Revenue and Profit Analysis of Car Rental Company, Exams of Economics

Download Revenue and Profit Analysis of Car Rental Company and more Exams Economics in PDF only on Docsity! Class/Section: IFSM 201 7394 Concepts and Applications of Information Technology Latest Update Project: Project 2 D a t e D u e : ear Quarter Location CarClass Revenue NumCar s 2017 Q1 Downtown Economy $976,803 6,137 2017 Q1 Airport Economy $1,047,03 1 5,773 2015 Q3 Downtown Economy $804,931 5,564 2016 Q4 Airport Economy $958,989 5,370 2016 Q1 Downtown Economy $750,562 5,048 2015 Q3 Airport Economy $733,215 4,917 2016 Q4 Downtown Economy $735,993 4,751 2016 Q3 Downtown Economy $712,136 4,703 2016 Q2 Downtown Economy $670,068 4,459 2015 Q4 Airport Economy $639,838 4,256 2015 Q4 Airport Premium $663,293 4,137 2016 Q3 Airport Premium $688,190 4,081 2015 Q4 Downtown Premium $623,279 4,072 2017 Q1 Airport Premium $709,705 4,024 2017 Q2 Airport Premium $721,899 4,008 2016 Q2 Airport Premium $626,117 3,773 2017 Q2 Downtown Economy $600,403 3,748 2016 Q3 Airport Economy $620,543 3,665 2016 Q1 Airport Premium $590,987 3,621 2015 Q3 Downtown Premium $540,136 3,584 2015 Q4 Downtown Economy $531,619 3,582 2015 Q2 Airport Economy $501,606 3,470 2016 Q1 Airport Economy $521,223 3,406 2015 Q1 Airport Economy $469,217 3,387 2016 Q2 Downtown Premium $522,789 3,283 2017 Q2 Airport Economy $621,746 3,282 2015 Q2 Downtown Premium $487,304 3,274 2016 Q4 Airport Premium $564,853 3,260 2015 Q3 Airport Premium $504,843 3,194 2016 Q3 Downtown Premium $517,084 3,185 2016 Q1 Downtown Premium $444,067 2,840 2015 Q2 Downtown Economy $396,037 2,839 pg. 1 pg. 2 CarClass Economy Premium Total Result 37,526 30,098 40,831 20,238 67,62 4 61,06 9 78,357 50,336 128,69 3 15 and 2016 combined, produced the most revenue? How much revenue was it? tion that had the most combined revenue was "Downtown". The revenue was $58,622. pg. 5 CarClass Economy Premium pg. 6 Year Quarter Location CarClass Revenue NumCars Overhead Profit 2017 Q1 Downtown Economy $976,803 6,137 $306,850 $669,953 2017 Q1 Airport Economy $1,047,03 1 5,773 $288,650 $758,381 2015 Q3 Downtown Economy $804,931 5,564 $278,200 $526,731 2016 Q4 Airport Economy $958,989 5,370 $268,500 $690,489 2016 Q1 Downtown Economy $750,562 5,048 $252,400 $498,162 2015 Q3 Airport Economy $733,215 4,917 $245,850 $487,365 2016 Q4 Downtown Economy $735,993 4,751 $237,550 $498,443 2016 Q3 Downtown Economy $712,136 4,703 $235,150 $476,986 2016 Q2 Downtown Economy $670,068 4,459 $222,950 $447,118 2015 Q4 Airport Economy $639,838 4,256 $212,800 $427,038 2015 Q4 Airport Premium $663,293 4,137 $310,275 $353,018 2016 Q3 Airport Premium $688,190 4,081 $306,075 $382,115 2015 Q4 Downtown Premium $623,279 4,072 $305,400 $317,879 2017 Q1 Airport Premium $709,705 4,024 $301,800 $407,905 2017 Q2 Airport Premium $721,899 4,008 $300,600 $421,299 2016 Q2 Airport Premium $626,117 3,773 $282,975 $343,142 2017 Q2 Downtown Economy $600,403 3,748 $187,400 $413,003 2016 Q3 Airport Economy $620,543 3,665 $183,250 $437,293 2016 Q1 Airport Premium $590,987 3,621 $271,575 $319,412 2015 Q3 Downtown Premium $540,136 3,584 $268,800 $271,336 2015 Q4 Downtown Economy $531,619 3,582 $179,100 $352,519 2015 Q2 Airport Economy $501,606 3,470 $173,500 $328,106 2016 Q1 Airport Economy $521,223 3,406 $170,300 $350,923 2015 Q1 Airport Economy $469,217 3,387 $169,350 $299,867 2016 Q2 Downtown Premium $522,789 3,283 $246,225 $276,564 2017 Q2 Airport Economy $621,746 3,282 $164,100 $457,646 2015 Q2 Downtown Premium $487,304 3,274 $245,550 $241,754 2016 Q4 Airport Premium $564,853 3,260 $244,500 $320,353 2015 Q3 Airport Premium $504,843 3,194 $239,550 $265,293 2016 Q3 Downtown Premium $517,084 3,185 $238,875 $278,209 2016 Q1 Downtown Premium $444,067 2,840 $213,000 $231,067 2015 Q2 Downtown Economy $396,037 2,839 $141,950 $254,087 Profit per Car $84.24 $109.17 $139.44 $131.37 $73.84 $94.67 $98.27 $128.58 $83.06 $98.69 $87.35 $99.12 $81.36 $104.91 $89.50 $101.42 $100.27 $100.34 $85.33 $93.63 $78.06 $101.37 $105.11 $90.95 $110.19 $119.32 $88.21 $75.71 $98.41 $94.56 $103.03 $88.53 pg. 7