Blog · Board and management reporting
Energy business performance analysis compares revenue, operating costs, output and budget variances on consistent units. Use a worked electricity-business workbook, exact spreadsheet formulas and reconciliations to explain the result by business unit.
Energy business performance analysis compares actual revenue, operating costs and output with budget on a consistent reporting basis. It shows whether the business earned more because it delivered more output, realized more revenue per unit, or changed its mix of activity. Start with finance and operating workbooks that share the same period and business-unit definitions.
Choose one reporting month, one approved budget version and one currency. Keep a separate label for actual and budget rows. State whether the report covers generation, purchased-energy resale, distribution services or another activity; these businesses do not have interchangeable unit economics.
For electricity, distinguish power from energy over time. The US Energy Information Administration explains that watts measure power at a moment, while watthours measure energy over a period. A capacity figure in MW cannot be substituted for monthly output in MWh.
The example below is an illustrative US electricity business with two units selling the output shown. Its report uses USD and MWh throughout. It excludes unrelated service revenue, so dividing revenue by the stated output produces a meaningful realized revenue rate.
Use one row per unit, scenario and month. These September 2026 rows place business unit in column A, scenario in B, output in C, revenue in D and operating costs in E. Put the headers in row 1 and the four records in rows 2 through 5.
| Business unit | Scenario | Output (MWh) | Revenue (USD) | Operating costs (USD) |
|---|---|---|---|---|
| North | Budget | 10,000 | 700,000 | 500,000 |
| North | Actual | 9,500 | 684,000 | 513,000 |
| South | Budget | 6,000 | 480,000 | 330,000 |
| South | Actual | 6,500 | 507,000 | 351,000 |
For this workbook, operating costs include the cost of energy supplied, maintenance, payroll, depreciation and allocated operating overhead. Interest and income tax are excluded. Match these categories between budget and actual; a changed allocation policy would otherwise look like an operating change.
If the original finance export has separate account rows, aggregate it to this level before attaching the output summary. Repeating monthly output beside every account would overstate output when those rows are summed.
Add F for operating result, G for revenue per MWh and H for cost per MWh. Enter these formulas in F2, G2 and H2 respectively, then fill down through row 5:
=D2-E2
=IF(C2=0,"",D2/C2)
=IF(C2=0,"",E2/C2)
The zero-output guard leaves a rate blank for review rather than presenting a fabricated zero rate. Validate that output and money fields are numeric before using the formulas. Display currency rates to two decimal places while retaining full precision in the cells.
| Business unit | Scenario | Operating result (USD) | Revenue / MWh (USD) | Cost / MWh (USD) |
|---|---|---|---|---|
| North | Budget | 200,000 | 70.00 | 50.00 |
| North | Actual | 171,000 | 72.00 | 54.00 |
| South | Budget | 150,000 | 80.00 | 55.00 |
| South | Actual | 156,000 | 78.00 | 54.00 |
North's actual result is 684,000 − 513,000 = $171,000. Its revenue rate improved, but its cost rate also increased and its output fell. South's output increased while its realized revenue rate fell. Neither unit can be described adequately by its revenue movement alone.
For the interpretation of profit as a share of revenue, use the separate operating margin guide; the rates here deliberately use output as the denominator.
Use Excel's SUMIFS function, which sums values meeting multiple criteria. With a selected business unit in K2, enter these formulas in L2 through P2 respectively for actual revenue, budget revenue, revenue variance, cost variance and operating-result variance:
=SUMIFS($D$2:$D$5,$A$2:$A$5,$K2,$B$2:$B$5,"Actual")
=SUMIFS($D$2:$D$5,$A$2:$A$5,$K2,$B$2:$B$5,"Budget")
=L2-M2
=SUMIFS($E$2:$E$5,$A$2:$A$5,$K2,$B$2:$B$5,"Actual")-SUMIFS($E$2:$E$5,$A$2:$A$5,$K2,$B$2:$B$5,"Budget")
=N2-O2
O2 is the cost variance and P2 is the operating-result variance. A positive revenue variance helps the result; a positive cost variance reduces it. Covirage is not affiliated with Microsoft.
For company totals, remove the unit criterion. Actual revenue is =SUMIFS(D2:D5,B2:B5,"Actual"); budget revenue uses "Budget". Repeat for columns C, E and F to produce this check:
| Measure | Budget | Actual | Actual minus budget |
|---|---|---|---|
| Output (MWh) | 16,000 | 16,000 | 0 |
| Revenue (USD) | 1,180,000 | 1,191,000 | 11,000 |
| Operating costs (USD) | 830,000 | 864,000 | 34,000 |
| Operating result (USD) | 350,000 | 327,000 | −23,000 |
The variance identity proves the result: $11,000 additional revenue minus $34,000 additional costs equals a $23,000 unfavorable change. Actual revenue minus actual costs also equals 1,191,000 − 864,000 = $327,000, matching summed unit results of $171,000 and $156,000.
Company output met budget, but that total hides a move from North to South. North delivered 500 MWh less, a 5.0% shortfall; South delivered 500 MWh more, an 8.3% increase rounded to one decimal place. Compare each unit with its own budget before attributing a company change to pricing or efficiency.
Ask North's finance partner to reconcile maintenance, payroll and overhead differences to the cost export. Ask the commercial owner to explain the realized revenue rates using the associated sales summaries. These are questions raised by the figures, not causes established by them; diagnostic analytics explains that next stage.
Agree the recurring definitions and report owners through a data analytics strategy. Keep the detailed comparison in the financial review so each owner can connect a reported difference to the supporting records.
Upload a sample of your own finance and operating workbook with units and budget scenarios labeled. Covirage maps the columns; its tools compute and check the comparisons, and the external AI model explains the results with every figure traced to its rows. Create a free Covirage account in about a minute, then set up your business and bring your file.
See Covirage for FP&A reporting for the supporting reporting context.
Start with an actual revenue and operating-cost export, the approved budget and an operating summary containing output by business unit and period. Retain scenario labels, currency and output units. Confirm that the financial and operating files describe the same business boundary and reporting cutoff.
Only when it has a valid common measurement basis. Do not add electricity output in MWh to gas volumes or service hours. Compare financial totals across businesses, but calculate physical unit economics within groups whose output units and business roles are comparable.
Revenue can rise while the operating result falls if included costs rise faster. Review revenue, costs and output together, then calculate the variance in the operating result. A business-unit comparison also shows whether one unit's improvement masks deterioration elsewhere.
State the sign convention in the report. Under actual minus budget, a positive cost variance means costs exceeded budget, while a positive revenue variance means revenue exceeded budget. Calculate the operating-result variance as revenue variance minus cost variance, and label favorable or unfavorable separately.