A. Based on the MRP diagram below, complete the MRP tables based on the given lot sizing together with costs. Given the ordering cost and holding cost are $2300 per order and $1.25 per unit. B2 C D2 D 1) Complete the MRP table with lot size: POQ2 (3 MARKS) MRP Record Part Name: A Lead Time = 1 week Safety Stock = 50 Lot Size = POQ2 Gross Requirements Week 11 Week 12 Week 14 Week 16 Week 17 Week 13 40 Week 15 40 50 100 10 70 20 Scheduled Receipts 20 20 10 20 Available Inventory 80 Net Requirements Planned Order Receipts Planned Order Releases Cost: 2) Complete the MRP table with lot size: MULT 50 (3 MARKS) MRP Record Part Name: B Lead Time = 1 week Safety Stock = 50 Lot Size = MULT50 Week 11 Week 12 Week 13 Week 14 Week 15 Week 16 Week 17 Gross Requirements Scheduled Receipts 50 20 10 Available Inventory 80 Net Requirements Planned Order Receipts Planned Order Releases Cost: 3) Complete the MRP table with lot size: MIN 60 (3 MARKS) MRP Record Part Name: C Lead Time = 1 week Safety Stock = 50 Lot Size = MIN60 Week 11 Week 12 Week 13 Week 14 Week 15 Week 16 Week 17 Gross Requirements Scheduled Receipts 20 40 60 20 Available Inventory 80 Net Requirements Planned Order Receipts Planned Order Releases Cost: 4) Complete the MRP table with lot size: LOT4LOT (3 MARKS) MRP Record Part Name: D Lead Time = 1 week Safety Stock = 50 Lot Size = LOT4LOT Week 11 Week 12 Week 13 Week 14 Week 15 Week 16 Week 17 Gross Requirements Scheduled Receipts 50 20 10 Available Inventory 80 Net Requirements Planned Order Receipts Planned Order Releases Cost