Headquarters EnergyCAP, LLC
360 Discovery Drive
Boalsburg, PA 16827

Denver, CO
Suite 500
5445 DTC Parkway
Greenwood Village, CO 80111

Dublin, Ireland
Unit F, The Digital Court, Rainsford Street,
Dublin 8, D08 R2YP, Ireland

Phone: 877.327.3702
Fax: 719.623.0577

Making the Most of Your Campus Energy Data

This eBook presents component processes involved in handling campus-based internal/interdepartmental invoicing for energy-related expenses using energy management software in conjunction with submeters. It also includes best practices and desirable features for energy management software. This eBook is most relevant for energy managers and/or accounting or utilities staff members responsible for granular energy reporting and/or internal/departmental invoicing for energy expenses.

What are Chargebacks?

Chargebacks are also referred to as cost or usage allocations, re-billings, or distributions. All of the terms can refer to a process by which energy provided by the energy vendor(s)—internal or external—is distributed to various departments of that organization. In practice, the organization’s facilities or accounting department often becomes the local energy “vendor” for the rest of the campus.

Because chargebacks include energy use and energy cost, they represent an intersection of accounting and energy management needs for a campus-type organization.

NOTE: A campus represents a number of buildings in relatively close proximity, such is characteristic of a college or university. Other campus-type organizations might include hospitals, prisons, resorts, theme parks, and industrial complexes. Most campuses of that sort have centralized utility distribution systems. They often have their own utility plants and may distribute their own energy.

How Do Chargebacks Work?

In most chargeback situations, individual buildings are served from an in-house system. Typically, these smaller divisions or departments do not receive utility bills from commercial vendors. A chargeback involves taking the energy and other utilities provided by the campus as a whole, and allocating or charging the individual campus units for the energy used in their buildings.

Why Are Chargebacks Useful?

Why do people want to do chargebacks? Why do people spend a lot of time and money doing it?

1. Often, it is a matter of budgeting and accountability. Most organizations have a general budget, but then there are auxiliary budgets for classrooms, dining halls, dormitories, or athletic facilities. Often, those kinds of activities are required to be self-supporting, and the divisions may have to pay their own way from the fees they collect. Or there may be contractual or legal obligations to external funding sources which require accounting for all spending, including utilities.

2. Sometimes chargebacks are important as a step toward more detailed energy reporting.If you want to receive ENERGY STAR ratings, you need to know individual consumption for each building. And that doesn’t work unless you have a way to allocate the energy use.

3. Chargebacks are helpful in meeting mandates or legislated energy reporting. A number of city governments now have energy reporting requirements for public and commercial facilities over a certain minimum square footage. Some state governments are also requiring that certain types of buildings report their energy use. So use and cost allocation become necessary to keep an organization in compliance.

4. Chargebacks are valuable in their role in assessment and reporting on energy conservation projects. Measurement and verification involves cost and use comparisons of the pre-retrofit or baseline period with the post-retrofit period. So it becomes very important to be able to allocate energy use and cost in a very granular fashion. This is what a chargeback can help provide.

5. Chargeback data is also helpful in benchmarking and other types of comparisons. One increasingly popular type of comparison, especially in higher education, is the competition (dorm vs.dorm). These types of comparisons would be impossible without the behind-the-scenes bookkeeping associated with chargeback processes.

6. Energy dashboards displaying various types of sustainability data are common in certain types of buildings. College campuses that are more aggressively and publicly tracking energy use may present that data from a kiosk location, or a large monitor in a lobby or other public area. Often these dashboards include a real-time representation of the building or organization’s current energy use. And often, these dashboards are populated to some extent with chargeback data.

7. Another value stream for chargebacks is in allocating line loss.Line loss represents the energy consumed in moving power through the distribution system between the point of receipt and the point of delivery. Often, an institution needs to reconcile the total energy received or generated with the total energy actually used or measured at the meter level. Chargebacks provide a valuable tool for allocating line loss in an equitable fashion, perhaps on a square footage or use basis.

8. Some campuses have privatized their central energy plant, so the central heating plant or the central cogeneration plant is no longer owned by the university. It may be owned by a private company that operates it for a profit. In this type of situation, the cost and use accounting becomes very important.

Where Does Chargeback Data Come From?

Different types of chargeback data

We’ve seen why chargeback data is valuable. But how is that data obtained? One way is simply to estimate it.

Estimates are necessary if submetering equipment is unavailable. If a meter is not present at a facility, the energy use can be estimated using building square footage as an approximate but impartial measure. The estimate can be further refined by incorporating a weighting factor, so that a less energy-intensive building (such as a warehouse with marginal climate control) would be weighted less than a more energy-intensive building (such as a primary computer lab).

Data is also available from the utility vendor. Not every building has its own direct connection to the local vendor, but somewhere on the campus, the university is buying water and electricity and natural gas and maybe other types of commodities as well. So all campuses get some actual bills from their local utility vendors and that’s another source of potential information that can be used in the chargeback process.

Optimally, all or most locations would be submetered. This would allow for calculations that would provide the most accurate view of the actual energy consumed in each managed building.

Metering Systems

Two types of metering systems

The first type includes manual read meters that are older and less expensive. To obtain energy data, someone walks around the campus once a month and reads the meters. That meter reading is compared to the prior reading, accounting for any rollover and the meter multiplier. The end result is a monthly record of utility use for that meter.

The second type of metering system includes Automated Meter Reading (AMR) instruments. Early automated read instruments were essentially old-style manual meters with a simple reader mechanism bolted on top. The reader automatically transmits the data to the utility vendor at a predetermined interval frequency. Meter data is stored in a computer database, then the computer does the math to convert meter readings to commodity use and cost.

Smart Meters

Today, smart meters have opened the door to two-way communication between the utility vendor and the individual meter, or even three-way communication with the vendor, meter, and building owner. This networked Advanced Metering Infrastructure (AMI) presents new possibilities for energy tracking, efficiency, grid demand management, and cost reduction.State-of-the-art smart meters are capable of recording and reporting virtually in real-time.

Chargeback Challenges

For many organizations, chargeback processes that are already in place can present a number of potential pitfalls.The first pitfall is that the process has become increasingly unwieldy and unworkable over time, despite everyone’s best intentions.

EnergyCAP engineers have worked with a number of organizations that were using elaborate homegrown chargeback processes, that included a dizzying array of Excel spreadsheets. Data was being passed from cell to cell and worksheet to worksheet.

This type of Excel system is not flexible or scalable to meet the needs of a comprehensive chargeback process.

Integrating submeter data is only part of that process. What changes need to be made when a meter is swapped out? How do you handle departmental reorganization? How do you apply cost to use? Are you allowed to add a surcharge? What about an administrative fee?

A frequent result of outdated homegrown chargeback processes is that they fail to accurately allocate energy expenses.

How to allocate demand

Additionally, many homegrown chargeback processes do not consider demand charges, which can be quite substantial. One university in the Northeast had a high number of funded medical research spaces, which were quite energy-intensive. Without a demand allocation system in place as part of the chargeback process, the university was subsidizing higher demand users through the general budget.

No visibility

Another problem with homegrown processes is that they are often very opaque. The utility end-users have little or no access to their accounts. Since data is handled in the background, they can’t log in and view the account history. Sometimes there is no audit trail, particularly with spreadsheet management. Problem bills become very hard to track and audit.

Time consuming

Homegrown systems tend to be labor-intensive.And they often rely on a single individual’s know-how and expertise. So if Lisa, who has been doing this for 20 years and has put together all the spreadsheets, is out sick, then the organization may have a problem.

Ultimately, chargebacks should flow smoothly to the accounting system, because they are utility bills. They are not payables; they are receivables. Someone is being billed, and either they are going to cut a check or the expense is going to be deducted from their budget line item. Either way, it’s a receivable. And without an automated interface for transferring chargeback data to and from the accounting office, then someone is going to have to key that utility billing information all over again. And that process can be very cumbersome, inefficient, and error-prone.

Two Best Practices

We’ve looked at some of the challenges of maintaining an effective chargeback process. So what are the best ways to do this?

Use Submeters

The most important way to maintain an effective chargeback system is to use submeters to track energy use in the most granular fashion possible. Allocations based on floor area and an agreed-upon weighting factor may be acceptable, but submetering will be the best by far.

Invest in Software

Invest in energy management software that includes chargeback functionality. That system should be capable of producing all required energy management reports, and data must be portable to the organization A/P system. As we have observed, handling energy data in a comprehensive and efficient way can be very challenging.

The end result of a quality chargeback process should be that the energy data is processed in a timely fashion, with a full accounting for all related expenses.Chargeback data should be transparent, auditable, and shareable.

Submetering Suggestions

What should you consider when implementing a submetering system?

1. Ensure that 15-minute interval data is available.Interval data enables demand-related reporting—this data is a prerequisite for participation in demand reduction programs.Interval data also enables more detailed analysis of energy use patterns associated with the metered buildings. This type of analysis can provide more insights into energy savings opportunities.

2. Store your submeter data in the cloud, and not on your own servers. Submeter data, particularly 15-minute interval data, accumulates very quickly. This type of data can be stored in the cloud very economically, avoiding concerns about adding to your organization’s server capacity.

3. Implement an effective data validation process. You would be surprised how often this vital step is overlooked. Just because the submeters are installed, and data is flowing smoothly back to a database, does not mean that the data will be helpful or even usable.

Fortunately, automatic processes can be set up to check for data dropouts and outliers. In most cases, those same processes can estimate replacement data or at least flag unreliable data for review by a human being. Validation is very important because a chargeback process built on submeter data is only as credible and reliable as the data itself. And raw data is exactly that—raw.

4. Consider the data end users—the energy stakeholders in the organization. Who will be using the data, and how will it be used? At the very least, the submetering system should produce an output which can be easily translated to a variety of different formats to enable communication and analytics.

5. Ensure that the system can easily and seamlessly create and deliver chargeback bills.

6. Assure that the submeter system has some sort of early warning capability. Ideally, this would include configurable alerts and alarms that will send a text message or email when something doesn’t turn on or off, or if some critical value is under or over the limit.

7. Implement a metering system that provides assistance with remote diagnostics. If the submetering system is very intelligent, it can help diagnose what’s going on in the building without the need to send a repairperson out there to take a look at the system. Remote diagnostics can indicate if controls have failed, schedules were altered for a special event, and many other issues.

8. Consider a system that can interface directly with data display systems including dashboards and kiosks. This is becoming very popular.

9. For very sensitive facilities, such as certain types of laboratory buildings, you may be very concerned about power quality. Consider looking at more expensive, more capable meters that can monitor fine gradations in power readings.

10. Consider the system’s energy use forecasting capabilities. This can be very helpful in budgeting. You can project how much energy you’re going to be using in the future using heating degree day and cooling degree day forecasts.

11 Desirable Energy Management Software Features

Energy management software is the ‘glue’ that binds together the submetering system hardware and your chargeback processes. It does this by providing a database for storing submeter data, and an interface for designing and updating chargeback calculations using that data. Powerful energy management software can leverage submeter data for in-depth analytics.

Here are 11 recommendations for energy management software features that will help ensure an efficient and effective chargeback process. The software should:

1. Provide integrated tracking of external purchased utility bills, as well as internal chargebacks. Often, the unit cost for the chargeback is based at least in part on what was paid per unit for the big bill that was received at the substation. It’s important to integrate from the production and consumption angles.

2. Be web-based so that customers can login and view their accounts conveniently, just as they might do with a utility vendor.

3. Provide flexibility to track supplied energy and chargebacks without double-counting the use or cost in reports. This can be trickier than it sounds.

4. Provide comprehensive functionality for creating chargebacks based on submeter readings and calculations, since there may be situations where some of the space is submetered and some is not. For example, you might have a complex of three buildings, two of which are submetered. The energy use of the third building could be calculated by subtracting the submetered use of the remaining buildings from the total energy supplied to the complex. So the software needs to do more than just process the submeter data. You may want to use formulas for calculating the allocations.

5. Accommodate percentage splits. In many multi-use facilities, building wiring may make more granular submetering impractical. There may also be HVAC limitations. In those cases, you may want to submeter the entire building but then split the use using different budget/GL codes.

6. Accommodate a process for entering estimates for energy use. There will certainly be situations where that need will arise. A meter might fail, requiring an estimate for a month of utility use. It might be necessary to provide estimates for buildings that are not yet adequately submetered.

7. Add administrative fees and surcharges to your chargeback transactions. This is one way to help recover the cost of the submetering system and the software—an important part of the cost of doing the business of providing utilities for your internal customers.

8. Allocate expenses related to energy generation. This is important in the event that your organization has a cogeneration plant. It is important to factor in more than the cost of kilowatt hours. There might be additional allocations of labor and maintenance, as well as capital costs that you are allowed to recover. But you need a way to do that.

9. Seamlessly integrate with your accounting system to the degree that is desirable and necessary to avoid duplication of labor and provide for prompt handling of utility invoices externally and internally.

10. Provide an interface with the ENERGY STAR Portfolio Manager, a ubiquitous energy benchmarking service provided by the EPA. This will dramatically streamline the process of obtaining ENERGY STAR building ratings.

11. Provide robust analytics, including measurement and verification, as well as cost avoidance.

Conclusion

Developing a new chargeback process, or revising an existing chargeback process provides a unique opportunity to enhance an organization’s energy management capabilities. The software and hardware components that encompass a submetering system must work together to provide a maximum benefit. Multiple value streams can be realized with thoughtful planning and implementation.

eBooks