How do you calculate cylinder fleet utilization?

Divide the cylinders in service or rented by the total fleet. 820 in service of 1,000 is 82%, exactly on an 82% target, with 180 cylinders idle or in test, the Cylinder Fleet Utilization calculator's own example.

What counts as in service?

Cylinders at customers, in transit to them, or filled and ready to ship. Empty returns, yard stock and cylinders in test or repair are idle.

What utilization target should I set?

The one your rental pricing and fleet plan assume. The workbook's 82% is an example only, matching the calculator's default.

Can utilization be too high?

Yes. Far above target there may be nothing filled for a new account or a seasonal peak. Watch the empty count in the yard as well as the rate.

Why split idle cylinders into empty and in test?

They need different fixes. Empties in the yard point to demand or distribution between branches; cylinders in test point to requalification capacity. In the example 28 of the north depot's 39 idle acetylene cylinders are in test.

Does the workbook use macros?

No. It is a plain .xlsx with ordinary formulas, tables and native charts. The Verify sheet re-checks the formulas against fixed test counts and shows Self-check: PASS.

Planning and Supply Chain

Cylinder Fleet Utilization Excel Template

Cylinder fleet utilization = cylinders in service or rented ÷ total cylinders in the fleet. Log each count of each cylinder type at each branch and see utilization against target, the cylinders idle or in test split into empty yard stock and test, and the capital tied up in them, at the latest count and month by month.

Free, and a plain .xlsx with no macros to enable. A CSV with live formulas and a printed how-to guide come with it.

Overview

This cylinder fleet utilization template is a working Excel workbook for fleet, depot and operations managers at industrial and medical gas distributors, fillers and welding supply businesses. Each count of one cylinder type at one branch is one row with the whole fleet of that type, the cylinders at customers or in transit, those filled and ready to ship, and those in hydrostatic test, requalification or repair; each type's replacement value comes from Setup. The workbook gives the cylinders in service, utilization against your target with a status in words, the cylinders idle or in test split into empty yard stock and test, and their capital at replacement value. The Dashboard reads the latest count by type and branch, and the whole fleet month by month. It ships with six month-end counts of three types at two depots of a fictional gas distributor, so every tile and chart is filled in when you open it.

In the example the fleet of 1,500 cylinders ran at 81.9% in May against an 82% target and 80.2% at the end of October, with 297 idle or in test worth 88,420 at replacement value. Two lines explain it. At the north depot a requalification backlog grew from 10 to 28 acetylene cylinders in test, taking that line to 67.5%. At the south depot a lost fabrication account left argon mix at 74.9%, with 80 empties in the yard. Oxygen at both depots finished above target.

Cylinders lost or long overdue at customers count as in service; reconcile them separately. Capital idle is at replacement value, not rent lost. The download is a plain .xlsx with no macros. A CSV with live formulas is also included for other tools; the dashboard, charts, dropdowns and self-check are in the .xlsx.

What this template includes

Setup sheet with your company, currency, target utilization and near band, the branches, and the cylinder types with their replacement value
Counts table, one row per count of one cylinder type at one branch: fleet, at customers, filled and ready, and in test, with a Check column
Per line: cylinders in service, utilization, gap to target in points, a status in words, idle or in test, empty in the yard and the capital in idle cylinders
Dashboard with four tiles at the latest count (fleet utilization, idle or in test, capital in idle cylinders, lines below target), idle cylinders by month split into empty and in test, where the cylinders are by type, and the type, branch and month tables
Method sheet with every formula, and a Verify sheet that re-checks the formulas against an independent reference and the Cylinder Fleet Utilization calculator (Self-check: PASS)
CSV with live formulas for the Counts table; the dashboard, charts, dropdowns and self-check are in the .xlsx

Suggested use case

Use it for a monthly fleet review by branch, to decide whether to buy more cylinders or move them between depots, or to size a requalification backlog.

How to use it

On Setup, type your company, currency, target utilization and near band, and list your branches and cylinder types with their replacement value.
On Counts, give each fleet count of each type at each branch a row: date, fleet, at customers, filled and ready, and in test.
Fix anything the Check column names.
Open the Dashboard: utilization against target at the latest count, and the trend by month.

Frequently Asked Questions

How do you calculate cylinder fleet utilization?: Divide the cylinders in service or rented by the total fleet. 820 in service of 1,000 is 82%, exactly on an 82% target, with 180 cylinders idle or in test, the Cylinder Fleet Utilization calculator's own example.
What counts as in service?: Cylinders at customers, in transit to them, or filled and ready to ship. Empty returns, yard stock and cylinders in test or repair are idle.
What utilization target should I set?: The one your rental pricing and fleet plan assume. The workbook's 82% is an example only, matching the calculator's default.
Can utilization be too high?: Yes. Far above target there may be nothing filled for a new account or a seasonal peak. Watch the empty count in the yard as well as the rate.
Why split idle cylinders into empty and in test?: They need different fixes. Empties in the yard point to demand or distribution between branches; cylinders in test point to requalification capacity. In the example 28 of the north depot's 39 idle acetylene cylinders are in test.
Does the workbook use macros?: No. It is a plain .xlsx with ordinary formulas, tables and native charts. The Verify sheet re-checks the formulas against fixed test counts and shows Self-check: PASS.