1. 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. Item A Forecasted Demand Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 60 60 60 60 50 50 Booked Orders Projected Inventory MPS 50 50 80 100 0 100 100 On Hand 71 Item B Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Forecasted Demand 170 170 170 170 150 150 Booked Orders 500 Projected Inventory MPS 0 150 300 300 300 300 On Hand 49 Item C Forecasted Demand Booked Orders Projected Inventory MPS On Hand Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 342 342 342 342 296 296 740 0 900 0 900 0 900 5 Item D Forecasted Demand Week 26 Week Week Week 27 Week 28 Week 29 30 31 Booked Orders 84 84 84 190 84 73 73 Projected Inventory MPS 800 0 500 0 600 On Hand 11 Item E Forecasted Demand Booked Orders Projected Inventory MPS On Hand Week 3 Week 4 Week 5 Week 6 Week 7 Wee 88 88 88 88 76 76 1728 84 42 84 84 84 84 32