Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
City Council Packet 07-26-2011 Special
CITY OF PLYMOUTH AGENDA SPECIAL COUNCIL MEETING July 26, 2011, 5:00 p.m. MEDICINE LAKE CONFERENCE ROOM 1. CALL TO ORDER 2. TOPICS A. Discuss 2012/2013 Budget B. Set Future Study Sessions 3. ADJOURN Special Council Meeting 1 of 1 July 26, 2011 rp)City of Plymouth Agenda 2ANumber: Adding Quality to Life To: Laurie Ahrens, City Manager SPECIAL COUNCIL MEETING Prepared by: Cal Portner, Administrative Services Director July 26, 2011 Reviewed by: Item: Preliminary 2012-2013 Budget Review 1. ACTION REQUESTED: Review preliminary 2012-2013 budget and provide staff direction. 2. BACKGROUND: This is the second of four scheduled budget meetings for the 2012-2013 Biennial Budget. This will be the City of Plymouth's third biennial budget. The City Council met with staff on June 14, 2011, to review budget trends. Recognizing the continuing poor economy, the Council expressed a desire to adopt a conservative 2012-2013 budget. The purpose of this meeting is to review the preliminary budget and provide staff further direction. The budget information attached includes a balanced 2012 budget using the best information we have at this time, however the information will be subject to change due to legislative action, unaccounted for economic variables and improved property value information. The 2013 budget is dependant upon completion of 2012 and also requires further Council direction; therefore is not included in the information presented. Background, looking back at the last biennium Despite a very weak economy, falling property values and state budget crisis, the City of Plymouth budgets included flat or decreased levy amounts from the previous year. The city was able to accomplish this primarily due to the following factors: 1) Decreased service levels 2) Cuts in staffing (30 positions) 3) Expiring bond payments 4) Efficiencies resulting from new technology investments 5) Increased revenue (park field maintenance, PCC program fees) 6) Salary freezes The city further added a new levy for a voter -approved open space bond sale without increasing the total tax levy in 2011. The 2010-2011 biennial budget also contained a number of budget adjustments to internal service funds that were intended to improve their sustainability. Following analysis of Fleet, Facilities, Utility, Utility Trunk and Park Replacement Funds, adjustments were made to ensure the funds were in place for future maintenance and improvements. Looking forward, the next biennium The next biennium poses a number of challenges. Economic indicators show inflation, the June CPI was at the annual rate of 3.6%. The poor economy has hampered new revenue growth. During the next two years, we do not project the retirement of existing debt service. The city currently has approximately $3 million remaining in levy authority for open space acquisition from the 2006 voter -approved referendum. The legislature did not extend levy limits into 2012 and the Market Value Homestead Credit program was changed to decrease the taxable valuation for homeowners, eliminating the requirement for cities to reduce their levy and await uncertain state reimbursement. Beyond the next biennium 2012 is an election year, and resulting state and federal politics have an unknown impact on cities. In 2014, the city will have completed payment on four debt obligations, eliminating approximately $600,000 in levy. 2012 Budget Staff has included preliminary budget input for the next biennium. Overall, revenues and expenditures are projected to increase by roughly 2% over 2011 for 2012. Revenue Changes Non property tax levy revenue is projected to be stable. Potential increases in new building permit revenues are offset by decreases in fine revenue, intergovernmental transfers and continued low investment interest income. The 2011 levy for general government operations was $22,311,035. In order to maintain the same service levels in 2012, the levy is proposed to increase by 1% to account for scheduled increases in debt payments, wage and benefits increases, and expenditure inflationary adjustments. The budget also includes proposed levy increases for the Street Reconstruction Fund Levy, Capital Improvement Fund Levy, and Park Maintenance Fund Levy. The preliminary budget includes the following revenue adjustments from the last biennial budget in 2010: Increase of MSA aid by $300,000 for street maintenance to reflect the state allowance for maintenance. Increase of $500,000 for Market Value Homestead Credit (available funds within levy) Decrease of $118,000 in engineering allocation charges from 2010. Transfer of $51,000 from Resource Planning -Elections to pay for anticipated election costs. Increase of 12,000 in new license revenue. Increase of $165,000 in additional building permit revenue. Decrease in Police court revenue. Increase in antenna revenue by $28,000. Decrease of approximately $8,000 for the elimination of the resale program for weather radios. Increase in revenue for police contractual services for a flat rate billing methodology. Increase in the general tax levy by I%. Expenditure Changes As discussed at the June Council Budget session, allocation adjustments for internal services account for a majority of the increase. The Fleet Fund includes additions of a new fire apparatus as well as a shift to account for actual costs. The Fleet Fund adjustment has an impact on the General Fund of nearly 300,000. The Risk Management allocations were studied in 2011 and a methodology was created to account for actual losses. The Risk Management Fund realizes a $425,418 increase to fully account for actual premium costs, property losses and workers' compensation claims. Salary distributions were revisited and adjustments were made, including moving 80,000 in salary from the investment activities. Established a Park Replacement Fund levy to replace the transfer of funding from Park Maintenance to the Park Replacement fund to cover capital projects. Added funding for maintenance of retaining walls and fences. Eliminated parking lot seal coating in 2012 (maintained for 2013). Will seek strategies to recover the full amount budgeted in 2011 for playfield maintenance fees. The following seven positions were eliminated or reduced in this preliminary budget: Finance Office Support Representative Supervising Accountant (reduced) Administration Office Support Representative Park Superintendent Senior Engineering Tech Police Office Support Supervisor Police SRO (reduced) The Council approved labor contracts that include salary increases for two of the four unions increasing salary expenditures by approximately 1.5% or $210,000. We have included $150,000 in salary vacancies to account for staff turnover. Benefit increases include an estimate for health insurance. The city will receive renewal information in August with the actual rates. The approved labor contracts contain the same language with regard to sharing increases as in the past. Social service organizations have requested to increase appropriations from last year. The Plymouth Civic League requested an additional $20,000 for Music in Plymouth. Staff requests direction from council whether to include these requests in the budget. Other organizations such as LMC, SRA, Twin West Chambers, MLC and Metro Cities have maintained their current rates or have slight increases budgeted. Recommendation Staff has produced a balanced budget for 2012 and is seeking direction from Council. Upon direction, further adjustments will be made and will set the foundation for completing the 2013 budget. 3. ATTACHMENTS: Budget Worksheets (including General Fund summary) Tax Levy Worksheet IT Methodology & Allocation Risk Management Methodology & Allocation Central Services Allocation Central Equipment Allocation Allocation Trend Review CIP City and HRA Levies 7/21/2011 2:18 PM CITY and HRA TAX LEVIES Increase/ Increase/ Increase/ Levy Type 2009 2010 Decrease 2011 Decrease 2012 Decrease Levy Limit Base General Fund Base 12,856,138 13,050,115 12,560,323 22,989,710 Market Value Homestead Credit 510,000 589,795 552,502 0 Street Reconstruction 2,458,092 2,531,835 2,607,790 2,686,024 Recreation Fund 678,497 618,497 618,497 559,480 Park Replacement 130,000 Capital Improvement Fund 358,216 368,962 380,031 391,432 Total Levy Limit Base 16,860,943 17,159,204 1.77% 16,719,143 2.56% 26,756,646 60.04% Special Levies PERA 101,012 108,728 157,588 0 Public Safety 9,231,614 9,183,835 9,593,124 0 GO 2003B Street Recon Bonds 178,355 179,038 179,563 179,524 GO 2003C Street Recon Bonds 424,531 2003D Open Space Refunding 267,257 281,326 GO 2004A Public Safety 596,354 596,958 601,683 598,953 GO 2007A Open Space 255,486 255,223 254,764 254,108 2009B Activity Center Bonds 432,016 410,989 407,558 412,125 GO 2010A Open Space 263,259 264,036 Total Special Levies 11,486,625 11,016,097 4.10% 11,457,539 4.01% 1,708,746 85.09% TOTAL CITY LEVY 28,347,568 28,175,301 0.61% 28,176,682 0.00% 28,465,392 1.02% HRA Levy 551,277 551,277 551,277 551,277 TOTAL LEVY 28,898,845 28,726,578 0.60% 28,727,959 0.00% 29,016,669 1.00% 7/21/2011 2:18 PM TOTAL BUDGETED REVENUES 100-710 PW Street Maintenance 906,000 1,268,677 362,677 40.03% 100-711 PW Engineering 381,200 304,200 (77,000) -20.20% Total Revenues $ 29,591,112 $ 30,234,646 $ 643,534 2.17% 2012/2013 Bienniel Budget, City of Plymouth, MN 1 of 2 7/21/2011 2011 2012 Change Chane 100-110 City Manager 22,915,868 $ 23,381,850 465,982 2.03% 100-111 Mayor Et Council 100-210 Communication 200,000 18,635 181,365) 90.68% 100-211 City Clerk 249,865 313,750 63,885 25.57% 100-212 Human Resources 46,993 46,993 0.00% 100-213 Finance 3,600 3,600 100-214 Assessing 100-310 CD Admin 2,500 2,500 100-311 CD Planning 29,000 29,000 0.00% 100-312 CD Inspections 1,957,000 2,270,000 313,000 15.99% 100-410 PR Admin 100-411 PR Park Maintenance 155,000 100,000 55,000) 35.48% 100-412 PR Forestry 26,045 19,480 6,565) 25.21% 100-413 PR Plymouth Creek 183,600 183,880 280 0.15% 100-510 PD Admin 2,080,326 1,752,056 328,270) 15.78% 100-511 PD Patrol 8,700 108,200 99,500 1143.68% 100-512 PD Support 525 525 0.00% 100-513 PD Emergency Mgmt 5,000 5,000 100-610 Fire Operations 381,500 347,600 33,900) 8.89% 100-611 Fire RAD 69,490 78,700 9,210 13.25% 100-612 Fire Duty Crew 100-710 PW Street Maintenance 906,000 1,268,677 362,677 40.03% 100-711 PW Engineering 381,200 304,200 (77,000) -20.20% Total Revenues $ 29,591,112 $ 30,234,646 $ 643,534 2.17% 2012/2013 Bienniel Budget, City of Plymouth, MN 1 of 2 7/21/2011 TOTAL BUDGETED EXPENDITURES 2011 2012 Change Change 100-110 City Manager $ 1,751,526 $ 1,262,104 $ 489,422) 27.94% 100-111 Mayor 8t Council 154,351 170,937 16,586 10.75% 100-210 Communication 519,126 321,947 197,179) 37.98% 100-211 City Clerk 130,381 480,697 350,316 268.69% 100-212 Human Resources 205,643 195,506 10,137) 4.93% 100-213 Finance 411,137 619,436 208,299 50.66% 100-214 Assessing 765,087 810,540 45,453 5.94% 100-310 CD Admin 452,266 376,800 75,466) 16.69% 100-311 CD Planning 660,495 626,607 33,888) 5.13% 100-312 CD Inspections 1,280,161 1,382,389 102,228 7.99% 100-410 PR Admin 788,489 607,517 180,972) 22.95% 100-411 PR Park Maintenance 2,995,900 3,036,544 40,644 1.36% 100-412 PR Forestry 721,190 810,084 88,894 12.33% 100-413 PR Plymouth Creek 550,095 623,635 73,540 13.37% 100-510 PD Admin 2,232,822 2,068,989 163,833) 7.34% 100-511 PD Patrol 5,737,658 6,068,458 330,800 5.77% 100-512 PD Support 2,207,144 2,509,561 302,417 13.70% 100-513 PD Emergency Mgmt 40,237 44,147 3,910 100-610 Fire Operations 2,135,560 2,200,381 64,821 3.04% 100-611 Fire RAD 61,358 65,016 3,658 5.96% 100-612 Fire Duty Crew 525,890 554,783 28,893 5.49% 100-710 PW Street Maintenance 4,020,650 4,283,808 263,158 6.55% 100-711 PW Engineering 1,243,946 1,114,760 129,186) 10.39% Total Expenditures 29,591,112 $ 30,234,646 $ 643,534 2.17% Total Revenues Total Expenditures SUMMARY RECAP 29,591,112 30,234,646 643,534 2.17% 29,591,112 30,234,646 643,534 2.17% 2012/2013 Bienniel Budget, City of Plymouth, MN 2 of 2 7/21/2011 City of Plymouth General Fund Revenue Budget Administration - City Manager Division Account 2011-2012 Number Account Description 2009 Actual 2010 Actual 2011 Amended 2012 Proposed Change % Change 4000.100 Taxes Property 22,197,937 22,332,207 22,311,035 22,989,710 678,675 3.04% 4000.200 Taxes Abatements 4200 Intergovern- Federal - Operating 4230.100 Intergovernmental - State- Operatng Market Value 4230.101 Intergovernmental - State- Operatng PERA 46,993 23,497 4350 General Services 4350.101 General Services Maps 8t Ordinances 4350.119 General Services Antennae Charges 105,795 141,729 168,300 149,850 18,450) -10.96% 4500 Special Assessments 4,368 3,871 4620 Contributions Capital 2,270 3,261 4700 Interest Income 40,489 28,718 45,608 20,000 25,608) -56.15% 4800 Other Revenues 30,015 37,300 30,000 30,000 4801 Administrative fee 10,850 15,575 4807 Refunds 8t. Reimbursements 412 4808 Human Rights Honorarium 100 4900.220 Transfers In Transit 17,911 18,269 18,635 18,635) -100.00% 4900.407 Transfers In Project Administration 150,000 150,000) -100.00% 4900.500 Transfers In Water 79,567 82,567 82,567 82,567 4900.510 Transfers In Water Resources 17,388 17,388 17,388 17,388 4900.520 Transfers In Sewer 56,643 58,643 58,643 58,643 4900.530 Transfers In Solid Waste 17,929 17,929 17,929 17,929 4900.540 Transfers In Ice Center 11,939 11,939 11,939 11,939 4900.550 Transfers In Field House 3,824 3,824 3,824 3,824 Total Revenues $ 22,644,330 $ 22,796,816 $ 22,915,868 $ 23,381,850 $ 465,982 2012/2013 Bienniel Budget, City of Plymouth, MN 1 of 138 7/22/2011 City of Plymouth General Fund Expenditure Budget Administration - City Manager Division 2011-2012 Account 2011 Number Description 2009 Actual 2010 Actual Amended 2012 Proposed Change Change 6000 Salaries 6,380 6000.100 Salaries Regular 326,184 299,682 288,500 153,834 134,666) 46.7% 6000.200 Salaries Temporary 309,003 309,003) 100.0% 6020.100 Overtime Regular 114 6050 Benefits 1,866 55,360 15,000 40,360) 72.9% 6050.100 Benefits Social Security 21,355 17,406 16,980 9,538 7,442) 43.8% 6050.101 Benefits Medicare 4,869 4,391 4,250 2,231 2,019) 47.5% 6050.200 Benefits PERA 28,036 20,771 20,930 11,153 9,777) 46.7% 6050.201 Benefits Deferred Compensation 6,637 5,916 4,270 2,000 2,270) 53.2% 6050.300 Benefits Life 6050.303 Benefits Workers Compensation 6050.400 Benefits Dept'l Insurance Allocation 6050.550 Benefits Cell Phone Allowance 6060 Medical Insurance 36,809 21,464 6060.100 Medical Insurance Employer Contribution 11,851 6070 Dental Insurance 2,427 1,265 6070.100 Dental Insurance Employer Contribution 605 6080 Group Life Insurance 1,180 735 400 400 6080.100 Group Life Insurance Employer Contribution 457 1,150 1,150 6100 Office Supplies 3,988 4,175 3,700 3,700 6100.100 Office Supplies Coffee and Cups 130 6500 Employee Development 102 345 6500.100 Employee Development Employee Training 400 1,570 1,300 1,500 200 15.4% 6500.101 Employee Development City wide Training 6500.104 Employee Development Conferences Et Seminars 2,232 1,039 5,000 4,000 1,000) 20.0% 6550 Mileage Et Parking Reimbursement 318 420 400 500 100 25.0% 6600 Meetings 1,023 682 500 750 250 50.0% 6700 Dues and Subscriptions 4,379 2,167 3,260 3,100 160) 4.9% 6700.100 Dues and Subscriptions MN League of Cities 26,865 27,715 30,000 29,402 598) 2.0% 2012/2013 Bienniel Budget, City of Plymouth, MN 2 of 138 7/22/2011 9500.620 Transfers Out Information Technology 2012/2013 Bienniel Budget, City of Plymouth, MN 3 of 138 7/22/2011 City of Plymouth General Fund Expenditure Budget Administration - City Manager Division 2011-2012 Account 2011 Number Description 2009 Actual 2010 Actual Amended 2012 Proposed Change Change 6700.101 Dues and Subscriptions Metro Municipalities 13,066 13,097 13,752 13,595 157) 1.1% 6700.102 Dues and Subscriptions Municipal Legislative Comr 10,500 10,000 11,025 10,500 525) 4.8% 6700.103 Dues and Subscriptions Suburban Rate Authority 6,000 6,541 6,600 6,000 600) 9.1% 6700.106 Dues and Subscriptions Board and Commissions 815 6700.107 Dues and Subscriptions TwinWest Chamber of Corr 580 580 6700.108 Dues and Subscriptions Wright County Hwy 55 Coa 1,000 1,000 1,000 7000 Professional Services 1,530 587 4,000 4,000) 100.0% 7003 Legal 95,212 108,671 110,000 110,917 917 0.8% 7003.100 Legal Retainer 7003.101 Legal Criminal Prosecution 291,471 282,951 286,000 291,440 5,440 1.9% 7006 Medical Fees 7030 Boards and Commissions 2,498 10 7100 Communications 29 7100.100 Communications Postage 2,722 3,263 4,700 3,400 1,300) 27.7% 7100.104 Communications Mobile Telephone 7600 Rentals 8000 Non -Cap Equip (< 5K) 9000.100 Allocations Photocopying 25,078 26,751 26,751 26,751) 100.0% 9000.101 Allocations Information Technology 70,544 70,544 70,544 41,531 29,013) 41.1% 9000.102 Allocations Facilities Management 35,891 52,928 58,607 52,689 5,918) 10.1 9000.104 Allocations Mobile Phone 1,737 1,747 873 873) 100.0% 9000.106 Allocations Telephone 17,010 17,010 17,010 17,010) 100.0% 9000.107 Allocations Central Equipment 13,425 12,927 12,927) 100.0% 9000.108 Allocations Internal Rental Charges 11,105 9000.110 Allocations Risk Management 12,744 12,744 9500.405 Transfers Out Park Replacement 418,306 9500.406 Transfers Out Street Reconstruction 730,000 418,306 9500.610 Transfers Out Public Facilities 140,000 9500.620 Transfers Out Information Technology 2012/2013 Bienniel Budget, City of Plymouth, MN 3 of 138 7/22/2011 Account Number City of Plymouth General Fund Expenditure Budget Administration - City Manager Division 2011 2011-2012 Description 2009 Actual 2010 Actual Amended 2012 Proposed $ Change % Change 9500.630 Transfers Out Risk Management 70,059 70,059 70,059 9500.640 Transfers Out Employee Benefits 53,045 53,045 53,045 9900 Miscellaneous 9,158 10 9906.101 Donations Et Contributions Social Services 110,500 109,450 109,450 109,450 9907 Historical Society 9918 Contingency 130,012 150,000 370,000 Total Expenditures 2,024,874 2,378,757 1,751,526 $ 1,262,104 $ 70,059) -100.0% 53,045) -100.0% 220,000 146.7% 489,422) 2012/2013 Bienniel Budget, City of Plymouth, MN 4 of 138 7/22/2011 City of Plymouth General Fund Expenditure Budget Administration - Mayor and Council Division 2011-2012 Account 2011 Number Description 2009 Actual 2010 Actual Amended 2012 Proposed Change Change 6000.100 Salaries Regular 74,879 74,879 76,780 76,780 6000.200 Salaries Temporary 6050.100 Benefits Social Security 4,573 4,567 4,760 4,760 6050.101 Benefits Medicare 1,069 1,068 1,120 1,120 6050.200 Benefits PERA 3,807 3,949 3,840 3,840 6050.550 Benefits Cell Phone Allowance 6100 Office Supplies 682 727 3,500 1,000 2,500) 71.4% 6500 Employee Development 6500.100 Employee Development Employee Training 6500.104 Employee Development Conferences Et Seminars 824 2,000 2,000 6600 Meetings 2,824 3,599 2,500 2,500 6700 Dues and Subscriptions 20 750 750) 100.0% 7000 Professional Services 750 750) 100.0% 7100 Communications 508 7100.100 Communications Postage 67 5 1,000 250 750) 75.0% 7200 Printing and Publishing 5,170 3,736 5,700 4,000 1,700) 29.8% 8000 Non -Cap Equip (< 5K) 3,900 3,900 9000.101 Allocations Information Technology 10,845 10,845 10,845 25,034 14,189 130.8% 9000.102 Allocations Facilities Management 29,950 39,933 38,933 1,000) 2.5% 9000.104 Allocations Mobile Phone 1,347 873 873 873) 100.0% 9000.110 Allocations Risk Management 6,820 6,820 Total Expenditures $ 105,792 $ 135,021 $ 154,351 $ 170,937 $ 16,586 2012/2013 Bienniel Budget, City of Plymouth, MN 5 of 138 7/22/2011 City of Plymouth General Fund Revenue Budget Administration - Human Resources Division 2011-2012 Account 2012 Number Account Description 2009 Actual 2010 Actual 2011 Amended Proposed $ Change % Change 4230.101 Intergovern mental -State -Operatng PERA $ - $ 23,497 $ 46,993 $ 46,993 $ 4800 Other Revenues 2 - - - Total Revenues $ 2 $ 23,497 $ 46,993 $ 46,993 $ 2012/2013 Bienniel Budget, City of Plymouth, MN 6 of 138 7/22/2011 City of Plymouth General Fund Expenditure Budget Administration - Human Resources Division 2011-2012 Account 2011 Number Description 2009 Actual 2010 Actual Amended 2012 Proposed Change Change 6000 Salaries 24,183) 6000.100 Salaries Regular 204,195 196,307 200,540 162,930 37,610) 18.8% 6010 Salary Vacancies 150,000) 150,000) 6020.100 Overtime Regular 222 41 250 250 6050 Benefits 3,633) 30,663 25,875 4,788) 15.6% 6050.100 Benefits Social Security 15,378 11,651 12,500 10,102 2,398) 19.2% 6050.101 Benefits Medicare 2,939 2,725 2,930 2,365 565) 19.3% 6050.200 Benefits PERA 17,476 14,751 14,538 11,815 2,723) 18.7% 6050.201 Benefits Deferred Compensation 559 688 1,040 1,040 6050.302 Benefits Unemployment 1,034 6060 Medical Insurance 24,287 37,218 6060.100 Medical Insurance Employer Contribution 23,064 6070 Dental Insurance 2,722 1,051 6070.100 Dental Insurance Employer Contribution 1,007 6080 Group Life Insurance 173 192 6080.100 Group Life Insurance Employer Contribution 241 690 690 6100 Office Supplies 1,808 1,215 1,500 1,200 300) 20.0% 6500 Employee Development 4,041 66 6500.100 Employee Development Employee Training 29 65 1,500 1,500 6500.101 Employee Development City wide Training 4,341 18,000 18,000 6500.102 Employee Development Tuition Reimbursement 20,000 6500.103 Employee Development Employee Recognition 5,507 7,820 9,400 9,400 6500.104 Employee Development Conferences Et Seminars 1,374 1,258 5,000 3,500 1,500) 30.0% 6550 Mileage Et Parking Reimbursement 89 6700 Dues and Subscriptions 759 600 500 800 300 60.0% 7000 Professional Services 8,005 27,346 5,000 11,000 6,000 120.0% 7006 Medical Fees 4,180 9,000 32,650 23,650 262.8% 7007 Drug and Alcohol Testing 4,955 4,178 6,000 6,000 7018 Compensation Classification Stdy 500 1,200 1,200 2012/2013 Bienniel Budget, City of Plymouth, MN 7 of 138 7/22/2011 City of Plymouth General Fund Expenditure Budget Administration - Human Resources Division Total Expenditures $ 361,988 $ 347,007 $ 205,643 $ 195,506 $ (10,137) 2012/2013 Bienniel Budget, City of Plymouth, MN 8 of 138 7/22/2011 2011-2012 Account 2011 Number Description 2009 Actual 2010 Actual Amended 2012 Proposed Change % Change 7200 Printing and Publishing 4,841 5,940 5,000 5,000 9000.101 Allocations Information Technology 15,712 15,712 15,712 20,060 4,348 27.7% 9000.102 Allocations Facilities Management 20,378 17,417 16,430 13,608 2,822) -17.2% 9000.110 Allocations Risk Management 6,521 6,521 9900 Miscellaneous 753 Total Expenditures $ 361,988 $ 347,007 $ 205,643 $ 195,506 $ (10,137) 2012/2013 Bienniel Budget, City of Plymouth, MN 8 of 138 7/22/2011 City of Plymouth General Fund Revenue Budget Administrative Services - Communication Services Division Account 2011-2012 Number Account Description 2009 Actual 2010 Actual 2011 Amended 2012 Proposed $ Change % Change 4290 IntergovernmentalOther $ - $ - $ - $ - $ 4350.108 General Services Advertisements (20) - - - 4800 Other Revenues 298 - - - 4900.220 Transfers In Transit - - - 18,635 18,635 4900.660 Transfers In Resource Planning - 200,000 - (200,000) -100.0% Total Revenues $ 278 $ - $ 200,000 $ 18,635 $ (181,365) 2012/2013 Bienniel Budget, City of Plymouth, MN 9 of 138 7/22/2011 City of Plymouth General Fund Expenditure Budget Administrative Services - Communication Services Division 2011-2012 Account 2011 Number Description 2009 Actual 2010 Actual Amended 2012 Proposed Change % Change 6000 Salaries 4,403 6000.100 Salaries Regular 134,348 134,871 138,750 139,138 388 0.3% 6020.100 Overtime Regular 6050 Benefits 1,147 22,950 24,098 1,148 5.0% 6050.100 Benefits Social Security 9,579 7,724 8,600 8,627 27 0.3% 6050.101 Benefits Medicare 1,870 1,806 2,020 2,018 2) -0.1% 6050.200 Benefits PERA 11,078 9,441 10,050 10,088 38 0.4% 6050.201 Benefits Deferred Compensation 6050.300 Benefits Life 6050.303 Benefits Workers Compensation 6050.400 Benefits Dept'l Insurance Allocation 6060 Medical Insurance 19,531 12,746 6060.100 Medical Insurance Employer Contribution 7,911 6070 Dental Insurance 421 263 6070.100 Dental Insurance Employer Contribution 163 6080 Group Life Insurance 512 329 6080.100 Group Life Insurance Employer Contribution 211 540 540 6100 Office Supplies 698 1,089 3,800 1,500 2,300) -60.5% 6120 Operating Supplies 268 6120.100 Operating Supplies Photography 1,045 1,000 1,000 1,000 6500 Employee Development 6500.100 Employee Development Employee Training 20 174 1,000 1,000 6500.104 Employee Development Conferences it Seminars 1,600 1,600 6700 Dues and Subscriptions 435 435 550 550 7000 Professional Services 9,712 7,479 18,000 10,000 8,000) -44.4% 7100.100 Communications Postage 28,456 27,443 33,000 33,000 7100.104 Communications Mobile Telephone 7100.105 Communications Community Identity 2,232 601 3,000 3,000 7200 Printing and Publishing 399 3,403 10,000 3,500 6,500) -65.0% 2012/2013 Bienniel Budget, City of Plymouth, MN 10 of 138 7/22/2011 City of Plymouth General Fund Expenditure Budget Administrative Services - Communication Services Division Account Number Description 2009 Actual 2010 Actual 2011 Amended 2012 Proposed 7200.100 Printing and Publishing Plymouth News 27,670 19,632 35,000 35,000 7500.202 Repair and Maintenance Services Equipment Maint 6,285 8,155 7,000 7,000 7600 Rentals 8000 Non -Cap Equipment 8100.500 Capital Outlay (> 5K) Machinery and Equipment 200,000 9000.100 Allocations Photocopying 9000.101 Allocations Information Technology 8,570 8,570 8,570 21,531 9000.102 Allocations Facilities Management 6,560 11,053 12,550 12,236 9000.104 Allocations Mobile Phone 1,147 1,146 9000.106 Allocations Telephone 9000.108 Allocations Internal Rental Charges 1,197 9000.110 Allocations Risk Management 6,521 2011-2012 Change % Change 200,000) 12,961 314) 1,146) 6,521 Total Expenditures $ 270,618 $ 271,465 $ 519,126 $ 321,947 $ (197,180) 100.0% 151.2% 2.5% 100.0% 2012/2013 Bienniel Budget, City of Plymouth, MN 11 of 138 7/22/2011 Account Number Account Description City of Plymouth General Fund Revenue Budget Administrative Services - City Clerk Division 2011-2012 2009 Actual 2010 Actual 2011 Amended 2012 Proposed $ Change % Change 4100 Licenses $ 175 $ 4100.100 Licenses Gasoline Service Station 2,470 2,470 2,470 2,730 260 4100.200 Licenses Tobacco 9,632 9,450 9,675 12,000 2,325 4100.400 Licenses Garbage Hauler 4,988 4,575 4,250 4,800 550 4100.500 Licenses 3.2 Malt Liquor 5,672 10,100 9,600 9,600 4100.510 Licenses Off -Sale Liquor 5,183 5,320 5,320 6,000 680 4100.520 Licenses On -Sale Liquor 166,949 170,586 168,800 168,800 4100.530 Licenses Wine 23,892 22,000 20,000 20,000 4100.540 Licenses Consumption Et Display 600 450 300 300 4100.600 Licenses Investigation Fee 500 2,000 2,000 4100.740 Licenses Target and Trap Shooting 150 150 150 4100.750 Licenses Fireworks 2,150 1,450 2,300 1,000 1,300) 4100.800 Licenses Amusement 100 800 450 450 4100.850 Licenses Peddler 400) 5,730 3,750 10,000 6,250 4100.900 Licenses Massage 3,860 13,275 8,050 14,000 5,950 4100.950 Licenses Fertilizer 1,000 700 900 900 4350 General Services 4350.101 General Services Maps Et Ordinances 71 188 20 20 4430 Liquor/Tobacco Violations 12,000 10,000 2,000) 4230 Intergovernmental -State -Operatng 1,296 4350.100 General Services Photocopies 920 4800 Other Revenues 45 4807 Refunds Et Reimbursements 4900.660 Transfers In Resource Planning 51,000 51,000 Total Revenues $ 228,882 $ 247,465 $ 249,865 $ 313,750 $ 63,885 10.5% 24.0% 12.9% 12.8% 56.5% 166.7% 73.9% 16.7% 2012/2013 Bienniel Budget, City of Plymouth, MN 12 of 138 7/22/2011 City of Plymouth General Fund Expenditure Budget Administrative Services - City Clerk Division 2011-2012 Account 2011 Number Description 2009 Actual 2010 Actual Amended 2012 Proposed Change Change 6000 Salaries $ 2,647 6000.100 Salaries Regular 13,588 39,095 39,440 208,958 169,518 429.8% 6000.200 Salaries Temporary 65,854 71,000 71,000 6020.100 Overtime Regular 104 5,000 5,000 6050 Benefits 586 1,617 42,500 40,883 2528.3% 6050.100 Benefits Social Security 1,019 2,398 2,500 17,357 14,857 594.3% 6050.101 Benefits Medicare 180 561 580 4,060 3,480 600.0% 6050.200 Benefits PERA 2,925 2,746 2,860 15,150 12,290 429.7% 6050.201 Benefits Deferred Compensation 19 889 910 3,000 2,090 229.7% 6060 Medical Insurance 1,370 3,350 6060.100 Medical Insurance Employer Contribution 2,080 6070 Dental Insurance 182 255 6070.100 Dental Insurance Employer Contribution 174 6080 Group Life Insurance 64 68 6080.100 Group Life Insurance Employer Contribution 44 120 600 480 400.0% 6100 Office Supplies 294 6,555 1,000 7,000 6,000 600.0% 6500 Employee Development 537 6500.100 Employee Development Employee Training 280 200 200 6500.104 Employee Development Conferences Et Seminars 10 200 2,000 2,000 6550 Mileage Et Parking Reimbursement 160 76 200 200 6700 Dues and Subscriptions 270 305 305 350 45 14.8% 7013 Record Retention 3,884 3,898 3,900 5,000 1,100 28.2% 7100.100 Communications Postage 3,142 5,013 1,000 9,000 8,000 800.0% 7200 Printing and Publishing 927 4,854 1,600 7,000 5,400 337.5% 7500 Repair and Maintenance Services 524) 4,480 7500.202 Repair and Maintenance Services Equipment MaintenancE 3,808 3,948 11,000 8,500 2,500) 22.7% 7600 Rentals 2,500 2,800 2,800 9000.101 Allocations Information Technology 612 612 612 47,186 46,574 7610.1% 9000.102 Allocations Facilities Management 2,278 3,222 3,537 4,449 912 25.8% 9000.110 Allocations Risk Management 16,887 16,887 9500.660 Transfers Out Resource Planning 51,000 51,000) 100.0% 2012/2013 Bienniel Budget, City of Plymouth, MN 13 of 138 7/22/2011 City of Plymouth General Fund Expenditure Budget Administrative Services - City Clerk Division 2011-2012 Account 2011 Number Description 2009 Actual 2010 Actual Amended 2012 Proposed $ Change % Change 9925 Recognition Events - 2,500 6,000 2,500 (3,500) -58.3% Total Expenditures $ 34,745 $ 159,293 $ 130,381 $ 480,697 $ 350,316 2012/2013 Bienniel Budget, City of Plymouth, MN 14 of 138 7/22/2011 City of Plymouth General Fund Revenue Budget Administrative Services - Finance Division Account 2011 2012 Number Account Description 2009 Actual 2010 Actual Amended Proposed 2011-2012 Change % Change 4320 Rental Fees $ 4330.800 Utility Charges Penalties 4500.200 Special Assessments County Fees 2,654 2,600 2,600 4700 Interest Income 92 4800 Other Revenues 552 8,033 500 500 4801 Administrative Fee 15 582 500 500 4807 Refunds Et Reimbursements 4900.640 Transfers In Employee Benefits Total Revenues $ 567 $ 11,361 $ 3,600 $ 3,600 2012/2013 Bienniel Budget, City of Plymouth, MN 15 of 138 7/22/2011 City of Plymouth General Fund Expenditure Budget Administrative Services - Finance Division 2011-2012 Account 2011 Number Description 2009 Actual 2010 Actual Amended 2012 Proposed Change Change 6000 Salaries 3,728) 6000.100 Salaries Regular 220,688 191,465 200,340 303,006 102,666 51.2% 6000.200 Salaries Temporary 6020.100 Overtime Regular 718 537 7,000 1,500 5,500) 78.6% 6050 Benefits 190) 31,305 34,000 2,695 8.6% 6050.100 Benefits Social Security 15,837 11,633 13,070 18,280 5,210 39.9% 6050.101 Benefits Medicare 3,213 2,721 3,050 4,420 1,370 44.9% 6050.200 Benefits PERA 21,062 13,441 14,510 22,080 7,570 52.2% 6050.201 Benefits Deferred Compensation 3,945 3,279 3,330 3,330 6050.300 Benefits Life 6050.303 Benefits Workers Compensation 6050.400 Benefits Dept'l Insurance Allocation 6060 Medical Insurance 30,922 19,575 6060.100 Medical Insurance Employer Contribution 9,761 6070 Dental Insurance 2,593 1,296 6070.100 Dental Insurance Employer Contribution 769 6080 Group Life Insurance 743 450 6080.100 Group Life Insurance Employer Contribution 289 770 1,000 230 29.9% 6100 Office Supplies 1,465 1,355 4,500 2,000 2,500) 55.6% 6500 Employee Development 6500.100 Employee Development Employee Training 710 1,482 1,250 1,500 250 20.0% 6500.104 Employee Development Conferences Et Seminars 351 441 2,410 2,000 410) 17.0% 6550 Mileage 8t Parking Reimbursement 19 100 100 6600 Meetings 6700 Dues and Subscriptions 1,185 985 875 1,000 125 14.3% 7000 Professional Services 505 1,493 1,500 1,500 7004 Audit Fees 29,195 32,014 27,991 32,100 4,109 14.7% 7006 Medical Fees 7100 Communications 589 2012/2013 Bienniel Budget, City of Plymouth, MN 16 of 138 7/22/2011 City of Plymouth General Fund Expenditure Budget Administrative Services - Finance Division Account Number Description 2009 Actual 2010 Actual 2011 Amended 2012 Proposed 2011-2012 Change % Change 7100.100 Communications Postage 7,710 5,912 7,800 7,000 800) 10.3% 7100.104 Communications Mobile Telephone 7200 Printing and Publishing 9,404 9,095 9,500 9,500 7200.102 Printing and Publishing Truth In Taxation Notices 4,749 4,450 5,000 5,000 7600 Rentals 8000 Non -Cap Equip (< 5K) 3,570 8100.600 Capital Outlay (> 5K) Software 8930 Special Assessments 9000.100 Allocations Photocopying 9000.101 Allocations Information Technology 17,956 15,712 15,712 100,840 85,128 541.8% 9000.102 Allocations Facilities Management 13,404 43,028 52,902 59,549 6,647 12.6% 9000.104 Allocations Mobile Phone 273 273) 100.0% 9000.105 Allocations Security 7,534 7,534 7,534 7,534) 100.0% 9000.106 Allocations Telephone 9000.108 Allocations Internal Rental Charges 2,617 9000.110 Allocations Risk Management 7,081 7,081 9500.640 Transfers Out Employee Benefits 1,615 1,615 1,615) 100.0% 9900 Miscellaneous 448 11) 400 400) 100.0% 9900.100 Miscellaneous Cash Short / Cash Over 18 9919 Administration Fees 2,654 2,650 2,650 Total Expenditures 396,972 383,234 411,137 619,436 208,299 2012/2013 Bienniel Budget, City of Plymouth, MN 17 of 138 7/22/2011 City of Plymouth General Fund Expenditure Budget Administrative Services - Assessing Division 2011-2012 Account 2011 Number Description 2009 Actual 2010 Actual Amended 2012 Proposed Change Change 6000 Salaries 16,398 6000.100 Salaries Regular 485,799 485,442 504,428 510,099 5,671 1.1 6000.200 Salaries Temporary 6020.100 Overtime Regular 6050 Benefits 4,111 69,561 73,039 3,478 5.0% 6050.100 Benefits Social Security 33,467 30,081 31,750 31,626 124) 0.4% 6050.101 Benefits Medicare 6,877 7,035 7,430 7,396 34) 0.5% 6050.200 Benefits PERA 37,989 33,980 36,550 36,982 432 1.2% 6050.201 Benefits Deferred Compensation 7,399 8,479 7,620 7,620 6050.300 Benefits Life 6050.302 Benefits Unemployment 7,259 6050.303 Benefits Workers Compensation 6050.400 Benefits Dept'l Insurance Allocation 6060 Medical Insurance 54,056 34,383 6060.100 Medical Insurance Employer Contribution 20,720 6070 Dental Insurance 6,334 4,316 6070.100 Dental Insurance Employer Contribution 2,916 6080 Group Life Insurance 1,329 849 6080.100 Group Life Insurance Employer Contribution 545 1,430 1,430 6100 Office Supplies 742 1,116 3,000 2,200 800) 26.7% 6500 Employee Development 63 290 6500.100 Employee Development Employee Training 2,704 2,895 3,050 3,300 250 8.2% 6500.104 Employee Development Conferences Et Seminars 2,592 3,531 3,966 6,500 2,534 63.9% 6550 Mileage £t Parking Reimbursement 428 340 440 816 376 85.4% 6700 Dues and Subscriptions 5,852 6,179 5,909 7,130 1,221 20.7% 7000 Professional Services 1,032 2,790 2,790) 100.0% 7006 Medical Fees 7100 Communications 74 7100.100 Communications Postage 10,625 11,681 15,042 14,200 842) 5.6% 2012/2013 Bienniel Budget, City of Plymouth, MN 18 of 138 7/22/2011 City of Plymouth General Fund Expenditure Budget Administrative Services - Assessing Division Account Number Description 2009 Actual 2010 Actual 2011 Amended 2012 Proposed 7100.103 Communications Telephone 7200 Printing and Publishing 2,288 2,469 2,857 3,600 7600 Rentals 8000 Non -Cap Equip (< 5K) 9000.100 Allocations Photocopying 9000.101 Allocations Information Technology 28,567 28,567 28,567 50,857 9000.102 Allocations Facilities Management 24,856 30,145 31,909 31,925 9000.106 Allocations Telephone 9000.107 Allocations Central Equipment 10,738 8,788 15,000 9000.108 Allocations Internal Rental Charges 16,588 9000.110 Allocations Risk Management 6,820 9500.620 Transfers Out Information Technology 9500.640 Transfers Out Employee Benefits 2011-2012 Change % Change 743 22,290 16 6,212 6,820 Total Expenditures $ 736,847 $ 747,281 $ 765,087 $ 810,540 $ 45,453 26.0% 78.0% 0.1 70.7% 2012/2013 Bienniel Budget, City of Plymouth, MN 19 of 138 7/22/2011 Account Number Account Description 4100.860 Licenses Sign Contractor 4700 Interest Income 4700.100 Interest Income Investments 4800 Other Revenues 4801 Administrative Fee 4900.640 Transfers In Employee Benefits City of Plymouth General Fund Revenue Budget Community Development - Admin Division 2011-2012 2012 2009 Actual 2010 Actual 2011 Amended Proposed $ Change % Change 2,725 $ 3,525 $ - $ 2,500 $ 2,500 20 - - - - Total Revenues $ 2,745 $ 3,525 $ $ 2,500 $ 2,500 2012/2013 Bienniel Budget, City of Plymouth, MN 20 of 138 7/22/2011 City of Plymouth General Fund Expenditure Budget Community Development - Admin Division 2011-2012 Account 2011 Number Description 2009 Actual 2010 Actual Amended 2012 Proposed Change Change 6000 Salaries 8,001 6000.100 Salaries Regular 199,826 221,287 228,710 229,213 503 0.2% 6020.100 Overtime Regular 6050 Benefits 2,109 43,613 45,794 2,181 5.0% 6050.100 Benefits Social Security 13,040 12,337 13,850 14,211 361 2.6% 6050.101 Benefits Medicare 2,763 2,930 3,320 3,324 4 0.1% 6050.200 Benefits PERA 16,033 15,489 16,570 16,618 48 0.3% 6050.201 Benefits Deferred Compensation 6050.300 Benefits Life 6050.303 Benefits Workers Compensation 6050.400 Benefits Dept'l Insurance Allocation 6050.550 Benefits Cell Phone Allowance 6060 Medical Insurance 35,446 23,149 6060.100 Medical Insurance Employer Contribution 16,033 6070 Dental Insurance 414 259 6070.100 Dental Insurance Employer Contribution 161 6080 Group Life Insurance 435 270 6080.100 Group Life Insurance Employer Contribution 272 550 550 6100 Office Supplies 606 1,356 3,500 3,000 500) 14.3% 6500 Employee Development 6500.100 Employee Development Employee Training 90 350 300 50) 14.3% 6500.104 Employee Development Conferences Et Seminars 6700 Dues and Subscriptions 40 100 300 200 100) 33.3% 7006 Medical Fees 7100.104 Communications Mobile Telephone 7600 Rentals 9000.100 Allocations Photocopying 17,537 14,910 14,976 14,976) 100.0% 9000.101 Allocations Information Technology 50,429 50,095 50,095 34,163 15,932) 31.8% 9000.102 Allocations Facilities Management 12,029 14,816 15,745 17,308 1,563 9.9% 2012/2013 Bienniel Budget, City of Plymouth, MN 21 of 138 7/22/2011 Account Number City of Plymouth General Fund Expenditure Budget Community Development - Admin Division 2011 2011-2012 Description 2009 Actual 2010 Actual Amended 2012 Proposed $ Change % Change 9000.104 Allocations Mobile Phone 5,828 4,153 873 873) -100.0% 9000.106 Allocations Telephone 13,052 12,284 12,284 - 12,284) -100.0% 9000.107 Allocations Central Equipment 875 1,101 2,174 1,073 97.5% 9000.108 Allocations Internal Rental Charges 199 9000.110 Allocations Risk Management 9,945 9,945 9500.630 Transfers Out Risk Management 46,429 46,429 46,429 - 46,429) -100.0% 9500.640 Transfers Out Employee Benefits Total Expenditures $ 414,197 $ 447,315 $ 452,266 $ 376,800 $ 75,466) 2012/2013 Bienniel Budget, City of Plymouth, MN 22 of 138 7/22/2011 City of Plymouth General Fund Revenue Budget Community Development - Planning Division Account 2012 Number Account Description 2009 Actual 2010 Actual 2011 Amended Proposed 2011-2012 Change % Change 4150.600 Permits Plan Checking $ - $ $ $ $ 4200.500 Intergovern- Federal - Operating Pass-through - - - 4230 Intergovernmental- State- Operatng - - - - - 4350 General Services - 11,300 - - - 4350.110 General Services Zoning Change Variances 300 - - - - 4350.111 General Services Plat Fees -Subdivision Waiver - - - - - 4350.123 General Services Application Fees 28,159 46,003 29,000 11,500 (17,500) 4801 Administrative Fee - - - $ 17,500 17,500 Total Revenues $ 28,459 $ 57,303 $ 29,000 $ 29,000 $ - 60.3% 2012/2013 Bienniel Budget, City of Plymouth, MN 23 of 138 7/22/2011 City of Plymouth General Fund Expenditure Budget Community Development - Planning Division 2011-2012 Account 2011 Number Description 2009 Actual 2010 Actual Amended 2012 Proposed Change Change 6000 Salaries 8,077 6000.100 Salaries Regular 439,528 416,799 426,920 384,058 42,862) 10.0% 6020.100 Overtime Regular 6050 Benefits 55 2,318 50,495 53,020 2,525 5.0% 6050.100 Benefits Social Security 32,108 25,264 26,450 23,812 2,638) 10.0% 6050.101 Benefits Medicare 6,486 5,953 6,270 5,569 701) 11.2% 6050.200 Benefits PERA 37,421 29,177 30,950 27,844 3,106) 10.0% 6050.201 Benefits Deferred Compensation 6,134 5,117 5,320 5,320 6050.300 Benefits Life 6050.302 Benefits Unemployment 6050.303 Benefits Workers Compensation 6050.400 Benefits Dept'l Insurance Allocation 6050.550 Benefits Cell Phone Allowance 6060 Medical Insurance 44,975 25,061 6060.100 Medical Insurance Employer Contribution 17,183 6070 Dental Insurance 4,828 2,518 6070.100 Dental Insurance Employer Contribution 1,563 6080 Group Life Insurance 1,007 606 6080.100 Group Life Insurance Employer Contribution 490 1,090 1,090 6100 Office Supplies 1,181 643 4,800 3,000 1,800) 37.5% 6130 Repair 8t Maintenance Supplies 2,700 2,700 6130.102 Repair >:t Maintenance Supplies Traffic and Park Si 6500 Employee Development 156 23 6500.100 Employee Development Employee Training 20 239 3,150 2,500 650) 20.6% 6500.104 Employee Development Conferences 8t Seminars 2,432 1,799 6,350 5,000 1,350) 21.3% 6550 Mileage &t Parking Reimbursement 100 100 6700 Dues and Subscriptions 2,800 2,845 5,000 3,000 2,000) 40.0% 7000 Professional Services 10,843 7000.200 Professional Services Billed out pass-through servii 7,359 2012/2013 Bienniel Budget, City of Plymouth, MN 24 of 138 7/22/2011 City of Plymouth General Fund Expenditure Budget Community Development - Planning Division Account Number Description 2009 Actual 2010 Actual 2011 Amended 2012 Proposed 2011-2012 Change % Change 7012 Comprehensive Plan Review 20,000 20,000) 100.0% 7100.100 Communications Postage 2,381 2,439 4,250 4,000 250) 5.9% 7100.104 Communications Mobile Telephone 7200 Printing and Publishing 1,164 1,985 2,500 2,500 7600 Rentals 8000 Non -Cap Equip (< 5K) 9000.100 Allocations Photocopying 9000.101 Allocations Information Technology 25,506 25,506 25,506 28,918 3,412 13.4% 9000.102 Allocations Facilities Management 36,426 39,564 40,610 35,781 4,829) 11.9% 9000.104 Allocations Mobile Phone 9000.106 Allocations Telephone 9000.107 Allocations Central Equipment 812 734 8,674 7,940 1081.7% 9000.108 Allocations Internal Rental Charges 1,046 9000.110 Allocations Risk Management 9,721 9,721 9500.640 Transfers Out Employee Benefits 9500.660 Transfers Out Resource Planning 20,000 20,000 20,000 20,000 Total Expenditures 665,653 654,180 660,495 626,607 33,888) 2012/2013 Bienniel Budget, City of Plymouth, MN 25 of 138 7/22/2011 City of Plymouth General Fund Revenue Budget Community Development - Inspections Division 2011-2012 Account 2012 Number Account Description 2009 Actual 2010 Actual 2011 Amended Proposed $ Change % Change 4100.700 Licenses Rental Dwelling 93,169 $ 88,183 $ 90,000 90,000 $ 4150 Permits 39,778 11,028 15,000 10,000 5,000) 4150.100 Permits Building 17054,236 1,108,747 1,000,000 1,325,000 325,000 4150.200 Permits Plumbing 80,175 105,408 100,000 85,000 15,000) 4150.300 Permits Mechanical Permits 193,963 202,198 200,000 195,000 5,000) 4150.350 Permits Electrical 170,962 163,872 120,000 154,000 34,000 4150.500 Permits Fire Protection 62,903 54,735 72,000 55,000 17,000) 4150.600 Permits Plan Checking 326,665 359,758 350,000 350,000 4150.700 Permits Sign and Billboard 7,984 8,946 10,000 6,000 4,000) 4320 Rental Fees 510) 4350.123 General Services Application Fees 4350.127 General Services After Hours Inspections 100 4800 Other Revenues 1,191 1,326 4801 Administrative Fee 4807 Refunds £t Reimbursements 25 4900.640 Transfers In Employee Benefits Total Revenues 2,030,516 $ 2,104,328 $ 1,957,000 2,270,000 $ 313,000 33.3% 32.5% 15.0% 2.5% 28.3% 23.6% 40.0% 2012/2013 Bienniel Budget, City of Plymouth, MN 26 of 138 7/22/2011 Account Number City of Plymouth General Fund Expenditure Budget Community Development - Inspections Division 2011 2012 Description 2009 Actual 2010 Actual Amended Proposed 2011-2012 Change % Change 6000 Salaries 40,627 $ 6000.100 Salaries Regular 711,798 810,341 832,100 877,697 45,597 5.5% 6000.200 Salaries Temporary 2,620 3,088 31,000 31,000 6050 Benefits 128 8,870 107,969 113,367 5,398 5.0% 6050.100 Benefits Social Security 49,667 48,893 54,180 56,342 2,162 4.0% 6050.101 Benefits Medicare 10,170 11,435 12,660 13,180 520 4.1 6050.200 Benefits PERA 58,578 56,917 60,360 63,641 3,281 5.4% 6050.201 Benefits Deferred Compensation 11,436 11,282 11,100 11,100 6050.302 Benefits Unemployment 4,005 7,942 8,000 8,000 6060 Medical Insurance 76,555 42,676 6060.100 Medical Insurance Employer Contribution 49,471 6070 Dental Insurance 6,480 3,277 6070.100 Dental Insurance Employer Contribution 3,289 6080 Group Life Insurance 1,002 541 6080.100 Group Life Insurance Employer Contribution 653 1,260 1,260 6100 Office Supplies 2,220 2,145 6,500 5,700 800) 12.3% 6120.100 Operating Supplies Photography 8 520 400 120) 23.1% 6140 Miscellaneous Supplies 67 38 6140.102 Miscellaneous Supplies Safety Equipment 216 6500.100 Employee Development Employee Training 4,361 3,934 6,650 6,450 200) 3.0% 6500.104 Employee Development Conferences Et Seminars 444 800 2,350 2,000 350) 14.9% 6700 Dues and Subscriptions 2,476 2,189 2,650 2,905 255 9.6% 7100.100 Communications Postage 4,659 5,065 3,850 3,850 7200 Printing and Publishing 1,704 3,438 4,400 3,100 1,300) 29.5% 8000 Non -Cap Equip (< 5K) 750 650 100) 13.3% 9000.101 Allocations Information Technology 39,586 39,586 39,586 51,014 11,428 28.9% 9000.102 Allocations Facilities Management 31,885 48,224 53,670 52,326 1,344) 2.5% 9000.104 Allocations Mobile Phone 2,730 2,730) 100.0% 9000.107 Allocations Central Equipment 48,253 45,876 42,152 3,724) 8.1% 9000.108 Allocations Internal Rental Charges 55,382 2012/2013 Bienniel Budget, City of Plymouth, MN 27 of 138 7/22/2011 City of Plymouth General Fund Expenditure Budget Community Development - Inspections Division Account 2011 2012 Number Description 2009 Actual 2010 Actual Amended Proposed 2011-2012 Change % Change 9000.11 Allocations Risk Management - 11,255 11,255 9900 Miscellaneous 9 - - 9920.100 Bank Fees Credit Card - - - 25,000 25,000 Total Expenditures $ 1,075,439 $ 1,252,990 $ 1,280,161 $ 1,382,389 $ 102,228 2012/2013 Bienniel Budget, City of Plymouth, MN 28 of 138 7/22/2011 Account Number Account Description City of Plymouth General Fund Revenue Budget Parks and Recreation - Admin Division 2011-2012 2012 2009 Actual 2010 Actual 2011 Amended Proposed $ Change % Change 4320 Rental Fees $ 2,400 $ 2,400 $ $ $ 4800 Other Revenues 802 98 4900.640 Transfers In Employee Benefits - - Total Revenues $ 3,202 $ 2,498 $ $ $ 2012/2013 Bienniel Budget, City of Plymouth, MN 29 of 138 7/22/2011 Account Number Description City of Plymouth General Fund Expenditure Budget Parks and Recreation - Admin Division 2011 2009 Actual 2010 Actual Amended 2012 Proposed 2011-2012 Change % Change 6000 Salaries 11,065 $ 6000.100 Salaries Regular 362,573 361,866 375,280 326,765 48,515) 12.9% 6000.200 Salaries Temporary 1,300 5,610 5,400 6,000 600 11.1% 6020.100 Overtime Regular 692 6050 Benefits 2,622 44,716 46,952 2,236 5.0% 6050.100 Benefits Social Security 26,164 21,468 22,950 20,633 2,317) 10.1% 6050.101 Benefits Medicare 5,194 5,174 5,550 4,826 724) 13.0% 6050.200 Benefits PERA 29,516 25,257 27,210 23,691 3,519) 12.9% 6050.201 Benefits Deferred Compensation 2,986 2,868 2,880 2,880 6060 Medical Insurance 37,943 25,460 6060.100 Medical Insurance Employer Contribution 15,802 6070 Dental Insurance 1,477 853 6070.100 Dental Insurance Employer Contribution 569 6080 Group Life Insurance 546 342 6080.100 Group Life Insurance Employer Contribution 218 580 580 6100 Office Supplies 3,407 3,058 2,250 3,000 750 33.3% 6120 Operating Supplies 5,338 2,258 2,400 2,200 200) 8.3% 6500 Employee Development 1,054 6500.100 Employee Development Employee Training 3,226 100 1,025 900 125) 12.2% 6500.104 Employee Development Conferences Et Seminars 396 2,200 2,200 6550 Mileage Et Parking Reimbursement 663 422 750 575 175) 23.3% 6700 Dues and Subscriptions 1,775 1,470 1,270 1,570 300 23.6% 7000 Professional Services 5,365 7,738 5,300 10,000 4,700 88.7% 7100.100 Communications Postage 1,409 1,203 1,850 1,400 450) 24.3% 7100.104 Communications Mobile Telephone 57 7200 Printing and Publishing 84 9000.100 Allocations Photocopying 15,201 26,900 26,966 26,966) 100.0% 9000.101 Allocations Information Technology 57,675 57,675 57,675 46,743 10,932) 19.0% 9000.102 Allocations Facilities Management 60,404 69,507 72,542 69,579 2,963) 4.1% 9000.104 Allocations Mobile Phone 12,528 924 924 924) 100.0% 2012/2013 Bienniel Budget, City of Plymouth, MN 30 of 138 7/22/2011 Account Number Description City of Plymouth General Fund Expenditure Budget Parks and Recreation - Admin Division 2011 2012 2009 Actual 2010 Actual Amended Proposed 2011-2012 Change % Change 9000.105 Allocations Security 19,085 19,085 19,085 19,085) -100.0% 9000.106 Allocations Telephone 21,255 21,255 21,255 21,255) -100.0% 9000.107 Allocations Central Equipment 13,120 12,778 23,940 11,162 87.4% 9000.108 Allocations Internal Rental Charges 3,294 9000.110 Allocations Risk Management 8,083 8,083 9500.630 Transfers Out Risk Management 70,653 70,653 70,653 70,653) -100.0% 9904 Real Estate Taxes 4 9907 Historical Society 2,515 2,221 9925 Recognition Events 4,490 5,000 5,000 Total Expenditures $ 753,300 $ 781,733 $ 788,489 $ 607,517 $ 180,972) 2012/2013 Bienniel Budget, City of Plymouth, MN 31 of 138 7/22/2011 City of Plymouth General Fund Revenue Budget Parks and Recreation - Park Maintenance Division Account 2012 Number Account Description 2009 Actual 2010 Actual 2011 Amended Proposed 2011-2012 Change % Change 4310 Program Fees $ 84,826 $ 70,000 $ - $ (70,000) 4320 Rental Fees 2,874 85,000 100,000 15,000 4350.106 General Services Weeds 4350.107 General Services Tree Removal 4350.114 General Services Garden Plots 2,859 0 - - - 4360.113 Items for Resale Chalk 461 4620 Contributions - Capital 5,000 4800 Other Revenues 295 4807 Refunds Ft Reimbursements 750 4900.640 Transfers In Employee Benefits Total Revenues $ 9,070 $ 87,995 $ 155,000 $ 100,000 $ (55,000) 100.0% 17.6% 2012/2013 Bienniel Budget, City of Plymouth, MN 32 of 138 7/22/2011 City of Plymouth General Fund Expenditure Budget Parks and Recreation - Park Maintenance Division 2011-2012 Account 2011 Number Description 2009 Actual 2010 Actual Amended 2012 Proposed Change Change 6000 Salaries 22,351 6000.100 Salaries Regular 862,597 869,339 895,083 899,506 4,423 0.5% 6000.200 Salaries Temporary 241,665 213,645 214,200 214,200 6020 Overtime 1,312 1,300 1,300 6020.100 Overtime Regular 17,344 20,350 29,500 30,000 500 1.7% 6050 Benefits 6,873 165,112 173,368 8,256 5.0% 6050.100 Benefits Social Security 77,570 67,085 64,697 55,769 8,928) 13.8% 6050.101 Benefits Medicare 15,910 15,689 16,680 13,043 3,637) 21.8% 6050.200 Benefits PERA 81,771 71,738 64,919 65,214 295 0.5% 6050.201 Benefits Deferred Compensation 12,620 14,200 12,000 12,000 6050.300 Benefits Life 6050.301 Benefits Long Term Disability 1,328 6050.302 Benefits Unemployment 40,348 39,280 45,000 45,000 6050.303 Benefits Workers Compensation 6050.400 Benefits Dept'[ Insurance Allocation 6060 Medical Insurance 142,386 84,261 6060.100 Medical Insurance Employer Contribution 52,377 6070 Dental Insurance 9,825 6,585 6070.100 Dental Insurance Employer Contribution 4,093 6080 Group Life Insurance 1,443 910 6080.100 Group Life Insurance Employer Contribution 586 1,490 1,490 6100 Office Supplies 638 933 1,100 1,000 100) 9.1 6120 Operating Supplies 128,640 113,880 122,300 122,300 6120.100 Operating Supplies Photography 6120.103 Operating Supplies Janitorial 3,691 1,801 3,850 2,850 1,000) 26.0% 6120.107 Operating Supplies Animal Control 3,834 6,284 10,000 10,000) 100.0% 6120.108 Operating Supplies Twin City Tree Trust 8,428 5,648 8,500 8,500 6120.120 Operating Supplies McGruff Truck Program 6130 Repair Et Maintenance Supplies 6,237 2,020 2012/2013 Bienniel Budget, City of Plymouth, MN 33 of 138 7/22/2011 City of Plymouth General Fund Expenditure Budget Parks and Recreation - Park Maintenance Division Account Number Description 6130.101 Repair Et Maintenance Supplies Horticulture 6130.102 Repair Et Maintenance Supplies Traffic and Park Si 6130.104 Repair Et Maintenance Supplies Sand and Gravel 6130.107 Repair Et Maintenance Supplies Concrete and Asph 6130.118 Repair Et Maintenance Supplies Playstructure Repa 6130.119 Repair Et Maintenance Supplies Recharges 6130.121 Repair Et Maintenance Supplies Sprinkler Head Rer 6140 Miscellaneous Supplies 6140.100 Miscellaneous Supplies Medical 6140.101 Miscellaneous Supplies Uniforms 6140.102 Miscellaneous Supplies Safety Equipment 6500 Employee Development 6500.100 Employee Development Employee Training 6500.104 Employee Development Conferences Et Seminars 6550 Mileage Et Parking Reimbursement 6700 Dues and Subscriptions 7000 Professional Services 7006 Medical Fees 7007 Drug and Alcohol Testing 7016 Animal Control 7017 Laundry Services 7100 Communications 7100.100 Communications Postage 7100.104 Communications Mobile Telephone 7200 Printing and Publishing 7400 Utilities 7400.102 Utilities Natural Gas 7400.103 Utilities Water and Sewer 7400.104 Utilities Solid Waste 2009 Actual 2010 Actual 2011 Amended 2012 Proposed 2011-2012 Change % Change 45,858 44,653 46,462 46,462 3,484 3,351 6,200 5,000 1,200) 19.4% 22,920 16,755 18,500 18,500 65,718 22,793 52,750 57,750 5,000 9.5% 5,313 8,066 8,000 8,000 1,000 500 500) 50.0% 5,654 3,101 4,500 4,500 939 23 2,500 2,500) 100.0% 1,435 1,073 5,500 2,500 3,000) 54.5% 195 1,188 5,500 5,500 171 416 1,500 500 1,000) 66.7% 300 540 315 600 285 90.5% 48,787 40,551 44,000 44,000 2,821 2,500 2,500) 100.0% 611 2,090 1,805 10,000 10,000 5,723 5,371 8,100 7,000 1,100) 13.6% 191 583 600 600 97 189 1,000 500 500) 50.0% 6,153 4,946 7,365 5,000 2,365) 32.1% 58,430 61,765 50,399 63,464 13,065 25.9% 13,041 12,204 11,500 13,000 1,500 13.0% 2012/2013 Bienniel Budget, City of Plymouth, MN 34 of 138 7/22/2011 City of Plymouth General Fund Expenditure Budget Parks and Recreation Park Maintenance Division 2011-2012 Account 2011 Number Description 2009 Actual 2010 Actual Amended 2012 Proposed Change % Change 7400.108 Utilities Electric 97,072 100,000 100,000 7500 Repair and Maintenance Services 44,238 36,578 47,000 47,000 7500.100 Repair and Maintenance Services Landscape 82,922 87,493 92,000 92,000 7500.102 Repair and Maintenance Services Weed Control 12,771 11,173 15,000 15,000 7500.103 Repair and Maintenance Services Irrigation 5,545 1,576 7,000 3,500 3,500) -50.0% 7500.104 Repair and Maintenance Services Electrical 35,677 31,108 50,000 10,000 40,000) -80.0% 7500.105 Repair and Maintenance Services Plumbing 786 2,601 2,100 2,100 7500.106 Repair and Maintenance Services Bulldozer Work 1,489 875 2,800 2,800 7500.107 Repair and Maintenance Services Tennis Court 12,841 1,400 11,000 11,000 7500.108 Repair and Maintenance Services Snow Plowing 7500.109 Repair and Maintenance Services Seal Coating 31,960 18,388 7500.113 Repair and Maintenance Services Curb Raising Et C 3,100 7500.114 Repair and Maintenance Services Retaining Walls/ 5,000 5,000 7500.128 Repair and Maintenance Services Painting 1,326 1,300 1,300 7500.130 Repair and Maintenance Services Building Mainten 10,778 7,560 7,700 7,700 7500.133 Repair and Maintenance Services Millennium Gard 872 8,580 7500.201 Repair and Maintenance Services Departmental So 7500.202 Repair and Maintenance Services Equipment Maint 191 995 2,100 2,100 7600 Rentals 8,279 4,364 7,500 6,000 1,500) -20.0% 7600.100 Rentals Portable Toilets 28,154 28,479 40,000 36,000 4,000) -10.0% 8000 Non-Cap Equip (< 5K) 1,664 7,810 6,200 6,200) -100.0% 8100.200 Capital Outlay (> 5K) Infrastructure 0 8100.300 Capital Outlay (> 5K) Buildings 8100.400 Capital Outlay (> 5K) Improv Other Than Buildings 0 8100.500 Capital Outlay (> 5K) Machinery and Equipment 48,875 13,000 13,000 8100.800 Capital Outlay (> 5K) Construction Projects 9000.100 Allocations Photocopying 9000.101 Allocations Information Technology 73,866 73,866 73,866 39,488 34,378) -46.5% 9000.102 Allocations Facilities Management 23,835 54,339 64,640 45,833 18,807) -29.1% 2012/2013 Bienniel Budget, City of Plymouth, MN 35 of 138 7/22/2011 Account Number 9000.104 9000.105 9000.106 9000.107 9000.108 9000.110 9500.400 9500.405 9500.600 City of Plymouth General Fund Expenditure Budget Parks and Recreation - Park Maintenance Division 2011 2011-2012 Description 2009 Actual 2010 Actual Amended 2012 Proposed $ Change % Change Allocations Mobile Phone 4,647 6,006 Allocations Security Allocations Telephone Allocations Central Equipment 419,082 486,266 462,729 Allocations Internal Rental Charges 223,029 Allocations Risk Management 195,078 Transfers Out General Capital Projects 44,705 Transfers Out Park Replacement 77,480 84,600 86,300 Transfers Out Central Equipment 75,544 Total Expenditures 2,698,127 2,931,208 2,990,900 $ 3,036,544 $ 6,006) -100.0% 23,537) -4.8% 195,078 86,300) -100.0% 45,644 2012/2013 Bienniel Budget, City of Plymouth, MN 36 of 138 7/22/2011 2012/2013 Bienniel Budget, City of Plymouth, MN 37 of 138 7/22/2011 City of Plymouth General Fund Revenue Budget Parks and Recreation - Forestry Division 2011-2012 Account 2012 Number Account Description 2009 Actual 2010 Actual 2011 Amended Proposed Change % Change 4350.106 General Services Weeds 11,031 $ 4,205 $ 4,000 $ 4,000 4350.107 General Services Tree Removal 944) 453 17,500 10,000 7,500) -42.9% 4360.111 Items for Resale Mulch 275 - - 500 500 4801 Administrative Fee 2,623 999 1,500 1,500 4350.114 General Services Garden Plots 2,871 3,045 37480 435 14.3% Total Revenues $ 12,986 $ 8,528 $ 26,045 $ 19,480 6,565) 2012/2013 Bienniel Budget, City of Plymouth, MN 37 of 138 7/22/2011 City of Plymouth General Fund Expenditure Budget Parks and Recreation - Forestry Division Account Number Description 6000 Salaries 6000.100 Salaries Regular 6000.200 Salaries Temporary 6020.100 Overtime Regular 6050 Benefits 6050.100 Benefits Social Security 6050.101 Benefits Medicare 6050.200 Benefits PERA 6050.201 Benefits Deferred Compensation 6050.302 Benefits Unemployment 6060 Medical Insurance 6060.100 Medical Insurance Employer Contribution 6070 Dental Insurance 6070.100 Dental Insurance Employer Contribution 6080 Group Life Insurance 6080.100 Group Life Insurance Employer Contribution 6100 Office Supplies 6120 Operating Supplies 6120.113 Operating Supplies Community Planting 6120.114 Operating Supplies Reforestation 6120.115 Operating Supplies Nursery 6120.116 Operating Supplies Tree Fertilizer 6130.101 Repair $ Maintenance Supplies Horticulture 6130.105 Repair & Maintenance Supplies Paint 6140.101 Miscellaneous Supplies Uniforms 6140.102 Miscellaneous Supplies Safety Equipment 6500 Employee Development 6500.100 Employee Development Employee Training 6550 Mileage F± Parking Reimbursement 6600 Meetings 2012/2013 Bienniel Budget, City of Plymouth, MN 2011-2012 2011 2012 2009 Actual 2010 Actual Amended Proposed $ Change % Change 8,943 $ 190,418 187,666 192,190 192,560 370 0.2% 124,059 126,000 135,450 135,450 3,775 4,708 5,400 5,400 2,213 40,153 42,161 2,008 5.0% 21,123 18,986 18,610 20,672 2,062 11.1 4,561 4,440 4,840 4,834 6) 0.1% 19,526 18,176 13,940 24,173 10,233 73.4% 1,160 1,175 1,200 1,200 24,249 20,989 22,000 22,000 33,104 20,866 12,699 1,589 262 160 571 364 232 600 600 643 784 1,000 1,000 212 700 694 5,460 5,000 5,400 5,400) 100.0% 5,778 4,306 5,100 5,100 17,087 16,837 16,800 22,200 5,400 32.1% 154 126 400 400 1,000 500 500) 50.0% 2,900 2,084 3,600 3,000 600) 16.7% 330 663 1,170 1,010 1,100 90 8.9% 521 819 600 850 250 41.7% 156 176 500 300 200) 40.0% 38 of 138 7/22/2011 City of Plymouth General Fund Expenditure Budget Parks and Recreation - Forestry Division Account Number Description 6700 Dues and Subscriptions 7000 Professional Services 7006 Medical Fees 7007 Drug and Alcohol Testing 7017 Laundry Services 7100.100 Communications Postage 7100.104 Communications Mobile Telephone 7200 Printing and Publishing 7500.100 Repair and Maintenance Services Landscape 7500.102 Repair and Maintenance Services Weed Control 7500.124 Repair and Maintenance Services Hauling 7500.137 Repair and Maintenance Services Chemical Contro 7500.300 Repair and Maintenance Services Street Tree Main 7500.301 Repair and Maintenance Services Tree Contract RE 7500.302 Repair and Maintenance Services Forced Tree Rea 7500.303 Repair and Maintenance Services Oak Wilt Tree TE 7600 Rentals 8000 Non -Cap Equip (< 5K) 8100.500 Capital Outlay (> 5K) Machinery and Equipment 9000.101 Allocations Information Technology 9000.102 Allocations Facilities Management 9000.104 Allocations Mobile Phone 9000.107 Allocations Central Equipment 9000.108 Allocations Internal Rental Charges 9000.110 Allocations Risk Management 9500.600 Transfers Out Central Equipment Total Expenditures 2011-2012 2011 2012 2009 Actual 2010 Actual Amended Proposed $ Change % Change 415 1,979 2,261 139 381 1,417 35 455 36,359 11,889 400 57,772 76,488 5,643 45 730 1,397 12,243 2,487 62,928 9,541 490 3,502 358 1,230 901 45,919 13,059 600 1,086 41,356 122,647 1,547 50 2,200 2,660 12,243 5,925 2,460 31,422 440 5,500 1,400 1,080 1,400 120 600 36,500 16,500 1,800 2,200 40,500 98,000 17,500 200 3,600 2,000 12,243 7,071 2,457 22,286 500 5,200 500 1,400 900 36,500 16,500 1,000 1,700 41,300 88,000 17,500 200 2,500 2,000 20,000 21,859 5,014 53,331 10,680 60 13.6% 300) 5.5% 1,400) 100.0% 580) 53.7% 120) 100.0% 300 50.0% 800) 500) 800 10,000) 20,000 9,616 2,057) 2,457) 31,045 10,680 744,438 $ 748,837 $ 721,190 $ 810,084 $ 88,894 44.4% 22.7% 2.0% 10.2% 30.6% 78.5% 29.1 100.0% 139.3% 2012/2013 Bienniel Budget, City of Plymouth, MN 39 of 138 7/22/2011 City of Plymouth General Fund Revenue Budget Parks and Recreation - Plymouth Creek Center Division Account 2012 Number Account Description 2009 Actual 2010 Actual 2011 Amended Proposed 4310 Program Fees 4320 Rental Fees 4320.104 Rental Fees Millenium Garden 4320.200 Rental Fees Meeting Rooms 4320.201 Rental Fees Building Lease 4320.202 Rental Fees Catering Rebate 4320-203 Rental Fees Chair Rebate 4800 Other Revenues 2011-2012 Change % Change 7,497 $ 10,000 $ 9,000 $ 1,000) 129,799 58,482 17,516 18,979 25,000 28,000 3,000 15,094 94,213 101,720 95,000 6,720) 7,052 6,880 6,880 40,000 43,000 3,000 2,000 2,000 76 1,618 Total Revenues $ 162,485 $ 187,843 $ 183,600 $ 183,880 $ 280 10.0% 12.0% 6.6% 7.5% 2012/2013 Bienniel Budget, City of Plymouth, MN 40 of 138 7/22/2011 City of Plymouth General Fund Expenditure Budget Parks and Recreation - Plymouth Creek Center Division 2011-2012 Account 2011 Number Description 2009 Actual 2010 Actual Amended 2012 Proposed Change Change 6000 Salaries 9,079 $ 6000.100 Salaries Regular 214,642 213,742 223,922 222,851 1,071) 0.5% 6000.200 Salaries Temporary 51,303 48,979 47,000 47,000 6020.100 Overtime Regular 596 345 500 500 6050 Benefits 2,325 28,296 29,711 1,415 5.0% 6050.100 Benefits Social Security 18,699 16,354 17,290 13,817 3,473) 20.1% 6050.101 Benefits Medicare 3,901 3,825 4,044 3,231 813) 20.1 6050.200 Benefits PERA 20,623 18,083 16,234 16,157 77) 0.5% 6050.201 Benefits Deferred Compensation 7,027 4,238 7,436 7,436 6050.300 Benefits Life 6050.302 Benefits Unemployment 4 2,000 2,000 6050.303 Benefits Workers Compensation 6050.400 Benefits Dept1 Insurance Allocation 6060 Medical Insurance 23,583 19,965 6060.100 Medical Insurance Employer Contribution 13,058 6070 Dental Insurance 1,793 1,411 6070.100 Dental Insurance Employer Contribution 774 6080 Group Life Insurance 570 364 6080.100 Group Life Insurance Employer Contribution 235 607 607 6100 Office Supplies 2,467 1,992 2,000 2,000 6100.100 Office Supplies Coffee and Cups 2,983 288 288) 100.0% 6120 Operating Supplies 4,399 1,033 2,000 1,500 500) 25.0% 6120.103 Operating Supplies Janitorial 7,459 9,568 11,200 10,000 1,200) 10.7% 6130 Repair Et Maintenance Supplies 213 6130.119 Repair Et Maintenance Supplies Recharges 500 700 200 40.0% 6140.101 Miscellaneous Supplies Uniforms 814 810 800 900 100 12.5% 6500 Employee Development 41 6500.100 Employee Development Employee Training 595 275 300 25 9.1 6500.104 Employee Development Conferences Et Seminars - 775 525 1,000 475 90.5% 2012/2013 Bienniel Budget, City of Plymouth, MN 41 of 138 7/22/2011 2012/2013 Bienniel Budget, City of Plymouth, MN 42 of 138 7/22/2011 City of Plymouth General Fund Expenditure Budget Parks and Recreation Plymouth Creek Center Division 2011-2012 Account 2011 Number Description 2009 Actual 2010 Actual Amended 2012 Proposed Change Change 6550 Mileage Et Parking Reimbursement 52 250 200 50) 20.0% 6700 Dues and Subscriptions 150 120 120 150 30 25.0% 7000 Professional Services 555 1,000 16,000 15,000 1500.0% 7004 Audit Fees 870 1,142 1,000 1,200 200 20.0% 7006 Medical Fees 550 550) 100.0% 7100.100 Communications Postage 1,147 840 1,100 1,000 100) 9.1 7100.103 Communications Telephone 7100.104 Communications Mobile Telephone 7200 Printing and Publishing 1,888 2,025 3,200 2,200 1,000) 31.3% 7400.102 Utilities Natural Gas 10,938 10,530 18,000 15,000 3,000) 16.7% 7400.103 Utilities Water and Sewer 10,289 10,363 11,700 10,648 1,052) 9.0% 7400.104 Utilities Solid Waste 2,211 2,364 2,900 3,000 100 3.4% 7400.108 Utilities Electric 42,821 41,377 48,256 45,000 3,256) 6.7% 7500.104 Repair and Maintenance Services Electrical 1,000 1,000 7500.118 Repair and Maintenance Services Janitorial Servic( 8,161 4,713 5,280 5,500 220 4.2% 7500.130 Repair and Maintenance Services Building Mainten 16,206 13,614 12,200 14,000 1,800 14.8% 7500.135 Repair and Maintenance Services Building Security 7500.202 Repair and Maintenance Services Equipment Maint 494 3,400 2,000 1,400) 41.2% 7600 Rentals 1,000 500 500) 50.0% 8000 Non -Cap Equip (< 5K) 2,956 8,669 8,500 8,500 8100 Capital Outlay (> 5K) 8,476 8,476) 100.0% 8100.500 Capital Outlay (> 5K) Machinery and Equipment 9000.100 Allocations Photocopying 9000.101 Allocations Information Technology 13,467 13,467 13,467 71,771 58,304 432.9% 9000.102 Allocations Facilities Management 34,803 34,803 34,803 27,987 6,816) 19.6% 9000.104 Allocations Mobile Phone 1,060 1,092 1,092) 100.0% 9000.105 Allocations Security 9000.106 Allocations Telephone 9000.107 Allocations Central Equipment 3,026 4,034 4,034) 100.0% 2012/2013 Bienniel Budget, City of Plymouth, MN 42 of 138 7/22/2011 Account Number Description City of Plymouth General Fund Expenditure Budget Parks and Recreation - Plymouth Creek Center Division 2011 2011-2012 2009 Actual 2010 Actual Amended 2012 Proposed $ Change % Change 9000.108 Allocations Internal Rental Charges 9000.110 Allocations Risk Management 29,469 29,469 9500.630 Transfers Out Risk Management 9500.640 Transfers Out Employee Benefits 9900 Miscellaneous 1 9900.100 Miscellaneous Cash Short / Cash Over 8) 9904 Real Estate Taxes 1,546 1,615 1,900 1,900 9913 Licenses Et Permits 868 1,295 950 1,300 350 36.8% 9917 Bad Debt 1) 9920 Bank Fees 3,692 5,132 4,000 4,000) -100.0% 9920.100 Bank Fees Credit Card Fees 5,600 5,600 Total Expenditures $ 514,326 $ 523,600 $ 550,095 $ 623,635 $ 73,540 2012/2013 Bienniel Budget, City of Plymouth, MN 43 of 138 7/22/2011 Account Number City of Plymouth General Fund Revenue Budget Police - Administrative Division Account Description 2009 Actual 2010 Actual 2011 Amended 2012 Proposed 2011-2012 Change % Change 4100 Licenses 25 4100.300 Licenses Pet 3,275 934 4100.600 Licenses Investigation Fee 9,300 5,600 5,000 5,000) 100.0% 4100.730 Licenses Hunting 360 270 50 50) 100.0% 4150.550 Permits Alarm 4200 Intergovern- Federal- Operating 144,288 158,247 105,933 71,833 34,100) 32.2% 4200.500 Intergovern- Federal - Operating Pass-through 13,950 4220 Intergovernmental- Federal-Capitl 4230 Intergovernmental- State- Operatng 31,403 24,378 29,100 29,100) 100.0% 4230.103 Intergovernmental-State-Operatng Police State Ai 467,518 452,805 438,152 450,000 11,848 2.7% 4230.104 Intergovernmental-State-Operatng Disabled Offic( 10,240 10,010 23,000 23,000) 100.0% 4230.106 Intergovernmental-State-Operatng Police Traininc 25,000 25,000 4230.202 Intergovernmental-State-Operatng DARE Program 1,300 4250 Intergovernmental-County-Opertng 67 4270.100 Intergovernmental- Local- Operatng School Liaison 387,104 425,660 409,291 367,208 42,083) 10.3% 4310 Program Fees 3,000 3,000 4350 General Services 4,776 3,516 4350.102 General Services Alarm Fees 44,500 36,425 55,000 40,000 15,000) 27.3% 4350.103 General Services Accident Reports 1,239 1,641 1,000 1,000) 100.0% 4350.104 General Services Police Services 88,582 103,499 78,500 22,715 55,785) 71.1% 4350.105 General Services Towing 2,815 2,760 5,000 5,000 4350.122 General Services Police Training 1,100 1,100 4350.126 General Services Noise Ordinance Fees 250 4360 Items for Resale 4360.103 Items for Resale Amberstick 252 4400 General Fines Et Forfeitures 4410 Court Fines 784,434 721,388 883,500 750,000 133,500) 15.1% 4420 Animal Impound Fees 6,477 5,899 5,000 5,500 500 10.0% 4430 Liquor/Tobacco Violations 6,250 5,500 12,000 10,000 2,000) 16.7% 4600 Contributions - Operating 1,200 2012/2013 Bienniel Budget, City of Plymouth, MN 44 of 138 7/22/2011 Account Number Account Description City of Plymouth General Fund Revenue Budget Police - Administrative Division 2011-2012 2012 2009 Actual 2010 Actual 2011 Amended Proposed $ Change % Change 4620 Contributions - Capital 700 700 4700.100 Interest Income Investments - - - - 4800 Other Revenues 2,424 2,181 4800.100 Other Revenues Recycled Ammunition Brass - 231 - 4900.660 Transfers In Resource Planning - - 3,000 - (3,000) Total Revenues $ 2,010,804 $ 1,962,169 $ 2,080,326 $ 1,752,056 $ (328,270) 100.0% 2012/2013 Bienniel Budget, City of Plymouth, MN 45 of 138 7/22/2011 Account Number Description City of Plymouth General Fund Expenditure Budget Police - Administration Division 2011 2009 Actual 2010 Actual Amended 2012 Proposed 2011-2012 Change % Change 6000 Salaries 29,618 $ 6000.100 Salaries Regular 965,216 1,012,819 1,035,440 755,236 280,204) 27.1% 6000.200 Salaries Temporary 64,748 35,188 61,510 76,000 14,490 23.6% 6000.300 Salaries Court Time 6020 Overtime 678 510 510 6020.100 Overtime Regular 55,074 74,181 2,000 65,000 63,000 3150.0% 6020.200 Overtime Court Time 6020.300 Overtime Holiday 171 82 100 100 6020.400 Overtime Contractual 4,781 463 2,000 2,000 6050 Benefits 78) 9,474 141,704 148,789 7,085 5.0% 6050.100 Benefits Social Security 55,503 44,749 49,740 27,310 22,430) 45.1% 6050.101 Benefits Medicare 13,628 14,320 14,030 13,022 1,008) 7.2% 6050.200 Benefits PERA 114,470 101,328 97,510 88,015 9,495) 9.7% 6050.201 Benefits Deferred Compensation 15,710 19,207 16,850 16,850 6050.300 Benefits Life 6050.301 Benefits Long Term Disability 6050.302 Benefits Unemployment 3,667 7,573 6050.303 Benefits Workers Compensation 6050.400 Benefits Dept'[ Insurance Allocation 6050.500 Benefits Clothing Allowance 3,147 4,545 1,320 1,320) 100.0% 6050.550 Benefits Cell Phone Allowance 6050.700 Benefits Disabled Officer 6060 Medical Insurance 125,355 86,474 6060.100 Medical Insurance Employer Contribution 71,643 6070 Dental Insurance 8,282 5,829 6070.100 Dental Insurance Employer Contribution 3,724 6080 Group Life Insurance 2,745 1,899 6080.100 Group Life Insurance Employer Contribution 1,246 3,110 3,110 6100 Office Supplies 15,648 15,427 21,500 18,000 3,500) 16.3% 6100.100 Office Supplies Coffee and Cups 2012/2013 Bienniel Budget, City of Plymouth, MN 46 of 138 7/22/2011 2012/2013 Bienniel Budget, City of Plymouth, MN 47 of 138 7/22/2011 City of Plymouth General Fund Expenditure Budget Police - Administration Division 2011-2012 Account 2011 2012 Number Description 2009 Actual 2010 Actual Amended Proposed Change Change 6120.104 Operating Supplies Shooting Range 4,238 3,735 4,550 15,550 11,000 241.8% 6120.122 Operating Supplies Reserve Program 1,871 1,115 2,600 2,600 6120.123 Operating Supplies Explorer Program 0 6,929 7,000 7,000 6120.124 Operating Supplies Volunteer Program 233 349 600 600) 100.0% 6120.128 Operating Supplies Property Room 2,400 2,400 6130.100 Repair Et Maintenance Supplies Equipment Parts 75 6140.100 Miscellaneous Supplies Medical 462 6140.101 Miscellaneous Supplies Uniforms 236 44 300 300) 100.0% 6140.102 Miscellaneous Supplies Safety Equipment 199) 100 100) 100.0% 6500 Employee Development 318 6500.100 Employee Development Employee Training 34,080 26,953 43,555 35,000 8,555) 19.6% 6500.103 Employee Development Employee Recognition 5,008 2,762 3,000 3,000 6500.104 Employee Development Conferences Et Seminars 2,364 2,518 4,600 4,600 6550 Mileage Et Parking Reimbursement 119 6 100 100 6600 Meetings 6700 Dues and Subscriptions 4,140 5,135 5,420 5,000 420) 7.7% 7000 Professional Services 110,136 102,901 12,000 12,000 7000.100 Professional Services Citizen's Accademy 69 7006 Medical Fees 2,979 92 3,000 3,000) 100.0% 7008 Veterinary Fees 260 324 1,000 1,000 7016 Animal Control 19,987 18,669 22,100 23,300 1,200 5.4% 7100.100 Communications Postage 7,794 7,311 10,500 10,500 7200 Printing and Publishing 2,221 834 3,000 3,000 7500.202 Repair and Maintenance Services Equipment Maini 10,813 7,326 10,000 10,000 7600 Rentals 7600.100 Rentals Portable Toilets 8000 Non -Cap Equip (< 5K) 15,709 12,263 7,000 5,000 2,000) 28.6% 8100.600 Capital Outlay (> 5K) Software 12,718 9000.100 Allocations Photocopying 9,725 16,900 16,966 16,966) 100.0% 2012/2013 Bienniel Budget, City of Plymouth, MN 47 of 138 7/22/2011 Total Expenditures $ 2,435,647 $ 2,534,526 $ 2,232,822 $ 2,068,989 $ (163,833 2012/2013 Bienniel Budget, City of Plymouth, MN 48 of 138 7/22/2011 City of Plymouth General Fund Expenditure Budget Police - Administration Division 2011-2012 Account 2011 2012 Number Description 2009 Actual 2010 Actual Amended Proposed Change Change 9000.101 Allocations Information Technology 215,420 215,420 215,420 165,939 49,481) 23.0% 9000.102 Allocations Facilities Management 149,652 113,410 73,197 146,918 73,721 100.7% 9000.104 Allocations Mobile Phone 39,048 31,044 2,565 2,565) 100.0% 9000.105 Allocations Security 24,513 24,513 24,513 24, 513) 100.0% 9000.106 Allocations Telephone 37,864 37,864 37,864 37,864) 100.0% 9000.107 Allocations Central Equipment 27,382 21,859 33,869 12,010 54.9% 9000.108 Allocations Internal Rental Charges 43,949 9000.109 Allocations 800 MHz Radios 114,333 54,620 103,840 49,220 90.1 9000.110 Allocations Risk Management 264,431 264,431 9500.630 Transfers Out Risk Management 200,679 200,679 200,679 200,679) 100.0% 9500.640 Transfers Out Employee Benefits 9500.660 Transfers Out Resource Planning 30,398 9950.100 Grant and Award Fiscal Agent Pass-through Federi 13,950 Total Expenditures $ 2,435,647 $ 2,534,526 $ 2,232,822 $ 2,068,989 $ (163,833 2012/2013 Bienniel Budget, City of Plymouth, MN 48 of 138 7/22/2011 2012/2013 Bienniel Budget, City of Plymouth, MN 49 of 138 7/22/2011 City of Plymouth General Fund Revenue Budget Police - Patrol Division 2011-2012 Account Number Account Description 2009 Actual 2010 Actual 2011 Amended 2012 Proposed Change % Change 4200 Intergovern- Federal- Operating 2,422 $ 8,692 $ 4,400 1,600 2,800) -63.6% 4230 Intergovern mental - State- Operatng 2,695 8,618 4,300 1,600 2,700) -62.8% 4230.104 Intergovern menta l- State- Operatng Disabled Officer Reimbursement 10,000 10,000 4350.104 General Services Police Services 95,000 95,000 4360.105 Items for Resale Caps and apparel 42 4410 Court Fines 1,335 (335) 4800 Other Revenues 1,330 76 4807 Refunds Et Reimbursements 372 - - Total Revenues $ 8,154 $ 17,093 $ 8,700 108,200 99,500 2012/2013 Bienniel Budget, City of Plymouth, MN 49 of 138 7/22/2011 Account Number Description 6000 Salaries 6000.100 Salaries Regular 6000.300 Salaries Court Time 6020 Overtime 6020.100 Overtime Regular 6020.200 Overtime Court Time 6020.300 Overtime Holiday 6020.400 Overtime Contractual 6050 Benefits 6050.100 Benefits Social Security 6050.101 Benefits Medicare 6050.200 Benefits PERA 6050.201 Benefits Deferred Compensation 6050.302 Benefits Unemployment 6050.500 Benefits Clothing Allowance 6050.700 Benefits Disabled Officer 6060 Medical Insurance 6060.100 Medical Insurance Employer Contribution 6070 Dental Insurance 6070.100 Dental Insurance Employer Contribution 6080 Group Life Insurance 6080.100 Group Life Insurance Employer Contribution 6100 Office Supplies 6120.106 Operating Supplies Ammunition 6120.121 Operating Supplies SWAT Team 6120.126 Operating Supplies K9 Unit 6140 Miscellaneous Supplies 6140.100 Miscellaneous Supplies Medical 6140.101 Miscellaneous Supplies Uniforms 6140.102 Miscellaneous Supplies Safety Equipment 2012/2013 Bienniel Budget, City of Plymouth, MN City of Plymouth General Fund Expenditure Budget Police - Patrol Division 2011-2012 2011 2012 2009 Actual 2010 Actual Amended Proposed $ Change % Change 112,912 3,473,585 3,347,476 3,448,154 3,620,267 172,113 5.0% 15,277 7,034 7,500 7,500 5,097 108,547 98,863 146,000 120,000 26, 000) 17.8% 15,198 8,586 29,880 15,000 14,880) 49.8% 28,388 26,479 6,750 27,000 20,250 300.0% 26,935 35,258 36,000 36,000 35,048 510,124 535,630 25,506 5.0% 25,760 138 10,188 10,188 48,612 44,746 48,386 55,474 7,088 14.6% 599,735 490,312 494,586 550,910 56,324 11.4% 1,183 23,010 39,563 16,775 17,000 225 1.3% 23,860 23,860 465,838 277,221 195,398 17,385 9,628 6,759 8,627 5,235 3,396 8,714 8,714 196 14,851 18,778 17,500 19,500 2,000 11.4% 14,450 19,840 16,500 16,500 5,852 6,428 6,250 6,250 103 2,908 3,517 3,500 3,500 3,085 1,428 5,000 5,000 7,851 20,269 23,400 23,400 50 of 138 7/22/2011 Account Number Description City of Plymouth General Fund Expenditure Budget Police - Patrol Division 2011-2012 2011 2012 2009 Actual 2010 Actual Amended Proposed $ Change % Change 6500.100 Employee Development Employee Training 1,691 1,098 4,598 4,598 6600 Meetings 161 296 750 750 6700 Dues and Subscriptions 165 30 30 7000 Professional Services 771 975 1,000 1,000 7006 Medical Fees 142 7500 Repair and Maintenance Services 319 7500.202 Repair and Maintenance Services Equipment Maini 82,770 75,851 84,220 84,220 7600 Rentals 2,749 1,594 7,100 2,100 5,000) 8000 Non -Cap Equip (< 5K) 6,202 5,753 5,000 6,500 1,500 9000.101 Allocations Information Technology 192,622 192,622 192,622 265,987 73,365 9000.102 Allocations Facilities Management 173,849 180,751 183,051 216,443 33,392 9000.104 Allocations Mobile Phone 22,371 22,371) 9000.107 Allocations Central Equipment 269,134 290,397 255,137 35,260) 9000.108 Allocations Internal Rental Charges 212,646 9000.110 Allocations Risk Management 9500.660 Transfers Out Resource Planning 18,000 70,000 35,000 35,000) 9901 Care of Prisoners 45,587 27,644 50,000 45,000 5,000) 9902 Booking of Prisoners 39,074 42,033 45,000 50,000 5,000 Total Expenditures $ 5,684,021 $ 5,617,264 5,737,658 6,068,458 $ 330,800 70.4% 30.0% 38.1 18.2% 100.0% 12.1 50.0% 10.0% 11.1% 2012/2013 Bienniel Budget, City of Plymouth, MN 51 of 138 7/22/2011 City of Plymouth General Fund Revenue Budget Police - Support Division 2011-2012 Account 2012 Number Account Description 2009 Actual 2010 Actual 2011 Amended Proposed $ Change % Change 4360.103 Items for Resale Amberstick $ $ 488 $ 525 $ 525 $ 4360.105 Items for Resale Caps and apparel 305 - - Total Revenues $ $ 793 $ 525 $ 525 $ 2012/2013 Bienniel Budget, City of Plymouth, MN 52 of 138 7/22/2011 City of Plymouth General Fund Expenditure Budget Police - Support Division 2011-2012 Account 2011 Number Description 2009 Actual 2010 Actual Amended 2012 Proposed Change Change 6000 Salaries 22,746 6000.100 Salaries Regular 1,369,170 1,393,388 1,495,290 1,606,156 110,866 7.4% 6000.200 Salaries Temporary 5,939 6000.300 Salaries Court Time 1,738 1,216 6020 Overtime 97 6020.100 Overtime Regular 12,792 8,393 23,000 23,000 6020.200 Overtime Court Time 1,472 501 500 500 6020.300 Overtime Holiday 1,968 1,199 1,000 1,000 6020.400 Overtime Contractual 8,180 10,066 10,000 10,000 6050 Benefits 7,158 174,586 183,315 8,729 5.0% 6050.100 Benefits Social Security 15,716 2,291 3,810 4,905 1,095 28.7% 6050.101 Benefits Medicare 19,150 19,803 22,140 23,790 1,650 7.5% 6050.200 Benefits PERA 218,687 196,812 212,630 236,254 23,624 11.1% 6050.201 Benefits Deferred Compensation 798 808 830 830 6050.300 Benefits Life 6050.301 Benefits Long Term Disability 6050.302 Benefits Unemployment 6050.303 Benefits Workers Compensation 6050.400 Benefits Dept'l Insurance Allocation 6050.500 Benefits Clothing Allowance 6,326 15,588 8,180 8,200 20 0.2% 6050.550 Benefits Cell Phone Allowance 6050.700 Benefits Disabled Officer 6060 Medical Insurance 155,690 109,150 6060.100 Medical Insurance Employer Contribution 68,086 6070 Dental Insurance 6,598 5,650 6070.100 Dental Insurance Employer Contribution 2,835 6080 Group Life Insurance 3,084 1,902 6080.100 Group Life Insurance Employer Contribution 1,165 3,350 3,350 6120 Operating Supplies 8 2012/2013 Bienniel Budget, City of Plymouth, MN 53 of 138 7/22/2011 Account Number City of Plymouth General Fund Expenditure Budget Police - Support Division 2011 Description 2009 Actual 2010 Actual Amended 2012 Proposed 2011-2012 Change % Change 6120.100 Operating Supplies Photography 129 6120.101 Operating Supplies Public Education 8t Outreach Prj 32 80 2,000 500 1,500) 75.0% 6120.109 Operating Supplies Community Education 12,409 10,058 14,000 14,000 6120.110 Operating Supplies DARE Program 13,862 14,421 14,000 14,000 6120.117 Operating Supplies CFMH Program 1,641 1,406 2,000 2,000 6120.120 Operating Supplies McGruff Truck Program 870 1,000 1,000 6120.123 Operating Supplies Explorer Program 6,507 6140 Miscellaneous Supplies 5 600 600 6140.104 Miscellaneous Supplies Chaplain/Sr Corp 600 600 6500 Employee Development 58 6500.100 Employee Development Employee Training 2,607 2,140 7,361 7,361 6500.104 Employee Development Conferences Et Seminars 309 6700 Dues and Subscriptions 95 245 250 250 7000 Professional Services 9,105 9,388 10,500 11,150 650 6.2% 7500.202 Repair and Maintenance Services Equipment Maintenance 565 1,629 1,500 1,500 7600 Rentals 1,106 4,028 7600.100 Rentals Portable Toilets 7600.101 Rentals SIU Vehicles 5,000 5,000 8000 Non-Cap Equip (< 5K) 3,355 2,650 2,500 2,500) 100.0% 9000.101 Allocations Information Technology 64,479 64,479 64,479 94,769 30,290 47.0% 9000.102 Allocations Facilities Management 84,396 72,244 96,326 144,537 48,211 50.0% 9000.104 Allocations Mobile Phone 5,109 5,109) 100.0% 9000.107 Allocations Central Equipment 75,068 42,303 110,994 68,691 162.4% 9000.108 Allocations Internal Rental Charges 173,364 9000.109 Allocations 800 MHz Radios 9000.110 Allocations Risk Management 2012/2013 Bienniel Budget, City of Plymouth, MN 54 of 138 7/22/2011 City of Plymouth General Fund Expenditure Budget Police - Support Division 2011-2012 Account 2011 Number Description 2009 Actual 2010 Actual Amended 2012 Proposed $ Change % Change Total Expenditures $ 2,202,081 $ 2,126,817 $ 2,207,144 $ 2,509,561 $ 302,417 2012/2013 Bienniel Budget, City of Plymouth, MN 55 of 138 7/22/2011 Account Number Account Description City of Plymouth General Fund Revenue Budget Police - Emergency Management Division 2012-2013 2009 Actual 2010 Actual 2011 Amended 2012 Proposed $ Change % Change 4900.660 Transfers In Resource Planning $ $ - $ $ 5,000 $ 5,000 4360.115 Items for Resale Weather Radios 8,499 - - Total Revenues $ $ 8,499 $ $ 5,000 $ 5,000 2012/2013 Bienniel Budget, City of Plymouth, MN 56 of 138 7/22/2011 Account Number City of Plymouth General Fund Expenditure Budget Police - Emergency Management Division 2011 Description 2009 Actual 2010 Actual Amended 2012 Proposed 2012-2013 Change % Change 6000.100 Salaries Regular $ 12,835 6020 Overtime 36 6020.100 Overtime Regular 1,454 3,000 3,000) -100.0% 6050 Benefits 15 6050.101 Benefits Medicare 271 20 40 40) -100.0% 6050.200 Benefits PERA 4,652 205 6050.500 Benefits Clothing Allowance 175 6060 Medical Insurance 2,018 6060.100 Medical Insurance Employer Contribution 195 6070.100 Dental Insurance Employer Contribution 10 6080 Group Life Insurance 104 6080.100 Group Life Insurance Employer Contribution 3 6100 Office Supplies 647 486 500 500 6120.101 Operating Supplies Public Education Et Outreach Prj 156 600 600 6120.127 Operating Supplies Weather Radios 8,351 6500.100 Employee Development Employee Training 74 6500.104 Employee Development Conferences Et Seminars 3,812 2,031 3,540 3,540 6600 Meetings 60 500 500 6700 Dues and Subscriptions 95 300 440 440 7000 Professional Services 4,979 5,406 6,500 6,500 7400.108 Utilities Electric 716 674 850 1,000 150 17.6% 7500 Repair and Maintenance Services 2,505 7500.202 Repair and Maintenance Services Equipment Maintenance 5,741 11,673 10,500 10,500 8000 Non-Cap Equip (< 5K) 1,719 801 2,500 5,000 2,500 100.0% 8000.100 Non-Cap Equip (< 5K) CERT 556 9000.101 Allocations Information Technology 2,040 2,040 2,040 12,063 10,023 491.3% 9000.102 Allocations Facilities Management 11,612 6,073 4,227 3,504 723) -17.1% 2012/2013 Bienniel Budget, City of Plymouth, MN 57 of 138 7/22/2011 City of Plymouth General Fund Expenditure Budget Police - Emergency Management Division 2012-2013 Account 2011 Number Description 2009 Actual 2010 Actual Amended 2012 Proposed $ Change % Change 9000.110 Allocations Risk Management - - - - - 9500.660 Transfers Out Resource Planning 5,000 5,000 5,000 - (5,000) -100.0% Total Expenditures $ 59,551 $ 44,989 $ 40,237 $ 44,147 $ 3,910 2012/2013 Bienniel Budget, City of Plymouth, MN 58 of 138 7/22/2011 Account Number Account Description City of Plymouth General Fund Revenue Budget Fire - Operations Division 2011-2012 2009 Actual 2010 Actual 2011 Amended 2012 Proposed $ Change % Change 4230 Intergovernmental- State- Operatng $ 3,814 $ 4230.105 Intergovernmenta l- State- Operatng Fire State Aid 305,859 315,510 350,000 315,000 (35,000) 4240 Intergovernmental -State -Capital 2,000 4350.102 General Services Alarm Fees 4,100 1,600 3,000 3,000 4600 Contributions - Operating 250 4620 Contributions - Capital 13,995 800 4360.100 Items for Resale Car seat 4,250 14,922 14,000 141000 - 4360.101 Items for Resale Helmets 1,093 8,875 8,500 900 1,100 4360.102 Items for Resale Carbon monoxide detector 925 6,848 6,000 61000 - 4800 Other Revenues 65,197 Total Revenues $ 397,668 $ 352,369 $ 381,500 $ 347,600 $ (33,900) 10.0% 12.9% 2012/2013 Bienniel Budget, City of Plymouth, MN 59 of 138 7/22/2011 Account Number City of Plymouth General Fund Expenditure Budget Fire - Operations Division 2011 Description 2009 Actual 2010 Actual Amended 2012 Proposed 2011-2012 Change % Change 6000 Salaries 11,131 $ 1,675 1,675 6000.100 Salaries Regular 288,780 298,127 315,580 348,650 33,070 10.5% 6000.200 Salaries Temporary 186,550 202,039 180,000 206,795 26,795 14.9% 6050 Benefits 2,679 33,381 35,050 1,669 5.0% 6050.100 Benefits Social Security 19,648 17,208 12,110 19,670 7,560 62.4% 6050.101 Benefits Medicare 6,906 7,142 7,260 8,075 815 11.2% 6050.200 Benefits PERA 46,627 35,719 39,180 42,320 3,140 8.0% 6050.201 Benefits Deferred Compensation 4,372 4,816 4,850 4,850 6050.302 Benefits Unemployment 1,287) 6060 Medical Insurance 26,223 17,268 6060.100 Medical Insurance Employer Contribution 9,953 6070 Dental Insurance 2,967 1,869 6070.100 Dental Insurance Employer Contribution 1,364 6080 Group Life Insurance 1,093 724 6080.100 Group Life Insurance Employer Contribution 466 1,230 1,270 40 3.3% 6100 Office Supplies 1,843 1,619 3,400 2,500 900) 26.5% 6100.100 Office Supplies Coffee and Cups 103 6120 Operating Supplies 103 156 6120.100 Operating Supplies Photography 230 380 500 300 200) 40.0% 6120.101 Operating Supplies Public Education Et Outreach Prj 73,164 40,110 44,500 44,500 6120.103 Operating Supplies Janitorial 712 64 900 600 300) 33.3% 6120.105 Operating Supplies Fire Fighting 14,813 6,054 16,000 16,000 6130 Repair Et Maintenance Supplies 1,804 6130.100 Repair Et Maintenance Supplies Equipment Parts 7,439 4,206 10,000 8,000 2,000) 20.0% 6130.111 Repair Et Maintenance Supplies Chemicals 2,038 3,562 3,400 3,400 6130.119 Repair Et Maintenance Supplies Recharges 400 300 100) 25.0% 6140.101 Miscellaneous Supplies Uniforms 6,619 6,036 8,100 8,100 6140.102 Miscellaneous Supplies Safety Equipment 34,610 25,649 40,500 40,500 6500 Employee Development 1,502 926 2012/2013 Bienniel Budget, City of Plymouth, MN 60 of 138 7/22/2011 Account Number City of Plymouth General Fund Expenditure Budget Fire - Operations Division 2011 Description 2009 Actual 2010 Actual Amended 2012 Proposed 2011-2012 Change % Change 6500.100 Employee Development Employee Training 7,908 10,605 12,090 14,000 1,910 15.8% 6500.103 Employee Development Employee Recognition 2,543 972 1,800 1,800 6500.104 Employee Development Conferences Et Seminars 1,580 636 2,000 2,000 6550 Mileage Et Parking Reimbursement 1,003 146 400 400 6600 Meetings 482 655 6700 Dues and Subscriptions 1,094 981 1,000 1,000 7000 Professional Services 7,748 2,635 9,200 9,200 7006 Medical Fees 8,908 7,369 12,000 12,000) 100.0% 7007 Drug and Alcohol Testing 65 7100.100 Communications Postage 1,713 1,211 1,200 2,100 900 75.0% 7200 Printing and Publishing 744 191 500 300 200) 40.0% 7400.102 Utilities Natural Gas 22,485 20,465 30,349 25,000 5,349) 17.6% 7400.103 Utilities Water and Sewer 6,471 6,918 5,054 7,109 2,055 40.7% 7400.104 Utilities Solid Waste 1,395 1,395) 100.0% 7400.108 Utilities Electric 27,130 27,359 26,504 30,000 3,496 13.2% 7500.129 Repair and Maintenance Services Static Testing 3,845 4,406 6,900 6,900 7500.202 Repair and Maintenance Services Equipment Maintenance 47,871 46,980 66,400 66,400 7500.203 Repair and Maintenance Services Turn Out Gear Repair 2,371 8000 Non-Cap Equip (< 5K) 19,743 5,406 24,000 24,000 8100.500 Capital Outlay (> 5K) Machinery and Equipment 14,091 10,000 10,000) 100.0% 9000.100 Allocations Photocopying 5,083 7,700 7,758 7,758) 100.0% 9000.101 Allocations Information Technology 46,590 46,590 46,590 78,218 31,628 67.9% 9000.102 Allocations Facilities Management 126,757 249,618 290,571 218,958 71,613) 24.6% 9000.104 Allocations Mobile Phone 5,656 4,208 4,638 4,638) 100.0% 9000.105 Allocations Security 3,909 3,909 3,909 3,909) 100.0% 9000.106 Allocations Telephone 12,621 12,621 12,621 12,621) 100.0% 9000.107 Allocations Central Equipment 338,033 348,194 367,984 19,790 5.7% 2012/2013 Bienniel Budget, City of Plymouth, MN 61 of 138 7/22/2011 City of Plymouth General Fund Expenditure Budget Fire - Operations Division Account 2011 2012 Number Description 2009 Actual 2010 Actual Amended Proposed 9000.108 Allocations Internal Rental Charges 307,547 9000.109 Allocations 800 MHz Radios 71,333 34,760 64,786 9000.110 Allocations Risk Management 102,671 9500.630 Transfers Out Risk Management 34,436 34,436 34,436 9500.660 Transfers Out Resource Planning 17,000 70,000 70,000 70,000 9906 Donations Ft Contributions 305,859 318,977 350,000 315,000 Total Expenditures 1,767,741 $ 1,995,997 2,135,560 2,200,381 $ 2011-2012 Change % Change 30,026 86.4% 102,671 34,436) -100.0% 35,000) -10.0% 64,821 2012/2013 Bienniel Budget, City of Plymouth, MN 62 of 138 7/22/2011 Account Number Account Description City of Plymouth General Fund Revenue Budget Fire - RAD Division 2011-2012 2009 Actual 2010 Actual 2011 Amended 2012 Proposed $ Change % Change 4230.200 Intergovernmental -State -Operatng Haz Mat Grant 61,105 74,295 69,490 78,700 9,210 Total Revenues 61,105 74,295 69,490 78,700 9,210 13.3% 2012/2013 Bienniel Budget, City of Plymouth, MN 63 of 138 7/22/2011 City of Plymouth General Fund Expenditure Budget Account Number Description Fire -RAD 2009 Actual Division 2011 2010 Actual Amended 2012 Proposed 2011-2012 Change % Change 6000 Salaries 472 6000.100 Salaries Regular 13,633 13,716 7,270 7,270) 100.0% 6000.200 Salaries Temporary 4,494 5,628 6050 Benefits 124 670 670) 100.0% 6050.100 Benefits Social Security 406 349 6050.101 Benefits Medicare 266 287 110 110) 100.0% 6050.200 Benefits PERA 1,872 1,936 1,050 1,050) 100.0% 6050.201 Benefits Deferred Compensation 397 415 210 210) 100.0% 6060 Medical Insurance 428 279 6060.100 Medical Insurance Employer Contribution 173 6070 Dental Insurance 174 111 6070.100 Dental Insurance Employer Contribution 69 6080 Group Life Insurance 69 47 6080.100 Group Life Insurance Employer Contribution 30 40 40) 100.0% 6120.105 Operating Supplies Fire Fighting 3,143 1,734 3,090 3,000 90) 2.9% 6130.100 Repair Et Maintenance Supplies Equipment Parts 675 6140.101 Miscellaneous Supplies Uniforms 1,707 6140.102 Miscellaneous Supplies Safety Equipment 12,127 6500.100 Employee Development Employee Training 275 2,765 15,000 12,235 442.5% 6600 Meetings 152 7100.104 Communications Mobile Telephone 5,022 13,729 15,000 1,271 9.3% 7500.202 Repair and Maintenance Services Equipment 2,344 1,026 Maintenance 9000.107 Allocations Central Equipment 30,475 32,424 32,016 408) 1.3% 9000.108 Allocations Internal Rental Charges 24,627 Total Expenditures 54,388 74,295 61,358 65,016 3,658 2012/2013 Bienniel Budget, City of Plymouth, MN 64 of 138 7/22/2011 City of Plymouth General Fund Expenditure Budget Fire - Duty Crew Division Account Number Description 2009 Actual 2010 Actual 2011 Amended 2012 Proposed 2011-2012 Change % Change 6000 Salaries 8,360 600 600 6000.100 Salaries Regular 198,325 179,773 183,150 184,060 910 0.5% 6000.200 Salaries Temporary 266,159 272,795 280,000 284,135 4,135 1.5% 6020.100 Overtime Regular 250 250) 100.0% 6050 Benefits 1,407 18,260 30,723 12,463 68.3% 6050.100 Benefits Social Security 18,792 16,916 6,620 17,490 10,870 164.2% 6050.101 Benefits Medicare 6,479 6,503 6,770 6,800 30 0.4% 6050.200 Benefits PERA 28,009 25,349 26,370 26,505 135 0.5% 6050.201 Benefits Deferred Compensation 4,095 4,148 4,240 4,240 6060 Medical Insurance 14,211 9,341 6060.100 Medical Insurance Employer Contribution 5,776 6070 Dental Insurance 1,393 871 6070.100 Dental Insurance Employer Contribution 540 6080 Group Life Insurance 210 122 6080.100 Group Life Insurance Employer Contribution 75 230 230 Total Expenditures 537,674 531,974 525,890 554,783 28,893 2012/2013 Bienniel Budget, City of Plymouth, MN 65 of 138 7/22/2011 City of Plymouth General Fund Revenue Budget Public Works - Street Maintenance Division Account 2012 Number Account Description 2009 Actual 2010 Actual 2011 Amended Proposed 2011-2012 Change % Change 4230.102 Intergovernmental- State- Operatng MSA Maintenance $ 300,000 $ 300,000 637,677 $ 337,677 4300 Charges for Services 1,363 4330.500 Utility Charges Street Lighting 523,076 593,038 600,000 625,000 25,000 4330.800 Utility Charges Penalties 6,000 6,399 6,000 6,000 - 4350.113 General Services Grave Openings 430 30 4350.119 General Services Antennae Charges 0) 1,912 4350.123 General Services Application Fees 175 4900.640 Transfers In Employee Benefits Total Revenues $ 531,044 $ 901,379 $ 906,000 1,268,677 $ 362,677 112.6% 4.2% 2012/2013 Bienniel Budget, City of Plymouth, MN 66 of 138 7/22/2011 City of Plymouth General Fund Expenditure Budget Public Works - Street Maintenance Division 2011-2012 Account 2011 Number Description 2009 Actual 2010 Actual Amended 2012 Proposed Change % Change 6000 Salaries 25,284 $ 6000.100 Salaries Regular 682,793 660,061 695,900 697,459 1,559 0.2% 6000.200 Salaries Temporary 10,112 14,000 14,000 6020 Overtime 2,728 6020.100 Overtime Regular 28,059 55,748 30,000 46,000 16,000 53.3% 6050 Benefits 7,247 133,113 139,769 6,656 5.0% 6050.100 Benefits Social Security 48,389 42,441 45,470 46,975 1,505 3.3% 6050.101 Benefits Medicare 9,879 9,926 10,630 10,990 360 3.4% 6050.200 Benefits PERA 56,409 50,086 50,460 54,920 4,460 8.8% 6050.201 Benefits Deferred Compensation 7,400 6,994 7,410 7,410 6050.300 Benefits Life 6050.302 Benefits Unemployment 6050.303 Benefits Workers Compensation 6050.400 Benefits Dept'[ Insurance Allocation 6060 Medical Insurance 110,428 70,469 6060.100 Medical Insurance Employer Contribution 44,082 6070 Dental Insurance 4,586 2,661 6070.100 Dental Insurance Employer Contribution 1,672 6080 Group Life Insurance 1,322 815 6080.100 Group Life Insurance Employer Contribution 541 1,370 1,370 6100 Office Supplies 145 447 650 650 6100.100 Office Supplies Coffee and Cups 40 6130 Repair Et Maintenance Supplies 8 6130.100 Repair Et Maintenance Supplies Equipment Parts 4,107 2,575 4,500 4,500 6130.101 Repair Et Maintenance Supplies Horticulture 477 1,235 3,000 3,000 6130.102 Repair Et Maintenance Supplies Traffic and Park Si 28,190 14,511 26,000 50,000 24,000 92.3% 6130.104 Repair Et Maintenance Supplies Sand and Gravel 2,419 11,095 30,000 30,000 6130.105 Repair Et Maintenance Supplies Paint 2,616 43 2,000 2,000 6130.106 Repair Et Maintenance Supplies Lumber 400 400 2012/2013 Bienniel Budget, City of Plymouth, MN 67 of 138 7/22/2011 2012/2013 Bienniel Budget, City of Plymouth, MN 68 of 138 7/22/2011 City of Plymouth General Fund Expenditure Budget Public Works - Street Maintenance Division 2011-2012 Account 2011 Number Description 2009 Actual 2010 Actual Amended 2012 Proposed Change Change 6130.107 Repair it Maintenance Supplies Concrete and Asph 450,755 499,024 460,000 480,000 20,000 4.3% 6130.108 Repair it Maintenance Supplies Concrete Disposal 1,000 1,000 6130.111 Repair 8t Maintenance Supplies Chemicals 172,527 272,932 250,000 290,000 40,000 16.0% 6130.120 Repair &t Maintenance Supplies Mailbox Repairs 3,846 5,905 3,000 6,000 3,000 100.0% 6130.121 Repair >:t Maintenance Supplies Sprinkler Head Rer 564 225 1,500 1,500 6140.100 Miscellaneous Supplies Medical 6140.101 Miscellaneous Supplies Uniforms 6140.102 Miscellaneous Supplies Safety Equipment 5,828 4,941 5,300 5,400 100 1.9% 6500 Employee Development 7 50 1,500 1,500 6500.100 Employee Development Employee Training 2,464 2,779 2,800 2,800 6500.104 Employee Development Conferences 8t Seminars 6550 Mileage &t Parking Reimbursement 13 6700 Dues and Subscriptions 105 1,504 250 250 7000 Professional Services 546 5,318 25,000 25,000) 100.0% 7002 Internal Engineer 7003 Legal 7006 Medical Fees 191 500 500) 100.0% 7017 Laundry Services 5,341 5,013 6,100 6,100 7019 Street Evaluation 7100.100 Communications Postage 151 157 100 160 60 60.0% 7100.104 Communications Mobile Telephone 7200 Printing and Publishing 446 227 600 500 100) 16.7% 7400.100 Utilities Street Lights 635,254 602,006 630,977 603,000 27,977) 4.4% 7400.101 Utilities Traffic Lights 45,084 41,952 75,000 42,000 33,000) 44.0% 7400.102 Utilities Natural Gas 14,482 12,028 20,000 15,000 5,000) 25.0% 7400.104 Utilities Solid Waste 500 500) 100.0% 7400.108 Utilities Electric 37,972 37,564 38,000 40,000 2,000 5.3% 7500.108 Repair and Maintenance Services Snow Plowing 206,182 241,367 240,000 250,000 10,000 4.2% 7500.109 Repair and Maintenance Services Seal Coating 352,543 331,483 200,000 200,000 2012/2013 Bienniel Budget, City of Plymouth, MN 68 of 138 7/22/2011 City of Plymouth General Fund Expenditure Budget Public Works - Street Maintenance Division 2011-2012 Account 2011 Number Description 2009 Actual 2010 Actual Amended 2012 Proposed Change Change 7500.110 Repair and Maintenance Services Street Striping 59,662 80,000 110,000 30,000 37.5% 7500.111 Repair and Maintenance Services Street Cleaning 581 7500.113 Repair and Maintenance Services Curb Raising E C 7500.114 Repair and Maintenance Services Retaining Walls 1,743 2,173 5,000 5,000 7500.126 Repair and Maintenance Services Guard Rail/Fend 30 10,000 10,200 200 2.0% 7500.133 Repair and Maintenance Services Millennium Gard 7500.134 Repair and Maintenance Services Crack Sealing 126,474 119,663 130,000 200,000 70,000 53.8% 7500.140 Repair and Maintenance Services Traffic Signals 294 12,338 32,000 32,000 7500.202 Repair and Maintenance Services Equipment Maint 56,737 14,605 7600 Rentals 19,242 30,420 35,000 36,000 1,000 2.9% 8000 Non-Cap Equip (< 5K) 2,576 2,927 3,500 10,740 7,240 206.9% 8100.500 Capital Outlay (> 5K) Machinery and Equipment 5,200 11,100 5,900 113.5% 8100.800 Capital Outlay (> 5K) Construction Projects 9000.100 Allocations Photocopying 9000.101 Allocations Information Technology 49,258 49,258 49,258 16,407 32,851) 66.7% 9000.102 Allocations Facilities Management 15,085 43,349 52,771 37,417 15,354) 29.1% 9000.104 Allocations Mobile Phone 4,374 3,822 3,822) 100.0% 9000.105 Allocations Security 9000.106 Allocations Telephone 9000.107 Allocations Central Equipment 579,847 637,939 700,000 62,061 9.7% 9000.108 Allocations Internal Rental Charges 431,571 9000.110 Allocations Risk Management 55,161 55,161 9500.412 Transfers Out Utility Trunk Replacement 9500.413 Transfers Out Improvement Project Construction 9500.600 Transfers Out Central Equipment 9,541 9500.630 Transfers Out Risk Management 9500.640 Transfers Out Employee Benefits 9900 Miscellaneous 34 9920 Bank Fees 4,744 3,721 5,130 5,130 2012/2013 Bienniel Budget, City of Plymouth, MN 69 of 138 7/22/2011 City of Plymouth General Fund Expenditure Budget Public Works - Street Maintenance Division 2011-2012 Account 2011 Number Description 2009 Actual 2010 Actual Amended 2012 Proposed $ Change % Change Total Expenditures $ 3,639,401 $ 4,007,663 $ 4,020,650 $ 4,283,808 $ 263,158 2012/2013 Bienniel Budget, City of Plymouth, MN 70 of 138 7/22/2011 City of Plymouth General Fund Revenue Budget Public Works - Engineering Division 2011-2012 Account 2012 Number Account Description 2009 Actual 2010 Actual 2011 Amended Proposed $ Change % Change 4200 Intergovern- Federal - Operating $ 23,183 5,000 $ 4290 Intergovernmental -Other 4350.109 General Services Engineering Services 14,868 169,826 4350.128 General Services Vacations 1,350 3,000 3,000 4380.301 Allocation Charges Engineering 70,586 418,218 380,000 300,000 (80,000) 4800 Other Revenues 500 1,200 1,200 - 4801 Administrative Fee 4900.413 Transfers In Inprovement Project Construction 214,719 4900.420 Transfers In Water Sewer Construction 661 4900.421 Transfers In Enterprise - Other Construction 7,492 4900.510 Transfers In Water Resources 569 4900.650 Transfers In Design Engineering 198,794 Total Revenues $ 108,637 1,017,130 $ 381,200 $ 304,200 $ (77,000) 21.1% 2012/2013 Bienniel Budget, City of Plymouth, MN 71 of 138 7/22/2011 City of Plymouth General Fund Expenditure Budget Public Works - Engineering Division 2011-2012 Account 2011 Number Description 2009 Actual 2010 Actual Amended 2012 Proposed Change Change 6000 Salaries 12,502 $ 6000.100 Salaries Regular 218,039 569,378 737,960 642,650 95,310) 12.9% 6000.200 Salaries Temporary 6,431 8,000 20,000 12,000 150.0% 6020.100 Overtime Regular 305 22,422 13,000 17,500 4,500 34.6% 6050 Benefits 4,005 58,460 61,383 2,923 5.0% 6050.100 Benefits Social Security 14,478 36,798 47,090 42,169 4,921) 10.5% 6050.101 Benefits Medicare 3,237 8,847 11,190 9,862 1,328) 11.9% 6050.200 Benefits PERA 16,022 41,331 53,520 47,861 5,659) 10.6% 6050.201 Benefits Deferred Compensation 4,592 10,996 13,600 13,600 6050.300 Benefits Life 6050.302 Benefits Unemployment 6,435 15,000 15,000 6050.303 Benefits Workers Compensation 6050.400 Benefits Dept'[ Insurance Allocation 6050.550 Benefits Cell Phone Allowance 6060 Medical Insurance 19,882 22,106 6060.100 Medical Insurance Employer Contribution 37,839 6070 Dental Insurance 2,245 1,744 6070.100 Dental Insurance Employer Contribution 4,060 6080 Group Life Insurance 626 746 6080.100 Group Life Insurance Employer Contribution 1,073 2,040 2,040 6100 Office Supplies 1,512 1,814 3,420 2,800 620) 18.1% 6120 Operating Supplies 38 6120.100 Operating Supplies Photography 6120.112 Operating Supplies Survey 896 1,400 1,400 6130 Repair Et Maintenance Supplies 486 6130.100 Repair Et Maintenance Supplies Equipment Parts - 9 6500 Employee Development 305 580 6500.100 Employee Development Employee Training 2,819 2,922 4,550 4,300 250) 5.5% 6500.104 Employee Development Conferences Et Seminars 1,210 500 750 250 50.0% 2012/2013 Bienniel Budget, City of Plymouth, MN 72 of 138 7/22/2011 2012/2013 Bienniel Budget, City of Plymouth, MN 73 of 138 7/22/2011 City of Plymouth General Fund Expenditure Budget Public Works Engineering Division 2011-2012 Account 2011 Number Description 2009 Actual 2010 Actual Amended 2012 Proposed Change Change 6550 Mileage Et Parking Reimbursement 105 23 200 150 50) 25.0% 6700 Dues and Subscriptions 89 138 2,700 2,500 200) 7.4% 7000 Professional Services 625 625 500 600 100 20.0% 7001 Consulting Engineer 20,363 17,022 22,500 22,000 500) 2.2% 7006 Medical Fees 7100 Communications 3,351 7100.100 Communications Postage 2,464 1,317 2,400 2,400 7100.104 Communications Mobile Telephone 7200 Printing and Publishing 222 597 800 600 200) 25.0% 7500.112 Repair and Maintenance Services Drainway Mainte 7500.202 Repair and Maintenance Services Equipment Maint 300 1,000 700 233.3% 7600 Rentals 497 625 600 25) 4.0% 8000 Non -Cap Equip (< 5K) 4,250 4,250 8100.500 Capital Outlay (> 5K) Machinery and Equipment 8100.800 Capital Outlay (> 5K) Construction Projects 9000.100 Allocations Photocopying 20,344 13,964 14,022 14,022) 100.0% 9000.101 Allocations Information Technology 62,436 82,138 82,138 86,806 4,668 5.7% 9000.102 Allocations Facilities Management 28,800 63,481 70,959 75,114 4,155 5.9% 9000.104 Allocations Mobile Phone 16,717 4,020 3,057 3,057) 100.0% 9000.105 Allocations Security 3,484 3,484 3,484 3,484) 100.0% 9000.106 Allocations Telephone 8,433 10,384 10,384 10,384) 100.0% 9000.107 Allocations Central Equipment 26,918 29,739 30,000 261 0.9% 9000.108 Allocations Internal Rental Charges 8,581 9000.110 Allocations Risk Management 7,425 7,425 9500.412 Transfers Out Utility Trunk Replacement 9500.413 Transfers Out Improvement Project Construction 9500.630 Transfers Out Risk Management 38,877 45,408 45,408 45,408) 100.0% 9500.640 Transfers Out Employee Benefits 9900 Miscellaneous 2,291 2012/2013 Bienniel Budget, City of Plymouth, MN 73 of 138 7/22/2011 City of Plymouth General Fund Expenditure Budget Public Works - Engineering Division 2011-2012 Account 2011 Number Description 2009 Actual 2010 Actual Amended 2012 Proposed $ Change % Change Total Expenditures $ 502,977 $ 1,062,950 $ 1,243,946 $ 1,114,760 $ (129,186) 2012/2013 Bienniel Budget, City of Plymouth, MN 74 of 138 7/22/2011 City of Plymouth Recreation Revenue Budget Account Number Account Description 2009 Actual 2010 Actual 2011 Amended 2012 Proposed 2011-2012 Change % Change 4000.100 Taxes Property 670,772 618,092 618,497 559,480 59,017) 9.5% 4310 Program Fees 100 4310.100 Program Fees Recreation 1,099,573 1,128,324 1,073,711 1,082,355 8,644 0.8% 4310.101 Program Fees Subsidized Recreation 9,310 8,806 9,300 9,300 4320.100 Rental Fees Recreation 22,628 28,996 18,602 18,950 348 1.9% 4350.115 General Services Concession Sales 1,521 1 1) 100.0% 4600 Contributions - Operating 725 4700.100 Interest Income Investments 4,101 1,774 3,426 2,000 1,426) 41.6% 4800 Other Revenues 2,355 2,954 1,300 1,300 4900 Transfers In 29,253 12,071 17,182) 58.7% 4900.240 Transfers In Lawful Gambling 2,012 3,087 3,000 2500 500) 16.7% 4900.403 Transfers In Bldg and Equip Revolving Total Revenues 1,813,097 1,792,033 1,757,090 1,687,956 69,134) 2012/2013 Bienniel Budget, City of Plymouth, MN 75 of 138 7/22/2011 Account Number Description 6000 Salaries 6000.100 Salaries Regular 6000.200 Salaries Temporary 6020.100 Overtime Regular 6050 Benefits 6050.100 Benefits Social Security 6050.101 Benefits Medicare 6050.200 Benefits PERA 6050.201 Benefits Deferred Compensation 6050.302 Benefits Unemployment 6050.303 Benefits Workers Compensation 6060 Medical Insurance 6060.100 Medical Insurance Employer Contribution 6070 Dental Insurance 6070.100 Dental Insurance Employer Contribution 6080 Group Life Insurance 6080.100 Group Life Insurance Employer Contribution 6100 Office Supplies 6100.100 Office Supplies Coffee and Cups 6120 Operating Supplies 6120.125 Operating Supplies Resale 6140 Miscellaneous Supplies 6140.101 Miscellaneous Supplies Uniforms 6500 Employee Development 6500.100 Employee Development Employee Training 6500.104 Employee Development Conferences Et Seminars 6550 Mileage Et Parking Reimbursement 6700 Dues and Subscriptions 7000 Professional Services City of Plymouth Recreation Expenditure Budget 2011-2012 2011 2009 Actual 2010 Actual Amended 2012 Proposed $ Change % Change 452,846 309,885 87 51,750 10,964 41,200 3,199 1,027 53,419 3,900 2,216 278 34,987 1,436 55 16,072 1,383 2,437 323 405 300,080 61 9,299 $ 453,398 461,830 426,430 35,400) 7.7% 293,592 306,410 295,785 10,625) 3.5% 200 200 2,560 62,187 65,296 3,109 5.0% 45,582 47,795 45,773 2,022) 4.2% 10,660 11,154 10,733 421) 3.8% 36,883 33,480 33,330 150) 0.4% 2,781 2,480 2,480 720 2,000 2,000 30 20 10) 33.3% 37,830 24,349 3,087 1,710 1,466 925 2,400 2,400 2,269 3,000 3,000 40,939 42,115 45,330 3,215 7.6% 117 17,883 16,400 19,010 2,610 15.9% 805 2,150 2,300 150 7.0% 2,638 5,350 5,000 350) 6.5% 379 1,300 1,250 50) 3.8% 696 670 820 150 22.4% 293,696 273,455 294,545 21,090 7.7% 2012/2013 Bienniel Budget, City of Plymouth, MN 76 of 138 7/22/2011 City of Plymouth Recreation Expenditure Budget Account Number Description 2009 Actual 2010 Actual 2011 Amended 2012 Proposed 2011-2012 Change % Change 7006 Medical Fees 7050 External Program Registrations 5,708 5,261 6,220 5,670 550) 8.8% 7100 Communications 33 7100.100 Communications Postage 33,412 30,627 36,250 35,400 850) 2.3% 7100.103 Communications Telephone 511 80 1,460 1,460) 100.0% 7100.104 Communications Mobile Telephone 50 1,425 1,375 2750.0% 7200 Printing and Publishing 1,537 3,002 3,100 6,775 3,675 118.5% 7200.101 Printing and Publishing Recreation Handbook 51,214 45,000 45,500 45,500 7600 Rentals 68,162 78,647 92,880 92,120 760) 0.8% 8000 Non -Cap Equip (< 5K) 835 9,100 8,850 250) 2.7% 9000.100 Allocations Photocopying 4,351 4,351 4,351 4,351) 100.0% 9000.101 Allocations Information Technology 69,253 69,253 69,253 46,252 23,001) 33.2% 9000.102 Allocations Facilities Management 15,204 16,015 16,285 16,760 475 2.9% 9000.104 Allocations Mobile Phone 1,398 1,398 1,965 1,965) 100.0% 9000.106 Allocations Telephone 3,069 3,069 3,069 3,069) 100.0% 9000.108 Allocations Internal Rental Charges 10,850 9000.110 Allocations Risk Management 9,323 9,323 9500 Transfers Out 9500.403 Transfers Out Bldg and Equip Revolving 9500.630 Transfers Out Risk Management 26,955 26,955 26,955 26,955) 100.0% 9500.640 Transfers Out Employee Benefits 9500.660 Transfers Out Resource Planning 10,000 12,000 9900 Miscellaneous 497 9903 Scholarships 9,394 8,806 9,300 9,300 9906 Donations Et Contributions 88,504 88,834 88,946 88,504 442) 0.5% 9906.100 Donations it Contributions Music In Plymouth 30,000 30,000 30,000 30,000 9914 Youth Special Events 9917 Bad Debt 9920 Bank Fees 34,875 35,456 40,000 40,000) 100.0% 2012/2013 Bienniel Budget, City of Plymouth, MN 77 of 138 7/22/2011 City of Plymouth Recreation Expenditure Budget 2011-2012 Account 2011 Number Description 2009 Actual 2010 Actual Amended 2012 Proposed $ Change % Change 9920.100 Bank Fees Credit Card Fees - - - 36,375 36,375 Total Expenditures $ 1,752,878 $ 1,743,851 $ 1,757,090 $ 1,687,956 $ (69,134) 2012/2013 Bienniel Budget, City of Plymouth, MN 78 of 138 7/22/2011 City of Plymouth Transit Revenue Budget Account Number Account Description 2009 Actual 2010 Actual 2011 Amended 2012 Proposed 2011-2012 Change % Change 4230 Intergovern mental-State-Operatng 3,508,120 2,651,199 2,425,000 3,088,348 663,348 27.4% 4240 Intergovernmental -State -Capital 230,000 225,000 5,000) 2.2% 4350.120 General Services Transit Fares 1,206,214 1,011,332 1,100,000 1,100,000 4400 General Fines Et Forfeitures 8 4700.100 Interest Income Investments 37,324 15,315 26,321 26,321) 100.0% 4800 Other Revenues 0 4900 Transfers In 551,943 48,515 503,428) 91.2% 4900.640 Transfers In Employee Benefits Total Revenues 4,751,658 3,677,854 4,333,264 4,461,863 128,599 2012/2013 Bienniel Budget, City of Plymouth, MN 79 of 138 7/22/2011 City of Plymouth Transit Expenditure Budget 2011-2012 Account 2011 Number Description 2009 Actual 2010 Actual Amended 2012 Proposed Change Change 6000 Salaries 5,086 6000.100 Salaries Regular 126,106 124,681 129,740 131,437 1,697 1.3% 6020.100 Overtime Regular 500 500 6050 Benefits 1,191 16,601 17,431 830 5.0% 6050.100 Benefits Social Security 8,453 7,415 8,170 8,300 130 1.6% 6050.101 Benefits Medicare 1,749 1,734 1,920 2,000 80 4.2% 6050.200 Benefits PERA 10,036 8,727 9,410 9,700 290 3.1% 6050.201 Benefits Deferred Compensation 1,596 1,616 1,650 1,650 6060 Medical Insurance 13,939 9,143 6060.100 Medical Insurance Employer Contribution 5,675 6070 Dental Insurance 421 263 6070.100 Dental Insurance Employer Contribution 163 6080 Group Life Insurance 369 242 6080.100 Group Life Insurance Employer Contribution 155 400 400 6100 Office Supplies 136 136 500 500 6120 Operating Supplies 164 100 100 6120.101 Operating Supplies Public Education Et Outreach f 500 500 6120.111 Operating Supplies License Plates 6500 Employee Development 6500.100 Employee Development Employee Training 152 300 300 6500.104 Employee Development Conferences Et Seminars 500 500 6550 Mileage Et Parking Reimbursement 229 200 200 6600 Meetings 242 17 300 300 6700 Dues and Subscriptions 16,349 16,145 15,800 23,000 7,200 45.6% 7000 Professional Services 30,496 1,938 30,000 30,000 7003 Legal 1,052 636 1,000 1,000 7006 Medical Fees 7015 Transit Services 3,476,513 3,230,701 3,600,000 3,600,000 7100.100 Communications Postage 151 224 300 450 150 50.0% 2012/2013 Bienniel Budget, City of Plymouth, MN 80 of 138 7/22/2011 City of Plymouth Transit Expenditure Budget Account 2011 Number Description 2009 Actual 2010 Actual Amended 2012 Proposed 7100.103 Communications Telephone 7200 Printing and Publishing 9,626 5,623 7,000 7,000 7400.100 Utilities Street Lights 18,993 17,187 22,000 18,000 7400.102 Utilities Natural Gas 588 513 1,650 1,000 7400.103 Utilities Water and Sewer 1,340 1,302 2,100 1,338 7500 Repair and Maintenance Services 7500.132 Repair and Maintenance Services Transit Facility 71,004 112,962 125,000 133,000 7500.201 Repair and Maintenance Services Departmental So 125,000 7500.202 Repair and Maintenance Services Equipment Maint 6,119 6,402 5,000 5,000 7600 Rentals 47,125 47,371 74,000 55,000 8000 Non -Cap Equip (< 5K) 1,486 8100.200 Capital Outlay (> 5K) Infrastructure 8100.300 Capital Outlay (> 5K) Buildings 8100.400 Capital Outlay (> 5K) Improv Other Than Buildings 8100.500 Capital Outlay (> 5K) Machinery and Equipment 8100.800 Capital Outlay (> 5K) Construction Projects 230,000 233,000 9000.100 Allocations Photocopying 325 332 338 9000.101 Allocations Information Technology 9,881 10,079 10,280 13,714 9000.102 Allocations Facilities Management 3,946 5,813 6,435 7,386 9000.104 Allocations Mobile Phone 808 547 546 9000.105 Allocations Security 7,186 7,330 7,476 9000.106 Allocations Telephone 1,492 1,522 1,552 9000.108 Allocations Internal Rental Charges 68,601 9000.110 Allocations Risk Management 15,522 9500 Transfers Out 9500.100 Transfers Out General 17,911 18,269 18,635 18,635 9500.412 Transfers Out Utility Trunk Replacement 9500.413 Transfers Out Improvement Project Construction 9500.620 Transfers Out Information Technology 2011-2012 Change % Change 4,000) 650) 762) 8,000 125,000 19, 000) 3,000 338) 3,434 951 546) 7,476) 1,552) 15,522 18.2% 39.4% 36.3% 6.4% 25.7% 1.3% 100.0% 33.4% 14.8% 100.0% 100.0% 100.0% 2012/2013 Bienniel Budget, City of Plymouth, MN 81 of 138 7/22/2011 Account Number Description City of Plymouth Transit Expenditure Budget 2011-2012 2011 2009 Actual 2010 Actual Amended 2012 Proposed $ Change % Change 9500.630 Transfers Out Risk Management 4,275 4,361 4,361 9500.640 Transfers Out Employee Benefits - - - - Total Expenditures $ 3,958,693 $ 3,655,664 $ 4,333,264 $ 4,461,863 $ 132,960 2012/2013 Bienniel Budget, City of Plymouth, MN 82 of 138 7/22/2011 City of Plymouth HRA - CDBG Revenue Budget Account 2011-2012 Number Account Description 2009 Actual 2010 Actual 2011 Amended 2012 Proposed Change % Change 4000.100 Taxes Property 11,498 13,492 13,508 21,020 7,512 55.6% 4200.200 Intergovern- Federal - Operating CDBG 138,103 399,592 372,254 338,411 33,843) -9.1% 4200.210 Intergovern- Federal - Operating REHAB Grant Loan Repayment 20,577 10,000 20,000 20,000 4200.211 Intergovern- Federal - Operating FTHB Loan Repayment 125,000 20,000 20,000 4700.100 Interest Income Investments 828 74 508 500 8) -1.6% 4700.300 Interest Income Notes Total Revenues $ 296,006 423,158 $ 426,270 $ 399,931 $ (26,339) 2012/2013 Bienniel Budget, City of Plymouth, MN 83 of 138 7/22/2011 City of Plymouth HRA - CDBG Expenditure Budget Account Number Description 2009 Actual 2010 Actual 2011 Amended 2012 Proposed 2011-2012 Change % Change 6000 Salaries 3,313 6000.100 Salaries Regular 68,740 69,156 64,080 64,074 6) 0.0% 6020.100 Overtime Regular 6050 Benefits 755 8,727 9,163 436 5.0% 6050.100 Benefits Social Security 4,597 3,804 4,073 3,973 100) 2.5% 6050.101 Benefits Medicare 884 890 954 929 25) 2.6% 6050.200 Benefits PERA 5,096 4,841 4,321 4,646 325 7.5% 6050.201 Benefits Deferred Compensation 1,207 1,652 1,652 6050.300 Benefits Life 6050.303 Benefits Workers Compensation 6050.400 Benefits Dept1 Insurance Allocatio 6060 Medical Insurance 7,816 7,415 6060.100 Medical Insurance Employer Contribu 4,044 6070 Dental Insurance 303 6070.100 Dental Insurance Employer Contribut 6080 Group Life Insurance 84 92 90 90) 100.0% 6080.100 Group Life Insurance Employer Contribution 34 100 100 6100 Office Supplies 42 68 500 300 200) 40.0% 6500 Employee Development 85 6500.100 Employee Development Employee Train 1,000 1,000) 100.0% 6500.104 Employee Development Conferences Et 860 2,146 1,785 1,785) 100.0% 6550 Mileage Et Parking Reimbursement 44 66 100 100 6700 Dues and Subscriptions 40 7000 Professional Services 7003 Legal 465 1,873 2,000 1,797 203) 10.2% 7004 Audit Fees 3,264 3,580 4,129 4,000 129) 3.1% 7013 Record Retention 300 300 7100.100 Communications Postage 717 104 1,225 200 1,025) 83.7% 7200 Printing and Publishing 702 36 1,300 200 1,100) 84.6% 2012/2013 Bienniel Budget, City of Plymouth, MN 84 of 138 7/22/2011 City of Plymouth HRA - CDBG Expenditure Budget Account 2011 2012 Number Description 2009 Actual 2010 Actual Amended Proposed 2011-2012 Change % Change 7600 Rentals 9000.100 Allocations Photocopying 376 376 376 376) 9000.101 Allocations Information Technology 5,817 5,817 5,817 7,963 2,146 9000.102 Allocations Facilities Management 3,640 3,988 4,104 4,002 102) 9000.103 Allocations Administrative 9000.104 Allocations Mobile Phone 419 273 273 273) 9000.106 Allocations Telephone 400 400 400 400) 9000.107 Allocations Central Equipment 3,172 1,265 1,265) 9000.108 Allocations Internal Rental Charges 2,190 9000.110 Allocations Risk Management 9,422 9,422 9500 Transfers Out 10 10) 9500.630 Transfers Out Risk Management 1,652 1,652 1,652 1,652) 9500.640 Transfers Out Employee Benefits 9910 Housing Loans 121,844 136,227 123,912 109,156 14,756) 9911 Grant Awards 104,574 131,764 192,125 177,954 14,171) 9919 Administration Fees 99 Total Expenditures 335,954 $ 385,884 $ 426,270 $ 399,931 $ 26,339) 100.0% 36.9% 2.5% 100.0% 100.0% 100.0% 100.0% 100.0% 2012/2013 Bienniel Budget, City of Plymouth, MN 85 of 138 7/22/2011 Account Number Account Description City of Plymouth HRA - Section 8 Revenue Budget 2009 Actual 2010 Actual 2011 Amended 2012 Proposed 2011-2012 Change % Change 4200.100 Intergovern- Federal Operating Section 8 - DHAP 7,450 $ 1,207 $ 4200.101 Intergovern- Federal Operating Section 8 - HUD Direct 1,613,245 1,719,343 1,650,000 1,605,835 44,165) 2.7% 4200.102 Intergovern- Federal Operating Section 8 - Rent Port 1,362,722 1,214,390 1,210,000 1,250,000 40,000 3.3% 4200.103 Intergovern- Federal Operating Section 8 - Administration Port 102,533 92,058 95,115 95,000 115) 0.1% 4200.104 Intergovern- Federal Operating Section 8 - Rental - Other 4200.106 Intergovern- Federal Operating Section 8 - Mainstream Vouchers 94,998 105,101 142,000 114,000 28,000) 19.7% 4200.107 Intergovern- Federal Operating Section 8 - Fraud Recovery 5,441 11,421 4,000 5,000 1,000 25.0% 4200.108 Intergovern- Federal Operating DHAP Administration 552 500 4200.109 Intergovern- Federal Operating HUD Direct Administration 179,151 166,994 169,500 158,750 10,750) 6.3% 4200.110 Intergovern- Federal Operating Section 8 - Port- in Prior Years 4200.111 Intergovern- Federal Operating Mainstream Administration 13,668 13,275 131680 405 3.1% 4700.100 Interest Income Investments 7,983 3,030 8,000 800 7,200) 90.0% 4801 Administrative Fee 4900 Transfers In 6,560 6,560 4900.640 Transfers In Employee Benefits Total Revenues 3,374,074 $ 3,327,712 $ 3,291,890 3,249,625 42,265) 2012/2013 Bienniel Budget, City of Plymouth, MN 86 of 138 7/22/2011 City of Plymouth HRA - Section 8 Expenditure Budget 2011-2012 Account 2011 Number Description 2009 Actual 2010 Actual Amended 2012 Proposed Change Change 6000 Salaries 1,613 6000.100 Salaries Regular 161,677 160,968 165,770 165,914 144 0.1% 6050 Benefits 763 27,723 29,109 1,386 5.0% 6050.100 Benefits Social Security 10,005 9,572 10,409 10,287 122) 1.2% 6050.101 Benefits Medicare 2,147 2,239 2,420 2,406 14) 0.6% 6050.200 Benefits PERA 11,880 11,267 12,019 12,029 10 0.1% 6050.201 Benefits Deferred Compensation 1,743 2,030 1,980 1,980 6060 Medical Insurance 21,689 14,181 6060.100 Medical Insurance Employer Contribution 8,802 6070 Dental Insurance 1,959 1,183 6070.100 Dental Insurance Employer Contribution 734 6080 Group Life Insurance 223 130 6080.100 Group Life Insurance Employer Contribution 82 240 240 6100 Office Supplies 484 500 250 250) 50.0% 6500 Employee Development 6500.100 Employee Development Employee Training 44 179 2,700 1,500 1,200) 44.4% 6500.104 Employee Development Conferences >t Seminars 643 269 2,500 2,000 500) 20.0% 6550 Mileage 8t Parking Reimbursement 173 280 200 200 6700 Dues and Subscriptions 83 250 300 50 20.0% 7000 Professional Services 3,839 2,332 4,000 4,250 250 6.3% 7003 Legal 28 250 500 250 100.0% 7004 Audit Fees 7,139 7,860 6,500 7,937 1,437 22.1% 7005 Accounting 2,760 2,820 3,300 3,500 200 6.1% 7013 Record Retention 7100.100 Communications Postage 3,583 3,254 4,000 4,000 7100.104 Communications Mobile Telephone 7200 Printing and Publishing 562 749 1,000 1,000 7600 Rentals 2012/2013 Bienniel Budget, City of Plymouth, MN 87 of 138 7/22/2011 City of Plymouth HRA - Section 8 Expenditure Budget Account Number Description 2009 Actual 2010 Actual 2011 Amended 2012 Proposed 2011-2012 Change % Change 8100.500 Capital Outlay (> 5K) Machinery and Equipment 9000.100 Allocations Photocopying 376 376 376 376) 100.0% 9000.101 Allocations Information Technology 20,634 20,634 20,634 16,349 4,285) 20.8% 9000.102 Allocations Facilities Management 4,025 4,431 4,567 4,452 115) 2.5% 9000.103 Allocations Administrative 9000.104 Allocations Mobile Phone 182 9000.106 Allocations Telephone 1,751 983 983 983) 100.0% 9000.108 Allocations Internal Rental Charges 4,515 9500 Allocations Risk Management 9,422 9,422 9500.600 Transfers Out 8,226 8,226) 100.0% 9500.620 Transfers Out Central Equipment 9500.630 Transfers Out Information Technology 3,500 6,000 9500.640 Transfers Out Risk Management 7,843 7,843 7,843 7,843) 100.0% 9900 Transfers Out Employee Benefits 9906.101 Miscellaneous 9908.100 Donations Et Contributions Social Services 9908.102 Section 8 Fees Project Based 101,303 93,331 94,000 95,000 1,000 1.1% 9908.103 Section 8 Fees Port -Out Rent Assist 179,817 122,989 100,000 204,000 104,000 104.0% 9908.104 Section 8 Fees Port -Out Admin Fee 15,021 9,770 8,000 12,000 4,000 50.0% 9908.105 Section 8 Fees Port -In Vouchers 1,362,722 1,214,390 1,210,000 1,250,000 40,000 3.3% 9908.106 Section 8 Fees Mainstream M/C 81,634 86,809 84,500 85,000 500 0.6% 9908.107 Section 8 Fees Mainstream M5 (HUD) 103,441 105,101 142,000 114,000 28,000) 19.7% 9908.108 Section 8 Fees Rental Vouchers 1,160,813 1,193,203 1,225,000 1,130,000 95,000) 7.8% 9908.109 Section 8 Fees Enhanced Rental 157,151 130,843 140,000 82,000 58,000) 41.4% 9908.110 Section 8 Fees Utility Allowance 9908.111 Section 8 Fees Port -in Prior Years 9916 Section 8 Fees Prior Year HUD - Other 9,117 2012/2013 Bienniel Budget, City of Plymouth, MN 88 of 138 7/22/2011 Account Number Description City of Plymouth HRA - Section 8 Expenditure Budget 2011-2012 2011 2009 Actual 2010 Actual Amended 2012 Proposed $ Change % Change Total Expenditures $ 3,435,277 $ 3,237,239 $ 3,291,890 $ 3,249,625 $ (42,265) 2012/2013 Bienniel Budget, City of Plymouth, MN 89 of 138 7/22/2011 City of Plymouth HRA - General Revenue Budget Account Number Account Description 2009 Actual 2010 Actual 2011 Amended 2012 Proposed 2011-2012 Change % Change 4000.100 Taxes Property 527,915 525,636 537,769 530,257 7,512) -1.4% 4230 Intergovernmental- State- Operatng 141,553 200,000 4230.100 Intergovernmental- State- Operatng Market Value Credit (HACA) 10,970 5,888 4240 Intergovernmental -State -Capital 4290 Intergovernmental -Other 4600 Contributions - Operating 4620 Contributions - Capital 30,000 4700 Interest Income 15,679 50) 4700.100 Interest Income Investments 13,065 5,103 30,000 5,000 25,000) -83.3% 4700.300 Interest Income Notes 11,538 13,765 4801 Administrative Fee 4804 Sale of Asset 4820 Development Loan Repayments 15,170 21,243 21,250 21,250 4900 Transfers In 4900.258 Transfers In HRA General 4900.407 Transfers In Project Administration 4900.429 Transfers In TIF #1-3 - Crossroads Stations 5,433 4900.640 Transfers In Employee Benefits 4320 Rental Fees 3,800 4800 Other Revenues 165 16,154 Total Revenues 741,488 821,538 589,019 556,507 32,512) 2012/2013 Bienniel Budget, City of Plymouth, MN 90 of 138 7/22/2011 City of Plymouth HRA - General Expenditure Budget 2011-2012 Account 2011 Number Description 2009 Actual 2010 Actual Amended 2012 Proposed Change Change 6000 Salaries 3,273 6000.100 Salaries Regular 143,295 127,124 138,059 138,723 664 0.5% 6050 Benefits 839 16,810 17,651 841 5.0% 6050.100 Benefits Social Security 8,592 7,012 8,389 8,602 213 2.5% 6050.101 Benefits Medicare 1,884 1,674 1,999 2,012 13 0.7% 6050.200 Benefits PERA 10,206 8,899 10,000 10,058 58 0.6% 6050.201 Benefits Deferred Compensation 243 104 80 80 6060 Medical Insurance 15,464 8,528 6060.100 Medical Insurance Employer Contribution 5,851 6070 Dental Insurance 528 222 6070.100 Dental Insurance Employer Contribution 138 6080 Group Life Insurance 600 362 6080.100 Group Life Insurance Employer Contribution 259 640 640 6100 Office Supplies 78 204 500 500 6500 Employee Development 4 6500.100 Employee Development Employee Training 1,200 1,200 6500.104 Employee Development Conferences Et Seminars 114 134 4,000 2,000 2,000) 50.0% 6550 Mileage Et Parking Reimbursement 100 100 6700 Dues and Subscriptions 695 725 1,700 1,700 7000 Professional Services 590 1,097 10,000 10,000 7003 Legal 621 5,902 4,988 4,000 988) 19.8% 7004 Audit Fees 1,088 1,199 1,050 2,000 950 90.5% 7100.100 Communications Postage 394 500 500 7200 Printing and Publishing 104 500 500 7600 Rentals 8100.100 Capital Outlay (> 5K) Land 8100.300 Capital Outlay (> 5K) Buildings 171,008 9000.100 Allocations Photocopying 125 125 125 125) 100.0% 9000.101 Allocations Information Technology 8,923 8,923 8,923 7,963 960) 10.8% 2012/2013 Bienniel Budget, City of Plymouth, MN 91 of 138 7/22/2011 City of Plymouth HRA - General Expenditure Budget Account Number Description 2009 Actual 2010 Actual 2011 Amended 2012 Proposed 2011-2012 Change % Change 9000.102 Allocations Facilities Management 10,535 11,847 12,284 11,976 308) 2.5% 9000.103 Allocations Administrative 9000.104 Allocations Mobile Phone 60 60 9000.106 Allocations Telephone 2,065 2,065 2,065 2,065) 100.0% 9000.108 Allocations Internal Rental Charges 3,190 9000.110 Allocations Risk Management 9,572 9,572 9500.258 Transfers Out 19,901 2,281 17,621) 88.5% 9500.417 Transfers Out HRA General 9500.630 Transfers Out HRA Senior Apt Construction 9500.640 Transfers Out Risk Management 3,206 3,206 3,206 3,206) 100.0% 9900 Transfers Out Employee Benefits 9906 Miscellaneous 50 9909 Real Estate Taxes 1,722 9910 Donations Et Contributions 2,000 2,000 9911 Senior Housing Rent Assistance 316,299 339,996 340,000 322,105 17,895) 5.3% 9930 Housing Loans 9950 Grant Awards 141,553 345 345 9904 Development Loans Total Expenditures 670,062 712,941 589,019 556,507 32,512) 2012/2013 Bienniel Budget, City of Plymouth, MN 92 of 138 7/22/2011 City of Plymouth Water Revenue Budget Account Number Account Description 2009 Actual 2010 Actual 2011 Amended 2012 Proposed 2011-2012 Change % Change 4150.450 Permits Water 4,386 6,411 7,031 7,300 269 3.8% 4330.101 Utility Charges Water - Residential 3,831,995 3,410,294 4,244,893 3,747,885 497,008) 11.7% 4330.102 Utility Charges Water - Commercial 1,591,356 1,565,778 1,762,825 1,633,817 129,008) 7.3% 4330.103 Utility Charges Water Demand - Commercial 415,468 436,299 415,468 440,753 25,285 6.1 4330.106 Utility Charges Meter Sales 31,939 0 4330.600 Utility Charges Fire Hydrant Inspection 54,635 54,880 60,000 60,000 4330.800 Utility Charges Penalties 53,686 47,435 40,000 40,000 4350 General Services 2,707 4350.119 General Services Antennae Charges 105,795 130,566 154,900 121,694 33,206) 21.4% 4360.104 Items for Resale Water meter / horns 8,796 52,339 48,000 52,000 4,000 8.3% 4620 Contributions - Capital 867,459 539,157 250,000 200,000 50,000) 20.0% 4700 Interest Income 4700.100 Interest Income Investments 67,248 30,055 47,176 14,000 33,176) 70.3% 4700.200 Interest Income Special Assessments 10,964 4,195 4800 Other Revenues 16,546 30,240 4801 Administrative Fee 4807 Refunds Et Reimbursements 9,484 4900 Transfers In 161,792 161,792 DIV/0! 4900.306 Transfers In Water Revenue Bonds - 2004B 4900.406 Transfers In Street Reconstruction 44,586 4900.412 Transfers In Utility Trunk Replacement 100,655 4900.418 Transfers In Utility Trunk System Expansion 4900.419 Transfers In Water Fund Construction Bonds 4900.420 Transfers In Water Sewer Construction 126,623 2,173,167 4900.510 Transfers In Water Resources 4900.530 Transfers In Solid Waste Management 4900.610 Transfers In Public Facilities 28,952 27,768 4900.640 Transfers In Employee Benefits Total Revenues $ 7,225,331 $ 8,656,532 $ 7,030,293 $ 6,479,241 $ (551,052) 2012/2013 Bienniel Budget, City of Plymouth, MN 93 of 138 7/22/2011 City of Plymouth Water Expense Budget 2011-2012 Account 2011 Number Description 2009 Actual 2010 Actual Amended 2012 Proposed Change % Change 6000 Salaries 9,273 6000.100 Salaries Regular 1,259,589 1,058,935 1,122,250 1,119,520 2,730) -0.2% 6000.200 Salaries Temporary 18,729 18,569 35,000 35,000 6020 Overtime 3,260 6020.100 Overtime Regular 102,343 96,231 84,000 84,000 6050 Benefits 5,581 165,177 160,000 5,177) -3.1 6050.100 Benefits Social Security 93,868 69,974 77,580 76,788 792) -1.0% 6050.101 Benefits Medicare 19,657 16,611 18,330 17,959 371) -2.0% 6050.200 Benefits PERA 108,251 82,110 81,430 87,255 5,825 7.2% 6050.201 Benefits Deferred Compensation 24,190 23,384 23,540 23,540 6050.300 Benefits Life 6050.302 Benefits Unemployment 6,900 6,540 7,000 7,000 6050.303 Benefits Workers Compensation 6050.400 Benefits Dept'l Insurance Allocation 6050.550 Benefits Cell Phone Allowance 6060 Medical Insurance 155,761 99,169 6060.100 Medical Insurance Employer Contribution 44,809 6070 Dental Insurance 10,057 5,693 6070.100 Dental Insurance Employer Contribution 2,991 6080 Group Life Insurance 2,780 1,714 6080.100 Group Life Insurance Employer Contribution 797 2,680 2,680 6100 Office Supplies 16,927 17,343 22,000 22,000 6100.100 Office Supplies Coffee and Cups 6110 Computer Supplies 6120 Operating Supplies 5,590 48 6120.101 Operating Supplies Public Education Et Outreach Prj 4 6120.102 Operating Supplies Motor Fuels Et Lubricants 2,480 14,000 14,000 6120.103 Operating Supplies Janitorial 2,100 2,100 2012/2013 Bienniel Budget, City of Plymouth, MN 94 of 138 7/22/2011 City of Plymouth Water Expense Budget Account Number Description 2009 Actual 2010 Actual 2011 Amended 2012 Proposed 2011-2012 Change % Change 6130 Repair Et Maintenance Supplies 85 419 6130.100 Repair Et Maintenance Supplies Equipment Parts 81,000 72,068 90,000 90,000 6130.101 Repair Et Maintenance Supplies Horticulture 3,188 2,223 5,000 5,000 6130.105 Repair Et Maintenance Supplies Paint 1,946 1,041 2,000 2,500 500 25.0% 6130.111 Repair Et Maintenance Supplies Chemicals 430,899 364,063 395,000 430,000 35,000 8.9% 6130.112 Repair Et Maintenance Supplies Water Mains 13,549 21,395 20,000 22,500 2,500 12.5% 6130.114 Repair Et Maintenance Supplies Meter Parts 157,722 170,265 125,000 160,000 35,000 28.0% 6130.115 Repair Et Maintenance Supplies Hydrant Markers 1,291 1,570 2,500 2,000 500) -20.0% 6130.116 Repair Et Maintenance Supplies Water Valves and Curb Stops 28,396 26,278 30,000 30,000 6130.117 Repair Et Maintenance Supplies Hydrant Parts 12,403 11,808 15,000 15,000 6130.119 Repair Et Maintenance Supplies Recharges 6140.100 Miscellaneous Supplies Medical 500 500 6140.101 Miscellaneous Supplies Uniforms 6140.102 Miscellaneous Supplies Safety Equipment 5,600 4,485 5,800 5,800 6500 Employee Development 6500.100 Employee Development Employee Training 5,291 5,428 9,300 9,300 6500.104 Employee Development Conferences Et Seminars 3,300 3,300) -100.0% 6550 Mileage Et Parking Reimbursement 6700 Dues and Subscriptions 3,437 3,437 5,000 5,000 7000 Professional Services 143,885 131,978 130,000 145,000 15,000 11.5% 7001 Consulting Engineer 15,000 15,000 7002 Internal Engineer 7003 Legal 7004 Audit Fees 3,482 3,817 3,900 3,900 7006 Medical Fees 371 7007 Drug and Alcohol Testing 74 7011 Soil Boring and Testing 7012 Comprehensive Plan Review 2012/2013 Bienniel Budget, City of Plymouth, MN 95 of 138 7/22/2011 Account Number Description 7013 Record Retention 7014 City Survey 7017 Laundry Services 7100.100 Communications Postage 7100.103 Communications Telephone 7100.104 Communications Mobile Telephone 7200 Printing and Publishing 7400.102 Utilities Natural Gas 7400.103 Utilities Water and Sewer 7400.104 Utilities Solid Waste 7400.106 Utilities Water Connection Fee 7400.107 Utilities State Summer Water Surcharge 7400.108 Utilities Electric 7500.101 Repair and Maintenance Services Lawn 150,000 Maintenance 7500.104 Repair and Maintenance Services Electrical 7500.115 Repair and Maintenance Services Pull Wells 7500.116 Repair and Maintenance Services Water Samples 7500.117 Repair and Maintenance Services MN Health 13,366 Samples 7500.118 Repair and Maintenance Services Janitorial 5,000 Services 7500.119 Repair and Maintenance Services Main Repair 7500.120 Repair and Maintenance Services Water Withdrawal Permit 7500.121 Repair and Maintenance Services Zachary Plant 7500.122 Repair and Maintenance Services Central Plant 7500.123 Repair and Maintenance Services Gopher State One Call 2012/2013 Bienniel Budget, City of Plymouth, MN City of Plymouth Water Expense Budget 2009 Actual 2010 Actual 2011 Amended 2012 Proposed 3,434 3,223 6,000 6,500 22,499 22,259 23,100 23,500 654 23 1,000 1,000 59,094 52,923 145,000 55,000 3,670 4,088 47,000 4,200 472 1,800 1,000 131,760 133,544 150,000 150,000 9,020 18,508 35,000 25,000 616,562 594,479 625,000 600,000 2011-2012 Change % Change 500 400 90,000) 42,800) 800) 10,000) 25,000) 10,067 10,655 15,000 15,000 7,832 59,001 75,000 75,000 38 9,173 8,878 14,600 14,600 219,268 284,219 235,000 500,000 265,000 9,486 25,465 35,000 35,000 22,151 30,919 30,000 35,000 5,000 18,322 24,808 25,000 30,000 5,000 13,366 16,871 20,000 25,000 5,000 96 of 138 8.3% 1.7% 62.1 91.1% 44.4% 28.6% 4.0% 112.8% 16.7% 20.0% 25.0% 7/22/2011 Account 73,306 85,000 85,000 - Number Description 7500.127 Repair and Maintenance Services Metro Sewer 37,099) Board 7500.130 Repair and Maintenance Services Building 645,000) Maintenance 7500.135 Repair and Maintenance Services Building Security 7500.141 Repair and Maintenance Services Well Refurbishing 7500.202 Repair and Maintenance Services Equipment 830,000 Maintenance 7600 Rentals 8000 Non -Cap Equip (< 5K) 8100.100 Capital Outlay (> 5K) Land 8100.200 Capital Outlay (> 5K) Infrastructure 8100.250 Capital Outlay (> 5K) Capitalize -Infrastructure 8100.300 Capital Outlay (> 5K) Buildings 8100.350 Capital Outlay (> 5K) Capitalize Buildings 8100.400 Capital Outlay (> 5K) Improv Other Than 50,655) Buildings 8100.500 Capital Outlay (> 5K) Machinery and Equipment 8100.550 Capital Outlay (> 5K) Capitalize Machinery and 12,310) Equip 8100.800 Capital Outlay (> 5K) Construction Projects 8500 Depreciation 8910 Debt Service - Principal 8920 Debt Service - Interest 9000.100 Allocations Photocopying 9000.101 Allocations Information Technology 9000.102 Allocations Facilities Management 2012/2013 Bienniel Budget, City of Plymouth, MN City of Plymouth Water Expense Budget 2011 2009 Actual 2010 Actual Amended 1,600 2011-2012 2012 Proposed $ Change % Change 1,600 - 37,627 73,306 85,000 85,000 - 3,145 6,111 3,000 4,000 1,000 33.3% 9,279 15,593 8,550 18,250 9,700 113.5% 37,099) 136,355 - 136,355) - - 17,000 17,000 1,250,000 605,000 645,000) 51.6% 2,499,455 2,512,619 830,000 830,000 352,412 327,126 308,913 280,300 28,613) 9.3% 2,274 2,274 2,274 2,274) 100.0% 147,084 147,084 147,084 96,429 50,655) 34.4% 78,614 85,549 87,861 75,551 12,310) 14.0% 97 of 138 7/22/2011 City of Plymouth Water Expense Budget Account Number Description 2009 Actual 2010 Actual 2011 Amended 2012 Proposed 2011-2012 Change % Change 9000.104 Allocations Mobile Phone 11,183 11,183 6,003 6,003) 100.0% 9000.105 Allocations Security 32,558 32,558 32,558 32,558) 100.0% 9000.106 Allocations Telephone 8,984 8,984 8,984 8,984) 100.0% 9000.107 Allocations Central Equipment 159,340 138,583 135,144 3,439) 2.5% 9000.108 Allocations Internal Rental Charges 227,760 9000.110 Allocations Risk Management 38,258 38,258 9500 Transfers Out 188,010 188,010) 100.0% 9500.100 Transfers Out General 79,567 82,567 82,567 82,567 9500.306 Transfers Out Water Revenue Bonds - 2004B 9500.412 Transfers Out Utility Trunk Replacement 625,000 625,000 625,000) 100.0% 9500.413 Transfers Out Improvement Project Construction 60,904 2,164,313 9500.418 Transfers Out Utility Trunk System Expansion 9500.419 Transfers Out Water Fund Construction Bonds 9500.420 Transfers Out Water Sewer Construction 211,179 273,734 9500.510 Transfers Out Water Resources 41,683 9500.600 Transfers Out Central Equipment 4,771 9500.620 Transfers Out Information Technology 10,000 10,000 10,000 10,000) 100.0% 9500.630 Transfers Out Risk Management 50,419 50,419 50,419 50,419) 100.0% 9500.640 Transfers Out Employee Benefits 9900 Miscellaneous 38 9905 Easements 9913 Licenses Et Permits 9917 Bad Debt 63 9920 Bank Fees 4,744 3,721 5,000 4,000 1,000) 20.0% 9921 Bank Fees - Credit Card 17,000 17,000 Total Expenditures 7,668,558 10,309,349 7,030,293 6,479,241 551,052) 2012/2013 Bienniel Budget, City of Plymouth, MN 98 of 138 7/22/2011 Account Number Account Description City of Plymouth Water Resources Revenue Budget 2011-2012 2012 2009 Actual 2010 Actual 2011 Amended Proposed $ Change % Change 4230 Intergovernmental- State- Operatng 4230.203 Intergovernmental- State- Operatng Water Resources Grant 4240 Intergovernmental -State -Capital 923,688 800,000 800,000) 4290 Intergovernmental -Other 1,500 4330.400 Utility Charges Water Resources - Residential 1,204,081 1,212,630 1,120,000 1,212,630 92,630 4330.401 Utility Charges Water Resources - Commercial 1,319,395 1,319,849 1,320,000 1,320,000 4330.800 Utility Charges Penalties 22,288 22,693 15,000 15,000 4600 Contributions - Operating 1,000 4620 Contributions - Capital 200,570 4700.100 Interest Income Investments 17,201 7,873 14,008 15,000 992 4800 Other Revenues 1,063 36,393 4801 Administrative Fee 4807 Refunds 8t Reimbursements 24,788 4830 Internal Project Funding 4900 Transfers In 625,919 1,603,861 977,942 4900.404 Transfers In Community Improvement 4900.421 Transfers In Enterprise - Other Construction 359,506 333,285 4900.500 Transfers In Water 41,683 4900.510 Transfers In Water Resources 4900.640 Transfers In Employee Benefits Total Revenues 3,148,892 3,900,595 3,894,927 4,166,491 $ 271,564 100.0% 8.3% 7.1 156.2% 2012/2013 Bienniel Budget, City of Plymouth, MN 99 of 138 7/22/2011 City of Plymouth Water Resources Expense Budget 2011-2012 Account 2011 Number Description 2009 Actual 2010 Actual Amended 2012 Proposed Change Change 6000 Salaries 12,877 6000.100 Salaries Regular 567,037 563,597 551,350 607,785 56,435 10.2% 6000.200 Salaries Temporary 6000.999 Salaries Salaries and Benefits - Capital 13,310) 6020 Overtime 96 6020.100 Overtime Regular 18,348 14,915 34,000 34,000 6050 Benefits 3,832 96,534 112,865 16,331 16.9% 6050.100 Benefits Social Security 40,852 34,210 36,820 39,795 2,975 8.1 6050.101 Benefits Medicare 8,366 8,021 8,620 9,310 690 8.0% 6050.200 Benefits PERA 48,900 40,257 39,970 46,530 6,560 16.4% 6050.201 Benefits Deferred Compensation 10,450 8,870 9,380 9,380 6050.300 Benefits Life 6050.301 Benefits Long Term Disability 6050.303 Benefits Workers Compensation 6050.400 Benefits Dept'l Insurance Allocation 6060 Medical Insurance 75,326 51,360 6060.100 Medical Insurance Employer Contribution 29,593 6070 Dental Insurance 5,811 2,654 6070.100 Dental Insurance Employer Contribution 1,538 6080 Group Life Insurance 1,282 821 6080.100 Group Life Insurance Employer Contribution 504 1,350 1,350 6100 Office Supplies 423 378 2,000 1,500 500) 25.0% 6120.101 Operating Supplies Public Education Et Outreach Prj 34,791 34,381 25,000 35,000 10,000 40.0% 6120.114 Operating Supplies Reforestation 6130.101 Repair Et Maintenance Supplies Horticulture 5,746 4,817 30,000 20,000 10,000) 33.3% 6130.106 Repair Et Maintenance Supplies Lumber 362 1,647 3,500 3,500 6130.107 Repair Et Maintenance Supplies Concrete and Asphalt 4,088 18,042 16,500 20,000 3,500 21.2% 2012/2013 Bienniel Budget, City of Plymouth, MN 100 of 138 7/22/2011 City of Plymouth Water Resources Expense Budget Account Number Description 6130.110 Repair Et Maintenance Supplies Drainage 6140.101 Miscellaneous Supplies Uniforms 6140.102 Miscellaneous Supplies Safety Equipment 6500 Employee Development 6500.100 Employee Development Employee Training 6500.104 Employee Development Conferences Et Seminars 6550 Mileage Et Parking Reimbursement 6600 Meetings 6700 Dues and Subscriptions 7000 Professional Services 7001 Consulting Engineer 7002 Internal Engineer 7003 Legal 7006 Medical Fees 7011 Soil Boring and Testing 7016 Animal Control 7017 Laundry Services 7100.100 Communications Postage 7100.104 Communications Mobile Telephone 7200 Printing and Publishing 7400.108 Utilities Electric 7500.102 Repair and Maintenance Services Weed Control 7500.111 Repair and Maintenance Services Street Cleaning 7500.112 Repair and Maintenance Services Drainway 66,884 Maintenance 7500.113 Repair and Maintenance Services Curb Raising Et 14.7% Curb Work 7500.116 Repair and Maintenance Services Water Samples 7600 Rentals 2009 Actual 2010 Actual 2011 Amended 2012 Proposed 2011-2012 Change % Change 70,610 68,917 90,000 90,000 3,203 5,021 5,000 5,500 500 10.0% 3,130 1,104 3,500 2,500 1,000) 28.6% 782 430 3,000 2,000 1,000) 33.3% 52 61 100 100 8 100 100 260,198 243,906 265,000 265,000 23,515 66,884 150,000 128,000 22, 000) 14.7% 41,570 5,000 10,000 5,000 100.0% 10,000 10,000 57000 5,000 50,000 25,000 25,000) 50.0% 4,725 5,000 275 5.8% 940 137 2,200 2,000 200) 9.1% 351 530 800 1,000 200 25.0% 110 500 390 354.5% 35,658 22,354 45,000 45,000 138,456 115,230 155,000 100,000 55,000) 35.5% 84,928 52,601 95,000 125,000 30,000 31.6% 35,000 19,934 35,000 2857000 250,000 714.3% 44,007 17173 55,000 557000 10,361 19,049 30,000 30,000 2012/2013 Bienniel Budget, City of Plymouth, MN 101 of 138 7/22/2011 City of Plymouth Water Resources Expense Budget Account Number Description 2009 Actual 2010 Actual 2011 Amended 2012 Proposed 2011-2012 Change % Change 8000 Non -Cap Equip (< 5K) 13,676 9,157 15,000 15,500 500 3.3% 8100 Capital Outlay (> 5K) 8100.100 Capital Outlay (> 5K) Land 0) 0 8100.200 Capital Outlay (> 5K) Infrastructure 0) 8100.250 Capital Outlay (> 5K) Capitalize -Infrastructure 0) 8100.400 Capital Outlay (> 5K) Improv Other Than Buildings 0 8100.500 Capital Outlay (> 5K) Machinery and Equipment 258,500 258,500 8100.800 Capital Outlay (> 5K) Construction Projects 1,760,000 1,570,000 190,000) 10.8% 8500 Depreciation 78,307 97,544 9000.100 Allocations Photocopying 766 766 766 766) 100.0% 9000.101 Allocations Information Technology 53,884 53,884 53,884 19,728 34,156) 63.4% 9000.102 Allocations Facilities Management 12,130 13,660 14,171 10,849 3,322) 23.4% 9000.104 Allocations Mobile Phone 4,516 4,516 1,638 1,638) 100.0% 9000.106 Allocations Telephone 3,316 3,316 3,316 3,316) 100.0% 9000.107 Allocations Central Equipment 156,172 139,482 135,141 4,341) 3.1 9000.108 Allocations Internal Rental Charges 241,241 9000.110 Allocations Risk Management 6,670 6,670 9500 Transfers Out 9500.100 Transfers Out General 17,388 17,957 17,388 17,388 9500.412 Transfers Out Utility Trunk Replacement 9500.413 Transfers Out Improvement Project Construction 32,848 9500.421 Transfers Out Enterprise - Other Construction 353,220 497,454 9500.429 Transfers Out TIF #1-3 - Crossroads Stations 85,077 9500.500 Transfers Out Water 9500.520 Transfers Out Sewer 9500.600 Transfers Out Central Equipment 9500.630 Transfers Out Risk Management 24,723 24,723 24,723 24,723) 100.0% 9500.640 Transfers Out Employee Benefits 2012/2013 Bienniel Budget, City of Plymouth, MN 102 of 138 7/22/2011 Account Number Description 9900 Miscellaneous 9906 Donations 8t Contributions 9913 Licenses E Permits 9919 Administration Fees 9920 Bank Fees City of Plymouth Water Resources Expense Budget 2011-2012 2011 2009 Actual 2010 Actual Amended 2012 Proposed $ Change % Change 300 - 331 71 - 4,744 3,721 5,000 (5,000) -100.0% Total Expenditures $ 2,468,172 $ 2,352,218 $ 3,894,927 $ 4,166,491 $ 271,564 2012/2013 Bienniel Budget, City of Plymouth, MN 103 of 138 7/22/2011 City of Plymouth Sewer Revenue Budget Account Number Account Description 2009 Actual 2010 Actual 2011 Amended 2012 Proposed 2011-2012 Change % Change 4150.400 Permits Sewer 4,226 6,132 7,000 7,300 300 4.3% 4330.201 Utility Charges Sewer - Residential 4,532,942 4,678,262 5,045,278 4,697,714 347,564) 6.9% 4330.202 Utility Charges Sewer - Commercial 2,340,850 2,371,466 2,605,424 2,403,281 202,143) 7.8% 4330.203 Utility Charges Sewer Area Charges 46,000 81,904 4330.800 Utility Charges Penalties 67,369 70,345 60,000 65,000 5,000 8.3% 4350 General Services 2,540 4620 Contributions - Capital 269,572 150,000 100,000 50,000) 33.3% 4700.100 Interest Income Investments 15,474 4,172 9,210 9,000 210) 2.3% 4800 Other Revenues 16,186 2,466 1,500 1,500 4801 Administrative Fee 4804 Sale of Asset 750 4805 Gain (Loss) of Capital Asset 4807 Refunds 8t Reimbursements 427 4900 Transfers In 62,367 62,367 4900.412 Transfers In Utility Trunk Replacement 100,462 Total Revenues 7,293,046 7,318,499 7,878,412 7,346,162 532,250) 2012/2013 Bienniel Budget, City of Plymouth, MN 104 of 138 7/22/2011 City of Plymouth Sewer Expense Budget 2011-2012 Account 2011 Number Description 2009 Actual 2010 Actual Amended 2012 Proposed Change Change 6000 Salaries 3,354 6000.100 Salaries Regular 700,000 577,822 608,900 606,440 2,460) 0.4% 6000.200 Salaries Temporary 6020 Overtime 654 6020.100 Overtime Regular 19,475 26,573 22,000 22,000 6050 Benefits 2,439 88,473 88,000 473) 0.5% 6050.100 Benefits Social Security 50,326 36,047 39,400 38,965 435) 1.1% 6050.101 Benefits Medicare 10,371 8,621 9,320 9,115 205) 2.2% 6050.200 Benefits PERA 49,728 42,272 44,080 45,565 1,485 3.4% 6050.201 Benefits Deferred Compensation 12,935 12,391 12,440 11,000 1,440) 11.6% 6050.300 Benefits Life 6050.302 Benefits Unemployment 61 7,000 7,000 6050.303 Benefits Workers Compensation 6050.400 Benefits Dept'l Insurance Allocation 6050.550 Benefits Cell Phone Allowance 6060 Medical Insurance 84,647 53,940 6060.100 Medical Insurance Employer Contribution 22,986 6070 Dental Insurance 6,657 3,806 6070.100 Dental Insurance Employer Contribution 2,023 6080 Group Life Insurance 1,683 1,043 6080.100 Group Life Insurance Employer Contribution 499 1,660 1,660 6100 Office Supplies 16,289 15,906 18,500 18,500 6120.102 Operating Supplies Motor Fuels Et Lubricants 504 1,201 7,200 6,000 1,200) 16.7% 6130 Repair Et Maintenance Supplies 6130.100 Repair Et Maintenance Supplies Equipment Parts 78,168 79,517 105,000 105,000 6130.101 Repair Et Maintenance Supplies Horticulture 690 19 3,000 3,000 6130.105 Repair Et Maintenance Supplies Paint 5 910 1,000 1,500 500 50.0% 6130.113 Repair Et Maintenance Supplies Sewer Mains 842 1,798 5,500 5,500 6140.101 Miscellaneous Supplies Uniforms 2012/2013 Bienniel Budget, City of Plymouth, MN 105 of 138 7/22/2011 City of Plymouth Sewer Expense Budget Account Number Description 2009 Actual 2010 Actual 2011 Amended 2012 Proposed 6140.102 Miscellaneous Supplies Safety Equipment 3,898 4,371 4,500 4,500 6500 Employee Development 6500.100 Employee Development Employee Training 2,795 2,513 6,000 6,000 6500.104 Employee Development Conferences Et Seminars 6550 Mileage Et Parking Reimbursement 6700 Dues and Subscriptions 7000 Professional Services 69,694 63,201 45,000 60,000 7001 Consulting Engineer 7002 Internal Engineer 7003 Legal 7004 Audit Fees 3,482 3,817 3,900 3,900 7006 Medical Fees 211 300 7012 Comprehensive Plan Review 7013 Record Retention 7014 City Survey 7017 Laundry Services 2,289 2,149 3,500 3,500 7100.100 Communications Postage 23,326 22,374 24,000 24,000 7100.103 Communications Telephone 7100.104 Communications Mobile Telephone 7200 Printing and Publishing 767 1,000 1,000 7400.102 Utilities Natural Gas 14,544 12,405 30,575 15,000 7400.103 Utilities Water and Sewer 3,673 4,088 3,400 4,200 7400.104 Utilities Solid Waste 3,500 7400.108 Utilities Electric 77,060 91,698 80,000 95,000 7500 Repair and Maintenance Services 0) 7500.118 Repair and Maintenance Services Janitorial Services 3,400 3,400 7500.119 Repair and Maintenance Services Main Repair 50,019 36,372 60,000 60,000 2011-2012 Change % Change 15,000 300) 15,575) 800 3,500) 15,000 33.3% 100.0% 50.9% 23.5% 100.0% 18.8% 2012/2013 Bienniel Budget, City of Plymouth, MN 106 of 138 7/22/2011 City of Plymouth Sewer Expense Budget Account Number Description 2009 Actual 2010 Actual 2011 Amended 2012 Proposed 2011-2012 Change % Change 7500.127 Repair and Maintenance Services Metro Sewer Board 4,630,076 4,725,900 4,750,000 4,800,000 50,000 1.1% 7500.136 Repair and Maintenance Services Manhole Sealing 30,991 29,999 30,000 180,000 150,000 500.0% 7500.138 Repair and Maintenance Services Maple Grove Sewer Agreement 159,757 81,959 90,000 90,000 7500.202 Repair and Maintenance Services Equipment Maintenance 7,596 44,683 35,000 45,000 10,000 28.6% 7600 Rentals 2,212 8000 Non -Cap Equip (< 5K) 3,505 1,115 5,050 5,500 450 8.9% 8100.100 Capital Outlay (> 5K) Land 8100.200 Capital Outlay (> 5K) Infrastructure 562,462 8100.250 Capital Outlay (> 5K) Capitalize -Infrastructure 562,462) 8100.350 Capital Outlay (> 5K) Capitalize Buildings 8100.400 Capital Outlay (> 5K) Improv Other Than Buildings 8100.450 Capital Outlay (> 5K) Capitalize Improvements 8100.500 Capital Outlay (> 5K) Machinery and Equipment 8100.550 Capital Outlay (> 5K) Capitalize Machinery and Equip 8100.800 Capital Outlay (> 5K) Construction Projects 1,210,000 700,000 510,000) 42.1% 8500 Depreciation 833,887 890,635 9000.100 Allocations Photocopying 1,532 1,532 1,532 1,532) 100.0% 9000.101 Allocations Information Technology 79,865 79,865 79,865 17,260 62,605) 78.4% 9000.102 Allocations Facilities Management 32,977 21,348 17,472 14,591 2,881) 16.5% 9000.104 Allocations Mobile Phone 5,433 8,320 5,470 5,470) 100.0% 9000.105 Allocations Security 3,484 3,484 3,484 3,484) 100.0% 9000.106 Allocations Telephone 6,747 6,747 6,747 6,747) 100.0% 9000.107 Allocations Central Equipment 151,614 123,137 129,715 6,578 5.3% 9000.108 Allocations Internal Rental Charges 242,197 2012/2013 Bienniel Budget, City of Plymouth, MN 107 of 138 7/22/2011 City of Plymouth Sewer Expense Budget Account Number Description 2009 Actual 2010 Actual 2011 Amended 2012 Proposed 2011-2012 Change % Change 9000.110 Allocations Risk Management 34,708 34,708 9500 Transfers Out 48,893 48,893) 100.0% 9500.100 Transfers Out General 56,643 58,643 58,643 58,643 9500.412 Transfers Out Utility Trunk Replacement 125,000 125,000 125,000) 100.0% 9500.413 Transfers Out Improvement Project Construction 16,493 9500.420 Transfers Out Water Sewer Construction 879,386 416,759 9500.600 Transfers Out Central Equipment 4,771 9500.630 Transfers Out Risk Management 37,571 37,571 37,571 37,571) 100.0% 9500.640 Transfers Out Employee Benefits 10,000 10,000 10,000 10,000) 100.0% 9500.660 Transfers Out Resource Planning 7,500 9900 Miscellaneous 0 9906 Donations Et Contributions 9913 Licenses Et Permits 9917 Bad Debt 9920 Bank Fees 4,744 3,721 5,000 4,000 1,000) 20.0% 9920.100 Bank Fees - credit card 17,000 17,000 Total Expenditures 8,325,010 7,852,193 7,878,412 7,346,162 532,250) 2012/2013 Bienniel Budget, City of Plymouth, MN 108 of 138 7/22/2011 City of Plymouth Solid Waste Revenue Budget Account Number Account Description 2009 Actual 2010 Actual 2011 Amended 2012 Proposed 2011-2012 Change % Change 4230 Intergovernmental-State-Operatng 184,825 166,000 166,000) 100.0% 4250 Intergovernmental-County-Opertng 190,648 4270 Intergovernmental-Local-Operatng 3,390 4,300 44,400 40,100 932.6% 4290 Intergovernmental -Other 2,000 4330.300 Utility Charges Solid Waste 406,295 408,311 406,728 410,166 3,438 0.8% 4330.800 Utility Charges Penalties 4,661 4,755 5,000 5,000 4700 Interest Income 4700.100 Interest Income Investments 22,313 8,938 15,471 15,471) 100.0% 4800 Other Revenues 9,916 286,429 10,000 10,000) 100.0% 4807 Refunds Et Reimbursements 10,585 4900 Transfers In 658,301 706,594 48,293 7.3% 4900.640 Transfers In Employee Benefits Total Revenues 630,010 913,055 1,265,800 1,166,160 99,640) 2012/2013 Bienniel Budget, City of Plymouth, MN 109 of 138 7/22/2011 City of Plymouth Solid Waste Expense Budget Account Number Description 6000 Salaries 6000.100 Salaries Regular 6000.200 Salaries Temporary 6020.100 Overtime Regular 6050 Benefits 6050.100 Benefits Social Security 6050.101 Benefits Medicare 6050.200 Benefits PERA 6050.201 Benefits Deferred Compensation 6050.300 Benefits Life 6050.302 Benefits Unemployment 6050.303 Benefits Workers Compensation 6050.400 Benefits Dept'l Insurance Allocation 6060 Medical Insurance 6060.100 Medical Insurance Employer Contribution 6070 Dental Insurance 6070.100 Dental Insurance Employer Contribution 6080 Group Life Insurance 6080.100 Group Life Insurance Employer Contribution 6100 Office Supplies 6120 Operating Supplies 6120.101 Operating Supplies Public Education Et Outreach f 6140 Miscellaneous Supplies 6140.101 Miscellaneous Supplies Uniforms 6140.102 Miscellaneous Supplies Safety Equipment 6500 Employee Development 6500.100 Employee Development Employee Training 6500.101 Employee Development City wide Training 6500.104 Employee Development Conferences Et Seminars 6550 Mileage Et Parking Reimbursement 2012/2013 Bienniel Budget, City of Plymouth, MN 2011-2012 2011 2012 2009 Actual 2010 Actual Amended Proposed $ Change % Change 4,523 $ 74,311 85,875 94,300 95,748 1,448 1.5% 9,733 8,899 11,300 11,300 12,814 8,632 15,000 15,000 1,079 6,678 7,012 334 5.0% 6,089 5,660 7,497 7,568 71 0.9% 1,360 1,324 1,758 1,773 15 0.9% 5,848 6,608 6,839 8,850 2,011 29.4% 747 368 469 469 16,769 2,268 3,000 3,000 11,165 10,826 6,236 879 112 55 215 155 97 250 250 28 300 200 100) 33.3% 2,090 910 13,500 6,400 7,100) 52.6% 6,750 6,531 6,000 13,200 7,200 120.0% 539 900 1,500 600 119 69 200 300 100 50.0% 160 500 100 400) 80.0% 32 1,000 700 300) 30.0% 425 500 100 400) 80.0% 20 400 700 1,000 300 42.9% 116 19 250 150 100) 40.0% 110 of 138 7/22/2011 City of Plymouth Solid Waste Expense Budget 2011-2012 Account 2011 2012 Number Description 2009 Actual 2010 Actual Amended Proposed Change Change 6600 Meetings 19 50 100 50 100.0% 6700 Dues and Subscriptions 20 190 320 600 280 87.5% 7000 Professional Services 12,910 17,049 12,000 12,000 7100.100 Communications Postage 318 158 3,000 200 2,800) 7100.104 Communications Mobile Telephone 7200 Printing and Publishing 728 12,048 3,200 3,150 50) 8100.200 7400.104 Utilities Solid Waste 735,492 820,516 1,000,000 903,000 97,000) 7400.105 Utilities Yard Waste 583 732 1,000 1,000 7600 Rentals 8000 Non -Cap Equip (< 5K) 14,420 17,908 20,000 31,200 11,200 8100.200 Capital Outlay (> 5K) Infrastructure 8100.500 Capital Outlay (> 5K) Machinery and Equipment 9000.100 Allocations Photocopying 6,365 6,492 6,622 6,622) 100.0% 9000.101 Allocations Information Technology 9,763 9,958 10,157 8,408 1,749) 17.2% 9000.102 Allocations Facilities Management 6,046 6,338 6,435 5,161 1,274) 19.8% 9000.104 Allocations Mobile Phone 149 547 547 547) 100.0% 9000.106 Allocations Telephone 115 117 120 120) 100.0% 9000.107 Allocations Central Equipment 5,152 6,870 2,000 4,870) 9000.110 Allocations Risk Management 6,792 6,792 9500 Transfers Out 9500.100 Transfers Out General 17,929 17,929 17,929 17,929 9500.400 Transfers Out General Capital Projects 9500.500 Transfers Out Water 9500.520 Transfers Out Sewer 9500.630 Transfers Out Risk Management 5,391 5,499 5,609 5,609) 9500.640 Transfers Out Employee Benefits 9900 Miscellaneous 1,479 9920 Bank Fees 4,744 3,721 5,000 5,000) 2012/2013 Bienniel Budget, City of Plymouth, MN 111 of 138 7/22/2011 Account Number Description City of Plymouth Solid Waste Expense Budget 2011-2012 2011 2012 2009 Actual 2010 Actual Amended Proposed $ Change % Change Total Expenditures $ 966,628 $ 1,075,051 $ 1,265,800 $ 1,166,160 $ (99,640) 2012/2013 Bienniel Budget, City of Plymouth, MN 112 of 138 7/22/2011 City of Plymouth Ice Center Revenue Budget Account 2011-2012 Number Account Description 2009 Actual 2010 Actual 2011 Amended 2012 Proposed Change Change 4310 Program Fees 4310.101 Program Fees Subsidized Recreation 721 954 4310.102 Program Fees Open Freestyle 2,236 1,145 150 1,100 950 633.3% 4310.103 Program Fees Parents 8t Tots 546 527 1,000 500 500) 50.0% 4310.104 Program Fees Open Skating 13,234 14,228 14,000 14,000 4310.105 Program Fees Open Hockey 5,638 6,575 7,200 7,200 4310.106 Program Fees Figure Skating Classes 106,640 97,050 106,000 106,000 4310.108 Program Fees High School Hockey Games 17,379 22,166 25,000 25,000 4320.100 Rental Fees Recreation 660 1,485 4320.101 Rental Fees Ice Rental 1,083,831 1,075,731 1,073,000 1,055,000 18,000) 1.7% 4320.102 Rental Fees Skate Rental 5,703 5,936 6,400 6,000 400) 6.3% 4320.105 Rental Fees Ice Rental - Non-taxable 720 4320.200 Rental Fees Meeting Rooms 1,810 2,024 2,100 2,100 4350 General Services 2,719) 4350.108 General Services Advertisements 18,294 21,387 16,000 18,000 2,000 12.5% 4350.115 General Services Concession Sales 128,265 57 124,000 124,000) 100.0% 4350.116 General Services Vending Machine 17,178 13,319 23,000 16,000 7,000) 30.4% 4350.117 General Services Skate Sharpening 1,836 3,233 3,800 3,800 4350.118 General Services Pro Shop Sales 1,033 1,263 1,300 1,300 4360.114 Items for Resale Concessions 136,343 130,000 130,000 4600 Contributions - Operating 10,000 4620 Contributions - Capital 4700 Interest Income 300 300 4700.100 Interest Income Investments 6,322 3,920 6,298 4,500 1,798) 28.5% 4800 Other Revenues 5,204 4,737 5,000 5,000 4804 Sale of Asset 4807 Refunds Et Reimbursements 4900.405 Transfers In Park Replacement 4900.408 Transfers In Park Constr Dedication Fees 2012/2013 Bienniel Budget, City of Plymouth, MN 113 of 138 7/22/2011 Account Number Account Description City of Plymouth Ice Center Revenue Budget 2011-2012 2009 Actual 2010 Actual 2011 Amended 2012 Proposed $ Change % Change 4900.620 Transfers In Information Technology 17,495 4900.640 Transfers In Employee Benefits - - - - Total Revenues $ 1,444,748 $ 1,409,361 $ 1,414,548 $ 1,395,800 $ (18,748) 2012/2013 Bienniel Budget, City of Plymouth, MN 114 of 138 7/22/2011 City of Plymouth Ice Center Expense Budget 2011-2012 Account 2011 Number Description 2009 Actual 2010 Actual Amended 2012 Proposed Change Change 6000 Salaries 11,164 6000.100 Salaries Regular 237,569 227,143 232,130 235,390 3,260 1.4% 6000.200 Salaries Temporary 168,838 161,168 164,000 167,500 3,500 2.1% 6020.100 Overtime Regular 84 1,000 1,000 6050 Benefits 2,464 39,603 41,583 1,980 5.0% 6050.100 Benefits Social Security 26,618 23,937 24,640 25,042 402 1.6% 6050.101 Benefits Medicare 5,257 5,598 5,789 5,862 73 1.3% 6050.200 Benefits PERA 22,821 21,054 16,830 20,750 3,920 23.3% 6050.201 Benefits Deferred Compensation 2,251 2,507 2,070 2,070 6050.300 Benefits Life 6050.302 Benefits Unemployment 800 7,457 7,500 7,500 6050.303 Benefits Workers Compensation 6050.400 Benefits Dept'[ Insurance Allocation 6060 Medical Insurance 33,089 20,711 6060.100 Medical Insurance Employer Contribution 12,855 6070 Dental Insurance 2,079 1,272 6070.100 Dental Insurance Employer Contribution 842 6080 Group Life Insurance 676 425 6080.100 Group Life Insurance Employer Contribution 276 700 700 6100 Office Supplies 289 911 1,000 1,000 6120 Operating Supplies 1,505 7,316 9,950 10,300 350 3.5% 6120.103 Operating Supplies Janitorial 10,366 10,628 11,000 11,000 6120.114 Operating Supplies Reforestation 6120.125 Operating Supplies Resale 56,164 52,655 57,800 57,350 450) 0.8% 6130 Repair Et Maintenance Supplies 3,940 6130.100 Repair Et Maintenance Supplies Equipment Parts 48,636 47,060 39,200 39,200 6130.119 Repair Et Maintenance Supplies Recharges 200 200 6140 Miscellaneous Supplies 10 6140.100 Miscellaneous Supplies Medical 73 250 250 2012/2013 Bienniel Budget, City of Plymouth, MN 115 of 138 7/22/2011 City of Plymouth Ice Center Expense Budget Account Number Description 2009 Actual 2010 Actual 2011 Amended 2012 Proposed 2011-2012 Change % Change 6140.101 Miscellaneous Supplies Uniforms 1,855 2,800 2,200 600) 21.4% 6500 Employee Development 1,136 1,092 6500.100 Employee Development Employee Training 563 525 300 300 6500.104 Employee Development Conferences Et Seminars 2,100 2,100 6550 Mileage Et Parking Reimbursement 113 192 100 100 6700 Dues and Subscriptions 175 765 1,175 1,000 175) 14.9% 7000 Professional Services 21,583 21,481 20,750 20,750 7004 Audit Fees 816 916 900 900 7006 Medical Fees 7100.100 Communications Postage 179 221 300 300 7100.103 Communications Telephone 5,140 5,140 7100.104 Communications Mobile Telephone 100 7200 Printing and Publishing 165 100 400 400 7400.102 Utilities Natural Gas 74,071 71,877 100,000 75,000 25,000) 25.0% 7400.103 Utilities Water and Sewer 22,200 24,988 21,000 25,675 4,675 22.3% 7400.104 Utilities Solid Waste 3,918 4,539 6,000 5,000 1,000) 16.7% 7400.108 Utilities Electric 230,492 245,746 245,000 250,000 5,000 2.0% 7500 Repair and Maintenance Services 36 7500.104 Repair and Maintenance Services Electrical 1,953 2,301 1,900 1,900 7500.105 Repair and Maintenance Services Plumbing 2,463 2,500 2,500 7500.113 Repair and Maintenance Services Curb Raising Et C 3,100 7500.118 Repair and Maintenance Services Janitorial Servic( 1,376 449 2,700 1,600 1,100) 40.7% 7500.130 Repair and Maintenance Services Building Mainten 11,377 20,848 11,000 11,000 7500.135 Repair and Maintenance Services Building Security 7500.202 Repair and Maintenance Services Equipment Maint 15,950 35,753 14,000 14,000 7600 Rentals 3,728 2,700 1,028) 27.6% 8000 Non -Cap Equip (< 5K) 2,698 4,327 2,000 2,000) 100.0% 8100.100 Capital Outlay (> 5K) Land 8100.200 Capital Outlay (> 5K) Infrastructure 2012/2013 Bienniel Budget, City of Plymouth, MN 116 of 138 7/22/2011 City of Plymouth Ice Center Expense Budget 2011-2012 Account 2011 Number Description 2009 Actual 2010 Actual Amended 2012 Proposed Change Change 8100.300 Capital Outlay (> 5K) Buildings 8100.400 Capital Outlay (> 5K) Improv Other Than Buildings 8100.500 Capital Outlay (> 5K) Machinery and Equipment 41,000 47,500 6,500 15.9% 8500 Depreciation 470,440 470,006 8920 Debt Service - Interest 9000.100 Allocations Photocopying 2,356 2,356 2,356 2,356) 100.0% 9000.101 Allocations Information Technology 27,309 27,833 27,309 38,956 11,647 42.6% 9000.102 Allocations Facilities Management 3,493 5,844 6,627 12,692 6,065 91.5% 9000.104 Allocations Mobile Phone 1,097 1,097 546 546) 100.0% 9000.105 Allocations Security 9000.106 Allocations Telephone 6,884 6,884 6,884 6,884) 100.0% 9000.107 Allocations Central Equipment 3,072 3,416 2,000 1,416) 41.5% 9000.108 Allocations Internal Rental Charges 4,340 9000.110 Allocations Risk Management 25,535 25,535 9500 Transfers Out 249,216 144,285 104,931) 42.1 9500.100 Transfers Out General 11,939 11,939 11,939 11,939 9500.405 Transfers Out Park Replacement 9500.600 Transfers Out Central Equipment 9500.630 Transfers Out Risk Management 9,500 9,500 9,500 9,500) 100.0% 9500.640 Transfers Out Employee Benefits 9900 Miscellaneous 31) 282 9900.100 Miscellaneous Cash Short / Cash Over 9903 Scholarships 698 954 600 800 200 33.3% 9913 Licenses Et Permits 191 475 1,200 1,200 9917 Bad Debt 704 9920 Bank Fees 3,705 5,132 4,000 4,000 9920.100 Bank Fees Credit Card Fees 5,600 5,600 9922 Interest - Interfund Advances 66,668 62,037 52,031 52,031 2012/2013 Bienniel Budget, City of Plymouth, MN 117 of 138 7/22/2011 City of Plymouth Ice Center Expense Budget 2011-2012 Account 2011 Number Description 2009 Actual 2010 Actual Amended 2012 Proposed $ Change % Change Total Expenditures $ 1,618,363 $ 1,669,291 $ 1,414,548 $ 1,395,800 $ (18,748) 2012/2013 Bienniel Budget, City of Plymouth, MN 118 of 138 7/22/2011 Account Number Account Description City of Plymouth Field House Revenue Budget 2011-2012 2012 2009 Actual 2010 Actual 2011 Amended Proposed $ Change % Change 4320.100 Rental Fees Recreation $ 19,232 $ 15,000 $ 15,000 $ - 4320.103 Rental Fees Field House Rental 339,105 342,275 340,000 340,000 - 4350.116 General Services Vending Machine 5,000 4,000 (1,000) 4700.100 Interest Income Investments 8,787 3,831 6,525 3,000 (3,525) 4800 Other Revenues 25,248 7,287 1,500 1,500 - 4805 Gain (Loss) of Capital Asset 4900.640 Transfers In Employee Benefits Total Revenues $ 373,140 $ 372,626 $ 368,025 $ 363,500 $ (4,525) 20.0% 54.0% 2012/2013 Bienniel Budget, City of Plymouth, MN 119 of 138 7/22/2011 City of Plymouth Field House Expense Budget 2011-2012 Account 2011 Number Description 2009 Actual 2010 Actual Amended 2012 Proposed Change Change 6000 Salaries 2,179 6000.100 Salaries Regular 58,419 57,974 60,700 63,079 2,379 3.9% 6000.200 Salaries Temporary 16,029 21,259 23,000 23,000 6020.100 Overtime Regular 86 77 6050 Benefits 523 9,372 9,841 469 5.0% 6050.100 Benefits Social Security 5,388 4,926 5,249 5,340 91 1.7% 6050.101 Benefits Medicare 1,083 1,152 1,225 1,250 25 2.0% 6050.200 Benefits PERA 4,438 4,644 4,399 4,700 301 6.8% 6050.201 Benefits Deferred Compensation 756 656 810 810 6050.300 Benefits Life 6050.400 Benefits Dept'[ Insurance Allocation 6060 Medical Insurance 7,737 5,058 6060.100 Medical Insurance Employer Contribution 3,327 6070 Dental Insurance 596 454 6070.100 Dental Insurance Employer Contribution 256 6080 Group Life Insurance 214 138 6080.100 Group Life Insurance Employer Contribution 89 223 223 6100 Office Supplies 32 217 200 200 6120 Operating Supplies 3,823 6,369 2,200 6,500 4,300 195.5% 6120.103 Operating Supplies Janitorial 1,345 290 1,600 1,000 600) 37.5% 6130.119 Repair Et Maintenance Supplies Recharges 300 300 6140.101 Miscellaneous Supplies Uniforms 328 446 500 500 6500 Employee Development 200 200 6500.100 Employee Development Employee Training 6500.104 Employee Development Conferences Et Seminars 7000 Professional Services 14,501 12,430 20,000 15,000 5,000) 25.0% 7004 Audit Fees 653 916 850 900 50 5.9% 7006 Medical Fees 150 150) 100.0% 7100.100 Communications Postage 320 100 220) 68.8% 2012/2013 Bienniel Budget, City of Plymouth, MN 120 of 138 7/22/2011 City of Plymouth Field House Expense Budget Account Number Description 2009 Actual 2010 Actual 2011 Amended 2012 Proposed 2011-2012 Change % Change 7100.104 Communications Mobile Telephone 7200 Printing and Publishing 52 700 200 500) 71.4% 7400.102 Utilities Natural Gas 17,331 20,752 63,500 25,000 38,500) 60.6% 7400.103 Utilities Water and Sewer 7400.104 Utilities Solid Waste 662 788 950 1,000 50 5.3% 7400.108 Utilities Electric 25,944 30,607 32,000 35,000 3,000 9.4% 7500.104 Repair and Maintenance Services Electrical 717 500 1,000 500 100.0% 7500.130 Repair and Maintenance Services Building Mainten 5,956 1,612 1,600 2,000 400 25.0% 7500.202 Repair and Maintenance Services Equipment Maint 3,564 3,395 3,200 3,500 300 9.4% 7600 Rentals 4,768 4,729 9,410 6,000 3,410) 36.2% 8000 Non -Cap Equip (< 5K) 3,619 2,424 8100 Capital Outlay (> 5K) 3,200 3,200) 100.0% 8100.100 Capital Outlay (> 5K) Land 8100.300 Capital Outlay (> 5K) Buildings 8100.400 Capital Outlay (> 5K) Improv Other Than Buildings 8100.500 Capital Outlay (> 5K) Machinery and Equipment 5,000 5,000) 100.0% 8500 Depreciation 98,028 57,354 9000.100 Allocations Photocopying 198 198 198) 100.0% 9000.101 Allocations Information Technology 4,913 4,913 4,913 478 4,435) 90.3% 9000.102 Allocations Facilities Management 1,169 1,169 1,169 1,599 430 36.8% 9000.104 Allocations Mobile Phone 329 329 9000.106 Allocations Telephone 344 344 344 344) 100.0% 9000.108 Allocations Internal Rental Charges 9,410 9500 Allocations Risk Management 8,083 8,083 9500.100 Transfers Out 103,819 141,873 38,054 36.7% 9500.630 Transfers Out General 3,824 3,824 3,824 3,824 9500.640 Transfers Out Risk Management 1,900 1,900 1,900 1,900) 100.0% 9900 Transfers Out Employee Benefits 9917 Miscellaneous 357 2012/2013 Bienniel Budget, City of Plymouth, MN 121 of 138 7/22/2011 City of Plymouth Field House Expense Budget 2012/2013 Bienniel Budget, City of Plymouth, MN 122 of 138 7/22/2011 2011-2012 Account 2011 Number Description 2009 Actual 2010 Actual Amended 2012 Proposed Change % Change 9920 Bad Debt 9920 Bank Fees 658 933 500 - 500) -100.0% 9920.100 Bank Fees Credit Card Fees 1,000 1,000 Total Expenditures 298,255 $ 259,366 $ 368,025 $ 363,500 4,525) 2012/2013 Bienniel Budget, City of Plymouth, MN 122 of 138 7/22/2011 City of Plymouth Central Equipment Revenue Budget 2011-2012 Account 2012 Number Account Description 2009 Actual 2010 Actual 2011 Amended Proposed $ Change % Change 4290 Intergovernmental -Other 4300 Charges for Services 11,798 13,220 4380.303 Allocation Charges Central Equipment 2,416,023 2,373,903 2,418,204 2,556,000 137,796 4620 Contributions - Capital 48,875 4700 Interest Income 4700.100 Interest Income Investments 39,923 17,240 29,322 20,000 9,322) 4800 Other Revenues 1,393 1,253 4802 Property Claims 4804 Sale of Asset 89,862 95,913 4805 Gain (Loss) of Capital Asset 12,004 9,083) 4807 Refunds &t Reimbursements 61 2,088 4900 Transfers In 340,663 298,133 42,530) 4900.100 Transfers In General 94,627 4900.254 Transfers In HRA Section 8 4900.403 Transfers In Bldg and Equip Revolving 4900.406 Transfers In Street Reconstruction 4900.500 Transfers In Water 4,771 4900.510 Transfers In Water Resources 4900.520 Transfers In Sewer 4,771 4900.540 Transfers In Ice Center 4900.610 Transfers In Public Facilities 4900.630 Transfers In Risk Management 16,824 Total Revenues 2,675,231 2,560,231 2,788,189 $ 2,874,133 $ 85,944 5.7% 31.8% 12.5% 2012/2013 Bienniel Budget, City of Plymouth, MN 123 of 138 7/22/2011 City of Plymouth Central Equipment Expense Budget 2011-2012 Account 2011 Number Description 2009 Actual 2010 Actual Amended 2012 Proposed Change Change 6000 Salaries 5,481 6000.100 Salaries Regular 218,509 196,028 206,403 256,465 50,062 24.3% 6000.200 Salaries Temporary 3,312 4,428 5,500 5,500 6020 Overtime 386 6020.100 Overtime Regular 15,681 19,327 25,000 25,000 6050 Benefits 1,663 48,450 62,375 13,925 28.7% 6050.100 Benefits Social Security 17,763 12,513 14,827 17,795 2,968 20.0% 6050.101 Benefits Medicare 3,368 2,926 3,460 4,165 705 20.4% 6050.200 Benefits PERA 20,282 14,448 14,959 20,410 5,451 36.4% 6050.201 Benefits Deferred Compensation 2,619 2,212 2,260 2,260 6050.300 Benefits Life 6050.302 Benefits Unemployment 6050.303 Benefits Workers Compensation 6050.400 Benefits Dept'l Insurance Allocation 6060 Medical Insurance 32,916 19,752 6060.100 Medical Insurance Employer Contribution 12,280 6070 Dental Insurance 2,325 1,179 6070.100 Dental Insurance Employer Contribution 734 6080 Group Life Insurance 287 157 6080.100 Group Life Insurance Employer Contribution 102 260 500 240 92.3% 6100 Office Supplies 1,085 1,076 500 500) 100.0% 6120.102 Operating Supplies Motor Fuels Et Lubricants 354,467 451,297 500,000 665,000 165,000 33.0% 6120.103 Operating Supplies Janitorial 248 9 200 200 6120.111 Operating Supplies License Plates 439 2,290 340 2,400 2,060 605.9% 6130 Repair Et Maintenance Supplies 6130.100 Repair Et Maintenance Supplies Equipment Parts 169,957 172,654 180,000 180,000 6130.105 Repair Et Maintenance Supplies Paint 6130.109 Repair Et Maintenance Supplies Welding 1,189 4,386 3,000 3,500 500 16.7% 6130.111 Repair Et Maintenance Supplies Chemicals 3,215 3,304 3,500 3,500 2012/2013 Bienniel Budget, City of Plymouth, MN 124 of 138 7/22/2011 City of Plymouth Central Equipment Expense Budget Account Number Description 6130.119 Repair Et Maintenance Supplies Recharges 6140 Miscellaneous Supplies 6140.100 Miscellaneous Supplies Medical 6140.101 Miscellaneous Supplies Uniforms 6140.102 Miscellaneous Supplies Safety Equipment 6500.100 Employee Development Employee Training 6500.104 Employee Development Conferences Et Seminars 6550 Mileage Et Parking Reimbursement 6700 Dues and Subscriptions 7000 Professional Services 7004 Audit Fees 7006 Medical Fees 7017 Laundry Services 7100.100 Communications Postage 7100.104 Communications Mobile Telephone 7200 Printing and Publishing 7400.102 Utilities Natural Gas 7400.103 Utilities Water and Sewer 7400.104 Utilities Solid Waste 7400.108 Utilities Electric Repair and Maintenance Services Janitorial 7500.118 Services 7500.125 Repair and Maintenance Services Car Washes Repair and Maintenance Services Building 7500.130 Maintenance 500 Repair and Maintenance Services Body Work and 7500.131 Painting 1,526 Repair and Maintenance Services Equipment 7500.202 Maintenance 2012/2013 Bienniel Budget, City of Plymouth, MN 2011-2012 2011 2009 Actual 2010 Actual Amended 2012 Proposed $ Change % Change 317 1,375 3,000 2,000 1,000) 33.3% 576 765 1,000 1,000) 100.0% 753 657 1,000 1,000 1,500 1,500) 100.0% 200 200) 100.0% 35 2,400 2,400 15,224 29,615 2,176 160 500 500) 100.0% 1,526 1,403 2,200 2,400 200 9.1% 125 43 200 200 266 2,092 1,500 1,500 14,482 12,028 29,000 15,000 14,000) 48.3% 3,673 4,088 3,200 4,200 1,000 31.3% 597 372 3,600 1,000 2,600) 72.2% 11,229 10,411 12,400 15,000 2,600 21.0% 4,301 4,400 99 2.3% 4,090 4,482 5,500 5,500 - 988 - - - 1,789 11,015 10,000 10,000 80,347 91,193 85,000 85,000 125 of 138 7/22/2011 City of Plymouth Central Equipment Expense Budget Account Number Description 2009 Actual 2010 Actual 2011 Amended 2012 Proposed 2011-2012 Change % Change 8000 Non -Cap Equip (< 5K) 9,894 9,134 20,000 15,000 5,000) 25.0% 8100 Capital Outlay (> 5K) 8100.500 Capital Outlay (> 5K) Machinery and Equipment 1,056,367 1,523,200 1,271,400 251,800) 16.5% Capital Outlay (> 5K) Capitalize Machinery and 8100.550 Equip 1,056,367) 8100.800 Capital Outlay (> 5K) Construction Projects 8500 Depreciation 1Y153,387 1,128,433 9000.101 Allocations Information Technology 28,804 28,804 28,804 50,999 22,195 77.1% 9000.102 Allocations Facilities Management 11,563 22,676 26,380 18,705 7,675) 29.1% 9000.104 Allocations Mobile Phone 1,402 1,402 1,040 1,040) 100.0% 9000.106 Allocations Telephone 3,155 3,155 3,155 3,155) 100.0% 9000.110 Allocations Risk Management 119,359 119,359 9500 Transfers Out 9500.100 Transfers Out General 9500.408 Transfers Out Park Const Dedication Fees 9500.620 Transfers Out Information Technology 9500.630 Transfers Out Risk Management 10,450 10,450 10,450 10,450) 100.0% 9500.640 Transfers Out Employee Benefits Total Expenditures 2,204,632 $ 2,302,259 2,788,189 2,874,133 85,944 2012/2013 Bienniel Budget, City of Plymouth, MN 126 of 138 7/22/2011 Account Number Account Description 4380.107 Allocation Charges Postage 4380.302 Allocation Charges Facilities Management 4700.100 Interest Income Investments 4800 Other Revenues 4802 Property Claims 4900 Transfers In 4900.100 Transfers In General 4900.403 Transfers In Bldg and Equip Revolving 4900.406 Transfers In Street Reconstruction 4900.640 Transfers In Employee Benefits 4900.660 Transfers In Resource Planning City of Plymouth Public Facilities Revenue Budget 2011-2012 2009 Actual 2010 Actual 2011 Amended 2012 Proposed $ Change % Change 57,114 $ 58,193 $ 70,000 $ - $ (70,000) -100.0% 1,141,188 1,445,338 1,546,720 1,546,720 - 26,467 11,810 20,150 20,000 (150) -0.7% 116 - - - 246,044 246,044 140,000 - - - Total Revenues $ 1,224,769 $ 1,655,456 $ 1,636,870 $ 1,812,764 $ 175,894 2012/2013 Bienniel Budget, City of Plymouth, MN 127 of 138 7/22/2011 City of Plymouth Public Facilities Expense Budget 2011-2012 Account 2011 Number Description 2009 Actual 2010 Actual Amended 2012 Proposed Change Change 6000 Salaries 4,599 6000.100 Salaries Regular 126,936 124,146 128,110 128,486 376 0.3% 6020.100 Overtime Regular 432 1,000 1,000 6050 Benefits 1,201 21,931 23,028 1,097 5.0% 6050.100 Benefits Social Security 8,286 7,757 8,080 8,029 51) 0.6% 6050.101 Benefits Medicare 1,800 1,814 1,880 1,878 2) 0.1% 6050.200 Benefits PERA 9,541 8,690 9,290 9,388 98 1.1% 6050.201 Benefits Deferred Compensation 1,160 1,175 1,200 1,200 6050.300 Benefits Life 6050.303 Benefits Workers Compensation 6050.400 Benefits Dept'[ Insurance Allocation 6060 Medical Insurance 17,534 10,570 6060.100 Medical Insurance Employer Contribution 6,476 6070 Dental Insurance 1,620 1,478 6070.100 Dental Insurance Employer Contribution 918 6080 Group Life Insurance 486 315 6080.100 Group Life Insurance Employer Contribution 204 510 510 6100 Office Supplies 6,992 6,654 500 500) 100.0% 6100.100 Office Supplies Coffee and Cups 16,214 157 6120 Operating Supplies 200 200 6120.103 Operating Supplies Janitorial 31,560 28,181 30,000 32,000 2,000 6.7% 6130.100 Repair Et Maintenance Supplies Equipment Parts 6130.119 Repair Et Maintenance Supplies Recharges 4,230 680 1,500 1,500 6140.100 Miscellaneous Supplies Medical 5,906 5,975 8,000 8,000 6140.101 Miscellaneous Supplies Uniforms 6140.102 Miscellaneous Supplies Safety Equipment 1,826 127 300 300 6500 Employee Development 6500.100 Employee Development Employee Training 6500.104 Employee Development Conferences Et Seminars 2012/2013 Bienniel Budget, City of Plymouth, MN 128 of 138 7/22/2011 Account Number Description City of Plymouth Public Facilities Expense Budget 2011 2009 Actual 2010 Actual Amended 2012 Proposed 2011-2012 Change % Change 6700 Dues and Subscriptions 20 500 500 7000 Professional Services 1,122 4,000 4,000 7017 Laundry Services 381 358 600 500 100) 16.7% 7100.100 Communications Postage 54,395 55,428 75,000 5,000 70,000) 93.3% 7100.103 Communications Telephone 7100.104 Communications Mobile Telephone 1,000 1,000) 100.0% 7200 Printing and Publishing 7400.102 Utilities Natural Gas 47,597 41,116 75,000 45,000 30,000) 40.0% 7400.103 Utilities Water and Sewer 10,306 10,624 10,000 10,916 916 9.2% 7400.104 Utilities Solid Waste 8,741 12,011 8,500 13,000 4,500 52.9% 7400.108 Utilities Electric 114,187 112,415 130,000 115,000 15,000) 11.5% 7500 Repair and Maintenance Services Repair and Maintenance Services Janitorial 7500.118 Services 110,799 102,810 125,000 125,000 Repair and Maintenance Services Building 7500.130 Maintenance 202,807 308,238 470,000 300,000 170,000) 36.2% Repair and Maintenance Services Building 7500.135 Security 2,919 8,000 8,000 Repair and Maintenance Services Facility 7500.139 Improvements 141,025 290,353 Repair and Maintenance Services Equipment 7500.202 Maintenance 53,951 53,013 112,000 112,000 Repair and Maintenance Services Street Tree 7500.300 Maintenance 433 7600 Rentals 8000 Non -Cap Equip (< 5K) 20,525 26,595 2,000 2,000 8100.200 Capital Outlay (> 5K) Infrastructure 8100.300 Capital Outlay (> 5K) Buildings 2012/2013 Bienniel Budget, City of Plymouth, MN 129 of 138 7/22/2011 City of Plymouth Public Facilities Expense Budget Account Number Description 2009 Actual 2010 Actual 2011 Amended 2012 Proposed 2011-2012 Change % Change Capital Outlay (> 5K) Improv Other Than 8100.400 Buildings 49,500 8100.450 Capital Outlay (> 5K) Capitalize Improvements 49,500) 8100.500 Capital Outlay (> 5K) Machinery and Equipment 14,934 Capital Outlay (> 5K) Capitalize Machinery and 8100.550 Equip 14,934) 8100.600 Capital Outlay (> 5K) Software 8100.800 Capital Outlay (> 5K) Construction Projects 150,000 820,000 670,000 446.7% 8500 Depreciation 7,681 14,296 9000.100 Allocations Photocopying 325 325 325) 100.0% 9000.101 Allocations Information Technology 15,644 15,644 15,644 15,142 502) 3.2% 9000.102 Allocations Facilities Management 2,770 2,770 9000.104 Allocations Mobile Phone 1,274 547 1,146 1,146) 100.0% 9000.106 Allocations Telephone 1,147 1,147 1,147 1,147) 100.0% 9000.107 Allocations Central Equipment 7,771 7,806 8,000 194 2.5% 9000.108 Allocations Internal Rental Charges 7,664 9000.110 Allocations Risk Management 10,417 10,417 9500 Transfers Out 222,151 222,151) 100.0% 9500.400 Transfers Out General Capital Projects 9500.413 Transfers Out Improvement Project Construction 17,003 9500.500 Transfers Out Water 28,952 27,768 9500.600 Transfers Out Central Equipment 9500.630 Transfers Out Risk Management 4,750 4,750 4,750 4,750) 100.0% Total Expenditures 1,086,293 1,297,882 1,636,870 1,812,764 175,894 2012/2013 Bienniel Budget, City of Plymouth, MN 130 of 138 7/22/2011 City of Plymouth Information Technology Revenue Budget Account Number Account Description 2009 Actual 2010 Actual 2011 Amended 2012 Proposed 2011-2012 Change % Change 4300 Charges for Services 2,574 1,734 4350.100 General Services Photocopies 121 8 4350.101 General Services Maps Et Ordinances 4380 Allocation Charges 4380.101 Allocation Charges IT Overhead 1,077,368 1,075,188 1,075,588 1,664,651 589,063 54.8% 4380.102 Allocation Charges Software Maintenance 138,131 138,126 138,126 138,126) 100.0% 4380.103 Allocation Charges Hardware Replacement 348,083 348,083 348,083 348,083) 100.0% 4380.104 Allocation Charges Mobile Phone 112,841 90,876 79,675 79,675) 100.0% 4380.105 Allocation Charges Telephone 152,028 150,524 150,557 150,557) 100.0% 4380.106 Allocation Charges Photocopy 112,464 126,953 127,403 127,403) 100.0% 4380.107 Allocation Charges Postage 70,000 70,000 4380.108 Allocation Charges 800 MHz Radios 185,666 189,380 168,626 20,754) 11.0% 4380.201 Allocation Charges Dental 4380.301 Allocation Charges Engineering 4380.400 Allocation Charges Security Systems Replacement 101,753 101,897 102,043 102,043) 100.0% 4600 Contributions - Operating 3,775 4620 Contributions - Capital 6,000 4700 Interest Income 4700.100 Interest Income Investments 32,481 15,665 26,796 26,796) 100.0% 4800 Other Revenues 267 1,320 4804 Sale of Asset 550 300 4805 Gain (Loss) of Capital Asset 5,792) 4807 Refunds Et Reimbursements 355 445 4807.100 Refunds Et Reimbursements Cell Phone 4900 Transfers In 11,733 11,733) 100.0% 4900.100 Transfers In General 4900.220 Transfers In Transit System 4900.254 Transfers In HRA Section 8 3,500 6,000 4900.400 Transfers In General Capital Projects 4900.403 Transfers In Bldg and Equip Revolving 2012/2013 Bienniel Budget, City of Plymouth, MN 131 of 138 7/22/2011 Account Number Account Description City of Plymouth Information Technology Revenue Budget 2011-2012 2012 2009 Actual 2010 Actual 2011 Amended Proposed $ Change % Change 4900.405 Transfers In Park Replacement 4900.406 Transfers In Street Reconstruction 4900.412 Transfers In Utility Trunk Replacement 4900.416 Transfers In Public Safety Expansion - - - 4900.500 Transfers In Water 10,000 10,000 10,000 - (10,000) 4900.660 Transfers In Resource Planning - - - 56,535 56,535 Total Revenues $ 2,102,290 $ 2,246,994 $ 2,259,384 $ 1,959,812 $ (299,572) 100.0% 2012/2013 Bienniel Budget, City of Plymouth, MN 132 of 138 7/22/2011 City of Plymouth Information Technology Expense Budget 2011-2012 Account 2011 Number Description 2009 Actual 2010 Actual Amended 2012 Proposed Change Change 6000 Salaries 19,097 6000.100 Salaries Regular 576,790 562,309 584,860 573,130 11,730) 2.0% 6020.100 Overtime Regular 6050 Benefits 4,581 64,861 63,000 1,861) 2.9% 6050.100 Benefits Social Security 36,745 33,922 36,650 35,535 1,115) 3.0% 6050.101 Benefits Medicare 8,072 7,976 8,600 8,310 290) 3.4% 6050.200 Benefits PERA 41,868 39,362 42,410 41,555 855) 2.0% 6050.201 Benefits Deferred Compensation 8,324 8,930 8,650 8,650 6050.300 Benefits Life 6050.301 Benefits Long Term Disability 6050.302 Benefits Unemployment 6050.303 Benefits Workers Compensation 6050.400 Benefits Dept'[ Insurance Allocation 6060 Medical Insurance 53,753 34,925 6060.100 Medical Insurance Employer Contribution 21,677 6070 Dental Insurance 3,023 1,894 6070.100 Dental Insurance Employer Contribution 1,366 6080 Group Life Insurance 2,289 1,495 6080.100 Group Life Insurance Employer Contribution 962 2,460 2,300 160) 6.5% 6100 Office Supplies 21,365 20,927 46,000 46,000 6110 Computer Supplies 2,390 2,397 2,500 2,500 6130 Repair Et Maintenance Supplies 376 6130.100 Repair Et Maintenance Supplies Equipment Parts 3,217 4,102 11,000 13,000 2,000 18.2% 6500 Employee Development 1,250 3,971 20,000 20,000) 100.0% 6500.100 Employee Development Employee Training 21,065 2,221 42,000 21,000 21,000) 50.0% 6500.101 Employee Development City wide Training 1,650 514 4,000 4,000 6500.104 Employee Development Conferences Et Seminars 2,778 5,100 6,240 6,240 6550 Mileage Et Parking Reimbursement 93 100 100 6600 Meetings 2012/2013 Bienniel Budget, City of Plymouth, MN 133 of 138 7/22/2011 City of Plymouth Information Technology Expense Budget Account Number Description 2009 Actual 2010 Actual 2011 Amended 2012 Proposed 2011-2012 Change % Change 6700 Dues and Subscriptions 1,151 449 795 875 80 10.1 7000 Professional Services 52,601 81,759 116,000 82,000 34,000) 29.3% 7006 Medical Fees 7100 Communications 225 7100.100 Communications Postage 392 45 450 70,450 70,000 15555.6% 7100.102 Communications Data Communications 90,609 91,044 97,206 92,000 5,206) 5.4% 7100.103 Communications Telephone 42,529 37,237 53,000 38,000 15,000) 28.3% 7100.104 Communications Mobile Telephone 52,821 48,296 74,600 60,000 14,600) 19.6% 7200 Printing and Publishing 46,568 478 7500 Repair and Maintenance Services 24 7500.130 Repair and Maintenance Services Building Maintenance 7500.200 Repair and Maintenance Services Software 269,957 191,947 301,065 278,500 22,565) 7.5% 7500.201 Repair and Maintenance Services Departmental 23,523 84,565 109,393 95,650 13,743) 12.6% Software Maint 7500.202 Repair and Maintenance Services Equipment 82,436 133,500 161,041 130,800 30,241) 18.8% Maintenance 7600 Rentals 684 8000 Non -Cap Equip (< 5K) 245,577 82,975 118,975 160,300 41,325 34.7% 8100.500 Capital Outlay (> 5K) Machinery and Equipment 33,479 8100.550 Capital Outlay (> 5K) Capitalize Machinery and 33,479) Equip 8100.600 Capital Outlay (> 5K) Software 35,076 15,000 15,460 460 3.1% 8100.650 Capital Outlay (> 5K) Capitalize Software 35,076) 8100.800 Capital Outlay (> 5K) Construction Projects 270,000 270,000) 100.0% 8500 Depreciation 290,665 281,209 9000.100 Allocations Photocopying 9000.101 Allocations Information Technology 9000.102 Allocations Facilities Management 46,408 59,479 63,836 60,012 3,824) 6.0% 2012/2013 Bienniel Budget, City of Plymouth, MN 134 of 138 7/22/2011 2012/2013 Bienniel Budget, City of Plymouth, MN 135 of 138 7/22/2011 City of Plymouth Information Technology Expense Budget 2011-2012 Account 2011 Number Description 2009 Actual 2010 Actual Amended 2012 Proposed Change % Change 9000.104 Allocations Mobile Phone 1,692 1,692) -100.0% 9000.107 Allocations Central Equipment 6,000 6,000 9000.110 Allocations Risk Management 11,626 11,626 9500 Transfers Out 30,319 30,319 9500.540 Transfers Out Ice Center 17,495 9500.620 Transfers Out Information Technology 9500.640 Transfers Out Employee Benefits 9900 Miscellaneous 1,643 9912 Research Et Development 2,500 2,500 Total Expenditures $ 2,049,272 $ 1,871,795 $ 2,259,384 $ 299,572) 1,959,812 2012/2013 Bienniel Budget, City of Plymouth, MN 135 of 138 7/22/2011 City of Plymouth Risk Management Revenue Budget 2011-2012 Account 2012 Number Account Description 2009 Actual 2010 Actual 2011 Amended Proposed $ Change % Change 4380 Allocation Charges $ 1,082,021 1,082,021 4600 Contributions - Operating 4700.100 Interest Income Investments 48,088 22,046 37,395 37,395) 4800 Other Revenues 1,175 4802 Property Claims 24,690 19,961 4803 Worker's Comp Claims 5,229 4806 Premium Refunds 113,480 95,269 4807 Refunds & Reimbursements 28,511 104,267 4807.101 Refunds £t Reimbursements Restitution 502 1,757 4900 Transfers In 45,414 45,414) 4900.100 Transfers In General 461,133 467,664 467,664 467,664) 4900.200 Transfers In Recreation 26,955 26,955 26,955 26,955) 4900.220 Transfers In Transit System 4,275 4,361 4,361 4,361) 4900.250 Transfers In Community Dev Block Grant (CDBG) 1,652 1,652 1,652 1,652) 4900.254 Transfers In HRA Section 8 7,843 7,843 7,843 7,843) 4900.258 Transfers In HRA General 3,206 3,206 3,206 3,206) 4900.500 Transfers In Water 50,419 50,419 50,419 50,419) 4900.510 Transfers In Water Resources 24,723 24,723 24,723 24,723) 4900.520 Transfers In Sewer 37,571 37,571 37,571 37,571) 4900.530 Transfers In Solid Waste Management 5,391 5,499 5,609 5,609) 4900.540 Transfers In Ice Center 9,500 9,500 9,500 9,500) 4900.550 Transfers In Field House 1,900 1,900 1,900 1,900) 4900.600 Transfers In Central Equipment 10,450 10,450 10,450 10,450) 4900.610 Transfers In Public Facilities 4,750 4,750 4,750 4,750) 4900.640 Transfers In Employee Benefits 4900.650 Transfers In Design Engineering 6,531 Total Revenues $ 876,798 $ 900,968 $ 739,412 $ 1,082,021 342,609 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 2012/2013 Bienniel Budget, City of Plymouth, MN 136 of 138 7/22/2011 City of Plymouth Risk Management Expense Budget 2011-2012 Account 2011 Number Description 2009 Actual 2010 Actual Amended 2012 Proposed Change Change 6000 Salaries 2,153 6000.100 Salaries Regular 61,039 61,069 65,398 70,470 5,072 7.8% 6050 Benefits 524 8,152 10,000 1,848 22.7% 6050.100 Benefits Social Security 3,750 3,661 4,081 4,370 289 7.1% 6050.101 Benefits Medicare 869 878 958 1,025 67 7.0% 6050.200 Benefits PERA 4,473 4,275 4,747 5,110 363 7.6% 6050.201 Benefits Deferred Compensation 411 415 427 427 6060 Medical Insurance 6,417 4,154 6060.100 Medical Insurance Employer Contribution 2,578 6070 Dental Insurance 887 554 6070.100 Dental Insurance Employer Contribution 344 6080 Group Life Insurance 330 220 6080.100 Group Life Insurance Employer Contribution 144 296 350 54 18.2% 6100 Office Supplies 642 206 200 200 6140.102 Miscellaneous Supplies Safety Equipment 9,184 6140.103 Miscellaneous Supplies Ergonomic Equipment 300 300 6500 Employee Development 6500.100 Employee Development Employee Training 390 120 500 500 6500.104 Employee Development Conferences Et Seminars 175 120 500 500 6500.200 Employee Development Wellness 100 6550 Mileage Et Parking Reimbursement 112 100 100 6700 Dues and Subscriptions 765 425 700 700 7000 Professional Services 41,730 28,465 40,000 40,000 7300.100 Insurance Property 47,172 243,754 160,000 139,326 20,674) 12.9% 7300.101 Insurance Inland Marine 148,331 19,730 19,467 22,318 2,851 14.6% 7300.102 Insurance General Liability 119,764) 193,770 140,000 120,717 19,283) 13.8% 7300.103 Insurance Auto Liability 15,001) 36,682 14,600 13,956 644) 4.4% 7300.104 Insurance Auto Comprehensive 551 33,773 28,665 28,665 7300.105 Insurance Auto Collision 55,358 6,354 35,720 35,720) 100.0% 2012/2013 Bienniel Budget, City of Plymouth, MN 137 of 138 7/22/2011 City of Plymouth Risk Management Expense Budget Account Number Description 2009 Actual 2010 Actual 2011 Amended 2012 Proposed 2011-2012 Change % Change 7300.107 Insurance Boiler and Machinery 20,914 38,471 21,541 21,682 141 0.7% 7300.108 Insurance Information Technology 4,681 4,836 4,275 4,836 561 13.1 7300.110 Insurance Employee Dishonesty 2,785 3,248 2,900 2,575 325) 11.2% 7300.201 Insurance Workers Comp 287,389 352,246 200,000 206,000 6,000 3.0% 7600 Rentals 8000 Non -Cap Equip (< 5K) 9000.100 Allocations Photocopying 325 325 325 325) 100.0% 9000.101 Allocations Information Technology 3,683 3,683 3,683 3,825 142 3.9% 9000.102 Allocations Facilities Management 4,208 3,334 3,043 5,376 2,333 76.7% 9000.106 Allocations Telephone 373 373 373 373) 100.0% 9000.108 Allocations Internal Rental Charges 1,720 9000.110 Allocations Risk Management 9500 Transfers Out 378,693 378,693 9500.600 Transfers Out Central Equipment 16,824 9500.640 Transfers Out Employee Benefits 7,426 7,426 7,426 7,426) 100.0% 9923 Claims 8,593 5,000 Total Expenditures 589,921 1,080,234 739,412 1,082,021 342,609 2012/2013 Bienniel Budget, City of Plymouth, MN 138 of 138 7/22/2011 2008-2012 Allocation Summary Budgets 2011 2,418,204 340,663 5,955,338 Actuals 6,924,064 1,546,720 70,000 2008 2009 2010 600 Central Equipment 4,436,629 5,278,058 Total GF % 4380 - Allocation Charges 2,010,984 2,416,023 2,373,903 4900 - Transfers In 132,437 104,168 16,824 13.83% 2,143,420 2,520,191 2,390,727 610 Public Facilities 4380 - Allocation - Other 1,091,510 1,141,188 1,445, 338 4380.107 - Postage Alloc. 68,743 57,114 58,193 4900 - Transfers In 13,142 140,000 1,173,396 1,198,302 1,643,531 620 Information Technology 4380 - Allocation Charges 1,976,293 2,042,667 2,217,313 4380.107 - Postage Alloc. 4900 - Transfers In 29,863 13,500 16,000 2,006,156 2,056,167 2,233,313 630 Risk Management 4380 - Allocation Charges 4900 - Transfers In 632,365 656,299 656,493 632,365 656,299 656,493 Budgets 2011 2,418,204 340,663 5,955,338 6,430,960 6,924,064 1,546,720 70,000 1,546,720 1,616,720 Total GF $ 4,085,048 4,436,629 5,278,058 Total GF % 68.59% 68.99% 76.23% Total GF Expenditures 29,528,847 27,855,731 29,767,198 Allocation of Total GF Exp 13.83% 15.93% 17.73% Budgets 2011 2,418,204 340,663 2012 2,596,000 2,758,867 2,596,000 1,546,720 70,000 1,546,720 1,616,720 1,546,720 2,210,855 21,733 1,833,277 70,000 2,232,588 1,903,277 702,017 1,082,021 702,017 1,082,021 7,310,192 $ 7,128, 018 4,774,814 6,027,428 65.32% 84.56% 29,591,112 30,234,646 16.14% 19.94% 2012/2013 Bienniel Budget, City of Plymouth, MN 1 of 1 7/21/2011 2412 Public Facilities and Central Equipment Allocations Public Facilities Central Equipment Program/ Fund Description 2011 Budget 2012 Allocation 1,546,720 Difference 2011 Budget 2012 Allocation 2,556,000 Difference 11,100 City Council 39,933 38,933 1,000) 11,000 City Manager 58,607 52,689 5,918) 21,000 Communications 12,550 12,236 314) 21,101 Clerk 3,537 4,449 912 21,200 HR 16,430 13,608 2,822) 21,300 Finance 52,902 59,549 6,647 21,400 Assessing 31,909 31,925 16 8,788 15,000 6,212 31,000 CD Admin 15,745 17,308 1,563 1,101 2,174 1,073 31,100 Planning 40,610 35,781 4,829) 734 8,674 7,940 31,201 Building Inspections 53,670 52,326 1,344) 45,876 42,152 3,724) 31,202 Fire Inspections 31,203 Code Inspections 41,000 Park and Rec Admin 72,542 69,579 2,963) 12,778 23,940 11,162 41,001 Volunteer Coodinator 41,100 Park Mntce 64,640 45,833 18,807) 486,266 462,729 23,537) 41,200 Forestry 7,071 5,014 2,057) 22,286 53,331 31,045 71,100 Engineering 70,959 75,114 4,155 29,739 30,000 261 71,000 Streets 52,771 37,417 15,354) 637,939 700,000 62,061 51,000 Police Admin 73,197 146,918 73,721 21,859 33,869 12,010 51,100 Patrol 183,051 216,443 33,392 290,397 255,137 35,260) 51,200 Support 96,326 144,537 48,211 42,303 110,994 68,691 51,300 Emerg Mgmt 4,227 3,504 723) 61,000 Fire 290,571 218,958 71,613) 348,194 367,984 19,790 61,100 RAD 32,424 32,016 408) 200 Recreation 16,285 16,760 475 220 Transit 6,435 7,386 951 250 CDBG 4,104 4,002 102) 1,265 1,265) 254 Section 8 4,567 4,452 115) 258 HRA -General 12,284 11,976 308) 412 Utility Trunk 500 Water 87,861 60,825 27,036) 138,583 135,144 3,439) 510 Water Resources 14,171 10,849 3,322) 139,482 135,141 4,341) 520 Sewer 17,472 14,591 2,881) 123,137 129,715 6,578 530 Solid Waste 6,435 5,161 1,274) 6,870 2,000 4,870) 540 Ice Arena 6,627 12,692 6,065 3,416 2,000 1,416) 550 Field House 1,169 1,599 430 610 Facilities 2,225 2,225 7,806 8,000 194 600 Central Equipment 26,380 18,705 7,675) 630 RiskMgmt 3,043 5,376 2,333 620 IT 63,836 60,012 3,824) 6,000 6,000 41,300 Plymouth Creek 34,803 27,987 6,816) 4,034 4,034) TOTALI 1,546,720 1 1,546,720 0) 2,405,277 2,556,000 150,723 General Fund Impact 1,241,248 1 1,282,121 1 40,873 1 1,948,260 1 2,105,984 1 157,724 rp) INFORMATION TECHNOLOGY ALLOCATION PHILOSOPHY 1 Overall - allocation amounts are based on prior year (2010) actual expenses, adding 2% inflationary factor for 2012, and an additonal 3% inflationary factor for 2013, unless otherwise specified. 1 Overhead - allocation is based on number computers each division has, per IT's inventory. The allocation is split this way because the more computers a division has, the greater the anticipated need for day to day maintenance on the machines, thus the more time the IT dept. has to spend supporting those divisions. Overhead expenses include: Personal Services Materials & Supplies: 6110 - Computer supplies, 6130 - Repair & maint supplies, 6130.100 - Equip parts Employee Development & Meetings Dues & subscriptions Contractual services: 7000 - Professional services, 7006 - Medical Fees, 7100 - Communications, 7100.100 - Postage, 7100.102 - Data communications, 7200 - Printing & publishing, 7500 - Repair & maint services, 7500.130 - Building maint, 7600 - Rentals Allocations Transfers Other 2 Telephone - allocation is based on the number of phones each division has, per IT's inventory. The allocation includes the monthly phone bill, a 2 year maintenance contract (paid in full the first year), and CIP of a Citywide phone system replacement. Per the CIP document this purchase will take place in 2016. Mobile Phone - allocation is based on the number of cell phones each division has, per IT's inventory. The allocation includes the monthly bill and cell phone replacement of $7200 for phones and accessories per year. Because the IT dept wants to track the cost of their cell phone usage, they have chosen to include their dept in the allocation. This allocation is then included in the overhead allocation to departments. Per our cell phone contract, if a phone lasts 2 years, the replacement is free, which is why only the cost of 20 phones plus accessories are budgeted each year. (20 phones x $300 per phone + 40 purchases x $30 each for accessories). 4 Photocopier - allocation is based on the number of copiers in a division's area, per IT's inventory. The allocation includes the paper supply, maintenance contracts, and the replacement cost of each copier. Replacement cost is broken out based on the specific copier associated with the division. 5 Printer - allocation is based on the printer(s) in each division's area, per IT's inventory. The allocation includes the replacement cost specific to each printer and the maintenance contract. 6 Computer - allocation is based on the number and type of computer each division is assigned, per IT's inventory. 7 Security - allocation has not been included, as there are currently no on-going expenses related to security, per Greg. 8 CIP - allocation is based on the specific items per the CIP document and allocated to the applicable benefiting division. 9 Other - allocation is specific to the benefiting division. The allocation includes the remaining line items in the budget. These are broken out in detail to determine what the costs are that make up the line item in the budget, these costs are identified by which division(s) benefit. Other line items include: 7500.200 - Repair & Maintenance Services, software 7500.201- Repair & Maintenance Services, department software maintenance 7500.202 - Repair & Maintenance Services, equipment maintenance 8000 - Non -capital equipment (under $5,000). 1 of 4 7/20/2011 2012 - 2013 Budget Allocation - Information Technology Comaarison between 2011 allocations and Proaosed 2012, 20131T allocation: TOTAL: 2,021,475 2,154,102 2,140,941 132,627 7% 1,664,651 1,651,490 (356,824) -18% 2 of 4 7/20/2011 TOTAL 2011 TOTAL 2012 TOTAL 2013 2011 v. 2012 Allocation 2012 2013 2011 v. 2012 Adjusted PROGRAM BUDGETED BUDGETED BUDGETED Change ADJUSTED ADJUSTED Allocation Change DIVISION FUND CODE ALLOCATION ALLOCATION ALLOCATION Change Change ALLOCATION ALLOCATION Change Change City Manager 100 10-110-11000 115,178 26,062 25,787 89,116) 77% 20,140 19,891 95,038) 83% Mayor/Council 100 10-111-11100 11,718 32,394 32,002 20,676 176% 25,034 24,686 13,316 114% Communications 100 20-210-21000 9,716 27,862 27,748 18,146 187% 21,531 21,405 11,815 122% City Clerk 100 20-211-21101 612 61,059 60,236 60,447 9877% 47,186 46,465 46,574 7610% HR 100 20-212-21200 15,712 25,958 25,688 10,246 65% 20,060 19,815 4,348 28% Finance 100 20-213-21300 23,519 130,489 128,892 106,970 455% 100,840 99,425 77,321 329% Assessing 100 20-214-21400 28,567 65,811 65,113 37,244 130% 50,857 50,227 22,290 78% Admin Services - Admin 100 20-215-21500 27,681 27,236 27,681 21,391 21,010 21,391 0% Risk Management 630 20-261-26100 4,381 4,949 5,010 568 13% 3,825 3,865 556) 13% CD - Admin 100 30-310-31000 78,228 44,207 43,575 34,021) 43% 34,163 33,613 44,065) 56% Planning 100 30-311-31100 25,506 37,420 36,906 11,914 47% 28,918 28,469 3,412 13% Inspections admin 100 30-312-31200 2,730 2,730) 100% 2,730) 100% Inspections - Constr 100 30-312-31201 23,752 43,280 43,212 19,528 82% 33,446 33,333 9,694 41% Inspections - Fire 100 30-312-31202 5,278 13,064 13,077 7,786 148% 10,096 10,087 4,818 91% Inspections - Code Enf 100 30-312-31203 5,278 4,835 4,822 443) 8% 3,736 3,719 1,542) 29% Inspections - Electrical 100 30-312-31204 5,278 4,835 4,822 443) 8% 3,736 3,719 1,542) 29% CDBG 250 30-320-32000 6,866 10,305 10,234 3,439 50% 7,963 7,895 1,097 16% HRA - Section 8 254 30-320-32050 21,993 21,156 21,053 837) 4% 16,349 16,240 5,644) 26% HRA -General 258 30-320-32080 11,113 10,305 10,234 808) 7% 7,963 7,895 3,150) 28% Park & Rec - Admin 100 40-410-41000 121,008 60,486 60,120 60,522) 50% 46,743 46,376 74,265) 61% 100 40-410-41001 4,897 4,897) 100% 34,591 706% Park Maintenance 100 40-411-41100 79,872 51,098 51,930 28,774) 36% 39,488 40,058 58,013) 73% Forestry 100 40-412-41200 14,700 28,286 28,382 13,586 92% 21,859 21,893 57,071 388% Plymouth Creek Center 100 40-413-41300 14,559 92,874 92,156 78,315 538% 71,771 71,088 31,693 218% Recreation - Admin 200 40-420-42000 78,638 59,851 59,096 18,787) 24% 46,252 45,586 39,682) 50% Ice Center 540 40-450-45000 37,095 50,410 50,207 13,315 36% 38,956 38,729 36,617) 99% Field House 550 40-451-45100 5,455 618 626 4,837) 89% 478 483 160,484 2942% Police - Admin 100 50-510-51000 297,328 214,729 213,864 82,599) 28% 165,939 164,971 31,341) 11% Patrol 100 50-511-51100 214,993 344,194 343,157 129,201 60% 265,987 264,707 120,224) 56% Support 100 50-512-51200 69,588 122,634 120,636 53,046 76% 94,769 93,056 57,525) 83% Emergency Mgmt 100 55-513-51300 2,040 15,610 15,419 13,570 665% 12,063 11,894 76,178 3734% Fire 100 60-610-61000 75,516 101,216 100,622 25,700 34% 78,218 77,619 59,109) 78% Streets 100 70-710-71000 53,080 21,231 22,015 31,849) 60% 16,407 16,982 33,726 64% Engineering 100 70-711-71100 113,085 112,330 111,577 755) 1% 86,806 86,069 99,371) 88% Transit 220 70-720-72000 20,192 17,746 17,643 2,446) 12% 13,714 13,609 76,237 378% Water 500 70-750-75000 196,903 124,781 123,647 72,122) 37% 96,429 95,380 177,175) 90% Water Resources 510 70-751-75100 59,604 25,529 25,382 34,075) 57% 19,728 19,579 42,344) 71% Sewer 520 70-752-75200 97,098 22,335 23,046 74,763) 77% 17,260 17,777 88,690) 91% Solid Waste 530 70-753-75300 17,446 10,880 10,888 6,566) 38% 8,408 8,399 33,553 192% Central Equipment 600 70-760-76001 32,999 65,995 65,318 32,996 100% 50,999 50,385 17,857) 54% Public Facilities 610 70-760-76050 18,262 19,594 19,562 1,332 7% 15,142 15,090 18,262) 100% Information Technology 620 20-260-26000 1,692 1,692) 100% 1,692) 100% TOTAL: 2,021,475 2,154,102 2,140,941 132,627 7% 1,664,651 1,651,490 (356,824) -18% 2 of 4 7/20/2011 2012 - 2013 Budget Allocation - Information Technology 3 of 4 7/20/2011 2012 BUDGETALLOCATIONS 2013 BUDGET ALLOCATIONS 2013 TOTAL 2012 2012 FUND ADJUSTED TOTAL 2013 2013 FUND ADJUSTED PROGRAM OVER TELE BUDGETED BALANCE BUDGET OVER TELE BUDGETED BALANCE BUDGET DIVISION FUND CODE HEAD PHONE MOBILE COPIER PRINTER COMPUTER SECURITY CIP OTHER ALLOCATION CREDIT ADJUST ALLOCATION HEAD PHONE MOBILE COPIER PRINTER COMPUTER SECURITY CIP OTHER ALLOCATION CREDIT ADJ ALLOCATION 10-110-11000 City Manager 100 12,403 618 600 4,949 225 771 4,141 2,355 26,062 5,922) 20,140 12,608 626 600 5,010 226 771 3,543 2,402 25,787 5,895) 19,891 10-111-11100 Mayor/Council 100 16,537 618 600 4,949 1,029 5,521 3,140 32,394 7,361) 25,034 16,810 626 600 5,010 1,029 4,724 3,203 32,002 7,316) 24,686 20-210-21000 Communications 100 12,403 2,164 687 4,949 392 771 4,141 2,355 27,862 6,331) 21,531 12,608 2,192 828 5,010 394 771 3,543 2,402 27,748 6,344) 21,405 20-211-21101 City Clerk 100 33,074 2,473 4,949 501 2,740 11,043 6,280 61,059 13,874) 47,186 33,620 2,505 5,010 506 2,740 9,449 6,405 60,236 13,771) 46,465 20-212-21200 HR 100 12,403 927 4,949 412 771 4,141 2,355 25,958 5,898) 20,060 12,608 939 5,010 414 771 3,543 2,402 25,688 5,873) 19,815 20-213-21300 Finance 100 70,281 4,637 343 3,299 1,408 4,371 23,466 22,682 130,489 29,650) 100,840 71,444 4,697 414 3,340 1,412 4,371 20,078 23,136 128,892 29,467) 99,425 20-214-21400 Assessing 100 33,074 2,473 3,299 2,057 11,043 13,865 65,811 14,953) 50,857 33,620 2,505 3,340 2,057 9,449 14,142 65,113 14,886) 50,227 20-215-21500 Admin Services - Admin 100 16,537 1,237 1,246 5,521 3,140 27,681 6,290) 21,391 16,810 1,252 1,246 4,724 3,203 27,236 6,227) 21,010 20-261-26100 Risk Management 630 4,949 4,949 1,125) 3,825 5,010 5,010 1,145) 3,865 30-310-31000 CD - Admin 100 24,805 3,091 600 216 1,543 8,282 5,669 44,207 10,045) 34,163 25,215 3,131 600 217 1,543 7,086 5,783 43,575 9,962) 33,613 30-311-31100 Planning 100 20,671 1,546 2,875 216 1,286 6,902 3,925 37,420 8,503) 28,918 21,013 1,566 2,917 216 1,286 5,905 4,003 36,906 8,437) 28,469 30-312-31201 Inspections - Constr 100 22,159 2,900 2,301 2,791 144 1,378 7,399 4,208 43,280 9,834) 33,446 22,526 2,937 2,773 2,831 145 1,378 6,331 4,292 43,212 9,879) 33,333 30-312-31202 Inspections - Fire 100 5,623 736 584 2,791 37 350 1,877 1,068 13,064 2,968) 10,096 5,715 745 704 2,831 37 350 1,606 1,089 13,077 2,990) 10,087 30-312-31203 Inspections - Code Enf 100 2,646 346 275 17 165 883 502 4,835 1,098) 3,736 2,690 351 331 17 165 756 512 4,822 1,102) 3,719 30-312-31204 Inspections - Electrical 100 2,646 346 275 17 165 883 502 4,835 1,098) 3,736 2,690 351 331 17 165 756 512 4,822 1,102) 3,719 30-320-32000 CDBG 250 4,134 309 3,266 173 257 1,380 785 10,305 2,341) 7,963 4,203 313 3,307 173 257 1,181 801 10,234 2,340) 7,895 30-320-32050 HRA -Section 8 254 8,268 618 3,365 178 514 2,761 5,451 21,156 4,807) 16,349 8,405 626 3,407 178 514 2,362 5,560 21,053 4,813) 16,240 30-320-32080 HRA - General 258 4,134 309 3,266 173 257 1,380 785 10,305 2,341) 7,963 4,203 313 3,307 173 257 1,181 801 10,234 2,340) 7,895 40-410-41000 Park & Rec - Admin 100 28,939 2,782 1,374 9,898 535 1,800 9,662 5,495 60,486 13,744) 46,743 29,418 2,818 1,655 10,020 537 1,800 8,268 5,605 60,120 13,744) 46,376 40-411-41100 Park Maintenance 100 24,805 1,855 7,212 1,650 359 2,226 8,282 4,710 51,098 11,610) 39,488 25,215 1,879 8,690 1,670 359 2,226 7,086 4,804 51,930 11,872) 40,058 40-412-41200 Forestry 100 12,403 927 1,717 1,650 359 771 5,266 5,193 28,286 6,427) 21,859 12,608 939 2,069 1,670 359 771 4,668 5,297 28,382 6,488) 21,893 40-413-41300 Plymouth Creek Center 100 45,476 6,801 1,374 9,898 434 4,383 13,035 11,473 92,874 21,103) 71,771 46,228 6,889 1,655 10,020 436 4,383 10,843 11,702 92,156 21,068) 71,088 40-420-42000 Recreation - Admin 200 33,074 3,091 343 2,057 12,168 9,118 59,851 13,599) 46,252 33,620 3,131 414 2,057 10,574 9,300 59,096 13,510) 45,586 40-450-45000 Ice Center 540 20,671 4,019 687 9,898 548 1,286 6,539 6,763 50,410 11,454) 38,956 21,013 4,071 828 10,020 550 1,286 5,542 6,898 50,207 11,478) 38,729 40-451-45100 Field House 550 618 618 140) 478 626 626 143) 483 50-510-51000 Police - Admin 100 103,355 9,893 6,525 29,695 2,900 7,111 27,068 28,182 214,729 48,790) 165,939 105,064 10,020 7,863 30,061 2,913 7,111 22,086 28,746 213,864 48,892) 164,971 3 of 4 7/20/2011 4 of 4 7/20/2011 50-511-51100 Patrol 100 148,831 6,801 8,929 8,240 25,646 60,578 85,168 344,194 78,207) 265,987 151,292 6,889 10,760 8,295 25,646 53,404 86,872 343,157 78,451) 264,707 50-512-51200 Support 100 74,416 5,874 8,726 19,489 14,130 122,634 27,865) 94,769 75,646 5,949 8,726 15,902 14,412 120,636 27,579) 93,056 55-513-51300 Emergency Mgmt 100 8,268 3,091 514 2,165 1,570 15,610 3,547) 12,063 8,405 3,131 514 1,767 1,601 15,419 3,525) 11,894 60-610-61000 Fire 100 45,476 8,347 2,061 9,898 2,197 10,340 13,510 9,387 101,216 22,998) 78,218 46,228 8,454 2,483 10,020 2,204 10,340 11,318 9,575 100,622 23,004) 77,619 70-710-71000 Streets 100 8,268 618 4,808 1,650 359 1,197 2,761 1,570 21,231 4,824) 16,407 8,405 626 5,794 1,670 359 1,197 2,362 1,601 22,015 5,033) 16,982 70-711-71100 Engineering 100 57,879 5,256 3,091 3,671 1,527 5,184 19,325 16,398 112,330 25,523) 86,806 58,836 5,323 3,724 3,720 1,529 5,184 16,535 16,726 111,577 25,508) 86,069 70-720-72000 Transit 220 8,268 618 343 3,671 514 2,761 1,570 17,746 4,032) 13,714 8,405 626 414 3,720 514 2,362 1,601 17,643 4,033) 13,609 70-750-75000 Water 500 70,281 2,164 3,778 1,650 521 9,577 23,466 13,345 124,781 28,353) 96,429 71,444 2,192 4,552 1,670 523 9,577 20,078 13,612 123,647 28,268) 95,380 70-751-75100 Water Resources 510 12,403 618 687 3,671 883 771 4,141 2,355 25,529 5,801) 19,728 12,608 626 828 3,720 884 771 3,543 2,402 25,382 5,803) 19,579 70-752-75200 Sewer 520 8,268 309 4,465 1,650 492 2,820 2,761 1,570 22,335 5,075) 17,260 8,405 313 5,380 1,670 494 2,820 2,362 1,601 23,046 5,269) 17,777 70-753-75300 Solid Waste 530 4,134 309 343 3,671 257 1,380 785 10,880 2,472) 8,408 4,203 313 414 3,720 257 1,181 801 10,888 2,489) 8,399 70-760-76001 Central Equipment 600 37,208 2,782 1,374 1,650 115 2,314 12,423 8,129 65,995 14,995) 50,999 37,823 2,818 1,655 1,670 116 2,314 10,630 8,291 65,318 14,933) 50,385 70-760-76050 Public Facilities 610 8,268 618 687 3,671 139 1,880 2,761 1,570 19,594 4,452) 15,142 8,405 626 828 3,720 140 1,880 2,362 1,601 19,562 4,472) 15,090 TOTAL: 1,062,489 92,744 56,062 152,190 23,716 109,047 350,307 307,546 2,154,102 489,451) 1,664,651 1,080,058 93,935 67,185 154,101 23,824 109,047 299,093 313,697 2,140,941 489,451) 1,651,490 4 of 4 7/20/2011 rp RISK MANAGEMENT ALLOCATION -PHILOSOPHY 1 Allocation amounts are based on prior complete year's historical costs. Example: 2012 budget is based on actual 2010 amounts. An inflationary factor of 2% is added to overhead and safety training in 2012, and 3% in 2013. 2 Overhead (expenses that would occur regardless of how many claims the City has in one year). Disregard any one-time, or unusual expenses when calculating overhead costs. These expenses are going to be split out evenly between 6 departments (Admin, CD, P&R, Police, Fire, PW). Within each department, the allocation will be split out equally by division, unless otherwise instructed by the department director. Overhead expenses include: Personal Services Materials & Supplies Employee Development & Meetings Dues & subscriptions Allocations Transfer to Employee Benefits Professional Services - Broker fees Insurance - General Liability Insurance - Employee Dishonesty 3 Professional Services - Safety Training: Per Lisa M. safety training is split as follows: All employees LESS P&R and PW = 15% P&R = 50% of the remaining 85% overall. PW = 50% of the remaining 85% overall. 4 Insurance - Information Technology: 100% goes to IT, and is then allocated as part of the IT overhead expenses. 5 Insurance - Boiler & Machinery, Property, & Inland Marine are based on the insured value of each property. a. If a property's value is considered 100% in a specific area, the full expensed amount will go to that department/division. b. If a property's value is considered split among multiple depts./divs, the value will be split based on the number of employees in each division. 6 Insurance - Auto Liability: 100% goes to Central Equipment. It is then allocated as part of the fund's overhead expenses. 7 Variable expenses are allocated based on the overall actual claim expenses from the previous year. Variable expenses include: Insurance - Auto Comp, Auto Collision and Worker's Comp. a. Claim reserves are determined at year end by our insurance company. b. This amount is held as a liability in Risk Management for the current year (12/31/2010) and following year(2011). c. Each effected division will need to budget their "claim usage" for the following year (2012) to cover all claims paid in prior year (2010). Claim Usage is defined as any claim below the $5,000 deductible amount and/or any deductible amount of $5,000 when a claim exceeds the deductible. 1 of 4 7/20/2011 Risk Management 2012 - 2013 Budget - Revenue Allocations Analysis 2012 Risk Management Allocation 2013 Risk Overhead Insurance - Boiler/Machinery, Property, & Inland Marine Equal between Depts Percent Premium Division Fund 2012 2012 Safety Insurance: Dept Shared of Total Expense 2011 Dept Division Training Dept Assets Assets Employees Premium Alloc Program BUDGET 337.542 56,257 8.634 Specific 140,777 See Below per Div. 110,357 $301,955 2 100 City Manager 11000 70,059 100 City Council, Mayor 11100 - 7 100 Communications 21000 - 100 City Clerk 21100 - 100 Human Resources 21200 - 100 Finanace 21300 - 100 Assessing 21400 - 100 AdminSery - Admin 21500 620 IT - Systems 26000 - 100 CD Admin & Support 31000 56,257 6,251 6,251 6,251 6,251 6,251 6,251 6,251 6,251 6,251 46 27 1.0 0.02% 75 46 191 7.0 0.17% 523 46 82 3.0 0.07% 224 46 136 5.0 0.12% 373 46 82 3.0 0.07% 224 46 286 10.5 0.26% 784 46 191 7.0 0.17% 523 46 46 4,836 8 2010 WC PERC (%) ALLOC 46,429 56,257 9,376 46 352,246 100 CD Planning 31100 0.00% 9,376 46 0.00% 100 CD Inspections 31200 0.00% - 9,376 46 0.00% - 250 Housing & Redev 32000 1,652 9,376 46 0.00% 254 Housing & Redev 32050 7,843 9,376 46 258 Housing & Redev 32080 3,206 9,376 46 0.05% 850 Plymouth Town Sq 32081 0.0 851 Vicksburg 32082 0.00% 7 100 P & R Admin 41000 70,653 56,257 8,037 46 100 P & R Maintenance 41100 0.00% 8,037 1,835 100 P & R Forestry 41200 181,227 8,037 1,835 1.04% 100 P & R PCC 41300 0.27% 8,037 46 200 Rec Admin 42000 26,955 4.0 8,037 46 0.00% 540 Ice Ctr Admin 45000 9,500 164 8,037 46 448 550 Field Hse Admin 45100 1,900 5,858 8,037 46 1 100 Police Admin 51000 200,679 56,257 56,257 46 1 100 Fire Operations 61000 34,436 56,257 56,257 46 9 100 Streets 71000 11,653 6,251 1,223 2,136 100 Engineering 71100 45,408 56,257 6,251 46 39,836 220 Transit 72000 4,361 4,252 6,251 46 4.67% 500 Water 75000 50,419 0.30% 6,251 1,223 232 510 Water Resources 75100 24,723 2.0 6,251 46 0.00% 520 Sewer 75200 37,571 1,083 6,251 1,223 22,317 530 Solid Waste 75300 5,609 6,251 46 0.12% 600 Ctrl Equipment 76001 10,450 6,251 46 36,682 8.0 610 Pub Facilities 76050 4,750 0.79% 6,251 46 35 1.0 0.03% 97 656,603 337,542 337,542 8,634 41,518 1. Risk Mgmt allocations have been recognized as transfers in/out in all past budgets. 2. Allocations are budgeted at the admin program level unless otherwise specified by applicable director. 3. Employees per division are from the 2011 budget document. 4. Process to break out dept specific claims did not start until 12/2010, therefore not included in this allocation 5. 2012 overhead and safety training is calculated by 2010 actual plus 2% inflationary. 6. 2013 overhead and safety training is calculated by 2012 budget plus 3% inflationary. 2010 AUTO 2010 WC PERC (%) ALLOC PERC (%) ALLOC AUTO 40,127 WC 352,246 0.00% - 0.00% 4.0 0.00% - 0.00% 0.00% 0.00% - 0.00% 0.00% - 2.90% 10,217 0.00% - 0.00% 0.00% - 0.00% 0.00% - 0.00% 27 1.0 0.02% 75 1 0.00% - 0.00% - 180 6.6 0.16% 493 0.00% - 0.00% - 191 7.0 0.17% 523 0.00% 0.00% 109 4.0 0.10% 299 0.00% 0.00% 327 12.0 0.30% 896 0.00% 0.27% 937 0.0 0.00% 0.00% 0.00% 0.0 0.00% 0.00% 0.00% 264,431 55 2.0 0.05% 149 0.00% 0.00% 0.0 0.00% 0.00% 0.00% 0.0 0.00% 0.00% 0.00% 4.0 0.00% 0.00% 0.00% 64,501 1,733 17.6 60.02% 181,227 0.81% 325 1.04% 3,654 295 3.0 0.27% 808 0.00% 0.00% 7,816 4.0 7.08% 21,386 0.00% 0.00% 164 6.0 0.15% 448 1.91% 767 0.01% 25 5,858 3.8 5.31% 16,028 0.00% 0.40% 1,423 1.0 0.00% 0.00% 0.00% 2,396 82.5 2.17% 6,556 29.04% 11,653 53.92% 189,918 2,136 189 6.5 2.11% 6,361 0.42% 170 11.31% 39,836 274 1,280 13.0 1.41% 4,252 67.23% 26,979 4.67% 16,456 327 12.0 0.30% 896 0.58% 232 0.00% 3,317 55 2.0 3.06% 9,225 0.00% 0.00% 7,073 1,083 11.0 7.39% 22,317 0.00% 2.40% 8,468 136 5.0 0.12% 373 0.00% 0.00% 8,146 788 8.0 8.10% 24,444 0.00% 0.79% 2,790 8 27 1.0 0.03% 97 0.00% 0.11% 399 492 5.0 0.45% 1,347 0.00% 21.30% 75,033 322 55 2.0 0.34% 1,030 0.00% 0.88% 3,090 256 100% SHARED ASSETS - SPLIT Amount # employees 2,649.00 97.10 City Hall, City sign 5,672.00 57.60 PW bldg. 2,585.00 89.00 Public Safety See prop premiums sheet for shared break down. 100.00% 40,127 100.00% 352 2010 TOTAL TOTAL Dept Specific 2012 2013 Claims Allocation Allocation 6,372 6,561 6,820 7,008 6,521 6,710 16,887 17,076 6,521 6,710 7,081 7,270 6,820 7,008 6,372 6,561 11,626 11,815 9,945 10,228 9,721 10,004 11,255 11,538 9,422 9,705 9,422 9,705 9,572 9,854 8,083 8,325 195,078 195,374 10,680 10,976 29,469 29,711 9,323 9,566 25,535 25,777 8,083 8,325 264,431 266,120 102,671 104,360 55,161 55,386 7,425 7,614 15,522 15,711 38,258 38,482 6,670 6,859 34,708 34,933 6,792 6,981 119,359 119,548 10,417 10,606 1,082,021 1,092,407 2 of 4 7/20/2011 2010 AUTO CLAIMS Information is provided by Risk Management (Jennifer). This amount is used to determine the percentage of overall actual costs per division. This percentage is then used to allocate prior year's actual costs. 2 0.58% 4 0.42% 4 0.81% 1 1.91% 19 29.04% 4 67.23% 0.00% 51,216.34 35 100.00% 3 of 4 7/20/2011 Date of Loss Department Amount Paid Auto 2010-22 10/13/10 Eng 64.95 Auto 2010-34 12/29/10 Engineer 231.68 Auto 2010-19 9/13/10 FD 64.95 Auto 2010-01 2/3/10 Fire 64.94 Auto 2010-03 1/28/10 Fire 0.00 Auto 2010-33 12/27/10 Fire 86.95 Auto 2010-20 9/13/10 Parks 304.63 Auto 2010-29 12/11/10 Parks Maint 0.00 Auto 2010-30 11/30/10 Parks Maint 110.41 Auto 2010-35 12/30/10 Parks Maint Auto 2010-15 7/22/10 Pool 979.41 Auto 2010-24 11/21/10 CSO 0.00 Auto 2010-27 12/3/10 CSO 0.00 Auto 2010-04 2/11/10 PD 1,068.87 Auto 2010-05 3/29/10 PD 3,137.07 Auto 2010-06 4/18/10 PD 0.00 Auto 2010-07 5/8/10 PD 0.00 Auto 2010-08 6/11/10 PD 282.35 Auto 2010-09 5/27/10 PD 0.00 Auto 2010-10 6/18/10 PD 1,573.96 Auto 2010-11 6/25/10 PD 6,175.99 Auto 2010-12 6/24/10 PD 111.25 Auto 2010-13 7/6/10 PD 209.36 Auto 2010-14 7/17/10 PD 1,786.37 Auto 2010-16 5/22/10 PD Auto 2010-17 8/29/10 PD 133.28 Auto 2010-18 8/30/10 PD 50.05 Auto 2010-21 9/15/10 PD 234.90 Auto 2010-25 11/16/10 110.41 Auto 2010-28 12/1/10 PD -SIU Auto 2010-32 12/30/10 PW Streets 1,626.75 Auto 2010-02 2/8/10 PW -Streets 2,202.07 Auto 2010-23 11/13/10 PW -Streets 273.66 Auto 2010-26 11/30/10 PW -Streets 30,332.08 Auto 2010-31 12/12/10 PW Utilities 2 0.58% 4 0.42% 4 0.81% 1 1.91% 19 29.04% 4 67.23% 0.00% 51,216.34 35 100.00% 3 of 4 7/20/2011 2010 WORKER'S COMP CLAIMS Information is provided by Risk Management (Jennifer). This amount is used to determine the percentage of overall actual costs per division. This percentage is then used to allocate prior year's actual costs. Claim # Date of Inlury Status Emplovee Department Net Total Incurred WC 2010 25 8/30/10 Closed Diane Tiegs-Roussell Admin -Clerk 0.00 WC 2010 29 8/31/10 Open Diane Tiegs-Roussell Admin -Clerk 8,150.00 WC 2010 32 9/28/10 Closed William Tonn CD -Inspections 747.41 WC 2010 45 11/22/10 Closed Eric Noraas CD -Inspections 0.00 WC 2010 24 8/18/10 Closed Cory Peterson Fire 177.16 WC 2010 30 9/21/10 Closed Richard Sheldon Fire 12,921.56 WC 2010 40 11/15/10 Closed Kip Springer Fire 759.92 WC 2010 41 11/15/10 Oen Thomas Evenson Fire 812.76 WC 2010 43 11/21/10 Closed Chris Anderson Fire 0.00 WC 2010 44 11/22/10 Closed Gary Hendrickson Fire 17,106.73 WC 2010 42 11/14/10 Closed Lynn Smisek Ice Center 1,135.33 WC 2010 34 10/9/10 Closed Melissa Malikowski Park and rec 0.00 WC 2010 27 7/21/10 Closed Ronald Farley Parks and Rec 20.15 WC 2010 03 1/28/10 Closed Todd Miller Parks Maint 0.00 WC 2010 12 4/12/10 Closed Greg Poetz Parks Maint 1,692.42 WC 2010 28 9/8/10 Closed Paul Babb Parks Maint 0.00 WC 2010 48 11/30/10 Closed Troy Sun Parks Maint 0.00 WC 2010 49 11/22/10 Closed Todd Miller Parks Maint 0.00 WC 2010 52 12/2/10 Closed Gregory Poetz Parks Maint 0.00 WC 2010 53 12/14/10 Closed Gil Konop Parks Maint 1,222.54 WC 2010 01 1/1/10 Closed Amy Therkelson PD 529.75 WC 2010 02 1/7/10 Closed Melissa Johnson PD 0.00 WC 2010 05 3/9/10 Closed Angela Haseman PD 0.00 WC 2010 06 3/8/10 Closed Donald Nelson PD 0.00 WC 2010 07 3/12/10 Open Ryan Hazen PD 24,645.28 WC 2010 08 3/9/10 Closed Joseph Gebhardt PD 0.00 WC 2010 09 4/1/10 Closed Ryan Peterson PD 659.49 WC 2010 10 4/4/10 Closed Brian Beniek PD 1,315.05 WC 2010 13 4/25/10 Closed Scott Kroeger PD 0.00 WC 2010 16 4/8/10 Closed Melissa Johnson PD 154.28 WC 2010 22 7/29/10 Closed Kevin Pregler PD 0.00 WC 2010 23 8/2/10 Closed Scott Kroeger PD 14,698.61 WC 2010 31 9/24/10 Closed Ryan Janssen PD 0.00 WC 2010 35 10/30/10 Closed Brian Beniek PD 346.56 WC 2010 36 11/15/10 Closed Michael Buske PD 331.69 WC 2010 37 11/15/10 Closed William Dane PD 494.09 WC 2010 38 11/15/10 Closed Ryan Peterson PD 340.99 WC 2010 39 11/15/10 Closed Scott Kirchner PD 235.15 WC 2010 46 11/15/10 Closed Steven Larson PD 0.00 WC 2010 55 12/14/10 Closed Lisa Kurtz PD 0.00 11/9/09 Open Robert Gardner PD 54,960.01 8/5/08 Open Lisa Kurtz PD 51,057.96 11/21/02 Oen Karen Forslund PD 535.45 3/31/93 Oen Scott Streachek PD 1,195.90 WC 2010 33 9/26/10 Closed Teri Wetternach CSO 0.00 WC 2010 15 6/8/2010 Closed Michael Engler PW -Facilities 2,464.79 WC 2010 20 7/22/10 Open Russell Elzy PW -Mechanics 59,854.72 WC 2010 19 6/30/10 Closed Randolph Lehtola PW -Streets 0.00 WC 2010 26 9/3/20110 Closed Torrey Keith PW -Streets 13,127.58 WC 2010 17 6/15/10 Closed Kevin Mastey PW -Utilities 284.83 WC 2010 18 6/14/10 Closed Joe Raiche PW -Utilities 0.00 WC 2010 21 7/21/10 Closed Brian Rahn PW -Utilities 497.73 WC 2010 50 11/23/10 Closed Steve Herwig PW -Utilities 0.00 WC 2010 54 12/3/10 Closed Brian Rahn PW -Utilities 143.80 WC 2010 56 12/29/10 Oen Kevin Maste PW -Utilities WC 2010 47 11/21/10 Closed Russell Clarke PW-WasteMgmt WC 2010 51 11/30/10 Oen Gregory Cook PW -Water Net Total Incurred in 2010 2.900% 0.266% 11.309% 0.404% 0.007% 1.037% 53.916% 0.877% 21.301% 4.672% 3,525.00 1.584% 318.21 0.113% 4,529.00 1.612% 280,991.90 100.000% 4 of 4 7/20/2011 rp)City of Plymouth Adding Quaky to Life SPECIAL COUNCIL MEETING July 26, 2011 Agenda BNumber: To: Mayor and City Council Prepared by: Laurie Ahrens, City Manager Item: Set Future Study Sessions 1. ACTION REQUESTED: Review the list of pending study session items and schedule dates as desired. Calendars are attached for your use. Page 1 Pending Study Session Topics at least 3 Council members have approved the following study items on the list) Discuss paperless Council packets (CC — report provided) Meet with prosecutor for update and discuss Police Department's trends and statistics Update with City Manager — fall Other requests for study session topics: Review dangerous dog regulations/process (JW) Discuss streamlining street lighting rates Update on surplus City properties Page 2 r Plymouth Adding Quality to Life August 2011 Modified on 07122111 Page 3 1 2 2:30-5:00 PM 3 7:00 PM 4 7:00 PM 5 6 NIGHT TO UNITE PLANNING HUMAN RIGHTS KICKOFF COMMISSION COMMITTEE Plymouth creek Center MEETING MEETING Council Chambers Medicine Lake Room 6:30-9:30 PM NIGHT TO UNITE 7 8 9 6:00 PM 10 7:00 PM 11 12 13 SPECIAL COUNCIL ENVIRONMENTAL MEETING* QUALITY Medicine Lake Room COMMITTEE 7:00 PM EQC) MEETING REGULAR COUNCIL Council Chambers MEETING Council Chambers 14 15 16 17 18 19 206:00 PM 7:00 PM SPECIAL COUNCIL PLANNING MEETING COMMISSION Budget Study Session MEETING Medicine Lake Room Council Chambers 21 22 23 24 25 26 275:30 PM 7:00 PM SPECIAL COUNCIL HRA MEETING MEETING Parkers Lake Room 2012-2016 CIP Medicine Lake Room 7:00 PM REGULAR COUNCIL MEETING Council Chambers 28 29 30 31 Joint meeting with PACr to discuss operations Modified on 07122111 Page 3 r ity Plymouth Adding Quality to Life September 2011 Modified on 07122111 Page 4 1 2 3 4 5 111M 6 7 8 9 1.06:00 PM CANCELLED 7:00 PM SPECIAL COUNCIL PLANNING PARK 8 REC MEETING COMMISSION ADVISORY LABOR DAY Budget Study Session MEETING COMMISSION IfNecessary Medicine Lake Room PRAC) MEETING CITY OFFICES Medicine Lake Room Council Chambers CLOSED 11 12 13 14 7:00 PM 15 16 17 7:00 PM ENVIRONMENTAL REGULAR COUNCIL QUALITY MEETING COMMITTEE Council Chambers EQC) MEETING Parkers Lake Room 18 19 20 21 7:00 PM 22 2 3 24 9:00 AM 6:00-9:00 PM PLYMOUTHPLANNINGOPENHOUSEFIREFIGHTERS 5KCOMMISSIONFOURSEASONSFireStation #2MEETINGMALLSTUDYMedicineLakeRoomPlymouthCreek Center 11:30 AM PLYMOUTH ON 7:00 PM PARADE HRA MEETING CELEBRATION Parkers Lake Room City Center Area 25 26 27 7:00 PM 28 29 30 REGULAR COUNCIL MEETING Medicine Lake Room Rosh HaShonah Begins at Sunset Modified on 07122111 Page 4 City of Plymouth Adding Quality to Life October 2011 Modified on 07122111 Center Page 5 1 2 3 4 5 7:00 PM 6 7 8 PLANNING COMMISSION MEETING Medicine Lake Room Yom Kippur Begins at Sunset 9 10 11 12 13 14 157:00 PM 7:00 PM 7:00 PM ENVIRONMENTAL PARK £t REC 12:00-3:00 PM REGULAR COUNCIL QUALITY ADVISORY FIRE DEPT. COLUMBUS DAY MEETING COMMITTEE COMMISSION OPEN HOUSEObservedMedicineLakeRoomEQC) MEETING PRAC) MEETING Fire Station III Parkers Lake Room Plymouth Ice Cente PLYMOUTH PUBLIC WORKS DIVISION CLOSED 16 17 18 19 7:00 PM 20 21 22 PLANNING COMMISSION MEETING Medicine Lake Room 23 24 25 26 27 28 297:00 PM 7:00 PM REGULAR COUNCIL HRA MEETING MEETING Parkers Lake Room Medicine Lake Room 0 P Halloween oek Io yCreek Modified on 07122111 Center Page 5