See inside
This is the actual tool.
The Dashboard tab, shown with sample numbers — your figures replace them in seconds. Runs in Excel or Google Sheets.
One month of store numbers becomes a clean monthly P&L, a 15-KPI scorecard flagged against benchmarks, and a consolidated what-if that prices your biggest gaps. The command view that sits on top of the department tools — no DMS integration, no consultant.
The Dashboard tab, shown with sample numbers — your figures replace them in seconds. Runs in Excel or Google Sheets.
Any dashboard can add up every department's gaps and flash a number north of half a million. You run the store — you know no month closes with F&I, front-end and inventory all at benchmark at once. So this rolls the full gap into a ceiling, then applies a realistic capture rate (default 40%, editable) blended across the departments. The number you take to your manager meeting is one you can stand behind.
Enter the store once. Read a real P&L, score fifteen KPIs against benchmarks, and see the consolidated money in reach — all from one workbook.
Gross by department — new, used, F&I, service, parts — then variable, personnel, advertising, semi-fixed and fixed expense, down to net profit, net margin and service absorption. The whole store in one column.
Used-to-new, F&I PVR, front gross per unit, gross mix, absorption, expense ratios, net margin, days supply and turn — each flagged Below or At / Above, sourced where it counts and editable everywhere.
The biggest store-level gaps priced in one place — F&I PVR, front-end gross, used velocity — with the realistic capture band front and center. The department tools break each one down further.
Type your new, used, F&I, service, parts and expense totals into the blue cells.
See gross by department and net profit — a clean statement, no accountant required.
Fifteen metrics flagged against benchmark. See exactly where the store is soft.
Take the consolidated What-If — at a realistic capture — into your next manager meeting.
Honest by design: expense and margin references are marked "typical" and meant to be swapped for your own or your 20-group's numbers. Benchmarks are directional, not guarantees.
Pairs with the F&I, Fixed-Ops and Used-Car tools — this is the roll-up; those are the department deep-dives.
Instant download · Excel & Google Sheets · One-time $199 · 30-day guarantee
Get the Dealership P&L + KPI Dashboard — $199