Calculator Inputs
What This Tool Does
It blends weighted history, trend projection, seasonality, market growth, pipeline conversion, and operational constraints into a practical unit forecast.
Use it for demand planning, target setting, stock planning, sales operations, and scenario reviews.
Example Data Table
| Period | Units Sold | Seasonality Index | Campaign Effect (%) | Notes |
|---|---|---|---|---|
| Month 1 | 920 | 0.96 | 2 | Stable demand |
| Month 2 | 980 | 1.00 | 3 | Normal period |
| Month 3 | 1015 | 1.02 | 4 | Moderate uplift |
| Month 4 | 1080 | 1.05 | 5 | Channel push |
| Month 5 | 1125 | 1.07 | 5 | Better coverage |
| Month 6 | 1180 | 1.08 | 6 | Peak demand |
This sample shows how recent unit history and adjustments can support a more realistic forecast model.
Formula Used
WMA = (1×P1 + 2×P2 + 3×P3 + 4×P4 + 5×P5 + 6×P6) ÷ 21
Trend = a + bX, where b is the slope from historical sales and X is the future period position.
Base Forecast = (0.60 × WMA) + (0.40 × Trend Forecast)
Gross Forecast = Base Forecast × Seasonality × Growth × Marketing × Promotion + Pipeline Contribution + Manual Adjustment
Pipeline Contribution = Pipeline Units × Conversion Rate
Net Forecast = Gross Forecast × Capacity × Availability × (1 − Returns) × (1 − Lost Sales)
This structure combines statistical history with business drivers, giving a forecast that reflects demand, operations, and execution risks.
How to Use This Calculator
- Enter six recent sales periods in units.
- Choose the forecast horizon you want to evaluate.
- Add the seasonality index for the target period.
- Fill in market growth, marketing, and promotion effects.
- Enter open pipeline units and expected conversion rate.
- Adjust for capacity, stock availability, returns, and lost sales.
- Apply any manual units for special contracts or one-time events.
- Submit the form and review the result cards, table, and graph.
- Use CSV or PDF export to share the forecast.
Frequently Asked Questions
1) What does sales volume forecast mean?
It estimates future units likely to be sold over a chosen period. The result helps with targets, inventory, staffing, and capacity planning.
2) Why use six historical periods?
Six periods give enough recent history to spot movement without overloading the model. You can still adapt the file later for longer histories.
3) What is the seasonality index?
It adjusts demand for repeating seasonal patterns. A value above 1.00 lifts the forecast, while a value below 1.00 lowers it.
4) Why include pipeline contribution?
Pipeline units convert commercial activity into likely future sales. Applying a conversion rate prevents counting all open opportunities as guaranteed volume.
5) What does capacity factor represent?
It reflects how much output your team, channels, or operations can support. Limited capacity can reduce achievable sales even when demand is strong.
6) Why subtract returns and lost sales?
Returns reduce retained units, and lost sales capture missed demand from stockouts or poor execution. Both make the forecast more realistic.
7) How should I interpret confidence score?
It gives a quick stability signal based on recent variation. Higher scores suggest steadier history, while lower scores suggest greater uncertainty.
8) Can this forecast replace a full demand planning system?
No. It is a practical planning calculator, not a complete enterprise forecasting platform. Use it alongside business judgment and deeper market analysis.