Please show the excel solutions using the exact grids supplied in the images..

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. All the information you need is shown in the BOM and on the MRP records (Excel File). A B *2 required E F D E F *3 required *2 required A B D E F F. G H 1 J K L Week: 1 0 MPS due date Start assembly 2 250 0 3 300 0 4 300 0 5 300 0 6 200 0 0 NOON OO Week: 1 0 2 250 0 3 300 0 4 300 0 5 300 0 6 200 0 0 2 Acme PolyBob 3 4 LT (Weeks): 0 5 6 Item B 7 # Required: 1 8 LT (weeks): 1 9 10 11 Min. order: 1 12 13 14 Item C 15 # Required: 2 16 LT (weeks): 3 0 Gross requirements Scheduled receipts Projected ending inventory: Net requirements Planned receipts Planned orders 0 Week: 1 2 3 4 5 6 500 600 0 17 18 Gross requirements Scheduled receipts Projected ending inventory: Net requirements Planned receipts Planned orders 19 Min. order: 500 20 Week: 1 2 3 4 5 LO 6 1 1 400 100 Gross requirements Scheduled receipts Projected ending inventory: Net requirements Planned receipts Planned orders 1000 Week: 1 2 3 4 5 LO 6 4 4 21 22 Item D 23 # Required: 24 LT (weeks): 25 26 27 Min. order: 28 29 30 Item E 31 # Required: 32 LT (weeks) 33 34 35 Min. order: 36 37 38 Item F 39 # Required: 40 LT (weeks): 41 42 43 Min. order: 44 5750 Gross requirements Scheduled receipts Projected ending inventory: Net requirements Planned receipts Planned orders 5000 Week: 1 2 3 4 5 5 6 3 5 4750 Gross requirements Scheduled receipts Projected ending inventory: Net requirements Planned receipts Planned orders 750