Excel Project

profilepipernan
fall2018rentalcars.docx

Year Quarter Location CarClass Revenue NumCars

2017 Q1 Downtown Economy "$977,700" " 6,290 "

2017 Q1 Airport Economy "$1,047,832" " 5,963 "

2015 Q3 Downtown Economy "$805,325" " 5,577 "

2016 Q4 Airport Economy "$959,953" " 5,413 "

2016 Q1 Downtown Economy "$751,466" " 5,080 "

2015 Q3 Airport Economy "$734,028" " 4,922 "

2016 Q4 Downtown Economy "$736,727" " 4,796 "

2016 Q3 Downtown Economy "$712,259" " 4,715 "

2016 Q2 Downtown Economy "$670,449" " 4,472 "

2015 Q4 Airport Economy "$640,474" " 4,278 "

2017 Q2 Downtown Economy "$601,257" " 3,758 "

2016 Q3 Airport Economy "$621,108" " 3,710 "

2015 Q4 Downtown Economy "$532,065" " 3,610 "

2015 Q2 Airport Economy "$502,546" " 3,489 "

2016 Q1 Airport Economy "$521,919" " 3,445 "

2015 Q1 Airport Economy "$470,125" " 3,408 "

2017 Q2 Airport Economy "$622,565" " 3,324 "

2015 Q2 Downtown Economy "$396,848" " 2,881 "

2015 Q1 Downtown Economy "$375,118" " 2,849 "

2016 Q2 Airport Economy "$385,122" " 2,280 "

2015 Q4 Airport Premium "$663,901" " 4,055 "

2016 Q3 Airport Premium "$688,440" " 4,045 "

2015 Q4 Downtown Premium "$624,053" " 4,016 "

2017 Q1 Airport Premium "$710,376" " 3,957 "

2017 Q2 Airport Premium "$722,782" " 3,961 "

2016 Q2 Airport Premium "$627,078" " 3,711 "

2016 Q1 Airport Premium "$591,816" " 3,570 "

2015 Q3 Downtown Premium "$540,217" " 3,533 "

2016 Q2 Downtown Premium "$523,205" " 3,247 "

2015 Q2 Downtown Premium "$487,629" " 3,241 "

2016 Q4 Airport Premium "$565,096" " 3,228 "

2015 Q3 Airport Premium "$505,403" " 3,148 "

2016 Q3 Downtown Premium "$517,183" " 3,150 "

2016 Q1 Downtown Premium "$444,247" " 2,798 "

2016 Q4 Downtown Premium "$451,490" " 2,698 "

2017 Q1 Downtown Premium "$452,565" " 2,685 "

2015 Q1 Downtown Premium "$370,679" " 2,514 "

2015 Q1 Airport Premium "$375,811" " 2,466 "

2015 Q2 Airport Premium "$317,110" " 2,056 "

2017 Q2 Downtown Premium "$345,020" " 1,996 "

2015 Q4 Airport SUV "$663,548" " 4,299 "

2016 Q3 Airport SUV "$688,301" " 4,263 "

2015 Q4 Downtown SUV "$623,328" " 4,264 "

2017 Q1 Airport SUV "$710,588" " 4,166 "

2017 Q2 Airport SUV "$722,606" " 4,160 "

2016 Q2 Airport SUV "$626,757" " 3,943 "

2016 Q1 Airport SUV "$591,590" " 3,779 "

2015 Q3 Downtown SUV "$540,623" " 3,758 "

2016 Q2 Downtown SUV "$523,359" " 3,400 "

2015 Q2 Downtown SUV "$487,843" " 3,427 "

2016 Q4 Airport SUV "$565,293" " 3,381 "

2015 Q3 Airport SUV "$504,888" " 3,349 "

2016 Q3 Downtown SUV "$518,004" " 3,345 "

2016 Q1 Downtown SUV "$444,127" " 2,939 "

2016 Q4 Downtown SUV "$450,725" " 2,846 "

2017 Q1 Downtown SUV "$451,944" " 2,833 "

2015 Q1 Downtown SUV "$371,061" " 2,646 "

2015 Q1 Airport SUV "$376,497" " 2,621 "

2015 Q2 Airport SUV "$317,066" " 2,151 "

2017 Q2 Downtown SUV "$344,938" " 2,078 "

2015 Q4 Airport Hybrid "$663,467" " 4,139 "

2016 Q3 Airport Hybrid "$688,782" " 4,089 "

2015 Q4 Downtown Hybrid "$623,719" " 4,109 "

2017 Q1 Airport Hybrid "$709,847" " 4,050 "

2017 Q2 Airport Hybrid "$722,481" " 4,018 "

2016 Q2 Airport Hybrid "$626,363" " 3,807 "

2016 Q1 Airport Hybrid "$591,561" " 3,669 "

2015 Q3 Downtown Hybrid "$540,387" " 3,597 "

2016 Q2 Downtown Hybrid "$523,471" " 3,320 "

2015 Q2 Downtown Hybrid "$488,036" " 3,281 "

2016 Q4 Airport Hybrid "$565,829" " 3,261 "

2015 Q3 Airport Hybrid "$505,782" " 3,236 "

2016 Q3 Downtown Hybrid "$517,267" " 3,210 "

2016 Q1 Downtown Hybrid "$444,554" " 2,867 "

2016 Q4 Downtown Hybrid "$450,842" " 2,757 "

2017 Q1 Downtown Hybrid "$452,493" " 2,702 "

2015 Q1 Downtown Hybrid "$370,963" " 2,554 "

2015 Q1 Airport Hybrid "$376,241" " 2,533 "

2015 Q2 Airport Hybrid "$317,492" " 2,106 "

2017 Q2 Downtown Hybrid "$344,374" " 2,033 "