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 $800 per order and $1.50 per unit respectively. A B2 D3 E2 F3 E2 F2 1) Complete the MRP table with lot size: FOQ100 (3 MARKS) MRP Record Part Name: A Lead Time = 1 week Safety Stock = 50 Lot Size = FOQ100 Week 11 Week 12 Week 13 Week 14 Week 15 Week 16 Week 17 Gross Requirements 100 110 80 100 100 90 Scheduled Receipts 60 40 50 60 Available Inventory 80 Net Requirements Planned Order Receipts Planned Order Releases Cost: 2) Complete the MRP table with lot size: MULT 25 (3 MARKS) MRP Record Part Name: B Lead Time = 1 week Safety Stock = 70 Lot Size = MULT 25 Week 11 Week 12 Week 13 Week 14 Week 15 Week 16 Week 17 Gross Requirements Scheduled Receipts 30 50 40 70 20 Available Inventory 100 Net Requirements Planned Order Receipts Planned Order Releases Cost: 3) Complete the MRP table with lot size: POQ 2 (3 MARKS) MRP Record Part Name: C Lead Time = 1 week Safety Stock = 10 Lot Size = POQ 2 Week 11 Week 12 Week 13 Week 14 Week 15 Week 16 Week 17 Gross Requirements Scheduled Receipts 20 20 10 30 10 Available Inventory 80 Net Requirements Planned Order Receipts Planned Order Releases Cost: 4) Complete the MRP table with lot size: MIN 100 (3 MARKS) MRP Record Part Name: D Lead Time = 1 week Safety Stock = 60 Lot Size = MIN 100 Week 11 Week 12 Week 13 Week 14 Week 15 Week 16 Week 17 Gross Requirements Scheduled Receipts 80 50 70 Available Inventory 100 Net Requirements Planned Order Receipts Planned Order Releases Cost: 5) Complete the MRP table with lot size: Lot for lot (3 MARKS) MRP Record Part Name: E Lead Time = 1 week Safety Stock = 90 Lot Size = L4L Week 11 Week 12 Week 13 Week 14 Week 15 Week 16 Week 17 Gross Requirements Scheduled Receipts 220 200 190 230 260 Available Inventory 100 Net Requirements Planned Order Receipts Planned Order Releases Cost