QUESTION #2 a) Complete the MRP table based on lot sizing: POQ 2 (Periodic Order Quantity & Safety Stock = 50 Part Name: A MRP Record Lead Time = 2 week Safety Stock = 50 Lot Size = POQ 2 Gross Requirements Week 2 Week 3 Week 5 Week 6 Week 1 60 Week 4 120 Week 7 200 Week 8 100 50 40 80 80 Scheduled Receipts 100 50 50 100 Available inventory 100 Net Requirements Planned Order Receipts Planned Order Releases b) Complete the MRP table based on lot sizing: EOQ 150 (Economic Order Quantity) MRP Record Part Name: B Lead Time = 1 week Safety Stock = 0 Lot Size = EOQ 150 Gross Requirements Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 60 50 40 120 80 80 200 100 Scheduled Receipts 100 50 50 100 Available Inventory 100 Net Requirements Planned Order Receipts Planned Order Releases c) Complete the MRP table based on lot sizing; FOQ 130 (Fixed Order Quantity) MRP Record Part Name: C Lead Time = 1 week Safety Stock = 30 Lot Size = FOQ 130 Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Gross Requirements 60 50 40 120 80 80 200 100 Scheduled Receipts 100 50 50 100 Available Inventory 100 Net Requirements Planned Order Receipts Planned Order Releases