Use Excel to create a one-month Flash Report for a sample hotel property.

It must be done as an Excel Worksheet; you must use the provided revenue/figures and plug them in to the spreadsheet. See the included example and watch the video with explanations. Proper formulas and formatting will be factored in.

You must:

a. Create a one month Flash Report

b. Your categories should be listed along the top and your dates (March 1 thru March 31) down the

left side

c. Use provided daily figures

d. Calculate the corresponding Month to Date (MTD) figures using Excel formulas

Your guidelines are:

1. It must present one month on a single worksheet

2. You must have each of the following six columns:

Total Rooms (Available to Sell)

Rooms Sold

Occupancy Percentage (%) - Calculated as: Rooms Sold / Total Rooms

Room Sales/Revenue ($)

Average Room Rate ($) Calculated as: Room Sales/Rooms Sold

Labour Cost ($)

Spa Sales ($)

Room Service Sales ($)

Retail Sales ($)

Room Service Sales ($)

3. You must have a column for daily information and month-to-date (MTD) information. MTD is a running total to show you where you stand as the month goes on

Keep in mind:

Always calculate your percentages to two decimal places, rounding up or down as needed and using the percentage view

Show dollar figures an dollars and cents using the currency view

A daily flash report tells you

how sales are running compared to your budget plan and how your business is trending. The daily flash

report is typically the first report everyone checks each day.