101308 CC WS AgPCITY OF SHOREWOOD
CITY COUNCIL WORK SESSION
MONDAY, OCTOBER 13, 2008
AGENDA
1. CONVENE CITY COUNCIL WORK SESSION
A. Roll Call
5735 COUNTRY CLUB ROAD
SOUTHSHORE CENTER
6:00 P.M.
Mayor Lizee
Woodruff
Turgeon
Bailey
Wellens
B. Review Agenda
2. ENTERPRISE BUDGET DISCUSSION (Att. -Finance Director's memorandum)
3. ADJOURN
CITY OF
SHOREWOOD
5755 COUNTRY CLUB ROAD •SHOREWOOD, MINNESOTA 55331-8927 • (952) 474-3236
FAX (952) 474-0128 • www.ci.shorewood.mn.us • cityhall@ci.shorewood.mn.us
MEMORANDUM
DATE: October 9, 2008
TO: Honorable Mayor and City Councilmembers ~ a
FROM: Bonnie Burton, Finance Director/Treasurer ~ J
Brian Heck, City Administrator ~'
RE: Enterprise Fund Budget Workshop: `~`
Work-session -Monday, October 13, 2008
Attached for your review are Year 2009 budget drafts for the City's Enterprise Funds. These documents
will be reviewed and discussed at the first Enterprise Budget work-session scheduled for Monday night.
The documents consist of budgets for the Water Operations and Water Debt Service; Sanitary Sewer
Fund; Stormwater Management and Recycling Funds.
Water Budget
The Water Fund budget is comprised of two parts: the Water Debt Service budget and the Water
Operating budget. The 2009 Water Debt Service budget includes principal and interest debt service
payments for the existing bond issues. The debt service payments are programmed at approximately
$382,000 and are paid by a transfer from the Water Operating budget.
The 2009 Water Operating budget revenues are projected at $727,000 while expenses including
depreciation are forecast at about $987,000. This amount includes capital expenditures of $149,000 for
the next (and final) phase of the Water Meter Radio Read project and the Boulder Bridge Well #2
inspection project.
In order for the Water funds to be self-supporting, to assure the system can provide for improvements,
and to preserve fund balance at stable levels, water rates are periodically reviewed and increased when
necessary. The current water rates are: $35 for up to 10,000 gallons; $2.95/1000 gallons for 10,000-
50,000 gallons usage; and $3.75/1000 gallons for 50,000+ gallons usage. There are currently about 1,428
water connections that use an average of 30,000 gallons per quarter.
is
~. M~' PRINTED ON RECYCLED PAPER
2009 Enterprise Budget Memo
Page 2
The City Council last year discussed possible changes to the rate structure that reduced the minimum
usage charge from 10,000 gallons to 5,000 gallons minimum. The contemplated changes would adjust
minimum rates, thereby benefiting seniors and other low-gallon users.
Sanitary Sewer Budget
The City currently has about 2,800 connections to its Sanitary Sewer System. Proposed operating
expenditures for year 2009 are programmed at approximately $1.2 million. This amount includes capital
improvements of approximately $237,000. In order to provide for a balanced budget, the Council should
discuss if a sanitary sewer rate increase is appropriate or if funds should be transferred from the sewer
reserves to accommodate the shortfall. The sewer rate is currently $70 per quarter and has not been
changed in 6 years. An increase of $3 per quarter per household would provide an additional $33,600 and
$5 per quarter would provide approximately an additional $56,000.
Information about the sanitary sewer flow in millions of gallons is provided to the City annually by
Metropolitan Council Environmental Services (MCES) for the period July I prior year to June 30 current
year. MCES determines the 2009 cost by calculating each city's share using a formula based on the last
actual known flows from the period July 1, 2007 -June 30, 2008. The MCES wastewater charge, which
is the amount the City must pay for wastewater processing will be $576,200 for Budget 2009. The
monthly processing charge does not include I & I surcharges, which MCES could impose.
The City expects to again be exempted in 2009 from the Inflow & Infiltration surcharge program that the
MCES implemented in 2007. However, to continue to be exempted from this program, the City will have
to be proactive regarding I & I mitigation and funds have been designated for this purpose.
Stormwater Management Budget
The Stormwater Management budget contemplates revenues of about $228,000 and expenditures of
approximately $643,000 for 2009, which include proposed capital expenditures of $555,000. The capital
outlay contemplated is for the Lake Mary outlet ($457,000) and Harding Lane Drainage ($97,000). If
these projects proceed as planned, there will be a net deficit in the Stormwater Fund. Discussion is
needed to determine how the council would like to proceed regarding funding of Stormwater
Management projects, including a possible rate increase from the current residential rate of approximately
$15 per quarter.
Recycling Budget
There are about 1,100 households monthly recycling an average of 90 tons per month. The 2009
Recycling budget expenditures are approximately $94,000, The City again anticipates receiving $21,000
from Hennepin County Grant Funds. In addition the revenue item `Charges for Services' is programmed
at $61,000 in recycling fees annually. Expenditures include the City's recycling obligation based on the
Veolia contract and $10,000 for City clean-up. Every effort is made to recover costs through collection
site fees however the City may have to subsidize a portion of this program. In order to do so, a slight rate
increase may be necessary and Council may wish to consider a change from $1.75 per household to $2.75
per month per household. This $1.00 per month rate increase will generate an additional $33,000
annually and should be adequate to offset the increased costs for recycling and clean-up activity.
Conclusion
We invite your response and comments on the revised Enterprise Budgets. Please advise if you would
like additional information or if we can be of further assistance prior to the work-session discussions.
CITY OF SI-30IZEW®OD®
MINNESOTA
DRAFT
2009 WATER DEBT SERVICE BUDGET
October 2008
FUND: Water
SUBFUND: Water Debt Service
FUND NO: 601
DESCRIPTION OF ACTIVITY:
MISSION:
To pt•ovide for the retirement of
debt incurred to construct water
system improvements.
Responsible for the accumulation of resources for the retirement of Water Fund debt, and
for the periodic payment of principal and interest.
OBTECTIVES:
To assure adequate resources to retire debt as scheduled, or more quickly if prudent.
HIGHLIGHTS/COMMENTS:
Revenues:
Special Assessments on Water Improvements
Connection Charges
Interest Income
Transfers from Water Operating Fund
Expenses:
Staffing:
Supplies/Materials:
Support Services:
Charges & Fees:
Capital Outlay:
Other:
Debt service payments -Principal and interest
Fiscal Agent Fees
2
FUND: X601
BUDGET
ITEM FUND: Water -Debt Service
Actual Actual
2006 2007
Budget
2008
YTD Aug
2008 DEPT '~ 49400
Proposed Adopted
2009 2009
REVENUE
Sp Assess/Connect Chgs b63,633 96,710 105,000 82,066 90,000 0
Misc. Revemie 61,926 91,387 40,000 37,179 40,000 0
Transfers 0 0 260,000 0 350,000 0
TOTAL REVENUE 725,559 188,096 405,000 119,245 480,000 0
EXPENSES
Staffing 0 0 0 0 0 0
Supplies/Materials 0 0 0 0 0 0
Support Services 0 0 0 0 0 0
Charges & Fees 0 0 0 0 0 0
Other -Debt Service 373,955 427,050 388,000 319,874 381,500 0
Capital Outlay 0 0 0 0 0 0
Transfers 0 0 0 0 0 0
TOTAL EXPENSES 373,955 427,050 388,000 319,874 381,500 0
SERVICE INDICATORS
Outstanding Debt, Year End 3,920,000 3,665,000 3,410,000 3,665,000 3,415,000 3,415,000
CASH FLOW IMPACT:
Beginning Cash Balance 687,641 1,039,245 800,291 1,039,245 838,616 838,616
Revenues 725,559 188,096 405,000 119,245 480,000 0
Expenditures (373,955) (427,050) (388,000) (319,874) (381,500) 0
Ending Cash Balance 1,039,245 800,291 817,291 838,616 937,116 838,616
STAFFING
3
CIT'E' ®F S®IZEVV®®I~®
:IVIINNES®rTA
I~R1,F~'
2009 ~T1~T'EI~ ~PEIZI~TIN~ PLTI~GE'I'
October 2008
FUND: Water
SUBFUND: Water Operations
MISSION:
To provide a safe, clean, uninterrupted
supply of drinking water to all City
residents corulected to the City water system.
FUND NO: 601
DESCRIPTION OP ACTIVITY:
Responsible for operation and maintenance of seven (7) well systems, including all pumps and well houses, maintenance of water tower
and treahnent plant, and extension of new watermain and construction of new water facilities, as necessary.
OBTECTIVES:
- Supply a safe, clean uninterrupted source of water to all connections
- Explore possibility of intercoruiecting with other communities
HIGHLIGHTS/COMMENTS:
Revenues:
Estimated water sales based on quarterly billing at a tiered rate of $2.95 - $3.75/1,000 gallons
Corulection and permit revenues
Miscellaneous Income includes interest income and Cellular Antenna Space Rentals
Expenses
Staffing:
.15 Dir of Public Wks
.25 Engineering Technician
.15 Utility Lead Person
.75 Utility Operator
.06 Senior Accounting Clerk
.05 Receptionist/Secretary
Supplies/Nlateri als:
Office Supplies, including billing Eonns and postage
Maintenance contracts for computer hardware and software
Maintenance of gate valves
Small tools and chemicals for water treatment
Support Services & Charges:
Engineering
Water Operations Licenses & Training
Insurance on water system
Water testing & Water Quality Reporting
Capital Outlay:
Radio Read Meter project-($125,000 - 2009)
Boulder Bridge Well 2 -Pull & Inspect ($24,000 - 2009)
Other:
Water Purchased from other communities
Meter purchases
Well utility charges
Transfers to Water Debt Service Fund
Depreciation (Non-cash expense accounts for future system replacement)
6
FUND: #601 FUND: Water Operations DEPT x 49400
BUDGET Actual Actual Budget YTD Aug Proposed Adopted $$
ITEM 2006 2007 2005 2005 2009 2009 Change Change
REVENUE
Charges for Service 555,112 666,597 553,500 227,506 5S2,000 0 i, `.:'~ii~; -0.26`%
Bond Proceeds 1,402,5S5 396 0 0 0 0 0 #DIV/0!
Misc. Revenue 163,215 193,OOS 130,000 79,030 145,000 0 15,000 11.54%
TOTAL REVENUE x,150,915 560,301 713,500 306,537 727,000 0 13,500 1.S9%
EXPENSES
Staffing 75,163 56,677 109,659 54,759 114,996 0 5,337 4.S7`%
Supplies/Materials 53,323 52,757 76,625 55,325 71,350 0 t:~.?%`~? -6.SS
Support Services & Charges 94,756 123,233 96,425 74,120 100,100 0 3,675 3.51%
Capital Outlay 0 0 356,000 15,257 149,000 0 i_' ~,-,ilii~ -61.40%
Transfers 0 310,000 260,000 0 350,000 0 90,000 34.62%
Depreciation 184,105 201,790 155,000 135,472 202,000 0 17,000 919%
TOTAL EXPENSES 407,345 774,456 1,113,709 337,966 987,446 0 s7._;t; ~i-3~ -11.34%
SERVICE INDICATORS:
Miles of Water Line 16 16 16 16 16
No. of Connections 1,252 1,255 1,255 1,255 1,255
No. of Hydrants 272 2S0 2S0 230 230
Annual Gals Wtr Pumped* 175,000,000 185,509,000 iSS,509,000 188,509,000 185,509,000
Avg Daily Consump- gals 479,452 516,463 516,463 516,463 516,463
Water rate/1000 gals 2.95/3.75 2.95/3.75 2.95/3.75 2.95/3.75 2.95/3.75
CASH FLOW IMPACT:
8egituling Cash Balance 2,356,223 2,693,605 2,693,605 2,693,605 2,939,760
Revenues 2,150,915 560,301 713,500 306,537 727,000
Expenditures (407,343) (774,456) (1,113,709) (337,966) (957,446)
Depreciation 184,105 201,790 155,000 135,472 202,000
Construction of Infrastructure -
Other Cash Flow Impacts (1,590,288) (41,482) 0 0 0
Ending Cash Balance 2,693,608 2,939,760 2,478,399 2,797,650 2,851,314
STAFFING:
Dir. of Public Wks - - .15 .15 .15
City Engineer - - - - -
Engineer Technician .O8 .25 .25 .25 .25
Utility Lead Person .14 - .15 .15 .15
Utility Operator .77 1.15 .75 .75 .75
Acctg. Clerk .085 .125 .O6 .06 .06
Sec. JRecep. .100 .10 .05 .05 .05
* Source: Annual DNR reports
7
City of ~horewood,lVlinnesota
C~tpitctl hrapr~oz~~t~len~ Progt'c1t~31.
200 thru 2012
Department Project# Priority 2008 2009 2010 2011 2012 Total
Municipal tiVater System
Amesbury Well Controls Replacement W-07-03 nla 55,000 55,000
Water Meter Radio Read Project W-07-05 n/a 75,000 125,000 200,000
SE Area Water Tower -painting W-08-01 nta 275,000 275,000
Amesbury Lineshaft Well -Pull & Inspect W-08-02 n!a 23,000 23,000
Woodhaven Well Bldg Demolition W-08-03 nla 18,000 18,000
Boulder Bridge Well #2 -Pull 8 Inspect Nl-09-Oi n!a 24,000 24,000
Municipal ~Tater System'Total 446,000 149,000 595,000
~IR~~1'~D '~®`~'~1L 446,000 149,000 595,000
7'hrrrcdrn', J'eptiwrDi~r l 1. 'I1li~S
8
CITY ®F SI-I®IZEW~I~,
IVIINNES®TA
DRAFT
2009 SAl®TITARY SEWER BUDGET
October 2008
FUND: Sanitary Sewer
SUBFUND: Sanitary Sewer
MISSION:
To provide a safe, sanitary sewer
service to all City residents
DEPT NO: 611
DESCRIPTION OF ACTIVITY:
Major activities include maintenance of fourteen (14) lift stations, and cleaning, televising and repairing sewer mains to
control inflow and infiltration. Sewage treatment is performed by Metropolitan Council Environmental Services (MCES)
and is provided for in this area.
OBTECTIVES:
- Work with MCES to monitor inflow and infiltration into the sanitary sewer system
- Refurbish two lift stations per year
HIGHLIGHTS/COMMENTS:
Revenues:
Quarterly Sewer service charges at $70.00 per quarter
Interest revenue from investment of Sewer Fund cash balances
Repayment of Interfund Loans
Expenses
Staffing:
.15 Dir of Public Wks
.25 Engineering Technician
.10 Utility Lead Person
.53 Utility Operator
.10 Senior Accounting Clerk
.05 Receptionist/Secretary
Supplies/Materials:
Office Supplies, including billing forms and postage
Maintenance contracts For computer hardware and software
Support Services:
Sewer Main Cleaning
Inflow & Infiltration Control
Insurance on sewer system
Legal & engineering services
Utilities
Travel & seminars
Charges & Fees:
Charges Eor seavage flow into City of Excelsior trunk mains
Metropolitan Council Environmental Services sewage treatment charges -per MCES
Capital Outlay:
Reftrbish Lift Stations 15 (construction stage) & L.S. 17 (design stage) - 2009
Inflow & Infiltration Reduction
Transfers In (2009):
Residential Property purchase debt service payment (Genl Fnd): $60,000
Depreciation (Non-cash expense accounts for future system replacement)
10
FUND: ~ 611
BUDGET
ITEM FUND: Sanitary Sewer
Actual Actual
2006 2007
Budget
200S
YTD Aug
2005
Proposed
2009
Adopted
2009 DEPT # 49450
$$ %
Change Change
REVENUE
Charges Eor Service 991,659 1,046,199 950,500 482,326 937,550 0 E _.-~:St:i ~ -1.36%
Transfers 0 112,500 60,000 0 60,000 0 0 0.00`%~
TOTAL REVENUES 991,659 1,158,699 1,010,500 482,326 997,550 0 (i ';`~:~Ci~ -1.28"/°
EXPENSES
Staffing 46,260 85,257 90,236 57,841 94,638 0 4,402 4.88%
Supplies/Materials 17,864 11,559 14,100 6,052 30,600 0 16,500 117.02%
Support Services & Charges 517,448 645,152 639,282 382,074 641,216 0 1,934 0.30%
Capital Outlay 0 0 299,000 46,104 237,000 0 (~'...!'U) -20.74"/°
Transfers 0 0 0 0 0 0 0 ~YDIV/0!
Depreciation 204,064 210,138 205,000 124,365 205,000 0 0 0.00`%
TOTAL EXPENSES 785,636 952,107 1,247,618 616,435 1,208,454 0 i 3~}. i ~-? i -3.14%
SERVICE INDICATORS:
Miles of Sewer Line 65 65 65 65 65 65
No. of Connections 2,824 2,824 2,824 2,824 2,830 2,830
No. of Lift Stations 14 14 14 14 14 14
Flow (Mill. Gals.) 7/1 - 6/30 299.52 375.81 322.89 328.4b N/A
CASH FLOW IMPACT:
Beginning Cash Balance 3,550,499 3,958,626 4,387,059 4,387,059 4,354,941 4,354,941
Revenues 991,659 1,158,699 1,010,500 482,326 997,550 0
Expenditures (785,636) (952,107) (1,247,618) (616,435) (1,208,454) 0
Depreciation 204,064 210,138 205,000 124,365 205,000 0
Other Cash Flow Impacts (1,959) 11,703 - - - -
Ending Cash Balance 3,958,626 4,387,059 4,354,941 4,377,315 4,349,037 4,354,941
STAFFING:
Dir of Public Wks - - .15 .15 .15
Engineer. Technician .13 .25 .25 .25 .25
Utility Lead .07 .25 .10 .10 .10
Utility Operator .29 .67 .53 .53 .53
Sr. Acctg. Clerk .087 .025 .10 .10 .10
Receptionist/Secretary .12 .05 .05 .05 .05
City of Shorewood, Minnesota
CC1~71CC1~ j/121~7'O1'L'711E'7lt Pt'U~3"Cl/]I
2008 thru 2012
~~~.~~~~'~ ~~ ~~~~R,'~'I9~~EI~t'lt'
i~epartment Pro.ject# Priority 2005 2004 2010 2011 2012 Total
Sanitary Sewer
Lift Station 12 Rehab-5705 Christmas Lake Pt. SS-08-01 nla 110,000 110,000
Lift Station 16 Rehab-4915 Shady Island Rd SS-08-02 nla 104,000 104,000
Portable Lift Station Control Panel SS-08-03 n/a 7,000 7,000
Lift Station 15 Rehab-4360 Enchanted Dr. SS-08-O6 n!a 21,000 179,000 200,000
Lift Station 17 Rehab-5295 Shady Island Rd SS-09-O1 nla 8,000 70,000 78,000
Annual Lift Station Inspect R Rehab SS-1 i-03 n/a 25,000 25,000 25,000 25,000 25,000 125,000
Infiltration and Inflow Reduction SS-1i-05 nia 50,000 50,000 50,000 50,000 50,000 250,000
Sanitary Sewer Total
~I~1~1~ T®T~3.
317,000 262,000 145,000 75,000 75,000 874,000
317,000 262,000 145,000 75,000 75,000 874,000
7hnrs~lgr, Se~u~-ether t 1, 't)r6e
12
CI'T'Y ®~ SI-I®IZE~IT®®I~,
11~IINNES®T'1~
DRAFT
2009 RECYCLING BUDGET
October 2008
13
FUND: Recycling MISSION:
To provide weekly pickup of recyclables
SUBFUND: Recycling to all City residents; provide for the annual
City Clean-up activities
FUNDNO: 621
DESCRIPTION OF ACTIVITY:
Weekly pick-up of newspaper, corrugated cardboard, recyclable plastics, glass and
metal, and other recyclable materials. Includes annual City community clean-up at a drop-off site.
OBTECTIVES:
- Continue weekly pickup of recyclable materials
-Hold City community clean-up in the Spring of the year
- Provide a Leaf and yard waste disposal site in Fall of the year
HIGHLIGHTS/COMMENTS:
Revenues:
County Aid is a Herulepin County grant
Charges for Service includes City Clean-up fees and a
City Recycling Fee of $1.75 per month per household
Tranfers/other includes transfers, interest income and revenue sharing from the Recycling Contractor
Expenses:
Staffing:
Miscellaneous staffing for City Clean-up and Yardwaste Disposal
Supplies/Materials:
Office Supplies
Support Services:
Recycling contract with Veolia Recycling ($2.50/household/month for 2,800 households - 2009)
City Clean-up costs (Est. $10,000 - 2009)
14
FUND: #621 FUND: Recycling
BUDGET Actual
ITEM 2006
Actual
2007
Budget YTD Aug Proposed
2005 2005 2009
Adopted
2009 DEPT # 49550
$$ %
Change Change
REVENUE
County Aid 20,971 20,631 21,000 0 21,000 0 _ . „ -100.00%
Charges for Service L3,3S3 6S,92S 74,000 25,392 b1,000 0 i>-f,0i1(1; -100.00%
Transfers/other 2,735 4,536 2,450 2,214 2,450 0 ',3>~:?; -100.00`%
TOTAL REVENUE & 147,092 94,095 97,450 27,606 54,450 0 +,~~', €=,i;; -103.57%
OTHER SOURCES
EXPENSES
Staffing 0 0 0 1,110 0 0 0 #DIV/0!
Supplies/Materials 164 0 500 2S2 500 0 ! ~i+'t -100.00`%
Support Services & Charges 124,189 91,157 99,175 65,124 94,175 0 ~,'~~ ', :- -100.00`%
CapitalOutiay 0 0 0 0 0 0 0 #DIV/0!
Transfers 0 0 0 0 0 0 0 #DIV/0!
TOTAL EXPENSES 124,354 91,157 99,675 66,515 94,675 0 -109.34"'/0
SERVICE INDICATORS:
Est. Avg. mo. Participant Hshld 1,100 1,100 1,100 1,100 1,100 1,100
Avg. mo. Tonnage* 90 - - - 90 90
CASH FLOW IMPACT:
Beginning Cash Balance 61,905 53,554 94,646 94,646 94,646 94,646
Revenues 147,092 94,095 97,450 27,606 84,450 0
Expenditures (124,354) (91,157) (99,675) (66,515) (94,675) 0
Other Cash Flow Impacts (1,090) 5,155
Ending Cash Balance 83,554 94,646 92,421 55,737 54,421 94,646
* Annual Recycling Tonnage Reported:
2001 - 965 tons
2002 - 1,005 tons
2003 - 1,206 tons
2004 - 1,093 tons
2005 - 762 tons
2006 - 597 tons
2007 - 919 tons
2005 - Y"I'D 666 tons
15
16
CITY ®~' S OIZEW®OD,
MINI~ESOT1~
DRAFT
2009 ST®RIVIWATER BUDGET
October zoos
17
FUND: Stormwater Management
SUBFUND: Stormwater Management
FUND NO: 631
DESCRIPTION OF ACTIVITY:
MISSION:
To provide proper surface water and
ground water management throughout the City.
Activities include maintenance of storm sewer system, including cleaning of catch basins,
dredging of drainage ditches and retention ponds, and minor repairs to system problem areas.
Provides partial fimding for larger subwatershed drainage projects.
OBTECTNES:
To build and maintain a stable fund balance in order to be able to fund needed projects and
to facilitate council priorities.
HIGHLIGHTS/COMMENTS:
Revenues:
Stormwater Management Utility Charges - The current residential rate is approximately $15 per quarter.
Misc. Revenue includes interest income and other misc. revenue
Expenses:
Staffing:
.15 Dir of Pub Wks
.05 City Engineer
.25 Engineer Technician
.05 Senior Accounting Clerk
.18 Light Equipment Operator (LEO)
Supplies/Materials:
Drainage Correction/Maintenance Materials
Support Services:
Engineering
Contractual Services for drainage correction
Contractual Services
Contractual Services for seasonal pumping expense as needed ($10,000 - 2009)
Debt Service:
Capital Outlay: $555,000 budgeted in 2009 for Lake Mary and Harding Lane Road Construction
18
FUND: #631 FUND: Stormwater Management Utility DEPT # 49600
BUDGET Achial Actual Budget YTD Aug Proposed Adopted $$
ITEM 2006 2007 2008 2008 2009 2009 Change Change
REVENUE
Grant Proceeds 0 0 0 4,748 0 0 0 #DIV/0!
Special Assessments 0 0 0 0 0 0 0 #DIV/0!
Charges for Service 69,177 164,347 218,000 99,027 218,000 0 0 0.00`/~
Misc. Revenue 72,323 14,579 10,000 7,532 10,000 0 0 0.00%
Transfers 25,000 41,049 0 0 0 0 0 #DIV/0!
TOTAL REVENUE & 166,500 219,975 228,000 111,306 228,000 0 0 0.00'%
OTHER SOURCES
EXPENSES
Staffing 10,193 26,707 47,880 9,616 50,414 0 2,534 5.29°!~
Supplies/Materials 1,871 750 6,700 2,633 8,800 0 2,100 31.34%
Support Services 62,566 33,965 79,100 62,514 28,600 0 -',_~;}'' -63.84%
Charges & Fees 0 0 0 0 0 0 0 #DIV/0!
Other -Debt Service 4,438 2,466 0 0 0 0 0 #DIV/0!
Capital Outlay 90,056 0 100,000 0 555,000 0 455,000 455.00%
Transfers 0 52,500 0 0 0 0 0 #DIVJO!
TOTAL EXPENSES 169,125 116,387 233,680 74,763 642,81.4 0 409,134 175.08%
CASH FLOW IMPACT:
Beginning Cash Balance 300,316 275,950 322,116 322,116 316,436
Revenues 166,500 219,975 228,000 111,306 228,000
Expenditures (169,125) (116,387) (233,680) (74,763) (642,814)
Other Cash Flow Impacts (21,741) (57,422) 0 0 0
Ending Cash Balance 275,950 322,116 316,436 358,660 (S~`?,3:"s
STAFFING:
Dir of Pub Wks - - - 0.0 .15
City Engineer - - - .045 .05
Engineer Technician .07 - - .21 .25
Lt. Equip. Oper./Foreman .00 .10 .10 .0 .18
Sr. Acctg. Clerk .085 .05 .05 .05 .05
19
City of Shorewood, Minnesota
Cupitctl ~irip~~•oi~e~~ale~zt 1P~•ogf-cz~•n
Zoos tflfll Zo1.2
PROJECTS BY DEPARTMENT
Department Project# Prioritti~ 2008 2009 2010 2011 2012 Total
Stormwater Management ~
Harding Lane Drainage STM-09-01 1 97,000 97,000
Lake Mary Outlet STM-09-02 1 457,000 457,000
Meadowview Rd Storm STM-10-01 3 15,000 15,000
Nelsine Dr Drainage STM-10-02 1 16,000 16,000
6180 Murray Drainage STM-10-03 1 36,000 36,000
5925 Grant Drainage STM-10-04 1 49,000 49,000
Stratford PI Drainage STM-11-01 1 30,000 30,000
Star Circle Storm STM-11-03 3 89,000 89,000
RampartCt. Drainage STM-11-04 1 8,000 8,000
Lake South Auto Drainage STM-11-05 1 21,000 21,000
5830 Echo Rtl Drainage STM-11-O6 1 33,000 33,000
6180 Chaska Rd Drainage STM-11-07 1 4,000 4,000
Boulder Bridge Lift Station STM-12-01 nla 243,000 243,000
Valleywood Rd. Drainage STM-19-03 1 45,000 45,000
Stormwater Management Total 554,000 116,000 185,000 288,000 1,143,000
GRAND T®TAL 554,000 116,000 185,000 288,000 1,143,000
7'{ttrretlrn'. Ocfobcv' (PJ, 'OUb~
20