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, from the sample data to a plan built on your own numbers.
- 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 planning, until it isn't. These are the warning signs that you need a real production scheduling tool.
If three or more of these apply, you have outgrown spreadsheet planning. EDGEBIC, the current generation of RMDB, is User Solutions' finite capacity scheduling and production planning software. It imports the same orders, routings, work centers and stock from Excel, CSV or your ERP, schedules them against real machine, labor and material limits, and shows the result on a drag-and-drop Gantt chart. It is a one-time license: EDGEBIC APS is $25,000, and EDGEBIC Complete, which adds MRP, inventory and purchasing, is $35,000.
See EDGEBICNot ready to decide? Read what actually changes when you move off the spreadsheet, or see the published price before you talk to anyone.
Frequently 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.
Start with the spreadsheet. Move to EDGEBIC when it breaks.
The template handles the math for a small plan. EDGEBIC is what manufacturers move to when orders, routings and capacity change faster than a spreadsheet can follow: published one-time pricing, and implementation measured in days.