AWS - Calculating Variance %

[aliclair]

I have sales figures for 2004/05 and 2005/06, have worked out the variances for each month but now have to work out the % based on the 2004/05 figures, for example:

Sales Sales Varience

530 545 15

To get the % variance am I correct in saying that 15/530x100 which would give 2.8% which would be a positive percentage change?

Any help would be appreciated as I am confusing myself with positives and negatives!!:001_unsure:

[SandyHood]

Your sales are 2.8% more than budgeted, so you are correct.

[leevictoria18@hotmail.com]

Hope i can help. If yours sales are up its obviously a positive as we know. But when you calculate any costs risen i.e salaries, admin, cost of goods, that is a negative we DONT like the RISING of COSTS and so thats shown as a negative.

[aliclair]

Thanks for the replies, they were a great help.

Alison