How to build a car hire rate matrix

By the DayRunner team · 7 November 2026

A rate matrix is a base rate for one car type, multiplied by a set of factors: one for each car category, season, hire length and day of the week. You build it once, then manage a dozen numbers instead of hundreds of prices. The final rate for any booking is base × category × season × hire length × day.

This guide walks through each layer, with real category gaps from Rate Pulse airports and a template you can copy.

Why build a matrix at all

Most small fleets start with a rate sheet: a price for every car type, for every week, typed in by hand. It works until you have six car types, five seasons and four hire-length bands. That's 120 prices, and they drift out of line with each other.

The common symptoms:

• an SUV that costs less than a compact on some dates
• a 7-day hire that works out dearer per day than a 3-day hire
• a holiday week priced the same as the week before it because nobody updated it

A matrix fixes all three. The relationships are set once, so they hold everywhere.

The layers

The order doesn't matter for the maths, since multiplication works either way. It matters for how you think about it. Start with the base.

The method

1. Pick your anchor

   Choose your highest-volume car type and most common hire length. For many fleets that's a compact on a 3 to 6 day hire.

2. Set the base rate

   Use the market median for that car type in a normal week, times your target position. See how to price car hire against the market.

3. Build the category ladder

   Set every other car type as a multiple of the anchor. Start from the market's own gaps, then adjust for your fleet.

4. Set season bands

   Give each part of the year a multiplier, from your own utilisation history.

5. Set hire-length bands

   Decide how much cheaper per day a long hire is than a short one.

6. Add day-of-week moves if your data shows them

   Many fleets don't need this layer.

7. Add floors and ceilings

   No final rate goes under cost or over your maximum.

Step 3: the category ladder, with real numbers

The ladder is the easiest layer to get wrong, and the easiest to check against the market.

Here are the market median daily rates from the Rate Pulse sweep of 7 Nov 2026, shown as a multiple of each airport's compact median. Compact = 1.00.

A few things stand out.

Economy and compact sit close together almost everywhere. At Auckland the gap was only 4%. If your economy is 25% cheaper than your compact, you're probably giving away the economy cars or overcharging for the compacts.

The SUV step varies a lot: 1.29 in Madrid, 1.77 in Melbourne. Don't copy a ladder from another market.

People carriers carry the biggest premium. That fits: there are fewer of them, and the people who need one can't easily switch to two small cars.

This is one snapshot from a November shoulder period, at one hire length. In peak season the ladder can stretch, because the bigger cars sell out first. Check it against your own data.

Step 4: season bands

Season multipliers come from your own utilisation, not the market. Pull 12 months of fleet utilisation by week and sort the weeks into bands.

A simple rule to start with, for a hypothetical fleet:

The multipliers are illustrations, not advice. Yours depend on how far your prices can move before demand drops off. See price elasticity and shoulder season.

Peak bands are usually holidays and big events. Those deserve their own guides: school holidays and events.

Step 5: hire-length bands

Longer hires cost you less per day to run. One clean, one handover and one damage check, spread over more days. They also block the car from shorter, better-paying hires, which matters in peak weeks.

A hypothetical starting set:

In peak bands, consider shrinking the long-hire discount, or adding a minimum rental length. See length of rental for the wider idea.

Rate Pulse prices are 3-day hires, divided by 3. So compare them with your 3 to 6 day band, not your weekly rate.

Worked example: one price out of the matrix

Say you run 40 cars out of Queenstown with an in-terminal desk. Your anchor is a compact on a 3 to 6 day hire.

The Rate Pulse sweep of 7 Nov 2026 put the Queenstown compact median at NZ$210 a day. You decide to sit at 0.95 of the market, so your base is NZ$200 in a shoulder week.

Now price an SUV, in a high-season week, for an 8-day hire, picked up on a Friday where your data shows a 5% bump:

Round to NZ$322 a day, or NZ$2,576 for the 8 days. Then check it's inside your floor and ceiling.

The SUV multiplier is the real Queenstown ratio. The season, hire-length and Friday multipliers are made up for the example.

Next month the market median moves to NZ$220. You change one number, the base, to NZ$209. Every price in the matrix moves with it, and the relationships stay intact.

A template you can copy

Set this up as two tabs in a spreadsheet. The first tab holds the inputs.

The second tab multiplies them out: one row per car type and season, one column per hire-length band. Wrap each cell in a MAX and MIN so it can't break the floor or ceiling.

Keeping it honest

• Check the ladder monthly. Compare your category gaps with your airport's market gaps on Rate Pulse.
• Check which category sells out first. If it's always the same one, its multiplier is too low.
• Don't add layers you can't measure. A day-of-week layer with no data behind it is just noise.
• Write down why each number is what it is. In six months you won't remember.

The categories you sell need to line up with the market's for any of this to work. See car category mapping and ACRISS codes.

Questions