Question: An end item's demand forecasts for the next 10 weeks are 45, 45, 45, 45, 20, 20, 45, 45, 45, and 45 units. The current
An end item's demand forecasts for the next 10 weeks are
45,
45,
45,
45,
20,
20,
45,
45,
45,
and
45
units. The current on-hand inventory is
150
units. The order policy is to produce in lots of
95.
The booked customer orders for the item, starting with week 1, are
15,
48,
7,
5,
0,
3,
10,
0,
0,
and
0
units. The lead time is 2 weeks.
a. Develop an MPS for this end item. (Enter your responses as integers. A response of "0" is equivalent to being not applicable.)
| Lot Size: 95 | |||||||||||
| Lead Time: 2 weeks | |||||||||||
| Week | |||||||||||
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | ||
| Forecast | 45 | 45 | 45 | 45 | 20 | 20 | 45 | 45 | 45 | 45 | |
| Customer orders (booked) | 15 | 48 | 7 | 5 | 0 | 3 | 10 | 0 | 0 | 0 | |
| Projected on-hand inventory | 150 | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here |
| MPS quantity | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here |
| MPS start | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here |
| ATP | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here |
b. The marketing department has received five orders for this item in the following sequence:
Order
1 is for
20
units to be delivered in period 1.
Order
2 is for
125
units to be delivered in period 4.
Order
3 is for
90
units to be delivered in period 6.
Order
4 is for
125
units to be delivered in period 7.
Order
5 is for
120
units to be delivered in period 10.
Assuming that the prospective MPS you developed in part (a) does not change, which orders would you be able to accept based on the available to promise (ATP)?
| Order | Order Acceptance |
| 1 | reject accept |
| 2 | accept reject |
| 3 | reject accept |
| 4 | reject accept |
| 5 | accept reject |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
