Item A Forecasted Demand Booked Orders Projected Inventory MPS On Hand The following data pertains to...

Transcribed Image Text:

Item A Forecasted Demand Booked Orders Projected Inventory MPS On Hand The following data pertains to AH Company in regards to MPS. Develop a six-week Master Production Schedule for the end products (A, B, C, D, E), using the information provided below. What are your conclusions from the exercise? Please note that you know On Hand and MPS. All you need to find is the projected inventory at the end of the week. Week 3 Week 4 Item B Forecasted Demand Booked Orders Projected Inventory MPS On Hand Item C Forecasted Demand Booked Orders Projected Inventory MPS On Hand Item D Forecasted Demand Booked Orders Projected Inventory MPS On Hand Item E Forecasted Demand Booked Orders Projected Inventory MPS On Hand 71 49 5 11. 32 60 50 Week 3 170 500 0 Week 3 Week 26 342 740 0 84 190 800 88 60 84 50 Week 4 170 150 Week 4 342 900 Week 3 Week 4 84 0 88 Week 5 42 60 100 Week 5 Week 6 170 Week 27 Week 28 300 Week 5 342 0 84 500 Week 5 88 Week 6 Week 6 84 60 170 0 300 342 900 Week 29 Week 6 84 Week 7 Week 8 0 Week 7 88 50 100 Week 7 84 150 300 296 Week 30 0 Week 8 73 600 50 100 Week B 76 150 84 300 296 Week 31 900 Week 7 Wee 73 0 76 1728 84 Item A Forecasted Demand Booked Orders Projected Inventory MPS On Hand The following data pertains to AH Company in regards to MPS. Develop a six-week Master Production Schedule for the end products (A, B, C, D, E), using the information provided below. What are your conclusions from the exercise? Please note that you know On Hand and MPS. All you need to find is the projected inventory at the end of the week. Week 3 Week 4 Item B Forecasted Demand Booked Orders Projected Inventory MPS On Hand Item C Forecasted Demand Booked Orders Projected Inventory MPS On Hand Item D Forecasted Demand Booked Orders Projected Inventory MPS On Hand Item E Forecasted Demand Booked Orders Projected Inventory MPS On Hand 71 49 5 11. 32 60 50 Week 3 170 500 0 Week 3 Week 26 342 740 0 84 190 800 88 60 84 50 Week 4 170 150 Week 4 342 900 Week 3 Week 4 84 0 88 Week 5 42 60 100 Week 5 Week 6 170 Week 27 Week 28 300 Week 5 342 0 84 500 Week 5 88 Week 6 Week 6 84 60 170 0 300 342 900 Week 29 Week 6 84 Week 7 Week 8 0 Week 7 88 50 100 Week 7 84 150 300 296 Week 30 0 Week 8 73 600 50 100 Week B 76 150 84 300 296 Week 31 900 Week 7 Wee 73 0 76 1728 84

Answer rating: 100% (QA)

ANSWER Projected ending inventory On ... View the full answer