I need a solution please

9. Figure 16.31 shows a partially completed MPS record for ball bearings. a. Develop the MPS for ball bearings. b. Four customer orders arrived in the following sequence: Order Quantity Week Desired 1 500 4 400 5 N 3 300 1 4 300 7 Assume that you must commit to the orders in the se- quence of arrival and cannot change the desired shipping dates or your MPS. Which orders should you accept? Item: Ball bearings Order Policy: 500 units Lead Time: 1 week Week Quantity on Hand: 400 1 2 3 4 5 6 7 8 9 10 Forecast 550 300 400 450 300 350 200 300 450 400 Customer orders (booked) 300 350 250 250 200 150 100 100 100 100 Projected on-hand inventory MPS quantity 500 MPS start Available-to- promise (ATP) inventory