this question needs to be solved in excel sheet with all formulas mentioned.

Question # 1 Given the follow bill of materials tree and other data, construct the MRP records for parts A, B and C given the master production schedule below. In considering safety stocks, we require that on hand inventory never drop below the specified safety stock level. The demand provided in the table below is for Part A. Week Deman d 1 5 2 15 3 18 4 8 5 12 6 22 This table contains some extra information that needs to be factored into your MRP schedule!!!!!! Part A B C Lead time Safety Stock 1 2 1 Order On hand Quantity Inventory Expected Receipts 0 20 21 0 0 40 20 32 units, period 1 10 Lot for Lot 50 0