Problem 1: 1. Prepare a Master Schedule given the following information: The forecast for each week is 70 units. The starting inventory is Zero. The production lot size is 150 (MPS) for weeks 1, 3, and 5. Calculate the Projected on-hand inventory (POI) Calculate the Available to Promise (ATP) The following table shows the committed customer orders as follows: Week Customer order 1 80 50 60 2 3 4 65 5 60 6 70 Week Beginning inventory=0 1 2 3 4 5 6 Forecast Customer Orders Projected On-Hand Inventory MPS Formulas for Projected On-Hand Inventory Week 1 = Beginning Inventory + MPS MAX (Forecast: Customer Order) Highest number Weeks 2 6 = Previous Week Inventory + MPS (greater Forecast and Customer Order) Problem 2: . The forecast for each week is 30 units. . The starting inventory is 12. . The production lot size is 70 (MPS) when the projected on-hand inventory is negative. . Calculate the Projected on-hand inventory (POI) . Calculate the Available to Promise (ATP) Given the following Master Schedule: Week Customer order 34 2 29 3 28 4 35 5 32 6 33 35 8 35 Week Begining inventory= 12 1 2 3 4 5 6 7 8 Forecast Customer Orders Projected On-Hand Hand Inventory MPS ATP Note: The ATP quantities can be presented to the Marketing Department to promise customers the number of units to be manufactured by a specific date. Formula: Week 1 ATP = Beginning Inventory + MPS - Customer Order Week 2 ATP = MPS - Customer Order Week 3 ATP = MPS - (Wk3 + Wk4)