How do I calculate available capacity in hours?

Multiply available hours per shift by shifts per week, subtract planned downtime for maintenance and changeover, then multiply by your utilization rate. A machine running 8 hours across 10 shifts is 80 gross hours; subtract 5 hours downtime and apply 85 percent utilization to get about 63.8 usable hours per week. Nameplate capacity overstates reality, so the utilization factor is what makes the number trustworthy.

What utilization rate should I use for capacity planning?

For most discrete manufacturing, plan at 80 to 90 percent to leave room for setups, minor stops, and variability. Highly automated cells with strong reliability can run 90 to 95 percent. Planning at 100 percent guarantees you miss, because it assumes zero downtime and perfect flow. If you track OEE, your availability component is a good starting utilization figure for this template's rate input.

How do I convert unit demand into required machine hours?

Multiply demand in units by hours required per unit from your routing or standards. If you need 2,000 units and each takes 0.05 machine hours, that is 100 required hours for the period. This template sums required hours per work center automatically, then compares against available hours so you can see the gap. Use standard run times plus setup time spread across the batch for accuracy.

What does a negative capacity gap mean and how do I close it?

A negative gap means required hours exceed available hours, so you are overloaded. A work center needing 120 hours with 100 available is 20 hours short. Close it by adding a shift, scheduling overtime, offloading to another machine, outsourcing the overflow, or reducing setup time. If gaps persist across quarters, that is the business case for capital. The recommended action column prompts these options per row.

How is capacity planning different from takt time?

Takt time sets the pace for a single balanced line to meet demand in seconds per unit. Capacity planning works at the aggregate level, comparing total required hours against available hours across many machines or cells over weeks or months. Takt answers how fast one line must run today; capacity planning answers whether the whole plant can absorb next quarter's forecast and where the bottleneck resources sit.

How often should I refresh a capacity plan?

Refresh monthly as part of the S&OP cycle, and immediately when a major forecast change or large order lands. Demand shifts, routing changes, and downtime all move the numbers. Reviewing the gap column each S&OP meeting lets you commit overtime or outsourcing 4 to 8 weeks ahead rather than firefighting. Keep the utilization rate current, since a machine's real availability drifts as it ages.

Production and Throughput

Capacity Planning Spreadsheet Template

Model available capacity against demand to identify gaps, overloads, and resource requirements across machines, cells, or shifts.

Overview

This template models available capacity against demand across machines, cells, or shifts so planners and operations managers can see exactly where load exceeds what the plant can produce. Before accepting a large order or reacting to a forecast change, guessing whether you have room is how plants overcommit and miss ship dates. Laying required hours next to available hours per work center turns a gut feeling into a specific gap or surplus in hours you can act on.

Each row is a machine or work center. You enter available hours per shift, shifts per week, planned downtime, and a utilization rate to get realistic available hours rather than nameplate capacity. You enter demand in units and hours required per unit, and the sheet computes total required hours. The comparison column subtracts required from available to show a gap or surplus, and the recommended action column prompts you to add shifts, schedule overtime, or outsource the overload.

In an S&OP cycle you load next quarter's demand and scan the gap column for negatives. A press showing 120 required hours against 100 available is 20 hours short, roughly two shifts of overtime or a candidate for outsourcing. Apply your utilization factor honestly, since running at 85 percent of nameplate is realistic and 100 percent is not. Use it to justify a capital request when gaps persist, then pair it with the Capacity Planning Calculator to test shift or overtime scenarios quickly in a planning meeting.

What this template includes

Machine or work center list
Available hours per shift and shifts per week
Planned downtime and utilization rate
Demand in units and required hours per unit
Required hours vs. available hours comparison
Capacity gap or surplus in hours
Recommended action column

Suggested use case

Use this for S&OP planning, before accepting new orders, when responding to a forecast change, or when justifying equipment investment.

How to use it

List each machine, cell, or operation in the rows.
Enter available hours per period and apply your utilization factor.
Enter demand in units and hours per unit.
Review gap column to see where load exceeds capacity.
Adjust shifts, overtime, or outsource to close gaps.

Frequently Asked Questions

How do I calculate available capacity in hours?: Multiply available hours per shift by shifts per week, subtract planned downtime for maintenance and changeover, then multiply by your utilization rate. A machine running 8 hours across 10 shifts is 80 gross hours; subtract 5 hours downtime and apply 85 percent utilization to get about 63.8 usable hours per week. Nameplate capacity overstates reality, so the utilization factor is what makes the number trustworthy.
What utilization rate should I use for capacity planning?: For most discrete manufacturing, plan at 80 to 90 percent to leave room for setups, minor stops, and variability. Highly automated cells with strong reliability can run 90 to 95 percent. Planning at 100 percent guarantees you miss, because it assumes zero downtime and perfect flow. If you track OEE, your availability component is a good starting utilization figure for this template's rate input.
How do I convert unit demand into required machine hours?: Multiply demand in units by hours required per unit from your routing or standards. If you need 2,000 units and each takes 0.05 machine hours, that is 100 required hours for the period. This template sums required hours per work center automatically, then compares against available hours so you can see the gap. Use standard run times plus setup time spread across the batch for accuracy.
What does a negative capacity gap mean and how do I close it?: A negative gap means required hours exceed available hours, so you are overloaded. A work center needing 120 hours with 100 available is 20 hours short. Close it by adding a shift, scheduling overtime, offloading to another machine, outsourcing the overflow, or reducing setup time. If gaps persist across quarters, that is the business case for capital. The recommended action column prompts these options per row.
How is capacity planning different from takt time?: Takt time sets the pace for a single balanced line to meet demand in seconds per unit. Capacity planning works at the aggregate level, comparing total required hours against available hours across many machines or cells over weeks or months. Takt answers how fast one line must run today; capacity planning answers whether the whole plant can absorb next quarter's forecast and where the bottleneck resources sit.
How often should I refresh a capacity plan?: Refresh monthly as part of the S&OP cycle, and immediately when a major forecast change or large order lands. Demand shifts, routing changes, and downtime all move the numbers. Reviewing the gap column each S&OP meeting lets you commit overtime or outsourcing 4 to 8 weeks ahead rather than firefighting. Keep the utilization rate current, since a machine's real availability drifts as it ages.