How Attendances/Additions are Calculated

When a user updates from comparisons into the job and applies additions, these are split over each item evenly. This page aims to outline what calculation is made to determine the 'Addition Factor'

A contact's additions are the grand total of:

1. Adjustments

2. Allowances

3. Attendances

In this example, you can see Contact 1 has the following:

▪ 10% (of the contact rates total) adjustments

▪ £1000 allowances

▪ £2000 attendances

So, given the below rates:

There is a grand total of £25,190.50.

This means there is £2519.05(10% of the total) + £1000(allowance) + £2000(attendance) = £5519.05 in additions which must be split over the 4 items.

The split is not simply divided by the number of items, but by the percentage of the item value.

This is the factor we will multiply the item rate by to get the addition total for the item. It is calculated as AdditionValue / ItemRatesValue

So given:

▪ Value of item rates of £25,190.50

▪ Addition value of £5519.05

Would be 5519.05/25190.50, resulting in an addition factor of 0.21909251503543.

Now that we have the addition factor, we need to apply it to each item rate.

For the first item

▪ Rate is 10.00

▪ Qty is 330

▪ Extension is 3,300

We apply the addition factor with:

Which is 10 + (Round(10*0.21909251503543)) which equals 10 + 2.19

resulting in

▪ Rate is 12.19

▪ Qty is 330

▪ Extension is 4,022.70

There can be cases when this method will result in what some users would say is a bug, but is actually correct in a mathematical sense. The main case is when dealing with negative values.

Take the comparison below:

In this case, the contacts rates total a negative number of -15,000.70

The contact also has 15,000 in additions.

If we update the job and apply additions like above:

Addition factor = 15,000 / -15,000.70, which results in a factor of -1 (After rounding)

Now apply this to the item:

▪ Rate is 371.29

▪ Qty is 138

▪ Extension is 51,238.02

We apply the addition factor with

371.29 + (371.29 x -1)

or

371.29 + -371.29

Resulting in

▪ Rate is 0

▪ Qty is 138

▪ Extension is 0

Item 2 is marked as Included, so

▪ Rate is 0

▪ Qty is 1

▪ Extension is 0

▪ Rate is -66,238.72

▪ Qty is 1

▪ Extension is -66,238.72

We apply the addition factor with

-66,238.72 + (-66,238.72 x -1)

or

-66,238.72 + 66,238.72

Resulting in

▪ Rate is 0

▪ Qty is 1

▪ Extension is 0

If the user wants to update negative values back to the job with additions, it is best that they include the addition value in the rate, but they should also look at other options, such as discounts in the job, as this is not how comparisons are intended to be used.