Audit the Affordability Gap Between Your Shoppers and Your Lot

The deal you lost was priced, not sold

A shopper walks in wanting a $420 payment. Your rep shows them a unit that quotes at $610. The customer says they'll think about it. The rep logs it as "payment objection" and moves on.

Run that same story thirty times in a month and you don't have a payment objection. You have an inventory problem, a desking problem, or a lead-source problem — and nobody on your floor is set up to tell you which.

Most stores track gross, units, and closing rate. Almost nobody tracks the gap between what shoppers can afford and what's sitting on the lot. That gap is measurable, and the audit takes an afternoon.

What you're actually auditing

The question is simple: for each inventory price band, how many shoppers walked in wanting that range, what did we quote them, what came back approved, and did they end up in something else?

Five data points per deal. You probably have four of them already.

• Stated budget. What the customer said — payment, cash down, or total price. Pulled from the CRM note, the BDC call, or the credit app.
• First quoted payment. The number on the first pencil or the first menu they saw.
• Approval outcome. Approved as structured, approved with conditions, counter-offered, declined.
• Vehicle switch. Did they end up in a different unit than the one they came for? Up, down, or sideways?
• In-stock alternatives at the time. How many units you had in the band they said they wanted, on that day.

That last one is the one everybody skips, and it's the one that makes the whole audit useful. Without it you're just looking at lost deals. With it, you can tell the difference between "we didn't have the car" and "we had the car and didn't show it."

Set your price bands before you pull anything

Don't use quartiles. Use bands that mean something to a shopper on your lot. For most stores that's payment bands, because that's how the customer thinks.

A workable default:

• Band A: under $350/mo
• Band B: $350–$475
• Band C: $475–$600
• Band D: $600–$750
• Band E: $750+

Map every unit in stock into a band using a standard structure — say 72 months, tier-2 rate, $2,000 down, your local tax. It doesn't have to be the deal you'd actually write. It has to be consistent, because you're comparing distributions, not quoting customers.

Now you can put two charts side by side: how many shoppers asked for each band, and how many units you had in each band. That's the core of any honest dealership affordability review.

Pull 60 deals and sort them

Take the last 60 closed-and-lost opportunities. Not 300 — you'll never finish. Sixty gets you enough to see shape.

For each one, fill in a row:

Then count the patterns. You're looking for four specific failure types.

Failure 1: You don't stock the band

Shopper says Band A or B. You had zero to three units there. Rep quoted Band C or D because that's all there was.

This isn't a sales failure. This is a dealership inventory mix problem, and your used-car buyer needs to see it in writing. If 40% of your traffic asks for under $475 and 12% of your stock prices there, no amount of coaching fixes that.

The fix is acquisition, not objection handling. And it's a conversation with real numbers instead of a feeling.

Failure 2: You stock it and didn't show it

This is the painful one. Shopper says Band B, you had 19 units in Band B, and the rep quoted Band D anyway.

Go listen to those calls. Usually one of three things happened:

• The rep never asked for a budget, so they defaulted to the unit in the lead.
• The customer gave a budget and the rep heard it as a starting point to be overcome.
• The rep didn't know what was in stock under $475 because nobody walks the back row anymore.

Rep: "I hear you on $400. Let me show you what we've got — this one's gonna be a little more but it's loaded." Customer: "How much more?" Rep: "We can work on the numbers."

That's the sound of a Band B shopper being walked into Band D. "We can work on the numbers" is where the deal died, three steps before the pencil.

Failure 3: The quote was fine and the approval wasn't

Shopper asked Band B, you quoted Band B, lender came back with a counter that lands in Band C. The customer can't get there.

Count these separately. If this is a big slice of your lost deals, your problem is structure and lender mix, not inventory. Look at which lenders are generating counters, at what tier, and whether your reps are structuring with enough down to survive the callback.

The tell: approval outcomes cluster by credit tier, not by vehicle. Band B shoppers at tier 4 get countered 70% of the time while tier 1 sails through. That's a desking conversation and a subprime inventory conversation — you need units that price low enough to absorb the advance cap.

Failure 4: The switch nobody logged

Customer came for a $26,000 SUV, bought a $21,000 sedan. That's a successful save and you should know how often it happens and who's good at it.

Reps who save switches well have a pattern. They ask about the payment early, they confirm it out loud, and they re-present instead of defending.

Rep: "So $425 is the number that works, and anything over about $450 is a no. Did I get that right?" Customer: "Yeah, that's about it." Rep: "Then let me stop showing you the Highlander. I've got two units that hit $430 and one that hits $415. Let's look at those."

That rep didn't lose gross. He stopped burning an hour on a car the customer was never going to buy.

Turn the audit into three standing numbers

Once you've done this once, don't make it a project. Make it three sales manager metrics you look at monthly:

1. Band coverage ratio. For each band: units in stock ÷ shoppers requesting it. Anything under 0.5 is a stocking gap. Anything over 3.0 is money sitting still.
2. Quote drift rate. Percentage of deals where the quoted band is higher than the stated band while you had inventory in the stated band. This is pure coaching. Target it under 15%.
3. Counter-to-close on band-matched deals. When the quote matched the budget and the lender countered, how often do you save it? If that's under 30%, your structure needs work before your inventory does.

Three numbers. Fifteen minutes a month after setup.

The conversation this unlocks

The reason this vehicle payment analysis matters is that it separates arguments that usually get mashed together in a Monday meeting.

Your used-car manager thinks the floor can't close. Your sales manager thinks the lot is overpriced. Both are partly right, and neither can prove it, so the meeting ends with "we need to do better."

Sorting lost deals by inventory price bands gives each person their actual list. The buyer gets "we need eight more units under $400 a month." The sales manager gets "four reps are quoting over budget when we have the car." The finance director gets "tier-4 counters are killing Band B."

Everybody leaves with something assignable.

If you're already recording your sales calls, most of the budget data is sitting in those conversations — what the customer said their number was, whether the rep confirmed it, and what got quoted instead. Pulling stated budget out of call transcripts and matching it against what got desked is exactly the kind of thing a tool like MoreSignal can surface without anyone retyping CRM notes.

But the audit works with a spreadsheet and 60 rows. Start there. The first time you see your traffic distribution next to your stock distribution, you'll know which argument you've been losing.