酒店经营状况分析表(模板)

金额
占比
金额
占比
金额
占比
金额
占比
金额
占比
金额
平均出租率平均房价一、营业收入468650.05#N/A 314298.78100.00%9602.93100.00%0
#DIV/0!247601.7100.00%0
1、酒店业务收入456347.4597.37%303333.7896.51%4977.93
51.84%#DIV/0!239044.7
96.54% 1）净房金收入456347.45
#DIV/0!303333.78
100.00%0.00%#DIV/0!0.00% 2）电话费收入#DIV/0!0.00%0.00%#DIV/0!0.00% 3）洗衣收入#DIV/0!0.00%3434 1.13%#DIV/0!0.00% 4）会议类收入#DIV/0!0.00%0.00%#DIV/0!0.00% 5）客房赔偿类收入#DIV/0!0.00%0.00%#DIV/0!0.00% 6）餐饮收入#DIV/0!0.00%0.00%#DIV/0!0.00%3、招商租赁收入#N/A 0.00%0.00%#DIV/0!
0.00%4、加盟收入#N/A 0.00%0.00%0.00%5、其他收入
12302.6#N/A 10965 3.61%4625 1.52%#DIV/0!
8557
3.46% 1）前台小商品收入#N/A 0.00%0.00%0.00% 2）其他
#N/A
0.00%0.00%0.00%
0.00%
0.00%二、经营成本及费用小计356130.67#DIV/0!390024.81128.58%93643.001881.16%59424.39#DIV/0!198247.4082.93%325.00（一）、人工成本及费用130443.97#DIV/0!163346.2253.85%50936.771023.25%37880.94#DIV/0!85290.3535.68%325.00
1.工资99483.41#DIV/0!111296.2936.69%43290.47869.65%29995.38
#DIV/0!68482.2928.65%2.员工福利费825#DIV/0!23400.767.71%0.00%#DIV/0!622.50.26%3.社会保险费20765.16#DIV/0!20740.17 6.84%7321.3147.08%7560.56#DIV/0!7560.56 3.16%4.员工团险420
#DIV/0!325
0.11%325 6.53%325#DIV/0!325
0.14%3255.住房公积金#DIV/0!0.00%0.00%#DIV/0!0.00%6.员工宿舍费#DIV/0!0.00%0.00%#DIV/0!0.00%7.工作服费#DIV/0!0.00%0.00%#DIV/0!0.00%8.员工餐8950.4#DIV/0!7584.00 2.50%0.00%#DIV/0!8300 3.47%9.其他人力成本#DIV/0!0.00%0.00%#DIV/0!0.00%（二）、客房耗用52656.8#DIV/0!49088.816.18%5259.8105.66%5586.2#DIV/0!26478.411.08%01.客衣洗涤成本#DIV/0!0.00%0.00%#DIV/0!0.00%2.客房增值物品成本5000#DIV/0!6683 2.20%340.68%#DIV/0!0.00%3.客房布草租赁11172.4#DIV/0!0.00%5225.8104.98%5586.2#DIV/0!10812 4.52%4.客房一次性用品
18240#DIV/0!10000 3.30%0.00%#DIV/0!6588 2.76%5.客房布草洗涤费
15027.4#DIV/0!28905.89.53%0.00%#DIV/0!5378.4 2.25%6低值家具设备摊销（含被子的折旧）#DIV/0!
0.00%0.00%#DIV/0!0.00%6月
项目
酒店经营状况分析表
1月
2月
3月
4月
5月
（三）、餐饮成本35386#DIV/0!16019 5.28%6675134.09%6675#DIV/0!12380 5.18%0
1.早餐食材类35386#DIV/0!16019 5.28%6675134.09%6675#DIV/0!11780 4.93%
2.下午材料#DIV/0!0.00%0.00%#DIV/0!0.00%
3.餐饮易耗类#DIV/0!0.00%0.00%#DIV/0!0.00%
4.餐厅其他耗用类（报损类）#DIV/0!0.00%0.00%#DIV/0!6000.25%
（四）、前厅耗用类13400.16#DIV/0!8886.82 2.93%00.00%0#DIV/0!4449.8 1.86%0
1.前厅增值服务类1491.16#DIV/0!736.30.24%0.00%#DIV/0!8
2.80.03%
2.前厅易耗品类#DIV/0!2710.09%0.00%#DIV/0!0.00%
3.办公用品类#DIV/0!1800.06%0.00%#DIV/0!0.00%
4.前厅其他费用类9009#DIV/0!4499.520.06%0.00%#DIV/0!4367 1.83%
5.客人停车费290032002730
#DIV/0!0.00%0.00%#DIV/0!0.00%
（五）销售类费用16,614.4522941.25947.0305595.610
1.长包房佣金
2.中介佣金（携程）14736.2522136.25947.035218.58
3.通联手续费1878.2805377.03
（六）、能源燃料费40804.32#DIV/0!57984.3119.12%5228.1105.03%0#DIV/0!40347.1516.88%0
1.水费2980#DIV/0!29050.96%0.00%#DIV/0!3500 1.46%
2.电费29552#DIV/0!4596615.15%0.00%#DIV/0!315001
3.18%
3.取暖费/空调费#DIV/0!0.00%0.00%#DIV/0!0.00%
4.燃料费8272.32#DIV/0!9113.31 3.00%5228.110
5.03%#DIV/0!5347.15 2.24%
5.其他能源费用#DIV/0!0.00%0.00%#DIV/0!0.00%
（七）、维修维护费10860#DIV/0!10800.36%0.00%#DIV/0!7150.30%
（八）、通讯费7044.8#DIV/0!7054 2.33%7044.1141.51%6844.3#DIV/0!6844 2.86%0
1.有限电视6844.8#DIV/0!6854
2.26%6844.1137.49%6844.3#DIV/0!6844 2.86%
2.上网费#DIV/0!0.00%0.00%#DIV/0!0.00%
3.客用电话费#DIV/0!0.00%0.00%#DIV/0!0.00%
4.办公固定电话费#DIV/0!0.00%0.00%#DIV/0!0.00%
5.手机费200#DIV/0!2000.07%200 4.02%#DIV/0!0.00%
6.其他#DIV/0!0.00%0.00%#DIV/0!0.00%
八、广告宣传费#DIV/0!0.00%0.00%#DIV/0!0.00%
九、公告设施费10857.09#DIV/0!8601.00 2.84%1101.0022.12%1101.00#DIV/0!1101.000.46%1101.00垃圾清运费10000#DIV/0!8340.27%83416.75%834#DIV/0!8340.35%834治安联防费#DIV/0!0.00%0.00%#DIV/0!0.00%
消防费458.33#DIV/0!5000.00 1.65%0.00%#DIV/0!0.00%
绿化费165.42#DIV/0!0.00%0.00%#DIV/0!0.00%
控虫费233.33#DIV/0!267.000.09%267.00 5.36%267.00#DIV/0!267.000.11%267.00
办公费196.5#DIV/0!17000.56%0.00%#DIV/0!7580.32%
差旅费34.5#DIV/0!474.80.16%0.00%#DIV/0!0.00%
业务招待费2664.1#DIV/0!4960 1.64%0.00%#DIV/0!0.00%
邮电费#DIV/0!0.00%0.00%#DIV/0!0.00%
咨询#DIV/0!0.00%0.00%#DIV/0!0.00%
快递费87#DIV/0!0.00%490.98%#DIV/0!1100.05%
其他1679#DIV/0!4300 1.42%0.00%#DIV/0!6680.28%
印刷费160#DIV/0!0.00%0.00%#DIV/0!0.00%
培训费#DIV/0!0.00%0.00%#DIV/0!0.00%
绿植费#DIV/0!0.00%0.00%#DIV/0!0.00%
证照费与年检费#DIV/0!0.00%0.00%#DIV/0!0.00%
（十一)、其他费用33138.25#N/A37132.512.24%16077.28#N/A0#N/A13380.09#N/A0
信用卡手续费#N/A0.00%#N/A#N/A#N/A
其他费用#N/A0.00%#N/A#N/A#N/A
固定资产5268.36
加盟管理费27869.8937132.516077.2813380.09
（十二）、坏账及存货亏损#DIV/0!0.00%0.00%#DIV/0!0.00%
（十三）营业税金及附加81.7#DIV/0!6431.3 2.12%72.6 1.46%1336.95#DIV/0!750.03%
（十四）个所税22.03#DIV/0!24.810.01%252.32 5.07%#DIV/0!550.02%
三、营业毛利112519.38#DIV/0!-75726.03-24.96%-84040.07-1688.25%-59424.39#DIV/0!49354.3020.65%
四、非营业收入#DIV/0!0.00%0.00%#DIV/0!00.00%
五、非营业费用118629.5#DIV/0!95629.531.53%90629.51820.63%90629.5#DIV/0!63440.5826.54%63440.58投资摊销#DIV/0!0.00%0.00%#DIV/0!0.00%
建筑物租金及管理费90629.5#DIV/0!90629.529.88%90629.51820.63%90629.5#DIV/0!63440.5826.54%63440.58其他费用28000#DIV/0!5000 1.65%0.00%#DIV/0!0.00%
六、营业外支出0#DIV/0!0.00%0.00%0
罚没支出类#DIV/0!00.00%0.00%
七、利润总额-6110.12#DIV/0! -171,355.53-56.49% -174,669.57-3508.88% -150,053.89 -14,086.28-63440.58
八、还贷款 14,785.91 14,565.91 14,785.91
减：所得税0.00%0.00%
净利润0.00%0.00%
费用效率分析（每间夜） 4.140.00%
客用品 3.41 2.310.000.00%0.00 1.520.00
洗涤费0.68 6.680.000.00%0.00 1.280.00
水耗 6.700.670.00%0.000.840.00
电耗10.620.007.520.00
利润总额： -516,275.39利润总额(49%)： -252,974.94 2-4月还贷总额44137.73
1-6净利润：7-12净利润：
合计：。