Troubleshoot the MRP problem provided below. You can use the Excel spreadsheet provided to enter the MRP results. I am including the printed PDF spreadsheet for those who do not have access to Excel and have to do it by hand. Once you finish the assignment, insert into the blanks provided in Assignment 5 in Moodle all the values corresponding to the MRP. All blanks must be filled with zeros. You must enter the data into Moodle on or before Monday, April 26, 2021 at 1:00 PM. I am including the printed PDF spreadsheet for those who do not have access to Excel and have to do it by hand. Problem 1. 1 Jose Perez, production manager for an exercise equipment manufacturer in San Sebastian, needs to schedule orders for UltimaSteppers, which will be shipped as set forth in the master plan. Develop the material requirements plan (MRP) for the Steppers and their components to meet the demand set forth in the master plan. Below is information about the steppers: Week Master Plan (MPS) Article Stepper 1 2 3 4 5 6 7 8 3. 100 200 400 5 6 Security inventory 5 Supply time Component Stepper A 7 Stocks (including safety inventory) 15 2 8 1 10 Orders pending to be received 30 (in the period 2) 30 (in the period 2) 25 (in the period 3) 150 (in the period 2) B 5 25 1 1 10 9 10 11 12 13 D 1 10 E 1 S 1 2 3 5 0 0 0 0 0 0 0 0 Stepper Gross Requirements Stocks Backorders Net Requirements Planned Receita Release of orders 0 0 0 OOOOOO 0 0 0 o lo ODIO DOOOO 0 ol 0 0 0 0 0 0 0 0 0 0 0 1 12 3 4 7 0 0 0 0 g 0 0 0 0 0 Stepper Gross Requirements Stocks Backorders Net Resuirements Planned Receipts Release of orders 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o 0 01 0 0 0 0 0 0 0 0 O 0 0 0 1 3 5 6 7 0 0 O ol 0 0 0 0 0 0 0 0 0 g 0 Stepper Gross Regurements Stocks Backorders Net Reguirements Panned Recepti Release of orders 0 0 0 0 0 0 0 0 o o 0 0 0 0 al 0 0 0 0 0 0 0 0 4 5 9 7 O D 0 0 0 o 0 D D D 0 0 0 0 0 O 0 Stepper Gross Requirements Stocks Backoeders Net purements Planned Recept Rebase of orders O ol 0 D 0 0 O D 0 0 D O D 0 D O 0 0 0 0 10 0 D D 0 0 0 0 0 O O o 0 O 2 15 6 0 O 0 0 D 0 D 0 D 0 Step GPS vamente Stocks Rackorders Net Requrements Poned Receipts Resor orders 0 0 0 O 0 O 0 0 0 0 0 0 7 0 0 0 0 0 0 D al 0 O D 0 0 0 0 0 0 0 0 ol 0 0 0 D D 0 0 D 1 2 5 7 0 0 0 0 O 0 0 0 0 D o 0 D 0 0 Stepper Gross Reuvements Stocks Backorders Net Requirements Planned Receipts Release of orders 0 0 O 0 0 10 O 0 0 D 0 0 0 0 0 0 blo 0 0 ololo 0 0 O 0 0 O D ol 0 ol 01 0 O 0 0