Continuous Improvement

How to Calculate Manufacturing Efficiency in Excel

A simple efficiency calculation can help identify jobs that need process review.

By Shaunak

Basic formula

Efficiency % = Planned Hours ÷ Actual Hours × 100

Equation diagram: Planned Hours divided by Actual Hours, multiplied by 100, equals Efficiency percent.

This is a labor or performance efficiency metric — it compares how long a job was estimated to take against how long it actually took. That's a different measurement than utilization or OEE, which look at how much of the available time was spent producing at all, rather than how a specific job compared to its own estimate.

Excel formula

If planned hours are in cell B2 and actual hours are in C2:

=IFERROR(B2/C2,0)

Format the result as a percentage.

Spreadsheet mockup with columns B, C, and D. Row 1 headers: Planned Hours, Actual Hours, Efficiency. Row 2: 1.936, 2.33, and cell D2 selected showing the formula equals IFERROR of B2 divided by C2, comma zero, in the formula bar, with a result of 83.1%.
D2 selected — format the cell as a percentage after entering the formula.

IFERROR exists for data hygiene, not business logic: a job with zero actual hours logged, whether from a data-entry gap or a job that hasn't started yet, would otherwise throw #DIV/0! and break any report or chart built downstream of the cell.

Example

Planned time: 1.936 hours. Actual time: 2.33 hours.

Efficiency = 1.936 ÷ 2.33 × 100 = approximately 83.1%.

Bar comparison of planned hours, 1.936, against actual hours, 2.33, with the resulting efficiency of 83.1 percent shown as a highlighted result.

2.33 actual hours against 1.936 planned hours means the job took about 20% longer than estimated (2.33 ÷ 1.936 ≈ 1.203), which is where the 83.1% comes from — the formula is just the inverse of that ratio, scaled to a percentage.

Use the result carefully

Efficiency should be reviewed together with quality, downtime, rework, material shortages, and job complexity.

Hub diagram with Efficiency percent at the center connected to five factors to review alongside it: quality, downtime, rework, material shortages, and job complexity.
A high number can hide rework and downtime; a low one can hide a hard job.

A single efficiency number can't distinguish between an operator working slowly and a job that had a material shortage, unplanned downtime, or necessary rework baked into the actual hours — none of which reflect on the person doing the work, and all of which drag the percentage down. It cuts the other way too: a standard time that's set too generously makes every job look artificially efficient. And if this number gets used to evaluate people rather than to flag jobs worth investigating, it stops being reliable — people learn to pad actual-hours reporting or push for looser planned times, and the metric ends up measuring the gaming rather than the work.