Warehouse utility report - Dock Scheduler
Updated 6 months ago
by
Katarzyna
Who can use this function? Function available to CargoON and Trans for Forwarders users who have purchased the supplementary product: Business Intelligence reports and have access to the Dock Scheduler product. The reports are visible to the users specified by the company requesting access. Learn more about BI reports. |
Based on data from the Warehouse utility report, you can
- check how traffic is distributed in your warehouse,
- find out the most common reason for delays,
- check the operational efficiency of your warehousing and logistics processes,
- get information to help you make decisions on optimising your warehouse management,
- identify areas for improvement.
Navigating the Warehouse utility report
To access the report, click on the BI reports module and go to the Warehouse utility tab.
The report consists of 3 main parts:
- The top bar with parameters referring to the delay tolerance (expressed in minutes): Carrier arrived (concerning carrier delay) and Operation started (delay of warehouse operations) as well as information on the selected time interval.
- No. of operations - the middle section, where you use a doughnut chart, bar chart and calendar to determine the number of operations that were carried out on time or were delayed (both on the carrier's and warehouse end).
- Operations time - the bottom section with charts showing the hourly times of operations (on time and delayed).
The data presented in the report refers to 1 warehouse (you can select the warehouse using filters). The period for which the data is displayed is also determined by the filter option. It is described at the end of the article.
Delay time tolerance
In the top section of the report, you can use the slider to set the acceptable delay time for the carrier.
The time frame is up to 20 minutes. We distinguish between 2 tolerance times:
- when the carrier arrives too early,
- when the carrier arrives late.
The situation will be the same if the carrier arrives at the warehouse at 7:55 a.m.
Operation started
This parameter is used to set the accepted delay time for the start of the operation (loading or unloading).
The time frame is up to 20 minutes.
No. of operations
In the No. of operations section, there is data showing the number of on-time and delayed operations - distinguishing whether the delays were caused by the carrier or the warehouse.
The data is presented in the form of:
- a doughnut chart,
- a calendar,
- a bar chart.
- The parameter above the doughnut chart allows you to decide whether or not an early arrival is considered to be on time.
The chart on the left illustrates the situation when arriving ahead of schedule is still considered to be on time. The chart presents the following figures:
- Total - sum of operations,
- on time - operations carried out on time (grey),
- carrier delay - delayed operations on the carrier's end (yellow),
- warehouse delay - delayed operations on the warehouse end - e.g. the carrier arrived on time, but there were no free docks available at the warehouse (red),
- not happen - operations that were not performed - loading or unloading did not take place (dark blue).
The chart on the right illustrates the situation when arriving ahead of schedule is not considered to beon time. The chart presents the following figures:
- Total - sum of operations,
- on time - operations carried out on time (grey),
- carrier too early - operations where the carrier arrived ahead of schedule (grey),
- carrier delay - delays caused by the carrier (yellow),
- warehouse delay - delayed operations on the warehouse end - e.g. the carrier arrived on time, but there were no free docks available at the warehouse (red),
- not happen - operations that were not performed - loading or unloading did not take place (dark blue).
- Calendar
The calendar allows you to see how many operations carried out on a given day were:
- scheduled,
- delayed,
- on time.
The values on the right side of the calendar show how many operations were performed on a given day of the week.
The values at the bottom of the calendar allow you to see how many operations took place at specific times.
The information in the calendar is displayed according to the filter settings of the entire report.
- Bar chart
The number of operations can also be viewed on the bar chart:
- on time - carried out on time
- not happen - those for which loading or unloading did not take place,
- carrier delay - those where the carrier was late,
- carrier too early - those where the carrier arrived ahead of schedule,
- warehouse delay - those where the delay occurred on the warehouse end.
Select the type of operation you want to view and the data on the chart will adjust to your selection.
The data can be grouped by any of the following parameters:
- day of the week,
- day of the month,
- hour of the day.
The way the data is displayed is selected by using the Data aggregation option.
Operations time
The Operations time section presents the time of operations in two charts:
- "Total" linear chart [hour] - where the total time of operations expressed in hours is shown,
- "Average" bar chart [hour] - with the average time of operations, also expressed in hours.
The Total chart displays the data by category:
- total operation time,
- total operation delay time.
When one of the options is selected, the chart data is adjusted.
The colours in the chart correspond to those in the legend next to the doughnut chart.
The Average chart displays the data by category:
- average operation time,
- average operation delay time.
When one of the options is selected, the chart data is adjusted.
The colours in the chart correspond to those in the legend next to the doughnut chart.
Filtering
The data can be filtered in 5 ways:
- Select the option to display data in Arriving earlier is on time.
- Click on the given category in the doughnut chart under No. of operations.
- Select the options in the bar chart under No. of operations.
- Select the display options under Operations time.
- Set the appropriate filters in the filter menu.
Click on the filter icon in the right column to open the filter settings for the Warehouse utility report.
In the filter settings you can:
- select a booking date (Booking date),
- select a warehouse (Warehouse name),
- select a ramp name (more than one) (Ramp name),
- select a carrier (Carrier name),
- select type of operation (Operation type).
