Model A Item C (4) Component E (2) Raw Material F (2) Subassembly D (1) Item C (2) Item I (1) Item J (1) Item K (1) Raw Material O (2) Model B Item C (2) Raw Material F (1) Module H (1) Subassembly G (1) Item I (1) Item L (1) Component M (1) Raw Material O (1) Raw Material P (1) Component N (1) Raw Material Q (1) Raw Material R (1) Item Lead Time (weeks) 1 Order Quantity () Scheduled Receipts On-hand (Beginning) Inventory 270 40 1 1 180 (WK 1) D 2500 180 L4L 350 5 3 2 3 1 0 0 10 0 265 (WK 1) 120 (WK 1) E J K F G H L L4L 350 L4L 100 L4L 15 20 20 0 80 (WK 2) 2 2 1 2 2 1 1 1 80 (WK 2) 100 (WK 2) 0 M N zo | L4L 200 L4L 100 250 100 0 160 35 120 (WK 1) 2 1 240 100 R The MPS calls for 120 units of Model A to be started in week 5, 90 units in week 6, and 75 in week 7. The MPS for Model B calls for 100 units to be started in week 4, 80 units in week 6, and 110 in week 7. Use the low level coded bills of materials (product structure tree) to find the necessary planned order releases for all components. . You are required to submit the product structure diagram for Products A and B. You are required to submit the MRP record for all component parts in the Excel file. You are required to submit a completed PLANNED ORDER RELEASE FORM below . PLANNED ORDER RELEASE FORM Fill in the planned order releases for all components. Week 3 1 2 4 5 6 Item | D J F G H L M N o Q R 1 2 3 4 5 6 7 8 9 10 End Item MPS PLAN. ORDER RECEIPT MPS PLAN. ORDER RELEASE component A GROSS REQUIREMENTS: SCHEDULED RECEIPTS PROJECTED ON HAND NET REQUIREMENTS PLAN. ORDER RECEIPT PLAN. ORDER RELEASES component C GROSS REQUIREMENTS: SCHEDULED RECEIPTS PROJECTED ON HAND NET REQUIREMENTS PLAN. ORDER RECEIPT PLAN. ORDER RELEASES