Antonio is the RM at the 180-room Hawthorne Suites. Disappointed in his occupancy rate last year, he decided to reduce his room rates this year by 10 percent to help increase sales and improve his RevPAR. This action resulted in an upswing in occupancy, from 75 percent last year, to 85 percent this year; an increase of 13.3 percent. Last year, Antonio’s controllable operating costs were $61.00 per room. This year, they rose to $62.00 per room, an increase of only 1.6 percent. Help Antonio better understand the overall results of his rate reduction strategy by completing his hotel’s May operating performance worksheet and then answering the questions that follow. Statistics Last May This May Occupancy % 75% 85% Rooms Sold     ADR $129.99 $116.99 Rooms Revenue     RevPAR     Controllable operating cost     Gross operating profit     GOPPAR

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question

1) Antonio is the RM at the 180-room Hawthorne Suites. Disappointed in his occupancy rate last year, he decided to reduce his room rates this year by 10 percent to help increase sales and improve his RevPAR. This action resulted in an upswing in occupancy, from 75 percent last year, to 85 percent this year; an increase of 13.3 percent.
Last year, Antonio’s controllable operating costs were $61.00 per room. This year, they rose to $62.00 per room, an increase of only 1.6 percent. Help Antonio better understand the overall results of his rate reduction strategy by completing his hotel’s May operating performance worksheet and then answering the questions that follow.

Statistics Last May This May
Occupancy % 75% 85%
Rooms Sold    
ADR $129.99 $116.99
Rooms Revenue    
RevPAR    
Controllable operating cost    
Gross operating profit    
GOPPAR    

 

2) Paige Vincent is the RM at the City Center Novotel. For over 12 months, she has been working hard to improve the performance of her hotel. Paige just received the following performance data. Help her understand the revenue optimization trends for her property by completing the chart. Then, you will be asked to evaluate her efforts. 

City Center Novotel Performance:

 

Occupancy %

Novotel

Comp Set

Index

This month

57.2

58.1

 

Last 3 months

55.1

57.7

 

Last 12 months

51.3

55.6

 

ADR

   

 

This month

$266.57

$270.15

 

Last 3 months

$244.91

$269.69

 

Last 12 months

$231.45

$268.95

 

RevPAR

 

 

 

This month

 

 

 

Last 3 months

 

 

 

Last 12 months

 

 

 

 

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Forecasting methods
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.