Hotel Room Occupancy Analysis.xlsx - 2022 OCCUPANCY LEVELS...

This preview shows page 1 - 3 out of 7 pages.

2022 OCCUPANCY LEVELSInputs (you need to complete these sections)Assumed opening in January 2020Benchmarks (this is information already provided for you)Monthly Seasonality(Use this only if seasonality is different for each month)January FebruaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecemberAverageOccupancyMonday#DIV/0!Tuesday#DIV/0!Wednesday#DIV/0!Thursday#DIV/0!Midweek#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Friday#DIV/0!Saturday#DIV/0!Sunday#DIV/0!Weekend#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!STR Guildford Market Average (2013-2017)66.5%76.4%74.3%77.6%79.1%85.0%87.9%82.0%87.2%83.1%77.2%67.5%78.6%Jan-17Feb-17Mar-17Apr-17May-17Jun-17Jul-17Aug-17Sep-17Oct-16Nov-16Dec-16AverageSTR Guildford Occupancy October 2016-September 2017 Monday79.9%85.7%77.8%80.4%71.7%86.3%90.3%77.5%90.2%88.9%86.1%61.5%81.4%Tuesday91.1%91.0%86.9%91.3%87.2%92.2%95.5%84.2%92.9%96.0%91.2%68.4%89.0%Wednesday90.9%85.9%81.5%92.4%89.5%91.9%94.4%85.1%92.1%95.6%92.3%66.1%88.1%Thursday68.3%73.1%61.1%83.9%78.4%85.6%86.8%75.1%86.7%83.9%80.6%73.9%78.1%Midweek82.6%83.9%76.8%87.0%81.7%89.0%91.8%80.5%90.5%91.1%87.6%67.5%84.1%Friday42.7%71.6%59.2%71.5%72.8%86.1%89.6%89.9%89.6%79.0%64.2%79.6%74.6%Saturday60.7%79.5%76.1%83.2%87.0%92.3%96.4%96.0%93.3%93.5%80.8%75.5%84.5%Sunday37.7%49.1%48.3%46.6%61.4%58.1%63.8%70.7%61.5%61.3%55.6%45.5%55.0%Weekend47.0%66.8%61.2%67.1%73.7%78.9%83.3%85.5%81.5%77.9%66.9%66.9%71.4%67.3%76.6%70.1%78.5%78.3%84.7%88.1%82.6%86.6%85.4%78.7%67.2%78.7%RoomsRoomnightsRooms per DayOccupanciesMonday- - - - - - - - - - - - - 0#DIV/0!Tuesday- - - - - - - - - - - - - 0#DIV/0!Wednesday- - - - - - - - - - - - - 0#DIV/0!Thursday- - - - - - - - - - - - - 0#DIV/0!Friday- - - - - - - - - - - - - 0#DIV/0!Saturday- - - - - - - - - - - - - 0#DIV/0!Sunday- - - - - - - - - - - - - 0#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!- 0#DIV/0!0Total Days312831303130313130313031Available Week- - - - - - - - - - - - Available Weekend- - - - - - - - - - - - Available Total- - - - - - - - - - - - - Available check- - - - - - - - - - - - Total per month- - - - - - - - - - - - - Monthly Occ#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Weekday Occ#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Weekend Occ#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Total Rooms Available Midweek- Total Rooms Available Weekend- Total Rooms Available- Total Rooms Occupied Midweek- Total Rooms Occupied Weekend- Total Rooms Occupied- Weekday Occupancy#DIV/0!Weekend Occupancy#DIV/0!Occupancy#DIV/0!Number of Hotel Bedrooms
202020212022%%%Midweek- #DIV/0!0.0%- #DIV/0!0.0%- #DIV/0!Weekend- #DIV/0!0.0%- #DIV/0!0.0%- #DIV/0!Total - #DIV/0!- #DIV/0!- #DIV/0!Number of Bedrooms0Rooms Available - - - Rooms Occupied- - - Occ#DIV/0!#DIV/0!#DIV/0!****SENSE CHECK**** Occ Performance Against STR Global Benchmarks JanFebMarAprMayJunJulAugSepOctNovDecSTR Local Market (2013)69.3%70.9%69.8%77.1%80.2%82.7%89.0%79.1%85.1%81.2%75.5%65.5%STR Local Market (2014)64.5%76.6%76.8%76.5%78.3%83.6%85.1%82.7%86.8%82.5%78.0%69.6%STR Local Market (2015)66.6%81.1%80.0%78.3%80.2%88.6%90.0%83.5%90.0%85.4%78.2%67.4%STR Local Market (2016)65.4%76.9%70.7%78.4%77.8%84.9%87.6%82.6%86.7%0.0%0.0%0.0%Average Room Occupancy Local Market (2013 to 2017)66.5%76.4%74.3%77.6%79.1%85.0%87.9%82.0%87.2%83.1%77.2%67.5%Projected Room Occupancy, Proposed Hotel Development#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!****SENSE CHECK**** Projected Weekly Occupancy Performance Against STR GlobalMondayTuesdayWednesdayThursday FridaySaturdaySundayProjected Occupancy, Proposed Hotel Development#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture