餐饮财务管理分析表格式新

51475
61.46%
22.75%
0.58%
80935.7325 29.59% 52031.76 64.29%
19.02%
0.74% 101981.0513 37.83% 60482.4 59.31%
22.44%
管理费
4020 3798 3721 4467 4585 4412 4526 5482
管理费占总 费用的
1149.997 503.603 545.4
793 428.55 697.89 500.1355 604.9873
上月
当月
餐盒占总收入 的
总费用
总费用占营 业额的百分
比
总工资
总工资占总费 总工资占营
用的
业额的
0.86%
108087.337 42.11%
59482
55.03%
23.17%
0.66%
99299.6831 46.17% 58779.83 59.19%
综合成本率
毛利
毛利率
48.86% 47.35% 46.36% 46.34% 43.12% 39.97% 51.50% 44.84%
131271.4959 113239.2155 119711.8636 122950.7392 125383.3616 135797.5185 132663.8668 148693.404
17.71% 18.95% 19.60% 20.26% 21.04% 23.49% 22.87% 22.22%
193128 159776 163864 163659 154496 153248 186952 185988
96521.76606 77001.0453 77191.80712 75546.98295 66029.70639 60040.3624 99042.964 79720.5456
电占营业 额的
日杂
日杂占总 费用的
2.08% 2.32% 2.24% 2.18% 2.27% 2.21% 0.37% 0.19%
4979.737 5710.8531 4753.13155 4324.6118 4673.4001 5032.0997 6508.8726 7047.4907
4.61% 5.75% 6.99% 5.13% 4.86% 6.01% 8.04% 6.91%
3.72% 3.82% 5.47% 5.30% 4.77% 5.27% 5.59% 5.38%
管理费占营 业额的
1.57% 1.77% 1.67% 1.95% 2.08% 1.95% 1.65% 2.03%
电
5331 5000 5000 5000 5000 5000 1000 500
电占总费 用的
4.93% 5.04% 7.35% 5.93% 5.20% 5.97% 1.24% 0.49%
60.63% 62.02% 61.82% 60.06% 54.39% 54.34% 55.66% 55.86%
酒水毛利率
39.37% 37.98% 38.18% 39.94% 45.61% 45.66% 44.34% 44.14%
酒水利润
酒水占总收 入的
餐盒销售 额
餐盒成本
餐盒成本率
餐盒毛利 率
餐盒利润
49.98% 48.19% 47.11% 46.16% 42.74% 39.18% 52.98% 42.86%
50.02% 51.81% 52.89% 53.84% 57.26% 60.82% 47.02% 57.14%
96606.23394 82774.9547 86672.19288 88112.01705 88466.29361 93207.6376 87909.036 106267.4544
41554 37364 39940 41577 41166 47045 55425 53123
菜品成本
菜品成本率 菜品毛利率
菜品利润
菜品占厨房 水饺销售
总收入的
额
水饺成本
水饺成本 水饺毛利
率
率
水饺利润
水饺占厨房总 收入的
15834.3085 13672.794 14372.74875 16575.95102 15434.32932 16369.59727 24275.0864 23859.632
9.03% 6.48% 23.16% 16.85% 13.26% 23.01% 18.91% 17.33%
234 23418.15894
50
13989.5324
178 51852.32208
140 38746.67743
138 29379.25149
72 52120.08073
611 52339.1343
税费占营业 额的
0.66% 1.00% 0.96% 0.94% 0.97% 0.95% 0.16% 0.16%
水费
500 500 0 500 500 500 100 1202
水费占总费 用的
0.46% 0.50% 0.00% 0.59% 0.52% 0.60% 0.12% 1.18%
水费占营业 额的
27.33%
0.54% 68037.54155 30.49% 35755.83 52.55%
16.02%
0.54%
84344.0618 36.81% 54282.83 64.36%
23.69%
0.54%
96142.1101 43.61%
66961
69.65%
30.38%
0.60%
83749.4378 37.02%
其他费用
其他费用占 其他费用占 总费用的 总销售额的
营业净利润
营业净利 润率
其他收入
总净利
总净利率
3.25% 3.87% 3.73% 3.64% 3.78% 3.68% 3.05% 3.09%
23741.6 15035
8331.58 5293.62 3946.71 6850.3381 8007.4999 18505.5606
餐饮财务管理分析表格式
金蝶做 账软件 财税实 操
月份 总营业额 综合成本
1月 2月 3月 4月 5月 6月 7月 8月 9月 10月 11月 12月
256676 215065 223156 229130 220445 226222 273526 269568
125404.5041 101825.7845 103444.1364 106179.2608 95061.63841 90424.48147 140862.1332 120874.596
0.19% 0.23% 0.00% 0.22% 0.23% 0.22% 0.04% 0.45%
房租
8333 8333 8333 8333 8333 8333 8333 8333
房租占总费 用的
7.71% 8.39% 12.25% 9.88% 8.67% 9.95% 10.30% 8.17%
房租占营业 额的
21.97% 15.14% 12.25% 6.28% 4.11% 8.18% 9.89% 18.15%
9.25% 6.99% 3.73% 2.31% 1.79% 3.03% 2.93% 6.86%
23184.15894 13939.5324 51674.32208 38606.67743 29241.25149 52048.08073 51728.1343 46712.3527
日杂占营业 额的
1.94% 2.66% 2.13% 1.89% 2.12% 2.22% 2.38% 2.61%
税费
1700 2143 2143 2143 2143 2147 428.6 4.15% 2.54% 2.23% 2.56% 0.53% 0.42%
51.14% 52.65% 53.64% 53.66% 56.88% 60.03% 48.50% 55.16%
厨房总收入
厨房成本
厨房成本 率
厨房毛利率
厨房占总 收入的
菜品销售额
234682 197140 203804 205236 195662 200293 242377 239111
112356.0746 90673.8393 91564.55587 92122.93397 81464.03571 76409.95967 123318.0504 103580.1776
123 46835.3527
9.12% 6.50% 23.24% 16.91% 13.33% 23.04% 19.13% 17.37%
47.88% 45.99% 44.93% 44.89% 41.64% 38.15% 50.88% 43.32%
52.12% 54.01% 55.07% 55.11% 58.36% 61.85% 49.12% 56.68%
91.43% 91.67% 91.33% 89.57% 88.76% 88.54% 88.61% 88.70%
82.29% 81.05% 80.40% 79.74% 78.96% 76.51% 77.13% 77.78%
酒水销售 额
酒水成本
酒水成本率
19799 16508 18141 22646 23585 24568 29557 28450
12003.4265 10238.5482 11213.9805 13601.3268 12828.1527 13351.4118 16452.2183 15892.4057
38.11% 36.59% 35.99% 39.87% 37.49%
35% 43.80% 44.91%
61.89% 63.41% 64.01% 60.13% 62.51%
65% 56.20% 55.09%
25719.6915 23691.206 25567.25125 25001.04898 25731.67068 30675.40273 31149.9136 29263.368
7795.5735 6269.4518 6927.0195 9044.6732 10756.847 11216.588 13104.782 12557.594
7.71% 7.68% 8.13% 9.88% 10.70% 10.86% 10.81% 10.55%
2195 1417 1211 1248 1198 1361 1592 2007
1045.003 913.397 665.6
455 769.45 663.11 1091.865 1402.013
47.61% 64.46% 54.96% 36.46% 64.23% 48.72% 68.58% 69.86%
52.39% 35.54% 45.04% 63.54% 35.77% 51.28% 31.42% 30.14%