Gettel Toyota of Bradenton — GM Command Center

Gettel Toyota of Bradenton — Store Health

Day 14 of 31 · March 2025 · Upload files to refresh

▶ Volume & Pace

New Car Units

82

Goal: 200 · Needed: 118

Pace

182

5.9 new/day needed

Used Car Units

52

Goal: 120 · Needed: 68

Pace

115

4.0 used/day needed

Total Units

134

Goal: 320 · Needed: 186

Pace

297

10.9 total/day needed

👤 Salesperson Pulse · tap to view →

Pacing 10+ cars—

No sale 3+ days—

🏆 Most New Units—

🏆 Most Used Units—

🏆 Highest Single Gross—

🏆 Highest PVR (3+ deals)—

🎯 Closing %

New Car Internet (tgt 12%) —

Used Car Internet (tgt 10%) —

VEP / RO Count (tgt 2.5%) —

▶ Front & Back End Health

New Front PVR

—

Target: ($340)

Used Front PVR

—

vs $778 prior mo

F&I PVR

—

vs $2,365 prior yr

Total Back Gross

—

New + Used F&I

▶ Fixed Ops Pulse

Service ROs Written

1,188

Prior yr pace: 3,000

Service Gross vs Goal

37%

$180K of $484K goal

Parts Gross vs Goal

22%

$101K of $467K goal

Body Shop · Erick Grenesko

ROs

36

Gross

—

Prior yr: 236 ROs 🚨

▶ Manager Snapshot

	Manager	New Units	New Pace	Front PVR	vs Target	Used Units	Back PVR	Status

Desk Log — Sales Feed

Upload desk log on the Upload tab · reads NEW LOG and USED LOG tabs automatically

🚕 New Car

Units

—

Front Gross

—

Front PVR—

Goal200 units

Pace—

🚗 Used Car

Units

—

Front Gross

—

Front PVR—

Goal120 units

Pace—

⭐ Total Combined

Total Units

—

Total Front

—

Combined Front PVR—

Goal320 units

Total Pace—

Today

New Car Log

Used Car Log

By Manager

Model Mix

🏆 Salespeople

New Today

0

Used Today

0

New Front Today

$0

Used Total Today

$0

Today — New Cars

#	Customer	Model	SP	Mgr	Front	Back	Total	Status

Today — Used Cars

#	Customer	Model	SP	Mgr	Front	Back	Total	Cert

Gross Tracker — MTD vs Annual Forecast Goal

All departments with pace-to-month-end. Updates when workbooks are uploaded.

Total Store Gross MTD

—

Pace: —

Annual Forecast Goal

—

Monthly target

% to Goal

—

Gap: —

Projected Month-End

—

Based on current pace

Variable Operations

Fixed Operations

★ Total Store Gross — All Departments

MTD Actual vs Monthly Goal — All Departments

🔒 GM Only

Net Profit Tracker & Estimator

Projected end-of-month net income with methodology detail

Projected End-of-Month Net Income

—

Upload DOC workbook to activate

—

Projection Methodology

Day / Days in Month—

MTD Total Gross—

Projected Month-End Gross—

Avg Sell Exp % (12-mo, outliers excl.)52.3%

Projected Selling Expense—

Projected Selling Gross—

Fixed Admin (prior yr basis)($548,812)

Operating Profit—

Net Adds (prorated by units)—

New Veh Incentive ($1,064/car est.)—

PROJECTED NET INCOME—

Benchmarks

Prior Year Same Month$1,488,846

Prior Month$817,574

12-Month Average$1,062,595

12-Month High (Dec 2024)$1,552,576

YTD Net Income$624,057

Prior YTD$1,998,656

~$300K in fixed charges not yet posted

Mortgage, mgmt fee, SWAP interest, depreciation not yet charged. True net will compress when posted.

12-Month Net Income — Apr 2024 → Mar 2025

🔒 Manager Payline

Team Manager Payline MTD

—

Upload desk log to calculate pace

New Car Total Gross (from log)—

Used Car Total Gross (from log)—

Wholesale Gross (DOC)—

Wholesale Credits (DOC)—

Income Reserve ($1,125 × New Units)—

Chargebacks (Deduction)—

Adjustments (Deduction)—

TOTAL PAYLINE—

Pace to Month-End—

P&L Summary

Line Item	Current Mo	Prior Mo	Prior Yr Mo	YTD

Variable Operations

New Cars · Used Cars · F&I · Manager Scoreboard · Payline

New Car

Used Car

F&I

F&I Report

Scoreboard

Payline

Recommendations

New Units

—

MTD

Front Gross

—

Front PVR

—

Target: ($340)

Gap to Target

—

Per unit vs target

Dollar Gap

—

Total vs target

Model Performance

Model	Units	Our PVR	Target	Gap	Total Front	$ Gap	Grade

PVR vs Target

Fixed Operations

Service · Parts · Body Shop

Service

Parts

Body Shop

Recommendations

Monthly Forecasts

Service Gross

Parts Gross

Body Shop Gross

Enter monthly targets · used for recommendations & pace tracking

CP ROs Written

—

MTD

Warranty ROs

—

MTD

Total Service Gross

—

Upload Gameday

Total Sales

—

MTD

CP Gross

—

Warranty Gross

—

Internal Gross

—

Sublet Gross

—

Service Revenue Detail

Category	MTD Sales	MTD Gross	Margin	Prior Mo	Prior Yr

Gross Trend — vs Prior Mo & Prior Yr

vs Prior Mo

—

vs Prior Yr

—

Monthly Forecast

—

BDC — Month to Date Activities

Sourced from Gameday workbook · New Car & Used Car Phone, Internet, Walk-in, Vehicle Exchange

🚕 New Car MTD

📞 In-Coming Phone Activity

Metric	Forecast	Actual	Trend	Needed/Day

🌐 Internet Activity

Metric	Forecast	Actual	Trend	Needed/Day

🚶 Walk-in Activity

Metric	Forecast	Actual	Trend	Needed/Day

🔁 Vehicle Exchange

Metric	Forecast	Actual	Trend	Needed/Day

🚗 Used Car MTD

📞 In-Coming Phone Activity

Metric	Forecast	Actual	Trend	Needed/Day

🌐 Internet Activity

Metric	Forecast	Actual	Trend	Needed/Day

🚶 Walk-in Activity

Metric	Forecast	Actual	Trend	Needed/Day

🎯 Closing % Summary

New Car Internet (S/B ≥12%)—

Used Car Internet (S/B ≥10%)—

VEP / RO Count (2.5%+)—

New Phone Appts to Calls—

Upload Gameday workbook to populate

Go to Upload tab → Drop Gameday Workbook. Parser reads the "Sales Manager Game Day Report" tab and extracts all BDC MTD activities automatically.

Closing Percentage

Populated from Gameday workbook — "Sales Manager Game Day Report" tab

Upload Gameday workbook to populate

Parser reads "Sold to Lead (S/B >= 12%)", "Sold to Lead (S/B >= 10%)", and "Sold to RO Count (2.5% +)" lines from the Gameday sheet.

Sold to Lead (S/B ≥ 12%)

Target: 12.0%

—

Upload Gameday workbook

Sold to Lead (S/B ≥ 10%)

Target: 10.0%

—

Upload Gameday workbook

Sold to RO Count (2.5%+)

Target: 2.5%

—

Upload Gameday workbook

Manual Entry Override

New Car Internet %

Used Car %

VEP %

🔒 GM Only

Finance — F&I Performance

F&I Gross · PVR · Pace · Manager Breakdown · Chargebacks · Adjustments

▶ Deal Status · Per Sales Daily Input

🚕 New Car Deal Status

E · Spot

—

— % · Spot

C · Closed

—

— % · Closed

F · Finalized

—

— % · Finance

Total All Deals—

🚗 Used Car Deal Status

E · Spot

—

— % · Spot

C · Closed

—

— % · Closed

F · Finalized

—

— % · Finance

Total All Deals—

⭐ Combined Deal Status

E · Spot

—

— % · Spot

C · Closed

—

— % · Closed

F · Finalized

—

— % · Finance

Grand Total All Deals—

Source: Gameday workbook upload

▶ F&I Gross Performance

🚕 New Car F&I

F&I Gross

—

From DOC

F&I PVR

—

vs prior yr

Units—

Pace to Month-End—

WARR Reserve—

FIN/LEA Reserve—

GAP Reserve—

🚗 Used Car F&I

F&I Gross

—

From DOC

F&I PVR

—

vs prior yr

Units—

Pace to Month-End—

WARR Reserve—

FIN/LEA Reserve—

GAP Reserve—

⭐ Total F&I

Total F&I Reserve

$279,074

72 deals

Combined PVR$3,876

Pace to Month-End—

Total WARR Reserve$112,803

Total FIN/LEA Reserve$78,127

Total GAP Reserve$88,144

▶ F&I Manager Leaderboard — Mike Brewer · Finance Director

	Manager	Deals	F&I Gross	PVR	VSC	VSC/Deal	GAP	GAP/Deal	Maint	Fin Reserve	Cash	Finance	Outside

F&I by Product — New Car

Product	Gross	Adj	Chargeback	Net	Prior Yr

F&I by Product — Used Car

Product	Gross	Adj	Chargeback	Net	Prior Yr

▶ Chargebacks & Adjustments

Chargebacks — By F&I Manager

Manager	Items	Total CB	Avg/Item

Chargeback Summary

Total Chargebacks MTD

—

Adjustments — By F&I Manager

Manager	Items	Total Adj

Grand Total Adjustments—

▶ Deal Detail

Date	Stock#	N/U	Customer	Mgr	Units	WARR Res	FIN/LEA Res	GAP	Total F&I

🚗 Used Car Inventory — vAuto Insight

Investment Summary — Averages (retail avg, 109 units, 21 day avg) · Mar 15, 2026 · Upload PDF on Upload tab to refresh

Total Units

109

Retail avg inventory

Avg Days in Inventory

21

Retail avg · target <45

Turn Rate

17.38

Prior week: 19.14

Market Days Supply

56

Retail avg MDS

Adj % Cost to Market

90%

Retail avg · owned right

Adj % of Market

99%

Retail avg pricing

Total Investment

$2,529,148

Retail avg · $25,291/unit

Red Car Count

3

Retail avg period

▶ Need Attention

59 Fewer than
15 Photos

78 Locked
Description

17 Open Recall
Vehicles

17 Off-Target
Price

24 Descriptions
to Review

4 No Price
(No Pending)

8 Market
Too Small

4 Not Digital
Frontline Ready

Inventory by Age Bucket — Current

Age	Units	Total Inv.	Avg Inv.	CTM%	% Mkt	MDS	Avg Markup
0–10	33	$386,663	$18,413	78%	101%	49	$3,410
11–20	31	$821,914	$27,397	93%	100%	47	$1,211
21–30	21	$575,886	$27,423	102%	100%	57	($820)
31–40	10	$256,432	$25,643	96%	97%	88	$514
41–50	8	$251,825	$31,478	102%	97%	79	($838)
51–60	2	$78,718	$39,359	88%	86%	66	($298)
61–70	0	—	—	—	—	—	—
Total	105	$2,371,438	$25,777	93%	99%	56	$989

Price Ranking Buckets

Knowledge Network · Enter from vAuto UI

Under Red

Under Yellow

Green

Yellow

Red

Unranked

Green + Under Green vs Red + Under Red

6-Week Trend — Retail Avg Investment Summary Averages

Metric	Feb 8	Feb 15	Feb 22	Mar 1	Mar 8	Mar 15
# Vehicles	107	105	127	125	113	109
Avg Days Inv.	22	21	18	17	19	21
Turn	16.60	17.66	20.45	21.32	19.14	17.38
MDS	52	53	56	57	54	56
CTM %	88%	87%	87%	89%	92%	90%
Water %	2.88%	0.01%	1.69%	1.10%	1.05%	0.15%
Red Cars	0	2	9	5	3	3
Avg Investment	$21,878	$21,431	$21,875	$23,904	$25,503	$25,291

Appraisal Scorecard — by Manager 60 days

Appraiser	Appraisals	Taken In	Look to Book
Soler	303	56	18.5%
Santos	268	59	22.0%
Burke	263	67	25.5%
Knott	96	40	41.7%
Wilbur	88	36	40.9%
Jones	10	0	0.0%
Santa Cruz	10	0	0.0%
Total	1,045	258	24.7%

Digital Merchandising — VDP Views

AutoTrader

7,349

SRP: 499,742 · 1.5% VDP rate

CarGurus

7,044

VDP views

Cars.com

5,215

SRP: 252,947 · 2.1% VDP rate

Top Appraisers — by Salesperson 60 days

Salesperson	Appraisals	Taken In	L2B %
Burke	4	3	75.0%
Espinel	35	18	51.4%
Redler	4	2	50.0%
Reed	8	4	50.0%
Blackburn	23	10	43.5%
Frank	26	11	42.3%
Evasku	24	9	37.5%
Aguilera	30	11	36.7%
Vazquez	56	22	39.3%
Moreira	88	15	17.0%
Total	1,045	258	24.7%

Upload vAuto Insight Report PDF to refresh all data

Go to Upload tab → Drop vAuto Insight Report PDF. Auto-populates inventory age buckets, appraisals, trends, and Need Attention alerts.

🔒 GM Only

🔁 Wholesale

Wholesale units, gross, and credits — sourced from Reynolds DOC · upload on Upload tab

Wholesale Units

—

Pace: —

Wholesale Gross

—

MTD

Wholesale Credits

—

Toyota incentive credits

Age Penalty

—

Used vehicle age

Wholesale Summary

Wholesale Units MTD—

Wholesale Gross—

Wholesale Credits—

Age Penalty—

Net Wholesale—

12-Month Wholesale History

🔒 GM Only

Chargeback Analysis & Adjustments

Upload Reynolds Chargeback workbook — auto-assigns by F&I manager initials (JD, MB, ES, JC, DL) · no initials = HOUSE

📄

Drop Reynolds Chargeback Workbook

Accepts .xlsx — reads Account, Amount, Description columns automatically

Total Chargebacks

—

All products

Total Adjustments

—

Negative amounts

Service Contract CB

—

Accts 16271 + 16371

GAP Chargebacks

—

Accts 16293 + 16393

Prepaid Maint CB

—

Accts 16273 + 16373

By Product

Product	Account(s)	Chargebacks	Adjustments	Net

By F&I Manager

JD = Julio Diaz · MB = Michael Brewer · ES = Einar Saldana · JC = Jonathan A Cruz · DL = Daniel A Lopez · HOUSE = unassigned

Manager	Initials	Items	Chargebacks	CB / Item	Adjustments	Net	Flag

Chargeback Trend — 12 Months

⚙ Adjustments — By F&I Manager

Upload TOB_ADJ workbook on the Upload tab · Initials before slash (ES/441937) or dash · No initials = HOUSE

Manager	Initials	Items	Total Adj	Per Item

Grand Total Adjustments—

Acct 16283 — FIN ADJ NC—

Acct 16383 — Finance Adj Used—

Acct 16396 — UC Serv Cont Adj—

Adjustments deducted from Manager Payline

Grand total flows automatically into the payline calculation as a deduction alongside chargebacks.

🔒 GM Only

Upload Center

Drop files below to refresh all dashboard data · uploads auto-save to this browser

Session Storage Active — data persists across page refreshes

📂 Google Drive Auto-Fetch

Paste a shared Google Drive link for each file · app fetches it automatically on load · no dragging needed

📜 Stone Eagle F&I Log

🏆 Gameday Workbook

📄 Reynolds DOC

⚠ Chargeback Report

⚙ Adjustments (TOB_ADJ)

🔧 Gameday Fixed Ops (optional separate file)

How to get a Drive link: Right-click any file in Google Drive → Share → Change to "Anyone with the link" → Copy link → Paste above. Links are saved automatically and fetched every time you open the app.

📜 Stone Eagle F&I Log

📜

Drop Stone Eagle F&I Log

F_I_Log_YYYYMMDD.xlsx · feeds Desk Log, SP Leaderboard, F&I Manager stats, deal status, model mix

🏆 Gameday Workbook

🏆

Drop Gameday Workbook

Daily upload · feeds BDC, Variable Ops, Fixed Ops gross, closing %, model performance

📄 Reynolds DOC

📄

Drop Reynolds DOC Workbook

Weekly/monthly · feeds Net Profit, Fixed Ops, Wholesale, Incentive, Expenses

📊 DORA Report (PDF)

📊

Drop DORA Report PDF

Monthly · updates model target PNVRs on Model Cheat Sheet

🚗 vAuto Insight Report

🚗

Drop vAuto Insight Report

Weekly · feeds vAuto tab · inventory age, turn rate, CTM%, appraisals, need-attention alerts

⚠ Chargeback Report

⚠

Drop Chargeback Workbook

Feeds chargeback analysis by manager & product · payline deduction

⚙ Adjustments (TOB_ADJ)

⚙

Drop Adjustments Workbook

TOB_ADJ file · F&I manager initials · feeds Chargeback page & Payline

Upload Status

Stone Eagle F&I LogNot uploaded

Gameday WorkbookNot uploaded

Reynolds DOCNot uploaded

DORA ReportJan 2026 targets active

vAuto InsightNot uploaded

Chargeback ReportNot uploaded

Adjustments (TOB_ADJ)Not uploaded

Adjustments (TOB_ADJ)

Alerts & Recommendations

All departments — generated from loaded data

— Critical — Watch — Process — Strong

Variable Ops

Fixed Ops

Financial

Process

🔒 GM Only

Expense Analysis

Sourced from Reynolds DOC · Current Mo vs Prior Mo vs Prior Yr Mo · Flags changes >40% and >$5,000

Early-month context

Selling expenses (commissions, advertising, F&I comp) typically post mid-to-late month. Large drops vs prior month in selling exp are expected at day 14 and not cause for concern. Fixed/Admin expense swings are more meaningful at any point in the month.

⚠ Expense Flags — Changes >40% and >$5,000

Selling Expenses

Operating Expenses

Fixed / Admin

Selling Expenses by Department

Department	Current Mo	Prior Mo	Prior Yr Mo	vs Prior Mo	vs Prior Yr	Flag

Selling Expense Detail

Line Item	Dept	Current Mo	Prior Mo	Prior Yr Mo	Chg vs Prior	Flag

🤖 Ask AI — Data Assistant

Ask questions about your loaded data — units, gross, pace, managers, chargebacks, F&I, expenses

AI

Hi! I can answer questions directly about your Gettel Toyota data.

Quick setup (2 steps):
1. Get a free API key at console.anthropic.com → API Keys → Create Key
2. Type any question — I'll ask for the key on first use

Note: If you see a CORS error, you need to serve this file from localhost. Open Terminal and run:
python3 -m http.server 8080
Then open http://localhost:8080 in Chrome.

📋 Data Context Loaded

💡 Sample Questions

"What's Tom J's opportunity cost?"
"Are we on track to hit 200 new units?"
"Compare Avery B vs Max W"
"What's dragging service gross?"
"Which F&I manager has the best PVR?"
"What fixed expenses haven't posted?"
"How does this month compare to prior year?"
"What's the CPO percentage?"