How could you make the three different alternative scenarios more realistic?

Managerial Accounting: The Cornerstone of Business Decision-Making
7th Edition
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Chapter7: Cost-volume-profit Analysis
Section: Chapter Questions
Problem 6MTC: Calculate the hotels margin of safety (both in units and in sales dollars) for Many Glacier Hotel,...
icon
Related questions
icon
Concept explainers
Topic Video
Question

Scenario:

Hotel XYZ is an independent city center hotel property with 200 rooms.

In general its Average Daily rate is approximately €100 throughout the year, and its runs at an average of 65% occupancy.

Its distribution channel mix is relatively simple. Currently approximately 50% of its bookings arrive at the hotel through direct channels, with business, leisure and meeting customers contacting the hotel directly.

The hotel is listed on the major GDS, generating approximately 10% of its business, while OTAs generate about 20% of its bookings, for which on average it pays a commission of 20% per booking.

The hotel has a direct brand.com website, which generates 10% of its bookings, while the remaining 10% come from other miscellaneous sources.

In terms of costs, the hotel estimates that the variable cost of selling a room is about €12. Each month the hotel’s labour cost is about €80,000 and Utilities / power & light about €50,000. The hotel has also budgeted €32,000 per month for sales and marketing expenses. A recent refurbishment of the property was financed by a bank the interest on which currently runs at €60,000 per month.

Right now the hotel’s owner is not happy with the level of profitability at the end of the month. Your general manager has asked you to quantitatively evaluate three different scenarios:

(1) Increasing the hotel’s average daily rate by 10%

(2) Increasing the number of bookings coming through OTA channels by 10%

(3) Increasing the number of bookings coming through your brand.com website by 10%

A spreadsheet with the above figures is provided in the “peer review documents” page, to help you undertake your assessment.

How could you make the three different alternative scenarios more realistic?

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Inventory management
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT