answer question 4 please

Questions: (Latest updated 12 April 2021) Company LN produces an end product 'W' for the market. One unit of 'W is made by assembling 2 units of K, 3 units of L and 4 units of M. One unit of K is made of 2 units of G and 3 units of H; one unit of L is assembled using 2 units of M and 2 units of N. Current on-hand inventories for L and M are 400 units and 1000 units, respectively. Scheduled receipts are 350 units for L at the beginning of week 1 and 450 units for Mat the beginning of week 2.- Lead times for Kand L are one week, and lead times for other components are two weeks. The final assembly time for 'W' is one week- 1. Fill in Table 1 to prepare a master production schedule for the end product 'W' using a fixed lot size of 200 units. The beginning inventory for 'W' is 150 units, the forecast and committed customer orders for 'W' are provided in this table. [4 marks] Weeke 2 32 52 be 7e 82 102 Forecaste 802 802 802 80 100 100 1000 1002 Committed Customer orderse 654 352 30- 202 0 Projected On-hand Ending 702 1902 1102 302 1302 30e 130e 302 Inventorye Net Inventory Before MPS 702 -102 1102 302 |-702 30e 702 302 MPS Receipte 2002 02 02 2002 0 2002 0 MPS Starte 2002 02 be 2002 02 2002 02 102 190 1352 180e 2002 Available-To-Promise Inventory (Uncommitted) 4. Use your master production schedule in Table 1 and your MRP schedule for the subassembly L to develop a material requirement plan (MRP) for component M using the fixed-period-of-two ordering policy. (4 marks] Week 1 2 3 4 5 6 7 8 M Lead Time = 2 weeks; On-hand inventory = 1000 units; Scheduled Receipt in Week 2 = 450 Units Gross Requirement Scheduled Receipts Projected on Hand Ending Inventory Net Requirement PO Receipts PO Releases