如家酒店集团2015年度预算模板

17,832 2.7% 8,916 8,916 8,742 1.3% 0
15,458 2.2% 7,729 7,729 8,715 1.3% 0 0
70 4,609 0 63
120 4,493 0 102
AG1712_保险费 AG1799_其他 AG18_酒店经营利润 AG19_市场营销 AG1901_市场营销费用率 AG1902_业务招待费 AG1903_宣传费 AG20_城区管理费用 AG2001_计提城区管理费用 AG21_店长考核GOP AG22_店长考核GOP率 AG23_代垫公司费用 AG24_非考核收入 AG2401_转租收入 AG25_营业外收入 AG26_营业外支出 AG27_摊销 AG2701_长期待摊 AG2702_折旧 AG2703_资产租赁 AG2704_租金 AG28_其他非经营费用 AG2801_咨询费 AG2802_利息收入 AG2803_CRS费用 AG2804_汇兑损益及其他 AG29_利润总额 AG30_所得税 AG31_每月天数 AG32_默认有效每月天数 AG33_实际有效每月天数 AG34_有效每月天数 费用效率分析（每间夜） 服务用品（客用品） 棉织品加洗涤费 水费 电费 367,008 91,752 31 #VALUE! 31 31 15,801 0 0 0 0 0 60,532 44,731 0 4,000 437,042 3,150 0.5% 2,500 650 6,352 6,352 427,540 64.6% 4,000 411,744 903 0.1% 253 650 5,556 5,556 405,285 58.5% 0 0 0 0 0 0 0 0 0 0 71,430 46,613 0 24,817 0 333,855 83,464 28 #VALUE! 28 28 4,000 515,372 650 0.1% 0 650 6,985 6,985 507,737 64.6% 0 0 0 0 0 0 0 0 0 0 65,654 50,466 0 15,188 0 442,083 110,521 31 #VALUE! 31 31 4,000 575,913 2,427 0.3% 1,057 1,370 7,814 7,814 565,672 67.8% 0 0 0 0 0 0 0 0 0 0 68,052 53,522 0 14,530 0 497,620 124,405 30 #VALUE! 30 30
41,889 0
622,750 35,535 5.7%
35,535 0
16,900 2.3% 7,000 68.9% 900 0.0% 0 9,000 96,710 13.2% 72,986 10.3% 7,545
40,575 5.9% 7,000 64.4% 975 61.9% 23,600 9,000 93,819 13.7% 73,076 10.3% 7,545
0 816 3,280 35,541 50 50
3月 0 256 100 105.6% 226 88.3% 239 93.2% 744,834 41,177
0 814 4,920 35,343 50 50
4月 1 256 100 101.7% 259 101.2% 263 102.9% 797,209 37,274
0 1,307 5,920 27,324 50 50
2015预算酒店输入 6月 7月 1 0 256 100 99.3% 213 83.2% 212 82.6% 643,527 39,718
0 1,515 6,720 31,383 50 50
8月 0 256 100 256 100 105.1% 226 88.3% 238 92.8% 745,331 34,034
12,729 320 0 33,679 4.0% 27,113.00 18,267 8,846 1,821 500 2,600 0 1,145 200 300 31,005 3.7% 4,734 26,271 0 0 22,116 2.7% 11,058 11,058 9,121 1.1% 200 0 150 4,672 0 99
731,107 33,654 4.6%
33,654 0
683,245 31,757 4.6%
31,757 0
773,603 36,821 4.8%
36,821 0
779,365 37,108 4.8%
37,108 0
628,492 35,408 5.6%
35,408 0
734,218 41,889 5.7%
0 1,155 11,565 24,454 50 50
661,957 30,572 4.6%
30,572 0
692,873 32,581 4.7%
32,581 0
786,011 42,498 5.4%
42,498 0
834,483 35,675 4.3%
35,675 0
16,000 2.4%
46,600 6.7%
0 1,500 4,000 30,000 50 50
11月 0 256 100 99.0% 195 76.2% 193 75.4% 587,150 35,600
0 1,500 4,000 30,000 50 50
108.1% 217 84.8% 235 91.6% 735,189 38,414
0 1,600 4,440 32,274 50 50
0.0%
0.0%
0.0%
0.0%
13,281 7,520 0 31,750 4.8% 24,833.00 17,700 7,133 1,671 500 3,250 0 996 200 300 30,533 4.6% 5,126 25,407
13,182 320 0 29,542 4.3% 23,782.00 17,599 6,183 0 500 4,199 0 561 200 300 34,307 5.0% 4,814 29,493 0 0
36,650 4.7%
32,750 3.9%
AG1305_绩效超额奖预提% AG1306_绩效超额奖预提 AG1307_工资附加 AG1308_福利费 AG1309_考核提成 AG14_物料用品 AG1401_物料用品费用率 棉织品加洗涤费_计提金额 AG1410_洗涤费 AG1406_棉织品-计提金额 AG1402_清洁用品 AG1403_清洁费 AG1404_服务用品 AG1408_餐厨具 AG1409_低值易耗品 AG1411_物料用品摊销 AG1310_服装费 AG15_能源费用 AG1501_能源费用率 AG1502_水费 AG1503_电费 AG1504_煤、燃气费 AG1505_蒸气费 AG16_酒店维修保养费 AG1601_维修保养费用率 AG1602_维修预提-酒店 AG1603_维修预提-公司 AG17_其他费用 AG1701_其他费用率 AG1702_交通差旅费 AG1704_城区差旅费 AG1705_印刷及文具费 AG1706_邮电费 AG1707_有线电视费 AG1709_金融机构手续费 AG1710_信用卡手续费 AG1708_证照费与年检费 AG1711_代客支付费用
12,878 320 0 28,605 4.2% 24,865.00 17,633 7,232 140 500 2,600 0 0 200 300 44,607 6.5% 4,864 39,743 0 0 18,080 2.6% 9,040 9,040 26,098 3.8% 0 0 0 4,801 11,241 256
如家酒店集团2015年酒店经营
1月 1 256 100 96.5% 206 80.5% 199 77.7% 624,249 37,708
0 833 4,600 32,175 50 50
20 每月法定节日天数 AG01_门市价 AG02_房间数 AG03_出租率 AG04_房价 AG05_房价执行率 AG06_RevPAR AG07_收益率 AG08_客房收入 AG09_非客房收入 AG0901_餐饮收入 AG0902_商品收入 AG0903_普卡收入 AG0906_金卡收入 AG0904_其他收入 AG0905_代客收入（洗涤费/电话费） AG10_考核总收入 AG11_税金 AG1101_税率 AG1102_营业税金及附加 AG1103_增值税 AG12_营业成本 AG1201_营业成本率 AG1202_餐饮成本% AG1203_餐饮成本 AG1204_商品成本% AG1205_商品成本 AG1206_卡成本% AG1207_卡成本 AG1208_销售服务费（CRS除外） AG13_人力成本 AG1301_人力成本率 AG1302_应发工资 AG1303_绩效达标奖计提% AG1304_绩效达标奖计提 7,000 120.0% 1,000 0.0% 0 8,000 89,486 13.5% 60,511 13.5% 8,174 7,000 122.5% 1,000 84.0% 32,600 6,000 113,926 16.4% 92,250 8.9% 8,174 7,000 129.0% 1,050 58.6% 23,600 5,000 87,923 11.2% 67,406 10.3% 6,916 7,000 64.9% 750 50.0% 18,000 7,000 94,224 11.3% 73,630 10.2% 7,545 2月 3 256 100 107.0% 216 84.4% 231 90.3% 653,136 39,737
44,592 7.1% 7,000 53.3% 800 84.7% 28,792 8,000 87,828 14.0% 60,363 12.5% 7,545
44,592 6.1% 7,000 53.3% 800 84.7% 28,792 8,000 97,553 13.3% 70,429 12.5% 8,804
13,281 320 0 44,822 5.7% 23,627.00 15,783 7,844 0 500 20,155 0 40 200 300 29,731 3.8% 4,781 24,950 0 0 19,610 2.5% 9,805 9,805 9,405 1.2% 200 0 4,856 0 349
ห้องสมุดไป่ตู้
34,000 4.4% 7,000 62.5% 1,000 49.0% 18,000 8,000 93,124 12.0% 70,502 9.8% 6,916
49,600 6.4% 7,000 62.4% 1,000 100.8% 32,600 9,000 92,891 11.9% 70,238 9.8% 6,916
44,592 7.2% 7,000 53.3% 800 84.7% 28,792 8,000 79,966 12.8% 55,330 12.5% 6,916
0.0%
0.0%
0.0%
0.0%
0.0%
0.0%
0.0%
13,459 2,720 0 39,248 5.4% 25,086.00 17,353 7,733 0 500 13,162 0 0 200 300 37,635 5.1% 4,989 32,646 0 0 19,332 2.6% 9,666 9,666 9,178 1.3% 0 0 313 4,746 0 119
0 1,603 3,720 28,611 50 50
9月 1 256 100 92.4% 211 82.4% 195 76.2% 592,892 35,600
0 1,500 4,000 30,000 50 50
10月 3 256 100 94.0% 237 92.6% 223 87.0% 698,618 35,600
1.1 8.3 1.7 8.5
1.4 7.9 1.6 9.8
6.2 7.2 1.5 7.6
0.9 8.9 1.6 8.6
煤、燃气费 蒸气费
-
-
-
-
家酒店集团2015年酒店经营预算
5月 1 256 100 99.0% 224 87.5% 222 86.6% 696,456 34,651