Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
9.b. 2017 Budget
EXECUTIVE SUMMARY City Council Regular Meeting September 20, 2016 AGENDA ITEM: 2017 Budget AGENDA SECTION: New Business PREPARED BY: Dwight Johnson, City Administrator Jeff May, Finance Director AGENDA NO. 9.b. ATTACHMENTS: Resolution, 2017 Preliminary Budget Summary APPROVED BY: ddj RECOMMENDED ACTION: Adopt a Resolution Setting the Preliminary 2017 General Fund Operating Budget, the Preliminary 2017 C.I.P. Budgets, the Preliminary 2017 Insurance Budget, the Preliminary 2017 Port Authority Operating Levy and the Preliminary 2016 Levy and a Budget Hearing Date of December 6, 2016 at 7:00 p.m. at City Hall. EXECUTIVE SUMMARY The recommended budget for 2017 proposes an increase in the City’s property tax levy of 3.52%. This would result in an estimated annual increase of $21 in the City taxes assessed to a median value home. The estimated City tax on a median family home valued at $250,700 would be $990. A 4.37% increase in the median residential property value combined with the increased levy amount is responsible for the projected increase in 2017. Even with this increase, the City has reduced taxes on the median home by $68 since 2008 and the total amount of property tax levy is just under what it was in 2008. The budget shows some increased costs for operating new facilities including a new Park Maintenance position, a new Patrol Sergeant in Police, increased levy support for the City’s insurance fund and overall increased wages and benefits for 2017 based on current contracts in place. Partially offsetting these increased costs are increased development related fees for building permits, plan checks and administrative charges for development of new streets and utilities. A public hearing on the budget will be scheduled for December 6th at 7:00 p.m. in the City Hall Council Chambers. A summary of key characteristics of the proposed 2017 budget is shown in the following table: Budget Facts at a Glance Increase of property tax base from 2016 +5.79% Average increase in median value residential property +4.37% General fund spending change: +5.13% Total funding change – all tax impacted funds +$671,754 Change in overall tax levy from 2009 -$8 City share of tax impact on median value home +$21 Percentage tax change on median value home +2.17% Change in estimated tax rate (City share only) -2.76%(from .43149 to .41957) 2 BUDGET PROCESS The annual budget process begins with the discussion of goals and work plans by the City Council early in the year. This draft budget was initially developed by the Department Directors. We met with each Department Director and reviewed details of their budget with them. In addition, as a part of the budget review, we have looked again at 10 year needs projections for street improvements, equipment replacement, buildings and the Ice Arena. We have also reviewed our long term needs for major maintenance needs for parking lots, playgrounds, etc. Finally, we looked at the overall budget strategically one more time for its overall balance, consistency, impact on taxpayers, and long term impacts on finances for 2016 and beyond. Our hope was to develop the most conservative budget possible that: (1) is consistent with council goals (2) is consistent with previous council direction on levels of service, (3) does not weaken the City’s long range financial outlook. (4) is balanced not only between revenues and expenditures, but also is well balanced internally between personnel, equipment, technology, operating needs and capital expenditures. According to state law, the preliminary budget and levy must be adopted by September 30th and the final budget must be adopted by December 28th after a public hearing. GENERAL FACTORS AFFECTING THE BUDGET Tax Base For the fourth consecutive year, the overall tax base in the community has increased. The overall tax capacity value within the City is estimated to be 5.79% higher in 2017 than it was in 2016. The increase in market value of the median home in Rosemount is 4.37%. State Budget and Legislative Impacts There were no significant changes in State legislation for 2017. However, a state bonding bill was not approved and proposed state funding for a portion of the County Road 42/Highway 52 interchange was not approved. This will require more funding from the City’s gas tax allocation over the next several years. There are no levy limits for 2017. REVENUES Property taxes fund 75% of the General Fund budget. However, there are several other categories of General Fund revenues that are also important to the City. The chart below compares budgeted revenue for 2016 with estimated revenue in 2017 for several key categories of revenues. 3 2016 Budget 2017 Estimated Change Licenses & Permits $611,800 $695,900 +$ 84,100 Intergovernmental $679,400 $760,600 +$ 81,200 Charges for Services (no SKB) $458,800 $498,800 +$ 40,000 Fines & Forfeits $120,000 $120,000 $ -0- Recreational Revenues $226,800 $242,100 +$ 15,300 Miscellaneous Revenues $210,800 $148,800 -$ 62,000 SKB revenue (General Fund portion) $500,000 $625,000 +$125,000 Building permit revenues have varied from about $345,000 to $520,000 annually over the past three years and have been showing an upward trend. For 2017, we are estimating an amount of $480,000. Charges for Services includes an additional $192,000 in plan check fees which are related to building permits. EXPENDITURES Salaries Rosemount currently has 81 authorized full time employees. This compares with 81 full time employees at the beginning of 2008. Two new full-time employees are proposed for 2017. A new Patrol Sergeant is proposed to help handle increased police calls, reduce response time and reduce unsupervised shifts. All four bargaining unit contracts have contracts though the end of 2017. Health Insurance Our health insurance quote for 2017 increased by 24%. Staff has sought additional bids. If the increase stands, staff proposes to use a reserve established several years ago that allows us to budget according to the three year average of health insurance premium increases rather than be subject to extreme year to year variations (two years ago we had a decrease of 2.5% and last year we had an increase of 14.9%). Capital Budgets The City currently has three capital improvement program (CIP) funds: Equipment, Streets, and Buildings. Staff has not yet done a detailed review of the CIP and plans to bring a proposed 10 year CIP to the Council later this year. A general review of the trends for the purpose of setting CIP levies for 2017 has been done. The levy for the Equipment CIP is proposed to be $580,000, an increase of $20,000 due to future forecasted needs. The Street CIP is proposed to have a levy of $811,400 for 2017, an increase of 4.0% to reflect the growth rate of the City and inflation. The Building CIP has an ongoing levy of $24,000 for 2017 which is for the repayment of an internal loan for the current Public Works facility. The Building CIP fund paid for the City’s share of the Steeple Center redevelopment project and may also provide some funds for partnerships to develop indoor recreational facilities. It will also fund some improvements and updates planned for the Community Center, certain park projects and begin to provide for future City building needs. No tax levy above the current $24,000 is proposed. New SKB host agreement funds along with proceeds from past General Fund surpluses and proceeds from the former SKB Trust fund will provide the funds for these projects. Enterprise Fund Budgets Proposed water, sewer and storm water utility rates and budgets are being reviewed by the Utility Commission at this writing and will be presented to the Council later this year. 4 CONCLUSION The City has reduced the tax burden on the median value home in recent years and proposes a moderate increase of 3.52% this year. Additional development related fees will help offset salary and benefit costs as well as increased insurance costs so that Rosemount will once again have one of the lowest municipal levy increases in the County in 2017 while still maintaining our service levels and our long-range equipment and facilities replacement schedules. Even with the proposed 3.52% increase for 2017, the overall City levy will still be lower than it was in 2009 and the median home City taxes about $68 less per year than in 2009. 2017 CITY BUDGET REPORT TABLE OF CONTENTS To return to the Table of Contents, click the right side of any page. Budget Resolution 1 Proposed Levy Certification 3 Funding Requirements 7 2016 General Property Tax Levy Payable 2017 9 Estimated Residential Property Taxes 11 General Fund Revenues 12 Departmental Budgets City Council 16 Administration 18 Elections 23 Finance 25 General Government 30 Community Development 33 Police 38 Fire 46 Public Works 52 Government Buildings 55 Fleet Maintenance 56 Street Maintenance 57 Parks & Grounds Maintenance 59 Water Operating Fund (Enterprise Fund) 88 Sewer Operating Fund (Enterprise Fund) 94 Storm Water Operating Fund (Enterprise Fund) 99 Parks & Recreation 61 Other Financing Uses - Transfers 66 Capital Improvement Plan 68 Insurance 70 Port Authority 72 Debt Service Funds 75 Enterprise Funds Water Operating Fund 88 Sewer Operating Fund 94 Storm Water Operating Fund 99 Ice Arena 103 CITY OF ROSEMOUNT DAKOTA COUNTY, MINNESOTA RESOLUTION 2016 - A RESOLUTION SETTING THE PRELIMINARY 2017 GENERAL FUND OPERATING BUDGET, THE PRELIMINARY 2017 C.I.P. BUDGETS, THE PRELIMINARY 2017 INSURANCE BUDGET, THE PRELIMINARY 2017 PORT AUTHORITY OPERATING LEVY AND THE PRELIMINARY 2016 LEVY AND BUDGET HEARING DATE REQUIRED BY THE CITY OF ROSEMOUNT WHEREAS, the City Council of the City of Rosemount has determined that budgets and special needs for the year 2017 will be in the amount of $19,893,800 for the General Operating Fund, the three CIP Funds, the Insurance Fund, the Port Authority Fund and the Enterprise Funds; and WHEREAS, the City Council has determined that special levies for Bonded Indebtedness total $346,056 for 2 City issues (G.O. Public Facility Refunding Bonds 2010B and G.O. Capital Improvement Plan Refunding Bonds 2015B) and no levy necessary for any other City issues (utilizing other revenue sources); and WHEREAS, the City Council has determined that actual incomes, fund transfers and anticipated aids will total $8,812,400. NOW, THEREFORE BE IT RESOLVED, that the total Preliminary Levy certified to the Dakota County Auditor shall be $11,427,456; and BE IT FURTHER RESOLVED, that the City Council of the City of Rosemount will conduct a Public Hearing for the purpose of presenting the proposed budget and levy to the general public and to comply with Truth in Taxation laws as set by the Minnesota State Legislature, and that the hearing shall take place on Tuesday, December 6, 2016, at 7:00 P.M., in the Council Chambers at the City Hall. ADOPTED this 20th day of September, 2016. _____________________________ William H. Droste, Mayor ATTEST: __________________________ Clarissa Hadler, City Clerk Page 1 of 105 RESOLUTION 2016 - CERTIFICATION I hereby certify that the foregoing is a true and correct copy of a resolution presented to and adopted by the City Council of Rosemount at a duly authorized meeting thereof, held on the 20th day of September, 2016, as disclosed by the records of said City in my possession. (SEAL) _______________________________ Clarissa Hadler, Rosemount City Clerk Page 2 of 105 Page 3 of 105 2016 GENERAL PROPERTY TAX LEVY PAYABLE 2017 GENERAL LEVY GENERAL FUND $9,348,000 BUILDING CIP FUND $24,000 STREET CIP FUND $811,400 EQUIPMENT CIP FUND $580,000 INSURANCE FUND $260,000 PORT AUTHORITY OPERATING LEVY $58,000 ------------------------- TOTAL GENERAL LEVY $11,081,400 BONDED INDEBTEDNESS G.O. PUBLIC FACILITY REFUNDING BONDS 2010B (Old 2001C) (Port Authority) (Authorized - $166,061)$166,060 G.O. IMPROVEMENT BONDS 2013A (Authorized - $8,467) $0 G.O. IMPROVEMENT BONDS 2014A (Authorized - $1,233) $0 G.O. CAPITAL IMPROVEMENT PLAN (CIP) REFUNDING BONDS 2015B (Authorized - $179,997)$179,996 ------------------------- TOTAL BONDED INDEBTEDNESS $346,056 ------------------------- GRAND TOTAL 2016 PROPERTY TAX LEVY $11,427,456 ============== Last Updated 9/14/16 Page 4 of 105 Page 5 of 105 Page 6 of 105 FUNDING REQUIREMENTS - USES September 20, 2016 2016 2017 Adopted Proposed +/- Departments Budget Budget Difference Percentage --------------------------------------------------------------------------------------------------------------------------------------- Council Budget $281,628 $287,400 $5,772 2.05% Sales Tax Exemption Savings ($50,000)$0 $50,000 n/a Administration Budget 610,100 674,200 64,100 10.51% Elections Budget 48,200 20,000 (28,200)-58.51% Finance Budget 507,800 529,900 22,100 4.35% General Government Budget 326,800 323,600 (3,200)-0.98% Community Development Budget 1,005,600 1,057,600 52,000 5.17% Police Budget 3,689,800 3,943,300 253,500 6.87% Fire Budget 366,400 384,000 17,600 4.80% Public Works Operating Budgets: Government Buildings Budget 542,100 574,600 32,500 6.00% Fleet Maintenance Budget 683,500 654,900 (28,600)-4.18% Street Maintenance Budget 1,345,200 1,427,600 82,400 6.13% Parks Maintenance Budget 921,200 942,300 21,100 2.29% Park & Rec Budget - General Operating 1,249,400 1,290,100 40,700 3.26% Park & Rec Budget - Steeple Ctr. Operations 93,400 111,400 18,000 19.27% Park & Rec Budget - Special Programs 84,400 91,800 7,400 8.77% Transfers - Arena Assistance 130,000 130,000 0 0.00%-------------------------------------------------------------------------- Total Operating Budgets - General Fund $11,835,528 $12,442,700 $607,172 5.13% Building CIP Requirements 24,000 24,000 0 0.00% Street CIP Requirements 780,000 811,400 31,400 4.03% Equipment CIP Requirements 560,000 580,000 20,000 3.57% Insurance Budget Requirements 245,000 260,000 15,000 6.12% Port Authority Operating Levy 58,000 58,000 0 0.00% Bonded Indebtedness 347,874 346,056 (1,818)-0.52% Water Enterprise Fund 1,579,700 1,655,600 75,900 4.80% Sewer Enterprise Fund 2,060,600 2,204,200 143,600 6.97% Storm Water Enterprise Fund 743,000 1,246,800 503,800 67.81% Arena Enterprise Fund 594,700 611,100 16,400 2.76%-------------------------------------------------------------------------- Total Funding Requirements $18,828,402 $20,239,856 $1,411,454 7.50%======================================= Page 7 of 105 FUNDING REQUIREMENTS - SOURCES September 20, 2016 2016 2017 Adopted Proposed +/- Types Budget Budget Difference Percentage ----------------------------------------------------------------------------------------------------------------------------------- Internal Revenue Generated: Licenses and Permits 611,800 695,900 84,100 13.75% Intergovernmental 679,400 760,600 81,200 11.95% Charges for Services 958,800 1,123,800 165,000 17.21% Fines & Forfeits 120,000 120,000 0 0.00% Recreational Fees 226,800 242,100 15,300 6.75% Miscellaneous Revenues 210,800 148,800 (62,000)-29.41% Transfers In 3,500 3,500 0 0.00% Enterprise Revenues 4,978,000 5,717,700 739,700 14.86% ------------------------------------------------------------------------ Total Internal Revenues 7,789,100 8,812,400 1,023,300 13.14% Levy Sources: Special Levies 347,874 346,056 (1,818)-0.52% General Levy 10,691,428 11,081,400 389,972 3.65% ------------------------------------------------------------------------ Total Levy $11,039,302 $11,427,456 $388,154 3.52% ------------------------------------------------------------------------ Total Revenue Sources $18,828,402 $20,239,856 $1,411,454 7.50% ====================================== Page 8 of 105 2016 GENERAL PROPERTY TAX LEVY PAYABLE 2017 GENERAL LEVY GENERAL FUND $9,348,000 BUILDING CIP FUND $24,000 STREET CIP FUND $811,400 EQUIPMENT CIP FUND $580,000 INSURANCE FUND $260,000 PORT AUTHORITY OPERATING LEVY $58,000 ------------------------- TOTAL GENERAL LEVY $11,081,400 BONDED INDEBTEDNESS G.O. PUBLIC FACILITY REFUNDING BONDS 2010B (Old 2001C) (Port Authority) (Authorized - $166,061)$166,060 G.O. IMPROVEMENT BONDS 2013A (Authorized - $8,467) $0 G.O. IMPROVEMENT BONDS 2014A (Authorized - $1,233) $0 G.O. CAPITAL IMPROVEMENT PLAN (CIP) REFUNDING BONDS 2015B (Authorized - $179,997)$179,996 ------------------------- TOTAL BONDED INDEBTEDNESS $346,056 ------------------------- GRAND TOTAL 2016 PROPERTY TAX LEVY $11,427,456 ============== Last Updated 9/14/16 Page 9 of 105 SPREAD LEVY COMPUTATIONAL WORKSHEET (INCLUDING FIRE STATION LEVY) (Proposed) 2014 2015 2016 2017 -------------------------------------------------------------------- Total Funding Requirements 17,575,222 18,237,547 18,828,402 20,239,856 Less: Internal Revenues 6,953,800 7,409,800 7,789,100 8,812,400 -------------------------------------------------------------------- Equals: Revenues Needed 10,621,422 10,827,747 11,039,302 11,427,456 County Auditor Adjustments (All Subtractions): Fiscal Disparities Distribution Levy (Metro Area)1,208,535 1,172,199 1,121,469 1,175,131 (2) -------------------------------------------------------------------- Spread Levy Used to Compute Local Tax Rate 9,412,887 (1)9,655,548 (1)9,917,833 (1)10,252,325 Increase/(Decrease) from Previous Year in Spread Levy 2.58%2.72%3.37% (1) Actual Spread Levy Based on Numbers from Dakota County (2) 2017 Number Provided by Dakota County as of 8/4/16 Last Updated - 9/14/16 Page 10 of 105 CITY OF ROSEMOUNT WORKSHEET FOR ESTIMATING RESIDENTIAL PROPERTY TAXES (ISD #196 FIGURES) (Rates Based on Proposed Final Levy Numbers) (M/V Exclusion is Only Applicable to 2012 and Beyond) 204,686 (Value After M/V Exclusion)224,578 (Value After M/V Exclusion)236,023 (Value After M/V Exclusion)(+5.1%)289,760 (Value After M/V Exclusion) Market Value 221,950 (Payable 2015 Median)240,200 (Payable 2016 Median)250,700 (Est. Payable 2017 Median)(+4.37%)300,000 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ Year 2015 2016 2017 Est.2015 2016 2017 Est.2015 2016 2017 Est.2015 2016 2017 Est. ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ Tax Capacity 2,047 2,047 2,047 2,246 2,246 2,246 2,360 2,360 2,360 2,898 2,898 2,898 Tax Capacity Rates: City 0.45152 0.43149 0.41957 0.45152 0.43149 0.41957 0.45152 0.43149 0.41957 0.45152 0.43149 0.41957 County 0.29633 0.28570 0.28570 0.29633 0.28570 0.28570 0.29633 0.28570 0.28570 0.29633 0.28570 0.28570 School District 0.23271 0.24317 0.24317 0.23271 0.24317 0.24317 0.23271 0.24317 0.24317 0.23271 0.24317 0.24317 Miscellaneous 0.05033 0.05063 0.05063 0.05033 0.05063 0.05063 0.05033 0.05063 0.05063 0.05033 0.05063 0.05063 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ Totals 1.03089 1.01099 0.99907 1.03089 1.01099 0.99907 1.03089 1.01099 0.99907 1.03089 1.01099 0.99907 ======================================================================================================================== City Market Referendum 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 ISD #196 Market Ref 0.0025484 0.0026998 0.0026998 0.0025484 0.0026998 0.0026998 0.0025484 0.0026998 0.0026998 0.0025484 0.0026998 0.0026998 Dakota County Ref 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 2016 2017 Property Taxes: City 924 883 859 1,014 969 942 1,066 1,018 990 1,308 1,250 1,216 City Taxes $969 $990 County 607 585 585 665 642 642 699 674 674 859 828 828 City Market Ref.$0 $0 School District 476 498 498 523 546 546 549 574 574 674 705 705 ---------------------------- Miscellaneous 103 104 104 113 114 114 119 119 119 146 147 147 Total Taxes - Median $969 $990 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ Total Property Taxes 2,110 2,069 2,045 2,315 2,270 2,244 2,433 2,386 2,358 2,987 2,929 2,895 Increase / (Decrease)$21 City Market Referendum 0 0 0 0 0 0 0 0 0 0 0 0 ISD #196 Market Ref 566 599 599 612 648 648 639 677 677 765 810 810 Dakota County Ref 0 0 0 0 0 0 0 0 0 0 0 0 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ Grand Total All Taxes $2,676 $2,669 $2,644 $2,927 $2,919 $2,892 $3,072 $3,063 $3,035 $3,752 $3,739 $3,705 ======================================================================================================================== 344,260 (Value After M/V Exclusion)414,000 (Value After M/V Exclusion) Market Value 350,000 414,000 History of Actual Tax Capacity Rates (Using ISD #196 Rates) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ Year 2015 2016 2017 Est.2015 2016 2017 Est.2012 2013 2014 2015 2016 2017 Est. ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ Tax Capacity 3,443 3,443 3,443 4,140 4,140 4,140 (2.76% Decrease) Tax Capacity Rates: City 0.45152 0.43149 0.41957 0.45152 0.43149 0.41957 0.46994 0.48862 0.47676 0.45152 0.43149 0.41957 (1), (2) County 0.29633 0.28570 0.28570 0.29633 0.28570 0.28570 0.31426 0.33421 0.31827 0.29633 0.28570 0.28570 (2) School District 0.23271 0.24317 0.24317 0.23271 0.24317 0.24317 0.28440 0.27956 0.27606 0.23271 0.24317 0.24317 (2) Miscellaneous 0.05033 0.05063 0.05063 0.05033 0.05063 0.05063 0.05562 0.05884 0.05538 0.05033 0.05063 0.05063 (2) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ Totals 1.03089 1.01099 0.99907 1.03089 1.01099 0.99907 1.12422 1.16123 1.12647 1.03089 1.01099 0.99907 ======================================================================================================================== City Market Referendum 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 (2) ISD #196 Market Ref 0.0025484 0.0026998 0.0026998 0.0025484 0.0026998 0.0026998 0.0022131 0.0023542 0.0025809 0.0025484 0.0026998 0.0026998 (2) Dakota County Ref 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000551 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 (2) Property Taxes: City 1,554 1,485 1,444 1,869 1,786 1,737 Net Tax Capacity Percentages County 1,020 984 984 1,227 1,183 1,183 For Residential Homesteads: School District 801 837 837 963 1,007 1,007 Miscellaneous 173 174 174 208 210 210 Equal to or Less Than $500,000 1.00%1.00%1.00% ------------------------------------------------------------------------------------------------------------Over $500,000 1.25%1.25%1.25% Total Property Taxes 3,549 3,480 3,439 4,268 4,185 4,136 City Market Referendum 0 0 0 0 0 0 ISD #196 Market Ref 892 945 945 1,055 1,118 1,118 (For 2002 Through 2011 Credit Applied to All Organizations Proportionately) Dakota County Ref 0 0 0 0 0 0 (For 2012 and On Credit Eliminated-Replaced with Market Value Adjustment) ------------------------------------------------------============================== Grand Total All Taxes $4,441 $4,425 $4,384 $5,323 $5,303 $5,254 ============================================================ (1) This Figure Derived Using Figures Provided by Dakota County: (a) 2016 Projected Levy Less Fiscal Disparities as of 8/29/16 10,252,325 /24,435,137 =0.41957 (b) Net Tax Capacity Figure as of 3/7/16 (With M/V Exclusion)27,737,808 (5.79% Increase from Final Pay 2016) (c) Captured Tax Increment Tax Capacity as of xx/xx/16 (787,267) (x.xx% Increase from Final Pay 2016) (d) Contribution to Fiscal Disparities as of 8/4/16 (2,515,404) (2.80% Increase from Final Pay 2016) ------------------ Last Updated - 9/14/16 (2) These Figures Provided by Dakota County as of xx/xx/16 24,435,137 (For 2012 and on the City of Rosemount does not have a Referendum Levy) Page 11 of 105 Page One 2017 BUDGET WORKSHEETS GENERAL FUND REVENUES September 20, 2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 101 31010.00 Current Ad Valorem Taxes $7,160,549 $7,437,178 $7,615,397 $7,902,959 $8,172,869 From County 101 31040.00 Fiscal Disparities 1,235,453 1,208,535 1,172,199 1,121,469 1,175,131 From County ---------------------------------------------------------------------------------------------------------------- Total Taxes (Tax)8,396,002 8,645,713 8,787,596 9,024,428 9,348,000 Total Property Tax Levy for Fund 101 101 32110.00 Alcoholic Beverage Licenses (L)37,900 36,695 42,080 38,000 40,000 _________________________________ 101 32160.00 Licenses to do Business (L)7,440 7,990 8,410 8,000 8,500 Garbage Haulers, Ped Licenses, etc. 101 32162.00 Lic to do Business-Rental Housing (L)5,775 12,500 4,025 12,000 5,000 _________________________________ 101 32180.00 Tobacco Licenses (L)0 0 5,500 7,000 7,000 New Requirement Beginning in 2016 101 32210.00 Building Permit Revenue (L)345,004 515,616 453,003 425,000 480,000 _________________________________ 101 32212.00 Mineral Extraction Permit (L)1,490 1,860 2,600 1,200 1,500 _________________________________ 101 32220.00 Electrical Permit Revenue (L)19,565 20,222 23,535 15,000 20,000 _________________________________ 101 32221.00 Admin Fee - Electrical Permits (L)7,260 8,048 6,742 7,000 7,000 _________________________________ 101 32230.00 Plumbing Permit Revenue (L)35,205 47,318 62,316 37,000 50,000 _________________________________ 101 32240.00 Animal Licenses (L)1,604 1,741 1,791 2,000 1,800 _________________________________ 101 32250.00 Sewer Permit Revenue (L)9,994 9,675 11,315 9,000 9,000 _________________________________ 101 32255.00 County Recording Fee-City's (L)130 120 160 100 100 _________________________________ 101 32260.00 HVAC Permit Revenue (L)50,375 68,600 71,267 50,000 65,000 _________________________________ 101 32290.00 Other Non-Bus Lic & Permits (L)390 380 2,020 500 1,000 Alarm Permits & Fireworks Permits ---------------------------------------------------------------------------------------------------------------- Total Licenses & Permits (L)522,131 730,765 694,765 611,800 695,900 101 31010.00 Current Ad Valorem Taxes (I)86,000 0 0 0 0 Included in Debt Levy Figure 101 31010.01 MSABC Armory Payments 0 ** Will Use Reserves Thru Final Pymt ** 101 31020.00 Delinquent Ad Valorem Taxes (I)113,915 113,740 58,970 0 0 From County 101 31030.00 Mobile Home Taxes (I)10,241 12,257 6,316 12,000 7,000 From County 101 31710.00 Gravel Taxes (I)19,467 39,275 83,275 100,000 100,000 From County 101 31810.00 Franchise Taxes - Regular Fees (I)216,687 227,039 227,388 225,000 227,000 From Cable Company 101 31811.00 Franchise Taxes - PEG Fees (I)22,911 22,111 21,627 23,000 22,000 From Cable Company 101 31920.00 Forfeited Tax Sale Apportionment (I)0 0 0 0 0 From County 101 33100.00 Federal Grants & Aids (I)0 0 96,190 0 50,000 Cops Grant 101 33416.00 Police Training Reimbursement (I)160,129 160,347 177,808 172,500 From State 101 33416.01 Post Board Training Reimb 7,000 7,000 _________________________________ 101 33416.02 State Aid (Tied to PERA)152,500 165,500 _________________________________ 101 33418.00 MSA for Streets - Maintenance (I)32,790 32,790 41,235 32,800 41,300 From State 101 33423.00 Ag Preserves Credit (I)3,424 3,736 7,347 3,000 4,000 From State 101 33425.00 Other State Grants & Aids (I)38,515 58,620 46,220 35,000 46,000 From State-PERA Aid & Safe & Sober 101 33620.00 Other County Grants & Aids (I)20,635 22,536 23,000 23,000 24,000 Dakota County Recycling Funds 101 33630.00 Police Services Levy-ISD #196 (I)63,493 64,128 64,769 66,100 66,800 _________________________________ 101 33630.00 Liaison Funding 66,800 From ISD #196 101 33720 Other Organization Grants 0 0 2,500 0 0 2015 - Walmart Police Grant ---------------------------------------------------------------------------------------------------------------- Total Intergovernmental (I)788,207 756,579 856,645 679,400 760,600 ---------------------------------------------------------------------------------------------------------------- PAGE TOTALS 9,706,340 10,133,057 10,339,007 10,315,628 10,804,500 Page 12 of 105 Page Two 2017 BUDGET WORKSHEETS GENERAL FUND REVENUES September 20, 2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 101 34103.00 Zoning & Subdivision Fees (C)27,183 60,915 44,545 40,000 42,000 _________________________________ 101 34104.00 Plan Checking Fees (C)124,959 212,622 185,952 175,000 192,000 _________________________________ 101 34105.00 Sales of Maps & Publications (C)233 160 120 300 300 Maps & Spec Books 101 34108.00 Admin Fees - Other Funds (C)110,000 _________________________________ 101 34108.01 Applicable Funds Except Const.25,000 25,000 25,000 25,000 25,000 _________________________________ 101 34108.02 Construction Funds 42,456 66,830 116,079 85,000 85,000 85% of 5% Fee for Const. Projects 101 34109.00 Other Charges for Service (C)5,094 4,322 7,331 5,000 5,000 _________________________________ 101 34110.00 Service Chg on Returned Chks (C)60 90 60 100 100 _________________________________ 101 34112.00 Utility Permit Application Fee (C)0 0 0 0 0 _________________________________ 101 34113.00 Application Fees (C)0 0 0 0 0 _________________________________ 101 34150.00 User Fees - SKB (C)86,115 82,943 149,072 120,000 180,000 SKB Fees - C & D Cell Fees 101 34151.00 User Fees/Host Agreements - SKB(C)156,033 25,000 0 0 0 _________________________________ 101 34151.00 Landscaping Agreement 0 Landscaping Agreement 101 34152.00 User Fees - SKB (C)17,959 28,690 25,675 20,000 25,000 SKB Fees - MSW Ash Charges 101 34153.00 User Fees - SKB (C)167,414 390,484 325,253 360,000 420,000 SKB Fees - Base Service Charges 101 34160.00 National Guard Maint Fees (C)54,673 50,560 50,560 46,000 54,500 _________________________________ 101 34160.00 Shared Space Maint. Agreement 16,000 Snow Removal / Mowing 101 34160.00 Building Maintenance Contract 38,500 _________________________________ 101 34201.00 Special Police Services (C)11,809 13,362 14,852 20,000 16,000 Contractual O/T for Officers 101 34202.00 Fire Services - Burning Permits (C)750 750 750 200 700 No Longer Charge for Permits 101 34203.00 Accident Reports (C)12 0 5 0 0 _________________________________ 101 34204.00 Day Care Inspection Fees (C)200 50 50 200 100 _________________________________ 101 34206.00 Other Police Services (C)4,293 526 4,654 0 2,000 _________________________________ 101 34207.00 Other Fire Protection Services (C)15,751 15,902 16,278 16,900 _________________________________ 101 34207.01 U of M Fire Contract 5,200 5,200 _________________________________ 101 34207.02 Coates Fire Contract 10,700 10,700 _________________________________ 101 34207.03 Other Billed Fire Calls 2,100 1,000 _________________________________ 101 34303.00 Mow Weeds (C)3,339 4,112 2,188 3,000 3,000 _________________________________ 101 34304.00 Sweep/Plow Streets (C)501 987 871 500 700 _________________________________ 101 34306.00 Other Highway & Street Rev (C)42,022 40,563 72,058 30,000 40,000 Street Light Bills - Developers 101 34310.00 Right-of-Way Permits (C)5,350 11,446 18,534 8,000 12,000 _________________________________ 101 34407.00 City Share of Metro SAC Chgs (C)2,601 2,309 5,407 2,500 3,500 _________________________________ ---------------------------------------------------------------------------------------------------------------- Total Charges for Services (C)793,806 1,037,621 1,065,295 958,800 1,123,800 101 35101.00 Court Fines (F)106,617 116,384 114,580 120,000 120,000 From County ---------------------------------------------------------------------------------------------------------------- Total Fines & Forfeits (F)106,617 116,384 114,580 120,000 120,000 101 34718.00 Tournament Fees (R)25,005 12,606 20,538 12,000 18,000 New Fee for 2012 101 34719.00 Player Maintenance Fees (R)0 0 0 0 0 New Fee for 2011 101 34720.00 Park Reservations (R)1,604 2,168 4,678 3,400 4,000 _________________________________ 101 34721.00 Softball Revenues (R)41,100 37,559 25,369 36,000 25,000 _________________________________ 101 34724.00 Tennis Revenues (R)2,175 2,480 1,995 2,400 2,200 _________________________________ 101 34726.00 Rosettes Revenues (R)2,288 2,222 1,966 2,100 2,000 _________________________________ 101 34727.00 Field Trip Revenues (R)7,000 _________________________________ 101 34727.01 Youth/Teen Trips 0 0 0 0 0 _________________________________ 101 34727.02 Adult/Senior Trips 8,050 7,621 10,072 7,000 7,000 _________________________________ 101 34728.00 Adult Soccer League Revenues (R)12,322 9,942 53 0 0 No Longer Offered 101 34730.00 Run for the Gold Revenues (R)4,677 5,540 4,344 5,500 4,800 _________________________________ 101 34731.00 Youth Soccer Lessons (R)3,298 2,441 1,364 2,400 2,400 _________________________________ 101 34732.00 Adult Basketball Revenues (R)1,214 2,054 1,867 2,000 2,000 _________________________________ 101 34733.00 Other Programs Revenues (R)13,804 13,014 11,180 13,000 13,000 _________________________________ 101 34735.00 Camps Revenues (R)23,594 23,873 26,851 23,000 30,000 _________________________________ 101 34736.00 T-Ball Lessons (R)5,224 4,130 3,961 4,500 4,000 _________________________________ 101 38080.00 Banquet Room Fees (R)39,623 43,171 51,089 50,000 50,000 _________________________________ 101 38081.00 Auditorium Fees (R)4,444 5,973 7,310 6,000 6,500 _________________________________ 101 38082.00 Gymnasium Fees (R)24,173 26,242 29,292 27,000 28,000 _________________________________ 101 38086.00 Classroom Fees (R)8,465 8,968 9,448 8,500 9,000 _________________________________ 101 38096.00 Liquor Provider Fees (R)900 660 600 800 600 _________________________________ 101 38097.00 A/V Rental Fees (R)710 456 450 1,000 500 _________________________________ 101 38154.00 Teen Night Revenues (R)693 631 527 700 600 _________________________________ 101 38201.00 Rental Revenues 11,910 4,800 0 18,000 28,000 Steeple Center Operations 101 38205.00 A/V Rental Revenues 0 0 0 500 2,000 Steeple Center Operations 101 38209.00 Miscellaneous Revenues 0 175 0 0 0 Steeple Center Operations 101 38211.00 Security Services 1,729 651 0 1,000 2,500 Steeple Center Operations 101 38301.00 Rental Revenues 0 0 0 0 0 Senior / Activity Center Operations 101 38305.00 A/V Rental Revenues 0 0 0 0 0 Senior / Activity Center Operations ---------------------------------------------------------------------------------------------------------------- Total Recreation Fees (R)237,001 217,377 212,956 226,800 242,100 ---------------------------------------------------------------------------------------------------------------- PAGE TOTALS 1,137,424 1,371,381 1,392,831 1,305,600 1,485,900 Page 13 of 105 Page Three 2017 BUDGET WORKSHEETS GENERAL FUND REVENUES September 20, 2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 101 36101.00 Principal - Special Assessments (M)4,470 4,457 0 2,000 0 From County - 101 Funded Projects 101 36102.00 Penalties & Interest - S/A (M)0 195 0 0 0 From County 101 36210.00 Interest Earnings - Investments (M)90,851 176,177 122,664 90,000 120,000 _________________________________ 101 36214.00 Net Change in FV-Investments (M)(357,024)231,871 16,629 0 0 Annual Market Value Changes 101 36215.00 Interest Earnings (M)147 122 837 300 800 From Checking Account 101 36220.00 Rents & Royalties (M)15,090 17,371 18,399 1,000 3,000 _________________________________ 101 36220.01 Garden Plot Rentals 2,000 Antenna to Water Utility Fund in 2016 101 36220.02 Athletic Complex Land Rental 1,000 _________________________________ 101 36230.00 Contribution/Donations (M)12,923 28,756 39,800 0 0 _________________________________ 101 36260.00 Other Revenue (M)6,084 2,086 11,524 10,500 10,500 Includes $7,500 for Health Reinsurance 101 36262.00 Special Settlements (M)13,156 0 0 0 0 _________________________________ 101 36263.00 Wellness Program Revenues 0 3,926 15,643 0 10,000 _________________________________ 101 36265.00 Use of Reserve Funds (M)0 41,000 0 102,500 0 _________________________________ 101 36265.01 Elections Balancing 0 0 0 0 0 Elections Balancing 101 36265.02 Health Insurance Adjustment 0 0 0 0 0 Health Insurance Adj/Assignment 101 38090.00 City Concessions (M)4,809 4,229 4,099 4,500 4,500 _________________________________ ---------------------------------------------------------------------------------------------------------------- Total Misc Revenues (M)(209,494)510,191 229,594 210,800 148,800 101 39202.00 Contribution from Enterprises (T)3,500 3,500 3,500 3,500 3,500 Arena - Building & Grounds Maint. 101 39203.00 Transfer From____________ (T)0 0 12,623 0 0 Funds Returned from Projects ---------------------------------------------------------------------------------------------------------------- Total Transfers In (T)3,500 3,500 16,123 3,500 3,500 ---------------------------------------------------------------------------------------------------------------- PAGE TOTALS ($205,994)$513,691 $245,717 $214,300 $152,300 FUND TOTALS $10,637,770 $12,018,129 $11,977,556 $11,835,528 $12,442,700 INTERNAL REVENUES $2,241,768 $3,372,416 $3,189,959 $2,811,100 $3,094,700 Grand Total Less: Ad Valorem =========================================================== & Fiscal Disparities Page 14 of 105 Page Four 2017 BUDGET WORKSHEETS GENERAL FUND REVENUES September 20, 2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 101 34108.00 General Fund Admin Fees $25,000 $25,000 $25,000 $25,000 $25,000 101 34108.01 Fund 201 6,000 101 34108.02 Fund 202 2,500 101 34108.03 Fund 203 2,500 101 34108.04 Fund 206 2,500 101 34108.05 Fund 207 2,500 101 34108.06 Fund 605 1,000 101 34108.07 Fund 606 1,000 101 34108.08 Fund 607 1,000 101 34108.09 Fund 650 6,000 ---------------------------------------------------------------------------------------------------------------- Admin Fees Breakdown Totals $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 =========================================================== Page 15 of 105 CITY COUNCIL The City Council is responsible for establishing the mission and vision for the City of Rosemount. The Council also establishes community goals and supervises the activities of the City Administrator. POLICY DEVELOPMENT •Provides for the legislative and policy-making activities for all of municipal government. •Provides for the planning and control of all City expenditures through the adoption of the City's annual budget. •Provides for the definition of the City's tax structure through the levying of taxes and approval of user fees and rate structures. •Provides for citizen input to policy-making process by establishing, appointing and managing advisory commissions, ad hoc committees and community groups. GENERAL OPERATIONS •Provides funding for general government projects and needs such as: City Newsletter Chamber of Commerce Directory Page 16 of 105 Page One 2017 BUDGET WORKSHEETS COUNCIL September 20, 2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- All Salary Costs Inclusive of 101 41110 103.00 Salaries & Benefits $37,181 $37,346 $40,976 $39,800 $41,300 Salary, Taxes, PERA & Benefits 101 41110 01 225.00 Landscaping Materials 24,923 45,181 26,368 0 25,000 Funding From SKB Revenues 101 41110 01 307.00 City Promotional Fees 23,100 ____________________________ 101 41110 01 307.01 Newsletter 14,637 14,424 14,357 15,000 15,000 3 Newsletters 101 41110 01 307.02 Chamber of Commerce Directory 1,069 1,000 1,000 1,100 1,100 ____________________________ 101 41110 01 307.03 Community Survey 0 0 0 0 0 ____________________________ 101 41110 01 307.04 Community Events 0 0 7,000 7,000 7,000 Leprechaun Days Fireworks 101 41110 01 315.00 Special Programs 4,226 982 2,725 3,000 3,000 Promotions, Marketing, etc. 101 41110 01 319.00 Other Professional Services 33,000 ____________________________ 101 41110 01 319.01 Education Reimbursement 7,307 10,230 5,521 12,000 12,000 ____________________________ 101 41110 01 319.02 Intergovernmental Initiatives 0 4,177 7,644 20,000 15,000 ____________________________ 101 41110 01 319.03 Open Government Intiatives 0 0 0 22,828 6,000 ____________________________ 101 41110 01 321.00 Telephone Costs 400 ____________________________ 101 41110 01 321.02 Mayor's Cell Phone 389 389 389 400 400 ____________________________ 101 41110 01 329.00 Other Communication Costs 0 0 0 500 500 Newspaper Ads / Open Houses 101 41110 01 331.00 Travel Expense 8,000 ____________________________ 101 41110 01 331.01 NLC Conference 4,455 4,092 4,302 6,000 6,000 ____________________________ 101 41110 01 331.02 Miscellaneous Travel 2,043 1,112 2,776 2,000 2,000 ____________________________ 101 41110 01 433.00 Dues & Subscriptions 28,600 ____________________________ 101 41110 01 433.01 LMC Dues 16,126 16,700 17,485 17,600 18,500 ____________________________ 101 41110 01 433.02 AMM Dues 7,507 7,597 7,656 7,800 8,000 ____________________________ 101 41110 01 433.03 Dak Cty Regional Chamber 0 0 0 100 100 ____________________________ 101 41110 01 433.04 NLC Dues 1,861 1,861 1,861 2,000 2,000 ____________________________ 101 41110 01 433.05 Miscellaneous Dues 0 0 0 0 0 ____________________________ 101 41110 01 435.00 Books & Pamphlets 0 0 0 100 100 ____________________________ 101 41110 01 437.00 Conferences & Seminars 14,000 ____________________________ 101 41110 01 437.01 Registration & Hotel-LMC Conf 394 1,003 1,552 2,000 2,000 ____________________________ 101 41110 01 437.02 Registration & Hotel-NLC Conf 7,541 7,040 10,538 9,000 9,000 ____________________________ 101 41110 01 437.03 Miscellaneous Conferences 0 875 674 3,000 3,000 ____________________________ 101 41110 01 439.00 Other Miscellaneous Charges 426 381 0 400 400 ____________________________ 101 41110 01 598.00 Council Designated 3,991 573,534 337,226 100,000 100,000 '14 & '15-Assignment for Projects 101 41110 01 598.01 Assignment for Health Ins. Increases 0 0 0 0 0 ____________________________ 101 41110 01 598.02 Sales Tax Exemption Savings 0 0 0 (50,000)0 0 Year 2 of 2 Phase Out 101 41110 01 598.03 Salary & Benefit Contingency 0 0 0 0 0 ____________________________ 101 41110 01 599.00 Employee Recognition Costs 10,000 ____________________________ 101 41110 01 599.01 Employee Recognition Costs 2,726 2,787 3,340 3,500 3,500 ____________________________ 101 41110 01 599.02 Vending Machine Costs 3,874 3,206 3,928 4,000 4,000 Offset by Revenue from Machines 101 41110 01 599.03 Commemorations 447 971 1,311 1,200 1,200 ____________________________ 101 41110 01 599.04 Commission/Volunteer Recognition 1,296 1,322 394 1,300 1,300 ____________________________ ------------------------------------------------------------------------------------------ PAGE TOTALS $142,417 $736,211 $499,025 $231,628 $287,400 DEPARTMENT TOTALS $142,417 $736,211 $499,025 $231,628 $287,400 ================================================ Page 17 of 105 ADMINISTRATION DEPARTMENT The Administration Department is responsible for the overall management of all departments within the City and for assuring that departmental activities are consistent with the goals established by the City Council. GENERAL ADMINISTRATION •Provides overall management, administration and coordination of activities in all City departments including: Community Development, Finance, Fire, Police, Public Works and Parks & Recreation. •Provides for preparation and overall management of the City's budgets. •Provides project management for projects that are unique and therefore not assignable to any other department. •Provides overall coordination of City consultants. •Provides for the execution of all policies as adopted by the City Council. •Provides administrative and clerical support to the City Council including the preparation, distribution and maintenance of City Council meeting documents. •Provides support for Youth Commission, Cable Commission, Safety Committee and Volunteer Program RECORDS MANAGEMENT •Provides for the preparation and maintenance of official records for the City including Council, Port Authority and Commission minutes. •Prepares and assures publication and posting of official notices. •Provides public information on ordinances, contracts and policies. •Administers the collection, storage and dissemination of data. •Provides for the maintenance, training and supervision of the digital document management system. Page 18 of 105 ADMINISTRATION DEPARTMENT - Page 2 LICENSING • Provides for the issuance and renewal of the following licenses: Liquor Peddlers, solicitors and transient merchants Lawful purpose gambling premise permits Block party street closures Massage therapy Arcade parlor, billiard hall and dance club PERSONNEL ADMINISTRATION • Administers overall human resources programs and services. Provides services to improve employee recruitment, retention, safety, training, orientation and relations. • Administers the City’s personnel policies and procedures, assures compliance with union contract language, as well as state and federal labor regulations. • Administers employee compensation, insurance, and benefit plans, assuring compliance with state and federal regulations. PUBLIC INFORMATION AND MARKETING • Prepares communications to residents about City government activities. • Creates and coordinates marketing publications directed to business sectors outside of the community for economic development. • Assists in preparing messages and collateral material for internal communications. Page 19 of 105 ADMINISTRATION DEPARTMENT - Page 3 STAFFING • For 2017, the department will consist of five positions: City Administrator Assistant City Administrator Communications Coordinator City Clerk Human Resources Coordinator PERFORMANCE MEASURES Worker’s Compensation Modification Factor 2011 2012 2013 2014 2015 2016 .90 .88 .82 .85 .92 n/a Turnover Rate of City Personnel 2011 2012 2013 2014 2015 2016 5.2% 2.6% 2.6% 5.1% 5.1% 4.9% (8 Months) Average Monthly Unique Views on City Website 2011 2012 2013 2014 2015 2016 6,555 7,423 6,916 9,722 12,499 14,586 (8 Months) n/a – Information Not Available Page 20 of 105 Page One 2017 BUDGET WORKSHEETS ADMINISTRATION September 20, 2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- All Salary Costs Inclusive of 101 41320 101.00 Salaries & Benefits $386,547 $404,313 $412,421 $431,100 $550,500 Salary, Taxes, PERA & Benefits 101 41320 101.00 Human Resources Coordinator 0 0 0 48,300 0 New Position - Start 7/1/16 101 41320 102.00 Full-Time Overtime 0 0 0 0 0 ____________________________ 101 41320 103.00 Part-Time Salaries & Benefits 0 5,359 4,322 0 0 ____________________________ 101 41320 01 209.00 Other Office Supplies 0 31 0 300 300 Miscellaneous Purchases 101 41320 01 313.00 Temporary Service Fees 0 0 0 0 0 ____________________________ 101 41320 01 319.00 Other Professional Services 0 0 0 0 0 ____________________________ 101 41320 01 321.00 Telephone Costs 1,572 1,322 1,322 1,600 1,600 Administration Cell Phones 101 41320 01 331.00 Travel Expense 1,200 ____________________________ 101 41320 01 331.01 NLC Conference 0 0 0 0 0 ____________________________ 101 41320 01 331.02 ICMA Conference 328 391 0 700 700 ____________________________ 101 41320 01 331.03 Miscellaneous Travel 353 226 252 500 500 ____________________________ 101 41320 01 433.00 Dues & Subscriptions 2,700 ____________________________ 101 41320 01 433.01 MCMA Dues 269 275 281 300 300 ____________________________ 101 41320 01 433.02 MAMA Dues 0 0 0 0 0 ____________________________ 101 41320 01 433.03 MCFOA Dues 35 35 85 100 100 ____________________________ 101 41320 01 433.04 Munici-Pals 25 25 25 100 100 ____________________________ 101 41320 01 433.05 IIMC Dues 0 185 0 200 200 City Clerk Association 101 41320 01 433.06 ICMA Dues 1,795 1,831 1,877 1,900 1,900 ____________________________ 101 41320 01 433.07 APMP Dues 60 50 40 100 100 ____________________________ 101 41320 01 435.00 Books & Pamphlets 0 0 0 100 100 ____________________________ 101 41320 01 437.00 Conferences & Seminars 8,800 ____________________________ 101 41320 01 437.01 Registration & Hotel - LMC 0 482 687 500 700 ____________________________ 101 41320 01 437.02 Registration & Hotel - MCMA 1,429 629 1,444 1,500 1,500 ____________________________ 101 41320 01 437.04 Staff (1) Each 0 0 0 0 0 ____________________________ 101 41320 01 437.05 Miscellaneous Seminars 0 40 17 300 300 ULI / Greening Initiatives 101 41320 01 437.06 Registration & Hotel - ICMA 3,399 2,995 1,556 3,400 3,400 ____________________________ 101 41320 01 437.07 City Clerk Training 1,240 1,507 2,224 2,700 2,700 All MCFOA Events -MMCI 101 41320 01 437.08 Registration & Hotel - NLC 0 0 0 0 0 ____________________________ 101 41320 01 437.09 Miscellaneous Meetings 89 0 111 200 200 ____________________________ 101 41320 01 439.00 Other Miscellaneous Charges 0 202 20 200 200 ____________________________ 101 41320 01 580.00 Other Equipment Purchases 0 6 0 200 200 ____________________________ ------------------------------------------------------------------------------------------ PAGE TOTALS 397,141 419,902 426,683 494,300 565,600 Page 21 of 105 Page Two 2017 BUDGET WORKSHEETS ADMINISTRATION September 20, 2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 101 41320 31 305.00 Medical & Dental Fees 9,200 Employee Drug Testing 101 41320 31 305.01 Pre-Employment Physicals 630 1,177 1,725 900 900 ____________________________ 101 41320 31 305.02 Employee Drug Testing 1,166 1,716 1,588 1,200 800 ____________________________ 101 41320 31 305.03 PCORI Fees 0 284 343 0 0 ____________________________ 101 41320 31 305.04 Reinsurance Costs 0 0 7,371 7,500 7,500 Costs Reimbursed by Grants 101 41320 31 306.00 Personnel Testing & Recruitment 0 1,825 6,198 8,000 8,000 ____________________________ 101 41320 31 315.00 Special Programs 11,500 ____________________________ 101 41320 31 315.01 Employee Training 49 0 132 1,000 1,000 ____________________________ 101 41320 31 315.02 Health & Wellness 206 594 500 500 500 Wellness & Health Management 101 41320 31 315.04 SW/WC Co-op Wellness Grant 0 3,912 15,557 0 10,000 Costs Reimbursed by Grants 101 41320 31 319.00 Other Professional Services 4,000 ____________________________ 101 41320 31 319.01 Labor Consultant 0 0 0 500 500 ____________________________ 101 41320 31 319.02 Labor Legal Issues 0 0 1,148 700 700 ____________________________ 101 41320 31 319.04 COBRA Consultant 699 518 715 800 800 ____________________________ 101 41320 31 319.05 Flex/VEBA Administrative Fees 1,770 1,945 1,920 2,000 2,000 ____________________________ 101 41320 31 319.06 SWWC Co-Operative Dues 0 0 0 0 0 ____________________________ 101 41320 31 331.00 Travel Expense 330 599 635 400 600 ____________________________ 101 41320 31 341.00 Employment Advertising 797 1,956 927 1,000 1,000 Vacancies 101 41320 31 391.00 P.C. Maintenance 0 0 0 3,500 3,500 Neo Gov - Annual Maintenance 101 41320 31 394.00 P.C. Software Purchases 0 0 8,500 0 0 Neo Gov - Initial Purchase 101 41320 31 433.00 Dues & Subscriptions 900 ____________________________ 101 41320 31 433.02 IPMA Dues 209 249 174 300 300 ____________________________ 101 41320 31 433.03 MPELRA Dues 275 200 275 400 600 ____________________________ 101 41320 31 435.00 Books & Pamphlets 0 0 0 100 100 Books & Training Materials 101 41320 31 437.00 Conferences & Seminars 1,100 ____________________________ 101 41320 31 437.01 MPELRA State Conference 297 485 601 500 800 ____________________________ 101 41320 31 437.02 Personnel Seminars 235 171 75 300 300 ____________________________ 101 41320 31 437.03 Safety, Supervisor, Policy 0 0 0 0 0 ____________________________ 101 41320 41 315.00 Special Programs 300 ____________________________ 101 41320 41 315.01 General Marketing 214 0 0 300 300 ____________________________ 101 41320 41 315.02 Historical Monuments 0 0 0 0 0 ____________________________ 101 41320 41 319.00 Other Professional Services 6,500 ____________________________ 101 41320 41 319.01 Website 3,572 4,751 5,983 13,000 6,500 ____________________________ 101 41320 41 319.02 Website Improvements 0 0 0 0 0 ____________________________ 101 41320 41 328.00 Cable Supply Costs 384 1,016 864 1,000 1,000 Cable Supplies, Software 101 41320 41 329.00 Other Communication Costs 0 0 0 60,100 ____________________________ 101 41320 41 329.01 Cable JPA Payment-General City 44,265 45,934 54,388 71,000 60,000 ____________________________ 101 41320 41 329.02 Video Streaming Council Mtgs 0 0 60 100 100 ____________________________ 101 41320 41 329.03 Bulk E-Mail System 0 0 0 0 0 ____________________________ 101 41320 41 331.00 Travel Expenses 32 52 55 100 100 ____________________________ 101 41320 41 433.00 Dues & Subscriptions 75 75 75 100 100 MAGC 101 41320 41 437.00 Conferences & Seminars 0 0 0 100 100 Technical Courses 101 41320 41 580.00 Other Equipment Purchases 189 371 0 500 500 ____________________________ ------------------------------------------------------------------------------------------ PAGE TOTALS $55,393 $67,829 $109,808 $115,800 $108,600 DEPARTMENT TOTALS $452,534 $487,731 $536,491 $610,100 $674,200 ================================================ Page 22 of 105 ELECTIONS The responsible execution of elections is a crucial function of local government. Federal, state and local elections assure the popular representation of citizens and that the community’s mission, vision and goals are consistent with the wishes of the electorate. GENERAL / ADMINISTRATIVE •Provides for conducting all local, state and federal elections. VOTER REGISTRATION •Provides for the maintenance and execution of procedures for voter registration. SUPPLIES & EQUIPMENT •Provides for the necessary supplies and minor equipment necessary to conduct the elections. CONTRACTED SERVICES •Provides for the maintenance agreements for service and repair of the voter assist terminals and the ballot counters. •Provides for continued use of polling locations. STAFFING •Provides for the recruitment, appointment, training and supervision of election judges to carry out Election Day activities at the City's seven precinct polling locations. •Provides for training of absentee ballot board. PERFORMANCE MEASURES Average Number of Registered Voters per Precinct 2011 2012 2013 2014 2015 2016 1,871 2,186 1,949 1,941 1,982 2,022 (8 months) n/a – Information not Available Page 23 of 105 Page One 2017 BUDGET WORKSHEETS ELECTIONS September 20, 2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 101 41410 01 103.00 Part-Time Salaries $0 $18,117 $0 $36,000 $0 Election Judges & Front Desk 101 41410 01 203.00 Printed Forms & Paper 0 568 0 200 0 Ballots & Programming 101 41410 01 208.00 Miscellaneous Supplies 0 147 0 500 0 ____________________________ 101 41410 01 219.00 Other Operating Supplies 0 306 0 300 0 Food for Election Judges 101 41410 01 242.00 Minor Equipment 0 0 0 0 0 Signs & Miscellaneous 101 41410 01 304.00 Legal Fees 0 0 0 0 0 ____________________________ 101 41410 01 319.00 Other Professional Services 0 0 0 0 0 ____________________________ 101 41410 01 321.00 Telephone Costs 0 0 0 0 0 ____________________________ 101 41410 01 351.00 Legal Notices Publishing 0 0 0 0 0 Election Publications 101 41410 01 391.00 P.C. Maintenance 0 6,200 6,355 6,200 0 Elections S/W Maintenance Costs (Utiliizing Laserfiche) 101 41410 01 409.00 Other Contracted Repair & Maint 5,000 ____________________________ 101 41410 01 409.01 Maintenance for Voting Machines 1,225 1,225 0 5,000 5,000 ____________________________ 101 41410 01 409.02 Maintenance for Accuvotes 1,000 1,000 0 0 0 ____________________________ 101 41410 01 412.00 Building Rental 0 0 0 0 0 Possible Rent for Locations 101 41410 01 439.00 Other Miscellaneous Charges 0 0 0 0 0 ____________________________ 101 41410 01 580.00 Other Equipment Purchases 8,626 0 11,200 0 15,000 ____________________________ ------------------------------------------------------------------------------------------ PAGE TOTALS $10,851 $27,562 $17,555 $48,200 $20,000 DEPARTMENT TOTALS $10,851 $27,562 $17,555 $48,200 $20,000 ================================================ Page 24 of 105 FINANCE DEPARTMENT The Finance Department is responsible to work with all departments of the City, especially the Administration Department, to ensure that all activities of the City are conducted in a fiscally responsible manner. GENERAL / ADMINISTRATIVE •Provides for the fiscal management, processing and maintenance of all accounting transactions for all funds of the City, including budgetary controls, preparation of interim accounting reports and the Comprehensive Annual Financial Report (CAFR). Also responsible for all other reporting requirements of the Federal, State, County and other government agencies in regards to budgets, taxes, financial statements, TIF Districts and other items. Beginning in 2012 also responsible for main line phone administration. DATA PROCESSING •Provides for evaluation of appropriate computer hardware and software on a continuing basis. •Coordinates efforts between departments to assure an integrated information system. •Acts as an in-house consultant providing technical assistance when possible, and if not possible, coordinating the procurement of outside technical assistance when needed. TREASURY •Fund Management - Collects and deposits revenues and manages the investment of idle funds. •Budgetary - Compiles historical and current expenditure and revenue data to facilitate budget preparation. •Bonding - Assists in the issuance, sale and record maintenance of indebtedness. •Insurance - Maintains records for property and worker's comp insurance requirements, handles all property & liability claims and prepares documents for all yearly renewals of policies. Page 25 of 105 FINANCE DEPARTMENT - Page 2 PAYROLL • Receives employee time sheets, coordinates insurance, pay rates and other applicable payroll information with personnel, prepares payroll checks, prepares all Federal and State required reports, prepares all employee withheld and employer promised obligation funds for disbursement to applicable organizations, and prepares all reports as needed, both internally and externally. UTILITY BILLING • Coordinates the automated reading of all City water meters, and the processing, mailing, uploading and collection of all utility bills. Handles on the computer system, the preparation of final bills and the setup of new accounts. Fields and responds to utility billing questions and complaints. Compiles operating statistical information which is available to other departments as needed. ACCOUNTS PAYABLE • Processes purchase orders prepared by all departments, checking for accuracy and matching with invoices and all other supporting documentation so payments can be made in a timely manner. Also, prepares all checks and supporting reports that accompany each check run. Coordinates the review of bills by Council by providing applicable reports and supporting documentation. ACCOUNTS RECEIVABLE / CASH RECEIPTS • Prepares invoices for all departments for items/services that must be billed to outside sources. Maintains records that allow for the timely collection of invoiced items/services. Receipts monies on a daily basis and deposits those monies daily in designated banking institutions. Maintains a system that allows for the appropriate reporting of all monies collected within the accounting system. Page 26 of 105 FINANCE DEPARTMENT - Page 3 FIXED ASSETS • Responsible for the maintenance of the fixed asset system. This includes all additions, deletions and changes in fixed assets for the City. It also includes the periodic physical reinventory of all current fixed assets. Also responsible for the corresponding reporting requirements that go along with the system, including year-end information, insurance renewal information and individual department information. SPECIAL ASSESSMENTS • Responsible for the maintenance of special assessments records to confirm that Dakota County’s assessment balances are correct and in agreement with ours. Works with the Engineering Department for additions to the special assessment system. Responsible for coordinating all deletions and changes to the system as well as all collections of special assessment payments not collected through property taxes. STAFFING • In 2017, the department will consist of eight positions: Finance Director Accounting Supervisor IT Coordinator Payroll Clerk Accounts Payable Clerk Utility Billing Clerks (2) Accounting Clerk Page 27 of 105 FINANCE DEPARTMENT - Page 4 PERFORMANCE MEASURES City Bond Rating 2011 2012 2013 2014 2015 2016 Aa2 Aa2 Aa2 Aa2 Aa2 Aa2 (4/16/10) GFOA Certificate of Achievement Award Received 2011 2012 2013 2014 2015 2016 Yes Yes Yes Yes (Applied) n/a # of Accounts Payable Checks Processed 2011 2012 2013 2014 2015 2016 3,263 3,138 3,139 3,101 3,148 2,219 # of Utility Bills Processed 2011 2012 2013 2014 2015 2016 29,563 30,019 29,644 30,962 31,524 18,531 2016 figures are estimates for the first 8 months of the year. n/a – Information Not Available Page 28 of 105 Page One 2017 BUDGET WORKSHEETS FINANCE September 20, 2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- All Salary Costs Inclusive of 101 41520 101.00 Salaries & Benefits $319,121 $395,125 $406,312 $420,100 $432,500 Salary, Taxes, PERA & Benefits 101 41520 102.00 Full-Time Overtime 2,707 2,826 1,629 3,000 3,000 ___________________________ 101 41520 103.00 Part-Time Salaries & Benefits 50,067 0 0 0 12,000 Intern 12-15 Hours Per Week 101 41520 01 321.00 Telephone Costs 1,429 1,322 1,322 1,500 1,500 Cell Phone Allowances (2) 101 41520 01 331.00 Travel Expense 1,300 ___________________________ 101 41520 01 331.01 Finance Director 869 449 409 1,200 1,200 National Conference Included 101 41520 01 331.02 Staff 69 0 129 100 100 ___________________________ 101 41520 01 391.00 P.C. Maintenance 67,900 ___________________________ 101 41520 01 391.02 Remote Desktop Services 962 900 900 1,000 1,500 ___________________________ 101 41520 01 391.03 Incode Software Maintenance 8,857 9,168 9,595 9,000 10,000 ___________________________ 101 41520 01 391.04 General Network Support 20,000 20,000 20,000 25,000 25,000 Block Hours of Support Time 101 41520 01 391.06 Fixed Asset Maint Contract 1,384 1,365 1,365 1,400 1,400 ^^ Increased Cost and Need ^^ 101 41520 01 391.07 Miscellaneous Repairs & Maint.1,590 2,794 711 2,500 2,000 ___________________________ 101 41520 01 391.08 Anti-Virus Software Renewal 4,696 1,188 1,188 2,000 2,000 ___________________________ 101 41520 01 391.09 File Server Software Maintenance 12,931 8,707 5,764 14,800 7,000 ___________________________ 101 41520 01 391.10 Managed Backup Services 0 11,010 11,060 14,500 19,000 Outgrowing Current Capacity 101 41520 01 392.00 P.C. Accessories & Supplies 2,462 2,075 1,766 3,000 3,000 City System Supplies 101 41520 01 393.00 P.C. Hardware Purchases 1,243 675 2,192 2,000 2,000 ___________________________ 101 41520 01 394.00 P.C. Software Purchases 2,000 ___________________________ 101 41520 01 394.01 Annual Microsoft Office Payment 0 0 0 0 0 2015 End of Life for Office 2010 101 41520 01 394.02 Miscellaneous S/W Purchases 3,515 352 1,754 2,000 2,000 ___________________________ 101 41520 01 409.00 Other Contracted R & M 210 225 225 300 300 Non-Computer Equipment 101 41520 01 433.00 Dues & Subscriptions 800 ___________________________ 101 41520 01 433.02 MnGFOA - Finance Director 60 60 60 70 70 ___________________________ 101 41520 01 433.03 MnGFOA - Staff 360 360 360 380 380 ___________________________ 101 41520 01 433.04 GFOA - Finance Director & Asst.340 340 340 350 350 ___________________________ 101 41520 01 435.00 Books & Pamphlets 100 ___________________________ 101 41520 01 435.01 Accounting Related Books 178 0 0 50 50 ___________________________ 101 41520 01 435.02 Finance Related Books 0 0 0 50 50 ___________________________ 101 41520 01 437.00 Conferences & Seminars 2,800 ___________________________ 101 41520 01 437.02 MnGFOA Annual Conf (F/D)571 571 573 700 700 ___________________________ 101 41520 01 437.03 GFOA National Conf (F/D)1,708 432 543 1,500 1,500 ___________________________ 101 41520 01 437.04 Staff Development 0 15 0 200 200 101 41520 01 437.05 Miscellaneous Seminars 278 360 387 400 400 Misc. Meetings, Lunches, etc. 101 41520 01 439.00 Other Miscellaneous Charges 39 284 85 200 200 Contingencies 101 41520 01 570.00 Office Equipment & Furnishings 1,000 316 971 500 500 ___________________________ ------------------------------------------------------------------------------------------ PAGE TOTALS $436,646 $460,919 $469,640 $507,800 $529,900 DEPARTMENT TOTALS $436,646 $460,919 $469,640 $507,800 $529,900 ================================================ Page 29 of 105 GENERAL GOVERNMENT DUPLICATING & COPYING •Provides for maintenance agreements and expenses to operate copy machines at all City facilities. Also provides for digital document management costs. PRINTED FORMS & PAPER •Provides for copy paper utilized by all departments and provides for forms utilized by the Finance Department. ENVELOPES & LETTERHEADS •Provides for letterhead utilized by all departments and for various types and sizes of envelopes. OTHER OFFICE SUPPLIES •Provides for general office supplies utilized by all City departments. EQUIPMENT PARTS •Provides for the maintenance and repair of general office equipment. AUDITING & ACCOUNTING SERVICES •Provides for the annual audit of the City's accounting transactions for all funds of the City and for the preparation of the Comprehensive Annual Financial Report. Also provides for other services as required of the City's financial and accounting consultants. LEGAL FEES •Provides for general legal and special legal services provided by the City Attorney or other law firms utilized by the City for such services. Page 30 of 105 GENERAL GOVERNMENT - Page 2 OTHER PROFESSIONAL SERVICES • Provides for the administration costs of the City's code updates, code web fees, annual updates to the user fee study, preparation of the State building report and continuing disclosure fees. TELEPHONE COSTS • Provides for the costs of the City's telephone system, monthly service fees, long distance calls and miscellaneous installation costs. Also, provides for fees associated with the City’s e-mail and web services. POSTAGE COSTS • Provides for postage costs for all departments and maintenance agreements for the postage machine and postage allocator. OTHER TRANSPORTATION EXPENSES • Provides for two-year renewals of City vehicle license plates, emission fees and duplicate plates, titles or tags, if needed. LEGAL & GENERAL NOTICES PUBLISHING • Provides for the publication of legal documents from all departments except when publication costs are charged to specific projects. LEASE AGREEMENTS • Provides for leasing of copy machines and other office machines at City Hall, Community Center and the Police Department. Page 31 of 105 Page One 2017 BUDGET WORKSHEETS GENERAL GOVERNMENT September 20, 2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 101 41810 01 202.00 Duplicating & Copying $15,000 ___________________________ 101 41810 01 202.02 Copying Costs 14,668 16,182 16,522 15,000 15,000 ___________________________ 101 41810 01 203.00 Printed Forms & Paper 7,600 ___________________________ 101 41810 01 203.01 Copy Paper 3,757 3,773 5,026 4,000 4,000 ___________________________ 101 41810 01 203.02 General Receipt Books 0 0 776 800 800 ___________________________ 101 41810 01 203.03 Purchase Orders 1,376 1,336 0 1,400 1,400 ___________________________ 101 41810 01 203.04 Payroll & A/P Checks 327 324 435 400 400 ___________________________ 101 41810 01 203.06 Miscellaneous Forms 856 2,257 123 1,000 1,000 Business Cards, etc. 101 41810 01 204.00 Envelopes & Letterheads 1,800 ___________________________ 101 41810 01 204.01 Letterhead 245 1,523 1,195 700 700 ___________________________ 101 41810 01 204.02 Plain Envelopes 1,192 322 902 600 600 ___________________________ 101 41810 01 204.03 A/P & Payroll Envelopes 0 946 0 500 500 ___________________________ 101 41810 01 204.04 10 x 13 Envelopes 0 0 0 0 0 ___________________________ 101 41810 01 209.00 Other Office Supplies 13,021 14,456 14,386 14,500 14,500 General Office Supplies 101 41810 01 221.00 Equipment Parts 0 0 0 0 0 City Hall Equipment Repairs 101 41810 01 242.00 Minor Equipment 500 ___________________________ 101 41810 01 242.02 Credit Card Equipment 0 0 748 500 500 $500-$700 for One Terminal 101 41810 01 301.00 Auditing & Accounting Services 68,100 ___________________________ 101 41810 01 301.01 Audit & General Consulting Fees 57,547 59,181 65,173 62,000 60,000 ___________________________ 101 41810 01 301.02 Dakota County Assessment Fees 5,955 6,344 6,482 7,000 6,500 ___________________________ 101 41810 01 301.03 Dak Cty Truth In Taxation Costs 1,503 1,523 1,525 1,600 1,600 ___________________________ 101 41810 01 303.00 Engineering Fees 0 0 0 0 0 ___________________________ 101 41810 01 304.00 Legal Fees 56,703 63,485 87,108 64,000 66,000 General City Legal Fees 101 41810 01 319.00 Other Professional Services 25,200 ___________________________ 101 41810 01 319.01 City Code Update 1,140 160 2,974 2,700 2,700 ___________________________ 101 41810 01 319.02 City Code Web Fees 500 500 500 500 500 ___________________________ 101 41810 01 319.03 State Building Report (Springsteds)4,935 4,548 4,310 5,000 5,000 Fees Paid to Springsted 101 41810 01 319.04 Continuing Disclosure Fees 2,000 2,400 2,600 4,000 3,000 Fees Paid to Springsted (Bonds) 101 41810 01 319.05 Annual User Fee Study Update 3,695 3,928 3,996 4,000 4,000 Fees Paid to Springsted 101 41810 01 319.06 Arbitrage/Rebate Calculations 5,750 0 5,850 10,000 10,000 Fees Paid to Springsted (Bonds) 101 41810 01 319.10 UMore Professional Services 36,961 20,020 2,603 0 0 In-House Engineer or Bill Out 101 41810 01 320.00 Credit Card Activity Fees 22,000 ___________________________ 101 41810 01 320.01 Utilities' Fees 453 0 0 0 0 O/L Added - Moved to Utilities 101 41810 01 320.02 Parks & Recreation Fees 5,082 5,031 4,746 5,200 5,500 ___________________________ 101 41810 01 320.03 Building Fees 10,950 11,492 19,326 12,000 15,000 ___________________________ 101 41810 01 320.04 General Fees 1,091 819 1,372 1,000 1,500 ___________________________ 101 41810 01 320.05 Parks & Recreation On-Line Fees 0 0 99 0 0 ___________________________ 101 41810 01 321.00 Telephone Costs 39,100 ___________________________ 101 41810 01 321.01 General Phone Costs (& Internet)36,021 25,574 27,504 28,000 28,000 Added Fiber to Buildings in 2013 101 41810 01 321.02 Domain Housing 60 60 60 100 100 ___________________________ 101 41810 01 321.03 Software Maintenance Costs 7,299 7,970 7,970 8,700 9,000 Added Additional Licenses 101 41810 01 321.04 Phone System Hardware 0 533 289 2,000 2,000 Phone Upgrades, Headsets, etc. 101 41810 01 322.00 Postage Costs 13,555 15,601 13,340 15,000 15,000 ___________________________ 101 41810 01 339.00 Other Transportation Expenses 44 906 166 800 1,000 Vehicle Licensing 101 41810 01 351.00 Legal Notices Publishing 3,500 ___________________________ 101 41810 01 351.01 Costs for Public Notices 2,716 4,468 2,997 3,000 3,000 All Departments 101 41810 01 351.03 Budget & Audit Publications 227 452 996 500 500 State Mandated Publications 101 41810 01 391.00 P.C. Maintenance 16,198 18,245 14,344 18,000 18,000 Laserfishe Maintenance 101 41810 01 392.00 P.C. Software Purchases 4,900 12,669 1,593 7,000 7,000 Laserfishe Software 101 41810 01 393.00 P.C. Hardware Purchases 3,825 2,140 1,100 4,000 4,000 Scanner Purchase 101 41810 01 433.00 Dues & Subscriptions 1,322 1,050 964 1,000 1,000 Newspapers 101 41810 01 439.00 Other Miscellaneous Charges 240 240 240 300 300 Direct Deposit Filing Fees/Flex 101 41810 01 450.00 Sales Tax on Purchases 0 0 0 0 0 Sales Tax Audit 101 41810 01 580.00 Other Equipment Purchases 36,132 32,209 30,930 20,000 14,000 Office Machines-All Buildings ------------------------------------------------------------------------------------------ PAGE TOTALS $352,247 $342,664 $351,268 $326,800 $323,600 DEPARTMENT TOTALS $352,247 $342,664 $351,268 $326,800 $323,600 ================================================ Page 32 of 105 COMMUNITY DEVELOPMENT OVERVIEW: MISSION, VISION AND GOALS The Community Development Department plays an important role as the City moves toward its mission of providing a safe, healthy and pleasant community in a fiscally responsible manner. The Building Inspection and Planning Divisions play a key role in making Rosemount a safe and pleasant community. These divisions are also involved in reaching the City Council’s goals in affordable housing and property maintenance. The Economic Development Division addresses the City’s vision statement by fostering opportunities to live, work and shop. The division helps the City enhance its hometown character and pride, for example, through downtown redevelopment. The division, along with the Rosemount Port Authority, plays a vital role in meeting goals of the City Council such as commercial enhancement and business growth. BUILDING INSPECTIONS •Is responsible for providing the services of building permit review, building inspection, code administration, consultation and review on new and existing buildings and structures within the City. •Is responsible for the maintenance and enforcement of city ordinances and codes relating to building, health, life safety, fire and environmental conditions and to assure local compliance with county, state and federal regulations relating to the same activities. •Is responsible for the successful implementation of all structural development and assuring regulated and controlled standards within Rosemount. •Is responsible for monitoring and permitting all individual sewage treatment systems within the City. •Is responsible for reports submitted to all appropriate jurisdictions concerning building activities. •Serves as Fire Marshal for the City activities. Page 33 of 105 COMMUNITY DEVELOPMENT – Page 2 CODE ENFORCEMENT • Is responsible for enforcement of city ordinances and codes relating to health, life safety, environmental, and nuisance conditions and assure local compliance with county, state and federal regulations relating to the same activities. • Is responsible for sign ordinance implementation and permitting. • Is responsible for drafting of code text amendments to carry out Council goals and City initiatives. • Is responsible for rental housing inspection and permitting. • Is responsible for sequential code enforcement program, which is a city initiated program for resident education and neighborhood code compliance. PLANNING • Is responsible for reviewing proposed developments for compliance with the zoning and subdivision ordinance and coordinating interdepartmental staff review of all residential, commercial, institutional and industrial developments. • Is responsible for providing recommendations to Planning Commission and City Council on all deliberations concerning land use, zoning, variances, site plan reviews, platting and special permits (interim use permits, mining permits, etc.). • Is responsible for maintaining zoning and subdivision ordinances and the City’s Comprehensive plan in compliance with county, state and federal requirements (statutes and rules). • Is responsible for long-range planning and special studies that guide the physical development of the community. • Is involved with state and regional activities affecting the City, including, but not limited to, land use, transportation, mining, housing and environmental services. Includes active participation by departmental staff in various committees and organizations. • Is involved with issuance of development related permits such as grading and building permits. Page 34 of 105 COMMUNITY DEVELOPMENT – Page 3 ECONOMIC DEVELOPMENT • Is responsible for marketing development opportunities within the City and creating an interest in Rosemount. • Is responsible for creating and coordinating the establishment of tax increment districts and other economic incentives. • Is responsible for creation and expansion of a local Business Retention program. • Is responsible for coordinating the state, county and local approval processes to insure the proponent's requests are met in a timely fashion. • Is responsible for staffing the majority of functions of the Rosemount Port Authority. • Is involved with state and regional economic development organizations and functions. Page 35 of 105 COMMUNITY DEVELOPMENT – Page 4 PERFORMANCE MEASURES Planning Application Processed Within 60 Days 2011 2012 2013 2014 2015 2016 83% 65% 45% 100% 97% 91% Requested Inspections Completed Within One Day 2011 2012 2013 2014 2015 2016 100% 100% 100% 100% 100% 100% Residential Plan Reviews Fully Completed Within 10 Working Days 2011 2012 2013 2014 2015 2016 86% 78% 96% 80% 92% 98% Code Complaints Resolved 2011 2012 2013 2014 2015 2016 99% 100% 98% 99% 99% 86% Existing Businesses Visited 2011 2012 2013 2014 2015 2016 24 16 74 43 60 38 All 2016 figures are estimates for the first 8 months of the year. Page 36 of 105 Page One 2017 BUDGET WORKSHEETS COMMUNITY DEVELOPMENT September 20, 2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- All Salary Costs Inclusive of 101 41910 101.00 Salaries & Benefits $865,686 $870,717 $906,340 $948,400 $983,900 Salary, Taxes, PERA & Benefits 101 41910 102.00 Full-Time Overtime 1,339 20 1,044 1,000 1,000 ___________________________ 101 41910 99 103.00 Part-Time Salaries & Benefits 2,702 2,072 2,035 27,500 27,500 ___________________________ 101 41910 99 103.01 Planning Commission Members 4,500 ___________________________ 101 41910 99 103.02 Part-Time Intern 6,000 ___________________________ 101 41910 99 103.03 Part-Time Code Enforcement 17,000 ___________________________ 101 41910 01 201.00 Office Accessories 14 0 0 0 0 Calendars, Planners, etc. 101 41910 01 202.00 Duplicating & Copying 1,346 2,071 3,615 2,500 14,000 Includes Comp Plan Printing 101 41910 01 203.00 Printed Forms & Paper 270 445 1,245 1,000 1,000 Forms, Stickers, Tags, etc. 101 41910 01 205.00 Drafting Supplies 0 0 0 0 0 ___________________________ 101 41910 01 208.00 Miscellaneous Supplies 144 27 0 0 0 ___________________________ 101 41910 01 209.00 Other Office Supplies 938 444 223 600 600 Dictation Devices & Tapes 101 41910 01 219.00 Other Operating Supplies 1,166 3,255 2,470 1,500 2,000 ___________________________ 101 41910 01 241.00 Small Tools 184 190 207 200 200 Inspectors' Tools 101 41910 01 302.00 Architects' Fees 0 0 0 0 0 ___________________________ 101 41910 01 319.00 Other Professional Services 0 554 1,816 1,000 2,000 Consultant 101 41910 01 329.00 Other Communication Costs 1,890 2,149 2,760 2,500 2,800 Cell Phones & Pagers 101 41910 01 331.00 Travel Expense 314 552 947 600 700 ___________________________ 101 41910 01 391.00 P.C. Maintenance 3,031 2,990 2,990 4,200 4,200 Permitworks Support 101 41910 01 392.00 P.C. Accessories & Supplies 0 0 40 300 300 ___________________________ 101 41910 01 393.00 P.C. Hardware Purchases 0 0 0 0 0 ___________________________ 101 41910 01 409.00 Other Contracted Repair & Maint.0 3,014 1,955 2,000 2,000 Mow Weeds-From Street Maint. 101 41910 01 433.00 Dues & Subscriptions 3,400 ___________________________ 101 41910 01 433.01 APA/AICP 1,440 1,150 1,040 1,700 1,700 ___________________________ 101 41910 01 433.02 ICC 290 125 290 300 300 ___________________________ 101 41910 01 433.03 AMBO 310 475 200 500 500 ___________________________ 101 41910 01 433.04 10,000 Lakes 115 115 125 150 150 ___________________________ 101 41910 01 433.06 Trade Magazines 0 0 0 0 0 ___________________________ 101 41910 01 433.07 Planner's Journal 0 430 430 0 0 ___________________________ 101 41910 01 433.08 Sensible Land Use Coalition 0 50 76 100 100 ___________________________ 101 41910 01 433.09 AACEO/MAHCO 9 55 55 100 100 ___________________________ 101 41910 01 433.10 Other Dues & Subscriptions 433 187 213 550 550 ___________________________ 101 41910 01 435.00 Books & Pamphlets 294 582 36 700 800 Manuals, References, IBC Books 101 41910 01 437.00 Conferences & Seminars 7,800 ___________________________ 101 41910 01 437.01 State Bldg Official School 423 557 606 500 500 ___________________________ 101 41910 01 437.02 Spring & Fall Code Updates 210 220 440 400 400 ___________________________ 101 41910 01 437.03 Building Inspector Training 961 962 1,038 1,000 1,000 ___________________________ 101 41910 01 437.04 Computer Training 0 0 0 200 200 ___________________________ 101 41910 01 437.05 Clerical Seminars 38 180 149 300 300 ___________________________ 101 41910 01 437.06 Planning Seminars 1,102 38 2,830 1,800 1,800 ___________________________ 101 41910 01 437.07 ISTS Training 390 175 391 500 500 ___________________________ 101 41910 01 437.08 State Planning Conference (2)2,092 786 624 2,000 2,000 ___________________________ 101 41910 01 437.09 Planning Commissioner Training 135 80 315 500 500 ___________________________ 101 41910 01 437.10 Gen'l Seminars 0 304 292 300 300 ___________________________ 101 41910 01 437.11 Code Enforcement Training 0 25 296 300 300 ___________________________ 101 41910 01 439.00 Other Miscellaneous Charges 165 0 630 400 400 Contingencies 101 41910 01 586.00 Computer Equipment Purchases 0 0 0 0 3,000 Tablets for Employees ---------------------------------------------------------------------------------------------- PAGE TOTALS $887,430 $894,997 $937,761 $1,005,600 $1,057,600 DEPARTMENT TOTALS $887,430 $894,997 $937,761 $1,005,600 $1,057,600 ================================================== Page 37 of 105 POLICE DEPARTMENT The Police Department is responsible for policing services to the community to ensure safety and response to services calls. A Community Oriented Policing philosophy is core to all services through partnerships and relationships with citizens, businesses and community organizations. Staffing levels are continually evaluated to meet the needs of a growing community. The specific service functions within the Police Department are described below. POLICE ADMINISTRATION This budget provides for the overall leadership, planning, coordination and management of personnel and administration of activities within the Police Department. This includes the collection, preparation and filing of crime data and miscellaneous reports with the State of Minnesota; preparation and oversight of the operating and capital improvements budgets; and strategic planning for the future needs of the Department and the community. Police Department leadership is also involved in many consolidated services governance boards that contribute to policing services for the city. The Dakota Communications Center (DCC), Criminal Justice Integrated Information Network (CJIIN) Dakota County Drug Task Forces and Dakota County Multi-Agency Assistance Group (MAAG) are consolidated services organizations that contribute to Rosemount’s policing services. RECORDS UNIT The Police Department’s Records Unit is responsible for the processing of over 2,200 case reports each year. Reports require transcription and compilation for transmittal to the city or county prosecutor’s office or any other agency (e.g., social services, county crises, corrections) requiring information for service to the community. Records staff ensure the Police Department is compliant with all Minnesota Bureau of Criminal Apprehension data management laws, regulations and reporting requirements. Administrative support is provided to the entire Police Department for gun permit applications, criminal background checks, and city licensing requirements. PATROL OPERATIONS Uniformed patrol is the core function of the Police Department and the most visible in the community. Through 24 hour daily patrols in marked police vehicles, patrol officers respond to calls for service, investigate traffic accidents, conduct preliminary criminal investigations, enforce traffic laws and enforce criminal laws. Patrol Officers respond to medical calls as trained first responders. Through patrol operations the Police Department meets its goal of the protection of life and property and creating a sense of safety and security in the community. Patrol Officers spend a significant amount of time developing relationships within the community and contacting members of community organizations. Patrol Officers perform additional specialty assignments as Crime Scene Technicians, Use-of-Force Instructors, Multi-Agency Assistance Group (MAAG) Tactical Officers, Drug Recognition Expert, and Field Training Officer. Page 38 of 105 POLICE DEPARTMENT – Page 2 CRIMINAL INVESTIGATION Patrol officers and investigators are responsible for the investigation of criminal incidents through evidence gathering and analysis, witness and suspect interviews, and court preparation and testimony. Complex investigations or those requiring a multi-jurisdictional or agency involvement are coordinated by the investigator. This is accomplished by working cooperatively with other police agencies, the County Attorney’s Office, Child Protection, victim services and other local, state and federal law enforcement agencies. One investigator is assigned to the Dakota County Drug Task Force, a multi-jurisdictional joint powers entity, whose mission is to investigate drug crimes in the City of Rosemount and throughout Dakota County. CRIME PREVENTION AND COMMUNITY EDUCATION PROGRAMS A significant effort is made by the police department to inform residents of crime within the community, methods that citizens can take to help prevent crimes and building relationships with community members. While these objectives are part of each officer’s daily responsibilities, there are specific programs that are frequently associated with community policing and that emphasize the need for the police and citizens to work together to prevent criminal activity and reduce the opportunities for criminals to commit crimes. • School Liaison - Officers serve as a liaison to the Rosemount Middle and High Schools. One officer is assigned full-time to the High School and a second officer spends one- quarter time at the Middle School. The liaison officers investigate criminal incidents that occur at the schools or that involve students at the schools. In addition, the liaisons work with the school staff to enhance the safety and security for both staff and students, specifically providing school safety planning, and armed intruder prevention and response planning. Presentations on a variety of topics are made by the liaison to classes at all grade levels. The Middle School officer also spends time at each of the elementary schools, working with staff on any issues and making presentations in classes. • Community Education - In order to work together with the community, police must share information concerning criminal activity and crime prevention with the community. Officers are available to make presentations to community groups and organizations on a variety of topics. In addition, officers provide prevention tips to persons on a daily basis who report criminal activity. Several events are also held throughout the year in an effort to build relationships with the residents and business persons. These include Night-to-Unite block parties and gatherings, Neighborhood Watch meetings and Public Safety in the Park events. Page 39 of 105 POLICE DEPARTMENT – Page 3 • Reserve Officer Program – Reserve officers are volunteers who supplement the staff of sworn officers of the Department. The reserve officers are utilized to handle traffic and crowd control duties during city festivals and celebrations or emergencies, such as hazardous materials spills or leaks, damage resulting from tornadoes or other severe weather and major criminal incidents. Reserve officers patrol on some evenings and handle service calls; for example, assisting stalled motorists and animal complaints. They are also utilized regularly to provide crime prevention information to citizens at community events or through other programs. • Chaplain Program – The Police Chaplains assist in a variety of situations in which individuals or families are having difficulties. Chaplains are able to provide support to persons that are experiencing stress as a result of the death of a loved one, marital or family problems, financial struggles or any other event. By utilizing the chaplains to console and counsel persons in crisis, police officers are able to focus on their primary duties, while the chaplains are able to remain with the persons involved in the crisis. • Explorer Program – Exploring is a community based, co-educational program supervised by the local police department. The Explorer program is designed for young adults ages 14 – 21 that want to learn more about law enforcement. The program is part of the Boy Scouts of America and is open to both young men and young women. Membership in the Rosemount Police Department Explorer Post is restricted to those young people that live in Rosemount or attend school in Rosemount. Residents of other communities that do not attend school in Rosemount are turned away. The Rosemount Police Explorer Post was formed in 2014. Explorers meet twice a month under the direction of the two officers that serve as Post advisors. During these meetings they conduct post business and train in law enforcement skills. The Explorers also take part in the statewide Explorer Conference where they compete against other Explorer Posts in law enforcement scenarios including crime scene processing, domestic disturbance calls, building searches, etc. In the past, the Explorers attended the national conference every other year. Five years ago, due to budget constraints, we ended this. Although the Explorers paid their own way to the conference there was a cost associated with sending the two officers that serve as post advisors. The Explorer Post is an opportunity for youth of our community to become exposed to law enforcement. Some just want to learn more about the police department. Others are truly “exploring” law enforcement as a potential future career. In either case it brings teenagers closer to the police department in a service capacity. As such it fits with the department’s mission of improving quality of life in our community. Page 40 of 105 POLICE DEPARTMENT – Page 4 • Adult Citizen Academy Program –The Adult Citizen Academy has been a project of the Rosemount Police Department for the past 6 years. It is a way to offer those who live or work in Rosemount an inside look at the operation of their police department. It also allows them an opportunity to meet the officers who serve them. The academy covers topics such as recruiting, ethics, criminal investigations, the charging process, drug task force, use of force, traffic enforcement, forensics, and includes a citizen ride-along with a patrol officer. As such it helps fulfill the department’s educational mission. ANIMAL CONTROL The Police Department is responsible for the enforcement of ordinances related to the control and care of domestic animals. These tasks are mainly handled by Community Service Officers. Their duties include the licensing of dogs and ferrets, assisting in the handling of stray, lost or injured animals and other complaints of animals causing a nuisance by barking, howling or being allowed to roam off the owner’s property. CODE ENFORCEMENT The Police Department assists the Community Development Department with code enforcement of city ordinances related to property maintenance and outside storage. The Department’s Community Service Officers primarily handle this effort. Property owners that are observed to be in violation of an ordinance are notified of the violation and given an explanation of how to remedy the violation. The enforcement of city ordinances is important to maintain community standards, which help the City attain its mission of providing a safe, healthy and pleasant community. EMERGENCY MANAGEMENT The City has an all-hazards emergency plan and the Chief of Police serves as the City’s emergency manager. The emergency manager is responsible for the development of emergency plans in the event of a chemical, technical or natural disaster in the community (e.g. tornado, flooding, school shooting, or hazardous materials release). The Chief of Police represents the City of Rosemount on the Dakota County Domestic Preparedness Committee (DCDPC). The DCDPC is comprised of police, fire, dispatch, EMS, public health, and medical facility representatives to aid all Dakota County cities and Dakota County with all-hazards emergency planning and leadership. Page 41 of 105 POLICE DEPARTMENT – Page 5 PERFORMANCE MEASURES Number of Licensed Officers per 1,000 Residents 2010 2011 2012 2013 2014 2015 .99 .99 .99 .99 1.01 1.01 Number of Non-licensed Employees per 1,000 Residents 2010 2011 2012 2013 2014 2015 .20 .20 .20 .22 .22 .22 Number of Car Crashes with Personal Injury Resulting 2010 2011 2012 2013 2014 2015 30 23 46 48 57 52 Part I Crimes 2010 2011 2012 2013 2014 2015 Total # Reported 334 336 270 253 217 317 Rate per 1,000 15.13 14.69 11.80 11.35 9.60 14.08 Part II Crimes 2010 2011 2012 2013 2014 2015 Total # Reported 686 719 659 570 580 867 Rate per 1,000 31.09 31.43 28.81 25.66 27.56 38.53 Case Clearance Rate of Reported Crimes (Percent Solved) 2010 2011 2012 2013 2014 2015 52% 54% 57% 55% 56% 47% DWI Arrests 2010 2011 2012 2013 2014 2015 Number of Arrests 101 106 119 96 62 74 Rate per 1,000 4.48 4.71 5.28 4.26 2.75 3.28 Page 42 of 105 POLICE DEPARTMENT – Page 6 Night to Unite (National Night Out) Neighborhood Parties 2010 2011 2012 2013 2014 2015 Number of Events 25 33 34 28 28 66 Response Time to Priority 1 Calls for Service (**) 2010 2011 2012 2013 2014 2015 6.24 6.75 6.24 5.25 4.95 6.55 Page 43 of 105 Page One 2017 BUDGET WORKSHEETS POLICE September 20, 2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- All Salary Costs Inclusive of 101 42110 101.00 Salaries & Benefits $2,514,144 $2,630,087 $2,840,182 $2,879,000 $2,958,800 Salary, Taxes, PERA & Benefits 101 42110 101.00 Salaries & Benefits 0 0 0 0 125,400 New Sergeant (Cops Grant-Part'l) 101 42110 102.00 Full-Time Overtime 94,077 89,832 94,032 93,500 93,500 _______________________________ 101 42110 102.01 Regular Overtime Hours 77,500 COLA & Explorer Post Time 101 42110 102.02 Contracted O/T 16,000 _______________________________ 101 42110 103.00 Part-Time Salaries & Benefits 44,700 _______________________________ 101 42110 23 103.00 Part-Time Secretary 12,686 10,227 123 0 0 Position Eliminated in 2015 101 42110 99 103.00 Part-Time CSO's 32,980 36,277 37,593 43,700 44,700 CSO's - Up To 50 Hours/Wk 101 42110 01 202.00 Duplicating & Copying 0 0 0 0 0 _______________________________ 101 42110 01 203.00 Printed Forms & Paper 1,745 1,784 1,693 1,600 1,700 _______________________________ 101 42110 01 204.00 Envelopes & Letterheads 8 213 0 300 300 Business Cards 101 42110 01 207.00 Training & Instructional Supplies 12,600 _______________________________ 101 42110 01 207.01 Practice Ammunition 3,003 5,067 5,277 5,500 5,500 Increase Due to Increase in Costs 101 42110 01 207.02 Service Ammunition 815 1,014 1,000 1,300 1,300 Increase Due to Increase in Costs 101 42110 01 207.03 Other Supplies 787 25 134 200 300 _______________________________ 101 42110 01 207.04 M.A.A.G. Ammunition 4,951 5,190 5,220 5,500 5,500 Increase Due to Increase in Costs 101 42110 01 208.00 Miscellaneous Supplies 0 Donated & Forfeited Funds 101 42110 01 208.01 DARE Donations 285 302 212 0 0 _______________________________ 101 42110 01 208.02 Equipment Donations/Forfeitures 6,465 3,837 2,901 0 0 _______________________________ 101 42110 01 208.03 Other Grants Expenditures 0 0 2,807 0 0 _______________________________ 101 42110 01 209.00 Other Office Supplies 1,518 1,080 908 1,100 1,100 Videos & CD's (Increase in Costs) 101 42110 01 211.00 Cleaning Supplies 1,500 _______________________________ 101 42110 01 211.01 Blanket Cleaning 0 0 0 0 0 _______________________________ 101 42110 01 211.02 Squad Cleaning 235 557 502 1,500 1,500 _______________________________ 101 42110 01 217.00 Clothing Allowance 4,700 _______________________________ 101 42110 01 217.01 CSO's 420 319 2,375 800 1,000 _______________________________ 101 42110 01 217.02 Reserves 1,796 997 2,168 1,000 1,500 _______________________________ 101 42110 01 217.03 Other Supplies 4,256 2,682 1,826 1,600 2,200 Increase to Cover Chief Uniforms 101 42110 01 219.00 Other Operating Supplies 4,200 _______________________________ 101 42110 01 219.01 Evidence Bags, Drug Kits, Misc.420 1,635 2,033 2,000 2,000 _______________________________ 101 42110 01 219.02 Accurint Database Services 600 717 713 1,700 2,200 Free Service no Longer Available 101 42110 01 221.00 Equipment Parts 3,025 2,598 2,841 4,000 4,000 Squad Emerg Equip (Medic Bags) 101 42110 01 241.00 Small Tools 4,100 Crime Scene Kit Supplies 101 42110 01 241.01 Evidence Processing Equipment 572 213 765 800 800 _______________________________ 101 42110 01 241.02 Camera and Video Supplies 1,141 1,644 1,850 2,000 2,000 Squad Camera Maintenance 101 42110 01 241.03 Digital Recorder Warranty 728 1,198 1,285 1,300 1,300 3% Cost Increase Estimate 101 42110 01 242.00 Minor Equipment 2,200 _______________________________ 101 42110 01 242.01 Less Lethal Tactical Equipment 754 966 1,615 1,000 1,200 Training Supplies, Taser Batteries 101 42110 01 242.02 MAAG Equipment 0 362 413 500 1,000 _______________________________ 101 42110 01 304.00 Legal Fees 59,570 59,532 68,420 65,400 67,000 Prosecution - 2.5% Increase 101 42110 01 305.00 Medical & Dental Fees 2,000 _______________________________ 101 42110 01 305.01 Physicals 1,044 667 1,418 800 1,200 _______________________________ 101 42110 01 305.02 Seized Narcotic Testing 773 170 794 800 800 Blood Draws 101 42110 01 306.00 Personnel Testing & Recruitment 1,551 795 4,319 1,000 1,500 Psychological 101 42110 01 313.00 Temporary Service Fees 787 70 626 800 800 Interpreter Services 101 42110 01 315.00 Special Programs 0 0 0 0 0 _______________________________ 101 42110 01 316.00 Animal Care Services 1,700 _______________________________ 101 42110 01 316.01 Impound & Care Fees 3,000 1,600 1,252 2,800 1,700 _______________________________ 101 42110 01 316.02 "Future Use"0 0 0 0 0 _______________________________ 101 42110 01 319.00 Other Professional Services 434,700 _______________________________ 101 42110 01 319.01 Dispatch Services - Operations 338,376 354,649 368,448 388,200 417,900 $403,800-Ops & $19,400-Capital 101 42110 01 319.02 Policy Development & Training 0 999 842 800 800 (Includes RFD^^^) 101 42110 01 319.03 Mediation Services 0 792 219 1,000 1,000 _______________________________ 101 42110 01 319.04 Electronic Crimes Unit Fees 0 0 15,000 15,000 15,000 Coordinated by Dakota County 101 42110 01 319.05 Emergency Mgmt Plan Update 0 5,148 0 0 0 _______________________________ 101 42110 01 321.00 Telephone Costs 14,000 _______________________________ 101 42110 01 321.01 Cell Phones 4,865 3,696 4,599 10,300 14,000 Switching to Smart Phones 101 42110 01 323.00 Radio Units 14,000 _______________________________ 101 42110 01 323.01 Radios 8,437 10,638 9,052 12,900 11,500 800 MHz Subscriber Fees 101 42110 01 323.02 Radars 0 767 370 500 500 Radar & LIDAR Repairs 101 42110 01 323.03 Radio Warranty 1,703 1,703 1,703 2,000 2,000 _______________________________ 101 42110 01 331.00 Travel Expense 6,000 _______________________________ 101 42110 01 331.01 MN Chief's Spring Conference 395 435 0 500 500 _______________________________ 101 42110 01 331.02 IACP or FBINAA Conference 0 1,813 1,956 2,000 2,200 _______________________________ 101 42110 01 331.03 Outstate Investigations & Conf.43 552 1,032 750 750 _______________________________ 101 42110 01 331.04 MAAG Conference 660 623 619 750 850 Increase in Conference Costs 101 42110 01 331.05 CAN-AM Narcotic Conference 394 420 261 500 500 _______________________________ 101 42110 01 331.06 Juvenile Officers Conference 244 513 521 600 600 Increase in Conference Costs 101 42110 01 331.07 Meeting Reimbursements 134 101 139 500 600 _______________________________ ------------------------------------------------------------------------------------------------------ PAGE TOTALS 3,109,386 3,244,506 3,492,057 3,557,800 3,800,500 Page 44 of 105 Page Two 2017 BUDGET WORKSHEETS POLICE September 20, 2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 101 42110 01 333.00 Freight & Express Expenses 46 97 9 200 200 Repairs 101 42110 01 394.00 P.C. Software Purchases 60,500 _______________________________ 101 42110 01 394.01 Automated Pawn System 204 204 204 300 300 _______________________________ 101 42110 01 394.02 Pictometry 0 0 0 0 0 In Public Works Budget 101 42110 01 394.03 CJIIN/Pro Phoenix System 7,385 36,120 41,759 32,200 0 No longer member of CJIIN/ProPhoen 101 42110 01 394.04 LOGIS TriTech RMS 0 0 0 24,500 60,200 TriTech RMS and Report Writing 101 42110 01 396.00 Computer Maintenance 35,700 _______________________________ 101 42110 01 396.01 LOGIS Apps Support 36,264 2,952 3,060 0 0 LOGIS APS-Moved to LOGIS RMS 101 42110 01 396.02 CJDN Connection Charges 2,981 3,724 4,365 2,800 2,800 State of MN CJDN Connection 101 42110 01 396.03 MCD Connection Charges 1,384 630 236 2,100 2,100 LOGIS MDC Connection Charges 101 42110 01 396.04 MCD Maintenance & Cellular 20,084 21,523 24,058 27,500 28,000 Increase Due to CAD Change 101 42110 01 396.05 LOGIS Fees/Development 8,288 3,302 1,985 1,600 1,600 Development Fund(Waived til 2018) 101 42110 01 396.06 Evidence.com Data Storage 0 0 0 600 600 Squad Video 101 42110 01 396.07 Schedule Anywhere 0 0 0 0 600 Scheduling Software 101 42110 01 433.00 Dues & Subscriptions 10,500 _______________________________ 101 42110 01 433.01 Multi-Agency Assistance Group-MAAG 5,000 8,300 8,300 8,300 8,300 MAAG Equipment CIP Increase 101 42110 01 433.02 IACP Chiefs 120 120 150 185 185 _______________________________ 101 42110 01 433.03 MN Chiefs of Police 290 290 290 300 300 _______________________________ 101 42110 01 433.04 Dakota Cty Chiefs of Police 320 330 400 400 400 Chief and a Sergeant 101 42110 01 433.05 Wakota CAER 0 0 0 0 0 _______________________________ 101 42110 01 433.06 Metro Emergency Managers 0 0 0 0 0 _______________________________ 101 42110 01 433.07 MN Sex Crimes Investigators 0 0 0 20 20 _______________________________ 101 42110 01 433.08 Tri-County Investigators 0 75 75 50 50 _______________________________ 101 42110 01 433.09 MN Crime Prevention Association 60 45 45 65 65 _______________________________ 101 42110 01 433.10 P.O.S.T. Licenses 639 420 1,260 540 540 _______________________________ 101 42110 01 433.11 FBI Nat'l Academy Association 75 85 0 0 0 Chief's Membership Cancelled 101 42110 01 433.12 Miscellaneous 171 13 350 290 390 _______________________________ 101 42110 01 433.13 ATOM 0 0 0 250 250 Ass'n Training Officers of MN 101 42110 01 435.00 Books & Pamphlets 887 1,123 1,058 1,500 2,500 Crime Prevention Materials 101 42110 01 436.00 Towing Charges 0 158 255 200 200 Disabled Squads Disabled Squads 101 42110 01 437.00 Conferences & Seminars 28,400 _______________________________ 101 42110 01 437.01 Firearms - Range 2,299 2,130 4,325 4,000 4,500 Range Rental 101 42110 01 437.02 Chiefs Spring Conference 20 523 0 750 750 Conference Cost Increases 101 42110 01 437.03 Investigations 1,103 1,064 1,175 1,500 2,000 _______________________________ 101 42110 01 437.04 IACP Conference 352 210 295 300 400 _______________________________ 101 42110 01 437.05 Supervision 198 1,362 1,883 6,000 6,500 Personnel Developmnt Northwestern 101 42110 01 437.06 Use of Force 736 275 750 2,000 2,000 Increase due to Instructor Retiring 101 42110 01 437.07 Emergency Driving 225 1,575 2,625 3,000 3,000 Driving School Cost Increase 101 42110 01 437.08 First Aid 500 0 640 600 700 Cost Increase due to State Reg. Inc. 101 42110 01 437.09 Narcotic Enforcement 0 12 197 200 200 _______________________________ 101 42110 01 437.10 Tactical 213 819 1,269 1,000 1,000 _______________________________ 101 42110 01 437.11 Support Services 240 190 306 500 500 _______________________________ 101 42110 01 437.12 Patrol Operations 1,848 1,413 1,480 3,500 4,500 Increase due to C.I.T. for Patrol 101 42110 01 437.13 Emergency Management 224 32 0 200 0 _______________________________ 101 42110 01 437.14 SRO / CRO 0 0 0 1,000 1,300 Added for Specialized Training 101 42110 01 437.15 Explorer Conference 0 0 0 750 750 Two Advisors to State Conference 101 42110 01 437.16 360 Communities Annual Banquet 0 0 0 300 300 _______________________________ 101 42110 01 439.00 Other Miscellaneous Charges 265 94 783 500 800 Refreshments for Meetings & Compliance Checks 101 42110 01 580.00 Other Equipment Purchases 0 1,730 1,864 2,000 2,000 _______________________________ 101 42110 01 599.00 Employee Recognition Costs 0 0 0 0 2,000 Recognition Banquet/Plaques/Awards ------------------------------------------------------------------------------------------------------ PAGE TOTALS $92,422 $90,940 $105,450 $132,000 $142,800 DEPARTMENT TOTALS $3,201,808 $3,335,445 $3,597,506 $3,689,800 $3,943,300 ====================================================== Page 45 of 105 FIRE DEPARTMENT MISSION / VISION / GOALS The Rosemount Fire Department’s mission is an intricate component of the overall mission of the City of Rosemount in that the Fire Department is dedicated to the saving of life and property. This component which the Fire Department provides compliments and provides a necessary service so that the City may reach its broader mission of providing a safe, healthy and pleasant community in which to live and work. This service is provided by a paid-on-call department, which is the most fiscally sound method of delivery at this point in the City of Rosemount’s development. The Rosemount Fire Department enhances the overall vision that is set for the City of Rosemount in that it provides the opportunity for individuals to demonstrate their pride in the community by serving on a “volunteer” fire department and assisting their neighbors. The “volunteer” Fire Department has historically been associated with the kind of small town character that Rosemount is striving to maintain. ADMINISTRATIVE / MANAGEMENT •Provides for the overall administration and management of the Fire Department. Included is the collection, preparation and dissemination of information; the preparation of operating budgets, Capital Improvement Projects (CIP) budgets and state reports; and planning for the long and short term needs with respect to training, fire protection, emergency medical response, facilities, staffing and the acquisition and maintenance of equipment, along with the coordination of efforts between other emergency response agencies and those of the City of Rosemount. FIRE SUPPRESSION / INVESTIGATION •Provides for the controlling and extinguishing of all types of fires in order to minimize injury, loss of life and loss of property within the City of Rosemount, both to its citizens and visitors. •Provides for the controlling and extinguishing of all types of fires in order to minimize injury, loss of life and loss of property within the contracted areas of Coates and the University of Minnesota, along with the railroad right-of-ways. •Provides for the provision of all of these fire services to all the cities of Dakota County and many of the cities of Washington County via a mutual aid agreement by which these services can be reciprocated on an as needed basis. Page 46 of 105 FIRE DEPARTMENT – Page 2 • Provides for the investigation of fires by the local Fire Marshal. Also provides for the coordination of joint investigations by the local Fire Marshal and the State Fire Marshal. RESCUE SQUAD • Provides for emergency operations pertaining to bodily injury or serious illness requiring emergency services within the City of Rosemount, both to its citizens and visitors. • Provides for emergency operations pertaining to bodily injury or serious illness requiring emergency services within the contracted areas of Coates and the University of Minnesota. • Provides for the provision of all of these emergency operations to all the cities of Dakota County and many of the cities of Washington County via a mutual aid agreement by which these services can be reciprocated on an as needed basis. HAZARDOUS MATERIAL RESPONSE / CONFINED SPACE RESPONSE • Provides a team of Operations Level, Technician Level and Specialists, trained to respond to hazardous material accidents, identify, secure and coordinate the efforts of outside agencies that are trained to contain, mitigate and clean up the spill. • Trains all Firefighters to respond to confined space incidents, evaluate the situation and mitigate or coordinate the rescue effort. • Incorporates members of the department with the Dakota County S.O.T. team. WATER/ICE RESCUE • Provide technical water rescue during emergency situations to include the use of inflatable boats, throwing devices, water rescue suits and row boats. Page 47 of 105 FIRE DEPARTMENT – Page 3 TRAINING / EDUCATION • Provides for the necessary monthly and annual training requirements. • Allows for training in areas above those that are required, in order that fire and rescue personnel may sharpen existing skills and acquire new skills. • Allows for training of Firefighters to prepare themselves for the acceptance of a position of leadership within the Fire Department. HEALTH TESTING • Provides for the screening and medical certification of potential new fire fighters. • Allows for the continuous health monitoring of existing personnel. • Provides for the protection of personnel from blood-borne pathogens and communicable disease. EQUIPMENT / MAINTENANCE • Allows for the replacement or addition of equipment necessary for fire and medical response, including both consumable and nonconsumable items. • Provides for the emergency contracting with outside providers for repairs of fire vehicles and specialized equipment. STAFFING • In 2015, the Fire Department consisted of 45 paid on-call Firefighters serving in various capacities within the department. This number was an upward swing in the right direction. We added six Firefighters to fill the void of members that left the department due retirement, job change, low percentages and the fact that the time commitment was too much. We will strive to hit our capacity of 50 Firefighters and look to create an eligibility list, something that hasn’t been accomplished in quite some time. Page 48 of 105 FIRE DEPARTMENT – Page 4 PERFORMANCE MEASURES Total Number of Paged Calls 2011 2012 2013 2014 2015 Fire 288 351 277 303 272 Medical 402 373 360 412 438 Average Response Time: High Priority Calls 2011 2012 2013 2014 2015 7:24 6:52 6:45 6:39 6:14 Number of Attendances at Outside Training 2011 2012 2013 2014 2015 28 46 15 35 28 Total Number of Fire Fighters 2011 2011 2013 2014 2015 Total 44 44 43 39 45 Added 5 3 5 6 6 Net Change 1 0 -1 -4 6 Number of Customer Complaints 2011 2012 2013 2014 2015 1 0 0 0 0 Insurance Industry Rating of Fire Services (ISO Rating) 2011 2012 2013 2014 2015 City 4/5 4/5 4/5 4/5 4/5 Rural 10 10 10 10 10 n/a – Information Not Available Page 49 of 105 Page One 2017 BUDGET WORKSHEETS FIRE September 20, 2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- All Salary Costs Inclusive of 101 42210 103.00 Salaries & Benefits $155,420 $163,743 $203,534 $213,000 $218,000 Salary, Taxes, PERA & Benefits 101 42210 103.01 Salaries 32,000 ____________________________ 101 42210 103.02 Training Pay 51,000 ____________________________ 101 42210 103.03 Call Pay/Stipends 135,000 ____________________________ 101 42210 103.04 Class Pay/Stipends 0 ____________________________ 101 42210 01 202.00 Duplicating & Copying 200 ____________________________ 101 42210 01 202.01 Copy Toner 0 0 97 50 100 ____________________________ 101 42210 01 202.02 Computer Printers 0 14 0 50 100 ____________________________ 101 42210 01 204.00 Envelopes & Letterhead 500 ____________________________ 101 42210 01 204.01 Envelopes 0 0 0 200 200 Need New Stationary in 2017 101 42210 01 204.02 Letterhead 0 0 0 200 200 Need New Stationary in 2017 101 42210 01 204.03 Forms 0 10 0 100 100 Need to Update Supply 101 42210 01 211.00 Cleaning Supplies 800 ____________________________ 101 42210 01 211.01 Soaps 885 47 278 550 550 ____________________________ 101 42210 01 211.02 Chamois, Towels, etc.0 0 0 50 50 ____________________________ 101 42210 01 211.03 Sponges, etc.0 0 0 50 50 ____________________________ 101 42210 01 211.04 SCBA Cleaner 0 91 100 150 150 ____________________________ 101 42210 01 218.00 Fire Department Clothing 5,000 ____________________________ 101 42210 01 218.01 Uniforms 2,923 1,268 319 1,500 1,700 Uniforms for New Hires 101 42210 01 218.02 Station Wear (2015)449 179 572 3,000 3,300 Yearly Allowance for Fire Fighters 101 42210 01 219.00 Other Operating Supplies 8,400 Medical Supplies 101 42210 01 219.01 Gloves 692 510 2,638 1,000 2,500 ____________________________ 101 42210 01 219.02 Bandages 0 0 0 100 100 ____________________________ 101 42210 01 219.03 Equipment 1,564 380 4,766 1,500 1,500 ____________________________ 101 42210 01 219.04 Tyvek Suits 0 0 0 100 100 ____________________________ 101 42210 01 219.05 Consummable Medical 2,174 2,406 2,566 3,000 3,000 Increase in Medical Calls 101 42210 01 219.06 Oxygen 126 917 (467)1,200 1,200 Added O2 Cascade @ FS #2 101 42210 01 229.00 Other Maintenance Supplies 6,900 ____________________________ 101 42210 01 229.01 Vehicle Repairs 0 0 58 400 400 ____________________________ 101 42210 01 229.02 Pickup Trucks 0 0 0 0 0 ____________________________ 101 42210 01 229.03 Rescue & Other 0 0 0 0 0 ____________________________ 101 42210 01 229.04 Vehicle Modifications 0 1,147 55 3,500 6,500 Replace Aging Light Bars 101 42210 01 230.00 Equipment Repair Materials 1,500 ____________________________ 101 42210 01 230.01 Light Bars 0 0 0 100 100 ____________________________ 101 42210 01 230.02 Smoke Machines 113 0 0 300 300 ____________________________ 101 42210 01 230.03 Lanterns & Miscellaneous 1,808 0 64 300 300 ____________________________ 101 42210 01 230.04 Small Tool Repairs 241 181 640 600 600 ____________________________ 101 42210 01 230.05 Opticom 0 0 0 100 100 ____________________________ 101 42210 01 230.06 Station 0 10 101 100 100 ____________________________ 101 42210 01 241.00 Small Tools 900 ____________________________ 101 42210 01 241.01 Axes, Bars & Other 15 42 1,413 150 150 ____________________________ 101 42210 01 241.02 Grass Fire 0 0 0 250 250 ____________________________ 101 42210 01 241.03 Hand Tools (2014 - Donation)338 5,994 461 500 500 Replace Aging Tools 101 42210 01 305.00 Medical & Dental Fees 3,120 3,039 2,560 3,800 4,500 Switching Testing Company-2017 101 42210 01 306.00 Personnel Testing & Recruitment 5,300 ____________________________ 101 42210 01 306.01 New Physicals (4)1,942 1,823 2,448 2,000 4,000 New Hires 101 42210 01 306.02 Hepatitis Shots (4)0 0 220 500 500 ____________________________ 101 42210 01 306.03 Background Checks (4)183 438 403 500 600 ____________________________ 101 42210 01 306.04 Drug Testing (4)0 0 0 200 200 ____________________________ 101 42210 01 308.00 Instructors' Fees 9,100 ____________________________ 101 42210 01 308.01 Fire Fighter 1 (4)1,015 1,951 600 1,600 1,600 ____________________________ 101 42210 01 308.02 Fire Fighter 1 Certificates (4)75 0 0 300 300 ____________________________ 101 42210 01 308.03 Fire Fighter Re-Certificates (14)320 280 200 400 400 ____________________________ 101 42210 01 308.04 First Responder (4)0 495 0 1,000 1,000 ____________________________ 101 42210 01 308.05 First Responder Refresher (1/2)1,350 1,447 1,200 1,400 1,400 ____________________________ 101 42210 01 308.06 Outside Schools 879 17,035 2,335 3,300 3,300 ____________________________ 101 42210 01 308.07 Haz-Mat Training (4)1,675 0 0 1,000 1,000 ____________________________ 101 42210 01 308.08 Other Re-Certificates (2)0 55 0 100 100 ____________________________ ------------------------------------------------------------------------------------------ PAGE TOTALS 177,305 203,503 227,160 248,200 261,100 Page 50 of 105 Page Two 2017 BUDGET WORKSHEETS FIRE September 20, 2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 101 42210 01 310.00 Testing Services 5,800 ____________________________ 101 42210 01 310.01 Aerial 750 750 2,373 1,000 2,500 ____________________________ 101 42210 01 310.02 Ladders 436 564 434 800 800 Increase in Fees 101 42210 01 310.03 Pumpers (3) (Next 2014)675 2,344 829 2,500 2,500 Increase in Fees 101 42210 01 310.04 SCBA Hydro Testing (Next 2016)0 0 0 0 0 ____________________________ 101 42210 01 313.00 Temporary Service Fees 15,300 ____________________________ 101 42210 01 313.01 SCBA Maintenance 3,105 1,988 1,800 4,500 4,500 Added SCBA Compressor-FS #2 101 42210 01 313.02 SCBA Flow Test 780 783 500 2,500 2,500 Added SCBA Compressor-FS #2 101 42210 01 313.04 Security Contract 610 656 656 800 800 ____________________________ 101 42210 01 313.05 SOT Joint Powers 5,770 6,867 6,867 7,500 7,500 Increase in Fees 101 42210 01 314.00 Annual Fire Relief Contribution 171,000 171,000 109,100 30,000 30,000 ____________________________ 101 42210 01 319.00 Other Professional Services 2,200 Fire Prevention Education 101 42210 01 319.01 School Literature 0 0 0 400 400 ____________________________ 101 42210 01 319.02 Door Prizes 0 0 114 200 200 ____________________________ 101 42210 01 319.03 Fire Prevention Week Promos 408 307 694 700 700 ____________________________ 101 42210 01 319.04 Food at Open House 141 283 223 300 300 ____________________________ 101 42210 01 319.05 Summer Park Education 0 0 0 0 0 ____________________________ 101 42210 01 319.06 National Night Out 539 762 0 600 600 ____________________________ 101 42210 01 321.00 Telephone Costs 5,000 ____________________________ 101 42210 01 321.01 Cell Phones 2,481 1,818 3,002 2,500 3,200 Active 911 Subscriptions 101 42210 01 321.02 Computer Cards 0 0 0 1,800 1,800 ____________________________ 101 42210 01 321.04 Numeric Pagers 0 0 0 0 0 ____________________________ 101 42210 01 322.00 Postage Costs 0 18 0 100 100 UPS Costs 101 42210 01 329.00 Other Communication Costs 21,300 ____________________________ 101 42210 01 329.01 Base Repairs 0 0 0 300 300 ____________________________ 101 42210 01 329.02 Pager Repairs 835 235 1,356 1,000 1,000 ____________________________ 101 42210 01 329.03 Hand Held Repairs 72 0 1,884 2,000 2,500 Warranty Plan to be Added 101 42210 01 329.04 Mobile Repairs 560 930 0 1,000 2,000 Aging Equipment 101 42210 01 329.05 800 MHZ User Fee 9,555 11,758 10,079 14,000 14,000 ____________________________ 101 42210 01 329.06 Mobile Computers 937 1,320 1,416 1,500 1,500 Monthly Air Time Fees (1 Add'n) 101 42210 01 331.00 Travel Expense 8,600 ____________________________ 101 42210 01 331.01 Minnesota Chief's Conference 1,083 0 0 2,000 2,000 ____________________________ 101 42210 01 331.02 Fire Department Association 0 0 0 1,600 1,600 ____________________________ 101 42210 01 331.03 Outside Schools 0 0 0 5,000 5,000 FDYC Training Added 101 42210 01 333.00 Freight & Express Expense 0 0 0 0 0 ____________________________ 101 42210 01 433.00 Dues & Subscriptions 2,000 ____________________________ 101 42210 01 433.01 Capital City 50 0 0 50 50 ____________________________ 101 42210 01 433.02 VFBA Insurance 287 307 672 350 775 ____________________________ 101 42210 01 433.03 State Fire 318 385 763 725 800 ____________________________ 101 42210 01 433.04 State Chiefs 0 345 0 250 250 ____________________________ 101 42210 01 433.05 DCFC 0 150 75 75 75 ____________________________ 101 42210 01 433.06 WAKOTA Mutual Aid 50 50 50 50 50 ____________________________ 101 42210 01 433.07 Purchasing Consortium 0 0 0 0 0 ____________________________ 101 42210 01 433.08 NFPA 0 0 0 0 0 ____________________________ 101 42210 01 433.09 "Future Use"0 0 0 0 0 ____________________________ 101 42210 01 437.00 Conferences & Seminars 1,900 ____________________________ 101 42210 01 437.01 State Fire Conference 0 367 323 400 400 ____________________________ 101 42210 01 437.02 State Chief's Conference 440 1,148 1,718 1,000 1,500 Sending Additional Personnel 101 42210 01 439.00 Other Miscellaneous Charges 3,100 ____________________________ 101 42210 01 439.01 Food & Coffee 565 546 818 700 700 ____________________________ 101 42210 01 439.02 Extinguisher 356 0 505 600 600 ____________________________ 101 42210 01 439.03 Plaques 30 91 139 200 200 ____________________________ 101 42210 01 439.04 Paint 0 0 0 100 100 ____________________________ 101 42210 01 439.05 Station Needs 737 987 1,617 1,500 1,500 ____________________________ 101 42210 01 580.00 Other Equipment Purchases 27,600 ____________________________ 101 42210 01 580.01 Bunker Gear (8)13,549 20,744 33,626 18,600 18,600 ____________________________ 101 42210 01 580.02 Pagers 0 385 2,245 5,000 5,000 Replacements (5 Per Year) 101 42210 01 580.03 Hose & Fittings 6,904 1,349 407 2,000 2,000 Aging Equipment 101 42210 01 580.04 Replace Damaged Items 2,502 1,001 6,917 2,000 2,000 ____________________________ 101 42210 01 581.00 Other Equipment Purchases 0 0 0 0 0 101 42210 01 586.00 Other Equipment Purchase 1,866 0 0 0 0 Donation Items ------------------------------------------------------------------------------------------ PAGE TOTALS $227,391 $230,239 $191,199 $118,200 $122,900 DEPARTMENT TOTALS $404,696 $433,742 $418,359 $366,400 $384,000 ================================================ Page 51 of 105 PUBLIC WORKS The Public Works Department has a mission to enhance the quality of life through responsive, efficient, and cost-effective delivery of services consistent with community values. With sound management, fiscal responsibility and professional care, the Department will preserve and protect the infrastructure resources of the City, creating a safe, clean and enjoyable environment for residents and businesses. The Public Works Department consists of the Engineering and Operations Divisions. The maintenance personnel maintain the streets, storm drainage, sanitary sewer and potable water systems, along with all government buildings, parks and all City grounds. The Department manages its expenditures and revenues through the following four (4) maintenance funds and three (3) enterprise funds: Government Buildings Fleet Maintenance Street Maintenance Parks Maintenance (*) Water Operating (*) Sewer Operating (*) Storm Water Operating (*) Separate Enterprise Fund Budgets from those included here under the advisement of the Utility Commission of the City of Rosemount. The Public Works Department currently has a combined permanent work force of 23 positions for the areas of engineering, buildings, fleet maintenance, streets, parks and the enterprise-funded utilities. The City also employs up to 14 seasonal part-time people to help during periods that require higher levels of maintenance. Page 52 of 105 PUBLIC WORKS – Page 2 - RESPECTIVE BUDGETS - GOVERNMENT BUILDINGS This budget provides for the management, operation, maintenance and repair of the City's buildings. This includes City Hall, the MN DOT garage, the Public Works building and garage, and two Fire Stations. It also includes three (3) park shelters and the Family Resource Center. Maintenance and operation of the Community Center / Ice Arena is not included in this budget. FLEET MAINTENANCE This budget provides for the maintenance of all City-owned vehicles and over 250 units of large and small equipment. It provides funding for all fuels, oils, parts, tires, shop supplies, and contracted vehicle maintenance. The City-owned vehicles include: • Police Department (4 sedans, 1 pickup truck, 10 SUVs, 3 shared SWAT units) • Fire Department (13 units) • Parks and Recreation (2 pickup trucks, 2 vans, 1 ice resurfacer) • Administration / Community Development (1 car, 1 pickup truck, 2 SUVs, 1 van) • Utility Department (1 Jetter, 1 Vactor, 2 trucks) • Streets and Parks Maintenance (2 sweepers, 3 tractors, 1 loader, 2 skidsters, 7 dump trucks, 1 water truck, 6 mowers, 13 pickup trucks, 1 pavement roller, 5 snow blowers, 6 snow blower attachments, 5 large trailers) STREET MAINTENANCE This budget provides for the maintenance and preservation of 110 miles of City roads, 100 miles of sidewalks and bike trails, and 23 parking lots. Standard maintenance includes grading, graveling, patching, sealing and overlays. This budget also provides for pavement markings, street signs, street lighting, signal light maintenance and power, snow and ice control, and street sweeping. PARKS MAINTENANCE This budget provides for the maintenance of over 500 acres of park space in 29 locations, including 14 parks with athletic fields, 12 parks with shelters or pavilions, and numerous athletic fields at DCTC, UMore, and the Flint Hills Athletic Complex. It includes the maintenance of all park trails and 10 other municipal areas, including City Hall, two Fire Stations and the Community Center. It also includes the installation and maintenance of playground equipment, landscaping projects, ice rink construction and maintenance, and other miscellaneous construction activities. Page 53 of 105 PUBLIC WORKS – Page 3 PERFORMANCE MEASURES Average Overall (Network) City Street Pavement Condition Rating 2010 2011 2012 2013 2014 2015 73.83 73.69 n/a 72.70 73.88 71.73 Value of Projects Ordered (Contract Amount) 2010 2011 2012 2013 2014 2015 $5,400,000 $5,462,900 $4,193,954 $4,090,678 $5,116,275 $1,831,088 % Change from Prior Year (Above) 2010 2011 2012 2013 2014 2015 282% 0.1% -23.2% -2.5% 25.1% -64.2% Average Number of Hours for Full Snow Clearing Event 2010-11 2011-12 2012-13 2013-14 2014-15 2015-16 6.80 6.92 7.70 7.60 6.60 7.40 % of Mechanics’ Time Spent on Repair / Maintenance 2010 2011 2012 2013 2014 2015 93% 97% 92% 94% 97% 90% Park Acres Maintained 2010 2011 2012 2013 2014 2015 133 134 152 152 155 160 n/a – Information Not Available Page 54 of 105 Page One 2017 BUDGET WORKSHEETS GOVERNMENT BUILDINGS September 20, 2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- All Salary Costs Inclusive of 101 41940 101.00 Salaries & Benefits $114,400 Salary, Taxes, PERA & Benefits 101 41940 77 101.01 Administrative 0 0 3,353 7,000 8,000 P.W. Director / City Engineer 101 41940 79 101.01 Maintenance 72,144 67,802 68,709 71,400 106,400 Facility Specialist (80%) 101 41940 102.00 Full-Time Overtime 1,791 1,047 563 0 0 ____________________________ 101 41940 01 208.00 Miscellaneous Supplies 19,744 16,604 15,995 18,000 18,000 Cleaning, Paper Prod., Coffee 101 41940 01 219.00 Other Operating Supplies 1,980 2,012 2,580 2,500 2,800 Flags 101 41940 01 223.00 Building Repair Supplies 7,881 10,602 8,760 13,000 10,500 Light Bulbs, Locks, etc. 101 41940 01 225.00 Landscaping Materials 1,614 1,367 442 1,500 1,500 Trees & Shrubs 101 41940 01 241.00 Small Tools 276 187 422 300 600 Carpentry, Bits, Blades, etc. 101 41940 01 242.00 Minor Equipment 829 1,384 995 2,000 1,000 Equipment Replacement 101 41940 01 302.00 Architects' Fees 0 0 0 0 0 Estimates 101 41940 01 318.00 Contract Engineer 2,500 3,000 1,562 0 0 ____________________________ 101 41940 01 319.00 Other Professional Services 86,300 ____________________________ 101 41940 01 319.01 Elevator Maintenance 3,110 2,388 1,887 2,500 2,500 ____________________________ 101 41940 01 319.02 Heating/Cooling Maint Contract 5,336 6,457 7,322 9,000 9,000 Includes all City Facilities 101 41940 01 319.03 Annual Boiler Inspections / Maint.75 75 50 800 500 ____________________________ 101 41940 01 319.04 Pest Control 2,821 2,972 3,144 3,100 4,500 Price Incr., Boxelder Treatment 101 41940 01 319.05 Fire Extinguishers 1,859 1,255 810 1,800 1,800 ____________________________ 101 41940 01 319.06 Fire Suppression System Check 3,400 2,505 2,569 3,500 3,500 ____________________________ 101 41940 01 319.07 Janitorial Service-Fire Stations 10,016 9,762 9,837 10,200 10,200 ____________________________ 101 41940 01 319.08 Janitorial Service-P.W. Building 10,529 10,620 10,774 10,700 11,000 ____________________________ 101 41940 01 319.09 Janitorial Service-City Hall 26,266 26,035 26,232 26,700 26,700 ____________________________ 101 41940 01 319.10 Floor Mats - Monthly Charges 4,361 4,125 4,491 4,500 5,000 Vendor Price Increase 101 41940 01 319.11 Other Janitorial Services 11,468 9,779 9,635 12,000 10,500 Wax Flrs, Carpet Clng, Windows 101 41940 01 319.12 Annual Monument Maintenance 1,025 1,025 1,075 1,100 1,100 $900 - $1200 (Hot Wax) 101 41940 01 321.00 Telephone Costs 447 735 726 800 800 Air Card for iPad-Monthly Chgs 101 41940 01 381.00 Electric Utilities 75,732 69,202 63,971 77,000 70,000 ____________________________ 101 41940 01 383.00 Gas Utilities 63,594 73,444 49,446 70,000 65,000 ____________________________ 101 41940 01 384.00 Refuse Disposal 39,000 ____________________________ 101 41940 01 384.01 General Buildings & Parks 18,982 19,289 19,936 20,000 22,000 Add 2 Parks in 2016 101 41940 01 384.02 Recycling/Cleanup 14,484 15,161 13,373 17,000 17,000 Increased Recycling Costs 101 41940 01 393.00 P.C. Hardware Purchases 850 0 0 0 0 ____________________________ 101 41940 01 394.00 P.C. Software Purchases 0 0 0 0 0 Will Share Cartegraph Cost in '18 101 41940 01 401.00 Contracted Building Repairs 60,000 ____________________________ 101 41940 01 401.01 Electrical Repairs 7,293 12,970 2,973 8,000 8,000 ____________________________ 101 41940 01 401.02 Siren Operations & Maintenance 3,688 4,748 6,648 10,000 7,000 ____________________________ 101 41940 01 401.03 Miscellaneous Repairs 35,205 51,040 49,062 13,000 25,000 ____________________________ 101 41940 01 401.04 HVAC Repairs 0 0 0 25,000 20,000 ____________________________ 101 41940 01 402.00 Security Card System Maintenance 0 0 0 2,500 5,000 Updates, Prev. Maint., Tech Supt. 101 41940 01 416.00 Machinery Rental 0 0 0 0 1,500 Lift Rental 101 41940 01 437.00 Conferences & Seminars 0 0 0 200 200 ____________________________ 101 41940 01 439.00 Other Miscellaneous Charges 5,950 0 5,573 5,000 6,000 Energy Efficiency Improvements 101 41940 01 530.00 Improvements Other Than Buildings 60,000 85,000 87,833 92,000 92,000 From Long-Term Plan 101 41940 01 601.00 Bond Principal 65,368 0 0 0 0 Will Be Paid from Assigned Funds 101 41940 01 611.00 Bond Interest 19,629 0 0 0 0 Will Be Paid from Assigned Funds 101 41940 01 621.00 Bond Paying Agent Fees 0 0 0 0 0 ____________________________ ------------------------------------------------------------------------------------------ PAGE TOTALS $560,247 $512,590 $480,747 $542,100 $574,600 DEPARTMENT TOTALS $560,247 $512,590 $480,747 $542,100 $574,600 `================================================ Page 55 of 105 Page One 2017 BUDGET WORKSHEETS FLEET MAINTENANCE September 20, 2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- All Salary Costs Inclusive of 101 43100 101.00 Salaries & Benefits $221,800 Salary, Taxes, PERA & Benefits 101 43100 77 101.00 Administrative 10,586 10,933 17,871 25,500 28,000 _____________________________ 101 43100 78 101.00 Technical/Clerical 9,415 9,972 10,144 10,700 11,200 _____________________________ 101 43100 79 101.00 Maintenance 158,351 163,952 177,494 172,400 182,600 _____________________________ 101 43100 102.00 Full-Time Overtime 1,117 304 1,183 3,000 3,000 _____________________________ 101 43100 01 211.00 Cleaning Supplies 4,378 2,685 2,609 4,000 4,000 Shop & Vehicles 101 43100 01 212.00 Motor Fuels 201,394 188,784 162,298 200,000 158,000 Part Moved to Utilities 101 43100 01 213.00 Lubricants & Additives 13,231 10,020 9,811 15,000 15,000 _____________________________ 101 43100 01 215.00 Shop Materials 19,270 15,279 13,479 20,000 20,000 _____________________________ 101 43100 01 221.00 Equipment Parts 103,190 99,142 103,841 120,000 120,000 _____________________________ 101 43100 01 222.00 Tires 24,375 38,757 15,783 30,000 30,000 _____________________________ 101 43100 01 241.00 Small Tools 4,249 2,919 4,125 5,000 5,000 Replace Old Tools 101 43100 01 242.00 Minor Equipment 2,544 1,902 5,715 4,000 4,000 _____________________________ 101 43100 01 318.00 Contract Engineer 5,000 6,000 3,125 0 0 _____________________________ 101 43100 01 321.00 Telephone Costs 0 0 0 0 0 _____________________________ 101 43100 01 323.00 Radio Units (Warranty & Batteries)1,830 905 905 1,000 1,000 _____________________________ 101 43100 01 384.00 Refuse Disposal 0 0 0 300 300 Shop Hazardous Waste 101 43100 01 394.00 P.C. Software Purchases 6,500 _____________________________ 101 43100 01 394.01 Licensing & Maintenance 1,646 1,668 1,735 2,000 2,000 CarteGraph OMS 101 43100 01 394.02 Online Subscriptions 1,997 1,500 2,188 3,000 3,000 ALLDATA/Cummings/CAT/Detroit 101 43100 01 394.03 New Software Purchases 1,860 0 1,200 1,500 1,500 _____________________________ 101 43100 01 404.00 Contracted Mach & Equip Services 53,837 65,000 _____________________________ 101 43100 01 404.01 Contracted Services 0 60,912 37,772 55,000 55,000 Aging Equipment, FD Units, Towing 101 43100 01 404.02 Contracted Preventative Maint.0 9,626 11,836 10,000 10,000 Power Wash All, Paint One Unit 101 43100 01 416.00 Machinery Rental 0 0 0 500 500 _____________________________ 101 43100 01 433.00 Dues/Subscriptions/Certifications 0 0 0 100 300 DOT Cert. ASE Cert., EVT Cert. 101 43100 01 435.00 Books & Pamphlets 195 48 60 200 200 DOT Decals and Inspection Pads 101 43100 01 437.00 Conferences & Seminars 90 90 157 300 300 _____________________________ ------------------------------------------------------------------------------------------ PAGE TOTALS $618,556 $625,398 $583,331 $683,500 $654,900 DEPARTMENT TOTALS $618,556 $625,398 $583,331 $683,500 $654,900 ================================================ Page 56 of 105 Page One 2017 BUDGET WORKSHEETS STREET MAINTENANCE September 20, 2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ All Salary Costs Inclusive of 101 43121 101.00 Salaries & Benefits $598,500 Salary, Taxes, PERA & Benefits 101 43121 77 101.00 Administrative 21,172 21,866 35,742 51,000 91,800 Added-$36K for Asst. City Engineer 101 43121 78 101.00 Technical/Clerical 51,712 55,442 53,541 55,300 54,900 ______________________________ 101 43121 79 101.00 Maintenance 408,540 416,767 429,553 426,300 451,800 ______________________________ 101 43121 102.00 Full-Time Overtime 10,343 14,733 9,409 14,000 14,000 Maintenance 101 43121 99 103.00 Part-Time Salaries & Benefits 21,958 15,293 18,916 20,000 21,000 Includes Funds for P/T Horticulturist 101 43121 01 201.00 Office Accessories 500 0 0 100 100 ______________________________ 101 43121 01 203.00 Printed Forms & Paper 0 ______________________________ 101 43121 01 203.01 R/W Permit & Inspection Forms 0 0 0 0 0 ______________________________ 101 43121 01 203.03 City Specification Books 0 0 804 0 0 ______________________________ 101 43121 01 205.00 Drafting Supplies 700 ______________________________ 101 43121 01 205.01 Plotter Ink and Paper 1,275 1,001 374 500 500 Split with 101-45202-01-205.00 101 43121 01 205.02 Off-Site Reproductions 160 0 0 200 200 ______________________________ 101 43121 01 209.00 Other Office Supplies 1,480 720 73 700 700 ______________________________ 101 43121 01 216.00 Chemical & Chemical Products 128,197 84,057 65,574 103,000 103,000 ______________________________ 101 43121 01 224.00 Street Maintenance Materials 14,300 ______________________________ 101 43121 01 224.01 Paint 403 314 441 500 500 ______________________________ 101 43121 01 224.02 Mail Boxes 1,757 1,357 1,428 1,500 1,500 ______________________________ 101 43121 01 224.03 Light Bulbs/Lenses 51 315 68 800 800 Replace with LED Bulbs 101 43121 01 224.04 Holiday Decorations 3,818 3,952 7,951 10,500 9,000 Contracted Tree Lighting 101 43121 01 224.04 Miscellaneous 0 0 0 0 2,500 Fencing, Miscellaneous Supplies 101 43121 01 225.00 Landscaping Materials 16,000 ______________________________ 101 43121 01 225.01 Turf Restoration Material 445 2,731 162 3,500 2,000 ______________________________ 101 43121 01 225.02 Seed 186 0 108 0 0 ______________________________ 101 43121 01 225.03 Black Dirt 599 0 0 0 0 ______________________________ 101 43121 01 225.04 Trees 155 159 272 500 500 ______________________________ 101 43121 01 225.05 Planters & Brackets 2,868 3,150 3,033 3,500 3,500 ______________________________ 101 43121 01 225.06 Entrance Monuments 200 1,182 1,665 1,500 1,000 ______________________________ 101 43121 01 225.07 Downtown Planters 1,973 1,275 2,034 2,000 2,500 ______________________________ 101 43121 01 225.08 Park Signs, Central Park 2,331 2,508 3,464 2,500 3,000 Includes Business Park Sign 101 43121 01 225.09 City Facilities 0 118 1,117 1,500 3,000 CH, RCC, FS1, FS2, LIB, STP, ACT 101 43121 01 225.10 Banners/Flag Components 0 180 0 500 500 ______________________________ 101 43121 01 226.00 Sign Repair Materials 4,069 10,827 7,950 6,000 ______________________________ 101 43121 01 226.01 Signs and Posts 5,500 5,500 ______________________________ 101 43121 01 226.02 Solar Batteries 500 500 ______________________________ 101 43121 01 231.00 Bituminous Patching Materials 26,784 27,083 29,722 37,500 37,500 ______________________________ 101 43121 01 232.00 Crushed Rock 32,206 30,331 35,628 30,000 30,000 1/2 Mile of Bacardi Paved in 2015 101 43121 01 233.00 Dust Control Materials 26,188 24,550 31,529 30,000 32,000 Bonaire/Akron - FHR Fields 101 43121 01 234.00 De-Icing Sand / Rock 6,435 4,235 1,161 4,500 4,500 Gravel Road Ice Control 101 43121 01 235.00 Shouldering Gravel 0 0 0 0 0 ______________________________ 101 43121 01 241.00 Small Tools 632 680 1,357 1,000 1,000 Shovels, Brooms, etc. 101 43121 01 242.00 Minor Equipment 6,490 3,366 2,536 3,000 3,000 Safety Equipment / Power Tools ______________________________ 101 43121 01 303.00 Engineering Fees 26,913 64,776 50,851 10,000 20,000 ______________________________ 101 43121 01 303.01 General Non-Project Related 15,000 ______________________________ 101 43121 01 303.02 Pavement Management 5,000 ______________________________ 101 43121 01 304.00 Legal Fees 0 0 0 0 0 ______________________________ 101 43121 01 310.00 Testing Services 0 1,125 0 0 0 ______________________________ 101 43121 01 318.00 Contract Engineer 10,000 12,000 6,250 0 0 ______________________________ 101 43121 01 319.00 Other Professional Services 0 0 0 2,000 ______________________________ 101 43121 01 319.01 "Future Use"0 0 0 0 0 ______________________________ 101 43121 01 319.02 GIS Consulting Services 344 3,071 2,276 5,000 2,000 Reduce Due to In-House Eng. 101 43121 01 321.00 Telephone Costs 2,623 2,629 3,113 3,700 3,700 Includes Wireless Technology 101 43121 01 323.00 Radio Units 1,045 1,367 1,120 1,500 5,100 (24x$300)(12x$1500) (Split 5 Ways) 101 43121 01 331.00 Travel Expense 6 6 242 200 200 ______________________________ 101 43121 01 381.00 Electric Utilities 175,100 ______________________________ 101 43121 01 381.01 Street Lights 174,559 164,890 163,598 170,000 172,000 ______________________________ 101 43121 01 381.02 Signal Lights & Sirens 2,680 2,943 2,592 3,000 3,100 ______________________________ 101 43121 01 384.00 Refuse Disposal 1,400 ______________________________ 101 43121 01 384.01 Hazardous Waste Disposal 0 1,508 0 500 500 ______________________________ 101 43121 01 384.02 Roadside Garbage 572 160 407 900 900 ______________________________ 101 43121 01 391.00 P.C. Maintenance 800 ______________________________ 101 43121 01 391.03 Pavement Management Syst Sup 8,977 17,550 15,824 10,000 0 Moved to 101-43121-01-303.02 101 43121 01 391.04 R-O-W Permit On-Line Service 536 585 643 800 800 ______________________________ 101 43121 01 392.00 P.C. Accessories & Supplies 0 0 0 0 0 ______________________________ 101 43121 01 393.00 P.C. Hardware Purchases 2,093 1,600 0 1,500 1,500 ______________________________ 101 43121 01 394.00 P.C. Software Purchases 7,200 ______________________________ 101 43121 01 394.01 Licensing & Maintenance 4,212 4,371 4,591 6,200 6,200 CarteGraph, OMS, ESRI 101 43121 01 394.02 Online Subscriptions 286 379 379 800 800 Pictometry 101 43121 01 394.03 New Software Purchases 235 0 0 200 200 ______________________________ ---------------------------------------------------------------------------------------------------- PAGE TOTALS 998,009 1,007,149 997,497 1,026,200 1,099,300 Page 57 of 105 Page Two 2017 BUDGET WORKSHEETS STREET MAINTENANCE September 20, 2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ 101 43121 01 402.00 Parking Lot Maintenance 25,000 65,000 55,000 60,000 70,000 From Long-Term Plan 101 43121 01 403.00 Contracted Repair & Maintenance 21,500 ^^ CH, RCC Lots Not Included ^^ 101 43121 01 403.01 Street Lights 27,080 786 2,384 5,000 5,000 Street Light/Pole Repair/Replace 101 43121 01 403.02 Signal Lights 510 463 488 1,500 1,500 ______________________________ 101 43121 01 403.03 Light Replacements 0 18,250 0 15,000 15,000 Conversion to LED 101 43121 01 404.00 Railroad Administration/Mgmt.1,683 9,574 0 15,000 15,000 QZ Update Due Jan '17, Misc Issues 101 43121 01 405.00 Street Striping 35,469 50,688 10,798 45,000 45,000 ______________________________ 101 43121 01 408.00 Street Crack Sealing 55,249 53,349 38,776 60,000 60,000 Increased Curb Seals 101 43121 01 409.00 Tree Trimming 7,630 8,375 9,071 8,500 10,000 ______________________________ 101 43121 01 410.00 Concrete Sidewalk/Curb Repairs 20,000 ______________________________ 101 43121 01 410.01 General Repairs 30,402 14,422 23,493 20,000 20,000 ______________________________ 101 43121 01 410.02 Pedestrian Improvements 0 0 146,924 0 0 Moved $125,000 to Street CIP 101 43121 01 411.00 Contracted Snow Removal 58,000 ______________________________ 101 43121 01 411.01 Community Center 24,081 19,710 8,961 23,000 23,000 ______________________________ 101 43121 01 411.02 Steeple Center 15,708 13,712 3,999 15,000 15,000 ______________________________ 101 43121 01 411.04 Dakota County Library 20,698 18,305 9,181 20,000 20,000 ______________________________ 101 43121 01 415.00 Equipment Rental 21,184 16,328 11,108 22,000 20,500 ______________________________ 101 43121 01 433.00 Dues & Subscriptions 1,300 ______________________________ 101 43121 01 433.01 American Public Works Ass'n 820 912 855 1,000 1,000 Annual Membership 101 43121 01 433.03 City Engineers' Association 0 0 0 100 100 ______________________________ 101 43121 01 433.07 MN Street Superintendent Ass'n 100 100 100 200 200 ______________________________ 101 43121 01 433.09 MN Transportation Alliance 0 788 804 0 0 ______________________________ 101 43121 01 437.00 Conferences & Seminars 6,200 ______________________________ 101 43121 01 437.01 APWA 1,765 1,780 0 3,000 2,000 State/Nat'l Conference in 2016 101 43121 01 437.03 Clerical 0 0 0 0 0 ______________________________ 101 43121 01 437.05 Maintenance Expo 0 0 134 300 300 ______________________________ 101 43121 01 437.06 Cartegraph, ESRI, GIS 237 161 0 1,300 1,300 User Group, Conference, Training 101 43121 01 437.07 Snow Conference 0 0 177 300 300 ______________________________ 101 43121 01 437.08 MN Dot 0 0 0 300 300 Simulator 101 43121 01 437.09 Miscellaneous Training 1,924 576 615 2,000 2,000 DCTC Defensive Driving Training 101 43121 01 439.00 Other Miscellaneous Charges 915 1,199 448 500 800 CONDAC, CDL Licenses 101 43121 01 570.00 Office Equipment & Furnishings 0 644 0 0 0 ______________________________ ---------------------------------------------------------------------------------------------------- PAGE TOTALS $270,456 $295,122 $323,315 $319,000 $328,300 DEPARTMENT TOTALS $1,268,465 $1,302,271 $1,320,812 $1,345,200 $1,427,600 ===================================================== Page 58 of 105 Page One 2017 BUDGET WORKSHEETS PARKS & GROUNDS MAINTENANCE September 20, 2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- All Salary Costs Inclusive of 101 45202 101.00 Salaries & Benefits $448,100 Salary, Taxes, PERA & Benefits 101 45202 77 101.00 Administrative 21,172 21,866 25,685 30,200 37,900 Add $6K for Asst. City Engineer 101 45202 78 101.00 Technical/Clerical 18,829 19,944 20,288 21,400 22,300 _______________________________ 101 45202 79 101.00 Maintenance 337,975 340,619 324,310 363,300 387,900 Added $62.4K-75% of New Person 101 45202 102.00 Full-Time Overtime 15,864 12,615 4,617 14,000 8,000 Reduce O/T with New Position 101 45202 99 103.00 Part-Time Salaries & Benefits 53,181 51,085 52,927 63,000 55,800 Reduce Horticulturist & Eliminate 1 101 45202 01 205.00 Plotter Ink and Paper 57 197 91 500 500 Split with 101-43121-01-205.01 101 45202 01 216.00 Chemical & Chemical Products 22,150 28,338 31,794 35,000 47,500 Jpn Bttl '16-18, Add in-house chem 101 45202 01 219.00 Other Operating Supplies 35,000 _______________________________ 101 45202 01 219.01 Seed, Sod, etc.4,722 4,948 3,962 6,000 6,000 FHR Fields Online in 2014 101 45202 01 219.02 Red Rock, Sand, Gravel, etc.9,448 8,830 10,449 10,000 14,000 Topdressing Program 101 45202 01 219.03 Repair Supplies 0 0 0 0 0 _______________________________ 101 45202 01 219.05 Wood Chips 12,691 12,000 12,000 15,000 15,000 Playgrounds 101 45202 01 220.00 Splash Pad Maintenance 0 0 8,899 7,500 2,500 Supplies 101 45202 01 221.00 Equipment Parts 18,500 _______________________________ 101 45202 01 221.01 Playground Equipment Repair 7,847 5,459 5,812 8,000 8,000 Repairs on Aging Equipment 101 45202 01 221.02 Irrigation Repair(In-House)3,487 6,357 6,962 8,000 8,000 _______________________________ 101 45202 01 221.03 Miscellaneous 2,340 2,397 2,204 2,500 2,500 Ballfield Fence Repair 101 45202 01 221.04 Park Sign Replacements 0 0 0 0 0 _______________________________ 101 45202 01 223.00 Shelter Repair Supplies 2,400 _______________________________ 101 45202 01 223.01 Paint, Stain, etc.383 606 862 1,500 800 _______________________________ 101 45202 01 223.02 Shingles, Boards, etc.569 784 324 1,500 600 _______________________________ 101 45202 01 223.03 Miscellaneous 992 1,016 629 1,500 1,000 _______________________________ 101 45202 01 223.04 Shelter/Shed Repairs 2,200 829 147 0 0 Paid from Building Maint. Budget 101 45202 01 225.00 Landscaping Materials 3,000 _______________________________ 101 45202 01 225.01 Trees, Shrubs, etc.1,459 1,200 1,779 2,500 2,000 _______________________________ 101 45202 01 225.02 Timbers, Fence, etc.2,775 70 132 2,500 1,000 Field Fence Maintenance 101 45202 01 226.00 Sign Repair Materials 0 0 0 500 500 _______________________________ 101 45202 01 229.00 Other Maintenance Supplies 21,173 9,728 14,101 20,000 18,000 Paint, Chalk, Field Dry, Etc. 101 45202 01 241.00 Small Tools 1,734 1,560 1,738 2,500 2,000 Hand Tools, Blades, Bits, etc. 101 45202 01 242.00 Minor Equipment 1,972 2,576 4,340 5,000 5,000 Weed Whips, Chain Saws, etc. _______________________________ 101 45202 01 303.00 Engineering Fees (GIS)0 0 0 5,000 2,000 Reduce Due to In-House Engineer 101 45202 01 318.00 Contract Engineer 2,500 3,000 1,562 0 0 _______________________________ 101 45202 01 319.00 Other Professional Services 11,000 _______________________________ 101 45202 01 319.01 Maintenance of Open Spaces 347 18,697 4,738 9,000 7,000 Prairies, Controlled Burns, etc. 101 45202 01 319.02 Landscaping & Flower Beds 3,924 8,142 9,456 6,000 4,000 Reduced Both Due to New Person 101 45202 01 321.00 Telephone Costs 3,915 3,927 3,836 5,000 5,000 All Wireless, Including iPad 101 45202 01 323.00 Radio Units 1,045 1,367 1,120 1,500 5,100 (24x$300)(12x$1500) (Split 5 Ways) 101 45202 01 381.00 Electric Utilities 24,000 Anticipated Rate Increase 101 45202 01 381.01 Skating Rinks 8,342 6,370 6,235 8,500 8,500 Service Connect / Disconnect 101 45202 01 381.02 Softball Fields 7,328 6,379 7,843 8,500 8,500 _______________________________ 101 45202 01 381.03 Irrigation 6,339 6,651 5,507 8,000 7,000 Umore 2013, Flint Hills 2014 101 45202 01 383.00 Gas Utilities 2,070 2,287 1,684 2,500 2,500 _______________________________ 101 45202 01 393.00 P.C. Hardware Purchases 2,833 1,600 0 1,000 1,000 _______________________________ 101 45202 01 394.00 P.C. Software Purchases 7,200 _______________________________ 101 45202 01 394.01 Licensing & Maintenance 4,212 4,371 4,591 6,200 6,200 Cartegraph, OMS, ESRI 101 45202 01 394.02 Online Subscriptions 286 379 379 800 800 Pictometry 101 45202 01 394.03 New Software Purchases 235 0 0 200 200 _______________________________ ---------------------------------------------------------------------------------------- PAGE TOTALS 586,398 596,193 581,005 684,100 704,600 Page 59 of 105 Page Two 2017 BUDGET WORKSHEETS PARKS & GROUNDS MAINTENANCE September 20, 2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 101 45202 01 403.00 Contracted Repair & Maintenance 10,000 _______________________________ 101 45202 01 403.01 Irrigation Repairs 2,070 9,806 2,425 8,000 5,000 RPZ-Inspect 101 45202 01 403.02 Electrical Repairs 2,811 2,479 1,462 3,000 3,000 _______________________________ 101 45202 01 403.03 Miscellaneous Repairs 575 1,425 3,654 1,000 2,000 Hard Court Fencing 101 45202 01 409.00 Other Contracted Repair & Maint 22,500 _______________________________ 101 45202 01 409.01 Spring Clean Up 0 0 0 1,200 1,200 Dethatching, Flower Beds, etc. 101 45202 01 409.02 Library / Steeple Center / RCC 9,374 8,521 9,081 9,500 10,000 Mowing / Chemicals - VonBank 101 45202 01 409.03 Fire Station #1 4,080 3,834 4,087 4,200 0 Eliminate with New Person Added 101 45202 01 409.04 Fire Station #2 2,867 2,556 2,724 3,000 0 Eliminate with New Person Added 101 45202 01 409.05 City Hall / Central Park 6,948 6,391 6,811 7,000 0 Eliminate with New Person Added 101 45202 01 409.06 UMore Baseball Fields 15,000 2,980 3,844 5,000 5,300 Chemicals - VonBank 101 45202 01 409.07 FHR Soccer Fields 0 2,451 5,901 5,000 6,000 Chemicals - VonBank 101 45202 01 416.00 Machinery Rental 26,000 _______________________________ 101 45202 01 416.01 Mower Leases 16,203 15,161 18,000 21,000 21,000 3 Mowers 101 45202 01 416.02 Miscellaneous Rentals 7,372 4,092 4,478 5,000 5,000 Gator (Utility Vehicle for Ballfields) 101 45202 01 433.00 Dues & Subscriptions 200 _______________________________ 101 45202 01 433.01 MN Park Supervisors Ass'n 0 50 0 50 50 _______________________________ 101 45202 01 433.02 Miscellaneous Dues 90 0 75 150 150 _______________________________ 101 45202 01 435.00 Books & Pamphlets 0 0 263 0 0 _______________________________ 101 45202 01 437.00 Conferences & Seminars 3,800 _______________________________ 101 45202 01 437.01 Seminars & Workshops 719 2,001 1,334 1,200 1,500 Green Expo, MPSA, Playgrounds 101 45202 01 437.02 School & Tuition 1,031 465 624 1,300 1,300 Turf School, Power Limited Tech. 101 45202 01 437.03 CarteGraph, ESRI, GIS 120 126 0 1,300 1,000 User Group, Conference, Training 101 45202 01 439.00 Other Miscellaneous Charges 224 39 48 200 200 Contingencies 101 45202 01 530.00 Improvements Other Than Bldgs 75,000 135,286 149,439 160,000 175,000 From Long-Term Plan ---------------------------------------------------------------------------------------- PAGE TOTALS $144,486 $197,663 $214,249 $237,100 $237,700 DEPARTMENT TOTALS $730,884 $793,855 $795,254 $921,200 $942,300 =============================================== Page 60 of 105 PARKS AND RECREATION The Parks and Recreation Department works together with citizens to provide a safe, healthy and pleasant community. Parks and recreation are essential services that can impact health, crime prevention, the environment, the economy and the quality of life for Rosemount residents. ADMINISTRATION •Provides for overall planning, coordination, management of personnel and administration of activities within the department of Parks and Recreation. This department provides a diversified range of activities and facilities for the residents of Rosemount. The long range planning, budget preparation and development of parks and coordination with other service agencies are ongoing activities. Administrative services also provide the residents of Rosemount an opportunity to reserve facilities and register for programs. RECREATION •Provides the Rosemount resident a variety of recreational activities serving all ages. Program offerings are based on the needs of residents as determined and evaluated by the Parks and Recreation Commission and staff. Coordination with other service agencies encourages a comprehensive, quality and efficient base of programs. COMMUNITY CENTER •Provides for operation of a multi-purpose Community Center, which offers facilities for recreational programs, banquets, meetings, events, theatrical productions, seminars and exercise. The Community Center provides services in the form of meeting space, gym space for community groups and sponsorship of community events. The Parks and Recreation Department provides ongoing, preventive maintenance and janitorial services of the Community Center and portions of the National Guard facilities. STEEPLE CENTER •Provides the operations of the Steeple Center which opened in 2010 in the former St. Joseph’s church building at the north end of Downtown Rosemount. The Center is available for weddings, banquets, meetings, parties, performances and special events. Staff coordinates the rentals, maintenance and capital improvement projects of the facility. In 2015, a 10,000 square foot addition which features a lobby area with a beautiful fireplace, gorgeous floor to ceiling windows and café-style seating, which is open to the general public. It is a great place to stop in for a cup of coffee, play a card or board game with a friend. The Steeple Center is home to the Rosemount Area Seniors and all senior programming as well as many classes and events hosted by the Rosemount Area Arts Council. Page 61 of 105 PARKS & RECREATION DEPARTMENT – Page 2 PERFORMANCE MEASURES Total Hours of Use at Community Center 2011 2012 2013 2014 2015 19,390 20,472 20,098 20,120 20,015 Hours of Use at Community Center at No Charge 2011 2012 2013 2014 2015 n/a 11,773* 9,536* 9,540* 11,769* Total Community Center Rental Income and % Change from Prior Fiscal Year 2011 2012 2013 2014 2015 Income $99,829 $89,242 $78,315 $85,740 $98,189 % Change +2.5% -10.6% -12.2% +9.3% +14.5% Number of Acres in the Park System and % Change from Prior Fiscal Year 2011 2012 2013 2014 2015 Income 467.24 467.24 532.74 532.74 537.65 % Change +6.8% +0.0% +14.1% +0.0% +0.93% 2009 – Added DCTC Soccer Fields 2011 – Added UMore Ball Fields 2013 – Added Flint Hills Fields 2015 – Added Greystone Percentage of Costs Received for All Recreation Programs 2011 2012 2013 2014 2015 Revenues $134,981 $128,233 $117,646 $110,876 $89,022 Expenses $113,336 $107,994 $109,009 $96,092 $ 87,272 Net $21,645 $20,239 $8,637 $14,784 $1,750 n/a – Information Not Available * Hours used at no charge are included in the total hours used at the Community Center. Page 62 of 105 Page One 2017 BUDGET WORKSHEETS PARKS & RECREATION September 20, 2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- All Salary Costs Inclusive of 101 45100 101.00 Salaries & Benefits $741,601 $762,122 $748,284 $804,100 $832,800 Salary, Taxes, PERA & Benefits 101 45100 102.00 Full-Time Overtime 5,660 3,018 1,372 5,000 5,000 Upgrades for Coord, Lead Pay^^ 101 45100 103.00 Part-Time Salaries & Benefits 191,400 _____________________________ 101 45100 10 103.00 P/T Receptionist 36,758 37,221 44,930 46,000 38,300 _____________________________ 101 45100 12 103.00 Building Attendants 55,230 46,178 53,567 54,000 54,000 _____________________________ 101 45100 15 103.00 P/T Recreation Coordinator 0 0 13,296 35,100 52,600 _____________________________ 101 45100 83 103.00 Playground Recreation Leaders 26,362 23,195 25,026 26,000 29,500 _____________________________ 101 45100 94 103.00 Warming House Attendants 16,287 10,347 10,162 15,000 15,000 _____________________________ 101 45100 99 103.00 Park & Rec Committee 1,920 1,420 1,464 2,000 2,000 _____________________________ 101 45100 01 203.00 Printed Forms & Paper 0 0 0 0 0 _____________________________ 101 45100 01 205.00 Drafting Supplies 25 0 500 500 500 Laminating 101 45100 01 207.00 Training & Instructional Supplies 0 0 0 0 0 _____________________________ 101 45100 01 208.00 Miscellaneous Supplies 0 0 0 0 0 _____________________________ 101 45100 01 209.00 Other Office Supplies 190 259 873 500 500 Envelopes, Forms, Rulers, etc. 101 45100 01 211.00 Cleaning Supplies 5,233 3,573 4,553 4,500 4,500 _____________________________ 101 45100 01 216.00 Chemicals & Chemical Products 282 689 527 0 0 Moved to "211.00" 101 45100 01 219.00 Other Operating Supplies 10,052 7,593 9,438 8,000 8,000 Rec Programs, 1st Aid Sup, etc. 101 45100 01 221.00 Equipment Parts 7,074 6,772 9,599 8,000 8,000 _____________________________ 101 45100 01 223.00 Building Repair Supplies 2,536 649 2,039 1,500 1,500 _____________________________ 101 45100 01 229.00 Other Maintenance Supplies 5,367 9,736 4,635 9,000 6,000 Tournament Supplies 101 45100 01 312.00 Custodial Services 5,990 4,461 5,450 6,000 6,000 Custodial Services-Banquet Rm 101 45100 01 315.00 Special Programs 20,000 _____________________________ 101 45100 01 315.01 Sunday Night Specials 5,039 4,873 5,326 5,500 5,500 Performances (Add Movies) 101 45100 01 315.02 Leprechaun Days 200 910 400 250 250 _____________________________ 101 45100 01 315.03 Umore Maint. Agreement 4,000 2,000 2,038 2,000 2,000 _____________________________ 101 45100 01 315.04 Ground Pounders(Running)169 200 225 200 200 Ribbons & Mailings 101 45100 01 315.05 Nature Programs (Arbor Day)4,741 0 221 0 0 Move to 101-41110-01-225.00 101 45100 01 315.06 Puppet Programs 54 0 189 150 150 Tapes, Fuses, Puppets, etc. 101 45100 01 315.07 Special Events 3,055 849 1,512 3,000 2,000 Publicity & Supplies (Winter Fest) 101 45100 01 315.08 Adopt-A-Park Program 67 54 50 500 500 Flyers, Signs 101 45100 01 315.09 Miscellaneous Programs 4,004 2,223 1,680 4,500 9,000 Community Gardens/Senior Prog 101 45100 01 315.10 ADA Programs 0 0 0 400 400 ADA Program Supplies 101 45100 01 319.00 Other Professional Services 431 6,964 6,802 6,000 6,000 ADA Services/Eng.LA Serv Test 101 45100 01 321.00 Telephone Costs 3,750 3,904 4,354 4,000 4,000 Pagers & Cellular Phones 101 45100 01 331.00 Travel Expense 874 253 493 1,000 1,000 _____________________________ 101 45100 01 341.00 Employment Advertising 0 0 0 0 0 _____________________________ 101 45100 01 349.00 Other Advertising 33,400 _____________________________ 101 45100 01 349.01 Brochures 29,427 28,574 29,572 29,000 29,000 City Newsletter (3 Per Year) 101 45100 01 349.02 Yellow Pages 643 385 391 1,500 500 Rec Ads 101 45100 01 349.03 Special Marketing 5,043 4,522 4,806 3,900 3,900 Garage Sale Ad 101 45100 01 381.00 Electric Utilities 37,269 33,207 30,874 30,000 30,000 _____________________________ 101 45100 01 383.00 Gas Utilities 28,636 34,036 21,845 30,000 30,000 _____________________________ 101 45100 01 384.00 Refuse Disposal 3,066 3,062 3,062 4,000 3,200 _____________________________ 101 45100 01 392.00 P.C. Accessories & Supplies 0 0 0 0 0 _____________________________ 101 45100 01 393.00 P.C. Hardware Purchases 0 0 0 0 0 _____________________________ 101 45100 01 394.00 P.C. Software Purchases 0 0 0 0 0 See "433.03" Below 101 45100 01 401.00 Contracted Building Repairs 14,693 13,070 9,771 12,000 12,000 _____________________________ 101 45100 01 404.00 Contracted Mach & Equip Repairs 13,012 13,542 13,647 9,000 9,000 _____________________________ 101 45100 01 409.00 Other Contracted Repair & Maint 24,599 26,330 24,143 24,000 24,000 Air Handler Maintenance Contract 101 45100 01 412.00 Building Rental 16,800 16,800 16,800 16,800 16,800 Monthly Rent Payments to Guard 101 45100 01 415.00 Other Equipment Rental 22,872 22,480 24,749 24,000 24,000 Portable Toilets & Other(New Pks) 101 45100 01 433.00 Dues & Subscriptions 6,400 _____________________________ 101 45100 01 433.01 MRPA Dues 1,520 1,520 1,809 1,700 1,700 Minn Recreation & Parks Ass'n 101 45100 01 433.02 Miscellaneous 2,469 2,445 2,515 2,000 2,000 Paper, Magazines, etc. 101 45100 01 433.03 On-Line Registrat'n Subscription 1,620 2,053 2,025 2,700 2,700 _____________________________ 101 45100 01 435.00 Books & Pamphlets 0 0 0 100 100 _____________________________ 101 45100 01 437.00 Conferences & Seminars 6,000 _____________________________ 101 45100 01 437.01 MRPA State Conference 1,065 1,604 1,353 2,000 2,000 _____________________________ 101 45100 01 437.03 Workshops, Schools, & Tuition 2,334 1,191 2,008 4,000 4,000 Additional Training 101 45100 01 439.00 Other Miscellaneous Charges 8,869 13,378 7,721 0 0 Donation Account 101 45100 01 530.00 Improvements Other Than Bldgs 0 0 0 0 0 _____________________________ ---------------------------------------------------------------------------------------------------- PAGE TOTALS $1,160,888 $1,157,660 $1,156,093 $1,249,400 $1,290,100 General Operating DEPARTMENT TOTALS $1,160,888 $1,157,660 $1,156,093 $1,249,400 $1,290,100 ===================================================== Page 63 of 105 Page Two 2017 BUDGET WORKSHEETS PARKS & RECREATION ** STEEPLE CENTER ** September 20, 2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 101 38201.00 Rental Revenues $11,910 $4,800 $0 $18,000 $28,000 _____________________________ 101 38205.00 A/V Rental Revenues 0 0 0 500 2,000 _____________________________ 101 38209.00 Miscellaneous Revenues 0 175 0 0 0 _____________________________ 101 38211.00 Security Services 1,729 651 0 1,000 2,000 _____________________________ ---------------------------------------------------------------------------------------------------- TOTAL REVENUES $13,639 $5,626 $0 $19,500 $32,000 2015 Closed for Construction 101 45100 30 103.00 Salaries & Benefits $52,000 Salary, Taxes, PERA & Benefits 101 45100 30 103.00 Building Attendants 13,485 5,177 1,639 34,000 52,000 Staff ^^ 101 45100 30 211.00 Cleaning Supplies 1,849 1,059 822 4,000 4,000 _____________________________ 101 45100 30 219.00 Other Operating Supplies 2,531 2,704 4,855 2,500 2,500 Events Supplies 101 45100 30 221.00 Equipment Parts 656 0 6,099 1,500 1,500 _____________________________ 101 45100 30 223.00 Building Repair Supplies 3,422 4,444 3,134 5,500 5,500 _____________________________ 101 45100 30 241.00 Small Tools 187 0 0 500 500 _____________________________ 101 45100 30 242.00 Minor Equipment 1,012 191 353 2,000 2,000 _____________________________ 101 45100 30 312.00 Custodial Services 1,357 299 450 2,000 2,000 _____________________________ 101 45100 30 321.00 Telephone Costs 1,760 219 547 3,000 3,000 _____________________________ 101 45100 30 349.00 Other Advertising 0 0 0 600 600 _____________________________ 101 45100 30 365.00 Workers' Comp Insurance 0 0 0 0 0 Pay from Insurance Fund 101 45100 30 369.00 Other Insurance 0 0 0 0 0 Pay from Insurance Fund 101 45100 30 381.00 Electric Utilities 5,319 5,485 10,472 6,500 6,500 _____________________________ 101 45100 30 383.00 Gas Utilities 7,971 10,065 6,934 10,000 10,000 _____________________________ 101 45100 30 384.00 Refuse Disposal 1,150 1,068 0 1,800 1,800 _____________________________ 101 45100 30 401.00 Contracted Building Repairs 5,645 14,069 17,266 9,000 9,000 _____________________________ 101 45100 30 404.00 Contracted Mach & Equip Repairs 6,265 4,803 2,334 7,000 7,000 _____________________________ 101 45100 30 409.00 Other Contracted Repairs & Main 0 1,532 0 2,500 2,500 Holiday Lights 101 45100 30 415.00 Other Equipment Rental 0 0 0 1,000 1,000 _____________________________ 101 45100 30 439.00 Other Miscellaneous Charges 0 0 0 0 0 _____________________________ 101 45100 30 521.00 Building & Structure Purchases 0 0 0 0 0 _____________________________ ---------------------------------------------------------------------------------------------------- PAGE/EXPENDITURE TOTALS $52,608 $51,115 $54,906 $93,400 $111,400 2015 Combined Steeple Center / Activity Center Expenditures Page 64 of 105 Page Three 2017 BUDGET WORKSHEETS PARKS & RECREATION September 20, 2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- $91,800 101 45100 80 Art Classes $0 $0 $0 $0 $0 _____________________________ 101 45100 81 Softball 34,384 25,390 20,188 23,500 23,500 101 45100 84 Tennis 1,943 2,379 2,292 2,000 2,200 _____________________________ 101 45100 86 Rosettes 1,927 2,363 2,098 2,000 2,000 _____________________________ 101 45100 87 Senior Programs 7,035 5,754 7,711 6,000 6,000 _____________________________ 101 45100 90 Run for the Gold 4,892 4,878 4,890 4,500 4,800 _____________________________ 101 45100 91 Camps 27,510 24,778 30,904 24,000 30,000 _____________________________ 101 45100 92 Adult Basketball 0 0 (139)600 600 _____________________________ 101 45100 93 Other Programs 11,740 12,751 11,964 14,000 14,000 _____________________________ 101 45100 95 T-Ball 4,308 5,720 4,261 5,000 5,000 _____________________________ 101 45100 96 Teen Night 882 350 986 0 900 _____________________________ 101 45100 97 Adult Soccer League 11,209 8,835 0 0 0 No Longer Offered 101 45100 98 Youth Soccer Lessons 3,179 2,894 2,117 2,800 2,800 _____________________________ ----------------------------------------------------------------------------------------------------_____________________________ 109,009 96,092 87,272 84,400 91,800 101 45100 80 219.00 Operating Supplies 0 0 0 0 0 _____________________________ 101 45100 81 103.00 Part-Time Salaries 5,345 4,083 3,748 3,500 3,500 _____________________________ 101 45100 81 219.00 Operating Supplies 6,386 2,679 3,327 2,500 2,500 _____________________________ 101 45100 81 311.00 Officiating Fees 20,575 17,323 12,261 16,000 16,000 _____________________________ 101 45100 81 319.00 Other Professional Services 2,079 1,305 851 1,500 1,500 _____________________________ 101 45100 84 103.00 Part-Time Salaries 1,673 1,935 2,216 1,500 1,700 _____________________________ 101 45100 84 219.00 Operating Supplies 270 444 75 500 500 _____________________________ 101 45100 86 103.00 Part-Time Salaries 817 870 1,104 1,000 1,000 _____________________________ 101 45100 86 219.00 Operating Supplies 1,110 1,493 994 1,000 1,000 _____________________________ 101 45100 87 103.00 Part-Time Salaries 0 0 0 0 0 _____________________________ 101 45100 87 219.00 Operating Supplies 6,000 _____________________________ 101 45100 87 219.01 Youth/Teen Trips Supplies 0 0 0 500 0 101 45100 87 219.02 Adult/Senior Supplies 7,035 5,754 7,711 5,500 6,000 101 45100 90 219.00 Operating Supplies 4,892 4,878 4,890 4,500 4,800 _____________________________ 101 45100 91 103.00 Part-Time Salaries 14,013 10,724 15,934 9,000 16,000 _____________________________ 101 45100 91 219.00 Operating Supplies 13,498 14,054 14,970 15,000 14,000 _____________________________ 101 45100 92 219.00 Operating Supplies 0 0 (139)600 600 _____________________________ 101 45100 93 103.00 Part-Time Salaries 2,232 3,842 5,582 3,000 3,000 _____________________________ 101 45100 93 219.00 Operating Supplies 9,507 8,909 6,382 11,000 11,000 _____________________________ 101 45100 93 319.00 Other Professional Services 0 0 0 0 0 101 45100 95 103.00 Part-Time Salaries 2,878 4,095 3,043 3,500 3,500 _____________________________ 101 45100 95 219.00 Operating Supplies 1,430 1,626 1,218 1,500 1,500 _____________________________ 101 45100 96 103.00 Part-Time Salaries 0 0 0 0 0 _____________________________ 101 45100 96 219.00 Operating Supplies 882 350 986 0 900 _____________________________ 101 45100 97 103.00 Part-Time Salaries 0 0 0 0 0 _____________________________ 101 45100 97 219.00 Operating Supplies 1,609 5,595 0 0 0 No Longer Offered 101 45100 97 311.00 Officiating Fees 9,600 3,240 0 0 0 No Longer Offered 101 45100 98 103.00 Part-Time Salaries 2,138 2,147 1,444 1,800 1,800 _____________________________ 101 45100 98 219.00 Operating Supplies 1,040 747 672 1,000 1,000 _____________________________ ---------------------------------------------------------------------------------------------------- SPECIAL PROGRAM TOTALS 109,009 96,092 87,272 84,400 91,800 GRAND TOTAL - PARK & REC $1,322,504 $1,304,867 $1,298,271 $1,427,200 $1,493,300 ===================================================== Page 65 of 105 OTHER FINANCING USES - TRANSFERS This is a transfer set up beginning in 2007 for the assistance from the General Fund to the Arena Fund for the operations of the arena. Page 66 of 105 Page One 2017 BUDGET WORKSHEETS OTHER FINANCING USES September 20, 2016 2016 2015 Object 2016 2013 2014 2015 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 101-49300-01 710.00 Transfers $115,000 $115,000 $130,000 $130,000 $130,000 ____________________________ 101-49300-01 710.01 Arena Operations Assistance 0 0 0 0 130,000 ____________________________ 101-49300-01 710.02 Debt Service Levies 0 0 0 0 0 ____________________________ 101-49300-01 720.00 Transfers 0 360,000 500,000 0 0 Excess F/B Transfers ------------------------------------------------------------------------------------------ FUND TOTALS $115,000 $475,000 $630,000 $130,000 $130,000 ================================================ Page 67 of 105 CAPITAL IMPROVEMENT PLAN (CIP) GENERAL / ADMINISTRATIVE •Provides for specific funding of items, the nature of which are not considered "current" in their use or life expectancy. These items are generally of a higher estimated cost than $5,000 and will have a life expectancy of 3 years or greater. •The source of funding for these expenditures is typically the general tax levy. In some instances, other funding is utilized. For example, beginning in 1996, revenues received from user fees have been designated in the CIP funds for capital equipment purchases or for street projects such as gravel road resurfacing. If these revenues are realized, the equipment or project will be completed and if the revenue is not realized the equipment or project will not be completed. Individual departments are designated for each item proposed for purchase in this plan. •Included are three separate funds to isolate and better track the types of capital improvements being planned for. The following briefly describes each of the three: Building CIP Fund - This fund is used to account for the on-going capital improvements and possible additions to government buildings. Street CIP Fund - This fund is used to account for the on-going street construction and reconstruction projects within the City and all other major maintenance items related to both paved and unpaved streets including, but not limited to, street lights, signal lights, sidewalks and gravel road resurfacing. Equipment CIP Fund - This fund is used to account for the on-going replacement of and additions to City equipment. •The CIP budgets included with this document are for the year 2017 only. As part of a long-range planning process, a 10-year CIP working plan has been adopted for the years 2017 through 2026. This is a working plan only, with the current year (2017 in this case) being approved as part of the formal budget process. Page 68 of 105 MSA 9/14/16 Building Funds & Facilities Street Equipment Park Imp From Water Sewer Storm Water Sewer Storm Debt Serv Total Year Item - Description Department CIP CIP CIP Assess Fund State Core Core Core Utility Utility Utility Levy Other Cost 2017 1 Replace Ice Edger Arena 6,000 (1)6,000 2017 2 Restroom Rehab - Upper Arena 30,000 (1)30,000 2017 3 PC Workstation Upgrades (From 2012) (Police, Fire, P.W.)Finance 69,000 69,000 2017 4 Technology Upgrades Station #1 (New)Fire 10,000 10,000 2017 5 Hose Truck (Replace 1-Ton Truck) (New)Fire 55,000 55,000 2017 6 City-Wide Software Gen'l. Govt.25,000 25,000 2017 7 Indoor Recreational Facilities (Year 2 of 2)Gen'l. Govt.750,000 750,000 2017 8 New Covered Picnic Tables at Central Park Park & Rec 12,000 12,000 2017 9 Parks Master Plan Update Park & Rec 20,000 20,000 2017 10 Dunmore Park Development Park & Rec 150,000 150,000 2017 11 Horsehoe Lake Park - Phase 1 Park & Rec 200,000 200,000 2017 12 Greystone Park Development Park & Rec 500,000 500,000 2017 13 Carroll's Woods Restoration Park & Rec 200,000 200,000 2017 14 Replace Police Portable Radio Batteries (New)Police 4,500 4,500 2017 15 Body Cameras Police 14,000 10,000 (2)24,000 2017 16 Portable Alarm Replacements Police 15,000 15,000 2017 17 Squad Set Up and Equipment Installation Police 20,000 20,000 2017 18 Replace Squad Laptops (5) / Printers / Netmotion (2019 Combined)Police 70,000 70,000 2017 19 2 Squads (Sell Back 2 - #3560 & #3570)Police 64,000 18,000 (3)82,000 2017 20 PW Building Addition Lease/Purchase (Year 19 of 20)Pub Works 24,000 10,000 10,000 44,000 2017 21 Pedestrian Improvements Program Pub Works 125,000 125,000 2017 22 PMP (Shannon Hills B, Shannon Parkway A)Pub Works 944,367 83,137 1,027,504 2017 23 County Road 38 - CSAH 31 to TH 3 (ROW Costs) Pub Works 72,000 128,000 (4)200,000 2017 24 County Road 73 - Bonaire Path to IGH (ROW Costs) Pub Works 225,000 275,000 (5)500,000 2017 25 CSAH 42 Bridge at TH 52 (Includes Watermain Extension)Pub Works 2,475,000 800,000 10,025,000 (6)13,300,000 2017 26 Keegan Lake Drainage Improvements (New)Pub Works 118,750 356,250 475,000 2017 27 Cartegraph OMS Implementation & Licensing (New)Pub Works 42,900 10,700 10,700 10,700 75,000 2017 28 6" Trash Pump (Replace #8088) (Purchased 1989)Pub Works 7,000 7,000 8,000 22,000 2017 29 Dump & Clean Station for Vactor / Mowers (New)Pub Works 40,000 40,000 2017 30 Broom Attach for #8071 & #8072 (Replace #0146) (1995) (New)Pub Works 5,000 5,000 2017 31 Paint Mixer Pub Works 12,000 12,000 2017 32 RTV Kubota (Replace #8401) (Purchased 2004)Pub Works 18,000 2,000 (7)20,000 2017 33 Ford Focus - Inspections (Replace #8612) (2000 Vehicle)Pub Works 23,000 2,000 (7)25,000 2017 34 Minivan (Replace #8621) (1998 Vehicle)Pub Works 28,500 1,500 (7)30,000 2017 35 1-Ton Pickup (Replace #8315) (2006 Vehicle)Pub Works 31,000 4,000 (7)35,000 2017 36 1-Ton Pickup (Replace #8333) (2003 Vehicle)Pub Works 10,000 11,000 10,000 4,000 (7)35,000 2017 37 JD Tractor & Broom Attachment (Replace #8408 & 0139) (2002)Pub Works 65,700 16,000 (7)81,700 2017 38 Sweeper (Replace #8444) (Purchased 2005)Pub Works 99,000 99,000 12,000 (7)210,000 2017 39 Hook Truck for Anti-Ice (with Dump Box) (New)Pub Works 160,000 160,000 2017 40 Grader (Replace #8413 & #0192) (Purchased 2001)Pub Works 260,000 40,000 (7)300,000 974,000 1,069,367 1,091,600 83,137 882,000 2,772,000 800,000 0 118,750 37,700 38,700 523,950 0 10,573,500 18,964,704 Total CIP Funding Requirements - Year 2017 $3,134,967 $0 (1)Ice Edger & Upper Restroom Rehab funding comes from Arena Fund operations/reserves. (2)Other funding for Body Cameras comes from assigned funds. (3)Other funding for Squad Cars comes from auction sales of old vehicles. (4)Other funding for County Road 38 project from County's share and the City of Apple Valley's share of project. Costs are for Right of Way purchases. (5) Other funding for County Road 73 project from County share of project. Costs are for Right of Way purchases. (6)Other funding for CSAH 42 Bridge at TH 52 comes from County State Aid and Federal Funding. (7) Other funding for Public Works equipment comes from trade-in value of old vehicles. Total Building CIP levy for 2017 is $24,000. If there is a difference, the difference between this number and the number from above is a result of a 10-year funding program and other funding alternatives (such as potential SKB revenues). Total Street CIP levy for 2017 is $828,360. If there is a difference, the difference between this number and the number from above is a result of a 10-year funding program and other funding alternatives. Total Equipment CIP levy for 2017 is $580,000. If there is a difference, the difference between this number and the number from above is a result of a 10-year funding program and other funding alternatives (such as potential SKB revenues). Page 69 of 105 INSURANCE GENERAL / ADMINISTRATIVE •Provides for the funding of the City's Worker's Compensation Insurance and General Liability Insurance. Currently, both insurances are provided through the League of Minnesota Cities Insurance Trust. This agency allows the City to have thorough, yet affordable insurance. •In 1995, we set up a separate Internal Service Fund for insurance purposes. The amount levied was, and will be, the same as it would have been if the Insurance budget had been in the General Fund, as it has been in the past. But, this allows us to build a special fund for insurance purposes that will allow the City to move towards self-insurance, and ultimately, lower rates. We do not anticipate ever being totally self-insured, but by raising our deductibles we approach that point and allow ourselves to save substantially on our annual insurance premiums. Doing so will allow the City to operate more efficiently and save the taxpayers money without taking undue risks. Page 70 of 105 Page One 2017 BUDGET WORKSHEETS INSURANCE - REVENUES September 20, 2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 206 31010.00 Current Ad Valorem Taxes $245,000 $245,000 $245,000 $245,000 $260,000 ____________________________ 206 33100.00 Federal Grants & Aids 0 0 0 0 0 ____________________________ 206 36210.00 Interest Earnings-Investments 6,562 4,103 4,682 4,000 4,000 ____________________________ 206 36214.00 Net Change in FV-Investments 0 0 0 0 0 Annual Market Value Changes 206 36215.00 Interest Earnings 46 33 91 100 100 ____________________________ 206 36260.00 Other Revenue 52,280 244,491 86,393 30,000 30,000 Insurance Refunds/Dividends 206 36265.00 Use of Reserve Funds 0 0 0 39,500 60,900 (2014-$217,000 Hail Damage) ------------------------------------------------------------------------------------------ FUND TOTALS 303,887 493,627 336,166 318,600 355,000 ================================================ INSURANCE - EXPENDITURES 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 206 49006 01 221.00 Equipment Parts $515 $4,187 $7,049 $5,000 $5,000 Liability & Auto Deductible Pymts 206 49006 01 304.00 Legal Fees 500 1,755 0 1,000 1,000 Unreimbursable Legal Fees 206 49006 01 305.00 Medical & Dental Fees 11,489 6,949 6,379 7,500 7,000 Work Comp Deductible Pymts 206 49006 01 317.00 General Fund Administrative Fees 2,500 2,500 2,500 2,500 2,500 Yearly Fee Per Policy F-3 206 49006 01 319.00 Other Professional Services 19,500 ____________________________ 206 49006 01 319.01 Risk Management Consultant 6,000 6,000 6,250 6,000 6,500 ____________________________ 206 49006 01 319.02 CHESS Consultant 12,300 12,540 12,720 12,600 13,000 ____________________________ 206 49006 01 365.00 Worker's Compensation Insurance 112,964 112,534 131,630 114,000 135,000 Annual Premium 206 49006 01 369.00 Other Insurance 89,163 98,607 108,529 100,000 110,000 Annual Premium-General Liability (Changed to High Deductible) 206 49006 01 403.00 Contracted R & M-Other Impr.0 20,332 5,533 0 0 Liability & Auto Deductible Pymts 206 49006 01 409.00 Other Contracted Repair & Maint 65,465 274,248 73,694 70,000 75,000 Liability & Auto Deductible Pymts 206 49006 01 439.00 Other Miscellaneous Charges 0 0 0 0 0 ____________________________ 206 49006 01 550.00 Motor Vehicle Purchases 37,176 21,730 0 0 0 2013 & 2014 - Replace Vehicle ------------------------------------------------------------------------------------------ FUND TOTALS 338,072 561,381 354,284 318,600 355,000 (Changed to High Deductible) ================================================ NOTE:Levy of $260,000 covers costs for all insurance premiums and some of the general liability payments (changed to high deductible plan for 2011). All other expenditures covered through a combination of tax levies, interest earnings, insurance refunds/dividends and reserve funds. Page 71 of 105 PORT AUTHORITY GENERAL / ADMINISTRATIVE •The Rosemount Port Authority is the successor to the Rosemount Housing and Redevelopment Authority (HRA) and the Rosemount Economic Development Authority (EDA). As such, the Port Authority is responsible for both redevelopment and economic development activities in the City. •The Port Authority concentrates much of its activity on the development of the Rosemount Business Park and on the redevelopment of downtown Rosemount. It also coordinates development opportunities with the University of Minnesota. •The Port Authority will continue to work on other development and redevelopment projects related to commercial and industrial development, including but not limited to, a new hotel and additional retailing opportunities on lands designated for commercial use. Page 72 of 105 Page One 2017 BUDGET WORKSHEETS PORT AUTHORITY - REVENUES September 20, 2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ 201 31010.00 Current Ad Valorem Taxes $58,000 $58,000 $58,000 $58,000 $58,000 Operating Levy 201 31050.00 Tax Increments 0 0 0 0 0 Admin Fees Portion Only 201 32280.00 Fiber License Fees 0 0 0 2,400 2,400 ____________________________ 201 33130.00 Federal Grants-CDBG 0 0 0 0 0 ____________________________ 201 33425.00 Other State Grants & Aids 0 734,060 287,090 0 0 LCA Grant-Land/Bldg Acquisition 201 33620.00 Other County Grants & Aids 0 6,600 0 0 0 Dakota Cty-South Gateway 201 34109.00 Other Charges for Services 0 0 0 0 0 Genz-Ryan Tenant Utility Pymts 201 36210.00 Interest Earnings - Investments 50 49 74 100 100 Interest Earned on CD's 201 36215.00 Interest Earnings 35 33 58 100 100 Checking Interest & Misc 201 36230.00 Contributions/Donations 0 0 0 0 0 ____________________________ 201 36260.00 Other Revenue 0 763 0 0 0 ____________________________ 201 36265.00 Use of Reserve Funds 0 0 0 14,000 0 ____________________________ 201 39101.00 Sales of General Fixed Assets 0 0 0 0 0 ____________________________ ------------------------------------------------------------------------------------------ FUND TOTALS $58,086 $799,505 $345,222 $74,600 $60,600 ====================================================== EXPENDITURES 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ All Salary Costs Inclusive of Salary, Taxes, PERA & Benefits 201 46300 01 103.00 Part-Time Salaries & Benefits $6,079 $5,511 $11,171 $0 $0 Part-Time Intern 201 46300 99 103.00 Part-Time Salaries & Benefits 2,509 2,305 3,008 4,000 4,000 Port Authority Members 201 46300 01 303.00 Engineering Fees 0 0 0 2,000 2,000 ____________________________ 201 46300 01 304.00 Legal Fees 1,645 8,422 4,912 3,000 5,000 ____________________________ 201 46300 01 317.00 General Fund Administrative Fees 6,000 6,000 6,000 6,000 6,000 Yearly Fee Per Policy F-3 201 46300 01 319.00 Other Professional Services 19,000 ____________________________ 201 46300 01 319.01 Project Management Consultant 0 0 0 2,000 2,000 ____________________________ 201 46300 01 319.02 Marketing - REDE - City Share 10,020 10,000 14,373 10,000 10,000 Twin Cities Marketing Initiative 201 46300 01 319.03 County TIF Charges 0 0 0 0 0 Moved to TIF Fund 201 46300 01 319.04 P/A Property Tax Payments 0 0 0 0 0 ____________________________ 201 46300 01 319.05 Other Consultants 0 0 0 5,400 7,000 Downtown Update 201 46300 01 319.06 South Gateway Study 0 11,553 0 0 0 Dakota Cty-South Gateway 201 46300 01 319.07 Buxton Project 0 16,667 16,667 17,000 0 ____________________________ 201 46300 01 322.00 Postage Costs 446 0 0 0 0 ____________________________ 201 46300 01 331.00 Travel Expense 0 0 0 0 0 ____________________________ 201 46300 01 349.00 Other Advertising 7,094 9,216 14,217 10,000 12,000 Additional Marketing 201 46300 01 359.00 Other Printing & Binding Costs 0 902 100 3,000 1,500 ____________________________ 201 46300 01 365.00 Workers Comp Insurance 540 530 604 500 700 Commissioners 201 46300 01 369.00 Other Insurance 394 409 440 2,000 500 Property Insurance 201 46300 01 381.00 Electric Utilities 309 190 130 500 400 Business Park & Other Properties 201 46300 01 383.00 Gas Utilities 0 0 0 0 0 Other Properties 201 46300 01 389.00 Other Utility Services 0 0 0 0 0 Utility Fees 201 46300 01 403.00 Contracted Repairs & Maintenance 0 0 0 2,000 2,000 Contracts for Fiber 201 46300 01 433.00 Dues & Subscriptions 2,000 Prof Organizations/Journals 201 46300 01 433.01 Professional Organizations/Journa 1,806 2,088 2,392 1,700 2,000 ____________________________ 201 46300 01 433.02 Foreign Trade Zone Commission 0 0 0 0 0 ____________________________ 201 46300 01 437.00 Conferences & Seminars 4,249 1,277 7,349 5,000 5,000 Development/TIF/Miscellaneous 201 46300 01 439.00 Other Miscellaneous Charges 434 172 0 500 500 Contingencies 201 46300 01 521.00 Building & Structure Purchases 0 0 0 0 0 ____________________________ 201 46300 01 525.00 Building & Structure Purchases 0 652,781 287,090 0 0 LCA Grant-Land/Bldg Acquisition 201 46300 01 530.00 Improvements Other Than Bldgs 0 0 0 0 0 ____________________________ 201 46300 01 710.00 Transfers 0 0 86,437 0 0 ____________________________ ------------------------------------------------------------------------------------------ FUND TOTALS $41,525 $728,022 $454,890 $74,600 $60,600 ====================================================== Page 73 of 105 Page One 2017 BUDGET WORKSHEETS DOWNTOWN/BROCKWAY DISTRICT(0108) - REVENUES September 20, 2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 242 31010.00 Current Ad Valorem Taxes $0 $0 $0 $0 $0 MVHC Payments 242 31050.00 Tax Increments 660,130 646,636 720,963 670,000 800,000 __________________________ 242 33400.00 State Grants & Aids 0 0 0 0 0 __________________________ 242 33425.00 Other State Grants & Aids 0 0 0 0 0 __________________________ 242 33620.00 Other County Grants & Aids 0 0 0 0 0 __________________________ 242 36210.00 Interest Earnings - Investments 826 645 978 800 800 __________________________ 242 36215.00 Interest Earnings 14 83 139 0 0 __________________________ 242 36220.00 Rents & Royalties 0 0 0 0 0 __________________________ 242 36230.00 Other Revenue 0 0 0 0 0 __________________________ 242 36260.00 Contribution/Donation-Private 0 0 0 0 0 __________________________ 242 39101.00 Sale of General Fixed Assets 0 283,045 15,000 0 0 __________________________ 242 39310.00 Bond Proceeds 0 0 0 0 0 __________________________ ------------------------------------------------------------------------------------------------ FUND TOTALS $660,971 $930,409 $737,080 $670,800 $800,800 =================================================== EXPENDITURES 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 242 49042 01 303.00 Engineering Fees $0 $0 $0 $0 $0 __________________________ 242 49042 01 304.00 Legal Fees 0 0 0 0 0 __________________________ 242 49042 01 319.00 Other Professional Services 16,516 12,942 14,919 15,000 15,000 County TIF Charges 242 49042 01 522.00 Building & Structure Purchases 0 40,278 0 0 0 CDA-Dahn Property Purchase 242 49042 01 530.00 Improvements Other Than Buildings 0 0 0 0 0 __________________________ 242 49042 01 533.00 Improvements Other Than Buildings 0 0 0 0 0 __________________________ 242 49042 01 536.00 Improvements Other Than Buildings 0 170,062 0 0 0 Fiber in Business Park 242 49042 01 538.00 Improvements Other Than Buildings 0 206,434 0 0 0 TH 3 Turn Lane Improvements 242 49042 01 601.00 Principal on Waterford PAYG 52,953 64,515 69,168 77,000 71,300 Waterford Pay-As-You-Go 242 49042 01 611.00 Interest on Waterford PAYG 84,179 81,453 78,081 74,400 72,000 Waterford Pay-As-You-Go 242 49042 01 710.00 Transfers 400,000 400,000 450,000 500,000 550,000 P & I for 2008A & 2008B Issues ------------------------------------------------------------------------------------------------ FUND TOTALS $553,647 $975,684 $612,168 $666,400 $708,300 =================================================== Page 74 of 105 DEBT SERVICE FUNDS GENERAL / ADMINISTRATIVE •Debt Service Funds are Governmental Funds set up to provide for the repayment of debt of the City. This debt is normally accomplished through the issuance of bonds secured by the full faith and credit of the City. Repayment of the debt is usually accomplished through the collection of special assessments; general levies of the City collected through property taxes; tax increment funds; core funds; transfers from Enterprise Funds (Revenue Debt Issues) and transfers from other areas. Page 75 of 105 Page One 2017 BUDGET WORKSHEETS DEBT SERV FUND 326 - G.O. IMPROVEMENT BONDS, 2006B - REVENUES - September 20, 2016 2016 2017 2013 2014 2015 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 326 31010.00 Current Ad Valorem Taxes $0 $0 $0 $0 $0 __________________________ 326 36101.00 Principal - Special Assessments 284,172 42,293 28,155 0 0 __________________________ 326 36102.00 Penalties & Interest - S/A 1,532 55,828 60 0 0 __________________________ 326 36210.00 Interest Earnings - Investments 3,438 3,319 3,377 0 0 __________________________ 326 36215.00 Interest Earnings 10 29 13 0 0 __________________________ 326-36260.00 Other Revenue 18,863 0 0 0 0 __________________________ 326 36265.00 Use of Reserve Funds 0 0 0 243,000 469,700 __________________________ 326 37145.00 Surcharge on Water Revenues 0 0 0 0 0 __________________________ 326 37160.00 Penalties - Surcharge Revenues 0 0 0 0 0 __________________________ 326 39201.00 Transfer From General Fund 0 0 0 0 0 __________________________ 326 39202.00 Contribution From Enterprises 200,000 200,000 0 0 0 __________________________ 326 39203.00 Transfer From________________0 3,306 0 0 0 __________________________ 326 39204.00 Transfer From Water Core 0 0 200,000 240,000 0 __________________________ 326 39205.00 Transfer From Sewer Core 0 0 0 0 0 __________________________ 326 39206.00 Transfer From Storm Core 0 0 0 0 0 __________________________ 326 39208.00 Transfer From Street CIP 0 0 0 0 0 __________________________ 326 39310.00 Bond Proceeds 0 0 0 0 0 __________________________ ------------------------------------------------------------------------------------- FUND TOTALS $508,015 $304,775 $231,605 $483,000 $469,700 ============================================= - EXPENDITURES - 2016 2017 2013 2014 2015 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 326 47000 01 317.00 General Fund Admin Fees $0 $0 $0 $0 $0 __________________________ 326 47000 01 319.00 Other Professional Services 0 0 0 0 0 __________________________ 326 47000 01 601.00 Bond Principal 440,000 445,000 450,000 455,000 460,000 __________________________ 326 47000 01 611.00 Bond Interest 81,200 63,500 45,600 27,500 9,200 __________________________ 326 47000 01 621.00 Bond Paying Agent Fees 431 450 450 500 500 __________________________ 326 47000 01 710.00 Transfers 0 0 0 0 0 __________________________ ------------------------------------------------------------------------------------- FUND TOTALS $521,631 $508,950 $496,050 $483,000 $469,700 ============================================= Page 76 of 105 Page One 2017 BUDGET WORKSHEETS DEBT SERV FUND 611 - G.O. WATER REVENUE BONDS, 2007A - REVENUES - September 20, 2016 2016 2017 2013 2014 2015 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 611 31010.00 Current Ad Valorem Taxes $0 $0 $0 $0 $0 __________________________ 611 36101.00 Principal - Special Assessments 0 0 0 0 0 __________________________ 611 36102.00 Penalties & Interest - S/A 0 0 0 0 0 __________________________ 611 36210.00 Interest Earnings - Investments 88 87 86 0 0 __________________________ 611 36215.00 Interest Earnings 2 4 10 0 0 __________________________ 611 36265.00 Use of Reserve Funds 0 0 0 0 34,100 __________________________ 611 37145.00 Surcharge on Water Revenues 0 0 0 0 0 __________________________ 611 37160.00 Penalties - Surcharge Revenues 0 0 0 0 0 __________________________ 611 39201.00 Transfer From General Fund 0 0 0 0 0 __________________________ 611 39202.00 Contribution From Enterprises 0 0 0 0 0 __________________________ 611 39203.00 Transfer From________________0 0 0 0 0 __________________________ 611 39204.00 Transfer From Water Core 150,000 150,000 150,000 150,000 115,000 __________________________ 611 39205.00 Transfer From Sewer Core 0 0 0 0 0 __________________________ 611 39206.00 Transfer From Storm Core 0 0 0 0 0 __________________________ 611 39207.00 Transfer From Port Authority 0 0 0 0 0 __________________________ 611 39310.00 Bond Proceeds 0 0 0 0 0 __________________________ ------------------------------------------------------------------------------------- FUND TOTALS $150,090 $150,091 $150,097 $150,000 $149,100 ============================================= - EXPENDITURES - 2016 2017 2013 2014 2015 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 611 47000 01 317.00 General Fund Admin Fees $0 $0 $0 $0 $0 __________________________ 611 47000 01 319.00 Other Professional Services 0 0 0 0 0 __________________________ 611 47000 01 601.00 Bond Principal 120,000 125,000 130,000 135,000 140,000 __________________________ 611 47000 01 611.00 Bond Interest 27,400 22,417 17,233 14,100 8,600 __________________________ 611 47000 01 614.00 Amortization of Bond Discount (2,422)0 0 400 0 __________________________ 611 47000 01 621.00 Bond Paying Agent Fees 3,986 450 450 500 500 __________________________ 611 47000 01 710.00 Transfers 0 0 0 0 0 __________________________ ------------------------------------------------------------------------------------- FUND TOTALS $148,965 $147,867 $147,683 $150,000 $149,100 ============================================= Page 77 of 105 Page One 2017 BUDGET WORKSHEETS DEBT SERV FUND 381 - G.O. TAXABLE TIF 2008A & G.O. TIF 2008B - REVENUES - September 20, 2016 2016 2017 2013 2014 2015 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 381 31010.00 Current Ad Valorem Taxes $0 $0 $0 $0 $0 __________________________ 381 31050.00 Tax Increments 0 0 0 0 0 381 36101.00 Principal - Special Assessments 0 0 0 0 0 __________________________ 381 36102.00 Penalties & Interest - S/A 0 0 0 0 0 __________________________ 381 36210.00 Interest Earnings - Investments 125 54 105 0 0 __________________________ 381 36215.00 Interest Earnings 14 17 153 0 0 __________________________ 381 36265.00 Use of Reserve Funds 0 0 0 0 0 __________________________ 381 37145.00 Surcharge on Water Revenues 0 0 0 0 0 __________________________ 381 37160.00 Penalties - Surcharge Revenues 0 0 0 0 0 __________________________ 381 39201.00 Transfer From General Fund 0 0 0 0 0 __________________________ 381 39202.00 Contribution From Enterprises 0 0 0 0 0 __________________________ 381 39203.00 Transfer From________________0 0 0 0 0 __________________________ 381 39204.00 Transfer From Water Core 0 0 0 0 0 __________________________ 381 39205.00 Transfer From Sewer Core 0 0 0 0 0 __________________________ 381 39206.00 Transfer From Storm Core 0 0 0 0 0 __________________________ 381 39207.00 Transfer From Port Authority 400,000 400,000 450,000 500,000 500,000 __________________________ 381 39310.00 Bond Proceeds 0 0 0 0 0 __________________________ ------------------------------------------------------------------------------------- FUND TOTALS $400,139 $400,071 $450,258 $500,000 $500,000 ============================================= - EXPENDITURES - 2016 2017 2013 2014 2015 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 381 47000 01 317.00 General Fund Admin Fees $0 $0 $0 $0 $0 __________________________ 381 47000 01 319.00 Other Professional Services 0 0 0 0 0 __________________________ 381 47000 01 601.00 Bond Principal 75,000 110,000 150,000 195,000 230,000 __________________________ 381 47000 01 611.00 Bond Interest 273,010 268,385 261,885 253,300 242,800 __________________________ 381 47000 01 621.00 Bond Paying Agent Fees 850 900 900 900 900 __________________________ 381 47000 01 710.00 Transfers 0 0 0 0 0 __________________________ ------------------------------------------------------------------------------------- FUND TOTALS $348,860 $379,285 $412,785 $449,200 $473,700 ============================================= Page 78 of 105 Page One 2017 BUDGET WORKSHEETS DEBT SERV FUND 614 - G.O. UTILITY REVENUE REFUNDING BONDS, 2010A (2001B, 2002B & 2003B) - REVENUES - September 20, 2016 2016 2017 2013 2014 2015 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 614 31010.00 Current Ad Valorem Taxes $0 $0 $0 $0 $0 __________________________ 614 36101.00 Principal - Special Assessments 773 0 0 0 0 __________________________ 614 36102.00 Penalties & Interest - S/A 1 0 0 0 0 __________________________ 614 36210.00 Interest Earnings - Investments 441 180 420 0 0 __________________________ 614 36215.00 Interest Earnings 2 3 10 0 0 __________________________ 614 36265.00 Use of Reserve Funds 0 0 0 0 60,300 __________________________ 614 37145.00 Surcharge on Water Revenues 0 0 0 0 0 __________________________ 614 37160.00 Penalties - Surcharge Revenues 0 0 0 0 0 __________________________ 614 39201.00 Transfer From General Fund 0 0 0 0 0 __________________________ 614 39202.00 Contribution From Enterprises 89,000 87,000 51,000 51,000 32,000 __________________________ 614 39203.00 Transfer From________________0 0 0 0 0 __________________________ 614 39204.00 Transfer From Water Core 155,000 152,000 90,000 88,000 56,000 __________________________ 614 39205.00 Transfer From Sewer Core 0 0 0 0 0 __________________________ 614 39206.00 Transfer From Storm Core 89,000 87,000 51,000 51,000 32,000 __________________________ 614 39207.00 Transfer From Port Authority 0 0 0 0 0 __________________________ 614 39310.00 Bond Proceeds 0 0 0 0 0 __________________________ ------------------------------------------------------------------------------------- FUND TOTALS $334,217 $326,182 $192,430 $190,000 $180,300 ============================================= - EXPENDITURES - 2016 2017 2013 2014 2015 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 614 47000 01 317.00 General Fund Admin Fees $0 $0 $0 $0 $0 __________________________ 614 47000 01 319.00 Other Professional Services 0 0 0 0 0 __________________________ 614 47000 01 601.00 Bond Principal 310,000 310,000 175,000 180,000 175,000 __________________________ 614 47000 01 611.00 Bond Interest 17,725 13,591 10,596 8,600 4,800 __________________________ 614 47000 01 614.00 Amortization of Bond Discount 1,340 0 0 900 0 __________________________ 614 47000 01 621.00 Bond Paying Agent Fees 11,481 425 450 500 500 __________________________ 614 47000 01 710.00 Transfers 0 0 0 0 0 __________________________ ------------------------------------------------------------------------------------- FUND TOTALS $340,546 $324,016 $186,046 $190,000 $180,300 ============================================= Page 79 of 105 Page One 2017 BUDGET WORKSHEETS DEBT SERV FUND 383 - G.O. PORT AUTHORITY PUBLIC FACILITY REFUNDING BONDS, 2010B (2001C) - REVENUES - September 20, 2016 2016 2017 2013 2014 2015 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 383 31010.00 Current Ad Valorem Taxes $165,383 $163,611 $161,446 $169,321 $166,060 __________________________ 383 36101.00 Principal - Special Assessments 0 0 0 0 0 __________________________ 383 36102.00 Penalties & Interest - S/A 0 0 0 0 0 __________________________ 383 36210.00 Interest Earnings - Investments 398 483 931 0 0 __________________________ 383 36215.00 Interest Earnings 8 11 22 0 0 __________________________ 383 36260.00 Other Revenue 0 0 0 0 0 __________________________ 383 36265.00 Use of Reserve Funds 0 0 0 0 0 __________________________ 383 37145.00 Surcharge on Water Revenues 0 0 0 0 0 __________________________ 383 39101.00 Sale of General Fixed Assets 0 0 0 0 0 __________________________ 383 39201.00 Transfer From General Fund 0 0 0 0 0 __________________________ 383 39202.00 Contribution From Enterprises 0 0 0 0 0 __________________________ 383 39203.00 Transfer From________________0 0 0 0 0 __________________________ 383 39204.00 Transfer From Water Core 0 0 0 0 0 __________________________ 383 39205.00 Transfer From Sewer Core 0 0 0 0 0 __________________________ 383 39206.00 Transfer From Storm Core 0 0 0 0 0 __________________________ 383 39207.00 Transfer From Port Authority 0 0 0 0 0 __________________________ 383 39310.00 Bond Proceeds 0 0 0 0 0 __________________________ ------------------------------------------------------------------------------------- FUND TOTALS $165,789 $164,105 $162,400 $169,321 $166,060 ============================================= - EXPENDITURES - 2016 2017 2013 2014 2015 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 383 47000 01 317.00 General Fund Admin Fees $0 $0 $0 $0 $0 __________________________ 383 47000 01 319.00 Other Professional Services 0 0 0 0 0 __________________________ 383 47000 01 601.00 Bond Principal 125,000 125,000 125,000 125,000 135,000 __________________________ 383 47000 01 611.00 Bond Interest 33,226 31,664 29,789 27,600 24,800 __________________________ 383 47000 01 621.00 Bond Paying Agent Fees 425 425 450 500 500 __________________________ 383 47000 01 710.00 Transfers 0 0 0 0 0 __________________________ ------------------------------------------------------------------------------------- FUND TOTALS $158,651 $157,089 $155,239 $153,100 $160,300 ============================================= Page 80 of 105 Page One 2017 BUDGET WORKSHEETS DEBT SERV FUND 327 - G.O. IMPROVEMENT BONDS, 2011A - REVENUES - September 20, 2016 2016 2017 2013 2014 2015 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 327 31010.00 Current Ad Valorem Taxes $0 $0 $0 $0 $0 __________________________ 327 36101.00 Principal - Special Assessments 351,197 89,159 92,533 0 0 __________________________ 327 36102.00 Penalties & Interest - S/A 132 0 0 0 0 __________________________ 327 36210.00 Interest Earnings - Investments 580 501 348 0 0 __________________________ 327 36215.00 Interest Earnings 22 25 13 0 0 __________________________ 327 36265.00 Use of Reserve Funds 0 0 0 428,700 428,400 __________________________ 327 37145.00 Surcharge on Water Revenues 0 0 0 0 0 __________________________ 327 37160.00 Penalties - Surcharge Revenues 0 0 0 0 0 __________________________ 327 39201.00 Transfer From General Fund 0 0 0 0 0 __________________________ 327 39202.00 Contribution From Enterprises 0 0 0 0 0 __________________________ 327 39203.00 Transfer From________________232,094 0 0 0 0 __________________________ 327 39204.00 Transfer From Water Core 0 0 0 0 0 __________________________ 327 39205.00 Transfer From Sewer Core 0 0 0 0 0 __________________________ 327 39206.00 Transfer From Storm Core 0 0 0 0 0 __________________________ 327 39208.00 Transfer From Street CIP 0 0 0 0 0 __________________________ 327 39310.00 Bond Proceeds 0 0 0 0 0 __________________________ ------------------------------------------------------------------------------------- FUND TOTALS $584,024 $89,685 $92,894 $428,700 $428,400 ============================================= - EXPENDITURES - 2016 2017 2013 2014 2015 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 327 47000 01 317.00 General Fund Admin Fees $0 $0 $0 $0 $0 __________________________ 327 47000 01 319.00 Other Professional Services 0 0 0 0 0 __________________________ 327 47000 01 601.00 Bond Principal 405,000 415,000 415,000 420,000 425,000 __________________________ 327 47000 01 611.00 Bond Interest 17,704 15,548 12,435 8,200 2,900 __________________________ 327 47000 01 621.00 Bond Paying Agent Fees 425 450 450 500 500 __________________________ 327 47000 01 710.00 Transfers 0 0 0 0 0 __________________________ ------------------------------------------------------------------------------------- FUND TOTALS $423,129 $430,998 $427,885 $428,700 $428,400 ============================================= Page 81 of 105 Page One 2017 BUDGET WORKSHEETS DEBT SERV FUND 328 - G.O. IMPROVEMENT BONDS, 2012A - REVENUES - September 20, 2016 2016 2017 2013 2014 2015 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 328 31010.00 Current Ad Valorem Taxes $0 $0 $0 $0 $0 __________________________ 328 36101.00 Principal - Special Assessments 653,112 149,797 21,314 0 0 __________________________ 328 36102.00 Penalties & Interest - S/A 0 0 0 0 0 __________________________ 328 36210.00 Interest Earnings - Investments 147 235 536 0 0 __________________________ 328 36215.00 Interest Earnings 30 23 13 0 0 __________________________ 328 36265.00 Use of Reserve Funds 0 0 0 169,000 167,900 __________________________ 328 37145.00 Surcharge on Water Revenues 0 0 0 0 0 __________________________ 328 37160.00 Penalties - Surcharge Revenues 0 0 0 0 0 __________________________ 328 39201.00 Transfer From General Fund 0 0 0 0 0 __________________________ 328 39202.00 Contribution From Enterprises 0 0 0 0 0 __________________________ 328 39203.00 Transfer From________________0 0 0 0 0 __________________________ 328 39204.00 Transfer From Water Core 0 0 0 0 0 __________________________ 328 39205.00 Transfer From Sewer Core 0 0 0 0 0 __________________________ 328 39206.00 Transfer From Storm Core 0 0 0 0 0 __________________________ 328 39208.00 Transfer From Street CIP 0 0 0 0 0 __________________________ 328 39310.00 Bond Proceeds 0 0 0 0 0 __________________________ ------------------------------------------------------------------------------------- FUND TOTALS $653,290 $150,055 $21,863 $169,000 $167,900 ============================================= - EXPENDITURES - 2016 2017 2013 2014 2015 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 328 47000 01 317.00 General Fund Admin Fees $0 $0 $0 $0 $0 __________________________ 328 47000 01 319.00 Other Professional Services 0 0 0 0 0 __________________________ 328 47000 01 601.00 Bond Principal 0 155,000 160,000 165,000 165,000 __________________________ 328 47000 01 611.00 Bond Interest 4,932 5,070 4,360 3,500 2,400 __________________________ 328 47000 01 621.00 Bond Paying Agent Fees 425 450 450 500 500 __________________________ 328 47000 01 710.00 Transfers 0 0 0 0 0 __________________________ ------------------------------------------------------------------------------------- FUND TOTALS $5,357 $160,520 $164,810 $169,000 $167,900 ============================================= Page 82 of 105 Page One 2017 BUDGET WORKSHEETS DEBT SERV FUND 329 - G.O. IMPROVEMENT BONDS, 2013A - REVENUES - September 20, 2016 2016 2017 2013 2014 2015 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 329 31010.00 Current Ad Valorem Taxes $0 $0 $0 $0 $0 __________________________ 329 36101.00 Principal - Special Assessments 0 1,187,907 296,208 0 0 __________________________ 329 36102.00 Penalties & Interest - S/A 277 3,300 0 0 0 __________________________ 329 36210.00 Interest Earnings - Investments 0 197 1,509 0 0 __________________________ 329 36215.00 Interest Earnings 23 52 67 0 0 __________________________ 329 36265.00 Use of Reserve Funds 0 0 0 308,800 311,300 __________________________ 329 37145.00 Surcharge on Water Revenues 0 0 0 0 0 __________________________ 329 37160.00 Penalties - Surcharge Revenues 0 0 0 0 0 __________________________ 329 39201.00 Transfer From General Fund 0 0 0 0 0 __________________________ 329 39202.00 Contribution From Enterprises 0 0 0 0 0 __________________________ 329 39203.00 Transfer From________________0 0 136,728 0 0 __________________________ 329 39204.00 Transfer From Water Core 0 0 0 0 0 __________________________ 329 39205.00 Transfer From Sewer Core 0 0 0 0 0 __________________________ 329 39206.00 Transfer From Storm Core 0 0 0 0 0 __________________________ 329 39208.00 Transfer From Street CIP 0 0 0 0 0 __________________________ 329 39310.00 Bond Proceeds 5,625 0 0 0 0 __________________________ ------------------------------------------------------------------------------------- FUND TOTALS $5,926 $1,191,457 $434,513 $308,800 $311,300 ============================================= - EXPENDITURES - 2016 2017 2013 2014 2015 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 329 47000 01 317.00 General Fund Admin Fees $0 $0 $0 $0 $0 __________________________ 329 47000 01 319.00 Other Professional Services 0 0 0 0 0 __________________________ 329 47000 01 601.00 Bond Principal 0 0 290,000 295,000 300,000 __________________________ 329 47000 01 611.00 Bond Interest 0 13,123 15,023 13,300 10,800 __________________________ 329 47000 01 621.00 Bond Paying Agent Fees 0 425 425 500 500 __________________________ 329 47000 01 710.00 Transfers 0 0 0 0 0 __________________________ ------------------------------------------------------------------------------------- FUND TOTALS $0 $13,548 $305,448 $308,800 $311,300 ============================================= Page 83 of 105 Page One 2017 BUDGET WORKSHEETS DEBT SERV FUND 330 - G.O. IMPROVEMENT BONDS, 2014A - REVENUES - September 20, 2016 2016 2017 2013 2014 2015 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 330 31010.00 Current Ad Valorem Taxes $0 $0 $0 $0 $0 __________________________ 330 36101.00 Principal - Special Assessments 0 0 1,194,295 0 0 __________________________ 330 36102.00 Penalties & Interest - S/A 0 169 197 0 0 __________________________ 330 36210.00 Interest Earnings - Investments 0 5 167 0 0 __________________________ 330 36215.00 Interest Earnings 0 4 155 0 0 __________________________ 330 36265.00 Use of Reserve Funds 0 0 0 405,300 351,600 __________________________ 330 37145.00 Surcharge on Water Revenues 0 0 0 0 0 __________________________ 330 37160.00 Penalties - Surcharge Revenues 0 0 0 0 0 __________________________ 330 39201.00 Transfer From General Fund 0 0 0 0 0 __________________________ 330 39202.00 Contribution From Enterprises 0 0 0 0 0 __________________________ 330 39203.00 Transfer From________________0 0 0 0 0 __________________________ 330 39204.00 Transfer From Water Core 0 0 65,000 0 67,000 __________________________ 330 39205.00 Transfer From Sewer Core 0 0 0 0 0 __________________________ 330 39206.00 Transfer From Storm Core 0 0 0 0 0 __________________________ 330 39208.00 Transfer From Street CIP 0 0 0 0 0 __________________________ 330 39310.00 Bond Proceeds 0 1,421 0 0 0 __________________________ ------------------------------------------------------------------------------------- FUND TOTALS $0 $1,599 $1,259,814 $405,300 $418,600 ============================================= - EXPENDITURES - 2016 2017 2013 2014 2015 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 330 47000 01 317.00 General Fund Admin Fees $0 $0 $0 $0 $0 __________________________ 330 47000 01 319.00 Other Professional Services 0 0 0 0 0 __________________________ 330 47000 01 601.00 Bond Principal 0 0 0 380,000 395,000 __________________________ 330 47000 01 611.00 Bond Interest 0 0 20,144 24,800 23,100 __________________________ 330 47000 01 621.00 Bond Paying Agent Fees 0 0 450 500 500 __________________________ 330 47000 01 710.00 Transfers 0 0 0 0 0 __________________________ ------------------------------------------------------------------------------------- FUND TOTALS $0 $0 $20,594 $405,300 $418,600 ============================================= Page 84 of 105 Page One 2017 BUDGET WORKSHEETS DEBT SERV FUND 612 - G.O. UTILITY REVENUE BONDS, 2015A - REVENUES - September 20, 2016 2016 2017 2013 2014 2015 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 612 31010.00 Current Ad Valorem Taxes $0 $0 $0 $0 $0 __________________________ 612 36101.00 Principal - Special Assessments 0 0 0 0 0 __________________________ 612 36102.00 Penalties & Interest - S/A 0 0 0 0 0 __________________________ 612 36210.00 Interest Earnings - Investments 0 0 0 0 0 __________________________ 612 36215.00 Interest Earnings 0 0 0 0 0 __________________________ 612 36265.00 Use of Reserve Funds 0 0 0 0 0 __________________________ 612 37145.00 Surcharge on Water Revenues 0 0 0 0 0 __________________________ 612 37160.00 Penalties - Surcharge Revenues 0 0 0 0 0 __________________________ 612 39201.00 Transfer From General Fund 0 0 0 0 0 __________________________ 612 39202.00 Contribution From Enterprises 0 0 0 0 0 __________________________ 612 39203.00 Transfer From________________0 0 0 0 0 __________________________ 612 39204.00 Transfer From Water Core 0 0 0 30,000 170,000 __________________________ 612 39205.00 Transfer From Sewer Core 0 0 0 0 0 __________________________ 612 39206.00 Transfer From Storm Core 0 0 0 0 0 __________________________ 612 39207.00 Transfer From Port Authority 0 0 0 0 0 __________________________ 612 39310.00 Bond Proceeds 0 0 0 0 0 __________________________ ------------------------------------------------------------------------------------- FUND TOTALS $0 $0 $0 $30,000 $170,000 ============================================= - EXPENDITURES - 2016 2017 2013 2014 2015 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 612 47000 01 317.00 General Fund Admin Fees $0 $0 $0 $0 $0 __________________________ 612 47000 01 319.00 Other Professional Services 0 0 3,342 0 0 __________________________ 612 47000 01 601.00 Bond Principal 0 0 0 0 130,000 __________________________ 612 47000 01 611.00 Bond Interest 0 0 0 26,800 37,300 __________________________ 612 47000 01 614.00 Amortization of Bond Discount 0 0 0 0 0 __________________________ 612 47000 01 621.00 Bond Paying Agent Fees 0 0 0 500 500 __________________________ 612 47000 01 710.00 Transfers 0 0 0 0 0 __________________________ ------------------------------------------------------------------------------------- FUND TOTALS $0 $0 $3,342 $27,300 $167,800 ============================================= Page 85 of 105 Page One 2017 BUDGET WORKSHEETS DEBT SERV FUND 384 - G.O. PORT AUTHORITY TAX INCREMENT REFUNDING BONDS, 2015A (2008B) - REVENUES - September 20, 2016 2016 2017 2013 2014 2015 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 384 31010.00 Current Ad Valorem Taxes $0 $0 $0 $0 $0 __________________________ 384 36101.00 Principal - Special Assessments 0 0 0 0 0 __________________________ 384 36210.00 Interest Earnings - Investments 0 0 0 0 0 __________________________ 384 36214.00 Net Change in FV-Investments 0 0 (19,097)0 0 __________________________ 384 36215.00 Interest Earnings 0 0 7 0 0 __________________________ 384 36260.00 Other Revenue 0 0 0 0 0 __________________________ 384 36265.00 Use of Reserve Funds 0 0 0 63,300 90,400 Paid from Escrow Fund 384 37145.00 Surcharge on Water Revenues 0 0 0 0 0 __________________________ 384 39101.00 Sale of General Fixed Assets 0 0 0 0 0 __________________________ 384 39201.00 Transfer From General Fund 0 0 0 0 0 __________________________ 384 39202.00 Contribution From Enterprises 0 0 0 0 0 __________________________ 384 39203.00 Transfer From________________0 0 0 0 0 __________________________ 384 39204.00 Transfer From Water Core 0 0 0 0 0 __________________________ 384 39205.00 Transfer From Sewer Core 0 0 0 0 0 __________________________ 384 39206.00 Transfer From Storm Core 0 0 0 0 0 __________________________ 384 39207.00 Transfer From Port Authority 0 0 0 0 0 __________________________ 384 39310.00 Bond Proceeds 0 0 3,436,436 0 0 __________________________ ------------------------------------------------------------------------------------- FUND TOTALS $0 $0 $3,417,345 $63,300 $90,400 ============================================= - EXPENDITURES - 2016 2017 2013 2014 2015 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 384 47000 01 317.00 General Fund Admin Fees $0 $0 $0 $0 $0 __________________________ 384 47000 01 319.00 Other Professional Services 0 0 67,045 0 0 __________________________ 384 47000 01 601.00 Bond Principal 0 0 0 0 0 __________________________ 384 47000 01 611.00 Bond Interest 0 0 0 63,300 90,400 Paid from Escrow Fund 384 47000 01 621.00 Bond Paying Agent Fees 0 0 0 0 0 __________________________ 384 47000 01 710.00 Transfers 0 0 0 0 0 __________________________ ------------------------------------------------------------------------------------- FUND TOTALS $0 $0 $67,045 $63,300 $90,400 ============================================= Page 86 of 105 Page One 2017 BUDGET WORKSHEETS DEBT SERV FUND 302 - G.O. CAPITAL IMPROVEMENT PLAN (CIP) REFUNDING BONDS, 2015B (Old 2005A) - REVENUES - September 20, 2016 2016 2017 2013 2014 2015 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 302 31010.00 Current Ad Valorem Taxes $0 $0 $0 $178,553 $179,996 __________________________ 302 36101.00 Principal - Special Assessments 0 0 0 0 0 __________________________ 302 36102.00 Penalties & Interest - S/A 0 0 0 0 0 __________________________ 302 36210.00 Interest Earnings - Investments 0 0 0 0 0 __________________________ 302 36215.00 Interest Earnings 0 0 6 0 0 __________________________ 302 36265.00 Use of Reserve Funds 0 0 0 0 0 __________________________ 302 37145.00 Surcharge on Water Revenues 0 0 0 0 0 __________________________ 302 37160.00 Penalties - Surcharge Revenues 0 0 0 0 0 __________________________ 302 39201.00 Transfer From General Fund 0 0 0 0 0 __________________________ 302 39202.00 Contribution From Enterprises 0 0 0 0 0 __________________________ 302 39203.00 Transfer From________________0 0 0 0 0 __________________________ 302 39204.00 Transfer From Water Core 0 0 0 0 0 __________________________ 302 39205.00 Transfer From Sewer Core 0 0 0 0 0 __________________________ 302 39206.00 Transfer From Storm Core 0 0 0 0 0 __________________________ 302 39207.00 Transfer From Port Authority 0 0 0 0 0 __________________________ 302 39310.00 Bond Proceeds 0 0 37,332 0 0 __________________________ ------------------------------------------------------------------------------------- FUND TOTALS $0 $0 $37,338 $178,553 $179,996 ============================================= - EXPENDITURES - 2016 2017 2013 2014 2015 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 302 47000 01 317.00 General Fund Admin Fees $0 $0 $0 $0 $0 __________________________ 302 47000 01 319.00 Other Professional Services 0 0 32,145 0 0 __________________________ 302 47000 01 601.00 Bond Principal 0 0 0 0 130,000 __________________________ 302 47000 01 611.00 Bond Interest 0 0 0 23,400 32,400 __________________________ 302 47000 01 621.00 Bond Paying Agent Fees 0 0 0 600 600 __________________________ 302 47000 01 710.00 Transfers 0 0 0 0 0 __________________________ ------------------------------------------------------------------------------------- FUND TOTALS $0 $0 $32,145 $24,000 $163,000 ============================================= Page 87 of 105 WATER OPERATING FUND This is an Enterprise Fund consisting of revenues from water sales that provides for the operation and maintenance of the City's wells, towers and distribution system. The City currently has four water towers and eight wells, with a ninth well currently under construction. This fund covers the operation of 1,420 fire hydrants, 1,700 gate valves and 130 miles of water main. PERFORMANCE MEASURES Operating Cost Per 1,000,000 Gallons of Water Pumped/Produced 2010 2011 2012 2013 2014 2015 $1,132 $1,392 $1,193 $1,365 $1,410 $1,635 Page 88 of 105 Page One 2017 BUDGET WORKSHEETS WATER UTILITY - REVENUES - September 20, 2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 601 33425.00 Other State Grants & Aids $0 $9,901 $0 $0 $4,500 MCES Water Efficiency Grant 601 34108.00 Administrative Fees-Other Funds 2,497 3,931 6,828 0 0 5% of 5% Fees-Const Projects 601 34109.00 Other Gen'l Govt Chgs for Services 12,250 15,820 5,850 0 0 ______________________________ 601 36101.00 Principal - Special Assessments 55,362 56,217 54,299 57,000 57,000 ______________________________ 601 36102.00 Penalties & Interest - S/A 224 (847)57 0 0 ______________________________ 601 36210.00 Interest Earnings - Investments 57,119 105,027 97,236 60,000 60,000 ______________________________ 601 36214.00 Net Change in FV-Investments (125,524)96,607 (5,138)0 0 Annual Market Value Changes 601 36215.00 Interest Earnings 70 65 280 200 200 ______________________________ 601 36220.00 Rents & Royalties 88,052 107,624 158,580 140,000 148,500 Antenna Leases 601 36260.00 Other Revenues 128 0 0 0 0 ______________________________ 601 36265.00 Use of Reserve Funds 0 0 0 0 0 ______________________________ 601 37110.00 Residential Water Revenues 1,155,429 1,100,286 1,090,820 1,350,000 1,200,000 Est $6K Lost Rev from Rebate Prog. 601 37120.00 Apartment Water Revenues 83,470 84,079 94,071 100,000 100,000 ______________________________ 601 37125.00 Institutional Water Revenues 70,541 61,957 69,187 78,000 75,000 ______________________________ 601 37130.00 Commercial Water Revenues 79,091 79,817 81,477 95,000 85,000 ______________________________ 601 37140.00 Industrial Water Revenues 123,072 113,947 164,347 140,000 150,000 ______________________________ 601 37160.00 Penalties - Water Revenues 9,896 9,280 10,506 9,500 9,500 ______________________________ 601 37165.00 Meter Maint Water Revenues 0 0 0 0 0 ______________________________ 601 37170.00 Other Water Revenues 0 2,800 592 0 0 ______________________________ 601 37180.00 Water Meter Sales Revenue 46,529 37,385 49,058 45,000 45,000 ______________________________ 601 39103.00 Gain or Loss from F/A Disposal (144)0 (494)0 0 ______________________________ 601 39203.00 Transfer From______________24,443 0 89,101 0 0 ______________________________ ---------------------------------------------------------------------------------------------------------- FUND TOTALS $1,682,505 $1,883,897 $1,966,658 $2,074,700 $1,934,700 ======================================================== Page 89 of 105 Page One 2017 BUDGET WORKSHEETS WATER UTILITY - EXPENDITURES - September 20, 2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- All Salary Costs Inclusive of 601 49400 101.00 Salaries & Benefits $515,100 Salary, Taxes, PERA & Benefits 601 49400 77 101.00 Administrative 117,500 117,387 139,529 144,900 178,900 Added-$24K for Asst City Engineer 601 49400 78 101.00 Technical/Clerical 142,778 151,671 151,280 158,800 160,500 ______________________________ 601 49400 79 101.00 Maintenance 157,164 163,437 165,527 172,300 175,700 ______________________________ 601 49400 xx 101.00 Salary & Benefit Contingency 0 0 0 0 0 ______________________________ 601 49400 102.00 Full-Time Overtime 15,629 13,810 9,705 8,000 8,000 ______________________________ 601 49400 103.00 Part-Time Salaries & Benefits 5,697 6,508 5,132 8,000 7,000 ______________________________ 601 49400 99 103.01 Utility Commission Wages (50%)1,000 50% - 601; 50% - 602 601 49400 99 103.02 Maintenance Labor 6,000 100% - 601 601 49400 01 203.00 Printed Forms & Paper 1,742 2,075 1,005 2,200 2,200 Inserts & Water Bill Statements 601 49400 01 209.00 Other Office Supplies 1,459 186 168 200 200 ______________________________ 601 49400 01 212.00 Motor Fuels 0 0 0 0 5,600 ______________________________ 601 49400 01 216.00 Chemicals & Chemical Products 58,454 51,562 48,581 70,000 75,000 Chlorine/Flouride/Poly(Add Well 16) 601 49400 01 219.00 Other Operating Supplies 331 250 50 300 300 Maintenance Supplies 601 49400 01 220.00 Water Meter Purchases 107,500 Meters, MIU's & CU Horns 601 49400 01 220.01 For Replacements 43,441 13,930 16,142 60,000 62,500 New Meter Standards 601 49400 01 220.02 For New Homes 61,704 68,837 74,982 45,000 45,000 From Water Rate Model 601 49400 01 224.00 Street Maintenance Materials 0 0 640 2,500 2,500 Patching for Breaks 601 49400 01 225.00 Landscaping Materials 845 0 60 500 500 Topsoil, Seed & Sod 601 49400 01 228.00 Meter Repair Materials 29 490 0 0 0 ______________________________ 601 49400 01 229.00 Other Maintenance Supplies 26,000 ______________________________ 601 49400 01 229.01 Supplies for Hydrants 3,332 6,622 8,619 6,000 8,000 ______________________________ 601 49400 01 229.02 Curb Shutoffs 565 653 252 1,000 1,000 ______________________________ 601 49400 01 229.03 GV Repair/Replacement 0 11,973 303 12,000 12,000 Repairs Done By City Staff 601 49400 01 229.04 Miscellaneous Supplies 3,355 2,581 2,074 5,000 5,000 ______________________________ 601 49400 01 241.00 Small Tools 614 702 626 2,000 2,000 Wrenches, Shovels, etc. 601 49400 01 242.00 Minor Equipment 2,860 2,966 5,113 3,000 12,000 Hydrant Tool (2 x $4500 each) 601 49400 01 303.00 Engineering Fees 78,000 ______________________________ 601 49400 01 303.01 WHPP 0 0 0 5,000 5,000 Groundwater Plan Implementation 601 49400 01 303.02 GIS 516 4,607 3,413 5,000 3,000 Reduce Due to In-House Engineer 601 49400 01 303.03 Rate Study 0 0 0 15,000 15,000 Part of Comp Plan Update 601 49400 01 303.04 Miscellaneous Fees 20,093 29,118 68,392 20,000 55,000 Water Facility Study in '17 ($50K) 601 49400 01 304.00 Legal Fees 0 0 0 1,000 1,000 ______________________________ 601 49400 01 310.00 Testing Services 47,000 ______________________________ 601 49400 01 310.01 Bacteria & Water Quality 1,585 1,560 1,966 2,000 2,000 Radon, Tri-Chl., Pesticides, Etc. 601 49400 01 310.03 MDH Service Connection Fee 43,149 43,552 44,475 45,000 45,000 $6.36/Connection -Annual Fee 601 49400 01 312.00 Gopher State One-Call 2,303 2,770 1,655 2,500 2,500 $7,500 Split 3 Ways 601 49400 01 318.00 Contract Engineer 10,000 12,000 6,250 0 0 ______________________________ 601 49400 01 319.00 Other Professional Services 30,000 ______________________________ 601 49400 01 319.01 Thaw Pipes, Check Leaks, etc.0 32,250 0 1,500 1,500 ______________________________ 601 49400 01 319.02 Supervisory Controls 15,648 6,562 3,575 5,000 12,500 SCADA, Summit Loggers-$7500 601 49400 01 319.03 Hazardous Chemical Permits 725 725 725 1,000 1,000 MN Department of Public Safety 601 49400 01 319.06 Contracted Hydrant Painting 10,004 10,120 10,028 10,000 11,000 110 Hydrants / Yr ($92 each) 601 49400 01 319.07 Antenna Expenses 12,563 19,904 15,458 0 0 ______________________________ 601 49400 01 319.08 Buxton Project 0 5,556 5,556 5,600 0 ______________________________ 601 49400 01 319.09 HVAC Maintenance Contract 0 0 0 0 4,000 Annual Insp/Maint, All Wells 601 49400 01 320.00 Credit Card Activity Fees 3,324 5,372 6,797 6,000 7,000 1/3 Cost of C/C Pymt Processing 601 49400 01 321.00 Telephone Costs 2,745 3,003 3,122 3,500 3,500 Cell Phones, Modesm, GPS 601 49400 01 322.00 Postage Costs 4,556 4,173 4,296 5,000 5,000 Billings with Inserts 601 49400 01 323.00 Radio Units 1,045 1,367 1,120 1,500 5,100 (24x$300)(12x$1500)(Split 5 Ways) 601 49400 01 365.00 Workers Comp Insurance 6,990 7,095 8,338 7,000 7,000 Water's Share of Premiums 601 49400 01 369.00 Other Insurance 6,181 6,048 6,132 12,000 6,500 Water's Share of Premiums 601 49400 01 391.00 P.C. Maintenance 2,900 ______________________________ 601 49400 01 391.01 U/B Software Maintenance 2,081 2,074 2,074 2,200 2,200 Added to Utility Budgets in 2012 601 49400 01 391.02 Auto Read Software Support 585 578 595 700 700 Added to Utility Budgets in 2012 601 49400 01 392.00 P.C. Accessories & Supplies 0 0 40 200 200 ______________________________ 601 49400 01 393.00 P.C. Hardware Purchases 4,093 1,707 9,199 2,000 2,000 ______________________________ 601 49400 01 394.00 P.C. Software Purchases 16,000 ______________________________ 601 49400 01 394.01 Licensing & Maintenance 4,279 4,371 4,591 6,200 15,000 ESRI, Cartegraph, OMS $10,700 601 49400 01 394.02 Online Subscriptions 286 379 379 800 800 Pictometry 601 49400 01 394.03 New Software Purchases 2,271 0 0 200 200 ______________________________ ---------------------------------------------------------------------------------------------------------- PAGE TOTALS 772,524 820,530 837,962 867,600 977,600 Page 90 of 105 Page Two 2017 BUDGET WORKSHEETS WATER UTILITY - EXPENDITURES - September 20, 2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 601 49400 01 403.00 Contracted R & M - Other Impr 30,845 23,576 23,397 30,000 30,000 Main Breaks, Gate Valves, Etc. 601 49400 01 416.00 Machinery Rental 0 0 0 0 0 ______________________________ 601 49400 01 433.00 Dues & Subscriptions 25 0 187 400 400 Suburban Utility Supt Assn, MRWA 601 49400 01 435.00 Books & Pamphlets 0 0 0 200 200 Reference Materials 601 49400 01 437.00 Conferences & Seminars 5,700 ______________________________ 601 49400 01 437.01 MDH Training (Water School)816 1,459 2,161 2,000 2,500 Operator Licensure 601 49400 01 437.02 AWWA Conference 0 0 0 0 1,200 Duluth, Send 2 Staff 601 49400 01 437.03 CarteGraph, ESRI, GIS 370 126 0 1,300 1,000 User Group, Conference, Training 601 49400 01 437.04 Miscellaneous Training 0 9 849 1,000 1,000 ______________________________ 601 49400 01 439.00 Other Miscellaneous Charges 14,627 13,460 13,459 45,000 45,000 DNR Annual Water Use 601 49400 01 450.00 Sales Tax on Purchases 0 0 2,699 0 0 ______________________________ 601 49400 01 521.00 Building & Structure Purchases 0 0 0 10,000 10,000 Pymt on P.W. Building (19 of 20) 601 49400 01 530.00 Improvements Other Than Bldgs 220,600 ______________________________ 601 49400 01 530.01 Well Inspections 490 560 0 600 600 ______________________________ 601 49400 01 530.02 Miscellaneous Improvements 0 0 405 5,000 5,000 ______________________________ 601 49400 01 530.03 CRP of Watermain 0 0 0 150,000 150,000 Annual Pavement Management 601 49400 01 530.04 Inspection & Maintenance 0 0 259,255 190,000 65,000 From Long-Term Plan 601 49400 01 540.00 Heavy Machinery Purchases 0 0 0 0 0 Equipment Purchases - Match CIP 601 49400 01 550.00 Motor Vehicle Purchases 0 0 0 0 10,000 Equipment Purchases - Match CIP 601 49400 01 570.00 Office Equipment Purchases 107 0 0 500 500 ______________________________ 601 49400 01 580.00 Other Equipment Purchases 0 0 0 0 7,000 Trash Pump (Split with 602, 603) 601 49400 01 611.00 Interest on Lease Payments 2,538 2,167 1,773 0 0 P.W. Building Expansion(See 521) 601 49400 01 710.00 Transfers 139,194 4,796 0 0 0 Transfers for Other Improvements ---------------------------------------------------------------------------------------------------------- 601-49400-01 TOTALS 961,537 866,683 1,142,148 1,303,600 1,307,000 601 49406 01 221.00 Equipment Parts 0 2,762 0 500 13,000 SCADA Upgrades 601 49406 01 223.00 Building Repair Supplies 0 7,250 0 200 200 ______________________________ 601 49406 01 319.00 Other Professional Services 0 2,352 5,862 1,000 1,000 ______________________________ 601 49406 01 381.00 Electric Utilities 1,045 1,083 1,147 1,300 1,300 Pumping & Lighting ---------------------------------------------------------------------------------------------------------- TOTAL - PRV 1,045 13,448 7,009 3,000 15,500 601 49407 01 221.00 Equipment Parts 1,401 0 409 1,500 1,500 ______________________________ 601 49407 01 223.00 Building Repair Supplies 0 8 0 200 200 ______________________________ 601 49407 01 319.00 Other Professional Services 0 0 0 0 0 ______________________________ 601 49407 01 321.00 Telephone Costs 211 211 211 300 300 ______________________________ 601 49407 01 381.00 Electric Utilities 23,667 23,142 20,778 33,000 33,000 Pumping, Lighting, Tower Mixer 601 49407 01 409.00 Other Contracted Repairs & Maint 6,000 11,781 1,429 2,000 2,000 $800 for Lights in 2015 601 49407 01 439.00 Other Miscellaneous Charges 37 0 0 100 100 Contingencies 601 49407 01 530.00 Improvements Other Than Bldgs 0 0 0 0 60,000 Controls Upgrade / Modernization ---------------------------------------------------------------------------------------------------------- TOTAL - WELL #7 31,316 35,142 22,826 37,100 97,100 601 49408 01 221.00 Equipment Parts 1,342 242 25 1,500 1,500 ______________________________ 601 49408 01 223.00 Building Repair Supplies 0 106 19 200 200 ______________________________ 601 49408 01 319.00 Other Professional Services 0 0 0 0 0 ______________________________ 601 49408 01 381.00 Electric Utilities 23,841 21,542 20,456 25,000 25,000 Pumping & Lighting 601 49408 01 383.00 Gas Utilities 470 592 497 600 600 Heat Only 601 49408 01 409.00 Other Contracted Repairs & Maint 5,952 27,330 735 2,000 2,000 $800 for Lights in 2015 601 49408 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ---------------------------------------------------------------------------------------------------------- TOTAL - WELL #8 31,605 49,812 21,732 29,400 29,400 601 49409 01 221.00 Equipment Parts 2,831 2,569 0 1,500 1,500 ______________________________ 601 49409 01 223.00 Building Repair Supplies 0 0 109 200 200 ______________________________ 601 49409 01 319.00 Other Professional Services 0 0 0 0 0 ______________________________ 601 49409 01 381.00 Electric Utilities 16,618 31,854 25,109 32,000 32,000 Pumping & Lighting 601 49409 01 383.00 Gas Utilities 795 901 627 1,500 1,500 Heat Only 601 49409 01 409.00 Other Contracted Repairs & Maint 837 335 1,838 2,000 2,000 $800 for Lights in 2015 601 49409 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies 601 49409 01 530.00 Improvements Other Than Bldgs 21,907 0 0 0 0 ______________________________ ---------------------------------------------------------------------------------------------------------- TOTAL - WELL #9 42,988 35,659 27,683 37,300 37,300 Page 91 of 105 Page Three 2017 BUDGET WORKSHEETS WATER UTILITY - EXPENDITURES - September 20, 2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 601 49410 01 219.00 Other Operating Supplies 0 0 0 500 500 ______________________________ 601 49410 01 221.00 Equipment Parts 4,434 0 5,710 1,000 1,000 ______________________________ 601 49410 01 223.00 Building Repair Supplies 213 15 0 200 200 ______________________________ 601 49410 01 321.00 Telephone Costs 765 765 765 0 0 Removing Phone Line in 2013 601 49410 01 381.00 Electric Utilities 16,623 13,223 16,173 17,000 17,000 Pumping & Lighting 601 49410 01 409.00 Other Contracted Repairs & Maint 9,957 1,748 690 2,000 2,000 $800 for Lights in 2015 601 49410 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies 601 49410 01 530.00 Improvements Other Than Bldgs 10,014 0 0 0 0 ______________________________ ---------------------------------------------------------------------------------------------------------- TOTAL - WELL #10 42,005 15,751 23,337 20,800 20,800 Rural Water System 601 49411 01 221.00 Equipment Parts 0 0 4 0 0 ______________________________ 601 49411 01 439.00 Other Miscellaneous Charges 0 0 0 0 0 ______________________________ ---------------------------------------------------------------------------------------------------------- TOTAL - WELL #11 0 0 4 0 0 Rural Water System (#2) 601 49412 01 221.00 Equipment Parts 0 0 3,431 1,500 1,500 ______________________________ 601 49412 01 223.00 Building Repair Supplies 0 0 0 200 200 ______________________________ 601 49412 01 319.00 Other Professional Services 0 0 0 0 0 ______________________________ 601 49412 01 381.00 Electric Utilities 23,242 21,696 21,159 28,000 28,000 Pumping & Lighting 601 49412 01 409.00 Other Contracted Repairs & Maint 1,495 8,317 15,891 2,000 2,000 $800 for Lights in 2015 601 49412 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ---------------------------------------------------------------------------------------------------------- TOTAL - WELL #12 24,737 30,013 40,480 31,800 31,800 601 49414 01 221.00 Equipment Parts 0 161 0 1,500 1,500 ______________________________ 601 49414 01 223.00 Building Repair Supplies 0 408 0 200 200 ______________________________ 601 49414 01 319.00 Other Professional Services 0 384 0 1,000 1,000 ______________________________ 601 49414 01 381.00 Electric Utilities 27,051 23,382 26,674 28,000 28,000 Pumping & Lighting 601 49414 01 409.00 Other Contracted Repairs & Maint 883 0 6,850 2,000 2,000 $800 for Lights in 2015 601 49414 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ---------------------------------------------------------------------------------------------------------- TOTAL - WELL #14 27,934 24,335 33,525 32,800 32,800 601 49425 01 221.00 Equipment Parts 575 830 0 1,500 1,500 ______________________________ 601 49425 01 223.00 Building Repair Supplies 0 0 0 200 200 ______________________________ 601 49425 01 319.00 Other Professional Services 0 0 0 500 500 ______________________________ 601 49425 01 381.00 Electric Utilities 26,071 24,817 24,641 28,000 28,000 Pumping & Lighting 601 49425 01 409.00 Other Contracted Repairs & Maint 1,526 430 3,944 2,000 2,000 $800 for Lights in 2015 601 49425 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ---------------------------------------------------------------------------------------------------------- TOTAL - WELL #15 28,172 26,077 28,585 32,300 32,300 601 49426 01 221.00 Equipment Parts 0 0 0 1,500 1,500 ______________________________ 601 49426 01 223.00 Building Repair Supplies 0 0 0 200 200 ______________________________ 601 49426 01 319.00 Other Professional Services 0 0 0 500 500 ______________________________ 601 49426 01 381.00 Electric Utilities 0 0 0 28,000 28,000 Pumping & Lighting 601 49426 01 383.00 Gas Utilities 0 0 0 1,000 1,000 May Be Electric Only (TBD) 601 49426 01 409.00 Other Contracted Repairs & Maint 0 0 0 1,000 1,000 ______________________________ 601 49426 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ---------------------------------------------------------------------------------------------------------- TOTAL - WELL #16 0 0 0 32,300 32,300 Page 92 of 105 Page Four 2017 BUDGET WORKSHEETS WATER UTILITY - EXPENDITURES - September 20, 2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 601 49415 01 221.00 Equipment Parts 0 0 0 500 500 Touch-up Paint 601 49415 01 319.00 Other Professional Services 0 3,675 0 0 0 ______________________________ 601 49415 01 409.00 Other Contracted Repairs & Maint 0 1,050 617 500 500 ______________________________ 601 49415 01 439.00 Other Miscellaneous Charges 0 0 0 200 200 Contingencies ---------------------------------------------------------------------------------------------------------- TOTAL - WATER TOWER #1 0 4,725 617 1,200 1,200 (Chippendale Water Tower) 601 49416 01 221.00 Equipment Parts 12 101 0 500 500 Touch-up Paint 601 49416 01 319.00 Other Professional Services 0 0 3,500 0 0 Tower Inspection 601 49416 01 381.00 Electric Utilities 1,338 1,261 2,195 4,500 4,500 New Water Mixers in 2014 601 49416 01 409.00 Other Contracted Repairs & Maint 0 8,210 3,027 500 500 ______________________________ 601 49416 01 439.00 Other Miscellaneous Charges 0 0 0 200 200 Contingencies ---------------------------------------------------------------------------------------------------------- TOTAL - WATER TOWER #2 1,350 9,572 8,722 5,700 5,700 (Connemara Water Tower) 601 49417 01 221.00 Equipment Parts 0 206 8 500 500 ______________________________ 601 49417 01 319.00 Other Professional Services 0 0 3,500 0 0 ______________________________ 601 49417 01 381.00 Electric Utilities 5,374 4,760 2,994 6,000 6,000 ______________________________ 601 49417 01 409.00 Other Contracted Repairs & Maint 0 14,700 6,105 500 500 ______________________________ 601 49417 01 439.00 Other Miscellaneous Charges 96 0 156 200 200 Contingencies ---------------------------------------------------------------------------------------------------------- TOTAL - WATER TOWER #4 5,470 19,666 12,763 7,200 7,200 (Bacardi Water Tower) 601 49418 01 221.00 Equipment Parts 0 0 24 500 500 ______________________________ 601 49418 01 319.00 Other Professional Services 0 0 20,314 0 0 ______________________________ 601 49418 01 381.00 Electric Utilities 3,359 2,768 2,154 4,000 4,000 New Water Mixers in 2014 601 49418 01 409.00 Other Contracted Repairs & Maint 519 15,500 1,020 500 500 ______________________________ 601 49418 01 439.00 Other Miscellaneous Charges 0 0 20 200 200 Contingencies ---------------------------------------------------------------------------------------------------------- TOTAL - WATER TOWER #3 3,878 18,268 23,532 5,200 5,200 (East Side Water Tower) GRAND TOTAL - ALL DEPTS.$1,202,036 $1,149,152 $1,392,963 $1,579,700 $1,655,600 ======================================================== Page 93 of 105 SEWER OPERATING FUND This is an Enterprise Fund consisting of revenues from sewer charges which provides for the operation and maintenance of 9 lift stations, 98 miles of sanitary sewer lines and 6,850 service connections for the collection and treatment of sewage. $1,284,600 covers one line item of the 2017 Sewer Fund budget for the charges paid to the Metropolitan Council for the City's share of the operations and debt for wastewater treatment plants within the metropolitan area. These charges, which make up nearly 60% of the Sewer Fund budget, are based on sewage flows into the Metropolitan Council's Rosemount and Empire treatment plants. PERFORMANCE MEASURES % of Sanitary Sewer System Cleaned 2010 2011 2012 2013 2014 2015 31.7% 31.3% 26.7% 32.2% 31.1% 23.7% Number of Sewer Blockages on City System Per 100 Connections 2010 2011 2012 2013 2014 2015 0.08 0.0 0.1 0.0 0.0 0.01 Page 94 of 105 Page One 2017 BUDGET WORKSHEETS SEWER UTILITY - REVENUES - September 20, 2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 602 33425.00 Other State Grants & Aids $0 $0 $0 $0 $0 ______________________________ 602 34108.00 Administrative Fees-Other Funds 2,497 3,931 6,828 0 0 5% of 5% Fees-Const Projects 602 36101.00 Principal - Special Assessments 98,077 81,278 78,480 90,000 85,000 ______________________________ 602 36102.00 Penalties & Interest - S/A 327 (1,366)(251)0 0 ______________________________ 602 36210.00 Interest Earnings - Investments 17,042 17,411 13,886 17,000 15,000 ______________________________ 602 36214.00 Net Change in FV-Investments (8,621)8,534 (4,100)0 0 Annual Market Value Changes 602 36215.00 Interest Earnings 76 54 225 200 200 ______________________________ 602 36260.00 Other Revenues 0 0 1,972 0 0 ______________________________ 602 36265.00 Use of Reserve Funds 0 0 0 103,400 351,000 ______________________________ 602 37210.00 Residential Sewer Revenues 1,278,008 1,247,826 1,251,838 1,500,000 1,400,000 ______________________________ 602 37220.00 Apartment Sewer Revenues 114,024 111,519 117,405 134,000 125,000 ______________________________ 602 37225.00 Institutional Sewer Revenues 24,238 24,128 21,813 29,000 25,000 ______________________________ 602 37230.00 Commercial Sewer Revenues 72,645 74,855 78,823 90,000 80,000 ______________________________ 602 37240.00 Industrial Sewer Revenues 86,042 71,258 110,928 85,000 110,000 ______________________________ 602 37260.00 Penalties - Sewer Revenues 12,567 12,104 13,051 12,000 13,000 ______________________________ 602 39103.00 Gain or Loss from F/A Disposal 0 0 0 0 0 ______________________________ 602 39203.00 Transfer From_______________10,806 0 0 0 0 ______________________________ ---------------------------------------------------------------------------------------------------- FUND TOTALS $1,707,729 $1,651,532 $1,690,900 $2,060,600 $2,204,200 ===================================================== Page 95 of 105 Page One 2017 BUDGET WORKSHEETS SEWER UTILITY - EXPENDITURES - September 20, 2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- All Salary Costs Inclusive of 602 49450 101.00 Salaries & Benefits $509,100 Salary, Taxes, PERA & Benefits 602 49450 77 101.00 Administrative 117,498 117,386 139,515 144,900 172,900 Add $18K for Asst City Engineer 602 49450 78 101.00 Technical/Clerical 142,778 151,671 151,279 158,800 160,500 ______________________________ 602 49450 79 101.00 Maintenance 157,163 163,438 165,527 172,300 175,700 ______________________________ 602 49450 xx 101.00 Salary & Benefit Contingency 0 0 0 0 0 ______________________________ 602 49450 102.00 Full-Time Overtime 15,629 13,810 9,705 7,500 7,500 ______________________________ 602 49450 103.00 Part-Time Salaries & Benefits 5,531 5,707 3,548 9,000 7,000 ______________________________ 602 49450 99 103.01 Utility Commission Wages (50%)1,000 50% - 602; 50% - 601 602 49450 99 103.02 Maintenance Labor 6,000 100% - 602 602 49450 01 203.00 Printed Forms & Paper 1,613 1,416 1,005 1,500 1,500 Inserts & Water Bill Statements 602 49450 01 209.00 Other Office Supplies 899 172 439 200 200 ______________________________ 602 49450 01 212.00 Motor Fuels 0 0 0 0 5,200 ______________________________ 602 49450 01 216.00 Chemicals & Chemical Products 0 0 731 500 500 Root Killer, Degreaser 602 49450 01 219.00 Other Operating Supplies 304 100 9 200 200 ______________________________ 602 49450 01 224.00 Street Maintenance Materials 0 0 1,439 2,500 2,500 Patching 602 49450 01 225.00 Landscaping Materials 0 0 0 400 400 Topsoil, Seed & Sod 602 49450 01 227.00 Utility System Maintenance Supplies 211 797 1,378 5,000 5,000 MH Castings Replacement Prog. 602 49450 01 241.00 Small Tools 165 237 241 500 500 Wrenches, Shovels, etc. 602 49450 01 242.00 Minor Equipment 2,990 3,746 2,765 3,000 3,000 ______________________________ 602 49450 01 303.00 Engineering Fees 23,000 ______________________________ 602 49450 01 303.01 GIS 516 4,607 3,413 5,000 3,000 Reduce Due to In-House Engineer 602 49450 01 303.02 Rate Study 0 0 0 15,000 15,000 Part of Comp Plan Update 602 49450 01 303.04 Miscellaneous 7,402 2,846 9,471 15,000 5,000 Reduce Due to In-House Engineer 602 49450 01 304.00 Legal Fees 0 0 0 500 0 ______________________________ 602 49450 01 312.00 Gopher State One-Call 2,303 2,770 1,655 2,500 2,500 $7,500 Split 3 Ways 602 49450 01 318.00 Contract Engineer 10,000 12,000 6,250 0 0 ______________________________ 602 49450 01 319.00 Other Professional Services 10,000 ______________________________ 602 49450 01 319.01 Televising 0 0 0 3,000 3,000 ______________________________ 602 49450 01 319.02 Root Control 0 0 0 2,000 2,000 ______________________________ 602 49450 01 319.03 Supervisory Controls(Maint Cont)6,802 0 0 5,000 5,000 SCADA System 602 49450 01 319.04 Buxton Project 0 5,556 5,556 5,600 0 ______________________________ 602 49450 01 320.00 Credit Card Activity Fees 3,324 5,372 6,797 6,000 7,000 1/3 Cost of C/C Pymt Processing 602 49450 01 321.00 Telephone Costs 2,745 3,001 3,122 3,500 3,500 Cell Phones, Modems, GPS 602 49450 01 322.00 Postage Costs 4,556 4,173 4,296 5,000 5,000 Billings with Inserts 602 49450 01 323.00 Radio Units 1,045 1,367 1,120 1,500 5,100 (24x$300)(12x$1500)(Split 5 Ways) 602 49450 01 365.00 Workers Comp Insurance 7,011 7,117 8,361 7,000 7,000 Sewer's Share of Premiums 602 49450 01 369.00 Other Insurance 10,777 12,067 13,292 12,000 12,000 Sewer's Share of Premiums 602 49450 01 391.00 P.C. Maintenance 0 0 0 2,900 ______________________________ 602 49450 01 391.01 U/B Software Maintenance 2,081 2,074 2,074 2,200 2,200 Added to Utility Budgets in 2012 602 49450 01 391.02 Auto Read Software Support 585 578 595 700 700 Added to Utility Budgets in 2012 602 49450 01 392.00 P.C. Accessories & Supplies 0 0 0 200 200 ______________________________ 602 49450 01 393.00 P.C. Hardware Purchases 4,093 1,600 9,199 2,000 2,000 ______________________________ 602 49450 01 394.00 P.C. Software Purchases 16,000 ______________________________ 602 49450 01 394.01 Licensing & Maintenance 4,279 4,371 4,591 6,200 15,000 ESRI, Cartegraph, OMS $10,700 602 49450 01 394.02 Online Subscriptions 286 379 379 800 800 Pictometry 602 49450 01 394.03 New Software Purchases 2,271 0 0 200 200 ______________________________ 602 49450 01 395.00 P.C. Repairs 0 0 0 500 500 ______________________________ 602 49450 01 403.00 Contracted R & M - Other Impr 2,581 63 24,454 5,000 30,000 MH Castings Replacement Prog. 602 49450 01 415.00 Other Equipment Rental 0 0 0 200 200 ______________________________ 602 49450 01 416.00 Machinery Rental 0 0 0 2,000 2,000 ______________________________ 602 49450 01 433.00 Dues & Subscriptions 0 0 0 200 200 SUSA (AJ, Dick) 50% Split w/Storm 602 49450 01 435.00 Books & Pamphlets 0 0 0 300 300 Reference Materials 602 49450 01 437.00 Conferences & Seminars 3,800 ______________________________ 602 49450 01 437.01 MPCA Training (Sewer School)1,646 669 600 1,500 1,500 Operator Licensure $300 each (M) 602 49450 01 437.03 CarteGraph, ESRI, GIS 120 126 0 1,300 1,300 User Group, Conference, Training 602 49450 01 437.04 Miscellaneous Training 0 0 814 1,000 1,000 ______________________________ 602 49450 01 439.00 Other Miscellaneous Charges 148 145 258 100 300 Contingencies 602 49450 01 521.00 Building & Structure Purchases 0 0 0 10,000 10,000 Pymt on P.W. Building (19 of 20) 602 49450 01 530.00 Improvements Other Than Bldgs 160,000 ______________________________ 602 49450 01 530.01 Miscellaneous Improvements 31 0 0 10,000 10,000 SCADA Reconfiguration, PCL's 602 49450 01 530.03 CRP of Sewermain 0 0 0 150,000 150,000 Annual Pavement Management 602 49450 01 540.00 Heavy Machinery Purchases 0 189,190 63 0 0 Equipment Purchases - Match CIP 602 49450 01 550.00 Motor Vehicle Purchases 0 0 0 0 11,000 Equipment Purchases - Match CIP 602 49450 01 560.00 Furniture & Fixture Purchases 0 0 56 500 500 ______________________________ 602 49450 01 570.00 Office Equipment Purchases 0 0 0 500 500 ______________________________ 602 49450 01 580.00 Other Equipment Purchases 0 0 0 0 7,000 Trash Pump (Split with 601, 603) ---------------------------------------------------------------------------------------------------- PAGE TOTALS 519,385 718,548 583,995 790,300 865,100 Page 96 of 105 Page Two 2017 BUDGET WORKSHEETS SEWER UTILITY - EXPENDITURES - September 20, 2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 602 49450 01 602.00 Sewer Service Charges 1,007,195 1,090,261 1,077,415 1,185,400 1,284,600 MWCC Charges 602 49450 01 611.00 Interest on Lease Payments 2,538 2,165 1,773 0 0 P.W. Building Expansion(See 521) 602 49450 01 710.00 Transfers 116,948 2,405 0 0 Transfers for Other Improvements ---------------------------------------------------------------------------------------------------- 602-49450-01 TOTALS 1,646,066 1,813,379 1,663,183 1,975,700 2,149,700 602 49451 01 219.00 Other Operating Supplies 0 0 0 100 100 ______________________________ 602 49451 01 221.00 Equipment Parts 0 0 0 800 800 ______________________________ 602 49451 01 229.00 Other Maintenance Supplies 0 0 567 200 200 ______________________________ 602 49451 01 303.00 Engineering Fees 0 0 0 0 0 ______________________________ 602 49451 01 381.00 Electric Utilities 915 916 761 1,500 1,500 ______________________________ 602 49451 01 403.00 Contracted R & M - Other Impr 0 775 704 45,000 2,000 ______________________________ 602 49451 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ---------------------------------------------------------------------------------------------------- (City Hall)TOTAL - LIFT STATION #1 915 1,691 2,032 47,700 4,700 602 49452 01 219.00 Other Operating Supplies 0 0 0 100 100 ______________________________ 602 49452 01 221.00 Equipment Parts 1,060 0 0 800 800 ______________________________ 602 49452 01 229.00 Other Maintenance Supplies 0 0 0 200 200 ______________________________ 602 49452 01 381.00 Electric Utilities 630 623 604 700 700 ______________________________ 602 49452 01 403.00 Contracted R & M - Other Impr 0 0 0 200 2,000 ______________________________ 602 49452 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ---------------------------------------------------------------------------------------------------- (Bloomfield 5th)TOTAL - LIFT STATION #7 1,691 623 604 2,100 3,900 602 49453 01 219.00 Other Operating Supplies 0 0 0 100 100 ______________________________ 602 49453 01 221.00 Equipment Parts 0 0 0 800 800 ______________________________ 602 49453 01 229.00 Other Maintenance Supplies 0 0 0 200 200 ______________________________ 602 49453 01 381.00 Electric Utilities 3,753 3,548 3,728 4,000 4,000 ______________________________ 602 49453 01 403.00 Contracted R & M - Other Impr 0 7,395 0 200 2,000 ______________________________ 602 49453 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ---------------------------------------------------------------------------------------------------- (Shannon Pond)TOTAL - LIFT STATION #3 3,753 10,942 3,728 5,400 7,200 602 49454 01 219.00 Other Operating Supplies 0 0 0 100 100 ______________________________ 602 49454 01 221.00 Equipment Parts 167 6 0 800 800 ______________________________ 602 49454 01 229.00 Other Maintenance Supplies 0 0 0 200 200 ______________________________ 602 49454 01 381.00 Electric Utilities 4,602 4,821 5,539 6,000 6,000 ______________________________ 602 49454 01 403.00 Contracted R & M - Other Impr 1,582 0 0 2,000 2,000 ______________________________ 602 49454 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ---------------------------------------------------------------------------------------------------- (Hawkins)TOTAL - LIFT STATION #4 6,351 4,827 5,539 9,200 9,200 602 49455 01 219.00 Other Operating Supplies 0 0 0 100 100 ______________________________ 602 49455 01 221.00 Equipment Parts 0 1,800 0 800 800 ______________________________ 602 49455 01 229.00 Other Maintenance Supplies 0 0 0 200 200 ______________________________ 602 49455 01 303.00 Engineering Fees 0 0 0 0 0 ______________________________ 602 49455 01 310.00 Testing Services 0 0 0 0 0 ______________________________ 602 49455 01 381.00 Electric Utilities 5,569 5,802 4,979 6,000 6,000 ______________________________ 602 49455 01 403.00 Contracted R & M - Other Impr 0 415 2,350 200 2,000 ______________________________ 602 49455 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ---------------------------------------------------------------------------------------------------- (LeForet Add'n)TOTAL - LIFT STATION #5 5,569 8,016 7,329 7,400 9,200 602 49456 01 219.00 Other Operating Supplies 0 0 0 100 100 ______________________________ 602 49456 01 221.00 Equipment Parts 2,385 0 0 800 800 ______________________________ 602 49456 01 229.00 Other Maintenance Supplies 0 0 0 200 200 ______________________________ 602 49456 01 381.00 Electric Utilities 6,001 8,270 3,945 6,000 6,000 ______________________________ 602 49456 01 403.00 Contracted R & M - Other Impr 0 0 0 200 2,000 ______________________________ 602 49456 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ---------------------------------------------------------------------------------------------------- (Drumcliffe)TOTAL - LIFT STATION #6 8,385 8,270 3,945 7,400 9,200 Page 97 of 105 Page Three 2017 BUDGET WORKSHEETS SEWER UTILITY - EXPENDITURES - September 20, 2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 602 49457 01 219.00 Other Operating Supplies 0 0 0 100 100 ______________________________ 602 49457 01 221.00 Equipment Parts 0 0 0 500 500 ______________________________ 602 49457 01 229.00 Other Maintenance Supplies 0 0 0 200 200 ______________________________ 602 49457 01 381.00 Electric Utilities 1,278 857 216 1,200 1,200 ______________________________ 602 49457 01 403.00 Contracted R & M - Other Impr 0 0 1,533 200 2,000 ______________________________ 602 49457 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ---------------------------------------------------------------------------------------------------- (Glendalough 5th)TOTAL - LIFT STATION #9 1,278 857 1,749 2,300 4,100 602 49458 01 219.00 Other Operating Supplies 0 0 0 100 100 ______________________________ 602 49458 01 221.00 Equipment Parts 1,269 0 0 500 500 ______________________________ 602 49458 01 229.00 Other Maintenance Supplies 0 0 0 200 200 ______________________________ 602 49458 01 381.00 Electric Utilities 633 629 449 800 800 ______________________________ 602 49458 01 403.00 Contracted R & M - Other Impr 0 0 539 200 2,000 ______________________________ 602 49458 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ---------------------------------------------------------------------------------------------------- (Meadows of )TOTAL - LIFT STATION #8 1,902 629 987 1,900 3,700 (Bloomfield) 602 49460 01 219.00 Other Operating Supplies 0 0 0 100 100 ______________________________ 602 49460 01 221.00 Equipment Parts 725 0 0 500 500 ______________________________ 602 49460 01 229.00 Other Maintenance Supplies 0 0 0 200 200 ______________________________ 602 49460 01 381.00 Electric Utilities 252 261 233 400 400 ______________________________ 602 49460 01 403.00 Contracted R & M - Other Impr 0 0 0 200 2,000 ______________________________ 602 49460 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ---------------------------------------------------------------------------------------------------- (Glen Rose)TOTAL - LIFT STATION #10 977 261 233 1,500 3,300 GRAND TOTAL - ALL DEPTS.$1,676,886 $1,849,496 $1,689,329 $2,060,600 $2,204,200 ===================================================== Page 98 of 105 STORM WATER OPERATING FUND This is an Enterprise Fund consisting of revenues from storm water utility charges that provides for the operation and maintenance of the City’s storm water facilities, which includes: •7 lift stations (one more scheduled to go online in 2016) •3,900 catch basins •97 miles of storm sewer •More than 65 storm water treatment ponds This fund pays for cleaning storm drain sumps in manholes and catch basins, and for ditching in rural areas. It funds wetland investigations and the assimilation of a wetland inventory for the City. Most of the remaining operating budget is used to pay for large projects in which debt is issued. Repayment of this debt is accomplished through fund transfers to the appropriate debt service funds. PERFORMANCE MEASURES Number of Sumps Cleaned 2010 2011 2012 2013 2014 2015 62 411* 167 128 130 562* * All sumps are inspected and rated on the following scale: 1: 0-25% full 2: 25-50% full 3: 50-75% full 4: 75-100% full Only sumps with ratings of 3 or 4 are cleaned each year. Many sumps that had been rated 2 for several years (just below the threshold for cleaning) received a rating of 3 or 4 in 2011 and 2015. Page 99 of 105 Page One 2017 BUDGET WORKSHEETS STORM WATER UTILITY - REVENUES - September 20, 2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 603 33400.00 State Grants & Aids $0 $0 $0 $0 $0 ______________________________ 603 33425.00 Other State Grants & Aids 0 0 0 0 0 ______________________________ 603 33620.00 Other County Grants & Aids 0 19,680 0 0 0 ______________________________ 603 34108.00 Administrative Fees-Other Funds 2,497 3,931 6,828 0 0 5% of 5% Fees-Const Projects 603 36101.00 Principal - Special Assessments 19,925 25,726 21,967 22,000 22,000 ______________________________ 603 36102.00 Penalties & Interest - S/A 76 (362)(57)0 0 ______________________________ 603 36210.00 Interest Earnings - Investments 21,458 37,889 34,724 25,000 25,000 ______________________________ 603 36214.00 Net Change in FV-Investments (48,916)40,005 (8,127)0 0 Annual Market Value Changes 603 36215.00 Interest Earnings 60 47 213 200 200 ______________________________ 603 36260.00 Other Revenues 188,004 35,615 0 0 0 ______________________________ 603 36262.00 Special Settlements 0 24,797 0 0 0 ______________________________ 603 36265.00 Use of Reserve Funds 0 0 0 0 0 ______________________________ 603 37300.00 Storm Water Utility Revenues 980,819 1,040,839 1,102,373 1,000,000 1,215,000 5% Rate Increase Per Year 603 37360.00 Penalties - Storm Water Utility 5,956 6,577 9,300 6,000 6,000 ______________________________ 603 39203.00 Transfer From______________0 14,260 24,000 0 0 ______________________________ ------------------------------------------------------------------------------------------------------ FUND TOTALS $1,169,878 $1,249,004 $1,191,221 $1,053,200 $1,268,200 ====================================================== Page 100 of 105 Page One 2017 BUDGET WORKSHEETS STORM WATER UTILITY - EXPENDITURES - September 20, 2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- All Salary Costs Inclusive of 603 49500 101.00 Salaries & Benefits $277,800 Salary, Taxes, PERA & Benefits 603 49500 77 101.00 Administrative 10,586 10,932 26,693 39,400 79,900 Added-$36K for Asst City Engineer 603 49500 78 101.00 Technical/Clerical 80,607 85,598 85,202 86,800 87,300 ______________________________ 603 49500 79 101.00 Maintenance 78,581 81,718 82,763 87,900 110,600 Added-$20.8K-25% of New Position 603 49500 xx 101.00 Salary & Benefit Contingency 0 0 0 0 0 ______________________________ 603 49500 102.00 Full-Time Overtime 7,836 6,918 4,928 6,000 6,000 ______________________________ 603 49500 99 103.00 Part-Time Salaries & Benefits 5,157 4,323 6,506 8,000 8,000 ______________________________ 603 49500 01 203.00 Printed Forms & Paper 1,613 1,416 1,005 1,500 1,500 ______________________________ 603 49500 01 204.00 Envelopes & Letterhead 0 0 0 0 0 ______________________________ 603 49500 01 208.00 Miscellaneous Supplies 1,090 0 397 500 500 Stakes, Ribbons, Level, etc. 603 49500 01 212.00 Motor Fuels 0 0 0 0 6,200 ______________________________ 603 49500 01 215.00 Shop Materials 0 0 0 0 0 ______________________________ 603 49500 01 219.00 Other Operating Supplies 0 0 0 0 0 ______________________________ 603 49500 01 221.00 Equipment Parts 0 0 0 0 0 ______________________________ 603 49500 01 224.00 Street Maintenance Materials 515 1,505 39 2,000 2,000 Patching Material for Washouts 603 49500 01 225.00 Landscaping Materials 2,000 ______________________________ 603 49500 01 225.01 Rip-Rap, Matting, Rock, etc.898 1,868 1,162 2,000 1,000 ______________________________ 603 49500 01 225.02 Black Dirt, Seed, Sod, etc.150 150 0 2,000 1,000 ______________________________ 603 49500 01 226.00 Sign Repair Materials 0 0 0 500 500 ______________________________ 603 49500 01 230.00 Equipment Repair Material 1,754 1,018 482 1,000 1,000 ______________________________ 603 49500 01 241.00 Small Tools 349 627 260 1,000 1,000 ______________________________ 603 49500 01 242.00 Minor Equipment 2,659 1,567 943 2,000 2,000 Misc. Nozzles for Vac Truck 603 49500 01 303.00 Engineering Fees 100,000 ______________________________ 603 49500 01 303.01 Problem Area Investigations 79 0 0 10,000 5,000 Reduce Due to In-House Engineer 603 49500 01 303.02 NPDES Phase II 14,115 68,996 75,829 40,000 32,000 Reduce Due to In-House Engineer 603 49500 01 303.03 CSMP Update 4,850 2,535 25,026 50,000 50,000 Part of Comp Plan Update 603 49500 01 303.04 Miscellaneous 14,108 5,265 11,053 20,000 10,000 Reduce Due to In-House Engineer 603 49500 01 303.05 GIS 344 3,071 2,276 5,000 3,000 Reduce Due to In-House Engineer 603 49500 01 303.06 MS4 Services 0 0 0 10,000 0 ______________________________ 603 49500 01 304.00 Legal Fees 0 0 0 2,000 2,000 ______________________________ 603 49500 01 310.00 Testing Services 0 0 0 1,000 1,000 Water Quality Tests (M) 603 49500 01 312.00 Gopher State One-Call 0 169 2,012 2,500 2,500 $7,500 Split 3 Ways 603 49500 01 315.00 Special Programs 4,815 4,815 3,850 5,000 5,000 WHEP 603 49500 01 318.00 Contract Engineer 10,000 12,000 6,250 0 0 ______________________________ 603 49500 01 319.00 Other Professional Services 6,802 5,000 ______________________________ 603 49500 01 319.01 SCADA 0 0 0 5,000 5,000 ______________________________ 603 49500 01 319.02 Buxton Project 0 5,556 5,556 5,600 0 ______________________________ 603 49500 01 320.00 Credit Card Activity Fees 3,324 5,372 6,797 6,000 7,000 1/3 Cost of C/C Pymt Processing 603 49500 01 321.00 Telephone Costs 2,745 3,002 3,122 3,500 3,500 Cell Phones, Modems, GPS 603 49500 01 322.00 Postage Costs 4,556 4,173 4,296 5,000 5,000 Billings & Info Mailings 603 49500 01 323.00 Radio Units 1,045 1,367 1,120 1,500 5,100 (24x$300)(12x$1500)(Split 5 Ways) 603 49500 01 352.00 General Notices & Public Info 0 0 0 1,000 1,000 Public Info Brochure 603 49500 01 365.00 Workers Comp Insurance 2,925 2,992 3,541 3,500 3,500 Storm Water's Share of Premiums 603 49500 01 369.00 Other Insurance 1,278 1,316 1,203 4,000 4,000 Storm Water's Share of Premiums 603 49500 01 391.00 P.C. Maintenance 2,900 ______________________________ 603 49500 01 391.01 U/B Software Maintenance 2,081 2,074 2,074 2,200 2,200 Added to Utility Budgets in 2012 603 49500 01 391.02 Auto Read Software Support 585 578 595 700 700 Added to Utility Budgets in 2012 603 49500 01 393.00 P.C. Hardware Purchases 4,093 1,600 9,199 2,000 2,000 ______________________________ 603 49500 01 394.00 P.C. Software Purchases 16,000 ______________________________ 603 49500 01 394.01 Licensing & Maintenance 4,279 4,371 4,591 6,200 15,000 ESRI, Cartegraph, OMS $10,700 603 49500 01 394.02 Online Subscriptions 286 379 379 800 800 Pictometry 603 49500 01 394.03 New Software Purchases 2,271 0 0 200 200 ______________________________ 603 49500 01 403.00 Contracted R & M - Other Impr 68,000 ______________________________ 603 49500 01 403.01 Ditching 4,330 8,344 0 8,000 8,000 ______________________________ 603 49500 01 403.02 Miscellaneous Repairs 32,838 117,136 20,634 60,000 60,000 Catch Basins, Manholes, Etc. 603 49500 01 403.03 Pond Inspection & Maintenance 0 0 0 10,000 0 ______________________________ 603 49500 01 405.00 MS4 Permit Compliance 170,000 ______________________________ 603 49500 01 405.01 Engineering Fees 0 0 0 0 45,000 Inspection, GIS, Guidance, Etc. 603 49500 01 405.02 Equipment Rental 0 0 0 0 20,000 Bulldozer, Large Equipment 603 49500 01 405.03 Dirt, Seed, Rip Rap, Etc.0 0 0 0 5,000 For Restoration 603 49500 01 405.04 Contracted Maintenance 0 0 0 0 100,000 Burush Clearing, Dredging ($40K) 603 49500 01 416.00 Machinery Rental 64 0 0 4,000 2,500 Pumps 603 49500 01 433.00 Dues & Subscriptions 140 140 140 200 200 SUSA(AJ, Dick) 50% Split w/Storm 603 49500 01 435.00 Books & Pamphlets 0 0 73 500 500 Utility Information 603 49500 01 437.00 Conferences & Seminars 3,500 ______________________________ 603 49500 01 437.01 Storm Water Management 112 0 0 1,200 1,200 Stormwater Collab, Flygt Training 603 49500 01 437.04 Cartegraph, ESRI, GIS 120 126 0 1,300 1,300 User Group, Conference, Training 603 49500 01 437.05 Miscellaneous Training 0 0 165 1,000 1,000 ______________________________ 603 49500 01 439.00 Other Miscellaneous Charges 908 145 265 0 300 ______________________________ ------------------------------------------------------------------------------------------------------ PAGE TOTALS 314,887 453,160 400,426 519,500 719,000 Page 101 of 105 Page Two 2017 BUDGET WORKSHEETS STORM WATER UTILITY - EXPENDITURES - September 20, 2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 603 49500 01 530.00 Improvements Other Than Bldgs 356,300 ______________________________ 603 49500 01 530.01 CRP of Storm Sewer 6,523 0 7,800 150,000 150,000 Keegan Lake Drainage in 2017 603 49500 01 530.02 Stormwater System Improvements 0 0 0 0 206,300 Keegan Lake Drainage in 2017 603 49500 01 540.00 Heavy Machinery Purchases 0 0 0 0 99,000 Sweeper (Split w/Equipment CIP) 603 49500 01 550.00 Motor Vehicle Purchases 0 0 0 0 10,000 Equipment Purchases - Match CIP 603 49500 01 560.00 Furniture & Fixture Purchases 0 189,190 0 500 500 ______________________________ 603 49500 01 580.00 Other Equipment Purchases 0 0 63 2,000 8,000 Trash Pump (Split with 601, 602) 603 49500 01 586.00 Computer Equipment Purchases 0 0 0 500 500 ______________________________ 603 49500 01 710.00 Transfers 32,000 ______________________________ 603 49500 01 710.06 1/2 of 2011 P & I Payments(2010A)89,000 87,000 51,000 51,000 32,000 Refunding Issue 12/10 603 49500 01 710.10 Projects 81,225 123,395 384,695 0 0 ______________________________ ------------------------------------------------------------------------------------------------------ 603-49500-01 TOTALS 491,635 852,746 843,983 723,500 1,225,300 603 49511 01 221.00 Equipment Parts 410 0 0 500 500 ______________________________ 603 49511 01 381.00 Electric Utilities 312 360 277 500 500 ______________________________ 603 49511 01 403.00 Contracted Repair & Maintenance 0 278 1,455 1,000 1,000 ______________________________ ------------------------------------------------------------------------------------------------------ (Copper Pond)TOTAL - LIFT STATION #1 722 638 1,732 2,000 2,000 603 49512 01 221.00 Equipment Parts 0 0 0 500 500 ______________________________ 603 49512 01 381.00 Electric Utilities 0 0 0 500 500 ______________________________ 603 49512 01 403.00 Contracted Repair & Maintenance 0 0 1,897 1,000 1,000 ______________________________ ------------------------------------------------------------------------------------------------------ (Schwarz Pond)TOTAL - LIFT STATION #2 0 0 1,897 2,000 2,000 603 49513 01 221.00 Equipment Parts 0 0 0 500 500 ______________________________ 603 49513 01 381.00 Electric Utilities 5,176 5,552 4,157 6,000 6,000 ______________________________ 603 49513 01 403.00 Contracted Repair & Maintenance 0 0 1,455 1,000 1,000 ______________________________ ------------------------------------------------------------------------------------------------------ (Birger Pond)TOTAL - LIFT STATION #3 5,176 5,552 5,612 7,500 7,500 603 49514 01 221.00 Equipment Parts 0 0 0 500 500 ______________________________ 603 49514 01 381.00 Electric Utilities 1,500 2,067 986 2,500 2,500 ______________________________ 603 49514 01 403.00 Contracted Repair & Maintenance 0 103 1,765 1,000 1,000 Alarm Upgrades ------------------------------------------------------------------------------------------------------ (Marcotte Pond)TOTAL - LIFT STATION #4 1,500 2,170 2,751 4,000 4,000 603 49515 01 221.00 Equipment Parts 0 0 0 500 500 ______________________________ 603 49515 01 381.00 Electric Utilities 0 0 0 500 500 ______________________________ 603 49515 01 403.00 Contracted Repair & Maintenance 0 0 1,455 1,000 1,000 Alarm Upgrades, SCADA, PLC ------------------------------------------------------------------------------------------------------ (Hawkins Pond)TOTAL - LIFT STATION #5 0 0 1,455 2,000 2,000 603 49516 01 221.00 Equipment Parts 0 0 0 500 500 ______________________________ 603 49516 01 381.00 Electric Utilities 449 473 352 500 500 ______________________________ 603 49516 01 403.00 Contracted Repair & Maintenance 0 145 1,455 1,000 1,000 ______________________________ ------------------------------------------------------------------------------------------------------ (Glendalough 7th)TOTAL - LIFT STATION #6 449 618 1,807 2,000 2,000 603 49517 01 221.00 Equipment Parts 0 0 0 0 500 ______________________________ 603 49517 01 381.00 Electric Utilities 0 0 0 0 500 ______________________________ 603 49517 01 403.00 Contracted Repair & Maintenance 0 0 0 0 1,000 ______________________________ ------------------------------------------------------------------------------------------------------ (Horseshoe Lake)TOTAL - LIFT STATION #7 0 0 0 0 2,000 GRAND TOTAL - ALL DEPTS.$499,484 $861,724 $859,238 $743,000 $1,246,800 ====================================================== Page 102 of 105 ICE ARENA ADMINISTRATION •The Parks and Recreation Department administer the Ice Arena. Scheduling and invoicing of ice are the main administrative duties of ice arena operations. The scheduling of prime time ice is coordinated with Independent School District #196 and Rosemount Area Hockey Association for practices, games and tournament play. The Parks and Recreation Department provides overall planning, coordination, management of personnel and administration of ice arena activities. COMMUNITY USE •Provides recreational open skating for the residents of Rosemount as well as learning to skate and figure skating programs. MAINTENANCE •Provides ongoing and preventative maintenance of the ice arena building structure and its mechanical components. Ensures ice is maintained at optimal efficiency. PERFORMANCE MEASURES Number of Ice Arena Hours Utilized 2011 2012 2013 2014 2015 2,514 2,332 2,478 2,378 2,375 Page 103 of 105 Page One 2017 BUDGET WORKSHEETS ARENA - REVENUES September 20, 2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 650 36210.00 Interest Earnings - Investments $320 $399 $628 $0 $0 ____________________________ 650 36215.00 Interest Earnings 35 54 70 100 100 ____________________________ 650 36230.00 Contributions/Donations 0 0 0 0 0 ____________________________ 650 36260.00 Other Revenue - Learn to Skate 31,950 38,362 40,189 37,000 40,000 Learn to Skate Program (LTS) 650 36265.00 Use of Reserve Funds 0 0 0 49,700 49,000 ____________________________ 650 38060.00 Prime Time Ice Fees 243,303 254,671 259,730 270,000 257,000 ____________________________ 650 38061.00 Non-Prime Time Ice Fees 72,984 61,953 71,309 72,000 95,000 ____________________________ 650 38063.00 Open Skating Ice Fees 7,945 6,425 6,316 6,000 6,500 ____________________________ 650 38065.00 Other Events - Arena 0 0 0 0 0 Dry Floor Events 650 38066.00 Advertising Revenue - Arena 8,750 12,250 6,500 13,000 13,000 ____________________________ 650 38067.00 Skate Sharpening Revenue - Arena 3,024 7,085 5,330 7,000 7,000 ____________________________ 650 38090.00 Concessions 2,600 4,550 4,100 3,900 2,000 ____________________________ 650 38091.00 Vending Machine Revenues 4,892 4,518 13,890 5,000 10,000 ____________________________ 650 38095.00 Pro Shop Revenues 611 950 1,510 1,000 1,500 Tape, Laces, Mouthguards, etc. 650 39103.00 Gain or Loss from F/A Disposal 0 1,867 0 0 0 ____________________________ 650 39201.00 Transfer From General Fund 115,000 115,000 130,000 130,000 130,000 Subsidy for Operations ------------------------------------------------------------------------------------------ FUND TOTALS 491,413 508,084 539,572 594,700 611,100 ================================================ Page 104 of 105 Page One 2017 BUDGET WORKSHEETS ARENA - EXPENDITURES September 20, 2016 2017 2016 Object 2017 2013 2014 2015 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- All Salary Costs Inclusive of 650 45130 101.00 Salaries & Benefits $181,800 Salary, Taxes, PERA & Benefits 650 45130 77 101.00 Administrative 42,768 39,514 49,113 44,500 45,800 ____________________________ 650 45130 78 101.00 Technical/Clerical 37,657 39,299 39,663 41,500 42,900 ____________________________ 650 45130 79 101.00 Maintenance 75,364 77,378 74,020 81,400 93,100 Upgrades for Coord, Lead Pay 650 45130 xx 101.00 Salary & Benefit Contingency 0 0 0 0 0 ____________________________ 650 45130 79 102.00 Full-Time Overtime 1,916 1,471 525 2,000 2,000 ____________________________ 650 45130 103.00 Part-Time Salaries & Benefits 42,000 ____________________________ 650 45130 89 103.00 Learn-To-Skate Program 17,512 19,779 21,035 19,000 19,000 ____________________________ 650 45130 99 103.00 Building Attendants 23,718 25,692 28,929 23,000 23,000 And Other P/T Positions 650 45130 01 207.00 Training & Instructional Supplies 0 0 0 100 100 ____________________________ 650 45130 01 208.00 Miscellaneous Supplies 700 ____________________________ 650 45130 01 208.01 Skate Magnets 0 0 0 100 100 ____________________________ 650 45130 01 208.02 Other Supplies 0 290 0 600 600 ____________________________ 650 45130 01 209.00 Other Office Supplies 107 135 605 500 500 Learn to Skate Program Supplies 650 45130 01 211.00 Cleaning Supplies 3,828 3,488 3,965 4,000 4,000 ____________________________ 650 45130 01 212.00 Motor Fuels 0 0 0 0 0 Zamboni Maintenance 650 45130 01 216.00 Chemicals & Chemical Products 7,515 7,848 8,083 5,000 7,500 Cooling Tower 650 45130 01 219.00 Other Operating Supplies 1,289 489 148 500 500 Events Supplies 650 45130 01 221.00 Equipment Parts 6,133 4,704 8,794 6,000 8,000 ____________________________ 650 45130 01 223.00 Building Repair Supplies 1,629 3,903 2,499 3,000 3,500 ____________________________ 650 45130 01 265.00 Other Items for Resale 681 1,075 1,006 600 600 Pro Shop Supplies 650 45130 01 305.00 Medical & Dental Fees 0 0 0 0 0 ____________________________ 650 45130 01 311.00 Officiating Fees 0 0 0 0 0 ____________________________ 650 45130 01 317.00 General Fund Admin Fees 6,000 6,000 6,000 6,000 6,000 Yearly Fee Per Admin Fee Policy 650 45130 01 321.00 Telephone Costs 1,285 1,183 1,000 1,300 1,300 ____________________________ 650 45130 01 331.00 Travel Expense 0 0 0 100 100 ____________________________ 650 45130 01 341.00 Employment Advertising 0 0 0 0 0 ____________________________ 650 45130 01 349.00 Other Advertising 120 855 1,077 200 200 ____________________________ 650 45130 01 365.00 Workers Comp Insurance 3,302 3,257 3,697 3,500 3,500 ____________________________ 650 45130 01 369.00 Other Insurance 4,033 3,803 3,715 8,000 8,000 ____________________________ 650 45130 01 381.00 Electric Utilities 134,898 123,636 118,354 130,000 125,000 ____________________________ 650 45130 01 383.00 Gas Utilities 28,636 32,808 21,845 25,000 25,000 ____________________________ 650 45130 01 384.00 Refuse Disposal 2,836 2,833 2,833 3,000 3,000 ____________________________ 650 45130 01 401.00 Contracted Building Repairs 10,653 9,490 11,375 8,500 10,000 ____________________________ 650 45130 01 404.00 Contracted Mach & Equip Repairs 28,128 25,257 28,175 25,000 25,000 ____________________________ 650 45130 01 415.00 Other Equipment Rental 0 0 225 300 300 ____________________________ 650 45130 01 433.00 Dues & Subscriptions 1,090 770 770 1,000 1,000 MIAMA & MRPA Dues 650 45130 01 437.00 Conferences & Seminars 0 406 2,415 2,500 4,000 MIAMA & MRPA Seminars 650 45130 01 439.00 Other Miscellaneous Charges 0 0 0 0 0 Contingencies 650 45130 01 521.00 Building & Structure Purchases 0 913 0 0 30,000 Restroom Rehab - Upper Level 650 45130 01 580.00 Other Equipment Purchases 80,176 14,005 0 145,000 108,000 Ice Resurfacer (Moved to 2017) 650 45130 01 581.00 Other Equipment Purchases 0 0 0 0 6,000 Ice Edger 650 45130 01 710.00 Transfers 3,500 ____________________________ 650 45130 01 710.01 Yearly Maintenance 3,500 3,500 3,500 3,500 3,500 650 45130 01 710.02 ____________________________0 0 0 0 0 ____________________________ 650 45130 01 710.03 ____________________________0 0 0 0 0 ____________________________ ------------------------------------------------------------------------------------------ FUND TOTALS 524,772 453,780 443,367 594,700 611,100 ================================================ Page 105 of 105