Rate Wizard

Also know as the Price Matrix and Rate Matrix

Open Rate Matrix Section of the Rate Wizard

To navigate to the Rate Matrix section of the Rate Wizard please do the following:

Click on the File Menu located in the top left handside of IDS Core.
Then select “Rate Wizard”
When the Rate Wizard opens, click on Price Matrix
You will see something like this
At this point, its a good idea to use the zoom located on the bottom of the tab
And the “Resize” mouse over by placing your mouse over the bottom right hand side of the screen
To adjust the tab to best suit your needs.
For more information on how to make the IDS Core container fit your screen, click here: Control the IDS Core Applications Container

(back to the top)

How to create/edit a Rate using Rate by Fixed price

To create a new rate rate using the rate by fixed price, please do the following:

Ensure that “Rate by fixed pricing” has been selected
Next, you will need to unlock the Rate Matrix by clicking the 'Unlock” button
A Unlock Pop Up will appear, click on “yes”
You will now see the following message
The next step is to select the Package Type and Service Level you wish to create
1. If you have not already created your Service Levels, please click here: Service Levels
2. If you have not already created your Package Types, please click here: Package Types
To do this, first select the Package Type from the first dropdown (please note because Package Type are defined and created by your company, your dropdown will display different Package Type )
Then select the package type from the second dropdown. (please note because Service Levels are defined and created by your company, your dropdown will display different Service Levels)
Before starting to enter in rates, its best to explain how to read the Rate Matrix
1. If you have not already created your zones, please click here: Zone Wizard
2. You will see your Zones across the top and along the left hand side of the screen. (please note because Zones are defined and created by your company, your matrix will display different Zones)
3. You will noticed that the Zones across the top are the same zones that are along the left hand side of the matrix.
4. To enter in a rate select the “From” zone on the left hand side and the “To” zone from the top
5. Using the example above, if you want to enter in a rate “From” Vancouver (outlined in green in image below) “to” Surrey (outlined in blue in image below) you will select the cell highlighted in red.
To enter a rate into the selected cell, double click the cell. The cell will change to Yellow.
Then type in your rate
Continue this one with each cell.
Some Trip and Tricks.
1. You can use Microsoft Copy and Paste Hot keys. To do this:
  1. double click into a cell that contains the price you which to copy
  2. Then press “Ctrl” and “a” to highlight the entire rate
  3. Then press “Ctrl” and “c” to copy the highlighted rated
  4. Now click into the cell you wish to paste the rate into
  5. Now press “Ctrl” and “v” to paste the rate into the cell
  6. Continue to paste the copied rate into as many fields as need.
2. You can initialize the cells to a rate. The is helpful when all your rates are the same OR most of the cells continue the same rate. To do this:
  1. Ensure “Initialize values to:$” has been selected
  2. In the field beside “Initialize values to: $”, type the value you wish to have entered into all the fields
  3. Then click “Modify Values”
  4. You will now see the rate will appear in all the cells of the Rate Matrix

13. When you have completed making all your changes, click the “save” button located on the bottom of the matrix.

14. Then lock the rate wizard by click on the unlock button

(back to the top)

How to create/edit a Rate using Rate by Lane pricing

To Edit/Create a Lane Price, please do the following:

Click the Radial Dial labelled “Rate by Land Pricing”
At the bottom on the screen you will see the following
Click on Edit
This will open the Lane Formula Pop Up
Now we need to make our first condition.
To do this, in the first dropdown, select if the condition will be based on Pieces, Weight or Mileage
Then select if the condition will be greater than, less then, etc
Then enter in the conditions number. Meaning if “pieces is less than 5”, then enter in 5
(Advanced - Optional) If you need more to the condition, then click on the dropdown immediately to the right.?
And select And/Or. Then create another condition.
Steps 9 and 10 above are Advanced - Optional steps. You dont need to do this unless you have an advanced rate.
In the “Results” enter in the dollar amount for this condition. Using our example from above of “if pieces is less than 5 then the price is $5”, then you would enter in 5 into this field.
If the rate is not a “Fixed price”, but something more advanced, then click on the radial dial beside “Formula”
This will change the field so that you can create a formula
The first field would be where you would enter in a base price
In the next field, select what field will be used to calculate the rate
If you select one of the fields with a + or - beside it another field will open up directly to the right of this dropdown. In this field the amount you wish to add or subject from the selected field. For example if you rate is “Piece - 1”, you would enter in “1” into this field.
Then select your mathematical symbol in the next dropdown. For example if your rate is “Pieces time 5”, then you would select “*”
Then in the next field enter in the number that will be used to calculate your rate. Using our example of if your rate is “Pieces times 5”, then you would enter in 5.
(Advanced - Optional). If you need a more advanced rate, then click on the dropdown below your newly created formula.
Then select if you going to add + or subject - from your rate
Another clone of the formula generator will appear. Repeat stems 16 to 19 above.
Click the “Save” button when done.
If you need to add more to your rate, then click on the +
This will allow you to repeat the above steps to add more to your rate.