Savings Management report
Updated 9 hours ago
by
Katarzyna
Who can use this function? Function available to CargoON and Trans for Forwarders users who purchased a complementary product: Business Intelligence reports. The reports are visible to selected users specified by the company requesting access. Learn more about the BI reports product. |
- monitor price trends,
- optimize costs,
- assess the effectiveness of negotiations.
Data source: Data comes from the Freights module.
Data scope: Reports are based on data obtained from the Freights module and cover all freights for which a formal transaction was concluded.
Cost calculation is based on the unloading date.
Currency exchange rates are calculated on the unloading date.
Based on the data from the Savings Management report you can:
- see the results of the negotiations on the Trans.eu Platform,
- check how effectively your employees negotiate, whether they can achieve more favourable conditions compared to the first, lowest and highest offer received,
- compare the performance of your employees,
- find out where negotiations bring the best results.
Navigation in the Savings Management report
To open the report, select the Savings Management tab in the BI Reports module.
The report consists of 5 main sections:
- KPI - showing the values of the entire company
- Savings activity calendar chart - showing the total savings generated per week.
- Savings per Employee table - the total savings generated by employees.
- Savings per direction chart - presents savings generated on specific routes.
- Maps with Savings on loading/unloading Country - total transactions divided into loading/unloading countries
Setting the range of analyzed data
You can define the range of analyzed data using filters.
- Click the filter symbol in the right column to open the Savings Management report filter settings.
Filtering
- Time range of displayed data (Unloading date) - you can specify the time range for the unloading date.
- Publication type - including the ones to the exchange (Exchange), to companies (Company), direct.
- Employee,
- Transport direction of your freight by country (Country directions) - defined by the country code,
- Body type,
- Freight type,
- Capacity range,
- Currency - currency in which prices are shown is displayed above the KPI and with selected indicators. There are two currencies to choose from: EUR and PLN.
- Carrier name,
- Freight number,
- External ID.
- From the drop-down list under KPI you can select the chart type:
- numeric - the savings amounts will be displayed,
- percentage - the percentage of savings compared to the initial price will be displayed.
KPI - Savings Management
The upper bar of the report shows the sum of values for the time period specified in the filters. Values are presented for the time period and currency specified in the filters
Hover over a selected tile, and a tooltip will appear with a description explaining the value presented in the tile.
What do the tiles mean:
- Accepted freights - the total number of published freights, the publication of which resulted in a transaction.
- Freights with negotiation - the total number of freights under negotiation.
- Total km - the number of kilometers traveled.
- Money paid - the total cost of all accepted freights.
- Cost per freight - the cost of one freight in the analyzed time period.
- Cost per km - the average cost of freight calculated for each kilometer traveled.
Savings activity calendar chart
The section consists of:
- A chart that shows the total amount of accepted freights and the amount saved during negotiations.
- A chart with days of the week that presents detailed data from the selected week range (specified using the Week option) broken down by days of the week (Monday to Friday).
Next to the blue tiles, for each day of the week, there is a line graph that shows the total savings for each day of the week throughout the analyzed period.
After hovering the mouse cursor over the selected part of the chart, additional information will be displayed in the tooltip.
Thanks to this approach, you will quickly identify the most favorable days and weeks in terms of generating savings.
There are two filtering parameters above the chart:
- Savings from - an option that lets you choose the reference point to which savings will be compared:
- First price (first offered price) - savings will be presented as the difference between the first offered price and the accepted price.
- Min offer (lowest received price offer) - savings will be presented as the difference between the lowest offered price and the accepted price.
- Max offer (highest received price offer) - savings will be presented as the difference between the highest offered price and the accepted price.For the purposes of this article, the selected parameter is max offer for all parts of the report.
- Week - from the dropdown list, select the weeks within the chosen date range for which you want to view the data.
In week 49, the savings amounted to 89 448 EUR. This means that the maximum offered price was higher by this amount.
Savings per direction chart
The bar chart shows the routes that generated the greatest savings.
You can specify how many routes to display in the chart (e.g. top 10) and sort the values ascending or descending.
The bars show the savings for each destination, and their value shows how much was saved - e.g. on the route from Spain to Poland, €196,033 was saved in the selected period compared to the maximum price offered.
Savings per Employee table
In this section, you will find a list of employees.
- Select the type of sorting: Sort order - Descending (from the best results) lub Ascending (from the worst results).
- Specify how many employees you want to include in the chart: No. of Employees
The chart shows 2 bars next to the employee's name:
- Blue - represents the result for Accepted price, which is the sum of prices that was finally obtained in the negotiation process in the selected period.
- Gray - shows Savings - indicates the sum of savings in the selected period.
You can compare the negotiation results of individual employees and see which of them generated the highest cost of concluded transactions and which of them negotiated most effectively.
Savings per loading/unloading country maps
The map view is closely linked to the Savings per direction chart. The points marked on the map correspond to the directions from the section above. The map shows savings for loading locations on the left, and unloading locations on the right.
Maps show savings for a parameter specified in the Savings activity calendar (e.g. max offer)
You can zoom in or out on the map view.
Additional features
- The "i" icon - hover over the icon to see detailed information about the range of data.
The Savings Management report allows you to identify the most effective negotiations, efficient routes and the best negotiating employees.
