Appendix 1 - MRP TABLES Item: LLC: Week Lot size: LT: Safety stock: Gross Requirements Scheduled Receipts On Hand Inventory Ner Requirements Planned Order Receipts Planned Order Releases LLC: Week LT: Item: Lot size: Safety stock: Gross Requirements Scheduled Receipts On Hand Inventory Net Requirements Planned Order Receipts Planned Order Releases Item: LLC: Week Lot size: LT: Safety stock: Gross Requirements Scheduled Receipts On Hand Inventory Net Requirements Planned Order Receipts Planned Order Releases Question 1 (5 marks) Consider the following master production schedule (MPS), product structure diagram, and inventory data: Master Production Schedule: Week 2 4 5 6 7 8 18 19 Product A 55 Product B 125 Product C 60 10 Product Structure Diagram: A B n E(1) E(2) E(2) D(2) F(2) D(1) D(1) F(2) D(2) F(2) Inventory Data: D FOQ (150) 3 Lof size Lead time (week) Safety stock Scheduled receipts Beginning inventory E L4L 1 10 120 (week 2) 0 F POO (P-2) 2 30 0 100 40 250 (week) 150 (a) Determine the low-level codes for each item. (b) Construct the Material Requirements Plan (MRP) for the next 8 weeks for item D, E and F by using the MRP tables provided in Appendix 1. (c) Summarize the results from Material Requirements Plan (MRP) in a planned order report