Hello, I originally tried to complete this on my excel spread sheet. I emailed my professor and he told me that the 95 on the top of period 7 is incorrect, can this be readjusted. The number should be zero for gross requirements in bicycles for period 7. I just need that to be readjusted for the rest of the columns. Please just fix this and I will attach the instructions I was provided.

\fMRP HW 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 Handle bar Wheels (2) Frame 1 Hub Spokes (50) 2 From the Master Production Schedule, the gross requirements for bicycles are 30 units in period 2, 30 units in period 5, and 40 units in period 8. The following table includes 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. Item Lead Available Time Lot Size Scheduled 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 Frame 2 15 multiple 20 None Hub 2 50 multiple 10 None Spokes 1 500 multiple | 200 None What are the planned order releases for all items during the next 8 periods