Forecast revenue
$586,979
Gross profit
$373,235
Gross margin
64%
Monthly Sales Forecast
A 12-month forecast by product from base volume, monthly growth and seasonality, with revenue, gross profit and actuals vs forecast.
4 free monthly sales forecast templates, ready to edit in your browser and download for Excel, Word, Google Sheets or your calendar app. This collection brings together 4 spreadsheets from Forecast & Quota and Reordering & Stock Planning. Start with Monthly Sales Forecast, Demand Forecast Planner and Weighted Pipeline Forecast: each comes with realistic sample content, working formulas or ready-to-use wording, and a step-by-step guide.
Forecast revenue
$586,979
Gross profit
$373,235
Gross margin
64%
A 12-month forecast by product from base volume, monthly growth and seasonality, with revenue, gross profit and actuals vs forecast.
Forecast units next month
2,189
Units short
1,089
Products growing
4
Forecast next month for each product from the last six months, with a trend and seasonal adjustment.
Quarter target
$250,000
Weighted forecast
$209,200
Commit
$120,000
Forecast the quarter from open deals: stage probability, close month and the gap to target.
Team attainment
45%
Projected finish
84%
Gap to quota
$347,000
Bookings against quota for each rep, with pace for the days gone, projected finish, pipeline coverage and the gap to close.