MASTER PRODUCTION SCHEDULEMAKE-TO-STOCKWEEKS123456789FORECAST3001001012030260300

MASTER PRODUCTION SCHEDULEMAKE-TO-STOCKWEEKS123456789FORECAST3001001012030260300
Week 5 Problem 1
MASTER PRODUCTION SCHEDULE
MAKE-TO-STOCK
WEEKS
1
2
3
4
5
6
7
8
9
FORECAST
300
100
10
120
30
260
300
50
400
BOOKED ORDERS
50
40
80
10
50
50
MPS DUE
MPS RELEASED
PAB
BEGIN
PAB 500
ATP
Beginning PAB prior to week number one is 500.
The FORECAST HAS NOT been consumed by booked orders.
Lead-time for MPS releases is one week.
All MPS releases must be in lot sizes of 250 units.
Period order coverage is one period.
INSTRUCTIONS
1. Complete the MPS due line and the MPS released line.
2. Complete the PAB line.
3. Complete the ATP line.
Week 5 Assignment
Make-to-Stock MPS
WEEKS
1
2
3
4
5
6
7
8
9
10
FORECAST
100
50
30
70
10
20
25
10
20
50
BOOKED
ORDERS
0
0
20
0
20
5
10
30
10
20
MPS
DUE
MPS
RELEASED
POH OR
PAB
200
ATP
GIVENS FOR THE MPS PROBLEM:
1. Beginning on-hand inventory prior to week one is 200 units.
2. The forecast has been consumed by booked orders.
3. Lead-time for MPS planned orders is one week.
4. All MPS releases must be in lot sizes of 200 or multiples of 200.
REQUIRED:
Complete the MPS due and MPS planned lines.
Calculate the new projected on-hand inventory line.
Calculate the ATP line for the entire MPS.
Week 5 Problem 3
Forecast Disaggregation
Product Family Blenders
Model Number
Percent of the Annual Forecast
B-100
10.00%
B-200
7.00%
B-300
25.00%
B-400
30.00&
B-500
12.00%
B-600
16.00%
Total
100.00%
Note: the total percentage must equal exactly 100%.
If the aggregate forecast for the family of blenders for the month of September is 5000 units complete the chart below.
Product Family Blenders
Model Number
September Monthly Forecast
Weekly Forecast Divide by 4
B-100
B-200
B-300
B-400
B-500
B-600
Attachments: