01 Mar 2008
NOTE: This was developed in March 2008 and the calculations are no longer accurate. They are close but not exactly right.
Update 11 August 2011: Want this as an app for your smartphone? Click here

A personal annoyance at the moment is the use of the term AA rates. It seems companies love to tell employees they pay at AA rates or charge customers at AA Rates. However due to a recent annoying experence I decided to read up on this, and to findout what the AA rate actually is.

Well imagine my surprise when I didn't find one magic overall AA rate! What I did find is there is a AA rate per vehicle, so how you get one rate is beyond me (I guess you could take the avg value of everyone in the company, but that sounds like too much work for admin/financial staff who need to update it each time someone joins/leaves).

Anyway I decided to take that and some of the Excel skills I have been taught recently and build a nice Excel speadsheet (2007 version) which works it out for you (download below). You can get the details on the rules and the fuel price (which you will need) from the AA site.

AttachmentSize
AARates.xlsx30.5 KB
Tags: 

Comments

Hein's picture

Hi,

Thanks for your insight on this issue. I am having a bit of a struggle with my co at the moment and would like to use your formula to check how my rate that I am getting compares to the "AA" rates. I tried to use your formula but it wont allow me to put the fuel price in. Could you please assist me with this?

If need be you can reply to [email protected].

Regards.

Hein.

Sheila's picture

Hi I am unable to open or download your excel spreadsheet. Could you possibly assist? Thanks Sheila
Craig's picture

It seems even with 2007 it does not open your spreadsheet.
Muzi's picture

I always hear AA rates and have googled all sites please help,how do I find a calculator or formula to commercial heavy duty charging and factors affecting change in rate.If any AA rate where is it straight link please
Robert MacLean's picture

In the post is the spreadsheet which is a calculator for the AA Rates. There is no such thing as "commercial heavy duty" rates - there is one AA Rate with many factors like vehicle type that influnence it. So the above will work for any need you have. You can see the formula too in the spreadsheet.
Cindy Nel's picture

Hi I dont know if you found what you have been looking for. I am in the same position needs the running cost for heavy duty trucks and double cab diesel ldv's Maybe you can help Thank you Cindy
Robert MacLean's picture

In the post is the spreadsheet which is a calculator for the AA Rates. There is no such thing as "commercial heavy duty" rates - there is one AA Rate with many factors like vehicle type that influnence it. So the above will work for any need you have. You can see the formula too in the spreadsheet.
Winston Lomahoza's picture

Please help with a table for aa rates I need to calculate new rates as cost of running cars has escalated.
Obakeng Freddy Morweng's picture

I WORK FOR A CERTAIN COMPANY IN KLERKSDORP, AND THEY ARE PAYING US R1,50 PER KILO. AND THE CONTRACT STATE THAT THEY MUST PAY ACCORDING TO AA RATES CAN YOU PLEASE HELP ME WITH THIS MATTER.
Robert MacLean's picture

If the contract states AA Rates then I would approach your HR department about the issue. Maybe they just don't realise they have it wrong. My reason for this work initially was the same, I too worked at company that paid "AA Rates" but didn't really. When I spoke to HR the contract was updated to pay an "agreed rate" - which was less than the AA Rate but more than before and we added a clause it would be reviewed yearly. I would recommend all companies do similar, the reason is that AA Rates are VERY tough for companies to deal with - they change monthly, they are influenced by factors outside the companies control (how much you drive, how much your car cost etc...). If you HR dept. is unwilling and you can't get any senior management to move on it, then take it to a labour law expert (which I am not) or to the CCMA as they, in my understanding, would be in breach of the contract.
Freddy's picture

Can you Please help me with AA RATES from 1O MAY 2011 TO 30 JANUARY 2012 1.4 2011 POLO VIVO. Can you send me the table eg.May 2011 R2.50 June R3.00.
Robert MacLean's picture

The Excel spreadsheet is right there, just above your comment so best is to download that and use that to work it out :)
Ian Robertson's picture

Hi, I really like your spreadsheet. Is there anyway I can update the data with the latest data? Thanks
Robert MacLean's picture

I checked the AA rates recently and they haven't changed since this was originally done

Add new comment