Description
Year Quarter Location CarClass Revenue NumCars
2017 Q1 Downtown Economy " $912,900 " " 6,262 "
2017 Q1 Airport Economy " $978,534 " " 5,891 "
2015 Q3 Downtown Economy " $752,272 " " 5,678 "
2016 Q4 Airport Economy " $896,251 " " 5,480 "
2016 Q1 Downtown Economy " $701,460 " " 5,151 "
2015 Q3 Airport Economy " $685,248 " " 5,017 "
2016 Q4 Downtown Economy " $687,844 " " 4,848 "
2016 Q3 Downtown Economy " $665,548 " " 4,799 "
2016 Q2 Downtown Economy " $626,232 " " 4,550 "
2015 Q4 Airport Economy " $597,979 " " 4,343 "
2015 Q4 Airport Premium " $619,900 " " 4,221 "
2016 Q3 Airport Premium " $643,168 " " 4,164 "
2015 Q4 Downtown Premium " $582,504 " " 4,155 "
2017 Q1 Airport Premium " $663,276 " " 4,106 "
2017 Q2 Airport Premium " $674,672 " " 4,090 "
2016 Q2 Airport Premium " $585,156 " " 3,850 "
2017 Q2 Downtown Economy " $561,124 " " 3,824 "
2016 Q3 Airport Economy " $579,947 " " 3,740 "
2016 Q1 Airport Premium " $552,324 " " 3,695 "
2015 Q3 Downtown Premium " $504,800 " " 3,657 "
2015 Q4 Downtown Economy " $496,840 " " 3,655 "
2015 Q2 Airport Economy " $468,791 " " 3,541 "
2016 Q1 Airport Economy " $487,124 " " 3,475 "
2015 Q1 Airport Economy " $438,521 " " 3,456 "
2016 Q2 Downtown Premium " $488,588 " " 3,350 "
2017 Q2 Airport Economy " $581,071 " " 3,349 "
2015 Q2 Downtown Premium " $455,424 " " 3,341 "
2016 Q4 Airport Premium " $527,900 " " 3,327 "
2015 Q3 Airport Premium " $471,816 " " 3,259 "
2016 Q3 Downtown Premium " $483,256 " " 3,250 "
2016 Q1 Downtown Premium " $415,016 " " 2,898 "
2015 Q2 Downtown Economy " $370,128 " " 2,897 "
2015 Q1 Downtown Economy " $349,852 " " 2,874 "
2016 Q4 Downtown Premium " $421,120 " " 2,804 "
2017 Q1 Downtown Premium " $422,288 " " 2,750 "
2015 Q1 Downtown Premium " $345,952 " " 2,589 "
2015 Q1 Airport Premium " $351,060 " " 2,558 "
2016 Q2 Airport Economy " $359,781 " " 2,323 "
2015 Q2 Airport Premium " $296,120 " " 2,099 "
2017 Q2 Downtown Premium " $321,768 " " 2,049 "
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
The Excel solution is attached.Please, remember to complete steps 1 to 4 with your personal details as contained in the instruction.Kindly let me know if you require further explanation.
Name:
Class/Section:
Project:
Date Due:
xxxxx
xxxxx
xxxxx
xxxxx
Year
2016
2016
2016
2016
2016
2016
2016
2016
2016
2016
2016
2016
2016
2016
2016
2016
Quarter
Q4
Q1
Q4
Q3
Q2
Q3
Q2
Q3
Q1
Q1
Q2
Q4
Q3
Q1
Q4
Q2
Location
Airport
Downtown
Downtown
Downtown
Downtown
Airport
Airport
Airport
Airport
Airport
Downtown
Airport
Downtown
Downtown
Downtown
Airport
CarClass
Economy
Economy
Economy
Economy
Economy
Premium
Premium
Economy
Premium
Economy
Premium
Premium
Premium
Premium
Premium
Economy
Revenue
NumCars
$896,251
5,480
$701,460
5,151
$687,844
4,848
$665,548
4,799
$626,232
4,550
$643,168
4,164
$585,156
3,850
$579,947
3,740
$552,324
3,695
$487,...