Machine Utilization Formula: How to Calculate It (Calculator)

Short answer

Machine utilization = run time ÷ available time × 100. Available time is usually the planned time (shifts minus breaks); against the full 24-hour day it is calendar utilization. A machine planned for 900 minutes that ran 690 has 76.7% utilization — and 47.9% of the calendar day.

The formula

Machine utilization formulas, worked on the default example
Measure	Formula	Example
Planned time	Shifts × (shift length − planned breaks)	2 × (480 − 30) = 900 min
Utilization	Run time ÷ planned time	690 ÷ 900 = 76.7%
Calendar utilization	Run time ÷ 1,440 min (24 h)	690 ÷ 1,440 = 47.9%
Idle in planned time	Planned time − run time	900 − 690 = 210 min

Machine utilization calculator

Change any number; the result updates as you type. The defaults are one CNC on two shifts.

Utilisation (planned time)

76.7%

Run time ÷ planned time: 690 ÷ 900 min.

Calendar utilisation: 47.9%; 690 of 1,440 min in the day
Idle in planned time: 210 min; Stops, setups, waiting — find the reasons

Planned vs calendar utilization: which one to use

Planned and calendar utilization compared
	Planned utilization	Calendar utilization
Divides run time by	Shifts the machine was scheduled for, minus breaks	All 24 hours, every day
Answers	Did the machine run when we planned it to?	How much of the machine's life is it working?
Use it for	Daily management, finding stops	Capacity: add a shift before buying a machine
Example	76.7%	47.9%

Utilization vs OEE

Utilization stops at “was it running?”. OEE carries on: availability (much like planned utilization) × performance (did it run at the ideal cycle?) × quality (were the pieces good?). A machine can run all shift at half speed making rejects and still show high utilization. Use utilization for capacity; use OEE to find the losses inside the running time. Work an example through in the OEE calculator or the guide to calculating OEE.

Machine utilization in Excel

Machine utilization formulas in Excel
Cell	Holds	Formula
B2	Shifts	2
C2	Shift length (min)	480
D2	Breaks per shift (min)	30
E2	Run time (min)	690
F2	Planned time	=B2*(C2-D2)
G2	Utilization	=E2/F2 (format as %)
H2	Calendar utilization	=E2/1440
Week	Utilization for the week	=SUM(E2:E8)/SUM(F2:F8)

Downtime by reason, which explains the idle minutes, goes in the free downtime log template.

What a machine utilization report should show

Utilization per machine per day, against planned time — with the idle minutes split by reason.
The same machine week on week, so a slipping machine shows before it becomes a delivery problem.
Calendar utilization per month for the machines you are thinking of replacing or adding a shift to.

Measured by hand, run time is the hard part. OpeEye records it per machine from the controller, a counting box or the operator’s tablet, and shows utilization live — ₹399 per machine a month.

See utilization for every machine, live.

OpeEye records run time from the machine or the operator's tablet and splits the idle time by reason. Free 15-day trial.

Book a demo WhatsApp us

Questions shop owners ask

What is the machine utilization formula?

Machine utilization = run time ÷ available time × 100. If a machine is planned for 2 shifts of 480 minutes with 30 minutes of breaks each, it has 900 minutes available; running 690 of them is 76.7% utilization.

What is the difference between planned and calendar utilization?

Planned utilization divides run time by the time the machine was scheduled to work (shifts minus breaks). Calendar utilization divides by all 24 hours. The same 690 minutes of running is 76.7% of planned time but 47.9% of the calendar day — the second number tells you whether to add a shift before buying a machine.

What is a good machine utilization rate?

There is no single benchmark: a machine that changes jobs three times a shift can't match one running the same part all week. The useful comparison is each machine against itself, week on week, with the idle time split by reason. Against calendar time the ceiling is set by your shifts — one 8-hour shift can never exceed a third of the day.

How is machine utilization different from OEE?

Utilization only asks whether the machine was running. OEE also asks whether it ran at full speed and made good pieces: OEE = availability × performance × quality. A machine can show 90% utilization and 55% OEE if it runs slowly or makes rejects.

What is spindle utilization?

Spindle utilization counts only the time the spindle is actually cutting, not time in cycle with the spindle stopped (tool changes, probing, loading). It is read from the CNC control and is always lower than machine utilization; it shows how much of the cycle is real cutting.

How do I calculate machine utilization in Excel?

Put planned minutes in one column and run minutes in the next; utilization is =run/planned, formatted as a percentage. For a week, divide the sum of run time by the sum of planned time — don't average the daily percentages, or a short day counts as much as a long one.