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