PlantOps BI

Labor Productivity

Formula
Units produced divided by total labor hours
Typical range
No universal target; track trend against your own baseline, ideally normalized to standard hours earned rather than raw units
Direction
Higher is better

Open the Calculator Generate the DAX

Labor productivity measures output per hour of labor worked, calculated as units produced divided by total labor hours over the same period. Raw units per hour is the simplest version and the easiest to misread, because it treats every unit as equally labor-intensive, which is almost never true across a mixed product line.

What Good Looks Like

There’s no external benchmark worth quoting here, because labor content per unit varies too much between products and industries for a cross-company comparison to mean anything. The useful version of this metric compares actual labor hours against standard hours earned, the engineered labor content of whatever was actually produced, which normalizes for product mix automatically. A plant holding labor efficiency (standard hours earned divided by actual hours worked) at or above 100% consistently is performing to its own engineered standard, regardless of what raw units per hour looks like on a mix-shifted week.

The trap with raw units per hour is treating a change in product mix as a productivity win or loss. A week that runs more of the simple, low-labor-content SKU will show higher units per hour with zero actual change in how efficiently anyone worked, and a manager who doesn’t know the mix shifted will draw the wrong conclusion from it.

Labor Productivity in Power BI (DAX)

With an hourly production fact, a labor hours fact, and a part dimension carrying standard labor content:

Units per Labor Hour =
DIVIDE (
    SUM ( fact_production_hourly[units_produced] ),
    SUM ( fact_labor_hours[actual_hours] )
)

Standard Hours Earned =
SUMX (
    fact_production_hourly,
    fact_production_hourly[units_produced] * RELATED ( dim_part[standard_hours_per_unit] )
)

Labor Efficiency % =
DIVIDE ( [Standard Hours Earned], SUM ( fact_labor_hours[actual_hours] ) )

Lead with Labor Efficiency % on any dashboard that gets compared across weeks or lines. Raw units per hour is fine as a supporting number, but it shouldn’t be the headline when product mix moves week to week.

Common Mistakes

  1. Comparing raw units per hour across different product mixes. It rewards running easy parts over hard ones, not actual labor efficiency.
  2. Using headcount instead of actual hours worked. Headcount hides absenteeism, overtime, and part-time schedules, all of which change true labor input without changing the headcount number.
  3. Excluding indirect labor that’s required to run the line. Material handlers and line-side quality techs are often necessary to hit the output number; leaving them out of the denominator overstates true productivity.

Table and column names in the DAX above are examples. Use the DAX generator below to fill in your own.

Labor Productivity Calculator

Runs in your browser

Nothing you type is sent anywhere. Your inputs only go into a URL if you click Copy Share Link, and anyone with that link can read them.

Result

Page's typical range: No universal target; track trend against your own baseline, ideally normalized to standard hours earned rather than raw units

DAX Generator

Use My Own Table and Column NamesUpdates as You Type

Type your own table and column names. The measures update as you type. Leave a field blank to keep the example name.

Tables
Columns
Your measures
Units per Labor Hour =
DIVIDE (
    SUM ( fact_production_hourly[units_produced] ),
    SUM ( fact_labor_hours[actual_hours] )
)

Standard Hours Earned =
SUMX (
    fact_production_hourly,
    fact_production_hourly[units_produced] * RELATED ( dim_part[standard_hours_per_unit] )
)

Labor Efficiency % =
DIVIDE ( [Standard Hours Earned], SUM ( fact_labor_hours[actual_hours] ) )