How to run the Route Optimisation Report

How to run the Route Optimisation Report

The Route Optimisation Report allows users to analyse the carrier options that have been selected and compares the price and the ETA of the route selected against all the other potentially available routes. This allows users to pinpoint areas of price or margin leakage and attempt to understand why there are discrepancies and adjust pricing or processes where necessary. 

How to generate the Route Optimisation Report

1. Select Reports and Route Optimisation Report.                       

   
                                  


2. You will then be able to view the Route Optimisation Report Modal, and set the configuration fields below:
                                     


3.  Select a Date/Date Range. 





 3. Set the configuration fields for the report including:

I. Select a route type:

The Route Type drop-down will allow users to limit the data returned in the report to be: 

  • Show all - This will show all of the routes for consignments created during the period selected.
  • Show cheaper and quicker options - This will just show the routes where there was either a cheaper option or a quicker option available.
  • Show cheaper options - This will just show routes where there was a cheaper option available.
  • Show quicker options - This will just show routes where there was a quicker option available. 


II. Select the Filter fields

The filter fields in the image below are not required fields, however, the more information entered the more specific the report will be. 

These fields are:

Company - This will be the company you want to run the report for.
                                                    



Include Children Flag - If you want to run the report for an organisation, set the company filter as the parent company and then set the Include Children Flag to be YES. 

Company From and To Locations - This will be the name of the sending or delivering company location.

From and To Location - This will be the name of the sending or delivering suburb.

User - This will be the username of the user who created the consignments. 


Once filled in, click on Get Route Optimisation Report.


Note: When entering in any information MachShip will auto-generate a list of valid Company/Locations/Users. 

5. Select Get Route Optimisation Report

MachShip will start to gather and put together a file. It will download at the bottom of the screen, just click on it to open.


Report Delivery Methods

The Route Optimisation Report is generated and delivered in two ways:

  • The file automatically downloads at the bottom of the screen when generation completes.
  • The report is also emailed to your registered email address.

Troubleshooting Email Delivery: If you do not receive the email, check your spam or junk folder — email filters may have caught the report. If the email does not arrive, you can always access the file via the download link at the bottom of the screen.

 

How to read the Route Optimisation Report

The Route Optimisation Report will contain the following fields:

ConsignmentId - This is the MachShip ID of the consignment.

Company Name - The company which the consignment was created against.

From and To Location, Suburb, and Postcode - Location details of the consignment.

# Items, Total Weight and Total Cubic - Consignment details which were used to generate the price. 

User - The user who created the consignment.

Despatch Date and Time - This will show the desired despatch date and time which was used to generate the route options. This can be important when determining why a user selected a particular service level. 

Original Values

  • Carrier - The carrier which the consignment was sent with.
  • Service - The service that was booked.
  • Transit - The transit time (in days) which the consignment was supposed to have met. 
  • Base - The base price, rate card and surcharges.
  • Fuel - The fuel surcharge price.
  • Total (Ex Tax) - The total of the base and fuel price.

Difference Values

  • Carrier - The carrier that was the cheapest carrier to send the consignment with.
  • Service - The service that was the cheapest to book with. 
  • Transit - The transit time (in days) for the cheapest route available.
  • Base - The base price, rate card and surcharges price for the cheapest service.
  • Fuel - The fuel surcharge price for the cheapest route.
  • Total (Ex Tax) - The total of the base and fuel price for the cheapest route.

Running List of Alternate Routes

MachShip will list each of the other available routes which would have been presented to a user. These will be shown as:

Row 1 - Carrier Name.

Row 2 - Carrier Account Name (Account Code).

Row 3 - Carrier Service. 

Every route option that was cheaper will be highlighted in Yellow.

Every route option that was quicker will have its transit highlighted in Orange. 


The cons with which the carrier it was booked from is highlighted in Green.

Use Cases for the Route Optimisation Report

Carrier Performance Analysis

Use this report to compare how often you select one carrier vs. alternative carriers available for the same routes. Identify if you're consistently choosing more expensive or slower options. This helps you understand carrier selection patterns and optimize your routing decisions.

Batch Carrier Comparison

Rather than manually testing multiple consignments against different carriers, run the Route Optimisation Report for a date range covering your shipments. The report will show all available carrier options that were presented at the time of booking, allowing you to analyze carrier performance across multiple shipments in one view. This is particularly useful for brokers and freight managers who need to evaluate carrier options across a large volume of shipments.

Cost Optimization

Identify lanes or routes where cheaper or faster alternatives were available but not selected, helping you optimize carrier selection rules or pricing strategies. Use the report to pinpoint specific routes or time periods where margin leakage is occurring and take corrective action.