Prices tab in CPC
Prices are set at the Route level and depend on a parameter called EntryIntervalType. This parameter was set on the main page in Calculation Type -> Measurment -> MaxWeightAndVolumeWeight.
To add a new Price condition select New. The user is prompted for three parameters:
Value From, Value To which establish Weight intervals and Step which defines the minimum increment in weight for the range formed by the values entered in Value From and Value To.
Looking at the provided price matrix we observe 26 Weight intervals. For each interval there are 64 possible distance intervals that can be covered. Therefore, there will be 26 x 64 = 1664 total price entries in this tab for our example to cover the entire matrix.
Looking at the table it is observed that the prices in the table are given in SEK/100 kg therefore the Step for all weight intervals is 100 kg. For the intervals we establish them to start with the number listed in the column Vikt (kg) and end just before the next marking, effectively creating an open boundary interval of the form 1000-1200 kg (in effect it contains values from 1000-1199.99 kg) for our first entry. Combined with the Step provided above we conclude that the price will have the same values as 1000kg for weights between 1000-1099 kg and 1100kg for 1100-1199 kg. If more precision is required from the price quote, a Step of 50kg could be defined, however the values SEK/100 kg in the table would also need a conversion factor of 0.5 applied to them.
We construct the first interval:
Like previously stated each weight interval will have an associated 64 possible Routes associated with it, each with its own price value.
We start with the price corresponding to RouteZ1 (1-20km) and read from the table the value 49.5 SEK/100kg. The minimum shipping weight is 1000kg, therefore the minimum price will be:
Step/100*Minimum Weight=Value From
The value for Value To is left to be anything by assignment of the character * (asterix). We are concerned only with the Value From (Minimum Price) since the method to calculate the price for weights inside the interval depends on this value. The principle is the following for 1155kg:
1155 kg belongs to the open boundary interval 1100-1200 kg. In 1000-1200 kg we have two distinct intervals:
[1000-1100) and [1100,1200), where 1100) can be thought as 1099.99kg and 1200) as 1199.99kg
Therefore 1155kg belongs to the second interval. We mark this count value as I and assign it the value i=2 because it corresponds to the second step of the interval [1000-1200).
To calculate the price associated with 1155kg following the RouteZ1 we distinguish the following:
Value From + Step * i = Final Price
495 + 49.5 * 2 = 594 SEK
Proceeding in a similar fashion we obtain values for RouteZ2, RouteZ3 … Route Z64. After each entry press New in the right hand menu to continue adding all 64 price conditions for the weight interval 1000-1200kg.
In the matrix follow the values column by column for each row. Row 1 (1000- ) has price values in Column 1 (1-20) = 49.50, in Column 2 (21-40) = 49.80… and in Column 64 (1950-2000) =250.90.
For Row 2 (1200- ) these will be 45.30 (Column 1), 45.70 (Column 2) … and 235.20 (Column 64).
We now define the second weight interval with values 1200-1400 kg and keep going until all 26 intervals are covered. The method is always the same in defining the minimum price.
The matrix is now mapped and the file can be Published and be used in COP for calculations.