Ramon, the chief operating officer, has requested that you explain how he can use Excel to address the following concerns:

a. Ramon is interested in determining the proportion of bookings that are made by families with children.

Identify and describe a suitable Excel function that can help Ramon determine the proportion of bookings made by singles, couples and families.

b. Ramon requires information regarding which hotels generate the highest level of revenue.

Identify and describe a suitable Excel function that can help Ramon clearly inform the Board which hotels are providing the most revenue.

c. Ramon is concerned with the effectiveness of the membership level program.

Identify and describe a suitable Excel function that can help Ramon identify the quantity of repeat customers at each membership level.

d. Ramon is currently preparing budgets for the next 3 years.

Identify and describe a suitable Excel function that can help Ramon generate future revenue data that will help him prepare the budgets.