Problem 1: Prepare a Master Schedule given the following information: - The forecast for each week for an eight-week schedule is 75 units. - The Master Production Schedule (MPS) rule is to schedule production if the projected on-hand inventory would be negative without it. - Committed customer orders are as follows: Use a production lot size of 100 units and no beginning inventory. Formulas for Projected On-Hand Inventory Week 1 = Beginning Inventory + MPS - MAX (Forecast:Customer Order) 1 Highest number Weeks 28 = Previous Week Inventory + MPS - (Forecast: Customer Order) Because the problem says we cannot have any negative inventory, then we require MPS shipments to come in. When a shipment comes in, it is in lots of 100 . In this problem. MPS will be added for Weeks 1,2,3, and Weeks 5, 6, 7. No MPS shipments are expected in Week 4 or Week 8 . Problem 2: Given the following Master Schedule: 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 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)