50.1K

Verified Solution

Link Copied!

Cindy, the executive general manager, has requested that you explain how she can use Excel to address the following concerns:

a. There is considerable variance in the revenue from each individual booking.

Identify and describe a suitable Excel function that can help Cindy determine the greatest and least amount of revenue that GHG receives from a single booking.

b. Cindy understands that repeat customers are critical to the success of GHG.

Identify and describe a suitable Excel function that can help Cindy determine which customers have stayed with the group more than once.

c. The Board of directors has asked Cindy which of the hotel brands contribute the majority of GHGs revenue.

Identify and describe a suitable Excel function that can help Cindy clearly inform the Board which hotel brands are providing the most revenue in dollars.

d. The Board of directors has also asked Cindy to provide estimates of expected future revenues based on GHGs performance throughout August to November.

Identify and describe a suitable Excel function that can help Cindy provide revenue estimates for future periods.

e. The Board of directors has also asked Cindy to identify bookings in each country as a proportion of total bookings.

Identify and describe a suitable Excel function that can help Cindy identify the relative proportion of bookings by country.

f. To assist her with future advertising campaigns, Cindy also wants to understand the average rate charged across the group on Suites and Family rooms.

Identify and describe a suitable Excel function that can help Cindy identify the average revenue charged within the group for Suites and Family rooms.

g. Cindy is interested in the seasonality of the business and would like to know the quantity of separate bookings made during September.

Identify and describe a suitable Excel function that can help Cindy determine the number of bookings made during the month of September.

Answer & Explanation Solved by verified expert

See Answer