Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

SHOW WORK! sing the information in the following table, prepare a prospective MP

ID: 339841 • Letter: S

Question

SHOW WORK!

sing the information in the following table, prepare a prospective MPS and calculate the available-to- promise (ATP) quantities on the table below. The order policy is to produce in lots of 100. Show all your calculations on the paper to receive full or partial credis. Week 4 5 6 7 8 3 Quantity on hand: 40 1 2 40 40 440550 5050 20 95 4045 Forecast Customer orders (booked) Projected on-hand Inventory MPS quantity Available-to-promise (ATP) 75 20 10 Based on the ATP, should a new customer order of 50 units, to be delivered in week 4, be accepted? If not, which week is the earliest that this order can be accepted?

Explanation / Answer

Solution :

New order of 50 cannot be accepted in week 4.

It can be accepted in week 5.

Week On Hand 1 2 3 4 5 6 7 8 Total Forecast 40 40 40 40 50 50 50 50 Customer Orders 20 95 40 45 15 75 20 10 Projected On Hand Inventory 40 0 5 65 20 70 95 45 95 MPS 100 100 100 100 100 ATP 20 5 15 85 5 90