Energy dashboard examples: use, cost and intensity

Useful energy dashboard examples put commercial consumption, billed cost and output-normalized intensity on the same page. The comparison should answer whether a site used more energy because it produced more, paid more for the same energy, or consumed more per unit of output.

Begin with matching utility and production periods

Consider an illustrative US manufacturer making the same standard component at plants in Cleveland, Dayton and Erie. The operations director wants to compare September 2026 electricity costs without penalizing the plant that produced the most components.

Bring the utility export with site, meter, service start, service end, consumption unit, billed consumption and charges. Bring the production export with site, production date, product and accepted output. Use service dates to match the two files; the invoice posting month alone does not identify when the electricity was used.

For this example, all bills cover September 1 through September 30, 2026. Output is accepted components produced during that period. Each site's electricity meters serve the production and supporting areas included in the comparison. Natural gas is outside this example's boundary.

The Department of Energy defines energy intensity as energy required per unit of output or activity. That makes the output definition part of the measure. A count of equivalent components works here because the plants make the same product; it would need reconsideration for sites with different production processes.

A worked example across three plants

These are the period totals from the two exports. Billed cost includes all electricity charges for the stated service period, with no unpaid balance from a previous bill.

Three calculations turn those rows into useful comparisons:

Electricity intensity = Electricity used / Accepted output

Electricity cost per unit = Billed electricity cost / Accepted output

Blended billed cost per kWh = Billed electricity cost / Electricity used

Intensity is rounded to one decimal place; dollar unit measures use three decimals. Calculations use the original amounts before rounding. The total blended rate is 84,600 / 540,000, rounded to 0.157.

Cleveland has the largest bill, $36,000, but matches Erie's physical electricity intensity. Dayton has the highest intensity despite spending less than Cleveland. Erie has the same intensity as Cleveland and a higher cost per unit, so its billing components deserve review before anyone labels the plant inefficient.

The blended cost is an explanation of the full bill, not the tariff's consumption rate. The Department of Energy distinguishes energy, demand and fixed charges: consumption charges use kWh, demand charges use maximum kW, and fixed charges follow the rate schedule. Their combined effect can change cost per kWh even when the energy charge itself is unchanged.

Put the comparison into a practical layout

Use a site comparison table as the center of the dashboard. Put electricity use, billed cost and accepted output above it as period totals. Below it, show the same measures over successive periods, with a visible label identifying the service dates and output unit.

For the monthly review, separate the questions. Operations owns output and investigates Dayton's consumption per component. Finance checks each bill's charges and the cost allocation. Facilities confirms which meters and buildings each site includes. The purchasing team reviews tariff or supply-contract differences when the physical intensity does not explain the cost gap.

Keep the next action beside the measure: the site, the question, the owner and the evidence needed. Dayton's next action is to check operating hours, idle load and product comparability. Erie's is to inspect the bill components and operating timing. Neither question can be resolved from a ranked spending chart alone.

For a broader analysis layout, see the energy analytics dashboard. The spreadsheet energy dashboard and BI implementation guide cover their respective presentation approaches. This example supplies the comparison those layouts need.

Change one input: Dayton produces more

Now change only Dayton's accepted output from 6,000 to 9,000 components. Keep electricity and every bill amount unchanged. This is a sensitivity example, not a claim that extra production requires no additional energy.

Company output rises by 3,000 / 24,000 = 12.5%. Company intensity falls by (22.5 - 20.0) / 22.5 = 11.1%, rounded to one decimal place, while the bill remains $84,600. The denominator alone changed both unit measures.

This is why lower intensity is a finding to investigate. It may reflect more output spread over a standing electricity load. It does not, by itself, prove that equipment became more efficient or cash spending fell. Electricity is also only one input to manufacturing cost per unit.

The checks that make the comparison trustworthy

The site bills must add to $84,600 and consumption must add to 540,000 kWh. Production rows must add to 24,000 accepted components in the original case. Confirm that each meter appears once and that supply and delivery charges have not duplicated the same consumption quantity.

The intensity also has an independent check. Multiply each site's unrounded intensity by its output, then sum: 20 × 12,000 + 30 × 6,000 + 20 × 6,000 = 540,000 kWh. Divide by 24,000 to recover 22.5 kWh per component. Use totals for the company measure rather than an unweighted average of site ratios.

Where it goes wrong

• Billing periods do not match production. A bill spanning parts of different months cannot be compared directly with one calendar month's output.
• Different products share one output count. A component needing a different process can change intensity without an operating problem. Compare like products or document equivalent output weights.
• Demand is treated as consumption. kW measures power demand; kWh measures energy. Keep their billing drivers distinct.
• Lower output is called an efficiency saving. Reduced consumption alongside a larger production decline can mean intensity worsened. Read the denominator before assigning a cause.

Compare your own utility and production files in Covirage

Upload your utility and production exports with matching site and period fields. Covirage maps the columns; its tools compute and check consumption, cost and intensity, and the external AI model explains the results with every figure traced to its rows. Create a free Covirage account, which takes about a minute, and bring a sample of your own data after setting up your business.

See Covirage for industrial manufacturers for the wider operating and financial context.