Problem 2: Given the following Master Schedule: Week 1 2 75 75 75 53 3 4 75 75 26 18 5 75 0 IN 6 75 0 ou 7 8 7575 0 alo Forecast Customer Orders Projected On-Hand Hand Inventory MPS ATP - 25 100 25 50 100 47 75 100 74 0 0 0 25 100 100 50 100 100 75 100 100 0 0 0 Use production lot size of 100 units and no beginning inventory. Inventory is counted as physical inventory. Week 4 & Week 8 no MPS is planned, it stays 0. Determine the available to promise (ATP) quantities for each week. The ATP quantities can be presented to the Marketing Department to promise customers the number of units to be manufactured by a specific date Week 4 & Week 8 no MPS is planned, it stays 0. Formula: Week 1 ATP = Beginning Inventory + MPS - Customer Order Week 2 ATP = MPS Customer Order W In Week 3, we must add customer orders for Wk3 and Wk 4 because they are scheduled but Wk 4 no MPS is scheduled. So, our next MPS will not occur until Wk 5. The rule is to count scheduled orders until the next MPS This occurs again in Week 7 we add customer orders for Wk7 and Wk8 and subtract them from MPS Week 3 ATP = MPS - (Wk3+ Wk4)