Cost and Budget Improvements KPI's

[alsalms3]

Hello All!!

See if you can come up with a method for identifying overspend and abnormalities. Conditional formatting perhaps based on targets or 6 month averages or 12 months ?


Thanks.

[FDibbins]

the only abnormality I can see is a table with 2013 ceels ALL containing zeros, and no indication of what you want.

You will have to be a lot more descriptive as to what you want, why you want it and where you want it be put

[alsalms3]

Yeah I have changed to "0" Anyway I have Attached the right file.

1. I'm looking to have monthly average for each month.
2. Identify the high values where I spent more money (over spent).
3. Add percentage to each month and compare it with previous month.
4. Highlight or condition if I spent like over 20,000$.

[FDibbins]

thanks for the updated file

1. =AVERAGE(C2:J2) copied down will give the average for the months you have. =sum(C2:J2) will give you the total. However, I have a feeling that you will be adding months as time goes by? If thats the case, then I would suggest you add the extra months now, so that your formula becomes...
=AVERAGE(C2:N2)
you can hiode the extra columns until you need them

2. "Identify the high values where I spent more money (over spent)." high values compared to what??

3. do you want an extra column between each month to do that? or would you prefer just 1 extra column that will compare just this month with last month?

4. For this, you can add another Conditional formatting rule, the same as the 1 you already have there, just change the "less than or equal to" to "greater than" 20000