Data & reporting · Free Excel template

Container Terminal Productivity KPI Report Template

A monthly Excel report for a container terminal: gross and net crane rate, berth productivity, hours at berth, berth occupancy, truck turnaround, yard utilization, equipment availability and idle share. Enter vessel, gate, yard and equipment rows, and the dashboard compares each KPI with your target and shows a 12-month trend.

Free: enter your name, email and job title and we email you the file. It works in Excel 2019 or later, Microsoft 365, Google Sheets and LibreOffice Calc, with no macros.
  • 10 KPIs, no macros
  • Status against your targets
  • 12-month trend and chart
safee-terminal-productivity-kpi-report-en.xlsx
KPIThis monthTargetStatus
Gross crane rate (moves/h)27.325.0On target
Hours at berth per call28.924.0Off target
Truck turnaround (min)6460Close
Yard utilization65%65%On target
Equipment availability94%90%On target
Example data for October. Targets are examples: enter your own on Settings.
What's in the file

Quay, gate, yard and equipment on one monthly page

Enter the rows you already have in vessel reports, gate records and hour meters. The dashboard does the arithmetic and weights each average the right way.

  1. 01

    Dashboard

    Ten KPIs for the chosen month with target and status, monthly totals, the highest yard utilization, a 12-month trend and a chart of crane rate and truck turnaround.

  2. 02

    Vessel calls

    Berthed, first lift, last lift and unberthed times, cranes, moves, TEU, gross crane hours and delays; gross and net crane rate, berth productivity and idle time at berth per call.

  3. 03

    Gate

    Daily truck visits, average turnaround, visits over the target time and the wait before the gate.

  4. 04

    Yard

    Daily containers on hand and storage capacity, with utilization and a mark on days above your target.

  5. 05

    Equipment

    Monthly possible, breakdown, engine and idle hours per machine; availability, use of available time and idle share.

  6. 06

    Settings

    Report month, berths, targets and direction for each KPI, the amber band, and the sources with the date checked.

What does a terminal productivity report measure?

A terminal productivity report puts the month's quay, gate, yard and equipment figures on one page and compares each with a target. It answers the questions a terminal manager, a port authority or a shipping line asks: how fast did the cranes work, how long did ships stay at the berth, how long did trucks spend in the terminal, how full was the yard and how much of the time was the equipment ready to work.

The workbook takes raw rows, one per vessel call, one per day at the gate and in the yard, one per machine and month, and works out ten KPIs for the month you choose, with a status against your targets and a 12-month trend.

Which KPIs are in the report?

KPIHow it is calculatedSource of the definition
Gross crane rateMoves ÷ gross crane hoursTIC 4.0 Productivity Gross
Net crane rateMoves ÷ (gross crane hours − delay hours)Crane productivity per crane-hour, UNCTAD 2012
Berth productivityMoves ÷ hours at berthShip productivity per hour at berth, UNCTAD 2012
Hours at berth per callUnberthed − berthed, averaged over callsTime at berth, the core of the World Bank CPPI
Berth occupancyHours at berth ÷ (berths × hours in the month)UNCTAD 2012
Truck turnaroundVisit-weighted average of daily turnaroundTIC 4.0 Truck Turnaround Time
Visits over the target timeVisits over target ÷ visitsYour own target
Yard utilizationContainers on hand ÷ storage capacityUNCTAD 2012
Equipment availability(Possible − breakdown hours) ÷ possible hoursUNCTAD 2012
Idle share of engine hoursIdle hours ÷ engine hoursHour meters and the tracking system's idle report

Why measure these every month?

  • Ships compare ports by time: the World Bank's Container Port Performance Index ranks ports by the time vessels need for their calls; in the 2024 edition, reported in September 2025, Hamad Port was first in the Gulf and 11th of 403 ports.
  • Gates and yard limit the quay: a full yard or a slow gate shows up later as slower cranes and longer berth stays.
  • Equipment hours drive cost: breakdown hours cut availability, and idle engine hours burn fuel and bring services forward.

How to fill in the workbook

  1. Settings: pick the month, enter the berths in service, your targets and whether higher or lower is better for each KPI.
  2. Vessel calls: one row per call with berthed, first lift, last lift and unberthed times, cranes, moves, gross crane hours and delay hours, from the vessel report or your terminal operating system.
  3. Gate and Yard: one row per day with truck visits, average turnaround, visits over target, containers on hand and capacity.
  4. Equipment: one row per machine and month with possible, breakdown, engine and idle hours.
  5. Dashboard: read each KPI with its target and status, and the 12-month trend with a chart.

Worked example: October in the sample data

  • 23 vessel calls with 40,450 moves give a gross crane rate of 27.3 moves an hour against a 25 example target: On target.
  • Ships stayed 28.9 hours at the berth on average against a 24-hour example target: Off target, which points to the time between berthing and the first lift and after the last lift.
  • 30,159 truck visits averaged 64 minutes of turnaround against 60: Close, inside the 10% band.
  • Equipment was available 94% of possible hours, and 36% of engine hours were idle.

The sample rows and targets are examples to show how the workbook works, not data of any terminal.

Common mistakes in terminal KPIs

  • Mixing gross and net hours. A crane rate means little without saying which hours it divides by.
  • Averaging averages. The workbook weights turnaround by visits and crane rates by hours, not by days or calls.
  • Counting hatch covers as moves in one month and not the next. Keep one rule for what a move is.
  • Targets nobody agreed. Set targets with the shipping lines, the port authority and your own operations team.

What the template does not cover

The workbook calculates from the rows you enter; it does not connect to a terminal operating system, crane systems or the port authority. It reports one terminal; copy it per terminal. The 70% berth occupancy and 65% yard utilization targets are the limits used in the Tanzania Ports Authority example presented at UNCTAD in 2012, given as examples only. All sample rows are examples.

Sources

  • TIC 4.0, Productivity Gross KPI definition, version 20240412. Source: TIC 4.0.
  • TIC 4.0, Truck Turnaround Time KPI definition, page updated 4 June 2024. Source: TIC 4.0.
  • H. Mwasenga, Tanzania Ports Authority, Port Performance Indicators: A case of Dar es Salaam port, UNCTAD Ad Hoc Expert Meeting on Assessing Port Performance, 12 December 2012. Source: UNCTAD.
  • Gulf Times, 25 September 2025: Hamad Port first in the Gulf and 11th globally in the World Bank and S&P Global Container Port Performance Index 2024. Source: Gulf Times. Last reviewed 21 October 2026.
Related Safee solution

Fill the equipment rows from tracking, not from paper

Safee covers the machine and truck side of the report: engine running and idle time from the Vehicle Idle Time and Advanced Vehicle Idle reports, active and non-active time from the Equipment Activity report, and geofence entry and exit times for your vehicles. Crane moves and vessel times come from your terminal operating system; Safee does not read them.

  • Vehicle Idle Time and Advanced Vehicle Idle reports with engine-on standing time for each machine.
  • Equipment Activity report with active and non-active duration from a digital input on the machine.
  • Scheduled reports sent by email on the schedule you set, with Excel export.
  • Vehicle Geofence Movement Details report with entry and exit times at the geofences you draw around gates and yard areas.
FAQ

Questions about terminal productivity KPIs

Want engine and idle hours for every machine without typing them? Talk to Safee.

What is gross crane rate?

Moves divided by gross crane hours, the hours each crane was logged on the vessel from start to finish of its work. TIC 4.0 defines gross productivity as moves over logged hours. Net crane rate divides by the hours left after delays.

What is the difference between crane rate and berth productivity?

Crane rate divides moves by crane hours; berth productivity divides the vessel's moves by its hours at the berth, so it shows how many cranes worked and how long the ship waited before and after work.

How is truck turnaround time measured?

From the end of gate-in to the end of gate-out, as TIC 4.0 defines it. The workbook takes a daily average and weights it by visits for the month.

What is a good yard utilization?

It depends on the terminal and the stacking system. The Tanzania Ports Authority example at UNCTAD in 2012 used 65% as a maximum to avoid congestion; set your own target.

Can the workbook take data from tracking?

Yes, for the equipment rows: engine and idle hours come from the tracking system's reports. Crane moves and vessel times come from the terminal operating system or vessel reports.

Does it work in Google Sheets?

Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets. In Excel it needs Excel 2019 or later, or Microsoft 365. It also works in LibreOffice Calc.

Next step

Get equipment hours and idling every month without typing

Tell us how many machines and vehicles you run, and we will show you how Safee reports engine, idle and active time for each of them on a schedule.

Related tools and templates

More for ports and fleet reporting

Get the report

Enter your details and we will email you the file.

Use your real name so the file arrives addressed to you. Don't worry, we won't flood you with emails or calls.

Scroll to Top