Free Capacity Planning Excel Template
A practical Excel workbook for matching work-center capacity against forecasted demand — built by manufacturers, used to find bottlenecks before they break the schedule.
What you get
A working capacity planning Excel template plus a 30-day trial of Resource Manager for Excel (RMX) — the same tool manufacturers use when their static capacity model can no longer keep up with weekly demand changes.
Free 30-day trial · No credit card required · Used by manufacturers since 1991
Why manufacturers still use Excel for this
Capacity planning is the most underrated discipline in manufacturing. Every operations manager knows that running over 100% capacity is a disaster — but very few have a clear, current answer to "what is our actual available capacity next month, and how does it compare to our committed orders?" The result is the same in shops everywhere: customer due dates get committed without checking, work centers get overloaded, expedites pile up, and the schedule becomes a daily firefight.
A capacity planning Excel template will not solve all of that. But it will give you a clear, current picture of demand vs available hours per work center per week — which is the single most important input to every other production decision you make. If you cannot see your capacity load, you cannot manage your bottleneck. And if you cannot manage your bottleneck, you cannot improve throughput.
This page gives you a free template that does the math correctly: available hours by work center, by week, against the demand from your open work orders. It also explains the warning signs that mean your business has outgrown a static capacity model — and what to do when that happens.
What's inside the template
Work-center master list
Every machine, work cell, or skilled-operator group that limits your throughput. Capacity calculations roll up from this sheet.
Available hours calculator
Per work center, per week — accounting for shift patterns, planned downtime, holidays, and an OEE adjustment so the numbers reflect reality.
Demand load sheet
Per work order, hours required by work center — populated from your work order list or routing table.
Load vs capacity comparison
Side-by-side weekly view showing where you are over capacity (red), under capacity (green), and at risk (amber).
Bottleneck identification report
Sorts work centers by sustained utilization to surface the constraint resource — the one your throughput is actually limited by.
Headcount and overtime planner
Quick what-if for adding shifts, hiring, or overtime — shows the capacity uplift before you commit to the cost.
How to use this template
A practical walkthrough — five steps from blank spreadsheet to a working schedule.
- 1
List your work centers
On the Work Centers tab, enter every resource that limits throughput. Be ruthless about what counts — if it never gets fully loaded, it is not a bottleneck and not worth tracking here.
- 2
Set realistic available hours
For each work center, enter shift hours, days per week, planned downtime, and a realistic OEE percentage (most manufacturers should use 65–75%, not 100%). This produces the "available hours" number every other tab depends on.
- 3
Load demand from your work orders
On the Demand tab, list each open work order with its routing — which work centers it touches and how many hours each operation needs. The load sheet sums these by week.
- 4
Review the load-vs-capacity heat map
Open the Heat Map tab. Red cells are weeks where demand exceeds available capacity — those are the weeks you cannot deliver on time without action. Amber is a warning. Green is healthy.
- 5
Plan corrective action
For every red week, decide: shift work to an alternate work center, expedite a different job, add overtime, push out a customer due date, or accept the slip. Update the demand tab and re-check until the heat map is clean.
When you outgrow this template
Excel is the right answer for early-stage scheduling — until it isn't. Here are the warning signs that you need a real production scheduling tool.
If three or more of these apply, you have outgrown Excel scheduling. The good news: you do not have to leave Excel behind. Resource Manager for Excel (RMX) is a real finite-capacity scheduling engine that runs as an Excel add-in — so your team keeps the interface they know while gaining the scheduling power of a dedicated APS tool.
Learn about RMXFrequently asked questions
Is this capacity planning template really free?+
Yes. The template ships with the free 30-day trial of Resource Manager for Excel (RMX) from User Solutions. No credit card, no obligation. Many small manufacturers use the trial indefinitely as a static capacity planning tool.
What is the difference between rough-cut and finite capacity planning?+
Rough-cut capacity planning uses average hours and infinite-capacity assumptions to give you a directional answer in minutes. Finite capacity planning uses real shift calendars, setup times, and resource constraints to give you a schedulable answer in seconds. This template is rough-cut by default; RMX adds finite-capacity logic on top of the same workbook.
Should I use OEE in my capacity calculation?+
Yes — and the most common mistake we see is people NOT applying it. If you assume 100% of theoretical hours are available, you will commit to schedules you cannot deliver. A realistic OEE for most discrete manufacturers is 60–75%; the world-class number is around 85%.
Can I model multiple shifts in this template?+
Yes. The Available Hours calculator supports up to 3 shifts per work center per day, plus weekend operations. Set shift hours and days-per-week per work center; the template handles the math.
What if my work centers share operators?+
A static template cannot handle shared-operator constraints cleanly — that is one of the warning signs you have outgrown rough-cut planning. RMX models operator skill matrices and resource sharing properly.
How does this template differ from MRP capacity planning?+
MRP systems (like SAP, Epicor, Sage) generate capacity requirements from BOMs and routings, but most use infinite-capacity assumptions in the planning run. They tell you how much capacity you need, not whether you have it. This template — and RMX/RMDB — close that gap by enforcing real finite capacity.
Get the free template — plus the tool that grew up around it
The template is the starting point. Resource Manager for Excel (RMX) is what manufacturers move to when their Excel scheduler starts breaking. 35+ years in production, free 30-day trial.