Skip to main content
ARPIEmployees

Employees

All three stores · October 2025 · Finance view

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

Filters and controls1 applied

Lead mix and funnel only.

This role family

Finance · October 2025

People credited

3

Finance

Retail units

77

Credited to these people in this period

Comparison-eligible on the leading figure

3 of 3

Minimum sample 10 · everyone in this family clears it

Retail deliveries with this person on the F&I desk, the finance structure of them, and the income earned.

The floor is a publication discipline, not a performance threshold: below it this page declines to print a comparative ratio and says nothing whatever about the person. It applies to each measure’s own denominator, so someone can be eligible on one figure and not on another in the same period.

The people

Business-key order

Credited activity, by person

Store, then role, then employee code. That order is fixed and there is no control to change it: a list sorted by a measure is a leaderboard whether or not it is labelled one. Both figures divide by every retail delivery, including cash deals, which cannot generate reserve. The structure mix is beside them for that reason.

3 people in the Finance family, each with their credited volume, the measures their role is governed by, the sample behind each one, and the mix and opportunity around it.

  • EMP-00005Finance ManagerStore GSA-001Tenure 5-10 Years33 retail units
    Back gross per retail unit$1,484n 33 retail units
    Reserve per retail unit$375n 33 retail units
    Finance structureCash 6 (18.2%) · Retail finance 21 (63.6%) · Lease 6 (18.2%)
    Deliveries carrying a product 31 of 33Product contracts written 72
  • EMP-00017Finance ManagerStore GSA-002Tenure 5-10 Years29 retail units
    Back gross per retail unit$1,297n 29 retail units
    Reserve per retail unit$293n 29 retail units
    Finance structureCash 11 (37.9%) · Retail finance 16 (55.2%) · Lease 2 (6.9%)
    Deliveries carrying a product 27 of 29Product contracts written 43
  • EMP-00028Finance ManagerStore GSA-003Tenure 5-10 Years15 retail units
    Back gross per retail unit$1,051n 15 retail units
    Reserve per retail unit$170n 15 retail units
    Finance structureCash 8 (53.3%) · Retail finance 7 (46.7%) · Lease 0 (0.0%)
    Deliveries carrying a product 15 of 15Product contracts written 21

What the stores had to work with

Average active units, by store

An average over the snapshot days observed in the period: a stock count summed across days overstates by roughly the number of days. Availability, not difficulty.

GSA-001 89.2 average active units over 31 observed snapshot days. GSA-002 97.2 average active units over 31 observed snapshot days. GSA-003 64.9 average active units over 31 observed snapshot days

  • GSA-00189.2

    31 observed snapshot days
  • GSA-00297.2

    31 observed snapshot days
  • GSA-00364.9

    31 observed snapshot days

Store context, not an employee measure. It is not on any employee row and cannot be summed across people.

Activity credited to nobody

Real transactions and real opportunity with no employee credited. Inside every store total, outside the comparison above, and never given an invented employee code.

Deliveries with nobody on the F&I desk
3Real retail deliveries with no finance manager credited. Inside the store total, outside the comparison above.

How to read these figures

The context that changes interpretation is on the rows above. What is behind this disclosure is how the arithmetic was done.

How to read employee metrics

Every ratio is a ratio of sums. Gross per retail unit is total gross divided by total retail units at the grain being reported — never an average of daily figures, per-person figures or store figures, which are different numbers and all of them wrong.

Each figure has its own sample, and its own floor verdict. Gross per unit is governed by retail units; contact rate by valid assigned leads; appointment-set rate by contacted leads, never by all valid ones; show rate by eligible appointments on the scheduled date; show-to-sale by appointments shown on the show date. One person can be comparison-eligible on one figure and not on another in the same period, and the page says so per figure.

Four absences, four statements. “Not applicable” means the measure does not belong to the role. “Insufficient sample” means it does and the denominator is below the floor. “No data” means it does and nothing was observed. A zero is a real observed value and is none of those three.

History keeps its own store and title. Every row’s role, store and tenure band are the values that were true when the activity happened, taken from the employee version the transaction points at. A transfer or a promotion later does not move earlier activity to the new store or relabel it with the new title.

Certified units are used units. The certified count shown beside a mix is a subset of the used count, not a third category, and adding it to used would double count.

Cash deals are inside the finance denominators. Reserve and back gross per retail unit divide by every retail delivery, including cash deals, which cannot generate reserve. A different cash mix moves both figures for reasons unrelated to the finance office, which is why the structure mix is drawn beside them on the row.

Appointments and leads are different populations. One lead can produce several appointments, so the lead-grain rates and the appointment-grain rates do not share a denominator, and the BDC row draws them as two separate bands for that reason. Show rate is on the scheduled date and excludes appointments cancelled in advance — an exclusion a store can game, which is why the cancellation count is on the row beside it. Show-to-sale is on the show date, so period-to-date conversion improves as the data matures.

A response time nobody answered is not a fast one. A never-responded lead has no response value at all and is excluded from the median rather than counted as zero seconds. The count of leads never answered is on the row beside the median, because the statistic is blind to them.

Lead-source mix is context, not a score. This project publishes no lead-quality ranking, difficulty index or source weighting, and none is derivable here. The mix is shown because comparing two people’s contact rates without it compares two different jobs.

Nothing here is causal. A figure is credited to a person, observed for them, or on transactions they handled. The model records associations between people and outcomes; it does not isolate an individual effect, and no figure on this page supports a statement about individual skill.

Every person on this page is invented, and so is every number. The codes identify fictional employees in a synthetic dataset. No name, contact detail, hire date, termination date, exact tenure, age, pay, commission or protected attribute exists anywhere in the governed export this page reads, and no figure here is comparable to any published market figure.