## (Solved) Rooms available Date Day of Week Rooms Sold 5/8/2011 5/9/2011 5/10/2011 5/11/2011 5/12/2011 5/13/2011 5/14/2011 5/15/2011 5/16/2011 5/17/2011

I need to know how reformat to

freeze panes so the title row and the column containing the date are always showing,

use absolute/ relative reference to use column E (occupancy = rooms sold / rooms available), column F (Daily Room Rev = Rooms sold x Average Daily Rate), column G (Revenue per available room= Daily Room Revenues / Total Rooms available)

Compute overall average RevPar (L6)

Using conditional formatting, using L6 highlight the rows where daily RevPAR is greater than the average RevPar (using cell containing the average RevPar as a reference)

Using a function calculator for L9 find ho many days from the month of May are in the table, L10 identify how many days in June, and compute total room revenue

Rooms available Date Day of Week Rooms Sold 5/8/2011
5/9/2011
5/10/2011
5/11/2011
5/12/2011
5/13/2011
5/14/2011
5/15/2011
5/16/2011
5/17/2011
5/18/2011
5/19/2011
5/20/2011
5/21/2011
5/22/2011
5/23/2011
5/24/2011
5/25/2011
5/26/2011
5/27/2011
5/28/2011
5/29/2011
5/30/2011
5/31/2011
6/1/2011
6/2/2011
6/3/2011
6/4/2011
6/5/2011
6/6/2011
6/7/2011
6/8/2011
6/9/2011
6/10/2011
6/11/2011
6/12/2011
6/13/2011 Sun
Mon
Tue
Wed
Thu
Fri
Sat
Sun
Mon
Tue
Wed
Thu
Fri
Sat
Sun
Mon
Tue
Wed
Thu
Fri
Sat
Sun
Mon
Tue
Wed
Thu
Fri
Sat
Sun
Mon
Tue
Wed
Thu
Fri
Sat
Sun
Mon 246
281
276
170
108
117
117
261
284
265
169
109
110
81
242
285
260
164
108
106
118
250
280
265
166
109
105
110
236
282
275
246
281
276
170
108
117 295 Average Daily Rate
(\$)
245.87
260.45
266.28
248.78
283.77
248.78
237.12
219.62
286.69
286.69
245.87
318.77
353.76
347.93
347.93
318.77
219.62
321.68
388.75
280.86
266.28
251.70
301.27
356.67
347.93
388.75
213.79
368.34
301.27
342.09
337.00
321.68
388.75
280.86
266.28
251.70
301.27 6/14/2011
6/15/2011
6/16/2011
6/17/2011
6/18/2011
6/19/2011
6/20/2011
6/21/2011
6/22/2011
6/23/2011
6/24/2011
6/25/2011
6/26/2011
6/27/2011
6/28/2011
6/29/2011
6/30/2011 Tue
Wed
Thu
Fri
Sat
Sun
Mon
Tue
Wed
Thu
Fri
Sat
Sun
Mon
Tue
Wed
Thu 117
261
284
265
169
109
110
250
280
265
166
109
105
110
236
282
246 356.67
368.34
301.27
342.09
318.77
353.76
347.93
347.93
318.77
219.62
245.87
260.45
266.28
248.78
283.77
248.78
237.12 295 3
Occupancy % by Date 4
Daily Room Revenues(\$) 5
RevPAR by Date(\$) 6. Average RevPAR (\$) 8. Number of days in May
9. Number of days in June
10. Total room revenue 3121073 0 10580 0

Solution details:
STATUS
QUALITY
Approved

This question was answered on: Sep 05, 2019

Solution~000200151236.zip (25.37 KB)

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free copy from our tutoring website www.aceyourhomework.com (Deadline assured. Flexible pricing. TurnItIn Report provided)

STATUS

QUALITY

Approved

Sep 05, 2019

EXPERT

Tutor