1、如如家家酒酒店店连连锁锁20082008年年预预算算编编制制表表酒店名称：上海龙东大道酒店开业时间：2005.1.1编制人：施云德项项目目2006年年实实际际发发生生额额2007年年全全年年预预估估2007年年19月月实实际际发发生生额额2007年年9月月实实际际发发生生额额2007年年4季季度度预预估估经经营营收收入入及及费费用用2007年年年年度度经经营营额额（包包括括4季季度度预预估估）2008年年预预算算2008年年预预算算/2007年年预预算算1 客房数133133129129129129129出租率73%70%80.90%84.90%802060.68%78.00%0.120689
2、655平均房价170170174.00177.0017617450.00%1750.029411765RevPAR123.93118.32140.77150.00145.003,595.88136.500.101428226客房收入(包括中介佣金、CRS佣金）5,887,826.005,711,056.005,014,492.00595,726.001,787,178.006,801,6706,626,454.300.160285296非客房经营收入1,037,224.00800,000.00884,651.00129,824.00329,283.501,213,9351,238,213.19
3、0.547766488 餐饮收入938,878.00750,000.00796,492.00120,377.00300,942.501,097,4351,119,383.190.49251092 商品收入75,030.0035,000.0066,834.006,813.0020,439.0087,27389,018.461.543384571 其他收入23,316.0015,000.0021,325.002,634.007,902.0029,22729,811.540.987436考考核核总总收收入入6,925,050.006,511,056.005,899,143.00725,550.002
4、,116,461.508,015,6057,864,667.490.207894309税税金金366,579.00360,061.40319,803.0038,747.00116,241.00436,044443,630.020.232095495税率5.29%5.53%5.42%5.34%5.49%5.44%5.64%0.020035847 营业税金及附加366,579.00360,061.40319,803.0038,747.00116,241.00436,044443,630.020.232095495 增值税-#DIV/0!营营业业成成本本893,141.00542,500.00722
5、,015.0095,275.00285,825.001,007,840794,650.780.464794063成本率12.90%8.33%12.24%13.13%13.50%12.57%10.10%0.212683967 餐饮成本608,371.00375,000.00533,605.0076,160.00228,480.00762,085559,691.600.49251092 商品成本50,514.0017,500.0048,945.004,075.0012,225.0061,17035,607.381.034707657 销售佣金（CRS除外）234,256.00150,000.001
6、39,465.0015,040.0045,120.00184,585199,351.800.329012人人力力成成本本1,272,645.001,119,873.381,141,027.00131,603.00278,850.001,419,8771,473,842.430.316079535成本率18.38%17.20%19.34%18.14%13.18%17.71%18.74%0.089565142 员工工资931,082.00774,815.66807,720.0098,324.00196,648.001,004,3681,048,560.190.35330278 工资附加186,92
7、4.00163,101.95161,912.0016,276.0032,552.00194,464198,353.280.216130626 福利费110,323.00108,474.19102,581.0011,866.0035,598.00138,179132,651.840.222888471 考核提成33,742.0057,481.5756,660.003,778.0011,334.0067,99480,000.000.391750521 服装费10,574.0016,000.0012,154.001,359.002,718.0014,87214,277.12-0.10768物物料料用
8、用品品357,104.00368,132.67291,569.0033,403.00100,209.00391,778418,840.530.137743433费用率5.16%5.65%4.94%4.60%4.73%4.89%5.33%-0.058076999 清洁用品18,910.0015,000.0011,521.00915.001,830.0013,35111,214.84-0.252344 服务用品119,462.00105,000.0078,983.009,395.0028,185.00107,168109,311.360.041060571 棉织品83,002.0078,132.6
9、771,355.008,773.0017,546.0088,90194,376.010.207894309 餐厨具16,267.005,000.005,261.0030.0090.005,3515,779.080.155816 低值易耗品8,032.0012,000.0014,337.00-14,33713,763.520.14696 洗涤费98,204.00138,000.0097,942.0013,600.0038,080.00136,022171,387.720.24194 物料用品摊销13,227.0015,000.0012,170.00690.001,380.0013,55013,0
10、08.00-0.1328能能源源费费用用633,541.00692,500.00541,460.0052,339.00138,051.10679,511774,642.650.118617551费用率9.15%10.64%9.18%7.21%6.52%8.48%9.85%-0.073911068 水费68,730.0075,000.0056,422.007,209.0021,627.0078,04988,975.860.1863448 电费397,731.00450,000.00353,033.0033,133.0082,832.50435,866496,886.670.1041926 煤、燃
11、气费167,080.00167,500.00132,005.0011,997.0033,591.60165,597188,780.120.127045516 蒸气费-#DIV/0!维维修修保保养养费费225,717.00195,331.68178,388.0021,932.0065,796.00244,184235,940.020.207894309费用率3.26%3.00%3.02%3.02%3.11%3.05%3.00%0其其他他费费用用246,759.00207,167.00300,198.0039,119.00101,426.70401,625386,119.710.863808966
12、费用率3.56%3.18%5.09%5.39%4.79%5.01%4.91%0.543023219 差旅费19,699.0024,000.0021,314.001,266.003,798.0025,11224,107.520.00448 交通费38,698.0055,000.0044,417.007,880.0022,064.0066,48163,821.760.160395636 印刷及文具费30,110.0052,000.0038,601.004,801.0011,042.3049,64347,657.57-0.083508308 邮电费66,866.0070,000.0053,512.0
13、05,308.0014,862.4068,37465,639.42-0.062293943 有线电视费-3,280.0014,000.0014,000.00-14,00014,000.000 其他94,666.00-7,833.00128,354.0019,864.0049,660.00178,014170,893.44-22.81711222酒酒店店经经营营利利润润2,929,564.003,025,489.882,404,683.00313,132.001,030,062.703,434,7463,337,001.330.102962321GOP百分比42.30%46.47%40.76%4
14、3.16%48.67%42.85%42.43%-0.08687183市市场场营营销销20,304.0039,000.0022,700.006,300.0011,340.0034,04032,678.40-0.162092308费用率0.29%0.60%0.38%0.87%0.54%0.42%0.42%-0.306307112 业务招待费20,304.0039,000.0022,700.006,300.0011,340.0034,04032,678.40-0.162092308 宣传费-#DIV/0!代代垫垫公公司司费费用用76,794.0039,600.0035,670.004,664.005
15、5,968.0091,638109,965.601.776909091公公司司代代垫垫费费用用5,229.001,997.005,991.0011,22013,464.00#DIV/0!店店长长考考核核GOPGOP2,986,054.003,026,089.882,412,424.00309,499.001,068,699.703,481,1243,400,824.530.12383461 百分比43.12%46.48%40.89%42.66%50.49%43.43%43.24%-0.069591933非非考考核核收收入入27,538.0048,000.0039,442.004,537.001
16、3,611.0053,05357,297.240.1936925 转租收入-#DIV/0! 卡收入27,538.0048,000.0039,442.004,537.0013,611.0053,05357,297.240.1936925营营业业外外收收入入75.0075#DIV/0!营营业业外外支支出出15,425.0015,425#DIV/0!摊摊销销1,960,344.002,133,919.001,599,132.00179,530.00538,590.002,137,7222,153,763.900.009299744 长期待摊403,345.00430,480.00322,107.00
17、36,122.00108,366.00430,473443,387.190.029983251 折旧299,675.00312,780.00234,030.0026,247.0078,741.00312,771315,898.710.009970938 租金1,257,324.001,390,659.001,042,995.00117,161.00351,483.001,394,4781,394,478.000.00274618其其他他非非经经营营费费用用7,700.00-1,800.00322,111.0043,278.00126,449.69448,561453,135.95-252.74
18、21927 咨询费8,957.00323,366.0043,816.00126,987.69450,354454,857.23#DIV/0! 利息收入1,257.001,800.001,255.00538.00538.001,7931,721.28-0.043733333CRS费用65,780.0067,380.007,140.0021,420.0088,80085,248.00#DIV/0!利利润润总总额额902,974.00902,370.88417,452.0081,421.00345,874.01763,326669,472-0.25809626所所得得税税297,981.42297,
19、782.39137,759.1626,868.93114,138.42251,898167,368.08-0.437951712黄色标注部分由公式设置，请勿随意改动！2008年年预预算算/2007年年实实际际说说明明20082008年年公公司司下下达达指指标标-0.9621483250.00286533-0.962039868-0.0257606880.020.020.020.02-0.0188303960.0173973840.0369230560.017397384#DIV/0!-0.211530819-0.196398688-0.265578518-0.4178946540.080.03
20、80071180.0579283270.0440.02-0.040.176574404-0.040.0690761860.089593666-0.160.020.061585470.08-0.040.26-0.040.140.1618786350.140.140.14#DIV/0!-0.033761325-0.015217479-0.038605663-0.02015479-0.04-0.04-0.04-0.040-0.04-0.028457526-0.009811892-0.04-0.021575886-0.04#DIV/0!0.20.2-0.023067025在其他费用有所降低的情况下，GOP率仍未达到07年预估额，但与07年度经营额持平，原因：1.接物业通知，07年能源（水，电，煤）单价将一定幅度上调，故此次08年预算比07年预估额增加61020；2.08年洗涤费单价上调，增加额为34000；如以上费用维持原来单价的情况下，08年预算GOP率44.57%，与07年度经营额GOP率持平-0.0043179370.08#DIV/0!0.08-1-10.0075042030.030.0100.0101998610.01-0.04-0.04-0.122953603-0.335570912
