酒店收入估算预测模型

项目房间数出租率豪华客房房费间夜数收入平均房价房费收入房间数出租率营业收入标准间房费收间夜数入平均房价房费收入房费收入小计餐饮收入酒吧收入合计营业税金客房成本餐饮成本营业成本酒吧成本合计人员工资职工保险及福利水费电费燃气(煤炭)营业费用销售佣金市场费用日常运营费用不可预见费用费用合计预提折损重装费用利润6月份7月份8月份9月份10月份2050.00%3101,200.00372,0003030.00%279600.00167,400539,400226,020107,880873,30048,03226,50579,10732,364137,976106,74047,07210,24023,10030,00037,20050,00030,00010,000344,352100,000242,94111月份2050.00%310800.00248,000300.00%00248,000175,80049,600473,40026,03713,95061,53014,88090,36090,00039,6907,84017,10140,00024,80050,00030,00010,000309,431100,000-52,4282020202050.00%70.00%100.00%100.00%3104346206201,200.001,200.001,200.001,200.00372,000520,800744,000744,0003030303050.00%70.00%100.00%100.00%465651930930800.00800.00800.00800.00372,000520,800744,000744,000744,0001,041,6001,488,0001,488,000259,500315,300399,000399,000148,800208,320297,600297,6001,152,3001,565,2202,184,6002,184,60063,37786,087120,153120,15334,87548,82569,75069,750116,775110,355139,650139,65044,64062,49689,28089,280196,290221,676298,680298,680127,200142,080164,400164,40056,09562,65772,50072,50011,91414,39118,10818,10827,28533,47842,76942,76920,00020,00020,00020,00037,20052,08074,40074,40050,00050,00050,00050,00030,00030,00030,00030,00010,00010,00010,00010,000369,694414,687482,177482,177100,000422,940100,000100,000100,000742,7701,183,5901,183,5901、职工保险及公积金占工资的比例分别为：养老20%，医疗9%，大病1%，失业1%，工伤0.3%，生育02、酒吧收入是客房收入的20%，酒吧成本是酒吧收入30%3、燃气费用均暂估

4、客房成本按45元/间夜5、餐饮成本率按45%

6、餐饮收入按每间夜带来1.5个客人，人均消费120元/天计算，另外全年平均每月接待散客1000位7、客房收入不包含早餐收入

8.以上成本支出不含财务成本和折旧费

算（模型）

12月份2050.00%310600.00186,000300.00%00186,000175,80037,200399,00021,94513,95061,53011,16086,64090,00039,6907,39415,98540,00018,60050,00030,00010,000301,669100,000-111,2541月份2050.00%310500.00155,000300.00%00155,000175,80031,000361,80019,89913,95061,5309,30084,78090,00039,6907,17115,42740,00015,50050,00030,00010,000297,788100,000-140,6672月份2050.00%310500.00155,000300.00%00155,000175,80031,000361,80019,89913,95061,5309,30084,78090,00039,6907,17115,42740,00015,50050,00030,00010,000297,788100,000-140,6673月份2050.00%310500.00155,000300.00%00155,000175,80031,000361,80019,89913,95061,5309,30084,78090,00039,6907,17115,42740,00015,50050,00030,00010,000297,788100,000-140,6674月份2050.00%310800.00248,000300.00%00248,000175,80049,600473,40026,03713,95061,53014,88090,36090,00039,6907,84017,10130,00024,80050,00030,00010,000299,431100,000-42,4285月份2060.00%3721,200.00446,4003020.00%186600.00111,600558,000220,440111,600890,04048,95225,11077,15433,480135,744101,16044,61210,34023,35120,00044,64050,00030,00010,000334,102100,000271,241合计4860.83%4,526800.004,346,2005030.83%3,441772.972,659,8007,006,0002,874,0601,401,20011,281,260620,469358,5151,005,921420,3601,784,7961,345,980593,577127,688289,219360,000434,620600,000360,000120,0004,231,0841,200,0003,418,961生育0.8%，公积金12%，合计比例为：44.1%

00位