Lean Training for your lean journey


Takt Time Calculation

Sometimes misspelled tact time, tack time, or tac time

takt time drumbeat

What is Takt Time

Your planning drumbeat.

How often completed units NEED to come out the end of the pipe —

as established by customer demand

and perhaps adjusted for Sales & Operations Planning factors,
as explained in the Takt Time training

Takt Time Formula

Takt Time = Working Time Available / Customer Demand

Which sounds easy until you run into issues with units of measure.

When and Why to use your

Takt Time Calculator

Takt Time Caclulator

If you don't yet own it,
download it now:
Takt Time Calculator

Use your Takt Time Calculator (Takt.xlsx)
whenever you need to calculate:

Benefits of this Takt Time Calculator

  1. It correctly handles units of measure
  2. It calculates Pitch (which your workers should care about more than Takt Time)
  3. It comes with training (below)

Bookmark = how

How to use your

Takt Time Calculator

Find and open your template

Systems2win menu > Systems2win templates

Find and open your Takt Time Calculator (Takt.xlsx)
in the same way that you find and open
your other 150+ Systems2win templates.

Note: Even though this is a Word template,
you open it using your Systems2win menu in Excel

Save your working document, following the usual
document storage and naming conventions
established by your leaders.

If English is not your native language

Switch to your language, just like every Systems2win Excel template.

Open a Blank Sheet

Systems2win menu > Open a Blank Sheet

When you're ready to start doing your own real work...

click the button to 'Open a Blank Sheet'

Excel Ribbon bar > Systems2win tab > Open a Blank Sheet

This blank sheet is where you will do your real work

(not on the Sample sheet)

Rename your new sheet

Tip: You have as many sheets as you want — for different demand scenarios.

For example, you might have a sheet for Christmas demand and another for July demand.

Enter your header data

Takt Time Calculator

Usually, the only header data needed
might be Title, Author, and Revised Date.

You can optionally unhide the row for user-defined header data,

and you can copy that row
for unlimited rows of user-defined header data.

In the grey area above the Links header,

you might use one or more Link Icons to provide hyperlinks
to other documents that use the results of this Takt Time Calculator.

Calculate Work Time Available

Work Time Available

Work Time Available per Day = (Minutes Available per Shift + Overtime - Meals - Breaks - Change Overs - Planned Downtime - Unavailable Time) * Shifts per Day

Work Time Available per Day is calculated
using the values that you enter in the pink double-border fields.

Work Days per week(typical)

Shifts per day(typical)

Hours per shift(typical)

Overtimeincreases Work Time Available

Meals minutes for lunch or other major meal break

Break Minutes per Shift

Enter minutes for other regular-scheduled breaks.

Change Overs

Enter the number of minutes for beginning & end of shift setup/breakdown,
as well as batch change overs.

Tip: Like every Systems2win template, you can optionally use your Custom Formula Zone
to clarify "How did you come up with THAT number?"

Tip: Whenever you see a red anchor link in any Systems2win template,
that means that you can click it to quickly jump to another place within that workbook.

In this case... cClick the red anchor link to quickly go to the Custom Formula Zone.

Planned Downtime

Routine daily maintenance. Periodic maintenance. Or any other planned shutdown.

Other Unavailable Time

Typical time per day unavailable to work on THIS value stream —
due to things like other responsibilities, setup, clean up, routine maintenance, meetings...

Enter Demand

Demand per Week

In the pink double-border cell, enter Demand per Week.

How many are needed per week?

If Sales & Operations Planning demand is different from actual customer demand, use S&OP demand. (In other words, plan to deliver the quantity that your management tells you to deliver.)

If your source data is in some other time measure,

(such as Demand per Month, or Day, or Shift...)

Takt Time Caclulator

You'll get a lot more out of this training if you have your template open in front of you

See the Help and Sample sheets for examples, learning exercises, pop-up help, Excel tips, and other training aids

then you will need to convert it into Demand per Week

Optionally click the red anchor link to go to the Custom Formula Zone,
where you can use all the power of Excel
to explain "where did that number come from?"

Demand Unit of Measure

In the pink double-border cell, enter the Demand Unit of Measure.

What is being delivered to the customer?

Examples of the thing being processed.

Demand per Shift

Demand per Shift = (DemandWeek/WorkDaysWk)/ShiftsPerDay

Takt Time Calculation

The primary purpose of this Takt Time Calculator is to calculate Takt Time.

Takt Time Formula = Work Time Available / Demand

(both Work Time Available and Demand must be per Week)

Calculate Pitch

Home Run


The pace at which work is released,
and moves through the value stream.

Pitch = Takt Time * Pitch Batch Size

Learn more about Pitch

Pitch Batch Size

The batch size of work released to the pace setter process.

which establishes the work flow batch size for most upstream and downstream processes

Learn more about Pitch Batch Size

Link to and from your Takt Time Calculator

Link Icons

Links to related documents

In the grey area above the Links header,

you might use one or more Link Icons to provide hyperlinks
to other documents that use the results of this Takt Time Calculator.

In the Links column

you might use one or more Link Icons to provide hyperlinks
to any source documents or training for any row.

For example:

In the row for Demand, you might link to your source document(s) for your sales forecast and/or your Sales & Operations Plan.

Links from related documents

If you follow our suggestions for Document Storage and Naming Conventions

and you save your Takt Time workbook in the same folder
alongside the many other related documents
for analyzing the same process in different ways for different purposes...

then you can easily use what you know about familiar Microsoft Excel to Link Cells

to auto-populate with your latest Takt Time
whenever it changes in your one central Takt Time Calculator
shared by perhaps several related documents.

Systems2win menu > Copy Sheet

Add a Takt Time Calculator to any document

Or you can copy your Takt Time Calculation worksheet
to any other Systems2win template

using the special Copy Sheet utility.

This Takt Time Calculator comes with
many other useful Lean Tools for process improvement



priced low enough to empower every team member

Return to Lean Dictionary






menu bottom




If your organization has not yet provided a license, you can download your free trial

The Takt Time Calculator has no trial expiration. Use it for the rest of your career as a free gift.



Own All 150+ Templates for
Continuous Process Improvement













Your Systems2win templates come with free New User Training to quickly learn features that are common to all 150+ templates
























Why re-invent?

Why re-invent?