2014 Budget (PDF)

2014 APPROVED BUDGET CITY OF SUN PRAIRIE MISSION STATEMENT To provide valuable, responsive, and cost-effective services that enable residents to enjoy a high quality of life CITY OF SUN PRAIRIE VISION STATEMENT We want to coordinate the development of a modern community that understands and has pride in its roots to the past. We want to help develop “homes” for the residents that live here, through the creation and maintenance of neighborhoods. Each neighborhood will be equal in importance but separate in its identity. Our school system will play a major factor in the development of the neighborhoods and will serve as the community center. We want to help create harmony amongst all residents, where race and socio economic differences play no factor. We want everyone to feel that their personal safety is not at risk, whether they are at home or walking down the street. CITY OF SUN PRAIRIE DIRECTORY OF OFFICIALS 2013-2014 MAYOR John Murray COUNCIL PRESIDENT Mary Polenske COUNCIL MEMBERS District 1 – Russ Fassbender District 1 – Hariah Hutkowski District 2 – Jon Freund District 2 – Andrea Gage District 3 – Al Hoffman District 3 – Zach Weber District 4 – Kent Orfan District 4 – Mary Polenske ADMINISTRATION City Administrator Aaron Oppenheimer Director of Administrative Services vacant City Assessor Debbie Mason City Clerk Diane Hermann-Brown City Engineer Daryl Severson Director of Community Development Scott Kugler Sun Prairie Media Center Director Cameron Thompson Director of Building Inspection Dennis Allen Director of Public Works Larry Herman Director of Economic Development Neil Stechschulte EMS Director Kep Anderson Human Resources Director Brenda Sukenik Information Technology Director Randy Tyler Library Director Tracy Herold Police Chief Pat Anhalt WWTP Superintendent John Krug Sun Prairie Utilities Manager Rick Wicklund CITY OF SUN PRAIRIE 2014 APPROVED BUDGET TABLE OF CONTENTS TAB DESCRIPTION I Executive Summary Mayor’s Budget Message ..................................................................................... 1 Mayor’s Proposed Budget Initiatives .................................................................... 4 Approved Budget Amendments ............................................................................ 7 Resolutions and P ublic Notices ............................................................................ 8 Summary of Local Property Taxes ..................................................................... 12 City Fund List ...................................................................................................... 13 II Revenues and Expenditures Summary General Fund Revenues .................................................................................... 14 General Fund Expenditures ................................................................................ 20 Personnel Costs Summary ................................................................................. 23 III General Government Mayor ................................................................................................................. 24 City Counc il ........................................................................................................ 25 Municipal Court ................................................................................................... 26 City Attorney ....................................................................................................... 28 City Clerk and El ections ..................................................................................... 30 Administra tion ..................................................................................................... 34 Human Res ources .............................................................................................. 36 Finance and Risk Management .......................................................................... 38 Assessing ........................................................................................................... 42 Information Te chnology ..................................................................................... 44 Community Deve lopment ................................................................................... 47 Building Ma intenance ......................................................................................... 49 IV Public Safety Police Department .............................................................................................. 52 Fire Department .................................................................................................. 65 Emergency Medical Service ............................................................................... 66 Building Inspection ............................................................................................. 69 V Public Works Public Works Department ................................................................................... 71 Refuse and Recycling ......................................................................................... 80 Parks Maintenance ............................................................................................. 82 Forestry .............................................................................................................. 84 Engineering ........................................................................................................ 86 TAB DESCRIPTION VI Other General Funds Economic Development ...................................................................................... 88 Museum .............................................................................................................. 90 Librar y ................................................................................................................ 92 Senior s ............................................................................................................... 97 Youth and Family Commission ........................................................................... 98 Recreatio n .......................................................................................................... 99 Family Aquati c Center ...................................................................................... 105 VII Special Revenue Funds Special Revenue Fund Teen Court Program ................................................................................... 107 Police and Fire Programs ............................................................................ 107 Taxi Program ............................................................................................... 108 Library Programs ......................................................................................... 108 Museum Programs ...................................................................................... 109 Tourism Commission .................................................................................. 109 Transportation Impact Fee Fund ...................................................................... 110 Park Improvement Fund ................................................................................... 111 Wisconsin Development Fund .......................................................................... 114 Business Improvement District ......................................................................... 117 Community Development Authority .................................................................. 118 VIII Capital Projects Fund Overview .......................................................................................................... 119 Summary .......................................................................................................... 120 General Obligation Bo rrowing Summary .......................................................... 121 Tax Increment Financing Distr icts No. 8, 9 and 10 ........................................... 122 IX Debt Service Fund General Debt Service Budget ........................................................................... 125 Debt Service Requirements .............................................................................. 126 All Debt Service Funds ..................................................................................... 128 X Enterprise Funds Cable Access Te levision .................................................................................. 129 Water Pollution Control Facility ......................................................................... 133 Stormwater Utility ............................................................................................. 141 Sun Prairie Utilities Commission (Water and Light) .......................................... 146 1 2 3 City of Sun Prairie 2014 Budget Mayor's Proposed Budget Initiatives Revenues/ Operating Fund  Balance FTE Amount Expenditures  Tax Levy Administrative Services Assessor's Office Purchase four (4) table computers.  Allow employees to  enter assessing data in real time, extending inspection  season by two (2) weeks. ‐                      ‐         ‐                    4,000              4,000            Clerk's Office/Elections Replace election tab ulation machines.  Common Council  approved 1:1 match with Dane County funds. ‐                      ‐             ‐                    10,788            10,788          Information Technology Part‐time personnel classification for LTE position ‐              0.80    28,420       28,420        Administration Wage increase for nonunion employees. ‐                   ‐          120,130     120,130      Create Management Analyst position ‐                   1.0      60,543       60,543        Lead Program ‐                   ‐           ‐                   3,945             3,945          City Attorney's Office Westlaw subscription ‐                    ‐       ‐                   2,892             2,892          Community Development Building Maintenance 5‐year NFPA Fire Sprinkler Inspection ‐           ‐                   5,780             5,780          Create LTE Buildings and Grounds Maintenance position 0.480   11,841         11,841          Purchase software program to track routine  facility  maintenance activities ‐         ‐                    1,765              1,765            Replace roof on duplex on Bailey Road ‐           ‐                   6,800             6,800          Economic Development Economic Development Subscriptions increase 1,110             1,100          Increase in Communications for Smart Phone Use 1,600             1,600          Emergency Medical Service Ambulance Replacement 17,592        ‐       ‐                   165,000          147,408      LUCAS 2 Chest  Compression System ‐                    ‐       ‐                   27,933            27,933        Library Increase Secretary from .875 to FT ‐                   0.125 5,733         5,733          Increase three (3) Youth Library Assistant I positions from  .375 FTE to .475 FTE each ‐                     0.300   7,345           7,345            Increase Reference Librarian from .500 to .625 FTE 0.125 7,882         7,882          Police Department Create additional Sergeant position ‐                   1.00    103,512     103,512      Purchase seventeen (17) tactical vest carriers and ceramic  ballistic plates ‐                      ‐             ‐                    7,395              7,395            Personnel  Description 4 Increase base pay for seven (7) sergeants to eliminate pay  compression with Detectives ‐                      10,671         ‐                       10,671          Public Works Additional funding for snow removal contractor ‐                    ‐       ‐                   35,000            23,000        Rent mini‐front loader 244j to manage snow  accumulation ‐                      ‐         ‐                    10,000            10,000          Additional street maintenance funds ‐                    ‐       ‐                   100,000          30,000        Purchase three (3) laptops and wireless access points for  shop technicians to improve work flow and efficiency ‐                      ‐         ‐                    9,000              9,000            Purchase real ‐time GPS tracking for vehicles to replace  unreliable manual data downloads ‐                      ‐         ‐                    2,200              2,200            Portable signs and equipment to more efficiently direct  traffic and increase citizen safety during emergency  situations 6,000              6,000            Recreation Create Museum Assistant Curator position ‐                   0.23    3,800         3,800          Increase Piranha's swim team Head Coach salary ‐                   ‐       1,000         1,000          Wage increase for seasonal staff ‐       3,500         3,500          Increase recreation  fees to cover credit card fees 6,933          ‐       6,933             Fire Department Increase service through Sun Prairie Volunteer Fire  Department Inc. 225,000          225,000        GENERAL FUND TOTAL 24,525 $     4.06    364,377 $    633,141$       890,983 $    5 ADDITIONAL INITIATIVES ‐ SPECIAL FUNDS Revenues/ Operating Fund  Balance FTE Amount Expenditures TAX LEVY Sewer Utility Conduct phosphorous study to comply with WI DNR  permit ‐                      ‐         ‐                    40,000            ‐                      Complete Priority one (1) sewer repairs and continue  flow monitoring ‐                      ‐         ‐                    413,700          ‐                      Replace Jet/Vat truck used to clean sanitary sewer pipes ‐                      ‐         ‐                    335,000          ‐                      Replace sewer pipe on Bird Street from Lothe to Linnerd ‐                      ‐         ‐                     48,370            ‐                      Replace Supervisory Control and Data  Acquisition  Computer ‐                      ‐         ‐                    6,000              ‐                      Review sewer rates to ensure fee sustainability ‐                    ‐       ‐                   15,000            ‐                    Authorize two (2) seasonal staff positions ‐                   0.53    10,360       ‐                    Replace 2004 Ford F150 Pickup Truck ‐                    ‐       ‐                   23,000            ‐                    Purchase software to generate daily data reports ‐                    ‐       ‐                   6,000             ‐                    SP Media Center ‐                    Provide FT benefits to PT position ‐           1,864         ‐                    Description Personnel  6 Summary of Budget Adjustments/Changes to 2014  Budget Proposed/ Estimate Actual Difference General Fund ‐ expenses New Ambulance amount to be cash‐funded  changed 147,408$           142,844$             (4,564)$          LGPIF ‐ Property & Boilers Insurance projection  increased 32,731$             35,271$               2,540 $           Library Budget ‐ error in COLA for PT personnel 1,155,328$        1,159,892$         4,564 $           Continued Holiday on Income Continuation  Benefits ‐ PD 8,160$               ‐$                      (8,160)$          Planning Budget ‐ error in Principal Planner  salary/fringe 333,157$           317,268$             (15,889)$       Elimination of Mgnt Analyst 60,253$              ‐$                    (60,253)$      Amendment Increase Fire Budget ‐ turn out gear 3,000 $         Amendment Reduce EMS Professional Services ‐ no longer  required to pay Fire for call assists 63,000$             24,000$               (39,000)$       Amendment Increase Fire Budget projection for additional  coverage hours 39,000 $        Amendment Increase IT equipment ‐ use 3yr financing for  replacement of major equipment 63,000$               63,000 $         Delay hiring of new  Sergeant the remaining  amount to fund the Secretary's reinstatement 12,299$             (12,299)$       Reinstate the Police Records Secretary position  previously eliminated 43941 43,941 $         15,880 $       Subtotal ‐ expenses increased (reduced) General Fund ‐ Revenues Increase in Court Revenue projections due to  change in State Statutes and City Ordinance 126,000$           134,000$             8,000 $          Amendment SP Utilities funding for a portion of the Econ Dev  Dir salary was removed 10,000$             ‐$                      (10,000)$       Amendment Reduce revenue expected for borrowing for  Engineering services 332,800$           105,000$             (227,800)$     Amendment Increase projection for Recycling Fee ($44) 395,200$           404,580$             9,380 $           based on actual tax  roll Increase Refuse fee an additional $25 ($71 total) 441,800$           652,413$             210,613 $     Amendment based on  actual tax roll Increase projection for Ambulance Fees 760,000$           807,000$            47,000 $       Amendment Decrease projection for Ambulance Fees 807,000$           783,000$            (24,000)$      Amendment Increase projection for Township Ambulance Fees 53,000$             55,000$               2,000 $          Amendment Exempt Computer Aid ‐ final amount from State  was received 276,000$           283,833$             7,833 $           23,026 $       Subtotal ‐ revenues increased (reduced) Total from Above 7,146 $          Less amt to remain within expenditure restraint 7,146 $          Amount Property taxes reduced Original/ Other Funds ‐ expenses Estimate Actual Difference LGPIF ‐ Property & Boilers Insurance   SP UTILITIES 7,982$               9,350$                1,368 $            CATV 276$                    323$                    47 $                  STORMWATER 250$                    292$                    42 $                CIP Budget Increase ‐ Pony Lane Stormwater 300,000 $     Amendment   WASTEWATER ‐ LGPIF 9,200$               10,689$              1,489 $          Rate increase study not required for WWTP (15,000)$       Amendment 7 8 Projected Projected Property 2014 Beginning 2014 Ending Tax Levy FUND TYPE Fund Balance Revenues Expenditures Fund Balance Contribution GENERAL FUND 8,793,798$ 21,970,676$ 21,970,676$ 8,793,798$ 12,741,648$ SPECIAL REVENUE FUNDS Park Improvement Fund 864,814 108,500 130,200 843,114 - Media Center Fund 3,702 334,350 331,775 6,277 WDF-Revolving Loan Fund 70,112 13,243 - 83,355 - Special Revenue Fund 88,862 527,780 534,500 82,142 - Transportation Impact Fee Fund 1,590,055 106,850 50,000 1,646,905 - Library Trust Fund 60,000 50,000 50,000 60,000 - SPECIAL REVENUE FUNDS 2,677,545 1,140,723 1,096,475 2,721,793 - CAPITAL PROJECTS FUNDS Capital Projects - 5,184,100 5,184,100 - - TIF No. 8 387,492 1,761,083 1,657,582 490,993 - TIF No. 9 (768,367) 652,200 948,446 (1,064,613) - TIF No. 10 (2,785) 4,300 500 1,015 - Development Projects - 130,000 130,000 - - CAPITAL PROJECTS FUNDS (383,660) 7,731,683 7,920,628 (572,605) - DEBT SERVICE FUNDS Debt Service Fund 150,000 6,360,100 6,510,100 - 6,326,108 TIF No. 6 16,764 153,085 163,120 6,729 - TIF No. 7 1,979,779 948,017 567,976 2,359,820 - DEBT SERVICE FUNDS 2,146,543 7,461,202 7,241,196 2,366,549 6,326,108 ENTERPRISE FUNDS Water Pollution Control 9,309,959 3,949,500 2,652,316 10,607,143 - Stormwater Utility 2,020,584 1,539,660 1,531,333 2,028,911 - Water & Light 13,492,406 30,898,856 29,066,417 15,324,845 - ENTERPRISE FUNDS 24,822,949 36,388,016 33,250,066 27,960,899 - COMPONENT UNITS Business Improvement District 45,138 92,000 92,000 45,138 - Community Development Authority - 763,647 763,647 - - COMPONENT UNITS 45,138 855,647 855,647 45,138 - GRAND TOTALS 36,105,770$ 74,446,845$ 71,603,592$ 38,949,023$ 19,067,756$ TOTAL CITY PROPERTY TAX LEVY CONTRIBUTION 19,067,756$ ALL FUND TYPES 2014 RECOMMENDED BUDGET CITY OF SUN PRAIRIE 2014 APPROVED BUDGET SUMMARY 9 10 % CHANGE 2013 2013 2014 INCREASE REVENUES ESTIMATED BUDGET RECOMMENDED (DECREASE) Taxes (Other than Property) 1,660,400$ 1,659,900 $ 1,776,586 $ Special Assessments 20,000 22,000 20,000 Intergovernmental Revenues 3,796,826 3,777,801 3,693,938 Licenses & Permits 749,460 604,190 419,650 Fines, Forfeitures & Penalties 195,000 180,000 178,000 Public Charges for Services 1,636,248 1,717,528 2,142,233 Interest & Miscellaneous 541,459 439,759 471,275 Other Financing Sources 78,200 99,500 400,200 TOTAL REVENUES 8,677,593 8,500,678 9,101,882 7.07% EXPENDITURES General Government 4,102,566 4,278,744 4,528,050 Public Safety 8,675,875 8,676,658 9,475,962 Public Works 5,366,938 5,277,400 5,328,569 Culture, Recreation & Education 2,736,576 2,822,479 2,518,477 Transfers to Other Funds 104,500 113,200 119,618 Contingency Fund - 134,306 - TOTAL EXPENDITURES 20,986,455 21,302,787 21,970,676 3.14% Excess (Deficiency) of Revenues Over Expenditures (12,308,862) (12,802,109) (12,868,794) Surplus Funds Applied - 356,190 120,000 Local Property Taxes 12,475,499 12,475,499 12,748,794 2.19% NET SURPLUS (DEFICIT) 166,637 29,580 - Fund Balance-Beginning of Year 8,627,161 8,627,161 8,793,798 Fund Balance-End of Year (*Est.) 8,793,798$ 8,656,741$ 8,793,798$ CITY OF SUN PRAIRIE 2014 BUDGET DOCUMENT 2014 APPROVED BUDGET - GENERAL FUND 11 Summary of Local Property Taxes Apportioned Mill Apportioned Mill Taxing Entity Levy Rate Levy Rate State of Wisconsin 399,462 0.1657 401,977 0.1696 Dane County 6,806,305 2.9331 7,055,451 3.1149 City of Sun Prairie 19,074,902 8.2202 19,067,756 8.4182 Madison Area Technical College 4,113,018 1.7725 4,167,267 1.8398 SUB-TOTAL 13.0915 13.5424 Sun Prairie School District 28,893,946 12.4712 29,711,026 13.1369 Less:State School Credit 1.9299 1.9633 FINAL NET MILL RATE 59,287,633 23.6328 60,403,477 24.7160 2012/2013 2013/2014 State 0.69% County 12.60% City 34.06% MATC 7.44% SP School District 45.21% 2013-2014 Property Tax Distribution 12 GENERAL FUND SPECIAL REVENUE FUNDS GENERAL GOVERNMENT FUND # FUND 200 SPECIAL REVENUE FUND DEPT # DEPARTMENT 210 TRANSPORTATION IMPACT FEE FUND 110 MAYOR 240 REVOLVING LOAN FUND 115 COUNCIL 250 PARK FUND 120 MUNICIPAL COURT 130 CITY ATTORNEY 140 CITY CLERK COMPONENT UNITS 150 ADMINISTRATION 155 HUMAN RESOURCES FUND # FUND 160 FINANCE 810 BUSINESS IMPROVEMENT DISTRICT 165 RISK MANAGEMENT 850 COMMUNITY DEVELOPMENT AUTHORITY 170 ASSESSING 180 INFORMATION TECHNOLOGY 185 BUILDING MAINTENANCE 610 COMMUNITY DEVELOPMENT CAPITAL PROJECT FUNDS FUND # FUND PUBLIC SAFETY 400 CAPITAL PROJECTS FUND 490 DEVELOPMENT PROJECTS FUND DEPT # DEPARTMENT 508 TIF DISTRICT NO. 8 FUND 210 POLICE DEPARTMENT 509 TIF DISTRICT NO. 9 FUND 220 FIRE DEPARTMENT 510 TIF DISTRICT NO. 10 FUND 230 EMERGENCY MEDICAL SERVICE 240 BUILDING INSPECTION PUBLIC W ORKS DEBT SERVICE FUNDS FUND # FUND DEPT # DEPARTMENT 300 DEBT SERVICE FUND 310 PUBLIC WORKS 505 TIF DISTRICT NO. 5 FUND 320 REFUSE AND RECYCLING 506 TIF DISTRICT NO. 6 FUND 330 ENGINEERING 507 TIF DISTRICT NO. 7 FUND ADDITIONAL GENERAL FUNDS ENTERPRISE FUNDS FUND # FUND DEPT # DEPARTMENT 510 CABLE ACCESS TELEVISION 620 ECONOMIC DEVELOPMENT 610 WASTEWATER UTILITY 520 LIBARARY 650 STORMWATER UTILITY 530 MUSEUM 699 WATER & LIGHT UTILITY 541 SENIOR CITIZEN PROGRAM 542 YOUTH & FAMILIES 550 RECREATION 550 FAMILY AQUATIC CENTER 650 FORESTRY 13 CITY OF SUN PRAIRIE 2013 APPROVED BUDGET 2010 2011 2012 AMENDED PROPOSED APPROVED ACTUALS ACTUALS ACTUALS PROJECTED BUDGET BUDGET BUDGET TAXES (EXCLUDING LEVY) 142,953 142,953 120,318 120,400 119,900 120,400 120,400 SPECIAL ASSESSMENTS 21,142 21,142 27,860 20,000 22,000 20,000 20,000 LICENSES AND PERMITS 490,806 490,806 690,922 749,460 604,190 419,650 419,650 FINES,FORFEITS & PENALTIES 180,286 180,286 171,760 195,000 180,000 178,000 186,000 PUBLIC CHARGES FOR SERVICES 1,551,894 1,551,894 1,677,676 1,636,248 1,717,528 2,142,233 2,387,226 INVESTMENT INCOME 72,037 72,037 19,994 80,350 65,000 40,000 40,000 MISCELLANEOUS REVENUE 547,983 547,983 481,583 461,109 374,759 431,275 431,275 OTHER FINANCING SOURCES 1,485,602 1,485,602 2,704,654 1,618,200 1,639,500 2,056,386 1,818,586 LOCAL REVENUES 4,492,704 4,492,704 5,894,767 4,880,767 4,722,877 5,407,944 5,423,137 INTERGOVERNMENTAL REVENUE 3,887,472 3,887,472 3,997,087 3,796,826 3,777,801 3,693,938 3,701,771 TOTAL REVENUES 8,380,176 8,380,176 9,891,854 8,677,593 8,500,678 9,101,882 9,124,908 USE OF FUND BALANCE - - - 232,560 356,190 120,000 120,000 TOTAL REVENUE & FUND BALANCE 8,380,176 8,380,176 9,891,854 8,910,153 8,856,868 9,221,882 9,244,908 GENERAL PROPERTY TAX LEVY 12,447,883 12,447,883 12,247,373 12,475,499 12,475,499 12,748,794 12,741,648 TOTAL SOURCES 20,828,059 20,828,059 22,139,227 21,385,652 21,332,367 21,970,676 21,986,556 2014 GENERAL FUND REVENUES BY FUNCTION 2013 Property Taxes 58.5%Intergov'tal Payments 17.6% Local Revenues 16.9% Fund Balance 1.7% 2013 AMENDED BUDGET- FUNDING SOURCES BY MAJOR CATEGORY Property Taxes 58.0%Intergov'tal Payments 17.6% Local Revenues 16.9% Fund Balance 0.5% 2014 APPROVED BUDGET- FUNDING SOURCES BY MAJOR CATEGORY 14 CITY OF SUN PRAIRIE 2014 GENERAL FUND REVENUES ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 INCREASE/ DECREASE PROJECTED 2013 ADOPTED 2014 GENERAL PROPERTY TAXES 12,475,499 12,748,794GENERAL PROPERTY TAXES 12,475,49912,244,488 266,14910004000 401000 12,475,499 12,741,648 0 0OMITTED PROPERTY TAXES 02,885 010004000 402000 0 0 12,247,373 12,475,499 12,475,499 12,748,794 266,149SUB-TOTAL 12,475,499 12,741,648 OTHER TAXES 15,000 16,000PUBLIC ACCOMODATION TAX 14,81116,049 1,00010004100 414000 15,000 16,000 102,400 102,400PAYMENTS IN LIEU OF TAXES 95,377102,316 010004100 415000 102,400 102,400 2,500 2,000INTEREST AND PENALTY ON TAXES 9541,953 -50010004100 418000 2,500 2,000 120,319 111,142 119,900 120,400 500SUB-TOTAL 119,900 120,400 SPECIAL ASSESSMENTS 12,000 10,000INTEREST SPECIAL ASSESSMENTS 10,82414,422 -2,00010004200 428000 12,000 10,000 10,000 10,000DELQ SA HELD BY COUNTY 3,71513,438 010004200 429000 10,000 10,000 27,860 14,539 22,000 20,000 -2,000SUB-TOTAL 22,000 20,000 INTERGOVERNMENTAL REVENUE 682,025 680,372STATE SHARED REVENUE 682,940684,662 -1,65310004300 434100 682,025 680,372 606,515 584,773STATE EXPENDITURE RESTRAINT 606,516658,327 -21,74210004300 434200 606,515 584,773 209,155 276,000STATE AID - EXEMPT COMPUTERS 212,397161,448 74,67810004300 434300 209,155 283,833 83,000 83,000STATE FIRE INSURANCE TAX 81,46982,829 010004300 434400 83,000 83,000 10,000 8,000STATE GRANTS - POLICE 9,24210,344 -2,00010004300 435210 10,000 8,000 7,000 6,900STATE GRANTS - EMS 6,8697,210 -10010004300 435230 00071 7,000 6,900 1,549,772 1,414,867STATE AID - ROAD ALLOTMENT 1,548,8661,527,071 -134,90510004300 435310 1,549,772 1,414,867 53,645 54,034STATE AID - CONNECTING STREETS 53,64553,555 38910004300 435330 53,645 54,034 0 0STATE GRANTS - MULTIMODAL TRAN 013,294 010004300 435360 00122 0 0 39,141 47,000STATE GRANTS - RECYCLING 47,05646,986 7,85910004300 435450 39,141 47,000 402,848 399,292COUNTY AID - LIBRARY 403,285395,279 -3,55610004300 437520 402,848 399,292 134,700 139,700SCHOOL DISTRICT - PD LIASION 74,119133,165 5,00010004300 438210 134,700 139,700 0 0MISC.GRANTS 5,701222,917 010004300 438215 0 0 3,997,087 3,732,106 3,777,801 3,693,938 -76,030SUB-TOTAL 3,777,801 3,701,771 15 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 INCREASE/ DECREASE PROJECTED 2013 ADOPTED 2014 LICENSES AND PERMITS 23,000 25,000LIQUOR & MALT BEV. LICENSES 25,52623,026 2,00010004400 441100 23,000 25,000 8,000 8,600BARTENDER LICENSES 9,3528,660 60010004400 441150 8,000 8,600 890 800CIGARETTE LICENSES 800890 -9010004400 441200 890 800 6,000 6,000ELECTRICAL CONTRACTOR LICENSE 4,7706,290 010004400 441300 6,000 6,000 7,000 7,800OTHER BUSINESS LICENSES 8,2636,948 80010004400 441900 7,000 7,800 6,500 6,700DOG LICENSES 5,1416,735 20010004400 442200 6,500 6,700 95,000 130,000BUILDING PERMITS 144,726120,555 35,00010004400 443100 95,000 130,000 6,500 11,000OCCUPANCY PERMITS 12,92511,350 4,50010004400 443150 6,500 11,000 38,000 55,000PLUMBING PERMITS 67,30351,988 17,00010004400 443200 38,000 55,000 35,000 55,000ELECTRICAL PERMITS 71,46451,690 20,00010004400 443300 35,000 55,000 35,000 55,000HVAC PERMITS 69,29349,499 20,00010004400 443400 35,000 55,000 3,800 8,000STREET OPENING PERMITS 6,4505,250 4,20010004400 443500 3,800 8,000 7,500 12,000STORMWATER EROSION CONT FEE 31,58211,083 4,50010004400 443852 7,500 12,000 14,000 25,250ZONING AND PLAT APPROVAL FEES 13,24214,568 11,25010004400 444100 14,000 25,250 8,000 13,500OTHER PERMITS AND FEES 10,94810,114 5,50010004400 449300 8,000 13,500 378,645 481,783 294,190 419,650 125,460SUB-TOTAL 294,190 419,650 FINES, FOREFEITS AND PENALTIES 130,000 126,000COURT PENALTIES AND COSTS 114,833125,255 4,00010004500 451100 130,000 134,000 50,000 52,000PARKING VIOLATIONS 64,44846,505 2,00010004500 451300 50,000 52,000 171,760 179,281 180,000 178,000 6,000SUB-TOTAL 180,000 186,000 16 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 INCREASE/ DECREASE PROJECTED 2013 ADOPTED 2014 PUBLIC CHARGES FOR SERVICES 25,000 30,000CLERK FEES 43,57130,135 5,00010004600 461400 25,000 30,000 250 100INFORMATION TECHNOLOGY FEES 38203 -15010004600 461800 250 100 12,500 12,500POLICE DEPARTMENT FEES 13,87915,414 010004600 462100 12,500 12,500 0 0POLICE DEPARTMENT FEES 400 010004600 462100 00098 0 0 5,300 0POLICE LIFESKILLS FEES 5,7857,039 -5,30010004600 462102 5,300 0 350 330POLICE ANIMAL POUND FEES 360330 -2010004600 462105 350 330 783,000 760,000AMBULANCE FEES 602,273757,942 010004600 462300 783,000 783,000 55,000 53,000EMS TOWNSHIPS CHARGES 51,45159,408 010004600 462305 55,000 55,000 12,000 15,000BUILDING INSPECTION CHARGES 13,3609,915 3,00010004600 462400 12,000 15,000 1,450 5,000SEWER INSPECTION CHARGES 8,2241,020 3,55010004600 462405 1,450 5,000 6,000 8,000PUBLIC WORKS MISC CHARGES 11,9225,328 2,00010004600 463100 6,000 8,000 395,200 837,000RECYCLING CHARGES 405,809399,417 9,38010004600 463200 395,200 404,580 0 0REFUSE CHARGES 00 652,41310004600 463205 0 652,413 500 0APPLIANCE COLLECTION CHARGES 475458 -50010004600 463250 500 0 4,300 3,000ENGINEERING MISC CHARGES 2,6803,807 -1,30010004600 463300 4,300 3,000 7,000 4,000ENGINEERING REVIEW FEES 1,0843,410 -3,00010004600 463305 7,000 4,000 16,000 15,000PARKS MISCELLANEOUS CHARGES 14,73414,977 -1,00010004600 465500 16,000 15,000 4,500 0PARKS ADVERTISING FEES 07,825 -4,50010004600 465501 4,500 0 107,460 114,393SUMMER RECREATION FEES 127,84182,376 6,93310004600 465503 127,957 114,393 46,660 46,660WINTER RECREATION FEES 42,44746,950 010004600 465504 46,660 46,660 0 0PLANNING MISC CHARGES 0400 010004600 466100 0 0 1,446,353 1,345,973 1,482,470 1,903,983 666,506SUB-TOTAL 1,502,967 2,148,976 INVESTMENT INCOME 64,650 40,000INVESTMENT INCOME 33,28919,711 -24,65010004700 471000 64,650 40,000 19,711 33,289 64,650 40,000 -24,650SUB-TOTAL 64,650 40,000 17 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 INCREASE/ DECREASE PROJECTED 2013 ADOPTED 2014 MISCELLANEOUS REVENUE 24,000 26,000MISCELLANEOUS RENTS 22,95929,768 2,00010004800 482100 24,000 26,000 60,000 60,000SALE OF MATERIAL AND EQUIPMENT 61,20547,086 010004800 483200 60,000 60,000 35,000 35,000SALE OF MATERIAL AND EQUIPMENT 40,75038,852 010004800 483200 00101 35,000 35,000 25,000 50,000INSURANCE DIVIDEND & RECOVERY 17,990101,389 25,00010004800 484000 25,000 50,000 5,000 10,000INSURANCE DIVIDEND & RECOVERY 7,8327,416 5,00010004800 484000 31001 5,000 10,000 0 0DONATIONS - GENERAL 1,9001,604 010004800 485000 0 0 0 0DONATIONS - GENERAL 100 010004800 485000 81519 0 0 0 0DONATIONS - POLICE 044 010004800 485210 0 0 0 0DONATIONS - PARKS & RECREATION 300100 010004800 485550 0 0 1,000 1,000DONATIONS - CONCERTS IN THE PA 1,6351,314 010004800 485552 1,000 1,000 10,639 11,177PAYMENT FROM CATV 9,7520 53810004800 488510 10,639 11,177 71,067 73,098PAYMENT FROM WWTP UTILITY 65,14571,114 2,03110004800 488810 71,067 73,098 82,768 110,000PAYMENT FROM STORMWATER UTILT 75,87181,997 27,23210004800 488850 82,768 110,000 46,285 55,000MISCELLANEOUS REVENUES 97,84777,404 8,71510004800 489000 46,285 55,000 0 0AG USE PENANLTIES 15,6045,508 010004800 489200 0 0 463,596 418,799 360,759 431,275 70,516SUB-TOTAL 360,759 431,275 18 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 INCREASE/ DECREASE PROJECTED 2013 ADOPTED 2014 OTHER FINANCING SOURCES 0 2,500CITY ATTORNEY CHARGEBACKS 071 2,50010004900 481300 0 2,500 3,000 5,000HUMAN RESOURCES CHARGEBAKCS 03,000 2,00010004900 481550 3,000 5,000 2,000 2,000FINANCE CHARGEBACKS 01,700 010004900 481600 2,000 2,000 30,000 15,000FLEET LABOR CHARGEBACKS 15,71512,612 -15,00010004900 483110 30,000 15,000 35,000 332,800ENGINEERING CHARGEBACKS 14,23519,339 70,00010004900 483300 35,000 105,000 0 0ENGINEERING CHARGEBACKS 05,267 010004900 483300 00049 0 0 0 0ENGINEERING CHARGEBACKS 030,862 010004900 483300 00103 0 0 0 0ENGINEERING CHARGEBACKS 07,054 010004900 483300 00123 0 0 0 0ENGINEERING CHARGEBACKS 010,499 010004900 483300 00125 0 0 0 0ENGINEERING CHARGEBACKS 02,910 010004900 483300 00126 0 0 0 0ENGINEERING CHARGEBACKS 050,667 010004900 483300 00128 0 0 0 0ENGINEERING CHARGEBACKS 031,550 010004900 483300 00129 0 0 0 0ENGINEERING CHARGEBACKS 034,152 010004900 483300 00130 0 0 0 0ENGINEERING CHARGEBACKS 05,216 010004900 483300 00133 0 0 6,000 36,000TRANSFER IN 8,781825,854 20,00010004900 492100 6,000 26,000 1,540,000 1,656,186TRANSFER IN - W&L PILOT 01,571,507 116,18610004900 492199 1,540,000 1,656,186 356,190 120,000FUND BALANCE APPLIED 00 -236,19010004900 499000 356,190 120,000 2,612,259 38,731 1,972,190 2,169,486 -40,504SUB-TOTAL 1,972,190 1,931,686 FAC FUND CHARGES FOR SERVICES 235,058 238,250FAMILY AQUATIC CENTER FEES 186,080231,322 3,19225504600 465502 186,063 238,250 231,322 186,080 235,058 238,250 3,192SUB-TOTAL 186,063 238,250 FAC FUND MISC REVENUE 0 0MISCELLANEOUS REVENUES 2360 025504800 489000 0 0 0 236 0 0 0SUB-TOTAL 0 0 FAC FUND OTHER FINANCE SOURCES 6,900 6,900TRANSFER IN 046,198 025504900 492100 6,900 6,900 46,198 0 6,900 6,900 0SUB-TOTAL 6,900 6,900 21,762,482 19,017,459 20,991,417 21,970,676 995,139FUND TOTAL: 20,962,919 21,986,556 19 2011 2012 ACTUAL ACTUAL PROJECTED AMENDED RECOMMENDED APPROVED EXPENDITURES EXPENDITURES EXPENDITURES BUDGET BUDGET BUDGET General Government 4,421,550 4,114,561 4,102,566 4,278,744 4,528,050 4,345,183 Public Safety 8,547,107 8,464,082 8,675,875 8,676,658 9,475,962 9,497,880 Public Works 5,415,348 5,208,347 5,366,938 5,277,400 5,328,569 5,328,569 Other General Funds 3,080,585 2,776,602 2,736,576 2,822,479 2,518,477 2,523,041 21,464,590 20,563,592 20,881,955 21,055,281 21,851,058 21,694,673 Contingency/Fund Balance - - - - - 172,265 Transfers 94,971 113,850 104,500 113,200 119,618 119,618 Total General Expenses 21,559,561 20,677,442 20,986,455 21,168,481 21,970,676 21,986,556 2013 2014 GENERAL FUND EXPENDITURE SUMMARY 2014 APPROVED BUDGET General Government 20% Public Safety 41% Public Works 25% Other General Funds 13% Contingency/ Transfers 1% 2012 AMENDED BUDGET GENERAL FUND EXPENDITURES BY FUNCTION General Government 20% Public Safety 43% Public Works 21% Other General Funds 12% Contingency / Transfers 1% 2013 APPROVED BUDGET GENERAL FUND EXPENDITURES BY FUNCTION 20 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET SUMMARY OF GENERAL FUND EXPENDITURES ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 INCREASE/ DECREASE ADOPTED 2014 GENERAL GOVERNMENT MAYOR 37,916 40,795 40,683 38,514 39,230 39,230 716 CITY COUNCIL 67,554 62,013 71,473 70,234 70,234 70,234 0 MUNICIPAL COURT 94,362 91,185 96,568 96,281 97,504 97,504 1,223 CITY ATTORNEY 188,374 272,280 232,708 216,746 212,362 212,362 -4,384 CITY CLERK AND ELECTIONS 348,718 225,787 277,094 268,255 343,948 343,948 75,693 ADMINISTRATION 204,587 229,918 248,899 245,924 262,754 262,754 16,830 HUMAN RESOURCES 261,460 242,900 262,223 257,398 262,405 262,405 5,007 FINANCE 472,872 406,826 435,086 439,117 459,652 459,652 20,535 RISK MANAGEMENT 314,304 342,006 324,731 341,881 341,881 344,421 2,540 ASSESSING 322,770 331,257 361,549 367,712 330,926 330,926 -36,786 INFORMATION TECHNOLOGY 896,018 859,841 897,919 1,042,872 1,043,328 1,106,328 63,456 SUBTOTAL: $3,208,935 $3,104,808 $3,248,933 $3,384,934 $3,464,224 $3,529,764 $144,830 COMMUNITY DEVELOPMENT BUILDING MAINTENANCE 584,487 401,198 494,247 554,229 479,610 479,610 -74,619 PLANNING 321,143 310,118 340,162 351,600 335,809 335,809 -15,791 SUBTOTAL: $905,630 $711,316 $834,409 $905,829 $815,419 $815,419 $-90,410 PUBLIC SAFETY POLICE DEPARTMENT 6,275,894 5,940,617 6,398,758 6,514,663 6,846,380 6,878,022 363,359 FIRE DEPARTMENT 376,550 391,147 404,925 406,456 631,456 673,456 267,000 EMERGENCY MEDICAL SERVICES 1,469,786 1,291,629 1,409,337 1,429,026 1,629,165 1,590,165 161,139 BUILDING INSPECTION 341,847 327,943 357,464 347,161 356,237 356,237 9,076 SUBTOTAL: $8,464,077 $7,951,336 $8,570,484 $8,697,306 $9,463,238 $9,497,880 $800,574 PUBLIC WORKS PUBLIC WORKS DEPARTMENT 2,761,610 2,807,095 2,945,928 2,755,384 2,724,444 2,724,444 -30,940 REFUSE & RECYCLING 1,292,842 1,251,543 1,339,990 1,339,785 1,400,125 1,400,125 60,340 PARK & REC PARKS MAINTENANCE 550,061 532,051 559,232 580,828 588,633 588,633 7,805 FORESTRY 43,736 41,847 46,469 45,885 46,823 46,823 938 21 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 INCREASE/ DECREASE ADOPTED 2014 ENGINEERING 560,127 453,422 528,236 573,518 568,544 568,544 -4,974 SUBTOTAL: $5,208,376 $5,085,958 $5,419,855 $5,295,400 $5,328,569 $5,328,569 $33,169 TRANSFERS & CONTINGENCY TRANSFERS 111,920 114,700 113,200 113,200 119,618 119,618 6,418 PERSONNEL CONTINGENCY 1,930 3,017 17 6,393 15,000 15,000 8,607 GENERAL CONTINGENCY 0 0 0 0 157,265 157,265 157,265 SUBTOTAL: $113,850 $117,717 $113,217 $119,593 $291,883 $291,883 $172,290 Others ECONOMIC DEVELOPMENT 129,126 93,305 104,775 150,473 114,898 114,898 -35,575 LIBRARY 1,492,401 1,390,909 1,541,701 1,541,377 1,587,601 1,587,601 46,224 HISTORICAL MUSEUM 30,418 26,645 31,908 31,654 32,682 32,682 1,028 SENIOR CITIZENS PROGRAM 155,000 155,000 155,000 155,000 160,000 160,000 5,000 YOUTH & FAMILIES COMMISSION 1,975 1,758 2,500 2,500 2,500 2,500 0 RECREATION PROGRAMS 340,836 337,631 360,769 367,128 379,752 379,752 12,624 SUBTOTAL: $2,149,755 $2,005,248 $2,196,653 $2,248,132 $2,277,433 $2,277,433 $29,301 Others FAC FUND EXPENSES 300,876 228,414 224,073 241,958 245,608 245,608 3,650 SUBTOTAL: $300,876 $228,414 $224,073 $241,958 $245,608 $245,608 $3,650 20,607,624 1,093,40421,886,37420,893,15219,204,79620,351,499 21,986,556FUND TOTAL: 22 2013 FTE 2014 FTE Change 2013 2014 Change MAYOR & COUNCIL * * * 77,514 77,514 - MUNICIPAL COURT 1.0 1.0 - 86,231 87,454 1,223 CITY ATTORNEY 2.0 2.0 - 202,571 195,295 (7,276) CITY CLERK & ELECTIONS 3.0 3.0 - 233,015 287,600 54,585 ADMINISTRATION 2.0 2.0 - 209,124 218,585 9,461 HUMAN RESOURCES 2.5 2.5 - 219,758 224,734 4,976 FINANCE 4.5 4.5 - 368,683 386,547 17,864 ASSESSING 4.5 4.25 (0.25) 299,137 291,857 (7,280) INFORMATION TECHNOLOGY 4.0 4.8 0.8 381,032 415,724 34,692 COMMUNITY DEVELOPMENT 4.0 3.75 (0.25) 317,850 317,173 (677) BUILDING MAINTENANCE 1.0 1.48 0.48 59,447 72,565 13,118 POLICE DEPARTMENT 71.8 72.8 1.0 5,806,421 6,141,354 334,933 EMERGENCY MEDICAL SERVICE 14.5 14.5 - 1,478,668 1,522,096 43,429 BUILDING INSPECTION 3.9 3.9 - 325,784 333,619 7,835 PUBLIC WORKS & REFUSE 14.5 14.5 - 1,011,702 1,024,771 13,069 PARKS & FORESTRY 6.5 6.5 - 518,603 496,183 (22,420) ENGINEERING 6.50 6.25 (0.25) 557,598 551,132 (6,466) ECONOMIC DEVELOPMENT 1.5 1.0 (0.5) 134,273 99,441 (34,832) MUSEUM * * * 7,224 11,027 3,803 LIBRARY 22.7 23.8 1.1 1,118,452 1,152,712 34,260 YOUTH AND FAMILIES * * * 1,750 1,750 - RECREATION PROGRAMS 3.0 3.0 - 271,105 279,932 8,827 FAMILY AQUATIC CENTER * * * 153,175 156,173 2,998 TOTAL: GENERAL FUND 173.4 175.5 2.1 13,839,116 14,345,239 506,123 CABLE ACCESS TELEVISION 4.7 4.7 - 254,340 261,782 7,442 WASTEWATER UTILITY 10.0 10.0 - 749,054 771,451 22,397 STORMWATER UTILITY 4.0 4.0 - 251,570 255,373 3,803 TOTAL ALL FUNDS* 192.0 194.1 2.1 15,094,080 15,633,844 539,765 * EXCLUDING SUN PRAIRIE WATER & LIGHT UTILITIES CITY OF SUN PRAIRIE 2014 APPROVED BUDGET PERSONNEL COSTS DEPARTMENT STAFFING SALARIES, WAGES & BENEFITS 23 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET INCREASE/ DECREASE ADOPTED 2014 MAYOR PERSONNEL SERVICES 20,000 20,000REGULAR WAGES 20,00020,00010011000 511000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 0SUB-TOTAL 20,000 FRINGE BENEFITS 1,530 1,530SOCIAL SECURITY 1,530 1,53010011000 521000 1,530 1,530 1,530 1,530 1,530 1,530 1,530 0SUB-TOTAL 1,530 MATERIALS AND SUPPLIES 300 300OFFICE SUPPLIES 549 47010011000 531000 449 300 470 549 449 300 300 0SUB-TOTAL 300 CONTRACTUAL SERVICES 1,200 1,200COMMUNICATIONS 1,112 -10310011000 541000 1,200 1,200 -103 1,112 1,200 1,200 1,200 0SUB-TOTAL 1,200 PROFESSIONAL DEVELOPMENT 700 500MEETINGS AND TRAINING 170 1,10610011000 563000 400 500 11,100 11,950DUES AND MEMBERSHIPS 11,827 11,02010011000 564000 11,827 11,950 3,684 3,750SERVICE AWARDS 4,723 3,89310011000 565500 4,623 3,750 00PUBLICATIONS AND SUBSCRIPTION 55 010011000 566000 55 0 16,019 16,774 16,905 15,484 16,200 716SUB-TOTAL 16,200 CAPITAL PROJECTS 00OFFICE FURNITURE & EQUIPMENT 599 010011000 588000 599 0 0 599 599 0 0 0SUB-TOTAL 0 $37,916 $40,564 $38,514 $39,230 $716TOTAL MAYOR $40,683 $39,230 24 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET INCREASE/ DECREASE ADOPTED 2014 CITY COUNCIL PERSONNEL SERVICES 52,000 52,000REGULAR WAGES 51,49854,36810011500 511000 52,000 52,000 54,368 51,498 52,000 52,000 52,000 0SUB-TOTAL 52,000 FRINGE BENEFITS 3,984 3,984SOCIAL SECURITY 3,939 4,19110011500 521000 3,984 3,984 4,191 3,939 3,984 3,984 3,984 0SUB-TOTAL 3,984 MATERIALS AND SUPPLIES 750 750OFFICE SUPPLIES 612 7210011500 531000 750 750 00OPERATING SUPPLIES 530 88210011500 532000 530 0 953 1,142 1,280 750 750 0SUB-TOTAL 750 CONTRACTUAL SERVICES 12,000 12,000COMMUNICATIONS 4,223 5,05910011500 541000 12,000 12,000 00PROFESSIONAL SERVICES 528 010011500 544000 0 0 5,059 4,751 12,000 12,000 12,000 0SUB-TOTAL 12,000 PROFESSIONAL DEVELOPMENT 00MILEAGE 0 7710011500 562000 0 0 1,500 1,500MEETINGS AND TRAINING 85 2,79510011500 563000 1,500 1,500 00DUES AND MEMBERSHIPS 0 11010011500 564000 110 0 2,982 85 1,610 1,500 1,500 0SUB-TOTAL 1,500 CAPITAL ITEMS 00MACHINERY & EQUIPMENT EXPENS 599010011500 581000 599 0 0 599 599 0 0 0SUB-TOTAL 0 $67,554 $62,013 $70,234 $70,234 $0TOTAL CITY COUNCIL $71,473 $70,234 25 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET INCREASE/ DECREASE ADOPTED 2014 MUNICIPAL COURT PERSONNEL SERVICES 64,195 64,772REGULAR WAGES 61,30363,88310012000 511000 64,195 64,772 800 800OVERTIME 9010012000 513000 300 800 63,883 61,312 64,495 64,995 65,572 577SUB-TOTAL 65,572 FRINGE BENEFITS 4,700 4,815SOCIAL SECURITY 4,533 4,74410012000 521000 4,700 4,815 2,213 2,249RETIREMENT 2,033 2,19310012000 522000 2,213 2,249 12,991 13,486HEALTH INSURANCE 12,449 12,38410012000 523000 12,991 13,486 115 115LIFE INSURANCE 109 11410012000 524000 115 115 1,217 1,217DENTAL INSURANCE 1,166 1,15810012000 525000 1,217 1,217 20,594 20,290 21,236 21,236 21,882 646SUB-TOTAL 21,882 CONTRACTUAL SERVICES 1,000 1,000COMMUNICATIONS 1,281 1,23610012000 541000 1,100 1,000 3,000 3,000PROFESSIONAL SERVICES 1,075 2,07210012000 544000 2,500 3,000 6,000 6,000CONTRACTUAL SERVICES 6,000 6,00010012000 544400 6,000 6,000 9,307 8,356 9,600 10,000 10,000 0SUB-TOTAL 10,000 PROFESSIONAL DEVELOPMENT 50 50MILEAGE 156 27910012000 562000 200 50 00MEETINGS AND TRAINING 971 16010012000 563000 937 0 00DUES AND MEMBERSHIPS 100 14010012000 564000 100 0 579 1,227 1,237 50 50 0SUB-TOTAL 50 $94,362 $91,185 $96,281 $97,504 $1,223TOTAL MUNICIPAL COURT $96,568 $97,504 26 MUNICIPAL COURT 2013 FTE 2014 FTE Change 2013 2014 Change Municipal Judge elected elected - 30,693 30,693 - Court Clerk 1.0 1.0 - 54,738 55,961 1,223 Overtime - - - 800 800 - TOTAL 1.0 1.0 - 86,231 87,454 1,223 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET PERSONNEL COSTS Position Title STAFFING SALARIES, WAGES & BENEFITS 27 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET INCREASE/ DECREASE ADOPTED 2014 CITY ATTORNEY PERSONNEL SERVICES 152,688 145,304REGULAR WAGES 71,10252,25710013000 511000 75,000 145,304 52,257 71,102 75,000 152,688 145,304 -7,384SUB-TOTAL 145,304 FRINGE BENEFITS 11,591 10,992SOCIAL SECURITY 5,328 3,95610013000 521000 5,800 10,992 9,467 9,009RETIREMENT 4,086 3,24010013000 522000 3,900 9,009 25,982 26,972HEALTH INSURANCE 15,156 12,38410013000 523000 15,000 26,972 409 584LIFE INSURANCE 156 15810013000 524000 170 584 2,434 2,434DENTAL INSURANCE 1,419 1,15810013000 525000 1,400 2,434 20,897 26,146 26,270 49,883 49,991 108SUB-TOTAL 49,991 MATERIALS AND SUPPLIES 500 500OFFICE SUPPLIES 721 89010013000 531000 650 500 890 721 650 500 500 0SUB-TOTAL 500 CONTRACTUAL SERVICES 3,000 3,000COMMUNICATIONS 1,255 1,39010013000 541000 1,400 3,000 1,500 1,500PROFESSIONAL SERVICES 1,189 1,65810013000 544000 1,600 1,500 00PROFESSIONAL SERVICES 60 010013000 544000 0 0 3,700 3,700OUTSIDE LEGAL COUNSEL 147,003 97,77510013000 544450 103,000 3,700 00OUTSIDE LEGAL COUNSEL 4,857 1,16910013000 544450 5,000 0 2,000 2,000COLLECTION FEES 2,326 1010013000 544460 2,400 2,000 00CLAIM SETTLEMENTS 15,562 11,78910013000 544700 15,563 0 113,790 172,252 128,963 10,200 10,200 0SUB-TOTAL 10,200 PROFESSIONAL DEVELOPMENT 125 125MILEAGE 0 010013000 562000 125 125 1,050 1,050MEETINGS AND TRAINING 124 7910013000 563000 500 1,050 650 650DUES AND MEMBERSHIPS 410 010013000 564000 650 650 1,650 4,542PUBLICATIONS AND SUBSCRIPTION 1,52546010013000 566000 550 4,542 539 2,059 1,825 3,475 6,367 2,892SUB-TOTAL 6,367 $188,374 $272,280 $216,746 $212,362 $-4,384TOTAL CITY ATTORNEY $232,708 $212,362 28 CITY ATTORNEY'S OFFICE 2013 FTE 2014 FTE Change 2013 2014 Change Asst. Administrator/Legal Dir. 1.0 1.0 - 128,240 119,121 (9,119) Legal Secretary 1.0 1.0 - 74,331 76,174 1,843 Overtime - - - - - - TOTAL 2.0 2.0 - 202,571 195,295 (7,276) CITY OF SUN PRAIRIE 2014 APPROVED BUDGET PERSONNEL COSTS Position Title STAFFING SALARIES, WAGES & BENEFITS 29 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET INCREASE/ DECREASE ADOPTED 2014 CITY CLERK PERSONNEL SERVICES 156,179 153,766REGULAR WAGES 132,411158,15110014014 511000 156,179 153,766 150 500OVERTIME 3931,07810014014 513000 500 500 3,120 2,000BOARDS AND COMMITTEES 1,8101,75010014014 514000 2,000 2,000 160,980 134,615 158,679 159,449 156,266 -3,183SUB-TOTAL 156,266 FRINGE BENEFITS 11,136 11,373SOCIAL SECURITY 9,611 11,57110014014 521000 11,136 11,373 9,685 9,536RETIREMENT 7,210 9,65710014014 522000 9,685 9,536 31,010 32,194HEALTH INSURANCE 20,061 29,76210014014 523000 31,010 32,194 475 487LIFE INSURANCE 454 47210014014 524000 475 487 2,860 2,860DENTAL INSURANCE 1,929 2,74110014014 525000 2,860 2,860 00UNEMPLOYMENT COMPENSATION 0 110014014 526000 0 0 00POST EMPLOYMENT HEALTH PLAN 8,114 010014014 528000 8,115 0 54,204 47,378 63,281 55,166 56,450 1,284SUB-TOTAL 56,450 MATERIALS AND SUPPLIES 1,000 1,000OFFICE SUPPLIES 456 89810014014 531000 800 1,000 898 456 800 1,000 1,000 0SUB-TOTAL 1,000 CONTRACTUAL SERVICES 4,500 4,500COMMUNICATIONS 3,712 7,28110014014 541000 4,500 4,500 6,500 6,500ADVERTISING AND PRINTING 6,575 5,78310014014 543000 6,500 6,500 00PROFESSIONAL SERVICES 4,878 69010014014 544000 4,878 0 3,400 3,400BACKGROUND CHECKS 3,619 2,82110014014 544100 3,400 3,400 6,000 6,000CONTRACTUAL SERVICES 3,124 2,05510014014 544400 3,000 6,000 18,630 21,907 22,278 20,400 20,400 0SUB-TOTAL 20,400 30 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET INCREASE/ DECREASE ADOPTED 2014 PROFESSIONAL DEVELOPMENT 200 200MILEAGE 1941210014014 562000 200 200 1,800 4,000MEETINGS AND TRAINING 2,48370110014014 563000 2,484 4,000 240 260DUES AND MEMBERSHIPS 2859010014014 564000 285 260 00PUBLICATIONS AND SUBSCRIPTION 65010014014 566000 65 0 804 3,027 3,034 2,240 4,460 2,220SUB-TOTAL 4,460 $235,516 $207,383 $238,255 $238,576 $321TOTAL CITY CLERK $248,072 $238,576 31 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET INCREASE/ DECREASE ADOPTED 2014 ELECTIONS PERSONNEL SERVICES 18,000 73,784REGULAR WAGES 11,74785,67810014015 511000 16,000 73,784 300 1,000OVERTIME 01,02410014015 513000 300 1,000 86,702 11,747 16,300 18,300 74,784 56,484SUB-TOTAL 74,784 FRINGE BENEFITS 100 100SOCIAL SECURITY 0 77410014015 521000 100 100 774 0 100 100 100 0SUB-TOTAL 100 MATERIALS AND SUPPLIES 400 2,000OFFICE SUPPLIES 1,392 67210014015 531000 1,800 2,000 3,200 9,220OPERATING SUPPLIES 2,523 14,11710014015 532000 3,200 9,220 5,000 1,400MAINTENANCE AGREEMENTS 1,450 010014015 533100 5,000 1,400 14,789 5,366 10,000 8,600 12,620 4,020SUB-TOTAL 12,620 CONTRACTUAL SERVICES 1,800 6,000COMMUNICATIONS 940 8,64210014015 541000 1,700 6,000 1,000 1,000ADVERTISING AND PRINTING 310 2,21810014015 543000 800 1,000 10,860 1,250 2,500 2,800 7,000 4,200SUB-TOTAL 7,000 PROFESSIONAL DEVELOPMENT 200 200MILEAGE 20 10110014015 562000 100 200 0 100MEETINGS AND TRAINING 22 -2410014015 563000 22 100 77 42 122 200 300 100SUB-TOTAL 300 CAPITAL ITEMS 0 10,568MINOR CAPITAL 0 010014015 581100 0 10,568 0 0 0 0 10,568 10,568SUB-TOTAL 10,568 $113,202 $18,404 $30,000 $105,372 $75,372TOTAL ELECTIONS $29,022 $105,372 32 CITY CLERK'S OFFICE 2013 FTE 2014 FTE Change 2013 2014 Change City Clerk 1.0 1.0 - 88,829 90,419 1,590 Deputy Clerk 1.0 1.0 - 66,486 68,500 2,014 Secretary 1.0 1.0 - 56,018 51,297 (4,721) Overtime - - - 162 500 338 Boards & Committees - - - 3,120 2,000 (1,120) Election Officials - - - 18,100 73,884 55,784 Overtime - - - 300 1,000 700 TOTAL 3.0 3.0 - 233,015 287,600 54,585 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET PERSONNEL COSTS Position Title STAFFING SALARIES, WAGES & BENEFITS 33 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET INCREASE/ DECREASE ADOPTED 2014 ADMINISTRATION PERSONNEL SERVICES 165,913 174,498REGULAR WAGES 152,622140,08910015000 511000 165,913 174,498 00OVERTIME 029910015000 513000 0 0 140,388 152,622 165,913 165,913 174,498 8,585SUB-TOTAL 174,498 FRINGE BENEFITS 12,660 13,064SOCIAL SECURITY 11,851 10,69710015000 521000 12,660 13,064 10,287 10,176RETIREMENT 9,096 4,31310015000 522000 10,287 10,176 18,019 18,708HEALTH INSURANCE 17,533 4,77610015000 523000 18,019 18,708 602 536LIFE INSURANCE 474 38910015000 524000 602 536 1,643 1,643DENTAL INSURANCE 1,599 40610015000 525000 1,643 1,643 20,581 40,553 43,211 43,211 44,127 916SUB-TOTAL 44,127 MATERIALS AND SUPPLIES 1,000 700OFFICE SUPPLIES 386 44110015000 531000 600 700 500 500REPAIRS AND MAINTENANCE 1,011 53410015000 533000 1,011 500 975 1,396 1,611 1,500 1,200 -300SUB-TOTAL 1,200 CONTRACTUAL SERVICES 3,500 3,500COMMUNICATIONS 2,069 8,26210015000 541000 3,500 3,500 5,000 5,000ADVERTISING AND PRINTING 3,740 9,09010015000 543000 5,000 5,000 24,000 24,000PROFESSIONAL SERVICES 23,205 24,60710015000 544000 24,000 24,000 41,959 29,014 32,500 32,500 32,500 0SUB-TOTAL 32,500 PROFESSIONAL DEVELOPMENT 0 250MILEAGE 246 010015000 562000 300 250 1,500 6,445MEETINGS AND TRAINING 3,396 33810015000 563000 3,000 6,445 1,300 3,109DUES AND MEMBERSHIPS 1,525 10010015000 564000 1,414 3,109 0 500IN-HOUSE TRAINING 0 010015000 565000 0 500 0 125PUBLICATIONS AND SUBSCRIPTION 1,15324610015000 566000 950 125 684 6,320 5,664 2,800 10,429 7,629SUB-TOTAL 10,429 6,393 15,000CONTINGENCY 3,017 1,93010015000 581200 17 15,000 1,930 3,017 17 6,393 15,000 8,607SUB-TOTAL 15,000 $206,517 $232,923 $252,317 $277,754 $25,437TOTAL ADMINISTRATION $248,916 $277,754 34 ADMINISTRATION 2013 FTE 2014 FTE Change 2013 2014 Change City Administrator 1.0 1.0 - 139,675 147,566 7,891 Administrative Assistant 1.0 1.0 - 69,449 71,019 1,570 TOTAL 2.0 2.0 - 209,124 218,585 9,461 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET PERSONNEL COSTS Position Title STAFFING SALARIES, WAGES & BENEFITS 35 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET INCREASE/ DECREASE ADOPTED 2014 HUMAN RESOURCES PERSONNEL SERVICES 161,646 164,920REGULAR WAGES 148,662159,28010015500 511000 161,646 164,920 00OVERTIME 16822710015500 513000 0 0 159,507 148,830 161,646 161,646 164,920 3,274SUB-TOTAL 164,920 FRINGE BENEFITS 11,916 12,242SOCIAL SECURITY 11,068 11,96010015500 521000 11,916 12,242 10,024 10,226RETIREMENT 9,187 9,87510015500 522000 10,024 10,226 32,477 33,715HEALTH INSURANCE 30,858 30,96010015500 523000 32,477 33,715 653 620LIFE INSURANCE 607 52910015500 524000 653 620 3,042 3,042DENTAL INSURANCE 2,889 2,89610015500 525000 3,042 3,042 56,221 54,609 58,112 58,112 59,845 1,733SUB-TOTAL 59,845 MATERIALS AND SUPPLIES 800 800OFFICE SUPPLIES 853 40310015500 531000 800 800 403 853 800 800 800 0SUB-TOTAL 800 CONTRACTUAL SERVICES 1,800 1,800COMMUNICATIONS 682 78810015500 541000 1,000 1,800 12,000 12,000ADVERTISING AND PRINTING 17,388 5,95710015500 543000 17,000 12,000 10,458 10,458PROFESSIONAL SERVICES 6,961 7,06210015500 544000 10,000 10,458 8,400 8,400RECRUITMENT AND HIRING 12,118 29,52810015500 544600 12,000 8,400 43,335 37,149 40,000 32,658 32,658 0SUB-TOTAL 32,658 PROFESSIONAL DEVELOPMENT 600 600MEETINGS AND TRAINING 380 38510015500 563000 400 600 465 465DUES AND MEMBERSHIPS 499 46910015500 564000 465 465 2,000 2,000IN-HOUSE TRAINING 113 5410015500 565000 300 2,000 1,117 1,117PUBLICATIONS AND SUBSCRIPTION 4671,08510015500 566000 500 1,117 1,994 1,459 1,665 4,182 4,182 0SUB-TOTAL 4,182 $261,460 $242,900 $257,398 $262,405 $5,007TOTAL HUMAN RESOURCES $262,223 $262,405 36 HUMAN RESOURCES 2013 FTE 2014 FTE Change 2013 2014 Change Human Resources Director 1.0 1.0 - 106,331 108,577 2,246 Employee Benefits Coordinator 1.0 1.0 - 80,313 82,214 1,901 Confidential Secretary 0.5 0.5 - 33,114 33,943 829 TOTAL 2.5 2.5 - 219,758 224,734 4,976 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET PERSONNEL COSTS Position Title STAFFING SALARIES, WAGES & BENEFITS 37 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET INCREASE/ DECREASE ADOPTED 2014 FINANCE PERSONNEL SERVICES 270,251 282,031REGULAR WAGES 228,060264,28310016000 511000 270,251 282,031 00SEASONAL WAGES 3,266010016000 519000 3,500 0 264,283 231,327 273,751 270,251 282,031 11,780SUB-TOTAL 282,031 FRINGE BENEFITS 19,994 21,250SOCIAL SECURITY 17,307 19,75710016000 521000 19,994 21,250 16,696 17,427RETIREMENT 13,689 16,32710016000 522000 16,696 17,427 58,460 60,687HEALTH INSURANCE 51,151 55,72810016000 523000 53,060 60,687 824 820LIFE INSURANCE 754 75010016000 524000 700 820 5,477 5,477DENTAL INSURANCE 4,789 5,21310016000 525000 4,977 5,477 97,774 87,690 95,427 101,451 105,661 4,210SUB-TOTAL 105,661 MATERIALS AND SUPPLIES 3,055 3,055OFFICE SUPPLIES 1,601 1,63910016000 531000 2,500 3,055 3,700 3,700BANK SERVICE CHARGES 2,415 3,41010016000 532500 3,500 3,700 39,500 42,000MAINTENANCE AGREEMENTS 39,542 37,43310016000 533100 39,600 42,000 42,482 43,558 45,600 46,255 48,755 2,500SUB-TOTAL 48,755 CONTRACTUAL SERVICES 10,060 11,000COMMUNICATIONS 7,691 9,48810016000 541000 10,060 11,000 1,000 1,000ADVERTISING AND PRINTING 239 010016000 543000 700 1,000 42,900 44,000PROFESSIONAL SERVICES 34,004 36,98810016000 544000 42,900 44,000 46,476 41,933 53,660 53,960 56,000 2,040SUB-TOTAL 56,000 PROFESSIONAL DEVELOPMENT 200 200MILEAGE 225 19110016000 562000 200 200 2,600 2,600MEETINGS AND TRAINING 1,250 2,57710016000 563000 2,000 2,600 645 650DUES AND MEMBERSHIPS 670 58010016000 564000 670 650 150 150PUBLICATIONS AND SUBSCRIPTION 0 2710016000 566000 0 150 3,375 2,145 2,870 3,595 3,600 5SUB-TOTAL 3,600 38 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET INCREASE/ DECREASE ADOPTED 2014 CAPITAL ITEMS 00MACHINERY & EQUIPMENT EXPENS 0-15010016000 581000 0 0 0 157,265CONTINGENCY 0 010016000 581200 0 157,265 -150 0 0 0 157,265 157,265SUB-TOTAL 157,265 Others -36,395 -36,395VACANCY & TURNOVER SAVINGS 0 010016000 519900 -36,395 -36,395 00BAD DEBT EXPENSE 173 18,63210016000 574000 173 0 18,632 173 -36,222 -36,395 -36,395 0SUB-TOTAL -36,395 $472,872 $406,826 $439,117 $616,917 $177,800TOTAL FINANCE $435,086 $616,917 39 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET ACTUAL ACTUAL PROJECTED BUDGET RECOMMENDED ADOPTED INCREASE/ RISK MANAGEMENT PROFESSIONAL DEVELOPMENT 2012 2013 YTD 2013 2013 2014 2014 DECREASE 10016500 562000 MILEAGE 98 0 0 150 150 150 INSURANCE SUB-TOTAL 98 0 0 150 150 150 0 10016500 551000 WORKERS' COMPENSATION COVER 213,343 236,491 210,000 210,000 210,000 210,000 10016500 551200 10016500 552000 10016500 552100 10016500 553000 10016500 553100 10016500 554000 WORKERS' COMP SAFETY AWARD PROPERTY COVERAGE PROPERTY COVERAGE PAYMENTS LIABILITY COVERAGE LIABILITY COVERAGE PAYMENTS VEHICLE COVERAGE 1,208 24,747 9,664 47,136 44 18,064 764 30,049 2,940 46,212 9,404 16,147 1,000 32,731 3,000 48,000 10,000 20,000 1,000 1,000 32,731 32,731 5,000 5,000 48,000 48,000 25,000 25,000 20,000 20,000 1,000 35,271 5,000 48,000 25,000 20,000 SUB-TOTAL 314,206 342,006 324,731 341,731 341,731 344,271 2,540 TOTAL RISK MANAGEMENT $314,304 $342,006 $324,731 $341,881 $341,881 $344,421 $2,540 ACTUAL ACTUAL PROJECTED BUDGET RECOMMENDED ADOPTED INCREASE/ TRANSFERS 2012 2013 YTD 2013 2013 2014 2014 DECREASE Others 10069000 572000 TRANSFER OUT 111,920 114,700 113,200 113,200 119,618 119,618 SUB-TOTAL 111,920 114,700 113,200 113,200 119,618 119,618 6,418 TOTAL TRANSFERS $111,920 $114,700 $113,200 $113,200 $119,618 $119,618 $6,418 40 FINANCE DEPARTMENT 2013 FTE 2014 FTE Change 2013 2014 Change Director of Administrative Services 1.0 1.0 - 106,402 118,939 12,537 Accounting Manager 1.0 1.0 - 87,044 89,140 2,096 Accountant I 1.0 1.0 - 69,539 71,238 1,699 Account Clerk 1.0 1.0 - 71,500 73,283 1,783 Confidential Secretary 0.5 0.5 - 33,118 33,947 829 Overtime/Holiday/Seasonal 1,080 - (1,080) TOTAL 4.5 4.5 - 368,683 386,547 17,864 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET PERSONNEL COSTS Position Title STAFFING SALARIES, WAGES & BENEFITS 41 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET INCREASE/ DECREASE ADOPTED 2014 ASSESSING PERSONNEL SERVICES 220,289 215,601REGULAR WAGES 200,210217,61110017000 511000 220,224 215,601 1,200 1,200OVERTIME 045110017000 513000 600 1,200 218,062 200,210 220,824 221,489 216,801 -4,688SUB-TOTAL 216,801 FRINGE BENEFITS 16,622 16,289SOCIAL SECURITY 14,996 16,43710017000 521000 16,467 16,289 12,379 12,059RETIREMENT 11,181 12,26910017000 522000 12,261 12,059 44,001 42,308HEALTH INSURANCE 41,084 41,94510017000 523000 44,001 42,308 569 732LIFE INSURANCE 481 44310017000 524000 569 732 4,077 3,772DENTAL INSURANCE 3,804 3,88110017000 525000 4,077 3,772 74,975 71,546 77,375 77,648 75,160 -2,488SUB-TOTAL 75,160 MATERIALS AND SUPPLIES 1,200 1,200OFFICE SUPPLIES 424 94410017000 531000 1,000 1,200 9,350 6,610MAINTENANCE AGREEMENTS 6,378 5,71010017000 533100 8,000 6,610 6,654 6,803 9,000 10,550 7,810 -2,740SUB-TOTAL 7,810 CONTRACTUAL SERVICES 6,500 4,100COMMUNICATIONS 4,169 3,28110017000 541000 6,500 4,100 1,700 550ADVERTISING AND PRINTING 898 31410017000 543000 1,500 550 45,000 16,900PROFESSIONAL SERVICES 43,994 14,80710017000 544000 42,000 16,900 18,402 49,062 50,000 53,200 21,550 -31,650SUB-TOTAL 21,550 PROFESSIONAL DEVELOPMENT 500 500MILEAGE 0 6210017000 562000 250 500 2,500 3,780MEETINGS AND TRAINING 2,480 2,49410017000 563000 2,500 3,780 425 425DUES AND MEMBERSHIPS 200 20010017000 564000 200 425 1,400 900PUBLICATIONS AND SUBSCRIPTION 9571,92210017000 566000 1,400 900 4,678 3,637 4,350 4,825 5,605 780SUB-TOTAL 5,605 0 4,000MINOR CAPITAL 0 010017000 581100 0 4,000 0 0 0 0 4,000 4,000SUB-TOTAL 4,000 $322,770 $331,257 $367,712 $330,926 $-36,786TOTAL ASSESSING $361,549 $330,926 42 ASSESSOR'S OFFICE 2013 FTE 2014 FTE Change 2013 2014 Change City Assessor 1.00 1.00 - 92,883 95,006 2,123 Appraiser 2.00 2.00 - 127,804 130,827 3,023 Secretary 1.00 0.75 (0.25) 54,892 41,998 (12,894) PT Appraiser 0.50 0.50 - 22,266 22,734 468 Overtime 1,292 1,292 - TOTAL 4.50 4.25 (0.25) 299,137 291,857 (7,280) CITY OF SUN PRAIRIE 2014 APPROVED BUDGET PERSONNEL COSTS Position Title STAFFING SALARIES, WAGES & BENEFITS 43 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET INCREASE/ DECREASE ADOPTED 2014 INFORMATION TECHNOLOGY PERSONNEL SERVICES 274,204 304,303REGULAR WAGES 251,991271,85610018000 511000 274,204 304,303 800 800MISCELLANEOUS COMPENSATION 48059210018000 517000 800 800 18,579 3,579SEASONAL WAGES 24,21214,27810018000 519000 22,000 3,579 286,726 276,682 297,004 293,583 308,682 15,099SUB-TOTAL 308,682 FRINGE BENEFITS 21,843 24,281SOCIAL SECURITY 20,648 21,59610018000 521000 21,843 24,281 17,002 18,930RETIREMENT 15,623 16,85510018000 522000 17,002 18,930 44,001 59,166HEALTH INSURANCE 42,166 41,94510018000 523000 44,001 59,166 526 599LIFE INSURANCE 444 39010018000 524000 526 599 4,077 5,294DENTAL INSURANCE 3,905 3,88110018000 525000 4,077 5,294 84,667 82,787 87,449 87,449 108,270 20,821SUB-TOTAL 108,270 MATERIALS AND SUPPLIES 00OFFICE SUPPLIES 74 15410018000 531000 150 0 31,525 31,525OPERATING SUPPLIES 28,636 32,94610018000 532000 31,525 31,525 182,705 178,805MAINTENANCE AGREEMENTS 156,407157,82110018000 533100 170,000 178,805 190,922 185,116 201,675 214,230 210,330 -3,900SUB-TOTAL 210,330 CONTRACTUAL SERVICES 71,340 78,600COMMUNICATIONS 63,528 73,52410018000 541000 71,340 78,600 17,700 17,700PROFESSIONAL SERVICES 5,091 7,95810018000 544000 17,700 17,700 81,481 68,618 89,040 89,040 96,300 7,260SUB-TOTAL 96,300 PROFESSIONAL DEVELOPMENT 800 1,000MILEAGE 1,020 58710018000 562000 800 1,000 10,100 10,600MEETINGS AND TRAINING 3,599 10,37010018000 563000 10,100 10,600 800 800DUES AND MEMBERSHIPS 150 15010018000 564000 150 800 300 300PUBLICATIONS AND SUBSCRIPTION 19 28810018000 566000 300 300 11,395 4,788 11,350 12,000 12,700 700SUB-TOTAL 12,700 CAPITAL ITEMS 00MACHINERY & EQUIPMENT EXPENS 2,500010018000 581000 2,500 0 0 2,500 2,500 0 0 0SUB-TOTAL 0 44 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET INCREASE/ DECREASE ADOPTED 2014 CAPITAL PROJECTS 346,570 307,046OFFICE FURNITURE & EQUIPMENT 233,630240,82610018000 588000 208,901 370,046 240,826 233,630 208,901 346,570 307,046 23,476SUB-TOTAL 370,046 $896,018 $854,122 $1,042,872 $1,043,328 $63,456TOTAL INFORMATION TECHNOLOGY $897,919 $1,106,328 45 INFORMATION TECHNOLOGY 2013 FTE 2014 FTE Change 2013 2014 Change Information Technology Director 1.0 1.0 - 120,787 123,285 2,498 GIS Coordinator 1.0 1.0 - 86,638 88,692 2,054 Database Administrator 1.0 1.0 - 85,123 87,175 2,052 IT Support Specialist 1.0 1.0 - 67,621 69,137 1,516 IT Support Specialist - 0.8 0.8 42,721 42,721 Overtime/Temporary/Seasonal - - - 20,863 4,714 (16,149) TOTAL 4.0 4.8 0.8 381,032 415,724 34,692 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET PERSONNEL COSTS Position Title STAFFING SALARIES, WAGES & BENEFITS 46 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET INCREASE/ DECREASE ADOPTED 2014 COMMUNITY DEVELOPMENT PERSONNEL SERVICES 250,552 249,298REGULAR WAGES 227,168247,75910061000 511000 249,588 249,298 00OVERTIME 03010061000 513000 0 0 1,500 1,500BOARDS AND COMMITTEES 1,1201,52010061000 514000 1,500 1,500 249,309 228,288 251,088 252,052 250,798 -1,254SUB-TOTAL 250,798 FRINGE BENEFITS 18,980 18,961SOCIAL SECURITY 17,372 18,96310061000 521000 18,980 18,961 15,536 15,459RETIREMENT 14,085 15,04810061000 522000 15,536 15,459 31,010 28,823HEALTH INSURANCE 28,634 29,56110061000 523000 29,394 28,823 712 671LIFE INSURANCE 648 68210061000 524000 712 671 2,860 2,556DENTAL INSURANCE 2,638 2,72310061000 525000 2,860 2,556 66,976 63,378 67,482 69,098 66,470 -2,628SUB-TOTAL 66,470 MATERIALS AND SUPPLIES 400 200OFFICE SUPPLIES 106 42110061000 531000 400 200 421 106 400 400 200 -200SUB-TOTAL 200 CONTRACTUAL SERVICES 3,000 8,726COMMUNICATIONS 1,397 1,87110061000 541000 3,000 8,726 22,000 5,000PROFESSIONAL SERVICES 12,459 010061000 544000 13,000 5,000 1,871 13,855 16,000 25,000 13,726 -11,274SUB-TOTAL 13,726 PROFESSIONAL DEVELOPMENT 100 100MILEAGE 53 010061000 562000 100 100 2,300 2,300MEETINGS AND TRAINING 2,764 1,31910061000 563000 2,442 2,300 1,150 1,215DUES AND MEMBERSHIPS 894 1,01010061000 564000 1,150 1,215 1,500 1,000PUBLICATIONS AND SUBSCRIPTION 780 23610061000 566000 1,500 1,000 2,565 4,491 5,192 5,050 4,615 -435SUB-TOTAL 4,615 $321,143 $310,118 $351,600 $335,809 $-15,791TOTAL &200'(9 $340,162 $335,809 47 COMMUNITY DEVELOPMENT DEPARTMENT 2013 FTE 2014 FTE Change 2013 2014 Change Director 1.0 1.0 - 115,139 122,712 7,573 Principal Planner 1.0 1.0 - 68,111 71,027 2,916 Assisant Planner 1.0 1.0 - 78,097 79,843 1,746 Secretary 1.0 0.75 (0.3) 55,003 42,091 (12,912) Boards & Committees - - - 1,500 1,500 - TOTAL 4.0 3.8 (0.3) 317,850 317,173 (677) CITY OF SUN PRAIRIE 2014 APPROVED BUDGET PERSONNEL COSTS Position Title STAFFING SALARIES, WAGES & BENEFITS 48 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET INCREASE/ DECREASE ADOPTED 2014 BUILDING MAINTENANCE PERSONNEL SERVICES 38,367 49,996REGULAR WAGES 33,36438,14110018500 511000 38,367 38,996 1,500 1,500OVERTIME 059010018500 513000 0 1,500 00SEASONAL WAGES 384010018500 519000 0 11,000 38,731 33,748 38,367 39,867 51,496 11,629SUB-TOTAL 51,496 FRINGE BENEFITS 2,872 3,728SOCIAL SECURITY 2,412 2,83810018500 521000 2,872 3,728 2,379 2,418RETIREMENT 2,068 2,35910018500 522000 2,379 2,418 12,991 13,486HEALTH INSURANCE 12,449 12,38410018500 523000 12,991 13,486 121 220LIFE INSURANCE 117 12010018500 524000 121 220 1,217 1,217DENTAL INSURANCE 1,166 1,15810018500 525000 1,217 1,217 00UNEMPLOYMENT COMPENSATION 03,35910018500 526000 0 0 22,219 18,212 19,580 19,580 21,069 1,489SUB-TOTAL 21,069 MATERIALS AND SUPPLIES 23,000 23,000OPERATING SUPPLIES 17,527 18,89110018500 532000 21,000 23,000 26,400 33,200REPAIRS AND MAINTENANCE 24,707 47,92110018500 533000 26,400 33,200 16,050 23,595MAINTENANCE AGREEMENTS 8,512 10,75710018500 533100 16,050 23,595 53,000 53,000JANITORIAL SERVICES 49,098 50,68910018500 533200 51,000 53,000 450 450UNIFORMS 0 44910018500 535000 450 450 128,706 99,844 114,900 118,900 133,245 14,345SUB-TOTAL 133,245 CONTRACTUAL SERVICES 3,500 3,500COMMUNICATIONS 4,210 4,05610018500 541000 4,100 3,500 167,000 167,000UTILITIES 127,776 169,11910018500 542000 167,000 167,000 00PROFESSIONAL SERVICES 0 23,39610018500 544000 0 0 25,000 25,000CONTRACTUAL SERVICES 4,750 5,96010018500 544400 10,000 25,000 202,531 136,735 181,100 195,500 195,500 0SUB-TOTAL 195,500 PROFESSIONAL DEVELOPMENT 300 300MEETINGS AND TRAINING -50 010018500 563000 300 300 0 -50 300 300 300 0SUB-TOTAL 300 49 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET INCREASE/ DECREASE ADOPTED 2014 180,082 78,000MACHINERY & EQPMNT - REPLACED 112,709010018500 589000 140,000 78,000 00MACHINERY & EQPMNT - REPLACED 0192,30010018500 589000 0 0 192,300 112,709 140,000 180,082 78,000 -102,082SUB-TOTAL 78,000 $584,487 $401,198 $554,229 $479,610 $-74,619TOTAL BUILDING MAINTENANCE $494,247 $479,610 50 BUILDING MAINTENANCE 2013 FTE 2014 FTE Change 2013 2014 Change Bldg & Grounds Technician 1.0 1.0 - 57,832 59,109 1,277 Overtime/Temporary/Seasonal - 0.48 0.5 1,615 13,456 11,841 TOTAL 1.0 1.5 0.5 59,447 72,565 13,118 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET PERSONNEL COSTS Position Title STAFFING SALARIES, WAGES & BENEFITS 51 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET INCREASE/ DECREASE ADOPTED 2014 POLICE ADMINISTRATION PERSONNEL SERVICES 409,684 435,815REGULAR WAGES 385,697418,52710021021 511000 409,684 435,815 800 800OVERTIME 4771,01310021021 513000 500 800 1,200 1,200BOARDS AND COMMITTEES 68070010021021 514000 1,000 1,200 420,240 386,855 411,184 411,684 437,815 26,131SUB-TOTAL 437,815 FRINGE BENEFITS 30,926 33,255SOCIAL SECURITY 29,590 31,96810021021 521000 30,926 33,255 70,406 42,859RETIREMENT 52,248 65,91610021021 522000 57,719 42,859 51,964 53,944HEALTH INSURANCE 49,798 47,28810021021 523000 51,964 53,944 1,046 1,033LIFE INSURANCE 901 1,01410021021 524000 1,046 1,033 5,294 5,294DENTAL INSURANCE 5,071 4,80810021021 525000 5,294 5,294 0 10,211UNEMPLOYMENT COMPENSATION 0 010021021 526000 0 10,211 644 0LONG TERM DISABILITY 0 10710021021 527000 0 0 00POST EMPLOYMENT HEALTH PLAN 0 5,49610021021 528000 0 0 156,597 137,608 146,949 160,280 146,596 -13,684SUB-TOTAL 146,596 MATERIALS AND SUPPLIES 5,000 5,000OFFICE SUPPLIES 2,885 4,61110021021 531000 5,000 5,000 3,000 3,000OPERATING SUPPLIES 2,829 2,55510021021 532000 3,000 3,000 250 250REPAIRS AND MAINTENANCE 180 4010021021 533000 250 250 9,279 10,365MAINTENANCE AGREEMENTS 1,812 5,95910021021 533100 9,279 10,365 2,400 2,400UNIFORMS 2,400 2,40010021021 535000 2,400 2,400 15,564 10,106 19,929 19,929 21,015 1,086SUB-TOTAL 21,015 CONTRACTUAL SERVICES 24,200 24,200COMMUNICATIONS 22,720 23,72810021021 541000 24,200 24,200 3,000 3,000ADVERTISING AND PRINTING 1,740 4,30210021021 543000 3,000 3,000 3,500 2,500PROFESSIONAL SERVICES 298 1,69510021021 544000 3,500 2,500 150,188 147,633RMS/CAD OPERATING EXPENSES 150,187148,76010021021 544500 150,188 147,633 178,485 174,945 180,888 180,888 177,333 -3,555SUB-TOTAL 177,333 52 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET INCREASE/ DECREASE ADOPTED 2014 PROFESSIONAL DEVELOPMENT 100 100MILEAGE 0010021021 562000 100 100 10,000 10,000MEETINGS AND TRAINING 10,6799,95410021021 563000 10,000 10,000 745 745DUES AND MEMBERSHIPS 64075510021021 564000 745 745 50 50PUBLICATIONS AND SUBSCRIPTION 6111510021021 566000 50 50 10,824 11,380 10,895 10,895 10,895 0SUB-TOTAL 10,895 CAPITAL ITEMS 00MINOR CAPITAL 90 010021021 581100 90 0 0 90 90 0 0 0SUB-TOTAL 0 $781,710 $720,984 $783,676 $793,654 $9,978TOTAL POLICE ADMINISTRATION $769,935 $793,654 53 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET INCREASE/ DECREASE ADOPTED 2014 POLICE PATROL PERSONNEL SERVICES 2,224,445 2,564,421REGULAR WAGES 2,098,9932,150,01010021022 511000 2,224,445 2,552,122 75,000 75,000OVERTIME 82,74070,33510021022 513000 75,000 75,000 10,100 13,200LONGEVITY 11,7009,90010021022 515000 10,100 13,200 10,000 10,000PREMIUM PAY 8,3519,02810021022 516000 10,000 10,000 1,200 0MISCELLANEOUS COMPENSATION 037510021022 517000 0 0 50,000 58,988HOLIDAY COMPENSATION 54,30643,18010021022 518000 50,000 58,988 2,282,828 2,256,090 2,369,545 2,370,745 2,721,609 338,565SUB-TOTAL 2,709,310 FRINGE BENEFITS 178,670 204,862SOCIAL SECURITY 171,514 175,08510021022 521000 178,670 204,862 408,674 265,804RETIREMENT 316,938 386,19110021022 522000 353,708 265,804 330,720 364,578HEALTH INSURANCE 303,787 306,11810021022 523000 319,223 364,578 3,230 3,180LIFE INSURANCE 2,620 2,91110021022 524000 3,230 3,180 35,634 37,642DENTAL INSURANCE 32,285 31,85510021022 525000 33,428 37,642 00UNEMPLOYMENT COMPENSATION 0 -36310021022 526000 0 0 5,559 0LONG TERM DISABILITY 0 88410021022 527000 0 0 4,752 0POST EMPLOYMENT HEALTH PLAN 4,54827,84610021022 528000 4,752 0 930,528 831,690 893,011 967,239 876,066 -91,173SUB-TOTAL 876,066 MATERIALS AND SUPPLIES 14,600 19,750OPERATING SUPPLIES 10,102 18,07410021022 532000 14,600 19,750 3,000 3,000REPAIRS AND MAINTENANCE 1,860 2,31310021022 533000 3,000 3,000 23,700 24,300UNIFORMS 24,072 24,84010021022 535000 23,700 24,300 9,000 14,595BODY ARMOR 8,999 3,60610021022 535500 9,000 14,595 00FUEL PURCHASES 44 010021022 536000 0 0 48,833 45,076 50,300 50,300 61,645 11,345SUB-TOTAL 61,645 54 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET INCREASE/ DECREASE ADOPTED 2014 CONTRACTUAL SERVICES 8,000 16,160COMMUNICATIONS 9,5839,11310021022 541000 8,000 16,160 2,200 2,200UTILITIES 1,7362,21610021022 542000 2,200 2,200 5,000 4,000MEDICAL TESTING 2,1942,64210021022 546000 5,000 4,000 13,971 13,513 15,200 15,200 22,360 7,160SUB-TOTAL 22,360 PROFESSIONAL DEVELOPMENT 00MILEAGE 123 010021022 562000 125 0 27,250 35,500MEETINGS AND TRAINING 15,047 27,40610021022 563000 27,250 35,500 250 250DUES AND MEMBERSHIPS 215 5510021022 564000 250 250 4,155 4,155IN-HOUSE TRAINING 3,970 4,20810021022 565000 4,155 4,155 31,669 19,355 31,780 31,655 39,905 8,250SUB-TOTAL 39,905 CAPITAL ITEMS 29,310 29,130MACHINERY & EQUIPMENT EXPENS 8,0263,76910021022 581000 29,310 29,130 30,500 30,500MINOR CAPITAL 28,272 1,91910021022 581100 30,500 30,500 5,688 36,298 59,810 59,810 59,630 -180SUB-TOTAL 59,630 $3,313,516 $3,202,023 $3,494,949 $3,781,215 $273,967TOTAL POLICE PATROL $3,419,646 $3,768,916 55 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET INCREASE/ DECREASE ADOPTED 2014 POLICE INVESTIGATION PERSONNEL SERVICES 332,061 362,923REGULAR WAGES 310,796330,54410021023 511000 332,061 362,923 16,000 26,000OVERTIME 21,09216,48710021023 513000 16,000 26,000 2,950 3,400LONGEVITY 3,2003,00010021023 515000 2,950 3,400 500 500PREMIUM PAY 40649510021023 516000 500 500 8,300 8,300HOLIDAY COMPENSATION 6,2605,74810021023 518000 8,300 8,300 356,274 341,754 359,811 359,811 401,123 41,312SUB-TOTAL 401,123 FRINGE BENEFITS 27,448 29,758SOCIAL SECURITY 26,088 27,23210021023 521000 27,448 29,758 57,952 36,044RETIREMENT 45,891 57,47110021023 522000 50,783 36,044 51,542 53,512HEALTH INSURANCE 49,473 49,84710021023 523000 51,542 53,512 825 797LIFE INSURANCE 752 78410021023 524000 825 797 4,715 4,715DENTAL INSURANCE 4,462 4,48410021023 525000 4,715 4,715 719 0LONG TERM DISABILITY 0 11910021023 527000 0 0 576 0POST EMPLOYMENT HEALTH PLAN 564 57610021023 528000 576 0 140,512 127,230 135,889 143,777 124,826 -18,951SUB-TOTAL 124,826 MATERIALS AND SUPPLIES 4,000 5,250OPERATING SUPPLIES 3,240 3,26910021023 532000 4,000 5,250 250 250REPAIRS AND MAINTENANCE 82 23110021023 533000 250 250 2,700 2,700UNIFORMS 2,700 2,70010021023 535000 2,700 2,700 6,200 6,022 6,950 6,950 8,200 1,250SUB-TOTAL 8,200 CONTRACTUAL SERVICES 3,550 3,550COMMUNICATIONS 2,338 2,33610021023 541000 3,550 3,550 00MEDICAL TESTING 0 6010021023 546000 0 0 2,396 2,338 3,550 3,550 3,550 0SUB-TOTAL 3,550 3,000 3,000MEETINGS AND TRAINING 3,255 2,94610021023 563000 3,005 3,000 100 100DUES AND MEMBERSHIPS 70 5010021023 564000 100 100 2,996 3,325 3,105 3,100 3,100 0SUB-TOTAL 3,100 56 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET INCREASE/ DECREASE ADOPTED 2014 Others 4,500 4,500RENTAL VEHICLES AND EQUIPMENT 3,5253,80410021023 537000 4,500 4,500 3,804 3,525 4,500 4,500 4,500 0SUB-TOTAL 4,500 $512,182 $484,193 $521,688 $545,299 $23,611TOTAL POLICE INVESTIGATION $513,805 $545,299 57 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET INCREASE/ DECREASE ADOPTED 2014 POLICE COMMUNICATIONS PERSONNEL SERVICES 406,747 406,340REGULAR WAGES 333,234378,45710021024 511000 378,093 406,340 22,000 22,000OVERTIME 30,52527,98810021024 513000 31,000 22,000 2,200 2,200PREMIUM PAY 2,0792,14610021024 516000 2,200 2,200 10,000 10,000HOLIDAY COMPENSATION 4,7487,37810021024 518000 10,000 10,000 13,000 13,000SEASONAL WAGES 18,48113,72010021024 519000 17,500 13,000 429,687 389,067 438,793 453,947 453,540 -407SUB-TOTAL 453,540 FRINGE BENEFITS 33,638 33,703SOCIAL SECURITY 29,176 32,27810021024 521000 32,252 33,703 25,221 25,199RETIREMENT 20,228 23,06510021024 522000 23,441 25,199 80,039 91,360HEALTH INSURANCE 71,791 76,82710021024 523000 74,708 91,360 794 796LIFE INSURANCE 634 74910021024 524000 794 796 8,580 8,154DENTAL INSURANCE 6,608 7,78210021024 525000 6,900 8,154 140,702 128,437 138,095 148,272 159,212 10,940SUB-TOTAL 159,212 MATERIALS AND SUPPLIES 750 750OPERATING SUPPLIES 524 71110021024 532000 750 750 750 750REPAIRS AND MAINTENANCE 589 74310021024 533000 750 750 1,453 1,113 1,500 1,500 1,500 0SUB-TOTAL 1,500 CONTRACTUAL SERVICES 97,842 121,544COMMUNICATIONS 79,640 84,67110021024 541000 97,842 121,544 350 350UTILITIES 115 24910021024 542000 350 350 1,750 1,750PROFESSIONAL SERVICES 2,023 1,75010021024 544000 2,100 1,750 86,670 81,778 100,292 99,942 123,644 23,702SUB-TOTAL 123,644 PROFESSIONAL DEVELOPMENT 00MILEAGE 41 010021024 562000 50 0 2,180 2,180MEETINGS AND TRAINING 1,500 1,55310021024 563000 2,180 2,180 220 220DUES AND MEMBERSHIPS 574 33010021024 564000 220 220 1,883 2,115 2,450 2,400 2,400 0SUB-TOTAL 2,400 $660,395 $602,509 $706,061 $740,296 $34,235TOTAL POLICE COMMUNICATIONS $681,130 $740,296 58 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET INCREASE/ DECREASE ADOPTED 2014 POLICE RECORDS PERSONNEL SERVICES 280,255 251,570REGULAR WAGES 253,557275,89710021025 511000 278,555 285,183 3,200 2,700OVERTIME 1,3472,30610021025 513000 3,200 2,700 400 400PREMIUM PAY 18120010021025 516000 400 400 278,403 255,085 282,155 283,855 254,670 4,428SUB-TOTAL 288,283 FRINGE BENEFITS 20,900 19,125SOCIAL SECURITY 19,167 20,74710021025 521000 20,900 21,697 16,437 14,644RETIREMENT 14,854 16,16910021025 522000 16,437 16,728 75,011 72,652HEALTH INSURANCE 70,842 71,56610021025 523000 75,011 77,874 633 667LIFE INSURANCE 577 57010021025 524000 633 691 6,937 6,511DENTAL INSURANCE 6,547 6,60910021025 525000 6,937 6,937 115,661 111,987 119,918 119,918 113,599 4,009SUB-TOTAL 123,927 MATERIALS AND SUPPLIES 00OFFICE SUPPLIES 340 010021025 531000 400 0 1,000 1,000OPERATING SUPPLIES 255 90310021025 532000 1,000 1,000 903 595 1,400 1,000 1,000 0SUB-TOTAL 1,000 CONTRACTUAL SERVICES 00COMMUNICATIONS 355 33910021025 541000 500 0 339 355 500 0 0 0SUB-TOTAL 0 PROFESSIONAL DEVELOPMENT 1,175 1,675MEETINGS AND TRAINING 2,222 1,54010021025 563000 1,175 1,675 1,540 2,222 1,175 1,175 1,675 500SUB-TOTAL 1,675 $396,847 $370,244 $405,948 $370,944 $8,937TOTAL POLICE RECORDS $405,148 $414,885 59 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET INCREASE/ DECREASE ADOPTED 2014 POLICE TASK FORCE PERSONNEL SERVICES 262,661 286,502REGULAR WAGES 251,279263,29510021026 511000 262,661 286,502 18,000 18,000OVERTIME 12,96314,37510021026 513000 18,000 18,000 1,900 2,600LONGEVITY 2,4002,20010021026 515000 1,900 2,600 700 700PREMIUM PAY 38155410021026 516000 700 700 8,000 8,000HOLIDAY COMPENSATION 6,3977,39910021026 518000 8,000 8,000 287,823 273,421 291,261 291,261 315,802 24,541SUB-TOTAL 315,802 FRINGE BENEFITS 22,428 24,154SOCIAL SECURITY 20,807 22,06910021026 521000 22,900 24,154 50,249 29,920RETIREMENT 39,885 50,48610021026 522000 45,258 29,920 38,553 40,028HEALTH INSURANCE 37,763 36,57710021026 523000 38,553 40,028 268 678LIFE INSURANCE 575 32210021026 524000 546 678 3,500 3,500DENTAL INSURANCE 3,435 3,33110021026 525000 3,500 3,500 706 0LONG TERM DISABILITY 0 11710021026 527000 0 0 576 0POST EMPLOYMENT HEALTH PLAN 576 57610021026 528000 576 0 113,477 103,041 111,333 116,280 98,280 -18,000SUB-TOTAL 98,280 MATERIALS AND SUPPLIES 1,000 1,000OPERATING SUPPLIES 202 85310021026 532000 1,000 1,000 00REPAIRS AND MAINTENANCE 0 6010021026 533000 0 0 2,700 2,700UNIFORMS 2,700 2,70010021026 535000 2,700 2,700 3,613 2,902 3,700 3,700 3,700 0SUB-TOTAL 3,700 CONTRACTUAL SERVICES 2,500 2,500COMMUNICATIONS 758 73310021026 541000 2,500 2,500 733 758 2,500 2,500 2,500 0SUB-TOTAL 2,500 4,500 4,500MEETINGS AND TRAINING 4,289 4,05510021026 563000 4,500 4,500 4,055 4,289 4,500 4,500 4,500 0SUB-TOTAL 4,500 $409,702 $384,411 $418,241 $424,782 $6,541TOTAL POLICE TASK FORCE $413,294 $424,782 60 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET INCREASE/ DECREASE ADOPTED 2014 POLICE VEHICLES MATERIALS AND SUPPLIES 94,500 96,390FUEL PURCHASES 93,679110,06810021027 536000 105,000 96,390 110,068 93,679 105,000 94,500 96,390 1,890SUB-TOTAL 96,390 $110,068 $93,679 $94,500 $96,390 $1,890TOTAL POLICE VEHICLES $105,000 $96,390 61 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET INCREASE/ DECREASE ADOPTED 2014 POLICE COMMUNITY POLICING MATERIALS AND SUPPLIES 5,000 5,000OPERATING SUPPLIES 3,3865,15310021028 532000 5,000 5,000 0 1,200OPERATING SUPPLIES 1,2001,20010021028 532000 1,200 1,200 6,353 4,586 6,200 5,000 6,200 1,200SUB-TOTAL 6,200 Others 600 600REWARD PAYMENTS 0 010021028 548500 600 600 0 0 600 600 600 0SUB-TOTAL 600 $6,353 $4,586 $5,600 $6,800 $1,200TOTAL POLICE COMMUNITY POLICING $6,800 $6,800 62 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET INCREASE/ DECREASE ADOPTED 2014 POLICE CROSSING GUARDS CONTRACTUAL SERVICES 84,000 87,000PROFESSIONAL SERVICES 77,11985,12110021029 544000 84,000 87,000 85,121 77,119 84,000 84,000 87,000 3,000SUB-TOTAL 87,000 $85,121 $77,119 $84,000 $87,000 $3,000TOTAL POLICE CROSSING GUARDS $84,000 $87,000 63 POLICE DEPARTMENT 2013 FTE 2014 FTE Change 2013 2014 Change Police Chief 1.0 1.0 - 129,505 130,389 884 Assistant Chief 1.0 1.0 - 127,306 128,664 1,358 Lieutenant 2.0 2.0 - 235,051 235,954 903 Sergeant 7.0 8.0 1.0 690,957 829,263 138,306 Detective 4.0 4.0 - 372,149 383,928 11,779 Police Officer 37.0 37.0 - 2,864,037 2,998,464 134,427 Records Supervisor 1.0 1.0 - 79,955 81,878 1,923 Dispatch Supervisor 1.0 1.0 - 75,479 77,258 1,779 Dispatcher 8.4 8.4 - 469,349 484,580 15,231 Community Service Officer 1.0 1.0 - 64,159 65,434 1,275 Court Officer 1.0 1.0 - 55,445 56,440 995 Administrative Assistant 1.0 1.0 - 77,553 79,355 1,802 Records Secretary 6.4 6.4 - 319,445 326,325 6,880 Holiday/Misc/Prem Pay - - - 98,356 106,668 8,312 Overtime - - - 146,475 155,554 9,079 Boards & Commissions - - - 1,200 1,200 - TOTAL 71.8 72.8 1.0 5,806,421 6,141,354 334,933 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET PERSONNEL COSTS Position Title STAFFING SALARIES, WAGES & BENEFITS 64 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET INCREASE/ DECREASE ADOPTED 2014 FIRE DEPARTMENT MATERIALS AND SUPPLIES 00REPAIRS AND MAINTENANCE 010,95110022000 533000 0 0 00JANITORIAL SERVICES 05,79610022000 533200 0 0 16,747 0 0 0 0 0SUB-TOTAL 0 20,000 20,000UTILITIES 15,908 19,34210022000 542000 20,000 20,000 140,167 140,167PROFESSIONAL SERVICES 140,167 181,79210022000 544000 140,167 190,167 124,284 349,284PAID ON PREMISE FIREFIGHTERS 124,28475,10110022000 544220 124,284 338,284 276,235 280,359 284,451 284,451 509,451 264,000SUB-TOTAL 548,451 CAPITAL ITEMS 39,005 39,005MACHINERY & EQUIPMENT EXPENS 29,32074010022000 581000 39,005 42,005 740 29,320 39,005 39,005 39,005 3,000SUB-TOTAL 42,005 Others 83,000 83,000FIRE INSURANCE DUES PAYMENT 81,46982,82910022000 548400 81,469 83,000 82,829 81,469 81,469 83,000 83,000 0SUB-TOTAL 83,000 $376,550 $391,147 $406,456 $631,456 $267,000TOTAL FIRE DEPARTMENT $404,925 $673,456 65 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET INCREASE/ DECREASE ADOPTED 2014 EMERGENCY MEDICAL SERVICES PERSONNEL SERVICES 561,622 596,541REGULAR WAGES 526,001568,17810023000 511000 561,622 596,541 286,791 306,944OVERTIME 274,943291,57710023000 513000 289,287 306,944 00MISCELLANEOUS COMPENSATION 90622110023000 517000 1,000 0 27,369 27,369HOLIDAY COMPENSATION 19,08829,04510023000 518000 29,000 27,369 889,021 820,938 880,909 875,782 930,854 55,072SUB-TOTAL 930,854 FRINGE BENEFITS 64,447 69,125SOCIAL SECURITY 61,043 66,17110023000 521000 67,945 69,125 91,008 51,307RETIREMENT 66,442 90,02610023000 522000 71,785 51,307 147,929 153,568HEALTH INSURANCE 137,432 149,23410023000 523000 141,965 153,568 818 765LIFE INSURANCE 694 77010023000 524000 818 765 15,030 14,239DENTAL INSURANCE 13,940 14,21110023000 525000 14,161 14,239 500 0UNEMPLOYMENT COMPENSATION 0 010023000 526000 0 0 2,412 0POST EMPLOYMENT HEALTH PLAN 6002,40010023000 528000 601 0 322,811 280,151 297,275 322,144 289,004 -33,140SUB-TOTAL 289,004 MATERIALS AND SUPPLIES 550 550OFFICE SUPPLIES 0 13910023000 531000 550 550 45,680 50,000OPERATING SUPPLIES 35,742 45,62210023000 532000 38,477 50,000 00OPERATING SUPPLIES 7,202 1,51610023000 532000 7,203 0 3,000 3,000REPAIRS AND MAINTENANCE 793 1,33810023000 533000 3,000 3,000 16,830 16,830MAINTENANCE AGREEMENTS 11,703 9,57710023000 533100 16,830 16,830 600 600JANITORIAL SERVICES 280 34010023000 533200 600 600 7,500 7,500UNIFORMS 5,112 7,07610023000 535000 7,500 7,500 10,000 13,000FUEL PURCHASES 11,667 10,59110023000 536000 10,000 13,000 76,198 72,499 84,160 84,160 91,480 7,320SUB-TOTAL 91,480 66 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET INCREASE/ DECREASE ADOPTED 2014 CONTRACTUAL SERVICES 5,160 5,160COMMUNICATIONS 5,2575,61310023000 541000 5,160 5,160 11,000 11,000UTILITIES 6,4137,97810023000 542000 11,000 11,000 300 300ADVERTISING AND PRINTING 0010023000 543000 300 300 63,000 63,000PROFESSIONAL SERVICES 53,30078,60010023000 544000 63,000 24,000 51,500 51,500BILLING SERVICES 47,38351,11710023000 547000 51,500 51,500 143,309 112,352 130,960 130,960 130,960 -39,000SUB-TOTAL 91,960 PROFESSIONAL DEVELOPMENT 750 750MILEAGE 0 010023000 562000 750 750 4,410 4,450MEETINGS AND TRAINING 1,136 4,16810023000 563000 4,410 4,450 550 620DUES AND MEMBERSHIPS 603 7510023000 564000 603 620 270 270PUBLICATIONS AND SUBSCRIPTION 0 22510023000 566000 270 270 4,468 1,739 6,033 5,980 6,090 110SUB-TOTAL 6,090 CAPITAL ITEMS 10,000 37,933MACHINERY & EQUIPMENT EXPENS 3,95032,60510023000 581000 10,000 37,933 00MINOR CAPITAL 0 1,37510023000 581100 0 0 0 142,844VEHICLES 0 010023000 582000 0 142,844 33,980 3,950 10,000 10,000 180,777 170,777SUB-TOTAL 180,777 $1,469,786 $1,291,629 $1,429,026 $1,629,165 $161,139TOTAL EMERGENCY MEDICAL SERVICES $1,409,337 $1,590,165 67 EMERGENCY MEDICAL SERVICE 2013 FTE 2014 FTE Change 2013 2014 Change EMS Director 1.0 1.0 - 101,763 103,865 2,102 Paramedics 12.0 12.0 - 984,386 1,004,518 20,132 LTE Paramedics 1.5 1.5 - 53,825 53,825 - Holiday/Training/Pager Pay - - - 29,463 29,463 - Overtime/Temporary - - - 308,731 330,425 21,695 Unemployment Compensation - - - 500 - (500) TOTAL 14.5 14.5 - 1,478,668 1,522,096 43,429 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET PERSONNEL COSTS Position Title STAFFING SALARIES, WAGES & BENEFITS 68 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET INCREASE/ DECREASE ADOPTED 2014 BUILDING INSPECTION PERSONNEL SERVICES 218,482 226,328REGULAR WAGES 202,278215,29010024000 511000 218,482 226,328 00OVERTIME 1520710024000 513000 200 0 25,000 25,000SEASONAL WAGES 18,02924,58410024000 519000 25,000 25,000 240,081 220,322 243,682 243,482 251,328 7,846SUB-TOTAL 251,328 FRINGE BENEFITS 17,647 19,029SOCIAL SECURITY 16,148 17,53610024000 521000 17,647 19,029 12,197 13,972RETIREMENT 11,713 12,04710024000 522000 13,000 13,972 48,233 45,680HEALTH INSURANCE 47,458 45,69710024000 523000 48,233 45,680 828 851LIFE INSURANCE 783 82110024000 524000 828 851 4,474 4,077DENTAL INSURANCE 4,437 4,26310024000 525000 4,474 4,077 80,365 80,539 84,182 83,379 83,609 230SUB-TOTAL 83,609 MATERIALS AND SUPPLIES 1,000 1,000OFFICE SUPPLIES 314 1,04610024000 531000 1,000 1,000 6,000 6,000OPERATING PERMITS & LICENSES 6,0006,00010024000 532400 6,000 6,000 7,046 6,314 7,000 7,000 7,000 0SUB-TOTAL 7,000 CONTRACTUAL SERVICES 4,400 5,400COMMUNICATIONS 2,696 4,06510024000 541000 4,100 5,400 00ADVERTISING AND PRINTING 0 4010024000 543000 0 0 6,000 6,000PROFESSIONAL SERVICES 16,412 8,68110024000 544000 16,000 6,000 12,786 19,108 20,100 10,400 11,400 1,000SUB-TOTAL 11,400 PROFESSIONAL DEVELOPMENT 2,000 2,000MEETINGS AND TRAINING 1,660 1,36810024000 563000 1,800 2,000 650 650DUES AND MEMBERSHIPS 0 20210024000 564000 500 650 250 250PUBLICATIONS AND SUBSCRIPTION 0 010024000 566000 200 250 1,569 1,660 2,500 2,900 2,900 0SUB-TOTAL 2,900 $341,847 $327,943 $347,161 $356,237 $9,076TOTAL BUILDING INSPECTION $357,464 $356,237 69 BUILDING INSPECTION 2013 FTE 2014 FTE Change 2013 2014 Change Director of Building Inspection 1.0 1.0 - 109,024 111,318 2,294 Building Inspector 2.0 2.0 - 146,091 149,697 3,606 Secretary 0.9 0.9 - 43,756 45,691 1,935 LTE Plumbing Inspector - - - 26,913 26,913 - Overtime/Temporary - - - - - - Unemployment Compensation - - - - - - TOTAL 3.9 3.9 - 325,784 333,619 7,835 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET PERSONNEL COSTS Position Title STAFFING SALARIES, WAGES & BENEFITS 70 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET INCREASE/ DECREASE ADOPTED 2014 PUBLIC WORKS ADMINISTRATION PERSONNEL SERVICES 134,971 134,036REGULAR WAGES 123,080135,82510031031 511000 130,000 134,036 300 300OVERTIME 15525210031031 513000 250 300 136,077 123,235 130,250 135,271 134,336 -935SUB-TOTAL 134,336 FRINGE BENEFITS 10,200 10,230SOCIAL SECURITY 9,373 10,39610031031 521000 9,880 10,230 8,369 8,312RETIREMENT 7,631 8,42110031031 522000 8,060 8,312 11,062 22,080HEALTH INSURANCE 11,075 10,69410031031 523000 10,412 22,080 594 604LIFE INSURANCE 365 44410031031 524000 594 604 1,729 2,739DENTAL INSURANCE 1,705 1,65810031031 525000 1,729 2,739 31,613 30,149 30,675 31,954 43,965 12,011SUB-TOTAL 43,965 MATERIALS AND SUPPLIES 1,100 1,100OFFICE SUPPLIES 989 23010031031 531000 1,100 1,100 230 989 1,100 1,100 1,100 0SUB-TOTAL 1,100 CONTRACTUAL SERVICES 3,500 3,500COMMUNICATIONS 6,939 9,19110031031 541000 8,000 3,500 00ADVERTISING AND PRINTING 0 12110031031 543000 0 0 00PROFESSIONAL SERVICES 0 40010031031 544000 0 0 9,712 6,939 8,000 3,500 3,500 0SUB-TOTAL 3,500 PROFESSIONAL DEVELOPMENT 500 500MEETINGS AND TRAINING 217 8010031031 563000 500 500 275 275DUES AND MEMBERSHIPS 386 44410031031 564000 400 275 00PUBLICATIONS AND SUBSCRIPTION 148 010031031 566000 150 0 524 752 1,050 775 775 0SUB-TOTAL 775 $178,156 $162,062 $172,600 $183,676 $11,076TOTAL PUBLIC WORKS ADMINISTRATION $171,075 $183,676 71 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET INCREASE/ DECREASE ADOPTED 2014 PUBLIC WORKS FLEET MAINTENANCE PERSONNEL SERVICES 203,704 207,447REGULAR WAGES 187,207198,46010031032 511000 202,915 207,447 350 350OVERTIME 49763510031032 513000 700 350 860 860MISCELLANEOUS COMPENSATION 1,5211,10910031032 517000 1,400 860 200,205 189,225 205,015 204,914 208,657 3,743SUB-TOTAL 208,657 FRINGE BENEFITS 15,156 15,423SOCIAL SECURITY 14,079 14,90610031032 521000 15,200 15,423 12,631 12,864RETIREMENT 11,607 11,90010031032 522000 12,580 12,864 51,964 45,680HEALTH INSURANCE 42,166 45,40810031032 523000 44,000 45,680 339 350LIFE INSURANCE 292 34610031032 524000 339 350 4,868 4,077DENTAL INSURANCE 3,905 4,24810031032 525000 4,075 4,077 76,808 72,049 76,194 84,958 78,394 -6,564SUB-TOTAL 78,394 MATERIALS AND SUPPLIES 00OFFICE SUPPLIES 56 2710031032 531000 100 0 9,000 9,000OPERATING SUPPLIES 8,031 12,81910031032 532000 9,000 9,000 100,000 100,000REPAIRS AND MAINTENANCE 84,359 89,89010031032 533000 96,316 100,000 00REPAIRS AND MAINTENANCE 3,684 2,10510031032 533000 3,684 0 27,500 27,500REPAIRS & MAINTENANCE - POLICE 13,26141,55910031032 533210 27,500 27,500 5,000 5,000REPAIRS & MAINTENANCE - FIRE 21,5846,06810031032 533220 5,000 5,000 6,000 6,000REPAIRS & MAINTENANCE - EMS 3,575 3,93910031032 533230 6,000 6,000 2,500 2,500SMALL TOOLS 3,037 1,84010031032 534000 2,500 2,500 1,000 1,000UNIFORMS 1,311 1,67910031032 535000 1,000 1,000 103,000 108,000FUEL PURCHASES 125,109 117,61210031032 536000 120,000 108,000 277,538 264,007 271,100 254,000 259,000 5,000SUB-TOTAL 259,000 CONTRACTUAL SERVICES 480 480COMMUNICATIONS 455 63910031032 541000 480 480 15,000 15,000UTILITIES 11,358 13,47610031032 542000 15,000 15,000 3,000 3,000PROFESSIONAL SERVICES 3,768 3,60010031032 544000 3,244 3,000 17,715 15,581 18,724 18,480 18,480 0SUB-TOTAL 18,480 72 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET INCREASE/ DECREASE ADOPTED 2014 PROFESSIONAL DEVELOPMENT 1,000 1,000MEETINGS AND TRAINING 42277910031032 563000 1,000 1,000 00PUBLICATIONS AND SUBSCRIPTION 1,62412410031032 566000 1,624 0 902 2,045 2,624 1,000 1,000 0SUB-TOTAL 1,000 CAPITAL ITEMS 00MACHINERY & EQUIPMENT EXPENS 01,35410031032 581000 0 0 0 9,000MINOR CAPITAL 0 010031032 581100 0 9,000 1,354 0 0 0 9,000 9,000SUB-TOTAL 9,000 Others 112,000 167,600VEHICLES - POLICE 114,514 150,95010031032 582210 115,000 167,600 341,000 206,000VEHICLES - PUBLIC WORKS 266,249 285,51110031032 582310 341,000 206,000 436,461 380,763 456,000 453,000 373,600 -79,400SUB-TOTAL 373,600 $1,010,983 $923,671 $1,016,352 $948,131 $-68,221TOTAL PUBLIC WORKS FLEET MAINTENANCE $1,029,657 $948,131 73 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET INCREASE/ DECREASE ADOPTED 2014 PUBLIC WORKS OPERATIONS PERSONNEL SERVICES 354,611 345,212REGULAR WAGES 305,890344,64110031033 511000 339,662 345,212 4,500 4,500OVERTIME 9,3446,72410031033 513000 10,000 4,500 1,600 1,600MISCELLANEOUS COMPENSATION 1,9082,06610031033 517000 1,600 1,600 30,000 30,000SEASONAL WAGES 17,87228,06210031033 519000 20,000 30,000 381,494 335,014 371,262 390,711 381,312 -9,399SUB-TOTAL 381,312 FRINGE BENEFITS 29,234 28,581SOCIAL SECURITY 25,572 28,78310031033 521000 28,558 28,581 21,989 21,404RETIREMENT 18,985 21,00810031033 522000 21,059 21,404 55,523 71,130HEALTH INSURANCE 64,611 52,91510031033 523000 68,513 71,130 1,000 1,035LIFE INSURANCE 911 98710031033 524000 1,000 1,035 7,545 7,545DENTAL INSURANCE 7,139 6,89210031033 525000 7,545 7,545 110,584 117,218 126,675 115,291 129,695 14,404SUB-TOTAL 129,695 MATERIALS AND SUPPLIES 00OFFICE SUPPLIES 692 7810031033 531000 693 0 13,500 13,500OPERATING SUPPLIES 13,489 15,87510031033 532000 13,500 13,500 5,000 5,000REPAIRS AND MAINTENANCE 7,197 3,36510031033 533000 6,500 5,000 00SMALL TOOLS 621 010031033 534000 650 0 3,600 3,600UNIFORMS 3,695 4,48810031033 535000 3,600 3,600 23,806 25,694 24,943 22,100 22,100 0SUB-TOTAL 22,100 20,000 20,000UTILITIES 15,019 19,13010031033 542000 20,000 20,000 3,500 5,700PROFESSIONAL SERVICES 4,203 4,27810031033 544000 3,500 5,700 600 600MEDICAL TESTING 258 53510031033 546000 600 600 23,943 19,480 24,100 24,100 26,300 2,200SUB-TOTAL 26,300 PROFESSIONAL DEVELOPMENT 500 500MEETINGS AND TRAINING 412 1,56110031033 563000 500 500 00PUBLICATIONS AND SUBSCRIPTION 0 14810031033 566000 0 0 1,709 412 500 500 500 0SUB-TOTAL 500 74 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET INCREASE/ DECREASE ADOPTED 2014 CAPITAL ITEMS 00MACHINERY & EQUIPMENT EXPENS 1,86613,06110031033 581000 1,866 0 13,061 1,866 1,866 0 0 0SUB-TOTAL 0 $554,598 $499,683 $552,702 $559,907 $7,205TOTAL PUBLIC WORKS OPERATIONS $549,346 $559,907 75 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET INCREASE/ DECREASE ADOPTED 2014 PUBLIC WORKS SNOW/ICE CONTROL PERSONNEL SERVICES 28,579 28,579OVERTIME 22,37619,48910031034 513000 28,579 28,579 19,489 22,376 28,579 28,579 28,579 0SUB-TOTAL 28,579 FRINGE BENEFITS 2,186 2,186SOCIAL SECURITY 1,708 1,48710031034 521000 2,186 2,186 1,487 1,708 2,186 2,186 2,186 0SUB-TOTAL 2,186 MATERIALS AND SUPPLIES 217,000 167,000OPERATING SUPPLIES 223,373 173,73410031034 532000 217,000 167,000 14,000 14,000REPAIRS AND MAINTENANCE 39,332 18,42110031034 533000 40,000 14,000 192,155 262,704 257,000 231,000 181,000 -50,000SUB-TOTAL 181,000 6,000 6,000PROFESSIONAL SERVICES 2,360 6,95810031034 544000 6,000 6,000 35,000 58,000CONTRACTUAL SERVICES 128,934 89,99310031034 544400 140,000 58,000 96,951 131,294 146,000 41,000 64,000 23,000SUB-TOTAL 64,000 Others 0 10,000RENTAL VEHICLES AND EQUIPMENT 21,370010031034 537000 19,670 10,000 0 21,370 19,670 0 10,000 10,000SUB-TOTAL 10,000 $310,081 $439,453 $302,765 $285,765 $-17,000TOTAL PUBLIC WORKS SNOW/ICE CONTROL $453,435 $285,765 76 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET INCREASE/ DECREASE ADOPTED 2014 PUBLIC WORKS TRAFFIC CONTROL MATERIALS AND SUPPLIES 12,000 12,000OPERATING SUPPLIES 21,25316,67410031035 532000 21,752 12,000 5,000 5,000REPAIRS AND MAINTENANCE 27,62715,18710031035 533000 20,000 5,000 1,765 1,765MAINTENANCE AGREEMENTS 2,2781,76510031035 533100 2,278 1,765 00SMALL TOOLS 1,069010031035 534000 1,000 0 33,626 52,227 45,030 18,765 18,765 0SUB-TOTAL 18,765 11,220 11,220UTILITIES 12,437 13,40110031035 542000 11,220 11,220 15,000 15,000CONTRACTUAL SERVICES 22,300 6,29710031035 544400 15,000 15,000 19,698 34,737 26,220 26,220 26,220 0SUB-TOTAL 26,220 PROFESSIONAL DEVELOPMENT 980 980MEETINGS AND TRAINING 660 40410031035 563000 980 980 404 660 980 980 980 0SUB-TOTAL 980 CAPITAL ITEMS 25,000 31,000MACHINERY & EQUIPMENT EXPENS 17,21719,98910031035 581000 25,000 31,000 00STREET/TRAFFIC SIGNS 0 1,55110031035 581300 0 0 21,540 17,217 25,000 25,000 31,000 6,000SUB-TOTAL 31,000 $75,269 $104,840 $70,965 $76,965 $6,000TOTAL PUBLIC WORKS TRAFFIC CONTROL $97,230 $76,965 77 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET INCREASE/ DECREASE ADOPTED 2014 PUBLIC WORKS STREETS MAINT MATERIALS AND SUPPLIES 320,000 350,000OPERATING SUPPLIES 335,727104,02310031036 532000 320,000 350,000 00OPERATING SUPPLIES 057,73410031036 532000 0 0 00OPERATING SUPPLIES 0138,70610031036 532000 0 0 00REPAIRS AND MAINTENANCE 9732810031036 533000 973 0 00FUEL PURCHASES 02010031036 536000 0 0 300,510 336,700 320,973 320,000 350,000 30,000SUB-TOTAL 350,000 320,000 320,000UTILITIES 302,010 332,01210031036 542000 324,212 320,000 332,012 302,010 324,212 320,000 320,000 0SUB-TOTAL 320,000 $632,522 $638,710 $640,000 $670,000 $30,000TOTAL PUBLIC WORKS STREETS MAINT $645,185 $670,000 78 PUBLIC WORKS DEPARTMENT 2013 FTE 2014 FTE Change 2013 2014 Change Public Works Director 1.0 1.0 - 112,253 112,672 419 Parks/PW Supervisor 0.5 0.5 - 42,128 43,187 1,059 Fleet Maint/Contracts Supervisor 1.0 1.0 - 95,905 98,144 2,239 Maintenance Crewleader 1.0 1.0 - 69,075 70,499 1,424 Traffic Control Crewleader 1.0 1.0 - 70,999 72,396 1,397 Fleet Maintenance Crewleader 1.0 1.0 - 75,037 76,584 1,547 Mechanic 2.0 2.0 - 117,655 110,988 (6,667) Maintenance Worker 5.0 5.0 - 284,975 286,003 1,028 Secretary 1.25 1.25 - 54,589 65,212 10,623 Seasonal Pay - - - 32,295 32,295 - Overtime/Miscellaneous - - - 38,953 38,953 - TOTAL 13.8 13.8 - 993,864 1,006,933 13,069 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET PERSONNEL COSTS Position Title STAFFING SALARIES, WAGES & BENEFITS 79 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET INCREASE/ DECREASE ADOPTED 2014 REFUSE & RECYCLING PERSONNEL SERVICES 16,570 16,570REGULAR WAGES 11,53714,21510032000 511000 14,000 16,570 14,215 11,537 14,000 16,570 16,570 0SUB-TOTAL 16,570 FRINGE BENEFITS 1,268 1,268SOCIAL SECURITY 883 1,08710032000 521000 1,071 1,268 00UNEMPLOYMENT COMPENSATION 972 1,51410032000 526000 972 0 2,601 1,854 2,043 1,268 1,268 0SUB-TOTAL 1,268 MATERIALS AND SUPPLIES 2,000 2,000OPERATING SUPPLIES 2,155 58210032000 532000 2,000 2,000 2,000 2,000REPAIRS AND MAINTENANCE 4,965 1,61910032000 533000 4,000 2,000 300 300UNIFORMS 151 010032000 535000 300 300 2,202 7,270 6,300 4,300 4,300 0SUB-TOTAL 4,300 CONTRACTUAL SERVICES 650 650COMMUNICATIONS 0 010032000 541000 650 650 1,000 1,000UTILITIES 529 37910032000 542000 1,000 1,000 2,500 2,500ADVERTISING AND PRINTING 448 93710032000 543000 2,500 2,500 1,313,497 1,373,837PROFESSIONAL SERVICES 1,229,8971,272,50810032000 544000 1,313,497 1,373,837 1,273,824 1,230,874 1,317,647 1,317,647 1,377,987 60,340SUB-TOTAL 1,377,987 $1,292,842 $1,251,534 $1,339,785 $1,400,125 $60,340TOTAL REFUSE & RECYCLING $1,339,990 $1,400,125 80 REFUSE & RECYCLING 2013 FTE 2014 FTE Change 2013 2014 Change Solid Waste Officer - LTE 0.7 0.7 - 17,838 17,838 - Overtime - - - - - TOTAL 0.7 0.7 - 17,838 17,838 - CITY OF SUN PRAIRIE 2014 APPROVED BUDGET PERSONNEL COSTS Position Title STAFFING SALARIES, WAGES & BENEFITS 81 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET INCREASE/ DECREASE ADOPTED 2014 PARKS MAINTENANCE PERSONNEL SERVICES 270,339 274,914REGULAR WAGES 248,693254,42410055055 511000 252,962 274,914 7,000 7,000OVERTIME 12,2766,05910055055 513000 13,000 7,000 00MISCELLANEOUS COMPENSATION 1,16073210055055 517000 972 0 68,000 68,000SEASONAL WAGES 59,07072,42210055055 519000 63,695 68,000 333,637 321,200 330,629 345,339 349,914 4,575SUB-TOTAL 349,914 FRINGE BENEFITS 25,738 26,433SOCIAL SECURITY 24,394 25,13410055055 521000 23,000 26,433 16,765 17,047RETIREMENT 15,400 15,41410055055 522000 15,684 17,047 63,656 66,082HEALTH INSURANCE 61,002 60,67010055055 523000 60,670 66,082 1,031 858LIFE INSURANCE 742 50310055055 524000 1,031 858 6,389 6,389DENTAL INSURANCE 6,120 5,84410055055 525000 6,389 6,389 17,400 17,400UNEMPLOYMENT COMPENSATION 12,96814,40210055055 526000 14,500 17,400 121,968 120,626 121,274 130,979 134,209 3,230SUB-TOTAL 134,209 MATERIALS AND SUPPLIES 00OFFICE SUPPLIES 0 4510055055 531000 0 0 19,700 19,700OPERATING SUPPLIES 16,532 17,28310055055 532000 19,700 19,700 25,000 25,000REPAIRS AND MAINTENANCE 19,910 25,48310055055 533000 25,000 25,000 2,000 2,000MAINTENANCE AGREEMENTS 14 010055055 533100 2,000 2,000 1,500 1,500MAINTENANCE - TURF 1,500 1,62210055055 533120 1,500 1,500 1,500 1,500MAINTENANCE - PLAYGROUNDS 2,938 2,10010055055 533130 3,000 1,500 00MAINTENANCE - SURFACE MATERIA 07,00110055055 533140 0 0 00SMALL TOOLS 7082,12410055055 534000 800 0 2,700 2,700UNIFORMS 2,9022,67110055055 535000 2,900 2,700 58,329 44,504 54,900 52,400 52,400 0SUB-TOTAL 52,400 82 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET INCREASE/ DECREASE ADOPTED 2014 CONTRACTUAL SERVICES 2,000 2,000COMMUNICATIONS 8911,14610055055 541000 2,000 2,000 29,000 29,000UTILITIES 23,76130,82710055055 542000 29,000 29,000 18,000 18,000PROFESSIONAL SERVICES 17,716010055055 544000 18,000 18,000 900 900CITY FLOWER BEDS 99984910055055 544345 999 900 930 930CONTRACTUAL SERVICES 6751,93810055055 544400 930 930 34,760 44,042 50,929 50,830 50,830 0SUB-TOTAL 50,830 PROFESSIONAL DEVELOPMENT 1,000 1,000MEETINGS AND TRAINING 1,184 1,36710055055 563000 1,000 1,000 280 280DUES AND MEMBERSHIPS 275 010055055 564000 280 280 1,367 1,459 1,280 1,280 1,280 0SUB-TOTAL 1,280 CAPITAL ITEMS 00MACHINERY & EQUIPMENT EXPENS 220010055055 581000 220 0 0 220 220 0 0 0SUB-TOTAL 0 $550,061 $532,051 $580,828 $588,633 $7,805TOTAL PARK & REC PARKS MAINTENANCE $559,232 $588,633 83 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET INCREASE/ DECREASE ADOPTED 2014 FORESTRY PERSONNEL SERVICES 29,566 30,081REGULAR WAGES 27,29429,40410065000 511000 29,566 30,081 00OVERTIME 566810065000 513000 57 0 00MISCELLANEOUS COMPENSATION 922310065000 517000 77 0 29,495 27,442 29,700 29,566 30,081 515SUB-TOTAL 30,081 FRINGE BENEFITS 2,195 2,278SOCIAL SECURITY 2,106 2,22510065000 521000 2,195 2,278 1,834 1,866RETIREMENT 1,682 1,81710065000 522000 1,834 1,866 7,796 8,092HEALTH INSURANCE 7,470 7,42810065000 523000 7,796 8,092 163 175LIFE INSURANCE 137 14610065000 524000 163 175 731 731DENTAL INSURANCE 699 69510065000 525000 731 731 12,310 12,094 12,719 12,719 13,142 423SUB-TOTAL 13,142 MATERIALS AND SUPPLIES 2,800 2,800OPERATING SUPPLIES 1,499 72510065000 532000 2,800 2,800 00REPAIRS AND MAINTENANCE 27 810065000 533000 0 0 00SMALL TOOLS 377 010065000 534000 400 0 733 1,903 3,200 2,800 2,800 0SUB-TOTAL 2,800 CONTRACTUAL SERVICES 00COMMUNICATIONS 63 7110065000 541000 50 0 71 63 50 0 0 0SUB-TOTAL 0 PROFESSIONAL DEVELOPMENT 255 255MEETINGS AND TRAINING 75 48910065000 563000 255 255 145 145DUES AND MEMBERSHIPS 270 23510065000 564000 145 145 724 345 400 400 400 0SUB-TOTAL 400 CAPITAL ITEMS 400 400MACHINERY & EQUIPMENT EXPENS 040410065000 581000 400 400 404 0 400 400 400 0SUB-TOTAL 400 $43,736 $41,847 $45,885 $46,823 $938TOTAL FORESTRY $46,469 $46,823 84 PARKS MAINTENANCE & FORESTRY 2013 FTE 2014 FTE Change 2013 2014 Change Parks/PW Supervisor 0.50 0.50 - 42,135 43,196 1,061 Maintenance Crewleader 1.00 1.00 - 70,806 72,210 1,404 Maintenance Worker 5.00 5.00 - 307,512 282,627 (24,885) Seasonal Wages - - - 73,214 73,214 - Unemployment Compensation - - - 17,400 17,400 - Overtime - - - 7,536 7,536 - TOTAL 6.50 6.50 - 518,603 496,183 (22,420) CITY OF SUN PRAIRIE 2014 APPROVED BUDGET PERSONNEL COSTS Position Title STAFFING SALARIES, WAGES & BENEFITS 85 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET INCREASE/ DECREASE ADOPTED 2014 ENGINEERING PERSONNEL SERVICES 409,180 399,701REGULAR WAGES 313,849406,21710033000 511000 335,135 399,701 4,000 4,000OVERTIME 5,53237010033000 513000 8,000 4,000 00SEASONAL WAGES 8,410010033000 519000 8,410 0 406,587 327,792 351,545 413,180 403,701 -9,479SUB-TOTAL 403,701 FRINGE BENEFITS 29,817 29,839SOCIAL SECURITY 24,550 30,13710033000 521000 26,717 29,839 25,372 24,784RETIREMENT 18,178 25,14110033000 522000 20,778 24,784 80,460 84,287HEALTH INSURANCE 62,212 76,70010033000 523000 58,423 84,287 1,254 1,152LIFE INSURANCE 979 1,07810033000 524000 960 1,152 7,515 7,606DENTAL INSURANCE 5,816 7,15410033000 525000 5,461 7,606 00POST EMPLOYMENT HEALTH PLAN 3,884 010033000 528000 3,884 0 140,209 115,619 116,223 144,418 147,668 3,250SUB-TOTAL 147,668 MATERIALS AND SUPPLIES 750 650OFFICE SUPPLIES 416 88410033000 531000 750 650 2,500 2,130OPERATING SUPPLIES 719 1,87010033000 532000 2,000 2,130 1,075 1,075REPAIRS AND MAINTENANCE 0 52810033000 533000 1,075 1,075 4,825 5,080MAINTENANCE AGREEMENTS 4,031 4,03110033000 533100 4,825 5,080 7,313 5,166 8,650 9,150 8,935 -215SUB-TOTAL 8,935 CONTRACTUAL SERVICES 4,750 5,400COMMUNICATIONS 3,515 3,54810033000 541000 4,750 5,400 00PROFESSIONAL SERVICES 0 010033000 544000 45,000 0 3,548 3,515 49,750 4,750 5,400 650SUB-TOTAL 5,400 PROFESSIONAL DEVELOPMENT 00MILEAGE 0 5210033000 562000 0 0 1,195 2,000MEETINGS AND TRAINING 1,242 1,71810033000 563000 1,243 2,000 650 665DUES AND MEMBERSHIPS 0 52610033000 564000 650 665 175 175PUBLICATIONS AND SUBSCRIPTION 87 17410033000 566000 175 175 2,470 1,329 2,068 2,020 2,840 820SUB-TOTAL 2,840 $560,127 $453,422 $573,518 $568,544 $-4,974TOTAL ENGINEERING $528,236 $568,544 86 ENGINEERING DEPARTMENT 2013 FTE 2014 FTE Change 2013 2014 Change City Engineer 1.0 1.0 - 115,906 118,270 2,364 Staff Engineer 2.0 2.0 - 183,819 184,724 905 Senior Engineering Technician 1.0 1.0 - 87,733 89,832 2,099 Engineering Technician 2.0 2.0 - 142,986 140,275 (2,711) Secretary 0.5 0.25 (0.25) 23,154 14,031 (9,123) Seasonal Pay - - - - - - Overtime - - - 4,000 4,000 - TOTAL 6.5 6.3 (0.3) 557,598 551,132 (6,466) CITY OF SUN PRAIRIE 2014 APPROVED BUDGET PERSONNEL COSTS Position Title STAFFING SALARIES, WAGES & BENEFITS 87 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET INCREASE/ DECREASE ADOPTED 2014 ECONOMIC DEVELOPMENT PERSONNEL SERVICES 99,216 74,413REGULAR WAGES 67,11294,56210062000 511000 72,744 74,413 94,562 67,112 72,744 99,216 74,413 -24,803SUB-TOTAL 74,413 FRINGE BENEFITS 7,555 5,635SOCIAL SECURITY 5,102 7,20010062000 521000 5,528 5,635 6,152 4,614RETIREMENT 4,161 5,86310062000 522000 4,510 4,614 19,435 13,486HEALTH INSURANCE 12,449 12,38410062000 523000 12,991 13,486 86 83LIFE INSURANCE 81 12810062000 524000 85 83 1,829 1,217DENTAL INSURANCE 1,166 1,15810062000 525000 1,217 1,217 26,733 22,958 24,331 35,057 25,035 -10,022SUB-TOTAL 25,035 MATERIALS AND SUPPLIES 250 100OFFICE SUPPLIES 39 41310062000 531000 250 100 413 39 250 250 100 -150SUB-TOTAL 100 CONTRACTUAL SERVICES 1,000 1,600COMMUNICATIONS 733 1,49210062000 541000 1,000 1,600 1,000 380ADVERTISING AND PRINTING 45 25010062000 543000 1,000 380 10,000 8,600MARKETING 1,077 3,05410062000 543500 1,500 8,600 00PROFESSIONAL SERVICES 0 2010062000 544000 0 0 4,816 1,855 3,500 12,000 10,580 -1,420SUB-TOTAL 10,580 PROFESSIONAL DEVELOPMENT 250 100MILEAGE 0 010062000 562000 250 100 2,600 2,300MEETINGS AND TRAINING 615 86010062000 563000 2,600 2,300 600 1,260DUES AND MEMBERSHIPS 275 1,31010062000 564000 600 1,260 500 1,110PUBLICATIONS AND SUBSCRIPTION 452 43210062000 566000 500 1,110 2,602 1,342 3,950 3,950 4,770 820SUB-TOTAL 4,770 $129,126 $93,305 $150,473 $114,898 $-35,575TOTAL ECONOMIC DEVELOPMENT $104,775 $114,898 88 ECONOMIC DEVELOPMENT 2013 FTE 2014 FTE Change 2013 2014 Change Econ. Development Director 1.0 1.0 - 97,401 99,441 2,040 Econ. Development Specialist 0.5 - (0.5) 36,872 (36,872) TOTAL 1.5 1.0 (0.5) 134,273 99,441 (34,832) CITY OF SUN PRAIRIE 2014 APPROVED BUDGET PERSONNEL COSTS Position Title STAFFING SALARIES, WAGES & BENEFITS 89 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET INCREASE/ DECREASE ADOPTED 2014 HISTORICAL MUSEUM PERSONNEL SERVICES 6,710 10,241REGULAR WAGES 5,8016,73510053000 511000 6,710 10,241 6,735 5,801 6,710 6,710 10,241 3,531SUB-TOTAL 10,241 FRINGE BENEFITS 514 786SOCIAL SECURITY 444 51510053000 521000 514 786 00UNEMPLOYMENT COMPENSATION -20 2010053000 526000 0 0 535 424 514 514 786 272SUB-TOTAL 786 MATERIALS AND SUPPLIES 400 400OFFICE SUPPLIES 429 12410053000 531000 429 400 8,300 8,300OPERATING SUPPLIES 6,473 9,09510053000 532000 8,300 8,300 3,200 3,200REPAIRS AND MAINTENANCE 2,622 1,49410053000 533000 3,200 3,200 2,000 2,000MAINTENANCE AGREEMENTS 1,606 2,32210053000 533100 2,000 2,000 275 275JANITORIAL SERVICES 400 010053000 533200 500 275 100 100SMALL TOOLS 83 13010053000 534000 100 100 13,166 11,612 14,529 14,275 14,275 0SUB-TOTAL 14,275 CONTRACTUAL SERVICES 1,130 1,130COMMUNICATIONS 946 1,00410053000 541000 1,130 1,130 3,600 3,600UTILITIES 3,380 3,57310053000 542000 3,600 3,600 750 750ADVERTISING AND PRINTING 682 88510053000 543000 750 750 750 750PROFESSIONAL SERVICES 371 59510053000 544000 750 750 6,057 5,379 6,230 6,230 6,230 0SUB-TOTAL 6,230 CAPITAL ITEMS 0 750MACHINERY & EQUIPMENT EXPENS 2,322010053000 581000 492 750 0 2,322 492 0 750 750SUB-TOTAL 750 CAPITAL PROJECTS 3,925 400OFFICE FURNITURE & EQUIPMENT 219 010053000 588000 2,544 400 0 219 2,544 3,925 400 -3,525SUB-TOTAL 400 90 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET INCREASE/ DECREASE ADOPTED 2014 Others 00BUILDING IMPROVEMENTS 8883,92510053000 584000 889 0 3,925 888 889 0 0 0SUB-TOTAL 0 $30,418 $26,645 $31,654 $32,682 $1,028TOTAL HISTORICAL MUSEUM $31,908 $32,682 91 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET INCREASE/ DECREASE ADOPTED 2014 LIBRARY ADMINISTRATION PERSONNEL SERVICES 859,033 890,563REGULAR WAGES 782,144843,94910052041 511000 850,000 890,563 00OVERTIME 06710052041 513000 0 0 1,400 1,400PREMIUM PAY 1,0681,16510052041 516000 1,400 1,400 4,628 4,628SEASONAL WAGES 4,6163,10910052041 519000 4,628 4,628 848,290 787,828 856,028 865,061 896,591 31,530SUB-TOTAL 896,591 FRINGE BENEFITS 63,152 65,473SOCIAL SECURITY 57,315 61,92510052041 521000 63,152 65,473 43,340 45,229RETIREMENT 39,960 43,24910052041 522000 43,340 45,229 132,419 137,774HEALTH INSURANCE 122,555 124,04010052041 523000 132,419 137,774 2,162 2,215LIFE INSURANCE 1,925 2,08610052041 524000 2,162 2,215 12,318 12,610DENTAL INSURANCE 11,877 11,98710052041 525000 12,318 12,610 243,287 233,632 253,391 253,391 263,301 9,910SUB-TOTAL 263,301 MATERIALS AND SUPPLIES 2,500 2,000OFFICE SUPPLIES 1,903 2,03410052041 531000 2,500 2,000 00WORK PERMITS 30 1010052041 532150 10 0 1,000 1,000REPAIRS AND MAINTENANCE 655 99610052041 533000 1,000 1,000 13,588 13,000MAINTENANCE AGREEMENTS 10,777 8,54810052041 533100 13,588 13,000 11,589 13,365 17,098 17,088 16,000 -1,088SUB-TOTAL 16,000 CONTRACTUAL SERVICES 3,500 3,500COMMUNICATIONS 3,051 3,36010052041 541000 3,500 3,500 4,000 4,000SPECIAL PROGRAMS 4,010 3,99910052041 542500 4,000 4,000 1,000 1,000SPECIAL PROGRAMS 886 1,00310052041 542500 1,000 1,000 300 300ADVERTISING AND PRINTING 308 26010052041 543000 300 300 8,623 8,254 8,800 8,800 8,800 0SUB-TOTAL 8,800 92 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET INCREASE/ DECREASE ADOPTED 2014 PROFESSIONAL DEVELOPMENT 500 500MILEAGE 39249110052041 562000 500 500 1,600 1,600MEETINGS AND TRAINING 7592,00910052041 563000 1,600 1,600 1,060 1,000DUES AND MEMBERSHIPS 1,05565010052041 564000 1,060 1,000 3,150 2,206 3,160 3,160 3,100 -60SUB-TOTAL 3,100 $1,114,939 $1,045,285 $1,147,500 $1,187,792 $40,292TOTAL LIBRARY ADMINISTRATION $1,138,477 $1,187,792 93 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET INCREASE/ DECREASE ADOPTED 2014 LIBRARY COLLECTION MATERIALS AND SUPPLIES 13,708 13,708OPERATING SUPPLIES 5,62912,44510052042 532000 13,708 13,708 176,107 181,390LIBRARY MATERIALS 167,207174,96110052042 532200 176,107 181,390 187,406 172,835 189,815 189,815 195,098 5,283SUB-TOTAL 195,098 CONTRACTUAL SERVICES 00COMMUNICATIONS 42 3110052042 541000 0 0 79,662 84,311PROFESSIONAL SERVICES 83,434 79,41010052042 544000 83,434 84,311 79,441 83,476 83,434 79,662 84,311 4,649SUB-TOTAL 84,311 $266,847 $256,312 $269,477 $279,409 $9,932TOTAL LIBRARY COLLECTION $273,249 $279,409 94 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET INCREASE/ DECREASE ADOPTED 2014 LIBRARY BUILDINGS AND GROUNDS MATERIALS AND SUPPLIES 3,500 3,000OPERATING SUPPLIES 1,80480710052043 532000 3,500 3,000 7,500 7,000REPAIRS AND MAINTENANCE 6,1977,29110052043 533000 7,500 7,000 2,400 2,400MAINTENANCE AGREEMENTS 5481,97610052043 533100 2,400 2,400 20,500 21,500JANITORIAL SERVICES 17,24216,46310052043 533200 20,500 21,500 26,538 25,791 33,900 33,900 33,900 0SUB-TOTAL 33,900 CONTRACTUAL SERVICES 00COMMUNICATIONS 250 60210052043 541000 250 0 60,000 56,000UTILITIES 43,061 52,11410052043 542000 60,000 56,000 52,715 43,311 60,250 60,000 56,000 -4,000SUB-TOTAL 56,000 CAPITAL ITEMS 00MACHINERY & EQUIPMENT EXPENS 5,32515,72910052043 581000 5,325 0 15,729 5,325 5,325 0 0 0SUB-TOTAL 0 CAPITAL PROJECTS 10,000 10,000OFFICE FURNITURE & EQUIPMENT 694 1,20710052043 588000 10,000 10,000 20,500 20,500MACHINERY & EQPMNT - REPLACED 12,32714,42610052043 589000 20,500 20,500 15,633 13,020 30,500 30,500 30,500 0SUB-TOTAL 30,500 $110,615 $87,447 $124,400 $120,400 $-4,000TOTAL LIBRARY BUILDINGS AND GROUNDS $129,975 $120,400 95 PUBLIC LIBRARY 2013 FTE 2014 FTE Change 2013 2014 Change Library Director 1.0 1.0 - 104,253 106,428 2,175 Technical Services Librarian 1.0 1.0 - 85,284 87,270 1,986 Adult Services Librarian 1.0 1.0 - 76,429 78,242 1,813 Youth Services Librarian 1.0 1.0 - 76,120 77,918 1,798 Young Adult Services Librarian 0.5 0.5 - 26,811 27,450 639 Reference Librarian 1.0 0.63 (0.37) 48,136 31,181 (16,955) Circulation Manager 1.0 1.0 - 74,102 75,751 1,649 Assistant Circulation Manager 0.8 - (0.8) 45,002 (45,002) Public Services Librarian 1.0 1.0 59,253 59,253 Secretary 0.9 1.0 0.1 37,448 43,237 5,789 Computer Technician 1.0 1.0 - 67,664 69,018 1,354 Library Assistant II 3.0 3.0 - 137,148 139,799 2,651 Library Assistant I 6.5 7.8 1.3 230,401 254,591 24,190 Page II 2.2 2.2 - 61,131 62,421 1,290 Page I 1.8 1.64 (0.16) 42,034 33,620 (8,414) LTE/Summer 0.1 0.1 - 4,982 5,026 44 Holiday/Premium Pay - - - 1,507 1,507 0 Overtime - - - - - - TOTAL 22.7 23.8 1.1 1,118,452 1,152,712 34,260 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET PERSONNEL COSTS Position Title STAFFING SALARIES, WAGES & BENEFITS 96 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET INCREASE/ DECREASE ADOPTED 2014 SENIOR CITIZENS PROGRAM CONTRACTUAL SERVICES 155,000 160,000PROFESSIONAL SERVICES 155,000155,00010054100 544000 155,000 160,000 155,000 155,000 155,000 155,000 160,000 5,000SUB-TOTAL 160,000 $155,000 $155,000 $155,000 $160,000 $5,000TOTAL SENIOR CITIZENS PROGRAM $155,000 $160,000 97 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET ACTUAL ACTUAL PROJECTED BUDGET RECOMMENDED ADOPTED INCREASE/ YOUTH & FAMILIES COMMISSION PERSONNEL SERVICES 2012 2013 YTD 2013 2013 2014 2014 DECREASE 10054200 514000 BOARDS AND COMMITTEES 1,020 1,020 1,750 1,750 1,750 1,750 FRINGE BENEFITS SUB-TOTAL 1,020 1,020 1,750 1,750 1,750 1,750 0 10054200 521000 SOCIAL SECURITY 78 78 100 0 0 0 SUB-TOTAL CONTRACTUAL SERVICES 78 78 100 0 0 0 0 10054200 541000 COMMUNICATIONS 6 80 60 0 0 0 SUB-TOTAL PROFESSIONAL DEVELOPMENT 6 80 60 0 0 0 0 10054200 562000 10054200 563000 MILEAGE MEETINGS AND TRAINING 185 685 32 218 0 590 0 0 750 750 0 750 SUB-TOTAL 870 250 590 750 750 750 0 TOTAL YOUTH & FAMILIES COMMISSION $1,975 $1,428 $2,500 $2,500 $2,500 $2,500 $0 YOUTH & FAMILY COMMISSION: CARRYOVER BALANCE 2012 2013 2013 2013 2014 ACTUAL YTD ACTUAL PROJECTED BUDGET RECOMMENDED BEGINNING FUND BALANCE 2,632 3,157 3,157 3,157 3,907 ADDITIONS 2,500 2,500 2,500 2,500 2,500 EXPENSES 1,975 1,428 1,750 1,428 2,500 ENDING FUND BALANCE 3,157 4,229 3,907 4,229 3,907 98 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET INCREASE/ DECREASE ADOPTED 2014 RECREATION ADMINISTRATION PERSONNEL SERVICES 138,131 141,836REGULAR WA GES 119,620137,19710055051 511000 127,296 141,836 00OVER TIME 47112510055051 513000 800 0 900 900BOARDS AND COMMITTEES 10094010055051 514000 900 900 138,262 120,191 128,996 139,031 142,736 3,705SUB-TOTAL 142,736 FRINGE BENEFITS 10,315 10,648SOCIAL SECURITY 8,706 10,34310055051 521000 9,675 10,648 8,566 8,795RETIREMENT 7,004 7,50610055051 522000 7,892 8,795 25,982 26,972HEALTH INSURANCE 24,899 21,67210055051 523000 25,982 26,972 180 314LIFE INSURANCE 140 15710055051 524000 180 314 2,434 2,434DENTAL INSURANCE 2,331 2,02710055051 525000 2,434 2,434 41,706 43,080 46,163 47,477 49,163 1,686SUB-TOTAL 49,163 MATERIALS AND SUPPLIES 1,390 1,390OFFICE SUPPLIES 832 1,38910055051 531000 1,390 1,390 00OPERATING SUPPLIES 0 610055051 532000 0 0 200 200WORK PERMITS 250 18010055051 532150 250 200 6,000 12,933BANK SERVICE CHARGES 5,469 5,66610055051 532500 6,000 12,933 3,000 3,000MAINTENANCE AGREEMENTS 2,100 2,20810055051 533100 3,000 3,000 9,450 8,651 10,640 10,590 17,523 6,933SUB-TOTAL 17,523 CONTRACTUAL SERVICES 4,500 5,700COMMUNICATIONS 6,147 6,18510055051 541000 5,000 5,700 1,500 1,500ADVERTISING AND PRINTING 1,190 3,39210055051 543000 1,500 1,500 1,500 1,000PROFESSIONAL SERVICES 0 010055051 544000 1,500 1,000 9,577 7,336 8,000 7,500 8,200 700SUB-TOTAL 8,200 PROFESSIONAL DEVELOPMENT 2,000 2,000MILEAGE 816 82210055051 562000 1,000 2,000 1,900 1,900MEETINGS AND TRAINING 927 1,13010055051 563000 1,900 1,900 710 710DUES AND MEMBERSHIPS 680 26110055051 564000 710 710 100 100PUBLICATIONS AND SUBSCRIPTION 0 7710055051 566000 100 100 2,290 2,423 3,710 4,710 4,710 0SUB-TOTAL 4,710 99 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET INCREASE/ DECREASE ADOPTED 2014 CAPITAL PROJECTS 1,700 0OFFICE FURNITURE & EQUIPMENT 1,192010055051 588000 1,700 0 0 1,192 1,700 1,700 0 -1,700SUB-TOTAL 0 $201,283 $182,874 $211,008 $222,332 $11,324TOTAL PARK & REC ADMINISTRATION $199,209 $222,332 100 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET INCREASE/ DECREASE ADOPTED 2014 PARK & REC SUMMER RECREATION PERSONNEL SERVICES 62,500 63,614REGULAR WAGES 63,08852,19910055053 511000 62,500 63,614 00OVERTIME 2613110055053 513000 261 0 52,230 63,348 62,761 62,500 63,614 1,114SUB-TOTAL 63,614 FRINGE BENEFITS 4,965 5,051SOCIAL SECURITY 4,743 3,99810055053 521000 4,965 5,051 00UNEMPLOYMENT COMPENSATION 0 3110055053 526000 0 0 4,029 4,743 4,965 4,965 5,051 86SUB-TOTAL 5,051 MATERIALS AND SUPPLIES 13,544 13,544OPERATING SUPPLIES 10,735 10,50310055053 532000 11,000 13,544 251 0CONCESSION SUPPLIES 0 010055053 532300 0 0 10,503 10,735 11,000 13,795 13,544 -251SUB-TOTAL 13,544 8,200 2,000ADVERTISING AND PRINTING 2,764 6,61410055053 543000 3,000 2,000 13,000 20,251PROFESSIONAL SERVICES 27,162 14,49210055053 544000 24,150 20,251 2,400 2,400TRANSPORTATION SERVICES 2,255 74510055053 544200 2,400 2,400 2,600 1,600COMMISSIONED SALES 0 1,20010055053 544300 0 1,600 23,051 32,181 29,550 26,200 26,251 51SUB-TOTAL 26,251 PROFESSIONAL DEVELOPMENT 00MEETINGS AND TRAINING 54 010055053 563000 55 0 0 54 55 0 0 0SUB-TOTAL 0 $89,813 $111,061 $107,460 $108,460 $1,000TOTAL PARK & REC SUMMER RECREATION $108,331 $108,460 101 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET INCREASE/ DECREASE ADOPTED 2014 PARK & REC WINTER RECREATION PERSONNEL SERVICES 18,000 18,278REGULAR WAGES 19,68417,95310055054 511000 27,000 18,278 17,953 19,684 27,000 18,000 18,278 278SUB-TOTAL 18,278 FRINGE BENEFITS 1,360 1,382SOCIAL SECURITY 1,843 1,37410055054 521000 2,065 1,382 1,374 1,843 2,065 1,360 1,382 22SUB-TOTAL 1,382 MATERIALS AND SUPPLIES 4,500 4,500OPERATING SUPPLIES 3,053 4,67310055054 532000 4,500 4,500 4,673 3,053 4,500 4,500 4,500 0SUB-TOTAL 4,500 CONTRACTUAL SERVICES 8,000 2,000ADVERTISING AND PRINTING 0 6,56610055054 543000 1,000 2,000 13,000 19,000PROFESSIONAL SERVICES 14,480 14,65810055054 544000 13,000 19,000 1,300 1,300TRANSPORTATION SERVICES 0 1,56010055054 544200 1,300 1,300 500 500COMMISSIONED SALES 0 010055054 544300 500 500 22,783 14,480 15,800 22,800 22,800 0SUB-TOTAL 22,800 $46,783 $39,059 $46,660 $46,960 $300TOTAL PARK & REC WINTER RECREATION $49,365 $46,960 102 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET INCREASE/ DECREASE ADOPTED 2014 PARK & REC PARK CONCERTS MATERIALS AND SUPPLIES 00OPERATING SUPPLIES 53914810055057 532000 539 0 148 539 539 0 0 0SUB-TOTAL 0 CONTRACTUAL SERVICES 2,000 2,000PROFESSIONAL SERVICES 3,325 2,81010055057 544000 3,325 2,000 2,810 3,325 3,325 2,000 2,000 0SUB-TOTAL 2,000 $2,958 $3,864 $2,000 $2,000 $0TOTAL PARK & REC PARK CONCERTS $3,864 $2,000 103 RECREATION 2013 FTE 2014 FTE Change 2013 2014 Change Park, Rec, Forestry Director - - - - - - Recreation Supervisor 1.00 1.00 - 82,278 87,428 5,150 Recreation Coordinator 1.00 1.00 - 66,777 68,383 1,606 Secretary 1.00 1.00 - 34,325 35,064 739 Summer Rec Wages - - - 67,465 68,480 1,015 Winter Rec Wages - - - 19,360 19,676 316 Boards & Committees - - - 900 900 - TOTAL 3.00 3.00 - 271,105 279,932 8,827 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET PERSONNEL COSTS Position Title STAFFING SALARIES, WAGES & BENEFITS 104 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET INCREASE/ DECREASE ADOPTED 2014 FAC FUND EXPENSES PERSONNEL SERVICES 142,289 145,075REGULAR WAGES 124,811 146,44125555052 511000 124,812 145,075 00OVERTIME 209 12625555052 513000 210 0 146,567 125,020 125,022 142,289 145,075 2,786SUB-TOTAL 145,075 FRINGE BENEFITS 10,886 11,100SOCIAL SECURITY 9,564 11,21325555052 521000 9,574 11,100 11,213 9,564 9,574 10,886 11,100 214SUB-TOTAL 11,100 MATERIALS AND SUPPLIES 9,300 9,300OPERATING SUPPLIES 10,179 8,28625555052 532000 9,194 9,300 12,000 12,000CONCESSION SUPPLIES 12,013 18,10325555052 532300 12,423 12,000 14,000 14,000CHEMICALS 14,000 15,57325555052 532350 14,000 14,000 1,228 1,228OPERATING PERMITS & LICENSES 1,3101,22825555052 532400 1,310 1,228 7,500 7,500REPAIRS AND MAINTENANCE 8,725 15,87325555052 533000 8,116 7,500 00SMALL TOOLS 167 025555052 534000 167 0 59,063 46,394 45,210 44,028 44,028 0SUB-TOTAL 44,028 CONTRACTUAL SERVICES 450 1,100COMMUNICATIONS 1,062 93625555052 541000 657 1,100 33,000 33,000UTILITIES 40,268 35,13825555052 542000 37,939 33,000 00ADVERTISING AND PRINTING 0 7825555052 543000 0 0 4,405 4,405PROFESSIONAL SERVICES 1,045 73525555052 544000 610 4,405 36,887 42,375 39,206 37,855 38,505 650SUB-TOTAL 38,505 PROFESSIONAL DEVELOPMENT 00MEETINGS AND TRAINING 535 94925555052 563000 535 0 949 535 535 0 0 0SUB-TOTAL 0 CAPITAL PROJECTS 6,900 6,900MACHINERY & EQPMNT - REPLACED 4,52646,19825555052 589000 4,526 6,900 46,198 4,526 4,526 6,900 6,900 0SUB-TOTAL 6,900 $300,876 $228,414 $241,958 $245,608 $3,650TOTAL FAC FUND EXPENSES $224,073 $245,608 105 FAMILY AQUATIC CENTER 2013 FTE 2014 FTE Change 2013 2014 Change Seasonal Wages * * * 153,175 156,173 2,998 TOTAL - - - 153,175 156,173 2,998 * Includes both wage and benefit costs CITY OF SUN PRAIRIE 2014 APPROVED BUDGET PERSONNEL COSTS Position Title STAFFING SALARIES, WAGES & BENEFITS 106 2012 2013 2013 2013 2014 INCREASE ACTUAL YTD ACTUAL PROJECTED BUDGET RECOMMENDED (DECREASE) TEEN COURT PROGRAM (200-120) TEEN COURT REVENUES 20004300-435000 STATE GRANTS - GENERAL -$ - $ - $ - $ -$ -$ 20004700-471000 INVESTMENT INCOME 15 - - - - TOTAL TEEN COURT REVENUES 15 - - - - - TEEN COURT EXPENDITURES 20012000-544000 PROFESSIONAL SERVICES - - - - - - 20012000-572000 TRANSFER OUT - 6,000 6,000 6,000 6,000 - TOTAL TEEN COURT EXPENDITURES -$ 6,000$ 6,000$ 6,000 $ 6,000$ -$ TEEN COURT: FUND BALANCE BEGINNING FUND BALANCE 16,329 16,344 16,344 16,344 10,344 ADDITIONS 15 - - - - EXPENSES - 6,000 6,000 6,000 6,000 ENDING FUND BALANCE 16,344 10,344 10,344 10,344 4,344 POLICE PROGRAMS (200-210) POLICE PROGRAM REVENUES 20004300-435210 GRANTS - POLICE 53,748$ -$ 3,350$ 3,350 $ -$ (3,350)$ 20004700-471000 INVESTMENT INCOME 29 - 30 30 - (30) 20004800-485210 DONATIONS - POLICE 8,041 850 2,500 5,000 2,500 (2,500) 20004800-489000 MISCELLANEOUS REVENUES 95 5,520 - 2,500 2,500 TOTAL POLICE PROGRAM REVENUES 61,913 6,370 5,880 8,380 5,000 (3,380) POLICE PROGRAM EXPENDITURES 20021000-511000 REGULAR WAGES 40 40 40 - - - 20021000-513000 OVERTIME - - - - - - 20021000-521000 SOCIAL SECURITY 3 3 3 - - - 20021000-522000 RETIREMENT - - - - - - 20021000-532000 OPERATING SUPPLIES 4,874 7,535 7,535 5,000 6,000 1,000 20021000-532000 OPERATING SUPPLIES: K9 PROGRAM 2,950 836 3,000 3,000 3,000 - 20021000-544000 PROFESSIONAL SERVICES - - - - - - 20021000-544000 SHOP WITH A COP 4,020 4,000 4,000 4,000 - 20021000-544000 NATIONAL NIGHT OUT - - - 1,000 - (1,000) 20021000-544000 MPSISC GRANT FUNDED PROJECTS 44,888 - - - - - 20021000-563000 MEETINGS AND TRAINING - - - - - - 20021000-581000 MACHINERY & EQUIPMENT EXPENSE 5,014 - - - - - 20021000-581100 MINOR CAPITAL - - - - - - 20021000-582000 VEHICLES - - - - - - 20021000-572000 TRANSFER OUT - 2,781 2,781 - - - TOTAL POLICE PROGRAM EXPENDITURES 61,789$ 11,195$ 17,359$ 13,000 $ 13,000$ -$ POLICE PROGRAMS: FUND BALANCE BEGINNING FUND BALANCE 32,300 32,424 32,424 32,424 20,945 ADDITIONS 61,913 6,370 5,880 8,380 5,000 EXPENSES 61,789 11,195 17,359 13,000 13,000 ENDING FUND BALANCE 32,424 27,599 20,945 27,804 12,945 CITY OF SUN PRAIRIE 2013 RECOMMENDED BUDGET SPECIAL REVENUE FUND 107 2012 2013 2013 2013 2014 INCREASE ACTUAL YTD ACTUAL PROJECTED BUDGET RECOMMENDED (DECREASE) CITY OF SUN PRAIRIE 2013 RECOMMENDED BUDGET SPECIAL REVENUE FUND TAXI PROGRAM (200-350) TAXI PROGRAM REVENUES 20004300-435350 STATE AID - TRANSIT 386,547$ 236,688 $ 315,585 $ 335,000 $ 395,000$ 60,000 20004800-485350 DONATIONS - TAXI PROGRAM 2,800 940 1,000 3,000 3,000 - 20004900-492100 TRANSFER IN 82,500 82,500 82,500 82,500 89,780 7,280 TOTAL TAXI PROGRAM REVENUES 471,847 320,128 399,085 420,500 487,780 67,280 TAXI PROGRAM EXPENDITURES 20035000-533000 REPAIRS AND MAINTENANCE - - - - - - 20035000-544000 PROF SVCS: TAXI CONTRACT 449,266 329,736 490,000 440,000 467,280 27,280 20035000-544000 PROF SVCS: REDUCED FARE PRGM 23,757 13,578 20,367 16,500 20,500 4,000 20035000-582000 VEHICLES - - - - - TOTAL TAXI PROGRAM EXPENDITURES 473,023 $ 343,314 $ 510,367 $ 456,500 $ 487,780$ 31,280 TAXI PROGRAM: FUND BALANCE BEGINNING FUND BALANCE (35,422) (36,598) (36,598) (36,598) (36,598) ADDITIONS 471,847 320,128 399,085 420,500 487,780 EXPENSES 473,023 343,314 510,367 456,500 487,780 ENDING FUND BALANCE (36,598) (59,784) (147,880) (72,598) (36,598) PLUS PRIOR YEAR PAYMENTS DUE FROM STATE 63,261 63,261 63,261 94,820 94,820 NET PROGRAM BALANCE 26,663 3,477 (84,619) 22,222 58,222 LIBRARY PROGRAMS (200-520) LIBRARY PROGRAM REVENUES 20004300-435520 GRANTS - LIBRARY 1,450$ 587$ 2,000$ -$ -$ 20004300-437520 COUNTY AID - LIBRARY - - - - - - 20004700-471000 INVESTMENT INCOME 8 - - - - 20004800-485520 DONATIONS - LIBRARY 7,901 6,140 6,000 - - TOTAL LIBRARY PROGRAM REVENUES 9,359 6,727 8,000 - - - LIBRARY PROGRAM EXPENDITURES 20052000-532000 OPERATING SUPPLIES - - - - - 20052000-532000 OP SUPPLIES: GRANT PROJECTS 1,032 700 2,000 - - 20052000-532000 OP SUPPLIES: DONATION PROJECTS 6,524 5,659 6,000 - - 20052000-532200 LIBRARY MATERIALS - - - - - 20052000-532000 RENTAL LIBRARY MATERIALS - - - - - 20052000-532000 PROFESSIONAL SERVICES - - - - - TOTAL LIBRARY PROGRAM EXPENDITURES 7,556 $ 6,359 $ 8,000 $ - $ -$ -$ LIBRARY PROGRAMS: FUND BALANCE BEGINNING FUND BALANCE 6,877 8,680 8,680 8,680 8,680 ADDITIONS 9,359 6,727 8,000 - - EXPENSES 7,556 6,359 8,000 - - ENDING FUND BALANCE 8,680 9,048 8,680 8,680 8,680 108 2012 2013 2013 2013 2014 INCREASE ACTUAL YTD ACTUAL PROJECTED BUDGET RECOMMENDED (DECREASE) CITY OF SUN PRAIRIE 2013 RECOMMENDED BUDGET SPECIAL REVENUE FUND MUSEUM PROGRAMS (200-530) MUSEUM REVENUES 20004800-485530 DONATIONS - MUSEUM 1,961$ 547$ 1,500$ - $ -$ -$ 20004700-471000 INVESTMENT INCOME 13 - - - - - 20004900-492100 TRANSFER IN - - - - - - TOTAL MUSEUM REVENUES 1,974 547 1,500 - - - MUSEUM EXPENDITURES 20053000-581000 MACHINERY & EQUIPMENT EXPENSE 4,388 314 5,000 - - 20069000-572000 TRANSFER OUT - - - - - - TOTAL MUSEUM EXPENDITURES 4,388$ 314$ 5,000$ - $ -$ -$ MUSEUM PROGRAMS: FUND BALANCE BEGINNING FUND BALANCE 15,196 12,782 12,782 12,782 9,282 ADDITIONS 1,974 547 1,500 - - EXPENSES 4,388 314 5,000 - - ENDING FUND BALANCE 12,782 13,015 9,282 12,782 9,282 TOURISM COMMISSION (200-575) TOURISM REVENUES 20004100-414000 PUBLIC ACCOMODATION TAX 37,454$ 18,429$ 35,000$ 35,000 $ 35,000$ -$ 20004600-466600 ADVERTISING FEES - - - - - - 20004700-471000 INVESTMENT INCOME 73 40 - - - - 20004900-489000 MISCELLANEOUS - - - - - - TOTAL TOURISM REVENUES 37,527 18,469 35,000 35,000 35,000 - TOURISM EXPENDITURES 20057500-544000 PROFESSIONAL SERVICES 18,238 23,135 27,720 27,720 27,720 - 20057500-563000 MEETINGS AND TRAINING - - - - - - 20057500-572000 TRANSFER OUT - - - - - - TOTAL TOURISM EXPENDITURES 18,238$ 23,135$ 27,720$ 27,720 $ 27,720$ - TOURISM COMMISSION: FUND BALANCE BEGINNING FUND BALANCE 61,586 80,875 80,875 80,875 76,209 ADDITIONS 37,527 18,469 35,000 35,000 35,000 EXPENSES 18,238 23,135 27,720 27,720 27,720 ENDING FUND BALANCE 80,875 76,209 88,155 88,155 83,489 SPECIAL REVENUE FUND TOTALS BEGINNING FUND BALANCE 94,697$ 114,507$ 114,507$ 114,507 $ 88,862$ ADDITIONS 595,758 352,241 449,465 463,880 527,780 EXPENSES 575,948 390,317 574,446 503,220 534,500 ENDING FUND BALANCE 114,507 $ 76,431 $ (10,474)$ 75,167 $ 82,142$ 109 312,043 56,850 56,850 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET - Transportation Impact Fee Fund TRANS IMPFEE CHARGES FOR SVCS ACTUAL 2012 ACTUAL 2013 YTD PROJECTED 2013 BUDGET 2013 RECOMMENDED 2014 ADOPTED 2014 INCREASE/ DECREASE 21004600 469210 IMPACT FEES - SINGLE FAMILY 6,165 21,747 6,850 6,850 6,850 20,000 13,150 21004600 469220 IMPACT FEES - MULTI FAMILY 29,573 80,327 0 0 0 20,000 20,000 21004600 469230 IMPACT FEES - NON-RESIDENTIA 569,694 202,473 100,000 100,000 100,000 400,000 300,000 SUB-TOTAL 605,432 304,547 106,850 106,850 106,850 440,000 333,150 TOTAL TRANS IMPFEE CHARGES FOR SVCS TRANS IMPFEE INVESTMENT INCOME $605,432 $304,547 $106,850 $106,850 $106,850 $440,000 $333,150 21004700 471000 INVESTMENT INCOME 960 7,496 0 0 0 0 0 SUB-TOTAL 960 7,496 0 0 0 0 0 TOTAL TRANS IMPFEE INVESTMENT INCOME TRANS IMPFEE CAPITAL OUTLAY $960 $7,496 $0 $0 $0 $0 $0 21070000 572000 TRANSFER OUT -231,426 0 -50,000 -50,000 -50,000 -1,110,807 -1,060,807 SUB-TOTAL -231,426 0 -50,000 -50,000 -50,000 -1,110,807 -1,060,807 TOTAL TRANS IMPFEE CAPITAL OUTLAY $-231,426 $0 $-50,000 $-50,000 $-50,000 $-1,110,807 $-1,060,807 FUND TOTAL: 374,966 56,850 -670,807 -727,657 TRANSPORTATION IMPACT FEE:  FUND BALANCE  2012  2013  2013  2014  2014  ACTUAL  BUDGET  PROJECTED  RECOMMENDED  APPROVED  BEGINNING FUND BALANCE   $              1,346,303   $              1,721,269   $              1,721,269    $               1,778,119   $              1,778,119  ADDITIONS                       606,392                        106,850                        106,850                         440,000                        440,000  EXPENSES                       231,426                           50,000                          50,000                      1,110,807                     1,110,807  ENDING FUND BALANCE   $              1,721,269   $              1,778,119   $              1,778,119    $               1,107,312   $              1,107,312  110 2012 2013 2013 2013 2014 2014 INCREASE ACTUAL YTD ACTUAL PROJECTED BUDGET RECOMMENDED APPROVED (DECREASE) PARK FUND (250) PARK FUND REVENUES 25004400-443600 PARK FEES - BUILDING PERMITS 60,582 $ 133,209 $ 130,000 $ 25,000 $ 50,000 $ 50,000 $ 25,000 $ 25004400-443610 PARK FEES - DEVELOPMENT AGMNTS 136,745 (11,136) 35,000 35,000 14,000 14,000 (21,000) 25004600-465500 PARKS MISCELLANEOUS CHARGES 15,223 2,170 3,000 6,000 2,500 2,500 (3,500) 25004600-465505 DOG PARK USE FEES 13,468 13,546 13,077 13,000 13,000 13,000 - 25004600-466500 STREET TREE CHARGES 25,502 45,767 42,382 20,000 25,000 25,000 5,000 25004700-471000 INVESTMENT INCOME (2,386) 4,040 12,000 12,000 4,000 4,000 (8,000) 25004800-483000 SALE OF CITY PROPERTY - - - - - - - 25004800-485550 DONATIONS - PARKS & RECREATION 771 882 882 - - - - 25004800-485553 DONATIONS - PARKS SCHOLARSHIPS 420 193 182 - - - - 25004800-485650 DONATIONS - FORESTRY 1,075 375 375 - - - - 25004800-489000 MISCELLANEOUS REVENUES 784 - - - - - - TOTAL PARK FUND REVENUES 252,184$ 189,046 $ 236,898 $ 111,000 $ 108,500 $ 108,500 $ (2,500) $ PARK FUND EXPENDITURES MATERIALS & SUPPLIES 25055000-532000 OPERATING SUPPLIES 5,416 $ 4,428 $ 3,000 $ 3,000 $ 3,000 $ 3,000 $ - $ SUB-TOTAL 5,416 4,428 3,000 3,000 3,000 3,000 - CONTRACTUAL SERVICES 25055000-543000 ADVERTISING & PRINTING - - - - - - - 25055000-544000 PROFESSIONAL SERVICES - 525 375 - - - (375) 25055000-563000 MEETINGS AND TRAINING 255 - - - - - - SUB-TOTAL 255 525 375 - - - (375) TRANSFERS 25055000-572000 TRANSFER OUT 46,198 - 10,000 10,000 20,000 20,000 10,000 SUB-TOTAL 46,198 - 10,000 10,000 20,000 20,000 10,000 CAPITAL ITEMS 25055000-583300 PARK IMPROVEMENTS 74,947 75,817 147,051 124,199 218,500 218,500 71,449 25065000-583400 LAND IMPROVEMENTS-STREET TREES 89 - 5,000 5,000 5,000 5,000 - 25065000-583500 LAND IMPROVEMENTS-ARBOR DAY 678 - - - - - - SUBTOTAL 75,714 75,817 152,051 129,199 223,500 223,500 71,449 TOTAL PARK FUND EXPENDITURES 127,583$ 80,770 $ 165,426 $ 142,199 $ 246,500 $ 246,500 $ 81,074 $ 124,602$ 108,276$ 71,472$ (31,199)$ (138,000)$ (138,000)$ PARK FUND: FUND BALANCE BEGINNING FUND BALANCE 790,160$ 790,160 $ 790,160 $ 898,436 $ 898,436 $ 898,436 $ ADDITIONS 252,184 189,046 236,898 111,000 108,500 108,500 EXPENSES 127,583 80,770 165,426 142,199 246,500 246,500 ENDING FUND BALANCE 914,762$ 898,436$ 861,632$ 867,237$ 760,436$ 760,436$ 2014 APPROVED BUDGET 111 112 113 City of Sun Prairie 2014 Budget Revolving Loan Fund (Wisconsin Development Fund) Overview: The City of Sun Prairie has retained Community Development Block Grant (CDBG) funds from the U.S. Department of Housing and Urban Development (HUD) for the establishment of an Economic Development Revolving Loan Fund (RLF). This has also been referred to as the “Wisconsin Development Fund.” This fund is designated to make direct business loans on a companion basis with other financing sources (public sector loans, governmental loans/grants, equity, etc.). The Wisconsin Department of Administration (DOA) is the recipient and contracts with the Wisconsin Economic Development Corporation (WEDC) to manage activities and funds associated with Economic Development. These economic development funds are used to provide grants to local units of government that use the funds to loan to a business. The business, in return for use of the public funds, provides private investment towards the assisted activity and most importantly creates job opportunities, principally for the benefit of low and moderate income persons. The Director of Administrative Services and the Director of Economic Development serve as the RLF Program Coordinators for this fund, and act as staff liaisons to the RLF Committee. A City Council member serves as a voting member of the RLF Committee. The RLF Committee reviews applications for assistance through the program, and makes recommendations to the City Council regarding approval of said applications. Mission: The RLF fund and committee’s primary purpose is to provide a supplementary financing tool to qualified businesses unable to secure adequate funds through traditional financing that will have a positive economic impact by way of full-time job creation and increased opportunity for low-to- moderate income persons. Goals: According to the proposed 2013 updates to the City’s Revolving Loan Fund Manual, economic development activities assisted with funds made available through the RLF Program are intended to meet the following federal and State goals and objectives:  To encourage the creation and retention of permanent jobs, which provide a wage, appropriate to the skills and experience of the local labor force and that is competitive. The recipient of funds must agree that a minimum of 51 percent of the jobs created or retained shall be made available to low and moderate income persons. Revolving Loan  Fund Committee 114 City of Sun Prairie 2014 Budget Revolving Loan Fund (Wisconsin Development Fund)  To encourage the leveraging of new private investment into the City of Sun Prairie in the form of fixed asset investment, particularly in land and buildings.  To perpetuate a positive and proactive business climate which encourages the retention and expansion of existing businesses and helps to attract desirable new businesses.  To implement the City of Sun Prairie’s Strategic Business Development Plan’s goals and objectives.  To maintain and promote a diverse mix of employment opportunities and to minimize seasonal or cyclical employment fluctuations.  To encourage the development and use of modern technology and create safe work environments. Strategies: According to the proposed 2013 updates to the City’s Revolving Loan Fund Manual, applications that meet the following local objectives of the City of Sun Prairie will be considered to be more competitive and more desirable:  To encourage redevelopment or new development in targeted geographies within the city of Sun Prairie, including Downtown Sun Prairie (TIF 8), Main Street (TIF 10), the Sun Prairie Business Park (TIF 7), and areas immediately adjacent to these targeted geographies. In addition, the City of Sun Prairie may identify individual sites as priority areas outside of these general areas that have been identified as areas in need of redevelopment or otherwise economically distressed.  To support business creation, retention and expansion in targeted business sectors as 5 adopted in the City’s Strategic Business Development Plan.  To enhance the economic viability of the immediately surrounding area, or of the City of Sun Prairie as a whole.  To encourage full-time the creation, retention or expansion of employment opportunities with wages and benefits beyond the federal minimum wage, and at or above the average wages for Dane County in that industry or occupation.  To encourage the creation, retention and expansion of unique or entrepreneurial businesses that are determined to be viable businesses by the RLF Committee, but may not have adequate access to more traditional means of financing.  Other projects outside of these criteria may be considered if identified by the City Council as a worthy project through formal action. Activities: The RLF Program currently has one active loan which was issued in 2013. This applicant is current on their payments and loan conditions to date. A previous loan to another applicant was also paid off early in 2013. 115 ACTUAL ACTUAL PROJECTED PROJECTED ASSETS 2011 2012 2013 2014 Cash & Investments 105,979$        117,595 $  73,198 $      121,357 $     Loan Receivable 32,096$          ‐$           62,196 $      48,159 $       TOTAL ASSETS 138,075$        117,595 $  135,394 $    169,516 $     LIABILITIES & FUND BALANCE Reserved for Loan 32,096$          ‐$           62,196 $      48,159 $       RLF Fund 105,979$        117,595 $  73,198 $      121,357 $     TOTAL LIABILITIES & FUND BALANCE 138,075$        117,595 $  135,394 $    169,516 $     WISCONSIN DEVELOPMENT FUND 116 2012 2013 2013 2013 2014 2014 INCREASE ACTUAL YTD ACTUAL PROJECTED BUDGET RECOMMENDED APPROVED (DECREASE) BUSINESS IMPROVEMENT DISTRICT (810) BUSINESS IMPROVEMENT DISTRICT REVENUES 81004200-422000 BID DISTRICT ASSESSMENT 63,746$ 70,982 $ 72,000 $ 72,000 $ 92,000$ 92,000$ 20,000$ 81004600-466600 ADVERTISING FEES - - - - - - - 81004700-471000 INVESTMENT INCOME 107 - - - - - - 81004800-485000 DONATIONS - GENERAL - - - - - - - 81004800-489000 MISCELLANEOUS REVENUES - - - - - - - 81004800-489100 SUPPORT FROM GENERAL FUND - - - - - - - TOTAL REVENUES 63,853 70,982 72,000 72,000 92,000 92,000 20,000 BUSINESS IMPROVEMENT DISTRICT EXPENDITURES CONTRACTUAL SERVICES 81066000-541000 COMMUNICATIONS 162 196 196 - - - - 81066000-544000 PROFESSIONAL SERVICES 96 - - - - - - 81066000-544400 ADVERTISING 7,357 503 503 2,000 2,000 2,000 - 81066000-544400 BEAUTIFICATION/MAINTENANCE 25,783 17,318 17,318 35,650 38,250 38,250 (2,600) 81066000-544400 EVENTS 5,160 4,474 4,500 24,500 3,000 3,000 21,500 81066000-544400 BLOCK PARTY 9,993 8,960 8,960 6,000 6,000 6,000 - 81066000-544400 BUSINESS RECRUITMENT - - - - 2,000 2,000 (2,000) 81066000-544400 MISCELLANEOUS 2,599 - 81066000-544400 ADMINISTRATIVE 2,102 17,219 17,219 3,850 21,250 21,250 (17,400) 81066000-544400 TASTE OF SUN PRAIRIE 567 1,127 1,127 - 2,000 2,000 (2,000) 81066000-544400 ART FEST 2,952 3,421 3,421 - 4,000 4,000 (4,000) 81066000-544400 LADIES NIGHT OUT 802 - - - 3,000 3,000 (3,000) 81066000-544400 CAR CRUISE 1,018 609 609 - 1,500 1,500 (1,500) 81066000-544400 FARMERS MARKET - 1,000 1,000 - 1,000 1,000 (1,000) 81066000-544400 GROUND HOG DAY - 3,106 3,106 - 1,500 1,500 (1,500) 81066000-544400 FALL FESTIVAL 3,436 2,384 3,400 - 4,000 4,000 (4,000) 81066000-544400 FIRE TRUCK PARADE 290 1,486 1,500 - 2,500 2,500 (2,500) 81066000-544400 CONTRACTUAL SERVICES - - - - - SUB-TOTAL 62,317 61,802 62,663 72,000 92,000 92,000 (20,000) TOTAL EXPENDITURES 62,317$ 61,802 $ 62,663 $ 72,000 $ 92,000$ 92,000$ (20,000)$ BID DISTRICT: FUND BALANCE BEGINNING FUND BALANCE 50,415$ 51,951 $ 51,951 $ 51,951 $ 51,951$ 51,951$ ADDITIONS 63,853 70,982 72,000 72,000 92,000 92,000 EXPENSES 62,317 61,802 62,663 72,000 92,000 92,000 ENDING FUND BALANCE 51,951 $ 61,131 $ 61,288 $ 51,951 $ 51,951$ 51,951$ CITY OF SUN PRAIRIE 2014 RECOMMENDED BUDGET 117 ACTUAL YTD ACTUAL PROJECTED BUDGET RECOMMENDED APPROVED 2012 2013 2013 2013 2014 2014 COMMUNITY DEVELOPMENT AUTHORITY (850) COMMUNITY DEVELOPMENT AUTHORITY REVENUES 85004700-471300 INTEREST INCOME - LEASE REC 819,102$ - $ 782,311$ 782,311 $ 763,647 $ 763,647 $ TOTAL REVENUES 819,102 - 782,311 782,311 763,647 763,647 COMMUNITY DEVELOPMENT AUTHORITY EXPENDITURES DEBT PAYMENTS 85068500-594000 INTEREST ON DEBT 819,102 - 782,311 782,311 763,647 763,647 85068500-597000 DEBT ISSUANCE EXPENSE - - - - SUB-TOTAL 819,102 - 782,311 763,647 763,647 TOTAL EXPENDITURES 819,102$ - $ 782,311$ 782,311 $ 763,647 $ 763,647 $ COMMUNITY DEVELOPMENT AUTHORITY: FUND BALANCE BEGINNING FUND BALANCE -$ -$ -$ -$ -$ -$ ADDITIONS 819,102 - 782,311 782,311 763,647 763,647 EXPENSES 819,102 - 782,311 782,311 763,647 763,647 ENDING FUND BALANCE -$ -$ -$ -$ -$ -$ CITY OF SUN PRAIRIE 2014 RECOMMENDED BUDGET 118 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET CAPITAL PROJECTS FUND OVERVIEW The purpose of this document is to provide a tool for decision makers and managers in allocating scarce resources in a cost efficient and effective manner. Long-range planning is intended to identify needs and assist budget preparations in order to eliminate peaks and valleys and reduce the impact on debt by pre-planning. This section includes detailed information on the City's general capital projects which are funded primarily through general obligation borrowing. 2014 Capital Projects Include: Street Reconstruction and Rehabilitation Projects The Public Works and Engineering Department work together to determine which streets are in most need of reconstruction or rehabilitation. For 2014, the following streets are scheduled for major reconstruction or rehabilitation: W. MacArthur Street, S. Bird Street, Thomas Drive, Olympic Street, Briar Lane, Heath Court, Oneida Court, Jasper Circle, Andaman Street, Apple Drive, and Echo Drive. Sidewalk Improvements The City has been awarded a Safe Routes to School Grant from the Wisconsin Department of Transportation to construct sidewalks as a means to improve safety for school-age children walking to school. The 2014 sidewalk projects funded by this grant program include W. MacArthur Street, North Street, and Walmar Drive. The City also funded $71,500 for Chase Boulevard sidewalk improvements. Dispatch Center Equipment The 2014 Capital Projects Fund budget includes $282,000 for the purchase of Dispatch Center consoles and funding the Dispatch Center’s connection to DaneCom, the new county-wide radio interoperability project. GENERAL CAPITAL PROJECTS BORROWING 119 CITY OF SUN PRAIRIE 2013 APPROVED BUDGET CAPITAL PROJECTS SUMMARY CAPITAL PROJECTS FUND (400) ACTUAL PROJECTED APPROVED 2012 2013 2014 2015 2016 2017 2018 SOURCES OF FUNDING Property Tax Levy 271,046$ 200,000 $ - $ 450,000$ 550,000 $ 650,000 $ 750,000 $ General Obligation-Capital Borrowing 3,744,551 2,364,243 3,448,702 2,928,709 3,832,127 3,464,379 4,289,810 Transfer from Impact Fee Fund 227,936 50,000 1,110,807 322,185 1,223,035 180,408 1,284,382 Transfer from TIF - - - - - - - Grants, Interest & Other Revenues 17,000 650,857 813,082 - - - - Utility Reimbursement - - - - - - - TOTAL SOURCES OF FUNDING 4,260,533 3,265,100$ 5,372,591$ 3,700,894 5,605,162 4,294,787 6,324,191 USES OF FUNDING Buildings & Land Improvements - 105,000 250,000 - - - Street Reconstruction/Rehabilitation 1,200,000 2,375,000 2,235,000 2,386,000 2,697,500 3,199,000 2,815,000 Sidewalks/Bikepaths - 579,000 757,800 110,400 54,050 80,500 69,000 Transportation System Improvements 315,000 100,000 2,093,500 140,450 1,025,805 135,363 1,344,497 Equipment 631,000 295,100 282,000 - - - - Transfer Out - 92,005 - - - - Issuance Costs - 34,000 49,291 41,859 54,772 49,516 61,313 TOTAL USES OF FUNDING 2,146,000$ 3,580,105$ 5,417,591$ 2,928,709$ 3,832,127$ 3,464,379$ 4,289,810$ SURPLUS/(DEFICIT) 2,114,533 (315,005) (45,000) 772,185 1,773,035 830,408 2,034,382 Beginning Balance (1,376,468) 738,065 738,065 693,065 1,465,250 3,238,285 4,068,693 Ending Balance 738,065 378,060 693,065 1,465,250 3,238,285 4,068,693 6,103,075 PROJECTED 120 Estimated PROJECT OTHER GO APPROVED Year ESTIMATE REVENUES* BORROWING 2014 2015 2016 2017 2018 Street Reconstruction 2014 Street Projects 2014 2,235,000 65,282 2,169,718 2,169,718 - - - - 2015 Street Projects 2015 2,836,000 450,000 2,386,000 - 2,386,000 - - - 2016 Street Projects 2016 3,247,500 550,000 2,697,500 - - 2,697,500 - - 2017 Street Projects 2017 3,849,000 650,000 3,199,000 - - - 3,199,000 - 2018 Street Projects 2018 3,565,000 750,000 2,815,000 - - - - 2,815,000 Sub-total Street Reconstruction 18,107,500 2,950,139 15,157,361 2,169,718 2,386,000 2,697,500 3,199,000 2,815,000 Transportation Improvements Broadway & Windsor Intersection Design 2014 37,500 - 37,500 37,500 - - - i Main St Extended - Weybridge to CTH C 2014 1,855,000 1,077,300 777,700 777,700 - - - - i S. Grand Ave Sidewalk (impact fee) 2014 51,000 33,507 17,493 17,493 - - - West Prairie Village Repaving 2014 150,000 130,000 20,000 20,000 i QBE Sidewalk 2015 25,000 16,850 8,150 - 8,150 - i Thompson-Brooks Connection 2016 2,195,000 1,319,195 875,805 - - 875,805 - 875,805 i Reiner Road Extended 2018 1,085,000 712,845 372,155 - - - 53,463 318,692 CTH C - North of Hwy 19 i Traffic Studies - WS Impact Fee 2018 60,000 60,000 - - - - - - i* Traffic Signals 810,000 295,800 514,200 - 132,300 150,000 81,900 150,000 Sub-total Transportation Improvements 6,368,500 3,695,497 2,673,003 852,693 140,450 1,025,805 135,363 1,344,497 Sidewalks/Bikepaths SRTS - Walmar/MacArthur/North 2014 451,000 376,000 75,000 75,000 - - - - Hoepker Bike Path 2014 241,800 241,800 - - - - - - Chase Boulevard 2014 65,000 45,000 20,000 20,000 - - - - Sidewalk Improvements 2015-2018 313,950 - 313,950 - 110,400 54,050 80,500 69,000 Sub-total Sidewalks/Bikepaths 1,071,750 662,800 408,950 95,000 110,400 54,050 80,500 69,000 Facilities/Equipment Sheehan Park Sports Complex 2015 275,000 25,000 250,000 250,000 - - - Dispatch Center Equipment 2014 282,000 - 282,000 282,000 - - - - Sub-total Equipment 920,100 43,000 877,100 282,000 250,000 - - - Debt Issuance Costs 2014-2018 306,043 - 306,043 49,291 41,859 54,772 49,516 61,313 TOTAL CAPITAL IMPROVEMENT PLAN 26,785,893$ 7,363,436$ 19,422,457$ 3,448,702$ 2,928,709$ 3,832,127$ 3,464,379$ 4,289,810$ * Other Revenues include property tax levy, available project funds, grant revenue, and impact fees. i Westside Traffic Impact Fee Project i* Partial Westside Traffic Impact Fee Project SUN PRAIRIE CAPITAL IMPROVEMENT PLAN GENERAL OBLIGATION BORROWING SUMMARY GENERAL OBLIGATION BORROWING 121 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET TAX INCREMENT FINANCING DISTRICTS TAX INCREMENT FINANCING DISTRICT #8 ACTUAL PROJECTED RECOMMENDED 2012 2013 2014 2015 2016 2017 2018 SOURCES OF FUNDING Tax Increment 1,402,460$ 1,415,688$ 1,630,000$ 1,680,000$ 1,680,000$ 1,690,000$ 1,697,000 $ Intergovernmental Revenue 395,717 15,700 15,700 15,700 15,700 15,700 Public Charges for Services 14,764 14,041 8,000 8,000 8,000 8,000 8,000 Interest Income - - - - - - - Land Sales & Other Miscellaneous Revenues - - - - Proceeds of Long-Term Debt - - - - - - - TOTAL SOURCES OF FUNDING 1,812,941 1,429,729 1,653,700 1,703,700 1,703,70 0 1,713,700 1,720,700 580000 USES OF FUNDING Project & Administrative Costs 17,115 17,115 25,000 25,000 25,000 25,000 25,000 New Perspectives Development 562,885 562,885 65,000 65,000 67,000 69,000 71,000 Copps Development - - - - - - - Façade Improvement Program 5,000 - - - - - - Debt Issuance Costs - 4,427 - - - - - Debt Principal 705,000 805,000 905,000 970,000 1,055,000 1,140,000 1,205,000 Debt Interest 686,633 662,169 624,582 596,929 559,561 517,911 471,495 TOTAL USES OF FUNDING 1,976,633$ 2,051,596$ 1,619,582$ 1,656,929$ 1,706,561 $ 1,751,911$ 1,772,495$ SURPLUS/(DEFICIT) (163,692) (621,867) 34,118 46,771 (2,861) (38,211) (51,795) Beginning Balance 1,164,682 1,000,990 379,123 413,241 460,012 457,151 418,940 Ending Balance 1,000,990 379,123 413,241 460,012 457,151 418,940 367,145 122 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET TAX INCREMENT FINANCING DISTRICTS TAX INCREMENT FINANCING DISTRICT #9 ACTUAL PROJECTED RECOMMENDED 2012 2013 2014 2015 2016 2017 2018 SOURCES OF FUNDING Tax Increment -$ - $ - $ 230,000$ 230,000 $ 230,000 $ 230,000 $ Intergovernmental Revenue 2,700 1,540 2,700 2,700 2,700 2,700 2,700 Interest Income - - - - - - - Land Sales & Other Miscellaneous Revenues - - - - - - - Proceeds of Long-Term Debt - - - 4,200,00 0 - - - TOTAL SOURCES OF FUNDING 2,700 1,540 2,700 4,432,700 232,70 0 232,700 232,700 USES OF FUNDING Project & Administrative Costs 2,046 24,997 5,000 5,000 5,000 5,000 5,000 Debt Issuance Costs - 17,459 - 50,000 - - - Debt Principal - - 10,000 4,200,000 420,000 420,000 420,000 Debt Interest 201,025 183,470 182,325 201,025 160,000 143,000 126,000 TOTAL USES OF FUNDING 203,071$ 225,926$ 197,325$ 4,456,025$ 585,00 0$ 568,000$ 551,000$ SURPLUS/(DEFICIT) (200,371) (224,386) (194,625) (23,325) (352,300) (335,300) (318,300) Beginning Balance (162,867) (363,439) (587,825) (782,450) (805,775) (1,158,075) (1,493,375) Ending Balance (363,238) (587,825) (782,450) (805,775) (1,158,075) (1,493,375) (1,811,675) 123 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET TAX INCREMENT FINANCING DISTRICTS TAX INCREMENT FINANCING DISTRICT #10 ACTUAL PROJECTED RECOMMENDED 2012 2013 2014 2015 2016 2017 2018 SOURCES OF FUNDING Tax Increment -$ - $ - $ - $ - $ - $ - $ Intergovernmental Revenue 2,708 4,276 2,700 2,700 2,700 2,700 2,700 Interest Income - - - - - - - Land Sales & Other Miscellaneous Revenues - - - - - - - Proceeds of Long-Term Debt - - - - - - - TOTAL SOURCES OF FUNDING 2,708 4,276 2,700 2,700 2,700 2,700 2,700 USES OF FUNDING Project & Administrative Costs 490 206 1,000 1,000 1,000 1,000 1,000 Debt Issuance Costs - - - - - - - Debt Principal - - - - - - - Debt Interest - - - - - - - TOTAL USES OF FUNDING 490$ 206$ 1,000$ 1,000$ 1,000$ 1,000$ 1,000$ SURPLUS/(DEFICIT) 2,218 4,070 1,700 1,700 1,700 1,700 1,700 Beginning Balance (10,216) (7,998) (3,928) (2,228) (528) 1,172 2,872 Ending Balance (7,998) (3,928) (2,228) (528) 1,172 2,872 4,572 124 2012 2013 2014 Actual Projected APPROVED REVENUES Property Taxes 6,559,367$ 6,399,403 $ 6,326,108 $ Special Assessments 5,334 - - Miscellaneous 38,272 41,648 40,324 Interest 325 1,000 - Total Revenues 6,603,298 6,442,051 6,366,432 EXPENDITURES Principal 11,471,031 5,265,932 9,746,186 Interest 1,403,304 1,130,860 828,360 Total Expenditures 12,874,335 6,396,792 10,574,546 Excess (deficiency)  of revenues over  expenditures (6,271,037) (15,104) (4,208,114) OTHER FINANCING SOURCES Proceeds from long-term debt 8,565,449 9,831,790 - Payment to escrow (2,322,044) (5,887,634) - Premium/Discount/Issuance Costs 78,014 174,913 - Operating transfers in/(out) (916,062) 116,290 - Total Other Financing Sources (Uses) 5,405,357 4,235,359 - Excess (Deficit) of Sources vs. Uses of Funds (865,680) $ 4,280,618 $ (4,208,114) $ FUND BALANCE Beginning of Year 865,680 - 4,280,618 End of Year -$ 4,280,618$ 72,504$ General Debt Service Budget 2014 APPROVED BUDGET CITY OF SUN PRAIRIE *Debt Service fund balance is needed for cash flow purposes since the majority of the City's debt service payments are made between February 1st and April 1st while revenues are collected throughout the year. 125 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET CITY OF SUN PRAIRIE 2014 DEBT SERVICE REQUIREMENTS Description Principal Escrow Interest Interest Principal Interest Principal Interest 2003 CDA Lease/Rev Bonds 2005 CDA Lease/Rev Bonds 2005A GO Public Safety Bonds 350,000         98,288       36,775       2005B GO Notes 2005C GO Refunding Bonds 759,469         64,181       20,531       1,969           2005 Clean Water Fund Loan 2006 CDA Lease/Rev Bonds 2006 GO Notes 835,000         51,700       2006 STFL 2007 GO Bonds 350,000         66,400       19,688       2008 GO Notes 720,000         109,931     44,284       2009 CDA Refunding Bonds 110,000     30,120         420,000     147,376     2009 GO Bonds 305,000         219,218     2009 Taxable GO  Note 2009 STFL 95,742            22,432       2009 WPPI Loan 9,912             2010 GO Notes 200,000         86,221       2012 GO Notes 560,000         86,075       2012 GO Bonds 1,280,000      81,600       2013 A GO Bonds 95,000            116,188     2013 B GO Refunding Bonds 4,186,064      65,936       TOTALS 9,746,186 $    274,619 $    828,360 $    196,467 $    32,089 $       420,000 $    147,376 $    General Debt Service TIF No. 6 TIF No. 7 126 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET CITY OF SUN PRAIRIE 2014 DEBT SERVICE REQUIREMENTS Description Principal Interest Principal Interest Principal Interest Principal Interest 2003 CDA Lease/Rev Bonds 140,000 $     74,155 $      2005 CDA Lease/Rev Bonds 525,000       370,700     2005A GO Public Safety Bonds 2005B GO Notes 2005C GO Refunding Bonds 2005 Clean Water Fund Loan 790,461        246,593      2006 CDA Lease/Rev Bonds 165,000       136,031     2006 GO Notes 2006 STFL 2007 GO Bonds ‐                    ‐                   2008 GO Notes 70,000         4,516         2009 CDA Refunding Bonds 2009 GO Bonds 35,242       100,000        20,020        100,000      20,215        2009 Taxable GO Note 162,750     2009 STFL 2009 WPPI  Loan 2010 GO Notes 10,000          137              2012 GO Notes 2012 GO Bonds 2013 A GO Bonds 5,000           3,938         10,000       19,575       2013 B GO Refunding Bonds TOTALS 905,000 $     624,582 $    10,000 $      182,325 $    900,461 $      266,750 $     100,000 $     20,215 $       StormwaterTIF No. 8 TIF No. 9 WWTP 127 CITY OF SUN PRAIRIE DEBT SERVICE FUNDS 2014 APPROVED BUDGET 2014 2014 General TID TID Debt Service No. 6 No. 7 TOTALS REVENUES Property Taxes 6,326,108$ - $ - $ 6,326,108$ Exempt Computer Aid 64 15,548 15,612 TID Increment 133,509 922,992 1,056,501 Special Assessments - - - Public Charges for Services - - Miscellaneous 40,324 20,000 - 60,324 Interest - 50 100 150 Total Revenues 6,366,432 153,623 938,640 7,458,695 EXPENDITURES Professional Services - - - Principal 9,746,186 196,467 420,000 10,362,653 Interest 828,360 32,089 147,376 1,007,825 Fiscal Charge - 500 600 1,100 Total Expenditures 10,574,546 229,056 567,976 11,371,578 Excess (deficiency)  of revenues over  expenditures (4,208,114) (75,433) 370,664 (3,912,883) OTHER FINANCING SOURCES Proceeds of Bonds - - - Operating transfers in/(out) - - - -     Total Other Financing Sources (Uses) - - - Excess (deficiency) of revenues and other sources over expenditures and other uses (75,433) 370,664 (3,912,883) Fund Balances ‐ Beginning of Year (Estimated) 4,280,618 79,006 1,961,965 6,321,589 FUND BALANCES - - END OF YEAR 72,504 $ 3,573$ 2,332,629$ 2,408,706$ 128 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET - CATV INCREASE/ DECREASE ADOPTED 2014 CATV CHARGES FOR SERVICES Others 310,000 320,000CABLE TV FRANCHISE FEES 247,568 312,276 10,00022004400 441500 310,000 320,000 312,276 247,568 310,000 310,000 320,000 10,000SUB-TOTAL 320,000 $312,276 $247,568 $310,000 $320,000 $10,000TOTAL CATV CHARGES FOR SERVICES $310,000 $320,000 CATV INVESTMENT INCOME Others 350 350INVESTMENT INCOME 0283 022004700 471000 350 350 283 0 350 350 350 0SUB-TOTAL 350 $283 $0 $350 $350 $0TOTAL CATV INVESTMENT INCOME $350 $350 CATV MISCELLANEOUS REVENUE Others 14,000 14,000MISCELLANEOUS REVENUES 14,83517,987 022004800 489000 14,000 14,000 17,987 14,835 14,000 14,000 14,000 0SUB-TOTAL 14,000 $17,987 $14,835 $14,000 $14,000 $0TOTAL CATV MISCELLANEOUS REVENUE $14,000 $14,000 CATV OTHER FINANCING SOURCES Others 9,700 0TRANSFER IN 9,700 0 -9,70022004900 492100 9,700 0 -1,661 0FUND BALANCE APPLIED 0 0 1,66122004900 499000 -1,661 0 0 9,700 8,039 8,039 0 -8,039SUB-TOTAL 0 $0 $9,700 $8,039 $0 $-8,039TOTAL CATV OTHER FINANCING SOURCES $8,039 $0 CATV EXPENDITURES PERSONNEL SERVICES -163,960 -167,463REGULAR WAGES -148,028-145,355 -3,50322051000 511000 -163,960 -167,463 -720 -720BOARDS AND COMMITTEES -40-240 022051000 514000 -200 -720 -10,920 -10,920SEASONAL WAGES -12,592-19,552 022051000 519000 -12,000 -10,920 -165,147 -160,660 -176,160 -175,600 -179,103 -3,503SUB-TOTAL -179,103 129 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET - CATV INCREASE/ DECREASE ADOPTED 2014 FRINGE BENEFITS -13,343 -15,095SOCIAL SECURITY -11,559-12,152 -1,75222051000 521000 -13,343 -15,095 -10,166 -11,464RETIREMENT -9,131-9,007 -1,29822051000 522000 -10,166 -11,464 -50,340 -53,944HEALTH INSURANCE -46,680-37,152 -3,60422051000 523000 -50,340 -53,944 -175 -208LIFE INSURANCE -149-123 -3322051000 524000 -175 -208 -4,716 -5,933DENTAL INSURANCE -4,371-3,475 -1,21722051000 525000 -4,716 -5,933 -61,909 -71,891 -78,740 -78,740 -86,644 -7,904SUB-TOTAL -86,644 MATERIALS AND SUPPLIES -6,175 -3,000OFFICE SUPPLIES -1,370 -2,767 3,17522051000 531000 -3,000 -3,000 -9,580 -5,000OPERATING SUPPLIES -2,563 -6,519 4,58022051000 532000 -6,500 -5,000 -10 -10WORK PERMITS -30 -10 022051000 532150 -50 -10 0 0BANK SERVICE CHARGES -739 -683 022051000 532500 -700 0 -2,000 -2,000REPAIRS AND MAINTENANCE -567 -196 022051000 533000 -250 -2,000 -3,000 -6,000MAINTENANCE AGREEMENTS -5,687 -750 -3,00022051000 533100 -6,000 -6,000 0 0FUEL PURCHASES -56 -63 022051000 536000 -60 0 -10,987 -11,011 -16,560 -20,765 -16,010 4,755SUB-TOTAL -16,010 CONTRACTUAL SERVICES -4,100 -4,100COMMUNICATIONS -4,482 -4,107 022051000 541000 -4,100 -4,100 -6,000 -6,000UTILITIES -8,126 -8,629 022051000 542000 -8,000 -6,000 -11,139 -6,000PROFESSIONAL SERVICES -9,837 -800 5,13922051000 544000 -11,000 -6,000 -150 -150CONTRACTUAL SERVICES -350 -90 022051000 544400 0 -150 -13,626 -22,795 -23,100 -21,389 -16,250 5,139SUB-TOTAL -16,250 PROFESSIONAL DEVELOPMENT -500 -200MILEAGE -179 -59 30022051000 562000 -200 -200 -3,150 -6,000MEETINGS AND TRAINING -5,261 -2,634 -2,85022051000 563000 -4,883 -6,000 -2,692 -5,440 -5,083 -3,650 -6,200 -2,550SUB-TOTAL -6,200 130 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET - CATV INCREASE/ DECREASE ADOPTED 2014 CAPITAL ITEMS 0 0MACHINERY & EQUIPMENT EXPEN -17,6480 022051000 581000 -14,738 0 0 0MINOR CAPITAL -790 -1,511 022051000 581100 -790 0 -1,511 -18,438 -15,528 0 0 0SUB-TOTAL 0 INSURANCE -600 -600WORKERS' COMPENSATION COV -272 -260 022051000 551000 -259 -600 0 -276PROPERTY COVERAGE -275 -227 -32322051000 552000 -275 -323 -1,600 -1,600LIABILITY COVERAGE -58 -47 022051000 553000 -60 -1,600 -45 -45VEHICLE COVERAGE 0 0 022051000 554000 -45 -45 -534 -605 -639 -2,245 -2,521 -323SUB-TOTAL -2,568 CAPITAL PROJECTS 0 0OFFICE FURNITURE & EQUIPMEN -3,5910 022051000 588000 -3,591 0 -30,000 -25,000MACHINERY & EQPMNT - REPLAC -10,471-69,563 5,00022051000 589000 -9,000 -25,000 -69,563 -14,062 -12,591 -30,000 -25,000 5,000SUB-TOTAL -25,000 0 0BUILDING IMPROVEMENTS -286 0 022051000 584000 -286 0 0 -286 -286 0 0 0SUB-TOTAL 0 $-325,970 $-305,187 $-332,389 $-331,728 $614TOTAL CATV EXPENDITURES $-328,687 $-331,775 FUND TOTAL: 0 2,622-33,0844,576 2,5753,702 2,575 131 CABLE ACCESS TELEVISION 2013 FTE 2014 FTE Change 2013 2014 Change CATV Director 1.0 1.0 - 75,784 77,420 1,636 CATV Program Coordinator 1.9 1.9 - 123,109 129,521 6,412 CATV Production Coordinator 1.0 1.0 - 42,970 42,364 (606) LTE Programmers/Tapings 0.8 0.8 - 11,757 11,757 - Overtime * * * - - - Boards & Commissions * * * 720 720 - TOTAL 4.7 4.7 - 254,340 261,782 7,442 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET PERSONNEL COSTS Position Title STAFFING SALARIES, WAGES & BENEFITS 132 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 INCREASE/ DECREASE ADOPTED 2014 OPERATING WASTEWATER OPERATING REVENUES Others 61004600 468101 WASTEWATER FEES - RESIDENTIAL 2,438,404 1,864,883 2,554,500 2,554,500 2,685,150 130,6502,685,150 61004600 468102 WASTEWATER FEES - COMMERCIAL 823,820 646,369 874,200 874,200 945,410 71,210945,410 61004600 468103 WASTEWATER FEES - INDUSTRIAL 94,619 80,382 106,500 106,500 109,270 2,770109,270 61004600 468104 WASTEWATER FEES - PUBLIC AUTH 34,630 25,625 34,300 34,300 35,630 1,33035,630 61004600 468105 WASTEWATER FEES - SURCHARGES 5,843 13,390 3,200 3,200 5,000 1,8005,000 61004800 488100 FOREFEITED DISCOUNTS 18,469 11,902 18,000 18,000 18,000 018,000 61004800 488102 CAMERA REPLACEMENT 1,550 3,400 1,125 1,125 2,000 8752,000 61004800 488103 PEAK SHAVE OPERATION 45,204 13,641 14,000 14,000 0 -14,0000 61004800 489000 MISCELLANEOUS REVENUES 1,003 3,264 5,000 5,000 70,000 65,00070,000 3,463,540SUB-TOTAL 2,662,855 3,610,825 3,610,825 3,870,460 259,6353,870,460 259,6353,870,4603,610,8253,610,8252,662,8553,463,540TOTAL WASTEWATER OPERATING REVENUES 3,870,460 WASTEWATER ADMINISTRATION EXPENSE PERSONNEL SERVICES 61081081 511000 REGULAR WAGES 90,547 82,915 90,200 90,200 90,200 090,200 90,547SUB-TOTAL 82,915 90,200 90,200 90,200 090,200 FRINGE BENEFITS 61081081 521000 SOCIAL SECURITY 6,930 6,354 0 6,887 6,878 -96,878 61081081 522000 RETIREMENT 5,614 5,141 5,593 5,593 5,593 05,593 61081081 523000 HEALTH INSURANCE 4,793 4,818 5,028 5,028 5,222 1945,222 61081081 524000 LIFE INSURANCE 555 581 691 691 664 -27664 61081081 525000 DENTAL INSURANCE 406 408 426 426 426 0426 61081081 528000 POST EMPLOYMENT HEALTH PLAN -3,023 0 000 00 15,275SUB-TOTAL 17,302 11,738 18,625 18,783 15818,783 MATERIALS AND SUPPLIES 61081081 531000 OFFICE SUPPLIES 1,171 1,253 1,200 1,200 1,400 2001,400 61081081 532500 BANK SERVICE CHARGES 342 275 000 00 61081081 535000 UNIFORMS 00 200 200 200 0200 1,513SUB-TOTAL 1,528 1,400 1,400 1,600 2001,600 CONTRACTUAL SERVICES 61081081 541000 COMMUNICATIONS 9,382 9,497 9,300 9,300 8,640 -6608,640 61081081 543000 ADVERTISING AND PRINTING 372 667 800 800 800 0800 133 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 INCREASE/ DECREASE ADOPTED 2014 61081081 544000 PROFESSIONAL SERVICES 108,665 95,506 113,630 113,630 128,628 -2113,628 61081081 547000 BILLING SERVICES 228,535 216,700 243,000 243,000 243,000 0243,000 346,953SUB-TOTAL 322,370 366,730 366,730 381,068 -662366,068 INSURANCE 61081081 551000 WORKERS' COMPENSATION COVERA 10,612 11,120 17,000 17,000 15,000 -2,00015,000 61081081 552000 PROPERTY COVERAGE 7,500 9,106 4,000 4,000 9,200 6,68910,689 61081081 553000 LIABILITY COVERAGE 1,912 2,358 3,500 3,500 3,000 -5003,000 61081081 554000 VEHICLE COVERAGE 704 545 750 750 750 0750 20,728SUB-TOTAL 23,129 25,250 25,250 27,950 4,18929,439 PROFESSIONAL DEVELOPMENT 61081081 562000 MILEAGE 03 2 100 100 100 0100 61081081 563000 MEETINGS AND TRAINING 75 513 1,200 1,200 1,200 01,200 61081081 564000 DUES AND MEMBERSHIPS 2,113 2,113 2,770 2,770 2,770 02,770 2,188SUB-TOTAL 2,658 4,070 4,070 4,070 04,070 0SUB-TOTAL 0 0 0 0 00 3,885523,671506,275499,388449,901477,205TOTAL WASTEWATER ADMINISTRATION EXPENSE 510,160 WASTEWATER PLANT OPERATIONS EXPENSE PERSONNEL SERVICES 61081082 511000 REGULAR WAGES 345,137 319,862 353,653 353,653 358,161 4,508358,161 61081082 513000 OVERTIME 2,331 2,383 5,000 5,000 5,000 05,000 61081082 517000 MISCELLANEOUS COMPENSATION 4,597 4,100 3,290 3,290 3,290 03,290 61081082 519000 SEASONAL WAGES 00 0 0 5,180 5,1805,180 352,066SUB-TOTAL 326,345 361,943 361,943 371,631 9,688371,631 FRINGE BENEFITS 61081082 521000 SOCIAL SECURITY 26,547 24,481 0 26,118 26,494 37626,494 61081082 522000 RETIREMENT 21,329 19,666 21,930 21,930 22,208 27822,208 61081082 523000 HEALTH INSURANCE 70,446 69,651 75,011 75,011 77,874 2,86377,874 61081082 524000 LIFE INSURANCE 1,284 1,243 1,342 1,342 1,527 1851,527 61081082 525000 DENTAL INSURANCE 6,505 6,436 6,937 6,937 6,937 06,937 61081082 528000 POST EMPLOYMENT HEALTH PLAN 358 0 000 00 126,469SUB-TOTAL 121,477 105,220 131,338 135,040 3,702135,040 MATERIALS AND SUPPLIES 61081082 532000 OPERATING SUPPLIES 67,561 88,371 93,700 93,700 93,700 093,700 61081082 533000 REPAIRS AND MAINTENANCE 5,351 15,212 10,000 10,000 10,000 010,000 61081082 533100 MAINTENANCE AGREEMENTS 12,336 11,249 13,690 13,690 13,690 013,690 61081082 533200 JANITORIAL SERVICES 4,548 4,548 4,600 4,600 4,600 04,600 61081082 533810 REPAIRS & MAINTENANCE - WWTP 2,553 2,132 2,500 2,500 3,000 5003,000 61081082 534000 SMALL TOOLS 125 193 2,000 2,000 2,000 02,000 134 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 INCREASE/ DECREASE ADOPTED 2014 61081082 535000 UNIFORMS 2,858 2,628 2,800 2,800 2,800 02,800 61081082 536000 FUEL PURCHASES 6,288 6,188 6,200 6,200 6,500 3006,500 61081082 537000 RENTAL VEHICLES AND EQUIPMENT 7,490 4,460 7,000 7,000 7,000 07,000 109,110SUB-TOTAL 134,981 142,490 142,490 143,290 800143,290 CONTRACTUAL SERVICES 61081082 542000 UTILITIES 189,141 165,935 225,000 225,000 225,000 0225,000 61081082 544000 PROFESSIONAL SERVICES 4,086 6,856 10,980 10,980 16,980 6,00016,980 193,227SUB-TOTAL 172,791 235,980 235,980 241,980 6,000241,980 PROFESSIONAL DEVELOPMENT 61081082 563000 MEETINGS AND TRAINING 591 1,159 2,500 2,500 2,500 02,500 591SUB-TOTAL 1,159 2,500 2,500 2,500 02,500 Others 61081082 571000 DEPRECIATION EXPENSE 1,072,923 0 1,100,000 1,100,000 1,150,000 50,0001,150,000 1,072,923SUB-TOTAL 0 1,100,000 1,100,000 1,150,000 50,0001,150,000 70,1902,044,4411,974,2511,948,133756,7521,854,385TOTAL WASTEWATER PLANT OPERATIONS EXPENSE 2,044,441 WASTEWATER COLLECTION SYSTEM EXPENSE PERSONNEL SERVICES 61081083 511000 REGULAR WAGES 94,312 87,183 94,612 94,612 96,159 1,54796,159 61081083 513000 OVERTIME 3,470 1,546 3,000 3,000 3,000 03,000 61081083 517000 MISCELLANEOUS COMPENSATION 1,705 1,799 2,200 2,200 2,200 02,200 61081083 519000 SEASONAL WAGES 0 3,860 5,400 5,400 10,360 4,96010,360 99,487SUB-TOTAL 94,387 105,212 105,212 111,719 6,507111,719 FRINGE BENEFITS 61081083 521000 SOCIAL SECURITY 7,521 7,150 36 7,098 7,627 5297,627 61081083 522000 RETIREMENT 5,815 5,391 5,867 5,867 5,963 965,963 61081083 523000 HEALTH INSURANCE 24,795 24,966 25,982 25,982 26,972 99026,972 61081083 524000 LIFE INSURANCE 354 334 355 355 415 60415 61081083 525000 DENTAL INSURANCE 2,319 2,338 2,434 2,434 2,434 02,434 61081083 528000 POST EMPLOYMENT HEALTH PLAN -316 0 000 00 40,489SUB-TOTAL 40,178 34,674 41,736 43,411 1,67543,411 MATERIALS AND SUPPLIES 61081083 532000 OPERATING SUPPLIES 14,932 12,942 12,000 12,000 12,000 012,000 61081083 533000 REPAIRS AND MAINTENANCE 3,749 1,633 5,000 5,000 5,000 05,000 61081083 533810 REPAIRS & MAINTENANCE - WWTP 1,190 1,167 2,500 2,500 2,500 02,500 61081083 534000 SMALL TOOLS 160 316 1,000 1,000 1,000 01,000 61081083 535000 UNIFORMS 914 802 1,200 1,200 1,200 01,200 61081083 536000 FUEL PURCHASES 9,371 8,749 8,000 8,000 9,000 1,0009,000 135 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 INCREASE/ DECREASE ADOPTED 2014 30,317SUB-TOTAL 25,608 29,700 29,700 30,700 1,00030,700 CONTRACTUAL SERVICES 61081083 542000 UTILITIES 6,320 6,867 7,000 7,000 7,000 07,000 61081083 544000 PROFESSIONAL SERVICES 3,545 4,091 4,800 4,800 4,800 04,800 9,865SUB-TOTAL 10,958 11,800 11,800 11,800 011,800 PROFESSIONAL DEVELOPMENT 61081083 563000 MEETINGS AND TRAINING 170 165 1,000 1,000 1,000 01,000 170SUB-TOTAL 165 1,000 1,000 1,000 01,000 0SUB-TOTAL 0 0 0 0 00 DEPRECIATION EXPENSE 61081083 571000 DEPRECIATION EXPENSE 251,792 0 250,000 250,000 265,000 15,000265,000 251,792SUB-TOTAL 0 250,000 250,000 265,000 15,000265,000 24,182463,630439,448432,386171,296432,119TOTAL WASTEWATER COLLECTION SYSTEM EXPENSE 463,630 WASTEWATER REPLACEMENT ACCOUNT CAPITAL ITEMS 61081085 581000 MACHINERY & EQUIPMENT EXPENSE 18,361 30,342 225,354 225,354 225,354 0225,354 61081085 589000 MACHINERY & EQPMNT - REPLACED 24,377 68,331 150,236 150,236 151,036 800151,036 42,739SUB-TOTAL 98,672 375,590 375,590 376,390 800376,390 800376,390375,590375,59098,67242,739TOTAL WASTEWATER REPLACEMENT ACCOUNT 376,390 WASTEWATER CAPITAL EXPENSE CAPITAL EXPENSE 61081087 581000 MACHINERY & EQUIPMENT EXPENSE 36,513 0 99,000 99,000 0 -99,0000 61081087 585000 SANITARY SEWER 6,569 271,343 399,400 399,400 427,700 28,300427,700 43,082SUB-TOTAL 271,343 498,400 498,400 427,700 -70,700427,700 -70,700427,700498,400498,400271,34343,082TOTAL WASTEWATER CAPITAL EXPENSE 427,700 Others Others 61004800 484000 INSURANCE DIVIDEND & RECOVERY 0 23,335 000 00 0SUB-TOTAL -23,335 0 0 0 00 0000-23,3350TOTAL WWTP PLANT EXPANSION 0 614,010TOTAL INCOME (LOSS) OPERATING 938,226 -143,072 -183,139 34,628 231,27848,139 NON-OPERATING WASTEWATER NON-OPERATING REVENUES Others 136 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 INCREASE/ DECREASE ADOPTED 2014 61004200 420100 NON OPERATING CAPITAL CONTRIB 69,269 0 000 00 61004200 428000 INTEREST SPECIAL ASSESSMENTS 685 0 000 00 61004400 443811 SANITARY SEWER CONNECTION FEE 381,523 499,517 100,000 100,000 200,000 100,000200,000 61004400 443812 INTERCEPTOR CONNECTION FEE 117,767 41,692 60,000 60,000 60,000 060,000 61004700 471000 INVESTMENT INCOME 13,157 8,006 7,500 7,500 7,500 07,500 61004700 471100 INVESTMENT INCOME RESTRICTED 25 2 8,000 8,000 8,000 08,000 61004900 491900 BOND PREMIUM 1,752 0 000 00 584,177SUB-TOTAL 549,217 175,500 175,500 275,500 100,000275,500 100,000275,500175,500175,500549,217584,177TOTAL WASTEWATER NON-OPERATING REVENUES 275,500 WASTEWATER DEBT SERVICE EXPENSE DEBT SERVICE EXPENSE 61081084 592000 PRINCIPAL ON DEBT 00 877,198 877,198 927,470 50,272927,470 61081084 594000 INTEREST ON DEBT 305,562 288,274 288,274 288,274 288,174 -100288,174 61081084 598000 AMORITIZATION OF DEBT DISCOUNT 3,346 0 000 00 308,908SUB-TOTAL 288,274 1,165,472 1,165,472 1,215,644 50,1721,215,644 0SUB-TOTAL 0 0 0 0 00 50,1721,215,6441,165,4721,165,472288,274308,908TOTAL WASTEWATER DEBT SERVICE EXPENSE 1,215,644 Others CONTRACTUAL SERVICES 61081086 544000 PROFESSIONAL SERVICES 00 0 0 40,000 40,00040,000 0SUB-TOTAL 0 0 0 40,000 40,00040,000 40,00040,0000000TOTAL WASTEWATER EXPANSION EXPENSE 40,000 275,270TOTAL INCOME (LOSS) NON-OPERATING 260,944 -989,972 -989,972 -980,144 9,828-980,144 137 2012 2013 2013 2013 2014 INCREASE ACTUAL YTD ACTUAL PROJECTED BUDGET RECOMMENDED (DECREASE) CITY OF SUN PRAIRIE 2014 APPROVED BUDGET WATER POLLUTION CONTROL FACILITY 889,280 892,999 (1,133,044) (1,173,111) (945,516) 227,595 CHANGES IN ASSETS AND LIABILITY ACCRUALS (39,768) - - - - - DUE TO (FROM) OTHER FUNDS 366,991 - - - - - APPLY FUND BALANCE TO PURCHASES (354,000) DEBT AMORTIZATION 198,000 271,343 306,000 - 1,181,700 1,181,700 DEBT ISSUANCE COSTS - - - - - - DEPRECATION EXPENSE 1,324,714 - 1,355,000 1,350,000 1,415,000 65,000 NET INCREASE (DECREASE) IN CASH 2,742,563 1,164,342 527,956 645,479 1,297,184 BEGINNING CASH BALANCE 6,039,440 8,782,003 8,782,003 8,782,003 9,309,959 8,782,003$ 9,946,345$ 9,309,959$ 9,427,482$ 10,607,143$ ENDING CASH BALANCE TOTAL SOURCES (USES) OF FUNDS 138 WASTEWATER TREATMENT PLANT 2013 FTE 2014 FTE Change 2013 2014 Change WWTP Superintendent 1.0 1.0 - 108,825 108,893 68 WWTP Supervisor 1.0 1.0 - 94,248 96,472 2,224 Chemist 1.0 1.0 - 72,497 74,175 1,678 Maintenance Crewleader 1.0 1.0 - 71,424 72,896 1,472 Maintenance Worker 6.0 6.0 - 383,170 388,796 5,626 Seasonal Wages - - - 5,400 16,729 11,329 Overtime/Miscellaneous - - - 13,490 13,490 - TOTAL 10.0 10.0 - 749,054 771,451 22,397 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET PERSONNEL COSTS Position Title STAFFING SALARIES, WAGES & BENEFITS 139 City of Sun Prairie Capital Outlay Requests and 5 Year Plan Capital Item Included in Repl Fund? 2014 Quantity 2014 Requested ($) 2015 Projected ($) 2016 Projected ($) 2017 Projected ($) 2018 Projected ($) Sewer Capital Projects/Grouting/I&I No 1 $427,700 $533,000 $453,300 $453,300 $453,300 SCADA Computer Yes 1 $6,000 Pickup Truck - Ford F150 Yes 1 $23,000 Sewer Cleaning Truck Yes 1 $325,000 Replace Bird Sewer (Lothe to Linnerud) No 1 $356,000 GPS Unit Yes 1 $6,000 Portable Sampler Yes 1 $6,500 KVAR Controller Yes 1 $20,000 Lochnivar Boiler Yes 1 $30,000 Portable Flow Monitor Yes 1 $6,000 Water Purification System - Lab Yes 1 $8,500 Fire Alarms and Paging System Yes 1 $34,000 Water Softener System - Service Garage Yes 1 $14,000 Air Compressor - Service Garage Yes 1 $8,000 Variable Speed Drives - Influent Pumps Yes 4 $65,000 Hot Water Recir Pumps Yes 2 $11,000 SCADA Monitoring System Yes 1 $75,000 Utility Truck - Ford F350 Yes 1 $33,000 Flat Bed Truck - Ford F350 Yes 1 $28,000 80 KW Portable Generator Yes 1 $26,000 Thompson Portable Pump Yes 1 $20,000 New Holland Tractor and Loader Yes 1 $23,000 PLC Network System Yes 1 $12,000 Waukesha Generator Yes 1 $200,000 Primary Collectors Yes 2 $90,000 Primary Sludge Pumps Yes 2 $15,000 TAS Sludge Pumps Yes 2 $15,000 Electric Hoist Yes 2 $14,300 1000 Gallon Above Ground Fuel Tank Yes 1 $8,000 Electric Scissors Lift Yes 1 $14,000 ISCO Portable Sampler Yes 1 $7,000 Village Lift Yes 1 $250,000 TOTAL COST $1,137,700 $601,500 $810,800 $1,066,600 $453,300 WATER POLLUTION CONTROL FACILITY CAPITAL PROJECTS AND EQUIPMENT PLAN 140 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET - STORMWATER ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 INCREASE/ DECREASE ADOPTED 2014 OPERATING STORMWATER OPERATING REVENUES 65004400 443850 STORMWATER MANAGEMENT FEE 64,304 -2,570 20,000 20,000 30,900 10,90030,900 65004400 443851 STORMWATER BLDG PERMIT FEE 11,566 4,105 15,000 15,000 12,400 -2,60012,400 65004400 443852 STORMWATER EROSION CONT FEE 0 -244 0 0 0 00 65004600 468501 STORMWATER FEES - RESIDENTIA L 725,978 590,065 774,750 774,750 789,700 14,950789,700 65004600 468502 STORMWATER FEES - NON-RESIDE N 586,116 494,907 622,710 622,710 658,500 35,790658,500 65004800 488100 FOREFEITED DISCOUNTS 5,927 3,855 5,200 5,200 5,100 -1005,100 65004800 489000 MISCELLANEOUS REVENUES 393 11,942 0 0 0 00 1,394,284 1,102,060 1,437,660 1,437,660 1,496,600 58,9401,496,600 1,394,284SUB-TOTAL SWU MISCELLANEOUS REVENUE 1,102,060 1,437,660 1,437,660 1,496,600 58,9401,496,600 STORMWATER ADMINISTRATION EXPENSE 65085091 513000 OVERTIME 190 0 0 0 0 00 190 0 0 0 0 00 MATERIALS AND SUPPLIES 65085091 531000 OFFICE SUPPLIES 0 0 250 250 250 0250 65085091 532500 BANK SERVICE CHARGES 23 4 0 0 0 00 23 4 250 250 250 0250 65085091 544000 PROFESSIONAL SERVICES 86,494 93,861 120,000 120,000 120,000 0120,000 65085091 547000 BILLING SERVICES 52,743 49,212 52,000 52,000 52,000 052,000 139,237 143,073 172,000 172,000 172,000 0172,000 INSURANCE 65085091 551000 WORKERS' COMPENSATION COVE R 3,672 3,848 5,307 5,307 5,307 05,307 65085091 552000 PROPERTY COVERAGE 205 249 243 243 250 49292 65085091 553000 LIABILITY COVERAGE 662 816 784 784 858 74858 65085091 554000 VEHICLE COVERAGE 1,408 1,089 1,439 1,439 1,439 01,439 5,947 6,002 7,773 7,773 7,854 1237,896 PROFESSIONAL DEVELOPMENT 65085091 563000 MEETINGS AND TRAINING 458 0 1,000 1,000 1,000 01,000 458 0 1,000 1,000 1,000 01,000 145,855SUB-TOTAL SWU ADMINISTRATION 149,079 181,023 181,023 181,104 123181,146 141 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 INCREASE/ DECREASE ADOPTED 2014 STORMWATER MAINTENANCE EXPENSE PERSONNEL SERVICES 65085092 511000 REGULAR WAGES 157,591 146,520 159,426 159,426 162,018 2,592162,018 65085092 513000 OVERTIME 2,404 4,061 2,000 2,000 2,000 02,000 65085092 517000 MISCELLANEOUS COMPENSATION 973 739 1,024 1,024 1,024 01,024 65085092 519000 SEASONAL WAGES 10,876 7,049 9,600 9,600 9,600 09,600 171,844 158,369 172,050 172,050 174,642 2,592174,642 FRINGE BENEFITS 65085092 521000 SOCIAL SECURITY 12,904 11,666 973 12,623 12,768 14512,768 65085092 522000 RETIREMENT 9,791 9,084 9,887 9,887 10,046 15910,046 65085092 523000 HEALTH INSURANCE 49,536 49,798 51,964 51,964 53,944 1,98053,944 65085092 524000 LIFE INSURANCE 177 171 178 178 215 37215 65085092 525000 DENTAL INSURANCE 4,634 4,663 4,868 4,868 4,868 04,868 65085092 528000 POST EMPLOYMENT HEALTH PLAN 750 0 0 0 0 00 77,792 75,381 67,870 79,520 81,841 2,32181,841 MATERIALS AND SUPPLIES 65085092 532000 OPERATING SUPPLIES 13,316 17,854 15,000 15,000 15,000 015,000 65085092 533000 REPAIRS AND MAINTENANCE 20,514 29,571 33,500 33,500 33,500 033,500 65085092 535000 UNIFORMS 1,409 2,022 1,000 1,000 1,000 01,000 35,240 49,447 49,500 49,500 49,500 049,500 CONTRACTUAL SERVICES 65085092 542000 UTILITIES 11,756 10,337 9,500 9,500 9,500 09,500 65085092 544000 PROFESSIONAL SERVICES 54,047 50,409 70,400 70,400 70,400 070,400 65,803 60,745 79,900 79,900 79,900 079,900 PROFESSIONAL DEVELOPMENT 65085092 563000 MEETINGS AND TRAINING 378 0 500 500 500 0500 378 0 500 500 500 0500 TRANSFERS/BAD DEBT EXPENSE 65085092 571000 DEPRECIATION EXPENSE 868,425 0 900,000 900,000 900,000 0900,000 868,425 0 900,000 900,000 900,000 0900,000 1,219,481SUB-TOTAL SWU MAINTENANCE OPERATIONS 343,942 1,269,820 1,281,470 1,286,383 4,9131,286,383 STORMWATER STREET CLEANING EXPENSE MATERIALS AND SUPPLIES 65085093 532000 OPERATING SUPPLIES 0 107 0 0 0 00 65085093 533000 REPAIRS AND MAINTENANCE 13,719 3,188 13,200 13,200 13,200 013,200 65085093 536000 FUEL PURCHASES 22,310 17,848 20,000 20,000 20,000 020,000 142 ACTUAL 2013 YTD BUDGET 2013 ACTUAL 2012 RECOMMENDED 2014 PROJECTED 2013 INCREASE/ DECREASE ADOPTED 2014 36,029 21,143 33,200 33,200 33,200 033,200 CONTRACTUAL SERVICES 65085093 544000 PROFESSIONAL SERVICES 0 7,137 8,000 8,000 8,000 08,000 0 7,137 8,000 8,000 8,000 08,000 36,029SUB-TOTAL SWU STREET CLEANING 28,280 41,200 41,200 41,200 041,200 STORMWATER EROSION CONTROL EXPENSE CONTRACTUAL SERVICES 65085094 544000 PROFESSIONAL SERVICES 0 0 2,500 2,500 2,500 02,500 0 0 2,500 2,500 2,500 02,500 0SUB-TOTAL SWU EROSION CONTROL 0 2,500 2,500 2,500 02,500 -7,080TOTAL INCOME (LOSS) OPERATING 580,759 -56,883 -68,533 -14,587 53,904-14,629 NON-OPERATING STORMWATER NON-OPERATING REVENUES 65004200 420100 NON OPERATING CAPITAL CONTRI B 102,203 0 0 0 0 00 65004200 420200 CONTRIBUTED CAPITAL-MUNICIPAL -113,054 0 0 0 0 00 65004300 435850 STATE GRANTS - STORMWATER 0 0 60,000 100,000 0 -100,0000 65004700 471000 INVESTMENT INCOME 3,554 -1,326 2,000 2,000 3,100 1,1003,100 65004800 483200 SALE OF MATERIAL AND EQUIPMEN T 0 29,583 0 0 0 00 65004800 488800 UTILITY REIMBURSEMENT 152,405 0 0 0 0 00 65004900 491900 BOND PREMIUM 1,754 0 0 0 0 00 146,862 28,258 62,000 102,000 3,100 -98,9003,100 146,862SUB-TOTAL SWU OTHER FINANCE SOURCES 28,258 62,000 102,000 3,100 -98,9003,100 STORMWATER DEBT SERVICE 65085095 592000 PRINCIPAL ON DEBT 0 0 95,000 95,000 135,000 40,000135,000 65085095 594000 INTEREST ON DEBT 25,277 23,658 23,140 23,140 26,378 3,23826,378 65085095 597000 DEBT ISSUANCE EXPENSE 0 432 2,000 2,000 2,000 02,000 65085095 598000 AMORITIZATION OF DEBT DISCOUNT 2,086 0 0 0 0 00 27,363 24,090 120,140 120,140 163,378 43,238163,378 27,363SUB-TOTAL SWU DEBT SERVICE 24,090 120,140 120,140 163,378 43,238163,378 STORMWATER CAPITAL EXPENSE CAPITAL ITEMS 65085096 581000 MACHINERY & EQUIPMENT EXPEN S 0 246,590 325,000 325,000 130,000 -195,000130,000 0 246,590 325,000 325,000 130,000 -195,000130,000 143 ACTUAL 2012 ACTUAL 2013 YTD PROJECTED 2013 BUDGET 2013 RECOMMENDED ADOPTED INCREASE/ DECREASE 2014 2014 -60,142 -955,929 -1,251,740 -1,345,140 -1,900,278 -2,200,278 CAPITAL PROJECTS 65085096 544000 PROFESSIONAL SERVICES 90 5,462 0 0 0 0 0 65085096 583000 LAND ACQUISITION 0 0 0 0 0 300,000 300,000 65085096 585100 WATER MAIN 152,425 0 0 0 0 0 0 65085096 587000 STORM SEWER IMPROVEMENTS 17,688 708,045 868,600 1,002,000 1,610,000 1,610,000 608,000 65085096 589900 LOSS ON DISP OF CAPITAL ASSETS 9,437 0 0 0 0 0 0 179,641 713,506 868,600 1,002,000 1,610,000 1,910,000 908,000 SUB-TOTAL SWU CAPITAL PROJECTS 179,641 960,096 1,193,600 1,327,000 1,740,000 2,040,000 713,000 TOTAL INCOME (LOSS) NON-OPERATING -855,138               144 STORMWATER UTILITY 2013 FTE 2014 FTE Change 2013 2014 Change Maintenance Crewleader 1.0 1.0 - 67,349 68,727 1,378 Maintenance Worker 3.0 3.0 - 171,734 174,159 2,425 Seasonal Wages - - - 10,334 10,334 0 Overtime - - - 2,153 2,153 - TOTAL 4.0 4.0 - 251,570 255,373 3,803 CITY OF SUN PRAIRIE 2014 APPROVED BUDGET PERSONNEL COSTS Position Title STAFFING SALARIES, WAGES & BENEFITS 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164