11-13-12 WS Agenda
2
MEETING TYPE
Work Session
City of Shorewood Work Session Item
Meeting
Title / Subject: Financial Consultant Presentations
Meeting Date: November 13, 2012
Prepared by: Bruce DeJong, Finance Director
Reviewed by: Bill Joynes, Interim City Administrator
Policy Consideration:
Should the City Council select a financial advisory firm?
Background:
The City Council has discussed the water system and financing mechanisms during the review of the
water plan earlier this year. Staff has been in contact with several financial advisory firms to discuss the
possibility of refunding our outstanding water fund bonds to save on interest expense. These firms will
provide presentations to the City Council to assist in determining which firm to select.
The three firms, which will present in alphabetical order are:
Ehlers, Inc. – Roseville, MN
Northland Securities, Inc – Minneapolis, MN
Springsted, Inc. – St. Paul, MN
Northland Securities has provided financial advisory services for the City and EDA
Recommendation / Action Requested:
Staff recommends that the City Council interview the firms, review the materials, and make a selection
of financial advisor at the meeting of November 26.
Next Steps and Timelines:
Once a financial advisor is selected, staff will work with them to craft a preliminary refunding analysis
and call for sale to be adopted by the City Council.
Connection to Vision / Mission:
This process contributes to excellent financial management by providing high quality, reliable public
utility services at a low cost.
Mission Statement: The City of Shorewood is committed to providing residents quality public services, a
healthy environment, a variety of attractive amenities, a sustainable tax base, and sound financial
management through effective, efficient, and visionary leadership. Page 1
3
MEETING TYPE
Work Session
City of Shorewood Work Session Item
Meeting
Title / Subject: 2013 Capital Improvement Plan and Enterprise Budgets
Meeting Date: November 13, 2012
Prepared by: Bruce DeJong, Finance Director
Reviewed by: Larry Brown, Public Works Director
Bill Joynes, Interim City Administrator
Attachments: Budget Worksheets
Projects by Department
Policy Consideration:
How should enterprise budgets and capital projects be prioritized, scheduled, and funded?
Background:
The entire Capital Improvement Plan (CIP) and enterprise fund budgets will be reviewed at this meeting.
The ten-year CIP and the budgets have been updated based on the discussions held on October 8 and
October 22.
Fund 402 - The Park Commission has merged its various project lists into one that includes everything on
the CIP. Because of this, the projects beyond 2013, particularly Badger Park modifications, are still
speculative in nature. This fund is fully funded for 2013, but does not have enough to cover all items on
the list starting in 2014. Longer term analysis of park needs in conjunction with a joint meeting of the
Park Commission and City Council in 2013 will be a good next step to resolving this funding challenge.
Fund 403 - Equipment Replacement fund generally covers all of the city’s rolling stock and attachments
along with the equipment at the Public Works shop to keep everything running. Projects from the Public
Facilities and Technology have been incorporated into this fund. The next ten years of equipment
purchases average about $185,000 per year, so this level of replacement requires additional resources
to fully fund equipment needs over the long term.
New projects have been added since the meeting on October 8.
1.Network Connection between City Hall, Southshore Center, and Public Works
This could be accomplished several different ways – fiber optic cable, point-to-point wireless, or
potentially through Mediacom. Costs is estimated at roughly $10 per lineal foot based on a
quote received from a vendor.
2.Laserfiche Upgrade
This allows better access to city records by internet users and includes workflow software to
allow easier entry of documents by staff in the normal course of business rather than as a
process after the fact. The cost today would be about $5,900 because we have some pro-rated
credit available from our unused annual maintenance. The cost will increase by over $2,060 if
we wait until January to purchase this upgrade.
Mission Statement: The City of Shorewood is committed to providing residents quality public services, a
healthy environment, a variety of attractive amenities, a sustainable tax base, and sound financial
management through effective, efficient, and visionary leadership. Page 1
3.Copier Replacement
This project anticipates purchase of a new copier for about $9,000. Annual per-copy costs
would go down by about $1,900 per year. This would be about a five year payback of the costs
and the current copier has had a service life of seven years.
Staff has included the merger of Public Facilities and Technology funds into the Equipment Replacement
fund as an action item on the regular meeting agenda as recommended by the City Council.
The 2013 projects essentially become the capital outlay portion of the budget. The remaining year’s
projects are then used to evaluate the solvency and funding adequacy of each capital projects fund and
the utility funds over the ten years shown in the plan.
Staff recommends that certain projects specifically approved by the City Council be delegated to staff to
complete as long as the total cost is at or below the amount listed in the CIP. If a project exceeds the
budgeted amount, staff will bring that back for a budget amendment prior to purchase. All other
projects will be brought back to the City Council for approval prior to purchase. A list is included as an
attachment.
Fund 490 – Southshore Center
Operations have undergone significant changes this year. Community Recreation Resources has been
contracted to run the center with greatly expanded hours of operation. Staff worked with Kristi
Anderson, principal for CRR, on an amended agreement which was adopted by the City Council in
January, 2012. The budget has been modified to make clearer which expenditures are includes in
specific line items.
Fund 601 – Water
The City Council is interviewing financial advisory firms to determine if the City should refund water
bonds in order to take advantage of low interest rates.
Fund 611 – Sewer
A rate study should be performed after a decision has been made regarding use of this fund balance to
cover project costs for the Storm Water fund.
Fund 621 – Recycling
No changes from the previous presentation.
Fund 631 – Storm Water is actually profitable in a financial accounting sense, but the cash drain created
by new projects needs to be covered. This should be included in the Sewer Fund rate study.
Financial or Budget Considerations:
Several funds do not have adequate resources to cover the operations and capital items listed. The Park
Capital Improvement fund runs out of money in 2014 if all the Badger Park items are funded. The
Equipment Replacement fund runs out of money in 2015 if no additional funding sources are found. The
Community Infrastructure fund runs out of money in 2020 if no adjustments are made. The Southshore
Center fund will need additional support from either neighboring communities or from the General Fund
to continue operations. The Storm Water fund runs out of cash in 2015 if no adjustments are made.
The plan discussed last year anticipates transfers from the Sewer fund to cover new storm drainage
projects if bonding is not used as a financing source. City Council should prioritize the projects in each of
these funds and determine a method of funding the highest ranking projects over the selected time
horizon.
Recommendation / Action Requested:
Staff recommends that the City Council review the budgeted expenditures for the 2013-2022 CIP and
2013 enterprise budgets and direct staff to make any changes that are desired.
Next Steps and Timelines:
Adoption of the 2013 Budget and 2013-2022 CIP is anticipated for December 10.
Connection to Vision / Mission:
These purchases contribute to providing excellent public services by maintaining high quality, reliable
public utility services and infrastructure.
City of Shorewood, Minnesota
Capital Improvement Program
20132022
thru
PROJECTS BY DEPARTMENT
Department#Priority2013201420152016201720182019202020212022Total
402 - Park Capital Improvement
Gideon Glen Parking Lot & Signage 5 20,000
P0003 20,000
Freeman Plaza P01005 5,000
5,000
Freeman North Playground Equipment 4 55,000
P0102 55,000
Freeman Parking Lot w/ MCWD P01035 50,000
50,000
Freeman Ball Field Lights P01045 75,00075,000
Freeman Picnic Shelter Re-Roof P01054 3,000
3,000
Freeman Park - Eddy Station P01084 8,5003,00011,500
Cathcart Park - Resurface 1 6,5007,0007,000
P0200 20,500
Tennis/Basketball Courts
Cathcart Park Hockey Boards 3 20,000
P0201 20,000
Cathcart Park Tot Lot P02025 50,000
50,000
Cathcart Parking Lot P02035 100,000100,000
Badger Park - Rustic Trail 3 10,000
P0300 10,000
Badger Park Tennis Courts P03012 200,0008,0008,500216,500
Badger Park Hockey Rink 2 200,000
P0302 200,000
Badger Park Swing Set P03032 12,000
12,000
Badger Park Green Space 2 20,000
P0304 20,000
Badger Park Warming House P03052 80,000
80,000
Badger Park Playground Equipment 2 65,000
P0306 65,000
Manor Park - Versa-Court Tennis Surface P04001 30,000
30,000
Manor Park - Water Source for Garden 1 8,000
P0401 8,000
Manor Park - Shelter Outside Floor & P04021 5,400
5,400
Stoops
Silverwood Park-Resurface 1/2 court 2 2,0002,5002,500
P0500 7,000
Silverwood Park Equipment P05013 60,000
60,000
Silverwood Park Swing Set 3 14,000
P0502 14,000
Skate Park Rehab P06003 75,000
75,000
Skate Park Picnic Shelter P06015 15,00015,000
Skate Park - Community Garden Fencing P06025 5,000
5,000
Department#Priority2013201420152016201720182019202020212022Total
141,500652,00028,5003,000113,000134,50019,000128,9009,5003,0001,232,900
402 - Park Capital Improvement Total
403 - Equipment Replacement
Replace Unit 21 - 24' trailer 2 16,000
E-12-01 16,000
Sand Pro 3000 - replace Unit 64 E-12-022 13,000
13,000
Groundsmaster Mower- Toro 328D - E-12-032 30,00030,000
replace unit 75
Air Compressor-Replace unit 38 E-13-013 12,000
12,000
Dump Truck - replace unit 65 3 160,000
E-13-02 160,000
Dump Truck - Replace Unit 68 E-13-032 165,000
165,000
Pickup 4x4 - Replace Unit 78 3 38,000
E-13-04 38,000
Cab for mower - replace A3 E-13-053 8,000
8,000
Utility Truck w/crane & toolbox replace E-14-015 77,00077,000
unit 76
Mower - Replace Unit 84 E-14-024 25,000
25,000
Utility Vehicle - replace unit 77 4 26,000
E-14-03 26,000
Blower Attachment for Skid Steer E-14-044 12,500
12,500
Cab attachement for mower replace unit 4 7,000
E-14-05 7,000
A4
Pick-up - 4 x 4 150 Replace Unit 80 E-15-015 35,000
35,000
Dump Truck - replace unit 72 5 175,000
E-15-03 175,000
Trailer 18' replace unit 59 E-16-015 15,000
15,000
Sewer Jetter - replace unit 60 5 53,000
E-16-02 53,000
Pickup - 350 4x4 replace unit 81 E--17-015 42,000
42,000
Groundsmaster Mower replace unit 91 5 28,000
E-17-02 28,000
Cab for mower replace A4 E-17-045 7,000
7,000
Skid Steer - replace unit 63 E-19-015 46,00046,000
ATV - replace unit 34 5 20,000
E-19-02 20,000
4" pump replace unit 50 E-20-015 45,00045,000
Trailer 12' replace unit 69 5 4,000
E-20-02 4,000
Pickup 350 4x4 - replace unit 91 E-20-045 42,000
42,000
Sweeper - replace unit 74 5 190,000
E-21-01 190,000
Cab for mower - replace A3 E-21-035 8,000
8,000
Flatbed - 4 x 2 Replace unit 49 5 44,000
E-24-01 44,000
Broom Attachment - Skid Steer replace E-25-025 3,000
3,000
A13
Street Sign Replacement 2 6,3006,6006,9007,2007,5007,8008,1008,4008,7009,000
LR-99-001 76,500
South Shore Community Center PF-11-01n/a 2,50043,00041,0002,000
88,500
Public Works Building n/a 4,00010,00081,000
PF-12-01 95,000
Financial Software T-12-032 90,000
90,000
Department#Priority2013201420152016201720182019202020212022Total
Network Connection 2 20,000
T-13-01 20,000
Laserfiche Upgrade T-13-022 8,0008,000
Color Copier Replacement 2 9,000
T-13-03 9,000
Computer Upgrades T-99-991 20,00010,00010,00010,00010,00010,00010,00010,00010,00010,000
110,000
1,843,500
352,800216,600256,900258,700263,50071,80068,100253,40082,70019,000
403 - Equipment Replacement Total
404 - Street Reconstruction
Afton Road LR-11-011 33,00033,000
Elbert Point 3 27,000
LR-13-01 27,000
KcKinley Circle LR-13-023 21,000
21,000
McLain Road 3 26,000
LR-13-03 26,000
Shady Hills Rd (& Alley)LR-13-043 58,000
58,000
Shore Road 3 26,000
LR-13-05 26,000
Valleywood Circle & Lane LR-13-063 601,000
601,000
Charleston Circle 4 36,000
LR-14-01 36,000
Club Valley Road LR-14-024 29,000
29,000
Lake Virginia Drive LR-14-034 63,00063,000
Radisson Entrance 4 33,000
LR-14-04 33,000
Shady Lane LR-14-054 24,000
24,000
Sunnyvale Lane 4 228,000
LR-14-06 228,000
Timber Lane LR-14-074 55,000
55,000
Chaska Road 5 87,000
LR-15-01 87,000
Mayflower Road LR-15-025 33,000
33,000
McKinley Court 5 40,000
LR-15-03 40,000
Murray Hill Road LR-15-045 52,000
52,000
Star Circle & Lane LR-15-055 453,000453,000
Summit Avenue 5 32,000
LR-15-06 32,000
Amlee Road LR-16-015 332,000332,000
Garden Road 5 42,000
LR-16-02 42,000
Gillette Curve LR-16-035 35,000
35,000
Manitou Lane 5 317,000
LR-16-04 317,000
McKinley Place N & S LR-16-055 65,000
65,000
Shady Hills Circle 5 51,000
LR-16-06 51,000
Echo Road LR-17-015 71,000
71,000
Howards Point Road LR-17-025 180,000180,000
Kathleen Court 5 22,000
LR-17-03 22,000
Oak Ridge Circle LR-17-045 29,00029,000
Riviera Lane 5 371,000
LR-17-05 371,000
Shorewood Lane LR-17-065 432,000
432,000
Department#Priority2013201420152016201720182019202020212022Total
Mann Lane 5 444,000
LR-18-01 444,000
Maple Street LR-18-025 100,000100,000
Bayswater Road 5 100,000
LR-19-01 100,000
Boulder Circle LR-19-025 49,000
49,000
Christmas Lane W 5 32,000
LR-19-03 32,000
Lilac Lane LR-19-055 46,000
46,000
Strawberry Lane 5 85,000
LR-19-06 85,000
Vine Street LR-19-075 33,000
33,000
Birch Bluff Road LR-20-015 107,000107,000
Excelsior Blvd LR-20-025 19,000
19,000
Seamans Drive LR-20-035 629,000629,000
West Lane 5 32,000
LR-20-04 32,000
Christmas Lane E LR-21-015 21,000
21,000
Christmas Lake Road 5 107,000
LR-21-02 107,000
Country Club Road LR-21-035 95,000
95,000
Maintenance-Bituminous Sealcoating 1 220,000270,000228,000245,000184,000238,000305,000274,000255,000
LR-99-100 2,219,000
955,000762,000958,0001,087,0001,289,000782,000650,0001,061,000478,0008,022,000
404 - Street Reconstruction Total
405 - MSA Construction
Eureka Road N 5 1,922,000
LR-19-04 1,922,000
1,922,0001,922,000
405 - MSA Construction Total
406 - Trails
Trail Connection to LRT 1 72,000
T001 72,000
Smithtown from West Border to T0021 357,500
357,500
Minnewashta Elem
Galpin Lake Rd T0031 192,500
192,500
Mill Street 1 137,500
T004 137,500
From 7/41 to Chanhassen Trail T0051 24,000
24,000
Smithtown from Minnewashta to 19 T0061 412,500412,500
Strawberry Lane 1 192,500
T007 192,500
County Road 19 from Pub Works to T0081 220,000
220,000
Excelsior
St. Albans Bay Rd T0091 110,000
110,000
Edgewood Road T0101 165,000165,000
Excelsior Blvd Trail 1 30,000
T011 30,000
1,913,500
459,500192,500137,50024,000412,500192,500220,000110,000165,000
406 - Trails Total
Department#Priority2013201420152016201720182019202020212022Total
601 - Water
Radio/ISP Communications System 1 80,000
W-10-01 80,000
Water Main - Star Circle & Lane W-11-02n/a 130,000
130,000
Water Main - Valleywood Circle & Lane n/a 272,000
W-12-01 272,000
Water Main - Sunnyvale Lane W-13-02n/a 100,000
100,000
W. Water Tower - Rehab & Painting 3 450,000
W-13-03 450,000
Water Interconnect with Excelsior W-13-043 251,400
251,400
HWY 7 Water Main Crossing 3 311,300
W-13-05 311,300
1,364,700100,000130,0001,594,700
601 - Water Total
611 - Sewer
Radio/ISP Communications - Lift Station 1 40,00010,000
SS-10-10 50,000
Retrofit
Lift Station 11 Rehab - 20465 Radisson SS-13-013 180,000180,000
Rd.
Lift Station 11 Force Main Separation SS-13-023 194,800
194,800
Lift Station 9 Rehab - 20995 Minnetonka 3 120,000
SS-14-01 120,000
Blvd
Lift Station 10 Rehab - 4773 Lakeway SS-15-013 80,00080,000
Terrace
Lift Station 20 Rehab - 26550 Noble Road SS-16-013 70,000
70,000
Lift Station 7 Rehab - 5600 Woodside 3 80,000
SS-16-02 80,000
Road
Lift Station 18 Rehab - 4996 Shady Island SS-17-013 10,000
10,000
Point
Infiltration and Inflow Reduction SS-99-051 70,00070,00070,00070,00070,00070,00070,00070,00070,000
630,000
1,414,800
484,800200,000150,000220,00080,00070,00070,00070,00070,000
611 - Sewer Total
631 - Stormwater Management
Lake South Auto Drainage - WSB Report STM-12-053 24,000
24,000
Valleywood Circle & Lane - Drainage 4 142,000
STM-12-08 142,000
Shorewood Lane Ditch STM-13-014 70,000
70,000
Sunnyvale Lane Drainage STM-13-024 192,000192,000
Excelsior Blvd Drainage 4 40,000
STM-13-03 40,000
Club Valley Drainage STM-14-014 101,000101,000
6120 Riviera Drainage - WSB Report 3 19,000
STM-14-04 19,000
Star Circle & Lane STM-15-015 31,000
31,000
Grant Lorenz 5 50,00050,00050,000
STM-15-02 150,000
23350 Academy Drainage STM-15-044 75,000
75,000
Department#Priority2013201420152016201720182019202020212022Total
Garden Road 4 26,000
STM-15-05 26,000
Amlee/Glen Road STM-16-014 381,000381,000
Manitou Lane 4 75,000
STM-16-02 75,000
Riveria Lane STM-17-014 87,000
87,000
Shorewood Lane 4 99,000
STM-17-02 99,000
Mann Lane STM-18-014 105,000
105,000
Maple St 4 24,000
STM-18-02 24,000
Eureka Road N STM-19-014 452,000
452,000
Seamans Drive STM-20-014 148,000148,000
Rampart Ct. Drainage STM-22-011 11,880
11,880
2,252,880
252,000336,000182,000506,000236,000129,000452,000148,00011,880
631 - Stormwater Management Total
4,010,3002,459,1001,842,9002,098,7002,394,0001,379,8003,401,1001,771,300805,20033,880
20,196,280
GRAND TOTAL
SOUTHSHORE COMMUNITY CENTER
Revenue Coding: 490-
Expenditure Coding: 490-48000-
Requested
ActualActualBudgetYTDBudgetDollar
Percent
REVENUES20102011201220122013ChangeChange
34101Rentals 48,000 61,801 75,000 29,331 55,000 -27%(20,000)
34790Class fees 2,500 9,958 2,500 14,272 15,500 520%13,000
36210Interest Income 100 - 100 - 100 0%0
36230Contributions/Donations 1,500 7,942 1,000 1,019 1,000 0%0
36270Miscellaneous Revenue 4,000 411 1,500 436 1,500 0%0
39201Transfers In 48,591 13,600 - 52,700 288%39,100
34%
32,100
TOTAL REVENUES 56,100 128,703 93,700 45,058 125,800
EXPENDITURES
MATERIALS & SUPPLIES
200Office Supplies 190 0
208Postage 460 0
223Maintenance of Building 7,200 317 7,500 3,925 5,000 -33%(2,500)
245General Supplies 800 4,917 800 1,194 800 0%0
246Program Expense 12,417 13,000 13,000
247Community Event Expense 4,003 4,000 4,000
TOTAL MATERIALS & SUPPLIES 8,000 5,234 8,300 22,189 22,800 175%14,500
OTHER SERVICES
302Consulting Fees 54,282 76,000 76,000
304Legal - - - - - 0
321Communication 20 610 100 1,114 1,500 1400%1,400
351Print/Publish 1,000 1,492 1,000 1,403 1,500 50%500
360Insurance-Total 2,500 325 3,000 - 1,000 -67%(2,000)
380Utilities 11,000 14,567 11,000 9,834 11,000 0%0
400Contractual 30,000 50,540 60,000 4,130 10,000 -83%(50,000)
410Rentals 2,245 0
433Dues & Subscriptions 204 0
437Taxes/Licenses 728 0
440Misc. Services 10,000 13,357 10,000 575 2,000 -80%(8,000)
450Bank Service Charges 599 - 29 - 0
TOTAL OTHER SERVICES 54,520 81,490 85,100 74,544 103,000 21%17,900
CAPITAL OUTLAY
540Building & Structures - 24,261 - - - 0
TOTAL CAPITAL OUTLAY - 24,261 - - -
0
TOTAL EXPENDITURES-16%
62,520 110,985 93,400 96,733 125,800 32,400
Revenues over/(under) (6,420) 17,718 300 (51,675) -
WATER FUND
Revenue Coding: 601-
Expenditure Coding: 601-49400-
Requested
Percent
ActualActualBudgetYTDBudgetDollar
20102011201220122013ChangeChange
REVENUES
Water Sales465,861509,737630,000518,712630,000
371100%0
Special Assessments21,74417,14835,0004,55735,000
361010%0
Permits & Connection Fees29,18415,4901,00020,7901,000
371700%0
Interest Earnings31,99930,35935,000035,000
362100%0
Water Meter Sales3,0281,6902,5001,2352,500
371710%0
Antennae Space Rental148,859146,228100,000102,2370
37175-100%(100,000)
Total Revenues700,675720,652803,500647,531703,500(100,000)
-12%
EXPENSES
Personal Services
101Regular Salaries64,35980,27074,00070,71282,36511%8,365
102O.T. Salaries2,0572,9263,0001,0863,0000%0
121PERA City Share4,5245,9155,9725,1866,1894%217
122FICA City Share4,8175,9366,3105,1536,5313%221
131Ins. City Share8,15810,85710,0113,74310,5015%490
151Workers Compensation6832,4180
Total Personal Services84,598105,90499,29388,298108,5853%9,292
Supplies
208Postage 1,235 1,354 1,300 1,080 1,3000%0
221Maint-Equipment 4,244 3,027 6,500 5,494 6,5000%0
223Maint-Buildings 252 444 1,000 1,452 1,0000%0
240Small Tools 290 43 550 686 5500%0
245General Supplies 7,608 10,457 10,000 8,649 10,0000%0
260Wtr Purch - Tonka Bay 2,125 2,662 3,300 1,207 3,3000%0
261Wtr Purch - Excelsior 18,892 20,001 17,500 16,714 17,5000%0
262Wtr Purch - Mtka 687 1,269 1,000 400 1,0000%0
263Wtr Purch - Chan 11,380 13,122 12,000 9,606 12,0000%0
265Water Meters 5,631 4,024 5,000 8,555 15,000200%10,000
Total Supplies 52,344 56,403 58,150 53,843 68,15017% 10,000
Other Services & Charges
301Financial & Audit 2,250 296 2,250 - 2,2500%0
303Engineering 2,070 - - 8,318 5,0005,000
321Communication 978 822 1,500 574 2,50067%1,000
331Travel, Conf,Sch 350 700 600 525 6000%0
351Print/Publish 628 583 1,000 558 1,0000%0
360Insurance-Total 7,816 - 8,000 - 8,0000%0
394Utilities - Amesbury 9,672 11,620 10,000 7,753 11,00010%1,000
395Utilities - Badger 10,243 11,645 11,000 5,756 11,0000%0
396Utilities - Boulder Bridge 16,799 18,287 15,000 14,946 18,50023%3,500
398Utilities - SE Area/Tower 29,892 30,277 30,000 21,657 30,0000%0
400Contractual 13,987 25,580 15,000 6,694 30,000100%15,000
420Depreciation 279,699 273,673 290,000 - 290,0000%0
437Licenses-Sales Taxes 4,382 3,164 3,000 - 3,0000%0
440Misc. Services 126 137 200 196 2000%0
450Bank Svc Chgs 95 - 525 8 5250%0
Total Other Services & Charges 378,987 376,784 388,075 69,985 413,5757% 25,500
Capital Outlay
580Other Improve 2,446 34,543 - - -0
Total Capital Outlay 2,446 34,543 - - - -
Debt Service
611Bond Interest 124,656 115,975 103,398 53,578 103,3980%0
620Fiscal Agent Fees 750 753 1,500 323 1,5000%0
Total Debt Service 125,406 116,728 104,898 53,901 104,8980% -
TOTAL EXPENSES 643,781 690,362 650,416 266,027 695,2087%46,581
REVENUES OVER/(UNDER) EXPENSES 56,894 30,290 153,084 381,504 8,292
SEWER FUND
Revenue Coding: 611-
Expenditure Coding: 611-49450-
Requested
YTDPercent
ActualActualBudgetBudgetDollar
REVENUES
20102011201220122013ChangeChange
Interest Earnings 38,439 27,939 36,000 - 36,000
3621029% 8,061
Sewer Serv Charges 812,537 792,420 825,000 621,453 825,000
372104% 32,580
Sewer Chg-Cnty Coll 28,456 25,877 -
37220 (25,877)
Local SAC Charges 2,400 - - 2,400 -
37250 -
Sewer Permits 1,650 1,200 700 1,800 700
37270-42% (500)
Tsfr From Other Funds 60,000 - - - -
39201 -
Total Revenues 943,482 847,436 861,700 625,653 861,700 14,264
2%
EXPENSES
Personal Services
Regular Salaries 53,842 76,410 71,179 41,796 71,331
101-7% (5,079)
O.T. Salaries 922 2,177 1,200 2,546 2,000
102 (177)
PERA City Share 3,740 5,541 5,260 3,197
1215,316-4% (225)
FICA City Share 4,004 5,690 5,545 3,230
1225,610-1% (80)
Ins. City Share 6,538 10,177 9,017 3,391 9,017
131-11% (1,160)
Workers Compensation 683 2,152
151 -
69,729 99,995 92,201 56,312 93,274 (6,721)
Total Personal Services-7%
Supplies
Office Supplies 102 105 110 109 110
200 5
Postage 1,211 1,299 1,500 946 1,500
20815% 201
Maint-Equipment 14,640 1,673 5,000 1,182 5,000
221199% 3,327
Small Tools 79 120 550 45 5,550
2404525% 5,430
General Supplies 919 1,519 2,100 550 2,100
24538% 581
16,951 4,716 9,260 2,832 14,260 9,544
Total Supplies202%
Other Services & Charges
Financial & Audit 2,250 - 2,250 - 2,250
300 2,250
5,000
303Engineering
Consulting - - 1,500 204 1,500
308 1,500
Engineering - Design Stage 4,634 - 5,000 583 5,000
313 5,000
Communication 3,806 4,108 4,000 2,534 4,500
32110% 392
Travel, Conf,Sch 934 1,300 1,500 - 1,500
33115% 200
Insurance-Total 5,225 - 6,500 773 6,500
360 6,500
Utilities-Gas/Elec 5,919 6,518 6,000 3,486 6,000
380-8% (518)
MCES Service Charges 564,332 714,110 728,000 506,631 753,480
3856% 39,370
Excelsior Sewer Chg 29,941 29,988 31,000 22,437 31,000
3863% 1,012
Contractual 31,825 42,521 20,000 7,859 20,000
400-53% (22,521)
Depreciation 218,483 214,247 225,000 - 225,000
4205% 10,753
Misc. Services 126 160 150 195 150
440-6% (10)
Service Charges 110 4 900 - 900
45022400% 896
867,850 1,012,956 1,031,800 544,702 1,062,780 44,824
Total Other Services & Charges5%
Capital Outlay
Other Improve 25,643 29,889 22,015
580 (29,889)
25,643 29,889 - 22,015 -
Total Capital Outlay (29,889)
Transfers
Permanent - - - - -
720 -
Total Transfers - - - - -
-
TOTAL EXPENSES 980,173 1,147,556 1,133,261 625,861 1,170,314 17,758
2%
REVENUES OVER/(UNDER) EXPENSES (36,691) (300,120) (271,561) (208) (308,614)
RECYCLING FUND
Revenue Coding: 621-
Expenditure Coding: 621-49550-
Requested
ActualActualBudgetBudgetDollar
YTDPercent
20102011201220122013ChangeChange
REVENUES
336200% -
County Recycling Aid 23,560 23,086 23,000 23,007 23,000
33621 -
County Park Recycling Grant 10,500
36101 -
Special Assessment 5,184
362100% -
Interest Earnings 656 319 350 - 350
373100% -
Recycling Service Charges 154,279 147,957 155,000 119,513 155,000
373200% -
City Clean-up Fees - (1,247) 6,000 (2,231) 6,000
37330 -
Recycling Bin Sales - - - - -
37340 -
Revenue from Contractor - - - - -
39201 -
Transfers from Other Funds - - - - -
0% -
Total Revenues 178,495 185,799 184,350 140,289 184,350
EXPENSES
Personal Services
101 -
Regular Salaries - 986 - - -
1020% -
O.T. Salaries 788 997 1,000 851 1,000
103-1% (79)
Part Time Salaries 4,307 3,223 5,330 3,153 5,251
121459-2% (9)
PERA City Share 353 368 272 450
122485-2% (10)
FICA City Share 388 388 302 475
1310% -
Ins. City Share - 219 619 234 619
151 -
Workers Comp - - - 190 -
Total Personal Services-1% (97)
5,836 6,181 7,892 5,002 7,795
Supplies
2000% -
Office Supplies 102 105 100 110 100
2080% -
Postage 1,211 1,176 900 1,062 900
2450% -
General Supplies 170 352 200 665 200
Total Supplies0% -
1,483 1,633 1,200 1,837 1,200
Other Services & Charges
4000% 324
Contractual 166,449 166,668 166,992 124,206 166,992
4407043% 7,888
Misc. Services 8,405 112 8,000 74 8,000
450-100% (241)
Service Charges - 241 - - -
Total Other Services & Charges0% 7,971
174,854 167,021 174,992 124,280 174,992
5%
TOTAL EXPENSES 182,173 174,835 184,084 131,119 183,987 (97)
REVENUES OVER/(UNDER) EXPENSES (3,678) 10,964 266 9,170 363
STORMWATER MANAGEMENT FUND
Revenue Coding: 631-
Expenditure Coding: 631-49600-
Requested
YTDPercent
ActualActualBudgetBudgetDollar
REVENUES
20102011201220122013ChangeChange
Grant Proceeds 5,202 - 5,100 - 5,100
336200% -
Special Assessments 7,651 6,957 - - -
36101 -
5,637 4,331 5,100 - 3,000
Interest Earnings
36210-41% (2,100)
Miscellaneous Revenue 122 - 75 - 75
362700% -
Cellular Antenna Revenue -
37175 -
Storm Utility Charges 190,819 189,012 200,500 144,534 200,500
374100% -
Transfers/Internal Loans - - - - -
39201 -
Total Revenues 209,431 200,300 210,775 144,534 208,675
-1% (2,100)
EXPENSES
Personal Services
Regular Salaries 17,816 34,739 28,478 30,843 28,478
1010% -
O.T. Salaries 158 163
102 -
Part Time Salaries
103 -
PERA City Share 1,186 2,543 2,242
1212,0652,0650% -
FICA City Share 1,287 2,632 2,352
1222,1792,1790% -
Ins. City Share 2,448 4,643 2,879 1,053 2,879
1310% -
Workers Comp - - - 666
151 -
22,737 44,715 35,601 37,319 35,601 2,879
Total Personal Services0%
Supplies
Office Supplies 102 105 109 100
200 100
Postage 1,211 1,176 350 946 1,000
208186% 650
Maint-Equipment - - 5,500 - 5,500
2210% -
Small Tools - - 300 - 300
2400% -
General Supplies 1,268 2,283 3,000 310 3,000
2450% -
2,581 3,564 9,150 1,365 9,900
Total Supplies8% 750
Other Services & Charges
Financial & Audit -
300
Engineering 8,384 23,869 5,000 1,811 5,000
3030% -
Legal 46 241 1,000 185 1,000
3040% -
Engineering - Design Stage 1,418 5,198 5,000 5,955 5,000
3130% -
Communication - - - - 500
321 500
Print/Publish - 324 100 64 100
3510% -
Insurance-Total -
360 -
Contractual 40,871 41,752 50,000 182,616 50,000
4000% -
Depreciation 19,833 25,250 20,000 - 22,000
42010% 2,000
Subscrip-Member - 600 - 600
4330% -
Misc. Services 1,748 117 1,100 935 1,100
4400% -
Service Charges 14 - 500 - 500
4500% -
72,314 96,751 83,300 191,566 85,800
Total Other Services & Charges3% 2,500
Capital Outlay
Land -
510
Other Improvements 33,475 88,004 36,187 -
580 -
Total Capital Outlay 33,475 88,004 - 36,187 -
-
TOTAL EXPENSES 131,107 233,034 128,051 266,437 131,301 6,129
3%
REVENUES OVER/(UNDER) EXPENSES 78,324 (32,734) 82,724 (121,903) 77,374