PLEASE SHOW ALL WORK

Using the MPS record created in Q1 and shown below. As well as the Bill of Materials (BOM) shown below, complete the two MRP records by filling in the yellow cells. If the answer is zero (O), enter a 0 in the cell. SHOW YC MPS Record and Bill of Materials (BOM): Item: ABC ABC (1) Lot Sizing Rule: FOQ = 100 Lead time: 1 week Beginning Inventory: 80 Week 1 1 12 lo 3 4 14 15 Gross Requirements 25 D (1) LT=3 E (4) LT=2 16 17 18 10 11 12 25 25 25 30 30 30 30 35 35 35 35 35 Complete These Two MRP Records: Item: D 55 30 5 30 50 20 90 60 25 90 55 20 0 0 10000 1000 0 0 1000 Lot Sizing Rule: FOQ - 144 Projected On Hand (80) Planned Orders (MPS) Lead Time: 3 weeks Parent: ABC Beginning Inventory: 120 Week Gross Requirements Scheduled Receipts Projected On Hand (120) Planned Orders (MRP) Planned Order Releases (MRP Release Date) 1 2 3 4 5 6 7 8 9 10 11 12 OD 000000000000 NOUL INT Item: E Lot Sizing Rule: L4L Lead Time: 2 weeks Parent: ABC Beginning Inventory: 0 Week 123456789101112 000000000000 Gross Requirements Scheduled Receipts Projected On Hand (120) Planned Orders (MRP) Planned Order Releases (MRP Release Date) beri HU ON | |