Ref. P20-014 · 2020 Ram 1500 · Columbia used · day 88

Daily DOC · rolling 30 days · Ed Morris Group

$504,000 in lost gross.

On 5 aged units. 88 days average on the oldest. Data you already own — now visible for the first time.

Lost gross · this periodi
$504K
5 aged units · 60 stated buyers · $3,800 avg gap per unit · 30 days
Daily DOC
9 Apr · 9:47 AM
Units MTD
312▲ on plan
Front gross / unit
$2,840▼ $340
Back PVR (F&I)
$1,960▲ top tier
Aged > 60d
9units
Close rate
16.9%▲ 1.2pt

Ed Morris Automotive Group · Columbia, Jefferson City, Lake Ozark

Executive terminal.

Four stores. Twenty-one agents. Rolling thirty days of every conversation on every floor — assembled into the three decisions only ownership can make.

Daily briefing →

The group

Four lots.
One ledger.i

Close rates, rolling thirty days.

Columbia · Kia
Columbia, MO
19.2%
Jefferson City · Kia
Jefferson City, MO
15.4%
Columbia · Used
Columbia, MO
14.8%
Lake of the Ozarks
Lake Ozark, MO
11.3%

Network at a glance.i

rolling 30 days
Conversations
1,842
Closes
312
Close rate
16.9%
Walk-aways
884
Re-engaged
171
Recovered
$4.1M

Pricing intelligence

The price gap report.i

Where they walked, and what they told us they would have paid.
$504K on table
2024 Sorento X-Line AWD
63 days · 2 units · K24-812
$38,900 listed
$35,200
$30K$35K$40K
15
would buy
2023 Telluride EX
41 days · 1 unit · K23-604
$48,400 listed
$44,800
$40K$45K$50K
11
would buy
2020 Ram 1500 · pre-owned
88 days · 1 unit · P20-014
$31,900 listed
$28,100
$25K$30K$35K
18
would buy
2024 K5 GT
37 days · 1 unit · K24-231
$34,200 listed
$32,600
$30K$33K$36K
9
would buy
2024 Sportage Hybrid EX
29 days · 2 units · K24-119
$36,800 listed
$34,500
$32K$35K$38K
7
would buy
Across five slow-turning units, 60 buyers told us during a conversation what they would pay. The delta between your listing and their willingness-to-pay is real, recent, and quotable.
$504K
aggregate · on table

Inventory gaps

What they asked for,
that you don't have.i

Every customer request logged. Ranked by frequency. 30 days.
White Rogue SV
2023+ · under $30K
14
Used Telluride
7-seat · under $42K
11
AWD compact SUV
hybrid · any colour
9
Used truck · tow pkg
$28K max
8
EV · sub-$40K
rebate-eligible
6
Manual transmission
any · sub-$25K
4
For the sourcing team: how quickly can we acquire fourteen white Rogue SVs at auction? At an estimated $2,400 gross each — that is $33,600 of captured gross this month alone.

Who walks in

Demographic picture.i

Every customer categorised from the conversation — not a survey, not a guess.

HOUSEHOLD SHAPE

Family 4+
38%
Couple
25%
Single
19%
Retired
11%
Student
7%

FINANCING READINESS

Pre-approved
41%
Prime (est)
33%
Sub-prime
19%
Cash
7%

Foot traffic

By hour, by day.i

conversations · Columbia Kia · 30d
MON
TUE
WED
THU
FRI
SAT
10A
3
4
6
5
7
14
12P
7
8
10
11
12
22
2P
8
10
11
13
15
24
4P
9
11
14
15
18
21
6P
6
7
9
11
10
8
Saturday 12–4 PM is your peak. You had three agents scheduled last Saturday against 46 conversations.

Why they walked

Top eight blockers.i

884 walk-aways · 30d
Price too high
32%
Wrong colour
18%
Not in stock
15%
Trade too low
11%
Still shopping
9%
Fin. denied
7%
Feature missing
5%
Bad experience
3%

Recovery

Walk-aways recovered.i

171 of 884 re-engaged · $4.1M recovered
19.3%
recovery rate
Same vehicle
54%
Price drop
28%
Alt match
18%
Industry average recovery: ~2%. Your floor runs at nearly ten times that — because the AI never forgets what the customer told you.

Before Closer, after Closer.i

group-level · rolling 30 days
Before Closer · baseline month
2%
Walk-away recovery rate. ~18 recovered out of 884 walk-aways — most of them accidental (customer happened to call back).
Conversations captured0
Structured profiles0
Follow-ups sent~40 / mo
Recovered revenue~$420K
After Closer · pilot month 1
19.3%
Walk-away recovery rate. 171 re-engaged of 884 — because the AI never forgot what the customer told you, and drafted the outreach on arrival.
Conversations captured1,842
Structured profiles1,842
Follow-ups sent612 / mo
Recovered revenue$4.1M

Investment · Ed Morris pilot

$18,000 / month.
For all four lots.i

A rounding error against $504K in first-month recovered revenue. Pilot rate locks for the first three months — after that, standard rate at $8,500/store. Either way, the system pays for itself in four recovered deals per month.

Monthly cost · pilot
$18K
$4.5K × 4 stores
Infra included
~$900
deepgram · haiku · hosted
Visible revenue / mo
$504K
price-gap alone, month 1
Return ratio
28×
recovered ÷ subscription
Morning briefing · 9 Apr 2026 · 9:00 AM CT

Three things before your 9:30.i

Generated overnight from every conversation across all four stores. The same briefing was prepared for each store manager — customised to their floor.
i

The used-truck gap is costing you $504K.

Eighteen buyers in the last thirty days said they would pay near $28,000 for a used 4×4 with a tow package. You don't have one. The Ram 1500 on the Columbia used lot at $31.9K has sat eighty-eight days.

ii

Eric Lund needs EV product training.

His close rate on EV inquiries is 6% — floor median 19%. Three customers last week mentioned the Niro EV and walked. Strong on ICE. Specific, fixable gap.

iii

Saturday is under-rostered.

Your peak is Saturday 12–4 PM — forty-six conversations against three scheduled agents. Conversion drops 34% when the ratio exceeds 1:4. Adding one body likely captures ~$38K next Saturday.