酒店预算财务报表Excel图表.xls
- 文档编号:17680091
- 上传时间:2023-07-29
- 格式:XLS
- 页数:63
- 大小:489.50KB
酒店预算财务报表Excel图表.xls
《酒店预算财务报表Excel图表.xls》由会员分享,可在线阅读,更多相关《酒店预算财务报表Excel图表.xls(63页珍藏版)》请在冰点文库上搜索。
上上海海大大酒酒店店hotelshanghai财财务务预预算算FINANCIALFINANCIALBUDGETBUDGET20201717年年ForForthetheYearYearofof20201717编编制制日日期期:
20:
201616年年1111月月22日日分分发发Distribution:
董董事事长长ChairmanoftheBoard总总经经理理GeneralManager目目录录120201717年年度度上上海海酒酒店店经经营营预预算算报报告告2客客房房总总收收入入预预算算3经经营营损损益益汇汇总总表表4房房务务部部损损益益表表5餐餐饮饮部部损损益益表表6其其他他营营业业部部门门损损益益汇汇总总表表7财财务务部部损损益益表表8人人事事行行政政部部门门损损益益表表9总总经经理理室室损损益益表表10市市场场销销售售部部损损益益表表11维维修修和和能能源源损损益益表表12工工资资和和福福利利预预算算13餐餐饮饮收收入入预预算算20201717年年度度客客房房收收入入预预算算20171月2月3月4月5月6月7月8月9月10月11月12月总计每日可售房1781781781781781781781781781781781782136每月可售房55185162551853405518534055185518534055185340551865148出出租租率率34%34%32%32%51%51%60%60%60%60%59%59%56%56%56%56%70%70%63%63%70%70%57%57%56%56%平均房价(RMB)房夜总计18901630283031803320315031003100373034603730315036270总收入(RMB)细分市场房夜数公司散客30020080010001100110011001100130012001300110011600旅行社散客3003004504504503503503505004505003504800订房中心散客4503005006506506006006008007008006007250政府0000000000000会议/展览0010010010010050501501001501001000前台散客101030302020202030303020270旅行社团队001001001501501501501001501001501300机组0000000000000长住房8008008008008008008008008008008008009600其他折扣302050505030303050305030450总计房夜18901630283031803320315031003100373034603730315036270住店客人数37803260576064606790645063506350756070707560645073840细分市场平均房价(RMB)公司散客400400500500550500500500520500520480501旅行社散客260260350380380350350350400400400300318订房中心散客350330450480520450450450550550550420463政府会议/展览430400500500550500480480500500500430472前台散客440360530530500500460460600550600460518旅行社团队260260320400350300300300450450450280353机组长住房300300300310310310310310310310310300300其他折扣360300420420400400400400450450450350388总总计计平平均均房房价价323323311311403403427427452452415415413413413413462462451451462462390390420420细分市场客房收入(RMB)公司散客120000800004000005000006050005500005500005500006760006000006760005280005835000旅行社散客78000780001575001710001710001225001225001225002000001800002000001050001708000订房中心散客157500990002250003120003380002700002700002700004400003850004400002520003458500政府0000000000000会议0050000500005500050000240002400075000500007500043000496000前台散客4400360015900159001000010000920092001800016500180009200139900旅行社团队0032000400005250045000450004500045000675004500042000459000机组0000000000000长住房2400002400002400002480002480002480002480002480002480002480002480002400002944000其他折扣10800600021000210002000012000120001200022500135002250010500183800总总计计客客房房收收入入610700610700506600506600114140011414001357900135790014995001499500130750013075001280700128070012807001280700172450017245001560500156050017245001724500122970012297001522420015224200团代*2人打印日期:
2023/7/29上上海海大大酒酒店店KINGTOWNHotelSHANGHAI损损益益表表PROFIT&LOSSSTATEMENT经营损益汇总表2017预算合计假定条件/注解PROFIT&LOSSSTATEMENT2017BudgetAssumption/Comments一月Jan二月Feb三月Mar四月Apr五月May六月Jun七月Jul八月Aug九月Sep十月Oct十一月Nov营业收入GROSSOPERATINGREVENUE客务部Rooms15,354,90043.1%615,100510,2001,157,3001,373,8001,509,5001,317,5001,280,7001,289,9001,733,7001,578,5001,741,000餐饮部Food&Beverage20,223,96556.8%551,850847,0501,159,7501,334,3001,422,6901,534,5001,739,5251,890,6502,032,4002,345,4002,518,400其他运作部门OtherOperatingDept.9,6500.0%5605608501,0101,0007907007108708201,060营营业业收收入入合合计计TOTALOPERATINGREVENUE35,588,515100.0%1,167,5101,357,8102,317,9002,709,1102,933,1902,852,7903,020,9253,181,2603,766,9703,924,7204,260,460经营费用OPERATINGEXPENSES客务部Rooms12,622,97882.2%365,5292,073,568430,665476,0642,239,358468,635462,1932,178,995538,893525,6562,302,340餐饮部Food&Beverage10,255,77466.8%437,910561,286654,192732,217763,669803,527871,941925,742976,2381,108,8491,151,750其他运作部门OtherOperatingDept.8,03283.2%5004905505205201,452490490490490550财务部ccount&GENERALP&L628,8661.8%47,96650,95645,65645,42651,62647,52645,46645,46645,53676,08645,296总经理室损益表529,2941.5%44,27545,17543,67543,67545,17543,70543,70543,70543,67545,17543,675人事行政部门Administrative&General557,0351.6%58,50860,35827,30847,30830,30862,33827,33827,33863,30858,30837,208市场销售Sales&Marketing#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
维修Maintenance215,2350.6%15,42013,02014,27016,77018,97020,18017,18017,18017,18019,17025,670能源Utilities2,278,8376.4%117,04898,338164,763178,048187,381323,924179,459176,483223,763203,552229,992经经营营费费用用合合计计GROSSOPERATINGEXPENSES#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
3,337,0071,771,2881,647,7723,415,3991,909,0832,037,2873,836,482经营毛利GROSSOPERATINGPROFIT#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
-403,8171,081,5021,373,153-234,1391,857,8871,887,433423,978非经营费用TOTALNON-OPERATINGEXPENSES折旧及摊销Depreciation&Amortization120,0000.3%年10,00010,00010,00010,00010,00010,00010,00010,00010,00010,00010,000开业前费用摊销Pre-OpeningExp.Amortiz.10.0%年/10150,000150,000150,000150,000150,000150,000150,000150,000150,000150,000150,000城市房地产税PropertyTax194,1130.5%97,05797,056财产保险费PropertyInsurance120,0000.3%估计10,00010,00010,00010,00010,00010,00010,00010,00010,00010,00010,000存款利息收入Interest(Income)-0.0%借款利息支出LoanInterest-0.0%董事会费DirectorsExpenses-0.0%员工奖励费StaffIncentiveFee-0.0%估计汽车保险养路费9,0000.0%4,500其它非经营费用OtherNon-Op.Expenses-0.0%非非经经营营费费用用合合计计TOTALNON-OPERATINGEXPENSES443,1141.2%170,000170,000170,000267,057170,000170,000174,500170,000170,000267,056170,000营业利润OPERATINGPROFIT/(LOSS)#REF!
#REF!
#REF!
#REF!
#REF!
-573,817911,5021,198,653-404,1391,687,8871,620,377253,978加:
营业外收入Add:
Non-OperatingIncome0.0%减:
营业外支出Less:
Non-OperatingExpenses0.0%加:
以前年度损益调整Add:
AdjForPriorYear0.0%利利润润总总额额PROFIT/(LOSS)BEFORETAX#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
-573,817911,5021,198,653-404,1391,687,8871,620,377253,978减:
所得税Less:
IncomeTax0.0%净净利利润润NETPROFIT/(LOSS)AFTERTAX#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
-573,817911,5021,198,653-404,1391,687,8871,620,377253,978统统计计数数据据STATISTICS房间数RoomsAvailable2,136178178178178178178178178178178178天数Days366日历天数3129313031303131303130可出租房间数AvailableRoomNights65,1485,5185162551853405518534055185518534055185340已出租房间数OccupiedRoomNights36,2701,8901630283031803320315031003100373034603730出租率%Occupancy%56%34%32%51%60%60%59%56%56%70%63%70%平均房价AverageRoomRate420323311403427452415413413462451462住店客人数NumberofGuests73,8403,7803,2605,7606,4606,7906,4506,3506,3507,5607,0707,560餐饮就餐人数NumberofF&BCovers1,0308080808080809090909095客房部利润RoomDepartmentProfit4,206,12327.4%251,252-1,422,205841,7071,017,109-585,586973,857950,610-766,1921,324,1701,171,786-439,748餐饮部利润F&BDepartmentProfit5,134,77325.4%-170,812-24,224149,171231,596277,673335,476451,810539,322616,280771,154888,038其他运作部门利润OtherOp.Dept.Profit1,61816.8%6070300490480-662210220380330510工资总额TotalSalary&Wages5,068,55814.2%413,063442,563392,063392,063444,563392,063392,063392,063392,063426,563597,363总人工成本TotalLabourCost6,367,74117.9%507,478555,368486,478502,608555,108502,641498,478498,478498,478554,368706,778员工人数No.OfEmployee1911911911911911911911911911911911916打印日期:
2023/7/29上上海海大大酒酒店店KINGTOWNHotelSHANGHAI损损益益表表PROFIT&LOSSSTATEMENT7打印日期:
2023/7/29营业外收入NON-OPERATINGINCOME处理固定资产收益固定资产盘盈坏帐收入其他收入OtherIncome营业外收入合计TOTALNON-OPERATINGINCOME营业外支出NON-OPERATINGEXPENSES处理固定资产损失固定资产盘亏罚款支出捐赠支出非常损失其他支出OTHEREXPENSES营业外支出合计TOTALNON-OPERAINGEXPENSES上上海海大大酒酒店店KINGTOWNHotelSHANGHAI损损益益表表PROFIT&LOSSSTATEMENT8打印日期:
2023/7/29十二月Dec1,247,7002,847,4507204,095,870561,0811,268,4511,49081,86643,67557,40820,220196,0882,230,2791,865,59110,000150,00010,0004,500174,5001,691,0911,691,0911,691,091178315518315057%3906,45095889,3621,069,289-770392,063501,4781919打印日期:
2023/7/2910打印日期:
2023/7/2911上上海海大大酒酒店店KINGTOWNHotelSHANGHAI损损益益表表PROFIT&LOSSSTATEMENT前厅部损益表2017预算合计假定条件/注解F/ODEPARTMENTP&LSTATEMENT2017BudgetAssumption/Comments一月Jan二月Feb三月Mar四月Apr五月May六月Jun七月Jul八月Aug九月Sep十月Oct十一月Nov营业收入REVENUE散客F.I.T.130,70097.8%4,4003,60015,90015,90010,00010,000-9,2009,20018,00016,500团队Groups-0.0%长住户LongStaying-0.0%服务费ServiceCharge-0.0%其他收入OtherIncome2,8802.2%180180360360360180180180180180360营业收入合计TOTALREVENUE133,580100.0%4,5803,78016,26016,26010,36010,1801809,3809,38018,18016,860工资及福利PAYROLL&BENEFITS工资及薪金Salary&Wages1,023,600766.3%详见工资预算88,60085,00085,00085,00085,00085,00085,00085,00085,00085,00085,000加班费OvertimePay-0.0%-补助Allowance10,5227.9%877877877877877877877877877877877奖金Bonus50,00037.4%8,00020,000-20,000-2,000-其他工资Miscellaneous85,00063.6%-工资费用小计TOTALSALARIES&WAGES1,169,122875.2%97,477105,87785,87785,877105,87785,87785,87785,87785,87787,87785,877社会保险金SocialInsurance79,63659.6%养老/失业/大病/工伤/生育6,6366,6366,6366,6366,6366,6366,6366,6366,6366,6366,636住房公积金HousingFund71,40053.5%5,9505,9505,9505,9505,9505,9505,9505,9505,9505,9505,950员工福利FringeBenefits52,90439.6%教育/伙食4,4094,4094,4094,4094,4094,4094,4094,4094,4094,4094,409其他福利Miscellaneous-0.0%福利费用小计TOTALBENEFITS203,940152.7%16,99516,99516,99516,99516,99516,99516,99516,99516,99516,99516,995工资及福利合计TOTALPAYROLL&BENEFITS1,373,0611027.9%114,472122,872102,872102,872122,872102,872102,872102,872102,872104,872102,872其他营业费用OTHEREXPENSES制服费Uniforms-0.0%布草费Linen&Blankets-0.0%5洗涤费Laundry&DryCleaning32,40024.3%2,7002,7002,7002,7002,7002,7002,7002,7002,7002,7002,7001.3清洁用品Cleaning&CleaningSupplies5,4004.0%45045045045045045045045045045045011服务用品Supplies&Others23,50017.6%1,3001,3001,7002,1002,1002,0001,9001,9002,4002,5002,4000.2免费水果/食品Comp.Fruit/Food-0.0%0.2瓷器/玻璃器皿Glassware/Chinaware-0.0%1印刷及文具Printing&Stationery183,620137.5%9,1108,81013,61016,31016,31016,71015,01015,01019,61017,01019,610邮递费Postage-0.0%通讯费CommunicationFees15,51011.6%7807201,2001,4001,4001,3501,2601,2601,6201,5001,620差旅费TravellingExpenses-0.0%交通费TransportationFees2,4001.8%200200200200200200200200200200200客房佣金Commissions-0.0%预定费用ReservationServices2,4001.8%200200200200200200200200200200200电视及娱乐Tv&MovieExpenses-0.0%装饰费Decoration6,0004.5%500500500500500500500500500500500执照费Licenses-0.0%营业税RevenueTax-0.0%营业收入的5.5其他Miscellaneous1,2000.9%100100100100100100100100100100100维修费12,4809.3%1,0401,0401,0401,0401,0401,0401,0401,0401,0401,0401,040保洁费1,2000.9%100100100100100100100100100100100车辆费31,60023.7%2,0402,0402,5703,5702,5703,0402,0402,0403,0402,0402,570报刊费/快递26,76020.0%2,2302,2302,2302,2302,2302,2302,2302,2302,2302,2302,230其他营业费用合计TOTALOTHEREXPENSES344,470257.9%20,75020,39026,60030,90029,90030,62027,73027,73
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 酒店 预算 财务报表 Excel 图表