Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please answer the question under the pivot table 3302,100 01 Q1 01 01 O2 02 6 1 $22 $351 $122.190 $370.120 $455.4 9 10 11

please answer the question under the pivot table
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
3302,100 01 Q1 01 01 O2 02 6 1 $22 $351 $122.190 $370.120 $455.4 9 10 11 12 13 114 15 16 12 $58057 $19.2 S304 BOC 54718 3917 $20.00 5582604 5610.900 Sum of Profit RowLabels Airport Economy Premium Downtown Economy Premium Grand Total Column Labels 2017 2018 2019 Grand Total 1914828 22912064 2459103.2 66651376 1127191.2 1218772.8 1359912 3705876 7876368 1072433610991912 29592616 18271464 20082072 2176100 6011453.6 1131582 1084788 11609664 33773424 6955584 923419.2 10151336 26341112 3741974.4 42.994136 4635203.2 126765912 04 01 19 50 R: 22 09 Art Ya 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2018 2018 2018 2018 2018 2018 2016 2018 2018 2018 2015 2018 2016 2018 2055 2018 2010 2009 2019 2012 2019 2019 2010 2019 2019 2010 2010 2010 2010 2019 2010 2010 24 135 20 Average of Revenue Column Labels Row Labels 2017 2011 2019 Grand Total Airport 480968 5890465626.512.25 565608.9167 Economy 469663 507822 566630 514705 Premium 492273 670271 5869945 616512.8333 Downtown 4531095 514566 559097.25 50892425 Economy 471495 451995 483736 469075 3333 Premium 434724 577137 63445855487731667 Grand Total 467038.35 55180625 592954.5 537266.5833 Local Care Airport Economy Airport Premium Downlown Economy Down Premium Airport Economy Airport Premium Downtown Economy Downtown Premium Airport Economy Airport Premium Downtown Economy Downtown Premium Airport Economy Airport Peonium Downtown Economy Downtown Premium Airport Economy Airport Premium Downtown Eco Downlown Premium Airport Premium Downtown Economy Down Prem Airport Economy Airport Premium Downtown Economy Downtown Premium Airport Economy Airport Promin Downtown Economy Downtown Premium Airport Economy Airport Premium Downtown Down Premium Airport Economy Airport Premium Downtowe Down Pramar Airport Ecoo Airport Pro Downtown Economy Down Premium Airport Economy Airport Demium Down Economy Downtown Premi 5701400 $415016 550234 M056 S230 3401 SSG 156 100.213 30665 33326 S43160 w 99 19 19 1111 NumeracowProfs 3.252 31 320.284 2.205 $200 951 1191 3705 5137301 20951 31477 5210.69 5142.400 4 $16283315 3.487 222.077 OS 40 $162 1703 5272.254 2.897 $177,672 51100 3.2141 $220 2200 DE 3581 $451 4200 S90 3.500 $28.00 $0.72 3.570 $213.4112025 1991 290101010 3,350 MO 3.190 5371, 040 57.500 2440 31945011291751 3761 $420,076 2004 2.40 $1000010 3024 8.3313122000 30 5104 5291634 3320 $37570504 3.51 519545 23,153 3440 $351004 $234002 3.282 32012 347 3.320 3210 3515 $102.300 25 3435 $385 DSM 3.00 222 3.327 $412,200 2007 $161.3 12522 3.371 5310 74021211160 30 1235 3.600 1547 1.013 $1,215 2253373 203 136310 292 5174.926 139.674 52344 1024 312170243 3061 3120 1200, 300 151 345 4500 1204110 33120 100002 3,000 123001 5912700 2014 2.700 12 2.75 1402 121 Question which categories Location or cards are more trofitable? 29 10 03 Answer 12 13 14 25 6 12 21,120 1527.900 . 5012.000 19 140 12 02 SES 2 SAJT 120 1217 14 MO 129972 SA 121.231 SO S421234 46 27 04 04 so S67656 Sum of Profit Row Labels Alrport Economy Premium Downtown Economy Premium Grand Total Column Labels 2017 2018 2019 Grand Total 1914828 2291206.4 2459103.2 6665137.6 1127191.2 1218772.8 1359912 3705876 787636.8 1072433.6 1099191.2 2959261.6 1827146.4 2008207.2 2176100 6011453.6 1131588 1084788 1160966.4 3377342.4 695558.4 923419.2 1015133.6 2634111.2 3741974.4 4299413.6 4635203.2 12676591.2 Average of Revenue Column Labels Row Labels 2017 2018 2019 Grand Total Airport 480968 589046.5 626812.25 565608.9167 Economy 469663 507822 566630 514705 Premium 492273 670271 686994.5 616512.8333 Downtown 453109.5 514566 559097.25 508924.25 Economy 471495 451995 483736 469075.3333 Premium 434724 577137 634458.5 548773.1667 Grand Total 467038.75 551806.25 592954.75 537266.5833 40 Question: Which categories Locations or car class are more profitable? 30 Answer: 20 100 Q R 1600000 1400000 Sum of Profit 1200000 1000000 30 000 2017 BODOCO 2015 2019 400000 200000 0 Economy Premium Economy Premium Downtown Airport Airport Downtow al 9167 4705 800000 8333 700000 Average of Revenue 00000 24.25 3333 1667 5833 500000 ODD 2012 2018 300000 20 2000 10000 D Economy Premium Economy Premium Downtown Airport

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Finance Capital Markets Financial Management And Investment Management

Authors: Frank J. Fabozzi, Pamela Peterson Drake

1st Edition

0470407352, 978-0470407356

More Books

Students also viewed these Finance questions