2. Consider the following master production schedule (MPS), product structure diagram, and inventory data: Master Production Schedule (Start): 1 3 Product A B 7 Week 4 5 95 2 125 6 150 70 8 130 80 Product Structure Diagram: B D(2) E(2) C(2) E(2 D/1 E(1) D(1 E(1) E(1 Inventory Data: Item Data Category D Lot-size rule L4L POQ (P=3) Lead time 3 weeks 2 weeks Scheduled receipts 200 (week 2) None On-hand inventory 85 625 (a) Determine the low-level codes for item C, D, and E. E FOQ - 800 1 week 800 (week 1) 350 (1 marks) (b) Construct the Material Requirements Plan (MRP) for the next 8 weeks for item D, E and F by using the MRP tables provided. (3 marks) Lot Size: Lead Time: 5 6 1 2 3 4 7 8 Item: Description: Week Gross requirements Scheduled receipts Projected on hand Planned receipts Planned order releases Lot Size: Lead Time: 5 6 1 2 3 4 7 8 Item: D Description: Week Gross requirements Scheduled receipts Projected on hand Planned receipts Planned order releases Lot Size: Lead Time: 5 1 2 3 4 7 8 Item: E Description: Week Gross requirements Scheduled receipts Projected on hand Planned receipts Planned order releases C) Summarize the results from Material Requirements Plan (MRP) in a planned order report. (1 marks) Planned order report: Week Item 1 2 3 4 8 D E 6