PRODUCTION PLANNING FOR SUPPLY CHAIN ASSIGNMENT 2-520 You are given the following for an item that your company manufactures: PRODUCTION PLANNING FOR SUPPLY CHAIN ASSIGNMENT 2-$20 NAME STUDENT# (1) Week On Hand 1 2 3 4 5 6 7 8 Week Forecast 36 1 2 3 4 5 6 7 8 9 60 72 84 96 84 72 60 36 (1) You meet with your production team the week prior to week 1: You plan on using a batch size of 72units, as you have in the past with a reorder point of 0. Your On Hand inventory is 30 units. Develop the MPS for weeks 1-9. What will be the issue with supplying the customer? Forecast Projected Avail. Inventory (2) To resolve the issue, a member of the production team suggests increasing the batch size to 144 and keeping the reorder point at 0. Develop the MPS with the revised batch size. (2) Forecast Projected Avail. Inventory www.MPS (3) In week 1 the actual demand is 48 units not the 36 forecast. Sales also revises the forecast as follows: Week Forecast 2 3 72 84 4 96 S 6 7 8 9 10 96 84 72 60 36 36 What is the on hand inventory at the start of week 2? Develop an MPS for weeks 2-10 (3) Forecast Projected Avail. Inventory MPS On Hand 1 2 3 4 Week 5 6 7 8 9 Week On Hand 2 3 S 6 7 9 10