Matrix
Matrix components lookup a value based on two inputs
The Matrix component uses a lookup table to determine a value based on two primary inputs. Common examples are costs per unit that vary depending on the quantity of an order or maintenance costs that change due to equipment age.
There are four inputs required for a Matrix Cost:
The Matrix X value (lookup value along the x axis)
The Matrix Y value (lookup value along the y axis)
The Matrix (lookup table)
The Activity
The output of this component is the resulting value from the Matrix multiplied by the Activity.
Example
Using a Matrix to estimate the transport costs where the cost per load changes depending upon the distance of the trip (Matrix X), the number of parcels in each load (Matrix Y) and the number of trips for the period (Activity).
These values are the values defined in the Matrix input.
Matrix Table Input
Matrix ($/Trip) | 0-10km | 10-20km | 20-30km |
0-5 Parcels | $5.00 | $7.00 | $9.00 |
5-10 Parcels | $4.50 | $7.50 | $9.50 |
10-15 Parcels | $4.00 | $8.00 | $10.00 |
15-20 Parcels | $3.50 | $8.50 | $10.50 |
Next, here are our inputs for the Matrix component.
Period 01 | Period 02 | Period 03 | Period 04 | |
Time Based Inputs | ||||
Distance of Trip (Matrix X) | 9 | 12 | 19 | 25 |
No of Parcels (Matrix Y) | 1 | 7 | 12 | 17 |
No of Trips (Activity) | 20 | 15 | 15 | 12 |
Finally, the resulting are calculated. For the first period the km are between 0 and 10 so we're only looking at the first column in the Matrix. The number of parcels is between 0 and 5 so the resulting value is $5.00. Then that number is multiplied by the number of activities, in this case 20 trips resulting in a total of $100.
Calculation | Period 1 | Period 2 | Period 3 | Period 4 |
Resultant $/Trip | $5.00 | $7.50 | $8.00 | $10.50 |
No of Trips | 20 | 15 | 15 | 12 |
Cost Outcome | $100.00 | $112.50 | $120.00 | $126.00 |
Last updated