See attached file. If possible please explain, and use excel.

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 Demand 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