Please Help!!

Consider the MPS, BOMs, and IMFs below. Complete the MPS below and MRP explosions on next page, identifying what actions, if any, you would take. HINT: You just need to fill in the yellow shaded rows. Complete the MPS (2 points): 6 7 10 Master Production Schedule (MPS) Weeks 2 3 4 5 Customer Reg A 5 8 Item A POR Customer Reg B Item B POR Lead time for product A is 1 week Lead time for product B is 2 weeks 10 Bill of Materials (BOM) D F (2) E (2) F (2) Item Master File (IMF) Item C D | E LFL LFL FOQ (25) | F POQ (P=2) 3 Lot Sizing Rule Lead Time (weeks) Beginning (OH) Inventory Scheduled Receipts (SR) 19 3 8 in week 1 None 25 in week 1 7 in week 1 Complete the MRP Explosions (4 points each): 4 | 5 | 6 | 7 | 8 Item C (LFL, LT=3 weeks) Week | 1 | 2 | 3 | Gross Requirements Scheduled Receipts 18 On Hand Planned Receipts Planned Order Releases 4 5 6 7 8 Item D (LFL, LT=1 week) Week 1 2 3 Gross Requirements Scheduled Receipts On Hand 8 Planned Receipts Planned Order Releases | 5 | 6 7 8 Item E (FOQ=25, LT=3 weeks Week 1 | 2 | 3 | 4 Gross Requirements Scheduled Receipts 25 On Hand 19 Planned Receipts Planned Order Releases 5 | 6 | 7 | 8 Item F (POQ=2 weeks, LT=1 week) Week 1 | 2 | 3 | 4 Gross Requirements Scheduled Receipts On Hand Planned Receipts Planned Order Releases