酒店收支预算表-公式自动版 项目 一、营业收入 各月占比 1、客房收入合计 房费收入 客房杂项收入 其它收入 2、餐饮收入合计 酒水等商品收入 食品收入 其它收入 婚庆收入 3、其它收入合计 会员卡收入 房屋出租收入 会议室出租收入二、减：营业成本行次1234567891011121314151720年1月20年2月20年3月20年4月20年5月20年6月20年7月20年8月20年9月 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.006.82%6.09%4.87%4.86%9.69%9.89%10.48%12.10%8.69% 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 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 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 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 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 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 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 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 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 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 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 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 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.00122,000.00108,625.0097,750.0097,750.00162,000.00162,000.00167,500.00183,500.00146,500.00后厨原材料成本后厨调料成本后厨燃料成本酒水成本客房成本商品成本婚庆成本三、减：管理费用1、工资及福利费用客房部餐饮部综合部财务部工程部安保部福利费保险奖金员工生日费18192021222324323334353637383940414243180,000.0020,000.002,000.0010,000.0087,500.002,500.0050,000.00522,932.38298,367.0055,000.00159,100.005,500.0026,167.0022,500.0012,200.0014,000.00750.003,000.00150.00180,000.0020,000.002,000.0010,000.0075,000.001,625.0030,000.00510,274.25298,367.0055,000.00159,100.005,500.0026,167.0022,500.0012,200.0014,000.00750.003,000.00150.00135,000.0015,000.001,500.0010,000.0070,000.001,250.0010,000.00507,496.13298,367.0055,000.00159,100.005,500.0026,167.0022,500.0012,200.0014,000.00750.003,000.00150.00135,000.0015,000.001,500.0010,000.0070,000.001,250.0010,000.00408,461.13298,367.0055,000.00159,100.005,500.0026,167.0022,500.0012,200.0014,000.00750.003,000.00150.00315,000.0035,000.003,500.0020,000.00100,000.003,500.0050,000.00357,442.38298,367.0055,000.00159,100.005,500.0026,167.0022,500.0012,200.0014,000.00750.003,000.00150.00315,000.0035,000.003,500.0020,000.00100,000.003,500.0050,000.00430,910.50298,367.0055,000.00159,100.005,500.0026,167.0022,500.0012,200.0014,000.00750.003,000.00150.00360,000.0040,000.004,000.0020,000.00100,000.003,500.0050,000.00452,244.88298,367.0055,000.00159,100.005,500.0026,167.0022,500.0012,200.0014,000.00750.003,000.00150.00450,000.0050,000.005,000.0025,000.00100,000.003,500.0050,000.00445,937.38298,367.0055,000.00159,100.005,500.0026,167.0022,500.0012,200.0014,000.00750.003,000.00150.00270,000.0030,000.003,000.0015,000.0095,000.003,500.0050,000.00427,184.88298,367.0055,000.00159,100.005,500.0026,167.0022,500.0012,200.0014,000.00750.003,000.00150.002、一般管理费用差旅费收视费通信费办公费内部招待费车辆费用运杂费清洁费销售费用其它费用3、财务费用银联卡刷卡手续费金融机构手续费其它财务费用4、营运部门费用洗涤费服装费印刷品4445464748495051525354555657585960616212,506.001,000.001,170.00500.00936.005,000.00400.001,000.001,000.00500.001,000.002,465.632,215.63150.00100.0014,593.7513,293.75500.00300.0012,506.001,000.001,170.00500.00936.005,000.00400.001,000.001,000.00500.001,000.002,228.751,978.75150.00100.0013,172.5011,872.50500.00300.0012,506.001,000.001,170.00500.00936.005,000.00400.001,000.001,000.00500.001,000.001,831.881,581.88150.00100.0010,791.259,491.25500.00300.0012,506.001,000.001,170.00500.00936.005,000.00400.001,000.001,000.00500.001,000.001,826.881,576.88150.00100.0010,761.259,461.25500.00300.0012,506.001,000.001,170.00500.00936.005,000.00400.001,000.001,000.00500.001,000.003,395.633,145.63150.00100.0020,173.7518,873.75500.00300.0012,506.001,000.001,170.00500.00936.005,000.00400.001,000.001,000.00500.001,000.003,462.503,212.50150.00100.0020,575.0019,275.00500.00300.0012,506.001,000.001,170.00500.00936.005,000.00400.001,000.001,000.00500.001,000.003,653.133,403.13150.00100.0021,718.7520,418.75500.00300.0012,506.001,000.001,170.00500.00936.005,000.00400.001,000.001,000.00500.001,000.004,180.633,930.63150.00100.0024,883.7523,583.75500.00300.0012,506.001,000.001,170.00500.00936.005,000.00400.001,000.001,000.00500.001,000.003,073.132,823.13150.00100.0018,238.7516,938.75500.00300.00装饰费5、物料消耗工程用品客房用品餐饮用品6、能源费用水费电费供暖费7、维修费用维保费日常修理费弱电维修费四、营业外支出净额五、固定资产采购六、前期欠款偿还七、经营利润（GOP）6364656667686970717273747576777879500.005,000.002,000.001,000.002,000.00187,000.007,000.0080,000.00100,000.003,000.00500.005,000.002,000.001,000.002,000.00176,000.00500.005,000.002,000.001,000.002,000.00176,000.00500.005,000.002,000.001,000.002,000.0077,000.00500.005,000.002,000.001,000.002,000.0015,000.00500.005,000.002,000.001,000.002,000.0088,000.00500.005,000.002,000.001,000.002,000.00108,000.00500.005,000.002,000.001,000.002,000.0098,000.00500.005,000.002,000.001,000.002,000.0087,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 70,000.00 70,000.00 70,000.00 8,000.00 80,000.00 100,000.00 90,000.00 80,000.00100,000.003,000.00100,000.003,000.00 -3,000.00 -3,000.00 -3,000.00 -3,000.00 -3,000.00 -3,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.00500.00500.00500.00500.00500.00500.00500.00500.00500.00500.00500.00500.00500.00500.00500.00500.00500.00500.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 10,000.00 10,000.00 10,000.00 10,000.00 10,000.00 10,000.00 10,000.00 10,000.00 10,000.00 10,000.00 10,000.00 10,000.00 10,000.00 10,000.00 10,000.00 10,000.00 10,000.00 10,000.00 230,317.63 161,600.75 16,503.88 113,538.88 727,807.63 681,089.50 730,505.13 931,812.63 544,565.1320年10月20年11月20年12月全年合计 1,260,250.00 1,029,250.00 1,153,250.00 12,990,000.009.70%7.92%8.88%100.00% 408,000.00 388,000.00 409,000.00 4,452,250.00 400,000.00 380,000.00 400,000.00 4,370,000.00 7,000.00 7,000.00 8,000.00 70,250.00 1,000.00 1,000.00 1,000.00 12,000.00 842,000.00 632,000.00 732,000.00 8,404,000.00 40,000.00 30,000.00 30,000.00 380,000.00 800,000.00 600,000.00 600,000.00 7,200,000.00 2,000.00 2,000.00 2,000.00 24,000.00 100,000.00 100,000.00 100,000.00 1,000,000.00 10,250.00 9,250.00 12,250.00 133,750.00 3,000.00 3,000.00 3,000.00 29,000.00 1,250.00 1,250.00 1,250.00 15,000.00 6,000.00 5,000.00 8,000.00 65,000.00167,500.00146,500.00152,000.00 1,713,625.00360,000.0040,000.004,000.0020,000.00100,000.003,500.0050,000.00529,477.38298,367.0055,000.00159,100.005,500.0026,167.0022,500.0012,200.0014,000.00750.003,000.00150.00270,000.0030,000.003,000.0015,000.0095,000.003,500.0050,000.00515,434.88298,367.0055,000.00159,100.005,500.0026,167.0022,500.0012,200.0014,000.00750.003,000.00150.00270,000.0030,000.003,000.0015,000.00100,000.004,000.0050,000.00527,604.88298,367.0055,000.00159,100.005,500.0026,167.0022,500.0012,200.0014,000.00750.003,000.00150.00 360,000.00 360,000.00 36,000.00 190,000.00 1,092,500.00 35,125.00 500,000.00 5,635,401.00 3,580,404.00 660,000.00 1,909,200.00 66,000.00 314,004.00 270,000.00 146,400.00 168,000.00 9,000.00 36,000.00 1,800.0012,506.001,000.001,170.00500.00936.005,000.00400.001,000.001,000.00500.001,000.003,400.633,150.63150.00100.0020,203.7518,903.75500.00300.0012,506.001,000.001,170.00500.00936.005,000.00400.001,000.001,000.00500.001,000.002,823.132,573.13150.00100.0016,738.7515,438.75500.00300.0012,506.001,000.001,170.00500.00936.005,000.00400.001,000.001,000.00500.001,000.003,133.132,883.13150.00100.0018,598.7517,298.75500.00300.00 150,072.00 12,000.00 14,040.00 6,000.00 11,232.00 60,000.00 4,800.00 12,000.00 12,000.00 6,000.00 12,000.00 35,475.00 32,475.00 1,800.00 1,200.00 210,450.00 194,850.00 6,000.00 3,600.00500.005,000.002,000.001,000.002,000.00187,000.007,000.0080,000.00100,000.003,000.00500.005,000.002,000.001,000.002,000.00177,000.007,000.0070,000.00100,000.003,000.00500.005,000.002,000.001,000.002,000.00187,000.007,000.0080,000.00100,000.003,000.00 6,000.00 60,000.00 24,000.00 12,000.00 24,000.00 1,563,000.00 85,000.00 878,000.00 600,000.00 36,000.00 2,000.00 2,000.00 2,000.00 24,000.00500.00500.00500.00500.00500.00500.00 6,000.00 6,000.00 1,000.00 1,000.00 1,000.00 12,000.00 10,000.00 10,000.00 10,000.00 120,000.00 10,000.00 10,000.00 10,000.00 120,000.00 552,272.63 356,315.13 462,645.13 5,508,974.00