Assignment 1.xlsx - Auto Semi fixed cost cost/unit $...

This preview shows page 1 - 23 out of 60 pages.

fixed costcost/unitsell/unitAuto$ 250,000.00 $ 100.00 $ 400.00 Semi$ 100,000.00 $ 40.00 $ 400.00 total cost= fixed cost +variable cost(Q) total revenue= price(Q)Total Cost Auto$ 250,100.00 QSemi$ 100,040.00 QTotal RevenueAuto $400 Semi$400 AutoQTCTR0 $ - $ - 250 $ 275,000.00 $ 100,000.00 500 $ 300,000.00 $ 200,000.00 750 $ 325,000.00 $ 300,000.00 1000 $ 350,000.00 $ 400,000.00 1250 $ 375,000.00 $ 500,000.00 1500 $ 400,000.00 $ 600,000.00 1750 $ 425,000.00 $ 700,000.00 2000 $ 450,000.00 $ 800,000.00 2250 $ 475,000.00 $ 900,000.00 2500 $ 500,000.00 $ 1,000,000.00 2750 $ 525,000.00 $ 1,100,000.00 3000 $ 550,000.00 $ 1,200,000.00 3250 $ 575,000.00 $ 1,300,000.00 3500 $ 600,000.00 $ 1,400,000.00 3750 $ 625,000.00 $ 1,500,000.00 4000 $ 650,000.00 $ 1,600,000.00 4250 $ 675,000.00 $ 1,700,000.00 4500 $ 700,000.00 $ 1,800,000.00 4750 $ 725,000.00 $ 1,900,000.00 5000 $ 750,000.00 $ 2,000,000.00 5250 $ 775,000.00 $ 2,100,000.00 5500 $ 800,000.00 $ 2,200,000.00 5750 $ 825,000.00 $ 2,300,000.00 6000 $ 850,000.00 $ 2,400,000.00 6250 $ 875,000.00 $ 2,500,000.00
6500 $ 900,000.00 $ 2,600,000.00 6750 $ 925,000.00 $ 2,700,000.00 7000 $ 950,000.00 $ 2,800,000.00 7250 $ 975,000.00 $ 2,900,000.00 7500 $ 1,000,000.00 $ 3,000,000.00 7750 $ 1,025,000.00 $ 3,100,000.00 8000 $ 1,050,000.00 $ 3,200,000.00 8250 $ 1,075,000.00 $ 3,300,000.00 8500 $ 1,100,000.00 $ 3,400,000.00 8750 $ 1,125,000.00 $ 3,500,000.00 9000 $ 1,150,000.00 $ 3,600,000.00 9250 $ 1,175,000.00 $ 3,700,000.00 9500 $ 1,200,000.00 $ 3,800,000.00 9750 $ 1,225,000.00 $ 3,900,000.00 10000 $ 1,250,000.00 $ 4,000,000.00 10250 $ 1,275,000.00 $ 4,100,000.00 10500 $ 1,300,000.00 $ 4,200,000.00 123456789 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25$- $10,000,000.00 $20,000,000.00 $30,000,000.00 $40,000,000.00 $50,000,000.00 $60,000,000.00 $70,000,000.00 AutoQTCTR
SemiAutoQ02505007501000125015001750200022502500275030003250350037504000425045004750500052505500575060006250
650067507000725075007750800082508500875090009250950097501000010250105005 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 430$- $200,000.00 $400,000.00 $600,000.00 $800,000.00 $1,000,000.00 $1,200,000.00
Background image
TCTR$ - $ - $ 110,000.00 $ 100,000.00 $ 120,000.00 $ 200,000.00 $ 130,000.00 $ 300,000.00 $ 140,000.00 $ 400,000.00 $ 150,000.00 $ 500,000.00 $ 160,000.00 $ 600,000.00 $ 170,000.00 $ 700,000.00 $ 180,000.00 $ 800,000.00 $ 190,000.00 $ 900,000.00 $ 200,000.00 $ 1,000,000.00 $ 210,000.00 $ 1,100,000.00 $ 220,000.00 $ 1,200,000.00 $ 230,000.00 $ 1,300,000.00 $ 240,000.00 $ 1,400,000.00 $ 250,000.00 $ 1,500,000.00 $ 260,000.00 $ 1,600,000.00 $ 270,000.00 $ 1,700,000.00 $ 280,000.00 $ 1,800,000.00 $ 290,000.00 $ 1,900,000.00 $ 300,000.00 $ 2,000,000.00 $ 310,000.00 $ 2,100,000.00 $ 320,000.00 $ 2,200,000.00 $ 330,000.00 $ 2,300,000.00 $ 340,000.00 $ 2,400,000.00 $ 350,000.00 $ 2,500,000.00
$ 360,000.00 $ 2,600,000.00 $ 370,000.00 $ 2,700,000.00 $ 380,000.00 $ 2,800,000.00 $ 390,000.00 $ 2,900,000.00 $ 400,000.00 $ 3,000,000.00 $ 410,000.00 $ 3,100,000.00 $ 420,000.00 $ 3,200,000.00 $ 430,000.00 $ 3,300,000.00 $ 440,000.00 $ 3,400,000.00 $ 450,000.00 $ 3,500,000.00 $ 460,000.00 $ 3,600,000.00 $ 470,000.00 $ 3,700,000.00 $ 480,000.00 $ 3,800,000.00 $ 490,000.00 $ 3,900,000.00 $ 500,000.00 $ 4,000,000.00 $ 510,000.00 $ 4,100,000.00 $ 520,000.00 $ 4,200,000.00 5001000150020002500300035004000450050005500600065007000750080008500900095001000Chart Title
TCTR
000010500
Background image
AutomaticUnit Revenue$ 400.00 Fixed Cost$ 250,000.00 Marginal Cost$ 40.00 Sales Forecast1200.00500Production Quantity
Total Revenue$ 200,000.00 Total Fixed Cost$ 250,000.00 Total Variable Cost$ 20,000.00 Profit$ (70,000.00)
SemiAutomatic Unit Revenue$ 400.00 Fixed Cost$ 100,000.00 Marginal Cost$ 100.00 Sales Forecast1200.00
Total Revenue$ 200,000.00 Total Fixed Cost$ 100,000.00 Total Variable Cost$ 20,000.00 Profit$ 80,000.00
AutoQTCTR0 $- $- 250 $ 62,500,100.00 $ 100,000.00 500 $ 125,000,100.00 $ 200,000.00 750 $ 187,500,100.00 $ 300,000.00 1000 $ 250,000,100.00 $ 400,000.00 1250 $ 312,500,100.00 $ 500,000.00 1500 $ 375,000,100.00 $ 600,000.00 1750 $ 437,500,100.00 $ 700,000.00 2000 $ 500,000,100.00 $ 800,000.00 2250 $ 562,500,100.00 $ 900,000.00 2500 $ 625,000,100.00 $ 1,000,000.00 2750 $ 687,500,100.00 $ 1,100,000.00 3000 $ 750,000,100.00 $ 1,200,000.00 3250 $ 812,500,100.00 $ 1,300,000.00 3500 $ 875,000,100.00 $ 1,400,000.00 3750 $ 937,500,100.00 $ 1,500,000.00 4000 $ 1,000,000,100.00 $ 1,600,000.00 4250 $ 1,062,500,100.00 $ 1,700,000.00 4500 $ 1,125,000,100.00 $ 1,800,000.00 4750 $ 1,187,500,100.00 $ 1,900,000.00 5000 $ 1,250,000,100.00 $ 2,000,000.00 5250 $ 1,312,500,100.00 $ 2,100,000.00 5500 $ 1,375,000,100.00 $ 2,200,000.00 5750 $ 1,437,500,100.00 $ 2,300,000.00 6000 $ 1,500,000,100.00 $ 2,400,000.00 6250 $ 1,562,500,100.00 $ 2,500,000.00 6500 $ 1,625,000,100.00 $ 2,600,000.00 6750 $ 1,687,500,100.00 $ 2,700,000.00 7000 $ 1,750,000,100.00 $ 2,800,000.00 7250 $ 1,812,500,100.00 $ 2,900,000.00 7500 $ 1,875,000,100.00 $ 3,000,000.00 7750 $ 1,937,500,100.00 $ 3,100,000.00 8000 $ 2,000,000,100.00 $ 3,200,000.00 8250 $ 2,062,500,100.00 $ 3,300,000.00 8500 $ 2,125,000,100.00 $ 3,400,000.00 8750 $ 2,187,500,100.00 $ 3,500,000.00 9000 $ 2,250,000,100.00 $ 3,600,000.00 9250 $ 2,312,500,100.00 $ 3,700,000.00 9500 $ 2,375,000,100.00 $ 3,800,000.00 9750 $ 2,437,500,100.00 $ 3,900,000.00
10000 $ 2,500,000,100.00 $ 4,000,000.00 10250 $ 2,562,500,100.00 $ 4,100,000.00 10500 $ 2,625,000,100.00 $ 4,200,000.00
SemiAutoProfitQTC$- 0 $- $ (62,400,100.00)250 $ 25,010,000.00 $ (124,800,100.00)500 $ 50,020,000.00 $ (187,200,100.00)750 $ 75,030,000.00 $ (249,600,100.00)1000 $ 100,040,000.00 $ (312,000,100.00)1250 $ 125,050,000.00 $ (374,400,100.00)1500 $ 150,060,000.00 $ (436,800,100.00)1750 $ 175,070,000.00 $ (499,200,100.00)2000 $ 200,080,000.00 $ (561,600,100.00)2250 $ 225,090,000.00 $ (624,000,100.00)2500 $ 250,100,000.00 $ (686,400,100.00)2750 $ 275,110,000.00 $ (748,800,100.00)3000 $ 300,120,000.00 $ (811,200,100.00)3250 $ 325,130,000.00 $ (873,600,100.00)3500 $ 350,140,000.00 $ (936,000,100.00)3750 $ 375,150,000.00 $ (998,400,100.00)4000 $ 400,160,000.00 $ (1,060,800,100.00)4250 $ 425,170,000.00 $ (1,123,200,100.00)4500 $ 450,180,000.00 $ (1,185,600,100.00)4750 $ 475,190,000.00 $ (1,248,000,100.00)5000 $ 500,200,000.00 $ (1,310,400,100.00)5250 $ 525,210,000.00 $ (1,372,800,100.00)5500 $ 550,220,000.00 $ (1,435,200,100.00)5750 $ 575,230,000.00 $ (1,497,600,100.00)6000 $ 600,240,000.00 $ (1,560,000,100.00)6250 $ 625,250,000.00 $ (1,622,400,100.00)6500 $ 650,260,000.00 $ (1,684,800,100.00)6750 $ 675,270,000.00 $ (1,747,200,100.00)7000 $ 700,280,000.00 $ (1,809,600,100.00)7250 $ 725,290,000.00 $ (1,872,000,100.00)7500 $ 750,300,000.00 $ (1,934,400,100.00)7750 $ 775,310,000.00 $ (1,996,800,100.00)8000 $ 800,320,000.00 $ (2,059,200,100.00)8250 $ 825,330,000.00 $ (2,121,600,100.00)8500 $ 850,340,000.00 $ (2,184,000,100.00)8750 $ 875,350,000.00 $ (2,246,400,100.00)9000 $ 900,360,000.00 $ (2,308,800,100.00)9250 $ 925,370,000.00 $ (2,371,200,100.00)9500 $ 950,380,000.00 $ (2,433,600,100.00)9750 $ 975,390,000.00
$ (2,496,000,100.00)10000 $ 1,000,400,000.00 $ (2,558,400,100.00)10250 $ 1,025,410,000.00 $ (2,620,800,100.00)10500 $ 1,050,420,000.00
TRProfit$ 100,000.00 #VALUE!$ 200,000.00 $ (24,810,000.00)$ 300,000.00 $ (49,720,000.00)$ 400,000.00 $ (74,630,000.00)$ 500,000.00 $ (99,540,000.00)$ 600,000.00 $ (124,450,000.00)$ 700,000.00 $ (149,360,000.00)$ 800,000.00 $ (174,270,000.00)$ 900,000.00 $ (199,180,000.00)$ 1,000,000.00 $ (224,090,000.00)$ 1,100,000.00 $ (249,000,000.00)$ 1,200,000.00 $ (273,910,000.00)$ 1,300,000.00 $ (298,820,000.00)$ 1,400,000.00 $ (323,730,000.00)$ 1,500,000.00 $ (348,640,000.00)$ 1,600,000.00 $ (373,550,000.00)$ 1,700,000.00 $ (398,460,000.00)$ 1,800,000.00 $ (423,370,000.00)$ 1,900,000.00 $ (448,280,000.00)$ 2,000,000.00 $ (473,190,000.00)$ 2,100,000.00 $ (498,100,000.00)$ 2,200,000.00 $ (523,010,000.00)$ 2,300,000.00 $ (547,920,000.00)$ 2,400,000.00 $ (572,830,000.00)$ 2,500,000.00 $ (597,740,000.00)$ 2,600,000.00 $ (622,650,000.00)$ 2,700,000.00 $ (647,560,000.00)$ 2,800,000.00 $ (672,470,000.00)$ 2,900,000.00 $ (697,380,000.00)$ 3,000,000.00 $ (722,290,000.00)$ 3,100,000.00 $ (747,200,000.00)$ 3,200,000.00 $ (772,110,000.00)$ 3,300,000.00 $ (797,020,000.00)$ 3,400,000.00 $ (821,930,000.00)$ 3,500,000.00 $ (846,840,000.00)$ 3,600,000.00 $ (871,750,000.00)$ 3,700,000.00 $ (896,660,000.00)$ 3,800,000.00 $ (921,570,000.00)$ 3,900,000.00 $ (946,480,000.00)$ 4,000,000.00 $ (971,390,000.00)
$ 4,100,000.00 $ (996,300,000.00)$ 4,200,000.00 $ (1,021,210,000.00)$- #VALUE!

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture