Skip to main content
ARPISales & Gross

Sales & Gross

All three stores · August 2025 · vs July 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

August 2025

  • Retail units

    116

    +13 units vs July 2025

    KPI-SLS-001

  • Total gross

    $353,812

    -$4,276 vs July 2025

    KPI-GRS-003

  • Total PVR

    $3,050

    -$426 per retail unit vs July 2025

    KPI-GRS-006

  • New units

    45

    +12 units vs July 2025

    KPI-SLS-002

  • Used units

    71

    +1 units vs July 2025

    KPI-SLS-003

  • Front gross

    $226,505

    -$9,295 vs July 2025

    KPI-GRS-001

  • Back gross

    $127,307

    +$5,019 vs July 2025

    KPI-GRS-002

  • Front PVR

    $1,953

    -$337 per retail unit vs July 2025

    KPI-GRS-004

  • Back PVR

    $1,097

    -$90 per retail unit vs July 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

July 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 45, Granite Subaru 41, Granite Pre-Owned 30. Total gross: Granite Chevrolet $157,067, Granite Subaru $98,767, Granite Pre-Owned $97,978. Total GPRU: Granite Chevrolet $3,490, Granite Subaru $2,409, Granite Pre-Owned $3,266.

  • Granite Chevrolet
  • Granite Subaru
  • Granite Pre-Owned

Retail unitsKPI-SLS-001

  • 45
  • 41
  • 30

Total grossKPI-GRS-003

  • $157,067
  • $98,767
  • $97,978

Total GPRUKPI-GRS-006

  • $3,490
  • $2,409
  • $3,266

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 45, Granite Subaru 41, Granite Pre-Owned 30. Total gross: Granite Chevrolet $157,067, Granite Subaru $98,767, Granite Pre-Owned $97,978. Total GPRU: Granite Chevrolet $3,490, Granite Subaru $2,409, Granite Pre-Owned $3,266.
StoreRetail unitsTotal grossTotal GPRU
Granite Chevrolet45$157,067$3,490
Granite Subaru41$98,767$2,409
Granite Pre-Owned30$97,978$3,266

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 45, Used 71. Total gross: New $71,434, Used $282,378. Total GPRU: New $1,587, Used $3,977.

  • New
  • Used

Retail units

  • 45
  • 71

Total grossKPI-GRS-003

  • $71,434
  • $282,378

Total GPRUKPI-GRS-006

  • $1,587
  • $3,977

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 45, Used 71. Total gross: New $71,434, Used $282,378. Total GPRU: New $1,587, Used $3,977.
ConditionRetail unitsTotal grossTotal GPRU
New45$71,434$1,587
Used71$282,378$3,977

What the bridge attributes the change to

What changed against the month before

In August 2025, total gross decreased by $4,276 against the month before. The bridge attributes +$46,524 to unit volume, -$40,267 to front PVR, -$10,533 to back PVR.

  • Comparison total$358,088
  • Volume effect+$46,524
  • Front PVR effect-$40,267
  • Back PVR effect-$10,533
  • Rounding$0.02display only
  • Current total$353,812
Read what changed against the month before as a table
What changed against the month before. In August 2025, total gross decreased by $4,276 against the month before. The bridge attributes +$46,524 to unit volume, -$40,267 to front PVR, -$10,533 to back PVR.
ComponentRoleAmount
Comparison totalPeriod total$358,088
Volume effectAttributed movement+$46,524
Front PVR effectAttributed movement-$40,267
Back PVR effectAttributed movement-$10,533
RoundingAttributed movement$0.02 (display only)
Current totalPeriod total$353,812

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 31 of 31Month 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 units104.5% of target

Retail units: 116 actual against a target of 111, 104.5% of target.

116Target 111

Pace3.74 units per selling dayKPI-TGT-007

Selling-day pace projection116KPI-TGT-009

Selling-day pace projection is 5 above 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 gross94.5% of target

Total gross: $353,812 actual against a target of $374,442, 94.5% of target.

$353,812Target $374,442

Pace$11,413.29 per selling dayKPI-TGT-008

Selling-day pace projection$353,812KPI-TGT-010

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

116 deals across 7 bands. Median $2,580, Mean $3,050.

Read total gross per deal as a table
Total gross per deal. 116 deals across 7 bands. Median $2,580, Mean $3,050.
BandDeals
Below $06
$0 to $99915
$1,000 to $1,99923
$2,000 to $2,99923
$3,000 to $4,99930
$5,000 to $7,49912
$7,500 and above7

20 of 116 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 $226,505, Back gross $127,307.

Front gross
$226,505
Back gross
$127,307
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,622

+$117 per retail unit against July 2025

Discount from final asking

$1,172

+$179 per retail unit against July 2025

Discount from MSRP

$2,067

+$409 per retail unit against July 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 retail15
Wholesale14
Dealer trade6

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.