Rooms Sold Formula

75 total room revenue 1000 rooms x 90 room x 75 occupancy x 90 nights in the quarter.

Rooms sold formula.

Formula for average guest per room apr apr calculator average guest per room apr provides the average number of guests occupied per room in the hotel this ratio is normally based on the total guest in the hotel including children divided by the total number of rooms sold. It is a very classic kpi and regarded as one of the most important financial calculation for any hotel to see how much revenue they have made within a certain period of time. In the last line one can see the difference between the. The line below shows the actual costs per month.

The second page of the spreadsheet highlights the flower cost per room sold. How do you calculate cpor. Adr room revenue rooms sold. Trevpar is calculated by dividing total revenue by total number of rooms.

Using the first formula and the information above we can calculate that company xyz s revpar was. Revenue per available room. Naturally you ll want to try to increase trevpar as this will indicate an increase in average revenue occupancy or both. 90 average occupancy rate.

The formula to calculate your average daily rate is. Total rooms departments cost number of rooms sold. The cpor formula helps calculate the average cost per occupied room. 1 875 75 25.

The flower cost per room sold budget line shows the amount that one is allowed to spend according to the budgeted figures. So if your hotel revenue for a day was 15 000 for example and your hotel has 110 rooms trevpar would be 136. The formula for occupancy percentage number of rooms occupied total number of rooms available for sale 100 there are generally two ways used to calculate the occupancy percentage in hotel one by the number of rooms occupied and another by the rooms sold rooms sold occupied rooms complimentary and house use. Using the second formula we can arrive at the same answer.

Revenue per available room revpar is a performance measure used in the hospitality industry. Rooms revenue earned number of rooms sold of course when you are using this formula you need to exclude any rooms that are complimentary or rooms that are currently being occupied by staff members. Revpar is calculated by multiplying a hotel s average daily room rate by its occupancy rate.