i have solved the first table but would like to know how to solve second table with data I have

Week Inventory From Previous Wk. Requirements Net Inventories Before MPS (60) MPS Projected On-Hand Inventory WN TILL 00 O April 35 5 May 6 / 7 2020 Forecast Customer Orders Projected on-hand inventory MPS 12 2. (20 points) A company that makes industrial pumps wants to prepare a master production schedule for April and May. Marketing has forecasted demand of 100 pumps for April and 80 pumps for May. These have been evenly distributed over the four weeks in each month: 25 per week in April and 20 per week in May, as illustrated below. April May 35 1 2 3 4 5 7 8 Forecast 25 2020 20 Customer Orders 36 4 9 1 2 Projected on-hand inventory MPS ATP 6 26 19 There are currently 35 pumps in inventory (i.e., beginning inventory is 35 pumps), and that there are customer orders that have been committed (booked) and must be filled as shown in the table above. Use the MPS rule of scheduling production when the projected on-hand inventory would be negative without production and use a lot size of 100. Week Inventory From Previous Wk. Requirements Net Inventories Before MPS (60) MPS Projected On-Hand Inventory WN TILL 00 O April 35 5 May 6 / 7 2020 Forecast Customer Orders Projected on-hand inventory MPS 12 2. (20 points) A company that makes industrial pumps wants to prepare a master production schedule for April and May. Marketing has forecasted demand of 100 pumps for April and 80 pumps for May. These have been evenly distributed over the four weeks in each month: 25 per week in April and 20 per week in May, as illustrated below. April May 35 1 2 3 4 5 7 8 Forecast 25 2020 20 Customer Orders 36 4 9 1 2 Projected on-hand inventory MPS ATP 6 26 19 There are currently 35 pumps in inventory (i.e., beginning inventory is 35 pumps), and that there are customer orders that have been committed (booked) and must be filled as shown in the table above. Use the MPS rule of scheduling production when the projected on-hand inventory would be negative without production and use a lot size of 100