Spring 2018 Name: LD. #: 1. Using the information in the following table, prepar

Question

Spring 2018 Name: LD. #: 1. Using 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 credits Week 7 50 20 8 50 10 Quantity on hand: 40 1 50 50 75 Forecast 40 40 40 40 45 15 Customer orders (booked) 2095 Projected on-hand Inventory MPS quantity Available-to-promise (ATP) 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 :

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 360 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

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.