Commodity Usage

Access

Consumption details for a commodity are accessed through the "<Commodity> Use" tab on the carousel.

Monthly Consumption vs Degree Day Heating - Single Commodity

Object type	Double Y-axis chart
Purpose	To compare the monthly consumption profile for one or more sites against standard NIWA degree day heating figures.

Defaults
Reporting interval	Monthly totals
Plot type	Bar and line
Dates	Relative
Start date	Current year -3
End date	Current month

Configurable in session
Start date
End date

Parent - Standard Configuration - Home

---

Monthly Consumption Trends - Single Commodity

Object Type	Single value chart
Purpose	To highlight trends in the consumption profile for one or more sites by comparing year-on-year accumulated monthly consumption totals.

Defaults
Reporting interval	Monthly (accumulated annually)
Plot type	Line
Dates	Relative
Start date	Current year -3
End date	Current month

Configurable in session
Start date
End date

Parent - Standard Configuration - Home

---

Monthly Budgeted vs Projected Usage - Single Commodity

Object Type	Single value vhart
Purpose	To highlight variance between budgeted and expected consumption profiles for one or more sites.

Defaults
Reporting interval	Monthly
Plot type	Line
Dates	Relative
Start date	Current year -1
End date	Current month +18

Configurable in session
Start date
End date

Note: Projected usage is equal to actual (normalised) usage for historical periods with complete consumption history.

Parent - Standard Configuration - Home

---

Usage Summary Table - Single Commodity

Object Type	Summary table
Purpose	To summarise and compare consumption data for a single commodity by commonly used time periods.

Defaults
Reporting Intervals	Current (calendar) month Current year (previous 11 calendar months and current month) Current financial year (financial year to date) Last month (previous calendar month) Last full year (previous 12 calendar months)
Reporting Items	Total commodity normalised consumption Total commodity invoiced consumption Total commodity forecast consumption Total commodity budgeted consumption Commodity consumption variance (percentage difference between actual and projected values) Commodity unit cost ($/consumption Unit) Carbon emissions in tCO2e associated with commodity

Configurable in session
None

Parent - Standard Configuration - Home

---

Share of Usage by Category - Single Commodity

Object Type	Pie chart
Purpose	To chart how a commodity's consumption is shared across a category.

Defaults
Reporting interval	Annually
Plot Type	Pie
Dates	Relative
Start Date	Current month -13
End Date	Current month -1
Category	Business unit
Threshold	5%

|Start date

Configurable in session
End date
Category
Threshold

Parent - Standard Configuration - Home

---

Monthly Consumption vs Unit Cost - Single Commodity

Object Type	Double Y-axis chart
Purpose	To compare monthly normalised consumption to unit cost for one or more sites - single commodity.

Defaults
Reporting interval	Monthly totals
Plot Type	Bar and line
Dates	Relative
Start Date	Current year -3
End Date	Current month

Configurable in session
Start Date
End Date

Parent - Standard Configuration - Home

---

Monthly Consumption vs Forecast Variance - Single Commodity

Object Type	Double Y-axis chart
Purpose	To compare monthly normalised consumption to the percentage variance between actual and forecast consumption - single commodity.

Defaults
Reporting Interval	Monthly totals
Plot Type	Bar and line
Dates	Relative
Start date	Current year -2
End date	Current month

Configurable in session
Start Date
End Date

Parent - Standard Configuration - Home

---

Usage Tracking Table - Single Commodity

Object Type	Tracking Table
Purpose	To highlight variances between actual and expected consumption data for a single commodity over commonly used time periods.

Defaults
Reporting Intervals	Single Month Current Financial Year (Financial year to date)
Reporting Items	Total commodity normalised monthly consumption as at 13 months previous Total commodity normalised monthly consumption in previous month (current -1) Percentage normalised monthly consumption difference between that in previous month and that a year earlier. Total commodity normalised (actual) monthly consumption in previous month Total commodity forecast (budget) monthly consumption in previous month Total commodity expected (projected) monthly consumption in previous month Variance (percentage difference) between expected and forecast consumption in previous month Commodity vonsumption variance (Percentage difference between actual and projected values) in previous month Total commodity forecast (budget) monthly consumption in financial year to date Total commodity expected (projected) monthly consumption in financial year to date Variance (percentage difference) between expected and forecast consumption in financial year to date Commodity consumption variance (percentage difference between actual and projected values) in financial year to date
Category	Business unit
Highlight threshold	5%

Configurable in session
Start date
End date
Highlight threshold
Reporting period (month or quarter)
Category

Note: The Highlight Threshold sets the value over which a variance or difference is highlighted in the table.
* Cells containing negative differences (i.e. consumption has fallen) are shaded green, positive differences are shaded red
* Cells containing negative variances (i.e. consumption is higher than forecast) are shaded red, positive differences are shaded green

Note: By default the tracker uses forecast data from a budget where one has been defined.  In this case tracking takes place against
forecast data that is fixed over the time frame of the budget.  If no budget has been defined, the tracker reports difference and
variance against system generated forecast data.  Forecast data is periodically regenerated as new consumption data is received.
This means, where no budget has been fixed, subtle month by month changes in variance data may be noted (occurring mostly in the current quarter).

Parent - Standard Configuration - Home

---

Normalised Usage All Commodities by Period

Object Type	Data table
Purpose	To summarise and compare total monthly consumption over the previous year - single commodity.

Defaults
Reporting Intervals	Month
Reporting Items	Total commodity normalised consumption Total commodity forecast consumption Total commodity invoiced consumption Total commodity budgeted consumption Commodity unit cost ($/consumption unit) Commodity consumption variance (percentage difference between actual and projected values) Carbon emissions in tCO2e associated with commodity

Configurable in session
Start Date
End Date

Parent - Standard Configuration - Home