Negotiation report

Updated 15 hours ago by Katarzyna

Who can use this function?

Function available to CargoON and Trans for Forwarders users who have purchased the complementary product: Business Intelligence reports.

Reports are visible to users selected by the company ordering access.

Learn more about BI reports.

The Savings Management report is part of a group of price reports that enable comprehensive analysis of freight costs and rates carried out via the Trans.eu Platform. With these reports, you can:
- 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 data from the Negotiation report you can:

  • check what savings were achieved or could have been achieved on individual freights,
  • see the negotiation process for each freight in the form of a chart,
  • plan your strategy for future price negotiations based on historical data
To access the report, click the BI Reports module, then select the Negotiations tab.

Parameters that allow you to set the number and status of freights and how to sort them.

  1. KPI with summarized data for the entire company, based on selected filters.
  2. Top directions table with data on negotiations for the most popular routes with the largest number of loads per route or by offer discrepancy (between the initial proposal and the finally accepted conditions).
  3. Total directions table with data on negotiations for specific freights and routes.
  4. Negotiation flow chart showing the course of negotiations for the selected freight or route.
  5. Negotiation view chart with information about carriers.

Setting the range of analyzed data

You can define the range of analyzed data using filters.

  1. Click the filter symbol in the right column to open the Negotiations report filter settings.

Filtering
In the filters you can set:

- 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.

  1. From the drop-down list under KPI Choose freight status you can select the freight status (accepted, not accepted, partially accepted or all).​
​A partially accepted freight can be, for example, a multifreight in which 5 out of 10 transports have been accepted and the publication time has already passed.

The selection of this parameter affects the data displayed in the Top directions and Total directions charts.​

KPI - Negotiations

​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.

Top directions table

​The table presents the most popular routes on which offers were submitted and negotiated. Data can be displayed by the largest number of freights on the route or the largest offer discrepancy.​

​For each direction, you can check:​

  • ​the total number of unique freights that were negotiated (All freights),​
  • ​the total number of unique carriers that participated in negotiations on a given route (Carriers negotiated),​
  • ​the total value of all accepted freights on a given route (Money paid),​
  • ​the value calculated per freight (Cost per freight).​

​You can set the parameters of the data displayed: select the number of the best routes displayed and the type of sorting.

Click on the selected direction to see information about specific freights negotiated for that direction in the Total directions table.​

Total directions table

The table presents data for the total number of directions, including:​

  • ​freight number,​
  • ​exact loading and unloading address,​
  • ​name of the employee who published and negotiated the freight offer,​
  • ​number of carriers negotiating a given freight,​
  • ​accepted price for a given freight,​
  • ​value of the minimum offer for a given freight,​
  • ​value of the maximum offer for a given freight,​
  • ​average price per kilometer.

There is a piggy bank icon next to some freights. It appears when the transaction ended with an amount lower than the amount proposed by the carrier.

You can choose the sorting type and display data for:

  • All freights,
  • ​non-savings freights,
  • ​savings freights.

Based on the data from Total directions, you can evaluate:

Employee efficiency - check which of your employees is the most effective in negotiations, e.g. an employee who regularly achieves small differences between the maximum offer and the accepted price can be considered a good negotiator.

Attractiveness of offers - check which destinations are most often negotiated by carriers.

Negotiation effectiveness - you can compare how negotiations are progressing on selected routes and decide where you can set higher offer rates.

Negotiation flow chart

This section shows the progress of negotiations on selected routes.

To view the data, click on the selected freight in the Total directions table.

After selecting a route, the first column will show the data of all carriers who participated in the offer negotiations on this route.

In the second column, a bar chart shows the negotiation process — in pink, offers submitted by the shipper and in blue - by the carrier.

Hover your mouse over a selected bar to display a tooltip with additional information.

Negotiation view chart

​This is a chart that shows a general view of the negotiation process. Prices that were negotiated are marked in blue, accepted amounts in navy blue.​

​You can view data by:​

  • carrier:​

  • without detailed breakdown​

At the bottom of the table, the hours during which negotiations took place are marked.

Hover your mouse cursor over a selected value to display additional information.

Additional features​

  1. The "i" icon - hover over the icon to see detailed information about the range of data.​


How Did We Do?

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