Warehouse utility report - Dock Scheduler
Updated 1 week ago
by
Katarzyna
Who can use this function? Function available to CargoON and Trans for Forwarders users who 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, go to the BI Reports module, select the Dock Scheduler tab and then Warehouse utility.
The report consists of 3 main sections:
- Parameter settings - in this section you can adjust the range of analyzed data. The settings affect all visualizations and tables in the report.
Available parameters:- Date range - the period for which the data will be displayed.
- Delay tolerance - defines the acceptable time margin when evaluating punctuality.
- Booking statuses - the ability to filter data by selected statuses (e.g. on time, warehouse delay).
- Filters - allow you to display data including warehouses, carriers, ramps and operation type.
- Bookings in time section - the middle section, where you can determine the number of operations that have taken place at a time or were delayed (both on the carrier and warehouse side). You can do this using a doughnut chart, bar chart, and calendar.
- Bookings per day & operation place section - bottom section with tables showing the number of bookings per day and place of operation, enabling analysis of their distribution over time and by location.
How to set the range of data to be analyzed
You can use filters and parameters at the top of the report to specify the range of analyzed data.
- Click the filter symbol in the right column to open the report filter settings. You can select the following: warehouse, carrier, ramp in warehouse, operation type.
- Specify the period (Date range) for which you want to view the data.
- Set the delay tolerance in minutes for carrier (Carrier delay tolerance) and warehouse (Warehouse delay tolerance).
Example 1
Unloading is scheduled for 8:00 The carrier arrived at the warehouse at 8:09, which is within the 10-minute tolerance limit, so the report will consider it a timely arrival.
The same applies if the carrier arrives at 7:55.
Example 2
Unloading is scheduled for 10:00. Although the carrier arrived on time, the earlier operation was delayed, causing the warehouse to start service at 10:15. In this case, the report will show a five-minute delay on the warehouse side.
- Select the statuses you want to include in the analysis:
- delays caused by both the carrier and warehouse (carrier & warehouse delay),
- delay caused by the carrier (carrier delay),
- bookings that did not take place (not happened), e.g. the carrier did not reach the warehouse,
- bookings made on time, taking into account the time of tolerance (on time),
- delay caused by the warehouse (warehouse delay).
Bookings in time
In this section, you will find data on the number of operations performed on time and with a delay, according to the parameters and filters you set.
The data is presented using the following methods:
- a doughnut chart,
- a calendar,
- a bar chart.
- The doughnut chart illustrates the total number of operations during a specified time period, categorized by selected statuses.
The chart contains figures on:
- Total booking - total number of operations,
- on time - operations performed on time (green),
- carrier delay- delay caused by the carrier (yellow),
- warehouse delay - delay caused by the warehouse, e.g. the carrier arrived on time, but there were no ramps available (maroon color),
- carrier & warehouse delay - delay caused by both the carrier and warehouse (pink),
- not happen - operations that have not been carried out, e.g. unloading did not take place (purple).
- Calendar
The calendar shows the number of bookings by day of the week and time, based on aggregated data from the selected date range.
You can check how many operations took place on specific days and times, divided into punctual and delayed bookings.
When you click on the cell, the other parts of the chart will adjust accordingly.
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 total number of operations for each hour.
The information shown in the calendar matches the filters and parameters applied throughout the report.
- Bar chart
In a bar chart, you can check the number of operations per day. The bars are divided by color according to the delay statuses that were selected at the top of the report.
When you hover over a selected part of the bar, you will see detailed information, e.g. how many bookings on a given day were delayed because of the carrier and warehouse
Bookings per day and operation place
The Bookings per day & operation place section presents detailed information about the time and place of the operation in two tables:
- The first table contains the following columns: date, warehouse, ramp and booking count. It allows you to check how many operations took place on a given day in individual warehouses and at specific ramps - divided into punctual and delayed notifications (according to previously set parameters).
- The second table presents the details of each booking: booking ID, operation type, start date, warehouse, ramp, carrier and punctuality status.
The information on punctuality is presented in the form of a colored square. According to the legend, the square indicates a delay caused by the carrier, the warehouse or both.
