The URL can be used to link to this page

Home My WebLink AboutMilsoft Ukiah 2021-06-11; Amendment 1 2022-02-01COU 2021-207-Al CITY OF UKIAH AMENDMENT NO. 1 TO PROFESSIONAL SERVICES AGREEMENT BETWEEN MILSOFT UTILITY SOLUTIONS and THE CITY OF UKIAH This Amendment No. 1, entered on February 1, 2022 revises the Agreement between the City of Ukiah and Milsoft Utility Solutions , for vendor products and services related to providing a Utility Billing Customer Information System (CIS). This Amendment No. 1 adds to the scope of work, and $8,820, for a revised total , not-to- exceed amount to $273 ,520. The following attachments are included and made part of the amendment: 1) Milsoft Quote 51060 Rl 2) Mi I soft Quote 50972 R2 3) Statement of Work True Up 4) Attachment C-Milestone Payments and Pricing Reflecting Amendment 1 Except as expressly amended by this Amendment, all other terms remain unchanged and in fu 11 force and effect. IN WITNESS WHEREOF, THE PARTIES HA VE EXECUTED THIS AMENDMENT ON THE EFFECTIVE DA TE: MILSOFT UTILITY SOLUTIONS BY: ,A, -4 ---0 l vv• .. J\JA0 DA TE: ~~t{_ I, 20 -z..'"' • PRINT NAME: ~A"--='d"""""am="'--T"---'u=m~e"'"""r ____ _ CITY OF UKIAH BY:____________ DATE: ______ _ SAGE SANGIACOMO, CITY MANAGER ATTEST BY: ___________ _ DATE: ______ _ KRISTINE LAWLER, CITY CLERK Mar 11, 2022 Kristine Lawler (Mar 11, 2022 10:49 PST) Kristine Lawler Mar 11, 2022 MILSOFT ®. ____ Utility Solutions B1II To Mary Horger Ukiah , City of 300 Seminary Avenue Ukiah , CA, 95482-5400 USA Ship To Mary Horger Ukiah , City of 300 Seminary Avenue , Ukiah , CA, 95482-5400 USA Accounting & Utility Billing -Services Schedule A Quote Number: Date Created: Account Manager: E-mail: Phone: Valid Until : 51060 01-25-2022 Paul Kluba paul .kluba@milsoft.com (800) 344-5647 03-02-2022 Quantity Quoted Line Item Retail Price Ext. Price 1.00 CIS iXp Services -Custom Fees by Account Rather than Service/Payment Distribution change request With the proposed changes Ukiah will be able to configure the system to post payments in the order of Sewer, Refuse , Water, Electric . All automated fees would be assessed to the lowest active service number on the account (typically water or electric , depending on account enrollment). The fee would be a lump sum , not duplicated by service . All manual fees would be posted by the CSRs to the lowest service number. Partial payments would leave money owing on water or electric, allowing disconnects . Support is applicable -see Terms & Conditions. Subtotal: Total : Grand Total Subtotal : Total: Quote 51060 I Submission Options: quotes@milsoft .com I P.O . Box 5726 Abilene , TX 79608 I Fax : 325-690-0338 $2 ,800 .00 $2 ,800.00 $2 ,800.00 $2,800.00 $2 ,800 .00 $2,800 .00 1 / 2 Quote Acceptance: This Quote comprises all material representations and constitutes the entire understanding between the parties to date with respect to the subject matter hereof and supersedes any and all prior representations, offers or agreements either oral or written between the parties with respect to such subject matter. This Quote shall serve as Schedule A to the Customer's contract for procurement of the Product, Training, Service and Support Program as described when applicable, or as an Addendum to Customer/Client's current contract(s) with Milsoft. Terms & Conditions -Services -CIS iXp Services -Custom Payment Terms • Payment due upon receipt of invoice • 100% invoiced upon quote acceptance • Payment must be made in USO Support Program o Annual support at the rate of 20% of the quoted price, to be billed monthly -$2,800 X 20% / 12 = $46.67 o Support invoiced separately Account Name: __________________ _ Accepted By: ___________________ _ Printed Name: ___________________ _ Date: ------------------------ PO# (if applicable): _______________ _ Quote 51060 I Submission Options: quotes@milsoft.com I P.O. Box 5726 Abilene, TX 79608 I Fax: 325-690-0338 2/2 SAGE SANGIACOMO CITY OF UKIAH Mar 11, 2022 M I LS OFT ®·~ Utility Solutions Bill To Lori Martin Ukiah , City of 300 Seminary Avenue Ukiah , CA, 95482-5400 USA Ship To Lori Martin Ukiah , City of 300 Seminary Avenue , Ukiah , CA , 95482-5400 USA Accounting & Utility Billing -Services Schedule A Quote Number: Date Created: Account Manager: E-mail: Phone : Valid Until: 50972 12-09-2021 Paul Kluba paul .kluba@milsoft .com (800) 344-5647 03-02-2022 Quantity Quoted Line Item Retail Price Ext. Price 1.00 CIS iXp Services -Custom Custom request to create a report in the system based on SIC code . Report Shows SIC Code , month , number of Accounts , KWH sales , and revenue. Report shows this info with quarterly data . This will be a report within iXp that will allow them to run it on a date range , come to screen and take to excel or PDF . Add to the reports Tab . SIC Usage Reporting iXp Screen : 1. Prompt for dates From/To a . Today they run Quarterly b. This will allow for a monthly/quarterly/annual report 2 . Prompt for a SIC code or *All SIC Codes a . This will allow a particular SIC or all SIC's to print Produce the SIC Report (to Screen): Allow to PDF Allow to Excel Support is applicable -see Terms and Conditions. Subtotal : Total : Grand Total Subtotal : Total : Quote 509721 Submission Options : quotes@milsoft.com I P.O . Box 5726 Abilene , TX 79608 I Fax : 325-690-0338 $2 ,100 .00 $2 ,100 .00 $2 ,100 .00 $2 ,100.00 $2 ,100.00 $2 ,100 .00 1 / 2 Quote Acceptance: This Quote comprises all material representations and constitutes the entire understanding between the parties to date with respect to the subject matter hereof and supersedes any and all prior representations, offers or agreements either oral or written between the parties with respect to such subject matter. This Quote shall serve as Schedule A to the Customer's contract for procurement of the Product, Training, Service and Support Program as described when applicable, or as an Addendum to Customer/Client's current contract(s) with Milsoft. Terms & Conditions -CIS iXp Services -Custom Payment Terms • Payment due upon receipt of invoice • 100% invoiced upon quote acceptance • Payment must be made in USO Support Program o Annual support at the rate of 20% of the quoted price, billed monthly -$2,100 X 20% = $420 I 12 = $35 o Support invoiced separately Account Name: __________________ _ Accepted By: ___________________ _ Printed Name: ___________________ _ Date: _______________________ _ PO# (if applicable):---------------- Quote 50972 I Submission Options: quotes@milsoft.com I P.O. Box 5726 Abilene, TX 796081 Fax: 325-690-0338 2/2 CITY OF UKIAH SAGE SANGIACOMO Mar 11, 2022 Development & Integration Work Pricing Options In Contract Mi/soft Ticket Add'/ Cost $'s Added Removed Delayed Asof Date Commentary ·•-. --~ DEV-01 Sewer Mod Yes No 15-Jan-22 ..._ _______ --------------r t -----_--~---~ --~ . Dev-02 Collection Fee s No 291342 No 15-Jan-22 --+-- DEV-03 Sewer Rates & Dwellings No I 292554 No 15-Jan-22 ---------. -~ ------.... _____ ._.._ --------r-DEV-04 Elec Rates & Discounts No =w 292564No 15-Jan -22 __ ___,_ e~dinL __ Yes $ : ···~~. DEV-OS SIC Code Report No 2,100.00 Y 1-Feb-22 -----~ DEV-06 Fee s by Account rather than Service/Payment Di stribution No _tending _~ Yes $ 2,800 .00 Y 1-Feb -22 DEV-07 Placeholder No --+----------------=+-T I INT-01 ITRON MVRS/AMR Yes ___J_ 288231 No 15-Jan -22 -----------~----+---~-- INT-02 Bill Printing Yes 289024 No -·t 15-Jan-22 ------·----·-. ------~r~-------+ ---------INT-03 EBPP Yes Ebusiness No 15-Jan -22 ---INT-04 EBPP Yes Invoice Cloud Yes ~·~ 15-Jan-22 Separate Contract handles add'I costs INT-OS Coll ection Agency ~---~-----------Yes No 15-Jan -22 _ ~ding ------...... ---....... -· --INT-06 HEAP Yes 285298No =E 15-Jan-22 ----1 ~ ~ ==r:~ INT-07 Trash Di spo sal Signup Yes 291128 No 15-Jan-22 I INT-08 Trash Add'I charges Yes ' 291128 No 15-Jan-22 ------·---------' INT-09 Bank Lock Box Yes y 15-Jan-22 INT-10 ERP/GL Yes 2873701· 15-Jan-22 ----~----- ------. _--r_ve~ -INT-11 ERP/AP y 15-Jan-22 Removed from Phase I scope --~ INT-12 GIS _ , __ _J_es _______ --y 15-Jan-22 Removed from Phase I scope ----•·-------+ - INT-13 Mobile Wo r k Mgmt Yes y 15-Jan-22 Removed from Phase I scope INT-14 ----~ ~ --15-Jan-22 Removed fro""m Phase I scope GIS & Design ,Yes y ------------i:-----~I --.------.------,... ---- INT-15 CYME -System Planning 295264 No 15-Jan -22 1 Yes ------+-- INT-16 Meter Testing-WECO ·Yes I 295273 No I -~: 15-Jan-22 INT-09(a) -_ --------1---.t= 288234 No T-- Remit+ No y 15-Jan -22 Swapped with INT-09, Bank lock Box --· ----INT-17 Meter Testing -Mfg data No l cancelled No y I 15-Jan-22 ------~----Total s $ 4,900 .00 ATTACHMENT C -Revised per Amendment 1 Vendo r : Milsoft Utility Solutions Description Yearl Vear2 Milsoft Cloud-Based Hosted CIS Solution Reflecting Schedule "A" Quote for Milsoft Base Fees Terms & Conditions -Includes Software Costs Enterprise Accounting & Utility Bi lling (with eBusiness and ePrint) s 74,700.00 $ 36,000 .00 Annual Support Costs (If not included above) Implementation Services Project Management Services Included $ System Setup &Configura t ion Included s Data Conversion from provided flat f iles to your system Included s Interfaces/System Integrat ion Integrations per the Statement of Work (SOW). s 20,000.00 $ 4,000.00 M od ificatio n s (If an y ) ESSFU M odification as per St at ement of W ork (SO W) --Inclu ded $ Customer Reports (if any) SO W required has been marked in areas req ui r i ng more deta il. $ Traini ng Included: Train ing req u ired for standa rd implementa tion through Go Liv e . $ Othe r (Please descri be) Added Optional Item -CIS Training post Go Live Recommended additiona l CIS training post Go Li v e. Three (3 ) d ays on -s ite . s 10,000.00 ---·-----------------·-·-·-·-·-Original contract totals: $ 104,7 00.00 $ 40,000.00 Contract Amendment 1: CIS iXp Services -Custom Fees by Account rather than Service/Payment Distribution change request $ 2,800.00 $ S60 .00 Create report in the system based on SIC Code , month, number of Accounts, KWH sales, and revenue. $ 2,100.00 $ 420.00 Tota l Implementation Services REVISED TOTALS $ 109,600.00 $ 40,980.00 Dates 6/11/2021 7/13/2021 Year3 Year4 s 36,000 .00 s 36,000.00 $ 4,000 .00 $ 4,000.00 .. $ 40,000.00 $ 40,000.00 s 560 .00 $ 560 .00 s 420.00 $ 420 .00 s 40,980 .00 $ 40,980 .00 Implementation Milestone Payments Contract Signing "Effective Date" Project Initiation Pilot Milestone Completion & Acceptance Delivery of all Integration and modifications Years $ 36,000 .00 $ 4,000.00 $ 40,000.00 s $ s 560.00 420.00 40,980 .00 20% 20% 20% 20% Totals s 218,700.00 s s s $ 36,000.00 $ $ $ $ 10,000 .00 $ 264,700 .00 s s $ 5,040 .00 3,780 .00 273,520-00 20,940 .00 20,940.00 20,940.00 20,940.00 Acceptance of all integration and modifications 10% $ 10,470.00 Go -Live 10% $ 10,470.00 CI S iXp Service : Fees by account Upon completion/acceptance $ 2,800 .00 CIS iXp Service : SIC Code Report Upon completion/acceptance $ 2,100.00 Tota l Implementation 100% $ 109,600 .00 Balance Remaining $ 163,920.00 Subscription & support fees for 48 months $ 3,415 .00