Devry BSOP330 week 5 ilab

BSOP330 Master Planning,
Week 5, Problem 1

MASTER PRODUCTION SCHEDULE

MAKE-TO-STOCK

Beginning PAB
prior to week number one is 500.

If the forecast is
larger than the book orders, complete the MPS using the forecast demand. If the
booked orders is larger than the forecast complete the MPS using the 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.

1. Complete the MPS due line and the MPS
released line.

2. Complete the PAB line.

3. Complete the ATP line.

Make-to-Stock MPS

GIVENS FOR THE MPS
PROBLEM:

1. Beginning on-hand inventory prior to
week one is 200 units.
2. If the forecast is larger than the book
orders, complete the MPS using the forecast
demand. If the booked orders is larger than the forecast complete the MPS using the 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.

BSOP330 Master Planning, 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 5,000 units, complete the chart below.