Paul Chapman: /* Monthly Normalised Cost vs Unit Cost - Single Commodity */

2013-10-02T00:18:00Z

Monthly Normalised Cost vs Unit Cost - Single Commodity

Paul Chapman at 00:16, 2 October 2013

2013-10-02T00:16:48Z

Paul Chapman at 00:15, 2 October 2013

2013-10-02T00:15:05Z

Paul Chapman at 00:14, 2 October 2013

2013-10-02T00:14:44Z

Paul Chapman: Created page with "{{#hidens:}} ==Access== Commodity Usage Tab Cost details for a Commodity are accessed through the '''" Cost"''' Tab on the Caro..."

2013-10-01T22:36:59Z

Created page with "{{#hidens:}} ==Access== left|250px|Frame|Commodity Usage Tab Cost details for a Commodity are accessed through the '''"<Commodity> Cost"''' Tab on the Caro..."

New page

{{#hidens:}}
==Access==
[[File:ComCo1.png|left|250px|Frame|Commodity Usage Tab]]
Cost details for a Commodity are accessed through the '''"<Commodity> Cost"''' Tab on the Carousel.

===Controls===
----

[[File:ComCo2.png|right|750px|Frame|Electricty Cost Trends (Annualised)]]

====Monthly Cost Trends - Single Commodity====

{| class="wikitable" style="text-align: left; color: black;"
!'''Object type'''
|
:[[Ellserve:Graph#Single_Y-Axis_Graphs|Single Y-axis chart]]
|-
!'''Purpose'''
|
:To highlight trends in the cost profile for one or more sites by comparing year-on-year accumulated monthly cost totals.
|}

{| class="wikitable" style="text-align: left; color: black;"
!'''Defaults '''
!
|-
|'''Reporting interval'''
|
:Monthly (accumulated annually)
|-
|'''Plot type'''
|
:Line
|-
|'''Dates'''
|
:Relative
|-
|'''Start date'''
|
:Current year -3
|-
|'''End date'''
|
:Current month
|}

{| class="wikitable" style="text-align: left; color: black;"
!Configurable in session
|-
|
:Start date
|-
|
:End date
|}

[[Commodity Details|Parent]] - [[Standard Configuration|Standard Configuration]] - [[Ellserve:Ellserve|Home]]
----

[[File:ComCo3.png|right|750px|Frame|Electricty Consumption Vs Electricity Cost]]

====Monthly Consumption vs Cost - Single Commodity====

{| class="wikitable" style="text-align: left; color: black;"
!'''Object type'''
|
:[[Ellserve:Graph#Double_Y-Axis_Graphs|Double Y-axis chart]]
|-
!'''Purpose'''
|
:To compare how normalised monthly consumption tacks against cost over the same period for one or more sites - single Commodity.
|}

{| class="wikitable" style="text-align: left; color: black;"
!'''Defaults '''
!
|-
|'''Reporting interval'''
|
:Monthly totals
|-
|'''Plot type'''
|
:Bar and line
|-
|'''Dates'''
|
:Relative
|-
|'''Start date'''
|
:Current year -3
|-
|'''End date'''
|
:Current month
|}

{| class="wikitable" style="text-align: left; color: black;"
!Configurable in session
|-
|
:Start date
|-
|
:End date
|}

[[Commodity Details|Parent]] - [[Standard Configuration|Standard Configuration]] - [[Ellserve:Ellserve|Home]]
----

[[File:ComCo4.png|right|750px|Frame|Electricty Actual vs Forecast Cost]]

====Monthly Projected vs Budgeted Costs - Single Commodity====

{| class="wikitable" style="text-align: left; color: black;"
!'''Object Type'''
|
:[[Ellserve:Graph#Single_Y-Axis_Graphs|Single Value Chart]]
|-
!'''Purpose'''
|
:To highlight variance between projected and budgeted cost profiles for one or more sites.
|}

{| class="wikitable" style="text-align: left; color: black;"
!'''Defaults '''
!
|-
|'''Reporting interval'''
|
:Monthly
|-
|'''Plot type'''
|
:Line
|-
|'''Dates'''
|
:Relative
|-
|'''Start date'''
|
:Current year -4
|-
|'''End date'''
|
:Current month +18
|}

{| class="wikitable" style="text-align: left; color: black;"
!Configurable in session
|-
|
:Start date
|-
|
:End date
|}

''Note: Projected costs are equal to actual (normalised) costs for historical periods with complete cost history.''

[[Commodity Details|Parent]] - [[Standard Configuration|Standard Configuration]] - [[Ellserve:Ellserve|Home]]
----

====Cost Summary Table - Single Commodity====

[[File:ComCo5.png|right|750px|Frame|Normalised Cost Summary - All Commodities]]

{| class="wikitable" style="text-align: left; color: black;"
!'''Object Type'''
|
:[[Ellserve:Summary_Info|Summary Table]]
|-
!'''Purpose'''
|
:To summarise and compare normalised cost data for a single commodity by commonly used time periods.
|}

{| class="wikitable" style="text-align: left; color: black;"
!'''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 cost
:* Total Commodity Invoiced Cost
:* Total commodity forecast cost
:* Total commodity budgeted cost
:* Commodity cost variance (percentage difference between actual and projected values)
:* Commodity unit cost ($/consumption Unit)
|}

{| class="wikitable" style="text-align: left; color: black;"
!Configurable in session
|-
|
:None
|}
[[Commodity Details|Parent]] - [[Standard Configuration|Standard Configuration]] - [[Ellserve:Ellserve|Home]]
----

====Share of Costs by Category - Single Commodity====
[[File:ComCo6.png|right|750px|Frame|Annual Cost Usage(Normalised) - Business Unit Category]]

{| class="wikitable" style="text-align: left; color: black;"
!'''Object Type'''
|
:[[Ellserve:Graph#Pie_Graphs|Pie Chart]]
|-
!'''Purpose'''
|
:To chart how a commodity's cost is shared across a category.
|}

{| class="wikitable" style="text-align: left; color: black;"
!'''Defaults '''
!
|-
|'''Reporting interval'''
|
:Annually
|-
|'''Plot type'''
|
:Pie
|-
|'''Dates'''
|
:Relative
|-
|'''Start date'''
|
:Current month -13
|-
|'''End date'''
|
:Current month -1
|-
|'''Category'''
|
:Business Unit
|-
|'''Threshold'''
|
:%
|}

{| class="wikitable" style="text-align: left; color: black;"
!Configurable in session
|-
|
:Start date
|-
|
:End date
|-
|
:Category
|-
|
:Threshold
|}
[[Commodity Details|Parent]] - [[Standard Configuration|Standard Configuration]] - [[Ellserve:Ellserve|Home]]
----

[[File:ComCo7.png|right|750px|Frame|Electricty Cost Vs Variance with Forecast]]

====Monthly Cost vs Forecast Variance - Single Commodity====

{| class="wikitable" style="text-align: left; color: black;"
!'''Object type'''
|
:[[Ellserve:Graph#Double_Y-Axis_Graphs|Double Y-axis chart]]
|-
!'''Purpose'''
|
:To compare monthly normalised cost to the percentage variance between actual and forecast cost - single Commodity.
|}

{| class="wikitable" style="text-align: left; color: black;"
!'''Defaults '''
!
|-
|'''Reporting interval'''
|
:Monthly totals
|-
|'''Plot type'''
|
:Bar and line
|-
|'''Dates'''
|
:Relative
|-
|'''Start date'''
|
:Current year -2
|-
|'''End date'''
|
:Current month
|}

{| class="wikitable" style="text-align: left; color: black;"
!Configurable in session
|-
|
:Start date
|-
|
:End date
|}

[[Commodity Details|Parent]] - [[Standard Configuration|Standard Configuration]] - [[Ellserve:Ellserve|Home]]
----

[[File:ComCo10.png|right|750px|Frame|Electricty Cost Vs Electricity Unit Cost]]

====Monthly Normalised Cost vs Unit Cost - Single Commodity====

{| class="wikitable" style="text-align: left; color: black;"
!'''Object type'''
|
:[[Ellserve:Graph#Double_Y-Axis_Graphs|Double Y-axis chart]]
|-
!'''Purpose'''
|
|
:To compare monthly normalised cost to unit cost for one or more sites - single Commodity.
|}

{| class="wikitable" style="text-align: left; color: black;"
!'''Defaults '''
!
|-
|'''Reporting interval'''
|
:Monthly totals
|-
|'''Plot type'''
|
:Bar and line
|-
|'''Dates'''
|
:Relative
|-
|'''Start date'''
|
:Current year -3
|-
|'''End date'''
|
:Current month
|}

{| class="wikitable" style="text-align: left; color: black;"
!Configurable in session
|-
|
:Start date
|-
|
:End date
|}

[[Commodity Details|Parent]] - [[Standard Configuration|Standard Configuration]] - [[Ellserve:Ellserve|Home]]
----

====Usage Tracking Table - Single Commodity====

[[File:ComCo9.png|right|800px|Frame|Single Commodity Costs Tracking Table - Business Units]]

{| class="wikitable" style="text-align: left; color: black;"
!'''Object Type'''
|
:[[Ellserve:Budget_Tracking|Tracking Table]]
|-
!'''Purpose'''
|
:To highlight variances between actual and expected costs for a single commodity over commonly used time periods.
|}

{| class="wikitable" style="text-align: left; color: black;"
!'''Defaults '''
!
|-
|'''Reporting intervals'''
|
:* Single Month
:* Current financial year (Financial year to date)
|-
|'''Reporting Items'''
|
:* Total commodity normalised monthly cost as at 13 months previous
:* Total commodity normalised monthly cost in previous month (current -1)
:* Percentage normalised monthly cost difference between that in previous month and that a year earlier.
:* Total commodity normalised (actual) monthly cost in previous month
:* Total commodity forecast (budget) monthly cost in previous month
:* Total commodity expected (projected) monthly cost in previous month
:* Variance (percentage difference) between expected and forecast Cost in previous month
:* Commodity Cost Variance (percentage difference between actual and projected values) in previous month
:* Total commodity forecast (budget) monthly cost in financial year to date
:* Total commodity expected (projected) monthly cost in financial year to date
:* Variance (percentage difference) between expected and forecast Cost in financial year to date
:* Commodity cost variance (percentage difference between actual and projected values) in financial year to date
|-
|'''Category'''
|
:Business Unit
|-
|'''Highlight Threshold'''
|
:5%
|-
|}

{| class="wikitable" style="text-align: left; color: black;"
!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. cost has fallen) are shaded green, positive differences are shaded red''
''* ''Cells containing negative variances (i.e. Cost 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. Where 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).''

[[Commodity Details|Parent]] - [[Standard Configuration|Standard Configuration]] - [[Ellserve:Ellserve|Home]]

----

[[File:ComCo8.png|right|750px|Frame|Monthly Usage(Normalised) - Single Commodity]]

====Normalised Cost - Single Commodity by Period====

{| class="wikitable" style="text-align: left; color: black;"
!'''Object Type'''
|
:[[Ellserve:Data_Table|Data table]]
|-
!'''Purpose'''
|
:To summarise and compare total monthly cost over the previous year - single Commodity.
|}

{| class="wikitable" style="text-align: left; color: black;"
!'''Defaults '''
!
|-
|'''Reporting intervals'''
|
:Month
|-
|'''Reporting items'''
|
:* Total commodity normalised cost
:* Total commodity forecast cost
:* Total commodity invoiced cost
:* Total commodity budgeted cost
:* Commodity cost variance (percentage difference between actual and projected values)
:* Commodity unit cost ($/consumption unit)
|}

{| class="wikitable" style="text-align: left; color: black;"
!Configurable in session
|-
|
:Start date
|-
|
:End date
|}
[[Commodity Details|Parent]] - [[Standard Configuration|Standard Configuration]] - [[Ellserve:Ellserve|Home]]

@@ Line 336: / Line 336: @@
 |-
 !'''Purpose'''
+|
 :To compare monthly normalised cost to unit cost for one or more sites - single Commodity.

@@ Line 1: / Line 1: @@
 ==Access==
 [[File:ComCo1.png|left|250px|Frame|Commodity Usage Tab]]
 Cost details for a Commodity are accessed through the '''"<Commodity> Cost"''' Tab on the [[Carousel|carousel]].
@@ Line 12: / Line 13: @@
 !'''Object type'''
+|
-:[[Ellserve:Graph#Single_Y-Axis_Graphs|Single Y-axis chart]]
+:[[Graph#Single_Y-Axis_Graphs|Single Y-axis chart]]
 |-
 !'''Purpose'''
@@ Line 64: / Line 65: @@
 !'''Object type'''
+|
-:[[Ellserve:Graph#Double_Y-Axis_Graphs|Double Y-axis chart]]
+:[[Graph#Double_Y-Axis_Graphs|Double Y-axis chart]]
 |-
 !'''Purpose'''
@@ Line 117: / Line 118: @@
 !'''Object Type'''
+|
-:[[Ellserve:Graph#Single_Y-Axis_Graphs|Single Value Chart]]
+:[[Graph#Single_Y-Axis_Graphs|Single Value Chart]]
 |-
 !'''Purpose'''
@@ Line 171: / Line 172: @@
 !'''Object Type'''
+|
-:[[Ellserve:Summary_Info|Summary Table]]
+:[[Summary_Info|Summary Table]]
 |-
 !'''Purpose'''
@@ Line 215: / Line 216: @@
 !'''Object Type'''
+|
-:[[Ellserve:Graph#Pie_Graphs|Pie Chart]]
+:[[Graph#Pie_Graphs|Pie Chart]]
 |-
 !'''Purpose'''
@@ Line 280: / Line 281: @@
 !'''Object type'''
+|
-:[[Ellserve:Graph#Double_Y-Axis_Graphs|Double Y-axis chart]]
+:[[Graph#Double_Y-Axis_Graphs|Double Y-axis chart]]
 |-
 !'''Purpose'''
@@ Line 332: / Line 333: @@
 !'''Object type'''
+|
-:[[Ellserve:Graph#Double_Y-Axis_Graphs|Double Y-axis chart]]
+:[[Graph#Double_Y-Axis_Graphs|Double Y-axis chart]]
 |-
 !'''Purpose'''
@@ Line 385: / Line 386: @@
 !'''Object Type'''
+|
-:[[Ellserve:Budget_Tracking|Tracking Table]]
+:[[Budget_Tracking|Tracking Table]]
 |-
 !'''Purpose'''
@@ Line 466: / Line 467: @@
 !'''Object Type'''
+|
-:[[Ellserve:Data_Table|Data table]]
+:[[Data_Table|Data table]]
 |-
 !'''Purpose'''

Commodity Costs - Revision history

Paul Chapman: /* Monthly Normalised Cost vs Unit Cost - Single Commodity */

Paul Chapman at 00:16, 2 October 2013

Paul Chapman at 00:15, 2 October 2013

Paul Chapman at 00:14, 2 October 2013

Paul Chapman: Created page with "{{#hidens:}} ==Access== Commodity Usage Tab Cost details for a Commodity are accessed through the '''" Cost"''' Tab on the Caro..."