SLE-00000176

2017 Chevrolet Camaro 1LT

Granite Chevrolet of Nashua · Delivered 12 August 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: $4,126.42
Total gross: -$1,304.22; Front plus back
Front gross: -$1,304.22; Vehicle
Back gross: $0.00; Finance office, deal date
Days in stock at sale: 60 days

Granite Chevrolet of NashuaUsedWholesalenot a retail unitWholesaleDelivered 12 August 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$4,126.42
Acquisition cost$3,425.11
Reconditioning cost$1,210.53
Pack amount$795.00
Front-end gross-$1,304.22

The costs on this deal exceed its sale price, so the front gross is a signed amount rather than a remaining share and no lengths are drawn. A negative front is a real dealership outcome: it is shown with its sign and never suppressed.

Discount from original asking price: $2,063.22
Discount from final asking price: $1,852.77
Discount from MSRP: Not applicableNot applicable: this unit carries no MSRP, and one is not inferred.

Verify this calculation, and what the figure excludes

Sale price: $4,126.42
Acquisition cost: $3,425.11
Reconditioning cost: $1,210.53
Pack amount: $795.00
Front-end gross: -$1,304.22

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.

This deal’s back-end gross is zero or a component is negative, so no share is defined. The amounts below carry their signs.

Finance reserve: $0.00
Original product gross: $0.00
Back-end gross: $0.00

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

Verify this reconciliation, and the two date bases

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

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

Not applicable: no trade on this deal.

How the deal was funded

Structure: Wholesalederived: a wholesale disposal: no consumer, so no retail structure
Cash down: $0.00
Amount financed: $0.00
Finance reserve: $0.00an amount, not a rate
Lender: Not applicable
Lender category: Not applicable
Lender program tier: Not applicable
Back-end gross: $0.00deal date

A wholesale or dealer-trade disposal has no consumer, so it carries no lender. Every lender in ARPI is fictional; no real institution is named anywhere in this project.

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: -$1,304.22
Back-end gross: $0.00
Total gross: -$1,304.22

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

F&I products written

No F&I product was written on this deal. That is a real and common outcome — a delivery that carried nothing — and not missing data. The deal’s back-end gross is finance reserve alone.

The unit that was sold

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

Vehicle: 2017 Chevrolet Camaro 1LT
Unit identifier: VEH-0000864not a stock number
Synthetic VIN: ARPIWLAWMNR8V7N2L
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: Used
Body style: Coupe
Odometer: 60k-100kbanded, never exact
Inventory source: Customer Trade
Acquisition date: Not modelledthe model records none; days in stock is what exists
Days in inventory at sale: 60 days
Original asking price: $6,190
Final asking price: $5,979
MSRP: Not applicable

Deal structure

Deal: SLE-00000176
Sale date: 12 August 2025
Delivery date: 12 August 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: Wholesalenot a retail unit
Finance structure: Wholesalederived: a wholesale disposal: no consumer, so no retail structure

Who worked the transaction

Salesperson: EMP-00003Salesperson
Desk manager: EMP-00008Desk Manager
Finance manager: Not applicable
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

No linked lead: walk-in or unattributed. This is a real outcome, not missing data. A deal with no CRM lead behind it is business the store earned without one.

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 eligibilitypassedNo product was written on this deal, so there is no eligibility to check. Recorded as passed rather than hidden, because an absent check reads exactly like a passing one.
Product adjustment validitypassedNo product was written on this deal, so no adjustment can exist against one.
Delivery date validitypassedThe vehicle was delivered on or after the date the deal was finalized.
Sale-to-inventory relationshippassedThe unit appears in 42 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

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.