HomeMy Public PortalAbout07.19.2016 City Council Special Meeting PacketMEDINA
SPECIAL MEETING AGENDA
MEDINA CITY COUNCIL
Tuesday, July 19, 2016
6:00 P.M.
Medina City Hall
2052 County Road 24
I. Call to Order
II. 2017 Budget — Utilities/CIP
III. Sioux Drive Project Discussion
IV. Adjourn
Posted 7/15/2016
MEMORANDUM
TO: Medina City Council
FROM: Scott Johnson, City Administrator
DATE OF REPORT: July 8, 2016
DATE OF MEETING: July 19, 2016
SUBJECT: July 19, 2016 Work Session — 6:00 PM
Work Session 6:00 PM
City Capital Improvement Plan/Utilities Discussion
Staff will present information on the proposed 2017 Capital Improvement Plan (CIP). We will
also discuss 2017 rates for water, sewer and stormwater (proposed 3% increase for all three
funds). Staff included a memo from 2012 to provide background on the utility increases. Also,
changes were discussed and made in 2012/13 by the City Council to the water and sewer fees to
make sure the water fund did not run a deficit as predicted in the 2012 memo. Attached is the
information on the CIP and rates for 2017.
Sioux Drive Discussion
Jim Stremel will be on hand to discuss the corrections that need to be made on the Sioux Drive
project. Jim will also be providing an updated cost estimate for the repairs necessary, and how
the costs will be quantified, and allocated.
2017 - 2021 Capital Improvement Plan
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
2017 CIP: DEPARTMENT
2017
2018
2019
2020
2021
Project Cost
City Proposed
Portion
Project Cost
City Proposed
Portion
Project Cost
City Proposed
Portion
Project Cost
City Proposed
Portion
Project Cost
City Proposed
Portion
Roads
Potential Revenue Source
Tamarack North of Medina to Blackfoot
Overlay
$ 54,000
$ 43,200
Reserves/Bonds/Assessments
Tamarack - Medina to 24 - Overlay
$ 49,985
$ 39,988
Reserves/Bonds/Assessments
Tamarack City Limits to CSAH 24 Overlay
$ 77,675
$ 62,140
Reserves/Bonds/Assessments
Clydesdale trail overlay 116 to 600
$ 80,000
$ 40,000
Reserves/Bonds/Assessments
600 Clydesdale - Parking Lot
$ 20,000
$ 20,000
$ 20,000
$ 20,000
$ 20,000
$ 20,000
Revolving Cap. Impr. Fund
Oakview Road - Overlay
$ 43,000
$ 21,500
Reserves/Bonds/Assessments
Deer Hill Road East - Overlay
$ 27,040
$ 13,520
Reserves/Bonds/Assessments
Dusty Trail - Overlay
$ 3,900
$ 1,950
Reserves/Bonds/Assessments
Morgan Rd.
Reserves/Bonds/Assessments
Independence Beach Overlay
Reserves/Bonds/Assessments
Tower Recon - Tower Drive Schedule A
& K
MSA/Bonds/Assessments
Tower Recon - Hamel Road West
Schedule B & L
MSA/Bonds/Assessments
Tower Recon - Hamel Road East Schedule
C & M
MSA/Bonds/Assessments
Tower Recon - Kilkenny Lane Schedule D
MSA/Bonds/Assessments
Chestnut Road - Overlay
$ 50,000
$ 25,000
Reserves/Bonds/Assessments
Hickory Drive - Reconstruct
$ 180,427
$ 90,214
Reserves/Bonds/Assessments
Comanche Trail Overlay
Reserves/Bonds/Assessments
Chippewa Road West overlay
Reserves/Bonds/Assessments
Lakeview Road overlay
Reserves/Bonds/Assessments
Willow Drive Orono to 24 Overlay
Reserves/Bonds/Assessments
Willow Drive N of Chippewa overlay
blacktop portion
$ 59,000
$ 47,000
Reserves/Bonds/Assessments
Willow Drive North to 24 - reclaim
$ 200,000
$ 160,000
Reserves/Bonds/Assessments
Wichita Trail overlay
40,000
Reserves/Bonds/Assessments
Tower Drive West of Pinto Overlay
$ 30,000
$ 15,000
Reserves/Bonds/Assessments
Cottonwood Trail Upgrade
Reserves/Bonds/Assessments
Iroquois Drive Overlay
$ 26,000
$ 13,000
Reserves/Bonds/Assessments
Willowbrook RD
Split/Orono Road Bond
Maplewood Drive Overlay
$ 29,328
$ 14,664
Reserves/Bonds/Assessments
Bobolink Road Overlay
$ 86,326
$ 43,163
Reserves/Bonds/Assessments
Morningside Road Overlay
$ 100,654
$ 50,327
Reserves/Bonds/Assessments
Elsinore Circle N of Morningside Rd
Overlay
$ 18,789
$ 9,395
Reserves/Bonds/Assessments
Tuckborough/Hunter farms Addition overlay
Reserves/Bonds/Assessments
Townline Road CR11 to TH 55 Overlay
Independence funds/Road
Bonds/Assessments
Sioux Drive Turn Lane
Road Bonds/MSA
Hwy 55 & CSAH101 Signal upgrade
Developer/Assessments
(reimburse City)
Hwy 55 & CR 116 Whistleless Crossing
$ 250,000
$ 125,000
Reserves/MSA
Hwy 55 & CR 116 Intersection
$ 2,773,282
$ 387,913
Roads/Ca pital/MSA
Roads Sub -total $ 3,222,282 $
Public Works
639,913 $ 741,524 $
440,762 $ 275,600 $ 202,298 $
Tandem
Equipment Bonds/Cap Equip Fund
Crack Sealer
Equipment Bonds/Cap Equip Fund
Tanker
Equipment Bonds/Cap Equip Fund
1984 Grader rehab
$ 25,000
$ 25,000
Equipment Bonds/Cap Equip Fund
Replace 2007 550
$ 60,000
$ 60,000
Equipment Bonds/Cap Equip Fund
Air Compressor (40 % Parks)
Equipment Bonds/Cap Equip Fund
Sweeper
Grant
Brush Hog (50 % Parks)
Equipment Bonds/Cap Equip Fund
Self propeled kick off broom
$ 40,000
$ 40,000
Equipment Bonds/Cap Equip Fund
Lift
Grant
Skid Steer Upgrade w/ Bucket
$ 5,000
$ 5,000
Equipment Bonds/Cap Equip Fund
Pickup Truck 3/4 Ton (50 % Parks)
Equipment Bonds/Cap Equip Fund
Tandem Trailer
Equipment Bonds/Cap Equip Fund
Single Axle Truck
$ 220,000
$ 220,000
$ 220,000
$ 220,000
Equipment Bonds/Cap Equip Fund
Loader
$ 200,000
$ 2-,0-C
$ 200,000
$ 200,000
Equipment Bonds/Cap Equip Fund
Miscellaneous
Equipment Bonds/Cap Equip Fund
Public Works Sub -total $
Police
30,000 $ 30,000 $ 100,000 $ 100,000 $ 200,000 $ 200,000 $ 220,000 $ 220,000 $
PD Squad Cars
$ 72,000
$ 72,000
$ 72,000
$ 72,000
$ 108,000
$ 108,000
Equipment Bonds/Cap Equip Fund
Traffic Squad
$ 35,000
$ 35,000
Equipment Bonds/Cap Equip Fund
PD Speed Trailers
Equipment Bonds/Cap Equip Fund
PD Squad Camera
Fed Drug Forfeiture Fund
PD Squad Portable Radios
DWI Forfeiture Fund
Portable Radios
$ 27,000
$ 27,000
$ 60,000
$ 60,000
DWI Forfeiture Fund
PD Squad Laptops/Software MDC
$ 10,000
$ 10,000
$ 40,000
$ 40,000
DWI Forfeiture Fund
1
2017 - 2021 Capital Improvement Plan
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84 Fire
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
2017 CIP: DEPARTMENT
2017
Project Cost
City Proposed
Portion
2018
Project Cost
City Proposed
Portion
2019
Project Cost
City Proposed
Portion
1
2020
Project Cost
City Proposed
Portion
2021
Project Cost
City Proposed
Portion
Potential Revenue Source
PD Card Reader System
DWI Forfeiture Fund
Electronics (New PD Facility)
DWI Forfeiture Fund
Workout Equipment
DWI Forfeiture Fund/ Excellence Award
Bicycles
l $ 2,000
$ 2,000
Equipment Bonds/Cap Equip Fund
Digital Speed Signs
Equipment Bonds/Cap Equip Fund
Lexipold Policy Software
$ 10,000
$ 10,000
Fed Drug Forfeiture Fund
Tasers
$ 9,000
$ 9,000
Equipment Bonds/Cap Equip Fund
Side Arms
$ 2,000
$ 2,000
$-7,500
$ 7 500
DWI Forfeiture Fund
223 Rifles (2)
Equipment Bonds/Cap Equip Fund
Bunkers & Helmets
$ 7,500
$ 7,500
Equipment Bonds/Cap Equip Fund
PD Server
Equipment Bonds/Cap Equip Fund
Training Room
$ 5,000
$ 5,000
Fed/Equip
Body Cameras & Server
$ 15,000
$ 15,000
Fed/Equip
Miscellaneous - Equip Fund
Equipment Bonds/Cap Equip Fund
Miscellaneous - DWI Fund
$ 4,000
$ 4,000
DWI Forfeiture Fund
Police Sub -total $ 101,500 $ 101,500 $ 122,000 $
HAMEL
122,000 $ 208,000 $ 208,000 $
SCBA Replacement
l
funded by grants/other
Mobile Radio Replacement
funded by grants/other
Lucas Tool
Equipment Bonds/Cap Equip Fund
Ongoing PPE Replacement
$ 10,000
$ -
$ 10,000
$ -
$ 10,000
$ -
$ 10,000
$ 10,000
Equipment Bonds/Cap Equip Fund
Bldg - Exhaust Removal System
l
Equipment Bonds/Cap Equip Fund
Thermal Imaging Camera
Equipment Bonds/Cap Equip Fund
Engine 11 Trash Line
Equipment Bonds/Cap Equip Fund
Hose - 1.75" & 2"
Equipment Bonds/Cap Equip Fund
Duty Officer Vehicle
l
Equipment Bonds/Cap Equip Fund
Ranger Vehicle
Equipment Bonds/Cap Equip Fund
E11 Rescue Tool Replacement
funded by grants/other
Defibrillator
funded by grants/other
Utility 11 Overhaul/retrofit
$ 21,667
$ 21,667
$ -
Equipment Bonds/Cap Equip Fund
Command Vehicle Replacement
$ 4,320
$ -
$ 4,320
$ 4,320
$ 4,320
$ 4,320
Equipment Bonds/Cap Equip Fund
Engine 11 Refurbishment
$ 20,000
$ 20,000
$ 20,000
Equipment Bonds/Cap Equip Fund
Air Lift Bag Replacement
funded by grants/other
Pumper/Tanker
$ 38,917
$ 38,917
$ 38,917
$ 38,917
$ 38,917
Equipment Bonds/Cap Equip Fund
Portable JAWS Tool
funded by grants/other
Bldg Improvement
Revolving Cap. Impr. Fund
Annual Contract
$ 73,000
$ 73,000
$ 73,000
$ 73,000
$ 73,000
Equipment Bonds/Cap Equip Fund
Hamel Fire Sub -total $
Loretto & Long Lake
74,904 $
73,000 $
74,904 $
73,000 $
73,237 $
73,000 $
73,237 $
73,000 $
73,237 $
73,000
Fire (Loretto)
$ 20,000
$ 20,000
$ 21,000
$ 21,000
$ 22,000
$ 22,000
Equipment Bonds/Cap Equip Fund
Fire (Long Lake)
$ 6,000
$ 6,000
$ 6,000
$ 6,000
$ 6,000
$ 6,000
Equipment Bonds/Cap Equip Fund
Fire Sub -total $
Emergency Management
26,000 $
26,000 $
27,000 $
27,000 $
28,000 $
28,000 $
Emergency Operation Supplies (EOC)
Revolving Cap. Impr. Fund/
County Grant
Siren Maintenance
$ 5,000
$ 5,000
$ 5,000
$ 5,000
$ 5,000
$ 5,000
$ 5,000
$ 5,000 $ 5,000
$ 5,000
Equipment Bonds/Cap Equip Fund
Civil Defense Sirens
$30-,000
$--307000
$ 30,000
$ 30,000
Revolving Cap. Impr. Fund/
County Grant
Civil Defense Sub -total $
ntstrationiData Processing
Vehicle
5,000 $
5,000 $
5,000 $
5,000 $
35,000 $
35,000 $
5,000 $
5,000 $
5,000 $
5,000
I
Administration Sub -total $
City Buildings
I
b
I
I
`Equipment Bonds/Cap Equip Fund
City Hall Repairs/Renovation
I $ 10,000
$ 10,000
$ 15,000
$ 15,000
$ 10,000
$ 10,000
Revolving Cap. Impr. Fund
Community Building Repairs
$ 15,000
$ 15,000
$ 10,000
$ 10,000
$ 15,000
$ 15,000
Revolving Cap. Impr. Fund
PW//Police/City Hall Renovations
Recharacterization from Water
Bonds
Police Server
Equipment Bonds/Cap Equip Fund
City Hall Server
Equipment Bonds/Cap Equip Fund
PW/PD Gas Pump Wiring
Revolving Cap. Impr. Fund
PW/PD Facility Roof
Revolving Cap. Impr. Fund
City Building Sub -total $
136 Water (high growth expectation)
137
138
139
140
141
142
143
144
145
146
147
25,000 $
25,000 $
25,000 $
25,000 $
25,000 $
25,000 $
Independence Beach House Controls
Water Capital Improvement
Water Treatment Plant SCADA Upgrade
Water Capital Improvement
Water Treatment Plant Expansion
$ 1,400,000
$ 1,400,000
Future
Well #8/pump/controls
Water Capital Improvement
Pumphouse # 3 reconstruct/raw waterline
Water Capital Improvement
Generator
Water Capital Improvement
Utility Truck
Water Capital Improvement
Willow Dr Water Tower Rehab
$ 400,000
$ 400,000
Water Capital Improvement
Hwy 55 & CR116 Watermain
$ 304,556
$ 304,556
Water Capital Imp/Wtr Fund
Water Tower (and land acquisition)
$ 2,600,000
$ 2,600,000
Future (2020-2023)
Tower Recon - Hamel Road West
Watermain
Water Capital Imp / Assessments
2
2017 - 2021 Capital Improvement Plan
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
2017 CIP: DEPARTMENT
2017
Project Cost
City Proposed
Portion
2018
Project Cost
City Proposed
Portion
2019
Project Cost
City Proposed
Portion
1
2020
Project Cost
City Proposed
Portion
2021
Project Cost
City Proposed
Portion
Potential Revenue Source
Tower Recon - Tower Dr WaterMain
!
I
!
Water Sub -total $ 704,556 $ 704,556 $ 4,000,000 $ 4,000,000 $
Sewer
!
!Water Capital Imp / Assessments
Generator (Foxberry or Ind Beach)
Sewer Capital Improvement
Sewer Pipe Cammera
Sewer Capital Improvement
Utility Truck
Sewer Capital Improvement
Vac & Jetter
Equip fund-Sewer/Stormwater
Extension - Others
Assessments/Sewer Capital
Hwy 55 & CR116 Sewer Lining
$ 50,000
$ 50,000
Sewer Fund (Maintenance)
Gravity Sewer Replacement - Orono
Sewer Capital Improvement-27.4
Tower Recon - Hamel Road West Sewer
Sewer Capital Imp/Assess
Tower Recon - Tower Dr Sewer
Sewer Capital Imp/Assess
Sewer Sub -total $
Storm Water
50,000 $
50,000 $
Willow Dr. Water Quality (WQ)
Improvements
Road Bonds/ Assessments/ Storm
Water Utility/ Grant
Vac & Jetter
Equip fund-Sewer/Stormwater
Tower Recon - Tower Dr Storm Pond
Storm Water Utility; Grants
PW Facility WQ Improvements
Elm Creek Watershed grants
Loretto Wetland Restoration/Creation
Storm Water Utility; Grants
Cottonwood Trail Infultration Basin
Storm Water Utility; Grants
Lake Independence WQ Improvements
Storm Water Utility; Grants
Stream/Ditch restoration in MCWD area
Storm Water Utility; Grants
Wetland restoration in MCWD area
Storm Water Utility; Grants
ISTS Repair and Replacement
Storm Water Utility
Rain Garden Implementation Program
SWU; Grants; Env. Fund
Storm Water Sub -total $
Parka
Trails
Tower Recon - Hamel Rd -Hunter to
Pinto
Developer/Park Dedication Fund
Arrowhead Trail (without Land Acq)
Park Dedication Fund/Grants
General Landscaping - all parks
$ 7,000
$ 7,000
$ 7,000
$ 7,000
$ 7,000
$ 7,000
$ 7,000
$ 7,000
$ 7,000
$ 7,000
Park Dedication Fund
Small Equip/Improvements - all parks
$ 20,000
$ 20,000
$ 20,000
$ 20,000
$ 20,000
$ 20,000
$ 20,000
$ 20,000
$ 20,000
$ 20,000
Park Dedication Fund
Large Equipment
Air Compressor (60 % PW)
Park Dedication Fund
Pickup Truck 3/4 Ton (50 % PW)
Park Dedication Fund
Brush Hog (50% PW)
Park Dedication Fund
Hamel Legion Park
Hawks Field/Parking Lot clean-up
Park Dedication Fund
Dugout Covers
Park Dedication/Grants/Donations
Snow Machine
Park Dedication/Grants/Donations
Trail Lights
Park Dedication/Grants/Donations
Holy Name Park
Picnic Shelter
Park Dedication Fund
Hunter Lions Park
Park Dedication Fund
Playground Mats
Park Dedication Fund
Fence Rail Covers
Park Dedication Fund
New Picnic Tables
Park Dedication Fund
Lakeshore Park
Add Playground Features
Park Dedication Fund
Picnic tables and concrete pads
Park Dedication Fund
Horseshoe pits
Park Dedication Fund
Stone steps to boat launch
Rainwater Nature Area
Park Dedication Fund
Bridge by New Trail
Park Dedication Fund
Maple Park
Soccer Nets
Park Dedication Fund
Pavillion
Park Dedication Fund
Medina Morningside Park
Fix Curbing around playground
Revolving Cap. Impr. Fund
Land Acquisitions / New Trails
$ 250,000
$ 250,000
$ 250,000
$ 250,000
$ 250,000
$ 250,000
$ 250,000
$ 250,000
$ 250,000
$ 250,000
Park Dedication Fund/Grants
Tomann Preserve - Park Development
$ 20,000
$ 20,000
Park Dedication Fund
The Park at Fields of Medina
Park Dedication Fund
Park Land by Medina Golf & CC
Park Dedication Fund
Park Dedication Fund
Parks Sub -total $ 297,000 $ 297,000 $ 277,000 $
277,000 $ 277,000 $ 277,000 $ 277,000 $ 277,000 $ 277,000 $ 277,000
TOTAL: $ 4,536,242 $ 1,951,969 $ 5,372,428 $ 5,069,762 $ 1,121,837 $ 1,048,298 $ 575,237 $ 575,000 $ 355,237 $ 355,000
3
CITY OF MEDINA
2017 BUDGET
WATER FUND
2014
Budget
2014
Actual
2015
Budget
2015
Actual
2016
Budget
2017 Amount Percentage
2016 Preliminary hrcrease hierease
YTD Budget (Decrease) (Decrease)
OPERATING REVENUES
Charges for Services
Charges for Services 761,190 877,292 783,986 900,278 807,466 464,891 831,651 24,185 3.0%
Special Assessments 2,500 12,527 2,500 11,940 2,500 0 2,500 0 0.0%
Meter Sales 28,560 46,465 35,700 46,283 28,140 16,478 28,140 0 0.0%
Total Charges for Services 792,250 936,284 822,186 958,501 838,106 481,368 862,291 24,185 2.9%
TOTAL OPERATING REVENUES 792,250 936,284 822,186 958,501 838,106 481,368 862,291 24,185 2.9%
OPERATING EXPENSES
Personal Services 143.999 152,254 150,392 150,986 164,427 75,440 168,795 4,368 2.7%
Supplies 82,900 103,362 99,100 92,379 83,863 23,112 87,220 3,357 4.0%
Other Services and Charges 518.900 427,984 489,675 (249,430) 504,157 82,883 168,100 (336,057) -66.7%
TOTAL OPERATING EXPENSES 745,799 683,600 739,167 (6,065) 752,447 181,436 424,115 (328,332) -43.6%
OPERATING INCOME (LOSS) 46,451 252,684 83,019 964,565 85,659 299,932 438,176 352,517 411.5%
NONOPERATING REVENUES
Miscellaneous Revenues 0 8,908 0 545 0 (250) 0 0 N/A
Interest Earnings 5,000 14,769 5,000 11,309 5,000 0 5,000 0 0.0%
Water Connect/Recomtect Fee 13,600 21,257 17,000 20,882 17,000 7,776 17,000 0 0.0%
Total Nonoperating Revenues 18,600 44,934 22,000 32,735 22,000 7,526 22,000 0 0.0%
NONOPERATING EXPENSES
Bond hrterest (130,176) (118,601) (76,605) (47,382) (52,563) (29,390) (43,563) 9,000 -17.1%
Fiscal Agent s Fees (900) (1,034) (700) (1,193) (700) (225) (700) 0 0.0%
Total Nonoperatmg Expenses (131,076) (119,635) (77,305) (48,575) (53,263) (29,615) (44,263) 9,000 -16.9%
INCOME (LOSS) BEFORE CAPITAL
CONTRIBUTIONS AND TRANSFERS (66,025) 177,983 27,714 948,725 54,396 277,843 415,913 361,517 664.6%
CAPITAL CONTRIBUTIONS AND TRANSFERS
Transfers from Other Funds 369,556 369,556 358,425 358,425 D 361,578 361,578 N/A
Transfers to Other Funds (113,295) (113,295) (114,101) (114,101) (116,2.22) (118,401) (2,179) 1.9%
Capital Contributions 0 81,687 0 330,059 0 0 0 N/A
Total Capital Contributions and Transfers 256,261 337,948 244,324 574,383 (116,222) 0 243,177 359,399-309.2%
CHANGE IN NET POSITION 190,236 515,931 272,038 1,523,108 (61,826) 277,843 659,090 720,916-1166.0%
NET POSITION, JANUARY I 5,289,801 5,480,037 5,289,801 5,561,839 5,805,731 7084,947 5,743905 (61,826) -1.1%
NET POSITION, DECEMBER 31 5,480,037 5,995,968 5,561,839 7,084,947 5,743,905 7,362,790 6,402,995 659,090 11.5%
OTHER CASH INFLOWS
Proceeds from Bonds 0 1,520,000 0 0 N/A
Preimum on Bonds Issued 0 63,540 0 0 N/A
OTHER CASH OUTFLOWS
Principal Payments on Bonds 570,000 570,000 470,000 470.000 510,000 470.000 540,000 70.000 5.9%
Payment to Escrow Agent for Bond Reftmding 0 1,545,979 0 0 0 0 0 0 N/A
Capital Outlay 0 0 0 0 0 0 0 0 N/A
CITY OF MEDINA
2017 BUDGET
SEWER FUND
2014
Budget
OPERATING REVENUES
Charges for Services
2014
Actual
2015
Budget
2015
Actual
2016
Budget
2017 Amount Percentage
2016 Prelim Increase Increase
YTD Budget (Decrease) (Decrease)
Charges for Services 534,840 579,181 550,846 613,068 567,331 323,969 584,312 16,981 3.0%
Special Assessments 2,500 12,527 2,500 11,940 2,500 0 2,500 0 0.0%
Total Charges for Services 537,340 591,708 553,346 625,008 569,831 323,969 586,812 16,981 3.0%
TOTAL OPERATING REVENUES 537,340 591,708 553,346 625,008 569,831 323,969 586,812 16,981 3.0%
OPERATING EXPENSES
Personal Services 116,127 121,891 121,240 123,436 132,405 61,303 157,488 25,083 18.9%
Supplies 5,700 3,503 6,500 10,392 6,696 570 6,880 184 2.7%
Other Services and Charges 411,975 387,645 420,130 369,208 432,734 183,781 464,900 32,166 7.4%
TOTAL OPERATING EXPENSES 533,802 513,039 547,870 503,037 571,835 245,654 629,268 57,433 10.0%
OPERATING INCOME (LOSS) 3,538 78,669 5,476 121,972 (2,004) 78,315 (42,456) (40,452) 2018.6%
NONOPERATING REVENUES
Miscellaneous Revenues 0 2,278 0 312 0 240 0 0 N/A
Interest Eamings 8,000 15 323 5,000 13,448 5,000 0 5,000 0 0.0%
Total Nonoperating Revenues 8,000 17,601 5,000 13,759 5,000 240 5,000 0 0.0%
INCOME (LOSS) BEFORE CAPITAL
CONTRIBUTIONS AND TRANSFERS 11,538 96,270 10,476 135,731 2,996 78,555 (37,456) (40,452)-1350.2%
CAPITAL CONTRIBUTIONS AND TRANSFERS
Transfers to Other Funds (118,949) (118,949) (119,318) (119,318) (121,307) 0 (123,347) (2,040) 1.7%
Capital Contributions 0 35,763 0 13,719 0 0 0 0 N/A
Total Capital Contributions and Transfers (118,949) (83,186) (119,318) (105,599) (121,307) 0 (123,347) (2,040) 1.7%
CHANGE IN NET POSITION (107,411) 13,084 (108,842) 30,132 (118,311) 78,555 (160,803) (42,492) 35.9%
NET POSITION, JANUARY 1 273,631 273,631 286,715 286,715 4,049,142 316,847 3,930,831 (118,311) -2.9%
NET POSITION, DECEMBER 31 166,220 286,715 177,873 316,847 3,930,831 395,402 3,770,028 (160,803) -4.1%
OTHER CASH INFLOWS
Proceeds from Bonds 0 0 0 0 0 0 0 N/A
Prehnum on Bonds Issued 0 0 0 0 0 0 0 0 N/A
OTHER CASH OUTFLOWS
Principal Payments on Bonds 0 0 0 0 0 0 0 0 N/A
Payment to Escrow Agent for Bond Refunding 0 0 0 0 0 0 N/A
Capital Outlay 0 0 0 0 0 0 N/A
CITY OF MEDINA
2017 BUDGET
STORM WATER FUND
2014
Budget
OPERATING REVENUES
Charges for Services
2014
Actual
2015
Budget
2015
Actual
2016
Budget
2016 Prelim Increase Increase
YTD Budget (Decrease) (Decrease)
Charges for Services 186,430 196,094 192,023 200,620 197,783 182,136 203,716 5,933 3.0%
Special Assessments 2,500 4,017 2,500 4,577 2,500 0 2,500 0 0.0%
Total Charges for Services 188,930 200,111 194,523 205,197 200,283 182,136 206,216 5,933 3.0%
TOTAL OPERATING REVENUES
OPERATING EXPENSES
188,930 200,111 194,523 205,197 200,283 182,136 206,216 5,933 3.0%
Personal Services 57,078 58,311 60,169 58,982 68,888 30,753 72,018 3,130 4.5%
Supplies 5,200 468 5,000 434 5,151 0 5,200 49 1.0%
Other Services and Charges 56,144 63,832 57,619 87,416 63,884 37,714 64,700 816 1.3%
TOTAL OPERATING EXPENSES 118,422 122,611 122,788 146,832 137,923 68,468 141,918 3,995 2.9%
OPERATING INCOME (LOSS) 70,508 77,500 71,735 58,365 62,360 113,668 64,298 1,938 3.1%
NONOPERATING REVENUES
Miscellaneous Revenues 3,000 0 0 0 3,000 0 3,000 0 0.0%
Interest Earnings 1,000 3,331 1,000 3,010 1,000 0 1,000 0 0.0%
Total Nonoperating Revenues 4,000 3,331 1,000 3,010 4,000 0 4,000 0 0.0%
INCOME (LOSS) BEFORE CAPITAL
CONTRIBUTIONS AND TRANSFERS 74,508 80,831 72,735 61,375 66,360 113,668 68,298 1,938 2.9%
CAPITAL CONTRIBUTIONS AND TRANSFERS
Transfers from Other Funds 0 0 0 0 0 0 0 0 N/A
Transfers to Other Funds (50,200) (50,200) (51,700) (51,700) (53,251) 0 (54,849) (1,598) 3.0%
Capital Contributions 0 376,782 0 0 0 0 0 0 N/A
Total Capital Contributions and Transfers (50,200) 326,582 (51,700) (51,700) (53,251) 0 (54,849) (1,598)
CHANGE IN NET POSITION 24,308 407,413 21,035 9,675 13,109 113,668 13,449 340
NET POSITION, JANUARY 1 413,726 413,726 438,034 438,034 821,140 459,069 834,249 13,109
NET POSITION, DECEMBER 31 438,034 821,139 459,069 447,709 834,249 572,737 847,698 13,449
OTHER CASH INFLOWS
3.0%
2.6%
1.6%
1.6%
Proceeds from Bonds 0 0
Preimum on Bonds Issued 0 0
OTHER CASH OUTFLOWS
0
0
0
0
0
0
0 0 0 N/A
0 0 0 N/A
Principal Payments on Bonds 0 0 0 0 0 0 0 0 N/A
Payment to Escrow Agent for Bond Refunding 0 0 0 0 0 0 0 N/A.
Capital Outlay 41,000 0 573,375 0 433,375 0 58,375. (375,000) -86.5%
MEMORANDUM
TO: Mayor Crosby and City Council, through City Administrator Scott Johnson
FROM: Joe Rigdon, Finance Director, KDV
DATE: July 12, 2012
SUBJ: Water Fund Financial Update
Water Fund Financial Update
Background
The City is currently considering the re -characterization of approximately $1.4 million of the
2007A G.O. Water Revenue Bonds as capital improvement bonds to be used as part of a public
works facility acquisition and improvement. A projection of future Water Fund sources and uses
was completed to determine the impact on the utility.
The Water Fund is deemed to consist of an operations fund and a capital fund. The water capital
fund has historically collected water hookup charges and transferred those to the water
operations fund to assist in making debt service payments on the 2005A (water treatment plant)
G.O. Revenue Bonds and the 2007A (water tower, raw water, well) G.O. Revenue Bonds.
Because of an insufficiency in hookup fees due to economic conditions, the water capital fund
has been unable to transfer amounts as originally intended to pay the bonds.
In the scenario presented, future water cash balances were estimated by using 2011 ending
balances and forecasting 2012 and future operations based upon historical and budgeted
amounts. The scenario includes the following assumptions:
• A 5% rate increase in existing water charges each year from 2013 through 2018 and a 3%
rate increase in water charges each year thereafter
• No inclusion of increased water revenues due to new user growth; and no corresponding
increase in water operating costs
• 2013 water budgeted expenses at current proposed amounts and a 3% inflationary
increase in expenses in 2014 and each year thereafter
• Reduction in the annual water transfer out to the General Fund from $137,300 in 2012 to
$67,400 in 2013, and inflated by 3% per year thereafter (the reduction in the transfer has
been accounted for in the proposed 2013 General Fund budget)
• Inclusion of approximately $32,000 in 2013 for a 9% share in the payment of debt service
payments on a public works facility (increasing to approximately $49,000 per year from
2014 through 2023, and $35,000 per year from 2024 through 2032)
• $1.4 million of the 2007A water bonds re -characterized as CIP facility bonds in 2012,
with associated 2013 and future debt service principal and interest payments removed
from the Water Fund
• Water connections estimated at approximately 38 per year from 2012 to 2025
• Water connection fee of $6,575 for the duration of the scenario
• $180,000 outflow in 2013 for painting of water tower
" $ 3 0 0 , 0 0 0 n e t o u t f l o w i n 2 0 1 8 f o r W e l l # 8 a n d P u m p h o u s e # 3
" $ 2 , 6 0 0 , 0 0 0 b o n d p r o c e e d s a n d o u t f l o w i n 2 0 2 0 f o r a 1 , 0 0 0 , 0 0 0 g a l l o n H a m e l z o n e w a t e r
t o w e r ; b o n d s r e p a i d o v e r 2 0 2 1 t h r o u g h 2 0 4 0
A s c a n b e s e e n o n t h e p r o j e c t e d c a s h b a l a n c e s s u m m a r y f o r t h e s c e n a r i o ( p a g e s 1 - 3 ) , t h e w a t e r
o p e r a t i o n s f u n d i s p r o j e c t e d t o e n t e r a c a s h d e f i c i t p o s i t i o n i n 2 0 1 4 , w i t h t h e d e f i c i t p r o g r e s s i v e l y
b e c o m i n g l a r g e r u n t i l t h e 2 0 0 5 A a n d 2 0 0 7 A b o n d s a r e r e p a i d b y 2 0 2 0 a n d 2 0 2 3 , r e s p e c t i v e l y .
A s s u m i n g w a t e r c o n n e c t i o n s a s e s t i m a t e d a n d c o l l e c t i o n o f a s s o c i a t e d h o o k u p f e e s , o v e r a l l w a t e r
c a s h ( o p e r a t i o n s a n d c a p i t a l ) i s p r o j e c t e d t o e n t e r a s l i g h t d e f i c i t i n 2 0 1 8 , r e t u r n i n g t o a s u r p l u s i n
2 0 1 9 .
P a g e s 4 - 5 o f t h e a t t a c h m e n t i l l u s t r a t e h y p o t h e t i c a l 2 0 1 3 w a t e r r a t e c h a n g e i m p a c t s t o r e s i d e n t i a l
u s e r s o f t h e H a m e l w a t e r s y s t e m . A s s u m i n g u n c h a n g e d m o n t h l y w a t e r u s a g e p e r m o n t h f r o m
2 0 1 2 t o 2 0 1 3 o f 8 , 0 0 0 g a l l o n s , t h e m o n t h l y w a t e r c h a r g e w o u l d b e e s t i m a t e d t o i n c r e a s e b y
5 . 0 % , o r $ 1 . 8 9 . A s s u m i n g h i g h e r u s a g e o f 2 0 , 0 0 0 g a l l o n s i n a m o n t h w o u l d r e s u l t i n a 5 . 0 %
i n c r e a s e o r $ 4 . 8 6 p e r m o n t h .
I t a p p e a r s t h e C i t y '