BSOP 330 Week 5 Problems

BSOP330 Master Planning, 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

 

 

 

250

 

250

250

 

500

 

MPS RELEASED

 

 

 

 

 

250

 

250

 

 

500

PAB

BEGIN

PAB 500

 

 

200

 

100

60

190

160

150

100

50

150

ATP

 

 

 

20

160

 

150

 

 

500

 

 

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.

 

 

INSTRUCTIONS

 

 

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

 

2.         Complete the PAB line.

 

3.         Complete the ATP line.

BSOP Master Planning, Week 5 Assignment, Problem Two

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

 

 

200

 

 

 

 

 

200

 

MPS

RELEASED

 

 

 

200

 

 

 

 

 

200

POH OR

PAB

200

100

50

20

150

130

110

85

55

35

185

ATP

 

 

0

125

 

 

 

 

 

180

 

 

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.

Product Family Blenders

Model Number

September Monthly Forecast

Weekly Forecast Divide by 4

B-100

500

125

B-200

350

87.5

B-300

1250

312.5

B-400

1500

375

B-500

600

150

B-600

800

200

 

Required: Complete the chart above and submit to the Dropbox.

 

Save time and excel in your essays and homework. Hire an essay writer for the best price for the top-notch grade you deserve.
275 words per page

You essay will be 275 words per page. Tell your writer how many words you need, or the pages.

12 pt Times New Roman

Unless otherwise stated, we use 12pt Arial/Times New Roman as the font for your paper.

Double line spacing

Your essay will have double spaced text. View our sample essays.

Any citation style

APA, MLA, Chicago/Turabian, Harvard, our writers are experts at formatting.

We Accept
Image 3