How to Create and Import Lane Sell Mark-ups

If a user needs to create a set of mark-ups, commonly called sell rates, which are different based on the lane that is selected, then you will need to create a set of Lane Sell Mark-ups.

A lane in MachShip is referred to as a combination of account, service, from zone and to zone.  Lane Sell Mark-ups allows you to configure a different set of percentage increases based on the lane that is returned. 

In order to set these up, you will first need to create an configure the Lane Sell Mark-ups import spreadsheet, you would then need to import them. 

The 2 step process for this is described in the videos below:

1. Set up the MachShip Lane Sell Mark-ups import in the required format

The fully created template should appear like the below:

 Each of the fields can be found by:

2. Populate the Template

Carrier

To obtain the carrier abbreviation go to Admin - Carriers.

You will be provided with a list of all of your accessible carriers. By typing in the search bar, the name of the required carrier will be filtered in. 

The abbreviation will be shown in the second column of the grid. In the example we will be using the abbreviation field will be TNT. If you cannot find your required carrier please contact support@machship.com. 

Once configured you would see the template like the below:

Account

In order to populate the Account field, you will need to ensure that you have created a Carrier Account. The instructions on how to do this can be found at the following link.

Once the Carrier Account has been created we will need to get the abbreviation. To do this go to Admin and Carrier Accounts.

Use the Company or Carrier filters along with the Search bar in order to find the created Carrier Account.

The Account Code will be shown in the second column of the grid.

Once configured you would see the template like the below:

Company Carrier Account

In order to populate the Company Carrier Account field, you will need to ensure that you have created a Company Carrier Account. The instructions on how to do this can be found at the following Link

Once the Company Carrier Account has been created we will need to get the abbreviation. To do this go to Admin and Company Carrier Accounts.

Use the Company, Carrier or Carrier Account filters along with the Search bar in order to find the created Company Carrier Account.

The Company Account Code will be shown in the second column of the grid.

Once configured you would see the template like the below:

Service

To obtain the carrier service abbreviation go to Admin - Carriers.

You will be provided with a list of all of your accessible carriers. By typing in the search bar, the name of the required carrier will be filtered in. 

Select the drop-down cog of the applicable carrier and select view services.

You will be provided with a list of all of the services which have been integrated into MachShip. You can use the search bar to filter to your desired service option. If you cannot find your valid service option please contact support@machship.com.

The Service Abbreviation will be shown in the 2nd column of the grid. 

Once configured you would see the template like the below:

From Zone and To Zone

As it would be impractical to provide a customer with a price from every suburb in Australia to every suburb in Australia, carriers will collect suburbs into groupings known as zones.

These zones will be set based on a similar cost for the carrier to deliver there or if they are a similar transit time. In order to complete the rate card template, you will need to ascertain the from zone abbreviation and the to zone abbreviation.

MachShip has endeavoured to match the zone abbreviations that are used by the carriers in their rate cards. That being said, we have seen that some carriers and sales representatives will provide customised rate card templates which may not conform to other rate cards provided by that carrier. In this circumstance, you will be required to ascertain exactly which zone on your rate card is which zone in MachShip. This link will outline how this can be achieved.

Once you have ascertained the From Zone and the To Zone your template should appear like the below:

Reciprocal

Reciprocal rates will indicate that a particular consignment can be priced either way. For example, if I had a reciprocal rate from Sydney to Melbourne then that would mean that MachShip could price a job with the same rate from both Sydney to Melbourne as Melbourne to Sydney. 

If a rate is reciprocal it will likely be made very obvious in the rate card provided. An example of how this is shown on a rate card is below.

The MachShip import template is expecting this to be either be a Y or an N.

Note that this will need to match up with the buy rate

Once configured you would see the template like the below:

Cubic Conversion Factor

The cubic conversion factor allows for a transport provider to be able to correctly charge for freight which is either cubic or dead weight. The total space and total weight on the truck is one of the large limiters and costs for a transport provider, therefore, being able to create a charging mechanism which can compare large, light freight to small, heavy freight is very important. 

The cubic conversion factor should be made quite clear on the rate card and needs to be inputted into MachShip with the units of kg/m^3. 

The units are important as a carrier may say to you that the cubic conversion is for example 4 cubic per tonne. What you would do is convert this to kg/m^3 by dividing the weight (1000kg) by the cubic metres (4) to get the cubic conversion of 250kg/m^3. 

Commonly used cubic conversion factors are:

250 kg/m^3 or 4 cubic metres per tonne

333 kg/m^3 or 3 cubic metres per tonne

1000 kg/m^3 or 1 cubic metre per tonne

If you wish to sell or markup at a different sell cubic conversion factor then the buy, you would populate this field with the Cubic Conversion Factor. Otherwise, leave this blank. 

Once configured you would see the template like the below:

Mark-Ups

MachShip will then allow you to set the % Mark-up for that individual lane. It is important to note that this will be configured as Mark-up and not Margin, so if your mark-up was 15% then the returned sell amount would be:

Buy x 1.15 = sell

The configuration will allow you to set 2 types of Mark-up either a total mark-up or a set mark-up against the minimum, basic and breaks. 

Note you can only set this as against either the Total mark-up or the individual Break, Minimum and Basic mark-up. 

Once configured you would see the template like the below:

3. Import the Template

Select Admin and Other Options:

Then select Import Lane Sell Markups

Drag and Drop your file into the Upload Section and then select Upload

If there were any errors with the file then MachShip will return then to you. You will need to correct then and then re-upload. Should there be no errors the file will move into the Import section below:

Select the Import type as one of:

- Do Not Reset Rates - Use this if you are adding new rates or updating a set of existing rates

- Reset Accounts - Use this option if you wish to remove any mark-ups that are in the system for this company carrier account and replace them with your upload file

- Reset Account and Service Combination - Use this option if you wish to remove any mark-ups that are in the system for this company carrier account / Service combination and replace them with your upload file

Import the file:

Select the file(s) and then select Import Selected Lane Mark-ups

MachShip will then advise you that the file is successful imported: