thenorthernmonkey
New Member
- Joined
- Aug 9, 2019
- Messages
- 4
Hi all,
New user and couldn't seem to find exactly what I was after, so hopefully below makes some sense.
Context:
I'm looking at utility spend across our portfolio of around 100 locations, each location is a different size and spend is location specific.
What I'm trying to pull out is any location with a significant change in cost month on month, but a simple % variance isn't quite working due to the location specific element, and just using cost doesn't take into account the scale of expected cost.
Example:
Site 1 Jan: £100
Site 1 Feb: £150
% Increase: 50%
Cost increase: £50
Site 2 Jan: £1,000,000
Site 2 Feb: £1,200,000
% Increase: 20%
Cost Increase: £200,000
So I'm more interested in a 20% increase on site 2 as it relates to a higher cost value.
Formula used to get the % change on a location by location basis is =(current month - previous month) / previous month
Is there a formula that would highlight significant cost changes, but also show the scale / impact against the rest of the portfolio?
ie - I want to easily see the £200k increase.
Quick sample set below, ones in bold are the have the biggest month on month location specific cost increase, but aren't the biggest % increase:
<tbody>
</tbody>
New user and couldn't seem to find exactly what I was after, so hopefully below makes some sense.
Context:
I'm looking at utility spend across our portfolio of around 100 locations, each location is a different size and spend is location specific.
What I'm trying to pull out is any location with a significant change in cost month on month, but a simple % variance isn't quite working due to the location specific element, and just using cost doesn't take into account the scale of expected cost.
Example:
Site 1 Jan: £100
Site 1 Feb: £150
% Increase: 50%
Cost increase: £50
Site 2 Jan: £1,000,000
Site 2 Feb: £1,200,000
% Increase: 20%
Cost Increase: £200,000
So I'm more interested in a 20% increase on site 2 as it relates to a higher cost value.
Formula used to get the % change on a location by location basis is =(current month - previous month) / previous month
Is there a formula that would highlight significant cost changes, but also show the scale / impact against the rest of the portfolio?
ie - I want to easily see the £200k increase.
Quick sample set below, ones in bold are the have the biggest month on month location specific cost increase, but aren't the biggest % increase:
<tbody> </tbody> |
<tbody>
</tbody>