Warehouse utility report - Dock Scheduler
Who can use this feature? This feature is available to CargoON and Trans for Forwarders users who have access to Dock Scheduler and to BI Reports. Reports are visible to selected users designated by the company that ordered access. Learn more about BI Reports. |
With data from the Warehouse utility report, you can:
- see how traffic is distributed across your warehouse,
- check whether operations finish according to the booking schedule,
- find out the most common causes of delays,
- check the operational efficiency of your warehouses and logistics processes,
- get information that helps you make decisions on optimising warehouse management,
- identify areas for improvement.
Navigating the Warehouse utility report
To open the report, click the BI Reports module, then select the Dock Scheduler tab and Warehouse utility.
The report consists of 2 main parts:
- Bookings in time section - the upper section, where a donut chart, a bar chart and a calendar show the number of bookings completed on time or late, together with information on which side caused the delay.
- Bookings per day & operation place section - the lower part, with tables showing the number of bookings by day and by operation place, so you can analyse how they are distributed over time and across locations.
How the report assesses punctuality
The report focuses primarily on whether bookings are carried out according to schedule. It assesses punctuality from two sides:
- Carrier punctuality - we compare the time the carrier arrived at the warehouse with the planned start of the booking. The carrier is late if they arrived later than the carrier delay tolerance allows.
- Warehouse punctuality - we compare the actual end time of the operation (loading or unloading) with the planned end of the booking. The report does not check when the operation started. What matters is whether it finished on time, because this determines whether the next booking at the same dock can start as planned.
Bookings that finished late (Carrier delay (unrecovered) and Warehouse delay) can disrupt the schedule and delay subsequent bookings. Bookings that finished on time are On time and Carrier delay (recovered).
Setting the scope of analysed data
You define the scope of analysed data using the filters and parameters in the Filters panel.
- Click the filter icon in the right-hand column to open the report's filter settings. Here you can select: warehouse, carrier, dock and operation type.
- Set the period (Booking date) for which you want to view data.
- Set the delay tolerance in minutes for the carrier (Carrier delay tolerance) and the warehouse (Warehouse delay tolerance).
- Carrier delay tolerance - how many minutes after the planned start of the booking the carrier can arrive and still be considered on time by the report.
- Warehouse delay tolerance - how many minutes after the planned end of the booking the operation can still finish without being considered late.
For the warehouse tolerance, choose when it applies (Apply ‘Warehouse Delay Tolerance’ to):
- All arrivals - the tolerance is added to every booking.
- Late arrivals only - the tolerance is added only to bookings where the carrier arrived late, i.e. later than the carrier delay tolerance allows. If the carrier arrived on time, the warehouse had the entire booking window available, so no extra time is added.
If the operation finishes after the tolerance has expired, the report shows the number of minutes of delay counted from the end of the tolerance period.
Example 1a - warehouse tolerance applies to all arrivals. Unloading was scheduled for 8:00-9:00. The carrier arrived at the warehouse at 7:54 and unloading finished at 9:05. Result: On time, because:
- the carrier arrived on time (the same would apply to an arrival at 8:04, as it is within the 10-minute carrier tolerance),
- the end of unloading is within the 10-minute warehouse tolerance.
Example 1b - warehouse tolerance applies only to late arrivals. Unloading was scheduled for 8:00-9:00. The carrier arrived at the warehouse at 7:54 and unloading finished at 9:05. Result: Warehouse delay, because:
- the carrier arrived on time, so the warehouse tolerance is not added (the same applies to an arrival at 8:04 - it is within the carrier tolerance, so it does not count as late),
- unloading finished after the planned end of the booking.
Examples 1a and 1b describe the same situation. The result depends only on which warehouse tolerance option you select.
Example 2 - carrier late, warehouse made up the time. Unloading was scheduled for 9:00-10:00. The carrier arrived at 9:15 and the warehouse finished handling at 10:04. Result: Carrier delay (recovered) (with both warehouse tolerance settings), because:
- the carrier's arrival exceeds the 10-minute carrier tolerance,
- the end of unloading is within the 10-minute warehouse tolerance.
Example 3 - carrier late, operation finished late. Unloading was scheduled for 10:00-11:00. The carrier arrived at 10:15 and the warehouse finished handling at 11:15. Result: Carrier delay (unrecovered), 5 minutes of delay (with both warehouse tolerance settings), because:
- the carrier's arrival exceeds the 10-minute carrier tolerance,
- the end of unloading exceeds the 10-minute warehouse tolerance by 5 minutes.
Example 4 - carrier on time, operation finished late. Unloading was scheduled for 11:00-12:00. The warehouse tolerance applies to all arrivals. The carrier arrived on time, but the operation took longer and the warehouse finished handling at 12:15. Result: Warehouse delay, 5 minutes of delay, because:
- the carrier arrived on time,
- the end of unloading exceeds the 10-minute warehouse tolerance by 5 minutes.
Booking punctuality statuses
Based on the tolerances you set, the report assigns each booking one of the following statuses:
- On time - the carrier arrived on time and the operation finished on time,
- Carrier delay (recovered) - the carrier arrived late, but the operation finished on time,
- Carrier delay (unrecovered) - the carrier arrived late and the operation finished late,
- Warehouse delay - the carrier arrived on time, but the operation finished late,
- Incomplete data - not enough data (booking statuses) to assess punctuality.
Statuses are shown in the report's charts and tables, colour-coded according to the legend.
Bookings over time - Bookings in time
In this part, you will find data on the number of bookings finished on time and late - according to the parameters and filters you have set.
The data is presented as:
- a donut chart,
- a calendar,
- a bar chart.
- The donut chart shows the total number of operations in the selected period, broken down by punctuality status.
- Calendar
The calendar shows the number of bookings by day of the week and hour, based on aggregated data from the selected date range. You can check how many operations took place on specific days and at specific hours, broken down by punctuality status.
The values on the right side of the calendar show the total number of operations for each day of the week.
The values at the bottom of the calendar show the totals of operations for each hour.
The information in the calendar reflects the filter and parameter settings applied to the entire report.
- Bar chart
In the bar chart, you can check the number of operations on individual days. Each bar is colour-coded according to punctuality status.
When you hover over a part of a bar, you will see details, e.g. how many bookings on a given day had the Warehouse delay status.
Bookings by day and operation place
The Bookings per day & operation place section shows detailed information on when and where operations took place, in two tables:
- The first table contains the columns: date, warehouse, dock and number of bookings. It lets you check how many operations took place on a given day in individual warehouses and at specific docks - broken down by punctuality status (according to the parameters set earlier).
- The second table shows the details of each booking: booking number, operation type, start date and time, warehouse, dock, carrier and punctuality status. Punctuality is shown as a text status: On time, Carrier delay (recovered), Carrier delay (unrecovered), Warehouse delay, Incomplete data.
