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).