T2605 Appendix 3 - Reporting Requirements 12.19.24~1.docx

Appendix 3: REPORTS REQUIREMENTS

INTERNET REPORTS AND SCREENS

The Contractor shall maintain all energy data entered into the comprehensive database for reporting at six (6) levels:

1. Participant Energy Account level, with associated general ledger account number;

2. Building name level;

3. Participant facility name level (i.e. one or more supplier energy accounts or meters serving a specific facility), but maintained in account level detail by building;

4. Participant division level, if applicable;

5. Participant departmental level of detail which includes all facility and division levels of detail into a single departmental level view; and

6. Statewide level of detail which includes all Participant energy account levels, building name levels, facility name levels, division levels and department levels into a single Statewide report.

This level of hierarchy shall be maintained and available for all reporting purposes. Reports shall be available and able to be sorted and demarked by any data field available in the system. All reporting and data capture shall be by Participant fiscal year (accounting for meter read dates around these dates). The Participant fiscal year is July 1 through June 30. For example, July 1, 2022 through June 30, 2023 is Participant fiscal year 2023. The Contractor shall generate reports upon request for any line item of information that is requested by the Participant.

The Solution will provide year-over-year, month-over-month, week-over-week or day-by-day energy, cost, or equipment health and performance reports. Reports will be generated for single or multiple sites in a format specified by, or acceptable to the Participant.

The solution will provide users the ability to create and save custom reports.

The Contractor shall make data available to the Participants for each energy account, PoD ID, building, facility, division, department and Participant (i.e., inclusive of applicable facility-related energy accounts) monthly and annually (by fiscal year).

The following cost, consumption and energy efficiency metrics are required:

1. Total consumption volume (kWh, MMBTU, therms, ton hours, gallons etc.);

2. Peak electricity demand (kW) and Load Factor (%);

3. Total cost by energy type (electricity, natural gas or propane, heating oil, thermal or chilled water, steam, hot water, diesel fuel, gasoline, water, sewer, etc.);

4. Unit cost ($/kWh, $/MMBTU, $/ton-hr, $/therm, $/gal. etc.);

5. Supply and delivery charges ($/kWh, $/MMBTU, $/ton-hr, $/therm, $/gal. etc.);

6. Occupancy cost ($/square feet by bill);

7. Total cost;

8. Greenhouse gas emissions in CO2e tons (as applicable); and

GENERAL REPORTS

The Contractor’s online data system shall provide the following reports:

A. Monthly Energy Account bill data report including all usage and calculated data, total usage, cost factors and total cost, and subtotals for Societal Benefits Charges, including the ability to see all months by fiscal year in the same report as an optional screen.

B. Annual Energy Account bill data report by facility by month and fiscal year. Yearly Energy Account bill data report by division by month and fiscal year. Annual Energy Account bill data report by department by month and fiscal year. Annual Energy Account bill data report Statewide by month and fiscal year.

C. Annual Energy Account bill data report Statewide by Energy Vendor.

D. Current Energy Account report including department, NJCFS code, facility name and address, facility number, LBAM number, square footage, service type and city.

E. Supplier report including name, account numbers (NJCFS and Supplier or LDC), meter numbers, tariff codes and Supplier contact names, billing addresses and phone numbers.

F. Participant name report including Energy Account number, NJCFS code, facility name, LBAM name, division, department and contact name, phone number and email address. The Participant will supply this information to the Contractor.

G. Monthly List of Issued or Voided Checks shall list issued and voided checks with explanations of why checks were issued or voided.

AD HOC REPORTING

The Contractor’s online data system shall include a data mining capability that can mine information from all data in the comprehensive database. The data mining capabilities available to users shall allow querying of any data fields captured from utility/energy bills received by the Contractor. Users shall be able to export any queried data into standard reporting format (See Appendix 3 – Section 5). Data mining capabilities shall include the ability to choose from a variety of fields, ability to specify data ranges, and the ability to view line-by-line details of bills or budget data. Data searches should be available by cost, demand, usage and use per square feet and other variables. The ability to perform wildcard searches shall be made available for all search fields. Report settings must be savable.

ADDITIONAL REQUIRED SPECIFIC REPORTS

All reports shall be viewable online and compatible with downloading into Microsoft Excel. Reports shall be generated for different levels by energy account, building, facility, division, department and Participant by month and by fiscal year. Below is a list of required specific reports. The Contractor shall create additional specific reports as needed by the Participant at no additional cost.

The Forecast Reports shall enable users to accurately forecast budget needs for utility accounts. This report shall have the ability to change consumption and utility cost at the account level.

The Meter Report (NJ Transit – B) shows by meter number the commodity type, the rate code, the service provided, the facility name and account status (active or inactive).

EXPORTING, GRAPHING, AND PRINTING

The Solution will export reports to the following file formats.

a. .pdf

b. doc

c. .jpg

d. xlsx/xls

e. html

The Solution will allow users to export data (all, or selected points or totalizations) to the following file formats for use in external tools such as MS Excel and MS Access.

a. xlsx/.xls

b. .csv

c. .xml

d. ASCII

Participants shall be able to print reports and screens on local or network printers. Paper conservation in the formatting and printing of reports is to be considered and taken into account and wastage avoided. Reports should be formatted to fit on one 8 ½ x 11 page where possible.

T2605 – Appendix 3 Page 6 of 6 25DPP01093