Tabard Industries forecasted the following demand for one of itsmost profitable products for the next 8? weeks: 100, 100, 100, 80,80, 80, 60, and 60 units. The booked customer orders for thisproduct, starting in week 1 are: 110, 80, 50, 40, 20, 10, 10, and 0units. The current on-hand inventory is 250 units, the orderquantity is 200 units, and the lead time is one week.
a. Develop a MPS for this product. (Enteryour responses as whole numbers. A response of “0” is equivalent tobeing not? applicable.)
Order Policy: 250 units Leadtime: 1 week
Quantity on Hand: 250
1
2
3
4
5
6
7
8
Forecast
100
100
100
80
80
80
60
60
Customer Orders (booked)
110
80
50
40
20
20
10
10
Projected on hand inventory
MPS quantity
MPS
OR
PayPal Gateway not configured
OR
PayPal Gateway not configured