The historical series has a sustained upward pattern
Monthly revenue increases from $210K in January 2023 to $382K in December 2025, with positive same-month year-over-year growth throughout the period.
A six-month sales forecast built from 36 months of U.S. sales history, using a seasonal year-over-year method, backtesting, and planning considerations.
BUSINESS SITUATION
A business had three years of monthly sales history but relied mainly on recent performance when planning upcoming periods. The objective was to create a forward-looking view that could be used as a planning input while keeping the assumptions and limitations visible.
DATASET
Thirty-six months of monthly sales history followed by a six-month forecast period.
DATA PREPARATION
Sorted the monthly revenue series chronologically and confirmed one observation for each month from January 2023 through December 2025.
Checked the 36 historical values for missing months and unusually large discontinuities before calculating year-over-year changes.
Calculated same-month year-over-year growth for 2024 versus 2023 and 2025 versus 2024 so recurring calendar position is preserved.
Kept 2025 separate as a validation period for the initial backtest before using all available history for the final six-month projection.
METHOD
Reviewed the 36-month series for trend and recurring same-month behavior rather than extrapolating only the latest month.
Backtested a seasonal year-over-year growth rule on 2025: each 2025 month was estimated from the corresponding 2024 month using the growth observed from 2023 to 2024.
Evaluated the 2025 holdout using mean absolute percentage error (MAPE), obtaining 0.7% MAPE.
For January–June 2026, averaged the two observed same-month year-over-year growth rates and applied that average to the corresponding 2025 month.
Compared the six-month forecast total with the immediately preceding six actual months and treated the result as a planning baseline, not a guaranteed outcome.
KEY METRICS
VISUAL ANALYSIS
KEY FINDINGS
Monthly revenue increases from $210K in January 2023 to $382K in December 2025, with positive same-month year-over-year growth throughout the period.
Applying 2023-to-2024 same-month growth to estimate the 2025 holdout produces 0.7% MAPE. This result measures performance on the sample dataset and should not be generalized to other datasets or future forecasts.
The January–June 2026 forecast totals $2.272M, compared with $2.172M across July–December 2025, a difference of approximately 4.6%.
The forecast ranges from $355K in January to $403K in June and does not force every month into a straight-line increase; May is below April because the method retains same-month historical structure.
SUPPORTING TABLES
| Month | Forecast Revenue |
|---|---|
| Jan 2026 | $355K |
| Feb 2026 | $364K |
| Mar 2026 | $374K |
| Apr 2026 | $390K |
| May 2026 | $386K |
| Jun 2026 | $403K |
| Check | Result | Interpretation |
|---|---|---|
| 2025 holdout backtest | 0.7% MAPE | Low backtest error on the sample dataset |
| Jan–Jun 2026 forecast | $2.272M | Six-month planning baseline |
| Previous six actual months | $2.172M | Jul–Dec 2025 comparison period |
| Forecast vs. previous six months | +4.6% | Comparison, not a causal growth claim |
BUSINESS INTERPRETATION
The forecast provides a transparent planning baseline derived from historical sales patterns. The backtest evaluates performance on a held-out year, while the final projection preserves month-specific growth behavior. Planning decisions should also consider pricing, promotions, launches, capacity, and market conditions.
VALIDATION
DECISION USE
Treat the six-month total as a reference scenario for planning and compare it with management assumptions before setting inventory, staffing or sales commitments.
Adjust or scenario-test the baseline when promotions, pricing changes, launches, closures or capacity changes are already known but absent from the historical series.
Compare each new month with the forecast, record the error and update the model when the recent pattern materially departs from the historical relationship.
LIMITATIONS
DELIVERABLE
BUSINESS VALUE
The example shows a complete forecasting workflow: prepare the time series, define a transparent method, test it on a held-out period, produce the forecast, state its limitations and connect the result to a planning decision.
NEXT