based on the LBHP PROPERTIES key performance indicators worksheet and the assumptions to the assigned problems below answer the 7 assigned problems. 1. calculate the utility costs for this property electricity, water, gas, and steam? 2. what is the labor cost percentage? 3. what is the average daily rate? 4. what is the revenue per available room? 5. what is the gross operating profit per available room? 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?

G . L M N 1 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 Profit and Loss Statement EYE 6/30/18 REVENUES Rooms $ 9,021,500 Food & Beverage $ 4,857,500 TOTAL REVENUES $ 13,879,000 OPERATING EXPENSES Rooms $ 2,557,500 Food & Beverage 3,200,700 1 General/Administrative $ 1,069,900 2 Repair/Maintenance $ 595,200 Utilities $ 468,200 4 Marketing S 476,650 5 Franchise Fees $ 693,950 6 Management Fees S 324,000 7 Property Taxes/Insurance S 719,100 18 Professional Fees S 344,800 19 Depreciation $ 2,100,300 20 State Tax Fees S 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 5 160.304) Sheet1 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? G . L M N 1 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 Profit and Loss Statement EYE 6/30/18 REVENUES Rooms $ 9,021,500 Food & Beverage $ 4,857,500 TOTAL REVENUES $ 13,879,000 OPERATING EXPENSES Rooms $ 2,557,500 Food & Beverage 3,200,700 1 General/Administrative $ 1,069,900 2 Repair/Maintenance $ 595,200 Utilities $ 468,200 4 Marketing S 476,650 5 Franchise Fees $ 693,950 6 Management Fees S 324,000 7 Property Taxes/Insurance S 719,100 18 Professional Fees S 344,800 19 Depreciation $ 2,100,300 20 State Tax Fees S 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 5 160.304) Sheet1 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