酒店预算表(带公式)

项目,行次,19年1月,19年2月,19年3月,19年4月,19年5月,19年6月,19年7月,19年8月,19年9月,19年10月,19年11月,19年12月,全年合计

一、营业收入,1,"886,250.00","791,500.00","632,750.00","630,750.00","1,258,250.00","1,285,000.00","1,361,250.00","1,572,250.00","1,129,250.00","1,260,250.00","1,029,250.00","1,153,250.00","12,990,000.00"

各月占比,2,6.82%,6.09%,4.87%,4.86%,9.69%,9.89%,10.48%,12.10%,8.69%,9.70%,7.92%,8.88%,100.00%

1、客房收入合计,3,"356,000.00","304,250.00","283,500.00","283,500.00","408,000.00","408,000.00","408,000.00","408,000.00","388,000.00","408,000.00","388,000.00","409,000.00","4,452,250.00"

房费收入,4,"350,000.00","300,000.00","280,000.00","280,000.00","400,000.00","400,000.00","400,000.00","400,000.00","380,000.00","400,000.00","380,000.00","400,000.00","4,370,000.00"

客房杂项收入,5,"5,000.00","3,250.00","2,500.00","2,500.00","7,000.00","7,000.00","7,000.00","7,000.00","7,000.00","7,000.00","7,000.00","8,000.00","70,250.00"

其它收入,6,"1,000.00","1,000.00","1,000.00","1,000.00","1,000.00","1,000.00","1,000.00","1,000.00","1,000.00","1,000.00","1,000.00","1,000.00","12,000.00"

2、餐饮收入合计,7,"522,000.00","482,000.00","342,000.00","342,000.00","842,000.00","842,000.00","942,000.00","1,152,000.00","732,000.00","842,000.00","632,000.00","732,000.00","8,404,000.00"

酒水等商品收入,8,"20,000.00","20,000.00","20,000.00","20,000.00","40,000.00","40,000.00","40,000.00","50,000.00","30,000.00","40,000.00","30,000.00","30,000.00","380,000.00"

食品收入,9,"400,000.00","400,000.00","300,000.00","300,000.00","700,000.00","700,000.00","800,000.00","1,000,000.00","600,000.00","800,000.00","600,000.00","600,000.00","7,200,000.00"

其它收入,10,"2,000.00","2,000.00","2,000.00","2,000.00","2,000.00","2,000.00","2,000.00","2,000.00","2,000.00","2,000.00","2,000.00","2,000.00","24,000.00"

婚庆收入,11,"100,000.00","60,000.00","20,000.00","20,000.00","100,000.00","100,000.00","100,000.00","100,000.00","100,000.00","100,000.00","100,000.00","100,000.00","1,000,000.00"

3、其它收入合计,12,"8,250.00","5,250.00","7,250.00","5,250.00","8,250.00","35,000.00","11,250.00","12,250.00","9,250.00","10,250.00","9,250.00","12,250.00","133,750.00"

会员卡收入,13,"2,000.00","2,000.00","1,000.00","1,000.00","2,000.00","3,000.00","3,000.00","3,000.00","3,000.00","3,000.00","3,000.00","3,000.00","29,000.00"

房屋出租收入,14,"1,250.00","1,250.00","1,250.00","1,250.00","1,250.00","1,250.00","1,250.00","1,250.00","1,250.00","1,250.00","1,250.00","1,250.00","15,000.00"

会议室出租收入,15,"5,000.00","2,000.00","5,000.00","3,000.00","5,000.00","6,000.00","7,000.00","8,000.00","5,000.00","6,000.00","5,000.00","8,000.00","65,000.00"

二、减：营业成本,17,"302,000.00","288,625.00","232,750.00","232,750.00","477,000.00","477,000.00","527,500.00","633,500.00","416,500.00","527,500.00","416,500.00","422,000.00","4,953,625.00"

后厨原材料成本,18,"180,000.00","180,000.00","135,000.00","135,000.00","315,000.00","315,000.00","360,000.00","450,000.00","270,000.00","360,000.00","270,000.00","270,000.00","3,240,000.00"

后厨调料成本,19,"20,000.00","20,000.00","15,000.00","15,000.00","35,000.00","35,000.00","40,000.00","50,000.00","30,000.00","40,000.00","30,000.00","30,000.00","360,000.00"

后厨燃料成本,20,"2,000.00","2,000.00","1,500.00","1,500.00","3,500.00","3,500.00","4,000.00","5,000.00","3,000.00","4,000.00","3,000.00","3,000.00","36,000.00"

酒水成本,21,"10,000.00","10,000.00","10,000.00","10,000.00","20,000.00","20,000.00","20,000.00","25,000.00","15,000.00","20,000.00","15,000.00","15,000.00","190,000.00"

客房成本,22,"87,500.00","75,000.00","70,000.00","70,000.00","100,000.00","100,000.00","100,000.00","100,000.00","95,000.00","100,000.00","95,000.00","100,000.00","1,092,500.00"

商品成本,23,"2,500.00","1,625.00","1,250.00","1,250.00","3,500.00","3,500.00","3,500.00","3,500.00","3,500.00","3,500.00","3,500.00","4,000.00","35,125.00"

婚庆成本,24,"50,000.00","30,000.00","10,000.00","10,000.00","50,000.00","50,000.00","50,000.00","50,000.00","50,000.00","50,000.00","50,000.00","50,000.00","500,000.00"

三、减：管理费用,32,"522,932.38","510,274.25","507,496.13","408,461.13","357,442.38","430,910.50","452,244.88","445,937.38","427,184.88","529,477.38","515,434.88","527,604.88","5,635,401.00"

1、工资及福利费用,33,"298,367.00","298,367.00","298,367.00","298,367.00","298,367.00","298,367.00","298,367.00","298,367.00","298,367.00","298,367.00","298,367.00","298,367.00","3,580,404.00"

客房部,34,"55,000.00","55,000.00","55,000.00","55,000.00","55,000.00","55,000.00","55,000.00","55,000.00","55,000.00","55,000.00","55,000.00","55,000.00","660,000.00"

餐饮部,35,"159,100.00","159,100.00","159,100.00","159,100.00","159,100.00","159,100.00","159,100.00","159,100.00","159,100.00","159,100.00","159,100.00","159,100.00","1,909,200.00"

综合部,36,"5,500.00","5,500.00","5,500.00","5,500.00","5,500.00","5,500.00","5,500.00","5,500.00","5,500.00","5,500.00","5,500.00","5,500.00","66,000.00"

财务部,37,"26,167.00","26,167.00","26,167.00","26,167.00","26,167.00","26,167.00","26,167.00","26,167.00","26,167.00","26,167.00","26,167.00","26,167.00","314,004.00"

工程部,38,"22,500.00","22,500.00","22,500.00","22,500.00","22,500.00","22,500.00","22,500.00","22,500.00","22,500.00","22,500.00","22,500.00","22,500.00","270,000.00"

安保部,39,"12,200.00","12,200.00","12,200.00","12,200.00","12,200.00","12,200.00","12,200.00","12,200.00","12,200.00","12,200.00","12,200.00","12,200.00","146,400.00"

福利费,40,"14,000.00","14,000.00","14,000.00","14,000.00","14,000.00","14,000.00","14,000.00","14,000.00","14,000.00","14,000.00","14,000.00","14,000.00","168,000.00"

保险,41,750.00,750.00,750.00,750.00,750.00,750.00,750.00,750.00,750.00,750.00,750.00,750.00,"9,000.00"

奖金,42,"3,000.00","3,000.00","3,000.00","3,000.00","3,000.00","3,000.00","3,000.00","3,000.00","3,000.00","3,000.00","3,000.00","3,000.00","36,000.00"

员工生日费,43,150.00,150.00,150.00,150.00,150.00,150.00,150.00,150.00,150.00,150.00,150.00,150.00,"1,800.00"

2、一般管理费用,44,"12,506.00","12,506.00","12,506.00","12,506.00","12,506.00","12,506.00","12,506.00","12,506.00","12,506.00","12,506.00","12,506.00","12,506.00","150,072.00"

差旅费,45,"1,000.00","1,000.00","1,000.00","1,000.00","1,000.00","1,000.00","1,000.00","1,000.00","1,000.00","1,000.00","1,000.00","1,000.00","12,000.00"

收视费,46,"1,170.00","1,170.00","1,170.00","1,170.00","1,170.00","1,170.00","1,170.00","1,170.00","1,170.00","1,170.00","1,170.00","1,170.00","14,040.00"

通信费,47,500.00,500.00,500.00,500.00,500.00,500.00,500.00,500.00,500.00,500.00,500.00,500.00,"6,000.00"

办公费,48,936.00,936.00,936.00,936.00,936.00,936.00,936.00,936.00,936.00,936.00,936.00,936.00,"11,232.00"

内部招待费,49,"5,000.00","5,000.00","5,000.00","5,000.00","5,000.00","5,000.00","5,000.00","5,000.00","5,000.00","5,000.00","5,000.00","5,000.00","60,000.00"

车辆费用,50,400.00,400.00,400.00,400.00,400.00,400.00,400.00,400.00,400.00,400.00,400.00,400.00,"4,800.00"

运杂费,51,"1,000.00","1,000.00","1,000.00","1,000.00","1,000.00","1,000.00","1,000.00","1,000.00","1,000.00","1,000.00","1,000.00","1,000.00","12,000.00"

清洁费,52,"1,000.00","1,000.00","1,000.00","1,000.00","1,000.00","1,000.00","1,000.00","1,000.00","1,000.00","1,000.00","1,000.00","1,000.00","12,000.00"

销售费用,53,500.00,500.00,500.00,500.00,500.00,500.00,500.00,500.00,500.00,500.00,500.00,500.00,"6,000.00"

其它费用,54,"1,000.00","1,000.00","1,000.00","1,000.00","1,000.00","1,000.00","1,000.00","1,000.00","1,000.00","1,000.00","1,000.00","1,000.00","12,000.00"

3、财务费用,55,"2,465.63","2,228.75","1,831.88","1,826.88","3,395.63","3,462.50","3,653.13","4,180.63","3,073.13","3,400.63","2,823.13","3,133.13","35,475.00"

银联卡刷卡手续费,56,"2,215.63","1,978.75","1,581.88","1,576.88","3,145.63","3,212.50","3,403.13","3,930.63","2,823.13","3,150.63","2,573.13","2,883.13","32,475.00"

金融机构手续费,57,150.00,150.00,150.00,150.00,150.00,150.00,150.00,150.00,150.00,150.00,150.00,150.00,"1,800.00"

其它财务费用,58,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,"1,200.00"

4、营运部门费用,59,"14,593.75","13,172.50","10,791.25","10,761.25","20,173.75","20,575.00","21,718.75","24,883.75","18,238.75","20,203.75","16,738.75","18,598.75","210,450.00"

洗涤费,60,"13,293.75","11,872.50","9,491.25","9,461.25","18,873.75","19,275.00","20,418.75","23,583.75","16,938.75","18,903.75","15,438.75","17,298.75","194,850.00"

服装费,61,500.00,500.00,500.00,500.00,500.00,500.00,500.00,500.00,500.00,500.00,500.00,500.00,"6,000.00"

印刷品,62,300.00,300.00,300.00,300.00,300.00,300.00,300.00,300.00,300.00,300.00,300.00,300.00,"3,600.00"

装饰费,63,500.00,500.00,500.00,500.00,500.00,500.00,500.00,500.00,500.00,500.00,500.00,500.00,"6,000.00"

5、物料消耗,64,"5,000.00","5,000.00","5,000.00","5,000.00","5,000.00","5,000.00","5,000.00","5,000.00","5,000.00","5,000.00","5,000.00","5,000.00","60,000.00"

工程用品,65,"2,000.00","2,000.00","2,000.00","2,000.00","2,000.00","2,000.00","2,000.00","2,000.00","2,000.00","2,000.00","2,000.00","2,000.00","24,000.00"

客房用品,66,"1,000.00","1,000.00","1,000.00","1,000.00","1,000.00","1,000.00","1,000.00","1,000.00","1,000.00","1,000.00","1,000.00","1,000.00","12,000.00"

餐饮用品,67,"2,000.00","2,000.00","2,000.00","2,000.00","2,000.00","2,000.00","2,000.00","2,000.00","2,000.00","2,000.00","2,000.00","2,000.00","24,000.00"

6、能源费用,68,"187,000.00","176,000.00","176,000.00","77,000.00","15,000.00","88,000.00","108,000.00","98,000.00","87,000.00","187,000.00","177,000.00","187,000.00","1,563,000.00"

水费,69,"7,000.00","6,000.00","6,000.00","7,000.00","7,000.00","8,000.00","8,000.00","8,000.00","7,000.00","7,000.00","7,000.00","7,000.00","85,000.00"

电费,70,"80,000.00","70,000.00","70,000.00","70,000.00","8,000.00","80,000.00","100,000.00","90,000.00","80,000.00","80,000.00","70,000.00","80,000.00","878,000.00"

供暖费,71,"100,000.00","100,000.00","100,000.00",-,-,-,-,-,-,"100,000.00","100,000.00","100,000.00","600,000.00"

7、维修费用,72,"3,000.00","3,000.00","3,000.00","3,000.00","3,000.00","3,000.00","3,000.00","3,000.00","3,000.00","3,000.00","3,000.00","3,000.00","36,0