Loading...
HomeMy WebLinkAbout01-14-19 City Commission Packet Materials - A5. Wastewater Impact Fee Study PresentationCommission Memorandum REPORT TO: Honorable Mayor and City Commission FROM: Anna Rosenberry, Assistant City Manager SUBJECT: Wastewater Impact Fee Study – Presentation by Impact Fee Study Consultants and direction to staff regarding adopting new study and making changes to the City’s Wastewater Impact Fees. MEETING DATE: January 14, 2019 AGENDA ITEM TYPE: Action RECOMMENDATION: Listen to the presentation, take public comment, and direct staff to return with a resolution to adopt the new study and change Wastewater Impact Fees. BACKGROUND: State law requires the city to periodically review and update our wastewater system development impact fees. The City’s Impact Fee Advisory Committee and city staff have been working with Tindale Oliver & Public Resources Management Group (PRMG) consultants to provide the necessary data and to formulate a recommendation to change Wastewater Impact Fees. Tonight, the consultants will present the Wastewater Impact Fee Study Update. This updated study & methodology has been recommended by the Impact Fee Advisory Committee. After hearing Mr. Thomas’ presentation and taking public comment, staff can draft a resolution and schedule the hearing that will adopt the Wastewater Impact Fee Study update and change the City’s Wastewater Impact Fees. Any changes in the City’s impact fees would be made effective by this resolution. Public Meetings & Participation: In the process of developing this updated study, we held numerous public meetings and opportunities for public participation. An initial public outreach meeting was held at City Hall as the update began. It was attended by members 333 of the public and stakeholders interested in topics such as transit, transportation, affordable housing, clean water, development, etc. We also maintained an Impact Fee Study Update “project page” on the City’s website. This site linked to historical impact fee information, as well as upcoming meeting times and draft content, and contained a link to submit public comment. Publicized meetings of the Impact Fee Advisory Committee were held in June and in December. There was an opportunity for public comment at those meetings as well. On December 11, 2018, PRMG representative, Henry Thomas, presented a revised Draft Wastewater Impact Fee Study Update to the Impact Fee Advisory Committee. The draft reflected updated project cost estimates for the Norton East Interceptor project and changes the Committee had requested for residential impact fees based on dwelling-unit size. (Similar to the Water Impact Fee Study, the previous draft had contained fees only based on the size of the water meter.) The Advisory Committee voted 4-0 to recommend adoption of the study, including fees based on dwelling-unit size. The draft minutes from that meeting are attached. The Wastewater Impact Fee Study is attached, in its final, recommended form. The document contains a Transmittal Letter, Executive Summary, Report, and Appendices. The Updated Fee: Wastewater Impact Fees are designed to recover capital costs associated with providing wastewater system capacity (both wastewater collection and wastewater treatment) to new development. This includes the cost of existing system assets with capacity available to serve new development and expansion-related projects included in the City’s Capital Improvement Plan (CIP). The proposed Fee Schedule is found of Page 2-10 and 2-11 of the report. It recommends a Residential Water Impact Fee based on square footage of living area. 334 Proposed Residential Wastewater Impact Fees Square Feet of Living Area Water Reclamation Plant Fee Per Unit Transmission System Fee Per Unit Combined Total Fee 1400 or Less $ 718 $ 415 $ 1,133 1401 to 1600 $ 913 $ 528 $ 1,441 1601 to 1800 $ 964 $ 558 $ 1,522 1801 to 2000 $ 1,026 $ 593 $ 1,619 2001 to 2200 $ 1,098 $ 635 $ 1,733 2201 to 2400 $ 1,159 $ 671 $ 1,830 2401 to 2600 $ 1,221 $ 706 $ 1,927 2601 to 2800 $ 1,241 $ 718 $ 1,959 2801 to 3000 $ 1,303 $ 754 $ 2,057 3001 or More $ 1,385 $ 801 $ 2,186 Group Quarters Per Person $ 1,026 $ 593 $ 1,619 The proposed Non-Residential Water Impact Fee is based on water-meter size. The Impact Fee charged to buildings needing a very-large meter (beyond 3 inch meter size) would be individually calculated. Proposed Non - Residential Wastewater Impact Fees Meter Size Water Reclamation Plant Fee Per Unit Transmission System Fee Per Unit Combined Total Fee 0.75-inch $ 1,539 $ 890 $ 2,429 1-inch $ 2,565 $ 1,484 $ 4,049 1.5-inch $ 5,130 $ 2,969 $ 8,099 2-inch $ 8,209 $ 4,750 $ 12,959 3-inch $ 15,392 $ 8,907 $ 24,299 Above 3-inch Calculated Calculated Calculated Comparisons of Existing and Proposed Fee: Comparisons of the existing and proposed fee for specific dwelling sizes and commercial projects are shown below. (Lot sizes are referenced because our existing fee schedule contains a lot-size element that is not recommended in the updated study or the proposed fee.) 335 Wastewater Impact Fee Examples - Residential Existing Fee Proposed Fee Change Change Median Detached Home $ 1,697.22 $ 1,830.00 8% $ 132.78 2,400 sq. ft. 6,500 sq. ft. lot Small Detached Home $ 1,082.79 $ 1,441.00 33% $ 358.21 1,500 sq. ft. 4,500 sq. ft. lot Townhome $ 787.92 $ 1,133.00 44% $ 345.08 1,350 sq. ft. 3,000 sq. ft. lot Group Quarters $ 6,104.10 $ 16,190.00 165% $ 10,085.90 10 residents 15,246 sq. ft. lot Apartment Building $ 7,829.32 $ 13,596.00 74% $ 5,766.68 12 homes@ 1,000 sq. ft. each 21,408 sq. ft. lot Affordable Housing Townhome $ 732.22 $ 1,133.00 55% $ 400.78 800 sq. ft 2,500 sq. ft. lot Wastewater Impact Fee Examples -Non-Residential Existing Fee Proposed Fee Change Offices $ 4,932.69 $ 2,429.00 -51% $ (2,503.69) 3/4 inch meter 30,000 sq. ft. lot 10,000 sq. ft. bldg Retail $ 6,046.83 $ 2,429.00 -60% $ (3,617.83) 3/4 inch meter 40,000 sq. ft. lot 12,000 sq. ft. bldg Restaurant $ 10,741.48 $ 8,099.00 -25% $ (2,642.48) 1.5 inch meter 25,000 sq. ft. lot 6,000 sq. ft. bldg Manufacturing $ 8,672.92 $ 4,049.00 -53% $ (4,623.92) 1 inch meter 45,000 sq. ft. lot 15,000 sq. ft. bldg 336 We have also prepared a Comparison Schedule for All Fee Types (Water, Wastewater, Transportation, and Fire/EMS), which is attached to this memo. UNRESOLVED ISSUES: None. ALTERNATIVES: As for further study of different methods or data. FISCAL EFFECTS: This presentation has no immediate fiscal effects. Once the Commission adopts the study and resolution necessary to change Impact Fees, amounts deposited to the Wastewater Impact Fee Fund will be based upon the new schedule. Attachments: Wastewater Impact Fee Study, Dated December 3, 2018 Draft Impact Fee Advisory Committee Minutes – December 11, 2018 Comparison Schedule for All Fee Types – Residential Comparison Schedule for All Fee Types – Non-Residential Report compiled on: January 4, 2019 337 Fiscal Year 2018 WASTEWATER IMPACT FEE STUDY For CITY OF BOZEMAN, MONTANA Public Resources Management Group, Inc. Utility, Rate, Financial, and Management Consultants 338 Public Resources Management Group, Inc. Utility, Rate, Financial, and Management Consultants K:\DC\1246-01\Rpt\Revised Wastewater Impact Fee Study.docx 341 NORTH MAITLAND AVENUE – SUITE 300 – MAITLAND, FL 32751 Tel: 407-628-2600  Fax: 407-628-2610  Email: PRMG@PRMGinc.com  Website: www.PRMGinc.com December 3, 2018 Honorable Mayor and Members of the City Commission City of Bozeman 121 N. Rouse Avenue Bozeman, MT 59715 Subject: Wastewater Impact Fee Study Public Resources Management Group, Inc. ("PRMG") has completed our review of the wastewater impact fees for the City of Bozeman, Montana (the "City") wastewater system (the "System"), and has summarized the results of our analyses, assumptions, and conclusions in this service area report, which is submitted for your consideration. This service area report summarizes and provides a basis for the updated impact fees recommended for the wastewater system (the "System") that are a source of funding for the City's expansion-related capital costs for the System. The proposed wastewater impact fees have been designed to meet a number of goals and objectives that include:  The wastewater impact fees are based on the requirements of Title 7, Chapter 6, Part 16 of the Montana Code and, therefore, comply with Montana State Law;  The wastewater impact fees are designed to recover the capital costs associated with providing wastewater capacity to new development including the cost of existing system assets with capacity available to serve new development and expansion-related projects included in the City’s capital improvement program (the "CIP");  The impact fees do not include the funding requirements associated with any infrastructure deficiencies of the wastewater system (e.g., renewals and replacements) or any operating and maintenance expenses; and  The impact fees are based upon reasonable level of service standards that generally meet the needs of the City’s new customers, that are indicative of criteria used for long-term infrastructure planning, and that are consistent with the current level of service provided to existing customers. 339 Honorable Mayor and Members of the City Commission City of Bozeman December 3, 2018 Page 2 Based on information provided by the City regarding the capital cost of system facilities, customer service levels, existing capacity utilization, the assumptions and considerations outlined in this report, and our studies and evaluations, PRMG considers the proposed wastewater impact fees to be cost-based, reasonable, and representative of the capital cost of serving new development. Following this letter, we have provided an executive summary, which outlines our observations, recommendations and conclusions to the City. The accompanying report provides the details of the analyses conducted on behalf of the City. We appreciate the opportunity to be of service to the City and would like to thank the City staff for their assistance and cooperation during the course of this study. Very truly yours, Public Resources Management Group, Inc. Henry L. Thomas Senior Vice-President HLT/leg Attachments 340 -i- CITY OF BOZEMAN, MONTANA WASTEWATER IMPACT FEE STUDY TABLE OF CONTENTS Title Page No. Letter of Transmittal Table of Contents ................................................................................................................... i List of Tables, Figures, and Appendices ................................................................................ ii EXECUTIVE SUMMARY AND RECOMMENDATIONS Purpose of Wastewater Impact Fees .................................................................................ES-1 Observations, Recommendations, and Conclusions .........................................................ES-1 SECTION 1: INTRODUCTION General ................................................................................................................................ 1-1 Criteria for Wastewater Impact Fees .................................................................................. 1-1 Establishment of Need and Supporting Documentation ..................................................... 1-2 SECTION 2: DEVELOPMENT OF WASTEWATER IMPACT FEES Introduction ......................................................................................................................... 2-1 Existing Wastewater Impact Fees ....................................................................................... 2-1 Impact Fee Development Methods ..................................................................................... 2-2 Design of Wastewater Impact Fees ..................................................................................... 2-2 Level of Service Requirements ........................................................................................... 2-3 Existing Plant-in-Service .................................................................................................... 2-3 Additional Capital Investment ............................................................................................ 2-6 Design of Wastewater Impact Fee ...................................................................................... 2-7 Equivalent Dwelling Unit Determination Methodology ..................................................... 2-9 Proposed Wastewater Impact Fee Schedule ..................................................................... 2-10 Conclusions and Recommendations ................................................................................. 2-11 341 -ii- CITY OF BOZEMAN, MONTANA WASTEWATER IMPACT FEE STUDY LIST OF TABLES, FIGURES, AND APPENDICES Table No. Description Page No. ES-1 Summary of Calculated Costs Per Gallon and Proposed Wastewater Impact Fees ES-3 2-1 Development of Existing Wastewater Treatment Facility Capacity Available to Serve System Growth 2-12 2-2 Multi-Year Estimated Capital Improvement Program Summary 2-14 2-3 Summary of Capital Improvement Program By Plant Function 2-16 2-4 Summary of Capital Improvement Program Recognized in Wastewater Impact Fees 2-18 2-5 Development of Wastewater Impact Fee 2-21 2-6 Calculation of Debt Service Credit – Wastewater System 2-23 Figure No. Description Page No. 1-1 Wastewater Impact Fee Compliance with Montana Enabling Impact Fee Legislation (Section 7-6-1602 MCA) 1-3 Appendix No. Description A Classification of Existing Wastewater Utility System Assets 342 EEXXEECCUUTTIIVVE E SSUUMMMMAARRYY AANNDD RREECCOOM MMMEENNDDAATTIIOO NNSS 343 ES-1 CITY OF BOZEMAN, MONTANA WASTEWATER IMPACT FEE STUDY EXECUTIVE SUMMARY AND RECOMMENDATIONS PURPOSE OF WASTEWATER IMPACT FEES The purpose of wastewater impact fees is to recover the pro-rata share of allocated capital costs that are considered growth-related from new customers connecting to the system or from existing customers that are requesting an increase in the reserved wastewater capacity associated with increased development on their property. To the extent that new population growth and associated development impose identifiable capital costs to municipal services, capital funding practices to include the assignment of such costs to those residents or system users responsible for those costs rather than to the entire population base is reasonable. Generally, this practice has been labeled as "growth paying its own way" to minimize existing user cost burdens. The application of impact fees to finance capital infrastructure allocated to such new capacity requests is very common in Montana and throughout the United States and has been used as a capital funding source by the City of Bozeman (the "City") for a number of years. The City last reviewed its wastewater impact fees in 2012. Since Montana's enabling impact fee legislation requires a review and update of impact fees at least every five (5) years, the City commissioned impact fee reviews in 2017. OBSERVATIONS, RECOMMENDATIONS, AND CONCLUSIONS The following is a summary of the observations, recommendations and conclusions developed by PRMG during our investigation, analyses, and preparation of this report: 1. The imposition of impact fees must satisfy the requirements of Montana State Law based on the criteria set forth in Title 7, Chapter 6, Part 16 of the Montana Code Annotated (the "MCA") and should reflect a rational nexus whereby the benefits received by new development are reasonably related to the impact fees. 2. The wastewater facilities such as the treatment and transmission facilities are interconnected and serve an overall system need and, as such, the proposed impact fee is based on a single service area or system-wide fee for the wastewater system. The proposed wastewater impact fee is $1,619 per equivalent dwelling unit ("EDU"). For residential wastewater service, the City charges a wastewater impact fee based on the size of the residential home. For non-residential wastewater service, the City charges a wastewater impact fee based on the size of the water meter in service. While no changes in the application methodology is proposed, this study updates the demand coefficients or EDUs for each category of service based on the most recently available information from the City. 3. The capital costs included in the proposed wastewater impact fees are based on: i) the cost of certain existing wastewater system assets with capacity available to serve new 344 ES-2 development; ii) planned capital improvements that upgrade existing wastewater assets, a portion of which are available to serve growth; and iii) planned capital improvements that provide additional capacity to serve future growth. The cost of such capacity is allocated between existing and future customers based on the estimated benefit or proportionate share assigned to such customers predicated on the intent of the expenditures, level of service assumptions, the existing and future capacity needs of the System. The proposed fees also include a five percent (5%) allowance to recover administrative costs as allowable by Montana's enabling impact fee legislation. 4. The CIP for the wastewater system does not include any further expansion of the capacity of existing wastewater treatment and disposal facilities, but does include: i) projects which upgrade the existing wastewater treatment and disposal facilities that benefit both existing and future customers; and ii) improvements that expand the wastewater transmission system or upgrade existing transmission assets, a portion of which are available to serve growth. In keeping with Montana State Law a proportionate share of these costs was assigned to new development and was included in the calculation of the proposed wastewater impact fees. 5. In accordance with the provisions of Montana State Law and case law pertaining to impact fees, the fees can only be used to pay for growth-related projects or to pay for growth- related debt service. The City could use wastewater impact fee receipts either to: i) pay directly for the costs of projects allocable to growth such that the need for borrowing external funds to finance the identified wastewater system capital program is reduced; or ii) apply the impact fees toward the expansion-related component of the City's debt service payments for the wastewater system. Table ES-1, on the following page, contains a summary of existing and proposed wastewater impact fees. (Remainder of page intentionally left blank) 345 PROPOSED APPLICATION METHODOLOGY Wastewater Impact Fee - Residential Wastewater Wastewater Reclamation Plant Reclamation Plant Wastewater Calculated Impact Fee Impact Fee Line Treatment Component Reclamation Plant Calculated Less Cost per Gallon With Gallons per per Unit Without Administration per Unit With No. Square Feet of Living Area Fee per Unit Cost per Gallon Debt Service Credit Debt Service Credit Day per EDU EDU Factor Admin Charge Charge Admin Charge 1 1400 or Less $440.89 $8.47 ($1.68) $6.79 144 0.70 $684.12 5.0% $718.00 2 1401 - 1600 565.04 8.47 (1.68) 6.79 144 0.89 869.81 5.0% 913.00 3 1601 - 1800 676.43 8.47 (1.68) 6.79 144 0.94 918.68 5.0% 964.00 4 1801 - 2000 775.05 8.47 (1.68) 6.79 144 1.00 977.32 5.0% 1,026.00 5 2001 - 2200 864.39 8.47 (1.68) 6.79 144 1.07 1,045.73 5.0% 1,098.00 6 2201 - 2400 945.60 8.47 (1.68) 6.79 144 1.13 1,104.37 5.0% 1,159.00 7 2401 - 2600 1,018.70 8.47 (1.68) 6.79 144 1.19 1,163.01 5.0% 1,221.00 8 2601 - 2800 1,087.15 8.47 (1.68) 6.79 144 1.21 1,182.56 5.0% 1,241.00 9 2801 - 3000 1,150.97 8.47 (1.68) 6.79 144 1.27 1,241.20 5.0% 1,303.00 10 3001 or More 1,190.42 8.47 (1.68) 6.79 144 1.35 1,319.38 5.0% 1,385.00 11 Group Quarters per person 428.13 8.47 (1.68) 6.79 144 1.00 977.32 5.0% 1,026.00 Calculated Cost Transmission System Transmission System Calculated Transmission System Impact Fee Transmission Component Fee per Net Acre Calculated Less Cost per Gallon With Gallons per Impact Fee Without Administration per Unit With Square Feet of Living Area of Development Cost per Gallon Debt Service Credit Debt Service Credit Day per EDU EDU Factor Admin Allowance Allowance Admin Allowance 12 1400 or Less $4,716.42 $4.05 ($0.13) $3.93 144 0.70 $395.90 5.0% $415.00 13 1401 - 1600 4,716.42 4.05 (0.13) 3.93 144 0.89 503.36 5.0% 528.00 14 1601 - 1800 4,716.42 4.05 (0.13) 3.93 144 0.94 531.64 5.0% 558.00 15 1801 - 2000 4,716.42 4.05 (0.13) 3.93 144 1.00 565.57 5.0% 593.00 16 2001 - 2200 4,716.42 4.05 (0.13) 3.93 144 1.07 605.16 5.0% 635.00 17 2201 - 2400 4,716.42 4.05 (0.13) 3.93 144 1.13 639.10 5.0% 671.00 18 2401 - 2600 4,716.42 4.05 (0.13) 3.93 144 1.19 673.03 5.0% 706.00 19 2601 - 2800 4,716.42 4.05 (0.13) 3.93 144 1.21 684.34 5.0% 718.00 20 2801 - 3000 4,716.42 4.05 (0.13) 3.93 144 1.27 718.28 5.0% 754.00 21 3001 or More 4,716.42 4.05 (0.13) 3.93 144 1.35 763.52 5.0% 801.00 22 Group Quarters per person 4,716.42 4.05 (0.13) 3.93 144 1.00 565.57 5.0% 593.00 Calculated Total Proposed Fee Total Proposed Fee Combined Total Existing Fee Calculated Less Cost per Gallon With Gallons per Without Administration per Unit With Square Feet of Living Area for One Acre Cost per Gallon Debt Service Credit Debt Service Credit Day per EDU EDU Factor Admin Charge Charge Admin Charge 23 1400 or Less $5,157.31 $12.52 ($1.81) $10.71 144 0.70 $1,080.02 5.0% $1,133.00 24 1401 - 1600 5,281.46 12.52 (1.81) 10.71 144 0.89 1,373.17 5.0% 1,441.00 25 1601 - 1800 5,392.85 12.52 (1.81) 10.71 144 0.94 1,450.32 5.0% 1,522.00 26 1801 - 2000 5,491.47 12.52 (1.81) 10.71 144 1.00 1,542.89 5.0% 1,619.00 27 2001 - 2200 5,580.81 12.52 (1.81) 10.71 144 1.07 1,650.89 5.0% 1,733.00 28 2201 - 2400 5,662.02 12.52 (1.81) 10.71 144 1.13 1,743.47 5.0% 1,830.00 29 2401 - 2600 5,735.12 12.52 (1.81) 10.71 144 1.19 1,836.04 5.0% 1,927.00 30 2601 - 2800 5,803.57 12.52 (1.81) 10.71 144 1.21 1,866.90 5.0% 1,959.00 31 2801 - 3000 5,867.39 12.52 (1.81) 10.71 144 1.27 1,959.47 5.0% 2,057.00 32 3001 or More 5,906.84 12.52 (1.81) 10.71 144 1.35 2,082.90 5.0% 2,186.00 33 Group Quarters per person 5,144.55 12.52 (1.81) 10.71 144 1.00 1,542.89 5.0% 1,619.00 City of Bozeman, Montana Table ES-1 Summary of Calculated Costs per Gallon and Proposed Wastewater Impact Fees Wastewater Impact Fee Study ES-346 3 City of Bozeman, Montana Table ES-1 Summary of Calculated Costs per Gallon and Proposed Wastewater Impact Fees Wastewater Impact Fee Study Wastewater Impact Fee - Nonresidential Line No. Meter Size Existing Fee Proposed Rate Calculation Impact Fee Impact Fee Rated Maximum Meter Without Administration With Treatment Component Per Meter Size Capacity (gpm) Equivalent Factor Admin Allowance Allowance Admin Allowance 34 0.75-inch $1,545.45 30 1.50 $1,465.98 5.0% $1,539.00 35 1-inch 3,556.17 50 2.50 2,443.30 5.0% 2,565.00 36 1.5-inch 7,731.91 100 5.00 4,886.60 5.0% 5,130.00 37 2-inch 14,382.46 160 8.00 7,818.56 5.0% 8,209.00 38 3-inch 30,775.63 300 15.00 14,659.80 5.0% 15,392.00 39 Above 3-inch Calculated Calculated Impact Fee Impact Fee Rated Maximum Meter Without Administration With Transmission Component Per Net Acrea Capacity (gpm) Equivalent Factor Admin Allowance Allowance Admin Allowance 40 0.75-inch $4,716.42 30 1.50 $848.36 5.0% $890.00 41 1-inch 4,716.42 50 2.50 1,413.93 5.0% 1,484.00 42 1.5-inch 4,716.42 100 5.00 2,827.86 5.0% 2,969.00 43 2-inch 4,716.42 160 8.00 4,524.57 5.0% 4,750.00 44 3-inch 4,716.42 300 15.00 8,483.57 5.0% 8,907.00 45 Above 3-inch Calculated Calculated Impact Fee Impact Fee Total Existing Fee Rated Maximum Meter Without Administration With Combined for One Acre Capacity (gpm) Equivalent Factor Admin Allowance Allowance Admin Allowance 46 0.75-inch $6,261.87 30 1.50 $2,314.34 5.0% $2,429.00 47 1-inch 8,272.59 50 2.50 3,857.23 5.0% 4,049.00 48 1.5-inch 12,448.33 100 5.00 7,714.46 5.0% 8,099.00 49 2-inch 19,098.88 160 8.00 12,343.13 5.0% 12,959.00 50 3-inch 35,492.05 300 15.00 23,143.37 5.0% 24,299.00 51 Above 3-inch Calculated Calculated ES-347 4 SSEECCTTIIOONN 1 1 IINNTTRROODDUUCCT TIIOONN 348 1-1 CITY OF BOZEMAN, MONTANA WASTEWATER IMPACT FEE STUDY SECTION 1: INTRODUCTION GENERAL The City of Bozeman, Montana (the "City") owns and operates a wastewater utility system (the "System") within its service area boundaries. The City has historically used impact fees to fund a portion of the expansion-related capital costs for the System. The City last reviewed its wastewater impact fees in 2012. Since Montana's enabling impact fee legislation requires a review and update of impact fees at least every five (5) years, the City commissioned impact fee reviews in 2017. CRITERIA FOR WASTEWATER IMPACT FEES The purpose of an impact fee is to assign, to the extent practical, growth-related capital costs to those new customers responsible for such additional costs. To the extent population growth and associated development require identifiable capital costs to provide utility service, modern capital funding practices suggest the assignment of such costs to those new residents or system users responsible for those costs rather than the existing customer base. Generally, this practice is labeled as "growth paying its own way" to avoid burdening existing users with the cost of facility expansion. Within the State of Montana, Title 7, Chapter 6, Part 16 of the Montana Code Annotated (the "Code" or the "MCA") authorizes the use of impact fees for utilities owned by local governments. According to the Code, a valid impact fee, among other things, must meet the following requirements: 1. The calculation of the impact fee must be based on the proportionate share of the cost of infrastructure improvements necessary to serve new development; 2. Provide for recognition of other available funding sources such as grants; 3. The fee cannot include the cost of correcting existing System deficiencies; 4. The fee may not include expenses related to the operation and maintenance of the facility; 5. New development may not be held to a higher level of service standard than existing users unless there is a funding mechanism in place for the existing users to make improvements that match the higher level of service. 6. The City must deposit the impact fees in a special proprietary fund and monies held in this fund prior to expenditure must be invested with all interest accruing to the fund to ensure that the fees collected are used only for the lawful purposes established in the Code. 349 1-2 7. The City must collect the impact fees in accordance with an impact fee ordinance or resolution that establishes the method for developing and applying the fee and makes such information available to the public upon request. In addition, the ordinance or resolution should also explicitly restrict the use of the fees collected. Based on the criteria above, we believe that the proposed wastewater impact fees recommended herein, which are set forth in the Executive Summary and in Section 2, are in compliance with the Code and as such: i) include only the proportionate share of the estimated capital cost of facilities necessary to serve new development, ii) do not reflect costs associated with renewal and replacement of any existing capital assets to cure existing System deficiencies, iii) do not include any costs of operation and maintenance of any facilities; and iv) recognize other funding sources such as grants used by the City to construct certain wastewater capital facilities. ESTABLISHMENT OF NEED AND SUPPORTING DOCUMENTATION The City of Bozeman currently owns and operates one wastewater treatment facility – the Bozeman Water Reclamation Facility ("WRF") – which has a current capacity of 8.5 million gallons per day (MGD) expressed on an average daily flow basis. The wastewater collection system consists of 278 miles of wastewater lines, 4,200 manholes, and 12 lift stations. Since the wastewater treatment and transmission facilities are interconnected and serve an overall system need, the proposed wastewater impact fees represent a single service area. Wastewater impact fees charged by utility providers in Montana are based on the requirements of Title 7, Chapter 6, Part 16 of the Montana Code. Figure 1-1 presents the specific documentation that will allow the City of Bozeman to update the wastewater impact fee in compliance with Montana State Law. (Remainder of page left intentionally left blank) 350 1-3 Figure 1-1 Wastewater Impact Fee Study Compliance with Montana Enabling Impact Fee Legislation (Section 7-6-1602 MCA) Wastewater System Section Reference Documentation Item Document(s) Page or Section (1) for each public facility for which an impact fee is imposed, the governmental agency must prepare and approve a service area report. Wastewater Impact Fee Study Service Area Report (2) The service area report is a written analysis that must: (2)(a) describe existing conditions of the facility. Bozeman Wastewater Collection Facilities Plan dated May 2015 Chapter 3: Existing Collection System Database (2)(b) establish level of service standards. Bozeman Wastewater Collection Facilities Plan dated May 2015 Chapter 2: Basis of Planning, Page 2-12 Wastewater Impact Fee Study Service Area Report Section 2: Development of Wastewater Impact Fees, Level of Service Requirements, Page 2-3 (2)(c) forecast future additional needs for service for a defined period of time. Bozeman Wastewater Collection Facilities Plan dated May 2015 Chapter 5: Future Collection System Evaluation (2)(d) identify capital improvements necessary to meet future needs for service. Bozeman Wastewater Collection Facilities Plan dated May 2015 Chapter 6: Summary Recommendations and Capital Improvement Summary CIP Wastewater-related projects Wastewater Impact Fee Study Service Area Report Section 2: Development of Wastewater Impact Fees, Tables 2-2 to 2-4 (2)(e) identify those capital improvements needed for continued operation and maintenance of the facility. Bozeman Wastewater 1-4 Figure 1-1 (cont.) Wastewater Impact Fee Study Compliance with Montana Enabling Impact Fee Legislation (Section 7-6-1602 MCA) Wastewater System Section Reference Documentation Item Document(s) Page or Section (2)(h) establish the methodology and time period over which the governmental entity will assign the proportionate share of capital costs for expansion of the facility to provide service to new development within each service area. CIP Wastewater-related improvements in the CIP Wastewater Impact Fee Study Service Area Report Section 2: Development of Wastewater Impact Fees (2)(i) establish the methodology that the governmental entity will use to exclude operations and maintenance costs and correction of existing deficiencies from the impact fee. Bozeman Wastewater Collection Facilities Plan dated May 2015 Chapter 6: Summary Recommendations and Capital Improvement Summary Wastewater Impact Fee Study Service Area Report Section 2: Development of Wastewater Impact Fees (2)(j) establishes the amount of the impact fee that will be imposed for each unit of increased service demand. Wastewater Impact Fee Study Service Area Report Table ES-1; Section 2: Development of Wastewater Impact Fee, Table 2- 5 (2)(k) has a component of the budget of the governmental entity that: (i) schedules construction of public facility capital improvements to serve projected growth. (ii) projects costs of the capital improvements. (iii) allocates collected impact fees for construction of the capital improvements. (iv) covers at least a 5-year period and is 1-5 Figure 1-1 (cont.) Wastewater Impact Fee Study Compliance with Montana Enabling Impact Fee Legislation (Section 7-6-1602 MCA) Wastewater System Section Reference Documentation Item Document(s) Page or Section (5) The amount of each impact fee imposed must be based upon the actual cost of public facility expansion or improvements or reasonable estimates of the cost to be incurred by the governmental entity as a result of new development. The calculation of each impact fee must be in accordance with generally accepted accounting principles. Wastewater Impact Fee Study Service Area Report Section 2: Development of Wastewater Impact Fees, Table 2- 5 (6) The ordinance or resolution adopting the impact fee must include a time schedule for periodically updating the documentation required under subsection (2). Updated Wastewater Impact Fee Resolution To be determined (7) An impact fee must meet the following requirements: (a) The amount of the impact fee must be reasonably related to and reasonable attributable to the development’s share of the cost of infrastructure improvements made necessary by the new development. (b) The impact fees imposed may not exceed a proportionate share of the costs incurred or to be incurred by the governmental entity in accommodating the development. The following factors must be considered in determining a proportionate share of public facilities capital improvements costs: (i) the need for public facilities capital improvements required to serve new development; and (ii) consideration of payments for system improvements reasonable/ anticipated to be made by or as a result of development in the form of user fees, taxes, and other available sources of funding the system improvements. (c) Costs for correction of existing deficiencies in a public facility may not be included in the impact fee. (d) New development may not be held to a higher level of service than existing users SSEECCTTIIOONN 2 2 DDEEVVEELLOOPPMME ENNTT OOFF WWAASSTTEEWWAATTE ERR SSYYSSTTEEMM IIMMPPAACCTT F FEEEESS 354 2-1 CITY OF BOZEMAN, MONTANA WASTEWATER IMPACT FEE SERVICE AREA REPORT SECTION 2: DEVELOPMENT OF WASTEWATER IMPACT FEES INTRODUCTION This section of the report summarizes the basis for the development of the City's proposed wastewater impact fees. Included in this section is a presentation of the existing impact fees for providing service to new wastewater customers, a discussion of the methodology used to develop the proposed wastewater impact fees, and a comparison of the proposed fees with those of other neighboring jurisdictions. EXISTING WASTEWATER IMPACT FEES Resolution No. 4422 (the "Wastewater Impact Fee Resolution"), which was adopted by the City Commission on December 10, 2012, established wastewater impact fees for the City based on a formal wastewater impact fee review. Section 2.06.1700(L) of the City's Code of Ordinances enables the City to adjust the wastewater impact fees annually to reflect the effects of inflation on those costs for improvements set forth in the wastewater impact fee study. On January 1 of each year unless and until the wastewater impact fee study is revised or replaced, the wastewater impact fee is adjusted by multiplying such amount by one plus the value of the Construction Cost Index published by Engineering News-Record in the first December edition of the current year. The adjusted wastewater impact fees automatically become effective immediately upon calculation by the City without additional action by the City Commission. The current wastewater impact fees are summarized as follows: Existing Residential Wastewater Impact Fees Square Feet of Living Area Water Reclamation Plant Fee Per Unit Transmission System Fee Per Net Acre of Development 1400 or Less $440.89 $4,716.42 1401 to 1600 565.04 4,716.42 1601 to 1800 676.43 4,716.42 1801 to 2000 775.05 4,716.42 2001 to 2200 864.39 4,716.42 2201 to 2400 945.60 4,716.42 2401 to 2600 1,018.70 4,716.42 2601 to 2800 1,087.15 4,716.42 2801 to 3000 1,150.97 4,716.42 3001 or More 1,190.42 4,716.42 Group Quarters Per Person 428.13 4,716.42 (Remainder of page left intentionally left blank) 355 2-2 Existing Nonresidential Water Impact Fees Meter Size Water Reclamation Plant Fee Per Meter Transmission System Fee Per Net Acre of Development 0.75-inch $1,545.45 $4,716.42 1-inch 3,556.17 4,716.42 1.5-inch 7,731.91 4,716.42 2-inch 14,382.46 4,716.42 3-inch 30,775.63 4,716.42 IMPACT FEE DEVELOPMENT METHODS There are several different methods generally recognized for the calculation of impact fees. The calculation is dependent on the type of charge being calculated (e.g., water, wastewater, police services, transportation, etc.); the cost and engineering data available; and the availability of other local data such as household and population projections, current levels of service, and other related items. There are two general methods for calculating impact fees: i) the improvements- driven method and ii) the standards-driven method. Both methods have been utilized in the development of impact fees for local governments. The improvements-driven method, which is generally used for water and wastewater impact fees, is an approach that utilizes a specific list of planned capital improvements over a period of time. The fee corresponds to the level of capital improvements, which have been identified in the capital improvements element of a local government’s comprehensive land use / community plan or the master plan or capital improvement plan of the utility. The standards-driven method utilizes an estimated or theoretical cost of the improvements for incremental development typically based on historical estimates. For example, the standards-driven method for a transportation impact fee would consider the estimated cost of a mile of a new road by the trip capacity of a mile of road to establish the cost per trip. The primary difference between the two methodologies is how the capital costs are calculated; however, both methods meet the requirements of the Section 7-6-1602(5) of the Code requiring that impact fees be based on the actual cost of the improvements or reasonable estimates of such costs. The development of water and wastewater impact fees is typically based on the improvements-driven method, whereby the cost of capital facilities are allocated between current and future users based on reasonable and defensible data and estimates of facility utilization. The improvements-driven method is used by utility systems because this method works well in conjunction with the capital planning process of the utility business. The impact fees proposed in this report are based on the improvements-driven method using the capital costs and needs as documented in the City's asset records and CIP. The method recognizes the embedded cost of existing unused capacity that is available from the City's existing utility plant which is currently in service, as well as planned investments in wastewater treatment and transmission assets that provide additional wastewater system capacity. DESIGN OF WASTEWATER IMPACT FEES The approach to designing wastewater impact fees includes two significant components. These two components are: i) the level of service to be apportioned to the applicants that request system 356 2-3 capacity; and ii) the associated amount of capital cost to be recovered from a new applicant requesting service. Both of these items are related to the level of the wastewater impact fee expressed on an equivalent dwelling unit (EDU) basis, which represents the average capacity required to service a typical individually-metered single family residential account. LEVEL OF SERVICE REQUIREMENTS In the evaluation of the capital facility needs for providing water and wastewater utility services, it is critical that a level of service (LOS) standard is established. The level of service is an indicator of the extent or degree of service provided to a specific customer. Level of service indicates the capacity per unit of demand for each public facility. Essentially, the level of service standard is established in order to ensure that adequate facility capacity will be provided for future development. For water and wastewater service, the level of service that is commonly used in the industry is the amount of capacity (service) allocable to each EDU expressed as the average amount of usage (gallons) on a daily basis. The level of service generally represents the amount of capacity attributable to an EDU, whether or not such capacity is actually used (commonly referred to as "readiness to serve"). As previously mentioned, an EDU is representative of the average capacity required to service a typical individually metered single-family residential account. This class of users represents the largest amount of customers served by a public utility such as the City's and generally has the lowest level of usage requirements for a specifically metered account. Several alternative methods are used to apply the EDU concept to non-single family residential uses including business attributes linked to the demand for water and wastewater service, fixture counts, and meter size equivalency factors. Pursuant to Montana State Law, in the calculation of water impact fees, new development may not be held to a higher level of service standard than existing users. Accordingly, the following levels of service standards were assumed for calculating the proposed impact fees based on actual historical information for existing users as provided by City staff and as contained in the Bozeman Wastewater Collection Facilities Plan dated May 2015: Derivation of Wastewater Level of Service Utilized in Wastewater Impact Fee Calculations Amount Residential Per Capita Wastewater Generation [1] 64.4 gpd Persons Per Household [2] 2.24 Recognized Level of Service Per Wastewater EDU 144 gpd __________ [1] Amounts shown on page 1-2 of Bozeman Wastewater Collection Facilities Plan Update dated May 2015. [2] Persons per household for 2012 to 2016 as published by U.S. Census (census.gov). EDU = equivalent dwelling unit gpd = gallons per day – average daily flow basis EXISTING PLANT-IN-SERVICE In the determination of the impact fee associated with the servicing of future customers, any constructed capacity in existing treatment and transmission facilities that is available to serve future growth was considered in developing the proposed wastewater impact fees. Since this 357 2-4 capacity was constructed and is available to serve the near-term growth of the utility system, it is appropriate to recognize the capacity cost of such facilities. In order to evaluate the availability of the existing utility plant-in-service to meet or provide for near-term future capacity needs, it was necessary to categorize the existing utility facilities by specific utility function or purpose (treatment, conveyance, etc.). Categorizing the investment in existing utility facilities helps to identify those assets that should be considered or included in the determination of the impact fees. The functional cost categories are based on the purpose of the assets and the service that such assets served. The following is a summary of the functional cost categories for the utility plant- in-service identified in this report. Facility Plant Categories Wastewater Service Other Plant Treatment General Plant (Equipment, Vehicles, etc.) Transmission Collection (Includes Local Lift Stations, Manholes, and Laterals) It was necessary to categorize the utility facilities into these cost categories so that system-wide capacity costs are identified such that a proper fee can be developed. System-wide capacity costs are those costs incurred to provide capacity needed to serve new growth and development and do not include: i) site improvements and facilities that are planned and designed to provide service for a particular development project and that are necessary for the use and convenience of the occupants or users of the project; and ii) routine and periodic maintenance expenditures, personnel training, and other operating costs. Therefore, the costs of onsite facilities which serve a specific development or customer are not considered as "System-wide" costs that are proportionately allocable to all users. Onsite facilities such as wastewater collection lines, meters and services, local lift stations, and fire hydrants are usually paid for and donated by a developer as part of the City's utility extension program (a contribution of the facilities). The cost of such facilities should not be included in the impact fee calculation. Additionally, assets or utility plant with short service lives that are replaced on a recurring basis are also not included since these assets generally benefit the existing customers of the System. An example of this utility plant would be assets commonly referred to as "general plant" and would include vehicles, equipment, and other related assets. The City provided PRMG with reported utility plant asset information through June 30, 2017 (the most recently completed fiscal year at the time of this analysis) that served as the basis of the functionalization of the existing utility plant-in-service. Appendix A at the end of this report provides the functionalization analysis of the existing utility plant-in-service for the System. The functionalized existing utility plant-in-service as shown in Appendix A represents the original installed cost of such assets (gross book value) when placed into service and represents all assets in service as of June 30, 2017 that were provided by the City and detailed in the utility asset records. This information represents the most current information available relative to the plant- in-service to serve the existing and near-term future customer base of the utility system. The assets represent "installed costs" and have not been restated to account for any fair market value adjustments which would reflect current costs (would essentially assume that assets were 358 2-5 replaced with identical materials). If an asset had been replaced by the City as of June 30, 2017 and is now in service, such assets were considered since they are physically in-service and represent the capital cost actually being incurred by the City to provide service to future development (this also recognized that the asset that was replaced is retired and no longer in service and was assumed to not be included in the fixed asset register provided to PRMG). A summary of the categorization of the existing utility plant-in-service in Appendix A is shown as follows: Summary of Wastewater Utility System Existing Assets (Gross Utility Plant) [1] Function Amount Percent Treatment $71,944,667 37.2% Transmission 39,980,801 20.7% Collection [2] 71,587,418 37.0% General Plant [2] 9,796,187 5.1% Total Gross Utility Plant In Service [3] $193,300,074 100.0% __________ [1] Amounts shown derived from utility asset records as of June 30, 2017 that were provided by the City as shown in Appendix A. [2] These assets are not included in the wastewater impact fees. [3] Construction work-in-progress was not recognized since the projects have not yet been completed and placed into service by the City and the corresponding existing assets, if any, that would be retired or improved were not removed from the fixed asset register. In order to determine the amount of existing wastewater treatment / disposal plant assets with capacity available to meet future growth, it is necessary to estimate the amount of unused capacity in such facilities. Table 2-1 at the end of this section provides an estimate of the unused capacity and the allocated water supply and treatment plant costs available to meet future needs. This estimate for wastewater capacity and the allocation of existing plant to future growth was based on: i) the permitted design capacity of the respective utility plant facilities; ii) the recognition of adjustments to present the facility capacity on an average daily demand / flow basis to be consistent with the assumed level of service requirements (dependable daily capacity); and iii) actual use of such facilities as experienced by the System service area through the Fiscal Year 2017. Based on this analysis, it was estimated that the existing wastewater treatment plant facilities had the following available capacity to meet future needs: (Remainder of page left intentionally left blank) 359 2-6 Summary of Wastewater Plant Capacity Available to Meet Future Demand Wastewater Plant [1] Total Permitted Capacity (ADF - MGD) 8.500 Less Existing Plant Utilization (ADF - MGD) 5.118 Net Available to Meet Future Service Area Needs 3.382 Estimated Percent of Total System Capacity 39.78% __________ MGD = Million Gallons Per Day ADF = Average Daily Flow [1] Amounts derived from Table 2-1. As shown above, it has been estimated that approximately 39.78% in existing wastewater treatment and disposal utility assets is allocable to serve future development. The wastewater treatment / disposal capacity costs in the impact fee calculations represent the average installed costs of such capacity ("buy-in") as well as upgrades to such assets (reflected in the CIP), a portion of which benefit new development. ADDITIONAL CAPITAL INVESTMENT As with any utility, the City is continually in the process of updating and expanding the wastewater facilities to serve increasing demand; upgrade and improve service and reliability; and meet new regulatory requirements. In order to develop an impact fee that is consistent with the capital costs of the System, the cost of the City's capital improvements that are anticipated to meet future needs are included in the proposed wastewater impact fees. The City staff provided the most recent CIP, which outlines a number of capital improvements for the wastewater system as shown in Table 2-2 at the end of this section. Generally, these improvements are for i) expansions of the System to meet new growth; ii) upgrades to existing assets which may benefit both current and future users of the System (e.g., a transmission line upgrade or improvements to increase reliability or comply with new regulatory requirements); and iii) replacement of assets that only benefit current users of the System. Of these three types of costs identified in the CIP, the cost associated with the replacement of assets is not included in the proposed impact fees as these costs are not associated with providing capacity for new development while the cost of system upgrades, which represent an enhanced level of service for all users, and the cost of system expansion that directly benefits new development are included in the proposed fees. Also, as required by Section 7-6-1601(1)(a) of the Code, all of the costs included in the fees have a useful life of at least ten (10) years. Table 2-3 at the end of this section provides a functional summary of all planned wastewater improvements and expansions for the System. Based on the functional categories previously discussed, this step helps to ensure that only system level facilities such as treatment and transmission facilities are included in the impact fee. Based on discussions with City staff and as shown on Table 2-3, approximately $15.8 million of wastewater treatment and disposal capital projects and $33.0 million of wastewater transmission capital improvements have been considered in the determination of the proposed wastewater impact fees. Table 2-4 shows the allocation of functionalized CIP projects between existing users and future growth for the wastewater system. 360 2-7 DESIGN OF WASTEWATER IMPACT FEE As shown on Table 2-5 at the end of this section, the proposed impact fee for the wastewater system is $1,619 per EDU. The costs included in the calculation of the fee reflect the proportionate share of capital costs that meet the demands of future customers as identified in the City’s fixed asset records and CIP. The proposed charge is based on current estimates of capacity costs and is reasonably comparable with those of other Montana utilities. The major assumptions relied upon in the development of the proposed wastewater impact fees are as follows. 1. The existing wastewater treatment facilities have approximately 39.78% of capacity available to serve new growth, based on: i) the permitted capacity of the existing wastewater treatment plant facilities; and ii) estimated average daily flows provided by the City. Therefore, the proposed impact fee reflects the proportionate share of the existing plant at original cost including any improvements that are anticipated to serve new development. Since the wastewater treatment plant has significant capacity available to serve new growth, the City currently does not plan to expand the wastewater treatment plant in the near future. 2. The capital costs identified in the City's CIP are incorporated into the calculation of the proposed impact fees as appropriate on a project-specific basis. Only the costs of those facilities considered to be allocable to growth are included in the fee. For capital expenditures, which are solely for the replacement of existing assets directly benefiting only existing customers or considered as an on-site cost (provide service to a local area such as a development that would normally be constructed and subsequently contributed to the City by a developer), such amounts are not reflected as an appropriate cost to be recovered from the application impact fees. A summary of capital improvement costs considered in the development of the wastewater impact fee is shown in Table 2-4 at the end of this section. 3. For the capital costs identified as transmission system upgrades, which benefit both existing and future users, the total cost of such improvements is recognized in the fee analysis. Since the transmission function capacity is difficult to ascertain except at "build- out" conditions, the total existing assets plus the planned expansions are recognized and divided by total treatment plant capacity, thus estimating an average "buy-in" cost for new users for this component of the System. 4. The level of service for a wastewater EDU is assumed to be 144 gallons per day (gpd) expressed on an average daily flow (ADF) basis based on: i) the residential per capita generation per the Bozeman Wastewater Collection Facilities Plan Update dated May 2015; and ii) the published 2.24 persons per household for the City per the United States Census. 5. For the development of the proposed impact fees, no existing or planned capital facility costs associated with collection facilities have been included in the calculation of the charge. Additionally, capital costs included in the development of the proposed impact fee 361 2-8 were reduced based upon amounts associated with grants received by the City and the anticipated retirement of certain existing assets. 6. In order to promote rational nexus provisions of the payment of the impact fees, a credit for an assumed level of debt (external capital) that is paid by utility rate revenues has been reflected in the determination of the fee. The calculation of the debt service credit is summarized on Table 2-6 at the end of this report. The purpose of the credit is to recognize that new growth will also pay monthly user charges (once such users become an active customer) which have a debt component included in the rates for service that is allocable to the construction of the growth-related projects. As such, it was assumed that a credit to the impact fee would be appropriate. It should be recognized that the impact fees are a pledged revenue for the repayment of debt and that the capacity of the existing facilities for which debt has been issued is essentially at full utilization and therefore fully-funded from existing users. Also the priority of use of the impact fees is to fund future capital improvements and thus limit the issuance of future debt (which also provides a benefit to the level of rates charged for monthly service). Additionally, all funds received from the wastewater impact fees are applied toward wastewater-related capital projects or expansion-related debt service requirements, thus providing rate benefit. As shown on Table 2-5, the analysis utilizes estimated capital costs for the wastewater treatment/transmission system, EDU service requirements, and current fixed asset and plant capacity data for the wastewater system. By designing the wastewater impact fee to recover these costs, an attempt is made to design a fee on a reasonable basis in order to reflect the cost of capacity needed to meet the future growth of the wastewater system. It should be noted that in the event the construction costs, capacity requirements, or utility service area materially change from what is reflected on Table 2-5, the wastewater impact fee may need to be adjusted accordingly. As shown on Table 2-5, the proposed wastewater impact fee is recommended to be $1,584 per EDU. Based on the capital facilities associated with the determination of the charge, the functional breakdown of the components of the rate are as follows: Proposed Wastewater Impact Fee Per EDU [*] Wastewater Treatment Wastewater Transmission Combined Calculated Amount $977.32 $565.57 Administrative Allowance @ 5.0% 48.87 28.28 $1,026.19 $593.85 Recommended Fee Per EDU (Rounded) $1,026.00 $593.00 $1,619.00 Level of Service / Capacity Allocation Per EDU 144 144 144 Cost Per Gallon of Capacity $7.13 $4.12 $11.24 __________ [*] Amounts derived from Table 2-5. 362 2-9 EQUIVALENT DWELLING UNIT DETERMINATION METHODOLOGY The City currently provides wastewater service to residential and non-residential properties of the system. For residential wastewater service, the City charges a wastewater treatment impact fee based on the size of the residential home. For non-residential service, the City charges a wastewater treatment impact fee based on the size of the service meter. No changes to the application methodology are proposed, however, this study updates the demand coefficients or EDUs for each category of wastewater service based on the most recently available information from the City. The existing impact fee for the transmission component is currently charged per acre which does not adequately reflect the demand for wastewater transmission service. Therefore, PRMG recommends that the City apply the transmission component of the wastewater impact fee per EDU. The City provided historical service demands by size of residential homes for the most recent two (2) fiscal years. The average service demands over the period for each category of residential properties were compared to the average demands for the typical residential dwelling unit, which includes residential homes between 1,801 to 2,000 square feet of living area. The following table summarizes the proposed EDUs per residential home based on recent data: Equivalent Residential Units by Square Feet of Living Area for City Wastewater System Lower Limit Upper Limit EDU Factor [1] 0 1,400 0.70 1,401 1,600 0.89 1,601 1,800 0.94 1,801 2,000 1.00 2,001 2,200 1.07 2,201 2,400 1.13 2,401 2,600 1.19 2,601 2,800 1.21 2,801 3,000 1.27 Above 3,000 1.35 __________ [1] Amounts based on historical service demands provided by the City. For non-residential properties, the City applies the wastewater treatment impact fee on a per meter equivalent approach. Under this method, the impact fees for wastewater service are based on rated meter capacity information published by AWWA (e.g., in the M6 manual entitled Water Meters). Based on an analysis of the non-residential service demands when compared to residential service, non-residential demands were 50% greater than the typical residential service. Therefore, the following table summarizes the proposed EDUs per non-residential meter sizes: (Remainder of page left intentionally left blank) 363 2-10 Equivalent Non-residential Units by Meter Size for City Wastewater System Meter Size Rated Capacity (gallons per minute) [1] EDU Factor [2] 3/4" 30 1.50 1" 50 2.50 1-1/2" 100 5.00 2" 160 8.00 3" 300 15.00 __________ [1] Amounts based on water meter data published by AWWA. [2] Amounts calculated by dividing the rated capacity (gallons per minute) for each meter size by the rated capacity for the smallest-sized 3/4" meter beginning at a factor of 1.50 since non-residential demands are approximately 50% greater than the typical residential service. PROPOSED WASTEWATER IMPACT FEE SCHEDULE Based on the proposed application methodology, the following wastewater impact fees are proposed: Proposed Residential Wastewater Impact Fees Square Feet of Living Area Water Reclamation Plant Fee Per Unit Transmission System Fee Per Unit 1400 or Less $718.00 $415.00 1401 to 1600 913.00 528.00 1601 to 1800 964.00 558.00 1801 to 2000 1,026.00 593.00 2001 to 2200 1,098.00 635.00 2201 to 2400 1,159.00 671.00 2401 to 2600 1,221.00 706.00 2601 to 2800 1,241.00 718.00 2801 to 3000 1,303.00 754.00 3001 or More 1,385.00 801.00 Group Quarters Per Person 1,026.00 593.00 Proposed Nonresidential Wastewater Impact Fees Meter Size Water Reclamation Plant Fee Per Meter Transmission System Fee Per Meter 0.75-inch $1,539.00 $890.00 1-inch 2,565.00 1,484.00 1.5-inch 5,130.00 2,969.00 2-inch 8,209.00 4,750.00 3-inch 15,392.00 8,907.00 Above 3-inch Calculated Calculated 364 2-11 This schedule is also contained in Table ES-1 at the beginning of this report. CONCLUSIONS AND RECOMMENDATIONS Based on our evaluation of the City's wastewater impact fees, PRMG offers the following conclusions and recommendations: 1. Pursuant to the analysis discussed herein, PRMG is of the opinion that the proposed wastewater impact fees are reasonable, are based on the requirements of Montana State Law, and reflect the City's capital cost of providing capacity based on the proposed level of service. As such, PRMG recommends that the City consider adjusting the existing wastewater impact fee to $1,619 per EDU. 2. Consistent with the practices of the City, PRMG recommends that the City continue to apply the wastewater treatment portion of the residential impact fees based on the size of the residential home and non-residential impact fees based on the size of the service meter. For the transmission component of the wastewater impact fees, PRMG recommends that the City charge such fees on a consistent basis with the treatment component rather than on a per acre basis. The proposed schedule of wastewater impact fees is shown in Table ES-1 at the beginning of this report. (Remainder of page left intentionally left blank) 365 Line Wastewater No. Description System Existing Permitted Plant Capacity of System (MGD): [1] Wastewater System 1 Bozeman Water Reclamation Facility (WRF) 8.500 2 Total Production/Treatment 8.500 3 Peaking Factor 1.000 4 Adjustment to Reflect Average Daily Flow of Plant Capacity 0.000 5 Existing Plant Capacity of System - Average Daily Flow Basis (MGD) [1] 8.500 6 Average Daily Flow [2] 5.118 7 Remaining Capacity (ADF) 3.382 8 Percent of Total Capacity Allocable to Growth 39.78% Capital Costs of Production/Treatment Facilities: 9 Existing City-Owned Facility Costs [3] $ 71,944,667 10 Additional Costs [4] 15,750,687 11 Less Assumed Retirements [4] (459,430) 12 Less Grant Funds and Other Contributions [5] (15,262,162) 13 Total Capital Costs of Existing Facilities 71,973,762 14 Estimated Amount Allocable to Incremental Growth $ 28,634,074 MGD = Million Gallons Per Day ADF = Average Daily Flow Footnotes on following page. Capacity Available to Serve System Growth Table 2-1 City of Bozeman, Montana Wastewater Impact Fee Study Development of Existing Wastewater Treatment Facility 2-366 12 Capacity Available to Serve System Growth Table 2-1 City of Bozeman, Montana Wastewater Impact Fee Study Development of Existing Wastewater Treatment Facility Footnotes: [1] Reflects ADF capacity of wastewater treatment facilities. [2] Average daily flow data calculated as follows: Wastewater System: Total Wastewater Fiscal Year Flow (MGD) 2013 4.586 2014 5.051 2015 4.892 2016 5.016 2017 5.118 Five-Year Maximum 5.118 [3] Derived from Appendix A, Line 693. Based on summary of utility asset records provided by the City. [4] Derived from Table 2-4, Lines 14. Based on capital improvement program associated with upgrades, renewals, and replacements of the wastewater system. [5] Derived from Appendix A, Line 695. 2-367 13 Table 2-2 City of Bozeman, Montana Wastewater Impact Fee Study Multi-Year Estimated Capital Improvement Program Summary Projected Fiscal Year Ending September 30, Line Project Budgeted Adjusted No. ID Department Description 2018 Adjustments 2018 2019 2020 2021 2022 2023 Unscheduled Total WASTEWATER CAPITAL PROJECTS Wastewater Fund (Renewals, Replacements, and Upgrades) 1 PW04 Engineering Property on Corner of Aspen and Rouse $ 100,000 $ - $ 100,000 $ - $ - $ - $ - $ - $ - $ 100,000 2 WW07 Engineering Annual Wastewater Pipe Replacement Program ‐ Design 22,500 - 22,500 22,500 22,500 22,500 22,500 22,500 - 135,000 3 WW08‐18 Engineering Wastewater Pipe Replacement Program ‐ Construction in 2018 1,000,000 - 1,000,000 - - - - - - 1,000,000 4 WW08‐19 Engineering Wastewater Pipe Replacement Program ‐ Construction in 2019 - - - 1,000,000 - - - - - 1,000,000 5 WW08‐20 Engineering Wastewater Pipe Replacement Program ‐ Construction in 2020 - - - - 1,000,000 - - - - 1,000,000 6 WW08‐21 Engineering Wastewater Pipe Replacement Program ‐ Construction in 2021 - - - - - 1,000,000 - - - 1,000,000 7 WW08‐22 Engineering Wastewater Pipe Replacement Program ‐ Construction in 2022 - - - - - 1,000,000 - - 1,000,000 8 WW08‐23 Engineering Wastewater Pipe Replacement Program ‐ Construction in 2023 - - - - - - - 1,000,000 - 1,000,000 9 WW27 Engineering Annual Watershed Study and Stream Modeling 60,000 - 60,000 60,000 60,000 60,000 60,000 60,000 - 360,000 10 GF227 Finance ERP Replacement "Sungard Replacement/Upgrade" - - - - - - - - 333,333 333,333 12 PW05 Pubworks Admin Public Works Shops Master Plan - - - 20,000 - - - - - 20,000 13 PW06 Pubworks Admin Public Works Shops Facility Construction - - - - 670,000 - - - - 670,000 15 WW54 Wastewater Op Replace #1783 ‐ 1995 Ford Dump Truck - - - - 95,000 - - - - 95,000 16 WW65 Wastewater Op Digital Universal Camera (DUC) 70,000 - 70,000 - - - - - - 70,000 17 WW86 Wastewater Op Wheeled Excavator - - - - - - - - 151,000 151,000 18 WW86 Wastewater Op Steerable Sewer TV Tractor - - - 25,000 - - - - - 25,000 19 WW87 Wastewater Op Sewer Flow Meters - - - 35,000 - - - - - 35,000 20 WW39 WRF Resurface and Repaint Clarifiers 90,000 - 90,000 320,000 - - - - - 410,000 22 WW45 WRF Final and Secondary Clarifier Launder Covers 200,000 - 200,000 - - - - - - 200,000 23 WW49 WRF Roll‐Off Storage Building Construction and Possible 2nd Screw Press Enclosure 600,000 - 600,000 1,500,000 - - - - - 2,100,000 24 WW50 WRF Refrigerated Automatic Sampler 10,000 - 10,000 - - - - - - 10,000 25 WW53 WRF Positive Displacement Lobe Pumps 50,000 - 50,000 - - - - - - 50,000 26 WW58 WRF Chip Seal and Topcoat WRF Asphalt - - - 55,000 - - - - - 55,000 27 WW66 WRF Odor Control for Old Pretreatment Building 40,000 - 40,000 - - - - - - 40,000 28 WW69 WRF WRF Facility R&R 50,000 - 50,000 75,000 100,000 100,000 100,000 100,000 - 525,000 29 WW70 WRF WRF Facility Engineering and Optimization 50,000 - 50,000 50,000 50,000 50,000 50,000 50,000 - 300,000 30 WW71 WRF WRF Facility Master Plan Update 250,000 - 250,000 - - - - - - 250,000 31 WW76 WRF Third Pretreatment Screen - - - - - 500,000 - - - 500,000 32 WW78 WRF Server Replacement at WRF (Wrfctrlbak) - - - - - - 10,000 - - 10,000 34 WW80 WRF Lagoon Valve Replacement in Lift #3 50,000 - 50,000 - - - - - - 50,000 35 WW81 WRF Membrane Roof Replacement on Old Digester Building (Dig 1 & 2) 60,000 - 60,000 - - - - - - 60,000 36 WW83 WRF Ufat Gravity Thickener Drive and Arms Replacement - - - - - - 400,000 - - 400,000 37 WW84 WRF Server Replacement at WRF (Wrfctrlpri) - - - - - - 10,000 - - 10,000 38 WW85 WRF WRF Process Upgrades to Improve Nutrient Recovery - - - - - - - - 12,000,000 12,000,000 39 WW88 WRF Re-Tube Boiler - - - - 25,000 - - - - 25,000 40 WW89 WRF HVAC Heat Loop Optimization - - - 250,000 - - - - - 250,000 41 Subtotal - Wastewater Fund (Renewals, Replacements, and Upgrades) $ 2,702,500 $ - $ 2,702,500 $ 3,412,500 $ 2,022,500 $ 1,732,500 $ 1,652,500 $ 1,232,500 $ 12,484,333 $ 25,239,333 Wastewater Impact Fees (Growth Projects) 42 WWIF11 WW Impact Fee Front Street Interceptor $ - $ - $ - $ 2,185,000 $ - $ - $ - $ - $ - $ 2,185,000 43 WWIF20 WW Impact Fee N Frontage Rd Interceptor - - - - - - - 5,290,000 - 5,290,000 44 WWIF22 WW Impact Fee Davis Fowler Interceptor - - - - - - - - 778,035 778,035 45 WWIF24 WW Impact Fee Davis Lane (Lift Station) - - - 5,800,000 - - - - - 5,800,000 46 WWIF27 WW Impact Fee South University District/Cattail Creek Basin - S 15th Ave to Willow Way to W Lincoln St 795,000 - 795,000 - - - - - - 795,000 47 WWIF31 WW Impact Fee Davis Ln Lift Station, Interceptor, and Force Main 645,000 - 645,000 - - - - - - 645,000 48 WWIF32 WW Impact Fee Hidden Valley (Lift Station) - - - - - - - - 5,190,000 5,190,000 Table 2-2 City of Bozeman, Montana Wastewater Impact Fee Study Multi-Year Estimated Capital Improvement Program Summary Projected Fiscal Year Ending September 30, Line Project Budgeted Adjusted No. ID Department Description 2018 Adjustments 2018 2019 2020 2021 2022 2023 Unscheduled Total 55 WWIF39 WW Impact Fee Renova Street Sanitary Sewer Main Upgrade - - - - - - - - 16,000 16,000 56 WWIF40 WW Impact Fee Front Street Interceptor Debt Service (WWIF11) - - - - 139,497 139,497 139,497 139,497 139,497 697,485 57 WWIF41 WW Impact Fee Norton East Ranch Outfall Diversion Debt Service (WWIF38) - - - - - 211,960 211,960 211,960 211,960 847,840 58 Subtotal - Wastewater Impact Fees (Growth Projects) $ 1,440,000 $ - $ 1,440,000 $ 8,625,000 $ 6,424,797 $ 721,757 $ 721,757 $ 6,011,757 $ 7,005,792 $ 30,950,860 59 TOTAL WASTEWATER CAPITAL PROJECTS $ 4,142,500 $ - $ 4,142,500 $ 12,037,500 $ 8,447,297 $ 2,454,257 $ 2,374,257 $ 7,244,257 $ 19,490,125 $ 56,190,193 2-369 15 Adjustments to Adjustments to Adjustments to Remove Project Remove General- Remove Debt Costs Considered Net Amount Line Project Estimated Total Related Project Service 100% Allocable to For Future Allocation No. ID Project Description Capital Cost [1] Costs [2] Placeholders [3] Existing Users Expenditures Reference Treatment Transmission Collection WASTEWATER CAPITAL IMPROVEMENT PROGRAM Wastewater Fund (Renewals, Replacements, and Upgrades) 1 PW04 Property on Corner of Aspen and Rouse $100,000 $0 $0 $0 $100,000 Collection $0 $0 $100,000 2 WW07 Annual Wastewater Pipe Replacement Program ‐ Design 135,000 0 0 0 135,000 Transmission 0 135,000 0 3 WW08‐18 Wastewater Pipe Replacement Program ‐ Construction in 2018 1,000,000 0 0 0 1,000,000 Transmission 0 1,000,000 0 4 WW08‐19 Wastewater Pipe Replacement Program ‐ Construction in 2019 1,000,000 0 0 0 1,000,000 Transmission 0 1,000,000 0 5 WW08‐20 Wastewater Pipe Replacement Program ‐ Construction in 2020 1,000,000 0 0 0 1,000,000 Transmission 0 1,000,000 0 6 WW08‐21 Wastewater Pipe Replacement Program ‐ Construction in 2021 1,000,000 0 0 0 1,000,000 Transmission 0 1,000,000 0 7 WW08‐22 Wastewater Pipe Replacement Program ‐ Construction in 2022 1,000,000 0 0 0 1,000,000 Transmission 0 1,000,000 0 8 WW08‐23 Wastewater Pipe Replacement Program ‐ Construction in 2023 1,000,000 0 0 0 1,000,000 Transmission 0 1,000,000 0 9 WW27 Annual Watershed Study and Stream Modeling 360,000 (360,000) 0 0 0 N/A 0 0 0 10 GF227 ERP Replacement "Sungard Replacement/Upgrade" 333,333 0 0 0 333,333 S-Assets 130,687 72,625 130,021 11 PW05 Public Works Shops Master Plan 20,000 0 0 0 20,000 Collection 0 0 20,000 12 PW06 Public Works Shops Facility Construction 670,000 0 0 0 670,000 Collection 0 0 670,000 13 WW54 Replace #1783 ‐ 1995 Ford Dump Truck 95,000 (95,000) 0 0 0 N/A 0 0 0 14 WW65 Digital Universal Camera (DUC) 70,000 (70,000) 0 0 0 N/A 0 0 0 15 WW86 Wheeled Excavator 151,000 (151,000) 0 0 0 N/A 0 0 0 16 WW86 Steerable Sewer TV Tractor 25,000 (25,000) 0 0 0 N/A 0 0 0 17 WW87 Sewer Flow Meters 35,000 (35,000) 0 0 0 Collection 0 0 0 18 WW39 Resurface and Repaint Clarifiers 410,000 0 0 (410,000) 0 N/A 0 0 0 19 WW45 Final and Secondary Clarifier Launder Covers 200,000 0 0 0 200,000 Treatment 200,000 0 0 20 WW49 Roll‐Off Storage Building Construction and Possible 2nd Screw Press Enclosure 2,100,000 0 0 0 2,100,000 Treatment 2,100,000 0 0 21 WW50 Refrigerated Automatic Sampler 10,000 0 0 0 10,000 Treatment 10,000 0 0 22 WW53 Positive Displacement Lobe Pumps 50,000 0 0 0 50,000 Treatment 50,000 0 0 23 WW58 Chip Seal and Topcoat WRF Asphalt 55,000 0 0 (55,000) 0 N/A 0 0 0 24 WW66 Odor Control for Old Pretreatment Building 40,000 (40,000) 0 0 0 N/A 0 0 0 25 WW69 WRF Facility R&R 525,000 0 0 (525,000) 0 N/A 0 0 0 26 WW70 WRF Facility Engineering and Optimization 300,000 (300,000) 0 0 0 N/A 0 0 0 27 WW71 WRF Facility Master Plan Update 250,000 (250,000) 0 0 0 N/A 0 0 0 28 WW76 Third Pretreatment Screen 500,000 0 0 0 500,000 Treatment 500,000 0 0 29 WW78 Server Replacement at WRF (Wrfctrlbak) 10,000 (10,000) 0 0 0 N/A 0 0 0 30 WW80 Lagoon Valve Replacement in Lift #3 50,000 0 0 0 50,000 Treatment 50,000 0 0 31 WW81 Membrane Roof Replacement on Old Digester Building (Dig 1 & 2) 60,000 0 0 0 60,000 Treatment 60,000 0 0 32 WW83 Ufat Gravity Thickener Drive and Arms Replacement 400,000 0 0 0 400,000 Treatment 400,000 0 0 33 WW84 Server Replacement at WRF (Wrfctrlpri) 10,000 (10,000) 0 0 0 N/A 0 0 0 34 WW85 WRF Process Upgrades to Improve Nutrient Recovery 12,000,000 0 0 0 12,000,000 Treatment 12,000,000 0 0 35 WW88 Re-Tube Boiler 25,000 (25,000) 0 0 0 N/A 0 0 0 36 WW89 HVAC Heat Loop Optimization 250,000 0 0 0 250,000 Treatment 250,000 0 0 37 Subtotal - Wastewater Fund (Renewals, Replacements, and Upgrades) $25,239,333 ($1,371,000) $0 ($990,000) $22,878,333 $15,750,687 $6,207,625 $920,021 Functional Category Table 2-3 City of Bozeman, Montana Wastewater Impact Fee Study Summary of Capital Improvement Program By Plant Function 2-16 370 Adjustments to Adjustments to Adjustments to Remove Project Remove General- Remove Debt Costs Considered Net Amount Line Project Estimated Total Related Project Service 100% Allocable to For Future Allocation No. ID Project Description Capital Cost [1] Costs [2] Placeholders [3] Existing Users Expenditures Reference Treatment Transmission Collection Functional Category Table 2-3 City of Bozeman, Montana Wastewater Impact Fee Study Summary of Capital Improvement Program By Plant Function Wastewater Impact Fees (Growth Projects) 38 WWIF11 Front Street Interceptor $2,185,000 $0 $0 $0 $2,185,000 Transmission $0 $2,185,000 $0 39 WWIF20 N Frontage Rd Interceptor 5,290,000 0 0 0 5,290,000 Transmission 0 5,290,000 0 40 WWIF22 Davis Fowler Interceptor 778,035 0 0 0 778,035 Transmission 0 778,035 0 41 WWIF24 Davis Lane (Lift Station) 5,800,000 0 0 0 5,800,000 Transmission 0 5,800,000 0 42 WWIF27 South University District/Cattail Creek Basin - S 15th Ave to Willow Way to W Lincoln St 795,000 0 0 0 795,000 Collection 0 0 795,000 43 WWIF31 Davis Ln Lift Station, Interceptor, and Force Main 645,000 0 0 0 645,000 Transmission 0 645,000 0 44 WWIF32 Hidden Valley (Lift Station) 5,190,000 0 0 0 5,190,000 Transmission 0 5,190,000 0 45 WWIF33 Davis Ln Lift Station Debt Service (WWIF24) 1,851,500 0 (1,851,500) 0 0 Transmission 0 0 0 46 WWIF34 Annie Street Sanitary Sewer Upgrade 300,000 0 0 0 300,000 Transmission 0 300,000 0 47 WWIF35 Babcock Sanitary Sewer Upgrade 245,000 0 0 0 245,000 Transmission 0 245,000 0 48 WWIF36 Baxter Creek Basin- Cottonwood Road 18" Sanitary Sewer Extensions 640,000 0 0 0 640,000 Transmission 0 640,000 0 49 WWIF37 Hunters Way Sewer Capacity Upgrade 350,000 0 0 0 350,000 Transmission 0 350,000 0 50 WWIF38 Norton East Ranch Outfall Diversion & Interceptor 5,320,000 0 0 0 5,320,000 Transmission 0 5,320,000 0 51 WWIF39 Renova Street Sanitary Sewer Main Upgrade 16,000 0 0 0 16,000 Transmission 0 16,000 0 52 WWIF40 Front Street Interceptor Debt Service (WWIF11) 697,485 0 (697,485) 0 0 Transmission 0 0 0 53 WWIF41 Norton East Ranch Outfall Diversion Debt Service (WWIF38) 847,840 0 (847,840) 0 0 Transmission 0 0 0 54 Subtotal - Wastewater Impact Fees (Growth Projects) $30,950,860 $0 ($3,396,825) $0 $27,554,035 $0 $26,759,035 $795,000 55 TOTAL WASTEWATER CAPITAL IMPROVEMENT PROGRAM $56,190,193 ($1,371,000) ($3,396,825) ($990,000) $50,432,368 $15,750,687 $32,966,660 $1,715,021 Footnotes: [1] Amounts reflect total cost as contained in the multi-year capital improvement program provided by the City. [2] Adjustments to exclude vehicles, equipment, and items that might be classified as operating expenses. [3] The project costs anticipated to be financed with debt are reflected under other project ID's. 2-17 371 Table 2-4 City of Bozeman, Montana Wastewater Impact Fee Study Summary of Capital Improvement Program Recognized in Wastewater System Impact Fees Assumed Adjusted Original Estimated Percent to Line Project Project Project In-Service Original New Facilities / Recognize No. ID Project Description Cost [1] Status Date [2] Cost [3] Upgrades [5] Expansion Future / Direct for Expansion WASTEWATER TREATMENT PROJECTS Wastewater Fund (Renewals, Replacements, and Upgrades) 1 GF227 ERP Replacement "Sungard Replacement/Upgrade" $130,687 Upgrade 1999 $66,031 $130,687 $0 $0 0.00% 2 WW45 Final and Secondary Clarifier Launder Covers 200,000 Upgrade N/A 0 200,000 0 0 0.00% 3 WW49 Roll‐Off Storage Building Construction and Possible 2nd Screw Press Enclosure 2,100,000 Upgrade N/A 0 2,100,000 0 0 0.00% 4 WW50 Refrigerated Automatic Sampler 10,000 Upgrade N/A 0 10,000 0 0 0.00% 5 WW53 Positive Displacement Lobe Pumps 50,000 Replacement 2002 27,851 50,000 0 0 0.00% 6 WW76 Third Pretreatment Screen 500,000 Reliability N/A 0 500,000 0 0 0.00% 7 WW80 Lagoon Valve Replacement in Lift #3 50,000 Upgrade 2003 28,771 50,000 0 0 0.00% 8 WW81 Membrane Roof Replacement on Old Digester Building (Dig 1 & 2) 60,000 Replacement 2007 39,320 60,000 0 0 0.00% 9 WW83 Ufat Gravity Thickener Drive and Arms Replacement 400,000 Replacement 1985 128,210 400,000 0 0 0.00% 10 WW85 WRF Process Upgrades to Improve Nutrient Recovery 12,000,000 Upgrade N/A 0 12,000,000 0 0 0.00% 11 WW89 HVAC Heat Loop Optimization 250,000 Upgrade 2008 169,247 250,000 0 0 0.00% 12 Subtotal - Wastewater Fund (Renewals, Replacements, and Upgrades) $15,750,687 $459,430 $15,750,687 $0 $0 0.00% Wastewater Impact Fees (Growth Projects) 13 Subtotal - Wastewater Impact Fees (Growth Projects) $0 $0 $0 $0 $0 0.00% 14 Total Wastewater Treatment Projects $15,750,687 $459,430 $15,750,687 $0 $0 0.00% WASTEWATER TRANSMISSION PROJECTS Wastewater Fund (Renewals, Replacements, and Upgrades) 15 WW07 Annual Wastewater Pipe Replacement Program ‐ Design $135,000 Replacement 1948 $12,996 $135,000 $0 $0 0.00% 16 WW08‐18 Wastewater Pipe Replacement Program ‐ Construction in 2018 1,000,000 Replacement 1948 96,269 1,000,000 0 0 0.00% 17 WW08‐19 Wastewater Pipe Replacement Program ‐ Construction in 2019 1,000,000 Replacement 1948 96,269 1,000,000 0 0 0.00% 18 WW08‐20 Wastewater Pipe Replacement Program ‐ Construction in 2020 1,000,000 Replacement 1948 96,269 1,000,000 0 0 0.00% 19 WW08‐21 Wastewater Pipe Replacement Program ‐ Construction in 2021 1,000,000 Replacement 1948 96,269 1,000,000 0 0 0.00% 20 WW08‐22 Wastewater Pipe Replacement Program ‐ Construction in 2022 1,000,000 Replacement 1948 96,269 1,000,000 0 0 0.00% 21 WW08‐23 Wastewater Pipe Replacement Program ‐ Construction in 2023 1,000,000 Replacement 1948 96,269 1,000,000 0 0 0.00% 22 GF227 ERP Replacement "Sungard Replacement/Upgrade" 72,625 Upgrade 1999 36,695 72,625 0 0 0.00% 23 Subtotal - Wastewater Fund (Renewals, Replacements, and Upgrades) $6,207,625 $627,304 $6,207,625 $0 $0 0.00% Wastewater Impact Fees (Growth Projects) 24 WWIF11 Front Street Interceptor $2,185,000 New N/A N/A $2,185,000 $0 $0 0.00% 25 WWIF20 N Frontage Rd Interceptor 5,290,000 Upgrade 1969 1,007,918 5,290,000 0 0 0.00% 26 WWIF22 Davis Fowler Interceptor 778,035 Upgrade 2006 493,564 778,035 0 0 0.00% 27 WWIF24 Davis Lane (Lift Station) 5,800,000 New N/A N/A 5,800,000 0 0 0.00% 28 WWIF31 Davis Ln Lift Station, Interceptor, and Force Main 645,000 New N/A N/A 645,000 0 0 0.00% 29 WWIF32 Hidden Valley (Lift Station) 5,190,000 New N/A N/A 5,190,000 0 0 0.00% 30 WWIF34 Annie Street Sanitary Sewer Upgrade 300,000 Upgrade 2007 196,600 300,000 0 0 0.00% 31 WWIF35 Babcock Sanitary Sewer Upgrade 245,000 Upgrade 2007 160,557 245,000 0 0 0.00% 32 WWIF36 Baxter Creek Basin- Cottonwood Road 18" Sanitary Sewer Extensions 640,000 New N/A N/A 640,000 0 0 0.00% 33 WWIF37 Hunters Way Sewer Capacity Upgrade 350,000 Upgrade 1994 150,312 350,000 0 0 0.00% Amount Recognized [4] 2-372 18 Table 2-4 City of Bozeman, Montana Wastewater Impact Fee Study Summary of Capital Improvement Program Recognized in Wastewater System Impact Fees Assumed Adjusted Original Estimated Percent to Line Project Project Project In-Service Original New Facilities / Recognize No. ID Project Description Cost [1] Status Date [2] Cost [3] Upgrades [5] Expansion Future / Direct for Expansion Amount Recognized [4] 34 WWIF38 Norton East Ranch Outfall Diversion & Interceptor 5,320,000 New N/A N/A 5,320,000 0 0 0.00% 35 WWIF39 Renova Street Sanitary Sewer Main Upgrade 16,000 Upgrade 1998 7,826 16,000 0 0 0.00% 36 Subtotal - Wastewater Impact Fees (Growth Projects) $26,759,035 $2,016,776 $26,759,035 $0 $0 0.00% 37 Total Wastewater Transmission Projects $32,966,660 $2,644,081 $32,966,660 $0 $0 0.00% 38 TOTAL WASTEWATER PROJECTS $48,717,347 $3,103,511 $48,717,347 $0 $0 0.00% Footnotes on following page. 2-373 19 Footnotes: [1] [2] Original in-service date is based on discussions with City staff regarding the approximate age of assets being upgraded or replaced. [3] Amount shown was determined by discounting the projected (replacement) cost by an inflationary factor as measured by the Engineering News-Record (ENR) Construction Cost Index applied to the estimated number of years in service. [4] For any replacement projects recognized in fee, amount derived by subtracting the estimated original cost from the new project cost (net asset addition). [5] Represents asset additions to be installed by the City that will upgrade and improve facilities. Such assets do not represent a replacement. Note: With respect to capital projects associated with plant upgrades, the following were assumed: New = Project designated for capacity expansion only. Upgrade = Project designated to improve existing capacity facilities. Replacement = Project which removes original asset from service but necessary for providing service to City customers. Relocate = Project which removes original asset from service, and usually replaces it with an asset designated for capacity expansion. Redundancy = Project which provides redundancy to existing capacity and not an increase in capacity to serve new growth. Future = Reflects project which extends beyond the planning horizon in this report. System = Project that benefits existing, expansion and future customers. Direct = Reflects projects which directly relate to specific customer base and not System cost. Reliability = Project which provides additional reliability to existing capacity and not an increase in capacity to serve new growth. Table 2-4 City of Bozeman, Montana Wastewater Impact Fee Study Summary of Capital Improvement Program Recognized in Wastewater System Impact Fees Amounts shown are derived from Table 2-3 and do not include any capital expenditures classified as distribution-related or collection-related. 2-374 20 Table 2-5 City of Bozeman, Montana Wastewater Impact Fee Study Development of Wastewater System Impact Fee Line No. Description Amount Total Estimated Cost of Existing Wastewater Treatment/Disposal Facilities: 1 Existing Facilities [1] $ 71,944,667 2 Additional Costs Capitalized to Plant in Service [2] 15,750,687 3 Less Anticipated Retirements [3] (459,430) 4 Less Grant Funds and Other Contributions [4] (15,262,162) 5 Subtotal Wastewater Treatment/Disposal Facilities $ 71,973,762 6 Existing Nominal Plant Capacity (MGD) (Three-Month Average Daily Flow) [5] 8.500 7 Existing Plant Capacity (MGD) (Average Daily Flow) [5] 8.500 8 EDU Factor - GPD 144 9 Estimated EDUs to be Served By Existing Facilities 59,028 10 Percent Remaining Capacity of Existing Facilities [6] 39.78% 11 Allocation of Existing Facilities to Incremental Growth $ 28,634,074 18 Rate per EDU Allocable to Wastewater Treatment/Disposal Facilities [10] $ 1,219.32 19 Less Debt Service Credit (242.00) 20 Adjusted Rate per EDU Allocable to Wastewater Treatment / Disposal Facilities $ 977.32 21 Administrative Allowance @ 5.0% $ 48.87 22 Rate per EDU Associated with Existing Facilities with Administrative Allowance $ 1,026.19 23 Rounded Rate per EDU Associated with Existing Facilities with Administrative Allowance $ 1,026.00 24 Cost per Gallon Associated with Existing Facilities Without Administrative Allowance $ 8.47 25 Cost per Gallon Associated with Existing Facilities With Administrative Allowance $ 8.89 26 Cost per Gallon Associated with Existing Facilities Without Administrative Allowance Less Debt Service Credit $ 6.79 27 Cost per Gallon Associated with Existing Facilities With Administrative Allowance Less Debt Service Credit $ 7.13 Major Transmission System: [7] 28 Existing Facilities [8] $ 39,980,801 29 Additional Costs Capitalized to Plant in Service [9] 32,966,660 30 Less Anticipated Retirements [10] (2,644,081) 31 Less Receipt of Grant Funds and Other Contributions [4] (35,856,343) 32 Total Major Transmission Facility Costs $ 34,447,038 33 Estimated Plant Capacity (MGD) (Average Daily Flow) [11] 8.500 34 EDU Factor - GPD 144 35 Estimated ERCs served by Transmission Facilities [12] 59,028 36 Rate per EDU of Major Transmission Facilities $ 583.57 37 Less Debt Service Credit (18.00) 38 Adjusted Rate per EDU Allocable to Major Transmission Facilities $ 565.57 39 Administrative Fee @ 5.0% $ 28.28 40 Rate per EDU Associated with Major Transmission Facilities with Administrative Allowance $ 593.85 41 Rounded Rate per EDU Associated with Major Transmission Facilities with Administrative Allowance $ 593.00 42 Cost per Gallon of Major Transmission Facilities Without Administrative Allowance $ 4.05 43 Cost per Gallon of Major Transmission Facilities With Administrative Allowance $ 4.26 44 Cost per Gallon Associated with Existing Facilities Without Administrative Allowance Less Debt Service Credit $ 3.93 45 Cost per Gallon Associated with Existing Facilities With Administrative Allowance Less Debt Service Credit $ 4.12 46 Combined Cost per Gallon Without Administrative Allowance $ 12.52 47 Combined Cost per Gallon With Administrative Allowance $ 13.15 48 Combined Cost per Gallon Without Administrative Allowance Less Debt Service Credit $ 10.71 49 Combined Cost per Gallon With Administrative Allowance Less Debt Service Credit $ 11.24 50 Combined Rate per EDU $ 1,619.00 MGD = Million-Gallons-Per-Day EDU = Equivalent Dwelling Unit GPD = Gallons Per Day Footnotes on following page. 2-375 21 Footnotes: [1] Amount reflects estimated City-owned wastewater treatment and effluent disposal assets currently in service based on utility asset records provided by the City. Amounts derived from Appendix A, Line 693. [2] Amount shown derived from Table 2-4, Line 14; reflects net recognized additions to the wastewater treatment and effluent disposal facilities where applicable. [3] Amount derived from Table 2-4, Line 14 and reflects estimated treatment utility asset retirements due to imposition of the capital improvement plan of the City's utility system. [4] Appendix A, Line 695 and Table 2-3 show adjustments for capital costs funded from contributed capital. Such costs were not included in the impact fee calculations. [5] Amount shown derived from Table 2-1, Line 5. [6] Amount shown derived from Table 2-1, Line 8. [7] Amounts do not include the estimated costs of retail on-site capital expenditures such as manholes, local lift stations, service laterals, and on-site (local) collection utility plant facilities or general plant assets (vehicles, equipment, etc.) or general transmission lines; such costs are: i) generally provided by the developer or owners of property which specifically benefit from such facilities; or ii) funded by a separate and distinct fee (e.g., wastewater tap charge). [8] Amount reflects cost of wastewater transmission and master pumping station utility plant in service based on utility asset records provided by the City. Amounts derived from Appendix A, Line 693. [9] Amount shown derived from Table 2-4, Line 37; reflects net recognized additions to the wastewater transmission facilities where applicable. [10] Amount derived from Table 2-4, Line 37 and reflects estimated transmission utility asset retirements due to imposition of the capital improvement plan of the City's utility system. [11] Reflects total estimated plant capacity for the forecast period for the wastewater service area based on capacity planning estimates. Amount calculated as follows: Amount 8.500 0.000 8.500 Existing Capacity (MGD-ADF) Capacity to Be Added During Forecast Period: FY 2018 - 2023 (MGD-ADF) Total Projected Capacity Needs Table 2-5 City of Bozeman, Montana Wastewater Impact Fee Study Development of Wastewater System Impact Fee 2-22 376 Line Fiscal Year No. 2017 1 Total Outstanding Debt Allocable to Wastewater System [1] $ 17,856,000 2 Total Gross Wastewater Plant in Service [2] $ 193,300,074 3 Less Contributed and Grant-Funded Assets (122,528,799) 4 Net Gross Wastewater Plant in Service $ 70,771,275 Existing Utility Plant Asset Allocation: Treatment and Disposal 5 Reported Functional Assets [2] $ 71,944,667 6 Less Contributed and Grant-Funded Functional Assets [2] (15,262,162) 7 Net Reported Functional Assets [2] $ 56,682,505 8 Percent of Net Gross Wastewater Plant in Service 80.09% Transmission 9 Reported Functional Assets [2] $ 39,980,801 10 Less Contributed and Grant-Funded Functional Assets [2] (35,856,343) 11 Net Reported Functional Assets [2] $ 4,124,459 12 Percent of Net Gross Wastewater Plant in Service 5.83% Allocated Debt Associated with Function: 13 Treatment and Disposal $ 14,301,322 14 Transmission 1,040,625 15 Total $ 15,341,947 16 Estimated Annual Average EDUs [3] 59,028 17 Rounded Debt Service Credit Expressed Per EDU (@ 144 gallons per day per EDU) $260 18 Debt Service Credit Per EDU - Treatment and Disposal Component $242 19 Debt Service Credit Per EDU - Transmission Component 18 [1] Amount derived from Page 74 of City's Comprehensive Annual Financial Report for the Fiscal Year Ended June 30, 2017. [2] Amounts derived from Appendix A. [3] Based on relationship of total capacity of existing service area and the level of service assumed for a wastewater system EDU. Table 2-6 City of Bozeman, Montana Water Impact Fee Study Calculation of Debt Service Credit - Wastewater System Footnotes: 2-377 23 AAPPPPEENNDDIIXX AA CCLLAASSSSIIFFIIC CAATTIIOONN OOFF EEXXIISSTTIINNG G WWAASSTTEEWWAATTE ERR UUTTIILLIITT YY SSYYSSTTEEMM AASSSSEETTSS 378 Page 1 of 14 Line Asset Acquired Asset Adj. General No. Description ID Type Location Acquired Date Cost Adjustments [2] Acq. Amt. Treatment Trans. Collection Plant Wastewater Utility Assets as of June 30, 2017 [1] 1 Roller 11101 M&E Water Operations PURCHASED 7/1/1998 $ 4,395 $ - $ 4,395 $ - $ - $ - $ 4,395 2 Generator On Truck#1118 12141 M&E Laurel Glen PURCHASED 7/1/1998 3,612 - 3,612 - - - 3,612 3 Compactor 13131 M&E Water Operations PURCHASED 7/1/1998 2,938 - 2,938 - - - 2,938 4 Air Compressor 15881 M&E Water Operations PURCHASED 7/1/1998 3,495 - 3,495 - - - 3,495 5 Trench Box 18051 M&E Water Operations PURCHASED 7/1/1998 5,335 - 5,335 - - - 5,335 6 Prof Building Remodel Srvcs Thru 3/25/16-Mar Expds 262058 BLD Professional Building PURCHASED 3/25/2016 5,281 - 5,281 - - - 5,281 7 Prof Building Remodel Srvcs Thru 4/05/16-Apr Expds 262060 BLD Professional Building PURCHASED 4/5/2016 736 - 736 - - - 736 8 Prof Building Remodel Srvcs -May Expds 262064 BLD Professional Building PURCHASED 5/13/2016 38,560 - 38,560 - - - 38,560 9 Prof Building Remodel Srvcs -June Expds Fy16 262066 BLD Professional Building PURCHASED 6/25/2016 33,651 - 33,651 - - - 33,651 10 Prof Building Remodel Srvcs:Retainage:Fy16 262067 BLD Professional Building PURCHASED 6/30/2016 4,930 - 4,930 - - - 4,930 11 Prof Building Remodel Srvcs -Oct Expds Fy17 262071 BLD Professional Building PURCHASED 10/1/2016 1,799 - 1,799 - - - 1,799 12 Prof Bldg Upgrade Phase 1 262075 BLD Professional Building PURCHASED 1/1/2017 115 - 115 - - - 115 13 City Shops Paving Project:August Expds 29213 BLD City Shops PURCHASED 8/31/2016 71,931 - 71,931 - - - 71,931 14 City Shops Paving Project:September Expds 29217 BLD City Shops PURCHASED 9/1/2016 7,155 - 7,155 - - - 7,155 15 Burrup Plan Review Proj 30699 BLD Wastewater Operation PURCHASED 4/25/2016 315 - 315 - - - 315 16 Burrup Plan Review Proj-May Expds 306910 BLD Wastewater Operation PURCHASED 5/12/2016 2,250 - 2,250 - - - 2,250 17 Burrup Plan Review Proj-June Expds 306911 BLD Wastewater Operation PURCHASED 6/30/2016 3,257 - 3,257 - - - 3,257 18 Burrup Lift Station Imp Proj:July Expds Fy17 306912 BLD Wastewater Operation PURCHASED 7/31/2016 94,725 - 94,725 - 94,725 - - 19 Burrup Lift Station Imp Proj:Sept Expds Fy17 306913 BLD Wastewater Operation PURCHASED 9/1/2016 1,141 - 1,141 - 1,141 - - 20 Pole Bldg-Water/Sewer/Streets(Heater):March Expd'S 32626 BLD City Shops-Lower Yard PURCHASED 3/18/2010 6,216 - 6,216 - - - 6,216 21 Pole Bldg-Water/Sewer/Streets(Heater):May Expd'S 32628 BLD City Shops-Lower Yard PURCHASED 5/1/2010 3,000 - 3,000 - - - 3,000 22 Pole Bldg-Water/Sewer/Streets(Heater):July Expd'S 326210 BLD City Shops-Lower Yard PURCHASED 7/27/2010 2,821 - 2,821 - - - 2,821 23 New Shops Bldg:Arch Svcs-Lower Yards 3/1-4/30 34421 BLD City Shops-Lower Yard PURCHASED 5/7/2008 6,000 - 6,000 - - - 6,000 24 New Shops Bldg:Arch Svcs 1/1-5/31/08 34423 BLD City Shops-Lower Yard PURCHASED 6/2/2008 160 - 160 - - - 160 25 New Shops Bldg:Arch Svcs-Lower Yards 5/1-6/30/08 34425 BLD City Shops-Lower Yard PURCHASED 6/30/2008 16,782 - 16,782 - - - 16,782 26 New Shops Bldg:Arch Svcs 1/1-6/30/08 34427 BLD City Shops-Lower Yard PURCHASED 6/30/2008 620 - 620 - - - 620 27 New Shops Bldg:Topo Mapping & Civil-Imp Plans 8/2 34429 BLD City Shops-Lower Yard PURCHASED 8/11/2008 1,542 - 1,542 - - - 1,542 28 New Shops Bldg:Topography Work 344211 BLD City Shops-Lower Yard PURCHASED 9/12/2008 2,444 - 2,444 - - - 2,444 29 Shops Remodel:Arch Svcs Thru 4/30/11-April Expds 344215 BLD City Shops-Lower Yard PURCHASED 4/30/2011 2,800 - 2,800 - - - 2,800 30 New Shops Bldg:Plan Check Fees & Bid Request-May 344220 BLD City Shops-Lower Yard PURCHASED 5/15/2011 148 - 148 - - - 148 31 Shops Remodel:Arch Svcs Thru 6/30/11-June Expds 344225 BLD City Shops-Lower Yard PURCHASED 6/30/2011 1,006 - 1,006 - - - 1,006 32 New Shops Bldg:Walker Const-Lwr Yards Pmt#1-July 344230 BLD City Shops-Lower Yard PURCHASED 7/11/2011 4,000 - 4,000 - - - 4,000 33 Shops Remodel:Arch Svcs Pmt#5 & Walker Const Pmt#2 344235 BLD City Shops-Lower Yard PURCHASED 8/24/2011 13,062 - 13,062 - - - 13,062 34 Shops Remodel:Arch Svcs Pmt#6 & Walker Const Pmt#3 344240 BLD City Shops-Lower Yard PURCHASED 9/1/2011 10,376 - 10,376 - - - 10,376 35 Shops Remodel:Walker Const Pmt#4-Oct Expds 344245 BLD City Shops-Lower Yard PURCHASED 10/1/2011 22,542 - 22,542 - - - 22,542 36 Shops Remodel:Archtrl Srvc 9/01-10/30-Nov Expds 344250 BLD City Shops-Lower Yard PURCHASED 11/1/2011 447 - 447 - - - 447 37 Shops Remodel:Walker Const Pmt#5-Final-Dec Expds 344255 BLD City Shops-Lower Yard PURCHASED 12/1/2011 5,586 - 5,586 - - - 5,586 38 Shops Remodel:Walker Const Pmt#5-Jan Expds 344260 BLD City Shops-Lower Yard PURCHASED 1/1/2012 2,081 - 2,081 - - - 2,081 39 Shops Remodel:Fire Door Closures & Occupd Sign 344265 BLD City Shops-Lower Yard PURCHASED 2/28/2012 565 - 565 - - - 565 40 Shops Remodel:Prep & Paint Doors-March Expds 344270 BLD City Shops-Lower Yard PURCHASED 3/1/2012 409 - 409 - - - 409 41 Shops Remodel:Install Furnace-April Expds 344276 BLD City Shops-Lower Yard PURCHASED 4/27/2012 1,475 - 1,475 - - - 1,475 42 Shops Remodel:Install Heater-May Expds 344281 BLD City Shops-Lower Yard PURCHASED 5/23/2012 541 - 541 - - - 541 43 Laurel Glen Annex-December 36211 BLD Laurel Glen PURCHASED 12/1/2011 2,132 - 2,132 - - 2,132 - 44 Laurel Glen Annex-January Expds 36213 BLD Laurel Glen PURCHASED 1/1/2012 4,584 - 4,584 - - 4,584 - 45 Laurel Glen Annex-February Expds 36215 BLD Laurel Glen PURCHASED 2/7/2012 953 - 953 - - 953 - 46 Laurel Glen Annex-July Expds 36217 BLD Laurel Glen PURCHASED 7/31/2012 7,948 - 7,948 - - 7,948 - 47 Laurel Glen Annex-Sept Expds 36219 BLD Laurel Glen PURCHASED 9/19/2012 475 - 475 - - 475 - 48 Laurel Glen Annex-December Expds 362111 BLD Laurel Glen PURCHASED 12/21/2012 110 - 110 - - 110 - 49 Laurel Glen Annex-January Expds 362113 BLD Laurel Glen PURCHASED 1/22/2013 15,347 - 15,347 - - 15,347 - 50 Laurel Glen Annex-February Expds 362115 BLD Laurel Glen PURCHASED 2/26/2013 11,632 - 11,632 - - 11,632 - 51 Laurel Glen Annex-April Expds 362117 BLD Laurel Glen PURCHASED 4/23/2013 941 - 941 - - 941 - 52 Laurel Glen Annex-June Expds 362119 BLD Laurel Glen PURCHASED 6/30/2013 5,170 - 5,170 - - 5,170 - 53 Laurel Glen Annex-Oct Expds 362121 BLD Laurel Glen PURCHASED 10/7/2013 315 - 315 - - 315 - Classification of Existing Wastewater Utility System Assets [1] Appendix A City of Bozeman, Montana Page 2 of 14 Line Asset Acquired Asset Adj. General No. Description ID Type Location Acquired Date Cost Adjustments [2] Acq. Amt. Treatment Trans. Collection Plant Classification of Existing Wastewater Utility System Assets [1] Appendix A City of Bozeman, Montana Wastewater Impact Fee Study Wastewater System 54 Shop Complex 4910 BLD City Shops PURCHASED 7/1/1998 65,000 - 65,000 - - 65,000 - 55 19Th Interchange 14740 IMP Wastewater Operation PURCHASED 7/1/1998 392,172 - 392,172 - 392,172 - - 56 Sewer Renovations 15320 IMP Wastewater Operation PURCHASED 7/1/1998 316,784 - 316,784 - 111,908 204,877 - 57 Sid 627 Cook-Klabunde 20120 IMP Special Improv District PURCHASED 7/1/1998 26,345 - 26,345 - - 26,345 - 58 Sid 626 Stratford Sewer 20160 IMP Special Improv District PURCHASED 7/1/1998 14,229 - 14,229 - - 14,229 - 59 Sid 629 Sewer University 20770 IMP Special Improv District PURCHASED 7/1/1998 27,925 - 27,925 - - 27,925 - 60 Sid 634 West Main Sewer 20800 IMP Special Improv District PURCHASED 7/1/1998 26,114 - 26,114 - - 26,114 - 61 Sid 635 Tri-Annex Sewer 20820 IMP Special Improv District PURCHASED 7/1/1998 10,880 - 10,880 - - 10,880 - 62 Sid 638 Sanitary Sewer 20840 IMP Special Improv District PURCHASED 7/1/1998 7,761 - 7,761 - - 7,761 - 63 Sid 615 Sewer Burey Annes 22210 IMP Special Improv District PURCHASED 7/1/1983 281,632 - 281,632 - - 281,632 - 64 Sid 645 Sewer Kagy-Grafs 22540 IMP Special Improv District PURCHASED 1/31/1984 36,229 - 36,229 - - 36,229 - 65 Sid 649 Sanitary Sewer 24620 IMP Special Improv District PURCHASED 8/1/1986 324,333 - 324,333 - - 324,333 - 66 Epa Grant 56Ep04 320662 IMP Wastewater Plant GRANT 11/15/2004 298,747 - 298,747 298,747 - - - 67 Epa Grant 56Ep04 320664 IMP Wastewater Plant GRANT 12/15/2004 196,553 - 196,553 196,553 - - - 68 Epa Grant 56Ep04 320671 IMP Wastewater Plant GRANT 5/15/2005 3,962 - 3,962 3,962 - - - 69 Fy80-06 Private Sewer Infr:Developer Contributions 34080 IMP Wastewater Operation CONTRIBUTION 6/30/2007 52,097,635 - 52,097,635 - 18,404,064 33,693,571 - 70 Fy07 Private Sewer Infr:Developer Contributions 34081 IMP Wastewater Operation CONTRIBUTION 6/30/2007 13,772,623 - 13,772,623 - 4,865,331 8,907,292 - 71 Fy08 Private Sewer Infr:Developer Contributions 34082 IMP Wastewater Operation CONTRIBUTION 6/30/2008 14,615,989 - 14,615,989 - 5,163,259 9,452,729 - 72 Fy09 Private Sewer Infr:Developer Contributions 34083 IMP Wastewater Operation CONTRIBUTION 6/30/2009 1,466,623 - 1,466,623 - 518,101 948,522 - 73 Fy10 Private Sewer Infr:Developer Contributions 34084 IMP Wastewater Operation CONTRIBUTION 6/30/2010 1,152,686 - 1,152,686 - 407,199 745,487 - 74 Fy11 Private Sewer Infr:Developer Contributions 34085 IMP Wastewater Operation CONTRIBUTION 6/30/2011 3,568,128 - 3,568,128 - 1,260,481 2,307,648 - 75 Fy14 Private Sewer Infr:Developer Contributions 34086 IMP Wastewater Operation CONTRIBUTION 6/30/2014 2,760,945 - 2,760,945 - 975,334 1,785,611 - 76 Fy15 Private Sewer Infr:Developer Contributions 34087 IMP Wastewater Operation CONTRIBUTION 6/30/2015 2,080,091 - 2,080,091 - 734,815 1,345,276 - 77 Fy16 Private Sewer Infr:Developer Contributions 34088 IMP Wastewater Operation CONTRIBUTION 6/30/2016 5,997,522 - 5,997,522 - 2,118,691 3,878,831 - 78 Fy17 Private Sewer Infr:Developer Contributions 34089 IMP Wastewater Operation CONTRIBUTION 6/30/2017 3,985,608 - 3,985,608 - 1,407,960 2,577,648 - 79 2008 Sewer Rehab Project:Design Svcs Thru 6/30/08 34291 IMP Wastewater Operation PURCHASED 6/30/2008 80,000 - 80,000 - 28,261 51,739 - 80 Sewer Repair E. Babcock - Replace Sewer Main 34292 IMP Wastewater Operation PURCHASED 8/1/2008 10,000 - 10,000 - 3,533 6,467 - 81 2008 Sewer Rehab Project:Design Svcs Thru 09/03/08 34293 IMP Wastewater Operation PURCHASED 9/12/2008 8,013 - 8,013 - 2,831 5,182 - 82 2008 Sewer Rehab Project:Design Svcs Thru 10/09/08 34294 IMP Wastewater Operation PURCHASED 10/17/2008 5,468 - 5,468 - 1,931 3,536 - 83 2008 Sewer Rehab Project:Design Svcs Thru 11/29/08 34295 IMP Wastewater Operation PURCHASED 11/30/2008 28,551 - 28,551 - 10,086 18,465 - 84 2008 Sewer Rehab Project:Design Svcs Thru 12/23/08 34296 IMP Wastewater Operation PURCHASED 11/30/2008 16,253 - 16,253 - 5,742 10,512 - 85 08 Sewer Rehab Proj:Const Svcs Thru 12/22 Pmt#1 34297 IMP Wastewater Operation PURCHASED 1/14/2009 310,297 - 310,297 - 109,616 200,681 - 86 08 Sewer Rehab Proj:1%Grt (Pec) Pmt#1 Thru 12/22 34298 IMP Wastewater Operation GRANT 1/14/2009 3,135 - 3,135 - 1,107 2,027 - 87 2008 Sewer Rehab Project:Design Svcs Thru 01/17/09 34299 IMP Wastewater Operation PURCHASED 1/30/2009 3,181 - 3,181 - 1,124 2,057 - 88 2008 Sewer Rehab Proj:Legal 9001/Bid Ad 342910 IMP Wastewater Operation PURCHASED 3/1/2009 120 - 120 - 42 78 - 89 2008 Sewer Rehab Proj:Legal 5001/Bid Ad 342911 IMP Wastewater Operation PURCHASED 3/1/2009 66 - 66 - 23 43 - 90 2008 Sewer Rehab Project:Design Svcs Thru 04/20/09 342912 IMP Wastewater Operation PURCHASED 4/22/2009 1,535 - 1,535 - 542 993 - 91 2008 Sewer Rehab Project:Design Svcs Thru 05/16/09 342913 IMP Wastewater Operation PURCHASED 5/28/2009 20,711 - 20,711 - 7,317 13,395 - 92 2008 Sewer Rehab Project:July Expds 342914 IMP Wastewater Operation PURCHASED 7/31/2009 139,539 - 139,539 - 49,294 90,245 - 93 2008 Sewer Rehab Project:August Expds 342915 IMP Wastewater Operation PURCHASED 8/31/2009 5,422 - 5,422 - 1,915 3,506 - 94 2008 Sewer Rehab Project:October Expds 342916 IMP Wastewater Operation PURCHASED 10/20/2009 910 - 910 - 321 588 - 95 2008 Sewer Rehab Project:October Expds 342917 IMP Wastewater Operation PURCHASED 10/20/2009 90,041 - 90,041 - 31,808 58,233 - 96 2008 Sewer Rehab Project:November Expds 342918 IMP Wastewater Operation PURCHASED 11/30/2009 23,234 - 23,234 - 8,208 15,026 - 97 2008 Sewer Rehab Project:December Expds 342919 IMP Wastewater Operation PURCHASED 12/28/2009 28,927 - 28,927 - 10,219 18,709 - 98 2008 Sewer Rehab Project:March Expds 342920 IMP Wastewater Operation PURCHASED 3/30/2010 1,318 - 1,318 - 465 852 - 99 2012 Sewer Rehab Project:Pmt#1 February Expds 342921 IMP Wastewater Operation PURCHASED 2/28/2012 4,000 - 4,000 - 1,413 2,587 - 100 2012 Sewer Rehab Project:Pmt#2 March Expds 342922 IMP Wastewater Operation PURCHASED 3/22/2012 11,600 - 11,600 - 4,098 7,502 - 101 2012 Sewer Rehab Project:Pmt#3 April Expds 342923 IMP Wastewater Operation PURCHASED 4/24/2012 3,100 - 3,100 - 1,095 2,005 - 102 2012 Sewer Rehab Project:Pmt#4 May Expds 342924 IMP Wastewater Operation PURCHASED 5/24/2012 1,750 - 1,750 - 618 1,132 - 103 2012 Sewer Rehab Project:Pmt#5 June Expds 342925 IMP Wastewater Operation PURCHASED 6/28/2012 18,764 - 18,764 - 6,629 12,135 - 104 2012 Sewer Rehab Project:Pmt#6 July Expds 342926 IMP Wastewater Operation PURCHASED 7/26/2012 4,350 - 4,350 - 1,537 2,813 - 105 2012 Sewer Rehab Project:Pmt#7 August Expds 342927 IMP Wastewater Operation PURCHASED 8/5/2012 3,858 - 3,858 - 1,363 2,495 - Page 3 of 14 Line Asset Acquired Asset Adj. General No. Description ID Type Location Acquired Date Cost Adjustments [2] Acq. Amt. Treatment Trans. Collection Plant Classification of Existing Wastewater Utility System Assets [1] Appendix A City of Bozeman, Montana Wastewater Impact Fee Study Wastewater System 109 2012 Sewer Rehab Project:Pmt#11 June Expds 342931 IMP Wastewater Operation PURCHASED 6/26/2013 2,836 - 2,836 - 1,002 1,834 - 110 2012 Sewer Rehab Project:Pmt#12 July Expds 342932 IMP Wastewater Operation PURCHASED 7/29/2013 5,581 - 5,581 - 1,971 3,609 - 111 2012 Sewer Rehab Project:Pmt#13 Aug Expds 342933 IMP Wastewater Operation PURCHASED 8/29/2013 294,153 - 294,153 - 103,913 190,240 - 112 2012 Sewer Rehab Project:Pmt#14 Sept Expds 342934 IMP Wastewater Operation PURCHASED 9/30/2013 614,247 - 614,247 - 216,989 397,257 - 113 2012 Sewer Rehab Project:Pmt#15 Oct Expds 342935 IMP Wastewater Operation PURCHASED 10/29/2013 377,983 - 377,983 - 133,527 244,457 - 114 2012 Sewer Rehab Project:Pmt#16 & 17 Nov Expds 342936 IMP Wastewater Operation PURCHASED 11/21/2013 77,654 - 77,654 - 27,432 50,222 - 115 2012 Sewer Rehab Project:Pmt#18 Jan Expds 342937 IMP Wastewater Operation PURCHASED 1/28/2014 1,444 - 1,444 - 510 934 - 116 2012 Sewer Rehab Project:Pmt#19 March Expds 342938 IMP Wastewater Operation PURCHASED 3/25/2014 5,689 - 5,689 - 2,010 3,679 - 117 2012 Sewer Rehab Project:Pmt#20 April Expds 342939 IMP Wastewater Operation PURCHASED 4/28/2014 4,811 - 4,811 - 1,699 3,111 - 118 2012 Sewer Rehab Project:Pmt#21 May Expds 342940 IMP Wastewater Operation PURCHASED 5/23/2014 1,270 - 1,270 - 449 821 - 119 2012 Sewer Rehab Project:Pmt#22 Oct Expds 342941 IMP Wastewater Operation PURCHASED 10/22/2014 3,053 - 3,053 - 1,078 1,974 - 120 2012 Sewer Rehab Project:Pmt#23 Nov Expds 342942 IMP Wastewater Operation PURCHASED 11/20/2014 970 - 970 - 342 627 - 121 2012 Sewer Rehab Project:Pmt#24 Sept Expds Fy16 342943 IMP Wastewater Operation PURCHASED 9/24/2015 15,130 - 15,130 - 5,345 9,785 - 122 2012 Sewer Rehab Project:Pmt#25 April Expds Fy16 342944 IMP Wastewater Operation PURCHASED 4/21/2016 4,062 - 4,062 - 1,435 2,627 - 123 2012 Sewer Rehab Project:June Expds Fy16 342945 IMP Wastewater Operation PURCHASED 6/23/2016 2,307 - 2,307 - 815 1,492 - 124 2012 Sewer Rehab Project:July Expds Fy17 342946 IMP Wastewater Operation PURCHASED 7/21/2016 6,365 - 6,365 - 2,249 4,116 - 125 S University Sewer Main Pay#1:July Expds Fy17 342947 IMP Wastewater Operation PURCHASED 7/31/2016 215,508 - 215,508 - 215,508 - - 126 S University Sewer Main Pay#2:Oct Expds Fy17 342948 IMP Wastewater Operation PURCHASED 10/18/2016 367,251 - 367,251 - 367,251 - - 127 S University Sewer Main Pay#3:Dec Expds Fy17 342949 IMP Wastewater Operation PURCHASED 12/20/2016 691,781 - 691,781 - 691,781 - - 128 S University Sewer Main Pay#4:Jan Expds Fy17 342950 IMP Wastewater Operation PURCHASED 1/17/2017 138,122 - 138,122 - 138,122 - - 129 N Willson Sewer Renovation Proj:April Expds 342951 IMP Wastewater Operation PURCHASED 4/14/2017 666 - 666 - 235 431 - 130 S University Sewer Main Pay#5:April Expds Fy17 342952 IMP Wastewater Operation PURCHASED 4/30/2017 111,974 - 111,974 - 111,974 - - 131 Ww Facility Plan Update Fy17-April 342953 IMP Wastewater Operation PURCHASED 4/30/2017 134,953 - 134,953 - - - 134,953 132 Concrete Retaining Wall & Drain Improv @ Shops 34576 IMP City Shops PURCHASED 1/1/2009 7,457 - 7,457 - - 7,457 - 133 Laurel Glen Annex Irrgtn-June Fy15 Expds 362123 IMP Laurel Glen PURCHASED 6/30/2015 19,504 - 19,504 - - 19,504 - 134 College-Main->S 19Th-Mdot Highway Project 37131 IMP Street Department PURCHASED 1/1/2014 21,884 - 21,884 - - - 21,884 135 Sid 718 - E Story Street Sewer Replacement 37282 IMP Special Improv District PURCHASED 5/6/2014 346 - 346 - - 346 - 136 Cds Storm Drain Unit Separator 37642 IMP City Shops PURCHASED 3/1/2015 2,333 - 2,333 - - - 2,333 137 Sid732:N Wallace Ave Sewer:August Expds Fy17 38178 IMP Special Improv District PURCHASED 8/18/2016 14,673 - 14,673 - - 14,673 - 138 Rouse-Oak To Storymill Rd (Water/Sewer)City Share 38641 IMP Water Operations PURCHASED 8/31/2016 32,064 - 32,064 - 32,064 - - 139 Bridger Drive Sewer Main Project-Sept Expds 38661 IMP Wastewater Operation PURCHASED 9/30/2016 21,208 - 21,208 - 21,208 - - 140 Sid739:Olive & Church Recnstrctn Prj-Fy17-June Exp 39913 IMP Special Improv District PURCHASED 6/1/2017 31,721 - 31,721 - - 31,721 - 141 Sid739:Olive & Church Recnstrctn Prj-Fy17-June Exp 399111 IMP Special Improv District PURCHASED 6/30/2017 182,094 - 182,094 - - 182,094 - 142 Sid 567 San Sewer Lateral Mn 4330 IMP Special Improv District PURCHASED 7/1/1998 95,631 - 95,631 - - 95,631 - 143 Sid 580 Sanitary Sewer West Koch 4440 IMP Special Improv District PURCHASED 7/1/1998 85,866 - 85,866 - - 85,866 - 144 Sid 587 Beaumont Subdivison 4500 IMP Special Improv District PURCHASED 7/1/1998 77,594 - 77,594 - - 77,594 - 145 Sid 596 Sewer Mcchesney 4570 IMP Special Improv District PURCHASED 7/1/1998 105,000 - 105,000 - - 105,000 - 146 Sid 597 Sanitary Sewer Wheat Subdivison 4580 IMP Special Improv District PURCHASED 7/1/1998 64,479 - 64,479 - - 64,479 - 147 Sid 601 Sewer Figgins 4Th 4620 IMP Special Improv District PURCHASED 7/1/1998 87,205 - 87,205 - - 87,205 - 148 Sid 414 Sanitary Sewer 5440 IMP Special Improv District PURCHASED 7/1/1998 144,223 - 144,223 - - 144,223 - 149 Sid 425 Sanitary Sewer Hillcrest 5500 IMP Special Improv District PURCHASED 7/1/1998 83,703 - 83,703 - - 83,703 - 150 Sid 426 Westridge Sanitary Sewer 5520 IMP Special Improv District PURCHASED 7/1/1998 62,836 - 62,836 - - 62,836 - 151 Sid 432 West End Sanitary Sewer 5530 IMP Special Improv District PURCHASED 7/1/1998 226,619 - 226,619 - - 226,619 - 152 Sid 511 Sanitary Sewer Thompson 5690 IMP Special Improv District PURCHASED 7/1/1998 144,604 - 144,604 - - 144,604 - 153 Sid 527 Grafs & Figgins 5750 IMP Special Improv District PURCHASED 7/1/1998 69,258 - 69,258 - - 69,258 - 154 Sid 621 Sewer Valley Unit 5800 IMP Special Improv District PURCHASED 7/1/1998 585,797 - 585,797 - - 585,797 - 155 Sid 623 Sewer Valley Unit 5810 IMP Special Improv District PURCHASED 7/1/1998 515,644 - 515,644 - - 515,644 - 156 Wheat Drive Lift Station 11600 IMP Wastewater Operation PURCHASED 7/1/1998 132,994 - 132,994 - 132,994 - - 157 Epa Project 22 22080 IMP Wastewater Operation GRANT 7/1/1998 386,262 - 386,262 - - - 386,262 158 Epa Project 23 22090 IMP Wastewater Operation GRANT 7/1/1998 210,634 - 210,634 - - - 210,634 159 Epa Project 24 22100 IMP Wastewater Operation GRANT 7/1/1998 5,168,755 - 5,168,755 - - - 5,168,755 160 Figgins/Westridge Outfall 28870 IMP Wastewater Operation PURCHASED 6/30/2000 143,893 - 143,893 143,893 - - - Page 4 of 14 Line Asset Acquired Asset Adj. General No. Description ID Type Location Acquired Date Cost Adjustments [2] Acq. Amt. Treatment Trans. Collection Plant Classification of Existing Wastewater Utility System Assets [1] Appendix A City of Bozeman, Montana Wastewater Impact Fee Study Wastewater System 164 Solvent Site Water Improvements 29473 IMP Wastewater Operation PURCHASED 6/30/2002 81,479 (81,479) 0 - - - - 165 Solvent Site Water Improvements 29474 IMP Wastewater Operation PURCHASED 6/30/2002 1,487,063 (1,487,063) 0 - - - - 166 Solvent Site 29475 IMP Wastewater Operation PURCHASED 8/15/2002 36,060 (36,060) 0 - - - - 167 Solvent Site 29476 IMP Wastewater Operation PURCHASED 9/15/2002 5,968 (5,968) 0 - - - - 168 Solvent Site 29477 IMP Wastewater Operation PURCHASED 10/15/2002 7,050 (7,050) 0 - - - - 169 Solvent Site 29478 IMP Wastewater Operation PURCHASED 12/15/2002 5,594 (5,594) 0 - - - - 170 Solvent Site 29479 IMP Wastewater Operation PURCHASED 5/15/2003 1,009 (1,009) 0 - - - - 171 Solvent Site 294710 IMP Wastewater Operation PURCHASED 7/28/2003 1,515 (1,515) 0 - - - - 172 Solvent Site Clean Up 294711 IMP Wastewater Operation PURCHASED 8/12/2003 10,637 (10,637) 0 - - - - 173 Solvent Site 294712 IMP Wastewater Operation PURCHASED 9/12/2003 7,497 (7,497) 0 - - - - 174 Lyman Reservoir 295823 IMP Water Treatment Plant PURCHASED 3/15/2003 8,285 - 8,285 - - - 8,285 175 Burrup Lift Station (See 3095-Aerial Truck-Ranger) 30690 IMP Wastewater Operation PURCHASED 6/1/2001 52,215 - 52,215 - 52,215 - - 176 Burrup Lift Station 30695 IMP Wastewater Operation PURCHASED 6/30/2002 67,443 - 67,443 - 67,443 - - 177 Burrup Lift Station 30696 IMP Wastewater Operation PURCHASED 8/29/2003 15,000 - 15,000 - 15,000 - - 178 Burrup Lift Station 30697 IMP Wastewater Operation PURCHASED 10/15/2003 1,183 - 1,183 - 1,183 - - 179 Burrup Lift Station 30698 IMP Wastewater Operation PURCHASED 10/15/2004 6,210 - 6,210 - 6,210 - - 180 Epa Project #1 4790 IMP Wastewater Operation GRANT 7/1/1998 147,341 - 147,341 147,341 - - - 181 Epa Project #13 4820 IMP Wastewater Operation GRANT 7/1/1998 377,958 - 377,958 377,958 - - - 182 Epa Project #23-Ii 4940 IMP Wastewater Operation GRANT 7/1/1998 75,481 - 75,481 75,481 - - - 183 Epa Project #23-Iii 4950 IMP Wastewater Operation GRANT 7/1/1998 72,708 - 72,708 72,708 - - - 184 Disposal System 4960 IMP Wastewater Operation PURCHASED 7/1/1998 60,696 - 60,696 60,696 - - - 185 Disposal Plant 4980 IMP Wastewater Operation PURCHASED 7/1/1998 274,352 - 274,352 274,352 - - - 186 Old Plant 4990 IMP Wastewater Plant PURCHASED 7/1/1998 50,000 - 50,000 50,000 - - - 187 West Sanitary Tanks 5010 IMP Wastewater Operation PURCHASED 7/1/1998 113,638 - 113,638 113,638 - - - 188 Sanitary Sewers Old 5020 IMP Wastewater Operation PURCHASED 7/1/1998 498,068 - 498,068 498,068 - - - 189 Sanitary Sewers New 5030 IMP Wastewater Operation PURCHASED 7/1/1998 699,081 - 699,081 699,081 - - - 190 Epa Project #26 5510 IMP Wastewater Operation GRANT 7/1/1998 2,587,634 - 2,587,634 2,587,634 - - - 191 Sewer Easement 25330 LAN Wastewater Operation PURCHASED 7/1/1998 1,000 - 1,000 - 1,000 - - 192 801 N Rouse Ave Land Purchase-March Expds Fy17 39692 LAN City Shops PURCHASED 3/13/2017 74,964 - 74,964 - - - 74,964 193 1804 N Rouse / Mdt Property Stpp 86-1(44)-June Exp 39753 LAN City Shops PURCHASED 6/30/2017 292,500 - 292,500 - - - 292,500 194 New Site - Lower Yards Property 4840 LAN Wastewater Operation PURCHASED 7/1/1998 34,690 - 34,690 - - - 34,690 195 City Yard Improvements 4850 LAN Wastewater Operation PURCHASED 7/1/1998 3,744 - 3,744 - - - 3,744 196 Easements 4860 LAN Wastewater Operation PURCHASED 7/1/1998 16,338 - 16,338 - 16,338 - - 197 Wonderware Scada Software-Dec 125880 M&E Water Treatment Plant PURCHASED 12/16/2014 8,646 - 8,646 - - - 8,646 198 Accounting Software 26252 M&E Hte Software PURCHASED 7/1/1998 37,200 - 37,200 - - - 37,200 199 Cisco 310240 M&E Cisco Phone System PURCHASED 9/15/2002 5 - 5 - - - 5 200 Cisco 310257 M&E Cisco Phone System PURCHASED 1/15/2003 230 - 230 - - - 230 201 Cisco 310297 M&E Cisco Phone System PURCHASED 2/15/2003 3 - 3 - - - 3 202 Cisco 3102114 M&E Cisco Phone System PURCHASED 5/15/2003 209 - 209 - - - 209 203 Iseries+P7 V7Ri Os Upgrade:Sungard Srvr Operat Sys 32974 M&E City Hall:121 N.Rouse PURCHASED 6/6/2012 1,020 - 1,020 - - - 1,020 204 Hte Click2Gov:Digital Certificate-Cx 332427 M&E Hte Software PURCHASED 12/1/2006 120 - 120 - - - 120 205 Hte Click2Gov:Core Module #20061445 332436 M&E Hte Software PURCHASED 12/1/2006 620 - 620 - - - 620 206 Hte Click2Gov:Cx Utility Billing 332443 M&E Hte Software PURCHASED 12/1/2006 1,390 - 1,390 - - - 1,390 207 Hte Click2Gov:Tax Billing Module (Sid Billing) 332452 M&E Hte Software PURCHASED 12/1/2006 1,938 - 1,938 - - - 1,938 208 Hte Click2Gov:Final Core Module Install 332469 M&E Hte Software PURCHASED 3/23/2007 300 - 300 - - - 300 209 Hte Click2Gov:Tax Cc Activation Installation 332480 M&E Hte Software PURCHASED 3/23/2007 163 - 163 - - - 163 210 Hte Click2Gov:Tax Billing+Collect Final Install 332488 M&E Hte Software PURCHASED 3/23/2007 225 - 225 - - - 225 211 Hte Click2Gov:Util Cc Activation Installation 332494 M&E Hte Software PURCHASED 3/23/2007 217 - 217 - - - 217 212 Hte Click2Gov:Util Cx Final Installation 3324100 M&E Hte Software PURCHASED 3/23/2007 300 - 300 - - - 300 213 Server-Data Backup Managr:$14974.55 Split Citywide 3324145 M&E Information Technology PURCHASED 11/1/2007 599 - 599 - - - 599 214 Cityworks Work Order Lic-Azteca Work Orders Pmt#1 3324152 M&E Geographic Info Systems PURCHASED 11/28/2007 12,833 - 12,833 - 6,417 6,417 - 215 Work Order Arc-Gis License:Sewer Portion #97189 3324161 M&E Geographic Info Systems PURCHASED 2/1/2008 4,250 - 4,250 - 2,125 2,125 - Page 5 of 14 Line Asset Acquired Asset Adj. General No. Description ID Type Location Acquired Date Cost Adjustments [2] Acq. Amt. Treatment Trans. Collection Plant Classification of Existing Wastewater Utility System Assets [1] Appendix A City of Bozeman, Montana Wastewater Impact Fee Study Wastewater System 219 Cityworks Site License Startup:Azteca Sys:July Exp 3324230 M&E Geographic Info Systems PURCHASED 7/10/2013 8,435 - 8,435 - 4,218 4,218 - 220 Add'L (2)Arc-Gis Licenses-Sewer Portion 3324234 M&E Geographic Info Systems PURCHASED 9/5/2013 3,943 - 3,943 - 1,971 1,971 - 221 Meter Reading Device (Backup For Fa#3745) 33580 M&E Wastewater Operation PURCHASED 10/2/2006 19,925 - 19,925 - - 19,925 - 222 P7-New As400 Software/Hardware 36143 M&E City Hall:121 N.Rouse PURCHASED 6/28/2011 5,187 - 5,187 - - - 5,187 223 Ivr (Integrated Voice Recognition Software) 37511 M&E Finance Department PURCHASED 11/14/2014 6,219 - 6,219 - - - 6,219 224 Ivr (Integrated Voice Recognition Software)June 15 37515 M&E Finance Department PURCHASED 6/30/2015 15,083 - 15,083 - - - 15,083 225 Ivr (Integrated Voice Recognitn Software)Aug Fy16 37517 M&E Finance Department PURCHASED 8/1/2015 6,233 - 6,233 - - - 6,233 226 Ivr (Integrated Voice Recognitn Software)Oct Fy16 37519 M&E Finance Department PURCHASED 10/27/2015 1,558 - 1,558 - - - 1,558 227 Web Mapping Software Integration(Vantage Points) 37650 M&E Geographic Info Systems PURCHASED 2/26/2015 29,130 - 29,130 - 14,565 14,565 - 228 Web Mapping Software Integration(Vantage Points) 37651 M&E Geographic Info Systems PURCHASED 5/31/2015 6,600 - 6,600 - 3,300 3,300 - 229 Dell Cto Storage(Sewer ) 39832 M&E Information Technology PURCHASED 5/23/2017 2,300 - 2,300 - - - 2,300 230 Copier 32667 M&E City Shops-Veh Maint PURCHASED 10/15/2004 956 - 956 - - - 956 231 Savin C9145 Photocopier-Dec Expds 36047 M&E City Shops PURCHASED 12/21/2010 1,046 - 1,046 - - - 1,046 232 Mobile Track File System & Installation 36370 M&E Professional Building PURCHASED 6/18/2012 23,833 - 23,833 - - - 23,833 233 Easement Machine 14820 M&E Wastewater Operation PURCHASED 7/1/1998 13,150 - 13,150 - - - 13,150 234 Crib Trailer 14830 M&E Wastewater Operation PURCHASED 6/30/2012 0 - 0 - - - 0 235 Color Moni System 19940 M&E Wastewater Operation PURCHASED 7/1/1998 16,022 - 16,022 - - - 16,022 236 1999 John Deere Backhoe 26830 M&E Wastewater Operation PURCHASED 7/1/1998 129,926 - 129,926 - - - 129,926 237 2001 Jk Skid Steer Loader 30300 M&E Wastewater Operation PURCHASED 9/19/2001 19,579 - 19,579 - - - 19,579 238 John Deere Post Hole Digger W/12" Auger 30301 M&E Wastewater Operation PURCHASED 9/25/2001 1,450 - 1,450 - - - 1,450 239 John Deere 48" Rail Pallet Forks 30302 M&E Wastewater Operation PURCHASED 9/25/2001 835 - 835 - - - 835 240 Pickup Broom 30303 M&E Wastewater Operation PURCHASED 9/25/2001 3,455 - 3,455 - - - 3,455 241 2001 Trail Max Trailer 30650 M&E Wastewater Operation PURCHASED 4/15/2002 5,400 - 5,400 - - - 5,400 242 Ground Heater Trailer 31151 M&E Wastewater Operation PURCHASED 6/13/2002 7,838 - 7,838 - - - 7,838 243 Radio Read Water Meter System 31320 M&E Wastewater Operation PURCHASED 6/30/2002 185,657 - 185,657 - - 185,657 - 244 Radio Read Water Meter System 31322 M&E Wastewater Operation PURCHASED 8/15/2002 18,387 - 18,387 - - 18,387 - 245 Radio Read Water Meter System 31323 M&E Wastewater Operation PURCHASED 8/15/2002 1,445 - 1,445 - - 1,445 - 246 Radio Read Water Meter System 31325 M&E Wastewater Operation PURCHASED 10/15/2002 10,550 - 10,550 - - 10,550 - 247 Radio Read Water Meter System 31327 M&E Wastewater Operation PURCHASED 11/15/2002 2,687 - 2,687 - - 2,687 - 248 Radio Read Water Meter System 313210 M&E Wastewater Operation PURCHASED 11/15/2002 723 - 723 - - 723 - 249 Radio Read Water Meter System 313211 M&E Wastewater Operation PURCHASED 11/15/2002 74,120 - 74,120 - - 74,120 - 250 Radio Read Water Meter System 313212 M&E Wastewater Operation PURCHASED 11/15/2002 5,540 - 5,540 - - 5,540 - 251 Radio Read Water Meter System 313214 M&E Wastewater Operation PURCHASED 12/15/2002 11,720 - 11,720 - - 11,720 - 252 Radio Read Water Meter System 313216 M&E Wastewater Operation PURCHASED 1/15/2003 18,138 - 18,138 - - 18,138 - 253 Radio Read Water Meter System 313218 M&E Wastewater Operation PURCHASED 2/15/2003 9,812 - 9,812 - - 9,812 - 254 Radio Read Water Meter System 313220 M&E Wastewater Operation PURCHASED 3/15/2003 21,797 - 21,797 - - 21,797 - 255 Radio Read Water Meter System 313222 M&E Wastewater Operation PURCHASED 4/15/2003 71,793 - 71,793 - - 71,793 - 256 Radio Read Water Meter System 313224 M&E Wastewater Operation PURCHASED 5/15/2003 37,706 - 37,706 - - 37,706 - 257 Radio Read Water Meter System 313226 M&E Wastewater Operation PURCHASED 6/15/2003 6,575 - 6,575 - - 6,575 - 258 Radio Read Water Meter System 313228 M&E Wastewater Operation PURCHASED 8/6/2003 8,889 - 8,889 - - 8,889 - 259 Radio Read Water Meter System 313230 M&E Wastewater Operation PURCHASED 9/3/2003 4,825 - 4,825 - - 4,825 - 260 Radio Read Water Meter System 313232 M&E Wastewater Operation PURCHASED 6/30/2002 185,657 - 185,657 - - 185,657 - 261 Bypass Pump With Trailer 32530 M&E Laurel Glen PURCHASED 6/15/2004 51,880 - 51,880 - - - 51,880 262 Portable Flow Sensor Machine 32570 M&E Wastewater Operation PURCHASED 4/21/2004 6,745 - 6,745 - - - 6,745 263 Bagella Asphalt Recycling Machine:Portable Plant 33662 M&E Street Department PURCHASED 5/1/2007 16,873 - 16,873 - - - 16,873 264 01 Ford Tv Van Retrofitted For Sewer S/B 3406 34063 M&E Wastewater Operation PURCHASED 5/24/2012 98,024 - 98,024 - - - 98,024 265 Camera Wheels Module & Accesories-June S/B 3406 34064 M&E Wastewater Operation PURCHASED 6/15/2012 6,620 - 6,620 - - - 6,620 266 Impactor:Icy Ground Jack Hammer 34141 M&E Wastewater Operation PURCHASED 1/15/2008 4,673 - 4,673 - - - 4,673 267 Manhole Adj Tool:Cutter Extractor Unit W/Acc Pack 34901 M&E Street Department PURCHASED 4/1/2009 7,060 - 7,060 - - - 7,060 268 2010 Kenworth Dump Truck 35490 M&E Wastewater Operation PURCHASED 8/11/2010 105,146 - 105,146 - - - 105,146 269 Boring Tool & Kit 36391 M&E Wastewater Operation PURCHASED 7/26/2012 3,635 - 3,635 - - - 3,635 270 Hitachi Mini Excavator:24"Bucket&Clamp Kit 36632 M&E Wastewater Operation PURCHASED 4/15/2013 21,622 - 21,622 - - - 21,622 Page 6 of 14 Line Asset Acquired Asset Adj. General No. Description ID Type Location Acquired Date Cost Adjustments [2] Acq. Amt. Treatment Trans. Collection Plant Classification of Existing Wastewater Utility System Assets [1] Appendix A City of Bozeman, Montana Wastewater Impact Fee Study Wastewater System 274 2015 Ford F350 Super Duty(White)+Tools&Accesrs 37160 M&E Wastewater Operation PURCHASED 5/30/2014 40,518 - 40,518 - - - 40,518 275 Trimble Geo 7X Range Finder 37261 M&E Geographic Info Systems PURCHASED 7/30/2014 3,472 - 3,472 - - - 3,472 276 2015 Vactor 2100 Plus(Sewer Vacuum Truck)(White) 37630 M&E Wastewater Operation PURCHASED 4/7/2015 369,323 - 369,323 - - - 369,323 277 Light Plant/Tower 50/50 Wtr/Swr 37751 M&E Water Operations PURCHASED 6/23/2015 3,682 - 3,682 - - - 3,682 278 Sewer Flow Meter Assembly 38350 M&E Wastewater Operation PURCHASED 7/27/2016 15,851 - 15,851 - - 15,851 - 279 Sewer Flow Meter Mounting Jack Temp Mount&Frame 38351 M&E Wastewater Operation PURCHASED 9/1/2016 939 - 939 - - 939 - 280 Vaporooter System/ Root Foamer 38460 M&E Wastewater Operation PURCHASED 8/22/2016 39,000 - 39,000 - - - 39,000 281 Sewer Tv Camera 39820 M&E Wastewater Operation PURCHASED 5/11/2017 9,810 - 9,810 - - - 9,810 282 1988 Ford Flatbed Truck 11180 VEH Laurel Glen PURCHASED 7/1/1998 14,992 - 14,992 - - - 14,992 283 1994 Gmc Truck 16070 VEH Wastewater Operation PURCHASED 7/1/1998 18,695 - 18,695 - - - 18,695 284 1995 Ford Dump Truck 17830 VEH Wastewater Operation PURCHASED 7/1/1998 39,668 - 39,668 - - - 39,668 285 2002 Freightliner Hydraulic Sewer Jet Cleaner 30310 VEH Wastewater Operation PURCHASED 8/28/2001 98,211 - 98,211 - - - 98,211 286 Radio & Antenna 30311 VEH Wastewater Operation PURCHASED 8/15/2001 540 - 540 - - - 540 287 2004 Ford X21 F250 3/4 Ton Extended Cab Truck 32320 VEH Wastewater Operation PURCHASED 4/21/2004 27,350 - 27,350 - - - 27,350 288 Radio 32321 VEH Wastewater Operation PURCHASED 5/15/2004 6,907 - 6,907 - - - 6,907 289 2006 Gmc Sierra Truck For Water Dept 50%-Fund620 33442 VEH Water Operations PURCHASED 3/8/2006 9,595 - 9,595 - - - 9,595 290 Strobe Lights For Water Truck 50%-Fund620 33443 VEH Water Operations PURCHASED 3/21/2006 1,355 - 1,355 - - - 1,355 291 2007 Gmc Sierra 2500 (White - 3/4 Ton) 33600 VEH Wastewater Operation PURCHASED 10/5/2006 27,445 - 27,445 - - - 27,445 292 Sewer Line Tv Van 34060 VEH Wastewater Operation PURCHASED 12/18/2007 196,000 - 196,000 - - - 196,000 293 Strobes,Install & New Computer - Net Doubledata Cr 34061 VEH Wastewater Operation PURCHASED 3/18/2008 2,307 - 2,307 - - - 2,307 294 Doubledata 2000 System W/Cables For Tv Van 34062 VEH Wastewater Operation PURCHASED 5/1/2008 5,544 - 5,544 - - - 5,544 295 2008 Kenworth Dump Truck T370 - White 34150 VEH Wastewater Operation PURCHASED 2/6/2008 89,475 - 89,475 - - - 89,475 296 2012 Gmc Sierra 3500 36200 VEH Water Operations PURCHASED 2/9/2012 27,971 - 27,971 - - - 27,971 297 2012 Gmc Sierra Truck Body/Hoist & Installation 36201 VEH Water Operations PURCHASED 5/24/2012 9,860 - 9,860 - - - 9,860 298 2012 Gmc Sierra 3500:(5)Lightbars &Mountng Kit 36202 VEH Water Operations PURCHASED 6/27/2012 1,210 - 1,210 - - - 1,210 299 2012 Gmc Sierra 3500:Door Decals & Light Bars 36203 VEH Wastewater Operation PURCHASED 7/11/2012 755 - 755 - - - 755 300 2013 Ford F150 Supercab 4X4 36680 VEH Wastewater Operation PURCHASED 5/23/2013 24,600 - 24,600 - - - 24,600 301 13 Ford Supercab:Install Light Bar & Parts 36681 VEH Wastewater Operation PURCHASED 6/27/2013 4,043 - 4,043 - - - 4,043 302 2016 Ford F150 Truck 38330 VEH Wastewater Operation PURCHASED 8/2/2016 27,451 - 27,451 - - - 27,451 303 2016 Ford F350 Truck 38340 VEH Wastewater Operation PURCHASED 8/2/2016 30,265 - 30,265 - - - 30,265 304 2016 Ford F350 Truck Trav-L-Vac 300 Skidmount Sys 38341 VEH Wastewater Operation PURCHASED 1/31/2017 15,870 - 15,870 - - - 15,870 305 2016 Ford F350 Truck:Tool Box Install 38342 VEH Wastewater Operation PURCHASED 3/13/2017 5,660 - 5,660 - - - 5,660 306 2016 Ford F350 Truck:Light Bar & Radio 38343 VEH Wastewater Operation PURCHASED 4/1/2017 2,868 - 2,868 - - - 2,868 307 Epa Grant 320651 BLD Wastewater Plant GRANT 6/15/2004 9,500 - 9,500 9,500 - - - 308 New Site Wwtp (Wrf:Water Reclamation Facility) 4880 BLD Wastewater Plant PURCHASED 7/1/1998 25,000 - 25,000 25,000 - - - 309 Wwtp Site 4881 BLD Wastewater Plant PURCHASED 5/15/2003 17,073 - 17,073 17,073 - - - 310 Air Conditioning System 4882 BLD Wastewater Plant PURCHASED 5/15/2003 14,100 - 14,100 14,100 - - - 311 Wrf Upgrade Const June Expds 488197 BLD Wastewater Plant PURCHASED 6/30/2013 32,324 - 32,324 32,324 - - - 312 Wrf Upgrade Const July Expds 488198 BLD Wastewater Plant PURCHASED 7/31/2013 12,950 - 12,950 12,950 - - - 313 Wrf Upgrade Const August Expds 488199 BLD Wastewater Plant PURCHASED 8/29/2013 9,158 - 9,158 9,158 - - - 314 Wrf Upgrade Const September Expds 488200 BLD Wastewater Plant PURCHASED 9/12/2013 1,485 - 1,485 1,485 - - - 315 Wrf Upgrade Const October Expds 488201 BLD Wastewater Plant PURCHASED 10/15/2013 28,719 - 28,719 28,719 - - - 316 Wrf Upgrade Const November Expds 488202 BLD Wastewater Plant PURCHASED 11/14/2013 5,484 - 5,484 5,484 - - - 317 Wrf Upgrade Const December Expds 488203 BLD Wastewater Plant PURCHASED 12/17/2013 5,577 - 5,577 5,577 - - - 318 Wrf Upgrade Const February Expds 488204 BLD Wastewater Plant PURCHASED 2/10/2014 10,549 - 10,549 10,549 - - - 319 Wrf Upgrade Const March Expds 488205 BLD Wastewater Plant PURCHASED 3/29/2014 27,950 - 27,950 27,950 - - - 320 Wrf Upgrade Const May Expds 488206 BLD Wastewater Plant PURCHASED 5/23/2014 22,769 - 22,769 22,769 - - - 321 Wrf Upgrade Const June Expds 488207 BLD Wastewater Plant PURCHASED 6/30/2014 32,589 - 32,589 32,589 - - - 322 Wrf Upgrade Digester #3 Constr July Expds 488208 BLD Wastewater Plant PURCHASED 7/26/2014 13,732 - 13,732 13,732 - - - 323 Wrf Upgrade Digester #3 Constr Sept Expds 488210 BLD Wastewater Plant PURCHASED 9/27/2014 14,510 - 14,510 14,510 - - - 324 Wrf Upgrade Digester #3 Constr Nov Expds 488211 BLD Wastewater Plant PURCHASED 11/10/2014 9,257 - 9,257 9,257 - - - 325 Wrf Upgrade Digester #3 Constr Dec Expds 488212 BLD Wastewater Plant PURCHASED 12/12/2014 15,935 - 15,935 15,935 - - - Page 7 of 14 Line Asset Acquired Asset Adj. General No. Description ID Type Location Acquired Date Cost Adjustments [2] Acq. Amt. Treatment Trans. Collection Plant Classification of Existing Wastewater Utility System Assets [1] Appendix A City of Bozeman, Montana Wastewater Impact Fee Study Wastewater System 329 Wrf Upgrade Digester #3 Constr March Expds 488217 BLD Wastewater Plant PURCHASED 3/1/2015 7,222 - 7,222 7,222 - - - 330 Wrf Upgrade:(2)Platforms W/Safety Railings:Chem Tk 488218 BLD Wastewater Plant PURCHASED 4/2/2015 9,905 - 9,905 9,905 - - - 331 Wrf Upgrade Digester #3 Constr April Expds 488219 BLD Wastewater Plant PURCHASED 4/8/2015 4,158 - 4,158 4,158 - - - 332 Wrf Upgrade Digester #3 Constr May Expds 488220 BLD Wastewater Plant PURCHASED 5/18/2015 6,050 - 6,050 6,050 - - - 333 Wrf Upgrade Const June Fy15 Expds 488221 BLD Wastewater Plant PURCHASED 6/26/2015 41,632 - 41,632 41,632 - - - 334 Wrf Upgrade Digester #3 Constr June Fy15 Expds 488222 BLD Wastewater Plant PURCHASED 6/30/2015 2,938 - 2,938 2,938 - - - 335 Wrf Upgrade Digester #3 Constr July Fy16 Expds 488223 BLD Wastewater Plant PURCHASED 7/30/2015 8,651 - 8,651 8,651 - - - 336 Wrf Upgrade Digester #3 Constr Aug Fy16 Expds 488224 BLD Wastewater Plant PURCHASED 8/30/2015 4,322 - 4,322 4,322 - - - 337 Wrf Upgrade Digester #3 Constr Sept Fy16 Expds 488225 BLD Wastewater Plant PURCHASED 9/30/2015 9,629 - 9,629 9,629 - - - 338 Wrf Upgrade Const Oct Fy16 Expds 488226 BLD Wastewater Plant PURCHASED 10/6/2015 265 - 265 265 - - - 339 Wrf Upgrade Digester #3 Constr Oct Fy16 Expds 488227 BLD Wastewater Plant PURCHASED 10/30/2015 1,766 - 1,766 1,766 - - - 340 Wrf Upgrade Const Nov Fy16 Expds 488228 BLD Wastewater Plant PURCHASED 11/16/2015 4,577 - 4,577 4,577 - - - 341 Wrf Upgrade Digester #3 Constr Nov Fy16 Expds 488229 BLD Wastewater Plant PURCHASED 11/30/2015 802 - 802 802 - - - 342 Wrf Upgrade Digester #3 Constr Dec Fy16 Expds 488230 BLD Wastewater Plant PURCHASED 12/26/2015 6,029 - 6,029 6,029 - - - 343 Wrf Upgrade Const Jan Fy16 Expds 488231 BLD Wastewater Plant PURCHASED 1/29/2016 4,427 - 4,427 4,427 - - - 344 Wrf Upgrade Const March Fy16 Expds 488232 BLD Wastewater Plant PURCHASED 3/31/2016 4,597 - 4,597 4,597 - - - 345 Wrf Upgrade Digester #3 Constr March Fy16 Expds 488233 BLD Wastewater Plant PURCHASED 3/2/2016 5,267 - 5,267 5,267 - - - 346 Wrf Upgrade Const May Fy16 Expds 488234 BLD Wastewater Plant PURCHASED 5/25/2016 3,665 - 3,665 3,665 - - - 347 Wrf Upgrade Const Phase 1:July Expds Fy17 488235 BLD Wastewater Plant PURCHASED 7/31/2016 2,493 - 2,493 2,493 - - - 348 Wrf Upgrade Const Phase 1:Sept Expds Fy17 488236 BLD Wastewater Plant PURCHASED 9/30/2016 3,490 - 3,490 3,490 - - - 349 Wrf Upgrade Const Phase 1:Oct Expds Fy17 488237 BLD Wastewater Plant PURCHASED 10/10/2016 13,003 - 13,003 13,003 - - - 350 Wrf Upgrade Const Phase 1:Jan Expds Fy17 488238 BLD Wastewater Plant PURCHASED 1/10/2017 6,681 - 6,681 6,681 - - - 351 Wrf Upgrade Const Phase 1:Feb Expds Fy17 488239 BLD Wastewater Plant PURCHASED 2/13/2017 10,159 - 10,159 10,159 - - - 352 Wrf Upgrade Const Phase 1:April Expds Fy17 488240 BLD Wastewater Plant PURCHASED 4/11/2017 11,295 - 11,295 11,295 - - - 353 Wrf Upgrade Const Phase 1:May Expds Fy17 488241 BLD Wastewater Plant PURCHASED 5/8/2017 3,151 - 3,151 3,151 - - - 354 New Complex 4890 BLD Wastewater Plant PURCHASED 7/1/1998 25,000 - 25,000 25,000 - - - 355 Air Conditioning System 4891 BLD Wastewater Plant PURCHASED 2/15/2002 5,300 - 5,300 5,300 - - - 356 Wastewater Treatment Plant 11770 IMP Wastewater Plant PURCHASED 7/1/1998 266,678 - 266,678 266,678 - - - 357 Wastewater Treatment Plant 11771 IMP Wastewater Plant PURCHASED 7/1/1998 316,434 - 316,434 316,434 - - - 358 Wastewater Treatment Plant 11772 IMP Wastewater Plant PURCHASED 7/1/2002 270,162 - 270,162 270,162 - - - 359 New Plant 5000 IMP Wastewater Plant PURCHASED 7/1/1998 756,830 - 756,830 756,830 - - - 360 Sludge Lagoon Expansion 25710 LAN Wastewater Plant PURCHASED 7/1/1998 599,255 - 599,255 599,255 - - - 361 Final Sludge Payment 25711 LAN Wastewater Plant PURCHASED 3/1/2000 30,000 - 30,000 30,000 - - - 362 Sewage Disposal 4830 LAN Wastewater Plant PURCHASED 7/1/1998 8,000 - 8,000 8,000 - - - 363 Wonderware Scada Software-Dec 125881 M&E Water Treatment Plant PURCHASED 12/16/2014 8,646 - 8,646 2,882 2,882 2,882 - 364 Cisco 310241 M&E Cisco Phone System PURCHASED 9/15/2002 5 - 5 - - - 5 365 Cisco 310258 M&E Cisco Phone System PURCHASED 1/15/2003 230 - 230 - - - 230 366 Cisco 310298 M&E Cisco Phone System PURCHASED 2/15/2003 3 - 3 - - - 3 367 Cisco 3102115 M&E Cisco Phone System PURCHASED 5/15/2003 209 - 209 - - - 209 368 Iseries+P7 V7Ri Os Upgrade:Sungard Srvr Operat Sys 32975 M&E City Hall:121 N.Rouse PURCHASED 6/6/2012 1,020 - 1,020 - - - 1,020 369 Hte Click2Gov:Digital Certificate-Cx 332428 M&E Hte Software PURCHASED 12/1/2006 120 - 120 - - - 120 370 Hte Click2Gov:Core Module #20061445 332437 M&E Hte Software PURCHASED 12/1/2006 620 - 620 - - - 620 371 Hte Click2Gov:Cx Utility Billing 332444 M&E Hte Software PURCHASED 12/1/2006 1,390 - 1,390 - - - 1,390 372 Hte Click2Gov:Tax Billing Module (Sid Billing) 332453 M&E Hte Software PURCHASED 12/1/2006 1,938 - 1,938 - - - 1,938 373 Hte Click2Gov:Final Core Module Install 332470 M&E Hte Software PURCHASED 3/23/2007 300 - 300 - - - 300 374 Hte Click2Gov:Tax Cc Activation Installation 332481 M&E Hte Software PURCHASED 3/23/2007 163 - 163 - - - 163 375 Hte Click2Gov:Tax Billing+Collect Final Install 332489 M&E Hte Software PURCHASED 3/23/2007 225 - 225 - - - 225 376 Hte Click2Gov:Util Cc Activation Installation 332495 M&E Hte Software PURCHASED 3/23/2007 217 - 217 - - - 217 377 Hte Click2Gov:Util Cx Final Installation 3324101 M&E Hte Software PURCHASED 3/23/2007 300 - 300 - - - 300 378 Server-Data Backup Managr:$14974.55 Split Citywide 3324146 M&E Information Technology PURCHASED 11/1/2007 599 - 599 - - - 599 379 P7-New As400 Software/Hardware 36144 M&E City Hall:121 N.Rouse PURCHASED 6/28/2011 5,187 - 5,187 - - - 5,187 380 Wrf Upgrade:Plc Software 488209 M&E Wastewater Plant PURCHASED 9/1/2014 15,039 - 15,039 15,039 - - - Page 8 of 14 Line Asset Acquired Asset Adj. General No. Description ID Type Location Acquired Date Cost Adjustments [2] Acq. Amt. Treatment Trans. Collection Plant Classification of Existing Wastewater Utility System Assets [1] Appendix A City of Bozeman, Montana Wastewater Impact Fee Study Wastewater System 384 2000 Alumacraft John Boat, Oars & Oar Locks 28830 M&E Wastewater Plant PURCHASED 6/30/2012 0 - 0 - - - 0 385 Gehl Skid Steer 29110 M&E Wastewater Plant PURCHASED 1/15/2001 14,425 - 14,425 - - - 14,425 386 Gehl Skid Steer Boom 29111 M&E Wastewater Plant PURCHASED 1/10/2001 2,650 - 2,650 - - - 2,650 387 2001 Sludge Injector (Terra-Gator) 29570 M&E Wastewater Plant PURCHASED 12/4/2000 195,790 - 195,790 - - - 195,790 388 Toro Mower 30910 M&E Wastewater Plant PURCHASED 8/23/2001 6,500 - 6,500 - - - 6,500 389 Flump (Dredge) 31850 M&E Wastewater Plant PURCHASED 3/15/2003 88,819 - 88,819 88,819 - - - 390 Flump (Dredge) 31851 M&E Wastewater Plant PURCHASED 3/15/2003 4,110 - 4,110 4,110 - - - 391 Bush Hog Rotary Cutter 32900 M&E Wastewater Plant PURCHASED 12/8/2004 5,400 - 5,400 - - - 5,400 392 Toolcat, Model 5600 32920 M&E Wastewater Plant PURCHASED 3/16/2005 39,900 - 39,900 - - - 39,900 393 Sigma Portable Sampler (Wwtp) 33880 M&E Wastewater Plant PURCHASED 11/16/2006 6,434 - 6,434 - - - 6,434 394 2008 Freighliner Semi-Truck 999Ds 34120 M&E Wastewater Plant PURCHASED 12/27/2007 92,003 - 92,003 - - - 92,003 395 2008 Freighliner Semi-Truck 999Ds 34130 M&E Wastewater Plant PURCHASED 12/27/2007 88,860 - 88,860 - - - 88,860 396 2008 Freighliner Semi-Truck 999Ds:Add Options 34131 M&E Wastewater Plant PURCHASED 1/1/2008 3,143 - 3,143 - - - 3,143 397 Lachat Quikchem 8500 Unit/Diluter & Block Digester 35980 M&E Wastewater Plant PURCHASED 10/1/2010 48,780 - 48,780 48,780 - - - 398 S650 Bobcat Skid Steer 36090 M&E Wastewater Plant PURCHASED 7/7/2011 32,943 - 32,943 - - - 32,943 399 20Yd Tub Drop Box Rolloff For Wrf:Sludge To Logan 37610 M&E Wastewater Plant PURCHASED 2/1/2015 10,642 - 10,642 10,642 - - - 400 Exterior Removeable Shade For Wrf 37770 M&E Wastewater Plant PURCHASED 6/28/2015 8,788 - 8,788 8,788 - - - 401 1982 Progress Tank Trailer 550 M&E Wastewater Plant PURCHASED 6/30/2012 0 - 0 - - - 0 402 1982 Progress Tank Trailer 21760 VEH Wastewater Plant PURCHASED 7/1/1998 28,366 - 28,366 - - - 28,366 403 1982 Toyota Pickup 3120 VEH Wastewater Plant PURCHASED 6/30/2012 0 - 0 - - - 0 404 2003 Ford F250 4X4 31300 VEH Wastewater Plant PURCHASED 6/30/2012 0 - 0 - - - 0 405 2006 Gmc Sierra Pickup For Wwtp 33310 VEH Wastewater Plant PURCHASED 6/1/2006 18,844 - 18,844 - - - 18,844 406 2006 Jeep Liberty 4X4 For Wwtp 33360 VEH Wastewater Plant PURCHASED 3/8/2006 18,558 - 18,558 - - - 18,558 407 2015 Toyota Prius (White) 37780 VEH Wastewater Plant PURCHASED 7/2/2015 22,975 - 22,975 - - - 22,975 408 1982 Chevy 4X4 Service Truck 970 VEH Wastewater Plant PURCHASED 6/30/2012 0 - 0 - - - 0 409 Epa Grant Fy02 Wastewater Facilities Proj-56Ep04 32069 IMP Wastewater Plant GRANT 6/30/2002 28,063 - 28,063 28,063 - - - 410 Epa Grant Wwtp Fy04 320614 IMP Wastewater Plant GRANT 8/31/2003 11,852 - 11,852 11,852 - - - 411 Wwtp Epa Grant Fy04 320616 IMP Wastewater Plant GRANT 9/29/2003 15,960 - 15,960 15,960 - - - 412 Wwtp Epa Grant Fy04 320617 IMP Wastewater Plant GRANT 9/16/2003 5,906 - 5,906 5,906 - - - 413 Epa Grant Fy04 Wasteater Facilities Proj 56Ep04 320619 IMP Wastewater Plant GRANT 10/15/2003 1,378 - 1,378 1,378 - - - 414 Ep Grant Fy04 Wastewater Faciltiies Proj 56Ep05 320620 IMP Wastewater Plant GRANT 10/15/2003 1,920 - 1,920 1,920 - - - 415 Epa Grant Fy04 Wastewater Facilities Proj 56Ep05 320623 IMP Wastewater Plant GRANT 11/15/2003 1,343 - 1,343 1,343 - - - 416 Epa Grant Fy04 Wastewater Facilities Proj 320624 IMP Wastewater Plant GRANT 12/15/2003 216,224 - 216,224 216,224 - - - 417 Epa Grant Fy04 Wastewater Facilities Proj 320625 IMP Wastewater Plant GRANT 12/15/2003 258,968 - 258,968 258,968 - - - 418 Epa Grant Fy04 Wastewater Facilities Proj 320627 IMP Wastewater Plant GRANT 1/15/2004 187,941 - 187,941 187,941 - - - 419 Epa Grant Fy04 Wastewater Facilities Proj 320628 IMP Wastewater Plant GRANT 1/15/2004 229,952 - 229,952 229,952 - - - 420 Epa Grant Fy04 Wastewater Faciliites Proj 320631 IMP Wastewater Plant GRANT 2/15/2004 2,742 - 2,742 2,742 - - - 421 Epa Grant Fy04 Wastewater Facilities Proj 320632 IMP Wastewater Plant GRANT 2/15/2004 14,881 - 14,881 14,881 - - - 422 Epa Grant Fy04 Wastewater Facilities Porj 320634 IMP Wastewater Plant GRANT 3/15/2004 91,335 - 91,335 91,335 - - - 423 Epa Grant Fy04 Wastewater Facilities 320635 IMP Wastewater Plant GRANT 3/15/2004 3,276 - 3,276 3,276 - - - 424 Epa Grant Fy04 Eastewater Facilities Proj-56Ep04 320637 IMP Wastewater Plant GRANT 4/15/2004 153,132 - 153,132 153,132 - - - 425 Epa Grant Fy04 Project 56Ep05 320638 IMP Wastewater Plant GRANT 4/27/2004 2,374 - 2,374 2,374 - - - 426 Epa Grant Fy04 320643 IMP Wastewater Plant GRANT 5/15/2004 1,536 - 1,536 1,536 - - - 427 Epa Grant Fy04 Wastwater Facilities 320646 IMP Wastewater Plant GRANT 6/9/2004 575,665 - 575,665 575,665 - - - 428 Epa Grant Fy04 - Wastewater Facilities 320647 IMP Wastewater Plant GRANT 6/15/2004 68,966 - 68,966 68,966 - - - 429 Epa Chronicle Ads 320649 IMP Wastewater Plant GRANT 6/15/2004 678 - 678 678 - - - 430 Epa Grant 56Ep04 320652 IMP Wastewater Plant GRANT 7/15/2004 399,674 - 399,674 399,674 - - - 431 Epa Grant 56Ep05 320653 IMP Wastewater Plant GRANT 7/15/2004 5,326 - 5,326 5,326 - - - 432 Epa Grant 56Ep04 320655 IMP Wastewater Plant GRANT 8/15/2004 433,016 - 433,016 433,016 - - - 433 Epa Grant 56Ep04 320657 IMP Wastewater Plant GRANT 9/15/2004 8,101 - 8,101 8,101 - - - 434 Epa Grant 56Ep04 320659 IMP Wastewater Plant GRANT 10/15/2004 365,953 - 365,953 365,953 - - - 435 Epa Grant 56Ep05 320660 IMP Wastewater Plant GRANT 10/15/2004 5,000 - 5,000 5,000 - - - Page 9 of 14 Line Asset Acquired Asset Adj. General No. Description ID Type Location Acquired Date Cost Adjustments [2] Acq. Amt. Treatment Trans. Collection Plant Classification of Existing Wastewater Utility System Assets [1] Appendix A City of Bozeman, Montana Wastewater Impact Fee Study Wastewater System 439 Epa Grant 56Ep04 320680 IMP Wastewater Plant GRANT 6/15/2005 152,955 - 152,955 152,955 - - - 440 N Rouse Sewer Construction Services Thru 7/15/05 320682 IMP Wastewater Plant PURCHASED 7/15/2005 9,474 - 9,474 - 9,474 - - 441 N Rouse Trunk Swr Main Setlement Agreement 9/13/05 320689 IMP Wastewater Plant PURCHASED 12/15/2005 277,709 - 277,709 - 277,709 - - 442 Epa Grant Fy01 Wastewater Facilities Proj-56Ep02 32063 BLD Wastewater Plant GRANT 6/30/2002 68,274 - 68,274 68,274 - - - 443 Epa Grant Fy02 Wastewater Facilities Proj-56Ep02 32064 BLD Wastewater Plant GRANT 6/30/2002 162,517 - 162,517 162,517 - - - 444 Epa Grant Fy03 Wastewater Facilities Proj-56Ep02 32065 BLD Wastewater Plant GRANT 7/1/2002 2,030,735 - 2,030,735 2,030,735 - - - 445 Epa Grant Fy03 Wastewater Facilities Proj-56Ep06 320612 BLD Wastewater Plant GRANT 7/1/2002 22,393 - 22,393 22,393 - - - 446 Epa Grant Wwtp Fy04 320613 BLD Wastewater Plant GRANT 8/21/2003 182,364 - 182,364 182,364 - - - 447 Wwtp Epa Fy04 320615 BLD Wastewater Plant GRANT 9/19/2003 162,593 - 162,593 162,593 - - - 448 Epa Grant Fy04 Wastewater Facilities Proj 56Ep02 320618 BLD Wastewater Plant GRANT 10/15/2003 14,710 - 14,710 14,710 - - - 449 Epa Grant Fy04 Wastewater Facilities Proj 56Ep06 320621 BLD Wastewater Plant GRANT 10/15/2003 59,929 - 59,929 59,929 - - - 450 Epa Grant Fy04 Wastewater Facilities Proj 56Ep02 320622 BLD Wastewater Plant GRANT 11/15/2003 3,128 - 3,128 3,128 - - - 451 Epa Grant Fy04 Wastewater Facilities Proj 320629 BLD Wastewater Plant GRANT 1/15/2004 124,490 - 124,490 124,490 - - - 452 Epa Grant Fy04 Wastewater Facilties Proj 320630 BLD Wastewater Plant GRANT 2/15/2004 41,111 - 41,111 41,111 - - - 453 Epa Grant Fy04 Wastewater Facilities 320633 BLD Wastewater Plant GRANT 3/15/2004 415 - 415 415 - - - 454 Epa Grant Fy04 Wastewater Facilities 320636 BLD Wastewater Plant GRANT 3/15/2004 27,476 - 27,476 27,476 - - - 455 Professional Engineering Services 320640 BLD Wastewater Plant PURCHASED 3/29/2004 13,557 - 13,557 13,557 - - - 456 Epa Grant Fy02 320642 BLD Wastewater Plant GRANT 5/15/2004 100,000 - 100,000 100,000 - - - 457 Epa Grant Fy04 320644 BLD Wastewater Plant GRANT 5/15/2004 284 - 284 284 - - - 458 Epa Grant Fy02 Wastewater Facilities 320645 BLD Wastewater Plant GRANT 6/15/2004 25,010 - 25,010 25,010 - - - 459 Epa Grant Fy04 Wastewater Facilities 320648 BLD Wastewater Plant GRANT 6/15/2004 32,092 - 32,092 32,092 - - - 460 Epa Grant 320650 BLD Wastewater Plant GRANT 6/15/2004 217,009 - 217,009 217,009 - - - 461 Epa Grant 56Ep06 320654 BLD Wastewater Plant GRANT 7/15/2004 4,709 - 4,709 4,709 - - - 462 Epa Grant 56Ep06 320656 BLD Wastewater Plant GRANT 8/15/2004 466,149 - 466,149 466,149 - - - 463 Epa Grant 56Ep06 320658 BLD Wastewater Plant GRANT 9/15/2004 180,208 - 180,208 180,208 - - - 464 Epa Grand 56Ep06 320661 BLD Wastewater Plant GRANT 10/15/2004 9,496 - 9,496 9,496 - - - 465 Epa Grant 56Ep06 320663 BLD Wastewater Plant GRANT 11/15/2004 542,285 - 542,285 542,285 - - - 466 Epa Grant 320665 BLD Wastewater Plant GRANT 12/15/2004 479,119 - 479,119 479,119 - - - 467 Epa Grant 56E906 320668 BLD Wastewater Plant GRANT 3/15/2005 24,094 - 24,094 24,094 - - - 468 Epa Grant Fy06 320670 BLD Wastewater Plant GRANT 4/15/2005 7,998 - 7,998 7,998 - - - 469 Epa Grant 56Ep06 320672 BLD Wastewater Plant GRANT 5/15/2005 263,892 - 263,892 263,892 - - - 470 Epa Grant 56Ep06 320681 BLD Wastewater Plant GRANT 6/15/2005 9,929 - 9,929 9,929 - - - 471 2003 Wwtp Clarifier/Hdwks Scada-Svcs Thru 8/12/05 320683 BLD Wastewater Plant PURCHASED 8/12/2005 3,512 - 3,512 3,512 - - - 472 2003 Epa Wwtp Mod Project Services Thru 9/9/05 320684 BLD Wastewater Plant GRANT 9/9/2005 4,141 - 4,141 4,141 - - - 473 2003 Wwtp Modification:Final Payment +1% Dor 320685 BLD Wastewater Plant PURCHASED 10/1/2005 83,662 - 83,662 83,662 - - - 474 Trolley Hoist Install-Headworks:Epa Grant 320686 BLD Wastewater Plant GRANT 10/19/2005 8,497 - 8,497 8,497 - - - 475 Wwtp Modif Project Const Insp Thru 10/14-11/11/05 320687 BLD Wastewater Plant PURCHASED 11/11/2005 8,248 - 8,248 8,248 - - - 476 Change Orders-Trolley Crane Epa Wwtp Fac Grant 320688 BLD Wastewater Plant GRANT 11/21/2005 1,710 - 1,710 1,710 - - - 477 Wwtp Modif Project Prof Svcs 11/11-12/09/05 320690 BLD Wastewater Plant PURCHASED 12/9/2005 3,999 - 3,999 3,999 - - - 478 03 Wwtp Clarifier/Hdwks Scada/Svcs Thru 4/28/06 320691 BLD Wastewater Plant PURCHASED 5/1/2006 147 - 147 147 - - - 479 Epa Grant Fy01 Wastewater Facilities Proj-56Ep03 32066 IMP Wastewater Plant GRANT 6/30/2002 78,700 - 78,700 78,700 - - - 480 Epa Grant Fy02 Wastewater Facilities Proj-56Ep03 32067 IMP Wastewater Plant GRANT 6/30/2002 9,700 - 9,700 9,700 - - - 481 Epa Grant Fy03 Wastewater Facilities Proj-56Ep03 32068 IMP Wastewater Plant GRANT 7/1/2002 529,845 - 529,845 529,845 - - - 482 Epa Grant Fy03 Wasetwater Facilities Proj-56Ep04 320610 IMP Wastewater Plant GRANT 7/1/2002 118,263 - 118,263 118,263 - - - 483 Epa Grant Fy03 Wastewater Facilities Proj-56Ep05 320611 IMP Wastewater Plant GRANT 7/1/2002 100,066 - 100,066 100,066 - - - 484 Epa Grant General Entries Facilities Proj-56Ep01 32060 IMP Wastewater Plant GRANT 6/30/2002 157,484 - 157,484 157,484 - - - 485 Epa Grant Fy01 Wastewater Facilities Proj-56Ep01 32061 IMP Wastewater Plant GRANT 6/30/2002 213 - 213 213 - - - 486 Epa Grant Fy02 Wastewater Facilities Proj-56Ep01 32062 IMP Wastewater Plant GRANT 6/30/2002 4,049 - 4,049 4,049 - - - 487 Software System 320641 M&E Wastewater Plant PURCHASED 4/15/2004 21,384 - 21,384 - - - 21,384 488 Wwtp 4883 BLD Wastewater Plant PURCHASED 9/25/2003 580 - 580 580 - - - 489 Building Design Wwtp 4884 BLD Wastewater Plant PURCHASED 3/15/2005 2,369 - 2,369 2,369 - - - 490 Wwtp Storage Building 4885 BLD Wastewater Plant PURCHASED 4/15/2005 1,957 - 1,957 1,957 - - - Page 10 of 14 Line Asset Acquired Asset Adj. General No. Description ID Type Location Acquired Date Cost Adjustments [2] Acq. Amt. Treatment Trans. Collection Plant Classification of Existing Wastewater Utility System Assets [1] Appendix A City of Bozeman, Montana Wastewater Impact Fee Study Wastewater System 494 Wwtp Storage Building Bidding & Neg Svcs-10/14 4889 BLD Wastewater Plant PURCHASED 10/14/2005 853 - 853 853 - - - 495 Wwtp Maint Bldg Eng Svc Thru 11/14/05 48810 BLD Wastewater Plant PURCHASED 11/4/2005 833 - 833 833 - - - 496 Light Fixtures(27)/Lamps-60 48811 BLD Wastewater Plant PURCHASED 12/23/2005 2,633 - 2,633 2,633 - - - 497 Wwtp Maint Bldg Constr Phase Svcs Thru 12/16/05 48812 BLD Wastewater Plant PURCHASED 12/16/2005 1,331 - 1,331 1,331 - - - 498 Wwtp Storage Bldg Proj(Ingrm-Clev&Mm) Const+1%Dor 48813 BLD Wastewater Plant PURCHASED 1/1/2006 103,089 - 103,089 103,089 - - - 499 2003 Wwtp Modifications Insp Svcs 12/10-1/27/06 48814 BLD Wastewater Plant PURCHASED 2/1/2006 3,314 - 3,314 3,314 - - - 500 Wwtp Maint Bldg 01/27/06 Construction Phase Svcs 48815 BLD Wastewater Plant PURCHASED 2/1/2006 428 - 428 428 - - - 501 Wwtp Storage Bldg Project Const Svcs Thru 3/24/06 48816 BLD Wastewater Plant PURCHASED 3/24/2006 108,910 - 108,910 108,910 - - - 502 Wwtp Storage Bldg Project Const Svcs Thru 4/24/06 48817 BLD Wastewater Plant PURCHASED 4/24/2006 139,761 - 139,761 139,761 - - - 503 Wwtp Storage Bldg Project Const Svcs Thru 5/22/06 48818 BLD Wastewater Plant PURCHASED 5/23/2006 46,460 - 46,460 46,460 - - - 504 Wwtp Storage Bldg Project Const Svcs Thru 6/28/06 48819 BLD Wastewater Plant PURCHASED 6/28/2006 56,612 - 56,612 56,612 - - - 505 Wwtp Reroofing Project-3/1-5/31/06///Thinkone Dba 48820 BLD Wastewater Plant PURCHASED 6/8/2006 5,325 - 5,325 5,325 - - - 506 Landscaping/Edging & Replace Faulty Wall Station 48821 BLD Wastewater Plant PURCHASED 7/7/2006 847 - 847 - - - 847 507 Wwtp Reroofing Proj Design Svcs 7/1-7/31/06 48822 BLD Wastewater Plant PURCHASED 7/31/2006 715 - 715 715 - - - 508 Wwtp Roofing Proj 8/06 Design & Bidding Services 48823 BLD Wastewater Plant PURCHASED 9/19/2006 3,195 - 3,195 3,195 - - - 509 Wwtp Reroofing Proj:Bidding Svcs 2/1-2/28/07 48824 BLD Wastewater Plant PURCHASED 2/28/2007 717 - 717 717 - - - 510 Wwtp Upgrade-Early Out Prof Svcs Thru 2/3/07 48825 BLD Wastewater Plant PURCHASED 2/20/2007 9,770 - 9,770 9,770 - - - 511 Wwtp Early Out Proj:Design Svcs Thru 2/16/07 48826 BLD Wastewater Plant PURCHASED 3/1/2007 35,142 - 35,142 35,142 - - - 512 Wwtp Early Out Proj:Design Svcs Thru 3/31/07 48827 BLD Wastewater Plant PURCHASED 3/31/2007 2,997 - 2,997 2,997 - - - 513 Wwtp Reroofing Proj:Bidding Svcs 3/1-4/20/07 48828 BLD Wastewater Plant PURCHASED 4/23/2007 2,968 - 2,968 2,968 - - - 514 Wwtp Upgrade Proj:Design Svcs Thru 3/31/07 48829 BLD Wastewater Plant PURCHASED 4/30/2007 5,424 - 5,424 5,424 - - - 515 Wwtp Early Out Proj:Design Svcs Thru 3/31/07 48830 BLD Wastewater Plant PURCHASED 4/30/2007 22,034 - 22,034 22,034 - - - 516 Wwtp Reroofing Proj:Bidding/Nego 4/23-27 & 5/1/07 48831 BLD Wastewater Plant PURCHASED 5/29/2007 788 - 788 788 - - - 517 Wwtp Upgrade Proj:Design Svcs Thru 4/28/07 48832 BLD Wastewater Plant PURCHASED 6/11/2007 22,871 - 22,871 22,871 - - - 518 Wwtp Early Out Proj:Design Svcs Thru 4/28/07 48833 BLD Wastewater Plant PURCHASED 6/11/2007 21,192 - 21,192 21,192 - - - 519 Wwtp Upgrade Proj:Ph I-Design Svcs Thru 6/30/07 48834 BLD Wastewater Plant PURCHASED 6/30/2007 111,987 - 111,987 111,987 - - - 520 Wwtp Upgrade Proj:Design Svcs Thru 6/30/07 48835 BLD Wastewater Plant PURCHASED 6/30/2007 11,440 - 11,440 11,440 - - - 521 Wwtp Early Out Proj:Design Svcs 7/1-8/4/07 48836 BLD Wastewater Plant PURCHASED 7/31/2007 1,306 - 1,306 1,306 - - - 522 Wwtp Reroofing Proj:Bidding Svc 5/21-7/31 48837 BLD Wastewater Plant PURCHASED 8/7/2007 2,767 - 2,767 2,767 - - - 523 Wwtp Reroofing Proj:Constr Admin Svcs 8/7-8/22/07 48838 BLD Wastewater Plant PURCHASED 8/31/2007 1,380 - 1,380 1,380 - - - 524 Wwtp Upgrade Proj:Design Svcs Thru 8/4/07 48839 BLD Wastewater Plant PURCHASED 8/9/2007 145,079 - 145,079 145,079 - - - 525 Wwtp Upgrade Proj:Design Svcs Thru 9/1/07 48840 BLD Wastewater Plant PURCHASED 8/31/2007 2,565 - 2,565 2,565 - - - 526 Wwtp Reroofing Proj:Constr Svcs Thru 8/31/07 48841 BLD Wastewater Plant PURCHASED 9/1/2007 101,762 - 101,762 101,762 - - - 527 Wwtp Reroofing:1% Grt (Metalworks) Thru 8/31/07 48842 BLD Wastewater Plant PURCHASED 9/1/2007 1,028 - 1,028 1,028 - - - 528 Wwtp Upgrade Proj:Design Svcs Thru 9/1/07 Ph 1 48843 BLD Wastewater Plant PURCHASED 9/27/2007 285,402 - 285,402 285,402 - - - 529 Wwtp Upgrade Proj:Constr Svcs Thru 9/29/07 48844 BLD Wastewater Plant PURCHASED 9/30/2007 5,173 - 5,173 5,173 - - - 530 Wwtp Upgrade Proj:Design Svcs Thru 9/29/07 48845 BLD Wastewater Plant PURCHASED 9/30/2007 172,447 - 172,447 172,447 - - - 531 Wwtp Early Out:Constr Svcs Thru 11/08/07 Phase I 48846 BLD Wastewater Plant PURCHASED 10/31/2007 46,089 - 46,089 46,089 - - - 532 Wwtp Early Out:Constr Svcs Thru 11/08/07 1%Grt 48847 BLD Wastewater Plant PURCHASED 10/31/2007 466 - 466 466 - - - 533 Wwtp Early Out:Mixer Equip Purchase Phase I 48848 BLD Wastewater Plant PURCHASED 10/31/2007 25,305 - 25,305 25,305 - - - 534 Wwtp Modifications Discharge Permit App Fee 48850 BLD Wastewater Plant PURCHASED 11/7/2007 4,000 - 4,000 4,000 - - - 535 Wwtp Upgrade Proj:Constr Svcs Thru 10/27/07 48851 BLD Wastewater Plant PURCHASED 11/12/2007 2,637 - 2,637 2,637 - - - 536 Wwtp Upgrade Proj:Design Svcs Thru 11/24/07 48852 BLD Wastewater Plant PURCHASED 11/30/2007 234,044 - 234,044 234,044 - - - 537 Wwtp Upgrade Proj:Design Svcs Thru 10/27/07 48853 BLD Wastewater Plant PURCHASED 11/30/2007 5,960 - 5,960 5,960 - - - 538 Wwtp Early Out:Constr Svcs Thru 12/14/07 Phase I 48855 BLD Wastewater Plant PURCHASED 12/18/2007 3,207 - 3,207 3,207 - - - 539 Wwtp Early Out:Constr Svcs Thru 12/14/07 1%Grt 48856 BLD Wastewater Plant PURCHASED 12/14/2007 32 - 32 32 - - - 540 Wwtp Early Out:Mixer Equip Purchase Phase I 48857 BLD Wastewater Plant PURCHASED 12/18/2007 15,816 - 15,816 15,816 - - - 541 Wwtp Early Out:Inspection Svcs 11/25-12/29/07 48858 BLD Wastewater Plant PURCHASED 12/29/2007 2,965 - 2,965 2,965 - - - 542 Wwtp Upgrade Proj:Design Svcs Thru 12/29/07 48859 BLD Wastewater Plant PURCHASED 12/29/2007 407,030 - 407,030 407,030 - - - 543 Wwtp Upgrade Proj:Design Svcs Thru 10/27/07 48860 BLD Wastewater Plant PURCHASED 12/31/2007 177,596 - 177,596 177,596 - - - 544 Wwtp Upgrade Proj:Planning Review Fees 48861 BLD Wastewater Plant PURCHASED 1/22/2008 400 - 400 400 - - - 545 Wwtp Upgrade Proj:Design Svcs Thru 2/2/08 48862 BLD Wastewater Plant PURCHASED 1/31/2008 439,551 - 439,551 439,551 - - - Page 11 of 14 Line Asset Acquired Asset Adj. General No. Description ID Type Location Acquired Date Cost Adjustments [2] Acq. Amt. Treatment Trans. Collection Plant Classification of Existing Wastewater Utility System Assets [1] Appendix A City of Bozeman, Montana Wastewater Impact Fee Study Wastewater System 549 Wwtp Early Out:Constr Svcs Thru 04/21/08 1% Grt 48866 BLD Wastewater Plant PURCHASED 4/21/2008 57 - 57 57 - - - 550 Wwtp Upgrade Proj:Design Svcs Thru 3/29/08 48869 BLD Wastewater Plant PURCHASED 5/12/2008 253,286 - 253,286 253,286 - - - 551 Wwtp Early Out:Mixer Equip Purchase Phase I 48870 BLD Wastewater Plant PURCHASED 5/27/2008 3,274 - 3,274 3,274 - - - 552 Wwtp Upgrade Proj:Design Svcs Thru 5/24/08 48871 BLD Wastewater Plant PURCHASED 6/19/2008 295,523 - 295,523 295,523 - - - 553 Wwtp Expansion Review 5/1/08-5/7/08 48872 BLD Wastewater Plant PURCHASED 6/1/2008 763 - 763 763 - - - 554 Wwtp Upgrade Proj:Design Svcs Thru 6/28/08 48873 BLD Wastewater Plant PURCHASED 6/28/2008 149,797 - 149,797 149,797 - - - 555 Wwtp Upgrade Proj:Planning Review Fees 48874 BLD Wastewater Plant PURCHASED 7/7/2008 1,850 - 1,850 1,850 - - - 556 Wwtp Upgrade Proj:Design Svcs Thru 8/18/08 48875 BLD Wastewater Plant PURCHASED 8/26/2008 102,544 - 102,544 102,544 - - - 557 Wwtp Upgrade Proj:Pump,Flanges & Control Panel 48876 BLD Wastewater Plant PURCHASED 9/2/2008 48,060 - 48,060 48,060 - - - 558 Wwtp Upgrade Proj:Design Svcs Thru 8/30/08 48877 BLD Wastewater Plant PURCHASED 9/17/2008 63,682 - 63,682 63,682 - - - 559 Wwtp Early Out:Constr Svcs Thru 10/03/08 Phase I 48878 BLD Wastewater Plant PURCHASED 9/25/2008 10,405 - 10,405 10,405 - - - 560 Wwtp Upgrade Proj:Fsp Review Fee 48879 BLD Wastewater Plant PURCHASED 9/30/2008 1,313 - 1,313 1,313 - - - 561 Wwtp Early Out:Constr Svcs Thru 10/03/08 1%Grt 48880 BLD Wastewater Plant PURCHASED 9/30/2008 105 - 105 105 - - - 562 Wwtp Upgrade Proj:Design Svcs Thru 9/27/08 48881 BLD Wastewater Plant PURCHASED 10/30/2008 80,027 - 80,027 80,027 - - - 563 Wwtp Upgrade Proj:Design Svcs Thru 11/22/08 48882 BLD Wastewater Plant PURCHASED 11/30/2008 179,563 - 179,563 179,563 - - - 564 Wwtp Upgrade Proj:Design Svcs Thru 12/27/08 48883 BLD Wastewater Plant PURCHASED 1/14/2009 20,287 - 20,287 20,287 - - - 565 Wwtp Upgrade Proj:Design Svcs Thru 01/31/09 48884 BLD Wastewater Plant PURCHASED 2/17/2009 49,257 - 49,257 49,257 - - - 566 Wrf Upgrade Ph.1:Const Svcs Thru 01/31/09 Pmt#1 48885 BLD Wastewater Plant PURCHASED 2/19/2009 328,613 - 328,613 328,613 - - - 567 Wrf Upgrade Ph.1:1%Grt (Williams) Pmt#1 Thru 01/31 48886 BLD Wastewater Plant PURCHASED 2/19/2009 3,319 - 3,319 3,319 - - - 568 Wrf Upgrade Ph.1:Fsp Planning Review Fees 48887 BLD Wastewater Plant PURCHASED 2/27/2009 220 - 220 220 - - - 569 Wrf Upgrade Ph.1:Legal 2001/Bid Ad 48888 BLD Wastewater Plant PURCHASED 3/1/2009 253 - 253 253 - - - 570 Wrf Upgrade Ph.1:Building Inspection Admin Costs 48889 BLD Wastewater Plant PURCHASED 3/1/2009 3,591 - 3,591 3,591 - - - 571 Wrf Upgrade Ph.1:Boundary Realignmnt Tr 1 Cos 1015 48890 BLD Wastewater Plant PURCHASED 3/6/2009 1,142 - 1,142 1,142 - - - 572 Wwtp Upgrade Proj:Design Svcs Thru 02/28/09 48891 BLD Wastewater Plant PURCHASED 3/16/2009 13,085 - 13,085 13,085 - - - 573 Wrf Upgrade Ph.1:Const Admin Svcs Thru 02/28/09 48892 BLD Wastewater Plant PURCHASED 3/16/2009 60,055 - 60,055 60,055 - - - 574 Wrf Upgrade Ph.1:Const Svcs Thru 04/07/09 Pmt#2 48893 BLD Wastewater Plant PURCHASED 3/31/2009 872,282 - 872,282 872,282 - - - 575 Wrf Upgrade Ph.1:1%Grt (Williams) Pmt#2 Thru 04/07 48894 BLD Wastewater Plant PURCHASED 3/31/2009 8,811 - 8,811 8,811 - - - 576 Wwtp Upgrade:Bldg Permits 255 Moss Bridge Rd 48895 BLD Wastewater Plant PURCHASED 4/3/2009 834 - 834 834 - - - 577 Wwtp Upgrade Proj:Design Svcs Thru 04/09/09 48896 BLD Wastewater Plant PURCHASED 4/20/2009 9,780 - 9,780 9,780 - - - 578 Wrf Upgrade Ph.1:Const Admin Svcs Thru 04/09/09 48897 BLD Wastewater Plant PURCHASED 4/20/2009 48,260 - 48,260 48,260 - - - 579 Wwtp Upgrade:Bldg Permits 255 Moss Bridge Rd 48898 BLD Wastewater Plant PURCHASED 4/24/2009 1,934 - 1,934 1,934 - - - 580 Wrf Upgrade Ph.1:Const Svcs Thru 04/30/09 Pmt#3 48899 BLD Wastewater Plant PURCHASED 4/30/2009 207,934 - 207,934 207,934 - - - 581 Wrf Upgrade Ph.1:1%Grt (Williams) Pmt#3 Thru 04/30 488100 BLD Wastewater Plant PURCHASED 4/30/2009 2,100 - 2,100 2,100 - - - 582 Wrf Upgrade Ph.1:Const Admin Svcs Thru 04/25/09 488101 BLD Wastewater Plant PURCHASED 5/7/2009 70,397 - 70,397 70,397 - - - 583 Wrf Upgrade:Bldg Insp Permits 255 Moss Bridge Rd 488102 BLD Wastewater Plant PURCHASED 5/14/2009 5,420 - 5,420 5,420 - - - 584 Wrf Upgrade:Bldg Insp Permits 255 Moss Bridge Rd 488103 BLD Wastewater Plant PURCHASED 5/22/2009 5,862 - 5,862 5,862 - - - 585 Wrf Upgrade Ph 1:Fence Relocation/Gate Installatn 488104 BLD Wastewater Plant PURCHASED 5/31/2009 1,690 - 1,690 1,690 - - - 586 Wrf Upgrade Ph.1:Const Svcs Thru 05/31/09 Pmt#4 488105 BLD Wastewater Plant PURCHASED 5/31/2009 1,833,060 - 1,833,060 1,833,060 - - - 587 Wrf Upgrade Ph.1:1%Grt (Williams) Pmt#4 Thru 05/31 488106 BLD Wastewater Plant PURCHASED 5/31/2009 18,516 - 18,516 18,516 - - - 588 Wrf Upgrade Ph.1:Prof Svcs Thru 05/29/09 488107 BLD Wastewater Plant PURCHASED 6/1/2009 8,439 - 8,439 8,439 - - - 589 Wrf Upgrade Ph.1:Prof Svcs Thru 05/29/09 488108 BLD Wastewater Plant PURCHASED 6/1/2009 1,623 - 1,623 1,623 - - - 590 Wrf Upgrade Ph.1:Const Admin Svcs Thru 05/28/09 488109 BLD Wastewater Plant PURCHASED 6/15/2009 79,187 - 79,187 79,187 - - - 591 Wrf Upgrade Ph.1:Const Admin Svcs Thru 04/25/09 488110 BLD Wastewater Plant PURCHASED 6/15/2009 8,864 - 8,864 8,864 - - - 592 Wrf Upgrade Ph.1:Design Svcs Thru 06/27/09 488111 BLD Wastewater Plant PURCHASED 6/27/2009 36,833 - 36,833 36,833 - - - 593 Wrf Upgrade Ph.1:Const Admin Svcs Thru 06/27/09 488112 BLD Wastewater Plant PURCHASED 6/27/2009 99,192 - 99,192 99,192 - - - 594 Wrf Upgrade Ph.1:Const Svcs Thru 06/30/09 Pmt#5 488113 BLD Wastewater Plant PURCHASED 6/30/2009 1,932,387 - 1,932,387 1,932,387 - - - 595 Wrf Upgrade Ph.1:1%Grt (Williams) Pmt#5 Thru 06/30 488114 BLD Wastewater Plant PURCHASED 6/30/2009 19,519 - 19,519 19,519 - - - 596 Wrf Upgrade Constr July Expds 488115 BLD Wastewater Plant PURCHASED 7/31/2009 1,987,040 - 1,987,040 1,987,040 - - - 597 Wrf Upgrade Constr August Expds 488116 BLD Wastewater Plant PURCHASED 8/31/2009 1,892,092 - 1,892,092 1,892,092 - - - 598 Wrf Upgrade Constr September Expds 488117 BLD Wastewater Plant PURCHASED 9/30/2009 2,518,150 - 2,518,150 2,518,150 - - - 599 Wrf Upgrade Constr October Expds 488118 BLD Wastewater Plant PURCHASED 10/28/2009 1,908,493 - 1,908,493 1,908,493 - - - 600 Wrf Upgrade Constr November Expds 488119 BLD Wastewater Plant PURCHASED 11/30/2009 1,326,731 - 1,326,731 1,326,731 - - - Page 12 of 14 Line Asset Acquired Asset Adj. General No. Description ID Type Location Acquired Date Cost Adjustments [2] Acq. Amt. Treatment Trans. Collection Plant Classification of Existing Wastewater Utility System Assets [1] Appendix A City of Bozeman, Montana Wastewater Impact Fee Study Wastewater System 604 Wrf Upgrade Constr March Expds 488123 BLD Wastewater Plant PURCHASED 3/31/2010 1,747,994 - 1,747,994 1,747,994 - - - 605 Wrf Upgrade Constr April Expds 488124 BLD Wastewater Plant PURCHASED 4/12/2010 110,944 - 110,944 110,944 - - - 606 Wrf Upgrade Constr May Expds 488125 BLD Wastewater Plant PURCHASED 5/31/2010 1,372,290 - 1,372,290 1,372,290 - - - 607 Wrf Upgrade Admin/Lab Constr May Expds 488126 BLD Wastewater Plant PURCHASED 5/10/2010 10,000 - 10,000 10,000 - - - 608 Wrf Upgrade Digester #3 Constr May Expds 488127 BLD Wastewater Plant PURCHASED 5/31/2010 96,602 - 96,602 96,602 - - - 609 Wrf Upgrade Constr June Expds 488128 BLD Wastewater Plant PURCHASED 6/30/2010 1,460,570 - 1,460,570 1,460,570 - - - 610 Wrf Upgrade Admin/Lab Constr June Expds 488129 BLD Wastewater Plant PURCHASED 6/30/2010 139,629 - 139,629 139,629 - - - 611 Wrf Upgrade Digester #3 Constr June Expds 488130 BLD Wastewater Plant PURCHASED 6/10/2010 15,000 - 15,000 15,000 - - - 612 Wrf Upgrade Constr July Expds 488131 BLD Wastewater Plant PURCHASED 7/22/2010 128,608 - 128,608 128,608 - - - 613 Wrf Upgrade Admin/Lab Constr July Expds 488132 BLD Wastewater Plant PURCHASED 7/20/2010 2,742 - 2,742 2,742 - - - 614 Wrf Upgrade Digester #3 Constr July Expds 488133 BLD Wastewater Plant PURCHASED 7/12/2010 101,090 - 101,090 101,090 - - - 615 Wrf Upgrade Admin/Lab Constr Aug Expds 488134 BLD Wastewater Plant PURCHASED 8/1/2010 65,427 - 65,427 65,427 - - - 616 Wrf Upgrade Constr Aug Expds 488135 BLD Wastewater Plant PURCHASED 8/13/2010 1,419,927 - 1,419,927 1,419,927 - - - 617 Wrf Upgrade Digester #3 Constr Aug Expds 488136 BLD Wastewater Plant PURCHASED 8/13/2010 117,725 - 117,725 117,725 - - - 618 Wrf Upgrade Constr Sept Expds 488137 BLD Wastewater Plant PURCHASED 9/30/2010 1,486,103 - 1,486,103 1,486,103 - - - 619 Wrf Upgrade Admin/Lab Constr Sept Expds 488138 BLD Wastewater Plant PURCHASED 9/30/2010 227,364 - 227,364 227,364 - - - 620 Wrf Upgrade Digester #3 Constr Sept Expds 488139 BLD Wastewater Plant PURCHASED 9/30/2010 430,873 - 430,873 430,873 - - - 621 Wrf Upgrade Constr Oct Expds 488140 BLD Wastewater Plant PURCHASED 10/31/2010 1,112,965 - 1,112,965 1,112,965 - - - 622 Wrf Upgrade Admin/Lab Constr Oct Expds 488141 BLD Wastewater Plant PURCHASED 10/31/2010 38,371 - 38,371 38,371 - - - 623 Wrf Upgrade Digester #3 Constr Oct Expds 488142 BLD Wastewater Plant PURCHASED 10/31/2010 299,635 - 299,635 299,635 - - - 624 Wrf Upgrade Constr Nov Expds 488143 BLD Wastewater Plant PURCHASED 11/30/2010 1,125,019 - 1,125,019 1,125,019 - - - 625 Wrf Upgrade Admin/Lab Constr Nov Expds 488144 BLD Wastewater Plant PURCHASED 11/30/2010 18,088 - 18,088 18,088 - - - 626 Wrf Upgrade Digester #7 Constr Nov Expds 488145 BLD Wastewater Plant PURCHASED 11/30/2010 290,030 - 290,030 290,030 - - - 627 Wrf Upgrade Constr Dec Expds 488146 BLD Wastewater Plant PURCHASED 12/31/2010 972,325 - 972,325 972,325 - - - 628 Wrf Upgrade Admin/Lab Constr Dec Expds 488147 BLD Wastewater Plant PURCHASED 12/31/2010 40,307 - 40,307 40,307 - - - 629 Wrf Upgrade Digester #8 Constr Dec Expds 488148 BLD Wastewater Plant PURCHASED 12/31/2010 683,166 - 683,166 683,166 - - - 630 Wrf Upgrade Constr Jan Expds 488149 BLD Wastewater Plant PURCHASED 1/25/2011 1,271,505 - 1,271,505 1,271,505 - - - 631 Wrf Upgrade Admin/Lab Constr Jan Expds 488150 BLD Wastewater Plant PURCHASED 1/31/2011 267,047 - 267,047 267,047 - - - 632 Wrf Upgrade Digester #8 Constr Jan Expds 488151 BLD Wastewater Plant PURCHASED 1/28/2011 685,686 - 685,686 685,686 - - - 633 Wrf Upgrade Constr Feb Expds 488152 BLD Wastewater Plant PURCHASED 2/22/2011 882,515 - 882,515 882,515 - - - 634 Wrf Upgrade Admin/Lab Constr Feb Expds 488153 BLD Wastewater Plant PURCHASED 2/28/2011 135,698 - 135,698 135,698 - - - 635 Wrf Upgrade Constr March Expds 488154 BLD Wastewater Plant PURCHASED 3/29/2011 249,021 - 249,021 249,021 - - - 636 Wrf Upgrade Digester #10 Constr March Expds 488155 BLD Wastewater Plant PURCHASED 3/29/2011 1,161,004 - 1,161,004 1,161,004 - - - 637 Wrf Upgrade Constr April Expds 488156 BLD Wastewater Plant PURCHASED 4/1/2011 1,595,262 - 1,595,262 1,595,262 - - - 638 Wrf Upgrade Admin/Lab Constr April Expds 488157 BLD Wastewater Plant PURCHASED 4/19/2011 528,036 - 528,036 528,036 - - - 639 Wrf Upgrade Digester #10 Constr April Expds 488158 BLD Wastewater Plant PURCHASED 4/21/2011 16,121 - 16,121 16,121 - - - 640 Wrf Upgrade Constr May Expds 488159 BLD Wastewater Plant PURCHASED 5/31/2011 136,721 - 136,721 136,721 - - - 641 Wrf Upgrade Constr May Expds 488160 BLD Wastewater Plant PURCHASED 5/31/2011 701,887 - 701,887 701,887 - - - 642 Wrf Upgrade Admin/Lab Constr May Expds 488161 BLD Wastewater Plant PURCHASED 5/31/2011 65,250 - 65,250 65,250 - - - 643 Wrf Upgrade Digester #12 Constr May Expds 488162 BLD Wastewater Plant PURCHASED 5/31/2011 865,737 - 865,737 865,737 - - - 644 Wrf Upgrade Constr June Expds 488163 BLD Wastewater Plant PURCHASED 6/30/2011 677,323 - 677,323 677,323 - - - 645 Wrf Upgrade Admin/Lab Constr June Expds 488164 BLD Wastewater Plant PURCHASED 6/30/2011 17,788 - 17,788 17,788 - - - 646 Wrf Upgrade Digester Constr June Expds Fy11 488165 BLD Wastewater Plant PURCHASED 6/30/2011 26,331 - 26,331 26,331 - - - 647 Wrf Upgrade Constr July Expds 488166 BLD Wastewater Plant PURCHASED 7/31/2011 531,045 - 531,045 531,045 - - - 648 Wrf Upgrade Admin/Lab Constr July Expds 488167 BLD Wastewater Plant PURCHASED 7/31/2011 5,501 - 5,501 5,501 - - - 649 Wrf Upgrade Digester Constr July Expds 488168 BLD Wastewater Plant PURCHASED 7/21/2011 218,006 - 218,006 218,006 - - - 650 Wrf Upgrade Constr August Expds 488169 BLD Wastewater Plant PURCHASED 8/29/2011 614,391 - 614,391 614,391 - - - 651 Wrf Upgrade Constr September Expds 488170 BLD Wastewater Plant PURCHASED 9/30/2011 631,804 - 631,804 631,804 - - - 652 Wrf Upgrade Digester Constr Sept Expds 488171 BLD Wastewater Plant PURCHASED 9/22/2011 117,682 - 117,682 117,682 - - - 653 Wrf Upgrade Constr October Expds 488172 BLD Wastewater Plant PURCHASED 10/1/2011 929,903 - 929,903 929,903 - - - 654 Wrf Upgrade Admin/Lab Constr October Expds 488173 BLD Wastewater Plant PURCHASED 10/30/2011 42,950 - 42,950 42,950 - - - 655 Wrf Upgrade Constr November Expds 488174 BLD Wastewater Plant PURCHASED 11/1/2011 4,236 - 4,236 4,236 - - - Page 13 of 14 Line Asset Acquired Asset Adj. General No. Description ID Type Location Acquired Date Cost Adjustments [2] Acq. Amt. Treatment Trans. Collection Plant Classification of Existing Wastewater Utility System Assets [1] Appendix A City of Bozeman, Montana Wastewater Impact Fee Study Wastewater System 659 Wrf Upgrade Const March Expds 488178 BLD Wastewater Plant PURCHASED 3/31/2012 830,982 - 830,982 830,982 - - - 660 Wrf Upgrade Admin/Lab Constr March Expds 488179 BLD Wastewater Plant PURCHASED 3/1/2012 57,217 - 57,217 57,217 - - - 661 Wrf Upgrade Const April Expds 488180 BLD Wastewater Plant PURCHASED 4/17/2012 227,846 - 227,846 227,846 - - - 662 Wrf Upgrade Const May Expds 488181 BLD Wastewater Plant PURCHASED 5/22/2012 1,125,057 - 1,125,057 1,125,057 - - - 663 Wrf Upgrade Const June Expds 488182 BLD Wastewater Plant PURCHASED 6/29/2012 209,333 - 209,333 209,333 - - - 664 Wrf Upgrade Const July Expds 488183 BLD Wastewater Plant PURCHASED 7/31/2012 52,264 - 52,264 52,264 - - - 665 Wrf Upgrade Const August Expds 488184 BLD Wastewater Plant PURCHASED 8/10/2012 2,840 - 2,840 2,840 - - - 666 Wrf Base Constrctn Retainage Thru 6/30/12 488185 BLD Wastewater Plant PURCHASED 6/29/2012 909,728 - 909,728 909,728 - - - 667 Wrf Admin Lab Cons Retainage Thru 6/30/12 488186 BLD Wastewater Plant PURCHASED 6/29/2012 43,467 - 43,467 43,467 - - - 668 Digester #3 Constr Retainage Thru 6/30/12 Fy12 488187 BLD Wastewater Plant PURCHASED 6/29/2012 265,094 - 265,094 265,094 - - - 669 Wrf Upgrade Const Sept Expds 488188 BLD Wastewater Plant PURCHASED 9/30/2012 34,747 - 34,747 34,747 - - - 670 Wrf Upgrade Const Oct Expds 488190 BLD Wastewater Plant PURCHASED 10/31/2012 325,265 - 325,265 325,265 - - - 671 Wrf Upgrade Const Nov Expds 488191 BLD Wastewater Plant PURCHASED 11/30/2012 41,810 - 41,810 41,810 - - - 672 Wrf Upgrade Svcs:Jan Expds:Hot Wtr Heatng Biocide 488192 BLD Wastewater Plant PURCHASED 1/17/2013 2,460 - 2,460 2,460 - - - 673 Wrf Upgrade Const Feb Expds 488193 BLD Wastewater Plant PURCHASED 2/5/2013 68,713 - 68,713 68,713 - - - 674 Wrf Upgrade Const March Expds 488194 BLD Wastewater Plant PURCHASED 3/15/2013 23,477 - 23,477 23,477 - - - 675 Wrf Upgrade Const April Expds 488195 BLD Wastewater Plant PURCHASED 4/11/2013 15,876 - 15,876 15,876 - - - 676 Wrf Upgrade Const May Expds 488196 BLD Wastewater Plant PURCHASED 5/17/2013 50,395 - 50,395 50,395 - - - 677 Wrf:Wonderware Sftwre/Scada:February Expds Fy10 488215 BLD Wastewater Plant PURCHASED 2/25/2010 35,713 - 35,713 35,713 - - - 678 Wwtp Early Out Proj:Progress Payment-Pndn 48849 IMP Wastewater Plant PURCHASED 10/26/2007 5,150 - 5,150 5,150 - - - 679 Wwtp Early Out Proj:Payment As Per Agreement 48854 IMP Wastewater Plant PURCHASED 11/29/2007 7,090 - 7,090 7,090 - - - 680 Weir Installation:April On Aerations Basins 48867 IMP Wastewater Plant PURCHASED 4/24/2008 11,627 - 11,627 11,627 - - - 681 Rebuild/Repair Of Dredge 48868 IMP Wastewater Plant PURCHASED 4/25/2008 38,289 - 38,289 38,289 - - - 682 Impact Fee Credits-Sewer 32150 IMP Wastewater Operation PURCHASED 6/30/2003 349,512 - 349,512 - - - 349,512 683 Sewer Impact Improv Fy11-June Expds 32151 IMP Wastewater Operation PURCHASED 6/30/2011 224,616 - 224,616 - 224,616 - - 684 Kohls Impfee Credit:Granary Project 32152 IMP Wastewater Operation PURCHASED 1/23/2012 8,838 - 8,838 - - - 8,838 685 Impact Fee/Sewer Oversizing Cottonwood:Ifcr-1403 32153 IMP Wastewater Operation PURCHASED 6/18/2015 170,277 - 170,277 - - - 170,277 686 Graf Sewer Impact Fee Credit/Graf Corridor 32154 IMP Wastewater Operation PURCHASED 9/9/2016 6,476 - 6,476 - - - 6,476 687 Public Sewer Improv:Oversizing-Huffine+Cottonwood 34290 IMP Wastewater Operation PURCHASED 9/19/2007 42,862 - 42,862 - 42,862 - - 688 Bridger Drive Sewer Main Project 38660 IMP Wastewater Operation PURCHASED 9/30/2016 166,305 - 166,305 - 166,305 - - 689 Bridger Drive Sewer Main Project-Oct Expds 38662 IMP Wastewater Operation PURCHASED 10/24/2016 70,106 - 70,106 - 70,106 - - 690 TOTAL SYSTEM ASSETS - CURRENTLY REPORTED $ 195,102,803 $ (1,802,729) $ 193,300,074 $ 71,944,667 $ 39,980,801 $ 71,578,418 $ 9,796,187 691 ALLOCATION OF OTHER DEVELOPER CONTRIBUTIONS - - - - - 692 ALLOCATION OF INDIRECT PLANT - - - - - 693 TOTAL ASSETS FOR IMPACT FEE DETERMINATION $ 195,102,803 $ (1,802,729) $ 193,300,074 $ 71,944,667 $ 39,980,801 $ 71,578,418 $ 9,796,187 694 100.00% 37.22% 20.68% 37.03% 5.07% 695 TOTAL ASSETS CONSIDERED AS DONATIONS / CONTRIBUTIONS [3] CONTRIBUTION $ 122,528,799 $ 15,262,162 $ 35,856,343 $ 65,644,644 $ 5,765,651 GRANT 391 Page 14 of 14 Line Asset Acquired Asset Adj. General No. Description ID Type Location Acquired Date Cost Adjustments [2] Acq. Amt. Treatment Trans. Collection Plant Classification of Existing Wastewater Utility System Assets [1] Appendix A City of Bozeman, Montana Wastewater Impact Fee Study Wastewater System [1] and iii) ratemaking judgment. [2] Adjustments to remove asset repairs, assets no longer in service, assets not applicable to the wastewater utility, and assets applicable to future capacity expansions. [3] The City reported the following loan forgiveness: U.S. Environmental Protection Agency Grants: Water Reclamation Facility Admin Building Loan Forgiveness 2011 $ 390,700 $ 390,700 $ 390,700 $ - $ - $ - Water Reclamation Facility Admin Building Loan Forgiveness 2011 359,300 359,300 359,300 - - - Water Reclamation Facility Digester Loan Forgiveness 2011 384,000 384,000 384,000 - - - Water Reclamation Facility Digester Loan Forgiveness 2011 816,000 816,000 816,000 - - - Total Grants $1,950,000 $ 1,950,000 $ 1,950,000 $ - $ - $ - Footnotes: Amounts shown are derived from fixed asset records provided by the City; amounts reported as of June 30, 2017. Amounts are classified to plant functions based on: i) fixed asset description and cost center / location; ii) relevance of fixed asset; 392 Impact Fee Advisory Committee (IFAC) Tuesday, December 11th | 6:00 PM | City Hall Commission Room 121 N. Rouse Ave, 59715 A. 06:02:52 PM (00:00:09) Call meeting to order  Kristin Donald (City Staff)  Jacki McGuire  James Nickelson (Chair)  Chris Budeski  Deputy Mayor Chris Mehl (Commission Liaison)  Brian Heaston (City Staff)  Chris Saunders (City Staff)  Nilgun Kamp (Consultant)  Henry Thomas (Consultant)  Steven Tindale (Consultant) B. 06:03:14 PM (00:00:31) Changes to the Agenda C. 06:03:21 PM (00:00:38) Public Comment Please state your name and address in an audible tone of voice for the record. This is the time for individuals to comment on matters falling within the purview of the Committee. There will also be an opportunity in conjunction with each action item for comments pertaining to that item. Please limit your comments to three minutes. 06:03:33 PM (00:00:50) Kevin Thane (3432 S. 29th Ave) voiced concerns regarding the effects of impact fees on affordable housing. Thane requested that the Committee recommend to the Commission that impact fees for affordable housing be reduced. D. 06:11:19 PM (00:08:36) Minutes 1. Approval of minutes:  11-8-18 Minutes (PDF) o 11-8-18 Meeting Audio Link  11-15-18 Minutes (PDF) o 11-15-18 Meeting Audio Link 06:11:29 PM (00:08:46) MOTION to accept minutes as submitted: Chris Budeski 06:11:30 PM (00:08:47) MOTION SECONDED: Jacki McGuire 393 06:11:30 PM (00:08:47) VOTE: All in Favor – Motion Carries Unanimously G. 06:11:44 PM (00:09:01) Action Items Assistant City Manager, Anna Rosenberry, introduced Steven Tindale, Nilgun Kamp and Henry Thomas, the consultants completing Bozeman’s impact fee study update. 1. 06:13:57 PM (00:11:14) Wastewater Impact Fee Schedule Review and Recommendation & Water Impact Fee Schedule Review and Recommendation Henry Thomas with Public Resources Management Group provided a recap of the study conducted on wastewater impact fees. Thomas explained that his original proposal was to have a single fee per residential unit, but based on board discussion, the consultants looked back at the tiered structure and developed supporting data. Thomas explained the factors that went into changes to the study and the tiered fee recommendation. Thomas explained that when looking at the assets and capital improvement plan, there are higher costs on the wastewater side and lower costs on the water side than the previous calculations. 06:33:25 PM (00:30:42) Ms. Rosenberry provided some clarification regarding the two sets of numbers presented. 06:35:51 PM (00:33:08) Mr. Thomas responded to questions regarding data used in calculations for the wastewater impact fee recommendation. 06:48:20 PM (00:45:37) Board Chair, James Nickelson, asked a follow-up question regarding the public comment received from Kevin Thane about modifying impact fees for affordable housing. City Planner and Community Development Manager, Chris Saunders responded. Following, committee members continued directing questions toward Mr. Thomas, impact fee consultant. 07:03:08 PM (01:00:25) Mr. Thomas recapped the impact fees affiliated with group housing per Deputy Mayor Mehl’s request. 07:09:08 PM (01:06:25) MOTION to make a recommendation to the City Commission for approval of the wastewater impact fee schedule review: Chris Budeski (withdrawn for more discussion.) Wastewater Impact Fees: 07:09:40 PM (01:06:57) Impact Fee Advisory Committee members worked around the dais, sharing their opinions on the impact fee options for wastewater. 07:11:35 PM (01:08:52) MOTION to recommend approval to the City Commission for the revised methodology dated December 3rd, 2018 for the wastewater impact fees: Chris Budeski 07:13:29 PM (01:10:46) MOTION SECONDED: Jacki McGuire 07:13:31 PM (01:10:48) Motion Discussion 394 07:17:56 PM (01:15:13) VOTE: All in Favor – Motion Carries Water Impact Fees: 07:18:18 PM (01:15:35) MOTION to recommend approval to the City Commission for the water impact fee study with the revised methodology, draft report dated December 3rd, 2018. 07:18:43 PM (01:16:00) MOTION SECONDED: Kristin Donald 07:19:00 PM (01:16:17) VOTE: All in Favor – Motion Carries 2. 07:19:27 PM (01:16:44) Fire Impact Fee Schedule Review and Recommendation Nilgun Kamp of Tindale and Oliver introduced herself and initiated her presentation by addressing some of the concerns brought up in a previous meeting regarding affordable housing. Kamp proposed separating single family homes from multi-family homes for the fire impact fee schedule. 07:22:13 PM (01:19:30) Ms. Rosenberry referred back to the packet memo, showing actual fees in order to provide clarification for Nilgun’s presentation, explaining that the previous single fee had been separated into three separate fees under the new proposal for fire. 07:24:18 PM (01:21:35) Josh Waldo, Bozeman Fire Chief answered questions regarding the difference in fighting fires in a single family home vs. multi-family. Chief Waldo stated that the bigger the building is, the more challenging it is to handle an emergency. 07:25:37 PM (01:22:54) Consultant, Steven Tindale, stated that 90% of calls to the fire department are not directly related to a fire, but other emergencies. Mr. Tindale also stated that there is a relationship between persons per household and fire rescue services. Following, Ms. Kamp explained the data they used, in response to committee member questions. 07:30:46 PM (01:28:03) Ms. Rosenberry explained that the Impact Fee Advisory Committee is charged with forwarding a recommendation to the City Commission for a single fee structure for residential fire impact fees or whether the fees should be separated based on residential type. 07:36:06 PM (01:33:23) Committee members directed questions toward Mr. Saunders regarding impact fee management and affordable housing. 07:40:37 PM (01:37:54) MOTION to recommend approval of the fire impact fee schedule proposed in table or option #2: Chris Budeski 07:41:26 PM (01:38:43) MOTION SECONDED Jacki McGuire 07:41:35 PM (01:38:52) Motion Discussion 07:42:42 PM (01:39:59) VOTE: All in Favor – Motion Carries 395 3. 07:42:59 PM (01:40:16) Transportation Impact Fee Schedule Review and Recommendation Ms. Rosenberry, introduced the Transportation Impact Fee Schedule and provided an overview of the components included in the determination made by consultants. 07:45:02 PM (01:42:19) Ms. Kamp provided an overview of the transportation impact fee options presented. 07:50:11 PM (01:47:28) Mr. Tindale explained the level of service components of the transportation impact fee study. Following, Ms. Rosenberry and Ms. Kamp explained the committee’s fee options (tables in packet) in more depth and responded to questions from committee members. 07:59:53 PM (01:57:10) Consultants explained the comparison numbers used in calculating construction costs within the transportation impact fee study in response to committee member questions. 08:10:26 PM (02:07:43) Mr. Saunders explained provisions in Bozeman’s Unified Development Code that state that no development can take place in an intersection that doesn’t meet the city’s D standard until the intersection has reached the planned build-out. Saunders did state that they look at other ways to provide solutions to congestion at these intersections. 08:14:01 PM (02:11:18) City Staff responded to a question asking if they were satisfied with the proposed fee tiers. Following, Saunders explained that impact fees are fees for service, not considered a tax and so all schools (not only private) are responsible for impact fees. 08:17:09 PM (02:14:26) Ms. Kamp provides a brief summary so that committee members may deliberate as to which transportation impact fee schedule to choose. The group then discussed the change in curve (fees) between homes of different sizes. 08:25:36 PM (02:22:53) Ms. Rosenberry offered more detail on the graph provided in the transportation impact fee study packet. Following, the Tindale and Oliver Consultants explained which curve the consulting firm recommended based on their past experience. 08:31:07 PM (02:28:24) Committee members deliberate on how to move forward in selecting which transportation impact fee schedule to recommend for adoption to the City Commission. 08:38:21 PM (02:35:38) MOTION to recommend approval for the demand component, separating single family versus multi-family and the alternative curve using the Plums Data. 08:39:14 PM (02:36:31) MOTION SECONDED Jacki McGuire 08:39:19 PM (02:36:36) Discussion 08:40:31 PM (02:37:48) VOTE: All in Favor – Motion Carries 396 08:40:38 PM (02:37:55) Committee members discussed the vehicle to capacity ratio (V.C. ratio) and level of service as it pertains to the transportation impact fee options. 08:47:23 PM (02:44:40) Ms. Rosenberry provided a more detailed explanation of Table #5 which shows the transportation fee split into single family and multi-family dwellings based on the increased level of service component, compared to the current impact fee. Following, committee members continued deliberation. 09:12:37 PM (03:09:54) Impact Fee Committee members and consultants discussed why the impact fees are increasing at the current rate in order to maintain a specific level of service. 09:20:07 PM (03:17:24) Ms. Rosenberry recapped the options before the committee. 09:27:14 PM (03:24:31) MOTION to recommend that the commission consider the V.C. ratio of .73: Chris Budeski 09:27:33 PM (03:24:50) MOTION SECONDED: Kristin Donald 09:27:36 PM (03:24:53) Discussion 09:29:11 PM (03:26:28) VOTE: 2 for; 2 Against 09:29:37 PM (03:26:54) MOTION to recommend to the commission to accept the report for the transportation impact fee schedule. 09:30:12 PM (03:27:29) MOTION SECONDED: Jacki McGuire 09:30:18 PM (03:27:35) VOTE: All in Favor – Motion Carries 09:32:52 PM (03:30:09) Mr. Tindale spoke briefly about intersection capacity. H. 09:34:52 PM (03:32:09) FYI/Discussion 1. Annual ethics training requirements I. 09:35:46 PM (03:33:03) Adjournment For more information please contact Chris Saunders at 406-582-2260 This board generally meets as needed Committee meetings are open to all members of the public. If you have a disability and require assistance, please contact our ADA coordinator, Chuck Winn at 582-2306 (TDD 582-2301). 397 Comparison Schedule for All Impact Fee Types ‐ Examples ‐ Residential 03‐Jan‐19 Median Detached Home 2,400 sq. ft. 6,500 sq. ft. lot Existing New ‐ Transportation Scenario 1 New ‐ Transportation Scenario 2 Transportation $ 5,395.22 $ 6,127.00 $ 8,566.00 Fire $ 409.51 $ 358.20 $ 358.20 Water $ 3,117.63 $ 3,036.00 $ 3,036.00 Wastewater $ 1,697.22 $ 1,830.00 $ 1,830.00 $ 10,619.58 $ 11,351.20 $ 13,790.20 Small Detached Home 1,500 sq. ft. 4,500 sq. ft. lot Existing New ‐ Scen. #1 New ‐ Scen. #2 Transportation $ 3,692.72 $ 4,689.00 $ 6,556.00 Fire $ 244.75 $ 333.60 $ 333.60 Water $ 1,923.53 $ 2,391.00 $ 2,391.00 Wastewater $ 1,082.79 $ 1,441.00 $ 1,441.00 $ 6,943.79 $ 8,854.60 $ 10,721.60 Townhome 1,350 sq. ft. 3,000 sq. ft. lot Existing New ‐ Scen. #1 New ‐ Scen. #2 Transportation $ 3,141.14 $ 4,211.00 $ 5,886.00 Fire $ 191.02 $ 325.91 $ 325.91 Water $ 1,450.30 $ 1,881.00 $ 1,881.00 Wastewater $ 787.92 $ 1,133.00 $ 1,133.00 $ 5,570.38 $ 7,550.91 $ 9,225.91 Group Quarters 10 residents 15,246 sq. ft. lot Existing New ‐ Scen. #1 New ‐ Scen. #2 Transportation $ 24,773.37 $ 15,490.00 $ 21,680.00 Fire $ 1,850.54 $ 1,537.30 $ 1,537.30 Water $ 12,696.32 $ 26,870.00 $ 26,870.00 Wastewater $ 6,104.10 $ 16,190.00 $ 16,190.00 $ 45,424.33 $ 60,087.30 $ 66,277.30 398 Apartment Building 12 homes@ 1,000 sq. ft. each 21,408 sq. ft. lot Existing New ‐ Scen. #1 New ‐ Scen. #2 Transportation $ 37,693.72 $ 31,404.00 $ 43,884.00 Fire $ 2,292.28 $ 2,767.20 $ 2,767.20 Water $ 15,947.37 $ 22,572.00 $ 22,572.00 Wastewater $ 7,829.32 $ 13,596.00 $ 13,596.00 $ 63,762.69 $ 70,339.20 $ 82,819.20 Affordable Housing Townhome 800 sq. ft 2,500 sq. ft. lot Existing New ‐ Scen. #1 New ‐ Scen. #2 Transportation $ 3,141.14 $ 2,617.00 $ 5,886.00 Fire $ 191.02 $ 325.91 $ 325.91 Water $ 1,400.00 $ 1,881.00 $ 1,881.00 Wastewater $ 732.22 $ 1,133.00 $ 1,133.00 $ 5,464.38 $ 5,956.91 $ 9,225.91 399 Comparison Schedule for All Impact Fee Types ‐ Examples ‐ Non‐Residential 03‐Jan‐19 Offices 3/4 inch meter 30,000 sq. ft. lot 10,000 sq. ft. bldg Existing New ‐ Transportation Scenario 1 New ‐ Transportation Scenario 2 Transportation $ 39,664.76 $ 21,054.50 $ 29,469.50 Fire $ 3,760.78 $ 4,573.50 $ 4,573.50 Water $ 5,366.06 $ 4,031.00 $ 4,031.00 Wastewater $ 4,932.69 $ 2,429.00 $ 2,429.00 $ 53,724.29 $ 32,088.00 $ 40,503.00 Retail 3/4 inch meter 40,000 sq. ft. lot 12,000 sq. ft. bldg Existing New ‐ Scen. #1 New ‐ Scen. #2 Transportation $ 109,952.18 $ 73,664.40 $ 103,142.40 Fire $ 5,071.68 $ 5,119.08 $ 5,119.08 Water $ 6,363.99 $ 4,031.00 $ 4,031.00 Wastewater $ 6,046.83 $ 2,429.00 $ 2,429.00 $ 127,434.68 $ 85,243.48 $ 114,721.48 Restaurant 1.5 inch meter 25,000 sq. ft. lot 6,000 sq. ft. bldg Existing New ‐ Scen. #1 New ‐ Scen. #2 Transportation $ 54,976.09 $ 36,832.20 $ 51,571.20 Fire $ 2,535.84 $ 2,559.54 $ 2,559.54 Water $ 14,356.19 $ 13,437.00 $ 13,437.00 Wastewater $ 10,741.48 $ 8,099.00 $ 8,099.00 $ 82,609.60 $ 60,927.74 $ 75,666.74 Manufacturing 1 inch meter 45,000 sq. ft. lot 15,000 sq. ft. bldg Existing New ‐ Scen. #1 New ‐ Scen. #2 Transportation $ 20,605.52 $ 12,609.75 $ 17,709.75 Fire $ 465.62 $ 691.80 $ 691.80 Water $ 9,946.79 $ 6,418.00 $ 6,418.00 Wastewater $ 8,672.92 $ 4,049.00 $ 4,049.00 $ 39,690.85 $ 23,768.55 $ 28,868.55 400 656 Wrf Upgrade Constr December Expds 488175 BLD Wastewater Plant PURCHASED 12/30/2011 74,121 - 74,121 74,121 - - - 657 Wrf Upgrade Constr January Expds 488176 BLD Wastewater Plant PURCHASED 1/1/2012 557,050 - 557,050 557,050 - - - 658 Wrf:Wonderware Sftwre/Scada:February Expds Fy12 488177 BLD Wastewater Plant PURCHASED 2/13/2012 3,283 - 3,283 3,283 - - - 390 601 Wrf Upgrade Constr December Expds 488120 BLD Wastewater Plant PURCHASED 12/31/2009 778,405 - 778,405 778,405 - - - 602 Wrf Upgrade Constr January Expds 488121 BLD Wastewater Plant PURCHASED 1/25/2010 1,293,371 - 1,293,371 1,293,371 - - - 603 Wrf Upgrade Constr February Expds Fy10 488122 BLD Wastewater Plant PURCHASED 2/25/2010 625,005 - 625,005 625,005 - - - 389 546 Wwtp Upgrade Proj:Prof Svcs Thru 3/1/08 Phase 1 48863 BLD Wastewater Plant PURCHASED 3/24/2008 352,750 - 352,750 352,750 - - - 547 Wwtp Upgrade Proj:Prof Svcs Thru 3/29/08 Phase 1 48864 BLD Wastewater Plant PURCHASED 4/16/2008 340,463 - 340,463 340,463 - - - 548 Wwtp Early Out:Constr Svcs Thru 04/21/08 Phase I 48865 BLD Wastewater Plant PURCHASED 4/21/2008 5,682 - 5,682 5,682 - - - 388 491 Wwtp Maintenance Buidling 4886 BLD Wastewater Plant PURCHASED 5/15/2005 6,765 - 6,765 6,765 - - - 492 Wwtp Modification 4887 BLD Wastewater Plant PURCHASED 6/15/2005 1,845 - 1,845 1,845 - - - 493 Wwtp Maintenance Building Svcs Thru 7/29/05 4888 BLD Wastewater Plant PURCHASED 8/17/2005 1,381 - 1,381 1,381 - - - 387 436 Epa Grant 56Ep04 320666 IMP Wastewater Plant GRANT 1/15/2005 9,215 - 9,215 9,215 - - - 437 Epa Grant 56Ep04 320667 IMP Wastewater Plant GRANT 3/15/2005 8,978 - 8,978 8,978 - - - 438 Epa Grant 56Ep04 320669 IMP Wastewater Plant GRANT 4/15/2005 4,891 - 4,891 4,891 - - - 386 381 Sigma Sampler 17140 M&E Wastewater Plant PURCHASED 7/1/1998 10,456 - 10,456 10,456 - - - 382 Tiger Tractor 6610 Mower 22310 M&E Wastewater Plant PURCHASED 6/30/2012 0 - 0 - - - 0 383 Compressor Flotation 26780 M&E Wastewater Plant PURCHASED 7/1/1998 8,975 - 8,975 8,975 - - - 385 326 Upgrade Truck Barn:Jan Expds 488213 BLD Wastewater Plant PURCHASED 1/8/2015 2,165 - 2,165 - - - 2,165 327 Wrf Upgrade Digester #3 Constr:Jan Expds 488214 BLD Wastewater Plant PURCHASED 1/1/2015 22,040 - 22,040 22,040 - - - 328 Wrf Upgrade Digester #3 Constr Feb Expds 488216 BLD Wastewater Plant PURCHASED 2/1/2015 5,121 - 5,121 5,121 - - - 384 271 2013 Freightliner Sewer Jetter Truck 36750 M&E Wastewater Operation PURCHASED 6/11/2013 219,628 - 219,628 - - - 219,628 272 Towmaster Tilt-Bed Trailer For Mini Excavator 36762 M&E Wastewater Operation PURCHASED 6/11/2013 3,328 - 3,328 - - - 3,328 273 Pressure Washer @ Shop Complex 37055 M&E City Shops PURCHASED 2/1/2014 1,066 - 1,066 - - - 1,066 383 216 Work Order 2-Day Training Kick-Off Meeting-Azteca 3324165 M&E Geographic Info Systems PURCHASED 3/2/2008 1,800 - 1,800 - 900 900 - 217 Ctywrks Database Config Task2,2A,3,4 Remote Instal 3324181 M&E Geographic Info Systems PURCHASED 4/2/2008 12,075 - 12,075 - 6,038 6,038 - 218 Ctywrks Database Config Task 5,6,7 Remote Install 3324182 M&E Geographic Info Systems PURCHASED 4/17/2008 7,550 - 7,550 - 3,775 3,775 - 382 161 Solvent Site Water Improvements 29470 IMP Wastewater Operation PURCHASED 10/23/2000 13,316 (13,316) 0 - - - - 162 Solvent Site Project 29471 IMP Wastewater Operation PURCHASED 6/26/2001 15,456 (15,456) 0 - - - - 163 Solvent Site 29472 IMP Wastewater Operation PURCHASED 6/1/2001 130,085 (130,085) 0 - - - - 381 106 2012 Sewer Rehab Project:Pmt#8 March Expds 342928 IMP Wastewater Operation PURCHASED 3/19/2013 53,340 - 53,340 - 18,843 34,497 - 107 2012 Sewer Rehab Project:Pmt#9 April Expds 342929 IMP Wastewater Operation PURCHASED 4/30/2013 13,518 - 13,518 - 4,775 8,743 - 108 2012 Sewer Rehab Project:Pmt#10 May Expds 342930 IMP Wastewater Operation PURCHASED 5/22/2013 6,544 - 6,544 - 2,312 4,232 - 380 Wastewater Impact Fee Study Wastewater System 379 49 WWIF33 WW Impact Fee Davis Ln Lift Station Debt Service (WWIF24) - - - - 370,300 370,300 370,300 370,300 370,300 1,851,500 50 WWIF34 WW Impact Fee Annie Street Sanitary Sewer Upgrade - - - - - - - - 300,000 300,000 51 WWIF35 WW Impact Fee Babcock Sanitary Sewer Upgrade - - - - 245,000 - - - - 245,000 52 WWIF36 WW Impact Fee Baxter Creek Basin- Cottonwood Road 18" Sanitary Sewer Extensions - - - 640,000 - - - - - 640,000 53 WWIF37 WW Impact Fee Hunters Way Sewer Capacity Upgrade - - - - 350,000 - - - - 350,000 54 WWIF38 WW Impact Fee Norton East Ranch Outfall Diversion & Interceptor - - - - 5,320,000 - - - - 5,320,000 2-368 14 unless there is a mechanism in place for the existing users to make improvements to the existing system to match the higher level of service. (e) Impact fees may not include expenses for operations and maintenance of the facility. Wastewater Impact Fee Study Service Area Report All Sections 353 reviewed and updated at least every 2 years. CIP Wastewater-related improvements for the CIP Wastewater Impact Fee Study Service Area Report Section 2: Development of Wastewater Impact Fees (3) The service area report is a written analysis that must contain documentation of sources and methodology used for purposes of subsection (2) and must document how each impact fee meets the requirements of subsection (7). Wastewater Impact Fee Study Service Area Report All Sections (4) The service area report that supports adoption and calculation of an impact fee must be available to the public upon request. Wastewater Impact Fee Study Service Area Report All documents will be made available at City offices (Table continues on following page) 352 Collection Facilities Plan dated May 2015 Chapter 6: Summary Recommendations and Capital Improvement Summary CIP Wastewater-related projects (2)(f) make a determination as to whether one service area or more than one service area is necessary to establish a correlation between impact fees and benefits. Wastewater Impact Fee Study Service Area Report Executive Summary and Recommendations, Page ES-1 (2)(g) make a determination as to whether one service area or more than one service area for transportation facilities is needed to established a correlation between impact fees and benefits. Not Applicable for Wastewater Impact Fees Not Applicable for Wastewater Impact Fees (Table continues on following page) 351