Simulation & Prediction
Forecasting
Historical actuals with run-rate, no-action and recommended-action projections against target.
Latest actual
ACTUALUSD 6.8M
Run-rate (6 mo)
FORECASTUSD 6.8M
No action (6 mo)
FORECASTUSD 10.02M
Recommended (6 mo)
SCENARIOUSD 3.58M
Target
TARGETNot stored
Revenue at risk (churn) — Churn & Retention
Solid = stored actuals (Historical KPI trend data). Dashed = deterministic projections in the shaded period. Band = ±1σ of historical residuals around the no-action line, widening with horizon. Direction of good: lower.
Forecast table
| Period | Type | Actual | Run-rate | No action | Recommended | Spread (±1σ) |
|---|---|---|---|---|---|---|
| Apr 26 | ACTUAL | USD 4.1M | ||||
| May 26 | ACTUAL | USD 4.5M | ||||
| Jun 26 | ACTUAL | USD 5.2M | ||||
| Jul 26 | ACTUAL | USD 5.7M | ||||
| Aug 26 | ACTUAL | USD 6.1M | ||||
| Sep 26 | ACTUAL | USD 6.8M | ||||
| Oct 26 | FORECAST | — | USD 6.8M | USD 7.34M | USD 6.26M | USD 7.25M – USD 7.43M |
| Nov 26 | FORECAST | — | USD 6.8M | USD 7.87M | USD 5.73M | USD 7.75M – USD 7.99M |
| Dec 26 | FORECAST | — | USD 6.8M | USD 8.41M | USD 5.19M | USD 8.26M – USD 8.56M |
| Jan 27 | FORECAST | — | USD 6.8M | USD 8.95M | USD 4.65M | USD 8.77M – USD 9.13M |
| Feb 27 | FORECAST | — | USD 6.8M | USD 9.49M | USD 4.11M | USD 9.29M – USD 9.69M |
| Mar 27 | FORECAST | — | USD 6.8M | USD 10.02M | USD 3.58M | USD 9.8M – USD 10.24M |
Source data, assumptions, methodology & limitations
Source data
- Telecom KPI data (current period, target, prior)
- Historical KPI trend data (monthly history Apr–Sep 2026)
Assumptions
- Run-rate baseline: holds the latest stored actual flat.
- No action: continues the 6-month stored trend (+0.54 per month).
- Recommended action: reverses the trend at the same monthly rate (no stored target).
Methodology
- Least-squares straight line through 6 stored months (slope +0.537 per month).
- Residual standard deviation σ = 0.088; spread = σ × √(months ahead).
- Identical arithmetic feeds Decision Journey Stage 5 — Predict.
Limitations
- Forecasts are straight-line projections of six stored months; they ignore seasonality, shocks and interactions between measures.
- Many KPIs have no stored target; where absent, the recommended path reverses the trend at the same monthly rate.
- No downside scenario is stored for any journey; downside coverage is shown as a gap rather than invented.
| Evidence type | Item | Source |
|---|---|---|
| model output | Congestion forecast 214 sites forecast to exceed 85% utilisation within 90 days. | OSS network data |
| model output | SIM-box detection output 1,240 SIM-box incidents flagged; 91% detection rate. | Revenue assurance data |
| methodology | Network Performance & Risk methodology Aggregate availability and KPIs from network counters; Classify outages by root cause; Score sites by risk and revenue exposure. | Finance Planning Dataset |
| assumption | FX assumption All figures in USD at a constant planning rate. | Finance Planning Dataset |
| model output | Churn propensity scores 48k high-value subscribers scored above 60% churn propensity. | CRM |
| limitation | Regulatory data lag Regulator returns lag by one quarter; current quarter is estimated. | Regulatory Reporting Store |