Please answer questions clearly and precisely. Only experts should answer.

Solve in excel so that I can copy it easily. Do not copy-paste answers avialable on the internet. Please read it thoroughly.

PART 2 [45 pts QUESTION-2.1: The BOM for product A is shown in the following figure. The MPS for product A calls for 120 units to be started in weeks 2, 4, 5, and 8. Table shows data from the inventory records. a) Develop the material requirements plan for the next 8 weeks for each item. b) What specific managerial actions are required in week 1? Make sure you address any specific difficulties you encounter in the inventory records. E (2) D (3) C (2) F (1) G (2) E (1) F (1) G (2) Figure. BOM for product A Table. Inventory Record Data ITEM Data Category C D E F G Lot-sizing rule L4L FOQ = 700 FOO = 700 L4L L4L Lead time 3 weeks 3 weeks 4 weeks 2 weeks 1 week Safety stock 0 0 0 50 0 Scheduled receipts 150 (week 2) 450 (week 2) 700 (week 1) None 1,400 /week 1) Beginning inventory 125 0 235 750 0 4/4