酒店财务表格-客房部损益表-Fixed-(2)

客务部损益表RoomsProfit&LossAccount酒店名称HotelName：更新日期Updated：2011年08月16日一月Jan二月Feb三月Mar四月Apr五月May六月Jun七月Jul八月Aug九月Sep十月Oct十一月Nov十二月Dec06预算Bgt营业收入Revenue散客F.I.T.1,148,6001,288,6801,535,0001,452,9001,262,4001,405,5001,539,4001,607,6501,600,7501,689,7501,662,6501,704,25017,897,530团队Groups334,400341,600526,080546,800687,600586,400675,600662,800740,000662,800651,200641,6007,056,880长住客LongStaying36,00050,40050,40057,60060,80068,40068,40068,40068,40076,00076,00087,400768,200服务费ServiceCharge-其他收入OtherIncome-营业收入合计TotalRevenue1,519,0001,680,6802,111,4802,057,3002,010,8002,060,3002,283,4002,338,8502,409,1502,428,5502,389,8502,433,25025,722,610经营费用DirectExpenses人工成本TotalLabourCosts#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!洗涤费Laundry&DryCleaning#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!制服费Uniforms#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!布草Linen&Blankets65,51265,51265,51265,51265,51265,51265,51265,51265,51265,51265,51265,512786,144清洁用品Cleaning&CleaningSupplies12,0578,40310,55710,28710,05410,30211,41711,69412,04612,14311,94912,166133,075服务用品Supplies&Others58,97664,84876,45576,30577,32576,84584,93086,86590,57089,10089,17590,975962,369印刷及文具Printing&Stationery6,0346,5197,8127,6497,5107,6588,3288,4948,7058,7638,6478,77794,896瓷器Chinaware-玻璃器皿Glassware-银器Silverware-通讯费CommunicationFees11,51911,68112,11112,05712,01112,06012,28312,33912,40912,42912,39012,433145,722旅行社佣金TravelAgentsCommissions#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!预定费用ReservationExpenses-差旅费TravellingExpenses-交通费TransportationFees1001001001001001001001001001001001001,200装饰费Decoration6,0006,0006,0006,0006,0006,0006,0006,0006,0006,0006,0006,00072,000电视及娱乐TV&MovieExpenses10,00010,00010,00010,00010,00010,00010,00010,00010,00010,00010,00010,000120,000执照费Licenses-营业税RevenueTax83,54592,437116,131113,152110,594113,317125,587128,637132,503133,570131,442133,8291,414,744其他Miscellaneous1,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,00012,000经营费用合计TotalDirectExpenses#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!部门利润DepartmentalProfit/(Loss)#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!部门利润%Dept.ProfittoRevenue#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!出租率Occupancy%50.0%58.1%66.0%68.1%66.8%67.8%73.4%75.0%80.8%77.0%78.6%77.6%69.8%售出房平均房价AverageRoomRate423.00423.99421.79412.28397.71409.60410.54410.97405.92415.85413.11412.07412.50人工分析LabourAnalysis基本工资BasicSalary&Wages49,15549,15549,15549,15549,15549,15549,15549,15549,15549,15549,15549,155589,860加班Overtime-补助Allowance24,57824,57824,57824,57824,57824,57824,57824,57824,57824,57824,57824,578294,936奖励金Incentives24,57824,57824,57824,57824,57824,57824,57824,57824,57824,57824,57824,578294,936奖金Bonus8,1928,1928,1928,1928,1928,1928,1928,1928,1928,1928,1928,19298,304休假工资VacationAccrual-其他Miscellaneous-工资合计TotalSalaries&Wages106,503106,503106,503106,503106,503106,503106,503106,503106,503106,503106,503106,5031,278,036员工福利FringeBenefits&Misc.#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!临时工工资CasualLabour-人工成本TotalLabourCost#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!人工成本%LabourCosttoRevenue#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!员工人数No.OfEmployee90909090909090909090909090客务部54货币单位：人民币元已出租房平均损益AmountPerOccupiedRoom酒店名称HotelName：更新日期Updated：2011年08月16日一月Jan二月Feb三月Mar四月Apr五月May六月Jun七月Jul八月Aug九月Sep十月Oct十一月Nov十二月Dec06预算Bgt已出租房间数TotalOccupied36864053509750875155512356625791603859405945606563642营业收入Revenue散客F.I.T.311.61317.96301.16285.61244.89274.35271.88277.61265.11284.47279.67281.00281.22团队Groups90.7284.28103.21107.49133.39114.46119.32114.45122.56111.58109.54105.79110.88长住客LongStaying9.7712.449.8911.3211.7913.3512.0811.8111.3312.7912.7814.4112.07服务费ServiceCharge-------------其他收入OtherIncome-------------营业收入合计TotalRevenue412.10414.68414.26404.42390.07402.16403.28403.87399.00408.84401.99401.20404.17经营费用DirectExpenses人工成本TotalLabourCosts#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!洗涤费Laundry&DryCleaning#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!制服费Uniforms#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!布草Linen&Blankets17.7716.1612.8512.8812.7112.7911.5711.3110.8511.0311.0210.8012.35清洁用品Cleaning&CleaningSupplies3.272.072.072.021.952.012.022.022.002.042.012.012.09服务用品Supplies&Others16.0016.0015.0015.0015.0015.0015.0015.0015.0015.0015.0015.0015.12印刷及文具Printing&Stationery1.641.611.531.501.461.491.471.471.441.481.451.451.49瓷器Chinaware-------------玻璃器皿Glassware-------------银器Silverware-------------通讯费CommunicationFees3.132.882.382.372.332.352.172.132.062.092.082.052.29旅行社佣金TravelAgentsCommissions#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!预定费用ReservationExpenses-------------差旅费TravellingExpenses-------------交通费TransportationFees0.030.020.020.020.020.020.020.020.020.020.020.020.02装饰费Decoration1.631.481.181.181.161.171.061.040.991.011.010.991.13电视及娱乐TV&MovieEx