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 anymore 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 '9 FORECAST 250 250 150 200 400 550 500 600 4200 OUTPUT REGULAR 330 330 330 330 330 330 330 330 3960 OVERTIME 60 60 60 60 240 SUBCONTRACT 0 OUTPUT-FORECAS 80 80 180 130 -10 -160 -110 -210 INVENTORY 4200 BEGINNING 0 80 160 340 430 420 260 150 ENDING 80 160 340 470 420 260 150 0 AVERAGE 40 120 250 405 425 340 205 75 0 0 0 0 0 0 0 0 -60 -80 TOTALS $7,920 $660 $660 $660 $660 $660 $660 $660 $660 $660 $660 $660 $660 $0 $0 $0 $0 $0 $0 $180 $180 $180 $180 $0 $0 $720 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $40 $120 $250 $405 $460 $440 $425 $340 $205 $75 $0 $0 $2,760 $0 $0 $0 $0 $0 $0 $0 $0 $0 $300 $400 $0 $700 $700 $780 $910 $1,065 $1,120 $1,100 $1,265 $1,180 $1,045 $1,215 $1,060 $660 $12,100 BACKLOG COSTS: OUTPUT REGULAR OVERTIME SUBCONTRACT INVENTORY BACKORDER TOTALS TYPE OF COST AMOUNT REGULAR OVERTIME SUBCONTRACT INVENTORY BACKORDER 23675 1 4 5 350 330 -20 470 450 460 0 6 350 330 -20 450 430 440 0 7 '8 10 11 12 350 330 -20 0 0 250 330 80 0 0 0 0