The URL can be used to link to this page

Home My WebLink About9A - 2015 Budget Adoption O� PRIp+P ti U 4646 Dakota Street SE Prior Lake, MN 55372 jNivFSolP CITY COUNCIL AGENDA REPORT MEETING DATE: DECEMBER 8, 2014 AGENDA#: 9A PREPARED BY: FRANK BOYLES, CITY MANAGER JERILYN ERICKSON, FINANCE DIRECTOR PRESENTED FRANK & JERILYN BY: AGENDA ITEM: CONSIDER APPROVAL OF RESOLUTIONS ADOPTING 2015 PRIOR LAKE BUDGETS AND CERTIFYING FINAL 2015 CITY OF PRIOR LAKE PROPERTY TAX LEVIES TO SCOTT COUNTY DEPARTMENT OF TAXATION. DISCUSSION: Introduction The purpose of this agenda item is to consider approval of the 2015 budgets for the City of Prior Lake's General Fund, Debt Service Funds, Cable Fund, Capital Park Fund, Revolving Equipment Fund, Facilities Management Fund, Economic Development Authority, Water Fund, Sewer Fund, Water Quality Fund and Transit Fund and to determine the City's final 2015 property tax levy for certification to the Scott County Department of Taxation office. History The Council has held workshops on August 11 and November 10 this year to discuss the challenges, priorities and options for developing the 2015 budget. On September 22, 2014 the City Council considered the preliminary budgets for the General Fund, Debt Service Funds, Cable Fund, Revolving Equipment Fund, Facilities Management Fund, Economic Development Authority and Enterprise Funds and a preliminary tax levy of $10,394,086 which represented a proposed 10.0% increase over 2014. It was announced at the September 22, 2014 meeting and included in the meeting minutes that a public budget meeting (TNT hearing) would be held on December 8, 2014 at which time the 2015 budget and levy would be discussed and would allow for citizen input. Following individual parcel mailings, the public budget meeting (TNT hearing)was then conducted on December 8, 2014. The City Manager gave a presentation which covered the following items: • 2014 Accomplishments and 2015 Efforts 0 Overview of Proposed 2015 Budget and Tax Levy • Impact of Tax Levy 0 Standard Measures Beginning in 2009, the City of Prior Lake recognized the impact of the recession upon its constituents. Accordingly, the City cut four full time positions and services and shifted in 2011 to a significant reliance ($500,000 to $1 million annually) for annual budgetary financing from the General Fund reserve. Phone 952.447.9800 / Fax 952.447.4245/www.cityofpriorlake.com As a result of these policies, the City recorded substantially lower annual levy increases than the consumer price index (CPI) as shown below: Levy $9,365,437 $9,881,555 $10,079,186 $10,114124 $9414,124 $9,414,124 59,448,918 $10,394,086 PYS Change $646,660 $516,118 $197,631 $34,938 ($700,000) SO $34,794 $945,168 (Actual) PY%Change 7.42% 5.51% 2.00% 0.35% (6.9296) 0.00% 0.37% 10.0096 (Actual) CPI-u(Msl� 3.80% (0so%) 1.80% Change Recalculated: PYS Chg $315,346 $562,945 $19,763 ($327,913) ($932,625) ($178,868) ($153,488) $756,190 PY%Chg 3.48% 6.04% 0.20% (3.1496) (9.01%) (1.8696) (1.6096) 7.85% While the CPI has increased on average 2.10% each year, the levy has increased on average 0.24% annually. The community continued to grow during the same period by an average of 1 to 2 % per year adding miles of streets, trails, sidewalks, miles of sewer and water pipes, sewer and water accounts, dwelling units, traffic on the roadways all of which demand greater city products and service. For the most part the additional work and services have been absorbed through greater productivity and cost effectiveness or the service levels have eroded as set forth in Exhibit "E". Frankly we are at the end of our capacity to absorb any more. Population and households are most closely correlated with municipal service demands. Below are graphics which show the historic expenditure and levy per household for this period. General Fund Total Operating Expenditures Per Household $2,000 $1,900 $1,800 $1,700 — $1,600 $1,500 $1,400 -- ....- $1.300 - $1,200 — $1,100 $1,000 .... _... -- _ 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 Est 2015 Expected Operating Expenditures/HH --*—Operating Expenditures/H H Includes 2014 Amended Budget and 2015 Proposed Budget The City Council adopted this metric in the most recent amendment to the CFMP . . . "Maintain a level of General Fund operational expenditures on a per household basis which takes into account the cost of inflation and community growth." As reflected in the above chart, the proposed 2015 budget/household is significantly less than the level it would be if the City's cost actually kept pace with inflation and growth. Property Tax Levy Per Household $1,500 ---- --- $1,400 $1,300 -- $1,200 — --- $1,100 $1,000 — $900 $800 $700 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 Est 2015 — �-PropertyTax Levy/HH Expected Property Tax Levy/HH The City Council adopted this metric in the most recent amendment to the CFMP . . . "Maintain a level of property taxes on a per household basis which takes into account the cost of inflation and community growth." As reflected in the above chart, the proposed 2015 total tax levy/household is less than it would have been had the City kept pace with actual inflation and growth over these last 15 years. Current Circumstances As a part of the regular budget review process since November 10, Staff continued to review budget requests and funding sources and has refined them as follows in order to reduce the budget and the pressure on the property tax levy as well as reflecting recent Council actions: 1) Eliminate $50k transfer from General Fund to Revolving Park Equipment Fund; 2) Eliminated part-time records position in Police Department (General Fund); 3) Eliminated seasonal part-time administrative position in Fire Department (General Fund); 4) Reduce seasonal staff in Recreation due to reducing the number of beach parties from three to one (General Fund). 5) Reduced property tax levy in EDA fund; 6) Increased property tax levy in General Fund. 7) Add GESP expenditures to Facilities Management Fund; 8) Add debt service payment and funding sources for GESP lease agreement in Facilities Management Fund and Debt Service Funds. It should be noted that the EDA adopted a resolution on November 17, 2014 requesting a $37,500 increase in their tax levy. On December 1, Staff asked the EDA to consider a lower tax levy increase of$9,000 so the $28,500 difference could be available for funding General Fund services. All commissioners present were fine with that change, knowing that if they needed additional funds for other EDA initiatives, they would be coming back to the City Council with a subsequent request. The revenue and expenditure changes have been incorporated into Exhibit "A" which is the overview of all budgeted funds. The second page of Exhibit "A" includes the following: • Property tax comparisons; • Expenditure comparisons; • All funds expenditure comparison with the 2014 original and amended budgets; • General Fund expenditure comparison with the 2014 original and amended budgets; Exhibit "B" provides a summary of the 2015 proposed revenues and expenditures from the 2014 amended budgets. Exhibits "C" and "D" provide a line-by-line comparison of the 2015 proposed revenues and expenditures from the 2014 amended budgets. The property tax levy which we believe necessary to continue to provide services to our growing community (with the exception of the reductions noted above) while properly retiring debt, ending our reliance upon the general fund reserve, adding a modest amount of money for economic development and sustaining our infrastructure improvement efforts is 10.0% greater than 2014. After these adjustments, the 2015 tax levy increase is created by the following five elements: 12/08/14 Percent Proposed of Total Debt Service $162,000 1.71% Reserve 511,000 5.41% Replacement from 2014 EDA Fund 9,000 0.10% Rev Equip Fund 50,000 0.53% General Fund net 213,200 2.26% Total $945,200 10.00% FINANCIAL The summaries of revenues and expenditures reflect 2014 adopted and amended IMPACT: budgets, and 2015 proposed budgets. The dollar and percentage change are calculated from the 2014 amended budgets. Tax Levy The total proposed 2015 tax levy of $10,394,086 reflects a $945,168 or 10.0% increase from 2014. Exhibit "A" includes a comparison of the different components of the tax levy from 2014 to 2015 on page two. Fund Balance Reserves The proposed budget includes a planned use of reserves for eight funds. The General Fund and the Capital Park Fund do not include a planned use of reserves. Capital improvement projects and capital purchases are cause for the greatest variability in expenditure levels and, therefore, fluctuation in the amount of reserves used from year to year in the Water Fund, Sewer Fund, Water Quality Fund, Capital Park Fund, Revolving Equipment Fund and Facilities Management Fund. The level of special assessment and property tax collections impact the amount of reserves used to pay debt service obligations in the Debt Service Funds. The EDA Special Revenue Fund includes revenues from an EDA property tax levy to fund its ongoing operating expenditures. There is a use of reserves anticipated for 2015. The Transit Fund is shown for comparative purposes only. Transit operations will be taken over by the Minnesota Valley Transit Authority(MVTA) on January 1, 2015. The General Fund budget does not reflect any use of reserves for 2015. The following chart reflects the fund balance reserve projection based on use of reserves and operational estimates for 2014 and estimated FEMA reimbursement (as discussed at the November 10 workshop). GENERAL FUND Projected P2014 P2015 P2016 P2017 P2018 P2019 CURRENT FUND BALANCE 6,431,258 4,945,502 5,245,502 5,395,502 5,595,502 5,795,502 Planned use of FB: 1) Incentives to Contain Healthcare Costs,Etc (100,000) - _ - - 2)Levy Limits (406,050) 3)Election Equipment (37,500) 4)ERP (384,890) 5)Target FB 45%at YE 2015 (105,000) - - _ _ _ 6)Anticipated FEMA reimbursement 100,000 5,397,818 5,045,502 5,245,502 5,395,502 5,595,502 5,795,502 Projected Increase/(Decrease)from.Operations (360,000) 200,000 200,000 200,000 200,000 200,000 Budget Amendments Approved: 1) Lakefront Storage Building (82,519) - - - _ - 2) Dakota property acquisition(net of DSF547) (1,297) 3).Demolish Colorado Street property (8,500) Other Possible Planned Uses: 1)Comp Plan Update - Yearend Fund Balance 4,945;502 5,245,502 5,395,502 5,595,502 5,795,502 5,995,502 Overall Change in FB (1,485,756) 300,000 150,000 200,000 200,000 200,000 Proposed Projected Projected Projected Projected Projected 2015 2016 2017 2018 2019 2020 Budget Budget Budget Budget Budget Budget Projected Expenditures(3%) 12,563,945 12,940,863 13,329,089 13,728,962 14,140,831 14,565,056 FB as%of Projected Expforfollowing year 3?.496 40.54 40.5°5 43.E". 41.05£ 4;_7;L The Comprehensive Financial Management Policy (CFMP) targets a range of 40- 50% General Fund reserve. As stated in the Policy, this percentage could fluctuate with each year's budget objectives and appropriations such as large capital expenditures and variations in the collections of revenues. The CFMP also identifies the expenditure criteria when the City Council may consider the judicious use of reserve balances. Expenditures The 2015 proposed expenditure budgets are as follows: Fund Proposed Budget General $ 12,563,945 Debt Service 4,256,609 Cable 7,000 Capital Park 50,000 Rev. Equipment 818,550 Facilities Management 3,546,418 EDA 188,595 Water 51728,336 Sewer 3,317,936 Water Quality 1,125,299 Transit 0 Total $ 31,602,688 Exhibit "A" offers comparisons of the proposed budget to the original 2014 budget as well as the 2014 amended budget. The budget may be periodically amended for expenditures and corresponding funding sources associated with projects or tasks that the council authorizes throughout the year. These projects or tasks were not contemplated as part of the original budget but the Council deemed it necessary to move forward with them mid-year; therefore, the budget was amended to reflect these expenditures, revenues or use of reserves as a funding source. In an effort to reflect the change in expenditures based on "all spending" authorized throughout the year in the budgeted funds, Staff has included comparisons with the amended budgets. In addition, Staff has included comparisons with both the original and amended budgets that reflect adjustments in order to compare the budgets on an apples to apples basis. ISSUES As indicated above the proposed levy increase to support the 2015 budget is 10.0% or $945,168 more than the 2014 levy. The 2014 levy was a 0.37% increase over the 2013 levy. To be sure a large part of the reason the 2015 levy is high is the replacement of $511 k of reserves that were used in 2014 for operational expenses. The 2015 General Fund budget does propose an expenditure decrease of$421,310 or 3.24% as compared to the 2014 original budget. It is important to note that the 2014 included two one-time cost items: the replacement of our 1984 ERP System ($385,000) and replacement of our 12 year old voting equipment ($75,000). The purchase of new voting equipment will take place in 2015. After taking into account the one-time purchases in 2014, the reduction for the SJPA, EDA staff allocation and transfers, the General Fund budget will be increased by $237,180 or 1.94%. The following table provides a summary of the more significant changes in the 2015 proposed General Fund budget: Expenditure Amount Percent of Total Change Personnel Adjustments — COLA, steps, 121,000 51% allocation changes, etc. Staff Reductions 65,000 27% Scott JPA Assessing Agreement 17,000 7% Legal 40,000 17% Street Maintenance 66,000 28% Other Current Expenses & Capital Outlay 30,000 13% Debt Service Market Value 29,000 12% Total before Reductions for 238,000 100% Comparative Purposes Reductions for Comparative Purposes: Staff Allocation to EDA 24,000 ERP Software 385,000 SJPA Contract 165,000 Transfers to Rev Park Equipment fund and (85,000) EDA Total Chane $421,000 ALTERNATIVES: 1. Approve two Resolutions: 1) Resolution Adopting 2015 Prior Lake Budgets and Certifying Final 2015 City of Prior Lake Property Tax Levy to Scott County Department of Taxation. (Resolution#1); and 2)Approve a Resolution Adopting the 2015 Economic Development Authority Budget and Certifying the 2015 Economic Development Authority Property Tax Levy to Scott County Department of Taxation (Resolution #2) 2. Amend Resolutions according to specific Council changes. RECOMMENDED Alternative #1 MOTION: EXHIBITS: "A" — Budget Overview (2 pages) "B" — Revenue and Expenditure Summaries (4 pages) "C" — Revenue Line Item Comparisons (4 pages) "D" — Expenditure Line Item Comparisons (18 pages) "E" — Erosion in Services (3 pages) O� PRI() U trl 4646 Dakota Street SE '�I 9o".P Prior Lake,MN 55372 RESOLUTION 14-xxx (#1) RESOLUTION ADOPTING 2015 PRIOR LAKE BUDGETS AND CERTIFYING FINAL 2015 CITY OF PRIOR LAKE PROPERTY TAX LEVY TO SCOTT COUNTY DEPARTMENT OF TAXATION Motion By: Second By: WHEREAS, The City Council of the City of Prior Lake conducted a Truth in Taxation public budget meeting on December 8, 2014 pursuant to state requirements; and WHEREAS, The City Council hereby adopts the following 2015 budgets; and General Fund $ 12,563,945 Debt Service Funds 4,256,609 Cable Fund 7,000 Capital Park Fund 50,000 Revolving Equipment Fund 818,550 Facilities Management Fund 3,546,418 Water Fund 5,728,336 Sewer Fund 3,317,936 Water Quality Fund 1,125,299 Transit Fund 0 Total $31,414,093 WHEREAS, The property tax levy by tax base approved for payable year 2015 is as follows; and Tax Capacity Based Levy $ 9,199,593 Market Value Based Referenda Levy 1,035,493 Total $ 10,235,086 WHEREAS, The property tax levy approved for payable year 2015 is for the following purposes: General Purposes $ 7,071,730 Revolving Equipment Fund 250,000 Debt Service 2,913,356 Total $ 10,235,086 WHEREAS, The City of Prior Lake's General Fund tax levy is hereby equivalent to$8,107,223; and WHEREAS, The Revolving Equipment Fund levy amount is$250,000; and WHEREAS, The Special debt levies account for an additional tax levy of $1,877,863 of which the Scott County cooperative agreement appropriation of$148,805 for CSAH 82 is included. NOW THEREFORE, BE IT HEREBY RESOLVED BY THE CITY COUNCIL OF PRIOR LAKE, MINNESOTA as follows: 1. The recitals set forth above are incorporated herein. 2. That the tax levy be distributed upon the taxable property in said City for the following purposes in payable 2015: Purpose Amount Amount General City Purposes $ 7,071,730 Revolving Equipment Fund 250,000 Debt Service: F553-CSAH 82 Improvement Appropriation '06 $148,805 F554-G.0. Street Reconstruction Bonds '07 179,000 F555-G.0. Imp Bonds '08(Brooksville Hills 1) 91,000 F556-G.0. Imp Bonds'09 (Brooksville Hills ll) 139,000 F557-G.0. Imp Bonds 2010 (CR12) 109,000 F558-G.0. Imp Bonds 2011A(Boudins I/Arcadia ROW) 167,000 F559-G.0. Imp Bonds 2011B (Boudins II/Arcadia) 201,000 F317-G.0. CIP Refunding Bonds 2012A 587,058 F560-G.0. Imp Bonds 2013A(Welcome,CR12,Sunset) 15,000 F561-G.0. Imp bonds 2014A (Maplewood,Crest,Carriage) 241,000 ** F316-Park Refunding Bonds '05 820,475 ** F318-Fire Station #2 Referendum Bonds '06 215,018 Total Debt Service 2,913,356 Total $ 10,235,086 Note: Single starred funds shall be spread over the entire consolidated City of Prior Lake. Note: Double starred funds represent market value based referendum taxes and shall be spread over the entire consolidated City of Prior Lake. Note: All other bond issues have sufficient fund balances to cover debt requirements. PASSED AND ADOPTED THIS 8th DAY OF DECEMBER, 2014. VOTE Hedberg Keeney McGuire Morton Soukup Aye ❑ ❑ ❑ ❑ ❑ Nay ❑ ❑ ❑ ❑ ❑ Absent ❑ ❑ ❑ ❑ ❑ Abstain ❑ ❑ ❑ ❑ ❑ Frank Boyles, City Manager 2 O� PW2 ti t U 4646 Dakota Street SE ` 11150110. Prior Lake,MN 55372 RESOLUTION 14-xxx (#2) A RESOLUTION ADOPTING THE 2015 ECONOMIC DEVELOPMENT AUTHORITY BUDGET AND CERTIFYING THE 2015 ECONOMIC DEVELOPMENT AUTHORITY PROPERTY TAX LEVY TO SCOTT COUNTY DEPARTMENT OF TAXATION Motion By: Second By: WHEREAS, Truth in Taxation provisions as specified by state statute requires the Prior Lake City Council to certify a proposed property tax levy to the Scott County Department of Taxation; and WHEREAS, State Statute 469.107 subd. 1 provides that a city may, at the request of the Economic Development Authority, levy a tax in any year for the benefit of the authority in an amount not to exceed 0.01813 percent of taxable market value; and WHEREAS, The maximum allowable EDA property tax levy for payable year 2015 has been determined to be approximately$475,000; and WHEREAS, The Prior Lake EDA, at its regularly scheduled meeting of November 17, 2014, authorized a 2015 tax levy for economic development purposes in the amount of $187,500 and a 2015 budget of$188,595; and. WHEREAS, The Prior Lake EDA reconsidered its 2015 budget at the December 1, 2014 special meeting and authorized a reduction to the levy to$159,000 with the budget remaining at $188,595 including utilization of$22,095 of EDA Reserve. NOW THEREFORE, BE IT HEREBY RESOLVED BY THE CITY COUNCIL OF PRIOR LAKE, MINNESOTA as follows: 1. The recitals set forth above are incorporated herein. 2. A final tax levy of$159,000 and proposed budget of$188,595 are approved for payable year 2015. 3. That the proposed Economic Development Authority tax levy be distributed upon the taxable property in said City for the purposes of economic development in payable 2015. PASSED AND ADOPTED THIS 8th DAY OF DECEMBER, 2014. VOTE Hedberg Keeney McGuire Morton Soukup Aye ❑ ❑ ❑ ❑ ❑ Nay ❑ ❑ ❑ ❑ ❑ Absent ❑ ❑ ❑ ❑ ❑ Abstain ❑ ❑ ❑ ❑ ❑ Frank Boyles, City Manager 01 PRIOR City of Prior Lake Council Meering 12.08.2014 2015 Proposed Budget Budgeted Funds '4�NNafO'� Debt ....Capital Revolving Facilities Total Total General Service Cable Park Equipment Management EDA Governmental Water Sewer WatarQuality Transit Enterprise Budgeted. Fund Funds Fund Fund Fund. Fund Funds Fund Fund Fund Fund Funds Funds. Revenues/Sources Property Taxes _ _ _ _ _ Levy-Tax Capacity $ 7,071,730 $ 1,877,863 $ - $ - $ 250,000 $ - $ 159,000 $ 9,358,593 $ $ $ $ $ $ 9,358,593 Levy-Market Value 1,035,493 - - - - - - 1,035,493 1,035,493 Special Assessments - 401,346 - - - - - 401,346 - - _ - = 401,346 Licenses&Permits 642,745 - - - - - - 642,745 _ = 642,745 Fines&Forfeits - - _ Intergovernmental 1,483,842 - - - - - - 1,483,842 - - 95,000 95,000 1,578,842 Charges for Services 1,644,615 - 5,133 162,150 - - 7,000 1,818,898 3,625,980 3,227,732 817,652 - 7,671,364 9,490,262 Other Revenues 330,000 95,453 - 7,000 82,978 11,458 500 527,389 60,000 52,000 5,560 - 117,560 644,949 Bond Proceeds - - - - - 600,000 - 600,000 - - - _ _ 600,000 Lease Proceeds - - - Transfers From Other Funds General Fund - 1,035,845 - - - - - 1,035,845 - - _ 1,035,845 Water Fund 177,760 526,935 - - 60,000 40,000 - 804,695 - - 804,695 Sewer Fund 177,760 - - - 60,000 10,000 - 247,760 - - - - - 247,760 Water Quality Fund - - - - 21,000 - - 21,000 - _ _ _ 25,904 25,924 25,924 TIF Fund - _ Facilities Management Fund - 81,381 - - - - - 81,381 - - - 81.381 Total Revenues/Sources $ 12.563,945 $ 4.044,747 $ 5J33 $ 169,150 $ 473.978 $ 661,458 $ 166,500 $ 18.084.911 $ 3,685,980 $ 3,279,732 $ 918,212 $ $ 7.883.924 $ 25,968,835 Expenditures/Uses Employee Services $ 7,776,329 $ - $ - $ - $ - $ - $ 119,255 $ 7,895,584 $ 704,727 $ 651,872 $ 290,330 $ - $ 1,646,929 $ 9,542,513 Current Expenditures 3,507,337 - - - 66,340 3,573,677 1,418,914 1,643,304 256,381 3,318,599 6,892,276 Capital Outlay 244,434 - 7,000 50,000 818,550 797,113 3,000 1,920,097 100,000 100,000 - _ 200,000 2,120,097 Capital Improvements - - 2,667,924 - 2,667,924 2,700,000 675,000 557,588 3,932,588 6,600,512 Subtotal $ 11,528,100 $ - $ 7,000 $ 50,000 $ 818,550 $ 3,465,037 $ 188,595 $ 16,057,282 $ 4,923,641 $ 3,070,176 $ 1,104,299 $ $ 9,098,116 $ 25,155,398 Transfers To Other Funds _ _ General Fund $ $ - $ - $ - $ - $ - $ - $ - $ 177,760 $ 177,760 $ $ $ 355,520 $ 355,520 Treatment Plant(Debt) - - - - - - - - 526,935 - - _ 526,935 526,935 Equipment Fund 60,000 60,000 21,000 141,000 141,000 - - - Park Equipment Fund - - _ _ _ Debt Service Funds 1,035,845 - - - - 81,381 - 1,117,226 - - 1,117,226 Facilities Management Fund - - - - - - _ _ 40,000 10,000 - = 50,000 50,000 EDA Fund - - - _ _ Debt Service - 4,256,609 4,256,609 - - 4,256,609 Subtotal $ 1,035,845 $ 4,256,609 $ - $ - $ - $ 81,381 $ - $ 5,373,835 $ 804,695 $ 247,760 $ 21,000 $ $ 1,073,455 $ 6,447,290 Total Ex enditures/Uses $ 12,563,945 $ 4,256,609 $ 7.000 $ 50,000 $ 818,550 $ 3,546,418 $ 188,595 $ 21,431,117 $ 5,728,336 $ 3,317,936 $ 1,125,299 $ - $ 10 171 571 $ 31 602 688 Change in Fund Balance $ $ 211,862 $ 1,867 $ 119,150 $ 344,572 $ 2,884,960 $ 22,095 $ 3,346,206 $ 2,042,356 $ 38,204 $ 207,087 $ - $ 2,287,647 $ 5,633,853 12 2015 Property Tax Levy Comparison Councll Meeting 12.08.2014 Change 14.-,15 Property Taxes 2014 2015 Amount Percent Levy-Tax Capacity General Fund-Operating $ 6,347,726 $ 7,071,730 $ 724,002 11.41% Debt Service Funds 1,744,398 1,877,863 133,465 7,65% Revolving Equipment Fund 200,000 250,000 50,000 25.00% Facilities Management Fund n/a $ 8,292,126 $ 9,199,593 $ 907,467 10.94% Levy-Market Value-General Fund 1,006,792 1,035,493 28,701 2.85% Lev -Economic Dev Authority 150,000 159,000 9,000 6.00 Total Lev $ 9,448,918 $ 10,394,086 $ 945,168 10.00% 2015 Budget Expenditure Comparisons(2014 Original Budgets) Capital .Revolving.... Facilities. Taal ...Total General Debt Service Cable .Park .Equipment Management EDA. Governmental Water Sewer WaterQualRy, Transit Enterprise Budgeted... Fund Funds Fund" Fund ' Fund Fund_ Fuels ,Fund Fund,. Fund Fund :.Funds Funds. 2015 Total Expenditures/Uses $ 12,563,945 $ 4,256,609 $ 7,000 $ 50,000 $ 818,550 $ 3,546,418 $ 188,595 $ 21,431,117 $ 5,728,336 $ 3,317,936 $ 1,125,299 $ - $ 10,171,571 $ 31,602,688 2014 Total Expenditures/Uses $ 12,985,255 $ 7,589,881 $ - $ 170,000 $ 725,356 $ 371,395 $ 189,170 $ 22,031,057 $ 3,078,731 $ 2,949,887 $ 764,205 $ 937,149 $ 7,729,972 $ 29,761,028 Change 2014 to 2015($) $ (421,310) $ (3,333,272) $ 7,000 $ (120,000) $ 93,194 $ 3,175,023 $ (575) $ (599,940) $ 2,649,605 $ 368,049 $ 361,094 $ (937,149) $ 2,441,599 $ 1,841,660 Change 2014 to 2015 % -3.24% -43.92% n/a -70,59% 12.85% 854.89% -0.30% -2.72% 86.06% 12.48% 47.25% -100.00% 31.59% 6.19% "Cable Fund has not previously been a budgeted fund. There has been no expenditure activity year-to-date in 2014. 2015 Budget Expenditure Comparisons(2014 Amended Budgets) Capital Revolving Facilities Total Total General Debt Service Cable Park Equipment Management EDA Governmental Water sewer Water Quality Transit Enterprise Budgeted Fund Funds Fund* Fund Fund Fund Funds Fund Fund Fund Fund Funds Funds 2015 Total Expenditures Uses $ 12,563,945 $ 4,256,609 $ 7,000 $ 50,000 $ 818,550 $ 3,546,418 $ 188,595 $ 21,431,117 $ 5,728,336 $ 3,317,936 $ 1,125,299 $ - $ 10,171,571 $ 31,602,688 2014 Total Expenditures/Uses $ 13,267,637 $ 7,589,881 $ $ 190,436 $ 808,122 $ 371,395 $ 189,170 $ 22,416,641 $ 3,078,731 $ 2,949,887 764,205 $ 937,149 $ 7,729,972 $ 30,146,612 Change 2014 to 2015($) $ (703,692) $ (3,333,272) $ 7,000 $ (140,436) $ 10,428 $ 3,175,023 $ (575) $ (985,524) $ 2,649,605 $ 368,049 $ 361,094 $ (937,149) $ 2,441,599 $ 1,456,076 Change 2014 to 2015 % -5.30% -43.92% n/a -73.74% 1.29% 854.89% -0.30% -4.40% 86.06% 12.48% 47.25% -100.00% 31.59% 4,83% Expenditure Comparison(All Funds;2014 Original Budget) Expenditure Comparison(All Funds;2014 Amended Budget) Change 14-15 Change 14-15 Original inal B d 0 4 2015 Amount -percent Amended Budget :. 2014 2015. Amount Percent Total All Funds $ 29,761,028 $ 31,602,688 $ 1,841,660 6.19% Total All Funds $ 30,146,612 $31,602,688 $ 1,456,076 4.83% Less: Bond Refunding (3,310,017) - 3,310,017 n/a Less: Bond Refunding (3,310,017) - 3,310,017 n/a Less: Transit Fund (937,149) 937,149 n/a Less: Transit Fund (937,149) 937,149 n/a Net Total Budgets $ 25,513,862 $ 31,602,688 6,088,826 23.86% Net Total Budgets $ 26,836,595 $31,602,688 $ 4,766,093 17.76% Expenditure Comparison(General Fund;2014 Original Budget) Expenditure Comparison(General Fund;2014 Amended Budget) Change 14.15 'Change 14-.15 O' final Bud2014 2015 Amount Percent Amended Bud et 2014 2015 Amount Percent Total General Fund Budget $ 12,985,255 $ 12,563,945 $ (421,310) -3.24% Total General Fund Budget $ 13,267,637 $12,563,945 $ (703,692) -5.30% Less: EDA Staff Allocation (24,000) - 24,000 n/a Less: EDA Staff Allocation (24,000) - 24,000 n/a Less: ERP Software (384,890) - 384,890 n/a Less: ERP Software (384,890) - 384,890 n/a Less: Election Equipment (75,000) (75,000) - n/a Less: Election Equipment (75,000) (75,000) - n/a Less: SJPA (165,000) - 165,000 n/a Less: SJPA - (165,000) 165,000 n/a Less: Transfers (84,600) 84,600 n/a Less: Transfers (84,600) 84,600 n/a Net General Fund Budget $ 12,251,765 $ 12,488,945 $ 237,180 1.94% Net General Fund Budget $ 12,534,147 $12,488,945 $ (45,202) -0.36% 13 of PRIOR City of Prior Lake Council Meeting 12.08.2014 F 2015 Proposed Budget U Revenue Summary M'NNE9�`� From Amended Budget 2014 2015 2014 2014 2015 $Change %Change %of %of Adopted Amended Proposed 14-15 14-15 Total Total General Fund Taxes 7,354,520 7,354,520 8,107,223 752,703 10.23% 62.18% 64.53% Licenses and permits 638,895 638,895 642,745 3,850 0.60% 4.45% 5.12% Intergovernmental 1,474,044 1,550,044 1,483,842 (66,202) -4.27% 12.20% 11.81% Charges for services 1,679,816 1,679,816 1,644,615 (35,201) -2.10% 14.14% 13.09% Fines and forfeitures 155,000 155,000 - (155,000) -100.00% 1.35% 0.00% Interest on investments 120,000 120,000 120,000 0 0.00% 1.57% 0.96% Other 181,000 181,000 210,000 29,000 16.02% 1.14% 1.67% Transfers from other funds 348,540 348,540 355,520 6,980 2.00% 2.97% 2.83% Total General Fund 11,951,815 12,027,815 12,563,945 536,130 4.46% 100.00% 100.00% Debt Service Funds Taxes 1,744,398 1,744,398 1,877,863 133,465 7.65% 44.25% 46.43% Special assessments 489,877 489,877 401,346 (88,531) -18.07% 9.83% 9.92% Interest on investments 30,731 30,731 26,527 (4,204) -13.68% 0.57% 0.66% Other - - 68,926 68,926 n/a 0.00% 1.70% Transfers from other funds 1,731,814 1,731,814 1,670,085 (61,729) -3.56% 45.36% 41.29% Total Debt Service Funds 3,996,820 3,996,820 4,044,747 47,927 1.20% 100.00% 100.00% Cable Fund Charges for Services - - 5,133 5,133 n/a n/a 100.00% Total Cable Fund - - 5,133 5,133 n/a n/a 100.00% Revolving Equipment Fund Taxes 200,000 200,000 250,000 50,000 25.00% 68.34% 52.75% Interest on investments 25,173 25,173 20,151 (5,022) -19.95% 4.82% 4.25% Other - - 62,827 62,827 n/a 0.00% 13.26% Transfers from other funds 131,000 131,000 141,000 10,000 7.63% 26.85% 29.75% Total Revolving Equipment Fund 356,173 356,173 473,978 117,805 33.08% 100.00% 100.00% Facilities Management Fund Interest on investments 2,831 2,831 11,458 8,627 304.73% 7.33% 1.73% Transfers from other funds 45,000 45,000 50,000 5,000 11.11% 92.67% 7.56% Bond proceeds 300,000 300,000 600,000 300,000 100.00% 0.00% 90.71% Total Facilities Management Fund 347,831 347,831 661,458 313,627 90.17% 100.00% 100.00% Capital Park Revenue Fund Charges for services 138,750 138,750 162,150 23,400 16.86% n/a 95.86% Interest on investments 6,000 6,000 7,000 1,000 n/a n/a 4.14% Total Capital Park Fund 144,750 144,750 169,150 24,400 16.86% n/a 100.00% 17 of pluOA City of Prior Lake Council Meeting 12.08.2014 r' 2015 Proposed Budget U m Revenue SummaryNE9OSt. From Amended Budget 2014 2015 2014 2014 2015 $Change %Change %of %of Adopted Amended Proposed 14-15 14-16 Total Total EDA Special Revenue Fund Taxes 150,000 150,000 159,000 9,000 6.00% 78.25% 95.50% Charges for services 9,185 9,185 7,000 (2,185) -23.79% 2.45% 4.20% Interest on investments 282 282 500 218 77.30% 0.00% 0.30% Transfers from other funds 34,600 34,600 - (34,600) -100.00% 19.30% 0.00% Total EDA Fund 194,067 194,067 166,500 27,567 -14.20% 100.00% 100.00% Water Fund Charges for services-water 3,264,130 3,264,130 3,625,980 361,850 11.09% 98.34% 98.37% Interest on investments 25,000 25,000 60,000 35,000 140.00% 1.66% 1.63% Total Water Fund 3,289,130 3,289,130 3,685,980 396,850 12.07% 100.00% 100.00% Sewer Fund Charges for services-sewer 3,167,478 3,167,478 3,227,732 60,254 1.90% 98.16% 98.41% Interest on investments 25,000 25,000 52,000 27,000 108.00% 1.84% 1.59% Total Sewer Fund 3,192,478 3,192,478 3,279,732 87,254 2.73% 100.00% 100.00% Water Quality Fund Charges for services-storm water 813,603 813,603 817,652 4,049 0.50% 92.24% 89.05% Intergovernmental revenues 95,000 95,000 95,000 0 0.00% 6.81% 10.35% Interest on investments 3,903 3,903 5,560 1,657 42.45% 0.96% 0.61% Total Water Quality Fund 912,506 912,506 918,212 5,706 0.63% 100.00% 100.00% Transit Fund Charges for services-transit revenue 224,000 224,000 - (224,000) -100.00% 25.02% n/a Intergovernmental revenues 672,515 672,515 - (672,515) -100.00% 71.23% n/a Interest on investments 33,000 33,000 - (33,000) -100.00% 3.74% n/a Total Transit Fund 929,515 929,515 - (929,515) -100.00% 100.00% n/a GRAND TOTAL 25,315,085 25,391,085 25,968,835 577,750 2.28% of p'vORC City of Prior Lake Council Meeting 12.08.2014 2015 Proposed Budget D m Fund/Department Expense Summary from Amended Budget 2014 2015 2014 2014 2015 $Change %Change %of %of Adopted Amended Proposed 14-15 14-15 Subtotal Subtotal General Fund 41110 Mayor&Council 57,603 57,603 55,390 (2,213) -3.84% 0.43% 0.44% 41130 Ordinance 6,000 6,000 7,500 1,500 25.00% 0.05% 0.06% 41320 Administration 404,052 404,052 384,759 (19,292) -4.77% 3.05% 3.06% 41330 Boards&Commissions 10,339 10,339 10,339 0 0.00% 0.08% 0.08% 41410 Elections 100,020 100,020 75,000 (25,020) -25.01% 0.75% 0.60% 41520 Finance 427,661 427,661 434,683 7,022 1.64% 3.22% 3.46% 41540 Internal Auditing 25,125 25,125 29,950 4,825 19.20% 0.19% 0.24% 41500 Assessing 134,600 134,600 152,250 17,650 13.11% 1.01% 1.21% 41610 Legal 340,000 340,000 215,000 (125,000) -36.76% 2.56% 1.71% 41820 Personnel 161,128 161,128 160,221 (907) -0.56% 1.21% 1.28% 41830 Communications 125,648 125,648 122,301 (3,347) -2.66% 0.95% 0.97% 41910 Community Development 323,850 323,850 307,993 (15,856) -4.90% 2.44% 2.45% 41920 Technology 687,851 687,851 263,996 (423,855) -61.62% 5.18% 2.10% 41940 Buildings&Plant 430,500 430,500 513,457 82,957 19.27% 3.24% 4.09% 42100 Police 3,351,084 3,351,084 3,364,784 13,700 0.41% 25.26% 26.78% 42200 Fire 904,430 904,430 883,855 (20,575) -2.27% 6.82% 7.03% 42400 Building Inspection 562,984 562,984 577,443 14,459 2.57% 4.24% 4.60% 42500 Emergency Management 5,000 5,000 10,025 5,025 100.50% 0.04% 0.08% 42700 Animal Control 25,257 25,257 25,257 0 0.00% 0.19% 0.20% 43050 Engineering 371,001 371,001 380,147 9,146 2.47% 2.80% 3.03% 43100 Street 1,215,292 1,215,292 1,346,321 131,029 10.78% 9.16% 10.72% 43400 Central Garage 361,948 361,948 369,791 7,842 2.17% 2.73% 2.94% 45100 Recreation 387,320 387,320 359,377 (27,943) -7.21% 2.92% 2.86% 45200 Parks 1,321,511 1,480,030 1,331,676 (148,354) -10.02% 11.16% 10.60% 45500 Libraries 75,516 75,516 66,760 (8,756) -11.59% 0.57% 0.53% 46100 Natural Resources 77,594 77,594 79,824 2,230 2.87% 0.58% 0.64% 47000 Debt Service/Transfers 1,007,343 1,007,343 1,035,845 28,502 2.83% 7.59% 8.24% 49999 Contingency - 123,863 - (123,863) -100.00% 0.93% 0.00% 49303 Transfers 84,600 84,600 (84,600) -100.00% 0.64% 0.00% Total General Fund 12,985 255 13,267,637 12,563,945 (703,692) -5.30% 100.00% 100.00% Debt Service Funds 47000 Debt 7,589 881 7,589,881 4256 609 3,333 272 -43.92% 100.00% 100.00% Total Debt Service Funds 7,589,881 7,589,881 4,256,609 3333272 -43.92% 100.00% 100.00% Cable Fund 41340 Cable 7,000 7,000 n/a n/a 100.00% Total Cable Fund 7,000 7,000 n/a n/a 100.00% Capital Park Fund 45200 Parks 50,000 70,436 - (70,436) -100.00% 36.99% 0.00% xxxxx Named Park 120,000 120,000 50,000 (70,000) -58.33% 63.01% 100.00% Total Ca ital Park Fund 170,000 190,436 50,000 (140,436) -73.74% 100.00% 100.00% 18 oQ p'uOA City of Prior Lake Council Meeting 12.08.2014 2075 Proposed Budget Fund/Department Expense Summary From Amended Budget 2014 2015 2014 2014 2015 $Change %Change %of %of Adopted Amended Proposed 14-15 14-15 Subtotal Subtotal Revolving Equipment Fund 42100 Police 53,216 53,216 115,600 62,384 n/a 6.59% 14.12% 42200 Fire 36,050 118,816 150,950 32,134 n/a 14.70% 18.44% 43050 Engineering 25,750 25,750 - (25,750) n/a 3.19% 0.00% 43100 Street 207,957 207,957 310,500 102,543 49.31% 25.73% 37.93% 43400 Central Garage 72,165 72,165 20,000 (52,165) -72.29% 8.93% 2.44% 45200 Parks 93,833 93,833 108,000 14,167 n/a 11.61% 13.19% 49420 Water Quality - - 73,500 73,500 n/a 0.00% 8.98% 49450 Sewer 236,385 236,385 40,000 (196,385) -83.08% 29.25% 4.89% Total Revolving Equipment Fund 725,356 808,122 818,550 10,428 1.29% 100.00% 100.00% Facilities Management Fund 42200 Fire - - 87,056 87,056 n/a 0.00% 2.45% 43400 Central Garage(Maintenance Ctr) 300,500 300,500 598,933 298,433 99.31% 80.91% 16.89% 45100 Recreation 35,448 35,448 55,562 20,115 56.74% 9.54% 1.57% 45500 Library/Club Prior 35,448 35,448 55,562 20,115 56.74% 9.54% 1.57% xxxxx GESP - - 2,667,924 2,667,924 n/a 0.00% 75.23% 49303 Transfers 81,381 81,381 n/a 0.00% 2.29% Total Facilities Management Fund 371,395 371,395 3,546,418 3175023 854.89% 100.00% 100.00% EDA Special RevenueFund 46500 Economic Development 162,670 162,670 148,595 (14,075) -8.65% 85.99% 78.79% 46503 Technology Village Incubator 26,500 26,500 40,000 13,500 50.94% 14.01% 21.21% Total EDA Fund 189,170 189,170 188,595 575 -0.30% 100.00% 100.00% Water Fund 41520 Finance 85,157 85,157 86,090 933 1.10% 2.77% 1.50% 49400 Water 2,125,339 2,125,339 4,837,551 2,712,212 127.61% 69.03% 84.45% 49303 Transfers 868,235 868,235 804,695 63,540 -7.32% 28.20% 14.05% Total Water Fund 3,078,731 3,078,731 5,728,336 2 649,606 86.06% 100.00% 100.00% Sewer Fund 41520 Finance 85,148 85,148 86,040 892 1.05% 2.89% 2.59% 49450 Sewer 2,536,293 2,536,293 2,984,136 447,843 17.66% 85.98% 89.94% 49303 Transfers 328,446 328,446 247,760 (80,686) -24.57% 11.13% 7.47% Total Sewer Fund 2,949,887 2949887 3,317,936 368,049 12.48% 100.00% 100.00% Water Quality Fund 49420 Water Quality 764,205 764,205 1,125,299 361 094 47.25% 100.00% 100.00% Total Water Quality Fund 764,205 764,205 1,125,299 361,094 47.25% 100.00% 100.00% Transit Fund 49804 Transit Services 937,148 937,148 937,148 -100.00% 100.00% n/a Total Transit Fund 937,148 937,148 937,148 -100.00% 100.00% n/a GRAND TOTAL 29,761,028 30,146,612 31,602,688 1,456,076 4.83% 19 Lx1-::7J' I �F eiVOA F City of Prior Lake Council Meeting 12.08.2014 'u 2015 Proposed Budget Revenue Details Change from Amended 2014 2015 2014 2015 2014 2014 2015 $Change %Change %of %of %of %of Adopted Amended Proposed 14-15 14-15 Subtotal Subtotal Total Total General Fund Property taxes 31010 Current taxes 6,670,870 6,670,870 7,421,246 750,376 11.25% 90.70% 91.54% 31040 Fiscal disparities 683,650 683,650 685,977 2,327 0.34% 9.30% 8.46% 7,354,520 7,354,520 8,107,223 752,703 10.23% 100.00% 100.00% 61.15% 64.53% Licenses&permits 32100 Business licenses 1,400 1,400 1,200 (200) -14.29% 0.22% 0.19% 32110 Liquor licenses 66,520 66,520 64,420 (2,100) -3.16% 10.41% 10.02% 32160 Refuse haulers 3,600 3,600 4,000 400 11.11% 0.56% 0.62% 32161 Plumbing registrations 700 700 1,300 600 85.71% 0.11% 0.20% 32170 Outdoor concert permits 850 850 1,050 200 23.53% 0.13% 0.16% 32180 Cigarette licenses 2,250 2,250 2,250 - 0.00% 0.35% 0.35% 32210 Building permits 470,060 470,060 470,060 - 0.00% 73.57% 73.13% 32215 Mechanical permits 41,245 41,245 43,720 2,475 6.00% 6.46% 6.80% 32230 Plumbing permits 38,770 38,770 41,245 2,475 6.38% 6.07% 6.42% 32231 Sewer/water inspection 7,500 7,500 7,500 - 0.00% 1.17% 1.17% 32240 Animal licenses 3,750 3,750 3,750 0.00% 0.59% 0.58% 32260 Burning permits 2,250 2,250 2,250 0.00% 0.35% 0.35% 638,895 638,895 642,745 3,850 0.60% 100.00% 10000% 5.31% 512% Intergovernmental revenue 33160 Federal aids/grants 1,500 1,500 3,500 2,000 133.33% 0.10% 0.24% 33401 Local government aid 49,405 49,405 52,680 3,275 6.63% 3.19% 3.55% 33416 State aid-police training 7,860 7,860 7,800 (60) -0.76% 0.51% 0.53% 33418 State road&bridge aid 276,000 276,000 288,000 12,000 4.35% 17.81% 19.41% 33420 State fire aid-ins premium 205,000 205,000 209,000 4,000 1.95% 13.23% 14.09% 33421 State police aid-ins premium 160,000 160,000 175,000 15,000 9.38% 10.32% 11.79% 33620 Township fire&rescue aid 329,459 329,459 282,002 (47,457) -14.40% 21.25% 19.00% 33621 Liaison aid 44,820 44,820 45,860 1,040 2.32% 2.89% 3.09% 33631 Payment in lieu of taxes 400,000 400,000 420,000 20,000 5.00% 25.81% 28.30° 33700 Miscellaneous grants 76,000 (76,000) -100.00% 4.90% 0.00% 1,474,044 1,550,044 1,483,842 (66202) -4.27% 100.00% 100.00% 1289% 1181% Charges for services 34103 Zoning&subdivision fees 7,810 7,810 7,810 0.00% 0.46% 0.47% 34104 Plan check fees 291,420 291,420 291,420 0.00% 17.35% 17.72% 34105 Sale of maps/publications 1,000 1,000 1,000 0.00% 0.06% 0.06% 34107 Assessment searches 400 400 400 0.00% 0.02% 0.02% 34109 Project admin/eng fees 376,000 376,000 300,000 (76,000) -20.21% 22.38% 18.24% 34203 Accident/warrant reports 900 900 900 - 0.00% 0.05% 0.05% 34303 Franchise fees 571,700 571,700 595,000 23,300 4.08% 34.03% 36.18% 34304 PEG access fees 34,000 34,000 34,000 - 0.00% 2.02% 2.07% 34731 Softball fees 28,000 28,000 28,000 0.00% 1.67% 1.70% 34735 Recreation program fees 35,000 35,000 35,000 0.00% 2.08% 2.13% 34740 Beach concessions 750 750 750 0.00% 0.04% 0.05% 34760 Facility rental 71,021 71,021 71,520 499 0.70% 4.23% 4.35% 34761 Studio/pavilion rental 15,000 15,000 15,000 - 0.00% 0.89% 0.91% 34762 Park shelter rental 8,250 8,250 8,250 0.00% 0.49% 0.50% 34765 Tower leases 202,065 202,065 202,065 0.00% 12.03% 12.29% 34780 Park admission fees 10,000 10,000 10,000 0.00% 0.60% 0.61% 34783 Contract Services 26,500 26,500 43,500 17,000 64.15% 1.58% 2.64% 1,679,816 1,679,816 1,644615 (35201) -2.10% 100.00% 100.00% 13.97% 1309% Fines&forfeitures 35101 County court fines 110,000 110,000 - (110,000) -100.00% 70.97% n/a 35104 Prosecution restitution 45,000 45,000 (45,000) -100.00% 29.03% n/a 155,000 155,000 (155,000) -100.00% 100.00% n/a 1.29% 0.00% 20 pF PRfpR S City of Prior Lake Council Meeting 12.08.2014 m 2015 Proposed Budget Revenue Details Change from Amended 2014 2015 2014 2015 2014 2014 2015 $Change %Change °%of %of %of %of Adopted Amended Proposed 14-15 14-15 Subtotal Subtotal Total Total Miscellaneous revenues 36102 County Assess.Collection - - 35,000 35,000 n/a 0.00% 10.61% 36210 Interest earnings 120,000 120,000 120,000 - 0.00% 39.87% 36.36% 36211 Developer agreements 70,000 70,000 70,000 - 0.00% 23.26% 21.21% 36212 Miscellaneous revenue 100,000 100,000 94,000 (6,000) -6.00% 33.22% 28.48% 36230 Contributions&donations 11,000 11,000 11,000 0.00% 3.65% 3.33% 301,000 301,000 330,000 29,000 9.63% 100.00% 100.00% 2.50% 2.63% Other financing sources 39203 Transfers from other funds 348,540 348,540 355,520 6,980 2.00% 100.00% 100.00% 348,540 348,540 355,520 6,980 2.00% 100.00% 100.00% 2.90% 2.83% GENERAL FUND TOTAL 11,951,815 12,027,815 12,563,945 536,130 4.46% 100.00% 100.00% 100.00% 100.00% DEBT SERVICE FUNDS Property taxes 31010 Current taxes 1,744,398 1,744,398 1,877,863 133,465 7.65% 100.00% 100.00% 1,744,398 1,744,398 1,877,863 133,465 7.65% 100.00% 100.00% 43.64% 46.43% Miscellaneous revenues 36210 Interest earnings 30,731 30,731 26,527 (4,204) -13.68% 100.00% 27.79% 36212 Miscellaneous revenue 68,926 68,926 n/a 0.00% 72.21% 30,731 30,731 95,453 64,722 210.61% 100.00% 100.00% 0.77% 2.36% Other financing sources 36102 Special assessments 489,877 489,877 401,346 (88,531) -18.07% 22.05% 19.38°% 39203 Otherfinancing sources 1,731,814 1,731,814 1,670,085 (61,729) -3.56% 77.95% 80.62% 2,221,691 2,221,691 2,071,431 (150,260) -6.76% 100.00% 100.00% 55.59% 51.21% DEBT SERVICE FUNDS TOTAL 3,996,820 3,996,820 4,044,747 47,927 1.20% 100.00% 100.00% 100.00% 100.00% CABLEFUND Charges for services 34304 PEG access fees 5,133 5,133 n/a n/a 100.00% 5,133 5,133 n/a n/a 100.00% n/a 100.00% CABLE FUND TOTAL 5,133 5,133 n/a We 100.00°% n/a 100.00% REVOLVING EQUIPMENT FUND Property taxes 31010 Current taxes 200,000 200,000 250,000 50,000 25.00% 100.00% 100.00°% 200,000 200,000 250,000 50,000 25.00% 100.00% 100.00% 57.50% 37.80% Miscellaneous revenues 36210 Interest earnings 25,173 25,173 20,151 (5,022) -19.95% 100.00% 100.00% 25,173 25,173 20,151 (5,022) -19.95% 100.00% 100.00°% 7.24% 3.05% Other financing sources 39102 Sale of Property - - 31,000 31,000 n/a 0.00% 15.21% 39104 Forfeiture Property Sales - - 31,827 31,827 n/a 0.00% 15.61% 39203 Transfers from other funds 131,000 131,000 141,000 10,000 7.63% 100.00°% 69.18% 131,000 131,000 203,827 72,827 55.59% 100.00% 100.00% 37.66% 30.81% REVOLVING EQUIPMENT FUND TOTAL 356,173 356,173 473,978 117,805 33.08% 100.00% 100.00% 100.00% 100.00% 21 pF rtUpR City of Prior Lake Council Meeting 12.08.2014 2015 Proposed Budget Revenue Details Change from Amended 2014 2015 2014 2015 2014 2014 2015 $Change %Change %of %of %of %of Adopted Amended Proposed 14-15 14-15 Subtotal Subtotal Total Total FACILITIES MANAGEMENT FUND Miscellaneous revenues 36210 Interest earnings 2,831 2,831 11,458 8,627 304.73% 100.00% 100.00% 2,831 2,831 11,458 8,627 304.73% 100.00% 100.00% 0.81% 1.73% Other financing sources 39203 Transfers from other funds 45,000 45,000 50,000 5,000 11.11% 13.04% 7.69% 39310 Bond proceeds 300,000 300,000 600,000 300,000 100.00% 86.96% 92.31° XXXXX Capital lease proceeds n/a 0.00% 0.00% 345,000 345,000 650,000 305,000 88.41% 100.00% 100.00% 99.19% 98.27% FACILITIES MANAGEMENT FUND TOTAL 347,831 347,831 661,458 313,627 90.17% 100.00% 100.00% 100.00% 100.00% CAPITAL PARK FUND Charges for services 34760 Facility rental - - 23,400 23,400 n/a n/a 14.43% 34791 Dedication fees 138,750 138,750 138,750 0.00% 100.00% 85.57% 138,750 138,750 162,150 23,400 16.86% 100.00% 100.00% 95.85% 95.86% Miscellaneous revenues 36210 Interest earnings 6,000 6,000 7,000 1,000 16.67% 100.00% 100.00% 6,000 6,000 7,000 1,000 16.67% 100.00% 100.00% 4.15% 4.14% CAPITAL PARK FUND TOTAL 144,750 144,750 169,150 24,400 16.86% 100.00% 100.00% 100.00% 100.00% EDA SPECIAL REVENUE FUND Property taxes 31010 Current taxes 150,000 150,000 159,000 9,000 6.00% 77.29% 95.50% 150,000 150,000 159,000 9,000 6.00% 77.29% 95.50% 77.29% 95.50% Charges for services 3XXXX Leases/loan administration 9,185 9,185 7,000 (2,185) -23.79% 4.73% 4.20% 9,185 9,185 7,000 (2,185) -23.79% 4.73% 4.20% 4.73% 4.20% Miscellaneous revenues 36210 Interest earnings 282 282 500 218 77.30% 0.15% 0.30% 282 282 500 218 77.30% 0.15% 0.30% 0.15% 0.30% Other financing sources 39203 Transfers from other funds 34,600 34,600 (34,600) -100.00% 76.89% 0.00% 34,600 34,600 (34,600) -100.00% 10.03% 0.00% 9.95% 0.00% EDA SPECIAL REVENUE FUND TOTAL 194,067 194,067 166,500 (27,567) -14.20% 100.00% 100.00% 100.00% 100.00% WATER FUND Charges for services 37100 Water utility revenue 2,861,570 2,861,570 3,253,750 392,180 13.71% 87.67% 89.73% 37110 Capital facility revenue 254,910 254,910 247,080.00 (7,830) -3.07% 7.81% 6.81% 37150 Disconnect charges 4,500 4,500 - (4,500) -100.00% 0.14% 0.00% 37160 Penalties 25,000 25,000 7,000.00 (18,000) -72.00% 0.77% 0.19% 37170 Water meters 93,400 93,400 93,400.00 0.00% 2.86% 2.58% 37175 Pressure reducers 24,750 24,750 24,750.00 0.00% 0.76% 0.68% 3,264,130 3,264,130 3,625,980 361,850 11.09% 100.00% 100.00% 99.24% 98.37% Miscellaneous revenues 36210 Interest earnings 25,000 25,000 60,000 35,000 140.00% 100.00% 100.00% 25,000 25,000 60,000 35,000 140.00% 100.00% 100.00% 0.76% 1.63% WATER FUND TOTAL 3,289,130 3,289,130 3,665,980 396,850 12.07% 100.00% 100.00% 100.00% 100.00% 22 Of PRlpR City of Prior Lake Council Meeting 12.08.2014 2015 Proposed Budget Revenue Details Change from Amended 2014 2015 2014 2015 2014 2014 2015 $Change %Change %of %of %of %of Adopted Amended Proposed 14-15 14-15 Subtotal Subtotal Total Total SEWER FUND Charges for services 37102 City sewer utility revenue 1,394,344 1,394,344 1,437,028 42,684 3.06% 44.02% 44.52% 37104 Met council sewer utility revenue 1,501,054 1,501,054 1,536,624 35,570 2.37% 47.39% 47.61% 37110 Capital facility revenue 247,080 247,080 247,080 - 0.00% 7.80% 7.65% 37160 Penalties 25,000 25,000 7,000 (18,000) -72.00% 0.79% 0.22% 3,167,478 3,167,478 3,227,732 60,254 1.90% 100.00% 100.00% 99.22% 98.41% Miscellaneous revenues 36210 Interest earnings 25,000 25,000 52,000 27,000 108.00% 100.00% 100.00% 25,000 25,000 52,000 27,000 108.00% 100.00% 100.00% 0.78% 159% SEWER FUND TOTAL 3,192,478 3,192,478 3,279,732 87,254 2.73% 100.00% 100.00% 100.00% 100.00% WATER QUALITY FUND Charges for services 37120 Storm water revenue 813,603 813,603 817,652 4,049 0.50% 100.00% 100.00% 813,603 813,603 817,652 4,049 0.50% 100.00% 100.00% 89.16% 89.05% Intergovernmental revenue XXXXX Grant revenue 95,000 95,000 95,000 0.00% 100.00% 100.00% 95,000 95,000 95,000 0.00% 100.00% 100.00% 10.41% 10.35% Miscellaneous revenues 36210 Interest earnings 3,903 3,903 5,560 1,657 42.45% 100.00% 100.00% 3,903 3,903 5,560 1,657 42.45% 100.00% 100.00% 0.43% 0.61% WATER QUALITY FUND TOTAL 912,506 912,506 918,212 5,706 0.63% 100.00% 100.00% 100.00% 100.00% TRANSIT FUND Intergovernmental revenue 38422 State transit aid 672,515 672,515 (672,515) -100.00% 100.00% n/a 672,515 672,515 (672,515) -100.00% 100.00% n/a 72.35% n/a Charges for services 38400 Bus fares 224,000 224,000 (224,000) -100.00% 100.00% n/a 224,000 224,000 (224,000) -100.00% 100.00% n/a 24.10% n/a Miscellaneous revenues 36210 Interest earnings 33,000 33,000 (33,000) -100.00% 100.00% n/a 33,000 33,000 (33,000) -100.00% 100.00% n/a 3.55% n/a TRANSIT FUND TOTAL 929,515 929,515 (929,515) -100.00% 100.00% n/a 100.00% nla GRAND TOTAL-ALL BUDGETED FUNDS 25,315,085 25,391,085 25,968,835 577,750 2.28% 23 ZE7X /-p/3 iT OQ PR/pP City of Prior Lake Council Meeting 12.08.2014 2015 Proposed Budget Expenditure Details From Amended Budget.... 2014 2015 2014 2015 2014 2014 2015 $Change %Change %of %of %of %of Adopted Amended Proposed 14-15 14-16 Subtotal Subtotal Total Total GENERALFUND General Government 41110 Mayor&Council 107 Council Per Diems 8,750 8,750 7,000 (1,750) -20.00% 15.19% 12.64% 111 Council Salaries 39,180 39,180 39,180 0 0.00% 68.02% 70.73% 121 PERA Contributions 1,587 1,587 1,959 372 23.44% 2.76% 3.54% 122 FICA Contributions 1,004 1,004 434 (570) -56.76% 1.74% 0.78% 123 MEDICARE Contributions 695 695 670 (25) -3.60% 1.21% 1.21% 151 Workers Comp-Insurance 108 108 127 19 17.79% 0.19% 0.23% 201 Office Supplies-General 468 468 300 (168) -35.90% 0.81% 0.54% 321 Communications 561 561 - (561) -100.00% 0.97% 0.00% 331 Training&Certification 4,750 4,750 5,250 500 10.53% 8.25% 9.48% 437 Misc Expense-General 500 500 470 (30) -6.00% 0.87% 0.85% 57,603 57,603 55,390 (2,213) -3.84% 100.00% 100.00% 0.44% 0.44% 41130 Ordinance 351 Legal Notice 4,500 4,500 6,000 1,500 33.33% 75.00% 80.00% 352 Ordinance Publication 1,500 1,500 1,500 0 0.00% 25.00% 20.00% 6,000 6,000 7,500 1,500 25.00% 100.00% 100.00% 0.05% 0.06% 41320 Administration 101 Full Time Employees Regular 246,398 246,398 233,640 (12,758) -5.18% 60.98% 60.72% 112 Longevity 22,500 22,500 22,500 0 0.00% 5.57% 5.85% 113 Sick Leave 5,130 5,130 3,398 (1,732) -33.76% 1.27% 0.88% 121 PERA Contributions 19,495 19,495 19,616 121 0.62% 4.82% 5.10% 122 FICA Contributions 14,598 14,598 13,844 (754) -5.17% 3.61% 3.60% 123 MEDICARE Contributions 3,973 3,973 3,842 (132) -3.32% 0.98% 1.00% 131 Health Insurance 30,634 30,634 26,394 (4,240) -13.84% 7.58% 6.86% 132 Dental Insurance 1,440 1,440 1,330 (110) -7.64% 0.36% 0.35% 133 Life Insurance 1,868 1,868 1,926 58 3.08% 0.46% 0.50% 135 HCSP Contributions 780 780 630 (150) -19.23% 0.19% 0.16% 151 Workers Comp-Insurance 1,286 1,286 1,530 244 18.94% 0.32% 0.40% 100 Severance Compensation Funding 1,317 1,317 1,281 (36) -2.77% 0.33% 0.33% 201 Office Supplies-General 936 936 1,000 64 6.84% 0.23% 0.26% 202 Office Supplies-Dup&Copy 2,292 2,292 1,250 (1,042) -45.47% 0.57% 0.32% 314 Professional Services-General 17,200 17,200 17,200 0 0.00% 4.26% 4.47% 321 Communications 842 842 1,320 478 56.75% 0.21% 0.34% 331 Training&Certification 2,200 2,200 2,000 (200) -9.09% 0.54% 0.52% 334 Car Allowance 5,400 5,400 5,400 0 0.00% 1.34% 1.40% 433 Dues&Subscriptions 25,760 25,760 26,659 899 3.49% 6.38% 6.93% 404,052 404,052 384,759 (19,292) -4.77% 100.00% 100.00% 3.11% 3.06% 41330 Boards&Commissions 115 EDA/Planning Commission 9,000 9,000 9,000 0 0.00% 87.05% 87.05% 122 FICA Contributions 558 558 558 0 0.00% 5.40% 5.40% 123 MEDICARE Contributions 131 131 131 0 0.00% 1.27% 1.27% 331 Training&Certification 300 300 300 0 0.00% 2.90% 2.90% 433 Dues&Subscriptions 350 350 350 0 0.00% 3.39% 3.39% 10,339 10,339 10,339 0 0.00% 100.00% 100.00% 0.08% 0.08% 23 04 PRIpA ®� City of Prior Lake Council Meeting 12.08.2014 2015 Proposed Budget Expenditure Details From Amended Budget.... 2014 2015 2014 2015 2014 2014 2015 $Change %Change %of %of %of %of Adopted Amended Proposed 14-15 14-15 Subtotal Subtotal Total Total 41410 Elections 116 Election Judge Salaries 25,020 25,020 - (25,020) -100.00% 25.01% 0.00% 240 Small Tools&Equipment 75,000 75,000 75,000 0 0.00% 74.99% 100.00% 100,020 100,020 75,000 (25,020) -25.01% 100.00% 100.00% 0.77% 0.60% 41520 Finance 101 Full Time Employees Regular 310,424 310,424 324,935 14,510 4.67% 72.59% 74.75% 113 Sick Leave 3,156 3,156 2,768 (388) -12.31% 0.74% 0.64% 121 PERA Contributions 22,506 22,506 24,370 1,864 8.28% 5.26% 5.61% 122 FICA Contributions 19,442 19,442 20,318 876 4.51% 4.55% 4.67% 123 MEDICARE Contributions 4,547 4,547 4,752 205 4.51% 1.06% 1.09% 131 Health Insurance 40,452 40,452 34,798 (5,654) -13.98% 9.46% 8.01% 132 Dental Insurance 1,714 1,714 1,700 (14) -0.83% 0.40% 0.39% 133 Life Insurance 274 274 274 0 0.15% 0.06% 0.06% 135 HCSP Contributions 925 925 1,200 275 29.73% 0.22% 0.28% 151 Workers Comp-Insurance 1,493 1,493 1,915 422 28.23% 0.35% 0.44% 100 Severance Compensation Funding 1,552 1,552 1,625 73 4.67% 0.36% 0.37% 201 Office Supplies-General 702 702 700 (2) -0.28% 0.16% 0.16% 203 Office Supplies-Printed Forms 2,540 2,540 1,525 (1,015) -39.97% 0.59% 0.35% 240 Small Tools&Equipment 281 281 200 (81) -28.83% 0.07% 0.05% 314 Professional Services-General 1,800 1,800 2,000 200 11.11% 0.42% 0.46% 316 Bank Service Charges 7,250 7,250 7,250 0 0.00% 1.70% 1.67% 321 Communications 692 692 - (692) -100.00% 0.16% 0.00% 331 Training&Certification 3,160 3,160 3,435 275 8.70% 0.74% 0.79% 433 Dues&Subscriptions 4,675 4,675 845 (3,830) -81.93% 1.09% 0.19% 437 Misc Expense-General 75 75 75 0 0.00% 0.02% 0.02% 427,661 427,661 434,684 7,023 1.64% 100.00% 100.00% 3.29% 3.46% 41540 Internal Auditing 301 Audit 25,125 25,125 29,950 4,825 19.20% 100.00% 100.00% 0.19% 0.24% 41550 Assessing 310 Property Assessing 132,500 132,500 150,000 17,500 13.21% 98.44% 98.52% 314 Professional Services-General 2,100 2,100 2,250 150 7.14% 1.56% 1.48% 134,600 134,600 152,250 17,650 13.11% 100.00% 100.00% 1.04% 1.21% 41610 Legal 304 Legal Fees 175,000 175,000 215,000 40,000 22.86% 51.47% 100.00% 305 Prosecution 165,000 165,000 - (165,000) -100.00% 48.53% 0.00% 340,000 340,000 215,000 (125,000) -36.76% 100.00% 100.00% 2.62% 1.71% 41820 Personnel 101 Full Time Employees Regular 102,146 102,146 105,294 3,148 3.08% 63.39% 65.72% 113 Sick Leave 2,290 2,290 2,371 81 3.56% 1.42% 1.48% 121 PERA Contributions 7,406 7,406 7,897 491 6.64% 4.60% 4.93% 122 FICA Contributions 6,475 6,475 6,675 200 3.09% 4.02% 4.17% 123 MEDICARE Contributions 1,514 1,514 1,561 47 3.08% 0.94% 0.97% 131 Health Insurance 8,366 8,366 6,739 (1,627) -19.45% 5.19% 4.21% 132 Dental Insurance 377 377 370 (7) -1.87% 0.23% 0.23% 24 OQ PR/p4 City of Prior Lake Council Meeting 12.08.2014 2015 Proposed Budget Expenditure Details From Amended Budget.. 2014 2015 2014 2015 2014 2014 2015 $Change %Change %of %of %of %of Adopted Amended Proposed 14-15 14-15 Subtotal Subtotal Total Total 133 Life Insurance 54 54 54 0 0.00% 0.03% 0.03% 135 HCSP Contributions 300 300 300 0 0.00% 0.19% 0.19% 151 Workers Comp-Insurance 507 507 645 138 27.32% 0.31% 0.40% 100 Severance Compensation Funding 511 511 526 15 2.99% 0.32% 0.33% 201 Office Supplies-General 281 281 250 (31) -11.03% 0.17% 0.16% 314 Professional Services-General 12,000 12,000 10,000 (2,000) -16.67% 7.45% 6.24% 321 Communications 674 674 660 (14) -2.08% 0.42% 0.41% 331 Training&Certification 300 300 450 150 50.00% 0.19% 0.28% 354 Public Information 4,000 4,000 2,500 (1,500) -37.50% 2.48% 1.56% 437 Misc Expense-General 13,928 13,928 13,928 0 0.00% 8.64% 8.69% 161,128 161,128 160,220 (908) -0.56% 100.00% 100.00% 1.24% 1.28% 41830 Communications 101 Full Time Employees Regular 72,003 72,003 75,639 3,636 5.05% 57.31% 61.85% 103 Part Time Employees Regular 4,000 4,000 4,464 464 11.60% 3.18% 3.65% 121 PERA Contributions 5,220 5,220 5,673 453 8.67% 4.15% 4.64% 122 FICA Contributions 4,712 4,712 4,966 254 5.39% 3.75% 4.06% 123 MEDICARE Contributions 1,102 1,102 1,161 59 5.39% 0.88% 0.95% 131 Health Insurance 11,860 11,860 10,660 (1,200) -10.12% 9.44% 8.72% 132 Dental Insurance 480 480 480 0 0.00% 0.38% 0.39% 133 Life Insurance 68 68 68 0 0.00% 0.05% 0.06% 135 HCSP Contributions 300 300 300 0 0.00% 0.24% 0.25% 151 Workers Comp-Insurance 358 358 461 103 28.78% 0.28% 0.38% 100 Severance Compensation Funding 360 360 378 18 4.99% 0.29% 0.31% 210 Operating Supplies-General 1,684 1,684 750 (934) -55.46% 1.34% 0.61% 314 Professional Services-General 2,500 2,500 2,000 (500) -20.00% 1.99% 1.64% 331 Training&Certification - - 100 100 n/a 0.00% 0.08% 354 Public Information 19,000 19,000 15,200 (3,800) -20.00% 15.12% 12.43% 437 Misc Expense-General 2,000 2,000 - (2,000) -100.00% 1.59% 0.00% 125,648 125,648 122,301 (3,347) -2.66% 100.00% 100.00% 0.97% 0.97% 41910 Comm Development/Natural Res 101 Full Time Employees Regular 220,493 220,493 211,448 (9,045) -4.10% 68.08% 68.65% 102 Full Time Employees Overtime 3,000 3,000 3,000 0 0.00% 0.93% 0.97% 121 PERA Contributions 16,203 16,203 16,084 (120) -0.74% 5.00% 5.22% 122 FICA Contributions 13,857 13,857 13,296 (561) -4.05% 4.28% 4.32% 123 MEDICARE Contributions 3,241 3,241 3,110 (131) -4.05% 1.00% 1.01% 131 Health Insurance 32,431 32,431 26,099 (6,332) -19.52% 10.01% 8.47% 132 Dental Insurance 1,380 1,380 1,275 (105) -7.60% 0.43% 0.41% 133 Life Insurance 193 193 178 (14) -7.48% 0.06% 0.06% 135 HCSP Contributions 645 645 600 (45) -6.98% 0.20% 0.19% 151 Workers Comp-Insurance 1,060 1,060 1,247 187 17.65% 0.33% 0.40% 100 Severance Compensation Funding 1,102 1,102 1,057 (45) -4.10% 0.34% 0.34% 201 Office Supplies-General 1,404 1,404 1,400 (4) -0.28% 0.43% 0.45% 202 Office Supplies-Dup&Copy 468 468 500 32 6.84% 0.14% 0.16% 210 Operating Supplies-General 234 234 250 16 6.84% 0.07% 0.08% 240 Small Tools&Equipment 468 468 500 32 6.88% 0.14% 0.16% 313 Professional Services-Consultant 7,500 7,500 5,000 (2,500) -33.33% 2.32% 1.62% 314 Professional Services-General 920 920 950 30 3.26% 0.28% 0.31% 321 Communications 702 702 750 48 6.84% 0.22% 0.24% 25 p4 P/Vpk City of Prior Lake Council Meeting 12.08.2014 2015 Proposed Budget Expenditure Details From Amended Budget.... 2014 2015 2014 2015 2014 2014 2015 $Change %Change %of %of %of %of Adopted Amended Proposed 14-16 14-15 Subtotal Subtotal Total Total 331 Training&Certification 900 900 1,000 100 11.11% 0.28% 0.32% 404 Repair&Maint Service-Equipment 4,250 4,250 4,250 0 0.00% 1.31% 1.38% 433 Dues&Subscriptions 1,400 1,400 1,000 (400) -28.57% 0.43% 0.32% 437 Misc Expense-General 12,000 12,000 15,000 3,000 25.00% 3.71% 4.87% 323,850 323,850 307,993 (15,856) -4.90% 100.00% 100.00% 2.49% 2.45% 41920 Technology 101 Full Time Employees Regular 98,888 98,888 103,959 5,071 5.13% 14.38% 39.38% 121 PERA Contributions 7,169 7,169 7,797 628 8.75% 1.04% 2.95% 122 FICA Contributions 6,131 6,131 6,445 314 5.12% 0.89% 2.44% 123 MEDICARE Contributions 1,434 1,434 1,507 73 5.10% 0.21% 0.57% 131 Health Insurance 10,458 10,458 9,404 (1,053) -10.07% 1.52% 3.56% 132 Dental Insurance 471 471 490 19 3.96% 0.07% 0.19% 133 Life Insurance 71 71 71 0 0.00% 0.01% 0.03% 135 Health Savings Plan 375 375 375 0 0.00% 0.05% 0.14% 151 Workers Comp-Insurance 468 468 603 135 28.74% 0.07% 0.23% 100 Severance Compensation Funding 494 494 520 26 5.17% 0.07% 0.20% 210 Operating Supplies-General 973 973 1,040 67 6.88% 0.14% 0.39% 306 Training Expenses 2,000 2,000 2,000 0 0.00% 0.29% 0.76% 309 Software Design 31,570 31,570 18,723 (12,847) -40.69% 4.59% 7.09% 313 Professional Services-Consultant 172,000 172,000 7,000 (165,000) -95.93% 25.01% 2.65% 321 Communications 600 600 2,080 1,480 246.67% 0.09% 0.79% 407 Software Service Contract 45,840 45,840 77,119 31,279 68.24% 6.66% 29.21% 408 Hardware Service Contract - - 1,700 1,700 n/a 0.00% 0.64% 580 General Equipment 308,908 308,908 23,163 (285,745) -92.50% 44.91% 8.77% 687,851 687,851 263,996 (423,855) -61.62% 100.00% 100.00% 5.30% 2.10% 41940 Buildings&Plant 101 Full Time Employees Regular 23,275 23,275 50,277 27,002 116.01% 5.41% 9.79% 121 PERA Contributions 1,687 1,687 3,771 2,083 123.46% 0.39% 0.73% 122 FICA Contributions 1,443 1,443 3,117 1,674 116.01% 0.34% 0.61% 123 MEDICARE Contributions 337 337 729 392 116.01% 0.08% 0.14% 131 Health Insurance - - 8,995 8,995 n/a 0.00% 1.75% 132 Dental Insurance 480 480 n/a 0.00% 0.09% 133 Life Insurance 58 58 n/a 0.00% 0.01% 135 HCSP Contributions - - 180 180 n/a 0.00% 0.04% 151 Workers Comp-Insurance 808 808 3,552 2,744 339.45% 0.19% 0.69% 100 Severance Compensation Funding 116 116 251 135 116.00% 0.03% 0.05% 223 Repair&Maint Supplies-Bldgs 5,614 5,614 5,614 0 0.00% 1.30% 1.09% 313 Prof Serv.-Consultant 9,000 9,000 9,000 0 0.00% 2.09% 1.75% 321 Communications 15,021 15,021 15,021 0 0.00% 3.49% 2.93% 322 Communications-Postage 16,350 16,350 16,350 0 0.00% 3.80% 3.18% 361 Insurance-Liability 94,365 94,365 104,378 10,013 10.61% 21.92% 20.33% 362 Insurance-Property 110,481 110,481 109,570 (911) -0.82% 25.66% 21.34% 381 Utilities-Electric 43,041 43,041 70,900 27,859 64.73% 10.00% 13.81% 383 Utilities-Gas 28,070 28,070 33,500 5,430 19.34% 6.52% 6.52% 384 Refuse Disposal 1,224 1,224 1,051 (173) -14.13% 0.28% 0.20% 401 Repair&Maint Service-Bldgs 30,037 30,037 30,250 213 0.71% 6.98% 5.89% 404 Repair&Maint Service-Equipment 8,850 8,850 8,850 0 0.00% 2.06% 1.72% 406 Repair&Maint Service-Clean 25,741 25,741 24,011 (1,730) -6.72% 5.98% 4.68% 26 OQ PRlpk City of Prior Lake Council Meeting 12.08.2014 x2015 Proposed Budget Expenditure Details " say' From Amended Budget.... 2014 2015 2014 2015 2014 2014 2015 $Change %Change %of %of %of %of Adopted Amended Proposed 14-15 14-15 Subtotal Subtotal Total Total 413 Rentals-Office Equipment 5,053 5,053 5,053 0 0.00% 1.17% 0.98% 570 Office Equipment&Furnishings 9,985 9,985 8,500 (1,485) -14.88% 2.32% 1.66% 430,500 430,500 513,457 82,957 19.27% 100.00% 100.00% 3.32% 4.09% Total General Government 3,234,377 3,234,377 2,732,840 (501,536) -15.51% 100.00% 100.00% 24.91% 21.75% Public Safety 42100 Police 101 Full Time Employees Regular 1,980,580 1,980,580 2,027,195 46,615 2.35% 59.10% 60.25% 102 Full Time Employees Overtime 121,000 121,000 123,000 2,000 1.65% 3.61% 3.66% 103 Part Time Employees Regular 106,303 106,303 81,794 (24,509) -23.06% 3.17% 2.43% 106 Training Overtime 9,211 9,211 9,211 0 0.00% 0.27% 0.27% 112 Longevity 102,077 102,077 96,536 (5,541) -5.43% 3.05% 2.87% 113 Sick Leave 26,561 26,561 13,287 (13,274) -49.98% 0.79% 0.39% 119 Clothing Allowance 20,185 20,185 20,264 79 0.39% 0.60% 0.60% 121 PERA Contributions 334,166 334,166 357,895 23,729 7.10% 9.97% 10.64% 122 FICA Contributions 16,071 16,071 14,836 (1,235) -7.69% 0.48% 0.44% 123 MEDICARE Contributions 34,306 34,306 34,384 78 0.23% 1.02% 1.02% 131 Health Insurance 242,318 242,318 213,322 (28,996) -11.97% 7.23% 6.34% 132 Dental Insurance 11,244 11,244 11,089 (155) -1.38% 0.34% 0.33% 133 Life Insurance 1,753 1,753 1,753 0 0.00% 0.05% 0.05% 135 HCSP Contributions 6,180 6,180 5,895 (285) -4.61% 0.18% 0.18% 151 Workers Comp-Insurance 49,362 49,362 61,474 12,112 24.54% 1.47% 1.83% 100 Severance Compensation Funding 10,945 10,945 11,689 744 6.80% 0.33% 0.35% 201 Office Supplies-General 3,509 3,509 3,509 0 0.00% 0.10% 0.10% 202 Office Supplies-Dup&Copy 842 842 841 (1) -0.13% 0.03% 0.02% 203 Office Supplies-Printed Forms 1,684 1,684 1,684 0 0.00% 0.05% 0.05% 210 Operating Supplies-General 5,895 5,895 6,895 1,000 16.97% 0.18% 0.20% 212 Operating Supplies-Fuel 66,780 66,780 58,380 (8,400) -12.58% 1.99% 1.74% 217 Operating Supplies-Uniforms 9,421 9,421 18,059 8,638 91.69% 0.28% 0.54% 221 Repair&Maint Sup-Equipment 2,339 2,339 2,339 0 0.00% 0.07% 0.07% 223 Repair&Maint Sup-Bldgs 4,211 4,211 4,211 0 0.00% 0.13% 0.13% 228 Repair&Maint Sup-Vehicles 3,000 3,000 3,000 0 0.00% 0.09% 0.09% 240 Small Tools&Equipment 18,129 18,129 18,129 0 0.00% 0.54% 0.54% 306 Training Expenses 9,500 9,500 10,000 500 5.26% 0.28% 0.30% 314 Professional Services-General 29,100 29,100 25,400 (3,700) -12.71% 0.87% 0.75% 321 Communications 10,292 10,292 11,000 708 6.88% 0.31% 0.33% 324 Communications-Ticketwriter 4,500 4,500 4,000 (500) -11.11% 0.13% 0.12% 325 Communications-State Terminal 1,080 1,080 1,080 0 0.00% 0.03% 0.03% 326 Communications-Computer 3,240 3,240 3,240 0 0.00% 0.10% 0.10% 331 Training&Certification 1,500 1,500 1,500 0 0.00% 0.04% 0.04% 363 Insurance-Auto 4,500 4,500 7,508 3,008 66.84% 0.13% 0.22% 381 Utilities-Electric 28,070 28,070 34,600 6,530 23.26% 0.84% 1.03% 383 Utilities-Gas 14,971 14,971 13,000 (1,971) -13.17% 0.45% 0.39% 384 Refuse Disposal 600 600 433 (167) -27.83% 0.02% 0.01% 401 Repair&Maint Service-Bldgs 17,000 17,000 15,296 (1,704) -10.02% 0.51% 0.45% 404 Repair&Maint Service-Equipment 5,000 5,000 5,000 0 0.00% 0.15% 0.15% 406 Repair&Maint Service-Clean 15,783 15,783 14,857 (926) -5.87% 0.47% 0.44% 27 pQ PRIpA City of Prior Lake Council Meeting 12.08.2014 2015 Proposed Budget Expenditure Details From Amended Budget. 2014 2015 2014 2015 2014 2014 2015 $Change %Change %of %of %of %of Adopted Amended Proposed 14-15 14-15 Subtotal Subtotal Total Total 407 Software Service Contract - - 4,200 4,200 n/a 0.00% 0.12% 413 Rentals-Office Equipment 3,876 3,876 - (3,876) -100.00% 0.12% 0.00% 421 Special Response Team SRT 10,000 10,000 10,000 0 0.00% 0.30% 0.30% 433 Dues&Subscriptions 3,000 3,000 3,000 0 0.00% 0.09% 0.09% 437 MiscExpense-General 1,000 1,000 - (1,000) -100.00% 0.03% 0.00% 3,351,084 3,351,084 3,364,784 13,700 0.41% 100.00% 100.00% 25.81% 26.78% 42200 Fire 101 Full Time Employees Regular 102,328 102,328 107,576 5,248 5.13% 11.31% 12.17% 104 Temporary Employees Regular 9,100 9,100 - (9,100) -100.00% 1.01% 0.00% 113 Sick Leave - - 639 639 n/a 0.00% 0.07% 117 Volunteer Compensation 206,520 206,520 195,760 (10,760) -5.21% 22.83% 22.15% 121 PERA Contributions 15,656 15,656 17,427 1,771 11.31% 1.73% 1.97% 122 FICA Contributions 13,368 13,368 10,727 (2,642) -19.76% 1.48% 1.21% 123 MEDICARE Contributions 4,610 4,610 4,078 (532) -11.55% 0.51% 0.46% 124 Pension Contribution 20,000 20,000 20,000 0 0.00% 2.21% 2.26% 125 Insurance Premium Contribution 205,000 205,000 209,000 4,000 1.95% 22.67% 23.65% 131 Health Insurance 10,408 10,408 8,995 (1,413) -13.58% 1.15% 1.02% 132 Dental Insurance 480 480 480 0 0.00% 0.05% 0.05% 133 Life Insurance 68 68 68 0 0.00% 0.01% 0.01% 135 HCSP Contributions 300 300 300 0 0.00% 0.03% 0.03% 151 Workers Comp-Insurance 35,431 35,431 36,841 1,411 3.98% 3.92% 4.17% 100 Severance Compensation Funding 512 512 538 26 5.15% 0.06% 0.06% 201 Office Supplies-General 281 281 281 0 0.00% 0.03% 0.03% 202 Office Supplies-Dup&Copy 173 173 174 1 0.52% 0.02% 0.02% 210 Operating Supplies-General 6,316 6,316 6,316 0 0.00% 0.70% 0.71% 212 Operating Supplies-Fuel 15,900 15,900 14,950 (950) -5.97% 1.76% 1.69% 217 Operating Supplies-Uniforms 31,813 31,813 31,813 0 0.00% 3.52% 3.60% 218 Operating Supplies-Medical 1,684 1,684 1,684 0 0.00% 0.19% 0.19% 221 Repair&Maint Sup-Equipment 7,485 7,485 7,485 0 0.00% 0.83% 0.85% 223 Repair&Maint Sup-Bldgs 7,485 7,485 7,485 0 0.00% 0.83% 0.85% 240 Small Tools&Equipment 14,971 14,971 21,989 7,018 46.88% 1.66% 2.49% 306 Training Expenses 15,500 15,500 15,500 0 0.00% 1.71% 1.75% 321 Communications 8,241 8,241 8,808 567 6.88% 0.91% 1.00% 331 Training&Certification 3,500 3,500 3,500 0 0.00% 0.39% 0.40% 354 Public Information 6,500 6,500 6,500 0 0.00% 0.72% 0.74% 363 Insurance Auto 11,500 11,500 10,525 (975) -8.48% 1.27% 1.19% 381 Utilities-Electric 25,263 25,263 26,500 1,237 4.90% 2.79% 3.00% 383 Utilities-Gas 16,374 16,374 16,000 (374) -2.28% 1.81% 1.81% 384 Refuse Disposal 948 948 866 (82) -8.65% 0.10% 0.10% 401 Repair&Maint Service-Bldgs 25,560 25,560 21,088 (4,472) -17.50% 2.83% 2.39% 404 Repair&Maint Service-Equipment 16,800 16,800 16,800 0 0.00% 1.86% 1.90% 406 Repair&Maint Service-Clean 10,837 10,837 6,663 (4,174) -38.52% 1.20% 0.75% 433 Dues&Subscriptions 2,000 2,000 2,000 0 0.00% 0.22% 0.23% 437 Misc Expense-General 3,500 3,500 3,500 0 0.00% 0.39% 0.40% 520 Buildings&Structures 41,000 41,000 41,000 0 0.00% 4.53% 4.64% 580 General Equipment 7,018 7,018 - (71018) -100.00% 0.78% 0.00% 904,430 904,430 883,855 (20,575) -2.27% 100.00% 100.00% 6.97% 7.03% 28 aQ rxtpR City of Prior Lake Council Meeting 12.08.2014 2015 Proposed Budget Expenditure Details From Amended Budget.... 2014 2015 2014 2015 2014 2014 2015 $Change %Change %of %of %of %of Adopted Amended Proposed 14-15 14-15 Subtotal Subtotal Total Total 42400 Building Inspection 101 Full Time Employees Regular 399,812 399,812 416,353 16,541 4.14% 71.02% 72.10% 102 Full Time Employees Overtime 7,500 7,500 7,500 0 0.00% 1.33% 1.30% 104 Temporary Employees Regular 15,400 15,400 15,400 0 0.00% 2.74% 2.67% 113 Sick Leave 2,663 2,663 1,795 (868) -32.61% 0.47% 0.31% 121 PERA Contributions 29,530 29,530 31,789 2,259 7.65% 5.25% 5.51% 122 FICA Contributions 26,373 26,373 27,345 972 3.68% 4.68% 4.74% 123 MEDICARE Contributions 6,168 6,168 6,395 227 3.68% 1.10% 1.11% 131 Health Insurance 56,452 56,452 42,946 (13,506) -23.92% 10.03% 7.44% 132 Dental Insurance 2,434 2,434 2,420 (14) -0.58% 0.43% 0.42% 133 Life Insurance 319 319 319 0 0.00% 0.06% 0.06% 135 HCSP Contributions 990 990 1,140 150 15.15% 0.18% 0.20% 151 Workers Comp-Insurance 2,056 2,056 2,630 574 27.92% 0.37% 0.46% 100 Severance Compensation Funding 1,999 1,999 2,082 83 4.15% 0.36% 0.36% 201 Office Supplies-General 1,404 1,404 1,500 96 6.84% 0.25% 0.26% 203 Office Supplies-Printed Forms 1,404 1,404 1,500 96 6.84% 0.25% 0.26% 210 Operating Supplies-General 1,216 1,216 1,000 (216) -17.76% 0.22% 0.17% 212 Operating Supplies-Fuel 3,180 3,180 8,340 5,160 162.26% 0.56% 1.44% 217 Operating Supplies-Uniforms 374 374 374 0 0.00% 0.07% 0.06% 240 Small Tools&Equipment 561 561 300 (261) -46.56% 0.10% 0.05% 321 Communications 898 898 2,900 2,002 222.85% 0.16% 0.50% 331 Training&Certification 1,500 1,500 2,300 800 53.33% 0.27% 0.40% 363 Insurance-Auto 350 350 315 (35) -10.00% 0.06% 0.05% 433 Dues&Subscriptions 400 400 400 0 0.00% 0.07% 0.07% 437 Misc Expense-General - - 400 400 n/a 0.00% 0.07% 562,984 562,984 577,443 14,459 2.57% 100.00% 100.00% 4.34% 4.60% 42500 Emergency Management 381 Utilities-Electric 1,500 1,500 2,000 500 33.33% 30.00% 19.95% 404 Repair&Maint Service-Equipment 3,500 3,500 8,025 4,525 129.29% 70.00% 80.05% 5,000 5,000 10,025 5,025 100.50% 100.00% 100.00% 0.04% 0.08% 42700 Animal Control 311 Animal Control Contract 25,257 25,257 25,257 0 0.00% 100.00% 100.00% 0.19% 0.20% Total Public Safety 4,848,755 4,848,755 4,861,364 12,609 0.26% 100.00% 100.00% 37.34% 38.69% Public Works 43050 Engineering 101 Full Time Employees Regular 212,016 212,016 219,486 7,470 3.52% 57.15% 57.74% 102 Full Time Employees Overtime 7,500 7,500 5,000 (2,500) -33.33% 2.02% 1.32% 103 Part Time Employees-Regular 30,826 30,826 26,077 (4,748) -15.40% 8.31% 6.86% 104 Temporary Employees-Regular - - 11,800 11,800 n/a 0.00% 3.10% 113 Sick Leave 1,700 1,700 2,566 866 50.93% 0.46% 0.68% 121 PERA Contributions 18,150 18,150 18,792 642 3.54% 4.89% 4.94% 122 FICA Contributions 15,627 15,627 16,426 799 5.12% 4.21% 4.32% 123 MEDICARE Contributions 3,655 3,655 3,841 186 5.10% 0.99% 1.01% 131 Health Insurance 29,158 29,158 28,249 (909) -3.12% 7.86% 7.43% 29 oQ rxioa City of Prior Lake Councit Meeting 12.08.2014 2015 Proposed Budget u � Expenditure Details From Amended Budget.... 2014 2015 2014 2015 2014 2014 2015 $Change %Change %of %of %of %of Adopted Amended Proposed 14-15 14-15 Subtotal Subtotal Total Total 132 Dental Insurance 1,205 1,205 1,200 (5) -0.38% 0.32% 0.32% 133 Life Insurance 165 165 165 0 0.00% 0.04% 0.04% 135 HCSP Contributions 795 795 675 (120) -15.09% 0.21% 0.18% 151 Workers Comp-Insurance 1,218 1,218 1,581 363 29.78% 0.33% 0.42% 100 Severance Compensation Funding 1,214 1,214 1,228 14 1.14% 0.33% 0.32% 201 Office Supplies-General 1,684 1,684 1,700 16 0.95% 0.45% 0.45% 202 Office Supplies-Dup&Copy 468 468 500 32 6.88% 0.13% 0.13% 205 Drafting Supplies 281 281 300 19 6.76% 0.08% 0.08% 210 Operating Supplies-General 3,883 3,883 5,500 1,617 41.64% 1.05% 1.45% 212 Operating Supplies-Fuel 3,000 3,000 2,780 (220) -7.33% 0.81% 0.73% 217 Operating Supplies-Clothing 281 281 300 19 6.76% 0.08% 0.08% 240 Small Tools&Equipment 936 936 500 (436) -46.56% 0.25% 0.13% 303 Professional Service-Engineering 25,000 25,000 20,000 (5,000) -20.00% 6.74% 5.26% 314 Professional Service-General 920 920 460 (460) -50.00% 0.25% 0.12% 321 Communications 2,470 2,470 2,640 170 6.88% 0.67% 0.69% 331 Training&Certification 3,000 3,000 2,550 (450) -15.00% 0.81% 0.67% 363 Insurance-Auto 350 350 330 (20) -5.71% 0.09% 0.09% 404 Repair&Maint Service-Equipment 3,000 3,000 3,500 500 16.67% 0.81% 0.92% 407 Software Service Contract 1,600 1,600 1,600 0 0.00% 0.43% 0.42% 413 Rentals-Office Equipment 500 500 - (500) -100.00% 0.13% 0.00% 437 Misc Expense-General 400 400 400 0 0.00% 0.11% 0,11% 371,001 371,001 380,147 9,146 2.47% 100.00% 100.00% 2.86% 3.03% 43100 Street 101 Full Time Employees Regular 215,296 215,296 226,383 11,087 5.15% 17.72% 16.81% 102 Full Time Employees Overtime 23,000 23,000 23,000 0 0.00% 1.89% 1.71% 104 Temporary Employees-Regular 10,000 10,000 10,000 0 0.00% 0.82% 0.74% 113 Sick Leave 1,281 1,281 57 (1,224) -95.55% 0.11% 0.00% 121 PERA Contributions 17,276 17,276 18,704 1,427 8.26% 1.42% 1.39% 122 FICA Contributions 15,474 15,474 16,085 611 3.95% 1.27% 1.19% 123 MEDICARE Contributions 3,619 3,619 3,762 143 3.96% 0.30% 0.28% 131 Health Insurance 39,579 39,579 33,818 (5,761) -14.56% 3.26% 2.51% 132 Dental Insurance 1,688 1,688 1,672 (16) -0.94% 0.14% 0.12% 133 Life Insurance 206 206 206 0 0.00% 0.02% 0.02% 135 HCSP Contributions 784 784 810 26 3.35% 0.06% 0.06% 151 Workers Comp-Insurance 13,196 13,196 16,952 3,756 28.47% 1.09% 1.26% 100 Severance Compensation Funding 1,076 1,076 1,132 56 5.16% 0.09% 0.08% 210 Operating Supplies-General 4,725 4,725 4,726 1 0.02% 0.39% 0.35% 212 Operating Supplies-Fuel 47,700 47,700 61,980 14,280 29.94% 3.92% 4.60% 215 Operating Supplies-Shop Material 3,743 3,743 740 (3,003) -80.23% 0.31% 0.05% 217 Operating Supplies-Uniforms 2,620 2,620 2,620 0 0.00% 0.22% 0.19% 219 Operating Supplies-Snow&Ice 62,024 62,024 73,990 11,966 19.29% 5.10% 5.50% 223 Repair&Maint Sup-Bldgs 1,029 1,029 1,030 1 0.07% 0.08% 0.08% 224 Repair&Maint Sup-General 89,899 89,899 103,835 13,936 15.50% 7.40% 7.71% 240 Small Tools&Equipment 4,678 4,678 4,679 1 0.01% 0.38% 0.35% 331 Training&Certification 4,100 4,100 4,100 0 0.00% 0.34% 0.30% 363 Insurance-Auto 1,870 1,870 1,963 93 4.97% 0.15% 0.15% 381 Utilities-Electric 1,310 1,310 500 (810) -61.83% 0.11% 0.04% 384 Refuse Disposal 900 900 900 0 0.00% 0.07% 0.07% 386 Street Lighting 182,082 182,082 200,200 18,118 9.95% 14.98% 14.87% 30 OQ PR7pR City of Prior Lake Council Meeting 12.08.2014 2015 Proposed Budget Expenditure Details From Amended Budget . 2014 2015 2014 2015 2014 2014 2015 $Change %Change %of %of %of %of Adopted Amended Proposed 14-15 14-15 Subtotal Subtotal Total Total 407 Software Service Contract 12,000 12,000 12,000 0 0.00% 0.99% 0.89% 409 Dust Control 5,614 5,614 5,614 0 0.00% 0.46% 0.42% 412 Repair&Maint Service-General 443,000 443,000 509,340 66,340 14.98% 36.45% 37.83% 415 Rentals-Heavy Equipment 4,678 4,678 4,678 0 0.00% 0.38% 0.35% 433 Dues&Subscriptions 845 845 845 0 0.00% 0.07% 0.06% 1,215,292 1,215,292 1,346,321 131,029 10.78% 100.00% 100.00% 9.36% 10.72% 43400 Central Garage 101 Full Time Employees Regular 114,691 114,691 117,562 2,871 2.50% 31.69% 31.79% 102 Full Time Employees Overtime 3,026 3,026 3,026 0 0.00% 0.84% 0.82% 104 Temporary Employees Regular 9,600 9,600 9,600 0 0.00% 2.65% 2.60% 113 Sick Leave - - 943 943 n/a 0.00% 0.26% 121 PERA Contributions 8,535 8,535 9,044 510 5.97% 2.36% 2.45% 122 FICA Contributions 7,894 7,894 8,130 236 2.99% 2.18% 2.20% 123 MEDICARE Contributions 1,846 1,846 1,901 55 2.97% 0.51% 0.51% 131 Health Insurance 23,720 23,720 21,320 (2,400) -10.12% 6.55% 5.77% 132 Dental Insurance 960 960 960 0 0.00% 0.27% 0.26% 133 Life Insurance 115 115 115 0 0.00% 0.03% 0.03% 135 HCSP Contributions 360 360 360 0 0.00% 0.10% 0.10% 151 Workers Comp-Insurance 3,679 3,679 4,674 995 27.06% 1.02% 1.26% 100 Severance Compensation Funding 573 573 588 14 2.50% 0.16% 0.16% 201 Office Supplies-General 468 468 468 0 0.00% 0.13% 0.13% 203 Office Supplies-Printed Forms 281 281 281 0 0.00% 0.08% 0.08% 210 Operating Supplies-General 5,614 5,614 5,614 0 0.00% 1.55% 1.52% 215 Operating Supplies-Shop Material 6,550 6,550 6,550 0 0.00% 1.81% 1.77% 217 Operating Supplies-Uniforms 2,339 2,339 2,339 0 0.00% 0.65% 0.63% 240 Small Tools&Equipment 6,082 6,082 9,200 3,118 51.27% 1.68% 2.49% 331 Training&Certification 2,000 2,000 2,000 0 0.00% 0.55% 0.54% 384 Refuse Disposal 500 500 1,000 500 100.00% 0.14% 0.27% 407 Software Service Contract 100 100 100 0 0.00% 0.03% 0.03% 412 Repair&Maint Service-General 1,600 1,600 1,600 0 0.00% 0.44% 0.43% 433 Dues&Subscriptions 2,200 2,200 3,200 1,000 45.45% 0.61% 0.87% 437 Misc Expense-General 900 900 900 0 0.00% 0.25% 0.24% 451 Repair Sup-Parts(P/S) 10,292 10,292 10,292 (0) 0.00% 2.84% 2.78% 452 Repair Sup-Parts(P/K) 16,842 16,842 16,842 (0) 0.00% 4.65% 4.55% 453 Repair Sup-Parts(P/W) 14,035 14,035 14,035 (0) 0.00% 3.88% 3.80% 454 Repair Sup-Parts(SNV) 3,743 3,743 3,743 0 0.01% 1.03% 1.01% 461 Repair Sup-Equip(P/S) 6,550 6,550 6,550 0 0.00% 1.81% 1.77% 462 Repair Sup-Equip(P/K) 24,327 24,327 24,327 (0) 0.00% 6.72% 6.58% 463 Repair Sup-Equip(PNV) 34,620 34,620 34,620 0 0.00% 9.56% 9.36% 464 Repair Sup-Equip(SNV) 8,421 8,421 8,421 (0) 0.00% 2.33% 2.28% 471 Batteries &Tires(P/S) 8,421 8,421 8,421 (0) 0.00% 2.33% 2.28% 472 Batteries &Tires(P/K) 7,953 7,953 7,953 (0) 0.00% 2.20% 2.15% 473 Batteries &Tires(P/W) 7,018 7,018 7,018 0 0.01% 1.94% 1.90% 474 Batteries &Tires(SNV) 1,871 1,871 1,871 (0) -0.02% 0.52% 0.51% 481 Minor Sery-Contract(P/S) 3,743 3,743 3,743 0 0.01% 1.03% 1.01% 482 Minor Sery-Contract(P/K) 2,339 2,339 2,339 (0) -0.01% 0.65% 0.63% 483 Minor Sery-Contract(PAN) 2,058 2,058 2,058 (0) -0.02% 0.57% 0.56% 484 Minor Sery-Contract(S/W) 936 936 936 0 0.04% 0.26% 0.25% 491 Major Sery-Contract(P/S) 1,871 1,871 1,871 (0) -0.02% 0.52% 0.51% 31 pQ PRtpk City of Prior Lake Council Meeting 12.08.2014 „ 2015 Proposed Budget Expenditure Details From Amended Budget 2014 2015 2014 2015 2014 2014 2015 $Change %Change %of %of %of %of Adopted Amended Proposed 14-15 14-15 Subtotal Subtotal Total Total 492 Major Sery-Contract(P/K) 1,404 1,404 1,404 0 0.03% 0.39% 0.38% 493 Major Sery-Contract(PNV) 936 936 936 0 0.04% 0.26% 0.25% 494 Major Sery-Contract(SNV) 936 936 936 0 0.04% 0.26% 0.25% 361,948 361,948 369,791 7,842 2.17% 100.00% 100.00% 2.79% 2.94% Total Public Works 1,948,241 1,948,241 2,096,259 148,017 7.60% 100.00% 100.00% 15.00% 16.68% Culture/Recreation 45100 Recreation 101 Full Time Employees Regular 123,622 123,622 128,583 4,960 4.01% 31.92% 35.78% 103 Part Time Emlpoyees-Regular 35,384 35,384 37,203 1,819 5.14% 9.14% 10.35% 104 Temporary Employees-Regular 70,812 70,812 50,812 (20,000) -28.24% 18.28% 14.14% 121 PERA Contributions 11,528 11,528 12,434 906 7.86% 2.98% 3.46% 122 FICA Contributions 14,249 14,249 13,429 (820) -5.75% 3.68% 3.74% 123 MEDICARE Contributions 3,332 3,332 3,141 (192) -5.75% 0.86% 0.87% 131 Health Insurance 20,226 20,226 17,399 (2,827) -13.98% 5.22% 4.84% 132 Dental Insurance 857 857 850 (7) -0.82% 0.22% 0.24% 133 Life Insurance 112 112 112 (0) -0.36% 0.03% 0.03% 135 HCSP Contributions 660 660 660 0 0.00% 0.17% 0.18% 151 Workers Comp-Insurance 6,059 6,059 7,036 978 16.14% 1.56% 1.96% 100 Severance Compensation Funding 795 795 829 34 4.26% 0.21% 0.23% 201 Office Supplies-General 936 936 500 (436) -46.58% 0.24% 0.14% 202 Office Supplies-Dup&Copy 234 234 150 (84) -35.88% 0.06% 0.04% 208 Senior Programs 11,000 11,000 11,000 0 0.00% 2.84% 3.06% 220 Operating Supplies-Playground 38,792 38,792 28,793 (9,999) -25.78% 10.02% 8.01% 259 Concessions 702 702 702 0 0.03% 0.18% 0.20% 308 Instructor's Fees 16,500 16,500 16,500 0 0.00% 4.26% 4.59% 316 Bank Service Charges 2,000 2,000 3,000 1,000 50.00% 0.52% 0.83% 321 Communications 2,077 2,077 450 (1,627) -78.34% 0.54% 0.13% 331 Training&Certification 1,100 1,100 1,100 0 0.00% 0.28% 0.31% 354 Public Information 1,500 1,500 2,000 500 33.33% 0.39% 0.56% 404 Repair&Maint Service-Equipment 1,955 1,955 - (1,955) -100.00% 0.50% 0.00% 406 Repair&Maint Service-Clean 1,588 1,588 2,202 614 38.66% 0.41% 0.61% 417 Community Events 20,550 20,550 19,743 (807) -3.93% 5.31% 5.49% 433 Dues&Subscriptions 750 750 750 0 0.00% 0.19% 0.21% 387,320 387,320 359,377 (27,943) -7.21% 100.00% 100.00% 2.98% 2.86% 45200 Parks 101 Full Time Employees Regular 420,634 420,634 436,201 15,567 3.70% 31.83% 32.76% 102 Full Time Employees Overtime 20,000 20,000 20,000 0 0.00% 1.51% 1.50% 104 Temporary Employees-Regular 195,600 195,600 195,600 0 0.00% 14.80% 14.69% 113 Sick Leave 3,278 3,278 - (3,278) -100.00% 0.25% 0.00% 121 PERA Contributions 31,946 31,946 34,215 2,269 7.10% 2.42% 2.57% 122 FICA Contributions 39,650 39,650 40,412 762 1.92% 3.00% 3.03% 123 MEDICARE Contributions 9,273 9,273 9,451 178 1.92% 0.70% 0.71% 131 Health Insurance 68,515 68,515 57,680 (10,835) -15.81% 5.18% 4.33% 132 Dental Insurance 2,965 2,965 2,930 (35) -1.19% 0.22% 0.22% 133 Life Insurance 402 402 402 0 0.00% 0.03% 0.03% 32 p4 PRIpP City of Prior Lake Council Meeting 12.08.2014 2015 Proposed Budget Expenditure Details MMgOS' From Amended Budget..... 2014 2015 2014 2015 2014 2014 2015 $Change %Change %of %of %of %of Adopted Amended Proposed 14-15 14-15 Subtotal Subtotal Total Total 135 HCSP Contributions 1,455 1,455 1,455 0 0.00% 0.11% 0.11% 151 Workers Comp-Insurance 14,826 14,826 18,609 3,783 25.52% 1.12% 1.40% 153 Mn Unemployment Insurance 2,500 2,500 2,500 0 0.00% 0.19% 0.19% 100 Severance Compensation Funding 2,103 2,103 2,181 78 3.70% 0.16% 0.16% 201 Office Supplies-General 936 936 1,000 64 6.84% 0.07% 0.08% 210 Operating Supplies-General 42,620 42,620 39,550 (3,070) -7.20% 3.23% 2.97% 212 Operating Supplies-Fuel 63,600 63,600 67,880 4,280 6.73% 4.81% 5.10% 215 Operating Supplies-Shop Material 1,871 1,871 2,000 129 6.89% 0.14% 0.15% 217 Operating Supplies-Uniforms 4,519 4,519 4,830 311 6.88% 0.34% 0.36% 223 Repair&Maint Sup-Bldgs 4,678 4,678 5,000 322 6.88% 0.35% 0.38% 224 Repair&Maint Sup-General 56,936 56,936 60,850 3,914 6.88% 4.31% 4.57% 240 Small Tools&Equipment 4,678 4,678 5,000 322 6.88% 0.35% 0.38% 313 Professional Services-Consultant 2,000 2,000 2,000 0 0.00% 0.15% 0.15% 321 Communications 599 599 640 41 6.88% 0.05% 0.05% 331 Training&Certification 3,880 3,880 3,880 0 0.00% 0.29% 0.29% 343 Sign Advertising 2,000 2,000 - (2,000) -100.00% 0.15% 0.00% 363 Insurance-Auto 3,712 3,712 3,146 (566) -15.25% 0.28% 0.24% 381 Utilities-Electric 14,877 14,877 24,000 9,123 61.32% 1.13% 1.80% 383 Utilities-Gas 4,678 4,678 5,500 822 17.57% 0.35% 0.41% 384 Refuse Disposal 13,522 13,522 14,290 768 5.68% 1.02% 1.07% 387 Park Lighting 35,556 35,556 36,000 444 1.25% 2.69% 2.70% 401 Repair&Maint Service-Bldgs 4,500 4,500 4,500 0 0.00% 0.34% 0.34% 402 Repair&Maint Service-Trails 20,000 20,000 20,000 0 0.00% 1.51% 1.50% 403 Repair&Maint Service-Parks 22,250 22,250 22,250 0 0.00% 1.68% 1.67% 415 Rentals-Heavy Equipment 15,602 15,602 15,603 1 0.00% 1.18% 1.17% 433 Dues&Subscriptions 350 350 350 0 0.00% 0.03% 0.03% 530 Improvements 185,000 343,519 171,771 (171,748) -50.00% 14.00% 12.90% 1,321,511 1,480,030 1,331,676 (148,355) -10.02% 100.00% 100.00% 10.18% 10.60% 45500 Libraries 223 Repair&Maint Sup-Bldgs 3,743 3,743 3,743 0 0.00% 4.96% 5.61% 321 Communications 2,111 2,111 2,364 253 11.99% 2.80% 3.54% 381 Utilities-Electric 24,327 24,327 21,000 (3,327) -13.68% 32.21% 31.46% 383 Utilities-Gas 14,035 14,035 10,200 (3,835) -27.32% 18.59% 15.28% 384 Refuse Disposal 1,224 1,224 1,051 (173) -14.13% 1.62% 1.57% 401 Repair&Maint Service-Bldgs 10,700 10,700 10,700 0 0.00% 14.17% 16.03% 406 Repair&Maint Service-Clean 19,376 19,376 17,702 (1,674) -8.64% 25.66% 26.52% 75,516 75,516 66,760 (8,756) -11.59% 100.00% 100.00% 0.58% 0.53% Total Culture/Recreation 1,784,347 1,942,866 1,757,813 (185,053) -9.52% 100.00% 100.00% 13.74% 13.99% Natural Resources 46100 Natural Resources 101 Full Time Employees Regular 28,022 28,022 28,722 701 2.50% 36.11% 35.98% 121 PERA Contributions 2,032 2,032 2,154 122 6.03% 2.62% 2.70% 122 FICA Contributions 1,737 1,737 1,781 44 2.51% 2.24% 2.23% 123 MEDICARE Contributions 406 406 416 10 2.38% 0.52% 0.52% 131 Health Insurance 2,602 2,602 2,249 (353) -13.58% 3.35% 2.82% 132 Dental Insurance 94 94 120 26 27.31% 0.12% 0.15% 133 Life Insurance 17 17 17 0 0.00% 0.02% 0.02% 33 OQ PA/pA City of Prior Lake Council Meeting 12.08.2014 2015 Proposed Budget Expenditure Details MMNE3�� From.Amended Budget...:.. 2014 2015 2014 2015 2014 2014 2015 $Change %Change %of %of %of %of Adopted Amended Proposed 14-15 14-15 Subtotal Subtotal Total Total 135 HCSP Contributions 75 75 75 0 0.00% 0.10% 0.09% 151 Workers Comp-Insurance 136 136 172 36 26.55% 0.18% 0.22% 100 Severance Compensation Funding 140 140 144 4 2.78% 0.18% 0.18% 201 Office Supplies-General 234 234 250 16 6.84% 0.30% 0.31% 210 Operating Supplies-General 2,339 2,339 2,500 161 6.88% 3.01% 3.13% 224 Repair&Maint Sup-General 20,585 20,585 22,000 1,415 6.87% 26.53% 27.56% 313 Professional Services-Consultant 4,000 4,000 4,000 0 0.00% 5.16% 5.01% 321 Communications 705 705 754 49 6.95% 0.91% 0.94% 331 Training&Certification 2,120 2,120 2,120 0 0.00% 2.73% 2.66% 403 Repair&Maint Service-Parks 12,000 12,000 12,000 0 0.00% 15.47% 15.03% 433 Dues&Subscriptions 350 350 350 0 0.00% 0.45% 0.44% 77,594 77,594 79,824 2,230 2.87% 100.00% 100.00% 0.60% 0.64% Total Natural Resources 77,594 77,594 79,824 2,230 2.87% 100.00% 100.00% 0.60% 0.64% 49303 Transfers to other funds 1,091,943 1,091,943 1,035,845 (56,098) -5.14% 100.00% 100.00% 8.41% 8.24% 49999 Contingency reserve - 123,863 (123,863) -100.00% n/a n/a 0.00% 0.00% GENERAL FUND TOTAL 12,985,255 13,267,637 12,563,945 (703,692) -5.30% 100.00% 100.00% 100.00% 100.00% DEBT SERVICE FUNDS 47000 Debt 4,279,864 4,279,864 4,256,609 (23,255) -0.54% 56.39% 100.00% 47000 Debt-refunding 3,310,017 3,310,017 - (3,310,017) -100.00% 43.61% 0.00% 7,589,881 7,589,881 4,256,609 (3,333,272) -43.92% 100.00% 100.00% 100.00% 100.00% DEBT SERVICE FUNDS TOTAL 7,589,881 7,589,881 4,256,609 (3,333,272) -43.92% 100.00% 100.00% 100.00% 100.00% CABLE FUND 41340 Public Cable Access - - 7,000 7,000 n/a n/a 100.00% 7,000 7,000 n/a n/a 100.00% n/a 100.00% CABLE FUND TOTAL - - 7,000 7,000 n/a n/a 100.00% n/a 100.00% REVOLVING EQUIPMENT FUND 42200 Fire 36,050 118,816 150,950 32,134 27.05% 4.97% 18.44% 42100 Police 53,216 53,216 115,600 62,384 117.23% 7.34% 14.12% 43050 Engineering 25,750 25,750 - (25,750) -100.00% 3.55% 0.00% 43100 Streets 207,957 207,957 310,500 102,543 49.31% 28.67% 37.93% 43400 Central Garage 72,165 72,165 20,000 (52,165) -72.29% 9.95% 2.44% 45200 Parks 93,833 93,833 108,000 14,167 15.10% 12.94% 13.19% 49420 Water Quality - - 73,500 73,500 n/a 0.00% 8.98% 49450 Sewer 236,385 236,385 40,000 (196,385) -83.08% 32.59% 4.89% 725,356 808,122 818,550 10,428 1.29% 100.00% 100.00% 100.00% 100.00% REVOLVING EQUIPMENT FUND TOTAL 725,356 808,122 818,550 10,428 1.29% 100.00% 100.00% 100.00% 100.00% 34 OQ PRIp4 City of Prior Lake Council Meeting 12.08.2014 2015 Proposed Budget Expenditure Details " sem' From Amended Budget.... 2014 2015 2014 2015 2014 2014 2015 $Change %Change %of %of %of %of Adopted Amended Proposed 14-15 14-15 Subtotal Subtotal Total Total FACILITIES MANAGEMENT FUND 42200 Fire - - 87,056 87,056 n/a 0.00% 2.51% 43000 Public Works 300,500 300,500 598,933 298,433 99.31% 80.91% 17.29% 45100 Recreation 35,448 35,448 55,562 20,115 56.74% 9.54% 1.60% 45500 Library 35,448 35,448 55,562 20,115 56.74% 9.54% 1.60% XXXXX GESP - 2,667,924 2,667,924 n/a 0.00% 77.00% 371,395 371,395 3,465,037 3,093,642 832.98% 100.00% 100.00% 100.00% 97.71% 49303 Transfers to other funds - - 81,381 81,381 n/a n/a n/a 0.00% 2.29% FACILITIES MANAGEMENT FUND TOTAL 371,395 371,395 3,546,418 3,175,023 854.89% 100.00% 100.00% 100.00% 100.00% CAPITAL PARK FUND 45200 Parks 50,000.00 70,436.00 - (70,436) -100.00% 29.41% 0.00% xxxxx Rice Lake Park 120,000.00 120,000.00 50 000.00 (70,000) -58.33% 70.59% 100.00% 170 000.00 190,436.00 50 000.00 (140,436) -73.74% 100.00% 100.00% 100.00% 100.00% 49303 Transfers to other funds - - - 0 n/a n/a n/a 0.00% 0.00% CAPITAL PARK FUND TOTAL 170,000 190,436 50,000 (1409436) -73.74% 100.00% 100.00% 100.00% 100.00% EDA SPECIAL REVENUE FUND 46500 Economic Development 101 Full Time Employees Regular 70,573 70,573 91,654 21,081 29.87% 43.38% 61.68% 115 EDA/Planning Commission 3,000 3,000 3,000 0 0.00% 1.84% 2.02% 121 PERA Contributions 5,177 5,177 6,934 1,758 33.95% 3.18% 4.67% 122 FICA Contributions 4,562 4,562 5,869 1,307 28.65% 2.80% 3.95% 123 MEDICARE Contributions 1,067 1,067 1,372 306 28.65% 0.66% 0.92% 131 Health Insurance 8,022 8,022 8,700 678 8.45% 4.93% 5.85% 132 Dental Insurance 334 334 425 91 27.14% 0.21% 0.29% 133 Life Insurance 49 49 63 14 29.63% 0.03% 0.04% 135 HCSP Contributions 195 195 240 45 23.08% 0.12% 0.16% 151 Workers Comp-Insurance 340 340 540 201 59.01% 0.21% 0.36% 100 Severance Compensation Funding 353 353 458 105 29.87% 0.22% 0.31% 201 Office Supplies 500 500 250 (250) -50.00% 0.31% 0.17% 304 Legal Fees 3,500 3,500 2,500 (1,000) -28.57% 2.15% 1.68% 314 Professional Services 40,000 28,000 22,000 (6,000) -21.43% 24.59% 14.81% 321 Communications - - 500 500 n/a 0.00% 0.34% 331 Training&Certification 3,500 3,500 2,000 (1,500) -42.86% 2.15% 1.35% 351 Legal Notice 500 500 500 0 0.00% 0.31% 0.34% 433 Dues&Subscriptions 1,000 1,000 1,000 0 0.00% 0.61% 0.67% 437 Misc Expense-General - - 590 590 n/a 0.00% 0.40% XXX SAC Deferral Loans issued 20,000 20,000 - (20,000) -100.00% 12.29% 0.00% 162,670 162,670 148,595 (14,075) -8.65% 100.00% 100.00% 85.99% 78.79% 46503 Technology Village Incubator 201 Office Supplies 500 500 500 0 0.00% 1.89% 1.25% 321 Communications 2,500 2,500 5,000 2,500 100.00% 9.43% 12.50% 35 oQ rxroA City of Prior Lake Council Meeting 12.08.2014 2015 Proposed Budget Expenditure Details MNNES�' From Amended Budget.... 2014 2015 2014 2015 2014 2014 2015 $Change %Change %of %of %of %of Adopted Amended Proposed 14-15 14-15 Subtotal Subtotal Total Total 433 Dues&Subscriptions 2,500 2,500 2,500 0 0.00% 9.43% 6.25% 437 Misc Expense-General 2,500 2,500 2,500 0 0.00% 9.43% 6.25% XXX Property Taxes 1,500 1,500 - (1,500) -100.00% 5.66% 0.00% XXX Business Assistance 3,000 3,000 3,000 0 0.00% 11.32% 7.50% XXX Rent Subsidies 10,000 22,000 23,500 1,500 6.82% 37.74% 58.75% 560 Furniture&Fixtures - - 1,500 1,500 n/a 0.00% 3.75% 580 General Equipment 4,000 4,000 1,500 (2,500) -62.50% 15.09% 3.75% 26,500 26,500 40,000 13,500 50.94% 100.00% 100.00% 14.01% 21.21% EDA SPECIAL REVENUE FUND TOTAL 189,170 189,170 188,595 (575) -0.30% 100.00% 100.00% 100.00% 100.00% WATER FUND 41520 Finance 101 Full Time Employees Regular 25,688 25,688 26,333 645 2.51% 30.17% 30.59% 102 Full Time Employees Overtime 500 500 1,000 500 100.00% 0.59% 1.16% 103 Part Time Employees-Regular 19,507 19,507 20,531 1,024 5.25% 22.91% 23.85% 121 PERA Contributions 3,277 3,277 3,515 238 7.28% 3.85% 4.08% 122 FICA Contributions 2,802 2,802 2,968 166 5.92% 3.29% 3.45% 123 MEDICARE Contributions 655 655 694 39 5.90% 0.77% 0.81% 131 Health Insurance 5,930 5,930 5,330 (600) -10.12% 6.96% 6.19% 132 Dental Insurance 240 240 240 0 0.00% 0.28% 0.28% 133 Life Insurance 29 29 29 0 0.00% 0.03% 0.03% 135 HCSP Contributions 180 180 180 0 0.00% 0.21% 0.21% 151 Workers Comp-Insurance 213 213 276 63 29.66% 0.25% 0.32% 100 Severance Compensation Funding 226 226 234 8 3.55% 0.27% 0.27% 201 Office Supplies 150 150 150 0 0.00% 0.18% 0.17% 203 Office Supplies-Printed Forms 140 140 140 (0) -0.25% 0.16% 0.16% 240 Small Tools&Equipment 750 750 750 0 0.00% 0.88% 0.87% 316 BankService Charges 5,375 5,375 4,625 (750) -13.95% 6.31% 5.37% 322 Communications-Postage 9,716 9,716 9,358 (358) -3.68% 11.41% 10.87% 331 Training&Certification 245 245 245 0 0.00% 0.29% 0.28% 350 Printing Services 2,460 2,460 2,418 (42) -1.71% 2.89% 2.81% 404 Repair&Maint Service-Equip 50 50 50 0 0.00% 0.06% 0.06% 407 Software Service Contract 7,000 7,000 7,000 0 0.00% 8.22% 8.13% 433 Memberships 25 25 25 0 0.00% 0.03% 0.03% 85,157 85,157 86,091 934 1.10% 100.00% 100.00% 2.77% 1.50% 49400 Water 101 Full Time Employees Regular 417,958 417,958 433,312 15,354 3.67% 19.67% 8.96% 102 Full Time Employees Overtime 23,000 23,000 23,000 0 0.00% 1.08% 0.48% 104 Temporary Employees Regular 38,810 38,810 38,810 0 0.00% 1.83% 0.80% 113 Sick Leave 3,371 3,371 2,299 (1,072) -31.80% 0.16% 0.05% 121 PERA Contributions 31,969 31,969 34,223 2,254 7.05% 1.50% 0.71% 122 FICA Contributions 29,955 29,955 30,840 885 2.96% 1.41% 0.64% 123 MEDICARE Contributions 7,006 7,006 7,213 207 2.96% 0.33% 0.15% 131 Health Insurance 65,150 65,150 52,872 (12,278) -18.85% 3.07% 1.09% 132 Dental Insurance 2,831 2,831 2,803 (29) -1.01% 0.13% 0.06% 133 Life Insurance 379 379 379 0 0.00% 0.02% 0.01% 135 Health Savings Plan 1,215 1,215 1,560 345 28.40% 0.06% 0.03% 36 �Q PA/pP City of Prior Lake Council Meeting 12.08.2014 'u 2015 Proposed Budget Expenditure Details From Amended Budget.... 2014 2015 2014 2015 2014 2014 2015 $Change %Change %of %of %of %of Adopted Amended Proposed 14-15 14-15 Subtotal Subtotal Total Total 151 Workers Comp-Insurance 12,364 12,364 13,921 1,558 12.60% 0.58% 0.29% 100 Severance Compensation Funding 2,090 2,090 2,167 77 3.67% 0.10% 0.04% 201 Office Supplies 936 936 936 0 0.00% 0.04% 0.02% 202 Office Supplies-Dup&Copy 496 496 496 0 0.02% 0.02% 0.01% 203 Office Supplies-Printed Forms 3,743 3,743 3,743 0 0.01% 0.18% 0.08% 210 Operating Supplies-General 3,322 3,322 3,322 0 0.00% 0.16% 0.07% 212 Operating Supplies-Fuel 12,720 12,720 13,340 620 4.87% 0.60% 0.28% 216 Operating Supplies-Chemicals 180,000 180,000 160,000 (20,000) -11.11% 8.47% 3.31% 217 Operating Supplies-Uniforms 2,246 2,246 2,246 0 0.00% 0.11% 0.05% 221 Repair&Maint Sup-Equipment 15,439 15,439 15,440 1 0.01% 0.73% 0.32% 223 Repair&Maint Sup-Bldgs 8,421 8,421 8,421 (0) 0.00% 0.40% 0.17% 224 Repair&Maint Sup-General 91,696 91,696 91,696 0 0.00% 4.31% 1.90% 240 Small Tools&Equipment 4,678 4,678 4,678 (0) -0.01% 0.22% 0.10% 241 Computer/Data Services 10,950 10,950 55,482 44,532 406.68% 0.52% 1.15% 260 Water Meters 277,118 277,118 277,117 (1) 0.00% 13.04% 5.73% 303 Professional Service-Engineering 25,000 25,000 25,000 0 0.00% 1.18% 0.52% 312 Professional Service-Water Samples 22,500 22,500 22,500 0 0.00% 1.06% 0.47% 314 Professional Services 25,000 25,000 25,000 0 0.00% 1.18% 0.52% 321 Communications 20,887 20,887 21,425 538 2.58% 0.98% 0.44% 322 Communications-Postage 4,200 4,200 4,200 0 0.00% 0.20% 0.09% 325 Communications-Utility Locations 8,100 8,100 8,100 0 0.00% 0.38% 0.17% 331 Training&Certification 14,800 14,800 14,800 0 0.00% 0.70% 0.31% 363 Insurance-Auto 1,870 1,870 1,963 93 4.97% 0.09% 0.04% 381 Utilities-Electric 168,421 168,421 168,420 (1) 0.00% 7.92% 3.48% 383 Utilities-Gas 42,105 42,105 35,000 (7,105) -16.88% 1.98% 0.72% 384 Refuse Disposal - - 433 433 n/a 0.00% 0.01% 389 Contract Water 255,000 255,000 n/a 0.00% 5.27% 401 Repair&Maint Service-Bldg 15,920 15,920 15,920 0 0.00% 0.75% 0.33% 404 Repair&Maint Service-Equip 1,800 1,800 1,800 0 0.00% 0.08% 0.04% 406 Repair&Maint Service-Cleaning 20,186 20,186 15,420 (4,766) -23.61% 0.95% 0.32% 407 Software Service Contract 17,600 17,600 17,600 0 0.00% 0.83% 0.36% 412 Repair&Maint Service-General 114,400 114,400 114,400 0 0.00% 5.38% 2.36% 415 Rentals-Heavy Equipment 4,678 4,678 5,000 322 6.88% 0.22% 0.10% 433 Dues&Subscriptions 5,255 5,255 5,255 0 0.00% 0.25% 0.11% 530 Improvements 364,755 364,755 2,700,000 2,335,245 640.22% 17.16% 55.81% 580 General Equipment - - 100,000 100,000 n/a 0.00% 2.07% 2,125,339 2,125,339 4,837,551 2,712,212 127.61% 100.00% 100.00% 69.03% 84.45% 49303 Transfers to other funds 868,235 868,235 804,695 (63,540) -7.32% 100.00% 100.00% 28.20% 14.05% WATER FUND TOTAL 3,078,731 3,078,731 5,728,336 2,649,605 86.06% 100.00% 100.00% 100.00% 100.00% SEWER FUND 41520 Finance 101 Full Time Employees Regular 25,688 25,688 26,333 645 2.51% 30.17% 30.61% 102 Full Time Employees Overtime 500 500 1,000 500 100.00% 0.59% 1.16% 103 Part Time Employees-Regular 19,507 19,507 20,531 1,024 5.25% 22.91% 23.86% 121 PERA Contributions 3,277 3,277 3,515 238 7.28% 3.85% 4.09% 122 FICA Contributions 2,833 2,833 2,968 135 4.76% 3.33% 3.45% 123 MEDICARE Contributions 663 663 694 31 4.74% 0.78% 0.81% 37 °e rwo� City of Prior Lake Council Meeting 12.08.2014 2015 Proposed Budget Expenditure Details From Amended Budget.... 2014 2015 2014 2015 2014 2014 2015 $Change %Change %of %of %of %of Adopted Amended Proposed 14-15 14-15 Subtotal Subtotal Total Total 131 Health Insurance 5,930 5,930 5,330 (600) -10.12% 6.96% 6.19% 132 Dental Insurance 240 240 240 0 0.00% 0.28% 0.28% 133 Life Insurance 29 29 29 0 0.00% 0.03% 0.03% 135 HCSP Contributions 180 180 180 0 0.00% 0.21% 0.21% 151 Workers Comp-Insurance 215 215 276 61 28.23% 0.25% 0.32% 100 Severance Compensation Funding 226 226 234 8 3.55% 0.27% 0.27% 201 Office Supplies 150 150 150 0 0.00% 0.18% 0.17% 203 Office Supplies-Printed Forms 140 140 140 (0) -0.25% 0.16% 0.16% 240 Small Tools&Equipment 750 750 750 0 0.00% 0.88% 0.87% 316 BankService Charges 5,375 5,375 4,625 (750) -13.95% 6.31% 5.38% 322 Communications-Postage 9,716 9,716 9,358 (358) -3.68% 11.41% 10.88% 331 Training&Certification 245 245 245 0 0.00% 0.29% 0.28% 350 Printing Services 2,460 2,460 2,418 (42) -1.71% 2.89% 2.81% 407 Software Service Contract 7,000 7,000 7,000 0 0.00% 8.22% 8.14% 433 Memberships 25 25 25 0 0.00% 0.03% 0.03% 85,148 85,148 86,041 893 1.05% 100.00% 100.00% 2.89% 2.59% 49450 Sewer 101 Full Time Employees Regular 371,111 371,111 379,742 8,631 2.33% 14.63% 12.73% 102 Full Time Employees Overtime 23,000 23,000 23,000 0 0.00% 0.91% 0.77% 103 Part Time Employees-Regular 54,351 54,351 33,372 (20,979) -38.60% 2.14% 1.12% 104 Temporary Employees Regular 7,920 7,920 7,920 0 0.00% 0.31% 0.27% 113 Sick Leave 1,281 1,281 57 (1,224) -95.55% 0.05% 0.00% 121 PERA Contributions 32,514 32,514 32,708 195 0.60% 1.28% 1.10% 122 FICA Contributions 28,375 28,375 27,534 (842) -2.97% 1.12% 0.92% 123 MEDICARE Contributions 6,636 6,636 6,439 (197) -2.97% 0.26% 0.22% 131 Health Insurance 57,129 57,129 49,778 (7,351) -12.87% 2.25% 1.67% 132 Dental Insurance 2,497 2,497 2,580 83 3.33% 0.10% 0.09% 133 Life Insurance 334 334 334 0 0.00% 0.01% 0.01% 135 Health Savings Plan 1,586 1,586 1,305 (281) -17.73% 0.06% 0.04% 151 Workers Comp-Insurance 19,497 19,497 23,709 4,212 21.60% 0.77% 0.79% 100 Severance Compensation Funding 2,127 2,127 2,066 (62) -2.90% 0.08% 0.07% 201 Office Supplies 936 936 1,000 64 6.84% 0.04% 0.03% 203 Office Supplies-Printed Forms 2,433 2,433 2,600 167 6.88% 0.10% 0.09% 210 Operating Supplies-General 3,322 3,322 3,550 228 6.86% 0.13% 0.12% 212 Operating Supplies-Fuel 12,720 12,720 13,340 620 4.87% 0.50% 0.45% 217 Operating Supplies-Uniforms 2,526 2,526 2,700 174 6.88% 0.10% 0.09% 224 Repair&Maint Sup-General 78,596 78,596 84,000 5,404 6.88% 3.10% 2.81% 240 Small Tools&Equipment 5,146 5,146 5,500 354 6.88% 0.20% 0.18% 241 Computer/Data Services 8,750 8,750 8,750 0 0.00% 0.34% 0.29% 303 Professional Service-Engineering 82,500 82,500 82,500 0 0.00% 3.25% 2.76% 321 Communications 15,339 15,339 16,394 1,055 6.88% 0.60% 0.55% 331 Training&Certification 13,000 13,000 13,000 0 0.00% 0.51% 0.44% 363 Insurance-Auto 1,870 1,870 1,963 93 4.97% 0.07% 0.07% 381 Utilities-Electric 38,363 38,363 38,300 (63) -0.16% 1.51% 1.28% 404 Repair&Maint Service-Equip 12,000 12,000 12,000 0 0.00% 0.47% 0.40% 407 Software Service Contract 4,100 4,100 4,100 0 0.00% 0.16% 0.14% 412 Repair&Maint Service-General 94,500 94,500 94,500 0 0.00% 3.73% 3.17% 415 Rentals-Heavy Equipment 4,678 4,678 4,678 0 0.00% 0.18% 0.16% 38 OQ PA/pP City of Prior Lake Council Meeting 12.08.2014 2015 Proposed Budget u M Expenditure Details '�Mpcs�n From Amended Budget 2014 2015 2014 2015 2014 2014 2015 $Change %Change %of %of %Of %Of Adopted Amended Proposed 14-15 14-15 Subtotal Subtotal Total Total 433 Dues&Subscriptions 685 685 685 0 0.00% 0.03% 0.02% 437 Misc Expense-General 500 500 500 0 0.00% 0.02% 0.02% 440 MCES Installment 1,215,970 1,215,970 1,228,533 12,563 1.03% 47.94% 41.17% 530 Improvements 330,000 330,000 675,000 345,000 104.55% 13.01% 22.62% 580 General Equipment - - 100,000 100,000 n/a 0.00% 3.35% 2,536,293 2,536,293 2,984,136 447,843 17.66% 100.00% 100.00% 85.98% 89.94% 49303 Transfers to other funds 328,446 328,446 247,760 (80,686) -24.57% 100.00% 100.00% 11.13% 7.47% SEWER FUND TOTAL 2,949,887 2,949,887 3,317,936 368,049 12.48% 100.00% 100.00% 100.00% 100.00% WATER QUALITY FUND 49420 Water Quality 101 Full Time Employees Regular 178,812 178,812 190,430 11,618 6.50% 24.06% 17.24% 104 Temporary Employees Regular 31,657 31,657 36,956 5,299 16.74% 4.26% 3.35% 121 PERA Contributions 12,964 12,964 14,282 1,318 10.17% 1.74% 1.29% 122 FICA Contributions 13,049 13,049 14,098 1,049 8.04% 1.76% 1.28% 123 MEDICARE Contributions 3,052 3,052 3,297 245 8.04% 0.41% 0.30% 131 Health Insurance 26,174 26,174 23,912 (2,263) -8.64% 3.52% 2.17% 132 Dental Insurance 1,102 1,102 1,123 21 1.94% 0.15% 0.10% 133 Life Insurance 145 145 145 0 0.00% 0.02% 0.01% 135 Health Savings Plan 555 555 555 0 0.00% 0.07% 0.05% 151 Workers Comp-Insurance 3,500 3,500 4,579 1,079 30.82% 0.47% 0.41% 100 Severance Compensation Funding 894 894 952 58 6.48% 0.12% 0.09% 201 Office Supplies 477 477 477 0 0.00% 0.06% 0.04% 203 Office Supplies-Printed Forms 1,871 1,871 1,872 1 0.04% 0.25% 0.17% 210 Operating Supplies-General 4,276 4,276 4,276 (0) 0.00% 0.58% 0.39% 212 Operating Supplies-Fuel 12,720 12,720 12,800 80 0.63% 1.71% 1.16% 224 Repair&Maint Sup-General 32,749 32,749 32,749 0 0.00% 4.41% 2.97% 241 Technology/Equipment 1,200 1,200 1,200 0 0.00% 0.16% 0.11% 314 Professional Service-General 102,025 102,025 102,025 0 0.00% 13.73% 9.24% 331 Training&Certification 1,500 1,500 1,500 0 0.00% 0.20% 0.14% 407 Software Service Contract 2,150 2,150 2,150 0 0.00% 0.29% 0.19% 412 Repair&Maint Service-General 96,332 96,332 96,332 0 0.00% 12.96% 8.72% 437 MiscExpense-General 1,000 1,000 1,000 0 0.00% 0.13% 0.09% 530 Improvements 215,000 215,000 557,588 342,588 159.34% 28.93% 50.49% 743,205 743,205 1,104,299 361,095 48.59% 100.00% 100.00% 97.25% 98.13% 49303 Transfers to other funds 21,000 21,000 21,000 0 0.00% 100.00% 100.00% 2.75% 1.87% WATER QUALITY FUND TOTAL 764,205 764,205 1,125,299 361,094 47.25% 100.00% 100.00% 100.00% 100.00% TRANSIT FUND 49804 Transit 201 Office Supplies 94 94 - (94) -100.00% 0.01% n/a 203 Office Supplies-Printed Forms 5,146 5,146 (5,146) -100.00% 0.55% n/a 304 Legal Services 1,500 1,500 (1,500) -100.00% 0.16% n/a 314 Professional Service-General 25,000 25,000 (25,000) -100.00% 2.67% n/a 321 Communications 674 674 (674) -100.00% 0.07% n/a 331 Training&Certification 1,500 1,500 (1,500) -100.00% 0.16% n/a 39 OQ PIVpR City of Prior Lake Council Meeting 12.08.2014 M 2015 Proposed Budget Expenditure Details MNNE9�' From Amended Budget.... 2014 2015 2014 2015 2014 2014 2015 $Change %Change %of %of %of %of Adopted Amended Proposed 14-16 14-16 Subtotal Subtotal Total Total 412 Repair&Maint Service-General 5,000 5,000 (5,000) -100.00% 0.53% n/a 418 Facility Rental 90,000 90,000 - (90,000) -100.00% 9.60% n/a 425 Transit Contract Service 757,675 757,675 - (757,675) -100.00% 80.85% n/a 433 Dues&Subscriptions 560 560 - (560) -100.00% 0.06% n/a 530 Improvements 50,000 50,000 - (50,000) -100.00% 5.34% n/a 937,149 937,149 - (937,149) -100.00% 100.00% n/a 100.00% n/a TRANSIT FUND TOTAL 937,149 937,149 - (937,149) -100.00% 100.00% n/a 100.00% n/a GRAND TOTAL-ALL BUDGETED FUNDS 29,761,028 30,146,612 31,602,688 1,456,076 4.83% 40 O� PRIO ti U 4646 Dakota Street SE Prior Lake,MN 55372 �t�'NESo�P EROSION IN SERVICES 12/1/14 2014 1. Street sweeping is more frequent but takes longer due to greater street mileage and focus on eliminating pollutants from lakes and wetland areas. 2. Water valves are not exercised because of other day to day duties. 3. Directed patrol work is restricted to times when the department has a full personnel complement. Much of the year we do not have a full personnel complement. 4. Plan checking and inspection completion are more and more extended to the last day of our standards. 5. Vacant positions do not get refilled promptly because of competing priorities. 6. Staff response to Council directives are delayed due to competing priorities. 7. Public improvement project administration and actual projects take longer because of added meetings and added information the staff is directed to obtain (grants). 8. Support to advisory committees is taking staff time from day to day responsibilities. 9. Build permit closure is behind by multiple years. 10. Snow is no longer hauled from cul de sacs for lack of free time to do so. 11. Public works design manual does not reflect current technology since it was last updated in 2007. 12. Ordinance modifications (hookah, short term rental)take longer to complete. 13. Engineering proofing of one another's' plans is less frequent. 14. The City's 2000 easement records are not up to date. 15. Building department handouts and new handouts are not up to date. 16. Digital file clean-up has not been done. 17. Emails are not placed in folders or deleted/filed as appropriate. 18. Police use of technology is behind on website, Facebook, and crime mapping. 19. Cost increases for essential supplies (gas, water treatment chemicals) are paid for by cannibalizing other line items in all departments. 20. The condition of our trails is deteriorating due to lack of maintenance, age and reconstruction. 21. New parks escalate costs for contract services for things like Biffs. We are cannibalizing other line items to provide them. 22. Neighborhood parks are now mowed every two weeks rather than weekly (non-athletic facilities). 23. Tree and landscape trimming are now complaint based rather than proactive. 24. Invasive species removal (buckthorn)takes place by volunteers only. 25. Repair projects to water towers are not being completed (replacement of isolation valves and upgrades to overflow pipes). 26. We have a current back log of 200+ repairs to isolation valves to stop water services to dwelling units. 27. The city revises pedestrian ramps on sidewalks for Americans with Disabilities Act purposes but we have not prepared a comprehensive plan on this topic as we were supposed to have done. 28. Public infrastructure as built plan records are three years behind which impacts field location of infrastructure such as sewer and water pipes when repair, locates, or shut offs are requested. 29. New fire recruits tend to have lower response rates than experienced and longer term firefighters meaning more recruits required. 30. Focus on daily responsibilities in all departments has inhibited research and implementation of current technology (example officer body cameras) and productivity improvements. 2 2015 31. The reduction of warming house attendants from two per shift to one per shift has necessitated a cut back in warming house hours. 32. Beach Parties were previously offered three times. Cut backs in seasonal staff will reduce them to one. 33. Lakefront Days support from recreation staff is eliminated because of cuts to temporary staff.The umbrella project is eliminated. 34. Recreation class sizes will be smaller serving fewer in 2015 because of cuts in temporary employees. 35. Elimination of one police support position while redefining a CSO position will result in less support for police officers (evidence handling) and slower customer service (vacation home checks, lock outs). 36. Safety camp is discontinued unless volunteers can be found. 37. The time between approval of a document and publication/distribution is much longer (2040 Vision and Strategic Plan, 2014-2019 Capital Improvement Program). 38. There is increasing a conflict between time spent with customers and time spent getting daily work responsibilities done. 39. More frequently the city is "kicking the can down the road" (2015—not funding$50,000 Revolving Park Equipment Plan). 40. Delayed preparation of Retention Plan due to time constraints and resources to offer as incentives. 41. Trail plowing is delayed as is street plowing because of the addition of miles in each without corresponding resource additions in personnel and equipment. 3 -VH/ l� '' n /� -j pQ P1VpR F� City of Prior Lake Council Meeting 12.08.2014 v 2015 Proposed Budget Expenditure Details From Amended Budget.... 2014 2015 2014 2015 2012 2013 2014 2014 2015 $Change %Change %of %of %of %of YE Actual YE Actual Adopted Amended Proposed 14-15 14-1.5 Subtotal Subtotal Total Total GENERAL FUND General Government 41110 Mayor&Council 107 Council Per Diems 6,700 5,300 8,750 8,750 7,000 (1,750) -20.00% 15.19% 12.64% 111 Council Salaries 39,180 38,560 39,180 39,180 39,180 0 0.00% 68.02% 70.73% 121 PERA Contributions 2,294 1,981 1,587 1,587 1,959 372 23.44% 2.76% 3.54% 122 FICA Contributions 2,845 897 1,004 1,004 434 (570) -56.76% 1.74% 0.78% 123 MEDICARE Contributions 665 636 695 695 670 (25) -3.60% 1.21% 1.21% 151 Workers Comp-Insurance 89 105 108 108 127 19 17.79% 0.19% 0.23% 201 Office Supplies-General 113 286 468 468 300 (168) -35.90% 0.81% 0.54% 321 Communications 1,870 600 561 561 - (561) -100.00% 0.97% 0.00% 331 Training&Certification 4,668 5,082 4,750 4,750 5,250 500 10.53% 8.25% 9.48% 437 Misc Expense-General 1,521 1,380 500 500 470 (30) -6.00% 0.87% 0.85% 59,945 54,827 57,603 57,603 55,390 (2,213) -3.84% 100.00% 100.00% 0.44% 0.44% 41130 Ordinance 351 Legal Notice 5,699 6,761 4,500 4,500 6,000 . 1,500 33.33% 75.00% 80.00% 352 Ordinance Publication 1,223 1,335 1,500 1,500 1,500 0 0.00% 25.00% 20.00% 6,922 8,096 6,000 6,000 7,500 1,500 25.00% 100.00% 100.00% 0.05% 0.06% 41320 Administration 101 Full Time Employees Regular 223,196 236,742 246,398 246,398 233,640 (12,758) -5.18% 60.98% 60.72% 103 Part Time Employees Regular 39,901 21,397 - - - 0 n/a 0.00% 0.00% 112 Longevity 19,457 22,500 22,500 22,500 22,500 0 0.00% 5.57% 5.85% 113 Sick Leave 3,758 3,330 5,130 5,130 3,398 (1,732) -33.76% 1.27% 0.88% 121 PERA Contributions 18,502 19,513 19,495 19,495 19,616 121 0.62% 4.82% 5.10% 122 FICA Contributions 15,246 15,334 14,598 14,598 13,844 (754) -5.17% 3.61% 3.60% 123 MEDICARE Contributions 4,075 4,040 3,973 3,973 3,842 (132) -3.32% 0.98% 1.00% 131 Health Insurance 19,800 24,226 30,634 30,634 26,394 (4,240) -13.84% 7.58% 6.86% 132 Dental Insurance 1,047 1,254 1,440 1,440 1,330 (110) -7.64% 0.36% 0.35% 133 Life Insurance 1,906 1,906 1,868 1,868 1,926 58 3.08% 0.46% 0.50% 135 HCSP Contributions 1,035 953 780 780 630 (150) -19.23% 0.19% 0.16% 151 Workers Comp-Insurance 1,329 1,324 1,286 1,286 1,530 244 18.94% 0.32% 0.40% 100 Severance Compensation Funding 1,379 1,403 1,317 1,317 1,281 (36) -2.77% 0.33% 0.33% 201 Office Supplies-General 1,696 900 936 936 1,000 64 6.84% 0.23% 0.26% 202 Office Supplies-Dup&Copy 1,519 345 2,292 2,292 1,250 (1,042) -45.47% 0.57% 0.32% 314 Professional Services-General 5,484 14,155 17,200 17,200 17,200 0 0.00% 4.26% 4.47% 321 Communications 986 1,293 842 842 1,320 478 56.75% 0.21% 0.34% 331 Training&Certification 1,219 1,957 2,200 2,200 2,000 (200) -9.09% 0.54% 0.52% 334 Car Allowance 5,400 5,400 5,400 5,400 5,400 0 0.00% 1.34% 1.40% 433 Dues&Subscriptions 26,514 26,286 25,760 25,760 26,659 899 3.49% 6.38% 6.93% 394,054 404,419 404,052 404,052 384,759 (19,292) -4.77% 100.00% 100.00% 3.11% 3.06% 41330 Boards&Commissions 115 EDA/Planning Commission 7,000 8,800 9,000 9,000 9,000 0 0.00% 87.05% 87.05% 122 FICA Contributions 434 546 558 558 558 0 0.00% 5.40% 5.40% 123 MEDICARE Contributions 102 128 131 131 131 0 0.00% 1.27% 1.27% 331 Training&Certification 1,728 86 300 300 300 0 0.00% 2.90% 2.90% 433 Dues&Subscriptions 350 350 350 0 0.00% 3.39% 3.39% 9,264 9,560 10,339 10,339 10,339 0 0.00% 100.00% 100.00% 0.08% 0.08% 23 pQ PBIpA City of Prior Lake Council Meeting 12.08.2014 2015 Proposed Budget Expenditure Details From Amended Budget.... 2014 2015 2014 2015 2012 2013 2014 2014 2015 $Change %Change %of %of %of %of YE Actual YE Actual Adopted Amended Proposed 14-15 14-16 Subtotal Subtotal Total Total 41410 Elections 116 Election Judge Salaries 11,864 25,020 25,020 - (25,020) -100.00% 25.01% 0.00% 240 Small Tools&Equipment 75,000 75,000 75,000 0 0.00% 74.99% 100.00% 25,309 100,020 100,020 75,000 (25020) -25.01% 100.00% 100.00% 0.77% 0.60% 41520 Finance 101 Full Time Employees Regular 291,441 276,426 310,424 310,424 324,935 14,510 4.67% 72.59% 74.75% 113 Sick Leave 4,221 1,291 3,156 3,156 2,768 (388) -12.31% 0.74% 0.64% 121 PERA Contributions 21,128 19,862 22,506 22,506 24,370 1,864 8.28% 5.26% 5.61% 122 FICA Contributions 17,814 16,859 19,442 19,442 20,318 876 4.51% 4.55% 4.67% 123 MEDICARE Contributions 4,166 3,943 4,547 4,547 4,752 205 4.51% 1.06% 1.09% 131 Health Insurance 29,264 30,831 40,452 40,452 34,798 (5,654) -13.98% 9.46% 8.01% 132 Dental Insurance 1,467 1,408 1,714 1,714 1,700 (14) -0.83% 0.40% 0.39% 133 Life Insurance 336 234 274 274 274 0 0.15% 0.06% 0.06% 135 HCSP Contributions 900 713 925 925 1,200 275 29.73% 0.22% 0.28% 151 Workers Comp-Insurance 1,494 1,373 1,493 1,493 1,915 422 28.23% 0.35% 0.44% 100 Severance Compensation Funding 1,457 1,348 1,552 1,552 1,625 73 4.67% 0.36% 0.37% 201 Office Supplies-General 960 715 702 702 700 (2) -0.28% 0.16% 0.16% 203 Office Supplies-Printed Forms 2,168 2,551 2,540 2,540 1,525 (1,015) -39.97% 0.59% 0.35% 240 Small Tools&Equipment 151 - 281 281 200 (81) -28.83% 0.07% 0.05% 314 Professional Services-General 4,046 11,950 1,800 1,800 2,000 200 11.11% 0.42% 0.46% 316 Bank Service Charges 6,028 7,240 7,250 7,250 7,250 0 0.00% 1.70% 1.67% 321 Communications 1,000 652 692 692 - (692) -100.00% 0.16% 0.00% 331 Training&Certification 1,865 3,009 3,160 3,160 3,435 275 8.70% 0.74% 0.79% 433 Dues&Subscriptions 4,414 4,260 4,675 4,675 845 (3,830) -81.93% 1.09% 0.19% 437 Misc Expense-General 3,061 9,189 75 75 75 0 0.00% 0.02% 0.02% 397,381 393,854 427,661 427,661 434,684 7,023 1.64% 100.00% 100.00% 3.29% 3.46% 41540 Internal Auditing 301 Audit 26,240 24,890 25,125 25,125 29,950 4,825 19.20% 100.00% 100.00% 0.19% 0.24% 41550 Assessing 310 Property Assessing 116,700 124,000 132,500 132,500 150,000 17,500 13.21% 98.44% 98.52% 314 Professional Services-General 1,989 2,203 2,100 2,100 2,250 150 7.14% 1.56% 1.48% 118,689 126,203 134,600 134,600 152,250 17,650 13.11% 100.00% 100.00% 1.04% 1.21% 41610 Legal 304 Legal Fees 172,016 178,086 175,000 175,000 215,000 40,000 22.86% 51.47% 100.00% 305 Prosecution 158,055 157,961 165,000 165,000 (165,000) -100.00% 48.53% 0.00% 330,071 336,047 340,000 340,000 215,000 (125,000) -36.76% 100.00% 100.00% 2.62% 1.71% 41820 Personnel 101 Full Time Employees Regular 93,289 97,522 102,146 102,146 105,294 3,148 3.08% 63.39% 65.72% 113 Sick Leave 2,165 2,261 2,290 2,290 2,371 81 3.56% 1.42% 1.48% 121 PERA Contributions 6,764 7,063 7,406 7,406 7,897 491 6.64% 4.60% 4.93% 122 FICA Contributions 5,940 6,163 6,475 6,475 6,675 200 3.09% 4.02% 4.17% 123 MEDICARE Contributions 1,389 1,441 1,514 1,514 1,561 47 3.08% 0.94% 0.97% 131 Health Insurance 6,816 7,939 8,366 8,366 6,739 (1,627) -19.45% 5.19% 4.21% 132 Dental Insurance 348 377 377 377 370 (7) -1.87% 0.23% 0.23% 133 Life Insurance 72 54 54 54 54 0 0.00% 0.03% 0.03% 135 HCSP Contributions 300 300 300 300 300 0 0.00% 0.19% 0.19% 151 Workers Comp-Insurance 378 456 507 507 645 138 27.32% 0.31% 0.40% 100 Severance Compensation Funding 466 487 511 511 526 15 2.99% 0.32% 0.33% 201 Office Supplies-General 81 74 281 281 250 (31) -11.03% 0.17% 0.16% 24 oQ rxrp,� City of Prior Lake Council Meeting 12.08.2014 2015 Proposed Budget Expenditure Details MMMs� From Amended Budget.... 2014 2015 2014 2015 2012 2013 2014 2014 2015 $Change %Change %of %of %of %of YE Actual YE Actual Adopted Amended Proposed 14-15 14-15 Subtotal Subtotal Total Total 314 Professional Services-General 17,594 4,999 12,000 12,000 10,000 (2,000) -16.67% 7.45% 6.24% 321 Communications 866 652 674 674 660 (14) -2.08% 0.42% 0.41% 331 Training&Certification - - 300 300 450 150 50.00% 0.19% 0.28% 354 Public Information 2,607 2,544 4,000 4,000 2,500 (1,500) -37.50% 2.48% 1.56% 437 Misc Expense-General 5,268 1,418 13,928 13,928 13,928 0 0.00% 8.64% 8.69% 144,343 133,750 161,128 161,128 160,220 (908) -0.56% 100.00% 100.00% 1.24% 1.28% 41830 Communications 101 Full Time Employees Regular 65,640 68,608 72,003 72,003 75,639 3,636 5.05% 57,31% 61.85% 103 Part Time Employees Regular 2,621 3,259 4,000 4,000 4,464 464 11.60% 3.18% 3.65% 121 PERA Contributions 4,759 4,974 5,220 5,220 5,673 453 8.67% 4.15% 4.64% 122 FICA Contributions 3,964 4,236 4,712 4,712 4,966 254 5.39% 3.75% 4.06% 123 MEDICARE Contributions 927 991 1,102 1,102 1,161 59 5.39% 0.88% 0.95% 131 Health Insurance 11,280 11,500 11,860 11,860 10,660 (1,200) -10.12% 9.44% 8.72% 132 Dental Insurance 348 480 480 480 480 0 0.00% 0.38% 0.39% 133 Life Insurance 88 68 68 68 68 0 0.00% 0.05% 0.06% 135 HCSP Contributions 300 300 300 300 300 0 0.00% 0.24% 0.25% 151 Workers Comp-Insurance 391 323 358 358 461 103 28.78% 0.28% 0.38% 100 Severance Compensation Funding 328 343 360 360 378 18 4.99% 0.29% 0.31% 210 Operating Supplies-General 351 292 1,684 1,684 750 (934) -55.46% 1.34% 0.61% 314 Professional Services-General 709 500 2,500 2,500 2,000 (500) -20.00% 1.99% 1.64% 331 Training&Certification - - - - 100 100 n/a 0.00% 0.08% 354 Public Information 15,343 17,696 19,000 19,000 15,200 (3,800) -20.00% 15.12% 12.43% 437 Misc Expense-General 1,362 2,000 2,000 (2,000) -100.00% 1.59% 0.00% 107,151 115,053 125,648 125,648 122,301 (3,347) -2.66% 100.00% 100.00% 0.97% 0.97% 41910 Comm Development/Natural Res 101 Full Time Employees Regular 226,715 224,373 220,493 220,493 211,448 (9,045) -4.10% 68.08% 68.65% 102 Full Time Employees Overtime 618 2,022 3,000 3,000 3,000 0 0.00% 0.93% 0.97% 121 PERA Contributions 16,482 16,362 16,203 16,203 16,084 (120) -0.74% 5.00% 5.22% 122 FICA Contributions 13,586 13,408 13,857 13,857 13,296 (561) -4.05% 4.28% 4.32% 123 MEDICARE Contributions 3,177 3,136 3,241 3,241 3,110 (131) -4.05% 1.00% 1.01% 131 Health Insurance 30,344 31,567 32,431 32,431 26,099 (6,332) -19.52% 10.01% 8.47% 132 Dental Insurance 1,388 1,411 1,380 1,380 1,275 (105) -7.60% 0.43% 0.41% 133 Life Insurance 242 193 193 193 178 (14) -7.48% 0.06% 0.06% 135 HCSP Contributions 246 615 645 645 600 (45) -6.98% 0.20% 0.19% 151 Workers Comp-Insurance 1,234 1,033 1,060 1,060 1,247 187 17.65% 0.33% 0.40% 100 Severance Compensation Funding 1,130 1,115 1,102 1,102 1,057 (45) -4.10% 0.34% 0.34% 201 Office Supplies-General 527 754 1,404 1,404 1,400 (4) -0.28% 0.43% 0.45% 202 Office Supplies-Dup&Copy 161 78 468 468 500 32 6.84% 0.14% 0.16% 210 Operating Supplies-General - - 234 234 250 16 6.84% 0.07% 0.08% 240 Small Tools&Equipment 21 71 468 468 500 32 6.88% 0.14% 0.16% 313 Professional Services-Consultant - 39,398 7,500 7,500 5,000 (2,500) -33.33% 2.32% 1.62% 314 Professional Services-General 230 193 920 920 950 30 3.26% 0.28% 0.31% 321 Communications 802 652 702 702 750 48 6.84% 0.22% 0.24% 331 Training&Certification 545 656 900 900 1,000 100 11.11% 0.28% 0.32% 404 Repair&Maint Service-Equipment 3,083 1,665 4,250 4,250 4,250 0 0.00% 1.31% 1.38% 433 Dues&Subscriptions 1,177 725 1,400 1,400 1,000 (400) -28.57% 0.43% 0.32% 437 Misc Expense-General 5,457 15,827 12,000 12,000 15,000 3,000 25.00% 3.71% 4.87% 308,849 355,591 323,850 323,850 307,993 (15,856) -4.90% 100.00% 100.00% 2.49% 2.45% 25 pQ PRlp$ City of Prior Lake Council Meeting 12.08.2014 u' 2015 Proposed Budget Expenditure Details From Amended Budget.... 2014 2015 2014 2015 2012 2013 2014 2014 2015 $Change %Change %of %of %of %of _YE Actual YE Actual Adopted Amended Proposed 14-15 14-16 Subtotal Subtotal Total Total 41920 Technology 101 Full Time Employees Regular 12,847 17,815 98,888 98,888 103,959 5,071 5.13% 14.38% 39.38% 121 PERA Contributions 931 1,292 7,169 7,169 7,797 628 8.75% 1.04% 2.95% 122 FICA Contributions 796 1,095 6,131 6,131 6,445 314 5.12% 0.89% 2.44% 123 MEDICARE Contributions 186 256 1,434 1,434 1,507 73 5.10% 0.21% 0.57% 131 Health Insurance - 1,985 10,458 10,458 9,404 (1,053) -10.07% 1.52% 3.56% 132 Dental Insurance 51 94 471 471 490 19 3.96% 0.07% 0.19% 133 Life Insurance 13 17 71 71 71 0 0.00% 0.01% 0.03% 135 Health Savings Plan - 53 375 375 375 0 0.00% 0.05% 0.14% 151 Workers Comp-Insurance 89 79 468 468 603 135 28.74% 0.07% 0.23% 100 Severance Compensation Funding 64 89 494 494 520 26 5.17% 0.07% 0.20% 210 Operating Supplies-General 1,032 4,362 973 973 1,040 67 6.88% 0.14% 0.39% 306 Training Expenses - - 2,000 2,000 2,000 0 0.00% 0.29% 0.76% 309 Software Design 2,875 8,948 31,570 31,570 18,723 (12,847) -40.69% 4.59% 7.09% 313 Professional Services-Consultant 30,848 147,327 172,000 172,000 7,000 (165,000) -95.93% 25.01% 2.65% 321 Communications 1,275 1,579 600 600 2,080 1,480 246.67% 0.09% 0.79% 407 Software Service Contract 31,847 38,913 45,840 45,840 77,119 31,279 68.24% 6.66% 29.21% 408 Hardware Service Contract 96 3,376 - - 1,700 1,700 n/a 0.00% 0.64% 580 General Equipment 84,269 43,483 308,908 308,908 23,163 (285,745) -92.50% 44.91% 8.77% 167,219 271,003 687,851 687,851 263,996 (423,855) -61.62% 100.00% 100.00% 5.30% 2.10% 41940 Buildings&Plant 101 Full Time Employees Regular 51,433 166 23,275 23,275 50,277 27,002 116.01% 5.41% 9.79% 121 PERA Contributions 3,130 278 1,687 1,687 3,771 2,083 123.46% 0.39% 0.73% 122 FICA Contributions 3,515 238 1,443 1,443 3,117 1,674 116.01% 0.34% 0.61% 123 MEDICARE Contributions 822 56 337 337 729 392 116.01% 0.08% 0.14% 131 Health Insurance 3,408 - - - 8,995 8,995 n/a 0.00% 1.75% 132 Dental Insurance 240 480 480 n/a 0.00% 0.09% 133 Life Insurance 44 58 58 n/a 0.00% 0.01% 135 HCSP Contributions 150 - - - 180 180 n/a 0.00% 0.04% 151 Workers Comp-Insurance 177 1,477 808 808 3,552 2,744 339.45% 0.19% 0.69% 100 Severance Compensation Funding 216 19 116 116 251 135 116.00% 0.03% 0.05% 223 Repair&Maint Supplies-Bldgs 6,721 4,799 5,614 5,614 5,614 0 0.00% 1.30% 1.09% 313 Prof Serv.-Consultant 2,000 9,000 9,000 9,000 9,000 0 0.00% 2.09% 1.75% 321 Communications 15,699 16,823 15,021 15,021 15,021 0 0.00% 3.49% 2.93% 322 Communications-Postage 10,391 15,479 16,350 16,350 16,350 0 0.00% 3.80% 3.18% 361 Insurance-Liability 93,219 116,455 94,365 94,365 104,378 10,013 10.61% 21.92% 20.33% 362Insurance-Property 107,800 106,534 110,481 110,481 109,570 (911) -0.82% 25.66% 21.34% 381 Utilities-Electric 55,745 66,881 43,041 43,041 70,900 27,859 64.73% 10.00% 13.81% 383 Utilities-Gas 20,320 31,662 28,070 28,070 33,500 5,430 19.34% 6.52% 6.52% 384 Refuse Disposal 1,226 1,320 1,224 1,224 1,051 (173) -14.13% 0.28% 0.20% 401 Repair&Maint Service-Bldgs 15,153 20,109 30,037 30,037 30,250 213 0.71% 6.98% 5.89% 404 Repair&Maint Service-Equipment 11,249 7,358 8,850 8,850 8,850 0 0.00% 2.06% 1.72% 406 Repair&Maint Service-Clean 18,103 19,797 25,741 25,741 24,011 (1,730) -6.72% 5.98% 4.68% 413 Rentals-Office Equipment 4,446 202 5,053 5,053 5,053 0 0.00% 1.17% 0.98% 570 Office Equipment&Furnishings 8,205 2,154 9,985 9,985 8,500 (1,485) -14.88% 2.32% 1.66% 443,030 490,244 430,500 430,500 513,457 82,957 19.27% 100.00% 100.00% 3.32% 4.09% Total General Government 2,538,467 2,723,537 3,234,377 3,234,377 2,732,840 (501,536) -15.51% 100.00% 100.00% 24.91% 21.75% 26 pQ PRfpB City of Prior Lake Council Meeting 12.08.2014 u 2015 Proposed Budget Expenditure Details h� Ii From Amended Budget.... 2014 2015 2014 2015 2012 2013 2014 2014 2015 $Change %Change %of %of %of %,of YE Actual YE Actual Adopted Amended Proposed 14-15 14-15 Subtotal Subtotal Total Total Public Safety 42100 Police 101 Full Time Employees Regular 1,837,093 2,011,047 1,980,580 1,980,580 2,027,195 46,615 2.35% 59.10% 60.25% 102 Full Time Employees Overtime 153,215 180,147 121,000 121,000 123,000 2,000 1.65% 3.61% 3.66% 103 Part Time Employees Regular 78,737 82,755 106,303 106,303 81,794 (24,509) -23.06% 3.17% 2.43% 106 Training Overtime 9,628 6,445 9,211 9,211 9,211 0 0.00% 0.27% 0.27% 112 Longevity 86,650 - 102,077 102,077 96,536 (5,541) -5.43% 3.05% 2.87% 113 Sick Leave 14,486 18,595 26,561 26,561 13,287 (13,274) -49.98% 0.79% 0.39% 119 Clothing Allowance 18,181 19,010 20,185 20,185 20,264 79 0.39% 0.60% 0.60% 121 PERA Contributions 295,913 312,859 334,166 334,166 357,895 23,729 7.10% 9.97% 10.64% 122 FICA Contributions 13,015 13,225 16,071 16,071 14,836 (1,235) -7.69% 0.48% 0.44% 123 MEDICARE Contributions 28,983 31,128 34,306 34,306 34,384 78 0.23% 1.02% 1.02% 131 Health Insurance 226,188 225,188 242,318 242,318 213,322 (28,996) -11.97% 7.23% 6.34% 132 Dental Insurance 10,769 10,941 11,244 11,244 11,089 (155) -1.38% 0.34% 0.33% 133 Life Insurance 2,202 1,724 1,753 1,753 1,753 0 0.00% 0.05% 0.05% 135 HCSP Contributions 5,753 5,828 6,180 6,180 5,895 (285) -4.61% 0.18% 0.18% 151 Workers Comp-Insurance 49,746 44,914 49,362 49,362 61,474 12,112 24.54% 1.47% 1.83% 100 Severance Compensation Funding 10,013 10,492 10,945 10,945 11,689 744 6.80% 0.33% 0.35% 201 Office Supplies-General 3,645 4,355 3,509 3,509 3,509 0 0.00% 0.10% 0.10% 202 Office Supplies-Dup&Copy 604 354 842 842 841 (1) -0.13% 0.03% 0.02% 203 Office Supplies-Printed Forms 1,960 2,182 1,684 1,684 1,684 0 0.00% 0.05% 0.05% 210 Operating Supplies-General 5,765 8,042 5,895 5,895 6,895 1,000 16.97% 0.18% 0.20% 212 Operating Supplies-Fuel 68,143 68,500 66,780 66,780 58,380 (8,400) -12.58% 1.99% 1.74% 217 Operating Supplies-Uniforms 6,766 5,306 9,421 9,421 18,059 8,638 91.69% 0.28% 0.54% 221 Repair&Maint Sup-Equipment 2,228 3,926 2,339 2,339 2,339 0 0.00% 0.07% 0.07% 223 Repair&Maint Sup-Bldgs 5,738 4,366 4,211 4,211 4,211 0 0.00% 0.13% 0.13% 228 Repair&Maint Sup-Vehicles 4,363 4,654 3,000 3,000 3,000 0 0.00% 0.09% 0.09% 240 Small Tools&Equipment 27,960 16,638 18,129 18,129 18,129 0 0.00% 0.54% 0.54% 306 Training Expenses 10,901 12,355 9,500 9,500 10,000 500 5.26% 0.28% 0.30% 314 Professional Services-General 23,110 24,612 29,100 29,100 25,400 (3,700) -12.71% 0.87% 0.75% 321 Communications 9,901 8,617 10,292 10,292 11,000 708 6.88% 0.31% 0.33% 324 Communications-Ticketwriter 3,241 2,738 4,500 4,500 4,000 (500) -11.11% 0.13% 0.12% 325 Communications-State Terminal 1,080 1,080 1,080 1,080 1,080 0 0.00% 0.03% 0.03% 326 Communications-Computer 3,240 3,240 3,240 3,240 3,240 0 0.00% 0.10% 0.10% 331 Training&Certification 12 1,562 1,500 1,500 1,500 0 0.00% 0.04% 0.04% 363 Insurance-Auto 4,612 7,087 4,500 4,500 7,508 3,008 66.84% 0.13% 0.22% 381 Utilities-Electric 33,696 32,594 28,070 28,070 34,600 6,530 23.26% 0.84% 1.03% 383 Utilities-Gas 11,772 12,172 14,971 14,971 13,000 (1,971) -13.17% 0.45% 0.39% 384 Refuse Disposal 499 561 600 600 433 (167) -27.83% 0.02% 0.01% 401 Repair&Maint Service-Bldgs 9,838 14,680 17,000 17,000 15,296 (1,704) -10.02% 0.51% 0.45% 404 Repair&Maint Service-Equipment 3,219 2,752 5,000 5,000 5,000 0 0.00% 0.15% 0.15% 406 Repair&Maint Service-Clean 10,083 10,042 15,783 15,783 14,857 (926) -5.87% 0.47% 0.44% 407 Software Service Contract - - - - 4,200 4,200 n/a 0.00% 0.12% 413 Rentals-Office Equipment 4,143 4,143 3,876 3,876 - (3,876) -100.00% 0.12% 0.00% 421 Special Response Team SRT 10,000 10,000 10,000 10,000 10,000 0 0.00% 0.30% 0.30% 433 Dues&Subscriptions 2,522 2,137 3,000 3,000 3,000 0 0.00% 0.09% 0.09% 437 MiscExpense-General 1,887 1,059 1,000 1,000 (1,000) -100.00% 0.03% 0.00% 3,118,245 3,244,390 3,351,084 3,351,084 3,364,784 13,700 0.41% 100.00% 100.00% 25.81% 26.78% 27 pQ PAIpB ~� City of Prior Lake Council Meeting 12.08.2014 � m 2015 Proposed Budget Expenditure Details From Amended Budget.... 2014 2015 2014 2015 2012 2013 2014 2014 2015 $Change %Change %Of %Of %Of %of YE Actual YE Actual Adopted Amended Proposed 14-15 14-15 Subtotal Subtotal Total Total 42200 Fire 101 Full Time Employees Regular 93,131 97,422 102,328 102,328 107,576 5,248 5.13% 11.31% 12.17% 104 Temporary Employees Regular - 9,100 9,100 - (9,100) -100.00% 1.01% 0.00% 113 Sick Leave - - 639 639 n/a 0.00% 0.07% 117 Volunteer Compensation 166,758 180,144 206,520 206,520 195,760 (10,760) -5.21% 22.83% 22.15% 121 PERA Contributions 13,411 14,063 15,656 15,656 17,427 1,771 11.31% 1.73% 1.97% 122 FICA Contributions 10,339 11,169 13,368 13,368 10,727 (2,642) -19.76% 1.48% 1.21% 123 MEDICARE Contributions 3,698 3,955 4,610 4,610 4,078 (532) -11.55% 0.51% 0.46% 124 Pension Contribution 75,925 78,990 20,000 20,000 20,000 0 0.00% 2.21% 2.26% 125 Insurance Premium Contribution 143,938 206,356 205,000 205,000 209,000 4,000 1.95% 22.67% 23.65% 131 Health Insurance 11,280 10,010 10,408 10,408 8,995 (1,413) -13.58% 1.15% 1.02% 132 Dental Insurance 480 480 480 480 480 0 0.00% 0.05% 0.05% 133 Life Insurance 88 68 68 68 68 0 0.00% 0.01% 0.01% 135 HCSP Contributions 300 300 300 300 300 0 0.00% 0.03% 0.03% 151 Workers Comp-Insurance 28,705 35,016 35,431 35,431 36,841 1,411 3.98% 3.92% 4.17% 100 Severance Compensation Funding 466 487 512 512 538 26 5.15% 0.06% 0.06% 201 Office Supplies-General 194 273 281 281 281 0 0.00% 0.03% 0.03% 202 Office Supplies-Dup&Copy 55 13 173 173 174 1 0.52% 0.02% 0.02% 210 Operating Supplies-General 3,396 8,388 6,316 6,316 6,316 0 0.00% 0.70% 0.71% 212 Operating Supplies-Fuel 15,652 14,732 15,900 15,900 14,950 (950) -5.97% 1.76% 1.69% 217 Operating Supplies-Uniforms 35,298 26,700 31,813 31,813 31,813 0 0.00% 3.52% 3.60% 218 Operating Supplies-Medical 1,106 734 1,684 1,684 1,684 0 0.00% 0.19% 0.19% 221 Repair&Maint Sup-Equipment 8,773 6,136 7,485 7,485 7,485 0 0.00% 0.83% 0.85% 223 Repair&Maint Sup-Bldgs 7,454 7,782 7,485 7,485 7,485 0 0.00% 0.83% 0.85% 240 Small Tools&Equipment 2,722 15,529 14,971 14,971 21,989 7,018 46.88% 1.66% 2.49% 306 Training Expenses 4,924 9,528 15,500 15,500 15,500 0 0.00% 1.71% 1.75% 321 Communications 9,061 8,402 8,241 8,241 8,808 567 6.88% 0.91% 1.00% 331 Training&Certification 3,145 1,831 3,500 3,500 3,500 0 0.00% 0.39% 0.40% 354 Public Information 5,488 5,672 6,500 6,500 6,500 0 0.00% 0.72% 0.74% 363 Insurance Auto 10,457 5,883 11,500 11,500 10,525 (975) -8.48% 1.27% 1.19% 381 Utilities-Electric 25,770 24,722 25,263 25,263 26,500 1,237 4.90% 2.79% 3.00% 383 Utilities-Gas 10,147 15,089 16,374 16,374 16,000 (374) -2.28% 1.81% 1.81% 384 Refuse Disposal 928 1,043 948 948 866 (82) -8.65% 0.10% 0.10% 401 Repair&Maint Service-Bldgs 29,962 29,521 25,560 25,560 21,088 (4,472) -17.50% 2.83% 2.39% 404 Repair&Maint Service-Equipment 41,746 19,969 16,800 16,800 16,800 0 0.00% 1.86% 1.90% 406 Repair&Maint Service-Clean 7,040 9,372 10,837 10,837 6,663 (4,174) -38.52% 1.20% 0.75% 433 Dues&Subscriptions 1,497 2,486 2,000 2,000 2,000 0 0.00% 0.22% 0.23% 437 Misc Expense-General 3,679 3,485 3,500 3,500 3,500 0 0.00% 0.39% 0.40% 520 Buildings&Structures 40,998 40,998 41,000 41,000 41,000 0 0.00% 4.53% 4.64% 580 General Equipment 13,199 5,475 7,018 7,018 (7,018) -100.00% 0.78% 0.00% 831,210 902,223 904,430 904,430 883,855 (20,575) -2.27% 100.00% 100.00% 6.97% 7.03% 28 oQ rwa8 City of Prior Lake Council Meeting 12.08.2014 - 2015 Proposed Budget U T Expenditure Details From Amended Budget.... 2014 2015 2014 2015 2012 2013 2014 2014 2015 $Change %Change %of %of %of %of YE Actual YE Actual Adopted Amended Proposed 14-15 14-15 Subtotal Subtotal Total Total 42400 Building Inspection 101 Full Time Employees Regular 319,390 328,132 399,812 399,812 416,353 16,541 4.14% 71.02% 72.10% 102 Full Time Employees Overtime 7,735 4,024 7,500 7,500 7,500 0 0.00% 1.33% 1.30% 104 Temporary Employees Regular - 56,571 15,400 15,400 15,400 0 0.00% 2.74% 2.67% 113 Sick Leave 5,472 1,187 2,663 2,663 1,795 (868) -32.61% 0.47% 0.31% 121 PERA Contributions 23,498 24,067 29,530 29,530 31,789 2,259 7.65% 5.25% 5.51% 122 FICA Contributions 18,718 20,816 26,373 26,373 27,345 972 3.68% 4.68% 4.74% 123 MEDICARE Contributions 4,378 4,868 6,168 6,168 6,395 227 3.68% 1.10% 1.11% 131 Health Insurance 40,248 42,714 56,452 56,452 42,946 (13,506) -23.92% 10.03% 7.44% 132 Dental Insurance 1,941 1,954 2,434 2,434 2,420 (14) -0.58% 0.43% 0.42% 133 Life Insurance 324 261 319 319 319 0 0.00% 0.06% 0.06% 135 HCSP Contributions 915 863 990 990 1,140 150 15.15% 0.18% 0.20% 151 Workers Comp-Insurance 1,393 1,786 2,056 2,056 2,630 574 27.92% 0.37% 0.46% 100 Severance Compensation Funding 1,578 1,636 1,999 1,999 2,082 83 4.15% 0.36% 0.36% 201 Office Supplies-General 1,334 1,708 1,404 1,404 1,500 96 6.84% 0.25% 0.26% 203 Office Supplies-Printed Forms 1,074 2,904 1,404 1,404 1,500 96 6.84% 0.25% 0.26% 210 Operating Supplies-General 109 169 1,216 1,216 1,000 (216) -17.76% 0.22% 0.17% 212 Operating Supplies-Fuel 2,516 2,347 3,180 3,180 8,340 5,160 162.26% 0.56% 1.44% 217 Operating Supplies-Uniforms 178 423 374 374 374 0 0.00% 0.07% 0.06% 240 Small Tools&Equipment 73 6 561 561 300 (261) -46.56% 0.10% 0.05% 321 Communications 679 734 898 898 2,900 2,002 222.85% 0.16% 0.50% 331 Training&Certification 1,178 3,157 1,500 1,500 2,300 800 53.33% 0.27% 0.40% 363 Insurance-Auto 344 251 350 350 315 (35) -10.00% 0.06% 0.05% 433 Dues&Subscriptions 375 14 400 400 400 0 0.00% 0.07% 0.07% 437 Misc Expense-General 32 432 - 400 400 n/a 0.00% 0.07% 433,482 501,024 562,984 562,984 577,443 14,459 2.57% 100.00% 100.00% 4.34% 4.60% 42500 Emergency Management 381 Utilities-Electric 1,460 2,588 1,500 1,500 2,000 500 33.33% 30.00% 19.95% 404 Repair&Maint Service-Equipment 31,472 945 3,500 3,500 8,025 4,525 129.29% 70.00% 80.05% 32,932 3,533 5,000 5,000 10,025 5,025 100.50% 100.00% 100.00% 0.04% 0.08% 42700 Animal Control 311 Animal Control Contract 25,650 26,612 25,257 25,257 25,257 0 0.00% 100.00% 100.00% 0.19% 0.20% Total Public Safety 4,441,519 4,677,782 4,848,755 4,848,755 4,861,364 12,609 0.26% 100.00% 100.00% 37.34% 38.69% 29 pQ PBtp$ F� City of Prior Lake Council Meeting 12.08.2014 2015 Proposed Budget Expenditure Details From Amended Budget.... 2014 2015 2014 2015 2012 2013 2014 2014 2015 $Change %Change %of %of %of %of YE Actual YE Actual Adopted Amended Proposed 14-15 14-15 Subtotal Subtotal Total Total Public Works 43050 Engineering 101 Full Time Employees Regular 172,171 181,810 212,016 212,016 219,486 7,470 3.52% 57.15% 57.74% 102 Full Time Employees Overtime 4,654 6,944 7,500 7,500 5,000 (2,500) -33.33% 2.02% 1.32% 103 Part Time Employees-Regular 35,343 30,136 30,826 30,826 26,077 (4,748) -15.40% 8.31% 6.86% 104 Temporary Employees-Regular - - - - 11,800 11,800 n/a 0.00% 3.10% 113 Sick Leave 2,539 2,570 1,700 1,700 2,566 866 50.93% 0.46% 0.68% 121 PERA Contributions 15,141 15,870 18,150 18,150 18,792 642 3.54% 4.89% 4.94% 122 FICA Contributions 12,282 12,686 15,627 15,627 16,426 799 5.12% 4.21% 4.32% 123 MEDICARE Contributions 2,872 2,967 3,655 3,655 3,841 186 5.10% 0.99% 1.01% 131 Health Insurance 22,680 25,779 29,158 29,158 28,249 (909) -3.12% 7.86% 7.43% 132 Dental Insurance 1,031 1,092 1,205 1,205 1,200 (5) -0.38% 0.32% 0.32% 133 Life Insurance 172 145 165 165 165 0 0.00% 0.04% 0.04% 135 HCSP Contributions 600 670 795 795 675 (120) -15.09% 0.21% 0.18% 151 Workers Comp-Insurance 880 998 1,218 1,218 1,581 363 29.78% 0.33% 0.42% 100 Severance Compensation Funding 1,019 1,058 1,214 1,214 1,228 14 1.14% 0.33% 0.32% 201 Office Supplies-General 1,078 1,481 1,684 1,684 1,700 16 0.95% 0.45% 0.45% 202 Office Supplies-Dup&Copy 248 60 468 468 500 32 6.88% 0.13% 0.13% 205 Drafting Supplies 486 132 281 281 300 19 6.76% 0.08% 0.08% 210 Operating Supplies-General 5,860 360 3,883 3,883 5,500 1,617 41.64% 1.05% 1.45% 212 Operating Supplies-Fuel 2,638 2,802 3,000 3,000 2,780 (220) -7.33% 0.81% 0.73% 217 Operating Supplies-Clothing - 31 281 281 300 19 6.76% 0.08% 0.08% 240 Small Tools&Equipment 1,259 - 936 936 500 (436) -46.56% 0.25% 0.13% 303 Professional Service-Engineering 61,997 40,057 25,000 25,000 20,000 (5,000) -20.00% 6.74% 5.26% 314 Professional Service-General - 920 920 460 (460) -50.00% 0.25% 0.12% 321 Communications 2,138 2,298 2,470 2,470 2,640 170 6.88% 0.67% 0.69% 331 Training&Certification 2,027 3,199 3,000 3,000 2,550 (450) -15.00% 0.81% 0.67% 363 Insurance-Auto 344 240 350 350 330 (20) -5.71% 0.09% 0.09% 404 Repair&Maint Service-Equipment 3,083 2,095 3,000 3,000 3,500 500 16.67% 0.81% 0.92% 407 Software Service Contract 1,867 1,600 1,600 1,600 1,600 0 0.00% 0.43% 0.42% 413 Rentals-Office Equipment 1,684 - 500 500 - (500) -100.00% 0.13% 0.00% 437 Misc Expense-General 504 210 400 400 400 0 0.00% 0.11% 0.11% 356,597 337,290 371,001 371,001 380,147 9,146 2.47% 100.00% 100.00% 2.86% 3.03% 43100 Street 101 Full Time Employees Regular 179,942 202,006 215,296 215,296 226,383 11,087 5.15% 17.72% 16.81% 102 Full Time Employees Overtime 12,784 13,134 23,000 23,000 23,000 0 0.00% 1.89% 1.71% 104 Temporary Employees-Regular 7,967 9,498 10,000 10,000 10,000 0 0.00% 0.82% 0.74% 113 Sick Leave 1,931 2,265 1,281 1,281 57 (1,224) -95.55% 0.11% 0.00% 121 PERA Contributions 13,679 15,434 17,276 17,276 18,704 1,427 8.26% 1.42% 1.39% 122 FICA Contributions 10,780 13,047 15,474 15,474 16,085 611 3.95% 1.27% 1.19% 123 MEDICARE Contributions 2,521 3,051 3,619 3,619 3,762 143 3.96% 0.30% 0.28% 131 Health Insurance 33,996 36,753 39,579 39,579 33,818 (5,761) -14.56% 3.26% 2.51% 132 Dental Insurance 1,498 1,612 1,688 1,688 1,672 (16) -0.94% 0.14% 0.12% 133 Life Insurance 239 198 206 206 206 0 0.00% 0.02% 0.02% 135 HCSP Contributions 635 605 784 784 810 26 3.35% 0.06% 0.06% 151 Workers Comp-Insurance 9,509 11,434 13,196 13,196 16,952 3,756 28.47% 1.09% 1.26% 100 Severance Compensation Funding 877 996 1,076 1,076 1,132 56 5.16% 0.09% 0.08% 210 Operating Supplies-General 2,782 925 4,725 4,725 4,726 1 0.02% 0.39% 0.35% 212 Operating Supplies-Fuel 52,888 64,038 47,700 47,700 61,980 14,280 29.94% 3.92% 4.60% 215Operating Supplies-Shop Material 1,190 87 3,743 3,743 740 (3,003) -80.23% 0.31% 0.05% 217 Operating Supplies-Uniforms 3,323 3,216 2,620 2,620 2,620 0 0.00% 0.22% 0.19% 219 Operating Supplies-Snow&Ice 75,101 99,361 62,024 62,024 73,990 11,966 19.29% 5.10% 5.50% 30 OQ PRIpQ F® City of Prior Lake Council Meeting 12.08.2014 m 2015 Proposed Budget Expenditure Details MpKSd1r From Amended Budget.... 2014 2015 2014 2015 2012 2013 2014 2014 2015 $Change %Change %of %of %of %of YE Actual YE Actual Adopted Amended Proposed 14-15 14-15 Subtotal Subtotal Total Total 223 Repair&Maint Sup-Bldgs 10 - 1,029 1,029 1,030 1 0.07% 0.08% 0.08% 224 Repair&Maint Sup-General 90,871 85,780 89,899 89,899 103,835 13,936 15.50% 7.40% 7.71% 240 Small Tools&Equipment 2,654 4,189 4,678 4,678 4,679 1 0.01% 0.38% 0.35% 331 Training&Certification 3,638 1,658 4,100 4,100 4,100 0 0.00% 0.34% 0.30% 363 Insurance-Auto 1,823 1,975 1,870 1,870 1,963 93 4.97% 0.15% 0.15% 381 Utilities-Electric 145 - 1,310 1,310 500 (810) -61.83% 0.11% 0.04% 384 Refuse Disposal - - 900 900 900 0 0.00% 0.07% 0.07%, 386 Street Lighting 193,322 185,919 182,082 182,082 200,200 18,118 9.95% 14.98% 14.87% 407 Software Service Contract 2,277 4,643 12,000 12,000 12,000 0 0.00% 0.99% 0.89% 409 Dust Control 5,841 7,954 5,614 5,614 5,614 0 0.00% 0.46% 0.42% 412 Repair&Maint Service-General 285,747 419,594 443,000 443,000 509,340 66,340 14.98% 36.45% 37.83% 415 Rentals-Heavy Equipment 2,309 360 4,678 4,678 4,678 0 0.00% 0.38% 0.35% 433 Dues&Subscriptions 765 860 845 845 845 0 0.00% 0.07% 0.06% 1,007,283 1,191,124 1,215,292 1,215,292 1,346,321 131,029 10.78% 100.00% 100.00% 9.36% 10.72% 43400 Central Garage 101 Full Time Employees Regular 113,220 112,029 114,691 114,691 117,562 2,871 2.50% 31.69% 31.79% 102 Full Time Employees Overtime 814 1,109 3,026 3,026 3,026 0 0.00% 0.84% 0.82% 104 Temporary Employees Regular 9,898 8,943 9,600 9,600 9,600 0 0.00% 2.65% 2.60% 113 Sick Leave 699 915 - - 943 943 n/a 0.00% 0.26% 121 PERA Contributions 8,275 8,202 8,535 8,535 9,044 510 5.97% 2.36% 2.45% 122 FICA Contributions 6,609 6,843 7,894 7,894 8,130 236 2.99% 2.18% 2.20% 123 MEDICARE Contributions 1,545 1,600 1,846 1,846 1,901 55 2.97% 0.51% 0.51% 131 Health Insurance 23,040 23,000 23,720 23,720 21,320 (2,400) -10.12% 6.55% 5.77% 132 Dental Insurance 960 960 960 960 960 0 0.00% 0.27% 0.26% 133 Life Insurance 146 115 115 115 115 0 0.00% 0.03% 0.03% 135 HCSP Contributions 360 360 360 360 360 0 0.00% 0.10% 0.10% 151 Workers Comp-Insurance 3,049 3,375 3,679 3,679 4,674 995 27.06% 1.02% 1.26% 100 Severance Compensation Funding 565 558 573 573 588 14 2.50% 0.16% 0.16% 201 Office Supplies-General 102 189 468 468 468 0 0.00% 0.13% 0.13% 203 Office Supplies-Printed Forms - - 281 281 281 0 0.00% 0.08% 0.08% 210 Operating Supplies-General 4,018 5,678 5,614 5,614 5,614 0 0.00% 1.55% 1.52% 215 Operating Supplies-Shop Material 12,322 21,826 6,550 6,550 6,550 0 0.00% 1.81% 1.77% 217 Operating Supplies-Uniforms 2,242 1,380 2,339 2,339 2,339 0 0.00% 0.65% 0.63% 240 Small Tools&Equipment 7,753 3,195 6,082 6,082 9,200 3,118 51.27% 1.68% 2.49% 331 Training&Certification 562 360 2,000 2,000 2,000 0 0.00% 0.55% 0.54% 384 Refuse Disposal 1,178 587 500 500 1,000 500 100.00% 0.14% 0.27% 407 Software Service Contract - - 100 100 100 0 0.00% 0.03% 0.03% 412 Repair&Maint Service-General 973 2,890 1,600 1,600 1,600 0 0.00% 0.44% 0.43% 433 Dues&Subscriptions 3,848 2,458 2,200 2,200 3,200 1,000 45.45% 0.61% 0.87% 437 Misc Expense-General 619 216 900 900 900 0 0.00% 0.25% 0.24% 451 Repair Sup-Parts(P/S) 19,102 13,727 10,292 10,292 10,292 (0) 0.00% 2.84% 2.78% 452 Repair Sup-Parts(P/K) 12,704 13,561 16,842 16,842 16,842 (0) 0.00% 4.65% 4.55% 453 Repair Sup-Parts(P/W) 11,117 25,207 14,035 14,035 14,035 (0) 0.00% 3.88% 3.80% 454 Repair Sup-Parts(S/W) 4,351 3,678 3,743 3,743 3,743 0 0.01% 1.03% 1.01% 461 Repair Sup-Equip(P/S) 1,796 1,016 6,550 6,550 6,550 0 0.00% 1.81% 1.77% 462 Repair Sup-Equip(P/K) 38,018 28,934 24,327 24,327 24,327 (0) 0.00% 6.72% 6.58% 463 Repair Sup-Equip(P/W) 17,733 24,101 34,620 34,620 34,620 0 0.00% 9.56% 9.36% 464 Repair Sup-Equip(S/W) 6,481 26,583 8,421 8,421 8,421 (0) 0.00% 2.33% 2.28% 471 Batteries &Tires(P/S) 12,217 9,641 8,421 8,421 8,421 (0) 0.00% 2.33% 2.28% 472 Batteries &Tires(P/K) 7,575 3,136 7,953 7,953 7,953 (0) 0.00% 2.20% 2.15% 473 Batteries &Tires(P/W) 13,370 10,076 7,018 7,018 7,018 0 0.01% 1.94% 1.90% 474 Batteries &Tires(S/W) 2,265 1,716 1,871 1,871 1,871 (0) -0.02% 0.52% 0.51% 481 Minor Sery-Contract(P/S) 1,276 2,563 3,743 3,743 3,743 0 0.01% 1.03% 1.01% 31 �Q P1UO.PC F®k City of Prior Lake Council Meeting 12.08.2014 C 2015 Proposed Budget Expenditure Details From Amended Budget.... 2014 2015 2014 2015 2012 2013 2014 2014 2015 $Change %Change %of %of %of %of YE Actual YE Actual Adopted Amended Proposed 14-15 14-15 Subtotal Subtotal Total Total 482 Minor Sery-Contract(P/K) 1,539 5,335 2,339 2,339 2,339 (0) -0.01% 0.65% 0.63% 483 Minor Sery-Contract(P/W) 853 70 2,058 2,058 2,058 (0) -0.02% 0.57% 0.56% 484 Minor Sery-Contract(S/W) 1,153 1,484 936 936 936 0 0.04% 0.26% 0.25% 491 Major Sery-Contract(P/S) 926 890 1,871 1,871 1,871 (0) -0.02% 0.52% 0.51% 492 Major Sery-Contract(P/K) 1,250 1,711 1,404 1,404 1,404 0 0.03% 0.39% 0.38% 493 Major Sery-Contract(P/W) - 136 936 936 936 0 0.04% 0.26% 0.25% 494 Major Sery-Contract(SNV) 484 3,331 936 936 936 0 0.04% 0.26% 0.25% 349,878 376,868 361,948 361,948 369,791 7,842 2.17% 100.00% 100.00% 2.797/6 2.94% Total Public Works 1,713,758 1 905 282 1,948,241 1 948 241 2,096,259 148 017 7.60% 100.00% 100.00% 15.00% 16.68% Culture/Recreation 45100 Recreation 101 Full Time Employees Regular 73,196 117,627 123,622 123,622 128,583 4,960 4.01% 31.92% 35.78% 103 Part Time Emlpoyees-Regular 70,701 30,807 35,384 35,384 37,203 1,819 5.14% 9.14% 10.35% 104 Temporary Employees-Regular 72,484 70,910 70,812 70,812 50,812 (20,000) -28.24% 18.28% 14.14% 121 PERA Contributions 11,298 10,790 11,528 11,528 12,434 906 7.86% 2.98% 3.46% 122 FICA Contributions 13,038 13,381 14,249 14,249 13,429 (820) -5.75% 3.68% 3.74% 123 MEDICARE Contributions 3,049 3,129 3,332 3,332 3,141 (192) -5.75% 0.86% 0.87% 131 Health Insurance 11,280 18,877 20,226 20,226 17,399 (2,827) -13.98% 5.22% 4.84% 132 Dental Insurance 480 826 857 857 850 (7) -0.82% 0.22% 0.24% 133 Life Insurance 88 108 112 112 112 (0) -0.36% 0.03% 0.03% 135 HCSP Contributions 698 518 660 660 660 0 0.00% 0.17% 0.18% 151 Workers Comp-Insurance 5,257 4,240 6,059 6,059 7,036 978 16.14% 1.56% 1.96% 100 Severance Compensation Funding 719 741 795 795 829 34 4.26% 0.21% 0.23% 201 Office Supplies-General 660 963 936 936 500 (436) -46.58% 0.24% 0.14% 202 Office Supplies-Dup&Copy 138 86 234 234 150 (84) -35.88% 0.06% 0.04% 208 Senior Programs 9,731 8,935 11,000 11,000 11,000 0 0.00% 2.84% 3.06% 220 Operating Supplies-Playground 42,760 41,724 38,792 38,792 28,793 (9,999) -25.78% 10.02% 8.01% 259 Concessions 5,586 549 702 702 702 0 0.03% 0.18% 0.20% 308 Instructor's Fees 13,428 13,070 16,500 16,500 16,500 0 0.00% 4.26% 4.59% 316 Bank Service Charges 1,874 2,258 2,000 2,000 3,000 1,000 50.00% 0.52% 0.83% 321 Communications 2,854 2,165 2,077 2,077 450 (1,627) -78.34% 0.54% 0.13% 331 Training&Certification 751 1,313 1,100 1,100 1,100 0 0.00% 0.28% 0.31% 354 Public Information - 200 1,500 1,500 2,000 500 33.33% 0.39% 0.56% 404 Repair&Maint Service-Equipment 1,395 603 1,955 1,955 - (1,955) -100.00% 0.50% 0.00% 406 Repair&MaintService-Clean 823 1,643 1,588 1,588 2,202 614 38.66% 0.41% 0.61% 417 Community Events 20,262 28,057 20,550 20,550 19,743 (807) -3.93% 5.31% 5.49% 433 Dues&Subscriptions 434 659 750 750 750 0 0.00% 0.19% 0.21% 373,495 375,181 387,320 387,320 359,377 (27,943) -7.21% 100.00% 100.00% 2.98% 2.86% 45200 Parks 101 Full Time Employees Regular 399,430 406,880 420,634 420,634 436,201 15,567 3.70% 31.83% 32.76% 102 Full Time Employees Overtime 28,699 32,828 20,000 20,000 20,000 0 0.00% 1.51% 1.50% 104 Temporary Employees-Regular 193,770 190,019 195,600 195,600 195,600 0 0.00% 14.80% 14.69% 113 Sick Leave 1,533 527 3,278 3,278 - (3,278) -100.00% 0.25% 0.00% 121 PERA Contributions 36,541 36,742 31,946 31,946 34,215 2,269 7.10% 2.42% 2.57% 122 FICA Contributions 37,694 38,112 39,650 39,650 40,412 762 1.92% 3.00% 3.03% 123 MEDICARE Contributions 8,816 8,914 9,273 9,273 9,451 178 1.92% 0.70% 0.71% 131 Health Insurance 58,680 65,570 68,515 68,515 57,680 (10,835) -15.81% 5.18% 4.33% 132 Dental Insurance 2,772 2,965 2,965 2,965 2,930 (35) -1.19% 0.22% 0.22% 133 Life Insurance 508 402 402 402 402 0 0.00% 0.03% 0.03% 32 pQ PRIpP City of Prior Lake Council Meeting 12.08.2014 2015 Proposed Budget Expenditure Details MMMsm� From Amended Budget— . 2014 2015 2014 2015 2012 2013 2014 2014 2015 $Change %Change %of %of %of %of YE Actual YE Actual Adopted Amended Proposed 14-15 14-15 Subtotal Subtotal Total Total 135 HCSP Contributions 1,439 1,457 1,455 1,455 1,455 0 0.00% 0.11% 0.11% 151 Workers Comp-Insurance 14,043 13,555 14,826 14,826 18,609 3,783 25.52% 1.12% 1.40% 153 Mn Unemployment Insurance 890 82 2,500 2,500 2,500 0 0.00% 0.19% 0.19% 100 Severance Compensation Funding 2,020 2,028 2,103 2,103 2,181 78 3.70% 0.16% 0.16% 201 Office Supplies-General 430 202 936 936 1,000 64 6.84% 0.07% 0.08% 210 Operating Supplies-General 26,827 35,516 42,620 42,620 39,550 (3,070) -7.20% 3.23% 2.97% 212 Operating Supplies-Fuel 64,667 68,300 63,600 63,600 67,880 4,280 6.73% 4.81% 5.10% 215 Operating Supplies-Shop Material 1,568 17 1,871 1,871 2,000 129 6.89% 0.14% 0.15% 217 Operating Supplies-Uniforms 5,225 3,646 4,519 4,519 4,830 311 6.88% 0.34% 0.36% 223 Repair&Maint Sup-Bldgs 1,204 3,252 4,678 4,678 5,000 322 6.88% 0.35% 0.38% 224 Repair&Maint Sup-General 62,983 79,744 56,936 56,936 60,850 3,914 6.88% 4.31% 4.57% 240 Small Tools&Equipment 6,525 4,426 4,678 4,678 5,000 322 6.88% 0.35% 0.38% 313 Professional Services-Consultant 9,972 10,870 2,000 2,000 2,000 0 0.00% 0.15% 0.15% 321 Communications 8,811 1,708 599 599 640 41 6.88% 0.05% 0.05% 331 Training&Certification 4,383 2,665 3,880 3,880 3,880 0 0.00% 0.29% 0.29% 343 Sign Advertising - - 2,000 2,000 - (2,000) -100.00% 0.15% 0.00% 363 Insurance-Auto 3,878 2,351 3,712 3,712 3,146 (566) -15.25% 0.28% 0.24% 381 Utilities-Electric 13,226 22,394 14,877 14,877 24,000 9,123 61.32% 1.13% 1.80% 383 Utilities-Gas 2,846 4,913 4,678 4,678 5,500 822 17.57% 0.35% 0.41% 384 Refuse Disposal 11,548 12,628 13,522 13,522 14,290 768 5.68% 1.02% 1.07% 387 Park Lighting 36,458 33,570 35,556 35,556 36,000 444 1.25% 2.69% 2.70% 401 Repair&Maint Service-Bldgs 2,542 3,944 4,500 4,500 4,500 0 0.00% 0.34% 0.34% 402 Repair&Maint Service-Trails 21,383 15,497 20,000 20,000 20,000 0 0.00% 1.51% 1.50% 403 Repair&Maint Service-Parks 30,684 15,817 22,250 22,250 22,250 0 0.00% 1.68% 1.67% 415 Rentals-Heavy Equipment 14,732 14,605 15,602 15,602 15,603 1 0.00% 1.18% 1.17% 433 Dues&Subscriptions 230 1,084 350 350 350 0 0.00% 0.03% 0.03% 530 Improvements 111,275 106,752 185,000 343,519 171,771 (171,748) -50.00% 14.00% 12.90% 1,247,657 1,248,887 1,321,511 1,480030 1,331,676 (148355) -10.02% 100.00% 100.00% 10.18% 10.60% 45500 Libraries 223 Repair&Maint Sup-Bldgs 8,146 5,094 3,743 3,743 3,743 0 0.00% 4.96% 5.61% 321 Communications 2,223 2,283 2,111 2,111 2,364 253 11.99% 2.80% 3.54% 381 Utilities-Electric 26,542 19,859 24,327 24,327 21,000 (3,327) -13.68% 32.21% 31.46% 383 Utilities-Gas 9,055 9,620 14,035 14,035 10,200 (3,835) -27.32% 18.59% 15.28% 384 Refuse Disposal 1,304 1,320 1,224 1,224 1,051 (173) -14.13% 1.62% 1.57% 401 Repair&Maint Service-Bldgs 6,638 14,298 10,700 10,700 10,700 0 0.00% 14.17% 16.03% 406 Repair&Maint Service-Clean 11,692 14,997 19,376 19,376 17,702 (1,674) -8.64% 25.66% 26.52% 65,662 67,471 75,516 75,516 66,760 (8,756) -11.59% 100.00% 100.00% 0.58% 0.53% Total Culture/Recreation 1,686,814 1,691,539 1,784,347 1,942,866 1,757,813 (185,053) -9.52% 100.00% 100.00% 13.74% 13.99% Natural Resources 46100 Natural Resources 101 Full Time Employees Regular 77,214 27,161 28,022 28,022 28,722 701 2.50% 36.11% 35.98% 121 PERA Contributions 4,999 1,969 2,032 2,032 2,154 122 6.03% 2.62% 2.70% 122 FICA Contributions 4,964 1,589 1,737 1,737 1,781 44 2.51% 2.24% 2.23% 123 MEDICARE Contributions 1,161 372 406 406 416 10 2.38% 0.52% 0.52% 131 Health Insurance 6,228 2,502 2,602 2,602 2,249 (353) -13.58% 3.35% 2.82% 132 Dental Insurance 360 94 94 94 120 26 27.31% 0.12% 0.15% 133 Life Insurance 66 17 17 17 17 0 0.00% 0.02% 0.02% 135 HCSP Contributions 162 75 75 75 75 0 0.00% 0.10% 0.09% 151 Workers Comp-Insurance 281 330 136 136 172 36 26.55% 0.18% 0.22% 100 Severance Compensation Funding 345 136 140 140 144 4 2.78% 0.18% 0.18% 201 Office Supplies-General 67 6 234 234 250 16 6.84% 0.30% 0.31% 33 OQ PN08 F� City of Prior Lake Council Meeting 12.08.2014 2015 Proposed Budget Expenditure Details From Amended Budget.... 2014 2015 2014 2015 2012 2013 2014 2014 2015 $Change %Change %of %of %of %of YE Actual YE Actual Adopted Amended Proposed 14-16 14-15 Subtotal Subtotal Total Total 210 Operating Supplies-General 651 - 2,339 2,339 2,500 161 6.88% 3.01% 3.13% 224 Repair&Maint Sup-General 1,781 3,264 20,585 20,585 22,000 1,415 6.87% 26.53% 27.56% 313 Professional Services-Consultant 59 - 4,000 4,000 4,000 0 0.00% 5.16% 5.01% 321 Communications 819 695 705 705 754 49 6.95% 0.91% 0.94% 331 Training&Certification 560 - 2,120 2,120 2,120 0 0.00% 2.73% 2.66% 403 Repair&Maint Service-Parks 19,092 37,116 12,000 12,000 12,000 0 0.00% 15.47% 15.03% 433 Dues&Subscriptions 326 - 350 350 350 0 0.00% 0.45% 0.44% 125,118 75,326 77,594 77,594 79,824 2,230 2.87% 100.00% 100.00% 0.60% 0.64% Total Natural Resources 125,118 75,326 77,594 77,594 79,824 2,230 2.87% 100.00% 100.00% 0.60% 0.64% 49303 Transfers to other funds 3,124,227 1,200,070 1,091,943 1,091,943 1,035,845 (56,098) -5.14% 100.00% 100.00% 8.41% 8.24% 49999 Contingency reserve 123,863 (123,863) -100.00% n/a n/a 0.00% 0.00% GENERAL FUND TOTAL 13,646,012 12,273,536 12,985,255 13,267,637 12,563,945 (703,692) -5.30% 100.00% 100.00% 100.00% 100.00% DEBT SERVICE FUNDS 47000 Debt 4,800,287 4,375,840 4,279,864 4,279,864 4,256,609 (23,255) -0.54% 56.39% 100.00% 47000 Debt-refunding 10,136,121 770,000 3,310,017 3,310,017 - (3,310,017) -100.00% 43.61% 0.00% 14,936,408 5,145 840 7,589,881 7,589,881 4,256,609 (3,333,272) -43.92% 100.00% 100.00% 100.00% 100.00% DEBT SERVICE FUNDS TOTAL 14,936,408 5,145,840 7,589,881 7,589,881 4,256,609 (3,333,272) -43.92% 100.00% 100.00% 100.00% 100.00% CABLEFUND 41340 Public Cable Access 14,490 7,000 7,000 n/a n/a 100.00% 14,490 7,000 7,000 n/a n/a 100.00% n/a 100.00% CABLE FUND TOTAL - 14,490 - - 7,000 7,000 n/a n/a 100.00% n/a 100.00% REVOLVING EQUIPMENT FUND 42200 Fire 66,928 175 36,050 118,816 150,950 32,134 27.05% 4.97% 18.44% 42100 Police 35,804 90,963 53,216 53,216 115,600 62,384 117.23% 7.34% 14.12% 43050 Engineering - - 25,750 25,750 - (25,750) -100.00% 3.55% 0.00% 43100 Streets 263,255 56,780 207,957 207,957 310,500 102,543 49.31% 28.67% 37.93% 43400 Central Garage 5,464 19,160 72,165 72,165 20,000 (52,165) -72.29% 9.95% 2.44% 45200 Parks 259,255 104,935 93,833 93,833 108,000 14,167 15.10% 12.94% 13.19% 49420 Water Quality - - - - 73,500 73,500 n/a 0.00% 8.98% 49450 Sewer 48,997 236,385 236,385 40,000 (196,385) -83.08% 32.59% 4.89% 630,706 321,010 725,356 808,122 818,550 10,428 1.29% 100.00% 100.00% 100.00% 100.00% REVOLVING EQUIPMENT FUND TOTAL 630,706 321,010 725,356 808,122 818,550 10,428 1.29% 100.00% 100.00% 100.00% 100.00% 34 pQ PAtpP City of Prior Lake Council Meeting 12.08.2014 ~ 2015 Proposed Budget V m Expenditure Details From Amended Budget.... 2014 2015 2014 2015 2012 2013 2014 2014 2015 $Change %Change %of %of %of %of YE Actual YE Actual Adopted Amended Proposed 14-15 14-15 Subtotal Subtotal Total Total FACILITIES MANAGEMENT FUND 42200 Fire 62,500 - - 87,056 87,056 n/a 0.00% 2.51% 43000 Public Works 179,595 - 300,500 300,500 598,933 298,433 99.31% 80.91% 17.29% 45100 Recreation 9,506 69,612 35,448 35,448 55,562 20,115 56.74% 9.54% 1.60% 45500 Library 9,506 69,715 35,448 35,448 55,562 20,115 56.74% 9.54% 1.60% XXXXX GESP 2,667,924 2,667,924 n/a 0.00% 77.00% 261,107 139,327 371,395 371,395 3,465,037 3,093,642 832.98% 100.00% 100.00% 100.00% 97.71% 49303 Transfers to other funds 81,381 81,381 n/a n/a n/a 0.00% 2.29% FACILITIES MANAGEMENT FUND TOTAL 261,107 139,327 371,395 371,395 3,546,418 3,175,023 854.89% 100.00% 100.00% 100.00% 100.00% CAPITAL PARK FUND 45200 Parks 944,852 63,110 50,000 70,436 - (70,436) -100.00% 29.41% 0.00% xxxxx Rice Lake Park 120,000 120,000 50,000 (70,000) -58.33% 70.59% 100.00% 944,852 63,110 170,000 190,436 50,000 (140,436) -73.74% 100.00% 100.00% 100.00% 100.00% 49303 Transfers to other funds 33,750.00 0 n/a n/a n/a 0.00% 0.00% CAPITAL PARK FUND TOTAL 978,602 63,110 170,000 190,436 50,000 (140,436) -73.74% 100.00% 100.00% 100.00% 100.00% EDA SPECIAL REVENUE FUND 46500 Economic Development 101 Full Time Employees Regular 49,467 51,291 70,573 70,573 91,654 21,081 29.87% 43.38% 61.68% 115 EDA/Planning Commission 1,700 2,050 3,000 3,000 3,000 0 0.00% 1.84% 2.02% 121 PERA Contributions 3,654 3,728 5,177 5,177 6,934 1,758 33.95% 3.18% 4.67% 122 FICA Contributions 3,095 3,101 4,562 4,562 5,869 1,307 28.65% 2.80% 3.95% 123 MEDICARE Contributions 724 725 1,067 1,067 1,372 306 28.65% 0.66% 0.92% 131 Health Insurance 5,760 5,750 8,022 8,022 8,700 678 8.45% 4.93% 5.85% 132 Dental Insurance 240 240 334 334 425 91 27.14% 0.21% 0.29% 133 Life Insurance 44 34 49 49 63 14 29.63% 0.03% 0.04% 135 HCSP Contributions 44 150 195 195 240 45 23.08% 0.12% 0.16% 151 Workers Comp-Insurance 149 235 340 340 540 201 59.01% 0.21% 0.36% 100 Severance Compensation Funding 247 256 353 353 458 105 29.87% 0.22% 0.31% 201 Office Supplies - - 500 500 250 (250) -50.00% 0.31% 0.17% 304 Legal Fees 6,990 1,434 3,500 3,500 2,500 (1,000) -28.57% 2.15% 1.68% 314 Professional Services 85,528 1,409 40,000 28,000 22,000 (6,000) -21.43% 24.59% 14.81% 321 Communications - 1,235 - - 500 500 n/a 0.00% 0.34% 331 Training&Certification 3,750 1,009 3,500 3,500 2,000 (1,500) -42.86% 2.15% 1.35% 351 Legal Notice 517 375 500 500 500 0 0.00% 0.31% 0.34% 433 Dues&Subscriptions 995 395 1,000 1,000 1,000 0 0.00% 0.61% 0.67% 437 Misc Expense-General - 65 - - 590 590 n/a 0.00% 0.40% XXX SAC Deferral Loans issued 20,000 20,000 (20,000) -100.00% 12.29% 0.00% 162,904 73,482 162,670 162,670 148,595 (14,075) -8.65% 100.00% 100.00% 85.99% 78.79% 46503 Technology Village Incubator 201 Office Supplies 152 101 500 500 500 0 0.00% 1.89% 1.25% 321 Communications 1,765 666 2,500 2,500 5,000 2,500 100.00% 9.43% 12.50% 433 Dues&Subscriptions - 1,520 2,500 2,500 2,500 0 0.00% 9.43% 6.25% 437 Misc Expense-General - 2,500 2,500 2,500 0 0.00% 9.43% 6.25% XXX Property Taxes 1,500 1,500 - (1,500) -100.00% 5.66% 0.00% XXX Business Assistance 3,000 3,000 3,000 0 0.00% 11.32% 7.50% 35 OQ PRIp$ City of Prior Lake Council Meeting 12.08.2014 2015 Proposed Budget Expenditure Details From Amended Budget.... 2014 2015 2014 2015 2012 2013 2014 2014 2015 $Change %Change %of %of %of %of YE Actual YE Actual Adopted Amended Proposed 14-15 14-15 Subtotal Subtotal Total Total XXX Rent Subsidies 10,000 22,000 23,500 1,500 6.82% 37.74% 58.75% 560 Furniture&Fixtures 207 27,512 - - 1,500 1,500 n/a 0.00% 3.75% 580 General Equipment 7,966 337 4,000 4,000 1,500 (2,500) -62.50% 15.09% 3.75% 13,296 35,244 26,500 26,500 40,000 13,500 50.94% 100.00% 100.00% 14.01% 21.21% EDA SPECIAL REVENUE FUND TOTAL 176,200 108,726 189,170 189,170 188,595 (575) -0.30% 100.00% 100.00% 100.00% 100.00% WATER FUND 41520 Finance 101 Full Time Employees Regular 25,356 25,073 25,688 25,688 26,333 645 2.51% 30.17% 30.59% 102 Full Time Employees Overtime - - 500 500 1,000 500 100.00% 0.59% 1.16% 103 Part Time Employees-Regular 18,029 18,400 19,507 19,507 20,531 1,024 5.25% 22.91% 23.85% 121 PERA Contributions 3,145 3,152 3,277 3,277 3,515 238 7.28% 3.85% 4.08% 122 FICA Contributions 2,346 2,343 2,802 2,802 2,968 166 5.92% 3.29% 3.45% 123 MEDICARE Contributions 549 548 655 655 694 39 5.90% 0.77% 0.81% 131 Health Insurance 5,760 5,750 5,930 5,930 5,330 (600) -10.12% 6.96% 6.19% 132 Dental Insurance 240 240 240 240 240 0 0.00% 0.28% 0.28% 133 Life Insurance 37 29 29 29 29 0 0.00% 0.03% 0.03% 135 HCSP Contributions 180 180 180 180 180 0 0.00% 0.21% 0.21% 151 Workers Comp-Insurance 233 192 213 213 276 63 29.66% 0.25% 0.32% 100 Severance Compensation Funding 287 462 226 226 234 8 3.55% 0.27% 0.27% 201 Office Supplies 27 18 150 150 150 0 0.00% 0.18% 0.17% 203 Office Supplies-Printed Forms 732 1,097 140 140 140 (0) -0.25% 0.16% 0.16% 240 Small Tools&Equipment 170 - 750 750 750 0 0.00% 0.88% 0.87% 316 BankService Charges 3,799 3,608 5,375 5,375 4,625 (750) -13.95% 6.31% 5.37% 322 Communications-Postage 6,533 12,528 9,716 9,716 9,358 (358) -3.68% 11.41% 10.87% 331 Training&Certification 113 108 245 245 245 0 0.00% 0.29% 0.28% 350 Printing Services - 2,245 2,460 2,460 2,418 (42) -1.71% 2.89% 2.81% 404 Repair&Maint Service-Equip - - 50 50 50 0 0.00% 0.06% 0.06% 407 Software Service Contract 6,011 4,335 7,000 7,000 7,000 0 0.00% 8.22% 8.13% 433 Memberships - 25 25 25 25 0 0.00% 0.03% 0.03% 73,547 80,333 85,157 85,157 86,091 934 1.10% 100.00% 100.00% 2.77% 1.50% 49400 Water 101 Full Time Employees Regular 284,465 321,344 417,958 417,958 433,312 15,354 3.67% 19.67% 8.96% 102 Full Time Employees Overtime 22,910 20,149 23,000 23,000 23,000 0 0.00% 1.08% 0.48% 104 Temporary Employees Regular 12,210 15,288 38,810 38,810 38,810 0 0.00% 1.83% 0.80% 113 Sick Leave 1,531 7,239 3,371 3,371 2,299 (1,072) -31.80% 0.16% 0.05% 121 PERA Contributions 23,629 24,553 31,969 31,969 34,223 2,254 7.05% 1.50% 0.71% 122 FICA Contributions 20,313 22,251 29,955 29,955 30,840 885 2.96% 1.41% 0.64% 123 MEDICARE Contributions 4,751 5,204 7,006 7,006 7,213 207 2.96% 0.33% 0.15% 131 Health Insurance 36,664 44,156 65,150 65,150 52,872 (12,278) -18.85% 3.07% 1.09% 132 Dental Insurance 1,558 2,039 2,831 2,831 2,803 (29) -1.01% 0.13% 0.06% 133 Life Insurance 355 295 379 379 379 0 0.00% 0.02% 0.01% 135 Health Savings Plan 880 1,089 1,215 1,215 1,560 345 28.40% 0.06% 0.03% 151 Workers Comp-Insurance 8,244 8,551 12,364 12,364 13,921 1,558 12.60% 0.58% 0.29% 100 Severance Compensation Funding 15,008 (1,571) 2,090 2,090 2,167 77 3.67% 0.10% 0.04% 201 Office Supplies 1,375 1,534 936 936 936 0 0.00% 0.04% 0.02% 202 Office Supplies-Dup&Copy 850 308 496 496 496 0 0.02% 0.02% 0.01% 203 Office Supplies-Printed Forms 720 211 3,743 3,743 3,743 0 0.01% 0.18% 0.08% 210 Operating Supplies-General 4,761 2,871 3,322 3,322 3,322 0 0.00% 0.16% 0.07% 212 Operating Supplies-Fuel 11,796 14,560 12,720 12,720 13,340 620 4.87% 0.60% 0.28% 216 Operating Supplies-Chemicals 180,140 159,064 180,000 180,000 160,000 (20,000) -11.11% 8.47% 3.31% 36 pQ PRIp$ City of Prior Lake Council Meeting 12.08.2014 2015 Proposed Budget Expenditure Details From Amended Budget 2014 2015 2014 2015 2012 2013 2014 2014 2015 $Change %Change %of %of %of %of YE Actual YE Actual Adopted Amended Proposed 14-15 14-15 Subtotal Subtotal Total Total 217 Operating Supplies-Uniforms 3,365 2,896 2,246 2,246 2,246 0 0.00% 0.11% 0.05% 221 Repair&Maint Sup-Equipment 5,213 5,905 15,439 15,439 15,440 1 0.01% 0.73% 0.32% 223 Repair&Maint Sup-Bldgs 12,151 18,985 8,421 8,421 8,421 (0) 0.00% 0.40% 0.17% 224 Repair&Maint Sup-General 67,790 47,416 91,696 91,696 91,696 0 0.00% 4.31% 1.90% 240 Small Tools&Equipment 4,390 3,455 4,678 4,678 4,678 (0) -0.01% 0.22% 0.10% 241 Computer/Data Services 7,933 7,248 10,950 10,950 55,482 44,532 406.68% 0.52% 1.15% 260 Water Meters 66,574 123,045 277,118 277,118 277,117 (1) 0.00% 13.04% 5.73% 303 Professional Service-Engineering 59,251 28,267 25,000 25,000 25,000 0 0.00% 1.18% 0.52% 312 Professional Service-Water Samples 19,397 20,291 22,500 22,500 22,500 0 0.00% 1.06% 0.47% 314 Professional Services - 20,000 25,000 25,000 25,000 0 0.00% 1.18% 0.52% 321 Communications 26,022 26,436 20,887 20,887 21,425 538 2.58% 0.98% 0.44% 322 Communications-Postage 4,244 155 4,200 4,200 4,200 0 0.00% 0.20% 0.09% 325 Communications-Utility Locations 7,845 8,540 8,100 8,100 8,100 0 0.00% 0.38% 0.17% 331 Training&Certification 13,670 4,008 14,800 14,800 14,800 0 0.00% 0.70% 0.31% 363 Insurance-Auto 1,823 1,975 1,870 1,870 1,963 93 4.97% 0.09% 0.04% 381 Utilities-Electric 197,071 196,138 168,421 168,421 168,420 (1) 0.00% 7.92% 3.48% 383 Utilities-Gas 24,441 31,162 42,105 42,105 35,000 (7,105) -16.88% 1.98% 0.72% 384 Refuse Disposal - 2,617 - - 433 433 n/a 0.00% 0.01% 389 Contract Water - - - - 255,000 255,000 n/a 0.00% 5.27% 401 Repair&Maint Service-Bldg 42,630 37,206 15,920 15,920 15,920 0 0.00% 0.75% 0.33% 404 Repair&Maint Service-Equip 3,019 2,487 1,800 1,800 1,800 0 0.00% 0.08% 0.04% 406 Repair&Maint Service-Cleaning 11,541 12,468 20,186 20,186 15,420 (4,766) -23.61% 0.95% 0.32% 407 Software Service Contract 17,444 16,917 17,600 17,600 17,600 0 0.00% 0.83% 0.36% 412 Repair&Maint Service-General 76,495 53,769 114,400 114,400 114,400 0 0.00% 5.38% 2.36% 415 Rentals-Heavy Equipment 3,080 5,075 4,678 4,678 5,000 322 6.88% 0.22% 0.10% 433 Dues&Subscriptions 2,386 2,338 5,255 5,255 5,255 0 0.00% 0.25% 0.11% 530 Improvements 10,628 148,802 364,755 364,755 2,700,000 2,335,245 640.22% 17.16% 55.81% 580 General Equipment 100,000 100,000 n/a 0.00% 2.07% 1,984,384 2,108,217 2,125,339 2,125,339 4,837,551 2,712,212 127.61% 100.00% 100.00% 69.03% 84.45% 49303 Transfers to other funds 1,514,830 1,556,856 868,235 868,235 804,695 (63,540) -7.32% 100.00% 100.00% 28.20% 14.05% WATER FUND TOTAL 3,572,761 3,745,406 3,078,731 3,078,731 5,728,336 2,649,605 86.06% 100.00% 100.00% 100.00% 100.00% SEWER FUND 41520 Finance 101 Full Time Employees Regular 25,356 25,072 25,688 25,688 26,333 645 2.51% 30.17% 30.61% 102 Full Time Employees Overtime - - 500 500 1,000 500 100.00% 0.59% 1.16% 103 Part Time Employees-Regular 18,029 18,400 19,507 19,507 20,531 1,024 5.25% 22.91% 23.86% 121 PERA Contributions 3,145 3,152 3,277 3,277 3,515 238 7.28% 3.85% 4.09% 122 FICA Contributions 2,346 2,343 2,833 2,833 2,968 135 4.76% 3.33% 3.45% 123 MEDICARE Contributions 549 548 663 663 694 31 4.74% 0.78% 0.81% 131 Health Insurance 5,760 5,750 5,930 5,930 5,330 (600) -10.12% 6.96% 6.19% 132 Dental Insurance 240 240 240 240 240 0 0.00% 0.28% 0.28% 133 Life Insurance 37 29 29 29 29 0 0.00% 0.03% 0.03% 135 HCSP Contributions 180 180 180 180 180 0 0.00% 0.21% 0.21% 151 Workers Comp-Insurance 233 192 215 215 276 61 28.23% 0.25% 0.32% 100 Severance Compensation Funding 287 462 226 226 234 8 3.55% 0.27% 0.27% 201 Office Supplies 27 18 150 150 150 0 0.00% 0.18% 0.17% 203 Office Supplies-Printed Forms 732 1,097 140 140 140 (0) -0.25% 0.16% 0.16% 240 Small Tools&Equipment 170 - 750 750 750 0 0.00% 0.88% 0.87% 316 BankService Charges 3,799 3,608 5,375 5,375 4,625 (750) -13.95% 6.31% 5.38% 322 Communications-Postage 6,533 12,528 9,716 9,716 9,358 (358) -3.68% 11.41% 10.88% 331 Training&Certification 113 63 245 245 245 0 0.00% 0.29% 0.28% 37 oQ rAroA F� City of Prior Lake Council Meeting 12.08.2014 2015 Proposed Budget Expenditure Details From Amended Budget.. 2014 2015 2014 2015 2012 2013 2014 2014 2015 $Change %Change %of %of %,of %of YE Actual YE Actual Adopted Amended Proposed 14-15 14-15 Subtotal Subtotal Total Total 350 Printing Services - 2,245 2,460 2,460 2,418 (42) -1.71% 2.89% 2.81% 407 Software Service Contract 6,011 4,334 7,000 7,000 7,000 0 0.00% 8.22% 8.14% 433 Memberships 25 25 25 0 0.00% 0.03% 0.03% 73,547 80,261 85,148 85,148 86,041 893 1.05% 100.00% 100.00% 2.89% 2.59% 49450 Sewer 101 Full Time Employees Regular 307,291 313,202 371,111 371,111 379,742 8,631 2.33% 14.63% 12.73% 102 Full Time Employees Overtime 14,865 19,794 23,000 23,000 23,000 0 0.00% 0.91% 0.77% 103 Part Time Employees-Regular 75,419 52,200 54,351 54,351 33,372 (20,979) -38.60% 2.14% 1.12% 104 Temporary Employees Regular 5,712 8,899 7,920 7,920 7,920 0 0.00% 0.31% 0.27% 113 Sick Leave 398 2,265 1,281 1,281 57 (1,224) -95.55% 0.05% 0.00% 121 PERA Contributions 28,823 27,626 32,514 32,514 32,708 195 0.60% 1.28% 1.10% 122 FICA Contributions 23,712 23,701 28,375 28,375 27,534 (842) -2.97% 1.12% 0.92% 123 MEDICARE Contributions 5,546 5,543 6,636 6,636 6,439 (197) -2.97% 0.26% 0.22% 131 Health Insurance 44,468 50,082 57,129 57,129 49,778 (7,351) -12.87% 2.25% 1.67% 132 Dental Insurance 2,171 2,301 2,497 2,497 2,580 83 3.33% 0.10% 0.09% 133 Life Insurance 386 1,277 334 334 334 0 0.00% 0.01% 0.01% 135 Health Savings Plan 1,166 1,240 1,586 1,586 1,305 (281) -17.73% 0.06% 0.04% 151 Workers Comp-Insurance 20,041 17,520 19,497 19,497 23,709 4,212 21.60% 0.77% 0.79% 100 Severance Compensation Funding (18,938) 1,914 2,127 2,127 2,066 (62) -2.90% 0.08% 0.07% 201 Office Supplies 1,285 1,422 936 936 1,000 64 6.84% 0.04% 0.03% 203 Office Supplies-Printed Forms - - 2,433 2,433 2,600 167 6.88% 0.10% 0.09% 210 Operating Supplies-General 2,229 807 3,322 3,322 3,550 228 6.86% 0.13% 0.12% 212 Operating Supplies-Fuel 11,796 12,183 12,720 12,720 13,340 620 4.87% 0.50% 0.45% 217 Operating Supplies-Uniforms 3,047 2,048 2,526 2,526 2,700 174 6.88% 0.10% 0.09% 224 Repair&Maint Sup-General 44,804 25,638 78,596 78,596 84,000 5,404 6.88% 3.10% 2.81% 240 Small Tools&Equipment 3,935 1,346 5,146 5,146 5,500 354 6.88%, 0.20% 0.18% 241 Computer/Data Services 1,796 3,748 8,750 8,750 8,750 0 0.00% 0.34% 0.29% 303 Professional Service-Engineering 18,165 816 82,500 82,500 82,500 0 0.00% 3.25% 2.76% 321 Communications 13,158 12,549 15,339 15,339 16,394 1,055 6.88% 0.60% 0.55% 331 Training&Certification 14,512 2,160 13,000 13,000 13,000 0 0.00% 0.51% 0.44% 363 Insurance-Auto 1,823 1,975 1,870 1,870 1,963 93 4.97% 0.07% 0.07% 381 Utilities-Electric 35,154 35,956 38,363 38,363 38,300 (63) -0.16% 1.51% 1.28% 404 Repair&Maint Service-Equip 164 5,084 12,000 12,000 12,000 0 0.00% 0.47% 0.40% 407 Software Service Contract 4,364 3,754 4,100 4,100 4,100 0 0.00% 0.16% 0.14% 412 Repair&Maint Service-General 34,447 8,353 94,500 94,500 94,500 0 0.00% 3.73% 3.17% 415 Rentals-Heavy Equipment 4,079 5,109 4,678 4,678 4,678 0 0.00% 0.18% 0.16% 433 Dues&Subscriptions 94 - 685 685 685 0 0.00% 0.03% 0.02% 437 Misc Expense-General 20 - 500 500 500 0 0.00% 0.02% 0.02% 440 MCES Installment 1,197,812 1,195,487 1,215,970 1,215,970 1,228,533 12,563 1.03% 47.94% 41.17% 530 Improvements 8,585 50,095 330,000 330,000 675,000 345,000 104.55% 13.01% 22.62% 580 General Equipment 100,000 100,000 n/a 0.00% 3.35% 2,275,411 2,264,906 2,536,293 2,536,293 2,984,136 447,843 17.66% 100.00% 100.00% 85.98% 89.94% 49303 Transfers to other funds 508,907 355,268 328,446 328,446 247,760 (80,686) -24.57% 100.00% 100.00% 11.13% 7.47% SEWER FUND TOTAL 2,857,865 2,700,435 2,949,887 2,949,887 3,317,936 368,049 12.48% 100.00% 100.00% 100.00% 100.00% WATER QUALITY FUND 49420 Water Quality 101 Full Time Employees Regular 149,429 196,547 178,812 178,812 190,430 11,618 6.50% 24.06% 17.24% 104 Temporary Employees Regular 32,357 40,933 31,657 31,657 36,956 5,299 16.74% 4.26% 3.35% 38 pQ PRlpa City of Prior Lake Council Meeting 12.08.2014 —; 2015 Proposed Budget Expenditure Details From Amended Budget.... 2014 2015 2014 2015 2012 2013 2014 2014 2015 $Change %Change %of %of %of %of YE Actual YE Actual Adopted Amended Proposed 14-15 14-15 Subtotal Subtotal Total Total 121 PERA Contributions 11,048 14,704 12,964 12,964 14,282 1,318 10.17% 1.74% 1.29% 122 FICA Contributions 11,271 14,942 13,049 13,049 14,098 1,049 8.04% 1.76% 1.28% 123 MEDICARE Contributions 2,636 3,494 3,052 3,052 3,297 245 8.04% 0.41% 0.30% 131 Health Insurance 11,948 27,499 26,174 26,174 23,912 (2,263) -8.64% 3.52% 2.17% 132 Dental Insurance 702 1,215 1,102 1,102 1,123 21 1.94% 0.15% 0.10% 133 Life Insurance 135 166 145 145 145 0 0.00% 0.02% 0.01% 135 Health Savings Plan 88 381 555 555 555 0 0.00% 0.07% 0.05% 151 Workers Comp-Insurance 960 1,035 3,500 3,500 4,579 1,079 30.82% 0.47% 0.41% 100 Severance Compensation Funding 2,757 2,515 894 894 952 58 6.48% 0.12% 0.09% 201 Office Supplies 81 74 477 477 477 0 0.00% 0.06% 0.04% 203 Office Supplies-Printed Forms 195 - 1,871 1,871 1,872 1 0.04% 0.25% 0.17% 210 Operating Supplies-General 695 2,711 4,276 4,276 4,276 (0) 0.00% 0.58% 0.39% 212 Operating Supplies-Fuel - - 12,720 12,720 12,800 80 0.63% 1.71% 1.16% 224 Repair&Maint Sup-General 558 5,633 32,749 32,749 32,749 0 0.00% 4.41% 2.97% 241 Technology/Equipment - - 1,200 1,200 1,200 0 0.00% 0.16% 0.11% 314 Professional Service-General 60,912 107,628 102,025 102,025 102,025 0 0.00% 13.73% 9.24% 331 Training&Certification 298 956 1,500 1,500 1,500 0 0.00% 0.20% 0.14% 407 Software Service Contract - - 2,150 2,150 2,150 0 0.00% 0.29% 0.19% 412 Repair&Maint Service-General 11,500 52,183 96,332 96,332 96,332 0 0.00% 12.96% 8.72% 437 Misc Expense-General 2,591 574 1,000 1,000 1,000 0 0.00% 0.13% 0.09% 530 Improvements 9,305 - 215,000 215,000 557,588 342,588 159.34% 28.93% 50.49% 362,462 532,509 743,205 743,205 1,104,299 361,095 48.59% 100.00% 100.00% 97.25% 98.13% 49303 Transfers to other funds 440,382 207,000 21,000 21,000 21,000 0 0.00% 100.00% 100.00% 2.75% 1.87% WATER QUALITY FUND TOTAL 802,844 739,509 764,205 7649205 1,1259299 361,094 47.25% 100.00% 100.00% 100.00% 100.00% TRANSIT FUND 49804 Transit 201 Office Supplies 81 103 94 94 (94) -100.00% 0.01% n/a 203 Office Supplies-PrintedForms 2,610 1,058 5,146 5,146 (5,146) -100.00% 0.55% n/a 304 Legal Services 4,176 1,694 1,500 1,500 (1,500) -100.00% 0.16% n/a 314 Professional Service-General 29,552 27,063 25,000 25,000 (25,000) -100.00% 2.67% n/a 321 Communications 607 453 674 674 (674) -100.00% 0.07% n/a 331 Training&Certification 968 914 1,500 1,500 (1,500) -100.00% 0.16% n/a 412 Repair&Maint Service-General 9,333 - 5,000 5,000 (5,000) -100.00% 0.53% n/a 418 Facility Rental 38,799 39,964 90,000 90,000 (90,000) -100.00% 9.60% n/a 425 Transit Contract Service 621,818 608,866 757,675 757,675 (757,675) -100.00% 80.85% n/a 433 Dues&Subscriptions 500 515 560 560 (560) -100.00% 0.06% n/a 530 Improvements 32,310 50,000 50,000 (50,000) -100.00% 5.34% n/a 841,039 772,707 937,149 937,149 (937,149) -100.00% 100.00% n/a 100.00% n/a TRANSIT FUND TOTAL 841,039 772,707 937,149 937,149 - (937,149) -100.00% 100.00% n/a 100.00% n/a GRAND TOTAL-ALL BUDGETED FUNDS 38,703,543 26,024,095 29,761,028 30,146,612 31,602,688 1,456,076 4.83% 39