SLE-00000617

2024 Chevrolet Silverado EV RST

Granite Chevrolet of Nashua · Delivered 23 December 2025 · All checks passed

Granite Auto Group is fictional. Operating figures are synthetic.· data and methodology

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

Fictional transaction from the synthetic Granite Auto Group dataset. Not a real sale, customer, or dealership record.

This deal

Sale price: $46,318.71
Total gross: $3,334.92; Front plus back
Front gross: $2,600.18; Vehicle
Back gross: $734.74; Finance office, deal date
Days in stock at sale: 34 days

Granite Chevrolet of NashuaNewNew RetailRetail FinanceDelivered 23 December 2025

Vehicle economics

Where the front gross came from

Sale price, the three costs taken out of it, and what is left. Each length is that amount's share of the sale price.

Sale price$46,318.71
Acquisition cost$42,773.53
Reconditioning cost$150.00
Pack amount$795.00
Front-end gross$2,600.18

Discount from original asking price: $1,778.52
Discount from final asking price: $1,345.64
Discount from MSRP: $1,750.02

Verify this calculation, and what the figure excludes

Sale price: $46,318.71
Acquisition cost: $42,773.53
Reconditioning cost: $150.00
Pack amount: $795.00
Front-end gross: $2,600.18

Verified to the cent. Verified to the cent: the components above recompute the front-end gross exactly.

Front-end gross is the ARPI definition of KPI-GRS-001: selling price less what the unit cost to acquire, recondition and pack. Trade variance is not part of it and is shown separately below, because folding it in would change what the KPI means.

Manufacturer holdback, dealer cash, stair-step money, floorplan credits and unposted accounting adjustments are all excluded by the model. They arrive on a different cadence than the deal and are not attributable to a single vehicle at the time of sale, so including them would make this figure disagree with the deal jacket a manager reads. ARPI does not model any of them, and nothing here implies it does.

Finance office economics

What the finance office made

Finance reserve and original product gross, as shares of this deal's back-end gross. Deal-date basis.

Finance reserve: $288.54
Original product gross: $446.20
Back-end gross: $734.74

Adjustments through 2025-12-31: $0.00
Retained F&I gross as of 2025-12-31: $734.74

Verify this reconciliation, and the two date bases

Deal-date back-end gross, decomposed into finance reserve and product gross
Finance reserve	$288.54
+ Original product gross	$446.20
+Other F&I income	$0.00
= Back-end gross	$734.74

Reconciled to the cent: finance reserve plus original product gross equals this deal’s back-end gross exactly, with other F&I income of $0.00 and no balancing figure. Recomputed here from the components above rather than read from a stored flag.

Back-end gross is the deal-date figure and is never rewritten when an adjustment posts later. Retained F&I gross answers a different question — what the store still has as of 2025-12-31 — and a difference between the two is expected wherever adjustments posted, not an error in either. The identity above uses ORIGINAL product gross for exactly that reason: substituting the retained figure would make the check fail on every adjusted deal and report correct behaviour as a defect.

Trade

Trade allowance: $9,927.90
Trade actual cash value: $9,818.41
Trade variance: $109.49allowance above ACV

Payoff: Not modelled
Equity: Not modelled
Trade vehicle and disposition: Not modelled

Trade variance is allowance less actual cash value. It is shown here and is deliberately not part of the front-gross formula above. Payoff, equity and the trade vehicle itself need trade detail the model does not carry; they are named as not modelled rather than shown as zero.

How the deal was funded

Structure: Retail Financederived: an amount was financed
Cash down: $1,055.35
Amount financed: $35,335.46
Finance reserve: $288.54an amount, not a rate
Lender: Harborline BankLND-005
Lender category: Bank
Lender program tier: Near-primeclassifies the lender’s program, not the customer
Back-end gross: $734.74deal date

APR, term, payment, buy rate, sell rate, rate spread: Not modelledNot modelled, and deliberately out of scope permanently. PRIVACY_AND_ETHICS.md §7 places rate mechanics outside what this project publishes: ARPI approves nothing, prices nothing and recommends no lender.

Total gross

Front-end gross: $2,600.18
Back-end gross: $734.74
Total gross: $3,334.92

Verified to the cent. Verified to the cent: the components above recompute the total gross exactly.

F&I products written

F&I product contracts written on this deal, with original and retained gross
Product	Category	Retail	Dealer cost	Original gross	Adjustments	Net gross	Status
Granite Shield Powertrain PlusGranite Shield Administrators · 72-month coverage	Vehicle Service ContractELIG-VSC	$684.67	$365.96	$318.71	None	$318.71	Active
Northbridge Deficiency WaiverNorthbridge Protection Services · 48-month coverage	GAPELIG-GAP	$189.35	$61.86	$127.49	None	$127.49	Active
2 contracts				$446.20	$0.00	$446.20

Granite Shield Powertrain PlusVehicle Service Contract · Granite Shield Administrators · ELIG-VSC
Retail
$684.67
Dealer cost
$365.96
Original gross
$318.71
Adjustments
None
Net gross
$318.71
Status
Active
Northbridge Deficiency WaiverGAP · Northbridge Protection Services · ELIG-GAP
Retail
$189.35
Dealer cost
$61.86
Original gross
$127.49
Adjustments
None
Net gross
$127.49
Status
Active

Original gross is what the contract was written for, on the day of the deal. Net gross is what remained as at 2025-12-31after every adjustment posted on or before that date. Status is derived from each contract’s own event history and never from today’s date. Every product and administrator named here is fictional, and every price is synthetic.

The unit that was sold

The odometer is banded and the VIN-style identifier is synthetic.

Vehicle: 2024 Chevrolet Silverado EV RST
Unit identifier: VEH-0000843not a stock number
Synthetic VIN: ARPI0X7ZT59U8GSHL
What this identifier is
A machine-generated VIN-style identifier belonging to no real vehicle (ADR-0005). It is the right length and shape for a VIN so that the data behaves like the real thing, and it decodes to nothing.
Condition: New
Body style: Pickup
Odometer: Newbanded, never exact
Inventory source: Manufacturer Allocation
Acquisition date: Not modelledthe model records none; days in stock is what exists
Days in inventory at sale: 34 days
Original asking price: $48,097
Final asking price: $47,664
MSRP: $48,069

Deal structure

Deal: SLE-00000617
Sale date: 23 December 2025
Delivery date: 23 December 2025
Store: Granite Chevrolet of Nashua GSA-001
Deal status: Finalized
Why only finalized deals appear
A canceled or unwound deal is not a sale, and counting one would overstate every volume and gross measure downstream. The warehouse’s transaction fact holds finalized deals only, so there is no canceled deal for this route to show: the absence is the data model working, not a filter applied here.
Sale type: New Retail
Finance structure: Retail Financederived: an amount was financed

Who worked the transaction

Salesperson: EMP-00012Salesperson
Desk manager: EMP-00001General Manager
Finance manager: EMP-00005Finance Manager
BDC: Unattributed

Synthetic employee identifiers only. No name exists anywhere in ARPI, for any employee, by design: a fabricated name invites confusion with real staff and adds nothing to any measure. “Unattributed” means the role could have been filled and was not; “Not applicable” means this deal type has no such role.

How the deal arrived

Source: Showroom Walk-in

Lead created21 September 2025
First response25.0 minutes
ContactedYes
Appointment setNo
Sale23 December 2025
Delivery23 December 2025

Stages come from the lead and appointment facts. No message, note, email, phone number or free-form CRM text appears here, because none exists in the model: it records that a lead was contacted, not what was said.

What this page checked before showing you the figures

Front-gross identitypassedSale price less acquisition, reconditioning and pack equals the published front-end gross, to the cent.
Total-gross identitypassedFront-end gross plus back-end gross equals the published total gross, to the cent.
Back-gross reconciliationpassedFinance reserve plus original product gross equals the published back-end gross, to the cent, with other F&I income of $0.00.
F&I product eligibilitypassedEvery contract on this deal names the governed eligibility rule its category resolves to, and was written on a retail structure a product can attach to. The rule itself is evaluated once in the governed layer by DQ-FPS-011 and RECON-FI-ELIGIBILITY; this page checks that the evidence travelled with the row rather than re-implementing the predicate.
Product adjustment validitypassedEvery contract's net gross recomputes from its own original gross less its own cumulative adjustments, and none has been reduced below zero or above what it was written for.
Delivery date validitypassedThe vehicle was delivered on or after the date the deal was finalized.
Sale-to-inventory relationshippassedThe unit appears in 34 inventory snapshots before it sold.
Source lineagepassedPublished figures for one delivery, as of 31 December 2025. The version and contract this was read from are in the methodology disclosure at the top of the page.

All checks passed. Eight checks, and every one of them recomputes something from the figures on this page rather than reading a stored flag. Back-gross reconciliation, product eligibility and product-adjustment validity were named as absent through DASH.4because the F&I model had no surface here; they are real now, and each can fail.

Where these figures came from

Where every figure on this page came from

Source reporting view: reporting.vw_deal_jacket
Source grain: One row per finalized vehicle transaction
Date basis: Sale date
Export dataset: deal-jacket
Dataset version: 17
Contract fingerprint: 4b77a5bf9322
Data as of: 2025-12-31
KPIs this deal feeds: KPI-SLS-001, KPI-GRS-001, KPI-GRS-002, KPI-GRS-003, KPI-INV-007, KPI-FNI-001, KPI-FNI-003, KPI-FNI-004, KPI-FNI-011

Known limitations

Synthetic data. Granite Auto Group and every store, employee role and transaction referenced here are fictional.
Front-end gross EXCLUDES manufacturer holdback, dealer cash, stair-step money, floorplan credits and unposted accounting adjustments. None is modelled, and none is implied.
Back-end gross is on the DEAL-DATE basis and is never rewritten when a cancellation or chargeback posts later. Retained F&I gross answers a different question and is shown separately.
Every F&I product, administrator and lender is fictional, and every product price and cost is synthetic. No figure here is a market price or an industry benchmark.
No APR, term, payment, buy rate, sell rate or rate spread exists anywhere in this project. Finance reserve is an amount, never a rate.
A product contract term is the COVERAGE term and is never a loan term.
The odometer reading is banded, never exact.
Trade payoff and equity are not modelled: no trade fact exists.
The lender is a fictional finance source recorded as an assignment only. No credit application, decision, tier, stipulation or adverse-action record exists in ARPI, and none is implied by a lender appearing here.
The vehicle identifier is not a stock number. The model contains none.

Return to the Deal Explorer to find another transaction, or open Sales and gross for the aggregate this deal is part of. Data as of 31 December 2025.