| Component | Houses | Margin £/mo | % of Base |
|---|---|---|---|
| Prior Month Closing (= Opening) | 12,076 | £330,080 | — |
| New Sales Going Live | +724 | +£19,380 | +6.0% |
| Returning (Renewal Lag) | +68 | +£1,360 | +0.6% |
| SVT Rollovers (in) | +450 | £0 | +3.7% |
| Total Joiners | +1,242 | +£20,740 | +10.3% |
| Natural Ends (≥300d) | −892 | −£24,560 | −7.4% |
| Premature Cancellations (<300d) | −150 | −£4,180 | −1.2% |
| Total Leavers | −1,042 | −£28,740 | −8.6% |
| Net House Change | +200 | −£8,000* | −1.7% |
| Closing Base (contract movements) | 12,276 | — | — |
| Renewals (within base) | 68 | — | — |
contract_type field + monthly snapshot model. Margin £ uses rate card on priced movements only.| Margin Type | Houses | £/mo Added | £/House |
|---|---|---|---|
| HIGH | 60 | £2,400 | £40 |
| STANDARD | 392 | £11,760 | £30 |
| LOW | 250 | £5,000 | £20 |
| EXTRA_LOW | 22 | £220 | £10 |
| Total New Business | 724 | £19,380 | £26.77 |
This section tracks houses present in both Apr and May that changed margin tier between snapshots (e.g. STANDARD→ZERO_MARGIN, HIGH→STANDARD), with the £ margin impact of each move — exactly as in the Excel "Tariff Migrations (Stayers)" block.
Cannot be computed reliably from the current single-snapshot dbt table — it requires comparing each phoenix_house_id's margin_type across consecutive month-end snapshots. This needs a monthly snapshot model in dbt (on the requested-fields list). Once built, this populates automatically. Will not be faked with estimates.
| Movement (target structure) | Houses | Margin Impact £ |
|---|---|---|
| STANDARD → ZERO_MARGIN | — | — |
| HIGH → ZERO_MARGIN | — | — |
| HIGH → STANDARD | — | — |
| ZERO_MARGIN → STANDARD (recovery) | — | — |
| LOW → STANDARD | — | — |
Tracks migration between the old PAYG margin model and the new Unlimited/Fixed model (Old→New, New→Old, Any→Unknown, Unknown→Priced recovery) with £ impact — the Excel "Old World vs New World" block.
Requires a field distinguishing tariff model (PAYG vs Unlimited) — derivable from elec_tariff_name codes (UL17/UL33 = new model) but not yet a clean dbt field. Combined with the monthly snapshot model, this becomes computable. Flagged for the methodology session — no estimates shown.
| Margin | P8 Feb | P9 Mar | P10 Apr | P11 May | £/mo P11 |
|---|---|---|---|---|---|
| HIGH | 3,399 | 3,531 | 3,609 | 3,592 | £143,680 |
| STANDARD | 4,752 | 5,026 | 5,438 | 5,689 | £170,670 |
| LOW | 895 | 943 | 1,107 | 1,324 | £26,480 |
| EXTRA_LOW | 0 | 3 | 44 | 65 | £650 |
| ZERO / SVT | 1,508 | 1,611 | 1,878 | 2,282 | £0 |
| Unknown (historic) | 4,658 | 4,268 | 3,334 | 2,363 | £0 |
| Total Houses | 15,212 | 15,382 | 15,410 | 15,315 | — |
| Rate Card Margin /mo | £296,420 | £310,910 | £330,080 | £341,480 | — |
| + Mgmt Fee Margin /mo | £0 | £616 | £4,123 | £9,746 | 703 @ month-end |
| Total Bunch Margin /mo | £296,420 | £311,526 | £334,203 | £351,226 | — |
| Segment | Leavers | Premature | Avg Days |
|---|---|---|---|
| HIGH | 94 | 28 (30%) | 310 |
| STANDARD | 364 | 27 (7%) | 351 |
| LOW | 49 | 12 (24%) | 300 |
| ZERO / SVT | 76 | 23 (30%) | 381 |
| Unknown | 3,179 | 429 (13%) | 345 |
| Total | 3,762 | 519 (14%) | — |
| Segment | Houses | £ Added | £/House |
|---|---|---|---|
| HIGH | 60 | £2,400 | £40.00 |
| STANDARD | 392 | £11,760 | £30.00 |
| LOW + XL | 272 | £5,220 | £19.19 |
| Total Joiners | 724 | £19,380 | £26.77 |