EXPENSE ANALYSIS

Cost datasets often do not have quantity information, because that would be meaningless. Therefore you cannot analyze "price" variance. The tool provides useful insights also in this case.

In this example, the 200k row dataset of the budget of NYC, there is no quantity column, but just the amount spent. This means that we cannot distinguish price variance from volume variance. We also cannot get mix variance information because this also requires a quantity metric.

Let's load the the New York City budget dataset (type NYC in the "choose sample dataset" widget) and run a "fix dimension" bridge.

To show higher values in red, change the color palette parameter.

image-20210422182552617

The first year expense is 271,597,447,185$. The change between the two years is about 5%, 14,191,868,822$.

waterfall (23)

If we run a "a variable dimension" bridge with standard parameters, we get this. Notice that the most important items is "N/A" as Responsibility Center Name. The field seems to be often empty.

waterfall (2)

table (2)

Lets drop the responsibility center name column from our analysis

image-20210422182845353

Here is the new output.

waterfall (3)

table (3)

We are showing this chart with the initial and final totals.

image-20210422182952947

You can also see it without.

waterfall (4)

table (4)

We want to understand better that first "Department of education" row so we drill down

image-20210313172626088

The app now also returns a more detailed report.

waterfall (5)

table (5)

To distinguish the "new", "maintained" and "dropped" expenses set "Show variance as" to "price, new, lost, volume & mix".

waterfall (6)

table (6)