What it helps you decide
Net forecasts against inventory and round requirements to batch sizes.
Make planning
Convert forecast demand and inventory into batch-ready quantities.
Net demand against usable stock and confirmed inbound units, add safety stock, and round every SKU to its actual production batch size.
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
Forecast and inventory by SKU
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
Confirm every inventory balance before releasing work.
Use usable and uncommitted inventory only. Check shelf life, open orders, substitutions, minimum runs, material and packaging availability, capacity, demand uncertainty, production yield, scrap, and lot restrictions.
Want to keep working with these numbers?
Waste & Yield Tracker
Measure planned versus actual output, waste rate, disposed quantity, cost impact, causes, and actions.
About this free sales & demand tool
How to use the Production Quantity Planner
Net forecasts against inventory and round requirements to batch sizes. 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: SKU entries.
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.
Complete workflow guide
Inventory and traceability
A stock count tells you how much is on the shelf. Traceability explains how it arrived, which batch used it, and which customers received the finished product.
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.