Mutts Amazing Dogs has developed the following demand forecast for The Pitbull, a spicy concoction graced by pepper jack cheese, serrano, habanero, poblano and jalapeno peppers, onion, and a cilantro-lime aioli. They enter the planning period with 20 hotdogs in inventory as shown in Week 0. A few customers have standing orders for hotdogs and they have booked catering events over the next two months. They buy their hotdogs in packages of ten just like you and me.
|
Week
|
0
|
1
|
2
|
3
|
4
|
5
|
6
|
7
|
8
|
|
Forecast
|
|
70
|
80
|
90
|
100
|
120
|
140
|
170
|
220
|
|
Customer Orders
|
|
80
|
50
|
30
|
10
|
0
|
0
|
0
|
0
|
|
Projected on-hand inventory
|
20
|
|
|
|
|
|
|
|
|
|
MPS
|
|
|
|
|
|
|
|
|
|
|
ATP
|
|
|
|
|
|
|
|
|
|
Use Table 11.2 to answer this question. What should the MPS quantity be for week 5?