please give solution to question 14. Chapter 6. thr abc company is run weekly.

CM20004 Waterial Requirements Planning 14. The MPC system at ABC Manufacturing Company is run weekly to update the master produs tion schedule (MPS) and MRP records. At the start of week 1, the MPS for end products X and Y is: Master Production Schedule 1 3 2 4 5 Week Number 6 10 25 5 Product X 10 5 Product Y 30 20 20 One unit of component C is required to manufacture one unit of either end product X or Y. Pur- chasing lead time for component C is two weeks, an order quantity of 40 units is used, and no (zero) safety stock is maintained for this item. Inventory balance for component C is 5 units at the start of week 1, and there's an open order (scheduled receipt) for 40 units due to be delivered at the beginning of week 1. a. Complete the MRP record for component C as it would appear at the beginning of week 1: Week 1 2 3 5 6 Gross requirements Scheduled receipts Projected available balance Planned order releases 4 5 6 b. During week 1, the following transactions occurred for component C: 1. The open order for 40 units due to be received at the start of week I was received on Monday 2. An inventory cycle count during week 1 revealed that five units of component were missing. Thus, an inventory adjustment of an of week 1 with a quantity of 30 (10 units of component Cwere scrapped on this order) CM20004 Waterial Requirements Planning 14. The MPC system at ABC Manufacturing Company is run weekly to update the master produs tion schedule (MPS) and MRP records. At the start of week 1, the MPS for end products X and Y is: Master Production Schedule 1 3 2 4 5 Week Number 6 10 25 5 Product X 10 5 Product Y 30 20 20 One unit of component C is required to manufacture one unit of either end product X or Y. Pur- chasing lead time for component C is two weeks, an order quantity of 40 units is used, and no (zero) safety stock is maintained for this item. Inventory balance for component C is 5 units at the start of week 1, and there's an open order (scheduled receipt) for 40 units due to be delivered at the beginning of week 1. a. Complete the MRP record for component C as it would appear at the beginning of week 1: Week 1 2 3 5 6 Gross requirements Scheduled receipts Projected available balance Planned order releases 4 5 6 b. During week 1, the following transactions occurred for component C: 1. The open order for 40 units due to be received at the start of week I was received on Monday 2. An inventory cycle count during week 1 revealed that five units of component were missing. Thus, an inventory adjustment of an of week 1 with a quantity of 30 (10 units of component Cwere scrapped on this order)