Konnekt is collecting between KES 33,000 and KES 125,000 per day in subscription and hotspot payments, with a clear weekly rhythm. Payments tend to cluster mid-week and around month boundaries when most billing cycles renew. The model has trained on 90 days of complete payment history and is projecting forward for the next 31 days.
The forecast uses the Holt-Winters Additive method — a classical time series model well-suited to subscription and billing data because it explicitly separates three signals present in payment flows.
The forecast for any day h periods ahead is computed as:
Each component is updated daily using exponential smoothing — meaning recent observations carry more weight than older ones, but the model never discards historical context entirely.
The smoothing parameters are deliberately conservative. A low β of 0.10 means the model does not overreact to short-term shifts in trend — important for subscription revenue which grows gradually rather than in sudden jumps. A moderate α of 0.30 balances responsiveness to recent payment volumes against stability in the baseline estimate.
The model trains on payment records fetched directly from the Splynx ISP platform via its REST API. Every payment transaction is retrieved, aggregated to a daily total, and passed to the model. No manual data entry or intermediate spreadsheets are involved.
Days with no payments are filled with KES 0 to preserve the continuity of the time series. Today's date is always excluded from training because the current day is incomplete — including a partial day's total would understate the level estimate and distort the seasonal index for that weekday.
Payment method All 12,553 transactions are M-PESA payments processed via Safaricom. The model implicitly captures M-PESA timing behaviour — customers tend to pay in bursts around salary dates (end of month) and service renewal reminder messages, which creates the weekly spikes the seasonal component detects.
Coverage The forecast includes all revenue streams: residential subscriptions, business accounts, and hotspot top-ups. This ensures projected totals match exactly what the Payments section of the operations dashboard reports for any given date range.
Seasonality assumption The model uses a weekly (7-day) seasonal period — the dominant cycle in ISP billing data. Monthly seasonality such as concentrated month-end spikes is partially captured because it recurs at weekly-adjacent intervals. A longer seasonal period (L=30) would require significantly more data to initialise reliably and is best revisited once 6+ months of history are available.
Trend lag With β set to 0.10 the model responds slowly to trend shifts. If Konnekt onboards a large batch of new customers or experiences significant churn, the forecast will lag behind the new reality for several weeks before the trend component fully adjusts to the changed baseline.
Forecast horizon Confidence degrades with distance. The 31-day table is most reliable for the first 7–10 days ahead. Beyond two weeks the forecast reflects the model's expectation of continued pattern repetition — treat it as a planning range, not a hard target. Month-level projections carry wider uncertainty than the daily figures suggest.
Non-recurring events Public holidays, M-PESA system outages, promotional campaigns, bulk activations, or sudden churn events cannot be predicted by this model. A day of near-zero payments caused by an outage would reduce the level estimate for several subsequent days. Such anomalies should be noted and the forecast reviewed manually when they occur.