please include the steps to the problem. Thank you.

List of formulas: Projected on-hand inventory at the end of this week - On-hand inventory at the end of last week + MPS quantity due at start of this week - Projected requirements this week ATP for the first week - Projected on-hand inventory at the end of last week + MPS quantity for the first week - The cumulative total number of customer orders booked up to (but not including) the week in which the next MPS quantity arrives. ATP for the 2nd, 3rd, ... weeks - MPS quantity - The Cumulative total number of customer orders booked up to (but not including) the week in which the next MPS quantity arrives . A company forecasted the following demand for one of its products for the next 4 weeks: 10, 45, 50, and 12. The booked customer orders for the product are 2, 10, 32, and 14 units from week 1 to week 4. The current on-hand inventory is 50 units. The order quantity is 60 units. The lead time is one week. The company wants to develop an MPS for the product. Round to the nearest whole number. Answer the following questions. Current on-hand inventory: 50 Order policy: 60 LT: 1 1 2 3 4 Forecast 10 45 50 12 Customer orders (booked) 2 10 32 14 Projected on-hand inventory MPS quantity MPS start ATP inventory D Question 1 4 pts What is the MPS quantity for week 2? O 20 O 40 O 60 Question 2 4 pts What is the MPS start quantity for week 1? 20 . 50 0.60 D Question 3 4 pts What is the projected on-hand inventory for week 1? OO O 40 60 Question 4 4 pts What is the available-to-promise inventory (ATP) for week 1? 48 65 o 70 Question 5 4p What is the projected on-hand inventory for week 3? O 5 O 45 55 Question 6 4 pts What is the projected on-hand inventory for week 2? OO 45 O 55