Skip to main content
ARPISales & Gross

Sales & Gross

Granite Subaru, Granite Pre-Owned · 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

    57

    +9 units vs November 2025

    KPI-SLS-001

  • Total gross

    $192,956

    +$31,155 vs November 2025

    KPI-GRS-003

  • Total PVR

    $3,385

    +$14 per retail unit vs November 2025

    KPI-GRS-006

  • New units

    18

    +5 units vs November 2025

    KPI-SLS-002

  • Used units

    39

    +4 units vs November 2025

    KPI-SLS-003

  • Front gross

    $131,565

    +$22,294 vs November 2025

    KPI-GRS-001

  • Back gross

    $61,391

    +$8,862 vs November 2025

    KPI-GRS-002

  • Front PVR

    $2,308

    +$32 per retail unit vs November 2025

    KPI-GRS-004

  • Back PVR

    $1,077

    -$17 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 Subaru 35, Granite Pre-Owned 22. Total gross: Granite Subaru $102,305, Granite Pre-Owned $90,651. Total GPRU: Granite Subaru $2,923, Granite Pre-Owned $4,121.

  • Granite Subaru
  • Granite Pre-Owned

Retail unitsKPI-SLS-001

  • 35
  • 22

Total grossKPI-GRS-003

  • $102,305
  • $90,651

Total GPRUKPI-GRS-006

  • $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 Subaru 35, Granite Pre-Owned 22. Total gross: Granite Subaru $102,305, Granite Pre-Owned $90,651. Total GPRU: Granite Subaru $2,923, Granite Pre-Owned $4,121.
StoreRetail unitsTotal grossTotal GPRU
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 18, Used 39. Total gross: New $27,867, Used $165,089. Total GPRU: New $1,548, Used $4,233.

  • New
  • Used

Retail units

  • 18
  • 39

Total grossKPI-GRS-003

  • $27,867
  • $165,089

Total GPRUKPI-GRS-006

  • $1,548
  • $4,233

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 18, Used 39. Total gross: New $27,867, Used $165,089. Total GPRU: New $1,548, Used $4,233.
ConditionRetail unitsTotal grossTotal GPRU
New18$27,867$1,548
Used39$165,089$4,233

What the bridge attributes the change to

What changed against the month before

In December 2025, total gross increased by $31,155 against the month before. The bridge attributes +$36,159 to unit volume, -$4,834 to front PVR, -$170 to back PVR.

  • Comparison total$161,800
  • Volume effect+$36,159
  • Front PVR effect-$4,834
  • Back PVR effect-$170
  • Rounding-$0.01display only
  • Current total$192,956
Read what changed against the month before as a table
What changed against the month before. In December 2025, total gross increased by $31,155 against the month before. The bridge attributes +$36,159 to unit volume, -$4,834 to front PVR, -$170 to back PVR.
ComponentRoleAmount
Comparison totalPeriod total$161,800
Volume effectAttributed movement+$36,159
Front PVR effectAttributed movement-$4,834
Back PVR effectAttributed movement-$170
RoundingAttributed movement-$0.01 (display only)
Current totalPeriod total$192,956

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 rounding line is the residual left when each component is divided by the comparison unit count and rounded to the cent. It is shown rather than folded into a component, because adjusting one component to make a column add up would misstate that component.

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 units100.0% of target

Retail units: 57 actual against a target of 57, 100.0% of target.

57Target 57

Pace1.90 units per selling dayKPI-TGT-007

Selling-day pace projection57KPI-TGT-009

Selling-day pace projection is exactly at 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 gross103.9% of target

Total gross: $192,956 actual against a target of $185,747, 103.9% of target.

$192,956Target $185,747

Pace$6,431.86 per selling dayKPI-TGT-008

Selling-day pace projection$192,956KPI-TGT-010

Selling-day pace projection is $7,209 above 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.

57 deals across 7 bands. Median $2,450, Mean $3,385.

Read total gross per deal as a table
Total gross per deal. 57 deals across 7 bands. Median $2,450, Mean $3,385.
BandDeals
Below $00
$0 to $9998
$1,000 to $1,99915
$2,000 to $2,99911
$3,000 to $4,9998
$5,000 to $7,49911
$7,500 and above4

7 of 57 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 $131,565, Back gross $61,391.

Front gross
$131,565
Back gross
$61,391
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,587

-$121 per retail unit against November 2025

Discount from final asking

$877

-$168 per retail unit against November 2025

Discount from MSRP

$1,494

-$413 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
Lease4
Certified retail5
Wholesale6
Dealer trade1

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.