Lean Manufacturing

Takt Time in a Spreadsheet: The Layout That Survives a Demand Change

A takt spreadsheet that hardcodes available time is a spreadsheet you will rebuild every quarter. Separate the three inputs properly and a demand change becomes one number, not an afternoon.

Takt time is the simplest calculation in lean manufacturing and the one most often built wrong in a spreadsheet. The formula is available time divided by customer demand. The failure is structural: people bury shift patterns, break schedules, and downtime allowances inside the available-time cell as a single hardcoded number, so when demand moves or a shift is added the whole sheet has to be reasoned through again. Split those inputs onto their own rows and takt becomes genuinely live.

Three input blocks, one output

Block one is time: shifts per day, hours per shift, days per period, and paid breaks. Block two is losses: planned maintenance, changeover, and a realistic unplanned downtime allowance, each as a percentage with its own cell so you can argue about them separately. Block three is demand, in units for the same period. Takt is a single formula referencing all three. The discipline is that no number appears twice anywhere in the sheet, which means a shift pattern change touches exactly one cell.

Work it through. Two shifts of 8 hours across 5 days is 4,800 gross minutes. Subtract 30 minutes of break per shift, which is 300 minutes, and apply a 5% allowance for unplanned stops, leaving about 4,275 available minutes. Against demand of 900 units, takt is roughly 4.75 minutes per unit. Every one of those inputs is visible and challengeable, which is the point.

Takt is not cycle time, and the gap is the plan

Takt is the rhythm demand requires. Cycle time is the rhythm your process delivers. The gap between them is the entire content of a line balance exercise, and a spreadsheet that shows only takt is doing half a job. Add a column of measured station cycle times next to the takt figure, and the bottleneck names itself: any station whose cycle exceeds takt caps the line regardless of what the others do. Running cycle time meaningfully below takt is not a win either, it is idle capacity you are paying for.

Takt is what the customer asks for. Cycle time is what the line gives. Every balance decision you will ever make lives in the distance between them.

The allowance is where honesty enters

The downtime allowance is the one input people fudge, because a generous allowance makes takt longer and therefore easier to hit. Derive it from your own records rather than picking a comfortable figure: total unplanned stop minutes over total scheduled minutes for the last complete quarter. If that number is uncomfortable, the spreadsheet is doing its job. A takt calculation built on an optimistic allowance produces a line balance that fails in the first bad week and gets blamed on the operators.

Use the takt time calculator to check the figure your spreadsheet produces. Calculate takt time

Published 2026-08-08.