Understanding the KPI Dashboard for Air Export Jobs

This dashboard tracks three key performance indicators (KPIs) and their due dates based on different shipment terms. The due dates are calculated from specific milestones in the shipment process.

1. The Columns

• Job Type: This is the type of shipment. In this case, all rows are for "AIR EXPORT".

• Shipment Terms: These are the Incoterms, which define the responsibilities of the buyer and seller. The image shows the following terms:

  • FCA (Free Carrier): The seller delivers the goods, cleared for export, to a carrier nominated by the buyer at a named place.

  • FOB (Free on Board): The seller places the goods on board a vessel nominated by the buyer.

  • CIF (Cost, Insurance, and Freight): The seller is responsible for the cost, insurance, and freight to bring the goods to a named port of destination.

  • DDU (Delivered Duty Unpaid): The seller is responsible for delivering the goods to the buyer's destination, but the buyer is responsible for paying import duties.

  • DDP (Delivered Duty Paid): The seller is responsible for delivering the goods to the buyer's destination, including the payment of all duties and taxes.

  • EXW (Ex Works): The seller makes the goods available at their own premises, and the buyer is responsible for all costs and risks from that point onward.

• CHA (Customs House Agent): This column seems to indicate the party responsible for customs clearance. "NA" likely means "Not Applicable" or that the internal team handles it, while "Glottis" is a specific agent.

• Customer Invoicing KPI: This KPI measures the time taken to issue the invoice to the customer.

• Product Head KPI: This KPI likely relates to an internal metric for the product head, possibly for operational or data completion tasks.

• Job Closing KPI: This KPI tracks the time taken to finalize and close the job file.

2. The Key Metrics and Due Date Calculations

The due dates for each KPI are defined by a number of working days from a specific event.

For FCA, FOB, and CIF Shipments:

All three KPIs are calculated "from ATD".

• ATD stands for Actual Time of Departure of the flight.

  • Customer Invoicing KPI: Due date is 2 working days from ATD.

  • Product Head KPI: Due date is 4 working days from ATD.

  • Job Closing KPI: Due date is 5 working days from ATD.

For DDU, DDP, and EXW Shipments:

All three KPIs are calculated "from ATA".

• ATA stands for Actual Time of Arrival of the flight at the destination.

  • Customer Invoicing KPI: Due date is 5 working days from ATA.

  • Product Head KPI: Due date is 9 working days from ATA.

  • Job Closing KPI: Due date is 10 working days from ATA.

For [ANY] Shipment Terms:

The due date calculation depends on the CHA.

• With CHA = Glottis:

  • The due dates for all three KPIs are calculated "from ACD".

  • ACD likely stands for Actual Customs Clearance Date.

  • Customer Invoicing KPI: Due date is 2 working days from ACD.

  • Product Head KPI: Due date is 4 working days from ACD.

  • Job Closing KPI: Due date is 5 working days from ACD.

• With CHA = [ANY]:

  • Similar to the above, the due dates are calculated "from ACD".

  • Customer Invoicing KPI: Due date is 2 working days from ACD.

  • Product Head KPI: Due date is 4 working days from ACD.

  • Job Closing KPI: Due date is 5 working days from ACD.

3. How to Interpret and Use the Dashboard

1. Identify the Shipment Type: First, look at the Shipment Terms for a specific job.

2. Determine the Starting Point: Find the corresponding "Metric" column (ATD, ATA, or ACD) for that row.

3. Calculate the Due Date: Use the number of "working days" to calculate the due date for each KPI.

   • For example, for an FCA shipment, if the ATD was a Monday, the invoice would be due on Wednesday (Monday + 2 working days).

   • For a DDU shipment, if the ATA was a Friday, the invoice would be due the following Friday (Friday + 5 working days, excluding weekend).

4. Track Performance: The dashboard allows you to see if your team is meeting the defined deadlines. If a task is completed after the calculated due date, it is considered a KPI failure.

This structure provides a clear, standardized way to measure operational efficiency across different types of air export shipments.