Need help on this assignment!

MRP-2 MPS Assignment Fall 2021 - Saved to my Mic Mallings Review View Tell me MRP-2 MPS Assignment Fall 2021 20 points) Model A Item C(4) Component (2) Raw Material F (2) Subassembly D (D) Item C (2) Item 1 (1) Item (0) Item K(1) Raw Material (3) Model B fem (2) Raw Material F() Module HD Subassembly (1) Item 1 (0) Item L. (1) Component M () Raw Material (1) Raw Material P (1) Component N (1) Raw Material (1) Raw Material (1) MacBook Pro 888 000 235 FS 85 DU 98 $ el 7 8 Item Order Quantity (0) Scheduled Receipts Lead Time (weeks) 1 1 3 On-hand (Beginning) Inventory 270 40 180 (WK 1) 0 D E 2 3 265 (WK1) 120 (WK1) F G 1 2 2 Opo 23 ITm0-10 2500 180 L4L 350 5 L4L 350 L4L 100 L4L L4L 200 L4L 100 250 100 0 10 0 15 20 20 0 80 (WK 2) 1 2 2 1 1 80 (WK 2) 100 (WK 2) M N 120 (WK1) 0 0 160 35 240 100 P Q R 1 2 1 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 1 D E J K F G H L M N 0 doc R MRP-2 MPS Assignment Fall 2021 - Saved to my Mic Mallings Review View Tell me MRP-2 MPS Assignment Fall 2021 20 points) Model A Item C(4) Component (2) Raw Material F (2) Subassembly D (D) Item C (2) Item 1 (1) Item (0) Item K(1) Raw Material (3) Model B fem (2) Raw Material F() Module HD Subassembly (1) Item 1 (0) Item L. (1) Component M () Raw Material (1) Raw Material P (1) Component N (1) Raw Material (1) Raw Material (1) MacBook Pro 888 000 235 FS 85 DU 98 $ el 7 8 Item Order Quantity (0) Scheduled Receipts Lead Time (weeks) 1 1 3 On-hand (Beginning) Inventory 270 40 180 (WK 1) 0 D E 2 3 265 (WK1) 120 (WK1) F G 1 2 2 Opo 23 ITm0-10 2500 180 L4L 350 5 L4L 350 L4L 100 L4L L4L 200 L4L 100 250 100 0 10 0 15 20 20 0 80 (WK 2) 1 2 2 1 1 80 (WK 2) 100 (WK 2) M N 120 (WK1) 0 0 160 35 240 100 P Q R 1 2 1 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 1 D E J K F G H L M N 0 doc R