Loading...
RES 16-17-124B ALL SIGNED LAS CRUCES UTILITIES BOARD RESOLUTION NO. 16-17-124B A RESOLUTION RECOMMENDING APPROVAL OF AQUAHAWK/ UTILITYHAWK'S CUSTOMER WEB PORTAL AS PROVIDED FOR IN RESOLUTION 16-17-124A, ENERGY SAVINGS PERFORMANCE CONTRACT, AND AUTHORIZE STAFF TO PROCEED WITH IMPLEMENTATION OF THIS SOFTWARE SOLUTION. The Board of Commissioners for the City of Las Cruces Utilities, on behalf of the City of Las Cruces, is informed that: WHEREAS, the Las Cruces Utilities ("LCU") Board of Commissioners ("Board") approved Resolution 16-17-124 for an Investment Grade Audit agreement with Johnson Controls, Inc. on May 11, 2017, to expedite the completion of the Advanced Metering Infrastructure ("AMI") project; and WHEREAS, the LCU Board approved Resolution 16-17-124A, which recommended that the Las Cruces City Council ("Council") approve the Guaranteed Utility Savings Contract on December 14, 2017; and WHEREAS, Council adopted Ordinance 2837 for the issuance of up to $22,500,000.00 in Subordinate Lien Bonds to finance the Energy Savings Performance on January 16, 2018; and WHEREAS, Council approved Resolution 18-122 to amend the LCU Fiscal Year 2018 Budget to allow expenditures from Joint Utility Revenue Bond to finance the AMI project, which included the initial purchase and implementation of a customer web portal software solution; and WHEREAS, the web portal will present utility usage analysis in comparative formats such as this year versus last year, year to date, and usage patterns with customizable alert thresholds via text or email alerts; and WHEREAS, the customer web portal will allow LCU customers to LCU FY19 11/18 Rev. 2 LCU Board Resolution No. 16-17-124B Page 2 of 3 monitor/manage their usage patterns, set goals and track progress of their usage to save money and practice conservation, and provide analytical/graphical data on either personal computers or mobile computing devices in either English or Spanish, depending on the customer's preference; and WHEREAS, LCU staff has researched and reviewed the potential web portal offerings, scoring each finalist based on customer ease of use, technical criteria, and security of the software; and WHEREAS, LCU staff recommends proceeding with the implementation of the AquaHawk/UtilityHawk Customer Web Portal software solution. NOW, THEREFORE, Be it Resolved by the Board of Commissioners for the City of Las Cruces Utilities, on behalf of the City of Las Cruces: (I) THAT Implementation of the AquaHawk/UtilityHawk Customer Web Portal software is to proceed in accordance with the Energy Savings Performance Contract. (II) THAT City staff is hereby authorized to do all deeds necessary in the accomplishment of the herein above. DONE AND APPROVED this loth day of October 2019. APPROVED: By Board Chair ATTEST: Secretary LCU FY19 11/18 Rev. 2 LCU Board Resolution No. 16-17-124B Page 3 of 3 VOTE: Chair Little: Moved by Vice-Chair Archuleta: Commissioner Baumgarn: Seconded by Commissioner Carmichael: Commissioner Johnson: Commissioner Sorg: Commissioner Vasquez: APPROVED AS TO FORM: Sr. A sistant City Attor 4lA`I// LCU FY19 11/18 Rev. 2 Exhibit "A" Vendor Research and Scores UtilityHawk Ranking Smart Energy Water Ranking Staff questions-Section ranking: N/A =0, Low=1, Medium =2, High =3 UtilityHawk advised they have multiple customers using Munis. Only one customer integrating with Munis responded to survey questionnaire- SmartEnergyWater advised they have Integration with Henderson NC.They only export Munis multiple customers using Munis. No 1 Munis? data via manually generated Crystal 1 customers using Munis responded to Reports (in csv format) - no automated questionnaire. process being used. Followed up with phone call to them,they have no integration with Munis system. Ranges from 11% up to 55%, depending on location. Demographic factors The one response we received indicated a Customer impacted those numbers, but also how 43%customer engagement rate with their Engagement involved the Utility is with promoting it- 3 portal. Demographic factors impacted 3 a spoke with both Hendersonville NC(11/) those numbers, but also how involved the and Dublin San Ramon Services District CA Utility is with promoting it. (55%). All responses favorable, all indicate Tech Support of the Response indicated that support can be support is responsive to any issues they 3 2 Vendor slow at times- rated as 3 out of 5. bring forward. Average rating 4.5 out of 5. About 6 months (one response also Average Timeframe indicated that involving a third party had About a year(response also indicated that For Setup of some scope changes.They recommended 3 involving a third party presented some 2 System/deploy portal thoroughly vetting internal scope delays, and may have resulted in not requests(and verifying contract before getting everything they initially wanted). finalizing). If reported,tended to be associated with Integration Problems No interface issues reported on initial with portal? their Customer Information System- not 3 questionnaire. 3 the portal. Munis does not provide a real-time Munis does not provide a real-time interface. Utility Billing data will be interface. Utility Billing data will be Real-time interface? 2 2 updated daily. Meter and consumption updated daily. Meter and consumption data will be updated from ITRON. data will be updated from ITRON. None reported on the Vendor side, a few Difficulties during reports of Utility/Internal problems installation;setup;or developing workflows or getting the 3 Unknown - no response to this question 0 training? correct data identified to provide to the vendor. Page 1 of 3 UtilityHawk Ranking Smart Energy Water Ranking Staff questions-Section ranking: N/A =0, Low=1, Medium =2, High =3 customers win register Tor access to What type of UtilityHawk by providing their email customer logins do address and entering a password. The you utilize?(i.e.— customer's email address will be their Customers login to the portal with their unique username and username. Password requirements can digital identity, which is a combination of complex password; or be customized with the default security a unique username and complex some other way of requirement, 6 character password. The password.The username can be the identifying the user, customer will also enter their contact customer's primary email address for easy so that they see only information and select t notification recall.The default password policy their information). preferences (text, email, or phone call). enforces password strength using Can the users totally When signing in for the first time,they 3 parameters such as password length, 3 create, manage, and will be asked for an account number; combination of alphanumeric and special delete their portal name on the account; and service characters.These password requirements account without any address. AquaHawk can be customized to are configurable based on Las Cruces Utility Administrator require an additional customer id or policies. intervention customer pin for added security and Customers can self-manage their portal required?What types accounts can be 'locked' so that account without Utility staff intervention. of password security additional users are not allowed to does your solution register for those accounts. Customers offer/enforce? can self-manage their portal account UtilityHawk supports the GDPR opt-out requirement and any opt-out received by the Utility can automatically remove/scrub the data as it is pushed into The SCM platform complies with GDPR UtilityHawk. UtilityHawk can also be requirements. Customer consent is customized to manage the opt-out managed and tracked in the system to Support Global Data capability allowing a customer to opt-out ensure that any customer who has opted from within the UtilityHawk interface. In out does not have their data published in Privacy Requirements 3 3 (GDPR)? this case, UtilityHawk can manage the opt the online digital platform by a) ensuring out data scrubbing capability and also that existing digital data is deleted, and b) supply a report back to the utility showing using the consent tracking as a filter for the customer accounts that have opted- any subsequent web services or data out of the service. The workflow would upload services. need to be discussed as additional charges may apply based on the level of customization required. Is the Utilities data Servers and data centers are hosted Yes,the SCM platform honors the data housed in data completely in the United States and privacy requirements of nations by centers only within additionally, all development,training, 3 housing data in data centers within the 3 the U.S. (no territories and support staff members are located in United States. or foreign nations)? the United States. What type of data Both Role and User-based permissions for The SCM platform has Role-Based Access protection Control, which is a combination of users staff. Utility Customers would be added in permissions/access a separate role with permissions 3 and roles. Roles are defined as a group of 3 restrictions do you appropriate for their level of access. permissions, and users are assigned roles utilize? I in the system. Page 2 of 3 UtilityHawk Ranking Smart Energy Water Ranking Staff questions Section ranking: NIA =0, Low=2, Medium =2, High =3 IT Security Survey Section-Section ranking:Passing =25, Failing=0 IT Security Survey jPassed 25 1passed 1 25 Tota l 55 Total 50 Possible: 58 Possible: 58 Page 3 of 3 RESOLUTION NO. 18-122 A RESOLUTION AUTHORIZING AN AMENDMENT TO THE FISCAL YEAR 2018 BUDGET FOR THE JOINT UTILITY REVENUE BONDS, SERIES 2018. The City Council is informed that: WHEREAS, on May 25, 2017, the City contracted with Johnson Controls, Inc. for an Investment-Grade Energy Audit and project proposal to determine the feasibility of entering into a guaranteed utility savings contract at the Las Cruces Utilities facilities; and WHEREAS, the Investment-Grade Energy Audit for the Energy Savings Performance Contract("ESPC") Phase I showed that a guaranteed utility savings contract was feasible; and WHEREAS, on January 16, 2018, the City Council adopted Ordinance 2837 for the issuance up to $22,500,000.00 in subordinate lien bonds to finance the ESPC; and WHEREAS, this Resolution will and clarify the approved Ordinance on for the budget amendment needed to finance the project-, and WHEREAS, the Joint Utility Revenue Bonds proceeds were not available when the City Council approved the Fiscal Year 2018 ("FY2018") Mid-Year Budget Adjustment in February 2018. City Council's approval of this Resolution will authorize an adjustment to the FY2018 Budget to allow expenditures of the Joint Utility Revenue Bonds. NOW, THEREFORE, Be it Resolved by the Governing Body of the City of Las Cruces: THAT the budget adjustment shown in Exhibit "A", attached hereto and made part of this Resolution, is hereby adopted and approved. (11) THAT City staff is hereby authorized to do all deeds as necessary in the accomplishment of the herein above. DONE AND APPROVED this 16 day Of April 20 18. APPROVED: L_-Major ATTEST: VOTE: Mayor Miyagishima: Aye (SEAL) Councillor Gandara: Aye Councillor Smith- Aye Councillor Vasquez- Absent Councillor Eakman: Aye Moved by: Sorg Councillor Sorg- Aye Councillor Flores: Aye Seconded by: Eakman APPROVED AS TO FORM: Ci t y Ittorney EXHIBIT"A" FUND 5271 : 2018 JU PROJECT ORG OBJECT DESCRIPTION FY17 ACTUALS FY18 BUDGET ADJUSTMENT FY19 AMENDED REVENUES 5271 2018 JU PROJECT 570000 INVESTMENT INCOME $0 $0 $1,000 $1,000 900100 BOND/NOTE PROCEEDS $0 $0 $5,613,758 $5,613,758 910000 BOND PREMIUMS $0 $0 $69,323 $69,323 REVENUES Total $0 $0 $S,684,081 $5,694,081 EXPEN01f.#RES 5271 2018JU PROJECT 830000 DEBT ISSUANCE COST $0 $0 ($79,503) ($79,503) 53410024 UTILITIES TECHNICAL SUPPORT 721070 PROFESSIONAL/TECHNICAL SERVICE $0 $0 ($200,000) ($200,000) 804000 INFRASTRUCTURE $0 $0 ($5,400,320) ($5,400,320) EXPENDITURES Total $0 $0 ($5,679,823) ($5,679,823) ENDING BALANCE $0 $0 $4,258 $4,258 FUND 5281 : 2018 JU DEBT SERVICE FUND ORG OBJECT DESCRIPTION FY17 ACTUALS FY18 BUDGET ADJUSTMENT FY18 AMENDED REVENUES 5281 2018 JU DEBT SERVICE FUND 910000 BOND PREMIUMS $0 $0 $163,708 $163,708 REVENUES:Total $0 $0 $163,708 $163,708 ENDING BALANCE $0 $0 $163,708 $163,708 FUND 5339 : 2018 JU DEBT SERVICE FUND ORG OBJECT DESCRIPTION FY17 ACTUALS FY18 BUDGET ADJUSTMENT FY18 AMENDED REVENUES 5339 2018 JU DEBT SERVICE FUND 910000 BOND PREMIUMS $0 $0 $483,103 $483,103 REVENUES Tatar $0 $0 $483,103 $483,103 ENDING BALANCE $0 $0 $483,103 $483,103 FUND 5349 : 2018 JU IMPROVEMENT REV BOND ORG OBJECT DESCRIPTION FY17 ACTUALS FY18 BUDGET ADJUSTMENT FY18 AMENDED REVENUES 5349 2018 JU PR1 570000 INVESTMENT INCOME $0 $0 $2,000 $2,000 900100 BOND/NOTE PROCEEDS $0 $0 $16,566,242 $16,566,242 910000 BOND PREMIUMS $0 $0 $204,572 $204,572 REVENUES Total $0 $0 $16,772,814 $16,772,814 EXPENDITURES 5349 2018 JU PR1 830000 DEBT ISSUANCE COST $0 $0 ($234,614) ($234,614) 53410025 UTILITIES TECHNICAL SUPPORT 721070 PROFESSIONAL/TECHNICALSERVICE $0 $0 ($200,000) ($200,000) 804000 INFRASTRUCTURE $0 $0 ($16,323,680) ($16,323,680) EXPENDITURES Total $0 $0 ($16,770,079) ($16,770,079) ENDING BALANCE $0 $0 $2,735 $2,735 CRY of Las ruce P E 0 P L E N E L P I IN G P E 0 P L E Council Action and Executive Summary Item # 8 Ord inance/Resolution# 18-122 For Meeting of For Meeting of April 16, 2018 (Ordinance First Reading Date) (Adoption Date) Please check box that applies to this item: ❑QUASI JUDICIAL ❑LEGISLATIVE r;JADMINISTRATIVE TITLE: A RESOLUTION AUTHORIZING AN AMENDMENT TO THE FISCAL YEAR 2018 BUDGET FOR THE JOINT UTILITY REVENUE BONDS, SERIES 2018. PURPOSE(S) OF ACTION: Amend the Fiscal Year 2018 (FY1 8) budget. COUNCIL DISTRICT: ALL Drafter/Staff Contact: Department/Section: Phone: Christopher Kiolbasa Finance/Bud2et 1541-2102 City Manager Signature: BACKGROUND / KEY ISSUES / CONTRIBUTING FACTORS: On May 25, 2017, the City contracted with Johnson Controls, Inc. for an Investment-Grade Energy Audit and project proposal to determine the feasibility of entering into a guaranteed utility savings contract at the Las Cruces Utilities facilities. The Investment-Grade Energy Audit for the Energy Savings Performance Contract (ESPC) Phase I showed that a guaranteed utility savings contract was feasible. On January 16, 2018, the City Council adopted Ordinance 2837 for the issuance of up to $22,500,000.00 in subordinate lien bonds to finance the ESPC. This resolution will clarify the approved ordinance for the budget amendment needed to finance the project. The Joint Utility Revenue Bonds proceeds were not available when the City Council approved the FY2018 Mid-Year Budget Adjustment in February 2018. City Council's approval of this resolution will authorize an adjustment to the FY2018 Budget to allow expenditures of the Joint Utility Revenue Bonds. SUPPORT INFORMATION: 1. Resolution. 2. Exhibit "A", Budget Adjustment. (Continue on additional sheets as required) Rev. 02/2012 Council Action and Executive Summary Page 2 SOURCE OF FUNDING: Is this action already budgeted? Yes ❑ See fund summary below No ® If No, then check one below: Budget ❑ Expense reallocated from: Adjustment Attached ❑ Proposed funding is from a new revenue source i.e. rant; see details below ® Proposed funding is from fund balance in the 5271/5349 2018 JU Project Fund. Does this action create any revenue? Yes ❑ Funds will be deposited into this fund: in the amount of for N/A FY No ® There is no new revenue generated by this action. BUDGET NARRATIVE Budget adjustment for Subordinate Lien JU System Irn rovement Revenue Bonds, Series 2018 FUND EXPENDITURE SUMMARY: Fund Name(s) Account Number(: Expenditure Available Remaining Purpose for Proposed ; Budgeted Funds Remaining Funds in Funds Current FY 2018 JU Project' 53410024-721070 $ 200,000.00 ! $0.00 $0.00 N/A 53410024-804000 $ 5,400,320.00 $0.00 $0.00 53410024-830000 $ 79,503.00 $0.00 $0.00 i 2018 JU Project! 53410025-721070 $ 200,000.00 $0.00 $0.00 NIA 53410025-804000 $16,323,680.00 $0.00 $0.00 53410025-830000 $ 234,614.00 $Q.QO G $0.00 OPTIONS f ALTERNATIVES: 1_ Vote "Yes"; this will approve the Resolution authorizing the budget amendment. 2. Vote "No"; this will not approve the Resolution, thus not authorizing the budget amendment. 3. Vote to "Amend"; this could delay the ESPC Phase I project. 4. Vote to "Table"; this could delay the ESPC Phase I project. (Continue on additional sheets as required) I Council Action and Executive Summary Page 3 REFERENCE INFORMATION: The resolution(s) and/or ordinance(s) listed below are only for reference and are not included as attachments or exhibits. 1. Ordinance No. 2837. (Continue on additional sheets as required) Rev, 02/2012 Imtv of Las t;ruces AWPEOPLE HELPING PEOPLE COUNCIL ACTION AND EXECUTIVE SUMMARY PACKET ROUTING SLIP For Meeting of For Meeting of April 16, 2018 (Ordinance First Reading Date) (Adoption Date) TITLE: A RESOLUTION AUTHORIZING AN AMENDMENT TO THE FISCAL YEAR 20181 ;BUDGET FOR THE JOINT UTILITY REVENUE BONDS, SERIES 2018. Purchasing Manager's Request to Contract (PMRC) (Required?) Yes 0 No DEPARTMENT SIGNATURE PHONE NO. DATE 1 Drafter/Staff Contact C> 2— lay I Department Director Budget 10 72414 t Assistant City Manager lWilliam F. Studer, Jr. 730-le Assistant City Manager/David P. Dollahon /-j jl �, M ,City Attorney Oro I j%,lLy Clerk CC Rev. 5/2017 LAS CRUCES UTILITIES BOARD RESOLUTION NO. 16-17-124A A RESOLUTION APPROVING THE FORM OF THE ENERGY SAVINGS PERFORMANCE CONTRACT PHASE I AND ACCEPTING THE INVESTMENT- GRADE AUDIT REPORT BETWEEN THE CITY OF LAS CRUCES FOR LAS CRUCES UTILITIES AND JOHNSON CONTROLS, INC., SUBJECT TO THE CITY OF LAS CRUCES CITY COUNCIL FUNDING APPROVAL. The Board of Commissioners ("Board") for the City of Las Cruces Utilities ("LCU"), on behalf of the City of Las Cruces ("CLC"), is informed that: WHEREAS, the LCU Board instructed staff to move forward with the initial conversion of manual read water and gas meters to Automated Meter Reading ("AMR") technology; and WHEREAS, on June 9, 2016, the LCU Board approved a pilot project of approximately 2,600 water meters to be to implemented as an Advanced Metering Infrastructure ("AMI") solution under Resolution 16-17-004; and WHEREAS, staff from the Gas Section followed by installing AMI gas meters. The LCU has a total of 5,630 water and gas meters; and WHEREAS, the LCU Department has been using Itron hand held meter reading devices and Multi-Vendor Reading System ("MVRS") various versions of the software for the manual readings and transfer of meter reading data to the CLC Enterprise Resource Planning ("ERP") billing system for over 20 years. Because staff utilizes Itron software and collections equipment, it was important to bring an AMR/AMI system that has proven to interface well with the CLC ERP system, as has the Itron systems; and WHEREAS, currently, the meter reading in both water and gas is considered a hybrid system that consists of Itron AMR technology, Itron AMI ChoiceConnect solution, and manual readings within our service area. Due to this hybrid system LCU LCU 12/17 Rev. 7 LCU Board Resolution No. 16,17-124A Page Jnf5 will continue to operate in a manner that is not as streamlined and efficient that vvOU/d be seen with a full AMIfixed network system; and � WHEREAS, UD May 11, 2OI7, the LCU Board awarded D Professional Services � Contract to Johnson Controls, Inc' ("]Cl"), of Irving, Texas, to perform an � / Investment-Grade Audit ("IGA") and Project Proposal Contract for the LCU i , Department in an amount not to exceed $686,268.00 including New Mexico {]rDgs � � Receipts T��, using the CUFr��t �tDt8YVid� Ph�� A�r��Dl�Dt 1�-OUO-14-O�758AA, � ' � � Ann8Odrn2nt No. Two, dated February 8, 2017/ under Resolution 16-17-124; and / WHEREAS. ]CI was to determine the feasibility of executing a Guaranteed , ` Utility Savings Contract to expedite the completion of the LCU AMI sO>Utk)n and � i implement other self-funded infrastructure improvements; and � WHEREAS, the entire development of this performance-based, guaranteed � , efficiency proposal has followed the guidelines set forth in Statewide Price Agreement � ' #15-000-14-05759AAand Public Facility Energy Efficiency and Water Conservation ' ' Act [Section 6-23-1 etSeq., NMSA 1970]; and � , WHEREAS, due to the immediate benefits to expedite the AMlimprovements, ' LCU and JCI decided to separate the IGA into two phases. Over the past five months, / ]CI extended significant effort in technical audits, meter accuracy measurements, � > development Of cost estimates, and project benefit calculations to develop this � ` Energy Savings Performance Contract ("ESPC") for the Phase Project; and � , WHEREAS, in order to realize project benefits vvh||e the water and gasAMl � systems are being installed, LCU staff is recommending to proceed with ordering the < AMI Network, order and install large water meters, and finalize all necessary engineering with current bond funds available in the fiscal year2018 budget in an LCU zZ/17 Rev. 7 LCU Board Resolution No. 16-17-124A Page 3 of 5 amount not to exceed $2.65 million; and WHEREAS, the total cost to implement the AMI system, including Automatic Leak Detection, for all 81,000 water and gas meters is estimated at $22.1 million, which would require CLC City Council to approve issuance of Joint Utility Revenue Bonds to fund the ESPC Phase I Project. The LCU Department will realize $1.35 million in annual savings by implementing the AMI solution throughout the LCU water and gas systems; and WHEREAS, the IGA report includes the analysis and recommendations for the ESPC Phase I Project to implement the AMI network, water meters, and automatic leak detection improvements; and WHEREAS, LCU plans to utilize Joint Utility Revenue Bonds to fund the ESPC Phase I Project, subject to CLC City Council approving this funding source. NOW, THEREFORE, be it resolved by the Board of Commissioners for the City of Las Cruces Utilities, on behalf of the City of Las Cruces: (I) THAT the form of the ESPC Phase I between the CLC for LCU and JCI, subject to CLC City Council approval of the funding source utilizing Joint Utility Revenue Bonds be approved. (II) THAT the IGA Report, attached herein as Exhibit "B", and made part of this resolution be accepted. (III) THAT Utilities staff is authorized to work with City Purchasing staff to set up a Professional Services Agreement for a period of one year, effective January 17, LCU 12/17 Rev. 7 LCU Board Resolution No. 16-17-124A Page 4 of 5 2018, through January 17, 2019. (IV) THAT City staff is authorized to issue JCI an initial Notice to Proceed to procure and install the AMI network, order and install large meters, and complete all necessary engineering in an aggregate amount not to exceed $2,65 million using the sources of funds listed below and reimbursing those funds immediately upon issuance of the Bonds to fund the Energy Savings Performance Contract Phase I. The reimbursement declaration will be included in the ordinance authorizing the issuance of the Bonds: ESPC PHASE I PROJECT Accounts: Amount: Series: 53410005-804100-11301 $ 160,000.00 Rates 53410006-804000 $1,165,000.00 2015A Bonds 53410014-804000 $ 3,316.04 NMFA 2007 53410015-804000 $ 156,683.96 NMFA 2007 53410008-804000 $1,165,000.00 2015A Bonds $2,650,000.00 M THAT City staff is hereby authorized to do all deeds necessary in the accomplishment of the herein above. DONE AND APPROVED this 14 th day of December 2017. APPROVED: "I By VIX Board Chair ATTEST: Secretary LCU 12/17 Rev. 7 LCU Board Resolution No. 16-17-124A Page 5 of 5 VOTE: Chair Little: Ave Moved by Baumgarn Vice-Chair Sorg: Ave Commissioner Archuleta: Ave Seconded by Vasquez Commissioner Baumgarn: Ave Commissioner Carmichael: Absent Commissioner Johnson: Absent Commissioner Vasquez: Aye APPROVED AS TO FORM: Sr. Assistant City t ney LCU 12/17 Rev. 7 L.AS CRUCES UTILITIES BOARD RESOLUTION . 1 -17- 24 RESOLUTION A DI G A PROFESSIONAL SERVICES CONTRACT T JOHNSON CONTROLS, INC., OF I VI G, TEXAS, TO PERFORM AN INVESTMENT-GRADE ENERGY AUDIT AND PROJECT PROPOSAL CONTRACT FOR THE L S CRUCES UTILITIES DEPARTMENT IN AN AMOUNT NOT T EXCEED 6,2 . ® INCLUDING NE EXIC SS RECEIPTS TAX, USING THE CURRENT STATEWIDE PRICE AGREEMENT 15-0 -14-05759 , AMENDMENT . TWO, DATED FEBRUARY 6, 2017. The Board of Commissioners for the City of Las Cruces Utilities, on behalf of the City of Las Cruces, is informed that: WHEREAS, the City of Las Cruces Utilities ("LCU") Department currently owns and operates four public utilities for its own account: natural gas, water, wastewater, and solid waste; and WHEREAS, the water utility had 34,569 connections year-to-date ("YTD") as of March 31, 2017, which is comprised of an average of 30,234 residential and 4,335 commercial customers, and with an average daily consumption of 15.04 million gallons. Total YTD unaudited water utility sales revenues for the City's fiscal year 2016/2017 ("FY17"), are approximately $11,241,643, for 4,080,729 billing units of water sold. Billing units for water service are stated and defined in thousand (1,000) gallons; and WHEREAS, associated with the water wells are: 11 ground level storage tanks, 10 booster stations, 10 pressure zones with numerous flow-regulating valves, and reservoir capacity totals 25.4 million gallons; and WHEREAS, the newly acquired Jornada Water Company ("JWC") is made up of 5 separate systems consisting of 11 wells, 12 storage/pressure tanks, and 8 booster stations supplying over 671,850,025 gallons of water. Projected annual revenue from former JWC customers billed under LCU water rate schedules is LCU 10/16 Rev,3 LCU Board Resolution No. 16-17-124 Page 2 of 5 estimated at $1,703,000; and WHEREAS, the water distribution system contains approximately 600 miles of transmission and distribution lines. The City acquired 3,320 and 310 active water customers from different small water systems. The Jornada Water Company distribution system contains approximately 90 miles of transmission and distribution lines; and WHEREAS, the wastewater utility had 33,968 connections comprised of 30,584 residential and 3,384 commercial customers. Total YTD unaudited wastewater utility sales revenues for the City's FY17, as of March 31, 2017, are $7,897,886, for 2,627,818 billing units of discharge. Billing units for wastewater service are stated and defined in thousand (1,000) gallons; and WHEREAS, there is approximately 540 miles of collection pipelines. The wastewater collection system includes: 17 lift stations and 9 permanent odor control stations; and WHEREAS, the City's natural gas utility served approximately 40,302 customers YTD as of March 31, 2017, which is comprised of 37,247 residential and 3,055 commercial customers, and has approximately 1,000 miles of gas lines; and WHEREAS, the current Statewide Price Agreement 15-000-14-05759AA, Amendment No. Two, dated February 6, 2017 ("Statewide Agreement"), was created for use by New Mexico government entities to obtain an Investment-Grade Energy Audit of a facility from private energy service company Johnson Controls, Inc. of Irving, Texas, ("JCI"); and WHEREAS, authority exists in the law for LCU to enter into a contract and funds have been budgeted, appropriated, and otherwise made available; a sufficient LCU 10/16 Rev.3 LCU Board Resolution No. 16-17-124 Page 3 of 5 unencumbered balance thereof remains available for payment; and the required approval, clearance, and coordination have been accomplished from and with appropriate agencies; and WHEREAS, ICI is a company with experience and technical and management capabilities to provide for the discovery, engineering, procurement, installation, financing, savings guarantee, maintenance and monitoring of energy and water conserving measures at facilities similar in size, function, and system type to LCUs facilities; and WHEREAS, based on all the LCU facilities that consume energy, staff has identified the need to perform a comprehensive evaluation of energy consumption performance through an Investment-Grade Energy Audit; and WHEREAS, some of the energy audit components will include: a summary/description of improvement measures that Johnson Controls, Inc ("JCI") proposes to implement, summary/description of the guaranteed reduced operating costs, cost avoidance and increased billable usage as a result of installing and/or implementing the recommended improvement measures and services, and an Investment-Grade Energy Audit report; all other aspects of the Investment-Grade Energy Audit are outlined in Attachment "A" on the Board Action Form; and WHEREAS, LCU staff is recommending a professional services contract be awarded to ICI, in an amount not to exceed $686,268.00 including New Mexico Gross Receipts Tax ("NMGRT") using the current Statewide Agreement to perform an Investment-Grade Energy Audit and Project Proposal to determine the feasibility of entering into a Guaranteed Utility Savings Contract to provide for installation and implementation of energy and water conserving measures at LCU facilities; and LCU 10/16 Rev.3 LCU Board Resolution No. 16-17-124 Page 4 of 5 WHEREAS, the timeframe for the completion of a draft Investment-Grade Energy Audit Report is within 150-days from the date of the executed Investment- Grade Energy Audit and Project Proposal Contract. THEREFORE, be it resolved by the Board of Commissioners for the City of Las Cruces Utilities, on behalf of the City of Las Cruces: (1) THAT a professional services contract be awarded to JCI, in an amount not to exceed $686,268.00 including NMGRT, using the current Statewide Agreement to perform an Investment-Grade Energy Audit and Project Proposal Contract, on LCU facilities, and in substantially the same form as shown in Attachment "B" to the Board Action Form. (11) THAT City staff is hereby authorized to do all deeds necessary in the accomplishment of the herein above. DONE AND APPROVED this 111h day of Mav 2017. APPROVED: t By Board Chair ATTEST: ' t Secretary LCU 10/16 Rev.3 LCU Board Resolution No. 16-17-124 Page 5 of 5 VOTE: Chair Little: Ave Moved by Sorer Vice-Chair Sorg: e Commissioner Baumgarn: Aire Seconded by Baumaarn Commissioner Carmichael: Ave Commissioner Ericson: —Absent. Commissioner Johnson: _. ). ?a Commissioner Pedroza: Aye APPROVED AS TO FORM: Sr, istant City: grney Ass LCU 10/16 Rev.3 i0ffilv of Las Cruces MOUNTAINS OF OPPORTUNITY LAS CRUCES UTILITIES BOARD OF COMMISSIONERS ACTION FORM For Meeting of October 10, 2019 TITLE: A RESOLUTION RECOMMENDING APPROVAL OF AQUAHAWK/UTILITYHAWK'S CUSTOMER WEB PORTAL AS PROVIDED FOR IN RESOLUTION 16-17-124A, ENERGY SAVINGS PERFORMANCE CONTRACT, AND AUTHORIZE STAFF TO PROCEED WITH IMPLEMENTATION OF THIS SOFTWARE SOLUTION. BACKGROUND: On May 11, 2017, the Las Cruces Utilities ("LCU") Board of Commissioners ("Board") approved the Investment Grade Audit agreement with Johnson Controls, Inc. to determine the feasibility of executing a Guaranteed Utility Savings Contract to expedite the completion of the LCU Advanced Metering Infrastructure ("AMI") project in Resolution 16-17-124. On December 14, 2017, the LCU Board recommended that the Las Cruces City Council ("Council") approve the Guaranteed Utility Savings Contract in Resolution 16-17-124A. On January 16, 2018, Council adopted Ordinance 2837 for the issuance of up to $22,500,000.00 in Subordinate Lien Bonds to finance the Energy Savings Performance Contract. On April 16, 2018, Council approved Resolution 18-122 to amend the LCU Fiscal Year 2018 Budget to allow expenditures from Joint Utility Revenue Bond to finance the AMI project, which included the initial purchase and implementation of a customer web portal solution. LCU customers will be able to engage with their Water and Gas services through this interactive/proactive utility services portal. This solution will allow customers to monitor/manage their usage patterns, set goals and track progress of their usage, create alerts, and provide analytical/graphical data both on a personal computer as well as via mobile computing devices in either English or Spanish, depending on their preference. „ Co tinue on additional sheets as required Name of Draf er ' Department: Phone: ]eff Dillard Utilities 541-2726 Account Nu r Amount of Expenditure: Budget Amount: N/A N/A N/A Strategic Plan Goal / Objective / Strategy Addressed: N/A Performance Bud et Goal / Objective Addressed: N/A De artment Signature Phone Department Signature Phone Utilities I� 528-3512 Budget v ri 541-2300 Assistant Legal 541-2128 City Manager P'� 541-2271 City Manager 541-2076 LCU 5/18 Rev.4 LCU Board Action Form Page 2 The web portal also presents utility usage analysis in comparative formats such as this year versus last year, year to date, usage patterns, and customizable alert thresholds to allow the customer to receive a text or email notice when they are approaching that target usage or spending. In late 2018/early 2019, staff researched the potential web portal offerings and narrowed those choices to two, which were initially reviewed with the LCU Board in the January 10, 2019, meeting. With direction from the LCU Board in that meeting, and with further direction from the LCU Board's March 14, 2019, Work Session, staff conducted further research and phone conferences with both vendors and their reference cities. One vendor had multiple cities that participated, while the other vendor did not have any reference cities that chose to participate in the phone conferences. As with all software solutions, which will use Utility data, an IT Security Compliance Review has been conducted on both vendor's web portal solutions to determine the security of our data between their system and our Munis Utility database. The information gained from both the research and the result of the Security Compliance Review has been summarized and scored in the attached Exhibit "A". Based on the score, staff recommends the LCU Board authorize proceeding with the implementation of the AquaHawk/UtilityHawk Customer Web Portal software solution. SUPPORT INFORMATION: 1. LCU Resolution No. 16-17-124B. 2. Exhibit "A" - Vendor Research and Scores. 3. Attachment "A" - Council Resolution 18-122. 4. Attachment "B" - Resolution 16-17-124A. 5. Attachment "C" - Resolution 16-17-124. BOARD OPTIONS: 1. VOTE "YES" - Will approve Resolution 16-17-124B, and approve the selection of AquaHawk/UtilityHawk's customer web portal and authorize staff to proceed with implementation of this software solution. 2. VOTE "NO" - Will reject Resolution 16-17-124B, and not approve the selection of AquaHawk/UtilityHawk's Customer Web Portal, nor will staff be authorized to proceed with implementation of this software solution. Under this circumstance, staff requests strategic guidance. (Continue on additional sheets as required)