Rooms Sold Formula

1 875 75 25.

Rooms sold formula.

Trevpar is calculated by dividing total revenue by total number of rooms. Revpar is calculated by multiplying a hotel s average daily room rate by its occupancy rate. So if your hotel revenue for a day was 15 000 for example and your hotel has 110 rooms trevpar would be 136. In the last line one can see the difference between the.

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. The cpor formula helps calculate the average cost per occupied room. Total flower cost per room sold. Adr room revenue rooms sold.

The second page of the spreadsheet highlights the flower cost per room sold. Using the first formula and the information above we can calculate that company xyz s revpar was. How do you calculate cpor. The formula to calculate your average daily rate is.

Revenue per available room revpar is a performance measure used in the hospitality industry. 75 total room revenue 1000 rooms x 90 room x 75 occupancy x 90 nights in the quarter. This is another kpi to measure and analyse if the operating cost for each room is reasonable. 90 average occupancy rate.

Room revenue adr room nights sold jan 2015 10 748 99 74 65 144 room nights sold feb 2015 619 24 11 06 56 room nights sold mar 2015 1925 64 24 69 78 room nights sold. The line below shows the actual costs per month. The flower cost per room sold budget line shows the amount that one is allowed to spend according to the budgeted figures. Using the second formula we can arrive at the same answer.

Revenue per available room. 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. Naturally you ll want to try to increase trevpar as this will indicate an increase in average revenue occupancy or both.