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