The URL can be used to link to this page

07-25-11 WS Agenda CITY OF SHOREWOOD 5755 COUNTRY CLUB ROAD CITY COUNCIL WORK SESSION COUNCIL CHAMBERS MONDAY, JULY 25, 2011 6:00 P.M. AGENDA Attachments 1. CONVENE CITY COUNCIL WORK SESSION A. Roll Call Mayor Lizée ____ Hotvet____ Siakel ____ Woodruff____ Zerby ____ B. Review Agenda 2. 2011 GENERAL FUND OPERATING BUDGET Finance Director’s memo 3. ADJOURN MEMORANDUM Date: July 25, 2011 To: Mayor Lizee Council Members From: Bruce DeJong, Finance Director Re: 2012 Budget Review For your reading pleasure, we have provided a lot of the information requested at the last work session. The list of programs for the priority - driven budget process leads the way. We have included the department mission and activities as way of background to explain what each area of the budget intends to accomplish. We also have a listing of staffing allocations that were used in developing the budget. The 2012 budget has been a moving target. Staff discovered that the 2011 performance -based salary adjustments had not been updated in the spreadsheets so those have been changed. The Southshore Community Center will require some amount of subsidy in order to fund its operations, so $13,600 has been added to the budget as an intial estimate. Because the Priority Driven Budget sheet was prepared earlier this week, it does have old total budget dollars that are no longer entirely accurate. Staff looks forward to discussing the budget further on Monday evening. Attachment: Priority Driven Budget sheet Staffing Allocations Department Mission and Activity Summaries 2012 Detailed Budget Sheets PRIORITY DRIVEN BUDGET Internal Support Functions Finance Support all departments, utility billing, purchasing, etc. Estimated Estimated Group and Program Description Cost $ Staff allocation Community Protection Elections Supports and ensures free and fair elections are conducted $ 22,481 Police SLMPD agreement for services $ 1,008,576 15.50 Fire EFD agreement for services $ 332,805 2.50 Protective Inspections Building inspections code enforcement $ 114,746 1.00 0.10 $ 1,456,127 19.00 Debt Service Contractual Services Other Public safety Facility EDA bonds for the public safety facility $ 507,972 22,500 City Hall Remodel EDA bonds for city hall remodel $ 103,950 33,000 Legal Civil $ 611,922 47,500 Roads and Trails Assessing Assessing services and value reveiws $ 96,000 Snow and Ice $ 101,684 0.70 Road program Implementation of 20 year improvement program funded by transfer $ 721,000 Traffic Control Generally covers the cost of electricity for street lights and stop lights $ 57,149 Trail Development Capital projection to implement proposed trail program $ 6,500 General Road maintenance Patching and other general activities (staff and supplies) $ 232,459 1.65 Engineering Staff, consultants, etc. necessary to carryout road programs and maintenance $ 1.23,263 1.10 $ 1,242,055 3.45 Communications Newsletter Monthly publication both paper and electronic $ 50,344 0.40 Website Generally covers staff time associated with maintenance and development $ 50,522 0.60 Other publications Fliers, brochures, publications, etc. $ 5,500 $ 106,366 1.00 Parks and Recreation Park Improvements Funded by transfers from general fund to cover capital improvements $ 42,000 General park Maintenance Mowing, labor, general maintenance, garbage /recycling, etc $ 245,508 1.70 Contracutal services Park Coordinator, life guards, etc. $ 59,500 Recreation programs Free Fridays, safety camp, fireworks, movie /music, arctic fever, etc. $ 55,395 0.60 $ 402,403 2.30 City Council Establish policy and overall direction for the City $ 118,030 5.00 Internal Support Functions Finance Support all departments, utility billing, purchasing, etc. $ 166,274 1.50 General Govt Supports engineering, PW, Adminsitration, Reception, etc. $ 138,466 1.90 Elections Supports and ensures free and fair elections are conducted $ 22,481 Administration coordinates council policy, labor, HR, Legal, etc. $ 148,718 1.25 Public Works Services coordination, maintenance of equipment, purchasing, etc. $ 356,747 2.20 Municipal buildings Provides for repair, maintenance, support of public buildings $ 174,250 0.10 $ 1,006,936 6.95 Contractual Services Other Audit provides the annual audit ofthe city's financials $ 22,500 Legal Prosecution Criminal prosecution except for code violations $ 33,000 Legal Civil Covers general legal advice and support, code enforcement, ordinance review $ 47,500 Assessing Assessing services and value reveiws $ 96,000 $ 199,000 Land Use and Economic Dev Coordinates and enforces land use and economic development in the city Environmental AIS Prevention Contribution to LMA for Phelps and Guideon Bay's Milfoil Treatment Sanitation /Waste removal Provides for Spring clean -up activities Trees Tree trimming, removal, and disposal Deer management Staff time to coordinate with deer hunters and residents $ 169,017 1.60 $ 6,000 $ 6,781 $ 28,695 0.40 $ 11,744 0.10 $ 53,220 0.50 $ 5,247,046 34.80 -1- I O O O °o °o °o Co C o 0' Cl Co fo I N ° F i t E 1 � 0 0 C ( to O ° I Vl IIl I tI11 O O Vl Vl rl O v CIO .... Ion J -O� ri Om O o� OO O O O ON a W O C OI O L J� LATO C I- oI � o ico v �o v nI wl o i O o o o Qf I ° V Oi IO v O O O Oi0 UJ � ¢ � J LL J 0. J i I�£��ILA J Q Q U U V d LL In 0 m = Z h9. v N N T it m m pj L mm N I L Y Y ° c O _ J_u.m o oluI lJ x x G G z xzl ni d "nl n'IN I 2- City Council 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. DESCRIPTION OF ACTIVITY: The City Council meets twice monthly and in periodic special work sessions to consider and adopt legislative and administrative policies that pertain to the services provided to residents. The City Council also sits as the Shorewood Economic Development Authority (EDA). Administration 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 DESCRIPTION OF ACTIVITY: The City Administrator directs City departmental operations to ensure compliance with policies established by the City Council and with state and federal laws The department supports the City Council by managing Council agendas, directing the flow of information and requests for action to the Council. General Government DEPARTMENT MISSION: Provide staff support for the City Council including preparation of agendas and meeting packets. Responsible for City Clerk functions including records retention, notices, and licenses. DESCRIPTION OF ACTIVITY: This department provides for reception and clerical duties in the City offices, and the recording secretary for City Council meetings. ` ]'his department is the official record keeper of minutes, contracts, and permanent records; and is also responsible for all licensing functions and City communication tools. 3- Finance DEPARTMENT MISSION: The finance department's goal is to present accurate, timely, and complete financial information in an understandable and friendly manner to the council, residents, and staff members of the city; and to protect and manage the assets of the city as directed by the City Council. DESCRIPTION OF ACTIVIT The finance department 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, and financial reporting The finance department also produces the following documents, with the assistance of other city departments: The annual operating budget, the Comprehensive Annual Financial Report (CAFR), and the five -year Capital Improvement Program (CIP). Professional Services DEPARTMENT MISSION: Provide contracted professional services including general legal, prosecution, financial audit, and property assessment. DESCRIPTION OF ACTIVI This department provides for contracted legal, assessing, and auditing services for the City. Legal services include general counsel to the City Council, litigation, and prosecution of criminal misdemeanors. Assessing services provide property valuation information for tax purposes. Audit services provide for the annual financial audit required by Minnesota State Statutes. Planning DEPARTMENT MISSION': Guide and control the physical development of the community. Coordinate and implement long range city -wide and area planning activities. 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, fioodplain, and other planning and zoning related ordinances. Municipal Buildings 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' comp insurance. DESCRIPTION OF ACTIVITY: -4- 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 coverage's are also provided under this department. Protective Inspections DEPARTMENT MISSION: Enforce construction safety and related building codes through plan review and inspections. 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 zoning violations. City Engineer DEPARTMENT MISSION: Provide engineering and construction management services for the City. 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. Public Works Services DEPARTMENT MISSION: Provide supervision and support for all public works functions; provides for public works utilities, shop and equipment maintenance and fuels. 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 public works facilities. Streets DEPARTMENT MISSION: To maintain and upgrade City streets, parking areas and storm water control systems in an efficient and economical manner DESCRIPTION OF ACT Includes ongoing maintenance consisting of street patching, street sweeping, roadside mowing, painting of lane markings, and minor storm sewer repair. -5- Snow and Iee Control DEPARTMENT MISSION: Provide snow and ice control for public streets and City owned parking lots to ensure the safe and efficient movement of traffic. DESCRIPTION OF ACT IVITY: This department is responsible for the plowing and removal of snow after a 2 -inch or greater snowfall has occurred. Street sanding with a salt /sand mixture is used as a measure of ice control, and is performed as needed. Traffic Control DE PARTMENT MISSION: Provide for street lighting and traffic signals at intersections and other locations throughout the City for the safety of pedestrians and vehicular traffic. DESCRIPTION OF ACTIVITY: Includes maintenance 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. Sanitation DEPARTMENT MISSION: Provide for the general sanitation and cleanliness of the City and provide for the treatment of noxious weeds on City properties. DESCRIPTION OF ACTIVIT 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. Trees 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. 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 residents on an on -call basis. Parks 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. s- DESCRIPTION OF ACTIVITY The department is responsible for the maintenance of all City parks; including playgrounds, ball fields, trails, ice rinks, buildings, and other play areas. The department also develops and coordinates Winter ice skating and summer recreation programs such as movie in the park, music in the park, safety camp, fins program, zoo mobile, kayaking, life guards, etc. -7- GENERAL FUND BUDGET DETAIL REVENUES TAXES 31010 GENERAL PROPERTY TAX 31010 SPECIAL LEVY 31020 DELINQUENT AD VALOREM TAXES 31040 FISCAL DISPARITIES TOTAL TAXES LICENSES & PERMITS 32110 LIQUOR LICENSES 32120 TOBACCO LICENSES 32160 TREE TRIMMING LICENSES 32175 RENTAL HOUSING LICENSES 32180 OTHER BUSINESS LICENSES AND PE 32210 BUILDING PERMITS 32215 PLAN CHECK FEES 32240 DOG LICENSES 32250 HORSE PERMITS 32260 OTHER NON- BUSINESS LICENSES AN TOTAL LICENSES & PERMITS INTERGOVERNMENTAL 33130 FEDERAL GRANTS - COMMUNITY DEVEL 33160 FEMA STORM DISASTER AID 33401 LOCAL GOVERNMENT AID 33403 MKT VALUE CREDIT AID 33404 PERA AID 33418 MUNICIPAL STATE AID FOR STREET 33422 STATE SNOW REMOVAL /STORM DISAS 33630 METRO COUNCIL COMM DEV PLANNIN TOTAL INTERGOVERNMENTAL CHARGES FOR SERVICES 34000 CHARGES FOR SERVICES 34101 CITY HALL RENT 34103 ZONING AND SUBDIVISION FEES 34104 PASS -THRU CHARGES 34105 SALE OF COPIES 34107 SPECIAL ASSESSMENT SEARCHES 34108 ENGINEERING CHARGES TO OTHER 34110 ELECTION FILING FEES 34780 PARK FEES & RENTALS 34785 PARK DONATIONS 34790 CRESCENT BEACH REIMBURSEMENTS TOTAL CHARGES FOR SERVICES FINES & FORFEITURES 35101 FINES & FORFEITS TOTAL FINES & FORFEITURES Actual Actual Adopted To Date Requested Percent Dollar 2009 2010 2011 2011 2012 Change Change 3,899,749 4,030,047 4,158,672 1,656,000 4,158,672 0.05 - 617,620 617,620 604,647 722 604,647 0.0% - 62,141 6,725 - - - - 123,858 63,140 - - - - 4,703,368 4,717,532 4,763,319 1,656,000 4,763,319 1.0% 45,787 8,320 810 8,300 8,820 8,300 0.0% - 1,000 825 1,000 - 1,000 0.0% - 630 570 450 180 450 0.0% - 1,020 1,440 1,000 360 1,000 0.0% - 3,555 4,940 3,100 7,462 3,100 0.0% - 97,651 118,189 70,000 58,626 80,000 14.3% 10,000 12,336 23,679 11,000 11,469 12,000 9.1% 1,000 3,321 3,609 3,300 1,758 3,300 0.0% - 50 50 50 25 50 0.0% - 127,883 154,112 98,200 88,700 109,200 -29.19/ (44,912) 189 f265) - - - - 4,751 4,751 4,751 - 4,751 0.0% - 61,471 64,646 64,650 34,109 64,650 0.0% - 66,411 69,132 69,401 34,109 69,401 0.4% 269 7,493 - - - 5,738 2,824 4,500 1,692 4,500 0.0% - 4,750 - (1,500) - 913 722 1,000 201 1,000 0.0% 110 190 150 75 150 0.0% 325 250 425 275 425 0.0% 27,070 34,146 29,000 21,393 29,000 0.0% 41,649 42,882 35,075 22,136 35,075 -18.2% (7,807) 52,968 55,806 52,000 20,386 54,500 4.8% 2,500 52,968 55,806 52,000 20,386 54,500 -2.3% (1,306) Page 1 -8- GENERAL FUND BUDGET DETAIL Page 2 -9- Actual Actual Adopted To Date Requested Percent Dollar 2009 2010 2011 2011 2012 Change Change MISCELLANEOUS REVENUE 36210 INTEREST EARNINGS 58,624 38,968 45,000 12,372 45,000 0.0% - 36230 CONTRIBUTIONS AND DONATIONS FR 820 - - 1,040 - - 36240 REFUNDS & REIMBURSEMENTS 11,349 13,423 - 2,020 - - 36250 POP MACHINE REVENUE - - - - - - 36260 DRY HYDRANT CHARGES 3,332 (125) 3,500 3 3,500 0.0% - 36265 CELLULAR ANTENNA REVENUE - - - - - 36270 MISCELLANEOUS REVENUE 8,236 26,111 15,000 9,098 15,000 0.0% - 36275 CONCESSIONS /VENDING 394 394 400 - 400 0.0% - TOTALMISCELLANEOUSREVENUE 82,755 78,771 63,900 24,533 63,900 -18.9% (14,871) TRANSFERS 39202 TRANSFERS FROM ENTERPRISE FUND 40,000 - 40,000 - - - 100.0% (40,000) 39203 TRANSFERS FROM OTHER FUNDS - 33,465 - - - TOTALTRANSFERS 40,000 33,465 40,000 - - - 100.0% (40,000) TOTAL REVENUES 5,115,034 5,151,700 5,121,895 1,845,864 5,095,395 - 167.2% (62,840) EXPENDITURES CITY COUNCIL Personnel 16,794 16,794 16,800 8,397 16,800 0.0% - Materials and Supplies 3,064 1,175 1,300 619 3,000 130.8% 1,700 Support Services and Charges 46,158 45,776 102,430 32,812 71,590 -30.1% (30,840) Transfers - - - - 13,600 - 13,600 Total City Council 66,016 63,745 120,530 41,828 104,990 -12.9% (15,540) Administration Personnel 149,286 144,743 142,828 70,418 149,083 4.4% 6,255 Materials and Supplies 40 - - - - - Support Services and Charges 7,909 3,153 4,760 3,092 5,990 25.8% 1,230 Capital 1,631 - 1,631 - - - 100.0% (1,631) Total City Administration 158,866 147,896 149,219 73,510 155,073 3.9% 5,854 GENERAL GOVERNMENT Personnel 219,756 214,687 226,387 118,916 228,040 0.7% 1,653 Materials and Supplies 17,860 14,564 18,500 5,917 18,670 0.9% 170 Support Services and Charges 31,507 31,220 32,350 15,056 32,670 1.0% 320 Capital 6,540 1,213 - - - - Total General Government 275,663 261,684 277,237 139,889 279,380 0.8% 2,143 ELECTIONS Personnel 840 39,864 4,781 273 15,832 231.1% 11,051 Materials and Supplies 2,024 3,570 2,300 1,665 5,425 135.9% 3,125 Support Services and Charges 25 1,508 - - 1,275 1,275 Capital - - - - - - Total Elections 2,889 44,942 7,081 1,938 22,532 218.2% 15,451 FINANCE Personnel 166,032 147,242 153,224 78,634 160,842 5.0% 7,618 Materials and Supplies 6,952 7,576 6,950 6,967 7,300 5.0% 350 Support Services and Charges 4,799 7,222 6,575 7,222 9,150 39.2% 2,575 Capital 2,483 - - - - - Total Finance 180,266 162,040 166,749 92,823 177,292 6.3% 10,543 PROFESSIONAL SERVICES Support Services and Charges 223,859 178,604 199,000 138,057 199,320 0.2% 320 Page 2 -9- GENERAL FUND BUDGET DETAIL Page 3 -10- Actual Actual Adopted To Date Requested Percent Dollar 2009 2010 2011 2011 2012 Change Change Total Professional Services 223,859 178,604 199,000 138,057 199,320 0.2% 320 PLANNING Personnel 195,474 175,553 170,694 80,294 171,557 0.5% 863 Materials and Supplies 2,138 149 655 156 655 0.0% - Support Services and Charges 8,990 6,882 11,810 4,641 9,412 -20.3% (2,398) Capital - - - - - - Total Planning 206,602 182,584 183,159 85,091 181,624 -0.8% (1,535) MUNICIPAL BUILDINGS Materials and Supplies 34,321 51,244 29,665 16,500 16,500 -44.4% (13,165) Support Services and Charges 123,958 54,496 94,640 157,750 157,750 66.7% 63,110 Capital - 15,713 1,040 - - (1,040) Bond Payments 5,425 2,959 - - - - Transfers 99,773 160,368 - - 103,950 103,950 Total Municipal Buildings 263,477 284,780 125,345 174,250 278,200 121.9% 152,855 POLICE Materials and Supplies - 1,367 - - - - Support Services and Charges 943,989 949,337 995,750 498,693 1,011,300 116% 15,550 Capital 232,940 228,068 230,066 115,034 230,066 0.0% - Total Police 1,176,929 1,178,772 1,225,816 613,727 1,241,366 1.3% 15,550 FIRE Support Services and Charges 323,180 322,535 337,130 168,565 332,805 -1.3% (4,325) Capital 277,270 272,629 270,697 135,349 277,906 2.7% 7,209 Total Fire 600,450 595,164 607,827 303,914 610,711 0.5% 2,884 PROTECTIVE INSPECTIONS Personnel 119,184 115,081 109,096 55,974 110,595 1.4% 1,499 Materials and Supplies 139 28 300 154 200 -33.35P (100) Support Services and Charges 5,647 4,575 6,400 124 5,450 -14.8% (950) Capital 1,298 - 300 - - - 100.0% (300) Total Protective Inspections 126,268 119,684 116,096 56,252 116,245 0.1% 149 CITY ENGINEER Personnel 107,388 94,497 111,103 47,829 112,647 1.4% 1,544 Materials and Supplies 741 152 1,255 4 200 -84.1% (1,055) Support Services and Charges 7,639 8,937 13,320 896 11,960 -10.2% (1,360) Capital 2,854 538 1,000 - - - 100.0% (1,000) Total City Engineer 118,622 104,124 126,678 48,729 124,807 -1.5% (1,871) PUBLIC WORKS SERVICES Personnel 279,601 289,827 184,107 142,187 185,896 1.0% 1,789 Materials and Supplies 58,800 62,149 71,200 39,737 81,200 14.0% 10,000 Support Services and Charges 40,539 41,107 41,440 23,547 41,440 0.0% - Capital 5,003 - - - - - Transfers 175,000 100,000 50,000 - 50,000 0.0% - Total Public Works Services 558,943 493,083 346,747 205,471 358,536 3.4% 11,789 STREETS AND ROADS Personnel 69,846 88,822 113,459 39,552 116,600 2.8% 3,141 Materials and Supplies 53,168 80,253 85,000 30,795 85,000 0.0% - SupportServicesandCharges 27,233 21,274 34,000 1,703 34,000 0.09/. - Capital - - - - - - Transfers 700,000 700,000 700,000 - 721,000 3.0% 21,000 Page 3 -10- GENERAL FUND BUDGET DETAIL SANITATION /WEEDS /WASTE REMOVAL Personnel Actual Actual Adopted To Date Requested Percent Dollar 21 2009 2010 2011 2011 2012 Change Change Total Streets and Roads 850,247 890,349 932,459 72,050 956,600 2.6% 24,141 SNOW AND ICE CONTROL 3,925 6,781 0.0% - TREE MAINTENANCE Personnel 35,995 55,052 56,567 41,341 57,430 1.5% 863 Materials and Supplies 38,457 32,451 45,117 14,211 45,117 0.0% - Support Services and Charges - - - - - 13,250 - Capital - - - - - 0.0% - - Total Snow and Ice Control 74,452 87,503 101,684 55,552 102,547 0.8% 863 TRAFFIC CONTROL 185,708 69,042 185,945 0.1% 237 Materials and Supplies 10,094 14,237 Personnel - - - - - 96,057 - Materials and Supplies 2,873 2,528 5,000 2,214 5,000 0.0% - Support Services and Charges 43,664 40,893 52,149 23,733 52,149 0.0% - Total Traffic Control 46,537 43,421 57,149 25,947 57,149 0.0% - SANITATION /WEEDS /WASTE REMOVAL Personnel 2,764 5,827 2,281 186 2,281 0.0% - Materials and Supplies 21 - 100 - 100 0.0% - Support Services and Charges - 3,210 4,400 3,739 4,400 0.05/. - Total Sanitation /Weeds /Waste Removal 2,785 9,037 6,781 3,925 6,781 0.0% - TREE MAINTENANCE Personnel 7,513 20,625 14,020 9,364 14,020 0.0% - Materials and Supplies 437 107 1,425 170 1,425 0.0% - Support ServicesandCharges 9,501 11,461 13,250 1,460 13,250 0.0% - Total Tree Maintenance 17,451 32,193 28,695 10,994 28,695 0.0% - PARKS AND RECREATION Personnel 147,532 153,637 185,708 69,042 185,945 0.1% 237 Materials and Supplies 10,094 14,237 19,800 12,515 19,800 0.0% - Support ServicesandCharges 109,781 96,057 91,900 44,677 91,900 0.0% - Transfers 45,000 42,000 42,000 - 42,000 0.0% - Total Parks and Recreation 312,407 305,931 339,408 126,234 339,645 0.1% 237 GENERAL FUND TOTAL EXPENDITURES 5,262,729 5,185,536 5,117,661 2,270,181 5,341,493 4.4% 223,832 REVENUE OVER/ (UNDER) EXPENDITURES (147,695) (33,837) 4,234 (424,317) (246,098) Page 4 -11- City Council Expenditure Coding: 101-41110 - Actual Actual Budget To Date Requested Percent Dollar PERSONAL SERVICES 2009 2010 2011 2011 2012 Change Change 101 FULL -TIME REGULAR 102 PULL -TIME OVERTIME 103 PART -TIME 15,600 15,600 15,600 7,800 15,600 0.0% - 106 OTHER 111 SEVERANCE PAY 121 PERA CONTRIB - CITY SHARE - - - - - - 122 FICA CONTRIB - CITY SHARE 1,194 1,194 1,200 597 1,200 0.0% - 131 EMPLOYEE INSURANCE - CITY SHARE 141 UNEMPLOYMENT COMPENSATION 151 WORKERS COMPENSATION TOTAL PERSONAL SERVICES 16,794 16,794 16,800 8,397 16,800 0.0% - MATERIALS & SUPPLIES 245 GENERALSUPPLIES 3,064 1,175 1,300 550 3,000 130.8% 1,700 TOTAL MATERIALS & SUPPLIES 3,064 1,175 1,300 550 3,000 130.8% 1,700 SUPPORT SERVICES /CHARGES 302 CONSULTING FEES - - - - - - 331 TRAVEL, CONFERENCE & SCHOOLS 2,968 2,270 3,500 115 4,500 28.6% 1,000 351 PRINTING AND PUBLISHING - - - - - - 400 CONTRACTUAL SERVICES - - 36,649 - - - 100.0% (36,649) 410 RENTALS - - - - - - 433 DUES AND SUBSCRIPTIONS 43,190 43,506 43,169 21,571 47,690 10.5% 4,521 440 MISC SERVICES - - 19,112 - 19,400 1.5% 288 TOTAL SUPPORT SERVICES /CHARGES 46,158 45,776 102,430 21,686 71,590 -30.1% (30,840) TRANSFERS 720 OPERATING TRANSFERS - - - - 13,600 13,600 TOTAL TRANSFERS - - - - 13,600 13,600 TOTAL Council 66,016 63,745 120,530 30,633 104,990 -12.9% (15,540) BUDGET COMMENTS: MAYOR AND COUNCIL DEPT 41110 Code # 103 Council Salaries: Mayor $300 /mo, Council $250 /mo 331 Travel, Conferences, Schools 2,000 Appreciation Activities 2,500 433 Subscriptions & Memberships Lake Minnetonka Conservation District (LMCD) 30,473 Metro Cities 3,140 League of MN Cities 6,415 Excelsior Chamber of Commerce July 4th 7,500 Metropolitan Mayors 20 Other 142 440 Contingency for non -union wage adjustments 19,400 720 Transfer to Southshore Community Center 13,600 12- ADMINSTRATION Expenditure Coding: 101- 41300- PERSONAL SERVICES 101 FULL -TIME REGULAR 102 FULL -TIME OVERTIME 103 PART -TIME 106 OTHER 111 SEVERANCE PAY 121 PERA /ICMA CONTRIB - CITY SHARE 122 FICA CONTRI B - CITY SHARE 131 EMPLOYr-E INSURANCE - CITYSHARE 141 UNEMPLOYMENT COMPENSATION 151 WORKERS COMPENSATION Actual Actual 2009 2010 115,076 112,654 7,767 7,598 8,680 8,042 11,398 12,482 6,365 3,967 Budget 2011 113,539 8,232 8,686 12,371 To Date 2011 61,299 4,276 4,521 4,451 2,204 Requested Percent Dollar 2012 Change Change 119,794 5.5% 6,255 8,232 0.0% 8,686 0.0% - 12,371 0.0% TOTAL PERSONAL SERVICES 149,286 144,743 142,828 76,750 149,083 4.4% 6,255 MATERIALS & SUPPLIES 221 MAINTENANCE OF EQUIPMENT - - - - - - 24S GENERAL SUPPLIES 40 - - - - TOTAL MATERIALS & SUPPLIES 40 - - - - - SUPPORT SERVICES /CHARGES 321 COMMUNICATIONS - TELEPHONE 944 873 960 S60 960 OD% - 331 TRAVEL, CONFERENCE & SCHOOLS 1,618 1,333 2,700 454 3,670 35.9% 970 400 CONTRACTUAL SERVICES 4,305 - - - - - 433 DUES AND SUBSCRIPTIONS 1,042 947 1,7.00 802 1,360 23.6% 260 440 MISC SERVICES - - - - - - TOTAL SUPPORT SERVICES/CHARGES 7,909 3,153 4,760 1,815 5,990 25.8% 1,230 CAPITAL OUTLAY 540 MACHINERY & EQUIPMENT - 1,631 - 1,631 - - 560 FURNITURE AND FIXTURES - - - - - - 580 OTHER IMPROVEMENTS - - - - TOTAL CAPITAL OUTLAY - 1,631 - 1,631 - - TOTAL ADMINISTRATION 157,235 149,527 147,588 80,197 155,073 5.1% 7,485 BUDGETCOMMENTS: ADMINISTRATION DEPT 41300 Code N 101 1 FTE Administrator, .25 FTE Executive Scretary = Salary and benefits No salary increase, benefits increase included Salary performance based part of merit pool located in Council Contingency 321 Cell Phone reimbursment for base Blackberry Plan only, no fees or taxes included. Employee owns phone 331 Reimbursment for mileage to meetings and events average about $55.00 per month in mileage. Conferences include LMC and MCMA annual conference, travel, meals, lodging- $1,200 1 regional or national conference approximately $1,900 400 Consulting Svcs. 433 Subscriptions & Memberships ICMA = %based on salary approximately 800 810 MCMA = 125 120 MAMA = 40 180 M PE LRA 2S0 1360 13- GENERAL GOVERNMENT Expenditure Coding: 101- 41400- CAPITAL OUTLAY 540 MACHINERY &EQUIPMENT 6,540 1,213 560 FURNITURE AND FIXTURES - - 580 OTHER IMPROVEMENTS TOTAL CAPITAL OUTLAY 6,540 1,213 TOTAL GENERAL GOVERNMENT 275,663 261,684 277,237 277,237 279,380 0.8% BUDGETCOMMENTS: GENERAL GOVERNMENT /CITY CLERK DEPT 41400 Code 4 101 Full -Time Deputy Clerk @ .70 FTE and Receptionist @ .70 FTE. Part -time staff= '65 FTE Communications /recycling coordinator and Web maintenance @ A FTE. 200 Copier /printer paper, pen's, paper clips, etc for all departments. 208 Postage meter fees Newsletter postage (est. $535 /mo) 221 Copier and office equipment maintenance 245 Software upgrades (In- Design, Illustrator, Acrobat and Adobe Photoshop( 331 State Clerks Conference - Jean / Twila Misc. Seminars, Mileage & MCFOA Mugs Training /Educ - Tuition Reimb ($2K -lean / $200 Twila /200 Pat /350 Julie /350 Pamela 351 Legal Notices -All General Fund except Capital Projects 400 Council Packet Delivery & Video Tape Council Recording Secretary Newsletter Mail Service - Midwest Mailing Code Book Web Host Code Book Update Document Image Service Document Destruction Newsletter Printing Service ($875 / month( 433 MCFOA Dues (Jean and Tonle $40 ea) IIMC - Int'I. Clerks Assoc. Dues - Jean125/Twi75 Municipals Organization Dues 2011 0 6,000 5,000 6,000 0 900 550 200 0 750 1,500 2,400 7,600 4,500 200 1,500 0 300 10,500 80 200 25 14- Actual Actual Budget To Date Requested Percent Dollar PERSONAL SERVICES 2009 2010 2011 2011 2012 Change Change 101 FULL -TIME REGULAR 124,456 114,245 118,140 118,140 119,331 1.0% 1,191 102 FULL-TIME OVERTIME 422 - - - - - 103 PART -TIME 52,523 58,544 60,235 60,235 60,697 0.8% 462 121 PERA CONTRIB - CITY SHARE 11,520 11,440 3.2,932 12,932 12,932 0.0% - 122 FICA CONTRIB - CITY SHARE 13,510 11,400 13,646 13,646 13,646 0.0% - 131 EMPLOYEE INSURANCE - CITY SPAR 17,325 19,049 21,434 21,434 21,434 0.0% - 141 UNEMPLOYMENT COMPENSATION - 9 - - - - 151 WORKERS COMPENSATION TOTAL PERSONAL SERVICES 219,756 214,687 226,387 226,387 228,040 0.7% 1,653 MATERIALS & SUPPLIES 200 OFFICE SUPPLIES 4,276 2,991 6,000 6,000 5,500 -83% (500) 208 POSTAGE 10,658 9,957 11,000 11,000 12,020 9.3% 1,020 221 MAINTENANCE OF EQUIPMENT - - - - - - 240 SMALL TOOLS AND MINOR EQUIPMEN - - - - - - 245 GENERAL SUPPLIES 2,926 1,616 1,500 1,500 1,150 -23.3% (350) TOTAL MATERIALS & SUPPLIES 17,860 14,564 18,500 18,500 18,670 0.9% 170 SUPPORT SERVICES /CHARGES 302 CONSULTING FEES - - - - - - 321 COMMUNICATIONS - TELEPHONE - - - - - - 331 TRAVEL, CONFERENCE &SCHOOLS 3,529 1,428 2,950 2,950 2,150 -27.1% (800) 351 PRINTING AND PUBLISHING 890 1,515 2,000 2,000 2,000 0.0% - 400 CONTRACTUAL SERVICES 26,695 27,582 27,000 27,000 27,965 3.6% 965 433 DUES AND SUBSCRIPTIONS 393 695 400 400 555 38.8% 155 437 TAXES /LICENSES - - - - - - 440 MISC SERVICES TOTAL SUPPORT SERVICES /CHARGES 31,507 31,220 32,350 32,350 32,670 1.0% 320 CAPITAL OUTLAY 540 MACHINERY &EQUIPMENT 6,540 1,213 560 FURNITURE AND FIXTURES - - 580 OTHER IMPROVEMENTS TOTAL CAPITAL OUTLAY 6,540 1,213 TOTAL GENERAL GOVERNMENT 275,663 261,684 277,237 277,237 279,380 0.8% BUDGETCOMMENTS: GENERAL GOVERNMENT /CITY CLERK DEPT 41400 Code 4 101 Full -Time Deputy Clerk @ .70 FTE and Receptionist @ .70 FTE. Part -time staff= '65 FTE Communications /recycling coordinator and Web maintenance @ A FTE. 200 Copier /printer paper, pen's, paper clips, etc for all departments. 208 Postage meter fees Newsletter postage (est. $535 /mo) 221 Copier and office equipment maintenance 245 Software upgrades (In- Design, Illustrator, Acrobat and Adobe Photoshop( 331 State Clerks Conference - Jean / Twila Misc. Seminars, Mileage & MCFOA Mugs Training /Educ - Tuition Reimb ($2K -lean / $200 Twila /200 Pat /350 Julie /350 Pamela 351 Legal Notices -All General Fund except Capital Projects 400 Council Packet Delivery & Video Tape Council Recording Secretary Newsletter Mail Service - Midwest Mailing Code Book Web Host Code Book Update Document Image Service Document Destruction Newsletter Printing Service ($875 / month( 433 MCFOA Dues (Jean and Tonle $40 ea) IIMC - Int'I. Clerks Assoc. Dues - Jean125/Twi75 Municipals Organization Dues 2011 0 6,000 5,000 6,000 0 900 550 200 0 750 1,500 2,400 7,600 4,500 200 1,500 0 300 10,500 80 200 25 14- ELECTIONS Expenditure Coding: 101- 41410- SUPPORT SERVICES /CHARGES 304 LEGAL FEES - - - - - - 331 TRAVEL, CONFERENCE & SCHOOLS 25 340 - - 75 75 351 PRINTING AND PUBLISHING - 1,168 - - 1,200 1,200 440 MISCSERVICES - - - - - - TOTAL SUPPORT SERVICES/CHARGES 25 1,508 - - 1,275 1,275 CAPITAL OUTLAY 560 FURNITURE AND FIXTURES TOTAL CAPITAL OUTLAY TOTAL ELECTIONS 2,889 44,942 7,081 7,081 22,532 218.2% 15,451 BUDGETCOMMENTS: ELECTIONS DEPT 41410 Code # 101 Personnel is .2 Executive Secretary/Deputy Clerk during election year and .05 Executive Secretary /Deputy Clerk - Non - Election Years - Includes all costs 103 Part-time personnel consists of Election Judges Est, 32 Judges working Primary; 44 Judges working General Est. 18 hrs /judge & extra training on equipment 200 Election Office Supplies (misc.) 221 Equipment Maintenance - 11 voting machines 245 General supplies - forms, posters, rosters, etc. 351 Printing and publishing - ballots, envelopes, etc. 15- Actual Actual Budget To Date Requested Percent Dollar PERSONAL SERVICES 2009 2010 2011 2011 2012 Change Change 101 FULL -TIME REGULAR 655 22,765 3,784 3,784 3,835 1.3% 51 103 PART -TIME - 11,069 - - 11,000 11,000 121 PERA CONTRIB - CITY SHARE 44 1,594 274 274 274 0.0% - 122 FICA CONTRIB - CITY SHARE 50 1,732 289 289 289 0.0% - 131 EMPLOYEE INSURANCE - CITY SHARE 91 2,704 434 434 434 0.0% - TOTAL PERSONAL SERVICES 840 39,864 4,781 4,781 15,832 231.1% 11,051 MATERIALS & SUPPLIES 200 OFFICE SUPPLIES 280 181 - - 1,500 1,500 208 POSTAGE 157 397 250 250 2,225 790.0% 1,975 221 MAINTENANCE OF EQUIPMENT 1,585 1,665 2,050 2,050 1,700 -17.1% (350) 245 ELECTIONS /GENERAL SUPPLIES 2 1,327 - - - - TOTAL MATERIALS & SUPPLIES 2,024 3,570 2,300 2,300 5,425 135.9% 3,125 SUPPORT SERVICES /CHARGES 304 LEGAL FEES - - - - - - 331 TRAVEL, CONFERENCE & SCHOOLS 25 340 - - 75 75 351 PRINTING AND PUBLISHING - 1,168 - - 1,200 1,200 440 MISCSERVICES - - - - - - TOTAL SUPPORT SERVICES/CHARGES 25 1,508 - - 1,275 1,275 CAPITAL OUTLAY 560 FURNITURE AND FIXTURES TOTAL CAPITAL OUTLAY TOTAL ELECTIONS 2,889 44,942 7,081 7,081 22,532 218.2% 15,451 BUDGETCOMMENTS: ELECTIONS DEPT 41410 Code # 101 Personnel is .2 Executive Secretary/Deputy Clerk during election year and .05 Executive Secretary /Deputy Clerk - Non - Election Years - Includes all costs 103 Part-time personnel consists of Election Judges Est, 32 Judges working Primary; 44 Judges working General Est. 18 hrs /judge & extra training on equipment 200 Election Office Supplies (misc.) 221 Equipment Maintenance - 11 voting machines 245 General supplies - forms, posters, rosters, etc. 351 Printing and publishing - ballots, envelopes, etc. 15- FINANCE Expenditure Coding: 101- 41500- PERSONAL SERVICES 101 FULL -TIME REGULAR 102 OVERTIME 103 PART -TIME 106 OTHER 111 SEVERANCE PAY 121 PERA CONTRIB - CITY SHARE 122 FICA CONTRIB - CITY SHARE 131 EMPLOYEE INSURANCE - CITY SHARE 141 UNEMPLOYMENT COMPENSATION 151 WORKERS COMPENSATION Actual Actual Budget To Date Requested Percent Dollar 2009 2010 2011 2011 2012 Change Change 132,533 118,664 120,791 120,791 128,409 6.3% 7,618 8,924 7,220 8,757 8,757 8,757 0.05/o 10,102 8,484 9,241 9,241 9,241 0.09/1 14,473 12,874 14,435 14,435 14,435 0.0% TOTAL PERSONAL SERVICES 166,032 147,242 153,224 153,224 160,842 5.0% 7,618 MATERIALS & SUPPLIES - 3,400 - - 3,400 200 OFFICE SUPPLIES 604 109 - - - - 221 MAINTENANCE OF EQUIPMENT 6,183 6,521 6,700 6,700 7,000 4.5% 300 245 GENERAL SUPPLIES 165 946 250 250 300 20.0% so TOTAL MATERIALS & SUPPLIES 6,952 7,576 6,950 6,950 7,300 5.0% 350 SUPPORT SERVICES /CHARGES 301 AUDITING& ACCOUNTING SERVICES - 3,400 - - 3,400 245 3,400 331 TRAVEL, CONFERENCE & SCHOOLS 2,166 2,323 3,300 - 2,300 -303% (7,000) 351 PRINTING AND PUBLISHING 720 597 S00 S00 650 30.0% 150 360 UNALLOCATED INS - LTD - - - - - 433 - 400 CONTRACTUAL SERVICES 719 721 1,000 1,000 1,000 0.0% - 433 DUES AND SUBSCRIPTIONS 698 60 1,000 1,000 1,000 0.0% - 440 MISC SERVICES - - - - - - 450 BANK SERVICE CHARGES 496 121 775 775 800 3.2% 25 TOTAL SUPPORT SERVICES /CHARGES 4,799 7,222 6,575 3,275 9,150 39.2% 2,575 CAPITAL OUTLAY 540 MACHINERY &EQUIPMENT 1,678 - - - - - 560 FURNITURE AND FIXTURES - - - - - - 580 OTHER IMPROVEMENTS 805 - - - - - TOTAL CAPITAL OUTLAY 2,483 - - - - - TOTAL FINANCE 180,266 162,040 166,749 163,449 177,292 6.3% 10,543 BUDGET COMMENTS: FINANCE DEPT 41500 Code # 101 1.0 FTE Finance Director and .70 FTE Sr. Accounting Clerk 221 Finance software support & enhancements 7,000 Fund accounting, Payroll, Util Bill Software 245 Books & Publications 300 331 Travel, Conferences & Schools: GFOA Local 100 GFOA State 1000 Mileage 200 Educational - Tuition Reimbusement 1000 Nat'l. GFOA Conference 0 351 Publish financial statements and budget 650 433 GFOA - State and National 1000 Submittal fee - GFOA Cert. of Excellence 450 Bank & Broker Service Charges 800 -16- PROFESSIONAL SERVICES Expenditure Coding: 101- 41600- TOTAL PROFESSIONAL SERVICES 223,859 223,859 199,000 199,000 199,320 0.2% 320 BUDGET COMMENTS: PROFESSIONAL SERVICES DEPT 41600 Code If Budget 2011 301 covers the annual audit this was bit in 2008 and is a three year agreement Actual Actual Budget To Date Requested Percent Dollar SUPPORT SERVICES /CHARGES 2009 2010 2011 2011 2012 Change Change 301 AUDITING &ACCOUNTING SERVICES 19,835 20,573 22,500 22,500 24,000 6.7% 1,500 304 CIVIL LEGAL CONTRACT 82,567 36,989 47,500 47,500 44,400 -6.5% (3,100) 304 PROSECUTION CONTRACT 30,224 27,500 33,000 33,000 33,000 0.0% - 400 CONTRACTUAL ASSESSOR SERVICES 90,549 93,492 96,000 96,000 97,920 2.0% 1,920 440 MISC SERVICES 684 50 - - - - TOTAL SUPPORT SERVICES/CHARGES 223,859 178,604 199,000 199,000 199,320 012% 320 TOTAL PROFESSIONAL SERVICES 223,859 223,859 199,000 199,000 199,320 0.2% 320 BUDGET COMMENTS: PROFESSIONAL SERVICES DEPT 41600 Code If Budget 2011 301 covers the annual audit this was bit in 2008 and is a three year agreement 25,000 304 contract for civil - retainer, mileage, coping, other civil cases 47,500 304 contract for prosecuting attorney retainer and forfeitures 33,000 400 contract for the assessor with Hennepin County 96,000 County Assessor, Auditor, and Attorney are at end of three year contract term on December 31, 2011 NOTE: 2009 City incurred significant fees related to Ron Johnson Litigation Civil retainer currenity $1,850 per month. Mileage, copying, etc, extra. Special civil work billed out separate e.g. Ron Johnson Prosecution retainer currenity $2,291.66 per month. Forfeitures not included in general retainer and billed separately at $85 per hour -17- PLANNING Actual Actual Budget YID Requested Revenue Coding: 101 - Dollar PERSONAL SERVICES 2009 2010 Expenditure Coding. 101-41910 - 2011 2012 Increase Increase 101 FULL -TIME REGULAR 141,729 Actual Actual Budget YTD Requested Percent Dollar REVENUE 2009 2010 2011 2011 2012 Change Change 34103 Zoning and Subdivision Fees 5,738 2,824 4,500 4,500 4,500 - CAPITAL OUTLAY 540 MACHINERY & EQUIPMENT 560 FURNITURE AND FIXTURES 580 OTHER IMPROVEMENTS TOTAL CAPITAL OUTLAY TOTAL PLANNING 206,602 182,584 183,159 181,624 -0.8% (1,535) Net Levy Impact $ 200,864 $ 179,760 $ 178,659 $ (4,500) $ 177,124 $ (0) $ (1,5351 BUDGETCOMMENTS: PLANNING &ZONING DEPT 41910 Code 4 Actual Actual Budget YID Requested Percent Dollar PERSONAL SERVICES 2009 2010 2011 2011 2012 Increase Increase 101 FULL -TIME REGULAR 141,729 138,594 133,024 133,887 CC% 863 102 OVERTIME - - - 1000 GTS Training Session - 7 P.C. Members - 103 PART-TIME 15,027 1,142 - 400 recording secretary =24 meetings @ $100 2400 433 APA 106 OTHER - - - - Zoning News - 111 SEVERANCE PAY - - - - - 121 PERA CONTRIB - CITY SHARE 10,376 9,274 9,644 9,644 00% - 122 FICA CONTRIB - CITY SHARE 11,106 8,971 10,176 10,176 00% - 131 EMPLOYEE INSURANCE - CITY SHAD 17,236 17,582 17,850 17,850 0.0% - 141 UNEMPLOYMENT COMPENSATION - - - - 151 WORKERS COMPENSATION TOTAL PERSONAL SERVICES 195,474 175,553 170,694 - 171,557 0.5% 863 MATERIALS & SUPPLIES 200 OFFICE SUPPLIES 510 71 - - 221 MAINTENANCE OF EQUIPMENT 405 - 405 405 0.0% - 245 GENERAL SUPPLIES 1,223 78 250 250 0.0% TOTAL MATERIALS &SUPPLIES 2,138 149 655 - 655 0.0% - SUPPORT SERVICES /CHARGES 304 LEGAL FEES - - - - - 321 COMMUNICATIONS - CELLULAR PHON 1,301 1,109 960 800 -16.7% (160{ 331 TRAVEL, CONFERENCE & SCHOOLS 1,904 4,177 5,600 4,012 -284% (1,588) 351 PRINTING AND PUBLISHING 1,298 732 1,000 1,000 00% - 400 CONTRACTUAL SERVICES 3,660 - 3,400 2,500 -26.5% (900) 433 DUES AND SUBSCRIPTIONS 827 864 850 1,100 294% 250 440 MISC SERVICES TOTAL SUPPORT SERVICES /CHARGES 8,990 6,882 11,810 - 9,412 -20.3% (2,398) CAPITAL OUTLAY 540 MACHINERY & EQUIPMENT 560 FURNITURE AND FIXTURES 580 OTHER IMPROVEMENTS TOTAL CAPITAL OUTLAY TOTAL PLANNING 206,602 182,584 183,159 181,624 -0.8% (1,535) Net Levy Impact $ 200,864 $ 179,760 $ 178,659 $ (4,500) $ 177,124 $ (0) $ (1,5351 BUDGETCOMMENTS: PLANNING &ZONING DEPT 41910 Code 4 101 Personnel consist of .95 Planning director and .9 planning assistant includes all wages and benefits 245 Books Graphics materials 250 Franklin Planner Supplies 0 Hennepin Co. Aerial Pictometry /Software 0 Microsoft Office Software 0 321 Cellular phone 331 Computer Training(GIS Training) Misc.(planning commission) Conferences/ Seminars - possible in- housetraining 1000 Mileage 7.000 Sensible Land Use Coalition Meetings 1000 GTS Training Session - 7 P.C. Members 0 Education 400 Nat Conf 2200 400 recording secretary =24 meetings @ $100 2400 433 APA 850 MN APA APA Journal Zoning News Sensible Land Use Coalition MUNICIPAL BUILDINGS Expenditure Coding: 101- 41940- CAPITAL OUTLAY 520 BUILDINGS &STRUCTURES - 540 MACHINERY & EQUIPMENT - 15,713 560 FURNITURE AND FIXTURES - - 580 OTHER IMPROVEMENTS - - TOTAL CAPITAL OUTLAY - 15,713 EDA DEBT SERVICE 601 BOND PRINCIPAL - - 50,000 - - 100.0% (50,000) 611 BOND INTEREST 5,425 2,959 53,950 - - 100.0% (53,950) TOTAL EDA DEBT SERVICES 5,425 2,959 103,950 - - - 100.0% (103,950) TRANSFERS 720 OPERATING TRANSFERS 99,773 160,368 - - 103,950 103,950 TOTAL TRANSFERS 99,773 160,368 - - 103,950 103,950 TOTAL MUNICIPAL BUILDINGS 263,477 284,780 278,200 174,250 27 0% BUDGET COMMENTS: MUNICIPAL BLDG. CITY HALL DEPT 41940 Code It 221 Copier - Ricoh -new 3,300 Copier - Ricoh Color 2,500 Laserfiche Software Assurance Plan 6,300 Office Printers / folding machine 200 Postage machine lease & maint 1,400 13,700 245 General Supplies - cleaning supplies, ice control, paper, etc. Actual Actual Budget To Date Requested Percent Dollar MATERIALS & SUPPLIES 2009 2010 2011 2011 2012 Change Change 221 MAINTENANCE OF EQUIPMENT 32,020 48,384 14,000 14,000 14,000 0.0% - 223 MAINTENANCE OF BUILDINGS 119 883 - - - - 245 GENERALSUPPLIES 2,182 1,977 2,500 2,500 2,500 0.0% - TOTAL MATERIALS & SUPPLIES 34,321 51,244 16,500 16,500 16,500 0.0% - SUPPORT SERVICES /CHARGES 302 CONSULTING FEES - - - - - - 321 COMMUNICATIONS - Warner Conn. 6,523 2,771 34,000 34,000 34,000 0.0% - 331 TRAVEL, CONFERENCE &SCHOOLS - 542 - - - 360 INSURANCE 98,796 33,942 105,000 105,000 105,000 0.0% - 380 UTILITY SERVICES 10,671. 7,700 11,000 11,000 11,000 0.0% - 400 CONTRACTUAL SERVICES 6,640 8,173 7,500 7,500 7,500 0.0% - 410 RENTALS 1,328 1,368 250 250 250 0.0% - 437 TAXES /LICENSES - - - 440 MISC SERVICES - - - TOTAL SUPPORT SERVICES/CHARGES 123,958 54,496 157,750 157,750 157,750 0.0% - CAPITAL OUTLAY 520 BUILDINGS &STRUCTURES - 540 MACHINERY & EQUIPMENT - 15,713 560 FURNITURE AND FIXTURES - - 580 OTHER IMPROVEMENTS - - TOTAL CAPITAL OUTLAY - 15,713 EDA DEBT SERVICE 601 BOND PRINCIPAL - - 50,000 - - 100.0% (50,000) 611 BOND INTEREST 5,425 2,959 53,950 - - 100.0% (53,950) TOTAL EDA DEBT SERVICES 5,425 2,959 103,950 - - - 100.0% (103,950) TRANSFERS 720 OPERATING TRANSFERS 99,773 160,368 - - 103,950 103,950 TOTAL TRANSFERS 99,773 160,368 - - 103,950 103,950 TOTAL MUNICIPAL BUILDINGS 263,477 284,780 278,200 174,250 27 0% BUDGET COMMENTS: MUNICIPAL BLDG. CITY HALL DEPT 41940 Code It 221 Copier - Ricoh -new 3,300 Copier - Ricoh Color 2,500 Laserfiche Software Assurance Plan 6,300 Office Printers / folding machine 200 Postage machine lease & maint 1,400 13,700 245 General Supplies - cleaning supplies, ice control, paper, etc. 2,500 321 telephone and data through Warner Connect @ $2,800 month 34,000 360 Insurance Property /Casualty, WC, etc. 105,000 380 Utilities 11,000 400 Contractual Services - janitorial, Carpet, and pest control 7,500 720 Debt Service Payments (for City Hall public project bonds) 103,950 _19_ POLICE Expenditure Coding: 101- 42100- TOTAL POLICE PROTECTION 1,176,929 1,178,772 1,225,816 1,225,816 1,241,366 1.3% 15,550 BUDGET COMMENTS: POLICE DEPT 42100 Code # Contractual services is the contribution to the SLMPD per the IPA. The percentage assessed has changed to 48.49% for budget year 2012. Miscellaneous Services are charges associated with Forfeiture vehicles (tow charges) Capital outlay covers the City's share of the bonds. -20- Actual Actual Budget To Date Requested Percent Dollar MATERIALS &SUPPLIES 2009 2010 2011 2011 2012 Change Change 245 GENERALSUPPLIES - 1,367 - - - - TOTAL MATERIALS & SUPPLIES - 1,367 - - - - SUPPORT SERVICES /CHARGES 380 UTILITY SERVICES 26 41 50 50 - - 100.0% (50) 400 CONTRACTUAL SERVICES 941,396 947,298 991,700 991,700 1,009,300 1.89/ 17,600 440 MISC SERVICES 2,567 1,998 4,000 4,000 2,000 -50.0% (2,000) TOTAL SUPPORT SERVICES /CHARGES 943,989 949,337 995,750 995,750 1,011,300 1.6% 15,550 CAPITAL OUTLAY 520 BUILDINGS &STRUCTURES 232,940 228,068 230,066 230,066 230,066 0.0% - TOTAL CAPITAL OUTLAY 232,940 228,068 230,066 230,066 230,066 0.0% - TOTAL POLICE PROTECTION 1,176,929 1,178,772 1,225,816 1,225,816 1,241,366 1.3% 15,550 BUDGET COMMENTS: POLICE DEPT 42100 Code # Contractual services is the contribution to the SLMPD per the IPA. The percentage assessed has changed to 48.49% for budget year 2012. Miscellaneous Services are charges associated with Forfeiture vehicles (tow charges) Capital outlay covers the City's share of the bonds. -20- FIRE Expenditure Coding: 101- 42200- BUDGETCOMMENTS: FIRE DEPT 42100 Code If Support Services and charges covers the contract cost for Mound FD to cover the island and the city's share of the costs for the EFD 1PA Buildings & Structures is the city's share of the building bonds and capital equipment. Mound operations cost Capital costs 21- Actual Actual Budget To Date Requested Percent Dollar SUPPORT SERVICES /CHARGES 2009 2010 2011 2011 2012 Change Change 400 Excelsior Fire 298,175 298,113 312,548 312,548 307,705 -1.5% (4,843) 400 Mound Fire Contract 25,005 24,422 24,582 24,582 25,100 2.1% 518 TOTAL SUPPORT SERVICES /CHARGES 323,180 322,535 337,130 337,130 332,805 -1.3% (4,325) CAPITAL OUTLAY 520 BUILDINGS &STRUCTURES 277,270 272,629 270,697 270,697 277,906 23% 7,209 TOTAL CAPITAL OUTLAY 277,270 272,629 270,697 270,697 277,906 2.7% 7,209 TOTAL FIRE PROTECTION 600,450 595,164 607,827 607,827 610,711 0.5% 2,884 BUDGETCOMMENTS: FIRE DEPT 42100 Code If Support Services and charges covers the contract cost for Mound FD to cover the island and the city's share of the costs for the EFD 1PA Buildings & Structures is the city's share of the building bonds and capital equipment. Mound operations cost Capital costs 21- PROTECTIVE INSPECTIONS Expenditure Coding: 101- 42400- SUPPORT SERVICES/CHARGES 321 COMMUNICATIONS - CELLULAR PHONE Actual Actual Budget To Date Requested Percent Dollar REVENUE 2009 2010 2011 2011 2012 Change Change 32210 Building Permits 97,651 118,190 70,000 70,000 70,000 0.0% - 32215 Plan Check Fees 12,336 23,679 11,000 11,000 11,000 0.0% - TOTAL REVENUE 109,987 141,869 81,000 81,000 81,000 0.0% - SUPPORT SERVICES/CHARGES 321 COMMUNICATIONS - CELLULAR PHONE Actual Actual Adopted To Date Requested Percent Dollar PERSONAL SERVICES 2009 2009 2011 2011 2012 Increase Change 101 FULL -TIME REGULAR 88,521 90,428 83,433 83,433 84,932 1.8% 1,499 102 PART -TIME 7,275 1,285 1,500 1,500 1,500 0.0% - 121 PERA CONTRIB - CITY SHARE 6,267 6,092 6,050 6,050 6,050 0.0% - 122 FICA CONTRIB - CITY SHARE 6,646 5,895 6,383 6,383 6,383 0.0% - 131 EMPLOYEE INSURANCE - CITY SHARE 10,475 11,381 11,730 11,730 11,730 0.0% - TOTAL PERSONAL SERVICES 119,184 115,081 109,096 109,096 110,595 1.4% 1,499 MATERIALS & SUPPLIES - 300 - - - 100.0% (300) TOTAL PROTECTIVE INSPECTIONS 126,268 200 OFFICE SUPPLIES - 6 - - - 16,281 - 245 GENERAL SUPPLIES 139 22 300 200 -33.3% (100) TOTAL MATERIALS & SUPPLIES 139 28 300 - 200 -33.3% (100) SUPPORT SERVICES/CHARGES 321 COMMUNICATIONS - CELLULAR PHONE 470 244 450 - - - 100.0% (450) 331 TRAVEL, CONFERENCE & SCHOOLS 2,799 2,785 3,000 2,500 -16.7% (500) 351 PRINTING AND PUBLISHING 668 116 300 300 0.0% - 400 CONTRACTUAL SERVICES 1,610 1,330 2,500 2,500 0.0% - 433 DUES AND SUBSCRIPTIONS 100 100 150 150 0.0% - TOTAL SUPPORT SERVICES /CHARGES 5,647 4,575 6,400 - 5,450 -14.8% (950) CAPITAL OUTLAY 540 MACHINERY & EQUIPMENT 1,298 - 300 - - - 100.0% (300) 560 FURNITURE AND FIXTURES - - - - - - TOTAL CAPITAL OUTLAY 1,298 - 300 - - - 100.0% (300) TOTAL PROTECTIVE INSPECTIONS 126,268 119,684 116,096 109,096 116,245 0.1% 149 Net Levy Support 16,281 (22,185) 35,096 28,096 35,245 BUDGET COMMENTS: PROTECTIVE INSPECTION DEPT 42400 Code # 101 Personnel allocation includes 1 FTE Building official, .05 Planning Dir .SO Planning assistant - costs all inclusive except for increases for 2011 245 Books and other reference material 321 Cellular Telephone - switch to "pay as you go" phone Possibility to add wireless internet computer card for remote access In field 331 Inspect. classes Conferences Mileage 351 forms are generated in house and being taken electronically 400 covers contract inspections in the absence of Joe 433 LC.B.O. Northstar Chapter - IC60 -22- CITY ENGINEER Expenditure Coding: 101- 43010- PERSONAL SERVICES 101 FULL -TIME REGULAR 121 PERA CONTRIB- CITY SHARE 122 FICA CONTRIB - CITY SHARE 131 EMPLOYEE INSURANCE - CITY SHARE TOTAL PERSONAL SERVICES MATERIALS & SUPPLIES 200 OFFICE SUPPLIES 221 MAINTENANCE OF EQUIPMENT 245 GENERALSUPPLIES TOTAL MATERIALS & SUPPLIES SUPPORT SERVICES /CHARGES 303 ENGINEERING FEES 321 COMMUNICATIONS - CELLULAR PHONE 331 TRAVEL, CONFERENCE & SCHOOLS 351 PRINTING AND PUBLISHING 400 CONTRACTUAL SERVICES 410 RENTAL 433 DUES AND SUBSCRIPTIONS 437 TAXES /LICENSES TOTALSUPPORT SERVICES /CHARGES CAPITAL OUTLAY 540 MACHINERY & EQUIPMENT 560 FURNITURE AND FIXTURES 580 OTHER IMPROVEMENTS TOTAL CAPITAL OUTLAY 2,854 538 1,000 1,000 - - 100.0% (1,000) TOTAL CITY ENGINEER 118,622 104,124 126,678 126,678 124,807 -1.5% (1,871) BUDGET COMMENTS: CITY ENGINEER DEPT 43010 Code # 101 .9 City Engineer, .20 FTE clerical - in 2010 only .10 200 Covers general supplies specific to engineering General supplies -Books and materials 221 Covers software maintenance agreements, was in Subscriptions and memberships 303 Engineering - miscellaneous consulting and /or studies 321 - Cellular telephone for GPS Data 331 - Travel, Conference, & Schools 351 - Printing and publishing 410 - Rentals - Survey grade GPS @ $200 per day 433 - Subscriptions and memberships 437 PE and CE license Actual Actual Budget To Date Requested Percent Dollar 2009 2010 2011 2011 2012 Change Change 86,821 74,859 86,585 86,585 88,129 1.8% 1,544 4,826 4,993 6,277 6,277 6,277 0.0% - 6,581 5,437 6,624 6,624 6,624 0.0% - 9,160 9,208 11,617 11,617 11,617 0.0% - 107,388 94,497 111,103 111,103 112,647 1.4% 1,544 395 119 300 300 150 -50.0% (150) - - 830 830 - - 100.0% (830) 346 33 125 125 50 -60.0% (75) 741 152 1,255 1,255 200 -84.1% (1,055) 1,825 4,620 5,000 5,000 5,000 0.0% - 547 411 700 700 60 -91.4% (640) 3,375 1,400 3,500 3,500 2,500 -28.6% (1,000) 792 177 500 500 300 -40.0% (200) - - 250 250 - - 100.0% (250) 267 - 1,000 1,000 600 -40.0% (400) 833 2,197 1,470 1,470 3,200 117.7% 1,730 - 132 900 900 300 -66.7% (600) 7,639 8,937 13,320 13,320 11,960 -10.2% (1,360) 2,854 538 1,000 1,000 - - 100.0% (1,000) 23- PUBLIC WORKS Expenditure Coding: 101- 4305D- General Public works consists of .5 Director, .3 LEO, A Utiltiy Lead Fire Suppression System Monitoring and .9 Shop Tech. Wages include 2% increase and all associated benefits. Annual Crane Inspections (2) 212 - Gas and diesel fuel for trucks and other equipment 51,000 221 - Equipment Maintenance 16,000 Actual Actual Budget To Date Requested Percent Dollar PERSONAL SERVICES 2609 20ID 2011 2010 2012 Increase Change 101 FULL -TIME REGULAR 228972 227,435 142,390 112,403 144,179 13% 1,789 102 OVERTIME 390 39 2,500 - 2,500 0.0% - 103 PART -TIME 1,302 504 - 121 PLEA CONTRIB - CITY SHARE 14,906 15,336 10,323 8,309 10,323 OD% 122 FICA CONTRIS - CITY SHARE 16,364 16,770 10,893 8,860 10,893 0.0% - 131 EMPLOYEE INSURANCE - CITY SHARE 26,969 28,945 18,001 12,343 18,001 0.0% TOTAL PERSONAL SERVICES 279,601 289,827 184,107 142,419 185,896 1.0% 1,789 MATERIALS & SUPPLIES 200 OFFICE SUPPLIES 16 126 200 126 200 0.0% - 212 MOTOR FUELS & LUBRICATION 27,668 37,660 43,000 20,599 51,000 186% 8,000 221 MAINTENANCE OF EQUIPMENT 19,373 15,237 16,000 9,296 16,000 0.0% - 223 MAINTENANCE OF BUILDINGS 865 1,502 2,000 557 4,000 100.0% 2,000 240 SMALL TOOLS AND MINOR EQUIPMENT 908 757 1,000 372 1,000 0.0% 245 GENERAL SUPPLIES 9,970 6,867 9,000 2,796 9,000 0.0% TOTAL MATERIALS & SUPPLIES 58,800 62,149 71,200 33,745 81,200 14.0% 10,000 SUPPORT SERVICES /CHARGES 305 DRUGTESTING - 1,300 - 1,300 0.0% - 321 COMMUNICATIONS - TELEPHONE 1,527 1,950 3,200 1,059 3,200 0.0% - 331 TRAVEL, CONFERENCE &SCHOOLS 2,800 3,060 3,200 3,060 3,200 Do - 351 PRINTING AND PUBLISHING 2,896 - - 380 UTILITY SERVICES 9,996 10,048 14,000 14,000 14,000 0.0% - 400 CONTRACTUAL SERVICES 20,888 22,783 16,190 16,190 16,190 0.0% - 410 RENTALS 283 331 1,000 11000 11000 0.0% - 433 DUES AND SUBSCRIPTIONS 1,518 1,584 1,500 1,500 1,500 0.0% - 437TAXES /LICENSES 317 846 850 850 850 00% - 440 MISC SERVICES 314 505 200 200 200 0.0% TOTAL SUPPORT SERVICES /CHARGES 40,539 41,107 41,440 37,859 41,440 0.0% - CAPITALOUTLAY 520 BUILDINGS & STRUCTURES - 540 MACHINERY &EQUIPMENT 5,003 560 FURNITURE AND FIXTURES - 580 OTHER IMPROVEMENTS TOTAL CAPITAL OUTLAY 51003 TRANSFERS 720 OPERATING TRANSFERS- EQUIPMENT 175,000 100,000 50,000 50,000 DOG. TOTALTRANSFERS 175,000 100,000 50,000 - 50,000 0.0% - TOTAL PUBUC WORKS 558,943 493,083 3o-6,74> 214,022 358,536 3.4% 11,789 BUDGETCOMMENTS: PUBLIC WORKS SERVICE DEPT43050 Code 4 101 - Personnel was modified using actual time reports for last 6 months of 2009 & first 6 months of 2010 General Public works consists of .5 Director, .3 LEO, A Utiltiy Lead Fire Suppression System Monitoring and .9 Shop Tech. Wages include 2% increase and all associated benefits. Annual Crane Inspections (2) 212 - Gas and diesel fuel for trucks and other equipment 51,000 221 - Equipment Maintenance 16,000 223 - Building Maintenance - general routine maintenance + $2,000 for Salt Storage bldg main 2,000 240 -small tools 1,000 245 General equipment 9,000 305 - Drug monitoring and testing, including annual dues to LMCIT 1,300 321 - Telephones, pager &cable modem;' Internet weather, Alarm call oncho ring 3,200 331 - Travel, COnPerences, &Schools Safety Training- SefeASSUre IQ$HA mandate) 3,200 380 - Utilities - Gas &Electric 14,000 400 - Contractual Services 16190 Laundry service - uniforms, towels- $170 wk x 52 wits 9100 Janitorial Services 5940 Pest Control Fire Suppression System Monitoring 300 Annual Crane Inspections (2) 850 410 - Rentals 1,000 433 Mis -150; All Data Automotive Tech ServiceQ000 1,500 437 Hazardous Waste License - Dept of Bev 850 Hennepin Co. Hazardous Waste Misc Licenses (Boiler, criganoomre Extingl nsp) 440 Miscellaneous Charges e.g. mail box damage, damage to private property, etc. 200.00 720 Transferto Equipment Replacement Fund 50,000 24- STREETS AND ROADS Expenditure Coding: 101- 43100- PERSONNEL SERVICES 101 FULL -TIME REGULAR 102 OVERTIME 103 PART -TIME 106 OTHER 111 SEVERANCE PAY 121 PERA CONTRIB - CITY SHARE 122 FICA CONTRIB - CITY SHARE 131 EMPLOYEE INSURANCE - CITY SHARE 141 UNEMPLOYMENT COMPENSATION 151 WORKERS COMPENSATION Actual Actual 2009 2010 55,417 70,545 223 129 460 - 3,730 4,925 4,206 5,266 5,810 7,957 Budget To Date Requested Percent Dollar 2011 2010 2012 Increase Change 87,832 43,132 90,973 3.6% 3,141 500 22 500 0.0% - 6,368 3,013 6,368 0.0% 6,719 3,214 6,719 0.0% 12,040 3,386 12,040 0.0% TOTAL PERSONAL SERVICES 69,846 88,822 113,459 52,768 116,600 Z.8% 3,141 MATERIALS & SUPPLIES 221 MAINTENANCE OF EQUIPMENT - - - - - - 240 SMALL TOOLS AND MINOR EQUIPMENT - 45 - - 245 GENERAL SUPPLIES 53,168 80,208 85,000 85,000 0.0% - TOTALMATERIALS &SUPPLIES 53,168 80,253 85,000 - 85,000 0.0% - SUPPORT SERVICES /CHARGES 331 TRAVEL, CONFERENCE & SCHOOLS - - 4,000 4,000 0.0% - 351 PRINTING AND PUBLISHING - - - - - 400 CONTRACTUAL SERVICES 27,233 21,068 30,000 30,000 0.0% - 440 MISC SERVICES - 206 - - TOTALSUPPORTSERVICES /CHARGES 27,233 21,274 34,000 - 34,000 0.0% - CAPITAL OUTLAY 540 MACHINERY & EQUIPMENT - - - - 580 OTHER IMPROVEMENTS - - - - - TOTAL CAPITAL OUTLAY - - - - - TRANSFERS 720 OPERATING TRANSFERS- STREETS 700,000 700,000 700,000 700,001 721,000 3.0% 21,000 TOTALTRANSFERS 700,000 700,000 700,000 700,001 721,000 3.0% 21,000 TOTAL STREETS & ROADWAYS 850,247 890,349 932,459 752,769 956,600 2.6% 24,141 BUDGET COMMENTS: STREETS AND ROADWAYS DEPT 43100 Code N 101 1.2 FTE LEO and .3 FTE Utility Supervisor. 24S - General Supplies- Rock, gravel, black dirt & asphalt, Rock and Aggregates 85,000 Black dirt, asphalt patching, castings & rings, etc. 331 Travel, Conferences, and Schoosl- safety training, refresher training, etc. 4,000 400 Contractual services Includes roadway striping, street sweeping, etc. 30,000 720 Transfer to Local Street Reconstruction Fund to support road program 721,000 -25- SNOW AND ICE CONTROL Expenditure Coding: 101- 43125- BUDGET COMMENTS: SNOW AND ICE REMOVAL DEPT 43125 Code # 101 Staffing allocation is equivalent to 1.4 FIE 245 - General Supplies covers the purchase of salt, sand, cutting blades, etc. 45,117 26- Actual Actual Budget To Date Requested Percent Dollar PERSONAL SERVICES 2009 2010 2011 2010 2012 Increase Change 101 FULL -TIME REGULAR 23,995 27,444 38,238 13,211 39,101 2.3% 863 102 OVERTIME 5,226 18,317 7,500 8,651 7,500 0.0% - 103 PART -TIME - - - - - - 106 OTHER - - - - - 111 SEVERANCE PAY - - - - - - 121 PERA CONTRIB - CITY SHARE 1,981 2,645 2,772 1,531 2,772 0.0% - 122 FICA CONTRIB - CITY SHARE 2,178 2,759 2,925 1,587 2,925 0.0% - 131 EMPLOYEE INSURANCE -CITY SHARE 2,615 3,887 5,132 1,848 5,132 0.0% - 141 UNEMPLOYMENT COMPENSATION - - - - - - 1S1 WORKERS COMPENSATION - - - - - - TOTAL PERSONAL SERVICES 35,995 55,052 56,567 26,828 57,430 1.5% 863 MATERIALS & SUPPLIES 245 GENERALSUPPLIES 38,457 32,451 45,117 45,117 45,117 0.0% - TOTAL MATERIALS & SUPPLIES 38,457 32,451 45,117 45,117 45,117 0.0% - SUPPORT SERVICES /CHARGES 331 TRAVEL, CONFERENCE &SCHOOLS - - - - - ' TOTAL SUPPORT SERVICES /CHARGES - - - - - #DIV /01 - CAPITAL OUTLAY 540 MACHINERY &EQUIPMENT - - - - - TOTAL CAPITAL OUTLAY - - - - - #DIV /O! - TOTAL ICE & SNOW CONTROL 74,452 87,503 101,684 71,945 102,547 0.8% 863 BUDGET COMMENTS: SNOW AND ICE REMOVAL DEPT 43125 Code # 101 Staffing allocation is equivalent to 1.4 FIE 245 - General Supplies covers the purchase of salt, sand, cutting blades, etc. 45,117 26- TRAFFIC CONTROL Expenditure Coding: 101- 43160- PERSONAL SERVICES 101 FULL -TIME REGULAR 102 PART -TIME 121 PERA CONTRIB - CITY SHARE 122 FICA CONTRIB - CITY SHARE 131 EMPLOYEE INSURANCE - CITY SHARE Actual Actual Budget To Date Requested Percent Dollar 2011 2011 2012 Increase ChaneE TOTAL PERSONAL SERVICES MATERIALS & SUPPLIES 221 MAINTENANCE OF EQUIPMENT - - - - - 245 GENERALSUPPLIES 2,873 2,528 5,000 5,000 5,000 0.0% - TOTAL MATERIALS & SUPPLIES 2,873 2,528 5,000 5,000 5,000 0.0% - SUPPORT SERVICES /CHARGES 303 ENGINEERING FEES - - - - - 380 UTILITY SERVICES 294 278 300 300 300 0.0% - 399 UTILITIES - STREETLIGHTS 41,049 38,882 41,049 41,049 41,049 0.0% - 400 CONTRACTUAL SERVICES 2,321 1,733 10,800 10,800 10,800 0.0% - 440 MISC SERVICES - - - - - TOTAL SUPPORT SERVICES/CHARGES 43,664 40,893 52,149 52,149 52,149 0.0% - TOTAL TRAFFIC CONTROL 46,537 43,421 57,149 57,149 57,149 0.0% - BUDGET COMMENTS: TRAFFIC CONTROL /STREET LIGHTING DEPT 43160 Code 4 This budget covers the operational cost of street lights, traffic signals and street signs. the major change in this budget is preparing for the new federal requirement for street signs. Dollars are budgeted to hire a consultant to conduct a comprehensive sign inventory. 245 General Supplies covers the costs associated with light replacement for stop lights. 380 - Utilities - street lights 400 consulting services to conduct the sign inventory and reflectivity study. HMO 41,049 10,800 -27- SANITATION /WEEDS /WASTE REMOVAL Expenditure Coding: 101- 43200- PERSONAL SERVICES 101 FULL -TIME REGULAR 102 OVERTIME 121 PERACONTRIB - CITYSHARE 122 FICA CONTRIB - CITY SHARE 131 EMPLOYEE INSURANCE - CITY SHARE 141 UNEMPLOYMENT COMPENSATION 151 WORKERS COMPENSATION Actual 2009 Actual 2010 Budget 2011 To Date 2010 Projected 2012 Percent Dollar Increase Change 1,365 4,588 1,500 3,232 1,500 0.0% 859 272 200 172 200 0.0% 150 340 245 238 245 0.0% 168 371 260 260 260 0.0% 222 256 76 76 76 0.0% TOTAL PERSONAL SERVICES 2,764 5,827 2,281 3,979 2,281 0.0% MATERIALS & SUPPLIES 245 GENERALSUPPLIES 21 - 100 101 100 0.0% - TOTAL MATERIALS & SUPPLIES 21 - 100 101 100 0.0% - SUPPORT SERVICES /CHARGES 400 CONTRACTUAL SERVICES - - 1,000 1,000 1,000 0.0% - 440 MISC SERVICES - 3,210 3,400 3,400 3,400 0.0% TOTAL SUPPORT SERVICES /CHARGES - 3,210 4,400 4,400 4,400 0.0% - TOTAL SANITATION /WEEDS /WASTE 2,785 9,037 6,781 8,480 6,781 0.0% - BUDGET COMMENTS: SANITATION /WASTE REMOVAL /WEEDS DEPT 43200 Code # 101 - Personnel consists of staff time to work the annual spring clean -up day 400 - Contractual Services - roadside spraying 2,281 1,000 Ra TREE MAINTENANCE Expenditure Coding: 101- 43250- TOTAL TREE MAINTENANCE 17,451 32,193 28,695 25,708 28,695 0.0% - BUDGET COMMENTS: TREE MAINTENANCE DEPT 43250 Code # 101 - Personnel consists of a .4 FTE LEO 14,020 400 - Contractual Services - covers the cost of tree removal 13,000 Replacement of trees is part of Parks budget. No funds presently allocated for tree inventory -29- Actual Actual Budget To Date Projected Percent Dollar PERSONAL SERVICES 2009 2010 2011 2010 2011 Increase Change 101 FULL -TIME REGULAR 5,617 15,972 10,837 9,118 10,837 0.0% - 102 OVERTIME 378 613 - 316 - - 103 PART -TIME - - - - - - 121 PERA CONTRIB - CITY SHARE 405 1,152 786 660 786 0.0% - 122 FICA CONTRIB - CITY SHARE 456 1,229 829 709 829 0.0% - 131 EMPLOYEE INSURANCE - CITY SHARE 657 1,659 1,568 230 1,568 0.0% - 141 UNEMPLOYMENT COMPENSATION - - - - - - 151 WORKERS COMPENSATION - - - - - - TOTALPERSONALSERVICES 7,513 20,625 14,020 11,033 14,020 0.0% - MATERIALS & SUPPLIES 221 MAINTENANCE OF EQUIPMENT 75 - 150 150 150 0.0% - 240 SMALL TOOLS AND MINOR EQUIPMENT - - 775 775 775 0.0% - 245 GENERALSUPPUES 362 107 500 500 500 0.0% - TOTAL MATERIALS & SUPPLIES 437 107 1,425 1,425 1,425 0.0% - SUPPORT SERVICES /CHARGES 331 TRAVEL, CONFERENCE & SCHOOLS - - 250 250 250 0.0% - 400 CONTRACTUAL SERVICES 9,501 11,461 13,000 13,000 13,000 0.0% - TOTALSUPPORTSERVICES /CHARGES 9,501 11,461 13,250 13,250 13,250 0.0% - TOTAL TREE MAINTENANCE 17,451 32,193 28,695 25,708 28,695 0.0% - BUDGET COMMENTS: TREE MAINTENANCE DEPT 43250 Code # 101 - Personnel consists of a .4 FTE LEO 14,020 400 - Contractual Services - covers the cost of tree removal 13,000 Replacement of trees is part of Parks budget. No funds presently allocated for tree inventory -29- PARKS AND RECREATION Revenue Coding: 101 - Expenditure Coding: 101-45200 - Actual Actual Budget To Date Requested Percent Dollar REVENUE 2009 2010 2011 2011 2012 Increase Change 34780 Park fees and Classes 27,395 34,396 29,425 29,425 29,425 0.0% - MATERIALS & SUPPLIES 221 MAINTENANCE OF EQUIPMENT 223 MAINTENANCE OF BUILDINGS 240 SMALLTOOLS AND MINOR EQUIPMENT 245 GENERALSUPPLIES 841 2,896 5,000 5,000 5,000 284 920 4,000 4,000 4,000 63 604 800 800 800 0.0% 0.0% 0.0% 0.0% TOTAL MATERIALS & SUPPLIES SUPPORT SERVICES /CHARGES 302 CONSULTING FEES 303 ENGINEERING FEES 304 LEGAL FEES 321 COMMUNICATIONS - TELEPHONE 331 TRAVEL, CONFERENCE & SCHOOLS 2851 PRINTING AND PUBLISHING 380 UfILFFY SERVICES 400 CONTRACTUAL SERVICES 410 RENTALS 433 DUES AND SUBSCRIPTIONS 440 MISC SERVICES 10,094 14,237 19,800 19,800 19,800 0.0% 14,013 - - - - 1,695 1,747 1,900 1,900 1,900 0.0% - Actual Actual Adopted Adopted Requested Percent Dollar PERSONAL SERVICES 2009 2010 2011 2011 2012 Increase Change 101 FULL -TIME REGULAR 95,949 102,710 124,702 124,702 124,939 0.2% 237 102 OVERTIME 2,222 1,870 2,500 2,500 2,500 0.0% - 103 PART -TIME 22,100 21,314 22,000 22,000 22,000 0.0% - 106 OTHER - - - - - - 111 SEVERANCE PAY - - - - - - 121 PLEA CONTRIB - CITY SHARE 6,773 7,437 9,041 9,041 9,041 0.0% - 122 FICA CONTRIB - CITY SHARE 8,575 8,719 9,540 9,540 9,540 0.0% - 131 EMPLOYEE INSURANCE - CITY SHARE 11,913 11,587 17,925 17,925 17,925 0.0% - 141 UNEMPLOYMENT COMPENSATION - - - - - - 151 WORKERS COMPENSATION - - - - - - TOTAL PERSONAL SERVICES 147,532 153,637 185,708 185,708 185,945 011% 237 MATERIALS & SUPPLIES 221 MAINTENANCE OF EQUIPMENT 223 MAINTENANCE OF BUILDINGS 240 SMALLTOOLS AND MINOR EQUIPMENT 245 GENERALSUPPLIES 841 2,896 5,000 5,000 5,000 284 920 4,000 4,000 4,000 63 604 800 800 800 0.0% 0.0% 0.0% 0.0% TOTAL MATERIALS & SUPPLIES SUPPORT SERVICES /CHARGES 302 CONSULTING FEES 303 ENGINEERING FEES 304 LEGAL FEES 321 COMMUNICATIONS - TELEPHONE 331 TRAVEL, CONFERENCE & SCHOOLS 2851 PRINTING AND PUBLISHING 380 UfILFFY SERVICES 400 CONTRACTUAL SERVICES 410 RENTALS 433 DUES AND SUBSCRIPTIONS 440 MISC SERVICES 10,094 14,237 19,800 19,800 19,800 0.0% 14,013 - - - - 1,695 1,747 1,900 1,900 1,900 0.0% - 105 1,000 1,000 1,000 0.0% 8,179 7,613 9,000 9,000 9,000 0.0% 73,949 76,352 70,000 70,000 70,000 0.0% 11,709 10,240 9,500 9,500 9 0.0% 236 - 500 500 500 0.0% TOTAL SUPPORT SERVICES /CHARGES 109,781 96,057 91,900 91,900 91,900 0.0% TRANSFERS 720 OPERATING TRANSFERS 45,000 42,000 42,000 42,000 42,000 0.0% - TOTALTRANSFERS 45,000 42,000 42,000 42,000 42,000 0.0% - TOTAL PARKS AND RECREATION 312,407 305,931 339,408 339,408 339,645 0.1% 237 Net Levy Support 285,012 271,535 309,983 309,983 310,220 0.1% 237 BUDGET COMMENTS: PARKS & RECREATION /BEACHES DEPT 45200 Code 4 101 Personnel FT consists of 1.7 FTE LEO and .6 FTE clerical 103 covers part -time employees including rink attendants and part -time summer help 22,000 221 Maintenance to park equipment. Increse this line to accommodate general maintenance. 5,000 223 Park building maintenance 4,000 30- 240 Small tools and supplies 245 General supplies e.g. seed, sand, dirt, rock, etc. 321 Telephone 380 Utilitites 400 Park Coordinator Contract Music in the park Life guards AS Contribution Other Programs - Fun Friday's, Music in the Park, safety camp, Arctic Fever, etc. Buckthorn Removal 410 Rental - porta- potties 440 Miscellaneous Services - 720 Transfer to Park Capital Improvement Fund 800 10,000 1,900 9,000 53,000 2,500 3,900 6,000 3,000 1,600 70,000 9,500 1,000 42,000 31-