Quarter target
$250,000
Weighted forecast
$209,200
Commit
$120,000
Weighted Pipeline Forecast
Forecast the quarter from open deals: stage probability, close month and the gap to target.
SpreadsheetForecast & QuotaFree
A 12-month forecast by product from base volume, monthly growth and seasonality, with revenue, gross profit and actuals vs forecast.
Shown with sample data
A 12-month forecast by product from base volume, monthly growth and seasonality, with revenue, gross profit and actuals vs forecast.
Build a 12-month sales forecast the way planners do: set each product's price, unit cost, base monthly volume and growth rate, apply a seasonality index for each month, and the forecast works out units, revenue and gross profit by product and by month. Record actual revenue as months close to see variance against forecast and how the year is tracking.
Base units × (1 + monthly growth) raised to the month number minus one × that month's seasonality index, rounded to whole units.
Use hours or projects as units and your rate as price.
Download a copy
Downloads need a free account.