SLE-00000440
2017 Subaru Impreza Sport
Granite Subaru of Manchester · Delivered 27 October 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.
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.
Fictional transaction from the synthetic Granite Auto Group dataset. Not a real sale, customer, or dealership record.
This deal
- Sale price
- $2,660.92
- Total gross
- $1,035.32
- Front plus back
- Front gross
- -$520.99
- Vehicle
- Back gross
- $1,556.31
- Finance office, deal date
- Days in stock at sale
- 132 days
Granite Subaru of ManchesterUsedUsed RetailCashDelivered 27 October 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 $2,660.92, less acquisition cost $1,676.12, reconditioning cost $755.79, pack amount $750.00, giving front-end gross -$520.99.
Sale price$2,660.92
Acquisition cost$1,676.12
Reconditioning cost$755.79
Pack amount$750.00
Front-end gross-$520.99
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
- $381.98
- Discount from final asking price
- $175.06
- 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
- $2,660.92
- Acquisition cost
- $1,676.12
- Reconditioning cost
- $755.79
- Pack amount
- $750.00
- Front-end gross
- -$520.99
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 $0.00, Original product gross $1,556.31, giving back-end gross $1,556.31 on the deal-date basis.
- Finance reserve
- $0.00
- Original product gross
- $1,556.31
- Back-end gross
- $1,556.31
- Adjustments through 2025-12-31
- $0.00
- Retained F&I gross as of 2025-12-31
- $1,556.31
Verify this reconciliation, and the two date bases
| Finance reserve | $0.00 |
|---|---|
| + Original product gross | $1,556.31 |
| +Other F&I income | $0.00 |
| = Back-end gross | $1,556.31 |
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
- Cashderived: nothing was financed
- Cash down
- $2,660.92
- 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
- $1,556.31deal date
Nothing was financed on this deal, so no lender exists. 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
- -$520.99
- Back-end gross
- $1,556.31
- Total gross
- $1,035.32
Verified to the cent. Verified to the cent: the components above recompute the total gross exactly.
F&I products written
| Product | Category | Retail | Dealer cost | Original gross | Adjustments | Net gross | Status |
|---|---|---|---|---|---|---|---|
| Granite Shield Powertrain PlusGranite Shield Administrators · 48-month coverage | Vehicle Service ContractELIG-VSC | $3,302.61 | $1,746.30 | $1,556.31 | None | $1,556.31 | Active |
| 1 contract | $1,556.31 | $0.00 | $1,556.31 | ||||
- Granite Shield Powertrain PlusVehicle Service Contract · Granite Shield Administrators · ELIG-VSC
- Retail
- $3,302.61
- Dealer cost
- $1,746.30
- Original gross
- $1,556.31
- Adjustments
- None
- Net gross
- $1,556.31
- 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
- 2017 Subaru Impreza Sport
- Unit identifier
- VEH-0000467not a stock number
- Synthetic VIN
- ARPIZR4HYK737M3R7
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
- Hatchback
- Odometer
- Over 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
- 132 days
- Original asking price
- $3,043
- Final asking price
- $2,836
- MSRP
- Not applicable
Deal structure
- Deal
- SLE-00000440
- Sale date
- 27 October 2025
- Delivery date
- 27 October 2025
- Store
- Granite Subaru of Manchester GSA-002
- 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
- Used Retail
- Finance structure
- Cashderived: nothing was financed
Who worked the transaction
- Salesperson
- EMP-00016Salesperson
- Desk manager
- EMP-00013General Manager
- Finance manager
- EMP-00017Finance Manager
- BDC
- EMP-00019
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: Paid Social Feed Campaign
- Lead created7 September 2025
- First response110.7 minutes
- ContactedYes
- Appointment setYes
- Appointment date8 September 2025
- ShowedYes
- Showed on8 September 2025
- Test driveYes
- Write-upYes
- Sale27 October 2025
- Delivery27 October 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 118 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.