As described in class and on the Canvas tutorial, you need to improve the aggregate plan from the total cost of $$12100.$ Remember that you must produce the same every period under the "Regular" output you choose $($no hiring$/$layoffs to adjust regular output$)$ and can not produce anymore than $25\%$ of your Regular for any given period in overtime. Subcontracting is unlimited. You start with $0$ inventory and can have end of the year inventory if you desire.

BICYCLE CO$.$ CAPACITY PLANNING

PERIOD $123456789101112$

$-------------------------------------------------------------------------------------------$

FORECAST $2502501502003503504005505006003502504200$

OUTPUT

REGULAR $3303303303303303303303303303303303303960$

OVERTIME $60606060240$

SUBCONTRACT $0$

OUTPUT$-$FORECAST $8080180130-20-20-10-160-110-210-2080--------$

INVENTORY $4200$

BEGINNING $08016034047045043042026015000$

ENDING $80160340470450430420260150000$

AVERAGE $401202504054604404253402057500$

BACKLOG $000000000-60-800$

COSTS:

OUTPUT TOTALS

REGULAR $$660$ $$660$ $$660$ $$660$ $$660$ $$660$ $$660$ $$660$ $$660$ $$660$ $$660$ $$660$ $$7,920$

OVERTIME $$0$ $$0$ $$0$ $$0$ $$0$ $$0$ $$180$ $$180$ $$180$ $$180$ $$0$ $$0$ $$720$

SUBCONTRACT $$0$ $$0$ $$0$ $$0$ $$0$ $$0$ $$0$ $$0$ $$0$ $$0$ $$0$ $$0$ $$0$

INVENTORY $$40$ $$120$ $$250$ $$405$ $$460$ $$440$ $$425$ $$340$ $$205$ $$75$ $$0$ $$0$ $$2,760$

BACKORDER $$0$ $$0$ $$0$ $$0$ $$0$ $$0$ $$0$ $$0$ $$0$ $$300$ $$400$ $$0$ $$700$

$--------$

TOTALS $$700$ $$780$ $$910$ $$1,065$ $$1,120$ $$1,100$ $$1,265$ $$1,180$ $$1,045$ $$1,215$ $$1,060$ $$660$ $$12,100$

$========$

TYPE OF COST AMOUNT

$-------------------------$

REGULAR $2$

OVERTIME $3$

SUBCONTRACT $6$

INVENTORY $1$

BACKORDER $5$