Docsity
Docsity

Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity


Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan


Guidelines and tips
Guidelines and tips

Occupancy ADR RevPar excel worksheet 2024, Quizzes of Hospitality and Tourism

Hospitality Sales and Revenue management excel assignment. This contains all the answers.

Typology: Quizzes

2023/2024

Available from 09/04/2024

ticia-amankwaah
ticia-amankwaah 🇨🇦

6 documents

1 / 2

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
Room Number
Date Day of Week 1 2 3 4 5 6 7
1 Monday 70 70 70 85
2 Tuesday 85 85 85 70 70
3 Wednesday 85 85 70 70 70
4 Thursday 70 70 70 70 85 85
5 Friday 105 105 105 120 120 110
6 Saturday 120 120 120 120 120 130 130
7 Sunday 85 85 120 120
8 Monday 70 70 70 85
9 Tuesday 85 85 85 70 70
10 Wednesday 85 85 70 70 70
11 Thursday 60 70 70 70 85 70
12 Friday 95 105 70 120 120 110 110
13 Saturday 120 120 110 120 130 120
14 Sunday 85 85 85 120 120
15 Monday 70 70 85
16 Tuesday 80 85 85 70 70
17 Wednesday 85 85 60 70 70
18 Thursday 70 70 70 90 70 85
19 Friday 105 120 105 120 110 110
20 Saturday 120 120 120 120 120 130 130
21 Sunday 85 85 120 120
22 Monday 70 70 70 85 85
23 Tuesday 85 85 85 70 70
24 Wednesday 85 85 70 70 70
25 Thursday 70 70 70 70 85 85
26 Friday 95 120 120 110 110
27 Saturday 120 120 120 120 120 130
28 Sunday 85 85 120 120
29 Monday 70 70 70 85
30 Tuesday 85 85 70 70
31 Wednesday 85 85 70 70 70
Occupancy 84% 65% 81% 87% 58% 81% 61%
ADR 81% 61% 81% 84% 58% 77% 61%
RevPar 81% 65% 81% 84% 61% 77% 61%
Occ ADR RevPar
Which Room was used the most
Which Room was used the most
Who would use this information
Why is this information important
pf2

Partial preview of the text

Download Occupancy ADR RevPar excel worksheet 2024 and more Quizzes Hospitality and Tourism in PDF only on Docsity!

Room Number

Occupancy 84% 65% 81% 87% 58% 81% 61% ADR 81% 61% 81% 84% 58% 77% 61% RevPar 81% 65% 81% 84% 61% 77% 61% Occ ADR RevPar Which Room was used the most Which Room was used the most Who would use this information

  • Date Day of Week - 1 Monday - 2 Tuesday - 3 Wednesday - 4 Thursday - 5 Friday - 6 Saturday - 7 Sunday - 8 Monday - 9 Tuesday
    • 10 Wednesday
    • 11 Thursday
    • 12 Friday
    • 13 Saturday
    • 14 Sunday
    • 15 Monday
    • 16 Tuesday
    • 17 Wednesday
    • 18 Thursday
    • 19 Friday
    • 20 Saturday
    • 21 Sunday
    • 22 Monday
    • 23 Tuesday
    • 24 Wednesday
    • 25 Thursday
    • 26 Friday
    • 27 Saturday
    • 28 Sunday
    • 29 Monday
    • 30 Tuesday
    • 31 Wednesday
    • 85 50% $ 76.00 $ 38. 8 9 PH Occupancy ADR RevPar
    • 70 85 70% $ 78.57 $ 55. - 90 60% $ 78.33 $ 47.
    • 95 225 80% $ 96.25 $ 77.
  • 120 120 250 90% $ 128.33 $ 115.
  • 140 140 300 100% $ 144.00 $ 144.
  • 120 120 225 70% $ 125.00 $ 87.
    • 85 50% $ 76.00 $ 38.
    • 70 85 70% $ 78.57 $ 55. - 90 60% $ 78.33 $ 47.
    • 95 120 80% $ 80.00 $ 64.
  • 120 120 225 100% $ 119.50 $ 119.
  • 140 140 300 90% $ 144.44 $ 130.
  • 120 120 140 80% $ 109.38 $ 87.
    • 85 40% $ 77.50 $ 31.
    • 70 85 225 80% $ 96.25 $ 77. - 90 60% $ 76.67 $ 46.
    • 95 120 225 90% $ 99.44 $ 89.
      • 120 250 80% $ 130.00 $ 104.
  • 140 140 300 100% $ 144.00 $ 144.
  • 120 225 60% $ 125.83 $ 75.
    • 85 225 70% $ 98.57 $ 69.
    • 70 85 70% $ 78.57 $ 55. - 50% $ 76.00 $ 38.
    • 95 120 225 90% $ 98.89 $ 89.
  • 120 120 250 80% $ 130.63 $ 104.
  • 140 140 80% $ 126.25 $ 101.
  • 120 120 225 70% $ 125.00 $ 87.
    • 85 50% $ 76.00 $ 38.
    • 70 85 225 60% $ 100.83 $ 60. - 90 60% $ 78.33 $ 47.