Management Chapter 12 Homework Mps Doses Due Mps Due Weeks Start

65

23456789

45 50 55 60 65 70 75 80

On-hand inventory at end of week 1

Week

Forecasted demand

Master production schedule

Available to promise

Booked orders

Projected ending inventory

65

23456789

45 50 55 60 65 70 75 80

On-hand inventory at end of week 1

Week

Forecasted demand

Projected ending inventory

Master production schedule

Available to promise

Booked orders

100

23456789

250 250 300 300 350 350 250 250

On-hand inventory at end of week 1

Week

Forecasted demand

Projected ending inventory

Master production schedule

Available to promise

Booked orders

100

23456789

250 250 300 300 350 350 250 250

On-hand inventory at end of week 1

Week

Forecasted demand

Projected ending inventory

Master production schedule

Available to promise

Booked orders

a.)

40

Month

19 20 21 22 23 24 25 26

200 200 200 225 225 225 200 200

On-hand inventory at end of April:

Week

Forecasted demand

************May***********

************June************

Booked orders

Projected ending inventory

Master production schedule

Available to promise

***A2*** Week: 1 2 3 4 5 6

200 200 200 300 300 300

LT (weeks): 2 200

Gross requirements

Scheduled receipts

Planned receipts

Planned orders

Projected ending inventory:

Net requirements

***A2*** Week: 1 2 3 4 5 6

200 200 200 300 300 300

LT (weeks): 3 200

Gross requirements

Scheduled receipts

Planned receipts

Planned orders

Projected ending inventory:

Net requirements

***B3*** Week: 1 2 3 4 5 6

400 400 400 400

Gross requirements

Planned receipts

Planned orders

Scheduled receipts

Projected ending inventory:

Net requirements

***B3*** Week: 1 2 3 4 5 6

400 400 400 400

LT (weeks): 1

00 0 0 0 0 0

Gross requirements

Scheduled receipts

Projected ending inventory:

Planned receipts

Planned orders

Net requirements

MPS due date

Planned receipts

Planned orders

Projected ending inventory:

Net requirements

Projected ending inventory:

Net requirements

Planned receipts

Planned orders

Scheduled receipts

Week: 1 2 3 4 5 6

LT (weeks): 0 0250 300 300 300 200

Item B Week: 1 2 3 4 5 6

# Required: 1 0250 300 300 300 200

LT (weeks): 1

Item C Week: 1 2 3 4 5 6

# Required: 2 0500 600 600 600 400

LT (weeks): 3 500 600

0 0 0 0 0 0

Item F Week: 1 2 3 4 5 6

# Required: 3 1450 1500 1300 300 200 0

Start assembly

Acme PolyBob

Gross requirements

Scheduled receipts

Gross requirements

Scheduled receipts

Planned orders

Gross requirements

Projected ending inventory:

Gross requirements

Scheduled receipts

Projected ending inventory:

Net requirements

Planned receipts

Planned orders

Planned receipts

Scheduled receipts

Projected ending inventory:

MPS due date

Start assembly

Gross requirements

01000 0500 0 0

Min. order: 2500 02500 02500 0 0

2500 02500 0 0 0

Week: 1 2 3 4 5 6

# Required: 2 04000 04000 04000

Min. order: 15000 0 0 0 0 0 0

0 0 0 0 0 0

Planned orders

Planned receipts

Gross requirements

Wheels

Net requirements

Planned receipts

Planned orders

Scheduled receipts

Projected ending inventory:

Net requirements

Gross requirements

Planned receipts

Planned orders

Scheduled receipts

Projected ending inventory:

Net requirements

Gross requirements

Scheduled receipts

Projected ending inventory:

Net requirements

Planned receipts

Planned orders

Net requirements

Week: 1 2 3 4 5 6

2500 3000 3000 3000 2000

LT (weeks): 0 02500 3000 3000 3000 2000

05000 00001000

Week: 1 2 3 4 5 6

Triam Deluxe Computer System

MPS due date

Start assembly

Projected ending inventory:

CD-ROM drives

Scheduled receipts

Projected ending inventory:

Net requirements

Planned orders

Planned receipts

Gross requirements

Scheduled receipts

a.)

916

Month

12345678

1000 1000 1250 1250 1500 1500 1750 1750

1095 950 1100 963 1125 1095 1243 1208

c.)

Booked orders

On-hand at end of December:

************January************

************February************

Week

Forecasted demand

Projected ending inventory

Master production schedule

Available to promise

Gross requirements

Scheduled receipts

Projected ending inventory:

Planned receipts

Net requirements

Compound B

Planned orders

Compound A

Planned orders

MPS mg due

MPS doses due

Compound C

Planned orders

Planned receipts

Gross requirements

Scheduled receipts

Projected ending inventory:

Net requirements

LT (weeks): 1 0 0 17000 0 0 14000 0

Week: 1 2 3 4 5 6 7

# Required: 0.5 0 0 8500 0 0 7000 0

LT (weeks): 1

1500 1500 1500 13000 13000 13000 6000 6000

Week: 1 2 3 4 5 6 7

# Required: 0.25 0 0 4250 0 0 3500 0

LT (weeks): 1 200

0200 200 00000

0 0 4050 0 0 3500 0

# Required: 0.25 010000 00000

LT (weeks): 1

00000000

010000 00000

Min. order: 4000 010000 00000

Start mixing

Gross requirements

Projected ending inventory:

Gross requirements

Scheduled receipts

Projected ending inventory:

Net requirements

Planned receipts

Compound Z

Scheduled receipts

Projected ending inventory:

Net requirements

Compound X

Planned receipts

Net requirements

Planned receipts

Planned orders

Gross requirements

Scheduled receipts

Projected ending inventory:

Net requirements

Compound Y

Planned orders

Projected ending inventory:

Net requirements

Planned receipts

LT (weeks): 1

Scheduled receipts

Gross requirements

PAINTING ASSEMBLY PACKING

A1.5 20.5 415 3.75

First come – first served

START END START END START END

B1.5 5.5 5.5 8.5 8.5 9.5 0

D8.5 14.5 14.5 18.5 18.5 19.5 0

Earliest due date

START END START END START END

C0 3 3 5 5 5.5 0

Critical ratio

START END START END START END

CRITICAL

RATIO

JOB

Estimated Days

TOTAL

TASK TIME

DAYS UNTIL

DUE

PACKING

DAYS LATE

JOB

PAINTING

ASSEMBLY

PACKING

DAYS LATE

JOB

PAINTING

ASSEMBLY

DAYS LATE

JOB

PAINTING

ASSEMBLY

PACKING

STEP 1 STEP 2 STEP 3

Critical ratio

START END START END START END

D Smith 0 6 6 10 10 11 0

DAYS LATE

JOB

STEP 1

STEP 2

NAME

STEP 3

CRITICAL

RATIO

NAME

JOB

Estimated Days

TOTAL

TASK TIME

DAYS UNTIL

DUE

Minneapolis Distribution Center

Month:

Week: 45 46 47 48 49 50 51 52 1 2 3 4

80 80 80 80 90 90 100 100 120 120 140 140

LT (weeks): 2

Buffalo Distribution Center

Month:

Planned receipts

Planned orders

Projected ending inventory:

Net requirements

Week: 45 46 47 48 49 50 51 52 1 2 3 4

60 60 70 70 80 80 80 80 90 90 95 95

LT (weeks): 1 100

Master Schedule

Month:

Week: 45 46 47 48 49 50 51 52

Gross requirements

Scheduled receipts

November

December

January

November

December

January

November

December

Gross requirements

Scheduled receipts

Planned receipts

Projected ending inventory:

Net requirements

Question 1.)

Week: 1 2 3 4 5 6 7 8

Question 2.)

Question 3.)

Question 4.)

Week: 1 2 3 4 5 6 7 8

Total planned orders 20000 20000 20000 20000 20000 20000 20000 20000

Refusing a customer order up-front when you know that you can not deliver is a responsible and honest

demand.

Jack’s approach to order promising has been serving as a “rule-of-thumb” in the absence of any real

information. The advantages are that even without data, he has been able to give customers a fairly