102504 CC WS AgP
-r.. ..
,
.-..
CITY OF SHOREWOOD
CITY COUNCIL WORK SESSION
MONDAY, OCTOBER 25,2004
5755 COUNTRY CLUB ROAD
COUNCIL CHAMBERS
IMMEDIATELY FOLLOWING
REGULAR MEETING
AGENDA
1. CONVENE CITY COUNCIL WORK SESSION
A. Roll Call
Mayor Love_
Garfunkel
Lizee
Zerby _
Turgeon _
B. Review Agenda
2. ENTERPRISE BUDGETS (Att. - Finance Director's memorandum)
A. Water Budget
B. Sanitary Sewer Budget
C. Stormwater Management Budget
D. Recycling Budget
E. Liquor Operations Budget
3. OTHER
4. ADJOURN
No action will be taken during this meeting.
\
/
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:
October 18, 2004
FROM:
Honorable Mayor and City Councilmembers ~
Bonnie Burton, Finance Directorffreasurer ~
TO:
RE:
Enterprise .Fund Budget Workshop:
Work-session, Monday October 25, 2004
CC:
Craig W. Dawson, City Administrator
Attached for .your review are Year 2005 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 Water Operations and Water Debt Service, Sanitary Sewer Fund, Stormwater
Management, and Recycling Funds, and Liquor Operations
Water Budget I
The Water Fund budget is comprised of two parts: the Water Debt SerVice budget and the Water
Operating budget. The 2005 Water Debt Service budget includes payments for the existing bond
issues and the anticipated 2005 issue which will finance major water and well improvements in
2005. These debt service payments are programmed at approximately $356,000 and will be paid
for by a transfer from the Water Operating budget.
The 2005 Water Operating budget revenues are projected at $1.738 million while expenses
(including depreciation) are forecast at about $1.8 million. Proposed capital expenditures to be
funded from 2005 bond proceeds include: Amesbury Well enhancements; Badger Well House
reconstruction; Woodhaven Interconnection; Radio Read project; SE Water Tower Painting.
In order for the Water Funds to be self-supporting, to assure the system can provide for
improvements, and to preserve fund balance at current levels, a three-year step approach to water
rate increases was discussed and approved by the Council several years ago.
{) PRINTED ON RECYCLED PAPER
1
#J-
'"
2005 Enterprise Budget Memo
Page 2 of 3
Based on that plan, the final scheduled increase would change the base rate in 2005 from $30 to
$35 for up to 10,000 gallons; and remain at $2.95/1000 gallons for 10,000-50,000 gallons usage;
and $3.75/1000 gallons for 50,000 + gallons usage. There are currently approximately 1,225
water connections that use an average of 30,000 gallons per quarter. The proposed 2005 increase
would generate and additional $25,000 in annual revenue and the average quarterly bill (30,000
gallons) would increase from about $89 per quarter to $94 per quarter.
Sanitary Sewer Budget
The City currently has about 2,800 connections to its Sanitary Sewer System. The Sanitary
Sewer Fund has a substantial fund balance that has enabled it to be used to fund projects such as
the Gideon Glen land acquisition. This loan is being repaid on schedule from the Stormwater
Management Fund. Staff is not recommending any additional rate increases at this time.
Proposed operating revenues and expenditures for year 2005 are contemplated at approximately
$873,500. In addition, capital improvements of approximately $247,000 are planned. Capital
improvements for year 2005 include refurbishment of Lift Stations 15 and 17, and the purchase
of a sewer camera, Trailer Jetter, and portable generator. In addition, funds have also been
designated for Inflow & Infiltration Control and Reduction projects ($25,000).
Storm water Management Budget
The 2005 Stormwater Management Budget draft contemplates revenues and expenditures of
about $379,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 by the MCWD; Boulder Bridge Storm Lift station
improvements ($88,000) 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. Staffis not recommending any additional rate increases at this time. .
Recycling Budget
The Recycling Budget draft contemplates revenues and expenditures of about $117,220. The
City anticipates again receiving approximately $21,640 from Hennepin County Grant Funds.
We note that the number of households participating in the recycling program remains stable at
about 1,100 households per month. Staff does not recommend any additional rate increases at
this time.
Liquor Operations
The City optimistically anticipates reasonable profit levels at its two current operating municipal
stores. However, the 2005 budget has been prepared very conservatively, because of potential
competition that is under development in the Tonka Bay shopping center as of this writing.
Waterford (Store No. I)
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 2005.
2
2005 Enterprise Budget Memo
Page 3 of3
Shorewood Plaza (Store No.2)
Lastly, during the coming year, the Shorewood Plaza location has been positively impacted by its
relocation within the mall and the completion of the Cub store. The 2005 budget for this store
reflects continued profitability.
The Liquor Committee will review the Liquor Operations budgets at its October 25 meeting and
it is expected that the committee will recommend approval of the budgets by the City Council.
Conclusion
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.
3
FUND: Water
MISSION:
To provide for the retirement of
debt incurred to construct water
system improvements.
SUBFUND: 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:
SupplieslMaterials:
Support Services:
Charges & Fees:
Capital Outlay:
Other:
Debt service payments - Principal and interest
Fiscal Agent Fees
8
FUND: #601 FUND: Water - Debt Service DEPT # 49400
BUDGET Actual Actual Actual Budget YTD Sept Proposed Adopted
ITEM 2001 2002 2003 2004 2004 2005 2005
REVENUE
Sp Assess/Connect Chgs 115,198 16,904 41,360 55,000 48.321 45.000 0
Misc. Revenue 18 0 22.206 35,000 32,698 35,000 0
Transfers 85,000 110,000 150,000 230,000 0 280,000 0
TOTAL REVENUE 200,216 126,904 213,566 320,000 81,019 360,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 325,985 275,258 101,438 264,090 264,090 355,904 0
Capital Outlay 0 0 0 0 0 0 0
Transfers 0 0 0 0 0 0 0
TOTAL EXPENSES 325,985 275,258 101,438 264,090 264,090 355,904 0
SERVICE INDICATORS:
Outstanding Debt, Year End 2,100,000 1,915,000 1,730,000 1,545,000 1.545,000 2,610,000
CASH FLOW IMPACT:
Beginning Cash Balance
740,511 614,742 466.388 578.516 578,516 395,445 399,541
Revenues
200,216 126,904 213,566 320.000 81,019 360,000 0
Expenditures
(325.985) (275,258) (101,438) (264,090) (264,090) (355,904) 0
Ending Cash Balance
614,742 466,388 578,516 634,426 395.445 399,541 399,541
STAFFING:
9
SUBFUND:
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
HIGHLIGHTS/COMMENTS:
Revenues:
Estimated water sales based on quarterly billing at a tiered rate of $2.95 - $3.75/1,000 gallons
Connection and permit revenues
Miscellaneous Income includes interest income and Cellular Antenna Space Rentals
Anticipate issuing Water Revenue Bonds for approximately $ 1,200,000 (2005)
Expenses:
Staffing:
.1 0 Senior Accounting Clerk
.125 Receptionist/Secretary
.25 Utility Lead Person
1.15 Utility Operator
.10 Director of Public Works
.25 Engineer. Technician
.125 Junior 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
Support Services & Charges:
Engineering
Water Operations Ucenses & Training
Insurance on water system
Water testing & Water Quality Reporting
Water system analysis
Capital Outlay:
Amesbury Polyphosphate System ($12,100 - 2005)
Amesbury Building Repair ($55,000 - 2005)
Amesbury Well Repair ($96,000 - 2005)
Woodhaven Well Inter-Connection ($174,500 - 2005)
Badger Well House Reconstruction ($480,000 - 2005)
Radio Read Meter project-($21 0,000 - 2005)
SE Area Water Tower Painting ($50,000 - 2005)
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 Actual Budget YTD Sept Proposed Adopted
ITEM 2001 2002 2003 2004 2004 2005 2005
REVENUE
Charges for Service 334,830 272,465 447,867 453,200 206,938 467,200 0
Bond Proceeds 0 0 0 0 0 1 ,200,000 0
Mise. Revenue 72,n8 104,106 71 ,193 71,000 52,543 71,000 0
TOTAL REVENUE 407,608 376,571 519.061 524,200 259,481 1 ,738,200 0
EXPENSES
Staffing 17,829 48,431 70,964 99,654 46,897 98,699 0
Supplies/Materials 52,542 47,565 47,591 49,250 74,162 51.825 0
Support Services & Charges 137,711 140,580 74,132 n,900 90,906 103,900 0
Capital Outlay 935 0 0 800,000 0 1,On,600 0
Transfers 85,000 110,000 110,000 230,000 0 280,000 0
Depreciation 178,328 180,805 181,113 182,000 134,818 190,000 0
TOTAL EXPENSES 472,345 527,381 483,800 1 ,438,804 346,784 1,802,024 0
SERVICE INDICATORS:
Miles of Water Line 16 16 16 16 16 16
No. of Connections 1,120 1,120 1,120 1.120 1.172 1,225
No. of Hydrants 222 222 222 222 222 222
Avg Dally Consump- gals 430,000 430,000 430,000 430.000 430,000 430,000
Water ratel1000 gals 1.50/1.76 1.50/1.76 1.95/2.75 2.95/3.75 2.95/3.75 2.95/3.75
CASH FLOW IMPACT:
Beginning Cash Balance 617,861 658,730 767,463 1,088,253 1,088,253 355.649
Revenues 407.608 376,571 519,061 524,200 259,481 1,738,200
Expenditures (472,345) (527,381) (483,800) (1,438,804) (346,784) (1,802,024)
Depreciation 178,328 180,805 181,113 182,000 134,818 190,000
Construction of Infrastructure
Other Cash Flow Impacts (72,722) 78,738 1 04,417 0 0 1,200,000
Ending Cash Balance 658,730 767,463 1,088.253 355,649 1,135,769 1,681,825
STAFFING:
Dir of PW .15 .15 .15 .10
Utility Lead Person .25
Lt. Equip. Oper. .30 .30 .30 .30 .30 1.10
Engineer. Tech. .25 .25 .25 .25
Sr. Acctg. Clerk .10 .10 .10 .10 .10 .10
Jr. Acctg. Clerk .125
Sec./Recep. .10 .10 .10 .10 .10 .125
13
Capital Improvement Program
City of Shorewood, Minnesota
PROJECTS BY DEPARTMENT
2005
thru
2009
Department P , ~# . Priority 2005 2006 2007 2008 2009
rOJect ~ Total
MUl1icipal Water System
Amesbury BuDding Repair W.Q3-02 0 55,000 55,000
BadgerWeU House Reconstrucllon W.os-03 0 480,000 480,000
Woodhaven WeR Interconnect W-OS-OS 0 174,500 174,500
Water Meter Radio Read ProIect W.Q3.Q6 0 70,000 70,000 140,000
Amesbury Submersible WeD - pun &. Inspect W.()4.()1 0 21,000 21,000
SE Area Water Tower - paInting W-Q4.06. O. 50,000 50,000
Amesbury Polyphosphete System W-04-08 0 12,100 12,100
Amesbury WeR Controls ReplacelJlent W.Q5.o2 0 75,000 75,000
. Boulder Bridge Submersible Wen - PuR &. Inspect W:005-03 ~. 0 21,000 21,000
S.E. Area Uneshaft WeD- pun &. Inspect W.oe-01 0 22,000 . 22,000
InterconnecUon of Amesbury &. SE Area Wells W.o7.o1 0 ., 626,400 626,400
; . Amesbury Uneshaft WeD ..Pull &. Inspect J
W.oNI2 0 22,000 !. 22,000
Boulder Bridge Weill:! - Pull & Inspect W.Q9-01 0 21,045 21,045
BadgerFlsId Uneshaft Well- pull & Inspect W-09-02 0 23,500 23,500
Municipal Water System Total 937,600 91,000 648,400 22,000 44,545 1,743.545
GRAND TOTAL 937.600 91,000 648,400 22,000 44,545 1,743.545
. ~.
. I
Wl!dlll!sda)', A1l8'~f/ 25, 2004
15
Preliminary
$1,245,000.00
City of Shorewood, Minnesota
General Obligation Water Revenue Bonds of2004\ (15 Year Scenario).
Sources & Uses
Dated 01/01/20051 Delivered 01/01/2005
SOURCES OF FUNDS
Par Amount of Bonds
$1,245,000,00
$1 ,245,000.00
TOTAL SOURCES
USES OF FUNDS
Deposit to Project Construction Fund
Costs of Issuance
Total Underwriter's Discount (1.400%)
Rounding Amount
1,200,500.00
26,100.00
17,430.00
970.00
TOTAL USES
$1,245,000,00
2004WalerRevenue Bonds 1101512004 11:45 PM
Page 1
16
Preliminary
$1,245,000.00
City of Shorewood, Minnesota
General Obligation Water Revenue Bonds of 2004 I (15 Year Scenario)
Debt Service Schedule
Date Principal Coupon Interest Total P+I Fiscal Total
01/0112005
07/01/2005 22,428.75 22,428.75
01101/2006 65,000.00 1.950% 22,428.75 87,428.75 109,857.50
07101/2006 21,795.00 21,795.00
01/01/2007 70,000.00 2.250% 21,795.00 91,795.00 113,590.00
07101/2007 21.007.50 21,007.50
01/01/2008 70,000.00 2.550% 21,007.50 . 91,007.50 112,015.00
07/01/2008 20,115.00 20,115.00
01/01/2009 70,000.00 2.850% 20,115.00 90,115.00 110,230.00
07/0112009 19,117.50 19,117.50
01101/2010 75,000.00 3.100% 19,117;50 94,117.50 113,235.00
07/01/2010 17,955.00 17.955.00
01101/2011 75,000.00 3.300% 17,955.00 92,955.00 110,910.00
07/01/2011 16,717.50 16,717.50
01/01/2012 80,000.00 3.500% 16,717.50 96,717.50 113,435.00
07/0112012 15,317.50 15,317.50
0110112013 80,000.00 3.700% 15,317.50 95,317.50 110,635.00
07/0112013 13,837.50 13,837.50
0110112014 85,000.00 3.850% 13,837.50 98,837.50 112,675.00
07/01/2014 12,201.25 12,201.25
01/01/2015 85,000.00 4.000% 12,201.25 97,201.25 109,402.50
07/01/2015 10,501.25 10,501.25
01/01/2016 90,000.00 4.100% 10.501.25 100,501.25 111,002.50
07/0112016 8,656.25 8,656.25
011Ot12017 95,000.00 4.200% 8,656.25 103,856.25 112,312.50
07/0112017 6,661.25 6,661.25
01/01/2018 100,000.00 4.300% 6,661.25 106,661.25 113,322.50
07/01/2018 4,511.25 4,511.25
01/0112019 100,000.00 4.350% 4,511.25 104,511.25 109,022.50
07/01/2019 2,336.25 2,336.25
01/01/2020 105,000.00 4.450% 2,336.25 107.336.25 109,672.50
Total $1,245,000.00 $426.317.50 $1,671,317.50
Dated 1101/2005
Delivery Date 1/0112005
First Coupon Date 7/0112005
First available call date
Call Price
Bond Year Dollars $10,740.00
Average Ufe 8.627 Vears
Average Coupon 3.9694367%
Net Interest Cost (NIC) 4.1317272%
True Interest Cost mC) 4.1364769%
AD Inclusive Cost (A1C) 4.4445090%
IRS Fonn 8038
Net Interest Cost in Oollan; 428,317.50
Weighted Average Maturity 8.627 Vears
Bond YIeld for Arbitrage Purposes 3.9359417%
2004 Water Reyenue Bonds I 101512004 I 1 :45 PM
Public Finance
Page 2.
17
SUBFUND:
DEPT NO:
Sanitary Sewer
611
. MISSION:
To provide a safe, sanitary sewer
service to all City residents
FUND:
Sanitary Sewer
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 $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
.125 Receptionist/Secretary
.25 Utility Lead Person
1.15 Utility Operator
.10 Director of Public Works
.25 Engineer. Technician
.125 Junior Accounting Clerk
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 & 17 (2005)
Equipment Capital Outlay (2005)- Sewer Camera $5,100; TrailerJetter $70,000; portable Generator $68,800
Inflow & Infiltration Reduction
Transfers:
Debt Service Payment From Interfund Loan to Stormwater Fund- Gideon Glen 2000
Depreciation (Non-cash expense accounts for future system replacement)
20
FUND: # 611 FUND: Sanitary Sewer DEPT # 49450
BUDGET Actual Actual Actual Budget YTD Sept Proposed Adopted
ITEM 2001 2002 2003 2004 2004 2005 2005
REVENUE
Charges for Service 788,944 809,913 891,804 840,500 480,528 840,500 0
Transfers 0 0 0 37,397 0 33,000 0
TOTAL REVENUES 788,944 809,913 891,804 8n,897 480,528 873,500 0
EXPENSES
Staffing 18,795 32,068 52,467 104,154 35,847 103,199 0
Supplies/Materials 10,013 21,334 11,914 22,750 4,694 16,750 0
Support Services & Charges 445,493 413,547 488,462 510,758 325,622 473,310 0
Capital Outlay 0 0 0 121,500 2,190 246,900 0
Transfers 10,000 15,000 0 0 0 0 0
Depreciation 200,821 202,291 203,538 205,000 153,075 205,000 0
TOTAL EXPENSES 685,122 684,239 756,381 964,162 521,428 1,045,159 0
SERVICE INDICATORS:
Miles of Sewer Line 57 57 57 57 65 65 65
No. of Connections 2,705 2,705 2,705 2,n3 2,n3 2,n3 2,n3
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
CASH FLOW IMPACT:
Beginning Cash Balance 2,050,624 2,259,108 2,549,785 3,358,079 3,358,079 3,470,254 3,470,254
Revenues 788,944 809,913 891,804 840,500 480,528 840,500 0
Expenditures (685,122) (684,239) (756,381) (964,162) (521,428) (1,045,159) 0
Depreciation 200,821 202,291 203,538 205,000 153,075 205,OOQ 0
Other Cash Flow Impacts (96,159) (37,288) 469,334
Ending Cash Balance 2,259,108 2,549,785 3,358,079 3,439,417 3,470,254 3,470,595 3,470,254
STAFFING: 534,n4
Sr. Acctg. Clerk .10 .10 .10 .10 .10 .10
Acctg. Clerk .20 .20 .125
Utility Operator/Utility Lead .20 .20 .20 1.10 1.10 1.40
Receptionist/Secretary .10 .10 .10 .05 .05 .125
Director of Public Works .125 .125 .10
Engineer. Technician .25 .25 .25
21
Capital Improvement Program
City of Shorewood, Minnesota
PROfficrS BYDEPART:MBNT
2005 thrn 2009
Department pro}ect#: Priority 2005 2006 2007 . 2008 2009 Total
Sanitary Sewer
Inliltration and Inflow Reduction SS.Q3.Q5 0 25,000 25,000 .25,000 25,000 25,000 125,000
Uft Station 15 RehablUtation S8-0S.Q6 0 81,000 81,000
LIft Station 17 RehabIDtatIon. SS-04-01 0 22,000 81,000 103.000
. porlable Generator for lift StaUons SS-OS-01 0 68,800 68,800
Uft Station 16 Rehabnttatlon SS.Q5-02 0 25,000 79,000 104.000
un Station 12 Rehabilitation SS.Q7.01 0 1~,ooo 91,000 110.000
Sanitary Sewer Total 196.800 131,000 123,000 116,000 25,000 591,800
GRAND TOTAL ,...; 196,800 131,000 123,000 116.000 . 25,000 591,800
!f~.
Wedlle.~da)'. A1I811.ft 2$. 2004
23
SUBFUND:
Stormwater Management
MISSION:
To provide proper surface water and
ground water management throughout
the City.
FUND:
Stormwater Management
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:
.1 0 Light Equipment Operator
.05 Senior Accounting Clerk
.10 Junior Accounting Clerk
Supplies/Materials:
Drainage Correction/Maintenance Materials
Support Services:
Engineering
Contractual Services for drainage correction
Debt Service:
Repayment of Internal Loan to Sewer Fund for land purchase (Balance outstanding at end of 2004: $120,000)
Capital Outlay:
Glen Road Drainage Improvement ($25,000 . 2005)
Gideon Glen Drainage Project ($183.300 - To be funded by MCWD in 2005)
Boulder Bridge Storm Lift Station ($88,000 - To be funded with special assessments in 2005)
26
FUND: #631 FUND: Stormwater Management Utility DEPT # 49600
BUDGET Actual Actual Actuai Budget YTD Sept Proposed Adopted
ITEM 2001 2002 2003 2004 2004 2005 2005
REVENUE
Special Assessments 0 0 0 82,800 0 88,000 0
Charges for Service 48,425 43,985 57,201 59,500 30,664 60,000 0
Misc. Revenue 205,092 62,580 23,911 269,100 26,256 294,300 0
Transfers 10,000 35,000 30,000 25,000 0 25,000 0
TOTAL REVENUE & 263,516 141,565 111,111 353,600 56,920 379,300 0
OTHER SOURCES
EXPENSES
Staffing 2,473 2,299 2,493 11,979 3,820 12,482 0
Supplies/Materials 600 3,376 1,074 2,300 2,021 2,300 0
Support Services 44,399 12,486 51,579 18,200 19,570 32,300, 0
Charges & Fees 0 0 0 0 0 0 0
Other - Debt Service 206,767 9,863 8,877 37,397 0 35,918 0
Capital Outlay 0 0 0 291,000 0 296,300 0
Transfers 0 0 0 0 0 0 0
TOTAL EXPENSES 254,240 28,023 64,024 360,876 25,411 379,300 0
SERVICE INDICATORS:
CASH FLOW IMPACT:
Beginning Cash Balance 228,296 58,157 179,483 171,018 171,018 163,742 163,742
Revenues 263,516 141,565 111,111 353,600 56,920 379,300 0
Expenditures (254,240) (28,023) (64,024) (360,876) (25,411) (379,300) 0
Other Cash Flow Impacts (179,416) 7,785 (55,553) 0 0 0 0
Ending Cash Balance 58,157 179,483 171,018 163,742 202,527 163,742 163,742
STAFFING:
City Administrator .10 .10 .10 .10 .10
Engineer .05 .05 .05 .05 .05
Lt. Equip. Oper JForeman .10 .10 .10 .10 .10 .10 .10
Sr. Acctg. Clerk .10 .10 .05 .05 .05 .05 .05
Acctg. Clerk .10 .10 .10 .10 .10
27
Capit~ Improvement Program
City of Shotewood, Minnesota
PROJECTS BY DEP ARTlY.ffiNT
2005
thru
2009
.Department . !'( Priority 200S 2006 2007 _ 2008
ProJect# 2009 Total
Stormwater M~nagement
Gideon Glen Improvements STM-04-01 0 183,300 183,800
Glen Road Dralnage., STM-04-02 0 25,000 25,000
Boulder Bridge l1ft Station Sl'M-04-04 ,0 88,000 88,000
Mtsc Stannwater Pro)ecls STM-04-OS 0 30,000 80,000 80,000 80,000 120,000
Stormwater Management Total 296,300 30,000 30,000 30,000 ~,ooo 416,300
. GRAND TOTAL 296,300 30,000 30,000 30,000 30,000 416,300
,
~
.'
Wf!dne.~da,\'. Allg/1St 1S, 2004
29
.
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
FUNDNO: 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 brushlleaf 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.75 per month per household
Tranfers/other includes transfers, interest income and revenue sharing from the Recycling Contractor
Expenses:
Staffing:
Miscellaneous staffing for City Clean-up and Yardwaste Disposal
Supplies/Materials:
Office Supplies
Support Services:
Recycling contract with E-Z Recycling - $2.35/household/month for 2,720 households
City Clean-up costs
32
'*
~
FUND: #621 FUND: Recycling DEPT # 49550
BUDGET Actual Actual Actual Budget YTD Sept Proposed Adopted
ITEM 2001 2002 2003 2004 2004 2005 2005
REVENUE
County Aid 23,728 23,690 21 ,460 21,460 21,160 21,500 0
Charges for Service 77,992 81,860 98,064 94,020 57,841 94,020 0
Transfers/other 1,625 2,831 1,138 2,000 1,023 1,700 0
TOTAL REVENUE & 103,345 108,382 120,662 117,480 80,025 117,220 0
OTHER SOURCES
EXPENSES
Staffing 653 498 590 2,920 0 1,801 0
Supplies/Materials 983 1,694 990 1,300 0 1,000 0
Support Services & Charges 102,516 102,516 114,980 113,260 87,510 114,419 0
Capital Outlay 0 0 0 0 0 0 0
Transfers 0 0 0 0 0 0 0
TOTAL EXPENSES 104,151 104,709 116,560 117,480 87,510 117,220 0
SERVICE INDICATORS:
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
CASH FLOW IMPACT:
Beginning Cash Balance 26,317 21,519 37,785 41,886 41,886 34,400 34,400
Revenues 103,345 108,382 120,662 117,480 80,025 117,220 0
Expenditures (104,151) (104,709) (116,560) (117,480) (87,510) (117,220) 0
Other Cash Flow Impacts (3,992) 2,616
Ending Cash Balance 21,519 37,785 41,886 41,886 34,400 34,400 34,400
STAFFING:
.05 Receptionist/Secretary
33
,)
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
HIGHLIGHTS/COMMENTS:
Revenues:
Estimated liquor sales for two stores.
Expenses:
Staffing:
1.00 Operations Manager
1.00 Assistant Managers
2.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 Tonka 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
36
, "
'.
. FUND:;~ 640 SUBFUND: Liquor Operations (Shorewood Village & Waterford) DEPT #
BUDGET Actual Actual Budget YTD Sept Proposed Adopted
ITEM 2002 2003 2004 2004 2005 2005
REVENUE
Sales 2,622,145 2,507,063 2,224.045 1,624,743 2,283,500 0
Cost of Goods 1,962,099 1,829,854 1,645,909 1,168,415 1,678.740 0
GROSS PROFIT 660,046 677,209 578,136 456,327 604,760 0
EXPENSES
Staffing 290,934 302,702 272,477 190,570 281,267 0
Supplies/Materials 12,912 11,325 8.000 7,340 7,150 0
Services & Charges 258,685 232,728 196,830 165,707 222,820 0
Depreciation 9.662 10,085 14,800 29,293 36,960 0
Capital Outlay 0 40,000 20,000 465 21,500 0
TOTAL EXPENSES 572,193 596,840 512,107 393,376 569,697 0
TOTAL OPERATING INCOME (LOSS) 87,853 80,369 66,029 62,952 35,063 0
Other Sources 4,502 10.680 30,000 3,122 20,000 0
Other Uses 10,000 30,000 0 668 50,000 0
NET INCOME (LOSS) 82,355 61,048 96,029 65,406 5.063 0
SERVICE INDICATORS:
Gross Profit as a % of Sales 25.17% 27.01% 25.99% 28.09% 26.48%
Oper. Income as a % of Sales 3.35% 3.21% 2.97% 3.87% 1.54%
CASH FLOW IMPACT:
Beginning Cash Balance
Net Operating Income/Loss
Depreciation
Other Cash Flow Impacts
Ending Cash Balance
STAFFING:
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
Full Time Clerk 1.00 1.00 1.00 1.00
Sr. Acctg. Clerk .15 .15 .15 .1 !) .15 .15
Part time:
Sales Clerks 15.00 15.00 15.00 15.00 10.00 10.00
37
,
FUND NO:
Liquor MISSION:
To control the sale and distribution of
Shorewood Plaza packaged alcholic beverages within the
City and to provide property tax relief
641 the use of operation profits.
FUND:
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
- Provide a profit equal to at least 2% of sales for transfer to the General Fund
HIGHLIGHTS/COMMENTS:
Revenues:
Estimated liquor sales
Expenses:
Staffing:
.50 Operations Manager
2.00 Full Time Clerk II
6.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
Advertising
Credit Card Service Charges
Capital Outlay:
Computer inventory & accounting software systems (2005)
Misc. Revenue/Expenditures:
Interest Income & Service Charges
38
.5' ,
t
FUND: # 641 SUBFUND: Liquor - Shorewood Plaza DEPT #
BUDGET Actual Actual Budget YTD Sept Proposed Adopted
ITEM 2002 2003 2004 2004 2005 2005
REVENUE
Sales 986,844 931,324 1,367,445 986,022 1,370,000 0
Cost of Goods 714,346 687,760 1,011,909 702,530 1,006,950 0
GROSS PROFIT 272,499 243,564 355,536 283,492 363,050 0
EXPENSES
Staffing 104,673 120,185 159,510 108,060 162,205 0
Supplies/Materials 4,967 5,178 4,000 4,031 3,825 0
Services & Charges 86,660 98.734 103.565 89,382 120,81Q 0
Depreciation 3,188 9,777 10,000 25,429 33,573 0
Capital Outlay 0 0 20,000 16,825 11 ,500 0
TOTAL EXPENSES 199,487 233,874 297.075 243.726 331,913 0
NET OPERATING INCOME (LOSS) 73,011 9,690 58,461 39,766 31,137 0
Other Sources 11,740 15.000 25,000 3,122 15,000 0
Other Uses 15,000 0 0 0 40,000 0
NET INCOME (LOSS) 69,752 24,690 83,461 42,888 6,137 0
BUSINESS INDICATORS:
Gross Profit as a % of Sales 27.61 % 26.15% 26.00% 28.75% 26.50% #DIV/Ol
Oper. Income as a % of Sales 7.40% 1.04% 4.28% 4.03% 2.27% #DIV/O!
CASH FLOW IMPACT:
Beginning Cash Balance 287,570 294,255 318,222 294,255 318,222 318,222
Net Operating Income/(Loss) 73,011 9.690 58,461 39,766 31,137 0
Depreciation 3,188 9,777 10,000 25,429 33,573 0
Other Cash Flow Impacts (69,514) 4,500 4,500 4,500 (5,000) (5,000)
Ending Cash Balance 294,255 318,222 391,183 363.950 377,932 313,222
STAFFING:
Full time:
Operations Manager .33 .33 .33 .33 .50 .50
Assistant Manager 1.00 1.00 1.00 1.00 .00 1.00
Full Time Clerk II 2.00 1.00
Sr. Acctg. Clerk .05 .05 .05 .05 .05 .05
Part time:
Sales Clerks 5.00 5.00 5.00 5.00 5.00 5.00
39
" iI. ,'.
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
HIGHLIGHTS/COMMENTS:
Revenues:
Estimated liquor sales
Expenses:
Staffing:
.50 Operations Manager
1 .00 Assistant Manager
4.00 Part time Sales Clerks
.05 Senior Accounting Clerk
SupplieslMaterials:
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: Remodel
Misc. Revenue/Expenditures:
Interest Income & Service Charges
40
(I ... ...
~ FUND: # 642 SUBFUND: Liquor - Waterford DEPT #
BUDGET Actual Actual Budget YTD Sept Proposed Adopted
ITEM 2002 2003 2004 2004 2005 2005
REVENUE
Sales 792,260 841,374 856,600 638,721 913,500 0
Cost of Goods 575,759 615,141 634,000 465,886 671,790 0
GROSS PROFIT 216,501 226,233 222,600 172,835 241,710 0
EXPENSES
Staffing 97,522 113,378 112,967 82,510 119,062 0
SupplieslMaterials 4,746 2,959 4,000 3,310 3,325 0
Support Services 97,251 93,491 93,265 76,326 102,010 0
Depreciation 4,854 5,083 4,800 3,864 3,387 0
Capital Outlay 0 0 0 0 10,000 0
TOTAL EXPENSES 204,373 214,911 215,032 166,009 237,784 0
TOTAL OPERATING INCOME (LOSS) 12,128 11 ,323 7,568 6,826 3,926 0
Other Sources 0 15,000 5,000 0 5,000 0
Other Uses 6,453 0 0 668 10,000 0
NET INCOME (LOSS) 5,675 26,323 12,568 6,158 (1,074) 0
BUSINESS INDICATORS:
Gross Profit as a % of Sales 27.33% 26.89% 25.99% 27.06% 26.46% #DIV/Ol
Oper. Income as a % of Sales 1.53% 1.35% 0.88% 1.07% 0.43% #DIV/O!
CASH FLOW IMPACT:
Beginning Cash Balance (159,160) (184,371 ) (164,966) (184,371 ) (164,966) (164,966)
Net Operating Income/(Loss) 12,128 11,323 7,568 6,826 3,926 '0
Depreciation 4,854 5,083 4,800 3,864 3,387 0
Other Cash Flow Impacts (42,193) 3,000 3,000 3,000
Ending Cash Balance (184,371 ) (164,966) (149,598) (170,682) (157,653) (164,966)
STAFFING:
Full time:
Operations Manager .33 .33 .33 .33 .50 .50
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
Part time:
Sales Clerks 5.00 5.00 5.00 5.00 5.00 5.00
41