What it helps you decide
Blend sales trend and recent demand into a forward unit forecast.
Sales forecasting
Turn recent sales history into a practical demand forecast.
Use a linear trend and recent moving average to project the next periods, while making sales volatility visible before purchasing or scheduling production.
Excel-readyExport this tool as a downloadable .xlsx spreadsheet.
Start with the example
The values already filled in are a working example—not a recommendation.
- 1Choose the closest starting point.
- 2Replace the example with your real details.
- 3Read the live result and its important limits.
Your numbers
Historical unit sales
Use the filled example first. Then replace each field with a measured value or your best current estimate.
Step 1Answer one question at a time. Your example values stay available.
Important limit
A statistical trend does not know what changes next.
Adjust for promotions, lost sales, stockouts, holidays, weather, new accounts, churn, pricing, distribution changes, seasonality, and known one-time orders. Use separate histories for products with different demand patterns.
Want to keep working with these numbers?
Sales Forecast Spreadsheet
Use reusable product assumptions to forecast units and revenue, then compare actual sales and variance.
About this free sales & demand tool
How to use the Demand Forecast Calculator
Blend sales trend and recent demand into a forward unit forecast. The calculator runs privately in your browser and is designed to make the assumptions behind the answer visible.
What to have ready
Use a clean sales history, note promotions or stockouts, and separate unusual events from demand you reasonably expect to repeat.
Key inputs: Period entries; Periods to forecast; Periods in recent average; Trend forecast weight.
How to use the result
Use the forecast as a planning range, then adjust for inventory on hand, lead time, shelf life, capacity, and the cost of being over or under stock.
Excel spreadsheet export
Download the Demand Forecast Excel Spreadsheet
Use the Demand Forecast Calculator in your browser, then export a branded .xlsx forecast workbook to save the demand assumptions, planning result, and production target for review.
This gives you a portable forecast workbook you can save with an order, production record, planning meeting, or pricing review. The workbook keeps the source link and date with the numbers, making it easier to understand where the result came from when you reopen or share it later.
Spreadsheet questions
Using this tool as an Excel workbook
Use the browser calculator for speed, then take the result into the spreadsheet workflow that fits your business.
Can I export the Demand Forecast Calculator to Excel?
Yes. Enter your information, review the live result, and select Export to Excel. Batch Scale creates a branded .xlsx workbook with your inputs and the result shown by the tool.
What is included in the Demand Forecast Excel Spreadsheet?
The workbook includes a Tool Result sheet, an Inputs sheet, the original calculator link, and the date generated. When a supported calculator has an Excel formula profile, its result cells remain connected to the editable input cells.
Can I use the spreadsheet in Google Sheets?
You can import the .xlsx workbook into Google Sheets. Because spreadsheet applications sometimes interpret formulas and formatting differently, confirm any important result after importing—especially before using it for pricing, safety, compliance, or production.
Is the Excel download free?
Yes. The calculator and workbook are free. The first Excel export on a device asks for your email and permission to receive occasional practical Batch Scale resources. Once captured, later tool exports on that device download directly.
Learn the workflow
Helpful guides for this calculator
Markets & GrowthSeasonal Demand Forecasting With Almost No Data: A Practical Range for Makers
Forecast a seasonal product using last-year evidence, confirmed demand, event changes, capacity, supplier commitments, and explicit low-base-high scenarios.
Read the guide →Markets & GrowthWhy Customers Do Not Reorder: Build a Repeat-Purchase Flywheel That Feels HumanDiagnose weak repeat buying by examining product use-up timing, customer success, replenishment friction, relevance, and contribution before defaulting to discounts.
Read the guide →Ready for the connected version?
Turn the calculation into a repeatable workflow.
Batch Scale connects recipes, materials, costs, inventory, production, sales, and your storefront in one workspace.