The URL can be used to link to this page

2002 - 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.cLshorewood.mn.us. cityhall@cLshorewood.mn.us CITY OF SHOREWOOD, MINNESOTA 2002 ANNUAL OPERATING BUDGET ADOPTED DECEMBER 10,2001 #.' ~~ 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 2002 ANNUAL OPERATING BUDGET TABLE OF CONTENTS P AGE NO. INTRODUCTION Budget Message......................................... ....................................... ................... 1-4 SUMMARY INFORMATION Budget Schedule............................................ .... ................................... ...................5 Organization Chart.. ........ ..... ............. ...... ..... ...... ....................... ................... ............7 Newsletter Insert: December 2001 Shore Report ................................................8-9 GENERAL FUND General Fund Description............................................... .......... ............................ .11 General Fund Summary ................. ....... ...... ....... ................................... ........... 12-13 General Fund Revenue Summary ...... .......... ..... ................. .................... .......... 14-15 General Fund Expenditure Summary............................................................... 16-17 Mayor and Council.................................................... ................... ................... 18-19 Administration............................. ..................... ...................... ......................... 20-21 General Government................................... ............................................ ......... 22-23 Finance....................... ... ................................ ...................... ............................. 24-25 Professional Services ............................... ...... ....... ....... .................................... 26-27 Planning and Zoning............................... ................... ................... ................... 28-29 Municipal Building - City Hall........................................................................ 30-31 Police................................................................................................................ 32-33 Fire Protection.................................................... .............................................. 34-35 Protective Inspection. ............................................... ........... ....................... ...... 36-37 Animal Control.. ...... ............. ............................................. ............. ................. 38-39 City Engineer ..... ........................ ............................................... ....................... 40-41 Public Works Service.............. ..................................................... ..... ............... 42-43 Streets and Roadways ................ ................................. ........................ ............. 44-45 Snow and Ice Removal...... ................................... .................... ....... ................ 46-47 Traffic Control/Street Lighting.. ........... ............... ....... ....... ................ ......... ..... 48-49 SanitationlWaste Removal/W eeds............................................... .................... 50-51 Tree Maintenance............................... ........... ..................... ............ .................. 52-53 Parks and Recreation. ...................................................... ............ ......... .............54-55 DEBT SERVICE Debt Service Fund Description............... ........... ................................................ ....57 Debt Information................................ ........... ...................... ..... ...... .................. 58-59 CAPITAL PROJECTS Capital Proj ects Funds Description...... ................. .............. ....... .......................... ..61 Category Summary By Department.......... ......................... ......... ........................ ...63 Projects By Department............. ..................................... ................................. 64-65 Projects By Department and Category.... ........... .............................................. 66-67 Projects By Year ....... ............................................... ................................. ....... 68-69 TABLE OF CONTENTS (Continued) I I I I I I I I I I I I I I I I I I I ENTERPRISE Enterprise Fund Descriptions...... ......... .......................... ............................. ........... 71 Water Operations.............. ........ ...... ................. .............. .............. .................... 72-73 Water Debt Service ........................ ............ ....... ................. .......... ......... ........... 74-75 Sewer........... ..... ........ ............................................................. ............... ............ 76-77 Recycling .................................................. ........................................... ............ 78-79 Stormwater Management ....... ................................ ...................... ....... ............. 80-81 Liquor Operations Summary...................... ......................................... ...... ....... 82-83 Liquor - Shorewood Plaza.... .................... ..................... ..... ..... ............ ............ 84-85 Liquor - Waterford... ....... ................ ........................................ ..... .................... 86-87 Liquor - Tonka Bay...... ....................................... ..... ........................... ............ 88-89 GLOSSARY ................................ ..................... ........... ... ..................................... ....... 91-94 APPENDIX General Fund Detailed Budget.... ............. ....... .......... ........... ..................... ..... 95-133 Enterprise Fund Detailed Budget.. .................... ......................... ..... ............. 134-161 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@cLshorewood.mn.us January 2,2002 Honorable Mayor and Members of the City Council Residents of the City of Shorewood We are pleased to present to you the City of Shorewood 2002 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. This budget was discussed at Council work-sessions on August 13 and November 5,2001. The budget was prepared according to priorities and programs that the Council identified and incorporates the changes discussed at that time. The preliminary Pay 2002 budget and levy was certified to Hennepin County before September 17, 2001; the fmal budget was adopted by the City Council on December 10, 2001 and certified by December 28, 2001. ' The budget conforms to the City Council's Statement of Purpose, Goals, and Expectations. The budget supports the City's purpose of providing value in municipal services to our residents while assuring compliance with community laws and standards. 'Our goal is to do this in such an efficient, friendly manner that residents feel good about being citizens of the' Shorewood community. This budget is proposed as a guide to fulfilling our purpose and reaching our goal. Levy Limits Reinstated, , Many variables were considered when preparing the 2002 budget, such as the reinstatement of levy limits and the reduction of J;lon-tax revenues, as well as the importance of preserving the integrity of the General Fund balance. The 2002 Proposed Budget contemplates an increase in the City's tax levy, as permitted (and restricted) by the newly legislated levy limits. The proposed 20021evy is $2,763,367, which is an increase of about 5.4%, after correcting for the lost state aids the City must nOW levy for. The . City's estimated market value (tax base) as of July 2001 is $817.1 million, which is up from $769.8 million last year, an approximate 6% increase. Overall, property tax bills should decrease for most properties, because of other changes in the property tax structure. The 2002 Operating Budget also contemplates maintaining a General Fund balance of about $1.7 million in accordance with City Auditor recommendations to maintain 5 - 6 months reserve for working capital purposes. This is necessary because cities receive most of their revenue in June and December and must operate for six months at a time without major revenue flows. Major Features . The 2002 Proposed General Fund Budget is $3,270,162, which is an expenditure increase of approximately 4.5% from the $3,127,790 budgeted for 2001. Revenues are expected to remain fairly stable with the exception of building permit revenue, which is expected to decrease f'. tJ PRINTED ON RECYCLED PAPER 1 Budget 2002 Transmitt~l Letter - Page 2 because of reduced activity. Other sources of revenue include fees, permits, some limited inter- governmental aid, and transfers from other funds, including a $30,000 transfer from the liquor . store fund. The City COlillCil agreed with the staff recommendation to review city fees carefully and consider increases, especially park user fees, to assure parity. Some of the major items that contribute to the growth in expenditures include: Fire Department increases $45,700; Police Department requests $37,500; LMCD requests $2,500; Community Visioning Process $25,000; Elections $13,000; Recodification of the City Code Book (first year of two-year project) $10,000; Computer Equipment Upgrades $30,000; Senior Community Services $6,000; Professional Services increases (fertilizer legislation; assessor contract; transit 'opt-out' consulting) $48,000. In addition, the following general economic adjustments have been factored into the Proposed 2002 budget: scheduled pay plan increases including two percent cost-of-living increases in January and July and appropriate employee 'step' increases per the City salary charts; health insurance increases of approximately 12.5%; and volatile energy costs. Water Fund The Water Fund is comprised of two subfunds: Water Operations and Water Debt Service. The Water Operations sub fund includes the revenues received for the sale of water. The City currently has about 1,590 connections to its water system. The Water Debt Service sub fund accounts for the accumulation of resources for future debt retirement and for the annual payment of principal and interest on current water system debt. 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 fund. To offset this change, an increase is needed in the transfer from the Water Operating Fund. For example, the transfer to the water debt service in 2000 was $45,000 and in 2002 it will b~ $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. Sanitary Sewer Fund 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 interfllnd loans. These loans are being repaid on schedule from the Stormwater Management Fund and the Park Improvement 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. 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's sewer liiles. If the truck is not purchased, the City will contract with a service for scheduled sewer cleaning ($20,000). 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 2002 Transmittal Letter - Page 3 Stormwater Management and Recycling 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. Liquor Operations Fund 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 subj ect to renewal for the fIrst time in 7 years and staff has negotiated very persistently to reduce the amount of rent we must pay. We are willing to accept a smaller physical space in order to reduce this rent expense, and we anticipate a savings of about $40,000 annually by negotiating a favorable arrangement. 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. The City has agreed to extend its current lease for one- (1) year with an agreement to convert it to a fIve- (5) year lease pending the outcome of the various development proposals. Ifthese proposals are ultimately unsuccessful, we anticipate business as usual and will plan for capital improvements such as carpeting, countertops, and gondolas. , ' The Liquor Committee reviewed the Liquor Operations budgets at its October 22 meeting and recommended approval of the budgets by the City Council. Conclusion The'CityofShotewobd 2002~ual'OperatingHB1.ldget' is 'responsive "to the s'erviceneeds 'and concerns of the residents of the City and represents the best joint efforts of the City Council and staff. Respectfully submitted, ;it Bonnie Burton Finance Director/Treasurer 3 I I I I Date 07/09/01 I 07/20/01 I 07/31/01 08/01/01 I 08/13/01 I 08/23/01 I 08/27/01 09/01/01 I 09/10/01 I 09/15/01 I 10/01/01 10/08/01 I 10/19/01 I 11/05/01 I 12/08/01 12/10/01 I 12/28/01 I I I City of Shorewood Year 2002 Budget Schedule Description Council work-session to provide direction to staffre: budget priorities. Budget worksheets distributed to staff and department heads. Completed operating budget worksheets due from staff. MN Department of Revenue to certify LGA (Local Government Aid) and LP A (Local Performance Aid) to cities. Regular city council meeting. Council and staff budget work session. Preliminary budget completed. Regular city council meeting. Draft budget presented to City Council. MN Department of Revenue to certify HACA to cities. Regular city council meeting. Council adopts 2002 preliminary budget and levy. Proposed budget and levy must be adopted and certified to County Auditor by this date. State form Payable 2002 PT Form 280 also to be submitted. County to certify Levy Certification Tax Rate to Cities. "Tax Rate Public Hearing" requirement waived for 2002 budgets. Tax Rate Public Hearing and submission of council resolution approving the tax rate increase due, to the state by this date. (The tax rate hearing is optional this year.) Regular City Council meeting. Enterprise fund budget workshop with Council and staff. Counties to mail Notice of Proposed Property Tax. by this date. Regular city council meeting. Final budget and levy adopted. Final levy and budget must be certified to the County Auditor by this date. State forms Payable 2002 Property Tax Levy Report and PT Form TNT2002 also due. 5 - - - ...... Personnel Accounting Payroll Investments Utility Billing Accts. Payable Accts. Receivable Spedal Assessments Budgeting MIS Purchasln - - - - - - - - - - - - - - CITY OF SHOREWOOD ORGANIZATION CHART Off-Sale Retail CONTRACTED SERVICES ASSESSOR--------HENNEPIN COUNTY RECYa.ING-------EZ RECVa.ING UTILlTIES--------MUNITECH ANIMAL CONTROL--crry OF ORONO ANIMAL IMPOUND--PAWS, CLAWS &. HOOVES FIRE (ISlands)---MOUND crrY COUNCIL RECEPTIONISTI PARK SECRETARY COMMUNICATIONS TECHNICIAN General Government Ucensing Elections Records Legal Publications Public Information Recreation Programs Cable TV franchise crry ATTORNEY Planning Zoning Administration Property Records Inspection JOINT POWERS ORGANIZATIONS POUCE - SLMPD FIRE - EXCELSIOR FIRE DISTRICT LMCC - Lake Minnetonka Communications Commission LMCO - Lake Mlnnetonka Conservation District Building and Grounds Tree Maintenance Park Maintenance Street MaIntenance Equipment Maintenance Stonnwater System Street Ughting Sanltation/Weeds Janitor Services (Contract) Utility Maintenance (Contract) Park Planning Contract - - ENGINEERING ADMIN. ASST. Engineering Services Project Mgmt 2002 $1,033 667 173 1,022 321 I I I I I I I I .1 I I I I I City of Shorewood 2002 'City Services Are a' Good Value How does the City of Shorewood propose to spend funds? COMPARED WITH OTHER service and utility cqarges for the aver- age household, City of Shorewood services remain a bargain! Public Safety Public Works Parks & Rec General All Other 2001 $929 647 152 866 504 City services provided for $740 (the city portion of taxes on"a $250,000 average value home.) Total Budget $3,098 (numbers in thousands) · Police protection · Fire protection · Street maintenance · Snow plowing · Parks and trails · Building and other inspections · Other City services $3,216 City of Shorewood Proposed 2002 Expenditures All Other 10% ....~ :.,.<,,, )\'ffi.~~:""~r"""~"")'- l;;:tJ:~.~~;~f/.."t;.'f1 \?/;:}>: .~. ID_~PO'\C~~" a;m,~~.;1'RJ, ~f1f1 ";&;&tWEJ~~~/~ . General Services 32% Parks & Rec 5% Budget Action Public Safety 32% Public Works 21% ALTHOUGH THE STATE does not require hearings for 2002, public comment is valued in Shorewood. The City Council w:i11 I be discussing the budget action for 2002 at the following meeting: . Monday, December 10,7 PM City Council Chambers 5755 Country Club Road Shorewood, NIN' 55331 (952) 474-3236 THE SHORE REPORT I DECEMBER 2001 8 I I I I I I I I I I I I I I I I I I I I I I I M~J. Your 2002 Prope~tyTaxe's Proposed Property Tax Notice . J. YOU WILL SOON RECEIVE a notice from Hennepin County regard- ing the amount of property taxes your school district, the county, and the city can collect in 2002. You'll notice a lot of changes this year. Your actual taxes may be lower than the proposed tax on your notice. These are the maximum taxes that can be levied after November 30. Your actual tax statement will arrive in the spring. Because of the major changes, the state modified the notice fonnat for this year so that only the 2001 tax total is listed: . Proposed 2002 Ptoperty Tax For an Average Shorewood Home Estimated Market Value $250,000 2001 , 2002 $1,215 740 County City School Voter Approved Other School1btal Metro Districts Total Tax $4,582 882 170 1,052 272 $3.279 Tax Decrease $1,303 -28.4% ,r... Property Tax Reform THE PAST LEGISLATIVE SESSION dramatically changed Minnesota's . property tax system. Most significantly, Shorewood lost its.entire $427,000 state aid allocation~ The Legislature. expected and specifically allowed cities to levy for all of their lost state aids. TIlls means that over 85% of city operations must now be funded by property taxes. The state also assumed primary responsibility for school nmding. As a result, a far greater share of your property tax dollar now goes to Hennepin County and the City of Shorewood. Where your 2002 "property tax dotlar goes Special Districts 8% Schools 32% Hennepin County 37% THE SHORE REPORT I DECEMBER 2001 9 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 current day-to-day operations will be financed from this fund. 11 CITY OF SHOREWOOD I GENERAL FUND SUMMARY I 2002 ADOPTED BUDGET Actual Actual Budget YTO June Requested Proposed Adopted $$ I 1999 2000 2001 2001 2002 2002 2002 Change Revenues and Other Sources Property Taxes 1,870,727 1,938,705 2,208,574 1,025,775 2,763,367 2,763,367 2,763,367 554,793 I Licenses and Permits 221 ,555 346,086 141,200 143,122 199,200 199,200 199,200 58,000 Intergovernmental 468,969 485,046 453,916 0 26,918 26,918 26,918 (426,998) Fines and Forfeitures 94,115 76,483 95,000 26,359 50,677 50,677 50,677 (44,323) Charges for Service 43,348 29,381 54,100 4,582 30,000 30,000 30,000 (24,100) I Miscellaneous Revenue 84,562 200,843 145,000 30,012 145,000 145,000 145,000 Total Revenues 2,783,276 3,076,544 3,097,790 1 ,229,848 3,215,162 3,215,162 3,215,162 117,372 I Expenditures General Government I Mayor and Council 64,322 66,071 95,514 35,850 120,814 120,814 120,814 25,300 Administration 112,865 134,152 107,023 48,144 106,940 106,940 106,940 (83) General Government 126,506 182,458 125,609 69,771 169,945 169,945 169,945 44,336 I Finance 114,872 103,103 118,376 57,485 137,834 137,834 137,834 19,458 Professional Services 131,017 228,178 149,950 103,778 198,800 198,800 198,800 48,850 Planning and Zoning 110,469 88,364 137,985 65,858 138,117 138,117 138,117 132 Municipal Building 138,107 131,199 132,020 56,614 149,585 149,585 149,585 17,565 I Total General Government 798,158 933,525 866,477 437,500 1,022,035 1,022,035 1,022,035 155,558 Public Safety I Police 547,335 549,882 578,482 318,155 615,443 615,443 615,443 36,961 Fire Protection 166,355 191,175 235,954 126,219 295,500 295,500 295,500 59,546 Protective Inspection 67,254 67,852 92,273 32,299 99,233 99,233 99,233 6,960 I Animal Control 18,570 18,574 21,800 9,793 22,700 22,700 22,700 900 Total Public Safety 799,514 827,483 928,509 486,466 1,032,876 1,032,876 1,032,876 104,367 I Public Works City Engineer 91,275 93,101 114,681 39,779 100,439 100,439 100,439 (14,242) Public Works Services 234,581 225,362 277,431 122,426 301,290 301,290 301,290 23,859 I Streets and Roadways 104,506 113,102 138,905 39,606 146,283 146,283 146,283 7,378 Snow and Ice Removal 30,039 32,110 48,495 30,625 50,156 50,156 50,156 1,661 Traffic Control/Street Lights 39,094 38,217 39,550. 17,594 39,750 39,750 39,750 200 I Sanitation/Waste Removal 456 7,679 4,130 .1,081 4,150 4,150 4,150 20 Tree Maintenance 16,773 20,445 23,868 3,553 24,613 24,613 24,613 745 Total Public Works 516,724 530,016 647,060 254,664 666,681 666,681 666,681 19,621 I Culture and Recreation Parks and Recreation 114,435 135,891 151,744 64,012 172,770 172,770 172,770 21,026 I Total Culture and Recreation 114,435 135,891 151,744 64,012 172,770 172,770 172,770 21,026 Total Expenditures 2,228,831 2,426,915 2,593,790 1,242,642 2,894,362 2,894,362 2,894,362 300,572 I Total Revenues Over (Under) I Expenditures 554,445 649,629 504,000 (12,794) 320,800 320,800 320,800 (183,200) 12 I I CITY OF SHOREWOOD I GENERAL FUND SUMMARY 2002 ADOPTED BUDGET I Actual Actual Budget YTD June Requested Proposed Adopted $$ 1999 2000 2001 2001 2002 2002 2002 Change Fund Transfers In Liquor Fund 0 10,000 10,000 0 30,000 30,000 30,000 20,000 I Street Reconstr Fund 32,000 0 0 0 0 0 0 Trail Fund 6,000 3,000 5,000 0 0 0 0 (5,000) Sewer Fund 6,000 10,000 10,000 0 15,000 15,000 15,000 5,000 I Water Fund 2,400 5,000 5,000 0 10,000 10,000 10,000 5,000 Total Tr; nsfers In 46,400 28,000 30,000 0 55,000 55,000 55,000 25,000 I Fund Tranders Out i:quip Replacemt Fund (Pol 800 800 800 0 800 800 800 Euip Replacemt Fund (P 107,000 112,000 116,500 0 70,000 70,000 70,000 (46,500) I St,et Reconstr Fund 360,000 347,000 367,000 0 200,000 200,000 200,000 (167,000) Par' Capital Imp Fund 0 10,000 10,000 0 35,000 35,000 35,000 25,000 Publi,: Facilities Fund 15,000 15,000 29,700 0 35,000 35,000 35,000 5,300 I Storm,later Mgmt Fund 10,000 10,000 10,000 0 35,000 35,000 35,000 25,000 Total Fund Transfer;~ Out 492,800 494,800 534,000 0 375,800 375,800 375,800 (158,200) I Excess (Deficiency) oi Revenues and Other Financing SourcE. <; Over Expenditures and Other t.!ses 108,045 182,829 0 (12,794) 0 0 0 I Amounts to be Provided fro 11 General Fund Balance 0 0 0 0 0 0 0 I General Fund Balance January 1 1,402,173 1,566,351 1,749,180 1,749,180 1,749,180 1,749,180 1,749,180 I General Fund Balance December 31 1,566,351 1,749,180 1,749,180 1,736,386 1,749,180 1,749,180 1,749,180 I I I I I I I 13 CITY OF SHOREWOOD 2002 ESTIMATED REVENUES I BUDGET COMMENTS' GENERAL FUND REVENUES TAXES: The City levies property taxes to finance the general operating fund which provides municipal governmental services Fiscal Disparities - 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 to communities in the metropolitan area. I I I LICENSE/PERMIT FEES: Rental Housing Liceqse 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. State Surcharge Collections - Surcharges collected on building permits equal to 0.5% of the improvement value. The City retains an administrative fee equal to 4% of the fee. Buildlna Permits - Permit fee based upon valuation of structure according to Uniform Building Code Schedule. Doa Licenses pther Non-business - Horse permit and alarm permit fees. I I I I INTERGOVERNMENTAL REVENUE: I FEMA Disaster Aid - a one-time federal aid for 1998 storm damage equal to 75 % of actual related costs Storm/Snow Disaster Aid - relief aid to cities for unusual snow season 1996-97 and storm damage in 1998 Metropolitan Council PlanninQ Grant - a grant from the Metropolitan Council for 1998 for land use and park and trail planning. Local Government Aid - the continuance of the discontinued Local Performance Aid Homestead and Agriculture Credit Aid (HACA)- AState credit which reduced the tax levy. Eliminated 20[2. l-ocal 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 (he City's PERA contribution. MSA Road Aid (Became eligible for this aid as of 1/1/90) Aid provided by the State of Minnesota to cities over 5,000 in population to maintain designatfd MSA roads. I I I I CHARGES FOR SERVICES: I General Government The City provides services to the public for which a charge is collected such as assessment services, map sales, planning fees, etc. Enaineerina - Fees charged to other City funds and developers for engineering servt,es. Recreation - fees charged for recreation uses I I FINES & FORFEITS - Fines imposed for traffic & ordinance violations. I MISC. REVENUES - Revenue from a variety of sources such as interest incr (:1:, dry hydrant charges, pop sales, cellular antenna rental and other miscella <;e.Js revenues. FUND BALANCE - Fund Balance allocated for 2002 budget purposes. I 14 I I ...... 0) Parks 5% Public Works .__~O% - I CITY OF SHOREWOOD ADOPTED 2002 GENERAL FUND EXPENDITURES Street Proj ects 6% Capital Tsfrs 3% Other Public Safety 4% Capital Equip I 2% I j General Gov't 32% ------------------- I I CITY OF SHOREWOOD GENERAL FUND SUMMARY OF EXPENDITURES 2002 ADOPTED BUDGET I BUDGET BUDGET BUDGET DEPT ACTUAL ACTUAL BUDGET YTD JUNE REQUEST PROPOSED ADOPTED I NO. DEPARTMENT 1999 2000 2001 2001 2002 2002 2002 41110 Mayor and Council 76.008 66,070 95,514 35,850 120,814 120,814 120,814 41300 Administration 104,535 134,152 107,023 48,144 106,940 106,940 106,940 I 41400 City Clerk 114,348 182,458 125,609 69,771 169,945 169,945 169,945 41500 Finance 107,857 103,103 118,376 57,485 137,834 137,834 137,834 41600 Professional Services 152,000 228,178 149,950 103,778 198,800 198,800 198,800 I 41910 Planning & Zoning 103,651 88,364 137,985 65,858 138,117 138,117 138,117 41940 Municipal Building (City Hall) 130,100 93,655 132,020 56,614 149,585 149,585 149,585 Capital Transfer - Office Equip 15,000 15,000 29,700 0 35,000 35,000 35,000 I 42100 Police 553,428 549,882 578,482 318,155 615,443 615,443 615,443 Capital Transfer - Equip 800 800 800 0 800 800 800 42200 Fire 166,355 191,175 235,954 126,219 295,500 295,500 295,500 I 42400 Protective Inspection 84,112 67,852 92,273 32,299 99.233 99,233 99,233 42700 Animal Control 18,000 18.574 21,800 9,793 22,700 22,700 22,700 43010 City Engineer 102,477 93,101 114.681 39.779 100,439 100,439 100,439 43050 Public Works Service 205,190 225,362 277,431 122,426 301,290 301,290 301,290 I Capital Transfers - Equip & Stormwtr 117,000 122,000 126,500 0 105.000 105,000 105,000 43100 Streets & Roadways 131,691 113,102 138,905 39,606 146,283 146,283 146,283 Capital Transfer - Street Imps 360,000 347.000 367,000 0 200,000 200.000 200.000 I 43125 Snow & Ice Removal 44,817 32,110 48,495 30,625 50,156 50,156 50,156 43160 Traffic Control/Street Lighting 38,500 38,217 39,550 17,594 39,750 39,750 39,750 43200 SanitationlWaste RemovallWeeds 4,616 7,679 4,130 1,081 4,150 4,150 4,150 I 43250 Tree Maintenance 22,222 20,445 23,868 3,553 24,613 24,613 24,613 45200 Parks & Recreation 148,606 173,435 151,744 64,012 172,770 172,770 172,770 Capital Transfer - Park Imps 0 10,000 10,000 0 35,000 35,000 35,000 I TOTAL GENERAL FUND EXPENDITURES 2,801,313 2,921,714 3.127,790 1,242,642 3,270,162 3,270,162 3,270,162 I I I I I I I 17 18 I I I I I I I I I I I I I I I I I I I FUND: 101 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 workshops to consider and adopt legislative and administrtive policies that pertain to the services provided to citizens. . OBJECTIVES: - Strategic planning HIGHLIGHTS/COMMENTS: Staffing: City Council Salaries Supplies/Materials: Awards and misc. supplies Support Services: Christmas Lake Milfoillnspections (2) Strategic Planning Consultant Conferences and Seminars Appreciation Function for City Volunteers/Staff City Newsletters (12) & Council Brochure Lake Minnetonka Conservation District (LMCD) Assn of Metro Municipalities League of MN Cities Excelsior Chamber of Commerce July 4th Fireworks Charges, Fees & Other: Council Contingency I FUND: 101 DEPARTMENT: Mayor and Council DEPT 41110 I BUDGET Actual Actual Budget YTD June Requested Proposed Adopted ITEM 1999 2000 2001 2001 2002 2002 2002 I I Staffing 13,564 13,564 13,564 6,782 13,564 13,564 13,564 Supplies/Materials 1,906 684 1,500 387 1,500 1,500 1,500 I Support Services 48,352 42,803 50,450 22,989 75,750 75,750 75,750 Charges, Fees & Other 500 9,020 30,000 5,692 30,000 30,000 30,000 I Capital Outlay 0 0 0 0 0 0 0 I Transfers 0 0 0 0 0 0 0 TOTAL 64,322 66,070 95,514 35,850 120,814 120,814 120,814 I SERVICE INDICATORS: I Seminars, Conferences & . Schools Attended 1 5 5 5 I Newsletters Published 12 12 12 12 No. of Council Mtgs. 24 24 24 24 No. of Workshops/Specia . 36 24 24 24 I Agenda Items 591 500 500 500 Ordinances & I Resolutions Adopted 135 130 130 130 I COST INDICATORS: Expenditures 64,322 66,070 95,514 35,850 120,814 120,814 120,814 I - Program Revenues I = Levy Dollars 64,322 66,070 95,514 35,850 120,814 120,814 120,814 I STAFFING: Part time: I Mayor 1.00 1.00 1.00 1.00 1.00 1.00 1.00 Council members 4.00 4.00 4.00 4.00 4.00 4.00 4.00 I I 19 20 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 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. DEPARTMENT: Administration DEPT NO: 41300 DESCRI PTION 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 - Review City objectives each quarter in detail - Be active in regional housing issues HIGHLIGHTS/COMMENTS: Staffing: Includes step increases Supplies/Materials: Maintenance contracts on computer equipment Miscellaneous books & supplies Support Services: Labor Relations Associates Contract Conference, mileage, meetings & seminars Memberships to ICMA, MCMA, MAMA, MPELRA & Rotary I FUND: 101 DEPARTMENT: Administration DEPT 41300 I BUDGET Actual Actual Budget YTD June Requested Proposed Adopted ITEM 1999 2000 2001 2001 2002 2002 2002 I Staffing 106,403 104,017 99,773 40,071 98,140 98,140 98,140 I Supplies/Materials 375 0 400 47 400 400 400 I Support Services 6.087 30,134 6,850 7,702 8,400 8,400 8,400 Charges & Fees 0 0 0 0 0 0 0 I Capital Outlay 0 0 0 324 0 0 0 I Transfers 0 0 0 0 0 0 0 TOTAL 112,865 134,151 107,023 48,144 106,940 106,940 106,940 I SERVICE INDICATORS: I Council MtgslWork Session 66 48 48 48 Council Agenda Items 591 500 500 500 Park Comm. Meetings 23 20 20 20 I Staff Meetings 50 52 52 52 I COST If\lDICATORS: Expenditures 112,865 134,151 107,023 48.144 106,940 106,940 106,940 I - Program Revenues 0 0 0 0 0 0 0 I = Levy Dollars 112,865 134,151 107.023 48,144 106,940 106,940 106,940 I STAFFING: I Full Time: Admistrator/Clk 1.00 1.00 1.00 1.00 0.90 0.90 0.90 I Exec Sec/Dep Clk .33 .33 .33 .33 .33 .33 .33 I I I 21 22 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 staff support for the City Council including preparation of agendas and meeting packets. Responsible for City Clerk functions including elections, records retention, notices and licenses. DEPARTMENT: City Clerk DEPT NO: 41400 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. It also 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 fuctions. It also oversees implementation of the City communications plan. OBJECTIVES: -Continue to improve web site, allowing visitors to communicate better with City Hall via the web _ Improve City newsletter through the addition of more community pictures and/or articles _ Improve response time to residents making general inquiries through various communications tools _ Increase youth awareness of local government issues through active involvement with school officials and instructors through programs such as student election judges _ Monitor and report on effectiveness of communications plan _ Develop orientation package for new council members. commission members and staff - Develop employee manual _ Develop hiring manual for city positions setting uniform practices for each - Develop wards/ notices to residents HIGHLIGHTS/COMMENTS: Staffing: Includes step increases for full time employees, part-time communications tech & election judges Supplies/Materials: Office supplies Maintenance contracts for computer printers Support Services: Conference, mileage and Seminars publication of legal notices for all General Fund Depts Council Recording Secretary Computer Consulting and Training Memberships to liMe, MCFOA & Municipals Capital Outlay: Voting Booths (6) I I FUND: 101 DEPARTMENT: City Clerk DEPT 41400 BUDGET Actual Actual Budget YTD June Requested Proposed Adopted ITEM 1999 2000 2001 2001 2002 2002 2002 I Staffing 97,870 127,494 86,119 52,976 107,909 107,909 107,909 I Supplies/Materials 12,600 19,801 18,600 8,123 28,475 28,475 28,475 Support Services 16,036 29,412 20,390 6,018 28,236 28,236 28,236 I Charges & Fees 0 0 0 0 0 0 0 I Capital Outlay 0 692 500 2,653 5,325 5,325 5,325 Transfers 0 0 0 0 0 0 0 I TOTAL 126,506 177,399 125,609 69,771 169,945 169,945 169,945 I SERVICE INDICATORS: No. of Elections held 2 2 2 2 2 No. of Ordinances 5 10 10 10 10 I No. of Resolutions 130 120 120 120 120 Dog licenses issued 440 450 475 475 475 I Other Hcenses issued 30 30 45 45 45 Council Agendas 44 48 52 52 52 I COST INDICATORS: I Expenditures 126,506 177,399 125,609 69,771 169,945 169,945 169,945 - Program Revenues I Licenses 14,453 20,350 20,350 20,350 20,350 Sale of copies 651 1.000 1,000 . 1,000 1,000 I = Levy Dollars 111,402 177,399 104,259 .' 69,771 148,595 148,595 148,595 I STAFFING: Full time: I Exec Sec/Dep Clk .67 .67 .67 .67 .67 .67 .67 Parks Secretary .70 .70 .70 .70 .70 .70 .70 Secretary/Receptio nist 0.25 0.25 0.25 0.25 0.25 0.25 0.25 I Part time: Clerical 1.00 1.00 1.00 1.00 0.50 0.50 0.50 I Seasonal: Summer Clerical 1.00 1.00 1.00 1.00 1.00 1.00 1.00 I FIAr.tinn .Judaes 0.00 32.00 33.00 0.00 35.00 35.00 35.00 23 24 I I I I .1 I I I I I I I I I I I I I I FUND: 101 General 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. DEPARTMENT: Finance DEPT NO: 41500 DESCRIPTION OF ACTIVITY: 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. OBJECTIVES: - Prepare annual budget document and submit to GFOA Distinguished Budget Award Program - Prepare CAFR for submittal to GFOA Certificate of Achievement Program - Provide monthly reports to staff, quarterly reports to City Council - Review debt issues and make recommendations on debt structure - Review and Update financial policies and procedures HIGHLIGHTS/COMMENTS: Staffing: Includes step increases Supplies/Materials: Computer checks & budget supplies Finance software support and maintenance Miscellaneous supplies 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 Capital Outlay: I I FUND: 101 DEPARTMENT: Finar,~e DEPT 41500 BUDGET Actual Actual Budget YTD June Requested Proposed Adopted I ITEM 1999 2000 2001 2001 2002. 2002 2002 Staffing 103,196 95,777 101,376 ";7,901 112,134 112,134 112,134 I Supplies/Materials 2,812 4,053 3,450 ,,03 13,500 13,500 13,500 Support Services 8,864 3,274 13,550 9,08\~ 10,200 1 0,200 1 0,200 I Charges & Fees 0 0 0 0 0 0 0 I Capital Outlay 0 0 0 0 2,000 2,000 2,000 Transfers 0 0 0 0 0 0 0 I TOTAL 114,872 103,104 118,376 57,485 137,e34 137,834 137,834 I SERVICE INDICATORS: No. Monthly Statements 12 12 12 12 No. Accounts Payable I Checks Issued 2,070 2,500 2,700 2,700 Utility Bills Sent 10,850 11,000 12,000 12,000 I No. of payroll Checks Issued 1,123 1,100 1,300 1,300 No. of Sp. Assess. I Rolls Maintained 23 23 23 23 COST INDICATORS: I Expenditures 114,872 103,104 118,376 57,485 137,834 137,834 1"7,834 - Program Revenues Interest Earnings I Sp.Assess.Searches = Levy Dollars 114,872 103,104 118,376 57,485 137,834 137,834 137,834 I STAFFING: Full time: I Finance Dir 1.00 1.00 1.00 1.00 1.00 1.00 1.00 Sr Acctg Clerk .60 .60 .60 .60 .60 .60 .60 I I I I 25 26 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 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 contract;d iegal, assessing and auditing services for the City. Legal services include genera' counsel to the City Council, litigation and prosecution of criminal misdemear JrS. Assessing services provide property valuation information for tax purposes. Auclt services provide for the annual financial audit required by Minnesota State Statutes. OBJECTIVES: - Contain costs on contr::tc:ed professional services - Attempt to utilize mec .a:ion services to avoid litigation HIGHLlGHTS/COfYMENTS: Supplies/Materi, IS. Supplies for '::\ty Assessor Support SUVices: Includr,S general legal fees and prosecutions, mediation services, assessing contract and ~nnual audit services Ch;:: rges and Fees: Court Awards from Litigation 28 I I I I I I I I I I I I I I I I I I I FUND: 101 Genera! 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 H'IGHLlGHTS/COMMENTS: Staffing: Includes step increases Intern for Land Conservation/Environment Committee Supplies/Materials: Maintenance contracts for computer & office equipment Miscellaneous supplies Support Services: Database Technical Assistance Recording. Secretary for Planning Commission Meetings Air time for cellular phone Conferences, mileage, meetings & seminars Land Conservation/Environment Committee expenses Memberships to APA, MN APA, Sensible Land Use Coalition Subscriptions to APA Journal & Zoning News Charges & Fees: Capital Outlay: I I FUND: 101 DEPARTMENT: Planning & Zoning DEPT 41910 BUDGET Actual Actual Budget YTD June Requested Proposed Adopted ITEM 1999 2000 2001 2001 2002 2002 2002 I Staffing 100,468 77,668 118,635 51,462 118,767 118,767 118,767 I Supplies/Materials 357 357 400 0 900 900 900 I Support Services 9,408 10,340 17,850 13,914 17,750 17,750 17,750 Charges & Fees 0 0 0 0 0 0 0 I Capital Outlay 236 0 1,100 482 700 700 700 I Transfers 0 0 2,500 0 0 0 0 TOTAL 110,469 88,365 140,485 65,858 138,117 138,117 138,117 I 9ERVICE INDICATORS: No. of zoning apps. 16 20 20 20 20 I No. of zoning complnts 18 20 20 20 20 Planning Comm. Meeting 12 12 12 12 12 I Planning Comm. Work Sessions 11 12 12 12 12 I COST INDICATORS: I Expenditures 110,469 88,365 140,485 65,858 138,117 138,117 138,117 I - Program Revenues Zoning Appl. Fees 2,915 5,000 5,000 5,000 5,000 Bldg. Permit Carryover 134,173 93,484 31,127 31,127 31,127 I (from Proto Inspection) = Levy Dollars (26,619) 88,365 42,001 65,858 101,990 101,990 101,990 I STAFFING: I Full time: Planning Dir .95 .95 .95 .95 .95 .95 .95 Planning Asst. .70 .70 .70 .70 .70 .70 .70 I Part Time: Clerical 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: 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: MunicipalBldg - 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 Software upgrades 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 and pop machine 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 June Requested Proposed Adopted ITEM 1999 2000 2001 2001 2002 2002 2002 I Staffing 0 0 0 0 0 0 0 I Supplies/Materials 10,071 7,426 10,170 5,218 9,585 9,585 9,585 I Support Services 89,952 86,229 82,850 13,392 97,050 97,050 97,050 Charges & Fees 0 0 0 0 0 0 0 I Capital Outlay 38,084 42,040 39,000 38,004 42,950 42,950 42,950 I Transfers 25,000 15,000 25,000 0 35,000 35,000 35,000 TOTAL 163,107 150,695 157,020 56,614 184,585 184,585 184,585 I SERVICE INDICATORS: I Number of copies 240,000 275,000 275,000 275,000 275,000 I COST INDICATORS: Expenditures 163,107 150,695 157,020 56,614 184,585 184,585 184,585 I - Program Revenues Insurance rebate 24,013 30,000 30,000 30,000 30,000 I ::: Levy Dollars 139,094 150,695 127,020 56,614 154,585 154,585 154,585 I Other Dollars I STAFFING: I I I I I 31 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 Police Department is a cooperative joint venture between the cities of Excelsior, Greenwood, Shorewood and Tanka 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% OBJECTIVES: _ Implement targeted traffic control program HIGHLIGHTS/COMMENTS: Supplies/Materials: Service for civil defense sirens Fuel/maintenence for Snowmobile Support Services: Police services contract for 2002 Targeted Traffic Control Prisoner expense, court officer expense, & booking fees Annual police Auxilliary Dinner Transfers: Transfer to Equipment Replacment Fund for Snowmobile Replacement 32 .1 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 FUND: 101 BUDGET ITEM Staffing Supplies/Materials Support Services Charges & Fees Capital Outlay Transfers. TOTAL SERVICE INDICATORS: Initial complaint reports Clearance rate - ICR's Part I crimes (serious) Part \I crimes (other) Clearance rate (Parts 1 & II) Statewide clearance rate Citations issued Police vehicles Shorewood demand COST INDICATORS: Expenditures - Program Revenues Fines = Levy Dollars STAFFING: Chief Lieutenant Sergeant Investigator .,. Patrol Officer Shorewood Traffic Control Offic Administrative Clerk Clerl<!Typist (part time) ** .,. 1 Juvenile Specialist DEPARTMENT: Police DEPT 42100 Actual Actual Budget YTD June Requested Proposed Adopted 1999 2000 2001 2001 2002 2002 2002 0 0 0 0 0 0 0 401 0 0 0 0 0 0 546,934 549,811 577,882 318,155 615,443 615,443 615,443 0 0 0 0 0 0 0 0 0 0 0 0 0 0 800 800 800 0 800 800 800 548.135 550,611 578,682 318.155 616,243 616,243 616,243 18,802 20,501 20,501 20,501 20,501 96.9% 97.0% 97.0% 97.0% 97.0% 242 250 250 250 250 650 625 625 625 625 55.0% 58.0% 58.0% 58.0% 58.0% Unknown Unknown Unknown Unknown Unknown 4,625 4,500 4,500 4,500 4,500 8 9 9 9 9 45.9% 45.5% 46.0% 46.0% 46.0% 548,135 550,611 578,682 318,155 616,243 616,243 616,243 58,240 75.700 0 0 0 489,895 492,371 502,982 318.155 616,243 616.243 616.243 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 7.00 7.00 7.00 7.00 7.75 7.75 7.75 1.00 1.00 1.00 1.00 0.25 0.25 0.25 1.00 1.00 1.00 . 1.00 1.00 1.00 1.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 ** 2 Part time @ .6 33 34 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 cities of Excelsior and 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. OBJECTI\lES: HIGHLIGHTS/COMMENTS: Support Services: Fire contracts with Mound ($9,300) and Excelsior (est. $284,503) I I FUND: 101 DEPARTMENT: Fire Protection DEPT 42200 BUDGET Actual Actual Budget YTD June Requested Proposed Adopted ITEM 1999 2000 2001 2001 2002 2002 2002 I Staffing 0 0 0 0 0 0 0 Supplies/Materials 0 0 0 0 0 0 0 I ,Support Services 166,355 191,175 235,954 126,219 295,500 295,500 295,500 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 166,355 191,175 235,954 126,219 295,500 295,500 295,500 I SERVICE INDICATORS: Fire calls 148 135 135 135 135 I Rescue calls 126 125 125 125 125 Inspection hours 225 25 25 25 25 I Investigation hours 22 35 35 35 35 Other hours * 517 400 400 400 400 Cost of emergency I respons . 150,975 218,083 277 ,629 277,629 277,629 Cost of inspection/ investigation 15,380 17,871 17,871 17,871 17,871 I * includes plan review, paper work, complaint investigation, tank removals, burning permits, etc. ~OST INDICATORS: I Expenditures 166,355 191,175 235,954 126,219 '295,500 295,500 295,500 - Program Revenues 0 0 0 0 0 0 0 I = Levy Dollars 166,355 191,175 235,954 126,219 295,500 295,500 295,500 STAFFING.:. I Chief 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 Captain 2.00 2.00 . 2.00 2.00 2.00 .2.00 2.00 I Lieutenants 4.00 4.00 4.00 4.00 .4.00 4.00 4.00 Fire Marshall 1.00 1.00 1.00 1.00 1.00 1.00 1.00 Training Officer 1.00 1.00 1.00 1.00 1.00 1.00 1.00 I Firefighters 37.00 37.00 37.00 37.00 37.00 37.00 37.00 I I I I 35 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: Enforce construction safety and related building codes through plan review and inspections. Enforce animal control ordinances. DEPARTMEN 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 I FUND: 101 DEPARTMENT: Protective Inspection DEPT 42400 BUDGET Actual Actual Budget YTD June Requested Proposed Adopted I ITEM 1999 2000 2001 2001 2002 2002 2002 Staffing 64,542 64,445 85,673 30,256 91,353 91,353 91,353 Supplies/Materials 166 251 1,050 256 400 400 400 I Support Services 2,546 3,157 5,550 1 ,404 7,080 7,080 7.080 Charges & Fees 0 0 0 0 0 0 0 I Capital Outlay 0 0 0 383 400 400 400 Transfers 0 0 0 0 0 0 0 TOTAL 67,254 67,853 92,273 32,299 99,233 99,233 99,233 I SERVICE INDICATORS: No. of permits issued I New Homes 35 50 18 18 18 Additions/Other 623 600 400 400 400 I Avg inspections/permit New Homes 8-10 8-10 8-10 8-10 8-10 Additions/Other 2-8 2-8 2-8 2.8 2-8 I No. of complaints COST INDICATORS: I Expenditures 67.254 67,853 92,273 32,299 99,233 99,233 99,233 - Program Revenues Building Permits 201,336 175,000 175,000 175,000 175,000 I State Surcharges 7,996 500 500 500 500 Rental Housing Licens 0 3,500 3,500 3,500 3,500 = Levy Dollars (142,078) 67,853 (86,727) 32,299 (79,767) (79,767) (79,767) I STAFFING.:. Full time: I Building Official 1.00 1.00 1.00 1.00 1.00 1.00 1.00 Planning Dir .05 .05 .05 .05 .05 .05 .05 Planning Asst .30 .30 .30 .30 .30 .30 .;30 I Secretary/Recept . .10 .10 .10 .10 .10 .10 .10 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 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 I FUND: 101 DEPARTMENT: Animal Control DEPT 42700 BUDGET Actual Actua[ Budget YTD June Requested Proposed Adopted ITEM 1999 2000 2001 2001 2002 2002 2002 I Staffing 0 0 0 0 0 0 0 Supplies/Materials 0 0 0 0 0 0 0 I Support Services 18,570 18,574 21,800 9,793 22,700 22,700 22,700 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 18,570 18,574 21,800 9,793 22,700 22,700 22,700 I SERVICE INDICATORS: I No. of Animal Complaints I COST INDICATORS: Expenditures 18,570 18,574 21,800 9,793 22,700 22,700 22,700 I - Program Revenues I = Levy Dollars 18,570 18,574 21,800 9,793 22,700 22,700 22,700 I STAFFING: Full time: I 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: 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% of City Engineer/Public Works Director, including step increases 25% of full time technician 25% of full time clerical Supplies/Materials: Computer maintainance/Upgrade Books, Materials and Software Support Services: Contractual engineering for 2002 Contractual engineering technical assistance Cellular phone Airtime & Pager Conferences and mileage Subscriptions and Memberships Charges & Fees: Capital Outlay: 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: 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 ]-I I GH LIGHTS/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 pr!vateproperty (mailboxes, etc) HazardoUs Waste Licenses Miscellaneous equipment rentals Memberships Charges & Fees: Capital Outlay: Replacement Radios Transfers: Transfer to Equipment Replacement Fund I I FUND: 101 DEPARTMENT: Public Works Service DEPT 43050 BUDGET Actual Actual Budget YTD June Requested Proposed Adopted I ITEM 1999 2000 2001 2001 2002 2002 2002 I Staffing 182,624 169,537 213,381 87,687 235,205 235,205 235,205 supplies/Materials 33,454 29,655 39,900 18,932 40,000 40,000 40,000 I Support Services 17.299 24,279 22,150 14,742 23,460 23,460 23,460 I Charges & Fees 0 0 0 0 0 0 .0 Capital Outlay 1,204 1,891 900 1,065 2,625 2,625 2,625 I Transfers 107,000 122,000 126,500 0 105,000 105,000 105,000 TOTAL 341,581 347,363 402,831 122,426 406,290 406,290 406,290 I SERVICE INDICATORS: I No of Gopher One calls 2,640 2,800 2,800 2,800 2,800 No of vehicle repairs 102 110 110 110 110 I COST INDICATORS: I Expenditures 341.581 347.363 402,831 122,426 406,290 406,290 406,290 - Program Revenues I ::: Levy Dollars 341,581 347,363 402,831 122,426 406,290 406,290 406,290 I STAFFING: I Full time: City Engineer/Pub Wks Dir 0.10 0.10 0.10 0.10 0.10 I Supervisor of Oper. & Maint 1.00 1.00 1.00 1.00 1.00 1.00 1.00 Lt Equip Oper 1.90 1.90 2.40 2.40 2.40 2.40 2.40 I Clerical 0.25 0.25 0.25 0.25 0.25 0.25 0.25 Engineer Tech .25 .25 .25 I I I 43 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: 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: Includes step increases Supplies/Materials: Rock, gravel & bituminous for street & road repair Support Services: Safety training Contracte~ road striping Transfers: Transfer to Street 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: 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: Includes step increases Supplies/Materials: Sand and salt for ice control I I FUND: 101 DEPARTMENT: Snow & Ice Removal DEPT 43125 BUDGET Actual Actual Budget YTD June Requested Proposed Adopted I ITEM 1999 2000 2001 2001 2002 2002 2002 I Staffing 17,030 . 16,693 30,595 19,702 32,656 32,656 32,656 Supplies/Materials 13,009 15,416 17,500 10,923 17,500 17,500 17,500 I Support Services 0 0 200 0 0 0 0 I Charges & Fees 0 0 200 0 0 0 0 Capital Outlay 0 0 0 0 0 0 0 I Transfers 0 0 0 0 0 0 0 TOTAL 30,O3~ ' 32,110 48,495 30,625 50,156 50,156 50,156 I SERVICE INDICATORS: I Miles of street plowed 49 51 51 51 51 I Tons of salt used 211 250 250 250 250 Tons of sand used 1,135 1,200 1,200 1,200 1,200 I Manhours spent 690 1,000 1,000 1,000 1,000 I No. of cul~de-sacs 88 88 88 88 88 plowed I COST INDICATORS: I Expenditures 39,039 32,110 48,495 30,625 50 I ~ 56 50,156 50,156 - Program Revenues I MN Snow Removal Aid 0 0 0 0 0 0 0 = Levy Dollars 30,039 32,110 48,495 30,625 50,156 50,156 50,156 I I STAFFING: . Full time: I Lt Equip Oper/Foreman .50 .50 .50 .50 .50 .50 .50 I 47 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: Provide for street lighting and traffic signals at intersections and other locations throughout the City for the safety of pedestrians and vehicular traffi c DEPARTMENT: Traffic ControllSt Lights DEPT NO: 43160 DESCRIPTION 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: j-\ I GH LI GHTS/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: 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: 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: Sanitation/Waste Rmv/Weeds 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 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: 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 DEPARTMEN 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 100% 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 DEPARTMENT: Parks & Recreation 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 I I I I I I I I I I I I I I I I I FUND: 101 General DEPT NO: 45200 DESCRIPTION OF ACTIVITY The department is responsible for the maintenance of all City parks, including playgrounds, baUfields, trails, ice rinks, buildings and other play areas. Winter ice skating, and summer recreation programs (administered by Minnetonka Community Schools) are coordinated under this department. OBJECTIVES: _ Continue implementation of the trail planning process: _ Further define potential trail segments by using community outreach and neighborhood meetings. _ Identify and secure funding sources for the Smithtown Road trail segment, as well as future segments. _ Work with South lake Minnetonka communities to secure funding, identify a site, and construct a skate park. o Identify needs and assist the Shorewood Parks Foundation in coordination of fund raising efforts (to replace diminishing park dedication fees). _ Continue promoting the benefits of investing in Shorewood parks, and develop support for funding operation and park improvements HIGHLIGHTS/COMMENTS: Staffing: Includes step increases Part time includes Park Commission Secretarial Seasonal includes Summer employees and Winter Rink Attendants SupplieslMaterials: Small tools Maintenance to park equipment and buildings Rock, black dirt, gravel, sand, fertilizers, seed for parks Support Services: Contracted park & trail planning services Playground and beach scheduling services - Mtka Community Services Contracted weed control in parks Park utility and telephone charges Annual park newsletter Rental of portable toilets Contribution to Senior Recreational Program Services Charges & Fees: Capital Outlay: Transfers: Transfer to Park Capital Improvement Fund 54 I FUND: 101 DEPARTMENT: Parks & Recreation DEPT 45200 I BUDGET Actual Actual Budget YTD June Requested Proposed Adopted ITEM 1999 2000 2001 2001 2002 2002 2002 I Staffing 74,906 98,316 104,494 48,519 119,395 119,395 119,395 supplies/Materials 15,093 8,239 19,500 5,260 19,500 19,500 19,500 Support Services 24,436 28,795 27,750 10,233 33,500 33,500 33,500 I Charges & Fees 0 0 0 0 0 0 0 Capital Outlay 0 542 0 0 375 375 375 I Transfers 0 10,000 10,000 0 35,000 35,000 35,000 TOTAL 114,435 145,891 161,744 64,012 207,770 207,770 207,770 SERVICE INDICATORS: I Acres of maint park 95.80 95.80 95.80 95.80 95.80 95.80 95.80 No. of ballfjelds Softball 3 3 3 3 3 3 I Baseball 5 5 5 5 5 5 No. of shelters 4 4 4 4 4 4 No. of hockey rinks 2 2 2 2 2 2 I No. of skating rinks 3 3 3 4 4 4 Miles of Trails 2.75 2.75 2.75 3 3 3 I Cost of maint per acre 955 1,200 1,221 1,377 1,377 1,377 No. of times rinks are cleaned & resurfaced 80 80 80 80 80 80 I No. of picnic tables 45 45 45 45 45 45 No. of Tennis Courts 4 4 4 4 4 4 I COST INDICATORS: Expenditures 114,435 145,891 161,744 64,012 207,770 207,770 207,770 I - Program Revenues Sports Organizations 7,150 12,000 14,000 14,000 12,000 Tanka Bay - Beach 366 500 500 500 500 Transfer from Trail Fund 0 3,000 0 0 0 I Capital Levy 10,000 10,000 0 0 0 = Levy Dollars - Maint. 96,919 145,891 136,244 64,012 193,270 193,270 195,270 I STAFFING: Full time: Lt Equip Oper/Foreman 1.60 1.60 1.30 1.30 1.30 1.30 1.30 I Clerical .25 .25 .25 .25 .25 .25 .25 Part time: I Clerical Seasonal: I Summer 2.00 2.00 2.00 2.00 2.00 2.00 2.00 Winter (rinks) 10.00 10.00 10.00 10.00 10.00 10.00 10.00 I I 55 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 obligation debt other than debt issued for and serviced primarily by enterprise funds. 57 Moody's Rating Al I I I I I I I I I I I I I I I I I I I CITY OF SHOREWOOD DEBT INFORMATION MOODY'S CREDIT REPORT - OCTOBER 23, 1996 Ten Year Debt Payout 72.6% Debt Burden 3.8% Direct Debt Per Capita $761 Per Capita Income, 1989 $28,584 Per Capita Income, 1989, City as a % of State 198.7% Unemployment Rate, 1996 Hennepin County State of Minnesota 2.9% 3.4% 58 I I I I CITYOF SHOREWOOD SCHEDULE OF BONDS PAYABLE DECEMBER 31,2001 Interest Rates Issue Date Final Maturity Date Authorized and Issued Bonds Total Redeemed 12/31/01 Outstanding (ECIAL ASSESSMENT BONDS G.O. Improvement Bonds, Series 1991A G.O. Improvement Bonds, Selies 1993A I I REVENUE BONDS I G.O. Water Revenue Bonds, Series 1995 G.O. Water Revenue Bonds, Series 1995 I I I I I I I I I I I TOTAL TOTAL TOTAL BONDS PAYABLE 5.10-5.85 3.50-4.45 3.90-5.50 4.00-5.40 11/1/91 12/1/93 11/1/95 11/1/96 59 2/1/02 2/1/04 $960,000 325,000 1,285,000 $865,000 265,000 1,130,000 95,000 60,000 155,000 2/1/11 2/1/12 1,920,000 860,000 2,780,000 640,000 225,000 865,000 1,280,000 635,000 1,915,000 $4,065,000 $1,995,000 $2,070,000 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 ofMSA designated roads. Trail Capital Improvement Fund- This fund was established for the purpose of funding the periodic extension of the City trail system. 61 CAPITAL PLAN I City of Shorewood, Minnesota I PROJECTS BY DEPARTMENT 2002 thru 2006 I Department Project# Priority 2002 2003 2004 2005 2006 Total I Equipment Replacement I Backhoe E-02.22 0 72,781 72,781 Floor Sweeper E-02-46 0 3,791 3,791 F1504x2 Pickup E.02-47 0 25,748 25,748 I F350 Dump E-02-52 0 38,765 38,765 F350 4x4 Pickup w/plow E-02-53 0 30,026 30,026 F350 4x4 Pickup w/plow E.02.55 0 27,263 27,263 I Groundsmaster Mower E-02-57 0 17,131 17,131 Bobcat E-02-63 0 15,781 21,119 36,900 I Roller E.03-32 0 17,519 17,519 F350 & Flatbed E.03-49 0 29,160 29,160 Speed Awareness Display E-04-50 0 17,459 17,459 I Snowmobile E.04-61 0 7,963 7,963 Air Compressor E.Q5-38 0 20,948 20,948 Trailer Mounted Water Pump E.05-51 0 5,779 5,779 I Dump w/Plow and SND E-05-54 0 98,874 98,874 Groundsmaster Mower E.05-67 0 19,661 19,661 Tractor E-06-35 0 30,628 30,628 I Equipment Replacement Total 231,286 46,679 25,422 145,262 51,747 500,396 Local Roadways I Shore Road Reconstruction LR-01-05 0 96,640 96,640 Amlee Road Pavement Reclamation LR-01.Q6 0 41,140 41,140 I Manitou Lane Pavement Reclamation LR.01-07 0 15,100 15,100 Wood Duck Circle Pavement Reclamation LR-01-08 0 9,000 36,100 45,100 I Local Roadways Total 161,880 36,100 197,980 Minnesota State Aid Streets I CR 19 Intersection Realignment MSA-01-02 0 971,600 971,600 TH 7. TH 41 Realignment MSA-01-03 0 2,328,800 2,328,800 I Minnesota State Aid Streets Total 3,300,400 3,300,400 Municipal Water System I SE Area Water Tower - painting W-02.06 0 38,500 38,500 I 64 I I Department Project# Priority 2002 2003 2004 2005 2006 Total Amesbury Piping Project W-02-08 0 25,000 25,000 I Municipal Water System Total 25,000 38,500 63,500 Parks I 5i1verwood Park Resurface Tennis/Basketball Court P-01-06 0 4,000 4,000 Parks Total 4,000 4,000 I Public Facilities/Office Equip City Hall Window Replacement PF-01-05 0 1,500 1,500 3,000 I Computer & network Upgrades PF-01-06 3 10,000 20,000 30,000 Public Facilities/Office Equip Total 11,500 21,500 33,000 I Sanitary Sewer Lift Station Rehabilitations 55-01-04 0 59,950 59,950 59,950 179,850 Infiltration and Inflow Reduction 55-01-05 0 22,000 22,000 22,000 66,000 I Cleaning and televising of the 5anitary Sewer 55-01-06 0 16,000 16,000 16,000 48,000 Sanitary Sewer Total 97,950 97,950 97,950 293,850 I I GRAND TOTAL 3,832,016 202,229 161,872 145,262 51,747 4,393,126 I I I I I I I I I I 65 CAPITAL PLAN I City of Shorewood, Minnesota I PROmCTS BY YEAR 2002 thru 2006 I I Project Name Departmmt Project # Priority Project Value 2002 I Backhoe Equipment Replacement E.02-22 0 72,781 Floor Sweeper Equipment Replacement E-02.46 0 3,791 I F1S0 4x2 Pickup Equipment Replacement E-02-47 0 25,748 F350 Dump Equipment Replacement E-02-S2 0 38,765 F3504x4 Pickup w/plow Equipment Replacement E-02.S3 0 30,026 I F3S0 4x4 Pickup w/plow Equipment Replacement E-02-SS 0 27,263 Groundsmaster Mower Equipment Replacement E-02-S7 0 17,131 Bobcat Equipment Replacement E.02-63 0 15,781 I Shore Road Reconstruction Local Roadways LR-01-0S 0 96,640 Amlee Road Pavement Reclamation Local Roadways LR-01-06 0 41,140 Manitou Lane Pavement Reclamation Local Roadways LR.Q1-07 0 15,100 Wood Duck Circle Pavement Reclamation Local Roadways LR-01-0S 0 9,000 I CR 19 Intersection Realignment Minnesota State Aid Streets MSA-01-02 0 971,600 TH 7 . TH 41 Realignment Minnesota State Aid Streets MSA.Q1.03 0 2,328,800 Amesbury Piping Project Municipal Water System W-02-0S 0 25,000 I Silverwood Park Resurface TennislBasketball Court Parks P-01-06 0 4,000 City Hall Window Replacement Public Facilities/Office Equip PF-01-0S 0 1,500 Computer & network Upgrades Public Facilities/Office Equip PF-01-06 3 10,000 I Lilt Station Rehabilitations Sanitary Sewer S8-01-04 0 59,950 Infiltration and Inflow Reduction Sanitary Sewer 8S-01-0S 0 22,000 Cleaning and televising of the Sanitary Sewer Sanitary Sewer S8-01-06 0 16,000 I Total for 2002 3,832,016 2003 I Roller Equipment Replacement E.03-32 0 17,519 F350 & Flatbed Equipment Replacement E.03.49 0 29,160 Wood Duck Circle Pavement Reclamation Local Roadways LR-01'0S 0 36,100 I City Hall WindOW Replacement Public Facilities/Office Equip PF.01.0S 0 1,500 Computer & network Upgrades Public Facilities/Office Equip PF.01.06 3 20,000 Lilt Station Rehabilitations Sanitary Sewer 8S-01-04 0 59,950 I Infiltration and Inflow Reduction Sanitary Sewer 55-01.05 0 22,000 Cleaning and televising of the Sanitary Sewer Sanitary Sewer SS.01.06 0 16,000 Total for 2003 202,229 I 2004 Speed Awareness Display Equipment Replacement E-D4.50 0 17,459 I Snowmobile Equipment Replacement E.04.61 0 7,963 SE Area Water Tower. painting Municipal Water System W.02-06 0 38,500 I 68 I 1 Project Name Lift Station Rehabilitations Infiltration and Inflow Reduction 1 Cleaning and televising of the Sanitary Sewer 12005 Air Compressor Trailer Mounted Water Pump I Dump wlPlow and SND Groundsmaster Mower 12006 Bobcat I Tractor I GRAND TOTAL I I I I I I I I I I I 1 Department Project # Priority Project Value SS-01-04 0 59,950 SS-01-0S 0 22,000 55-01-0S 0 16,000 Total for 2004 161,872 E.OS.38 0 20,948 E-OS-S1 0 5,779 E-OS-S4 0 9B,874 E-OS-S7 0 19,661 Total for 2005 145,262 E-02-63 0 21,119 E-OS-3S 0 30,628 Total for 200S 51,747 4,393,126 Sanitary Sewer Sanitary Sewer Sanitary Sewer Equipment Replacement Equipment Replacement Equipment Replacement Equipment Replacement Equipment Replacement Equipment Replacement 69 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. Recycling Fund - This fund is used to accotmt for the activities of the City recycling program. Stormwater Management Utility Fund - This fund is used to account for the activitiesofthe 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 three off-sale liquor store sites. A portion of the net income from the operation is used to fund general fund activities. 71 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 SUBFUND: I 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. I I pBJECTIVES: - 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 t-iIGHLlGHTS/COMMENTS: I I 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 I Expenses: I Staffing: .10 Senior Accounting Clerk .30 Ught Equipment Operator .10 Receptionist/Secretary 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 I I I Support Services & Charges: Engineering Contract with Munitech for system maintenance - 5% increase from 2001 Water Operations Licenses & Training Insurance on water s~stem Water testing & Water Quality Reporting Water system analysis. I I I Capital Outlay: Interconnect Woodhaven Well ($118,000 - 2002) Pull & Repair Vertical Turbine Purrip Boulder Bridge ($18,000 - 2002) Radio Read Meter project ($10,000.2002) I 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 72 I 74 I I I I I I I I I I I I I I I I I I I SUBFUND: Water Debt Service MISSION: To provide for the retirement of debt incurred to construct water system improvements. FUND: Water FUND NO: 601 DESCRIE'TION 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 I FUND: #601 FUND: Water - Debt Service DEPT # 49400 I BUDGET Actual Actual Budget YTD Sept Proposed Adopted ITEM 1999 2000 2001 2001 2002 2002 I REVENUE Sp Assess/Connect Chgs 441,982 .216,409 120,000 88,769 110,000 110,000 I Misc. Revenue 51,848 10 0 0 0 0 I Transfers 40,000 40,000 80,000 0 120,000 120,000 TOTAL REVENUE 533,830 256,420 200,000 88,769 230,000 230,000 I EXPENSES Staffing 0 0 0 0 0 0 I Supplies/Materials 0 0 0 0 0 0 Support Services 0 0 0 0 0 0 I Charges & Fees 0 0 0 0 0 0 I Other - Debt Service 297,337 299,424 284,739 236.928 276,415 276,415 Capital Outlay 0 0 0 0 0 0 I Transfers 0 0 0 0 0 0 TOTAL EXPENSES 297,337 299,424 284,739 236,928 276,415 276,415 I SERVICE INDICATORS: I Outstanding Debt. Year End 2,290,000 2,100,000 1,915,000 1,915,000 1,730,000 1,730,000 CASH FLOW IMPACT: I Beginning Cash Balance 504,018 740,511 697,507 697,507 620,118 620,118 .1 Revenues 533,830 256,420 200,000 88,769 230,000 230,000 Expenditures (297,337) (299,424) (284,739) (236,928) (276,415) (276,415) I Ending Cash Balance 740,511 697,507 612,768 549,348 573,703 573,703 I STAFFING: I I I 75 SUB FUND: DEPT NO: Sanitary Sewer MISSION: To provide a safe, sanitary sewer service to all City residents I FUND: Sanitary Sewer 611 I DESCRIPTION OF ACTIVITY: Major activities include maintenance offourteen (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 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 $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 Receptionist/Secretary Supplies/Materials: Office Supplies, Including blUing forms and postage Maintenance contracts for computer hardware and software Support Services: Contract with Munltech for system maintenance Sewer Main Cleaning Inflow & Infiltration Control Insurance on sewer system Legal & engineering services Utilities Travel & seminars I I I I I I I I Charges & Fees: Charges for sewage flow into City of Excelsior trunk mains Metropolitan Council Environmental Services sewage treatment charges I Capital Outlay: Refurbish Shady Island (2001 and 2002) and Birch Bluff (2001) Lift Stations Transfers: General Fund Overhead Costs Interfund Loan - Gideon Glen 2001 I I Depreciation (Non-Cash Expense accounts for future system replacement) I 76 I I FUND: # 611 FUND: Sanitary Sewer DEPT # 49450 I BUDGET Actual Actual Budget YTD Sept Proposed Adopted ITEM 1999 2000 2001 2001 2002 2002 REVENUE I Charges for Service 804,469 860,283 732,200 341,700 706,680 706,680 I Transfers 0 0 25,000 0 28,000 28,000 TOTAL REVENUES 804,469 860,283 757,200 341,700 734,680 734,680 EXPENSES I Staffing 14,076 18,973 22,064 11,754 41,373 41,373 I supplies/Materials 18,423 16,742 17,150 1,620 17,150 17,150 Support Services & Charges 386,869 368,506 490,850 282,107 482,020 482,249 I Capital Outlay 3,960 0 100,000 0 184,500 184,500 Transfers 6,000 651,875 10,000 0 15,000 15,000 I Depreciation 197,794 198,974 200,000 133,880 200,000 200,000 TOTAL EXPENSES 627,122 1,255,070 840,064 429,362 940,043 940,272 I SERVICE INDICATORS: Miles of Sewer Line 57 57 65 65 65 I No. of Connections 2,705 2,705 2,730 2,730 2,730 I No. of Lift Stations 16 16 14 14 14 Sewer Charge 60.00 60.00 60.00 60.00 60.00 I CASH FLOW IMPACT: Beginning Cash Balance 1,577 ,441 2,050,624 1,758,652 1,758,652 1,941 ,548 1,941,548 I Revenues 804,469 860,283 732,200 341,700 706,680 706,680 Expenditures. (627,122) (1,255,070) (840,Oe4) (429,362) (940,043) (940,272) I Depreciation 197,794. 198,974 200,000 133,880 200,000 200,000 Other Cash Flow Impacts 98,042 (96,159) I Ending Cash Balance 2,050,624 1,758,652 1,850,788 1,804,869 1,908,185 1,907,956 STAFFING: I Sr. Acctg. Clerk .10 .10 .10 .10 .10 .10 Lt. Equip. Oper.lForeman .20 .20 .20 .20 .20 .20 I Receptionist/Secreta ry .10 .10 .10 .10 .10 .10 City Engineer .15 .15 Engineer. Technician .25 .25 I I 77 SUBFUND: Recycling MISSION: To provide weekly pickup of recyclables to all City residents; provide for the annual pickup of household and yard wastes I I I I 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. 78 I I I I I I I I I I I I I I I 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 t1IGHLlGHTS/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 I FUND: #621 FUND: Recycling DEPT # 49550 I BUDGET Actual Actual Budget YTD Sept Proposed Adopted ITEM 1999 2000 2001 2001 2002 2002 I REVENUE County Aid 21,860 21,858 22,000 23,728 23,450 23,450 I Charges for Service 67,703 76,864 71,950 49,100 72,950 72,950 I Transfers/other 966 2,346 1,100 578 1,000 1,000 TOTAL REVENUE & 90,529 101,067 95,050 73,407 97,400 97,400 OTHER SOURCES I EXPENSES I Staffing 543 0 1,526 653 1,525 1,525 supplies/Materials 143 1,840 200 626 500 500 I Support Services & Charges 83,629 85,577 95,335 79,830 95,375 95,375 I Capital Outlay 0 0 0 0 0 0 Transfers 0 0 0 0 0 0 I TOTAL EXPENSES 84,315 87,417 97,061 81,108 97,400 97,400 I SERVICE INDICATORS: Avg. mo. Participant Hshlds. 1,300 1,300 1,100 1,100 1,100 I Avg. mo. Tonnage 70 70 72 72 72 I CASH FLOW IMPACT: I Beginning Cash Balance 17,503 26,317 35,975 35,975 35,178 35,178 Revenues 90,529 101,067 95,050 73,407 97,400 97,400 I Expenditures (84,315) (87,417) (97,061 ) (81,108) (97,400) (97,400) I Other Cash Flow Impacts 2,600 (3,992) Ending Cash Balance 26,317 35,975 33,964 28,273 35.178 35,178 I STAFFING: I I 79 SUBFUND: Stormwater Management MISSION: To provide proper surface water and Stormwater Management ground water management throughout the City. I FUND: I FUND NO: 631 I DESCRIPTION OF ACTIVI1Y: 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. ~IGHLlGHTS/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: I .10 Senior Accounting Clerk .10 City Administrator .10 Light Equipment Operator .05 City Engineer I Supplies/Materials: Drainage Correction/Maintenance Materials I Support Services: I Engineering Contractual Services for drainage correction I Capital Outlay: I Gideon Glen Drainage Project I I 80 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. I FUND: Liquor SUB FUND: I I DESCRIF>TION OF ACTIVITY: Provides for the sale of packaged alcoholic beverages to the general public. I OBJECTIVES: I - 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 I I l-lIGHLlGHTSfCOMMENTS: Revenues: Estimated liquor sales: approximately the same as 2001 I Expenses: I Staffing: 1.00 Operations Manager 5.00 Assistant Managers .15 Senior Accounting Clerk 14.00 Part time Sales Clerks I I Supplies/Materials: Office Supplies, Bags, Postage 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 Leasing: Possible down-sizing of Waterford Store has potential of reducing lease expense by est $30,000 annually I I Capital Outlay: Shorewood Plaza Store Improvements ($40,000) Transfers Out: Transfer to General Fund I Misc. Revenue/Expenditures: Interest Income & Service Charges I 82 I I FUND: # 640 SUBFUND: Liquor Operations DEPT # I BUDGET. Actual Actual Budget YTD Aug Proposed Adopted ITEM 1999 2000 2001 2001 2002 2002 I REVENUE Sales 2,320,164 2,532,379 2,863,000 1,703,992 2,692,130 2,692,130 I Cost of Goods 1,837,915 1,888,069 2,204,510 1,110,710 2,034,864 2,034,864 GROSS PROFIT 482,249 644,310 658,490 593,283 657,266 657,266 I EXPENSES Staffing 211,786 259,076 287,230 186,485 302,702 302,702 I Supplies/Materials 12,909 14,854 13~325 9,885 11,325 11,325 I Services & Charges 232,762 251,081 275,535 174,695 255,195 255,195 Depreciation 9,489 6,609 9,490 5,456 6,770 6,770 I Capital Outlay 0 0 50,000 8,992 40,000 40,000 TOTAL EXPENSES 466,946 531,620 635,580 385,512 615,992 615,992 I TOTAL OPERATING INCOME (LOSS) 15,303 112,690 22,910 207,771 41,274 41,274 Transfers In/(Out) 0 (10,000) (10,000) 0 (30,000) (30,000) I Misc. Revenue/(Expense) 14,916 22,195 9,400 (4,876) 10,000 10,000 NET INCOME (LOSS) 30,219 124,885 22,310 202,895 21,274 21,274 I SERVICE INDICATORS: Gross Profit as a % of Sales 20.79% 25.44% 23.00% 34.82% 24.41% 24.41% I Oper. Income as a % of Sales 0.66% 4.45% 0.80% 12.19% 1.53% 1.53% I CASH FLOW IMPACT: Beginning Cash Balance 44,590 190,317 152,510 147,602 195,410 195,410 I Net Operating Income/Loss 8,834 112,690 22,910 207,771 41,274 41,274 Depreciation 9,489 6,609 9,490 5,456 6,770 6,770 . Other Cash Flow Impacts 127,404 (157,106) 10,500 11,180 0 0 I Ending Cash Balance 190,317 152,510 195,410 372,008 238,454 238,454 I STAFFING: Full time: I Operations Manager 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 Sr. Acctg. Clerk .15 .15 .15 .15 .15 .15 I Part time: Sales Clerks 15.00 15.00 15.00 15.00 15.00 15.00 I 83 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. I I I I Provides for the sale of packaged alcoholic beverages to the general public. OBJECTIVES: I I I I - 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 I I I I I I I I I I 84 I I FUND: # 641 SUB FUND: Liquor - Shorewood Plaza DEPT # I BUDGET Actual Actual Budget YTD Aug Proposed Adopted ITEM 1999 2000 2001 2001 2002 2002 I REVENUE Sales 978,818 1,093,956 1,210,000 701,703 1,115,500 1,115,500 I Cost of Goods 792,228 810,884 931,700 436,048 836,625 836,625 GROSS PROFIT 186,590 283,072 278,300 265,655 278,875 278,875 I EXPENSES Staffing 75,238 101,236 103,821 69,116 116,819 116,819 I Supplies/Materials 7,149 6,127 6,275 3,496 4,975 4,975 I Services & Charges 76,905 90,187 95,250 62,240 96,395 96,395 Depreciation 1,365 244 1,365 280 420 420 I Capital Outlay 0 0 50,000 8,992 40,000 40,000 TOTAL EXPENSES 167,126 197,794 256,711 144,124 258,609 258,609 I NET OPERATING INCOME (LOS 19,464 85,278 21,589 121,531 20,266 20,266 Transfers In/(Out) 0 (5,000) (10,000) 0 (15,000) (15,000) I Misc. Revenue/(Expense) 9,285 14,813 5,000 (726) 10,000 10,000 NET INCOME (LOSS) 28,749 95,091 16,589 120,804 15,266 15,266 I BUSINESS INDICATORS: Gross Profit as a % of Sales 19.06% 25.88% 23.00% 37.86% 25.00% 25.00% I Oper. Income as a % of Sales 1.99% 7.80% 1.78% 17.32% 1.82% 1.82% CASH FLOW IMPACT: I Beginning Cash Balance 132,349 229,346 245,354 245,354 272,808 272,808 Net Operating Income/(Loss) 19,464 85,278 21,589 121.531 20,266 20,266 . I . Depreciation 1,365 . 244 1,365 280 420 420 Other Cash Flow Impacts 76,168 (69,514) .4,500 4,500 (5,000) Ending Cash Balance 229,346 245,354 272,808 371.665 288,494 293,494 I STAFFING: I Full time: Operations Manager .33 .33 .33 .33 .33 .33 I Assistant Manager 1.00 1.00 1.00 1.00 2.20 2.20 Sr. Acct9. Clerk .05 .05 .05 .05 .05 .05 I Part time: Sales Clerks 6.00 5.00 5.00 5.00 5.00 5.00 I 85 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. I I FUND: Liquor SUB FUND: Waterford - Effectively control the sale of packaged alcoholic beverages in the City - Decrease operating loses through the reduction of leased floor space I I I I I I DESCRIPTION OF ACTIVITY: Provides for the sale of packaged alcoholic beverages to the general public. OBJECTIVES: !.HGHLlGHTS/COMMENTS' Revenues: Estimated liquor sales .33 Operations Manager 1.40 Assistant Manager .05 Senior Accounting Clerk 5.00 Part time Sales Clerks I I I I Expenses: Staffing: Supplies/Materials: Office Supplies, Postage, Equipment Repair, Bags I I 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 I I I Capital Outlay: 86 I I Misc. Revenue/Expenditures: Interest Income & Service Charges I FUND: # 642 SUBFUND: Liquor - Waterford DEPT # I BUDGET Actual Actual Budget YTD Aug Proposed Adopted ITEM 1999 2000 2001 2001 2002 2002 I REVENUE Sales 703,264 710,433 833,500 495,378 783,180 783,180 I Cost of Goods 530,085 539,260 641,795 337,641 595,217 595,217 GROSS PROFIT 173,179 171,173 191,705 157.737 187,963 187,963 I EXPENSES Staffing 63,699 72,186 88,209 51,506 89,069 89,069 I Supplies/Materials 3,212 4,020 4,725 3,411 3,425 3,425 I Support Services 113,357 111,497 125,650 81,656 88,255 88,255 Depreciation 7,874 5,816 7,875 3,816 5,800 5,800 I Capital Outlay TOTAL EXPENSES 188,142 193,519 226,459 140,389 186,549 186,549 I TOTAL OPERATING INCOME (LOSS (14,963) (22,346) (34,754) 17,348 1,414 1,414 Transfers In/(Out) 0 0 0 0 0 0 I Misc. Revenue/(Expense) 908 (911 ) 0 (3,458) 0 0 NET INCOME (LOSS) (14,055) (23,257) (34,754) 13,890 1,414 1,414 I BUSINESS INDICATORS: Gross Profit as a % of Sates 24.63% 24.09% 23.00% 31.84% 24.00% 24.00% I Oper. Income as a % of Sales (2.13%) (3.15%) (4.17%) 3.50% 0.18% 0.18% CASH FLOW IMPACT: I Beginning Cash Balance (166,804) (149,719) (208,442) (20aA42) (232,321 ) (232,321 ) Net Operating Income/(Loss) (14,963) (22,346) (34,754) 17 ,348 1,414 1,414 I Depreciation 7,874 5,816 7,875 3,816 5,800 5,800 Other Cash Flow Impacts 24,174 (42,193) 3,000 3,000 I Ending Cash Balance (149,719) (208,442) (232,321 ) (184,278) (225,107) (225,107) STAFFING: I Full time: I Operations Manager .33 .33 .33 .33 .33 0.33 Assistant Manager 1.00 1.00 1.00 1.00 1.40 1.40 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 87 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. I I FUND: Liquor SUBFUND: Tonka Bay Provides for the sale of packaged alcoholic beverages to the general public. This location was acquired in December, 1994. I I DESCRIPTION OF ACTIVITY: _ 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 I I OBJECTIVES' HIGHLIGHTS/COMMENTS: Revenues: Estimated liquor sales I Office Supplies, Postage. Equipment Repair, Bags I I I I I Expenses: Staffing: .33 Operations Manager 1.40 Assistant Manager .05 Senior Accounting Clerk 4.00 Part time Sales Clerks Supplies/Materials: 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 I Capital Outlay: Misc. Revenue/Expenditures: Interest Income & Service Charges I 88 I I FUND: # 643 SUBFUND: Liquor - Tonka Bay DEPT # I BUDGET Actual Actual Budget YTD Aug Proposed Adopted ITEM 1999 2000 2001 2001 2002 2002 I REVENUE Sales 638,082 727,990 819,500 506,912 793,450 793,450 I Cost of Goods 515,602 537,925 631,015 337,021 603,022 603,022 GROSS PROFIT 122,480 190,065 188,485 169,890 190,428 190,428 I EXPENSES I Staffing 72,849 85,655 95,200 65,862 96,814 96,814 Supplies/Materials 2,548 4,707 2,325 2,978 2,925 .2,925 I Support Services 42,500 49,397 54,635 30,798 70,545 70,545 I Depreciation 250 549 250 1,360 550 550 Capital Outlay 0 0 0 0 0 0 I TOTAL EXPENSES 118,147 140,307 152,410 100,998 170,834 170,834 TOTAL OPERATING INCOME 4,333 49,758 36,075 68,892 19,594 19,594 I Transfers In/(Out) 0 (5,000) 0 0 (15,000) (15,000) Misc. Revenue/(Expense) 4,723 8,293 4,400 (691 ) 0 0 NET INCOME/(LOSS) 9,056 53,051 40,475 68,201 4,594 4,594 I BUSINESS INDICATORS: I Gross Profit as a % of Sales 19.20% 26.11 % 23.00% 33.51% 24.00% 24.00% Oper. Income as a % of Sales 0.68% 6.83% 4.40% 13.59% 2.47% 2.47% I CASH FLOW IMPACT: Beginning Cash Balance 79,045 110,690 115,598 110.690 154,923 154,923 I Net Operating Income/(Loss) 4,333 49,758 36,075 68.892 19,594 19,594 Depreciation 250 549 .250 1,360 550 550 Other Cash Flow Impacts 27,062 (45,399) 3,000 3,680 0 0 I Ending Cash Balance 110,690 115,598 154,923 184,622 175,067 175.067 I STAFFING: Full time: I Operations Manager .33 .33 .33 .33 .33 .33 Assistant Manager 1.00 1.00 1.00 1.00 1.40 1.40 Senior Acct. Clerk .05 .05 .05 .05 .05 .05 I Part time: Sales Clerks 4.00 4.00 4.00 4.00 4.00 4.00 I 89 I I I I ALLOCATED APPROPRIATION BOND ISSUE . . I I I I I I I I I I I I I I BOND REFERENDUM BUDGET CAPITAL ASSET CAPITAL OUTLAY CAPITAL PROJECTS FUND COMMUNITY DEVELOPMENT BLOCK GRANT (CDBG) COMPARABLE WORTH . CONTRACTUAL COMPREHENSIVE PLAN DEBT LEVY DEBT SERVICE FUND GLOSSARY Distribute costs betwee.n reporting divisions or funds. A grant of money by a legislative body to carry out 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 which enhance the community. The City participates in a joint program which is administered by Hennepin County. The City designates uses for each year's allocation, which is then administered by the County. 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 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. 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. 91 ENTERPRISE FUND EXPENDITURE FISCAL DISPARITIES FUND FUND BALANCE FUND EQUITY GENERAL FUND GOAL GOPHER ONE-CALL GRANT HOMESTEAD AND AGRICULTURE CREDIT AID (HACA) ISTEA GRANT JOINT POWERS AGREEMENT LEVY LIMITS Established to accOlmt for operations that are financed and prorated 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. I I I I I I I I I I I I I I I I I I I A metropolitan program that distributes 40% 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 which are segregated for the purpose of carrying on specific activities or attaining certain objectives. The residual balance resulted from all fiscal activity within a fund which is available for appropriation. The residual balance, reserved and unreserved, resulted from all fiscal activity within a fund. 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 program that provides assistance by utility companies to contractors/homeowners to located underground utilities to avoid damaging buried electrical, gas, telephone, cable television, water and sanitary sewer systems. A contribution or gift of cash or other assets from another government to be used or expended for a specified purpose, . activity or facility. The State of Minnesota distributes revenue to communities as a result of state reductions in property taxes collected to keep property taxes at a reasonable level. lntermodal Surface Transportation Efficiency Act -- a federal grant for building infrastructure, and enhancements such as scenic, historic and environmental aspects of the intermodal transportation system. A contract between two or more government jurisdictions to provide a common service. Statutory limit on amount of property taxes which may be levied. 92 I I I I I I I I I I I I I I I I I I I MUNICIPAL ST ATE AID PROGRAM (MSA) MUNICIPAL STATE AID STREETS (MSA) OBJECTIVE ORDINANCE SPECIAL ASSESSMENT TAX INCREMENT TAX LEVY TAXING JURISDICTION TRANSFERS TRUTH-IN- TAXATION ZONING A State of Minnesota program which provides for the distribution of highway user funds to qualifying cities over a population of 5,000. Fund are appropriated annually for the construction and maintenance of city designated 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 oriented accomplishments which can be measured and achieved within a given time period. A municipal law. A cost paid by landowners for specific improvements to adjoining property which adds at least as much value 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 enacted in 1989 that provides citizens with notification of proposed property tax changes and requires a public hearing notice be published in a quarter page newspaper ad. 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 DETAILED BUDGETS 95 FUND: 101 ACTIVITY: Mayor and Council DEPT 41110 I Obj Actual Actual Budget YTD June Requested Proposed Adopted Cod ITEM 1999 2000 2001 2001 2002 2002 2002 PERSONAL SERVICES I 101 Regular Salaries 102 O.T. Salaries 103 Part Time Salaries 12,600 12,600 12,600 6,300 12,600 12,600 12,600 I 121 PERA City Share 122 FICA City Share 964 964 964 482 964 964 964 131 Ins. City Share I 141 MN Unemp Comp 151 Workers Camp Total 13,564 13,564 13,564 6,782 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 1,906 684 1,500 387 1,500 1,500 1,500 I Total 1,906 684 1,500 387 1,500 1,500 1,500 OTHER SERVICES 301 Financial I 302 Consulting 303 Engineering 304 Legal I 321 Communication 331 Travel, Conf,Sch 3,004 3,911 3,000 126 3,000 3,000 3,000 351 Print/Publish 8,936 8,239 9,000 4,824 19,000 19,000 19,000 I 360 Ins. -Total 380 Utilities- Gas.lElec. 400 Contractual 11,723 1,627 9,750 15,000 15,000 15,000 I 410 Rental 125 433 Dues & Subscription 24,564 29,026 28,700 18,039 38,750 38,750 38,750 437 Licenses-Taxes I 440 Contingency 500 9,020 30,000 5,692 30,000 30,000 30,000 Total 48,852 51,823 80,450 28,681 105,750 105,750 105,750 OTHER CHARGES I 54 State Surchgs 55 Interest- Interfund Loan I 56 Allocated Expense from other Depts Total 0 0 0 0 0 0 0 CAPITAL OUTLAY I 510 Land 520 Buildings 540 Machinery-Equip I 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 64,322 66,070 95,514 35,850 120,814 120,814 120,814 96 I I I BUDGET COMMENTS: MAYOR AND COUNCIL DEPT 41110 Code # I I 103 Council Salaries in 2002: 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 I 351 Newsletters & Council Info Broc Visioning Project-Print/publ 9,000 10,000 I 400 Christmas Lake Milfoillnspection (2) Visioning Consultant 15,000 I I 433 Subscriptions & Memberships Lake Minnetonka Conservation District (LMCD) - 26,317 + 3300 Water Patrol Assn of Metro Municipalities - 2,362 League of MN Cities - 5,266 Excelsior Chamber of Commerce July 4th Fireworks -1,500 I 440 Contingency I I I I I I 97 FUND: 101 General ACTIVITY: Administration OEPT 41300 I Obj Actual Actual Budget YTO June Annual Requested Proposed Adopted Code ITEM 1999 2000 2001 2001 EST-OO 2002 2002 2002 I PERSONAL SERVICES 101 Regular Salaries 88,468 87,608 78,759 33,465 75,530 75,530 75,530 102 OT. Salaries I 103 Part Time Salaries 121 PERA City Share 3,974 4.458 4,080 1,733 4,177 4,177 4,177 122 FICA City Share 6,894 6,722 6,025 2,560 5,778 5,778 5,778 I 131 Ins. City Share 7,067 5,230 10,909 2,312 12,655 12,655 12,655 141 MN Unemp Comp 151 Workers Comp Total 106,403 104,017 99,773 40,071 0 98,140 98,140 98,140 I SUPPLIES 200 Office Supplies I 212 Motor Fuel & Lube 221 Maint-Equipment 223 Maint-Buildings 240 Small Tools I 245 General Supplies 375 0 400 47 400 400 400 Total 375 0 400 47 0 400 400 400 OTHER SERVICES I 301 Auditing/Accounting 302 Consulting 303 Engineering I 304 Legal 321 Communication 331 Travel, Conf,Sch 2,580 1,145 2,800 1,985 4,500 4,500 4,500 I 351 Print/Publish 360 Ins.- Total 380 Utilities- Gas.lElec. I 400 Contractual 2,590 28,960 3,000 2,800 2,800 2,800 410 Rental 433 Dues & Subscriptio 917 30 1,050 5,717 1,100 1,100 1,100 I 437 Licenses-Taxes 440 Misc. Services Total 6,087 30,134 6,850 7,702 0 8,400 8,400 8,400 OTHER CHARGES I 54 State Surchgs 55 Interest- Interfund Loan I 56 Allocated Expense from other Oepts Total 0 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 I Total 0 0 0 324 0 0 0 0 TRANSFERS 720 Permanent I Total 0 0 0 0 0 0 0 0 TOTAL ACCOUNT 112,865 134,151 107,023 48,144 0 106,940 106,940 106,940 I 98 I I I I I I I I I I I I I I I I I I I BUDGET COMMENTS: ADMINISTRATION DEPT 41300 Code # 101 90% Administrator's Salary 1/3 Executive Secretary/Deputy Clerk 245 Books & Misc Supplies 331 MCMA, LMC, ICMA & Rotary Conferences, Education & Mileage 2,800 ICMA-Philadelphia 1800; MCMA-Brainerd 500; LMC-St. Cloud 600; MAMA-100; Mileage& Exp-1500 400 Labor Relations Associates 2,650 433 Subscriptions & Memberships ICMA 625 MCMA 75 MAMA 25 Excelsior Rotary 300 99 FUND: 101 General ACTIVITY: City Clerk OEPT 41400 I Obj Actual Actual Budget YTD June Annual Requested Proposed Adopted Code ITEM 1999 2000 2001 2001 EST-OO 2002 2002 2002 PERSONAL SERVICES I 101 Regular Salaries 66,234 86,602 57,105 37,831 37,831 60,745 60,745 60,745 102 O.T. Salaries 37 9,200 0 0 15,564 15,564 15,564 103 Part Time Salaries 14,746 9,764 13,060 5,267 5,267 10,865 10,865 10,865 I 121 PERA City Share 4,248 5,058 3,324 2,232 2,232 3,888 3,888 3,888 122 FICA City Share 6,108 8,028 5,368 3,297 3,297 6,669 6,669 6,669 131 Ins. City Share 6,497 8,843 7,262 4,348 4,348 10,178 10,178 10,178 I 141 MN Unemp Comp 151 Workers Comp Total 97,870 127,494 86,119 52,976 52,976 107,909 107,909 107,909 SUPPLIES I 200 Office Supplies 7,690 13,558 9,000 5,447 5,447 11,000 11,000 11,000 208 Postage 4,267 4,508 6,500 2,250 2,250 14,000 14,000 14,000 212 Motor Fuel & Lube I 221 Maint-Equipment 1,250 1,375 1,375 1,375 223 Maint-Buildings 240 Small Tools 250 245 General Supplies 643 1,735 1,600 426 426 2,100 2,100 2,100 I Total 12,600 19,801 18,600 8,123 8,123 28,475 28,475 28,475 OTHER SERVICES 301 Audit/Accounting I 302 Consulting 1,500 14,000 14,000 14,000 303 Engineering 304 Legal 321 Communication I 331 Travel, Conf,Sch 2,515 2,467 2,830 1,313 1,313 2,950 2,950 2,950 351 Print/Publish 6,634 10,405 6,500 2,319 2,319 6,500 6,500 6,500 360 Ins.-Total I 380 Utilities- Gas.lElec. 400 Contractual 6,567 16,166 9,360 2,146 2,146 4,536 4,536 4,536 410 Rental I 433 Dues & Subscriptio 240 320 200 240 240 250 250 250 437 Licenses-Taxes 80 440 Misc. Services 54 Total 16,036 29,412 20,390 6,018 6,018 28,236 28,236 28,236 I 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 0 CAPITAL OUTLAY 60 Land I 520 Buildings 540 Machinery-Equip 2,380 2,380 0 0 0 560 Fum & Fixtures 692 274 274 4,025 4,025 4,025 580 Other Improve 500 1,300 1,300 1,300 I Total 0 692 500 2,653 2,653 5,325 5,325 5,325 TRANSFERS 720 Permanent I 71 Temporary 72 Refund-Reimburse. Total 0 0 0 0 0 0 0 0 I TOTAL ACCOUNT 126,506 182,458 125,609 69,771 69,771 169,945 169,945 169,945 100 I I BUDGET COMMENTS: CITY CLERK I DEPT 41400 Code # I 101 2/3 Executive Secretary/Deputy Clerk 70% Parks Secretary I 25% Secr/Recp 103 Part-time Comm Tech (15 hrs/wk x 52 wks x $14.23) 15,564 Election Clerks 10,865 I I 200 Office supplies, computer paper & copier supplies 11,000 I 208 Postage & postage permits (Regular-5000; Newsletter- 14,000 221 Computer printer contracts 750 I Elec Equip 625 302 Computer/Network Maint Consult 4,000 I Recodification 10,000 245 General Supplies 250 LMC Directory - 9 copies 350 I Truth in Taxation Notices 600 Voters Registrations 200 2,100 Redistricting (mailings/mapsl1egals) 700 I 331 Travel, Conferences & Schools: State Clerks Conferencellnst - Jean 750 I Misc. Seminars, Mileage & MCFOA Mtgs 1,200 Computer Training 1,000 2,950 351 Legal Notices - All General Fund I except Capital Projects Planning Commission I Park Comm (See planning & park dept buds) I 400 Council Recording Secretary 4,536 ($120 x 3 mtgs x 12 mas) I 433 MCFOA Dues 50 IIMC - MN Clerk Assn. 130 Subscriptions 70 I 540 Capital Equip 4,025 Fireproof File-1200; 3-17" Monitors 750; SW Upgrades-100; Scanner-200; Digital Camera-475 Office Chair-400 4,025 I 580 Voting Booths (6 @ 215) 1,300 I I 101 FUND: 101 General ACTIVITY: Finance DEPT 41500 I Obj Actual Actual Budget YTD June Requested Proposed Adopted Cod ITEM 1999 2000 2001 2001 2002 2002 2002 PERSONAL SERVICES I 101 Regular Salaries 86,210 79,195 80,460 38,718 86,300 86,300 86,300 102 O.T. Salaries I 103 Part Time Salaries 121 PERA City Share 4,466 3,862 4,168 2,006 4,772 4,772 4,772 122 FICA City Share 5,896 5,677 6,155 2,909 6,602 6,602 6,602 131 Ins. City Share 6,624 7,043 10,593 4,268 14,460 14,460 14,460 I 141 MN Unemp Comp 151 Workers Comp Total 103,196 95,777 101,376 47,901 112,134 112,134 112,134 SUPPLIES I 200 Office Supplies 173 548 750 466 800 800 . 800 212 Motor Fuel & Lube I 221 Maint-Equipment 2,541 2,319 2,500 12,500 12,500 12,500 223 Maint-Buildings 240 Small Tools 245 General Supplies 98 1,186 200 36 200 200 200 I Total 2,812 4,053 3,450 503 13,500 13,500 13,500 OTHER SERVICES 301 Audit/Accounting 900 0 5,100 0 0 0 I 302 Consulting 303 Engineering 304 . Legal I 321 Communication 331 Travel, Conf,Sch 4,951 5,650 2,525 5,900 5,900 5,900 351 Print/Publish 1,289 712 1,300 257 1,300 1,300 1,300 360 Ins-Unallocated L TD 4,600 261 500 500 500 I 380 Utilities- Gas./Elec. 400 Contractual 1,575 410 Rental I 433 Dues & Subscriptio 780 257 800 629 1,000 1,000 1,000 437 Licenses-Taxes 440 Misc. Services I 450 Service Chgs. 944 729 1,200 309 1,500 1,500 1,500 Total 8,864 3,274 13,550 9,080 10,200 10,200 10,200 OTHER CHARGES 54 State Surchgs I 55 Interest- Interfund Loan 56 Allocated Expense I from other Depts Total 0 0 0 0 0 0 0 CAPITAL OUTLAY I 60 Land 520 Buildings 540 Machinery-Equip 2,000 2,000 2,000 I 560 Furn & Fixtures 580 Other Improve Total 0 0 0 0 2,000 2,000 2,000 TRANSFERS I 720 Permanent 71 Temporary I 72 Refund-Rei mburse. Total 0 0 0 0 0 0 0 TOTAL ACCOUNT 114,872 103,103 118,376 57,485 137,834 137,834 137,834 I 102 I I BUDGET COMMENTS: FINANCE DEPT 41500 Code # I 101 100% Finance Director 60% Senior Accounting Clerk I I I 200 Computer Checks, Budget Supplies, etc I 221 Finance software support & enhancements Fund accounting, Payroll, Util Bill Software 2,500 10,000 I 245 Books & Publications I I I I 331 Travel, Conferences & Schools: GFOA Local 300 GFOA State 500 Mileage 500 Educational - Tuition Reimbusement 2,800 Nat'l. GFOA Conference 1,800 351 Publish financial statements and budget 360 Unallocated Insurance Expense for L TO benefit 4,600 433 GFOA - State and National 165 Public Investor, Governing, Other 135 Submittal fee. GFOA Cert. of Excellence 350 Submittal fee - GFOA Distinguished Budget Award 150 450 Bank & Broker Servce Charges 540 Computer Replacement (Fin Dir) 2,000 I I I I I I I 103 I I BUDGET COMMENTS: PROFESSIONAL SERVICES DEPT 41600 Code # I I I I I 200 Assessor Supplies I I 301 Audit - General ($10,000 est. x 80%) I 304 Legal: Monthly Retainer $1,750 x 12 = Prosecutions Generallegal/Mediation Services Litigation I I I 400 Assessor Services I 440 Misc Services Opt out Transit Consultant I I I I I 105 21,000 19,000 35,000 25,000 100,000 15,000 FUND: 101 General ACTIVITY: Planning & Zoning DEPT 41910 I Obj Actual Actual Budget YTD June Requested Proposed Adopted Cod ITEM 1999 2000 2001 2001 2002 2002 .2002 PERSONAL SERVICES I 101 Regular Salaries 83,884 59,364 89,886 29,428 65,047 65,047 65,047 102 O.T. Salaries 103 Part Time Salaries 165 4,402 5,000 13,067 30,260 30,260 30,260 I 121 PERA City Share 4,369 3,160 4,656 2,201 5,270 5,270 5,270 122 FICA City Share 5,628 4,454 7,259 3,146 7,291 7,291 7,291 131 Ins. City Share 6,422 6,287 11,834 3,620 10,899 10,899 10,899 I 141 MN Unemp Camp 151 Workers Camp Total 100,468 77,668 118,635 51,462 118,767 118,767 118,767 I SUPPLIES 200 Office Supplies 212 Motor Fuel & Lube I 221 Maint-Equipment 223 Maint-Buildings 240 Small Tools 245 General Supplies 357 357 400 900 900 900 I Total 357 357 400 0 900 900 900 OTHER SERVICES 301 AudiVAccounting I 302 Consulting 303 Engineering 304 Legal I 321 Communication 762 1,252 850 639 900 900 900 331 Travel, Conf,Sch 1,710 996 2,500 3,627 6,300 6,300 6,300 351 PrinVPublish 1,076 346 750 786 900 900 900 360 Ins.-Total I 380 Utilities- Gas.lElec. 400 Contractual 5,556 7,287 5,200 6,238 5,000 5,000 5,000 I 410 Rental 433 Dues & Subscriptio 304 459 500 39 650 650 650 437 Licenses-Taxes 440 Misc. Services 8,050 2,585 4,000 4,000 4,000 I Total 9,408 10,340 17,850 13,914 17,750 17,750 17,750 OTHER CHARGES 54 State Surchgs I 55 Interest- Interfund Loan 56 Allocated Expense I . from other Depts Total 0 0 0 0 0 0 0 CAPITAL OUTLAY I 60 Land 520 Buildings 540 Machinery-Equip 1,100 700 700 700 I 560 Furn & Fixtures 482 580 Other Improve 236 Total 236 0 1,100 482 700 700 700 TRANSFERS I 720 Permanent 2,500 71 Temporary 72 Refund-Reimburse. I Total 0 0 2,500 0 0 0 0 TOTAL ACCOUNT 110,469 88,364 140,485 65,858 138,117 138,117 138,117 I 106 I BUDGET COMMENTS: PLANNING & ZONING I DEPT 41910 I Code # 101 95% of salary cost for Planning Director 70% Planning Assistant I 103 I I I 245 General Supplies: Books 100 I Graphics materials 100 Franklin Planner Supplies Planning Software 700 I 321 Air Time - Cellular Phone 331 Travel, Conferences & Schools: I Computer Training 550 Misc. Conferences/Seminars 400 Mileage 750 Sensible Land Use Coalition Meetings 400 I GTS Training Session - 4 P.C. Members 2,000 Education 200 Nat. Conf 2,000 I 351 Print/Publish: Comprehensive Plan brochure 900 400 Planning Commission Recording Secretary I ($150 x 20 mtgs) 5.000 433 Subscriptions & Memberships: I APA 150 MN APA (3) 125 APA Journal 50 I Zoning News (4) 125 Sensible Land Use Coalition 100 Misc 100 I 440 Land Conservation/Environment Committee 4.000 540 CD-RW drive; Battery charger, Cell phone 700 I I I 107 FUND: 101 General ACTIVITY: Municipal Bldg City Hall DEPT 41940 I Obj Actual Actual Budget Requested Proposed Adopted Cod ITEM 1999 2000 2001 2002 2002 2002 PERSONAL SERVICES I 101 Regular Salaries 102 O.T. Salaries 103 Part Time Salaries I 121 PERA City Share 122 FICA City Share 131 Ins. City Share I 141 MN Unemp Comp 151 Workers Comp Total 0 0 0 0 0 0 SUPPLIES I 200 Office Supplies 212 Motor Fuel & Lube 221 Maint-Equipment 3,555 3,306 4,350 4,110 4,110 4,110 I 223 Maint-Buildings 2,945 958 1,500 2,000 2,000 2,000 240 Small Tools 245 General Supplies 3,571 3,162 4,320 3,475 3,475 3.475 Total 10,071 7,426 10,170 9,585 9,585 9,585 I OTHER SERVICES 301 Audit/Accounting 302 Consulting 2,500 2,500 2,500 I 303 Engineering 304 Legal 321 Communication 8,173 6,931 7,500 7,500 7,500 7,500 331 Travel, Conf,Sch 1,200 1,200 1,200 I 351 Print/Publish 360 Ins.-Total 66,880 56,531 60,000 65,000 65,000 65,000 380 Utilities- I Gas.lElec. 5,649 14,301 6,000 11,000 11,000 11,000 400 Contractual 4,255 4,365 4,850 4,850 4,850 4,850 410 Rental 1,158 956 1,000 1,500 1,500 1,500 433 Subscrip-Member I 437 Licenses-Taxes 3,837 3,135 3,500 3,500 3,500 3,500 440 Misc. Services 10 Total 89,952 86,229 82,850 97,050 97,050 97,050 I OTHER CHARGES 54 State Surchgs 55 I nterest- Interfund Loan I 56 Allocated Expense from other Depts Total 0 0 0 0 0 0 I CAPITAL OUTLAY 60 Land 520 Buildings 37,544 37,544 37,550 37,550 37,550 37,550 I 540 Machinery-Equip 360 5,000 5,000 5,000 560 Furn & Fixtures 540 4,136 1 ,450 400 400 400 580 Other Improve 1,500 1,500 1,500 Total 38,084 42,040 39,000 42,950 42,950 42,950 I TRANSFERS 720 Permanent 25,000 15,000 25,000 35,000 35,000 35,000 71 Temporary I 72 Refund-Reimburse. Total 25,000 15,000 25,000 35,000 35,000 35,000 TOTAL ACCOUN 163,107 150,695 157,020 184,585 184,585 184,585 I 108 I I I BUDGET COMMENTS: MUNICIPAL BLDG. CITY HALL DEPT 41940 Code # I I I I 221 Maintenance Contracts: Copiers (1) - (Hitachi 1800) Duplicator (Priport) Other - Folding Machine Back-up Copier I I 223 Bldg. Maint., recharge fire extinguisers, painting, etc. I 245 Cleaning supplies, ice control for sidewalks, Coffee supplies, pop purchases, paper supplies Software Upgrades (Pagemaker, Photoshop, Mise) Property Tax Info Upgrades from County I 302 Web Page -Search Option conversion & Hosting I 321 City Hall telephone expense 331 Web Page Training (2 @ 600) 360 Insurance package - Including Worker's Compensation (All Dept's) I 380 Electric and Gas utility & refuse hauling I 400 Janitorial, pest control & rugs Internet Access Charges 410 Rental on Postage Meter & Pop Machine I 437 Special Assessments - City owned property (includes misc. County charges) State Sales & Use Tax I 520 Payment on Senior Community Center I 540 Network System Replacement 560 Office Chair (400) 580 Window Replacement 720 Transferto Public Facilities Fund I I I 109 FUND: 101 General ACTIVITY: Police OEPT 42100 I Obj Actual Actual Budget YTO June Requested Proposed Adopted Cod ITEM 1999 2000 2001 2001 2002 2002 2002 I PERSONAL SERVICES 101 Regular Salaries 102 O.T. Salaries I 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 58 I 221 Maint-Equipment 343 223 Maint-Buildings 240 Small Tools I 245 General Supplies Total 401 0 0 0 0 0 0 OTHER SERVICES I 301 Audit/Accounting 302 Consulting 303 Engineering 304 Legal I 321 Communication 331 Travel, Conf,Sch 351 Print/Publish I 360 Ins.- Total 380 Utilities- Gas.lElec. 35 50 16 400 Contractual 539,920 530,475 569,832 314,319 607,443 607,443 607,443 I 410 Rental 433 Subscrip-Member 437 Licenses-Taxes I 440 Misc. Services 6,979 19,336 8,000 3,820 8,000. 8,000 8,000 Total 546,934 549,811 577,882 318,155 615,443 615,443 615,443 OTHER CHARGES I 54 State Surchgs 55 Interest- Interfund Loan I 56 Allocated Expense from other Oepts Total 0 0 0 0 0 0 0 CAPITAL OUTLAY I 60 Land 520 Buildings 540 Machinery-Equip I 560 Furn & Fixtures 580 Other Improve Total 0 0 0 0 0 0 0 I TRANSFERS 720 Permanent 800 800 800 0 800 800 800 71 Temporary I 72 Refund-Reimburse. Total 800 800 800 0 800 800 800 TOTAl Ar.r.OIINT 54A. 1 :\5 550.082 578.682 318.155 616.243 616.243 616.243 I 110 I I BUDGET COMMENTS: POLICE DEPT 42100 I Code # I I I I 212 Gas/Oil for Snowmobile Patrol I 221 Maintenance of Snowmobile I 245 Mailings to Snowmobile owners Signs for trails I I I 400 Police Contract (2002) (11.2% Increase) Traffic Patrol Officer Targeted Traffic Enforcement 598,943 o 8,500 I 380 Electricity for Civil Defense Sirens I 440 Court Officer Expense Prisoner Expense Annual Auxiliary Police Dinner 3,000 4,550 450 8,000 I I 720 Transfer to Equipment Replacement Fund for Snowmobile Replacement I I I 111 FUND: 101 General ACTIVITY: Fire Protection DEPT 42200 I Obj Actual Actual Budget YTD June Requested Proposed Adopted Cod ITEM 1999 2000 2001 2001 2002 2002 2002 I PERSONAL SERVICES 101 Regular Salaries 102 O.T. Salaries I 103 Part Time Salaries 121 PERA City Share 122 FICA City Share 131 Ins. City Share I 141 MN Unemp Comp 151 Workers Comp Total 0 0 0 0 0 0 0 SUPPLIES I 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 I 302 Consulting 303 Engineering 304 Legal I 321 Communication 331 Travel, Conf,Sch 351 Print/Publish 360 Ins.-Total I 380 Utilities- Gas.lElec. 400 Contractual 166,355 191,175 235,954 126,219 293,803 293,803 293,803 410 Rental I 433 Dues & Subscriptions 437 Licenses-Taxes 440 Misc. Services 1,697 1,697 1,697 I Total 166,355 191,175 235,954 126,219 295,500 295,500 295,500 OTHER CHARGES 54 State Surchgs I 55 I nterest- 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 Furn & Fixtures I 580 Other Improve Total 0 0 0 0 0 0 0 TRANSFERS I 720 Permanent 71 Temporary 72 Refund-Reimburse. I Total 0 0 0 0 0 0 0 TOTAL ACCOUNT 166,355 191,175 235,954 126,219 295,500 295,500 295,500 112 I FUND: 101 General ACTIVITY: Protective Inspection DEPT 42400 I Obj Actual Actual Budget YTD June Requested Proposed Adopted Cod ITEM 1999 2000 2001 2001 2002 2002 2002 I PERSONAL SERVICES 101 Regular Salaries 53,832 52,993 68,649 24,560 71,979 71,979 71,979 102 O.T. Salaries I 103 Part Time Salaries 121 PERA City Share 2,788 2,745 3,556 1,272 3,980 3,980 3,980 122 FICA City Share 3,791 3,727 5,252 1,730 5,506 5,506 5,506 I 131 Ins. City Share 4,131 4,980 8,216 2,693 9,888 9,888 9,888 141 MN Unemp Comp 151 Workers Comp Total 64,542 64,445 85,673 30,256 91,353 91,353 91,353 I SUPPLIES 200 Office Supplies 212 Motor Fuel & Lube I 221 Maint-Equipment 223 Maint-Buildings 240 Small Tools I 245 General Supplies 166 251 1,050 256 400 400 400 Total 166 251 1,050 256 400 400 400 OTHER SERVICES I 301 Audit/Accounting 302 Consulting 303 Engineering 304 Legal I 321 Communication 309 579 650 250 650 650 650 331 Travel, Conf,Sch 1,571 2,228 2,700 1,079 2,700 2,700 2,700 351 Print/Publish 581 25 600 76 600 600 600 I 360 Ins.-Total 380 Utilities- Gas.lElec. . 400 Contractual 240 1,500 3,000 3,000 3,000 I 410 Rental 433 Subscrip-Member 85 85 100 130 130 130 437 Licenses-Taxes I 440 Misc. Services Total 2,546 3,157 5,550 1 ,404 7,080 7,080 7,080 OTHER CHARGES I 54 State Surchgs 55 I nteres t- Interfund Loan I 56 Allocated Expense from other Depts Total 0 0 0 0 0 0 0 CAPITAL OUTLAY I 60 Land 520 Buildings 540 Machinery-Equip 400 400 400 I 560 Furn & Fixtures 383 580 Other Improve Total 0 0 0 383 400 400 400 I TRANSFERS 720 Permanent 71 Temporary I 72 Refund-Reimburse. Total 0 0 0 0 0 0 0 TOTAL ACCOUN 67,254 67,853 92,273 32,299 99,233 99,233 99,233 I 114 I I BUDGET COMMENTS: PROTECTIVE INSPECTION DEPT 42400 I Code # I 101 5% of Planning Director 30% Planning Assistant 100% Building Inspector 10% Secretary/Receptionist I I 245 General Supplies: Books Film & Processing 300 100 I I 321 Cellular Telephone & Air Time 650 I 331 Travel, Conferences & Schools: Inspect. classes Conferences Mileage 225 275 2,200 I 351 Print permit application forms 600 I 400 Contractual Inspections during vacations, sick leave 3,000 I I 433 Subscriptions & Memberships: LC.B.O. Northstar Chapter - ICBO 100 30 540 Portable Printer 400; 400 I I I I I I 115 FUND: 101 General ACTIVITY: Animal Control DEPT 42700 I Obj Actual Actual Budget YTD June Requested Proposed Adopted Cod ITEM 1999 2000 2001 2001 2002 2002 2002 I PERSONAL SERVICES 101 Regular Salaries 102 O.T. Salaries 103 Part Time Salaries I 121 PERA City Share 122 FICA City Share 131 Ins. City Share. I 141 MN Unemp Comp 151 Workers Comp Total 0 0 0 0 0 0 0 SUPPLIES I 200 Office Supplies 212 Motor Fuel & Lube 221 Maint-Equipment I 223 Maint-Buildings 240 Small Tools 245 General Supplies I Total 0 0 0 0 0 0 0 OTHER SERVICES 301 AudiVAccounting I 302 Consulting 303 Engineering 304 Legal 321 Communication I 331 Travel, Conf,Sch 351 PrinVPublish 360 Ins.-Total I 380 Utilities- Gas.lElec. 400 Contractual - Animal Cont 18,570 18,574 21,800 9,793 22,700 22,700 22,700 410 Rental I 433 Subscrip-Member 437 Licenses-Taxes 440 Misc. Services I Total 18,570 18,574 21,800 9,793 22,700 22,700 22,700 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 I 64 Future 560 Furn & Fixtures Total 0 0 0 0 0 0 0 TRANSFERS I 720 Permanent 71 Temporary 72 Refund-Reimburse. I Total 0 0 0 0 0 0 0 TOTAL ACCOUNT 18,570 18,574 21,800 9,793 22,700 22,700 22,700 116 I FUND: 101 General ACTIVITY: City Engineer DEPT 43010 I Obj Actual Actual Budget YTD June Requested Proposed Adopted Cod ITEM 1999 2000 2001 2001 2002 2002 2002 I PERSONAL SERVICES 101 Regular Salaries 60,689 61,322 77,401 27,104 65,524 65,524 65,524 102 O.T. Salaries I 103 Part Time Salaries 121 PERA City Share 3,174 3,205 4,009 1 ,404 3,623 3,623 3,623 122 FICA City Share 4,687 4,734 5,921 2,073 5,013 5,013 5,013 I 131 Ins. City Share 5,311 6,473 9,725 3,073 10,979 10,979 10,979 141 MN Unemp Comp 151 Workers Comp Total 73,861 75,734 97,056 33,654 85,139 85,139 85,139 I SUPPLIES 200 Office Supplies 212 Motor Fuel & Lube I 221 Maint-Equipment 83 350 350 350 350 223 Maint-Buildings 240 Small Tools I 245 General Supplies 695 328 750 41 750 750 750 Total 778 328 1,100 41 1,100 1,100 1,100 OTHER SERVICES I 301 Audit! Accounting 302 Consulting 303 Engineering 5,974 1,834 4,000 3,489 5,000 5,000 5,000 304 Legal I 321 Communication 657 609 600 446 600 600 600 331 Travel, Conf,Sch 2,437 959 3,000 409 3,000 3,000 3,000 351 Print/Publish 275 300 300 300 300 I 360 Ins.-Total 380 Utilities- Gas.lElec. 400 Contractual 7,568 13,163 8,000 1,740 2,000 2,000 2,000 I 410 Rental 433 Subscrip-Member 200 200 200 200 437 Licenses-Taxes 600 600 600 I 440 Misc. Services Total 16,636 16,840 16,100 6,083 11,700 11,700 11,700 OTHER CHARGES I 54 State Surchgs 55 Interest- Interfund Loan I 56 Allocated Expense from other Depts Total 0 0 0 0 0 0 0 CAPITAL OUTLAY I 60 Land 520 Buildings 540 Machinery-Equip 2,000 2,000 2,000 I 560 Furn & Fixtures 200 425 500 500 500 580 Other Improve Total 0 200 425 0 2,500 2,500 2,500 I TRANSFERS 720 Permanent 2,200 71 Temporary I 72 Refund-Reimburse. Total 0 0 2,200 0 0 0 0 TOTAL ACCOUN 91,275 93,101 116,881 39,779 100,439 100,439 100,439 I 118 I I BUDGET COMMENTS: CITY ENGINEER DEPT 43010 I Code # I 101 65% City Engineers/Public Works Director Salary 25% FIT Clerical 25% FIT Engineering Tech. I I I 221 Computer Upgrade I 245 Books & Materials Software Upgrades I I I 303 Engineering - General Contractual I 321 Cellular phone time & Pager 331 Travel, Conference, & School I 400 Contractual Engineering Tech Assistance I 433 Subscriptions & Memberships I I 540 Drafting Table & Supplies-Tech 560 Computer (Technician) I I I 119 300 450 500 2,000 FUND: 101 General ACTIVITY: Public Works Service DEPT 43050 I Obj Actual Actual Budget YTD June Requested Proposed Adopted Cod ITEM 1999 2000 2001 2001 2002 2002 2002 I PERSONAL SERVICES 101 Regular Salaries 151,614 136,697 169,879 69,699 180,730 180,730 180,730 102 O.T. Salaries 25 1,513 300 214 300 300 300 I 103 Part Time Salaries 53 1,252 1,029 121 PERA City Share 7,946 6,824 8,800 . 3,675 9,994 9,994 9,994 122 FICA City Share 11 ,388 10,568 13,019 5,365 13,849 13,849 13,849 I 131 Ins. City Share 11,598 12,683 21,383 7,706 30,332 30,332 30,332 141 MN Unemp Comp 151 Workers Camp Total 182,624 169,537 213,381 87,687 235,205 235,205 235,205 I SUPPLIES 200 Office Supplies 212 Motor Fuel & Lube 10,003 11,552 16,500 7,159 16,500 16,500 16,500 I 221 Maint-Equipment 12,089 8,124 13,000 6,945 13,000 13,000 13,000 223 Maint-Buildings 2,212 1,317 1,200 199 1,200 1,200 1,200 240 Small Tools 770 986 1,000 336 1,000 1,000 1,000 I 245 General Supplies 8,380 7,676 8,200 4,292 8,300 8,300 8,300 Total 33,454 29,655 39,900 18,932 40,000 40,000 40,000 OTHER SERVICES I 301 Audit/Accounting 305 Drug Testing 217 390 600 72 600 600 600 302 Consulting I 303 Engineering 304 Legal 321 Communication 1,255 1,873 1,300 997 1,800 1,800 1,800 331 Travel, Conf,Sch 760 3,423 2,600 3,114 2,600 2,600 2,600 I 351 Print/Publish 360 Ins.- Total 380 Utilities- Gas/Elec. 6,919 8,033 8,500 6,088 9,000 9,000 9,000 I 400 Contractual 7,310 9,511 7,800 4,055 8,000 8,000 8,000 410 Rental 113 500 34 500 500 500 433 Subscrip-Member 50 50 50 50 50 437 Licenses-Taxes 250 475 500 307 610 610 610 I 440 Misc. Services 588 411 300 76 300 300 300 Total 17,299 24,279 22,150 14,742 23,460 23,460 23,460 OTHER CHARGES I 54 State Surchgs 55 Interest- Interfund Loan I 56 Allocated Expense from other Depts Total 0 0 0 0 0 0 0 CAPITAL OUTLAY I 60 Land 520 Buildings I 540 Machinery-Equip 1,204 1,891 900 1,065 2,625 2,625 2,625 560 Furn & Fixtures 580 Other Improve 1,100 Total 1,204 1,891 900 1,065 2,625 2,625 2,625 I TRANSFERS 720 Permanent 107,000 122,000 126,500 105,000 105,000 105,000 72 Refund-Reimburse. I Total 107,000 122,000 126,500 0 105,000 105,000 105,000 TOTAL ACCOUN 341,581 347,363 402,831 122,426 406,290 406,290 406,290 120 I I I BUDGET COMMENTS: PUBLIC WORKS SERVICE DEPT 43050 I Code # I 101 10% City Engineer/Public Works Director 100% Public Works Supervisor 2.50 Light Equipment Operators .25 FIT Clerical .25 Engineer Tech 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 I 305 Drug monitoring and testing, including annual dues to LMCIT 321 Telephones and pager & dial-in internet acct for weather & parts 331 Safety Training - SafeAssure (OSHA man 2600 I 380 Utilities - Gas & Electric I I 400 Laundry service - uniforms, towels Janitorial Services Fire Suppression System Monitoring 220 Annual Crane Inspection 250 410 Mise equip rental for all PW Depts. 433 SUbscriptions & memberships 437 Hazardous Waste Licence - Dept of Rev 50 Hennepin Co. Hazardous Waste 200 Mise Licenses(Boiler,lrrigation,FireExting I 360 440 Damage to private property - mailboxes, etc. 540 Replacement Radios (2) & Mics 1000 Computer 1100 Cell Phone Replacement 175 Drain Oil System 350 720 Transfer to Equipment Replacement Fund 70000 Transfer to Stormwater Management Fun 35000 I I I I I I I 121 FUND: 101 General ACTIVITY: Streets and Roadways DEPT 43100 I Obj Actual Actual Budget YTD June Requested Proposed Adopted Cod ITEM 1999 2000 2001 2001 2002 2002 2002 I PERSONAL SERVICES 101 Regular Salaries 53,605 33,628 77,126 23,685 80,527 80,527 80,527 102 O.T. Salaries 366 334 500 316 500 500 500 I 103 Part Time Salaries 121 PERA City Share 2,799 1,759 4,021 1,243 4,481 4,481 4,481 122 FICA City Share 3,984 2,536 5,938 1,780 6,199 6,199 6,199 131 Ins. City Share 4,089 3,893 10,220 2,158 13,576 13,576 13,576 I 141 MN Unemp Comp 151 Workers Comp Total 64,843 42,151 97,805 29,181 105,283 105,283 105,283 I SUPPLIES 200 Office Supplies 212 Motor Fuel & Lube I 221 Maint-Equipment 223 Maint-Buildings 240 Small Tools 245 General Supplies 32,796 20,672 35,000 9,925 35,000 35,000 35,000 I Total 32,796 20,672 35,000 9,925 35,000 35,000 35,000 OTHER SERVICES 301 Audit/Accounting I 302 Consulting 303 Engineering 304 Legal I 321 Communication 331 Travel, Conf,Sch 100 351 Print/Publish I 360 Ins.- Total 380 Utilities- Gas.lElec. 400 Contractual 3,076 I 410 Rental 433 Subscrip-Member 437 Licenses-Taxes I 440 Misc. Services 3,791 50,280 6,000 500 6,000 6,000 6,000 Total 6,867 50,280 6,100 500 6,000 6,000 6,000 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 I 60 Land 520 Buildings 540 Machinery-Equip I 560 Furn & Fixtures 580 Other Improve Total 0 0 0 0 0 0 0 I TRANSFERS 720 Permanent 360,000 347,000 367,000 200,000 200,000 200,000 71 Temporary I 72 Refund-Reimburse. Total 360,000 347,000 367,000 0 200,000 200,000 200,000 TOTAL ACCOUNT 464,506 460,103 505,905 39,606 346,283 346,283 346,283 I 122 I BUDGET COMMENTS: STREETS AND ROADWAYS DEPT 43100 I Code # I 101 Street Maintenance salaries - 2.0 Light Equip. Operators I I I I I 245 Rock, gravel, black dirt & asphalt I 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 (2002) Street Improvements Overlays Seal Coating 200,000 I I 123 FUND: 101 General ACTIVITY: Snow and Ice Removal DEPT 43125 I Obj Actual Actual Budget YTD June Requested Proposed Adopted Cod ITEM 1999 2000 2001 2001 2002 2002 2002 I PERSONAL SERVICES 101 Regular Salaries 10,321 10,327 19,282 9,662 20,132 20,132 20,132 102 O.T. Salaries 3,889 3,784 5,000 5,968 5,000 5,000 5,000 I 103 Part Time Salaries 121 PERA City Share 736 731 1,258 810 1,390 1,390 1,390 122 FICA City Share 1,034 1,058 1,858 1,167 1,923 1,923 1,923 I 131 Ins. City Share 1,050 794 3,197 2,097 4,211 4,211 4,211 141 MN Unemp Camp 151 Workers Camp Total 17,030 16,693 30,595 19,702 32,656 32,656 32,656 I SUPPLIES 200 Office Supplies 212 Motor Fuel & Lube I 221 Maint-Equipment 223 Maint-Buildings 240 Small Tools I 245 General Supplies 13,009 15,416 17,500 10,923 17,500 17,500 17,500 Total 13,009 15,416 17,500 10,923 17,500 17,500 17,500 OTHER SERVICES I 301 Audit/Accounting 302 Consulting 303 Engineering 304 Legal I 321 Communication 331 Travel, Conf,Sch 200 0 0 0 351 Print/Publish I 360 Ins.-Total 380 Utilities- Gas.lElec. 400 Contractual I 410 Rental 433 Subscrip-Member 437 Licenses-Taxes I 440 Misc. Services Total 0 0 200 0 0 0 0 OTHER CHARGES I 54 State Surchgs 55 Interest- Interfund Loan I 56 Allocated Expense from other Depls Total 0 0 200 0 0 0 0 CAPITAL OUTLAY I 60 Land 520 Buildings 540 Machinery-Equip I 560 Furn & Fixtures 580 Other Improve Total 0 0 0 0 0 0 0 I TRANSFERS 720 Permanent 71 Temporary I 72 Refund-Reimburse. Total 0 0 0 0 0 0 0 TOTAL ACCOUNT 30,039 32,110 48,495 30,625 50,156 50,156 50,156 I 124 FUND: 101 General ACTIVITY: Traffic Control/Street Lighting DEPT 43160 I Obj Actual Actual Budget YTD June Requested Proposed Adopted Cod ITEM 1999 2000 2001 2001 2002 2002 2002 PERSONAL SERVICES I 101 Regular Salaries 102 O.T. Salaries I 103 Part Time Salaries 121 PERA City Share 122 FICA City Share 131 Ins. City Share I 141 MN Unemp Comp 151 Workers Comp Total 0 0 0 0 0 0 0 SUPPLIES I 200 Office Supplies 212 Motor Fuel & Lube I 221 Maint-Equipment 1,668 1,410 1,500 264 1,500 1,500 1,500 223 Maint-Buildings 240 Small Tools 245 General Supplies 3,558 1,882 3,550 2.433 3,550 3,550 3,550 I Total 5,226 3,291 5,050 2,697 5,050 5,050 5,050 OTHER SERVICES 301 Audit! Accounting I 302 Consulting 303 Engineering 304 Legal I 321 Communication 331 Travel, Conf,Sch 351 Print/Publish 360 Ins.-Total I 380 Utilities- Gas.lElec. 4,334 5,753 5,500 2,723 5,700 5,700 5,700 400 Contractual 410 Rental I 433 Subscrlp-Member 437 Licenses-Taxes 440 Misc. Services 29,532 29,173 29,000 12,175 29,000 29,000 29,000 I Total 33,866 34,926 34,500 14,897 34,700 34,700 34,700 OTHER CHARGES 54 State Surchgs I 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 Furn & Fixtures I 580 Other Improve Total 0 0 0 0 0 0 0 TRANSFERS I 720 Permanent 71 Temporary 72 Refund-Reimburse. I Total 0 0 0 0 TOTAL ACCOUNT 39,092 38,217 39,550 17,594 39,750 39,750 39,750 126 I I BUDGET COMMENTS: TRAFFIC CONTROUSTREET LIGHTING DEPT 43160 I Code # I I I I I 221 Maintenance to semaphores I 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 127 FUND # 101 General ACTIVITY: SanitationlWaste RemovallWeeds I Obj Actual Actual Budget TD June Requested roposed Adopted Cod ITEM 1999 2000 2001 2001 2002 2002 2002 PERSONAL SERVICES I 101 Regular Salaries 374 1,057 500 878 500 500 500 102 O.T. Salaries 373 103 Part Time Salaries I 121 PERA City Share 19 74 26 45 28 28 28 122 FICA City Share 26 107 38 67 38 38 38 131 Ins. City Share 37 114 66 91 84 84 84 I 141 MN Unemp Comp 151 Workers Comp Total 456 1,726 630 1,081 650 650 650 SUPPLIES I 200 Office Supplies 212 Motor Fuel & Lube 221 Maint-Equipment I 223 Maint-Buildings 240 Small Tools 245 General Supplies I Total 0 0 0 0 0 0 0 OTHER SERVICES 301 Audit/Accounting I 302 Consulting 303 Engineering 304 Legal 321 Communication I 331 Travel, Conf,Sch 351 Print/Publish 360 Ins.-Total 380 Utilities- Gas.lElec. I 400 Contractual 241 500 500 500 500 410 Rental 433 Dues & Subscriptions I 437 Licenses-Taxes 440 Misc. Services 5,713 3,000 3,000 3,000 3,000 Total 0 5,954 3,500 0 3,500 3,500 3,500 OTHER CHARGES I 54 State Surchgs 55 Interest- Interfund Loan I 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 580 Other Improve 64 Future 560 Furn & 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 456 7,679 4,130 1,081 4,150 4,150 4,150 I 128 I I BUDGET COMMENTS: SANITATIONIWASTE REMOVAUWEEDS DEPT 43200 I Code # I 101 Public Works salaries associated with property clean-up I I I I I I 400 Property clean-up I I 440 Contracted weed spraying. I I I I I I I I 129 FUND: 101 General ACTIVITY: Tree Maintenance DEPT 43250 I Obj Actual Actual Budget YTD June Requested Proposed Adopted Cod ITEM 1999 2000 2001 2001 2002 2002 2002 I PERSONAL SERVICES 101 Regular Salaries 4,297 11,434 7,713 877 8,053 8,053 8,053 102 O.T. Salaries 51 171 I 103 Part Time Salaries 121 PERA City Share 225 601 400 45 445 445 445 122 FICA City Share 317 865 590 65 616 616 616 131 Ins. City Share 310 1,167 1,015 115 1,349 1,349 1,349 I 141 MN Unemp Comp 151 Workers Comp Total 5,200 14,238 9,718 1,103 10,463 10,463 10,463 I SUPPLIES 200 Office Supplies 212 Motor Fuel & Lube I 221 Maint-Equipment 223 Maint-Buildings 240 Small Tools 555 550 579 550 550 550 I 245 General Supplies 67 300 286 300 300 300 Total 555 67 850 865 850 850 850 OTHER SERVICES 301 AUdiUAccounting I 302 Consulting 303 Engineering 304 Legal I 321 Communication 331 Travel, Conf,Sch 190 100 300 130 300 300 300 351 PrinUPublish I 360 Ins.-Total 380 Utilities- Gas.lElec. 400 Contractual 10,828 6,040 13,000 1,455 13,000 13,000 13,000 I 410 Rental 433 Dues & Subscriptions 437 Licenses-Taxes I 440 Misc. Services Total 11,018 6,140 13,300 1,585 13,300 13,300 13,300 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 I 60 Land 520 Buildings 540 Machinery-Equip I 560 Furn & Fixtures 580 Other Improve Total 0 0 0 0 0 0 0 I TRANSFERS 720 Permanent 71 Temporary I 72 Refund-Reimburse. Total 0 0 0 0 0 0 0 TOTAL ACCOUNT 16,773 20,445 23,868 3,553 24,613 24,613 24,613 I 130 I BUDGET COMMENTS: TREE MAINTENANCE DEPT 43250 I Code # 101 .20 Light Equipment Operators I I I I 240 Small Tools - 1 Replacement chain saw I I 245 Paint for marking trees I I I 331 Tree Inspection School (2 @ $150) I 400 Contracted tree removal. I I I I I I I 131 FUND: 101 DEPARTMENT: Parks and Recreation DEPT 45200 I Obj Actual Actual Budget YTD June Requested Proposed Adopted Cod ITEM 1999 2000 2001 2001 2002 2002 2002 I PERSONAL SERVICES 101 Regular Salaries 48,889 71,203 66,039 28,624 69,184 69,184 69,184 102 O.T. Salaries 788 3,430 500 10,257 500 500 500 I 103 Part Time Salaries 13,871 7,385 19,560 798 26,800 26,800 26,800 121 PERA City Share 2,677 3,764 3,447 1 ,498 3,854 3,854 3,854 122 FICA City Share 4,721 6,209 6,587 3,008 7,381 7,381 7,381 I 131 Ins. City Share 3,960 6,324 8,361 4,334 11,676 11,676 11,676 141 MN Unemp Camp 151 Workers Camp Total 74,906 98,316 104,494 48,519 119,395 119,395 119,395 I SUPPLIES 200 Office Supplies I 212 Motor Fuel & Lube 221 Maint-Equipment 1,625 1,581 2,000 590 2,000 2,000 2,000 223 Maint-Buildings 993 376 1,000 824 1,000 1,000 1,000 240 Small Tools 211 11 500 76 500 500 500 I 245 General Supplies 12,264 6,271 16,000 3,771 16,000 16,000 16,000 Total 15,093 8,239 19,500 5,260 19,500 19,500 19,500 OTHER SERVICES I 301 AudiUAccounting 302 Consulting 3,991 7,519 3,000 134 3,000 3,000 3,000 303 Engineering I 304 Legal 321 Communication 128 349 400 1,057 650 650 650 331 Travel, Conf,Sch 100 200 144 200 200 200 351 PrinUPublish 123 400 49 400 400 400 I 360 Ins.- Total 380 Utilities- Gas.lElec 2,778 3,063 4,500 3,887 5,400 5,400 5,400 400 Contractual 8,447 7,608 9,500 2,749 15,500 15,500 15,500 I 410 Rental 8,527 10,033 8,750 2,164 7,250 7,250 7,250 433 Dues & Subscriptions 437 Licenses-Taxes 440 Misc. Services 565 1,000 50 1,100 1,100 1,100 I Total 24,436 28,795 27,750 10,233 33,500 33,500 33,500 OTHER CHARGES 54 State Surchgs I 55 Interest- Interfund Loan 56 Allocated Expense I from other Depts Total 0 0 0 0 0 0 0 CAPITAL OUTLAY I 60 Land 520 Buildings 540 Machinery-Equip 542 375 375 375 I 560 Furn & Fixtures 580 Other Improve 0 0 0 0 Total 0 542 0 0 375 375 375 TRANSFERS I 720 Permanent 10,000 10,000 35,000 35,000 35,000 71 Temporary I 72 Refund-Reimburse. Total 0 10,000 10,000 0 35,000 35,000 35,000 TOTAL ACCOUNT 114,435 145,891 161,744 64,012 207,770 207,770 207,770 132 I I I I I I I I BUDGET COMMENTS: PARKS & RECREATION/BEACHES DEPT 45200 Code # 101 1.50 Light Equipment Operators 0.25 Clerical 103 Part-time Rink Attendants (400 hrs x 4 rinks x $10.00) Park Commission Minutes ($150 x 1.5 x 12) Part-time summer help (12 weeks x 40 hrs x $11.25 x 2 emps.) 16,000 2,700 10,800 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 I I I I I I I I I I I 302 Park Planner - Park and Trail Planning 321 331 351 380 400 Park telephones. Travel, Conferences, Schools Annual Parks Newsletter & Snowmobile information Includes electricity and natural gas for warming houses Minnetonka Community Services, weeds spraying, Sr. Rec Program Rental of portable toilets for Parks, Crescent Beach Christmas Lake Public Access 410 440 Misc. Expenses, such as rubbish hauling, electrical work; Cathcart Warming House electrical hook-up & disconnect Backpack Blower Transfer to Park Capital Improvement Fund 540 720 133 9,500 6,000 7,200 375 134 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 Budget YTD Sept Proposed Adopted # 1999 2000 2001 2001 2002 2002 36210 Water Int. Earned 32,178 93,266 50,000 17,976 40,000 40,000 37110 Water Sales 238,127 285,212 250,000 127,943 250,000 250,000 37150 Connection Fees 0 0 100,000 0 150,000 150,000 . 37170 Water Permits 500 5,336 500 3,195 375 375 37171 Sale of Meters 4,832 10,105 3,000 7,475 2,250 2,250 37175 Antennae Space Rental 35,049 23,381 22,700 6,575 20,000 20,000 Totals 310,686 417,300 426,200 163,165 462,625 462,625 I I I I I I I I I I I I I I I I I I I BUDGET COMMENTS: WATER FUND REVENUES 36210 Interest earned on investment of water funds 37110 Estimate of 2002 water sales 37150 Connection Fees (15 at $10,000) 37170 Permits to be sold (same number as meters) 15 @ $25 = $375 37171 Water meter sales -15 new hookups 37175 Revenue from space rental of water tower to cellular companies 135 I FUND # 601 WATER FUND EXPENDITURES DEPT # 49400 Code Actual Actual Budget YTD Sept Proposed Adopted I # ITEM 1999 2000 2001 2001 2002 2002 PERSONAL SERVICES I 101 Regular Salaries 20,634 10,235 17,650 7,755 31,841 31,841 102 O.T. Salaries 577 149 0 411 0 0 I 103 Part Time Salaries 0 0 0 0 121 PERA City Share 1,085 538 914 423 1,761 1,761 122 FICA City Share 1,496 748 1,350 597 2,436 2,436 I 131 Ins. City Share 1,685 925 2,150 816 5,335 5,335 Total 25,477 12,595 22,064 10,002 41,373 41,373 SUPPLIES I 200 Office Supplies 1,955 1,498 2,000 2,000 2,000 208 Postage 676 1,240 1,000 349 1,000 1,000 I 212 Motor Fuel & Lube 0 0 0 221 Maint-Equipment 19,940 14,168 14,000 9,209 16,000 16,000 223 Maint-Buildings 724 366 2,500 2,500 2,500 I 240 Small Tools 250 250 250 245 General Supplies 8,978 10,413 7,500 9,322 10,000 10,000 260 Wtr Purch - Tanka Bay 1,216 1,816 1,500 482 1,500 1,500 I 261 Wtr Purch - Excelsior 9,231 9,933 10,000 5,795 10,000 10,000 262 Wtr Purch - Mtka 375 508 500 417 500 500 265 Water Meters 3,595 8,920 3,000 0 2,000 2,000 I Total 46,690 48,861 42,250 25,574 45,750 45,750 OTHER SERVICES & CHARGES I 301 Financial & Audit 863 1,042 800 1,383 1 ,400 1,400 302 Consulting 0 518 0 0 303 Engineering 14,092 9,175 6,000 6,192 7,000 7,000 I 304 Legal 5,031 1,000 0 500 500 321 Communication 233 300 1,000 1,000 331 Travel, Conf,Sch 0 1,000 1,000 I 351 Print/Publish 338 406 400 386 400 400 360 Insurance-Total 3,637 4,184 4,200 2,299 5,000 5,000 394 Utilities - Amesbury 7,691 7,416 7,500 5,520 7,800 5,741 I 395 Utilities - Badger 6,702 7,529 5,800 6,995 7,500 7,500 396 Utilities - Boulder Bridge 9,770 11,641 11,000 9,805 11 ,440 10,197 397 Utilities - Woodhaven 2,714 3,033 4,000 2,030 4,160 2,111 I 398 Utilities - SE Area/Tower 21,633 18,035 25,000 13,767 26,000 14,317 400 Contractual 54,299 55,327 62,000 52,435 62,000 62,000 410 Rental 0 0 I 420 Depreciation 151,615 172,032 145,000 118,888 145,000 145,000 433 Subscrip-Member 300 300 300 437 Licenses-Sales Taxes 810 1,247 1,200 1,393 1 ,400 1,400 I 440 Misc. Services 35 200 250 180 200 200 State Surchgs 1,200 1,200 1,200 I 450 Investment Svc Chgs 883 896 900 736 900 900 Total 280,346 292,163 276,850 222,526 284,200 267,167 136 I I FUND # 601 DEPT # 49400 I Code Actual Budget Budget YTD Sept Proposed Adopted # ITEM 1999 2000 2001 2001 2002 2002 I CAPITAL OUTLAY 60 Land I 520 Buildings 540 Machinery-Equip 5,111 580 Other Improve 698 0 136,000 0 220,000 220,000 I Total 698 5,111 136,000 0 220,000 220,000 TRANSFERS I 720 Permanent 42,400 45,000 85,000 0 110,000 110,000 Total 42,400 45,000 85,000 0 110,000 110,000 I TOTAL ACCOUNT 395,611 403,730 562,164 258,103 701,323 684,290 I I I I I I I I I I I I 137 I BUDGET COMMENTS: WATER FUND EXPENDITURES FUND # 601 I 101 .10 Senior Accounting Clerk .10 Receptionist/Secretary .30 Light Equip. Operator .15 City Engineer .25 Engineering Technician I I 200 Billing supplies 208 Postage I 221 Maintenance contract for UB hardware & software. Inspection/Maintenance of Wells Boulder Bridge Well Maintenance Surge Protectors for Wells I 223 Maintenance of Well Buildings I 240 Small Tools I 245 General Supplies 265 20 homes @ $100.00/meter plus replacement meters I 303 Engineering - Water maintenance I 321 Autodialers for Pumphouses - Costs moved to individual well utility accts. I 331 Water Operators License Training I 351 Annual Water Quality Report 360 Insurance I 400 Munitech Contract I 420 Depreciation - a non-cash expense for future system replacement I 437 Sales tax on commercial water sales - Recorded as pass thru liability in 1999 & thereafter State Water Surcharges - $5.21/connection/year - Recorded as pass thru liability in 1999 & thereafter I I I 138 I I I BUDGET COMMENTS: WATER FUND I I I I I I I I I I I I I I I I I 580 Interconnection of Woodhaven Well with Excelsior ($118,000 - 2002) Pull & Repair Vertical Turbine pump at Boulder Bridge ($18,000 - 2002) Two (2) Water Tower alarm systems ($4,000 - 2002) Amesbury Well House Piping ($80,000) 720 Permanent Transfers Water Debt Service Fund - Debt Payments ($100,000) General Fund - Overhead Costs ($10,000 - 2002) 139 I FUND # 601 DEPT # 49400 I REVENUES CODE REVENUE SOURCE Actual Actual Budget YTD Sept Proposed Adopted I # 1999 2000 2001 2001 2002 2002 17000 Victoria Tower Payments 51,848 0 0 .0 0 0 I 31010 Property Tax 10 0 0 0 0 36101 Special Assessments 225,882 41 ,409 100,000 41 ,419 80,000 80,000 36210 Interest Income I 37150 Connection Fees 216,100 175,000 20,000 47,350 30,000 30,000 39203 Transfers 40,000 40,000 80,000 120,000 120,000 Totals 533,830 256,420 200,000 88,769 230,000 230,000 I EXPENSES I Code Actual Actual Budget YTD Sept Proposed Adopted # ITEM 1999 2000 2001 2001 2002 2002 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 o. 0 0 0 0 0 I TRANSFERS I 720 Permanent Total 0 0 0 0 0 0 DEBT SERVICE I 23100 Bond Principal 180,000 190,000 185,000 185,000 185,000 185,000 611 Bond Interest 117,337 109,424 99,739 51,928 91,415 91,415 620 Agent Fees 305 312 350 312 350 350 I Total 297,337 299,424 284,739 236,928 276,415 276,415 TOTAL ACCOUNT 297,337 299,424 284,739 236,928 276,415 276,415 I 140 I I I I I I I I I I I I I I I I I I I I BUDGET COMMENTS: WATER DEBT SERVICE REVENUES CODE# 36101 Special Assessment payments 17000 Victoria Tower Payment 37150 Connection Fees 36210 Interest Income 39203 Transfers from Other Funds EXPENSES CODE# 23100 Principal on G.O. Revenue Bonds 611 Interest G.O. Revenue Bonds 620 Agent Fees 141 FUND # 611 SEWER FUND REVENUES Dept # 49450 I I I I I I I I I I I I I I I I I I I Code Actual Actual Budget YTD Sept Proposed Adopted # REVENUE SOURCE 1999 2000 2001 2001 2002 2002 33635 MCES I & I Grant 0 5,000 0 0 0 0 36210 Sewer Int. Earned 56,991 146,025 80,000 23,111 50,000 50,000 36240 Refunds/Reimburse 780 0 0 0 0 0 36270 Metro Sac Charges 452 5,154 200 0 180 180 37210 Sewer Serv Charges 720,446 693,904 650,000 307,729 650,000 650,000 37210 Sewer Chg-Cnty Coli 0 0 0 0 0 37250 Local SAC Charges 22,000 0 0 7,200 5,000 5,000 37270 Sewer Permits 3,800 10,200 2,000 3,660 1,500 1,500 39203 Tsfr From Other Funds 25,000 0 28,000 28,000 Total 804,469 860,283 757,200 341,700 734,680 734,680 142 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 earnings. 36270 Metro SAC charges collected w/sewer permit $1,200 x est. 15 homes to be constructed in 2002 = $20,000*.01=$180 37210 Estimated Sewer Service Charge Revenue (($60/Qtr * 2,700 Accts) 37210 Delinquent sewer bills collected by the County 37250 Local Sewer Access Charges @ $1,250 each 37270 $100 each for estimated 15 homes to be constructed in 2001 39203 Transfer in from Stormwater Fund for repayment of Gideon Glen Interfund Loan ($200,000 from Watershed; $25,000 prinlint pmt - 2001) ($28,000 - 2002) 143 FUND # 611 DEPT # 49450 I Code Actual Actual Budget YTD Sept Proposed Adopted # ITEM 1999 2000 2001 2001 2002 2002 I PERSONAL SERVICES 101 Regular Salaries 11,672 15,011 17,650 9,482 31 ,841 31 ,841 102 O.T. Salaries 45 0 55 0 0 I 103 Part Time Salaries 0 0 0 121 PERA City Share 605 780 914 494 1,761 1,761 122 FICA City Share 837 1,114 1,350 708 2,436 2,436 I 131 Ins. City Share 962 2,023 2,150 1,016 5,335 5,335 Total 14,076 18,973 22,064 11,754 41,373 41,373 SUPPLIES I 200 Office Supplies 1,954 1,205 2,500 2,500 2,500 208 Postage 992 1,666 1,500 688 1,500 1,500 I 212 Motor Fuel & Lube 0 0 221 Maint-Equipment 15,012 13,007 12,000 915 12,000 12,000 223 Maint-Buildings I 240 Small Tools 450 450 450 245 General Supplies 465 864 700 17 700 700 Total 18,423 16,742 17,150 1,620 17,150 17 ,150 I SUPPORT SERVICES & CHARGES 301 Financial & Audit 863 1,042 800 1,383 1 ,400 1 ,400 302 Consulting I 303 Engineering 11,201 6,920 7,500 874 5,000 5,000 304 Legal 500 500 321 Communication 139 137 700 68 1,200 1,200 I 331 Travel, Conf,Sch 136 774 1,100 630 1,100 1,100 351 PrinUPublish 491 250 250 250 360 Insurance-Total 1,689 2,416 2,500 946 2,500 2,500 I 380 Utilities-Gas/Elec 5,402 4,855 5,500 3,488 5,720 5,949 385 MCES Service Charges 322,976 293,148 384,000 244,240 393,600 393,600 386 Excelsior Sewer Chg 11,397 13,016 12,000 0 13,000 13,000 I 400 Contractual 31,566 44,050 74,500 29,327 55,000 55,000 410 Rental 420 Depreciation 197,794 198,974 200,000 133,880 200,000 200,000 I 433 Dues & Subscriptions 250 250 437 Licenses-Taxes 500 500 440 Misc. Services 58 500 58 500 500 I 450 Service Charges 1,500 1,598 1,500 1,092. 1,500 1,500 MCES SAC Charges I Total 584,663 567,480 690,850 415,987 682,020 682,249 CAPITAL OUTLAY 540 Machinery-Equip 84,500 84,500 I 560 Furn & Fixtures 580 Other Improve 3,960 100,000 0 100,000 100,000 Total 3,960 0 100,000 0 184,500 184,500 I TRANSFERS 720 Interfund Loans-Gideon/Sr Ctr 565,000 0 0 0 0 I 720 Permanent 6,000 86,875 10,000 0 15,000 15,000 Total 6,000 651,875 10,000 0 15,000 15,000 TOTAL ACCOUNT 627,122 1,255,070 840,064 429,362 940,043 940,272 I 144 I I I I I I I I I I I I I I I I I I I BUDGET COMMENTS: SEWER FUND FUND#611 CODE # 101 .10 Senior Accounting Clerk .10 Receptionist/Secretary .20 Light Equip. Operator .15 City Engineer .10 Engineer. Technician 221 Includes software maintenance Equipment Maintenance 240 Phase meter for lift stations 245 Adjusting rings manholes Jetter nozzles and hose 303 Engineering fees for I & I Study, other 304 Legal fees 321 2 Nextel phones; airtime charges for autodialer for Lift 18; 3 alarms monitoring 331 To license Public Works staff - MSCC School 360 Insurance 385 MCES treatment charges - Est. 320 million gallons @ $1,230/million gallons 386 Charge for Sewage Flow through Excelsior Trunks 400 Munitech Contract (incr of 5% for 2001) - $31,500 Scheduled Sewer Cleaning - (Not needed if Vac Truck purchased - otherwise $20,000) Inflow & Infiltration Control & Reduction - $22,000 Sewer Service Inspections - $1,000 420 Depreciation 440 Misc. expenses - also includes costs for backups in resident homes 540 Alarm panels 1/3 purchase of Vacuum Jetter Truck with Excelsior & Tonka Bay ($80,000 - 2002) 580 Refurbish Shady Island Lift Station ($60,000 - 2001 & 2002) Refurbish Birch Bluff Lift Station ($40,000 - 2002) Add 3 alarm/auto dialers to lift stations 5, 11, 15 720 Transfer to General Fund for Overhead Costs $15,000 - 2002 145 I FUND # 621 RECYCLING FUND BUDGET DEPT # 49550 REVENUES I CODE REVENUE SOURCE Actual Actual Budget YTD Sept Proposed Adopted # 1999 2000 2001 2001 2002 2002 33620 Cnty Recycling Aid 21,860 21,858 22,000 23,728 23,450 23,450 I 36210 Interest Income 966 2,346 1,100 578 1,000 1,000 37310 Recycling Svc Chgs 44,036 52,507 48,600 22,249 48,600 48,600 I 37320 City Clean-up Fees 23,307 23,941 23,000 26,531 24,000 24,000 37330 Recycling Bin Sales 360 416 350 320 350 350 37340 Revenue from Contr 0 0 0 I 39203 Tfrs from Other Funds 0 0 0 0 0 Totals 90,529 101,067 95,050 73,407 97,400 97,400 EXPENSES I Code Actual Actual Budget YTD Sept Proposed Proposed # ITEM 1999 2000 2001 2001 2002 2002 I PERSONAL SERVICES 101 Regular Salaries 0 100 100 100 102 O.T. Salaries 448 1,150 580 1,150 1,150 I 103 Part Time Salaries 0 0 0 121 PERA City Share 23 65 30 65 65 122 FICA City Share 33 96 42 95 95 I 131 Ins. City Share 39 115 0 115 115 Total 543 0 1,526 653 1,525 1,525 SUPPLIES I 200 Office Supplies 301 0 212 Motor Fuel & Lube I 221 Maint-Equipment 223 Maint-Buildings 240 Small Tools I 245 General Supplies 143 1,539 200 626 500 500 Total 143 1,840 200 626 500 500 OTHER SERVICES I 301 Financial & Auditing 302 Consulting 303 Engineering I 304 Legal 321 Communication 331 Travel, Conf,Sch I 351 Print/Publish 13 200 360 Insurance-Total 380 Utilities-Gas/Elec I 400 Contractual 83,607 85,427 95,115 79,692 95,200 95,200 410 Rental 433 Subscrip-Member I 437 Licenses-Taxes 440 Misc. Services 114 119 150 150 450 Service Charges 22 23 20 20 25 25 I Total 83,629 85,577 95,335 79,830 95,375 95,375 TOTAL ACCOUNT 84,315 87,417 97,061 81,108 97,400 97,400 146 I I I BUDGET COMMENTS: RECYCLING FUND REVENUES REVENUES I 33620 Recycling Aid from Hennepin County 37310 Residential Charges for Recycling Services - $1.50/mo/household I 37320 Residential Charges for City Clean-Up I I I I 37340 Revenue from Recycling Contractor from Sale of Recyclables EXPENSES CODE # 101 Light Equip. Operator - City Clean Up Administration Salaries I I 245 General supplies I I I I 351 Publishing & Promotion 400 E-Z Recycling - Residential Recycling (2,675 x $2.15 x 12) City Clean-up - Spring & Fall . Includes $50/ mo Freeman Park I I I I I 147 69,100 25,500 600 I FUND # 631 DEPT # 49600 REVENUES I CODE REVENUE SOURCE Actual Actual Budget YTD Sept Proposed Adopted # 1999 2000 2001 2001 2002 2002 36210 Interest Income 5,237 17,505 6,500 (835) 1,000 1,000 I 36270 Miscellaneous Revenu 1,094 206 200,000 200,048 1,000 1,000 37410 Storm Utility Charges 44,938 52,134 45,000 20,022 50,000 50,000 39203 Transfers 10,000 10,000 10,000 0 35,000 35,000 I Totals 61,269 79,845 261,500 219,235 87,000 87,000 EXPENSES I Code Actual Actual. Budget YTD Sept Proposed Adopted # ITEM 1999 2000 2001 2001 2002 2002 PERSONAL SERVICES I 101 Regular Salaries 1,270 1,873 7,358 1,500 18,051 18,051 102 O.T. Salaries 45 0 0 I 103 Part Time Salaries 0 0 121 PERA City Share 66 99 381 78 998 998 122 FICA City Share 81 134 563 109 1,381 1,381 I 131 Ins. City Share 102 190 950 162 3,025 3,025 Total 1,519 2,340 9,252 1,848 23,455 23,455 SUPPLIES I 200 Office Supplies 221 Maint-Equipment I 240 Small Tools 245 General Supplies 1,370 642 4,000 292 1,795 1,795 Total 1,370 642 4,000 292 1,795 1.795 I OTHER SERVICES & CHARGES 301 Financial & Audit 0 I 303 Engineering 8,997 3,985 5,000 13,111 5,000 5,000 304 Legal 0 321 Communication 0 I 331 Travel, Conf,Sch 0 351 Print/Publish 13 0 90 100 100 360 Insurance-Total 0 I 400 . Contractual 1,689 . 2,358 7,000 4,415 7,000 7,000 420 Depreciation 1,094 2,920 3,000 3,000 433 Subscrip-Member 0 I 440 Misc. Services 74 0 3,034 3,500 3,500 450 Service Charges 166 176 150 72 150 150 Total 10,852 7,699 12,150 23,641 18,750 18,750 I CAPITAL OUTLAY 580 Other Improvements 25,801 14,500 2,700 15,000 15,000 I Total 25,801 0 14,500 2,700 15,000 15,000 TRANSFERS 720 Permanent 0 225,000 0 28,000 28,000 I Total 0 0 225,000 0 28,000 28,000 TOTAL ACCOUNT 39,542 10,682 264,902 28,481 87,000 87,000 I 148 I I BUDGET COMMENTS: STORMWATER MANAGEMENT FUND REVENUES I 37410 Stormwater Utilty Fees 36270 Grant Money from Watershed District for Gideon Glen purchase ($200,000 - 2001) 39203 Interfund Loan transfer in from Sewer Fund for Gideon Glen Purchase ($400,000 - 2000) Transfer in from Genl Fund ($10,000 - 2001; $35,000 - 2002) I EXPENSES I I I I CODE # 101 .10 City Administrator .05 City Engineer .10 Senior Accounting Clerk .10 Light Equipment Operator I 245 Culverts and Appurtences Catch Basin Frames, Rings and Grates I 303 Internal & Contractual Engineering for Storm Drainage System 400 Contractual Repairs to Storm Drainage System I I 580 Gideon Glen Project - Year 2000 Land Purchase ($400,000) Edgewood Rd Culvert Replacement Project (Yr 2001 - $50,000) I I 720 Transfer out to Sewer Fund - Grant proceeds for Loan Repayment ($200,000 - 2001) Transfers out to Sewer Fund - Gideon Glen Loan Repayment ($28,000 prin + int. - 2002) I I I I I 149 I FUND: #640 FUND: Liquor DEPT #49750 I BUDGET Actual Actual Budget YTD Aug Proposed Adopted ITEM 1999 2000 2001 2001 2002 2002 I SALES 37811 Liquor 703,023 763,377 805,565 505,508 804,500 804,500 37812 Wine 506,556 600,790 596,520 379,594 629,500 629,500 I 37813 Beer 991,562 1,051,458 1,167,065 735,891 1,120,700 1,120,700 37814 Miscellaneous 119,023 116,753 293,850 82,999 137,430 137,430 TOTAL SALES 2,320,164 2,532,379 2,863,000 1,703,992 2,692,130 2,692,130 I COST OF GOODS SOLD 251 Liquor 581 ,180 587,249 684,918 349,940 632,750 632,750 I 252 Wine 360,246 406,147 473,271 186,336 427,500 427,500 253 Beer 800,985 817,903 956,389 514,451 885,500 885,500 254 Miscellaneous 95,509 76,770 89,932 59,983 89,114 89,114 I TOTAL COST OF GOODS SOLD 1,837,920 1,888,069 2,204,510 1,110,710 2,034,864 2,034,864 GROSS PROFIT 482,244 644,310 658,490 593,283 657,266 657,266 EXPENSES 0.79215 0.74557 0.77000 0.65183 0.75586 0.75586 I PERSONAL SERVICES 101 Regular Salaries 108,085 136,674 151,250 100,766 203,491 203,491 102 O.T. Salaries 628 659 0 156 0 0 I 103 Part Time Salaries 71,177 79,270 87,572 55,440 54,000 54,000 121 PERA City Share 7,094 8,669 12,538 6,239 11,811 11,811 122 FICA City Share 13,594 16,203 18,270 11,949 15,400 15,400 I 131 Ins. City Share 8,876 12,890 17,600 11,638 18,000 18,000 141 Unemployment Comp 151 Workers Comp I Total 209,454 254,365 287,230 186,188 302,702 302,702 SUPPLIES I 200 Office Supplies 1,418 583 600 759 975 975 201 Postage 234 201 525 0 300 300 221 Maint-Equipment 4,765 5,499 5,100 4,759 4,900 4,900 I 223 Maint-Buildings 58 1,174 650 1,142 650 650 245 General Supplies 6,434 7,398 6,450 3,224 .4,500 4,500 Total 12,909 14,854 13,325 9,885 11,325 11,325 I OTHER SERVICES 301 Audit & Accounting 3,003 3,329 4,100 4,148 4,275 4,275 302 Consulting Fees 0 550 0 0 0 0 I 304 Legal 1,126 0 0 150 0 0 321 Communication 2,642 4,266 4,050 3,179 4,500 4,500 331 Travel, Conf,Sch 608 1,430 2,250 2,432 3,000 3,000 I 342 Advertising & Promo 7,983 8,986 12,000 6,768 12,000 12,000 351 Print/Publish 1,657 934 1,800 342 1,200 1,200 360 Insurance-Total 15,193 11,836 18,100 8,396 14,200 14,200 I 380 Utilities-Gas/Elec 22,479 22,522 25,250 15,689 22,400 22,400 400 Contractual 2,270 2,116 3,050 1,829 2,460 2,460 I 410 Rent 149,822 169,222 179,585 116,792 166,000 166,000 150 I I I 420 Depreciation 9,489 6,609 9,490 5,456 6,770 6,770 432 Uncollectible Checks 3,207 2,624 1,500 0 1,500 1,500 433 Dues & Subscriptions 515 785 600 640 900 900 I 437 Taxes/Licenses 860 1,360 3,000 750 860 860 440 Misc Services 778 0 0 0 0 0 445 Credit Card Fees 17,919 21,120 20,250 13,581 21,900 21,900 I Total 239,551 257,690 285,025 180,151 261,965 261,965 CAPITAL OUTLAY I 560 Furniture & Fixtures 0 0 50,000 9,365 40,000 40,000 Total 0 0 50,000 9,365 40,000 40,000 TOTAL EXPENSES 461,914 526,909 635,580 385,589 615,992 615,992 I TOTAL OPERATING INCOME/(LOSS) 20,330 117,401 22,910 207,694 41,274 41,274 720 Transfers In/(Out) 0 (10,000) (10,000) 0 (30,000) (30,000) Misc Revenue/(Expense) 14,916 22,195 9,400 (4,876) 10,000 10,000 I NET INCOME/(LOSS) 35,246 129,596 22,310 202,818 21,274 21,274 I I I I I I I I I I I I 151 FUND: #640 FUND: LIQUOR HIGHLIGHTS/COMMENTS: Revenues: Estimated liquor sales less cost of goods sold Expenses: Staffi ng: 1.00 Operations Manager 5.00 Assistant Manager .15 Senior Accounting Clerk 14.00 Part time Sales Clerks 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: Misc. Revenue/Expenditures: Interest Income & Service Charges I I I I I I I I I I I I I I I I I I 152 I I FUND: #641 SUBFUND: Liquor - Shorewood Plaza DEPT #49750 I BUDGET Actual Actual Budget YTD Aug Proposed Adopted ITEM 1999 2000 2001 2001 2002 2002 SALES I 37811 Liquor 324,650 351,891 350,900 219,263 355,000 355,000 37812 Wine 248,477 310,125 290,400 190,850 322,000 322,000 37813 Beer 365,451 391,103 423,500 264,057 395,000 395,000 I 37814 Miscellaneous 40,240 40,837 145,200 27,533 43,500 43,500 TOTAL SALES 978,818 1,093,956 1,210,000 701,703 1,115,500 1,115,500 COST OF GOODS SOLD I 251 Liquor 272,379 274,718 315,649 146,371 285,000 285,000 252 Wine 180,165 213,202 244,968 84,361 218,000 218,000 I 253 Beer 304,539 300,781 345,595 182,043 310,000 310,000 254 Miscellaneous 35,147 22,183 25,488 23,273 23,625 23,625 TOTAL COST OF GOODS SOLD 792,228 810,884 931,700 436,048 836,625 836,625 I GROSS PROFIT 186,590 283,072 278,300 265,655 278,875 278,875 EXPENSES I PERSONAL SERVICES 101 Regular Salaries 32,252 47,201 50,000 33,832 78,608 78,608 102 OT. Salaries 244 346 0 25 0 0 I 103 Part Time Salaries 30,580 35,678 36,024 24,848 20,000 20,000 121 PERA City Share 2,398 2,897 4,516 2,235 4,561 4,561 122 FICA City Share 4,780 6,269 6,581 4,489 6,500 6,500 I 131 Ins. City Share 2,652 4,133 6,700 3,413 7,150 7,150 141 Unemployment Comp 2,332 4,711 0 275 0 0 151 Workers Comp 0 0 0 0 0 I Total 75,238 101,236 103,821 69,116 116,819 116,819 SUPPLIES 200 Office Supplies 1,138 179 300 211 325 325 I 201 Postage 78 67 175 0 100 100 221 Maint-Equipment 2,335 2,186 2,500 2,133 2,400 2,400 223 Maint-Buildings 58 983 650 272 650 650 I 245 General Supplies 3,540 2,712 2,650 880 1,500 1,500 Total 7,149 6,127 6,275 3,496 4,975 4,975 I OTHER SERVICES 301 Audit & Accounting 863 1,042 1,200 1,383 1,425 1,425 302 Consulting Fees 0 0 0 0 0 I 304 Legal 162 0 0 50 0 0 321 Communication 1,067 1,438 1,650 970 1,500 1,500 331 Travel, Conf,Sch 250 529 750 944 1,000 1,000 I 342 Advertising & Promo 3,635 3,283 4,300 2,202 4,000 4,000 351 Print/Publish 460 311 600 114 400 400 360 Insurance-Total 5,754 3,871 6,200 2,271 4,200 4,200 I 380 Utilities-Gas/Elec 8,277 7,994 9,000 5,050 7,800 7,800 400 Contractual 756 474 650 223 500 500 410 Rent 45,787 60,774 60,000 42,523 65,000 65,000 I 420 Depreciation 1,365 244 1,365 280 420 420 I 153 432 Uncollectible Checks 913 372 500 0 500 500 I 433 Dues & Subscriptions 172 262 200 213 300 300 437 Taxes/Licenses 270 270 600 250 270 270 I 440 Mise Services 240 0 0 0 0 0 445 Credit Card Fees 8,299 9,567 9,600 6,047 9,500 9,500 Total 78,270 90,431 96,615 62,520 96,815 96,815 I CAPITAL OUTLAY 560 Furniture & Fixtures 50,000 8,992 40,000 40,000 Total 0 0 50,000 8,992 40,000 40,000 I TOTAL EXPENSES 167,126 197,794 256,711 144,124 258,609 258,609 TOTAL OPERATING INCOME/(LOSS) 19,464 85,278 21,589 121,531 20,266 20,266 I 720 Transfers In/(Out) (5,000) (10,OOO) 0 (15,000) (15,000) Misc Revenue/(Expense) 9,285 14,813 5,000 (726) 10,000 10,000 NET INCOME/{LOSS) 28,749 95,091 16,589 120,804 15,266 15,266 I I I I I I I I I I I I I 154 I I FUND: #641 SUBFUND: Liquor - Shorewood Plaza I HIGHLIGHTS/COMMENTS: I Revenues: Estimated liquor sales I Expenses: I Staffing: .33 Operations Manager 2.20 Assistant Manager .05 Senior Accounting Clerk 5.00 Part time Sales Clerks I I Supplies/Materials: I Office Supplies, Bags, Postage Other Services: I 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 I I I Capital Outlay: I Misc. Revenue/Expenditures: Interest Income & Service Charges I I I I I I 155 FUND: #642 SUBFUND: Liquor - Waterford DEPT #49750 I BUDGET Actual Actual Budget YTD Aug Proposed Adopted I ITEM 1999 2000 2001 2001 2002 2002 SALES 37811 Liquor 198,472 205,987 233,400 144,119 227,250 227,250 I 37812 Wine 154,708 159,606 175,000 106,609 172,500 172,500 37813 Beer 314,501 312,944 358,400 221,980 344,700 344,700 37814 Miscellaneous 35,583 31,896 66,700 22,670 38,730 38,730 I TOTAL SALES 703,264 710,433 833,500 495,378 783,180 783,180 COST OF GOODS SOLD I 251 Liquor 155,683 155,225 184,739 103,967 172,750 172,750 252 Wine 103,620 115,258 137,173 65,392 125,000 125,000 253 Beer 244,073 244,727 291 ,259 155,275 268,000 268,000 I 254 Miscellaneous 26,712 24,051 28,624 13,007 29,467 29,467 TOTAL COST OF GOODS SOLD 530,085 539,260 641,795 337,641 595,217 595,217 GROSS PROFIT 173,179 171,173 191,705 157,737 187,963 187,963 I EXPENSES PERSONAL SERVICES I 101 Regular Salaries 37,717 42,541 50,000 30,117 59,469 59,469 102 OT. Salaries 44 0 0 0 0 0 103 Part Time Salaries 16,514 18,110 23,524 12,994 17,000 17,000 I 121 PERA City Share 2,243 2,542 3,860 1,691 3,600 3,600 122 FICA City Share 4,072 4,525 5,625 3,296 3,800 3,800 131 Ins. City Share 3,109 4,467 5,200 3,397 5,200 5,200 I 141 Unemployment Comp 0 0 10 0 0 151 Workers Comp 0 0 0 0 0 Total 63,699 72,186 88,209 51,506 89,069 89,069 I SUPPLIES 200 Office Supplies 175 179 150 280 325 325 201 Postage 78 67 175 0 100 100 I 221 Maint-Equipment 1 ,450 1,439 2,000 1,200 1,500 1,500 223 Maint-Buildings 0 0 526 0 0 245 General Supplies 1,509 2,336 2,400 1 ,405 1,500 1,500 I Total 3,212 4,020 4,725 3,411 3,425 3,425 OTHER SERVICES I 301 Audit & Accounting 863 1,042 1,200 1,383 1,425 1,425 302 Consulting Fees 0 0 0 0 0 0 304 Legal 802 0 0 50 0 0 I 321 Communication 1,091 1 ,482 1,500 989 1,500 1,500 331 Travel, Conf,Sch 179 451 750 798 1,000 1,000 342 Advertising & Promo 3,216 2,891 4,400 2,619 4,000 4,000 I 351 Print/Publish 461 311 600 114 400 400 360 Insurance-Total 4,602 3,213 6,200 2,258 4,200 4,200 380 Utilities-Gas/Elec 7,880 7,579 9,100 5,060 6,000 6,000 I 400 Contractual 396 660 1,250 440 660 660 410 Rent 84,205 85,021 93,000 63,369 61,000 61,000 420 Depreciation 7,874 5,816 7,875 3,816 5,800 5,800 I 156 I I 432 Uncollectible Checks 1,523 1,360 500 0 500 500 433 Dues & Subscriptions 171 262 200 213 300 300 I 437 Taxes/Licenses 270 270 600 250 270 270 440 Misc Services 262 0 0 0 0 0 445 Credit Card Fees 5,842 6,954 6,350 4,112 7,000 7,000 I Total 121,231 117,313 133,525 85.472 94,055 94,055 CAPITAL OUTLAY 560 Furniture & Fixtures 373 0 0 I Total 0 0 0 373 0 0 TOTAL EXPENSES 188,142 193,519 226.459 140,762 186,549 186,549 I TOTAL OPERATING INCOMEf(LOSS) (14,963) (22,346) (34,754) 16,975 1.414 1.414 720 Transfers In/(Out) Misc Revenue/(Expense) 908 (911 ) (3.458 ) 0 0 I NET INCOME/(LOSS) (14,055) (23,257) (34,754) 13,517 1.414 1,414 I I I I I I I I I I I I I 157 FUND: #642 SUB FUND: Liquor - Waterford I HIGHLIGHTS/COMMENTS: I Revenues: Estimated liquor sales I Expenses: I Staffing: I .33 Operations Manager 1 .00 Assistant Manager .05 Senior Accounting Clerk 5.00 Part time Sales Clerks I Supplies/Materials: I Office Supplies, Bags, Postage I 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 I I I Capital Outlay: I Misc. Revenue/Expenditures: I Interest Income & Service Charges I I I I I 158 I I FUND: #643 SUBFUND: Liquor - Tonka Bay DEPT #49750 I BUDGET Actual Actual Budget YTD Aug Proposed Adopted ITEM 1999 2000 2001 2001 2002 2002 ~ I 37811 Liquor 179,901 205,499 221,265 142,126 222,250 222,250 37812 Wine 103,371 131,060 131,120 82,136 135,000 135,000 37813 Beer 311,610 347,410 385,165 249,854 381,000 381,000 I 37814 Miscellaneous 43,200 44,020 81,950 32,796 55,200 55,200 TOTAL SALES 638,082 727,990 819,500 506,912 793,450 793,450 COST OF GOODS SOLD I 251 Liquor 153,118 157,307 184,529 99,602 175,000 175,000 252 Wine 76,461 77,687 91,131 36,583 84,500 84,500 I 253 Beer 252,373 272,396 319,535 177,133 307,500 307,500 254 Miscellaneous 33,650 30,536 35,820 23,703 36,022 36,022 TOTAL COST OF GOODS SOLD 515,602 537,925 631,015 337,021 603,022 603,022 I GROSS PROFIT 122,480 190,065 188,485 169,890 190,428 190,428 EXPENSES I PERSONAL SERVICES 101 Regular Salaries 38,116 46,932 51,250 36,817 65,414 65,414 102 O.T. Salaries 340 313 0 131 0 0 I 103 Part Time Salaries 24,083 25,481 28,024 17,599 17,000 17,000 121 PERA City Share 2,453 3,230 4,162 2,313 3,650 3,650 122 FICA City Share 4,742 5,409 6,064 4,164 5,100 5,100 I 131 Ins. City Share 3,115 4,289 5,700 4,828 5,650 5,650 141 Unemployment Camp 0 0 0 10 0 0 151 Workers Camp 0 0 0 0 0 0 I Total 72,849 85,655 95,200 65,862 96,814 96,814 SUPPLIES 200 Office Supplies 105 225 150 268 325 325 I 201 Postage 78 67 175 0 100 100 221 Maint-Equipment 980 1,874 600 1,426 1,000 1,000 223 Maint-Buildings 191 0 344 0 0 I 245 General Supplies 1,385 2,350 1,400 939 1,500 1,500 Total 2,548 4,707 2,325 2,978 2,925 2,925 I OTHER SERVICES 301 Audit & Accounting 1,277 1,245 1,700 1,383 1,425 1 ,425 302 Consulting Fees 550 0 0 0 0 I 304 Legal 162 0 0 50 0 0 321 Communication 484 1,346 900 1,219 1,500 1,500 331 Travel, Conf, School 179 451 750 690 1,000 1,000 I 342 Advertising & Promo 1,132 2,812 3,300 1,947 4,000 4,000 351 Print/Publish 736 311 600 114 400 400 360 Insurance-Total 4,837 4,752 5,700 3,866 5,800 5,800 I 380 Utilities-Gas/Elec 6,322 6,949 7,150 5,578 8,600 8,600 400 Contractual 1,118 982 1,150 1,166 1,300 1,300 410 Rent 19,830 23,427 26,585 10,900 40,000 40,000 I 420 Depreciation 250 549 250 1,360 550 550 I 159 432 Uncollectible Checks 771 892 500 0 500 500 I 433 Dues & Subscriptions 172 262 200 213 300 300 437 Taxes/Licenses 320 820 1,800 250 320 320 I 440 Misc Services 276 0 0 0 0 0 445 Credit Card Fees 3,778 4,599 4,300 . 3,422 5,400 5,400 Total 42,750 49,946 54,885 32,158 71,095 71,095 I CAPITAL OUTLAY 560 Furniture & Fixtures Total 0 0 0 0 0 0 I TOTAL EXPENSES 118,147 140,307 152,410 100,998 170,834 170,834 TOTAL OPERATING INCOME/(LOSS) 4,333 49,758 36,075 68,892 19,594 19,594 I 720 Transfers In/(Out) (5,000) 0 (15,000) (15,000) Misc Revenue/(Expense) 4,723 8,293 4,400 (691 ) 0 0 NET INCOME/(LOSS) 9,056 53,051 40,475 68,201 4,594 4,594 I I I I I I I I I I I I I 160 I I FUND: #643 SUBFUND: Liquor - Tonka Bay I HIGHLIGHTS/COMMENTS: I Revenues: I Estimated liquor sales Expenses: I Staffing: I .33 Operations Manager 1.40 Assistant Manager .05 Senior Accounting Clerk 4.00 Part time Sales Clerks I Supplies/Materials: I Office Supplies, Bags, Postage I Other Services: I 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 I I Capital Outlay: I I Misc. Revenue/Expenditures: Interest Income & Service Charges I I I I I 161