Skip to main content
ARPIActions

Management Actions

Deterministic review prompts backed by the same governed data as the operating console.

Granite Pre-Owned · 47 open review prompts

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

What an action is, and what it is not

Each prompt below exists because a condition written down in advance holds in this dataset version. It is a reason to look, not a finding, a recommendation of business action, or evidence of a real-world condition.

Nothing here claims a cause. A rule states that a condition holds and shows the exported values that made it hold; why it holds is what the drill-through is for.

The queue is stateless. It is rebuilt from the data every time the export is regenerated, so it holds no history and carries no acknowledgement, assignment, completion or due date. Reloading this page reconstructs the same queue; nothing remembers what was clicked.

No language model, learned model or scoring heuristic takes any part in producing it. Every word of every prompt comes from a rule template and every number from an exported column, so any action can be recomputed by hand from files in the repository.

12 of 30 permanent rules are enabled. The other 18 are retained and switched off, each with the audited reason the project cannot evaluate it honestly — the evidence is absent, it exists only at a different grain, or the condition is one an earlier data-quality gate already prevents.

Every threshold this register owns is a project default for a fictional dealer group. None is an industry benchmark, an OEM standard, a best practice or a compliance requirement.

The review queue

Ruleset 911c6bd4a226
8of 47 open review prompts shownClear all filters

Counts are of the whole queue, so selecting one facet does not renumber the others. Open means present in the data this console is serving, as of 31 December 2025: the queue is rebuilt whenever that data is and holds no workflow state, so nothing here is assigned, acknowledged, completed or overdue.

What the gross change decomposes into

Total gross change, December 2025

In December 2025, total gross increased by $16,019 against the month before. The bridge attributes +$27,987 to unit volume, -$15,822 to front PVR, +$3,854 to back PVR.

  • Volume effect+$27,987
  • Front PVR effect-$15,822
  • Back PVR effect+$3,854
  • Total change+$16,019
Read total gross change, december 2025 as a table
Total gross change, December 2025. In December 2025, total gross increased by $16,019 against the month before. The bridge attributes +$27,987 to unit volume, -$15,822 to front PVR, +$3,854 to back PVR.
ComponentRoleAmount
Volume effectAttributed movement+$27,987
Front PVR effectAttributed movement-$15,822
Back PVR effectAttributed movement+$3,854
Total changePeriod total+$16,019
How this decomposition works

The bridge is computed in SQL by reporting.vw_gross_change_bridge and carried through the export. It is a SEQUENTIAL decomposition: each effect is measured with the earlier ones already applied, so the order is part of the method and a different order would apportion the same change differently. The bridge attributes; it does not establish cause.

Effects smaller than $500 are grouped into a single remainder rather than listed — display materiality — project default. Grouped, never dropped: the listed effects and the remainder sum to the period change exactly.

What meets a review rule right now

Severity, then domain, then store, then rule

The order is a property of the data rather than of the reader: everyone looking at the same figures sees the same sequence.

  • HighInventoryGSA-003Review role: Used-car manager

    Aged unit with no markdown since the prior snapshot

    222 days in stockAged threshold 60 daysHigh-severity review threshold — project default 120 days

    Review this unit's price movement against its age and the store's aged-unit pattern.

    Open the evidence behind this
    Evidence, threshold detail and the rule
    Days in stock
    222 days
    Aged threshold days
    60 days
    Current asking price
    $18,963.60
    Original asking price
    $21,117.60
    Asking price change
    $0.00
    Markdown count to date
    6
    Price to market ratio
    1.0075
    Condition group
    Used
    Model name
    1500

    price_to_market_ratio is computed from a synthetic market price estimate. It is not a guidebook value, an auction result, an appraisal or a valuation.

    Rule ACT-INV-001 · inventory unit GSA-003|VEH-0000002 · snapshot date basis

  • HighInventoryGSA-003Review role: Used-car manager

    Aged unit with no markdown since the prior snapshot

    265 days in stockAged threshold 60 daysHigh-severity review threshold — project default 120 days

    Review this unit's price movement against its age and the store's aged-unit pattern.

    Open the evidence behind this
    Evidence, threshold detail and the rule
    Days in stock
    265 days
    Aged threshold days
    60 days
    Current asking price
    $33,799.13
    Original asking price
    $37,638.23
    Asking price change
    $0.00
    Markdown count to date
    6
    Price to market ratio
    0.8571
    Condition group
    Used
    Model name
    Camaro

    price_to_market_ratio is computed from a synthetic market price estimate. It is not a guidebook value, an auction result, an appraisal or a valuation.

    Rule ACT-INV-001 · inventory unit GSA-003|VEH-0000757 · snapshot date basis

  • HighInventoryGSA-003Review role: Used-car manager

    Aged unit with no markdown since the prior snapshot

    231 days in stockAged threshold 60 daysHigh-severity review threshold — project default 120 days

    Review this unit's price movement against its age and the store's aged-unit pattern.

    Open the evidence behind this
    Evidence, threshold detail and the rule
    Days in stock
    231 days
    Aged threshold days
    60 days
    Current asking price
    $40,520.80
    Original asking price
    $45,123.38
    Asking price change
    $0.00
    Markdown count to date
    6
    Price to market ratio
    0.9076
    Condition group
    Used
    Model name
    Colorado

    price_to_market_ratio is computed from a synthetic market price estimate. It is not a guidebook value, an auction result, an appraisal or a valuation.

    Rule ACT-INV-001 · inventory unit GSA-003|VEH-0000869 · snapshot date basis

  • HighSales & GrossGSA-003Review role: General manager

    Front-PVR effect materially reduced total gross this month

    -$15,822.37 effect amountHigh-severity bridge-effect threshold — project default -12000 USDBridge-effect review threshold — project default -5000 USD

    Compare the front-gross components of this month's deliveries with the comparison month under the documented sequential bridge.

    Open the evidence behind this
    Evidence, threshold detail and the rule
    Effect amount
    -$15,822.37
    Component label
    Front PVR effect
    Total gross change
    $16,018.51
    Total gross
    $90,650.97
    Comparison total gross
    $74,632.46
    Front end gross
    $66,718.58
    Comparison front end gross
    $60,029.78
    Retail units sold
    22 units
    Comparison retail units sold
    16 units

    A bridge contribution is an arithmetic attribution under a documented sequential decomposition. It is not a cause, and the decomposition order determines how a change is apportioned between components.

    Rule ACT-SLS-003 · store month GSA-003|2025-12-01|front_pvr · sale date, aggregated to calendar month basis

  • HighAccountingGSA-003Review role: Controller

    Control account with one side of the comparison absent

    ACC-MISSING-SUBLEDGER-BALANCE exception code

    Confirm which side of this control comparison is absent and reconcile it.

    Open the evidence behind this
    Evidence, threshold detail and the rule
    Exception code
    ACC-MISSING-SUBLEDGER-BALANCE
    Exception date
    2025-12-31 exception date
    Exception amount
    not recorded
    Exception detail
    New Vehicle Inventory at Granite Pre-Owned Center of Merrimack on date key 20251231: the control account carries 18400.00 and NO stock schedule exists to support it. The variance is NULL, not the full control balance: an absent schedule is not an empty one.

    A missing side is not a zero balance. The absent amount is carried as null and is never coalesced: "no balance was recorded" and "the balance was zero" are different control positions.

    Rule ACT-ACC-002 · accounting exception ACC-MISSING-SUBLEDGER-BALANCE:gl_reconciliation:20251231-3-1 · exception date basis

  • MediumInventoryGSA-003Review role: Used-car manager

    Asking price above the synthetic market estimate on an aged unit

    1.0747 price to market ratioAged threshold 60 daysPrice-to-market review threshold — project default 1.05 ratio

    Compare this unit's asking price with its age, its markdown history and the synthetic market context the ratio was built from.

    Open the evidence behind this
    Evidence, threshold detail and the rule
    Price to market ratio
    1.0747
    Current asking price
    $4,847.30
    Market price estimate
    $4,510.36
    Days in stock
    83 days
    Aged threshold days
    60 days
    Markdown count to date
    2
    Condition group
    Used
    Model name
    Tucson

    market_price_estimate is synthetic and generated by this project. The ratio is not a real market valuation, a guidebook value, an auction result, an appraisal or a pricing recommendation.

    Rule ACT-INV-003 · inventory unit GSA-003|VEH-0000245 · snapshot date basis

  • MediumInventoryGSA-003Review role: Used-car manager

    Asking price above the synthetic market estimate on an aged unit

    1.0672 price to market ratioAged threshold 60 daysPrice-to-market review threshold — project default 1.05 ratio

    Compare this unit's asking price with its age, its markdown history and the synthetic market context the ratio was built from.

    Open the evidence behind this
    Evidence, threshold detail and the rule
    Price to market ratio
    1.0672
    Current asking price
    $12,697.66
    Market price estimate
    $11,897.75
    Days in stock
    71 days
    Aged threshold days
    60 days
    Markdown count to date
    2
    Condition group
    Used
    Model name
    Telluride

    market_price_estimate is synthetic and generated by this project. The ratio is not a real market valuation, a guidebook value, an auction result, an appraisal or a pricing recommendation.

    Rule ACT-INV-003 · inventory unit GSA-003|VEH-0000440 · snapshot date basis

  • MediumF&IGSA-003Review role: F&I manager

    Retail delivery with no finance-manager attribution

    Cash finance structure

    Confirm how this delivery was desked and whether the F&I desk was involved.

    Open the evidence behind this
    Evidence, threshold detail and the rule
    Finance structure
    Cash
    Back end gross
    $535.16
    Finance reserve gross
    $0.00
    Product contract count
    1 contracts
    Original product gross
    $535.16
    Total gross
    $5,676.53
    Vehicle display
    2023 Chevrolet Equinox Premier
    Sale type
    Used Retail

    An unattributed delivery is a modelled state in this project's data, not necessarily an omission. This action makes no statement about any employee and is not a performance measure.

    Rule ACT-FNI-006 · deal SLE-00000607 · sale date basis

How this queue is produced

Where the rules live, and what keeps them honest

Rules live in config/dashboard/action_rules.yaml as data, not code, and are evaluated once at export time against the datasets this console already publishes. The queue is then a governed artifact with its own hash, exactly like a dataset.

The rule file is an input to the published data. Changing a threshold changes the queue even though no business fact moved, so the export check re-derives the queue from the current rule file and fails if the committed one differs. Ruleset 911c6bd4a226 produced what is shown here.

Facet counts are counts of the queue on this page. They are presentation figures derived from the rows, not new measures, and the generator refuses a count that disagrees with the rows it counts.

Every drill-through is checked against the console’s own route registry before the queue is written, so a link here cannot point at a retired route or carry a parameter its destination does not read.