Question

In: Operations Management

I need this answered not using excel Given the following data, construct a material requirements plan...

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

Solutions

Expert Solution

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 Solutions

I 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
ADVERTISEMENT