3. The MPS planner at Murphy Motors uses MPS time-phased records for planning end-item production.

The planner is currently working on a schedule for the P24, one of Murphy’s top-selling motors. The planner uses a production lot size of 70 and a safety stock of 5 for the P24 motor.

On Week Item: P24 hand 1 2 3 4 5 6 7 8 Forecast 30 30 30 40 40 40 45 45 Orders 13 8 4 Projected available balance 20 Available-to-promise MPS

a. Complete the MPS time-phased record for product P24.

b. Can Murphy accept the following orders? Update the MPS time-phased record for accepted orders.

Order Amount Desired Week 1 40 4 2 30 6 3 30 2 4 25 3