酒店預(yù)算表(帶公式)

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

一、營業(yè)收入,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"

二、減：營業(yè)成本,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"

后廚調(diào)料成本,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"

財務(wù)部,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"

內(nèi)部招待費,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、財務(wù)費用,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"

銀聯(lián)卡刷卡手續(xù)費,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"

金融機構(gòu)手續(xù)費,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"

其它財務(wù)費用,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