Using the MPS record created in Question 1 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. Remember, FOQ is Fixed Order Quantity and L4L is Lot for Lot. SHOW YOUR WORK! I need to see the MRP chart, and show how you got each number if you want partial credit. Otherwise, if a number is wrong it is wrong! MPS Record and Bill of Materials (BOM): Item: A Lot Sizing Rule: FOG - 100 Lead time: 1 week Beginning Inventory: 80 D(1) LT 3 weeks LT 2 weeks Week Gross Requirements 25 25 25 25 30 30 30 30 35 35 35 35 Projected On Hand Complete These Two MRP Records: 180) | 55 305 30 50 20 30 60 25 30 55 20 | Pierned Orders (MPS) 10 0 100 0 0 100 0 0 | 100 0 0 10 item: D Lot Sizing Rule: FOQ = 144 Lead Time: 3 weeks Parent: A 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 NOON 000000000000 L U N. LINN Item: E Lot Sizing Rule: L4L Lead Time: 2 weeks Parent: A Beginning Inventory: O Il Week 2 3 4 5 6 7 8 9 10 11 12 Gross Requirements Scheduled Receipts 000000000000 Projected On Hand (120 UUUUUUUUUUU Planned Orders (MRP)UUUUUUUUUUUU Planned Order Releases MRP Release Date)