HOS 200 Assignment # 3 Flash Report Assignment Format: Individual Assignment Due: Wednesday November 17th, 2021 / 4:00 p.m. / Submitted thru Blackboard Total Marks: 50 Percentage of Term Mark: 25% Use Excel to create a one-month Flash Report for a sample hotel property. 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. 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

f - Figures to Use - Flas... - 177 Date: Total Rooms 01-Mar 177 02-Mar 177 03-Mar 177 04-Mar 177 05-Mar 177 06-Mar 177 07-Mar 177 08-Mar 177 09-Mar 177 10-Mar 177 11-Mar 12-Mar 177 13-Mar 177 14-Mar 177 15-Mar 177 16-Mar 177 17-Mar 177 18-Mar 177 19-Mar 177 20-Mar 177 21-Mar 177 22-Mar 177 23-Mar 177 24-Mar 177 25-Mar 177 26-Mar 177 27-Mar 177 28-Mar 177 29-Mar 177 30-Mar 177 31-Mar 177 Rooms Sold Total Room Sales Labour 121 $ 25,898.00 $ 7,752.00 $ 1350 $ 27,656.00 $ 7,895.00 $ 1621 $ 29,888.00 $ 7,258.00 $ 171 $ 35,789.00$ 7,456.00 $ 153 $ 36,985.00 $ 7,895.00 $ 170 $ 32,578.00 $ 7,154.00 $ 177 $ 36,214.00 $ 7,263.00 $ 154 $ 35,415.00$ 7,541.00$ 143 $ 33,231.00 $ 7,896.00 $ 121 $ 30,564.00 $ 7,105.00 $ 135 $ 33,547.00 $ 8,125.00 $ 166 $ 41,526.00 $ 7,963.00 $ 172] $ 44,235.00 $ 7,589.00 $ 153 $ 38,741.00$ 7,123.00 $ 1440 $ 35,888.00 $ 6,905.00 $ 174 $ 44,567.00 $ 7,245.00 $ 172) $ 43,574.00 $ 7,548.00 $ 171 $ 42,158.00 $ 7,961.00 $ 162) $ 40,036.00 $ 7,489.00 $ 163 $ 45,352.00 $ 7,542.00 $ 159 $ 47,895.00 $ 7,962.00 $ 157 $ 48,975.00 $ 8,125.00 $ 148 $ 42,579.00 $ 8,235.00 $ 122$ 29,836.00 $ 7,456.00 $ 117$ 25,879.00 $ 7,890.00 $ 115$ 26,987.00 $ 7,210.00 $ 119 $ 25,471.00 $ 7,354.00 $ 1777 $ 49,852.00 $ 7,451.00 $ 1771 $ 51,231.00 $ 7,776.00 $ 155) $ 42,105.00 $ 7,154.00 $ 173] $ 44,578.00 $ 7,542.00 $ Spa Room Service 563.00 $ 554.00 $ 235.00 $ 526.00 $ 741.00 $ 158.00 $ 562.00 $ 598.00 $ 741.00 $ 644.00 $ 548.00 $ 524.00 $ 485.00 $ 741.00 $ 658.00 $ 547.00 $ 742.00 $ 589.00 $ 415.00$ 654.00 $ 496.00 $ 745.00 $ 653.00 $ 654.00 $ 654.00 $ 687.00 $ 235.00 $ 265.00 $ 157.00 $ 964.00 $ 847.00 $ 820.00 $ 521.00 $ 802.00$ 556.00 $ 302.00 $ 458.00 $ 320.00 $ 923.00 $ 254.00 $ 814.00 $ 365.00 $ 745.00 $ 914.00 $ 785.00 $ 508.00 $ 654.00 $ 607.00 $ 954.00 $ 541.00$ 632.00 $ 223.00 $ 112.00 $ 267.00 $ 879.00 $ 845.00 $ 889.00 $ 956.00 $ 741.00 $ 663.00 $ 156.00 $ 618.00 $ Retail 123.00 353.00 341.00 410.00 210.00 220.00 254.00 415.00 630.00 226.00 351.00 302.00 552.00 314.00 356.00 635.00 702.00 223.00 210.00 256.00 258.00 852.00 649.00 515.00 555.00 320.00 123.00 458.00 915.00 226.00 321.00