Demand & Planning
A rolling forecast is a continuously updated projection of future demand, sales, or production, typically extending a fixed period into the future (e.g., 12 months) and updated regularly (e.g., monthly).
Full Definition
Unlike a static annual budget, a rolling forecast is a dynamic planning tool that is regularly revised and extended. Each month or quarter, the oldest period is dropped, and a new future period is added, incorporating the latest sales data, market trends, and operational insights. For CPG brands, this means adapting quickly to shifts in consumer demand, promotional impacts, or supply chain disruptions. It provides a more accurate and agile view of future needs, helping to optimize inventory levels and production schedules.
Why It Matters for CPG Brands
For CPG operators, a rolling forecast is crucial for minimizing stockouts and overstock, which directly impacts profitability and customer satisfaction. It enables proactive adjustments to production plans and raw material procurement, reducing waste and ensuring fresh products are always available. This agility is vital in the fast-paced CPG market.
In CPG Operations
A snack food producer might use a rolling 12-month forecast, updated monthly, to anticipate demand for seasonal flavors or new product launches. By continually adjusting the forecast based on actual sales, promotional performance, and ingredient lead times, they can better plan raw material purchases and co-packer schedules. This prevents costly ingredient spoilage or missed sales opportunities.
Example
A small batch artisanal jam brand with 8 SKUs uses a rolling 6-month forecast, updated weekly, to manage their fruit procurement from local farms. If a sudden heatwave impacts berry yields, they can quickly adjust their production forecast for strawberry jam, potentially shifting focus to other flavors or securing alternative fruit sources earlier, avoiding production delays and ingredient waste.
Manage Rolling Forecast with Guidance
Guidance is the operations platform built for CPG brands. Replace your spreadsheets with one connected system for purchasing, production, inventory, COGS, and compliance.
Apply as a Design Partner
Frequently Asked Questions
How often should I update my rolling forecast?
The frequency depends on your product's seasonality, sales volatility, and supply chain lead times. Many CPG brands update monthly, but weekly or even daily updates might be necessary for highly perishable goods or volatile markets.
What's the main difference between a rolling forecast and a budget?
A budget is typically a fixed annual plan used for financial control and performance evaluation. A rolling forecast, however, is a dynamic, operational tool that is continuously updated to reflect current realities, helping you make agile decisions about production and inventory.
What data do I need to create an effective rolling forecast for my CPG brand?
You'll need historical sales data, promotional calendars, new product launch plans, market trends, lead times for raw materials and packaging, and production capacity. The more accurate your input data, the more reliable your forecast will be.