Solution 7.8

 

 

 

a)   Calculate the average room rate the hotel should charge to achieve their required return on capital. You may assume a corporation tax rate of 20 per cent and ignore any problems associated with double or single occupancy. 

This question requires the Hubbard approach to the calculation of average room rate. This is calculated by starting with the required return on capital invested. By adding back taxation, finance costs and fixed operating expenses, one arrives at the total contribution required to achieve the return on capital. By deducting the contribution from other revenue producing departments, one arrives at a room’s department contribution figure. This figure divided by the forecast number of bed-nights will calculate a contribution per room used. By adding the estimated variable cost per room, an average selling price per room is calculated. 

 

€

 

 

Net profit to achieve required return (200,000 x 15 per cent)

30,000

 

80%

Taxation (30,000 x 20 Έ 80)

  7,500

 

20%

Net profit before tax

37,500

 

100%

Loan interest  (800,000 x 9%)

  72,000

 

 

Net operating profit

109,500

 

 

Fixed costs

300,000

 

 

Total contribution

409,500

 

 

Contribution food and bar

  80,000

 

 

Room contribution

329,500

 

 

 

 

 

 

No of bed-nights (30 rooms x 75 per cent occupancy x 360 days)

8,100

 

 

 

 

 

 

Contribution per room (€329,500 Έ 8,100 days)

€40.67

 

 

Variable cost per room

€10.00

 

 

Selling price per room

€50.67

 

 

b)   If the double rooms are sold at a premium of €20 above the single rooms, what prices should be charged for each single and double room to achieve the owners required rate of return. You may assume that double occupancy as a percentage of overall occupancy is 60 per cent and there is no change to variable cost per room.

The approach in this part of the question is to let X = price of a single room. If that is the case the X + €20 = the price of a double room. Total sales is made up of 40% single rooms and 60% double. 

Total sales  =  Single room sales + double room sales

 

 

100%

        =

40%

 

60%

 

 

 

 

 

 

 

 

 

8,100

       =

3240

 

4860

 

 

 

 

 

 

 

 

 

410500

       =

3240

X          +

4860

(x + €20)

 

 

 

 

 

 

 

 

410500

      =

3240

X          +

4860

x   +  97,200

 

 

 

 

 

 

 

313,300

       =

8,100X

 

 

 

 

 

 

 

 

 

 

 

38.68

      =

X

 

 

 

 

 

 

 

 

 

 

 

Double rooms =

38.68 + 20

58.67

 

 

c) What other considerations would you take into account when looking for strategies to improve room occupancy.     

  • Level of competition
  • Seasonality
  • The level of demand
  • The state of the local and foreign economies
  • The cost structure of the business.
  • Local events
  • Advertising
  • Offering package deals to new and existing customers during off-peak period