MPS problem 5 Using the MPS/ATP worksheets provided, do the following. Safety stock=10 Order quantity=50 There is a MPS of 50 scheduled in weck 2. Demand time fence two weeks: no changes to MPS can be made within the first two weeks; the projected available balance (PAB) only subtracts actual orders and NOT the forecast. Outside of the demand time fence, use the PAB convention of subtracting the GREATER of orders or forecast in a time period. a. Complete the MPS/ATP time phased record. The following orders are received in the order shown. Can they be accepted as requested? b. Order 2 3 4 Amount 30 35 30 8 Desired week 4 5 3 1 Enter each order one at a time to the MPS from part a. First, without changing the projected available line or the MPS line, update the orders and ATP numbers. After trying to do this, do you see any problems? What options might be considered to address these problems? c. Finally, with all the new orders entered as requested (whether or not you said to accept them in "b"), recalculate the projected available, MPS, and ATP