2004 - Annual Budget Report
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
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
CITY OF SHOREWOOD,
MINNESOTA
2004 ANNUAL
OPERATING BUDGET
ADOPTED DECEMBER 8, 2003
ft .
. ~J PRINTED ON RECYCLED PAPER
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
CITY OF SHOREWOOD
2004 ANNUAL OPERATING BUDGET
TABLE OF CONTENTS
PAGE NO.
INTRODUCTION
Budget Message ............................. ............ ...................................... ............... ..... 1-4
SUMMARY INFORMATION
Budget Schedule................ ............. .............. ...... ....................... ......... ..................... 5
Organization Chart.................................................................................................. 6
Newsletter Insert: December 2003 Shore Report.................................................... 7
Truth- In-Taxation Published Notice ....... ............. ....... ............. ....... ........ ................ 8
GENERAL FUND
General Fund Description ........ ...... ............ ..................... ....... .......... .......... ............. 9
General Fund Budget Summary .......................................................................10-11
General Fund Revenue Summary .............. ........ .............. ............................ ..... 12-14
General Fund Expenditure Summary ...............................................................15-17
Mayor and Council............... ............................ ..... ....... .................... ................ 18-19
Administration.................................................................................................. 20- 21
General Government/City Clerk .... ............... ............ ....... .............. ............ ......22-23
Elections........................................................................................................... 24- 25
Finance............................................................................................................. 26- 27
Professional Services........................................................................................ 28-29
Planning and Zoning .............. ................. ......................... ............ ....... ............. 30-31
Municipal Building - City Hall .... ........ ........................ ........... ...... ..... .............. 32-33
Police................................................................................................................ 34-35
Fire Protection......... ........................... ........... ......... .......... ................... ..... ........36-37
Protective Inspection .. .... .... ... ........................ ....... ........ ............... ............ .... .....38-39
Animal ControL................................................................................................ 40-41
City Engineer ..... ............................... ...... ................. ........... .................. ............42-43
Public Works Service ............................... ....................... ......... ................. .......44-45
Streets and Roadways..................... .......... ......... ...................... ............ .............46-47
Snow and Ice Removal.......... ....... ......... ............. ..... ........... ............ ...... ............ 48-49
Traffic Control/Street Lighting.. ....... .............. ........... ..... ...... ................. ..........50-51
SanitationIW aste RemovallW eeds ... ..................... ......................... .......... ........52-53
Tree Maintenance.................. ........... ..................... ..... ................. ...... ...... ......... 54-55
Parks and Recreation............... ...................... .................. ........... ....... ............... 56-57
DEBT SERVICE
Debt Service Fund Description.. ............. ......... .......... .............................. ...... ....... 59
Schedule of Bonds Payable ................................................................. .................. 60
Bond Rating Information.;................................................................................ 61-63
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
TABLE OF CONTENTS (Continued)
CAPITAL PROJECTS
Capital Projects Funds Description ............... ........... ........... ................. ................. 65
Category Summary By Department......... ........ ....................... ...... ......................... 66
Projects By Department.... ...................... ........... ............ ..................... .............. 67 -69
Projects By Department and Category ............................................................. 70-72
Projects By year..... ...... .................................. ...~ ................. ........ .....................73-75
ENTERPRISE
Enterprise Fund Descriptions... ..... ........ .................... ............. ...... ........ ....... .......... 77
Water Operations.... ............. ................ ....... ..... ......... ......... .... ............ ....... ........ 78-79
Water Debt Service ............. ............. ...... ........................................ .... ........ ...... 80-81
Sewer................................................................................................................ 82-83
Recycling.......................................................................................................... 84-85
Stormwater Management... ............. ....... ..... ............... .......................... ............86-87
Liquor Operations Summary...... ...... ......... ....................... ..... ...... ............. ........ 88-89
GLOSSARy.......... ............ ...... ............... ........ .................................. ..... ......... .............91-93
APPENDIX
General Fund Detailed Budget ............... ....... ......... ............................. ...........95-135
Enterprise Fund Detailed Budgets................................................................ 137-166
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
CITY OF
SHOREWOOD
5755 COUNTRY CLUB ROAD. SHOREWOOD, MINNESOTA 55331-8927. (952) 474-3236
FAX (952) 474-0128. www.cLshorewood.mn.us. cityhall@ci.shorewood.mn.us
January 2, 2004
Honorable Mayor and City Council Members
Residents of the City of Shorewood
INTRODUCTION
We are pleased to present to you the City of Shorewood 2004 Annual Operating Budget. This
document, after adoption by the City Council, becomes the guide for the delivery of services to
the residents of the City in the coming year. The budgets anticipate the level of funding
necessary to provide these services.
The budget requests herein are the result of careful consideration by staff, guided by the direction
of the City Council at its budget work-sessions in June, August, and October. Shorewood
provides essential services at a very reasonable cost, with a lean budget and small staff. Staff
members perform at a high level with economy and efficiency; professional staff consistently
spends countless extra hours to meet and exceed the high expectations of performance.
2004 GENERAL FUND BUDGET HIGHLIGHTS
Levy Limitations
As the Council is aware, the City is again subject to levy limits for Pay2004. Accordingly, the
City is able to raise the levy by an amount equivalent to 60% of the lost state aids (LGA and
MVHC). For the City of Shorewood, this is an increase of about $56,000 or 1.96%, from the
Pay2003 levy of $2,851,847 to a Pay2004levy of $2,907,997. The proposed budget recommends
that the Council levy the maximum permitted by state law under levy limits.
The City is permitted to add a "special levy" to accommodate the debt service payments that will
be made annually to fund the new public safety buildings. For 2004, Shorewood's share of this
special levy amount is estimated to be $512,232 (the Pay2003 special levy was $304,500.) Thus,
the total proposed Pay2004levy is $3,420,229. In addition to the levy, the 2004 budget also
contemplates other sources of funding such as fees, licenses, and permits.
Expenditure Highlights
The 2004 Proposed General Fund Budget is $3,921,947, which is an increase of approximately
5.5% from the $3,719,072 budgeted in 2003. Most of the changes in the 2004 budget will be
incremental for the continuing cost of doing business. The significant changes in the proposed
#"
~J PRINTED ON RECYCLED PAPER
1
Budget 2004 Transmittal Letter
Page 2 of 4
2004 budget are almost exclusively attributable to Police and Fire Department increases for the
public safety building debt service requirements.
In addition, the following general economic adjustments have been factored into the Proposed
2004 budget: scheduled pay plan increases including 1.5% cost-of-living increases in January
and July and appropriate employee 'step' increases per the City salary charts; and health
insurance increases of approximately 12%.
EFFORTS TO ECONOMIZE
The Pay 2004 Budget reflects efforts to economize where able. For example, cost-of-living
adjustments for 2004 are planned at a reduced rate of 1.5% instead of the customary 2%, which
is a savings of $8,000; the Council contingency reductions will save $10,000; the City
participated in a shared purchase of paver equipment with other area cities for an estimated
savings of $8,000. The Council reviewed several other areas of potential economization at their
budget work-sessions and noted that General Government 2004 expenditures were scheduled to
increase by barely 1 %.
ENTERPRISE FUND HIGHLIGHTS
Water Fund
The Water Fund budget is comprised of two parts: the Water Operating budget and the Water
"Debt Service budget. The 2004 Water Debt Service payments for the two existing bond issues
are scheduled at approximately $265,000 and will be paid for by a transfer from the Water
Operating budget.
The 2004 Water Operating budget revenues are projected at $1,324,200 and the expenses
(including depreciation) are forecast at $1,438,804. This results in a shortfall, or deficit, of about
$114,604. Proposed capital expenditures include the Woodhaven Well Interconnection
($140,000), the Badger Well House Reconstruction ($480,000), the Water Meter Radio Read
project (Year 1 of 3 - $70,000), SE Area Water Tower Painting ($50,000) and installation of the
SE Area Well VFD ($18,000) and Amesbury Polyphosphate System ($12,000). Water Revenue
Bonds are the proposed funding source for the improvements, which are estimated at $800,000.
In order for the Water Funds to be self-supporting, to assure the system can provide for
improvements and enhancements, and to preserve fund balance at current levels, a water rate
increase was necessary in 2003. At the budget workshop last year, Council may recall that staff
suggested a three-year step approach to water rate increases, and Council concurred at that time.
Based on that approach, the 2004 scheduled increase would change the base rate from $25 to $30
for up to 10,000 gallons; from $1.95/1000 gallons to $2.95/1000 gallons for 10,000-50,000
gallons; and from $2.75/1000 gallons to $3.75/1000 gallons for 50,000 + gallons usage. There
are currently approximately 1,200 water connections that use an average of 30,000 gallons per
quarter. The adopted 2004 increase will generate and additional $95,000-100,000 in annual
revenue and the average quarterly bill (30,000 gallons) will increase from about $65 per quarter
to $89 per quarter.
2
I
I
I
I
I
I
I
I
I
I
"I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
Budget 2004 Transmittal Letter
Page 3 of4
Sanitary Sewer Fund
The City currently has about 2,800 connections to its Sanitary Sewer System. Proposed
operating revenues and expenditures for year 2004 are contemplated at approximately $870,000.
In addition, capital improvements of approximately $121,500 are planned. Capital
improvements for year 2004 include refurbishment of Lift Stations 8 and 15. In addition, funds
have also been designated for Inflow & Infiltration Control and Reduction projects ($25,000).
The Sanitary Sewer Fund has a substantial fund balance that has enabled it to be used to help
fund projects such as the Gideon Glen land acquisition. This loan is being repaid on schedule
from the Stormwater Management Fund. Council will recall that a sewer rate increase was
implemented during 2003. Staff is not recommending any additional rate increases at this time.
Storm water Management Budget
The 2004 Stormwater Management Budget contemplates revenues and expenditures of about
$361,000. This includes operations and debt service payments for the Gideon Glen land
acquisition. Capital improvement projects anticipated include the Gideon Glen Drainage Project
($183,300) to be funded with grant proceeds and by the MCWD; Boulder Bridge Storm Lift
station improvements ($82,800) to be funded with special assessments; and the Glen Road
Drainage Improvement project. The Council will recall that a small increase in rates was
implemented for 2003. Staff is not recommending any additional rate increases at this time.
Recycling Budget
The Recycling Budget draft contemplates revenues and expenditures of about $117,480. The
City will receive $21,640 from Hennepin County Grant Funds, which is a slight reduction due to
funding cuts in this program. Council will recall that the rate the City charged was increased
slightly for 2003 to keep pace with the contract increase with EZ Recycling (now $2.25 per
household.) We note that the number of households participating in the recycling program
remains stable at about 1,100 households per month. Staff is not recommending. any additional
rate increases at this time.
Liquor Operations
For the first time in a several years, the Liquor Operations has a surer sense of the future of its
liquor stores. The City optimistically anticipates reasonable profit levels at its two current
operating stores. The Liquor Committee has reviewed the Liquor Operations budgets and the
committee recommends approval of the budgets by the City Council.
Waterford (Store No. 1)
During 2003, the City was successful in substantially reducing the lease rental rates and this store
is forecasted to show a small operating profit for 2004.
Shorewood Plaza (Store No.2)
Lastly, during the coming year, the Shorewood Plaza location should be positively impacted by
its recent relocation within the mall and the completion of the Cub store. Business at this store
declined by 28-33% during construction this year; however staff anticipates a strong fourth
quarter 2003. The 2004 budget for this store reflects an expected return to profitability. Capital
improvements for this store include inventory software and hardware upgrades ($20,000).
3
Bonnie Burton
Finance Directorffreasurer
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
Budget 2004 Transmittal Letter
Page 4 of 4
Tonka Bay I Smithtown Store (Store No.3)
As Council will recall, the Tonka Bay store closed on November 30, 2002. City staff, with the
approval of the Liquor Committee, initiated discussions with the owners of the Oasis gas station
(located across the street from the current Tonka Bay store) to discuss building a liquor store
there. Early discussions are encouraging, however staff has concluded that a marketing
feasibility study should be undertaken in early 2004 to ascertain if an adequate market exists to
justify a third store. Accordingly, $20,000 has been budgeted for this study.
CONCLUSION
The 2004 Proposed Budget and levy were prepared according to the priorities and direction from
the City Council. Staff believes the budget allocates the resources necessary to continue to
provide quality services to the residents of Shorewood.
Respectfully submitted,
4
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
CITY OF SHOREWOOD
Year 2004 Budget Schedule
Date Descrivnon
06/23/03 CIP Budget work-session (Council and Staff)
07/15/03 Budget worksheets distributed to staff and department heads.
07/25/03 Completed budget worksheets due from staff.
07/28/03 CIP Budget work-session (Council and Staff)
08/11/03 General Fund Operating Budget draft work session (Council and Staff)
08/22/03 Preliminary budget completed.
08/25/03 Regular city council meeting.
08/30/03 Levy limit notification due to cities from state.
09/08/02 Regular city council meeting. Council adopts 2004 preliminary budget and levy.
09/15/03 Proposed budget and levy must be adopted and certified to County Auditor
by this date. State form Payable 2003 PT Form 280 also to be submitted.
10/27/03 Enterprise fund budget work-session (Council and staff)
11/20-11/24 Counties to mail Notice of Proposed Property Tax by this date.
11/26/03 Budget hearing advertisement published in the official newspaper.
12/01103 City initial budget truth-in-taxation hearing.
12/08/03 If required, the continuation budget truth-in-taxation hearing to be held on this date.
12/08/03 Regular city council meeting. Final budget and levy to be adopted.
12/29/03 Final levy and budget must be certified to the County Auditor by this date. State
forms Payable 2003 Property Tax Levy Report and PT Fonn TNT2003 also due.
5
CITY OF SHOREWOOD ORGANIZATION CHART
CITY COUNCil
en
ACCOUNnNG
CLERK
Personnel / HR
Accounting
Payroll
Investments
Utility Billing
Accts. Payable
Accts. Receivable
Special Assessments
Budgeting
MIS
Purchasing
-
UQUOR
STORE
MANAGERS
UQUOR
STORE
SALES CLERKS
Off-Sale Retail
RECEPnONIST/
PARK SECRETARY
COMMUNICAnONS
TECHNICIAN
General Government
Ucenslng
Elections
Records
legal Publications
Public Information
Coble TV Franchise
CONTRACTED SERVICES
ASSESSOR--.............HENNEPIN COUNTY
RECVCUNG.--m....-.---EZ RECVCUNG
ANIMAL CONTROL-------ClTY OF ORONO
ANIMAL IMPOUND--------PAWS. CLAWS Be HOOVES
ARE (lslands)--..-------MOUND
-
-
-
-
-
-
-
-
CITY ATTORNEY
SECRETARY/
RECEPTIONIST
-
ADVISORY BOARDS
PARK COMMISSION
PLANNING COMMISSION
LAND CONSERVAnON Be
ENVIRONMENT
COMMITTEE (lCEC)
PLANNING
ASSISTANTS
Planning
Zoning Admlnlstratlon
Property Records
Inspectlon
-
-
-
-
JOINT POWERS ORGANIZATIONS
POUCE - SLMPD
FIRE - EXCELSIOR FIRE DISTIllCT
LMCC . Lake M1nnelonka
Communlcallons Commission
LMCD - Lake M1nnetonka Conservation
DIstrict
UGHT EQUIPMENT
OPERATORS
----------------------------------
Building and Grounds Engineering Services
Tree Maintenance Project Mgmt
Pork Maintenance Water Maintenance
street Maintenance Sewer Malnrenance
Equipment MalntenancESanltotlon/Weeds
Stormwater System Street Ughtlng
Park Planning /Recreatlon Programs
-
-
-
-
-
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
THE SHORE REPORT/December 2003
City of Shorewood 2004 City Budget
Proposed Property
Tan.{ NoticE
YOU should have received a notice
from Hennepin County about the
property taxes your school district,
county and city can collect in 2004.
Your actual taxes may be lower than
the proposed tax on your notice. These
are the maximum taxes that can be
levied. Your actual tax statement will
arrive in the spring.
I,~,'__~'_"~"~.'~"'"'~_'~"'___'~"~'~'~~~M_"_""~,"~'''''''''''~_'~~~~_'~~'~'~~-'--'~~--'.J.IlI
Shorewood
23%
Schools
35%
IF YOU HA VB ANY
QUESTIONS ABOUT THE
PROPOSED BUDGET OR
ABOUT YOUR PROPERTY
TAXES, PLEASE CON-
TACT THE FINANCE
DEPARTMENT AT (952)
474-3236. .
)(
~ ~
~ ~
~j
@?:
w 1-
a..((
o V\
" ~
~ <<
~ ..,J
;j ....B
o 0
)iQ
Other
7%
Hennepin
County
35%
Less than one-fourth of your property tax dollar goes to the City of
Shorewood.
~""~,,,..._,,,,,._~.~~_<._..,,~.,,~,,,,~~.._,.....'''W'~~'~'M."""",..,~,,,. .."""",~"~"~~.~,"._._.,,~,,."",.,"~.~,",,..""""""'"
~ CITY OF SHOREWOOD MINNETONKA SCHOOL DISTRICT #276
V& Monday, December 1, 7 PM Tuesday, December 2, 7 PM
\:) City Council Chambers Community Room, District Service Center
Z 5755 Country Club Road 5621 Co. Rd. 101 S
~ Shorewood, MN 55331 Minnetonka, MN 55345
Ii( (952) 474:-3236 (952) 401-5024
W
T
~
F
I&A
\:'J
(:\
:;)
~ YOUR INPUT ON OUR BUDGETS IS WELCOMED AND APPRECIATED!
HENNEPIN COUNTY
Thursday, December 4,5:30 PM
Commissionioners' Board Room
A-2400 Govemement Center
Minneapolis, MN 55438 .
(612) 348-5433
WESTONKA PUBLIC SCHOOLS
Tuesday, December 2,7:30 PM
Community Room, Educational Service Center
5901 Sunnyfield Rd. E
Minnetrista, MN 55364
(952) 491-8021
7
Sample Proposed 2004
Property Tax
For the median Shorewood Home
(S326,OOO)
County
City
School
Metro Districts
Other Districts
Solid Waste Fee
Total
$1,528
970
1,~02
111
132
61
$4,304
...........,..,
Water Rate Changes
The Shorewood City Council is
considering a water rate increase
for 2004 as part of a gradual increase
over a three.:.year period. The base rate
for water in 2004 would change from
$25 to $30 for the first 10,000 gallons
of usage. The rate for 10,000-50,000
gallons usage would increase from
$1.95 to $2.95 per thousand gallons.
For usage greater than 50,000 gallons
per quarter, the .rate would change
from $2.75 to $3.75 per thousand. The
quarterly cost for an average household
that uses 30,000 gallons would be about
$89.
Please contact the Finance Department
at (952) 474-3236 if you have questions
about the proposed rate change.
4-~4A.,4~4.bA.~~...I......~. ~b..
~~~~~G~~~~~rw~~.~
www.ci.shorewood.mn.us
'. .'
.2003 ~ , ~ .... ,'.. 2ci04Tax Rate If '
tax R'ate : , . , , ,", 'NO l.:evy"lncrease
31.922% . .. 27.994% "
, '20,04' Prop"osec!
. , Tax Rate , ' ,
,,30.420% ' , ", "
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
CITY OF SHOREWOOD
BUDGET 2004
TRUTH-IN-TAXATION NOTICE
, Notice of Propos.~d' , ",' ,
:Total BU,dg~t and.~'Prol?~rty Taxes I
Tre Shorewood City c~uncil'~i1i hold a pubiiC hea:;ingeon~ i~'~~dg~t ando~ the ,amount '
of property taxes it is, proposing to collect to pay for',the costs of ~ervices ,the 9ity will ,
p,rovid~ in 2004. : ' , , ',..
SPENDING: Th~' tot~lbudget "amounts below c,omp'are the ,City's ,2003' total ',actual '
budget wit~ t,heam()unt the cltY'~roposes to spend i~ 2004., ,', ,'. ' '
. . . ..
2003,Total ,", ' Proposed 2004' Chan'ge from
Actual' BlIdget :, BucQet,', 2003 - 2004
$317191072. . .$3,.921.947!..,. '5.50/0 .' :.
'. '. . .J" '.. . '., . " " . . ,~ .
TAXES:7ne"propertY',tax,:am'ounfs below:c'ompare ,that portion of the curient budget
levied in property taxes in the City of Shorewood for 2003 with tti~.property taxeS the City'
proposes t? coll~ct i~ ,2q04.. ' , " ,
,
:: ' 2003 PropertY' , ' 'Proposed 2004 Change !rorr(
, ' ' Taxes, Property Taxes 2003 - 2004 ' '
., , ' ,.'.- $3,156,a47 "','",', ,$3,420,~9," 8.4%' "
, LOCA~ TAX R~TE' C6MPAI11S0N~ The ,fO;lo~i~g' ~o~pares the' ci~'s 'curr~A~'loc~ta~
rcite, the City'stax rate for 2004 if rio taX levy incre,ase i~ adopt~d" an~the City's proposed
tax 'rate ,for ~004.. ".' , " - ':." " ,'. , "':" . .
. '" ,...,
, ' , Attenc;l ,the P,\.lblic Hearing" , .' . ,", - ,
, All Shbrewood City residents ~re invited to atfend the, public hearing of the City Council' '
to ~xpress theiropinion~ on the budget ant! on the proposed amount of 2004 property'
, t~es. The hear,ing will be held on: '," ' . . ,,' : ' .
, ',Monday; D'eoember 1,' at' 7:00 p.m.' ,
" ' Shorewood City Hall' ' , " ,
, . 5755 Country' C.lub Road ' '
. Shorewqbd, MN' >
If the discussion of the budget cannot beco~p!eted;atime and piace'for contin'uing the
discussion will be announced at t)1e hearing. You are als'o'inviteo to sencfyour written
comments to: . ' ";: '
. City of Shorewood Mayor's Office , '
,57$5 Country Club. Road, Shorewood, MN 55331
8
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
THE GENERAL FUND
The General Fund is used to account for resources traditionally associated with
government which are not required legally or by sound financial management to be
accounted for in other funds. It normally receives a greater variety and number of taxes
and other general revenues than any other fund. The majority of the CUlTent day-to-day
operations will be financed from this fund.
9
I
CITY OF SHOREWOOD
GENERAL FUND REVENUE AND EXPENDITURE SUMMARY I
2004 ADOPTED BUDGET
Actual Adopted YTO Sept Requested Proposed Adopted $$ % I
2002 2003 2003 2004 2004 2004 Change Change
Revenues and Other Sources
Property Taxes 2,658,662 3,156,847 1,086,000 3,420,229 3,420,229 3,420,229 263,382 8.34%1
Licenses and Permits 229,234 242,050 218,606 191,967 191,967 191,967 (50,083) -20.69%
Intergovernmental 171,783 70,175 60,609 59,751 59,751 59,751 (10,424) -14.85%
Fines and Forfeitures 89,632 60,000 64,669 60,000 60,000 60,000 0 0.00%1
Charges for Service 46,079 35,000 47,587 35,000 35,000 35,000 0 0.00%
Miscellaneous Revenue 434,743 125,000 92,913 125,000 125,000 125,000 0 0.00%
Total Revenues 3,630,133 3,689,072 1,570,384 3,891,947 3,891,947 3,891,947 202,875 5.5001<
Expenditures
General Government I
Mayor and Council 93,693 125,964 56,542 103,664 103,664 103,664 (22,300) -17.70%
Administration 104,539 122,362 82,273 133,723 133,723 133,723 11,361 9.28%
General Government 173,689 205,930 114,714 189,647 189,647 189,647 (16,283) -7.911
Elections 6,006 0 1,383 32,094 32,094 32,094 32,094 100.000
Finance 127,064 151,885 109,393 165,686 165,686 165,686 13,801 9.09%
Professional Services 169,394 206,800 147,885 190,000 190,000 190,000 (16,800) -8.120;1
Planning and Zoning 146,953 146,726 114,282 149,740 149,740 149,740 3,014 2.050
Municipal Building 128,146 158,865 64,246 166,350 166,350 166,350 7,485 4.71%
Total General Government 949,484 1,118,532 690,718 1,130,904 1 ,130,904 1,130,904 12,372 1.11t
Public Safety
Police 609,192 797,664 675,183 947,102 947,102 947,102 149,438 18.731
Fire Protection 293,029 404,091 301,743 481,629 481,629 481,629 77,538 19.190
Protective Inspection 86,958 103,720 68,768 108,146 108,146 108,146 4,426 4.27%
Animal Control 19,900 23,500 14,527 23,500 23,500 23,500 0 0.001
Total Public Safety 1,009,079 1,328,975 1,060,221 1,560,377 1,560,377 1,560,377 231,402 17.41%
Public Works 2.72J
City Engineer 101,582 117,279 79,380 120,467 120,467 120,467 3,188
Public Works Services 225,940 280,910 162,154 281,516 281,516 281,516 606 0.22"1c
Streets and Roadways 1 04,045 152,656 70,305 164,959 164,959 164,959 12,303 8.061
Snow and Ice Removal 40,013 57,435 25,081 63,392 63,392 63,392 5,957 10.37
Traffic ControVStreet Lights 34,478 40,250 24,915 40,250 40,250 40,250 0 0.000;'
Sanitation/Waste Removal 3,993 4,450 2,957 5,167 5,167 5,167 717 16.11
Tree Maintenance 20,715 24,852 15,648 25,378 25,378 25,378 526 2.12
Total Public Works 530,766 677 ,832 380,439 701,129 701,129 701,129 23,297 3.441
Culture and Recreation
Parks and Recreation 451,793 200,083 127,452 206,037 206,037 206,037 5,954 2.981
Total Culture and Recreation 451,793 200,083 127,452 206,037 206,037 206,037 5,954 2.98
Total Expenditures 2,941,122 3,325,422 2,258,831 3,598,447 3,598,447 3,598,447 273,025 8.21
Total Revenues Over (Under)
Expenditures 689,011 363,650 (688,447) 293,500 293,500 293,500 I
10
I
I
I
CITY OF SHOREWOOD
GENERAL FUND REVENUE AND EXPENDITURE SUMMARY
2004 ADOPTED BUDGET
Actual
2002
Adopted
2003
YTD Sept Requested Proposed
2003 2004 2004
Adopted
2004
$$
Change
%
Change
rnd Transfers In
Liquor Fund 30,000 30,000 0 30,000 30,000 30,000 0 0.00%
Street Reconstr Fund 0 0 0 0 0 0 0
I Trail Fund 0 0 0 0 0 0 0
Sewer Fund 25,000 0 0 0 0 0 0
Water Fund 0 0 0 0 0 0 0
lotal Transfers In 55,000 30,000 0 30,000 30,000 30,000 0 0.00%
Fund Transfers Out
I Equip Replacemt Fund (Pol) 0 0 0 0 0 0 0
Equip Replacemt Fund (PW) 70,800 70,000 0 50,000 50,000 50,000 (20,000) -28.57%
Street Reconstr Fund 200,000 200,000 0 183,500 183,500 183,500 (16,500) -8.25%
I Park Capital Imp Fund 185,000 30,000 0 10,000 10,000 10,000 (20,000) -66.67%
Trail Capitallmprvment Fnd 28,700 28,650 0 0 0 0 (28,650) -100.00%
Public Facilities Fund 89,600 35,000 0 50,000 50,000 50,000 15,000 42.86%
I Land & Open Space Fund 0 0 0 5,000 5,000 5,000 5,000
Stormwater Mgmt Fund 35,000 30,000 0 25,000 25,000 25,000 (5,000) -16.67%
Total Fund Transfers Out 609,100 393,650 0 323,500 323,500 323,500 (70,150) -17.82%
lxcess (Deficiency) of Revenues and
Other Financing Sources Over
rxpenditures and Other Uses 134,911 0 (688,447) 0 0 0 0 0.00%
Amounts to be Provided from
General Fund Balance 0 0 688,447 0 0 0 0
IGeneral Fund Balance January 1
2,023,069 2,157,979 2,157,979 . 2,157,979 2,157,979 2,157,979
IGeneral Fund Balance December 31 2,157,979 2,157,979 1,469,532 2,157,979 2,157,979 2,157,979
I
I
I
I
I
I 11
CITY OF SHOREWOOD
GENERAL FUND SUMMARY OF ESTIMATED REVENUES
2004 ADOPTED BUDGET
I
I
I
TAXES:
~ - The City levies property taxes to finance the general operating fund which provides municipal governmental services
Fiscal Disoarities - Received with taxes above. In 1971, the legislature enacted this law to allow municipalities to share
in metropolitan commercial/industrial growth. A percentage of commercial/industrial taxes are pooled and distributed
and distributed to communities in the metrololitan area.
Special Lew - In addition to levy limits, this special levy is for Shorewood's share of the debt service for the public safety bldg.
General Govemment
The City provides services to the public for which a charge is collected such as assessment searches, map sale, planning fees.
Enaineerina - Fees charged to other City funds and developers for engineering services.
Recreation - Fees charged to Freeman Park Foundation for park maintenance and Crescent Beach charges.
I
I
I
I
I
I
I
I
I
LICENSE/PERMIT FEES:
Rental Housina License Fees - License fees for rental housing units. License is valid for a term of three (3) years.
Liquor License Fees
Other Business Licenses - Fees for refuse hauler and tree trimming licenses.
Building Permits - Permit fee based upon valuation of structure according to Uniform Building Code Schedule.
Doa Licenses
Other Non-business - Horse permit and alarm permit fees.
INTERGOVERNMENTAL REVENUE:
Local Government Aid - the continuance of the discontinued Local Performance Aid. LGA is discontinued as of 2003.
Homestead and Aariculture Credit Aid (HACA)- A State credit which reduces the tax levy. HACA is discontinued as of 2003.
Local Performance Aid (LPA) - A State aid passed in the 1996 legislature which is given to
jurisdictions which certify that they are either developing or have already incorporated the use of
performance measurements in their budgeting process. This aid is discontinued for 2000.
PERA Aid - A State aid approved in the 1997 legislature to fund an mandated increase of 0.70% in the
MSA Road Aid - Aid provided by the State of Minnesota to cities over 5,000 in population to maintain designated MSA roads.
CHARGES FOR SERVICES:
MISC. REVENUES - Revenue from a variety of sources such as interest income,
dry hydrant charges, pop sales, cellular antenna rental and other miscellaneous revenues.
I
I
FINES & FORFEITS - Fines imposed for traffic & ordinance violations.
12
I
I
I
I
I
TRANSFERS FROM OTHER FUNDS - For 2004, transfers from liquor, and other funds, such as sewer and water.
FUND BALANCE - Fund Balance allocated for 2004 budget purposes.
-------------------
CITY OF SHOREWOOD
ADOPTED 2004 GENERAL FUND REVENUES
Intergvm'tl Revenue
2%
Licenses & Permits
5%
Fines & Forfeits
2%
Charges For Service
1%
Tsfrs & Misc
4%
Property Taxes
85%
I
I CITY OF SHOREWOOD
GENERAL FUND SUMMARY OF ESTIMATED REVENUES
I 2004 ADOPTED BUDGET
Actual Actual Budget YTD Sept Proposed Adopted
EVENUES: 2001 2002 2003 2003 2004 2004
AXES:
General Property 2,128,512 2,558,366 2,851,847 1,086,000 2,907,997 2,907,997 56,150 1.97%
liscal Disparities 78,013 100,297 0 0 0 0
pecial Levy 0 0 305.000 0 512,232 512.232 207,232 67.94%
TOTAL TAXES 2.206.525 2.658.662 3.156.847 1.086.000 3,420.229 3,420,229 263.382 8.34%
tCENSE/PERMIT:
ental Housing 210 100 130 100 100 0 0.00%
Tobacco 1,750 2,500 2,500 500 2,500 2,500 0 0.00%
tcohOIiC Beverages 8,150 8,150 8,150 8,450 8,150 8,150 0 0.00%
thers-Business 2,345 2,669 2,000 1,419 2,000 2,000 0 0.00%
Building Permits 333,939 210,386 225,000 204,587 175,000 175,000 (50,000) -22.22%
I Tree Trimming Licenses 300 330 300 120 300 300 0 0.00%
Dog Licenses 2,706 3,164 2,500 2,700 2,500 2,500 0 0.00%
Others-Misc. 325 1,825 1,500 700 1 ,417 1,417 (83) -5.53%
TOTAL LICENSE/PERMIT 349,515 229.234 242.050 218.606 191 .967 191.967 (50.083) -20.69%
liNTER-GOVERNMENTAL REVENUES
STATE AIDS
Local Government Aid 8,412 8,417 8,418 0 0 0 (8,418) -100.00%
I HACA 427,003 0 0 0 0 0 0
Mkt Value Credit Aid 96,244 0 0 0 0
PERA Aid 4,751 4,751 4,751 0 4,751 4,751 0 0.00%
I MSA Road Aid 57,103 62,371 57,006 60,609 55.000 55,000 (2,006) -3.52%
Total State Aids 497,269 171,783 70,175 60,609 59,751 59,751 (10,424)
TOTAL INTERGOVERNMENTAL 497.269 171,783 70.175 60.609 59.751 59,751 (10,424) -14.85%
I CHARGES FOR SERVICE: 12,815 8,635 8,000 19,368 8,000 8,000 0 0.00%
General Government
Engineering 12,443 19,540 12,000 0 10,000 10,000 (2,000) -16.67%
I Recreation 16.965 17.904 15,000 28.219 17.000 17.000 2.000 13.33%
TOTAL CHARGES FOR SERVICE 42,222 46,079 35,000 47.587 35,000 35.000 0 0.00%
FINES & FORFEITS 61 .243 89.632 60.000 64.669 60.000 60,000 0 0.00%
I MiSe REVENUES 161,002 434.743 125,000 92.913 125.000 125.000 0 0.00%
TRANSFERS
I From Other Funds ' 20,000 25,000 0 0 0 0 0
From Liquor Stores 10.000 30.000 30.000 0 30.000 30 ,000 0 0.00%
TOTAL TRANSFERS 30.000 55.000 30,000 0 30,000 30.000 0 0.00%
I TOTAL REVENUES 3.347.776 3.685.132 3.719,072 1.570,385 3,921.947 3,921.947 202,875 5.45%
OTHER FUNDING SOURCES: 0 0 0 0 0 0 0
I TOTAL REVENUES $3.347,776 $3,685.132 $3.719.072 $1.570,385 $3.921.947 $3.921.947 $202.875 5.45%
I
I 15
I
CITY OF SHOREWOOD I
GENERAL FUND SUMMARY OF EXPENDITURES & TRANSFERS OUT
2004 ADOPTED BUDGET
Actual Adopted YTD Sept Requested Proposed Adopted $$ % I
2002 2003 2003 2004 2004 2004 Change Change
Expenditures I
General Government
Mayor and Council 93,693 125,964 56,542 103,664 103,664 103,664 (22,300) -17.70%
Administration 104,539 122,362 82,273 133,723 133,723 133,723 11,361 9.28%
General Government 173,689 205,930 114,714 189,647 189,647 189,647 (16,283) -7.91%1
Elections 6,006 0 1,383 32,094 32,094 32,094 32,094 100.00%
Finance 127,064 151,885 109,393 165,686 165,686 165,686 13,801 9.09%
Professional Services 169,394 206,800 147,885 190,000 190,000 190,000 (16,800) -8.12%1
Planning and Zoning 146,953 146,726 114,282 149,740 149,740 149,740 3,014 2.05%
Municipal Building 128,146 158,865 64,246 166,350 166,350 166,350 7,485 4.71%
- Capital Tsfr: Ottc. Equip. 89,600 35,000 0 50,000 50,000 50,000 15,000 42.86%
Total General Government 1,039,084 1,153,532 690,718 1,180,904 1,180,904 1,180,904 27,372 2.37%
Public Safety 18.73%1
Police 609,992 797,664 675,183 947,102 947,102 947,102 149,438
Fire Protection 293,029 404,091 301,743 481,629 481,629 481,629 77 ,538 19.19%
Protective Inspection 86,958 103,720 68,768 108,146 108,146 108,146 4,426 4.27o~1
Animal Control 19,900 23,500 14,527 23,500 23,500 23,500 0 0.000/.
Total Public Safety 1,009,879 1,328,975 1,060,221 1,560,377 1,560,377 1,560,377 231 ,402 17.410/1
Public Works
City Engineer 101,582 117,279 79,380 120,467 120,467 120,467 3,188 2.72)
Public Works Services 225,940 280,910 162,154 281,516 281,516 281,516 606 0.220
-Capital Tsfr: Equip/Strmwtr 105,000 100,000 0 75,000 75,000 75,000 (25,000) -25.0000
Streets and Roadways 104,045 152,656 70,305 164,959 164,959 164,959 12,303 8.06%
-Capital Tsfr: Street Imprvs. 200,000 200,000 0 183,500 183,500 183,500 (16,500) -8.25t
Snow and Ice Removal 40,013 57,435 25,081 63,392 63,392 63,392 5,957 10.370
Traffic ControVStreet Lights 34,478 40,250 24,915 40,250 40,250 40,250 0 0.00%
Sanitation/Waste Removal 3,993 4,450 2,957 5,167 5,167 5,167 717 16.110
Tree Maintenance 20,715 24,852 15,648 25,378 25,378 25,378 526 2.120
Total Public Works 835,766 977,832 380,440 959,629 959,629 959,629 (18,203) -1.860/1
Culture and Recreation
Parks and Recreation 451,793 200,083 127,452 206,037 206,037 206,037 5,954 2.98%
-Cap Tsfr: Pk Imprv/Land 213,700 58,650 0 15,000 15,000 15,000 (43,650) -74.420
Total Culture and Recreation 665,493 258,733 127,452 221,037 221,037 221,037 (37,696) -14.57%
Total Expenditures 3,550,222 3,719,072 2,258,831 3,921,947 3,921,947 3,921,947 202,875 5.451
I
I
16 I
-------------------
CITY OF SHOREWOOD
ADOPTED 2004 GENERAL FUND EXPENDITURES
Other Public
Safety
3%
Parks
5%
Capital Tsfrs
8%
General Gov't
30%
Public Works
18%
Fire
12%
Police
24%
18
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
FUND:
1 01 General
DEPARTMENT MISSION:
The Mayor and City Council set policy for the City
and provide general direction to the Administrator in
policy implementation. The department budget
supports council development, information efforts and
special City associations and programs.
DEPARTMENT: Mayor and Council
DEPT NO:
41110
DESCRIPTION OF ACTIVITY:
The City Council meets twice montly and in periodic special worksessions to consider
and adopt legislative and administrtive policies that pertain to the services
provided to residents. The City Council also sits as the Board of Review for property valuations and
as the Board of the Shorewood Economic Development Authority.
OBJECTIVES'
- Establish annual goals and priorities for the City
- Meet at least annually with advisory commissions.
- Strategic planning
HIGHLIGHTS/COMMENTS'
Staffing:
City Council Salaries
Supplies/Materials:
Awards and misc. supplies
Support Services:
Conferences and Seminars
Appreciation Function for City Volunteers/Staff
Special Brochures
Lake Minnetonka Conservation District (LMCD)
Assn of Metro Municipalities
League of MN Cities
Excelsior Chamber of Commerce July 4th Celebration
Charges, Fees & Other:
Council Contingency
20
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
FUND:
1 01 General
DEPARTMENT MISSION:
To implement policy established by the City Council; offer
staff support to the City Council in its policy making role;
and manage day-to-day operations of the City in a manner
consistent with established City values to effectively and
efficiently meet set goals & objectives.
D EP ARTM ENT: Administration
DEPT NO:
41300
DESCRIPTION OF ACTIVITY:
The City Administrator directs City departmental operations to ensure compliance with
policies established by the City Council and with state and federal laws. The
department supports the City Council by managing Council agendas, directing the
flow of information and requests for action to the Council.
OBJECTIVES:
- Take a leadership role in intergovernmental cooperative efforts in the Lake Minnetonka area
- Participate actively in joint powers organizations
- Participate actively in legislative and policy activities of municipal associations
- Actively monitor legislation and communicate with legislators
HIGHLIGHTS/COMMENTS:
Staffing:
Includes step increases
Supplies/Materials:
Miscellaneous books & supplies
Support Services:
Labor Relations Associates Contract
Conference, mileage, meetings & seminars
Memberships to ICMA, MCMA, MAMA
I
FUND: 101 DEPARTMENT: Administration DEPT 41300
I BUDGET Actual Actual Budget YTD Sept Requested Proposed Adopted
ITEM 2001 2002 2003 2003 2004 2004 2004
I Staffing 99,764 98,716 111,512 76,384 122,273 122,273 122,273
Supplies/Materials 47 0 400 0 200 200 200
I
Support Services 4,468 5,823 10,450 5,889 11 ,250 11 ,250 11 ,250
I Charges & Fees 0 0 0 0 0 0 0
Capital Outlay 324 0 0 0 0 0 0
I Transfers 0 0 0 0 0 0 0
TOTAL 104,603 104,539 122,362 82,273 133,723 133,723 133,723
I SERVICE INDICATORS'
I Council Mtgs/Work Sessions 48 48 48 48
Council Agenda Items 500 500 500 500
Public Safety Board Meetings 20 20 20 20
I Public Safety Staff Meetings 14 14 14 14
Staff Meetings 52 52 52 52
I COST INDICATORS:
Expenditures 104,603 104,539 122,362 82,273 133,723 133,723 133,723
I - Program Revenues 0 0 0 0 0 0 0
I = Levy Dollars 104,603 104,539 122,362 82,273 133,723 133,723 133,723
I STAFFING:
Full Time:
I Admistrator/Clk 1.00 1.00 1.00 1.00 1.00 1.00 1.00
Exec Sec/Dep Clk .33 .33 .33 .33 .33 .33 .33
I
I
I
I
I 21
I
FUND:
101 General
DEPARTMENT MISSION:
Provide staff support for the City Council including
preparation of agendas and meeting packets.
Responsible for City Clerk functions including
records retention, notices and licenses.
I
DEPARTMENT: City Clerk
DEPT NO:
41400
I
DESCRIPTION OF ACTIVITY:
This department provides for general reception and secretarial duties in the City offices,
as well as the recording secretary for City Council meetings. The Deputy Clerk is the official
recordkeeper of minutes and permanent records, and supervises all staff in this area.
This department is responsible for all licensing functions. It also oversees implementation of
the City communications plan.
I
I
OBJECTIVES:
-Continue to improve web site, allowing visitors to communicate better with City Hall
- Improve City newsletter through the addition of community articles & pictures, council & commission articles, & project updates
- Improve response time to residents making general inquiries through various communications tools
- Monitor and report on effectiveness of communications plan
- Develop orientation package for new council members, commission members and staff
I
I
I
Staffing:
I
HIGHLIGHTS/COMMENTS'
Includes step increases for full time employees,
part-time communications tech
part-time. temporary, general office support
part-time Web developer
I
Supplies/Materials:
I
Newsletter supplies & postage
Office supplies & postage
Software upgrades
Office equipment supplies
I
Support Services:
I
Conference, mileage and Seminars
Publication of legal notices for all General Fund Depts
Council Recording Secretary
Computer Consulting and Training
Memberships to IIMC, MCFOA & Municipals
I
I
Capital Outlay:
Computers (3) (Pat, Twila, Jean)
I
I
I
22
I
I
FUND: 101 DEPARTMENT: City Clerk DEPT 41400
I
BUDGET Actual Actual Budget YTD Sept Requested Proposed Adopted
ITEM 2001 2002 2003 2003 2004 2004 2004
I Staffing 96,939 128,277 134,780 90,240 130,772 130,772 130,772
Supplies/Materials 17,184 17 ,404 37,250 12,467 31,725 31,725 31,725
I Support Services 13,777 25,044 30,250 8,552 22,350 22,350 22,350
I Charges & Fees 0 0 0 0 0 0 0
Capital Outlay 5,398 2,964 3,650 3,456 4,800 4,800 4,800
I Transfers 0 0 0 0 0 0 0
TOTAL 133,298 173,689 205,930 114,714 189,647 189,647 189,647
I SERVICE INDICATORS:
No. of Elections held 0 0 0
I No. of Ordinances 10 10 10
No. of Resolutions 120 120 120
Dog licenses issued 450 450 450
I Other licenses issued 30 50 50
Council Agendas 48 48 48
I COST INDICATORS:
Expenditures 133,298 173,689 205,930 114,714 189,647 189,647 189,647
I . Program Revenues
I = Levy Dollars 133,298 173,689 205,930 114,714 189,647 189,647 189,647
I STAFFING:
Full time:
I Exec Sec/Dep Clk .67 .67 .67 .67 .60 .60 .60
Parks Secretary .70 .70 .70 .70 .70 .70 .70
Secretary/Receptionist 0.25 0.25 0.25 0.25 0.25 0.25 0.25
I Accounting Clerk I 0.25 0.25 0.25 0.25 0.25
Part time:
I Communications Tech. 1.00 0.66 0.66 0.66 0..37 0..37
Website Maint. (Plan.Asst) 0.20 0.20 0.20 0.20
Temporary Receptionist
I
I
I 23
FUND:
101 General
DEPARTMENT MISSION:
Responsible for Election functions.
I
I
DEPARTMENT: Elections
DEPT NO:
41410
I
DESCRIPTION OF ACTIVITY'
This department provides for the preparation for and supervision of State/Federal Primary
City General and Special elections by the Deputy City Clerk.
I
- Increase youth awareness of local government issues through active involvement with school officials
and instructors through programs such as student election judges
I
I
I
I
OBJECTIVES:
I
HIGHLIGHTS/COMMENTS:
I
Staffing:
Supplies/Materials:
I
I
Election Clerks
Election supplies & materials
I
Support Services:
I
CapitalOutlay:
I
I
V oting Booths
ADA Ramp for W1 P 1
I
24
I
I
I
FUND: 101 DEPARTMENT: Elections DEPT 41410
I BUDGET Actual Actual Budget YTD Sept Requested Proposed Adopted
ITEM 2001 2002 2003 2003 2004 2004 2004
I Staffing 0 26,569 26,569 26,569
Supplies/Materials 1.383 2,075 2,075 2,075
I Support Services 0 1,650 1,650 1,650
Charges & Fees 0 0 0 0
I Capital Outlay 0 1,800 1,800 1,800
I Transfers 0 0 0 0
TOTAL 0 0 0 1,383 32.094 32,094 32,094
I SERVICE INDICATORS:
No. of Elections held 0 2 2 2
No. of Ordinances
I No. of Resolutions
Dog licenses issued
I Other licenses issued
Council Agendas
I COST INDICATORS:
Expenditures 0 0 0 1,383 32,094 32,094 32,094
I - Program Revenues
I = Levy Dollars 0 0 0 1,383 32,094 32,094 32.094
I STAFFING:
Full time:
I Exec Sec/Dep Clk 0.20 0.20 0.20
Part time:
I Election Judges 35.00 35.00 35.00
I
I
I
I 25
DEPT NO:
41500
DEPARTMENT MISSION:
To administer financial policies of the City; perform
accounting functions for all fund types; invest
available funds in accordance with State Statutes;
oversee City insurance policies; and provide for
timely reporting of financial matters to City Council
staff and the public.
I
I
FUND:
101 General
DEPARTMENT: Finance
I
DESCRIPTION OF ACTIVITY:
I
Finance is responsible for processing all financial transactions of the City in accordance with
Federal, State and Local laws, and in compliance with Generally Accepted Accounting Principles.
Transactions include accounts payable, accounts receivable, payroll, investments, utility billing,
special assessments, risk management, personnel benefits and financial reporting. The
Finance Director is responsible for the preparation and administration of the City budget.
- Prepare annual budget document
- Prepare CAFR for submittal to GFOA Certificate of Achievement Program
- Review debt issues and make recommendations on debt structure
- Review and update financial policies and procedures
- Coordinate the transition to GASB 34 financial reporting
I
I
I
I
OBJECTIVES:
Computer checks & budget supplies
Finance software support and maintenance
Miscellaneous supplies
I
I
I
I
HIGHLIGHTS/COMMENTS:
Staffing:
Includes step increases
Supplies/Materials:
Support Services:
Conferences, Mileage, Meetings, Education & Seminars
Publication of Financial Statements & Budgets
Memberships to GFOA & MGFOA
Subscription to GFOA periodicals
Submittal fee - GFOA Certificate of Excellence Program
Submittal fee - GFOA Distinguished Budget Award Program
Bank & Broker service charges
I
I
Capital Outlay:
I
I
I
26
I
I
I
FUND: 101 DEPARTMENT: Finance DEPT 41500
I BUDGET Actual Actual Budget YTD Sept Requested Proposed Adopted
ITEM 2001 2002 2003 2003 2004 2004 2004
I Staffing 106,001 117,031 120,685 97,108 135,636 135,636 135,636
Supplies/Materials 2,870 1,090 18,500 4,543 18,350 18,350 18,350
I Support Services 6,422 7,888 10,200 4,644 9,700 9,700 9,700
Charges & Fees 0 0 0 0 0 0 0
I
Capital Outlay 1,065 1,055 2,500 3,098 2,000 2,000 2,000
I Transfers 0 0 0 0 0 0 0
TOTAL 116,358 127.064 151.885 109.393 165.686 165.686 165,686
I SERVICE INDICATORS:
No. Monthly Statements 12 12 12 12 12 12 12
No. Accounts Payable
I Checks Issued 2,500 2,500 2,500 2,500 2,500 2,500 2,500
Utility Bills Sent 11,000 11,000 11 ,000 11,500 11,500 11,500 11 ,500
No. of Payroll Checks
I Issued 1,100 1,100 1,100 1,250 1,250 1,250 1,250
No. of Sp. Assess.
Rolls Maintained 23 23 23 23 23 23 23
I COST INDICATORS:
Expenditures 116,358 151,885 109,393 165,686 165,686 165,686
I - Program Revenues
Interest Earnings 99,370 105,000
Sp. Assess. Searches 415 300
I = Levy Dollars 16,573 46,585 109,393 165,686 165,686 165,686
STAFFING:
Full time:
I Finance Dir 1.00 1.00 1.00 1.00 1.00 1.00
Sr Acctg Clerk .60 .60 .60 .60 .60 .60
Acctg. Clerk .25 .25 .25 .25 .25
I
I
I
I
I
I 27
FUND:
101 General
DEPARTMENT MISSION:
Provide contracted professional services to the City
including general legal, prosecution, financial
audit and property assessment.
DEPARTMENT: Professional Services
DEPT NO:
41600
DESCRIPTION OF ACTIVITY:
This department provides for contracted legal, assessing and auditing services for the
City. Legal services include general counsel to the City Council, litigation and
prosecution of criminal misdemeanors. Assessing services provide property valuation
information for tax purposes. Audit services provide for the annual financial audit required
by Minnesota State Statutes.
OBJECTIVES:
- Contain costs on contracted professional services
- Attempt to utilize mediation services to avoid litigation
HIGHLIGHTS/COMMENTS:
Supplies/Materials:
Supplies for City Assessor
Support Services:
Includes general legal fees and prosecutions, mediation services, assessing contract, annual audit services.
Charges and Fees:
28
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
FUND: 101 DEPARTMENT: Professional Services DEPT 41600
I BUDGET Actual Actual Budget YTD Sept Requested Proposed Adopted
ITEM 2001 2002 2003 2003 2004 2004 2004
I Staffing 0 0 0 0 0 0 0
Supplies/Materials 0 0 0 0 0 0 0
I
Support Services 197,472 169,394 206,800 147,885 190,000 190,000 190,000.
I Charges & Fees 0 0 0 0 0 0 0
Capital Outlay 0 0 0 0 0 0 0
I Transfers 0 0 0 0 0 0 0
TOTAL 197,472 169,394 206,800 147.885 190,000 190,000 190,000
I SERVICE INDICATORS:
I No. of parcels 3,050 3,050 3,050 3,050 3,050 3,050
No. of litigations 5 5 5 5 5 5
I No. of City Funds 22 22 22 22 22 22
I COST INDICATORS:
Expenditures 197,472 169,394 206,800 147,885 190,000 190,000 190,000
I - Program Revenues
Fines 18,100 19,300 19,300 0 0
I = Levy Dollars 179,372 150,094 187,500 147,885 190,000 190,000 190,000
Other Dollars
I STAFFING:
I
I
I
I
I
I 29
30
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
FUND:
101 General
DEPARTMENT MISSION'
Guide and control the physical development of
the community. Coordinate and implement long
range city-wide and area planning activities.
DEPARTMENT: Planning & Zoning
DEPT NO:
41910
DESCRIPTION OF ACTIVITY:
This department is responsible for the review of development proposals, preparing and updating
the City's Comprehensive Plan, and other long range planning activities. It provides for
administration and enforcement of the City's zoning codes, and preparation and upkeep of
zoning, subdivision, floodplain and other planning and zoning related ordinances.
OBJECTIVES:
- Establish an action plan to implement Comprehensive Plan
- Complete GIS parcel data base
- Update/enhance city maps
- Update/enhance procedure handouts
HIGHLIGHTS/COMMENTS:
Staffing:
Includes step increases
Supplies/Materials:
Maintenance contracts for computer & office equipment
Miscellaneous supplies
Support Services:
Recording Secretary for Planning Commission Meetings
Air time for cellular phone
Conferences, mileage, meetings & seminars
Memberships to APA, MN APA, Sensible Land Use Coalition
Subscriptions to APA Journal & Zoning News
Charges & Fees:
Capital Outlay:
I
FUND: 101 DEPARTMENT: Planning & Zoning DEPT 41910
I
BUDGET Actual Actual Budget YTD Sept Requested Proposed Adopted
ITEM 2001 2002 2003 2003 2004 2004 2004
I Staffing 117,205 128,405 127,326 102,492 135,040 135,040 135,040
I Supplies/Materials 122 842 3,200 783 975 975 975
Support Services 24,549 16,961 14,550 8,931 13,175 13,175 13,175
I Charges & Fees 0 0 0 0 0 0 0
Capital Outlay 482 745 1,650 2,076 550 550 550
I Transfers 2,500 0 0 0 0 0 0
TOTAL 144,858 146,953 146,726 114,282 149,740 149,740 149.740
I SERVICE INDICATORS:
No. of zoning apps. 20 20 20 20
I No. of zoning complnts 20 25 25 25
Planning Comm. Meetings 12 12 12 12
I Planning Comm. Work
Sessions 12 12 12 12
I COST INDICATORS:
Expenditures 144,858 146,953 146,726 114,282 149,740 149,740 149,740
I - Program Revenues
Zoning Appl. Fees
I Bldg. Permit Carryover
(from Proto Inspection)
= Levy Dollars 144,858 146,953 146,726 114,282 149,740 149,740 149,740
I STAFFING:
I Full time:
Planning Dir .95 .95 .95 .95 .95 .95 .95
Planning Asst. .70 .70 1.00 1.00 1.00 1.00 1.00
I Part Time:
Clerical
I
I
I
I 31
32
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
FUND:
101 General
DEPARTMENT MISSION:
Provide for the physical operation of City Hall:
utilities; maintenance of office equipment and the
building structure; and provide for the City's general
liability, property, auto and workers' compensation
insurance.
DEPARTMENT: Municipal Bldg - City Hall
DEPT NO:
41940
DESCRIPTION OF ACTIVITY:
The Municipal Building department provides for maintenance of all equipment located in the City
Hall, and for janitorial services to furnish a clean environment in which to conduct City business.
General Liability, Property and Casualty insurance coverages are also provided under this department.
OBJECTIVES:
- Identify maintenance needs to avoid major investments in the future
- Identify options for maximum utilization of office space to avoid future additions
- Maintain existing facilities at current level or better utilizing staff to reduce maintenance costs
- Continue to dispose of outdated documentation in storage area
- Continue to promote community programs to enhance public facilities, such as "Adopt a Garden."
HIGHLIGHTS/COMMENTS:
Supplies/Materials:
Maintenance contracts for copiers, telephones and office equipment
Maintenance to city hall building
City Hall supplies
Support Services:
City Hall janitorial, rug services, & pest control
Utilities and phone service for City Hall
Insurance coverage for all city depts except enterprise funds
Rental of postage meter
Special Assessments on City owned property
Sales and Use Tax Payments
Charges & Fees:
Capital Outlay:
Senior Community Center Payment
Transfers:
Public Facilities Fund - Office Equipment
I
FUND: 101 DEPARTMENT: Municipal Building - City Hall DEPT 41940
I
BUDGET Actual Actual Budget YTD Sept Requested Proposed Adopted
ITEM 2001 2002 2003 2003 2004 2004 2004
I Staffing 0 0 0 0 0 0 0
I Supplies/Materials 8,914 7,332 17,005 5,958 16,500 16,500 16,500
Support Services 96,410 82,228 104,310 20,403 107,300 107,300 107,300
I Charges & Fees 0 0 0 0 0 0 0
Capital Outlay 38,630 38,586 37,550 37,885 42,550 42,550 42,550
I Transfers 25,000 89,600 35,000 0 50.000 50,000 50,000
TOTAL 168,954 217.746 193.865 64,246 216,350 216.350 216,350
I SERVICE INDICATORS:
I
I COST INDICATORS:
Expenditures 168,954 217,746 193,865 64.246 216,350 216,350 216,350
I - Program Revenues
0 0
I == Levy Dollars 168,954 217,746 193.865 64,246 216,350 216,350 216,350
Other Dollars
I STAFFING:
I
I
I
I
I
I
I 33
FUND:
101 General
DEPARTMENT MISSION:
To provide a modern, flexible, full-service criminal
justice agency which is responsive to community
needs.
DEPARTMENT: Police
DEPT NO:
42100
DESCRIPTION OF ACTIVITY:
The South Lake Minnetonka Police Department is a cooperative joint venture between the cities
of Excelsior, Greenwood, Shorewood and Tonka Bay. Through this venue, the department provides for
the protection of the safety and well-being of citizens in the community, the prevention and detection of
crime, and the enforcement of all local, state and federal laws in a cost-efficient manner.
Costs and staff are allocated to each of the participating cities on a set percentage basis.
The pro-rata share of costs and staff time for City of Shorewood is at 46.0%
A separate obligation is required to finance the new SLMPD station. The cost is apportioned on an
ad valorem basis among four cities. The City of Shorewood's pro-rata share of the 2004 payment is $265,600,
which is approximately 58% of the total payment due.
OBJECTIVES:
HIGHLIGHTS/COMMENTS:
Supplies/Materials:
Upgrade civil defense sirens (two sirens - 2004)
Support Services:
Police services contract for 2004
Prisoner expense, court officer expense, & booking fees
Annual Police Auxilliary Dinner
34
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
36
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
FUND:
101 General
DEPARTMENT MISSION'
Provide the highest possible quality of fire
suppression, prevention and eduction services,
and First Responder emergency medical services.
DEPARTMENT: Fire Protection
DEPT NO:
42200
DESCRIPTION OF ACTIVITY'
Fire services are contracted by the City through the Excelsior Fire District and the City of Mound.
This department provides for the protection of life and property of the citizens of
the community through fire prevention and suppression, fire inspection, building inspection,
fire code enforcement and emergency medical services.
A separate obligation is made toward the financing of new facilities for the Excelsior Fire District. This
cost is apportioned on the same allocation for the operating budget. The City of Shorewood's pro-rata share
of the 2004 debt service payment is $241,687.
OBJECTIVES:
HIGHLIGHTS/COMMENTS:
Support Services:
Fire contracts with Mound and Excelsior Fire District
I
FUND: 101 DEPARTMENT: Fire Protection DEPT 42200
I BUDGET Actual Actual Budget YTD Sept Requested Proposed Adopted
ITEM 2001 2002 2003 2003 2004 2004 2004
I Staffing 0 0 0 0 0 0 0
Supplies/Materials 0 0 0 0 0 0 0
Support Services 248,398 293,029 250,997 191,486 234,997 234,997 234,997
I Charges & Fees 0 0 0 0 0 0 0
Capital Outlay 0 0 152,608 110,256 246,632 246,632 246,632
Transfers 0 0 0 0 0 0 0
I TOTAL 248,398 293,029 403,605 301.743 481 ,629 481.629 481.629
SERVICE INDICATORS:
I Fire calls 135 135 135 135
Rescue calls 125 125 125 125
Inspection hours 25 25 25 25
I Investigation hours 35 35 35 35
Other hours * 400 400 400 400
Cost of emergency
I response 385,734 463,758 463,758 463,758
Cost of inspection/
investigation 17,871 17,871 17,871 17,871
I * includes plan review, paper work, complaint investigation, tank removals, burning permits, etc.
COST INDICATORS:
I Expenditures 248,398 293,029 403,605 301,743 481,629 481,629 481,629
- Program Revenues 0 0 0 0 0 0 0
= Levy Dollars 248,398 293,029 403,605 301,743 481,629 481,629 481,629
I EFD STAFFING:
Chief (FIT) 1.00 1.00 1.00 1.00 1.00 1.00 1.00
Asst. Chief 1.00 1.00 1.00 1.00 1.00 1.00 1.00
I Captain 2.00 2.00 2.00 2.00 2.00 2.00 2.00
lieutenants 4.00 4.00 4.00 4.00 4.00 4.00 4.00
Fire Marshall (FIT) 1.00 1.00 1.00 1.00 1.00 1.00 1.00
I Training Officer 1.00 1.00 1.00 1.00 1.00 1.00 1.00
Firefighters 37.00 37.00 37.00 37.00 37.00 37.00 37.00
I
I
I
I
I
I 37
38
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
FUND:
101 General
DEPARTMENT MISSION:
Enforce construction safety and related building
codes through plan review and inspections.
Enforce animal control ordinances.
DEPARTMENT: Protective Inspection
DEPT NO:
42400
DESCRIPTION OF ACTIVITY:
This department provides for the issuance building and construction permits, review of
construction plans and specifications, enforcement of all building codes under the Uniform
Building Code, inspection of rental housing units, and inspection of zoning violations.
The department also provides for contractual animal control, which includes patrol, detention
and disposition of stray domestic animals.
OBJECTIVES:
- Increase and enhance public information through the development of at least
two handouts relative to building codes
- Explore joint inspection possibilities with adjoining communities
- Enhance environmental inspections
HIGHLIGHTS/COMMENTS:
Staffing:
Includes step increases
Supplies/Materials:
Maintenance contracts on computer and office equipment
Miscellaneous supplies
Support Services:
Contractual inspections during vacations, sick leave
Conferences, mileage, meetings & seminars
Printing of application forms
Membership to ICBO
Charges & Fees:
Remittances to state of permit surcharges collected
Capital Outlay:
I
FUND: 101 DEPARTMENT: Protective Inspection DEPT 42400
I
BUDGET Actual Actual Budget YTD Sept Requested Proposed Adopted
ITEM 2001 2002 2003 2003 2004 2004 2004
I Staffing 68,841 77,595 91,670 65,137 95,676 95,676 95,676
Supplies/Materials 1,030 361 400 43 850 850 850
Support Services 6,176 8,715 9,550 3,587 10,270 10,270 10,270
I Charges & Fees 0 0 0 0 0 0 0
Capital Outlay 383 287 2,100 0 1,350 1,350 1,350
Transfers 0 0 0 0 0 0 0
I TOTAL 76,431 86,958 103,720 68,768 108,146 108,146 108,146
I SERVICE INDICATORS:
No. of permits issued
New Homes 10 50 50 50 50
I Additions/Other 475 600 600 600 600
Avg inspections/permit
New Homes 8-10 8-10 8-10 8-10 8-10
I Additions/Other 2-8 2-8 2-8 2-8 2-8
Commeroial/lndustrial: 1 2 2 2
COST INDICATORS:
I Expenditures 76,431 86,958 103,720 68,768 108,146 108,146 108,146
- Program Revenues
Building Permits 175,000 82,898
I State Surcharges 500
Rental Housing Licenses 3,500
= Levy Dollars 76,431 86,958 (75,280) (14,130) 108,146 108,146 108,146
I STAFFING:
Full time:
Building Official 1.00 1.00 1.00 1.00 1.00 1.00 1.00
I Planning Dir .05 .05 .05 .05 .05 .05 .05
Planning Asst .30 .30 .30 .30 .20 .20 .20
Secretary/Recept .10 .10 .10 .10 .10 .10 .10
I
I
I
I
I
I
I 39
40
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
FUND:
101 General
DEPARTMENT MISSION:
Enforce animal control ordinances.
DEPARTMENT: Animal Control
DEPT NO:
42700
DESCRIPTION OF ACTIVITY:
The department provides for contractual animal control, which includes patrol, detention
and disposition of stray domestic animals.
OBJECTIVES:
HIGHLIGHTS/COMMENTS:
Staffing:
Supplies/Materials:
Support Services:
Animal control contracts with City of Orono and Claws, Paws & Hooves
Charges & Fees:
Capital Outlay:
I
FUND: 101 DEPARTMENT: Animal Control DEPT 42700
I BUDGET Actual Actual Budget YTD Sept Requested Proposed Adopted
ITEM 2001 2002 2003 2003 2004 2004 2004
I Staffing 0 0 0 0 0 0 0
Supplies/Materials 0 0 0 0 0 0 0
Support Services 19,486 19,900 23,500 14,527 23,500 23,500 23,500
I Charges & Fees 0 0 0 0 0 0 0
Capital Outlay 0 0 0 0 0 0 0
Transfers 0 0 0 0 0 0 0
I TOTAL 19,486 19,900 23,500 14.527 23.500 23,500 23,500
I SERVICE INDICATORS: .
No. of Animal Complaints 47 50 42 50 50 50
I
COST INDICATORS:
I Expenditures 19,486 19,900 23,500 14,527 23,500 23,500 23,500
- Program Revenues
I = Levy Dollars 19,486 19,900 23,500 14,527 23,500 23,500 23,500
I STAFFING:
Full time:
I,
I
I
I
I
I
I
I
I 41
42
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
FUND:
101 General
DEPARTMENT MISSION'
DEPARTMENT: City Engineer
Provide engineering and construction management
services for the City.
DEPT NO:
43010
DESRIPTION OF ACTIVITY:
This department is responsible for general engineering services in the City, as well as
preparation of feasibility studies, plans and specifications, and on-site inspection of
City projects. The City Engineer also reviews all development proposals and plans.
OBJECTIVES'
- Assist the City in determining right-of-way needs
- Keep construction project files up-to-date and accurate
- Communicate in written form to affected residents at least two
(2) times during a construction project
- Provide in-house engineering where feasible
- Provide good public relations with property owners adjacent to construction projects
- Resolve construction issues promptly.
HIGHLIGHTS/COMMENTS'
Staffing:
.65 City Engineer/Public Works Director
.50 FIT Engineer Technician
.25 FIT Clerical
Supplies/Materials:
Computer maintainance/Upgrade
Books, Materials and Software
Support Services:
Contractual engineering for 2004
Contractual engineering technical assistance
Cellular phone Airtime & Pager
Conferences and mileage
Subscriptions and Memberships
Charges & Fees:
Capital Outlay:
44
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
FUND:
101 General
DEPARTMENT MISSION:
DEPT NO:
43050
Provide supervision and support for all public
works functions; provides for public works utilities,
shop and equipment maintenance and fuels
DEPARTMENT: Public Works Service
DESCRIPTION OF ACTIVITY:
The Public Works Service department is responsible for all general public works duties,
maintenance of all public works equipment, and maintenance of the public works facility.
OBJECTIVES:
- Perform preventative maintenance on all equipment within 100 miles or 10 hours
of scheduled service
- Perform 90% of City building repairs and preventative maintenance using City personnel
HIGHLIGHTS/COMMENTS:
Staffing:
Includes step increases
Supplies/Materials:
Includes motor fuel, maintenance of equipment and buildings, and inventory supply items
Support Services:
Uniforms for crew
Janitorial Services
Utilities and telephone service for public works building
Conference, mileage, meetings & seminars
Miscellaneous - damage to private property (mailboxes, etc)
Hazardous Waste Licenses
Miscellaneous equipment rentals
Memberships
Charges & Fees:
Capital Outlay:
Replacement Radios
Transfers:
Transfer to Equipment Replacement Fund
46
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
FUND:
101 General
DEPARTMENT MISSION:
DEPT NO:
43100
To maintain and upgrade City streets, parking areas
and storm water control systems in an efficient and
economical manner
DEPARTMENT: Streets & Roadways
DESCRIPTION OF ACTIVITY:
Includes ongoing maintenance consisting of street patching, street sweeping, roadside mowing,
painting of lane markings, and minor storm sewer repair.
OBJECTIVES:
- Maintain the pavement management system to aid in scheduling of street projects
- Paint lane markings on all designated streets
- Sweep each City street at least once annually
- Mow roadsides at least twice annually
- Visually inspect storm drainage grates annually and repair as needed
HIGHLIGHTS/COMMENTS'
Staffing:
2.0 LEO
0.33 Util. Maint. Ops.
Supplies/Materials:
Rock, gravel & bituminous for street & road repair
Support Services:
Safety training
Contracted road striping
Transfers:
Transfer to Street Replacement Fund
48
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
FUND:
101 General
DEPARTMENT MISSION:
DEPT NO:
43125
Provide snow and ice control for public streets and
City owned parking lots to ensure the safe and
efficient movement of traffic
DEPARTMENT: Snow & Ice Removal
DESCRIPTION OF ACTIVITY:
This department is reponsible for the plowing and removal of snow after a 2-inch or greater
snowfall has occured. Street sanding with a salt/sand mixture is used as a measure of ice control,
and is performed as needed.
OBJECTIVES:
- Remove snow and ice and complete salt/sand operations within 14 hours after
the end of a snow event
- Complete widening and clean up functions within 48 hours of a snow event
HIGHLIGHTS/COMMENTS:
Staffing:
.5 LEO
Supplies/Materials:
Sand and salt for ice control
50
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
FUND:
101 General
DEPARTMENT MISSION'
Provide for street lighting and traffic signals at
intersections and other locations throughout the
City for the safety of pedestrians and vehicular
traffic
DEPARTMENT: Traffic Control/St Lights
DEPT NO:
43160
DE$CRIPTION OF ACTIVITY:
Includes maintenace of semaphores and traffic control devices, and maintenance/replacement
of regulatory and informational road signs. Provides for electricity for street lights and traffic control
devices.
OBJECTIVES'
HIGHLIGHTS/COMMENTS'
Supplies/Materials:
Maintenance to semaphores and Hwy 7 & Vine Hill Road, Christmas Lake Road,
County Road 19, Hwy 41 and Old Market Road
Street signs & posts
Support Services:
52
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
FUND:
101 General
DEPARTMENT MISSION'
DEPT NO:
43200
Provide for the general sanitation and cleanliness
of the City and provide for the treatment of noxious
weeds on City properties.
DEPARTMENT: SanitationlWaste RmvlWeeds
DESCRIPTION OF ACTIVITY:
Activities include spraying of boulevards and roadways for weed control, and clean-up
of properties in violation of City zoning and sanitation codes, as necessary.
OBJECTIVES:
- Aid in private property cleanup complaints
- Resolve 100% of weed complaints
HIGHLIGHTS/COMMENTS:
Staffing:
Miscellaneous staff time for property clean-ups
Support Services:
Miscellaneous property clean-ups
Contracted weed spraying services
I
I FUND: 101 DEPARTMENT: Sanitation/Waste Removal/Weeds DEPT 43200
BUDGET Actual Actual Budget YTD Sept Requested Proposed Adopted
ITEM 2001 2002 2003 2003 2004 2004 2004
I
Staffing 1,619 1,138 650 37 1,267 1,267 1,267
I Supplies/Materials 0 0 0 0 0 0 0
Support Services 5,840 2,854 3,800 2,920 3,900 3,900 3,900
I Charges & Fees 0 0 0 0 0 0 0
I Capital Outlay 0 0 0 0 0 0 0
Transfers 0 0 0 0 0 0 0
TOTAL 7 .458 3,993 4,450 2,957 5,167 5,167 5,167
I
SERVICE INDICATORS:
I No of weed complaints 2 2 2 2 2 2
I No of notices served 1 1 1 1 1 1
No of parcels sprayed 0 0 0 0 0 0
I Miles/roadside sprayed 10 10 10 10 10 10
Spraying in Dollars 3,000 3,000 3,000 3,000 3,000 3,000
I COST INDICATORS:
I Expenditures 7.458 3,993 4,450 2,957 5,167 5,167 5,167
- Program Revenues
I Fed Disaster Aid
= Levy Dollars 7.458 3,993 4,450 2,957 5,167 5,167 5,167
I STAFFING:
I
I
I
I
I 53
54
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
FUND:
101 General
DEPARTMENT MISSION:
To provide diseased tree inspection services to
residents; to remove diseased trees located on City
property; and to maintain and trim trees located on
City rights-of-way and other property
DEPARTMENT: Tree Maintenance
DEPT NO:
43250
DESCRIPTION OF ACTIVITY:
This department is responsible for detection and removal of diseased and unsafe trees on City
rights-of-way and other properties, and pruning of trees on city property. Tree inspection
services are provided to citizens on an on-call basis.
OBJECTIVES:
- Remove 1 00% of diseased trees on public property
- Respond to all property owner requests to identify diseased trees
- Maintain and trim trees on City property which present a hazard to public
HIGHLIGHTS/COMMENTS:
Staffing:
Includes step increases
Supplies/Materials:
Small Tools
Paint for tree marking
Support Services:
Contracted tree and brush removal
Tree inspection certification
FUND:
101 General
DEPARTMENT MISSION:
Maintain City parks, trails & beaches to ensure safe
and enjoyable recreational amenities, and coordinate
recreational opportunities for City residents of all
ages and physical abilities
I
I
DEPARTMENT:
Parks & Recreation
DEPT NO:
45200
I
I
DESCRIPTION OF ACTIVITY
The department is responsible for the maintenance of all City parks, including
playgrounds, ballfields, trails, ice rinks, buildings and other play areas.
Winter ice skating, and summer recreation programs are coordinated within this department.
HIGHLIGHTS/COMMENTS:
Staffing:
Includes step increases
Part time includes Park Commission Secretarial
Seasonal includes Summer employees and Winter Rink Attendants
Supplies/Materials:
Small tools
Maintenance to park equipment and buildings
Rock, black dirt, gravel, sand, fertilizers, seed for parks
Support Services:
Park Coordinating Services
Contracted weed control in parks
Park utility and telephone charges
Rental of portable toilets
Contribution to Senior Recreational Program Services
Charaes & Fees:
Capital Outlay:
I
I
I
I
I
I
I
I
OBJECTIVES:
- Continue promoting the benefits of investing in Shorewood parks, and develop support for funding operation
and park improvements
- Identify needs and assist the Shorewood Parks Foundation in coordination of fund raising efforts (to replace
diminishing park dedication fees).
56
I
I
I
I
I
I
I
Transfers:
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
DEBT SERVICE FUNDS
Debt service funds are used to account for the payment of interest and principal on
long-term general o~ligation debt other than debt issued for and serviced primarily
by enterprise funds.
59
60
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
City of Shorewood
Schedule of Bonds Payable
12/31/03
Bonds Bonds Original
Outstanding Issued Paid Outstanding Issue
Item Fund Issue 12/31/02 2003 2003 12/31/03 Amount
#1 301 GO Improvement 1991 A (804B) 0 0 0 0 0
#2 302 GO Improvement 1993A (067C) 40,000 0 20,000 20,000 325,000
#3 601 . GO Water Revenue 1995A (225C) 1,155,000 0 130,000 1,025,000 1,920,000
#4 601 GO Water Revenue 1996A (A506) 575,000 0 55,000 520,000 860,000
#5 304 EDA Public Safety West Fire Facility
Lease Revenue Bonds, Series 2002A. 3,865,000 0 0 3,865,000 3,865,000
#6 304 EDA Public Safety Police Facility
Lease Revenue Bonds, Series 2002B 4,025,000 0 0 4,025,000 4,025,000
#7 304 EDA Public Safety East Fire Facility
Lease Revenue Bonds, Series 2002C 2,060,000 0 0 2,060,000 2,060,000
#8 305 EDA Public Safety West Fire Facility
Lease Revenue Bonds, Series 2003A 0 1,195,000 0 1,195,000 1,195,000
#9 305 EDA Public Safety Police Facility
Lease Revenue Bonds, Series 2003B 0 1,220,000 0 1,220,000 1,220,000
#10 601 Crossover Refunding Bonds, 2003 0 815,000 0 815,000 815,000
Totals $11,720,000 $3,230,000 $205,000 $14,745,000 $16,285,000
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
Uj Moody's 'nves.fDr5 Service
~L Global Credit Research
Municipal Credit Research
New Issue
Published 9 Jul 2003
Shorewood (City of) MN
Contacts
Christine Grima
Julia Harris
Edward Damutz
312-706-9952
312-706-9969
312-706-9953
Moody's Rating
Issue
Rating
General Obligation Water Revenue Crossover Refunding Bonds,
Series 2003
Sale Amount
Expected Sale Date
Rating Description
Aa3
$815,000
07/14/03
General Obligation Unlimited Tax
MOODY'S UPGRADES RATING TO Aa3 FROM A1 ON THE CITY OF SHOREWOOD
(MN) $14.8 MILLION G.O. DEBT, INCLUDING THE CURRENT ISSUE
Aa3 ASSIGNMENT TO SHOREWOOD'S $815,000 G.O. WATER REVENUE
CROSSOVER REFUNDING BONDS, SERIES 2003
Opinion
Moody's Investors Service has assigned a Aa3 rating to the City of Shorewood
$815,000 General Obligation Water Revenue Crossover Refunding Bonds, Series
2003. Concurrently, Moody's has upgraded the rating to Aa3 from A 1 on the city's
outstanding parity debt, affecting $14.8 million, including the current issue. The
bonds are secured by the unlimited tax pledge of the city, although debt service is
expected to be supported by net revenues from the city's water utility. Proceeds
will refund outstanding maturities of Series 1995A bonds for estimated net present
savings of $770,000, or 3.8% of refunded par. The upgrade and Aa3 rating reflects
the city's mature economy with affluent wealth levels and healthy tax base growth;
strong financial operations characterized by healthy reserve levels; and average debt
levels.
MATURE AND WEALTHY COMMUNITY EXPERIENCES HEALTHY TAX BASE
GROWTH
Located about 15 miles west of the Twin Cities along the southern shore of Lake
Minnetonka, Shorewood displays very strong wealth indices which are
approximately double the state norm, while full value per capita is also very strong
at $148,226. The city's tax base, valued at $1.1 billion in 2002, has grown at an
average annual rate of 11.5% annually over the past five years, mainly driven by
property appreciation. Shorewood, which has average home prices in the top 10 in
61
0)
N
-
-
:I:
CD
:J
:J <
CD !!!.
~. C
:J CD
() "0
o ~
C
:J
r+
-<
C
:J
CD
3
"0
o
-<
3
CD
:J
r+
-:j;:
o
w
w
(0
~
a
-n
S-
o
Ol
"0
;:t.
Ol
<f)o
~
en
N
N
Ol
N
o
o
o
- "0
~ 0
"0
S-
Ol
r+
o'
:J
CD
en
!:!.
N
o
o
N
<
!!!.
c
CD
<f)o
~
~
~
o'
:J
-
3
Ol
r+
CD
i" CD 3 r+ -'"0 men 0 :c-c: 0 g 03 !!!.O:3 g ~
::J ~CD~~-<OOCDC ::JC~~O~O
m enCDCD.ooo~en~~ur~~::JoCDa.oO
-< C ~ Ol~. CD -, CD CD CD en r+ CD CD o'c 0 CD _.0.
m ... CD a.... CD 3 r+ . Ol::J -, -' r+ iil ::J -<
CDr+a.CDS~ ~~-::Jr+r+"O~a.r+~~
-f r+ ~ -. r+ 0 r+ CD ... r+ a. CD CD Ol CD CD r+
;t> ~CD !:!.~~o 0 . en :i' en "'3 -3 0"' Ol CD
-f CD::J g CD CD a.O"'cg 3 iS~ !:!'. EOl r+~x~
en en CD Ol en CD "0 CD "0 CD C 0 3 rlC::J ~WO"CD
-l -<o-c 0 ::J-o-Ol~OOl'. OlO
- ~ CD a."O~"O gl O"Ol a.::;: a;- CD"'~ ~~en r+
() <IIg:CD"O::lC~~~o-COen en<ll[F.~CDen
m 3 Ol 0"' 0 r+ - I <: CD CD Ol Q. rl 3 ~ ~ co r+
...r+~ ~en<3 r+enr+oCD' ...~
--<r+ O_CCD :J~~-<~::J-f~OCD
en...~a-O"O<II~0::J03 r+~-~o
enCDOl Ol::J"O::lr+a;-cn~ ~-CD~r+~
CD .... r+ Ol . 0 -. Ol en ~
~CD<:~~Ol~O~a.~:J-<~ ~m ~
U, 01 <: ~ 0 :J S' 15 g: rl 0"' ~ 0"' -< g r+"O g: en
~%~~~~(Q~m~~~gN~~aa.~
"Oena._en~O"-r+r+~ooOo~Ox=o-
OrlO"'rlaCD-<::J~~<:J<: CDCD-3rl
~3<11~C"O-n~"'CD en<~~en3~0"'
-. CD <II - 0 -< ... <II Ol r+...... ::J::J CD CD C
:J::J~"O"Or+ CD'~~20Ql~0r+a.'"
~r+ CDCDN<-<rl......rl r+CD a.
. en~~~:Jo<ll<ll~m~mmO"'"O<OCD
lIl~~d~o~~ooCO~::JoQ-~~:J
~CDoO!!!.m<ll cCD:JCDO...OlCD-r+
O~::l::l . lIl~<<: <:eno::J-~O
C. -. 0"' ~ -f 01 Ol <: 0 <: rl ~ r+ ...... - .....
~~::l-<_~Ol:J;~OOO-O~:JCD
:::..~ ~ CD::J _...... ~~ ;:t._:J _,c CD 3
enO::J"'en a.::J ~ -< ~OO<llCDft'
C 0 CD CIl C -0 CD en ~
o a. ~. ~, - -< ~ "0 !:!, N - ::r U d' c S' g- ::J
~-<_~a.g~"O iil~c.n<f)o!!o~'" <II.-t' 3
OllllO"'~Q1<11CDO-<~N-o~m::r-lOl
"O<IIor+33~CDena~S~<II~CD~::l
<II x'" en _r+-<o rl3 -~CDm
~"O~_OlO.-tOen"""3~Olod-0~
rl CD 0 0 ~o' c c -. ~"O -. .., rl 0 0 CD'" -' CD
- 0... ......:J- -CDCD:J::J rl
000. -'~CD03~=CD-enOlO-<~
::J~~OCD::JOO... ::JO -<...._rlm~
rlO Ox . CD-.O::J.... .., 0"' CD
o -' -f ::l "0 !:!:. m Ol III ii" 0 <f)o CO"'o 0
OOOl::J <::Jen::J ~_~OO...<~
O::J~CD~ena.<IIO!!!.Ol-od:J.....CD~
C _. _, 0 oJ CD ..,.... -< < 0 0 a. 0 ... CD
.'" en ::J r+ ~,... CD Ol ~ CD.:J en ~ Ol :J
_....~~o<xrlen....o-<o _-=
::J::r-:J:J<II"O~~~CCDOa:J:Ja.<II
Ol:J en CD ......CDrlQlO ~CDX
g .... .... "< ~ ~ ~ -' en a. 0 ..,. CD -n-< 0 0"'"0
a.rlO<oooo:Jc-_en_:J _rl<ll
<II~Ol~~~rlO~:J ~::lCDN""O"'~
.., OOClla::r"'~"" <r+<:O~CCD
....OO~ CD 0.0 CD ~::r<OCD...~
O~O<:S'~ ~~:J ::rCD woo.
-< C <: ..... . _. <II
::JOrlr+ S'oJ rl:J
~r+CCD::r ~ -<
_' _ ~ CD iii'
- a. CD
~
~
o
o
-
-
-
-
-
-
;t>
<
m
::xl
;t>
G)
m
o
m
OJ
-I
OJ
C
::xl
o
m
Z
;t>
Z
o
I
s:
::j
m
o
()
;t>
-0
:::j
;t>
I
Z
m
m
o
en
en....rl;t>
CD~Di::l
.., CD :J
$'0 en 01
o -....... a.
CD.:t~9:
... ..,rl
CD 3 CD o'
"0 Ol a. :J
~ 5' <f)o !!!.
l<<Ol"(}len
:J -. (}l 0
r+:J"Oc
CD 00 0'"
a.:;:'og
m CD ...... 0
OCDO"'"
~ 2: 3 CD
~~rl<
.-<::r~
~r+CDC
#0 CCD
o q- ~ iii'
-~O""
CDlIl"'~
X -~CD
"O~Co
CD :J-'
::lCo.rl
0."0. -<..
;:+"rlOOO
Co... _
~ ~ ~ ii'
lIlOOC
:i' 0 '# g
~'#02'
-<O-:J
N......::lO'
au CD
o...r+
N~O:J
-'"0 -n
ur~-<
-'01 N
...... !:!, 0
::l::l 0
~~ N
o.u'
CD .., ....
p.~~
o yr Q'
~Q1.:t
....;:+
::r
o
C
~
~
-
-
0"' rl -n U -, 00 5' CJ)(\l CD m Q. S. ~ g 3'::
.....~c-:J en <(Orl (\l 0
---CD Dl-3 .... '-<:7=::leno
rt :J::JO C<CD~ :::..
~"O a. en 0 "0 ~ o' :J CD -. m <II 0.
(\l m rl rt Ol ~. r+ (\l C ~::l 5 (Jl :< ~
en ~ 0 0 ;;; l<< S. _ g: 0 ~ (\l rl Ol en
....Ol r+q:.o 0 cn~ C' -a. en ~!:!.CD
~oJ<< rl:J(\l'""' ~CD<X
a;- ... CD CD CD 01 ::r 0..0 ~'-n Ol iil CD "0
_g: (')0'" en CD en C:J-< -OO"'CD
Jg -< .!!! 0 ::l3 3 Q. ~ ~ ~ N :. ~ Co. g
-' ~ 3 Ill.... ~ -. III 0 -, 0 v.
~ ~ ;:t. CD CD = -< _.::l - 0 ~ _ ~ ....
Dl...!!!. ~~rten~-nNQI"'~~
2 !'l -0 ~ 01' 0;:;: ~ C <: - ~ S' CD
... -f ... CD -' -.J 01 ~ N:J <:"0 iii' ~ 0
<II 0 0. '# iii" 0';:t...,:J. ;:t.
i6 roO ~ 0 ~:J ~... ~ g. 0 0-<
o 0 ......~tC 0 CF-(\l< 01 -CD~....
0....... CD (\l mO
-' en .... <f)o... CD 0 CD C> 3 0 ...
.:t~W'wCDo.o""":J(\len::JQl3
c=N<(\l:Jr+C::Jo enOQl
~,:J 0"'"0 ~ If! "0 ~ g: ~ -n ~ cti S'
=9--< Oc (\l 0 . Ol Q..rl iil'~
m ..... 0 g: CD "0 g 4' - 0 CD (\l -.
en- ~ CD -'. ...... CD 3 0 -n <: III a.:J
:T 0. :J "';4 C < -.
o -. c Z 0 -< 0"'"0 :J -. 9- 0"' ~
- 0 0 0- 0 3 -' CD 0.:J -< Ol
~ ::r :i' ~ :J rl ~ ~ ~ 0"' ~ m rl Q:
-< ~ ~ ::r CD ::r X a. -< 01 Ol "0 ::r CD
Dl r+(\lCD rt-::l"'(\l
Ol<r+~::r "'OlQl CD ::n
0(\l:T-((\loo(Jl(\lx:J003:J
a CD CDr+~<:<IIO"OIIlOlOl
[F.O"' CD Nen ~ III CD en CD CD ~,-':J
o ~ :J o}!l CD en E 0 0 ~ g ;:l. Q.
......:J :J 8.... 0"'"0 CD 0 ...... -. en CD 01
rl C ~coen3<f)o::J :J-
~~!!oQl CD 0.< 0"0 N~ ~ 01 0
CD CD ::l ~ -. .........' en < :J U
o ... !:t 0. Q. (\l 0.<11 rt iii' N C (\l OCD ~
01 rl.... ~(\l "':J m
~<f)o::l~-<OJo.CD 3"OcOrl
-. (}l en -< ~ -< 0 :;:. :=: c CD - 0'
:J g CD' N ="0 :J G) (\l 0' en en ~ ::J
-n. ...o-...~<II-:JooCDen
-<oenO"'OO:JQI- ......cQlo.
...... (\l 0"' -' CD .., -
NO",~o-:J...~O<f)oog.c
000' CD(\l~!!!.CD""'~CD-<CD
o Ol 3 ~ <' 3 CIl OJ ~ Ol W ~ ... .-t
~ :J r+ 01 <II en rl :J ~ (}l -. CD 0
:J~:J . III 0."0 CD' <enOl
IIlCCDOlOlOl2: gQlOCDCD
CIlQl ~...en::;:Orl;:+O:J:<~
01 = C> CD ~ en .:t CD 0' ::r 9 rl CD iii'
=-<CD3crl'0"'::l-< :TenS'
OO:JCDO~ r+ ~CD....
~<~:Jd".CD ~ CDCJ)IIl-<
CD~!!!.""Om rleno
a. :J -. ~ _
0. CD
-
-
-
-
-
m
-f
::xl
o
Z
C>
-n
Z
;t>
Z
Q
)>
I
o
~
m
::xl
~
(5
Z
CJ)
()
:c
;t>
::xl
)>
()
-f
m
::xl
N
m
o
OJ
-<
;t>
s:
~
I
m
::xl
m
CJ)
m
::xl
<
m
CJ)
0-3'~3~
o 0 Dl (\l
~-g0::l-,
-. 0 0. m -,
:J < -< r.a ~_.
C CD - (\l
CD3en3::J
0. CDCD(')
en CD x ....
q;:l.u ;:+;:t.
o en CD ... (ii'
:JrlO CD en
~our"OQI
o ...
o."O.-t... CD
CDo~ur!>>
3"00...._.
01 CD _. ~ en
~a..:t~1Il
...... g: en- 00 ~
o rl 0 -.
... 01 III 3 3
~~XCD~
o O"'rl=
"001 III CD-<
CD 3 gl ~ ...
~ 0 I CD
-< 0. 8" g- !!l.
CD <: 0.
00 0 < (\l
rlO ::l ;:l.
CD ;:l. 01 iii'
< -':J -
~E o.Ol
o CD S' ~
-h......-4.
:J0=3
CD ~ - III
~ 0 ~2
o..~~Cil
~CO-o
~ <..g 03
o CD 3
u :J <II 3
3 0 ::J C
(\l ::l rl ::I
;:l. <g iii'~'
.. _..-+~
Ol :J Ol 01
en~~;:+
~ c6 is
~ "0 C
- -~
OJ ~ ~
en CD
-
-
-
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
Hennepin County unemployment (4/02): 3.9%
Overall debt burden: 3.1 %
Payout of principal (10 years): 42.5%
FY 2002 General Fund balance: $2.2 million (59.4% of General Fund revenues)
Median Family Income (as percentage of state): 183.0%
Per Capita Income (as percentage of state): 191.5%
Cl Copyright 2003, Moody's Investors Service, Inc. and/or its licensors including Moody's Assurance Company, Inc. {together
ALL INFORMATION CONTAINED HEREIN IS PROTECTED BY COPYRIGHT LAW AND NONE OF SUCH
INFORMATION MAY BE COPIED OR OTHERWISE REPRODUCED, REPACKAGED. FURTHER
TRANSMITTED, TRANSFERRED, DISSEMINATED, REDISTRIBUTED OR RESOLD, OR STORED FOR
SUBSEQUENT USE FOR ANY SUCH PURPOSE, IN WHOLE OR IN PART, IN ANY FORM OR MANNER
OR BY ANY MEANS WHATSOEVER, BY ANY PERSON WITHOUT MOODY'S PRIOR WRITTEN
CONSENT. All information contained herein is obtained by MOODY'S from sources believed by it to be
accurate and reliable. Because of the possibility of human or mechanical error as well as other factors.
however, such information is provided "as is" without warranty of any kind and MOODY'S, in particular.
makes no representation or warranty, express or implied, as to the accuracy, timeliness, completeness,
merchantability or fitness for any particular purpose of any such information. Under no circumstances shall
MOODY'S have any liability to any person or entity for (a) any loss or damage in whole or in part caused by,
resulting from, or relating to, any error (negligent or otherwise) or other circumstance or contingency within or
outside the control of MOODY'S or any of its directors, officers, employees or agents in connection with the
procurement, collection, compilation, analysis, interpretation, communication, publication or delivery of any
such infom1ation, or (b) any direct, indirect, special, consequential, compensatory or incidental damages
whatsoever (including without limitation, lost profits), even if MOODY'S is advised in advance of the
possibility of such damages, resulting from the use of or inability to use, any such information. The credit
ratings, if any, constituting part of the information contained herein are, and must be construed solely as,
statements of opinion and not statements of fact or recommendations to purchase. sell or hold any securities.
NO WARRANTY, EXPRESS OR IMPLIED, AS TO THE ACCURACY, TIMELINESS, COMPLETENESS,
MERCHANTABILITY OR FITNESS FOR ANY PARTICULAR PURPOSE OF ANY SUCH RATING OR
OTHER OPINION OR INFORMATION IS GIVEN OR MADE BY MOODY'S IN ANY FORM OR MANNER
WHATSOEVER. Each rating or other opinion must be weighed solely as one factor in any investment
decision made by or on behalf of any user of the information contained herein, and each such user must
accordingly make its own study and evaluation of each security and of each issuer and guarantor of. and
each provider of credit support for, each security that it may consider purchasing, holding or selling. Pursuant
to Section 17(b) of the Securities Act of 1933, MOODY'S hereby discloses that most issuers of debt
securities (including corporate and municipal bonds. debentures. notes and commercial paper) and preferred
stock rated by MOODY'S have. prior to assignment of any rating. agreed to pay to MOODY'S for appraisal
and rating services rendered by it fees ranging from $1,500 to $1,500,000.
83
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
CAPITAL PROJECTS FUNDS
Capital Projects funds are used to account for the acquisition and construction of
major capital facilities other than those financed by enterprise funds.
Public Facilities/Office Equipment Fund - This fund was established to account
for various capital improvement projects that may be financed without the need to
issue bonds.
Park Capital Improvement Fund - This fund accounts for parkland acquisition
and other capital improvements in the City parks.
Equipment Replacement Fund - This fund was established for the purpose of
funding the replacement of capital equipment.
Street Reconstruction Fund - This fund was established for the purpose of
funding the periodic reconstruction of City streets and roadways.
MSA Road Reconstruction Fund - This fund was established to account for the
accumulation of Municipal State Aid (MSA) to fund the periodic reconstruction
of MSA designated roads.
Trail Capital Improvement Fund - This fund was established for the purpose of
funding the periodic extension of the City trail system.
EDA Public Safety PolicelFire Construction Fund - This fund was established
to account for the construction of the Police and Fire Public Safety facility in the
City of Shorewood.
65
Capital Plan I
City of Shorewood, Minnesota I
CATEGORY SUMMARY BY DEPARTMENT I
2004 2008
thru
Department I
Category 2004 2005 2006 2007 2008 Total FuturE
Equipment Replacement I
Facilities/equipment 54,392 28,662 123,735 20,473 227,262
PW: Small Tools & Equip 18,200 18,200 30,795
PW: Vehicles 177,221 158,043 85,049 53,533 473,846 345,657
Total: 72,592 205,883 281,778 105,522 53,533 719,308 376,452 I
Land & Open Space Acquisition
Land & Open Space Acquisitions 5,000 10,000 10,000 10,000 10,000 45,000
Total: 5,000 10,000 10,000 10,000 10,000 45,000 I
Local Roadways
Roadways/streets 505,000 232,000 190,000 232,000 300,000 1,459,000
Total: 505,000 232,000 190,000 232,000 300,000 1,459,000 I
Municipal State Aid Streets
State Aid Roadways 5,152,200 5,152,200 I
Total: 5,152,200 5,152,200
Municipal Water System
Water: Distribution 70,000 70,000 70,000 210,000 I
Water: Towers 50,000 50,000
Water: Wells 650,000 21,000 21,000 22,000 22,000 736,000 21 ,045
Total: 770,000 91,000 91,000 22,000 22,000 996,000 21,045
Parks I
Park Improvements 22,000 10,000 10,000 10,000 10,000 62,000
Total: 22,000 10,000 10,000 10,000 10,000 62,000
Public Facilities/Office Equip I
Facilities/equipment 35,500 686,500 27,250 10,000 10,000 769,250
Total: 35,500 686,500 27,250 10,000 10,000 769,250
Sanitary Sewer I
Sanitary Sewer 43,000 128,000 131,000 123,000 116,000 541,000
Total: 43,000 128,000 131,000 123,000 116,000 541,000 I
Stormwater Management
Stormwater Management 266,100 30,000 30,000 30,000 30,000 386,100
Total: 266,100 30,000 30,000 30,000 30,000 386,100 I
GRAND TOTAL: 6,871,392 1,393,383 771,028 542,522 551,533 10,129,858 397,497
I
I
I
66 I
I Capital Plan
I City of Shorewood, Minnesota
I PROJECTS BY DEPARTMENT
2004 thru 2008
I
I Department Project# Priority 2004 2005 2006 2007 2008 Total
I Equipment Replacement
Backhoe E-02-22 0 64,459 64,459
Floor Sweeper E-02-46 0 12,401 12,401
F350 4x4 Pickup w/plow E-02-53 0 30,285 30,285
I F350 4x4 Pickup w/plow E-02.55 0 30,285 30,285
F350 & Flatbed E-03-49 0 36,558 36,558
I Pump - 4' Discharge E-03-50 0 24,336 24,336
AMT - John Deere 622 E-04-40 0 13,000 13,000
Speed Awareness Display E-04-50 0 0 21,900 21,900
I Van - Oldsmobile E-04-62 0 19,864 19,864
Snow Thrower - John Deere 826 E-Q4-91 0 780 780
Snow Thrower E-04-92 0 780 780
I Attach. Flail side mower E-04.93 0 13,312 13,312
Attach. Flail rear mower E-Q4.94 0 6,656 6,656
I Dump w/Plow and SND E-05-54 0 121,485 121,485
Groundsmaster Mower E-05-67 0 18,200 . 18,200
Attach - Cabs for Groundmaster E-05-85 0 4,326 4,326
I Dump Truck. Ford L8000 E-06-33 0 123,735 123,735
Bobcat E-06-63 0 19,307 19,307
Trail King Trailer E.07-21 0 8,189 8,189
I Water Truck E-07-45 0 97,344 97,344
Mower - Toro Groundsmaster 3250 E-07-70 0 20,473 20,473
Tractor - Ford 3910 E-08-35 0 31,633 31,633
I
Equipment Replacement Total 72,592 205,883 281.778 105,522 53,533 719,308
I Land & Open Space Acquisition
Land Conservation Easements LO-04.Q1 0 5,000 10,000 10,000 10,000 10,000 45,000
I Land & Open Space Acquisition Total 5,000 10,000 10,000 10,000 10,000 45,000
Local Roadways
I Brand Circle Pavement Reclamation LR-01-Q4 0 41 ,500 41,500
Amlee Road Pavement Reclamation LR-01-06 0 62,500 62,500
Bituminous Overlays LR-03-04 0 90.000 90,000 90,000 90,000 90,000 450,000
I Bnuminous Sealcoating LR-03-05 0 60,000 60,000 60,000 60,000 60,000 300,000
Wedgewood Drive Overlay & Reconstruction LR-Q4-01 0 251,000 251,000
I 67
Department Project# Priority 2004 2005 2006 2007 2008 Total I
Pavement Reclamation Wood Duck Circle LR-OS-01 0 82,000 82,000
Anthony Terrace Reconstruction LR-06-01 0 40,000 40,000 I
Beverly Dr Pavement Reclamation LR-07-01 0 82,000 82,000
Bracketts Rd Pavement Reclamation LR-OS-01 0 150,000 150,000 I
Local Roadways Total 505,000 232,000 190,000 232,000 300,000 1,459,000
Municipal State Aid Streets I
Vine Hill Road - Mill and Overlay MSA-03-05 0 104,000 104,000
Yellowstone Trail- Bit Overlay MSA-04-01 0 72,000 72,000
CR 19 Intersection Realignment MSA03-o6 0 4,976,200 4,976,200 I
Municipal State Aid Streets Total 5,152,200 5,152,200
Municipal Water System I
Badger Well House Reconstruction W-03-03 3 480,000 480,000
Woodhaven Well Interconnect W-03-OS 0 140,000 140,000 I
Water Meter Radio Read Project W-Q3-06 0 70,000 70,000 70,000 210,000
Amesbury Submersible Well - Pull & Inspect W-04-01 3 21,000 21,000
SE Area Water Tower - painting W-04-06 0 50,000 50,000 I
SE Well - Install VFD W-04-07 0 18,000 18,000
Amesbury Polyphosphate System W-04-08 0 12,000 12,000 I
Boulder Bridge Submersible Well- Pull & Inspect W-05-o1 3 21,000 21,000
S.E. Area Uneshaft Well- Pull & Inspect W-06-01 3 22,000 22,000
Amesbury Uneshaft Well- Pull & Inspect W-07-02 0 22,000 22,000 I
Municipal Water System Total no,ooo 91,000 91,000 22,000 22,000 996,000
Parks I
Freeman Park Walkway P-04-o1 0 12,000 12,000
Skate Park Improvements P-04-02 0 10,000 10,000 I
Park Improvements P-04-03 0 10,000 10,000 10,000 10,000 40,000
Parks Total 22,000 10,000 10,000 10,000 10,000 62,000 I
Public Facilities/Office Equip
Network (Computer) Upgrade PF-01-Q3 0 17,250 17,250 I
Computer Upgrades PF-03-OS 3 10,000 10,000 10,000 10,000 10,000 50.000
Municipal Liquor Store PF-03-07 0 20,000 676,500 696,500
Public Works Building Remodel PF-04-Q3 0 5,500 5,500 I
Public Facilities/Office Equip Total 35,500 686,500 27,250 10,000 10,000 769,250
Sanitary Sewer I
Infiltration and Inflow Reduction SS-os-o5 3 25,000 25,000 25,000 25,000 25,000 125,000
Lift Station 15 Rehabilitation SS-03-06 3 18,000 81,000 99,000 I
Lift Station 17 Rehabilitation SS-04-01 3 22,000 81,000 103,000
Lift Station 16 Rehabilitation SS-05-01 3 25,000 79,000 104,000
Lift Station 12 Rehabilitation SS-07 -01 0 19,000 91,000 110,000 I
68 I
I Department Project# Priority 2004 2005 2006 2007 2008 Total
I Sanitary Sewer Total 43,000 128,000 131,000 123,000 116,000 541,000
I
Stormwater Mana~ement
Gideon Glen Improvements
Glen Road Drainage
Harding Lane Drainage
Boulder Bridge Lift Station
Mise Stormwater Projects
STM-04-01
STM-04-02
STM-04-03
STM.04.04
STM.04-05
0 183,300 183,300
0 25,000 25,000
0 30,000 30,000
0 82,800 82,800
0 30,000 30,000 30,000 90,000
291,100 30,000 30,000 30,000 30,000 411,100
6,896,392 1,393,383 n1,028 542,522 551,533 10,154,858
I
I
Stormwater Management Total
GRAND TOTAL
I
I
I
I
I
I
I
I
I
I
I
I
I
I
69
Capital Plan I
City of Shorewood, Minnesota I
PROJECTS BY DEPARTNIENT AND CATEGORY I
2004 thru 2008
Department I
Category 2004 2005 2006 2007 2008 Total Future
Equipment Replacement I
Facilities/eauioment
Pump - 4' Discharge 24,336 24,336 I
AMT - John Deere 622 13,000 13,000
Van - Oldsmobile 19,864 19,864
Snow Thrower - John Deere 826 780 780
Snow Thrower 780 780 I
Attach. Flail side mower 13,312 13,312
Attach - Flail rear mower 6,656 6,656
Attach - Cabs for Groundmaster 4,326 4,326
Dump Truck - Ford LeoOO 123,735 123,735 I
Mower - Toro Groundsmaster 325D 20,473 20,473
Total: 54,392 28,662 123,735 20,473 227,262
PW: Small Tools & Eouio I
Air Compressor 14,409
Groundsmaster Mower 18,200 1 8,200
42"-48" Walk-behind Mower 4,518 I
Side-mount Flail Mower 11,868
Total: 18,200 18,200 30,795
PW: Vehicles I
Dump Truck 132,316
Backhoe 64,459 64,459
Floor Sweeper 12,401 12,401
F350 Dump 61,786 I
F350 4x4 Pickup w/plow 30,285 30,285
F350 4x4 Pickup w/plow 30,285 30,285
F350 & Aatbed 36,558 36,558
Speed Awareness Display 21,900 21 ,900 I
Dump w/Plow and SND 121,485 121 ,485
Bobcat 19,307 19,307
Trail King Trailer 8,189 8,189 I
Water Truck 97,344 97,344
Sandpro 12,098
Dump Truck 136,654
Tractor - Ford 3910 31,633 31,633 I
Trailer 2,803
Total: 177,221 158,043 85,049 53,533 473,846 345,657
Department Total: 72,592 205,883 281,778 105,522 53,533 719,308 376,452 I
Land & Open Space Acquisition
Land & Ooen Soace ACQuisitions I
Land Conservation Easements 5,000 10,000 10,000 10,000 10,000 45,000
Total: 5,000 10,000 10,000 10,000 10,000 45,000
Department Total: 5,000 10,000 10,000 10,000 10,000 45,000 I
70 I
I Department
Category 2004 2005 2006 2007 2008 Total Future
I Local Roadways
I Roadwavslstreets
Brand arcle Pavement Reclamation 41,500 41,500
Amlee Road Pavement Reclamation 62,500 62,500
Bituminous Overlays 90,000 90,000 90,000 90,000 90,000 450,000
I Bituminous Sealcoating 60,000 60,000 60,000 60,000 60,000 300,000
Wedgewood Drive OVerlay & Reconstruction 251,000 251,000
Pavement Reclamation Wood Duck Circle 82,000 82,000
Anthony Terrace Reconstruction 40,000 40,000
I Beverly Dr Pavement Reclamation 82,000 82,000
Bracketts Rd Pavement Reclamation 150,000 150,000
Total: 505,000 232,000 190,000 232,000 300,000 1,459,000
I Department Total: 505,000 232,000 190,000 232,000 300,000 1,459,000
Municipal State Aid Streets
I State Aid Roadwavs
Vine Hili Road - Mill and Overlay 104,000 104,000
Yellowstone Trail - Bit Overlay 72,000 72,000
CR 19 Intersection Realignment 4,976,200 4,976,200
I Total: 5,152,200 5,152,200
Department Total: 5,152,200 5,152,200
I Municipal Water System
Water. Distribution
I Water Meter Radio Read Project 70,000 70,000 70,000 210,000
Total: 70,000 70,000 70,000 210,000
Water: Towers
I SE Area Water Tower - painting 50,000 50,000
Total: 50,000 50,000
I Water. Wells
Badger Well House Reconstruction 480,000 480,000
Woodhaven Well Interconnect 140,000 140,000
Amesbury Submersible Well - Pull & Inspect 21,000 21,000
I SE Well- Install VFD 18,000 18,000
Amesbury Polyphosphate System 12,000 12,000
Boulder Bridge Submersible Well- Pull & Inspect 21,000 21,000
S.E. Area Lineshaft Well- Pull & Inspect 22,000 22,000
I Amesbury Lineshaft Well - Pull & Inspect 22,000 22,000
Boulder Bridge Well #2 - Pull & Inspect 21,045
Total: 650,000 21,000 21,000 22,000 22,000 736,000 21,045
I Department Total: 770,000 91 ,000 91,000 22,000 22,000 996,000 21 ,045
Parks
I Park imorovements
Freeman Park Walkway 12,000 12,000
Skate Park Improvements 10,000 10,000
I Park Improvements 10,000 10,000 10,000 10,000 40,000
Total: 22,000 10,000 10,000 10,000 10,000 62,000
Department Total: 22,000 10,000 10,000 10,000 10,000 62,000
I Public Facilities/Office Equip
I 71
I Capital Plan
I City of Shorewood, Minnesota
PROJECTS BY YEAR
I 2004 thru 2008
I
I Project Name Department Project # Priority Project Value
I 2004
AMT - John Deere 622 Equipment Replacement E-04-40 0 13,000
Speed Awareness Display Equipment Replacement E.{)4..50 0 0
I Van - Oldsmobile Equipment Replacement E-04-62 0 19,864
Snow Thrower - John Deere 826 Equipment Replacement E-04-91 0 780
Snow Thrower Equipment Replacement E-D4-92 0 780
I Attach - Flail side mower Equipment Replacement E-D4-93 0 13,312
Attach - Flail rear mower Equipment Replacement E-04-94 0 6,656
Groundsmaster Mower Equipment Replacement E-05-67 0 18,200
I Land Conservation Easements Land & Open Space Acquisition LO-04-01 0 5,000
Brand Circle Pavement Reclamation Local Roadways LR-D1-04 0 41,500
Amlee Road Pavement Reclamation Local Roadways LR-D1-06 0 62,500
I Bituminous OVerlays Local Roadways LR-03-04 0 90,000
Bituminous Sealcoatlng Local Roadways LR-03-05 0 60,000
Wedgewood Drive Overlay & Reconstruction Local Roadways LR-Q4-01 0 251,000
I Vine Hill Road - Mill and Overlay Municipal State Aid Streets M5A-03-05 0 104,000
Yellowstone Trail- Bil Overlay Municipal State Aid Streets M5A-04-D1 0 72,000
CR 19 Intersection Realignment Municipal State Aid Streets M5A03-06 0 4,976,200
I Badger Well House Reconstruction Municipal Water System W-03-03 3 480,000
Woodhaven Well Interconnect Municipal Water System W-03-D5 0 140,000
Water Meter Radio Read Project Municipal Water System W-03-06 0 70,000
I 5E Area Water Tower - painting Municipal Water System W-D4-06 0 50,000
SE Well- Install VFD Municipal Water System W-Q4-07 0 18,000
Amesbury Polyphosphate 5ystem Municipal Water System W-04-Q8 0 12,000
I Freeman Park Walkway Parks P-Q4-D1 0 12,000
Skate Park Improvements Parks P-Q4-02 0 10,000
Computer Upgrades Public Facilities/Office Equip PF-03-06 3 10,000
I Municipal Liquor 5tore Public Facilities/Office Equip PF-D3-07 0 20,000
Public Works Building Remodel Public Facilities/Office Equip PF-Q4-03 0 5,500
Infiltration and Inflow Reduction Sanitary Sewer 55-03-05 3 25,000
I Lift Station 15 Rehabilitation Sanitary Sewer 55-03-06 3 18,000
Gideon Glen Improvements Stormwater Management STM-Q4-01 0 183,300
Glen Road Drainage Stormwater Management STM-04-02 0 25,000
I Boulder Bridge Lift Station Stormwater Management STM-04-04 0 82,800
Total for 2004 6,896,392
I 2005
F350 4x4 Pickup w/plow Equipment Replacement E-02-53 0 30,285
F350 4x4 Pickup w/plow Equipment Replacement E-02-55 0 30,285
I 73
Project Name Department Project # Priority Project Value I
Pump - 4' Discharge Equipment Replacement E.oS-SO 0 24,336 I
Attach - Cabs for Groundmaster Equipment Replacement E-OS-BS 0 4,326
Bobcat Equipment Replacement E-06-63 0 19,307
Water Truck Equipment Replacement E-07-45 0 97,344 I
Land Conservation Easements Land & Open Space Acquisition LO-04-01 0 10,000
Bituminous Overlays Local Roadways LR-03-04 0 90,000
Bituminous Sealcoating Local Roadways LR-03-0S 0 SO ,000 I
Pavement Reclamation Wood Duck Circle Local Roadways LR-OS.o1 0 82,000
Water Meter Radio Read Project Municipal Water System W-03-06 0 70,000
Amesbury Submersible Well- Pull & Inspect Municipal Water System W-04-01 3 21 ,000 I
Park Improvements Parks P-04-Q3 0 10,000
Computer Upgrades Public Facilities/Office Equip PF.o3-06 3 10,000
Municipal Liquor Store Public Facilities/Office Equip PF-03-07 0 676,500 I
Infiltration and Inflow Reduction Sanitary Sewer SS-03-0S 3 25,000
Lift Station 1S Rehabilitation Sanitary Sewer SS-03.oS 3 81,000
Lift Station 17 Rehabilitation Sanitary Sewer SS-04-01 3 22,000 I
Harding Lane Drainage Stormwater Management STM-Q4-03 0 30,000
Total for 2005 1,393,383
2006 I
F350 & Flatbed Equipment Replacement E-03-49 0 3S,558
Dump w/Plow and SND Equipment Replacement E-OS-S4 0 121,485
Dump Truck - Ford LBOOO Equipment Replacement E-06-33 0 123,735 I
Land Conservation Easements Land & Open Space Acquisition LO-Q4-01 0 10,000
Bituminous Overlays Local Roadways LR-03-04 0 90,000
Bituminous Sealcoating Local Roadways LR-OS-OS 0 SO,OOO I
Anthony Terrace Reconstruction Local Roadways LR-06-01 0 40,000
Water Meter Radio Read Project Municipal Water System W-03-OS 0 70,000
80ulder Bridge Submersible Well - Pull & Inspect Municipal Water System W-OS-01 3 21,000 I
Park Improvements Parks P-04-03 0 10,000
Network (Computer) Upgrade Public Facilities/Office Equip PF-01-03 0 17,,250
Computer Upgrades Public Facilities/Office Equip PF-03.OS 3 10,000 I
Inflltration and Inflow Reduction Sanitary Sewer SS-03-0S 3 25,000
Lilt Station 17 Rehabilitation Sanitary Sewer S5-04-01 3 81,000
Lilt Station 16 Rehabilitation Sanitary Sewer SS-OS-01 3 25,000 I
Mise Stormwater Projects Stormwater Management STM.o4-0S 0 30,000
Total for 2006 771,028 I
2007
Backhoe Equipment Replacement E-02-22 0 64,459
Floor Sweeper Equipment Replacement E-02-46 0 12,401 I
Trail King Trailer Equipment Replacement E.o7-21 0 8,189
Mower - Toro Groundsmaster 32S0 Equipment Replacement E-07-70 0 20,473
Land Conservation Easements Land & Open Space Acquisition LO-04-01 0 10,000 I
Bituminous Overlays Local Roadways LR-03-04 0 90,000
Bituminous Sealcoating Local Roadways LR-03.oS 0 60,000
Beverly Dr Pavement Reclamation Local Roadways LR-07-01 0 82,000 I
S.E. Area Lineshaft Well- Pull & Inspect Municipal Water System W-OS-01 3 22,000
Park Improvements Parks P-04-03 0 10,000
Computer Upgrades Public Facilities/Office Equip PF-03-06 3 10,000 I
Infiltration and Inflow Reduction Sanitary Sewer 5S-03-0S 3 25,000
74 I
I
Deparlment
Project Name
lift Station 16 Rehabilitation
lift Station 12 Rehabilitation
Mise Stormwater Projects
Sanitary Sewer
Sanitary Sewer
Stormwater Management
I
Project # Priority Project Value
SS-OS-01 3 79,000
SS-07-01 0 19,000
STM-04-0S 0 30,000
Total for 2007 542,522
E-04-S0 0 21,900
E-08-3S 0 31,633
LO-04-01 0 10,000
LR-03-04 0 90,000
LR-OS-OS 0 60,000
LR-08-01 0 150,000
W-07-02 0 22,000
P-04-03 0 10,000
PF-03-06 3 10,000
SS-03-oS 3 25,000
55-07-01 0 91,000
STM-Q4-05 0 30,000
Total for 2008 551,533
10,154,858
I 2008
I
Speed Awareness Display
Tractor - Ford 3910
Land Conservation Easements
Bituminous Overlays
Bituminous Sealcoating
Bracketts Rd Pavement Reclamation
Amesbury Lineshaft Well- Pull & Inspect
Park Improvements
Computer Upgrades
Infiltration and Inflow Reduction
lift Station 12 Rehabilitation
Misc Stormwater Projects
Equipment Replacement
Equipment Replacement
Land & Open Space Acquisition
Local Roadways
Local Roadways
Local Roadways
Municipal Water System
Parks
Public Facilities/Office Equip
Sanitary Sewer
Sanitary Sewer
Stormwater Management
I
I
I
I
GRAND TOTAL
I
I
I
I
I
I
I
I
I
I
I
75
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
ENTERPRISE FUNDS
Enterprise funds are used to account for operations that are financed and operated
in a manner similar to private business, where the costs of providing services to
the general public are financed primarily through user charges.
Water Operations Fund - This fund is used to account for the activities of the
City water system.
Water Debt Service Fund - This fund is used to account for accumulation of
funds for, and payment of, debt service for the City water system.
Sewer Fund - This fund is used to account for the activities of the City sanitary
sewer system.
Recvcling Fund - This fund is used to account for the activities of the City
recycling program.
Stormwater Management Utility Fund - This fund is used to account for the
activities of the City Stormwater Management system.
Liquor Funds - These funds are used to account for the activities of the City's
off-sale liquor operation. The operation consists of two off-sale liquor store sites.
A portion of the net income from the operation is used to fund general fund
activities.
77
I
SUB FUND:
Water Operations
MISSION:
To provide a safe, clean, uninterrupted
supply of drinking water to all City
residents connected to the City water system.
I
FUND:
Water
FUND NO:
601
I
DESCRIPTION OF ACTIVITY:
Responsible for operation and maintenance of seven (7) well systems, including all
pumps and well houses, maintenence of water tower and treatment plant, and
extension of new watermain and construction of new water facilities, as necessary.
OBJECTIVES:
- Supply a safe, clean uninterrupted source of water to all connections
- Explore possibility of interconnecting with other communities
I
I
HIGHLlGHTS/COMMENTS:
I
Revenues:
Estimated water sales based on quarterly billing at a tiered rate of $2.95 - $3.75/1 ,000 gallons (Proposed 2004 rate change)
Connection and permit revenues
Miscellaneous Income includes interest income and Cellular Antenna Space Rentals
Anticipate issuing Water Revenue Bonds for approximately $ 800,000 . 2004
I
I
Expenses:
Staffing:
1.00 Utility Operator
.10 Senior Accounting Clerk
.20 Accounting Clerk
Supplies/Materials:
Office Supplies, including billing forms and postage
Maintenance contracts for computer hardware and software
Maintenance of gate valves
Small tools and chemicals for water treatment
.125 City Engineer
.25 Engineering Technician
.05 Sec./Recep.
I
I
I
Support Services & Charges:
Engineering
Water Operations Licenses & Training
Insurance on water system
Water testing & Water Quality Reporting
Water system analysis
Capital Outlay:
Woodhaven Well Inter-Connection ($140,000 - 2004)
Badger Well House Reconstruction ($480,000 - 2004)
Radio Read Meter project-Year 1 of 3 ($70,000 .2004)
SE Area Water Tower Paining ($50,000 - 2004)
SE Well-lnstall VFD ($18,000 - 2004)
Amesbury Polyphosphate System ($12,000 - 2004)
Other:
Water Purchased from other communities
Meter purchases
Well utility charges
Transfers to Water Debt Service Fund and General Fund
Depreciation (Non-cash expense accounts for future system replacement)
I
I
I
I
I
I
I
78
I
I
I FUND: #601 FUND: Water Operations DEPT # 49400
BUDGET Actual Actual Actual Budget YTD Sept Proposed Adopted
I ITEM 2000 2001 2002 2003 2003 2004 2004
REVENUE
Charges for Service 300,652 334,830 272,465 327,000 169,368 453,200 453,200
I Bond Proceeds 0 0 0 0 0 800,000 800,000
Misc. Revenue 116,648 72,778 104,106 76,000 42,624 71,000 71 ,000
I TOTAL REVENUE 417,300 407,608 376,571 403,000 211,993 1 ,324,200 1,324,200
EXPENSES
Staffing 12,595 17,829 48,431 100,312 52,160 99,654 99,654
I Supplies/Materials 48,861 52,542 47,565 49,750 33,016 49,250 49,250
Support Services & Charges 120,131 137,711 140,580 72,350 55,865 77,900 77 ,900
I Capital Outlay 5,111 935 0 270,200 0 800,000 800,000
Transfers 45,000 85,000 110,000 150,000 0 230,000 230,000
Depreciation 172,032 178,328 180,805 180,000 135,277 182,000 182,000
I TOTAL EXPENSES 403,730 472,345 527,381 822,612 276,318 1,438,804 1,438,804
SERVICE INDICATORS:
Miles of Water Line 16 16 16 16 16 16 16
I No. of Connections 1,120 1,120 1,120 1,120 1,172 1,200 1,200
No. of Hydrants 222 222 222 222 222 222 222
Avg Daily Consump- gals 430,000 430,000 430,000 430,000 430,000 430,000 430,000
I Water rate/1 000 gals 1.50/1.76 1.50/1.76 1.50/1.76 1.50/1.76 1.50/1.76 2.95/3.75 2.95/3.75
CASH FLOW IMPACT:
I Beginning Cash Balance 617,861 730,741 923,070 1,057,481 1,057,481 817,869 817,869
Revenues 417,300 407,608 376,571 403,000 211,993 1 ,324,200 1,324,200
Expenditures (403,730) (472,345) (527,381 ) (822,612) (276,318) (1,438,804) (1,438,804)
I Depreciation 172,032 178,328 180,805 180,000 135,277 182,000 182,000
Construction of Infrastructure
I Other Cash Flow Impacts (72,722) 78,738 104,417 0 0 0 0
Ending Cash Balance 730,741 923,070 1,057,481 817,869 1,128,434 885,265 885,265
STAFFING:
I Lt. Equip. Oper. .30 .30 .30 .30 .30 1.10 1.10
Engineer. Tech. .25 .25 .25 .25 .25
I Engineer .15 .15 .15 .125 .125
Sr. Acctg. Clerk .10 .10 .10 .10 .10 .10 .10
Acctg. Clerk .20 .20
I Sec.lRecep. .10 .10 .10 .10 .10 .05 .05
I
I
I 79
I
FUND: Water
MISSION:
To provide forthe retirement of
debt incurred to construct water
system improvements.
I
SUB FUND: Water Debt Service
FUND NO: 601
I
I
DESCRIPTION OF ACTIVITY:
Responsible for the accumulation of resources for the retirement of Water Fund debt, and
for the periodic payment of principal and interest.
I
I
OBJECTIVES:
To assure adequate resources to retire debt as scheduled, or more quickly if prudent.
I
I
HIGHLIGHTS/COMMENTS:
I
Revenues:
Property Tax Levy for Debt Service
Special Assessments on Water Improvements
Connection Charges
Interest Income
Transfers from Water Operating Fund
I
I
I
Expenses:
Staffing:
I
Supplies/Materials:
I
Support Services:
I
Charges & Fees:
I
Capital Outlay:
I
Other:
Debt service payments - Principal and interest
Fiscal Agent Fees
I
80
I
I
I FUND: #601 FUND: Water - Debt Service DEPT # 49400
BUDGET Actual Actual Actual Budget YTD Sept Proposed Adopted
I ITEM 2000 2001 2002 2003 2003 2004 2004
REVENUE
I Sp Assess/Connect Chgs 216,409 115,198 16,904 120,000 16,763 35,000 35,000
I Misc. Revenue 10 18 0 0 0 0 0
Transfers 40,000 85,000 110,000 150,000 0 230,000 230,000
I TOTAL REVENUE 256,420 200,216 126,904 270,000 16,763 265,000 265,000
EXPENSES
I Staffing 0 0 0 0 0 0 0
I Supplies/Materials 0 0 0 0 0 0 0
Support Services 0 0 0 0 0 0 0
I Charges & Fees 0 0 0 0 0 0 0
I Other - Debt Service 299,424 325,985 275,258 267,904 267,904 264,890 264,890
Capital Outlay 0 0 0 0 0 0 0
I Transfers 0 0 0 0 0 0 0
TOTAL EXPENSES 299,424 325,985 275,258 267,904 267,904 264,890 264,890
I SERVICE INDICATORS:
I Outstanding Debt, Year End 2,100,000 1,915,000 1,730,000 1,545,000 1,545,000 1,355,000 1,355,000
I CASH FLOW IMPACT:
Beginning Cash Balance 740,511 697,507 571,738 423,384 423,384 425,480 425,590
I Revenues 256,420 200,216 126,904 270,000 16,763 265,000 265,000
I Expenditures (299,424) (325,985) (275,258) (267,904) (267,904) (264,890) (264,890)
Ending Cash Balance 697,507 571,738 423,384 425,480 172,243 425,590 425,700
I STAFFING:
I
I 81
I
FUND:
Sanitary Sewer
MISSION:
To provide a safe, sanitary sewer
service to all City residents
I
SUBFUND:
DEPT NO:
Sanitary Sewer
611
I
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.
I
OBJECTIVES:
- Work with MCES to correct inflow and infiltration into the sanitary sewer system
. Work with MCES to reduce sewage treatment costs to the City
- Refurbish two lift stations per year
I
I
HIGHLIGHTS/COMMENTS:
Revenues:
Quarterly Sewer service charges at $70.00 per quarter
Interest revenue from investment of Sewer Fund cash balances
Other permit and connection fee revenues estimated based on 15 new homes
Repayment of Interfund Loan from Stormwater Management Fund for purchase of Gideon Glen land
Expenses:
Staffing:
.10 Senior Accounting Clerk
1.10 Light Equipment Operator
.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 for sewage flow into City of Excelsior trunk mains
Metropolitan Council Environmental Services sewage treatment charges
Capital Outlay:
Refurbish Lift Stations 15 (2004)
Inflow & Infiltration Reduction
Transfers:
Interfund Loan - Gideon Glen 2000
I
I
I
I
I
I
I
I
I
Depreciation (Non-cash expense accounts for future system replacement)
I
I
I
82
I
I
I FUND: # 611 FUND: Sanitary Sewer DEPT # 49450
BUDGET Actual Actual Actual Budget YTD Sept Proposed Adopted
I ITEM 2000 2001 2002 2003 2003 2004 2004
REVENUE
Charges for Service 860,283 788,944 809,913 840,500 467,932 840,500 840,500
I Transfers 0 0 0 38,877 0 37,397 37,397
TOTAL REVENUES 860,283 788,944 809,913 879,377 467,932 877,897 877,897
I EXPENSES
Staffing 18,973 18,795 32,068 104,812 40,960 104,154 104,154
I Supplies/Materials 16,742 10,013 21,334 18,500 10,430 22,750 22,750
Support Services & Charges 368,506 445,493 413,547 520,800 383,068 510,758 510,758
I Capital Outlay 0 0 0 197,700 11,767 121,500 121,500
Transfers 651,875 10,000 15,000 0 0 0 0
I Depreciation 198,974 200,821 202,291 202,000 151,693 205,000 205,000
TOTAL EXPENSES 1,255,070 685,122 684,239 1,043,812 597,918 964,162 964,162
I SERVICE INDICATORS:
Miles of Sewer Line 57 57 57 57 65 65 65
I No. of Connections 2,705 2,705 2,705 2,773 2,773 2,773 2,773
No. of Lift Stations 16 16 16 16 16 16 16
Sewer Charge 60.00 60.00 60.00 70.00 70.00 70.00 70.00
I CASH FLOW IMPACT:
Beginning Cash Balance 2,050,624 1,758,652 2,026,007 2,823,305 2,823,305 2,821,993 2,821,993
I Revenues 860,283 788,944 809,913 840,500 467,932 840,500 840,500
Expenditures (1,255,070) (685,122) (684,239) (1,043,812) (597,918) (964,162) (964,162)
I Depreciation 198,974 200,821 202,291 202,000 151,693 205,000 205,000
Other Cash Flow Impacts (96,159) (37,288) 469,334
I Ending Cash Balance 1,758,652 2,026,007 2,823,305 2,821,993 2,845,013 2,903,331 2,903,331
STAFFING: 0
I Sr. Acctg. Clerk .10 .10 .10 .10 .10 .10 .10
Acctg. Clerk .20 .20 .20 .20
Lt. Equip. OperJForeman .20 .20 .20 1.10 1.10 1.10 1.10
Receptionist/Secretary .10 .10 .10 .05 .05 .05 .05
I City Engineer .125 .125 .125 .125
Engineer. Technician .25 .25 .25 .25
I
I
I 83
I
SUBFUND:
Recycling
MISSION:
To provide weekly pickup of recyclables
to all City residents; provide for the annual
pickup of household and yard wastes
I
FUND:
Recycling
FUND NO:
621
I
DESCRIPTION OF ACTIVITY:
I
Weekly pick-up of newspaper, corrugated cardboard, recyclable plastics, glass and
metal, and other recyclable materials. Includes annual City curbside pickup of large household
items and brush. and operation of an annual brush/leaf composting drop-off site.
I
OBJECTIVES:
I
- Continue weekly pickup of recyclable materials
- Hold curbside pickup of household and yard wastes in the Spring of the year
- Provide a leaf and yard waste disposal site in Fall of the year
I
HIGHLIGHTS/COMMENTS:
I
County Aid is a Hennepin County grant
I
Revenues:
Charges for Service includes City Clean-up fees and a
City Recycling Fee of $1.75 per month per household
I
Tranfers/other includes transfers, interest income and revenue sharing from the Recycling Contractor
I
Expenses:
Staffing:
I
Miscellaneous staffing for City Clean-up and Yardwaste Disposal
I
Supplies/Materials:
Office Supplies
I
Support Services:
Recycling contract with E-Z Recycling - $2.35/householdlmonth for 2.720 households
City Clean-up costs
I
I
I
I
84
I
I
I FUND: #621 FUND: Recycling DEPT # 49550
I BUDGET Actual Actual Actual Budget YTD Sept Proposed Adopted
ITEM 2000 2001 2002 2003 2003 2004 2004
I REVENUE
County Aid 21,858 23,728 23,690 23,700 0 21,460 21,460
I Charges for Service 76,864 77,600 81,860 86,120 63,843 94,020 94,520
Transfers/other 2,346 2,017 2,831 1,250 949 2,000 1,500
I TOTAL REVENUE & 101,067 103,345 108,382 111,070 64,793 117,480 117,480
OTHER SOURCES
I EXPENSES
Staffing 0 653 498 3,914 590 2,920 2,920
I Supplies/Materials 1,840 983 1,694 750 990 1,300 1,300
Support Services & Charges 85,577 102,516 102,516 106,406 89,944 113,260 113,260
I Capital Outlay 0 0 0 0 0 0 0
Transfers 0 0 0 0 0 0 0
I TOTAL EXPENSES 87,417 104,151 104,709 111,070 91,524 117,480 117,480
SERVICE INDICATORS:
I Avg. mo. Participant Hshlds. 1,100 1,100 1,100 1,100 1,100 1,100 0
Avg. mo. Tonnage 70 70 70 70 70 70 0
I
CASH FLOW IMPACT:
I Beginning Cash Balance 26,317 35,975 37,785 41 ,457 41 ,457 41 ,457 41,457
I Revenues 101 ,067 103,345 108,382 111,070 64,793 117,480 117 ,480
Expenditures (87,417) (104,151) (104,709) (111,070) (91,524) (117,480) (117,480)
I Other Cash Flow Impacts (3,992) 2,616
Ending Cash Balance 35,975 37,785 41,457 41 ,457 14,726 41,457 41,457
I
STAFFING:
I .05 Receptionist/Secretary
I
I 85
I
FUND:
Stormwater Management
MISSION:
To provide proper suriace water and
ground water management throughout
the City.
I
SUBFUND:
Stormwater Management
FUND NO:
631
I
DESCRIPTION OF ACTIVITY:
I
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 funding for larger subwatershed drainage projects.
I
OBJECTIVES:
I
To build and maintain a stable fund balance in order to facilitate council priorities and projects.
HIGHLIGHTS/COMMENTS:
I
Revenues:
I
Stormwater Management Utility Charges
Misc. Revenue includes interest income and other misc. revenue (antenna)
Transfers from the General Fund
I
Expenses:
I
Staffing:
.05 Senior Accounting Clerk
.10 Light Equipment Operator
I
Supplies/Materials:
Drainage Correction/Maintenance Materials
I
Support Services:
Engineering
Contractual Services for drainage correction
I
Debt Service:
Repayment of Internal Loan to Sewer Fund for land purchase (Balance outstanding at end of 2004: $120,000)
I
Capital Outlay:
Glen Road Drainage Improvement ($25,000 - 2004)
Gideon Glen Drainage Project ($183,300 - To be funded by MCWD in 2004)
Boulder Bridge Storm Lift Station ($82,800 - To be funded with special assessments in 2004)
I
I
I
I
86
I
I
I FUND: #631 FUND: Storrnwater Management Utility DEPT # 49600
BUDGET Actual Actual Actual Budget YTD Sept Proposed Adopted
I ITEM 2000 2001 2002 2003 2003 2004 2004
REVENUE
I Special Assessments 0 0 0 0 0 82,800 82,800
I Charges for Service 52,134 48,425 43,985 59,500 27,946 59,500 59,500
Misc. Revenue 17,711 205,092 62,580 2,500 23,605 269,100 186,300
I Transfers 10,000 10,000 35,000 18,000 0 25,000 25,000
TOTAL REVENUE & 79,845 263,516 141,565 80,000 51,551 353,600 270,800
OTHER SOURCES
I EXPENSES
Staffing 2,340 2,473 2,299 11,528 1,598 11,979 11,979
I Supplies/Materials 642 600 3,376 2,000 0 2,300 2,300
I Support Services 7,699 44,399 12,486 18,095 19,669 18,200 18,200
Charges & Fees 0 0 0 0 0 0 0
I Other - Debt Service 0 206,767 29,863 38,877 0 37,397 37,397
Capital Outlay 0 0 0 0 0 291,000 291 ,000
I Transfers 0 0 0 0 0 0 0
TOTAL EXPENSES 10,682 254,240 48,023 70,500 21,267 360,876 360,876
I SERVICE INDICATORS:
I CASH FLOW IMPACT:
I Beginning Cash Balance 228,296 118,043 135,105 173,094 173,094 182,594 182,594
Revenues 79,845 263,516 141,565 80,000 51,551 353,600 270,800
I Expenditures (10,682) (254,240) (48,023) (70,500) (21,267) (360,876) (360,876)
Other Cash Flow Impacts (179,416) 7,785 (55,553) 0 0 0 (90,076)
I Ending Cash Balance 118,043 135,105 173,094 182,594 203,377 175,318 2,442
I STAFFING:
City Administrator .10 .10 .10 .10 .10
I Engineer .05 .05 .05 .05 .05
Lt. Equip. Oper.lForeman .10 .10 .10 .10 .10 .10 .10
Sr. Acctg. Clerk .10 .10 .05 .05 .05 .05 .05
I Acctg. Clerk .10 .10 .10 .10 .10
87
88
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
FUND NO:
640
MISSION:
To control the sale and distribution of
packaged alcholic beverages within the
City and to provide property tax relief
the use of operation profits.
FUND:
Liquor
SUBFUND:
DESCRIPTION OF ACTIVITY:
Provides for the sale of packaged alcoholic beverages to the general public.
OBJECTIVES:
- Effectively control the sale of packaged alcoholic beverages in the City
- Produce a reasonable net profit
- Find a new location for Tonka Bay Store
HIGHLIGHTS/COMMENTS:
Revenues:
Estimated liquor sales for two stores.
Expenses:
Staffing:
1 .00 Operations Manager
2.00 Assistant Managers
1 .00 Full Time Clerks
.15 Senior Accounting Clerk
10.00 Part time Sales Clerks
Supplies/Materials:
Office Supplies, Bags, Postage
Services & Charges:
Finance and Auditing Services
Consulting Services include a marketing study for the former Tanka Bay Store
General and Liquor Liability Insurance
Electric & Gas Utilities, and Refuse Hauling
Building Rental
Advertising
Credit Card Service Charges
Capital Outlay: To Be Determined
Transfers Out:
Transfer to General Fund
Misc. Revenue/Expenditures:
Interest Income & Service Charges
I
FUND: # 640 SUBFUND: Liquor Operations (Shorewood Village & Waterford) DEPT #
IBUDGET
Actual Actual Budget YTD Sept Proposed Adopted
ITEM 2001 2002 2003 2003 2004 2004
IREVENUE
Sales 2,622,145 2,507,063 1,986,000 1,187,206 2,224,045 2,224,045
I Cost of Goods
1,962,099 1,829,854 1,487,000 852,069 1,645,909 1,645,909
GROSS PROFIT 660,046 677,209 499,000 335,136 578,136 578,136
I EXPENSES
Staffing 290,934 302,702 233,473 160,472 272,477 272,477
I Supplies/Materials
12,912 11,325 8,000 5,477 8,000 8,000
I Services & Charges 258,685 232,728 194,790 140,405 196,830 196,830
Depreciation 9,662 10,085 7,300 7,271 14,800 14,800
I Capital Outlay 0 40,000 30,000 3,109 20,000 20,000
TOTAL EXPENSES 572,193 596,840 473,563 316,733 512,107 512,107
I TOTAL OPERATING INCOME (LOSS) 87,853 80,369 25,437 18,403 66,029 66,029
Transfers In/(Out) (10,000) (30,000) (20,000) 0 (30,000) (30,000)
I Misc. Revenue/(Expense) 4,502 10,680 9,000 5,390 11 ,000 11,000
NET INCOME (LOSS) 82,355 61,048 14,437 23,793 47,029 47,029
I SERVICE INDICATORS: 25.17% 27.01% 25.13% 28.23% 25.99% 25.99%
Gross Profit as a % of Sales
I Oper. Income as a % of Sales 3.35% 3.21% 1.28% 1.55% 2.97% 2.97%
CASH FLOW IMPACT:
I Beginning Cash Balance
Net Operating Income/Loss
I Depreciation
Other Cash Flow Impacts
Ending Cash Balance
I STAFFING:
I Full time:
Operations Manager 1.00 1.00 1.00 1.00 1.00 1.00
Assistant Manager 3.00 3.00 2.00 2.00 2.00 2.00
I Full Time Clerk 1.00 1.00 1.00 1.00
Sr. Acctg. Clerk .15 .15 .15 .15 .15 .15
Part time:
I Sales Clerks 15.00 15.00 15.00 15.00 10.00 10.00
I 89
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
ALLOCATED
APPROPRIATION
BOND ISSUE
BOND REFERENDUM
BUDGET
CAPITAL ASSET
CAPITAL OUTLAY
CAPITAL PROJECTS
FUND
COMMUNITY
DEVELOPMENT
BLOCK GRANT
(CDBG)
COMPARABLE
WORTH
CONTRACTUAL
COMPREHENSIVE
PLAN
DEBT LEVY
GLOSSARY
Distribute costs between reporting divisions or funds.
A grant of money by a legislative body to carry out a governmental
function or program.
A security representing a long-term promise to pay a certain sum of
money at specified times with a fixed rate of interest payable to the
holder.
An election for a bond issue.
(1) A statement describing the revenues and expenditures of all
governmental units, and (2) a mechanism for controlling,
managing, planning and evaluating the activities fo each
governmental unit.
Assets of significant value and having a useful life of several years
(Fixed Asset).
Expenditures for the acquisition of capital assets.
Established to account for the activity of capital projects
and equipment initiated or purchased by the City.
A federal grant program intended for community
development, rehabilitation and other public purposes
purposes that enhance the community.
Mandated by State law; a system which establishes
the value of jobs by weighting tasks performed on a point scale.
Ensures comparable wages for jobs within a comparable point
range within the jurisdiction.
A legally binding document that provides both parties perform
specific duties.
A comprehensive short-range and long-range plan intended to
guide the growth and development of a community, and one that
includes analysis, recommendations, and proposals for the
community's population, economy, housing, transportation,
community facilities, and land use.
A tax collected to pay for bonds issued.
91
DEBT SERVICE
FUND
ENTERPRISE FUND
EXPENDITURE
FISCAL DISPARITIES
FUND
FUND BALANCE
FUND EQUITY
GASB 34
GENERAL FUND
GOAL
GRANT
HOMESTEAD AND
AGRICULTURAL
Established to account for the accumulation of financial
sources for the payment of principal and interest on debt incurred
by the City. Debt incurred for improvements of an enterprise are
accounted for in the appropriate enterprise fund.
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
Established to account for operations that are financed and
managed in a manner similar to private business enterprises where
the intent of the governing body is that the costs (expenses,
including depreciation) of providing goods or services to the
general public on a continuing basis be financed or recovered
primarily through user charges.
The amount of cash or property paid, or to be paid, for a service
rendered, goods received, or an asset purchased.
A metropolitan program that distributes a percentage of property
tax revenue from new commercial and industrial development to
all metropolitan communities.
A fiscal and accounting entity with a self-balance set of accounts
that are segregated for the purpose of carrying on specific activities
or attaining certain objectives.
The residual balance resulting from all fiscal activity within a fund
which is available for appropriation.
The residual balance, reserved and unreserved, resulting from all
fiscal activity within a fund.
The new governmental financial reporting model for state and local
governments issued by the Governmental Accounting standards
Board (GASB) as Statement No. 34.
Used to account for all financial resources except those required to
be accounted for in another fund. The General Fund includes most
operating functions of City government.
A statement of broad direction, purpose, or intent based on the
needs of the community. A goal is general and timeless; that is, it
is not concerned with a specific achievement in a given time
period.
A contribution or gift of cash or other assets from another
government to be used or expended for a specified purpose,
activity or facility.
A State of Minnesota program that distributed revenue to
cities as a result of state reductions in property taxes
92
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
CREDIT AID (HACA)
JOINT POWERS
AGREElVIENT
LEVY LIMITS
MUNICIPAL STATE
AID PROGRAM (MSA)
MUNICIPAL STATE
AID STREETS (MSA)
OBJECTIVE
ORDINANCE
SPECIAL
ASSESSMENT
TAX INCREMENT
T AX LEVY
TAXING
JURISDICTION
TRANSFERS
TRUTH-IN-
TAXATION
ZONING
collected to keep property taxes at a reasonable level.
A contract between two or more government
jurisdictions to provide a common service.
Statutory restriction on amount of property tax that may be levied.
A State of Minnesota program which provides for the
distribution of highway user funds to qualifying cities over a
population of 5,000. Funds are appropriated annually for
construction and maintenance of MSA streets and roads.
Designated by the City to be eligible for Municipal State
Aid payments for construction and maintenance of collector streets
and roads.
Desired output which can be measured and achieved within a given
time period.
A municipal law.
A cost paid by landowners for specific improvements to
their property that adds at least as much value and benefit as the
amount of the special assessment.
The additional, or incremental, property taxes collected within a
tax increment district. Increments are the difference between the
taxes collected on the total value of the district and the taxes
collected on the original value of the district. Increments include
taxes levied by all taxing jurisdictions.
The total amount of dollars assessed in taxes against property for
the purpose of producing funds to meet financial obligations.
A geographic area permitted to tax landowners within.
Money moved from one fund to another with City Council
authorization.
A state law that provides citizens with notification of proposed
property tax changes through public hearings and newspaper
publications.
Regulation of land use by districts ensuring that certain land uses
are compatible.
93
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
CITY OF SHOREWOOD
GENERAL FUND DETAILED BUDGETS
95
I
FUND: 101 ACTIVITY: Mayor and Council DEPT 41110
Obj Actual Actual Budget YTD Sept Requested Proposed Adopted I
Code ITEM 2001 2002 2003 2003 2004 2004 2004
PERSONAL SERVICES
101 Regular Salaries I
102 O.T. Salaries
103 Part Time Salaries 12,600 12,600 12,600 9,450 12,600 12,600 12,600
121 PERA City Share
122 FICA City Share 964 964 964 723 964 964 964 I
131 Ins. City Share
141 MN Unemp Comp
151 Workers Comp
Total 13,564 13,564 13,564 10,173 13,564 13,564 13,564 I
SUPPLIES
200 Office Supplies
212 Motor Fuel & Lube I
221 Maint-Equipment
223 Maint-Buildings
240 Small Tools
245 General Supplies 725 544 1,500 423 1,200 1,200 1,200 I
Total 725 544 1,500 423 1,200 1,200 1,200
OTHER SERVICES
301 Financial I
302 Consulting
303 Engineering
304 Legal
321 Communication I
331 Travel, Cont,Sch 3,668 5,723 7,900 947 8,900 8,900 8,900
351 Print/Publish 9,397 14,444 10,000 9,463 2,000 2,000 2,000
360 Ins. -Total
380 Utilities- I
Gas./Elec.
400 Contractual 12,296 17,920 15,000 10,000 10,000 10,000
410 Rental
433 Dues & Subscriptions 37,364 39,196 38,000 35,535 38,000 38,000 38,000 I
437 Licenses-Taxes
440 ContinQency 11 ,019 2,303 40,000 0 30,000 30,000 30,000
Total 73,744 79,585 110,900 45,946 88,900 88,900 88,900
OTHER CHARGES I
54 State Surchgs
55 I nterest- I
Interfund Loan
56 Allocated Expense
trom other Depts
Total 0 0 0 0 0 0 0 I
CAPITAL OUTLAY
510 Land
520 Buildings I
540 Machinery-Equip
560 Furn & Fixtures
580 Other Improve
Total 0 0 0 0 0 0 0 I
TRANSFERS
720 Permanent
Total 0 0 0 0 0 0 0 I
TOTAL ACCOUNT 88,033 93,693 125,964 56,542 103,664 103,664 103,664
I
96 I
I
I
BUDGET COMMENTS: MAYOR AND COUNCIL
DEPT 41110
I
Code #
I
103 Council Salaries: Mayor $250/mo, Council $200/mo
122 City's portion of FICA tax
I
I
245 Awards and misc. supplies; Council Photos
I
331 Travel, Conferences, Schools
Appreciation Activities
I
351 Council Info Brochure
I
400 Community Survey
I
I
433 Subscriptions & Memberships
Lake Minnetonka Conservation District (LMCI
Assn of Metro Municipalities
League of MN Cities
Excelsior Chamber of Commerce July 4th
Other
I
440 Contingency
I
I
I
I
I
I
I
3,900
5,000
2,000
10,000
25,800
2,500
5,500
2,000
2,200
97
I
FUND: 101 General ACTIVITY: Administration DEPT 41300
Obj Actual Actual Budget YTD Sept Requested Proposed Adopted I
Code ITEM 2001 2002 2003 2003 2004 2004 2004
PERSONAL SERVICES
101 Regular Salaries 84,594 78,690 88,445 61,324 96,003 96,003 96,003 I
102 O.T. Salaries 0 0 0
103 Part Time Salaries 0 0 0
121 PERA City Share 3,793 4,493 4,891 3,394 5,309 5,309 5,309 I
122 FICA City Share 5,804 6,172 6,766 4,639 7,344 7,344 7,344
131 Ins. City Share 5,573 9,361 11,410 7,028 13,617 13,617 13,617
141 MN Unemp Camp
151 Workers Comp I
Total 99,764 98,716 111,512 76,384 122,273 122,273 122,273
SUPPLIES
200 Office Supplies I
212 Motor Fuel & Lube
221 Maint-Equipment
223 Maint-Buildings
240 Small Tools I
245 General Supplies 47 0 400 0 200 200 200
Total 47 0 400 0 200 200 200
OTHER SERVICES
301 Auditing! Accounting I
302 Consulting
303 Engineering
304 Legal I
321 Communication
331 Travel, Conf,Sch 3,791 3,793 4,900 2,342 4,500 4,500 4,500
351 PrinVPublish
360 Ins.-Total I
380 Utilities-
Gas.lElec.
400 Contractual 0 1,125 4,800 2,830 6,000 6,000 6,000
410 Rental I
433 Dues & Subscriptions 677 905 750 702 750 750 750
437 Licenses-Taxes
440 Misc. Services 16
Total 4,468 5,823 10,450 5,889 11,250 11,250 11,250 I
OTHER CHARGES
54 State Surchgs
55 Interest - I
Interfund Loan
56 Allocated Expense
from other Depts
Total 0 0 0 0 0 0 0 I
CAPITAL OUTLAY
60 Land
520 Buildings I
540 Machinery-Equip
560 Furn & Fixtures 324
580 Other Improve
Total 324 0 0 0 0 0 0 I
TRANSFERS
720 Permanent
Total 0 0 0 0 0 0 0 I
TOTAL ACCOUNT 104.603 104.539 122.362 82,273 133,723 133,723 133.723
I
98 I
I
I
BUDGET COMMENTS: ADMINISTRATION
DEPT 41300
I
Code #
I
101 1.0 Administrator's Salary
.33 Executive Secretary/Deputy Clerk
I
I
245 Books & Misc Supplies
I
I
I
331 MCMA, LMC, ICMA
Conferences, Education & Mileage
ICMA-San Diego 1800
MCMA-Brainerd 500
LMC-Duluth 500 Mileage& Exp-1200
Development Seminars 800
Mileage& Exp 900
I
I
400 Labor Relations Associates - 3000
HR Consulting Svcs. - 3000
I
433 Subscriptions & Memberships
ICMA
MCMA
MAMA
I
I
I
I
I
I
I
99
I
FUND: 101 General ACTIVITY: City Clerk DEPT 41400
Obj Actual Actual Budget YTD Sept Requested Proposed Adopted I
Code ITEM 2001 2002 2003 2003 2004 2004 2004
PERSONAL SERVICES
101 Regular Salaries 64,135 77,203 79,955 58,988 80,983 80,983 80,983 I
102 O.T. Salaries 289 616 0 173 200 200 200
103 Part Time Salaries 11,959 27,946 30,547 14,732 22,826 22,826 22,826
121 PERA City Share 4,972 5,224 5,510 4,032 5,846 5,846 5,846
122 FICA City Share 7,343 7,993 8,453 5,596 9,005 9,005 9,005 I
131 Ins. City Share 8,241 9,296 10,315 6,719 11,912 11,912 11,912
141 MN Unemp Comp
151 Workers Comp
Total 96,939 128,277 134,780 90,240 130,772 130,772 130,772 I
SUPPLIES
200 Office Supplies 11 ,432 11 ,548 17,700 7,625 14,500 14,500 14,500
208 Postage 4,762 5,267 17,000 4,150 15,500 15,500 15,500
212 Motor Fuel & Lube I
221 Maint-Equipment 500 0 625 0
223 Maint-Buildings
240 Small Tools
245 General Supplies 490 588 1.925 691 1,725 1,725 1,725 I
Total 17,184 17,404 37,250 12,467 31,725 31,725 31,725
OTHER SERVICES
301 Audit/Accounting I
302 Consulting 9,869 14,000 0
303 Engineering
304 Legal
321 Communication I
331 Travel, Conf,Sch 1,683 2,272 2,600 915 2,600 2,600 2,600
351 Print/Publish 7,115 7,010 8,000 2,878 7,500 7,500 7,500
360 Ins.-Total
380 Utilities- I
Gas.lElec.
400 Contractual 4,714 5,738 5,400 4,545 12,000 12,000 12,000
410 Rental
433 Dues & Subscriptions 265 155 250 214 250 250 250
437 Licenses-Taxes I
440 Misc. Services 0
Total 13,777 25,044 30,250 8,552 22,350 22,350 22,350
OTHER CHARGES I
54 State Surchgs
55 Interest-
Interfund Loan
56 Allocated Expense I
from other Depts
Total 0 0 0 0 0 0 0
CAPITAL OUTLAY
60 Land I
520 Buildings
540 Machinery-Equip 4,533 0 2,300 2,945 4,500 4,500 4,500
560 Furn & Fixtures 274 2,964 0 510 300 300 300 I
580 Other Improve 591 0 1.350 0
Total 5,398 2,964 3,650 3,456 4,800 4,800 4,800
TRANSFERS
720 Permanent I
71 Temporary
72 Refund-Reimburse.
Total 0 0 0 0 0 0 0
TOTAL ACCOUNT 133,298 173.689 205.930 114.714 189.647 189,647 189.647 I
I
100 I
I
I
BUDGET COMMENTS: CITY CLERK
DEPT 41400
I
I
Code #
101 .60 Executive Secretary/Deputy Clerk
.70 Parks Secretary
.25 Secr/Recp
.25 Acct. Clrk I
103 Part-time Comm Tech (15 hourslwk)
Website Administration
PIT temporary front desk help (100 hours x $11)
200 Office supplies, copier & printer paper & supplies 13,000
Newsletter - Supplies 1,500
208 Postage & postage permits (Regular) 8,500
Newsletter postage 7,000
245 General Supplies
LMC Directory - 9 copies 375
Truth in Taxation Notices 650
Henn Co Property Tax updates 200
Software upgrades 500
331 Travel, Conferences & Schools:
State Clerks Conference - Jean 600
Misc. Seminars, Mileage & MCFOA Mtgs 500
Computer Software Training 1,500
351 Legal Notices - All General Fund 7,500
except Capital Projects
I
I
I
I
I
I
I
Planning Commission I Park Comm (See planning & park dept buds)
400 Council Recording Secretary ($175 x 3 x 12 mos) 6,300
Newsletter Mail Service 4,800
Code Book Web Host 200
Code Book Update 200
Document Destruction 500 12,000
I
I
433 MCFOA Dues 50
IIMC - MN Clerk Assn. 130
Subscriptions 70
540 Capital Equip
Computers (3) 4500
560 Fumiture & Fixtures 300
I
I
I
I
I
I
101
I
FUND: 101 General ACTIVITY: Elections DEPT 41410
Obj Actual Actual Budget YTD Sept Requested Proposed Adopted I
Code ITEM 2001 2002 2003 2003 2004 2004 2004
PERSONAL SERVICES
101 Regular Salaries 10,779 10,779 10,779 I
102 O.T. Salaries
103 Part Time Salaries 12,000 12,000 12,000
121 PERA City Share 539 539 539
122 FICA City Share 1,743 1,743 1,743 I
131 Ins. City Share 1,509 1,509 1,509
141 MN Unemp Camp
151 Workers Camp
Total 0 0 0 0 26,569 26,569 26,569 I
SUPPLIES
200 Office Supplies 200 200 200
208 Postage 750 750 750 I
212 Motor Fuel & Lube
221 Maint-Equipment 625 625 625
223 Maint-Buildings
240 Small Tools I
245 General Supplies 1,383 500 500 500
Total 0 0 0 1,383 2,075 2,075 2,075
OTHER SERVICES
301 Audit/Accounting I
302 Consulting
303 Engineering
304 Legal
321 Communication I
331 Travel, Conf,Sch 150 150 150
351 Print/Publish 1,500 1,500 1,500
360 Ins.-Total
380 Utilities- I
Gas.lElec.
400 Contractual
410 Rental
433 Dues & Subscriptions I
437 Licenses-Taxes
440 Misc. Services
Total 0 0 0 0 1,650 1,650 1,650
OTHER CHARGES I
54 State Surchgs
55 Interest-
Interfund Loan
56 Allocated Expense I
from other Depts
Total 0 0 0 0 0 0 0
CAPITAL OUTLAY
60 Land I
520 Buildings
540 Machinery-Equip
560 Fum & Fixtures 1,800 1,800 1,800 I
580 Other Improve
Total 0 0 0 0 1,800 1,800 1,800
TRANSFERS
720 Permanent I
71 Temporary
72 Refund-Reimburse.
Total 0 0 0 0 0 0 0 I
TOTAL ACCOUNT 0 0 0 1.383 32,094 32.094 32,094
I
102 I
I
I BUDGET COMMENTS: ELECTIONS
DEPT 41410
I Code #
101 .20 Executive Secretary/Deputy Clerk
I 103 Election Judges
I 200 Election Supplies
I 208 Postage
221 Election maintenance contract
I
331 Travel, Conferences & Schools
I
351 Election Printing /Publishing
I
I
I
560 ADA Ramp at W1P1
I Voting Booths
I
I
I
I
I
I
I 103
I
BUDGET COMMENTS: FINANCE
DEPT 41500
I
Code#
I
101 .96 Finance Director
.60 Senior Accounting Clerk
.25 Accounting Clerk
I
I
I
200 Computer Checks, Budget Supplies, etc
221 Finance software support & enhancements
Fund accounting, Payroll, Util Bill Software
I
245 Books & Publications
I
I
331 Travel, Conferences & Schools:
GFOA Local
GFOA State
Mileage
Educational. Tuition Reimbusement
Nat'l. GFOA Conference
I
I
351 Publish financial statements and budget
360
I
400 GASB 34 Consulting
I
433 GFOA. State and National
Public Investor, Goveming, Other
Submittal fee. GFOA Cert. of Excellence
Submittal fee - GFOA Distinguished Budget Award
I
450 Bank & Broker Servce Charges
540 Computer Upgrades
560
I
I
I
I
104
I
I
FUND: 101 General ACTIVITY: Finance DEPT 41500
I Obj Actual Actual Budget YTD Sept Requested Proposed Adopted
Code ITEM 2001 2002 2003 2003 2004 2004 2004
PERSONAL SERVICES
I 101 Regular Salaries 86,625 93,747 95,721 78,024 106,495 106,495 106,495
102 O.T. Salaries
103 Part Time Salaries
121 PERA City Share 4,487 5,199 5,293 4,317 5,889 5,889 5,889
I 122 FICA City Share 6,547 7,142 7,323 5,969 8,147 8,147 8,147
131 Ins. City Share 8,342 10,942 12,348 8,798 15,105 15,105 15,105
141 MN Unemp Comp
151 Workers Comp
I Total 106,001 117,031 120,685 97,108 135,636 135,636 135,636
SUPPLIES
200 Office Supplies 550 1,084 800 185 500 500 500
I 212 Motor Fuel & Lube
221 Maint-Equipment 1,817 0 17,500 4,189 17,500 17,500 17,500
223 Maint-Buildings
240 Small Tools
I 245 General Supplies 503 6 200 169 350 350 350
Total 2,870 1,090 18,500 4,543 18,350 18,350 18,350
OTHER SERVICES
301 Audit! Accounting 0 0 0 0 0 0
I 302 Consulting
303 Engineering
304 Legal
321 Communication
I 331 Travel, Conf,Sch 3,714 4,742 5,900 3,242 5,200 5,200 5,200
351 Print!Publish 747 645 1,300 237 1,200 '1,200 1,200
360 Ins-Unallocated 261 0 500
380 Utilities-
I Gas.lElec.
400 Contractual 0 745 1,000 1,000 1,000
410 Rental
433 Dues & Subscriptions 629 525 1,000 580 800 800 800
I 437 Licenses-Taxes
440 Misc. Services
450 Service ChQs. 1,071 1,231 1,500 585 1,500 1,500 1.500
Total 6,422 7,888 10,200 4,644 9,700 9,700 9,700
I OTHER CHARGES
54 State Surchgs
55 Interest-
Interfund Loan
I 56 Allocated Expense
from other Depts
Total 0 0 0 0 0 0 0
I CAP IT AL OUTLAY
60 Land
520 Buildings
540 Machinery-Equip 1,055 1,500 1,482 1,500 1,500 1,500
I 560 Fum & Fixtures 1,000 1,083 0 0 0
580 Other Improve 1,065 533 500 500 500
Total 1,065 1,055 2,500 3,098 2,000 2,000 2,000
TRANSFERS
I 720 Permanent
71 Temporary
72 Refund-Reimburse.
I Total 0 0 0 0 0 0 0
TOTAL ACCOUNT 116,357 127.064 151 ,885 109,393 165,686 165.686 165,686
I
I 105
I
FUND: 101 General ACTIVITY: Professional Services DEPT 41600
Obj Actual Actual Budget YTD Sept Requested Proposed Adopted I
Code ITEM 2001 2002 2003 2003 2004 2004 2004
PERSONAL SERVICES I
101 Regular Salaries
102 O.T. Salaries
103 Part Time Salaries
121 PERA City Share I
122 FICA City Share
131 Ins. City Share
141 MN Unemp Camp
151 Workers Comp I
Total 0 0 0 0 0 0 0
SUPPLIES
200 Office Supplies
212 Motor Fuel & Lube I
221 Maint-Equipment
223 Maint-Buildings
240 Small Tools
245 General Supplies I
Total 0 0 0 0 0 0 0
OTHER SERVICES
301 Audit/Accounting 7,900 8,820 11 ,200 8,539 12,000 12,000 12,000 I
302 Consulting
303 Engineering
304 Legal 115,918 82,385 100,000 46,619 95,000 95,000 95,000
321 Communication I
331 Travel, Conf,Sch
351 Print/Publish
360 Ins.-Total
380 Utllities- I
Gas.lElec.
400 Contractual - Assessor 73,654 78,189 80,600 n,727 73,000 73,000 73,000
410 Rental
433 Subscrip-Member I
437 Licenses-Taxes
440 Misc. Services 0 0 15,000 15,000 10,000 10,000 10,000
450 Service Chas.
Total 197,472 169,394 206,800 147,885 190,000 190,000 190,000
OTHER CHARGES I
54 State Surchgs
55 Interest-
Interfund Loan I
56 Litiaation Awards
Total 0 0 0 0 0 0 0
CAPITAL OUTLAY
60 Land I
520 Buildings
540 Machinery-Equip
560 Fum & Fixtures I
580 Other Improve
Totai 0 0 0 0 0 0 0
TRANSFERS
720 Permanent I
71 Temporary
72 Refund-Reimburse.
Total 0 0 0 0 0 0 0
TOTAL ACCOUNT 197,470 169,394 206.800 147.885 190,000 190,000 190,000 I
I
106 I
I
I
BUDGET COMMENTS: PROFESSIONAL SERVICES
DEPT 41600
I
Code #
I
I
I
I
200 Assessor Supplies
I
301 Audit - General
I
304 Legal:
Monthly Retainer $1,750 x 12 =
Prosecutions
Generallegal/Mediation Services
Litigation
I
I
I
400 Assessor Services
440 Misc Services
I
I
I
I
I
I
I
107
12,000
21,000
19,000
35,000
20,000
95,000
73,000
10,000
I
FUND: 101 General ACTIVITY: Planning & Zoning DEPT 41910
Obj Actual Actual Budget YTD Sept Requested Proposed Adopted I
Code ITEM 2001 2002 2003 2003 2004 2004 2004
PERSONAL SERVICES
101 Regular Salaries 64,924 73,560 68,690 75,154 70,938 70,938 70,938 I
102 O.T. Salaries 0
103 Part Time Salaries 33,188 32,741 35,980 8,458 37,158 37,158 37,158
121 PERA City Share 5,106 5,877 5,788 4,627 5,978 5,978 5,978
122 FICA City Share 7,309 7,665 8,007 5,846 8,269 8,269 8,269 I
131 Ins. City Share 6,678 8,562 8,861 8,408 12,697 12,697 12,697
141 MN Unemp Camp
151 Workers Camp
Total 117,205 128,405 127,326 102,492 135,040 135,040 135,040 I
SUPPLIES
200 Office Supplies
212 Motor Fuel & Lube I
221 Maint-Equipment
223 Maint-Buildings
240 Small Tools
245 General Supplies 122 842 3.200 783 975 975 975 I
Total 122 842 3,200 783 975 975 975
OTHER SERVICES
301 Audit! Accounting
302 Consulting I
303 Engineering
304 Legal 2,125 0
321 Communication 1,110 1,387 1,200 1,066
331 Travel, Conf,Sch 4,879 5,344 7,750 4,840 7,500 7,500 7,500 I
351 Print!Publish 810 52 900 12 900 900 900
360 Ins.-Total
380 Utilities-
Gas.lElec. I
400 Contractual 8,500 4,380 4,000 2,480 4,000 4,000 4,000
410 Rental
433 Dues & Subscriptions 632 430 700 533 775 775 775
437 Licenses-Taxes I
440 Misc. Services 6.493 5,369 0
Total 24,549 16,961 14,550 8,931 13,175 13,175 13,175
OTHER CHARGES
54 State Surchgs I
55 Interest-
Interfund Loan
56 Allocated Expense
from other Depts I
Total 0 0 0 0 0 0 0
CAPITAL OUTLAY
60 Land I
520 Buildings
540 Machinery-Equip 745 1,650 2,076 550 550 550
560 Furn & Fixtures 482 0
580 Other Improve I
Total 482 745 1,650 2,076 550 550 550
TRANSFERS
720 Permanent 2,500 0 I
71 Temporary
72 Refund-Reimburse.
Total 2,500 0 0 0 0 0 0
TOTAL ACCOUNT 144.858 146.953 146.726 114.282 149,740 149.740 149,740 I
I
108 I
I
I
BUDGET COMMENTS: PLANNING & ZONING
DEPT 41910
I
Code #
101 .95 Planning Director
I
103 1 .0 Planning Asst.
I
I
I
245 General Supplies:
Books 100
Graphics materials 100
Franklin Planner Supplies 25
Planning Software (Arcview - floating license) 750
321 Air Time - Cellular Phone 1,200
331 Travel, Conferences & Schools:
Computer Training (GIS Training) 750
Misc. Conferences/Seminars 400
Mileage 750
Sensible Land Use Coalition Meetings 900
GTS Training Session - 4 P.C. Members 2,000
Education 200
Nat. Conf 2,500
351 Print/Publish: Comprehensive Plan brochure 900
400 Planning Commission Recording Secretary
($150 x 20 mtgs) 4,000
433 Subscriptions & Memberships:
APA 175
MN APA (3) 150
APAJoumal 75
Zoning News (4) 150
Sensible Land Use Coalition 125
Misc 100
540 Desktop Upgrade 300
Laptop Upgrade 250
I
I
I
I
I
I
I
I
I
I
I
I
109
I
FUND: 101 General ACTIVITY: Municipal Bldg City Hall DEPT 41940
Obj Actual Actual Budget YTD Sept Requested Proposed Adopted I
Code ITEM 2001 2002 2003 2003 2004 2004 2004
PERSONAL SERVICES
101 Regular Salaries I
102 O.T. Salaries
103 Part Time Salaries
121 PERA City Share
122 FICA City Share I
131 Ins. City Share
141 MN Unemp Comp
151 Workers Comp
Total 0 0 0 0 0 0 0 I
SUPPLIES
200 Office Supplies
212 Motor Fuel & Lube I
221 Maint-Equipment 3,852 3,250 12,005 2,918 12,000 12,000 12,000
223 Maint-Buildings 791 1,322 2,000 623 1,500 1,500 1,500
240 Small Tools
245 General Supplies 4.271 2.760 3.000 2.418 3,000 3.000 3,000 I
Total 8,914 7.332 17 ,005 5,958 16,500 16,500 16,500
OTHER SERVICES
301 Auditl Accounting
302 Consulting 2,700 2,500 2,500 2,500 I
303 Engineering
304 Legal
321 Communication 8,164 7,126 7,500 5,344 7,500 7,500 7,500
331 Travel, Conf,Sch 490 I
351 PrintlPublish
360 Ins.-Total 66,141 58,940 71 ,500 500 73,000 73,000 73,000
380 Utllities-
GasJEiec. 12,622 7,357 11 ,000 5,016 11 ,000 11 ,000 11 ,000 I
400 Contractual 5,079 4,507 6,910 4,272 7,100 7,100 7,100
410 Rental 1 ,464 984 1,200 1,312 1,000 1,000 1,000
433 Subscrip-Member
437 Licenses-Taxes 2,940 2,794 3,500 3,797 5,000 5,000 5,000 I
440 Misc. Services 0 30 162 200 200 200
Total 96,410 82,228 104,310 20,403 107,300 107,300 107,300
OTHER CHARGES
54 State Surchgs I
55 Interest-
Interfund Loan
56 Allocated Expense
from other Depts I
Total 0 0 0 0 0 0 0
CAPITAL OUTLAY
60 Land I
520 Buildings 37,544 37,544 37,550 37,544 37,550 37,550 37,550
540 Machinery-Equip 360 563 0 213 500 500 500
560 Furn & Fixtures 726 479 0 128 500 500 500
580 Other Improve 1,500 4.000 4,000 4,000 I
Total 38,630 38,586 37,550 37,885 42,550 42,550 42,550
TRANSFERS
720 Permanent 25,000 89,600 35,000 0 50,000 50,000 50,000 I
71 Temporary
72 Refund-Reimburse.
Total 25,000 89,600 35,000 0 50,000 50,000 50,000
TOTAL ACCOUNT 168.954 217.746 193,865 64,246 216.350 216,350 216,350 I
I
110 I
I
I
BUDGET COMMENTS: MUNICIPAL BLDG. CITY HALL
DEPT 41940
I
Code #
I
I
I
I
221 Maintenance Contracts:
Copiers (1) - (Hitachi) 2,025
Duplicator (Priport) 1,100
Other - Folding Machine 250
Back-up Copier 600
Color printer/other printers 600
Postage machine lease & maint 1,140
Computer Network Maint-Techies, Inc. 6,000
223 Bldg. Maint., recharge fire extinguisers, painting, etc. 1,500
245 Cleaning supplies, ice control for sidewalks,
Coffee supplies, pop purchases, paper supplies, water 3,000
302 Web Page. Hosting 2,500
321 City Hall telephone expense
331
360 Insurance package - Including Worker's Compensation (All Dept's)
380 Electric and Gas utility & refuse hauling
400 Janitorial 4,700
Internet Access Charges 1,200
. Rugs & Carpet Cleaning 750
Pest Control 450
410 Rental on Pop Machine 1,200
I
I
I
I
I
I
I
437 Special Assessments - City owned property (includes misc. County charges)
State Sales & Use Tax
I
520 Payment on Senior Community Center
37,550
I
540
560
580 Window Replacement
720 Transfer to Public Facilities Fund
1,500
I
I
I
111
I
FUND: 101 General ACTIVITY: Police DEPT 42100
Obj Actual Actual Budget YTD Sept Requested Proposed Adopted I
Code ITEM 2001 2002 2003 2003 2004 2004 2004
PERSONAL SERVICES
101 Regular Salaries I
102 O.T. Salaries
103 Part Time Salaries
121 PERA City Share
122 FICA City Share I
131 Ins. City Share
141 MN Unemp Camp
151 Workers Camp
Total 0 0 0 0 0 0 0 I
SUPPLIES
200 Office Supplies
212 Motor Fuel & Lube I
221 Malnt-Equipment
223 Maint-Buildings
240 Small Tools
245 General Supplies I
Total 0 0 0 0 0 0 0
OTHER SERVICES
301 Audit/Accounting
302 Consulting I
303 Engineering
304 Legal
321 Communication
331 Travel, Conf,Sch I
351 Print/Publish
360 Ins.-Total
380 Utilities- 38 38 50 25 50 50 50
Gas.lElec. I
400 Contractual 538,832 599,443 638,158 519,nO 670,452 670,452 670,452
410 Rental
433 Subscrip-Member
437 Licenses-Taxes I
440 Misc. Services 10,268 9,712 7,550 3,336 0 0 0
Total 549,138 609,193 645,758 523,131 670,502 670,502 670,502
OTHER CHARGES
54 State Surchgs I
55 Interest-
Interfund Loan
56 Allocated Expense
from other Depts I
Total 0 0 0 0 0 0 0
CAPITAL OUTLAY
60 Land I
520 Buildings 151,906 152,052 265,600 265,600 265,600
540 Machinery-Equip 11 ,000 11 ,000 11 ,000
560 Fum & Fixtures
580 Other Improve I
Total 0 0 151,906 152,052 276,600 276,600 276,600
TRANSFERS
720 Permanent 800 800 0 0 0 0 0 I
71 Temporary
72 Refund-Reimburse.
Total 800 800 0 0 0 0 0
TOTAL ACCOUNT 549,938 609.993 797,664 675.183 947,102 947,102 947,102 I
I
112 I
I
I
BUDGET COMMENTS: POLICE
DEPT 42100
I
Code #
I
I
I
I
I
I
400 Police Contract (2004) (6.3% Increase)
380 Electricity for Civil Defense Sirens
I
I
440 Court Officer Expense
Prisoner Expense
I
520 Police Building
540 Civil Defense Siren Upgrade (2 sirens)
I
I
I
I
I
I
I
113
662,952
3,000
4,500
265,600
11 ,000
I
FUND: 101 General ACTIVITY: Fire Protection DEPT 42200
Obj Actual Actual Budget YTD Sept Requested Proposed Adopted I
Code ITEM 2001 2002 2003 2003 2004 2004 2004
PERSONAL SERVICES
101 Regular Salaries I
102 O.T. Salaries
103 Part Time Salaries
121 PERA City Share
122 FICA City Share I
131 Ins. City Share
141 MN Unemp Camp
151 Workers Camp
Total 0 0 0 0 0 0 0 I
SUPPLIES
200 Office Supplies
212 Motor Fuel & Lube I
221 Maint-Equipment
223 Maint-Buildings
240 Small Tools
245 General Supplies I
Total 0 0 0 0 0 0 0
OTHER SERVICES
301 Audit! Accounting
302 Consulting I
303 Engineering
304 Legal
321 Communication
331 Travel, Conf,Sch I
351 Print!Publish
360 Ins.-Total
380 Utilities-
GasJElec. I
400 Contractual 248,398 293,029 250,997 191,486 234,997 234,997 234,997
410 Rental
433 Dues & Subscriptions
437 Licenses-Taxes I
440 Misc. Services
Total 248,398 293,029 250,997 191,486 234,997 234,997 234,997
OTHER CHARGES
54 State Surchgs I
55 Interest-
Interfund Loan
56 Allocated Expense
from other Depts I
Total 0 0 0 0 0 0 0
CAPITAL OUTLAY
60 Land I
520 Buildings 152,608 110,256 246,632 246,632 246,632
540 Machinery-Equip
560 Fum & Fixtures
580 Other Improve I
Total 0 0 152,608 110,256 246,632 246,632 246,632
TRANSFERS
720 Permanent I
71 Temporary
72 Refund-Reimburse.
Total 0 0 0 0 0 0 0
TOTAL ACCOUNT 248,398 293.029 403.605 301.743 481 ,629 481.629 481.629 I
I
114 I
I
I
BUDGET COMMENTS: FIRE PROTECTION
DEPT 42200
I
Code #
I
I
I
I
I
I
I
I
400 Mound Fire Operations Contract
Excelsior Fire Contract -2004 Operations Portion
I
520 Excelsior Fire District - Shorewood's share of 2004 Deb
Mound Fire - Shorewood's share of 2004 Debt.Svc.
I
I
I
I
I
I
I
115
12,555
222,442
241,687
4,945
I
FUND: 101 General ACTIVITY: Protective Inspection DEPT 42400
Obj Actual Actual Budget YTD Sept Requested Proposed Adopted I
Code ITEM 2001 2002 2003 2003 2004 2004 2004
PERSONAL SERVICES
101 Regular Salaries 56,m 60,182 63,712 50,468 66,866 66,866 66,866 I
102 O.T. Salaries
103 Part Time Salaries 2,033 8,995 2,257 9,289 9,289 9,289
121 PERA City Share 2,779 3,440 4,021 2,917 4,211 4,211 4,211
122 FICA City Share 4,117 4,497 5,562 3,803 5,826 5,826 5,826 I
131 Ins. City Share 5,168 7,444 9,380 5,691 9,484 9,484 9,484
141 MN Unemp Comp
151 Workers Comp
Total 68,841 77,595 91,670 65,137 95,676 95,676 95,676 I
SUPPLIES
200 Office Supplies
212 Motor Fuel & Lube I
221 Maint-Equipment
223 Maint-Buildings
240 Small Tools
245 General Supplies 1,030 361 400 43 850 850 850
Total 1,030 361 400 43 850 850 850 I
OTHER SERVICES
301 Audit/Accounting
302 Consulting I
303 Engineering
304 Legal
321 Communication 686 617 650 341 1,370 1,370 1,370
331 Travel, Conf,Sch 2,570 2,757 2,700 1,705 2,700 2,700 2,700 I
351 Print/Publish 76 1,026 600 481 600 600 600
360 Ins.-Total
380 Utilities-
Gas.lElec. I
400 Contractual 2,760 4,230 5,450 960 5,450 5,450 5,450
410 Rental
433 Subscrip-Member 85 85 150 100 150 150 150
437 Licenses-Taxes I
440 Misc. Services
Total 6,176 8,715 9,550 3,587 10,270 10,270 10,270
OTHER CHARGES
54 State Surchgs I
55 Interest-
Interfund Loan
56 Allocated Expense
from other Depts I
Total 0 0 0 0 0 0 0
CAPITAL OUTLAY
60 Land I
520 Buildings
540 Machinery-Equip 383 287 2,100 1,350 1,350 1,350
560 Fum & Fixtures
580 Other Improve I
Total 383 287 2,100 0 1,350 1,350 1,350
TRANSFERS
720 Permanent
71 Temporary I
72 Refund-Reimburse.
Total 0 0 0 0 0 0 0
TOTAL ACCOUNT 76,431 86.958 103.720 68.768 108,146 108,146 108.146 I
I
116 I
I
I
BUDGET COMMENTS: PROTECTIVE INSPECTION
DEPT 42400
I
Code #
I
101 .05 Planning Director
.2 Planning Assistant
1. Building Inspector
.1 Secretary/Receptionist
I
I
I
245 General Supplies:
Books 300
Wireless Card 300
Cork Boards 100
Mobile Workstation 150
321 Cellular Telephone & Air Time 650
Wireless Internet Service ($60/mo x 12 mos.) 720
331 Travel, Conferences & Schools:
Inspect. classes 225
Conferences 275
Mileage 2,200
351 Print permit application forms 600
400 Contractual Inspections during vacations, sick leave 5,450
( 26 days, 6 inspec!day; $35/ inspec)
433 Subscriptions & Memberships:
1.C.B.O. 100
Northstar Chapter - ICBO 50
540 Docimeter (Sound Meter) 1,200
Mobile Printer 150
I
I
I
I
I
I
I
I
I
I
I
I
117
I
FUND: 101 General ACTIVITY:Animal Control DEPT 42700
Obj Actual Actual Budget YTD Sept Requested Proposed Adopted I
Code ITEM 2001 2002 2003 2003 2004 2004 2004
PERSONAL SERVICES
101 Regular Salaries I
102 O.T. Salaries
103 Part Time Salaries
121 PERA City Share
122 FICA City Share I
131 Ins. City Share
141 MN Unemp Comp
151 Workers Comp
Total 0 0 0 0 0 0 0 I
SUPPLIES
200 Office Supplies
212 Motor Fuel & Lube I
221 Malnt-Equipment
223 Maint-Buildings
240 Small Tools
245 General Supplies
Total 0 0 0 0 0 0 0 I
OTHER SERVICES
301 Audit/Accounting
302 Consulting I
303 Engineering
304 Legal
321 Communication
331 Travel, Conf,Sch I
351 Print/Publish
360 Ins.-Total
380 Utilities-
Gas.lElec. I
400 Contractual - Animal Control 19,486 19,900 23,500 14,527 23,500 23,500 23,500
410 Rental
433 Subscrip-Member
437 Licenses-Taxes I
440 Misc. Services
Total 19,486 19,900 23,500 14,527 23,500 23,500 23,500
OTHER CHARGES
54 State Surchgs I
55 Interest-
Interfund Loan
56 Allocated Expense
from other Depts I
Total 0 0 0 0 0 0 0
CAPITAL OUTLAY
60 Land I
520 BUildings
540 Machinery-Equip
580 Other Improve
64 Future I
560 Furn & Fixtures
Total 0 0 0 0 0 0 0
TRANSFERS
720 Permanent I
71 Temporary
72 Refund-Reimburse.
Total 0 0 0 0 0 0 0
TOTAL ACCOUNT 19.486 19,900 23.500 14.527 23.500 23,500 23.500 I
I
118 I
I
I
BUDGET COMMENTS: ANIMAL CONTROL
DEPT 42700
I
Code #
I
I
I
I
I
400 Animal control contracts with City of Orono and Claws, Paws & Hooves
(2004 est. = 23,500 )
I
I
I
I
I
I
I
I
I
I
I
119
I
FUND: 101 General ACTIVITY: City Engineer OEPT 4301 0
Obj Actual Actual Budget YTD Sept Requested Proposed Adopted I
Code ITEM 2001 2002 2003 2003 2004 2004 2004
PERSONAL SERVICES
101 Regular Salaries 76,399 72,983 80,329 61,502 83,357 83,357 83,357 I
102 O.T. Salaries
103 Part Time Salaries 146
121 PERA City Share 3,369 4,657 4,442 3,403 4,610 4,610 4,610
122 FICA City Share 5,205 6,330 6,145 4,705 6,377 6,377 6,377 I
131 Ins. City Share 5,720 10,096 10,363 6,916 11,823 11,823 11,823
141 MN Unemp Comp
151 Workers Comp
Total 90,693 94,212 101,279 76,526 106,167 106,167 106,167 I
SUPPLIES
200 Office Supplies
212 Motor Fuel & Lube I
221 Maint-Equipment 350 350 350 350
223 Maint-Buildings
240 Small Tools
245 General Supplies 261 196 750 145 750 750 750 I
Total 261 196 1,100 145 1,100 1,100 1,100
OTHER SERVICES
301 Audit/Accounting I
302 Consulting
303 Engineering 9,068 203 5,000 144 5,000 5,000 5,000
304 Legal
321 Communication 759 423 700 818 1,850 1,850 1,850 I
331 Travel, Conf,Sch 672 508 3,000 195 4,000 4,000 4,000
351 Print/Publish 216 38 300 105 400 400 400
360 Ins.-Total
380 Utilities-Gas/Elec I
400 Contractual 4,021 2,000 1,227
410 Rental
433 Subscrip-Member 208 300 350 350 350
437 Licenses-Taxes 600 600 600 600 I
440 Misc. Services
Total 14,736 1,380 11,900 2,489 12,200 12,200 12,200
OTHER CHARGES
54 State Surchgs I
55 I nterest-
56 Allocated Expense
from other Depts I
Total 0 0 0 0 0 0 0
CAPITAL OUTLAY
60 Land I
520 Buildings
540 Machinery-Equip 5,548 3,000 600 600 600
560 Furn & Fixtures 247 219 400 400 400
580 Other Improve 618 0 I
Total 618 5,795 3,000 219 1,000 1,000 1,000
TRANSFERS
720 Permanent 2,200 0 I
71 Temporary
72 Refund-Reimburse.
Total 2,200 0 0 0 0 0 0
TOTAL ACCOUNT 108,508 101,582 117,279 79,380 120,467 120,467 120,467 I
I
120 I
I
I
BUDGET COMMENTS: CITY ENGINEER
DEPT 43010
I
Code #
I
101 .65 City Engineers/Public Works Director
.25 Fff Clerical
.50 Fff Engineering Tech.
I
I
I
221 Computer Upgrade
I
245 Books & Materials
Software Upgrades
I
I
303 Engineering - General Contractual
I
321 Cellular phone,time. Pager and High Speed Internet Access
331 Travel, Conference. & School
I
I
433 Subscriptions & Memberships
I
540 Digital Camera, Flatbed Scanner
560 Lateral File
I
I
I
I
I
121
300
450
I
FUND: 101 General ACTIVITY: Public Works Service DEPT 43050
Obj Actual Actual Budget YTD Sept Requested Proposed Adopted I
Code ITEM 2001 2002 2003 2003 2004 2004 2004
PERSONAL SERVICES
101 Regular Salaries 156,680 129,182 160,610 83,804 161,419 161,419 161,419 I
102 O.T. Salaries 1,693 5,801 300 4,946 1,000 1,000 1,000
103 Part Time Salaries 3,404 186 0
121 PERA City Share 7,947 6,148 8,882 4,911 8,926 8,926 8,926
122 FICA City Share 11 ,607 9,096 12,310 6,609 12,425 12,425 12,425 I
131 Ins. City Share 14,486 15,084 20,758 10,244 22,896 22,896 22,896
141 MN Unemp Comp 1,356 6,168
151 Workers Comp
Total 195,817 166,852 202,860 116,682 206,666 206,666 206,666 I
SUPPLIES
200 Office Supplies
212 Motor Fuel & Lube 14,875 12,628 18,000 11,793 18,000 18,000 18,000 I
221 Maint-Equipment 10,345 12,856 14,000 5,409 14,000 14,000 14,000
223 Maint-Buildings 449 1,660 1,500 156 1,500 1,500 1,500
240 Small Tools 543 34 1,000 261 1,000 1,000 1,000
245 General Supplies 7.794 7,142 9.000 3,214 9.000 9,000 9,000 I
Total 34,006 34,320 43,500 20,833 43,500 43,500 43,500
OTHER SERVICES
301 Audit/Accounting
305 Drug Testing 72 0 600 48 600 600 600 I
302 Consulting
303 Engineering
304 Legal
321 Communication 2,066 2,008 3,000 1,664 3,000 3,000 3,000 I
331 Travel, Conf,Sch 3,409 2,543 3,400 2,502 3,400 3,400 3,400
351 Print/Publish 17
360 Ins.-Total
380 Utilities- Gas/Elec. 9,860 8,815 9,200 9,630 9,200 9,200 9,200 I
400 Contractual 9,755 10,070 9,700 7,335 9,800 9,800 9,800
410 Rental 34 0 500 500 500 500
433 Subscrip-Member 125 50 100 125 150 150 150
437 Licenses-Taxes 317 559 600 291 650 650 650 I
440 Mise, Services 196 50 300 119 300 300 300
Total 25,834 24,112 27,400 21,714 27,600 27,600 27,600
OTHER CHARGES
54 State Surchgs I
55 Interest-
Interfund Loan
56 Allocated Expense
from other Depts I
Total 0 0 0 0 0 0 0
CAPITAL OUTLAY
60 Land I
520 Buildings
540 Machinery-Equip 1,569 655 7,150 2,926 3,750 3,750 3,750
560 Fum & Fixtures
580 Other Improve I
Total 1,569 655 7,150 2,926 3,750 3,750 3,750
TRANSFERS
720 Permanent 126,500 105,000 100,000 75,000 75,000 75,000
72 Refund-Reimburse. I
Total 126,500 105,000 100,000 0 75,000 75,000 75,000
TOTAL ACCOUNT 383,726 330.940 380,910 162,154 356,516 356,516 356.516
I
I
122 I
I
I
BUDGET COMMENTS: PUBLIC WORKS SERVICE
DEPT 43050
I
Code #
I
101 .1 City Engineer/Public Works Director
2.50 Light Equipment Operators
.33 Utility Maint. Operators
.05 Frr Clerical
I
I
212 Gasoline, Diesel Fuel for operating equipment
221 Maintenance of Equipment, includes Radios
223 Maintenance to buildings
240 Small tools, shovels, wrenches etc.
245 Inventory Items: cutting edges, automotive supplies, cleaning & shop supplies
First aid equipment and personal safety equipment
I
I
305 Drug monitoring and testing, including annual dues to LMCIT
321 Telephones and pager & cable modem; internet weather radar and parts
331 Safety Training - SafeAssure (OSHA mandate. 2770
I
380 Utilities - Gas & Electric
I
400 Laundry service. uniforms, towels
Janitorial Services
Fire Suppression System Monitoring
Annual Crane Inspection
Coop Purchase venture (county /state)
220
340
500
I
410 Mise equip rental for all PW Depts.
433 Subscriptions & memberships
I
437 Hazardous Waste Licence - Dept of Rev
Hennepin Co. Hazardous Waste
Mise Licenses(Boiler,lrrigation ,FireExtinglnsp)
100
225
360
I
440 Damage to private property - mailboxes, etc.
I
540 Replacement Radios (2) & Mics
Parts Sandblaster
22 Ton Jack
1000
1575
600
I
720 Transfer to Equipment Replacement Fund
Transfer to Stormwater Management Fund
50000
25000
I
I
I
I
123
I
FUND: 101 General ACTIVITY: Streets and Roadways DEPT 43100
Obj Actual Actual Budget YTD Sept Requested Proposed Adopted I
Code ITEM 2001 2002 2003 2003 2004 2004 2004
PERSONAL SERVICES
101 Regular Salaries 61,368 49,732 84,490 35,089 93,114 93,114 93,114 I
102 O.T. Salaries 821 331 500 485 500 500 500
103 Part Time Salaries
121 PERA City Share 3,221 2,769 4,700 1,967 5,177 5,177 5,177
122 FICA City Share 4,601 3,668 6,502 2,640 7,161 7,161 7,161 I
131 Ins. City Share 7,112 6,339 10,964 3,483 13,207 13,207 13,207
141 MN Unemp Comp
151 Workers Comp
Total 77 ,124 62,839 107,156 43,663 119,159 119,159 119,159 I
SUPPLIES
200 Office Supplies
212 Motor Fuel & Lube
221 Maint-Equipment I
223 Maint-Buildings
240 Small Tools
245 General Supplies 46 ,498 32,277 38.000 19 ,377 38,000 38,000 38,000
Total 46,498 32,277 38,000 19,377 38,000 38,000 38,000 I
OTHER SERVICES
301 AudiV Accounting
302 Consulting I
303 Engineering
304 Legal
321 Communication
331 Travel, Conf,Sch I
351 PrinVPublish
360 Ins.-Total
380 Utllities-
Gas.lElec. I
400 Contractual 1,002 8,002
410 Rental
433 Subscrip-Member
437 Licenses-Taxes
440 Misc. Services 7,667 928 7.500 7.265 7,800 7,800 7,800 I
Total 8,669 8,930 7,500 7,265 7,800 7,800 7,800
OTHER CHARGES
54 State Surchgs I
55 Interest-
Interfund Loan
56 Allocated Expense
from other Depts I
Total 0 0 0 0 0 0 0
CAPITAL OUTLAY
60 Land I
520 Buildings
540 Machinery-Equip 3,577
560 Furn & Fixtures
580 Other Improve I
Total 3,577 0 0 0 0 0 0
TRANSFERS
720 Permanent 367,000 200,000 200,000 0 183,500 183,500 183,500
71 Temporary I
72 Refund-Reimburse.
Total 367,000 200,000 200,000 0 183,500 183,500 183,500
TOTAL ACCOUNT 502.867 304,045 352,656 70.305 348.459 348.459 348.459 I
I
124 I
I
I
BUDGET COMMENTS: STREETS AND ROADWAYS
DEPT 43100
Code #
I
101 Street Maintenance salaries - 2.0 Light Equip. Operators + .33 Utility Maint. Ops.
I
I
I
I
245 Rock, gravel, black dirt & asphalt
I
I
I
331 Safety Training
I
I
440 Warning lights when street repair in progress.
Road Striping
I
I
I
720 Transfer to Street Reserve Fund (2004)
Street Improvements
Overlays
Seal Coating
I
I
I
I
125
I
FUND: 101 General ACTIVITY: Snow and Ice Removal DEPT 43125
Obj Actual Actual Budget YTD Sept Requested Proposed Adopted I
Code ITEM 2001 2002 2003 2003 2004 2004 2004
PERSONAL SERVICES
101 Regular Salaries 11 ,459 8,927 21,122 7,419 21,845 21 ,845 21,845 I
102 O.T. Salaries 8,451 2,753 5,000 1,163 5,000 5,000 5,000
103 Part Time Salaries
121 PERA City Share 1,031 646 1,445 475 1,485 1 ,485 1 ,485
122 FICA City Share 1 ,487 868 1,998 633 2,054 2,054 2,054 I
131 Ins. City Share 1,787 1,461 3,370 979 3,808 3,808 3,808
141 MN Unemp Camp
151 Workers Comp
Total 24,215 14,655 32,935 10,669 34,192 34,192 34,192 I
SUPPLIES
200 Office Supplies
212 Motor Fuel & Lube I
221 Maint-Equipment
223 Maint-Buildings
240 Small Tools
245 General Supplies 14.424 25.358 20,000 14.412 26,000 26.000 26.000 I
Total 14,424 25,358 20,000 14,412 26,000 26,000 26,000
OTHER SERVICES
301 Audit! Accounting
302 Consulting I
303 Engineering
304 Legal
321 Communication
331 Travel, Cont,Sch 0 0 0 0 I
351 Print!Publish
360 Ins.-Total
380 Utilities-
Gas.lElec. I
400 Contractual
410 Rental
433 Subscrip-Member
437 Licenses-Taxes I
440 Misc. Services
Total 0 0 0 0 0 0 0
OTHER CHARGES
54 State Surchgs I
55 Interest-
Interfund Loan
56 Allocated Expense I
trom other Depts
Total 0 0 0 0 0 0 0
CAPITAL OUTLAY
60 Land I
520 Buildings
540 Machinery-Equip 4,500 3,200 3,200 3,200
560 Fum & Fixtures
580 Other Improve I
Total 0 0 4,500 0 3,200 3,200 3,200
TRANSFERS
720 Permanent I
71 Temporary
72 Refund-Reimburse.
Total 0 0 0 0 0 0 0
TOTAL ACCOUNT 38.639 40,013 57,435 25.081 63,392 63.392 63.392 I
I
126 I
I
I
BUDGET COMMENTS: SNOW AND ICE REMOVAL
DEPT 43125
Code #
I
101 Snow & Ice removal salaries - .5 LEO's
I
I
I
245 Salt & sand for snow removal, calcium chloride.
I
540 Cab for Blower Unit
3,200
I
I
I
I
I
I
I
I
I
I
I
I
127
I
FUND: 101 General ACTIVITY: Traffic Control/Street Lighting DEPT 43160
Obj Actual Actual Budget YTD Sept Requested Proposed Adopted I
Code ITEM 2001 2002 2003 2003 2004 2004 2004
PERSONAL SERVICES
101 Regular Salaries I
102 O.T. Salaries
103 Part Time Salaries
121 PERA City Share
122 FICA City Share I
131 Ins. City Share
141 MN Unemp Camp
151 Workers Camp
Total 0 0 0 0 0 0 0 I
SUPPLIES
200 Office Supplies
212 Motor Fuel & Lube I
221 Maint-Equipment 310 883 1,500 1,029 1,500 1,500 1,500
223 Maint-Buildings
240 Small Tools
245 General Supplies 3,535 367 3,550 1.292 3.550 3,550 3,550 I
Total 3,845 1,249 5,050 2,320 5,050 5,050 5,050
OTHER SERVICES
301 Audit/Accounting
302 Consulting I
303 Engineering
304 Legal
321 Communication
331 Travel, Conf,Sch I
351 Print/Publish
360 Ins.-Total
380 Utilities-
Gas.lEiec. 5,650 4,085 5,700 2,910 5,700 5,700 5,700 I
400 Contractual
410 Rental
433 Subscrip-Member
437 Licenses-Taxes I
440 Misc. Servlces-Strt Liot 29.299 29,144 29,000 19.685 29,500 29,500 29,500
Total 34,949 33,229 34,700 22,594 35,200 35,200 35,200
OTHER CHARGES
54 State Surchgs I
55 Interest-
Interfund Loan
56 Allocated Expense
from other Depts I
Total 0 0 0 0 0 0 0
CAPITAL OUTLAY
60 Land I
520 Buildings
540 Machinery-Equip
560 Furn & Fixtures
580 Other Improve I
Total 0 0 0 0 0 0 0
TRANSFERS
720 Permanent I
71 Temporary
72 Refund-Reimburse.
Total 0 0 0
TOTAL ACCOUNT 38.794 34.478 39,750 24.915 40.250 40 .250 40 ,250 I
I
128 I
I
I
BUDGET COMMENTS: TRAFFIC CONTROUSTREET LIGHTING
DEPT 43160
Code #
I
I
I
I
I
221 Maintenance to semaphores
245 Signs and posts.
I
I
I
I
380 Electricity for signal systems
I
440 Electricity for street lights
I
I
I
I
I
I
I
129
I
FUND # 101 General ACTIVITY: Sanitation/Waste Removal/Weeds OEPT 43200
Ob] Actual Actual Budget YTD Sept Requested Proposed Adopted I
Code ITEM 2001 2002 2003 2003 2004 2004 2004
PERSONAL SERVICES
101 Regular Salaries 1,318 898 500 31 1,000 1,000 1,000 I
102 O.T. Salaries 0 0
103 Part Time Salaries 0 0
121 PERA City Share 68 50 28 2 50 50 50
122 FICA City Share 100 66 38 2 77 77 77 I
131 Ins. City Share 133 125 84 2 140 140 140
141 MN Unemp Comp
151 Workers Comp
Total 1,619 1,138 650 37 1,267 1,267 1,267 I
SUPPLIES
200 Office Supplies
212 Motor Fuel & Lube I
221 Maint-Equipment
223 Maint-Buildings
240 Small Tools
245 General Supplies I
Total 0 0 0 0 0 0 0
OTHER SERVICES
301 Audit! Accounting
302 Consulting I
303 Engineering
304 Legal
321 Communication
331 Travel, Conf,Sch I
351 Print!Publish
360 Ins.-Total
380 Utllities- Gas.lElec.
400 Contractual 2,985 0 800 66 800 800 800 I
410 Rental
433 Dues & Subscriptions
437 Licenses-Taxes
440 Misc. Services 2,854 2.854 3,000 2,854 3.100 3,100 3.100 I
Total 5,840 2,854 3,800 2,920 3,900 3,900 3,900
OTHER CHARGES
54 State Surchgs I
55 Interest-
Interfund Loan
56 Allocated Expense
from other Depts I
Total 0 0 0 0 0 0 0
CAPITAL OUTLAY
60 Land
520 Buildings I
540 Machinery-Equip
580 Other Improve
64 Future
560 Fum & Fixtures I
Total 0 0 0 0 0 0 0
TRANSFERS
720 Permanent I
72 Refund-Reimburse.
Total 0 0 0 0 0 0 0
TOTAL ACCOUNT 7,458 3.993 4,450 2.957 5,167 5.167 5,167 I
I
130 I
I
I
BUDGET COMMENTS: SANITATION/WASTE REMOVAUWEEDS
DEPT 43200
Code #
I
101 Public Works salaries associated with property clean-up
I
I
I
I
I
400 Property clean-up
I
I
440 Contracted weed spraying
3,000
I
I
I
I
I
I
I
I
I
131
I
FUND: 101 General ACTIVITY: Tree Maintenance DEPT 43250
Obj Actual Actual Budget YTD Sept Requested Proposed Adopted I
Code ITEM 2001 2002 2003 2003 2004 2004 2004
PERSONAL SERVICES
101 Regular Salaries 6,670 12,143 8,449 10,629 8,738 8,738 8,738 I
102 O.T. Salaries 62 62
103 Part Time Salaries
121 PERA City Share 345 671 467 591 483 483 483
122 FICA City Share 493 892 646 790 668 668 668 I
131 Ins. City Share 392 1,143 1,090 1,489 1,239 1,239 1,239
141 MN Unemp Camp
151 Workers Camp
Total 7,901 14,912 10,652 13,561 11,128 11,128 11,128 I
SUPPLIES
200 Office Supplies
212 Motor Fuel & Lube
221 Maint-Equipment I
223 Maint-Buildings
240 Small Tools 637 0 600 98 600 600 600
245 General Supplies 286 369 300 108 300 300 300
Total 923 369 900 206 900 900 900 I
OTHER SERVICES
301 Audit! Accounting
302 Consulting I
303 Engineering
304 Legal
321 Communication
331 Travel, Conf,Sch 130 0 300 350 350 350 I
351 Print!Publish
360 Ins.-Tota!
380 Utilities-
Gas.lElec. I
400 Contractual 5,301 5,435 13,000 1,881 13,000 13,000 13,000
410 Rental
433 Dues & Subscriptions
437 Licenses-Taxes I
440 Misc. Services
Total 5,431 5,435 13,300 1,881 13,350 13,350 13,350
OTHER CHARGES
54 State Surchgs I
55 Interest-
Interfund Loan
56 Allocated Expense
from other Depts I
Total 0 0 0 0 0 0 0
CAPITAL OUTLAY
60 Land I
520 Buildings
540 Machinery-Equip
560 Furn & Fixtures
580 Other Improve I
Total 0 0 0 0 0 0 0
TRANSFERS
720 Permanent
71 Temporary I
72 Refund-Reimburse.
Total 0 0 0 0 0 0 0
TOTAL ACCOUNT 14.255 20.715 24,852 15.648 25,378 25,378 25,378 I
I
132 I
I
I
BUDGET COMMENTS: TREE MAINTENANCE
DEPT 43250
Code #
I
101 .20 Light Equipment Operators
I
I
I
240 Small Tools. 1 Replacement chain saw
I
245 Paint for marking trees
I
I
I
331 Tree Inspection School (2 @ $175)
I
400 Contracted tree removal.
I
I
I
I
I
I
I
I
133
I
FUND: 101 DEPARTMENT: Parks and Recreation DEPT 45200
Obj Actual Actual Budget YTD Sept Requested Proposed Adopted I
Code ITEM 2001 2002 2003 2003 2004 2004 2004
PERSONAL SERVICES
101 Regular Salaries 54,979 75,525 75,437 57,419 78,384 78,384 78,384 I
102 O.T. Salaries 10,280 864 500 286 500 500 500
103 Part Time Salaries 4,938 14,329 18,525 13,764 18,975 18,975 18,975
121 PERA City Share 3,167 4,206 4,199 2,852 4,362 4,362 4,362
122 FICA City Share 5,755 6,848 7,226 5,433 7,452 7,452 7,452 I
131 Ins. City Share 7,051 8,779 9,796 6,581 11 ,189 11 ,189 11,189
141 MN Unemp Camp 87
151 Workers Camp
Total 86,170 110,551 115,683 86,422 120,862 120,862 120,862 I
SUPPLIES
200 Office Supplies
212 Motor Fuel & Lube I
221 Maint-Equipment 1,437 182 2,000 346 2,000 2,000 2,000
223 Maint-Buildlngs 978 567 2,000 91 2,000 2,000 2,000
240 Small Tools 201 0 600 600 600 600
245 General Supplies 8.617 9.618 16.000 6,776 16.000 16.000 16.000 I
Total 11,233 10,367 20,600 7,212 20,600 20,600 20,600
OTHER SERVICES
301 AudiV Accounting
302 Consulting 4,818 7,402 4,000 396 4,000 4,000 4,000 I
303 Engineering 835
304 Legal
321 Communication 1,588 1,285 1,250 1,363 1,250 1,250 1,250
331 Travel, Conf,Sch 152 94 300 34 300 300 300 I
351 Print/Publish 49 0 400 100 400 400 400
360 Ins.-Total
380 Utillties- Gas.lElec. 6,289 3,740 5,800 5,282 5,800 5,800 5,800
400 Contractual 8,327 15,566 43,000 20,588 43,000 43,000 43,000 I
410 Rental 6,808 9.563 7,250 5,956 8,000 8,000 8,000
433 Dues & Subscriptions 389 200 250 250 250
437 Licenses-Taxes
440 Misc. Services 705 323 1.100 100 1.200 1.200 1.200 I
Total 28,736 39,197 63,300 33,818 64,200 64,200 64,200
OTHER CHARGES
54 State Surchgs
55 Interest- I
Interfund Loan
56 Allocated Expense
from other Depts I
Total 0 0 0 0 0 0 0
CAPITAL OUTLAY
60 Land 285,000
520 Buildings I
540 Machinery-Equip 1,077 6,000 500 375 375 375
560 Furn & Fixtures 678
580 Other Improve
Total 1,077 291,678 500 0 375 375 375 I
TRANSFERS
720 Permanent 10,000 213,700 63,650 15,000 15,000 15,000
71 Temporary I
72 Refund-Reimburse.
Total 10,000 213,700 63,650 0 15,000 15,000 15,000
TOTAL ACCOUNT 137.215 665,493 263.733 127 ,452 221 .037 221.037 221.037
I
I
. 134 I
I
I
BUDGET COMMENTS: PARKS & RECREATION/BEACHES
DEPT 45200
I
Code #
I
101 1.50 Light Equipment Operators
0.33 Clerical
I
103 Part-time Rink Attendants
(347 hrs x 3 rinks x $9.00 + 347 x 10.50 = 13,000)
Park Commission Minutes ($175 x 18 meetings)
Part-time summer help
13,000
3,150
2,825
I
I
221 Maintenance to Park Equipment
223 Maintenance to Badger, Manor, Eddy Station, Cathcart Trailer
240 Tools, shovels, scrapers, etc.
245 Rock, dirt, fertilizers, seed, sand, etc., & signs for Snowmobile Trails
302 Engineering and Park Planning
321 Park telephones, inc!. Eddy Station
331 Travel, Conferences, Schools
380 Includes electricity and natural gas for warming houses
400 Contract Park Coordinator 30,000
MCES Lifeguard Svc. 7,000
Sr. Rec Program 6,000
410 Rental of portable toilets for Parks, Crescent Beach 8,000
Christmas Lake Public Access
440 Misc. Expenses, such as rubbish hauling,
electrical work; Cathcart Warming House electrical hook-up
& disconnect
540 Gas Trimmer and Accessories 375
720 Transfer to Park Capital Improvement Fund 10,000
Transfer to the Land & Open Space Fund 5,000
I
I
I
I
I
I
I
I
I
I
I
I
135
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
CITY OF SHOREWOOD
ENTERPRISE FUND DETAILED BUDGETS
137
138
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
FUND # 601 WATER FUND REVENUES BUDGET DEPT # 49400
CODE REVENUE SOURCE Actual Actual Actual Budget YTD Sept Proposed Adopted
# 2000 2001 2002 2003 2003 2004 2004
36210 Water Int. Earned 93,266 63,712 60,511 40,000 25,440 35,000 35,000
37110 Water Sales 285,212 319,260 266,720 320,000 161,928 427,200 427,200
37150 Connection Fees 0 0 0 20,000 20,000
37170 Water Permits 5,336 4,445 1,590 1,000 1,270 1,000 1,000
37171 Sale of Meters 10,105 11,125 4,155 6,000 6,170 5,000 5,000
37175 Antennae Space Rental 23,381 9,066 43,595 36,000 17,184 36,000 36,000
39310 Bond Proceeds 0 0 0 0 0 800,000 800,000
Totals 417 ,300 407,608 376,571 403,000 211,993 1,324,200 1,324,200
I
I BUDGET COMMENTS: WATER FUND REVENUES
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
36210 Interest eamed on investment of water funds
37110 Estimate of 2004 water sales
37150 Connection Fees (2 at $10,000)
37170 Permits to be sold (same number as meters) 30 @ $25 = $750
37171 Water meter sales - 30 new hook-ups
37175 Revenue from space rental of water tower to cellular companies
139
I
FUND # 601 WATER FUND EXPENDITURES DEPT # 49400 I
Code Actual Actual Actual Budget YTD Sept Proposed Adopted
# ITEM 2000 2001 2002 2003 2003 2004 2004 I
PERSONAL SERVICES
101 Regular Salaries 10,235 14,073 38,840 79,165 41,658 77,851 77,851
102 aT. Salaries 149 481 115 500 319 500 500 I
103 Part Time Salaries 0 0 0
121 PERA City Share 538 754 2,153 4,378 2,322 4,305 4,305
122 FICA City Share 748 1,072 2,817 6,056 3,042 5,956 5,956 I
131 Ins. City Share 925 1 ,449 4,505 10,213 4,819 11,042 11,042
Total 12,595 17,829 48,431 100,312 52,160 99,654 99,654
SUPPLIES I
200 Office Supplies 1 ,498 1,232 963 2,000 0 2,000 2,000
208 Postage 1,240 743 750 484 750 750
212 Motor Fuel & Lube I
221 Maint-Equipment 14,168 22,871 14,648 15,000 13,687 15,000 15,000
223 Maint-Buildings 366 152 164 3,500 3,500 3,500
240 Small Tools 0 250 798 750 750
245 General Supplies 10,413 12,360 12,422 12,000 6,899 12,000 12,000 I
260 Wtr Purch - Tonka Bay 1,816 1,129 1,181 1,500 313 1,500 1,500
261 Wtr Purch - Excelsior 9,933 11,010 10,200 11,000 5,812 11,000 11 ,000
262 Wtr Purch - Mtka 508 596 482 750 335 750 750
265 Water Meters 8,920 2,450 7,506 3,000 4,688 2,000 2,000 I
Total 48,861 52,542 47,565 49,750 33,016 49,250 49,250
OTHER SERVICES & CHARGES
301 Financial & Audit 1,042 1,383 1,544 2,000 1,423 2,000 2,000 I
302 Consulting 518 0 0 0 0
303 Engineering 9,175 7,337 7,000 930 5,000 5,000
304 Legal 0 500 0 500 500 I
321 Communication 102 558 750 600 800 800
331 Travel, Cont,Sch 750 1,000 0 2,500 2,500
351 Print/Publish 406 438 441 502 500 500 I
360 I nsurance- Total 4,184 3,617 4,384 4,500 3,001 5,000 5,000
394 Utilities - Amesbury 7,416 6,587 6,552 7,000 6,291 7,000 7,000
395 Utilities - Badger 7,529 9,203 6,554 9,500 4,766 9,300 9,300
396 Utilities - Boulder Bridge 11,641 12,631 12,718 13,000 10,787 13,000 13,000 I
397 Utilities - Woodhaven 3,033 2,982 3,516 3,000 2,473 3,000 3,000
398 Utilities - SE Areafrower 18,035 19,209 20,373 20,000 16,276 20,000 20,000
400 Contractual 55,327 70,570 80,925 0 6,969 5,000 5,000
410 Rental I
420 Depreciation 172,032 178,328 180,805 180,000 135,277 182,000 182,000
433 S ubscrip-Member 0 0 300 300 300
437 Licenses-Sales Taxes 1,247 1,393 2,233 2,300 1,251 2,500 2,500 I
440 Misc. Services 200 180 34 500 178 500 500
450 Investment Svc Chgs 896 811 748 1,000 417 1,000 1,000
Total 292,163 316,039 321,386 252,350 191,142 259,900 259,900
I
I
I
140 I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
FUND # 601
Code
# ITEM
CAPITAL OUTLAY
60 Land
520 Buildings
540 Machinery-Equip
580 Other Improve
Total
TRANSFERS
720 Permanent
Total
Actual Actual Actual Budget YTD Sept Proposed Adopted
2000 2001 2002 2003 2003 2004 2004
0 0
0 0
5,111 935 0 0
0 0 0 270,200 0 800,000 800,000
5,111 935 0 270,200 0 800,000 800,000
45,000 85,000 110,000 150,000 0 230,000 230,000
45,000 85,000 110,000 150,000 0 230,000 230,000
403,730 472,345 527,381 822,612 276,318 1 ,438,804 1 ,438,804
TOTAL ACCOUNT
141
I
BUDGET COMMENTS: WATER FUND EXPENDITURES
FUND # 601
I
101 1.00 Utility Operator .125 City Engineer
.10 Senior Accounting Clerk .25 Engineering Technician
.20 Accounting Clerk .05 Secr/Recep.
I
I
200 Billing supplies
208 Postage
221 Maintenance contract for UB hardware & software.
Inspection/Maintenance of Wells
Boulder Bridge Well Maintenance
Surge Protectors for Wells
I
I
223 Amesbury Building Repair ($3,450)
240 Small Tools
I
245 General Supplies
I
265 20 homes @ $1 OO.aO/meter plus replacement meters
303 Engineering - Water maintenance
I
321 Autodialers for Pumphouses - Costs moved to individual well utility accts.
I
331 Water Operators License Training
351 Annual Water Quality Report
I
360 Insurance
400 Munitech Contract-(1999-2002)
I
420 Depreciation - a non-cash expense for future system replacement
I
580
I
I
I
I
I
142
I
I
I
I
BUDGET COMMENTS: WATER FUND
I
I
I
I
I
I
I
I
I
580 Capital Outlay:
Woodhaven Well Inter-Connection ($140,000 - 2004)
Badger Well House Reconstruction ($480,000 - 2004)
Radio Read Meter project-Year 1 of 3 ($70,000 - 2004)
SE Area Water Tower Paining ($50,000 - 2004)
SE Well-Install VFD ($18,000 - 2004)
Amesbury Polyphosphate System ($12,000 - 2004)
720 Permanent Transfers
Water Debt Service Fund - Debt Payments ($230,000-2004)
I
I
I
I
I
I
I
143
I
FUND # 601 WATER DEBT SERVICE DEPT # 49400 I
REVENUES
CODE REVENUE SOURCE Actual Actual Actual Budget YTD Sept Proposed Adopted I
# 2000 2001 2002 2003 2003 2004 2004
31010 Property Tax 10 18 0 0 0 0 0 I
36101 Special Assessments 41 ,409 40,348 1,904 40,000 4,263 20,000 20,000
36210 Interest Income 0 0 0 0 0 0 0 I
37150 Connection Fees 175,000 74,850 15,000 80,000 12,500 15,000 15,000
39203 Transfers 40,000 85,000 110,000 150,000 0 230,000 230,000
Totals 256,420 200,216 126,904 270,000 16,763 265,000 265,000 I
EXPENSES EXPENSES
Code Actual Actual Actual Budget YTD Sept Proposed Adopted I
# ITEM 2000 2001 2002 2003 2003 2004 2004
OTHER SERVICES I
301 Financial
302 Consulting
303 Engineering I
304 Legal
321 Communication
331 Travel, Conf,Sch I
351 Print/Publish
360 Insurance-Total
380 Utilities-Gas/Elec I
400 Contractual
410 Rental
433 Dues & Subscriptions I
437 Licenses-Taxes
440 Misc. Services
45 Service Charges I
Total 0 0 0 0 0 0
OTHER CHARGES
Total 0 0 0 0 0 0 I
TRANSFERS I
720 Permanent
Total 0 0 0 0 0 0
DEBT SERVICE I
23100 Bond Principal 190,000 185,000 185,000 185,000 185,000 190,000 190,000
611 Bond Interest 1 09,424 140,985 89,797 82,904 82,904 74,090 74,090
620 Agent Fees 312 312 462 500 500 800 800 I
Total 299,424 325,985 275,258 267,904 267,904 264,890 264,890
TOTAL ACCOUNT 299,424 325,985 275,258 267,904 267,904 264,890 264,890 I
144 I
I
I
I
BUDGET COMMENTS: WATER DEBT SERVICE
REVENUES
CODE #
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
36101
37150
36210
39203
Special Assessment payments
Connection Fees
Interest Income
Transfers from Other Funds
EXPENSES
CODE #
23100 Principal on G.O. Revenue Bonds (Prin on proposed 2004 issue not due 'til 2005)
611 Interest G.O. Revenue Bonds (Interest on proposed 2004 issue not due 'til 2005)
620 Fiscal Agent Fees
145
146
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
FUND # 611 SEWER FUND REVENUES Dept # 49450
Code Actual Actual Actual Budget YTD Sept Proposed Adopted
# REVENUE SOURCE 2000 2001 2002 2003 2003 2004 2004
33635 MCES I & I Grant 5,000 0 0 0 0 0 0
36210 Sewer Int. Eamed 146,025 108,409 109,108 50,000 31,864 50,000 50,000
36240 Refunds/Reimburse 0 0 2,353 0 0 0 0
36270 Metro Sac Charges 5,154 0 0 0 0 0 0
37210 Sewer Serv Charges 693,904 666,987 690,150 784,000 397,908 784,000 784,000
37210 Sewer Chg-Cnty Call 0 0 0 0 0 0 0
37250 Local SAC Charges 0 7,637 6,252 5,000 35,760 5,000 5,000
37270 Sewer Permits 10,200 5,910 2,050 1,500 2,400 1,500 1,500
39203 Tsfr From Other Funds 0 0 0 38,877 0 37,397 37,397
Total 860,283 788,944 809,913 879,377 467,932 877 ,897 877,897
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
BUDGET COMMENTS: SEWER FUND REVENUES
FUND # 611
36210 Estimated Interest eamings.
36270 Metro SAC charges collected w/sewer permit
$1,200 x est. 15 homes to be constructed in 2004 = $20,000*.01=$180
37210
37210
Estimated Sewer Service Charge Revenue (($70/Qtr * 2,800 Accts)
Delinquent sewer bills collected by the County
784,000
37250 Local Sewer Access Charges @ $1,250 each
37270 $100 each for estimated 15 homes to be constructed in 2003
39203 Transfer in from Stormwater Fund for repayment of Gideon Glen Interfund Loan ($38,877 prinlint pmt -2003)
147
I
FUND # 611 SEWER FUND EXPENDITURES DEPT # 49450 I
Code Actual Actual Actual Budget YTD Sept Proposed Adopted
# ITEM 2000 2001 2002 2003 2003 2004 2004 I
PERSONAL SERVICES
101 Regular Salaries 15,011 15,969 25,714 79,165 32,244 77,851 77,851
102 O.T. Salaries 45 55 175 5,000 712 5,000 5,000
103 Part Time Salaries 0 0 I
121 PERA City Share 780 830 1 ,430 4,378 1,824 4,305 4,305
122 FICA City Share 1,114 1,188 1,896 6,056 2,423 5,956 5,956
131 Ins. City Share 2,023 754 2,852 10,213 3,757 11,042 11,042 I
Total 18,973 18,795 32,068 104,812 40,960 104,154 104,154
SUPPLIES
200 Office Supplies 1,205 1,232 2,500 0 2,500 2,500 I
208 Postage 1,666 1,368 1,384 1,500 726 1,500 1,500
212 Motor Fuel & Lube
221 Maint-Equipment 13,007 7,345 14,915 12,000 9,139 16,000 16,000 I
223 Maint-Buildings 0
240 Small Tools 479 500 260 750 750
245 General Supplies 864 69 4,554 2,000 305 2,000 2,000
Total 16,742 10,013 21,334 18,500 10,430 22,750 22,750 I
SUPPORT SERVICES & CHARGES
301 Financial & Audit 1,042 1,383 1,544 1,800 1 ,423 2,000 2,000
302 Consulting I
303 Engineering 6,920 2,892 346 5,000 1,074 5,000 5,000
304 Legal 500
321 Communication 137 145 695 1,000 1,286 1,200 1,200 I
331 Travel, Conf,Sch 774 630 0 1,000 533 1,500 1,500
351 PrinVPublish 491 52 10 250 49 250 250
360 Insurance-Total 2,416 1,414 1,344 2,500 845 2,500 2,500
380 Utilities-Gas/Elec 4,855 5,065 4,562 6,000 3,118 6,000 6,000 I
385 MCES Service Charges 293,148 374,980 339,960 450,000 369,438 450,000 450,000
386 Excelsior Sewer Chg 13,016 14,558 14,927 15,000 0 15,000 15,000
400 Contractual 44,050 43,132 49,099 35,000 4,459 25,000 25,000 I
410 Rental
420 Depreciation 198,974 200,821 202,291 202,000 151,693 205,000 205,000
433 Dues & Subscriptions 250 250 250
437 Licenses-Taxes 500 72 500 500 I
440 Misc. Services 58 58 59 500 44 58 58
450 Service Charges 1,598 1,184 1,001 1,500 727 1,500 1,500
MCES SAC Charges I
Total 567,480 646,314 615,838 722,800 534,760 715,758 715,758
CAPITAL OUTLAY
540 Machinery-Equip 0 44,100 11,767 1,500 1,500 I
560 Furn & Fixtures 0
580 Other Improve 0 153,600 120,000 120,000
Total 0 0 0 197,700 11,767 121,500 121,500 I
TRANSFERS
720 Interfund Loans-Gideon/Sr I 565,000 0 0 0 0 0 0
720 Permanent 86,875 10,000 15,000 0 0 0 0 I
Total 651,875 10,000 15,000 0 0 0 0
TOTAL ACCOUNT 1,255,070 685,122 684,239 1,043,812 597,918 964,162 964,162
I
148 I
I
I
BUDGET COMMENTS: SEWER FUND
FUND # 611
I
CODE #
I 101 .10 Senior Accounting Cle .125 City Engineer
.05 ReceptionisVSecretary .25 Engineer. Technician
1.10 Light Equip. Operator .20 Junior Accounting Clerk
I 221 Includes software maintenance
Equipment Maintenance
I 240
245 Adjusting rings manholes
I Jetter nozzles and hose
I
303 Engineering fees for I & I Study, other
304 Legal fees
I
321 2 Nextel phones; airtime charges, autodialer cell phone air time for Lift Station monitoring
(12 lift stations x 12.50 cell time = $150)
331 To license Public Works staff - MSCC School
360 Insurance
I
385 MCES treatment charges - Est. 360 million gallons @ $1 ,250/million gallons
386 Charge for Sewage Flow through ExcelsiorTrunks
I
400 Inflow & Infiltration Control & Reduction - $25,000 - 2004)
I
420 Depreciation
440 Misc. expenses - also includes costs for backups in resident homes
I
540 Capital Outlay - $1250 Meg Ohm Meter; $250 Amprobe
I
580 $120,000 Lift Station Rehab (carry over of 2003 & 2004)
I
720 Transfer to General Fund for Overhead Costs ($0 - 2004)
I
I
I
I
149
I
FUND # 621 RECYCLING FUND BUDGET DEPT # 49550 I
REVENUES
CODE REVENUE SOURCE Actual Actual Actual Budget YTD Sept Proposed Adopted I
# 2000 2001 2002 2003 2003 2004 2004
33620 Cnty Recycling Aid 21,858 23,728 23,690 23,700 0 21,460 21,460
36210 Interest Income 2,346 1,625 1,655 750 643 1,500 1,500 I
37310 Recycling Svc Chgs 52,507 48,191 49,730 57,120 27,994 57,120 57,120
37320 City Clean-up Fees 23,941 29,409 32,130 29,000 35,849 36,900 36,900
37330 Recycling Bin Sales 416 392 1,176 500 286 500 500
37340 Revenue from Contr 20 0 0 I
39203 Tfrs from Other Funds 0 0 0 0
Totals 101 ,067 103,345 108,382 111,070 64,793 117 ,480 117,480
EXPENSES EXPENSES I
Code Actual Actual Actual Budget YTD June Proposed Adopted
# ITEM 2000 2001 2002 2003 2003 2004 2004
PERSONAL SERVICES I
101 Regular Salaries 0 0 0 2,164 0 2,000 2,000
102 O.T. Salaries 580 403 1,000 480 500 500
103 Part Time Salaries I
121 PERA City Share 30 22 158 27 130 130
122 FICA City Share 42 30 242 34 190 190
131 Ins. City Share 0 43 350 50 100 100
Total 0 653 498 3,914 590 .2,920 2,920 I
SUPPLIES
200 Office Supplies 301 308 0 0 300 300
212 Motor Fuel & Lube I
221 Maint-Equipment
223 Maint-Buildings
240 Small Tools I
245 General Supplies 1,539 675 1,694 750 990 1,000 1,000
Total 1,840 983 1,694 750 990 1,300 1,300
OTHER SERVICES I
301 Financial & Auditing
302 Consulting
303 Engineering I
304 Legal
321 Communication
331 Travel, Conf,Sch
351 PrinVPublish 13 I
360 Insurance-Total
380 Utilities-Gas/Elec
400 Contractual 85,427 102,376 102,382 106,231 89,842 113,120 113.120 I
410 Rental
433 Subscrip-Member
437 Ucenses- Taxes
440 Misc. Services 114 119 116 150 90 120 120 I
450 Service Charges 23 21 19 25 11 20 20
Total 85.577 102.516 102,516 106,406 89,944 113,260 113,260
TOTAL ACCOUNT 87,417 104,151 104,709 111,070 91,524 117,480 117,480 I
I
150 I
I
I BUDGET COMMENTS: RECYCLING FUND REVENUES
REVENUES
I 33620 Recycling Aid from Hennepin County - 2004 contract=$21 ,640
I 37310 Residential Charges for Recycling Services - $1.75/mo/household
37320 Residential Charges for City Clean-Up
I 37340 Revenue from Recycling Contractor from Sale of Recyclables
I EXPENSES
I CODE #
I 101 .05 Receptionist/Secretary
Light Equip. Operator - City Clean Up
I
245 General supplies
I
I
351 Publishing & Promotion
I 400 E-Z Recycling - Residential Recycling (2,720 x $2.35 x 12) 76,700
(2,720 x $2.20 x 12)
I City Clean-up - Spring & Fall 36,000
I
I
I
I
I
I 151
I
FUND # 631 STORMWATER MANAGEMENT FUND DEPT # 49600 I
REVENUES
CODE REVENUE SOURCE Actual Actual Actual Budget YTD Sept Proposed Adopted
# 2000 2001 2002 2003 2003 2004 2004 I
36101 Special Assessments 0 0 0 0 0 82,800 82,800
36210 Interest Income 17,505 5,044 5,576 1,500 2,299 3,000 3,000
36270 Miscellaneous Revenue 206 200,048 57,004 1,000 21,306 183,300 183,300 I
37410 Storm Utility Charges 52,134 48,425 43,985 59,500 27,946 59,500 59,500
39203 Transfers 10,000 10,000 35,000 18,000 0 25,000 25,000
Totals 79,845 263,516 141,565 80,000 51,551 353,600 353,600 I
EXPENSES
Code Actual Actual Actual Budget YTD Sept Proposed Adopted
# ITEM 2000 2001 2002 2003 2003 2004 2004
PERSONAL SERVICES I
101 Regular Salaries 1,873 2,033 1,843 9,143 1,279 9,405 9,405
102 O.T. Salaries 45 0 I
103 Part Time Salaries 0
121 PERA City Share 99 105 102 506 71 520 520
122 FICA City Share 134 149 138 699 98 720 720
131 Ins. City Share 190 186 215 1,180 150 1,334 1,334 I
Total 2,340 2,473 2,299 11,528 1,598 11 ,979 11,979
SUPPLIES
200 Office Supplies I
221 Maint-Equipment
240 Small Tools 300 300
245 General Supplies 642 600 3,376 2,000 0 2,000 2,000 I
Total 642 600 3,376 2,000 0 2,300 2,300
OTHER SERVICES & CHARGES
301 Financial & Audit I
303 Engineering 3,985 28,251 740 5,000 15,024 7,000 7,000
304 Legal
321 Communication I
331 Travel, Conf,Sch
351 Print/Publish 13 211 45 400 400
360 Insurance-Total
400 Contractual 2,358 4,415 5,820 5,000 5,000 5,000 I
420 Depreciation 1,094 5,276 4,376 4,400 3,282 4,400 4,400
433 Subscrip-Member 579 426 250 250
440 Misc. Services 74 6,168 904 3,500 892 1,000 1,000 I
450 Service Charges 176 78 67 150 45 150 150
Total 7,699 44,399 12,486 18,095 19,669 18,200 18,200
CAPITAL OUTLAY I
580 Other Improvements 0 0 0 0 0 291,000 291,000
Total 0 0 0 0 0 291,000 291,000
DEBT SERVICE I
Bond Principal 200,000 20,000 30,000 0 30,000 30,000
611 Bond Interest 6,767 9,863 8,877 0 7,397 7,397
620 Agent Fees I
Total 0 206,767 29,863 38,877 0 37,397 37,397
TRANSFERS
720 Permanent 0 0 0 0 0 0 0 I
Total 0 0 0 0 0 0 0
TOTAL ACCOUNT 10,682 254,240 48,023 70,500 21,267 360,876 360,876 I
152
I
I BUDGET COMMENTS: STORMWATER MANAGEMENT FUND
REVENUES
I
I
37410
36270
Stormwater Utilty Fees (Includes 2003 rate change: 2950 properties * $5.04 average rate * 4 quarters)
Grant Money from Watershed District for Gideon Glen purchase ($200,000 - 2001)
Grant Money from Minnehaha Creek Watershed District for Gideon Glen Improvements ($183,300 - 2004)
39203
Interfund Loan transfer in from Sewer Fund for Gideon Glen Purchase ($400,000 - 2000)
Transfer in from Genl Fund ($25,000 - 2004 - Cell Antenna Revenue)
I
EXPENSES
I
I
I
CODE #
101 .10 Light Equipment Operator
.05 Senior Accounting Clerk
.10 Accounting Clerk
240 Jetter tips & nozzels (2004)
245 Culverts and Appurtences
Catch Basin Frames, Rings and Grates
I
I
I
I
I
303 Internal & Contractual Engineering for Storm Drainage System
351 NPDES reporting
400 Contractual Repairs to Storm Drainage System (outside of CIP items)
580 Gideon Glen Project - Year 2000 Land Purchase ($400,000)
Gideon Glen Project (to be funded with Watershed Grant. $183,300 - 2004)
Glen Road Drainage Improvement ($25,000 - 2004)
Boulder Bridge Storm Lift (to be funded with special assessments. $82,800 - 2004)
I
620 Debt service - Gideon Glen Land Acquisition Loan Repayment ($37,397 prin + int - 2004)
720
I
I
I
I
I
153
I
FUND: #640 FUND: Liquor DEPT #49750
BUDGET Actual Actual Budget YTD Sept Proposed Adopted I
ITEM 2001 2002 2003 2003 2004 2004
SALES
37811 Liquor 787,200 754,840 603,000 362,592 674,400 674,400 I
37812 Wine 618,992 579,589 515,000 286,718 595,000 595,000
37813 Beer 1,095,632 1,061,568 783,000 488,164 868,000 868,000
37814 Miscellaneous 120,321 111,066 85,000 49,731 86,645 86,645 I
TOTAL SALES 2,622,145 2,507,063 1,986,000 1,187,206 2,224,045 2,224,045
COST OF GOODS SOLD
251 liquor 600,838 572,013 454,000 273,724 522,000 522,000 I
252 Wine 424,592 394,077 356,000 185,602 412,000 412,000
253 Beer 839,677 791,961 603,000 354,672 665,000 665,000
254 Miscellaneous 96,991 71,803 "4,000 38,072 46,909 46,909 I
TOTAL COST OF GOODS SOLD 1 ,962,099 1 ,829,854 1 ,487,000 852,069 1,645,909 1 ,645,909
GROSS PROFIT 660,046 677,209 499,000 335,136 578,136 578,136 I
EXPENSES 0.74828 0.72988 0.74874 0.71771 0.74005 0.74005
PERSONAL SERVICES
101 Regular Salaries 162,358 166,010 141,920 108,069 159,378 159,378 I
102 O.T. Salaries 164 343 0 0 0 0
103 Part Time Salaries 79,719 72,541 44,564 22,883 55,600 55,600
121 PERA City Share 9,758 12,860 10,723 7,204 10,750 10,750 I
122 FICA City Share 18,429 17,866 14,266 10,035 11,780 11,780
131 Ins. City Share 19,548 21,651 22,000 12,227 34,969 34,969
141 Unemployment Comp 311 14 0 54 0
151 Workers Comp 648 3,201 0 0 0 I
Total 290,934 302,702 233,473 160,472 272,477 272,477
SUPPLIES
200 Office Supplies 1,205 1,170 800 306 700 700 I
201 Postage 34 0 200 0 200 200
221 Maint-Equipment 4,939 5,420 3,000 2,754 3,500 3,500
223 Maint-Buildings 1,658 923 0 271 0 0 I
245 General Supplies 5,076 5,451 4,000 2,145 3,600 3,600
Total 12,912 11,325 8,000 5,477 8,000 8,000
OTHER SERVICES I
301 Audit & Accounting 4,148 4,715 2,850 2,846 2,850 2,850
302 Consulting Fees 0 0 0 0 20,000 0
304 Legal 1,158 3,039 0 369 0 0 I
321 Communication 4,945 3,983 3,000 1,882 3,000 3,000
331 Travel, Conf,Sch 2,908 1 ,486 1,600 524 1,600 1,600
342 Advertising & Promo 10,374 7,694 8,000 7,089 8,000 8,000 I
351 Print/Publish 342 0 240 157 240 240
360 Insurance-Total 12,597 13,512 9,200 11,988 19,000 19,000
380 Utilities-Gas/Elec 24,309 20,541 14,500 11,289 15,400 15,400 I
400 Contractual 2,962 2,221 1,160 6,384 1,700 1,700
410 Rent 167,433 149,171 135,000 83,177 125,000 125,000
420 Depreciation 9,662 10,085 7,300 7,271 14,800 14,800 I
432 Uncollectible Checks 4,504 2,849 2,000 0 1,000 1,000
433 Dues & Subscriptions 640 695 200 1,530 500 500
437 Taxes/Licenses 1,360 1,250 540 540 540 540 I
440 Mise Services 0 100 0 0 0 0
154 I
I
FUND: #640 FUND: Liquor
IBUDGET
ITEM
445 Credit Card Fees
Total
CAPITAL OUTLAY
1560 Furniture & Fixtures
Total
TOTAL EXPENSES
I TOTAL OPERATING INCOME/(LOSS)
720 Transfers In/(Out)
Misc Revenue/(Expense)
I NET INCOME/(LOSS)
DEPT #49750
Actual Actual Budget YTD Sept Proposed Adopted
2001 2002 2003 2003 2004 2004
21,006 21,472 16,500 12,629 18,000 18,000
268,347 242,813 202,090 147,676 231,630 211,630
0 0 30,000 3,109 20,000 20,000
0 40,000 30,000 3,109 20,000 20,000
572,193 596,840 473,563 316,733 532,107 512,107
87,853 80,369 25,437 18,403 46,029 66,029
(10,000) (30,000) (20,000) 0 (30,000)
4,502 10,680 9,000 5,390 11,000 11,000
82,355 61,048 14,437 23,793 57,029 47,029
I
I
I
I
I
I
I
I
I
I
I
I
I
155
FUND: #640
FUND: LIQUOR
I
I
HIGHLIGHTS/COMMENTS:
Estimated liquor sales less cost of goods sold
I
I
Revenues:
Expenses:
Staffing:
I
1.00 Operations Manager
2.00 Assistant Managers
1.00 Full Time Clerks
.15 Senior Accounting Clerk
10.00 Part time Sales Clerks
Finance and Auditing Services
Consulting Services include Marketing Study for former Tonka Bay Store
General and Liquor Liability Insurance
Electric & Gas Utilities, and Refuse Hauling
Building Rental
Advertising
Credit Card Service Charges
Depreciation
I
I
I
I
Supplies/Materials:
Office Supplies, Bags, Postage
Other Services:
Interest Income & Service Charges
I
I
I
I
Capital Outlay:
Misc. Revenue/Expenditures:
I
I
I
I
I
156
I
I
I
I
I
I
I
I
FUND:
Liquor
MISSION:
To control the sale and distribution of
packaged alcholic beverages within the
City and to provide property tax relief
the use of operation profits.
SUBFUND:
Waterford
FUND NO:
642
DESCRIPTION OF ACTIVITY:
Provides for the sale of packaged alcoholic beverages to the general public.
OBJECTIVES:
_ Effectively control the sale of packaged alcoholic beverages in the City
HIGHLIGHTS/COMMENTS:
Revenues:
I Estimated liquor sales
Expenses:
I
I
I
I
I
I
I
I
I
I
I
Staffing:
.50 Operations Manager
1.00 Assistant Manager
5.00 Part time Sales Clerks
.05 Senior Accounting Clerk
Supplies/Materials:
Office Supplies, Postage, Equipment Repair, Bags
Services & Charges:
Finance and Auditing Services
Contractual Rug Service
General and Liquor Liability Insurance
Electric & Gas Utilities, and Refuse Hauling
Building Rental - red,uced through reduction in floor space
Advertising
Credit Card Service Charges
Capital Outlay:
Misc. Revenue/Expenditures:
Interest Income & Service Charges
157
I
FUND: # 642 SUB FUND: Liquor - Waterford DEPT #
BUDGET Actual Actual Budget YTD Sept Proposed Adopted I
ITEM 2001 2002 2003 2003 2004 2004
REVENUE I
Sales 774,745 792,260 846,000 610,226 856,600 856,600
Cost of Goods 562,372 575,759 634,000 433,951 634,000 634,000 I
GROSS PROFIT 212,372 216,501 212,000 176,275 222,600 222,600
EXPENSES I
Staffing 73,187 97,522 105,908 83,872 112,967 112,967
Supplies/Materials 3,878 4,746 4,000 2,500 4,000 4,000 I
Support Services 115,188 97,251 88,075 69,751 93,265
93,265
Depreciation 5,771 4,854 5,800 3,589 4,800 4,800 I
Capital Outlay
TOTAL EXPENSES 198,023 204,373 203,783 159,713 215,032 215,032 I
TOTAL OPERATING INCOME (LOSS) 14,349 12,128 8,217 16,562 7,568 7,568
Transfers In/(Out) 0 0 (5,000) 0 (5,000) (5,000) I
Misc. Revenue/(Expense) (13,736) (6,453) (1,000) (66) (1,000) (1,000)
NET INCOME (LOSS) 613 5,675 2,217 16,496 1,568 1,568
BUSINESS INDICATORS: I
Gross Profit as a % of Sales 27.41 % 27.33% 25.06% 28.89% 25.99% 25.99%
Oper. Income as a % of Sales 1.85% 1.53% 0.97% 2.71% 0.88% 0.88% I
CASH FLOW IMPACT:
Beginning Cash Balance (159,160) (181,233) (161,251) (181,233) (161,251 ) (161,251 ) I
Net Operating lncome/(Loss) 14,349 12,128 8,217 16,562 7,568 7,568
Depreciation 5,771 4,854 5,800 3,589 4,800 4,800
Other Cash Flow Impacts (42,193) 3,000 3,000 3,000 I
Ending Cash Balance (181,233) (161,251 ) (144,234) (158,082) (148,883) (148,883)
STAFFING: I
Full time:
Operations Manager .33 .33 .33 .33 .50 .50 I
Assistant Manager 1.00 1.00 1.00 1.00 1.0 1.0
Full Time Clerk
Sr. Acctg. Clerk .05 .05 .05 .05 .05 .05 I
Part time:
Sales Clerks 5.00 5.00 5.00 5.00 5.00 5.00
I
I
158 I
1
FUND: #642 SUBFUND: Liquor - Waterford DEPT #49750
IUDGET Actual Actual Budget YTD Sept Proposed Adopted
ITEM 2001 2002 2003 2003 2004 2004
IALES
7811 Liquor 224,539 224,836 245,000 176,976 243,000 243,000
37812 Wine 175,226 186,741 192,000 139,490 202,000 202,000
7813 Beer 338,328 345,707 369,000 268,870 375,000 375,000
7814 Miscellaneous 36,651 34,975 40,000 24,890 36,600 36,600
TOTAL SALES 774,745 792,260 846,000 610,226 856,600 856,600
COST OF GOODS SOLD
151 Liquor 162,952 171 ,176 182,000 130,459 190,000 190,000
52 Wine 117,038 126,519 134,000 90,117 140,000 140,000
253 Beer 254,798 259,456 283,000 193,686 285,000 285,000
54 Miscellaneous 27,584 18,607 35,000 19,689 19,000 19,000
TOTAL COST OF GOODS SOLD 562,372 575,759 634,000 433,951 634,000 634,000
GROSS PROFIT 212,372 216,501 212,000 176,275 222,600 222,600
tXPENSES
PERSONAL SERVICES
1101 Regular Salaries 36,806 57,755 62,293 58,470 64,965 64,965
102 O.T. Salaries 8 23 0 0 0 0
103 Part Time Salaries 23,193 24,006 22,282 9,907 25,000 25,000
121 PERA City Share 2,449 4,297 4,863 3,833 4,499 4,499
1122 FICA City Share 4,862 5,938 6,470 5,271 4,028 4,028
131 Ins. City Share 5,643 3,904 10,000 6,391 14,475 14,475
141 Unemployment Comp 10 0 0 0 0 0
1151 Workers Comp 216 1,600 0 0 0 0
Total 73,187 97,522 105,908 83,872 112,967 112,967
SUPPLIES
1200 Office Supplies 409 311 400 102 300 300
201 Postage 11 100 0 100 100
221 Maint-Equipment 1,200 2,258 1,500 1,350 2,000 2,000
223 Maint-Buildings 526 177 0 221 0 0
1245 General Supplies 1,731 1,999 2,000 827 1,600 1,600
Total 3,878 4,746 4,000 2,500 4,000 4,000
OTHER SERVICES
1301 Audit & Accounting 1,383 1,572 1 ,425 1,423 1 ,425 1 ,425
302 Consulting Fees 0 0 0 0 0 0
304 Legal 458 1 ,453 0 84 0 0
1321 Communication 1,570 1,343 1,500 939 1,500 1,500
331 Travel, Conf,Sch 957 525 800 262 800 800
342 Advertising & Promo 4,064 3,695 4,000 3,900 4,000 4,000
1 351 Print/Publish 114 0 120 79 120 120
360 Insurance-Total 3,500 4,292 4,200 5,994 9,500 9,500
380 Utilities-Gas/Elec 7,991 6,458 6,000 5,035 6,400 6,400
400 Contractual 636 479 660 358 500 500
1 410 Rent 86,114 68,428 61,000 44,535 60,000 60,000
420 Depreciation 5,771 4,854 5,800 3,589 4,800 4,800
432 Uncollectible Checks 1,308 1,152 1,000 0 500 500
I 433 Dues & Subscriptions 213 247 100 765 250 250
437 Taxes/Licenses 520 500 270 270 270 270
440 Misc Services 100 0 0 0 0
1 445 Credit Card Fees 6,465 7,008 7,000 6,107 8,000 8,000
Total 120,959 102,105 93,875 73,340 98,065 98,065
1 159
FUND: #642 SUBFUND: Liquor - Waterford
BUDGET Actual Actual Budget
ITEM 2001 2002 2003
CAPITAL OUTLAY
560 Fumiture & Fixtures
Total 0 0 0
TOTAL EXPENSES 198,023 204,373 203,783
TOTAL OPERATING INCOME/(LOSS) 14,349 12,128 8,217
720 Transfers In/(Out} (5,000)
Misc Revenue/(Expense} (13,736) (6,453) (1,000)
NET INCOME/(LOSS) 613 5,675 2,217
YTD Sept
2003
Proposed
2004
DEPT #49750
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
Adopted
2004
160
1,923
1,923
161,635
14,640
(66)
14,574
o
o
215,032
7,568
(5,000)
(1,000)
1,568
o
o
215.032
7,568
(5,000)
(1,000)
1,568
I
FUND: #642 SUBFUND: Liquor - Waterford
I
HIGHLIGHTS/COMMENTS:
levenues:
Estimated liquor sales
Ixpenses:
rtaffing:
.5 Operations Manager
1.00 Assistant Manager
15.00 Part time Sales Clerks
.05 Senior Accounting Clerk
IsuPPlies/Materials:
Office Supplies, Bags, Postage
IOther Services:
Finance and Auditing Services
I Contractual Rug Service
General and Liquor Liability Insurance
Electric & Gas Utilities, and Refuse Hauling
Building Rental
I Advertising
Credit Card Service Charges
Depreciation
I Capital Outlay:
Misc. Revenue/Expenditures:
I Interest Income & Service Charges
I
I
I
I
I
I
I
161
I
FUND NO:
641
MISSION:
To control the sale and distribution of
packaged alcholic beverages within the
City and to provide property tax relief
the use of operation profits.
I
FUND:
Liquor
SUBFUND:
Shorewood Plaza
I
DESCRIPTION OF ACTIVITY:
Provides for the sale of packaged alcoholic beverages to the general public.
I
OBJECTIVES:
_ Effectively control the sale of packaged alcoholic beverages in the City
_ Provide a profit equal to at least 2% of sales for transfer to the General Fund
I
I
HIGHLIGHTS/COMMENTS:
Revenues:
I
Estimated liquor sales
I
Expenses:
Staffing:
.50 Operations Manager
1.00 Assistant Manager
1.00 Full Time Clerk
5.00 Part time Sales Clerks
.05 Senior Accounting Clerk
I
I
Supplies/Materials:
I
Office Supplies, Postage, Equipment Repair, Bags
I
Services & Charges:
Finance and Auditing Services
Contractual Rug Service
General and Liquor Liability Insurance
Electric & Gas Utilities, and Refuse Hauling
Building Rental
Advertising
Credit Card Service Charges
I
I
Capital Outlay:
Completely remodeled store in 2003
Computer inventory & accounting software systems (2004)
I
Misc. Revenue/Expenditures:
Interest Income & Service Charges
I
I
I
162
I
I
FUND: # 641 SUBFUND: Liquor - Shorewood Plaza DEPT #
I BUDGET Actual Actual Budget YTD Sept Proposed Adopted
ITEM 2001 2002 2003 2003 2004 2004
I REVENUE
Sales 1,086,613 986,844 1,140,000 576,980 1 ,367,445 1,367,445
I Cost of Goods 813,073 714,346 853,000 418,118 1,011,909 1,011,909
GROSS PROFIT 273,540 272,499 287,000 158,862 355,536 355,536
I EXPENSES
Staffing 117,261 104,673 127,565 76,600 159,510 159,510
I Supplies/Materials 4,733 4,967 4,000 2,976 4,000 4,000
Services & Charges 88,860 86,660 106,715 70,653 103.565 103,565
I Depreciation 1.848 3,188 1.500 3,682 10,000 10,000
Capital Outlay 0 0 30,000 1,186 20,000 20,000
I TOTAL EXPENSES 212,702 199,487 269,780 155,098 297,075 297,075
NET OPERATING INCOME (LOSS) 60,838 73,011 17,220 3,764 58,461 58,461
Transfers In/(Out) (5,000) (15,000) (15,000) 0 (25,000) (25,000)
I Misc. Revenue/(Expense) 7,697 11,740 10,000 5,456 12,000 12,000
NET INCOME (LOSS) 63,535 69,752 12,220 9,219 45,461 45,461
I BUSINESS INDICATORS:
Gross Profit as a % of Sales 25.17% 27.61 % 25.18% 27.53% 26.00% 26.00%
I Oper. Income as a % of Sales 5.60% 7.40% 1.51% 0.65% 4.28% 4.28%
CASH FLOW IMPACT:
I Beginning Cash Balance 287,570 280,742 361,442 280,742 361,442 361,442
Net Operating Income/(Loss) 60,838 73,011 17,220 3,764 58,461 58,461
Depreciation 1,848 3,188 1,500 3,682 10,000 10,000
I Other Cash Flow Impacts (69,514) 4,500 4,500 4,500 (5,000) (5,000)
Ending Cash Balance 280,742 361 ,442 384,662 292,688 424,903 424,903
I STAFFING:
Full time:
I Operations Manager .33 .33 .33 .33 .50 .50
Assistant Manager 1.00 1.00 1.00 1.00 1.00 1.00
Full Time Clerk \I 1.00 1.00
Sr. Acctg. Clerk .05 .05 .05 .05 .05 .05
I Part time:
Sales Clerks 5.00 5.00 5.00 5.00 5.00 5.00
I
I
I 163
FUND: #641 SUBFUND: Liquor - Shorewood Plaza
BUDGET Actual Actual Budget YTD Sept
ITEM 2001 2002 2003 2003
CAPITAL OUTLAY
560 Furniture & Fixtures 0 30,000 1,186
Total 0 0 30,000 1,186
TOTAL EXPENSES 212,702 199,487 269,780 155,098
TOTAL OPERATING INCOME/(LOSS} 60,838 73,011 17,220 3,764
720 Transfers In/(Out} (5,000) (15,000) (15,000) 0
Mise Revenue/(Expense} 7,697 11,740 10,000 5,456
NET INCOME/(LOSS} 63,535 69,752 12,220 9,219
Proposed
2004
DEPT #49750
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
Adopted
2004
164
20,000
20,000
297,075
58,461
(25,000)
12,000
45,461
20,000
20,000
297,075
58,461
(25,000)
12,000
45,461
I
FUND: #641 SUB FUND: Liquor - Shorewood Plaza DEPT #49750
IBUDGET Actual Actual Budget YTD Sept Proposed Adopted
ITEM 2001 2002 2003 2003 2004 2004
I SALES
37811 Liquor 341,798 321,756 358,000 185,616 431,400 431 ,400
37812 Wine 311,242 267,770 323,000 147,228 393,000 393,000
37813 Beer 390,325 361,024 414,000 219,294 493,000 493,000
137814 Miscellaneous 43,247 36,296 45,000 24,841 50,045 50,045
TOTAL SALES 1,086,613 986,844 1,140,000 576,980 1,367,445 1,367,445
COST OF GOODS SOLD
1251 Liquor 262,707 239,297 272,000 143,264 332,000 332,000
252 Wine 215,692 180,520 222,000 95,485 272,000 272,000
253 Beer 299,883 268,470 320,000 160,986 380,000 380,000
1254 Miscellaneous 34,790 26,058 39,000 18,383 27,909 27,909
TOTAL COST OF GOODS SOLD 813,073 714,346 853,000 418,118 1,011,909 1,011,909
GROSS PROFIT 273,540 272,499 287,000 158,862 355,536 355,536
I EXPENSES 0.72467
PERSONAL SERVICES
101 Regular Salaries 69,266 56,360 79,627 49,599 94,413 94,413
1 102 O.T. Salaries 25 8 0 0 0 0
103 Part Time Salaries 30,453 28,160 22,282 12,976 30,600 30,600
121 PERA City Share 3,843 4,553 5,860 3,372 6,251 6,251
I 122 FICA City Share 7,194 6,339 7,796 4,765 7,752 7,752
131 Ins. City Share 5,974 7,640 12,000 5,835 20,494 20,494
141 Unemployment Comp 290 14 0 54 0 0
I 151 Workers Comp 216 1,600 0 0 0 0
Total 117,261 104,673 127,565 76,600 159,510 159,510
SUPPLIES
I 200 Office Supplies 340 399 400 204 400 400
201 Postage 11 100 0 100 100
221 Maint-Equipment 2,180 1,560 1,500 1 ,405 1,500 1,500
223 Maint-Buildings 272 746 0 50 0 0
I 245 General Supplies 1,929 2,261 2,000 1,318 2,000 2,000
Total 4,733 4,967 4,000 2,976 4,000 4,000
OTHER SERVICES
I 301 Audit & Accounting 1,383 1,572 1,425 1 ,423 1,425 1 ,425
302 Consulting Fees 0 0 0 0 0
304 Legal 350 706 0 284 0 0
I 321 Communication 1,554 1,543 1,500 942 1,500 1,500
331 Travel, Conf,Sch 1,102 512 800 262 800 800
342 Advertising & Promo 3,446 2,515 4,000 3,190 4,000 4,000
I 351 Print/Publish 114 120 79 120 120
360 Insurance-Total 3,519 4,309 5,000 5,994 9,500 9,500
380 Utilities-Gas/Elec 8,280 7,286 8,500 6,254 9,000 9,000
400 Contractual 552 949 500 6,026 1,200 1,200
I 410 Rent 56,735 56,971 74,000 38,642 65,000 65,000
420 Depreciation 1,848 3,188 1,500 3,682 10,000 10,000
432 Uncollectible Checks 1,587 838 1,000 0 500 500
I 433 Dues & Subscriptions 213 247 100 765 250 250
437 Taxes/Licenses 520 500 270 270 270 270
440 Misc Services 0 0 0 0 0 0
445 Credit Card Fees 9,364 8,714 9,500 6,522 10,000 10,000
I Total 90,708 89,848 108,215 74,335 113,565 113,565
1 165
FUND: #641
SUBFUND: Liquor - Shorewood Plaza
HIGHLIGHTS/COMMENTS:
Revenues:
Estimated liquor sales
Expenses:
Staffing:
.5 Operations Manager
1.00 Assistant Manager
1.00 Full Time Clerk II
5.00 Part time Sales Clerks
.05 Senior Accounting Clerk
Supplies/Materials:
Office Supplies, Bags, Postage
Other Services:
Finance and Auditing Services
Contractual Rug Service
General and Liquor Liability Insurance
Electric & Gas Utilities, and Refuse Hauling
Building Rental
Advertising
Credit Card Service Charges
Depreciation
Capital Outlay:
Completely remodeled store in 2003
Computer inventory & accounting software systems (2004)
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
166
I