Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
11-26-12 CC Work Session Agenda
CITY OF SHOREWOOD CITY COUNCIL WORK SESSION MONDAY, NOVEMBER 26, 2012 AGENDA 1. CONVENE CITY COUNCIL WORK SESSION A. Roll Call B. Review Agenda 2. 2013 CIP AND ENTERPRISE BUDGETS 3. 2013 GENERAL FUND BUDGET 5755 COUNTRY CLUB ROAD COUNCIL CHAMBERS 6:00 PM Mayor Liz& Hotvet Siakel Woodruff Zerby ATTACHMENTS Finance Director's memo Finance Director's memo 4. ADJOURN 1:(2 Q Cit y of Shorewood Work Session Item Title / Subject: 2013 Capital Improvement Plan and Enterprise Budgets Meeting Date: November 26, 2012 Prepared by: Bruce DeJong, Finance Director Reviewed by: Bill Joynes, Interim City Administrator Attachments: Budget Worksheets Projects by Department N MEETING TYPE Work Session Meeting Policy Consideration: How should enterprise budgets and capital projects be prioritized, scheduled, and funded? Background: The entire Capital Improvement Plan (CIP) and enterprise fund budgets will be reviewed at this meeting. The ten -year CIP and the budgets have been updated based on the discussions held on October 8 and October 22. Fund 402 - The Park Commission has merged its various project lists into one that includes everything on the CIP. Because of this, the projects beyond 2013, particularly Badger Park modifications, are still speculative in nature. This fund is fully funded for 2013, but does not have enough to cover all items on the list starting in 2014. Longer term analysis of park needs in conjunction with a joint meeting of the Park Commission and City Council in 2013 will be a good next step to resolving this funding challenge. Fund 403 - Equipment Replacement fund generally covers all of the city's rolling stock and attachments along with the equipment at the Public Works shop to keep everything running. Projects from the Public Facilities and Technology have been incorporated into this fund. The next ten years of equipment purchases average about $185,000 per year, so this level of replacement requires additional resources to fully fund equipment needs over the long term. New projects have been added since the meeting on October 8. 1. Network Connection between City Hall, Southshore Center, and Public Works This could be accomplished several different ways — fiber optic cable, point -to -point wireless, or potentially through Mediacom. Costs is estimated at roughly $10 per lineal foot based on a quote received from a vendor. 2. Laserfiche Upgrade This allows better access to city records by internet users and includes workflow software to allow easier entry of documents by staff in the normal course of business rather than as a process after the fact. The cost today would be about $5,900 because we have some pro -rated credit available from our unused annual maintenance. The cost will increase by over $2,060 if we wait until January to purchase this upgrade. 3. Copier Replacement Mission Statement: The City of Shorewood is committed to providing residents quality public services, a healthy environment, a variety of attractive amenities, a sustainable tax base, and sound financial management through effective, efficient, and visionary leadership. Page 1 This project anticipates purchase of a new copier for about $9,000. Annual per -copy costs would go down by about $1,900 per year. This would be about a five year payback of the costs and the current copier has had a service life of seven years. A project from 2012 was also moved to 2013 based on changes in product line. The Groundsmaster mower scheduled for 2012 was not purchased because staff learned this fall that the models have completely changed and a direct replacement is no longer possible. Staff needs additional time to evaluate the new models to determine which will best meet our needs. The funding has also been increased up from $24,000 to $28,000 to allow sufficient money to fund a potentially larger mower. The 2013 projects essentially become the capital outlay portion of the budget. The remaining year's projects are then used to evaluate the solvency and funding adequacy of each capital projects fund and the utility funds over the ten years shown in the plan. Staff recommends that certain projects specifically approved by the City Council be delegated to staff to complete as long as the total cost is at or below the amount listed in the CIP. If a project exceeds the budgeted amount, staff will bring that back for a budget amendment prior to purchase. All other projects will be brought back to the City Council for approval prior to purchase. A list is included as an attachment. Fund 490 — Southshore Center Operations have undergone significant changes this year. Community Recreation Resources has been contracted to run the center with greatly expanded hours of operation. Staff worked with Kristi Anderson, principal for CRR, on an amended agreement which was adopted by the City Council in January, 2012. The budget has been modified to make clearer which expenditures are includes in specific line items. Fund 601— Water The City Council is interviewing financial advisory firms to determine if the City should refund water bonds in order to take advantage of low interest rates. Fund 611— Sewer A rate study should be performed after a decision has been made regarding use of this fund balance to cover project costs for the Storm Water fund. Fund 621— Recycling No changes from the previous presentation. Fund 631— Storm Water is actually profitable in a financial accounting sense, but the cash drain created by new projects needs to be covered. This should be included in the Sewer Fund rate study. Financial or Budget Considerations: Several funds do not have adequate resources to cover the operations and capital items listed. The Park Capital Improvement fund runs out of money in 2014 if all the Badger Park items are funded. The Equipment Replacement fund runs out of money in 2015 if no additional funding sources are found. The Community Infrastructure fund runs out of money in 2020 if no adjustments are made. The Southshore Center fund will need additional support from either neighboring communities or from the General Fund to continue operations. The Storm Water fund runs out of cash in 2015 if no adjustments are made. The plan discussed last year anticipates transfers from the Sewer fund to cover new storm drainage projects if bonding is not used as a financing source. City Council should prioritize the projects in each of these funds and determine a method of funding the highest ranking projects over the selected time horizon. Recommendation / Action Requested: Staff recommends that the City Council review the budgeted expenditures for the 2013 -2022 CIP and 2013 enterprise budgets and direct staff to make any changes that are desired. Next Steps and Timelines: Adoption of the 2013 Budget and 2013 -2022 CIP is anticipated for December 10. Connection to Vision / Mission: These purchases contribute to providing excellent public services by maintaining high quality, reliable public utility services and infrastructure. 2022 Total 55,000 50,000 3,000 75,000 5,000 6,500 7,000 7,000 20,000 50,000 100,000 200,000 8,000 8,500 200,000 12,000 20,000 80,000 65,000 5,400 2,000 2,500 2,500 75,000 14,000 15,000 20,000 5,000 55,000 50,000 75,000 3,000 3,000 11,500 20,500 20,000 50,000 100,000 10,000 216,500 200,000 12,000 20,000 80,000 65,000 30,000 8,000 5,400 7,000 60,000 14,000 75,000 15,000 5,000 402 - Park Capital Improvement Gideon Glen Parking Lot & Signage P0003 5 20,000 Freeman Plaza P0100 5 Freeman North Playground Equipment P0102 4 Freeman Parking Lot w/ MCWD P0103 5 Freeman Ball Field Lights P0104 5 Freeman Picnic Shelter Re -Roof P0105 4 Freeman Park - Eddy Station P0108 4 8,500 Cathcart Park - Resurface P0200 1 Tennis /Basketball Courts Cathcart Park Hockey Boards P0201 3 Cathcart Park Tot Lot P0202 5 Cathcart Parking Lot P0203 5 Badger Park - Rustic Trail P0300 3 10,000 Badger Park Tennis Courts P0301 2 Badger Park Hockey Rink P0302 2 Badger Park Swing Set P0303 2 Badger Park Green Space P0304 2 Badger Park Warming House P0305 2 Badger Park Playground Equipment P0306 2 Manor Park - Versa -Court Tennis Surface PO400 1 30,000 Manor Park - Water Source for Garden PO401 1 8,000 Manor Park - Shelter Outside Floor & PO402 1 Stoops Silverwood Park - Resurface 1/2 court P0500 2 Silverwood Park Equipment P0501 3 60,000 Silverwood Park Swing Set P0502 3 Skate Park Rehab P0600 3 Skate Park Picnic Shelter P0601 5 Skate Park - Community Garden Fencing P0602 5 5,000 55,000 50,000 3,000 75,000 5,000 6,500 7,000 7,000 20,000 50,000 100,000 200,000 8,000 8,500 200,000 12,000 20,000 80,000 65,000 5,400 2,000 2,500 2,500 75,000 14,000 15,000 20,000 5,000 55,000 50,000 75,000 3,000 3,000 11,500 20,500 20,000 50,000 100,000 10,000 216,500 200,000 12,000 20,000 80,000 65,000 30,000 8,000 5,400 7,000 60,000 14,000 75,000 15,000 5,000 Department # Priority 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 Total 402 - Park Capital Improvement Total 141 652 28 3 113 134 19 128 9 3 1,232,900 403 - Equipment Replacement Replace Unit 21 - 24' trailer E -12 -01 2 16,000 16,000 Sand Pro 3000 - replace Unit 64 E -12 -02 2 13,000 13,000 Groundsmaster Mower- Toro 328D - E -12 -03 2 28,000 30,000 58,000 replace unit 75 Air Compressor - Replace unit 38 E -13 -01 3 12,000 12,000 Dump Truck - replace unit 65 E -13 -02 3 160,000 160,000 Dump Truck - Replace Unit 68 E -13 -03 2 165,000 165,000 Pickup 44 - Replace Unit 78 E -13 -04 3 38,000 38,000 Cab for mower - replace A3 E -13 -05 3 8,000 8,000 Utility Truck w /crane & toolbox replace E -14 -01 5 77,000 77,000 unit 76 Mower - Replace Unit 84 E -14 -02 4 25,000 25,000 Utility Vehicle - replace unit 77 E -14 -03 4 26,000 26,000 Blower Attachment for Skid Steer E -14 -04 4 12,500 12,500 Cab attachement for mower replace unit E -14 -05 4 7,000 7,000 A4 Pick -up - 4 x 4 150 Replace Unit 80 E -15 -01 5 35,000 35,000 Dump Truck - replace unit 72 E -15 -03 5 175,000 175,000 Trailer 18' replace unit 59 E -16 -01 5 15,000 15,000 Sewer Jetter - replace unit 60 E -16 -02 5 53,000 53,000 Pickup - 350 44 replace unit 81 E- -17 -01 5 42,000 42,000 Groundsmaster Mower replace unit 91 E -17 -02 5 28,000 28,000 Cab for mower replace A4 E -17 -04 5 7,000 7,000 Skid Steer - replace unit 63 E -19 -01 5 46,000 46,000 ATV - replace unit 34 E -19 -02 5 20,000 20,000 4 pump replace unit 50 E -20 -01 5 45,000 45,000 Trailer 12' replace unit 69 E -20 -02 5 4,000 4,000 Pickup 350 44 - replace unit 91 E -20 -04 5 42,000 42,000 Sweeper - replace unit 74 E -21 -01 5 190,000 190,000 Cab for mower - replace A3 E -21 -03 5 8,000 8,000 Flatbed - 4 x 2 Replace unit 49 E -24 -01 5 44,000 44,000 Broom Attachment - Skid Steer replace E -25 -02 5 3,000 3,000 A13 Street Sign Replacement LR -99 -001 2 6,300 6,600 6,900 7,200 7,500 7,800 8,100 8,400 8,700 9,000 76,500 South Shore Community Center PF -11 -01 n/a 2,500 43,000 41,000 2,000 88,500 Public Works Building PF -12 -01 n/a 4,000 10,000 81,000 95,000 Financial Software T -12 -03 2 90,000 90,000 Department # Priority 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 Total Network Connection T -13 -01 2 20,000 20,000 Laserfiche Upgrade T -13 -02 2 8,000 8,000 Color Copier Replacement T -13 -03 2 9,000 9,000 Computer Upgrades T-99-99 1 20,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 110,000 403 - Equipment Replacement Total 380 216 256 258 263 71 68 253 82 19 1,871,500 404 - Street Reconstruction Afton Road LR -11 -01 1 33,000 33,000 Elbert Point LR -13 -01 3 27,000 27,000 KcKinley Circle LR -13 -02 3 21,000 21,000 McLain Road LR -13 -03 3 26,000 26,000 Shady Hills Rd (& Alley) LR -13 -04 3 58,000 58,000 Shore Road LR -13 -05 3 26,000 26,000 Valleywood Circle & Lane LR -13 -06 3 601,000 601,000 Charleston Circle LR -14 -01 4 36,000 36,000 Club Valley Road LR -14 -02 4 29,000 29,000 Lake Virginia Drive LR -14 -03 4 63,000 63,000 Radisson Entrance LR -14 -04 4 33,000 33,000 Shady Lane LR -14 -05 4 24,000 24,000 Sunnyvale Lane LR -14 -06 4 228,000 228,000 Timber Lane LR -14 -07 4 55,000 55,000 Chaska Road LR -15 -01 5 87,000 87,000 Mayflower Road LR -15 -02 5 33,000 33,000 McKinley Court LR -15 -03 5 40,000 40,000 Murray Hill Road LR -15 -04 5 52,000 52,000 Star Circle & Lane LR -15 -05 5 453,000 453,000 Summit Avenue LR -15 -06 5 32,000 32,000 Amlee Road LR -16 -01 5 332,000 332,000 Garden Road LR -16 -02 5 42,000 42,000 Gillette Curve LR -16 -03 5 35,000 35,000 Manitou Lane LR -16 -04 5 317,000 317,000 McKinley Place N & S LR -16 -05 5 65,000 65,000 Shady Hills Circle LR -16 -06 5 51,000 51,000 Echo Road LR -17 -01 5 71,000 71,000 Howards Point Road LR -17 -02 5 180,000 180,000 Kathleen Court LR -17 -03 5 22,000 22,000 Oak Ridge Circle LR -17 -04 5 29,000 29,000 Riviera Lane LR -17 -05 5 371,000 371,000 Shorewood Lane LR -17 -06 5 432,000 432,000 Department # Priority 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 Total Mann Lane LR -18 -01 5 444,000 444,000 Maple Street LR -18 -02 5 100,000 100,000 Bayswater Road LR -19 -01 5 100,000 100,000 Boulder Circle LR -19 -02 5 49,000 49,000 Christmas Lane W LR -19 -03 5 32,000 32,000 Lilac Lane LR -19 -05 5 46,000 46,000 Strawberry Lane LR -19 -06 5 85,000 85,000 Vine Street LR -19 -07 5 33,000 33,000 Birch Bluff Road LR -20 -01 5 107,000 107,000 Excelsior Blvd LR -20 -02 5 19,000 19,000 Seamans Drive LR -20 -03 5 629,000 629,000 West Lane LR -20 -04 5 32,000 32,000 Christmas Lane E LR -21 -01 5 21,000 21,000 Christmas Lake Road LR -21 -02 5 107,000 107,000 Country Club Road LR -21 -03 5 95,000 95,000 Maintenance - Bituminous Sealcoating LR -99 -100 1 220,000 270,000 228,000 245,000 184,000 238,000 305,000 274,000 255,000 2 404 - Street Reconstruction Total 955 3 000 762 958 1 1 782 650 1 478 8,022,000 405 - MSA Construction Eureka Road N LR -19 -04 5 1,922,000 1,922,000 405 - MSA Construction Total 1 1,922,000 406 - Trails Trail Connection to LRT Tool 1 72,000 72,000 Smithtown from West Border to T002 1 357,500 357,500 Minnewashta Elem Galpin Lake Rd T003 1 192,500 192,500 Mill Street T004 1 137,500 137,500 From 7/41 to Chanhassen Trail T005 1 24,000 24,000 Smithtown from Minnewashta to 19 T006 1 412,500 412,500 Strawberry Lane T007 1 192,500 192,500 County Road 19 from Pub Works to T008 1 220,000 220,000 Excelsior St. Albans Bay Rd T009 1 110,000 110,000 Edgewood Road Tolo 1 165,000 165,000 Excelsior Blvd Trail T011 1 30,000 30,000 406 - Trails Total 459 192 137 24 412 192 220 110 165 1,913,500 Department # Priority 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 Total 601 - Water Radio /ISP Communications System W-10-01 1 80,000 80,000 Water Main - Star Circle & Lane W -11 -02 n/a 130,000 130,000 Water Main - Valleywood Circle & Lane W-12-01 n/a 272,000 272,000 Water Main - Sunnyvale Lane W -13 -02 n/a 100,000 100,000 W. Water Tower - Rehab & Painting W -13 -03 3 450,000 450,000 Water Interconnect with Excelsior W -13 -04 3 251,400 251 HWY 7 Water Main Crossing W -13 -05 3 311,300 311,300 601 - Water Total 1 3 364 3 700 100 130 3 000 1,594,700 611 - Sewer Radio /ISP Communications - Lift Station SS -10 -10 1 40,000 10,000 50,000 Retrofit Lift Station 11 Rehab - 20465 Radisson SS -13 -01 3 180,000 180,000 Rd. Lift Station 11 Force Main Separation SS -13 -02 3 194,800 194,800 Lift Station 9 Rehab - 20995 Minnetonka SS -14 -01 3 120,000 120,000 Blvd Lift Station 10 Rehab - 4773 Lakeway SS -15 -01 3 80,000 80,000 Terrace Lift Station 20 Rehab - 26550 Noble Road SS -16 -01 3 70,000 70,000 Lift Station 7 Rehab - 5600 Woodside SS -16 -02 3 80,000 80,000 Road Lift Station 18 Rehab - 4996 Shady Island SS -17 -01 3 10,000 10,000 Point Infiltration and Inflow Reduction SS -99 -05 1 7 0,000 7 0,000 7 0,000 7 0,000 7 0,000 7 0,000 7 0,000 7 0,000 7 0,000 630,000 611 - Sewer Total 484 200 150 220 80 70 70 70 70 1,414,800 631 - Stormwater Management Lake South Auto Drainage - WSB Report STM -12 -05 3 24,000 24,000 Valleywood Circle & Lane - Drainage STM -12 -08 4 142,000 142,000 Shorewood Lane Ditch STM -13 -01 4 70,000 70,000 Sunnyvale Lane Drainage STM -13 -02 4 192,000 192,000 Excelsior Blvd Drainage STM -13 -03 4 40,000 40,000 Club Valley Drainage STM -14 -01 4 101,000 101,000 6120 Riviera Drainage - WSB Report STM -14 -04 3 19,000 19,000 Star Circle & Lane STM -15 -01 5 31,000 31,000 Grant Lorenz STM -15 -02 5 50,000 50,000 50,000 150,000 23350 Academy Drainage STM -15 -04 4 75,000 75,000 Department # Priority 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 Total Garden Road STM -15 -05 4 26,000 26,000 Amlee /Glen Road STM -16 -01 4 381,000 381,000 Manitou Lane STM -16 -02 4 75,000 75,000 Riveria Lane STM -17 -01 4 87,000 87,000 Shorewood Lane STM -17 -02 4 99,000 99,000 Mann Lane STM -18 -01 4 105,000 105,000 Maple St STM -18 -02 4 24,000 24,000 Eureka Road N STM -19 -01 4 452,000 452,000 Seamans Drive STM -20 -01 4 148,000 148,000 Rampart Ct. Drainage STM -22 -01 1 11,880 11,880 631 - Stormwater Management Total 252 3 000 336 182 506 236 129 452 148 11 2,252,880 GRAND TOTAL 4 2,459,100 1,842,900 2,098,700 2,394,000 1,379,800 3,401,100 1,771,300 805,200 33,880 20,224,280 PARK CAPITAL IMPROVEMENT FUND Fund: 402- Park Capital Outlay Actual Actual Actual Estimate Budget REVENUES 2009 2010 2011 2012 2013 Beginning Fund Balance 262,710 293,430 190,380 150,958 153,273 Park Dedication Fees - 10,000 - 10,000 30,000 Interest Earnings* 2 2 964 755 800 Contributions / donations - - - - - Concession Sales 394 - Grants - 104 Miscellaneous revenue - - - - - Transfers in 45,000 42,000 42,000 42,000 42,000 TOTAL REVENUES 48,165 158,930 42,964 52,755 72,800 EXPENDITURES OTHER SERVICES Contractrual Services 3,800 - - - - Miscellaneous Charges 40 TOTAL OTHER SERVICES 3,840 - - - - CAPITAL OUTLAY Other Improvements 13,605 261,980 82,386 50,440 141,500 TOTAL CAPITAL OUTLAY 13,605 261,980 82,386 50,440 141,500 TOTAL EXPENDITURES 17,445 261,980 82,386 50,440 141,500 Revenue - Over/(under) 30,720 (103,050) (39,422) 2,315 (68,700) Ending Fund Balance 293,430 190,380 150,958 153,273 84,573 EQUIPMENT REPLACEMENT FUND Fund: 403 - Equipment & Building Capital Outlay Actual Actual Actual Budget Budget REVENUES 2009 2010 2011 2012 2013 Beginning Fund Balance 671,447 842,786 732,105 521,172 181,772 Interest Earnings 7 8,495 4 2,600 900 Miscellaneous Income - - 6,271 - - Sale of Old Equipment - 31 - - - Transfers in 175,000 100,000 50,000 50,000 58,500 TOTAL REVENUES 182,282 139,625 61,059 52,600 59,400 EXPENDITURES OTHER SERVICES Contractual Services 1 - - - - Bank Charges 71 - TOTAL OTHER SERVICES 1,197 - - - - CAPITAL OUTLAY Machinery and Equipment 9,746 250,306 271,992 392,000 213,300 TOTAL CAPITAL OUTLAY 9,746 250,306 271,992 392,000 213,300 TOTAL EXPENDITURES 10,943 250,306 271,992 392,000 213,300 Revenue over /(under) 171,339 (110,681) (210,933) (339,400) (153,900) Ending Fund Balance 842,786 732,105 521,172 181,772 27,872 Available funds in 401- Public Facilities 178,089 Available funds in 408 - Technology 79,089 257,178 STREET RECONSTRUCTION FUND Fund: 404 - Street Capital Outlay Actual Actual Actual Budget Budget REVENUES 2009 2010 2011 2012 2013 Beginning Fund Balance 1,625,965 1,619,643 1,311,707 1,481,482 1,740,882 MSA Maintenance Money - - - - - Interest Earnings 11 13,981 11 7 8,700 Transfers in 700,000 712 700,000 700,000 714,000 Total Revenue 711,142 726,116 711,413 707,400 722,700 EXPENDITURES CAPITAL OUTLAY Other Improvements 717 1,034,052 541,638 448,000 955,000 TOTAL CAPITAL OUTLAY 717,464 1,034,052 541,638 448,000 955,000 TOTAL EXPENDITURES 717,464 1,034,052 541,638 448,000 955,000 Revenue over /under) (6,322) (307,936) 169,775 259,400 (232,300) Ending Fund Balance 1,619,643 1,311,707 1,481,482 1,740,882 1,508,582 MSA STREET CONSTRUCTION FUND Fund: 405 - MSA Capital Outlay EXPENDITURES MATERIALS & SUPPLIES General Supplies TOTAL MATERIALS & SUPPLIES OTHER SERVICES Miscellaneous Services 15 167 TOTAL OTHER SERVICES - 15 167 - - CAPITAL OUTLAY Other Improvements TOTAL CAPITAL OUTLAY - - - - - TOTAL EXPENDITURES - 15 167 - - Revenue over /(under) 3,594 4,078 901 700 700 Ending Fund Balance 127,671 131,749 132,650 133,350 134,050 MSA Construction Account Balance - at MN DOT 120,956 325,606 coming in Oct Actual Actual Actual Budget Budget REVENUES 2009 2010 2011 2012 2013 Beginning Fund Balance 124,011 127,671 131,749 132,650 133,350 MSA Construction Money - - - - - Interest Earnings 3,594 4,093 1,068 700 700 Transfers in - - - - - Total Revenue 3,594 4,093 1,068 700 700 EXPENDITURES MATERIALS & SUPPLIES General Supplies TOTAL MATERIALS & SUPPLIES OTHER SERVICES Miscellaneous Services 15 167 TOTAL OTHER SERVICES - 15 167 - - CAPITAL OUTLAY Other Improvements TOTAL CAPITAL OUTLAY - - - - - TOTAL EXPENDITURES - 15 167 - - Revenue over /(under) 3,594 4,078 901 700 700 Ending Fund Balance 127,671 131,749 132,650 133,350 134,050 MSA Construction Account Balance - at MN DOT 120,956 325,606 coming in Oct TRAIL CONSTRUCTION FUND Fund: 406 - Trail Capital Outlay Actual Actual Actual Budget Budget REVENUES 2009 2010 2011 2012 2013 Beginning Fund Balance - - - - - Interest Earnings - - - - - Grants - - - 54,000 - Transfers in - - - 18,000 459,500 Total Revenue - - - 72,000 459,500 EXPENDITURES CAPITAL OUTLAY Other Improvements - - - 72,000 459,500 TOTAL CAPITAL OUTLAY - - - 72,000 459,500 TOTAL EXPENDITURES - - - 72,000 459,500 Revenue over /under) - - - - - Ending Fund Balance - - - - - COMMUNITY INFRASTRUCTURE FUND Fund: 450- Community -wide Capital Outlay CAPITAL OUTLAY Actual Actual Actual Budget Budget REVENUES 2009 2010 2011 2012 2012 Beginning Cash Balance - 1 1 1 1 Interest Earnings - 13,206 15,827 8,400 8,300 Miscellaneous Income - - - - - Transfers in 1,000,000 854,590 - - - Total Revenues 1 867,796 15,827 8 8 EXPENDITURES OTHER SERVICES Miscellaneous Services - 13 - - - TOTAL OTHER SERVICES - 13 - - - CAPITAL OUTLAY Other Improvements - - 150,068 - - TOTAL CAPITAL OUTLAY - - 150,068 - - Transfers out 54,132 18,000 459,500 Total - - 54,132 18,000 459,500 TOTAL EXPENDITURES - 13 204,200 18,000 459,500 Revenue over /under) 1,000,000 867,783 (188,373) (9,600) (451,200) Ending Cash Balance 1 1 1 1 11218,610 SOUTHSHORE COMMUNITY CENTER Revenue Coding: 490 - Expenditure Coding: 490- 48000- Requested Actual Actual Budget YTD Budget Percent Dollar REVENUES 2010 2011 2012 2012 2013 Change Change Beginning Cash Balance - 13,204 13,504 34101 Rentals 48,000 61,801 75,000 29,331 55,000 -27% (20,000) 34790 Class fees 2,500 9,958 2,500 14,272 15,500 520% 13,000 36210 Interest Income 100 - 100 - 100 0% 0 36230 Contributions /Donations 1,500 7,942 1,000 1,019 1,000 0% 0 36270 Miscellaneous Revenue 4,000 411 1,500 436 1,500 0% 0 39201 Transfers In 48,591 13,600 - 47,700 251% 34,100 TOTAL REVENUES 56,100 128,703 93,700 45,058 120,800 29% 27,100 EXPENDITURES MATERIALS & SUPPLIES 200 Office Supplies 190 0 208 Postage 460 0 223 Maintenance of Building 7,200 317 7,500 3,925 5,000 -33% (2,500) 245 General Supplies 800 4,917 800 1,194 800 0% 0 246 Program Expense 12,417 13,000 13,000 247 Community Event Expense 4,003 4,000 4,000 TOTAL MATERIALS & SUPPLIES 8,000 5,234 8,300 22,189 22,800 175% 14,500 OTHER SERVICES 302 Consulting Fees 54,282 71,000 71,000 304 Legal - - - - - 0 321 Communication 20 610 100 1,114 1,500 1400% 1,400 351 Print /Publish 1,000 1,492 1,000 1,403 1,500 50% 500 360 Insurance -Total 2,500 325 3,000 - 1,000 -67% (2,000) 380 Utilities 11,000 14,567 11,000 9,834 11,000 0% 0 400 Contractual 30,000 50,540 60,000 4,130 10,000 -83% (50,000) 410 Rentals 2,245 0 433 Dues & Subscriptions 204 0 437 Taxes /Licenses 728 0 440 Misc. Services 10,000 13,357 10,000 575 2,000 -80% (8,000) 450 Bank Service Charges 599 - 29 - 0 TOTAL OTHER SERVICES 54,520 81,490 85,100 74,544 98,000 15% 12,900 CAPITAL OUTLAY 540 Building & Structures 24,261 0 TOTAL CAPITAL OUTLAY 24,261 0 TOTAL EXPENDITURES 62,520 110,985 93,400 96,733 120,800 -16% 27,400 Revenues over /(under) (6,420) 17,718 300 (51,675) Ending Cash Balance 13,204 13,504 13,504 WATER FUND 212 Motor Fuel & Lube 221 Maint- Equipment 4,244 223 Maint - Buildings 252 240 Small Tools 290 245 General Supplies 7,608 260 Wtr Purch -Tonka Bay 2,125 261 Wtr Purch - Excelsior 18,892 #DIV /01 0 3,027 6,500 5,494 6,500 0% 0 444 1,000 1,452 1,000 0% 0 43 550 686 550 0% 0 10,457 10,000 8,649 10,000 0% 0 2,662 3,300 1,207 3,300 0% 0 20,001 17,500 16,714 17,500 0% 0 262 Wtr Purch - Mtka 687 263 Wtr Purch - Chan 11,380 265 Water Meters 5,631 1,269 1,000 400 1,000 0% 0 13,122 12,000 9,606 12,000 0% 0 4,024 5,000 8,555 15,000 200% 10,000 Total Supplies 52,344 Other Services & Charges 302 Consulting - 56,403 58,150 53,843 68,150 17% 10,000 - - 3,000 - #DIV /01 0 312 Engineering - Feasiblity stage - 321 Communication 978 - - - #DIV /01 0 822 1,500 574 2,500 67% 1,000 331 Travel, Conf,Sch 350 351 Print /Publish 628 360 Insurance -Total 7,816 700 600 525 600 0% 0 583 1,000 558 1,000 0% 0 - 8,000 - 8,000 0% 0 394 Utilities - Amesbury 9,672 395 Utilities - Badger 10,243 397 Utilities - Woodhaven - 11,620 10,000 7,753 11,000 10% 1,000 11,645 11,000 5,756 11,000 0% 0 - - - #DIV /01 0 398 Utilities - SE Area /Tower 29,892 30,277 30,000 21,657 30,000 0% 0 410 Rental - - - - #DIV /01 0 433 Subscrip- Member - 437 Licenses -Sales Taxes 4,382 440 Misc. Services 126 450 Bank Svc Chgs 95 - - - #DIV /01 0 3,164 3,000 - 3,000 0% 0 137 200 196 200 0% 0 - 525 8 525 0% 0 Total Other Services & Charges 378,987 540 Machinery -Equip - 580 Other Improve 2,446 376,784 388,075 69,985 413,575 7% 25,500 - 0 34,543 - - - 0 Total Capital Outlay 2,446 Debt Service 611 Bond Interest 124,656 620 Fiscal Agent Fees 750 Total Transfers - 34,543 - - - - 115,975 103,398 53,578 103,398 0% 0 753 1,500 323 1,500 0% 0 - - - 0 TOTAL EXPENSES 643,781 690,362 650,416 266,027 695,208 7% 46,581 REVENUES OVER /(UNDER) EXPENSES 56,894 30,290 153,084 381,504 8,292 Ending Cash Balance 3,638,748 3,670,508 3,823,592 3,831,884 SEWER FUND Revenue Coding: 611 - Expenditure Coding: 611-49450 - Requested Actual Actual Budget YTD Budget Percent Dollar REVENUES 2010 2011 2012 2012 2013 Change Change Beginning Cash Balance 3,776,321 3,544,245 3,272,684 36210 Interest Earnings 38,439 27,939 36,000 - 36,000 29% 8,061 37210 Sewer Sery Charges 812,537 792,420 825,000 621,453 825,000 4% 32,580 37220 Sewer Chg -Cnty Call 28,456 25,877 - (25,877) 37250 Local SAC Charges 2,400 - - 2,400 - - 37270 Sewer Permits 1,650 1,200 700 1,800 700 -42% (500) 39201 Tsfr From Other Funds 60,000 - - - - Total Revenues 943,482 847,436 861,700 625,653 861,700 2% 14,264 EXPENSES Personal Services 101 Regular Salaries 53,842 76,410 71,179 41,796 71,331 -7% (5,079) 102 O.T. Salaries 922 2,177 1,200 2,546 2,000 (177) 121 PERA City Share 3,740 5,541 5,260 3,197 5,316 -4% (225) 122 FICA City Share 4,004 5,690 5,545 3,230 5,610 -1% (80) 131 Ins. City Share 6,538 10,177 9,017 3,391 9,017 -11% (1,160) 151 Workers Compensation 683 2,152 Total Personal Services 69,729 99,995 92,201 56,312 93,274 -7/ (6,721) Supplies 200 Office Supplies 102 105 110 109 110 5 208 Postage 1,211 1,299 1,500 946 1,500 15% 201 221 Maint- Equipment 14,640 1,673 5,000 1,182 5,000 199% 3,327 240 Small Tools 79 120 550 45 5,550 4525% 5,430 245 General Supplies 919 1,519 2,100 550 2,100 38% 581 Total Supplies 16,951 4,716 9,260 2,832 14,260 202% 9,544 Other Services & Charges 300 Financial & Audit 2,250 - 2,250 - 2,250 2,250 303 Engineering 5,000 308 Consulting - 1,500 204 1,500 1,500 313 Engineering - Design Stage 4,634 - 5,000 583 5,000 5,000 321 Communication 3,806 4,108 4,000 2,534 4,500 10% 392 331 Travel, Conf,Sch 934 1,300 1,500 - 1,500 15% 200 360 Insurance -Total 5,225 - 6,500 773 6,500 6,500 380 Utilities- Gas /Elec 5,919 6,518 6,000 3,486 6,000 -8% (518) 385 MCES Service Charges 564,332 714,110 728,000 506,631 753,480 6% 39,370 386 Excelsior Sewer Chg 29,941 29,988 31,000 22,437 31,000 3% 1,012 400 Contractual 31,825 42,521 20,000 7,859 20,000 -53% (22,521) 420 Depreciation 218,483 214,247 225,000 - 225,000 5% 10,753 440 Misc. Services 126 160 150 195 150 -6% (10) 450 Service Charges 110 4 900 - 900 22400% 896 Total Other Services & Charges 867,850 1,012,956 1,031,800 544,702 1,062,780 5% 44,824 Capital Outlay 580 Other Improve 25,643 29,889 22,015 (29,889) Total Capital Outlay 25,643 29,889 - 22,015 - (29,889) Transfers 720 Permanent - - - Total Transfers TOTAL EXPENSES 980,173 1,147,556 1,133,261 625,861 1,170,314 2% 17,758 REVENUES OVER /(UNDER) EXPENSES (36,691) (300,120) (271,561) (208) (308,614) Ending Cash Balance 3,776,321 3,544,245 3,272,684 2,964,070 RECYCLING FUND Revenue Coding: 621 - Expenditure Coding: 621 -49550 Total Revenues 178,495 185,799 184,350 140,289 Requested 0% Actual Actual Budget YTD Budget Percent Dollar REVENUES 2010 2011 2012 2012 2013 Change Change Beginning Cash Balance 43,390 53,146 53,412 33620 County Recycling Aid 23,560 23,086 23,000 23,007 23,000 0% - 33621 County Park Recycling Grant 10,500 - 986 - 36101 Special Assessment - 5,184 - 102 O.T. Salaries - 36210 Interest Earnings 656 319 350 - 350 0% - 37310 Recycling Service Charges 154,279 147,957 155,000 119,513 155,000 0% - 37320 City Clean -up Fees - (1,247) 6,000 (2,231) 6,000 0% - 37330 Recycling Bin Sales - - - - - - 37340 Revenue from Contractor - - - - - - 39201 Transfers from Other Funds - - - - - - Total Revenues 178,495 185,799 184,350 140,289 184,350 0% - EXPENSES Personal Services 101 Regular Salaries - 986 - - - - 102 O.T. Salaries 788 997 1,000 851 1,000 0% - 103 Part Time Salaries 4,307 3,223 5,330 3,153 5,251 -1% (79) 121 PERA City Share 353 368 459 272 450 -2% (9) 122 FICA City Share 388 388 485 302 475 -2% (10) 131 Ins. City Share - 219 619 234 619 0% - 151 Workers Comp - - - 190 - - Total Personal Services 5,836 6,181 7,892 5,002 7,795 -1% (97) Supplies 200 Office Supplies 102 105 100 110 100 0% - 208 Postage 1,211 1,176 900 1,062 900 0% - 245 General Supplies 170 352 200 665 200 0% - Total Supplies 1,483 1,633 1,200 1,837 1,200 0% - Other Services & Charges 400 Contractual 166,449 166,668 166,992 124,206 166,992 0% 324 440 Misc. Services 8,405 112 8,000 74 8,000 7043% 7,888 450 Service Charges - 241 - - - -100% (241) Total Other Services & Charges 174,854 167,021 174,992 124,280 174,992 0% 7,971 TOTAL EXPENSES 182,173 174,835 184,084 131,119 183,987 5% (97) REVENUES OVER /(UNDER) EXPENSES (3,678) 10,964 266 9,170 363 STORMWATER MANAGEMENT FUND Revenue Coding: 631 - Expenditure Coding: 631- 49600- REVENUES Beginning Cash Balance 33620 Grant Proceeds 36101 Special Assessments 36210 Interest Earnings 36270 Miscellaneous Revenue 37175 Cellular Antenna Revenue 37410 Storm Utility Charges 39201 Transfers /Internal Loans Total Revenues 209,431 200,300 210,775 144,534 208,675 -1% (2,100) EXPENSES Personal Services Requested Actual Actual Budget YTD Budget Percent Dollar 2010 2011 2012 2012 2013 Change Change 30,843 665,518 214,142 296,866 5,202 - 5,100 - 5,100 0% - 7,651 6,957 - - - - 5,637 4,331 5,100 - 3,000 -41% (2,100) 122 - 75 - 75 0% - 190,819 189,012 200,500 144,534 200,500 0% - Total Revenues 209,431 200,300 210,775 144,534 208,675 -1% (2,100) EXPENSES Personal Services 101 Regular Salaries 17,816 34 28,478 30,843 28,478 0% - 102 O.T. Salaries 158 163 - 103 Part Time Salaries - 121 PERA City Share 1 2,543 2,065 2 2,065 0% - 122 FICA City Share 1 2,632 2 2,352 2 0% - 131 Ins. City Share 2 4,643 2,879 1,053 2,879 0% - 151 Workers Comp - - - 666 - Total Personal Services 22,737 44,715 35,601 37,319 35,601 0% 2,879 Supplies 200 Office Supplies 102 105 109 100 100 208 Postage 1 1 350 946 1,000 186% 650 221 Maint- Equipment - - 5,500 - 5,500 0% - 240 Small Tools - - 300 - 300 0% - 245 General Supplies 1 2 3,000 310 3,000 0% - Total Supplies 2,581 3,564 9,150 1,365 9,900 8% 750 Other Services & Charges 300 Financial & Audit - 303 Engineering 8,384 23,869 5,000 1,811 5,000 0% - 304 Legal 46 241 1,000 185 1,000 0% - 313 Engineering - Design Stage 1 5,198 5,000 5,955 5,000 0% - 321 Communication - - - - 500 500 351 Print /Publish - 324 100 64 100 0% - 360 Insurance -Total - - 400 Contractual 40,871 41 50,000 182,616 50,000 0% - 420 Depreciation 19,833 25,250 20,000 - 22,000 10% 2,000 433 Subscrip- Member - 600 - 600 0% - 440 Misc. Services 1 117 1 935 1 0% - 450 Service Charges 14 - 500 - 500 0% - Total Other Services & Charges 72,314 96,751 83,300 191,566 85,800 3% 2,500 Capital Outlay 510 Land - 580 Other Improvements 33,475 88,004 36,187 - - Total Capital Outlay 33,475 88,004 - 36,187 - - TOTAL EXPENSES 131,107 233,034 128,051 266,437 131,301 3% 6,129 REVENUES OVER /(UNDER) EXPENSES 78,324 (32,734) 82,724 (121,903) 77,374 1:(2 U2 Cit y of Shorewood Work Session Item Title / Subject: 2013 General Fund Budget Meeting Date: November 26, 2012 Prepared by: Bruce DeJong, Finance Director Reviewed by: Bill Joynes, Interim City Administrator Attachments: General Fund Budget Worksheets 3 MEETING TYPE Work Session Meeting Policy Consideration: How should General Fund budgets be prioritized and funded? Background: The General Fund budget presented here is essentially unchanged from the preliminary budget approved in August. The only significant change is that the transfer to the Southshore Center has been increased from $40,000 to $47,700 based on an updated budget in that fund. This increased transfer is recommended to come from excess fund balance in the General Fund. Staff intends to present this budget with any modifications made at the work session as the basis for the Truth -in- Taxation budget hearing. Financial or Budget Considerations: This budget provides funding for the basic services that the City provides. Funding it with the resources identified in the budget is a reasonable, one -time method of operating. Long -term, the City Council needs to prioritize projects in the CIP and enterprise budgets and fully fund them either with new user fee revenues, outside funding sources such as partner cities for the Southshore Center, or increased tax levies. The options for long -range funding will be explored at the City Council retreat to be scheduled in early 2013. Recommendation / Action Requested: Staff recommends that the City Council review the budgeted expenditures for the 2013 General Fund budget and direct staff to make any changes that are desired. Next Steps and Timelines: Adoption of the 2013 Budget is anticipated for December 10. Connection to Vision / Mission: This budget contributes to providing excellent public services by maintaining high quality, reliable public services and infrastructure. Mission Statement: The City of Shorewood is committed to providing residents quality public services, a healthy environment, a variety of attractive amenities, a sustainable tax base, and sound financial management through effective, efficient, and visionary leadership. Page 1 GENERAL FUND BUDGET DETAIL Approved Dept Budget Actual Budget Actual Budget Actual Budget YTD Request Percent Dollar 2009 2009 2010 2010 2011 2011 2012 2012 2013 Change Change REVENUES TAXES 31010 GENERAL PROPERTY TAX 4,776,292 4,517,369 4,776,292 4,647,334 4,763,319 4,547,162 4,763,319 1,696,500 4,763,319 0.0% - 31020 DELINQUENT AD VALOREM TAXES - 62,142 - 6,730 - 119,030 - - - - 31040 FISCAL DISPARITIES - 123,858 - 63,140 - 121,002 - - - - TOTAL TAXES 4,776,292 4,703,369 4,776,292 4,717,204 4,763,319 4,787,194 4,763,319 1,696,500 4,763,319 0.0% - LICENSES & PERMITS 32110 LIQUOR LICENSES 8,820 8,320 8,820 810 8,300 8,820 8,300 8,820 8,300 0.0% - 32120 TOBACCO LICENSES 1,000 1,000 1,000 825 1,000 1,000 1,000 250 1,000 0.0% - 32160 TREE TRIMMING LICENSES 450 630 450 570 450 730 450 90 450 0.0% - 32175 RENTAL HOUSING LICENSES 500 1,020 500 1,440 1,000 1,440 1,000 540 1,000 0.0% - 32180 OTHER BUSINESS LICENSES AND PE 1,000 3,555 1,000 4,940 3,100 11,404 3,100 1,427 3,100 0.0% - 32210 BUILDING PERMITS 180,000 97,651 90,000 118,189 70,000 123,141 80,000 51,901 92,000 15.0% 12,000 32215 PLAN CHECK FEES - 12,336 - 23,679 11,000 24,225 12,000 14,994 15,000 25.0% 3,000 32240 DOG LICENSES 3,500 3,321 3,500 3,609 3,300 3,309 3,300 1,271 3,300 0.0% - 32250 HORSE PERMITS - 50 - 50 50 50 50 100 50 0.0% - TOTAL LICENSES & PERMITS 195,264 127,878 105,266 154,112 98,200 174,119 109,200 79,393 124,200 13.7% 15,000 INTERGOVERNMENTAL 33401 LOCAL PERFORMANCE AID - - - - - - 1,000 - 1,000 0.0% - 33404 PERA AID 5,000 4,751 5,000 4,751 4,751 2,375 4,751 - 4,751 0.0% - 33418 MUNICIPAL STATE AID FOR STREET 60,000 61,471 60,000 64,647 64,650 68,217 64,650 34,377 64,650 0.0% - TOTAL INTERGOVERNMENTAL 65,000 66,411 65,000 69,133 69,401 70,592 70,401 34,377 70,401 0.0% - CHARGES FOR SERVICES 34103 ZONING AND SUBDIVISION FEES 4,500 5,738 4,500 1,824 4,500 4,067 4,500 3,393 4,500 0.0% - 34104 PASS -THRU CHARGES - - - 4,750 - (4,235) - 835 - - 34105 SALE OF COPIES 1,000 913 1,000 722 1,000 526 1,000 125 1,000 0.0% - 34107 SPECIAL ASSESSMENT SEARCHES 500 110 500 190 150 250 150 325 150 0.0% - 34780 PARK FEES & RENTALS - 325 - 250 425 525 425 1,171 29,500 6841.2% 29,075 34781 TREE SALES - - - - - - - 6,828 - 34785 PARK DONATIONS 31,000 27,070 31,000 34,146 29,000 32,718 29,000 19,971 - - 100.0% (29,000) TOTAL CHARGES FOR SERVICES 37,000 41,649 37,000 41,882 35,075 33,851 35,075 32,648 35,150 0.2% 75 FINES & FORFEITURES 35101 FINES & FORFEITS 55,000 52,968 55,000 55,806 52,000 48,720 54,500 26,474 57,000 4.6% 2,500 TOTAL FINES & FORFEITURES 55,000 52,968 55,000 55,806 52,000 48,720 54,500 26,474 57,000 4.6% 2,500 MISCELLANEOUS REVENUE 36210 INTEREST EARNINGS 117,000 58,624 95,000 46,769 45,000 25,629 45,000 - 35,000 -22.2% (10,000) 36230 CONTRIBUTIONS AND DONATIONS FR - 820 - - - 1 - - - - 36240 REFUNDS & REIMBURSEMENTS 10,000 11,349 10,000 13,423 - 28,930 - 14,009 10,000 10,000 36250 POP MACHINE REVENUE - - - - - - - - - - 36260 DRY HYDRANT CHARGES 3,500 3,332 3,500 (125) 3,500 245 3,500 4 3,500 0.0% - 36265 CELLULAR ANTENNA REVENUE - - - - - - - - 150,000 150,000 36270 MISCELLANEOUS REVENUE 17,000 8,236 17,000 26,444 15,000 21,217 15,000 9,714 15,000 0.0% - 36275 CONCESSIONS /VENDING 2,500 394 2,500 394 400 394 400 - 400 0.0% - TOTAL MISCELLANEOUS REVENUE 150,000 82,755 128,000 86,905 63,900 77,755 63,900 23,727 213,900 234.7% 150,000 Approved Dept Budget Actual Budget Actual Budget Actual Budget YTD Request Percent Dollar 2009 2009 2010 2010 2011 2011 2012 2012 2013 Change Change TRANSFERS 39202 TRANSFERS FROM ENTERPRISE FUND 40,000 40,000 18,842 33,465 40,000 40,000 40,000 29,320 - - 100.0% (40,000) 39203 TRANSFERS FROM OTHER FUNDS 160,000 - 180,000 - - - - - - - TOTAL TRANSFERS 200,000 40,000 198,842 33,465 40,000 40,000 40,000 29,320 - - 100.0% (40,000) TOTAL REVENUES 5,478,556 5,115,030 5,365,400 5,158,507 5,121,895 5,232,231 5,136,395 1,922,439 5,263,970 2.5% 127,575 EXPENDITURES CITY COUNCIL Personnel 16,794 16,794 16,794 16,794 16,800 16,794 16,800 8,397 16,800 0.0% - Materials and Supplies 1,400 3,064 3,064 1,175 1,300 684 3,000 165 2,000 -33.3% (1,000) Support Services and Charges 52,000 46,158 46,158 45,776 102,430 76,063 86,315 18,801 72,450 -16.1% (13,865) Transfers - - - - - 1,379 13,600 - 47,700 250.7% 34,100 Total City Council 70,194 66,016 66,016 63,745 120,530 94,920 119,715 27,363 138,950 16.1% 19,235 Administration Personnel 374,401 369,882 360,040 399,294 373,996 427,106 319,475 213,545 359,671 12.6% 40,196 Materials and Supplies 23,500 19,924 24,925 17,634 20,800 16,524 24,095 10,172 18,450 -23.4% (5,645) Support Services and Charges 42,900 39,441 39,155 35,881 37,110 41,855 39,935 13,568 42,175 5.6% 2,240 Capital 7,500 6,540 6,200 2,844 - - - 135 - - Total City Administration 448,301 435,787 430,320 455,653 431,906 485,485 383,505 237,420 420,296 9.6% 36,791 FINANCE Personnel 177,637 166,032 177,637 147,242 177,637 163,794 128,416 81,064 132,929 3.5% 4,513 Materials and Supplies 8,200 6,952 8,200 7,576 8,200 7,785 7,300 7,932 8,400 15.1% 1,100 Support Services and Charges 8,500 4,799 8,500 7,222 8,500 13,822 9,150 1,014 11,600 26.8% 2,450 Capital 4,500 2,483 4,500 - 4,500 - - - - - Total Finance 198,837 180,266 198,837 162,040 198,837 185,401 144,866 90,010 152,929 5.6% 8,063 PROFESSIONAL SERVICES Support Services and Charges 205,500 223,859 223,859 178,604 223,859 188,963 199,320 130,640 203,390 2.0% 4,070 Total Professional Services 205,500 223,859 223,859 178,604 223,859 188,963 199,320 130,640 203,390 2.0% 4,070 PLANNING Personnel 199,601 195,474 195,474 175,553 195,474 168,156 170,666 88,269 170,666 0.0% - Materials and Supplies 1,755 2,138 2,138 149 2,138 261 655 - 650 -0.8% (5) Support Services and Charges 11,950 8,990 8,990 6,882 8,990 8,079 9,412 2,509 7,400 -21.4% (2,012) Capital - - - - - - - - 200 200 Total Planning 213,306 206,602 206,602 182,584 206,602 176,496 180,733 90,778 178,916 -1.0% (1,817) MUNICIPAL BUILDINGS Materials and Supplies 26,300 34,321 34,321 51,244 34,321 50,002 16,500 13,380 22,130 34.1% 5,630 Support Services and Charges 139,500 123,958 123,958 54,496 123,958 126,794 157,750 131,095 164,800 4.5% 7,050 Capital 1,000 - - 15,713 - 1,534 - 352 - - Bond Payments 100,120 5,425 5,425 2,959 5,425 - - - - - Transfers 110,000 99,773 99,773 160,368 - 103,950 102,200 - 100,450 -1.7% (1,750) Total Municipal Buildings 376,920 263,477 263,477 284,780 163,704 282,280 276,450 144,827 287,380 4.0% 10,930 POLICE Materials and Supplies - - - 1,367 - - - - - - Support Services and Charges 943,000 943,989 943,989 949,337 943,989 996,771 989,085 494,458 1,015,077 2.6% 25,992 Capital 233,000 232,940 232,940 228,068 232,940 230,068 225,132 112,566 235,437 4.6% 10,305 Total Police 1,176,000 1,176,929 1,176,929 1,178,772 1,176,929 1,226,839 1,214,217 607,024 1,250,514 3.0% 36,297 Approved Dept Budget Actual Budget Actual Budget Actual Budget YTD Request Percent Dollar 2009 2009 2010 2010 2011 2011 2012 2012 2013 Change Change FIRE Support Services and Charges 316,138 323,180 323,180 322,535 323,180 337,131 332,805 165,993 349,582 5.0% 16,777 Capital 284,500 277,270 277,270 272,629 277,270 270,697 277,906 138,953 287,643 3.5% 9,737 Total Fire 600,638 600,450 600,450 595,164 600,450 607,828 610,711 304,946 637,225 4.3% 26,514 PROTECTIVE INSPECTIONS Personnel 122,484 119,184 119,184 115,081 119,184 122,171 118,049 57,517 120,588 2.2% 2,539 Materials and Supplies 750 139 139 28 139 154 200 - 200 0.0% - Support Services and Charges 10,700 5,647 5,647 4,575 5,647 4,438 5,150 631 5,300 2.9% 150 Capital - 1,298 1,298 - 1,298 - - - - - Total Protective Inspections 133,934 126,268 126,268 119,684 126,268 126,763 123,399 58,148 126,088 2.2% 2,689 CITY ENGINEER Personnel 132,594 107,388 107,388 94,497 107,388 96,219 90,872 39,160 92,549 1.8% 1,677 Materials and Supplies 900 741 741 152 741 495 200 104 200 0.0% - Support Services and Charges 18,653 7,639 7,639 8,937 7,639 13,550 11,960 7,018 11,220 -6.2% (740) Capital 8,910 2,854 2,854 538 2,854 1,057 - - - - Total City Engineer 161,057 118,622 118,622 104,124 118,622 111,321 103,032 46,282 103,969 0.9% 937 PUBLIC WORKS SERVICES Personnel 401,668 359,724 414,085 405,101 313,867 389,918 418,633 181,079 428,775 2.4% 10,142 Materials and Supplies 160,900 115,838 164,623 144,931 162,725 159,047 172,575 103,074 171,300 -0.7% (1,275) Support Services and Charges 128,440 119,565 127,949 117,944 145,239 139,759 134,439 48,145 138,550 3.1% 4,111 Capital 3,500 5,003 3,800 - - - - - 1,200 1,200 Transfers 875,000 875,000 800,000 800,000 - 750,000 750,000 - 772,500 3.0% 22,500 Total Public Works Services 1,569,508 1,475,130 1,510,457 1,467,976 621,831 1,438,724 1,475,647 332,298 1,512,325 2.5% 36,678 SNOW AND ICE CONTROL Personnel 41,172 35,995 35,995 55,052 56,567 37,959 55,024 14,979 56,662 3.0% 1,638 Materials and Supplies 45,340 38,457 38,457 32,451 45,117 29 45,117 10,247 45,000 -0.3% (117) Support Services and Charges - - - - - - - - - - Capital - - - - - - - - - - Total Snow and Ice Control 86,512 74,452 74,452 87,503 101,684 67,421 100,141 25,226 101,662 1.5% 1,521 PARKS MAINTENANCE Personnel 147,532 147,532 147,532 153,637 185,708 152,118 100,988 52,583 103,358 2.3% 2,371 Materials and Supplies 10,094 10,094 10,094 14,237 19,800 17,394 18,300 12,307 19,300 5.5% 1,000 Support Services and Charges 109,781 109,781 109,781 96,057 91,900 87,090 26,500 13,652 30,910 16.6% 4,410 Transfers - - - - - - - - - - Total Parks Maintenance 267,407 267,407 267,407 263,931 297,408 256,602 145,788 78,542 153,568 5.3% 7,781 RECREATION Personnel - - - - - - 68,356 19,829 36,360 -46.8% (31,997) Materials and Supplies - - - - - - 1,500 1,000 1,500 0.0% - Support Services and Charges - - - - - - 34,150 11,634 20,145 -41.0% (14,005) Transfers 45,000 45,000 42,000 42,000 - 42,000 42,000 - 42,000 0.0% - Total Recreation 45,000 45,000 42,000 42,000 - 42,000 146,006 32,463 100,005 -31.5% (46,002) GENERAL FUND TOTAL EXPENDITURES 5,553,114 5,260,265 5,305,696 5,186,560 4,388,630 5,291,043 5,223,530 2,205,967 5,367,218 2.8% 143,688 REVENUE OVER /(UNDER) EXPENDITURES (74,558) (145,235) 59,705 (28,054) 733,266 (58,812) (87,135) (283,528) (103,248) 18.5% (16,113) (Planned Use of Fund Balance) GENERAL FUND REVENUE DETAIL REVENUES TAXES 31010 GENERAL PROPERTY TAX 31020 DELINQUENT AD VALOREM TAXES 31040 FISCAL DISPARITIES 31800 OTHER TAXES 31910 PENALTIES AND INTEREST ON AD V 31920 FORFEITED TAX SALE APPORTIONMENT TOTALTAXES 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 32300 DOMESTIC PARTNERSHIP REGISTRATION TOTAL LICENSES & PERMITS INTERGOVERNMENTAL 33401 LOCAL PERFORMANCE AID 33403 MKT VALUE CREDIT AID 33404 PERA AID 33418 MUNICIPAL STATE AID FOR STREET TOTAL INTERGOVERNMENTAL CHARGES FOR SERVICES 34101 CITY HALL RENT 34103 ZONING AND SUBDIVISION FEES 34104 PASS -THRU CHARGES 34105 SALE OF COPIES 34107 SPECIAL ASSESSMENT SEARCHES 34780 RECREATION & CLASS FEES 34781 TREE SALES 34785 PARK DONATIONS TOTAL CHARGES FOR SERVICES Approved Dept Budget Actual Budget Actual Budget Actual Budget YTD Request Percent Dollar 2009 2009 2010 2010 2011 2011 2012 2012 2013 Change Change 4,776,292 4,517,369 4,776,292 4,647,334 4,763,319 4,547,162 4,763,319 1,696,500 4,763,319 0.0% - 62,142 - 6,730 - 119,030 - - 123,858 - 63,140 - 121,002 - 4,776,292 4,703,369 4,776,292 4,717,204 4,763,319 4,787,194 4,763,319 1,696,500 4,763,319 0.0% 8,820 8,320 8,820 810 8,300 8,820 8,300 8,820 8,300 0.0% 1,000 1,000 1,000 825 1,000 1,000 1,000 250 1,000 0.0% 450 630 450 570 450 730 450 90 450 0.0% 500 1,020 500 1,440 1,000 1,440 1,000 540 1,000 0.0% 1,000 3,555 1,000 4,940 3,100 11,404 3,100 1,427 3,100 0.0% 180,000 97,651 90,000 118,189 70,000 123,141 80,000 51,901 92,000 15.0% 12,000 - 12,336 - 23,679 11,000 24,225 12,000 14,994 15,000 25.0% 3,000 3,500 3,321 3,500 3,609 3,300 3,309 3,300 1,271 3,300 0.0% - - 50 - 50 50 50 50 100 50 0.0% 75 1,000 - 1,000 - - - - 196,270 127,883 106,270 154,112 98,200 174,119 109,200 79,393 124,200 13.7% 15,000 - - 1,000 - 1,000 0.0% - 189 - (265) - - 5,000 4,751 5,000 4,751 4,751 2,375 4,751 4,751 0.0% 60,000 61,471 60,000 64,647 64,650 68,217 64,650 34,377 64,650 0.0% 65,000 66,411 65,000 69,133 69,401 70,592 70,401 34,377 70,401 0.0% 9,000 7,493 9,000 - - - - - 4,500 5,738 4,500 1,824 4,500 4,067 4,500 3,393 4,500 0.0% - - - 4,750 - (4,235) - 835 - 1,000 913 1,000 722 1,000 526 1,000 125 1,000 0.0% 500 110 500 190 150 250 150 325 150 0.0% - 325 - 250 425 525 425 1,171 29,500 6841.2% 29,075 6,828 - 31,000 27,070 31,000 34,146 29,000 32,718 29,000 19,971 - 100.0% (29,000 46,000 41,649 46,000 41,882 35,075 33,851 35,075 32,648 35,150 0.2% 75 35101 FINES & FORFEITS 55,000 52,968 55,000 55,806 52,000 48,720 54,500 26,474 57,000 4.6% 2,500 TOTAL FINES & FORFEITURES 55,000 52,968 55,000 55,806 52,000 48,720 54,500 26,474 57,000 4.6% 2,500 MISCELLANEOUS REVENUE 36210 INTEREST EARNINGS 117,000 58,624 95,000 46,769 45,000 25,629 45,000 35,000 -22.2% (10,000) 36230 CONTRIBUTIONS AND DONATIONS FR - 820 - - - 1,340 - - - 36240 REFUNDS & REIMBURSEMENTS 10,000 11,349 10,000 13,423 - 28,930 - 14,009 10,000 10,000 36260 DRY HYDRANT CHARGES 3,500 3,332 3,500 (125) 3,500 245 3,500 4 3,500 0.0% - 36265 CELLULAR ANTENNA REVENUE - - - - - - - 150,000 150,000 36270 MISCELLANEOUS REVENUE 17,000 8,236 17,000 26,444 15,000 21,217 15,000 9,714 15,000 0.0% - 36275 CONCESSIONS/VENDING 2,500 394 2,500 394 400 394 400 400 0.0% - TOTAL MISCELLANEOUS REVENUE 150,000 82,755 128,000 86,905 63,900 77,755 63,900 23,727 213,900 234.7% 150,000 TRANSFERS 39202 TRANSFERS FROM ENTERPRISE FUNDS 40,000 40,000 18,842 33,465 40,000 40,000 40,000 29,320 - - 100.0% (40,000) 39203 TRANSFERS FROM OTHER FUNDS 160,000 - 180,000 - - - TOTALTRANSFERS 200,000 40,000 198,842 33,465 40,000 40,000 40,000 29,320 - 100.0% (40,000) TOTAL REVENUES 5,488,562 5,115,035 5,375,404 5,158,507 5,121,895 5,232,231 5,136,395 1,922,439 5,263,970 2.5% 127,575 CITY COUNCIL Expenditure Coding: 101 -41110 TRANSFERS 720 OPERATING TRANSFERS 1,379 13,600 47,700 12,221 TOTALTRANSFERS 1,379 13,600 47,700 12,221 TOTAL Council 70,194 66,016 66,016 63,745 120,530 94,920 119,715 27,363 138,950 26.1% 24,795 Approved Dept Budget Actual Budget Actual Budget Actual Budget YTD Request Percent Dollar PERSONAL SERVICES 2009 2009 2010 2010 2011 2011 2012 2012 2013 Change Change 101 FULL -TIME REGULAR 102 FULL -TIME OVERTIME 103 PART -TIME 15,600 15,600 15,600 15,600 15,600 15,600 15,600 7,800 15,600 0.0% 106 OTHER 111 SEVERANCE PAY 121 PERA CONTRIB - CITY SHARE - - - - - - - - 122 FICACONTRIB - CITY SHARE 1,194 1,194 1,194 1,194 1,200 1,194 1,200 597 1,200 0.5% 6 131 EMPLOYEE INSURANCE - CITY SHARE 141 UNEMPLOYMENT COMPENSATION 151 WORKERS COMPENSATION TOTAL PERSONAL SERVICES 16,794 16,794 16,794 16,794 16,800 16,794 16,800 8,397 16,800 0.0% 6 MATERIALS & SUPPLIES 245 GENERAL SUPPLIES 1,400 3,064 3,064 1,175 1,300 684 3,000 165 2,000 338.6% 2,316 TOTAL MATERIALS & SUPPLIES 1,400 3,064 3,064 1,175 1,300 684 3,000 165 2,000 338.6% 2,316 SUPPORT SERVICES /CHARGES 302 CONSULTING FEES - - - - - 1,888 - (1,888) 331 TRAVEL, CONFERENCE & SCHOOLS 7,000 2,968 2,968 2,270 3,500 20,920 4,500 425 4,500 -78.5% (16,420) 351 PRINTING AND PUBLISHING - - - - - - - 400 CONTRACTUAL SERVICES 36,649 3,120 - 100.0% (3,120) 410 RENTALS - - - - 433 DUES AND SUBSCRIPTIONS 45,000 43,190 43,190 43,506 43,169 40,477 47,690 18,376 47,000 17.8% 7,213 440 MISC SERVICES - - - - 19,112 9,658 34,125 20,950 253.3% 24,467 TOTAL SUPPORT SERVICES /CHARGES 52,000 46,158 46,158 45,776 102,430 76,063 86,315 18,801 72,450 13.5% 10,252 TRANSFERS 720 OPERATING TRANSFERS 1,379 13,600 47,700 12,221 TOTALTRANSFERS 1,379 13,600 47,700 12,221 TOTAL Council 70,194 66,016 66,016 63,745 120,530 94,920 119,715 27,363 138,950 26.1% 24,795 ADMINSTRATION Expenditure Coding: 101 -41300 Approved Dept Budget Actual Budget Actual Budget Actual Budget YTD Request Percent Dollar PERSONAL SERVICES 2009 2009 2010 2010 2011 2011 2012 2012 2013 Change Change 101 FULL -TIME REGULAR 259,750 240,187 267 249,664 235,463 249,895 252 148,464 286,860 13.6% 34,387 102 FULL -TIME OVERTIME 400 422 - - - 74 - - - 103 PART -TIME 40 52,523 12,000 69,613 60,235 82,644 - 12 - - 121 PERA /ICMA CONTRIB - CITY SHARE 17,934 19,331 18,788 20,632 21 22,584 18,304 11,337 20,797 13.6% 2 122 FICA CONTRIB - CITY SHARE 21 22 20,534 21 22,621 25,138 19,314 12 21,945 13.6% 2,631 131 EMPLOYEE INSURANCE - CITY SHARE 35,064 28,814 41,313 34 34 46,752 29,384 24 30,069 2.3% 685 141 UNEMPLOYMENT COMPENSATION - 6,365 - 3,976 - 19 - 5,066 - - 151 WORKERS COMPENSATION - - - - - - - - - - TOTAL PERSONAL SERVICES 374,401 369,882 360,040 399,294 373,996 427,106 319,475 213,545 359,671 12.6% 40,196 MATERIALS & SUPPLIES 200 OFFICE SUPPLIES 7,800 4,556 7 3,172 6,000 4,001 7,000 2 5,000 2,999 208 POSTAGE 12 10,815 12 9,854 11 10,786 14 6,385 11 3,459 221 MAINTENANCE OF EQUIPMENT 2 1,585 1 1,665 2,050 1,665 1 1,364 1 35 245 GENERAL SUPPLIES 1,350 2,968 3,575 2,943 1,500 72 1 274 900 1,078 TOTAL MATERIALS & SUPPLIES 23,500 19,924 24,925 17,634 20,800 16,524 24,095 10,172 18,450 - 7,571 SUPPORT SERVICES /CHARGES 321 COMMUNICATIONS -TELEPHONE 500 944 1,000 873 960 1,012 960 527 1 -5.1% (52) 331 TRAVEL, CONFERENCE & SCHOOLS 9,180 5,172 5,350 3,101 5,650 3,669 5,895 1 8,710 60.7% 2 351 PRINTING AND PUBLISHING 3,500 890 4,500 2,683 2,000 3,218 3,200 848 2,000 400 CONTRACTUAL SERVICES 28,450 31,000 27,050 27,582 27,000 32 27,965 10,003 28,365 (4,196) 433 DUES AND SUBSCRIPTIONS 1 1 1 1,642 1,500 1 1,915 416 2,000 10.6% 184 440 MISC SERVICES - - - - - 64 - - - (64) TOTAL SUPPORT SERVICES /CHARGES 42,900 39,441 39,155 35,881 37,110 41,855 39,935 13,568 42,175 -4.6% (1,902) CAPITAL OUTLAY 540 MACHINERY & EQUIPMENT 7,500 6,540 5,600 2,844 - - - 135 - 560 FURNITURE AND FIXTURES - - 600 - - - - - 580 OTHER IMPROVEMENTS - - - - - - - - TOTAL CAPITAL OUTLAY 7,500 6,540 6,200 2,844 - - - 135 - - TOTAL ADMINISTRATION 448,301 435,787 430,320 455,653 431,906 485,485 383,505 237,420 420,296 -21.0% 45,865 FINANCE Expenditure Coding: 101 -41500 MATERIALS & SUPPLIES Approved Dept 200 OFFICE SUPPLIES Budget Actual Budget Actual Budget Actual Budget YTD Request Percent Dollar PERSONAL SERVICES 2009 2009 2010 2010 2011 2011 2012 2012 2013 Change Change 101 FULL -TIME REGULAR 137,679 132,533 137,679 118,664 137,679 128,624 102,399 67,398 106,078 3.6% 3,679 121 PERA CONTRIB - CITY SHARE 8,949 8,924 8,949 7,220 8,949 9,306 7,424 4,867 7,691 3.6% 267 122 FICACONTRIB - CITV SHARE 10,532 10,102 10,532 8,484 10,532 9,175 7,834 4,765 8,115 3.6% 281 131 EMPLOYEE INSURANCE - CITY SHARE 20,477 14,473 20,477 12,874 20,477 16,689 10,759 4,034 11,045 2.7% 286 TOTAL PERSONAL SERVICES 177,637 166,032 177,637 147,242 177,637 163,794 128,416 81,064 132,929 3.5% 4,513 MATERIALS & SUPPLIES 200 OFFICE SUPPLIES 1000 604 1000 109 1000 224 - - - (224) 221 MAINTENANCE OF EQUIPMENT 7,000 6,183 7,000 6,521 7,000 6,842 7,000 7,839 8,100 2.3% 158 245 GENERAL SUPPLIES 200 165 200 946 200 719 300 93 300 -58.3% (419) TOTAL MATERIALS & SUPPLIES 8,200 6,952 8,200 7,576 8,200 7,785 7,300 7,932 8,400 -6.2% (485) SUPPORT SERVICES /CHARGES 301 AUDITING & ACCOUNTING SERVICES - 3,400 3,106 3,400 - - 294 331 TRAVEL, CONFERENCE & SCHOOLS 4,800 2,166 4,800 2,323 4,800 3,887 2,300 734 4,000 -40.8% (1,587) 351 PRINTING AND PUBLISHING 500 720 500 597 500 635 650 - 700 2.4% 15 360 UNALLOCATED INS - LTD - - - - - - 400 CONTRACTUAL SERVICES 1,000 719 1,000 721 1,000 721 1,000 - 1,000 38.7% 279 433 DUES AND SUBSCRIPTIONS 1,000 698 1,000 60 1,000 290 1,000 280 500 244.8% 710 440 MISC SERVICES - - - - - - - 450 BANK SERVICE CHARGES 1,200 496 1,200 121 1,200 5,183 800 - 5,400 -84.6% (4,383) TOTAL SUPPORT SERVICES /CHARGES 8,500 4,799 8,500 7,222 8,500 13,822 9,150 1,014 11,600 -33.8% (4,672) CAPITAL OUTLAY 540 MACHINERY &EQUIPMENT 560 FURNITURE AND FIXTURES 580 OTHER IMPROVEMENTS TOTAL CAPITAL OUTLAY 4,500 2,483 4,500 4,500 4,000 1,678 4,000 4,000 500 805 500 500 TOTAL FINANCE 198,837 180,266 198,837 162,040 198,837 185,401 144,866 90,010 152,929 -21.9% (40,535) PROFESSIONAL SERVICES Expenditure Coding: 101- 41600- TOTAL PROFESSIONAL SERVICES 205,500 223,859 223,859 178,604 223,859 188,963 199,320 130,640 203,390 2.0% Approved Dept Budget Actual Budget Actual Budget Actual Budget YTD Request Percent SUPPORT SERVICES /CHARGES 2009 2009 2010 2010 2011 2011 2012 2012 2013 Change 301 AUDITING & ACCOUNTING SERVICES 25,000 19,835 19,835 20,573 19,835 30,347 24,000 4,000 25,000 4.2% 304 CIVIL LEGAL CONTRACT 77,500 82,567 82,567 36,989 82,567 36,007 44,400 15,319 44,400 0.0% 304 PROSECUTION CONTRACT 30,224 30,224 27,500 30,224 28,350 33,000 13,750 33,990 3.0% 400 CONTRACTUAL ASSESSOR SERVICES 93,000 90,549 90,549 93,492 90,549 94,259 97,920 97,571 100,000 2.1% 440 MISC SERVICES 10,000 684 684 50 684 TOTAL SUPPORT SERVICES /CHARGES 205,500 223,859 223,859 178,604 223,859 188,963 199,320 130,640 203,390 2.0% TOTAL PROFESSIONAL SERVICES 205,500 223,859 223,859 178,604 223,859 188,963 199,320 130,640 203,390 2.0% PLANNING Revenue Coding: 101 - Expenditure Coding: 101 - 41910- Approved Dept Budget Actual Budget Actual Budget Actual Budget YTD Request Percent Dollar REVENUE 2009 2009 2010 2010 2011 2011 2012 2012 2013 Change Change 34103 Zoning and Subdivision Fees 4,500 5,738 4,500 1,824 4,500 4,067 4,500 3,393 4,500 433 TOTAL REVENUE 4,500 5,738 4,500 1,824 4,500 4,067 4,500 3,393 4,500 433 Actual Actual Actual Actual Actual Actual Requested Percent Dollar PERSONAL SERVICES 2009 2009 2009 2010 2009 2011 2012 Increase Increase 101 FULL -TIME REGULAR 87,853 141,729 141,729 138,584 141,729 132,198 133,887 69,527 133,887 0.0% - 102 OVERTIME - - - - - - - - 103 PART -TIME 66,848 15,027 15,027 1,142 15,027 106 OTHER - - - - - 111 SEVERANCE PAY - - - - - 121 PERA CONTRIB - CITY SHARE 10,056 10,376 10,376 9,274 10,376 9,508 9,707 5,005 9,707 0.0% 122 FICA CONTRIB - CITY SHARE 11,835 11,106 11,106 8,971 11,106 9,187 10,242 4,698 10,242 0.0% 131 EMPLOYEE INSURANCE - CITY SHAR 23,009 17,236 17,236 17,582 17,236 17,263 16,830 6,316 16,830 0.0% 141 UNEMPLOYMENT COMPENSATION - - - - - - - 2,723 - 151 WORKERS COMPENSATION - - - - - - - - - - TOTAL PERSONAL SERVICES 199,601 195,474 195,474 175,553 195,474 168,156 170,666 88,269 170,666 1.5 °% 2,510 MATERIALS & SUPPLIES 200 OFFICE SUPPLIES 100 510 510 71 510 249 - - - 1249� 221 MAINTENANCE OF EQUIPMENT 405 405 405 - 405 - 405 400 405 245 GENERAL SUPPLIES 1,250 1,223 1,223 78 1,223 12 250 250 1983.3% 238 TOTAL MATERIALS & SUPPLIES 1,755 2,138 2,138 149 2,138 261 655 650 151.0 °% 394 SUPPORT SERVICES/CHARGES 304 LEGAL FEES - - - - - - - - - 321 COMMUNICATIONS - CELLULARPHON 1,200 1,301 1,301 1,109 1,301 923 800 429 800 -13.3% I123� 331 TRAVEL, CONFERENCE & SCHOOLS 4,600 1,904 1,904 4,177 1,904 3,916 4,012 355 2,000 2.5% 96 351 PRINTING AND PUBLISHING 500 1,298 1,298 732 1,298 1,266 1,000 721 1,000 -21.0% 1266� 400 CONTRACTUAL SERVICES 4,900 3,660 3,660 - 3,660 963 2,500 - 2,500 159.6% 1,537 433 DUES AND SUBSCRIPTIONS 750 827 827 864 827 1,011 1,100 1,004 1,100 8.8% 89 440 MISC SERVICES - - - - - - - - - - TOTAL SUPPORT SERVICES/CHARGES 11,950 8,990 8,990 6,882 8,990 8,079 9,412 2,509 7,400 16.5 °% 1,333 CAPITAL OUTLAY 540 MACHINERY &EQUIPMENT - - - - - - - - - - 560 FURNITURE AND FIXTURES 200 580 OTHER IMPROVEMENTS - TOTAL CAPITAL OUTLAY 200 TOTAL PLANNING 213,306 206,602 206,602 182,584 206,602 176,496 180,733 90,778 178,916 2.4 °% 4,237 Net Levy Impact $ 208,806 $ 200,864 $ 202,102 $ 180,760 $ 202,102 $ 172,429 $ 176,233 $ 87,385 $ 174,416 $ 0 $ 3,804 MUNICIPAL BUILDINGS Expenditure Coding: 101 -41940 TOTAL MUNICIPAL BUILDINGS 376,920 263,477 263,477 284,780 263,477 282,280 276,450 144,827 287,380 -2% (5,830) Approved Dept Budget Actual Budget Actual Budget Actual Budget YTD Request Percent Dollar MATERIALS & SUPPLIES 2009 2009 2010 2010 2011 2011 2012 2012 2013 Change Change 221 MAINTENANCE OF EQUIPMENT 21,300 32,020 32,020 48,384 32,020 45,472 14,000 11,545 11,400 - 69.2% (31,472) 223 MAINTENANCE OF BUILDINGS 5,000 119 119 883 119 2,899 - 589 7,800 (2,899) 245 GENERAL SUPPLIES - 2,182 2,182 1,977 2,182 1,631 2,500 1,246 2,930 53.3% 869 TOTAL MATERIALS & SUPPLIES 26,300 34,321 34,321 51,244 34,321 50,002 16,500 13,380 22,130 -67.0% (33,502) SUPPORT SERVICES /CHARGES 302 CONSULTING FEES - - - - - - - 805 - - 321 COMMUNICATIONS - Warner Conn. 7,000 6,523 6,523 2,771 6,523 3,287 34,000 15,404 34,000 934.4% 30,713 331 TRAVEL, CONFERENCE & SCHOOLS - - - 542 - - - - - 360INSURANCE 110,000 98,796 98,796 33,942 98,796 103,252 105,000 106,143 110,000 1.7% 1,748 380 UTILITY SERVICES 10,000 10,671 10,671 7,700 10,671 8,168 11,000 2,961 11,000 34.7% 2,832 400 CONTRACTUAL SERVICES 11,000 6,640 6,640 8,173 6,640 11,083 7,500 4,778 9,800 - 32.3% 13,5Q 410 RENTALS 1,500 1,328 1,328 1,368 1,328 1,004 250 1,004 - - 75.1% (754) 437 TAXES /LICENSES - - - - - 440 MISC SERVICES - - - - - - - TOTAL SUPPORT SERVICES/CHARGES 139,500 123,958 123,958 54,496 123,958 126,794 157,750 131,095 164,800 24.4% 30,956 CAPITAL OUTLAY 520 BUILDINGS &STRUCTURES - - - - - 250 - - (250) 540 MACHINERY &EQUIPMENT 1,000 15,713 1,284 352 (1,284) 560 FURNITURE AND FIXTURES - - - 580 OTHER IMPROVEMENTS - - - TOTAL CAPITAL OUTLAY 1,000 15,713 1,534 352 (1,534) EDA DEBT SERVICE 601 BOND PRINCIPAL 25,000 - - #DIV /0! 611 BOND INTEREST 75,120 5,425 5,425 2,959 5,425 #DIV /0! TOTAL EDA DEBT SERVICES 100,120 5,425 5,425 2,959 5,425 #DIV /01 TRANSFERS 720 OPERATING TRANSFERS 110,000 99,773 99,773 160,368 99,773 103,950 102,200 100,450 (1,750) TOTALTRANSFERS 110,000 99,773 99,773 160,368 99,773 103,950 102,200 100,450 (1,750) TOTAL MUNICIPAL BUILDINGS 376,920 263,477 263,477 284,780 263,477 282,280 276,450 144,827 287,380 -2% (5,830) POLICE Expenditure Coding: 101-42100 - Approved Dept Budget Actual Budget Actual Budget Actual Budget YTD Request Percent MATERIALS & SUPPLIES 2009 2009 2010 2010 2011 2011 2012 2012 2013 Change 245 GENERAL SUPPLIES 1,367 TOTAL MATERIALS & SUPPLIES 1,367 SUPPORT SERVICES /CHARGES 380 UTILITY SERVICES 50 26 26 41 26 45 11 50 - 100.0% 400 CONTRACTUAL SERVICES 938,950 941,396 941,396 947,298 941,396 994,787 987,085 494,243 1,013,027 -0.8% 440 MISC SERVICES 4,000 2,567 2,567 1,998 2,567 1,939 2,000 204 2,000 3.1% TOTAL SUPPORT SERVICES /CHARGES 943,000 943,989 943,989 949,337 943,989 996,771 989,085 494,458 1,015,077 -0.8% CAPITAL OUTLAY 520 BUILDINGS & STRUCTURES 233,000 232,940 232,940 228,068 232,940 230,068 225,132 112,566 235,437 -2.1% TOTAL CAPITAL OUTLAY 233,000 232,940 232,940 228,068 232,940 230,068 225,132 112,566 235,437 -2.1% TOTAL POLICE PROTECTION 1,176,000 1,176,929 1,176,929 1,178,772 1,176,929 1,226,839 1,214,217 607,024 1,250,514 -1.0% CAPITAL OUTLAY 520 BUILDINGS & STRUCTURES 284,500 277,270 277,270 272,629 277,270 270,697 277,906 138,953 287,643 2.7% TOTAL CAPITAL OUTLAY 284,500 277,270 277,270 272,629 277,270 270,697 277,906 138,953 287,643 2.7% TOTAL FIRE PROTECTION 600,638 600,450 600,450 595,164 600,450 607,828 610,711 304,946 637,225 0.5% Approved Dept Budget Actual Budget Actual Budget Actual Budget YTD Request Percent SUPPORT SERVICES /CHARGES 2009 2009 2010 2010 2011 2011 2012 2012 2013 Change 400 Excelsior Fire 316,138 298,175 298,175 298,113 298,175 312,549 307,705 159,852 324,999 -1.5% 400 Mound Fire Contract 25,005 25,005 24,422 25,005 24,582 25,100 6,141 24,583 2.1% TOTAL SUPPORT SERVICES /CHARGES 316,138 323,180 323,180 322,535 323,180 337,131 332,805 165,993 349,582 -1.3% CAPITAL OUTLAY 520 BUILDINGS & STRUCTURES 284,500 277,270 277,270 272,629 277,270 270,697 277,906 138,953 287,643 2.7% TOTAL CAPITAL OUTLAY 284,500 277,270 277,270 272,629 277,270 270,697 277,906 138,953 287,643 2.7% TOTAL FIRE PROTECTION 600,638 600,450 600,450 595,164 600,450 607,828 610,711 304,946 637,225 0.5% PROTECTIVE INSPECTIONS 180,000 109,987 90,000 Expenditure Coding: 101 - 42400- 81,000 Approved Dept 66,895 Budget Actual Budget Actual Budget Actual Budget YTD Request Percent Dollar REVENUE 2009 2009 2010 2010 2011 2011 2012 2012 2013 Change Change 32210 Building Permits 180,000 97,651 90,000 118,189 70,000 123,141 80,000 51,901 80000 - 35.0% (43,141) 32215 Plan Check Fees - 12,336 - 23,679 11,000 24,225 12,000 14,994 12000 - 50.5% (12,225) Miscellaneous Revenue 2009 2009 100 TOTAL REVENUE 180,000 109,987 90,000 141,868 81,000 147,366 92,000 66,895 92,100 -37.6% (55,366) Actual Actual Actual Actual Actual Adopted Requested Percent Dollar PERSONAL SERVICES 2009 2009 2009 2009 2009 2011 2012 Increase Change 101 FULL -TIME REGULAR 83,103 88,521 88,521 90,428 88,521 96,525 90,403 46,410 92,613 2.4% 2,210 102 PART -TIME 13,370 7,275 7,275 1,285 7,275 - 1,500 1,500 0.0% - 121 PERA CONTRIB - CITY SHARE 6,271 6,267 6,267 6,092 6,267 6,844 6,554 3,240 6,714 2.4% 160 122 FICA CONTRIB - CITY SHARE 7,380 6,646 6,646 5,895 6,646 6,460 6,916 3,072 7,085 2.4% 169 131 EMPLOYEE INSURANCE - CITY SHARE 12,360 10,475 10,475 11,381 10,475 12,342 12,676 4,795 12,676 0.0% - TOTAL PERSONAL SERVICES 122,484 119,184 119,184 115,081 119,184 122,171 118,049 57,517 120,588 -3,4% (4,122) MATERIALS & SUPPLIES 200 OFFICE SUPPLIES - - - 6 - 154 - - (154) 245 GENERAL SUPPLIES 750 139 139 22 139 - 200 200 200 TOTAL MATERIALS & SUPPLIES 750 139 139 28 139 154 200 200 29.9% 46 SUPPORT SERVICES /CHARGES 321 COMMUNICATIONS - CELLULAR PHONE 450 470 470 244 470 - - - - 331 TRAVEL, CONFERENCE & SCHOOLS 3,400 2,799 2,799 2,785 2,799 2,900 2,500 2,500 - 13.8% (400) 351 PRINTING AND PUBLISHING 300 668 668 116 668 135 36 150 400 CONTRACTUAL SERVICES 6,400 1,610 1,610 1,330 1,610 1,278 2,500 595 2,500 95.6% 1,222 433 DUES AND SUBSCRIPTIONS 150 100 100 100 100 125 150 150 20.0% 25 TOTAL SUPPORT SERVICES /CHARGES 10,700 5,647 5,647 4,575 5,647 4,438 5,150 631 5,300 16.0% 712 CAPITAL OUTLAY 540 MACHINERY &EQUIPMENT - 1,298 1,298 - 1,298 - - - - 560 FURNITURE AND FIXTURES - - - TOTAL CAPITAL OUTLAY 1,298 1,298 1,298 TOTAL PROTECTIVE INSPECTIONS 133,934 126,268 126,268 119,684 126,268 126,763 123,399 58,148 126,088 -2.7% (3,364) Net Levy Support (46,066) 16,281 36,268 (22,184) 45,268 (20,603) 31,399 (8,747) 33,988 CITY ENGINEER Expenditure Coding: 101 -43010 TOTAL CITY ENGINEER 161,057 118,622 118,622 104,124 118,622 111,321 103,032 46,282 103,969 -7.4% (8,289) Approved Dept Budget Actual Budget Actual Budget Actual Budget YTD Request Percent Dollar PERSONAL SERVICES 2009 2009 2010 2010 2011 2011 2012 2012 2013 Change Change 101 FULL -TIME REGULAR 102,767 86,821 86,821 74,859 86,821 75,297 72,196 31,524 73,640 2.0% 1,444 121 PERA CONTRIB - CITY SHARE 6,680 4,826 4,826 4,993 4,826 5,424 5,234 2,267 5,339 2.0% 105 122 FICA CONTRIB - CITY SHARE 7,862 6,581 6,581 5,437 6,581 5,704 5,523 2,387 5,633 2.0% 110 131 EMPLOYEE INSURANCE - CITV SHARE 15,285 9,160 9,160 9,208 9,160 9,794 7,919 2,982 7,937 0.2% 18 TOTAL PERSONAL SERVICES 132,594 107,388 107,388 94,497 107,388 96,219 90,872 39,160 92,549 1.8% 1,677 MATERIALS & SUPPLIES 200 OFFICE SUPPLIES 370 395 395 119 395 409 150 104 150 -63.3% (259) 221 MAINTENANCE OF EQUIPMENT - - - - - - - - - 245 GENERAL SUPPLIES 530 346 346 33 346 86 50 50 -41.9% (36) TOTAL MATERIALS & SUPPLIES 900 741 741 152 741 495 200 104 200 -59.6% (295) SUPPORT SERVICES /CHARGES 303 ENGINEERING FEES 5,000 1,825 1,825 4,620 1,825 5,236 5,000 3,875 5,000 -4.5% (236) 321 COMMUNICATIONS - CELLULAR PHONE 600 547 547 411 547 250 60 60 -76.0% (190) 331 TRAVEL, CONFERENCE & SCHOOLS 6,650 3,375 3,375 1,400 3,375 5,634 2,500 1,249 2,500 -55.6% (3,134) 351 PRINTING AND PUBLISHING 2,173 792 792 177 792 40 300 212 300 650.0% 260 400 CONTRACTUAL SERVICES 500 - - - - - - - #DIV /0! - 410 RENTAL 2,000 267 267 - 267 248 600 - 141.9% 352 433 DUES AND SUBSCRIPTIONS 830 833 833 2,197 833 1,400 3,200 1,546 3,060 128.6% 1,800 437 TAXES /LICENSES 900 - - 132 - 742 300 136 300 -59.6% (442) TOTAL SUPPORT SERVICES /CHARGES 18,653 7,639 7,639 8,937 7,639 13,550 11,960 7,018 11,220 -11.7% (1,590) CAPITAL OUTLAY 540 MACHINERY &EQUIPMENT 8,700 2,854 2,854 538 2,854 1,057 - - - 100.0% (1,057) 560 FURNITURE AND FIXTURES 210 - - - - - 580 OTHER IMPROVEMENTS - - - - - - TOTAL CAPITAL OUTLAY 8,910 2,854 2,854 538 2,854 1,057 - 100.0% (1,057) TOTAL CITY ENGINEER 161,057 118,622 118,622 104,124 118,622 111,321 103,032 46,282 103,969 -7.4% (8,289) PUBLIC WORKS Expenditure Coding: 101- 43050- MATERIALS & SUPPLIES 3,634 Approved Dept 1,300 - 200 OFFICE SUPPLIES Budget Actual Budget Actual Budget Actual Budget YTD Request Percent Dollar PERSONAL SERVICES 2009 2009 2010 2010 2011 2011 2012 2012 2013 Increase Change 101 FULL -TIME REGULAR 306,448 283,371 313,546 318,540 242,559 303,535 325,676 143,379 334,078 2.6% 8,402 102 OVERTIME 5,500 1,850 5,772 1,053 3,200 1,132 2,500 934 2,500 0.0% - 103 PART -TIME - 460 - 1,302 - 640 - 650 - 106.4% - 121 PERACONTRIB - CITY SHARE 20,277 19,191 22,352 21,753 17,722 22,090 23,611 10,383 24,402 3.3% 791 122 FICA CONTRIB - CITY SHARE 23,864 21,194 24,427 23,636 18,701 22,545 24,914 10,596 25,748 3.3% 834 131 EMPLOYEE INSURANCE - CITY SHARE 45,579 33,658 47,988 38,817 31,685 39,976 41,932 15,787 42,047 0.3% 115 TOTAL PERSONAL SERVICES 401,668 359,724 414,085 405,101 313,867 389,918 418,633 181,079 428,775 2.4% 10,142 MATERIALS & SUPPLIES 3,634 1,300 - 200 OFFICE SUPPLIES - 16 - 126 200 229 200 161 200 - 12.7% (29) 212 MOTOR FUELS & LUBRICATION 51,750 27,668 43,123 37,660 43,000 49,822 51,000 22,679 51,000 2.4% 1,178 221 MAINTENANCE OF EQUIPMENT 16,200 19,448 16,300 15,131 16,150 17,555 16,000 36,695 16,500 -8.9% (1,555) 223 MAINTENANCE OF BUILDINGS 2,050 865 2,000 1,502 2,000 1,324 4,000 1,881 2,500 202.1% 2,676 240 SMALLTOOLS AND MINOR EQUIPMENT 2,200 908 2,000 802 1,775 860 1,775 650 1,500 106.4% 915 245 GENERALSUPPLIES 88,700 66,933 101,200 89,710 99,600 89,257 99,600 41,008 99,600 11.6% 10,343 TOTAL MATERIALS & SUPPLIES 160,900 115,838 164,623 144,931 162,725 159,047 172,575 103,074 171,300 8.5% 13,528 SUPPORT SERVICES /CHARGES 303 ENGINEERING 305 DRUG TESTING 321 COMMUNICATIONS - TELEPHONE 331 TRAVEL, CONFERENCE & SCHOOLS 351 PRINTING AND PUBLISHING 380 UTILITY SERVICES 399 UTILITIES - STREETLIGHTS 400 CONTRACTUAL SERVICES 410 RENTALS 433 DUES AND SUBSCRIPTIONS 437 TAXES /LICENSES 440 MISC SERVICES TOTAL SUPPORT SERVICES /CHARGES CAPITAL OUTLAY 520 BUILDINGS &STRUCTURES 540 MACHINERY &EQUIPMENT 560 FURNITURE AND FIXTURES 580 OTHER IMPROVEMENTS TOTAL CAPITAL OUTLAY 2,750 5,003 3,800 900 750 - - 300 3,500 5,003 3,800 1,200 TRANSFERS 720 OPERATING TRANSFERS- EQUIPMENT 875,000 875,000 800,000 800,000 750,000 750,000 750,000 772,500 0.0% TOTALTRANSFERS 875,000 875,000 800,000 800,000 750,000 750,000 750,000 772,500 0.0% TOTAL PUBLIC WORKS 1,569,508 1,475,130 1,510,457 1,467,976 1,371,831 1,438,724 1,475,647 332,298 1,512,325 2.6% 36,923 3,634 1,300 - 1,300 - 1,300 - 1,300 - 1,800 #DIV /0! 1,300 3,200 1,527 3,200 1,950 3,200 2,169 3,200 1,422 3,200 47.5% 1,031 3,450 2,800 3,950 3,060 7,450 2,775 7,450 2,870 7,500 168.5% 4,675 - 2,896 - - - - - - - 18,400 10,285 15,000 10,325 14,300 11,124 14,300 4,481 14,550 28.6% 3,176 - 40,849 41,049 38,882 41,049 42,163 41,049 17,654 41,500 54,840 58,776 56,690 57,045 70,990 67,956 60,190 18,131 63,000 - 11.4% (7,766) 1,200 283 1,200 331 1,000 - 1,000 598 1,000 #DIV /0! 1,000 2,200 1,518 1,500 1,584 1,500 1,500 1,500 1,609 1,500 0.0% - 850 317 850 846 850 514 850 875 900 65.4% 336 43,000 314 3,210 3,921 3,600 7,924 3,600 505 3,600 - 54.6% (4,324) 128,440 119,565 127,949 117,944 145,239 139,759 134,439 48,145 138,550 -3.8% (5,320) 2,750 5,003 3,800 900 750 - - 300 3,500 5,003 3,800 1,200 TRANSFERS 720 OPERATING TRANSFERS- EQUIPMENT 875,000 875,000 800,000 800,000 750,000 750,000 750,000 772,500 0.0% TOTALTRANSFERS 875,000 875,000 800,000 800,000 750,000 750,000 750,000 772,500 0.0% TOTAL PUBLIC WORKS 1,569,508 1,475,130 1,510,457 1,467,976 1,371,831 1,438,724 1,475,647 332,298 1,512,325 2.6% 36,923 ICE AND SNOW REMOVAL Expenditure Coding: 101- 43125- Approved Dept Budget Actual Budget Actual Budget Actual Budget YTD Request Percent Dollar PERSONAL SERVICES 2009 2009 2010 2010 2011 2011 2012 2012 2013 Increase Change 101 FULL -TIME REGULAR 26,736 23,995 23,995 27,444 38,238 17,416 36,052 9,540 37,455 3.9% 1,403 102 OVERTIME 5,000 5,226 5,226 18,317 7,500 11,091 7,500 1,864 7,500 0.0% - 103 PART -TIME - - - - - - - - 106 OTHER 111 SEVERANCE PAY - - - - - - - - - 121 PERA CONTRIB - CITY SHARE 2,063 1,981 1,981 2,645 2,772 2,598 3,064 827 3,259 195 122 FICA CONTRIB - CITY SHARE 2,428 2,178 2,178 2,759 2,925 2,629 3,332 818 3,439 3.2% 107 131 EMPLOYEE INSURANCE - CITY SHARE 4,945 2,615 2,615 3,887 5,132 4,225 5,076 1,930 5,009 -1.3% (67) 141 UNEMPLOYMENT COMPENSATION - - - - - - - - - 151 WORKERS COMPENSATION - - - - - - - - - TOTAL PERSONAL SERVICES 41,172 35,995 35,995 55,052 56,567 37,959 55,024 14,979 56,662 3.0% 1,638 MATERIALS & SUPPLIES 245 GENERAL SUPPLIES 45,340 38,457 38,457 32,451 45,117 29,462 45,117 10,247 45,000 53.1% 15,655 TOTAL MATERIALS & SUPPLIES 45,340 38,457 38,457 32,451 45,117 29,462 45,117 10,247 45,000 53.1% 15,655 SUPPORT SERVICES /CHARGES 331 TRAVEL, CONFERENCE & SCHOOLS - - - - - - - - - TOTAL SUPPORT SERVICES /CHARGES CAPITAL OUTLAY 540 MACHINERY &EQUIPMENT TOTAL CAPITAL OUTLAY TOTAL ICE & SNOW CONTROL 86,512 74,452 74,452 87,503 101,684 67,421 100,141 25,226 101,662 48.5% 32,720 PARKS MAINTENANCE Expenditure Coding: 101 - 45200- 14,013 14,013 14,013 - - - Approved Dept 321 COMMUNICATIONS - TELEPHONE Budget Actual Budget Actual Budget Actual Budget YTD Request Percent Dollar PERSONAL SERVICES 2009 2009 2010 2010 2011 2011 2012 2012 2013 Increase Change 101 FULL -TIME REGULAR 95,949 95,949 95,949 102,710 124,702 102,797 67,732 42,403 69,784 - 34.1% (35,065) 102 OVERTIME 2,222 2,222 2,222 1,870 2,500 1,462 2,500 3,439 2,500 71.0% 1,038 103 PART -TIME 22,100 22,100 22,100 21,314 22,000 17,441 12,000 1,281 12,000 - 31.2% (5,441) 121 PERA CONTRIB - CITY SHARE 6,773 6,773 6,773 7,437 9,041 7,848 5,092 3,075 5,241 - 35.1% (2,756) 122 FICA CONTRIB - CITY SHARE 8,575 8,575 8,575 8,719 9,540 8,718 6,291 3,075 6,448 - 27.8% (2,427) 131 EMPLOYEE INSURANCE - CITY SHARE 11,913 11,913 11,913 11,587 17,925 13,852 7,373 2,749 7,386 - 46.8% (6,479) TOTAL PERSONAL SERVICES 147,532 147,532 147,532 153,637 185,708 152,118 100,988 52,583 103,358 -33.6% (51,130) MATERIALS & SUPPLIES 208 POSTAGE - - - - - 255 255 - 221 MAINTENANCE OF EQUIPMENT 841 841 841 2,896 5,000 2,858 5,000 - 4,000 74.9% 2,142 223 MAINTENANCE OF BUILDINGS 284 284 284 920 4,000 1,088 4,000 257 5,000 267.6% 2,912 240 SMALL TOOLS AND MINOR EQUIPMENT 63 63 63 604 800 344 800 800 132.6% 456 245 GENERALSUPPLIES 8,906 8,906 8,906 9,817 10,000 12,849 8,500 11,795 9,500 - 33.8% (4,349) TOTAL MATERIALS & SUPPLIES 10,094 10,094 10,094 14,237 19,800 17,394 18,300 12,307 19,300 5.2% 906 SUPPORT SERVICES /CHARGES 303 ENGINEERING FEES 14,013 14,013 14,013 - - - 2,000 321 COMMUNICATIONS - TELEPHONE 1,695 1,695 1,695 1,747 1,900 1,770 - 1,800 - 100.0% (1,770) 331 TRAVEL, CONFERENCE & SCHOOLS - - - - - 23 1,000 1,000 977 351 PRINTING AND PUBLISHING - - - 105 1,000 160 - 38 160 - 100.0% (160) 380 UTILITY SERVICES 8,179 8,179 8,179 7,613 9,000 7,761 9,000 3,439 9,000 16.0% 1,239 400 CONTRACTUAL SERVICES 73,949 73,949 73,949 76,352 70,000 67,702 7,000 4,555 7,200 - 89.7% (60,702) 410 RENTALS 11,709 11,709 11,709 10,240 9,500 9,501 9,500 5,620 9,750 0.0% M 440 MISC SERVICES 236 236 236 - 500 173 - - - 100.0% (173) TOTAL SUPPORT SERVICES /CHARGES 109,781 109,781 109,781 96,057 91,900 87,090 26,500 13,652 30,910 -69.6% (60,590) TRAfISFERS OPERATING R TOTALTRANSFERS TOTAL PARKS MAINTENANCE 267,407 267,407 267,407 263,931 297,408 256,602 145,788 78,542 153,568 -43.2% (110,814) RECREATION Revenue Coding: 101 Expenditure Coding: 101 - 45300- Approved Dept Budget Actual Budget Actual Budget Actual Budget YTD Request Percent Dollar REVENUE 2009 2009 2010 2010 2011 2011 2012 2012 2013 Increase Change 34780 Recreation & Class Fees 31,000 27,395 31,000 34,396 29,425 33,243 29,425 21,142 29,500 - 11.5% (3,818) Actual Actual Actual Adopted Requested Percent Dollar PERSONAL SERVICES 2009 2010 2011 2012 2013 Increase Change 101 FULL -TIME REGULAR 49,235 15,456 21,882 - 55.6% (27,353) 102 OVERTIME - - 103 PART -TIME 10,000 1,497 10,000 0.0% 106 OTHER - - 111 SEVERANCE PAY - - 121 PERACONTRIB - CITY SHARE 3,570 1,229 1,586 - 55.6% (1,984) 122 FICA CONTRIB - CITY SHARE 4,531 1,238 2,439 - 46.2% (2,093) 131 EMPLOYEE INSURANCE - CITY SHARE 1,020 409 453 - 55.6% (567) TOTAL PERSONAL SERVICES 68,356 19,829 36,360 -46.8% (31,997) MATERIALS & SUPPLIES 245 GENERAL SUPPLIES 1,500 1,000 1,500 1,500 TOTAL MATERIALS & SUPPLIES 1,500 1,000 1,500 1,500 SUPPORT SERVICES /CHARGES 302 CONSULTING FEES - - 303 ENGINEERING FEES 304 LEGAL FEES - - 321 COMMUNICATIONS - TELEPHONE 1,900 728 2,100 1,900 331 TRAVEL, CONFERENCE & SCHOOLS 1,500 179 1,500 1,500 351 PRINTING AND PUBLISHING 1,000 904 1,500 1,000 400 CONTRACTUAL SERVICES 29,500 9,823 14,795 29,500 433 DUES AND SUBSCRIPTIONS 250 250 250 TOTAL SUPPORT SERVICES /CHARGES 34,150 11,634 20,145 34,150 TRANSFERS 720 OPERATING TRANSFERS 45,000 45,000 42,000 42,000 42,000 42,000 42,000 - 42,000 0.0% - TOTALTRANSFERS 45,000 45,000 42,000 42,000 42,000 42,000 42,000 42,000 0.0% TOTAL PARKS AND RECREATION 45,000 45,000 42,000 42,000 42,000 42,000 146,006 32,463 100,005 247.6% 104,006 Net Levy Support 14,000 17,605 11,000 7,604 12,575 8,757 116,581 11,321 70,505 1231.3% 107,824 Fund Balance Available Calculation City Method 12/31/11 GF Reserve Proposed 2013 Exp Fund Balance 3,460,021 5,367,218 64o5% 12/31/11 GF Reserve 3,460,021 60% Reserve (3,220,331) 5.1% of the reserve 239,690 3% maximum use of reserves 161,017 Use of reserves in budget (103,248) Additional available reserves 57,p769 CISA Method 2012 Expenditures 5,291,047 Less transfers (895,950) Net General Fund Exp 4,395,097 Special Revenue Exp 110,985 Total Gen &Spec Exp 4,506,082 Fund Balance % 76.8%