Occupancy Rate

Completing this activity will help you learn to:

Determine how to track performance by comparing actual sales to total possible sales.

Extract information from a data set using Excel formulas, functions, and$/$or pivot tables.

Scenario:

Company A owns and operates $200$ small hotels in $10$ regions.

The company tracks its occupancy rate by comparing number of rooms sold to number of rooms available in a month.

The Data worksheet contains a list of operating data for the month of June.

Each row provides information about a property, including region, number of rooms available, number of guests that stayed one ni nights, number of guests that stayed three nights, number of guests that stayed four nights, and number of guests that stayed fiv

Required:

Chapter $15$ Data Analytics assignment take frame

Open spreadsheet

Complete three columns on the Data worksheet: Available room nights, Occupied room nights, and Percentage.

R$1.$ Cell E$4$: Enter a formula that results in the number of room nights available in June.

R$2.$ Cell K$4$: Enter a formula that results in the number of occupied room nights in June.