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.