powerpoint presentatio
re.bertyh.elpsfuben.t
RentalCarCompanyjune.xlsxAnalysis By
| Name: | Your Name | |
| Class/Section: | Your Class | |
| Project: | Excel Project 3 - MS Excel | |
| Date Due: | Due Date |
Data
| Year | Quarter | Location | CarClass | Revenue | NumCars |
| 2017 | Q1 | Downtown | Economy | $976,803 | 6,137 |
| 2017 | Q1 | Airport | Economy | $1,047,031 | 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 |
| 2015 | Q1 | Downtown | Economy | $374,342 | 2,817 |
| 2016 | Q4 | Downtown | Premium | $450,598 | 2,748 |
| 2017 | Q1 | Downtown | Premium | $451,848 | 2,695 |
| 2015 | Q1 | Downtown | Premium | $370,169 | 2,537 |
| 2015 | Q1 | Airport | Premium | $375,634 | 2,507 |
| 2016 | Q2 | Airport | Economy | $384,966 | 2,277 |
| 2015 | Q2 | Airport | Premium | $316,848 | 2,057 |
| 2017 | Q2 | Downtown | Premium | $344,292 | 2,008 |
Slide 2
| Year | Quarter | Location | CarClass | Revenue | NumCars |
| 2016 | Q4 | Airport | Economy | $958,989 | 5,370 |
| 2016 | Q1 | Downtown | Economy | $750,562 | 5,048 |
| 2016 | Q4 | Downtown | Economy | $735,993 | 4,751 |
| 2016 | Q3 | Downtown | Economy | $712,136 | 4,703 |
| 2016 | Q2 | Downtown | Economy | $670,068 | 4,459 |
| 2016 | Q3 | Airport | Premium | $688,190 | 4,081 |
| 2016 | Q2 | Airport | Premium | $626,117 | 3,773 |
| 2016 | Q3 | Airport | Economy | $620,543 | 3,665 |
| 2016 | Q1 | Airport | Premium | $590,987 | 3,621 |
| 2016 | Q1 | Airport | Economy | $521,223 | 3,406 |
| 2016 | Q2 | Downtown | Premium | $522,789 | 3,283 |
| 2016 | Q4 | Airport | Premium | $564,853 | 3,260 |
| 2016 | Q3 | Downtown | Premium | $517,084 | 3,185 |
| 2016 | Q1 | Downtown | Premium | $444,067 | 2,840 |
| 2016 | Q4 | Downtown | Premium | $450,598 | 2,748 |
| 2016 | Q2 | Airport | Economy | $384,966 | 2,277 |
| Sum of NumCars | Column Labels | ||||
| Row Labels | Economy | Premium | Sum of NumCars | ||
| Q1 | 8454 | 6461 | 14915 | ||
| Q2 | 6736 | 7056 | 13792 | ||
| Q3 | 8368 | 7266 | 15634 | ||
| Q4 | 10121 | 6008 | 16129 | ||
| Sum of NumCars | 33679 | 26791 | 60470 | ||
| Sum of NumCars | Column Labels | ||||
| Row Labels | Airport | Downtown | Sum of NumCars | ||
| Q1 | 7027 | 7888 | 14915 | ||
| Q2 | 6050 | 7742 | 13792 | ||
| Q3 | 7746 | 7888 | 15634 | ||
| Q4 | 8630 | 7499 | 16129 | ||
| Sum of NumCars | 29453 | 31017 | 60470 |
Number of cars
Economy Q1 Q2 Q3 Q4 8454 6736 8368 10121 Premium Q1 Q2 Q3 Q4 6461 7056 7266 6008number of cars
Airport Q1 Q2 Q3 Q4 7027 6050 7746 8630 Downtown Q1 Q2 Q3 Q4 7888 7742 7888 7499Slide 3
| Year | Quarter | Location | CarClass | Revenue | NumCars |
| 2016 | Q4 | Airport | Economy | $958,989 | 5,370 |
| 2016 | Q1 | Downtown | Economy | $750,562 | 5,048 |
| 2016 | Q4 | Downtown | Economy | $735,993 | 4,751 |
| 2016 | Q3 | Downtown | Economy | $712,136 | 4,703 |
| 2016 | Q2 | Downtown | Economy | $670,068 | 4,459 |
| 2016 | Q3 | Airport | Premium | $688,190 | 4,081 |
| 2016 | Q2 | Airport | Premium | $626,117 | 3,773 |
| 2016 | Q3 | Airport | Economy | $620,543 | 3,665 |
| 2016 | Q1 | Airport | Premium | $590,987 | 3,621 |
| 2016 | Q1 | Airport | Economy | $521,223 | 3,406 |
| 2016 | Q2 | Downtown | Premium | $522,789 | 3,283 |
| 2016 | Q4 | Airport | Premium | $564,853 | 3,260 |
| 2016 | Q3 | Downtown | Premium | $517,084 | 3,185 |
| 2016 | Q1 | Downtown | Premium | $444,067 | 2,840 |
| 2016 | Q4 | Downtown | Premium | $450,598 | 2,748 |
| 2016 | Q2 | Airport | Economy | $384,966 | 2,277 |
| Sum of Revenue | Column Labels | ||||
| Row Labels | Economy | Premium | Sum of Revenue | ||
| Q1 | 1271785 | 1035054 | 2306839 | ||
| Q2 | 1055034 | 1148906 | 2203940 | ||
| Q3 | 1332679 | 1205274 | 2537953 | ||
| Q4 | 1694982 | 1015451 | 2710433 | ||
| Sum of Revenue | 5354480 | 4404685 | 9759165 | ||
| Sum of Revenue | Column Labels | ||||
| Row Labels | Airport | Downtown | Sum of Revenue | ||
| Q1 | 1112210 | 1194629 | 2306839 | ||
| Q2 | 1011083 | 1192857 | 2203940 | ||
| Q3 | 1308733 | 1229220 | 2537953 | ||
| Q4 | 1523842 | 1186591 | 2710433 | ||
| Sum of Revenue | 4955868 | 4803297 | 9759165 |
