Report - Carrier On Time (Dock Scheduler)

Updated 2 weeks ago by Katarzyna

Who can use this function?

The function is available to CargoON and Trans for Forwarders users who have purchased a supplementary product: Business Intelligence Reports and have access to Dock Scheduler.

Reports are visible to selected users specified by the company requesting access.

Learn more about BI Reports.

Based on data from the Carrier On Time report:

  • you will check the punctuality of your subcontractors,
  • you will be able to influence the improvement of cooperation with subcontractors,
  • you will improve the efficiency of the warehouse,
  • you will be able to reward the most punctual carriers.

To go to the report, click on the BI reports module, and then select the Carrier On Time tab.

The report consists of 8 main sections:

  1. Range of date - specifies the time range.
  2. Delay time range (min) - a parameter that defines the time of the accepted delay.
  3. % number of operations over time - a chart presenting warehouse data for a specific day.
  4. Total numbers of operations - a donut chart showing the total number of all operations.
  5. Number of operation delay at time range (min) - the graph shows the number of delays in a specific time range.
  6. % of operation for carriers - the total number of operations performed by a specific carrier.
  7. Total number of operations by warehouse - a list of all operations showing their total number, as well as delayed and completed operations in given warehouses.
  8. Distribution of operations over time per carrier - view of operations per day, categorized by carrier.

The report is based on data obtained from the Dock Scheduler module.

Punctuality and delays of the subcontractors are determined based on scheduled booking times compared to the actual arrival times at the warehouse.

Range of date

Information on the time range of the presented data. You can specify the time range using filters - we describe it below.

Delay time range (min)

A parameter that allows you to specify the time of the accepted delay.

  • you can set the delay time using slider or arrows,
  • the minimum range is 1 minute,
  • the maximum range is 20 minutes,
  • the delay time you specify in this section will apply to all charts in the report.

In the example, the accepted delay time is 11 minutes. This means that a carrier with a delay of less than 11 minutes on a specific operation (e.g. arrives at the warehouse 7 minutes after the set time) will not be marked as delayed.

% number of operations over time

This part of the report presents data for a specific day in a specific warehouse:

  • the total number of all operations (shown by the height of the bar),
  • total number of delayed operations (maroon part of the bar),
  • total number of operations that took place on time (grey part of the bar),
  • total number of bookings that did not take place due to the lack of a vehicle (dark blue part of the bar),
  • percentage of delays (shown by the yellow line).

A booking is given a delayed status when the carrier has arrives at the warehouse site after the scheduled booking time. This data comes directly from the Schedules (Dock Scheduler) module.

% total number of operations

The donut chart shows the sum of all operations.

  • the percentage of the total number of bookings with the status of vehicle missing is marked  navy blue. These are bookings that did not take place because the vehicle did not arrive at the warehouse,
  • percentage of the total number of operations on time marked grey,
  • percentage of the total number of delayed operations marked maroon.

Number of operation delay at time range (min)

The chart shows the number of delays in time ranges, which are defined by the Delay time range (min) parameter.

In this example, the Delay time range (min) is 11 minutes. The chart shows how many delays occurred between 11 and 20 minutes, how many occurred between 21 and 30 minutes, and so on.

The bars in the chart are divided. Each part corresponds to a carrier. The intensity of the color in a part of the bar indicates the number of delays of the carrier. The more intense the color, the more delays.

After hovering over the column, you will see a  tooltip with information such as carrier's name, number of operations, and time delay range.

% of operation for carriers

The view presents the total number of operations made by a given carrier and their punctuality:

  • on the navy blue part of the bar, the number of bookings in which the vehicle did not arrive at the warehouse,
  • on the maroon part of the bar, the number of delayed operations,
  • on the grey part of the bar, the number of operations that took place on time,
  • next to the visualization, the percentage of operations made on time (e.g. 80% of operations of a given carrier took place on time).

The data presents the total number of bookings that were delayed or completed on time, indicating specific subcontractors. They are sorted in descending order of the number of operations - the maroon part of the chart refers to the number of delayed operations, the grey part to those that took place on time. The percentage corresponds to the number of bookings completed on time.

Other carriers (link solutions) refers to bookings sent through an external link. Bookings sent via an external link are a solution designed for subcontractors outside the Trans.eu community.

Total number of operation

A list of the total number of operations (loading/unloading) in all your warehouses:

  • Delay (maroon) column - number of delayed bookings.
  • On time (gray) column - number of bookings that have been made on time.
  • Vehicle missing column - the number of bookings that did not take place because the vehicle was missing.
  • Grand Total (white) column - the sum of all the bookings. Data is sorted in descending order.

You can hide this section of the report. To do this, click on the 4 squares icon.

Distribution of operations over time per carrier

This is the most detailed view in the entire report. It presents operations performed on a specific day per carrier. You can identify the operation by its reference number. Operations are marked in:

  • grey - operation took place on time,
  • navy blue - booking that did not take place because the vehicle was missing,
  • maroon - delayed operation.

Filtering

Click on the filter symbol on the right to open the Carrier On Time filter settings.

In the filtering settings, you can:

  • specify the operation time range to be displayed - Operation date,
  • select the warehouse/warehouses for which the data should be presented - Warehouse_name,
  • choose the specific location/locations in the warehouse, e.g. , Ramp 1 - Ramp id,
  • choose the name of the carrier/carriers whose punctuality you want to analyze - Carrier name.


How Did We Do?

UP!
Powered by HelpDocs (opens in a new tab)