Based on product structure tree and information given, complete all the MRP tables as follows and the cost if the ordering cost is $4000 and the carrying cost is $1.50 per unit. MRP Record Lead Time 1 week Safety Stock-50 Lot Size Lot-4-Lot Gross Requirements Scheduled Receipts Available Inventory Net Requirements Planned Order Receipts Planned Order Releases Kos (Cost): D (2) 1) Jadual MRP dengan lot saiz: Lot-4-Lot. MRP table with lot sizing: Lot-4-Lot. 150 B(1) E (1) Week 21 200 F (4) Week 22 150 20 A Week 23 270 C (2) D (1) Part Name: Week 24 110 10 F (1) (3 Markah/Marks) Week 25 190 Week 26 210 50 Week 27 200 2) Jadual MRP dengan lot saiz: MIN 150. MRP table with lot sizing: MIN 150. MRP Record Lead Time 1 week Safety Stock-0 Lot Size MIN 150 Gross Requirements Scheduled Receipts Available Inventory 150 Net Requirements Planned Order Receipts Planned Order Releases Kos (Cost): MRP Record Lead Time-1 week Safety Stock-50 Lot Size MULT 50 Gross Requirements Scheduled Receipts Available Inventory Net Requirements Planned Order Receipts Planned Order Releases 3) Jadual MRP dengan lot saiz: MULT 50. MRP table with lot sizing: MULT 50. Kos (Cost): Week 21 150 Week 22 Week 21 50 Week 22 60 Week 23 Week 23 20 Part Name: Week 24 60 Part Name: Week 24 80 (3 Markah/Marks) Week 25 Week 25 Week 26 100 160 (3 Markah/Marks) Week 26 Week 27 50 Week 27 4) Jadual MRP dengan lot saiz: POQ 3. MRP table with lot sizing: POQ 3. MRP Record Lead Time 1 week Safety Stock-0 Lot Size POQ 3 Gross Requirements Scheduled Receipts Available Inventory Net Requirements Planned Order Receipts Planned Order Releases Kos (Cost): MRP Record Lead Time 1 week Safety Stock 50 Lot Size-FOQ 300 Gross Requirements Scheduled Receipts Available Inventory Net Requirements Planned Order Receipts Planned Order Releases 150 5) Jadual MRP dengan lot saiz: FOQ 300. MRP table with lot sizing: FOQ 300. Kos (Cost): Week 21 100 500 Week 21 Week 22 50 Week 22 30 Week 23 400 Week 23 10 Part Name: Week 24 50 Part Name: Week 24 (3 Markah/Marks) Week 25 600 Week 26 200 20 (3 Markah/Marks) Week 25 Week 26 Week 27 Week 27 50 6) Jadual MRP dengan lot saiz: EOQ 500. MRP table with lot sizing: EOQ 500 MRP Record Lead Time 1 week Safety Stock-0 Lot Size = EOQ 500 Gross Requirements Scheduled Receipts Available Inventory 150 Net Requirements Planned Order Receipts Planned Order Releases Kos (Cost): Item A B D E F TOTAL Week 21 Week 21 50 Week 22 Week 2 400 Week 23 120 7) Berdasarkan semua jadual MRP di atas, lengkapkan laporan pesanan perancangan. Based on all above MRP tables, complete the planned order report Part Name: Week 24 100 Week 23 Week 24 (3 Markah/Marks) Week 25 Week 26 Week 27 700 Week 25 200 (1 Markah/Mark) Week 26 Week 27