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 and can not produce any more than 20% 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. Submit an Excel spreadsheet of your plan or a picture or pdf of your plan that you did manually.

BICYCLE CO. CAPACITY PLANNING PERIOD 1 2 3 4 5 6 00 8 9 '10 '11 '12 250 250 150 200 350 350 400 550 500 600 350 250 4200 330 330 330 330 330 330 330 330 330 60 330 60 330 60 330 60 3960 240 0 FORECAST OUTPUT REGULAR OVERTIME SUBCONTRACT OUTPUT-FORECAS INVENTORY BEGINNING ENDING AVERAGE BACKLOG 80 80 180 130 -20 -20 -10 -160 -110 -210 -20 80 4200 0 80 40 80 160 120 0 160 340 250 0 340 470 405 0 470 450 460 0 450 430 440 0 430 420 425 0 420 260 340 0 260 150 205 150 0 75 -60 0 0 0 -80 0 0 COSTS: OUTPUT REGULAR OVERTIME SUBCONTRACT INVENTORY BACKORDER $660 $0 $0 $40 $0 $660 $0 $0 $120 $0 $660 $0 $0 $250 $0 $660 $0 $0 $405 $0 $660 $0 $0 $460 $0 $660 $0 $0 $440 $0 $660 $180 $0 $425 $0 $660 $180 $0 $340 $0 $660 $180 $0 $205 $0 $660 $180 $0 $75 $300 $660 $0 $0 $0 $400 $660 $0 $0 $0 $0 TOTALS $7,920 $720 $0 $2,760 $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 OVERTIME SUBCONTRACT INVENTORY BACKORDER 2 3 6 1 5