MCA AUTOPLEX
Music City Autoplex Dashboard
📊 Dealership Overview
Music City Autoplex — Used Vehicle Operations
📅 JUL 2026 MTD
Units
7
Front Gross
$453
GAP $
—
SVC $
—
Reserve $
—
F&I Rev
$10,009
F&I PVR
$1,430
Front PVR
—
Back PVR
—
Total PVR
—
Total Gross
—
📈 Monthly Units Sold
🍩 Gross Profit by Department
📉 F&I PVR Trend
💸 Chargebacks by Month
🧾 Recent Deals — Jun 2026 MTD
DateStock #CustomerSalespersonF&I MgrTotal Gross
🚗 Sales — Salesperson Performance
Used Vehicles Only • Switch between current month and any prior month
CURRENT MONTH
📅 JUL 2026 MTD
Total Units
0
Front Gross
$453
F&I Revenue
$10,009
Total Gross
$10,462
Avg PVR
$1,430
Front PVR
—
Back PVR
—
Total Deal PVR
—
Avg Gross / Deal
$1,495
🏆 Jun 2026 MTD — Units Leaderboard
RankSalespersonUnitsEst. Front GrossEst. F&I RevEst. Total Gross$/Deal
📊 Jun 2026 MTD — Units by Rep
YTD Summary
Total Reps
8
YTD Units
837
Top Rep Units
142
YTD Avg Gross / Deal
$1,367
GAP Pen
41%
Warranty Pen
38%
🏆 YTD Leaderboard — Sorted by Total Gross
RankSalespersonUnitsFront GrossF&I RevenueTotal Gross$/DealClose Rate
📊 Units by Salesperson (YTD)
💵 Total Gross by Salesperson (YTD)
📅 Monthly Units by Rep (Dec–May)
💳 Finance & F&I
F&I Revenue, PVR, GAP & Warranty Penetration
YTD F&I Revenue
$1,958,442
F&I PVR
$2,340
GAP Penetration
41%
Warranty Penetration
38%
Reserve (est.)
$312K
Jun MTD F&I
$10,009
F&I Revenue by Month
F&I PVR by Month
Monthly F&I Summary
MonthUnitsF&I RevenuePVRGAP PenWarranty Pen
Dec 2025119$257,644$2,16539%36%
Jan 2026118$285,915$2,42340%37%
Feb 2026135$282,503$2,09338%35%
Mar 2026162$382,124$2,35942%39%
Apr 2026145$398,862$2,75144%41%
May 2026151$341,385$2,26141%38%
Jun 2026 MTD7$10,009$1,43043%43%
👤 Performance by F&I Manager
🔧 Service
AutoMatrix DMS • Service Department
YTD ROs
2,145
Avg RO / Month
338
Jun MTD ROs
142
YTD Gross (est.)
$413K
Service ROs by Month
🔌

Connect AutoMatrix DMS

Export a service summary CSV from AutoMatrix and use Import Data to load detailed RO data, technician productivity, and parts cost breakdown.

🔩 Parts
Parts Department — AutoMatrix DMS
🔩

Parts data pending

Export parts sales report from AutoMatrix DMS and import via Import Data tab to activate this page.

📦 Inventory
Used Vehicle Inventory — vAuto · Drop your daily report via 📂 Upload Inventory
Total Units
—
Total Cost
—
Total Retail Value
—
Avg Age (Days)
—
Avg Markup
—
Avg Cost/Unit
—
⚠ Open Recalls
—
🔴 60+ Days
—
📅 Age Buckets — Days on Lot
💲 Price vs Book Distribution
Price: –
Vehicle Inventory
Age ↕ Stock # Vehicle Color Miles ↕ Price ↕ Cost ↕ Markup ↕ % Market Price Rank Recall VIN
📂
Drop your vAuto export via 📂 Load Data → Inventory Tab to populate
💰 Expenses
Operating Expenses — Autosoft DMS
💰

Expense data pending

Export expense report from Autosoft and import via Import Data to activate budget-vs-actual tracking, category breakdown, and MOM comparison.

📋 A/R Parts & Service
Accounts Receivable
📋

A/R data pending

Connect your DMS A/R export to track outstanding balances, aging buckets, and collection status.

📝 Deal Log
Log deals daily · Auto-updates Overview, Sales & Finance pages
Deals
# Date Stock # Vehicle Customer Post Salesperson Split SP Fin. Mgr Front GAP SVC Reserve Total Gross Days Inv Score Source Bank Actions
🏆 Daily Team
Fast Start contest tracker — update each player's units daily and the rest recalculates automatically
⬆️ Import Data
Manual data refresh — paste from Excel or upload CSV
How to update this dashboard
Data SourceMethodFrequency
Sales / F&IEdit JS DATA object in source HTMLMonthly
CIT TrackerRe-export Dealertrack ConStatusCSV → paste into CIT_Data tabDaily / Weekly
Service ROsAutoMatrix export → Import CSV belowMonthly
InventoryvAuto export → Import CSV belowWeekly
ExpensesAutosoft export → Import CSV belowMonthly
Live Link option: Save Flash Report to OneDrive → File > Share > Embed → publish Exec_Feed tab as CSV → update the HTML to fetch that URL automatically on page load.
🚘 Vehicle Model Scorecard
Full analysis of all models sold — helps the used car buyer merchandise smarter
⚡ Fastest Sellers — Days in Stock + Avg Gross
🐢 Slowest Sellers — Days in Stock + Avg Gross
📊 Top 15 Models — Units Sold
# Make / Model Units Avg Days Avg Front Avg Total Gross Avg Miles Top Year(s) Top Source Buy Signal
📅 Month vs Month
Compare any two months side by side
🏦 CIT Tracker
Contracts in Transit — Dealertrack ConStatusCSV
Total Contracts
—
Click to view all →
🟠 In Transit
—
Click to view deals →
🟢 Funded-Booked
—
Click to view deals →
Total Disbursed
—
Click to view all →
⚠ 31+ Days
—
Click to view deals →
📋 Manual / Not Funded
—
Click to view deals →
📊 Aging Buckets — Contracts in Transit
🏢 Top Lenders — Deal Count & Amount
Aging Buckets Detail
BucketContractsAmount% of TotalBar
Top Lenders
Lender (YTD)DealsF&I RevenueFunded
📡 Lead Source Report
Marketing performance by lead source — where your deals are coming from
📊 Source Breakdown — All Metrics
Lead Source Units % Mix Front Gross F&I Rev Total Gross $/Deal Avg F&I
🏆 Units by Source
💰 Total Gross by Source
📈 Monthly Trend — Units by Source
🎯 Monthly Goals Tracker
Store targets and salesperson unit goals — updated in real time from deal data
🏪 STORE GOALS
👤 SALESPERSON UNIT GOALS
Salesperson Goal Actual Remaining Progress Projected Gap to Goal

📂 Load Data

History Status
Step 1 — Download your Flash Report
In SharePoint / OneDrive:
1. Find Flash_Report_v49_16.xlsm
2. Click the ⋯ menu next to the file → Download
3. The .xlsm file saves to your Downloads folder
Step 2 — Drop the downloaded .xlsm file here
📊

Click to browse or drag your .xlsm / .xlsx here

Flash_Report_v49_16.xlsm — reads ALL monthly tabs at once

Contracts
Sale Date Stock # Customer Vehicle Days Salesperson Fin. Mgr Source Front GAP SVC Reserve Total Gross VIN / CIT Funded Status

✅ Post Deal — Final Numbers

Loading deal...
Field
Logged
Posted / Actual
Bank Fee
—
Service Bill
—
Front Gross
—
GAP
—
SVC / Warranty
—
Reserve
—
Total Gross
—
—

Original logged numbers are preserved. Only posted numbers change the dashboard gross.

☁️ Cloud Sync Setup

Connect a free Firebase database so all managers see the same deals in real time — no matter whose computer they log a deal from.

1Create free Firebase project

Go to console.firebase.google.com → Add project → name it "Music City Autoplex" → skip Analytics → Create.

2Create a Realtime Database

In the left menu click Build → Realtime Database → Create database → choose United States → Start in test mode → Enable.

3Copy your Database URL & paste below

At the top of the Realtime Database page you'll see a URL like:
https://music-city-autoplex-default-rtdb.firebaseio.com/

ℹ️ Every manager needs to enter this URL once. After that it saves automatically.

💸 Chargebacks
Track reserve, warranty, GAP and other chargebacks — automatically reduces reported gross
Date Type Notes Amount Actions
🔧 Posting Adjustments
Track changes made when deals are posted — see where the F&I process needs attention
Adjustments by Category — what's driving the changes
Category # Deals Total $ Avg / Deal Share of Total Impact
Adjustments by F&I Manager
F&I Manager Posted Adjusted Front Δ GAP Δ SVC Δ Reserve Δ Gross Δ Avg |Gross Δ|
Adjusted Deals — Detail
Date Stock # Customer F&I SP Front (orig → post) GAP (orig → post) SVC (orig → post) Reserve (orig → post) Gross Δ Notes
📋 Pending Deals
Deals in progress — not yet flashed in Automatrix. Use Status notes to track what's preventing funding.
Pending Deals
Date Stock # Vehicle Customer SP F&I Est. Gross Bank Status / Comments Actions
💀 Dead Deals
Deleted deals are kept here for 90 days — restore them back to the Deal Log, or they'll be automatically and permanently removed once their time is up
Deleted Deals
Deleted Days Left Deal Date Stock # Vehicle Customer SP F&I Gross Bank Actions
🧮 Reserve Calculator
Select Bank / Lender
Wells Fargo Max Markup: +2.00% Participation: 75%
Amount Financed
$
Term (Months)
Buy Rate (Bank Rate)
%
Rate bank gives the dealer
Contract Rate
%
Max allowed: 16.95%
Customer Payment
—
per month
Buy Rate Payment
—
per month
Rate Spread
—
markup points
Payment Difference
—
per month
💰 Estimated Reserve Earned
—
based on 75% participation rate
At Max Markup
—
Total Interest (Customer)
—
Left on Table
—
📊 Reserve at Different Markups
💲
Payment Roller
Enter the payment you're working with — we'll find the selling price that hits it
Target Payment
$
per month
Interest Rate (APR)
%
Term (Months)
Sales Tax %
%
Cash Down & Fees
Down Payment
$
Trade Equity
$
Doc Fee
$
Tag & Title
$
Required Selling Price
—
to hit —/mo
Sales Tax —
Doc + Tag —
Down + Trade —
Amount Financed —
📊 Payment Grid
🚗 Units That Work at This Payment
Range:
📄
Customer Quote
Uses the rate & term set above · Add products to show per-month impact
Stock #
Customer Name
Base Payment (no products):
--
· set rate & term above
F&I Products
Price: $ adds -- /mo
Price: $ adds -- /mo
Price: $ adds -- /mo
Price: $ adds -- /mo
🏭 Taxes & Fees
% retail — applied to full price
Tax amt: --
$
$
Total Financed (with fees)
--
Payment incl. fees
--
Total Monthly Payment
No products selected
--
📈 Profit & Loss
Monthly P&L — variable gross net of chargebacks, pack & doc fee, service & parts, and operating expenses
Operating Expenses
Expense Amount
💵 Payroll
Sales Pay Plan:  $350 per unit (solo)  ·  $175 per unit (split deal)  ·  10% of Products (GAP + SVC, no Reserve)  ·  Cutoff: Funded by Sunday midnight

🔐 Admin Access

Enter your PIN to unlock admin controls

MCA Assistantpowered by Claude AI
Hi! I'm your MCA dashboard assistant. Ask me anything about your deals, inventory, or team performance.