based on this worksheet and assumptions given complete the assigned problems 1-7

Assumptions to the assigned problems below 1) The hotel has 199 guest rooms with 194 in operation 2) Utilies Costs are 60% electricity, 24% water, 11% gas and 5% steam 3) Labor Costs are $1,069,900 4) Occupancy Rate is 75% KEY PERFORMANCE INDICATORS WORKSHEET LBHP PROPERTIES LLC 5 Profit and Loss Statement FYE 6/30/18 4 REVENUES 5 Rooms $ 9,021,500 Food & Beverage $ 4,857,500 7 TOTAL REVENUES $ 13,879,000 8 OPERATING EXPENSES 9 Rooms $ 2,557,500 10 Food & Beverage $ 3,200,700 11 General/Administrative 1,069,900 12 Repair/Maintenance $ 595,200 13 Utilities $ 468,200 14 Marketing $ 476,650 15 Franchise Fees $ 693,950 16 Management Fees $ 324,000 17 Property Taxes/Insurance $ 719,100 18 Professional Fees $ 344,800 19 Depreciation $ 2,100,300 20 State Tax Fees 4,900 21 Other Expenses $ 369,300 22 TOTAL OPERATING EXPENSES $ 12,924,500 23 NET OPERATING INCOME 954,500 24 OTHER INCOME/EXPENSES 25 Interest Income (167,000) 26 Interest Expenses 1,181,804 27 NET INCOME (60,304) ch ASSIGNED PROBLEMS 1) Calculate the utility costs for this property Electricity Water Gas Steam 2) What is the labor cost percentage? 3) What is the Average Daily Rate (ADR)? 4) What is the Revenue Per Available Room (RevPAR)? 5) What is the Gross Operating Profit Per Available Room (GOPPAR)? 6) What do these numbers tell you about the operation of this property? 7) What would you recommend to make this property more successful financially