HomeMy WebLinkAbout09-24-2018 Council Work Session PacketOrono City Council
Work Session
Monday, September 24, 2018
Council Chambers 5:00 p.m.
AGENDA
1. Enterprise Budget Discussion
2. LMCD — Mark Kroll
3. Stubbs Bay Parking
Annual:
• Budget: Part of June, All of July, August and October.
• City Administrator & Police Chief Update (3 times per year for 15 minutes)
Previous Work Session Topics
August 27, 2018
• Budget Discussion
• Stormwater Planning Discussion
• Orono Oaks Drive Discussion
July 23, 2018
• Fire Department Debriefing (Tentative)
• Budget Discussion
June 25, 2018
• Police Department Response Update
• Curb and Gutter Discussion
• Budget Discussion
• Contract Update Discussion
TO: Mayor Walsh and Council Members
FROM: Ron Olson, Finance Director
DATE: September 24, 2018
SUBJECT: 2019 Enterprise Fund Budgets
Attachments:
1. Enterprise Funds Summary
2. Enterprise Fund Line Items
3. CIP Pages
4. Rate Study Profit/Loss Projections
The enterprise fund budgets consist of the Water, Sewer, Stormwater, Recycling and Cable TV Funds.
Unlike the General Fund, the accounting in the enterprise funds is similar to the accounting practices
of private enterprise. The goal of the enterprise funds is to operate independent of tax support. 2012
was the first year that a formal budget was adopted for the enterprise funds. Prior to 2010, the
enterprise funds did not attempt to cover depreciation expenses. Beginning with the completion of
the 2009 rate study, the suggested rate increases were designed to cover depreciation. The rate study
was reviewed in 2014 and the suggested rate increases are used to set the annual revenue budget.
Staff is currently working on an updated rate study.
Water Fund
The water fund has historically been operating at a loss. Because depreciation is a non-cash
expenditure, the fund has had a positive operating cash flow since 2009. In most years, the operating
loss has been covered by the revenue received from antenna leases on the water towers. Effective in
2018, the tower revenue has been moved out of the Water Fund. The reduction of lease revenue and
an increase in the administrative charge will need to be recovered in rates. Based on the staff's work
on the rate study, rates will need to continue increasing at an 11% rate for the next 5 years to reach
profitability.
The expenditure budget is increasing by $215,789 (31.2%). $60,329 of the increase is in Personal
Services and is the result of allocating the Public Works staff to more accurately reflect their time.
Depreciation is increasing $77,400 due to the addition of Well 4 and other additions to the system.
The Administrative Charge is increasing by $86,660. These three areas account for $224,389 of the
increase. The operating transfer of $55,000 is to the debt service fund supporting the Casco Point
Bonds ($55,000). The non-operating interest expense is for the interest on the 2014 Water Bonds.
A total of $474,855 of capital expenditures are identified in the 2019 draft CIP include: North Water
Plant Painting ($21,000), South Water Plant Painting ($78,000), a screen at Well 3 ($92,000), Water
Main Replacement at CSAH at Cty 15/19 ($169,855), annual Valve Replacements ($24,000) and
water meter replacements ($90,000) for a total cost of $474,855. The Water Fund's current cash
balance is $847,960.
Sewer Fund
In recent years, the sewer fund has mostly operated at a loss. Non-operating revenues however, have
consistently offset the operating losses. This has resulted in a positive operating cash flow for the
fund.
The single largest expense for the sewer fund is the Met Council disposal charges. The three years
have seen increases in the amounts of $37,410 (9.5%), $41,277 (9.6%) and $123,425 (28.6)
respectively. This is a 40% increase in three years. As has been discussed with the Council during
previous budget processes, heavy rains and high water tables increase the flow through the MCES
lift stations and increase our disposal charges.
The total operating expenditure budget is increasing by $213,675 (15.2%) The major increases are
the previously mentioned MCES charges ($123,425), repairs and maintenance for sewer lines
($57,280) and the Administrative Charge ($70,660). The operating transfer is to cover the sewer
improvements that were part of the Casco Point project and will continue for another five years.
Upcoming capital expenditures can be covered by the fund's current cash balances. Projects
identified in the CIP for 2019 include: Annual sewer rehabilitation ($281,377), Sewer televising
($48,690), additional generators ($150,000), lift station updates ($116,000); lift station monitoring
improvements ($26,000), sewer main replacements ($198,000), and a generator rehabilitation
($10,000), for a total of $820,068. The current cash balance for the fund is $2,426,737.
Storm Water
The Stormwater Fund is for the most part project based. Operating expenditures are mainly limited
to engineering associated with NPDES, SWPPP and other state and federal requirements. Public
Works time and materials spent on culvert cleaning/replacement are also charged to this fund. The
purpose of this fund is to collect money for the larger Stormwater projects that will be required in the
future. The attached five-year projection assumes a 10% annual increase.
Potential CIP projects in 2019 include: Watershed Delineation and Pond Assessments ($10,000),
Forest Arms Lane ($69,324), East Long Lake S ($63,515), Tonkaview Lane ($87,531), Chevy Chase
Drive ($146,330), East long Lake Road N ($82,000), Storm Sewer Improvements ($200,000), TMDL
Updates ($50,000), and OCB pipe upsizing (88,500). The capital expenditures total $798,200. The
funds current cash balance is $1,775,011.
Recycling
The recycling fund was newly created in 2013. Its major expenditure line is for contracted
recycling charges. The current contract with Waste Management is increasing 2.5% increase. The
Recycled Materials offset that the City was receiving in 2017 has not been being paid in 2018. The
offset is based on the market for recycled materials which weakened it 2018. The full time wages
that are charged to the fund represent 10% of the City Clerks wages. The current cash balance is
$32,436.
Cable
The Cable fund was new for the 2015 budget. The projected revenues are based on current
subscriber information and rates. The line item for Internet/Other communications covers the costs
associated with streaming and online access of council meetings. It has been increased to pay for
the increased cost of our fiber internet connection.
Revenue for the fund is in the from franchise fees that are set by the City's franchise agreement
with Mediacom. Capital Expenditures in 2019 will include upgrades to the presentation equipment
in the Council Chambers. The current cash balance of the fund is $153,373.
Rate Study
As mentioned above, staff is currently working on a rate study on which to base future utility rates.
Projected expenditure budgets have been prepared and the revenues needed to fund the expenses are
known. For Water, the current work on the study involves separating the expenses of the North and
South water systems to determine if the two systems should have different. The South system
provides softened water and the North does not. However, the South system has more connections
to spread the water plant overhead costs than the North system does. Staff is also exploring
changing the rate increases between usage tiers. We know that the revenue increases need to be
around 11%, but there maybe more equitable ways to structure the increase than a system wide rate
increase.
For Sewer, the revenue increase has been calculated at 4%. In the areas connected to the Long
Lake and Wayzata systems, we are charged based on usage for properties that are also connected to
water. On some properties this results in the Orono paying a higher amount to the providing city
than we are charging the resident. Staff is looking at changing our billing for these areas to be
based on the water meter readings. This would be a move away from the flat rate that has always
been used.
2019 Water Fund Operating Budget 2019 Enterprise Budget - Attachment - 1
Departmental Summary
49400
PROGRAM DESCRIPTION & OBJECTIVES:
The Water Operating Fund provides for the funding of the City's water distribution system. These funds
are accounted for separately and are designed to be funded primarily through water rates.
OPERATING COST ACTIVITIES:
*Included in 'Personal Services' are the wages and employment taxes for the Water Department Staff.
Staff includes: Director of Public Works (20%), Public Works Supervisors (25%), Maintenance
Workers (25%) and a Seasonal Employee.
*Supplies & Maintenance' includes the operating supplies and maintenance for the water distribution system.
*Professional Services' includes a portion of the costs related to the City's annual financial audit, IT
Services, and engineering consulting costs related to water projects.
*Other Expenses' include power supply costs, purchased water from the City of Wayzata, and a
depreciation charge on the fixed asserts.
0
2019
Dollar
%
2017
2017
2018
Y -T -D
Mgr
Increase
Increase
Budget
Actual
Budget
Jun 30, 2018
Recommd
(Decrease)
(Decrease)
Personal Services
182,150
181,929
187,131
87,409
247,460
60,329
32.24%
Supplies & Maintenance
139,700
97,893
148,700
57,823
130,810
(17,890)
-12.03%
Professional Services
22,700
24,032
24,900
11,154
36,700
11,800
47.39%
Insurances
10,280
10,280
10,280
5,140
7,070
(3,210)
-31.23%
Other Expenses
254,800
323,522
265,600
53,055
430,360
164,760
62.03%
Operating Transfers
55,000
55,000
55,000
0
55,000
0
Total Water Operating Fund
664,630
692,655
691,611
214,581
907,400
215,789
31.20%
PROGRAM DESCRIPTION & OBJECTIVES:
The Water Operating Fund provides for the funding of the City's water distribution system. These funds
are accounted for separately and are designed to be funded primarily through water rates.
OPERATING COST ACTIVITIES:
*Included in 'Personal Services' are the wages and employment taxes for the Water Department Staff.
Staff includes: Director of Public Works (20%), Public Works Supervisors (25%), Maintenance
Workers (25%) and a Seasonal Employee.
*Supplies & Maintenance' includes the operating supplies and maintenance for the water distribution system.
*Professional Services' includes a portion of the costs related to the City's annual financial audit, IT
Services, and engineering consulting costs related to water projects.
*Other Expenses' include power supply costs, purchased water from the City of Wayzata, and a
depreciation charge on the fixed asserts.
0
2019 Sewer Fund Operating Budget 2019 Enterprise Budget - Attachment - 1
Departmental Summary
49450
PROGRAM DESCRIPTION & OBJECTIVES:
The Sewer Operating Fund provides for the funding of the City's sewer collection system. The funds
are accounted for separately and are designedto be funded primarily through sewer unit charges.
OPERATING COST ACTIVITIES:
*Included in 'Personal Services' are the wages and employment taxes for the Sewer Department Staff.
Staff includes: Director of Public Works (30%), Public Works Supervisors (25%), Maintenance Workers (25%)
*'Supplies & Maintenance' includes the operating supplies and maintenance for the sewer collection system.
*'Professional Services' includes a portion of the costs related to the City's annual financial audit, IT Services, and engineering
consulting costs related to sewer projects.
*'Other Expenses' includes the City's disposal charges with the MCES, and a depreciation charge on fixed assets.
2
2019
Dollar
2017
2017
2018
Y -T -D
Mgr
Increase
Increase
Budget
Actual
Budget
Jun 30, 2018
Recommd
(Decrease)
(Decrease)
Personal Services
309,360
309,163
318,198
147,184
276,490
(41,708)
-13.11%
Supplies & Maintenance
142,450
181,680
163,922
37,336
202,470
38,548
23.52%
Professional Services
25,500
22,276
25,500
4,240
42,750
17,250
67.65%
Insurances
18,930
18,930
18,930
9,465
12,730
(6,200)
-32.75%
Other Expenses
873,590
880,781
883,690
332,644
1,089,475
205,785
23.29%
Operating Transfers
110,000
100,000
110,000
0
110,000
0
0.00%
Total Sewer Operating Fund
1,479,830
1,512,830
1,520,240
530,869
1,733,915
213,675
14.06%
PROGRAM DESCRIPTION & OBJECTIVES:
The Sewer Operating Fund provides for the funding of the City's sewer collection system. The funds
are accounted for separately and are designedto be funded primarily through sewer unit charges.
OPERATING COST ACTIVITIES:
*Included in 'Personal Services' are the wages and employment taxes for the Sewer Department Staff.
Staff includes: Director of Public Works (30%), Public Works Supervisors (25%), Maintenance Workers (25%)
*'Supplies & Maintenance' includes the operating supplies and maintenance for the sewer collection system.
*'Professional Services' includes a portion of the costs related to the City's annual financial audit, IT Services, and engineering
consulting costs related to sewer projects.
*'Other Expenses' includes the City's disposal charges with the MCES, and a depreciation charge on fixed assets.
2
2019 Recycling Fund Operating Budget 2019 Enterprise Budget - Attachment - 1
Departmental Summary
49500
PROGRAM DESCRIPTION & OBJECTIVES:
The city participates in a program to provide curbside recycling service. In addition, the city also provides a spring cleanup day
for residents who have materials unsuitable for curbside recycling pickup.
OPERATING COST ACTIVITIES:
*Personal Services are a portion of the City Clerk's wages and the wages for City Staff whom participate in the spring cleanup.
*Other Expenses includes disposal of items collected during the clean up day and materials related to organics recycling.
*'Professional Services includes the costs associated with recycling collection.
3
2019
Dollar
2017
2017
2018
Y -T -D
Mgr
Increase
Increase
Budget
Actual
Budget
Jun 30, 2018
Recommd
(Decrease)
(Decrease)
Personal Services
6,830
6,748
6,980
3,490
7,400
420
6.02%
Supplies & Maintenance
1,000
0
1,500
0
0
(1,500)
-100.00%
Professional Services
110,500
104,205
115,000
54,400
117,880
2,880
2.50%
Insurances
500
500
500
0
500
0
0
Other Expenses
6,170
11,750
6,170
7,477
8,750
2,580
41.82%
Recycling Total
125,000
123,203
130,150
65,367
134,530
4,380
3.37%
PROGRAM DESCRIPTION & OBJECTIVES:
The city participates in a program to provide curbside recycling service. In addition, the city also provides a spring cleanup day
for residents who have materials unsuitable for curbside recycling pickup.
OPERATING COST ACTIVITIES:
*Personal Services are a portion of the City Clerk's wages and the wages for City Staff whom participate in the spring cleanup.
*Other Expenses includes disposal of items collected during the clean up day and materials related to organics recycling.
*'Professional Services includes the costs associated with recycling collection.
3
2019 Stormwater Fund Operating Budget 2019 Enterprise Budget - Attachment - 1
Departmental Summary
49910
2019 Dollar %
2017 2017 2018 Y -T -D Mgr Increase Increase
Budget Actual Budget Jun 30, 2018 Recommd (Decrease) (Decrease)
Personal Services
47,380
42,134
48,662
21,824
128,030
79,368
163.10%
Supplies & Maintenance
30,000
4,477
31,300
4,270
31,530
230
0.73%
Professional Services
19,500
35,490
19,500
8,377
21,500
2,000
10.26%
Insurances
1,970
1,970
1,970
985
3,380
1,410
71.57%
Other Expenses
52,700
105,629
59,700
10,039
172,210
112,510
188.46%
Total Stormwater Operating Fund
151,550
189,699
161,132
45,495
356,650
195,518
121.34%
PROGRAM DESCRIPTION & OBJECTIVES:
The Stormwater Operating Fund provide sfunding to for the City's Stormwater responsibilities. The funds
are accounted for separately and are designedto be funded primarily through stormwater service and trunk fees.
OPERATING COST ACTIVITI ES:
*Included in 'Personal Services' are the wages and employment taxes for the Public Works Department Staff.
Staff includes: Director of Public Works (10%), Public Works Supervisors (25%), Maintenance Workers (5%)
* Supplies & Maintenance includes material associated with culvert maintenance.
*Other Expenses includes depreciation and an administrative charge and the annual LMCD Levy.
*'Professional Services includes engineering and annual audit charges.
4
2019 Enterprise Budget - Attachment - 1
2019 Cable TV Operating Budget
Departmental Summary
49840
PROGRAM DESCRIPTION & OBJECTIVES:
The Cable TV Fund was created to account for the Franchise fees that are collectected as part of
the City's Franchise agreement with Mediacom. Expenditures include costs associated with
recording and streaming meetings.
OPERATING COST ACTIVITI ES:
*Included in 'Personal Services' are 10% of the wages for the IT Tech
*'Professional Services includes IT Services and audit charges.
* Other Expenses include webcasting/online content and an administrative charge to the General Fund
2019
Dollar
2017
2017
2018
Y -T -D
Mgr
Increase
Increase
Budget
Actual
Budget
Jun 30, 2018
Recommd
(Decrease)
(Decrease)
Personal Services
13,660
11,957
14,445
7,223
18,430
3,985
27.59%
Supplies & Maintenance
500
985
2,000
330
2,000
0
0.00%
Professional Services
4,500
6,335
2,000
840
9,500
7,500
375.00%
Other Expenses
22,100
19,987
32,100
21,101
37,100
5,000
15.58%
Total Sewer Operating Fund
40,760
39,264
50,545
29,493
67,030
16,485
32.61%
PROGRAM DESCRIPTION & OBJECTIVES:
The Cable TV Fund was created to account for the Franchise fees that are collectected as part of
the City's Franchise agreement with Mediacom. Expenditures include costs associated with
recording and streaming meetings.
OPERATING COST ACTIVITI ES:
*Included in 'Personal Services' are 10% of the wages for the IT Tech
*'Professional Services includes IT Services and audit charges.
* Other Expenses include webcasting/online content and an administrative charge to the General Fund
Personal Services
101 Full -Time Employees Regular
102 Full -Time Employees Overtime
103 Part -Time Employees
104 Temporary Employees Regular
121 PERA
122 FICA
135 City Benefit Contribution
143 OPEB Expense
151 Worker's Comp Insurance Prem
Total Personal Services
Supplies & Maintenance
201 Office supplies
212 Motor Fuels & Lubricants
216 Chemicals and Chem Products
221 Equipment Parts & Accessories
222 Vehicle Equipment & Parts
223 Bldg/Grounds Maint. Supplies
226 Clothing & personal equipment
227 Utility System Maint. Supplies
240 Small Tools and Minor Equip
401 Repairs/Maint-Office Equip
402 Repairs/Maint-Auto Equip
403 Repairs/Maint-Misc. Equip
404 Repairs/Maint-Bldgs/Grounds
405 Repairs/Maint-Watermains/plant
416 Software Licensing
City of Orono 2019 Enterprise Budget - Attachment 2
2019 Line Item Budget
Water
49400
175,510 181,929 187,131 134,696 247,460 60,329 32.24%
0
44
200
0
2019
Dollar
%
2016
2017
2018
Y -T -D
Mgr
Increase
Increase
Actual
Actual
Budget
Jul 31, 2018
Recommd
Decrease
Decrease
116,806
108,869
116,233
91,605
147,460
31,227
26.87%
9,971
14,185
10,000
3,528
10,000
0
0.00%
9,749
12,183
11,977
8,570
15,510
3,533
29.50%
0
0
0
0
7,500
7,500
N/A
9,975
10,068
10,366
6,162
12,980
2,614
25.22%
10,209
10,213
10,573
7,171
13,810
3,237
30.62%
15,130
21,970
21,676
15,406
29,590
7,914
36.51%
0
0
1,800
0
1,800
0
0.00%
3,670
4,440
4,506
2,253
8,810
4,304
95.52%
175,510 181,929 187,131 134,696 247,460 60,329 32.24%
0
44
200
0
200
0
0.00%
0
0
4,500
2,250
4,680
180
4.00%
32,417
32,621
35,000
23,050
35,000
0
0.00%
68
272
0
284
0
0
N/A
0
23
1,000
500
1,150
150
15.00%
336
1,364
200
937
200
0
0.00%
699
461
1,000
33
1,000
0
0.00%
15,283
18,775
35,000
18,679
25,000
(10,000)
-28.57%
2,049
808
2,500
1,350
2,500
0
0.00%
0
173
2,300
0
0
(2,300)
-100.00%
688
1,574
0
23
0
0
N/A
7,030
1,733
7,000
3,500
6,080
(920)
-13.14%
4,080
2,442
4,000
36
4,000
0
0.00%
61,534
33,332
51,000
26,303
51,000
0
0.00%
6,682
4,272
5,000
2,482
0
(5,000)
-100.00%
1
Total Supplies & Maintenance 130,866 97,893 148,700 79,427 130,8102019 frit?FP&Q)BudgetU.QWk nent 2
Professional Services
301 Auditing and Acct'g Services
304 Engineering -Consulting
307 Legal -Consulting
312 Bank Fees
313 IT Services
314 Fleet Services
319 Professional Services
Total Professional Services
Insurances
361 General Liability Ins
362 Umbrella Liability Ins
366 Property Insurance
367 Equipment Floaters Ins
368 Automotive Insurance
City of Orono 2019 Enterprise Budget - Attachment 2
2019 Line Item Budget
Water cont.
49400
2019 Dollar %
2016 2017 2018 Y -T -D Mgr Increase Increase
Actual Actual Budget Jul 31, 2018 Recommd Decrease Decrease
5,775
4,500
5,000
4,000
5,000
0
0.00%
22,801
12,444
15,000
5,872
15,000
0
0.00%
2,891
2,430
2,000
3,105
3,000
1,000
50.00%
2,473
2,114
2,400
2,555
2,400
0
0.00%
0
0
0
0
11,300
11,300
N/A
0
0
0
0
0
0
N/A
0
2,544
500
0
0
(500)
-100.00%
33,939
24,032
24,900
15,532
36,700
11,800
47.39%
4,000
4,000
4,000
2,000
3,000
(1,000)
-25.00%
1,800
1,800
1,800
900
0
(1,800)
-100.00%
3,800
3,800
3,800
1,900
3,440
(360)
-9.47%
380
380
380
190
330
(50)
-13.16%
300
300
300
150
300
0
0.00%
Total Insurances 10,280 10,280 10,280 5,140 7,070 (3,210) -31.23%
3
Other Expenses
321 Telephone
322 Postage
340 General Advertising
352 Printing & Publishing
381 Gas & Electric
382 Water Utilities
387 Intergovernmental Services
409 Depreciation & Amortization
415 Other Equipment Rentals
433 Memberships
437 Training & Development
438 Administrative Charge
441 Licenses & Taxes
489 Other Miscellaneous Charges
Total Other Expenses
City of Orono 2019 Enterprise Budget - Attachment 2
2019 Line Item Budget
Water cont.
49400
2019 Dollar %
2016 2017 2018 Y -T -D Mgr Increase Increase
Actual Actual Budget Jul 31, 2018 Recommd Decrease Decrease
2,046
2,398
2,500
1,957
2,500
0
0.00%
358
729
350
593
1,050
700
200.00%
0
0
0
0
0
0
N/A
0
143
1,000
468
1,000
0
0.00%
60,251
74,461
73,000
38,374
73,000
0
0.00%
1,393
880
1,100
320
1,100
0
0.00%
25,171
40,618
30,000
12,185
30,000
0
0.00%
133,177
178,222
130,000
0
207,400
77,400
59.54%
0
0
0
0
0
0
N/A
596
657
650
452
650
0
0.00%
2,878
3,442
3,500
3,701
3,500
0
0.00%
16,000
16,000
16,000
8,000
102,660
86,660
541.63%
3,011
2,644
3,500
514
3,500
0
0.00%
5,275
3,330
4,000
1,357
4,000
0
0.00%
250,157 323,522 265,600 67,920 430,360 164,760 62.03%
Total Operating Expenses 600,752 637,655 636,611 302,715 852,400 215,789 33.90%
Non -Operating Expenses
612 Other Long -Term Oblig Interest
(1,486)
0
0
0 0
0 N/A
613 Other Interest Expense
0
0
0
0 0
0 N/A
720 Operating Transfers
55,000
55,000
55,000
0 55,000
0 0.00%
Total Non -Operating Expenses
53,514
55,000
55,000
0 55,000
0 0.00%
Total Water Fund 654,266 692,655 691,611 302,715 907,400 215,789 31.20%
4
Personal Services
101 Full -Time Employees Regular
102 Full -Time Employees Overtime
103 Part -Time Employees
104 Temporary Employees Regular
121 PERA
122 FICA
135 City Benefit Contribution
143 OPEB Expense
151 Worker's Comp Insurance Prem
Total Personal Services
Supplies & Maintenance
201 Office supplies
212 Motor Fuels & Lubricants
221 Equipment Parts & Accessories
222 Vehicle Equipment & Parts
223 Bldg/Grounds Maint. Supplies
226 Clothing & personal equipment
227 Utility System Maint. Supplies
240 Small Tools and Minor Equip
401 Repairs/Maint-Office Equip
402 Repairs/Maint-Auto Equip
403 Repairs/Maint-Misc. Equip
404 Repairs/Maint-Bldgs/Grounds
406 Repairs/Maint-Swr lines/lifts
443 Repairs/Maint-I&I Reduction
Total Supplies & Maintenance
City of Orono
2019 Line Item Budget
Sewer
49450
2016 2017 2018 Y -T -D
Actual Actual Budget Jul 31, 2018
2019 Enterprise Budget - Attachment 2
2019
Dollar
%
Mgr
Increase
Increase
Recommd
Decrease
Decrease
190,246
190,299
194,217
93,574
158,250
(35,967)
-18.52%
18,766
19,618
12,000
3,707
12,000
0
0.00%
9,749
12,183
11,977
8,570
15,510
3,533
29.50%
0
0
10,000
6,948
15,730
5,730
57.30%
16,018
16,657
16,365
9,555
13,940
(2,425)
-14.82%
16,053
16,661
17,457
10,794
15,420
(2,037)
-11.67%
34,873
37,554
37,484
19,870
30,690
(6,794)
-18.13%
0
0
2,200
0
2,200
0
0.00%
12,210
16,190
16,498
8,249
12,750
(3,748)
-22.72%
297,915 309,163 318,198 161,267 276,490 (41,708) -13.11%
387
98
400
0
400
0
0.00%
0
0
9,000
4,500
8,840
(160)
-1.78%
1,946
410
1,500
1,138
1,530
30
2.00%
328
0
2,500
3,813
2,300
(200)
-8.00%
424
3,295
0
1,127
1,000
1,000
N/A
867
2,596
1,000
34
1,000
0
0.00%
1,457
7,550
9,000
2,168
9,000
0
0.00%
2,024
1,194
2,500
1,350
2,500
0
0.00%
2,392
1,342
3,050
437
0
(3,050)
-100.00%
5,356
7,082
3,000
1,669
1,440
(1,560)
-52.00%
5,119
2,028
5,000
2,522
960
(4,040)
-80.80%
0
36
1,500
0
1,500
0
0.00%
151,267
117,867
89,720
44,322
147,000
57,280
63.84%
17,616
33,425
25,000
0
25,000
0
0.00%
189,183 176,923 153,170 63,079 202,470 49,300 32.19%
Professional Services
301 Auditing and Acct'g Services
304 Engineering -Consulting
307 Legal -Consulting
312 Bank Fees
313 IT Services
314 Fleet Services
319 Professional Services
Total Professional Services
Insurances
361 General Liability Ins
362 Umbrella Liability Ins
366 Property Insurance
367 Equipment Floaters Ins
368 Automotive Insurance
Total Insurances
City of Orono
2019 Line Item Budget
Sewer cont.
49450
2016 2017 2018
Actual Actual Budget
2019 Enterprise Budget - Attachment 2
2019
Dollar
%
Y -T -D Mgr
Increase
Increase
Jul 31, 2018 Recommd
Decrease
Decrease
7,000
6,500
6,500
5,000
6,500
0
0.00%
17,498
11,237
15,000
3,351
15,000
0
0.00%
3,689
0
1,000
222
1,000
0
0.00%
3,308
4,252
3,000
1,313
3,000
0
0.00%
0
0
0
0
17,250
17,250
N/A
0
0
0
0
0
0
N/A
0
288
0
0
0
0
N/A
31,494 22,276 25,500 9,886 42,750 17,250 67.65%
8,000
8,000
8,000
4,000
9,000
1,000
12.50%
3,600
3,600
3,600
1,800
0
(3,600)
-100.00%
3,200
3,200
3,200
1,600
2,550
(650)
-20.31%
1,230
1,230
1,230
615
330
(900)
-73.17%
2,900
2,900
2,900
1,450
850
(2,050)
-70.69%
18,930
18,930
18,930
9,465
12,730
(6,200)
-32.75%
6
Other Expenses
321 Telephone
322 Postage
331 Travel Expenses
340 General Advertising
352 Printing & Publishing
381 Gas & Electric
382 Water Utilities
383 MCES-Sewer
387 Intergovernmental Services
409 Depreciation & Amortization
415 Other Equipment Rentals
416 Software Licensing
433 Memberships
437 Training & Development
438 Administrative Charge
439 Meeting Expenses
440 Special Equipment Replacement
441 Licenses & Taxes
489 Other Miscellaneous Charges
City of Orono 2019 Enterprise Budget - Attachment 2
2019 Line Item Budget
Sewer cont.
49450
Total Other Expenses 823,599 885,538 894,442 392,316 1,089,475 195,033 21.80%
Total Operating Expenses 1,361,122 1,412,830 1,410,240 636,014 1,623,915 213,675 15.15%
7
2019
Dollar
%
2016
2017
2018
Y -T -D
Mgr
Increase
Increase
Actual
Actual
Budget
Jul 31, 2018
Recommd
Decrease
Decrease
2,953
4,110
5,000
2,118
5,000
0
0.00%
1,787
1,946
1,600
922
4,800
3,200
200.00%
0
0
100
0
100
0
0.00%
0
0
300
0
0
(300)
-100.00%
0
885
0
0
300
300
N/A
28,320
22,945
35,000
11,818
35,000
0
0.00%
0
0
0
0
0
0
N/A
395,680
431,942
431,940
315,478
555,365
123,425
28.57%
36,005
70,594
45,000
25,536
45,000
0
0.00%
311,135
308,847
320,000
0
330,000
10,000
3.13%
347
0
2,500
0
1,000
(1,500)
-60.00%
7,198
4,757
10,752
2,944
0
(10,752)
-100.00%
155
63
1,250
0
1,250
0
0.00%
4,679
1,815
4,500
3,898
4,500
0
0.00%
32,000
32,000
32,000
16,000
102,660
70,660
220.81%
0
0
0
0
0
0
N/A
0
0
0
0
0
0
N/A
417
374
1,000
32
1,000
0
0.00%
2,923
5,261
3,500
13,568
3,500
0
0.00%
Total Other Expenses 823,599 885,538 894,442 392,316 1,089,475 195,033 21.80%
Total Operating Expenses 1,361,122 1,412,830 1,410,240 636,014 1,623,915 213,675 15.15%
7
City of Orono 2019 Enterprise Budget - Attachment 2
2019 Line Item Budget
Sewer cont.
49450
2019 Dollar %
2016 2017 2018 Y -T -D Mgr Increase Increase
Actual Actual Budget Jul 31, 2018 Recommd Decrease Decrease
Non -Operating Expenses
613 Other Interest Expense
0
0
0
720 Operating Transfers
100,000
100,000
110,000
Total Non -Operating Expenses
100,000
100,000
110,000
Total Sewer Fund
1,461,122
1,512,830
1,520,240
0 0 0 N/A
0 110,000 0 0.00%
0 110,000
636,014 1,733,915
0 0.00%
213,675 14.06%
8
City of Orono 2019 Enterprise Budget - Attachment 2
2019 Line Item Budget
Recycling
49500
2019 Dollar %
2016 2017 2018 Y -T -D Mgr Increase Increase
Actual Actual Budget Jul 31, 2018 Recommd Decrease Decrease
Personal Services
101 Full -Time Employees Regular
3,488
5,900
6,030
3,015
6,380
350
5.80%
102 Full -Time Employees Overtime
0
0
0
0
0
0
N/A
103 Part -Time Employees
0
0
0
0
0
0
N/A
104 Temporary Employees Regular
0
0
0
0
0
0
N/A
121 PERA
252
442
450
225
480
30
6.67%
122 FICA
267
366
460
230
490
30
6.52%
135 City Benefit Contribution
0
0
0
0
0
0
N/A
151 Worker's Comp Insurance Prem
30
40
40
20
50
10
25.00%
Total Personal Services
4,037
6,748
6,980
3,490
7,400
420
6.02%
Supplies & Maintenance
221 Equipment Parts & Accessories
1,695
0
0
0
0
0
N/A
401 Repairs/Maint-Office Equip
0
0
1,500
0
0
(1,500)
-100.00%
Total Supplies & Maintenance 0 0 1,500 0 0 (1,500) -100.00%
Professional Services
316 Contract Recycling Pickup
319 Professional Services
Total Professional Services
101,942 104,205 110,500 63,545 117,880 7,380 6.68%
1,301 0 0 0 0 0 N/A
103,243 104,205 110,500 63,545 117,880 7,380 6.68%
7
City of Orono 2019 Enterprise Budget - Attachment 2
2019 Line Item Budget
Recycling cont.
49500
2019 Dollar %
2016 2017 2018 Y -T -D Mgr Increase Increase
Actual Actual Budget Jul 31, 2018 Recommd Decrease Decrease
Other Expenses
352 Printing & Publishing
483
0
0
0
0
0
N/A
361 General Liability Ins
0
0
500
0
500
0
0.00%
416 Software Licensing
1,548
879
0
1,849
1,750
1,750
N/A
438 Administrative Charge
2,500
625
2,500
1,250
2,500
0
0.00%
442 Spring,Fall,X-mas Cleanup
4,096
0
3,670
5,347
4,000
330
8.99%
444 Organics Recycling
0
0
0
0
500
500
N/A
Total Other Expenses
8,628
1,504
6,670
8,446
9,250
2,580
38.68%
Total Recycling Fund
115,907
112,458
125,650
75,481
134,530
8,880
7.07%
10
Personal Services
101 Full -Time Employees Regular
102 Full -Time Employees Overtime
104 Temporary Employees Regular
121 PERA
122 FICA
135 City Benefit Contribution
143 OPEB Expense
151 Worker's Comp Insurance Prem
Total Personal Services 44,900 42,134 48,662 27,180 128,030 79,368 163.10%
Supplies & Maintenance
201 Office supplies
221 Equipment Parts & Accessories
227 Utility System Maint. Supplies
240 Small Tools and Minor Equip
401 Repairs/Maint-Office Equip
402 Repairs/Maint-Auto Equip
404 Repairs/Maint-Bldgs/Grounds
406 Repairs/Maint-Swr lines/lifts
Total Supplies & Maintenance
0
City of Orono
0
0
2019 Enterprise Budget - Attachment 2
0
2019 Line Item Budget
0
0
1,300
650
1,530
Storm Water
17.69%
10,020
1,249
9,500
51
49910
0
0.00%
4,278
695
1,000
1,301
1,000
2019
Dollar
%
2016
2017 2018
Y -T -D
Mgr
Increase
Increase
Actual
Actual Budget
Jul 31, 2018
Recommd
Decrease
Decrease
35,017
32,836 36,309
20,952
78,640
42,331
116.59%
1,115
96 0
299
0
0
N/A
0
0 0
0
15,000
15,000
N/A
2,534
2,470 2,723
1,594
5,900
3,177
116.67%
2,611
2,581 2,798
1,864
7,170
4,372
156.25%
2,752
3,101 5,245
1,943
14,190
8,945
170.54%
0
0 530
0
530
0
0.00%
870
1,050 1,057
529
6,600
5,543
524.41%
Total Personal Services 44,900 42,134 48,662 27,180 128,030 79,368 163.10%
Supplies & Maintenance
201 Office supplies
221 Equipment Parts & Accessories
227 Utility System Maint. Supplies
240 Small Tools and Minor Equip
401 Repairs/Maint-Office Equip
402 Repairs/Maint-Auto Equip
404 Repairs/Maint-Bldgs/Grounds
406 Repairs/Maint-Swr lines/lifts
Total Supplies & Maintenance
0
0
0
0
0
0
N/A
0
0
1,300
650
1,530
230
17.69%
10,020
1,249
9,500
51
9,500
0
0.00%
4,278
695
1,000
1,301
1,000
0
0.00%
0
0
1,500
0
1,500
0
0.00%
875
4,033
4,000
2,253
4,000
0
0.00%
27,682
(129)
0
242
0
0
N/A
1,821
(1,371)
14,000
0
14,000
0
0.00%
44,676
4,477
31,300
4,496
31,530
230
0.73%
EF
City of Orono 2019 Enterprise Budget - Attachment 2
2019 Line Item Budget
Storm Water cont.
49910
2019 Dollar %
2016 2017 2018 Y -T -D Mgr Increase Increase
Actual Actual Budget Jul 31, 2018 Recommd Decrease Decrease
Professional Services
3,500
0
0.00%
301 Auditing and Acct'g Services
3,500
3,500
3,500
304 Engineering -Consulting
13,470
31,990
15,000
307 Legal -Consulting
0
0
1,000
313 IT Services
0
0
0
314 Fleet Services
0
0
0
319 Professional Services
0
0
0
0
0
0
Total Professional Services
16,970
35,490
19,500
Insurances
361 General Liability Ins
362 Umbrella Liability Ins
367 Equipment Floaters Ins
368 Automotive Insurance
370 Insurance Agent of Record
379 Insurance Deductibles
Total Insurances
2,000
3,500
0
0.00%
7,014
15,000
0
0.00%
222
1,000
0
0.00%
0
2,000
2,000
N/A
0
0
0
N/A
0
0
0
N/A
9,236 21,500 2,000 10.26%
500
500
500
250
2,950
2,450
490.00%
220
220
220
110
0
(220)
-100.00%
1,250
1,250
1,250
625
280
(970)
-77.60%
0
0
0
0
150
150
N/A
0
0
0
0
0
0
N/A
0
0
0
0
0
0
N/A
1,970
1,970
1,970
985
3,380
1,410
71.57%
12
Other Expenses
322 Postage
331 Travel Expenses
352 Printing & Publishing
409 Depreciation & Amortization
415 Other Equipment Rentals
416 Software Licensing
433 Memberships
437 Training & Development
438 Administrative Charge
441 Licenses & Taxes
489 Other Miscellaneous Charges
Total Other Expenses
Total Operating Expenses
City of Orono 2019 Enterprise Budget - Attachment 2
2019 Line Item Budget
Storm Water cont.
49910
2019 Dollar %
2016 2017 2018 Y -T -D Mgr Increase Increase
Actual Actual Budget Jul 31, 2018 Recommd Decrease Decrease
1,532
1,946
1,700
922
5,100
3,400
200.00%
0
0
0
0
0
0
N/A
0
0
0
24
0
0
N/A
35,817
37,645
38,000
0
53,500
15,500
40.79%
0
0
0
0
0
0
N/A
6,518
3,352
4,000
1,558
2,000
(2,000)
-50.00%
0
0
0
1,020
58,780
58,780
N/A
310
321
0
0
500
500
N/A
16,000
16,000
16,000
8,000
51,330
35,330
220.81%
0
0
0
0
0
0
N/A
0
46,365
0
0
1,000
1,000
N/A
60,177
105,629
59,700
11,524
172,210
112,510
188.46%
168,694
189,699
161,132
53,422
356,650
195,518
121.34%
Non -Operating Expenses
513 Easements & Rights of Way
0
272
0
0
0
0
N/A
592 Storm Sewer Utility Const
0
0
0
0
0
0
N/A
Total Non -Operating Expenses
0
272
0
0
0
0
N/A
Total Stormwater Fund
168,694
189,971
161,132
53,422
356,650
195,518
121.34%
13
City of Orono 2019 Enterprise Budget - Attachment 2
2019 Line Item Budget
Cable Franchise
49840
14
2019
Dollar
%
2016
2017
2018
Y -T -D
Mgr
Increase
Increase
Actual
Actual
Budget
Jul 31, 2018
Recommd
Decrease
Decrease
Personal Services
101 Full -Time Employees Regular
7,686
10,267
12,470
6,235
13,990
1,520
12.19%
102 Full -Time Employees Overtime
0
0
0
0
0
0
N/A
121 PERA
555
880
935
468
1,050
115
12.30%
122 FICA
S88
730
954
477
1,080
126
13.21%
135 City Benefit Contribution
0
0
0
0
2,200
2,200
N/A
151 Worker's Comp Insurance Prem
70
80
86
43
110
24
27.91%
Total Personal Services
8,899
11,957
14,445
7,223
18,430
2,465
17.06%
Professional Services
301 Auditing and Acct'g Services
0
2,000
2,000
2,000
2,000
0
0.00%
307 Legal -Consulting
0
0
0
0
0
0
N/A
313 IT Services
0
0
0
0
7,500
7,500
N/A
319 Professional Services
1,465
4,335
0
1,675
0
0
N/A
Total Professional Services
1,465
6,335
2,000
3,675
9,500
7,500
375.00%
Other Expenses
329 Internet/Other Communications
13,728
13,175
25,000
10,617
30,000
5,000
20.00%
401 Repairs/Maint-Office Equip
1,974
985
2,000
330
2,000
0
0.00%
409 Depreciation & Amortization
4,314
4,312
4,600
0
4,600
0
0.00%
438 Administrative Charge
2,500
2,500
2,500
1,250
2,500
0
0.00%
Total Other Expenses
22,516
20,972
34,100
12,197
39,100
5,000
14.66%
Total Operating Expenses
32,880
39,264
50,545
23,094
67,030
5,000
0
Total Cable TV Fund
32,880
39,264
50,545
23,094
67,030
14,965
29.61%
14
2019 Enterprise Budgets - Attachment 3
As of: 19 Jul 18
Water CIP
5-YearCIP
Planning Period
Table A-6
Project
Dep. Life
2018
2019
2020
2021
2022
2023
2024
2025
2026
2027
2028
2029
2030
2031
2032
2033
2034
2035
2036
2037
2038
North Wellhouse Scada Upgrade
10
$61,200
Navarre Plant Control Upgrade
10
$55,200
North Water Tower Maintenance
5
$62,500
$62,500
$70,000
North Water Plant Painting
15
$21,000
South Water Plant Painting
15
$78,000
Navarre Plant Salt Brine Tank Rehab.
50
$400,000
North Distribution Extension (West of OCB)
$70
$120,000
Well #1 Inspection and Maintenance (every 10 yrs)
na
$20,000
Well #2 Inspection and Maintenance(every 10 yrs)
na
$20,000
Well #3 Inspection & Maintenance (every 10 yrs)
na
$20,000
$20,000
Well #4 Inspection & Maintenance (every 10 yrs)
na
$20,000
Well #1 Rehabilitation (every 20 yrs)
20
$150,000
Well #2 Rehabilitation (every 20 yrs)
20
$150,000
Well #3 Rehabilitation (every 20 yrs)
20
$150,000
Well # 4 Rehabilitation (every 20 yrs)
20
$150,000
Well #3 Screen
30
$92,000
South Tower Repaint and Rehabilitation
15
$350,000
$60,000
$65,000
Watermain replacement Old Crystal Bay Road W/Road
75
$210,000
West Lafeyette Main Replacement (w/Road)
75
$75,000
Water Main Replacement (CSAH15/19) W/Road
75
$ 169,855
Watermain replacement CSAH 19 S of CSAH 15
75
$181,000
Watermain replacement Casco Circle W/Road
75
$357,700
Watermain replacement E.Navarre Streets W/Road
75
$327,880
Watermain replacement Togo Road W/Road
75
$200,060
Watermain Loop Concordia
75
$230,000
Water Valve Replacemetns (4 /Year)
50
$24,000
$24,600
$25,215
$25,845
$26,492
$27,154
$27,833
$28,528
$29,242
$29,973
$30,722
$31,490
$32,277
$33,084
$33,911
$34,759
$35,628 1
536,519
$37,432
$38,368
Watermain Replacement
75 1
1 $250,000
$255,000
$260,100
$265,302
$270,608
$276,020
$281,541
$287,171
$292,915
$298,773
$304,749
$310,844
$317,060
$323,402
$329,870
Water Meter Replacement (every 15yr)
15
$90,000
$90,000
$90,000
$90,000
$90,000
$ 90,000
Totals
$428,700
$474,855
$800,180
$821,415
$345,845
$379,052
$277,154
$302,833
$898,628
$444,544
$520,581
$306,7421
$313,031
$384,449
$325,999
$482,685
$339,508
$346,472
$373,579
$380,833
$478,237
2019 Enterprise Budgets - Attachment 3
As of: 16 JUL 18
Sanitary Sewer CIP
5-YearCIP
Planning Period
Table A-7
Project
Dep. Life
2018
2019
2020
2021
2022
2023
2024
2025
2026
2027
2028
2029
2030
2031
2032
2033
2034
2035
2036
2037
2038
Sewer Rehabilitation
50
$273,182
$281,377
$289,819
$298,513
$307,469
$316,693
$326,194
$335,979
$346,059
$356,441
$367,134
$378,148
$389,492
$401,177
$413,212
$425,609
$438,377
$451,528
$465,074
$479,026
$493,397
Annual Sewer Televising (1/S of City Each Year)
NA
$47,272
$48,690
$50,151
$51,655
$53,205
$54,801
$56,445
$58,139
$59,883
$61,679
$63,530
$65,436
$67,399
$69,421
$71,503
$73,648
$75,858
$78,133
$80,477
$82,892
$85,378
Lift Station #20 Generator
Lift Station #5 Generator
15
$75,000
Lift Station #9 Generator
15
$75,000
Lift Station #15 Generator
15
$75,000
Lift Station #1 Generator
15
$75,000
Lift Station #3 Generator
15
$75,000
Lift Station #13 Generator
15
1 $75,000
Lift Station #16 Generator
15
$75,000
Lift Station #25 Generator
15
$75,000
Lift Station #11 Generator
15
$75,000
Lift Station #17 Generator
15
$75,000
Lift Station #19 Generator
15
1
$75,000
Lift Station #23 Generator
15
$75,000
Lift Station #27 Generator
15
$75,000
Lift Station #29 Generator
15
$75,000
Grinder Station #2 Rehab
30
$56,000
Lift Station #9 Rehab
25
$56,000
Lift Station #5 Rehab
25
$58,000
Lift Station #11 Rehab
25
$58,000
Lift Station #3 Rehab
25
$60,000
Lift Station #4 Rehab
25
$60,000
Lift Station #16 Rehab
25
1
$62,000
Lift Station #25 Rehab
25
$62,000
Lift Station #28 Rehab
25
$64,000
Lift Station #2 Rehab
25
$64,000
Lift Station #6 Rehab
25
$65,600
Grinder Station #9 Rehab
30
1
$65,600
Lift Station #30 Rehab
25
$67,240
Grinder Station #8 Rehab
30
$67,240
Lift Station #13 Rehab
25
$68,921
Lift Station #10 Rehab
25
$68,921
Lift Station Rehab (2 per year)
25
1
1
$142,127
1 $146,391
$150,783
$155,306
1 $159,965
$164,764
$169,707
$174,798
$180,042
$185,443
$191,007
$196,737
$202,639
Northern Utilities Expansion (W/CSAH 113 PH3)
70
$436,000
Lift Station Monitoring (Mission)
20
$26,000
$26,000
$26,000
$26,000
Forest Arms Main Rehab w/ rd
50
$18,000
Windjammer Main Rehab with road
50
$24,750
West Laffayette Main Rehab with Road construction
50
$14,600
Old Crystal Bay Road N Main Rehab
50
$2,115
ForceMain replacement with CSAH 19/15 Porject
70
$180,000
Forcemain Replacement Tonkawa PH2
70
$225,000
Forcemain Replacement Tonkawa PH3
70
$215,250
Forcemain Replacement Tonkawa PH4
70
1
$139,950
Sewer Main Replacements
70
1
$ 130,000 $
133,250
$ 136,581
$ 139,996
$ 143,496
$ 147,083
$ 150,760
$ 154,529
$ 158,392
$ 162,352
$ 166,411
$ 170,571
$ 174,836
$ 179,206
$ 183,687
Totals
$625,169
$820,068
1 $1,096,720
1 $875,169
$853,924
$792,644
$797,119
$665,210
$684,650
1 $704,506
$724,942
$745,972
1 $767,616
$789,891
$812,815
$836,407
$860,688
$885,676
$911,394
$937,861
$965,101
2019 Enterprise Budgets - Attachment 3
As of: 17 Jul 18
Storm Sewer CIP
5-YearCIP
Planning Period
Table A-8
Project Dep. Life Dep Comment 2018
2019
2020
2021
2022
2023
2024
2025
2026
2027
2028
2029
2030
2031
2032
2033
2034
2035
2036
2037
2038
Storm Watershed Delineation and Pond Assessments
100
Based on Concrete Culvert Lif
$ 10,000
$ 10,000
$ 10,000
Forest Arms Lane (w/road. reconstruct)
100
Based on Concrete Culvert Life
$ 69,324
Windjammer Stormwater (w/road reconstruct)
100
Based on Concrete Culvert Life
$ 10,775
West Lafayette Stormwater (w/road reconstruct)
100
Based on Concrete Culvert Lif
$ 32,820
Lyric Avenue (w/ Road reconstruct)
100
Based on Concrete Culvert Lif
$ 5,000
Wildhurst Trail (w/ Road reconstruct)
100
Based on Concrete Culvert Lif
$ 275,673
Minnetonka Highlands (w/Road reconstruct)
100
Based on Concrete Culvert Lif
$ 11,374
Old Crystal Bay (6-112) (W/Rd Reconstruction)
100
Based on Concrete Culvert Lif
$ 506,059
Vine place (w/ Road reconstruct)
100
Based on Concrete Culvert Lif
$ 1,000
East Long Lake S (w/ Road reconstruct)
100
Based on Concrete Culvert Life
$ 63,515
Windjammer (North Arm to End) (w/ Road reconstruct)
100
Based on Concrete Culvert Life
$ 71,834
Smith and Lyman Avenue (w/ Road reconstruct)
100
Based on Concrete Culvert Life
$ 66,321
Tonkaview Lane (w/ Road reconstruct)
100
Based on Concrete Culvert Life
$ 87,531
Chevy Chase Drive (w/ Road reconstruct) (HA -1)
100
Based on Concrete Culvert Life
$ 146,330
Casco Circle (w/ M&O)
100
Based on Concrete Culvert Life
$ 122,065
East Navarre Roads (w/ M&C)
100
Based on Concrete Culvert Life
$ 30,572
Kelley Parkway - OCB Rd to Stone Bay (w/ Road M&O)
100
Based on Concrete Culvert Life
$ 5,450
Dickenson Street (w/ Road reconstruct)
100
Based on Concrete Culvert Life
$ 8,557
Glendale Drive (w/ Road reconstruct)
100
Based on Concrete Culvert Life
$ 5,047
Orchard Park Road (w/ Road reconstruct)
100
Based on Concrete Culvert Life
$ 21,320
Rest Point Lane (w/ Road reconstruct)
100
Based on Concrete Culvert Life
$ 4,279
Park Lane (w/ Road reconstruct)
100
Based on Concrete Culvert Life
$ 8,777
North Arm Drive (w/ Road reconstruct)
100
Based on Concrete Culvert Life
$ 44,962
Willow Dr (Fox -Brown) (w/ Road reconstruct)
100
Based on Concrete Culvert Life
$ 36,448
Street Stormwater Improvements
100
Based on Concrete Culvert Life
$ 140,000
$ 143,500
$ 147,088
$ 150,765
$ 154,534
$ 158,397
$ 162,357
$ 166,416
$ 170,576
$ 174,841
$ 179,212
$ 183,692
$ 188,284
$ 192,992
$ 197,816
$ 202,762
Long Lake Ravine Stabilization (SWMP 7)
25
Based on Gabion life
$ 100,000
East Long Lake Road Shoreline Restoration
30
Based on Rip Rap life
$ 102,500
Casco Point Park Outlet (SWMP 0-1)
100
Based on Concrete Culvert Life
$ 58,000
Casco cove Outlet (SWMP 0-2)
100
Based on Concrete Culvert Life
$ 80,000
Casco Point Park Bioretention Basin (SWMP CB -1)
25
Based on Bioretention Basin Life
$ 55,000
South Casco Point Road Sump (SWMP CB -2)
100
Based on Concrete Sump Life
$ 36,000
Casco cove Bioretatnion Basin (CB -3)
25
Based on Bio retention Life
$ 57,000
East Long Lake Road N Improvements (SWMP LL -1)
100
Based on Concrete Culvert Life
$ 82,000
Cherry Place Ravine Improvement (SWMP NA -1)
30
Based on Rip Rap life
$ 23,000
OCB Pipe Upsizing (Countryside south)
100
Based on Concrete Culvert Life
$ 88,500
Kelly Avenue Drainage Improvements
100
Based on Concrete Culvert Lif
$ 52,909
Surface Water Management Projects
50
Based on Pond Life
$ 160,000
$ 164,000
$ 168,100
$ 172,303
$ 176,610
$ 181,025
$ 185,551
$ 190,190
$ 194,944
$ 199,818
$ 204,814
$ 209,934
$ 215,182
$ 220,562
$ 226,076
$ 231,728
$ 237,521
Storm Sewer Improvements/ Replacements
100
Based on Concrete Culvert Lif
$ 157,850
$ 200,000
$ 205,000
$ 210,125
$ 215,378
$ 220,763
$ 226,282
$ 231,939
$ 237,737
$ 243,681
$ 249,773
$ 256,017
$ 262,417
$ 268,978
$ 275,702
$ 282,595
$ 289,660
$ 296,901
$ 304,324
$ 311,932
$ 319,730
Pond Cleaning/Maintenance (1/year)
50
Based on Pond Life
$ 50,000
$ 51,250
$ 52,531
$ 53,845
$ 55,191
$ 56,570
$ 57,985
$ 59,434
$ 60,920
$ 62,443
$ 64,004
$ 65,604
$ 67,244
$ 68,926
$ 70,649
$ 72,415
$ 74,225
$ 76,081
TMDL Updates/ Improvements
50
Based on Pond Life
$ 50,000
$ 51,000
$ 52,275
$ 53,582
$ 54,921
$ 56,294
$ 57,702
$ 59,144
$ 60,623
$ 62,139
$ 63,692
$ 65,284
$ 66,916
$ 68,589
$ 70,304
$ 72,062
$ 73,863
$ 75,710
$ 77,603
$ 79,543
$ 81,531
Totals
1
1 $ 1,202,685
1 $ 798,200
1 $ 829,119
1 $ 518,359
1 $ 562,960
1 $ 633,588
1 $ 649,428
$ 665,664
1 $ 682,305
1 $ 699,363
1 $ 716,847
1 $ 734,765
1 $ 753,137
1 $ 771,966
$ 791,265
1 $ 811,047
1 $ 831,323
1 $ 852,106
1 $ 873,408
1 $ 895,244
1 $ 917,625
2019 Enterprise Budget - Attachment - 4
Water 5 Year Forecast
601- _
12/31/2019
Base Charge Increase 11%
Rate Increase from Prior Year 11%
Inflation - 5 Yr Forecast
2%
Tier 1 to 2 Rate Increase 26%
Inactive
Tier 2 to 3 Rate Increase 50%
Inactive
2019 (2013-2017 Avg Consumption)
2020 (2013-2017 Avg Consumption)
2021 (2013-2017 Avg Consumption)
2022 (2013-2017 Avg Consumption)
2023 (2013-2017 Avg Consumption)
Consumption
Calculated
Consumption
Calculated
Consumption
Calculated
Consumption
Calculated
Consumption
Calculated
Per Level Rate
Amount
Per Level
Rate Amount
Per level
Rate
Amount
Per Level Rate
Amount
Per Level Rate
Amount
Est. Yearly Total Consumption
78,454.80
78,454.80
78,454.80
78,454.80
78,454.80
Total Estimated Revenue
722,341.38
801,798.93
*estimated
*estimated
*estimated
*estimated
*estimated
Total Increase from prior year
- -11.00%
11%
-
-11.00% 11%
-
-11.00%
11%
- -11.00%
11%
- -11.00%
11%
Budgeted Expenses w/ Dep.
907,400.00
Budgeted expense
939,800.00
Budgeted expense
969,680.00
Budgeted expense
1,005,545.60
Budgeted expense
1,030,002.51
Less Depreciation
207,400.00
ff 700000.00
Less Dep.
225,800.00
714,000.00
Less Dep.
241,400.00
728,280.00
Less Dep.
262,700.00
742,845.60
Less Dep.
272,300.00
57,702.51
Budgeted Expenses - Cash
Gain / (Loss) - Non-cash basis
(379,230.21)
(353,531.53)
(318,922.00)
(283,204.22)
(228,203.58)
Gain / (Loss) - Cash basis
(171,830.21)
(127,731.53)
(77,522.00)
(20,504.22)
44,096.42
CIP Amount
474,855.00
800,180.00
821,415.00
345,845.00
379,052.00
2019 Enterprise Budget - Attachment - 4
Sewer 5 Year Forecast
Rate Increase 4% 2019
2020
2021
2022
2023
12/31/2019
12/31/2020
12/31/2021
12/31/2022
12/31/2023
Base Rate Amount Base
Rate Amount Base Rate
Amount Base Rate
Amount Base Rate
Amount
Estimated Revenue
1,528,715.36
1,589,863.97
1,653,458.53
1,719,596.87
1,788,380.75
Inflation:
2.13%
2.04%
2.07%
2.12%
Budgeted Expenditure w/ Dep.
1,403,915.00
1,450,789.39
1,501,163.89
1,544,330.59
1,582,547.99
Budgeted Depreciation
330,000.00
354,000.00
382,000.00
402,000.00
416,000.00
Budgeted Expenditure- w/o Dep.
1,073,915.00
1,096,789.39
1,119,163.89
1,142,330.59
1,166,547.99
Gain/(Loss)-Non-cash basis
124,800.36
139,074.58
152,294.64
175,266.29
205,832.75
Gainf(Loss) - Cash basis
454,90D.36
493;074.58
534,294.54
577,265.29
621+833.35
CIP Amount
820,068.00
1,096,720.00
650,169.00
638,674.00
652,694.00
2019 Enterprise Budget - Attachment - 4
Stormwater 5 Year Forecast
Rate Increase
10%
12/31/2019
12/31/2020
12/31/2021
12/31/2022
12/31/2023
Users Rate
Total
Users Rate
Total
Users Rate
Total
Users Rate
Total
Users Rate
Total
Estimated Revenue
Estimated
353,955.33
Estimated
389,350.87
Estimated
428,285.95
Estimated
471,114.55
Estimated
518,226.00
Actual Revenue
Inflation
2.13%
Inflation
2.04%
Inflation
2.07%
Inflation
2.12%
651
Expenditure
Budgeted
356,650.00
Budgeted
371,607.10
Budgeted
390,823.08
Budgeted
405,762.69
Budgeted
420,898.90
651-49910-409
Budgeted
53,500.00
Budgeted
62,000.00
Budgeted
74,900.00
Budgeted
83,300.00
Budgeted
91,600.00
303,150.00
309,607.10
315,923.08
322,462.69
329,298.90
Gain / (Loss) - Non-cash basis
Budgeted
(2,694.67)
Budgeted
17,743.77
Budgeted
37,462.87
Budgeted
65,351.86
Budgeted
97,327.11
Gain / (Loss) - Cash basis
Budgeted
50,805.33
Budgeted
79,743.77
Budgeted
112,362.87
Budgeted
148,651.86
Budgeted
188,927.11
OF Amount
709,700.00
829,119.00
606,859.00
562,960.00
633,588.00