HomeMy WebLinkAboutResolution 4987 Adopting the Wastewater Impact Fee Study and Establishing Wastewater Impact Fees v
COMMISSION RESOLUTION NO. 4987
A RESOLUTION OF THE CITY COMMISSION OF THE CITY OF BOZEMAN,
MONTANA, ADOPTING THE WASTEWATER IMPACT FEE STUDY PER ARTICLE
2.06,BMC AND ESTABLISHING WASTEWATER IMPACT FEES AS STATED IN THE
STUDY.
WHEREAS, the City of Bozeman is committed to addressing the community's
expressed needs and desires for services; and
WHEREAS, the City of Bozeman is committed to meeting those desires and demands
for services in a fiscally responsible manner; and
WHEREAS, the City of Bozeman is committed to meeting those desires and demands
for services in a manner which recognizes the fiscal and legal interests of all of the system users
now and in the future and not a limited subset of users; and
WHEREAS, the City of Bozeman has developed and adopted a Wastewater master plan
which examined current and future needs and provides a lawful, logical, balanced, operationally
sound, and cost effective basis upon which to maintain and develop the City's Wastewater
system; and
WHEREAS, the City Commission has chosen to utilize impact fees as one element of an
integrated approach to fund and provide Wastewater services; and
WHEREAS, Sections 7-6-1601 through 7-6-1604, MCA provide specific authority and
guidance regarding the documentation necessary to establish an impact fee and procedures to
Page 1 of 5
Resolution 4987, Wastewater Impact Fee Study Adoption
adopt and administer an impact fee; and
WHEREAS, the City contracted with Tindale Oliver&Public Resources Management
Group to provide professional services in development of an updated Wastewater impact fee
study(the "Fee Study");
WHEREAS, Tindale Oliver&Public Resources Management Group reviewed the
existing demand and needs for Wastewater facilities,the existing facilities available to meet that
demand, and the method of financing the existing systems and needed new facilities; and,
WHEREAS, Tindale Oliver&Public Resources Management Group also reviewed the
contribution made or to be made in the future in cash or by taxes, fees, or assessments by
property owners towards the capital costs of Wastewater facilities; and,
WHEREAS, Tindale Oliver&Public Resources Management Group reviewed and
relied upon the City of Bozeman's level of service (LOS) standards and facility cost assumptions
as established by recently constructed projects in recommending Wastewater impact fees; and,
WHEREAS, Tindale Oliver&Public Resources Management Group has prepared the
Fee Study dated December 3,2018, including the assumptions,population and residential and
non-residential development projections, capital infrastructure and impact fee calculations,
which study has been submitted to and reviewed by City staff, Impact Fee Advisory Committee,
and City Commission; and,
WHEREAS, in addition to the Fee Study, Tindale Oliver&Public Resources
Management Group. and the City have prepared, updated, and relied upon other documentation,
as required by section 7-6-1602MCA, in developing the Wastewater facilities impact fees
adopted pursuant to this Resolution, including but not limited to the following which has been
summarized in the required service area report:
(1) The most current Wastewater facility plan;
(2) City of Bozeman Design and Specifications Manual;
Page 2 of 5
Resolution 4987, Wastewater Impact Fee Study Adoption
(3) Most recent bids and costs for actual construction of piping and plant
expansions;
(4) Adopted Wastewater Impact Fee Capital Improvement Program;
(5) Adopted Wastewater Capital Improvement Program, and
(6) the City Budget; and
WHEREAS,the City develops its Wastewater facility plans, and its capital
improvements program in a manner open to the public and accepts and responds to public
comment and input; and
WHEREAS, the City and Tindale Oliver &Public Resources Management Group have
developed the Fee Study in a manner open to the public and accepted and responded to comment
and input; and
WHEREAS,the City of Bozeman Impact Fee Advisory Committee has considered and
made a recommendation to the City Commission on the Fee Study; and
WHEREAS,the Impact Fee Advisory Committee conducted public hearings on the
subject of the impact fee study on December 11, 2018, and the City Commission conducted a
public hearing on January 14, 2019; and
WHEREAS,public comment was received and considered;and
WHEREAS,the City Commission reviewed and discussed the Fee Study and accepts
and agrees with the content of the Fee Study and recognizes that updates and modifications will
be made to the fee schedule in the future in accord with the annual cost adjustment requirements
of Chapter 2,Article 6, Division 9 BMC; and
WHEREAS, the City Commission finds that all required elements necessary for
compliance with standards for development of an impact fee have been satisfied.
Page 3 of 5
Resolution 4987, Wasteivater Impact Fee Study Adoption
NOW, THEREFORE,BE IT RESOLVED by the City Commission of the City of
Bozeman, Montana, that:
1. The December 3, 2018 draft of the Wastewater Impact Fee Study Update, as contained
in Exhibit "A", attached hereto and by this reference made a part hereof,is hereby
adopted.
2.As of the 2ND day of March 2019, any person who seeks to obtain any of the forms of
development listed 2.06.1660,BMC must pay a Wastewater Impact Fee pursuant to the
schedule included in Exhibit A of this Resolution.
PASSED, ADOPTED, AND APPROVED by the City Commission of the City of
Bozeman,Montana, at a regular session thereof held on the 4th day of February 2019.
C THIA L. US
Mayor
ATTEST:
• ,� •:�►
ROBIN CROUGH -�.� L;
City Clerk ;U• tz-L -c-�.: '`
=,��'.•.1883 •o `' APPR ' ED ASTO-FORM:
cO-�
G U LIVAN
City Attorney
Page 4 of 5
Resolution 4987, Wastewater Impact Fee Study Adoption
Appendix A
Page 5 of 5
-_.
'�� •-.. 1883
�xA Co.
Fiscal Fiscal Year 2018
WASTEWATER
IMPACT FEE STUDY
For
CITY OF BOZEMAN,
MONTANA
Public Resources Management Group, Inc.
Utility, Rate., Financial, and Management Consultants
Public Resources Management Group, Inc.
Utility, Rate, Financial, anti 1lanaoenient Consultants
19 lb
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.
KADC\1246-01\Rpt\Revised Wastewater Impact Fee Study.doex
341 NORTH MAITLAND AVENUE—SUITE 300—MAITLAND,FL 32751
Tel: 407-628-2600 • Fax: 407-628-2610 • Email: PRMG@,PRMGiuc.com • Website: www.PRMGinc.com
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
CITY OF BOZEMAN, MONTANA
WASTEWATER IMPACT FEE STUDY
TABLE OF CONTENTS
Title Page No.
Letter of Transmittal
Tableof 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 l: 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
ExistingPlant-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
-i-
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 ES-3
Impact Fees
2-1 Development of Existing Wastewater Treatment Facility Capacity 2-12
Available to Serve System Growth
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 2-18
Wastewater Impact Fees
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 1-3
Fee Legislation(Section 7-6-1602 MCA)
Appendix No. Description
A Classification of Existing Wastewater Utility System Assets
-ii-
EXECUTIVE SUMMARY
AND RECOMMENDATTQNS
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
ES-1
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)
ES-2
Table ES-1
City of Bozeman,Montana
Wastewater Impact Fee Study
Summary of Calculated Costs per Gallon and Proposed Wastewater Impact Fees
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 1400orLess $440.89 $8.47 ($1.68) $6.79 144 0.70 S684.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 97732 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,24120 5.0% 1,303,00
10 3001orMore 1,190.42 8.47 (1.68) 6.79 144 1.35 1,319.39 5.0% 1,385.00
11 Group Quarters per person 428.13 8.47 (1.68) 6.79 144 OAS 439.79 5.0% 461.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 S395.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 0.45 254.51 5.0% 267.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 1400orLess $5,157.31 $12.52 ($1.81) $10.71 144 0.70 $1,080.02 5.0% $1,133.05
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.99 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,936.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 0.45 694.30 5.0% 728.00
ES-3
Table ES-I
City of Bozeman,Montana
Wastewater Impact Fee Study
Summary of Calculated Costs per Gallon and Proposed Wastewater Impact Fees
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% 51,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 i-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-4
SECTION I
INTRODUCTION
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.
1-1
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)
1-2
Figure 1-1
Wastewater Impact Fee Study
Compliance with Montana Enabling Impact Fee Legislation
(Section 7-6-1602 MCA)
Wastewater System
Section
Reference Doctinientation Itein Doctinicia(s) Page or Section
(1) for each public facility for which an impact Wastewater Impact Fee
fee is imposed,the governmental agency Study Service Area Report
must prepare and approve a service area
report.
(2) The service area report is a written analysis
that must:
(2)(a) describe existing conditions of the facility. Bozeman Wastewater Chapter 3:Existing Collection
Collection Facilities Plan System Database
dated May 2015
(2)(b) establish level of service standards. Bozeman Wastewater Chapter 2:Basis of Planning,
Collection Facilities Plan Page 2-12
dated May 2015
Wastewater Impact Fee Section 2:Development of
Study Service Area Report Wastewater Impact Fees,Level of
Service Requirements,Page 2-3
(2)(c) forecast future additional needs for service Bozeman Wastewater Chapter 5:Future Collection
for a defined period of time. Collection Facilities Plan System Evaluation
dated May 2015
(2)(d) identify capital improvements necessary to Bozeman Wastewater Chapter 6: Summary
meet future needs for service. Collection Facilities Plan Recommendations and Capital
dated May 2015 Improvement Summary
CIP Wastewater-related projects
Wastewater Impact Fee Section 2:Development of
Study Service Area Report Wastewater Impact Fees,Tables
2-2 to 2-4
(2)(e) identify those capital improvements needed Bozeman Wastewater Chapter 6: Summary
for continued operation and maintenance of Collection Facilities Plan Recommendations and Capital
the facility. dated May 2015 Improvement Summary
CIP Wastewater-related projects
(2)(f) make a determination as to whether one Wastewater Impact Fee Executive Summary and
service area or more than one service area Study Service Area Report Recommendations,Page ES-1
is necessary to establish a correlation
between impact fees and benefits.
(2)(g) make a determination as to whether one Not Applicable for Not Applicable for Wastewater
service area or more than one service area Wastewater Impact Fees Impact Fees
for transportation facilities is needed to
established a correlation between impact
fees and benefits.
(Table continues on following page)
1-3
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 Iteni Document(s) Page or Section
(2)(h) establish the methodology and time period CIP Wastewater-related
over which the governmental entity will improvements in the CIP
assign the proportionate share of capital costs
for expansion of the facility to provide
service to new development within each
service area. Wastewater Impact Fee Section 2:Development of
Study Service Area Wastewater Impact Fees
Report
(2)(i) establish the methodology that the Bozeman Wastewater Chapter 6: Summary
governmental entity will use to exclude Collection Facilities Plan Recommendations and Capital
operations and maintenance costs and dated May 2015 Improvement Summary
correction of existing deficiencies from the Wastewater Impact Fee Section 2:Development of
impact fee. Study Service Area Wastewater Impact Fees
Report
(2)0) establishes the amount of the impact fee that Wastewater Impact Fee Table ES-1;
will be imposed for each unit of increased Study Service Area Section 2:Development of
service demand. Report Wastewater Impact Fee,Table 2-
5
(2)(k) has a component of the budget of the CIP Wastewater-related
governmental entity that:(i)schedules improvements for the CIP
construction of public facility capital Wastewater Impact Fee Section 2:Development of
improvements to serve projected growth. Study Service Area Wastewater Impact Fees
(ii)projects costs of the capital Report
improvements.
(iii)allocates collected impact fees for
construction of the capital improvements.
(iv)covers at least a 5-year period and is
reviewed and updated at least every 2 years.
(3) The service area report is a written analysis Wastewater Impact Fee All Sections
that must contain documentation of sources Study Service Area
and methodology used for purposes of Report
subsection(2)and must document how each
impact fee meets the requirements of
subsection(7).
(4) The service area report that supports adoption Wastewater Impact Fee All documents will be made
and calculation of an impact fee must be Study Service Area available at City offices
available to the public upon request. Report
(Table continues on following page)
�1
it
1-4
I
Figure 1-1 (cont.)
Wastewater Impact Fee Study
Compliance with Montana Enabling Impact Fee Legislation
(Section 7-6-1602 MCA)
Wastewater System
Section
io
(5) The amount of each impact fee imposed must Wastewater Impact Fee Section 2:Development of
be based upon the actual cost of public Study Service Area Wastewater Impact Fees,Table 2-
facility expansion or improvements or Report 5
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.
(6) The ordinance or resolution adopting the Updated Wastewater To be determined
impact fee must include a time schedule for Impact Fee Resolution
periodically updating the documentation
required under subsection(2).
(7) An impact fee must meet the following Wastewater Impact Fee All Sections
requirements: Study Service Area
(a)The amount of the impact fee must be Report
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
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.
1-5
S CTMN 2,
DEVELOPM A'NT Of'
WASTEWATER SYSTEM IMPACT FEES
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
Transmission System Fee
Water Reclamation Plant Per Net Acre of
Square Feet of Living Area Fee Per Unit 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)
2-1
Existing Nonresidential Water Impact Fees
Transmission System Fee
Water Reclamation Plant Per Net Acre of
Meter Size Fee Per Meter 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
2-2
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 aad
[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
2-3
capacity was constructed and is available to serve the near-tern 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
f inctionalized 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
2-4
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-seivice 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[21 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.
[31 Construction work-in-progress was not recognized since the projects have not yet been
completed and placed into set-vice 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)
2-5
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 Set-vice 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.
2-6
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
2-7
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 Wastewater
Treatment 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 J7.13 4.12 11.24
[*]Amounts derived from Table 2-5.
2-8
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)
2-9
Equivalent Non-residential Units by Meter Size
for City Wastewater System
Rated Capacity
Meter Size (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
Water Reclamation Plant Transmission System Fee
Square Feet of Living Area Fee Per Unit 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 461.00 267.00
Proposed Nonresidential Wastewater Impact Fees
Water Reclamation Plant Transmission System Fee
Meter Size Fee Per Meter 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
2-10
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)
2-11
Table 2-1
City of Bozeman,Montana
Wastewater Impact Fee Study
Development of Existing Wastewater Treatment Facility
Capacity Available to Serve System Growth
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.
2-12
Table 2-1
City of Bozeman,Montana
Wastewater Impact Fee Study
Development of Existing Wastewater Treatment Facility
Capacity Available to Serve System Growth
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-13
Table 2-2
City of Bozeman,Montana
Wastewater Impact Fee Study
Multi-Year Estimated Capital Improvement Pro ram Summa
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 Comer 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 W W08-18 Engineering Wastewater Pipe Replacement Program-Construction in 2018 1,000,000 - 1,000,000 - - - - - - 1,000,000
4 W W08-19 Engineering Wastewater Pipe Replacement Program-Construction in 2019 - - - 1,000,000 - - - - - 1,000,000
5 W W08-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 W WOS-22 Engineering Wastewater Pipe Replacement Program-Construction in 2022 - - - _ _ 1,000,000 - - 1,000,000
8 W WOS-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/Upgradc" - - - - - - - - 333,333 333,333
12 PWO5 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 W W54 Wastewater Op Replace#1783-1995 Ford Dump Track - - - - 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 Stecrable 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 W W45 WRF Final and Secondary Clarifier Launder Covers 200,000 - 200,000 - - - - - - 200,000
W W49 WRF Roll-Off Storage Building Construction and Possible 2nd Screw Press 600,000 - 600,000 1,500,000 - - - - - 2,100,000
23 Enclosure
24 WW50 WRF Refrigerated Automatic Sampler 10,000 - 10,000 - - - - - - 10,000
25 W W53 WRF Positive Displacement Lobe Pumps 50,000 - 50,000 - - - - - - 50,000
26 W W59 WRF Chip Seal and Topcoat WRF Asphalt - - - 55,000 - _ _ _ -
55,000
27 W W66 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 W W70 WRF WRF Facility Engineering and Optimization 50,000 - 50,000 50,000 50,000 50,000 50,000 50,000 - 300,000
30 W W71 WRF WRF Facility Master Plan Update 250,000 - 250,000 - - - - - - 250,000
31 W W76 WRF Third Pretreatment Scrcen _ _ _ _ _ 500,000 - - - 500,000
32 WW78 WRF Server Replacement at WRF(Wrfctrlbak) - _ _ _ - 10,000 - - 10,000
34 W W80 WRY Lagoon Valve Replacement in Lift#3 50,000 - 50,000 - - - - - - 50,000
35 W W81 WRF Membrane Roof Replacement on Old Digester Building(Dig I&2) 60,000 - 60,000 - - - - - 60,000
36 W W 83 WRY Ufat Gravity Thickener Drive and Amu Replacement - - - - - - 400,000 - - 400,000
37 WW94 WRF Server Replacement at WRF(Wrfctripri) - - - - - - 10,000 - - 10,000
38 W W85 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 WWIF 11 WW Impact Fee Front Street Interceptor $ - $ $ - $ 2,185,000 $ - $ - $ _ $ - $ - $ 2,195,000
43 W WIF20 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
W WIF27 WW Impact Fee South University District/Cattail Creek Basin-S ISth Ave to Willow 795,000 - 795,000 - - - - - - 795,000
46 Way to W Lincoln St
47 W WIF31 WW Impact Fee Davis Ln Lift Station,Interceptor,and Force Main 645,000 - 645,000 - - - - - - 645,000
48 W WIF32 WW Impact Fee Hidden Valley(Lift Station) - - - - - - - - 5,190,000 5,190,000
49 W WIF33 WW Impact Fee Davis La Lift Station Debt Service(W W1F24) - _ - 370,300 370,300 370,300 370,300 370,300 1,851,500
50 W WIF34 WW Impact Fee Annie Street Sanitary Sewer Upgrade - _ - _ _ _ _ -
51 W WIF35 WW Impact Fee Babcock Sanity Sewer Upgrade _ _ - 300,00- 245,000
P Sanitary PbR - 245,000 - - - - 245,000
52 W WLF36 WW Impact Fee Baxter Creek Basin-Cottonwood Road 18"Sanitary Sewer Extensions - - - 640,000 - - - - - 640,000
53 W WIF37 WW Impact Fee Hunters Way Sewer Capacity Upgrade - - - - 350,000 - - - - 350,000
54 W WIF35 WW Impact Fee Norton East Ranch Outfall Diversion&Interceptor - - - - 5,320,000 - - - - 5.320,000
2-14
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 W WIF39 WW Impact Fee Renova Street Sanitary Sewer Main Upgtade - - - - - - - - 16,000 16,000
56 WWIF40 WW Impact Fee Front Street Interceptor Debt Service(WWIFI I) - - - - 139,497 139,497 139,497 139,497 139,497 697,495
57 WWIF41 WW Impact Fee Norton East Ranch Outfatl Diversion Debt Service(WWIF38) - - - - - 211,960 211,960 211,960 211,960 947,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 $ 19A90,125 $ 56,190,193
2-15
Table 2-3
City of Bozeman,Montana
Wastewater Impact Fee Study
Summary of Capital Improvement Program By Plant Function
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 Functional Category
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 W W07 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 W W 08-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 W W54 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 W W45 Final and Secondary Clarifier Launder Covers 200,000 0 0 0 200,000 Treatment 200,000 0 0
20 W W49 Roll-Off Storage Building Construction and Possible 2nd Screw Press 2,100,000 0 0 0 2,100,000 Treatment 2.100,000 0 0
Enclosure
21 WW50 Refrigerated Automatic Sampler 10,000 0 0 0 10,000 Treatment 10,000 0 0
22 W W53 Positive Displacement Lobe Pumps 50,000 0 0 0 50,000 Treatment 50,000 0 0
23 W W58 Chip Seal and Topcoat WRF Asphalt 55,000 0 0 (55,000) 0 N/A 0 0 0
24 W W66 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 W W70 WRF Facility Engineering and Optimization 300,000 (300,000) 0 0 0 N/A 0 0 0
27 W W71 WRF Facility Master Plan Update 250,000 (250,000) 0 0 0 N/A 0 0 0
28 W W76 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 W W81 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 W W84 Server Replacement at WRF(Wrfctrlpri) 10,000 (10,000) 0 0 0 N/A 0 0 0
34 W W85 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,879,333 $15,750,687 $6,207,625 $920,021
2-16
Table 2-3
City of Bozeman,Montana
Wastewater Impact Fee Study
Summary of Capital Improvement Proeram By Plant Function
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 Functional Category
No. ID Project Description Capital Cost[1] Costs[2] Placeholders[3] Existing Users Expenditures Reference Treatment Transmission Collection
Wastewater Impact Fees(Growth Projects)
38 WWIFII Front Street Interceptor $2,185.000 $0 $0 $0 $2,185,000 Transmission $0 $2,185,000 $0
39 W W1F20 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 W WIF27 South University District/Cattail Creek Basin-S 15th Ave to Willow Way 795,000 0 0 0 795,000 Collection 0 0 795,000
to W Lincoln St
43 W WIF31 Davis Ln Lift Station,Interceptor,and Force Main 645,000 0 0 0 645,000 Transmission 0 645,000 0
44 YOW32 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 W WIF34 Annie Street Sanitary Sewer Upgrade 300,000 0 0 0 300,000 Transmission 0 300,000 0
47 W WIF35 Babcock Sanitary Sewer Upgrade 245,000 0 0 0 245,000 Transmission 0 245,000 0
48 W WIF36 Barter 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 W WIF39 Renova Street Sanitary Sewer Main Upgrade 16,000 0 0 0 16,000 Transmission 0 16,000 0
52 W WIF40 Front Street Interceptor Debt Service(W WIFI l) 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:
[I] 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
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 Amount Recognized[41 Percent to
Line Project Project Project In-Service Original New Facili6es/ Recognize
No. ID Project Description Cost[I] Status Date[21 Cost[3] Upgrades[5] Expansion Future/Direct for Expansion
WASTEWATER TREATMENT PROJECTS
Wastewater Fund(Renewals,Replacements,and Upgrades)
I GF227 ERP Replacement"Sungard Replacement/Upgrade" $130,687 Upgrade 1999 $66,031 $130,687 $0 $0 0.00%
2 W W45 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 W W76 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 W W81 Membrane Roof Replacement on Old Digester Building(Dig I&2) 60,000 Replacement 2007 39,320 60,000 0 0 0.00%
9 W W83 Ufat Gravity Thickener Drive and Arms Replacement 400,000 Replacement 1985 128,210 400,000 0 0 0.00%
10 W W85 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 W W08-18 Wastewater Pipe Replacement Program-Construction in 2018 1,000,000 Replacement 1948 96,269 1,000,000 0 0 0.00%
17 W W08-19 Wastewater Pipe Replacement Program-Construction in 2019 1,000,000 Replacement 1948 96,269 1,000,000 0 0 0.00%
18 W W08-20 Wastewater Pipe Replacement Program-Construction in 2020 1,000,000 Replacement 1948 96,269 1,000,000 0 0 0.00%
19 W W08-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 W W08-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 WWIFll Front Street Interceptor $2,185,000 New N/A N/A $2.185,000 $0 $0 0.00%
25 WWTF20 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 VMF24 Davis Lane(Lift Station) 5,800,000 New N/A N/A 5,800,000 0 0 0.00%
28 W WIF31 Davis Ln Lift Station,Interceptor,and Force Main 645,000 New N/A N/A 645,000 0 0 0.00%
29 WWI1732 Hidden Valley(Lift Station) 5,190,000 New N/A N/A 5,190,000 0 0 0.00%
30 W VIF34 Annie Street Sanitary Sewer Upgrade 300,000 Upgrade 2007 196,600 300,000 0 0 0.00%
31 W WIF35 Babcock Sanitary Sewer Upgrade 245,000 Upgrade 2007 160,557 245,000 0 0 0.00%
32 W WIF36 Baxter Creek Basin-Cottonwood Road 18"Sanitary Sewer Extensions 640,000 New N/A N/A 640,000 0 0 0.00%
33 W WIF37 Hunters Way Sewer Capacity Upgrade 350,000 Upgrade 1994 150,312 350,000 0 0 0.00%
2-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 Amount Recognized[41 Percent to
Line Project Project Project In-Service Original New Facilities/ Recognize
No. ID Project Description Cost[I] Status Date[21 Cost[3] Upgrades[5] Expansion Future/Direct for Expansion
34 W WIF38 Norton East Ranch Outfall Diversion&Interceptor 5,320,000 New N/A N/A 5,320,000 0 0 0.00%
35 W WIF39 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-19
Table 2-4
City of Bozeman,Montana
Wastewater Impact Fee Study
Summary of Capital Improvement Program Recognized in Wastewater System Impact Fees
Footnotes:
[1] Amounts shown are derived from Table 2-3 and do not include any capital expenditures classified as distribution-related or collection-related.
[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 theEngineering 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.
Reliability=Project which provides additional reliability 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.
2-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[61 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 cr 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-21
Table 2-5
City of Bozeman,Montana
Wastewater Impact Fee Study
Development of Wastewater System Impact Fee
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
Existing Capacity(MGD-ADF) 8.500
Capacity to Be Added During Forecast Period:FY 2018-2023(MGD-ADF) 0.000
Total Projected Capacity Needs 8.500
2-22
Table 2-6
City of Bozeman,Montana
Water Impact Fee Study
Calculation of Debt Service Credit-Wastewater System
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
Footnotes:
[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.
2-23
APPENDIX A
CLASSIFICATION OF EXISTING
WASTEWATER UTILITY SYSTEM ASSETS
Appendix A
Page 1 of 14
City of Bozeman,Montana
Wastewater Impact Fee Study
Classification of Existine Wastewater Utility System Assets 111
Wastewater System
Line Asset Acquired Asset Adj. General
No. Description ID Type Location Acquired Date Cost Adjustments[21 Acq.Amt. Treatment Trans. Collection Plant
Wastewater Utility Assets as of June 30,2017 111
1 Roller 11101 M&E Water Operations PURCHASED 7/1/1998 $ 4,395 $ - $ 4.395 $ - $ - $ - $ 4,395
2 Generator On Truck#I1 I8 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,939 - 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 Tluv 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 - - - 3&560
9 Prof Building Remodel Srves-Juno 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 I 262075 BLD Professional Building PURCHASED I/l/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 ProjecnSeptember 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 Fyl7 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/Strects(Heater):March Expd'S 32626 BLD City Shops-Lower Yard PURCHASED 3/19/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 B1dg: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:Topogmphy Work 344211 BLD City Shops-Lower Yard PURCHASED 9/12/2008 2,444 _ 2444 _ _ _ 2,444
29 Shops Remodel:Arch Svcs Thru 4/30/1I-April Expds 344215 BLD City Shops-Lower Yard PURCHASED 4/30/2011 2,800 2,800 2,800
30 New Shops B1dg:Phm Check Fees&Bid Request-May 344220 BLD City Shops-Lower Yard PURCHASED 5/15/2011 148 - 148 - - - 148
31 Shops RemodeLArch Svcs Thru 6/30/1I-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 Remodcl: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 Remodcl:Wa0cer Const Pmt#4-Oct Expds 344245 BLD City Shops-Lower Yard PURCHASED 10/1/201 I 22.542 - 22.542 - - _ 22,542
36 Shops Remodel:Archtrl Srve 9/01-10/30-Nov Expds 344250 BLD City Shops-Lower Yard PURCHASED i l/1/2011 447 _ 447 - _ _ 447
37 Shops Remodel:Walker Coast 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 RemodehPrep&Paint Doors-March Expds 344270 BLD City Shops-Lower Yard PURCHASED 3/1/2012 409 409 409
41 Shops RemodcHnnall Furnace-April Expds 344276 BLD City Shops-Lower Yard PURCHASED 4/27/2012 1.475 - 1A75 - - - 1.475
42 Shops RemodchInstall 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 -
Appendix A
Page 2 of 14
City of Bozeman,Montana
Wastewater Impact Fee Study
Classification of Existina Wastewater Utility System Assets[I I
Wastewater System
Line Asset Acquired Asset Adj. General
No. Description ID Type Location Acquired Date Cost Adjustments 121 Acq Amt. Treatment Trans Collection Plant
54 Shop Complex 4910 BLD City Shops PURCHASED 7/1/1998 65.000 - 65.000 - - 65,000 -
55 19ThInterchange 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/I/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 BureyAntics 22210 IMP Special Improv District PURCHASED 7/1/1983 281,632 - 281.632 - - 281.632 -
64 Sid 645 Sewer Kagy-Gmfs 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:Devcloper 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:Devcloper 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 L152,686 - 1,152.686 - 407.199 745,487 -
74 Fyl1 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 Fyl4 Private Sewer Infr:Dcveloper 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 1345,276 -
77 Fy16 Private Sewer Infr:Dcveloper 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:Devcloper Contributions 34099 IMP Wastewater Operation CONTRIBUTION 6/30/2017 3,985.609 - 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 - KOM - 28,261 51,739 -
-80 Sewer Repair E.Babcock-Replace Sewer Main 34292 IMP Wastewater Operation PURCHASED 8/l/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 ProjecuDesign 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 ProjecCDesign 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:I%Grt(Pee)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:Dcsign 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:Legat 9001Bid Ad 342910 IMP Wastewater Operation PURCHASED 3/l/2009 120 - 120 - 42 78
89 2008 Sewer Rehab Proj:Legat 5001/Bid Ad 342911 IMP Wastewater Operation PURCHASED 3/l/2009 66 - 66 - 23 43 -
90 2008 Sewer Rehab ProjecuDesign 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 - 5A22 - 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 ProjeckNovember 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 ProjecCPmt#3 April Expds 342923 IMP Wastewater Operation PURCHASED 4/24/2012 3.100 - 3.100 - 1,095 2.005
102 2012 Sewer Rehab Projec4Pmt#4 May Expds 342924 IMP Wastewater Operation PURCHASED 5/24/2012 1,750 - 1,750 - 618 1.132 -
103 2012 Sewer Rehab ProjecCPmt#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
106 2012 Sewer Rehab Project:Pmt#8 March Expds 342929 IMP Wastewater Operation PURCHASED 3/19/2013 53,340 - 53,340 - 18.843 34.497 -
107 2012 Sewer Rehab Prcjcct.•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 -
Appendix A Page 3 of 14
City of Bozeman,Montana
Wastewater Impact Fee Study
Classification of Existine Wastewater Utility System Assets 111
Wastewater System
Line Asset Acquired Asset Adj. General
No. Description ID Type Location Acquired Date Cost Ad,lustments[21 Aeg.Amt. Treatment Trans. Collection Plant
109 2012 Sewer Rehab Project•.Pmt#11 June Expds 342931 IMP Wastewater Operation PURCHASED 6/26/2013 2,836 - 2,836 - L002 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 ProjectPmt#19 March Expds 342938 RvII' 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 L699 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 ProjecuPmt#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 Fyl6 342943 IMP Wastewater Operation PURCHASED 9/24/2015 15.130 - 15,130 - 5.345 9.785 -
122 2012 Sewer Rehab Projeet:.Pmt#25 April Expds Fyl6 342944 IMP Wastewater Operation PURCHASED 4/21/2016 4,062 - 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 Fyl7 342946 IMP Wastewater Operation PURCHASED 7/21/2016 6,365 - 6.365 - 2,249 4.116 -
125 S University Sewer Main Pay#I: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 IlVIP Wastewater Operation PURCHASED 10/18/2016 367,251 - 367,251 - 367,251
127 S University Sewer Main Pay#3:Dee 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 Fyl7 342950 Va 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#S:Aprit Expds Fyl7 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/l/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/l/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 Cris 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 38179 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 Bridget Drive Sewer Main Project-Sept Expds 38661 IMP Wastewater Operation PURCHASED 9/30/2016 21,208 21.208 21,208 -
140 Sid739:OIive&Church Recnstretn Prj-Fyi7-June Exp 39913 IMP Special Improv District PURCHASED 6/1/2017 31,721 - 31.721 - - 31,721 -
141 Sid739:Ohve&Church Recnstretn Prj-Fyl7-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 Mechesney 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 - - 64A79 -
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.936
151 Sid 432 West End Sanitary Sewer 5530 IMP Special Improv District PURCHASED 7/1/1995 226,619 - 226.619 - - 226,619 -
152 Sid 511 Sanitary Sewer Thompson 5690 EvIP 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 595,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/l/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 - - _
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
Appendix A
Page 4 of 14
City of Bozeman,Montana
Wastewater Impact Fee Study
Classification of Existing Wastewater Utility System Assets it 1
Wastewater System
Line Asset Acquired Asset Adj. General
No. Description ID Type Location Acquired Date Cost Adjustments 121 Acq Amt. Treatment Trans Collection Plant
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 (7A97) 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.Rousc 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 Htc Software PURCHASED 12/1/2006 1,390 - 1,390 - - - 1,390
207 Hte Chck2Gov:Tax Billing Module(Sid Billing) 332452 M&E Hte Software PURCHASED 12/1/2006 1,938 - 1.938 - - - 1.938
208 Hte Click2Gov:Fina1 Core Module Install 332469 M&E Htc 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 Chck2Gov:Tax Billing+Collect Final Install 332488 M&E Hte Software PURCHASED 3/23/2007 225 225 225
211 Hte C1ick2Gov:Util Cc Activation Installation 332494 M&E Hte Software PURCHASED 3/23/2007 217 - 217 _ _ _ 217
212 Hte Cfick2Gov: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/i/2008 4,250 - 4.250 - 2,125 2.125
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,63 Remote Install 3324182 M&E Geographic Info Systems PURCHASED 4/17/2008 7.550 - 7.550 - 3,775 3.775 -
Appendix A
Page 5 of 14
City of Bozeman,Montana
Wastewater Impact Fee Study
Classification of Existing Wastewater Utility System Assets Ill
Wastewater System
Line Asset Acquired Asset Adj. General
No. Description ID Type Location Acquired Date Cost Adjustments f21 Acq.Amt. Treatment Trans Collection Plant
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-Ncw As400 Softwarc/Hardwarc 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 I1/14/2014 6,219 - 6,219 - - - 6,219
224 Ivr(Integrated Voice Recognition SoBware)June 15 37515 M&E Finance Department PURCHASED 6/30/2015 15,083 - 15.083 - - - 15,083
225 Ivr(Integrated Voice Recognitn Soffware)Aug Fy16 37517 M&E Finance Department PURCHASED 8/1/2015 6.233 - 6,233 - - - 6,233
226 Ivr(Integrated Voice Recognim Sofiwarc)Oct Fyl6 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 Sevin 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 Backboe 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 5A00 - 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/l/2007 16,873 - 16,873 - - - 16,873
264 01 Ford Tv Van Retrofitted For Sewer SB 3406 34063 M&E Wastewater Operation PURCHASED 5/24/2012 98,024 - 98.024 - - - 9&024
265 Camera Wheels Module&Accesorics-June SB 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/l/2009 7,060 - 7,060 - - - 7.060
268 2010KenworthDumpTruck 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
271 2013 Freightliner Sewer Jotter 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
Appendix A
Page 6 of 14
City of Bozeman,Montana
Wastewater Impact Fee Study
Classification of Existine Wastewater Utility System Assets Ill
Wastewater System
Line Asset Acquired Asset Adj. General
No. Description ID Type Location Acquired Date Cost Adjustments 121 Aeq.Amt. Treatment Trans. Collection Plant
274 2015 Ford F350 Super Duty(Whitc)+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/Power 50150 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 9/28/2001 98,211 - 98.211 - - - 98.211
286 Radio&Antenna 30311 VEH Wastewater Operation PURCHASED 9/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 Gme 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 Lino-Tv Van 34060 VEH Wastewater Operation PURCHASED 12/18/2007 196,000 - 196,000 - - - 196,000
293 Strobes,InsWI&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/l/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 Gone Sierra 3500 36200 VEH Water Operations PURCHASED 2/9/2012 27,971 - 27,971 _ _ _ 27.971
297 2012 Gone Sierra Truck Body/Hoist&Installation 36201 VEH Water Operations PURCHASED 5/24/2012 9,860 - 9,860 - - - 9.860
298 2012 Gme Sierra 3500:(5)Lightbars&Moumng Kit 36202 VEH Water Operations PURCHASED 6/27/2012 1210 - 1.210 - _ _ 1210
299 2012 Gme 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 Supereab:Install Light Bar&Paris 36681 VEH Wastewater Operation PURCHASED 6/27/2013 4,043 - 4,043 - - - 4,043
302 2016 Ford FI50 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 I5.870 15,870
305 2016 Ford F350 Tmek: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(Wr@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 Coast June Expds 488197 BLD Wastewater Plant PURCHASED 6/30/2013 32,324 - 32,324 32,324
312 Wrf UpgradeConst 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 489201 BLD Wastewater Plant PURCHASED 10/15/2013 28,719 - 28,719 28.719 - - -
316 WrfUpgmde 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 WrfUpgmde Const March Expds 488205 BLD Wastewater Plant PURCHASED 3/29/2014 27,950 - 27,950 27,950
320 Wrf UpgradeConst 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 43 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 - - _
326 Upgrade Truck Barn:Jan Expds 488213 BLD Wastewater Plant PURCHASED 1/8/2015 2,165 2,165 - 2,165
327 WrfUpgmde 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
Appendix A Page 7 of 14
City of Bozeman,Montana
Wastewater Impact Fee Study
Classification of Existint Wastewater Utility Svstem Assets III
Wastewater System
Line Asset Acquired Asset Adj. General
No. Description ID Type Location Acquired Date Cost Ad.justments[21 Acq.Amt. Treatment Trans. Collection Plant
329 Wrf Upgrade Digester#3 Constr March Expds 488217 BLD Wastewater Plant PURCHASED 3/1/2015 7,222 - 7.222 7.222
330 Wrf Upgmde:(2)Platfomms W/SafetyRailings:ChemTk 488218 BLD Wastewater Plant PURCHASED 4/2/2015 9.905 - 9,905 9.905
331 WrfUpgrede Digester#3 Constr April Expds 488219 BLD Wastewater Plant PURCHASED 4/8/2015 4.158 - 4,158 4.158
332 WrfUpgmde Digester#3 Constr May Expds 488220 BLD Wastewater Plant PURCHASED 5/18/201S 6.050 - 6,050 6,050
333 Wrf Upgrade Const June Fyl5 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 Upgmde Digester#3 Constr July Fyl6 Expds 488223 BLD Wastewater Plant PURCHASED 7/30/2015 8,651 - 8.651 8.651
336 Wrf Upgmde Digester#3 Constr Aug Fyl6 Expds 488224 BLD Wastewater Plant PURCHASED 8/30/2015 4.322 - 4,322 4,3212
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 Fyl6 Expds 488226 BLD Wastewater Plant PURCHASED 10/6/2015 265 - 265 265
339 Wrf Upgrade Digester#3 Constr Oct Fyl6 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 Fyl6 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 Fyl6 Expds 488231 BLD Wastewater Plant PURCHASED 1/29/2016 4,427 - 4,427 4.427
344 Wrf Upgrade Coast March Fyl6 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 i:July Expds Fy17 488235 BLD Wastewater Plant PURCHASED 7/31/2016 2,493 - 2.493 2,493
348 Wrf Upgrade Const Phase I:Sept Expds Fy17 498236 BLD Wastewater Plant PURCHASED 9/30/2016 3,490 3,490 3,490
349 Wrf Upgrade Const Phase 1:Oct Expds Fy17 498237 BCD Wastewater Plant PURCHASED 10/10/2016 13,003 - 13.003 13.003
350 Wrf Upgmde Const Phase I:Jan Expds Fyl7 488238 BLD Wastewater Plant PURCHASED 1/10/2017 6,681 - 6.681 6.681
351 WrfUpgmde Const Phase l: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 Fyl7 488240 BLD Wastewater Plant PURCHASED 4/11/2017 11,295 - 11,295 11.295
353 Wrf Upgrade Const Phase 1:May Expds Fyl7 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 &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 Halt,121 N.Rouse PURCHASED 6/6/2012 1,020 - 1,020 - - - 1.020
369 Hte CGck2Gov:Digital Certificate-Cx 332428 M&E Hte Software PURCHASED 12/1/2006 120 - 120 - - - 120
370 Hte Click'-)Gov-.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 C1ick2Gov: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 Chck2Gov:Uti1 Cc Activation Installation 332495 M&E Hte Software PURCHASED 3/23/2007 217 217 217
377 Hte CGck2Gov:Ut l Cx Final Installation 3324101 M&E Hte Software PURCHASED 3/23/2007 300 300 300
378 Server-Data Backup Managr:S14974.55 Split Citywide 3324146 M&E Information Technology PURCHASED 11/1/2007 599 - 599 - - - 599
379 P7-New As400 Softwarefflardware 36144 M&E City Hall:121 N.Rouse PURCHASED 6/28/2011 5,187 - 5.187 - - - 5.187
380 WrfUpgrade:PlcSofivare 488209 M&E Wastewater Plant PURCHASED 9/1/2014 15,039 - 15.039 15.039 - - -
381 Sigma Sampler 17140 M&E Wastewater Plant PURCHASED 7/l/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
Appendix A Page 8 of 14
City of Bozeman,Montana
Wastewater Impact Fee Study
Classification of Existine Wastewater Utility System Assets 111
Wastewater System
Line Asset Acquired Asset Adj. General
No. Description ID Type Location Acquired Date Cost Ad.justmentsf2f Aeg.Amt. Treatment Trans. Collection Plant
394 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 195J90 - 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 Freighincr 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/l/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 5650 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/l/2006 18,844 - 18,844 - - - l&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 Prins(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 2742 _ 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 3276 - 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 Grant56Ep04 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
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 311 SI2005 8,978 - 8,978 8978 - - -
438 Epa Grant 56Ep04 320669 IMP Wastewater Plant GRANT 4/15/2005 4,891 - 4.891 4.891 - - -
Appendix A
Page 9 of 14
City of Bozeman,Montana
Wastewater Impact Fee Study
Classification of Existing Wastewater Utility System Assets Ill
Line Asset Acquired Asset Wastewater System
9 Adj. General
No. Description ID Type Location Acquired Date Cost Adjustments[21 Acq.Amt. Treatment Trans Collection Plant
439 Epa Grant 56Ep04 320680 IMP Wastewater Plant GRANT 6/15/2005 152,955 152.955 152.955 -
440 N Rouse Sewer Construction Services Thm 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/l/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 124A90 - _ -
452 Epa Grant Fy04 Wastewater Faciltles 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 Grant56Ep06 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 190,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 Thor 9/9/05 320684 BLD Wastewater Plant GRANT 9/9/2005 4,141 - 4.141 4,141
473 2003 Wwtp ModificatiomFinal 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 ModifProject Const Insp Thru 10114-11111105 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 ModifProject 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/l/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/l/2002 529,845 - 529,845 529,845
482 Epa Grant Fy03 Wasetwater Facilities Proj-56Ep04 320610 IMP Wastewater Plant GRANT 7/l/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 Pr*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 4894 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
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 Thm 7/29/05 4888 BLD Wastewater Plant PURCHASED 8/17/2005 1,381 - 1,381 1,381 - - _
Appendix A Page 10 of 14
City of Bozeman,Montana
Wastewater Impact Fee Study
Classification of Existing Wastewater Utility System Assets III
Wastewater System
Line Asset Acquired Asset Adj. General
No. Description ID Type Location Acquired Date Cost Adjustments 121 Acq.Amt. Treatment Trans. Collection Plant
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+l%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 O1/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 9X0
511 Wwtp Early Out Proj:Design Svcs Thru 2/16/07 48826 BLD Wastewater Plant PURCHASED 3/l/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 Prcj: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/l/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 Prcj: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:Dcsign Svcs Thru 9/l/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/l/2007 101,762 - 101,762 101,762
527 Wwtp Reroofing:l%Grt(Metalworks)Tbru 8/31/07 48842 BLD Wastewater Plant PURCHASED 9/l/2007 1.028 - 1,028 1,028
528 Wwtp Upgrade Proj:Design Svcs Thru 9/l/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 Prcj: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:lnspection 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 Prcj:Design Svcs Thru 2/2/08 48862 BLD Wastewater Plant PURCHASED 1/31/2008 439,551 - 439,551 439,551
546 Wwtp Upgrade Proj:Prof Svcs Thru 3/l/08 Phase 1 48963 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 48965 BLD Wastewater Plant PURCHASED 4/21/2008 5,682 - 5.682 5.682 - - _
AppendixA Page 11 of 14
City of Bozeman,Montana
Wastewater Impact Fee Study
Classification of Existing Wastewater Utility System Assets fI l
Wastewater System
Line Asset Acquired Asset Adj. General
No. Description ID Type Location Acquired Date Cost Adjustments[21 Acq.Amt. Treatment Trans Collection Plant
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:Dcsign Svcs Thru 3/29/08 48869 BLD Wastewater Plant PURCHASED 5/12/2008 253,286 - 253,296 253,286
551 Wwtp Early Out:Mixer Equip Purchase Phase I 48870 BLD Wastewater Plant PURCHASED 5/27/2008 3,274 - 3.274 3274
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/l/O9-5/7/08 48872 BLD Wastewater Plant PURCHASED 6/I/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 Tarn 8/18/09 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:Dcsign Svcs Thru 8/30/08 48877 BLD Wastewater Plant PURCHASED 9/17/2008 63,682 - 63.682 63,682
559 Wwtp Early OutConstr 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/2009 1,313 - 1.313 1.313
561 Wwtp Early OutConstr 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 48893 BLD Wastewater Plant PURCHASED 1/14/2009 20,287 20,287 20.287
565 Wwtp Upgrade Proj:Design Svcs Tarn O1/31/09 49884 BLD Wastewater Plant PURCHASED 2/17/2009 49,257 - 49.257 49.257
566 Wrf Upgrade Ph.i:Const Svcs Thru O1/31/09 Pmt#I 48885 BLD Wastewater Plant PURCHASED 2/19/2009 328.613 328.613 328,613
567 WrfUpgmde Ph.1:1%Grt(Williams)Pmt#I Thru 01/31 48886 BLD Wastewater Plant PURCHASED 2/19/2009 3319 - 3.319 3.319
568 WrfUpgmde Ph.1:Fsp Planning Review Fees 48887 BLD Wastewater Plant PURCHASED 2/27/2009 220 220 220
569 WrfUpgradc Ph.I:Lcgat200I/BidAd 48888 BLD Wastewater Plant PURCHASED 3/I/2009 253 - 253 253
570 WrfUpgmde Ph.I:Building Inspection Admin Costs 48889 BLD Wastewater Plant PURCHASED 3/I/2009 3,591 - 3.591 3.591
571 WrfUpgmde Ph.I:Boundary Realignmut 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 WrfUpgmde Ph.I:Const Admin Svcs Thru 02/28/09 48892 BLD Wastewater Plant PURCHASED 3/16/2009 60,055 - 60.055 60,055
574 WrfUpgmde Ph.I:Const Svcs Thru 04/07/09 Pmt#2 48893 BLD Wastewater Plant PURCHASED 3/31/2009 872,282 - 872.282 872,292
575 Wrf Upgrade Ph.l:l%Grt(Williams)Pmt#2 Thru 04/07 48894 BLD Wastewater Plant PURCHASED 3/31/2009 8.811 - 8.911 &811
576 Wwtp Upgmde:Bldg Permits 255 Moss Bridge Rd 48895 BLD Wastewater Plant PURCHASED 4/3/2009 834 - 834 834
577 Wwtp Upgrade Proj:Design Svcs Tarn 04/09/09 48896 BLD Wastewater Plant PURCHASED 4/20/2009 9,780 - 9.780 9,780
578 WrfUpgmde Ph.I:Const Admin Svcs Thru 04/09/09 48897 BLD Wastewater Plant PURCHASED 4/20/2009 48,260 - 48.260 48.260
579 Wwip 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 WrfUpgmdcPh.l:l%Grt(Williams)Pmt#3 Thru 04/30 488100 BLD Wastewater Plant PURCHASED 4/30/2009 2,100 - 2,100 2,100
582 Wrf Upgradc Ph.1:Const Admin Svcs Thru 04/25/09 489101 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 Upgradc: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 I:Fence Relocation/Gate Installam 498104 BLD Wastewater Plant PURCHASED 5/31/2009 1,690 - 1,690 1.690
586 WrfUpgmde Ph.I: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 WrfUpgmde Ph.1:1%Grt(Williams)Pmt#4 Thru 05/31 488106 BLD Wastewater Plant PURCHASED 5/31/2009 19.516 - 18,516 18.516
588 Wrf Upgradc Ph.I:Prof Svcs Thru 05/29/09 488107 BLD Wastewater Plant PURCHASED 6/1/2009 8,439 - 8.439 8.439
589 Wrf Upgradc Ph.I:Prof Svcs Thm 05/29/09 488109 BLD Wastewater Plant PURCHASED 6/1/2009 1,623 - 1,623 1.623
590 Wrf Upgrade Ph.I:Const Admin Svcs Thru 05/28/09 488109 BLD Wastewater Plant PURCHASED 6/15/2009 79,187 79,187 79,187
591 WrfUpgmde Ph.I:Const Admin Svcs Thru 04/25/09 488110 BLD Wastewater Plant PURCHASED 6/15/2009 8,864 - 8,864 8,864
592 WrfUpgmde Ph.I:Dcsign Svcs Thru 06/27/09 488111 BLD Wastewater Plant PURCHASED 6/27/2009 36,833 36,833 36,833
593 Wrf Upgrade Ph.I:Const Admin Svcs Thru 06/27/09 488112 BLD Wastewater Plant PURCHASED 6/27/2009 99,192 - 99.192 99,192
594 WrfUpgmde 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.l:l%Grt(Williams)Pmt#5 Thru 06/30 488114 BLD Wastewater Plant PURCHASED 6/30/2009 19,519 - 19,519 19,519
596 WrfUpgmde 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 498117 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
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 WrlUpgrade Constr February Expds Fy10 488122 BLD Wastewater Plant PURCHASED 2/25/2010 625.005 - 625.005 625.005 - - _
Appendix A Page 12 of 14
City of Bozeman,Montana
Wastewater Impact Fee Study
Classification of Existing Wastewater Utility Svstem Assets Ill
Wastewater System
Line Asset Acquired Asset Adj. General
No. Description ID Type Location Acquired Date Cost Adjustments(2l Acq.Amt. Treatment Trans. Collection Plant
604 Wrf Upgradc 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 Upgradc Admin/Lab Constr May Expds 488126 BLD Wastewater Plant PURCHASED 5/10/2010 10,000 - 10,000 10,000
608 Wrf Upgradc 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 Upgradc 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 Upgradc Constr July Expds 488131 BLD Wastewater Plant PURCHASED 7/22/2010 128,608 128,608 12808
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 Upgradc Admin/Lab Constr Aug Expds 488134 BLD Wastewater Plant PURCHASED 8/1/2010 65A27 - 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 WrfUpgmde 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 Upgradc 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 Dee Expds 488146 BLD Wastewater Plant PURCHASED 12/31/2010 972.325 - 972.325 972325
628 Wrf Upgradc 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 Dee 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.696 685.686
633 Wrf Upgrade Constr Feb Expds 488152 BLD Wastewater Plant PURCHASED 2/22/2011 882,515 - 882.515 882,515
634 Wrf Upgradc 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 WrfUpgmde Digester#10Constr 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 Upgradc 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.897
642 Wrf Upgradc 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 Upgmde 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 Fyt 1 488165 BLD Wastewater Plant PURCHASED 6/30/2011 26,331 - 26331 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 Admiraab Constr July Expds 488167 BLD Wastewater Plant PURCHASED 7/31/2011 5,501 - 5,501 5.501
649 Wrf Upgradc 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 614391 614.391
651 Wrf Upgradc 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
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:WonderwarcSRwre/Scada:Febmary Expds Fy12 488177 BLD Wastewater Plant PURCHASED 2/13/2012 3,283 - 3,283 3,283 - _ _
Appendix A Page 13 of 14
City of Bozeman,Montana
Wastewater Impact Fee Study
Classification of Existine Wastewater Utility System Assets i11
Wastewater System
Line Asset Acquired Asset Adj. General
No. Description ID Type Location Acquired Date Cost Adjustments j21 Acq.Amt. Treatment Trans. Collection Plant
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 498179 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 UpgradeConst May Expds 488181 BLD Wastewater Plant PURCHASED 5/22/2012 1,125,057 - 1,125,057 1,125,057
663 Wrf UpgradeConst June Expds 488182 BLD Wastewater Plant PURCHASED 6/29/2012 209,333 209,333 209.333
664 Wrf UpgradeConst 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 Constrcm Retainage Thru 6/30/12 488195 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 UpgradeConst 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 Heamg Biocide 488192 BLD Wastewater Plant PURCHASED 1/17/2013 2,460 2,460 2.460
673 WdUpgrade Const Feb Expds 488193 BLD Wastewater Plant PURCHASED 2/5/2013 68.713 68,713 68.713
674 Wrf Upgmde Const March Expds 488194 BLD Wastewater Plant PURCHASED 3/15/2013 23,477 - 23,477 23A77
675 WdUpgrade Const April Expds 488195 BLD Wastewater Plant PURCHASED 4/11/2013 15,876 - 15,876 15.876
676 WdUpgrade Const May Expds 488196 BLD Wastewater Plant PURCHASED 5/17/2013 50,395 - 50.395 50.395 - -
677 Wrf Wonderware Sftwre/Seada:February Expds Fyl0 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 InstallatiomApril 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 Fyl I-June Expds 32151 IMP Wastewater Operation PURCHASED 6/30/2011 224,616 - 224,616 - 224,616 - _
684 Kohls Impfee Credit:Gmnary Project 32152 IMP Wastewater Operation PURCHASED 1/23/2012 8,838 - 8.838 - - - 8.838
685 Impact Fee/Sewer Oversizing Cottonwood:lfcr-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 6A76 - 6.476
687 Public Sewer Improv:Oversizing-HuiTme+Cottomvood 34290 IMP Wastewater Operation PURCHASED 9/19/2007 42,862 42,862 42,862 _
698 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 $ (L802,729) $ 193,300,074 $ 71,944.667 $ 39,980301 $ 71,578AI S $ 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%
TOTAL ASSETS CONSIDERED AS DONATIONS/
695 CONTRIBUTIONS[31 CONTRIBUTION $ 122.528.799 $ 15,262.162 $ 35.856.343 $ 65.644,644 $ 5.765,651
GRANT
Appendix A Page 14 of 14
City of Bozeman,Montana
Wastewater Impact Fee Study
Classification of Existine Wastewater Utility Svstem Assets[11
Wastewater System
Line Asset Acquired Asset Adj. General
No. Description ID Type Location Acquired Date Cost Adjustments[21 Acq.Amt. Treatment Trans. Collection Plant
Footnotes:
[1] Amounts shown are derived lbom 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:
and iii)mtemaking 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 $ $ $