2020年最新酒店宾馆全年各部门经营预算模板(带公式)

目录 2020年酒店宾馆全年各部门经营预算模板(带公式) 经营预算模板 页码 内容 1 目录 2 - 4 经营预算汇总表 5 - 15 部门预算明细表 16 - 29 餐饮各营业点利润明细表 30 - 33 销售费用明细表 34 - 36 管理费用明细表 37 财务费用明细表&C4-&P汇总 2020年酒店宾馆全年各部门经营预算模板(带公式) 经营预算至十二月截止 经营预算汇总表 项目 本年预测 经营预算年预算 差异 一月 二月 三月 四月 五月 六月 七月 八月 九月 十月 十一月 十二月 含免费房出租率 70.7% 77.1% 6.4% 83.2% 75.9% 86.3% 86.3% 74.9% 72.8% 73.8% 73.8% 72.8% 75.9% 73.8% 74.9% 不含免费房出租率 74.1% 80.0% 73.0% 83.0% 83.0% 72.0% 70.0% 71.0% 71.0% 70.0% 73.0% 71.0% 72.0% 含免费房平均房费 0.00 135.18 0.00 142.31 134.62 137.50 142.31 133.65 132.69 132.69 132.69 132.21 132.69 133.17 133.17 不含免费房平均房费 140.59 148.00 140.00 143.00 148.00 139.00 138.00 138.00 138.00 137.50 138.00 138.50 138.50 可使用房间 113,150 37,698 (75,452) 3,193 2,987 3,193 3,090 3,193 3,090 3,193 3,193 3,090 3,193 3,090 3,193 付费出租房间数 79,671 27,933 (51,738) 2,554 2,181 2,650 2,565 2,299 2,163 2,267 2,267 2,163 2,331 2,194 2,299 免费出租房间数 276 1,117 841 102 87 106 103 92 87 91 91 87 93 88 92 客人人均消费 0.00 126.17 0.00 131.38 126.05 127.28 131.49 125.05 124.72 124.17 124.35 124.32 124.14 124.99 124.47 收入 房费 0 0.0% 3,927,020 89.3% 0 377,992 305,340 378,950 379,620 319,561 298,494 312,846 312,846 297,413 321,678 303,869 318,412 食品 11,490,910 0.0% 220,442 5.0% (11,270,468) 20,155 17,214 20,913 20,243 18,144 17,068 17,891 17,891 17,068 18,397 17,315 18,144 酒水 418,088 0.0% 0 0.0% (418,088) 0 0 0 0 0 0 0 0 0 0 0 0 餐饮其他 4,493,678 0.0% 0 0.0% (4,493,678) 0 0 0 0 0 0 0 0 0 0 0 0 健身房 673,405 0.0% 0 0.0% (673,405) 0 0 0 0 0 0 0 0 0 0 0 0 电话 0 0.0% 6,000 0.1% 0 500 500 500 500 500 500 500 500 500 500 500 500 其他营业部门 0 0.0% 360 0.0% 0 30 30 30 30 30 30 30 30 30 30 30 30 商场，租金和其他收入 1,802,023 0.0% 244,240 5.6% (1,557,783) 20,020 20,020 20,520 20,520 20,520 20,520 20,020 20,520 20,520 20,520 20,520 20,020 收入合计 0 0.0% 4,398,062 100.0% 0 418,697 343,104 420,913 420,913 358,755 336,612 351,287 351,787 335,531 361,125 342,234 357,105 减 税金 0 0.0% 244,100 0.0% 244,100 23,239 19,042 23,362 23,361 19,912 18,682 19,497 19,525 18,622 20,043 18,995 19,820 净收入 0 100.0% 4,153,962 100.0% 0 395,458 324,062 397,552 397,552 338,843 317,930 331,790 332,262 316,909 341,081 323,239 337,285 销售成本 食品 9,152,065 79.6% 165,924 75.3% (8,986,141) 15,170 12,957 15,741 15,237 13,656 12,847 13,466 13,466 12,847 13,847 13,033 13,656 酒水 1,113,042 266.2% 0 0.0% (1,113,042) 0 0 0 0 0 0 0 0 0 0 0 0 餐饮其他 911,574 20.3% 0 0.0% (911,574) 0 0 0 0 0 0 0 0 0 0 0 0 健身房 9,150 1.4% 0 0.0% (9,150) 0 0 0 0 0 0 0 0 0 0 0 0 电话 0 0.0% 5,220 87.0% 5,220 435 435 435 435 435 435 435 435 435 435 435 435 其他营业部门 39,777 0.0% 0 0.0% (39,777) 0 0 0 0 0 0 0 0 0 0 0 0 商场，租金和其他 229,839 12.8% 88,944 36.4% (140,895) 7,212 7,212 7,512 7,512 7,512 7,512 7,212 7,512 7,512 7,512 7,512 7,212 销售成本合计 11,455,448 0.0% 260,088 5.9% (11,195,360) 22,817 20,604 23,688 23,184 21,603 20,794 21,113 21,413 20,794 21,794 20,980 21,303 0 工资及相关费用 0 客房 3,542,720 0.0% 0 0.0% 0 0 0 0 0 0 0 0 0 0 0 0 0 餐饮 7,900,526 0.0% 0 0.0% 0 0 0 0 0 0 0 0 0 0 0 0 0 健身房 178,871 0.0% 0 0.0% (178,871) 0 0 0 0 0 0 0 0 0 0 0 0 电话 68,558 0.0% 0 0.0% 0 0 0 0 0 0 0 0 0 0 0 0 0 其他营业部门 202,518 0.0% 0 0.0% 0 0 0 0 0 0 0 0 0 0 0 0 0 商场，租金和其他 0 0.0% 0 0.0% 0 0 0 0 0 0 0 0 0 0 0 0 0 工资合计 11,893,193 0.0% 0 0.0% 0 0 0 0 0 0 0 0 0 0 0 0 0 其他费用 客房 4,283,590 0.0% 433,401 11.0% (3,850,189) 38,444 35,103 39,263 38,451 36,193 34,585 35,529 35,500 34,556 36,271 34,187 35,322 餐饮 2,975,429 0.0% 32,493 14.7% (2,942,936) 2,804 2,645 2,845 2,809 2,695 2,639 2,681 2,681 2,639 2,709 2,651 2,695 健身房 156,816 0.0% 0 0.0% (156,816) 0 0 0 0 0 0 0 0 0 0 0 0 电话 95,678 0.0% 0 0.0% (95,678) 0 0 0 0 0 0 0 0 0 0 0 0 其他营业部门 197,082 0.0% 0 0.0% (197,082) 0 0 0 0 0 0 0 0 0 0 0 0 商场，租金和其他 0 0.0% 0 0.0% 0 0 0 0 0 0 0 0 0 0 0 0 0 其他费用合计 7,708,596 0.0% 465,894 10.6% (7,242,702) 41,248 37,748 42,108 41,260 38,888 37,224 38,210 38,181 37,195 38,980 36,838 38,017 费用总计 客房 7,826,310 0.0% 0 0.0% 0 0 0 0 0 0 0 0 0 0 0 0 0 餐饮 22,052,637 0.0% 0 0.0% 0 0 0 0 0 0 0 0 0 0 0 0 0 健身房 344,838 0.0% 0 0.0% (344,838) 0 0 0 0 0 0 0 0 0 0 0 0 电话 164,236 0.0% 0 0.0% 0 0 0 0 0 0 0 0 0 0 0 0 435 其他营业部门 439,377 0.0% 0 0.0% 0 0 0 0 0 0 0 0 0 0 0 0 0 商场，租金和其他 229,839 0.0% 88,944 36.4% (140,895) 7,212 7,212 7,512 7,512 7,512 7,512 7,212 7,512 7,512 7,512 7,512 7,212 费用总计 31,057,237 0.0% 0 0.0% 0 0 0 0 0 0 0 0 0 0 0 0 0 经营毛利润 客房 0 0.0% 0 0.0% 0 0 0 0 0 0 0 0 0 0 0 0 0 餐饮 (5,649,960) -34.4% 0 0.0% 0 0 0 0 0 0 0 0 0 0 0 0 0 健身房 328,568 48.8% 0 0.0% (328,568) 0 0 0 0 0 0 0 0 0 0 0 0 电话 0 0.0% 0 0.0% 0 0 0 0 0 0 0 0 0 0 0 0 37 其他营业部门 0 0.0% 0 0.0% 0 0 0 0 0 0 0 0 0 0 0 0 0 商场，租金和其他 1,572,184 87.2% 141,740 58.0% (1,430,444) 11,697 11,697 11,869 11,869 11,869 11,869 11,697 11,869 11,869 11,869 11,869 11,697 经营毛利润 0 0.0% 0 0.0% 0 0 0 0 0 0 0 0 0 0 0 0 0 间接部门费用 工资和相关费用 行政办公室 4,158,344 0.0% 0 0.0% 0 0 0 0 0 0 0 0 0 0 0 0 0 市场销售部 765,827 0.0% 0 0.0% 0 0 0 0 0 0 0 0 0 0 0 0 0 工程部 791,514 0.0% 0 0.0% 0 0 0 0 0 0 0 0 0 0 0 0 0 人事及 培训 焊锡培训资料ppt免费下载焊接培训教程 ppt 下载特设培训下载班长管理培训下载培训时间表下载 部 613,791 0.0% 0 0.0% 0 0 0 0 0 0 0 0 0 0 0 0 0 工资和相关费用合计 6,329,475 0.0% 0 0.0% 0 0 0 0 0 0 0 0 0 0 0 0 0 其他费用 行政办公室 1,068,005 0.0% 99,207 2.3% (968,798) 8,318 8,245 8,319 8,320 8,260 8,238 8,253 8,253 8,237 8,262 8,244 8,258 市场销售部 1,254,348 0.0% 18,000 0.4% (1,236,348) 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 工程部 1,572,957 0.0% 81,600 1.9% (1,491,357) 6,800 6,800 6,800 6,800 6,800 6,800 6,800 6,800 6,800 6,800 6,800 6,800 人事及培训部 260,695 0.0% 2,400 0.1% (258,295) 200 200 200 200 200 200 200 200 200 200 200 200 其他费用合计 4,156,005 0.0% 201,207 4.6% (3,954,798) 16,818 16,745 16,819 16,820 16,760 16,738 16,753 16,753 16,737 16,762 16,744 16,758 未摊费用合计 行政办公室 5,226,349 0.0% 0 0.0% 0 0 0 0 0 0 0 0 0 0 0 0 0 市场销售部 2,020,175 0.0% 0 0.0% 0 0 0 0 0 0 0 0 0 0 0 0 0 工程部 2,364,471 0.0% 0 0.0% 0 0 0 0 0 0 0 0 0 0 0 0 0 人事及培训部 874,486 0.0% 0 0.0% 0 0 0 0 0 0 0 0 0 0 0 0 200 能源成本 5,862,566 0.0% 350,380 8.0% (5,512,186) 43,388 34,222 25,327 22,017 21,952 25,458 26,850 27,558 22,247 24,655 33,021 43,685 间接部门费用合计 16,348,046 0.0% 0 0.0% 0 0 0 0 0 0 0 0 0 0 0 0 0 集团管理费 1,862,694 0.0% 0 0.0% (1,862,694) 0 0 0 0 0 0 0 0 0 0 0 0 经营毛利润 0 0.0% 0 0.0% 0 0 0 0 0 0 0 0 0 0 0 0 0 经营毛利润% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 经营外固定费用 租金费用等 租金 1,047,512 0.0% 1,300,000 29.6% 252,488 108,333 108,333 108,333 108,333 108,333 108,333 108,333 108,333 108,333 108,333 108,333 108,337 贷款利息费用 0 0.0% 0 0.0% 0 0 0 0 0 0 0 0 0 0 0 0 0 集团管理费 0 0.0% 0 0.0% 0 0 0 0 0 0 0 0 0 0 0 0 0 保险费 18,220 0.4% 18,220 1,518 1,518 1,518 1,518 1,518 1,518 1,518 1,518 1,518 1,518 1,518 1,518 费用性税金 38,901 0.9% 0 0 9,502 0 0 9,736 0 0 9,814 0 0 9,849 租金费用等合计 1,047,512 0.0% 1,357,120 30.9% 309,609 109,851 109,851 119,353 109,851 109,851 119,587 109,851 109,851 119,665 109,851 109,851 119,704 折旧 折旧-客房家具 0 0.0% 150,789 3.4% 150,789 12,566 12,566 12,566 12,566 12,566 12,566 12,566 12,566 12,566 12,566 12,566 12,566 折旧-电器 118,007 2.7% 118,007 9,834 9,834 9,834 9,834 9,834 9,834 9,834 9,834 9,834 9,834 9,834 9,834 折旧-大型设备(电梯、太阳能等） 0 0.0% 0 0.0% 0 0 0 0 0 0 0 0 0 0 0 0 0 折旧-水电暖系统 0 0.0% 0 0.0% 0 0 0 0 0 0 0 0 0 0 0 0 0 分摊-开办费 0 0.0% 0 0 0 0 0 0 0 0 0 0 0 0 分摊-装修费 755,778 17.2% 62,982 62,982 62,982 62,982 62,982 62,982 62,982 62,982 62,982 62,982 62,982 62,982 分摊-无形资产摊销 9,600 0.2% 800 800 800 800 800 800 800 800 800 800 800 800 折旧合计 0 0.0% 1,034,175 23.5% 1,034,175 86,181 86,181 86,181 86,181 86,181 86,181 86,181 86,181 86,181 86,181 86,181 86,181 经营外固定费用合计 0 0.0% 2,391,295 54.4% 2,391,295 196,033 196,033 205,534 196,033 196,033 205,768 196,033 196,033 205,847 196,033 196,033 205,886 利润总额 0 0.0% 0 0.0% 0 0 0 0 0 0 0 0 0 0 0 0 0 所得税 2,366,895 0.0% 0 0.0% 0 0 0 0 0 0 0 0 0 0 0 0 0 净利润 0 0.0% 0 0.0% 0 0 0 0 0 0 0 0 0 0 0 0 0 工资及相关费用 18,222,668 0.0% 0 0.0% 0 0 0 0 0 0 0 0 0 0 0 0 0 服务费总额 0 0.0% 0 0.0% 0 0 0 0 0 0 0 0 0 0 0 0 0 服务费发放总额 0 0.0% 0 0.0% 0 0 0 0 0 0 0 0 0 0 0 0 0 附表 客人总数 76,132 34,858 3,187 2,722 3,307 3,201 2,869 2,699 2,829 2,829 2,699 2,909 2,738 2,869 员工总数 7,739 0 0 0 0 0 0 0 0 0 0 0 0 0 预定费用 0 0 0 0 0 0 0 0 0 0 0 0 0 0 市场费用 0 0 0 0 0 0 0 0 0 0 0 0 0 0 区域销售经费 0 0 0 0 0 0 0 0 0 0 0 0 0 0 集团培训费 0 0 0 0 0 0 0 0 0 0 0 0 0 0&C4-&P部门明细 ACCORASIA SofitelSilverPlazaJinan 2020年酒店宾馆全年各部门经营预算模板(带公式) TWELVEMONTHSENDINGDECEMBER2006 BUDGET2006OPERATINGSTATEMENT-DEPARTMENTAL 经营预算至十二月截止 经营预算明细表 项目 一月 二月 三月 四月 五月 六月 七月 八月 九月 十月 十一月 十二月 合计 % 2005年预测 % Acct. Description Input Annual Jan Feb Mar April May June July Aug Sep Oct Nov Nov TotalBudget2006 TotalForecast2005 Code Method Input % % STATISTICS No.ofRoomsBuilt 房间总数 perDay 105 105 105 105 105 105 105 105 105 105 105 105 1200 No.ofRoomsAvailable(ExclHouseUse) 每日可用房（酒店用房除外） perDay 103 103 103 103 103 103 103 103 103 103 103 103 1200 310 No.ofWeeksinPeriod 当月星期数 4.4 4.1 4.4 4.3 4.4 4.3 4.4 4.4 4.3 4.4 4.3 4.4 52 52 DaysinPeriod 当月天数 DaysperMth --> 31 29 31 30 31 30 31 31 30 31 30 31 366 365 Availablerooms(excl.Houseuse) 可用房（酒店用房除外） autocalc --> 3,193 2,987 3,193 3,090 3,193 3,090 3,193 3,193 3,090 3,193 3,090 3,193 37,698 113,150 TotalRoomRented-Paid 付费出租房间数 frommarketmix --> 2,554 2,181 2,650 2,565 2,299 2,163 2,267 2,267 2,163 2,331 2,194 2,299 27,933 79,671 TotalRoomRented-Complementary 免费房 frommarketmix --> 102 87 106 103 92 87 91 91 87 93 88 92 1,117 276 No.ofguestsaccom. 客人人数 autocalc --> 3,187 2,722 3,307 3,201 2,869 2,699 2,829 2,829 2,699 2,909 2,738 2,869 34,858 95,898 Occupancy% 含免费房出租率 autocalc --> 83.2% 75.9% 86.3% 86.3% 74.9% 72.8% 73.8% 73.8% 72.8% 75.9% 73.8% 74.9% 77.06% 71% 不含免费房出租率 80.0% 73.0% 83.0% 83.0% 72.0% 70.0% 71.0% 71.0% 70.0% 73.0% 71.0% 72.0% 74.10% 平均每间房入住人数 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 DoubleOccupancyFactor 含免费房平均房价 Ratio/mnth --> 142.31 134.62 137.50 142.31 133.65 132.69 132.69 132.69 132.21 132.69 133.17 133.17 135.18 1.2 AverageRoomRate 不含免费房平均房价 autocalc 148.00 140.00 143.00 148.00 139.00 138.00 138.00 138.00 137.50 138.00 138.50 138.50 140.59 489.33 ROOMSDEPARTMENT 房务部 TotalNetRevenue 收入 frommarketmix --> 377,992 305,340 378,950 379,620 319,561 298,494 312,846 312,846 297,413 321,678 303,869 318,412 3,927,020 100.0% 39,120,137 100.0% Add: 减： SalesTax 税金 0.0% 20,979 16,946 21,032 21,069 17,736 16,566 17,363 17,363 16,506 17,853 16,865 17,672 217,950 0.0% 0 0.0% TotalRevenue 净收入 autocalc 357,013 288,394 357,918 358,551 301,825 281,928 295,483 295,483 280,906 303,825 287,004 300,740 3,709,070 94.4% 0 100.0% 0.00% Payroll&RelatedExpenses 工资及相关费用 Salaries&Wages 工资 FromManningGuide 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% 1,363,345 3.5% EmployeeBenefits 员工福利 FromManningGuide 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% 2,179,375 5.6% TotalSalary&Wages 工资合计 autocalc 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% 3,542,720 9.1% OtherExpenses 其他费用 Laundry&Drycleaning 布草洗涤费 /fromlaundryallocation 13,546 11,568 14,056 13,605 12,500 11,500 12,000 12,000 11,500 12,500 11,000 11,500 147,275 3.8% 764,683 2.0% ContractServices 劳务费 /annum 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% 0 0.0% DataProcessing 电脑系统维护费 /annum 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 24,000 0.6% 38,272 0.1% Replacement 营业用品更新 /roomocc 796 796 695 695 681 649 649 620 620 620 620 570 8,011 0.2% 99,842 0.3% Uniforms 工装费 /annum 130 130 130 130 130 130 130 130 130 130 130 130 1,560 0.0% 112,246 0.3% CleaningSupplies 清洁用品 /roomocc 1,328 1,134 1,378 1,334 1,195 1,125 1,179 1,179 1,125 1,212 1,141 1,195 14,525 0.4% 176,010 0.4% GuestSupplies 客房用品 /roomocc 5,578 4,763 5,788 5,602 5,021 4,724 4,951 4,951 4,724 5,091 4,792 5,021 61,006 1.6% 768,661 2.0% Newspaper&Magazine 报刊杂志 /roomocc 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% 418,654 1.1% Printing&Stationary 办公用品 /annum 1,328 1,134 1,378 1,334 1,195 1,125 1,179 1,179 1,125 1,212 1,141 1,195 14,525 0.4% 127,204 0.3% Music&Entertainment 音乐娱乐 /annum 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% 0 0.0% GuestGratuities 免费赠送 /roomocc 531 454 551 534 478 450 472 472 450 485 456 478 5,811 0.1% 435,386 1.1% GuestTransportation 客人安置费用 /roomocc 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% 0 0.0% GuestRelocation 旅行社佣金 /roomocc 1,328 1,134 1,378 1,334 1,195 1,125 1,179 1,179 1,125 1,212 1,141 1,195 14,525 0.4% 0 0.0% TravelAgencyCommissions 差旅费 %roomrev 266 227 276 267 239 225 236 236 225 242 228 239 2,906 0.1% 718,994 1.8% 低值易耗品摊销 300 300 300 300 300 300 300 300 300 300 300 300 3,600 0.1% TravellingExpenses 鲜花植被装饰 /annum 531 681 551 534 478 450 472 472 450 485 456 717 6,277 0.2% 17,863 0.0% Decoration-Flowers 预定费用 /annum 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% 73,541 0.2% 电话费 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% ReservationExpenses 网络使用费 %roomrev 3,300 3,300 3,300 3,300 3,300 3,300 3,300 3,300 3,300 3,300 3,300 3,300 39,600 1.0% 34,007 0.1% Telephone,Postage&Cable 邮寄费 /annum 200 200 200 200 200 200 200 200 200 200 200 200 2,400 0.1% 33,439 0.1% Training 培训费 /annum 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% 2,260 0.0% OtherExpenses 收视费 /annum 2,834 2,834 2,834 2,834 2,834 2,834 2,834 2,834 2,834 2,834 2,834 2,834 34,008 0.9% 462,527 1.2% 其他 4,448 4,448 4,448 4,448 4,448 4,448 4,448 4,448 4,448 4,448 4,448 4,448 53,372 1.4% TotalOtherExpenses 其他费用合计 autocalc 38,444 35,103 39,263 38,451 36,193 34,585 35,529 35,500 34,556 36,271 34,187 35,322 433,401 11.0% 4,283,590 10.9% TotalExpenses 费用总计 autocalc 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% 7,826,310 20.0% DEPARTMENTALPROFIT/(LOSS) 部门损益 autocalc 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% 31,293,826 80.0% FOOD&BEVERAGEDEPARTMENT 餐饮部 FoodRevenue 食品收入 F&BOutlet1:CoffeeShop 早餐 fromF&BWksheet 20,155 17,214 20,913 20,243 18,144 17,068 17,891 17,891 17,068 18,397 17,315 18,144 220,442 100.0% 6,969,100 60.6% F&BOutlet2:Steak'nGrill 午晚简餐 fromF&BWksheet 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% 475,579 4.1% Banquet/Function fromF&BWksheet 4,046,231 35.2% TotalFoodRevenue 食品收入合计 20,155 17,214 20,913 20,243 18,144 17,068 17,891 17,891 17,068 18,397 17,315 18,144 220,442 100.0% 11,490,910 70.1% Beverage 酒水收入 F&BOutlet1:CoffeeShop 酒吧 fromF&BWksheet 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% 418,088 100.0% TotalBeverageRevenue 酒水收入合计 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% 418,088 2.5% OtherRevenue 其他收入 ConferenceRoomHire 会议室出租 fromF&BWksheet 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% 2,284,245 13.9% Conf.EquipmentHire 设备出租 fromF&BWksheet 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% 190,968 1.2% Tobaccorevenue 餐饮其他收入 fromF&BWksheet 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% 242,522 1.5% MooncakeRevenue 0 0.0% 1,775,943 10.8% TotalNetRevenue 合计餐饮收入 autocalc 20,155 17,214 20,913 20,243 18,144 17,068 17,891 17,891 17,068 18,397 17,315 18,144 220,442 100.0% 16,402,677 100.0% Add: 减： SalesTax 税金 fromF&BWksheet 1,119 955 1,161 1,123 1,007 947 993 993 947 1,021 961 1,007 12,234 5.5% 22,394 0.0% TotalRevenue 餐饮净收入 19,036 16,259 19,752 19,120 17,137 16,121 16,898 16,898 16,121 17,376 16,354 17,137 208,208 94.5% 0 100.0% CostofSales: 餐饮销售成本 CostofFoodSold 食品销售成本 fromF&BWksheet 15,170 12,957 15,741 15,237 13,656 12,847 13,466 13,466 12,847 13,847 13,033 13,656 165,924 75.3% 9,152,065 79.6% CostofBeverage 酒水销售成本 fromF&BWksheet 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% 1,113,042 266.2% CostofOtherIncome 餐饮其他成本 fromF&BWksheet 0 0.0% 911,574 20.3% TotalCostOfSales 销售成本合计 autocalc 15,170 12,957 15,741 15,237 13,656 12,847 13,466 13,466 12,847 13,847 13,033 13,656 165,924 75.3% 11,176,682 0.0% Payroll&RelatedExpenses 工资及相关费用 Salaries&Wages 工资 fromF&BWksheet 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% 3,204,349 0.0% EmployeesBenefits 员工福利 fromF&BWksheet 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% 4,696,177 0.0% TotalSalary&Wages 工资合计 autocalc 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% 7,900,526 0.0% OtherExpenses 其他费用 Licenses 执照费 fromF&BWksheet 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% 30,673 0.0% GuestGratuities 免费赠送 fromF&BWksheet 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% 23,085 0.0% RentalofEquipment 租赁费 fromF&BWksheet 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% 0 0.0% Laundry&DryCleaning 布草洗涤费 /fromlaundryallocation 200 200 200 200 200 200 200 200 200 200 200 200 2,400 1.1% 296,488 0.0% ContractServices 劳务费 fromF&BWksheet 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% 0 0.0% DataProcessing 电脑系统维护费 fromF&BWksheet 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% 69,591 0.0% KitchenFuel 厨房燃料 fromF&BWksheet 600 600 600 600 600 600 600 600 600 600 600 600 7,200 3.3% 402,672 0.0% ReplacemtChina/Glass/Silver&Linen 营业用品更新 fromF&BWksheet 250 250 250 250 250 250 250 250 250 250 250 250 3,000 1.4% 71,050 0.0% Uniform 工装费 fromF&BWksheet 150 150 150 150 150 150 150 150 150 150 150 150 1,800 0.8% 198,563 0.0% KitchenUtensils&Supplies 厨房用具 fromF&BWksheet 100 100 100 100 100 100 100 100 100 100 100 100 1,200 0.5% 25,623 0.0% CleaningSupplies 清洁用品 fromF&BWksheet 217 185 225 218 195 184 192 192 184 198 186 195 2,371 1.1% 199,882 0.0% GuestSupplies 客人用品 fromF&BWksheet 650 555 675 653 585 551 577 577 551 593 559 585 7,111 3.2% 250,524 0.0% Menus&BeverageList 菜单及酒水单 fromF&BWksheet 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% 12,448 0.0% Printing&Stationary 办公用品 fromF&BWksheet 100 100 100 100 100 100 100 100 100 100 100 100 1,200 0.5% 113,024 0.0% Decoration&Flowers 鲜花植被装饰 fromF&BWksheet 217 185 225 218 195 184 192 192 184 198 186 195 2,371 1.1% 184,787 0.0% Music&Entertainment 音乐娱乐 fromF&BWksheet 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% 525,331 0.0% TravellingExpenses 差旅费 fromF&BWksheet 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% 40,198 0.0% 低值易耗品摊销 200 200 200 200 200 200 200 200 200 200 200 200 2,400 1.1% Telephone,Postage&Cable 电话费 fromF&BWksheet 100 100 100 100 100 100 100 100 100 100 100 100 1,200 0.5% 39,497 0.0% Training 邮寄费 fromF&BWksheet 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% 13,686 0.0% OtherExpenses 培训费 fromF&BWksheet 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% 478,308 0.0% 其他 20 20 20 20 20 20 20 20 20 20 20 20 240 0.1% TotalOtherExpenses 其他费用合计 autocalc 2,804 2,645 2,845 2,809 2,695 2,639 2,681 2,681 2,639 2,709 2,651 2,695 32,493 14.7% 2,975,429 0.0% TotalExpenses 费用总计 autocalc 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% 22,052,637 0.0% DEPARTMENTALPROFIT/(LOSS) 部门损益 autocalc 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% 0 0.0% SPORT&RECREATIONALDPT 健身房 Rental/SellingofEquipment 设备出租及销售 /roomocc 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% 349,527 51.9% TourRevenue 团体收入 /roomocc 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% 0 0.0% UserFees 会员费 /roomocc 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% 143,891 21.4% Massage/Sauna 按摩/桑拿 /roomocc 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% 140,748 20.9% Other 其他 /annum 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% 39,239 5.8% TotalNetRevenue 收入合计 autocalc 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% 673,405 100.0% Add: 减： SalesTax 税金 0.0% 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% 0 0.0% TotalRevenue 总收入 0 0 0 0 0 0 0 0 0 0 0 0 0 100.0% 0 100.0% CostofSales: 成本 TotalRevenue-CostofSales 销售成本 %TotalRev 3.33% 0 0.0% 9,150 1.4% TotalCostOfSales 销售成本合计 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% 9,150 1.4% Payroll&RelatedExpenses 工资合计 Salaries&Wages 工资 FromManningGuide 0 0.0% 64,160 9.5% EmployeesBenefits 员工福利 FromManningGuide 0 0.0% 114,711 17.0% TotalSalary&Wages 工资合计 autocalc 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% 178,871 26.6% OtherExpenses 其他费用 ProfessionalFees 教练费 /annum 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% 0 0.0% Licenses 执照费 /annum 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% 0 0.0% RentalofEquipment 租赁费 /annum 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% 0 0.0% Laundry&DryCleaning 布草洗涤费 /fromlaundryallocation 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% 58,160 8.6% ContractServices 劳务费 /annum 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% 0 0.0% Energy 水电费 /annum 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% 0 0.0% MotorFuel-Vehicle&Boat 车辆费用 /annum 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% 0 0.0% Insurance 保险费 /annum 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% 0 0.0% Mai