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 plan templates, ready to edit in your browser and download for Excel, Word, Google Sheets or your calendar app. This collection brings together 3 spreadsheets and 1 document from Forecast & Quota, Reordering & Stock Planning and Pricing & Merchandising. Start with Monthly Sales Forecast, Demand Forecast Planner and Open-to-Buy Plan: 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.
Planned purchases
$235,600
Already on order
$145,000
Open to buy
$90,600
Plan purchases by department and month from sales, markdowns and target stock, and see what is left to spend.
Owner: Name, Demand Generation Manager Sales partner: Name, Head of Sales Period: January–June 2027
1. Goal
Generate $2.4M of qualified pipeline and support $600,000 of new bookings in H1 2027, with marketing sourcing at least 45% of new opportunities.
2. Funnel maths
| Step | Rate or value | Result for 6 months |
| New bookings target | $600,000 | |
| Average deal size | $24,000 | 25 deals |
Use your own conversion rates from your CRM. If you do not have them yet, start with these and update after one quarter.
3. Who we want
Work back from the revenue target to leads needed, then plan channels, offers, budget, lead scoring and handoff to sales.