03-12-12 SCCITEM 7
tip
O
t�e F 0
MINNESOTA
TO: Otsego Mayor and City Council
FROM: Gary Groen, Finance Director
DATE: March 8, 2012
Re: CIP update for Monday, March 12 meeting
Included with the CIP information for the March 12 meeting are sources and uses of funds
schedules, pages 73 - 95. The schedules have been updated to include more accurate beginning
balances (December 31, 2011) based on the year end work that has been completed. The
schedules also include the revisions that we have discussed in the February 13 and 27 meetings.
At the first two CIP meetings, there were some items that required some additional information
from the staff to complete the CIP discussion.
• The items included a discussion of the finance request for finance software upgrade to
consolidate the various accounting tasks into one finance software system. The
discussion also included questions about the use of the current ADP payroll application.
The analysis and discussion of the software upgrade is attached with this transmittal.
• The CIP discussion included city entrance signs for the City, ADM -12-001, page 18.
The entrance sign expenditures have been moved back to 2013 to provide additional time
to review sign locations, design and cost.
• The public utilities CIP request, UTIL-12-078 and 079, pages 48 and 49, discussed the
need to paint the interior and exterior of water tower number #1. The exterior painting
has been moved up to 2012 and the interior painting has been moved back to 2016.
• The public utilities CIP request, UTIL-12-074, page 48, was a discussion of the west
water system service to the Riverwood National development. The city engineer provide
an estimate of $650,000 and was moved up and split between 2012 and 2013.
• The public works discussion included a discussion of a hydraulic mill, hotbox and
contracting for street sweeping and blacktop patching. The hot box request, PW12-008,
page 53, was $20,000 for a hotbox. The request has been moved back to 2013. The
analysis of contracting street sweeping and blacktop patching is attached with this
transmittal.
• The city facilities CIP request, FAC -12-007, page 23, discussed the need for an east
parking specifically as needed for parking for staff and elections. However, the elections
will be divided into precincts in 2012 and the need for the parking area as designed will
be revised and brought back to the March 12 CIP meeting. A financing source for this
project has not been identified.
2
ITEM 2
sTe Fot
SOTA
TO: Otsego Mayor and City Council
FROM: Gary Groen, Finance Director
DATE: March 8, 2012
Re: Finance Software and Payroll Information
At the first CIP meeting on Monday February 13, there was discussion of a finance department
software upgrade. The proposed software would provide for an integrated financial management
system used for all accounting, payroll and utility billing functions. Currently the finance
department uses Banyon Data Systems fund accounting software, ADP provides payroll services,
and Civic Systems software is used for utility billing. The CIP request IT -12-001, page 25
discussed the proposal to combine all finance functions.
Much of that discussion related to the use of ADP payroll software and how it was currently used
in relation to the finance. At the current time, the City uses the EzLaborManager for the online
employee time reporting. The ADP system allows for the employees to record their time by
department and job code. The timesheets are approved by supervisors and all timesheets are
printed by Kathy and a final review is completed to determine all timesheets are properly
completed. Kathy summarizes the employee hours and calls the information into ADP for
processing. Payroll reports are received via UPS the following day along with the payroll
checks.
ADP does have an option to import the payroll information directly. This option would require
several changes to the current EzLaborManager set up that we are currently not using and do not
believe are necessary including a scheduling program, wage program and holiday program. The
current 8, 9 and 10 hour days, pay differential and payroll earnings links would all require
additional time to restructure the current ADP setup.
The City currently has the option to use Easypaynet. The system allows the Kathy to review the
employee timesheet information and enter it into the ADP system rather than call in the
information. The ADP payroll reports would be available for review within an hour. There is no
additional set up fee but would require additional online training.
The ADP payroll information is summarized by department and the department totals are entered
into the fund accounting system via journal entry. The journal entries take about 30 minutes
each month to enter into the fund accounting system.
According to ADP, they currently do interface with some accounting software applications.
However, the ADP information can not be interfaced with the current Banyon Fund Accounting
software. With the proposed Civic Systems software, the ADP payroll information may be able
to interface into the fund accounting software. Civic Systems believes that it could be completed
and estimated approximately $1,000 in programming time for the interface.
The proposal from Civic Systems to combine the fund accounting, payroll and utility billing
systems totaled $37,675, based on a July, 2011 quote, of which $16,600 was the cost of payroll
software, training and on-site assistance. The job costing information that we currently receive
from ADP is not included in the Civic Systems proposal.
It is my recommendation that the software upgrades includes only the fund accounting
application and remain with ADP for the payroll services. The software upgrade would provide
an important link between the fund accounting and software utility billing system. The software
upgrade without the payroll application would cost approximately $21,000.
2
Sweeper Cost Comparison
***Numbers are based on new equipment prices and potential trade in of 50% of purchase price.
**Numbers are based off of 2011 labor, fuel and maintenance costs
*Based on 214.5 actual hours of operations for the sweeper for 2011.
m
W
2011
Sweeper
Sweeper
2011 Fuel,
2011
Total
Quoted
Year and
Year
Purchase
End of Life
Total
Service
Annual
Labor
Maint.
Costs Per
Sweeper
Contract
Model
Purchased
Price
Value
Sweeper Cost
Life
Cost
Costs**
Costs**
Hour*
Cost
Price
1993 Elgin
2005
$31,955.63
$10,000.00
$21,955.63
6 yrs
$3,665.94
$6,615.39
$3,303.83
$63.33
$13,585.16
$18,125.25
2007 Elgin
2011
$77,484.38
$40,000.00
$37,484.38
8 yrs
$4,685.55
$6,615.39
$3,303.83
$68.09
$14,604.77
$18,125.25
2011 Elgin***
2011
$175,000.00
$75,000.00
$100,000.00
12 yrs
$8,333.33
$6,615.39
$3,303.83
$85.09
$18,252.55
1 $18,125.25
***Numbers are based on new equipment prices and potential trade in of 50% of purchase price.
**Numbers are based off of 2011 labor, fuel and maintenance costs
*Based on 214.5 actual hours of operations for the sweeper for 2011.
m
W
96th Street Skinpatching Costs
Labor
Hours
Hourly Rate
Labor Cost
Kevin Lamson
26
$35.00
$910.00
Steve Springer
26
$30.00
$780.00
Brent Kolles
26
$31.00
$806.00
Don Mass
17
$37.00
$629.00
Brad Sherrill
26
$24.00
$624.00
Pat Launderville
26
$37.00
$962.00
Rick Knutson
26
$37.00
$962.00
Rene Metcalf
9
$15.50
$139.50
Adam Swenson
16
$12.50
$200.00
Mike Brumm
17
$12.50
$212.50
Dirk Udee
26
$15.50
$403.00
Dean Kolles
5
$12.50
$62.50
James Gornick
19
$12.50
$237.50
265 hrs.
$6,298.00
Labor Costs= 265 hours at $6298.00
Bituminous Cost= 34.15 ton @ $65.58/ton = $2393.09
Tack Oil= 150 gallons @ $3.20/gal. = $481.90
Roller 26 hrs @ $20.00/hr. = $520.00
Misc. Equipment & Supplies= 26 hrs @ $20/hr. = $520.00
Single Axle truck 26 hrs (@ $25.00/hr. = $650.00
Total Project Cost of $10,862.99
Avg. of $318/Ton of Bit.
Date
Tons of
Bituminous
Cost/Ton
Total Bit.
Cost
7/28/11
10.02
65.58
$702.29
8/4/11
12.05
65.58
$844.57
8/17/11
6.02
65.58
$421.93
8/22/11
6.06
65.58
$424.30
34.15 ton J 1 $2,393.09
96th St. Repair Options T
Tonnage Cost
Staff Skinpatching @ $318/ton
34.18 $10,862.99
Omann Bros. Patching $400/ton
34.18 $13,672.00
Omann Bros 1" Overlay
672 $43,860.00
In -House Annual Costs for Blacktopping
Year
Labor Hours
ADP Labor Cost
Equipment &
Misc. Supplies*
Omann Bros. for
bituminous mix
Vance Bros. for
tack oil and
supplies
In House Annual
Cost of Patching
Cost/Ton
2009
439.25
$8,057.13
$5,022.03
79 ton @ $5259.90
$1,582.59
$19,921.65
$252.17
2010
772
$15,792.14
$4,266.82
67.12 ton @$4307.05
$1,913.86
$26,279.87
$391.54
2011
984.25
$18,884.94
$5,689.52
89.5 ton @ $5869.70
$1,622.77
$32,066.93
$358.29
*Equipment and Misc. Supplies cost averages $63.57/Ton.
Total Annual Blacktopping Repairs by Contractors and Staff
Bargen for
Year Cracksealing
Bargen for Infrared
Manhole Repairs
Rum River
Contracting for
Overlay Repairs
In House Annual
Cost of Patching
Annual Cost of
Blacktop Repairs
2009 $59,095.60
$0.00
$0.00
$19,921.65
$79,017.25
2010 $28,017.00
$600.00
$0.00
$26,279.87
$54,896.87
2011 $41,647.95
$6,300.00
$2,300.00
$32,066.93
$82,314.88
In-house Blacktop Repairs:
Potholes
Skin Patching
Cut-outs: deep potholes, curbstops
Catch basin Repairs
In street sewer/water repairs
Culvert replacement repairs
Utility cut repairs
Contracted Blacktop Repairs:
Cracksealing
Infrared Heating on manholes/valves
Larger overlay projects (Riverplace, full width of street)
Street/trail overlays
ITEM 4
City of Otsego, Minnesota
Capital Improvement Plan
2012 thru 2016
SOURCES AND USES OF FUNDS
Source 2012 2013 2014 2015 2016 Total
101 General Fund
Beginning Balance 0 0 0 0 0
Revenues and Other Fund Sources
Revenue
General Property Taxes 0 40,000 20,000 50,000 10,000
Total
Total Revenues and Other Fund Sources
20,000
Total Funds Available
10,000
Expenditures and Uses
20,000
Capital Projects & Equipment
10,000
Administration
20,000
PHONE SYSTEM UPGRADE
ADM -12-002
0
Total
Public Utilities
0
SW COLL SYS (REPLACE CULVERTS OUT OF
UTIL-12-067
SW COLL SYS (KADLER CULVERT/DITCH N OF
UTIL-12-068
0
Total
Total Expenditures and Uses
Change in Fund Balance
Ending Balance
0 40,000
20,000
50,000
10,000
0 40,000
20,000
50,000
10,000
0 40,000
20,000
50,000
10,000
0 0 (20, 000) 0 0
0
0
(20,000)
0
0
0
0
0
(50,000)
(10,000)
0
(40,000)
0
0
0
0
(40,000)
0
(50,000)
(10,000)
0
(40,000)
(20,000)
(50,000)
(10,000)
0
0
0
0
0
0
0
0
0
0
Page 73 Thursday, March 08, 2012
Source
201 Pavement Management Fund
Beginning Balance
Revenues and Other Fund Sources
Revenue
General Property Taxes
Total
Total Revenues and Other Fund Sources
Total Funds Available
Expenditures and Uses
Capital Projects & Equipment
Public Works
ANNUAL STREET SEAL COATING PW-ST12-059
ANNUAL STREET CRACK FILLING PW-ST12-060
ANNUAL STREET STRIPING PW-ST12-061
ANNUAL STREET PREVENTATIVE MAINTENAN PW-ST12-062
Total
Total Expenditures and Uses
Change in Fund Balance
Ending Balance
2012 2013 2014 2015 2016 Total
879,000 603,000 382,000 305,000 224,000
300,000 310,000 320,000 330,000 340,000
300,000
310,000
320,000
330,000
340,000
300,000
310,000
320,000
330,000
340,000
1,179,000
913,000
702,000
635,000
564,000
(460,000)
(390,000)
(260,000)
(265,000)
(135,000)
(53,000)
(76, 000)
(70, 000)
(76, 000)
(70,000)
(26,000)
(27,000)
(28,000)
(29,000)
(29,000)
(37,000)
(38,000)
(39,000)
(41,000)
(42,000)
(576,000) (531,000) (397,000) (411,000) (276,000)
(576,000) (531,000) (397,000) (411,000) (276,000)
(276,000)
(221,000)
(77,000)
(81,000)
64,000
603,000
382,000
305,000
224,000
288,000
Page 74 Thursday, March 08, 2012
Source
202 Trail Management Fund
Beginning Balance
Revenues and Other Fund Sources
Revenue
General Property Taxes
Total Revenues and Other Fund Sources
Total Funds Available
Expenditures and Uses
Capital Projects & Equipment
Public Works
ANNUAL TRAIL MANAGEMENT
Total Expenditures and Uses
Change in Fund Balance
Ending Balance
2012 2013 2014 2015 2016 Total
47,000 22,000 23,000 24,500 26,500
25,000 26,000 26,500 27,000 28,000
Total 25,000
26,000
26,500
27,000
28,000
25,000
26,000
26,500
27,000
28,000
72,000
48,000
49,500
51,500
54,500
PW-ST12-058 (50,000)
(25,000)
(25,000)
(25,000)
(25,000)
Total (50,000)
(25,000)
(25,000)
(25,000)
(25,000)
(50,000)
(25,000)
(25,000)
(25,000)
(25,000)
(25,000) 1,000 1,500 2,000 3,000
22,000 23,000 24,500 26,500 29,500
Page 75 Thursday, March 08, 2012
Source
203 Park Development
Beginning Balance
Revenues and Other Fund Sources
Other Fund Sources
TRSA Contribution
Total
Total Revenues and Other Fund Sources
5,000
Total Funds Available
5,000
Expenditures and Uses
0
Capital Projects & Equipment
5,000
Parks & Recreation
5,000
WILDFLOWER MEADOWS PARK
P&R-12-055
NORIN LANDING PARK PROJECT
P&R-NL12-032
PRAIRIE PARK ADDITIONAL BALLFIELDS
P&R-PP12-034
PRAIRIE PARK BALLFIELD LIGHTING
P&R-PP12-035
PRAIRIE PARK ROUGH GRADE PARKING AREA
P&R-PP12-036
PRAIRIE PARK PICNIC SHELTER
P&R-PP12-041
PRAIRIE PARK SHADE SHELTERS
P&R-PP12-050
PRAIRIE PARK BB FIELD BACKSTOP FENCING
P&R-PP12-051
PRAIRIE PARK NW PARKING LOT
P&R-PP12-053
PRAIRIE PARK SOCCER FIELDS & PARKING LO
P&R-PP12-054
(30,000)
Total
Total Expenditures and Uses
0
Change in Fund Balance
(8,000)
Ending Balance
0
2012 2013 2014 2015 2016 Total
344,000 107,500 (472,500) (467,500) (1,162,500)
0 5,000 5,000 5,000 5,000
0
5,000
5,000
5,000
5,000
0
5,000
5,000
5,000
5,000
344,000
112,500
(467,500)
(462,500)
(1,157,500)
0
0
0
(640,000)
0
0
0
0
0
(310,367)
0
0
0
0
(200,000)
0
0
0
0
(500, 000)
(198,500)
0
0
0
(128,000)
0
0
0
(60, 000)
0
(30,000)
0
0
0
0
(8,000)
0
0
0
0
0
0
0
0
(152,000)
0
(585, 000)
0
0
0
(236,500)
(585,000)
0
(700,000)
(1,290,367)
(236,500)
(585,000)
0
(700,000)
(1,290,367)
(236,500)
(580,000)
5,000
(695,000)
(1,285,367)
107,500 (472,500) (467,500) (1,162,500) (2,447,867)
Page 76 Thursday, March 08, 2012
Source
205 Park Capital Eqpt Fund
Beginning Balance
Revenues and Other Fund Sources
Revenue
General Property Taxes
Total
Total Revenues and Other Fund Sources
Total Funds Available
Expenditures and Uses
Capital Projects & Equipment
Parks & Recreation
PRAIRIE PARK PLAYGROUND P&R-PP12-044
SCHOOL KNOLL PRE -K PLAY STRUCTURE P&R-SK12-045
Total
Total Expenditures and Uses
Change in Fund Balance
Ending Balance
2012 2013 2014 2015 2016 Total
84,000 104,000 155,500 193,500 248,500
50,000 51,500 53,000 55,000 56,500
50,000
51,500
53,000
55,000
56,500
50,000
51,500
53,000
55,000
56,500
134,000
155,500
208,500
248,500
305,000
(30,000) 0 0 0 0
0 0 (15,000) 0 0
(30,000)
0
(15,000)
0
0
(30,000)
0
(15,000)
0
0
20,000
51,500
38,000
55,000
56,500
104,000 155,500 193,500 248,500 305,000
Page 77 Thursday, March 08, 2012
Source 2012 2013 2014 2015 2016 Total
206 Capital Eqpt Revolving Fund
Beginning Balance 485,000 252,758 38,758 (81,242) (253,242)
Revenues and Other Fund Sources
Revenue
General Property Taxes 150,000 155,000 160,000 165,000 170,000
Total
150,000
155,000
160,000
165,000
170,000
Total Revenues and Other Fund Sources
150,000
155,000
160,000
165,000
170,000
Total Funds Available
635,000
407,758
198,758
83,758
(83,242)
Expenditures and Uses
Capital Projects & Equipment
Building Safetv
CHEVROLET EXT CAB (BD.19)
BLD -12-001
0
0
(25,000)
0
0
FORD EXPLORER (BD.20)
BLD -12-002
0
0
0
0
(30,000)
Total
0
0
(25,000)
0
(30,000)
Information Techndoa_v
SOFTWARE UPGRADE
IT -12-001
(19,000)
(19,000)
0
0
0
Total
(19,000)
(19,000)
0
0
0
Public Works
HYDRAULIC 18' MILL
PW -12-001
(9,500)
0
0
0
0
SIDE AND REAR FLAIL MOWERS (PW.35.01)
PW -12-002
(15,000)
0
0
0
0
ONE TON DUMP TRUCK WITH PLOW (PW.38)
PW -12-003
(45,000)
0
0
0
0
SPEEDWAGON (PW.31)
PW -12-004
(91000)
0
0
0
0
EXMARK MOWER (PW.22)
PW -12-005
(10,000)
0
0
0
(10,000)
SIGN TRUCK
PW -12-006
0
(60,000)
0
0
0
CAT IT28 LOADER (PW.21)
PW -12-007
0
0
0
0
(150,000)
BLACKTOP HOT BOX
PW -12-008
0
(20,000)
0
0
0
S/A DUMP TRUCK WITH PLOW (PW.03)
PW -12-009
(180,000)
0
0
0
0
HARLEY RAKE
PW -12-010
(8,000)
0
0
0
0
UPGRADE GASBOY SYSTEM
PW -12-021
(15,000)
0
0
0
0
CHEVROLET EXT CAB (BD.17)
PW -12-022
0
(25,000)
0
0
0
ELGIN PELICAN STREET SWEEPER (PW.01)
PW -12-023
(38, 742)
0
0
0
0
INT'L S/A DUMP TRUCK (PW.02)
PW -12-024
0
0
(180,000)
0
0
FORD DUMP TRUCK W/PLOW (PW.04)
PW -12-025
0
0
0
0
(45,000)
CHEVROLET EXT CAB (PW.06)
PW -12-026
0
0
(35,000)
0
0
INT'L HARVESTER TANDEM AXLE TRUCK (PW.
PW -12-028
0
0
0
(200,000)
0
CAT GRADER (PW.05)
PW -12-029
0
(150, 000)
0
0
0
FELLING TRAILER (PW.13)
PW -12-030
0
0
0
0
(10,000)
JOHN DEERE SKID LOADER (PW.14)
PW -12-031
0
0
0
(20,000)
0
MULTI -QUIP ASPHALT ROLLER (PW.16)
PW -12-033
0
(20,000)
0
0
0
CHEVROLET 2500 PICKUP (PW.17)
PW -12-034
0
0
0
(35,000)
0
CHEVROLET EXT CAB (PW.18)
PW -12-035
0
(25,000)
0
0
0
SNOWBLOWER (PW.24)
PW -12-038
0
0
0
(50,000)
0
Page 78
Thursday, March 08, 2012
Source
(214,000)
2012
2013
2014
2015
2016 Total
206 Capital Eqpt Revolving >�iuid
252,758
38,758
(81,242)
(253,242)
FORD F350 PICKUP WITH PLOW (PW.28)
PW -12-039
(33,000)
0
0
0
0
JOHN DEERE 1545 MOWER (PW.37)
PW -12-043
0
0
0
(20,000)
0
TORO HL4800 LAWN SWEEPER (PW.41)
PW -12-046
0
0
0
0
(25,000)
JOHN DEERE Z925A ZTRAK MOWER (PW.45)
PW -12-049
0
0
0
(12,000)
0
CAT 908 LOADER (PW.46)
PW -12-050
0
0
(40,000)
0
0
JD GATOR (PW.48)
PW -12-052
0
0
0
0
(20,000)
WIDE AREA MOWER FOR PARKS
PW -12-056
0
(50,000)
0
0
0
Total
Total Expenditures and Uses
Change in Fund Balance
Ending Balance
(363,242) (350,000) (255,000) (337,000)
(382,242) (369,000) (280,000) (337,000)
(260,000)
(290,000)
(232,242)
(214,000)
(120,000)
(172,000)
(120,000)
252,758
38,758
(81,242)
(253,242)
(373,242)
Page 79 Thursday, March 08, 2012
Source
2012 2013 2014 2015 2016 Total
208 Community Facilities Fund
Beginning Balance 800,000 (114,717) (149,717) (149,717) (149,717)
Revenues and Other Fund Sources
Revenue
No Funds 0 0
0 0 0
Total 0
0
0
0
0
Total Revenues and Other Fund Sources 0
0
0
0
0
Total Funds Available 800,000
(114,717)
(149,717)
(149,717)
(149,717)
Expenditures and Uses
Capital Projects & Equipment
Cily Facilities
CITY HALL HVAC SYSTEM
FAC -12-001
(75,000)
0
CITY HALL REMODELING
FAC -12-002
(75,000)
0
CITY HALL HANDICAP ACCESSIBLE
FAC -12-003
(40,000)
0
CITY HALL ROOFING
FAC -12-004
(118,000)
0
Total
(308,000)
0
Parks & Recreation
WATERFRONT EAST PARK
P&R-12-047
(35,000)
(35,000)
DARKENWALD LANDING
P&R-DI12-033
(480,700)
0
NORIN LANDING BOAT RAMP
P&R-NL12-042
(83,517)
0
PRAIRIE PARK SPLASH PAD WATER TREATME
P&R-PP12-001
(7,500)
0
Total
(606,717)
(35,000)
Total Expenditures and Uses
(914,717)
(35,000)
Change in Fund Balance
(914,717)
(35,000)
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
Ending Balance (114,717) (149,717) (149,717) (149,717) (149,717)
Page 80 Thursday, March 08, 2012
Source 2012 2013 2014 2015 2016 Total
Page 81 Thursday, March 08, 2012
209 Street Reconstruction end
Beginning Balance
263,000
163,000
163,000
(69,000)
(69,000)
Revenues and Other Fund Sources
No Funds
0
0
0
0
0
Total
0
0
0
0
0
Total Revenues and Other Fund Sources
0
0
0
0
0
Total Funds Available
263,000
163,000
163,000
(69,000)
(69,000)
Expenditures and Uses
Capital Projects & Equipment
Public Works
CSAH 39 SERVICE ROAD
PW-ST12-066
0
0
(146,000)
0
0
LEBEAUX AVE FRONTAGE ROAD
PW-ST12-067
(100,000)
0
0
0
0
78TH ST EXTENSION - QUADAY TO QUAM
PW-ST12-068
0
0
0
0
(360,000)
NASHUA REALIGNMENT AT CSAH 39
PW-ST12-069
0
0
(86,000)
0
0
Total
(100,000)
0
(232,000)
0
(360,000)
Total Expenditures and Uses
(100,000)
0
(232,000)
0
(360,000)
Change in Fund Balance
(100,000)
0
(232,000)
0
(360,000)
Ending Balance
163,000
163,000
(69,000)
(69,000)
(429,000)
Page 81 Thursday, March 08, 2012
Source
214 Fire Capital Reserve
Beginning Balance
Revenues and Other Fund Sources
Revenue
General Property Taxes
Total
Total Revenues and Other Fund Sources
140,000
Total Funds Available
150,000
Expenditures and Uses
135,000
Capital Projects & Equipment
145,000
Public Safety
155,000
PUBLIC SAFETY - EMERGENCY RESPONSE VE
PS -12-002
PUBLIC SAFETY - FIRE DEPT
PS -12-003
EMERGENCY VEHICLE STAGING AREA
PS -12-004
FIRE STATION
PS -12-005
Total
Total Expenditures and Uses
Change in Fund Balance
Ending Balance
2012 2013 2014 2015 2016 Total
1,236,000 1,371,000 1,511,000 1,656,000 1,706,000
135,000 140,000 145,000 150,000 155,000
135,000
140,000
145,000
150,000
155,000
135,000
140,000
145,000
150,000
155,000
1,371,000
1,511,000
1,656,000
1,806,000
1,861,000
0 0 0 (100,000) 0
0 0 0 0 (500,000)
0 0 0 0 (250,000)
0 0 0 0 (1,500,000)
0 0
0
(100,000)
(2,250,000)
0 0
0
(100,000)
(2,250,000)
135,000 140,000
145,000
50,000
(2,095,000)
1,371,000 1,511,000 1,656,000 1,706,000 (389,000)
Page 82 Thursday, March 08, 2072
Source
222 Stormwater Utility Fund
Beginning Balance
Revenues and Other Fund Sources
Revenue
Stormwater Utility Fees
Total
Total Revenues and Other Fund Sources
Total Funds Available
Expenditures and Uses
Capital Projects & Equipment
Public Utilities
STORMWATER COLLECTION SYSTEM (IN DIST UTIL-12-064
STORMWATER COLLECTION SYSTEM (OTSEG UTIL-12-066
Total
Total Expenditures and Uses
Change in Fund Balance
Ending Balance
2012 2013 2014 2015 2016 Total
49,000 99,000 149,000 139,000 139,000
50,000 50,000 50,000 50,000 50,000
50,000
50,000
50,000
50,000
50,000
50,000
50,000
50,000
50,000
50,000
99,000
149,000
199,000
189,000
189,000
0 0 (50,000) (50,000) (50,000)
0 0 (10,000) 0 0
0 0 (60,000) (50,000) (50,000)
0 0 (60,000) (50,000) (50,000)
50,000 50,000 (10,000) 0 0
99,000 149,000 139,000 139,000 139,000
Page 83 Thursday, March 08, 2012
Source
2012 2013 2014 2015 2016 Total
473,000 423,000 273,000 273,000 273,000
0 0 0 0 0
0
0
403 Collector Street Fund
Beginning Balance
0
Revenues and Other Fund Sources
0
No Funds
0
0
Total
Total Revenues and Other Fund Sources
273,000
Total Funds Available
273,000
Expenditures and Uses
Capital Projects & Equipment
Public Works
85TH STREET EXTENSION
PW-ST12-070
OVERLAY 85TH ST - PAGE TO PARRISH
PW-ST12-073
Total
Total Expenditures and Uses
Change in Fund Balance
Ending Balance
2012 2013 2014 2015 2016 Total
473,000 423,000 273,000 273,000 273,000
0 0 0 0 0
0
0
0
0
0
0
0
0
0
0
473,000
423,000
273,000
273,000
273,000
(50,000) (150,000) 0 0 0
0 0 0 0 (100,000)
(50,000) (150,000) 0 0 (100,000)
(50,000) (150,000) 0 0 (100,000)
(50,000) (150,000) 0 0 (100,000)
423,000 273,000 273,000 273,000 173,000
Page 84 Thursday, March 08, 2012
Source 2012 2013 2014 2015 2016 Total
408 Otsego Creek Watershed
Beginning Balance 672,000 607,000 607,000 532,000 532,000
Revenues and Other Fund Sources
Revenue
No Funds
Total
Total Revenues and Other Fund Sources
0
Total Funds Available
0 0
Expenditures and Uses
0
Capital Projects & Equipment
0 0
Parks & Recreation
0
BEAUDRY PARK DRAINAGE
P&R-BP12-043
672,000
Total
Public Utilities
532,000 532,000
SW COLLECTION SYSTEM (OTSEGO CREEK C
UTIL-12-065
Total
Public Works
LEBEAUX AVE FRONTAGE ROAD
PW-ST12-067
Total
Total Expenditures and Uses
Change in Fund Balance
Ending Balance
0
0
0
0 0
0
0
0
0 0
0
0
0
0 0
672,000
607,000
607,000
532,000 532,000
(20,000) 0 0 0 0
(20,000)
0
0
0
0
0
0
(75, 000)
0
0
0
0 (75,000)
0
0
(45, 000)
0 0
0
0
(45,000) 0 0 0 0
(65,000) 0 (75,000) 0 0
(65,000) 0 (75,000) 0 0
607,000 607,000 532,000 532,000 532,000
Page 85 Thursday, March 08, 2012
Source
414 Revolving Capital Impry
Beginning Balance
Revenues and Other Fund Sources
Other Fund Sources
Transfer from General Fund
Total Revenues and Other Fund Sources
Total Funds Available
Expenditures and Uses
Capital Projects & Equipment
Administration
CITY ENTRANCE SIGNS (3)
City Facilities
PUBLIC WORKS 2ND FLOOR BUILD -OUT
DEMOLITION OF OLD TOWN HALL
Public Safety
EMERGENCY SIRENS (2)
Total Expenditures and Uses
Change in Fund Balance
Ending Balance
2012 2013 2014 2015 2016 Total
942,000 855,500 825,500 875,500 925,500
50,000
50,000
50,000
50,000
50,000
Total 50,000
50,000
50,000
50,000
50,000
50,000
50,000
50,000
50,000
50,000
992,000
905,500
875,500
925,500
975,500
ADM -12-001
0
(60,000)
0
0
0
Total
0
(60,000)
0
0
0
FAC -12-006
(100,000)
0
0
0
0
FAC -12-009
0
(20,000)
0
0
0
Total
(100,000)
(20,000)
0
0
0
PS -12-001
(36,500)
0
0
0
0
Total
(36,500)
0
0
0
0
(136,500)
(80,000)
0
0
0
(86,500)
(30,000)
50,000
50,000
50,000
855,500
825,500
875,500
925,500
975,500
Page 86 Thursday, March 08, 2012
Source
601 Water Fund
Beginning Balance
Revenues and Other Fund Sources
Revenue
Water Utility User Fees
Total Revenues and Other Fund Sources
Total Funds Available
Expenditures and Uses
Capital Projects & Equipment
Public Utilities
BOOSTER STATION REPAIRS/MAINT
WELL #2 PUMP & AQUIFER REHAB
WELL #1 PUMP & AQUIFER REHAB
WELL #5 PUMP & AQUIFER REHAB
WELL #6 PUMP & AQUIFER REHAB
METER REPLACEMENT PROJECT
WEST SEWER DISTRICT WELL CAPACITY
WATER TOWER #1 INT PAINTING
WATER TOWER #1 EXT PAINTING
Total Expenditures and Uses
Change in Fund Balance
Ending Balance
2012 2013 2014 2015 2016 Total
900,000 705,440 555,880 707,320 622,760
175,440 175,440 175,440 175,440 175,440
Total 175,440
175,440
175,440
175,440
175,440
175,440
175,440
175,440
175,440
175,440
1,075,440
880,880
731,320
882,760
798,200
UTIL-12-018
0
0
(24,000)
0
0
UTIL-12-021
0
0
0
(70,000)
0
UTIL-12-022
0
0
0
(70,000)
0
UTIL-12-023
0
0
0
(120,000)
0
UTIL-12-026
0
0
0
0
(100,000)
UTIL-12-045
0
0
0
0
(50,000)
UTIL-12-074
(325,000)
(325,000)
0
0
0
UTIL-12-078
0
0
0
0
(170,000)
UTIL-12-079
(45,000)
0
0
0
0
Total
(370,000)
(325,000)
(24,000)
(260,000)
(320,000)
(370,000)
(325,000)
(24,000)
(260,000)
(320,000)
(194,560)
(149,560)
151,440
(84,560)
(144,560)
705,440
555,880
707,320
622,760
478,200
Page 87 Thursday, March 08, 2012
Source 2012 2013 2014 2015 2016 Total
602 Sewer Fund
Beginning Balance 700,000 720,198 832,396 902,594 974,792
Revenues and Other Fund Sources
Revenue
Wastewater Utility Fees 112,198 112,198 112,198 112,198 112,198
Total
Total Revenues and Other Fund Sources
112,198
Total Funds Available
112,198
Expenditures and Uses
112,198
Capital Projects & Equipment
112,198
Public Utilities
112,198
WEST WWTF ROOF REPLACEMENT
UTIL-12-001
EAST WWTF ROOF REPLACEMENT
UTIL-12-002
LS #1 REPLACE PUMPS #1 AND #2
UTIL-12-003
LS #6 REPLACE PUMPS #1 AND #2
UTIL-12-005
LS #7 REPLACE PUMPS #1 AND #2
UTIL-12-007
LS #5 REPLACE PUMPS #1, #2 & #3
UTIL-12-010
SCADA COMPUTER REPLACEMENT
UTIL-12-M
Total
Public Works
ONE TON DUMP TRUCK WITH PLOW (PW.38) PW -12-003
Total
Total Expenditures and Uses
Change in Fund Balance
Ending Balance
112,198
112,198
112,198
112,198
112,198
112,198
112,198
112,198
112,198
112,198
812,198
832,396
944,594
1,014,792
1,086,990
(40,000)
0
0
0
0
(40,000)
0
0
0
0
0
0
0
(40, 000)
0
0
0
(28, 000)
0
0
0
0
(14,000)
0
0
0
0
0
0
(51,000)
0
0
0
0
(15,000)
(80,000)
0
(42,000)
(40,000)
(66,000)
(12,000)
0
0
0
0
(12,000) 0 0 0 0
(92,000) 0 (42,000) (40,000) (66,000)
20,198 112,198 70,198 72,198 46,198
720,198 832,396 902,594 974,792 1,020,990
Page 88 Thursday, March 08, 2012
Source
2012 2013 2014 2015 2016 Total
Ending Balance 0 0 0 0 0
Page 89 Thursday, March 08, 2012
Assessments
Beginning Balance
0
0
0
0 0
Revenues and Other Fund Sources
Revenue
Assessments
145,000
0
146,000
1,250,000 0
Total
145,000
0
146,000
1,250,000 0
Total Revenues and Other Fund Sources
145,000
0
146,000
1,250,000 0
Total Funds Available
145,000
0
146,000
1,250,000 0
Expenditures and Uses
Capital Projects & Equipment
Public Works
CSAH 39 SERVICE ROAD
PW-ST12-066
0
0
(146,000)
0 0
LEBEAUX AVE FRONTAGE ROAD
PW-ST12-067
(145,000)
0
0
0 0
STREET RECONSTRUCTION - MISSISSIPPI SH
PW-ST12-077
0
0
0
(1,250,000) 0
Total
(145,000)
0
(146,000)
(1,250,000) 0
Total Expenditures and Uses
(145,000)
0
(146,000)
(1,250,000) 0
Change in Fund Balance
0
0
0
0 0
Ending Balance 0 0 0 0 0
Page 89 Thursday, March 08, 2012
Source
Federal Grants
Beginning Balance
Revenues and Other Fund Sources
Revenue
Federal Grants
Total
Total Revenues and Other Fund Sources
Total Funds Available
Expenditures and Uses
Capital Projects & Equipment
Public Works
70TH ST EXTENSION -MARTIN FARMS TO OAK PW-ST12-075
Total
Total Expenditures and Uses
Change in Fund Balance
Ending Balance
2012 2013 2014 2015 2016 Total
0 0 0 (800,000) (800,000)
0
0
0
0
800,000
0
0
0
0
800,000
0
0
0
0
800,000
0
0
0
(800,000)
0
0
0
(800,000)
0
0
0
0
(800,000)
0
0
0
0
(800,000)
0
0
0
0
(800,000)
0
800,000
0
0
(800,000)
(800,000)
0
Page 90 Thursday, March 08, 2012
Source
MSA State Aid
Beginning Balance
Revenues and Other Fund Sources
Revenue
MSA Construction State Aid
Total
Total Revenues and Other Fund Sources
Total Funds Available
Expenditures and Uses
Capital Projects & Equipment
Public Works
70TH ST EXTENSION -MARTIN FARMS TO OAK PW-ST12-075
70TH ST EXTENSION - MARLOWE TO MARTIN PW-ST12-076
Total
Total Expenditures and Uses
Change in Fund Balance
Ending Balance
2012 2013 2014 2015 2016 Total
1,100,000 1,044,000 1,294,000 344,000 394,000
464,000 450,000 450,000 450,000 450,000
464,000
450,000
450,000
450,000
450,000
464,000
450,000
450,000
450,000
450,000
1,564,000
1,494,000
1,744,000
794,000
844,000
(100,000) (200,000) (1,400,000) (400,000) 0
(420,000) 0 0 0 0
(520,000) (200,000) (1,400,000) (400,000) 0
(520,000) (200,000) (1,400,000) (400,000) 0
(56,000)
250,000
(950,000)
50,000
450,000
1,044,000
1,294,000
344,000
394,000
844,000
Page 91 Thursday, March 08, 2012
Source 2012 2013 2014 2015 2016 Total
Other Aids/Grants
Beginning Balance 0 0 0 0 0
Revenues and Other Fund Sources
Revenue
DNR Grant 83.517 0 0 0 0
Total
83,517
0
0
0
0
Total Revenues and Other Fund Sources
83,517
0
0
0
0
Total Funds Available
83,517
0
0
0
0
Expenditures and Uses
Capital Projects & Equipment
Parks & Recreation
NORIN LANDING BOAT RAMP P&R-NL12-042
(83,517)
0
0
0
0
Total
(83,517)
0
0
0
0
Total Expenditures and Uses
(83,517)
0
0
0
0
Change in Fund Balance
0
0
0
0
0
Ending Balance
0
0
0
0
0
Page 92 Thursday, March 08, 2012
Source
Other Local Sources
Beginning Balance
Revenues and Other Fund Sources
Revenue
Insurance Reimbursements
Total Revenues and Other Fund Sources
Total Funds Available
Expenditures and Uses
Capital Projects & Equipment
City Facilities
CITY HALL ROOFING
Total Expenditures and Uses
Change in Fund Balance
Ending Balance
2012 2013 2014 2015 2016 Total
0 0 0 0 0
18,000 0 0 0 0
Total 18,000
0
0
0 0
18,000
0
0
0 0
18,000
0
0
0 0
FAC -12-004 (18,000) 0 0 0 0
Total (18,000) 0 0 0 0
(18,000) 0 0 0 0
0 0 0 0 0
0 0 0 0 0
Page 93 Thursday, March 08, 2012
Source
Proceeds of Long Term Debt -Tax
Beginning Balance
Revenues and Other Fund Sources
Revenue
Proceeds of Long Term Debt
Total
Total Revenues and Other Fund Sources
Total Funds Available
Expenditures and Uses
Capital Projects & Equipment
Public Works
STREET RECONSTRUCTION - MISSISSIPPI SH PW-ST12-077
Total
Total Expenditures and Uses
Change in Fund Balance
Ending Balance
2012 2013 2014 2015 2016 Total
0 0 0 0 0
0 0 0 1,250,000 0
0 0
0
1,250,000 0
0 0
0
1,250,000 0
0 0
0
1,250,000 0
0 0 0 (1,250,000) 0
0 0 0 (1,250,000) 0
0 0 0 (1,250,000) 0
0 0 0 0 0
0 0 0 0 0
Page 94 Thursday, March 08, 2012
Source
2012 2013 2014 2015 2016 Total
Unfunded
Beginning Balance 0 (297,750) (297,750) (297,750) (2,197,750)
Revenues and Other Fund Sources
No Funds 0
0 0 0 0
Total 0 0
0
0
0
Total Revenues and Other Fund Sources 0 0
0
0
0
Total Funds Available 0 (297,750)
(297,750)
(297,750)
(2,197,750)
Expenditures and Uses
Capital Projects & Equipment
Cily Facilities
PUBLIC WORKS EAST PARKING LOT
FAC -12-007
(162,750)
PUBLIC WORKS BUILDING EXPANSION
FAC -12-008
0
Total
(162,750)
Parks & Recreation
TRAIL - QUEENS TO RIVERPOINTE AREA
P&R-12-048
(135,000)
Total
(135,000)
Total Expenditures and Uses
(297,750)
Change in Fund Balance
(297,750)
0 0 0 0
0 0 (1,900,000) 0
0 0 (1,900,000) 0
0 0 0 0
0 0 0 0
0 0 (1,900,000) 0
0 0 (1,900,000) 0
Ending Balance (297,750) (297,750) (297,750) (2,197,750) (2,197,750)
Page 95 Thursday, March 08, 2012