Submit the following on Moodle (do not submit by email): 1. Your MS Word file (not the PDF file) - containing your answers. 2. One Excel file for your solutions. Consider product #1 with the following bill of material: Quantity Lead time Level 2 Part Number Level O Level 1 1 11 12 1 2 | 1 2 1 1 2 1 121 13 1 The following planning factors and inventory records are also given: 11 12 13 121 Part 1 Gross Requirements 50/week On Hand Inventory 0 Lot Size Lot-for-lot Safety Stock 10 Scheduled Receipts 63 in t=1 8 250 0 250 in t=1 60 100 10 100 in t=2 0 100 10 100 in t=1 40 200 20 a) Create the product structure diagram of this product. Then, use a spreadsheet to develop the MRP records for all the parts on the product structure for the next 6 weeks, and identify the planned order releases for all these parts. Submit the following on Moodle (do not submit by email): 1. Your MS Word file (not the PDF file) - containing your answers. 2. One Excel file for your solutions. Consider product #1 with the following bill of material: Quantity Lead time Level 2 Part Number Level O Level 1 1 11 12 1 2 | 1 2 1 1 2 1 121 13 1 The following planning factors and inventory records are also given: 11 12 13 121 Part 1 Gross Requirements 50/week On Hand Inventory 0 Lot Size Lot-for-lot Safety Stock 10 Scheduled Receipts 63 in t=1 8 250 0 250 in t=1 60 100 10 100 in t=2 0 100 10 100 in t=1 40 200 20 a) Create the product structure diagram of this product. Then, use a spreadsheet to develop the MRP records for all the parts on the product structure for the next 6 weeks, and identify the planned order releases for all these parts