Using the information above:

As a material planner, what would you do today at the start of week 1? what about at the start of week 4?

Please show all work and explain thoroughly

Consider the following BOM, inventory data, and MPS, complete the MRP tables for these items. Bill of Materials B2 ci DI Om Order ITEM Lead Time On Hand Safety Stock Lot size B B D 2 1 3 100 150 50 0 0 0 L4L L4L 150 week 1 (L4L Master Production Schedule: The following table shows the required MPS quantities scheduled to begin the production of Product A and F. 4 8 9 10 Demand 1 20 12 30 3 10 15 10 6 7 40 20 Final Solution Class Problem Step 5: Work the MRP record for Level 2 (D) to find Planned Order Releases 3 8 1 2 5 5 6 7 9 10 MPS Demand A 120 30 10 10 40 20 Units Weeks Units 9 la 9 10 30 19 lo lo aleler Part No: B (Level 1) Lot Size: L4L Part Name: Lead Time: 2 Safety Stock Date 123 4567 8 Gross requirements 40 60 20 20 40 Scheduled receipts Planned order receipts 20 20 40 Available balance | 10060 0 0 0 0 0 Planned order releases 30 20 80 Part No: C (Level 2) Lot Size: L4L Part Name: Lead Time: 1 Each uses 2 C's Safety Stock: Date 1234567 8 Gross requirements 60 30 50 160 90 40 20 Scheduled receipts Planned order receipts 150 90 40 20 Available balance 150 90 60 100 0 0 0 Planned order releases 150 90 40 20 Units Weeks Units 10 lool lo Units Weeks Units 9 10 col 8 Part No: D (Level 2) Lot Size: LAL Part Name: Each Buses 1D Lead Time: 3 Safety Stock: Date 1 23456 7 Gross requirements 20 20 80 40 Scheduled receipts 150 Planned order receipts Available balance 50 180 180 160 80 40 Planned order releases