Question Details

(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
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: Sep 05, 2019

PRICE: $15

Solution~000200151236.zip (25.37 KB)

Buy this answer for only: $15

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)

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Sep 05, 2019

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP/h4>

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • As a reference for in-depth understanding of the subject.
  • As a source of ideas / reasoning for your own research (if properly referenced)
  • For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

NEW ASSIGNMENT HELP?

Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN YOUR SET DEADLINE.

Order Now