Math Is Fun Forum

Hi All,

I am looking into an interesting question/problem that has arisen from an application I am working on.

The application takes a collection of costs, and then calculates the VAT (sales tax for you Americans ) for the cost, before finally giving a total cost including VAT.

If we say VAT is calculated at 17.5% of the price of the cost of the goods, then the customer will be charged:

The total cost of goods (including VAT) is rounded to 2 decimal places, so it is in a correct pricing format (£xx.xx).

My question is this... If there are multiple costs for a single person, is it more accurate to calculate the VAT costs individually, and then sum the total of the costs (inc VAT), OR to sum the costs then calculate the VAT on top of that?

I have created an excel spreadsheet containing ~800 individual costs.  If I calculate the VAT (and round to 2 decimal places) then take a total, the cost that the customer will be charged is larger than if I calculate the sum of the costs (exc VAT) and THEN calculate the VAT on the total sum.  In my example, the difference between the two final costs was £1.11.

Many thanks in advance for any advice you can give,

AJ