The details are on the doc

OPER 3201-Operations Planning and Control Chapter 5 Assignment, Due Date: Monday, April 1, 2024 by 11:59 pm Please upload your homework on Canvas in a single file. 1. John Dow has constructed the incomplete time-phased MPS record shown. Suppose John Dow prepares the product in batches of Q = 70 units. Safety stock is 15 units. On hand = 70. Assume no lead time. Complete the MPS schedule. (4 pts) Week 1 40 Forecast Projected available balance 70 MPS 2 15 3 40 4 50 5 40 6 60 7 10 2. The XYZ company has constructed the following incomplete record. On hand = 130. Assume no safety stock and no lead time. Complete the record for projected available balance and available-to-promise (ATP). (3 pts) Week Forecast Orders Projected available balance ATP (discrete logic) ATP (cumulative logic) MPS 1 40 36 2 40 40 3 40 45 4 40 50 100 Can the following additional orders arrive: Order Amount Desired Week 1 2 2 4 10 15 5 40 25 6 40 30 7 30 20 8 30 10 100 Can we accept the order? Can XYZ company accept the orders or not? (1pt) Update the MPS time-phased record for accepted orders. (2pts)