How to Price a 40-Room Hotel Without Software
A step-by-step pricing method for small hotels, with real numbers: set a floor, build occupancy tiers, check your comp set, and adjust on pace.
If you run a small independent hotel and nobody ever taught you how to price rooms, use an occupancy ladder: work out what a room costs you, set a floor above it, then define three or four price tiers that step up as the night fills. Check your competitors once a day, and move a date up a tier when it is filling faster than usual. That is the whole method — the rest of this post is how to build it with your own numbers.
Start where you actually are
Most independent operators price the same way, and they are honest about it on forums: look at the nicer hotel down the road, sit somewhere below them, adjust if the weekend looks empty.
That is not stupid. It encodes two real signals — your position in the local market and current demand. The problem is that it is unrepeatable. It lives in one person's head, it changes with mood, and it cannot tell you whether last Saturday was priced correctly.
The method below keeps the instinct and gives it structure.
Step 1: Find your rate floor
Your cost per occupied room (CPOR) is what it actually costs to sell one more room night — housekeeping labor, linen, amenities, utilities, and the card or commission fee on that booking. Not your mortgage. Not salaried front desk. Only the costs that appear because the room sold.
Add those up for a month and divide by rooms sold. If a month of variable room costs is $24,000 and you sold 800 room nights, your CPOR is $30.
Your floor is not $30. Selling at cost is pointless. Your floor is the lowest rate you would accept on your emptiest night — commonly somewhere well above CPOR, because a cheap room still costs you a clean, a check-in, and wear on the asset.
Write the number down. Everything else is built on it.
Step 2: Build the occupancy ladder
Now set price tiers that step up as a night fills. A worked example for a 40-room property with a $30 CPOR:
| Rooms sold | Occupancy | Rate | Why |
|---|---|---|---|
| 0–16 | up to 40% | $95 | Floor tier — well above cost, competitive on a quiet night |
| 17–26 | 40–65% | $115 | Normal trading |
| 27–34 | 65–85% | $140 | Demand is proving itself |
| 35–40 | 85%+ | $170 | Scarcity — the last rooms are the most valuable |
The logic: your last few rooms are genuinely worth more than your first few, because once you are nearly full the only guests left are the ones with no alternative. Research from HVS on convention markets found room rates climb much faster once occupancy pushes past roughly 75–80% — the rate response is not linear, so your ladder should not be either.
Set your own numbers. The shape matters more than the values.
Step 3: Check your comp set once a day
Your comp set is the small group of hotels you genuinely lose bookings to — usually six to ten properties nearby at a similar quality level and price range.
Look at what they are charging for the next 7 to 14 nights. You are looking for three things:
- Anyone sold out — that is demand you can price into
- Anyone who has jumped their rate — they may know about an event you missed
- Your position in the list — are you where you intend to be?
Two free ways to do this before buying anything: your Expedia Partner Central account can export competitor rate data, and ten minutes on a booking site with your dates gives you the same picture manually.
Pick a time and do it daily. The discipline matters more than the tooling.
Step 4: Adjust on pace, not on panic
Pace means how fast a future date is filling compared to a normal equivalent date. Pickup means how many rooms you sold for that date since you last looked.
The useful question is never "is this date full?" It is "is this date filling faster or slower than usual?"
- Filling faster than normal → move it up a tier, early
- Filling slower than normal → hold your rate first, and look at why before discounting
That second one is where most money is lost. Which brings us to the evidence.
What the research says about discounting
This is the best-evidenced finding in hotel pricing, and it contradicts most people's instinct.
Cornell researchers analyzed 67,008 hotel observations from 2001 to 2007, spanning a recession and a boom (Enz, Canina & Lomanno, Competitive Hotel Pricing in Uncertain Times, Cornell Hospitality Report Vol. 9 No. 10). They compared hotels against their own comp sets:
| Rate vs comp set | Occupancy vs comp set | RevPAR vs comp set |
|---|---|---|
| 20–30% lower | +15.2% | −12.2% |
| 10–15% lower | +4.5% | −8.3% |
| 5–10% higher | −0.5% | +6.7% |
| 20–30% higher | −10.9% | +10.3% |
Hotels that cut rates did fill more rooms — and still made less money per available room. Hotels that held above their comp set sold fewer rooms and made more.
The reason sits in a separate Cornell study (Canina & Carvell, 2003, 480 hotels over eleven years): lodging demand is price-inelastic. A 1% rate cut moved demand by only about 0.14%. Demand tracked the economy, not your price. A discount mostly moves guests between hotels; it does not create new travelers.
One honest caveat the authors state themselves: this data shows correlation, not causation.
The mistakes that cost the most
Pricing off the calendar instead of the night. "Summer rate" and "winter rate" cannot respond to a competitor selling out on a random Tuesday.
Discounting early because a date looks empty. Most bookings for a date have not happened yet. Check pace against a comparable date before touching the rate.
A comp set full of the wrong hotels. If you benchmark against properties a tier below you, every signal you get will push you down-market.
Ignoring events. Money is concentrated in a handful of nights a year. Missing a single sold-out concert night costs more than a whole quiet week of fine-tuning.
Never checking your own work. If you cannot say whether last Saturday was priced right, you cannot improve. Note the rate, note the final occupancy, and look at it the following week.
The bottom line
Write down your cost per occupied room. Build three or four rate tiers that step up as a night fills. Check your comp set at the same time every day. Move dates up a tier when they fill faster than normal, and resist cutting when they do not. Review last week before you plan next week.
That is a revenue-management routine. It runs on a spreadsheet and fifteen minutes a day.
The reason operators eventually buy software is not that the method changes — it is that doing it by hand for 365 dates, across every room type, while also running a hotel, is the part that breaks down. If you get to that point, our dynamic pricing engine shows the same build — base rate, market signal, your rules, final price — for every night, and every rate stays inside guardrails you set.