国际酒店前台日报表.xls

daily performance report 1st8th15th22nd29th 2nd9th16th23rd30th 3rd10th17th24th31st 4th11th18th25thtrend 5rh12th19th26thhh redemption 6th13th20th27th 7th14th21st28th january index monthly performance january occupancy occupied rooms vacant rooms average room rate revpar revenue guests in house overall performance month to date plan017,5460.000 brm017,5460.000 forecast 1017,5460.000 forecast 2017,5460.000 forecast 3017,5460.000 actual#ref!#ref!#ref!# #div/0!#ref! thursday1st0.00%0566#div/0! #div/0!#div/0!0 friday2nd0.00%0566#div/0! #div/0!#div/0!0 saturday3rd#ref!#ref!#ref!#ref!#ref!#ref!#ref! sunday4th#ref!#ref!#ref!#ref!#ref!#ref!#ref! monday5th#ref!#ref!#ref!#ref!#ref!#ref!#ref! tuesday6th#ref!#ref!#ref!#ref!#ref!#ref!#ref! wednesday7th#ref!#ref!#ref!#ref!#ref!#ref!#ref! thursday8th#ref!#ref!#ref!#ref!#ref!#ref!#ref! friday9th#ref!#ref!#ref!#ref!#ref!#ref!#ref! saturday10th#ref!#ref!#ref!#ref!#ref!#ref!#ref! sunday11th#ref!#ref!#ref!#ref!#ref!#ref!#ref! monday12th#ref!#ref!#ref!#ref!#ref!#ref!#ref! tuesday13th#ref!#ref!#ref!#ref!#ref!#ref!#ref! wednesday14th#ref!#ref!#ref!#ref!#ref!#ref!#ref! thursday15th#ref!#ref!#ref!#ref!#ref!#ref!#ref! friday16th#ref!#ref!#ref!#ref!#ref!#ref!#ref! saturday17th#ref!#ref!#ref!#ref!#ref!#ref!#ref! sunday18th#ref!#ref!#ref!#ref!#ref!#ref!#ref! monday19th#ref!#ref!#ref!#ref!#ref!#ref!#ref! tuesday20th#ref!#ref!#ref!#ref!#ref!#ref!#ref! wednesday21st#ref!#ref!#ref!#ref!#ref!#ref!#ref! thursday22nd#ref!#ref!#ref!#ref!#ref!#ref!#ref! friday23rd#ref!#ref!#ref!#ref!#ref!#ref!#ref! saturday24th#ref!#ref!#ref!#ref!#ref!#ref!#ref! sunday25th#ref!#ref!#ref!#ref!#ref!#ref!#ref! monday26th#ref!#ref!#ref!#ref!#ref!#ref!#ref! tuesday27th#ref!#ref!#ref!#ref!#ref!#ref!#ref! wednesday28th#ref!#ref!#ref!#ref!#ref!#ref!#ref! thursday29th#ref!#ref!#ref!#ref!#ref!#ref!#ref! friday30th#ref!#ref!#ref!#ref!#ref!#ref!#ref! saturday31st#ref!#ref!#ref!#ref!#ref!#ref!#ref! total available rooms17,546 market segments occupancy 1234 5678 9 10 11 1213 14 15 1617 18 1920 21 22 2324 25 26 2728 29 30 31 50.00% 55.00% 60.00% 65.00% 70.00% 75.00% 80.00% 85.00% 90.00% 95.00% 100.00% occupied rooms 123456789 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 77 87 97 107 117 127 137 147 average room rate 123456789 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 500.00 550.00 600.00 650.00 700.00 750.00 800.00 850.00 900.00 revpar 123456789 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 500.00 550.00 600.00 650.00 700.00 750.00 800.00 850.00 900.00 revenue 12345678 9 10 11 12 13 14 15 1617 18 19 20 21 22 2324 25 26 27 28 29 30 31 65,000 75,000 85,000 95,000 105,000 115,000 125,000 135,000 guests in house 12345678910 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 150 170 190 210 230 250 270 fit 1357911 13 1517 19 2123 25 2729 31 10% 20% 30% 40% 50% 60% corporate 135791113151719212325272931 0% 5% 10% 15% 20% 25% 30% tour / iw 1357911 13 1517 19 2123 25 2729 31 10% 20% 30% 40% 50% 60% fit discount 1357911 13 1517 19 2123 25 2729 31 0% 5% 10% 15% 20% 25% fit 1357911 13 1517 19 2123 25 2729 31 10% 20% 30% 40% 50% 60% corporate 135791113151719212325272931 0% 5% 10% 15% 20% 25% 30% tour / iw 1357911 13 1517 19 2123 25 2729 31 10% 20% 30% 40% 50% 60% fit discount 1357911 13 1517 19 2123 25 2729 31 0% 5% 10% 15% 20% 25% market segment fit corporate meetings non-tour tour / iw package fit discount contract other room categories qr td kd ks qx kx ke front desk statistics 1 2 3 4 5 6 7 8 9 10 11 1213 1415 16 1718 1920 2122 2324 2526 27 2829 3031 0 0 0 0 0 1 1 1 1 1 1 same day reservations walk-in extensions same day cancellations no show early departures 1-11-1月月-07-07 daily performance report todaymtdfront desk statisticstodaymtdmarket segmenttodaymonth to date occupancy0.00%nasame day reservationsnapick-upsummaryroomsarrmix %roomsarrmix % average room rate#div/0!nawalk-inna0fit0#div/0!#div/0!nanana rev. p.a.r0.00naextensionsnacorporate0#div/0!#div/0!nanana total arrivalsnameetings0#div/0!#div/0!nanana available rooms154nasame day cxlnadrop-offnon tour00.00#div/0!nanana occupied - hu + comp.nano showna0tour / iw package0#div/0!#div/0!nanana complimentarynaearly departuresnafit discount0#div/0!#div/0!nanana house usenatotal departuresnacontract0#div/0!#div/0!nanana vacantnaother (j1d)00.00#div/0!nanana o.o.o / o.o.snanareservations takennatotal-#div/0!#div/0!nanana number of cancellationsna guest countnaaverage length of stay#div/0!namarket segmenttodaymonth to date rooms occupiednacomparisonroomsarrmix %roomsarrmix % double occupancynahhonours statisticstodaym-t-dhh red.fit #div/0!#div/0!nanana rooms occupiedna0corporate local#div/0!#div/0!nanana rooms revenuenaaverage rate#div/0!na0corporate preferred#div/0!#div/0!nanana potential revenuenaocc.% (vs. hotel)#div/0!na#div/0!corporate full#div/0!#div/0!nanana actual vs potential %#div/0!na total hhonours revenue na0government#div/0!#div/0!nanana meetings corporate#div/0!#div/0!nanana room statisticsqrtdkdksqxkxketotalmeetings non corporate#div/0!#div/0!nanana rooms occupied0convention congress#div/0!#div/0!nanana average rate#div/0!#div/0!#div/0!#div/0!#div/0!#div/0!#div/0!#div/0!incentives#div/0!#div/0!nanana occ.% (vs. category)0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%one-shot non tour#div/0!#div/0!nanana occ.% (vs. hotel)#div/0!#div/0!#div/0!#div/0!#div/0!#div/0!#div/0!0.00%packages#div/0!#div/0!nanana total revenue0.00 travel industry industry #div/0!#div/0!nanana travel industry group#div/0!#div/0!nanana indexmarket sharehiltonsheratoninterconhyattmarriotttotalindividual whole sale#div/0!#div/0!nanana available rooms1542552874143511461one-shot tour#div/0!#div/0!nanana last night occupied rooms00tour series#div/0!#div/0!nanana occupancy0.00%0.00%0.00%0.00%0.00%0.00%hh redemption#div/0!#div/0!nanana average rate#div/0!#div/0!fit discounted rate#div/0!#div/0!nanana revpar0.000.000.000.000.000.00airline crew#div/0!#div/0!nanana rooms revenue000000contract#div/0!#div/0!nanana m-share (hilton set)#div/0!#div/0!#div/0!#div/0!#div/0!long term#div/0!#div/0!nanana hiltonsheratoninterconhyattmarriotttotalother (j1d)#div/0!#div/0!nanana month to date 1542552874143511461total0#div/0!0.00%nanana occupied rooms000000 occupancy0.00%0.00%0.00%0.00%0.00%0.00%todays forecasthiltonsheratoninterconhyattmarriott average rate#div/0!#div/0!#div/0!#div/0!#div/0!#div/0!expected occupancy revpar0.000.000.000.000.000.00expected average rate rooms revenue000000expected occupied rooms0%0%0%0%0% m-share (hilton set)#div/0!#div/0!#div/0!#div/0!#div/0!expected total revenue- 2-12-1月月-07-07 daily performance report todaymtdfront desk statisticstodaymtdmarket segmenttodaymonth to date occupancy0.00%0.00%same day reservations0pick-upsummaryroomsarrmix %roomsarrmix % average room rate#div/0!#div/0!walk-in00fit0#div/0!#div/0!0#div/0!#div/0! rev. p.a.r0.000.00extensions0corporate0#div/0!#div/0!0#div/0!#div/0! total arrivals0meetings0#div/0!#div/0!0#div/0!#div/0! available rooms154308same day cxl0drop-offnon tour0#div/0!#div/0!0#div/0!#div/0! occupied - hu + comp.0no show00tour / iw package0#div/0!#div/0!0#div/0!#div/0! complimentary0early departures0fit discount0#div/0!#div/0!0#div/0!#div/0! house use0total departures0contract0#div/0!#div/0!0#div/0!#div/0! vacant0other (j1d)0#div/0!#div/0!0#div/0!#div/0! o.o.o / o.o.s00reservations taken0total-#div/0!#div/0!-#div/0!#div/0! number of cancellations0 guest count0average length of stay#div/0!#div/0!market segmenttodaymonth to date rooms occupied0comparisonroomsarrmix %roomsarrmix % double occupancyhhonours statisticstodaym-t-dhh red.fit #div/0!#div/0!0#div/0!#div/0! rooms occupied00corporate local#div/0!#div/0!0#div/0!#div/0! rooms revenue0average rate#div/0!#div/0!0corporate preferred#div/0!#div/0!0#div/0!#div/0! potential revenue0occ.% (vs. hotel)#div/0!#div/0!#div/0!corporate full#div/0!#div/0!0#div/0!#div/0! actual vs potential %#div/0!#div/0! total hhonours revenue 00government#div/0!#div/0!0#div/0!#div/0! meetings corporate#div/0!#div/0!0#div/0!#div/0! room statisticsqrtdkdksqxkxketotalmeetings non corporate#div/0!#div/0!0#div/0!#div/0! rooms occupied0convention congress#div/0!#div/0!0#div/0!#div/0! average rate#div/0!#div/0!#div/0!#div/0!#div/0!#div/0!#div/0!#div/0!incentives#div/0!#div/0!0#div/0!#div/0! occ.% (vs. category)0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%one-shot non tour#div/0!#div/0!0#div/0!#div/0! occ.% (vs. hotel)#div/0!#div/0!#div/0!#div/0!#div/0!#div/0!#div/0!0.00%packages#div/0!#div/0!0#div/0!#div/0! total revenue0.00 travel industry industry #div/0!#div/0!0#div/0!#div/0! travel industry group#div/0!#div/0!0#div/0!#div/0! indexmarket sharehiltonsheratoninterconhyattmarriotttotalindividual whole sale#div/0!#div/0!0#div/0!#div/0! available rooms1542552874143511461one-shot tour#div/0!#div/0!0#di