Sales and Revenue Excel assignment

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