b.xlsx 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 "o" is equivalent to being not applicable) Item: Ball bearings Order Policy: 500 units Lead Time: 1 week Quantity Week on Hand: 400 1 2 3 4 5 6 7 8 9 10 Forecast 550 300 350 400 350 350 150 300 450 400 Customer orders 300 350 250 300 250 200 50 150 50 100 (booked) Projected on-hand inventory I MPS quantity 500 I E MPS start .docx O DO eria nload Te Available-to- promise (ATP) inventory b. Four customer orders arrived in the following sequence: Order Quantity Week Desired 29 Ethi 9863 a Gle 2 Enter your answer in each of the answer boxes. s.xlsx MPS Start Available-to- promise (ATP) inventory D.xlsx b. Four customer orders arrived in the following sequence: Order 1 2 3 .docx Quantity Week Desired 500 4 300 5 300 1 300 7 Assume that you commit to the orders in the sequence of arrival and cannot change the desired shipping dates or your MPS. Which orders should you accept? 4 Order number 1 aria nload Term Order number 2 be accepted be accepted be accepted. be accepted Order number 3 Order number 4 29 Ethic 9863 a Glo Enter your answer in each of the answer boxes, W