A firm is planning their master production schedule for January and February. The forecast for January is 160 and the forecast for February is 200. Assume four weeks in each month. There are firm customer orders for the first five weeks. They are: 50, 42, 18, 6, and 2. The production lot size is 100 and beginning inventory is 75.
Develop the MPS and calculate the projected inventory and available to promise. Use those calculations to answer the following questions.
1) What is the master production schedule for period 1? If no production is scheduled, enter a zero.
2) What is the master production schedule for period 2? If no production is scheduled, enter a zero.
3) What is the master production schedule for period 3? If no production is scheduled, enter a zero.
4) What is the master production schedule for period 4? If no production is scheduled, enter a zero.
5) What is the master production schedule for period 5? If no production is scheduled, enter a zero.
6) What is the master production schedule for period 6? If no production is scheduled, enter a zero.
7) What is the master production schedule for period 7? If no production is scheduled, enter a zero.
8) What is the master production schedule for period 8? If no production is scheduled, enter a zero.
9) What is the projected inventory for period 1? Enter a zero if there is no inventory.
10) What is the projected inventory for period 2? Enter a zero if there is no inventory.
11) What is the projected inventory for period 3? Enter a zero if there is no inventory.
12) What is the projected inventory for period 4? Enter a zero if there is no inventory.
13) What is the projected inventory for period 5? Enter a zero if there is no inventory.
14) What is the projected inventory for period 6? Enter a zero if there is no inventory.
15) What is the projected inventory for period 7? Enter a zero if there is no inventory.
16) What is the projected inventory for period 8? Enter a zero if there is no inventory.
17) What is the available to promise for period 1? If available to promise is not calculated for that period, enter a zero.
18) What is the available to promise for period 2? If available to promise is not calculated for that period, enter a zero.
19) What is the available to promise for period 3? If available to promise is not calculated for that period, enter a zero.
20) What is the available to promise for period 4? If available to promise is not calculated for that period, enter a zero.
21) What is the available to promise for period 5? If available to promise is not calculated for that period, enter a zero.
22) What is the available to promise for period 6? If available to promise is not calculated for that period, enter a zero.
23) What is the available to promise for period 7? If available to promise is not calculated for that period, enter a zero.
24) What is the available to promise for period 8? If available to promise is not calculated for that period, enter a zero.