Step 4 - Transform the Resource Allowables to the Cluster Unit of Measure

Once the component resources have been added, you can transform their budget rates by editing the transform column. This is done by clicking on the column next to the relevant resource and then filling in the appropriate mathematical functions.

Comments can also be added by including them within square brackets within the transform column. Trimble Quest ignores everything in between square brackets, so it is not necessary to include them, but it does help with improving the readability of your calculations:

The transforming calculations which can be seen in the “Transform” column above works as follows:

In this example, one ton of building sand costs us $9.90 and we need 1.5 tons of sand per cubic yard (CY) of mortar, which is why we multiply the sand allowable by 1.5.

Other factors which can influence cost can also be applied here, which is why there is another multiplication by 1.05 in order to build in a 5% wastage factor into the cost of sand per CY of mortar. This gives us a per cubic yard budget rate for sand of $15.59.

We use 560 pounds (lb) of cement per yd3 of mortar, so we multiply the budget rate for the cement resource (which comes in 80 lb bags at a cost of $10.00 per bag) by 7 to get to 560, and again we then add in a 5% wastage factor by multiplying by 1.05. This gives us a per cube allowable for cement of $73.50.

Building water is bought in kilogallons at a cost of $0.30 per kilogallon. We only need 30 gallons per CY of mortar, so in this case, we divide the kgal cost by 1000 to get to the gallon cost and then we multiply it by 30 to get to the budget rate for water per CY of mortar, which works out to a budget rate of $0.01 for water per CY of mortar.

After applying these transform calculations, we end up with a budget rate for mortar of $89.10 per cubic yard.

Video: Resource Clusters