In: Operations Management
I need this answered not using excel
Given the following data, construct a material requirements plan which will result in 100 units of parent #1 (P1), at the beginning of week 6 and 200 units of parent #2 (P2) at the beginning of week 8:
item | parent | quantity | on-hand | on order(due) | Lead Time | Order size |
P1 | - | - | - | - | 1 | Lot-for-Lot |
P2 | - | - | - | - | 1 | Lot-for-Lot |
A | P1, P2 | 1,2 | 70 | 0 | 1 | 500 |
B | P1, P2 | 2, 1 | 50 | 0 | 3 | 250 |
C | A, B | 3, 4 | 1000 | 2000 (wk2) | 2 | 2000 |
Item P1 Period | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |
Gross requirements | 0 | 0 | 0 | 0 | 0 | 100 | 0 | 0 |
Scheduled receipts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Projected on hand | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Net requirement | 0 | 0 | 0 | 0 | 0 | 100 | 0 | 0 |
Planned order receipt | 0 | 0 | 0 | 0 | 0 | 100 | 0 | 0 |
Planned order release | 0 | 0 | 0 | 0 | 100 | 0 | 0 | 0 |
Item P2 Period | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |
Gross requirements | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 200 |
Scheduled receipts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Projected on hand | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Net requirement | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 200 |
Planned order receipt | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 200 |
Planned order release | 0 | 0 | 0 | 0 | 0 | 0 | 200 | 0 |
Item A Period | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |
Gross requirements | 0 | 0 | 0 | 0 | 100 | 0 | 400 | 0 |
Scheduled receipts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Projected on hand | 70 | 70 | 70 | 70 | 470 | 470 | 70 | 70 |
Net requirement | 0 | 0 | 0 | 0 | 30 | 0 | 0 | 0 |
Planned order receipt | 0 | 0 | 0 | 0 | 500 | 0 | 0 | 0 |
Planned order release | 0 | 0 | 0 | 500 | 0 | 0 | 0 | 0 |
Item B Period | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |
Gross requirements | 0 | 0 | 0 | 0 | 200 | 0 | 200 | 0 |
Scheduled receipts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Projected on hand | 50 | 50 | 50 | 50 | 100 | 100 | 150 | 150 |
Net requirement | 0 | 0 | 0 | 0 | 150 | 0 | 100 | 0 |
Planned order receipt | 0 | 0 | 0 | 0 | 250 | 0 | 250 | 0 |
Planned order release | 0 | 250 | 0 | 250 | 0 | 0 | 0 | 0 |
Item C Period | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 8 |
Gross requirements | 0 | 1000 | 0 | 2500 | 0 | 0 | 0 | 0 | |
Scheduled receipts | 0 | 2000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Projected on hand 1000 |
Related SolutionsI will be grateful to be answered using excell You have to include the Excel formulas...I will be grateful to be answered using excell
You have to include the Excel formulas used.
In an evaluation of progress, made to 400 managers, the average
of the scores was 70 and its standard deviation was 8.0, what is
the probability that, if we select a manager at random (among the
400 that were evaluated ), did he get 70 or more?
Z
=
__________________________
1-Z
+
__________________________
Probability
=
__________________________ = ____________________%
Instructions: Using the following data, complete the requirements given below. When you are given amounts to...Instructions: Using the following data,
complete the requirements given below. When you are given amounts
to assume as the answers to previous requirements, be careful to
use such assumed amounts rather than your answers (in order to
minimize carry-through errors).
The Finishing Department of Curtis Corporation reports the
following for January 2011:
Production: All materials are added at the beginning of the
process. Beginning work in process 20,000 units, 60% complete.
Units started into production 240,000 units. Ending work in...
Proocess Costing Instructions: Using the following data, complete the requirements given below. When you are given...Proocess Costing
Instructions: Using the following data,
complete the requirements given below. When you are given amounts
to assume as the answers to previous requirements, be careful to
use such assumed amounts rather than your answers (in order to
minimize carry-through errors).
The Finishing Department of Curtis Corporation reports the
following for January 2011:
Production: All materials are added at the beginning of the
process. Beginning work in process 20,000 units, 60% complete.
Units started into production 240,000 units. Ending...
I need the following questions answered with an explanation. 1. Which of the following constitutes market...I need the following questions answered with an explanation.
1. Which of the following constitutes market failure? The
inability of markets to _____
a. internalize positive externalities
b. internalize negative externalities
c. Both a. and b.
d. None of the above
2. When is the burden of an excise tax incidence equally shared
between producers and
consumers?
a.The tax burden is always equally shared between producers and
consumers.
b. When the slope of the supply curve is steeper than the...
For the state of New Mexico and Colorado, I need the following questions answered please: a)...For the state of New Mexico and Colorado, I need the following
questions answered please:
a) To what extent does New Mexico and Colorado follow the
rulings of the Multistate Tax Commission?
b) Does New Mexico and Colorado adopt pertinent changes to the
Internal Revenue Code? If so, as of what date?
c) Is the tax effectiveness of a passive investment company
limited in some way? Has New Mexico and Colorado adopted the
Geoffrey approach to the taxation of income...
I need the following answered for an Operating Systems course Describe the order in which the...I need the following answered for an Operating Systems
course
Describe the order in which the elements of the A array are
accessed in the rows() and columns() functions. What is the main
difference?
Include the output of each run and show what the average
throughput is
Is there a difference in the throughput or time required to
execute “rows()” versus “columns()”? If there is a difference,
explain the cause of the difference
I need a care plan for COPD. In this care plan i need you guys to...I need a care plan for COPD. In this care plan i need you guys
to include nursing diagnosis for COPD. Then 6 short term and 6 long
term goals for COPD. I need one nursing intervention for each each
short term and each long term goal. And the evaluation for each
nursing intervention.
Please give me something creative
THANK YOU!
I need step by step instructions on using Excel to do this assignment and the values...I need step by step instructions on using Excel to do this
assignment and the values I need to enter to compute what is being
asked of me. I don't know how to use Excel and you tube is no help
right now because I can't find specifics of what I need done. I'll
post part two of this assignment as a seperate question. I need to
get through part one first. Thanks...
1. Exercise 11 Section 3-1
11. Weight...
Using Excel to Construct event dummy (or binary) variables to represent three international events : (i)...Using Excel to Construct event dummy (or binary) variables to
represent three international events :
(i) The Asian financial crisis – one from Aug 1997 to Jul 1998,
zero otherwise.
(ii) The Global Financial Crisis (GFC) – one from Feb 2007 to
Feb 2009, zero otherwise.
(iii) Covid-19– one from Jan 2020 to Mar 2020, zero
otherwise.
I please need assistance with the following question " of this question partially answered: Question: Digital...I please need assistance with the following question " of this
question partially answered:
Question: Digital Solutions, Inc., manufactures two
component parts for the television industry: Voltag...
What price should Digital Solutions charge for the New Voltage
Regulator, and what next steps should Digital Solutions take
regarding the New Voltage Regulator?
7) Provide a recommendation given the case facts and your
analysis.
8) Pay attention to detail within your answers in terms of
spelling, grammar, and formatting.
see the...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
ADVERTISEMENT
|