酒店预算财务报表

损益表 PROFIT & LOSS STATEMENT2008 预算合计经营损益汇总表 PROFIT & LOSS STATEMENT2008 Budget营业收入 GROSS OPERATING REVENUE客务部 Rooms假定条件 / 注解％ption /Com一月 Jan二月 Feb三月 Mar四月 Apr五月 May六月 Jun七月 Jul八月 Aug九月 Sep十月 Oct十一月 Nov 12,283,92046.4%0.8 492,080餐饮部 Food & Beverage 14,156,77653.5%0.7 386,295其他运作部门 Other Operating Dept. 9,6500.0% 560营业收入合计 TOTAL OPERATING REVENUE 26,450,346100.0% 878,935经营费用 OPERATING EXPENSES 408,160 925,840 1,099,040 1,207,600 1,054,000 1,024,560 1,031,920 1,386,960 1,262,800 1,392,800 592,935 811,825 934,010 995,883 1,074,150 1,217,668 1,323,455 1,422,680 1,641,780 1,762,880 560 850 1,010 1,000 790 700 710 870 820 1,060 1,001,655 1,738,515 2,034,060 2,204,483 2,128,940 2,242,928 2,356,085 2,810,510 2,905,400 3,156,740 10,729,53187.3%0.9 310,699 1,762,533餐饮部 Food & Beverage 7,896,94664.3%0.8 337,191 432,191其他运作部门 Other Operating Dept. 8,03283.2% 500 490财务部Ａccount & GENERAL P&L 628,8662.4% 47,966 50,956总经理室损益表 529,2942.0% 44,275 45,175人事．行政部门 Administrative & General 557,0352.1% 58,508 60,358市场销售 Sales & Marketing#REF!#REF!#REF!#REF!维修 Maintenance 215,2350.8% 15,420 13,020能源 Utilities 1,823,0706.9%0.8 93,638 78,670经营费用合计 GROSS OPERATING EXPENSES#REF!#REF!#REF!#REF!客务部 Rooms 366,065 404,654 1,903,455 398,340 392,864 1,852,145 458,059 446,808 1,956,989 503,728 563,807 588,025 618,716 671,395 712,821 751,704 853,814 886,848 550 520 520 1,452 490 490 490 490 550 45,656 45,426 51,626 47,526 45,466 45,466 45,536 76,086 45,296 43,675 43,675 45,175 43,705 43,705 43,705 43,675 45,175 43,675 27,308 47,308 30,308 62,338 27,338 27,338 63,308 58,308 37,208#REF!#REF! 14,270 16,770 18,970 20,180 17,180 17,180 17,180 19,170 25,670 131,810 142,439 149,905 259,140 143,567 141,186 179,010 162,841 183,993#REF!#REF!#REF!#REF! 2,787,983 1,451,397 1,342,005 2,840,332 1,558,962 1,662,693 3,180,230 -583,500 677,543 900,922 -484,247 1,251,548 1,242,707 -23,490经营毛利 GROSS OPERATING PROFIT#REF!非经营费用 TOTAL NON-OPERATING EXPENSES折旧及摊销 Depreciation & Amortization 120,000开业前费用摊销 Pre-Opening Exp. Amortiz. 1,800,000城市房地产税 Property Tax#REF!#REF!#REF!0.5%５年 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,0006.8%５年/10 150,000 150,000 150,000 150,000 150,000 150,000 150,000 150,000 150,000 150,000 150,000 194,1130.7% 97,057 97,056财产保险费 Property Insurance 120,0000.5%估计 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000存款利息收入 Interest (Income) -0.0%借款利息支出 Loan Interest -0.0%董事会费 Director's Expenses -0.0%员工奖励费 Staff Incentive Fee -0.0%估计汽车保险．养路费 9,0000.0% 4,500其它非经营费用 Other Non-Op. Expenses -0.0%非经营费用合计 TOTAL NON-OPERATING EXPENSES 2,243,1138.5% 170,000 170,000 170,000 267,057 170,000 170,000 174,500 170,000 170,000 267,056 170,000营业利润 OPERATING PROFIT /(LOSS)#REF!0.0%0.0%0.0%#REF!0.0%#REF!#REF!#REF!#REF!#REF! -753,500 507,543 726,422 -654,247 1,081,548 975,651 -193,490加:营业外收入 Add:Non-Operating Income减:营业外支出 Less:Non-Operating Expenses加:以前年度损益调整Add:Adj For Prior Year利润总额 PROFIT /(LOSS) BEFORE TAX减:所得税 Less:Income Tax#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF! -753,500 507,543 726,422 -654,247 1,081,548 975,651 -193,490 -753,500 507,543 726,422 -654,247 1,081,548 975,651 -193,490净利润 NET PROFIT /(LOSS) AFTER TAX#REF!统计数据 STATISTICS 2,136天数 Days366可出租房间数 Available Room Nights 65,148已出租房间数 Occupied Room Nights 29,016出租率 % Occupancy %45%平均房价 Average Room Rate 420住店客人数 Number of Guests 73,840房间数 Rooms Available 178 178 178 178 178 178 178 178 178 178 178日历天 31 29 31 30 31 30 31 31 30 31 30 5,518 1,51227%5162130425%5518226441%5340254447%5518265649%5340252047%5518248045%5518248045%5340298456%5518276850%5340298456% 323 311 403 427 452 415 413 413 462 451 462 3,780 3,260 5,760 6,460 6,790 6,450 6,350 6,350 7,560 7,070 7,560餐饮就餐人数 Number of F&B Covers 1,030客房部利润 Room Department Profit 4,206,123餐饮部利润 F&B Department Profit 5,134,773其他运作部门利润 Other Op. Dept. Profit 1,618工资总额 Total Salary & Wages总人工成本 Total Labour Cost员工人数 No. Of Employee34.2%36.3%16.8%19.2%24.1% 80 80 80 80 80 80 90 90 90 90 95 251,252 -1,422,205 841,707 1,017,109 -585,586 973,857 950,610 -766,192 1,324,170 1,171,786 -439,748 -170,812 -24,224 149,171 231,596 277,673 335,476 451,810 539,322 616,280 771,154 888,038 60 70 300 490 480 -662 210 220 380 330 510 413,063 442,563 392,063 392,063 444,563 392,063 392,063 392,063 392,063 426,563 597,363 507,478 555,368 486,478 502,608 555,108 502,641 498,478 498,478 498,478 554,368 706,778 191 191 191 191 191 191 191 191 191 191 191 5,068,558 6,367,741 191十二月 Dec 998,160 1,993,215 720 2,992,095 476,919 976,707 1,490 81,866 43,675 57,408 20,220 156,870 1,815,156 1,176,939 10,000 150,000 10,000 4,500 174,500 1,002,439 1,002,439 1,002,439 178 315518252057% 390 6,450 95 889,362 1,069,289 -770 392,063 501,478 191