S&OP, Demand Planning & Forecasting calculator
Product Family Forecast Mix Calculator
Product Family Forecast Mix estimates how many good, sellable units a shared production line can actually deliver for a family of products once you strip out downtime and yield loss. Supply planners and S&OP capacity owners use it to check whether a demand forecast for a product family is even buildable before it becomes a commitment. It matters because gross capacity flatters you - a line that theoretically makes 1,920 units rarely ships that many after availability and first-pass yield bite. Sizing good capacity keeps the mix plan honest and stops you from promising volume the shop floor can't produce.
What this calculator does
- Estimate product family forecast mix for sandop, demand planning and forecasting using production-ready inputs so teams can confirm whether capacity can cover demand before committing the schedule.
- Use it when product family forecast mix in s and op, demand planning and forecasting is being asked to take on more work and you need to know if there is room.
- It computes good sellable capacity for a product family by multiplying output per cycle by available cycles, then derating for uptime and first-pass yield.
Formula used
- Gross product family forecast mix capacity = product family forecast mix output per cycle × available product family forecast mix cycles
- Good product family forecast mix capacity = gross capacity × expected product family forecast mix uptime × expected product family forecast mix first-pass yield
Inputs explained
- Sellable units built per production cycle:
- Available production cycles in the plan horizon:
- Planned line uptime (availability):
- Expected first-pass yield across the family:
How to use the result
- Use it during rough-cut capacity planning in S&OP to reality-check a product-family forecast against the line that has to build it.
- It treats the family as one blended flow - it does not model changeover losses from switching between products in the mix, so heavy changeover environments need a separate allowance.
Current U.S. benchmarks
- The producer price index for steel mill products stands at 348.53 (BLS, May 2026), up 6.7% from a year earlier. Quotes priced off last quarter's material cost miss this move.
- The U.S. has 3,569 primary metal manufacturing establishments employing about 354,911 workers (Census County Business Patterns, 2023).
Common questions
- How do you calculate good capacity for a product family? Multiply output per cycle by the number of available cycles for gross capacity, then multiply by uptime and first-pass yield. With 4 units/cycle over 480 cycles at 90% uptime and 97% yield you get 1,676 good units from a gross 1,920.
- What is the difference between gross and good capacity? Gross capacity ignores losses - it is just output per cycle times cycles, or 1,920 units here. Good capacity subtracts downtime loss (192 units) and yield loss (about 52 units) to leave the 1,676 sellable units you can actually plan around.
- Why include first-pass yield in a capacity number? Because units that fail first pass either scrap or rework, consuming capacity you already counted. At 97% yield you quietly lose about 52 units on this run even after downtime is handled.
- What is a good uptime figure to use? It depends on the asset, but 85-95% availability is common for a reasonably reliable line. Using the default 90% costs you 192 units versus perfect uptime - a useful reminder of what reliability projects are worth.
- Does this handle changeovers between products in the family? Not directly. It blends the family into one flow. If you run many short changeovers across the mix, fold that time into a lower effective uptime or shorten the available cycles.
Last reviewed 2026-05-12.