HTM381 HOTS Simulation Outline Sample Assignment
HTM 381 – HOTS Simulation Outline
JANUARY
Changes made…
- Changed weekday rate to $140 and weekend rate to $115
- Gave conference 15% discount and events a 10% discount on weekends
- Changed contract weekday min rate to $100 and weekend min rate to $90
- Changed late bookings to if less than 65% occupancy, quote price to 80% of normal
- Changed late bookings to if less than 75% occupancy, quote price to 90% of normal
- Changed late bookings to if more than 85% occupancy, quote price to 100% of normal
- Gave merchant website a discount of 5% and the opaque rate discount is set to 5%
- Allowed for direct bookings and use of expedia and booking.com
- We selected menu type 2 and food supplier type 1
- We made meal price to be $20 and selected band 2 for liquor
- We chose to have 12 hotel services and 7 front desk employees.
- We paid our department heads a band 3 and all other employees band 2
- We added poster advertising for $1063 weekly, local weekly newspaper for $550 weekly, posters for conferences for $1063 weekly.
- We selected to add a social media page and a local visitor guide for a one-time payment of $500 annually.
- We changed our waste reduction and recycling to a level three and all other options to level one
- We refurbished nothing
- Changed complimentary items to level 3 and room entertainment level to level 2
- We selected to have room and lounge service only
- Added no additional facilities in room or hotel
- Made no changed to loan.
Look at the month’s ACTUAL results and highlight 7 KPI’s.
KPI |
January |
Occupancy % |
18.6 |
ADR |
99.81 |
RevPAR |
18.59 |
GOPPAR |
-8.65 |
Rooms Sold |
652 |
Revenue |
126489 |
Contribution Margin |
- Are these KPI’s as expected or not – did this match the goals you set?
- What caused the results and why? What do these indicators tell you about your performance?
What is the status of your P&L, cash flow and balance sheet?
- Income Statement
- Statement of Cash Flow
- Balance Sheet
Where are you now positioned against your competition?
Identify current problems and possible causes.
Goals for coming month for each department (specific numbers).
FEBRUARY
Changes made…
Look at previous month’s ACTUAL results and highlight 7 KPI’s.
KPI |
January |
February |
Changes |
Occupancy % | |||
ADR | |||
RevPAR | |||
GOPPAR | |||
Rooms Sold | |||
Revenue | |||
Contribution Margin |
- Are these KPI’s as expected or not – did this match the goals you set?
- What caused the results and why? What do these indicators tell you about your performance?
What is the status of your P&L, cash flow and balance sheet?
- Income Statement
- Statement of Cash Flow
- Balance Sheet
Where are you now positioned against your competition?
Identify current problems and possible causes.
Goals for coming month for each department (specific numbers).
MARCH
Changes made…
Look at previous month’s ACTUAL results and highlight 7 KPI’s.
KPI |
February |
March |
Changes |
Occupancy % | |||
ADR | |||
RevPAR | |||
GOPPAR | |||
Rooms Sold | |||
Revenue | |||
Contribution Margin | |||
KPI |
January |
March |
Changes |
Occupancy % | |||
ADR | |||
RevPAR | |||
GOPPAR | |||
Rooms Sold | |||
Revenue | |||
Contribution Margin |
- Are these KPI’s as expected or not – did this match the goals you set?
- What caused the results and why? What do these indicators tell you about your performance?
What is the status of your P&L, cash flow and balance sheet?
- Income Statement
- Statement of Cash Flow
- Balance Sheet
Where are you now positioned against your competition?
Identify current problems and possible causes.
Goals for coming month for each department (specific numbers).
APRIL
Changes made…
Look at previous month’s ACTUAL results and highlight 7 KPI’s.
KPI |
March |
April |
Changes |
Occupancy % | |||
ADR | |||
RevPAR | |||
GOPPAR | |||
Rooms Sold | |||
Revenue | |||
Contribution Margin | |||
KPI |
January |
April |
Changes |
Occupancy % | |||
ADR | |||
RevPAR | |||
GOPPAR | |||
Rooms Sold | |||
Revenue | |||
Contribution Margin |
- Are these KPI’s as expected or not – did this match the goals you set?
- What caused the results and why? What do these indicators tell you about your performance?
What is the status of your P&L, cash flow and balance sheet?
- Income Statement
- Statement of Cash Flow
- Balance Sheet
Where are you now positioned against your competition?
Identify current problems and possible causes.
Goals for coming month for each department (specific numbers).
MAY
Changes made…
Look at previous month’s ACTUAL results and highlight 7 KPI’s.
KPI |
April |
May |
Changes |
Occupancy % | |||
ADR | |||
RevPAR | |||
GOPPAR | |||
Rooms Sold | |||
Revenue | |||
Contribution Margin | |||
KPI |
January |
May |
Changes |
Occupancy % | |||
ADR | |||
RevPAR | |||
GOPPAR | |||
Rooms Sold | |||
Revenue | |||
Contribution Margin |
- Are these KPI’s as expected or not – did this match the goals you set?
- What caused the results and why? What do these indicators tell you about your performance?
What is the status of your P&L, cash flow and balance sheet?
- Income Statement
- Statement of Cash Flow
- Balance Sheet
Where are you now positioned against your competition?
Identify current problems and possible causes.
Goals for coming month for each department (specific numbers).
JUNE
Changes made…
Look at previous month’s ACTUAL results and highlight 7 KPI’s.
KPI |
May |
June |
Changes |
Occupancy % | |||
ADR | |||
RevPAR | |||
GOPPAR | |||
Rooms Sold | |||
Revenue | |||
Contribution Margin | |||
KPI |
January |
June |
Changes |
Occupancy % | |||
ADR | |||
RevPAR | |||
GOPPAR | |||
Rooms Sold | |||
Revenue | |||
Contribution Margin |
- Are these KPI’s as expected or not – did this match the goals you set?
- What caused the results and why? What do these indicators tell you about your performance?
What is the status of your P&L, cash flow and balance sheet?
- Income Statement
- Statement of Cash Flow
- Balance Sheet
Where are you now positioned against your competition?
Identify current problems and possible causes.
Goals for coming month for each department (specific numbers).
JULY
Changes made…
Look at previous month’s ACTUAL results and highlight 7 KPI’s.
KPI |
June |
July |
Changes |
Occupancy % | |||
ADR | |||
RevPAR | |||
GOPPAR | |||
Rooms Sold | |||
Revenue | |||
Contribution Margin | |||
KPI |
January |
July |
Changes |
Occupancy % | |||
ADR | |||
RevPAR | |||
GOPPAR | |||
Rooms Sold | |||
Revenue | |||
Contribution Margin |
- Are these KPI’s as expected or not – did this match the goals you set?
- What caused the results and why? What do these indicators tell you about your performance?
What is the status of your P&L, cash flow and balance sheet?
- Income Statement
- Statement of Cash Flow
- Balance Sheet
Where are you now positioned against your competition?
Identify current problems and possible causes.
Goals for coming month for each department (specific numbers).
AUGUST
Changes made…
Look at previous month’s ACTUAL results and highlight 7 KPI’s.
KPI |
July |
August |
Changes |
Occupancy % | |||
ADR | |||
RevPAR | |||
GOPPAR | |||
Rooms Sold | |||
Revenue | |||
Contribution Margin | |||
KPI |
January |
August |
Changes |
Occupancy % | |||
ADR | |||
RevPAR | |||
GOPPAR | |||
Rooms Sold | |||
Revenue | |||
Contribution Margin |
- Are these KPI’s as expected or not – did this match the goals you set?
- What caused the results and why? What do these indicators tell you about your performance?
What is the status of your P&L, cash flow and balance sheet?
- Income Statement
- Statement of Cash Flow
- Balance Sheet
Where are you now positioned against your competition?
Identify current problems and possible causes.
Goals for coming month for each department (specific numbers).
SEPTEMBER
Changes made…
Look at previous month’s ACTUAL results and highlight 7 KPI’s.
KPI |
August |
September |
Changes |
Occupancy % | |||
ADR | |||
RevPAR | |||
GOPPAR | |||
Rooms Sold | |||
Revenue | |||
Contribution Margin | |||
KPI |
January |
September |
Changes |
Occupancy % | |||
ADR | |||
RevPAR | |||
GOPPAR | |||
Rooms Sold | |||
Revenue | |||
Contribution Margin |
- Are these KPI’s as expected or not – did this match the goals you set?
- What caused the results and why? What do these indicators tell you about your performance?
What is the status of your P&L, cash flow and balance sheet?
- Income Statement
- Statement of Cash Flow
- Balance Sheet
Where are you now positioned against your competition?
Identify current problems and possible causes.
Goals for coming month for each department (specific numbers).
OCTOBER
Changes made…
Look at previous month’s ACTUAL results and highlight 7 KPI’s.
KPI |
September |
October |
Changes |
Occupancy % | |||
ADR | |||
RevPAR | |||
GOPPAR | |||
Rooms Sold | |||
Revenue | |||
Contribution Margin | |||
KPI |
January |
October |
Changes |
Occupancy % | |||
ADR | |||
RevPAR | |||
GOPPAR | |||
Rooms Sold | |||
Revenue | |||
Contribution Margin |
- Are these KPI’s as expected or not – did this match the goals you set?
- What caused the results and why? What do these indicators tell you about your performance?
What is the status of your P&L, cash flow and balance sheet?
- Income Statement
- Statement of Cash Flow
- Balance Sheet
Where are you now positioned against your competition?
Identify current problems and possible causes.
Goals for coming month for each department (specific numbers).
NOVEMBER
Changes made…
Look at previous month’s ACTUAL results and highlight 7 KPI’s.
KPI |
October |
November |
Changes |
Occupancy % | |||
ADR | |||
RevPAR | |||
GOPPAR | |||
Rooms Sold | |||
Revenue | |||
Contribution Margin | |||
KPI |
January |
November |
Changes |
Occupancy % | |||
ADR | |||
RevPAR | |||
GOPPAR | |||
Rooms Sold | |||
Revenue | |||
Contribution Margin |
- Are these KPI’s as expected or not – did this match the goals you set?
- What caused the results and why? What do these indicators tell you about your performance?
What is the status of your P&L, cash flow and balance sheet?
- Income Statement
- Statement of Cash Flow
- Balance Sheet
Where are you now positioned against your competition?
Identify current problems and possible causes.
Goals for coming month for each department (specific numbers).
DECEMBER
Changes made…
Look at previous month’s ACTUAL results and highlight 7 KPI’s.
KPI |
November |
December |
Changes |
Occupancy % | |||
ADR | |||
RevPAR | |||
GOPPAR | |||
Rooms Sold | |||
Revenue | |||
Contribution Margin | |||
KPI |
January |
December |
Changes |
Occupancy % | |||
ADR | |||
RevPAR | |||
GOPPAR | |||
Rooms Sold | |||
Revenue | |||
Contribution Margin |
- Are these KPI’s as expected or not – did this match the goals you set?
- What caused the results and why? What do these indicators tell you about your performance?
What is the status of your P&L, cash flow and balance sheet?
- Income Statement
- Statement of Cash Flow
- Balance Sheet
Where are you now positioned against your competition?
Identify current problems and possible causes.
Goals for coming month for each department (specific numbers).