Loading...
HomeMy WebLinkAbout4.11 Agreement with Recyclist Software-as-a-Service for Senate Bill 1383 RecordkeepingSTAFF REPORT CITY COUNCIL Page 1 of 3 Agenda Item 4.11 DATE:June 7, 2022 TO:Honorable Mayor and City Councilmembers FROM:Linda Smith, City Manager SUBJECT:Agreement with Recyclist Software-as-a-Service for Senate Bill 1383 Recordkeeping Prepared by:Michelle Sung,Environmental Technician EXECUTIVE SUMMARY:The City Council will consider approving an agreement with Recyclist software-as-a-service for recordkeeping related to Senate Bill 1383. The agreement includes the Recyclist Program Tracker and Route Review Fieldwork Tool. STAFF RECOMMENDATION:Adopt the Resolution Approving a Software-as-a-Service (SAAS)Agreement with Recyclist for Senate Bill 1383 Recordkeeping. FINANCIAL IMPACT:The three-year cost of the Recyclist software is $96,530, comprising $30,510 in annual base fees for the Recyclist Program Tracker, projected data imports, and Route Review Fieldwork Tool, plus a one-time implementation service fee of $5,000. Staff is recommending an additional 10%contingency ($9,653)be included in case additional data set imports are needed or for reasonable, City-approved increases in data import fees over the agreement term.This puts the total not-to-exceed amount for the three-year contract at $106,183, funded by the Alameda County Waste Reduction and Recycling Initiative (Measure D) Fund. There is sufficient appropriation in Fiscal Year 2021-22 to cover the current year cost. Future year costs will be incorporated in each respective fiscal year budget requests. There is no impact to the General Fund. DESCRIPTION:Senate Bill 1383, Short-Lived Climate Pollutants (SB 1383),was signed into law in September 2016 and establishes methane reductions targets to help the State of California meet its climate goals. Targets in SB 1383 include a requirement to achieve by 2025,a 75% reduction in the level 307 Page 2 of 3 of statewide disposal of organic waste from the 2014 level and a requirement that not less than 20% of currently disposed edible food is diverted from landfill to food recovery organizations. SB 1383 includes recordkeeping requirements for the following: Compliance with organic waste collection services Container contamination minimization Waivers and exemptions Education and outreach Compliance with jurisdiction hauler program Edible food recovery program Recovered organic waste procurement target Recycled content paper procurement All documents supporting compliance with the requirements above must be maintained in an Implementation Record stored in one central location that must be available to the California Department of Resources, Recovery, and Recycling (CalRecycle) within 10 business days of request. The Recyclist Program Tracker is a cloud-based compliance and outreach database platform that provides jurisdictions with full customization and collaborative recordkeeping capabilities necessary to meet the SB 1383 recordkeeping requirements. The Recyclist Program Tracker has been in continuous development since August 2015, and Recyclist has communicated with CalRecycle to ensure correct compliance reporting. Recyclist is unique in providing this niche software product and has no known competitors providing comparable services. Recyclist’s platform is a software-as-a-service product, which includes ongoing support and customizations. Since the platform is in continual development, new features and improvements are released on a regular basis as regulations and reporting requirements are developed by the State. Recyclist has many customers in California, including the cities of Pleasanton, Livermore, and San Ramon, and others in Alameda County.Chapter 2.36 of the Dublin Municipal Code (DMC) requires contracts or purchases of general services, supplies, or equipment to go through a competitive bidding process. However, the Municipal Code provides the City Council with authority to waive the competitive bidding process, as stated in DMC 2.36.100(B)(4) when a contract or purchase involves goods of a technical nature, where it would be difficult for a vendor to bid on a standard set of specifications, and the Purchasing Agent undertakes a thorough review of known products and a comparison of features which would most closely meet the city’s needs at the lowest cost. As part of the City’s SB 1383 Implementation Assistance Agreement with Cascadia Consulting Group, Inc., SB 1383 recordkeeping database options were researched, compared, and presented in a Database Tracking and Management Options Report (Attachment 3). After reviewing the report, Staff found Recyclist to be the most comprehensive platform to meet the City’s SB 1383 recordkeeping requirements. Specifically, the Recyclist Program Tracker is the only available database that includes recordkeeping for route reviews, recordkeeping for procurement of recovered organic materials, and built-in data analysis and trends required for CalRecycle’s Electronic Annual Reports. 308 Page 3 of 3 STRATEGIC PLAN INITIATIVE:None. NOTICING REQUIREMENTS/PUBLIC OUTREACH:The City Council Agenda was posted. ATTACHMENTS:1) Resolution Approving a Software as a Service (SAAS) Agreement with Recyclist for Senate Bill 1383 Recordkeeping2) Exhibit A to the Resolution – Recyclist Software as a Service (SAAS) Agreement3) Database Tracking Management Options Report 309 Attachment 1 Reso. No. XX-22, Item X.X, Adopted XX/XX/2022 Page 1 of 2 RESOLUTION NO. XX – 22 A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF DUBLIN APPROVING A SOFTWARE-AS-A-SERVICE (SAAS) AGREEMENT WITH RECYCLIST FOR SENATE BILL 1383 RECORDKEEPING WHEREAS,in September 2016 the California legislature enacted Senate Bill (SB) 1383, Short-Lived Climate Pollutants, with the goal to reduce emissions of short-lived climate pollutants such as methane by mandating a reduction in disposal of organic waste in landfills, among other requirements on dairies and waste haulers; and WHEREAS,the California Department of Resources, Recycling, and Recovery (CalRecycle) was given the regulatory authority to achieve the desired organic waste reduction targets; and WHEREAS,CalRecycle developed final rulemaking for SB 1383 with an implementation date of January 1, 2022; and WHEREAS,SB 1383 requires each jurisdiction to maintain an Implementation Record; and WHEREAS,the City seeks a software system that would assist with tracking SB 1383 compliance and outreach and fulfill the City’s SB 1383 recordkeeping requirements; and WHEREAS,Chapter 2.36 of the Dublin Municipal Code establishes the procedures for contracts and purchasing, which require City Council approval for procurement of goods and services in excess of $45,000 via a competitive bidding process; and WHEREAS,Section 2.36.100(B)(4) of the Dublin Municipal Code allows for an exception to the competitive bid process when a contract or purchase of goods of a technical nature, where it would be difficult for a vendor to bid on a standard set of specifications, and the Purchasing Agent undertakes a thorough review of known products and a comparison of features which would most closely meet the city’s needs at the lowest cost; and WHEREAS,As part of the City’s SB 1383 Implementation Assistance Agreement with Cascadia Consulting Group, Inc., a report was produced on the available recordkeeping and database options; and WHEREAS,Staff reviewed the report and found Recyclist to be the only comprehensive platform to meet the City’s SB 1383 recordkeeping requirements; and WHEREAS,Staff recommends that the City enter into an agreement with Recyclist for a three-year term with a total not-to-exceed amount of $106,183 which includes a contingency amount of $9,653. NOW, THEREFORE, BE IT RESOLVED that the City Council of the City of Dublin does hereby authorize the City Manager to execute the SAAS Agreement with Recyclist, attached hereto as Exhibit A. 310 Reso. No. XX-21, Item X.X, Adopted XX/XX/21 Page 2 of 2 BE IT FURTHER RESOLVED that the City Manager is authorized to approve the use of the contingency funding of $9,653 in the event additional services are necessary. BE IT FURTHER RESOLVED that the City Manager is authorized to execute future SAAS agreement renewals after the three-year agreement term as long as the City continues utilizing the software and adequate budget is available. PASSED, APPROVED AND ADOPTED this 7th day of June 2022, by the following vote: AYES: NOES: ABSENT: ABSTAIN: ______________________________ Mayor ATTEST: _________________________________ City Clerk 311 1 SAAS SERVICES ORDER FORM Customer: City of Dublin Contact: Michelle Sung Address: 100 Civic Plaza Phone: (925) 833-6630 Dublin, CA 94568 Email: michelle.sung@dublin.ca.gov Services: Recyclist Program Tracker (the “Service(s)”). Initial Service Term: 36 months, commencing upon completion of implementation. Service Capacity: Management of regulatory compliance and outreach for commercial and multi-family waste generators within the City of Dublin service area. Implementation Services: Company will use commercially reasonable efforts to provide Customer the services described in the Statement of Work ("SOW") attached as Exhibit A hereto ("Implementation Services"), and Customer shall pay Company the Implementation Fee in accordance with the terms herein. Service Fees: Base Annual Subscription Fee billed upon completion of Implementation Services, subject to the terms of Section 4 herein. Data Import Fees billed upon receipt of each data set, subject to the terms of Section 4 herein. Implementation Fees (one-time): Payable upon execution of the Agreement, subject to the terms of Section 4 herein. SERVICE FEES PRICE QTY 3-YEAR DISCOUNT SUBTOTAL Program Tracker - Base Subscription (standard) $24,900.00 1 -$2,490.00 $22,410.00 Projected Data Set Imports (per data set) $1,000.00 4 -$400.00 $3,600.00 Add-On: Route Review Fieldwork Tool $5,000.00 1 -$500.00 $4,500.00 Total Projected Annual Fees $30,510.00 ONE-TIME FEES PRICE QTY SUBTOTAL Program Tracker Implementation Fee $5,000.00 1 $5,000.00 Total One-Time Fees $5,000.00 Attachment 2 312 2 SAAS SERVICES AGREEMENT This SaaS Services Agreement (“Agreement”) is entered into on this 8th day of June 2022 (the “Effective Date”) between Citizen Communications, LLC dba Recyclist with a place of business at 12313 Soaring Way, Suite 1D, Truckee CA 96161 (“Company”), and the Customer lis ted above (“Customer”). This Agreement includes and incorporates the above Order Form, as well as the attached Terms and Conditions and contains, among other things, warranty disclaimers, liability limitations and use limitations. There shall be no force or effect to any different terms of any related purchase order or similar form unless expressly identifying this Agreement, specifically referencing the provisions of this Agreement to be altered or superseded and signed by the parties after the date hereof. Citizen Communications, LLC dba Recyclist Name: Title: Date: City of Dublin Name: Linda Smith Title: City Manager Date: Emily Coven 5/31/2022 Managing Member 313 3 TERMS AND CONDITIONS 1. SAAS SERVICES AND SUPPORT 1.1 Subject to the terms of this Agreement, Company will use commercially reasonable efforts to provide Customer the Services. As part of the registration process, Customer will identify an administrative user name and password for Customer’s Company account. Company reserves the right to refuse registration of, or cancel passwords it deems inappropriate. 1.2 Subject to the terms hereof, Company will provide Customer with reasonable technical support services in accordance with Company’s standard practice. 2. RESTRICTIONS AND RESPONSIBILITIES 2.1 Customer will not, directly or indirectly: reverse engineer, decompile, disassemble or otherwise attempt to discover the source code, object code or underlying structure, ideas, know-how or algorithms relevant to the Services or any software, documentation or data related to the Services (“Software”); modify, translate, or create derivative works based on the Services or any Software (except to the extent expressly permitted by Company or authorized within the Services); use the Services or any Software for timesharing or service bureau purposes or otherwise for the benefit of a third; or remove any proprietary notices or labels. With respect to any Software that is distributed or provided to Customer for use on Customer premises or devices, Company hereby grants Customer a non-exclusive, non-transferable, non-sublicensable license to use such Software during the Term only in connection with the Services. 2.2 Further, Customer may not remove or export from the United States or allow the export or re-export of the Services, Software or anything related thereto, or any direct product thereof in violation of any restrictions, laws or regulations of the United S tates Department of Commerce, the United States Department of Treasury Office of Foreign Assets Control, or any other United States or foreign agency or authority. As defined in FAR section 2.101, the Software and documentation are “commercial items” and according to DFAR section 252.227‑7014(a)(1) and (5) are deemed to be “commercial computer software” and “commercial computer software documentation.” Consistent with DFAR sectio n 227.7202 and FAR section 12.212, any use modification, reproduction, release, performance, display, or disclosure of such com mercial software or commercial software documentation by the U.S. Government will be governed solely by the terms of this Agreement and will be p rohibited except to the extent expressly permitted by the terms of this Agreement. 2.3 Customer represents, covenants, and warrants that Customer will use the Services only in compliance with its intended functionality and all applicable laws and regulations. Customer shall be responsible for obtaining and maintaining any equipm ent and ancillary services needed to connect to, access or otherwise use the Services, including, without limitation, modems, hardware, servers , software, operating systems, networking, web servers and the like (collectively, “Equipment”). Customer is responsible for m aintaining the confidentiality of the passwords assigned to Customer and its users. Customer will immediately notify Company if it becomes aware that a password is lost, stolen, disclosed to an unauthorized third party, or otherwise compromised. Company wi ll be responsible for any and all activities made pursuant to the licenses granted to Customer’s hereunder and any of its users’ or Equipment or the access credentials to the Services. Customer shall, and shall ensure its users, use commercially reasonable efforts to prevent unauthorized access to, or use of, the Services, and notify Company promptly of any unauthorized access or use. Although Company has no obligation to monitor Customer’s use of the Services, Company may do so a nd may prohibit any use of the Services it believes may be (or alleged to be) in violation of the foregoing. 3. CONFIDENTIALITY; PROPRIETARY RIGHTS 3.1 Each party (the “Receiving Party”) understands that the other party (the “Disclosing Party”) has disclosed or may disclose business, technical or financial information relating to the Disclosing Party’s business (hereinafter referred to as “Proprietary Information” of the Disclosing Party). Proprietary Information of Company includes non-public information regarding features, functionality and performance of the Service. Proprietary Information of Customer includes non-public data provided by Customer to Company to enable the provision of the Services (“Customer Data”). The Receiving Party agrees: (i) to take reasonable precautio ns to protect such Proprietary Information, and (ii) not to use (except in performance of the Services or as otherwise permitted herein) or divulge to any third person any such Proprietary Information. The Disclosing Party agrees that the foregoing shall not apply with respect to any information that the Receiving Party can document (a) is or becomes generally available to the public, or (b) was in its possession or known by it prior to receipt from the Disclosing Party, or (c) was rightfully disclosed to it without restriction by a third party, or (d) was independently developed without use of any Proprietary Information of the Disclosing Party or (e) is required to be disclosed by law. 3.2 Customer shall own all right, title and interest in and to the Customer Data. Company shall own and retain all right, title and interest in and to (a) the Services and Software, all improvements, enhancements or modifications thereto, (b) any software, applications, inventions or other technology developed in connection with Implementation Services or support, and (c) all intellectual property rights related to any of the foregoing. 3.3 Notwithstanding anything to the contrary, Company shall have the right to collect and analyze data and other information relating to the provision, use and performance of various aspects of the Services and related systems and technologies (including, without limitation, information concerning Customer Data and data derived therefrom), and Company will be free (during and after the term hereof) to (a) use such information and data to improve and enhance the Services and for other development, diagnostic and corrective purposes in con nection with the 314 4 Services and other Company offerings, and (b) disclose such data solely in aggregate or other de-identified form in connection with its business. No rights or licenses are granted except as expressly set forth herein. 4. PAYMENT OF FEES 4.1 Customer will pay Company the then applicable fees described in the Order Form for the Services and Implementation Services in accordance with the terms therein (the “Fees”). If Customer’s use of the Services exceeds the Service Capacity set forth o n the Order Form or otherwise requires the payment of additional fees (per the terms of this Agreement), Recyclist shall notify Customer in advance of any additional fees. Upon acceptance of additional fees by Customer, Customer shall be billed for such usage and Customer agrees to pay the additional fees in the manner provided herein. Company reserves the right to change the Fees or applicable charges and to institute new charges and Fees at the end of the Initial Service Term or then‑current renewal term, upon thirty (30) days prior notice to Customer (which may be sent by email ). Notwithstanding the foregoing, all Data Import Fees set forth in the Order Form are, at any time during the Term, subject to reasonable increases bas ed on then-current Company fees for Data Set Imports. If Customer believes that Company has billed Customer incorrectly, Customer must contact Company no later than 60 days after the closing date on the first billing statement in which the error or problem appeared, in order to receiv e an adjustment or credit. Inquiries should be directed to Company’s customer support department. 4.2 Company may choose to bill through an invoice, in which case, full payment for invoices issued in any given month must be received by Company thirty (30) days after the mailing date of the invoice. Unpaid amounts are subject to a finance charge of 1.5% per month on any outstanding balance, or the maximum permitted by law, whichever is lower, plus all expenses of collection and may result in immediate termination of Service. Customer shall be responsible for all taxes associated with Services other than U.S. taxes based on Company’s net income. 4.3 Following the Initial Service Term, the annual subscription fee shall automatically increase (and annually thereafter) by an amount equal to the greater of five percent (5%) or one hundred percent (100%) of the percentage increase in the Consumer Price Index, Urban Consumers, All Cities Average 1982-84 Equals 100, (CPI-U) during the prior calendar year as published by the U.S. Department of Labor or any successor index, compounded annually from the Effective Date. 5. TERM AND TERMINATION 5.1 Subject to earlier termination as provided below, this Agreement is for the Initial Service Term as specified in the Order Fo rm, and shall be automatically renewed for additional periods of the same duration as the Initial Service Term (collectively, the “Term”), unless either party requests termination at least thirty (30) days prior to the end of the then-current term. 5.2 In addition to any other remedies it may have, either party may also terminate this Agreement upon thirty (30) days’ notice (or without notice in the case of nonpayment), if the other party materially breaches any of the terms or conditions of this Agre ement. Customer will pay in full for the Services up to and including the last day on which the Services are provided. Upon any termination, Company will make all Customer Data available to Customer for electronic retrieval for a period of thirty (30) days, but thereafter Company may, bu t is not obligated to, delete stored Customer Data. All sections of this Agreement which by their nature should survive termination will survive termination, including, without limitation, accrued rights to payment, confidentiality obligations, warranty disclaimers, and limitations of liabilit y. 6. WARRANTY AND DISCLAIMER Company shall use reasonable efforts consistent with prevailing industry standards to maintain the Services in a manner which minimizes errors and interruptions in the Services and shall perform the Implementation Services in a professional and workmanlike manner. Services may be temporarily unavailable for scheduled maintenance or for unscheduled emergency maintenance, either by Company or by third -party providers, or because of other causes beyond Company’s reasonable control, but Company shall use reasonable efforts to provide advance notice in writing or by e-mail of any scheduled service disruption. However, Company does not warrant that the Services will be uninterrupted or error free; nor does it make any warranty as to the results that may be obtained from use of the Services. EXCEPT AS EXPRESSLY SET FORTH IN THIS SECTION, THE SERVICES AND IMPLEMENTATION SERVICES ARE PROVIDED “AS IS” AND COMPANY DISCLAIMS ALL WARRANTIES, EXPRESS OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE AND NON-INFRINGEMENT. 7. INDEMNITY Company shall indemnify Customer from liability to third parties resulting from infringement by the Service of any United Sta tes patent or any copyright or misappropriation of any trade secret, provided Company is promptly notified of any and all threats, claims and proceedings relat ed thereto and given reasonable assistance and the opportunity to assume sole control over defense and settlement; Company will not be responsible for any settlement it does not approve in writing. The foregoing obligations do not apply with respect to portions or components of the Service (a) not supplied by Company, (b) made in whole or in part in accordance with Customer specifications, (c) that are modified after delivery by Company, (d) combined with other products, processes or materials where the alleged infringement relates to such combination, (e) wher e Customer continues allegedly infringing activity after being notified thereof or after being informed of modifications that would have avoided the alleged infringement, or (f) where Customer’s use of the Service is not strictly in accordance with this Agreement. If, due to a claim of infringem ent, the Services are held by a court of competent jurisdiction to be or are believed by Company to be infringing, Company may, at its option and expense (i) rep lace or modify the Service to be non-infringing provided that such modification or replacement contains substantially similar features and functionality, (ii) obtain for Customer a license to continue using the Service, or (iii) if neither of the foregoing is commercially practicable , terminate this Agreement and Customer’s rights hereunder and provide Customer a refund of any prepaid, unused fees for the Service. 315 5 Company shall procure and maintain insurance during the term of this Agreement in the amounts and under the terms set forth i n Exhibit “B” against claims that may arise from or in connection with the Agreement and performance of the Services. 8. LIMITATION OF LIABILITY 8.1 Customer acknowledges, understands and agrees that Company utilizes third party hardware, software and hosting solutions in connection with the Services (“Third Party Solutions”) in order to economically provide the Services to Customer. Customer recognizes that the quality of the Services is dependent upon such Third Party Solutions and that Company does not have nor exercise significant bargaining power with such Third Party Solutions so as to reasonably control the Customer’s experience resulting from such Third Party Solutions, and therefore notwithstanding any other provision of this Agreement to the contrary, agrees that Company shall not be liable or in breach o f this Agreement to the extent such liability or breach is the result of the acts or omissions of Third Party Solutions or their providers. The location of Third Party Solutions Data Centers is California (primary), New York (secondary), and an undisclosed location in the United States (backup). In the event that Company changes Third Party Solutions resulting in a movement of Data Centers, Company shall provide Customer with prior written noti ce of said change and disclose the name and location of new Third Party Solutions and Data Centers. The replacement of Third Party Solutions shall be reputable compared to current, and the Data Centers shall be located within the United States. 8.2 NOTWITHSTANDING ANYTHING TO THE CONTRARY, EXCEPT FOR BODILY INJURY OF A PERSON, COMPANY AND ITS SUPPLIERS (INCLUDING BUT NOT LIMITED TO ALL EQUIPMENT AND TECHNOLOGY SUPPLIERS), OFFICERS, AFFILIATES, REPRESENTATIVES, CONTRACTORS AND EMPLOYEES SHALL NOT BE RESPONSIBLE OR LIABLE WITH RESPECT TO ANY SUBJECT MATTER OF THIS AGREEMENT OR TERMS AND CONDITIONS RELATED THERETO UNDER ANY CONTRACT, NEGLIGENCE, STRICT LIABILITY OR OTHER THEORY: (A) FOR ERROR OR INTERRUPTION OF USE OR FOR LOSS OR INACCURACY OR CORRUPTION OF DATA OR COST OF PROCUREMENT OF SUBSTITUTE GOODS, SERVICES OR TECHNOLOGY OR LOSS OF BUSINESS; (B) FOR ANY INDIRECT, EXEMPLARY, INCIDENTAL, SPECIAL OR CONSEQUENTIAL DAMAGES; (C) FOR ANY MATTER BEYOND COMPANY’S REASONABLE CONTROL; OR (D) FOR ANY AMOUNTS THAT, TOGETHER WITH AMOUNTS ASSOCIATED WITH ALL OTHER CLAIMS, EXCEED THE FEES PAID BY CUSTOMER TO COMPANY FOR THE SERVICES UNDER THIS AGREEMENT IN THE 12 MONTHS PRIOR TO THE ACT THAT GAVE RISE TO THE LIABILITY, IN EACH CASE, WHETHER OR NOT COMPANY HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES AND WHETHER OR NOT SUBJECT TO THE INDEMNIFICATION OBLIGATIONS OF COMPANY HEREUNDER. 9. MISCELLANEOUS If any provision of this Agreement is found to be unenforceable or invalid, that provision will be limited or eliminated to the minimum extent necessary so that this Agreement will otherwise remain in full force and effect and enforceable. This Agreement is not assignable, transferable or sublicensable by Customer except with Company’s prior written consent. Company may transfer and assign any of its rights and obligations under this Agreement without consent. This Agreement is the complete and exclusive statement of the mutual understanding of the parties and supersedes and cancels all previous written and oral agreements, communications and other understandings relating to the subject matter of this Agreement, and that all waivers and modifications must be in a writing signed by both parties, except as otherwise provided herein. No agency, partnership, joint venture, or employment is created as a result of this Agreement and Customer does not have any authority of any kind to bind Company in any respect whatsoever. In any action or proceeding to enforce rights under this Agreement, the prevailing party will be entitled to recove r costs and attorneys’ fees. All notices under this Agreement will be in writing and will be deemed to have been duly given when received, if personally delivered; when receipt is electronically confirmed, if transmitted by facsimile or e-mail; the day after it is sent, if sent for next day delivery by recognized overnight delivery service; and upon receipt, if sent by certified or registered mail, return receipt requested. This Agreement shall be governed by the laws of the State of California without regard to its conflict of laws provisions. 316 6 EXHIBIT A Statement of Work Implementation of the Recyclist Program Tracker includes: ● Configuring data import process to align with Customer’s data and programmatic objectives ● Importing initial compliance records ● Setting up user accounts and permissions ● Customizing database fields to meet reasonable customer needs ● Customizing reports to meet reasonable customer needs Base subscription includes: ● Commercial and multi-family generator database for tracking: ○ Service levels ○ Contact information ○ AB 1826 & AB 341 compliance ○ SB 1383 compliance (rolling out in phases) ● Log of all outreach activities ● CRM features to schedule and track outreach to commercial generators, including: ○ Site Visits ○ Phone Calls ○ Emails ○ Photos taken ○ Task lists and calendars ○ Task reminders and summaries ● Customization of standard forms and reports to meet reasonable customer needs, such as: ○ Tracking local programs and pilot projects ○ Tracking compliance with state, regional and/or local ordinances ○ Complex customization projects necessitating new forms and/or reports may require additional professional services. Any additional consulting, training, development, configuration, development and/or integration services may be out of scope and subject to Company agreeing to provide such services pursuant to a change order to this SOW. ● Reports in list and/or graph format, with ability to search, sort and filter, and to export to Excel, PDF, or image file ● Cloud-based database that syncs data across all users in real time ● Web-based application, with mobile app for iOS and Android (requires internet connection) ● Secure web hosting with weekly backups ● Support via email, Monday-Friday 9am-5pm PT ● Support via phone by appointment ● Unlimited users Data Import includes: ● Processing and importing a single-tab Excel worksheet or CSV file ● For service record data imports: ○ Importing new accounts, identifying possibly closed accounts and service-level changes ○ Updating generator compliance statuses to align with new data ● Custom Data Template Surcharge applicable to any Data Imports not delivered in the standard Recyclist Service Record Template 13090458_v7 317 7 EXHIBIT B Insurance Requirements Minimum Scope and Limits of Insurance 1. Commercial General Liability Insurance. Contractor, at its own cost and expense, shall maintain commercial general liability insurance including operations, products, and completed operations, as applicable for the term of this Agreement in an amount not l ess than $1,000,000 per occurrence/$2,000,000 aggregate for bodily injury, personal injury, and property damage. If Commercial General Liability Insurance or other form with a general aggregate limit is used, either the general aggregate limit shall apply separately to this project/location or the general aggregate limit shall be at least twice the required occurrence limit. 2. Cyber and Professional Liability/Errors and Omissions. Contractor, at its own cost and expense, shall maintain cyber and professional liability/errors and emissions insurance for the term of this Agreement in an amount no less than $1,000,000 per claim. Coverage shall be sufficiently broad to respond to the duties and obligations as is undertaken by Contractor in this agreement and sh all include, but not be limited to, claims involving infringement of intellectual property, including but not limited to infringement of copyright, trademark ,trade dress, invasion of privacy violations, information theft, damage to or destruction of electronic information, release of pr ivate information, alteration of electronic information, extortion and network security. The policy shall provide coverage for breach response c osts as well as regulatory fines and penalties as well as credit monitoring expenses with limits sufficient to r espond to these obligations. Deductibles and Self-Insured Retention All self-insured retentions (SIR) must be disclosed to Risk Management for approval and shall not reduce the limits of liability. Policies containing any SIR provision shall provide, or be endorsed to provide, that the SIR may be satisfied by either the named insured or the City of Dublin. The City of Dublin reserves the right to obtain a full certified copy of any insurance policy and endorsements. Failure to exercise th is right shall not constitute a waiver of right to exercise later. Acceptability of Insurers All insurance required by this exhibit is to be placed with insurers with a current A.M. Bests' rating of no less than A:VII and accepted to do business in the State of California, unless otherwise acceptable to the City of Dublin. Other Insurance Provisions The general liability policy is to contain, or be endorsed to contain, the following provisions: 1. The City of Dublin, its officers, employees, and designated volunteers are to be covered as additional insureds as respects: liability arising out of work or operations performed by or on behalf of the Contractor. 18482604_v2 318 Database Tracking and Management OPTIONS REPORT AUGUST 2021 CASCADIA CONSULTING GROUP, INC. Tel (206) 343-9759 www.cascadiaconsulting.com Attachment 3 319 DATABASE TRACKING AND MANAGEMENT OPTIONS REPORT | 1 DATABASE TRACKING AND MANAGEMENT OPTIONS REPORT INTRODUCTION This report details Cascadia’s findings from researching different database tracking and management platforms. These findings will help inform the City of Dublin on available database tracking and management platforms to track compliance progress as required by Senate Bill 1383 (SB 1383). Cascadia researched five data tracking and management platforms: Recyclist, Minerva, Salesforce, Fulcrum, Spotio, and Green Halo. METHODOLOGY The five platforms listed above were selected for the following reasons: • Recyclist and Minerva are designed for solid waste program management and have built in features for SB 1383 compliance and reporting. • Salesforce is a universally known data management platform. From prior experience using the platform, Salesforce is very customizable and compatible with various other applications. • Cascadia often uses Fulcrum and Spotio for short term outreach and technical assistance tracking. These platforms are more affordable than the larger platforms such as Salesforce and have worked well for short term projects. We are interested in better understanding their capabilities for long-term data tracking and management. • The Green Halo platform, typically used for construction waste management, is currently developing a new feature for SB 1383 required procurement tracking. Cascadia began by conducting desktop research to answer the list of questions below. After the initial desktop research, Cascadia scheduled and participated in calls and demonstrations with sales representatives at each platform to better understand platform features and fill in any missing information not readily available online. Cascadia asked sales representatives of each platform the following questions: • What is the cost per year or quarter? • What is the baseline cost and any additional costs? • What are the various ways users can access the platform (web, desktop app, phone/tablet app)? • How many users can access on one platform subscription? Can multiple organizations use the platform under the same subscription? • Can different users have different levels of access (privacy)? • How long will it take for the platform to go live after signing the contract? • What is the available technical support? Is there phone or chat support available? What are the hours of support? • Are there features available for account activities tracking (site visits, calls, emails)? • Ability to document outreach provided: date, time, type of material provided to account holder? • Ability to tag other users to follow up with an account? To -dos or adding to a person’s activity queue? • Ability to upload attachments such as letters, photos, etc.? • Ability to easily use tracking capabilities in the field on a tablet? • Ability to link related accounts? i.e. main account with hauler data linked to tenant accounts. 320 DATABASE TRACKING AND MANAGEMENT OPTIONS REPORT | 2 • Activity/account mapping available? • Form fill-ins available? • Any built-in data analysis features? Trends? • Able to export information to excel? • Compatibility with other platforms? The following questions specific to SB 1383 compliance features were asked to Recyclist and Minerva. • Ability to view service levels and accounts that are SB 1383 compliant/non-compliant based on service levels? • Ability to document which accounts have waivers, when it was granted, and reason for waiver? • Ability to document which accounts are sharing or backhauling and upload documentation? • Ability to document which accounts are subject to food recovery requirements, which have food recovery agreements, pounds of food rescued, etc? • Ability to document/track type and amount of recovered organic material procured, where it was procured from, and where it was applied? Ability to document route reviews (for container contamination minimization): able to log results of lid flipping assessments, outreach provided, and which routes reviewed-including residential? Attachment A includes a comparison matrix that presents information collected during desktop research and calls. SUMMARY AND FINDINGS Below are summaries of Cascadia’s research of the five platforms. Recyclist Pros • Company is familiar with California waste laws and the compliance requirements • Platform has been operating since 2015 and many juristictions are subscribed to the platform and use it. • Has features specifically for SB 1383 compliance o Has built-in reporting abilities for CalRecycle Electronic Annual Reports • Unlimited users can access platform under one subscription • Ability to grant different permission levels for users • Tech support available via email and phone Monday through Fridays 9AM – 5PM PST • Available on web and phone/tablet app on Android and iOS Cons • Long turnaround time from signing the contract to platform going live. Takes approximately 2-3 months to setup platform but timeline could be shortened if Recyclist receives initial import data quickly o Actual onboarding once received data is 1.5 months but cannot guarantee quick turnaround if they receive a lot of new customers in the next 6 months • More costly than all other platforms except Salesforce Cost If signing a 1-year contract: $33,900 for the first year and $28,900 annually thereafter • Cost includes base subscription, estimated data imports, and one-time implementation fee of $5,000 321 DATABASE TRACKING AND MANAGEMENT OPTIONS REPORT | 3 If signing a 3-year contract: $31,010 for the first year and $26,010 annually thereafter • Cost reflects 10% discount for 3-year term and one-time implementation fee of $5,000 Minerva Pros • Company is familiar with California waste laws and the compliance requirements • Has features specifically for SB 1383 compliance • Unlimited users can access platform under one subscription • Ability to grant different permission levels for users • Can generate letters to send to recipients, such as notifications regarding compliance requirements • Tech support available via phone and chat feature Monday through Friday 9AM – 5PM • Company is very open to developing custom features relevant for the City’s specific needs (currently working with many local government and waste haulers) • Less costly than Recyclist • Turnaround time after signing contract to platform going live is 30-45 days Cons • Less available features than Recyclist • Many desired features are currently still under development and many will likely be ready in September 2021 o Currently developing the following features:  Ability to document which accounts are subject to food recovery requirements, which have food recovery agreements, pounds of food rescued, etc.  Ability to assign users to follow-up with specific accounts  Ability to view accounts on a map  Ability to link parent account to related accounts • Relatively new platform (could be more prone to startup issues). • Currently only available on Android and not on iOS Cost If paying annually: • $3500/quarter o Annual cost is $14,000 If paid quarterly: • $3900/quarter o Annual cost is $15,600 Salesforce Pros • Ability to grant different permission levels for users • Ability to assign users to follow-up with specific accounts • Greatest number of functions and features available • Able to integrate data from various apps and platforms • Many built-in data analysis features 322 DATABASE TRACKING AND MANAGEMENT OPTIONS REPORT | 4 • Tech su pport available 24/7 • Available on web and phone/tablet app on Android and iOS Cons • Most expensive platform • In addition to the baseline cost of the platform, the City would also need to pay for an implementation partner to setup Salesforce platform. • Does not have features specifically for SB 1383 compliance Cost • Professional plan: $900/user/year o Cost for 50 users: $45,000/year • Executive plan: $1800/user/year o Cost for 50 users: $90,000/year Fulcrum Pros • Highly customizable features • Ability to grant different permission levels for users • Ability to create PDF forms o Ability to email the form to recipient directly from platform • Tech support available through chat feature on web browser or email Monday through Friday 9AM – 5PM EST o Typical response time is 10 minutes • Quick turnaround from signing contract with platform going live (about 20 minutes) o See con below about self-setup • Available on web and phone/tablet app on Android and iOS Cons • Requires self-setup: import data and customize • Does not have features specifically for SB 1383 compliance Cost If paying annually: • Essentials plan - $22/user/month o Cost for 50 users: $13,200/year • Professional plan - $30/user/month o Cost for 50 users: $18,000/year Spotio Pros • Highly customizable platform 323 DATABASE TRACKING AND MANAGEMENT OPTIONS REPORT | 5 • Ability to grant different permission levels for users • Many built-in data analysis features • Tech support available via phone, chat feature, or email o Chat support is available Monday - Friday 8AM - 5PM CST, and Saturday 12PM - 4PM CST o Will be assigned a specific account manager that can answer any questions if there are more than 20 users o Typical response time is 1 minute • Spotio staff will train all users subscribed to the platform • Available on web and phone/tablet app on Android and iOS Cons • Platform is more suitable for companies that need to make sales or profits • More costly than Minerva or Fulcrum but offers less relevant features • Cascadia team previously used Spotio to track outreach efforts on a different project and found the platform did not suit their needs due to changes in user access, pricing structure, and limited features such as only one status option and less flexibility for the type of data that could be collected • Does not have features specifically for SB 1383 compliance Cost Team plan pricing for more than 20 users: • $34/user/month o Cost for 50 users: $20,400/year Green Halo Pros • Company is familiar with California waste laws and the compliance requirements • Currently working closely with local jurisdictions to develop this new procurement tool to fit the needs of SB 1383 • Tech support available via phone or chat feature Monday through Friday 7AM – 7PM PST • Once the tool launches, turnaround time from signing contract to platform going live is 1-2 weeks Cons • Tools and features not yet available • This will be the first year in operation for this feature (more prone to issues) Cost Not currently available. 324 Attachment A: Database Tracking and Management Platform Comparison MatrixFunctionalityRecyclistMinervaSalesforceFulcrumSpotioGreen Halo SystemsCost per year or quarterTBDWhat is the baseline cost and additional cost for add‐on features, if needed (see list of features below)Pricing for Dublin:Base year subscription: $24,900Estimated Data Imports: $4,000Discount for 3‐year term: ($2,890)Total Annual Cost (if a 3‐year‐term): $26,010+ Implementation Fee (one‐time cost): $5,000Paid Annually: $3,500 per quarter ($14,000/year)Paid Quarterly: $3,900 per quarter ($15,600)Professional ‐ $900/user/year (Cost for 50 users: $45,000)Enterprise ‐ $1800/user/year (Cost for 50 users: $90,000)This does not include the fee for an implementation partner that helps to set up the Salesforce platform for us to use for our use‐case.Annually payment pricing: Essentials ‐ $22/user/month (For 50 users, would equal $13,200/year) Professional ‐ $30/user/month (For 50 users, would equal $18,000/year)Monthly payment pricing:Essentials ‐ $28/user/month (For 50 users, would equal $16,800/year) Professional ‐ $38/user/month (For 50 users, would equal $22,800/year)Both pricing have an Enterprise option that has more media storage and more features but need to contact Fulcrum to determine the pricing.Varying pricing for add‐on features4 plan levels (Team, Business, Pro, and Enterprise), and prices were provided for a Team plan.If less than 10 users $39/user/monthMore than 20 users, price drops to $34/user/month (Cost for 50 users: $20,400/year)If less than 10 users, must be billed annually.If more than 10 users, can be billed monthly.TBDPlatforms available (web, desktop app, phone/tablet app)WebPhone/Tablet appWeb (can be accessed on the web and on tablet/phone browser)Phone/Tablet (Only available on Android at the moment. Have an Apple app created but Apple doesn't have it in the App Store because it's not a general use app but can work with a client to get it available)WebPhone/Tablet appWebPhone/Tablet appWebPhone/Tablet app (slightly more capabilities on tablet app, but all features on phone vs. tablet are the same)Web only but can be accessed via mobile browser.How many users can access? Unlimited usersUnlimited usersAs many as we pay for (cost is per/user) As many as we pay for (cost is per/user) As many as we pay for (cost is per/user) Unlimited usersPrivacy features? Able to have different levels of access for different users? (Can multiple organizations use it under the same subscription)Yes, 3 standard permission levels and can create custom permission levels.Yes, can make sure that different users have different access. Minerva uses this when a city has different haulers so each hauler only sees their own accounts.Yes, can set different privacy levels for if have Salesforce Classic or Lightning Experience.Multi‐Org configuration is also an Enterprise 2.0 account configuration and is upon request.Yes, can have an account that can edit details in the account but cannot export the information.Yes, permission levels are Sales, Manager, and Account Admin. There are custom settings for each level that the admin can make as well like not allowing people in a certain level to delete a lead, or hiding leads in a certain area.Sales ‐ Sales Reps are able to create new leads, change assigned leads, and see all leads within their assigned territory.Manager ‐ Managers have full access to all leads and users within their assigned territory.Account Admin ‐ Admins can change company settings, including billing.Yes, there will be at least 2 levels of access: Admin Users and Normal Users. Similar to our Green Halo tool where Admin Users can make settings changes, access the system, and use the functions and Normal Users can access and use the functions, but cannot make Settings changes.Are any features available to specifically track SB 1383 compliance? Able to view service levels and accounts that are SB 1383 compliant and which are not compliant based on service levels?YesYesYes, can put in service levels to accounts, and likely can customize the platform to show that they're not compliant if service levels meet some requirement.Able to document which accounts have waivers, when it was granted, and reason for waiver?Yes YesYes, can customize a field to do thisAble to document which accounts are sharing or backhauling & upload documentation?Yes, able to documenting backhaulingYesYes, can customize a field to do thisAble to document which accounts are subject to food recovery requirements, which have food recovery agreements, pounds of food rescued, etc.Yes Yes, able to document food recovery requirements.Food recovery agreements and pounds of food rescued are in development.Yes, can customize a field to do thisAble to document/track type & amount of recovered organic material procured, where it was procured from, where it was appliedYes, for procurement they're approaching it depending on our Customers’ specific situations. Recyclist should be able to track all 4 pieces of information but will need to check on that with the Product team.Under development and will likely ready by end of SeptemberYes, can customize a field to do this YesAble to document route reviews (for container contamination minimization): able to log results of lid flipping assessments, outreach provided, which routes reviewed‐including residentialYes NoLikely yesHow long will it take from signing the contract to have the platform live?2‐3 months process but can be shortened if Recyclist receives initial data import quickly. Actual onboarding once data is received is 1.5 months, but cannot guarantee quick turnaround if they receive a lot of new customers in the next 6 months.30‐45 days Procuring Salesforce will go through Carasoft paper. Carasoft will be able to process within 24‐48 hours assuming there's a signed order with PO. User should be available to start building the platform within 20 minutes after signing up.Would have a kick‐off call 2 days after signing contract. Spotio will build the platform and will make sure that all the features needed are there. Then Spotio would train users to use the platform, which would take about a week but depends on how many people need to be trained.Generally 1‐2 weeks (assuming the tool is ready to launch)Technical support availabilityYes, have a third party implementation system Spotio trains everyone that needs to use Spotio.Phone support? Hours?Yes, tech support via email and phone, Monday ‐ Friday 9AM ‐ 5PM PSTYes, Monday ‐ Friday 9AM ‐ 5PMYes, 24/7 availabilityNoDirect phone line or email for 90 days; but if there's about 20 (or more) users there will be an account manager that will be assigned to answer questions with them.Typically will respond in 1 minute.Yes. Hours: Monday ‐ Friday 7AM ‐ 7PM PSTPhone: 1‐888‐525‐1301325 Appendix A: Database Tracking and Management Platform Comparison MatrixFunctionality Recyclist Minerva Salesforce Fulcrum Spotio Green Halo SystemsChat feature? Hours? No chat feature Yes, Monday ‐ Friday 9AM ‐ 5PM Yes, 24/7 availability Chat feature on web browser or email Monday ‐Friday 9‐5AM EST, 10 minute response time.Yes, chat feature available on web browser and in app and can email the support. Available Monday ‐ Friday 8AM ‐ 5PM CST, and Saturday 12PM ‐ 4PM CST.Support email: Support@spotio.com Yes, and email. Hours: Monday ‐ Friday 7AM ‐ 7PM PSTDesired featuresAccount activities tracking (site visits, calls, emails) Yes Yes Yes Yes Yes, can note if a site visit, call, or email was madeAble to document outreach provided: date, time, type of material provided to account holderYes Yes Yes Yes Yes, there's a notes section to note these or can make it a dropdown to select what material was provided.Able to tag other users to follow up? To‐dos or adding to a person's queue?Yes, tasks can be delegated using the task schedule Under development, likely done by end of SeptemberYes Yes Yes, can reassign a lead, or create an event and reassign to a different.Able to upload attachments such as letters, photos, etc?Yes Yes Yes Yes YesAble to easily use tracking capabilities in the field on a tablet?Yes Yes Yes Yes Yes, the app is easy to useAble to link parent account to related accounts? Yes, have a system to identify multi‐tenant properties (strip malls) and tracking individual tenants.Under development and will likely done by the end of SeptemberYes, can be customized through Lightning Experience.Maybe/yes. It could be possible through customizing the fields so by putting a question about location type and then having another field pop‐up if it says landlord (or another term for consistency).Yes, can create a field to note that outreach was done at the same property if going to an apartment complex, townhome community, business plaza, etc.Activity/account mapping available? Yes Under development and will likely done by the end of SeptemberYes, through Salesforce MapsYes, can see it in the map if you input the coordinates.Yes, can view a map and tags of all leads.Form fill‐ins (for waivers) available? Yes Yes, but primarily for Call‐To‐Actions letters. Docusign or Nintex app exchange products can do this.Yes, they have a feature where you can create a pdf and be able to fill it out either on the web or on the phone/tablet app (rep called this "workflow"). Can create a setting so that once the pdf is filled out, it can be sent to an email via the app. There is also an option to include signatures on the PDF if needed. Then can filter the accounts on Fulcrum to see which ones have the form.Able to put a question that says "compliant", "exempt", etc. and filter to see those individual lists of the accounts that are compliant, exempt or etc.Any built‐in data analysis features? Trends? Yes, has built‐in reporting for CalRecycle Electronic Annual ReportsNo, the system is not meant to have many graphs, but for outreach tracking purposes, the map feature (which is under development) will likely be useful. At the moment, users would need to download the spreadsheets to do an analysis if desired.Yes, with the Einstein Tool. The tool that uses artificial intelligence to analyze past behavior to find trends and make predictions to know which ones need attentions, which leads are more likely etc.Yes, some analysis, but they mostly show countsYes, they have built‐in analysis features that can show you how many flyers/brochures were distributed, how many site visits were made, etc.Able to export information to excel? Yes, as well as PDF or image file Yes Yes, can also customize what information gets exported in a spreadsheet. Anyone with access to the database can run a report anytime they want. If there's one particular report that you repeatedly want to keep track of, you can schedule it to be sent to you daily, weekly, monthly, etc.Yes, and can customize the information a user wants to export.Yes, and can customize the information a user wants to export.Compatibility with other platforms? No. They do not do this because of errors and inconsistencies not caught by API.Yes, compatible with hauler billing systems:‐ A.M. Disposal‐ AAA Rubbish‐ American Reclamation‐ Athens Disposal Company‐ Calmet Services‐ CR&R‐ G‐B Rubbish‐ Haul‐Away‐ Rubbish Service‐ Key Disposal‐ NASA Services‐ Quality Waste Service‐ Republic Services‐ Serv‐wel Disposal‐ Universal Waste Systems‐ Waste & Recycling Services‐ Waste ManagementYes, compatible with many different apps. Likely no Yes, can be integrated with over 2000 other apps including the user's email so that you can see a person's calendar within the platform. This feature is useful if you are assigning a task to a user and need to see their availability to schedule meeting.Other notes‐ Working to ensure security by making sure Samal security level is met‐ The approach on Minerva is to focus on reporting (the company is mostly accountants that like excel spreadsheets or PDFs)‐ Use AI to try help automate things for haulers‐ They can do custom development and are flexible with their clients to create features that may be useful for all their clients‐ Database is very customizable and they like to work with clients to accommodate for their budgets‐ Salesforce is good if we have to do a lot of integration with different platforms‐ Can customize how we want. There is a team at Fulcrum that's available to help but  the platform is designed for users to customize to fit needs.‐ Suggested to do a free trial to try out the platform and app‐ When tagging a location or residence on the map, their platform may already have resident information listed.‐ The app also has GPS tracking to ensure that the field rep actually visited the site. This is a feature that's helpful for customers that have canvassers because they need to be within 10 feet of the location they marked that they canvassed at.Notes: A few of the platforms provided pricing based on users per month, so cost comparisons between the five platforms used the assumption of 50 users per year.Saleforce features above are based on the Executive PlanFulcrum features above are based on the Professional Plan326