Free Bottleneck Analysis Excel Template
Theory of Constraints worksheet to identify your real bottleneck, calculate throughput impact, and make capacity investments that actually unblock the system.
What you get
Working bottleneck analysis template that calculates capacity utilization, queue time, and throughput per work center. Identifies the constraint — the only place where capacity investment moves the needle.
Free 30-day trial · No credit card required · Used by manufacturers since 1991
Why manufacturers still use Excel for this
Theory of Constraints is the most under-applied idea in manufacturing. Eli Goldratt's insight is brutally simple: every system has one bottleneck, and investing in capacity anywhere else makes things worse. Most shops invest in the loudest work center, not the constraint, and wonder why nothing improves.
Identifying the real bottleneck requires data, not gut. The bottleneck has three signatures: (1) work piles up in front of it, (2) it runs at near-100% utilization while others run at 60–70%, (3) it sets the throughput of the entire system. A work center with high utilization but no queue is not a bottleneck — it is just busy.
This template captures the data needed to identify the real constraint: utilization per work center, average queue waiting in front of each, average cycle time, throughput rate. Three months of data makes the bottleneck obvious. After that, every capacity dollar goes to the constraint until it stops being the constraint.
What's inside the template
Work center capacity input
Per work center: available hours per shift, hours scheduled, actual hours run, idle hours, downtime hours.
Utilization calculation
Actual run hours ÷ available hours per work center, per shift. The first signature of the bottleneck.
Queue waiting analysis
Hours of work-in-process waiting in front of each work center. The second signature.
Throughput rate
Units completed per available hour. The throughput of the system equals the throughput of the bottleneck — no other work center matters for total output.
Constraint identification
Combined utilization + queue + throughput rank surfaces the bottleneck. The work center on top is where capacity investment pays.
Investment ROI calculator
For a proposed capacity addition: how much does throughput improve? The calculation that gets the capex approved.
How to use this template
A practical walkthrough — five steps from blank spreadsheet to a working schedule.
- 1
Capture 30 days of work center data
Daily capture of hours scheduled, hours run, downtime hours, and ending queue per work center. 30 days is enough to see the pattern; less is noise.
- 2
Calculate utilization and queue per work center
The template does the math. The bottleneck shows up as the work center with highest utilization AND highest queue. High utilization without queue = correctly sized. High queue without utilization = different problem (setup, breakdown).
- 3
Apply Theory of Constraints discipline
Exploit (run the bottleneck at maximum efficiency — never let it sit idle), subordinate (schedule other work centers to feed the bottleneck), elevate (invest only after exploitation is maxed).
- 4
Re-measure quarterly
When you elevate the bottleneck, the constraint moves. The bottleneck this quarter is not the bottleneck next quarter — the analysis has to be repeated.
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
How do I tell the difference between a bottleneck and a busy work center?+
A bottleneck has BOTH high utilization AND a persistent queue in front of it. A work center with high utilization but no queue is correctly sized — it is just busy. The queue is the key signature; without it, you do not have a constraint, you have full throughput at that station.
What does "subordinate to the constraint" mean in practice?+
It means non-bottleneck work centers should slow down to match the bottleneck's pace. Running upstream work centers at full capacity just builds inventory in front of the bottleneck. Running downstream work centers at full capacity is impossible — they cannot run faster than the bottleneck feeds them.
Should I always invest in the bottleneck?+
Yes — until you have exhausted exploitation. Theory of Constraints says EXPLOIT first (run the bottleneck at maximum efficiency without spending money: reduce setup, eliminate downtime, ensure material always ready), THEN elevate (invest in more capacity). Most shops skip exploit and go straight to elevate, which is expensive.
What if my bottleneck moves every week?+
A constantly moving bottleneck usually means: (1) high mix and the constraint depends on job mix, or (2) inadequate data and you cannot see the real constraint. Either way, the template surfaces it. For high-mix shops, the constraint is often a class of resource (skilled operators, specific tooling) rather than a single work center.
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.