Acme PolyBob Week 1 0 MPS due date Start assembly 2 250 0 3 300 0 4 300 0 5 300 0 6 200 0 LT (weeks): 0 0 Week: 1 Item B # Required: LT (weeks): 2 250 4 300 5 300 6 200 The following figure shows the bill of material (BOM) for the Acme PolyBob, a product that has proven unsuccessful in capturing roadrunners. Complete the MRP records. 300 1 1 0 Gross requirements Scheduled receipts Projected ending inventory: Net requirements Planned receipts Planned orders Min. order: 1 Week: 1 2 3 4 5 6 Item C # Required: LT (weeks): A 2 3 500 600 0 Gross requirements Scheduled receipts Projected ending inventory: Net requirements Planned receipts Planned orders Min. order: 500 B *2 required Week: 1 2 3 4 5 6 Item D Required: LT (weeks): E F D E F 400 *3 required *2 required 100 1 Gross requirements 1 Scheduled receipts Projected ending inventory: Net requirements 1000 Planned receipts Planned orders Min. order: Please give an answer with Excel formulas Week: 1 2 3 4 5 6 Item E # Required: LT (weeks): a a 5750 4 Gross requirements 4 Scheduled receipts Projected ending inventory: Net requirements 5000 Planned receipts Planned orders Min. order: Week: 1 2 3 4 5 6 Item F # Required: LT (Weeks): 3 5 4750 Gross requirements Scheduled receipts Projected ending inventory: Net requirements Planned receipts Planned orders Min. order: 750