Red Sunset Hotel Chain Exercise

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 7

Hotel Department Year Quarter Income Expenditures

Jackson Hotel Rooms 2006 Q 1 31144 23904


Jackson Hotel Restaurant 2006 Q1 44103 49342
Jackson Hotel Catering 2006 Q 1 46914 24917
Jackson Hotel Conference Facilities 2006 Q 1 37515 23166
Jackson Hotel Rooms 2006 Q 1 30869 51256
Miguel Ranch Restaurant 2006 Q 1 29471 44079
Miguel Ranch Catering 2006 Q 1 22879 43751
Miguel Ranch Conference Facilities 2006 Q 1 52633 19403
Miguel Ranch Rooms 2006 Q 1 26354 54935
Miguel Ranch Restaurant 2006 Q 1 52826 23643
Pengueno Place Catering 2006 Q 1 51528 18509
Pengueno Place Conference Facilities 2006 Q 1 38829 31137
Pengueno Place Rooms 2006 Q 1 18753 30910
Pengueno Place Restaurant 2006 Q 1 38482 46430
Pengueno Place Catering 2006 Q 2 48352 49523
Jackson Hotel Rooms 2006 Q 2 41917 48320
Jackson Hotel Restaurant 2006 Q 2 32315 49727
Jackson Hotel Catering 2006 Q 2 54784 24623
Jackson Hotel Conference Facilities 2006 Q 2 19661 47049
Jackson Hotel Rooms 2006 Q 2 43475 42408
Miguel Ranch Restaurant 2006 Q 2 36996 23972
Miguel Ranch Catering 2006 Q 2 53398 18543
Miguel Ranch Conference Facilities 2006 Q 2 32953 42993
Miguel Ranch Rooms 2006 Q 2 41360 40488
Miguel Ranch Restaurant 2006 Q 2 26803 48723
Pengueno Place Catering 2006 Q 2 32616 43997
Pengueno Place Conference Facilities 2006 Q 2 20408 29891
Pengueno Place Rooms 2006 Q 2 18110 43806
Pengueno Place Restaurant 2006 Q 2 20721 20407
Pengueno Place Catering 2006 Q 2 41426 28878
Jackson Hotel Rooms 2006 Q 3 33929 23112
Jackson Hotel Restaurant 2006 Q 3 40960 24256
Jackson Hotel Catering 2006 Q 3 30524 22579
Jackson Hotel Conference Facilities 2006 Q 3 48850 38725
Jackson Hotel Rooms 2006 Q 3 37782 31219
Jackson Hotel Rooms 2006 Q 3 44861 26809
Jackson Hotel Restaurant 2006 Q 3 25557 54126
Jackson Hotel Catering 2006 Q 3 42209 18743
Jackson Hotel Conference Facilities 2006 Q 3 28486 26171
Jackson Hotel Rooms 2006 Q 3 49194 51407
Miguel Ranch Restaurant 2006 Q 3 31659 31313
Miguel Ranch Catering 2006 Q 3 31342 19455
Miguel Ranch Conference Facilities 2006 Q 3 37534 54437
Miguel Ranch Rooms 2006 Q 3 25004 33547
Miguel Ranch Restaurant 2006 Q 3 20274 54391
Pengueno Place Catering 2006 Q 4 22366 54639
Pengueno Place Conference Facilities 2006 Q 4 27394 39998
Pengueno Place Rooms 2006 Q 4 48351 40421
Pengueno Place Restaurant 2006 Q 4 37535 25967
Pengueno Place Catering 2006 Q 4 30945 36392
Jackson Hotel Rooms 2006 Q 4 48760 49795
Jackson Hotel Restaurant 2006 Q 4 34839 17415
Jackson Hotel Catering 2006 Q 4 40621 37814
Jackson Hotel Conference Facilities 2006 Q 4 45569 24469
Jackson Hotel Rooms 2006 Q 4 25830 20635
Miguel Ranch Restaurant 2006 Q 4 23337 45871
Miguel Ranch Catering 2006 Q 4 23164 16108
Miguel Ranch Conference Facilities 2006 Q 4 18286 38238
Miguel Ranch Rooms 2006 Q 4 20269 53610
Miguel Ranch Restaurant 2006 Q 4 24629 42659
Pengueno Place Catering 2005 Q 1 19291 51677
Pengueno Place Conference Facilities 2005 Q1 22198 38104
Pengueno Place Rooms 2005 Q 1 53055 47651
Pengueno Place Restaurant 2005 Q 1 47545 33805
Pengueno Place Catering 2005 Q 1 18311 33457
Jackson Hotel Rooms 2005 Q 1 33545 38304
Jackson Hotel Restaurant 2005 Q 1 48763 46338
Jackson Hotel Catering 2005 Q 1 21705 17663
Jackson Hotel Conference Facilities 2005 Q 1 49671 39852
Jackson Hotel Rooms 2005 Q 1 52404 24383
Jackson Hotel Rooms 2005 Q 1 42979 46249
Jackson Hotel Restaurant 2005 Q 1 42532 48392
Jackson Hotel Catering 2005 Q 1 42550 38200
Jackson Hotel Conference Facilities 2005 Q 1 44344 30099
Jackson Hotel Rooms 2005 Q 2 34338 24394
Miguel Ranch Restaurant 2005 Q 2 41593 20368
Miguel Ranch Catering 2005 Q 2 25174 34170
Miguel Ranch Conference Facilities 2005 Q 2 49861 25631
Miguel Ranch Rooms 2005 Q 2 24836 22555
Miguel Ranch Restaurant 2005 Q 2 38839 16006
Pengueno Place Catering 2005 Q 2 47682 35908
Pengueno Place Conference Facilities 2005 Q 2 37024 34694
Pengueno Place Rooms 2005 Q 2 35756 28814
Pengueno Place Restaurant 2005 Q 2 28553 25465
Pengueno Place Catering 2005 Q 2 25012 41465
Jackson Hotel Rooms 2005 Q 2 28800 49210
Jackson Hotel Restaurant 2005 Q 2 20319 51344
Jackson Hotel Catering 2005 Q 2 44578 46453
Jackson Hotel Conference Facilities 2005 Q 2 53362 33295
Jackson Hotel Rooms 2005 Q 2 31279 27104
Miguel Ranch Restaurant 2005 Q 3 34293 48713
Miguel Ranch Catering 2005 Q 3 23765 29024
Miguel Ranch Conference Facilities 2005 Q 3 40071 34775
Miguel Ranch Rooms 2005 Q 3 33839 32532
Miguel Ranch Restaurant 2005 Q 3 21241 51102
Pengueno Place Catering 2005 Q 3 31231 22322
Pengueno Place Conference Facilities 2005 Q 3 53639 46894
Pengueno Place Rooms 2005 Q 3 49466 27740
Pengueno Place Restaurant 2005 Q 3 32310 32240
Pengueno Place Catering 2005 Q 3 23011 42709
Jackson Hotel Rooms 2005 Q 3 16344 23118
Jackson Hotel Restaurant 2005 Q 3 30165 42568
Jackson Hotel Catering 2005 Q 3 51242 37138
Jackson Hotel Conference Facilities 2005 Q 3 28465 49507
Jackson Hotel Rooms 2005 Q 3 49378 20972
Jackson Hotel Rooms 2005 Q 4 19925 16932
Jackson Hotel Restaurant 2005 Q 4 21112 16598
Jackson Hotel Catering 2005 Q 4 24168 16070
Jackson Hotel Conference Facilities 2005 Q 4 24233 24871
Jackson Hotel Rooms 2005 Q 4 47935 27255
Miguel Ranch Restaurant 2005 Q 4 38896 50806
Miguel Ranch Catering 2005 Q 4 21040 20593
Miguel Ranch Conference Facilities 2005 Q 4 54071 42329
Miguel Ranch Rooms 2005 Q 4 19778 29993
Miguel Ranch Restaurant 2005 Q 4 30389 29174
Pengueno Place Catering 2005 Q 4 42519 22852
Pengueno Place Conference Facilities 2005 Q 4 21122 32299
Pengueno Place Rooms 2005 Q 4 32662 52291
Pengueno Place Restaurant 2005 Q 4 25375 45214
Pengueno Place Catering 2005 Q 4 52547 25455
Jackson Hotel Rooms 2004 Q 1 20287 53241
Jackson Hotel Restaurant 2004 Q1 18877 31979
Jackson Hotel Catering 2004 Q 1 33188 19035
Jackson Hotel Conference Facilities 2004 Q 1 41405 39452
Jackson Hotel Rooms 2004 Q 1 50245 28384
Miguel Ranch Restaurant 2004 Q 1 20769 25259
Miguel Ranch Catering 2004 Q 1 25490 46964
Miguel Ranch Conference Facilities 2004 Q 1 47940 33406
Miguel Ranch Rooms 2004 Q 1 27629 21782
Miguel Ranch Restaurant 2004 Q 1 32650 19549
Pengueno Place Catering 2004 Q 1 41375 43012
Pengueno Place Conference Facilities 2004 Q 1 45575 53495
Pengueno Place Rooms 2004 Q 1 18798 53181
Pengueno Place Restaurant 2004 Q 1 28895 19024
Pengueno Place Catering 2004 Q 2 44330 16945
Jackson Hotel Rooms 2004 Q 2 45190 47614
Jackson Hotel Restaurant 2004 Q 2 49030 35133
Jackson Hotel Catering 2004 Q 2 32384 38200
Jackson Hotel Conference Facilities 2004 Q 2 19280 19783
Jackson Hotel Rooms 2004 Q 2 33993 34397
Jackson Hotel Rooms 2004 Q 2 47933 34266
Jackson Hotel Restaurant 2004 Q 2 34628 30292
Jackson Hotel Catering 2004 Q 2 49741 48143
Jackson Hotel Conference Facilities 2004 Q 2 24466 38013
Jackson Hotel Rooms 2004 Q 2 46010 32372
Miguel Ranch Restaurant 2004 Q 2 20310 17141
Miguel Ranch Catering 2004 Q 2 44170 31904
Miguel Ranch Conference Facilities 2004 Q 2 38015 22510
Miguel Ranch Rooms 2004 Q 2 21304 24869
Miguel Ranch Restaurant 2004 Q 2 45216 36509
Pengueno Place Catering 2004 Q 3 29879 19746
Pengueno Place Conference Facilities 2004 Q 3 40147 31845
Pengueno Place Rooms 2004 Q 3 19117 40160
Pengueno Place Restaurant 2004 Q 3 43493 39856
Pengueno Place Catering 2004 Q 3 42038 52399
Jackson Hotel Rooms 2004 Q 3 19794 20238
Jackson Hotel Restaurant 2004 Q 3 17146 29387
Jackson Hotel Catering 2004 Q 3 49088 29998
Jackson Hotel Conference Facilities 2004 Q 3 24895 54426
Jackson Hotel Rooms 2004 Q 3 36192 29642
Miguel Ranch Restaurant 2004 Q 3 44631 47612
Miguel Ranch Catering 2004 Q 3 21931 33776
Miguel Ranch Conference Facilities 2004 Q 3 28620 36926
Miguel Ranch Rooms 2004 Q 3 33636 47147
Miguel Ranch Restaurant 2004 Q 3 38706 44470
Pengueno Place Catering 2004 Q 4 32596 34590
Pengueno Place Conference Facilities 2004 Q 4 51658 38830
Pengueno Place Rooms 2004 Q 4 53582 38658
Pengueno Place Restaurant 2004 Q 4 27703 32518
Pengueno Place Catering 2004 Q 4 21860 16750
Jackson Hotel Rooms 2004 Q 4 49828 32812
Jackson Hotel Restaurant 2004 Q 4 18840 26939
Jackson Hotel Catering 2004 Q 4 23757 22916
Jackson Hotel Conference Facilities 2004 Q 4 31936 48070
Jackson Hotel Rooms 2004 Q 4 40692 29555
Jackson Hotel Rooms 2004 Q 4 38996 34638
Jackson Hotel Restaurant 2004 Q 4 44574 43295
Jackson Hotel Catering 2004 Q 4 52315 45821
Jackson Hotel Conference Facilities 2004 Q 4 26065 34456
Jackson Hotel Rooms 2004 Q 4 37451 25718
Miguel Ranch Restaurant 2003 Q 1 50469 53156
Miguel Ranch Catering 2003 Q1 50784 37544
Miguel Ranch Conference Facilities 2003 Q 1 48344 21245
Miguel Ranch Rooms 2003 Q 1 31733 21888
Miguel Ranch Restaurant 2003 Q 1 33659 39801
Pengueno Place Catering 2003 Q 1 50423 31681
Pengueno Place Conference Facilities 2003 Q 1 20814 42264
Pengueno Place Rooms 2003 Q 1 42700 29747
Pengueno Place Restaurant 2003 Q 1 23833 41784
Pengueno Place Catering 2003 Q 1 29707 40662
Jackson Hotel Rooms 2003 Q 1 28899 49310
Jackson Hotel Restaurant 2003 Q 1 52423 40673
Jackson Hotel Catering 2003 Q 1 22958 49766
Jackson Hotel Conference Facilities 2003 Q 1 37735 19303
Jackson Hotel Rooms 2003 Q 2 32583 45569
Miguel Ranch Restaurant 2003 Q 2 35007 16441
Miguel Ranch Catering 2003 Q 2 51363 34520
Miguel Ranch Conference Facilities 2003 Q 2 20861 43891
Miguel Ranch Rooms 2003 Q 2 28983 22513
Miguel Ranch Restaurant 2003 Q 2 25658 52810
Pengueno Place Catering 2003 Q 2 32743 52753
Pengueno Place Conference Facilities 2003 Q 2 29566 33529
Pengueno Place Rooms 2003 Q 2 37123 20641
Pengueno Place Restaurant 2003 Q 2 25457 51093
Pengueno Place Catering 2003 Q 2 44037 47313
Jackson Hotel Rooms 2003 Q 2 37057 48852
Jackson Hotel Restaurant 2003 Q 2 41915 28465
Jackson Hotel Catering 2003 Q 2 19436 49880
Jackson Hotel Conference Facilities 2003 Q 2 40924 39439
Jackson Hotel Rooms 2003 Q 2 51241 53317
Jackson Hotel Rooms 2003 Q 3 31700 50588
Jackson Hotel Restaurant 2003 Q 3 25443 37635
Jackson Hotel Catering 2003 Q 3 26703 25657
Jackson Hotel Conference Facilities 2003 Q 3 36246 21400
Jackson Hotel Rooms 2003 Q 3 17407 42647
Miguel Ranch Restaurant 2003 Q 3 42386 40355
Miguel Ranch Catering 2003 Q 3 32245 30673
Miguel Ranch Conference Facilities 2003 Q 3 28556 51895
Miguel Ranch Rooms 2003 Q 3 18000 52809
Miguel Ranch Restaurant 2003 Q 3 32249 42526
Pengueno Place Catering 2003 Q 3 33174 36069
Pengueno Place Conference Facilities 2003 Q 3 41493 26757
Pengueno Place Rooms 2003 Q 3 35135 54175
Pengueno Place Restaurant 2003 Q 3 39022 27430
Pengueno Place Catering 2003 Q 3 35162 32006
Jackson Hotel Rooms 2003 Q 4 23357 24162
Jackson Hotel Restaurant 2003 Q 4 46174 23918
Jackson Hotel Catering 2003 Q 4 27593 16455
Jackson Hotel Conference Facilities 2003 Q 4 51706 22828
Jackson Hotel Rooms 2003 Q 4 53194 22386
Miguel Ranch Restaurant 2003 Q 4 24927 23682
Miguel Ranch Catering 2003 Q 4 39515 17872
Miguel Ranch Conference Facilities 2003 Q 4 54721 24195
Miguel Ranch Rooms 2003 Q 4 32977 53230
Miguel Ranch Restaurant 2003 Q 4 26539 51999
Pengueno Place Catering 2003 Q 4 44124 47392
Pengueno Place Conference Facilities 2003 Q 4 49031 31124
Pengueno Place Rooms 2003 Q 4 50830 40956
Pengueno Place Restaurant 2003 Q 4 21591 34497
Pengueno Place Catering 2003 Q 4 32838 26093
Jackson Hotel Rooms 2002 Q 1 34443 46345
Jackson Hotel Restaurant 2002 Q1 38500 16462
Jackson Hotel Catering 2002 Q 1 47314 49964
Jackson Hotel Conference Facilities 2002 Q 1 53325 40118
Jackson Hotel Rooms 2002 Q 1 17561 30323
Jackson Hotel Rooms 2002 Q 1 26127 24236
Jackson Hotel Restaurant 2002 Q 1 22941 27725
Jackson Hotel Catering 2002 Q 1 23787 26098
Jackson Hotel Conference Facilities 2002 Q 1 39724 41500
Jackson Hotel Rooms 2002 Q 1 19327 49294
Miguel Ranch Restaurant 2002 Q 1 30450 46891
Miguel Ranch Catering 2002 Q 1 21428 19256
Miguel Ranch Conference Facilities 2002 Q 1 35564 26499
Miguel Ranch Rooms 2002 Q 1 47668 54507
Miguel Ranch Restaurant 2002 Q 2 49932 30947
Pengueno Place Catering 2002 Q 2 48645 32064
Pengueno Place Conference Facilities 2002 Q 2 19854 22261
Pengueno Place Rooms 2002 Q 2 17650 28106
Pengueno Place Restaurant 2002 Q 2 42656 41091
Pengueno Place Catering 2002 Q 2 30282 48713
Jackson Hotel Rooms 2002 Q 2 49512 16109
Jackson Hotel Restaurant 2002 Q 2 53755 24514
Jackson Hotel Catering 2002 Q 2 16215 18870
Jackson Hotel Conference Facilities 2002 Q 2 42595 40882
Jackson Hotel Rooms 2002 Q 2 45290 19365
Miguel Ranch Restaurant 2002 Q 2 50687 49228
Miguel Ranch Catering 2002 Q 2 20091 16025
Miguel Ranch Conference Facilities 2002 Q 2 53559 33490
Miguel Ranch Rooms 2002 Q 2 30654 32012
Miguel Ranch Restaurant 2002 Q 2 29277 36552
Pengueno Place Catering 2002 Q 3 17774 36121
Pengueno Place Conference Facilities 2002 Q 3 38840 46838
Pengueno Place Rooms 2002 Q 3 43456 26335
Pengueno Place Restaurant 2002 Q 3 35536 36928
Pengueno Place Catering 2002 Q 3 44525 28404
Jackson Hotel Rooms 2002 Q 3 16517 34761
Jackson Hotel Restaurant 2002 Q 3 29372 29713
Jackson Hotel Catering 2002 Q 3 37666 40303
Jackson Hotel Conference Facilities 2002 Q 3 33372 50466
Jackson Hotel Rooms 2002 Q 3 44244 42740
Jackson Hotel Rooms 2002 Q 3 21712 34440
Jackson Hotel Restaurant 2002 Q 3 26033 33232
Jackson Hotel Catering 2002 Q 3 16647 21137
Jackson Hotel Conference Facilities 2002 Q 3 34487 49912
Jackson Hotel Rooms 2002 Q 3 47131 54065
Miguel Ranch Restaurant 2002 Q 4 26956 25292
Miguel Ranch Catering 2002 Q 4 28238 33538
Miguel Ranch Conference Facilities 2002 Q 4 48558 18572
Miguel Ranch Rooms 2002 Q 4 50471 27484
Miguel Ranch Restaurant 2002 Q 4 24367 45253
Pengueno Place Catering 2002 Q 4 28807 51621
Pengueno Place Conference Facilities 2002 Q 4 25861 18484
Pengueno Place Rooms 2002 Q 4 54609 51908
Pengueno Place Restaurant 2002 Q 4 47364 19456
Pengueno Place Catering 2002 Q 4 31665 51176
Jackson Hotel Rooms 2002 Q 4 52455 23587
Jackson Hotel Restaurant 2002 Q 4 35875 49411
Jackson Hotel Catering 2002 Q 4 49043 51909
Jackson Hotel Conference Facilities 2002 Q 4 36831 18196
Jackson Hotel Rooms 2002 Q 4 28722 32500

You might also like