2009三亚亚龙湾铂尔曼酒店经营计划与预算

1、ACCOR ASIA BUDGET WORKSHEETS FOR YEAR 2009TABLE OF CONTENTSFile: Budget 2009 - Operating StatementSheetsContents1Contents2Instuctions3Budget Operating Statement Summary4Monthly Statistics Comparison5Summary Market Mix by Segment6Room Department Operating Statement Detail7 to 21Food & Beverage Op

2、erating Statement Detail22Sport & Recreation Operating Statement Detail23Transportation Operating Statement Detail24Telephone Operating Statement Detail25Guest Laundry Operating Statement Detail26House Laundry Operating Statement Detail27Business Centre Operating Statement Detail28Shop & Oth

3、er Income Operating Statement Detail29Sales & Marketing Operating Statement Detail30Human Resources Operating Statement Detail31Staff Canteen Operating Statement Detail32Administration Operating Statement Detail33Engineering Operating Statement DetailFile: Budget 2009 - Manning ExpensesSheetsCon

4、tents1Service Charge Allocation2Total Manning Summary3 to 7Room Manning Expenses8 to 23Food & Beverage Manning Expenses24Sport & Recreation Manning Expenses25Transportation Manning Expenses26Telephone Manning Expenses27Guest Laundry Manning Expenses28House Laundry Manning Expenses29Business

5、Center Manning Expenses30Shop & Other Income Manning Expenses31Sales & Marketing & PR Manning Expenses32Human Resources & Training Manning Expenses33Staff Canteen Manning Expenses34Administration & General Manning Expenses35Engineering Manning ExpensesACCOR ASIA BUDGET WORKSHEET

6、FOR YEAR 2009INSTRUCTIONSPlease Complete the Hotel Name in the cell:Pullman Sanya Yalong Bay Resort & SpaBudget System Presentation: This Budget system consists in 2 files:- Detailed Budget - Operating Statement.- Detailed Budget - Manning Expenses. When you click on the ZIP file, both of files

7、have been automatically saved on your hard disk in: C: AccorDetailed BudgetHow to use the files: Proceed in the following order:- 1: Complete the Number of Rooms Available in the worksheet Room.- 2: Complete Revenue figures in worksheets: Comparison, Market Mix, Business Individual,Business Groups,

8、Leisure Individual, Leisure Groups, F&B.- 3: Complete the Manning Expenses (Service Charge Allocation first).- 4: Complete what is not completed yet. Only cells with blue characters must be completed. Monetary values must be completed in Local Currency.ACCOR ASIA BUDGET WORKSHEET FOR YEAR 2009IN

9、STRUCTIONSHow to complete your Hotel Budget for Year 2009: Room Department:- Number of Room Available: Total Rooms Available minus all Permanent House Use Rooms (Cf.Dictionnary).- Occupancy %: Calculation based on Total Rooms Rented Paid + Complimentary.- Average Rate: Calculation based on Total Roo

10、ms Rented Paid + Complimentary. F&B Department:- For F&B Outlets which can only be A-La-Carte outlets as per Strategy Budget, Name of theOutlet must be completed.- F&B Summary Sheet: For the House Laundry Allocation, the Total Allocation per F&B Outletshould be equal to 100% of the t

11、otal allocated to F&B Department. If not equal: ERROR.- Uniforms: Includes cost for replacement and cleaning. Should be stated as annual input theprovision for replacement only. The cost of cleaning is automatically added through the Laundryworksheet. - The cost of Sales on Conference Rental mus

12、t be accounted for in the department Shop & OtherIncome.to match the Total Cost of Sales on Other Departmental Revenue of the Strategy Budget. Transportation Department:- If not existing, Revenue and Cost are part of worksheet Shop & Other Income. Guest Laundry Department:- Cost of Sales: Wh

13、en no separate Laundry is used, automatic input comes from House Laundryworksheet and annual input should be left blank. House Laundry Department:- Total Expenses is fully reallocated to all departments of the hotel. A fixed amount to cover uniformcleaning is monthly allocated to each department. Th

14、e balance will be allocated to Rooms, F&B, Sports and Guest Laundry on a % basis, which youhave input by department on the worksheet House Loundry. Business Centre:- If not existing, Revenue and Cost are part of of worksheet Shop & Other Income. Human Resources:- When separate Staff Canteen

15、with dedicated staff exists, the salaries of those personels will bereallocated under Staff Canteen Payroll. Staff Canteen:- If the Staff Canteen has no dedicated staff, only the Cost of Goods should be completed.- The allocation key should be the Total Number of Staff of each Department divided by

16、the TotalNumber of Staff of the hotel ( Staff entitled to Staff Canteen only). Administration & General:- Basic Management Fees: When % of Fees is net of any taxes, as per contract the amountstated should be the gross-up %, including the tax you pay on top of the invoiced amount to thegovernment

17、. Summary:- Fees: When % of Fees is net of any taxes, the % mentionned should be gross-up as for Basicfees. For example, a Basic Management Fee of 3% Net of any tax (15% witholding tax) should beentered as 3.53%. Manning Expenses:- The yearly rate must be added up for each individual salary.- The Me

18、al Allowance is not referring to Staff Canteen.149a3e4054bd6a9da7021a2a9c357a93.xls/SummaryPage 4/492022/3/5 2:16ACCOR ASIA Pullman Sanya Yalong Bay Resort & SpaTWELVE MONTHS ENDING DECEMBER 2009BUDGET OPERATING STATEMENT - SUMMARYAccount20082009JanFebMarAprMayJunJulAugSepOctNovDecCodeForecastBu

19、dgetOccupancy %0.0%58.0%70.0%71.2%53.5%55.4%51.0%39.7%49.0%56.8%42.1%64.0%71.7%72.2%Average Room Rate 1,280.461,187.601,943.751,286.981,092.06992.371,006.02826.70971.98979.92848.801,183.321,224.941,370.37No of Rooms Available070,4455,9835,4045,9835,7905,9835,7905,9835,9835,7905,9835,7905,983No of Ro

20、oms Rented - Total27,87340,8644,1903,8503,2003,2093,0502,3002,9303,4002,4353,8304,1504,320Spend per Guest 0.001,004.361,436.251,078.71942.16888.48887.41800.75885.84883.86818.65986.551,033.191,110.36NET REVENUERooms35,690,200100.0%48,530,18865.7%8,144,3104,954,8803,494,6003,184,5303,068,3601,901,4152

21、,847,8903,331,7432,066,8254,532,1105,083,5155,920,010Food00.0%17,059,60523.1%1,833,3211,725,3341,289,4111,303,0891,195,557927,3631,217,3271,394,5601,003,7121,524,8361,796,5001,848,595Beverage00.0%1,999,3832.7%216,526202,588150,810152,386139,936107,629141,822162,362118,367178,053211,124217,780Other F

22、&B Income00.0%3,006,1694.1%319,288301,093228,462230,735212,865168,091216,379245,834181,090267,583312,995321,754Sports & Recreation00.0%1,733,4612.3%177,582163,160135,804136,160129,47497,800124,410144,244103,497162,390175,870183,068Telephone 00.0%242,9070.3%21,38619,38520,34619,80820,18918,85

23、320,06320,55618,99521,00820,79621,522Other Operating Departments00.0%512,3000.7%52,50248,24040,12740,23638,25228,87336,75242,62730,56148,00251,99854,127Shop, Other Income & Rental00.0%792,0001.1%67,26660,75667,26665,09667,26665,09667,26667,26665,09667,26665,09667,266Total Net Revenue35,690,20010

24、0.0%73,876,013 100.0%10,832,1817,475,4365,426,8275,132,0384,871,8993,315,1204,671,9095,409,1933,588,1436,801,2487,717,8948,634,123Add:Serv Charge/Surcharge - Rooms00.0%00.0%000000000000Serv Charge/Surcharge - Food & Beverage00.0%00.0%000000000000Serv Charge/Surcharge - Sports & Recrea.00.0%0

25、0.0%000000000000Serv Charge/Surcharge - Telephone00.0%00.0%000000000000Serv Charge/Surcharge - Other Op. Dpt00.0%00.0%000000000000Serv Charge/Surcharge - Shop, Other Inc.00.0%00.0%000000000000Sub-total Service Charge/Surcharge00.0%00.0%000000000000Total Net Revenue incl Serv Ch./Surch.35,690,200100.

26、0%73,876,013 100.0%10,832,1817,475,4365,426,8275,132,0384,871,8993,315,1204,671,9095,409,1933,588,1436,801,2487,717,8948,634,123Add:Sales Tax00.0%00.0%000000000000Total Revenue35,690,200100.0%73,876,013 100.0%10,832,1817,475,4365,426,8275,132,0384,871,8993,315,1204,671,9095,409,1933,588,1436,801,248

27、7,717,8948,634,123COST OF SALESFood 00.0%6,226,75636.5%669,162629,747470,635475,628436,378338,487444,324509,014366,355556,565655,723674,737Beverage00.0%479,85224.0%51,96648,62136,19436,57333,58525,83134,03738,96728,40842,73350,67052,267Sports & Recreation00.0%69,3384.0%7,1036,5265,4325,4465,1793

28、,9124,9765,7704,1406,4967,0357,323Telephone 00.0%37,28815.4%3,8233,5132,9202,9282,7832,0992,6743,1032,2223,4953,7873,942Other Operating Departments00.0%46,7059.1%4,6974,2943,7073,6003,5572,7863,4373,9072,9214,3374,6364,827Shop, Other Income & Rental00.0%00.0%000000000000Total Cost Of Sales00.0%6

29、,859,9409.3%736,752692,701518,889524,175481,482373,115489,449560,761404,046613,625721,850743,096Payroll & Related ExpensesRooms00.0%4,131,6075.6%345,739338,341345,739343,273345,739343,273345,739345,739343,273345,739343,273345,739Food & Beverage00.0%5,991,3008.1%500,725493,269500,725498,23950

30、0,725498,239500,725500,725498,239500,725498,239500,725Sports & Recreation00.0%919,7291.2%76,96875,30276,96876,41376,96876,41376,96876,96876,41376,96876,41376,968Telephone 00.0%182,5310.2%15,28214,91815,28215,16015,28215,16015,28215,28215,16015,28215,16015,282Other Operating Departments00.0%376,2

31、480.5%31,48930,79531,48931,25831,48931,25831,48931,48931,25831,48931,25831,489Shop, Other Income & Rental00.0%00.0%000000000000 Total Salary & Wages00.0%11,601,41415.7%970,202952,624970,202964,343970,202964,343970,202970,202964,343970,202964,343970,202Other ExpensesRooms00.0%7,306,9139.9%939

32、,904678,845564,634533,397527,809407,276507,027561,088424,707665,101712,053785,071Food & Beverage00.0%2,389,4183.2%229,575212,756191,751189,398185,253163,524186,721198,991168,929208,048223,871230,601Sports & Recreation00.0%386,1880.5%34,37831,39332,12231,67431,78029,33431,50632,57829,64233,55

33、733,55034,674Telephone 00.0%192,5200.3%16,36814,84516,31215,95816,30315,76016,29716,32315,76716,34815,86416,375Other Operating Departments00.0%328,8280.4%28,37625,76427,70827,15127,60726,30627,52627,84326,39728,13327,55528,464Shop, Other Income & Rental00.0%231,4080.3%19,65417,75219,65419,02019,

34、65419,02019,65419,65419,02019,65419,02019,654Total Other Expenses00.0%10,835,27514.7%1,268,255981,355852,180816,597808,406661,220788,731856,476684,462970,8411,031,9131,114,839149a3e4054bd6a9da7021a2a9c357a93.xls/SummaryPage 5/492022/3/5 2:16ACCOR ASIA Pullman Sanya Yalong Bay Resort & SpaTWELVE

35、MONTHS ENDING DECEMBER 2009BUDGET OPERATING STATEMENT - SUMMARYAccount20082009JanFebMarAprMayJunJulAugSepOctNovDecCodeForecastBudgetTotal ExpensesRooms00.0%11,438,52015.5%1,285,6431,017,186910,373876,670873,548750,550852,766906,827767,9811,010,8401,055,3261,130,810Food & Beverage00.0%15,087,3262

36、0.4%1,451,4291,384,3931,199,3051,199,8371,155,9411,026,0821,165,8071,247,6971,061,9311,308,0701,428,5031,458,330Sports & Recreation00.0%1,375,2561.9%118,449113,221114,522113,533113,927109,659113,451115,315110,194117,021116,997118,965Telephone 00.0%412,3390.6%35,47333,27634,51334,04734,36833,0193

37、4,25234,70733,14935,12434,81235,599Other Operating Departments00.0%751,7811.0%64,56260,85262,90462,00862,65360,34962,45263,23960,57663,95963,44864,780Shop, Other Income & Rental00.0%231,4080.3%19,65417,75219,65419,02019,65419,02019,65419,65419,02019,65419,02019,654Total Expenses00.0%29,296,62939

38、.7%2,975,2092,626,6802,341,2712,305,1152,260,0911,998,6782,248,3822,387,4392,052,8512,554,6692,718,1062,828,138Gross Operating IncomeRooms35,690,200100.0%37,091,66850.2%6,858,6673,937,6942,584,2272,307,8602,194,8121,150,8651,995,1242,424,9161,298,8443,521,2704,028,1894,789,200Food & Beverage00.0

39、%6,977,8319.4%917,707844,622469,378486,372392,417177,001409,721555,059241,238662,402892,116929,799Sports & Recreation00.0%358,2050.5%59,13349,93921,28222,62615,547-11,85910,95928,929-6,69845,36958,87264,104Telephone 00.0%-169,432-0.2%-14,087-13,891-14,167-14,239-14,179-14,165-14,189-14,151-14,15

40、4-14,116-14,016-14,077Other Operating Departments00.0%-239,481-0.3%-12,060-12,612-22,776-21,772-24,400-31,476-25,699-20,611-30,015-15,957-11,450-10,652Shop, Other Income & Rental00.0%560,5920.8%47,61243,00447,61246,07647,61246,07647,61247,61246,07647,61246,07647,612Gross Operating Income35,690,2

41、00100.0%44,579,38460.3%7,856,9724,848,7563,085,5562,826,9232,611,8081,316,4422,423,5283,021,7541,535,2924,246,5804,999,7885,805,985UNDISTRIBUTED EXPENSESPayroll & Related ExpensesAdmin & General00.0%4,002,5145.4%334,244330,638334,244333,042334,244333,042334,244334,244333,042334,244333,042334

42、,244Sales & Marketing / PR00.0%1,577,3522.1%131,629130,689131,629131,316131,629131,316131,629131,629131,316131,629131,316131,629Property Operation & Maintenance00.0%1,279,9721.7%107,008105,239107,008106,418107,008106,418107,008107,008106,418107,008106,418107,008Personnel & Training00.0%8

43、26,3951.1%69,00968,27669,00968,76569,00968,76569,00969,00968,76569,00968,76569,009 Total Salary & Wages00.0%7,686,23310.4%641,890634,843641,890639,541641,890639,541641,890641,890639,541641,890639,541641,890Other ExpensesAdmin & General00.0%1,072,6591.5%127,33197,10184,08882,05379,64866,06978

44、,04883,94768,25395,083101,291109,746Sales & Marketing / PR00.0%1,840,1822.5%156,228141,256156,228151,615156,228151,237156,228156,228151,237156,228151,237156,228Property Operation & Maintenance00.0%1,081,2861.5%91,72283,11791,72289,55591,72288,85491,72291,72288,85491,72288,85491,722Personnel

45、& Training00.0%2,153,4122.9%182,312167,471182,312177,659182,312177,365182,312182,312177,365182,312177,365182,312Total Other Expenses00.0%6,147,5398.3%557,593488,946514,350500,883509,911483,525508,311514,209485,710525,345518,748540,008Total Undistributed DepartmentAdmin & General00.0%5,075,17

46、36.9%461,575427,740418,332415,095413,892399,111412,292418,191401,295429,327434,333443,990Sales & Marketing / PR00.0%3,417,5344.6%287,857271,945287,857282,931287,857282,553287,857287,857282,553287,857282,553287,857Property Operation & Maintenance00.0%2,361,2583.2%198,730188,356198,730195,9741

47、98,730195,272198,730198,730195,272198,730195,272198,730Personnel & Training00.0%2,979,8074.0%251,321235,748251,321246,424251,321246,130251,321251,321246,130251,321246,130251,321Energy Cost00.0%8,200,00011.1%771,000695,000647,000609,000657,800637,200686,000686,000617,600686,000734,400773,000Total

48、 Undistributed Department00.0%22,033,77229.8%1,970,4831,818,7881,803,2401,749,4241,809,6001,760,2661,836,2001,842,0991,742,8501,853,2351,892,6881,954,898 BASIC MANAGEMENT FEE00.00%1,477,5202.00%216,644149,509108,537102,64197,43866,30293,438108,18471,763136,025154,358172,682GROSS OPERATING PROFIT35,6

49、90,200100.00%21,068,09228.5%5,669,8462,880,4591,173,780974,858704,770-510,126493,8891,071,471-279,3222,257,3192,952,7423,678,405149a3e4054bd6a9da7021a2a9c357a93.xls/SummaryPage 6/492022/3/5 2:16ACCOR ASIA Pullman Sanya Yalong Bay Resort & SpaTWELVE MONTHS ENDING DECEMBER 2009BUDGET OPERATING STA

50、TEMENT - SUMMARYAccount20082009JanFebMarAprMayJunJulAugSepOctNovDecCodeForecastBudgetPROPERTY & OWNERS COSTSIncentive Management Fee %GOP00.00%842,7244.00%226,794115,21846,95138,99428,191-20,40519,75642,859-11,17390,293118,110147,136Fixed Incentive Management Fee00.0%00.0%000000000000Insurance -

51、 Owners00.0%120,0000.2%10,1929,20510,1929,86310,1929,86310,19210,1929,86310,1929,86310,192Rent00.0%00.0%000000000000Land Tax00.0%540,0000.7%45,86341,42545,86344,38445,86344,38445,86345,86344,38445,86344,38445,863Municipal Rates00.0%00.0%000000000000Interest Expenses00.0%00.0%000000000000Proceeds on

52、Sale of Fixed Assets00.0%00.0%000000000000Other Non Operating Expenses/Income00.0%2,100,0002.8%178,356161,096178,356172,603178,356172,603178,356178,356172,603178,356172,603178,356TOTAL PROP. & OWNERS COSTS00.0%3,602,7244.9%461,205326,944281,362265,844262,602206,444254,167277,270215,676324,704344

53、,959381,547NET PROFIT BEF. DEPRN35,690,200100.0%17,465,36823.6%5,208,6412,553,515892,418709,015442,168-716,571239,723794,202-494,9981,932,6162,607,7833,296,857DEPRECIATIONAmortisation - Preopening00.0%00.0%000000000000Amortisation - Other00.0%00.0%000000000000Amortisation - Leased Assets00.0%00.0%00

54、0000000000Depreciation - Plant & Equipment00.0%00.0%000000000000Depreciation - Buildings00.0%15,000,00020.3%1,273,9731,150,6851,273,9731,232,8771,273,9731,232,8771,273,9731,273,9731,232,8771,273,9731,232,8771,273,973TOTAL DEPRECIATION00.0%15,000,00020.3%1,273,9731,150,6851,273,9731,232,8771,273,

55、9731,232,8771,273,9731,273,9731,232,8771,273,9731,232,8771,273,973NET PROFIT BEFORE TAX35,690,200100.0%2,465,3683.3%3,934,6691,402,830-381,555-523,862-831,804-1,949,447-1,034,250-479,771-1,727,875658,6431,374,9062,022,885FF&E, Replacement Prov00.0%2,216,2803.0%324,965224,263162,805153,961146,157

56、99,454140,157162,276107,644204,037231,537259,024NET RETURN35,690,200100.0%249,0880.3%3,609,7031,178,567-544,360-677,823-977,961-2,048,901-1,174,407-642,047-1,835,519454,6061,143,3691,763,861Total Payroll & Rel. Exp.(Exc.Hse Ldry-Staff Canteen)00.0%19,287,64726.1%1,612,0921,587,4671,612,0921,603,

57、8841,612,0921,603,8841,612,0921,612,0921,603,8841,612,0921,603,8841,612,092Total Service Charge collected00.0%0000000000000Total Service Charge distributed00.0%00.0%000000000000Total Revenue for Accor Fees073,876,01310,832,1817,475,4365,426,8275,132,0384,871,8993,315,1204,671,9095,409,1933,588,1436,

58、801,2487,717,8948,634,123GOP for Accor Fees021,068,0925,669,8462,880,4591,173,780974,858704,770-510,126493,8891,071,471-279,3222,257,3192,952,7423,678,405Additional Information No of Guests 073,5557,5426,9305,7605,7765,4904,1405,2746,1204,3836,8947,4707,776Total Number Of Staff05,5564634634634634634

59、63463463463463463463Reservation Fees 0242,65140,72224,77417,47315,92315,3429,50714,23916,65910,33422,66125,41829,600Marketing Fees 00000000000000Reg. Sales Contribution/Support Services0738,76062,74456,67262,74460,72062,74460,72062,74462,74460,72062,74460,72062,744National Shared/Cooperative Marketi

60、ng Fund00000000000000Accor Training Fees00000000000000149a3e4054bd6a9da7021a2a9c357a93.xls/ComparisonPage 7/492022/3/5 2:16ACCOR ASIA Pullman Sanya Yalong Bay Resort & SpaTWELVE MONTHS ENDING DECEMBER 2009MONTHLY STATISTICS COMPARISONBUDGET 2009FORECAST 2008MonthOcc %Av. RateRms Rev.F&B Rev.Tot Net RevGOPNOPMgt FeesPayrollOcc %Av. RateRms Rev.F&B Rev.Tot Net RevGOPNOPMgt FeesPayroll(incl. Serv Ch)(incl. Serv Ch)% 000000000000000000000% 000000000000000000000Jan70.0%1,943.758,144.312,369.1410,832.185,669.853,609.70443.441,612.090.0%0