1. (50 points) MRP: Resource Planning (20 Points): The following information is available for three MPS items! Product A An 80-unit order is to be started in week 3 and a 55-unit order started in week 6. Product B A 125-unit order is to be started in week 5. Product C A 60-unit order is to be started in week 4. Note: MPS start quantities are the same as Planned Order Releases for end-products A, B, and C. Gross Requirements for D, E, F combines the corresponding requirements based on MPS starts for A, B, and C. a. (42 points) Develop the material requirements plan for the next 6 weeks for items D, E, and F by filling the appropriate MRP tables (the planned order releases POR row is the main row of interest, followed by the projected ending-inventory POHEI row: you do not need to enter other rows if they are not essential). Remember to enter any action or exception notices at the end of the MRP tables and also answer part 1.b at the end. Action or exception notices are those that require an action in week 1 and could involve order releases, expediting past due orders, or changing the timing of scheduled receipts. Note: A safety stock requirement applies to item F. Be sure to plan a receipt for any week in which the projected on-hand inventory becomes less than the safety stock. The BOMs are shown in the Figure below, and data from the inventory records are shown in the Table below. BOM Figure (numbers in brackets are item usage quantities to make each immediate parent item): (1 DI E2 D12 LE2 F2 E 0 100 0 0 30 Inventory Records Table: Item Lot Size Lead Scheduled On- Safety Technique Time Receipts Hand Stock D FOQ - 150 3 weeks 150 (week 3) 150 L4L 1 week 120 (week 2) F FOP, P-2 2 weeks None L4L - Lot-for-Lot; FOQ - Fixed Order Quantity: FOP - Fixed Order Period or Fixed Order Interval Acronym Key: GR - Gross Requirements: SR - Scheduled Receipts, POHEI - Projected On Hand End-of-period Inventory, NR - Net Requirements, PR - Planned Receipts, POR - Planned Order Releases MRP Explosion Tables for answering MRP question (feel free to edit Word doc or use Excel) Lot-sizing: Lead-Time: : Safety Stock Item Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 GR SR POHEI NR PR POR