=+(with Solver optimization)

Line hours per batch:

Production line hours per month:

Cost to start up a line:

Cost to shut down a line:

Inventory holding cost:

Beginning and ending lines:

Beginning and ending inventory:

hours per batch, per month production lines Ending Inventory Production Line Shutdowns Production Line Start-ups batches Sales

(in line hours)

Sales

(in production lines)

Actual Production Lines Actual Production Sales Month Forecast January February March April May June 50 100 Total = 6000 Average =

6,020 5 12.5 480 A B C D E F G H I 1

2 3

4 5

6 7

9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 8

1,200 1,200 1,000 800 800 2,400 16 320 25,000 6,000 300