Question: 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

As described in class and on the Canvas tutorial,
As described in class and on the Canvas tutorial,
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 and can not produce anymore than 20% of your Regular for any given period in overtime. Subcontracting is unlimited. You start with O inventory and can have end of the year inventory if you desire. BICYCLE CO. CAPACITY PLANNING 4 6 6 8 09 10 '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 PERIOD FORECAST OUTPUT REGULAR OVERTIME SUBCONTRACT OUTPUT-FORECAS INVENTORY BEGNNING ENDNG AVERAGE BACKLOG 3960 240 0 80 80 180 130 -20 -20 -10 -160 -110 210 -20 80 4200 0 80 40 0 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 0 150 0 75 -60 0 0 0 -80 OOOO COSTS: OUTPUT REGULAR OVERTIME SUBCONTRACT INVENTORY BACKORDER $660 $660 $660 $0 $0 $0 $0 $0 $0 $40 $120 $250 $0 $0 $0 $660 $0 $o $405 SO $660 SO $o $460 $0 $660 $0 $0 $440 $o $660 $180 $0 $425 $0 $660 $180 $0 $340 $0 $660 $180 $0 $205 SO $660 $180 SO $75 $300 $660 $660 $0 SO $0 $0 $0 $0 $400 $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 AMOUNT TYPE OF COST REGULAR OVERTIME SUBCONTRACT INVENTORY BACKORDER 2 3 6 1 5

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!