HOS 200 Assignment 3 Flash Report Angement Format: Individual Assignment Due: Wednesday November 17, 2021/4:00p.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 Mash report tells you how ales 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: Create a one month Flash Report b. Your enteories should be listed along the top and your dates (March 1 thru March 31) down the left side e Use provided daily figures Calculate the corresponding Month to Date (MTD) figures using Excel formulas Your guidelines are: 1 limust 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 Room Room Sales/Revenuc (5) Average Room Rate (S) - Calculated as: Room Sales/Rooms Sold Labour Cost (S) Spa Sules (S) Room Service Sales (S) Retail Sales (S) Room Service Sales (S) . . . . 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 dolint figures un dollars and cents using the currency" view HOS 200 Assignment 3 Flash Report Angement Format: Individual Assignment Due: Wednesday November 17, 2021/4:00p.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 Mash report tells you how ales 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: Create a one month Flash Report b. Your enteories should be listed along the top and your dates (March 1 thru March 31) down the left side e Use provided daily figures Calculate the corresponding Month to Date (MTD) figures using Excel formulas Your guidelines are: 1 limust 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 Room Room Sales/Revenuc (5) Average Room Rate (S) - Calculated as: Room Sales/Rooms Sold Labour Cost (S) Spa Sules (S) Room Service Sales (S) Retail Sales (S) Room Service Sales (S) . . . . 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 dolint figures un dollars and cents using the currency" view