Savings Management report

Updated 2 days 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.

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.

To open the report, select the Savings Management tab in the BI Reports module.

The report consists of 5 -> main sections:

  1. Savings from chart - showing the total generated savings.
  2. Chart with days of the week - presenting the savings achieved on a weekly basis.
  3. Savings per Employee table - the total savings generated by employees.
  4. Savings per direction chart - presents savings generated on specific routes.
  5. Maps with Savings on loading/unloading Country - total transactions divided into loading/unloading countries

The report is based on data extracted from accepted freights, i.e. those which resulted in the conclusion of transactions on the Trans.eu Platform.Data is presented according to the freight unloading date.Exchange rates are converted according to the freight unloading date.

Setting the range of analyzed data

  1. In the upper bar of the report, on the left side, you will find information about the date range for unloading operations for which we present data. You can set the range in the filtering options, on the right side of the chart.
Filtering
Click the filter symbol in the right column to open the filter settings.


In the filter settings you can select:
- range of displayed data (Unloading date),
- Day of the week,
- Loading country,
-Unloading country,
- Employee,
- currency of the transaction (Currency)

  1. Select the chart type:
  • numeric - the savings amounts will be displayed,
  • percentage - the percentage of savings compared to the initial price will be displayed.
For the purposes of this article, the selected parameters are max offer and savings for all parts of the report.

Savings from chart

This is a chart that presents the total amount of accepted freights and the amounts saved during negotiations.

There are two filtering parameters above the chart:

  1. 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.
  1. Week no. - from the dropdown list, select the weeks within the chosen date range for which you want to view the data.
Selecting these parameters will affect the data in the charts and tables in other parts of the report.
When you hover your mouse over the selected part of the chart, detailed information will be displayed.

For this chart, the parameters set are savings resulting from the difference between the maximum offer and the accepted price for several selected weeks.

In week 32, the savings amounted to PLN 481.66 thousand. This means that the maximum offered price was higher by this amount.

Days of the week

The chart with days of the week presents detailed data from the selected range of weeks (specified using the Week no. option) broken down by day of the week (Monday to Friday).

At the intersection of each day with the week number, there is a blue tile - the darker the shade of blue, the greater the savings were on that day of the week.

Next to the blue tiles, for each day of the week, there is a line chart that shows the total savings for each day of the week throughout the analyzed period.

Hovering your mouse over a section of the chart will display additional information in a tooltip.

This approach allows you to quickly identify the most profitable days and weeks in terms of generating savings. 

Savings per Employee table

In this section, you will find a list of employees.

  1. Select the type of sorting: Sort order - Top (from the best results) or Bottom (from the worst results).
  2. 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.
After hovering the mouse cursor over the selected part of the chart, detailed information will be displayed.

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 direction chart

The bar chart shows the routes that generated the greatest savings.

You can specify how many routes should be displayed on the chart (e.g. top 5).

The bars represent the savings for each direction, with their value indicating how much has been saved. For example, for the route from Spain to Poland, a savings of PLN 1,374 was achieved in the selected period compared to the maximum proposed price.

After clicking the bar, the rest of the charts will adjust, presenting the values ​​for the selected route.

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.

If you select a specific direction on the Savings per direction chart, the map will adjust to that choice.

You can zoom in or out on the map view.

After hovering the mouse cursor over a selected point on the map, a tooltip with summary data and a table will be displayed.

Summary data:

  • route
  • loading or unloading address
  • total savings generated for all freights carried out on this route.
  • sum of the final accepted prices after negotiations.

Table:

  • freight number,
  • loading city,
  • unloading city,
  • value of savings for each transaction.

The Savings Management report allows you to identify the most effective negotiations, efficient routes and the best negotiating employees.

Accepted price

The Accepted price chart presents the total value of transactions made over a specified period, along with the median and the extreme (lowest and highest) values.

Total stands for the total value of transactions made on the Trans.eu Platform.

The arrow indicates whether the current value is higher or lower than the value from another selected period.

Hovering the cursor over the arrow shows the period to which the value is being compared. The date range can be changed by filtering.

Employee accepted price

In this section you will find a list of employees sorted by the number of transactions made by them, starting with the highest number and ending with the lowest.

You can compare the negotiation results of individual employees and see which of them generated the highest cost of the concluded transactions and which of them negotiated most effectively.

The list displays up to 9 employees. Use the slider to specify the number of people displayed and the filter to select a specific employee.

By clicking on the employee's name, the rest of the charts will adjust to show the values for the selected person.

How Did We Do?

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