Agenda packet — Lakewood City Council, June 25, 2024

AGENDA

REGULAR CITY COUNCIL MEETING

COUNCIL CHAMBERS
5000 CLARK AVENUE

LAKEWOOD, CALIFORNIA
June 25, 2024
ADJOURNED MEETING: 5:30 p.m.

LAKEWOOD EQUESTRIAN CENTER OPERATIONS - WEINGART BALLROOM With two options to consider, staff seeks a council decision regarding the future disposition of the Lakewood Equestrian Center.
0CALL TO ORDER 7:30 p.m.

INVOCATION: Reverend Mary Ann Pickard, Lakewood First United Methodist Church PLEDGE OF ALLEGIANCE: Scout Troop 6925
ROLL CALL: Mayor Todd Rogers
Vice Mayor Cassandra Chase
Council Member David Arellano
Council Member Steve Croft
Council Member Jeff Wood
ANNOUNCEMENTS AND PRESENTATIONS:

ROUTINE ITEMS:

All items listed within this section of the agenda are considered to be routine and will be enacted by one motion without separate discussion. Any Member of Council may request an item be removed for individual discussion or further explanation. All items removed shall be considered immediately following action on the remaining items.

RI-1 MEETING MINUTES - Staff recommends City Council approve Minutes of the Meetings held May 28, 2024
RI-2 PERSONNEL TRANSACTIONS - Staff recommends City Council approve report of personnel transactions.

RI-3 REGISTERS OF DEMANDS - Staff recommends City Council approve registers of demands.

RI-4 CITY COUNCIL COMMITTEES’ ACTIVITIES - Staff recommends City Council receive and file the report.

RI-5 MONTHLY REPORT OF INVESTMENT TRANSACTIONS - MAY 2024 - Staff recommends City Council receive and file the report.

RI-6 REAPPOINTMENT TO THE SOUTHEAST LOS ANGELES COUNTY WORKFORCE DEVELOPMENT BOARD - Staff recommends City Council approve reappointment of Michael Segura to Southeast Los Angeles County Workforce Development Board.

City Council Agenda
June 25, 2024

Page 2 ends

ROUTINE ITEMS: - Continued
RI-7 CITY HALL OFFICE IMPROVEMENTS – PHASE 3 CHANGE ORDER - Staff recommends City Council authorize staff to negotiate and execute a change order to Empire Design and Build, in the amount not-to-exceed $711,000; authorize staff to issue a purchase order to D & R office works for the additional furniture, in an amount not-to-exceed $190,000; and authorize an additional project contingency of $110,000.

RI-8 RESOLUTION NO. 2024-36; AWARD PUBLIC WORKS CONTRACT NO. 2024-8, ASPHALT IMPROVEMENTS TO THE EXISTING MAYFAIR PARKING LOT TO LOW BIDDER R.J.

NOBLE UNDER UNIFORM PUBLIC CONSTRUCTION COST ACCOUNTING ACT - Staff recommends City Council authorize the use of Proposition “C” funds in the amount of $209,391 and appropriate the funds into a project account; adopt the working details for the subject project; and adopt the proposed resolution to award a contract for the project in the amount of $209,391, to the low bidder R.J. Noble, and authorize the Mayor to sign the contract in a form approved by the City Attorney.

RI-9 AMENDMENT OF THE ANIMAL CONTROL AGREEMENT - Staff recommends City Council approve the amendment with SEAACA for animal control services for a period ending June 30, 2025, in an amount not to exceed $ 857,595 per year, in a form approved by the City Attorney and authorize the signature by the Mayor.

RI-10HEALTH AND SAFETY CONSULTING SERVICE AGREEMENT - Staff recommends City Council authorize the Mayor to execute an Amendment to the Agreement for Health and Safety Consulting Services with Pacific EH&S Service, Inc., subject to approval as to form by the City Attorney.

RI-11PROFESSIONAL SERVICES AGREEMENT WITH HARRIS COMPUTER CORPORATION - Staff recommends City Council authorize the City Manager to enter into an agreement with Advanced Utility Systems in an amount not to exceed $153,608 for the upgrade of the City’s utility billing software and extend the City’s Master Service Agreement with Harris Computer Corporation.

PUBLIC HEARINGS:

1.1 RESOLUTION NO. 2024-37; TO ESTABLISH RESIDENTIAL REFUSE RATES FOR FISCAL YEAR 2024-25 - Staff recommends City Council adopt the proposed resolution.

1.2 INTRODUCTION OF ORDINANCE NO. 2024-4; AMENDING THE LAKEWOOD MUNICIPAL

CODE TO AUTHORIZE BACKYARD BEEKEEPING FOR HONEYBEES ON NO MORE THAN TEN LOTS AT ANYTIME CITYWIDE WITHIN BOTH THE R-1 (SINGLE FAMILY

RESIDENTIAL) AND R-A (RESIDENTIAL AGRICULTURE) ZONING DISTRICTS SUBJECT TO DEVELOPMENT STANDARDS - Staff recommends City Council approve the Best Management Practices for Backyard Beekeeping in Lakewood; approve the associated CEQA exemption; and introduce the proposed ordinance. [Continued from April 23, May 28, and June 11, 2024]
LEGISLATION:

2.1 RESOLUTION NO. 2024-38; ESTABLISHING A REQUIRMENT FOR OBTAINING A PERMIT

FOR SPECIAL EVENTS AT PROPERTIES OCCUPIED BY COMMERCIAL CAR WASHES AT PROPERTIES OCCUPIED BY COMMERCIAL CAR WASHES - Staff recommends City Council adopt proposed resolution.

City Council Agenda
June 25, 2024

Page 3 ends

In compliance with the Americans with Disabilities Act, if you are a qualified individual with a disability and need an accommodation to participate in the City Council meeting, please contact the City Clerk’s Office, 5050 Clark Avenue, Lakewood, CA, at 562/866-9771, ext. 2200; or at [email protected] at least 48 hours in advance to ensure that reasonable arrangements can be made to provide accessibility to the meeting.

Agenda items are on file in the Office of the City Clerk, 5050 Clark Avenue, Lakewood, and are available for public review during regular business hours. Any supplemental material distributed after the posting of the agenda will be made available for public inspection during normal business hours in the City Clerk’s Office. For your convenience, the agenda and the supporting documents are available in an alternate format by request and are also posted on the City’s website at www.lakewoodcity.org LEGISLATION: - Continued

2.2 RESOLUTION NO. 2024-39; APPROVING MUNICIPAL LAW ENFORCEMENT SERVICES

AGREEMENT BY AND BETWEEN COUNTY OF LOS ANGELES AND CITY OF LAKEWOOD, EFFECTIVE JULY 1, 2024 - Staff recommends City Council adopt proposed resolution.

REPORTS:

3.1 AMENDMENT TO AGREEMENT WITH SOUTHWEST PATROL, INC. FOR ADDITIONAL DEPLOYMENT OF PRIVATE SECURITY PATROLS - Staff recommends City Council approve an agreement amendment with Southwest Patrol, Inc. to add two daytime security guards for a period 60 days commencing June 27, 2024, and authorize the City Manager to sign the agreement in a form as approved by the City Attorney.

3.2 CORNER LOT DEVELOPMENT – ARCHITECT/ENGINEER (A/E) DESIGN SERVICES AGREEMENT - Staff recommends City Council authorize an appropriation of $924,909 of Measure L; and authorize additional Architect/Engineer design services work to the existing on-call Architectural Services agreement for the Corner Lot Development per the Dahlin Group proposal dated June 17, 2024, in an amount not-to-exceed $924,909.

ORAL COMMUNICATIONS:

ADJOURNMENT

Addendum A - Lakewood Equestrian Center Expenses and Revenues FY24, FY25 and FY26 Council Agenda – Lakewood Equestrian Center Operations - June 25, 2024 ACCOUNTS FOR: GENERAL FUND 1090 FY-2024 FY-2024 FY-2024 FY-2024 FY-2025 FY-2026 LAKEWOOD EQUESTRIAN CENTER ORIG BUD REVISED BUD ACTUAL at 6/19/24
FINAL

ESTIMATE PROPOSED PROPOSED

REVENUES
EQUESTRIAN REV-RENT - 627,000 541,665 627,000 930,000 930,000 EQUESTRIAN CENTER REV-CONCESSION - 30,500 30,289 30,500 46,000 46,000

EXPENSES
SALARIES-REGULAR OVERTIME - - - - 2,500 2,500
SALARIES-PART TIME - 168,862 97,250 168,850 - -
SALARIES- PART TIME B - - - - 251,500 251,500
SALARIES-PART TIME OVERTIME - - 104 - - -
PERS BENEFIT - - 7,355 - 24,680 24,680
MEDICARE BENEFIT - - 1,411 - 3,700 3,700
HEALTH ACA SUBSIDY - - 72 100 300 300
ARS BENEFIT - - 310 - - -
CONTRACTUAL SERVICES - 175,884 175,635 175,900 263,850 263,850 MANURE DISPOSAL - 112,000 106,444 112,000 168,000 168,000 DISPOSAL SERVICE - 7,000 7,000 7,000 10,500 10,500
RIGHT OF WAY LEASES - 42,789 42,789 42,800 44,100 45,450 UTILITIES-ELECTRICITY - 10,000 9,954 10,000 15,000 15,000 UTILITIES-WATER - 24,800 19,779 24,800 39,804 39,804
MAINT-BUILDING STRUCTUR GROUND - 13,993 12,972 14,000 21,000 21,000 COMMUNICATIONS - 2,250 2,897 2,250 3,400 3,400
SPECIAL SUPPLIES - 131,875 129,627 131,900 172,750 172,750 SPECIAL SUPPLIES-FEED - 110,690 110,689 110,700 228,384 228,384 UNIFORMS - 1,200 1,095 1,200 1,200 1,200
VEHICLE/EQUIPMENT MAINTENANCE - 12,000 14,381 12,000 1,800 1,800 CAPITAL-MACH/EQUIP/FURN - 18,000 16,656 18,000 - -
NON-CAPITAL MACH/EQUIP/FURN - 1,200 - 1,200 - -
TOTAL REVENUES - 657,500 571,954 657,500 976,000 976,000 TOTAL EXPENSES 832,543 756,419 832,700 1,252,468 1,253,818 TOTAL GAIN/(LOSS) (175,043) (184,465) (175,200) (276,468) (277,818) Addendum B – Horse Boarding, Horse Trailer Parking and Boarder Residency Statistics Council Agenda – Lakewood Equestrian Center Operations
June 25, 2024
Addendum B - Page 1 of 2
Horse Boarding and Horse Trailer Parking Statistics
Oct- 23 Nov23
Dec23Jan24Feb24March24April24May24June24
Horses in Stalls 132 122 122 122 119 116 115 114 112
Horse Stalls
Used as Storage
Unknown 10 10 10 8 6 6 6 6
Vacant Horse
Stalls Unknown 56 57 58 63 68 69 70 72
Dry Lots
(1, 2 and #3) 8 11 7 6 4 4 4 4 4
Pony Pasture 13 14 14 14 14 13 16 16 16
Horse Trailers Unknown 23 24 22 23 22 22 22 23
Notes
SJ
Equestrian
Operations
One
horse
passed
Closed
Dry Lot
#2
Split
Stall
#114
Closed
Dry Lot
#1
Stall 16
and 25
no
longer
used as
storage
One
horse
passed
One
horse
passed
Split
Stall
#141
One
horse
passed
Stall 12
and 21
no
longer
used as
storage
One
horse
passed
One
horse
passed
One
horse
passed
Addendum B – Horse Boarding, Horse Trailer Parking and Boarder Residency Statistics Council Agenda – Lakewood Equestrian Center Operations
June 25, 2024
Addendum B - Page 2 of 2
Boarder Residency Statistics
City Oct-23 Nov-23 Dec-23 Jan-24 Feb-24 March-24 April-24 May-24 June -24 Altadena 1 0 0 0 0 0 0 0 0
Anaheim 1 1 0 0 0 0 0 0 0
Buena Park 1 1 1 1 1 1 1 1 1
Cerritos 0 1 1 1 1 1 1 1 1
Compton 1 1 1 1 1 1 1 1 1
Cypress 5 5 5 6 6 6 6 6 6
Fullerton 1 1 1 1 1 1 1 1 1
Garden Grove 2 2 1 0 0 0 0 0 0
Huntington Beach 2 2 2 2 2 2 2 2 2
*Lakewood 17 17 18 18 18 17 17 16 16
Long Beach 36 37 36 37 36 36 34 33 33
Los Alamitos 7 9 9 9 8 8 8 8 8
Maywood 1 1 1 1 1 1 1 1 1
Newport Beach 1 1 1 1 1 1 1 1 1
Placentia 1 1 1 1 1 1 1 1 1
Rossmoor 3 2 2 2 2 2 2 2 2
Santa Fe Springs 1 0 0 0 0 0 0 0 0
Seal Beach 3 3 3 3 3 3 3 3 2
Torrance 1 1 1 1 1 1 1 1 1
Westminster 3 3 3 3 3 3 3 3 3
Wilmington 1 1 1 1 1 1 1 1 1
Total Individual Boarders 89 90 88 89 87 86 84 82 81
*The address provided to the city on four (4) boarder’s applications, differs from the address on their current driver’s license. Their “Lakewood” address was used for the statistics provided in the table above.

Addendum C - Minimum Requirements for a Business Entity or Non-Profit Organization to Manage and Operate the Lakewood Equestrian Center
Council Agenda – Lakewood Equestrian Center Operations
June 25, 2024
Addendum C - Page 1 of 3
If Business Entity
An LLC or Corporation
If Non-profit Organization
Tax-exempt under section 501(c)(3) of the Internal Revenue Code 51% of Executive Board must be residents of the City of Lakewood Experience
Equestrian center management including horse care, riding instruction and facility and grounds maintenance (minimum of 5 years)
Financial Capital
Startup expenses for equipment and supplies (minimum $200,000) Startup expenses for first month of operation, including personnel, contractual services, and utilities (minimum $120,000)
Investment for imperative facility improvements (minimum $1,500,000) SCE License Fee for first year of agreement is $51,141 (New five year license would be $255,704.16.)
Insurance
The lessee is required to carry insurance coverages as detailed below.

Commercial General Liability Insurance using Insurance Services Office “Commercial General Liability” policy form CG 00 01 or the exact equivalent.

Defense costs must be paid in addition to limits. There shall be no cross liability exclusion for claims or suits by one insured against another. Limits shall be no less than $3,000,000 per occurrence for all covered losses and no less than $5,000,000 general aggregate. (Estimated at $8-10,000 annually) Commercial Equine General Liability Insurance shall be required should Commercial General Liability exclude equine operations. Coverage shall cover equestrian activities such as boarding, riding instruction and training. Coverage shall be extended to provide coverage for independent trainers or instructors while acting within the scope of their duties at the facility. Additionally, this coverage shall include these specific activities if included in the operation: guided trail rides, therapeutic riding, carriage rides, pony rides and petting zoos. Lessee shall procure and maintain, at its sole costs and expense, comprehensive Commercial Equine General Liability Insurance in the single limit minimum amount of $2,000,000 per occurrence and an aggregate in the amount of $4,000,000. (Estimated at $2,000 annually as an umbrella policy to Commercial General Liability.)
Addendum C - Minimum Requirements for a Business Entity or Non-Profit Organization to Manage and Operate the Lakewood Equestrian Center
Council Agenda – Lakewood Equestrian Center Operations
June 25, 2024
Addendum C - Page 2 of 3
Care, Custody and Control Insurance. Lessee shall procure and maintain, at its sole cost and expense, a Care, Custody and Control (CCC) policy of insurance that specifically insures against damages resulting from the death, injury, illness, or theft of non-owned horses in the care, custody and control of lessee in an amount of $300,000 per horse, with an aggregate limit of $500,000. (Estimated at $8,000 annually)
Professional liability (errors & omissions) insurance. Contractor shall maintain professional liability insurance that covers the services to be performed in connection with this Agreement, in the minimum amount of $1,000,000 per claim and in the aggregate. Any policy inception date, continuity date, or retroactive date must be before the effective date of this Agreement and Contractor agrees to maintain continuous coverage through a period no less than three years after completion of the services required by this Agreement. (Several determinations are needed in order to determine if this coverage is needed and how much coverage would cost for the types of services provided.) Horse Shows, Clinics or Equestrian Events Insurance. Lessee shall procure special event coverage in advance of horse shows, clinics or equestrian events that will provide coverage to include protection for lessee running the event and also protect the show officials and city. Coverage is provided for negligence that causes bodily injury or property damage to a third party. Coverage shall be in an amount that adequately protects both lessee and city from loss resulting from such events. (Estimate is based on size and scope of event and could be covered by liability coverage.)
Worker’s Compensation Insurance on a state-approved policy form providing statutory benefits as required by law with employer’s liability limits no less than $1,000,000 per accident for all covered losses. (Estimated at $22,000 annually for every $100,000 in annual payroll expenses).

Business Auto Coverage Insurance. Lessee shall maintain automobile insurance at least as broad as Insurance Services Office form CA 00 01 covering bodily injury and property damage for all activities of lessee arising out of or in connection with work to be performed, including coverage for any owned, hired, non-owned or rented autos, trucks and trailers, and other vehicles or equipment, to include loading and unloading, in an amount not less than $2,000,000 combined single limit for each accident. If lessee owns no vehicles, this requirement may be satisfied by a non-owned auto endorsement to the general liability policy described above. If lessee or lessee’s employees will use personal autos in any way. Lessee shall provide evidence of personal auto liability coverage for each such person. (Estimate is dependent on the quantity and type of vehicles to be covered.)
Addendum C - Minimum Requirements for a Business Entity or Non-Profit Organization to Manage and Operate the Lakewood Equestrian Center
Council Agenda – Lakewood Equestrian Center Operations
June 25, 2024
Addendum C - Page 3 of 3
Excess or Umbrella Liability Insurance (Over Primary) if used to meet limit requirements, shall provide coverage at least as broad as specified for the underlying coverages. Any such coverage provided under an umbrella liability policy shall include a “drop down” provision with a maximum $25,000 self-insured retention. Lessee will be required to fully indemnify and hold harmless city, its elected or appointed officers, agents, officials, employees, and volunteers, for any injury to person of property resulting from its operations.

Commercial Property Insurance covering the facility, fixtures, equipment, building, all property situated in, on, or constituting a part of Facility and any improvements. Coverage shall be at least as broad as the Insurance Services Offices broad causes of loss form CP 10 20, and approved of in writing by city.

Coverage shall be sufficient to insure 100% of the replacement value and there shall be no coinsurance provisions. The policy shall include an inflation guard endorsement, 100% rents coverage, contents coverage, coverage for personal property of others, ordinance or law and increased cost of construction coverage.

City shall be included as an additional insured and as loss payee on any such insurance. City shall not be liable for any business income or other consequential loss sustained by lessee. City shall not be liable for any loss of lessee’s personal property even if such loss is caused by negligence of city, city’s employees or agents. (Estimate is based on the replacement costs of structures. For property limits totaling about $4.5 Million, the estimated expense is about $26,000 annually)
If providing youth programs
Originating Agency Identifier (ORI) for background checks Develop and implement child abuse prevention policies and procedures which include (but are not limited to):
o policies to ensure incidents of suspected child abuse are reported to the appropriate entities. Section 11165.9 of the California Penal Code o policies requiring the presence of at least two mandated reporters when employees and volunteers are in contact with or supervising children.

Addendum D – Equestrian Facilities in Los Angeles and Orange Counties Council Agenda – Lakewood Equestrian Center Operations
June 25, 2024
Equestrian Facilities in Los Angeles County
B&B Stables (license agreement through Southern California Edison) 10730 Artesia Blvd, Cerritos, CA 90703
562-865-9012
Rancho Verde Riding Club (license agreement through Southern California Edison) 1000 West Carson Street, Long Beach, CA 90810
King of King’s Equestrian Ranch (Privately owned)
7220 Century Blvd. Paramount, CA 90723
562-889-5100
Imperial Equestrian Center (Privately owned)
5543 Leeds Street, South Gate, CA 90280
562-260-9175
Whittier Narrows Equestrian Center (leased by Los Angeles County) 12191 Rooks Road, Whittier, CA 90601
(562) 355-5765
Schabarum Equestrian Center (leased by Los Angeles County) 17250 East Colima Road, Rowland Heights, CA 91748
(626) 854-5560
Marshall Canyon Equestrian Center (leased by Los Angeles County) 7000 Esperanza Dr, La Verne, CA 91750
909-593-8739
Bonelli Equestrian Center (leased by Los Angeles County) 100-114 Via Verde Drive, San Dimas, CA 91773
909-599-8411
Los Angeles Equestrian Center @ Griffith Park (leased by City of Los Angeles) 480 Riverside Dr, Burbank, CA 91506
818-840-9063
Peter Weber Equestrian Center (leased by City of Rolling Hills Estates) 26401 Crenshaw Boulevard, Rolling Hills Estates, CA 90274 310-541-9487
Palos Verdes Stables (leased by City of Palos Verdes Estates) 4057 Via Opata, Palos Verde Estates, CA 90274
310-493-2239
Addendum D – Equestrian Facilities in Los Angeles and Orange Counties Council Agenda – Lakewood Equestrian Center Operations
June 25, 2024
San Pascual Stables (leased by City of South Pasadena)
221 San Pascual Ave, South Pasadena, CA 91030
323-551-6841
Arroyo Seco Stables (leased by City of South Pasadena)
118 Marmion Way, South Pasadena, CA 91030
626-437-1511
Sycamore Canyon Equestrian Center (leased by the City of San Dimas) 1525 Sycamore Canyon Rd., San Dimas 91773
909-599-9681
Shadow Hills Equestrian Center (Privately owned - residential) 10263 La Canada Way, Shadow Hills, CA 91040
213-761-0549
Greatheart Stables (Privately owned - residential)
648 S Mariposa St, Burbank, CA 91506
818-859-9801
Equestrian Facilities in Orange County
Huntington Central Park Equestrian Center (leased by City of Huntington Beach) 18381 Golden West St., Huntington Beach, CA 92648
714-848-6565
Peacock Hill Equestrian Center (leased by OC Parks)
1 Irvine Park Rd, Orange, CA 92869
714-997-7720
Equestrian Center at the OC Fair & Event Center (operated by 32nd District Agricultural Association of the State of California)
88 Fair Drive, Costa Mesa, CA 92626
714-708-1652
El Rodeo Equestrian Center (Privately owned)
4449 Carbon Canyon Road, Brea, CA 92823
714-525-7510
Serrano Creek Ranch Equestrian (leased by the City of Lake Forest) 25200 Trabuco Rd, Lake Forest, CA 92630
949-768-5891
Addendum D – Equestrian Facilities in Los Angeles and Orange Counties Council Agenda – Lakewood Equestrian Center Operations
June 25, 2024
Nellie Gail Ranch Equestrian Center (Privately owned)
25202 Nellie Gail Rd, Laguna Hills, CA 92653
949-425-1477
San Juan Capistrano Equestrian Center
26282 Oso Rd, San Juan Capistrano, CA 92675
949-661-1755
Rancho Sierra Vista
31441 Avenida De La Vista, San Juan Capistrano, CA 92675 949-661-3867
Santiago Equestrian Center (Privately owned)
18381 Santiago Canyon Rd, Silverado, CA 92676
949-858-0221

PICKLEBALL OUTDOOR NATURE LEARNING

NATURE PLAY

SKATEPARK / BIKE PUMP TRACK

COMMUNITY CENTER

OUTDOOR NARURE LEARNING

LANDSCAPE BUFFER AREA
PICNIC AREA: LARGE
PICNIC AREA: SMALL
NORTH
SCALE 1”=50’
0’ 50’ 100’ 200’
g
0 20' 40' 80'
0 20' 40 0 20' 40' 80'
0 20' 40' 80'
Lakewood Equestrian Center Repurpose Concepts / 020462.00 / Lakewood, CA / JUNE 2024

SAN GABRIEL RIVER

RYNERSON
PARK

E CARSON STREET

DROP-OFF

EXISTING TOWERS

POWER LINE

LOOP TRAIL

LIMIT OF WORK

PEDESTRIAN CIRCULATION

OUTDOOR NATURE

LEARNING

COMMUNITY

CENTER /

RESTROOM
6000 SQ FT BLDG PARKING

PARKING

PARKING
NATURE

PLAY PICKLEBALL
COURTS

NATURALIZED

PLANTING

SKATE / BIKE

PUMP TRACK
RR

PETTING ZOO
/ PONY RIDES

TRAIL WITHIN

EXISTING TREES

LANDSCAPE AREA

PICNIC AREA

LANDSCAPE AREA

OPEN TURF

LANDSCAPE AREA

BIKE TRAIL ACCESS

ADDENDUM E - FACILITY ALTERATIVE USE PLAN
COUNCIL AGENDA - LAKEWOOD EQUESTRIAN CENTER OPERATIONS - JUNE 25, 2024

Advanced Utility Systems
8133 Warden Ave, Floor 7, Markham, Ontario, Canada L6G 1B3 City of Lakewood, CA
Statement of Work
Infinity CIS V3 to V5 Upgrade
Including Customer Self-Service
Portal and Mobile Workforce
Management
(Hosted)
Created: April 18, 2024
Valid Until: July 18, 2024

Page 2 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
Table of Contents
Introduction ........................................................................................................................................... 5 Lakewood Points of Contact................................................................................................................. 5 Primary Point of Contact (POC):........................................................................................................... 5 Project Scope ........................................................................................................................................ 6 Definitions.............................................................................................................................................. 7 Roles and Responsibilities ................................................................................................................... 9 Advanced Responsibilities:................................................................................................................... 9 Lakewood Responsibilities: ................................................................................................................ 10 Constraints and Assumptions ............................................................................................................ 11 Task 1 – Project Management............................................................................................................. 14 Subtask 1.1 – Project Planning........................................................................................................... 14 Subtask 1.2 - Change Control Process .......................................................................... 14 Subtask 1.3 – Status Reports............................................................................................................. 14 Subtask 1.4 – Quarterly Sponsor Review ........................................................................................... 15 Task 2 – Infinity CIS v5 Interfaces....................................................................................................... 16 Subtask 2.1 – Infinity CIS V3 Interfaces.............................................................................................. 16 Subtask 2.1.1 – Neptune Meter Reading Interface ................................................... 16 Subtask 2.1.2 – Infosend Bill Print Interface ....................................................... 16 Subtask 2.1.3 – Meter Change Import Interface ....................................................... 17 Subtask 2.1.4 – OCR Payment Import Interface.......................................................... 17 Subtask 2.1.5 – Balance Adjustment Import Interface........................................... 17 Subtask 2.1.6 – Notices Interface ................................................................................ 18 Subtask 2.1.7 – Collection Agency Interface............................................................ 18 Subtask 2.2 – Additional Interfaces & Modifications ............................................................................ 19 Subtask 2.2.1 – Paymentus Autopay Enrolment Import ............................................. 19 Subtask 2.3 – Reports........................................................................................................................ 19 Task 3 - Implementation Approach..................................................................................................... 19 Subtask 3.1 – Phase 1 – Project Initiation........................................................................................... 20 Subtask 3.2 – Phase 2 – Solution Overview ....................................................................................... 21 Subtask 3.2.1 – Solution Overview Workshop.............................................................. 21 Subtask 3.3 – Phase 3 – Interface Discovery...................................................................................... 22 Subtask 3.4 – Phase 4 – Other Discoveries........................................................................................ 23 Subtask 3.4.4 – Accelerated Innovations (AI) MyMeter Customer Self-Serve portal (CSS) Discovery ....................................................................................................... 23 Subtask 3.4.5 – ServiceLink Mobile Workforce Management (MWM) Discovery . 24 Subtask 3.4.6 – SmartVX (Welcome Videos).................................................................. 24 Subtask 3.5 – Phase 5 – Data Integrity Check/Clean-Up & Initial Data Conversion/Configuration ....... 25 Subtask 3.5 - Version 3 Data Integrity Check and Clean-up .............................. 26 Subtask 3.6 - Infinity CIS v5 Initial Upgrade Conversion, Data Validation and Testing .............................................................................................................................. 27 Subtask 3.7 – Phase 6 – Customer Training....................................................................................... 30 Subtask 3.8 – Phase 7 – Reports Development and Delivery ............................................................. 31 Subtask 3.9 – Phase 8 – Interface Delivery ........................................................................................ 31 Subtask 3.10 – Phase 9 – Software Testing ....................................................................................... 32 Subtask 3.11 – Phase 10 – End User Training ................................................................................... 37 Subtask 3.12 – Phase 11 – Provision and Technical Validation of Production Instance....................... 38 Subtask 3.13 – Phase 12 – Cut-Over Plan/Go/No Go Criteria............................................................. 39 Subtask 3.14 – Phase 13 – Transition to Live..................................................................................... 40 Subtask 3.15 – Phase 14 – Post Go Live............................................................................................ 41 Schedule 1 – Fees and Payments....................................................................................................... 42

Page 3 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
Fees .................................................................................................................................................. 42 Payment Milestones........................................................................................................................... 44 Termination.......................................................................................................................................... 45 Approvals............................................................................................................................................. 46 Appendix 1 – Table of Responsibilities (Deliverables) ...................................................................... 47 Appendix 2 – Reports.......................................................................................................................... 51 Appendix 3 – MyMeter Utility License ................................................................................................ 62

Page 4 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
SOW Version Control
Version Number Purpose/Change Author(s) Date
1 Creation of SOW Pav Sekhon April 16, 2024

1.1 Change to 7 yrs
of data
conversion +
addition of 15
MWM users +
proration of
annual fees.

Pav Sekhon June 3, 2024

Page 5 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
Introduction
The project is defined as the upgrade of Infinity CIS, by Advanced Utility Systems (“Advanced”) for City of Lakewood, CA (“Lakewood”) . The current Infinity CIS Version 3 (“V3”) instance will be upgraded to Infinity CIS Version 5 (“V5”), delivered via the Infinity Cloud Platform and will replace the current Orion Hosted version of Infinity CIS.. Additionally, optional value-add software solutions including Accelerated Innovations (AI) MyMeter Customer Self-Serve portal (CSS) and Service-Link Mobile Workforce Management (MWM) will be deployed as a part of the scope of this project.

This document describes the Scope of Work (“SOW”) to be delivered by Advanced, as well as defines the principal activities and deliverables of both Advanced and Lakewood for this project.

The project as outlined in this Scope of Work (“SOW”) encompasses all aspects of Lakewood’s Infinity CIS v5 upgrade, including but not limited to project management, requirements gathering, data integrity and clean up, data conversion, configuration including interfaces, and training.

Lakewood Points of Contact
Primary Point of Contact (POC):

Name Andrew Camacho
Title Admin Services Manager
Organization City of Lakewood
Address 5050 Clark Avenue, Lakewood
Phone 562-866-9771 Ext:2606
Email [email protected]
Website https://www.lakewoodcity.org/Home

Page 6 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
Project Scope
Advanced and Lakewood agree to cooperatively manage the cost, schedule, and scope of the project. Project scope is limited to the tasks and deliverables identified in this SOW and responses to the functional requirements attached to this document. Items not included in this SOW and its appendices are to be considered out of scope.

Advanced will provide the following services in regard to the Infinity CIS v5 to Lakewood:

1. Project Management.

2. Solution Overview Session:
a. Advanced and Lakewood will confirm and clarify requirements related to configurations, interfaces, and reports.

3. Data Integrity check and clean-up of Infinity CIS V3 data in Lakewood’s upgrade environment.

4. Conversion:
a. Related to data from Infinity CIS Version 3 to Infinity CIS v5. i. Advanced will convert up to seven (7) years of data from Infinity CIS V3.
b. Related to current Bill Print(s)/Notice(s)/Receipts formats from Crystal Reports XI to Crystal Reports 2013 (as confirmed during the Solution Overview session).
c. Related to Advanced created custom reports format from Crystal Reports XI to Crystal Reports 2013. Reports are summarized in “Appendix 2 – Reports” and will be confirmed during the Solution Overview session.
d. Related to interfaces as identified in Task 2.
e. Related to required billing formulas.

5. Data refreshes (Initial, Functional, ITC, UAT, Go-Live).

6. Software installation deployed
a. Software within scope of this project:
i. Advanced Infinity CIS V5, in a hosted Infinity Cloud environment
ii. Accelerated Innovation MyMeter Customer Self-Serve portal (CSS),
iii. Service-Link Mobile Workforce Management (MWM), in a hosted Infinity Cloud environment
iv. Advanced REST API.

7. Training:
a. Related to remote web-based Core Team system overview of new features and navigation of Infinity CIS V5,
b. Related to remote web-based End User Training on new features and navigation of Infinity CIS V5. Onsite delivery of this training is optional and available upon request at additional cost.

8. Technical Support.

Page 7 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
Definitions
Name Definition
Baseline Accounts A cross selection of account types and services that are used for testing purposes the Infinity CIS
solution.

BRD Business Requirements Document created by Advanced
that defines the requirements for software
modification(s) and non-configurable interfaces
required by Lakewood.

CIS Customer Information and Billing System.

Cloud Platform The underlying networking, storing, compute, security and monitoring infrastructure which provisions access
to Infinity CIS
Infinity CIS The Advanced Customer Information and Billing System.

CIS Solution All Advanced licensed software (Infinity CIS) and related implementation services.

Lakewood Owned
Control Forms
Configuration areas of the system that are the
responsibility of the Lakewood (including but not
limited to service orders, actions, letters, security,
admin).

Configuration Changes to the software that do not require source code or structural data model changes.

Core Team Training Instructor-led training delivered remotely by Advanced to the identified Project Team members of Lakewood on
the generic CIS Solution
Defect - High A code or configuration defect that makes a component of the CIS Solution unusable or inoperable. This error
is a loss of the capability of the CIS Solution to
perform an important business function.

High defects include (i) loss of the capability of the
CIS Solution to perform an important business
function; (ii) a workaround does not exist, and
testing this function cannot be performed until the
problem has been corrected.

Defect - Medium A code or configuration defect that significantly limits the CIS Solution's ability to conform to the
documentation. This limitation stops the user from
performing the normal use of the CIS Solution;
however, a mutually agreed upon workaround does exist.

Testing can continue on a module of the CIS Solution
with a workaround.

Defect - Low A code or configuration defect that limits the capability of the CIS Solution but is cosmetic or
minor in nature. There is a practical workaround, or
the defect does not impact Lakewood’s operation of the
CIS Solution in any significant respect.

Page 8 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
End User Training Instructor led (remotely) of the CIS Solution delivered by Advanced in coordination with the
Lakewood Core Team to Lakewood employee base utilizing
specific areas of the system.

Modification A change to the code base or a structural data model change.

CIS Infinity V3 Lakewood’s current customer information and billing system to be replaced by Infinity CIS V5.

Page 9 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
Roles and Responsibilities
The roles and responsibilities are summarized below and further detailed by task and subtask in “Appendix 1 – Table of Responsibilities” (Deliverables).

Advanced Responsibilities:

1. Advanced will maintain project communications with Lakewood’s Project Manager.

2. Advanced will manage the efforts of the Advanced staff and coordinate Advanced activities with the Lakewood’s Project Manager.

3. Advanced will conduct regular (e.g. weekly or as required) telephone status report conversations with the Lakewood’s Project Manager.

4. Advanced will participate in weekly reviews with Lakewood’s project team. Participation can be waived by mutual agreement.

5. Advanced will provide timely responses to critical issues raised by Lakewood’s Project Manager.

6. Advanced will prepare and submit a status report that includes: the accomplishments of the previous month, activities planned for the current month and an update to the Project Schedule in Smartsheet format, as well as an update to the action item list.

7. Advanced will prepare and submit project change proposals to Lakewood’s Project Manager as necessary.

8. Advanced will monitor the project to ensure that Advanced resources are available as scheduled.

9. Advanced will coordinate and oversee the installation of all Advanced licensed software.

10. Advanced will install all Advanced licensed software in one (1) production and one (1) test instance and will support the Advancedhosted Infinity Cloud Production environment throughout the implementation, and both hosted environments after implementation and Go-Live.

11. Advanced will coordinate and oversee the implementation efforts of all modifications and interfaces identified in this SOW (exclusive to the Infinity CIS v5 side of the interface).

12. Advanced will monitor and support all testing phases, i.e., Functional, Integrated, and User Acceptance Testing. Application consultants will be available to answer questions and resolve issues generated during testing.

Page 10 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
Lakewood Responsibilities:

1. Lakewood will provide the information required to configure and convert data into the CIS Solution.

2. Lakewood will establish a Project Team that is representative of the operational areas that will be affected by this project.

3. Lakewood will designate a Project Manager who will manage the efforts of Lakewood Project Team and/or staff and coordinate activities with the Advanced Project Manager.

4. Lakewood’s Project Manager must ensure that Lakewood’s personnel have the time, resources, and expertise to carry out their respective tasks and responsibilities to meet the project plan dates.

5. Lakewood’s Project Manager or designee will participate in the scheduled (e.g. weekly or as required) status meetings with the Advanced Project Manager.

6. Lakewood will review current business practices, consider and/or adopt new business practices as needed.

7. Lakewood will provide timely responses to critical issues raised by the Advanced Project Manager.

8. If this project requires onsite presence, Lakewood will make available meeting spaces as required for project meetings. Meeting spaces should be equipped with a white board and markers, flip chart, LCD projector, conference phone and internet connection.

9. If this SOW requires on-site presence, Lakewood shall establish a training/testing room that will provide space, computers (with necessary software) and access to the software for the number of users specified in the contract. The training room will be equipped with a white board and markers, flip chart, LCD projector, conference phone and internet connections.

10. Lakewood will ensure mutually agreed upon Change Orders are approved and process in accordance with the Change Order Procedure.

11. Lakewood Staff will attend scheduled training sessions.

12. Lakewood will perform testing as required including functional testing, integration testing, and user acceptance testing and will provide the documented test cases and results to Advanced utilizing the Advanced Testing Tool (Smartsheet).

13. Lakewood will perform manual cutover tasks identified in the data conversion and the cutover plan.

14. With support from Advanced, Lakewood will be responsible to create, configure and test all Lakewood Owned Control Forms (including but not limited to service orders, actions, letters, security, admin).

Optional training related to these activities is available upon request at additional cost.

15. Lakewood must update V5 control forms upon applying any changes to control forms in V3.

16. Lakewood must communicate and coordinate V3 rate changes with the Project Team.

Page 11 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
Constraints and Assumptions

1. All prices are quoted in US dollars.

2. The anticipated duration of this project is estimated to be 10-14 months. The Advanced PM and the Lakewood PM will finalize the project schedule within 2 weeks of the Project Kickoff meeting. Any changes to the project timeline during the project are to be communicated and reviewed by the Project Sponsors of Lakewood and at Advanced. Changes affecting the overall scope of the project or project schedule may necessitate the use of a Scope of Work Amendment process. (See Change Control).

3. The Fixed Cost will be firm for the services identified herein throughout the project’s duration. If circumstances occur that result in delays to the project or changes in scope, any extensions will be reviewed and managed via the Change Control Process.

4. Lakewood must update CIS Infinity V3 production environment to the recommended v3 release prior to project initiation.

5. Direct write access to the Infinity CIS database is not permitted. Any existing interfaces requiring write access to the database, including but not limited to those using stored procedures or database triggers must be modified to leverage REST, SOAP, or AIM-based technologies.

6. Lakewood recognizes that this is a project and not normal daily operations. All team members may not be accustomed to the demands of a project and will have to readily adjust to the needs of meeting deadlines and multi-tasking for this project to be successful.

7. Staffing issues will be resolved between Lakewood and the Advanced Project Managers. Both parties will make every reasonable effort to maintain stable project staffing for the life of the project and minimize disruption to the project.

8. Lakewood will strive to make a reasonable effort to minimize the impact of competing initiatives within the organization that may have a negative impact on the project. If this cannot occur:
a. Lakewood will define an escalation path that defines who can resolve resource allocation conflicts, determine the priority of the conflicting work, and communicate with the affected parties, including the Project Managers of both projects.
b. Advanced will make commercially reasonable efforts to work around any conflicting priorities. Depending on the length of time the resource is not available and task the conflict occurs on, this could result in a delay in the project schedule. If these delays result in extended project timelines, a Change Order will be issued to outline the impacts on schedule and cost.
c. Impacts and/or changes to project resources by either party are the responsibility of that same party to replace and provide knowledge transfer that will mitigate the risk of the resource loss.

9. Prompt decision-making and problem resolution will be required to achieve an on-time, on-budget project completion. It is expected most decisions and/or problems will be resolved within five (5) business days (or to a mutually agreed to timeframe). Reasonable efforts will be made to meet the requirements.

10. Lakewood will empower Lakewood's project team members to make decisions related to configuration and business processes. For some key decisions Lakewood team may be required to elevate the decision process to the executive team. Lakewood will work to minimize the escalation of

Page 12 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
decisions to keep the decision process as streamlined and timely as possible.

11. Lakewood and Advanced will ensure their respective Project Team members are available for meetings, workshops, discussions and conference calls upon request by either organization with reasonable notice. All Project Team members will respond to information requests by either organization within five (5) Business Days unless otherwise agreed to, to minimize delays in the project.

12. Both parties agree to work a reasonable number of additional hours (when required) to help complete project deliverables and project timelines as agreed upon by both Project Managers.

13. All Lakewood and Advanced Project Team members are expected to take normal vacation and holiday days throughout the course of the project except during stages of the project where their presence is critical.

14. Lakewood is willing to consider and implement, when mutually acceptable, Advanced “Best Practices” to minimize the need for software modifications to the extent these practices meet the CIS Solution Requirements.

15. Advanced will recommend configurations and processes based on its industry experience and knowledge of the Advanced solution. Lakewood is willing to consider and implement, when mutually acceptable, Advanced’ “Best Practices” to minimize the need for software modifications to the extent these practices meet the CIS Solution Requirements. This may not always be possible, but Lakewood will approach each opportunity from this perspective. In the event that Lakewood rejects any of Advanced Best Practices recommendations, Lakewood will be required to sign an acknowledgement of such decision. This document will describe Advanced’s concerns about Lakewood’s requested functionality, and Lakewood’s acceptance that a subsequent reversal or modification of such functionality shall be considered an increase in project scope at the agreed upon hourly rate. Furthermore, this document shall describe any impact to Advanced’s ability to provide ongoing support, including any impacts to the annual software subscription fee.

16. When onsite Advanced agrees to work within Lakewood standard business hours whenever possible with the understanding that travel days may impact onsite days. Additionally, it is important to note that there may be times in the project where key staff may be required to work extra hours or hours outside of the standard business hours. For example, cutover is typically done over the weekend.

17. Advanced will provide standard test cases based on standard product functionality. Lakewood is responsible for creating and executing any additional or custom test cases (as required).

18. Lakewood and Advanced will each assign a Project Manager to lead and guide their respective teams throughout this engagement.

19. Lakewood and Advanced will each secure the appropriate staff from their teams in a timely fashion in order to discuss or review the various materials produced when required.

20. Lakewood and Advanced agree to facilitate any required corporate logistics for the fulfillment of this agreement.

21. Lakewood and Advanced will provide access and support from their respective IT Groups and any other stakeholders, as deemed necessary by Customer and Advanced throughout this engagement.

22. Lakewood will provide the appropriate remote access to its network, facilities and systems, as may be required to perform activities from one of Advanced’s locations. Advanced shall abide by all rules and directions of Lakewood when accessing networks,

Page 13 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
facilities, or systems. Please note that multiple concurrent Advanced users must be allowed timely access to relevant client servers.

23. Advanced will work with Lakewood and all third-party vendors referenced in Task 2, Subtask 2.1 to ensure a successful project.

However, Lakewood will secure, as required and in a timely fashion, the assistance and cooperation of third-party vendors to ensure a successful project. A change order may be created if the third-party vendor is unavailable or non-cooperative and, as such, results in an impact to the schedule or effort.

24. Any and all SLA credits are specific to the products and services for which fail to meet standards outlined in the SLA and apply to no other products or services.

Page 14 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
Task 1 – Project Management
Project management occurs throughout the project. Advanced will have primary responsibility for the successful completion of this project as defined in the Scope of Work, including the management of all Advanced resources and tasks. Advanced will be responsible for conducting project-related administrative activities including the development and updates, as required, to the project schedule. The Advanced Project Manager (PM) will provide oversight and guidance to Advanced staff to ensure the successful completion of Advanced-led/assigned activities and related project tasks. Similarly, the Lakewood Project Manager (“PM”) will provide oversight and guidance to Lakewood staff to ensure the successful completion of Lakewood led/assigned activities and related project tasks.

Subtask 1.1 – Project Planning
Advanced and Lakewood will partner together for successful project execution.

Project Initiation will involve all members of the Advanced and Lakewood project team. Prior to the remote Project Kickoff meeting, Advanced and Lakewood will assemble their respective teams who will review this SOW in preparation of the Project Kickoff meeting. It is also highly recommended that the Lakewood review the Infinity CIS V5 upgrade documentation prior to the Project Kickoff meeting.

The Project Schedule for Lakewood identifies the activities, deliverables and resources required for the successful upgrade of Infinity CIS V5. The Advanced PM and the Lakewood PM will review the Project Schedule and internal project dates that may affect project milestones (for example, third-party delivery dates). Lakewood is responsible for managing the timelines and deliverables of any third-party vendor, to ensure they meet the requirements of the approved Project Schedule. The Advanced PM and the Lakewood PM will finalize the project schedule within 2 weeks of the Project Kickoff meeting.

Any changes to the project timeline during the project are to be communicated and reviewed by the Project Sponsors of Lakewood and at Advanced. Changes affecting the overall scope of the project or project schedule may necessitate the use of a Scope of Work Amendment process. (See Change Control).

Subtask 1.2 - Change Control Process
Advanced will coordinate a joint effort with Lakewood to document a Change Control process to manage project scope. The Change Control process will identify how changes are initiated and their impact on the project will be identified, documented and communicated to Lakewood. Appropriate sign-off channels will be developed for Change Order approval.

Subtask 1.3 – Status Reports
Status reporting provides a mechanism for monitoring and controlling the project progress.

Advanced will use various methods to communicate regularly with Lakewood including status reports and status meetings. Additional project

Page 15 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
communications will be performed via E-mail and telephone on an as needed basis.

Advanced Project Manager will attend status meetings with Lakewood Project Manager either in person or via telephone conference call to focus on project status/progress, issues which could impact project schedule, technical or operational issues affecting the project and risk assessment. These meetings shall occur on a weekly basis.

Advanced will provide a weekly status report documenting work in progress compared to schedule, issues, actions, risks and budget. Advanced will also provide a monthly summary of project progress, including significant risks and issues resolved and significant risks and issues raised.

Subtask 1.3 – Deliverables
Subtask 1.3
Deliverables
 Weekly Status Meeting and Report
 Monthly Project Progress Summary
Subtask 1.4 – Quarterly Sponsor Review
Advanced will prepare a Quarterly Sponsor Review to be attended by project management and project sponsor staff from both Lakewood and Advanced. The quarterly sponsor review meeting will review progress to date, future actions, and will validate, on a quarterly basis, that the Go Live date is still achievable for both parties. The dates for these meeting will be determined jointly by the Lakewood and the Advanced PM.

Subtask 1.4 – Deliverables
Subtask 1.5
Deliverables  Quarterly Sponsor Review

Page 16 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
Task 2 – Infinity CIS v5 Interfaces
This section delineates the integration of Advanced CIS Infinity V5 within the project's scope. It specifies the interfacing of Infinity CIS V5 with Lakewood's existing systems. Should these integrations necessitate development work on the interfaced systems, any related vendor costs will be borne by Lakewood and are outside this project's scope.

Advanced is responsible for documenting the progress of all development activities, irrespective of whether they are performed by Lakewood or by Advanced, in the weekly status reports.

Interfaces from Infinity CIS V3 will be migrated to the Infinity Cloud Platform version of Infinity CIS V5 unchanged, employing the same methods as previously used, assuming there are no direct database connections.

Subtask 2.1 – Infinity CIS V3 Interfaces
Subtask 2.1.1 – Neptune Meter Reading Interface
Infinity CIS V5 will support a two-way batch file interface between CIS and Neptune meter reading software.

The interface will support the export of account and meter details from CIS to Neptune, as well as the import from Neptune to CIS Infinity of the meter data reads used for billing purposes.

The interface will use the export and import file layouts configured in CIS V3.

Action Responsible
Party
Configure the meter reading export as per CIS V3 layout. AUS Configure the meter reading import as per CIS V3 layout. AUS Provide instruction on how to run the import and export processes in CIS V5
AUS
Test the meter reading export and import processes in CIS V5 Lakewood Subtask 2.1.2 – Infosend Bill Print Interface
Infinity CIS V5 will support a one-way batch interface to export bill details from CIS to the bill print provider, Infosend, that will generate and mail out customer bills.

The layout of the bill print file (EBP) will be configured as per CIS V3.

Action Responsible
Party

Page 17 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
Configure the EBP file as per CIS V3 AUS
Provide instruction on how to generate the EBP file in CIS V5
AUS
Test the EBP file with the third-party bill print
provider.

Lakewood
Subtask 2.1.3 – Meter Change Import Interface
Infinity CIS V5 will support a one-way batch file interface to import in CIS meter changes provided by a third-party solution.

The layout of the meter change file will be configured as per CIS V3.

Action Responsible
Party
Configure the meter change as per CIS V3 layout. AUS
Provide instruction on how to run the meter change import process in CIS V5
AUS
Test the meter change import process in CIS V5 Lakewood Subtask 2.1.4 – OCR Payment Import Interface
Infinity CIS V5 will support a one-way batch file interface to import utility customer payments coming from a configurable file.

The import file will be configured in CIS V5 using the layout associated with the CIS V3 ‘OCR Import’ process.

Action Responsible
Party
Configure the OCR File Import interface as per CIS V3 ‘OCR Import’ process.

AUS
Provide instruction on how to run the OCR File Import
process in CIS V5
AUS
Test the OCR File Import process in CIS V5 Lakewood
Subtask 2.1.5 – Balance Adjustment Import Interface
Infinity CIS V5 will support a one-way batch file interface to import customer balance adjustments from a configurable file.

The import file will be configured in CIS V5 using the layout associated with the CIS V3 ‘OCR CIS3 Import’ process.

Page 18 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
Action Responsible
Party
Configure the Balance Adjustment Import interface as per CIS V3 ‘OCR CIS3 Import’.

AUS
Provide instruction on how to run the Balance Adjustment Import process in CIS V5
AUS
Test the Balance Adjustment Import process in CIS V5 Lakewood

Subtask 2.1.6 – Notices Interface
Infinity CIS V5 will support a one-way batch interface to export delinquent customer details from CIS to the notice print provider, Infosend, that will generate and mail out door hanger notices.

The layout of the door hanger notices file will be configured as per CIS V3.

Action Responsible
Party
Configure the door hanger notices file as per CIS V3 AUS Provide instruction on how to generate the door hanger
notices file in CIS V5
AUS
Test the door hanger notices file with the third-party
notice print provider.

Lakewood
Subtask 2.1.7 – Collection Agency Interface
Infinity CIS V5 will support a one-way batch interface between CIS and Lakewood’s collection agency.

The interface will export a file containing delinquent customer information from CIS, to be used by the collection agency.

The layout of the collection agency export file will be configured as per CIS V3.

Action Responsible
Party
Configure the collection agency export interface as per CIS V3.

AUS
Provide instruction on how to run the collection agency file export process in CIS V5
AUS
Test the collection agency file export process in CIS V5 Lakewood

Page 19 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
Subtask 2.2 – Additional Interfaces & Modifications
For new interfaces added to scope, that are not currently in Infinity CIS V3, Advanced will create a Business Requirements Document (BRD) for each interface requiring development effort from Advanced (not applicable to existing Lakewood interfaces).

Subtask 2.2.1 – Paymentus Autopay Enrolment Import
Infinity CIS V5 will support a one-way batch file interface between CIS Infinity and Paymentus to import online customer autopay(ACH) enrolment from Paymentus to CIS.

Action Responsible
Party
Provide the Autopay Enrolment file layout Lakewood
Complete the Autopay Enrolment file data mapping AUS, Lakewood Provide Autopay Enrolment Import BRD AUS
Approve the Autopay Enrolment Import BRD Lakewood
Configure the Autopay Enrolment Import. AUS
Provide instruction on how to run the Autopay Enrolment Import
AUS
Test the Autopay Enrolment Import process in CIS V5 Lakewood In the event that any additional modifications, interfaces, integrations not listed above are identified during the project implementation, the jointly developed Change Order process as defined in Subtask 1.2 will be followed.

Subtask 2.3 – Reports
As a part of Lakewood’s code and system audit, completed as a separate engagement, Advanced has identified 432 custom reports within Lakewood’s V3 system. Out of the 432 reports identified, 20 reports have been custom developed by Advanced, and 8 have been identified as no longer required by Lakewood. Included within the scope of this SOW, Advanced will convert 12 reports to CIS Infinity V5. Please refer to “Appendix 2 – Reports” for a complete list of the reports that will be converted as part of this engagement.

Should Lakewood require additional custom reports or modifications to current reports, requests will be managed through the Change Control process, as detailed in Subtask 1.2.

Task 3 - Implementation Approach
This task covers the implementation approach Advanced will take to upgrade and reimplement Lakewood’s CIS Solution. Advanced will implement a phased approach as described herein.

Page 20 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
Subtask 3.1 – Phase 1 – Project Initiation
The Advanced PM will work with the Lakewood Project Manager and staff to organize project information for the preparation of the Project Schedule (see Task1). The Advanced PM will organize and present all the information required to start the project and will, at a minimum, address the following areas:
 Project Schedule,
 Software Provisioning on in the Advanced Infinity CIS Cloud Platform  Core Team and End User Training Course Syllabus’,
 Issues Tracking Tool set-up and overview,
 Access to CIS Infinity Entity Relationship Diagram and Data Dictionary,  Project Team Contact List which includes users that need access to the Issues Tracking Tool,
 Overview of the operations of Infinity CIS V5 via online conference,  Solution Overview Session agendas delivery and review.

The Advanced PM will oversee the daily activities of the project and work in conjunction with the Lakewood’s Project Manager and staff to ensure effective management of staff resourcing, forward planning initiatives and day to day project deliveries.

Subtask 3.1 – Deliverables
Subtask 3.1
Deliverables
 Project Kickoff Meeting
 Initial Project Schedule
 Training Course Agenda
 Issues Tracking Tool Overview
 Project Team Contact List
Subtask 3.1 – Entry Criteria
Criteria Responsible Party
 Contracts signed Advanced and
Lakewood
 Transition discussion from Sales to
Professional Services
Advanced and
Lakewood
 Project Team identified Advanced and
Lakewood
Subtask 3.1 – Exit Criteria
Criteria Responsible Party
 Infinity Cloud base environment provisioned and
signed off
Advanced
 3.1 Deliverables completed Advanced

Page 21 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
Subtask 3.2 – Phase 2 – Solution Overview
Advanced will review the Lakewood's Infinity CIS V3 configuration to provide an association between Lakewood’s business practices and the required Infinity CIS v5 configuration.

The Solution Overview will be led by Advanced and will be the basis for how Advanced will configure and convert the items within the scope of the project.

Subtask 3.2.1 – Solution Overview Workshop
Advanced will conduct the Solution Overview to appropriately review and confirm all required information for the areas listed below. Advanced and Lakewood will identify the necessary Lakewood staff needed to attend these workshops two to four weeks in advance.

The Solution Overview will include:

1. Foundation: Review of the Infinity CIS V3 basic system setup areas and logical business rules including but not limited to account types, services, and customer/account information.

2. Billing: Review of the Infinity CIS V3 meter reading to billing process with a review of all processing and exceptions reporting.

3. Rates: Review of the rate tariff, formulas, proration, and multipliers configured in Infinity CIS V3.

4. Cashiering: Review of all payment types, interfaces, automated clearing house, endorsements, receipts, miscellaneous and unapplied payments processing configured in Infinity CIS V3.

5. Collections: Review of all Infinity CIS V3 collections procedures, payment arrangements, exemptions, penalties, notices, disconnections, agency, add to tax/liens, tax certification, bankruptcy, and write-off processes including all applicable fees.

6. Infinity Cloud Platform Endpoint Connectivity
Network connectivity between Lakewood’s on-premise systems and the Infinity Cloud Platform requires Lakewood on Microsoft ExpressRoute, or an IPSEC VNET-to-VNET VPN tunnel. Here Advanced captures and reviews the networking details to permit connectivity between those client premise systems and the Infinity Cloud Platform.

Subtask 3.2.1 – Deliverables
Subtask 3.2.1
Deliverables
 Solution Overview Workshop
 Solution Overview Document

Page 22 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
Subtask 3.2.1 – Entry Criteria
Criteria Responsible Party
 Solution Overview Workshop Agenda delivered. Advanced Subtask 3.2.1 – Exit Criteria
Criteria Responsible Party
 Lakewood Core Team and/or SME’s attendance at
Solution Overview Workshop.

Lakewood
 Solution Overview Workshops conducted. Advanced
 Solution Overview Document delivered. Advanced
 Review and edits/Sign Off of Solution Overview
Document 10 days from receipt of each
iterative version.

Lakewood
Subtask 3.3 – Phase 3 – Interface Discovery
Advanced will conduct an Interface Discovery Analysis Workshop for interfaces listed in Task 2 - Subtask 2.2 Advanced will provide a Discovery Agenda for these sessions.

Lakewood will identify necessary Lakewood staff needed to attend this workshop two weeks in advance. Advanced will review with Lakewood all interfaces identified in Task 2 – Subtask 2.2, to be implemented in Infinity CIS V5.

Advanced will create a detailed Business Requirements Document (BRD) and a Use Case Document for each interface and modification listed in Task 2 – Subtask 2.2 for review and acceptance by Lakewood.

Advanced will review the documentation with Lakewood remotely and update as required.

Subtask 3.3 – Deliverables
Subtask 3.3
Deliverables
 Interface Discovery Agenda
 Interface Discovery Workshop.

Subtask 3.3 – Entry Criteria
Criteria Responsible Party
 Interface Discovery Agenda delivered. Advanced
 Interface file layout(s) and sample files
provided for each interface.

Lakewood
 3rd Party Vendor participation secured (if
applicable).

Lakewood

Page 23 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
 Staff SME participation secured. Lakewood
Subtask 3.3 – Exit Criteria
Criteria Responsible Party
 Interface Discovery Workshop complete. Advanced
 SME attendance and 3rd Party Vendor (if
applicable) attendance at Interface Discovery
Workshop.

Lakewood
 Business Requirements Document(s) delivered. Advanced  Review and Sign Off of Business Requirements
Documents within ten (10) days from receipt of
each iterative version.

Lakewood
Subtask 3.4 – Phase 4 – Other Discoveries
The following Discovery Workshops will be completed as part of this project:

Subtask 3.4.4 – Accelerated Innovations (AI) MyMeter Customer Self-Serve portal (CSS) Discovery
Accelerated Innovation (AI) is a subcontractor of Advanced and their terms and conditions can be found at Appendix 2. Advanced and AI will conduct a CSS Discovery Workshop. This workshop will be led by Advanced and AI and will review Lakewood's customer portal configuration requirements including a detailed review of Lakewood's business rules and technical environment.

Prior to the start of the workshop, Lakewood will complete the CSS Checklist provided by Advanced.

Advanced will deliver a CSS Discovery Document that will include the Technical Checklist..

Subtask 3.4.4 – Deliverables
Subtask 3.4.4
Deliverables
 CSS Discovery Workshop
 CSS Technical Checklist
 CSS Discovery Document
Subtask 3.4.4 – Entry Criteria
Criteria Responsible Party
 CSS Technical Checklist delivered Advanced
 CSS Technical Checklist complete and returned
2 weeks prior to Discovery Workshop
Lakewood
 CSS Discovery Agenda delivered Advanced

Page 24 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
Subtask 3.4.4 – Exit Criteria
Criteria Responsible Party
 Infinity CEP Discovery Workshop conducted Advanced
 SME attendance at Discovery Workshop Lakewood
 Infinity CEP Discovery Document delivered Advanced
 Infinity CEP Discovery Document reviewed and
signed off 10 days from receipt
Lakewood
Subtask 3.4.5 – ServiceLink Mobile Workforce Management (MWM) Discovery Advanced and ServiceLink will conduct a MWM Discovery Workshop. This workshop will be led by Advanced or a partner and will review Lakewood's mobile service order requirements including a detailed review of Lakewood’s business rules and technical environment.

Prior to the start of the MWM workshop, Lakewood will complete the Infinity MWM Checklist provided by Advanced. Advanced will deliver an MWM Discovery Document that will include the Technical Checklist.

Subtask 3.4.5 – Deliverables
Subtask 3.4.5
Deliverables
 MWM Discovery Workshop
 MWM Checklist
 MWM Discovery Document
Subtask 3.4.5 – Entry Criteria
Criteria Responsible Party
 MWM Checklist delivered Advanced
 MWM Checklist complete and returned 2 weeks
prior to Discovery Workshop
Lakewood
 MWM Discovery Agenda delivered Advanced
Subtask 3.4.5 – Exit Criteria
Criteria Responsible Party
 MWM Discovery Workshop conducted Advanced
 SME attendance at Discovery Workshop Lakewood
 MWM Discovery Document delivered Advanced
 MWM Discovery Document reviewed and signed off
within ten (10) days from receipt
Lakewood
Subtask 3.4.6 – SmartVX (Welcome Videos)
SmartVX is a Harris platform for generating personalized video from templates with customer-specific content. It provides tailor-made experience to customers viewing the video.

Page 25 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
By integrating with SmartVX, Infinity CIS can provide the ability to generate videos for billing and onboarding. These videos can be embedded in different forms of communication, such as emails, ebills and letters, that you send to your customers. They can also be embedded on your customer facing web portal to enhance your customers’ experience.

Subtask 3.4.6
Deliverables
 SmartVX Discovery Workshop for Welcome Videos
 SmartVX Technical Checklist.
 SmartVX Discovery Document.

Subtask 3.4.6 – Entry Criteria
Action Responsible Party
SmartVX Technical Checklist delivered. Advanced (with help from SmartVX)
Discover SmartVX features that client will use
(e.g. Billing Video, Welcome Video)
Advanced (with help from
SmartVX)
Provide logo, contacts, links to be embedded in the
videos
Client
Create video templates and configure SmartVX
dashboard
Advanced
Configure Infinity CIS to integrate with SmartVX Advanced Training on embedding SmartVX video in customer
emails, letters, etc.

Advanced
Subtask 3.4.6 – Exit Criteria
Action Responsible Party
SmartVX Discovery Workshop conducted. Advanced (with help from SmartVX)
Discover SmartVX features that client will use
(e.g. Billing Video, Welcome Video)
Advanced (with help from
SmartVX)
Provide logo, contacts, links to be embedded in the
videos
Client
Create video templates and configure SmartVX
dashboard
Advanced
Configure Infinity CIS to integrate with SmartVX Advanced Training on embedding SmartVX video in customer
emails, letters, etc.

Advanced
Subtask 3.5 – Phase 5 – Data Integrity Check/Clean-Up & Initial Data Conversion/Configuration
The following activities related to data integrity validation, clean-up, data conversion, and configuration will be completed as part of this project:

Page 26 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
Subtask 3.5 - Version 3 Data Integrity Check and Clean-up Prior to the Infinity CIS V5 upgrade conversion, the V3 Integrity Check will be run by Advanced in coordination with Lakewood within the V3 Upgrade Environment. The V3 Upgrade Environment must be refreshed from production by Lakewood prior to running the V3 Integrity Check. The V3 Integrity Check will report on data integrity issues within the V3 database, which, if not resolved, will prevent the successful upgrading of the V3 database to the Infinity CIS V5 database.

The V3 Data Integrity Check will find and report on data integrity issues, such as missing links (orphaned records), code lookups and unpopulated required fields, Advanced staff will analyze issues reported by the Integrity Check and prepare SQL scripts as required to resolve data issues and to review with the Lakewood team via a Data Discovery session. Data fixes will be applied by Advanced in the upgrade environment. Lakewood will review data fixes and once approved, Lakewood will run scripts and make data changes in V3 Production Environment.

Subtask 3.5 – Deliverables
Subtask

3.5Deliverables
 Run V3 Integrity Check on CIS Infinity V3 upgrade
environment (Refreshed),
 Identify, resolve and update data changes into CIS
Infinity V3 upgrade Environment prior to the initial
conversion of the V3 database to Infinity CIS V5,
 Initial software configurations,
 Develop and run V3 data clean up scripts in the V3
upgrade environment prior to the initial conversion of
the V3 database to Infinity CIS V5,
 Refresh V3 upgrade environment from V3 Production
environment.

Subtask 3.5 – Entry Criteria
Criteria Responsible Party
 New data cut that includes 100% of the agreed
upon data from CIS V3 and provided no later
than two (2) weeks prior to Initial Rollout.

Lakewood
 Data Validation parameters finalized. Advanced and
Lakewood
 Functional Discovery Document signed off per
timelines outlined in project schedule and no
later than two (2) months prior to scheduled
rollout.

Lakewood
 Baseline Accounts established, documented and
provided to Advanced.

Lakewood

Page 27 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
Subtask 3.5 – Exit Criteria
Criteria Responsible Party
 Initial Configuration complete to include no
less than 70% of the total configuration
requirements outlined in the Functional
Discovery Document, excluding all configurable
interfaces.

Advanced
 Data Validation reviewed jointly and anomalies
under investigation by both parties.

Advanced and
Lakewood
 All generic testing documents delivered
including conversion and end-to-end testing.

Advanced
 Review of Issues Tracking Tool. Advanced
 Commencement of conversion testing against
Baseline Accounts.

Lakewood
Subtask 3.6 - Infinity CIS v5 Initial Upgrade Conversion, Data Validation and Testing
Once the V5 data integrity and cleanup process is complete Advanced will convert Lakewood’s V3 data and load into Lakewood’s Infinity CIS V5 environment.

Advanced will supply a data validation report confirming both Version 3 and Infinity CIS v5 systems are in balance and will release the system for testing by Lakewood.

The initial Infinity CIS v5 Upgrade Conversion will average one to two days.

The length of time necessary for conversion is dependent on several key factors including the size of the current database and number of years of data being converted.

NOTE: The upgrade conversion routine does not automate the upgrade of interfaces, Lakewood security settings, hyperlinks, saved reporting criteria, information bars, billing formulas, bill prints, notices & receipts and custom reports. Advanced and Lakewood will need to configure these manually as identified below.

Advanced is responsible for converting/configuring the following:
 All billing formulas required by Lakewood in Infinity CIS V5,  Current receipts,
 Bill Print(s) Notices,
 Endorser,
 Reports identified in “Appendix 2 – Reports”,
 Generic Information Bars,

Page 28 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
 Interfaces (Delivered at Integration Testing).

Lakewood is responsible for converting/configuring the following:
 User security,
 Hyperlinks,
 Configuration of security is required for the Integration Testing phase.

Prior to the completion of the Initial Upgrade Conversion Lakewood will select a group of Baseline Accounts. Baseline Accounts provide Lakewood’s staff with a point of reference when completing testing. The Baseline Accounts represent a cross-section of account types and include accounts handled differently than “normal” accounts. For example, a sample of an account for each rate code, an account with automatic withdrawal, accounts with multiple meters, and account with compound meters are all examples of accounts that should be included in Lakewood’s Baseline Accounts, as applicable.

As part of the Initial Upgrade Conversion, Lakewood will undertake testing of the Infinity CIS V5 Upgrade conversion. Lakewood’s project manager will coordinate the completion of the Infinity CIS V5 Upgrade conversion testing and submit any issues identified in Team Support. This testing will provide Advanced with information relating to upgrade conversion anomalies to be corrected. Re-testing of identified conversion issues will be necessary.

During Initial Upgrade Conversion testing (and subsequent test phases), Advanced will access Lakewood’s server in order to upload data corrections, with the assistance of Lakewood’s technical staff. The users will re-test anomalies based on initial test results and established Baseline Accounts.

Subtask 3.6
Deliverables
 Advanced Convert CIS Infinity Version 3 database to
Infinity CIS V5 database
 Advanced Deliver Data Validation Report which
validates conversion accuracy between V3 and V5,
 Advanced Review and deliver initial V5 data conversion load with Lakewood,
 Advanced Time the process to convert and load data,
 Advanced Configure generic Information Bars,
 Lakewood Review and approve the Data Validation
Report,
 Lakewood Run reports currently used by Lakewood for
balancing system in V3 and V5 to confirm versions are
in balance,

Page 29 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
 Lakewood Load refreshed Infinity CIS V5 test database onto hosted secure storage (required for
troubleshooting and billing formula conversion),
 Lakewood Identify Baseline Accounts for testing,
 Lakewood Create test scripts and share with Advanced,  Lakewood Run Infinity CIS V5 Data Validation Tool to
compare and validate V3 data.

Page 30 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
Subtask 3.7 – Phase 6 – Customer Training
Advanced will provide 2 weeks of Customer Training conducted remotely via WebEx
The Customer Training sessions will include:
 Core Team Training:
o Training designed to train users on the new user interface (UI) and changes in key functional areas including AccountView, Main Menu, User Task Inquiry, New Services, Moves, Cash, Billing, Collections, Filters/Criteria, Service Orders, Letters, Email Management. Core Team training assumes users are familiar with Version 3 and Lakewood’s business processes and does not include introductory or basic training to users unfamiliar with Version 3 functionality and processes.
 Reports Training,
 Security Training,
 End User Training.

Onsite training is available upon request at additional cost and will be managed according to the Change Order process as defined in Subtask 1.2.

Subtask 3.7 – Deliverables
Subtask 3.6
Deliverables
 Standard Infinity CIS V5 Training Agendas
 Completion of Instructor-Led remote Customer Training Subtask 3.7 – Entry Criteria
Criteria Responsible Party
 Agenda delivered Advanced
 Where applicable, Training
Room/workstations/software/participants
available for training
Lakewood
 Infinity CIS V5 System QA’d and prepared for
Training
Advanced
Subtask 3.7 – Exit Criteria
Criteria Responsible Party
 Instructor-Led remote Training delivered Advanced
 90% Attendance rate from Customer at all
sessions
Lakewood

Page 31 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
Subtask 3.8 – Phase 7 – Reports Development and Delivery Reports in Infinity CIS V3 identified during Reports Discovery will be converted to Infinity CIS V5 system for review and acceptance by Lakewood.

Any custom reports identified in “Appendix 2 – Reports” will be developed and delivered by Advanced by ITC1. Custom reports unidentified in “Appendix 2 – Reports” will be recognized as out of scope and follow the Change Order Process.

Subtask 3.8 – Deliverables
Subtask 3.8
Deliverables  Reports are ready for Lakewood to test
Subtask 3.8 – Entry Criteria
Criteria Responsible Party
 TeamSupport Tickets created for each report
identified in “Appendix 2 – Reports”.

Advanced
Subtask 3.8 – Exit Criteria
Criteria Responsible Party
 Delivery of reports identified in “Appendix 2
– Reports”
Advanced
Subtask 3.9 – Phase 8 – Interface Delivery
Once an interface has been implemented, unit tested and tested internally by Advanced, Lakewood will be notified that the interface is ready to be released and available for testing or Lakewood will be notified that the interface is ready to be released and deployed in Lakewood’s environment through an executable or build.

Subtask 3.9 – Deliverables
Subtask 3.8.1
Deliverables  Interfaces are ready for Lakewood to test Subtask 3.9 – Entry Criteria
Criteria Responsible Party
 TeamSupport Tickets are created for each
interface identified in Subtask 2.

Advanced
 3rd Party Vendor participation in Interface
testing (if applicable).

Lakewood

Page 32 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
Subtask 3.9 – Exit Criteria
Criteria Responsible Party
 Interfaces are configured and ready for testing
in Lakewood’s environment.

Advanced
 Testing of interfaces with 3rd party vendor
participation (if applicable) completed.

Lakewood
Subtask 3.10 – Phase 9 – Software Testing
Advanced will support all software testing through possible combinations of onsite support, remote support and video conferencing online support.

Validated testing criteria will be used to determine if the testing phase is complete and the system is ready for the next cycle of testing. The Advanced PM will provide Lakewood with generic test scripts. Modification of test scripts to match Lakewood’s specific business scenarios is the responsibility of Lakewood. From the test scripts Lakewood will create an ITC Plan (Integration Testing Cycle), and User Acceptance Test (UAT) Plan.

At the start of each test cycle, a full data conversion using a fresh data extract will be performed to exercise the data conversion process and to update any required data fixes that are found through testing. Data Conversion is an iterative process and will require fixes throughout all testing phases based on the outcomes of each testing phase.

With each data conversion Advanced will provide and Lakewood will verify all balancing metrics that were agreed upon in the Data Conversion Discovery.

Deficiencies found during the Software Testing Phase will be entered into the Issues Tracking Tool for the correction of configuration, data conversion and/or system deficiencies. Deficiencies will be entered into the Issues Tracking Tool by Lakewood. The Issues Tracking Tool maintains a history of analysis and problem resolution.

The Issues Tracking Tool will be managed and maintained by the Advanced PM and will be reviewed with both Advanced and Lakewood staff to ensure the issues are being actively worked and tested. The Advanced PM will be proactive in the resolution of items logged in the Issues Tracking Tool so that they will be resolved within a timely manner. The Advanced PM or designate will document to the Lakewood Project Manager (in detail) the issue or defect, the resolution or workaround alternative, if applicable.

Advanced will provide a technical point of contact during all testing phases, Advanced will provide responses that include justification and mitigation plans, where applicable.

Lakewood will provide Advanced with evidence through Test Cases utilizing the Advanced Testing Tool (Smartsheet) and various other methods of testing documentation that testing is being done and progressing through the test phases.

The software testing phase is divided into the following test cycles:

Page 33 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
Subtask 3.10.1 – Functional Testing
Functional testing will utilize the Baseline Accounts to confirm that the data conversion and basic functions in the system are working as expected.

Individual accounts will be reviewed and will run through a meter to cash process.

Functional Testing is modular and does not test the system end-to-end utilizing interfaces.

Subtask 3.10.1 – Functional Testing Deliverables
Subtask

3.10.1 Deliverables
 Functional Test Data Conversion Refresh and Validation Report.

Subtask 3.10.1 – Entry Criteria
Criteria Responsible Party
 Configuration complete in accordance to the
requirements outlined in the Solution Overview
Document and excluding all interfaces and
modifications.

Advanced
 Data Refresh timelines recorded for the data
cut, conversion and load.

Advanced and Lakewood
 Customized Testing Documents designed, and
functional test cases created in Advanced
Testing Tool.

Lakewood
 Executed Contract with Payment Processor. Lakewood
Subtask 3.10.1 – Exit Criteria
Criteria Responsible Party
 Testing of all applicable functional modules
using customized test documents and test cases,
reporting any anomalies in Issues Tracking
Tool.

Lakewood
 Retesting of fixed conversion items, testing of
conversion additions and report anomalies in
Issues Tracking Tool.

Lakewood
 Functional Data Validation jointly reviewed and
anomalies under investigation by both parties.

Advanced and
Lakewood
 Rates Testing Completion and anomalies reported
in Issues Tracking Tool.

Lakewood
 Successful resolution of 70% of critical
configuration type tickets reported no less
than 15 days from scheduled ITC Refresh start
date.

Advanced
 Backup and Restore Site Failover Testing. Advanced

Page 34 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
 Connectivity validated between CIS platform
test instance and dependent systems.

Advanced
Subtask 3.10.2 - Integration Testing Cycle (ITC)
ITC will utilize test scripts/cases customized by Lakewood to confirm that the data conversion and business processes are functioning as expected.

ITC is intended to exercise full scale testing of the system incorporating the testing of interfaces and modifications scheduled for ITC. It includes testing of all end-to-end processes and all Lakewood Owned Control Forms (including but not limited to service orders, actions, filter/criteria, letter generation, security admin).

Subtask 3.10.2 – Integration Testing Deliverables
Subtask

3.10.2 Deliverables
 ITC Data Conversion Refresh and Validation Report
 ITC Build Release for Interfaces/Integrations and
Modifications
Subtask 3.10.2 – Entry Criteria ITC
Criteria Responsible Party
 Completion of testing of all applicable
functional modules using customized test
documents and test cases and anomalies
reported in Issues Tracking Tool.

Lakewood
 Customized Testing Documents designed, and ITC
test cases created in Advanced Testing Tool.

Lakewood
 Successful retesting of fixed conversion items
and testing of remaining conversion additions.

Anomalies reported in Issues Tracking Tool.

Lakewood
 ITC Data Validation reviewed jointly and
anomalies under investigation by both parties.

Advanced and Lakewood
 Rates Testing Completed and any anomalies
reported in Issues Tracking Tool.

Lakewood
 Successful resolution of 70% of critical path
configuration type tickets reported no less
than ten (10) days from ITC Refresh start
date.

Advanced
 Interfaces completed. Advanced
 Lakewood Owned Control Forms 60% completed
which must include Service Order Types.

Lakewood
 CSS configuration/GUI commencement. Advanced
 MWM configuration. Advanced

Page 35 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
 Lakewood AUS Preferred Payment Processor set
up complete and ready for integration testing
with Infinity CIS V5 and CSS.

Advanced
Subtask 3.10.2 – Exit Criteria ITC
Criteria Responsible Party
 Technical and training daily support for
initial week of ITC Testing.

Advanced
 Build Release(s) (if applicable) applied for
Interfaces.

Advanced
 Testing of interfaces with 3rd party vendor
participation (if applicable) and anomalies
reported in Issues Tracking Tool.

Lakewood
 Successful resolution of 80% of critical path
configuration type tickets reported no less
than ten (10) days from scheduled UAT Refresh
start date.

Advanced
 Successful resolution of 80% of conversion type
tickets reported no less than 10 days from
scheduled UAT Refresh start date.

Advanced
 Reports Testing Complete and anomalies reported
in Issues Tracking Tool.

Lakewood
 Bill Print testing, Cycle Bills, Final Bills,
Manual Bill and Prorated bills.

Lakewood
 Cycle Billing Testing Complete and anomalies
reported in Issues Tracking Tool.

Lakewood
 Lakewood Owned Control Forms 80% complete. Lakewood
 CSS configuration/GUI completed and ready for
UAT.

Advanced
 CSS Testing completed and any anomalies
reported in Issues Tracking Tool.

Lakewood
 MWM testing and anomalies reported in Issues
Tracking Tool.

Lakewood
 MWM configuration/GUI completed and ready for
UAT.

Advanced
 AUS Preferred Payment Processor configuration
completed and ready for UAT.

Advanced
Subtask 3.10.3 - User Acceptance Testing (UAT)
The final phase of testing is UAT and starts with a code freeze. Only critical path items will be altered during this phase as agreed upon by both parties after analyzing the risk of introducing these changes. Once complete, the UAT constitutes acceptance of the system as ready for Go Live. In combination with staff training readiness and organization readiness, the UAT

Page 36 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
and its acceptance help to drive the Go/No Go criteria that lock down the live date of the software.

Advanced will coordinate with Lakewood to select the integration test scripts that will be used during UAT.

The Advanced PM will work with Lakewood to ensure that test results for each testing phase provide evidence that Infinity CIS V5 capabilities have been properly integrated and tested in Lakewood’s test environment. Advanced will work with Lakewood to support performance tests.

Subtask 3.10.3 – User Acceptance Testing Deliverables
Subtask

3.10.3 Deliverables
 UAT Data Conversion Refresh and Validation Report
 UAT Acceptance Criteria
Subtask 3.10.3 – Entry Criteria
Criteria Responsible Party
 UAT Data Validation reviewed jointly and
anomalies under investigation by both parties.

Advanced and Lakewood
 Retested interfaces and modifications with 3rd
party vendor participation (if applicable) and
anomalies reported in Issues Tracking Tool.

Lakewood
 Successful resolution of 90% of critical path
configuration type tickets reported no less
than ten (10) days from scheduled UAT Refresh
start date.

Advanced
 Successful resolution of 90% of conversion
type tickets reported no less than ten (10)
days from scheduled UAT Refresh start date.

Advanced
 Reports Testing completed. Lakewood
 Bill Print Testing completed with 3rd party
vendor participation (if applicable).
 System Code Freeze. Advanced
 Final review of Lakewood Owned Control Forms. Lakewood  CSS Issues reported not less than ten (10)
days from scheduled UAT Refresh fixed.

Advanced/Lakewood
 MWM Issues reported not less than ten (10)
days from scheduled UAT Refresh fixed.

Advanced/Lakewood
Subtask 3.10.3 – Exit Criteria
Criteria Responsible Party
 Successful testing of all end-to-end processes. Lakewood

Page 37 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
 Successful resolution of all critical path
conversion and configuration type tickets.

Advanced
 Successful completion of all Lakewood Owned
Control Forms.

Lakewood
 Regression and stress test executed
successfully.

Lakewood
 Successful testing of Payment Processor. Lakewood
 Successful testing of CSS. Lakewood
 Successful testing of MWM. Lakewood
Subtask 3.11 – Phase 10 – End User Training
Advanced will provide 1 week of Infinity CIS V5 End User training to Lakewood to secure a working knowledge of Infinity CIS V5. As part of the Training Plan, Advanced will work with Lakewood to jointly create the appropriate Training Matrices (part of the Training Plan) that will identify classes and the Advanced and Lakewood staff attendance needs. End User training assumes users are familiar with V3 and Lakewood’s business processes and does not include introductory or basic training to users unfamiliar with V3 functionality and processes.

End User Training will be conducted by a combination of instructor led sessions in accordance with the Training Matrix and with Lakewood availability to answer participant questions pertaining to Lakewood business practices.

Each End User training session will have an attendance sheet that matches the End User training schedule. Once each session is complete, Lakewood will sign-off on a Training Session Sign-off Form signifying that the training session has been completed.

Subtask 3.11 – Deliverables
Subtask 3.10
Deliverables
 Completion of Instructor Led End User Training,
 Training Session Attendance Report,
 Training Session Signoff form.

Subtask 3.11 – Entry Criteria
Criteria Responsible Party
 End User Training Plan Matrix delivered. Advanced
 End User Training Plan Matrix completed. Lakewood
 End User Training Schedule created. Advanced and
Lakewood

Page 38 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
Subtask 3.11 – Exit Criteria
Criteria Responsible Party
 All End User Training sessions required for GoLive complete.

Advanced
 End Users absent or requiring additional
assistance/training from End User Training
identified.

Advanced
 Additional training plan developed and provided
to End Users identified as requiring additional
assistance/training complete for Go-Live.

Lakewood
Subtask 3.12 – Phase 11 – Provision and Technical Validation of Production Instance
During this phase Advanced will provision and validate the technical features of Infinity Cloud Platform. Advanced will lead and work with the client to conduct a regional failover test, and a backup and restore test. Network connectivity between the Infinity CIS production instance, on-premise, and/or 3rd Party services will also be validated in this phase.

1.Failover Testing
Advanced will simulate a system failover to a different region of the cloud infrastructure. Advanced will be responsible for a smoke test of the site during failover and failback. To ensure proper testing of such failover, the following steps will be executed:

1. Advanced to simulate a server outage

2. Lakewood to accept system is accessible and functional after failover

3. Lakewood to ensure system is functional after failback Failover testing will happen after Functional Testing and requires six (6) hours of effort. This effort is included within the scope of this project and corresponding pricing. Additional effort will be subject to a change order.

2.Restoration Testing
Advanced will simulate a system data recovery from backup to cloud infrastructure. Advanced will be responsible for a smoke test of the site during restoration. To ensure proper testing, the following steps will be executed:

1. Advanced to simulate a data restore using the point-in-time restore backup

2. Lakewood to ensure system is functional after restoration Restoration testing will happen after Functional Testing and requires six (6) hours of effort. . This effort is included within the scope of this project and corresponding pricing. Additional effort will be subject to a change order.

Page 39 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
Subtask 3.13 – Phase 12 – Cut-Over Plan/Go/No Go Criteria Lakewood will assist Advanced in the construction of Go/No-Go criteria. These criteria shall be used to determine whether or not to proceed to “Phase 12 - Transition to Live”. Criteria shall be measured on a weekly basis starting no later than the commencement of User Acceptance Testing. When all criteria are met, Lakewood shall issue formal authorization to proceed with the Cut-Over Plan to production.

The Advanced PM will develop a Cut-Over Plan throughout the lifecycle of the project in preparation for a final transition to live. This plan details the steps and responsibilities for Advanced and Lakewood to transition Infinity CIS to Lakewood’s production (live) environment. The Cut-Over Plan will include but not be limited to the following items:
 Full emergency contact information,
 Detailed steps and communications of when data extract is obtained, and data conversion is returned,
 Ordered steps for ensuring balancing of the system,
 Determination of whether a test system is refreshed at the same time as production for any required process testing,
 Post-cut-over checklist,
 Criteria that determine when the system will be turned over to end user staff,
 A formal release from Advanced that documents that the system has been handed to Lakewood in full balance.

Subtask 3.13 – Cut-Over Plan/Go/No Go Deliverables
Subtask 3.12
Deliverables
 Go/No Go Criteria,
 Cut-Over Plan,
 Formal Lakewood Authorization to Transition to Live.

Subtask 3.13 – Entry Criteria
Criteria Responsible Party
 System is in a readiness state for all
critical path items
Advanced and Lakewood
 Lakewood has invoked Change Management plan
(employees, customers, vendors)
Lakewood
 End Users trained Advanced or Lakewood
Subtask 3.13 – Exit Criteria
Criteria Responsible Party
 Cut-Over Plan finalized Advanced and Lakewood
 Organizational Readiness Plan finalized Advanced and Lakewood

Page 40 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
 Go/No Go Meeting Advanced and Lakewood
 Authorization to Go Live Lakewood
 Post Cut-Over List of Tasks Advanced and Lakewood
Subtask 3.14 – Phase 13 – Transition to Live
The cutover to live will occur over a weekend and will be coordinated by the Advanced Project Manager and Lakewood staff.

The transition to live will have a new and final data conversion in which the data validation parameters, bill codes, rate mapping and transaction codes will all be approved by Lakewood and the Advanced Project Manager.

Subtask 3.14 – Deliverables
Subtask 3.13
Deliverables
 Final Cut-Over Plan Report,
 Final Release Data Conversion Refresh and Validation
Report,
 AR Balancing Report,
 Year and month active confirmation,
 AR Summary Details Report,
 Transaction Code Report,
 Rates Report.

Subtask 3.14 – Entry Criteria
Criteria Responsible Party
 Execution of Cut-Over Plan. Advanced and
Lakewood
 End Users trained. Advanced and
Lakewood
 3rd Party Vendors communicated and on board. Lakewood  Execution of Organizational Readiness Plan. Advanced and Lakewood
 Connectivity validated between the Infinity CIS
production instance and dependent systems.

Advanced
Subtask 3.14 – Exit Criteria
Criteria Responsible Party
 Go Live Signed Off. Lakewood
 Post Live Items identified. Advanced

Page 41 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
Subtask 3.15 – Phase 14 – Post Go Live
Lakewood will receive one (1) month of standard post Go-Live support.

Advanced will assist Lakewood throughout the post live implementation phase to identify and respond to any needs and concerns. During the Post Go-Live period, Advanced will supply, as per the agreement, remote communications, and online support through video conferencing to ensure a smooth transition to Customer Success. During this phase of the project, the following items will be supplied to Lakewood:
 Weekly Project Manager and technical staff meetings to review all highpriority items,  Remote communications and video conference customer support,  Introduction and transition to Support.

Throughout the Post Go-Live period, the Advanced Project Manager will continue to act as primary resource for all issues. Upon completion of the Post live support period, Lakewood will transition to the Advanced Customer Success Team as per the Support and Maintenance agreement. Additional support (remote or onsite) is available at an additional cost.

Subtask 3.15 – Deliverables
Subtask 3.13
Deliverables
 Monthly Post Live Support Log,
 Transition to Support.

Subtask 3.15 – Entry Criteria
Criteria Responsible Party
 Go-Live Signed Off. Lakewood
 Post Live Punch List Items Identified. Advanced
Subtask 3.15 – Exit Criteria
Criteria Responsible Party
 Post Live Punch List Items resolved. Lakewood and
Advanced
 Project Completion documented. Advanced
 Transition to Customer Success Group. Advanced

Page 42 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
Schedule 1 – Fees and Payments
Fees
Professional Services Fees
Line Item Price
Services related to Infinity CIS V3 to V5 upgrade
 Project Management
 Installation
 Configuration
 Data Integrity
 Conversion
o Including Advanced created reports
 Training
 Integrations
 Go-Live support
 Post Go-Live support
$464,208
CIS Upgrade Discount -$464,208
Additional 2 yrs of data conversion (total of 7) $7,410 Services related to REST API $20,000
REST API Discount -$20,000
Services related to Infinity CIS V5 cloud hosting setup $18,000 Infinity CIS V5 cloud hosting setup Discount -$18,000
Services related to SmartVX (Welcome package) $15,000
SmartVX Discount -$15,000
Services related to Infinity CEP (AI MyMeter) $78,000
Services related to Infinity MWM CEP (ServiceLink) $48,162 Total $133,572
Annual Recurring Fees*
Line Item Price
Infinity CIS V5 Platform Cloud hosting Fee
 Concurrent Users and up to 29,000 accounts
$93,000
SmartVX (Welcome Video) Subscription Fee $1,995
SmartVX (Welcome Video) Discount -$1,995
Infinity CEP (AI MyMeter) Subscription Fee
 Unlimited concurrent users and up to 29,000 AMR/AMI
meters
$41,400
Infinity Infinity MWM (ServiceLink) Subscription Fee
 20 Named Users
$52,437
Total $186,837*
*Above fees will be added to existing recurring fees
Estimated Travel Expenses
Line Item Price
Travel Expenses - AUS
Available on request
Billed as incurred
per rates outlined
in MSA

Page 43 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
Pricing Assumptions

1. Additional recurring fees in this SOW outlined above will be in addition to existing 2024 recurring fees, pro-rated for the remainder of the year to align with annual invoicing, and invoiced immediately.

2. Annual recurring fees are subject to an annual price increases.

3. Additional services required by Lakewood through the end of Post Live and approved through the Change Control Process (e.g. requirement changes or changes to the project scope) will be billed at a rate of $250/hour. Services required after that period will be billed in accordance with the Support and Maintenance Agreement.

4. Additional Subscription Fees that exceed maximum account/meter allowance as follows: CIS platform hosting fee at $2.50 per account per year, and CSS (CEP) at $1.00 per meter account per year.

5. Hosting data storage and corresponding pricing:
a. Data Storage Limit: 1024 GB1 (data held in the database) 1 Any additional data stored will be charged at $5.52/32GB per month or the then current rate and will be invoiced monthly and due upon receipt.
b. Data Export Limit: 100 GB2 (data exported from the Infinity Cloud Platform)
2 Any additional data exported $0.13/GB per month or the then current rate and will be invoiced monthly and due upon
receipt.
c. Document Storage Limit: 250 GB3 (binary files or documents stored in the application).
3 The organization has up to 250GB of Document Storage Limit per month available. Any additional artifact storage will be charged at $0.03/GB per month or the then current rate and will be invoiced monthly and due upon receipt.

6. All charges are exclusive of out of pocket expenses for Professional Services performed. Charges for actual and reasonable out-of-pocket expenses including, but not limited to, travel and lodging expenses will be billed monthly as incurred. Lapsed payments may lead to denial of access to the Service. Delayed payments are subject to an interest charge at a rate per annum that is equal to the prime lending rate set by the Bank of Canada plus 2.5% compounded monthly (or the prime lending rate set by the Federal Reserve plus 2.5% compounded monthly in the case that Organization is located in the United States), or the highest amount permitted by applicable law, whichever is lower.

7. Additional Professional Services may be provided on-site or via the telephone. Additional Professional Services work provided via telephone is billed at the rate of two hundred and fifty ($250) per hour.

Additional Professional Services work performed on-site does not include travel, lodging and per diem expenses. Professional Services performed one year or more after the execution date of this Agreement shall be billed at the then current Advanced Professional Services rates. Help line support and Support Services do not include training or other Professional Services. Customer shall incur a seven-hundred fifty dollar ($750) daily surcharge for any Professional Services provided on weekends or Advanced recognized holidays; plus the corresponding standard Professional Services fees and any applicable travel charges.

Page 44 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
Payment Milestones
Professional Services:
 50% on signature of SOW
 25% on installation of software
 15% on start of Core Team Training
 10% 30 days Post Go-Live
License Fees:
 100% due on SOW signature
Annual Fees:
 Infinity CIS V5 Platform Cloud hosting Fee:
o 100% on signature of SOW.
 Infinity CEP (AI MyMeter) Subscription Fee
o 100% due upon the start of the CIS v3 – v5 Upgrade Project Kickoff Meeting.
 Infinity Infinity MWM (ServiceLink) Subscription Fee
o 100% due upon the start of the CIS v3 – v5 Upgrade Project Kickoff Meeting.

Page 45 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
Termination
Unless Advanced and/or Lakewood exercises its right to terminate this SOW due to material breach or default, Advanced must provide, and Lakewood must purchase, services from Advanced for the items defined within this SOW.

It is specifically understood that Advanced is providing $464,208 worth of Infinity CIS Professional Services at no additional cost to Lakewood for an in consideration of its continued use of the other services and products hereunder for its entire term of 60 months. The value of these services is therefore being credited to Lakewood at the rate of $7,736.80 per month.

Should Lakewood terminate for this SOW for any reason, the pro rated value of these services shall be immediately due and owing for the remainder of the term.

If Lakewood and/or Advanced exercises its right to terminate this SOW due to material breach or default, or Customer and/or Advanced terminates this SOW without cause,
Lakewood’s obligation includes the following:

1. Provide notice of 10 calendar days for termination without cause;

2. Return the software to Advanced and certify, under the hand of a duly authorized officer of the Organization, that all copies of the software or any part thereof, in any form, within the possession or control of the Organization have been returned to Advanced (if applicable).

3. Complete payment for services performed and expenses incurred prior to termination including:
a. Any amounts previously invoiced but unpaid;
b. Fees for services performed through the termination date which has not been invoiced; and
c. Any approved travel and living costs.

Advanced’s obligation includes the following:

1. Provide notice of 10 calendar days for termination without cause.

Under no circumstances shall Advanced be liable for any special, indirect, consequential, punitive or incidental damages of any kind and shall not be liable for loss of profits, works stoppage, system failure or malfunction, loss of data or any other damages or losses in connection with this statement of work, even if Advanced has been advised of the possibility of such damages. In any event, Advanced shall not be liable to pay any amount, in the aggregate, that is greater than the fees received by Advanced under this statement of work.

Except as otherwise expressly set forth herein, this SOW is performed pursuant to the terms and conditions of “Lakewood, CA Advanced Master Subscription Agreement - Cloud Hosted” between the parties.

Page 46 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
Approvals
IN WITNESS WHEREOF the parties hereto have duly executed this Scope of Work to be effective as of the execution date below.

N. HARRIS COMPUTER CORPORATION
Per:

Name:

Title: Executive Vice President
Date:

City of Lakewood, CA
Per:

Name:

Title:

Date:

Page 47 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
Appendix 1 – Table of Responsibilities
(Deliverables)
Del
#
Task
Per
SOW
Subtask
Per
SOW
Name Deliverable Description/Definition Deliverabl
e Lead
1 1 1.2
Weekly and Monthly
Status Meetings &
Reports
Project meetings to be attended by
Advanced and Lakewood. Project core
team members to discuss work in
progress, issues, risks, actions,
near-term planned activities and
associated resource commitments.

Status reports to document project
progress.

Advanced
2 1 1.3 Quarterly Sponsor
Meeting
Meeting attended by Advanced and
Lakewood Project Manager and
Project Sponsors to review project
status.

Advanced
3 3 3.1
Environment ready
for Software
Provisioning
Application and database server
(production and test) provisioned,
and the operating system and
database software have been loaded.

Advanced/
Lakewood
4 3 3.1 Project Kick-Off
Meeting
Kick-off meeting held with the
project team.

Advanced
5 3 3.1 Draft Project
Schedule
Initial draft Project Schedule
delivered at project kickoff
meeting. Project Schedule updates
performed throughout the project.

The schedule is updated for
refinements to tasks, and percent
complete inclusive of resource
updates and timeframe updates.

Both parties will commit to
staffing and resources to meet a
rolling 3-month window.

Advanced
6 3 3.1 Risk Management
Plan
Plan that defines how project risks
will be logged, prioritized,
assigned and managed to closure
using a jointly agreed resolution
strategy. Risk Log will be
reviewed at project status
meetings.

Advanced
7 3 3.1 Communication Plan
Plan that defines the Project
Strategy for communicating
internally within the Project Team.

Advanced
8 3 3.1 Change Management
Plan
Plan that defines the strategy for
communicating with employees and
externally.

Lakewood
9 3 3.1 Change Control
Process
Process that defines how changes to
project scope will be logged,
approved, and managed as agreed to
by both parties.

Advanced
10 3 3.1 Training Plan
Plan that defines Lakewood
resources to be trained, the
courses to be delivered, materials,
locations, facilities and other
resources.

Advanced
11 3 3.1 Test Plan Plan that defines Lakewood’s
testing approach.

Advanced
12 3 3.1 Infinity CIS v5
Server Provisioning
Provisioning of Infinity CIS V5 on
Infinity Cloud Platform
Advanced
13 3 3.1 Access Training
Access to client instances in
Infinity Cloud Platform training
for technical personnel.

Advanced
15 3 3.1 Training Courses
Syllabus
Document that outlines the
duration, prerequisites and topics
Advanced

Page 48 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
to be covered during the Advanced
delivered standard training
courses.
16 3 3.1 Project Team
Contact List
Project listing of all Advanced and
Lakewood project team members’
contact information.

Advanced
17 3 3.1 System Overview Infinity CIS V5 system overview demonstration
Advanced
18 3 3.1
Issues Tracking
Tool Overview and
Set up
Advanced will provide Lakewood with
and overview of the Issues Tracking
Tool, the online tool for
documenting and tracking issues as
part of the overall implementation.

Lakewood users will be provided
with user ids and passwords which
also provide access to the Software
Entity relationship diagrams and
the Data Dictionary.

Advanced
19 3 3.1 Solution Overview
Workshop Agenda
Documents that outline the business
and conversion processes to be
discussed during the Solution
Overview Workshop(s).

Advanced
21 3 3.2.1 Solution Overview
Workshop
Sessions that will assist Advanced
in learning Lakewood business
processes and educating Lakewood
about the features and limitations
of the software. Advanced will
lead the sessions with Lakewood
business process experts
participating.

Advanced
22 3 3.2.1 Solution Overview
Document
Document that captures all learning
and understanding gained in the
Solution Overview Session Analysis
Workshops. Document will serve as a
template for configuring the
software.

Advanced
23 3 3.3
Interface/Enhanceme
nts Discovery
Workshop Agendas
Documents that outline the items to
be discussed during the
Interface/Enhancement Discovery
Workshop.

Advanced
24 3 3.3 Interfaces/Enhancem
ents Workshop
Session that will aid Advanced in
understanding modification
requirements and the third-party
systems’ interfacing capabilities
to determine the best approach for
interfacing with the identified
third party systems.

Advanced
25 3 3.3
Business
Requirements
Document
BRD and/or Use Case Documentation
for interfaces/Enhancements
identified in Task 2.2. Test Case
Documentation for interfaces
identified in Subtask 2.2.

Advanced
27 3 3.4.1 Reports Analysis
Spreadsheet
“Appendix 2 – Reports” Advanced
28 3 3.4.3 CSS Discovery
Workshop
Session that will assist Advanced
in learning how Lakewood will
deploy CSS service orders and
educating Lakewood about the
features and limitations of the
software. Advanced will lead the
sessions with Lakewood business and
technical experts participating.

Advanced
29 3 3.4.3 CSS Discovery
Document
Document that captures all learning
and understanding gained in the
Discovery Workshop. Document will
serve as a template for configuring
CSS.

Advanced

Page 49 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
30 3 3.4.4 MWM Discovery
Workshop
Session that will assist Advanced
in learning how Lakewood will
deploy MWM and educating Lakewood
about the features and limitations
of the software. Advanced will
lead the sessions with Lakewood
business and technical experts
participating.

Advanced
31 3 3.4.4 MWM Discovery
Document
Document that captures all learning
and understanding gained in the
Discovery Workshop. Document will
serve as a template for configuring
MWM.

Advanced
32 3 3.5.1 Initial Data
Conversion Load
Loading of initial conversion by
Advanced on Lakewood’s system.

Advanced
33 3 3.5.1 Baseline Accounts
Lakewood, with Advanced’s
assistance will identify Baseline
Accounts to be used for testing.

Lakewood
34 3 3.5.1 Data Validation
Results
Report that documents the results
of the agreed upon conversion
validation parameters for both the
source and target data.

Advanced
35 3 3.5.1
Initial System
Configuration
Rollout
Configuration of the control forms
and rates by Advanced based on the
Solution Overview Session document.

Advanced
36 3 3.5.2
Initial CIS Upgrade
Conversion, Data
validation Testing
Advanced will convert Lakewood’s V3
data load into Lakewood’s Infinity
CIS environment. Advanced will
supply data a data validation
report confirming both V3 and
Infinity CIS V5 are in balance and
will release the system for testing
by Lakewood
Advanced
37 3 3.6 Training Agendas
Standard Training Agenda for each
training course identified in the
Training Plan.

Advanced
38 3 3.6 Core Team Training
Execution and completion of Core
Team training per the Training
Plan. Training will include the
Issues Tracking Tool training.

Advanced
39 3 3.7 Custom Reports
Delivery
Delivery of custom reports
identified In “Appendix 2 –
Reports”.

Advanced
40 3 3.8.1
Interface
Configuration,
Testing and Rollout
Configuration, testing, and rollout
of configuration type interfaces
that have been identified in Task

2.2 of this SOW.

Advanced
41 3 3.9.1
Functional Test -
Data Conversion
Data Load &
Validation
Loading of conversion data by
Advanced on Lakewood’s system.

Includes audit report that
documents the results of the agreed
upon conversion validation
parameters for both the source and
target data.

Advanced
42 3 3.9.1 Generic Test
Scripts
Generic Integration Test scripts
provided by Advanced to test system
functionality.

Advanced
43 3

3.9.1,

3.9.2,

3.9.3. System Testing
Lakewood to conduct testing as
outlined in the Test Plan, document
test results (pass/fail) and log
any issues in the Issues Tracking
Tool for resolution by Advanced.

Lakewood
44 3 3.9.2 Build Releases
(ITC)
Installation of new builds on
Lakewood’s system which include
Lakewood’s modified software and
interfaces.

Advanced
45 3 3.9.2 Integration Test -
Data Conversion
Loading of conversion data by
Advanced on Lakewood’s system.

Includes audit report that
Advanced

Page 50 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
Data Load &
Validation
documents the results of agreed
upon conversion validation
parameters.
46 3 3.9.3
User Acceptance
Test - Data
Conversion Data
Load & Validation
Loading of conversion data by
Advanced on Lakewood’s system.

Includes audit report that
documents the results of the agreed
upon conversion validation
parameters for both the source and
target data.

Advanced
47 3 3.10
End User Training,
Signoff and
Attendance Report
Execution and completion of EndUser training per the Training Plan. Each training session will
have an Attendance Report.

Advanced
48 3 3.11 Go/No Go Criteria
Document
Document that identifies the
criteria that will be adhered to
enable cutover to Production to
proceed. It includes metrics to
evaluate project management
readiness, business solution
testing readiness, business
readiness, IT infrastructure
readiness and reorganization/people
readiness.

Advanced
49 3 3.11
Go / No Go Decision
Document approved
for Go Live
Document that defines the outcomes
of application readiness based on
the defined Go/No Go Criteria
document and Cutover Plan defined.

The result will be a decision to
Go-live or to identify issues that
will need to be resolved prior to
Go-Live or can be deferred to post
go-live. The decision to
transition to Go Live will be
approved when the items defined in
the Cut-Over and readiness
assessment has been successfully
achieved and there are no
significant agreed upon issues that
will impact transition to
Production.

Advanced
50 3 3.11 Cutover Plan
Document that defines steps and
responsibilities of Advanced and
Lakewood during transition to
Production. Includes steps to
achieve system balance and includes
a conversion cutover plan.

Advanced
51 3 3.12
Go-Live - Data
Conversion Data
Load & Validation
Loading of conversion data by
Advanced on Lakewood’s system.

Includes audit report that
documents the results of the agreed
upon conversion validation
parameters for both the source and
target data.

Advanced
52 3 3.12 Go-Live
System is operating and being used.

Balancing of legacy and Advanced
CIS has been validated and signedoff by Lakewood.

Advanced
53 3 3.13 Completion of Post
Live Support
Conclusion of Post live support
period, which includes remote and
online video conferencing.

Advanced
54 3 3.13 Customer Success
Transition Meeting
A transition meeting to transfer
from the project implementation
phase to the support phase of the
contract.

Advanced

Page 51 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
Appendix 2 – Reports
Complete list of all 432 custom reports identified in Infinity CIS V3 through the code and system audit:

Report Name Report Description
Meter Read Sheet A4365
Batch Summary by Transaction and Date Batch Summary by Transaction and Date ADV - Bills for specified number of Days Bills By Number of Days (filtered as follows) LKWD - Accounts by Cycle Accounts By Cycle
ADV Water Meter by Cycle Water Meter by Cycle
epa tets Block Summary
Transaction Code Multi Company/Division Transaction Code Listing Online Payments over 5000 A5209
letter history table Letter History
WEB003
Lakewood Accounting Monthly report Monthly Transaction History Detail Lakewood Monthly GL summary Transaction Daily Summary
Lakewood Bill Detail A319869
Tawny Unbilled report A319891
Lakewood Billed Consumption
LKWD -Vacant Account Usage Vacant Account Usage in Gallons ADV-Lakewood Extra bin R319900
LKWD - Arrearage TransactionsCodes A319999
Detail Test Transaction Daily Summary
Cave Creek Consumption Report R75
Transaction Detail Report Transaction Daily Summary
Water Meter by Cycle Copied 020207 Water Meter by Account Hydrant Deposit Transaction Report Transaction Daily Summary Cave Creek Meter Report Customer Count based on Active Meters Cave Creek Consumption AIAC R231
Unbilled Revenue A201
All Consumption Total Consumption February
AR Reconciliation (Debit) R287

WVWC MANUAL READS
SC/PV METER CONSUMPTION Customer Count based on Active Meters Billing with all Transaction R350
Billing Batch R350
Test Summary Report Block Summary
Billing with Consumption R350
Billing Testing R350
Payment Summary R289

Page 52 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
Service Orders Not Printed Service Order Cancelled
WMC Meter AIAC Monthly Meter Sales & Meter AIAC Detail Report After Hours Establishment & Reconnect
Revenue
Establishment and Reconnect Revenue
Meter Read Sheet for Excel A4365
Reconnection Count R563
After Hour - Connection R446
Penalties R368
Service Order Created Service Order Cancelled
SO Cxl R562
Bad Debt R464
Katherine's Collection Status R405
Negative Consumption
High Usage Exception Report * Over 40,000 gallons
Lakewood - Book 12 R319849
Lakewood-Move-Ins R319853
Lakewood-Last billed accounts R319854
Meter Data
Lakewood-Extra Bin R319900
LKWD WAVE Move In R319911
Paymentus Payment Plan
Move-Out Dates (Lakewood) R5464
Lakewood-Number of Payments R319894
Lakewood Total Payments R319930
Lakewood - Customer balance $500 R319934
Lakewood-# of Water Accounts R319944
Lakewood-Testing Meters R319945
Valley collections R319946
Valley Collections 2 R319947
Lakewood-Bill Print Status R319927
LKWD-No Return Envelope
LWKD-IL Emails R319961
MP Batch Totals
Menlo Park- Consumption R5377
MP- Consumption by Batch ID
Move in Dates (Lakewood) R5464
Read MGT Report
Read MGT Report 2
Read MGT Report 3
Read MGT Report 4
old reference number
tor mailing address

Page 53 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
Payment Arrangements
Service_Carmelle R4867
VAU
Billed customers for ebills R4893
Pending Research_CR R5028
Exempt - Notices/Penaties R5028
Complaints_Account Notes
Forced Comments_GV Customer Account Comments
SLA_SO's_Metrics R5400
LW Read History
Updated Date/Time
LW EBILLS R5524
test SC/PV CUSTOMER CONSUMPTION REPORT
FEBRUARY 2007
Adjustment Report Adjustment Report
valencia reconnects R589
contact reasons willow valley A275
DeeAnnas Testing Report R4846
Lakewood Active Accounts R319927
LAKEWOOD RES BALANCE > $500 R319932
Lakewood Balance
Lakewood - Extra Bin R319943
Lakewood Exempt No WAVE R319950
Lakewood Paperless Billing
LAKEWOOD MOVE OUT R319975
Lakewood Walk In Payments R319979
12/20/19TOTAL
Lakewood Payment Report- Detail R319893
Lakewood Payment Report- Summary R319894
Lakewood Payment Service Breakdown R319895
Lakewood- Paymentus
Lakewood Bill and Consumption Report R319913
Lakewood Payments R319957
Lakewood Outstanding Balance R319974
Water/Sewer

ESTIMATE READS
READ TYPE BY CYCLE R333
METER INVENTORY R334
Batch Totals R375
Collections Status R405
Service Address R432
Old account number
Service Address by Book R480
Meter Installs R481

Page 54 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
NEW METER INSTALL REPORT R482
LKWD - Customer Name R484
Disconnected Accounts - Weekly
Posted Payment Report
Pending Disconnects R515
Move-out by cust #
Recycled accounts R565
Removed Services
Read Type R591
Reco Deposit R597
Service Address
Disconnected Customers

SSN AND DL
Manual Notices
Meter install date R665
LKWD - Incoming Customers R675
Open SO's Billing and Collections Service Order Cancelled Job Run History
For Disco Final Service Order Completed
Billing and Collections Service Order Cancelled
Manual Read List Data R4647
Sewer Code Audit
Weekly B&C
Disco Finals
Final Bills R4694
MP All BFI
Not active new accounts
DAILY_SO_METRIC R4993
Pending Read Report R5002
Move-out date aging R5003
Daily SO Management Report R5043
Notices
Pending Notices R5033
Cycle Bill Reconciliation R5007
Payment Method
DAILY_SO_METRIC R4993
DAILY_SO_METRIC R4993
Mailing Addresses R5096
Move-out dates R5103
Pending Bills R5007
SCPV DISCO's
Pending Bills with Cust ID R5007
GWRI Open R5216
GWRI Completed R5216

Page 55 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
Kennedale SO Metrics
Previous Reads R5254
Notices for MTD R5033
No bill accounts R5253
Pending Reads
FBSO closed before move-out R5301
Structure type R5353
Owner address R5359
AMR repair and BFI R5406
Missed Reads
GWRI AMR AND METX R5414
MP VAU
Processed Notices
Lakewood Move in/out report R5482

INSTALLATION AND EXCHANGE
Meter table R5491
Read Status and Usage R5493
Usage and Status R5494
Usage and Bills R5231
Read Status and Bills R5269
Notes R5505
Read History R5508
UT Ebill Emails R5524

METER EXCHANGE
Remote ID R5527
Due date extensions R5546
Read import
Read status R319788
Everett billed zero consumption R4778
Service Addresses Service Addresses

SOPAS OPEN
X Y Coordinates R5315
Rates & Proration profile
Service Order Created Service Order Pending
Pending Bill w/Consumption R5007
Completed and by user
Pending Final Bill Service Orders R5088
Bill Codes and Rates R5555
Implementation Rates R319758
manual reads R7
ccwc feb 2007
DiscoFinal
RRU Open SO's
Grass Valley Contacts R5011

Page 56 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
GV Contacts (CIS)
Posted Payments CC
Red Rock Open SO's
SC/PV CONSUMPTION BY METER R156
Global Water Rate Increas Report by A/R
Menlo Park Billed Consumption Report R4778
MP SUR2
MP SUR2
Red Rock Open Service Orders
EPA Report - September Consumption
Previous Read Prior to 09/08/10
Red Rock Last Payment Received
WUNS Meter Charges
Cycle 3 Billing
Pulte Potable & Reclaimed Report
Pulte Report
Pulte R & R Report
Proration Issue R4826
Proration Issue R4827
Maricopa Sewer Connections 2009
SCPV Notice 1 Report
Pulte Report R4838
SCPV Not Yet Billed Cycle3
No Sewer
Red Rock Open S/O's R4844
Lakewood Posted Payments R4846
Torrance Book 2373 30/60 Day Bills
Disconnect Exemptions
Torrance Accounts w/ Previous Read R4860
Torrance Previous Reads
Torrance Read Types
Red Rock Active Customer Adresses R4880
Torrance Bill/ May Due Date
Vacant Account Usage Report
MP Late Fees
Sewer Report for Chad P R4889
GV Billed Customers R4893
Red Rock Proration Error Financial Impact R4894
Torrance Due Dates & Notice Dates R4907
GV Cycle 1 & 2
GV Cycle 1 & 2 Read Report R4914
Torrance Read & Bill Dates
SCPV Cycles 4-6 Mailing Addresses R4942

Page 57 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
GV Route 1 Mailing Addresses R4953
Torrance Oct Due Dates
Torrance Notes
TOR $50K Cancelled Bill R4962
Torrance Due Dates for Ashley R4963
MP Meters w/ Location
GV Door Hangers R4985
MP Read Detail
GV Comments R5079
GV Bill Dates
Monthly Meter Sales & AIAC Detail Monthly Meter Sales & Meter AIAC Detail Report Sales Tax Report Monthly Sales Tax Detail Report
Santa Cruz Annual Consumption R156
No Deposit on Account R441
Bankruptcy A/R Customer / Account
Listing
R464
Disconnected w/ No Collection Activity Disconnected Accounts with Status No Collection Ac
Disconnect Notices Sent R632
Contact Reason Contact Mgmt
Collections Status Search
Meter Size
Service Order Summary- Open CSR ONLY R561
Contact Reason RRU A275
FBSO Incoming Search
Completed Disconnects KMD R563
Menlo Park Open SOs
Contact Reason Menlo Park A275
EPA R4775
Katherine's Test Report
Katherine's Test Report 2
KMD Test
Cash Batch Search Bill Pay Error Tracking
Daily Account Notes R4988
Refunds R523
Meter and EP Query
Service Order Summary-Created wAccount #R564
Service Order Summary-Created-Account
#
Service Order Summary-CXL w-Account #
Final Bills
Meter Installed
Cash Security Deposit Transactions R81

Page 58 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
Billing Security Deposit Transaction R115
Hydrant Meter Deposit Transactions R120
AR Reconciliation (Credit) R287
AR Reconciliation R289
AR Reconciliation R292
Re-read Revenue R321
Construction Billing
Pending Read R365
New Report
New Report
Billing Consumption Report R383
New Start
Billing by Billing Code/Company R439
New Connection R446
Meter AIAC Balance R479
Meter Installed Date R535
Book R536
Detail Transaction
Meters installed for SC R626
Valencia Sewer Payable R4565
Valencia Sewer Adjustment
Cusomter Refund Report R4613
Billing Detail R4614
Deposit Report
Hydrant Deposit R4702
By Book Block Summary By Cycle
By Account Block Summary
Torrance Billed Accounts R4614
Global Billed Accounts R4614
Billed Accounts R4614
Services R319832
New KMD Report R632
082710 Report for rate case
Cancelled Bill Report R4839
Read History and Meter
Torrance Books
GV Re-Read R4984
Batch Summary by Transaction and Date
Copy
Batch Summary by Transaction and Date
Meter Read Sheet v2 A4365
ADV - Billing Details R4614
Service Order Test
Total Accounts (Lakewood) 0.5

Page 59 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
Consumption By Structure Type
(Lakewood)
R5151
Cycle09 Read History-Lakewood R5508
Cycle 06 Read History-Lakewood R5508
Service Order Pending
Lakewood Service Orders R319909
SCPV Notice 1 Sent R4829
SCPV 4-6 Notice 1 Listing
ADV - Block Summary Detail ADV - Block Summary Detail

TISHA'S OPEN SERVICE ORDER REPORT
LW - VAU Service Orders R4580
Meters -By Cycle

METER REPORT FOR MANUAL READS
Nicks Meter Report R4688
CC Service Order Report R5307
Kennedale Reco Report
Visalia Cancelled Bills Visalia Cancelled Bills
Visalia Finalled
Bills per Account R5421
Bill Pay Detail Report Bill Pay Detail Report
Total Bills per Client Total Bills per Client
Bill Pay Mailing Addresses
Cash App Processing Detail Report Bill Pay Detail Report credit card echeck payment report Bill Pay Detail Report Camden Block lot list Camden Block Lot List
Open Service Orders - Carissa R570
Maricopa - Open Service Orders R600
Service Order Summary - Open R561
Service Order Summary - Created R564
Service Order Summary - Completed R563
Service Order Summary - Cxl R562
Month End - 77100.0000 Transaction Monthly Summary
Month End - 77102.0000 Transaction Monthly Summary
Month End - 77901.0000 Transaction Monthly Summary
Month End - 76101.0000 Transaction Monthly Summary
Month End - 76103.0000 Transaction Monthly Summary
Month End - 76104.0000 Transaction Monthly Summary
Month End - 76109.0000 Transaction Monthly Summary
Month End - Palo Verde Transaction Monthly Summary
Month End - 10353.0000 Transaction Monthly Summary
Misc GL Lookup After Hours Revenue
Red Rock Open SO's R561
Red Rock SO - Created R561
Red Rock SO - Completed R561

Page 60 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
Red Rock SO - Open R561
Notices Sent R4655
RRU SO's - CXL R562
Payment Arrangements R405
Payment Arrangements R4675
Disco Cxl R564
VWC Multi Family R4614
MP Bill Detail R4614
Customer Notes_CR R4730
EPA Monthly Consumption R4739
Maricopa Open Service Orders 12.12.13
123113 so report
Lakewood Audit
Lakewood Audit Move in Out
Lakewood Current Balance R319873
Lakewood Service Accounts R319878
LKWD Audit Bill Date Tawny
LWKD Extra Bin Estimate
Lakewood - Audit Bill Dates
LK - Vacant Account Listing
LKWD Mailing Addresses
LKWD - Service Address R319966
Tawny - Extra Bin R319969
LKWD - Mailing Addresses R319970
LKWD - Testing Service Address
LKWD - Testing Service Address
LKWD TEST PAPERLESS R319988
LKWD - Meter Charges on Active Accts R319989
LKWD - Accounts with Bill Code
LKWD - # of bills
LKWD WAVE Move Out R319911
LKWD - Vacant Account Listing Vacant Account Usage in Gallons LKWD - All accounts not active R319996
LKWD - Extra Bins Multiplier R319997

LKWD COVID ARREARAGE LIST
LKWD - Account Type Listing
LKWD - Account by Book R320004
LKWD Trash Multiplier Customer by Bill Code Detail
LKWD - WRD Report for Vacant Accounts
LKWD - Account Type
LKWD - Account UUT Tax Status
LKWD - Recent Billed Usage
LKWD - Bills by date range

Page 61 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
LKWD - Accounts Billed for Trash
Adjustment by Company/Adj Code R625
Block Summary Detail R1183
Customer Revenue by Location Customer Revenue Report by Location New Customer Report
Out of 20 V3 Advanced created custom reports, Advanced will convert 12 of these reports identified with a ‘Y’ in the list below.

Report Name Report Description Used Y/N -
To be completed
by Lakewood
Meter Read Sheet A4365 N
Batch Summary by Transaction and
Date
Batch Summary by Transaction
and Date
Y
ADV - Bills for specified number of
Days
Bills By Number of Days (filtered
as follows)
Y
LKWD - Accounts by Cycle Accounts By Cycle Y
ADV Water Meter by Cycle Water Meter by Cycle Y
epa tets Block Summary N
Transaction Code Multi
Company/Division
Transaction Code Listing N
N
Online Payments over 5000 A5209 N
letter history table Letter History N
WEB003 N
Lakewood Accounting Monthly
report
Monthly Transaction History
Detail
Y
Lakewood Monthly GL summary Transaction Daily Summary Y Lakewood Bill Detail A319869 Y
A319885 N
Tawny Unbilled report A319891 Y
Lakewood Billed Consumption Y
LKWD -Vacant Account Usage Vacant Account Usage in Gallons Y ADV-Lakewood Extra bin R319900 Y
LKWD - Arrearage
TransactionsCodes
A319999 Y

Page 62 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
Appendix 3 – MyMeter Utility License
This MyMeter Utility License Agreement (“Agreement”) is a legal agreement between the Jupiter ("Utility") who purchased the MyMeter software and related services from an authorized reseller, and Accelerated Innovations, LLC ("AI") regarding the provision of, license to, access to, and use of the MyMeter software and related services (the "Services"). In this Agreement, "we", "us" and "our" refer collectively to AI.

IMPORTANT:

THIS AGREEMENT DOES NOT ALTER THE RIGHTS OR OBLIGATIONS AS BETWEEN UTILITY AND

THE RESELLER FROM WHICH UTILITY PURCHASED THE RIGHT TO ACCESS AND USE THE SERVICES ("RESELLER"), PURSUANT TO ANY WRITTEN AGREEMENT BETWEEN UTILITY AND RESELLER REGARDING THE SERVICES. THIS AGREEMENT INSTEAD SETS FORTH ADDITIONAL

TERMS DIRECTLY BETWEEN UTILITY AND AI, AND UTILITY MAY OTHERWISE SEEK RIGHTS OR REMEDIES FROM RESELLER PURSUANT TO UTILITY'S AGREEMENTS WITH RESELLER.

UTILITY AGREES TO THE TERMS AND CONDITIONS OF THIS AGREEMENT UPON SIGNING A RESELLER AGREEMENT REGARDING THE SERVICES .

1. CERTAIN DEFINITIONS. In addition to other terms that are defined as set forth in this Agreement, the following terms shall have the following definitions:

1.1. "Device" means any Utility or Utility's User's computer, tablet, smartphone, or any other electronic device.

1.2. “Intellectual Property” means any and all of the following in any jurisdiction throughout the world and all rights in, arising out of, or associated therewith: (a) patents, utility models, and applications therefor, and all reissues, divisions, re-examinations, renewals, extensions, provisionals, continuations and continuations-in-part thereof, and equivalent or similar rights anywhere in the world in inventions and discoveries, including invention disclosures; (b) all trade secrets, inventions (whether or not patentable and whether or not reduced to practice), and other rights in knowhow and confidential or proprietary information; (c) all mask works, works of authorship and copyrights, registrations and applications therefor, and all other rights corresponding thereto (including moral rights), throughout the world; (d) rights in software (including without limitation APIs, source code, object code, and mark-up language); (e) rights of publicity, personality, identification, or similar personal or group attributes; (f) trade names, logos, common law trademarks and service marks, trade dress, trademark and service mark registrations, and applications therefor and any goodwill associated therewith; and (g) any similar, corresponding, or equivalent rights to any of the foregoing and any other intellectual property or proprietary rights throughout the world.

1.3. "Modifications" means additional or modified functionality, updates, enhancements, security updates and patches, and upgrades to the

Page 63 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
Services or to remove or terminate the functionality of any Services in accordance with the termination provisions of this Agreement.

1.4. “Users” means each individual user of the Services.

2. LICENSE SUBJECT TO THIS AGREEMENT. Unless otherwise noted in this Agreement, and to the fullest extent allowed under any applicable laws, all terms and conditions of this Agreement apply to the license and Utility's accessing and using of any and all Services and provision of the Services to its customer Users, as otherwise granted pursuant to a written agreement with Reseller. Furthermore, Utility's license, access and use of any and all the Services and provision of the Services to its customer Users is contingent on the remittance of payment by the Reseller under the Reseller Agreement executed between AI and Reseller (“Reseller Agreement”). Utility's license rights to the Services are subject to Utility's compliance with this Agreement and are also expressly limited to the rights granted by Reseller to Utility, which are in turn are limited by the rights granted by AI to Reseller to resell to Utility a license to access and use the Services and to allow its customer Users to access and use the Services (hereinafter, those rights and licenses Reseller is authorized to resell to Utility being "Rightfully Granted Licenses").

2.1. THIRD PARTY SOFTWARE. Utility acknowledges that AI may have incorporated into the Services Intellectual Property created by third parties (“Third Party Intellectual Property”), and Utility agrees that Utility's right to use the Services containing Third Party Intellectual Property may be subject to the rights of third parties and limited by agreements with such third parties.

2.2. TITLE AND OWNERSHIP OF THE SERVICES. Title to and ownership of the Services and all copies thereof remain with AI and any other licensor(s) of the same, regardless of the form or media in or on which they may exist, and Utility agrees to protect all of AI's ownership interests therein. Utility is granted no implied licenses to any other Intellectual Property rights other than pursuant to Rightfully Granted Licenses. Utility acknowledges that the Services contain trade secrets of AI, its suppliers, or licensors, including but not limited to, the specific internal design and structure of individual programs and associated interface information, databases and database structures, regulatory compilations, and other Content accessed within the Services. All rights not expressly granted in this Agreement or pursuant to Rightfully Granted Licenses are reserved by AI and its licensors.

3. RESTRICTIONS ON USE. Utility may use the Services only for purposes expressly permitted within the Services, pursuant to the terms of this Agreement, and pursuant to Rightfully Granted Licenses. As a condition of Utility's use of AI’s Services, Utility warrants to AI that Utility will not use the Services for any purpose that is unlawful or prohibited by these terms, conditions, and notices. For example, Utility may not (and may not authorize any party to) do the following, except as allowed under Rightfully Granted Licenses: (i) co-brand the Services, (ii) frame the Services, without the express prior written permission of an authorized representative of AI, (iii) transfer, assign or sublicense Utility's login information or right to use the Services to another person or entity and Utility acknowledges that any attempted transfer, assignment, sublicense or use shall be void; (iv) make error corrections to, or otherwise modify or adapt, the Services or create derivative works based upon the Services, or permit third parties to do the same; (v) reverse engineer or decompile, decrypt, disassemble or otherwise reduce the Services to human-readable form, except to the extent otherwise expressly

Page 64 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
permitted under applicable law notwithstanding this restriction; (vi) disclose, provide, or otherwise make available trade secrets contained within the Services in any form, to any third party without the prior written consent of AI; (vii) use AI's Intellectual Property to develop any software application or products and services similar to the Services; or (ix) perform, display, or otherwise access or use the Services for the benefit of others outside of the scope of the Rightfully Granted Licenses granted to Utility. For purposes of this Agreement, “co-branding” means to display a name, logo, trademark, or other means of attribution or identification of any party in such a manner as is reasonably likely to give a User the impression that such other party has the right to display, publish, or distribute the Services or any Content accessible within the Services. In addition, Utility may not use Services in any manner which could disable, overburden, damage, or impair the Services or interfere with any other party's use and enjoyment of the Services. Utility may not obtain or attempt to obtain any materials, Content, or information through any means not intentionally made available or provided through the Services. Utility may not use scrapers, bots, spiders, or other automated tools to collect or index the Content of the Services without our express permission.

4. MONITORING OF USE AND ADDITIONAL RESTRICTIONS. Utility acknowledges and agrees that AI reserves the right to remotely prevent access to and/or use of the Services, with or without notice to Utility, including without limitation in the event that (i) AI becomes aware, from Utility or otherwise, of unauthorized access or use of the Services by any third party using any user name, password, or other login credentials of Utility or its Users, or in the event of a security concern related to the Services, or (ii) Utility's violation of any term or condition of this Agreement. AI reserves the right, but does not have the obligation, to monitor use of Services to determine compliance with this Agreement. The types of information, such as Devices used to access the Services, may also be tracked by AI (such as via Internet Protocol address and other log information regarding the Device, its operating system, browser, and other information regarding the User) to identify the Device and locate where on the Internet that computer is located, as well as Utility's use of the Services. It is be Utility's responsibility to administer the use, distribution and security and of its and its Users' passwords. Utility shall immediately notify AI in the event that such passwords are compromised or being used by unauthorized users. AI may use and disclose Utility's and its Users' information, including without limitation Identity Content, in special instances when AI has reason to believe disclosing this information is necessary to investigate, identify, contact, or bring legal action against someone who may be causing injury to or interfering with AI's rights or property, other Service Users, or anyone else. AI may disclose information when subpoenaed, if ordered or otherwise required by a court of law, arbitrator, or other similar proceeding or the rules governing such a proceeding, for government investigations, with government agencies if required by law, to exercise, establish, or defend AI's or Reseller's rights, to protect AI's vital interests or those of any other third party, and when AI otherwise believes in good faith that any applicable law requires it.

5. UTILITY RESPONSIBILITIES. The Services need to pull certain data from the Utility's systems in order populate the databases used in the Services.

This requires that the software data loader program be placed on the Utility's systems computer to pull data. The Utility shall be responsible for supplying and maintaining all computer hardware at its site. The computer hardware shall meet the following requirements: computer connected to the internet with at least a 15 MB internet bandwidth capacity, internal computer storage of 12 GB ram, and 150 GB disc space, and computer must be accessible by AI through

Page 65 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
secured internet connection. The Utility shall provide the data to AI in accordance with the file specifications to be provided to the Utility. The Utility is responsible for the content of any use or privacy policy to be included on the Utility's website. Said policy shall be made available to AI as a hyper link for inclusion on the web site for MyMeter. AI is not responsible for damages resulting from the web site privacy or use policy supplied by the Utility.

6. ADDITIONAL REPRESENTATIONS BY UTILITY. Utility represents and warrants that (a) Utility is the owner or authorized user of any information or content of any type provided by Utility in conjunction with the Services; and (b) Utility shall use the Services only for lawful purposes, and will comply at all times with all applicable federal, state, and local laws and regulations applicable to the use of the same.

7. PROPRIETARY INFORMATION. The material and content accessible through the Services including without limitation all Intellectual Property in or related thereto, whether software (whether in object code, source code, or mark-up language form), photos or other images, video, audio, text, or otherwise (the “Content”), whether provided by AI or its licensors, is the proprietary information of AI or the party that provided or licensed the Content to AI, whereby such providing party retains all right, title, and interest in the Content. Accordingly, the Content may not be copied, distributed, republished, uploaded, posted, or transmitted in any way outside of the normal functionality of the Services without the prior written consent of AI. Modification or use of the Content except as expressly provided in this Agreement violates AI’s Intellectual Property rights or the rights of its licensors. Neither title nor Intellectual Property rights to Content are transferred to Utility by access to the Services.

8. PROPRIETARY NOTICES. Utility agrees to maintain and reproduce all copyright, patent, trademark and other proprietary notices on all copies, in any form, of the Services and its Content, in the same form and manner that such copyright and other proprietary notices are included on the Services, whether they are AI notices or those of third parties including without limitation any other User.

9. UTILITY DATA OWNERSHIP. As between AI and Utility, “Identity Content” given to AI by Utility under this Agreement shall at all times remain the property of Utility and shall be Utility Confidential Information under Section 10 below. AI shall have no rights in the Identity Content other than the limited right to use such for the purposes of providing the Services or those expressly set forth in this Agreement. For the purposes of this Agreement, “Identity Content” shall mean any and all data received from the Utility that is identifiable as data from that Utility or data identifiable to a specific individual person.

10. CONFIDENTIAL INFORMATION. The Services, including, but not limited to, source and object code, logic and structure, database structure, and any and all copies of the foregoing, regardless of the form or media in or on which any of them may exist (all together, the “AI Confidential Information”) constitute valuable trade secrets, are the Intellectual Property and confidential information of AI and any other of their licensor(s), and are protected by copyright and Intellectual Property laws, international treaty provisions, and applicable laws of the country in which such AI Confidential Information is being used. AI Confidential Information additionally includes non-public information disclosed by AI if it is clearly and conspicuously marked as

Page 66 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
“confidential” or with a similar designation at time of disclosure or nonpublic information disclosed by AI if, by its nature, would generally be considered by AI to be confidential. Utility's confidential information is any passwords used in connection with the Software and information that Utility specifically designates as confidential. Neither AI Confidential Information nor Utility Confidential Information shall include information which: (i) is or becomes public knowledge through no fault of receiving party; (ii) was in receiving party's possession before receipt from the disclosing party; (iii) is rightfully received by receiving party from a third party without any duty of confidentiality; (iv) is disclosed to a third party by the disclosing party without a duty of confidentiality on the third party; (v) is independently developed by the receiving party; or (vi) is disclosed with the prior written approval the disclosing party. Each party may only disclose the other party's confidential information to those individuals who are participating in the performance of this Agreement and who need to know such confidential information for purposes of receiving and/or using such confidential information in a way expressly permitted by this Agreement, and neither party may use the confidential information of the other party for any purpose except as authorized under this Agreement. AI Confidential Information nor Utility Confidential Information may be disclosed in response to a valid court order or other legal process only to the extent required by such order or process and only after the party making such response has given the other party written notice, if legally allowed, of such court order or other legal process promptly and the opportunity for that other party to seek a protective order or confidential treatment of such confidential information, at that other party's expense, with reasonable cooperation by the responding party. Each party shall retain all ownership of its confidential information including without limitation all Intellectual Property rights in that confidential information. Subject to the licenses granted in this Agreement, Utility agrees, both during the term of the Agreement and after the termination of the Agreement to hold AI Confidential Information in confidence and to protect the disclosed AI Confidential Information by using the same degree of care to prevent the unauthorized use, dissemination or publication of the AI Confidential Information as Utility uses to protect Utility's own confidential information of a like nature, but in no event with less than reasonable care. Utility shall be responsible and liable under the terms of this Agreement for any violation of the confidentiality requirements of this Section committed by Utility's employees, agents, representatives, or independent contractors.

11. MAINTENANCE AND UPGRADES. Any Modifications provided to Utility shall be subject to the rights and obligations, including without limitation the applicable license terms and license restrictions, set forth in and referenced by this Agreement.

12. TERMINATION. The licenses granted by AI under this Agreement may be terminated in accordance with the terms of the Reseller Agreement or any written agreement between Utility and Reseller regarding the Services. The licenses granted by AI under this Agreement immediately terminate upon any breach by Utility of this Agreement. Upon termination of a license from AI under this Agreement for any reason, Utility shall immediately cease using the Confidential Information of AI, and Utility shall (i) cease accessing and using the Services, and any access or use of the Services by Utility's Users, subject to the terminated license, (ii) return AI's Confidential Information to Reseller or destroy it, at Reseller's election, and (iii) at AI's request, provide AI and Reseller with certification from a principal officer of Utility's organization that Utility has complied in full with the requirements of this Section. The provisions of this Agreement shall survive any termination of this Agreement or

Page 67 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
any license rights granted to Utility by AI except for those provisions granting from AI to Utility any license or rights in relation to the Services.

13. FEEDBACK. Utility may provide feedback to AI with respect to the Services. Notwithstanding any provision of the Agreement to the contrary, AI may use such feedback for any purpose without obligation of any kind. To the extent a license is required to make use of such feedback, Utility hereby grants to AI an irrevocable, non-exclusive, perpetual, royalty-free, transferrable license, with right to sublicense through multiple levels, to such feedback in connection with AI's business (and the business of its parent, subsidiary, sister, and otherwise affiliated businesses), including without limitation for the enhancement of the Services. Utility represents and warrants that (i) Utility owns or otherwise controls all of the rights in and to the feedback and can grant the license set forth in this Agreement, (ii) Utility has no obligations under law or contract, such as an employment or independent contractor agreement, that would interfere with the rights granted by Utility under this Agreement or would be interfered with by Utility's grant of such rights, and (iii) the feedback Utility supplies is accurate, not misleading, and otherwise in accordance with the terms of this Agreement, and such feedback does not infringe or misappropriate the Intellectual Property of any third party.

14. DISCLAIMER. AI does not assume any responsibility or risk for Utility's use of the Internet. The Content is not necessarily complete and up-to-date and should not be used to replace any written reports, statements, or notices provided by AI or any third party.

ANY WARRANTIES REGARDING THE SERVICES ARE BETWEEN UTILITY AND THE RESELLER, AND NONE ARE GRANTED DIRECTLY TO UTILITY BY AI.

UTILITY'S AND ITS USERS' USE OF THE SERVICES IS AT UTILITY'S AND THOSE USERS' OWN RISK. THE SERVICES AND ITS CONTENT ARE PROVIDED “AS IS” AND WITHOUT WARRANTIES OF ANY KIND, EITHER EXPRESSED OR IMPLIED, FROM AI. AI DISCLAIMS ALL

WARRANTIES, INCLUDING ANY IMPLIED WARRANTIES OF MERCHANTABILITY, FITNESS FOR A

PARTICULAR PURPOSE, TITLE, OR NON-INFRINGEMENT IN RELATION TO THE SERVICES AND THE CONTENT. AI DOES NOT WARRANT THAT THE FUNCTIONS OR CONTENT CONTAINED IN THE

SERVICES WILL BE UNINTERRUPTED OR ERROR-FREE, THAT DEFECTS WILL BE CORRECTED,

OR THAT THE SERVICES OR THE SERVER THAT MAKES THEM AVAILABLE ARE FREE OF VIRUSES OR OTHER HARMFUL COMPONENTS. AI DOES NOT WARRANT OR MAKE ANY REPRESENTATION

REGARDING USE, OR THE RESULT OF USE, OF THE SERVICES OR CONTENT IN TERMS OF ACCURACY, RELIABILITY, OR OTHERWISE. THE CONTENT MAY INCLUDE TECHNICAL

INACCURACIES OR TYPOGRAPHICAL ERRORS, AND AI MAY MAKE CHANGES OR IMPROVEMENTS AT ANY TIME. SOME STATES MAY NOT ALLOW THE DISCLAIMER OF IMPLIED WARRANTIES OR TO SELL A CONSUMER PRODUCT “AS-IS,” SO THIS EXCLUSION MAY NOT APPLY TO UTILITY.

15. LIMITATION ON LIABILITY. TO THE FULLEST EXTENT ALLOWED BY LAW AI AND ITS

RESPECTIVE SUBSIDIARIES, AFFILIATES, LICENSORS, SERVICE PROVIDERS, CONTENT

PROVIDERS, EMPLOYEES, AGENTS, OWNERS, SHAREHOLDERS, MEMBERS, OFFICERS, AND

DIRECTORS, BUT EXCLUDING RESELLER WHOSE LIABILITY SHALL INSTEAD BE GOVERNED BY

UTILITY'S AGREEMENT WITH THE RESELLER, WILL NOT BE LIABLE FOR ANY DIRECT,

INCIDENTAL, INDIRECT, PUNITIVE, ACTUAL, CONSEQUENTIAL, SPECIAL, EXEMPLARY, OR

OTHER DAMAGES, INCLUDING LOSS OF REVENUE, INCOME, PRODUCTION, USE, BUSINESS, OR

PROFIT, OR LOSS OF DATA OR DIMINUTION IN VALUE, OR SIMILAR DAMAGES, EVEN IF AI HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. IN NO EVENT WILL THE

COLLECTIVE LIABILITY OF AI AND ITS RESPECTIVE SUBSIDIARIES, AFFILIATES,

LICENSORS, SERVICE PROVIDERS, CONTENT PROVIDERS, EMPLOYEES, AGENTS, OWNERS,

Page 68 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx

SHAREHOLDERS, MEMBERS, OFFICERS, AND DIRECTORS TO ANY PARTY (REGARDLESS OF THE

FORM OF ACTION, WHETHER IN CONTRACT, TORT, OR OTHERWISE) EXCEED THE GREATER OF $100 OR THE MINIMUM AMOUNT ALLOWED BY LAW. UTILITY EXPRESSLY UNDERSTANDS AND

AGREES THAT ALL OF UTILITY'S RIGHTS AND REMEDIES RELATED TO OR ARISING OUT OF THE SERVICES ARE STRICTLY AND SOLELY BETWEEN UTILITY AND RESELLER. SOME

JURISDICTIONS DO NOT ALLOW THE LIMITATION OR EXCLUSION OF LIABILITY FOR CERTAIN TYPES OF DAMAGES. AS A RESULT, THE ABOVE LIMITATION OR EXCLUSION MAY NOT APPLY TO UTILITY.

16. INDEMNITY. Utility will, to the fullest extent permitted by law, and excluding any claim to the extent due to the gross negligence or intentional acts of AI, indemnify, defend, and hold AI and its respective subsidiaries, affiliates, licensors, content providers, service providers, employees, agents, owners, shareholders, members, officers, directors, and contractors (the “Indemnified Parties”) harmless from: (1) any breach of this Agreement by Utility, including without limitation any use of Services and its Content other than as expressly authorized in this Agreement; (2) any claims brought by third parties arising out of Utility's or its Users' use of the Services, including without limitation any Content or information accessed from the Services; (3) personal injury, wrongful death or damage to tangible personal property caused by the products and/or services promoted, sold or distributed by Utility; (4) defective products promoted, sold or distributed by Utility; or (5) representations or claims made about products or services promoted, sold or distributed by Utility. Utility agrees that the Indemnified Parties will have no liability in connection with any of the above, and Utility agrees to indemnify against any and all resulting loss, damages, judgments, awards, costs, expenses, and attorneys' fees (collectively "Losses") of the Indemnified Parties in connection therewith.

17. TRADEMARKS AND COPYRIGHTS. Trademarks, service marks, logos, and copyrighted works appearing in the Services are the property of AI or the party that provided the trademarks, services marks, logos, and copyrighted works to AI. AI and any party that provided trademarks, service marks, logos, and copyrighted works to AI retain all rights with respect to any of their respective trademarks, service marks, logos, and copyrighted works appearing in the Services. Utility agrees that AI may identify Utility as a client and for such purpose use Utility's name and logo in connection with referencing AI clients in any publication, web site or press release.

18. MISCELLANEOUS. This Agreement, and all claims or causes of action (whether in contract, tort or statute) that may be based upon, arise out of or relate to this Agreement, or the negotiation, execution or performance of this Agreement (including any claim or cause of action based upon, arising out of or related to any representation or warranty made in or in connection with this Agreement or as an inducement to enter into this Agreement), and Utility's use of the Services (collectively a "Dispute"), shall be governed by, and enforced in accordance with, the internal laws of the State of Minnesota, including its statutes of limitation and excluding its conflicts of law rules. Utility's use of the Services may also be subject to other local, state, national, or international laws. Any legal suit, action, or proceeding arising out of or related to this Agreement or the licenses granted hereunder will be instituted exclusively in the federal courts of the United States or the courts of the State of Minnesota in each case located in the city of Minneapolis and County of Hennepin, and each party irrevocably submits to the exclusive jurisdiction of such courts in any such suit, action, or proceeding.

Notwithstanding the foregoing, in lieu of or addition to any other remedies

Page 69 of 69 ends

Utility Billing Software Upgrade - Attachment 2.docx
available to AI, AI may seek injunctive or other relief in any state, federal, or national court of competent jurisdiction for (i) any actual or alleged infringement of AI’s or any third party's intellectual property or proprietary rights; or (ii) any breach of the confidentiality provisions in this agreement.

Utility hereby irrevocably consents to the exclusive jurisdiction and venue of the state and federal courts of the State of Minnesota with respect to any such injunctive or other relief. Utility further acknowledges that AI’s rights in its intellectual property and confidential information are of a special, unique, extraordinary character, giving those rights peculiar value, the unauthorized use, disclosure, or loss of which cannot be readily estimated and may not be adequately compensated for in monetary damages.

If any part of this Agreement is unlawful, void, or unenforceable, that part will be deemed severable, shall be modified by a court of competent jurisdiction or arbitrator to reflect to the maximum extent possible the original intention of the parties as dictated by the original wording, and will not affect the validity and enforceability of any remaining provisions.

This Agreement shall be legally binding upon and inure to the benefit of AI and Utility, and our respective successors and permitted assigns.

If there is any waiver of a breach or failure to enforce any of the provisions contained herein, it shall not be deemed as a future waiver of said terms or a waiver of any other provision of this Agreement.

No amendment to or modification of this Agreement is effective unless it is in writing and signed by an authorized representative of each party.

Utility agrees that no joint venture, partnership, employment, or agency relationship exists between Utility and AI as a result of this agreement or use of AI’s Services.

The section headings appearing in this Agreement are inserted only as a matter of convenience and in no way define, limit, construe or describe the scope or extent of such section or in any way affect such section.

This Agreement constitutes the entire agreement among the parties relating to this subject matter and supersedes all prior or contemporaneous communications and proposals, whether electronic, oral or written between Utility and AI with respect to the Services.

Notwithstanding the foregoing, any additional terms and conditions within the Services will govern the items to which they pertain.

Lakewood City CouncilJune 25, 2024

Lakewood City Council
June 25, 2024