Please provide step by step instructions with Excel so that I am able to follow along. Thanks!

Item A Week: | 1 | | | | | 2 250 3 300 4 300 5 300 6 200 MPS due date LT (weeks): 0 Start assembly 250 300 300 300 200 The above figure shows the bill of material (BOM) for the Acme PolyBob (A), a product that has proven unsuccessful in capturing roadrunners. Complete the following MRP records for components B, C, E, and F. All the information you need is shown in the BOM and on the MRP records. Item B: Lead time = 1 weeks; Minimum order quantity = 1 250 300 300 300 200 Week Gross requirements Scheduled receipts Projected ending inventory: 0 Net requirements Planned order receipts Planned order releases Item C: Lead time = 3 weeks; Minimum order quantity = 500 Week 1 2 3 Gross requirements Scheduled receipts 500 600 Projected ending inventory: 0 Net requirements Planned order receipts Planned order releases 4 5 6 Item E: Lead time = 4 weeks; Minimum order quantity = 5,000 Week 1 2 3 Gross requirements Scheduled receipts Projected ending inventory: 5,750 Net requirements Planned order receipts Planned order releases Item F: Lead time = 5 weeks: Minimum order quantity = 750 Week Gross requirements Scheduled receipts Projected ending inventory: 4,750 Net requirements Planned order receipts Planned order releases