Loading...
HomeMy WebLinkAbout12 01 08_Authorize City Manager to sign Amendment No. 1 to the Professional Services Agreement for Bozeman Wastewater Treatment Plant Phase I Improvements Commission Memorandum REPORT TO: Honorable Mayor and City Commission FROM: Bob Murray, Project Engineer Chris Kukulski, City Manager SUBJECT: 2007 WWTP Upgrade - Phase I Expansion Project MEETING DATE: 12/1/08 RECOMMENDATION: Authorize City Manager to sign. BACKGROUND: Attached is a copy of the partially executed Amendment Number 1 with HDR Engineering, Inc. for Professional Engineering Services for the Wastewater Treatment Plant Upgrade - Phase I Expansion Project. The original agreement only covered the design phase services. This amendment is to add the bidding and construction phase services. The document is in the City’s standard format. The proposed fee of $4,767,571 appears to be commensurate with the project complexity and anticipated total project cost. This is part of the total project costs that were presented to the Commission at the time of the construction contract award. FISCAL EFFECTS: The project has multiple funding sources which have been the subject of previous Commission presentations. ALTERNATIVES: As suggested by the City Commission. Respectfully submitted, _________________________________ ____________________________ Robert J. Murray Jr., Project Engineer Chris A. Kukulski, City Manager Attachments: Amendment No. 1 Report compiled on 11/25/2008 5 1 AMENDMENT NO. 1 TO PROFESSIONAL SERVICES AGREEMENT FOR BOZEMAN WASTEWATER TREATMENT PLANT PHASE I IMPROVEMENTS THIS IS AN AGREEMENT made as of , 2008 between THE CITY OF BOZEMAN, a Municipal Corporation, P.O. Box 1230, Bozeman, Montana, 59771-1230 (OWNER) and HDR Engineering Inc, 8404 Indian Hills Drive, Omaha, NE 68114-4098, (ENGINEER). WHEREAS the parties previously entered into a Professional Services Agreement dated April 9, 2007, herein referred to as the Original Agreement, for professional engineering services for the Bozeman Wastewater Treatment Plant Improvements; and WHEREAS, the scope of the Original Agreement included preliminary design and design engineering services; and WHEREAS, the parties desire to amend provisions of the Original Agreement to add bidding, construction, startup and software programming services for the project. NOW, THEREFORE, IN CONSIDERATION OF THE MUTUAL COVENANTS CONTAINED HEREIN, the parties agree as follows: The conditions and provisions set forth in the attached EXHIBIT F (AMENDMENT NO. 1) – CITY OF BOZEMAN, MONTANA WATER RECLAMATION FACILITY (WRF) PHASE 1 EXPANSION CONSTRUCTION SCOPE OF SERVICES; EXHIBIT G (AMENDMENT NO. 1) - CITY OF BOZEMAN, MONTANA WATER RECLAMATION FACILITY (WRF) PHASE 1 EXPANSION ENGINEERING FEE ESTIMATE, are hereby incorporated in and made part of this Agreement. ARTICLE 4 - Basic Engineering Services The Title of Section 4.4 of the Original Agreement is replaced with the following: “4.4 BIDDING OR NEGOTIATING PHASE” Section 4.4.7 is added to the Original Agreement as follows: “4.4.7 Provide additional Bidding Services as described in Task 1100 – BID SERVICES of the attached Exhibit F.” 6 2 The Title of Section 4.5 of the Original Agreement is replaced with the following: “4.5 CONSTRUCTION PHASE” Section 4.5.4 is added to the Original Agreement as follows: “4.5.4 Additional Construction Contract Services. In addition to the services provided under Article 10 (Exhibit A) and Section 4.5.1 of the Original Agreement, the ENGINEER shall provide the Additional Construction Contract Services during construction as described in Task 1200 – Construction Administration, Task 1300 – Project Startup & Commissioning, Task 1400 – Application Software Programming Services and Task 1500 – Project Closeout of the attached Exhibit F.” Article 6 - Compensation For Engineering Service Article 6.2 of the Original Agreement is replaced with the following: “6.2 DIRECT LABOR COST PAYMENT FOR BASIC SERVICES AND EXPENSES OF ENGINEER. Construction and project documentation services performed as Basic Engineering Services under Sections 4.4 through 4.7 (Tasks 700, 800 & 900 in Exhibit C, and Tasks 1100, 1200, 1300, 1400 & 1500 in Exhibit F), including General Administration of Construction Contract, Resident Project Representation, Project Documentation, Construction Testing, Bidding, Project Startup & Commissioning, Application Software Programming and Project Closeout services shall be compensated in accordance with the following: 6.2.1 The OWNER shall pay for Bidding Phase, Construction Phase and Project Documentation Services an amount not to exceed $4,767,571 ($129,957{SubTasks 700, 800 and 900 Exhibit C}+$4,637,614 {SubTasks 1100, 1200, 1300, 1400 and 1500 Exhibit F}) except as provided under 6.2.1.2 and 6.2.4. 6.2.1.1 Costs Compensation. Compensation for these services shall be based on the ENGINEER's Direct Labor Cost times a factor of 3.15 for services rendered which shall cover Direct Labor, Direct Labor Overhead, General & Administrative Overhead and Profit, plus reimbursable expenses as provided in 6.2.2. 6.2.1.2 Notification. At any time during the construction that it becomes apparent that the Bidding Phase, Construction Phase and Project Documentation Services rendered under this Agreement will exceed the negotiated compensation for these services, and prior to performing services in excess of the contract ceiling, the ENGINEER shall give OWNER written notice thereof. Promptly thereafter OWNER and ENGINEER shall review the scope and progress of the project work. ENGINEER shall obtain written authorization from OWNER, prior to any additional costs being incurred under paragraph 6.2.1.3. If it is determined that due to a change in project scope under paragraph 5.2.1, the ENGINEER is entitled to additional compensation, OWNER and ENGINEER may negotiate terms as provided under 6.2.1.1. The amount and terms of any additional compensation under 6.2.1.1 or 6.2.1.3 shall be negotiated and agreed in writing pursuant to 9.16. 6.2.1.3 Costs Exceeding Estimated Compensation. Except as allowed under 5.2.1, when the total cost of the original scope Construction Phase and Project Documentation Services exceeds the negotiated compensation for these services, the OWNER shall pay only for the direct costs incurred in excess of the estimated compensation. These costs consist of an amount equal to the ENGINEER'S Direct Labor Cost times a factor of 2.80 for services rendered which shall include Direct Labor, the federally audited payroll Direct Labor Overhead, and General & Administrative Overhead costs, but shall not include any allowance for profit. 7 3 6.2.2. Failed Test Expenses. The ENGINEER shall maintain and provide to the OWNER, a record of the costs associated with failing quality control tests performed for the OWNER during the course of the construction of the project and recommend an amount the OWNER deduct from the contractor(s) payments. 6.2.3 The OWNER shall pay an amount for Additional Services rendered by the ENGINEER and approved in writing by the OWNER on the basis of the ENGINEER'S Direct Labor Costs times a factor of 3.15, or an amount otherwise negotiated at the time such services are requested and approved by the OWNER. Additional Services also include those services defined in SubTask 1000 of Exhibit C, in an amount not to exceed $100,000.” Article 7 – Meaning of Terms Article 7.3 of the Original Agreement is replaced with the following: “7.3 DIRECT LABOR COSTS Direct Labor Costs used as a basis for payment mean the actual salaries and wages paid to all ENGINEER’S personnel engaged directly on the Project, including, but not limited to, engineers, architects, surveyors, designers, drafters, specification writers, estimators, other technical and business personnel; but does not include indirect payroll related costs or fringe benefits. For the purposes of this Agreement the principals and employees of the ENGINEER maximum billable Direct Labor Costs are: HDR Engineering, Inc. Morrison – Maierle, Inc. Principals $63 Principals $64 Project Design/Manager $63 Supervising Engineer III $53 Supervising Engineer III $63 Supervising Engineer II $47 Supervising Engineer II $60 Supervising Engineer I $47 Supervising Engineer I $53 Senior Engineer II $44 Engineer III $49 Senior Engineer I $40 Engineer II $47 Design Engineer II $36 Engineer I $30 Design Engineer I $30 Design Engineer II $36 Staff Engineer $25 Design Engineer I $30 Senior Environmental Professional $33 Staff Engineer $27 Environmental Professional $30 Senior Environmental Professional $60 Engineer Intern $25 Environmental Professional II $53 Senior Survey Manager $42 Environmental Professional I $27 Survey Party Chief $35 Project Architect $54 Land Surveyor I $24 Senior Environmental Technician $29 Survey Technician $24 Engineering Technician $37 Senior Engineering Technician $37 Engineering Technician II $28 Engineering Technician II $28 Engineering Technician I $24 Engineering Technician I $24 CADD Drafter $24 CADD Drafter $21 Accounting/Admin $24 Technicians $20 Clerical $24 Clerical $19 Printer $21 “ 8 4 Except as specifically amended herein, the Original Agreement shall remain in full force and effect and the parties shall be bound by all terms and conditions therein. In witness whereof, the Parties hereto do make and execute this Agreement. CITY OF BOZEMAN, MONTANA HDR ENGINEERING, INC. BY:________________________ BY:__________________________ (City Manager) (Amanda McInnis, P.E. Department Manager) DATE:_____________________ DATE:________________________ ATTEST: BY:______________________ (City Clerk) 9 Scope of Services 1 of 20 11/25/2008 EXHIBIT F - CITY OF BOZEMAN, MONTANA WATER RECLAMATION FACILITY (WRF) PHASE 1 EXPANSION CONSTRUCTION SCOPE OF SERVICES Provide assistance to the City in project bidding, bid evaluation and assistance to the City in award of a construction contract. The scope of services for project bidding assumes that a single construction contract will be bid and executed. The bidding services provided by HDR/MMI/IAC shall meet the requirements presented in Section 4.4. of the Professional Services Agreement (PSA). ! "#! ! "#! ! "#! ! "#! HDR/MMI will provide for printing of contract documents for use in bidding the construction contract(s). Half-sized documents will be used exclusively during project review and bidding to save costs. Full size will be made available after the project bid. Actual number of document sets may vary dependent upon project requirements. HDR/MMI will invoice the City for actual charges incurred for printing. It is assumed that ninety 90 sets of plans and specifications (printed in installments of 30, 20, 20, 10 and 10 sets) will be produced for the final bid and permit acquisition point. HDR/MMI will provide the City with the camera-ready originals of the project specifications and drawings following the project bid, and will supply the Contractor with four (4) sets of executed contract $%!!&’! (!"&)%!’’! *&"" !!#+!’’ ,!% !- 10 Scope of Services 2 of 20 11/25/2008 documents as required by Section 4.4.6. of the PSA. HDR/MMI will develop a separate document fee account during the bidding phase for fees collected from the sale of document sets (non-refundable). HDR/MMI will utilize the document fee collected to address direct costs associated with document distribution and administration of the project. Any difference in the cost for document printing and disposition, from what is collected in document fees assessed to the perspective bidders and what is included as charges presented in the engineering services budget, will be treated as an additional scope item and billed as additional services. If the revenue received from the sale of documents exceeds costs for document printing and distribution, the additional funds will be returned to the City. $$$$&’&’&’&’ HDR/MMI will assist the City in advertising for and obtaining bids for materials, equipment and services to be performed by a contractor for the construction contract. It is envisioned that the Project will be bid as a single construction contract, in accordance with Section 4.4.1. of the PSA. ((((!!!!".!#!".!#!".!#!".!#! HDR/MMI will contact up to ten (10) general contractors who have bid similar projects in both Montana and surrounding states approximately four (4) weeks prior to the first bid advertisement to alert them to the project, general bidding requirements, etc. ****----%!#%!#%!#%!# HDR/MMI will prepare an agenda and conduct a pre-construction conference, in accordance with Section 4.4.1.of the PSA, to be attended by the City, interested Contractors, and HDR/MMI. The meeting will include a presentation given by the HDR/MMI Project Manager, and a tour of the work site. ,,,,&&&&&&&& HDR/MMI shall receive and respond to prospective contractor questions in accordance with Section 4.4.2. of the PSA. HDR/MMI shall assist the City in determining acceptability of substitutes in accordance with Section 4.4.4. of the PSA. ////"0 !%!&+"0 !%!&+"0 !%!&+"0 !%!&+ HDR/MMI will attend the bid opening, prepare bid tabulation sheets, assist the City in evaluating bids, and help the City determine contractor responsiveness and responsibility. This subtask will also include assistance to the City for awarding the construction contract in accordance with Sections 4.4.5. and 4.4.6. of the PSA. Recommended bid advertisement. Camera-ready specifications and reproducible drawings. Pre-qualification review recommendations. Addenda. 11 Scope of Services 3 of 20 11/25/2008 Bid tabulation. Recommendation of award. Pre-bid conference meeting minutes. Drawings (camera-ready copies, eighty (80) half-size copies of bid and permit acquisition documents, ten (10) copies of full-size after bidding). Specifications (camera-ready copies, eighty (80) copies of bid documents). Final Contract Documents in digital .pdf and ACAD format. $$$$%!!%!!%!!%!!&’!&’!&’!&’! Assist the City of Bozeman in administering the construction of the Wastewater Reclamation Facility Phase 1 Upgrade Project in accordance with Section 4.5 - Construction Phase of the PSA. The scope of services for project construction services assumes that a single construction contract would be completed and executed. HDR/MMI/IAC will manage and control its professional services contract to provide efficient completion of the project. &%&%&%&% $$$$!!!!&’!&’!&’!&’! The HDR/MMI/IAC project manager will conduct periodic meetings with City staff, in conjunction with construction review meetings, to review project progress, schedule and budget; identify information needs, and make decisions regarding changes in the scope of the construction management efforts. A progress summary will be prepared with each monthly invoice. The progress summary will describe the work progress to date, the budget expenditures to date, and identify information requirements or decisions that need to be made by the City. These memos will help maintain frequent communications with the City. $$$$$$$$----!!%!#!!%!#!!%!#!!%!# HDR/MMI will schedule, prepare an agenda and administer a pre-construction conference to be attended by the City, Contractors, appropriate subcontractors, and HDR/MMI’s Project and Construction Services Managers in accordance with Section 4.5.1.1. of the PSA. $$$$((((%!!1%!!1%!!1%!!1 HDR/MMI/IAC will consult with and advise the City of Bozeman as set forth in the engineering services contract. The City of Bozeman’s instructions to the contractor will be issued through HDR/MMI/IAC, who will have limited authority to act on behalf of the City of Bozeman to the extent provided in the PSA. HDR/MMI/IAC will consult with and advise the City of Bozeman as set forth in Section 4.5 and Article 10, Exhibit A of the PSA. 12 Scope of Services 4 of 20 11/25/2008 $$$$****----%!!%!!%!!%!!!!!! The City of Bozeman and HDR/MMI agree that HDR/MMI will provide resident representation at the site. HDR/MMI will provide the City of Bozeman Resident Project Representative(s) to assist in carrying out such responsibilities at the site, in accordance with Section 4.5.2. and Article 11, Exhibit B of the PSA. $$$$,,,,!+!+!+!+ HDR/MMI/IAC will prepare final record drawings and maintain communication, data architecture and control system configuration drawings and data, which conform to construction records and will furnish the City with an electronic copy of the final product in accordance with Section 4.6. of the PSA. HDR/MMI will provide the City one set of record drawings on 22 IN x 34 IN reproducible sheets, two sheets hard copy, as well as one set of record drawings in electronic format for use with AutoCAD Version 2008. One complete set of .pdf format drawings will also be developed for use at the treatment plant site and City Engineering office. These drawings will be based on construction records provided by the Contractor, City and on-site resident project representatives. HDR/MMI will complete the record drawings within three months of the date of receipt of all of the marked-up prints and other necessary data from the Contractor. $/$/$/$/2 32 32 32 3 HDR/MMI will provide required field surveying and staking for facility construction. Field survey information will be developed and stakes provided for project components to provide the Contractor with reasonable information to complete the work. HDR/MMI has established a horizontal and vertical survey control network around the project site. Existing facilities are located with respect to this control. Using the existing control, HDR/MMI will establish one set of stakes for the Contractor to use in performance of the work. Generally, staking will include pipelines, utility corridors, buildings, structures, access roads, parking areas, site grading, and fencing. Further, elevation control will be established at multiple points on the job site. HDR/MMI will provide the following stakes: Water Main Improvements (Fittings, hydrants, 50’ stations) WRF Process Yard Piping Improvements (Fittings, manholes, vaults, 100’ stations) Utilidor Improvements (Vaults and 100’ stations) New Building Improvements (Building corners) New Structure Improvements (Structure corners and midpoints for circular structures) Access Road Improvements (100’ stations, grade changes, fillets) Parking Areas Improvements (100’ stations, grade changes, fillets) Curb and Gutter, Paving Improvements (Top back of curb) Storm Drain Improvements (Ditch alignment or pipe at 100’ stations, manholes/vaults) Detention Basin Improvements (Basin Bottom with slope stakes) East Gallatin Rip Rap Improvements (100’ stations) Fencing Improvements (100’ stations, bends, gates) Elevation Control Improvements (20 points across job site) 13 Scope of Services 5 of 20 11/25/2008 HDR/MMI will provide the above-described staking one time only. Re-staking or additional staking needed by the Contractor to complete the work shall be done solely at the Contractor’s Expense. $4$4$4$4 5 !6 5 !6 5 !6 5 !6 HDR/MMI will coordinate testing of the construction materials to be incorporated into the project as part of the construction contract. The Contractor will be required to provide testing from an independent testing agency for all materials imported for incorporation into the project. HDR/MMI will provide testing of in-situ materials to be used during construction or materials control verification using the services of the MMI Bozeman testing lab and local engineering staff, including provision of the following services: Concrete strength, air content and slump Embankment (backfill), trench backfill, and gravel and pavement densities Aggregate gradations Asphalt concrete plant mix strength, flow and asphalt content and core samples HDR/MMI will conduct the required on-site testing using the Contractor provided initial materials control tests for all imported materials, or coordinate the Contractor provided compaction testing throughout the project, utilizing the materials testing data provided as noted above. The type and frequency of tests will be specific to the construction and will be conducted in a manner to develop a good verification that the compaction requirements are being met. HDR/MMI will coordinate the provision of testing reports and will make recommendation to the City as to the acceptability of the work in accordance with Section 4.7 of the PSA. SK Geotechnical will provide observation services on and as needed basis to confirm the findings of the Geotechnical Evaluation Report. $7$7$7$7 " "!" "!" "!" "! HDR/MMI will provide on-site special inspection of the buildings in accordance with Sections 1704-1709 of the 2006 International Building Code as required by the City of Bozeman Building Department. HDR/MMI will coordinate the provision of testing reports and will make recommendation to the City as to the acceptability of the work in accordance with Section 4.7 of the PSA. Progress reports and invoices (3 copies and digital .pdf file). Workshop/Meeting agendas and notes in bullet item format (3 copies and digital .pdf copy of each agenda and meeting notes). Submittal review comment letters responding to contractor submittals. Pre-construction conference meeting summary notes. Construction meeting summary notes and action items list. Field logs including daily reports for all days when HDR/MMI/IAC are on-site. Geotechnical and compaction testing reports. 14 Scope of Services 6 of 20 11/25/2008 Responses to requests for information. Response to contract change proposals. Contract change orders. Deficiency punch lists. Record drawings (one set of full-size copies, camera-ready reproducible documents, digital files). Project observation reports. Shop drawing submittal log. Contractor pay estimate reviews. Compiled monthly reports. Field copy of Shop Drawings. ((((!"&%!’’!!"&%!’’!!"&%!’’!!"&%!’’! In addition to the startup requirements of the construction contractor, HDR/MMI/IAC will provide startup assistance to the City in final project commissioning of the newly constructed facilities. The services will include: &%&%&%&% (((("! "! "! "! HDR/MMI will prepare an electronic Operations and Maintenance (eO&M) Manual addressing the improvements incorporated in this project. The manual content and format will be developed in consultation with City staff and in accordance with Montana Department of Environmental Quality requirements. It is anticipated that the manual will be provided in electronic form to meet the minimum O&M requirements of MDEQ. MDEQ can, if preferred, be provided with one (1) electronic copy for their records and Two (2) hard copy printouts of electronic files to supplement their existing hard copy O&M Manual records. The Operations and Maintenance Manual development will include the following general elements: Prepare electronic text and graphics files to reflect the changes in the plant. Text files will be produced in the latest version of Microsoft Word. Graphic files will be produced in latest version of AutoCAD and converted to .pdf format. The preparation of unit process operating procedures will be provided. General standard operating procedures will be provided for all key process systems included in the Phase 1 project, and software links will be provided from the eO&M links to provide operator access to selected eO&M materials. Prepare and deliver a draft electronic copy of the revised text and graphics for review by the City approximately one month prior to startup. The City will forward a compilation of all comments to the draft electronic copy to HDR within two weeks of receipt. Revise the text and graphic files and deploy one (1) final electronic version on a City server and final paper copy (if required) to MDEQ within two weeks of receipt of comments. HDR will also provide MDEQ with a CD-ROM containing the associated electronic text and graphics files. 15 Scope of Services 7 of 20 11/25/2008 ($($($($1 !) 1 !) 1 !) 1 !) HDR/MMI will develop an eO&M Manual for the City of Bozeman’s WRF Phase 1 Project, which will provide the City staff the necessary information to operate and maintain its facilities in an efficient and reliable manner. The eO&M Manual will contain a variety of information, including facility and equipment descriptions, design criteria, process control narratives, design drawings, and vendor manuals. Using the eO&M Manual, City staff will be able to access this information in an electronic format with an easy-to-use graphical user interface. The eO&M Manual will be developed as a web application in the Microsoft ASP.net web environment and will function on a City provided Windows-based server. The eO&M Manual will be internally accessible via Internet Explorer and will not be accessible by the general public. An on-line HTML text editor (Cute Editor) will be embedded in the eO&M Manual web pages to enable easy text editing by City staff without having to know HTML. HDR owns a Cute Editor Enterprise License that allows for free distribution as long as the software is used on HDR's eO&M application. Static data will be retrieved from the City’s OPS32 SQL database for digital presentation in the eO&M. Equipment numbering and equipment Data Sheets will be coordinated with the City’s existing JobCal computerized maintenance management system (CMMS) to the greatest extent possible. The Operations Manual electronic development would include the following steps: 1. Web Site Map Development. A project kick-off meeting/workshop will be held to discuss general O&M content, system configuration and customizations, system installation and training, coordination with the design team, and the overall time schedule for development and implementation of the eO&M Manual system. The purpose of this task is to prepare a web site map to illustrate the comprehensive eO&M Manual for the wastewater treatment facilities. The draft eO&M Manual web site map will: Illustrate the eO&M Manual structure, organization and level of detail for each unit process. Explain how navigation (hyperlinks) between each section will be implemented. Show what reference information to be included in the eO&M Manual. The web site map will be developed in coordination with City staff, and will be specifically tailored to meet requirements and needs of the facility staff. The site map will be customized as necessary to provide the specific sub-sections desired by the plant staff. HDR/MMI will initially concentrate on developing the high level architecture of the eO&M Manual structure to define the structure and organization. HDR/MMI will prepare a draft web site map for review and comment. HDR/MMI and City staff will then hold a four-hour workshop focusing on defining the content format and level of detail within each unit process, including: eO&M Manual guidelines and maintenance help guide. Plant reference information. Equipment O&M manuals provided by equipment vendors via hyperlinks to PDF files. Unit process content details. 16 Scope of Services 8 of 20 11/25/2008 2. Manual Content Preparation. HDR/MMI will prepare the O&M manual content for each unit process shown in the web site map. Example content definitions are shown in the following table. Note that content definitions for this project will be specific and customized to those sub-sections agreed upon and defined by the web site map developed with plant staff. Example eO&M Content Definitions Section Text Overview A short description of each unit process. Theory A short description of the theory behind each unit process illustrating the design intent. Strategies for evaluating data and making process adjustments. Figures Hyperlinks to 2D and 3D figures illustrating each unit process. Design Criteria Tabular listing of unit process sizes, loadings, and other design criteria. Components Hyperlinks to equipment manuals provided by equipment vendors in PDF file format. Controls A description of manual and automatic controls. System Procedures A list of duties to be performed by operators when making daily process checks. General procedures for starting up and shutting down the process. Troubleshooting A list of process alarms showing possible causes and suggested responses. Safety General safety considerations for the unit process. Existing equipment O&M manuals that are only available in hard copy may be scanned into PDF files and hyperlinked within the eO&M manual, but will not be included in this scope of services initially. City personnel will be trained on procedures for completing this effort following project completion. Equipment record sheets will be stored as .pdf files. 3. Graphic Content Definition. HDR/MMI will develop 2D and 3D figures for communicating to plant O&M staff the design intent, and how to operate the unit process. The figures will be developed from the conformed contract drawings but will be modified by deleting extraneous construction related information that is not pertinent to O&M personnel. The figures will be prepared in AutoCAD and converted to PDF file format for inclusion in the eO&M Manual. The graphics will be sized for the monitor size the City intends to use to access the eO&M Manual. A total of fifty (50) 2D and twenty five (25) 3D figures are anticipated. In addition, HDR/MMI will incorporate the plant as-built drawings into the eO&M Manual in .pdf file format and provide hyperlinks to each drawing. 17 Scope of Services 9 of 20 11/25/2008 4. System Configuration and Customization. HDR/MMI will develop specific system customizations, including screen layouts, file formats, administration and integration needs. Technology issues related to installation on a City web server will be identified. 5. System Installation. HDR/MMI will develop the draft and final eO&M Manuals on an HDR/MMI server. The draft and final versions will be available to City staff via the Internet for review. HDR/MMI will coordinate installation of the final eO&M Manual on the City’s server with the City's information technology (IT) staff at the end of the project. The final eO&M Manual will be downloaded to the City’s network server via an HDR FTP site. 6. System Training. HDR/MMI will schedule a meeting with the plant staff, and facilitate two (4) four-hour training sessions for the plant staff on how to use and maintain the eO&M. The four-hour training sessions will provide general instruction and use of the eO&M Manual and will provide instruction on how the plant staff can edit and revise the eO&M Manual. Training will also be provided to the City's IT staff on eO&M Manual system administration, maintenance, and security. One four-hour training session has been budgeted for this effort. The computers and servers necessary to view the electronic Operations Manual are not included with the production of the electronic Operations Manual. %3 8 ’%3 8 ’%3 8 ’%3 8 ’ Provide necessary software on City WRF computers to enable the electronic Operations Manual to function The eO&M Manual hardware and software will be supplied by the City meeting the minimum requirements as follows: Path to and the necessary space on a City provided server at the WRF facilities for the electronic Operations Manual. The server shall be a Microsoft Windows machine (running Microsoft Windows Server 2003). At least a 2.0 GHz processor or better and 512 of RAM and at least 2 gigabytes of hard drive space. IIS (Internet Information Services 5.0 or higher). Microsoft.NET (pronounced dot net), Framework 1.1. SQL Server 2000 or later. AutoCAD viewer. Provide ancillary software on the City's computers necessary to run the eO&M Manual, including Microsoft Internet Explorer, MS Windows, or Vista and the SQL database. !"#$%% &’#$%% %#$%%( 18 Scope of Services 10 of 20 11/25/2008 !") % *"" !’#$%%" +" ,-"(-!#%.!*%%& ’ #$% #$%%" #$%%& (/!#$%% #$%%"(" .!’ ("(0 &’"#$%% ’"-/!(#$% #-(&’ %) (((((((( 2 3 2 3 2 3 2 3 ----""!""!""!""! HDR/MMI will review operating data for submission to the funding agencies and will assess overall performance of the new equipment and facilities. HDR/MMI/IAC will provide operational assistance to the City of Bozeman after the System is started, and train the City of Bozeman’s personnel. Pre-startup Training will be provided to communicate to the plant operators the following: 1. The ability to operate the equipment in each unit process. 2. An understanding of both the field and SCADA equipment controls and the ability to operate both. The pre-startup training will be presented in a classroom setting using a lecture format supplemented with figures and graphics delivered via an overhead projector or using Microsoft PowerPoint on an LCD projector. The training material for each specific session will consist of draft copies of the Operations Manual sections or HDR developed process presentations. Pre- startup training will be presented in the following modules: 1. Biological Nutrient Removal (BNR) Theory of Operation (To be provided in two (2) separate and similar sessions by HDR’s JB Neethling and Bob Bower – utilizing an HDR presentation format customized for the Bozeman WRF Facility) 2. Headworks, including influent flow measurement, screening and grit removal 3. Unified Fermentation and Thickening (UFAT) system 4. Primary effluent pumping and flow control systems 5. Bioreactors and aeration blowers system 19 Scope of Services 11 of 20 11/25/2008 6. Secondary clarification 7. RAS/WAS flow control systems 8. UV disinfection system 9. Anaerobic digestion facilities 10. High strength waste receiving system 11. Utilities and support facilities including standby engine generator and electric service entrance switchboard 12. HMI and SCADA server system Coordination with individual HDR/IAC PLC/SCADA programmer(s) will be provided. The portion of each module pertaining to SCADA controls will be presented by the HDR/IAC SCADA programmers who programmed that system. The HDR/IAC SCADA programmer will use an LCD projector to show the actual SCADA screens for each equipment item discussed in the module. The SCADA presentation will cover manual starting, stopping and speed control of equipment, set-point adjustment, operating mode changes, alarms, data collection and trending,. Startup Coordination will also be provided to the City of Bozeman to provide coordination between the contractor, the construction administration team and the plant staff during startup of the new equipment. The startup coordinator will allow the startup of new equipment to occur if, and only if, the equipment and ancillary subsystems are ready to be placed into service and the manufacturer’s O&M manuals are on-site and available for use by plant staff. The secondary purpose of this effort is to provide informal training to the plant operators during the actual process startup. HDR/MMI/IAC will coordinate clean water testing with the contractor. The clean water test occurs prior to startup and uses non-potable water to demonstrate the functionality of new equipment and controls. The following process units will have a clean water test: 1. Headworks, including influent flow measurement, screening and grit removal. 2. Unified Fermentation and Thickening (UFAT) system 3. Primary effluent pumping. 4. Bioreactor and aeration blowers. 5. Secondary clarification and RAS/WAS systems. 6. UV disinfection. 7. Anaerobic digestion. 8. High strength waste receiving. HDR/MMI/IAC will conduct startup service for each project element or unit process in conjunction with the training services provided by the City’s supervisor. Startup means placing the equipment into operation for its intended purpose and using the intended process material, i.e. primary effluent, primary sludge, filtrate, etc. Startup assistance will be provided as follows for the project components listed above. Startup services will include the following work products: 20 Scope of Services 12 of 20 11/25/2008 1. Review and approve equipment supplier training agendas and training material outlines as provided by the Contractor. Use discretion, based on experience with vendor training, to enforce contract provisions for vendor training duration. 2. Coordinate vendor training schedule with Contractor and plant staff to ensure that vendor training occurs on Wednesdays as a first choice, Tuesdays and Thursdays as second choice and avoids Mondays and Fridays. 3. Prepare a startup plan that lists specific responsibilities for the contractor, construction administration staff, PLC/SCADA programmer(s) and plant staff. 4. Provide the written startup plan to the contractor, the construction administration staff, PLC/SCADA programmer(s) and the plant staff approximately one month before startup. 5. Schedule and conduct startup review meetings (as required) between the contractor, the construction management staff, PLC/SCADA programmer(s) and the plant staff approximately two weeks before startup. 6. Revise and reissue the startup plan and schedule as needed based on the review meeting. 7. Verify the equipment is ready for the clean water test: 8. Verify the manufacturer's field service forms have been completed for each piece of equipment. 9. Verify pipe pressure tests and concrete water tightness tests have been conducted. 10. Verify rotating equipment has been bumped to check for proper operation and rotation. 11. Verify instrument calibration and loop testing is complete. The following activities will be performed during startup: 1. Coordinate with the contractor, the construction administration staff, the PLC/SCADA programmer and the plant staff to ensure that process material is introduced to the process in such a way as to not adversely impact the rest of the plant. 2. Verify and document that the controls and alarms are working in conformance with the software pre-design report. 3. Verify and document the results of testing that was deferred from the clean water test. 4. Identify and document equipment or control deficiencies (i.e. punch list). 5. Provide discipline-specific deficiency lists. Operator training during the clean water test and startup will be conducted by HDR/MMI/IAC on an informal basis in the field. The purpose of this training is to provide an opportunity to answer operator questions, to demonstrate (when requested) the transition from manual control to automatic control, and to demonstrate alternate modes of operation (when requested). Startup checklists and training materials including the HDR developed BNR Theory of Operation session customized for the Bozeman WRF facility. Two separate training sessions (may be consecutive or combined with other systems and held on the same day) for each of the separate unit project element or process. Written unit process operation procedures for each project element or unit process. Startup plans coordinated with the construction schedule. 21 Scope of Services 13 of 20 11/25/2008 ****&"" !!#+!’’&"" !!#+!’’&"" !!#+!’’&"" !!#+!’’ Implement the programming for the Plant SCADA system including PLC (Programmable Logic Controller) ladder logic and their associated OI (Local Operator Interface) and HMI (Human- Machine Interface) configurations. The new PLC ladder logic will be installed on the Plant PLC’s (new and existing, as required). The new HMI interface will be configured using the Plant’s modified Wonderware® InTouch 10.0 system, as specified and shown in the Contract Documents. The PLC ladder logic, OI and Wonderware® HMI process displays will be developed in collaboration with WRF plant personnel to provide the controls as described in the City of Bozeman Water Reclamation Facility (WRF) Phase 1 Improvements Project Contract Documents (Project Manual). The existing Plant SCADA system and PLC ladder logic will be reviewed to identify old control logic that should be removed. The existing PLCs and PLC applications will also be updated to the newest version of manufacturer firmware that is available for the hardware and the existing PLC program(s) and HMI configurations will be edited to conform existing programming to the new programming configuration where possible. Application and 3rd party module compatibility will also be verified for firmware upgrades. The existing process alarm management system will be modified to incorporate the new alarm points created as part of the Phase 1 Improvements project. The existing process alarm system includes an alarm dialing software (SCADA!arm) program. The OI and HMI displays (both existing and new displays) will be modified to conform to the developed project software standards and provide an improved alarm generation and archive system. It is intended to demonstrate the functionality of the modified and/or new Wonderware and Panelview process displays and SCADA alarms in conjunction with the new or modified PLC ladder logic. City of Bozeman Operations will perform hands-on activities necessary to run the simulated processes as identified in the Final Software Pre-design Report. &%&%&%&% ****3 ’!3 ’!3 ’!3 ’!!’!’!’!’ HDR/MMI/IAC will provide systems integration project management support for the project for the following work activities: Hold monthly onsite meetings with City of Bozeman Staff, Contractor and design staff to discuss the mechanics of implementing the Software changes and to define standards to be followed. The project schedule will be discussed and coordinated with the construction schedule to define milestones and resource allocations. It is expected the software development and system integration will occur through approximately twelve (12) months of the construction period. Document meeting decisions and action items; assign the activities to team members, and follow-up to ensure timely resolution. 22 Scope of Services 14 of 20 11/25/2008 Review Contractor provided equipment, electrical and instrumentation and control system submittals, and provide coordination input for electrical and instrumentation systems. Monitor project progress including work completed, work remaining, budget expended, schedule, estimated cost of work remaining, and estimated cost at completion. The project schedule will be developed by HDR/IAC following receipt of the Contractor’s project schedule to show the required programming to be completed one month before the associated construction start-up date. Manage the work provided to verify compliance with the current WRF HMI software standards, quality of documentation, and scheduling. Monitor project activities for potential changes, anticipate changes whenever possible, and with City of Bozeman approval, modify project subtasks, subtask budgets, and approach. Assist the City of Bozeman with the selection of computer workstations, software packages, and networking components required for the process control and monitoring equipment for the Phase 1 Improvements project. This includes the recommendation of computer hardware and software for the SCADA Workstations, SCADA Servers, and Office Workstations. This contract does not include the costs for the procurement of these components, and assumes these hardware and software items will be delivered to HDR/MMI/IAC by the City as needed by the project schedule. To enable work sharing and collaboration between HDR/MMI/IAC and the City, a project FTP site within HDR’s FTP system will be developed to enable “common” access to available information applicable to system integration. Agendas for meetings. Meeting notes for meetings. Monthly invoice with Software project progress summary report. Project software development FTP site. *$*$*$*$!#+!#+!#+!#+----"!"!"!"! HDR/MMI/IAC will provide software development preliminary design and develop a software design summary for the project. The following work activities are planned: Prepare a Software Pre-Design Report for the project which will include the following information: 1. Understanding of the existing WRF HMI and OI software standards. 2. Updated Control Loop Descriptions (using Contract Document Specification Section 13442). 3. Existing Wonderware HMI and Panelview OI Process Display Printouts marked up to show planned modifications. Sketches and descriptions of new OI and HMI displays will be provided. 4. Interface Definition Specifications (IDS), i.e. PLC/OI/HMI tag databases, based on information in the Contract Document). 5. Process Field Database Interface and Report Generation. 23 Scope of Services 15 of 20 11/25/2008 a. Provide system programming and interface coordination for integration with the City’s existing OPS32 SQL® database and Wonderware’s Muni-Suite® software using OPS32 SCADA Interface software provided by the City through separate procurement. b. Each report saved with report date-based file naming convention (or as requested by the City). 6. Conduct review of existing PLC programming and SCADA software and define recommendations for software programming revisions and cleanup of existing software code. A minimum of one hundred twenty (120) programming man-hours are assumed for the review of the existing programs and PLC code. 7. Alarm generation and alarm management will be as shown in the Contract Documents and will be based on the Wonderware and SCADA!arm handling functions. As a minimum, alarms will be stored in an alarm database to enable data access and/or report generation and printing from the SCADA report printer. 8. Real-time and historical data management will be consistent with current WRF Software standards. Reports will be printed from the historical database files, in spreadsheet format as desired by the City. 9. Define eO&M interface requirements and coordinate with eO&M development team. Conduct up to three (3) Software Pre-Design Report review meetings with City of Bozeman staff and HDR/MMI/IAC to discuss the following: 1. The modified and new HMI and OI process displays and their functionality for the major process areas. 2. Identify which OI and Wonderware HMI process screens (and tags) are to be removed or updated. a. Report content, format and printing. b. Alarm management. c. Data management. 3. Finalize the plan for cleaning up existing OI, HMI and PLC programs. Document meeting decisions and action items; assign the activities to team members, and follow-up to ensure timely resolution. Issue the Final Software Pre-design Report, including summary comments and revisions discussed in the meeting. Agendas for review meetings. Meeting notes of review meetings. Final Software Pre-design Report – Five (5) copies. Existing PLC program clean-up report. HMI Hardware and Software report. 24 Scope of Services 16 of 20 11/25/2008 ****((((!#+!’’)!#+!’’)!#+!’’)!#+!’’) The PLC logic (Allen-Bradley ControlLogix) program and OI and HMI process screens and database configuration will be designed from the information provided by the Final Software Pre-Design Report. This subtask includes the following work activities: Obtain the most current existing PLC programs, OI and HMI process screens, configuration files, tag database(s), data files, and other required files from City of Bozeman’s SCADA system just prior to beginning the programming effort. Develop a PLC, OI and HMI program modification Plan. Before loading the new or modified programming into the various PLC’s and the OI and HMI systems, coordinate with the City of Bozeman staff and IAC to confirm if additional modifications have been made to the PLC, OI or HMI software. Develop the programming for the new equipment to meet the requirements identified in the updated Final Software Pre-Design Report. Merge the new or modified PLC, OI and HMI programming with the existing PLC ladder logic and OI and HMI graphic displays where required. Provide for cleanup programming of the existing PLC and SCADA system programming identified in the Final Software Pre-design Report. A maximum of one hundred twenty (120) programming man-hours is assumed for completion of the existing software re- programming for the purposes of this budget. Actual man-hours will be provided as a deliverable to the Final Software Pre-design Report. Remove existing PLC programming when it is replaced with new PLC programming. Obtain the latest Panelview and Wonderware process screens and configuration files and databases (i.e., process database, alarm area database, picture files) for the WRF from the City and IAC. Wonderware process screens will be designed to meet the requirements identified in the Final Software Pre-design Report. The types of Wonderware HMI and Panelview OI process graphics or pictures to be generated include process screens, overview screens, controller pop-ups, real time and historical trending screens, and report screens. It is assumed that the existing Wonderware HMI process screens will remain unchanged, unless any of them need to be modified to include or remove process equipment pertaining to the Phase 1 project. The new Wonderware HMI and Panelview OI process tag databases, tag-groups, process screens and the picture files for the new equipment being added will be merged or replaced with existing screens and files on the SCADA Server. Screen navigation, consistent with existing, will be modified to integrate these changes into the system. Coordinate with City of Bozeman for required modifications to existing HMI and OI screens. The Software will be tested and debugged. HDR/MMI/IAC may use a software simulation package (where possible and practical) to thoroughly test the PLC, HMI and OI Software process interface. The I/O simulator software program will be used to simulate the real I/O to be connected for this project. Only the pertinent Wonderware and Panelview process databases and the new and modified Wonderware and Panelview process screens will be active in the simulator for testing to limit confusion and expedite testing. 25 Scope of Services 17 of 20 11/25/2008 HDR/MMI/IAC will provide a 90% software submittal for City review. A meeting will be conducted with the City to review City comments and finalize software design. 6 %3+ 6 %3+ 6 %3+ 6 %3+ Provide the PLC and HMI system software and hardware, specified by HDR/MMI/IAC, to be used for the programming, testing and commissioning efforts. The Hardware and software will be returned to the City when required to be put into service or at the end of the project. Review and provide comment on the 90% software submittal. Latest PLC ladder logic disk (CD-ROM) and hardcopy (print-outs). Latest Wonderware and Panelview process electronic files for screens, pictures, pop-ups, alarms, and data handling. It is assumed the City will continue to utilize their current OPS32 SQL database program for reporting. HDR/MMI/IAC will provide needed interface programming to enable the City to retrieve data from their SCADA system into the OPS32 program to continue their current reporting. This scope of services does not include any additional report development. 90% complete Wonderware and Panelview process displays for City of Bozeman Operations staff review (color print-out hardcopy, and where applicable marked up color print-outs of existing graphic displays). As-built documentation of non-modified PLCs, OI or HMI components is not included. ********2 ! ’!!2 ! ’!!2 ! ’!!2 ! ’!! This subtask includes the following work activities: During the software development and testing period, HDR/MMI/IAC will perform up to two (2) periodic QA/QC reviews. This will involve verification that the program strategy is correct, adequately documented, and in accordance with WRF HMI software standards developed under Subtask 1402. Software Demonstration meetings will be held at the 90% design completion. It is anticipated that up to five of these meetings will be required as indicated below. These meetings will be held in the Water Reclamation Facility. It is intended to demonstrate the functionality of the modified and/or new Wonderware and Panelview process displays and SCADA alarms in conjunction with the new or modified PLC ladder logic. City of Bozeman Operations will perform hands-on activities necessary to run the simulated processes as identified in the Final Software Pre-design Report. Software Demonstration 90% meeting Duration (days + travel) Headworks, Primary Effluent Pumping systems 1 2 26 Scope of Services 18 of 20 11/25/2008 Software Demonstration 90% meeting Duration (days + travel) Blower Room and UFAT systems 1 1 Bioreactors, RAS, UV Disinfection, and Digester Building systems 2 2 Lift Station No.2 and Miscellaneous systems 1 1 Totals 5 6 Agendas for Software Demonstration Meetings. Meeting minutes from the Software Demonstration Meetings. Hardcopy printout of the PLC ladder logic programs. Hardcopy printout of the HMI and OI process displays, databases and reports. SCADA!arm configurations. ****,,,,2 %!’’!!#+"2 %!’’!!#+"2 %!’’!!#+"2 %!’’!!#+" This subtask includes the following work activities: HDR/MMI/IAC will verify that the interconnections for the new PLC I/O are terminated correctly by witnessing the Contractor’s loop testing (specified in Section 13440). These tests are referred to as the Operational Readiness Tests (or Loop Checkouts). After the Operational Readiness Tests are complete, HDR/MMI/IAC will upload the new PLC ladder logic. Also, at this time we will transfer to the plant HMI workstations and OI’s the new Wonderware and Panelview process screens and the associated database files. The new Remote I/O Bases will then be attached to the associated PLCs, and the Functional Testing period will begin. All operator alarm notification functions will be tested for proper operation. Functional Testing is the process of putting the new equipment into full automatic operation. Loop tuning of the controls will be performed. Minor corrections will be made to the new PLC logic and Wonderware and Panelview process interfaces and SCADA alarms if found necessary. Field commissioning and software startup plan identifying pre-startup and startup activities and responsibilities. This plan will be issued prior to startup. Deliver new or modified PLC program files to be installed prior to the Functional Testing period. 27 Scope of Services 19 of 20 11/25/2008 Deliver new or modified Wonderware and/or Panelview process displays and revised databases to be installed prior the Functional Testing period. Deliver the modified database with all new Wonderware process tags, alarms, memory addresses, and description at start-up, with updates as required through start-up and substantial completion. Load the SCADA!arm configurations. ****////!"""!!"""!!"""!!"""! Upon substantial completion of the new programming, the automated system will be turned over to the City of Bozeman. HDR/MMI/IAC and City of Bozeman staff will periodically monitor the SCADA system to verify that Operations can satisfactorily control the processes as designed. HDR/MMI/IAC has allocated a maximum of eighty (80) hours of project engineer time in the budget for this subtask. These hours shall be available to be utilized within six (6) months after the project is turned over to the City of Bozeman. It is HDR/MMI/IAC’s intent to utilize the following personnel to develop and implement the new system software: Project Manager: Dan Harmon Project Software Design Lead: Don Best/Randy Geist Project Engineer (Programming and Field Commissioning): Don Best Project Engineer (Programming and Field Commissioning): Kyle Cram (IAC) Project Engineer (Programming and Field Commissioning): Matt Wolfe (IAC) Senior Programmer (Programming and Field Commissioning): Sean Rumelhart (IAC) Programmer (Programming and Field Commissioning): Aaron Wirth (IAC) Project Engineer (Functional Demonstration Tests): Chris Sheridan The City’s project managers: Tom Adams and Herb Bartle. ,,,,!% !!% !!% !!% !----%#!%#!%#!%#! Conduct final project reviews and assist the City in completion of project closeout reporting and coordination with MDEQ. Conduct final one-year certification evaluation and reporting to meet MDEQ project closeout requirements. ,,,,%!% !%!% !%!% !%!% !---- HDR/MMI/IAC will provide the City with a list of construction deficiencies, inspection of the correction of these deficiencies, review final payment application(s), make recommendation to the City for final payment, and give written notice to the City and Contractor(s) that work is acceptable and complete. HDR/MMI will provide consultation on warranty items, assist in the 11-month warranty inspection and provide warranty follow-up. 28 Scope of Services 20 of 20 11/25/2008 HDR/MMI will provide their consultation on contract close-out in accordance with the PSA Subarticle 4.5.1.12 and 4.5.1.13. ,$,$,$,$%#%#%#%#!!!! HDR/MMI/IAC will provide the City with the necessary certification documentation as required by the Montana Department of Environmental Quality. Certification will comply with the one- year certification requirements provided by MDEQ in their approval of the project design and will include the evaluation of one year of treatment plant performance data and individual process unit performance testing. Final recommendation for payment. Final deficiency list check-off. Notice of project acceptance and final project completion. 1 !"!#1 !"!#1 !"!#1 !"!# 29 Exhibit G City of Bozeman Water Reclamation Facility Phase 1 Expansion Engineering Fee Estimate Task Task Description Direct Labor Expenses By Task Task Total 1100 Bidding Services 137,667.60$ 27,049.60$ 164,717.20$ 1200 Construction Administration 3,196,251.45$ 304,002.70$ 3,500,254.15$ 1300 Project Startup Assistance & Commissioning 400,481.55$ 26,383.50$ 426,865.05$ 1400 Application Software Programming Services 448,509.60$ 50,853.00$ 499,362.60$ 1500 Project Close-Out 44,339.40$ 2,075.60$ 46,415.00$ Total Labor and Expenses Cost by Task 4,227,249.60$ 410,364.40$ 4,637,614.00$ Expense Summary Expenses Miscellaneous 176,100.00$ Travel Expenses 63,600.00$ Mapping/Photos/Surveys 8,000.00$ Printing and Photocopying 19,800.00$ Technology 142,864.40$ Total Expenses 410,364.40$ TOTAL ESTIMATED ENGINEERING SERVICES FEE 4,637,614.00$ Task Cost Summary DRAFTBozeman Phase 1 Construction Budget_(11)rev.xls Page 1 of 8 11/25/2008 30 DMQA1QA3DT1DT2DT3DT5OPSTS1TS2TS3TS6TS7TS8CAD1ADM1ADM2SubtotalDTCMS1PDT2DT7DT7DT8CMS3TS11TS12CS1CS2ADM2SubtotalSI-1SI-2SI-3SI-4SI-5SI-6Subtotal=204.75$ 204.75$ 189.00$ 138.60$ 81.90$ 119.70$ 173.25$ 163.80$ 182.70$ 148.05$ 179.55$ 78.75$ 185.85$ 72.45$ 59.85$ 72.45$ Hours141.75$ 160.65$ 141.75$ 119.70$ 113.40$ 135.45$ 91.35$ #REF!103.95$ 107.10$ 110.25$ 97.65$ Hours160.65$ 138.60$ 129.15$ 103.95$ 97.65$ 100.80$ HoursTask 1100 Bidding Services1101*Printing/Plotting Plans and Specifications8323272001102*Bid Advertisement 442060206016001103*Prospective Bidder Notification88001104*Pre-bid Conference1216281328814801105*Addenda and Bid Assistance1044801002488603242020820206801106*Bid Opening, Tabulation and Contract Award44444044840 Hours sub-total16404088116002488600086432576402400092000080804600000000Task 1200 Construction Administration1201*Project Administration3168824602406071630080380888241202*Pre-construction Conference1216288888888864888241203*Construction Engineering1408406820036036004012012036034534512408,24638011001003601980400100100010006,42001204*On-site Construction Observation200240120560320240274422405666,11081660841205*Record Drawings16166807121203008050021616341206*Field Surveying/Staking08025825859601207*Geotechnical and Material Testing Services012001,20001208*Special Inspection Services 060017602,36011617Hours sub-total1952407620838439161204012012036034516345680240130010,26238814084281288485240825855810033283534108017,63027321692160183Task 1300Project Startup Assistance & Commissioning1301*Operations and Maintenance Manual4408528882401302*Electronic O & M Manual162411601002901,5901616164801303*Plant Facility Start-up and Operator Training16162446040556244018024803485816100129 Hours sub-total36016004801660000010002980402,198406400180480008008420581610000129Task 1400Application Software Programming Services1401*System Integration4012012028004856681402*Software Pre-Design Report1808026008161401641403*Software Programming and Testing00684816960404401,5721404*Functional Demonstrations2411013407880561511405*Field Commissioning and Software Startup4014545230022242202004661406*Post Startup Support4024640588040133Hours sub-total000000010400059502690009680000000000000114112161536407362,554Task 1500Project Close-Out1501*Contract Close-out244081688204012020200816241502*Certification824436081624Hours sub-total32000064000000000820124204000120200000002000160320048Total Personnel Hours2,18440962084724,1441201,8041441283681,0001166149863121,39214,1284881,7524281,2885,2444762585581003,4163,5341,16818,710146168481,760567362,914* ALL Subtasks to be completed on a time and materials basis in accordance with Article 6.2 of the PSA189.00$ 204.75$ 204.75$ 189.00$ 138.60$ 81.90$ 119.70$ 173.25$ 163.80$ 182.70$ 148.05$ 179.55$ 78.75$ 185.85$ 72.45$ 59.85$ 72.45$ 141.75$ 160.65$ 141.75$ 119.70$ 113.40$ 135.45$ 91.35$ #REF!103.95$ 107.10$ 110.25$ 97.65$ 160.65$ 138.60$ 129.15$ 103.95$ 97.65$ 100.80$ 412,776.00$ 8,190.00$ 19,656.00$ 39,312.00$ 65,419.20$ 339,393.60$ 14,364.00$ 312,543.00$ 23,587.20$ 23,385.60$ 54,482.40$ 179,550.00$ 9,135.00$ 114,111.90$ 71,435.70$ 18,673.20$ 100,850.40$ 69,174.00$ 281,458.80$ 60,669.00$ 154,173.60$ 594,669.60$ 64,474.20$ 23,568.30$ #REF!10,395.00$ 365,853.60$ 389,623.50$ #########23,454.90$ 23,284.80$ 6,199.20$ 182,952.00$ 5,468.40$ 74,188.80$ Key PersonnelBill RateReal numbersRoundedRounded HDRLabor CategoryNameActualActual7%7%12%12%DM - Design ManagerDesign ManagerDan Harmon60$56.00$56.0059.926062.7263QA1 - Quality Assurance PrincipalBud Benjes65$84.13$84.1390.029094.2394QA3 - Quality AssurancePrincipalJohn Koch65$67.40$67.4072.127275.4976DT1 - Design TeamSupervising Engineer IICraig Caprara/Hank Fenske60$56.25$56.2560.196063.0063DT2 - Design TeamEngineer IIMatt Gough44$41.00$41.0043.874445.9246DT3 - Design TeamEngineer ICoralynn Jones26$24.50$24.5026.222627.4427DT5 - Design TeamEngineering TechnicianTom Hanou38$35.00$35.0037.453839.2039OPS - Operations Specialist Supervising Engineer Chris Sheridan55$51.00$51.0054.575557.1257TS1 - Technical SupportProject ArchitectDonn Hogan52$48.39$48.3951.785254.2054TS2 - Technical SupportSupervising Engineer IIITed Kontonickas58$54.20$54.2057.995860.7061TS3 - Technical SupportEngineer IIIBrad Miller47$44.00$44.0047.084749.2849TS6 - Technical SupportSupervising Engineer IIDon Best57$53.55$53.5557.305759.9860TS7 - Technical SupportEngineer IIIAdam Serock25$23.50$23.5025.152526.3226TS8 - Technical SupportPrincipalErnie Swanson/Randy Geist59$55.02$55.0258.875961.6262CAD - CAD TechnicianCADD DrafterHeather Fancher23$21.50$21.5023.012324.0824ADM1 - Project ControllerAccounting/Admin.Katie Ward19$17.00$17.0018.191919.0419ADM2 - Project AssistantClericalChris Kelly23$21.50$21.5023.012324.0824MMIDT - Design TeamSupervising Engineer INancy Cormier45$38.1241.8844.814546.9147CMS1 - CM SpecialistsSupervising Engineer IIIJames Nickelson51$42.8047.2350.545152.9053PDT2 - Preliminary Design Team Supervising Engineer IMike Kaczmarek45$35.9441.944.834546.9347DT7 - Structrual DesignSenior Engineer INate Menuez38$42.1935.1537.613839.3740DT7 - Design TeamSenior Engineer ICraig Brawner36$29.0633.6536.013637.6938DT8 - Design TeamSenior Engineer IITravis Meyer43$30.9440.0642.864344.8745CMS3 - CM SpecialistsEngineering Technician IBill Farrell29$20.9426.6728.542929.8730TS11 - Technical SupportLand Surveyor/CADDSteve Rude/Jerry Hallford33$39.0630.7932.953334.4835TS12 - Technical SupportDesign Engineer IIMike Brandt/Tom Coburn34$29.0631.8734.103435.6936CS1 - Construction TeamConstruction Engineer IIIRoger Sommerville35$27.9332.3734.643536.2536CS2 - Construction TeamConstruction Engineer ISteve Malmberg31$29.0029.2131.253132.7233ADM2 - ClericalClericalSue Dugan/Paula Madden18$17.0016.517.661818.4819IACSI-1 - PrincipalPrincipalChuck Wambeke51$48.00$48.0051.365153.7654SI-2 - Project ManagerProject ManagerGary Johnson44$41.00$41.0043.874445.9246SI-3 - Senior EngineerSenior EngineerMark Jenko41$38.00$38.0040.664142.5643SI-4 - Project EngineerProject EngineerKyle Cram/Mike Roche33$31.00$31.0033.173334.7235SI-5 - Controls EngineerControls EngineerMatt Wolfe31$29.00$29.0031.033132.4833SI-6 - Senior ProgrammerSenior ProgrammerSeam Rumelhart32$30.00$30.0032.103233.6034IACHDR Engineering, Inc.Exhibit G: City of Bozeman Water Reclamation Facility ConstructionPhase 1 ExpansionStaff Hour EstimateDRAFTBozeman Phase 1 Construction Budget_(11)rev.xlsPage 2 of 811/25/200831 Exhibit G City of Bozeman Water Reclamation FacilityPhase 1 Expansion Task 1100 Bidding Services TotalHDR Staff 1101 1102 1103 1104 1105 1106 Hours Rate Total Dan Harmon, Design Manager 0 4 0 12 104 44 164 60.00$ 9,840.00$ Bud Benjes, QA 0 0 0 0 0 0 0 65.00$ -$ John Koch, QA 0 0 0 0 4 0 4 65.00$ 260.00$ Craig Caprara, RAS/WAS Pumping 0 0 0 0 0 0 0 60.00$ -$ Matt Gough, Aeration Basin/BNR 0 0 8 0 80 0 88 44.00$ 3,872.00$ Coralynn Jones, Blower Building 0 0 0 16 100 0 116 26.00$ 3,016.00$ Tom Hanou, Constructibilty 0 0 0 0 0 0 0 38.00$ -$ Chris Sheridan, Operations Specialist 0 0 0 0 0 0 0 55.00$ -$ Donn Hogan, Architectural 0 0 0 0 24 0 24 52.00$ 1,248.00$ Paul Cockrell, HVAC 0 0 0 0 8 0 8 58.00$ 464.00$ Brad Miller, Structural Design 0 0 0 0 8 0 8 47.00$ 376.00$ Don Best, Instrumentation Design 0 0 0 0 60 0 60 57.00$ 3,420.00$ Adam Serock, Project Financing/3D 0 0 0 0 0 0 0 25.00$ -$ Ernie Swanson/Randy Geist, Electrical 0 0 0 0 0 0 0 59.00$ -$ Allyson Gillespie, CAD Technician 8 0 0 0 0 0 8 23.00$ 184.00$ Katie Ward, Project Controller 32 0 0 0 32 0 64 19.00$ 1,216.00$ Chris Kelly, Project Assistant 32 0 0 0 0 0 32 23.00$ 736.00$ HDR Totals 72 4 8 28 420 44 576 24,632.00$ Morrison Maierle Staff Nancy Cormier, Hydraulic Profile 0 20 0 0 20 0 40 45.00$ 1,800.00$ James Nickelson, Site Planning 0 60 0 132 8 40 240 51.00$ 12,240.00$ Mike Kaczmarek, Groundwater Study 0 0 0 0 0 0 0 45.00$ -$ Nate Menuez, Structural Design 0 0 0 0 0 0 0 38.00$ -$ Craig Brawner, Design Team 0 20 0 8 20 44 92 36.00$ 3,312.00$ Travis Meyer, Ultraviolet Disinfection 0 0 0 0 0 0 0 43.00$ -$ Bill Farrell, Field Inspection 0 0 0 0 0 0 0 29.00$ -$ Steve Rude, Surveyor 0 0 0 0 0 0 0 33.00$ -$ Mike Brandt, Standby Power 0 0 0 0 0 0 0 34.00$ -$ Roger Sommerville, Construction Team 0 0 0 8 0 0 8 35.00$ 280.00$ Steve Malmberg, Construction Team 0 0 0 0 0 0 0 31.00$ -$ Sue Dugan/Paula Madden, Clerical 0 60 0 0 20 0 80 18.00$ 1,440.00$ Morrison Maierle Totals 0 160 0 148 68 84 460 19,072.00$ IAC StaffChuck Wambeke, Principal 0 0 0 0 0 0 0 51.00$ -$ Gary Johnson, Project Manager 0 0 0 0 0 0 0 44.00$ -$ Mark Jenko, Senior Engineer 0 0 0 0 0 0 0 41.00$ -$ Kyle Cram/Mike Roche, Project Engineer 0 0 0 0 0 0 0 33.00$ -$ Matt Wolfe, Controls Engineer 0 0 0 0 0 0 0 31.00$ -$ Sean Rumelhart, Senior Programmer 0 0 0 0 0 0 0 32.00$ -$ IAC Totals 0 0 0 0 0 0 0 -$ TOTAL HOURS 72 164 8 176 488 128 1036 1101*Printing/Plotting Plans and Specifications Total Labor 43,704.00$ 1102*Bid Advertisement OH/Profit Multiplier x3.15 1103*Prospective Bidder Notification Total Direct Labor 137,667.60$ 1104*Pre-bid Conference 1105*Addenda and Bid Assistance Direct Expenses: 1106*Bid Opening, Tabulation and Contract Award Miscellaneous 7,000.00$ Travel Expenses 1,100.00$ Mapping/Photos/Surveys 2,000.00$ Printing and Photocopying 11,000.00$ Technology 5,949.60$ Total Direct Expenses 27,049.60$ 164,717.20$ DRAFTBozeman Phase 1 Construction Budget_(11)rev.xls Page 3 of 8 11/25/2008 32 Exhibit G City of Bozeman Water Reclamation Facility Phase 1 Expansion Task 1200Construction Administration Total HDR Staff 1201 1202 1203 1204 1205 1206 1207 1208 Hours Rate Total Dan Harmon, Design Manager 316 12 1408 200 16 0 0 0 1952 60.00$ 117,120.00$ Bud Benjes, QA 0 0 40 0 0 0 0 0 40 65.00$ 2,600.00$ John Koch, QA 8 0 68 0 0 0 0 0 76 65.00$ 4,940.00$ Craig Caprara, RAS/WAS Pumping 8 0 200 0 0 0 0 0 208 60.00$ 12,480.00$ Matt Gough, Aeration Basin/BNR 24 0 360 0 0 0 0 0 384 44.00$ 16,896.00$ Coralynn Jones, Blower Building 60 16 3600 240 0 0 0 0 3916 26.00$ 101,816.00$ Tom Hanou, Constructibilty 0 0 0 120 0 0 0 0 120 38.00$ 4,560.00$ Chris Sheridan, Operations Specialist 0 0 40 0 0 0 0 0 40 55.00$ 2,200.00$ Donn Hogan, Architectural 0 0 120 0 0 0 0 0 120 52.00$ 6,240.00$ Paul Cockrell, HVAC 0 0 120 0 0 0 0 0 120 58.00$ 6,960.00$ Brad Miller, Structural Design 0 0 360 0 0 0 0 0 360 47.00$ 16,920.00$ Don Best, Instrumentation Design 0 0 345 0 0 0 0 0 345 57.00$ 19,665.00$ Adam Serock, Project Financing/3D 0 0 0 0 16 0 0 0 16 25.00$ 400.00$ Ernie Swanson/Randy Geist, Electrical 0 0 345 0 0 0 0 0 345 59.00$ 20,355.00$ Allyson Gillespie, CAD Technician 0 0 0 0 680 0 0 0 680 23.00$ 15,640.00$ Katie Ward, Project Controller 240 0 0 0 0 0 0 0 240 19.00$ 4,560.00$ Chris Kelly, Project Assistant 60 0 1240 0 0 0 0 0 1300 23.00$ 29,900.00$ HDR Totals 716 28 8246 560 712 0 0 0 10262 383,252.00$ Morrison Maierle Staff 23 Nancy Cormier, Hydraulic Profile 0 8 380 0 0 0 0 0 388 45.00$ 17,460.00$ James Nickelson, Site Planning 300 8 1100 0 0 0 0 0 1408 51.00$ 71,808.00$ Mike Kaczmarek, Groundwater Study 0 8 100 320 0 0 0 0 428 45.00$ 19,260.00$ Nate Menuez, Structural Design 0 8 360 240 0 80 0 600 1288 38.00$ 48,944.00$ Craig Brawner, Design Team 0 8 1980 2744 120 0 0 0 4852 36.00$ 174,672.00$ Travis Meyer, Ultraviolet Disinfection 0 8 400 0 0 0 0 0 408 43.00$ 17,544.00$ Bill Farrell, Field Inspection 0 0 0 0 0 258 0 0 258 29.00$ 7,482.00$ Steve Rude, Surveyor 0 0 0 0 300 258 0 0 558 33.00$ 18,414.00$ Mike Brandt, Standby Power 0 0 100 0 0 0 0 0 100 34.00$ 3,400.00$ Roger Sommerville, Construction Team 0 8 1000 2240 80 0 0 0 3328 35.00$ 116,480.00$ Steve Malmberg, Construction Team 0 8 0 566 0 0 1200 1760 3534 31.00$ 109,554.00$ Sue Dugan/Paula Madden, Clerical 80 0 1000 0 0 0 0 0 1080 18.00$ 19,440.00$ Morrison Maierle Totals 380 64 6420 6110 500 596 1200 2360 17630 624,458.00$ IAC Staff Chuck Wambeke, Principal 8 8 0 8 2 0 0 1 27 51.00$ 1,377.00$ Gary Johnson, Project Manager 8 8 0 0 0 0 0 16 32 44.00$ 1,408.00$ Mark Jenko, Senior Engineer 0 0 0 16 0 0 0 0 16 41.00$ 656.00$ Kyle Cram/Mike Roche, Project Engineer 8 8 0 60 16 0 0 0 92 33.00$ 3,036.00$ Matt Wolfe, Controls Engineer 0 0 0 0 16 0 0 0 16 31.00$ 496.00$ Sean Rumelhart, Senior Programmer 0 0 0 0 0 0 0 0 0 32.00$ -$ IAC Totals 24 24 0 84 34 0 0 17 183 6,973.00$ TOTAL HOURS 1120 116 14666 6754 1246 596 1200 2377 28075 Total Labor 1,014,683.00$ 1201*Project Administration OH/Profit Multiplier x3.15 1202*Pre-construction Conference Total Direct Labor 3,196,251.45$ 1203*Construction Engineering 1204*On-site Construction Observation Direct Expenses: 1205*Record Drawings Miscellaneous 129,000.00$ 1206*Field Surveying/Staking Travel Expenses 52,000.00$ 1207*Geotechnical and Material Testing Services Mapping/Photos/Surveys 6,000.00$ 1208*Special Inspection Services Printing and Photocopying 6,000.00$ Technology 111,002.70$ Total Direct Expenses 304,002.70$ 3,500,254.15$ DRAFTBozeman Phase 1 Construction Budget_(11)rev.xls Page 4 of 8 11/25/2008 33 Exhibit G City of Bozeman Water Reclamation Facility Phase 1 Expansion Task 1300 Project Startup Assistance & Commissioning Total HDR Staff 1301 1302 1303 Hours Rate Total Dan Harmon, Design Manager 4 16 16 36 60.00$ 2,160.00$ Bud Benjes, QA 0 0 0 0 65.00$ -$ John Koch, QA 0 0 16 16 65.00$ 1,040.00$ Craig Caprara, RAS/WAS Pumping 0 0 0 0 60.00$ -$ Matt Gough, Aeration Basin/BNR 0 0 0 0 44.00$ -$ Coralynn Jones, Blower Building 0 24 24 48 26.00$ 1,248.00$ Tom Hanou, Constructibilty 0 0 0 0 38.00$ -$ Chris Sheridan, Operations Specialist 40 1160 460 1660 55.00$ 91,300.00$ Donn Hogan, Architectural 0 0 0 0 52.00$ -$ Paul Cockrell, HVAC 0 0 0 0 58.00$ -$ Brad Miller, Structural Design 0 0 0 0 47.00$ -$ Don Best, Instrumentation Design 0 0 0 0 57.00$ -$ Adam Serock, Project Financing/3D 0 100 0 100 25.00$ 2,500.00$ Ernie Swanson/Randy Geist, Electrical 0 0 0 0 59.00$ -$ Allyson Gillespie, CAD Technician 8 290 0 298 23.00$ 6,854.00$ Katie Ward, Project Controller 0 0 0 0 19.00$ -$ Chris Kelly, Project Assistant 0 0 40 40 23.00$ 920.00$ HDR Totals 52 1590 556 2198 106,022.00$ Morrison Maierle Staff Nancy Cormier, Hydraulic Profile 0 16 24 40 45.00$ 1,800.00$ James Nickelson, Site Planning 8 16 40 64 51.00$ 3,264.00$ Mike Kaczmarek, Groundwater Study 0 0 0 0 45.00$ -$ Nate Menuez, Structural Design 0 0 0 0 38.00$ -$ Craig Brawner, Design Team 0 0 180 180 36.00$ 6,480.00$ Travis Meyer, Ultraviolet Disinfection 8 16 24 48 43.00$ 2,064.00$ Bill Farrell, Field Inspection 0 0 0 0 29.00$ -$ Steve Rude, Surveyor 0 0 0 0 33.00$ -$ Mike Brandt, Standby Power 0 0 0 0 34.00$ -$ Roger Sommerville, Construction Team 0 0 80 80 35.00$ 2,800.00$ Steve Malmberg, Construction Team 0 0 0 0 31.00$ -$ Sue Dugan/Paula Madden, Clerical 8 0 0 8 18.00$ 144.00$ Morrison Maierle Totals 24 48 348 420 16,552.00$ IAC Staff Chuck Wambeke, Principal 0 0 5 5 51.00$ 255.00$ Gary Johnson, Project Manager 0 0 8 8 44.00$ 352.00$ Mark Jenko, Senior Engineer 0 0 16 16 41.00$ 656.00$ Kyle Cram/Mike Roche, Project Engineer 0 0 100 100 33.00$ 3,300.00$ Matt Wolfe, Controls Engineer 0 0 0 0 31.00$ -$ Sean Rumelhart, Senior Programmer 0 0 0 0 32.00$ -$ IAC Totals 0 0 129 129 4,563.00$ TOTAL HOURS 76 1638 1033 2747 1301 Operations and Maintenance Manual Total Labor 127,137.00$ 1302 Electronic O & M Manual OH/Profit Multiplier x3.15 1303 Plant Facility Start-up and Operator Training Total Direct Labor 400,481.55$ Direct Expenses: Miscellaneous 10,000.00$ Travel Expenses 5,000.00$ Mapping/Photos/Surveys -$ Printing and Photocopying 1,000.00$ Technology 10,383.50$ Total Direct Expenses 26,383.50$ TASK TOTAL 426,865.05$ Subtasks DRAFTBozeman Phase 1 Construction Budget_(11)rev.xls Page 5 of 8 11/25/2008 34 Exhibit G City of Bozeman Water Reclamation Facility Phase 1 Expansion Task 1400 Application Software Programming Services Subtasks Total HDR Staff 1401 1402 1403 1404 1405 1406 Hours Rate Total Dan Harmon, Design Manager 0 0 0 0 0 0 0 60.00$ -$ Bud Benjes, QA 0 0 0 0 0 0 0 65.00$ -$ John Koch, QA 0 0 0 0 0 0 0 65.00$ -$ Craig Caprara, RAS/WAS Pumping 0 0 0 0 0 0 0 60.00$ -$ Matt Gough, Aeration Basin/BNR 0 0 0 0 0 0 0 44.00$ -$ Coralynn Jones, Blower Building 0 0 0 0 0 0 0 26.00$ -$ Tom Hanou, Constructibilty 0 0 0 0 0 0 0 38.00$ -$ Chris Sheridan, Operations Specialist 40 0 0 24 40 0 104 55.00$ 5,720.00$ Donn Hogan, Architectural 0 0 0 0 0 0 0 52.00$ -$ Paul Cockrell, HVAC 0 0 0 0 0 0 0 58.00$ -$ Brad Miller, Structural Design 0 0 0 0 0 0 0 47.00$ -$ Don Best, Instrumentation Design 120 180 0 110 145 40 595 57.00$ 33,915.00$ Adam Serock, Project Financing/3D 0 0 0 0 0 0 0 25.00$ -$ Ernie Swanson/Randy Geist, Electrical 120 80 0 0 45 24 269 59.00$ 15,871.00$ Allyson Gillespie, CAD Technician 0 0 0 0 0 0 0 23.00$ -$ Katie Ward, Project Controller 0 0 0 0 0 0 0 19.00$ -$ Chris Kelly, Project Assistant 0 0 0 0 0 0 0 23.00$ -$ HDR Totals 280 260 0 134 230 64 968 55,506.00$ Morrison Maierle Staff Nancy Cormier, Hydraulic Profile 0 0 0 0 0 0 0 45.00$ -$ James Nickelson, Site Planning 0 0 0 0 0 0 0 51.00$ -$ Mike Kaczmarek, Groundwater Study 0 0 0 0 0 0 0 45.00$ -$ Nate Menuez, Structural Design 0 0 0 0 0 0 0 38.00$ -$ Craig Brawner, Design Team 0 0 0 0 0 0 0 36.00$ -$ Travis Meyer, Ultraviolet Disinfection 0 0 0 0 0 0 0 43.00$ -$ Bill Farrell, Field Inspection 0 0 0 0 0 0 0 29.00$ -$ Steve Rude, Surveyor 0 0 0 0 0 0 0 33.00$ -$ Mike Brandt, Standby Power 0 0 0 0 0 0 0 34.00$ -$ Roger Sommerville, Construction Team 0 0 0 0 0 0 0 35.00$ -$ Steve Malmberg, Construction Team 0 0 0 0 0 0 0 31.00$ -$ Sue Dugan/Paula Madden, Clerical 0 0 0 0 0 0 0 18.00$ -$ Morrison Maierle Totals 0 0 0 0 0 0 0 -$ IAC Staff -$ Chuck Wambeke, Principal 4 8 68 7 22 5 114 51.00$ 5,814.00$ Gary Johnson, Project Manager 8 16 48 8 24 8 112 44.00$ 4,928.00$ Mark Jenko, Senior Engineer 0 0 16 0 0 0 16 41.00$ 656.00$ Kyle Cram/Mike Roche, Project Engineer 56 140 960 80 220 80 1536 33.00$ 50,688.00$ Matt Wolfe, Controls Engineer 0 0 40 0 0 0 40 31.00$ 1,240.00$ Sean Rumelhart, Senior Programmer 0 0 440 56 200 40 736 32.00$ 23,552.00$ IAC Totals 68 164 1572 151 466 133 2554 86,878.00$ TOTAL HOURS 348 424 1,572 285 696 197 3,522 1401*System Integration Total Labor 142,384.00$ 1402*Software Pre-Design Report OH/Profit Multiplier x3.15 1403*Software Programming and Testing Total Direct Labor 448,509.60$ 1404*Functional Demonstrations 1405*Field Commissioning and Software Startup Direct Expenses: 1406*Post Startup Support Miscellaneous 30,000.00$ Travel Expenses 5,000.00$ Mapping/Photos/Surveys -$ Printing and Photocopying 1,800.00$ Technology 14,053.00$ Total Direct Expenses 50,853.00$ TASK TOTAL 499,362.60$ DRAFTBozeman Phase 1 Construction Budget_(11)rev.xls Page 6 of 8 11/25/2008 35 Exhibit G City of Bozeman Water Reclamation Facility Phase 1 Expansion Task 1500 Project Close-Out Subtasks Total HDR Staff 1501 1502 Hours Rate Total Dan Harmon, Design Manager 24 8 32 60.00$ 1,920.00$ Bud Benjes, QA 0 0 0 65.00$ -$ John Koch, QA 0 0 0 65.00$ -$ Craig Caprara, RAS/WAS Pumping 0 0 0 60.00$ -$ Matt Gough, Aeration Basin/BNR 0 0 0 44.00$ -$ Coralynn Jones, Blower Building 40 24 64 26.00$ 1,664.00$ Tom Hanou, Constructibilty 0 0 0 38.00$ -$ Chris Sheridan, Operations Specialist 0 0 0 55.00$ -$ Donn Hogan, Architectural 0 0 0 52.00$ -$ Paul Cockrell, HVAC 0 0 0 58.00$ -$ Brad Miller, Structural Design 0 0 0 47.00$ -$ Don Best, Instrumentation Design 0 0 0 57.00$ -$ Adam Serock, Project Financing/3D 0 0 0 25.00$ -$ Ernie Swanson/Randy Geist, Electrical 0 0 0 59.00$ -$ Allyson Gillespie, CAD Technician 0 0 0 23.00$ -$ Katie Ward, Project Controller 8 0 8 19.00$ 152.00$ Chris Kelly, Project Assistant 16 4 20 23.00$ 460.00$ HDR Totals 88 36 124 4,196.00$ Morrison Maierle Staff -$ Nancy Cormier, Hydraulic Profile 20 0 20 45.00$ 900.00$ James Nickelson, Site Planning 40 0 40 51.00$ 2,040.00$ Mike Kaczmarek, Groundwater Study 0 0 0 45.00$ -$ Nate Menuez, Structural Design 0 0 0 38.00$ -$ Craig Brawner, Design Team 120 0 120 36.00$ 4,320.00$ Travis Meyer, Ultraviolet Disinfection 20 0 20 43.00$ 860.00$ Bill Farrell, Field Inspection 0 0 0 29.00$ -$ Steve Rude, Surveyor 0 0 0 33.00$ -$ Mike Brandt, Standby Power 0 0 0 34.00$ -$ Roger Sommerville, Construction Team 0 0 0 35.00$ -$ Steve Malmberg, Construction Team 0 0 0 31.00$ -$ Sue Dugan/Paula Madden, Clerical 0 0 0 18.00$ -$ Morrison Maierle Totals 200 0 200 8,120.00$ IAC Staff Chuck Wambeke, Principal 0 0 0 51.00$ -$ Gary Johnson, Project Manager 8 8 16 44.00$ 704.00$ Mark Jenko, Senior Engineer 0 0 0 41.00$ -$ Kyle Cram/Mike Roche, Project Engineer 16 16 32 33.00$ 1,056.00$ Matt Wolfe, Controls Engineer 0 0 0 31.00$ -$ Sean Rumelhart, Senior Programmer 0 0 0 32.00$ -$ IAC Totals 24 24 48 1,760.00$ TOTAL HOURS 312 60 256 1501*Contract Close-out Total Labor 14,076.00$ 1502*Certification OH/Profit Multiplier x3.15 Total Direct Labor 44,339.40$ Direct Expenses: Miscellaneous 100.00$ Travel Expenses 500.00$ Mapping/Photos/Surveys -$ Printing and Photocopying -$ Technology 1,475.60$ Total Direct Expenses 2,075.60$ TASK TOTAL 46,415.00$ DRAFTBozeman Phase 1 Construction Budget_(11)rev.xls Page 7 of 8 11/25/2008 36 Labor HDR MMI IAC 1100 Bidding Services 77,590.80$ 60,076.80$ -$ 1200 Construction Administration 1,207,243.80$ 1,967,042.70$ 21,964.95$ 1300 Project Startup Assistance & Commissioning 333,969.30$ 52,138.80$ 14,373.45$ 1400 Application Software Programming Services 174,843.90$ -$ 273,665.70$ 1500 Project Close-Out 13,217.40$ 25,578.00$ 5,544.00$ Labor Total 1,806,865.20$ 2,104,836.30$ 315,548.10$ Miscellaneous 33,944.00$ 108,156.00$ 35,000.00$ Travel Expenses 31,600.00$ 30,000.00$ 2,000.00$ Mapping/Photos/Surveys -$ 8,000.00$ -$ Printing and Photocopying 13,800.00$ 2,200.00$ 3,800.00$ Technology 55,406.00$ 77,202.40$ 12,078.00$ Expense Total 134,750.00$ 225,558.40$ 52,878.00$ Overall Total 1,941,615.20$ 2,330,394.70$ 368,426.10$ 37