Solve and explain

Shown below is a partially completed MPS record for hand drills. a. Develop the MPS record for the hand drills. (Enter your responses as integers. A response of "O" is equivalent to being not applicable.) Item: Hand drills Order Policy: 60 units Lead Time: 1 week Week 1 2 3 4 6 5 55 15 40 15 20 35 Quantity on Hand: 30 Forecast Customer orders (booked) Projected on-hand inventory MPS quantity 20 25 10 15 0 0 10 30 15 55 0 25 0 60 0 60 0 60 MPS start 60 0 60 0 60 0 Available-to- promise (ATP) inventory 0 45 0 60