Loading...
HomeMy WebLinkAbout12-08-20 City Commission Packet Materials - C2. PSA w A2ES for Water Supply Optimization and Management Tool Commission Memorandum REPORT TO: Honorable Mayor and City Commission FROM: Brian Heaston, Senior Engineer Mitch Reister, Director of Public Works SUBJECT: Authorize the City Manager to Sign a Professional Services Agreement with Advanced Engineering and Environmental Services, Inc. for the Water Supply Optimization and Management Tool – Phase 1 Project. MEETING DATE: December 8, 2020 AGENDA ITEM TYPE: Consent RECOMMENDATION: Authorize the City Manager to Sign a Professional Services Agreement with Advanced Engineering and Environmental Services, Inc. for the Water Supply Optimization and Management Tool – Phase 1 Project. BACKGROUND: The attached professional services agreement (PSA) with Advanced Engineering and Environmental Services (AE2S) provides a detailed evaluation of the reliable hydrologic yield of the City’s municipal water supply sources to assess physical and legal water availability on a monthly basis. This evaluation when coupled with current and projected future monthly water demands provides an important tool to optimize and manage the City’s municipal water supplies both now and into the future. At present, the City’s existing municipal water supplies are sufficient to meet current water demands, but the existing supply sources will not support population growth indefinitely. The project will provide City staff with a management tool to assess monthly water availability given actual water demands and anticipated additional demands tied to proposed development. The tool will provide crucial knowledge to manage the City’s current water supply sources and growth related decisions. The tool will also provide scenario planning capability to assess when new water supply development projects must be completed in order to support future population growth. Pursuant to state procurement statute, AE2S was selected as the most qualified firm to perform professional engineering services upon review of RFPs received for the project. FISCAL EFFECTS: The scope and fee negotiated for the project amounts to a total cost of $168,850.00. The project is funded by project W80 in the FY18 Water Fund CIP, providing $150,000. These funds have rolled forward and remain available in the current fiscal year. The 38 $18,850.00 remainder of the project balance will be funded by remaining unspent funds in the FY21 Water Fund CIP for project W04-21 – Water Pipe Replacement Program Construction. Sufficient funding is available for the project. ALTERNATIVES: As suggested by the Commission. ATTACHMENTS: Professional Services Agreement 39 PROFESSIONAL SERVICES AGREEMENT THIS AGREEMENT is made and entered into this day of ,2020, by and between the CITY OF BOZEMAN, MONTANA, a self-governing municipal corporation organized and existing under its Charter and the laws of the State of Montana, 121 North Rouse Street, Bozeman, Montana, with a mailing address of PO Box 1230, Bozeman, MT 59771, hereinafter referred to as “City,” and Advanced Engineering and Environmental Services, Incorporated with a mailing address of 4050 Garden View Drive, Suite 200, Grand Forks, ND 58201, hereinafter referred to as “Consultant”, collectively referred to as “Parties”. In consideration of the mutual covenants and agreements herein contained, the receipt and sufficiency whereof being hereby acknowledged, the parties hereto agree as follows: 1. Purpose: City agrees to enter this Agreement with Consultant to perform for City services described in the Scope of Services attached hereto as “Exhibit A” and by this reference made a part hereof for the Project: Water Supply Optimization and Management Tool – Phase 1. 2. Term/Effective Date: This Agreement is effective upon the date of its execution and will terminate upon satisfactory completion of the agreed Scope of Services, which may be amended from time to time by the mutual agreement of the Parties pursuant to terms of this agreement, as determined by the City. 3. Scope of Services: Consultant will perform the work and provide the services in accordance with the requirements of the Scope of Services. For conflicts between this Agreement and the Scope of Services, unless specifically provided otherwise, the Agreement governs. Consultant may, at its own risk, use or rely upon design elements and information ordinarily or customarily furnished by others, including, but not limited to, specialty contractors, Sub- consultants, manufacturers, suppliers, and publishers of technical standards. 4. Payment for Scope of Services: City agrees to pay Consultant for the completion of the Scope of Services a lump sum amount of $93,287.00. The Consultant’s billing rates in $/hr for its employees and a detailed breakdown of personnel hours directly assigned to each task of the Scope of Services is provided herewith as “Attachment 1”. 5. Reimbursable Expenses: As defined in section 8 of this Agreement, for completion of the Scope of Services and approved Additional Services, reimbursable expenses shall be paid to the Consultant by the City in the actual amount of the costs incurred up to an amount not to exceed $75,563.00, which includes $75,506.55 for Sub-consultants hired by the Consultant and $56.45 for all other reimbursable expenses. The estimated reimbursable expenses are provided herewith as “Attachment 2”. The administrative markup factor being applied by the Consultant for any of its Sub-consultants shall be indicated on Attachment 2 and be no higher than 1.05. 6. Additional Services: If the City requests Consultant to perform any Additional Services not otherwise provided for in this Agreement, City shall so instruct the Consultant in writing, and 40 the Consultant shall perform, or direct its Sub-consultants to perform, such services necessary to complete the Additional Services requested. The City and Consultant shall mutually agree in writing upon the scope of Additional Services prior to their commencement. The basis of payment for Additional Services shall be equal to the Consultant’s Direct Labor Rates times a factor of 3.2. A tabulation of direct labor rates for employees performing Additional Services work shall be provided at the time the scope of Additional Services is requested. An administrative markup factor of 1.0 shall be applied by the Consultant for any of its Sub- consultants performing agreed Additional Services work. 7. Times of Payments: The Consultant may submit monthly statements for the Scope of Services and approved Additional Services rendered and for Reimbursable Expenses incurred. The statements shall be based upon Consultant’s estimate of the proportion of the total Scope of Services actually completed for each task at the time of billing. 8. Meaning of Terms: a. Additional Services: Additional Services means services resulting from significant changes in the general scope, extent or character of the Project or major changes in documentation previously accepted by the City where changes are due to causes beyond the Consultant’s control. Additional Services can also mean providing other services not otherwise provided for in the Agreement that are substantially similar to and generally consistent with the nature of services contained in the Scope of Services. b. Agreement: As used herein the term “this Agreement” refers to the contents of this document and its Attachments and Exhibits attached hereto and referred to as if they were part of one and the same document. c. Direct Labor Rates: Direct Labor Rates used as a basis for payment mean the actual salaries and wages paid to all of the Consultant’s personnel engaged directly on any agreed Additional Services, but does not include rates for indirect fringe benefits, indirect overhead expenses, and profit. d. Reimbursable Expenses: Reimbursable expenses mean the actual expenses incurred by the Consultant or its Sub-consultants directly in connection with the Project, such as expenses for: transportation and subsistence incidental thereto; toll telephone calls; specialized technology or software subscription charges; reproduction of reports, technical memoranda, drawings, renderings and similar Project-related items. e. Sub-consultants: Sub-consultants means any independent professional associates working on the Project that are not directly employed by the Consultant and have rather been hired by the Consultant to serve a particular role or offer a particular service for the Project. 9. Consultant’s Representations: To induce City to enter into this Agreement, Consultant makes the following representations: 41 a. Consultant has familiarized itself with the nature and extent of this Agreement, the Scope of Services, and with all local conditions and federal, state and local laws, ordinances, rules, and regulations that in any manner may affect cost, progress or performance of the Scope of Services. b. Consultant represents and warrants to City that it has the experience and ability to perform the services required by this Agreement; that it will perform said services in a professional, competent and timely manner and with diligence and skill; that it has the power to enter into and perform this Agreement and grant the rights granted in it; and that its performance of this Agreement shall not infringe upon or violate the rights of any third party, whether rights of copyright, trademark, privacy, publicity, libel, slander or any other rights of any nature whatsoever, or violate any federal, state and municipal laws. The City will not determine or exercise control as to general procedures or formats necessary to have these services meet this warranty. 10. Independent Consultant Status/Labor Relations: The parties agree that Consultant is an independent Consultant for purposes of this Agreement and is not to be considered an employee of the City for any purpose. Consultant is not subject to the terms and provisions of the City’s personnel policies handbook and may not be considered a City employee for workers’ compensation or any other purpose. Consultant is not authorized to represent the City or otherwise bind the City in any dealings between Consultant and any third parties. Consultant shall comply with the applicable requirements of the Workers’ Compensation Act, Title 39, Chapter 71, MCA, and the Occupational Disease Act of Montana, Title 39, Chapter 71, MCA. Consultant shall maintain workers’ compensation coverage for all members and employees of Consultant’s business, except for those members who are exempted by law. 11. Indemnity/Waiver of Claims/Insurance: For other than professional services rendered, to the fullest extent permitted by law, Consultant agrees to release, defend, indemnify, and hold harmless the City, its agents, representatives, employees, and officers (collectively referred to for purposes of this Section as the City) from and against any and all claims, demands, actions, fees and costs (including attorney’s fees and the costs and fees of expert witness and consultants), losses, expenses, liabilities (including liability where activity is inherently or intrinsically dangerous) or damages of whatever kind or nature connected therewith and without limit and without regard to the cause or causes thereof or the negligence of any party or parties that may be asserted against, recovered from or suffered by the City occasioned by, growing or arising out of or resulting from or in any way related to: (i) the negligent, reckless, or intentional misconduct of the Consultant; or (ii) any negligent, reckless, or intentional misconduct of any of the Consultant’s agents. For the professional services rendered, to the fullest extent permitted by law, Consultant agrees to indemnify and hold the City harmless against claims, demands, suits, damages, losses, 42 and expenses, including reasonable defense attorney fees, to the extent caused by the negligence or willful misconduct of the Consultant or Consultant’s agents or employees. Such obligations shall not be construed to negate, abridge, or reduce other rights or obligations of indemnity that would otherwise exist. The indemnification obligations of this Section must not be construed to negate, abridge, or reduce any common-law or statutory rights of the indemnitee(s) which would otherwise exist as to such indemnitee(s). Consultant’s indemnity under this Section shall be without regard to and without any right to contribution from any insurance maintained by City. Should any indemnitee described herein be required to bring an action against the Consultant to assert its right to defense or indemnification under this Agreement or under the Consultant’s applicable insurance policies required below the indemnitee shall be entitled to recover reasonable costs and attorney fees incurred in asserting its right to indemnification or defense but only if a court of competent jurisdiction determines the Consultant was obligated to defend the claim(s) or was obligated to indemnify the indemnitee for a claim(s) or any portion(s) thereof. In the event of an action filed against City resulting from the City’s performance under this Agreement, the City may elect to represent itself and incur all costs and expenses of suit. Consultant also waives any and all claims and recourse against the City or its officers, agents or employees, including the right of contribution for loss or damage to person or property arising from, growing out of, or in any way connected with or incident to the performance of this Agreement except “responsibility for his own fraud, for willful injury to the person or property of another, or for violation of law, whether willful or negligent” as per 28-2-702, MCA. These obligations shall survive termination of this Agreement and the services performed hereunder. In addition to and independent from the above, Consultant shall at Consultant’s expense secure insurance coverage through an insurance company or companies duly licensed and authorized to conduct insurance business in Montana which insures the liabilities and obligations specifically assumed by the Consultant in this Section. The insurance coverage shall not contain any exclusion for liabilities specifically assumed by the Consultant in subsection (a) of this Section. The insurance shall cover and apply to all claims, demands, suits, damages, losses, and expenses that may be asserted or claimed against, recovered from, or suffered by the City without limit and without regard to the cause therefore and which is acceptable to the City and Consultant shall furnish to the City an accompanying certificate of insurance and accompanying endorsements in amounts not less than as follows: · Workers’ Compensation – statutory; · Employers’ Liability - $1,000,000 per occurrence; $2,000,000 annual aggregate; · Commercial General Liability - $1,000,000 per occurrence; $2,000,000 annual 43 aggregate; · Automobile Liability - $1,000,000 property damage/bodily injury per accident; and · Professional Liability - $1,000,000 per claim; $2,000,000 annual aggregate. The above amounts shall be exclusive of defense costs. The City of Bozeman, its officers, agents, and employees, shall be endorsed as an additional or named insured on a primary non- contributory basis on both the Commercial General and Automobile Liability policies. The insurance and required endorsements must be in a form suitable to City and shall include no less than a sixty (60) day notice of cancellation or non-renewal. The City must approve all insurance coverage and endorsements prior to the Consultant commencing work. Consultant shall notify City within two (2) business days of Consultant’s receipt of notice that any required insurance coverage will be terminated or Consultant’s decision to terminate any required insurance coverage for any reason. 12. Termination for Consultant’s Fault: a. If Consultant refuses or fails to timely do the work, or any part thereof, or fails to perform any of its obligations under this Agreement, or otherwise breaches any terms or conditions of this Agreement, the City may, by written notice, terminate this Agreement and the Consultant’s right to proceed with all or any part of the work (“Termination Notice Due to Consultant’s Fault”). The City may then take over the work and complete it, either with its own resources or by re-letting the contract to any other third party. b. In the event of a termination pursuant to this Section 8, Consultant shall be entitled to payment only for those services Consultant actually rendered. c. Any termination provided for by this Section 8 shall be in addition to any other remedies to which the City may be entitled under the law or at equity. d. In the event of termination under this Section 8, Consultant shall, under no circumstances, be entitled to claim or recover consequential, special, punitive, lost business opportunity, lost productivity, field office overhead, general conditions costs, or lost profits damages of any nature arising, or claimed to have arisen, as a result of the termination. 13. Termination for City’s Convenience: a. Should conditions arise which, in the sole opinion and discretion of the City, make it advisable to the City to cease performance under this Agreement City may terminate this Agreement by written notice to Consultant (“Notice of Termination for City’s Convenience”). The termination shall be effective in the manner specified in the Notice of Termination for City’s Convenience and shall be without prejudice to any claims that the City may otherwise have against Consultant. b. Upon receipt of the Notice of Termination for City’s Convenience, unless otherwise directed in the Notice, the Consultant shall immediately cease performance under this Agreement and make every reasonable effort to refrain from continuing work, incurring 44 additional expenses or costs under this Agreement and shall immediately cancel all existing orders or contracts upon terms satisfactory to the City. Consultant shall do only such work as may be necessary to preserve, protect, and maintain work already completed or immediately in progress. c. In the event of a termination pursuant to this Section 9, Consultant is entitled to payment only for those services Consultant actually rendered on or before the receipt of the Notice of Termination for City’s Convenience. d. The compensation described in Section 9(c) is the sole compensation due to Consultant for its performance of this Agreement. Consultant shall, under no circumstances, be entitled to claim or recover consequential, special, punitive, lost business opportunity, lost productivity, field office overhead, general conditions costs, or lost profits damages of any nature arising, or claimed to have arisen, as a result of the termination. 14. Limitation on Consultant’s Damages; Time for Asserting Claim: a. In the event of a claim for damages by Consultant under this Agreement, Consultant’s damages shall be limited to contract damages and Consultant hereby expressly waives any right to claim or recover consequential, special, punitive, lost business opportunity, lost productivity, field office overhead, general conditions costs, or lost profits damages of any nature or kind. b. In the event Consultant wants to assert a claim for damages of any kind or nature, Consultant shall provide City with written notice of its claim, the facts and circumstances surrounding and giving rise to the claim, and the total amount of damages sought by the claim, within thirty (30) days of the Consultant becoming aware of the facts and circumstances giving rise to the claim. In the event Consultant fails to provide such notice, Consultant shall waive all rights to assert such claim. 15. Representatives: a. City’s Representative: The City’s Representative for the purpose of this Agreement shall be Brian Heaston, PE or such other individual as City shall designate in writing. Whenever approval or authorization from or communication or submission to City is required by this Agreement, such communication or submission shall be directed to the City’s Representative and approvals or authorizations shall be issued only by such Representative; provided, however, that in exigent circumstances when City’s Representative is not available, Consultant may direct its communication or submission to other designated City personnel or agents as listed above and may receive approvals or authorization from such persons. b. Consultant’s Representative: The Consultant’s Representative for the purpose of this Agreement shall be Scott Buecker, PE or such other individual as Consultant shall designate in writing. Whenever direction to or communication with Consultant is required by this Agreement, such direction or communication shall be directed to Consultant’s Representative; provided, however, that in exigent circumstances when Consultant’s Representative is not 45 available, City may direct its direction or communication to other designated Consultant personnel or agents. 16. Permits: Consultant shall provide all notices, comply with all applicable laws, ordinances, rules, and regulations, obtain all necessary permits, licenses, including a City of Bozeman business license, and inspections from applicable governmental authorities, and pay all fees and charges in connection therewith. 17. Laws and Regulations: Consultant shall comply fully with all applicable state and federal laws, regulations, and municipal ordinances including, but not limited to, all workers’ compensation laws, all environmental laws including, but not limited to, the generation and disposal of hazardous waste, the Occupational Safety and Health Act (OSHA), the safety rules, codes, and provisions of the Montana Safety Act in Title 50, Chapter 71, MCA, all applicable City, County, and State building and electrical codes, the Americans with Disabilities Act, and all non- discrimination, affirmative action, and utilization of minority and small business statutes and regulations. 18. Nondiscrimination: The Consultant agrees that all hiring by Consultant of persons performing this Agreement shall be on the basis of merit and qualifications. The Consultant will have a policy to provide equal employment opportunity in accordance with all applicable state and federal anti-discrimination laws, regulations, and contracts. The Consultant will not refuse employment to a person, bar a person from employment, or discriminate against a person in compensation or in a term, condition, or privilege of employment because of race, color, religion, creed, political ideas, sex, age, marital status, national origin, actual or perceived sexual orientation, gender identity, physical or mental disability, except when the reasonable demands of the position require an age, physical or mental disability, marital status or sex distinction. The Consultant shall be subject to and comply with Title VI of the Civil Rights Act of 1964; Section 140, Title 2, United States Code, and all regulations promulgated thereunder. Contractor represents it is, and for the term of this Agreement will be, in compliance with the requirements of the Equal Pay Act of 1963 and Section 39-3-104, MCA (the Montana Equal Pay Act). Contractor must report to the City any violations of the Montana Equal Pay Act that Contractor has been found guilty of within 60 days of such finding for violations occurring during the term of this Agreement. The Consultant shall require these nondiscrimination terms of its Sub-consultants providing services under this agreement. 19. Intoxicants; DOT Drug and Alcohol Regulations/Safety and Training: Consultant shall not permit or suffer the introduction or use of any intoxicants, including alcohol or illegal drugs, by any employee or agent engaged in services to the City under this Agreement while on City property or in the performance of any activities under this Agreement. Consultant acknowledges it is aware of and shall comply with its responsibilities and obligations under the U.S. Department of Transportation (DOT) regulations governing anti-drug and alcohol misuse prevention plans and 46 related testing. City shall have the right to request proof of such compliance and Consultant shall be obligated to furnish such proof. The Consultant shall be responsible for instructing and training the Consultant's employees and agents in proper and specified work methods and procedures. The Consultant shall provide continuous inspection and supervision of the work performed. The Consultant is responsible for instructing his employees and agents in safe work practices. 20. Modification and Assignability: This Agreement may not be enlarged, modified, amended or altered except by written agreement signed by both parties hereto. The Consultant may not subcontract or assign Consultant’s rights, including the right to compensation or duties arising hereunder, without the prior written consent of City. Any Sub-consultant or assignee will be bound by all of the terms and conditions of this Agreement. 21. Reports/Accountability/Public Information: Consultant agrees to develop and/or provide documentation as requested by the City demonstrating Consultant’s compliance with the requirements of this Agreement. Consultant shall allow the City, its auditors, and other persons authorized by the City to inspect and copy its books and records for the purpose of verifying that the reimbursement of monies distributed to Consultant pursuant to this Agreement was used in compliance with this Agreement and all applicable provisions of federal, state, and local law. The Consultant shall not issue any statements, releases or information for public dissemination without prior approval of the City. 22. Non-Waiver: A waiver by either party any default or breach by the other party of any terms or conditions of this Agreement does not limit the other party’s right to enforce such term or conditions or to pursue any available legal or equitable rights in the event of any subsequent default or breach. 23. Attorney’s Fees and Costs: In the event it becomes necessary for either Party to retain an attorney to enforce any of the terms or conditions of this Agreement or to give any notice required herein, then the prevailing Party or the Party giving notice shall be entitled to reasonable attorney's fees and costs, including fees, salary, and costs of in-house counsel to include City Attorney. 24. Taxes: Consultant is obligated to pay all taxes of any kind or nature and make all appropriate employee withholdings. 25. Dispute Resolution: a. Any claim, controversy, or dispute between the parties, their agents, employees, or representatives shall be resolved first by negotiation between senior-level personnel from each party duly authorized to execute settlement agreements. Upon mutual agreement of the parties, the parties may invite an independent, disinterested mediator to assist in the negotiated settlement discussions. 47 b. If the Parties are unable to resolve the dispute within thirty (30) days from the date the dispute was first raised, then such dispute may only be resolved in a court of competent jurisdiction in compliance with the Applicable Law provisions of this Agreement. 26. Survival: Consultant’s indemnification shall survive the termination or expiration of this Agreement for the maximum period allowed under applicable law. 27. Headings: The headings used in this Agreement are for convenience only and are not be construed as a part of the Agreement or as a limitation on the scope of the particular paragraphs to which they refer. 28. Severability: If any portion of this Agreement is held to be void or unenforceable, the balance thereof shall continue in effect. 29. Applicable Law: The parties agree that this Agreement is governed in all respects by the laws of the State of Montana. 30. Binding Effect: This Agreement is binding upon and inures to the benefit of the heirs, legal representatives, successors, and assigns of the parties. 31. No Third-Party Beneficiary: This Agreement is for the exclusive benefit of the parties, does not constitute a third-party beneficiary agreement, and may not be relied upon or enforced by a third party. 32. Counterparts: This Agreement may be executed in counterparts, which together constitute one instrument. 33. Integration: This Agreement and all Exhibits attached hereto constitute the entire agreement of the parties. Covenants or representations not contained therein or made a part thereof by reference, are not binding upon the parties. There are no understandings between the parties other than as set forth in this Agreement. All communications, either verbal or written, made prior to the date of this Agreement are hereby abrogated and withdrawn unless specifically made a part of this Agreement by reference. 34. Standard of Care: In providing services under this Agreement, Consultant will perform in a manner consistent with the degree of care and skill ordinarily exercised by members of the same profession currently practicing under similar circumstances. If any service should be found to be not in conformance with this standard, the Consultant shall, at the City’s request, re- perform the service at its own expense. Consultant shall also, at its own expense, make such changes, modifications or additions to the project which are made necessary as a result of the initial non-performance or the re-performance of services. The City’s rights herein are in addition to any other remedies the City may have under the law 48 35. Ownership and Reuse of Documents: Upon payment in full by City to Consultant for all monies due Consultant under this Agreement, Consultant’s work products produced under this Agreement shall become the sole property of the City. The City’s use, reuse, alteration, or modification of the work products will be at City’s sole risk and without liability or legal exposure to Consultant or to its officers, directors, members, partners, agents, employees, and consultants. 49 In witness whereof, the Parties hereto do make and execute this Agreement. CITY OF BOZEMAN, MONTANA CONSULTANT BY: BY: (City Manager) (Chief Operating Officer) DATE: DATE: ATTEST: BY: (City Clerk) APPROVED AS TO FORM: BY: (City Attorney) 50 EXHIBIT A: Scope and Fee Description for Bozeman Water Supply Optimization and Management Tool Phase 1 November 2020 AE2S Project Number: 05097-2019-004 51 Exhibit A Scope and Fee Description Bozeman Water Supply Optimization and Management Tool – Phase 1 2 Contents Project Objectives and Deliverables ......................................................................................................... 3 General Assumptions ................................................................................................................................ 3 Scope & Fee Description ........................................................................................................................... 4 Fee Summary ............................................................................................................................................ 8 Schedule .................................................................................................................................................... 9 Attachments: Attachment 1 – Hour and Fee Estimate by Subtask Attachment 2 – 2020 Rate Schedule 52 Exhibit A Scope and Fee Description Bozeman Water Supply Optimization and Management Tool – Phase 1 3 Project Objectives and Deliverables The objective of this project is to provide the City of Bozeman a suite of custom tools to visualize, project, evaluate, and optimize the City’s water supply and demands to help manage the limited resource and rapid growth. Phase 1 Key deliverables include: · Water Demand Characterization and Prediction Tool · Water Demand Technical Memorandum · Reliable Yield Hydrographs for the City’s Three Sources (Lyman Spring, Sourdough Creek, Hyalite Creek) · Firm Supply Evaluation Tool · Reliable Yield, Firm Yield, and Water Rights Technical Memorandum · Hyalite Reservoir Operating Tool · Hyalite Reservoir Technical Memorandum Phase 2 (not in this contract) Deliverables include: · Integrated Water Supply Optimization and Management Tool · User Manual and Supporting Documentation General Assumptions Specific Task-based assumptions are summarized within each Task description. General assumptions applicable to this overall scope include: · Phase 1 tools shall be created in Microsoft Excel · Phase 1 spreadsheets shall be formatted in a logical manner to allow use by City staff 53 Exhibit A Scope and Fee Description Bozeman Water Supply Optimization and Management Tool – Phase 1 4 Scope & Fee Description Phase 1 Task 1 – Project Management and Meetings Tasks 1.1 Client Meetings Basis of Planning Meeting · Land use categories to use in Water Demand Profile characterization · Risk tolerance and multi-year drought analysis methodology Reliable Yield Methodology Meeting · Approach to Sourdough physical yield estimations and assumptions made in Thornthwaite modeling Legal Availability/Water Rights Meeting · Review rights that may be excluded from legal availability analysis and assumptions · Potential water right transfers Firm Supply Evaluation Meeting · Review progress and define multi-year drought scenario Hyalite Reservoir Model Meeting · Review progress and discuss assumptions and methods used to estimate losses 1.2 Project Management · Schedule and budget management · Monthly invoices · Management of staff and subconsultants · Miscellaneous Client Meetings Deliverables · Client Meeting agendas and minutes · Bi-monthly budget and schedule updates via email · Monthly invoices Assumptions · Meetings will be virtual by either MS Teams or WebEx Fee · AE2S: $12,883 54 Exhibit A Scope and Fee Description Bozeman Water Supply Optimization and Management Tool – Phase 1 5 Phase 1 Task 2 – Water Demand Characterization and Model Tasks 2.1 Supply Side Water Demand Profile · Establish monthly baseline (indoor) water use demand profile for each major land use category from meter data · Establish monthly irrigation water use demand profile for each major land use category from meter data · Update / evaluate peaking factors and max day demand 2.2 Supply Side Monthly Demand Tool · Combine demand profiles and unaccounted for demand to create an overall demand profile and monthly volumes · Demand tool will allow for easy method for evaluating different growth scenarios · Determine when baseline water demand will require Hyalite reservoir withdrawals during winter months 2.3 Water Demand Technical Memorandum · Summarize data used, methods, and assumptions in a tech memo · TM to include user-guide for Demand Tool Deliverables · Water Supply Side Monthly Demand Spreadsheet Tool · Water Demand Tech Memo Assumptions · Spreadsheet tools will incorporate existing data up to September 2020 Fee · AE2S: $22,944 55 Exhibit A Scope and Fee Description Bozeman Water Supply Optimization and Management Tool – Phase 1 6 Phase 1 Task 3 – Direct Flow Water Rights – Reliable Yield Evaluation Tasks 3.1 Reliable Yield Hydrographs · Hyalite diversion: use historical (1895-present) stream flow time series data to estimate monthly yield curves · Sourdough diversion: use historical (1947-1986) stream flow time series data (digitized in 2013 as part of the IWRP project), recent (2015-pesent) stream flow time series data, and the Thornthwaite Model developed for Sourdough as part of the IWRP project to estimate monthly yield curves · Lyman diversion: update reliable yield model developed in 2017 as part of the Lyman Spring Assessment Study 3.2 Quantify Delivery Capacity · Analyze WTP inflow data by source and summarize monthly data · Quantify infrastructure capacity for: o Hyalite diversion and transmission to water treatment plant o Sourdough diversion and transmission to water treatment plant o Lyman diversion and transmission capacity to Lyman storage tank 3.3 Legal Demand Review · Overlay legal demands with physical yield · Monthly exercised senior rights in basin 41H will be provided by the City 3.4 Develop Firm Supply Evaluation Tool · Evaluate probability City’s firm supply become susceptible to senior rights · Evaluate 1-in-50 year drought at each source accounting for infrastructure capacity restrictions 3.5 Reliable Yield Technical Memorandum · Summarize data used, methods, and assumptions in a tech memo · TM to include user-guide for Demand Tool Deliverables · Reliable Yield Hydrographs · Monthly Reliable Yield Probabilistic Curves · Firm Supply Evaluation Tool · Reliable Yield Technical Memorandum Assumptions · Reliable yield analysis will conform to MT DEQ Circular 1 Chapter 3 · Scope does not include performing a major update to the Sourdough Thornthwaite Model or developing a new Watershed Yield model for any of the City’s sources Fee · AE2S: $15,772 56 Exhibit A Scope and Fee Description Bozeman Water Supply Optimization and Management Tool – Phase 1 7 Phase 1 Task 4 – Hyalite Reservoir Operating Model Tasks 4.1 Reservoir Optimization and Operating Model · Define and quantify projected reliable hydrologic inflows · Define and quantify losses (ET, siltation, seepage) · Define and quantify storage and water right requirements · Combine data into single spreadsheet model to evaluate reliable monthly storage probabilities · Develop planning level future scenarios to optimize reservoir storage for use when City’s base demand exceeds current supply – evaluate planning level changes to dam/reservoir to provide winter withdrawals 4.2 Evaluate Potential Storage Alternatives for City’s Remaining End-of-Year Hyalite Water · Develop planning-level alternatives for storing raw Hyalite water between diversion and Sourdough WTP · Evaluate benefit of storage to mitigate losses from discharge of excess water diverted from Hyalite but not utilized at the Sourdough WTP 4.3 Assess the 20% Conveyance Loss Factor Applied to Reservoir Water Rights · Use stream flow records to assess validity of 20% conveyance loss between reservoir and City diversion 4.4 Drought Reserve Analysis · Recommend initial drought reserve volume to establish in Hyalite Reservoir for drought contingency · Provide supporting calculations behind recommended reserve volume 4.5 Hyalite Reservoir Model Technical Memorandum · Summarize data used, methods, and assumptions in a tech memo · TM to include user-guide for Demand Tool Deliverables · Reservoir Operating Model · Reservoir Technical Memorandum Assumptions · Input, output and loss assumptions to be agreed upon with City · Past Hyalite Dam Reports and Studies will be utilized in modeling to the maximum extent practical. Data gaps will be discussed with the City as they are determined. · A watershed yield model for the upper Hyalite Basin is not included in this scope Fee · AE2S: $41,688 57 Exhibit A Scope and Fee Description Bozeman Water Supply Optimization and Management Tool – Phase 1 8 PHASE 2 Task 5 – Water Supply Optimization & Management Tool (NOT IN THIS CONTRACT) Tasks 5.1 Engage City Staff in Workshop · Identify potential Dashboard / Modeling platforms and discuss pros, cons, City’s expectations and desires · Identify climate change scenarios / analyses 5.2 Compile Phase 1 Tools 5.3 Develop Climate Change Scenarios 5.3 Develop Dashboards 5.4 User Manual Deliverables · Water Supply Optimization & Management Tool · User Manual Assumptions · All phase 1 tools will be configured in a way to streamline the integration into a singular Tool Estimated Hours / Fee · AE2S: $30,073 · Jacobs: $21,000 Estimated Fee – Phase 2 Scope to be defined after Phase 1 Fee Summary Phase Task Total AE2S Hours Fee Phase 1 Task 1 - Project Management and Meetings 73 $12,883 Task 2 – Water Demand Characterization and Model 164 $22,944 Task 3 – Direct Flow Water Rights – Reliable Yield Evaluation 104 $15,772 Task 4 – Hyalite Reservoir Operating Model 284 $41,688 Reimbursable Expenses (Sub- Consultants Jacobs and WGM) N/A $75,506.55 Phase 1 Total 593 $168,793.55 Phase 2 (Not in this contract) Task 5 – Water Supply Optimization & Management Tool Estimate 209 $51,073 58 Exhibit A Scope and Fee Description Bozeman Water Supply Optimization and Management Tool – Phase 1 9 Schedule 59 Attachment 1 to Exhibit A: Hour and Fee Estimate by SubtaskCity of Bozeman: Water Supply Optimization and Management Tool Buecker Magdol Strombeck Staff Eng. Vink GIS Staff AE2STotalBilling Category ENG VI ENG III ENG IV ENG I ENG IV GIS I Labor2020 Billing Rate 221 165 187 115 187 111PHASE 1Task 1 - Project Management & Meetings1.1 Client Meetings (Five) 5 5 5 0 0 0 2,865$ 1.2 Project Management 8 50 0 0 0 0 10,018$ Task 1 - Subtotal 13 55 5 0 0 0 12,883$ Task 2 - Supply Side Water Demand Characterization2.1 Supply Side Water Demand Profile 0 24 10 40 0 0 10,430$ 2.2 Supply Side Monthly Demand Tool 0 8 12 40 0 0 8,164$ 2.3 Water Demand Technical Memorandum 2 8 4 16 0 0 4,350$ Task 2 - Subtotal 2 40 26 96 0 0 22,944$ Task 3 - Reliable Yield Evaluation3.1 Reliable Yield Hydrographs 4 4 10 24 0 03.2 Quantify Delivery Capacity 2 2 0 4 0 0 1,232$ 3.3 Legal Demand Review 2 2 8 10 0 0 3,418$ 3.4 Firm Supply Tool 0 0 8 8 0 0 2,416$ 3.5 Reliable Yield Technical Memorandum 2 4 4 4 0 2 2,532$ Task 3 - Subtotal 10 12 30 50 0 2 15,772$ Task 4 - Hyalite Reservoir Operation Model4.1 Operating Model 2 16 40 96 8 0 23,098$ 4.2 Potential Storage Alternatives 2 4 2 16 0 0 3,316$ 4.3 Assess 20% Loss Factor 2 6 2 10 0 0 2,956$ 4.4 Drough Reserve Analysis 4 4 16 8 0 0 5,456$ 4.5 Hyalite Reservoir Model Technical Memorandum 2 16 8 16 0 4 6,862$ Task 4 - Subtotal 12 46 68 146 8 4 41,688$ PHASE 1 - LABOR SUBTOTAL 37 153 129 292 8 6 93,287$ 93,287.00$ 23,784$ Reimbursable Expenses Direct Cost Fee w/ 5% Administrative MarkupReimbursable Expenses 56.45$ N/A56.45$ WGM Group (Subconsultant) 12,011$ 12,611.55$ 12,611.55$ Jacobs, Inc. (Subconsultant) 59,900$ 62,895.00$ 62,895.00$ PHASE 1 TOTAL FEE168,850.00$ HOURSAE2S DIRECT LABOR COSTThursday, November 12, 202060 Page 1 of 2 ADVANCED ENGINEERING AND ENVIRONMENTAL SERVICES, INC. 2020 HOURLY FEE AND EXPENSE SCHEDULE Labor Rates* Administrative I $60.00 Administrative II $73.00 Administrative III $88.00 Communications Specialist I $92.00 Communications Specialist II $107.00 Communications Specialist III $123.00 Communications Specialist IV $148.00 Communications Specialist V $163.00 Construction Services I $141.00 Construction Services II $153.00 Construction Services III $173.00 Construction Services IV $190.00 Construction Services V $209.00 Engineering Assistant 1 $72.00 Engineering Assistant 2 $92.00 Engineer I $115.00 Engineer II $139.00 Engineer III $165.00 Engineer IV $187.00 Engineer V $199.00 Engineer VI $221.00 Engineer VII $236.00 Engineer VIII $246.00 Engineering Technician I $71.00 Engineering Technician II $90.00 Engineering Technician III $107.00 Engineering Technician IV $125.00 Engineering Technician V $141.00 Engineering Technician VI $156.00 Engineering Technician VII $173.00 Financial Analyst I $95.00 Financial Analyst II $110.00 Financial Analyst III $129.00 Financial Analyst IV $145.00 Financial Analyst V $163.00 Financial Analyst VI $183.00 Financial Analyst VII $199.00 Financial Analyst VIII $218.00 GIS Specialist I $92.00 GIS Specialist II $111.00 GIS Specialist III $131.00 GIS Specialist IV $147.00 GIS Specialist V $161.00 GIS Specialist VI $182.00 I&C Assistant $86.00 I&C Technician I $105.00 I&C Technician II $118.00 I&C Technician III $133.00 I&C Technician IV $144.00 I&C Technician V $157.00 I&C Specialist $171.00 I&C Senior Specialist $181.00 I&C Manager $190.00 IT I $110.00 IT II $150.00 IT III $180.00 Land Surveyor Assistant $85.00 Land Surveyor I $102.00 Land Surveyor II $122.00 Land Surveyor III $137.00 Land Surveyor IV $151.00 Operations Specialist I $86.00 Operations Specialist II $104.00 Operations Specialist III $131.00 Operations Specialist IV $148.00 Operations Specialist V $172.00 Program Coordinator I $185.00 Program Coordinator II $199.00 Program Coordinator III $210.00 Project Coordinator I $103.00 Project Coordinator II $114.00 Project Coordinator III $125.00 Project Coordinator IV $140.00 Project Coordinator V $158.00 Project Manager I $175.00 Project Manager II $192.00 Project Manager III $212.00 Project Manager IV $226.00 Technical Expert I $260.00 Technical Expert II $283.00 Technical Expert III Negotiable 61 Page 2 of 2 Reimbursable Expense Rates Transportation $0.65/mile Survey Vehicle $0.85/mile Laser Printouts/Photocopies $0.30/copy Plotter Printouts $1.00/s.f. UAS - Photo/Video Grade $100.00/day Video Production Equipment $100.00/each Total Station – Robotic $35.00/hour Mapping GPS $25.00/hour Fast Static/RTK GPS $50.00/hour All-Terrain Vehicle/Boat $100.00/day Air Transportation – Cirrus $700.00/hour Survey Monument $5.00/each Fence Posts $8.00/each Survey Lath $35.00/bundle Survey Stakes/Hubs $23.00/bundle Cellular Modem $75.00/month Web Hosting $26.00/month Legal Services Reimbursement $233.00/hour Outside Services** cost *1.05 Geotechnical Services cost *1.30 Out of Pocket Expenses*** cost*1.15 Rental Car cost*1.20 Project Specific Equipment Negotiable * Position titles are for labor rate grade purposes only. ** Includes laboratory testing, architectural and engineering consultants, surveying, etc. *** Includes toll telephone, shipping, postage, subsistence, technical literature, equipment rental, etc. These rates are subject to adjustment each year on January 1. 62