please answer in excel

EEE INSTRUCTIONS: 1. Please provide all your answers in the excel template provided 2. Please include your name (first and last name) in the file. 3. Name your files in the following format: LASTNAME FIRSTNAME MRPHW 4. Please show all your work! You will NOT be given credit if you just write the answer 5. Graphs should be labeled appropriately. 1. Assume that you are the plant manager that assembles bicycles. The bill of material for the bicycle is given below. Using the bill of material and the lot sizing information, solve the following MRP problem. LEVEL Bicycle 0 Handlebar Wheels (2) Frame 1 Hub Spokes (501 2 From the Master Production Schedule, the gross requirements for bicycles are 30 units in poriod 2,30 units in poriod 5, and 40 units in period 8. The following table includos the lead times, lot sizes, available balances at the beginning of the planning period, and scheduled receipts from the prior planning period. SHOW YOUR WORK ON THE EXCEL SHEET Lead Available Scheduled Item Time Lot Size Balance Receipts Bicycle 1 L4L 20 None Handle bar 1 L4L 0 10 in period 1 Wheels 1 50 min 10 50 in period 1 Framo 2 15 multipla 20 Nono Hub 2 50 multiple 10 None Spokos 1 500 multipla 200 Nono What are the planned order releases for all items during the next 8 periods? TCL