Two Lenses, Same 134 Accounts
The system answers two distinct questions through two parallel views. Both are correct — they show different things.
Dealer View (07a)
"Is this account economically viable for everyone in the chain?"
Includes: Equipment, Installer, Rep Comm, OH Allocation, and 10% Holdback (chargeback reserve for canceled accounts).
Use when: Dealer relations conversations, full-chain economic health, sales channel comparisons.
AAA Operations View (07b)
"We wrote a check. When do we recover it, and what's the long-term value?"
LTV = Net RMR × Life × Retention − Outlay
Pure company-side: Outlay = commission paid to dealer (already net of equipment listed on invoice) + Equipment Override.
Use when: Cash position, recovery timing, long-term portfolio valuation.
Headline Numbers — Both Views
| Metric | Dealer View | AAA Ops View |
|---|---|---|
| Total Accounts | 134 | 134 |
| Funding / Outlay | $471,193 modeled | $242,831 actual commish |
| Total Cost / Burden | $121,324 CPJ | — |
| Net Profit (deal level) | $302,749 | — |
| Avg Breakeven / Payback | 9.0 mo | 33.3 mo |
| Total LTV | $989,178 | $312,421 |
| LTV Multiple | — | 1.29× |
| Net Profitable / Underwater | — | 134 / 0 |
Per-Area (Dealer View)
| Area | # | Funding | CPJ | BE | Net Profit | LTV | Status |
|---|---|---|---|---|---|---|---|
| Texas | 55 | $98,617 | $461 | 9.5 | $63,374 | $206,628 | STRONG |
| Nebraska | 31 | $65,453 | $448 | 7.2 | $45,007 | $143,371 | STRONG |
| Michigan | 2 | $4,320 | $425 | 5.8 | $3,038 | $9,573 | CLEAN |
| Nevada | 41 | $60,529 | $488 | 10.8 | $34,465 | $119,475 | MONITOR |
| Other | 5 | $6,679 | $104 | 2.8 | $5,491 | $15,541 | OK |
| TOTAL | 134 | $235,596 | $385 | 7.2 | $151,375 | $494,589 | — |
Per-Area (AAA Ops View)
| Area | # | Avg Net RMR | Outlay | Payback | LTV | LTV × | Status |
|---|---|---|---|---|---|---|---|
| Nebraska | 31 | $71.05 | $63,955 | 29.9 mo | $93,317 | 1.46× | MONITOR |
| Michigan | 2 | $72.99 | $4,320 | 29.6 mo | $6,103 | 1.41× | MONITOR |
| Texas | 55 | $59.08 | $100,491 | 33.7 mo | $131,517 | 1.31× | MONITOR |
| Nevada | 41 | $47.65 | $65,557 | 34.9 mo | $73,930 | 1.13× | MONITOR |
| Other | 5 | $44.99 | $8,508 | 39.4 mo | $7,554 | 0.89× | REVIEW |
| TOTAL | 134 | $59.15 | $242,831 | 33.5 mo | $312,421 | 1.29× | — |
Reading the AAA View
Nebraska is the strongest payback area — highest Net RMR ($71.05), fastest payback (29.9 mo), best LTV multiple (1.46×). "Other" is the only flagged area at 0.89× LTV multiple — those 5 accounts will not break even over the life horizon at current outlay levels.
Equipment Override Mechanics
On invoices where equipment is listed, that cost is already deducted from total commission — the dealer netted it. Outlay = Commission, no override needed.
On accounts where equipment was supplied by AAA outside of commission netting (rare — typically commercial), enter cost in the yellow Equipment Override column on 07b. Adds to Outlay and recalculates Payback and LTV.
Real BOM flag (col L on 07b): Y = listed on invoice (already netted) | N = not listed (override may apply if AAA supplied)
Inventory Mechanics
The Five-Step Loop
| Step | Action | Where |
|---|---|---|
| 1 | Parts shipped from A3SH or DSC | 02_Inventory_OnHand IN columns (yellow) |
| 2 | Job assigned, BOM entered | 04_Job_BOM — qty per SKU per Job# |
| 3 | Movement auto-logged | 05_Inventory_Movements (formula-driven) |
| 4 | Balance recalculates: IN − OUT = BAL | 02_Inventory_OnHand BAL columns |
| 5 | Negative balance triggers AMBER/RED alert | Dashboard inventory health table |
Status Flags
OK Balance ≥ 5 — healthy. LOW Balance 0–4 — schedule replenishment. OVERSOLD Balance < 0 — investigate.
Addendum Workflow
- Log change order on 10_Addendum_Tracker
- Δ Cost auto-calculates: (New Qty − Original Qty) × Dealer Cost
- Status pills color-coded; Trigger Email defaults to wayne.jordan@a3marthome.com
How It Works — Field Reference
Why two views?
The Dealer View answers "is this account healthy for everyone in the chain" — it accounts for installer, rep comm, OH, and the 10% holdback (chargeback reserve for cancels). The AAA View answers "when do I get my money back from MY perspective as the company on the monitoring side" — pure outlay vs. recurring revenue.
Both are right. They show different things.
What's the 10% Holdback?
A3SH withholds 10% of contract value as a chargeback reserve. If accounts cancel within term, the holdback covers the loss. If accounts hold, the holdback releases back to the dealer over time. Visible on Dealer View only — it's a dealer-side mechanic, not company outlay.
Why is Equipment Override usually $0?
Because on most invoices, equipment cost is already deducted from total commission. The dealer netted the equipment cost out of their pay. AAA already accounted for it via reduced commission. Override only matters when AAA supplied equipment OUTSIDE the commission netting — rare, typically commercial accounts.
What does "dates stripped" mean?
Per spec, install dates were removed from the CPA file to focus on economics, not timing. Sequential ordering preserved via Quote ID and Job#.
Why is some inventory OVERSOLD?
BOM consumption from 134 accounts exceeds the small set of recent shipments in the parts file. Either log older shipments into 02 IN columns, OR mark generic BOMs as N (Real BOM flag) to remove fake consumption.
Can I model a price change?
Yes. On 00_Inputs, edit the funding multiples (rows 6–10) or pass-through ($/mo, rows 14–16). Both views recalculate instantly.
Daily / Weekly / Monthly Operating Rhythm
Daily
- Log new parts shipments → 02_Inventory_OnHand IN columns
- Enter BOMs for completed jobs → 04_Job_BOM
- Log addendums → 10_Addendum_Tracker
- Update Equipment Override on 07b for any AAA-supplied parts outside commission
Weekly
- Review BOTH views on Dashboard — Dealer side for chain health, AAA side for cash position
- Check Top 10 Risk accounts (Dealer View)
- Check Underwater accounts on AAA View (LTV < 0)
- Reconcile area Net Profit and LTV vs forecast
Monthly
- Roll up area-level CPJ trend (Dealer View)
- Review LTV multiple by area (AAA View) — anything < 1.0× = net negative
- Audit pass-through assumptions vs actual carrier invoices
- Update commission column in 03_Account_Master with actual paid amounts (drives AAA accuracy)