construct the materials requirements plan for item B,C,E,F. all information is shown in the BOM and the MRP record. (please show work)

Home Insert Draw Page Layout Formulas Data Review View Help Share X 96 Conditional Formatting o LS Font Alignment Number Cells Editing Format as Table Cell Styles - Styles Analyze Data Clipboard 5 Anaiyaa Sens F G C Lead Time (weeks) = D E 1 Minimum order quntity 2 350 1 1 3 5 250 0 150 250 Item B: Week Gross requirements Scheduled receipts Projected ending inventory: 500 Net requirements Planned receipts Planned orders 500 1 Minimum order untity 2 200 0 200 450 350 450 200 4 Minimum order untity 3000 Item C Lead Time (weeks) 1 Week 2 Gross requirements 3 Scheduled receipts 4 Projected ending inventory: 500 500 15 Net requirements 16 Planned receipts 7 Planned orders 18 19 Item : Lead Time (weeks) 20 Week 21 Gross requirements 22 Scheduled receipts 23 Projected ending inventory: 2,250 2250 24 Net requirements 25 Planned receipts 26 Planned orders 27 28 Item: Lead Time (weeks) 29 Week 30 Gross requirements 31 Scheduled receipts 22projected ending inventory: 9,000 5000 33 Net requirements 34 planned receipts 35 Planned orders 2 Minimum order untity 2 5.250 1 erial (BOM) for the Acme PolyBob. ds. for item B (enter your responses as whole numbers). - X More Info A B * 2 required E F D E F 4 required - 2 required Print Done