help

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. B2 C D3 E2 F3 E2 F2 1) Complete the MRP table with lot size: LOT FOR LOT (3 MARKS) MRP Record Part Name: A Lead Time = 1 week Safety Stock = 50 Lot Size = L4L Gross Requirements Week 11 Week 12 Week 13 Week 16 Week 17 Week 14 60 Week 15 120 80 100 80 100 90 Scheduled Receipts 40 20 40 60 Available Inventory 80 Net Requirements Planned Order Receipts Planned Order Releases Cost: 2) Complete the MRP table with lot size: MULT 50 (3 MARKS) 13 BJMP2033/A202 Part Name: B MRP Record Lead Time = 1 week Safety Stock = 70 Lot Size = MULT 25 Gross Requirements: Week 11 Week 12 Week 13 Week 14 Week 15 Week 16 Week 17 Scheduled Receipts 20 50 40 40 10 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 30 30 10 Available Inventory 80 Net Requirements Planned Order Receipts Planned Order Releases Cost: 4) Complete the MRP table with lot size: MIN 120 (3 MARKS) Part Name: D MRP Record Lead Time = 1 week Safety Stock = 60 Lot Size = MIN 120 Week 11 Week 12 Week 13 Week 14 Week 15 Week 16 Week 17 Gross Requirements Scheduled Receipts 80 100 50 70 Available Inventory 100 Net Requirements Planned Order Receipts Planned Order Releases Cost