please show work

Shown below is a partially completed MPS record for ball bearings. a. Develop the MPS for ball bearings. (Enter your responses as integers. A response of "0" is equivalent to being not applicable.) Item: Ball bearings Order Policy: 500 units Lead Time: 1 week Week 5 6 7 Quantity on Hand: 400 1 2 3 4 8 9 10 550 300 350 400 350 300 200 250 450 350 300 350 250 250 150 200 50 50 100 150 Forecast Customer orders (booked) Projected on-hand inventory MPS quantity 350 0 150 250 400 100 400 150 200 350 500 0 500 500 500 0 500 0 500 500 MPS start 0 500 500 500 0 500 0 500 500 0 Available-to- promise (ATP) inventory 1