Skip to main content
ARPISales & Gross

Sales & Gross

All three stores · December 2025 · vs November 2025

Granite Auto Group is fictional. Operating figures are synthetic.

Every warehouse record in this project is synthetic. Granite Auto Group and its three stores are fictional. No real dealership, customer, employee or lending data exists anywhere in the project.

Dataset v17 · developmentAs of 31 December 2025Real-engine validation pending

Real-engine validation pending. Neither accepted ADR-0008 path has recorded a result, so nothing on this page may be read as evidence that the Power BI semantic model has been validated. This console renders exported SQL figures; rendering a number in HTML proves nothing about a DAX measure.

The evidence behind both statements

How this is built, governed and validated

FiltersReset filters
Filters and controls1 applied

New and Used select the exported condition split of units and gross.

Result

December 2025

  • Retail units

    92

    +13 units vs November 2025

    KPI-SLS-001

  • Total gross

    $321,935

    +$32,545 vs November 2025

    KPI-GRS-003

  • Total PVR

    $3,499

    -$164 per retail unit vs November 2025

    KPI-GRS-006

  • New units

    40

    +15 units vs November 2025

    KPI-SLS-002

  • Used units

    52

    -2 units vs November 2025

    KPI-SLS-003

  • Front gross

    $213,657

    +$19,216 vs November 2025

    KPI-GRS-001

  • Back gross

    $108,277

    +$13,329 vs November 2025

    KPI-GRS-002

  • Front PVR

    $2,322

    -$139 per retail unit vs November 2025

    KPI-GRS-004

  • Back PVR

    $1,177

    -$25 per retail unit vs November 2025

    KPI-GRS-005

How every figure on this rail is measured

Retail units

KPI-SLS-001

The count of finalized retail and lease deliveries in the period. Wholesale disposals and dealer trades are not retail units and are never counted here.

SUM(unit_count) WHERE is_retail = true

Total gross

KPI-GRS-003

Front-end gross plus back-end gross on finalized retail deliveries.

front-end gross + back-end gross

Total PVR

KPI-GRS-006

Average total profit, vehicle plus finance office, earned on each retail unit delivered in the period.

total retail gross / retail units sold

New units

KPI-SLS-002

The count of finalized retail and lease deliveries of new vehicles in the period.

SUM(unit_count) WHERE is_retail = true AND the vehicle's condition is New

Used units

KPI-SLS-003

The count of finalized retail and lease deliveries of used vehicles, including manufacturer-certified pre-owned units, in the period.

SUM(unit_count) WHERE is_retail = true AND the vehicle's condition is Used or Certified

Front gross

KPI-GRS-001

Total vehicle profit on finalized retail deliveries: selling price less what the unit cost to acquire, recondition, and pack.

SUM(final sale price - acquisition cost - reconditioning cost - pack amount)

Back gross

KPI-GRS-002

The sum of net finance reserve and net F&I product gross on finalized retail deliveries.

SUM(net finance reserve + net F&I product gross)

Front PVR

KPI-GRS-004

Average vehicle profit earned on each retail unit delivered in the period.

total retail front-end gross / retail units sold

Back PVR

KPI-GRS-005

Average finance and insurance profit earned on each retail unit delivered in the period.

total retail back-end gross / retail units sold

How the period accumulated

One column per sale date
Trend measure

November 2025 is shown as a difference on the rail above rather than as a second series here: two overlaid shapes invite a reader to compare outlines when the figure that matters is the difference.

Stores

Store contribution

Each measure is scaled to its own largest store. Lengths compare within a measure and never across two.

Retail units: Granite Chevrolet 35, Granite Subaru 35, Granite Pre-Owned 22. Total gross: Granite Chevrolet $128,979, Granite Subaru $102,305, Granite Pre-Owned $90,651. Total GPRU: Granite Chevrolet $3,685, Granite Subaru $2,923, Granite Pre-Owned $4,121.

  • Granite Chevrolet
  • Granite Subaru
  • Granite Pre-Owned

Retail unitsKPI-SLS-001

  • 35
  • 35
  • 22

Total grossKPI-GRS-003

  • $128,979
  • $102,305
  • $90,651

Total GPRUKPI-GRS-006

  • $3,685
  • $2,923
  • $4,121

Business-code order. Nothing is ranked and no store score exists: the three run different operating models.

Read store contribution as a table
Store contribution. Retail units: Granite Chevrolet 35, Granite Subaru 35, Granite Pre-Owned 22. Total gross: Granite Chevrolet $128,979, Granite Subaru $102,305, Granite Pre-Owned $90,651. Total GPRU: Granite Chevrolet $3,685, Granite Subaru $2,923, Granite Pre-Owned $4,121.
StoreRetail unitsTotal grossTotal GPRU
Granite Chevrolet35$128,979$3,685
Granite Subaru35$102,305$2,923
Granite Pre-Owned22$90,651$4,121

New and used

Condition contribution

Each measure is scaled to its own larger side. Lengths compare within a measure and never across two.

Retail units: New 40, Used 52. Total gross: New $85,091, Used $236,843. Total GPRU: New $2,127, Used $4,555.

  • New
  • Used

Retail units

  • 40
  • 52

Total grossKPI-GRS-003

  • $85,091
  • $236,843

Total GPRUKPI-GRS-006

  • $2,127
  • $4,555

A certified pre-owned unit is Used, which is the split the export publishes. The certified retail unit count is in the sale-type detail below and is already inside the retail count.

Read condition contribution as a table
Condition contribution. Retail units: New 40, Used 52. Total gross: New $85,091, Used $236,843. Total GPRU: New $2,127, Used $4,555.
ConditionRetail unitsTotal grossTotal GPRU
New40$85,091$2,127
Used52$236,843$4,555

What the bridge attributes the change to

What changed against the month before

In December 2025, total gross increased by $32,545 against the month before. The bridge attributes +$52,622 to unit volume, -$18,901 to front PVR, -$1,176 to back PVR.

  • Comparison total$289,390
  • Volume effect+$52,622
  • Front PVR effect-$18,901
  • Back PVR effect-$1,176
  • Current total$321,935
Read what changed against the month before as a table
What changed against the month before. In December 2025, total gross increased by $32,545 against the month before. The bridge attributes +$52,622 to unit volume, -$18,901 to front PVR, -$1,176 to back PVR.
ComponentRoleAmount
Comparison totalPeriod total$289,390
Volume effectAttributed movement+$52,622
Front PVR effectAttributed movement-$18,901
Back PVR effectAttributed movement-$1,176
Current totalPeriod total$321,935

Verified: the exported component numerators sum exactly to the comparison unit count multiplied by the period change, with no division on either side of the identity.

The bridge attributes change under a documented arithmetic order: volume priced at the comparison period rate, then each rate change valued at the current period volume. It is an attribution, not a cause. Nothing here identifies why volume or rate moved, and no person, department, inventory position or marketing spend is implicated by it.

Plan and pace

The projection is selling-day arithmetic, not a forecast. Targets are synthetic operating goals, not benchmarks. A monthly plan is a single-month figure, so it is a reference beside the totals rather than a flat line drawn onto the trend.

Selling day 30 of 30Month complete, so attainment is final and the selling-day pace projection equals the actual.KPI-TGT-005 · KPI-TGT-006

Retail units against plan

Retail units94.8% of target

Retail units: 92 actual against a target of 97, 94.8% of target.

92Target 97

Pace3.07 units per selling dayKPI-TGT-007

Selling-day pace projection92KPI-TGT-009

Selling-day pace projection is 5 below target.

How retail units against plan is measured
  • Target (KPI-TGT-001): the sum of store-scope plan rows for the selected stores and months. Department rows exist in the same governed dataset and are refinements of the store plan, never addends.
  • Attainment (KPI-TGT-002): summed actual divided by summed target, over the same stores on both sides. It is never the average of store percentages, and a store with no plan contributes to neither side.
  • Pace (KPI-TGT-007): actual divided by governed selling days elapsed, counted from the governed date dimension’s selling-day flag and shared by all three stores.
  • Selling-day pace projection (KPI-TGT-009): pace multiplied by the month’s selling days. It is linear arithmetic over the calendar — not a forecast, not a prediction and not a statistical model — and it ignores the within-month shape of trading, so an early-month figure moves more than a late-month one.
KPI_CATALOG.mdsection 39 — KPI-TGT-001, KPI-TGT-002, KPI-TGT-007, KPI-TGT-009View KPI_CATALOG.md (section 39 — KPI-TGT-001, KPI-TGT-002, KPI-TGT-007, KPI-TGT-009) on GitHub (opens in a new tab)

Total gross against plan

Total gross95.0% of target

Total gross: $321,935 actual against a target of $338,844, 95.0% of target.

$321,935Target $338,844

Pace$10,731.15 per selling dayKPI-TGT-008

Selling-day pace projection$321,935KPI-TGT-010

Selling-day pace projection is $16,909 below target.

How total gross against plan is measured
  • Target (KPI-TGT-003): the sum of store-scope plan rows for the selected stores and months. Department rows exist in the same governed dataset and are refinements of the store plan, never addends.
  • Attainment (KPI-TGT-004): summed actual divided by summed target, over the same stores on both sides. It is never the average of store percentages, and a store with no plan contributes to neither side.
  • Pace (KPI-TGT-008): actual divided by governed selling days elapsed, counted from the governed date dimension’s selling-day flag and shared by all three stores.
  • Selling-day pace projection (KPI-TGT-010): pace multiplied by the month’s selling days. It is linear arithmetic over the calendar — not a forecast, not a prediction and not a statistical model — and it ignores the within-month shape of trading, so an early-month figure moves more than a late-month one.
KPI_CATALOG.mdsection 39 — KPI-TGT-003, KPI-TGT-004, KPI-TGT-008, KPI-TGT-010View KPI_CATALOG.md (section 39 — KPI-TGT-003, KPI-TGT-004, KPI-TGT-008, KPI-TGT-010) on GitHub (opens in a new tab)

Targets are synthetic internal operating goals for the fictional Granite Auto Group. They are not industry benchmarks, manufacturer objectives or any real dealership’s plan.

The shape of the deal population

Open these deals

Deal gross has a long tail, so the mean sits above the typical deal. Median and mean are shown together because either alone invites the wrong conclusion.

Total gross per deal

Every retail transaction in scope, counted into bands by its own total gross.

92 deals across 7 bands. Median $2,637, Mean $3,499.

Read total gross per deal as a table
Total gross per deal. 92 deals across 7 bands. Median $2,637, Mean $3,499.
BandDeals
Below $00
$0 to $99910
$1,000 to $1,99921
$2,000 to $2,99920
$3,000 to $4,99918
$5,000 to $7,49915
$7,500 and above8

10 of 92 deals in scope closed at a front-end loss. A negative front is a real dealership outcome: it is counted, shown with its sign, and never suppressed.

The median is computed from the deal-level values themselves, never from store medians: an order statistic cannot be recomputed from an aggregate. The mean over a retail population is total gross divided by retail units, which is KPI-GRS-006 by definition, so it is the same figure the performance summary shows.

Gross composition

Front and back

The finance office's contribution beside the vehicle's, as a share of the governed total.

Front gross $213,657, Back gross $108,277.

Front gross
$213,657
Back gross
$108,277
How to read this

Front and back are published separately and are not ranked against each other. A store can hold total gross steady while front collapses and the finance office compensates, and that is a materially different situation from one where both are stable: which is preferable depends on the store, not on the figure.

Discount taken, per unit

The MSRP discount divides by the units that actually carry an MSRP, which is fewer than the retail count.

Discount from original asking

$1,710

-$57 per retail unit against November 2025

Discount from final asking

$1,074

-$81 per retail unit against November 2025

Discount from MSRP

$1,550

-$504 per retail unit against November 2025

Detail, on demand

Units by sale type

Unit counts only. The export publishes no per-sale-type gross, and apportioning the retail total across sale types would invent a measure the reporting layer does not own.

By sale type
Sale typeUnits
Lease13
Certified retail7
Wholesale10
Dealer trade4

Unit counts only. The export publishes no per-sale-type gross, and apportioning the retail total across sale types would invent a measure the reporting layer does not own. Lease and certified retail units are already inside the retail count; wholesale and dealer trades are not.

Every figure on this page is the sum of finalized transactions. To see the transactions themselves, open the Deal Explorer, which carries this period and store selection.