Skip to content
Padmashree
All work
Manufacturing FP&A2026

Hours per unit: the denominator problem

Hours per unit swung from about 39 to 463 across the year. Was the line falling apart?

12x to 2x
spread once read on a minimum weekly volume
30 weeks
modeled, per line and as a rollup
ERP dataExcelUnit economicsProduction ramp

What I found

The line was not falling apart. Every spike in hours per unit lined up with a week we barely built anything. When a week ships 2 units, a normal load of fixed hours divides into a huge number. The metric was measuring volume, not how hard the crew worked.

What I built

A model that pairs weekly hours against units built for the full 2026 year to date, per assembly line and as a rollup, with a minimum-volume filter and a rolling-average option. The point was to stop anyone from quoting a three-unit week as if it were a trend.

How it works

Drag the minimum weekly volume. Weeks below the line drop out, and the headline range recomputes in place. Watch the band on the top chart collapse and the threshold line move across the units chart.

Minimum volume
0units/wk
HPU range
39 to 463
Spread
12.0x
Weeks kept
30/30

No minimum. Range about 39 to 463 hours per unit, roughly 12x, 30 of 30 weeks.

0 units (off)
01220

Raw, hours per unit runs from about 39 to 463 across the built weeks, a spread of roughly 12x. The spikes look alarming.

Hours per unit

0100200300400500

Units built

0102030JanFebMarAprMayJunJulAug

Shown: total across all lines. The model also produces battery pack, EDU, general assembly, full vehicle, and HPC views, weekly, monthly, or quarterly.

Battery packEDUGeneral assemblyFull vehicleHPC
View the weekly data
Week endingHours per unitUnits built
Jan 1745.230
Jan 2448.928
Jan 3138.635
Feb 752.326
Feb 1441.733
Feb 2157.824
Feb 2863.122
Mar 769.420
Mar 1474.618
Mar 2181.216
Mar 2879.014
Apr 476.513
Apr 1160.321
Apr 1855.025
Apr 2578.917
May 284.415
May 982.012
May 1650.127
May 23142.58
May 30168.06
Jun 6158.76
Jun 13205.44
Jun 20223.94
Jun 27n/a0
Jul 4271.63
Jul 11298.23
Jul 18187.35
Jul 25351.02
Aug 1462.82
Aug 8133.99
Aug 1596.511
Illustrative sample data. Total across all lines.

Raw, hours per unit runs from about 39 to 463, a spread of roughly 12x. Set the minimum to 12 units and the range tightens to about 39 to 84, roughly 2x. Same crew, same plant. The swing was the denominator.

Impact

  • The metric became something a director could act on, instead of a number that set off an alarm every low-volume week.
  • It shipped with a rule attached: read it on a minimum volume or a rolling average before it goes in a deck.
  • The same structure supports per-line views for battery pack, EDU, general assembly, full vehicle, and HPC, weekly, monthly, or quarterly.

The transferable lesson

A ratio is only as stable as its denominator. Before a per-unit metric goes near a meeting during a ramp, decide the minimum volume it is allowed to speak at. That one decision is the difference between a number people argue about and a number they can steer by.

The figures in this playbook are illustrative sample data, not any employer's actual numbers. What carries over is the method and the tool, which rebuild for any company.