1、53927a9eb5e0809acaf4ef02937276a4.xls2022/8/8 ,9:02Loong Palace Hotel & ResortBudget for 2006SUMMARY P&L 经经 营营 损损 益益 预预 算算PERIOD :January一一月月February二二月月March三三月月April四四月月May五五月月June六六月月July七七月月August八八月月September九九月月October十十月月November 十十一一月月 December十十二二月月HALF YEAR半半年年FULL YEAR全全年年Budget 2006Budget
2、 2006Budget 2006Budget 2006Budget 2006Budget 2006Budget 2006Budget 2006Budget 2006Budget 2006Budget 2006Budget 2006Budget 2006Budget 2006STATISTICS 统统计计数数字字Roomcount 房间数593593593593593593593593593593593593593593Available Rooms 可用房数18,38316,60418,38317,79018,38317,79018,38318,38317,79018,38317,79018,
3、383107,333216,445Total Occupied Rooms incl Compl. Rooms 实际出租房间数8,1908,0909,3809,57010,0859,37010,35010,28011,44011,44511,22010,52054,685119,940% Occupancy 出租率44.6%48.7%51.0%53.8%54.9%52.7%56.3%55.9%64.3%62.3%63.1%57.2%50.9%55.4%Average Room Rate 平均房价347.25304.40344.12439.47435.54393.80394.68402.6042
4、5.53447.54405.76343.80380.77393.58RevPar 可用房的平均房价154.71148.32175.59236.41238.94207.42222.22225.14273.64278.63255.91196.75194.00218.10No. of Guests 住客人数13,10412,94415,00815,31216,13614,99216,56016,44818,30418,31217,95216,83287,496191,904Occupancy Multiplier 平均每间出租房的客人数1.601.601.601.601.601.601.601.60
5、1.601.601.601.601.601.60ROOMS DEPT.: 客客房房部部Net Room Revenue 客房净收入2,843,9502,462,6303,227,8804,205,7304,392,3803,689,9304,084,9804,138,7304,868,0305,122,0804,552,6803,616,78020,822,50047,205,780Rooms Payroll & Related Expenses 工资及福利-16,89039,975-74,446-221,229-249,102-143,864-202,984-211,049-320,522-
6、358,519-273,225-132,750-665,556-2,164,606Room Other Expenses 其他费用569,550537,558617,098684,713710,761646,731695,110696,952771,140789,645745,643678,7963,766,4118,143,697Total Room Expenses 客客房房部部费费用用合合计计552,660577,533542,652463,484461,659502,867492,126485,903450,618431,126472,418546,0463,100,8555,979,
7、091Rooms Department Profit 客客房房部部利利润润2,291,2901,885,0972,685,2283,742,2463,930,7213,187,0633,592,8543,652,8274,417,4124,690,9544,080,2623,070,73417,721,64541,226,689Rooms Dept. Profit % 利润百分比80.6%76.5%83.2%89.0%89.5%86.4%88.0%88.3%90.7%91.6%89.6%84.9%85.1%87.3%FOOD & BEVERAGE DEPT.: 餐餐饮饮部部F&B Food R
8、evenue 食品收入2,389,5131,775,6772,263,2262,519,8142,318,3632,547,4552,633,2142,688,9722,758,3932,543,3312,684,8632,849,71613,814,04829,972,537F&B Beverage Revenue 酒水收入678,096375,878532,866644,456537,993672,399588,175609,341688,246715,834708,812749,0453,441,6887,501,141F&B Other Revenue 其他收入368,149291,8
9、33274,901302,135293,266331,438357,671378,402387,315327,339366,143858,3771,861,7224,536,969F&B Total Revenue 餐餐饮饮部部收收入入合合计计3,435,7582,443,3883,070,9933,466,4053,149,6223,551,2923,579,0603,676,7153,833,9543,586,5043,759,8184,457,13819,117,45842,010,647F&B Food Cost 食品成本835,554625,280793,584887,902818,
10、988904,115934,151958,542982,573899,542950,4921,006,4914,865,42210,597,214F&B Beverage Cost 酒水成本165,33888,622124,213157,583129,945160,551146,074154,154170,057188,951176,079185,599826,2531,847,167F&B Other Direct Costs 其他直接成本9,5005,5005,0003,5004,5003,5004,3004,650129,0002,0004,40091,50031,500267,350F
11、&B Payroll & Related Expenses 工资及福利204,318355,155262,145250,927295,478205,358232,292217,828191,026227,331195,21091,1641,573,3812,728,235F&B Other Expenses 其他费用591,344416,856500,915550,661519,026566,822552,734559,420610,448567,946582,571833,3493,145,6266,852,093Total F & B Expenses 餐餐饮饮部部费费用用合合计计1,80
12、6,0541,491,4131,685,8571,850,5741,767,9381,840,3461,869,5521,894,5942,083,1041,885,7701,908,7532,208,10510,442,18222,292,059F&B Department Profit 餐餐饮饮部部利利润润1,629,704951,9761,385,1361,615,8311,381,6841,710,9451,709,5081,782,1211,750,8501,700,7341,851,0652,249,0338,675,27619,718,588 F&B Dept. Profit %
13、 利润百分比47.4%39.0%45.1%46.6%43.9%48.2%47.8%48.5%45.7%47.4%49.2%50.5%45.4%46.9%TELEPHONE DEPT.: 电电话话房房Telephone Revenue 电电话话收收入入5,9595,6856,6906,9217,0996,8127,4777,4508,3888,1948,2867,33939,16686,300Total Telephone Expenses 电电话话房房费费用用34,27634,25934,34334,36134,38134,34934,40834,40534,48334,47234,47134
14、,404205,969412,612Telephone Department Profit 电电话话房房利利润润-28,317-28,574-27,653-27,440-27,282-27,537-26,931-26,955-26,095-26,278-26,185-27,065-166,803-326,312Telephone Dept. Profit % 利润百分比-475.2%-502.6%-413.3%-396.5%-384.3%-404.2%-360.2%-361.8%-311.1%-320.7%-316.0%-368.8%-425.9%-378.1%OTHER OPERATING
15、DEPTS.: 其其他他营营运运部部门门Other Operating Dept. Revenue 其其他他营营业业收收入入569,009550,701594,047571,146560,776565,989585,726603,011599,068561,261586,431605,9943,411,6686,953,159Total Other Operating Expenses incl payroll 其其他他营营业业部部门门的的工工资资及及福福利利338,549336,099351,000344,886339,221342,163347,258354,085358,407342,9
16、39351,044359,9402,051,9184,165,592Other Operating Department Profit 其其他他营营业业部部门门的的利利润润230,460214,602243,047226,260221,554223,826238,469248,925240,661218,322235,387246,0541,359,7502,787,567OtherOperating Dept. Profit % 利润百分比40.5%39.0%40.9%39.6%39.5%39.5%40.7%41.3%40.2%38.9%40.1%40.6%39.9%40.1%53927a9
17、eb5e0809acaf4ef02937276a4.xls2022/8/8 ,9:02Loong Palace Hotel & ResortBudget for 2006SUMMARY P&L 经经 营营 损损 益益 预预 算算PERIOD :January一一月月February二二月月March三三月月April四四月月May五五月月June六六月月July七七月月August八八月月September九九月月October十十月月November 十十一一月月 December十十二二月月HALF YEAR半半年年FULL YEAR全全年年Budget 2006Budget 2006Bu
18、dget 2006Budget 2006Budget 2006Budget 2006Budget 2006Budget 2006Budget 2006Budget 2006Budget 2006Budget 2006Budget 2006Budget 2006Total Revenue 收收入入总总计计6,854,6765,462,4046,899,6108,250,2028,109,8777,814,0238,257,2438,425,9069,309,4409,278,0398,907,2158,687,25143,390,79296,255,886Total Departemental
19、Expenses 部部门门费费用用总总计计2,731,5392,439,3042,613,8522,693,3052,603,1992,719,7252,743,3432,768,9872,926,6132,694,3062,766,6863,148,49415,800,92432,849,354Operating Departemental Profit 营营运运部部门门利利润润总总计计4,123,1373,023,1014,285,7585,556,8975,506,6785,094,2975,513,9005,656,9186,382,8276,583,7326,140,5295,538
20、,75727,589,86863,406,531Operating Departemental Profit % 利润百分比60.2%55.3%62.1%67.4%67.9%65.2%66.8%67.1%68.6%71.0%68.9%63.8%63.6%65.9%UNALLOCATED EXPENSES: 未未分分配配费费用用A&G 行政部649,941585,797598,139642,843612,367604,532608,544609,781651,295621,478613,233611,7993,693,6197,409,749Sales & Marketing 销售部455,36
21、0355,677368,854381,302420,894408,160377,638431,235439,755391,916428,314474,1562,390,2484,933,261Energy 能源费用799,000778,000745,000447,000486,000682,000686,000686,000581,000455,000778,000778,0003,937,0007,901,000POM 工程部（财产维修及保养）297,876301,801298,056298,065298,163298,035298,204298,193302,349298,370298,3
22、15298,2291,791,9943,585,651Total Unallocated Expenses 未未分分配配费费用用合合计计2,202,1772,021,2752,010,0491,769,2101,817,4241,992,7271,970,3862,025,2081,974,3991,766,7642,117,8612,162,18311,812,86123,829,662 % Of Revenue 占总收入百分比32.1%37.0%29.1%21.4%22.4%25.5%23.9%24.0%21.2%19.0%23.8%24.9%27.2%24.8%GOP 毛毛利利润润1,9
23、20,9601,001,8262,275,7103,787,6883,689,2543,101,5713,543,5143,631,7104,408,4284,816,9694,022,6683,376,57415,777,00739,576,870GOP margin 毛利率28.0%18.3%33.0%45.9%45.5%39.7%42.9%43.1%47.4%51.9%45.2%38.9%36.4%41.1%FIXED CHARGES: 固固定定费费用用P&L Basic Management Fee 基本管理费00000000000000P&L Incentive Management
24、 Fee 奖励管理费00000000000000P&L Franchise Royalty 特许经营费00000000000000P&L R.S.C. / Licence Fee许可证费用00Sub-total (1) Management Fees to SCH 管管理理费费合合计计00000000000000Property Rent 资产租用费00000000000000Capital Replacement Reserve 资产重置费205,640163,872206,988247,506243,296234,421247,717252,777279,283278,341267,216
25、260,6181,301,7242,887,677Real Estate Taxes 房产税40,00040,00040,00040,00040,00040,00040,00040,00040,00040,00040,00040,000240,000480,000Personal Property Tax 资产税个人承担部分00000000000000Insurance Buildings/Contents 财产保险10,55810,55810,55810,55810,55810,55810,55810,55810,55810,55810,55810,55863,348126,696Insur
26、ance Liability 责任险5,0005,0005,0005,0005,0005,0005,0005,0005,0005,0005,0005,00030,00060,000Insurance - Other 其他保险1251251251251251251251251251251251257501,500Equipment Lease 设备出租00000000000000Other Non Operating 非营运费用00000000000000Sub-total (2) Fixed Charges 固固定定费费用用合合计计261,323219,555262,671303,189298
27、,979290,104303,400308,460334,966334,024322,899316,3011,635,8223,555,873GRAND TOTAL FIXED CHARGES 固固定定费费用用总总计计261,323219,555262,671303,189298,979290,104303,400308,460334,966334,024322,899316,3011,635,8223,555,873EBITDA扣扣除除固固定定管管理理费费后后利利润润1,664,761787,3962,018,1633,489,6233,395,3992,816,5923,245,2393,
28、328,3754,078,5874,488,0693,704,8933,065,39814,171,93536,082,497Depreciation Building 房屋建筑折旧00000000000000Depreciation FF&E固定资产折旧00000000000000Pre-Opening Expenses开办费00000000000000Amortization Other其他摊销费用00000000000000TOTAL Depreciation & Amortization 折折旧旧及及摊摊销销费费用用合合计计00000000000000NOP净净利利润润1,664,76
29、1787,3962,018,1633,489,6233,395,3992,816,5923,245,2393,328,3754,078,5874,488,0693,704,8933,065,39814,171,93536,082,497 % Of Revenue占总收入百分比24.3%14.4%29.3%42.3%41.9%36.0%39.3%39.5%43.8%48.4%41.6%35.3%32.7%37.5%53927a9eb5e0809acaf4ef02937276a4.xls2022/8/8 ,9:02Loong Palace Hotel & ResortBudget for 2006
30、SUMMARY P&L 经经 营营 损损 益益 预预 算算PERIOD :January一一月月February二二月月March三三月月April四四月月May五五月月June六六月月July七七月月August八八月月September九九月月October十十月月November 十十一一月月 December十十二二月月HALF YEAR半半年年FULL YEAR全全年年Budget 2006Budget 2006Budget 2006Budget 2006Budget 2006Budget 2006Budget 2006Budget 2006Budget 2006Budget 200
31、6Budget 2006Budget 2006Budget 2006Budget 2006CTPBasic Management Fee 基本管理费00000000000000Incentive Management Fee 奖励管理费00000000000000Franchise Royalty 特许经营费00000000000000R.S.C. / License Fee 许可证费用00000000000000RM Global 2 (IHC Global II / Holidex Plus Fees)00000000000000RM Sales & Booking Fees 客房销售及预
32、定费用00000000000000Other CTP (= NOP for Owned & Leased hotels)00000000000000TOTAL CTP00000000000000Fees to SCH SummaryIT Holidex AsiaPacific亚亚太太区区假假日日网网络络RM Holidex Expenses to SCH HLDX假日远程预订系统费35,10035,10035,10035,10035,10035,10035,10035,10035,10035,10035,10035,100210,600421,200Reservation系系统统预预订订RM
33、Reservations / Global Dist Service to SCH 全球预定服务费00000000000000RM Reservation Assessments 客房系统预定费2,3342,3062,6732,7272,8742,6702,9502,9303,2603,2623,1982,99815,58434,182Marketing市市场场促促销销S&M Marketing Assessments to HQ 市场促销均摊费00000000000000S&M Divisional / Coop Advertising区域/合作广告费00000000000000S&M Br
34、and Advertising to HQ 品牌广告费00000000000000S&M Regional Advertising to HQ 地区广告费00000000000000S&M Six Continents Club to HQ 六洲俱乐部费用00000000000000S&M Frequent Stay 常住客费用00000000000000GSF (Group Service Fund) 集团服务基金00000000000000Priority Club优优先先俱俱乐乐部部S&M Priority Club Assessments Cost 优先俱乐部费2,5672,5678,
35、3138,3137,8248,6809,6589,65810,3918,1919,6588,06938,26493,888Other其其他他A&G - HI University Fees to HQ 假日大学费用00000000000000A&G - WWHS Fees 系统费00000000000000TOTAL FEES TO SCH40,00139,97346,08646,14045,79846,45047,70847,68848,75146,55347,95646,167264,448549,27053927a9eb5e0809acaf4ef02937276a4.xls2022/8/
36、8 ,9:02Loong Palace Hotel & ResortBudget for 2006SUMMARY P&L 经经 营营 损损 益益 预预 算算PERIOD :January一一月月February二二月月March三三月月April四四月月May五五月月June六六月月July七七月月August八八月月September九九月月October十十月月November 十十一一月月 December十十二二月月HALF YEAR半半年年FULL YEAR全全年年Budget 2006Budget 2006Budget 2006Budget 2006Budget 2006Budge
37、t 2006Budget 2006Budget 2006Budget 2006Budget 2006Budget 2006Budget 2006Budget 2006Budget 2006STATISTICS: 统统计计数数字字Number of Days in Period 营运天数312831303130313130313031181365Rooms Statistics: Per Occupied Room (incl. Complimentary Rooms):客客房房统统计计数数字字：每每间间已已出出租租房房Rooms Occupied Per Day 已出租房数/每天264.228
38、8.9302.6319.0325.3312.3333.9331.6381.3369.2374.0339.4302.1328.6No. of FTE Housekeeping Maids Per Day 每天全职的客房服务员人数 53.053.053.053.053.053.053.053.053.053.053.053.00.00.0No. of Occupied Room Per Day Per Maid 每位客房服务员每天清洁的房间数5.05.55.76.06.15.96.36.37.27.07.16.40.00.0Total Room Cost Per Occupied Room 每间已
39、出租房成本67.4871.3957.8548.4345.7853.6747.5547.2739.3937.6742.1051.9156.7049.85F&B Statistics: 餐餐饮饮统统计计数数据据Total F&B Covers 用餐人数合计33,81125,48532,67435,53135,32436,16238,61438,87840,46941,60140,18040,340198,987439,069No. of FTE - Total F&B 餐饮部全职员工人数343343343343343343343343343343343343343343Total F&B Cove
40、rs per day 每天用餐人数1,0919101,0541,1841,1391,2051,2461,2541,3491,3421,3391,3011,0991,203Total F&B Covers per day per FTE 每位全职员工服务客人数33333444444434Total F&B Food Revenue per Cover 每位就餐客人的食品消费数70.6769.6869.2770.9265.6370.4568.1969.1668.1661.1466.8270.6469.4268.26Total F&B Beverage Revenue per Cover每位就餐客人
41、的酒水消费数20.0614.7516.3118.1415.2318.5915.2315.6717.0117.2117.6418.5717.3017.08Total F&B Other Revenue per Cover 每位就餐客人的其他消费数 10.8911.458.418.508.309.179.269.739.577.879.1121.289.3610.33F&B Revenue as % of Room Revenue餐饮收入/客房收入百分比120.8%99.2%95.1%82.4%71.7%96.2%87.6%88.8%78.8%70.0%82.6%123.2%91.8%89.0%T
42、otal F&B Food Cost as % of Food Rev 食品成本率35.0%35.2%35.1%35.2%35.3%35.5%35.5%35.6%35.6%35.4%35.4%35.3%35.2%35.4%Total F&B Beverage Cost as % of Beverage Rev 酒水成本率24.4%23.6%23.3%24.5%24.2%23.9%24.8%25.3%24.7%26.4%24.8%24.8%24.0%24.6%Total F&B Other Cost as % of Other Rev 餐饮其他成本率2.6%1.9%1.8%1.2%1.5%1.1
43、%1.2%1.2%33.3%0.6%1.2%10.7%1.7%5.9%Energy:能能源源费费用用Total Energy Expenses Per Day 每天能源费用25,774.1927,785.7124,032.2614,900.0015,677.4222,733.3322,129.0322,129.0319,366.6714,677.4225,933.3325,096.7721,751.3821,646.58Total Energy Expenses Per Available Room 每间可用房的能源费用 43.4646.8640.5325.1326.4438.3437.323
44、7.3232.6624.7543.7342.3236.6836.50Total Energy Expenses Per Occupied Room 每间已出租房的能源费用97.5696.1779.4246.7148.1972.7966.2866.7350.7939.7669.3473.9571.9965.87Payroll:工工资资Total FTE 全职员工人数842842842842842842842842842842842842842842Total Payroll & Related Expenses 工资及相关费用1,178,7311,384,0331,179,1941,020,43
45、21,037,9851,052,1911,020,962998,420861,537860,640912,980950,0926,852,56512,457,196Total Payroll as % of Total Revenue 工资总额/总收入百分比17.2%25.3%17.1%12.4%12.8%13.5%12.4%11.8%9.3%9.3%10.2%10.9%15.8%12.9%Total Payroll per FTE 人均工资1,399.921,643.741,400.471,211.911,232.761,249.631,212.541,185.771,023.201,022
46、.141,084.301,128.378,138.4414,794.77Other: 其其他他Total Unallocated Expenses Per Available Room 每间可用房的未分配费用119.79121.73109.3499.4598.86112.01107.19110.17110.9896.11119.05117.62110.06110.10Total Unallocated Expenses Per Occupied Room 已出租客房的未分配费用268.89249.85214.29184.87180.21212.67190.38197.00172.59154.3
47、7188.76205.53216.02198.68Base Management Fee as % of Room Revenue 基本管理费占客房收入的百分比0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%Incentive Management Fee as % of GOP 奖励管理费占毛利润的百分比0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%Capex Reserve as % of Total Revenue 资产重置飞占总营业收入的百分比3.0%3.0
48、%3.0%3.0%3.0%3.0%3.0%3.0%3.0%3.0%3.0%3.0%3.0%3.0%Loong Palace Hotel & ResortBudget for 2006Hours (FTE)PSoft Fin: TBD936.INPHolidex Code: STBD936Hotel name: Crowne Plaza North, BeijingPSoft Stat: STBD936Currency : CNYRegion : North Asia Jan - JuneJuly - DecPERIOD :JanuaryFebruaryMarchAprilMayJuneJuly
49、AugustSeptemberOctoberNovember DecemberHALF YEAR FULL YEARBudget 2006Budget 2006Budget 2006 Budget 2006 Budget 2006Budget 2006Budget 2006Budget 2006Budget 2006Budget 2006Budget 2006Budget 2006Budget 2006Budget 2006Working Hours per day5.5AVERAGE PER MONTHDepartmentHOURS for FTE:66RoomsHours - Front
50、Office5,9685,3905,9685,7755,9685,7755,9685,9685,7755,9685,7755,9685,8075,855.21RoomsHours - Reservations682616682660682660682682660682660682664669.17RoomsHours - Uniform Services3,5813,2343,5813,4653,5813,4653,5813,5813,4653,5813,4653,5813,4843,513.13RoomsHours - Housekeeping Maids12,61711,39612,617
