Value Packs / Hospitality / RevPAR & Rate Guardian / Wisdom

Which states are earning less per room than we expect tonight, and how many rooms do we have in each?

N
Done See how Wisdom analyzed this

Three states are below what tonight should earn

IN A NUTSHELL

Three states are earning less per available room tonight than we expect of them. Arizona is furthest — $87 a room against an expected $128, $41 below, across 2,840 rooms. Nevada is $23 below across 1,910 rooms and New Mexico $15 below across 760. Every other state is at or above what tonight expects. Arizona’s gap on its room count is $116,000 of room revenue in one night.

Revenue per available room tonight against what we expect, by state

AZNVNMBELOW THE REVENUE PER ROOM WE EXPECT TONIGHTArizona2,840 rooms · expected $128−$41Nevada1,910 rooms · expected $146−$23New Mexico760 rooms · expected $112−$15The other 45 statesat or above what tonight expects

Each state is read against what a Wednesday in May expects of it — that figure is on each row, because a room in Arizona and one in New Mexico do not earn the same on an ordinary night.

Arizona has 2,840 rooms against 2,670 across Nevada and New Mexico together, so it carries both the most rooms and the widest gap. The three states are $172,000 of room revenue between them tonight.

Ask a follow-up

How has revenue per room in Arizona moved day by day against what we expect? How has Nevada moved day by day? Which states are at or above what tonight expects?

How has revenue per room in Arizona moved day by day against what we expect?

N
Done See how Wisdom analyzed this

Two nights below, and tonight is the worse one

IN A NUTSHELL

Arizona swings hard across the week — $110 on a quiet Sunday and $170 on a Saturday — so the range swings with it. Through 19 May the hotels never sat more than $8 away from what that particular day expects. Last night they were $28 below what a Tuesday expects, and tonight they are $41 below what a Wednesday expects. Two nights below the range, and the second is wider than the first.

Revenue per available room by day, against the range expected · Arizona

7510012515017520020 May — $28 below what a Tuesday expects1 May510152021 May, tonightRevenue per roomExpected range

The range rises for Fridays and Saturdays and drops for Sundays — it comes from the same weekday in the three weeks before, so a busy Saturday is not read as a good result on its own.

The raw numbers move more between a Sunday and a Saturday than they do between last night and a normal Tuesday. What matters is the distance from what each night expects, and that has gone from $8 at worst to $41.

Wisdom noticed

“That’s the second question in a row on Arizona. Shall I save it as your scope?”
Yes, save it as my scope No, ask me each time

Ask a follow-up

Is it the rate we are getting, or how many rooms we are filling? How many rooms were available on each of those nights? How does Arizona compare with Nevada night by night?

Is it the rate we are getting, or how many rooms we are filling?

N
Done See how Wisdom analyzed this

Both, and the empty rooms are the bigger half

IN A NUTSHELL

Both have moved. Rooms filled are 68.3% against a usual 87.5% for a Wednesday — 19.2 points down, or 22% fewer rooms. The average rate is $127.44 against a usual $146.29, which is 13% less. Multiply the two together and they give the 32% fall in revenue per room. The rooms booked on the day have fallen most — 11.2% filled against a usual 26.4%, at $84 a room against $112.

Rooms filled and rate achieved by booking window · Arizona tonight

Rooms filled tonightBelow usualUsual for a WednesdayBooked on the day$84 a room, usually $112Booked one to seven days out$104, usually $134Booked eight to thirty days out$148, usually $180Booked more than thirty days out$176, usually $1900.0%10.0%20.0%30.0%

The four windows add up to the whole hotel — 68.3% filled tonight against 87.5% on a usual Wednesday, with the rate for each window on the right.

Bookings made more than thirty days out are the only window filling as usual, at 14.1% against 13.8%. Everything booked inside a month is short, and the closer in it was booked the shorter it is.

Ask a follow-up

Put the rate report together. Which properties in Arizona are furthest below? Which booking windows filled on the nights before?

Put the rate report together.

N
Done See how Wisdom analyzed this

The report lists every property with the rooms it has, the rooms it filled over the last two nights, the rate it achieved and how far ahead each booking was made. One row per property and booking window, so a property can be compared with the same night in previous weeks.

XLSX

revenue_per_room_21_may.xlsx

One row per property and booking window, sorted by the gap per room. Three states, with the nineteen nights before this started for comparison.

51 KB · 164 rows · 3 states · 21 nights

Download

Ask a follow-up

Which properties are more than $30 a room below? Can I see this grouped by market rather than by booking window? How many rooms does each property have? Which segments booked the rooms that did sell?