110501 CC Ws AgP
~
is
.
-<
tit t I
!j-~ ~l
.... . tSj;I
~ .f-t
:.i .
CITY OF
SHOREWOOD
5755 COUNTRY CLUB ROAD. SHOREWOOD, MINNESOTA 55331-8927. (952) 474-3236
FAX (952) 474-0128. www.cLshorewood.mn.us. cityhall@cLshorewood.mn.us
MEMORANDUM
DATE:
November 2,2001
TO:
Honorable Mayor and City Councilmembers
Bonnie Burton, Finance Director ~
Craig W. Dawson, City Administrator rb>
Enterprise Fund Budget Workshop:
Work-session Monday, November 5, 2001
FROM:
RE:
Attached for your review are Year 2002 budget drafts for the City's Enterprise Funds.
These documents will be discussed at the work session on Monday night. The documents
consist of budgets for the Liquor Operations, Water Operations and Water Debt Service,
Sanitary Sewer Fund, Stormwater Management, and Recycling Funds.
Liquor Operations
The Liquor Operations budgets assume that business will be conducted as usual and sales
and expenditures will be maintained at current 2001 levels. The budgets have been
developed very conservatively to accommodate the uncertainty associated with each
location.
Locations and Leases
The liquor stores each have some uncertainty associated with their physical locations and
this uncertainty could impact 2002 business activity. For example, the Tonka Bay store
will have to be relocated when the County Road 19 construction commences. The Liquor
Committee will meet soon with the City of Tonka Bay to discuss future liquor locations,
and whether that will be in the strip mall shopping center or across the street temporarily
at the former Total Gas location. It is our hope to have no break in operations when this
move has to be made.
The Waterford Plaza lease is subject to renewal for the first time in 7 years and staff is
negotiating very persistently to reduce the amount ofrent we must pay. We are willing to
ft
\oJ PRINTED ON RECYCLED PAPER
Enterprise Budget Work-Session
Page 2
accept a smaller physical space in order to reduce this lease expense. This store has
consistently operated at a loss and the City's Auditor has advised that it would be a
prudent business decision to consider closing the store if we are unable to reduce
expenditures. We remain hopeful of negotiating a favorable arrangement to avoid this
alternative. This lease expires in February 2002.
Lastly, the future of the Shorewood Plaza store remains unknown at this time with the
potential of various development proposals. If these proposals are ultimately
unsuccessful, we anticipate business as usual and will plan for capital improvements such
as carpeting, countertops, and gondolas.
The Liquor Committee at its October 22 meeting reviewed the Liquor Operations budgets
and the committee recommends approval of the budgets by the City Council.
Water Budget
The City currently has about 1,590 connections to its Water System. The 2002 budget
projections show the fund operating at a deficit, primarily because the City of Victoria
Tower Revenue contract ended in 2000. Under this contract, Victoria paid Shorewood
$49,000 annually, and the City applied these funds to the water debt service account. To
offset this change, an increase is required in the amount transferred from the Water
Operating Fund. For example, the transfer to the water debt service in 2000 was $45,000
and in 2002, it will be $110,000.
Capital improvements for 2002 are estimated at $136,000 and include interconnection of
the Woodhaven Well with Excelsior and repair ofthe turbine pump at Boulder Bridge.
These improvements were previously scheduled for 2001. In addition, other
improvements contemplated include alarm systems installed on the water towers and
some funds to be set aside ($10,000) to begin implementation of a radio water meter
reading system.
In order for the Water Funds to be self-supporting, it will be important to find alternate
sources of revenue to offset the loss of the Victoria Tower revenue. A water rate increase
may be necessary in order to assure the system is self-supporting, and that it can provide
for improvements and enhancements.
Sanitary Sewer Budget
The Sanitary Sewer Fund is in a good position. Substantial balances have enabled it to
fund projects such as Gideon Glen and Eddy Station through interfund loans. These loans
are being repaid on schedule from the Stormwater Management Fund and the Park Fund.
Revenues and Expenditures for year 2002 are very similar to budget 2001, with the
exception that certain capital improvements scheduled for 2001 will be implemented
during 2002.
.
.
Enterprise Budget Work-Session
Page 3
Capital improvements for year 2001-2002 include refurbishment of Shady Island and
Birch Bluff Lift Stations (approximately $100,000) and the installation of three (3)
alarm/autodialers to lift stations 5,11, and 15. In addition, this budget contemplates the
purchase of 1/3 interest in a Vacuum Jetter Truck to be shared with the cities of Excelsior
and Tonka Bay ($80,000). This truck will allow for the safe cleaning and jetting of the
city sewer lines. Ifthe truck is not purchased, the City will contract with a service for
scheduled sewer cleaning ($20,000).
Storm water Mallagemellt altd Recyclillg Budgets
The Stormwater Management and Recycling Budgets are stable and should experience no
substantial change during year 2002. The City will continue to receive about $21,000
from Hennepin County Grant Funds through 2004. We do note that households
participating in the recycling program appear to have declined from an average of 1,300
to about 1,100 households per month.
COllclusioll
We invite your response and comments on the Enterprise Budgets. Please advise if you
would like additional information or if we can be of further assistance prior to the work-
session.
CITY OF SHOREWOOD,
MINNESOTA
2002 LIQUOR OPERATIONS BUDGET
November 1,2001
/l
~4~;-
FUND:
Liquor
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.
SUBFUND:
DESCRIPTION 9F 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
- Reduce rent in Waterford Store through reduction of floor space
- Produce a reasonable net profit
- Find a new location for Tonka Bay Store
- Remodel Plaza Store
HIGHLIGHTS/COMMENTS:
Revenues:
Estimated liquor sales: approximately the same as 2001
Expenses:
Staffing:
1.00 Operations Manager
5.00 Assistant Managers
.15 Senior Accounting Clerk
14.00 Part time Sales Clerks
Supplies/Materials:
Office Supplies, Bags, Postage
Services & Charges:
Finance and Auditing Services
. Contractuall~ug$ervice
General and Liquor Liability Insurance
Electric & Gas Utilities, and Refuse Hauling
Building Rental
Advertising
Credit Card Service Charges
Leasing:
Possible down-sizing of Waterford Store has potential
of reducing.lease expense by est $30,000 annually
Capital Outlay: Shorewood Plaza Store Improvements ($40,000)
Transfers Out:
Transfer to General Fund
Misc. Revenue/Expenditures:
Interest Income & Service Charges
2
FUND: # 640 SUB FUND: Liquor Operations DEPT #
BUDGET Actual Actual Budget YTD Aug Annual Proposed Adopted
ITEM 1999 2000 2001 2001 Est-01 2002 2002
REVENUE
Sales 2,320,164 2,532,379 2,863,000 1,703,992 2,555,988 2,692,130 0
Cost of Goods 1,837,915 1,888,069 2,204,510 1,110,710 1,841,871 2,034,864 0
GROSS PROFIT 482,249 644,310 658,490 593,283 714,117 657,266 0
EXPENSES
Staffing 211,786 . 259,076 287,230 186,485 279,727 302,702 0
Supplies/Materials 12,909 14,854 13,325 9,885 14,827 11,325 0
Services & Charges 232,762 251,081 275,535 174,695 262,042 255,195 0
Depreciation 9,489 6,609 9,490 5,456 8,184 6,770 0
Capital Outlay 0 0 50,000 8,992 9,000 40,000 0
TOTAL EXPENSES 466,946 531,620 635,580 385,512 573,780 615.992 0
TOTAL OPERATING INCOME (LOSS) 15,303 112,690 22,910 207,771 140,338 41,274 0
Transfers In/(Out) 0 (10.000) (10.000) 0 (10,000) (30,000) 0
Misc. Revenue/(Expense) 14,916 22,195 9,400 (4,876) 12,500 10,000 0
NET INCOME (LOSS) 30,219 124.885 22,310 202,895 142,838 21,274 0
SERVICE INDICATORS:
Gross Profit as a % of Sales 20.79% 25.44% 23.00% 34.82% 27.94% 24.41 %
Oper. Income as a % of Sales 0.66% 4.45% 0.80% 12.19% 5.49% 1.53%
CASH FLOW IMPACT:
Beginning Cash Balance 44.590 190.317 152,510 147,602 171.766 195,410 195,410
Net Operating IncomelLoss 8.834 112,690 22,910 207.771 140,338 41,274 0
Depreciation 9,489 6,609 9,490 5,456 8.184 6,770 0
Other Cash Flow Impacts 127,404 (157.106) 10,500 11.180 12,200 (800) 0
Ending Cash Balance 190.317 152,510 195,410 372.008 332,488 242,654 195,410
STAFFING:
Full time:
Operations Manager 1.00 1.00 1.00 1.00 1.00 1.00 1.00
Assistant Manager 3.00 3.00 3.00 3.00 3.00 3.00 3.00
Sr. Acctg. Clerk .15 .15 .15 .15 .15 .15 .15
Part time:
Sales Clerks 15.00 15.00 15.00 15.00 15.00 15.00 15.00
3
FUND:
Liquor
SUB FUND:
Shorewood Plaza
FUND NO:
641
DESCRIPTION OF ACTIVITY'
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.
Provides for the sale of packaged alcoholic beverages to the general public.
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
HIGHLIGHTS/COMMENTS:
Revenues:
Estimated liquor sales
Expenses:
Staffing:
.33 Operations Manager
2.20 Assistant Manager
.05 Senior Accounting Clerk
5.00 Part time Sales Clerks
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
Advertising
Credit Card Service Charges
Capital Outlay:
. Counter, carpet, paint, gondolas $40,000
Misc. Revenue/Expenditures:
Interest Income & Service Charges
4
FUN.D: # 641 SUB FUND: Liquor - Shorewood Plaza DEPT #
BUDGET Actual Actual Budget YTD Aug Annual Proposed Adopted
ITEM 1999 2000 2001 2001 Est-01 2002 2002
REVENUE
Sales 978,818 1,093,956 1,210,000 701,703 1,052,554 1.115,500 0
Cost of Goods 792,228 810,884 931.700 436,048 654,071 836,625 0
GROSS PROFIT 186,590 283,072 278,300 265,655 398,483 278,875 0
EXPENSES
Staffing 75.238 101,236 103,821 69,116 103,674 116,819 0
Supplies/Materials 7,149 6,127 6,275 3,496 5,244 4,975 0
Services & Charges 76,905 90,187 95.250 62,240 93,360 96,395 0
Depreciation 1,365 244 1,365 280 420 420 0
Capital Outlay 0 0 50,000 8,992 9,000 40,000 0
TOTAL EXPENSES 167,126 197,794 256,711 144,124 211,698 258,609 0
NET OPERATING INCOME (LOS 19,464 85,278 21.589 121,531 186,784 20,266 0
Transfers In/(Out) 0 (5,000) (10,000) 0 (10,000) (15,000) 0
Misc. Revenue/(Expense) 9.285 14,813 5,000 (726) 10,000 10,000 0
NET INCOME (LOSS) 28.749 95,091 16,589 120,804 186,784 15,266 0
BUSINESS INDICATORS:
Gross Profit as a % of Sales 19.06% 25.88% 23.00% 37.86% 37.86% 25.00%
Oper. Income as a % of Sales 1.99% 7.80% 1.78% 17.32% 17.75% 1.82%
CASH FLOW IMPACT:
Beginning Cash Balance 132,349 229,346 245,354 245,354 245,354 272,808 272,808
Net Operating Income/(Loss) 19,464 85,278 21,589 121,531 186,784 20.266 0
Depreciation 1,365 244 1.365 280 420 420 0
Other Cash Flow Impacts 76,168 (69,514) 4,500 4,500 5,000 (5,000)
Ending Cash Balance 229,346 245,354 272,808 371.665 437.558 288,494 272,808
STAFFING:
Full time:
Operations Manager .33 .33 .33 .33 .33 .33 .33
Assistant Manager 1.00 1.00 1.00 1.00 1.00 2.20 2.20
Sr. Acctg. Clerk .05 .05 .05 .05 .05 .05 .05
Part time:
Sales Clerks 6.00 5.00 5.00 5.00 5.00 5.00 5.00
5
FUND NO:
642
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:
Waterford
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
_ Decrease operating loses through the reduction of leased floor space
HIGHLIGHTS/COMMENTS:
Revenues:
Estimated liquor sales
Expenses:
Staffing:
.33 Operations Manager
1.40 Assistant Manager
.05 Senior Accounting Clerk
5.00 Part time Sales Clerks
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 - reduced through reduction in floor space
Advertising
Credit Card Service Charges
Capital Outlay:
Misc. Revenue/Expenditures:
Interest Income & Service Charges
6
FUND: # 642 SUB FUND: Liquor - Waterford DEPT #
BUDGET Actual Actual Budget YTD Aug Annual Proposed Adopted
ITEM 1999 2000 2001 2001 Est-01 2002 2002
REVENUE
Sales 703,264 710,433 833,500 495,378 743,067 783,180 0
Cost of Goods 530,085 539,260 641,795 337,641 583,308 595,217 0
GROSS PROFIT 173,179 171,173 191,705 157,737 159,759 187,963 0
EXPENSES
Staffing 63,699 72,186 88,209 51,506 77 ,259 89,069 0
Supplies/Materials 3,212 4,020 4,725 3,411 5,116 3,425 0
Support Services 113,357 111,497 125,650 81,656 122,484 88,255 0
Depreciation 7,874 5,816 7,875 3,816 5,724 5,800 0
Capital Outlay
TOTAL EXPENSES 188,142 193,519 226,459 140,389 210,584 186,549 0
TOTAL OPERATING INCOME (LOSS (14,963) (22,346) (34,754) 17,348 (50,824 ) 1,414 0
Transfers In/(Out) 0 0 0 0 0 0 0
Misc. Revenue/(Expense) 908 (911 ) 0 (3,458) (3,500) 0 0
NET INCOME (LOSS) (14,055) (23,257) (34.754) 13,890 (54,324) 1,414 0
BUSINESS INDICATORS:
Gross Profit as a % of Sales 24.63% 24.09% 23.00% 31.84% 21.50% 24.00%
Oper. Income as a % of Sales (2.13%) (3.15%) (4.17%) 3.50% (6.84%) 0.18%
CASH FLOW IMPACT:
Beginning Cash Balance (166,804) (149,719) (208,442) (208,442) (184,278) (232,321 ) (232,321 )
Net Operating Income/(Loss) (14,963) (22,346) (34,754) 17,348 (50,824) 1,414 0
Depreciation 7,874 5,816 7.875 3,816 5,724 5,800 0
Other Cash Flow Impacts 24,174 (42,193) 3,000 3,000 3,000
Ending Cash Balance (149,719) (208,442) (232,321 ) (184,278) (226,379) (225,107) (232,321 )
STAFFING:
Full time:
Operations Manager .33 .33 .33 .33 .33 .33 0.33
Assistant Manager 1.00 1.00 1.00 1.00 1.00 1.40 1.40
Sr. Acctg. Clerk .05 .05 .05 .05 .05 .05 .05
Part time:
Sales Clerks 5.00 5.00 5.00 5.00 5.00 5.00 5.00
7
FUND NO:
643
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
SUB FUND:
Tonka Bay
DESCRIPTION OF ACTIVITY:
Provides for the sale of packaged alcoholic beverages to the general public.
This location was acquired in December, 1994.
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
HIGHLIGHTS/COMMENTS:
Revenues:
Estimated liquor sales
Expenses:
Staffing:
.33 Operations Manager
1.40 Assistant Manager
.05 Senior Accounting Clerk
4.00 Part time Sales Clerks
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
Advertising
Credit Card Service Charges
Capital Outlay:
Misc. Revenue/Expenditures:
Interest Income & Service Charges
8
FUND: # 643 SUBFUND: Liquor - Tanka Bay DEPT #
BUDGET Actual Actual Budget YTD Aug Annual Proposed Adopted
ITEM 1999 2000 2001 2001 Est-01 2002 2002
REVENUE
Sales 638,082 727,990 819,500 506,912 760,367 793,450 0
Cost of Goods 515,602 537,925 631,015 337,021 604,492 603,022 0
GROSS PROFIT 122,480 190,065 188,485 169,890 155,875 190,428 0
EXPENSES
Staffing 72,849 85,655 95,200 65,862 98,793 96,814 0
Supplies/Materials 2,548 4,707 2,325 2,978 4,466 2,925 0
Support Services 42,500 49,397 54,635 30,798 46,197 70,545 0
Depreciation 250 549 250 1,360 2,040 550 0
Capital Outlay 0 0 0 0 0 0 0
TOTAL EXPENSES 118,147 140,307 152,410 100,998 151,497 170,834 0
TOTAL OPERATING INCOME 4,333 49,758 36,075 68,892 4,378 19,594. 0
Transfers In/(Out) 0 (5,000) 0 0 0 (15,000) 0
Misc. Revenue/(Expense) 4,723 8,293 4,400 (691 ) 6,000 0 0
NET INCOME/(LOSS) 9,056 53,051 40,475 68,201 10,378 4,594 0
BUSINESS INDICATORS:
Gross Profit as a % of Sales 19.20% 26.11 % 23.00% 33.51 % 20.50% 24.00%
Oper. Income as a % of Sales 0.68% 6.83% 4.40% 13.59% 0.58% 2.47%
CASH FLOW IMPACT:
Beginning Cash Balance 79,045 110,690 115,598 110,690 110,690 154,923 154,923
Net Operating Income/(Loss) 4,333 49,758 36,075 68,892 4,378 19,594 0
Depreciation 250 549 250 1,360 2,040 550 0
Other Cash Flow Impacts 27,062 (45,399) 3,000 3,680 4,200 4,200
Ending Cash Balance 110,690 115,598 154,923 184,622 121,308 179,267 154,923
STAFFING:
Full time:
Operations Manager .33 .33 .33 .33 .33 .33 .33
Assistant Manager 1.00 1.00 1.00 1.00 1.00 1.40 1.40
Senior Acct. Clerk .05 .05 .05 .05 .05 .05 .05
Part time:
Sales Clerks 4.00 4.00 4.00 4.00 4.00 4.00 4.00
9
b
~4;<,~ .
CITY OF SHOREWOOD,
MINNESOTA
2002 WATER BUDGET
November 1, 2001
11
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.
FUND:
Water
FUND NO: 601
DESCRIPTION OF ACTIVITY:
Responsible for operation and maintenance of seven (7) well systems, including all
pumps and wellhouses, 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
- Perform pump repair of Boulder Bridge Well
HIGHLlGHTS/COMMENTS:
Revenues:
Estimated water sales based on quarterly billing at a tiered rate of $1.50 - $1.75/1,000 gallons
Connection and permit revenues estimated based on 20 new homes
Miscellaneous Income includes interest income and Cellular Antenna Space Rentals
Expenses:
Staffing:
.10 Senior Accounting Clerk
.30 Light Equipment Operator
.10 ReceptionisUSecretary
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
.15 City Engineer
.25 Engineering Technician
Support Services & Charges:
Engineering
Contract with Munitech for system maintenance - 5% increase from 2001
Water Operations Licenses & Training
Insurance on water system
Water testing & Water Quality ReportinlJ
Water system analysis
Capital Outlay:
Interconnect Woodhaven Well ($118,000 - 2002)
Pull & Repair Vertical Turbine Pump Boulder Bridge ($18,000 - 2002)
Radio Read Meter project ($10,000 - 2002)
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)
12
FUND: #601 FUND: Water Operations DEPT # 49400
BUDGET Actual Actual Budget YTD Sept Annual Proposed Adopted
ITEM 1999 2000 2001 2001 Est-01 2002 2002
REVENUE
Charges for Service 243,459 300,652 353,500 138,613 316,670 402,625 0
Misc. Revenue 67,227 116,648 72,700 24,552 62,000 60,000 0
TOTAL REVENUE . 310,686 417,300 426,200 163,165 378,670 462,625 0
EXPENSES
Staffing 25,477 12,595 22,064 10,002 22,064 41,373 0
Supplies/Materials 46,690 48,861 42,250 25,574 42,250 45,750 0
Support Services & Charges 128,731 120,131 131,850 103,638 134,000 139,200 0
Capital Outlay 698 5,111 136,000 0 0 140,000 0
Transfers 42,400 45,000 85,000 0 85,000 110,000 0
Depreciation 151,615 172,032 145,000 118,888 145,000 145,000 0
TOTAL EXPENSES 395,611 403,730 562,164 258,103 428,314 621,323 0
SERVICE INDICATORS:
Miles of Water Line 16 30 30 30 30
No. of Connections 1,120 1,590 1,590 1,590 1,590
No. of Hydrants 222 222 222 222 222
Avg Daily Consump- gals 430,000 430,000 430,000 430,000 430,000
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
CASH FLOW IMPACT:
Beginning Cash Balance 653,835 617,861 730,741 730,741 730,741 826,097 826,097
Revenues 310,686 417 ,300 426,200 163,165 378,670 462,625 0
Expenditures (395,611 ) (403,730) (562,164) (258,103) (428,314) (621,323 ) 0
Depreciation 151,615 172,032 145,000 118,888 145,000 145,000 0
Construction of Infrastructure (108,630)
Other Cash Flow Impacts 5,966 (72,722)
Ending Cash Balance 617,861 730,741 739,777 754,691 826,097 812,399 826,097
STAFFING:
Sr. Acctg. Clerk .10 .10 .10 .10 .10 .10 .10
Lt. Equip. Oper.lForeman .30 .30 .30 .30 .30 .30 .30
Secretary/Recept .10 .10 .10 .10 .10 .10 .10
Engineer. Tech. .25 .25
Engineer .15 .15
13
FUND: Water
MISSION:
To provide for the retirement of
debt incurred to construct water
system improvements.
SUB FUND: Water Debt Service
FUND NO: 601
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.
OBJECTIVES:
To assure adequate resources to retire debt as scheduled, or more quickly if prudent.
HIGHLIGHTS/COMMENTS:
Revenues:
Property Tax Levy for Debt Service
Special Assessments on Water Improvements
Connection Charges
Interest Income
Transfers from Water Operating Fund
Expenses:
Staffing:
Supplies/Materials:
Support Services:
Charges & Fees:
Capital Outlay:
Other:
Debt service payments - Principal and interest
14
FUND: #601 FUND: Water - Debt Service DEPT # 49400
BUDGET Actual Actual Budget YTD Sept Annual Proposed Adopted
ITEM 1999 2000 2001 2001 EST-01 2002 2002
REVENUE
Sp Assess/Connect Chgs 441 ,982 216,409 120,000 88,769 127,350 110,000 0
Misc. Revenue 51,848 10 0 0 0 0 0
Transfers 40,000 40,000 80,000 0 80,000 120,000 0
TOTAL REVENUE 533,830 256,420 200,000 88,769 207,350 230,000 0
EXPENSES
Staffing 0 0 0 0 0 0 0
Supplies/Materials 0 0 0 0 0 0 0
Support Services 0 0 0 0 0 0 0
Charges & Fees 0 0 0 0 0 0 0
Other - Debt Service 297,337 299,424 284,739 236,928 284,739 276,415 0
Capital Outlay 0 0 0 0 0 0 0
Transfers 0 0 0 0 0 0 0
TOTAL EXPENSES 297,337 299,424 284,739 236,928 284,739 276,415 0
SERVICE INDICATORS:
Outstanding Debt, Year End 2,290,000 2,100,000 1,915,000 1,915,000 1,915,000 1,730,000 1,730,000
CASH FLOW IMPACT:
Beginning Cash Balance 504,018 740,511 697,507 697,507 697,507 620,118 620,118
Revenues 533,830 256,420 200,000 88,769 207,350 230,000 0
Expenditures (297.337) (299,424 ) (284,739) (236.928) (284,739) (276,415) 0
Ending Cash Balance 740,511 697,507 612,768 549,348 620,118 573,703 620,118
STAFFING:
15
CITY OF SHOREWOOD,
MINNESOTA
2002 SANITARY SEWER BUDGET
November 1, 2001
17
FUND:
Sanitary Sewer
MISSION:
To provide a safe, sanitary sewer
service to all City residents
SUBFUND:
Sanitary Sewer
DEPT NO: 611
DESCRIPTION OF ACTIVITY:
Major activities include maintenance of fourteen (14) lift stations, and cleaning,
televising and repairing sewer mains to control inflow and infiltration. Sewage
treatment is performed by Metropolitan Council Environmental Services (MCES) and is
provided for in this area.
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
HIGHLIGHTS/COMMENTS:
Revenues:
Quarterly Sewer service charges at $60.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
Expenses:
Staffing:
.10 Senior Accounting Clerk .15 City Engineer
.20 Light Equipment Operat .25 Engineering Technician
.10 ReceptionisUSecretary
Supplies/Materials:
Office Supplies. including billing forms and postage
Maintenance contracts for computer hardware and software
Support Services:
Contract with Munitech for system m~intenance
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 Shady Island (2001 and 2002) and Birch Bluff (2001) Lift Stations
Transfers:
General Fund Overhead Costs
lnterfund Loan - Gideon Glen 2001
Depreciation (Non-Cash Expense accounts for future system replacement)
18
FUND: # 611 FUND: Sanitary Sewer DEPT # 49450
BUDGET Actual Actual Budget YTD Sept Annual Proposed Adopted
ITEM 1999 2000 2001 2001 EST-01 2002 2002
REVENUE
Charges for Service 804,469 860,283 732,200 341,700 700,860 706,680 0
Transfers 0 0 25,000 0 225,000 28,000 0
TOTAL REVENUES 804,469 860,283 757,200 341,700 925,860 734,680 0
EXPENSES
Staffing 14,076 18,973 22,064 11,754 22,064 41,373 0
Supplies/Materials 18,423 16,742 17 , 150 1,620 6,650 17,150 0
Support Services & Charges 386,869 368,506 490,850 282,107 4 7Q ,250 482,020 0
Capital Outlay 3,960 0 100,000 0 0 184,500 0
Transfers 6,000 651,875 10,000 0 10,000 15,000 0
Depreciation 197,794 198,974 200,000 133,880 200,000 200,000 0
TOTAL EXPENSES 627,122 1,255,070 840,064 429,362 717,964 940,043 0
SERVICE INDICATORS:
Miles of Sewer Line 57 57 65 65 65
No. of Connections 2,705 2,705 2,730 2,730 2,730
No. of Lift Stations 16 16 14 14 14
Sewer Charge 60.00 60.00 60.00 60.00 60.00
CASH FLOW IMPACT:
Beginning Cash Balance 1,577 ,441 2,050,624 1,758,652 1,758,652 1,758,652 1,941,548 1,941,548
Revenues 804,469 860,283 732,200 341,700 700,860 706,680 0
Expenditures (627,122) (1,255,070) (840,064) (429,362) (717,964) (940,043) 0
Depreciation 197,794 198,974 200,000 133,880 200,000 200,000 0
Other Cash Flow Impacts 98,042 (96,159)
Ending Cash Balance 2,050,624 1,758,652 1,850,788 1,804,869 1,941,548 1,908,185 1,941,548
STAFFING:
Sr. Acctg. Clerk .10 .10 .10 .10 .10 .10 .10
Lt. Equip. Oper.lForeman .20 .20 .20 .20 .20 .20 .20
Receptionist/Secretary .10 .10 .10 .10 .10 .10 .10
City Engineer .15 .15
Engineer. Technician .25 .25
19
CITY OF SHOREWOOD,
MINNESOTA
2002 RECYCLING &
STORMWATERMANAGEMENT
BUDGETS
November 1, 2001
21
SUBFUND:
Recycling
MISSION'
To provide weekly pickup of recyclables
to all City residents; provide for the annual
pickup of household and yard wastes
FUND:
Recycling
FUND NO: 621
DESCRIPTION OF ACTIVITY:
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.
OBJECTIVES: .
- 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
HIGHLIGHTS/COMMENTS:
Revenues:
County Aid is a Hennepin County grant
Charges for Service includes City Clean-up fees and a
City Recycling Fee of $1.50 per month per household
Tranfers/other includes transfers, interest income and revenue sharing from the Recycling Contractor
Expenses:
Staffing:
Miscellaneous staffing for City Clean-up and Yardwaste Disposal
Supplies/Materials:
Office Supplies
Support Services:
Recycling contract with E-Z Recycling - $2.05/household/month for 2,675 households
City Clean-up costs
22
FUND: #621 FUND: Recycling DEPT # 49550
BUDGET Actual Actual Budget YTD Sept Annual Proposed Adopted
ITEM 1999 2000 2001 2001 EST-01 2002 2002
REVENUE
County Aid 21,860 21,858 22,000 23,728 23,728 23,450 0
Charges for Service 67,703 76,864 71,950 49,100 71,881 . 72,950 0
Transfersfother 966 2,346 1,100 578 1,000 1,000 0
TOTAL REVENUE & 90,529 101,067 95,050 73,407 96,609 97,400 0
OTHER SOURCES
EXPENSES
Staffing 543 0 1,526 653 1,526 1,525 0
SuppliesfMaterials 143 1,840 200 626 626 500 0
Support Services & Charges 83,629 85,577 95,335 79,830 95,254 95,375 0
Capital Outlay 0 0 0 0 0 0 0
Transfers 0 0 0 0 0 0 0
TOTAL EXPENSES 84,315 87,417 97,061 81,108 97,406 97,400 0
SERVICE INDICATORS:
Avg. mo. Participant Hshlds. 1,300 1,300 1,100 1,100 1,100
Avg. mo. Tonnage 70 70 72 72 72
CASH FLOW IMPACT:
Beginning Cash Balance 17,503 26,317 35,975 35,975 35,975 35,178 35,178
Revenues 90,529 101,067 95,050 73,407 96,609 97,400 0
Expenditures (84,315) (87,417) (97,061) (81,108) (97,406) (97,400) 0
Other Cash Flow Impacts 2,600 (3,992)
Ending Cash Balance 26,317 35,975 33,964 28,273 35,178 35,178 35,178
STAFFING:
23
FUND:
Stormwater Management MISSION:
To provide proper surface water and
Stormwater Management ground water management throughout
the City.
SUBFUND:
FUND NO: 631
DESCRIPTION OF ACTIVITY:
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.
OBJECTIVES:
To build and maintain a stable fund balance in order to facilitate council priorities and projects.
HIGHLIGHTS/COMMENTS:
Revenues:
Stormwater Management Utility Charges
Misc. Revenue includes interest income and other misc. revenue (antenna)
Transfers from the General Fund
Expenses:
Staffing:
.10 Senior Accounting Clerk .10 City Administrator
.10 Light Equipment Operator .05 City Engineer
Supplies/Materials:
Drainage Correction/Maintenance Materials
Support Services:
Engineering
Contractual Services for drainage correction
Capital Outlay:
Gideon Glen Drainage Project
24
\ ~
FUND: #631 FUND: Stormwater Management Utility DEPT # 49600
BUDGET Actual Actual Budget YTD Sept Annual Proposed Adopted
ITEM 1999 2000 2001 2001 EST-01 2002 2002
REVENUE
Charges for Service 44,938 52,134 45,000 20,022 45,000 50,000 0
Misc. Revenue 6,331 17,711 206,500 199,213 200,050 2,000 0
Transfers 10,000 10,000 10,000 0 10,000 35,000 0
TOTAL REVENUE & 61,269 79,845 261,500 219,235 255,050 87,000 0
OTHER SOURCES
EXPENSES
Staffing 1,519 2,340 9,252 1,848 9,252 23,455 0
Supplies/Materials 1,370 642 4,000 292 2,000 1,795 0
Support Services 10,852 7,699 12,150 23,641 27,750 18,750 0
Charges & Fees 0 0 0 0 0 0 0
Capital Outlay 25,801 0 14,500 2,700 50,000 15,000 0
Transfers 0 0 225,000 0 225,000 28,000 0
TOTAL EXPENSES 39,542 10,682 264,902 28,481 314,002 87,000 0
SERVICE INDICATORS:
CASH FLOW IMPACT:
Beginning Cash Balance 199,404 228,296 118,043 118,043 118,043 59,091 59,091
Revenues 61,269 79,845 261,500 219,235 255,050 87,000 0
Expenditures (39,542) (10,682) (264,902) (28,481 ) (314,002) (87,000) 0
Other Cash Flow Impacts 7,165 (179,416) 0
Ending Cash Balance 228,296 118,043 114,641 308,797 59,091 59,091 59,091
STAFFING:
City Administrator
Engineer
Sr. Acctg. Clerk
Lt. Equip. Oper./Foreman
.05
.10
.10
.10
.10
.10
.10
.10
.10
.10
.10
.05
.10
.10
.10
.05
.10
.10
25