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

F G H K ||| N 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% ASSIGNED PROBLEMS 1) Calculate the utility costs for this property Electricity Water Gas E 1 KEY PERFORMANCE INDICATORS WORKSHEET 2 LBHP PROPERTIES LLC 3 Profit and Loss Statement EYE 6/30/18 4 REVENUES 5 Rooms $ 9,021,500 6 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 S (60,304) 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