Understanding the Rate Matrix 

 

A matrix can be viewed as a table with an unlimited amount of rows and columns with two labeled sides: X-coordinate (X Range) and the Y-coordinate (Y Range).

 

Figure 16: Matrix of X and Y Coordinates

 

 

At the intersection of the two coordinates is the information (rate and breakpoints) that is to be returned as rating information to MoversSuite.

 

In the Rate Matrix setup of the MoversSuite Administration - web, a user can define each coordinate by specifying one of the following for either side (defined as Rate Matrix Range Types):

Cubic Feet

Linear Feet

Miles

Weight

 

MoversSuite currently provides a single, preset Rate Matrix entitled “Miles and Weight” with each release.  It contains a X-coordinate of Miles and a Y-coordinate of Weight

Figure 17: Graphical representation of the "Miles and Weight" Rate Matrix

 

Miles are arranged on the left in ten mile increments and the weight is grouped beginning at 2,100 pounds.  In the excerpt from the Rate Matrix report for Miles and Weight, see Figure 18 (below), if the distance of a move was 115 miles and the total weight assigned to the order was 2,500 pounds, then the rate that would be returned to the application would be $47.54

 

Figure 18: Miles and Weight Rate Matrix example

 

Notice that there are breakpoints for each axis.  The Breakpoint X is the Miles axis, which is not used in this model, and Breakpoint Y is for the Weight axis.  The breakpoint instructs the logic to jump up to the next Rate if the quantity is within the range AND above the breakpoint.  To continue with the previous example, if the total weight of the move was 3,500 pounds (instead of 2,500), then it would be above the breakpoint of 3,444 pounds and the charge would be $40.93 instead (jumping up to the next tier).

 

To give a user a different perspective on the same data presented within the Miles and Weight Rate Matrix, the following table is grouped by the Y-coordinate (Weight) instead.

 

Tier

Miles

Rate

Weight

Breakpoint

1

1 to 40

37.95

2,100 to 3,999

3,630

2

1 to 40

34.44

4,000 to 7,999

6,778

3

41 to 50

39.71

2,100 to 3,999

3,551

4

41 to 50

35.25

4,000 to 7,999

6,806

5

51 to 60

 40.93

2,100 to 3,999

3,550

6

51 to 60

36.33

4,000 to 7,999

6,663

7

61 to 70

41.33

2,100 to 3,999

3,634

8

61 to 70

37.55

4,000 to 7,999

6,677

9

71 to 80

43.22

2,100 to 3,999

3,487

10

71 to 80

37.68

4,000 to 7,999

6,682

11

81 to 90

44.57

2,100 to 3,999

3,443

12

81 to 90

38.36

4,000 to 7,999

6,761

13

91 to 100

45.52

2,100 to 3,999

3,418

14

91 to 100

38.90

4,000 to 7,999

6,834

15

101 to 110

46.19

2,100 to 3,999

3,532

16

101 to 110

40.79

4,000 to 7,999

6,570

17

111 to 120

47.54

2,100 to 3,999

3,444

18

111 to 120

40.93

4,000 to 7,999

6,784

 

 

View the complete Miles and Weight Rate Matrix through the Rate Matrix report to see the complete layout.  More information is available in the Ratings Reports section of this document.