Loading...
HomeMy WebLinkAbout2024.12.03_City Council AgendaPUBLIC NOTICE OF THE MEETING OF THE OWASSO CITY COUNCIL Council Chambers Old Central Building 109 North Birch, Owasso, OK Tuesday, December 3, 2024 - 6:30 PM NOTE: APPROPRIATE ACTION may include, but is not limited to: acknowledging, affirming, amending, ap/nprov-)4,1 r�flzor awarding, denying, postponing, or tabling. O 'ICJ AGENDA �1Y C �,?�?y 1. Call to Order - Mayor Alvin Fruga k s off Ce 2. Invocation - Lead Minister Chad Broaddus of First Church Owasso 3. Flag Salute 4. Roll Call 5. Presentation of the Character Trait of Trustworthiness 6. Consideration and appropriate action relating to the Consent Agenda. (All matters listed under "Consent" are considered by the City Council to be routine and will be enacted by one motion. Any Councilor may, however, remove an item from the Consent Agenda by request. A motion to adopt the Consent Agenda is non -debatable.) A. Approve minutes - November 19, 2024, Regular Meeting B. Approve claims C. Approve a budget amendment in the Healthcare Self -Insurance Fund, increasing the appropriation for expenditures by $50,982.81, following receipt of a stop loss reimbursement D. Accept the Justice Assistance Grant, authorize the execution of the grant contract with the Oklahoma Attorney General's Office, and approve a budget amendment in the Half -Penny Sales Tax Fund (Police) increasing the estimated revenue and the appropriation for expenditures by $9,600.00 E. Declare the 2019 Ford F150 (VIN 1 FTEW 1 E59KKC42419) as surplus to the needs of the City and authorize disposal of the vehicle F. Declare the 2013 Chevrolet Tahoe (VIN 1 GNLC2E03DR156633 as surplus to the needs of the City and authorize disposal of the vehicle G. Declaring the 2016 Dodge Charger (VIN IGNLC2E03DR156633) as surplus to the needs of the City and authorize disposal of the vehicle H. Accept the public infrastructure of a concrete sidewalk along East 96th Street North and North 97th East Avenue, two approaches, potable waterlines, stormwater piping, and a sanitary sewer manhole for Twill at Bailey Creek I. Accept the Fire Station No. 1 and Fire Station No. 2 Renovation Projects and authorize final payment to Limestone Construction, Inc., of Owasso, Oklahoma, in the amount of $92,321.95 7. Consideration and appropriate action relating to items removed from the Consent Agenda 8. Consideration and appropriate action relating to the purchase and implementation of an upgrade to the City's existing Enterprise Resource Planning (ERP) Software Steve Tibbles Staff recommends approval to purchase an upgrade of the City's ERP software in the amount of $387,193.75 with Central Square Technologies, LLC of Lake Mary, Florida, and authorization to execute all necessary documents. Owasso City Council December 3, 2024 Page 2 9. Consideration and appropriate action relating to the purchase of right-of-way for the East 96rh Street North and North 145th East Avenue Intersection Improvement Project Roger Stevens Staff recommends authorization for payment of $1,026,000.00 for the acquisition of right-of-way and compensation for damages located at 9732 North 145th East Avenue with $513,000.00 payable to the Charles W. Helscel Revocable Trust and $513,000.00 payable to the Charlotte Helscel Revocable Trust. 10. Consideration and appropriate action relating to the purchase of right-of-way for the East 96rh Street North and North 145th East Avenue Intersection Improvement Project Roger Stevens Staff recommends authorization for payment of $139,200.00 to Tyann Development Company, LLC for the acquisition of right-of-way and compensation for damages located at the southwest corner of East 96rh Street North and North 145rh East Avenue. 11. Presentation of the monthly Public Works Project Status Report - Roger Stevens 12. Report from City Manager 13. Report from City Attorney 14. Report from City Councilors 15. Official Notices (documents for acknowledgment of receipt or information only, no discussion or action will be taken) • Payroll Payment Report- pay period ending date November 16, 2024 • Change Order 1 executed by the City Manager or designee for the Ranch Creek Interceptor Improvement Project from East 96rh Street North to East 1 l 61h Street North 16. New Business (New Business is any item of business which could not have been foreseen at the time of posting of the agenda) 17. Adjournment Notice of Public Meeting filed in the office of the City Clerk on Friday, December 8, 2023, and the Agenda posted at City Hall, 200 South Main Street, at 2:00 pmm�Wednesday, November 27, 2024. M. Stevens, City The City of Owasso encourages citizen participation. To request M accommodation due to a disability, contact the City Clerk prior to the scheduled meeting by phone 918-376-1502 or by email to istevens@citvofowasso.com OWASSO CITY COUNCIL MINUTES OF REGULAR MEETING TUESDAY, NOVEMBER 19, 2024 The Owasso City Council met in regular session on Tuesday, November 19, 2024, in the Council Chambers at Old Central, 109 North Birch, Owasso, Oklahoma per the Notice of Public Meeting filed Friday, December 8, 2023; and the Agenda filed in the office of the City Clerk and posted at City Hall, 200 South Main Street, at 12:00 pm on Friday, November 15, 2024. 1. Call to Order - Mayor Alvin Fruga called the meeting to order at 6:30 pm. 2. Invocation - Associate Pastor Max Megee of Bible Church of Owasso offered the Invocation. 3. Flag Salute - Deputy Chief Jason Woodruff led the flag salute. 4. Roll Call - A quorum was declared present. Present Absent Mayor- Alvin Fruga Councilor- Paul Loving Vice Mayor- Lyndell Dunn Councilor- Doug Bonebrake Councilor - Cody Walter Staff: City Manager - Chris Garrett / City Attorney - Julie Lombardi 5. Consideration and appropriate action relating to the Consent Agenda. (All matters listed under "Consent" are considered by the City Council to be routine and will be enacted by one motion. Any Councilor may, however, remove an item from the Consent Agenda by request. A motion to adopt the Consent Agenda is non -debatable.) A. Approve minutes - November 5, 2024, and November 12, 2024, Regular Meetings B. Approve claims C. Approve Early Retirement benefits for Timothy Rooney D. Approve and grant a Use Easement at 405 West 2nd Avenue upon the property described as Tract B and upon which the air conditioning units are located, and authorize the Mayor to execute said easement E. Adopting Ordinance 1225, amending the Oklahoma Municipal Retirement Fund Defined Benefit Plan Joinder Agreement, and the Oklahoma Municipal Retirement Fund Master Defined Benefit Plan as approved and required by the Internal Revenue Service Mr. Bonebrake moved, seconded by Mr. Walter, to approve the Consent Agenda as presented, with claims totaling $1,257,460.08. YEA: Bonebrake, Dunn, Walter, Fruga NAY: None Motion carried: 4-0 6. Consideration and appropriate action relating to items removed from the Consent Agenda -None Consideration and appropriate action relating to a final plat for Casey's General Store #4559, a proposed commercial subdivision containing 5.60 acres located at the northeast corner of East 106th Street North and North Garnett Road Alexa Beemer presented the item, recommending approval of the final plat. There were no comments from the audience. After discussion, Mr. Dunn moved, seconded by Mr. Walter, to approve the final plat, as recommended. YEA: Bonebrake, Dunn, Walter, Fruga NAY: None Motion carried: 4-0 Owasso City Council November 19, 2024 Page 2 8. Consideration and appropriate action relating to a Specific Use Permit (SUP) for a proposed automotive repair and maintenance use in a Commercial Shopping (CS) zoning district on approximately 0.92 acres located at 9401 North Garnett Road, as referenced in application SUP 24-03. Alexa Beemer presented the item, recommending approval of the Specific Use Permit. There were no comments from the audience. After discussion, Mr. Bonebrake moved, seconded by Mr. Dunn, to approve the Specific Use Permit, as recommended. YEA: Bonebrake, Dunn, Walter, Fruga NAY: None Motion carried: 4-0 Consideration and appropriate action relating to Ordinance 1226, approving the abandonment of Planned Unit Development OPUD 06-04, creating a new Planned Unit Development for Bailey Village, and rezoning said property from Residential Single Family Low Density (RS-1), Office (0), Agriculture (AG) Residential Multi -Family (RM), and Commercial Shopping (CS) to Residential Single Family High Density (RS-3) for approximately 66.52 acres located south of East 1061h Street North and east of North 97th East Avenue (Mingo Road), as referenced in applications OPUD 24-01 and OZ 24-04 Wendy Kramer presented the item, recommending adoption of Ordinance 1226. Five citizens addressed the City Council. After discussion, Mr. Bonebrake moved, seconded by Mr. Dunn, to adopt Ordinance 1226, as recommended. YEA: Bonebrake, Dunn, Walter, Fruga NAY: None Motion carried: 4-0 10. Consideration and appropriate action relating to bids received for the Owasso Police Department Rifle Range Turning Target System Jason Woodruff presented the item, recommending to award the base bid and alternates # 1 and #2 to Range Systems of New Hope, Minnesota, in the amount of $58,385.00, and authorization to execute all necessary documents. There were no comments from the audience. After discussion, Mr. Bonebrake moved, seconded by Mr. Dunn, to award the bid and authorize execution of documents, as recommended. YEA: Bonebrake, Dunn, Walter, Fruga NAY: None Motion carried: 4-0 11. Consideration and appropriate action relating to bids received for the Centennial Park Playground Project Larry Langford presented the item, recommending to award the bid to Magnum Construction Inc., of Broken Arrow, Oklahoma, in the amount of $397,000.00, and authorization to execute all necessary documents. There were no comments from the audience. After discussion, Mr. Walter moved, seconded by Mr. Dunn, to award the bid and authorize execution of documents, as recommended. YEA: Bonebrake, Dunn, Walter, Fruga NAY: None Motion carried: 4-0 12. Consideration and appropriate action relating to the proposed project sites for the Annual Street Rehabilitation Program (2025) Roger Stevens presented the item, recommending approval of the following 2025 Street Rehabilitation Program priority sites: - Base Projects (Mill/Overlay): Alternate Projects (Preventive Maintenance): • E 116th St N/N Memorial to N Mingo Lakes @ Bailey Ranch • W Broadway, Atlanta to Main St Park Place @ Preston Lakes • 51h Avenue, from Fleet Maintenance to US Hwy • Camelot 169 Service Road • W 1 st St, Atlanta to Main Street • W 2nd St, Atlanta to Main Street • W 3rd St, Atlanta to Main Street Owasso City Council November 19, 2024 Page 3 There were no comments from the audience. After discussion, Mr. Bonebrake moved, seconded by Mr. Walter, to approve the priority sites, as recommended. YEA: Bonebrake, Dunn, Walter, Fruga NAY: None Motion carried: 4-0 13. Consideration and appropriate action relating to the indebtedness of the Owasso Public Works Authority (OPWA) in the Development and Financing Assistance Agreement between Robinson Business Park, LLC, and the Authority for the project known as Robinson Business Park Owasso containing approximately 35 acres located east of the southeast corner of North Mingo Road and East 76rh Street North Carly Novozinsky presented the item, recommending approval of the indebtedness of the OPWA, contingent upon the OPWA's approval of the Development and Financing Agreement with Robinson Business Park, LLC. There were no comments from the audience. After discussion, Mr. Dunn moved, seconded by Mr. Walter, to approve the indebtedness of the OPWA, as recommended. YEA: Bonebrake, Dunn, Walter, Fruga NAY: None Motion carried: 4-0 14. Report from City Manager - Mr. Garrett reported on various community events for November and December and announced the City received the 2024 Green Award from the Green Government Award at the Metropolitan Environmental Trust's 2024 America Recycles Day Celebration. 15. Report from City Attorney -None 16. Report from City Councilors - None 17. Official Notices - The Mayor acknowledged receipt of the following: • Payroll Payment Report - pay period ending date November 2, 2024 • Healthcare Self -Insurance Claims - dated as of October 31, 2024 • Monthly Budget Status Report - October 2024 • Change Order No. 1 executed by the City Manager or designee for the 2024 Annual Street Rehabilitation Project 18. New Business - None 19. Adjournment Mr. Bonebrake moved, seconded by Mr. Walter, to adjourn the meeting. YEA: Bonebrake, Dunn, Walter, Fruga NAY: None Motion carried: 4-0 and the meeting adjourned at 7:48 pm. Alvin Fruga, Mayor Juliann M. Stevens, City Clerk Claims List - 12/03/2024 Fund 01 GENERAL Vendor Name Payable Description Payment Amount CROSSLAND HEAVY CONTRACTORS 116TH - MINGO-GARNETT $23,342.81 116TH-MINGO TO GARNETT RD - Total $23,342.81 JPMORGAN CHASE BANK ALARM BILL -FIRE PANEL $90.00 JPMORGAN CHASE BANK AMAZON -HOT CHOCOLATE $24.47 JPMORGAN CHASE BANK AMAZON -REFUND ($9.88) JPMORGAN CHASE BANK JOHNSTONE-ICE MACHINE $37.56 JPMORGAN CHASE BANK MAVERIK-FUEL $15.00 JPMORGAN CHASE BANK OFFICE DEPOT -PAPER $27.29 JPMORGAN CHASE BANK SAMS-WATER $7.96 BUILDING MAINTENANCE -Total $192.40 JPMORGAN CHASE BANK ATWOOD-FENCE $71.97 JPMORGAN CHASE BANK BROWN FARMS -FENCE $980.00 JPMORGAN CHASE BANK LOWES-FENCE $161.30 JPMORGAN CHASE BANK TRACTOR SUPP-FENCE $80.97 JPMORGAN CHASE BANK TWIN CITIES -CONCRETE $6,024.00 CEMETERY WALL REPLACEMENT - Total $7,318.24 JPMORGAN CHASE BANK AMAZON -SUPPLIES $494.86 JPMORGAN CHASE BANK AMAZON -UNIFORM ($99.90) JPMORGAN CHASE BANK HARBOR FREIGHT-SUPPLI $151.95 JPMORGAN CHASE BANK HOME DEPOT -SUPPLIES $299.88 JPMORGAN CHASE BANK HOMEDEPOT-SUPPLIES $93.83 JPMORGAN CHASE BANK MIDWEST VET -SUPPLIES $332.82 JPMORGAN CHASE BANK TROYTDVM-SERVICE $225.00 JPMORGAN CHASE BANK ZOETIS-SUPPLIES $334.75 RGR SECURITY SOLUTIONS, LLC SECURITY CAMERA SYT $3,504.00 GEN ANIMAL CONTROL - Total $5,337.19 BILLY BASORE OCTOBER DIRT $303.33 JPMORGAN CHASE BANK LOWES-SUPPLIES $21.96 SPOK INC. PAGER USE $79.60 UNIFIRST HOLDINGS LP UNIFORM SERVICES $19.20 GEN CEMETERY - Total $424.09 TEAL DANCE COMPANY LLC TIPPITOES DANCE $456.00 GEN COMM CTR DONATIONS - Total $456.00 JPMORGAN CHASE BANK AMAZON -COFFEE BAR $7.99 JPMORGAN CHASE BANK AMAZON -LATEX GLOVES $59.99 JPMORGAN CHASE BANK AMAZON -MEMBERSHIP $139.00 JPMORGAN CHASE BANK AMAZON -PAINT $174.95 JPMORGAN CHASE BANK AMAZON -SUPPLIES $37.48 JPMORGAN CHASE BANK AMAZON -THERMOSTAT $19.30 JPMORGAN CHASE BANK CINTAS-RUGS $982.90 1 Claims List - 12/03/2024 Fund 01 GENERAL Vendor Name Payable Description Payment Amount JPMORGAN CHASE BANK COX-WIFI $180.00 JPMORGAN CHASE BANK EBAY-REMOTE $6.75 JPMORGAN CHASE BANK HOBBY LOBBY -PAINT $89.07 JPMORGAN CHASE BANK LOCKE-URINAL REPAIR $16.92 JPMORGAN CHASE BANK LODGING EXP 11/07-08 $324.58 JPMORGAN CHASE BANK QUIT BUGGIN-PEST $95.00 JPMORGAN CHASE BANK SAMS-COFFEE BAR $57.96 JPMORGAN CHASE BANK TRAVEL EXP 11/07-08 $13.42 JPMORGAN CHASE BANK WALMART-SUPPLIES $55.76 JPMORGAN CHASE BANK WALMART-TRAINING SUPP $23.88 GEN COMMUNITY CENTER - Total $2,284.95 JPMORGAN CHASE BANK LEE -LEGAL NOTICES $279.84 JPMORGAN CHASE BANK TOMMYS-FLEET $67.97 GEN COMMUNITY DEVELOPMENT - Total $347.81 BG SPECIALTIES INC REDBUD PLAQUE $7,058.00 J & K EQUIPMENT, INC. TREE INSTALL LIFT $749.00 JPMORGAN CHASE BANK ABCO-TAX REFUND ($8.24) JPMORGAN CHASE BANK AMAZON -MEMBERSHIP $14.99 JPMORGAN CHASE BANK AMAZON -SUPPLIES $24.98 JPMORGAN CHASE BANK ART IN BLOOM -DECOR $24.00 JPMORGAN CHASE BANK FACEBOOK-ADVERTISE $27.17 JPMORGAN CHASE BANK SAMS-VET DAY SUPP $58.34 JPMORGAN CHASE BANK WALMART-FRUIT & JUICE $28.92 JPMORGAN CHASE BANK WALMART-SUPPLIES $27.40 GEN CULTURE & RECREATION - Total $8,004.56 JPMORGAN CHASE BANK SAVON-CITY MAPS $275.00 GEN ECONOMIC DEV - Total $275.00 JPMORGAN CHASE BANK COX -CABLE $482.86 JPMORGAN CHASE BANK SUMNER-COPIER $81.95 GEN EMERG PREPAREDNESS - Total $564.81 DLT SOLUTIONS, LLC AUTOCAD SUBSCRIPTION $1,895.84 JPMORGAN CHASE BANK CHAMBER -LUNCHEON $120.00 JPMORGAN CHASE BANK DELL -KEYBOARD $46.24 UNIFIRST HOLDINGS LP UNIFORM SERVICES $41.84 UNITED STATES CELLULAR PW CELL PHONES $90.67 CORPORATION GEN ENGINEERING -Total $2,194.59 BT&CO AUDIT SERVICES $40,000.00 JPMORGAN CHASE BANK CHAMBER -LUNCHEON $240.00 JPMORGAN CHASE BANK OFFICE DEPOT -SUPPLIES $11.52 SUMNERONE INC COPIER SERVICES $57.00 2 Claims List - 12/03/2024 Fund 01 GENERAL Vendor Name Payable Description Payment Amount GEN FINANCE - Total $40,308.52 WALTON PROPERTY SERVICES LLC APPRAISAL 106 & 110 $1,400.00 GEN GENERAL GOVERNMENT -Total $1,400.00 JPMORGAN CHASE BANK GIANT OS-EMPY DEVELOP $856.11 JPMORGAN CHASE BANK JOTFORM-SUBSCRIPTION $408.00 JPMORGAN CHASE BANK MEETING EXP 11/07 $27.50 JPMORGAN CHASE BANK OFFICE DEPOT -NOTEBOOK $32.67 JPMORGAN CHASE BANK SAMS-CHOCOLATE $11.98 GEN HUMAN RESOURCES - Total $1,336.26 AT&T MOBILITY PUBLIC SAFE WIRELESS $83.35 FREEDOM ELECTRICAL SERVICES INC 3 PHASE UPS INSTALL $10,720.00 JPMORGAN CHASE BANK AMAZON -POST RACKS $1,753.31 JPMORGAN CHASE BANK AMAZON -POWER CORDS $319.33 JPMORGAN CHASE BANK AMAZON -REFUND ($42.99) JPMORGAN CHASE BANK BEST BUY -TABLET $169.99 JPMORGAN CHASE BANK EBAY-HOLE LUGS $37.00 JPMORGAN CHASE BANK EBAY-READERS $4,282.00 JPMORGAN CHASE BANK EBAY-REFUND ($853.54) JPMORGAN CHASE BANK EBAY-SWITCHES $400.00 JPMORGAN CHASE BANK HOME DEPOT -CONNECTION $13.93 JPMORGAN CHASE BANK HOME DEPOT -REMOTE $19.97 JPMORGAN CHASE BANK HOME DEPOT -SUPPLIES $333.36 JPMORGAN CHASE BANK HOSTING -SUPPLIES $19.99 JPMORGAN CHASE BANK LOCKE-SUPPLIES $48.35 JPMORGAN CHASE BANK LOWES-CLAMPS $11.08 JPMORGAN CHASE BANK OFFICE DEPOT -LABELS $22.58 JPMORGAN CHASE BANK WALMART-LABELS $6.47 JPMORGAN CHASE BANK WALMART-SUPPLIES $26.91 GEN INFORMATION TECH -Total $17,371.09 JPMORGAN CHASE BANK AMAZON-EMPY APP DECOR $22.95 JPMORGAN CHASE BANK BAILEY RANCH-EMPY REL $44.04 JPMORGAN CHASE BANK L&M-OFFICE FURNITURE $1,380.00 JPMORGAN CHASE BANK MEETING EXP 11/06 $17.60 JPMORGAN CHASE BANK MEETING EXP 11/18 $274.60 JPMORGAN CHASE BANK OTC BRANDS-EMPYAPP $15.60 JPMORGAN CHASE BANK PARTY CITY-EMPY APP $82.67 JPMORGAN CHASE BANK REASORS-CITIES UNITED $28.54 JPMORGAN CHASE BANK SMOKE ON MAIN-EMPY AP $76.80 JPMORGAN CHASE BANK TULSA AIR-EMPY RELAT $173.63 GEN MANAGERIAL - Total $2,116.43 3 Claims List - 12/03/2024 Fund 01 GENERAL Vendor Name Payable Description Payment Amount JPMORGAN CHASE BANK AMAZON -SUPPLIES $26.67 JPMORGAN CHASE BANK CTR-FEES $20.00 SUMNERONE INC COURT COPIER $26.22 GEN MUNICIPAL COURT - Total $72.89 JPMORGAN CHASE BANK ADT-SECURITY $53.45 JPMORGAN CHASE BANK ATWOOD-ZIP TIES $9.49 JPMORGAN CHASE BANK CORE&MAIN-PUMP HOSE $15.00 JPMORGAN CHASE BANK CORNERSTONE -A FREEZE $149.70 JPMORGAN CHASE BANK CORNERSTONE -TAPE $26.58 JPMORGAN CHASE BANK LIBERTY -FLAG SUPP $78.00 JPMORGAN CHASE BANK LIBERTYFLAGS-POLE $1,069.20 JPMORGAN CHASE BANK LOWES-BOLTS & NUTS $1.21 JPMORGAN CHASE BANK LOWES-BROOM HOLDER $11.98 JPMORGAN CHASE BANK LOWES-GFCI $59.48 JPMORGAN CHASE BANK LOWES-GFCI MAIN ST $38.55 JPMORGAN CHASE BANK LOWES-GRABBER $26.96 JPMORGAN CHASE BANK LOWES-HD CAPS $11.52 JPMORGAN CHASE BANK LOWES-LIGHTING $41.80 JPMORGAN CHASE BANK LOWES-SUPPLIES $26.98 JPMORGAN CHASE BANK LOWES-TAPE $9.98 JPMORGAN CHASE BANK LOWES-TIMER $11.98 JPMORGAN CHASE BANK OFFICE DEPOT -BOARD $6.99 JPMORGAN CHASE BANK P&K-SPARK PLUG $8.35 UNIFIRST HOLDINGS LP PARKS STAFF UNIFORMS $30.78 WASHINGTON CO RURAL WATER MCCARTY PARK $37.80 DISTRICT GEN PARKS - Total $1,725.78 TREASURER PETTY CASH NOTARY-SUTTON $10.00 GEN POLICE COMMUNICATIONS - Total $10.00 JPMORGAN CHASE BANK LOWES-TOOLS $20.98 JPMORGAN CHASE BANK STANDARD -SUPPLIES $139.78 SPOK INC. PAGER USE $79.70 UNIFIRST HOLDINGS LP UNIFORM SERVICES $168.94 GEN STORMWATER - Total $409.40 TREASURER PETTY CASH CC DEP REF-ALHJOUJ $100.00 TREASURER PETTY CASH CC DEP REF-CUEVAS $100.00 TREASURER PETTY CASH CC DEP REF -DOZIER $100.00 TREASURER PETTY CASH CC DEP REF-FLANAGAN $50.00 TREASURER PETTY CASH CC DEP REF-HARBISON $100.00 TREASURER PETTY CASH CC DEP REF-JACKSON $50.00 TREASURER PETTY CASH CC DEP REF-WOFFORD $40.00 4 Claims List - 12/03/2024 Fund Vendor Name Payable Description 01 GENERAL GENERAL - Total 20 AMBULANCE SERVICE GENERAL - Total Payment Amount $540.00 $116,032.82 JPMORGAN CHASE BANK AMAZON -CABLE MGMT $82.86 JPMORGAN CHASE BANK AMAZON -EMS BATTERIES $9.99 JPMORGAN CHASE BANK BOUND TREE -REFUND ($171.93) JPMORGAN CHASE BANK BOUND TREE -SUPPLIES $1,438.80 JPMORGAN CHASE BANK CAPITAL WASTE -DISPOSE $339.20 JPMORGAN CHASE BANK ESO-CONERENCE $999.00 JPMORGAN CHASE BANK IAFC-DUES $400.00 JPMORGAN CHASE BANK LENOX-M3 TOW $437.50 JPMORGAN CHASE BANK LIFE ASSIST -SUPPLIES $5,763.20 JPMORGAN CHASE BANK TRAVEL EXP 01/09-14 $773.90 JPMORGAN CHASE BANK TRAVEL EXP 11/13 $26.32 JPMORGAN CHASE BANK UPS -SHIPPING $25.83 JPMORGAN CHASE BANK ZOLL-SUPPLIES $7,216.00 MEDICLAIMS INC BILLING SERVICES $9,340.53 AMBULANCE - Total $26,681.20 JPMORGAN CHASE BANK TWIN CITIES -CONCRETE $450.00 FIRE STAT #1 RENOVATION -Total $450.00 AMBULANCE SERVICE -Total $27,131.20 21 E-911 DEPARTMENT OF PUBLIC SAFETY OLETS ACCESS $851.00 JPMORGAN CHASE BANK AMAZON -SUPPLIES ($24.99) JPMORGAN CHASE BANK APCO-TRAINING $105.00 JPMORGAN CHASE BANK METROPOLIS -PARKING $9.50 E911 COMMUNICATIONS - Total $940.51 E-911 - Total $940.51 25 HOTEL TAX JPMORGAN CHASE BANK MEETING EXP 11/18 $45.97 JPMORGAN CHASE BANK SIMPLE MODERN -REFUND ($119.96) STRONG NEIGHBORHOODS - Total ($73.99) HOTEL TAX - Total ($73.99) 27 STORMWATER MANAGEMENT DIVERSIFIED CIVIL CONTRACTORS LLC GARNETT CULVERT $5,284.56 IMPROVEME GARNETT CULVERT IMPROV -Total $5,284.56 ELLIS CONCRETE CONSTRUCTION LLC HONEY CREEK REHAB $26,600.00 HONEY CREEK CHANNEL REHAB - Total $26,600.00 JPMORGAN CHASE BANK ATWOOD-SUPPLIES $65.97 JPMORGAN CHASE BANK BROWN FARMS -SOD $10.00 JPMORGAN CHASE BANK CHAMBER -LUNCHEON $180.00 JPMORGAN CHASE BANK DRAINNET-GREASE TRAP $430.00 JPMORGAN CHASE BANK LOT 109-PARKING FEE $8.00 5 Claims List - 12/03/2024 Fund Vendor Name Payable Description Payment Amount 27 STORMWATER MANAGEMENT JPMORGAN CHASE BANK YELLOW HOUSE -VEHICLE $18.99 UNIFIRST HOLDINGS LP UNIFORM SERVICES $13.02 UNITED STATES CELLULAR PW CELL PHONES $90.69 CORPORATION STORMWATER - STORMWATER -Total $816.67 STORMWATER MANAGEMENT - Total $32,701.23 28 FEDERAL GRANTS GRADE LINE CONSTRUCTION 96TH - BRIDGE TO 129 $154,282.80 96TH-BRIDGE TO129TH -Total $154,282.80 FEDERAL GRANTS - Total $154,282.80 34 VISION TAX GRADE LINE CONSTRUCTION 96TH - BRIDGE TO 129 $85,294.30 96TH-BRIDGE TO129TH -Total $85,294.30 VISION TAX - Total $85,294.30 37 SALES TAX FIRE JPMORGAN CHASE BANK AMAZON -BATTERIES $71.82 JPMORGAN CHASE BANK AMAZON-FD5 UPFIT $39.99 JPMORGAN CHASE BANK AMAZON -FILTERS $128.47 JPMORGAN CHASE BANK AMAZON -REFUND ($19.89) JPMORGAN CHASE BANK AMAZON -SUPPLIES $103.96 JPMORGAN CHASE BANK AMAZON -TOILET REPAIR $23.49 JPMORGAN CHASE BANK ANALYTICS-CALIBRATION $1,424.00 JPMORGAN CHASE BANK CONRAD FIRE-E2 VALVE $475.80 JPMORGAN CHASE BANK CORE&MAIN-PITOT GAUGE $12.32 JPMORGAN CHASE BANK ESO-CONFERENCE $999.00 JPMORGAN CHASE BANK FIRE PROTECT-ELIBRARY $2,300.00 JPMORGAN CHASE BANK FLIR-TIC STRAPS $177.98 JPMORGAN CHASE BANK FMAO-REFUND ($200.00) JPMORGAN CHASE BANK GIH-SCBA BATTERIES $119.35 JPMORGAN CHASE BANK HITCH N POST -SHIPPING $66.76 JPMORGAN CHASE BANK IAFC-DUES $706.25 JPMORGAN CHASE BANK LODGING EXP10/27-11/1 $615.25 JPMORGAN CHASE BANK LOWES-TRASH BAGS $19.78 JPMORGAN CHASE BANK MR APPLIANCE -WASHER $128.49 JPMORGAN CHASE BANK NAFECO-UNIFORMS $240.00 JPMORGAN CHASE BANK NFPA-FIREMARSHAL BOOK $158.44 JPMORGAN CHASE BANK NSC-CALIBRATION $250.00 JPMORGAN CHASE BANK SAFE KIDS -CAR SEAT $55.00 JPMORGAN CHASE BANK SAMS-STATION SUPPLIES $145.84 JPMORGAN CHASE BANK SAMS-SUPPLIES $490.45 JPMORGAN CHASE BANK SUMNER-COPIER $160.27 JPMORGAN CHASE BANK TIMETOSHINE-FLEET $150.00 JPMORGAN CHASE BANK TRAVEL EXP 10/31 -11 /0 $108.55 JPMORGAN CHASE BANK TTC-BANQUET FEE $600.00 R Claims List - 12/03/2024 Fund Vendor Name Payable Description Payment Amount 37 SALES TAX FIRE JPMORGAN CHASE BANK UPS -UNIFORM BAG $89.47 SALES TAX FUND -FIRE - Total $9,640.84 SALES TAX FIRE - Total $9,640.84 38 SALES TAX POLICE JPMORGAN CHASE BANK APAC-SHOOTING RANGE $6,260.79 JPMORGAN CHASE BANK EQUIP ONE -SHOOT RANGE $165.00 JPMORGAN CHASE BANK TWIN CITIES -CONCRETE $450.00 P.D. MULTI -USE STRUCTURE - Total $6,875.79 AT&T MOBILITY PUBLIC SAFE WIRELESS $141.96 DANA SAFETY SUPPLY, INC SMALL TOOLS $1,820.00 JPMORGAN CHASE BANK AMAZON -DRONE $1,053.46 JPMORGAN CHASE BANK AMAZON -EQUIP REP $190.47 JPMORGAN CHASE BANK AMAZON -REFUND ($59.30) JPMORGAN CHASE BANK AMAZON -SUPPLIES $200.90 JPMORGAN CHASE BANK AMER WASTE -DISPOSAL $148.24 JPMORGAN CHASE BANK B&H-LAPTOPS $613.28 JPMORGAN CHASE BANK DELL -LAPTOPS $4,595.52 JPMORGAN CHASE BANK FAM ANIMAL MED-K9 $172.12 JPMORGAN CHASE BANK GALLS -UNIFORM $236.31 JPMORGAN CHASE BANK GT DIST-TOOLS $931.76 JPMORGAN CHASE BANK HOME DEPOT -LUMBER $31.44 JPMORGAN CHASE BANK JACKERY-REFUND ($169.34) JPMORGAN CHASE BANK JIM GLOVER -VEHICLE $483.76 JPMORGAN CHASE BANK JP ENTER -FIREARMS $590.68 JPMORGAN CHASE BANK LODGING EXP 11/3-5 $189.05 JPMORGAN CHASE BANK LOWES-K9 SUPPLIES $34.98 JPMORGAN CHASE BANK MAKESTICKERS-REFUND ($20.59) JPMORGAN CHASE BANK OFFICE DEPOT -SUPPLIES $44.99 JPMORGAN CHASE BANK OK POLICE -UNIFORM $80.00 JPMORGAN CHASE BANK OREILLY-VEHICLE $320.09 JPMORGAN CHASE BANK PEAVEY -SUPPLIES ($22.50) JPMORGAN CHASE BANK RAY ALLEN-K9 SUPPLIES $186.98 JPMORGAN CHASE BANK ROYAL CANIN-SUPPLIES $1,061.76 JPMORGAN CHASE BANK SPECIAL OPS-UNIFORM $54.99 JPMORGAN CHASE BANK SUMNER-COPIER $963.75 JPMORGAN CHASE BANK THE DEMAND -TRAINING $149.00 JPMORGAN CHASE BANK TRACTOR SUPP-K9 SUPP $1,189.98 JPMORGAN CHASE BANK TRAVEL EXP 11/11-18 $359.26 JPMORGAN CHASE BANK UNIQULEY YOURS -AWARDS $998.33 JPMORGAN CHASE BANK WALMART-AWARDS $10.00 NORTH AMERICA FIRE EQUIPMENT CO. BULLETPROOF VESTS $244.42 SOME'S UNIFORMS INC AWARDS & RECOGNITION $1,641.00 7 Claims List - 12/03/2024 Fund Vendor Name Payable Description Payment Amount 38 SALES TAX POLICE TREASURER PETTY CASH D BROCKUP-EXP REIMB $145.32 TREASURER PETTY CASH NOTARY -BISHOP $25.00 SALES TAX FUND -POLICE - Total $18,637.07 SALES TAX POLICE - Total $25,512.86 39 SALES TAX STREETS BILLY BASORE OCTOBER DIRT $303.33 CAMO FARMS INC ASPHALT $266.25 JPMORGAN CHASE BANK ATWOOD-SUPPLIES $98.94 JPMORGAN CHASE BANK DOLESE-CONCRETE $149.00 JPMORGAN CHASE BANK EQUIP ONE -SUPPLIES $9.99 JPMORGAN CHASE BANK GREENHILL-ASPHALT $225.00 JPMORGAN CHASE BANK HARD HAT -JACKET $43.00 JPMORGAN CHASE BANK LOWES-SUPPLIES $265.98 JPMORGAN CHASE BANK LOWES-TOOLS $489.96 JPMORGAN CHASE BANK SITEONE-SUPPLIES $140.19 JPMORGAN CHASE BANK TRACTOR SUPP-SUPPLIES $49.98 JPMORGAN CHASE BANK TWIN CITIES -CONCRETE $205.85 JPMORGAN CHASE BANK WELSCO-BOTTLE RENTAL $51.50 SPOK INC. PAGER USE $184.20 TULSA COUNTY HIGHWAY SIGNAGE $398.60 CONSTRUCTION UNIFIRST HOLDINGS LP UNIFORM SERVICES $277.60 WASHINGTON CO RURAL WATER 116 LANDSCAPE IRRIG $293.07 DISTRICT SALES TAX FUND -STREETS -Total $3,452.44 SALES TAX STREETS - Total $3,452.44 40 CAPITAL IMPROVEMENTS UNIVERSAL FIELD SERVICES INC ROW ACQUISITION SVCS $8,100.00 CIP 961145TH INTERSECT -Total $8,100.00 JPMORGAN CHASE BANK TINT SHOP -VEHICLE $400.00 CIP POLICE VEHICLES - Total $400.00 MTC TULSA LLC PW FACILITY $212,420.24 PUBLIC WORKS FACILITY -Total $212,420.24 GRADE LINE CONSTRUCTION STREET REHAB FY23-24 $81,775.05 STREET REHAB FY23-24 - Total $81,775.05 CAPITAL IMPROVEMENTS - Total $302,695.29 70 CITY GARAGE JPMORGAN CHASE BANK A&N-PARTS $252.35 JPMORGAN CHASE BANK AMAZON -MONITOR STAND $65.69 JPMORGAN CHASE BANK AMAZON -PHONE CORDS $17.50 JPMORGAN CHASE BANK AMAZON -REFUND ($15.38) JPMORGAN CHASE BANK B&H-LAPTOP CHARGERS $1,756.56 JPMORGAN CHASE BANK B&H-PC RAM $109.99 JPMORGAN CHASE BANK BEST CHOICE -GLASS REP $525.00 H Claims List - 12/03/2024 Fund Vendor Name Payable Description 70 CITY GARAGE JPMORGAN CHASE BANK JPMORGAN CHASE BANK JPMORGAN CHASE BANK JPMORGAN CHASE BANK JPMORGAN CHASE BANK JPMORGAN CHASE BANK JPMORGAN CHASE BANK JPMORGAN CHASE BANK JPMORGAN CHASE BANK VEHICLE MAINTENANCE - Total Payment Amount DELL -PC $888.25 DELL -PC MONITOR $151.97 EAGLE WINDOW -SERVICES $125.00 HESSELBEI N-PARTS $1,675.58 JACK KISSEE-SERVICES $753.49 ROCK AUTO -PARTS $398.34 SOUTHERN TIRE -REFUND ($1,620.36) STANDARD -PARTS $9.56 TEREX-PARTS $215.28 CITY GARAGE - Total 76 WORKERS' COMP SELF -INS CITY OF OWASSO IMPREST ACCOUNT WORKERS COMP CLAIMS WORKERS' COMP SELF -INS -Total WORKERS' COMP SELF -INS -Total 77 GENERAL LIABILITY-PROPERT DOERNER, SAUNDERS, DANIEL & HALL, ESTILL, HARDWICK, GABLE, GEN LIAB-PROP SELF INS -Total GENERAL LIABILITY-PROPERT - Total $5,308.82 $5,308.82 $3,502.90 $3, 502.90 $3, 502.90 LITIGATION $588.98 LITIGATION $577.50 $1,166.48 $1,166.48 City Grand Total $767,588.50 60] Sd TO: The Honorable Mayor and City Council FROM: Michele Dempster, Senior Director SUBJECT: Healthcare Self -Insurance Fund Stop Loss Reimbursements DATE: November 22, 2024 BACKGROUND: In 2004, the City Council approved a policy establishing the Healthcare Self -Insurance Fund for employee health, dental, and vision insurance. This fund covers the cost of claims and administrative fees associated with health, dental, and vision coverage, with funding provided by premiums paid by employees and departments. Self-insurance means that, instead of paying premiums to an external insurance company, the City pays claims directly through a third -party administrator. This approach enables the City to retain any unspent budgeted funds. To manage risk, the City carries Stop Loss coverage, which limits liability for any single individual. If a claim exceeds the Stop Loss limit, the excess costs are covered by the Stop Loss carrier. Effective July 1, 2024, the City transitioned its Stop Loss coverage from AETNA to Sun Life, resulting in $400,000 in premium savings. With this transition, the City is required to pay the full amount of all claims upfront, with reimbursement for claims that exceed the Stop Loss limit. These reimbursements are credited to the Healthcare Self -Insurance Fund as revenue. A budget amendment is required to account for the increased expenditures associated with claims that surpass the Stop Loss threshold. STOP LOSS REIMBURSEMENT RECEIVED: The City has received a Stop Loss reimbursement of $50,982.81. This amount has been credited to the "reimbursements and refunds" line item in the Healthcare Self -Insurance Fund. A budget amendment is required to allocate these funds for future claims expenditures. RECOMMENDATION: Staff recommends approval of a budget amendment in the Healthcare Self -Insurance Fund, increasing the appropriation for expenditures by $50,982.81. TO: The Honorable Mayor and City Council FROM: Jason Woodruff, Deputy Chief of Police SUBJECT: Acceptance of Justice Assistance Grant and a Budget Amendment DATE: November 22, 2024 BACKGROUND: The Edward Byrne Memorial Justice Assistance Grant (JAG) is administered by the Oklahoma District Attorney's Council using federal funding from the U.S. Department of Justice, and is aimed at reducing or preventing violent crime. The grant was named in honor of New York City Police Officer Edward Byrne, who was tragically shot and killed in the line of duty in 1988. City, county, and state law enforcement agencies can apply for a portion of the JAG funds through the competitive grant process. The Owasso Police Department was previously awarded funding under the JAG grant in 2014, 2015, 2016, 2017, 2021, 2022, 2023. In September 2024, the Owasso Police Department submitted an application for the Justice Assistance Grant. On November 20, 2024, the department received notification that grant funds have been approved in the amount of $9,600.00. The reimbursement -based grant funds are specified for the purchase of three (3) laptop computers to be used as Mobile Data Terminals in patrol vehicles. RECOMMENDATION: Staff recommends acceptance of the Justice Assistance Grant, authorization for the City Manager to sign the grant contract with the Oklahoma Attorney General's Office, and approval of a budget amendment in the Half -Penny Sales Tax Fund (Police) increasing the estimated revenue and the appropriation for expenditures by $9,600.00. sd TO: The Honorable Mayor and City Council FROM: Nathan Singleterry, Desktop Support Technician SUBJECT: Surplus Vehicles and Authorize Auction DATE: November 22, 2024 BACKGROUND: The City of Owasso declares items surplus that have reached their end of life or are no longer useful. An estimated value of $500.00 or more for the individual items requires City Council approval for disposal. For several years, the City has utilized auction sites to auction surplus vehicles and equipment. These sites act as an "auction broker." Both private individuals and public entities utilize these online auctions as a tool to obtain the highest resale or salvageable price for items they can no longer utilize. Prior to utilizing online auctions, City staff collected and processed surplus items, then conducted an onsite auction. This process took significant time and required many staff resources with very little return. The onsite auctions were typically not well attended and items were sold for far less than the City has received via online auction sites. :rg1LYi1[*03 There are fees to sell on most, though not all, auction sites. For some sites, there may be a set fee, and for others, there may be a percentage of the total sale price. Staff evaluates the items to be sold to determine the best online option for auctioning. The following is the step-by-step process for online auctions followed by the City of Owasso: • City Council declares vehicles or other items, valued over $500.00, as surplus; • Digital pictures are taken and descriptions written for each item to be auctioned • Staff determines the length of auction; • Staff includes acceptable methods of payment; • Staff determines whether items can be shipped or would need to be picked up by the purchaser/buyer. Most often, items are picked up at City locations; • The auction is promoted through social media and the City's website; • At the end of the auction the highest bidder is notified, and arrangements are made for shipping or pick-up of item once payment is received. ITEM REQUESTED TO BE DECLARED SURPLUS: A 2019 Ford F150 has been deemed as mechanically totaled. RECOMMENDATION: Staff recommends declaring the 2019 Ford F150 VIN: 1 FTEW 1 E59KKC42419 as surplus to the needs of the City and approving disposal of the vehicle via online auction. ATTACHMENT: Vehicle Inspection Form Vehicle Inspection Form Inventory ID: I Asset Number: Fair Market Value: Short Description: Year 2019 Make Ford Model F-150 XL 4WD SuperCrew 5.5' Box VIN: 1 FTEW 1 E59KKC42419 Title: []✓ Clean Title [] Salvage Title [] No Title []Court Documents Only [] SF97 Form [] Other Odometer: 59538.2 nV Miles ❑Kilometers ❑Hours Odometer Accurate? Z Yes 0 No Unknown Long Description: This Vehicle: ❑✓ Starts []Starts with a Boost & Z Runs/Drivable [] Engine Runs [] Does Not Run []For Parts Only Engine- Type: 5_0 L, V 8 Z Gas [] Diesel Engine Z Propane/Natural Gas []Gas/Electric Hybrid Engine Condition: ❑✓ Rmrs []Needs repair []is in unknown condition Repairs needed: Engine consumes oil (multiple quarts per week during normal use) This vehicle was maintained every ❑Days []Hours ❑Miles/Kilometers Date Removed from Service: 11/20/2024 Maintenance Records: []Available []Not Available For Inspection Manual _Speed Condition: UOperable UNeeds repair UIs Unknown Condition Repairs Needed: Drivetrain: [] 2 Wheel Drive Z 4 Wheel Drive Condition: Exterior: Color: White Minor:[]Dents []Scratches []✓ Dings Major Damage to: _ Additional Damage: Decals: [] None I Windows: ❑✓ No Cracked Glass [] Cracked Tire Condition: Good Tread: #Flat Hubcaps # Have Been Sprayed or Z Have been Removed & []✓ Impressions Remain [] No impressions None [] Has been removed & []✓ There are holes in the exterior RThere are no holes Interior: Color Gray []Cloth []✓ Vinyl ❑Leather Damage to Seats: Has seat covers, but may have some minor damaqe Damage to Dash/Floor: Very dirty, but appears to be ok for a work truck Radio: []✓ Stock or []Brand & Model: I —LAM []AM/FM []AM/FM Cassette[]AM/FMCD AC Condition: []Cold []Unknown []No AC Air Bags: []Driver's Side []Dual []Cruise Control []Tilt Steering []Remote Mirrors []Climate Control Power: []Steering []✓ Windows []✓ Door Locks []Seats Additional Equipment: Running boards, bed tool box, light bar (disabled) Manufacturer Mode. []Tool Box []Light Bar[] Ladder Rack Location of Asset: Serial # []Utility Body: Brand []Hitch: Type CNG & Gasoline. Tanks under bed. •apes 9'r _::� "T+ a71-��� �— �* I � s^� . r, '� TO: The Honorable Mayor and City Council FROM: Jason Woodruff, Deputy Chief of Police SUBJECT: Surplus Vehicles and Authorize Donation DATE: November 29, 2024 BACKGROUND: The City of Owasso declares items surplus that have reached the end of their life, or when they are no longer useful. If the item has an estimated value that exceeds $500.00, the item requires City Council approval for disposal. Because of the rigorous demands placed on patrol vehicles during daily use and the safety needs present during emergency response and pursuit driving, the Owasso Police Department (OPD) removes vehicles from active service when they reach seven (7) years of age, become unserviceable/damaged beyond repair, and/or reach 100,000 miles. After being removed from active service, these vehicles are sometimes used for pool vehicles or training, eventually being declared surplus and sold at auction when the vehicles are no longer needed. There are fees associated with the auctioning of items as well as labor costs associated with removing the emergency equipment from the vehicles prior to civilian sale. Surplus vehicles often sell at auction for far less than their estimated retail or trade-in value. OPD currently has two (2) decommissioned patrol vehicles deemed no longer needed to remain in service due to their age and condition. The vehicles are slated to be declared surplus/disposal, but they could still be of use for duties other than traditional street patrol. Instead of auctioning these vehicles, staff is seeking to donate them to other area agencies who have expressed a need_ Unit 13-4 is a 2013 Chevrolet Tahoe (VIN 1GNLC2E03DR156633) with 113,000 miles and an estimated value of $6,950. Spiro Public Schools has expressed interest in this vehicle for use as a School Resource Officer vehicle. Unit 16-4 is a 2016 Dodge Charger (VIN 1 GNLC2E03DR 156633) with 94,500 miles and an estimated value of $8,975.00. The Central Technology Center, Sapulpa Campus, has expressed interest in this vehicle for use in their law enforcement training program. Central Tech is accredited through the Oklahoma Council on Law Enforcement Education and Training to provide basic peace officer certification for recruits seeking a career as a police officer. In exchange for the proposed vehicle donation, Central Tech has offered to train two (2) future Owasso Police Department recruits free of charge, a value of $7,000.00. RECOMMENDATION: Staff recommends declaring the 2013 Chevrolet Tahoe (VIN 1 GNLC2E03DR156633) and the 2016 Dodge Charger (VIN 1GNLC2E03DR156633) as surplus to the needs of the City of Owasso and authorizing disposal of the vehicles. ATTACHMENT: Vehicle Value Estimates Monday, November 4, 2024 Trade In/Retail Breakdown J.D. Power Publication 11/2024, Region: Southwestern 2013 CHEVROLET TRUCKS Tahoe Utility 4D Police 5.3L V8.................................... $6,950 / $9,500 VIN: 1 GNLC2E03DR156633 MSRP..................................................................................................... 34350 Weight.................................................................................... .................. 5342 *** Itemized Add/Deducts *** Towing/Camper Pkg.......................................................... Condition................................................................ Total Value without mileage .................................. Mileage adjustment (113782) miles ....................... *** J.D. Power Trade In/Retail $9,825 / $12,400 ..... 200 / 225 ............ I............ Clean .......... $7,150 / $9,725 1....................... $2,675 Jim Glover Dodge Chrysler Jeep Ram Fiat - ADAM CLINKENBEARD J.D. Power publication for Oklahoma: Publication t 1/2024, Region: Southwestern Values are subjective opinions. J.D. Power and vAuto, Inc. assume no responsibility for errors or omissions. Q vAuto, Inc. 2024, all rights reserved. Trade In/Retail Breakdown J.D. Power Publication 11/2024, Region: Southwestern 2016 DODGE Charger Sedan 4D Police 5.71, V8......................................... VIN: 2C3CDXAT4GH165448 MSRP....................................... .... ......................... I ... ............... Weight..... ........ ......................................................................... *** Itemized Add/Deducts *** Monday, November 4, 2024 $9,975 / $11,350 ........ 33800 .......... 4321 FogLights.................................................................................................... Included Condition................................................................................................. Clean Total Value without mileage ................................................. $8,975 / $11,350 Mileage adjustment (96584) miles ........................................................ $1,275 #** T.D. Power Trade In/Retail $10,250 / $12,625 Jim Glover Dodge Chrysler Jeep Ram Fiat - ADAM CLINKENBEARD J.D. Power publication for Oklahoma: Publication 1112024, Region: Southwestern Values are subjective opinions. J.D. Power and vAuto, Inc. assume no responsibility for errors or omissions. 0 vAuto, Inc. 2024, all rights reserved. TO: The Honorable Mayor and City Council FROM: Earl Farris, Project Administrator SUBJECT: Acceptance of Infrastructure Improvements at Twill at Bailey Creek DATE: November 22, 2024 Sm;LHI all mll The subject residential development is located on the northeast corner of East 96th Street North and North 971h East Avenue. The residential development has two entrances, one off of North 97Th East Avenue and one off of East 96th Street North. Infrastructure improvements include a concrete sidewalk that runs along East 96th Street North and along North 97th East Avenue, two approaches, potable water, stormwater piping, and one public manhole for sanitary sewer. All roads and sidewalks inside the development are private. FINAL INSPECTIONS: Final inspections for all infrastructure components were completed in November 2024 by the Public Works Department. All standards for acceptance have been met. Additionally, the construction contractor and design engineer have supplied the necessary two-year maintenance bonds and required as -built drawings. RECOMMENDATION: Staff recommends acceptance of public infrastructure improvements located at Twill at Bailey Creek. ATTACHMENTS: Location Map City Attorney Approved Bonds Twill At Bailey Creek 1„ = t 63 ft Location Map 09/19/2024 (a Aui rmm.ne��.r+.,.n This map may represents a visual display of related geographic information. Data provided hereon is not guarantee of actual field conditions. 7o be sure of complete accuracy, please contact the responsible staff for most up-to-date information. Farris, Earl From: Wingert Shellie Sent: Monday, March 25, 2024 11:16 AM To: Eaton, Steven Cc: Lombardi, Julie; Farris, Earl Subject: RE: Twill at Bailey Creek Hello Steven, I have reviewed the Twill at Bailey Creek maintenance bond at your request. The attorney - in -fact signature is authorized, the surety is licensed to do business in Oklahoma, and the amount of the bond is well within the surety's $3,116,000.00 underwriting limitation. Therefore, the bond is approved. Thank you, Shellie Shellie Wingert Executive Assistant Office of the City Manager and City Attorney City of Owasso 200 S. Main St. Owasso, OK 74055 S AnaertacitVofowasso.com WK:918-376-1548 Cell:918-845-0465 From: Eaton, Steven <seaton@CityOfOwasso.com> Sent: Monday, March 25, 2024 11:02 AM To: Wingert Shellie <swingert@cityofowasso.com> Cc: Lombardi, Julie <JLombardi@CityOfOwasso.com>; Farris, Earl <efarris@CityOfOwasso.com> Subject: Twill at Bailey Creek Shellie, I am sending a maintenance bond for review. Would you please reply with your findings. Thank you, Steven Eaton City of Owasso Infrastructure Inspector seaton(a citvofowasso.com Phone 918-272-4959 MERCHANTS BONDING COMPANY MERCHANTS NATIONAL BONDING, INC. P.O. BOX 14498. DES MOINES. IA 50306-3498 PHONE: (800) 678-8171 FAX: (515) 243-3854 MAINTENANCE BOND KNOW ALL PERSONS BY THESE PRESENTS: Bond No. 100212632 That Barnes Construction Solutions Inc. as Principal, at held and firmly Tulsa, OK t Inc. as Surety are In the penal sum DOLLARS, lawful money of the United States of America, for the payment of which, well and truly to oe made, the Principal and Surety bind themselves, their and each of their heirs, executors, administrators, successors and assigns, jointly and severally, firmly by these presents. Signed and delivered this 7t11 day of September 2023 WHEREAS, the Principal entered into a certain contract, dated the with the day of Seive Twiloll Bs att eyeriarecVrid labor necessary for the construction of Sidewalk, Street, and Driveways to in conformity with certain specifications; and WHEREAS, a further condition of said contract is that the Principal should furnish a band of indemnity, guaranteeing to remedy any defects in workmanship or materials that may develop in said work within a period of Two years from the date of acceptance of the work under said contract; and WHEREAS, the above work has been completed and accepted and if not accepted will be automatically accepted upon the filing of this maintenance bond; and WHEREAS, the Merchants National Bonding. Inc. for valuable consideration, has agreed to join with said Principal in such bond or guarantee, indemnifying said City of Owasso as aforesaid; NOW, THEREFORE, THE CONDITION OF THIS OBLIGATION IS SUCH, that If the said Principal does and shall, at the Principal's own cost and expense, remedy any and all defects that may develop in said work, within the period of Two years from the dale of acceptance of the work under said contract, by reason of bad workmanship or poor material used in the construction of said work, and shall keep all work in continuous good repair during said period, and shall in all other respects, comply with all the terms and conditions of said contract with respect to maintenance and repair of said work, then this obligation to be null and void; otherwise to be and remain in full force and virtue in law. It is agreed that while the Principal shall be and remain liable for failure to adhere to the specifications which form the basis for the work, the Surety, inasmuch as the original work was not bonded, shall be obligated only to assure the maintenance of the work in the condition In which It existed at the time the work was accepted. Any obligation beyond this shall be that of only the Principal. Approved By CON 0304 (2l15) Barnes Construction Solutions Inc. Principal By Merchants National Bonding, Inc. r�aPt�P•ogf p:, e: bR Rq•o 13 .,.: u F••.25 Ze= —o- oie s; som ea y Dayna Harjo Attomcy-ut-Fact `'�ddW •..... _•���•' MERCHANTS BONDING COMPANYv. POWER OF ATTORNEY Know All Persons By These Presents, that MERCHANTS BONDING COMPANY (MUTUAL) and MERCHANTS NATIONAL BONDING, INC., both being corporations of the State of Iowa, d/b/a Merchants National Indemnity Company (in California only) (herein collectively called the "Companies") do hereby make, constitute and appoint, individually, Dayua R Harjo their true and lawful Atlarney(s)-in-Fact, to sign its name as surety(ies) and to execute, seal and acknowledge any and all bonds, undertakings, contracts and other written instruments in the nature thereof, on behalf of the Companies in (heir business of guaranteeing the fidelity of persons, guaranteeing the performance of contracts and executing or guaranteeing bonds and undertakings required or permitted in any actions or proceedings allowed by law. This Power -of -Attorney is granted and is signed and sealed by facsimile under and by authority of the following By -Laws adopted by the Board of Directors of Merchants Bonding Company (Mutual) on April 23, 2011 and amended August 14, 2015 and adopted by the Board of Directors of Merchants National Bonding, Inc., on October 16. 2015. "The President, Secretary, Treasurer, or any Assistant Treasurer or any Assistant Secretary or any Vice President shall have power and authority to appoint Attorneys -in -Fact, and to authorize them to execute on behalf of the Company, and attach the seal of the Company thereto, bonds and undertakings, recognizances, contracts of indemnity and other writings obligatory in the nature thereof." "The signature of any authorized officer and the seal of the Company may be affixed by facsimile or electronic transmission to any Power of Attorney or Certification thereof authorizing the execution and delivery of any bond, undertaking, recognizance, or other suretyship obligations of the Company, and such signature and seal when so used shall have the same force and effect as though manually fixed." In connection with obligations in favor of The Florida Department of Transportation only. it is agreed that the power and aut horny hereby given to the Attorney -in -Fact includes any and all consents for the release of retained percentages and/or final estimates on engineering and construction contracts required by the Slate of Florida Department of Transportation. it is fully understood that consenting to the Slate of Florida Department of Transportation making payment of the final estimate to the Contractor and/or its assignee, shall not relieve this surely company of any of its obligations under its bond. In connection with obligations in favor of the Kentucky Department of Highways only, it Is agreed that the power and authority hereby given to the Attorney -in -Fact cannot be modified or revoked unless prior written personal notice of such intent has been given to the Commissioner - Department of Highways of the Commonwealth of Kentucky at least thirty (30) days prior to the modification or revocation. In Wilness Whereof, the Companies have caused this instrument to be signed and sealed this 71h day of September 2023 . -'j lvMERCHANTS BONDING COMPANY (MUTUAL) ............. B0•. .•00?Ot1P09A -f MERCHANTS NATIONAL BONDING, INC. 4 O,:y • y• 4 d/b/a MERCHANTS NATIONAL INDEMNITY COMPANY :y`• 2003 1933 e -';t��•-..*....��1�.' •y`26d�.•�. ••'\1J.'• y President STATE OF IOWA •• '••' COUNTY OF DALLAS ss. On this 7th day of September 2023 , before me appeared Larry Taylor, to me personally known, who being by me duly sworn did say that he is President of MERCHANTS BONDING COMPANY (MUTUAL) and MERCHANTS NATIONAL BONDING, INC.; and that the seals affixed to the foregoing Instrument are the Corporate Seals of the Companies; and that the said instrument was signed and sealed in behalf of the Companies by authority of their respective Boards of Directors. IGm Lee Cosnn+s ioeiPkurdberTfJ2T37 NlycocolusimEjores ktar'y)P.blic (Expiration of no(ary's commission does not invalidate this instrument) 1, William Warner, Jr., Secretary of MERCHANTS BONDING COMPANY (MUTUAL) and MERCHANTS NATIONAL BONDING, INC., do hereby certify that the above and foregoing is a true and correct copy of the POWER -OF -ATTORNEY executed by said Companies, which is still in full force and effect and has not been amended or revoked. In Witness Whereof, I have hereunto set my hand and affixed the seal of the Companies on this 701 day of September . 2023. RPoRyr�Oy: 2003 1933 Vic; secretary -'pry A �•Y POA 0018 (10122) Farris, Earl From: Nathan Garrett <nathan@tulsapropertygroup.com> Sent: Tuesday, October 8, 2024 8:40 AM To: Farris, Earl Subject: RE: Breakdown needed CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe. Good morning Earl, l We have received the following breakdown from Cowen / Cherokee: g 0 o v f rig Ncre- • Public Storm - $131,000 • Public Water - $220,080 • Public Sanitary - $300,000 I apologize for the delay. As you might imagine, it's been difficult to get any information from Cherokee. Best Regards, Nathan Garrett Managing Principal rrz' t' TULSA PROPERTY GROUP . naihom��ul:_anmpnn:ernuc_rnm v.a_•.dul_aerin+rtvitnun.p_m From: Farris, Earl <efarris@CityofOwasso.com> Sent: Thursday, September 19, 20241:25 PM To: Nathan Garrett <nathan@tulsaprope rtygroup.com> Subject: Breakdown needed Mr. Garrett, could you please ask Cherokee to supply a breakdown of the cost for the three items on this bond. It should equal the total of the bond. I need this as it is added to the assert list for finance. It can be an email. From: Wingert Shellie To: Eaton Steven; Lombardi. Julie Cc: Farris, Ead Subject: RE: Twill Bailey Creek Date: Thursday, June 27, 2024 7:23:49 AM Steven, I have reviewed the Twill Bailey Creek subdivision Public Storm Sewer, Public Water Main, and Public Sanitary Sewer maintenance bond at your request. The attorney -in -fact signature is authorized, the surety is licensed to do business in Oklahoma, and the amount of the bond is well within the surety's $63,567,000.00 underwriting limitation. Therefore, the bond is approved Thank you, Shellie From: Eaton, Steven <seaton@CityOfowasso.com> Sent: Wednesday, June 26, 2024 5:23 PM To: Lombardi, Julie <JLombardi@CityOfOwasso.com> Cc: Wingert Shellie <swingert@cityofowasso.com>; Farris, Earl <efarris@CityOfOwasso.com> Subject: Twill Bailey Creek Ms. Lombardi, I am sending a maintenance bond for review. Would you please reply with your findings. Thank you, Steven Eaton City of Owasso Infrastructure Inspector seatonra citvofowasso.com Phone 918-272-4959 Cell 918-693-3979 DUPLICATE ORIGINAL Maintenance Bond PRIVATELY FINANCED PUBLIC IMPROVEMENTS Bond No. 0844254 KNOW ALL MEN BY THESE PRESENTS, That we Cherokee Builders, Inc. as Principal (Developer and Contractor), and Harco National Insurance Company as Surety, are held and firmly bound unto the City of Owasso, as Obligee, in the penal sum of Six Hundred Fifty-one Thousand Eighty B 00/100 ($ 651,080.00 ) which payment will and truly to be made, we do bind ourselves, and each of our heirs, executors, administrators, successors, and assigns jointly and severally, firmly by these presents. WHEREAS, the Principal will furnish a bond conditioned to guarantee, for the period of year(s) after final approval of the Pi Phlic torn SnWar P hiir wafer Main and PiAhur sanitary Sewer to serve The Twill Bailey Creek subdivision a privately financed public improvement, and acceptance of such by the City Council of the City of Owasso, against all defects in workmanship and materials which may become apparent in such privately financed public improvement during said period. NOW, THEREFORE, THE CONDITION OF THIS OBLIGATIONS IS SUCH that the Principal and/or Surety shall indemnifythe Obligee for all loss that the Obligee maysustain by reason of any defective materials or workmanship in the privately financed public improvement which may become apparent during the said period. SIGNED, SEALED, AND DATED: September 14, 2023 Cherokee Builders, Inc.aPrincipal (1 BY: ! e�N 0 l Har o klational Insurance Com an . Surety Astin! t BY: Attorney -in -Fact ais ` Attach Power of Attorney POWER OF ATTORNEY Bond If 0844254 HARCO NATIONAL INSURANCE COMPANY INTERNATIONAL FIDELITY INSURANCE COMPANY Member companies of [AT Insurance Group, Headquartered: 4200 Six Forks Rd, Suite 1400, Raleigh, NC 27609 KNOW ALL MEN BY THESE PRESENTS: That HARCO NATIONAL INSURANCE COMPANY, a corporation organized and existing under the laws of the State of Illinois, and INTERNATIONAL FIDELITY INSURANCE COMPANY, a corporation organized and existing under the laws of the State of New Jersey, and having their principal offices located respectively in the cities of Rolling Meadows, Illinois and Newark, New Jersey, do hereby constitute and appoint VAUGHN GRAHAM, JR. VAUGHN P. GRAHAM, CAREY KENNEMER, SHELL) R. SAMSEL. TOM PERRAULT. SECKY KILLMAN, KRISTIN LEWIS. FAITH BURLESON, STEPHEN M. POLEMAN, VICKI WILSON, TRAVIS E. BROWN, DWI CHT A PILGRIM, J. KELLY DEER, DEBORAH L RAPER. AUSTIN K. GREENHAW, JAMIE M. BURRIS, RYAN MATTHEW SANDERS, JOSHUA BRYAN Tulsa, OK their true and lawful attomey(s}in-fact to execute, seal and deliver for and on Its behalf as surety, any and all bonds and undertakings, contracts of Indemnity and other wdfings obligatory in the nature thereof, which are or may be allowed, required or permitted by law, statute, rule, regulation, contract or otherwise, and the execution of such insbument(s) in pursuance of these presents, shall be as binding upon the said HARCO NATIONAL INSURANCE COMPANY and INTERNATIONAL FIDELITY INSURANCE COMPANY, as fully and amply, to all intents and purposes, as if the same had been duly executed and acknowledged by their regularly elected officers at their principal offices. This Power ofAttomey is executed, and may be revoked, pursuant to and by authority of the By -Laws of HARCO NATIONAL INSURANCE COMPANY and INTERNATIONAL FIDELITY INSURANCE COMPANY and is granted under and by authority of the following resolution adopted by the Board of Directors of INTERNATIONAL FIDELITY INSURANCE COMPANY at a meeting duly held on the 13th day of December, 2018 and by the Board of Directors of HARCO NATIONAL INSURANCE COMPANY at a meeting held on the 13th day of December, 2016. "RESOLVED, that (1) the Chief Executive Officer, President Executive Vice President, Senior Vice President, Vice President, or Secretary of the Corporation shall have the power to appoint, and to revoke the appointments of, Allomaysdn-Fact or agents with power and authority as defined or limited in their respective powers of attorney, and to execute on behalf of the Corporation and affix the Corporation's seal thereto, bonds, undertakings. recognizances, contracts of Indemnity and other written obligations in the nature thereof or related thereto: and (2) any such Officers of the Corporation may appoint and revoke the appointments of joint -control custodians, agents for acceptance of process, and Attorneys -in -fact with authority to execute waivers and consents on behalf of the Corporation; and (3) the signature of any such Officer of the Corporation and the Corporation's seal may be affixed by facsfmfie to any power of attorney or certification given for the execution of any bond, undertaking, recognizance, contract of Indemnity or other written obligation in the nature thereof or related thereto, such signature and seals when so used whether heretofore or hereafter, being hereby adopted by the Corporation as the original signature of such officer and the original seal of the Corporation, to be valid and binding upon the Corporation with the same force and effect as though manually affixed." IN WITNESS WHEREOF. HARCO NATIONAL INSURANCE COMPANY and INTERNATIONAL FIDELITY INSURANCE COMPANY have each executed and attested these presents on this 31st day of December. 2022 "ONSuq'', CD STATE OF NEW JERSEY STATE OF ILLINOISoeo yr cCounty of Essex County of Cook = �? oFSEAL •'o: 1024 Kenneth Chapman �'y""x t• Executive Vice President, Harco National Insurance Company and International Fidelity Insurance Company On this 31st day of December, 2022 , before me came the individual who executed the preceding instrument, to me personally known, and, being by me duly swom, said he is the therein described and authorized officer of HARCO NATIONAL INSURANCE COMPANY and INTERNATIONAL FIDELITY INSURANCE COMPANY; that the seals affixed to said instrument are the Corporate Seals of said Companies; that the said Corporate Seals and his signature were duly affixed by order of the Boards of Directors of said Companies. IN TESTIMONY WHEREOF, I have hereunto set my hand affixed my Official Seal, at the City of Newark, New Jersey the day and year first above written. Cathy Cruz a Notary Public of New Jersey CERTIFICATION My Commission Expires April 16, 2024 I, the undersigned officer or HARCO NATIONAL INSURANCE COMPANY and INTERNATIONAL FIDELITY INSURANCE COMPANY do hereby certify that I have compared the foregoing copy of the Power of Attorney and affidavit. and the copy of the Sections of the By -Laws of said Companies as set forth in said Power of Attorney, with the originals on rile In the home office of held companies, and Ihat the same are correct transcripts thereof, and of the whole of the said originals, and that the said Power of Attorney has not been revoked and Is now in full force and effect IN TESTIMONY WHEREOF, I have hereunto set my hand on this day, September 14, 2023 A00171 Irene Marlins, Assistant Secretary TO: The Honorable Mayor and City Council FROM: David Hurst, Fire Chief SUBJECT: Acceptance Final Payment- Fire Station No. 1 and Fire Station No. 2, Renovation Projects DATE: November 25, 2024 BACKGROUND: On September 5, 2023, City Council approved the Fire Station No. 1 and No. 2 Renovation Projects awarding all bids and construction management services to Limestone Construction, Inc., in the amount of $4,417,250.00. Limestone Construction has completed the work and staff has completed final inspections. Staff determined that Limestone Construction has satisfied all requirements of the contract. IWIL110111" Funding is included in the project budget within the Capital Improvements Fund and the Fire Service, Ambulance Service, and Emergency Preparedness budgets. RECOMMENDATION: Staff recommends acceptance of the project and authorization for final payment to Limestone Construction, Inc., of Owasso, Oklahoma, in the amount of $92,321.95. TO: The Honorable Mayor and City Council FROM: Carly Novozinsky, Finance Director Steve Tibbles, Deputy IT Director SUBJECT: ERP Software Upgrade DATE: November 22, 2024 PROPOSED ACTION: During the November worksession meeting, staff presented information regarding the City's current Enterprise Resource Planning (ERP) Software programs. Staff is proposing an upgrade to Central Square's Enterprise and NaviLine products. BACKGROUND: In early 2021, Central Square notified the City that they intended to end functional support of the City's existing ERP Software programs by December31, 2023. This meant that Central Square would no longer provide any functional or case assistance for the programs. No functional support of a software program can result in security concerns, as well as loss of function. In March 2021, the IT Department initiated meetings with each of the departments that would be impacted most by this change: Finance, Utility Billing, Community Development, and Human Resources. Staff began the process of identifying all of the functional requirements of the ERP software, as well as software components that could streamline processes that are completed manually. While the City's existing software would no longer be supported, Central Square provided the option for the City to upgrade to one of the newer products that would continue to be supported by Central Square. The Enterprise Software was suggested for Finance, Community Development, and Human Resources, and NaviLine was suggested for Utility Billing. In addition to Central Square, two additional software vendors were identified as potentially being able to meet the needs of the City: Caselle and Tyler Technologies. After staff had begun the process of exploring options and demoing software products, Central Square notified the City of their decision not to end functional maintenance of the existing software at that time. City staff indicated a desire to continue searching for alternative options with the knowledge that Central Square had been considering ending maintenance and that there is a good possibility Central Square will eventually make the decision to end maintenance on the existing software. PROJECT DETAILS: After initial demonstrations with the above -mentioned software vendors, it was determined that only an upgrade to another Central Square product, or the purchase of a Tyler Technologies product would fully meet the needs of the City. Caselle's software is better fit for a much smaller city. ERP Software Page 2 During 2023 and 2024, City staff continued to demo Central Square and Tyler Technologies software options for the following City functions: • Community Development • Finance • Human Resources • Payroll • Utility Billing Central Square and Tyler Technologies provided the following quotes, both valid until December 31, 2024: Purchase/Upgrade Travel & Training Year 1 Maintenance Total Contract Year 2 Maintenance VIiU71.[ Central Square $ 387,193.75 no additional cost included above Tyler Technologies $ 1,022,353.00 69,870.00 273,884.00 $ 387,193.75 $ 1,366,107.00 Central Square Tyler Technologies $ 182,425.00 $ 273,884.00 Funding for the ERP software upgrade is available in the IT Department's FY2024-25 approved budget. RECOMMENDATION: Staff recommends approval to purchase an upgrade of the City's ERP software in the amount of $387,193.75 with Central Square Technologies, LLC of Lake Mary, Florida, and authorization to execute all necessary documents. ATTACHMENT: Central Square Agreement CentralSquare Solutions Agreement This CentralSquare Solutions Agreement (the "Agreement"), effective as of the latest date shown on the signature block below (the "Effective Date"), is entered into between CentralSquare Technologies, LLC with its principal place of business in Lake Mary, FL ("CentralSquare") and City of Owasso, OK ("Customer"), together with CentralSquare, the "Parties", and each, a "Party„ WHEREAS, Customer entered into a prior agreement for Software products with Superion, a CentralSquare Technologies, LLC company; and WHEREAS, Customer is a currently licensed end user of the Superion Software; and WHEREAS, through asset purchase, CentralSquare is the owner of all Superion Software products, services, and contractual obligations; and WHEREAS, Customer desires to discontinue use of the Superion Software products and upgrade to the CentralSquare Software solution identified in Exhibit 1 to this Agreement; and WHEREAS, this Agreement shall replace and supersede any and all prior agreements directly related to the Superion Software products being replaced by this Agreement. WHEREAS, CentralSquare licenses and gives access to certain software applications ("Solutions") to its customers and also provides maintenance, support, migration, installation and other professional services; and WHEREAS, Customer desires to license and/or gain access to certain Solutions and receive professional services described herein, and CentralSquare desires to grant and provide Customer license and access to such offerings as well as to provide support and maintenance, subject to the terms and conditions set forth in this Agreement. NOW, THEREFORE, in consideration of the mutual covenants, terms, and conditions set forth herein, and for other good and valuable consideration, the receipt and sufficiency of which are hereby acknowledged, by the signatures of their duly authorized representative below, the Parties intending to be legally bound, agree to all of the following provisions and exhibits of this Agreement: #4 Ce�r ra)S a�hno�logres LO' � a, s "�.. .Crty,O Owasso = .� .�?`y 1000 Business Center Drive Lake Mary, FL 32746 200 S Main, Owasso, OK, 74055 By: By: Print Name: Print Name: Print Title: Print Title: Date Signed: Date Signed: Solution: Finance Enterprise Term. Initial Term. The Initial Term of this Agreement commences as of the Effective Date and will continue in effect for five (5) year(s) from such date unless terminated earlier pursuant to any of the Agreement's express provisions (the "Initial Term"). Renewal Term. This Agreement will automatically renew for additional successive one (1) year terms unless earlier terminated pursuant to any of the Agreement's provisions (a "Renewal Term" and, collectively, with the Initial Term, the "Term"). Non -Renewal. Either Party may elect to end renewal of the Agreement by issuing a notice of non -renewal, in writing, to the other Party six (6) months prior to the expiration of the Agreement term. Fees. In consideration of the rights and services granted by CentralSquare to Customer under this Agreement, Customer shall make payments to CentralSquare pursuant to the amounts and payment terms outlined in Exhibit 1 (the Solution(s) and Services Fee Schedule). All invoices shall be billed and paid in U.S. dollars (USD) and in accordance with the terms set forth in Exhibit 1. If Customer delays an invoice payment for any reason, Customer shall promptly notify CentralSquare in writing the reasons for such delay. Unless otherwise agreed by both Parties, CentralSquare may apply any payment received to any delinquent amount outstanding. CST-2024-102205 Standard Terms and Conditions 1. Definitions. Capitalized terms not otherwise defined in this Agreement have the meanings set forth below: 1.1. "Affiliate" means any other Entity that directly or indirectly, through one or more intermediaries, controls, is controlled by, or is under common control with, such Entity. 1.2. "Authorized User" means Customer's employees, consultants, contractors, and agents who are authorized by Customer to access and use the Solutions pursuant to this Agreement, and for whom access to the Solutions has been purchased. 1.3. "Baseline Solution" means the version of a Solution updated from time to time pursuant to CentralSquare's warranty services and maintenance, but without any other modification. 1.4. "CentralSquare Systems" means the information technology infrastructure used by or on behalf of CentralSquare to deliver the Solutions, including all computers, software, hardware, databases, electronic systems (including database management systems), and networks, whether operated directly by CentralSquare or through the use of third -party services. 1.5. "Customer Data" means information, data, and content, in any form or medium, collected, downloaded, or otherwise received, directly or indirectly from Customer, an Authorized User or end -users by or through the Solutions, provided the data is not personally identifiable and not identifiable to Customer. 1.6. "Customer Systems" means the Customer's information technology infrastructure, including computers, software, hardware, databases, electronic systems (including database management systems), and networks, whether operated by Customer or through the third -party services. 1.7. "Defect" means a material deviation between the Baseline Solution and its Documentation, for which Customer has given CentralSquare sufficient information to enable CentralSquare to replicate the deviation on a computer configuration that is both comparable to the Customer Systems and that is under CentralSquare's control. Further, with regard to any custom modification, Defect means a material deviation between the custom modification and the CentralSquare generated specification and Documentation for such custom modification, and for which Defect Customer has given CentralSquare sufficient information to enable CentralSquare to replicate the deviation on a computer configuration that is both comparable to the Customer Systems and that is under CentralSquare's control. 1.8. "Delivery" means: 1.8.1. For on -premise Solutions, Delivery shall be when CentralSquare delivers to Customer the initial copies of the Solutions outlined in Exhibit 1 by whichever the following applies and occurs first (a) electronic delivery, by posting it on CentralSquare's network fordownloading, or similar suitable electronic file transfer method, or (b) physical shipment, such as on a disc or other suitable media transfer method, or (c) installation, or (d) delivery of managed services server. Physical shipment is on FOB - CentralSquare's shipping point, and electronic delivery is at the time CentralSquare provides Customer with access to download the Solutions. 1.8.2. For cloud -based Solutions Delivery shall be whichever the following applies and occurs first when Authorized Users have (a) received log -in access to the Solution or any module of the Solution or (b) received access to the Solution via a URL. 1.9. "Documentation" means any manuals, instructions, or other documents or materials that CentralSquare provides or makes available to Customer in any form or medium and which describe the functionality, components, features, or requirements of the Solution(s), including any aspect of its installation, configuration, integration, operation, use, support, or maintenance. 1.10, "End User Training" means the process of educating general users of the Software on the operation of the Software. 1.11. "Entity" means an individual, corporation, partnership, joint venture, limited liability entity, governmental authority, unincorporated organization, trust, association, or other organization. 1.12. "Hardware" means any equipment, computer systems, servers, storage devices, peripherals, and any other tangible assets purchased under this Agreement. 1.13. "Intellectual Property Rights" means any and all registered and unregistered rights granted, applied for, or otherwise now or hereafter in existence under or related to any patent, copyright, trademark, trade secret, database protection, or other intellectual property rights laws, and all similar or equivalent rights or forms of protection, in any part of the world. 1.14. "Managed Services Hardware" means any equipment, computer systems, servers, peripherals, and any other tangible asset purchased as a subscription under this Agreement. 1.15. "Maintenance" means optimization, error correction, modifications, and Updates (defined herein) to CentralSquare Solutions to correct any known Defects and improve performance. Maintenance will be provided for each Solution, the hours and details of which are described in Exhibit 2 (Maintenance and Support). 1.16. "New or Major Releases" means new versions of a Baseline Solution (e.g., version 4.0, 5.0 etc.) not provided as part of Maintenance. CST-2024-102205 1.17. "Personal Information" means any information that does or can identify a specific individual or by or from which a specific individual may be identified, contacted, or located. Personal Information includes all "nonpublic personal information" as defined under the Gramm -Leach -Bliley Act, "protected health information" as defined underthe Health and Insurance Portability and Accountability Act of 1996, "Personal Data" as defined in the EU General Data Protection Regulation (GDPR 2018), "Personal Information" as defined under the Children's Online Privacy Protection Act of 1998, and all rules and regulations issued under any of the foregoing. 1.18. "Professional Services" means configuration, installation, implementation, development work, training or consulting services including custom modification programming, support relating to custom modifications, on -site support services, assistance with data transfers, system restarts and reinstallations provided by CentralSquare. 1.19. "Project Kickoff' is a meeting to occur shortly after contract execution between CentralSquare and Customer in which goals and objectives are set forth, all parties relevantteam members are identified, and scope, timelines, and milestones are reviewed. 1.20. "Reliability Period" is the time period in which the Software is tested and confirmed reliable by successfully completed fifteen (15) continuous days in a live environment with no repeatable Priority 1 or Priority 2 issues as defined in Exhibit 2, unless otherwise agreed in a statement of work. 1.21. "Software" means the software program(s) (in object code format only) identified on Exhibit 1 (Solution(s) and Services Fee Schedule). The term "Software" excludes any Third -Party Software. 1.22. "Software Version" means the base or core version of the Solution Software that contains significant new features and significant fixes and is available to the Customer. The nomenclature used for updates and upgrades consists of major, minor, build, and fix and these correspond to the following digit locations of a release, a,b,c,d. An example of which would be 7.4.1.3, where the 7 refers to the major release, the 4 refers to the minor release, the 1 refers to the build, and the 3 refers to a fix. 1.23. "Solutions" means the software, Documentation, development work, CentralSquare Systems and any and all other information, data, documents, materials, works, and other content, devices, methods, processes, hardware, software, technologies and inventions, including any deliverables, technical or functional descriptions, requirements, plans, or reports, provided or used by CentralSquare or any Subcontractor in connection with Professional Services or Support Services rendered under this Agreement. 1.24. "Support Services" means Maintenance, Enhancements, implementation of New Releases, and general support efforts to respond to incidents reported by Customer in accordance with Exhibit 2 (Maintenance & Support) and Exhibit 8 (Managed Services Provisions), if applicable. 1.25. "Third -Party Materials" means materials and information, in any form or medium, including any software, documents, data, content, specifications, products, related services, equipment, or components of or relating to the Solutions that are not proprietary to CentralSquare. 2. License. Access. and Title. 2.1. License Grant. For any Solution designated as a "license" on Exhibit 1, Customer is granted a perpetual (unless terminated as provided herein), nontransferable, nonexclusive right and license to use the Software for Customer's own internal use for the applications described in the Statement of Work, in the applicable environment (e.g., production, test, training, or disaster recovery system) and in the quantity set forth in Exhibit 1. Additional software licenses purchased after the execution of this Agreement shall also be licensed in accordance with the provisions of this section. Customer shall not use, copy, rent, lease, sell, sublicense, modify, create derivative works from/of, or transfer any software, or permit others to do said acts, except as provided in this Agreement. Any such unauthorized use shall be void and may result in immediate and automatic termination of the applicable license. In such event, Customer shall not be entitled to a refund of any license fees paid. Notwithstanding, Customer shall be entitled to use software at the applicable designated location for the purpose of the application(s) described in the Statement of Work to provide services for itself and otherAffiliate governmental agencies/entities, provided that the Software is installed and operated at only one physical location. The Software license granted in this Agreement or in connection with it are for object code only and do not include a license or any rights to source code whatsoever. 2.2. Access Grant. For any Solution designated as a "subscription" on Exhibit 1, so long as subscription fees are paid and current, (unless terminated as provided herein), Customer is granted a nontransferable, nonexclusive right to use the software for the Customer's own internal use for the applications described in the Statement of Work, in the applicable environment (e.g., production, test, training, or disaster recovery system) and in the quantity set forth in Exhibit 1. Additional CentralSquare software subscriptions purchased after the execution of this Agreement shall also be accessed in accordance with the provisions of this section. Customer shall not use, copy, rent, lease, sell, sublicense, modify, create derivative works from/of, or transfer any software, or permit others to do said acts, except as provided in this Agreement. Any such unauthorized use shall be void and may result in immediate and automatic termination of the applicable access. In such event, Customer shall not be entitled to a refund of any subscription fees paid. Notwithstanding, Customer shall be entitled to use software at the applicable designated location for the purpose of the application(s) described in the Statement of Work to provide services for itself and other Affiliate governmental agencies/entities. The subscription access granted in this Agreement or in connection with it are for object code only and do not include a license or any rights to source code whatsoever. CST-2024-102205 2.3. Documentation License. CentralSquare hereby grants to Customer a non-exclusive, non-sublicensable, non- transferable license to use the Documentation during the Term solely for Customer's internal business purposes in connection with its use of the Solutions. 2.4. Application Programming Interface "API". If the Customer has purchased any Application Programming Interface (API) license or subscription, Customer may use such API for Customer's own internal use to develop interfaces which enable interfacing with the applicable CentralSquare Software purchased herein. The development and use of such interfacing applications is specifically permitted under the use granted herein and shall not be deemed derivative works provided that they are not, in fact, derived from the CentralSquare Software or the ideas, methods of operation, processes, technology or know-how implemented therein. Other than the usage rights granted herein, Customer shall not acquire any right, title or interest in the CentralSquare Software or API by virtue of the interfacing of such applications, whether as joint owner, or otherwise. Should Customer desire to provide or share the API to a third -party, the third -party must enter into an API Access Agreement by and between the third -party and CentralSquare directly to govern the usage rights and restrictions of the applicable API. 2.5. Hardware. Subject to the terms and conditions of this Agreement, CentralSquare agrees to deliver, through hardware vendors, the Hardware itemized on Exhibit 1. The risk of loss or damage will pass to Customer upon the date of delivery to the Customer specified facility. Upon delivery and full satisfaction of the Hardware payment obligations, Hardware shall be deemed accepted and Customer will acquire good and clear title to Hardware. All Hardware manufacturer warranties will be passed through to Customer. CentralSquare expressly disclaims, and Customer hereby expressly waives all other Hardware warranties, express or implied, without limitation, warranties of merchantability and fitness for a particular purpose. 2.6. Managed Services Hardware. Subject to the terms and conditions of this Agreement, CentralSquare agrees to deliver the Managed Services Hardware itemized on Exhibit 1. So long as the applicable subscription fees are paid and current, Customer shall maintain a limited right in possessory interest in the Managed Services Hardware. No title in the Managed Services Hardware will pass to Customer at any time or for any reason. Customer agrees to maintain adequate insurance against fire, theft, or other loss for the Managed Services Hardware full insurable value. CentralSquare shall coordinate any defect or warranty claims in accordance with Exhibit 8. 2.7. Reservation of Rights. Nothing In this Agreement grants any right, title, or interest in or to any Intellectual Property Rights in or relating to the Solutions, or Third -Party Materials, whether expressly, by implication, estoppel, or otherwise. All right, title, and interest in the Solutions, and the Third -Party Materials are and will remain with CentralSquare and the respective rights holders. 3. Use Restrictions. Authorized Users shall not: 3.1. copy, modify, or create derivative works or improvements of the Solutions, or rent, lease, lend, sell, sublicense, assign, distribute, publish, transfer, or otherwise make available any Solutions to any Entity, including on or in connection with the internet or any time-sharing, service bureau, software as a service, cloud, or other technology or service; 3.2. reverse engineer, disassemble, decompile, decode, adapt, or otherwise attempt to derive or gain access to the source code of the Solutions, in whole or in part; 3.& bypass or breach any security device or protection used by Solutions or access or use the Solutions other than by an Authorized User through the use of his or her own then valid access; 3.4. input, upload, transmit, or otherwise provide to or through the CentralSquare Systems, any information or materials that are unlawful or injurious, or contain, transmit, or activate any harmful code (any software, hardware, device, or other technology, including any virus, worm, malware, or other malicious computer code, the purpose or effect of which is to (a) permit unauthorized access to, or to destroy, disrupt, disable, distort, or otherwise harm or impede any (i) computer, software firmware, hardware, system or network; or (ii) any application or function of any of the foregoing or the security, integrity, confidentiality, or use of any data processed thereby; or (b) prevent Customer or any Authorized User from accessing or using the Solutions as intended by this Agreement; 3.5. damage, destroy, disrupt, disable, impair, interfere with, or otherwise impede or harm in any manner the CentralSquare Systems, or CentralSquare's provision of services to any third -parry, in whole or in part; 3.6. remove, delete, alter, or obscure any trademarks, specifications, Documentation, warranties, or disclaimers, or any copyright, trademark, patent, or other intellectual property or proprietary rights notices from any Documentation or Solutions, including any copy thereof; 3.7. access or use the Solutions in any manner or for any purpose that infringes, misappropriates, or otherwise violates any Intellectual Property Right or other right of any third -party, or that violates any applicable law; 3.8. access or use the Solutions for purposes of competitive analysis of the Solutions, the development, provision, or use of a competing software service or product or any other purpose that is to CentralSquare's detriment or commercial disadvantage or otherwise access or use the Solutions beyond the scope of the authorization granted in Section 2. 4. Audit. 4.1. CentralSquare shall have the right to audit Customer's use of the Software to monitor compliance with this Agreement. Customer shall permit CentralSquare and its directors, officers, employees, and agents to have on -site access at Customer's premises (or remote access as the case may be) during normal business hours to such systems, books, and CST-2024-102205 records for the purpose of verifying license counts, access counts, and overall compliance with this Agreement. Customer shall render reasonable cooperation to CentralSquare as requested. If as a result of any audit or inspection CentralSquare substantiates a deficiency or non-compliance, or if an audit reveals that Customer has exceeded the restrictions on use, Customer shall promptly reimburse CentralSquare for all its costs and expenses incurred to conduct such audit or inspection and be required to pay for any delinquencies in compliance and prompt payment of any underpayment of Fees. 5. Customer Obligations. 5.1. Customer Systems and Cooperation. Customer shall at all times during the Term: (a) set up, maintain, and operate in good repair all Customer Systems on or through which the Solutions are accessed or used; (b) provide CentralSquare Personnel with such access to Customers premises and Customer Systems as is necessary for CentralSquare to perform the Support Services in accordance with the Support Standards and specifications and if required by CentralSquare, remote access in accordance with Exhibit 3 (CentralSquare Access Management Policy); and (c) provide all cooperation as CentralSquare may reasonably request to enable CentralSquare to exercise its rights and perform its obligations under this Agreement. 5.2. Effect of Customer Failure or Delay. CentralSquare is not responsible or liable for any delay or failure of performance caused in whole or in part by Customer's delay in performing, or failure to perform, any of its obligations under this Agreement. 5.3. Corrective Action and Notice. If Customer becomes aware of any actual or threatened activity prohibited by Section 3, Customer shall, and shall cause its Authorized Users to, immediately: (a) take all reasonable and lawful measures within their respective control that are necessary to stop the activity or threatened activity and to mitigate its effects (including, where applicable, by discontinuing and preventing any unauthorized access to the Solutions and permanently erasing from their systems and destroying any data to which any of them gained unauthorized access); and (b) notify CentralSquare of any such actual or threatened activity. 5.4. Maintaining Current Versions of CentralSquare Solutions In accordance with Exhibit 2 (Maintenance & Support) and Exhibit 8 (Managed Services Provisions), if applicable. Customer shall install and/or use any New or Major Release within one year of being made available by CentralSquare to mitigate a performance problem, ineligibility for Support Services, or an infringement claim. 6. Professional Services. 6.1. Compliance with Customer Policies. While CentralSquare personnel are performing services at Customers site, CentralSquare personnel will comply with Customer's reasonable procedures and site policies that are generally applicable to Customer's other suppliers providing similar services and that have been provided to CentralSquare in writing or in advance. 6.2. Contributed Material. In the process of CentralSquare's performing Professional Services, Customer may, from time to time, provide CentralSquare with designs, plans, or specifications, improvements, works or other material for inclusion in, or making modifications to, the Solutions, the Documentation or any other deliverables ("Contributed Material"). Customer grants to CentralSquare a nonexclusive, irrevocable, perpetual, transferable right, without the payment of any royalties or other compensation of any kind and without the right of attribution, for CentralSquare, CentralSquare's Affiliates and CentralSquare's licensees to make, use, sell and create derivative works of the Contributed Material. 6.3. Federal Grant Funds. Not Applicable. 7. Confidentiality. 7.1. Nondisclosure. The Parties agree, unless otherwise provided in this Agreement or required by law, not to use or make each other's Confidential Information available to any third party for any purpose other than as necessary to perform under this Agreement. "Confidential Information" means the Solution(s), Software, and customizations in any embodiment, and either Party's technical and business information relating to inventions or software, research and development, future product specifications, engineering processes, costs, profit or margin information, marketing and future business plans as well as any and all internal Customer and employee information, and any information exchanged by the Parties that is clearly marked with a confidential, private or proprietary legend or which, by its nature, is commonly understood to be confidential. 7.2. Exceptions. A Party's Confidential Information shall not include information that: (a) is or becomes publicly available through no act or omission of the recipient; (b) was in the recipient's lawful possession prior to the disclosure and was not obtained by the recipient either directly or indirectly from the disclosing Party; (c) is lawfully disclosed to the recipient by a third party without restriction on recipient's disclosure, and where recipient was not aware that the information was the confidential information of discloser; (d) is independently developed by the recipient without violation of this Agreement; or (a) is required to be disclosed by law. 8. Security. 8.1. CentralSquare will implement commercially reasonable administrative, technical and physical safeguards designed to ensure the security and confidentiality of Customer Data, protect against any anticipated threats or hazards to the security or integrity of Customer Data, and protect against unauthorized access or use of Customer Data. CentralSquare will review and test such safeguards on no less than an annual basis. CST-2024-102205 8.2. Customer shall maintain, in connection with the operation or use of the Solutions, adequate technical and procedural access controls and system security requirements and devices, necessary for data privacy, confidentiality, integrity, authorization, authentication, non -repudiation, virus detection and eradication. 8.3. To the extent that Authorized Users are permitted to have access to the Solutions, Customer shall maintain agreements with such Authorized Users that adequately protect the confidentiality and Intellectual Property Rights of CentralSquare in the Solutions and Documentation and disclaim any liability or responsibility of CentralSquare with respect to such Authorized Users. 9. Personal Data. If CentralSquare processes or otherwise has access to any personal data or Personal Information on Customer's behalf when performing CentralSquare's obligations under this Agreement, then: 9.1. Customer shall be the data controller (where "data controller" means an entity which alone or jointly with others determines purposes for which and the manner in which any personal data are, or are to be, processed) and CentralSquare shall be a data processor (where "data processor" means an entity which processes the data only on behalf of the data controller and not for any purposes of its own); 9.2. Customer shall ensure that it has obtained all necessary consents and it is entitled to transfer the relevant personal data or Personal Information to CentralSquare so that CentralSquare may lawfully use, process and transfer the personal data and Personal Information in accordance with this Agreement on Customer's behalf, which may include CentralSquare processing and transferring the relevant personal data or Personal Information outside the country where Customer and the Authorized Users are located in order for CentralSquare to provide the Solutions and perform its other obligations under this Agreement; and 9.3. CentralSquare shall process personal data and information only in accordance with lawful and reasonable written instructions given by Customer and as set out in and in accordance with the terms of this Agreement; and 9.4. CentralSquare shall take reasonable steps to ensure that its employees, agents and contractors who may have access to Personal Information are persons who need to know / access the relevant Personal Information for valid business reasons; and 9.5. each Party shall take appropriate technical and organizational measures against unauthorized or unlawful processing of the personal data and Personal Information or its accidental loss, destruction or damage so that, having regard to the state of technological development and the cost of implementing any measures, the measures taken ensure a level of security appropriate to the harm that might result from such unauthorized or unlawful processing or accidental loss, destruction or damage in relation to the personal data and Personal Information and the nature of the personal data and Personal Information being protected. If necessary, the Parties will cooperate to document these measures taken. 10. Representations and Warranties. 10.1. Intellectual Property Warranty. CentralSquare represents and warrants that (a) it is the sole and exclusive owner of (or has the right to license) the software; (b) it has full and sufficient right, title and authority to grant the rights and/or licenses granted under this Agreement; (c) the software does not contain any materials developed by a third party used by CentralSquare except pursuant to a license agreement; and (d) the software does not infringe any patent, or copyright. 10.2. Intellectual Property Remedv. In the event that any third party asserts a claim of infringement against the Customer relating to the software contained in this Agreement, CentralSquare shall indemnify and defend the Customer pursuant to section 13.1 of this Agreement. In the case of any such claim of infringement, CentralSquare shall either, at its option, (1) procure for Customer the right to continue using the software; or (2) replace or modify the software so that that it becomes non -infringing, but equivalent in functionality and performance. 10.3. Software Warranty. CentralSquare warrants to Customer that: (i) for a period of one year from the Effective Date (the "Warranty Period") the Software will substantially conform in all material respects to the specifications set forth in the Documentation, when installed, operated and used as recommended in the Documentation and in accordance with this Agreement; and (ii) at the time of delivery the Software does not contain any virus or other malicious code. 10.4. Software Remedy. If, during the Warranty Period a warranty defect is confirmed in the CentralSquare Software, CentralSquare shall, at its option, reinstall the Software or correct the Defects. Defects that occur in the Software after the Warranty Period will be corrected pursuant to Exhibit 2 (Maintenance & Support) and Exhibit 8 (Managed Services Provisions), if applicable. 10.5. Services Warranty. CentralSquare warrants that the Professional Services delivered will substantially conform to the deliverables specified in the applicable statement of work and that all Professional Services will be performed in a professional and workmanlike manner consistent with industry standards for similar work. If Professional Services do not substantially conform to the deliverables, Customer shall notify CentralSquare of such non-conformance in writing, within 10 days from completion of Professional Service, and CentralSquare shall promptly repair the non -conforming deliverables. 10.6. Disclaimer of Warranty. EXCEPT FOR THE EXPRESS LIMITED WARRANTIES SET FORTH ABOVE, CENTRALSQUARE MAKES NO WARRANTIES WHATSOEVER, EXPRESSED OR IMPLIED, WITH REGARD TO THE INTELLECTUAL PROPERTY, SOFTWARE, PROFESSIONAL SERVICES, AND/OR ANY OTHER MATTER RELATING TO THIS AGREEMENT, AND THAT CENTRALSQUARE DISCLAIMS ALL WARRANTIES, WHETHER EXPRESS, IMPLIED, STATUTORY, OR OTHERWISE, INCLUDING ALL WARRANTIES ARISING FROM COURSE CST-2024-102205 OF DEALING, USAGE OR TRADE PRACTICE, AND SPECIFICALLY DISCLAIMS IMPLIED WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, OR TITLE. FURTHER, CENTRALSQUARE EXPRESSLY DOES NOT WARRANT THAT A SOLUTION, ANY CUSTOM MODIFICATION OR ANY IMPROVEMENTS WILL BE USABLE BY CUSTOMER IF THE SOLUTION OR CUSTOM MODIFICATION HAS BEEN MODIFIED BY ANYONE OTHER THAN CENTRALSQUARE PERSONNEL, OR WILL BE ERROR FREE, WILL OPERATE WITHOUT INTERRUPTION OR WILL BE COMPATIBLE WITH ANY HARDWARE OR SOFTWARE EXCEPT TO THE EXTENT EXPRESSLY SET FORTH IN THE DOCUMENTATION. ALL THIRD -PARTY MATERIALS ARE PROVIDED "AS -IS" AND ANY REPRESENTATION OR WARRANTY OF OR CONCERNING ANY OF THEM IS STRICTLY BETWEEN CUSTOMER AND THE THIRD -PARTY. THIS AGREEMENT DOES NOT AMEND, OR MODIFY CENTRALSQUARE'S WARRANTY UNDER ANY AGREEMENT OR ANY CONDITIONS, LIMITATIONS, OR RESTRICTIONS THEREOF. 11. Notices. All notices and other communications required or permitted under this Agreement must be in writing and will be deemed given when delivered personally, sent by United States registered or certified mail, return receipt requested; transmitted by facsimile or email confirmed by first class mail, or sent by overnight courier. Notices must be sent to a Party at its address shown below, or to such other place as the Party may subsequently designate for its receipt of notices in writing by the other Party. If to CentralSquare CentralSquare Technologies, LLC 1000 Business Center Dr. Lake Mary, FL 32746 Phone:407.304.3235 Attention: Legal/Contracts If to Customer: City of Owasso 200 S Main Owasso, OK 74055 Phone: (407) 514-9300 Email: william.sims@centralsquare.com Attention: 12. Force Maieure. Neither Party shall be responsible for failure to fulfill its obligations hereunder, or be liable for damages resulting from delay in performance as a result of war, fire, strike, riot or insurrection, natural disaster, pandemic or epidemic, delay of carriers, governmental order or regulation, complete or partial shutdown of plant, unavailability of equipment, software, or services from suppliers, default of a subcontractor or vendor to the Party if such default arises out of causes beyond the reasonable control of such subcontractor or vendor, the acts or omissions of the other Party, or its officers, directors, employees, agents, contractors, or elected officials, and/or other occurrences beyond the Party's reasonable control ("Excusable Delay" hereunder). In the event of such Excusable Delay, performance shall be extended on a day for day basis or as otherwise reasonably necessary to compensate for such delay. 13. Indemnification. 13.1. CentralSquare Indemnification. CentralSquare shall indemnify, defend, and hold harmless Customer from any and all Claims or liability, including attorneys' fees and costs, brought by a third party, allegedly arising out of, in connection with, or incident to any loss, damage or injury to persons or property or arising solely from a wrongful or negligent act, error or omission of CentralSquare, its employees, agents, contractors, or any subcontractor as a result of CentralSquare's or any subcontractor's performance pursuant to this Agreement; however, CentralSquare shall not be required to indemnify Customer for any claims caused to the extent of the negligence or wrongful act of Customer, its employees, agents, or contractors. Notwithstanding anything to the contrary in the foregoing, if a Claim or liability results from or is contributed to by the actions or omissions of Customer, or its employees, agents or contractors, CentralSquare's obligations under this provision shall be reduced to the extent of such actions or omissions based upon the principle of comparative fault. 13.2. Customer Indemnification. To the extent allowable by law, Customer shall indemnify, defend, and hold harmless CentralSquare from any and all Claims or liability, including attorneys' fees and costs, allegedly arising out of, in connection with, or incident to any loss, damage or injury to persons or property or arising solely from a wrongful or negligent act, error or omission of Customer, its employees, agents, contractors, or any subcontractor as a result of Customer's or any subcontractor's performance pursuant to this Agreement; however, Customer shall not be required to indemnify CentralSquare for any Claims or actions caused to the extent of the negligence or wrongful act of CentralSquare, its employees, agents, or contractors. Notwithstanding anything to the contrary in the foregoing, if a Claim or liability results from or is contributed to by the actions or omissions of CentralSquare, or its employees, agents or contractors, Customer's obligations under this provision shall be reduced to the extent of such actions or omissions based upon the principle of comparative fault. CST-2024-102205 13.3. "Claim" in this Section 13 means any claim, cause of action, demand, lawsuit, dispute, inquiry, audit, notice of violation, proceeding, litigation, citation, summons, subpoena or investigation of any nature, civil, criminal, administrative, regulatory or other, whether at law, in equity, or otherwise. 14. Termination. 14.1. Either Party may terminate this Agreement for a material breach in accordance with this subsection. In such event, the disputing Party shall deliver written notice of its intent to terminate along with a description in reasonable detail of the problems for which the disputing Party is invoking its right to terminate and the specific requirement within this Agreement or any exhibit or schedule hereto that the disputing Party is relying upon. Following such notice, the Parties shall commence dispute resolution procedures in accordance with the dispute resolution procedure pursuant to Section 17. 14.2. CentralSquare shall have the right to terminate this Agreement based on Customer's failure to pay undisputed amounts due under this Agreement more than ninety (90) days after delivery of written notice of non-payment. 14.3. Customer shall have the right to terminate if the proper appropriation of funds for the continuation of this Agreement is not available for any fiscal year after the first fiscal year during the Term, then this Agreement may be terminated. To effect the termination of this Agreement, Customer shall, within forty-five (45) days following the beginning of the fiscal year for which the proper appropriation is not available, provide CentralSquare with written notice of the failure to obtain the proper appropriation of funds. Such notice shall be accompanied by the payment of all sums then owed CentralSquare under this Agreement, if any. 14.4. For any on -premise, non -cloud -hosted, subscription asset, the Customer may terminate for convenience, in whole or in part, at any time by providing thirty (30) days written notice. Should Customer terminate for convenience during any twelve (12) month term, CentralSquare shall provide a pro -rated refund for any on -premise subscription asset. 15. Effect of Termination or Expiration. On the expiration or earlier termination of this Agreement 15.1. All rights, licenses, and authorizations granted to Customer hereunder will immediately terminate and Customer shall immediately cease all use of CentralSquare's Confidential Information and the Solutions, and within thirty (30) days deliver to CentralSquare, or at CentralSquare's request destroy and erase CentralSquare's Confidential Information from all systems Customer directly or indirectly controls; and 15.2. All licenses, access or subscription fees, services rendered but unpaid, and any amounts due by Customer to CentralSquare of any kind shall become immediately payable and due no later than thirty (30) days after the effective date of the termination or expiration, including anything that accrues within those thirty (30) days. 15.3. The provisions set forth in the following sections, and any other right or obligation of the Parties in this Agreement that, by its nature (including but not limited to: Use Restrictions, Confidential Information, Warranty Disclaimers, Indemnifications, & Limitations of Liability), will survive any expiration or termination of this Agreement. 15.4. In the event that Customer terminates this Agreement or cancels any portions of a project (as may be set forth in a Statement of Work) prior to Go Live (which shall be defined as "first use of a Solution or module of a Solution in a production environment, unless otherwise agreed by the Parties in a statement of work"), Customer shall pay for all Professional Services actually performed by CentralSquare on a time and materials basis, regardless of the payment terms in Exhibit 1. 15.5. Return of Customer Data. If Customer requests in writing at least ten (10) days prior to the effective date of expiration or earlier termination of this Agreement, CentralSquare shall within sixty (60) days following such expiration or termination, deliver to Customer in CentralSquare's standard format the then most recent version of Customer Data maintained by CentralSquare, provided that Customer has at that time paid all Fees then outstanding and any amounts payable after or as a result of such expiration or termination. 15.6. Deconversion. In the event of (i) expiration or earlier termination of this Agreement, or (ii) Customer no longer purchasing certain Solutions (including those indicated to be Third -Party Materials), if Customer requests assistance in the transfer of Customer Data to a different vendor's applications ("Deconversion"), CentralSquare will provide reasonable assistance. CentralSquare and Customer will negotiate in good faith to establish the relative roles and responsibilities of CentralSquare and Customer in effecting Deconversion, as well as the appropriate date for completion. CentralSquare shall be entitled to receive compensation for any additional consultation, services, software, and documentation required for Deconversion on a time and materials basis at CentralSquare's then standard rates. 15.7. Termination of this Agreement shall not relieve either Party of any other obligation incurred one to the other prior to termination. 16. Assignment. Neither this Agreement nor any rights or obligations hereunder shall be assigned or otherwise transferred by either Party without the prior written consent of the other Party, which consent will not be unreasonably withheld; provided however, that in the event of a merger or acquisition of all or substantially all of CentralSquare's assets, CentralSquare may assign this Agreement to an entity ready, willing and able to perform CentralSquare's executory obligations hereunder. 17. Dispute Resolution. Any dispute, controversy or claim arising out of or relating to this Agreement (each, a "Dispute"), including the breach, termination, or validity thereof, shall be resolved as follows: 17.1. Good Faith Negotiations. The Parties agree to send written notice to the other Party of any Dispute ("Dispute Notice"). After the other Party receives the Dispute Notice, the Parties agree to undertake good faith negotiations to resolve the Dispute. Each Party shall be responsible for its associated travel and other related costs. 17.2. Escalation to Mediation. If the Parties cannot resolve any Dispute through good faith negotiations, the dispute will be CST-2024-102205 escalated to non -binding mediation, with the Parties acting in good faith to select a mediator and establishing the mediation process. The Parties agree the mediator's fees and expenses, and the mediator's costs incidental to the mediation, will be shared equally between the Parties. The Parties shall bear their own fees, expenses, and costs. 17.3. Confidential Mediation. The Parties further agree all written or oral offers, promises, conduct, and statements made in the course of the mediation are confidential, privileged, and inadmissible for any purpose in any litigation, arbitration or other proceeding involving the Parties. However, evidence that is otherwise admissible or discoverable shall not be rendered inadmissible or non -discoverable as a result of its use in the mediation. 17.4. Litigation. If the Parties cannot resolve a Dispute through mediation, then once an impasse is declared by the mediator either Party may pursue litigation in a court of competent jurisdiction. 18. Waiver/Severability. The failure of any Party to enforce any of the provisions hereof will not be construed to be a waiver of the right of such Party thereafter to enforce such provisions. If any provision of this Agreement is found to be unenforceable, that provision will be enforced to the maximum extent possible, and the validity, legality and enforceability of the remaining provisions will not in any way be affected or impaired thereby. 19. LIABILITY. NOTWITHSTANDING ANY PROVISION WITHIN THIS AGREEMENT TO THE CONTRARY, AND REGARDLESS OF THE NUMBER OF LOSSES, WHETHER IN CONTRACT, EQUITY, STATUTE, TORT, NEGLIGENCE, OR OTHERWISE: 19.1. NEITHER PARTY SHALL HAVE LIABILITY TO THE OTHER PARTY FOR ANY SPECIAL, INDIRECT, INCIDENTAL, PUNITIVE, EXEMPLARY, LIQUIDATED, OR CONSEQUENTIAL DAMAGES OF ANY KIND INCLUDING BUT NOT LIMITED TO, REPLACEMENT COSTS, AND NEITHER PARTY SHALL BE LIABLE TO THE OTHER PARTY FOR LOSSES OF PROFIT, REVENUE, INCOME, BUSINESS, ANTICIPATED SAVINGS, DATA, AND REPUTATION, AND MORE GENERALLY, ANY LOSSES OF AN ECONOMIC OR FINANCIAL NATURE, REGARDLESS OF WHETHER SUCH LOSSES MAY BE DEEMED AS CONSEQUENTIAL OR ARISING DIRECTLY AND NATURALLY FROM THE INCIDENT GIVING RISE TO THE CLAIM, AND REGARDLESS OF WHETHER SUCH LOSSES ARE FORESEEABLE OR WHETHER EITHER PARTY HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH LOSSES; AND 19.2. CENTRALSQUARE'S TOTAL LIABILITY ARISING OUT OF OR IN CONNECTION WITH THIS AGREEMENT SHALL NOT EXCEED THE AMOUNT(S) ACTUALLY PAID BY CUSTOMER TO CENTRALSQUARE HEREUNDER FOR THE LAST TWELVE (12) MONTHS PRIOR TO THE DATE THE CLAIM AROSE. 20. Insurance. During the term of this Agreement, CentralSquare shall maintain insurance coverage covering its operations in accordance with Exhibit 4 (Certificate of Insurance (Evidence of Coverage)). Upon request by Customer, CentralSquare shall include Customer as an additional insured on applicable insurance policies provided under this Agreement. CentralSquare shall provide proof of current coverage during the term of this Agreement. 21. Third -Party Materials. CentralSquare may, from time to time, include third parties to perform services, provide software, or provide equipment. Customer acknowledges and agrees CentralSquare provides front-line support services for these Third - Party Materials, but these third parties assume all responsibility and liability in connection with the Third -Party Materials. CentralSquare is not authorized to make any representations or warranties that are binding upon the third -party or to engage in any other acts that are binding upon the third -party, except specifically that CentralSquare is authorized to represent third - party fees and to accept payment of such amounts from Customer on behalf of the third -party for as long as such third -party authorizes CentralSquare to do so. As a condition precedent to installing or accessing certain Third -Party Materials, Customer may be required to execute a click -through, shrink-wrap End User License Agreement ("EULA") or similar agreement provided by the Third -Party Materials provider. If mapping information is supplied with the CentralSquare Software, CentralSquare makes no representation or warranty as to the completeness or accuracy of the mapping data provided with the CentralSquare Software. The completeness or accuracy of such data is solely dependent on the information supplied by the Customer or the mapping database vendor to CentralSquare. All third -party materials are provided "as -is" and any representation or warranty concerning them is strictly between Customer and the third -party. 22. Subcontractors. CentralSquare may from time to time, in its discretion, engage third parties to perform services on its behalf including but not limited to Professional Services, Support Services, and/or provide software (each, a "Subcontractor"). CentralSquare shall be fully responsible for the acts of all subcontractors to the same extent it is responsible for the acts of its own employees. 23. Entire Agreement. This Agreement, and any Exhibits specifically incorporated therein by reference, constitute the entire agreement between the Parties with respect to the subject matter. These documents supersede and merge all previous and contemporaneous proposals of sale, communications, representations, understandings and agreements, whether oral or written, between the Parties with respect to the subject hereof. 24. Amendment. Either Party may, at any time during the term, request in writing changes to this agreement. The Parties shall evaluate and, if agreed, implement all such requested changes. No requested changes will be effective unless and until memorialized in either a CentralSquare issued add -on quote signed by Customer, or a written change order or amendment to this Agreement signed by both Parties. 25, No Third -Party Beneficiaries. This Agreement is for the sole benefit of the Parties and their respective successors and permitted assigns and nothing herein, express or implied, is intended to or shall confer on any other person any legal or equitable right, benefit, or remedy of any nature under or by reason of this Agreement. CST-2024-102205 26. Counterparts. This Agreement, and any amendments hereto, may be executed in several counterparts, each of which when so executed shall be deemed to be an original, and such counterparts shall constitute one and the same instrument. The Agreement (and any amendments) shall be considered properly executed by a Party if executed by that Parry and transmitted by facsimile or other electronic means, such as DocuSign, Tagged Image Format Files (TIFF), or Portable Document Format (PDF). 27. Material Adverse Change. If any law, regulation, applicable standard, process, OEM requirement is changed or comes into force after the Effective Date, including but not limited to PCI standards or Americans with Disabilities Act compliance (collectively, a "Material Adverse Change"), which is not explicitly addressed within this Agreement and results in significant extra costs for either Party in relation to the performance of this Agreement, both Parties shall promptly meet, discuss in good faith, and agree upon reducing the technical, operational, and/or commercial impact of such Material Adverse Change. 28. Cooperative Purchases. This Agreement may be used by Customer Affiliates. CentralSquare agrees to offer similar services to other Affiliates under the same terms and conditions as stated herein except that the Fees may be negotiated between CentralSquare and other Affiliates based on the specific revenue expectations, agency reimbursed costs, and other Affiliate requirements. The Customer will in no way whatsoever incur any liability in relation to specifications, delivery, payment, or any other aspect of purchases by such Affiliates. CentralSquare and the Affiliate will enter into any such arrangement with an amendment to this Agreement. 29. Order of Precedence. 29.1. In the event of any conflict or inconsistency between this Agreement, the Exhibits, or any purchase order, then the following priority shall prevail: 29.1.1. The main body of this Agreement and any associated amendments, statements of work (including Exhibit 5 (Statement of Work)), or change orders and then the attached Exhibits to this Agreement in the order in which they appear. 29.2. Customer's purchase terms and conditions or CentralSquare's sales terms and conditions are not applicable and shall have no force or effect, whether referenced in any document in relation to this Agreement. 29.3, Incorporated Exhibits to this Agreement: Exhibit 1: Solution(s) and Services Fee Schedule Exhibit 2: Maintenance & Support Exhibit 3: CentralSquare Access Management Policy Exhibit 4: Certificate of Insurance (Evidence of Coverage) Exhibit 5: Statement of Work Exhibit 6: Using/Accessing Agency Guidelines (if applicable) Exhibit 7: Service Level Commitments (if applicable) Exhibit 8: Managed Services Provisions (if applicable) Exhibit 9: Third -Party Terms and Conditions (if applicable) Exhibit 10: Community Data Platform Agreement (if applicable) CST-2024-102205 EXHIBIT 1 Solution(s) and Services Fee Schedule Quote #: Q-186699 WHAT SOFTWARE IS INCLUDED? CENTRALSQUARE PAYMENTS PRODUCT NAME QUANTITY UNIT PRICE TOTAL 1. CentralSquare Payments -Community 1 0.00 0.00 Development Annual Subscription Fee CentralSquare Payments Software Total 0.00 USD COMMUNITY DEVELOPMENT PRODUCT NAME QUANTITY UNIT PRICE DISCOUNT TOTAL 2. Bluebeam Server API for 1 2,100.00 2,100.00 TRAKiT Annual Access Fee 3. Community Development: 8 6,850.00-4,200.00 50,600.00 Advanced Annual Subscription Fee SaaS 4. eTRAKIT Credit Card API 1 900.00 900.00 Annual Access Fee 5. GIS Advanced Engine 1 5,500.00 5,500.00 Subscription SaaS Annual Subscription Fee SaaS FINANCE / HR /PAYROLL PRODUCT NAME 6. Finance Enterprise: Advanced SaaS Subscription Annual Subscription Fee T HCM Employee Finance Enterprise: Advanced SaaS Subscription Annual Subscription Fee UTILITY BILLING PRODUCT NAME 8, CentralSquare Utility Billing Annual Subscription Fee Community Development Software Subtotal 63,300.00 USD Community Development Software Discount-4,200.00 USD Community Development Software Total 59,100.00 USD QUANTITY UNIT PRICE DISCOUNT TOTAL 1 108,880.00-28,880.00 80,000.00 255 15.00 3,825.00 Finance / HR /Payroll Software Subtotal 112,705.00 USD Finance / HR [Payroll Software Discount - 28,880.00 USD Finance / HR /Payroll Software Total 83,825.00 USD QUANTITY UNIT PRICE DISCOUNT TOTAL 1 50,000.00-12,500.00 37,500.00 Utility Billing Software Subtotal 50,000.00 USD Utility Billing Software Discount-12,500.00 USD Utility Billing Software Total 37,500.00 USD CST-2024-102205 SOFTWARE SUMMARY WHAT SERVICES ARE INCLUDED? CENTRALSQUARE PAYMENTS DESCRIPTION 1. Public Administration Project Management Services -Fixed Fee 2. Public Administration Technical Services -Fixed Fee CentralSquare Payments Services Subtotal CentralSquare Payments Services Discount CentralSquare Payments Services Total COMMUNITY DEVELOPMENT DESCRIPTION 3. Public Administration Consulting Services - Fixed Fee 4. Public Administration Data Conversion Services - Fixed Fee 5. Public Administration Development Services - Fixed Fee 6. Public Administration GIS Services - Fixed Fee 7. Public Administration Project Management Services - Fixed Fee 8. Public Administration Technical Services - Fixed Fee 9. Public Administration Training Services - Fixed Fee Community Development Services Subtotal Community Development Services Discount Community Development Services Total IaIzL,1Z[d4Za ZVI 7Vd0611IN DESCRIPTION 10. Finance Enterprise: Advanced SaaS Subscription Cloud Setup Fee 11. Public Admin Travel & Living Estimate 12. Public Administration Consulting Services - Fixed Fee 13. Public Administration Data Conversion Services - Fixed Fee 14. Public Administration Project Management Services - Fixed Fee 15. Public Administration Technical Services - Fixed Fee 16. Public Administration Training Services - Fixed Fee Finance / HR /Payroll Services Subtotal Finance / HR /Payroll Services Discount Finance / HR /Payroll Services Total UTILITY BILLING DESCRIPTION 17. Public Administration Luciant Custom Services - As Incurred 18. Public Administration Project Management Services - Fixed Fee 19. Public Administration Technical Services - Fixed Fee Utility Billing Services Subtotal Software Subtotal Software Discount Software Total 226,005.00 USD - 45,580.00 USD 180,425.00 USD TOTAL 780.00 2,730.00 3,510.00 USD 3,510.00 USD 0.00 USD TOTAL 34,905.00 23,205.00 9,945.00 9,750.00 17,160.00 585.00 7,020.00 102,570.00 USD 66,670.50 USD 35,899.50 USD TOTAL 10,000.00 11,500.00 155,610.00 12,870.00 39,975.00 7,020.00 32,370.00 269,345.00 USD -161,099.25 USD 108,245.75 USD TOTAL 110,760.00 19,500.00 40, 950.00 171,210.00 USD CST-2024-102205 SERVICES SUMMARY WHAT HARDWARE IS INCLUDED? FINANCE / HR /PAYROLL PRODUCTNAME 1. VPN Hardware and Support HARDWARESUMMARY QUOTESUMMARY Utility Billing Services Discount-111,286.50 USD Utility Billing Services Total 59,923.50 USD Services Subtotal 546,635.00 USD Services Discount - 342,566.25 USD Services Total 204,068.75 USD QUANTITY UNIT PRICE TOTAL 1 2,700.00 2,700.00 Finance / HR /Payroll Hardware Total 2,700.00 USD Hardware Total 2,700.00 USD Software Subtotal Services Subtotal Hardware Subtotal 226,005.00 USD 546,635,00 USD 2,700.00 USD Quote Subtotal 775,340.00 USD CST-2024-102205 WHAT ARE THE RECURRING FEES? TYPE Discount-388,146.25 USD Quote Total 387,193.75 USD AMOUNT FIRST YEAR MAINTENANCE TOTAL 2,000.00 FIRST YEAR SUBSCRIPTION TOTAL 180,425.00 FIRSTYEAR RECURRING SERVICES TOTAL 0.00 The amount totals for Maintenance and/or Subscription on this quote include only the first year of software use and maintenance. Renewal invoices will include this total plus any applicable uplift amount as outlined in the relevant purchase agreement. CST-2024-102205 Payment Terms: Subscriptions: - If applicable, Annual Subscription Fees are due on the Delivery Date, and annually thereafter on the anniversary of the Delivery Date. - Annual Subscription Fees shall increase as follows: o Years 2 and 3 = no increase o Years 4 and 5 = 3% increase, due at time of renewal Services: Payment Schedule: Implementation Services 30% Due on Effective Date 20% Due at Project Kickoff 15% Due at completion of 151 End User Training Session 30% Due at Go Live 5% Due at completion of Reliability Period If applicable, non -fixed fee professional services shall be due as incurred on a time and materials basis. Non -fixed fee professional services are not included in the percentages outlined in the above Payment Schedule. If applicable, non -fixed fee travel expenses shall be due as incurred, invoiced monthly for the travel expenses of the preceding month. Non -fixed fee travel expenses are not included in the percentages outlined in the above Payment Schedule. If applicable, Fixed Fee travel expenses are included in the percentages outlined in the above Payment Schedule. Hardware: - If applicable, Non -subscription Hardware Fees are due on the Effective Date. Licenses: - If applicable, License Fees are due on the Delivery Date. Support & Maintenance - If applicable, Support & Maintenance Fees are due annually, starting prior to the first anniversary of the Delivery Date and annually thereafter. - Annual Software Maintenance Fees shall increase as follows: o Years 2 and 3 = no increase o Years 4 and 5 = 3% increase, due at time of renewal If applicable, legacy support and maintenance shall be due until the Delivery Date of the applicable replacement software. Any unused pre -paid support and maintenance shall be credited as a pro -rated amount towards the next applicable subscription software invoice due under this Agreement, or future invoice. Third Party: - If applicable, Third -Party Software Fees are due on the Effective Date. Third -Party software subscriptions and/or support fees shall be due annually thereafter on the anniversary of the Effective Date. Third -Party Software fees are subject to increase each year. - If applicable, Third -Party Services shall be due 50% at Effective Date, 25% at completion of 1 st End User Training Session, and 25% at Go Live. Invoice Terms: CentralSquare shall provide an invoice for the items in the schedule above no less than thirty (30) days prior to the due date. ANCILLARY FEES a. Customer is responsible for paying all taxes relating to this Agreement. Applicable tax amounts (if any) are not included in the fees set forth in this Agreement. If Customer is exempt from the payment of any such taxes, Customer must provide CentralSquare valid proof of exemption; otherwise, CentralSquare will invoice Customer and Customer will pay to CentralSquare all such tax amounts. CST-2024-102205 b. To the extent allowable bylaw, if Customer fails to make any payment when due, then CentralSquare may charge interest on the past due amount at the rate of 1.5% per month calculated daily and compounded monthly, or, if lower, the highest rate permitted under applicable law; and if such failure continues for 90 days following written notice thereof, CentralSquare may suspend performance or access until past due amounts have been paid. CST-2024-102205 EXHIBIT 2 Maintenance & Suoport This Maintenance & Support Exhibit describes support and maintenance relating to technical support that CentralSquare will provide to Customer during the Term of the Agreement. Product Updates and Releases 1.1. Software Version. "Software Version" means the base or core version of the Software that contains significant new features and significant fixes and is available to the Customer. Software Versions may occur as the Software architecture changes or as new technologies are developed. The nomenclature used for updates and upgrades consists of major, minor, build, and fix and these correspond to the following digit locations of a release, a,b,c,d. An example of which would be 7.4.1.3, where the 7 refers to the major release, the 4 refers to the minor release, the 1 refers to the build, and the 3 refers to a fix. All Software Versions are provided and included as part of this Agreement. 1.2. Updates. From time to time CentralSquare may develop permanent fixes or solutions to known problems or bugs in the Software and incorporate them in a formal "Update" to the Software. If Customer is receiving technical support from CentralSquare on the general release date for an Update, CentralSquare will provide the Customer with the Update and related Documentation at no extra charge. Updates for custom configurations will be agreed upon by the Parties and outlined in a Statement of Work or Change Order. 1.3. Releases. Customer shall agree to install and/or use any New or Major Release within one year of being made available by CentralSquare to avoid or mitigate a performance problem, ineligibility for Support and Maintenance Services or infringement claim. All modifications, revisions and updates to the Software shall be furnished by means of new Releases of the Software and shall be accompanied by updates to the Documentation whenever CentralSquare determines, in its sole discretion, that such updates are necessary. 2. Support 2.1. CentralSquare shall provide to Customer support via toll -free phone number 833-278-7877 or via the CentralSquare Support Portal. CentralSquare shall provide to Customer, commercially reasonable efforts in solving errors reported by the Customer as well as making available an online support portal. Customer shall provide to CentralSquare reasonably detailed documentation and explanation, togetherwith underlying data, to substantiate errors and to assist CentralSquare in its efforts to diagnose, reproduce and correct the error. Should either Party not be able to locate the error root cause and Customer and CentralSquare agree that on -site services are necessary to diagnose or resolve the problem CentralSquare shall provide a travel estimate and estimated hours in order to diagnose the reported error. 2.2. If after traveling onsite to diagnose a reported error and such reported error did not, in fact, exist or was not attributable to a defect in the Software provided by CentralSquare or an act or omission of CentralSquare, then Customer shall pay for CentralSquare's investigation, travel, and related services in accordance with provided estimate. Customer must provide CentralSquare with such facilities, equipment and support as are reasonably necessary for CentralSquare to perform its obligations under this Exhibit, including remote access in accordance with the Remote Access Policy. 3. Online Support Portal Online support is available via https://support.centralsouare.com/s/contact-us, offering Customer the ability to resolve its own problems with access to CentralSquare's most current information. Customer will need to enter its designated username and password to gain access to the technical support areas on CentralSquare's website. CentralSquare's technical support areas allow Customer to: (i) search an up-to-date knowledge base of technical support information, technical tips, and featured functions; and (ii) access answers to frequently asked questions (FAQ). 4. Exclusions from Technical Suoport Services CentralSquare shall have no support obligations to provide Support or Maintenance for Solutions that are not kept current to one version prior to the then current version of the Solution. CentralSquare shall have no support obligations with respect to any third -party hardware or software product not licensed or sold to Customer by CentralSquare ("Nonqualified Product"). Customer shall be solely responsible for the compatibility and functioning of Nonqualified Products with the Software. 5. Customer Responsibilities In connection with CentralSquare's provision of technical support as described herein, Customer acknowledges that Customer has the responsibility to do each of the following: 5.1 Provide hardware, operating system and browser software that meets technical specifications, as well as a fast, stable, high-speed connection and remote connectivity for accessing the Solution. 5.2 Maintain any applicable computer system and associated peripheral equipment in good working order in accordance with the manufacturers' specifications, and ensure that any problems reported to CentralSquare are not due to hardware malfunction; 5.3 For CentralSquare Solutions that are implemented on Customer Systems, maintain the designated operating system at the latest code revision level reasonably deemed necessary by CentralSquare for proper operation of the Software; 5.4 Supply CentralSquare with access to and use of all information and facilities reasonably determined to be necessary by CentralSquare to render the technical support described herein; CST-2024-102205 5.5 Perform any test or procedures reasonably recommended by CentralSquare for the purpose of identifying and/or resolving any problems; 5.6 At all times follow routine operator procedures as specified in the Documentation or any error correction guidelines of CentralSquare posted on the CentralSquare website; 5.7 Customer shall remain solely responsible at alltimes forthe safeguarding of Customer's proprietary, confidential, and classified information contained within Customer Systems; and 5.8 Reasonably ensure that the Customer Systems are isolated and free from viruses and malicious code that could cause harm before requesting or receiving remote support assistance. 6. Priorities and Su000rt Resoonse Matrix The following priority matrix relates to software errors covered by this Agreement. Causes secondary to non -covered causes - such as hardware, network, and third -party products - are not included in this priority matrix and are outside the scope of this Exhibit. CentralSquare will make commercially reasonable efforts to respond to Software incidents for live remote based production systems using the following guidelines: Priority Issue Definition Response Time Priority 1 — The software is completely down and will not Priority 1 issues mustbe called in via 833-278-7877 and Urgent launch or function. will be immediately answered and managed by the first available representative. Priority 2 — A high -impact problem that disrupts the Priority 2 issues must be called in via 833-278-7877 and Criticalcustomer's operation but there is capacity to will be immediately answered and managed by the first remain productive and maintain necessary available representative. operations. Priority 3 — A Software Error related to a user function which Priority 3 issues called in via 833-278-7877 will be Non -Critical does not negatively impact the User from the use immediately answered and managed by the first f the system. This includes system administrator available representative. unctions or restriction of user workflow but does of significantly impact theirjob function. Non -Critical Priority 3 issues may also be reported via Https:/Isupport.centralsquare.com/stcontact-us Priority 4— Cosmetic or documentation errors, including Priority 4 issues called in via 833-278-7877 will be Minor Customer technical questions or usability immediately answered and managed by the first questions. available representative. Minor Priority 4 issues may also be reported via Httr)s://support.centralsquare.com/s/contact-us 7. Exceptions. CentralSquare shall not be responsible for failure to carry out its Support and Maintenance obligations under this Exhibit if the failure is caused by adverse impact due to: 7.1. defectiveness of the Customers Systems (including but not limited to environment, hardware or ancillary systems), or due to Customer corrupt, incomplete, or inaccurate data reported to the Solution, or documented defect. 7.2. denial of reasonable access to Customer's System or premises preventing CentralSquare from addressing the issue. 7.3. material changes made to the usage of the Solution by Customer where CentralSquare has not agreed to such changes in advance and in writing or the modification or alteration, in any way, by Customer or its subcontractors, of communications links necessary to the proper performance of the Solution. 7.4. a Force Majeure event (as outlined in Section 12), or the negligence, intentional acts, or omissions of Customer or its agents. 8. Incident Resolution. Actual response times and resolutions may vary due to issue complexity and priority. For critical impact level and above, CentralSquare provides a continuous resolution effort until the issue is resolved. CentralSquare will make commercially reasonable efforts to resolve Software incidents for live remote based production systems using the following guidelines: CST-2024-102205 Priority Resolution Process Resolution Time Priority 1 — Urgent CentralSquare will provide a CentralSquare will work continuously to provide the Customer procedural or configuration with a solution that allows the Customer to resume live workaround or a code correction that operations on the production system. allows the Customer to resume live CentralSquare will either resolve the issue or provide a resolution operations on the production System. plan as soon as possible and not later than twenty-four (24) hours after notification. Priority 2 — CentralSquare will provide a CentralSquare will work continuously to provide the Customer procedural or configuration with a solution that allows the Customer to resume normal Critical workaround or a code correction that operations on the production System. allows the Customer to resume normal operations on the production CentralSquare will either resolve the issue or provide a resolution System. plan as soon as possible and not later than thirty-six (36) hours after notification. Priority 3 — Non — CentralSquare will provide a CentralSquare will work to provide the Customer with a Critical procedural or configuration resolution which may include a workaround or code correction workaround that allows the Customer within a timeframe that takes into consideration the impact of o resolve the problem. the issue on the Customer and CentralSquare's User base. Priority 3 issues have priority scheduling in a subsequent release. Priority 4 — Minor If CentralSquare determines that a CentralSquare will work to provide the Customer with a reported Minor Priority error resolution which may include a workaround or code correction requires a code correction, such in a future release of the software. Priority 4 issues have no issues will be addressed in a efined resolution time. ubsequentrelease when �pplicable. 9. Non -Production Environments. CentralSquare will make commercially reasonable efforts to provide fixes to non - production environment(s). Non -production environments are not included under the response or resolution tables provided in this Exhibit. 9.1. Maintenance. All non -production environment resolution processes will follow the structure and schedules outlined above for production environments. 9.2. Incidents and service requests. Non -production environment incidents are considered priority 3 or 4, dictated by circumstances and will be prioritized and scheduled subordinate to production environment service requests. 10. Training. Outside the scope of training services purchased, if any, Customer is responsible for the training and organization of its staff in the operation of the Software. 11. Development Work. Software support and maintenance does not include development work either (i) on software not licensed from CentralSquare or (ii) development work for enhancements or features that are outside the documented functionality of the Software, except such work as may be specifically purchased and outlined in the Agreement. CentralSquare retains all intellectual property rights in development work performed and Customer may request consulting and development work from CentralSquare as a separate billable service. 12. Technology Life Expectancy. Customer understands, acknowledges and agrees that the technology upon which the Hardware, Solution and Third -Party Software is based changes rapidly. Customer further acknowledges that CentralSquare will continue to improve the functionality and features of the Solution to improve legal compliance, accuracy, functionality and usability. As a result, CentralSquare does not represent or warrant that the Hardware, Solution and/or Third -Party Software provided to Customer under this Agreement or that the Customer Systems recommended by CentralSquare will function for an indefinite period of time. Rather, CentralSquare and Customer may, from time to time, analyze the functionality of the Hardware, Solution, Third -Party Software and Customer Systems in response to changes to determine whether Customer must upgrade the same. Customer upgrades may include without limitation, the installation of a new Release, additional disk storage and memory, and workstation and/or server upgrades. Customer upgrades may also include the installation and/or removal of Third -Party Software. Customer is solely responsible for all costs associated with future resources and upgrades. CST-2024-102205 EXHIBIT 3 CentralSquare Access Management Policy In order to provide secure, federally compliant connections to agency systems CentralSquare Technologies ("CentralSquare") requires BeyondTrust or SecureLink as the only approved methodology of connection. BeyondTrust and Securelink provide the necessary remote access in order to service and maintain CentralSquare products while adhering to the Federal Bureau of Investigations Criminal Justice Information Services requirements. Both solutions utilize two -factor authentication Federal Information Processing Standard Publication ("FIPS") 140-2 validated cryptographic modules and AES encryption in 256-bit strengths. BeyondTrust and Securelink are addressed in turn via this Access Management Policy; Customers may choose which remote privileged access management solution will be utilized by CentralSquare. BeyondTrust The BeyondTrust remote support solution may be utilized via escorted session or a jump Customer. As for an escorted session, when an agency needs assistance from CentralSquare, the agency employee requesting assistance will receive verbal or email communication with a session key necessary to enable remote access. If a verbal key is provided, the user enters the session key after visiting https://securesupport.centralsguare.com. Jump Customers are a Windows service that can be stopped/started to facilitate a support session. Connections made via jump Customer can be active or passive. An active jump Customer is always available. A passive connection is enabled for a specific purpose and then disabled when not used. Regardless of the option selected, CentralSquare's support team will arrange a BeyondTrust session to establish the jump Customer. The jump Customer resides on the agency side on the installed device, where an agency administrator can manage. Instructions on how to enable/disable jump Customers can be provided upon request. A sample workflow of a passive jump Customer is provided below: Should an agency require support from CentralSquare, a call would be placed and/or a support ticket opened in the portal on the CentralSquare customer support website. Before accessing the agency's system and/or environment, the CentralSquare representative would send a notice of connection from the CentralSquare support portal instance. This notice can be sent to the individual at the agency that the CentralSquare representative is working with or other designated contacts as necessary. Upon receipt of the notice of connection, the agency personnel would enable the BeyondTrust jump Customer. The CentralSquare representative would then be admitted to the agency's system and/or environment to perform the necessary task. Upon completion of the task, the CentralSquare representative sends a notice of disconnection from the CentralSquare support portal instance. Upon receipt of the notice of disconnection, the agency personnel would then disable the BeyondTrustjump Customer. Securelink Similar to BeyondTrust's escorted session, Securelink may be utilized via "quick connect". To enable a quick connect session when an agency needs assistance from CentralSquare, the Agency employee requesting assistance will enter a key code in order to connect for screen sharing on a device. Similar to the jump Customer methodology, SecureLink may also be utilized via "gatekeeper". The sample workflow description for a jump Customer provided above is substantially similar to the workflow for gatekeeper. Summation BeyondTrust and Securelink allow customers the ability to monitor connectivity to the customer's network and maintain CJIS compliance while enabling CentralSquare to perform the necessary support functions. CST-2024-102205 CERTIFICATE OF LIABILITY INSURANCE D oi22J2024 YYY) THIS CERTIFICATE IS ISSUED AS A MATTER OF INFORMATION ONLY AND CONFERS NO RIGHTS UPON THE CERTIFICATE HOLDER. THIS CERTIFICATE DOES NOT AFFIRMATIVELY OR NEGATIVELY AMEND, EXTEND OR ALTER THE COVERAGE AFFORDED BY THE POLICIES BELOW. THIS CERTIFICATE OF INSURANCE DOES NOT CONSTITUTE A CONTRACT BETWEEN THE ISSUING INSURER(S), AUTHORIZED REPRESENTATIVE OR PRODUCER, AND THE CERTIFICATE HOLDER. IMPORTANT: If the certificate holder is an ADDITIONAL INSURED, the policy(ies) must have ADDITIONAL INSURED provisions or be endorsed. If SUBROGATION IS WAIVED, subject to the terms and conditions of the policy, certain policies may require an endorsement. A statement on this certificate does not confer rights to the certificate holder in lieu of such endorsement(s). PRODUCER MARSH USA, LLC. TWO ALLIANCE CENTER 3560 LENOX ROAD, SUITE 2400 ATLANTA, GA 30326 CONTACT NAME: „__ PHONE FAX N Exit- WC, No): E-MAIL -- ADDRESS: INSURERS AFFORDING COVERAGE NAIC# INSURER A: The Charter Oak Fire Insurance Co. 25615 CN730114897-EO/GGAWU-24-25 INSURED CSUREDquare Technologies, LLC INSURER B: Phoenix Insurance Company 25623 -- INSURER C: Travelers Property Cmijally CumparyfAmerica 25674 1000Business Center Drive Lake Mary, FL 32746 INSURER D: Travelers CasualtyAnd Surety Company19036 INSURERE; AIG SpeCialf, insurance Company 26883 INSURER F : COVERAGES CERTIFICATE NUMBER: ATL-005617725-00 REVISION NUMBER: O THIS IS TO CERTIFY THAT THE POLICIES OF INSURANCE LISTED BELOW HAVE BEEN ISSUED TO THE INSURED NAMED ABOVE FOR THE POLICY PERIOD INDICATED. NOTWITHSTANDING ANY REQUIREMENT, TERM OR CONDITION OF ANY CONTRACT OR OTHER DOCUMENT WITH RESPECT TO WHICH THIS CERTIFICATE MAY BE ISSUED OR MAY PERTAIN, THE INSURANCE AFFORDED BY THE POLICIES DESCRIBED HEREIN IS SUBJECT TO ALL THE TERMS, EXCLUSIONS AND CONDITIONS OF SUCH POLICIES. LIMITS SHOWN MAY HAVE BEEN REDUCED BY PAID CLAIMS. INSR LTR TYPE OF INSURANCE ADDLSUBR POLICY NUMBER POLICY EFF MM/DDIYYri POLICY EXP MMIDDIYYYY LIMITS A X COMMERCIAL GENERAL LIABILITY CLAIMS -MADE FIOCCUR X H-650-6S75B660-COF-24 08/31/2024 08/31/2025 EACH OCCURRENCE $ 1,000,000 DAMA ISEEST PREMEa occurrence $ 1,000,000 MED EXP(My one person) $ 10,0DO S ADV INJURY $ 1,000,000 GEN'L AGGREGATE LIMIT APPLIES PER: AGGREGATE $ 2,000,000 X POLICY ECT LOC S-COMP/OP AGG $ 2,000,000 $ OTHER: B AUTOMOBILE LIABILITY X BA.6S783539-24-13-G OM112024 001/2025 tSINGLE LIMIT Mo 1,000,000 URY(Per parson) $ ANY AUTO OWNED SCHEDULED AUTOS ONLY AUTOSHIRED URY(Per a_,do 0 $ NON -OWNED AUTOS ONLY X AUTOS ONLY DAMAGEX nt $ C UMBRELLA LIAR OCCUR X CUP-6SBO1390-24-13 OB/31/2024 001/2025 EACH OCCURRENCE $ 10,000,000 _XJ AGGREGATE S 10,000,000 EXCESS LIAR CLAIM$ -MADE DED I X I RETENTION$ 10 000 $ D WORKERS COMPENSATION AND EMPLOYERS' LIABILITY YIN ANYPROPRIETORIPARTNEWEXECUTIVE OFFICERIMEMBEREXCLUDED? (Mandatory In NH) NIA UB-6S78366B-24-13.G 08/31/2024 08/31/2025 PER orH- X STATUTE ER E.L. EACH ACCIDENT $ 1,000,000 E.L. DISEASE -EA EMPLOYEE $ 1,000,000 If yes, describe under DESCRIPTION OF OPERATIONS below E.L. DISEASE -POLICY LIMIT S 1,000,000 E E80/Cyber OIA92-21-01 OB/31/2024 08131/2025 Limit 5,000,000 SIR 1,000,000 DESCRIPTION OF OPERATIONS I LOCATIONS / VEHICLES (ACORD 101, Additional Remarks Schedule, may be attached if more space is required) The City of Owasso, its officers, officials and employees are included as additional insureds with respect to liability arising out of the operations and to the extent provided by the policy language or endorsements issued or approved by the insurance carrier. City of Owasso 200 S. Main Owasso, OK 74055 LefdTC PJ a111L'\LL9PI SHOULD ANY OF THE ABOVE DESCRIBED POLICIES BE CANCELLED BEFORE THE EXPIRATION DATE THEREOF, NOTICE WILL BE DELIVERED IN ACCORDANCE WITH THE POLICY PROVISIONS. AUTHORIZED REPRESENTATNE of Marsh USA LLC © 1988-2016 ACORD ACORD 25 (2016103) The ACORD name and logo are registered marks of ACORD AGENCY CUSTOMER ID: CN130114897 LOC #: Atlanta ADDITIONAL REMARKS SCHEDULE Page 2 of 2 AGENCY NAMEDINSURED MARSH USA, LLC. CentralSquare Technologies, LLC 1000 Business Center Drive POLICY NUMBER Lake Mary,FL 32746 CARRIER I NAIC CODE EFFECTIVE DATE: ADDITIONAL REMARKS THIS ADDITIONAL REMARKS FORM IS A SCHEDULE TO ACORD FORM, FORM NUMBER: 25 FORM TITLE: Certificate of Liability Insurance Excess E&O/Cybor. Carder. Indian Harbor Insurance Company Policy Number: MTE9043949 03 Effective Date: 08/312024 Expiration Date: 08/312025 LImdt $5M x $5M ACORD 101 (2008101) © 2008 ACORD CORPORATION. All Hants reserved The ACORD name and logo are registered marks of ACORD POLICY NUMBER: BA-6S783539-24-13-G COMMERCIAL AUTO THIS ENDORSEMENT CHANGES THE POLICY. PLEASE READ IT CAREFULLY. BLANKET ADDITIONAL INSURED - PRIMARY AND NON-CONTRIBUTORY WITH OTHER INSURANCE This endorsement modifies insurance provided under the following: BUSINESS AUTO COVERAGE FORM PROVISIONS 1. The following is added to Paragraph A.1.c., Who Is An Insured, of SECTION 11 — COVERED AUTOS LIABILITY COVERAGE: This includes any person or organization who you are required under a written contract or agreement between you and that person or organization, that is signed by you before the °bodily injuryo or "property damage" occurs and that is in effect during the policy period, to name as an additional insured for Covered Autos Liability Coverage, but only for damages to which this insurance applies and only to the extent of that person's or organization's liability for the conduct of another •insured°. 2. The following Is added to Paragraph BS.. Other Insurance of SECTION IV — BUSINESS AUTO CONDITIONS: Regardless of the provisions of paragraph a. and paragraph d. of this part 5.Other Insurance, this Insurance is primary to and noncontributory with applicable other Insurance under which an additional insured person or organization is the first named insured when the written contract or agreement between you and that person or organization, that is signed by you before the 'bodily injury" or "property damage" occurs and that is in effect during the policy period, requires this insurance to be primary and non-contributory. CA T4 74 02 16 © 2016 The Travelers Indemnity Company. All rights reserved. Page 1 Of 1 Includes copyrighted material of Insurance Services Office, Inc. with its permission. POLICY NUMBER: H-660-6S758660-COF-24 COMMERCIAL GENERAL LIABILITY NT CHANGES THE POLICY. PLEASE READ IT CAREFULLY. BLANKET ADDITIONAL INSURED (Includes Products -Completed Operations If Required By Contract) This endorsement modifies insurance provided under the following: COMMERCIAL GENERAL LIABILITY COVERAGE PART PROVISIONS The following is added to SECTION 11— WHO IS AN INSURED: Any person or organization that you agree In a written contract or agreement to include as an additional insured on this Coverage Part Is an insured, but only: a. With respect to liability for "bodily Injury" or "property damage" that occurs, or for "personal injury' caused by an offense that is committed, subsequent to the signing of that contract or agreement and while that part of the contract or agreement is in effect; and b. ff, and only to the extent that, such Injury or damage is caused by acts or omissions of you or your subcontractor in the performance of "your work" to which the written contract or agreement applies. Such person or organization does not qualify as an additional insured with respect to the independent acts or omissions of such person or organization. The insurance provided to such additional insured is subject to the following provisions: a. If the Limits of Insurance of this Coverage Part shown In the Declarations exceed the minimum limits required by the written contract or agreement, the insurance provided to the additional insured will be limited to such minimum required limes. For the purposes of determining whether this limitation applies, the minimum limits required by the written contractor agreement will be considered to include the minimum limits of any Umbrella or Excess liability coverage required for the additional insured by that written contract or agreemerrL This provision will not Increase the limits of insurance described in Section III — Limits Of Insurance. (1) Any "bodily injury", "property damage" or "personal injur arising out of the providing, or failure to provide, any professional architectural, engineering or surveying services, including: (a) The preparing, approving, or failing to prepare or approve, maps, shop drawings, opinions, reports, surveys, field orders or change orders, or the preparing, approving, or fairing to prepare or approve, drawings and specifications; and (b) Supervisory, inspection, architectural or engineering activities. (2) Any Wwdiy injury' or "properly damage" caused by "your work" and included in the 'products -completed operations hazard' unless the written contract or agreement specificaly requires you to provide such coverage for that additional Insured during the policy period. c. The additional insured must comply with the following duties: (1) Give us written notice as soon as practicable of an "occurrence" or an offense which may result in a claim. To the extent possible, such notice should include: (a) How, when and where the "occurrence" or offense took place; (b) The names and addresses of any injured persons and witnesses; and (c) The nature and location of any injury or damage arising out of the "occurrence" or offense. It. The insurance provided to such additional (2) ff a claim is made or "suit" is brought against insured sloes not apply to: the additional insured: CG D2 46 0419 0 2018 The Travelers Indemnity company. At drgPds reserved. Page 1 of 2 POLICY NUMBER: H-660-6S758660-COF-24 COMMERCIAL GENERAL LIABILITY (a) Immediately record the specifics of the claim or "suit" and the date received; and (b) Notify us as soon as practicable and see to it that we receive written notice of the claim or "suit" as soon as practicable. (3) Immediately send us copies of all legal papers received in connection with the claim or "suit, cooperate with us in the investigation or settlement of the claim or defense against the "suit", and otherwise comply with all policy condiUans. (4) Tender the defense and Indemnity of any claim or "suit" to any provider of other Insurance which would cover such additional insured for a loss we cover. However, this condition does not affect whether the insurance provided to such additional insured is primary to other Insurance available to such additional insured which covers that person or organization as a named insured as described in Paragraph 4, Other Insurance, of Section IV — Commercial General Liability Conditions. Page 2 of 2 0 2018 The Travelers Indemnity Company. Al dghls reserved. CIS D2 46 0419 POLICY NUMBER: H-660-6S758660-COF-24 COMMERCIAL GENERAL LIABILITY THIS ENDORSEMENT CHANGES THE POLICY. PLEASE READ IT CAREFULLY. PRIMARY AND NONCONTRIBUTORY - OTHER INSURANCE CONDITION This endorsement modifies insurance provided under the following: COMMERCIAL GENERAL LIABILITY COVERAGE PART LIQUOR LIABILITY COVERAGE PART PRODUCTS/COMPLETED OPERATIONS LIABILITY COVERAGE PART The fallowing Is added to the Other Insurance (1) The additional insured Is a Named Condition and supersedes any provision to the Insured under such other insurance: and contrary. Prima And Noncontributory Insurance (z) You have agreed in writing r a contract Primary rY or agreement that this insurance would This insurance is primary to and will not seek be primary and would not seek contribution from any other insurance available contribution from any other insurance to an additional insured under your policy available to the additional insured. provided that: CG 20 01 1219 0 Insurance Services Office, Inc.. 2018 Page 1 of 1 POLICY NUMBER: H-660-6S758660-COF-24 COMMERCIAL GENERAL LIABILITY THIS ENDORSEMENT CHANGES THE POLICY. PLEASE READ IT CAREFULLY. XTEND ENDORSEMENT FOR TECHNOLOGY This endorsement modifies insurance provided under the following: COMMERCIAL GENERAL LIABILITY COVERAGE PART GENERAL DESCRIPTION OF COVERAGE — This endorsement broadens coverage. However, coverage for any injury, damage or medical expenses described In any of the provisions of this endorsement may be excluded or limited by another endorsement to this Coverage Part, and these coverage broadening provisions do not apply to the extent that coverage is excluded or limited by such an endorsement. The following listing is a general coverage description only. Read all the provisions of this endorsement and the rest of your policy carefully to determine rights, duties, and what is and is not covered. A. Non -Owned Watercraft— 75 Feet Long Or Less B. Who Is An Insured — Unnamed Subsidiaries C. Who is An Insured — Employees — Supervisory positions D. Who Is An Insured — Newly Acquired Or Formed Limited LiabilityCompanies E. Who Is An Insured — Liability For Conduct Of Unnamed Partnerships Or Joint Ventures F. Blanket Additional Insured —persons Or Organizations For Your Ongoing Operations As Required By Written Contract Or Agreement G. Blanket Additional Insured —Broad Form Vendors H. Blanket Additional Insured —Controlling Interest PROVISIONS A NON -OWNED WATERCRAFT — 7S FEET LONG OR LESS 1. The following replaces Paragraph (2) of Exclusion g., Aircraft, Auto Or Watercraft, in Paragraph 2. of SECTION 1 — COVERAGES — COVERAGE A — BODILY INJURY AND PROPERTY DAMAGE LIABILITY: (2) A watercraft you do riot own that is: (a) 75 feet long or less; and (b) Not being used to carry any person or property for a charge; 2. The following replaces Paragraph 2.e. of SECTION II — WHO IS AN INSURED: e. Any person or organization that, with your express or implied consent, either uses or 1. Blanket Additional Insured — Mortgagees, Assignees, Successors Or Receivers J. Blanket Additional Insured —Governmental Entities — Permits Or Authorizations Relating To Premises K. Blanket Additional Insured —Governmental Entities — Permits Or Authorizations Relating To Operations L. Medical Payments — Increased Limit M. Blanket Waiver Of Subrogation N. Contractual Liabilty—Railroads O. Damage To Premises Rented To You is responsible for the use of a watercraft that you do not own that is: (1) 75 feet long or less; and (2) Not being used to carry any person or property for a charge. B. WHO IS AN INSURED — UNNAMED SUBSIDIARIES The following is added to SECTION 11— WHO IS AN INSURED: Any of your subsidiaries, other than a partnership or joint venture, that is not shown as a Named Insured in the Declarations is a Named Insured if: a. You are the sole owner of, or maintain an ownership Interest of more than 50% in, such subsidiary on the first day of the policy period; and b. Such subsidiary is not an insured under similar other Insurance. CIS D417 0219 0 2017 The Travelers Indemnity Company. All rights reserved. Page 1 of 5 Includes copyrighted material of Insurance services Office, Inc. wlth its permission. POLICY NUMBER: H-660-6S758660-COF-24 COMMERCIAL GENERAL LIABILITY No such subsidiary is an insurers for "bodily injury' or "property damage" that occurred, or "personal and advertising injury' caused by an offense committed: a. Before you maintained an ownership interest of more than W% in such subsidiary; or b. After the date, if any, during the policy period that you no longer maintain an ownership interest of more than 50% in such subsidiary. For purposes or Paragraph 1. of Section 11— Who Is An Insured, each such subsidiary will be deemed to be designated in the Declarations as: a. A limited liability company; b. An organization other than a partnership, joint venture or limited liability company; or c. A trust; as indicated in its name or the documents that govem its structure. C. WHO IS AN INSURED — EMPLOYEES — SUPERVISORY POSITIONS The following is added to Paragraph 2.a.(1) of SECTION 11—WHO IS AN INSURED: Paragraphs (1)(a), (b) and (c) above do not apply to "bodily iryury" to a co -"employee" while in the course of the co -"employee's" employment by you arising out of wok by any of your "employees" who hold a supervisory position. D. WHO IS AN INSURED — NEWLY ACQUIRED OR FORMED LIMITED LIABILITY COMPANIES The following replaces Paragraph 3. of SECTION 11— WHO IS AN INSURED: 3. Any organization you newly acquire or form, other than a partnership or joint venture, and of which you are the sole owner or in which you maintain an ownership interest of more than 50%,, will qualify as a Named Insured if there is no other similar insurance available to that organization. However: a. Coverage under this provision is afforded only. (1) Until the 1801h day after you acquire or form the organization or the and of the policy period, whichever Is earlier, If you do not report such organization in writing to us within 180 days after you acquire or form It or (2) Until the and or the policy period, when that date Is later than ISO days after you acquire or form such organization, if you report such organization in writing to us within 180 days after you acquire or form it, b. Coverage A does not apply to "bodily injury or"property damage that occurred before you acquired or formed the organization; and c. Coverage B does not apply to "personal and advertising injury" arising out of an offense committed before you acquired or formed the organization. For the purposes of Paragraph 1. of Section 11 — Who Is An Insured, each such organization will be deemed to be designated in the Declarations as: a. A limited liability company; b. An organization, other than a partnership, joint venture or limited liability company; or c. A trusty as indicated in its name or the documents that govern its structure. E. WHO IS AN INSURED — LIABILITY FOR CONDUCT OF UNNAMED PARTNERSHIPS OR JOINT VENTURES The following replaces the last paragraph of SECTION 11—WHO IS AN INSURED: No person or organization is an insured with respect to the conduct of any current or past partnership or joint venture that is not shown as a Named Insured in the Declarations. This paragraph does not apply to any such partnership or joint venture that otherwise qualifies as an Insured under Section li — Who Is An Insured. F. BLANKET ADDITIONAL INSURED — PERSONS OR ORGANIZATIONS FOR YOUR ONGOING OPERATIONS AS REQUIRED BY WRITTEN CONTRACT OR AGREEMENT The following is added to SECTION II — WHO IS AN INSURED: Any person or organization that is not otherwise an insured under this Coverage Part and that you have agreed in a written contract or agreement to include as an additional insured on this Coverage Part is an insured, but only with respect to lability for "bodily injury' or "property damage" that: a. Occurs subsequent to the signing of that contract or agreement and Ir. Is caused, in whole or in part, by your acts or omissions In the performance of your ongoing operations to which that contract or Page 2 of 5 0 2017 The Travelers Indemrdty company. All rights reserved. CG D417 0219 Includes copyrighted material of Insurance Services 0111co, Inc, with its permisslom POLICY NUMBER: H-660-6S758660-COF-24 agreement applies or the acts or omissions of any person or organization performing such operations on your behalf. The limits of insurance provided to such insured will be the minimum limits that you agreed to provide in the written contract or agreement, or the limits shown in the Declarations, whichever are less. G. BLANKET ADDITIONAL INSURED — BROAD FORM VENDORS The following is added to SECTION II — WHO IS AN INSURED: Any person or organization that is a vendor and that you have agreed in a written contract or agreement to include as an additional insured on this Coverage Part is an insured, but only with respect to liability for "bodly injury" or "property damage" that: a. Occurs subsequent to the signing of that contract or agreement; and b. Arises out of "your products" that are distributed or sold in the regular course of such vendor's business. The insurance provided to such vendor is subject to the following provisions: a. The limits of insurance provided to such vendor will be the minimum limits that you agreed to provide in the written contract or agreement or the limits shown in the Declarations, whichever are less. COMMERCIAL GENERAL LIABILITY performed at such vendor's premises in connection with the sale of °your products"; or (6) "Your products" that, after distribution or sale by you. have been labeled or relabeled or used as a container, part or ingredient of any other thing or substance by or on behalf of such vendor. Coverage under this provision does not apply to: a. Any person or organization from whom you have acquired "your products", or any Ingredient, part or container entering into, accompanying or containing such products; or b. Any vendor for which coverage as an additional insured specifically is scheduled by endorsement. H. BLANKET ADDITIONAL INSURED — CONTROLLING INTEREST 1. The following is added to SEC71ON II —WHO IS AN INSURED: Any person or organization that has financial control of you is an insured with respect to liability for "bodily injury", "property damage" or "personal and advertising injury" that arises out of: b. The insurance provided to such vendor does not apply to: (1) Any express warranty not authorized by you or any distribution or sale for a purpose not authorized by you; (2) Any change in "your products" made by such vendor, (3) Repackaging, unless unpacked solely for the purpose of inspection, demonstration, testing, or the substitution of parts under Instructions from the manufacturer, and I then repackaged in the original container, (4) Any failure to make such inspections, adjustments, tests or servicing as vendors agree to perform or normally undertake to perform In the regular cause of business, in connectio n with the distribution or sale of "your products"; (5) Demonstration, installation, servicing or repair operations, except such operations a. Such financial control; or b. Such person's or organizations ownership, maintenance or use of premises leased to or occupied by you. The insurance provided to such person or organization does not apply to structural alterations, new construction or demolition operations performed by or on behalf of such person or organization. 2. The following is added to Paragraph 4. or SECTION If —WHO IS AN INSURED: This paragraph does not apply to any premises owner, manager or lessor that has financial control of you. BLANKET ADDITIONAL INSURED — MORTGAGEES, ASSIGNEES, SUCCESSORS OR RECEIVERS The following is added to SECTION II — WHO IS AN INSURED: Any person or organization that Is a mortgagee, assignee, successor or receiver and that you have agreed in a written contract or agreement to Include as an additional insured on this Coverage Part Is an insured, but only with respect to its CG D417 0219 O inn The Travelers Indemnity company. All rights reserved. Page 3 of 5 Includes rApydghted material of Insurance Services Office, Inc. with Its permission. POLICY NUMBER: H-660-6S758660-COF-24 COMMERCIAL GENERAL LIABILITY liability as mortgagee, assignee, successor or receiver for "bodily Injury", "property damage" or "personal and advertising injury' that a. Is "bodily injury' or "property damage" that occurs, or is 'personal and advertising injury' caused by an offense that is committed, subsequent to the signing of that contract or agreement: and b. Arises out of the ownership, maintenance or use of the premises for which that mortgagee, assignee, successor or receiver is required under that contract or agreement to be included as an additional insured on this Coverage Part. The insurance provided to such mortgagee, assignee, successor or receiver is subject to the following provisions: a. The limits of insurance provided to such mortgagee, assignee, successor or receiver will be the minimum limits that you agreed to provide in the written contract or agreement, or the limits shown in the Declarations, whichever are less. b. The insurance provided to such person or organization does not apply to: (1) Any "bodily injury' or "property damage• that occurs, or any "personal and advertising injury' caused by an offense that is committed, after such contract or agreement is no longer In effect or (2) Any "bodily injury, "property damage" or "personal and advertising injury" arising out of any structural alterations, new construction or demolition operations performed by or on behalf of such mortgagee, assignee, successor or receiver. J. BLANKET ADDITIONAL INSURED — GOVERNMENTAL ENTITIES — PERMITS OR AUTHORIZATIONS RELATING TO PREMISES The following is added to SECTION If — WHO IS AN INSURED: Any governmental entity that has issued a permit or authorization with respect to premises owned or occupied by, or rented or loaned to, you and that you are required by any ordinance, law, building code or written contract or agreement to include as an additional insured on this Coverage Part is an insured, but only with respect to liability for "bodily injury", "property damage" or "personal and advertising injury' arising out of the existence, ownership, use, maintenance, repair, construction, erection or removal of any of the following for which that governmental entity has issued such permit or authorization: advertising signs, awnings, canopies, cellar entrances, coal holes, driveways, manholes, marquees, hoist away openings, sidewalk vaults, elevators, street banners or decorations. K. BLANKET ADDITIONAL INSURED — GOVERNMENTAL ENTRIES — PERMITS OR AUTHORIZATIONS RELATING TO OPER- ATIONS The following is added to SECTION 11— WHO IS AN INSURED: Any governmental entity that has issued a permit or authorization with respect to operations performed by you or on your behalf and that you are required by any ordinance, law, building code or written contract or agreement to include as an additional insured on this Coverage Part is an insured, but only with respect to liability for "bodily injury", "prop" damage" or "personal and advertising injury" arising out of such operations. The insurance provided to such governmental entity does not apply to: a. Any "bodily injury', 'property damage" or "personal and advertising injury" arising out of operations performed for the governmental entity; or b. Any "bodily injury" or "property damage" Included in the "products -completed operations hazard L MEDICAL PAYMENTS— INCREASED LIMIT The following replaces Paragraph 7. of SECTION III — LIMITS OF INSURANCE: 7. Subject to Paragraph S. above, the Medical Expense Limit is the most we will pay under Coverage C for all medical expenses because of "bodily injury sustained by any one person, and will be the higher oF. a. $10,000;or b. The amount shown in the Declarations of this Coverage Part for Medical Expense Limit M. BLANKET WAIVER OF SUBROGATION The following is added to Paragraph a., Transfer Of Rights Of Recovery Against Others To Us, of SECTION IV — COMMERCIAL GENERAL LIABILITY CONDITIONS: If the insured has agreed in a contact or agreement to waive that insured's right of recovery against any person or organization, we Page 4 of 5 0 2017 The Travelers Indemnity Company. All duets reserved. CG D417 02 19 Includes copyrighted materml of Insurance services Once, Inc. with Its permisslon. POLICY NUMBER: H-660-6S758660-COF-24 waive our right of recovery against such person or orgardzation. but ordy for payments we make because of: a. 'Bodiy injury' or 'property damage that occws; or b. "Personal and advertising injury" caused by an offense that is committed; subsequent to the execution of the contract or agreement N. CONTRACTUAL LUIBILITN—RAILROADS 1. The following replaces Paragraph a of the defurfion of "insured contract" in the DEFINITIONS Section: c. Any easement or license agreement COMMERCIAL GENERAL LIABILITY 2. Paragraph f.(1) of the definition of insured contract" in the DEFINITIONS Section is deleted. O. DAMAGE TO PREMISES RENTED TO YOU The following replaces the defimiton of 'premises damage' in the DEFINITIONS Section: 'Premises damage" means "property damage" to: a. Any premises while rented W you or temporarily occupied by you with permission of the owner, or Is. The contents of any premises while such premises is rented to you, if you rent such premises for a period of seven or fewer consecutive days. CG D417 0219 0 2017 The travelers Indemnity Company. at rights reserved. Page 5 of 5 Includes copyrighted ma%edal of Insurance Sendces Office. Im with Its pennlsslon. EXHIBIT 5 Statement of Work [attached] CST-2024-102205 Implementation Statement of Work Project: Owasso, OK— Finance Enterprise and HR/Payroll, Community Development, CentralSquare Utility Billing CentralSquare is implementing a configurable, commercially available, off -the -shelf solution. The parties mutually agree and acknowledge this Statement of Work (SOW) is to be a planning document, not the detailed requirements or design of the solution. This Statement of Work (SOW) defines the services and deliverables that CentralSquare will be providing in accordance with the terms and conditions of the Agreement (the "Agreement") between CentralSquare Technologies, LLC (CentralSquare) and Owasso, OK ("Customer"). This project description includes the services and deliverables specified by the Agreement, including if applicable, CentralSquare and services, Subcontractor activities, third -party products, and services for the implementation of the System and Subsystems specified in the Agreement (collectively the "Project"). The number and type of software licenses, products, or services provided by CentralSquare, or its Subcontractors are specifically listed in the Agreement and any reference within this document as well as Subcontractors' SOWS (if applicable) do not imply or convey a software, license, or services that are not explicitly listed in the Agreement. Parties agree the Project Introduction Meeting will be scheduled within thirty (30) days from the Effective Date of the Agreement. Scope of Project The project includes the CentralSquare core systems, Finance Enterprise and HR/Payroll, Community Development and CentralSquare Utility Billing, as detailed in the Appendices. Services Scope The following outlines the proposed methodology for the project management, consulting, configuration, testing, training, and other services work necessary for the implementation of the contracted products. Details related to the activities for each application included in this project can be found in the Appendices of this SOW. Project Teams Project teams from all parties will include functional experts, technical resources, and decision makers. Resource management is critical to success, for all parties. CentralSquare and the Customer agree to make all necessary arrangements to ensure resources are available at each stage to ensure timelines are met. Project Management Methodology The implementation is conducted by a cross -functional team of experts from several departments within CentralSquare led by the assigned Project Manager. A phased approach to project management is followed to ensure the critical services are consistent and results are achieved. Phases include: Initiation: This phase includes the contract execution and transition to the Service Delivery team. CentralSquare may schedule an all -team meeting to kick off the project. The kickoff meeting will include time for the project managers from both teams to review all contractual documentation and begin the process of finalizing the integrated project schedule. Morning: During the planning phase, the project managers from both teams will meet to discuss all tasks and resources necessary to successfully complete implementation. The project team from CentralSquare will be finalized, project governance will be established, and a communications plan will be drafted and shared with the parties. Deliverables during the planning phase include the integrated baseline project schedule, communications plan, resource plan, and governance plan. Monitor and Control: Throughout the project, the project managers will work together on monitoring and controlling the overall project health. This includes regular status meetings/reports, quality reviews, managing risks/issues, and managing resources. Project managers will work together to manage the overall timeline, scope, and respective budgets, as well as ensuring the customers objectives are being met along the way. Any items determined to be out of scope will be immediately addressed by Central Square and customer Project Manager. Project governance is essential to establishing a decision making and communications model for the project. Key stakeholders will be identified by all parties and regular status meetings will be scheduled to review the project health, risks to timeline/budget, and issues that may block forward progress. Deliverables during this phase include regular status reports, risk/issue log, regular stakeholder meetings, and all project schedule updates. Proiect Close Out: The final stage of the project includes an introduction and transition to the Customer Support team and the Customer Success team. During transition, the project managers will work together to conduct an audit of tasks and deliverables associated with the project. Any mutually agreed upon delayed deliverables will be scheduled for post go -live and documented. Any contracted post go -live activities will be reviewed and scheduled as necessary before transition to Customer Support. Communication Proiect Status Cadence Meetings: Project status cadence meetings, scheduled as determined by the CentralSquare and Customer Project Managers, establish the status of the project; achievements over a defined iterative period, risk mitigation, issue review, and assurance of awareness of upcoming activities. Continuity in the meeting schedule is critical to early intervention of risks and issues. Proiect Status and Issues/Risks Reporting: In addition to the regularly scheduled Project Status Meetings, the CentralSquare Project Manager provides two key types of reports as part of the Communication Plan. The Project Status Report, distributed to key stakeholders at a frequency to be determined based on the needs of the Customer (typically bi-weekly or monthly), summarizes milestones completed, as well as recent and upcoming project activity. The Issues Log updated continually by the CentralSquare Project Manager, tracks entry and management of project issues identified by CentralSquare or the Customer. Log entries include status updates, action items, and responsibilities of both parties. Risks and issues tracking log adjustments are mutual agreement by the CentralSquare and Customer Project Manager. The Customer and CentralSquare agree that the individuals designated in the final project plan are essential to the services offered pursuant to this Agreement. The Customer and CentralSquare should anticipate challenging issues to arise throughout the implementation process due to the nature and complexity of projects of this type. For expedient remedying of challenging issues, the Customer and CentralSquare will use the following dispute resolution process. All communication regarding the project directed to CentralSquare's Project Manager and the Customer's Project Manager maintain consistent communication between the parties. Regularly scheduled project status meetings maintain open communication between the CentralSquare and Customer Project Manager. All issues or concerns are to be openly and actively discussed between CentralSquare's Project Manager and the Customers Project Manager prior to any escalation. If issues begin to interfere with the progression of the implementation project, the Customer and/or CentralSquare Project Manager should escalate challenges to senior management representatives. Customer will provide escalation personnel to CentralSquare Project Manager during Kick -Off phase of the project. Implementation Methodology CentralSquare Professional Service Consultants and Project Manager follow a standard implementation approach divided into stages throughout the course of the project. Several types of services and resources will be used during each stage to complete the necessary steps for successful deployment of the contracted services. Contracted services are detailed in Appendix A. APPENDIX A: FINANCE ENTERPRISE AND HR/PAYROLL FUNCTIONAL GROUPS: The Finance Enterprise and HR/Payroll solution will be implemented for the Customer for the following modules: • General Ledger • Budgeting • Accounts Payable • Accounts Receivable • Bank Reconciliation • Cash Receipts/Cash Management • Fixed Assets/Capital Assets • Purchasing/Requisitions • Person/Entity (Vendors/Customers) • Human Resources INSTALLATION: • Payroll • Employee Online Basic • Pcard • Employee Online with Open Enrollment • Position Budgeting • Budget Item Detail • Timecard Online • Project Allocation • Grants Management • Personnel Action Forms Below are the major technical tasks included in this project. Significant tasks included: Major Task Description Worksheet Installation of Pre -Prod of Finance Enterprise and Cognos Environments DATA MIGRATION: CentralSquare will present the Customer a worksheet for completion. A sample of this worksheet is attached as Appendix C. The completion of this worksheet is critical to the creation of your Finance Enterprise environment. Please refer to Roles and Responsibilities detailed in Appendix B of this SOW. CentralSquare technical consultant will create a new pre -production environment in CentralSquare's hosted cloud. Details are included in Appendix B of this SOW. Major Task Description Data Migration CentralSquare consultants will work with the Customer during the migration process. We will assist and train the Customer to use the data import tools. It is the responsibility of the Customer to provide legacy data in an acceptable format. Data Migration Mapping The consultant will work closely with the Customer's legacy data expert, to review the source data and assist with mapping it to the proper target data field in Finance Enterprise. CONFIGURATION: Finalizing the Finance Enterprise configuration will be a collaborative process driven by the functional requirements discovered during the Needs Analysis and through consultative engagements between CentralSquare staff and the customer's Subject Matter Experts. Significant tasks include: Major Task Description Needs Analysis Consultant meets with different areas of Finance reviewing and analyzing all key business processes. All sessions will be discussions on processes relating to the different key functional areas. System Configuration CentralSquare consultants will work with the Customer to configure the system to meet their needs. The configuration will be based on the findings of the Needs Analysis. This configuration will be tested and adjusted as needed by the County. Workflow Creation CentralSquare consultants will work with the Customer to configure Workflow in accordance with the Customers processes. CentralSquare will work directly with the Customer to identify Workflow to be created. The Workflow will be chosen by the Customer in conjunction with the number of hours (80) available for this task. The Customer will choose and prioritize the models that are to fit into the available hours. Customer will also receive Workflow creation training, see Training section below. Report Development The Report Development team will work directly with the Customer to identify reports to be created. The reports will be chosen by the Customer in conjunction with the number of hours (80) available for this task. CentralSquare will scope the requested reports and assign hours to each. The Customer will then choose and prioritize the reports that are to fit into the available hours. Hours assigned to each report will include specifications, development of the report, and modifications (within scope). Delivery of the reports will be made as they are completed and approved. Configuration Validation CentralSquare Consultant completes the Configuration Validation checklist of the system to I verify system is configured to meet the requirements. TRAINING: Training is a structured program designed to equip the Customer's staff with the necessary skills and knowledge for effective software utilization. The Customer has the option to record these training sessions, provided that a signed Confidentiality Agreement is submitted to the CentralSquare Project Manager. The responsibility for the management and storage of these recordings rests solely with the Customer. Application Workshops Application workshop training classes designed as hands-on workshops to Train -the -Trainer. These classes generally are limited to eight participants (or as determined by mutual agreement of the CentralSquare and Customer Project Managers) and should be attended by functional experts in the specific application area. Core Solution Training Type Intended Audience y Topics 1 t { Finance Core CST Instructor -led Train the Trainer Accounts Receivable, Accounts Payable, !i! Training i Cash Receipts, Bank Reconciliation, Fixed ! j Training f Customer functional E I Assets , experts will attend i I General Ledger i CST Instructor -led j Train the Trainer Training Training Customer functional experts will attend HR/Payroll CST Instructor -led Train the Trainer Training Training Customer functional experts will attend d I Cognos Analytics ( CST Instructor led Report writers and Training users i Workflow CST Instructor led i Customer technical Training j resources will attend End -User Training General Ledger & Human Resources, Overview and general navigation. Report building techniques and skills Creation and modification of Wor feature within Finance Enterprise End -user training provides hands-on, process -based instruction focusing on key tasks related to users' job responsibilities. With the decision to choose CentralSquare facilitated training, an instructor provides training on the chosen contracted solutions. End -user classes incorporate extensive activities based on realistic scenarios focusing on processes and tools within the applications for productive use of the system at and after Go -Live. These classes generally are limited to 10-12 participants (or as determined by mutual agreement of the CentralSquare and Customer Project Managers). Agendas for each module will be based on specific configuration and workflows established during the implementation. TESTING: Testing will assess your team's readiness for Go Live. It is an iterative process, conducted by the Customer, to verify the configured solution meets the stated functional requirements. This phase is especially important to ensure a smooth transition at go -live. Significant tasks include: Testing Tasks Definition Planning CST will work with the System Administrator to develop an Acceptance Test Plan to verify the configured solution meets the stated functional requirements. This Plan will include user test scripts covering the various Finance functions Issue Tracking CST will collaborate with the System Administrator to maintain a log of issues, configuration problems, and software malfunctions identified during testing Issue Resolution CST will work collaboratively to resolve all such issues, problems and malfunctions to the customer's satisfaction Acceptance Testing System Administrator will perform acceptance testing to ensure acceptance criteria items have been addressed, and certify Finance Enterprise is ready for "go -live' DEPLOYMENT: Starts with the completion of your production environment. Then, we conduct a mock Go Live. Finally, once both teams agree on readiness, we Go Live. Significant tasks include: Major Task Description Configuration Validation I CentralSquare Consultant completes the Configuration Validation checklist of the system to verify system is configured to meet the requirements. Plan Cutover Schedule and Communications Testing Ends Sign Off Execute Go Live Go Live Support Describes tasks to be handled by CentralSquare and Customer personnel during the initial cutover to Go -Live, including a detailed schedule of CentralSquare personnel covering each shift with resources, process for reporting issues, how they will be handled or escalated, contact names/phone numbers onsite staff, remote and third -party vendors. Both parties will acknowledge the completion of testing by signing the Testing Ends document. The Customer transitions from their legacy system to the finance Enterprise system and conducts their normal day-to-day business. This session will be used to provide support for Go Live. The topic will be determined by Customer needs. APPENDIX B: Cloud Services (Cloud Services — Hosted) CentralSquare and Customer will conduct the following as part of this project. bus a r' . o1e f '��'`+ Cents I5 , I o e � 1. Creation Initial Creation of CentralSquare's ,: � Attend Discovery call Discovery Call Finance Enterprise software Provide necessary Complete install and information forthe data migration :. environment build. Work with Customer Provide a list of team to choose the network printers authentication method Workwith CST team to Work with Customer to choose the verifythe site -to -site VPN authentication method is properly configured. Provide a list of users, if needed Work with Networking team to verify the site - to -site VPN is properly configured. 2. Test Account Test Account Creation is the Validate Create Test Creation creation from the production Account Account environment once the Customer goes live. 3. Cognos Creation of the Cognos Analytics Validate Complete install Environment pre -production environment. Account and migrate Creation Customer reports Assumptions • CentralSquare will migrate Customer data into the Finance Enterprise database and confirm that the Finance Enterprise software's primary system functions are available. • CentralSquare will install the Finance Enterprise software into our Private Cloud environment, managed by our Cloud services team and provide access to the Customer through a standard URL, secured over a site -to -site VPN tunnel. We provide a physical hardware appliance that the customer installs on -site and we manage remotely. • CentralSquare will configure Cisco Anyconnect VPN Customer access, but only for Disaster Recovery purposes. It is limited to 10 connections. Additional connections can be added for an additional cost. • Central5quare will complete all work remotely • CentralSquare will create one (1) Production Environment and one (1) Test Environment as part of the Agreement. Additional accounts will require additional hours and hosting fees, added under separate quote by mutual written agreement at CentralSquare's prevailing rates. • CentralSquare can assist the Customer with Azure AD (OIDC), which is compatible with version 21.1 or greater. CentralSquare will configure those parts of the integration that are required and accessible for the cloud environment. There are some tasks that CST will require Customer assistance. Once configuration is complete, this will be tested by the Customer. • CentralSquare can assist the Customer with Okta SAML and Azure AD SAML, which is compatible with version 21.2 or greater. CentralSquare will configure those parts of the integration that are required and accessible for the cloud environment. There are some tasks that CST will require Customer assistance. Once configuration is complete, this will be tested by the Customer. Roles and Responsibilities CentralSquare: • Will stand up the new environments. • URL's for the environment will remain the same following go -live. • Will conduct a test to verify that CentralSquare applications have been installed and operating properly. • Completion of VPN Tunnel Worksheet. CentralSquare responsible for CST Cloud Network Settings including, but not limited to, the following: • Device Manufacturer/Model • Firewall/Gateway Address • Protected Network Address(s) • Contact information of person(s) responsible for tunnel configuration Customer: • Participate in planning activities (conference calls, emails) with CentralSquare Application Installation Consultant and Technical Lead. • Completion of VPN Tunnel Worksheet. A sample of this worksheet is attached as Appendix C. Required information includes, but is not limited to, the following: • VPN tunnel configuration requirements, Customer Settings • Device Manufacturer/Model • Firewall/Gateway Address • Protected NetworkAddress(s) • Contact information of person(s) responsible for tunnel configuration • Customer must notify CentralSquare right away if the following ranges are not acceptable: • 10.30.0.0/16 • 10.60.0.0/16 APPENDIX C: SAMPLE VPN Tunnel Worksheet .. CENTRALSQUARE CST Cloud Network Settings Customer Settings Partner Details,', Name CentralSquare Technologies V,PN"tunnel configurationr"uirements Device Manufacturer/Model Firewall/Gateway Address Protected Network Address(s) IPSec Parameters (IKE Phase.1Proposal) Pre -shared Key IKE Negotiation Mode IKEv2 Encryption AES-256 Authentication SHA-256 D-H Group 14 Psuedo-random Function (PRF) SHA1 Lifetime 86400 (24 Hours) IPSec`Parameters (IKE-Ph ase`2Proposal); Perfect Forward Secrecy (PFS) D-H 14 Group ESP Encryption AES-256 ESP Authentication SHA-256 Lifetime 28800 (8 Hours) Contadt Information :- Responsible party for tunnel config Contact details (Name & Email) Further; information/commen`ts: PSK be updated after tunnel is can estabiishetl Confidential and Proprietary MORE INFORMATION AT CENTRALSOUARE.COM APPENDIX D: Community Development FUNCTIONAL GROUPS: The Community Development solution will be implemented for the Customer for the following modules: • Permitting • Projects and Planning • Code Compliance • Licensing • CRM • eTRAKiT • Mobiles • Advanced GIS Analysis To begin, we jointly perform a comprehensive analysis of your current state processes related to core system functionality. In this stage we also begin the process of data conversion by analyzing your legacy data. Significant tasks include: Major Task Description Business Process Review Data Migration Mapping Consultant meets with different areas of Community Development reviewing and analyzing all key business processes. All sessions will be discussions on processes relating to that area within Community Development. Deliverable: Community Development Formal BPR Report and Recommendations. The consultant will work closely with the agency's legacy data expert, to review the source data and map it to the proper target data field in Community Development Monitor & Control During this phase, the consultant has become familiar with your configuration requirements, processes, and current workflows. With this knowledge, we will deliver your configured system and converted legacy data into your new pre -production environment. Next, our consultant will provide guidance as you begin iterative testing that will continue throughout the remainder of the implementation. Also, our data conversion team guides you through testing your converted data and Admin training begins. Significant tasks include: Major Task Description System Configuration CentralSquare Technologies configures system. Customer provides additional information as needed. Python Scripting and Geo IThe GIS Specialist builds Python scripting by GEOTYPE (example: Parcel, Address, Streetto Database Delivery gather required data to populate the appropriate Community Development database tables for initial delivery and installation at the customer's site.Upon completion of the scripting, the GIs Specialist delivers the GEO database to the Database Specialist for inclusion in the initial delivery of the customer's testing database. Configuration Validation ( CentralSquare Consultant completes the Configuration Validation checklist of the system to verify system is configured to meet the requirements. Major Task Description list_ Training classes, designed as hands-on workshops, include building code tables, picklists, system settings, and assignment of security permissions. Designed for supervisors, system administrator, and staff with decision -making authority. Please see below for more details. Admin Skills Workshops Workshop training classes, designed as hands-on workshops, include building code tables, picklists, system settings, and assignment of security permissions. Designed for supervisors, system administrators, and staff with decision -making authority, these workshops kick off the application configuration process for designated project committee members. These classes generally are limited to six participants (or as determined by mutual agreement of the CentralSquare and Customer Project Managers) and should be attended by those responsible for maintaining user information and code tables, as well as by subject -matter experts in the specific application area. Class time focuses on beginning the building process under the guidance of the assigned CentralSquare trainer, as well as to discuss CentralSquare recommendations regarding potential configuration options as identified during the Functional Analysis Workshop. Class Title Nof Classes Training Type Intended Audience Topics I Location SME/Train the i 1 Hands-on, System Admins, General Navigation, Remote Trainer Training ( Instructor -led '.. Customer SM Es& Overview of each module is Training j Core Team Members included, review of customer's testing strategy Admin Training I 1 Hands-on,'.. System Admins Covers all modules, designed Remote Instructor -led '.. to train local administrators Training of the system and covers all areas of configuration with --. the system Custom Report Development The Report Development team will work directly with the Customer to identify reports to be created. The reports will be chosen by the customer in conjunction with the number of hours available for this task. CentralSquare will scope the requested reports and assign hours to each. The Customer will then choose and prioritize the reports that are to fit into the available hours. Hours assigned to each report will include specifications, development of the report, and modifications (within scope). Delivery of the reports will be made as they are completed and approved. Data Conversion The data conversion process will start with mapping the customer's legacy data into the Community Development production database format. The process includes four data refreshes, inclusive of the final cut-overfor Go Live. The conversion program will be designed to run while the target database is in full operation; however, because of the volume of data being processed, it will be ideal to execute the conversion during a window of minimal usage. Legacy system testing must be completed prior to mock go -live. Any legacy system or data mapping changes performed after the mock go -live will not be captured in the final data migration. Data conversion contracted for this project may include: Modules To be Definition of Module Converted Permitting Legacy permit data currently in the local government agency's current system of record. Generally, this is data representing the agency's construction or remodeling projects for properties within the agency's jurisdiction. It is intended to ensure that the project plans comply with local, state, and national building and construction regulations Projects & Planning Legacy planning & zoning data currently in the local government agency's currently system of record. Generally, this is data representing the agency's development and design of land use and the built environment, including air, water and the infrastructure passing into and out of the agency's jurisdiction. It is intended to ensure that the land use and zoning changes comply with local standards for land use, zoning, and urban planning Code Compliance Legacy case data currently in the local government agency's current system of record. Generally, this is data representing the agency's regulatory compliance violations for properties within the agency's jurisdiction. It is intended to ensure that the properties conform to the rules and standards set forth in the agency's municipal code of ordinances Licensing Legacy business licenses data currently in the local government agency's current system of record. Generally, this is data representing the agency's Regulatory Licenses, which are permits issued by the agency that allow individuals or companies to conduct business within the agency's jurisdiction. It is intended to ensure that the businesses conform to the rules and standards set forth in the agency's municipal code of ordinances and/or the state's regulatory rules Land Parcel The land parcel data commonly includes details of the ownership, precise location, dimensions, Management and value of individual parcels of land, within the agency's jurisdiction. It is intended to provide comprehensive land details obtained from the agency's source GIS system or Assessor's office, to ensure accuracy Customer Relations Legacy data that contains historical communications primarily from property owners within the Management agency's jurisdiction and generally consists of questions, issues, or complaints Entity Management The entity data commonly includes details of individuals and businesses that interact with the agency, on a regular recurring basis. It is intended to provide the agency with a quick reference source of contractor, engineer and tradesmen that can be linked to activities within the Community Development system Integration/Interfaces Integrations and/or interfaces Included in this project include: Integration/Interface Use of System Type / Import/ Interface Method / Future Frequency Export Functionality i Community Development Allows field personnel to engage On Demand To effectively utilize the Mobiles with Community Development - mappingfunction in the while on worksites '.. 1 Community Development Mobiles application (IOS or Android), the customer is responsible for supplying a valid I Google Maps key. Financial Batch Export Queries system for payments Batch / Export SQL Stored Procedure & SSRS and creates a file to be Nightly Report processed in a 3rd party GL Land Management Update Ensures the land parcel data Batch / Import File Based DLL Routine within the system, stays up to Nightly date', ..._...... ................ _ Integration/Interface Use of system ESRI GIS- Advanced Online Payment Gateway <see Note * a. below> Over the Counter Payment Gateway <see Note * b. below> Type/ Import/ Interface Method/Future Frequency Export Functionality Opens and saves PDFs within the On Demand File Based DLL system for plans review and markup -. Uses a published rest endpoint On Demand Import Web Services from ESRI to display map data with the system - Interface for credit card On Demand Import/ File Based DLL payment processing -, Export Interface for credit card On Demand Import/ File Based DLL payment processing ',, L ''., Export I Notes: * Customer will need to contract with a new payment provider, to accept payments over the counter (OTC) and/or online and provide credentials to CentralSquare within 30 days of project initiation. a. Supported online Payment Providers 1. Authorized.Net ii. USA ePay iii. Elevon (Converge) iv. PayFlowPro (PayPal) v. Paymentus vi. Cardknox vii. Card Connect viii. CS] (JetPay) ix. CentralSquare Payments b. Supported over the counter Payment Providers j. Paymentus ii. Cardknox iii. CardConnect Testing Testing will assess your team's readiness for Go Live. This includes knowledge transfer, end user training, and change management significant tasks include: Major Task Description Testing The testing phase is an iterative process, conducted by the customer, to help the consultants check the quality of the legacy data conversion and review the configuration decisions made during the discovery phase of the project. This phase is especially important to ensure a smooth transition before the system launches. Go Live Support This session will be used to provide support for Go Live. The topic will be determined by customer needs. See Go Live below. Training Training is a structured program designed to equip the Customer's staff with the necessary skills and knowledge for effective software utilization. The Customer has the option to record these training sessions, provided that a signed Confidentiality Agreement is submitted to the CentralSquare Project Manager. The responsibility for the management and storage of these recordings rests solely with the Customer. Within Testing and Deployment, End -user training is completed. End -User Training End -user training provides hands-on, process -based instruction focusing on key tasks related to users' job responsibilities. With the decision to choose CentralSquare facilitated training, an instructor provides training on the chosen contracted solutions. End -user classes incorporate extensive activities based on realistic scenarios focusing on processes and tools within the applications for productive use of the system at and after Go -Live. These classes generally are limited to 10-12 participants (or as determined by mutual agreement of the CentralSquare and Customer Project Managers). Agendas for each module will be based on specific configuration and workflows established during the implementation. Topics in end -user classes will include data entry, searching, reporting, and application navigation Core Solution f Training Type Intended Audience Topics End User i Hands-on, All Users of the ComDev General Navigation, End to end training of Training Instructor -led System ! each module based on the specific Training - configuration and workflows established during the implementation Deployment Starts with the completion of your production environment. Then, we conduct a mock Go Live. Finally, once both teams agree on readiness, we go live. Significant tasks include: Major Task Description Environment Plan Cutover Schedule and Comunications Execute Go Live Go Live Support CentralSquare Consultant completes the Configuration Validation checklist of the system to verify system is configured to meet the requirements. Describes tasks to be handled by CentralSquare and Customer personnel during the initial cutover to Go -Live, including a detailed schedule of CentralSquare personnel covering each shift with resources, process for reporting issues, how they will be handled or escalated, contact names/phone numbers onsite staff, remote and third -party vendors. The Customer transitions from their legacy system to the Community Development system and conducts their normal day-to-day business. '.. This session will be used to provide support for Go Live. The topic will be determined by customer needs. Go Live (additional information): CentralSquare offers a variety of Go -Live services to augment the Customer's staff during the transition from the legacy product to the CentralSquare solution. Included in this project, the Project Managers will work together to create a Go -Live Plan to include a schedule of events, resource allocation, communications plan, and issue log. Additionally, CentralSquare will support the Go -Live with the following services: Type of Resource; Two Consultants: Supporting staff during go live event Number of Days CentralSquare Project Manager; Supporting project during go live event As Needed Definitions Key Deliverables ( Description IF Ow wners ners __ Guides the project Finalized during the Planning phase CentralSquare Project i Project management team to ' during discussions about Project team Management Team I Management Plan i monitor and control z and timeline f mene r I I expectations, budget, � I i scope, schedule, communication, and ( quality. Identifies tasks to be An updated schedule will be provided as CentralSquare Project Project Schedule completed during the life needed Mgr. and Customer cycle of the project Project Manager including the key SOW I tasks, resources, durations, milestones, and delivery dates Describes the key project Provided at Kick-off and updated as CentralSquare Project team members from j required I Manager CentralSquare and ! S Communication 3 Customer Executives to I Plan Subject Matter Experts, f includes, roles and I( responsibilities, and contract information {{{ Following regular status 1 Determined by Customer need during CentralSquare Project^ Status Reports meetings, the kickoff j Manager and Customer iCentralSquare PMwill i Project Manager provide an updated status report Tracks risks and issues, Determined by Customer need during MCentralSquare Project _ Assignments, progress, kickoff Manager and Customer Issues Log mitigation strategies, due Project Manager dates, and other relevant information for managing risks and issues Risk Register Implementation Guide Test Matrices Go Live Plan Services to Support/ Project Closeout Report Classifies the risk based on probability and impact to the overall project and develops mitigation and response plans, where appropriate. End -to -end summary of engagements that make up the CST implementation. Workbook that contains all test and assessment cases completed during the implementation. Describes tasks to be handled by CentralSquare and Customer personnel during the initial cutover to Go -Live, including a detailed schedule of CentralSquare personnel covering each shift with resources, process for reporting issues, how they will be handled or escalated, contact names/phone numbers onsite staff, remote and third -party vendors. The delivery of formal closing documents as part of acceptance includes completed project artifacts outlined above, change order summary, lessons learned and recommendations, risk and issues log, customer support transition plan, and description of steady state operations. Maintained throughout the course of the Project CentralSquare Project Manager and Customer j Project Manager Provided at Kick-off and referred to CentralSquare Project throughout the project Manager Provided at Kick-off and updated as CentralSquare Project required Manager A draft will�be provided prior to Go -Live, CentralSquare Project reviewed with the Customer, andI Manager and Customer finalized for distribution to stakeholders ( Project Manager Provided at the end of the project CentralSquare Project Manager or. APPENDIX E: General Requirements For GIS Integration The Community Development product requires the customer to create and maintain three ArcGIS Server map services to provide GIS data and maps to the application. The requirements for ArcGIS Enterprise, map services, and GIS data are outlined below. ARCGIS ENTERPRISE REQUIREMENTS Community Development requires map services to be published with Esri's ArcGIS Enterprise and ArcGIS Server. The ArcGIS instance does not need to be solely dedicated to this purpose but must meet the requirements below. • ArcGIS Enterprise versions 10.7 to 11.0 (check with Centra/Squore on later version compliance) • ArcGIS Enterprise must utilize HTTPS based on a Valid SSL certificate issued by a third -party certificate authority. • ArcGIS Enterprise must be able to provide services to the web (outside the customer's network). The use of a proxy to expose ArcGIS Enterprise services within the agency network to the web is not supported. • Authentication o The customer must provide CentralSquare with login credentials for one of the built-in Portal for ArcGIS user types. o Web -tier authentication using Windows Authentication is not supported. o SAML Active Directory Federation is not supported. • On Premise Community Development customers must also provide an ArcGIS Pro license dedicated to the product. MAP SERVICE REQUIREMENTS Three map services are required for the product meeting the following requirements: • Map Services can be protected by a built-in ArcGIS user and password. • All layers in the service must be in the same Esri-recognized local projection. • Feature access must be enabled with query/data operations allowed. • Customer -side working geometry and print services are required. Please note: Community Development is not fully compatible with ArcGIS Online. ArcGIS Online feature services may be used to enable the GIS data integration but are not supported for the base map. Base map services meeting the requirements described above must be provided by the customer. GIS DATA REQUIREMENTS GIS data are utilized by the product in two manners: GIS layers are included in the base map for the system. The base map requirements are relatively minimal and covered in the Map Service Requirements section above. 2. GIS features are integrated into the product as Geotypes. A Geotype is a land -based feature used in the land management module to link permits, projects, code cases, licenses and CRM Issues. Parcel data is required as the primary Geotype. Secondary Geotypes may include address points, street segments or other land -based features your agency would link with other modules. Geotype GIs layer requirements are as follows: Geotype layers must each be provided and maintained in a single feature class. For example: parcel data cannot be divided across two layers covering two counties in your jurisdiction. A unique identifier (UID) field is required for each Geotype. All UIDs must be a text(string) data type with a 50-character maximum. ■ Special characters, GUIDs, and using the ObjectlD are not supported. ■ The UID should be unique to all other features across all Geotypes. ■ For parcel Geotype data, the PIN or APN, which comes from the assessor's office, is used as the UID for Community Development. • Once established, a UID for each GeoType feature cannot change, with the exception of parcel splits. UIDs removed from the GIS feature will result in retirement of associated records in the Community Development system. Address point Geotype data must also include the PIN or APN of the related parcel as an attribute. APPENDIX F: Cloud Services (Cloud Services - AWS) CentralSquare and Customer will conduct the following as part of this project. [.'T_1_Fj 1. Creation Initial Creation of CentralSquare's Community Development software 2. Test Account Test Account Creation is the Creation creation of the test account which is cloned from the pre -production environment. Assumptions • Attend Discovery • Discovery Call Call • Complete install and data migration Validate Account • Create Test Account • CentralSquare will migrate all Customer data into the Community Development database and confirm that the Community Development software's primary system functions are available. • CentralSquare will install the Community Development software into our AWS environment, managed by our Cloud services team centers and provide access to the Customer through a standard URL. • CentralSquare will complete all work remotely • CentralSquare will create one (1) Production Account and one (1) Test Account as part of the Agreement. Additional accounts will require additional hours added under separate quote by mutual written agreement at CentralSquare's prevailing rates. Roles and Responsibilities CentralSquare: • Load files and perform initial configuration of all licensed CentralSquare applications, including base and add -on modules, and interfaces to third -party applications. Configuration includes activating appropriate modules, table set up, and selection of mandatory configuration settings based on combination of CentralSquare applications purchased. • Set up test environment as mirror copy of the production environment. • Conduct a test to verify that CentralSquare applications have been installed and configured successfully, operating properly, and are ready to begin the implementation and configuration process. Note: Not all CentralSquare components may be ready at this point, for a full test, but a reasonable effort ensures CentralSquare components are ready for the next step in the process. CentralSquare installation services will ensure that all needed components are prepared and ready prior to conducting subsequent activities for the specific application area according to the agreed upon Project Schedule. Customer: • Participate in planning activities (conference calls, emails) with CentralSquare Application Installation Consultant and Technical Lead. • Provide access to Customer's servers (including third -party) as required for CentralSquare Technical Lead and Application Installation Consultant to perform installation and migration tasks. • Attend knowledge transfer sessions focusing on how to prepare workstations or mobile computers to run CentralSquare applications. APPENDIX G: CentralSquare Utility Billing FUNCTIONAL GROUPS: The CentralSquare Utility Billing solution for the Customer includes the implementation of the following modules: Utility Billing Bundle: • Customer Information System (CIS) • Cash Receipts • Land Parcel Management • Contact Management • Data Quality Suite (DQS) ANALYSIS: • Citizen Engagement Core • Citizen Engagement Request Tracking • Citizen Engagement CIS • Document Management Services (DMS) During this stage of the implementation, our consultants, including third party consultants, will meet with the customer's functional experts to review the current workflows of key functions impacted by this project and the contract software. In this stage we also begin the process of data conversion by analyzing your legacy data. Significant tasks include: Major Task Description Business Process Review Consultant meets with different areas of Utility Billing reviewing and analyzing all key business processes. All sessions will be discussions on processes relating to the different key functional areas. Deliverable: Utility Billing formal BPR report and recommendations. Data Migration Review The consultant will work closely with the agency's legacy data expert, to review the source data and map it to the proper target data field in Utility Billing. INSTALLATION: Below are the major technical tasks included in this project. Significant tasks included: Major Task Description Installation of Pre -Prod of CentralSquare technical consultant will create a new pre -production environment in Utility Billing CentralSquare's hosted cloud. Details are included in Appendix Hof this SOW. Environment DATA MIGRATION: Major Task Description Data Migration I Customer Responsibility: Identify data files from the existing utility system that will be needed for the conversion process. Provide all conversion data files from the existing application system in an IBM compatible data format. CentralSquare will convert all legacy data. Identify, create, and validate all translation and or cross reference tables. Provide file and field definitions for the conversion data files. Identify and make available application specialists, who will be responsible for providing information on the existing database for use in the creation of the conversion specifications document. Provide a full data set of conversion filesfrom the existing application. This information should be made available to the CST conversion analyst at least 2 weeks Prior to the second and third training session. This data set will be used to convert the information to the CST application in preparation for data verification and use d uring training visits CONFIGURATION: Finalizing the Utility Billing configuration will be a collaborative process driven by the functional requirements discovered during the business process review and through consultative engagements between Consulting staff and the Customer's Subject Matter Experts. Significant tasks include: Major Task Description Consultants will work with the Customer to configure the system to meet their needs. The configuration will be based on the findings of the Business Process Review. This configuration will be tested and adjusted as needed by the Customer. Upon final configuration, Customer will sign off that configuration is complete per the requirements set in the Business Process Review document. INTEGRATION/INTERFACES: Integrations and/or interfaces Included in this project: Integration/Interface j Use of System I Type of ! 1-way/2- Integration/Interfa I way/Bi- ce (i.e. API, Web directional Service, Batch) General Ledger (FE) I Financials Web Service/CSV j 2-way Meter --- Utility Billing.- Upload/Download i Compatible Payment Approved vendors: Vendors CentralSquare I Payments, AMS, 1 CardKnox, Selectron (IVR) II7IIIIIki 2-way Standard/Custom Standard Custom Over the Counter, 2-way Standard Citizen Engagement (Web Portal), Point of Sale Application Workshops Application workshop training classes designed as hands-on workshops to Train -the -Trainer. These classes generally are limited to eight participants (or as determined by mutual agreement of the CentralSquare and Customer Project Managers) and should be attended by functional experts in the specific application area. Automated/Manual Auto Manual/Auto Auto Core Solution Training Type Intended Audience 1Topia�— i I ! Location I 3 I Utility Billing — Land/Locations Instructor- Train the Overview, Codes, System Remote i led Training Trainer Control, Street Dictionary, j i ! Customer Location Records I j � i I functional Miscellaneous Information I experts will iattend 1 Utility Billing — Customer/Customer 1 Instructor- I Train the Customer Setup and ____a_ I Remote i I Services � led Training (Trainer Maintenance, Adding and Customer Managing Services, Viewing i I i functional Change History experts will _...__._...._.,.._._____..._ I attend ....__...._..._---_ j Utility Billing— Rates/Customer CST Train the Rate Groups, Billing Processes, Remote Billing/Meter Reading/Meter Shop Instructor -led Trainer Meter reading Maintenance Training i Customer I functional : � Utility Billing Cash Receipting/Payment Processing Utility Billing— Delinquency/Collection Write-off Utility Billing — Standard Reporting/Document Management Services Contact Management Citizen Engagement ! experts will attend CST j Train the Instructor -led ;Trainer Training " Customer functional j experts will attend CST 1 Train the Instructor -led i Trainer Training Customer functional experts will attend CST i Train the Instructor -led i Trainer Training Customer functional I experts will attend CST ! Train the Instructor -led Trainer Training { Customer i functional experts will attend CST I Train the Instructor -led Trainer Training Customer functional experts will 1 attend Cash Receipts System Control and Maintenance, Code Setup and Maintenance, Payment Processing Processing Delinquency and Penalty Processing, Collection Processing, Collection Account Maintenance DIMS 2.0 Report Building Training including Demand Reports, Customer Letters Module training including system control, codes, contacts, call entry and call review and reports Remote Remote Remote Remote Core, Citizen Request Tracking, Remote Utility Billing TESTING: Testing will assess your team's readiness for Go Live. It is an iterative process, conducted by the Customer, to verify the configured solution meets the stated functional requirements. This phase is especially important to ensure a smooth transition at go -live. Significant tasks include: Testing Tasks Definition Planning CST will work with the Customer to develop an Acceptance Test Plan to verify the configured solution meets the stated functional requirements. Issue Tracking CST will collaborate with the Customer to maintain a log of issues, configuration problems, and software malfunctions identified during testing. Issue Resolution CST will work collaboratively to resolve issues, problems and malfunctions to the Customer's satisfaction related to the implementation. Acceptance Testing Customer will perform acceptance testing to ensure acceptance criteria items have been addressed, and certify Utility Billing is ready for "go -live" DEPLOYMENT: Starts with the completion of your production environment. Then, we conduct a mock Go Live, which will include parallel processing. Finally, once both teams agree on readiness, we Go Live. Significant tasks include: Major Task Description Validation Plan Cutover Schedule and Communications Testing Ends Sign Off Execute Go Live Go Live Support CentralSquare Consultant completes the Configuration Validation checklist of the system to verify system is configured to meet the requirements. Describes tasks to be handled by CentralSquare and Customer personnel during the initial cutover to Go -Live, including a detailed schedule of CentralSquare personnel covering each shift with resources, process for reporting issues, how they will be handled or escalated, contact names/phone numbers onsite staff, remote and third -party vendors. Both parties will acknowledge the completion of testing by signing the Testing Ends document. The Customer transitions from their legacy system to the CentralSquare Utility Billing system and conducts their normal day-to-day business. This session will be used to provide support for Go Live. The topic will be determined by Customer needs. APPENDIX H: Cloud Services (Cloud Services —Hosted) CentralSquare and Customer will conduct the following as part of this project. 1. Creation 2. Test Account Creation Initial Creation of CentralSquare's Attend Discovery call Utility Billing software Provide necessary information for the environment build. Provide a list of network printers Work with CST team to choosethe '.. authentication method Provide a list of users Work with Networking team to verify the site - to -site VPN is properly configured. Discovery Call Complete install and data conversion Work with Customer to verify the site -to -site VPN is properly configured. Test Account Creation is the Validate Create Test creation from the production Account Account environment once the Customer goes live. Assumptions • CentralSquare will convert Customer data into the Utility Billing database and confirm that the Utility Billing software's primary system functions are available. • CentralSquare will install the Utility Billing software into our Private Cloud environment, managed by our Cloud services team and provide access to the Customer through a standard URL, secured over a site -to -site VPN tunnel. We provide a physical hardware appliance that the customer installs on -site and we manage remotely. • CentralSquare will configure Cisco Anyconnect VPN Customer access, but only for Disaster Recovery purposes. It is limited to 10 connections. Additional connections can be added for an additional cost. • CentralSquare will complete all work remotely. • CentralSquare will create one (1) Production Environment and one (1) Test Environment as part of the Agreement. Additional environments will require additional hours and hosting fees, added under separate quote by mutual written agreement at CentralSquare's prevailing rates. Roles and Responsibilities CentralSquare: • Will stand up the new environments. • Will conduct a test to verify that CentralSquare applications have been installed and operating properly. • Provide VPN RFI (Request For Information) to assist with configuration of VPN device provided to facilitate communication between Customer and CentralSquare data centers • Provide VPN router /firewall for installation on customer network for connectivity to Cloud systems • Configure VPN / firewall rules for inbound access to Cloud Systems, outbound access to Customer premise systems • Provide NATs/PATS for any premise systems or printers that require access from Cloud systems • Create new objects: user profiles, printers, and remote output queues via standards for Cloud IBMi systems • Set up Cloud Windows VM to support Citizen Engagement • Create test environment from a copy of production 30 days post -go live, if applicable • Test environment data refreshes: once a Customer is live in cloud data center, the Customer may request up to two test environment data refreshes per year if the Customer is current on their support agreement. Additional data refreshes are available at a cost and a quote will be provided if requested. Customer: • Participate in planning activities (conference calls, emails) with CentralSquare Application Installation Consultant and Technical Lead. • Complete VPN RFI document supplied by CentralSquare • Assist with installation of CentralSquare provided VPN router/firewall • Update network routing to direct traffic destined for the Cloud systems to route over the VPN EXHIBIT 6 Intentionally Omitted CST-2024-102205 EXHIBIT 7 Intentionally Omitted CST-2024-102205 EXHIBIT 8 Intentionally Omitted CST-2024-102205 EXHIBIT 9 Intentionally Omitted CST-2024-102205 EXHIBIT 10 Intentionally Omitted CST-2024-102205 O-JM sd TO: The Honorable Mayor and City Council FROM: Roger Stevens, Public Works Director SUBJECT: Right -of -Way Acquisition - East 961h Street North and North 1451h East Avenue Intersection Improvement Project DATE: November 22, 2024 BACKGROUND: City staff is currently involved in acquiring right-of-way for the East 961h Street North and North 1451h East Avenue intersection improvements. As part of those acquisitions, negotiations for the purchase of land from Charles W. Helscel Revocable Trust and Charlotte Helscel Revocable Trust for 84,942 square feet of right-of-way have been successfully completed and staff is seeking City Council authorization to purchase the land. DESCRIPTION/PURCHASE PRICE: Charles W. Helscel Revocable Trust and Charlotte Helscel Revocable Trust - The settlement offer for the right-of-way is approximately $2.86 per square foot, for a purchase price of $243,241.00. Compensation for damages in the amount of $782,759.00 is in addition to the right-of-way cost, for a total offer of $1,026,000.00. The Helscel family has requested the payment be split between the aforementioned Trusts. FUNDING: Funding for this purchase is included in the project budget from the Capital Improvements Fund. RECOMMENDATION: Staff recommends authorization for payment in the amount of $513,000.00 to Charles W. Helscel Revocable Trust for the acquisition of right-of-way and compensation for damages, located at 9732 North 1451h East Avenue. Staff recommends authorization for payment in the amount of $513,000.00 to Charlotte Helscel Revocable Trust for the acquisition of right-of-way and compensation for damages, located at 9732 North 1451h East Avenue. ATTACHMENT: Location Map Land Acquisition - E 96 St N and N 145 E Ave Intersection Improvements i^ = 282 n 9732 N 145 E Ave 11/19/2024 S(� cR� horbd� W OwmH This map may represents avisual ois play of related geographic information. Data provided hereon is nor guarantee of actual field condhions. To be sure of complete accuracy. please com act the responsible staff for most up-to-date information. TO: The Honorable Mayor and City Council FROM: Roger Stevens, Public Works Director SUBJECT: Right -of -Way Acquisition - East 96rh Street North and North 145th East Avenue Intersection Improvement Project DATE: November 22, 2024 BACKGROUND: City staff is currently involved in the acquisition of right-of-way for the East 96th Street North and North 145th East Avenue intersection improvements. As part of those acquisitions, negotiations for the purchase of land from Tyann Development Company, LLC, for 35,734 square feet of right-of-way have been completed and staff is seeking City Council authorization to purchase the land. DESCRIPTION/PURCHASE PRICE: Tvann Development Company, LLC - The settlement offer for the right-of-way is approximately $2.35 per square foot, for a purchase price of $84,046.00. Compensation for damages in the amount of $55,154.00 is in addition to the right-of-way cost, for a total offer of $139,200.00, FUNDING: Funding for this purchase is included in the project budget from the Capital Improvements Fund. RECOMMENDATION: Staff recommends authorization for payment of $139,200.00 to Tyann Development Company, LLC for the acquisition of right-of-way and compensation for damages, located at the southwest corner of East 961h Street North and North 145th East Avenue. ATTACHMENT: Location Map E 96 St N and N 145 E Ave - ROW Obtainment 1" = 178 n Sub Title 11 /08/2024 NA65V wirooro.xeu p..u�a This map may represents a visual display of related geographic information. Data provided hereon is not guarantee of actual field contlhions. To be sure of complete accuracy, please contact the responsible staff for most up-to-date information. CITY OF OWASSO PAYROLL PAYMENT REPORT PAY PERIOD ENDING 11/16/2024 Department Total Payroll Expenses Municipal Court $ 11,179.06 Managerial 35,268.83 Finance 34,529.13 Human Resources 20,276.82 Community Development 37,903.29 Engineering 31,644.25 Information Technology 34,934.23 Facility Maintenance 18,557.62 Cemetery 1,637.94 Dispatch 6,333.61 Animal Control 9,969.90 Emergency Preparedness 4,023.15 Stormwater 13,434.59 Parks 24,034.08 Recreation & Culture 14,676.31 Community Center 11,030,18 Historical Museum 1,056.51 Economic Development 2,088.76 Strong Neighborhoods 582.01 General Fund Total $ 313,160.27 Ambulance Fund 779.03 E911 Communications Fund 48,779.27 Economic Development 2,088.78 Strong Neighborhoods 7,069.08 Stormwater Fund 11,378.02 Half Penny - Fire 394,273.68 Half Penny - Police 379,045.35 Half Penny - Police Grants 2,873.33 Half Penny - Streets 42,950.16 Vehicle Maintenance 18,691.64 Workers Comp 4,181.84 SECTION 00600 CHANGE ORDER PROJECT: Ranch Creek Sanitary Sewer Upgrade Ph 11 CHANGE ORDER NUMBER: 1 CONTRACT DATE: January 9, 2024 TO CONTRACTOR: Timber Wolf Excavating DATE: November 18,2024 CONTRACT FOR: Ranch Creek Phase 11 The Contract is changed as follows: Addition of 60 days to the contract for additional work, (manholes and taps) and rain days. Not valid until signed by the Owner and Contractor The original Contract Sum was $ 6,297,560.00 Net change by previously authorized Change Orders $ $0 The Contract Sum prior to this Change Order was $ 6,297,560.00 The Contract Sum will be (increased) (decreased) (unchanged) by this Change Order in the estimated amount of $ 0 The new Contract Sum including this Change Order will be $ 6,297,560.00 The Contract Time will be (increased) (decreased) (unchanged) by L-60__) days. The date of Substantial Completion as of the date of this Change Order therefore is Anril 1.2025. NOTE: This summary does not reflect changes in the Contract Sum Time which have been authorized by Construction Change Directive. Timber Wolf Excavating, LLC CONTRACTOR 520 N 45th PL ADDRESS Broken Arrow, OK 74014 BY Edmund Barlow, Project Manager DATE 11/19/2024 City of Owasso OWNER 200 South Main ADDRESS Owasso Ok 74055 BY DATE 11-If-Zp0 SPECIAL PROVISIONS 0509 00900 - Page I of 4 11/18/24 RE: Ranch Creek Sanitary Sewer Improvements Project Change Order # 1 Day Reconciliation for contract Two additional Manhole (ordered and placed)-14 days agreed upon for change (added work) Ten additional service taps added to date -14 days agreed upon for change (added work) Additional bore across Mingo (missed in the plans)-14 days agreed upon for change (added work) Rain days as of November 18, 2024-18 days agreed to for weather beyond the contractor's control Public Works agrees to allow 60 days to the contract making substantial completion April 1, 2025; final completion will now be May 1, 2025. Any other changes to the contract dates will be considered by pay application or work directive changes.