Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2.b Draft Budget
4ROSEMOUNTEXECUTIVE SUMMARY CITY COUNCIL City Council Work Session: June 10, 2014 AGENDA ITEM: 2015 Draft Budget AGENDA SECTION: PREPARED BY: Dwight Johnson, City Administrator AGENDA NO. 2 b ATTACHMENTS: Draft 2015 Budget APPROVED BY: 041 RECOMMENDED ACTION: Discussion only BACKGROUND Attached is the first draft of the 2015 budget. Department directors proposed budgets for next year. Jeff May and I met with each department and adjustments were made both up and down in the proposed budgets. The result of this first draft is a proposed increase in the property tax levy of 2.85%. While there are many specific influences on the proposed budget which are discussed below,the proposed increase approximates the cost of living plus the current growth rate of the community. The current projected increase for the median value home is $28 per year. The total projected 2015 City tax for the median home is $928,which still favorably compares with$1,058 paid on the same home in 2008. DISCUSSION For 2015,we project that both building permit and gravel tax revenues will be significantly higher than in 2014. The projected increase in building permit and plan check fees is $130,000 compared with the 2014 budget. Gravel taxes are projected to increase from$43,000 in 2014 to $100,000 in 2015 based upon full operation of the mining at UMore Park. Finally,the surplus in the Fire Department Relief Association funds allows a reduction in the levy for that purpose of$35,000 for 2015. There are a number of offsetting items, however: • We have no general fund surplus from 2013 operations which we usually have to help offset future budget or CIP expenditures. • We need to budget for'h year of Activity Center operations based on current construction timetables,a net increase of$9,700 over the 2014 budget. An additional$32,700 will be needed in 2016 when the center is open for the full year. • Operation and maintenance for the new splash pad in the amount of$7,500 has been added. • A full year of funding for the new Sergeant position approved for July 2014 is included,an increase of$55,400. • Bargaining agreements of approximately 2% have been reached with all unions for 2015. These increases along with the decreases in amount we pay for family health insurance are incorporated in the 2015 budget. • The Ice Arena will require an additional$15,000 per year from the General Fund based on our 10 year cost projections. The cost of providing a new required refrigerant system is included in the 10 year analysis. • The Equipment CIP is currently our weakest fund in the 10 year analysis,with potential shortfalls as early as 2016. In order to mitigate this, an additional$50,000 per year of tax levy funding is proposed. Future General Fund surplus dollars will likely be needed to support this fund also. • PERA pension costs imposed by the State increased our General Fund budget by about$30,000. • An intern in Community Development is included for 2015 to assist with the Buxton marketing initiative and the Resilient Communities project. The cost is $6,000. CONCLUSION The State Legislature slightly amended the budget calendar for cities this year. We now have until September 30`h to submit our preliminary"not to exceed" levy instead of September 15`h. For us, it means that we can adopt the preliminary levy on at our September 16th regular meeting rather than the September 2"d meeting. Also,there are no levy limits in place for 2015. The proposed budget is the result of a detailed look at the tax-supported operating funds as well as the Ice Arena Fund and the Equipment OP fund. These are the funds most likely to have a significant impact on the tax levy. In the coming weeks,we will do more work on the utility fund budgets and the other CIP budgets. There are no new full-time employees proposed in this budget and no major new initiatives other than to complete and operate the projects and facilities currently underway. At this relatively early date,we are presenting our work so far for comment,questions and identification of additional research desired by the Council. We normally have a second budget meeting in August,but we can have a special meeting before then if necessary. 2 FUNDING REQUIREMENTS-USES (INCLUDING FIRE STATION LEVY) June 10,2014 2014 2015 Adopted Proposed +/- Departments Budget Budget Difference Percentage Council Budget $252,600 $267,900 $15,300 6.06% Safes Tax Exemption Savings ($90,000) ($90,000) $0 n/a Administration Budget 505,600 529,200 23,600 4.67% Elections Budget 40,000 20,000 (20,000) -50.00% Finance Budget 464,800 499,400 34,600 7.44% General Government Budget 374,200 351,400 (22,800) -6.09% Community Development Budget 929,300 981,700 52,400 5.64% Police Budget 3,349,700 3,547,800 198,100 5.91% Fire Budget 437,300 409,300 (28,000) -6.40% Public Works Operating Budgets: Government Buildings Budget 504,600 520,600 16,000 3.17% Fleet Maintenance Budget 677,000 695,200 18,200 2.69% Street Maintenance Budget 1,348,300 1,343,100 (5,200) -0.39% Parks Maintenance Budget 833,400 917,200 83,800 10.06% Park&Rec Budget-General Operating 1,169,100 1,199,500 30,400 2.60% Park&Rec Budget-Steeple Ctr.Operations 61,200 59,500 (1,700) -2.78% Park&Rec Budget-Activity Center 15,000 32,700 17,700 118.00% Park&Rec Budget-Special Programs 111,500 105,400 (6,100) -5.47% Transfers-Arena Assistance 115,000 130,000 15,000 13.04% Total Operating Budgets-General Fund $11,098,600 $11,519,900 $421,300 3.80% Building CIP Requirements 24,000 24,000 0 0.00% Street CIP Requirements 740,000 760,000 20,000 2.70% Equipment CIP Requirements 490,000 540,000 50,000 10.20% Insurance Budget Requirements 245,000 245,000 0 0.00% Port Authority Operating Levy 58,000 58,000 0 0.00% Bonded Indebtedness 375,622 373,247 (2,375) -0.63% Bonded Indebtedness-Fire Station Levy 0 0 0 0.00% Armory Anticipatory Levy(Value 2/19/14) 0 0 0 0.00% "$2,175,853,425 x.00798%=$117,633** Water Enterprise Fund 1,504,600 1,694,100 189,500 12.59% Sewer Enterprise Fund 1,874,300 1,901,900 27,600 1.47% Storm Water Enterprise Fund 660,300 667,500 7,200 1.09% Arena Enterprise Fund 504,800 588,700 83,900 16.62% Total Funding Requirements $17,575,222 $18,372,347 $797,125 4.54% NOTE: Special Levies include(1)Bonded Indebtedness,(2)Fire Station Levy and(3)Armory Anticipatory Levies. I FUNDING REQUIREMENTS-SOURCES (INCLUDING FIRE STATION LEVY) June 10,2014 2014 2015 Adopted Proposed +/- Types Budget Budget Difference Percentage Internal Revenue Generated: Licenses and Permits 438,300 535,800 97,500 22.25% Intergovernmental 580,800 670,200 89,400 15.39% Charges for Services 848,300 900,800 52,500 6.19% Fines&Forfeits 125,000 125,000 0 0.00% Recreational Fees 253,600 248,000 (5,600) -2.21% Miscellaneous Revenues 160,300 112,700 (47,600) -29.69% Transfers In 3,500 3,500 0 0.00% Enterprise Revenues 4,544,000 4,852,200 308,200 6.78% Total Internal Revenues 6,953,800 7,448,200 494,400 7.11% Levy Sources: Special Levies 375,622 373,247 (2,375) -0.63% General Levy 10,245,800 10,550,900 305,100 2.98% Total Levy $10,621,422 $10,924,147 $302,725 2.85% Loss of MVHC from State Funding $0 $0 $0 0.00% Total Revenue Sources $17,575,222 $18,372,347 $797,125 4.54% NOTE: Special Levies include(1)Bonded Indebtedness,(2)Fire Station Levy and(3)Armory Anticipatory Levies. 2014 GENERAL PROPERTY TAX LEVY PAYABLE 2015 GENERAL LEVY GENERAL FUND $8,923,900 BUILDING CIP FUND $24,000 STREET CIP FUND $760,000 EQUIPMENT CIP FUND $540,000 INSURANCE FUND $245,000 PORT AUTHORITY OPERATING LEVY $58,000 TOTAL GENERAL LEVY $10,550,900 BONDED INDEBTEDNESS G.O. CAPITAL IMPROVEMENT PLAN (CIP) BONDS 2005A(Authorized-$211,801) $211,801 G.O. IMPROVEMENT BONDS 2006B (Authorized-$264,704) $0 G.O. PUBLIC FACILITY REFUNDING BONDS 2010B (Old 2001C) (Port Authority)(Authorized-$161,446) $161,446 G.O. IMPROVEMENT BONDS 2011A(Authorized-$4,137) $0 G.O. IMPROVEMENT BONDS 2012A(Authorized-$611) $0 G.O. IMPROVEMENT BONDS 2013A(Authorized-$4,600) $0 TOTAL BONDED INDEBTEDNESS $373,247 MARKET VALUE BASED REFERENDUMS G.O. FIRE STATION REFUNDING BONDS, 2005D (Authorized-$141,619) $0 TOTAL FIRE STATION LEVY $0 PRINCIPAL AND INTEREST ON ARMORY BONDS ARMORY ANTICIPATORY LEVIES ($2,175,853,425 x.00798% =$173,633) (As of 2/19/14) $0 (Authorized-$173,633-Only Levy Amount Due MSABC) TOTAL PRINCIPAL AND INTEREST ON ARMORY BONDS $0 GRAND TOTAL 2014 PROPERTY TAX LEVY $10,924,147 Last Updated 6/3/14 3 SPREAD LEVY COMPUTATIONAL WORKSHEET (INCLUDING FIRE STATION LEVY) (Proposed) 2012 2013 2014 2015 Total Funding Requirements 16,689,426 16,954,894 17,575,222 18,372,347 Less: Internal Revenues 6,357,600 6,495,200 6,953,800 7,448,200 Less: Market Value Based Levy-Fire Station(See Below) 0 0 0 0 (3) Equals: Revenues Needed 10,331,826 10,459,694 10,621,422 10,924,147 Add Back in State MVHC Cuts to Reflect Actual Levy 0 0 0 0 (4) Levy Certified by City to County Auditor 10,331,826 10,459,694 10,621,422 10,924,147 County Auditor Adjustments(All Subtractions): Fiscal Disparities Distribution Levy(Metro Area) 1,252,954 1,235,453 1,208,535 1,208,535 (2) Spread Levy Used to Compute Local Tax Rate 9,078,872 (1) 9,224,241 (1) 9,412,887 (1) 9,715,612 Increase/(Decrease)from Previous Year in Spread Levy 1.60% 2.05% 3.22% Market Value Based Referendum Levy-Fire Station 143,654 0 0 0 (3) (1) Actual Spread Levy Based on Numbers from Dakota County (2) 2015 Number Provided by Dakota County as of x/xx/14 (3) For 2012 Through 2015 No Levy Needed so No Impact on the Taxpayers (4)The MVHC Program was Eliminated for 2012 and Replaced with a Market Value Exclusion Program Last Updated-6/3114 y CITY OF ROSEMOUNT WORKSHEET FOR ESTIMATING RESIDENTIAL PROPERTY TAXES(ISD#196 FIGURES) (Rates Based on Proposed Final Levy Numbers) (MN Exclusion is Only Applicable to 2012 and Beyond) 176,073 (Value After M/V Exclusion) 185,665 (Value After M/V Exclusion) 203,105 (Value After MN Exclusion) 235,260 (Value After MN Exclusion) Market Value 195,700 (Payable 2013 Median) 204,500 (Payable 2014 Median) 220,500 (Est.Payable 2015 Median) 250,000 Year 2013 2014 2015 Est. 2013 2014 2015 Est. 2013 2014 2015 Est. 2013 2014 2015 Est. Tax Capacity 1,957 1,761 1,761 2,045 1,857 1,857 2,205 2,031 2,031 2,500 2,353 2,353 Tax Capacity Rates: City 0.48862 0.47676 0.44964 0.48862 0.47676 0.44964 0.48862 0.47676 0.44964 0.48862 0.47676 0.44964 County 0.33421 0.31827 0.31827 0.33421 0.31827 0.31827 0.33421 0.31827 0.31827 0.33421 0.31827 0.31827 School District 0.27956 0.27606 0.27606 0.27956 0.27606 0.27606 0.27956 0.27606 0.27606 0.27956 0.27606 0.27606 Miscellaneous 0.05884 0.05538 0.05538 0.05884 0.05538 0.05538 0.05884 0.05538 0.05538 0.05884 0.05538 0.05538 Totals 1.16123 1.12647 1.09935 1.16123 1.12647 1.09935 1.16123 1.12647 1.09935 1.16123 1.12647 1.09935 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.0023542 0.0025809 0.0025809 0.0023542 0.0025809 0.0025809 0.0023542 0.0025809 0.0025809 0.0023542 0.0025809 0.0025809 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 2014 2015 Property Taxes. City 874 839 792 920 885 835 1,004 968 913 1,160 1,122 1,058 City Taxes $885 $913 County 598 560 560 629 591 591 687 646 646 793 749 749 City Market Ref. $0 $0 School District 500 486 486 526 513 513 575 561 561 663 649 649 - Miscellaneous 105 98 98 111 103 103 121 112 112 140 130 130 Total Taxes-Median $885 $913 Total Property Taxes 2,076 1,983 1,936 2,186 2,091 2,041 2,387 2,288 2,233 2,756 2,650 2,586 Increase I(Decrease) $28 City Market Referendum 0 0 0 0 0 0 0 0 0 0 0 0 ISD#196 Market Ref 461 505 505 481 528 528 519 569 569 589 645 645 Dakota County Ref 0 0 0 0 0 0 0 0 0 0 0 0 Grand Total All Taxes $2,537 $2,488 $2,441 $2,668 $2,619 $2,569 $2,906 $2,857 $2,802 $3,344 $3,295 $3,232 289,760 (Value After MN Exclusion) 414,000 (Value After M/V Exclusion) Market Value 300,000 414,000 History of Actual Tax Capacity Rates(Using ISO#196 Rates) Year 2013 2014 2015 Est. 2013 2014 2015 Est. 2010 2011 2012 2013 2014 2015 Est. Tax Capacity 3,000 2,898 2,898 4,140 4,140 4,140 (5.69%Decrease) Tax Capacity Rates: City 0.48862 0.47676 0.44964 0.48862 0.47676 0.44964 0.43358 0.44661 0.46994 0.48862 0,47676 0.44964 (1),(2) County 0.33421 0.31827 0.31827 0.33421 0.31827 0.31827 0.27269 0.29149 0.31426 0.33421 0.31827 0.31827 (2) School District 0.27956 0.27606 0.27606 0.27956 0.27606 0.27606 0.25391 0.26959 0.28440 0.27956 0.27606 0.27606 (2) Miscellaneous 0.05884 0.05538 0.05538 0.05884 0.05538 0.05538 0.04987 0.05199 0.05562 0.05884 0.05538 0.05538 (2) Totals 1.16123 1.12647 1.09935 1.16123 1.12647 1.09935 1.01005 1.05968 1.12422 1.16123 1.12647 1.09935 City Market Referendum 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000652 0.0000697 0.0000000 0.0000000 0.0000000 0.0000000 (2) ISD#196 Market Ref 0.0023542 0.0025809 00025809 0.0023542 0.0025809 0.0025809 0.0022268 0.0022601 0.0022131 0.0023542 0.0025809 0.0025809 (2) Dakota County Ref 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000501 0.0000537 0.0000551 0.0000000 0.0000000 0.0000000 (2) Property Taxes: City 1,423 1,381 1,303 2,023 1,974 1,861 Net Tax Capacity Percentages County 973 922 922 1,384 1,318 1,318 For Residential Homesteads: School District 814 800 800 1,157 1,143 1,143 Miscellaneous 171 160 160 244 229 229 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,381 3,264 3,185 4,807 4,664 4,551 City Market Referendum 0 0 0 0 0 0 ISD#196 Market Ref 706 774 774 975 1,068 1,068 Tax Credit for Homestead Properties: (For 2002 Through 2011 Credit Applied to All Organizations Proportionately) Dakota County Ref 0 0 0 0 0 0 (Based on%of Tax Capacity) (For 2012 and On Credit Eliminated-Replaced with Market Value Adjustment) Grand Total All Taxes $4,088 $4,038 $3,960 $5,782 $5,732 $5,620 Less Than Initial Value of Tax Capacity n/a n/a n/a (2) Over Initial Value(Maximum Allowed) $304 nla n/a (2) Initial Value Used to Calculate Credit $76,000 n/a n/a (2) (1) This Figure Derived Using Figures Provided by Dakota County: (a)2014 Projected Levy Less Fiscal Disparities as of 6/2/14 9,715,612 / 21,607,660 = 0.44964 (b) Net Tax Capacity Figure as of 2119/14(With M/V Exclusion) 24,576,368 (8.33%Increase from Final Pay 2014) (c) Captured Tax Increment Tax Capacity as of xx/xx/14 (597,533) (0.00%Increase from Final Pay 2014) (d) Contribution to Fiscal Disparities as of xx/xx/14 (2,371,175) (0.00%Increase from Final Pay 2014) Last Updated-6/2/14 (2) These Figures Will Be Provided by Dakota County as of 10/xx/14 21,607,660 .�. (For 2012 and on the City of Rosemount does not have a Referendum Levy) r V Page One 2015 BUDGET WORKSHEETS GENERAL FUND REVENUES June 10,2014 2014 2015 Object 2015 2011 2012 2013 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget 101 31010.00 Current Ad Valorem Taxes $7,239,992 $6,972,330 $7,160,549 $7,480,265 $7,715,365 From County 101 31040.00 Fiscal Disparities 1,299,717 1,252,954 1,235,453 1,208,535 1,208,535 From County --- -------------------------------------Total Taxes(Tax) 8,539,709 8,225,284 8,396,002 8,688,800 8,923,900 Total Property Tax Levy for Fund 101 101 32110.00 Alcoholic Beverage Licenses(L) 38,825 38,607 37,900 38,000 38,000 101 32160.00 Licenses to do Business(L) 5,880 6,960 7,440 7,000 7,000 Garbage Haulers,Ped Licenses,etc. 101 32162.00 Lic to do Business-Rental Housing(L) 4,010 15,750 5,775 12,000 6,000 101 32210.00 Building Permit Revenue(L) 249,558 304,223 345,004 280,000 375,000 101 32212.00 Mineral Extraction Permit(L) 1,070 1,850 1,490 1,200 1,200 101 32220.00 Electrical Permit Revenue(L) 16,467 14,085 19,565 13,000 15,000 101 32221.00 Admin Fee-Electrical Permits(L) 8,274 6,678 7,260 7,000 7,000 101 32230.00 Plumbing Permit Revenue(L) 29,795 30,355 35,205 30,000 30,000 101 32240.00 Animal Licenses(L) 2,491 2,440 1,604 2,500 2,000 101 32250.00 Sewer Permit Revenue(L) 5,325 13,894 9,994 7,000 9,000 101 32255.00 County Recording Fee-City's(L) 60 100 130 100 100 101 32260.00 HVAC Permit Revenue(L) 26,270 49,402 50,375 40,000 45,000 101 32290.00 Other Non-Bus Lic&Permits(L) 590 300 390 500 500 Alarm Permits&Fireworks Permits Total Licenses&Permits(L) 388,616 484,644 522,131 438,300 535,800 101 31010.00 Current Ad Valorem Taxes(I) 86,000 86,000 86,000 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) 131,114 106,838 113,915 0 0 From County 101 31030.00 Mobile Home Taxes(I) 12,746 12,401 10,241 12,000 12,000 From County 101 31710.00 Gravel Taxes(I) 39,679 16,817 19,467 43,000 100,000 From County 101 31810.00 Franchise Taxes-Regular Fees(I) 199,067 202,501 216,687 202,000 220,000 From Cable Company 101 31811.00 Franchise Taxes-PEG Fees(I) 24,037 23,173 22,911 23,000 23,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 26,044 0 0 0 101 33416.00 Police Training Reimbursement(I) 152,637 144,515 160,129 160,000 From State 101 33416.01 Post Board Training Reimb 7,000 7,500 101 33416.02 State Aid(Tied to PERA) 143,000 152,500 101 33418.00 MSA for Streets-Maintenance(I) 30,165 32,625 32,790 32,600 32,800 From State 101 33423.00 Ag Preserves Credit(I) 1,007 1,275 3,424 1,000 2,000 From State 101 33425.00 Other State Grants&Aids(I) 38,277 51,794 38,515 30,000 35,000 From State-PERA Aid&Safe&Sober 101 33620.00 Other County Grants&Aids(I) 22,400 21,100 20,635 22,500 20,000 Dakota County Recycling Funds 101 33630.00 Police Services Levy-ISD#196(I) 62,242 62,864 63,493 64,700 65,400 101 33630.00 Liaison Funding 65,400 From ISD#196 Total Intergovernmental(I) 799,371 787,949 788,207 580,800 670,200 ------------------------ ------------------- ----------- PAGE TOTALS 9,727,696 9,497,877 9,706,340 9,707,900 10,129,900 V Page Two 2015 BUDGET WORKSHEETS GENERAL FUND REVENUES June 10,2014 2014 2015 Object 2015 2011 2012 2013 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 101 34103.00 Zoning&Subdivision Fees(C) 31,865 29,854 27,183 32,000 32,000 101 34104.00 Plan Checking Fees(C) 71,774 105,669 124,959 90,000 125,000 101 34105.00 Sales of Maps&Publications(C) 377 215 233 300 300 Maps&Spec Books 101 34108.00 Admin Fees-Other Funds(C) 95,000 101 34108.01 Applicable Funds Except Const. 25,000 25,000 25,000 25,000 25,000 101 34108.02 Construction Funds 36,093 97,462 42,456 70,000 70,000 85%of 5%Fee for Const.Projects 101 34109.00 Other Charges for Service(C) 3,981 4,939 5,094 4,500 5,000 101 34110.00 Service Chg on Returned Chks(C) 60 210 60 100 100 101 34112.00 Utility Permit Application Fee(C) 0 0 0 0 0 101 34113.00 Application Fees(C) 0 2,500 0 0 0 101 34150.00 User Fees-SKB(C) 74,655 124,362 86,115 155,000 180,000 SKB Fees-C&D Cell Fees 101 34151.00 User Fees/Host Agreements-SKB(C) 180,672 140,248 156,033 180,000 25,000 101 34151.00 Landscaping Agreement 25,000 Landscaping Agreement 101 34151.00 Trust Fund-City Portion 0 101 34152.00 User Fees-SKB(C) 10,850 15,879 17,959 20,000 20,000 SKB Fees-MSW Ash Charges 101 34153.00 User Fees-SKB(C) 167,857 145,029 167,414 170,000 300,000 SKB Fees-Base Service Charges 101 34160.00 National Guard Maint Fees(C) 45,084 49,854 54,673 46,000 46,000 101 34160.00 Shared Space Maint.Agreement 16,000 Snow Removal/Mowing 101 34160.00 Building Maintenance Contract 30,000 101 34201.00 Special Police Services(C) 25,322 12,570 11,809 19,000 19,000 Contractual O/T for Officers 101 34202.00 Fire Services-Burning Permits(C) 750 750 750 200 200 No Longer Charge for Permits 101 34203.00 Accident Reports(C) 43 2 12 0 0 101 34204.00 Day Care Inspection Fees(C) 150 150 200 200 200 101 34206.00 Other Police Services(C) 0 50 4,293 0 0 101 34207.00 Other Fire Protection Services(C) 20,209 41,146 15,751 18,000 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 2,100 101 34303.00 Mow Weeds(C) 1,580 1,696 3,339 1,500 2,000 101 34304.00 Sweep/Plow Streets(C) 733 1,149 501 500 500 101 34306.00 Other Highway&Street Rev(C) 61,031 28,954 42,022 10,000 25,000 Street Light Bills-Developers 101 34310.00 Right-of-Way Permits(C) 3,146 10,905 5,350 4,000 5,000 101 34407.00 City Share of Metro SAC Chgs(C) 1,677 2,860 2,601 2,000 2,500 --------------------------------------- Total Charges for Services(C) 762,906 841,451 793,806 848,300 900,800 101 35101.00 Court Fines(F) 123,245 129,343 106,617 125,000 125,000 From County --------- -- ------------------ Total Fines&Forfeits(F) 123,245 129,343 106,617 125,000 125,000 101 34718.00 Tournament Fees(R) 0 11,685 25,005 9,000 20,000 New Fee for 2012 101 34719.00 Player Maintenance Fees(R) 1,894 0 0 0 0 New Fee for 2011 101 34720.00 Park Reservations(R) 3,605 3,526 1,604 4,000 3,400 101 34721.00 Softball Revenues(R) 59,135 50,946 41,100 52,000 40,000 101 34724.00 Tennis Revenues(R) 1,710 2,460 2,175 2,400 2,400 101 34725.00 Tiny Tot Revenues(R) 0 0 0 0 0 Eliminated Program in 2010 101 34726.00 Rosettes Revenues(R) 2,150 1,987 2,288 2,100 2,100 101 34727.00 Field Trip Revenues(R) 7,000 101 34727.01 Youth/Teen Trips 450 300 0 400 0 101 34727.02 Adult/Senior Trips 791 5,077 8,050 4,600 7,000 101 34728.00 Adult Soccer League Revenues(R) 13,319 12,527 12,322 13,000 13,000 101 34730.00 Run for the Gold Revenues(R) 4,956 4,410 4,677 4,600 4,600 101 34731.00 Youth Soccer Lessons(R) 3,782 2,814 3,298 3,000 3,000 101 34732.00 Adult Basketball Revenues(R) 1,400 1,774 1,214 1,400 1,400 101 34733.00 Other Programs Revenues(R) 21,064 20,032 13,804 20,000 20,000 101 34735.00 Camps Revenues(R) 20,000 21,256 23,594 19,000 23,000 101 34736.00 T-Ball Lessons(R) 4,330 5,250 5,224 4,500 4,500 101 38080.00 Banquet Room Fees(R) 60,124 46,427 39,623 60,000 50,000 101 38081.00 Auditorium Fees(R) 7,981 5,480 4,444 6,000 6,000 101 38082.00 Gymnasium Fees(R) 23,098 26,943 24,173 27,000 27,000 101 38086.00 Classroom Fees(R) 7,476 8,497 8,465 8,500 8,500 101 38096.00 Liquor Provider Fees(R) 630 795 900 800 800 101 38097.00 AN Rental Fees(R) 520 1,100 710 1,000 1,000 101 38154.00 Teen Night Revenues(R) 0 750 693 0 0 101 38201.00 Rental Revenues 19,750 17,830 11,910 8,000 8,000 Steeple Center Operations 101 38203.00 Rental Revenue-Churches 500 0 0 0 0 Moved to Rental Revenues 101 38205.00 AN Rental Revenues 428 25 0 500 500 Steeple Center Operations 101 38209.00 Miscellaneous Revenues 280 93 0 0 0 Steeple Center Operations 101 38211.00 Security Services 2,050 1,050 1,729 1,000 1,000 Steeple Center Operations 101 38301.00 Rental Revenues 0 0 0 750 750 Senior/Activity Center Operations 101 38305.00 AN Rental Revenues 0 0 0 50 50 Senior/Activity Center Operations ------------------------------------------------------------------------------------- Total Recreation Fees(R) 261,422 253,033 237,001 253,600 248,000 -------------------- PAG E TOTALS 1,147,572 1,223,827 1,137,424 1,226,900 1,273,800 7- Page Three 2015 BUDGET WORKSHEETS GENERAL FUND REVENUES June 10,2014 2014 2015 Object 2015 2011 2012 2013 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 101 36101.00 Principal-Special Assessments(M) 9,244 8,369 4,470 1,000 1,000 From County-101 Funded Projects 101 36102.00 Penalties&Interest-S/A(M) 0 2 0 0 0 From County 101 36210.00 Interest Earnings-Investments(M) 189,675 94,204 90,851 85,000 90,000 _ 101 36214.00 Net Change in FV-Investments(M) 5,947 2,588 (357,024) 0 0 Annual Market Value Changes 101 36215.00 Interest Earnings(M) 610 743 147 500 500 From Checking Account 101 36220.00 Rents&Royalties(M) 18,329 19,237 15,090 12,700 13,700 _. 101 36220.01 Verizon Antenna Rent 12,700 101 36220.02 Athletic Complex Land Rental 1,000 101 36230.00 Contribution/Donations(M) 25,622 42,638 12,923 0 0 101 36260.00 Other Revenue(M) 2,785 6,369 6,084 2,000 3,000 101 36262.00 Special Settlements(M) 0 0 13,156 0 0 101 36265.00 Use of Reserve Funds(M) 0 0 0 54,600 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 AdjlAssignment 101 38090.00 City Concessions(M) 5,295 4,538 4,809 4,500 4,500 1 Total Misc Revenues(M) 257,507 178,689 (209,494) 160,300 112,700 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) 61,422 0 0 0 0 Funds Returned from Projects Total Transfers In(T) 64,922 3,500 3,500 3,500 3,500 PAGE TOTALS $322,429 $182,189 ($205,994) $163,800 $116,200 FUND TOTALS $11,197,697 $10,903,894 $10,637,770 $11,098,600 $11,519,900 INTERNAL REVENUES $2,657,988 $2,678,610 $2,241,768 $2,409,800 $2,596,000 Grand Total Less: Ad Valorem &Fiscal Disparities S Page Four 2015 BUDGET WORKSHEETS GENERAL FUND REVENUES June 10,2014 2014 2015 Object 2015 2011 2012 2013 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 9 Page One 2015 BUDGET WORKSHEETS COUNCIL June 10,2014 2014 2015 Object 2015 2011 2012 2013 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 41110 103.00 Salaries&Benefits $36,148 $36,785 $37,181 $36,800 $41,800 Salary,Taxes, PERA&Benefits 101 41110 01 225.00 Landscaping Materials 25,000 24,799 24,923 25,000 25,000 SKB Agreement,Arbor Day,etc. 101 41110 01 307.00 City Promotional Fees 16,100 101 41110 01 307.01 Newsletter 18,300 14,475 14,637 15,000 15,000 Reduce From 5 to 3 Newsletters 101 41110 01 307.02 Chamber of Commerce Directory 1,069 1,069 1,069 1,100 1,100 101 41110 01 307.03 Community Survey 0 0 0 0 0 101 41110 01 315.00 Special Programs 3,058 1,501 4,226 2,500 3,000 Promotions,Marketing,etc. 101 41110 01 319.00 Other Professional Services 24,000 101 41110 01 319.01 Education Reimbursement 15,243 4,196 7,307 12,000 12,000 101 41110 01 319.02 Intergovernmental Initiatives 0 769 0 5,000 12,000 101 41110 01 321.00 Telephone Costs 400 101 41110 01 321.02 Mayor's Cell Phone 375 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 740 5,250 4,455 5,200 6,000 101 41110 01 331.02 Miscellaneous Travel 1,453 1,564 2,043 1,600 2,000 101 41110 01 433.00 Dues&Subscriptions 26,600 101 41110 01 433.01 LMC Dues 14,957 15,562 16,126 16,000 16,700 101 41110 01 433.02 AMM Dues 6,951 7,263 7,507 7,800 7,800 101 41110 01 433.03 Dak Cty Regional Chamber 30 0 0 100 100 101 41110 01 433.04 NLC Dues 1,549 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 12,000 101 41110 01 437.01 Registration&Hotel-LMC Conf 1,619 0 394 1,700 2,000 101 41110 01 437.02 Registration&Hotel-NLC Conf 3,249 2,245 7,541 8,600 9,000 101 41110 01 437.03 Miscellaneous Conferences 964 540 0 1,000 1,000 101 41110 01 439.00 Other Miscellaneous Charges 98 21 426 300 400 101 41110 01 598.00 Council Designated 271,718 49,119 3,991 100,000 100,000 2011-Assignment for Health Ins. 101 41110 01 598.01 Library Site Expenditures 0 0 0 0 0 101 41110 01 598.02 Sales Tax Exemption Savings 0 0 0 (90,000) 0 (90,000) 101 41110 01 598.03 Salary&Benefit Contingency 0 0 0 0 0 Contingency for Negotiations 101 41110 01 599.00 Employee Recognition Costs 10,000 101 41110 01 599.01 Employee Recognition Costs 2,462 3,980 2,726 3,500 3,500 101 41110 01 599.02 Vending Machine Costs 4,358 3,907 3,874 4,000 4,000 Offset by Revenue from Machines 101 41110 01 599.03 Commemorations 1,118 775 447 1,200 1,200 101 41110 01 599.04 CommissionNolunteer Recognition 0 0 1,296 1,200 1,300 PAGE TOTALS $410,458 $176,072 $142,417 $162,600 $177,900 DEPARTMENT TOTALS $410,458 $176,072 $142,417 $162,600 $177,900 10 Page One 2015 BUDGET WORKSHEETS ADMINISTRATION June 10,2014 2014 2015 Object 2015 2011 2012 2013 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 41320 101.00 Salaries&Benefits $426,536 $415,333 $386,547 $403,500 $423,500 Salary,Taxes,PERA&Benefits 101 41320 102.00 Full-Time Overtime 0 0 0 0 0 101 41320 103.00 Part-Time Salaries&Benefits 0 8,599 0 24,700 25,000 Receptionist Contingency 101 41320 01 209.00 Other Office Supplies 0 0 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,363 1,324 1,572 1,500 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 274 288 328 700 700 101 41320 01 331.03 Miscellaneous Travel 448 289 353 500 500 101 41320 01 433.00 Dues&Subscriptions 2,600 101 41320 01 433.01 MCMA Dues 261 264 269 270 300 101 41320 01 433.02 MAMA Dues 0 0 0 0 0 101 41320 01 433.03 MCFOA Dues 35 0 35 50 100 101 41320 01 433.04 Munici-Pals 25 85 25 90 100 101 41320 01 433.05 IIMC Dues 0 0 0 200 200 City Clerk Association 101 41320 01 433.06 ICMA Dues 1,742 1,759 1,795 1,800 1,800 101 41320 01 433.07 APMP Dues 30 55 60 90 100 101 41320 01 435.00 Books&Pamphlets 61 0 0 100 100 101 41320 01 437.00 Conferences&Seminars 7,700 101 41320 01 437.01 Registration&Hotel-LMC 709 295 0 500 500 101 41320 01 437.02 Registration&Hotel-MCMA 1,318 724 1,429 1,500 1,500 101 41320 01 437.04 Staff(1)Each 0 0 0 0 0 101 41320 01 437.05 Miscellaneous Seminars (193) 0 0 300 300 ULI/Greening Initiatives 101 41320 01 437.06 Registration&Hotel-ICMA 2,059 2,998 3,399 3,000 3,400 101 41320 01 437.07 City Clerk Training 594 679 1,240 1,800 1,800 All MCFOA Events-IIMC 101 41320 01 437.08 Registration&Hotel-NLC 0 0 0 0 0 101 41320 01 437.09 Miscellaneous Meetings 209 187 89 200 200 101 41320 01 439.00 Other Miscellaneous Charges 0 200 0 200 200 101 41320 01 580.00 Other Equipment Purchases 214 73 0 200 200 PAGE TOTALS 435,687 433,150 397,141 441,500 462,400 I ) Page Two 2015 BUDGET WORKSHEETS ADMINISTRATION June 10,2014 2014 2015 Object 2015 2011 2012 2013 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 101 41320 31 305.00 Medical&Dental Fees 2,100 Employee Drug Testing 101 41320 31 305.01 Pre-Employment Physicals 1,704 525 630 600 900 101 41320 31 305.02 Employee Drug Testing 658 1,020 1,166 1,200 1,200 101 41320 31 305.03 PCORI Fees 0 0 0 0 0 101 41320 31 306.00 Personnel Testing&Recruitment 0 8,850 0 2,000 2,000 101 41320 31 315.00 Special Programs 1,500 101 41320 31 315.01 Employee Training 1,066 638 49 1,000 1,000 101 41320 31 315.02 Health&Wellness 38 50 206 500 500 Wellness&Health Management 101 41320 31 319.00 Other Professional Services 4,000 101 41320 31 319.01 Labor Consultant 0 1,318 0 500 500 101 41320 31 319.02 Labor Legal Issues 0 502 0 700 700 101 41320 31 319.04 COBRA Consultant 692 764 699 800 800 101 41320 31 319.05 FIex/VEBAAdministrative Fees 1,777 1,771 1,770 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 343 336 330 400 400 101 41320 31 341.00 Employment Advertising 972 1,100 797 1,000 1,000 Vacancies 101 41320 31 433.00 Dues&Subscriptions 600 101 41320 31 433.01 "Future Use" 0 0 0 0 0 101 41320 31 433.02 IPMA Dues 149 149 209 200 200 101 41320 31 433.03 MPELRA Dues 150 329 275 400 400 101 41320 31 435.00 Books&Pamphlets 0 40 0 100 100 Books&Training Materials 101 41320 31 437.00 Conferences&Seminars 800 101 41320 31 437.01 MPELRA State Conference 300 365 297 500 500 101 41320 31 437.02 Personnel Seminars 74 209 235 200 300 101 41320 31 437.03 Safety,Supervisor,Policy 0 0 0 0 0 101 41320 41 315.00 Special Programs 0 300 101 41320 41 315.01 General Marketing 0 200 214 500 300 101 41320 41 315.02 Historical Monuments 0 0 0 0 0 101 41320 41 319.00 Other Professional Services 4,700 101 41320 41 319.01 Website 1,100 275 3,572 3,600 4,700 . 101 41320 41 319.02 Website Improvements 10,000 0 0 0 0 101 41320 41 328.00 Cable Supply Costs 60 759 384 1,000 1,000 Cable Supplies,Software 101 41320 41 329.00 Other Communication Costs 0 0 0 47,500 101 41320 41 329.01 Cable JPA Payment-General City 42,902 54,717 44,265 46,000 47,400 101 41320 41 329.02 Video Streaming Council Mtgs 0 60 0 100 100 101 41320 41 329.03 Bulk E-Mail System 2,508 209 0 0 0 101 41320 41 331.00 Travel Expenses 25 47 32 100 100 101 41320 41 433.00 Dues&Subscriptions 60 0 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 196 40 189 500 500 PAGE TOTALS $64,774 $74,272 $55,393 $64,100 $66,800 DEPARTMENT TOTALS $500,460 $507,422 $452,534 $505,600 $529,200 12 Page One 2015 BUDGET WORKSHEETS ELECTIONS June 10,2014 2014 2015 Object 2015 2011 2012 2013 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 101 41410 01 103.00 Part-Time Salaries $0 $29,523 $0 $30,000 $0 Election Judges 101 41410 01 203.00 Printed Forms&Paper 688 117 0 200 0 Ballots&Programming 101 41410 01 208.00 Miscellaneous Supplies 0 475 0 500 0 101 41410 01 219.00 Other Operating Supplies 0 216 0 300 0 Food for Election Judges 101 41410 01 242.00 Minor Equipment 0 77 0 200 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 0 0 6,200 6,200 Elections S/W Maintenance Costs 101 41410 01 409.00 Other Contracted Repair&Maint 2,600 101 41410 01 409.01 Maintenance forAutoMarks 1,225 1,225 1,225 1,400 1,400 Voting Machines 101 41410 01 409.02 Maintenance forAccuvotes 1,000 1,000 1,000 1,200 1,200 Voting Machines 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 0 0 8,626 0 11,200 PAGE TOTALS $2,913 $32,634 $10,851 $40,000 $20,000 DEPARTMENT TOTALS $2,913 $32,634 $10,851 $40,000 $20,000 ( 3 Page One 2015 BUDGET WORKSHEETS FINANCE June 10,2014 2014 2015 Object 2015 2011 2012 2013 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 41520 101.00 Salaries&Benefits $303,823 $310,869 $319,121 $395,400 $414,300 Salary,Taxes,PERA&Benefits 101 41520 102.00 Full-Time Overtime 2,302 570 2,707 1,500 2,000 101 41520 103.00 Part-Time Salaries&Benefits 43,796 46,816 50,067 0 0 Propose Making P/T Position F/T 101 41520 01 321.00 Telephone Costs 1,293 1,324 1,429 1,400 1,500 Cell Phone Allowances(2) 101 41520 01 331.00 Travel Expense 1,300 101 41520 01 331.01 Finance Director 358 372 869 1,200 1,200 Miscellaneous(National Added) 101 41520 01 331.02 Staff 0 99 69 100 100 101 41520 01 391.00 P.C.Maintenance 63,700 101 41520 01 391.01 Civic Systems Applications Support 5,482 0 0 0 0 Moved to Utilities 101 41520 01 391.02 Citrix Maintenance Renewal 1,656 962 962 1,000 1,000 101 41520 01 391.03 Incode Software Maintenance 7,967 8,334 8,857 8,700 9,000 101 41520 01 391.04 General Network Support 20,000 20,000 20,000 20,000 20,000 Block Hours of Support Time 101 41520 01 391.06 Fixed Asset Maint Contract 1,384 1,384 1,384 1,400 1,400 101 41520 01 391.07 Miscellaneous Repairs&Maint. 1,793 2,335 1,590 2,500 2,500 101 41520 01 391.08 Anti-Virus Software Renewal 3,023 3,063 4,696 3,000 5,000 101 41520 01 391.09 File Server Software Maintenance 7,801 8,049 12,931 12,000 14,000 101 41520 01 391.10 Managed Backup Services 0 0 0 0 10,800 101 41520 01 392.00 P.C.Accessories&Supplies 3,565 3,174 2,462 4,000 4,000 City System Supplies 101 41520 01 393.00 P.C.Hardware Purchases 1,892 2,412 1,243 2,500 2,500 101 41520 01 394.00 P.C.Software Purchases 5,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 5,286 3,605 3,515 5,000 5,000 101 41520 01 409.00 Other Contracted R&M 180 180 210 200 200 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 0 27 178 50 50 101 41520 01 435.02 Finance Related Books 0 0 0 50 50 101 41520 01 437.00 Conferences&Seminars 3,300 101 41520 01 437.02 MnGFOA Annual Conf(F/D&Ass't) 571 571 571 1,000 1,000 101 41520 01 437.03 GFOA National Conf(F/D) 0 0 1,708 1,500 1,500 101 41520 01 437.04 Staff Development 0 135 0 400 400 101 41520 01 437.05 Miscellaneous Seminars 292 314 278 400 400 Misc.Meetings,Lunches,etc. 101 41520 01 439.00 Other Miscellaneous Charges 114 34 39 200 200 Contingencies 101 41520 01 570.00 Office Equipment&Furnishings 969 495 1,000 500 500 PAGE TOTALS $414,308 $415,886 $436,646 $464,800 $499,400 DEPARTMENT TOTALS $414,308 $415,886 $436,646 $464,800 $499,400 \Ll Page One 2015 BUDGET WORKSHEETS GENERAL GOVERNMENT June 10,2014 2014 2015 Object 2015 2011 2012 2013 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 101 41810 01 202.00 Duplicating&Copying $14,000 101 41810 01 202.02 Copying Costs 12,453 12,911 14,668 14,000 14,000 101 41810 01 203.00 Printed Forms&Paper 7,700 101 41810 01 203.01 Copy Paper 6,811 3,743 3,757 5,000 4,000 101 41810 01 203.02 General Receipt Books 800 573 0 800 800 101 41810 01 203.03 Purchase Orders 1,707 0 1,376 1,700 1,500 101 41810 01 203.04 Payroll&NP Checks 326 1,578 327 500 400 101 41810 01 203.06 Miscellaneous Forms 735 277 856 1,000 1,000 Business Cards,etc. 101 41810 01 204.00 Envelopes&Letterheads 2,400 101 41810 01 204.01 Letterhead 1,223 967 245 1,200 700 101 41810 01 204.02 Plain Envelopes 0 557 1,192 1,800 600 101 41810 01 204.03 NP&Payroll Envelopes 766 523 0 500 500 101 41810 01 204.04 10 x 13 Envelopes 1,202 0 0 1,200 600 101 41810 01 209.00 Other Office Supplies 14,288 14,318 13,021 15,000 14,000 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.01 "Future Use" 0 0 0 0 0 101 41810 01 242.02 Credit Card Equipment 0 1,106 0 300 500 $500-$700 for One Terminal 101 41810 01 301.00 Auditing&Accounting Services 70,000 101 41810 01 301.01 Audit&General Consulting Fees 59,383 56,932 57,547 62,000 62,000 101 41810 01 301.02 Dakota County Assessment Fees 5,456 5,614 5,955 6,000 6,000 101 41810 01 301.03 Dak Cty Truth In Taxation Costs 1,860 1,554 1,503 2,000 2,000 101 41810 01 303.00 Engineering Fees 5,402 11,738 0 0 0 101 41810 01 304.00 Legal Fees 60,931 51,637 56,703 60,000 60,000 General City Legal Fees 101 41810 01 319.00 Other Professional Services 36,000 101 41810 01 319.01 City Code Update 2,568 4,024 1,140 2,700 2,700 101 41810 01 319.02 City Code Web Fees 0 250 500 300 300 101 41810 01 319.03 State Building Report(Springsteds) 4,703 4,470 4,935 5,000 5,000 Fees Paid to Springsted 101 41810 01 319.04 Continuing Disclosure Fees 4,321 2,000 2,000 4,000 4,000 Fees Paid to Springsted(Bonds) 101 41810 01 319.05 Annual User Fee Study Update 5,710 4,780 3,695 6,000 4,000 Fees Paid to Springsted 101 41810 01 319.06 Arbitrage/Rebate Calculations 15,750 18,750 5,750 10,000 10,000 Fees Paid to Springsted(Bonds) 101 41810 01 319.10 UMore Professional Services 12,868 64,050 36,961 10,000 10,000 101 41810 01 320.00 Credit Card Activity Fees 18,800 101 41810 01 320.01 Utilities'Fees 1,675 2,127 453 0 0 - O/L Added-Moved to Utilities 101 41810 01 320.02 Parks&Recreation Fees 5,692 5,012 5,082 6,000 5,600 101 41810 01 320.03 Building Fees 16,319 12,824 10,950 15,000 12,000 101 41810 01 320.04 General Fees 1,258 1,093 1,091 1,300 1,200 101 41810 01 321.00 Telephone Costs 41,100 101 41810 01 321.01 General Phone Costs(&Internet) 43,928 41,133 36,021 34,000 30,000 Aded 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 0 6,101 7,299 8,000 9,000 Added Additional Licenses 101 41810 01 321.04 Phone System Hardware 0 0 0 2,000 2,000 Phone Upgrades,Headsets,etc. 101 41810 01 322.00 Postage Costs 16,344 16,142 13,555 17,000 15,000 101 41810 01 339.00 Other Transportation Expenses 221 954 44 800 800 Vehicle Licensing 101 41810 01 351.00 Legal Notices Publishing 3,800 101 41810 01 351.01 Costs for Public Notices 2,564 3,467 2,716 3,000 3,000 All Departments 101 41810 01 351.02 Truth in Taxation Notices 0 0 0 300 300 Newspaper Notice Publication 101 41810 01 351.03 Budget&Audit Publications 457 648 227 500 500 State Mandated Publications 101 41810 01 391.00 P.C.Maintenance 9,745 9,962 16,198 16,800 16,800 Laserfishe Maintenance 101 41810 01 392.00 P.C.Software Purchases 0 0 4,900 15,300 7,000 Laserfishe Software 101 41810 01 393.00 P.C.Hardware Purchases 0 2,707 3,825 6,600 4,000 Scanner Purchase 101 41810 01 433.00 Dues&Subscriptions 956 943 1,322 1,000 1,000 Newspapers 101 41810 01 439.00 Other Miscellaneous Charges 270 510 240 500 500 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 33,304 36,663 36,132 35,000 38,000 Office Machine Leases-All Bldgs. PAGE TOTALS $352,051 $402,695 $352,247 $374,200 $351,400 DEPARTMENT TOTALS $352,051 $402,695 $352,247 $374,200 $351,400 r 5 Page One 2015 BUDGET WORKSHEETS COMMUNITY DEVELOPMENT June 10,2014 2014 2015 Object 2015 2011 2012 2013 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 41910 101.00 Salaries&Benefits $827,265 $840,012 $865,686 $895,900 $942,000 Salary,Taxes,PERA&Benefits 101 41910 101.00 Economic Development Coor. 0 0 0 0 0 Proposed New Position 101 41910 102.00 Full-Time Overtime 1,020 407 1,339 1,000 1,000 101 41910 99 103.00 Part-Time Salaries&Benefits 2,932 2,957 2,702 4,500 10,500 101 41910 99 103.01 Planning Commission Members 4,500 101 41910 99 103.02 Part-Time Intern 6,000 101 41910 01 201.00 Office Accessories 0 0 14 0 0 Calendars,Planners,etc. 101 41910 01 202.00 Duplicating&Copying 2,234 1,788 1,346 2,500 2,500 101 41910 01 203.00 Printed Forms&Paper 765 0 270 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 106 19 144 0 0 101 41910 01 209.00 Other Office Supplies 232 71 938 600 600 Dictation Devices&Tapes 101 41910 01 219.00 Other Operating Supplies 1,110 242 1,166 1,500 1,500 101 41910 01 241.00 Small Tools 30 230 184 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 0 0 1,000 1,000 Consultant 101 41910 01 329.00 Other Communication Costs 1,871 2,036 1,890 2,500 2,500 Cell Phones&Pagers 101 41910 01 331.00 Travel Expense 350 290 314 600 600 101 41910 01 391.00 P.C.Maintenance 2,190 3,031 3,031 4,200 4,200 Permitworks Support 101 41910 01 392.00 P.C.Accessories&Supplies 0 223 0 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 0 0 1,500 1,500 Mow Weeds-From Street Maint. 101 41910 01 433.00 Dues&Subscriptions 3,400 101 41910 01 433.01 APA/AICP 1,390 1,425 1,440 1,500 1,700 101 41910 01 433.02 ICC 100 225 290 200 300 101 41910 01 433.03 AMBO 300 200 310 300 300 101 41910 01 433.04 10,000 Lakes 150 115 115 150 150 101 41910 01 433.05 "Future Use" 0 0 0 0 0 101 41910 01 433.06 Trade Magazines 85 0 0 200 0 101 41910 01 433.07 Planner's Journal 0 0 0 0 0 101 41910 01 433.08 Sensible Land Use Coalition 0 0 0 300 300 101 41910 01 433.09 AACEO/MAHCO 0 90 9 100 100 101 41910 01 433.10 Other Dues&Subscriptions 269 307 433 550 550 101 41910 01 435.00 Books&Pamphlets 549 467 294 700 700 Manuals,References,IBC Books 101 41910 01 437.00 Conferences&Seminars 7,800 101 41910 01 437.01 State Bldg Official School 365 400 423 550 500 101 41910 01 437.02 Spring&Fall Code Updates 400 400 210 400 400 101 41910 01 437.03 Building Inspector Training 669 756 961 1,000 1,000 101 41910 01 437.04 Computer Training 0 0 0 200 200 101 41910 01 437.05 Clerical Seminars 0 60 38 300 300 101 41910 01 437.06 Planning Seminars 328 320 1,102 2,000 1,800 101 41910 01 437.07 ISTS Training 150 500 390 500 500 101 41910 01 437.08 State Planning Conference(2) 1,258 589 2,092 1,400 2,000 101 41910 01 437.09 Planning Commissioner Training 82 435 135 500 500 101 41910 01 437.10 Gent Seminars 150 354 0 300 300 101 41910 01 437.11 Code Enforcement Training 44 0 0 450 300 101 41910 01 439.00 Other Miscellaneous Charges 0 0 165 400 400 Contingencies PAGE TOTALS $846,393 $857,950 $887,430 $929,300 $981,700 DEPARTMENT TOTALS $846,393 $857,950 $887,430 $929,300 $981,700 I 1 Page One 2015 BUDGET WORKSHEETS POLICE June 10,2014 2014 2015 Object 2015 2011 2012 2013 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 42110 101.00 Salaries&Benefits $2,356,994 $2,416,057 $2,514,144 $2,636,700 $2,810,900 Salary,Taxes,PERA&Benefits 101 42110 102.00 Full-Time Overtime 75,223 67,587 94,077 72,500 72,500 101 42110 102.01 Regular Overtime Hours 53,500 COLA&Explorer Post Time 101 42110 102.02 Contracted OIT 19,000 101 42110 103.00 Part-Time Salaries&Benefits 61,600 101 42110 22 103.00 Part-Time Receptionist(2) 50,322 56,194 0 0 0 Made 1 FIT Position for 2014 101 42110 23 103.00 Part-Time Secretary 14,530 12,194 12,686 21,500 19,000 P/T Secretary-10.25 Hours/Wk 101 42110 95 103.00 Part-Time CSO's 33,759 28,286 32,980 41,900 42,600 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 975 1,442 1,745 1,200 1,500 Cost Increases Evid.Logs,Animal 101 42110 01 204.00 Envelopes&Letterheads 388 0 8 200 200 Business Cards 101 42110 01 207.00 Training&Instructional Supplies 11,600 101 42110 01 207.01 Practice Ammunition 4,963 4,898 3,003 5,250 5,250 101 42110 01 207.02 Service Ammunition 546 1,042 815 1,000 1,000 101 42110 01 207.03 Other Supplies 27 233 787 100 100 101 42110 01 207.04 M.A.A.G.Ammunition 4,920 4,999 4,951 5,250 5,250 101 42110 01 208.00 Miscellaneous Supplies 0 Donated&Forfeited Funds 101 42110 01 208.01 DARE Donations 156 226 285 0 0 101 42110 01 208.02 Equipment Donations/Forfeitures 6,875 6,489 6,465 0 0 101 42110 01 209.00 Other Office Supplies 245 456 1,518 1,000 1,000 Videos&CD's 101 42110 01 211.00 Cleaning Supplies 500 101 42110 01 211.01 Blanket Cleaning 0 0 0 0 0 101 42110 01 211.02 Squad Interior Cleaning 321 107 235 500 500 101 42110 01 217.00 Clothing Allowance 2,800 101 42110 01 217.01 CSO's 1,661 900 420 750 800 101 42110 01 217.02 Reserves 550 998 1,796 1,000 1,000 101 42110 01 217.03 Other Supplies 1,860 1,335 4,256 750 1,000 101 42110 01 219.00 Other Operating Supplies 3,000 101 42110 01 219.01 Evidence Bags,Drug Kits,Misc. 983 1,319 420 2,000 2,000 101 42110 01 219.02 Accurint Database Services 871 740 600 1,000 1,000 101 42110 01 221.00 Equipment Parts 3,199 2,965 3,025 3,000 3,000 Squad Emergency Equip Repairs 101 42110 01 241.00 Small Tools 3,900 Crime Scene Kit Supplies 101 42110 01 241.01 Evidence Processing Equipment 1,084 725 572 800 800 101 42110 01 241.02 Camera and Video Supplies 1,140 1,229 1,141 2,000 2,000 Squad Camera Maintenance 101 42110 01 241.03 Digital Recorder Warranty 407 433 728 1,100 1,100 101 42110 01 242.00 Minor Equipment 1,500 101 42110 01 242.01 Less Lethal Tactical Equipment 937 0 754 1,000 1,000 Training Supplies,Taser Batteries 101 42110 01 242.02 MAAG Equipment 688 0 0 500 500 101 42110 01 304.00 Legal Fees 57,780 59,802 59,570 62,500 63,800 Prosecution-2%Increase 101 42110 01 305.00 Medical&Dental Fees 2,000 101 42110 01 305.01 Physicals 380 623 1,044 1,000 1,000 101 42110 01 305.02 Seized Narcotic Testing 427 85 773 1,000 1,000 Blood Draws 101 42110 01 306.00 Personnel Testing&Recruitment 1,329 425 1,551 1,000 1,000 Medical&Psychological 101 42110 01 313.00 Temporary Service Fees 14 458 787 800 800 Interpreter Services 101 42110 01 315.00 Special Programs 0 0 0 0 0 101 42110 01 316.00 Animal Care Services 3,100 101 42110 01 316.01 Impound&Care Fees 7,632 3,078 3,000 3,100 3,100 101 42110 01 316.02 "Future Use" 0 0 0 0 0 101 42110 01 319.00 Other Professional Services 370,300 101 42110 01 319.01 Dispatch Services-Operations 307,043 290,111 338,376 354,700 368,500 101 42110 01 319.02 Policy Development&Training 6,850 2,650 0 800 800 101 42110 01 319.03 Mediation Services 0 0 0 1,000 1,000 101 42110 01 321.00 Telephone Costs 5,400 101 42110 01 321.01 Cell Phones 5,137 5,150 4,865 5,400 5,400 101 42110 01 321.03 "Future Use" 0 0 0 0 0 101 42110 01 323.00 Radio Units 14,300 101 42110 01 323.01 Radios 10,674 10,239 8,437 11,500 11,800 800 MHz Subscriber Fees(+1 Radio) 101 42110 01 323.02 Radars 0 0 0 500 500 Radar&LIDAR Repairs 101 42110 01 323.03 Radio Warranty 0 0 1,703 2,000 2,000 Warranty Radio Increase 101 42110 01 331.00 Travel Expense 4,500 101 42110 01 331.01 MN Chiefs Spring Conference 271 384 395 500 500 101 42110 01 331.02 IACP or FBINAA Conference 0 0 0 2,000 2,000 101 42110 01 331.03 Outstate Investigations&Conf. 352 520 43 500 500 101 42110 01 331.04 MAAG Conference 380 0 660 600 600 101 42110 01 331.05 CAN-AM Narcotic Conference 318 237 394 300 300 101 42110 01 331.06 Juvenile Officers Conference 440 661 244 500 500 101 42110 01 331.07 Meeting Reimbursements 139 99 134 100 100 ---------------------------- ----------- ---- PAGE TOTALS 2,962,788 2,985,375 3,109,386 3,250,800 3,439,200 I--/-' Page Two 2015 BUDGET WORKSHEETS POLICE June 10,2014 2014 2015 Object 2015 2011 2012 2013 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 101 42110 01 333.00 Freight&Express Expenses 13 19 46 200 200 Repairs 101 42110 01 394.00 P.C.Software Purchases 41,700 101 42110 01 394.01 Automated Pawn System 204 204 204 300 300 101 42110 01 394.02 Pictometry 1,538 0 0 0 0 In Public Works Budget 101 42110 01 394.03 CJIIN/Pro Phoenix System 11,610 7,314 7,385 37,000 41,400 CJIIN/ProPhoenix RMS(25%Prop) 101 42110 01 396.00 Computer Maintenance 36,800 101 42110 01 396.01 LOGIS Apps Support 33,120 33,852 36,264 3,000 3,700 LOGIS APS Support(21%Inc.) 101 42110 01 396.02 CJDN Connection Charges 2,520 4,509 2,981 2,800 2,800 State of MN CJDN Connection 101 42110 01 396.03 MCD Connection Charges 1,845 0 1,384 2,100 2,100 LOGIS MDC Connection Chgs. 101 42110 01 396.04 MCD Maintenance&Cellular 18,432 17,557 20,084 21,000 25,000 23%Increase 101 42110 01 396.05 LOGIS Fees/Development 7,890 8,188 8,288 4,600 3,200 Development Fund(31%Dec.) 101 42110 01 433.00 Dues&Subscriptions 10,200 101 42110 01 433.01 Multi-Agency Assistance Group-MAAG 3,200 5,000 5,000 8,300 8,300 MAAG Equipment CIP Increase 101 42110 01 433.02 IACP Chiefs 170 120 120 175 175 101 42110 01 433.03 MN Chiefs of Police 265 0 290 265 265 101 42110 01 433.04 Dakota Cty Chiefs of Police 0 50 320 330 330 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 50 50 0 50 50 101 42110 01 433.09 MN Crime Prevention Association 0 60 60 65 65 101 42110 01 433.10 P.O.S.T.Licenses 360 1,080 639 700 700 101 42110 01 433.11 FBI Nat'l Academy Association 0 0 75 75 75 Chief's Membership 101 42110 01 433.12 Miscellaneous 35 225 171 220 220 101 42110 01 435.00 Books&Pamphlets 0 0 887 1,000 1,000 Crime Prevention Materials 101 42110 01 436.00 Towing Charges 168 103 0 200 200 Disabled Squads Disabled Squads 101 42110 01 437.00 Conferences&Seminars 15,500 101 42110 01 437.01 Firearms-Range 2,113 4,790 2,299 4,000 4,000 Range Rental 101 42110 01 437.02 Chiefs Spring Conference 420 375 20 500 500 101 42110 01 437.03 Investigations 921 1,032 1,103 1,200 1,200 101 42110 01 437.04 IACP Conference 0 0 352 300 300 101 42110 01 437.05 Supervision 25 8,875 198 2,000 2,000 Personnel Development 101 42110 01 437.06 Use of Force 2,380 0 736 1,000 1,000 101 42110 01437.07 Emergency Driving 1,730 675 225 1,000 3,000 Driving School Cost Increase 101 42110 01437.08 First Aid 400 250 500 400 400 101 42110 01 437.09 Narcotic Enforcement 100 100 0 200 200 101 42110 01 437.10 Tactical 1,450 1,750 213 1,000 1,000 101 42110 01 437.11 Support Services 123 555 240 200 200 101 42110 01 437.12 Patrol Ops. 820 660 1,848 1,500 1,500 101 42110 01 437.13 Emergency Management 0 755 224 200 200 101 42110 01 439.00 Other Miscellaneous Charges 187 808 265 500 500 Refreshments for Meetings& Compliance Checks 101 42110 01 580.00 Other Equipment Purchases 0 0 0 2,500 2,500 3 Chairs&Desk -------- --------- - --- ------- ---- --- PAGE TOTALS $92,090 $98,957 $92,422 $98,900 $108,600 DEPARTMENT TOTALS $3,054,877 $3,084,331 $3,201,808 $3,349,700 $3,547,800 l B Page One 2015 BUDGET WORKSHEETS FIRE June 10,2014 2014 2015 Object 2015 2011 2012 2013 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 42210 103.00 Salaries&Benefits $56,593 $110,441 $155,420 $172,000 $172,000 Salary,Taxes,PERA&Benefits 101 42210 103.01 Salaries 32,000 101 42210 103.02 Training Pay/Stipends 0 101 42210 103.03 Call Pay/Stipends 140,000 101 42210 103.04 Class Pay/Stipends 0 101 42210 01 202.00 Duplicating&Copying 100 101 42210 01 202.01 Copy Toner 0 0 0 50 50 101 42210 01 202.02 Computer Printers 97 77 0 50 50 101 42210 01 204.00 Envelopes&Letterhead 100 101 42210 01 204.01 Envelopes 0 0 0 25 25 101 42210 01 204.02 Letterhead 0 0 0 25 25 101 42210 01 204.03 Forms 293 106 0 50 50 101 42210 01 211.00 Cleaning Supplies 800 101 42210 01 211.01 Soaps 835 358 885 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 0 0 150 150 101 42210 01 218.00 Fire Department Clothing 1,013 1,152 2,100 101 42210 01 218.01 Uniforms 0 0 2,923 1,000 1,500 5 Uniforms @$200 Each 101 42210 01 218.02 Station Wear(2015) 0 0 449 400 600 Next-2015 101 42210 01 219.00 Other Operating Supplies 5,100 Medical Supplies 101 42210 01 219.01 Gloves 535 1,105 692 1,000 1,000 101 42210 01 219.02 Bandages 0 0 0 100 100 101 42210 01 219.03 Equipment 2,076 365 1,564 1,000 1,000 101 42210 01 219.04 Tyvek Suits 0 0 0 100 100 101 42210 01 219.05 Consummable Medical 3,531 1,301 2,174 2,200 2,500 Added 02 Cascade @ FS#2 101 42210 01 219.06 Oxygen 175 198 126 400 400 101 42210 01 229.00 Other Maintenance Supplies 700 101 42210 01 229.01 Vehicle Repairs 0 419 0 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,576 0 300 300 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 0 0 113 300 300 101 42210 01 230.03 Lanterns&Miscellaneous 908 566 1,808 300 300 101 42210 01 230.04 Small Tool Repairs 734 1,258 241 600 600 101 42210 01 230.05 Opticom 0 0 0 100 100 101 42210 01 230.06 Station 339 910 0 100 100 101 42210 01 241.00 Small Tools 700 101 42210 01 241.01 Axes,Bars&Other 354 0 15 150 150 101 42210 01 241.02 Grass Fire 166 0 0 250 250 101 42210 01 241.03 Hand Tools 673 101 338 300 300 101 42210 01 305.00 Medical&Dental Fees 3,339 3,377 3,120 3,800 3,800 Annual Medical Tests 101 42210 01 306.00 Personnel Testing&Recruitment 3,200 101 42210 01 306.01 New Physicals(4) 2,237 1,004 1,942 1,600 2,000 New Hires 101 42210 01 306.02 Hepatitis Shots(4) 0 131 0 500 500 101 42210 01 306.03 Background Checks(4) 122 146 183 100 500 101 42210 01 306.04 Drug Testing(4) 0 0 0 200 200 101 42210 01 308.00 Instructors'Fees 9,000 101 42210 01 308.01 Fire Fighter 1 (4) 449 468 1,015 1,600 1,600 101 42210 01 308.02 Fire Fighter 1 Certificates(4) 225 375 75 280 280 101 42210 01 308.03 Fire Fighter Re-Certificates(14) 360 140 320 280 280 101 42210 01 308.04 First Responder(4) 1,200 777 0 1,000 1,000 101 42210 01 308.05 First Responder Refresher(1/2) 0 1,200 1,350 1,400 1,400 101 42210 01 308.06 Outside Schools 3,065 6,452 879 3,300 3,300 101 42210 01 308.07 Haz-Mat Training(4) 0 0 1,675 1,000 1,000 101 42210 01 308.08 Other Re-Certificates(2) 60 0 0 140 140 PAGE TOTALS 79,378 134,002 177,305 197,300 199,100 19 Page Two 2015 BUDGET WORKSHEETS FIRE June 10,2014 2014 2015 Object 2015 2011 2012 2013 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 101 42210 01 310.00 Testing Services 2,700 101 42210 01 310.01 Aerial 1,188 1,172 750 1,000 1,000 101 42210 01 310.02 Ladders 0 0 436 500 500 101 42210 01 310.03 Pumpers(3)(Next 2014) 0 675 675 1,200 1,200 101 42210 01 310.04 SCBA Hydro Testing(Next 2016) 0 0 0 0 0 101 42210 01 313.00 Temporary Service Fees 13,600 101 42210 01 313.01 SCBA Maintenance 4,771 8,182 3,105 4,000 4,500 Added SCBA Compressor-FS#2 101 42210 01 313.02 SCBA Flow Test 0 247 780 2,000 2,500 Added SCBA Compressor-FS#2 101 42210 01 313.04 Security Contract 641 587 610 800 800 101 42210 01 313.05 SOT Joint Powers 2,605 3,496 5,770 5,800 5,800 101 42210 01 314.00 Annual Fire Relief Contribution 166,000 171,000 171,000 171,000 138,000 101 42210 01 319.00 Other Professional Services 2,200 Fire Prevention Education 101 42210 01 319.01 School Literature 461 0 0 400 400 101 42210 01 319.02 Door Prizes 150 10 0 200 200 101 42210 01 319.03 Fire Prevention Week Promos 703 1,182 408 700 700 101 42210 01 319.04 Food at Open House 350 277 141 300 300 101 42210 01 319.05 Summer Park Education 0 309 0 0 0 101 42210 01 319.06 National Night Out 621 98 539 600 600 101 42210 01 321.00 Telephone Costs 4,300 101 42210 01 321.01 Cell Phones 802 2,050 2,481 300 2,500 Active 911 Subscriptions 101 42210 01 321.02 Computer Cards 44 0 0 1,800 1,800 101 42210 01 321.03 "Future Use" 88 0 0 0 0 101 42210 01 321.04 Numeric Pagers 0 0 0 0 0 101 42210 01 322.00 Postage Costs 0 258 0 100 100 UPS Costs 101 42210 01 329.00 Other Communication Costs 17,000 101 42210 01 329.01 Base Repairs 0 159 0 300 300 101 42210 01 329.02 Pager Repairs 282 608 835 1,000 1,000 101 42210 01 329.03 Hand Held Repairs 252 605 72 300 300 101 42210 01 329.04 Mobile Repairs 0 0 560 200 200 101 42210 01 329.05 800 MHZ User Fee 10,604 9,769 9,555 14,000 14,000 101 42210 01 329.06 Mobile Computers 0 371 937 1,200 1,200 Monthly Air Time Fees 101 42210 01 331.00 Travel Expense 3,900 101 42210 01 331.01 Minnesota Chiefs Conference 854 2,500 1,083 2,000 2,000 101 42210 01 331.02 Fire Department Association 1,572 1,647 0 1,600 1,600 101 42210 01 331.03 Outside Schools 168 0 0 300 300 101 42210 01 333.00 Freight&Express Expense 0 0 0 0 0 101 42210 01 433.00 Dues&Subscriptions 1,500 101 42210 01 433.01 Capital City 50 50 50 50 50 101 42210 01 433.02 VFBA Insurance 305 361 287 350 350 101 42210 01 433.03 State Fire 710 720 318 725 725 101 42210 01 433.04 State Chiefs 0 291 0 250 250 101 42210 01 433.05 DCFC 75 75 0 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 900 101 42210 01 437.01 State Fire Conference 0 0 0 400 400 101 42210 01 437.02 State Chiefs Conference 487 630 440 500 500 101 42210 01 439.00 Other Miscellaneous Charges 2,400 101 42210 01 439.01 Food&Coffee 664 480 565 700 700 101 42210 01 439.02 Extinguisher 559 692 356 550 550 101 42210 01 439.03 Plaques 221 51 30 50 50 101 42210 01 439.04 Paint 360 0 0 100 100 101 42210 01 439.05 Station Needs 5,419 880 737 1,000 1,000 101 42210 01 580.00 Other Equipment Purchases 23,600 101 42210 01 580.01 Bunker Gear(8) 17,423 19,067 13,549 18,600 18,600 101 42210 01 580.02 Pagers 0 0 0 2,000 2,000 Replacements 101 42210 01 580.03 Hose&Fittings 1,719 2,901 6,904 1,000 1,000 101 42210 01 580.04 Replace Damaged Items 4,760 380 2,502 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 7,196 19,900 1,866 0 0 Donation Items PAGE TOTALS $232,151 $251,729 $227,391 $240,000 $210,200 DEPARTMENT TOTALS $311,529 $385,731 $404,696 $437,300 $409,300 20 Page One 2015 BUDGET WORKSHEETS GOVERNMENT BUILDINGS June 10,2014 2014 2015 Object 2015 2011 2012 2013 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 41940 101.00 Salaries&Benefits $68,900 Salary,Taxes,PERA&Benefits 101 41940 79 101.01 Facility Specialist 0 26,690 72,144 73,900 68,900 80%of F/T Person 101 41940 102.00 Full-Time Overtime 0 513 1,791 0 0 101 41940 01 208.00 Miscellaneous Supplies 16,542 16,726 19,744 17,000 17,000 Cleaning,Paper Prod.,Coffee 101 41940 01 219.00 Other Operating Supplies 0 1,754 1,980 2,000 2,000 Flags 101 41940 01 223.00 Building Repair Supplies 13,423 14,961 7,881 13,000 13,000 Light Bulbs,Locks,etc. 101 41940 01 225.00 Landscaping Materials 941 1,122 1,614 1,500 1,500 Trees&Shrubs(CH in 2014) 101 41940 01 241.00 Small Tools 228 262 276 200 300 Hand Tools,Bits,Blades,etc. 101 41940 01 242.00 Minor Equipment 1,996 1,341 829 2,000 2,000 Equipment Replacement 101 41940 01 302.00 Architects'Fees 0 0 0 0 0 Estimates 101 41940 01 318.00 Contract Engineer 1,750 2,000 2,500 1,800 6,400 101 41940 01 319.00 Other Professional Services 85,300 101 41940 01 319.01 Elevator Maintenance 1,832 1,853 3,110 2,000 2,000 101 41940 01 319.02 Heating/Cooling Maint Contract 6,167 8,637 5,336 9,000 9,000 Includes all City Facilities 101 41940 01 319.03 Annual Boiler Inspections/Maint. 647 50 75 800 800 101 41940 01 319.04 Pest Control 2,505 3,051 2,821 3,000 3,000 101 41940 01 319.05 Fire Extinguishers 1,135 1,397 1,859 1,800 1,800 101 41940 01 319.06 Fire Suppression System Check 3,033 3,375 3,400 3,500 3,500 101 41940 01 319.07 Janitorial Service-Fire Stations 10,016 9,896 10,016 10,100 10,200 New Contractor in 2014 101 41940 01 319.08 Janitorial Service-P.W.Building 10,529 10,529 10,529 10,600 10,700 New Contractor in 2014 101 41940 01 319.09 Janitorial Service-City Hall 24,534 26,446 26,266 26,500 26,700 New Contractor in 2014 101 41940 01 319.10 Floor Mats-Monthly Charges 3,578 3,474 4,361 4,000 4,500 101 41940 01 319.11 Other Janitorial Services 6,946 8,211 11,468 9,200 12,000 Wax Firs,Carpet Cing,Windows 101 41940 01 319.12 Annual Monument Maintenance 800 1,025 1,025 1,000 1,100 $900-$1200(Hot Wax) 101 41940 01 321.00 Telephone Costs 0 0 447 700 700 Air Card for iPad-Monthly Chgs 101 41940 01 381.00 Electric Utilities 66,212 68,950 75,732 77,000 77,000 101 41940 01 383.00 Gas Utilities 51,688 44,796 63,594 55,000 65,000 101 41940 01 384.00 Refuse Disposal 37,000 101 41940 01 384.01 General Buildings&Parks 18,377 18,480 18,982 20,000 20,000 Add UMore in 2014 101 41940 01 384.02 Recycling/Cleanup 13,535 15,597 14,484 17,000 17,000 Increased Recycling Costs 101 41940 01 393.00 P.C.Hardware Purchases 0 0 850 0 0 iPad in 2013 101 41940 01 401.00 Contracted Building Repairs 52,000 101 41940 01 401.01 Electrical Repairs 3,027 5,740 7,293 4,000 4,000 101 41940 01 401.02 Siren Replacement Program 311 9,949 3,688 10,000 10,000 101 41940 01 401.03 Miscellaneous Repairs 27,419 35,544 35,205 38,000 38,000 Garage Doors,HVAC,etc. 101 41940 01 401.04 Roof Inspections 0 210 0 0 0 101 41940 01 402.00 Security Card System Maintenance 0 0 0 0 2,500 Annual Service and Maintenance 101 41940 01 439.00 Other Miscellaneous Charges 0 7,154 5,950 5,000 5,000 Energy Efficiency Improvements 101 41940 01 530.00 Improvements Other Than Buildings 69,944 76,000 60,000 85,000 85,000 Next 10-Yr Average Expenditures 101 41940 01 601.00 Bond Principal 60,526 490,526 65,368 0 0 Will Be Paid from Assigned Funds 101 41940 01 611.00 Bond Interest 24,973 22,416 19,629 0 0 Will Be Paid from Assigned Funds 101 41940 01 621.00 Bond Paying Agent Fees 0 775 0 0 0 PAGE TOTALS $442,613 $939,448 $560,247 $504,600 $520,600 DEPARTMENT TOTALS $442,613 $939,448 $560,247 $504,600 $520,600 21 Page One 2015 BUDGET WORKSHEETS FLEET MAINTENANCE June 10,2014 2014 2015 Object 2015 2011 2012 2013 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 43100 101.00 Salaries&Benefits $191,700 Salary,Taxes,PERA&Benefits 101 43100 77 101.00 Administrative 11,876 14,275 10,586 11,000 11,300 101 43100 78 101.00 Technical/Clerical 0 3,456 9,415 10,100 10,400 101 43100 79 101.00 Maintenance 152,060 154,723 158,351 164,600 170,000 101 43100 102.00 Full-Time Overtime 619 0 1,117 3,000 3,000 101 43100 01 211.00 Cleaning Supplies 1,577 2,470 4,378 2,000 2,000 Shop&Vehicles 101 43100 01 212.00 Motor Fuels 174,864 194,475 201,394 215,000 210,000 Price Estimate 101 43100 01 213.00 Lubricants&Additives 10,546 15,772 13,231 15,000 15,000 Price Increase 101 43100 01 215.00 Shop Materials 19,779 15,412 19,270 17,000 20,000 101 43100 01 221.00 Equipment Parts 147,760 140,223 103,190 145,000 145,000 101 43100 01 222.00 Tires 22,830 27,752 24,375 25,000 30,000 101 43100 01 241.00 Small Tools 2,195 2,387 4,249 3,000 3,000 101 43100 01 242.00 Minor Equipment 4,703 3,714 2,544 4,000 4,000 101 43100 01 318.00 Contract Engineer 3,500 4,000 5,000 3,500 12,600 101 43100 01 321.00 Telephone Costs 0 0 0 0 0 101 43100 01 323.00 Radio Units(Warranty&Batteries) 4,645 605 1,830 1,000 1,000 101 43100 01 384.00 Refuse Disposal 25 0 0 300 300 Shop Hazardous Waste 101 43100 01 394.00 P.C.Software Purchases 1,892 6,500 101 43100 01 394.01 Licensing&Maintenance 1,670 1,646 1,800 2,000 CarteGraph 101 43100 01 394.02 Online Subscriptions 1,500 1,997 2,700 3,000 ALLDATA/Cummings/CAT/Detroit 101 43100 01 394.03 New Software Purchases 0 1,860 1,500 1,500 Detroit Diesel Software 101 43100 01 404.00 Contracted Mach&Equip Repairs 37,962 51,265 53,837 50,000 101 43100 01 404.01 Contracted Repairs 0 0 0 40,000 40,000 Aging Equipment,FD Units 101 43100 01 404.02 Contracted Preventative Maint. 0 0 0 10,000 10,000 Power Wash All,Paint#8419 101 43100 01 416.00 Machinery Rental 0 0 0 1,000 500 101 43100 01 417.00 Uniforms Rental 181 0 0 0 0 101 43100 01 433.00 Dues&Subscriptions 1,500 0 0 100 100 DOT Certification 101 43100 01 435.00 Books&Pamphlets 273 87 195 100 200 DOT Decals and Inspection Pads 101 43100 01 437.00 Conferences&Seminars 247 113 90 300 300 PAGE TOTALS $599,035 $633,899 $618,556 $677,000 $695,200 DEPARTMENT TOTALS $599,035 $633,899 $618,556 $677,000 $695,200 22 Page One 2015 BUDGET WORKSHEETS STREET MAINTENANCE June 10,2014 2014 2015 Object 2015 2011 2012 2013 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 43121 101.00 Salaries&Benefits $523,700 Salary,Taxes,PERA&Benefits 101 43121 77 101.00 Administrative 35,630 38,790 21,172 22,000 22,600 101 43121 78 101.00 Technical/Clerical 47,215 49,966 51,712 53,800 55,300 101 43121 75 101.00 Maintenance 426,887 436,567 408,540 432,100 445,800 101 43121 102.00 Full-Time Overtime 10,055 4,112 10,343 14,000 14,000 Maintenance 101 43121 90 103.00 Part-Time Salaries&Benefits 16,553 17,652 21,958 20,000 20,000 Includes Funds for Horticulturist 101 43121 01 201.00 Office Accessories 0 171 500 100 100 101 43121 01 203.00 Printed Forms&Paper 200 101 43121 01 203.01 R/W Permit&Inspection Forms 0 0 0 200 200 101 43121 01 203.03 City Specification Books 0 0 0 0 0 101 43121 01 205.00 Drafting Supplies 900 101 43121 01 205.01 Plotter Ink and Paper 752 114 1,275 500 500 Split with 101-45202-01-205.00 101 43121 01 205.02 Off-Site Reproductions 0 147 160 400 400 101 43121 01 209.00 Other Office Supplies 0 70 1,480 500 500 101 43121 01 216.00 Chemical&Chemical Products 77,386 102,846 128,197 100,000 103,000 101 43121 01 224.00 Street Maintenance Materials 13,300 101 43121 01 224.01 Paint 738 343 403 500 500 101 43121 01 224.02 Mail Boxes 2,955 1,133 1,757 1,500 1,500 101 43121 01 224.03 Light Bulbs/Lenses 20 647 51 800 800 Replace with LED Bulbs 101 43121 01 224.04 Holiday Decorations 0 0 3,818 5,000 10,500 Contracted Tree Lighting 101 43121 01 225.00 Landscaping Materials 15,500 101 43121 01 225.01 Turf Restoration Material 235 622 445 3,500 3,500 101 43121 01 225.02 Seed 1,572 844 186 0 0 101 43121 01 225.03 Black Dirt 923 1,315 599 0 0 101 43121 01 225.04 Trees 2,990 975 155 500 500 101 43121 01 225.05 Planters&Brackets 3,638 4,087 2,868 5,000 3,500 101 43121 01 225.06 Entrance Monuments 656 4,508 200 2,000 1,500 101 43121 01 225.07 Downtown Planters 1,575 1,658 1,973 1,600 2,000 101 43121 01 225.08 Park Signs&RCC 1,112 1,905 2,331 2,000 2,500 101 43121 01 225.09 Library/Steeple Center 0 0 0 1,500 1,500 101 43121 01 225.10 Banners/Flag Components 0 492 0 800 500 101 43121 01 226.00 Sign Repair Materials 13,682 4,475 4,069 6,000 6,000 Solar Batteries for Signs/Lights 101 43121 01 231.00 Bituminous Patching Materials 39,430 44,731 26,784 37,500 37,500 101 43121 01 232.00 Crushed Rock 30,236 32,737 32,206 32,500 30,000 1/2 Mile of Bacardi Paved in 2014 101 43121 01 233.00 Dust Control Materials 24,848 25,000 26,188 30,000 30,000 Bonaire/Akron-FHR Fields 101 43121 01 234.00 De-Icing Sand/Rock 2,853 486 6,435 3,000 3,000 Gravel Road Ice Control 101 43121 01 235.00 Shouldering Gravel 0 257 0 0 0 101 43121 01 241.00 Small Tools 658 1,350 632 1,000 1,000 Shovels,Brooms,etc. 101 43121 01 242.00 Minor Equipment 2,095 1,723 6,490 3,000 3,000 Safety Equipment/Power Tools 101 43121 01 303.00 Engineering Fees 40,096 11,602 26,913 10,000 10,000 General Non-Project Related 101 43121 01 304.00 Legal Fees 0 1,196 0 0 0 101 43121 01 305.00 Medical&Dental Fees 0 0 0 0 0 101 43121 01 310.00 Testing Services 56 0 0 0 0 101 43121 01 313.00 Temporary Service Fees 9,706 0 0 0 0 101 43121 01 318.00 Contract Engineer 7,000 8,000 10,000 7,000 25,000 101 43121 01 319.00 Other Professional Services 114 0 0 5,000 101 43121 01 319.01 Random Drug Testing 0 (64) 0 0 0 101 43121 01 319.02 GIS Consulting Services 0 1,672 344 5,000 5,000 101 43121 01 321.00 Telephone Costs 2,812 2,814 2,623 3,000 3,000 Includes Wireless Technology 101 43121 01 323.00 Radio Units 1,211 1,116 1,045 1,500 1,500 24 Units @$300(Split 5 Ways) 101 43121 01 324.00 Messenger Services 0 0 0 0 0 101 43121 01 331.00 Travel Expense 0 38 6 500 200 101 43121 01 381.00 Electric Utilities 173,000 101 43121 01 381.01 Street Lights 170,065 166,887 174,559 170,000 170,000 101 43121 01 381.02 Signal Lights&Sirens 3,003 2,648 2,680 3,500 3,000 101 43121 01 384.00 Refuse Disposal 1,400 101 43121 01 384.01 Hazardous Waste Disposal 463 457 0 500 500 101 43121 01 384.02 Roadside Garbage 231 517 572 900 900 101 43121 01 384.03 Tree Disposal 0 0 0 0 0 101 43121 01 391.00 P.C.Maintenance 10,800 101 43121 01 391.03 Pavement Management Syst Sup 10,254 3,713 8,977 10,000 10,000 101 43121 01 391.04 R-O-W Permit On-Line Service 4,800 5,296 536 800 800 New County Online Permiting 101 43121 01 392.00 P.C.Accessories&Supplies 320 0 0 0 0 101 43121 01 393.00 P.C.Hardware Purchases 0 1,800 2,093 3,000 1,000 101 43121 01 394.00 P.C.Software Purchases 4,574 7,200 101 43121 01 394.01 Licensing&Maintenance 4,779 4,212 6,500 6,200 CarteGraph,GIS 101 43121 01 394.02 Online Subscriptions 308 286 800 800 Pictometry 101 43121 01 394.03 New Software Purchases 2,031 235 500 200 - -------------- - ----------- PAGE TOTALS 999,396 994,531 998,009 1,004,800 1,039,800 23 Page Two 2015 BUDGET WORKSHEETS STREET MAINTENANCE June 10,2014 2014 2015 Object 2015 2011 2012 2013 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 101 43121 01 402.00 Parking Lot Maintenance 0 25,000 25,000 65,000 55,000 Next 10-Yr Average Expenditures 101 43121 01 403.00 Contracted Repair&Maintenance 21,500 101 43121 01 403.01 Street Lights 27,543 27,506 27,080 10,000 10,000 Street Light/Pole Repair/Replace 101 43121 01403.02 Signal Lights 763 2,315 510 1,500 1,500 101 43121 01 403.03 Light Replacements 0 0 0 18,500 10,000 Conversion to LED 101 43121 01404.00 Contracted Mach&Equip Repairs 0 0 1,683 15,000 15,000 Quiet Zones-Railroad Maint Costs 101 43121 01 405.00 Street Striping 46,887 36,303 35,469 60,000 45,000 101 43121 01 408.00 Street Crack Sealing 59,267 50,577 55,249 60,000 60,000 Increased Street Overlays 101 43121 01 409.00 Tree Trimming 4,309 8,966 7,630 8,500 8,500 101 43121 01410.00 Concrete Sidewalk/Curb Repairs 20,000 101 43121 01410.01 General Repairs 26,252 14,641 30,402 20,000 20,000 101 43121 01410.02 Pedestrian Improvements 130,604 4,447 0 0 0 Moved$125,000 to Street CIP 101 43121 01411.00 Contracted Snow Removal 49,000 101 43121 01 411.01 Community Center 30,268 13,518 24,081 20,000 23,000 101 43121 01 411.02 Steeple Center 9,993 , 7,055 15,708 10,000 11,000 101 43121 01411.04 Dakota County Library 12,219 8,980 20,698 15,000 15,000 101 43121 01415.00 Equipment Rental 35,508 31,455 21,184 32,500 22,000 101 43121 01433.00 Dues&Subscriptions 1,100 101 43121 01 433.01 American Public Works Ass'n 695 796 820 800 900 Annual Membership 101 43121 01433.03 City Engineers'Association 0 35 0 0 0 101 43121 01 433.07 MN Street Superintendent Ass'n 70 100 100 200 200 101 43121 01 433.09 MN Transportation Alliance 0 0 0 0 0 101 43121 01 435.00 Books&Pamphlets 0 101 43121 01435.02 "Future Use" 0 0 0 0 0 101 43121 01 437.00 Conferences&Seminars 5,700 101 43121 01437.01 APWA 0 1,080 1,765 1,000 1,500 Spring/Fall Conferences 101 43121 01 437.03 Clerical 0 60 0 0 0 101 43121 01 437.05 Maintenance Expo 0 37 0 300 300 101 43121 01 437.06 Cartegraph,ESRI,GIS 231 105 237 1,500 1,300 User Group,Conference,Training 101 43121 01437.07 Snow Conference 0 0 0 300 300 101 43121 01437.08 MN Dot 0 200 0 300 300 Simulator 101 43121 01437.09 Miscellaneous Training 1,332 2,007 1,924 2,600 2,000 DCTC Defensive Driving Training 101 43121 01 439.00 Other Miscellaneous Charges 105 280 915 500 500 Host CONDAC,RL&CD Notary 101 43121 01 570.00 Office Equipment&Furnishings 0 0 0 0 0 ----------- -------------------------- --------- PAGE TOTALS $386,045 $235,463 $270,456 $343,500 $303,300 DEPARTMENT TOTALS $1,385,442 $1,229,994 $1,268,465 $1,348,300 $1,343,100 Page One 2015 BUDGET WORKSHEETS PARKS&GROUNDS MAINTENANCE June 10,2014 2014 2015 Object 2015 2011 2012 2013 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 45202 101.00 Salaries&Benefits $399,100 Salary,Taxes,PERA&Benefits 101 45202 77 101.00 Administrative 11,877 18,311 21,172 22,000 22,600 101 45202 78 101.00 Technical/Clerical 0 6,912 18,829 20,200 20,800 101 45202 79 101.00 Maintenance 411,767 362,547 337,975 346,900 355,700 101 45202 102.00 Full-Time Overtime 9,366 7,095 15,864 14,000 14,000 101 45202 99 103.00 Part-Time Salaries&Benefits 68,823 50,805 53,181 63,000 63,000 101 45202 01 205.00 Plotter Ink and Paper 0 114 57 500 500 Split with 101-43121-01-205.01 101 45202 01 216.00 Chemical&Chemical Products 14,460 16,714 22,150 31,000 35,000 FHR Fields Online in 2014 101 45202 01 219.00 Other Operating Supplies 26,000 101 45202 01 219.01 Seed,Sod,etc. 2,139 3,676 4,722 4,000 4,000 FHR Fields Online in 2014 101 45202 01 219.02 Red Rock,Sand,Gravel,etc. 5,299 5,147 9,448 5,000 10,000 Topdressing Fields 101 45202 01 219.03 Repair Supplies 0 115 0 0 0 101 45202 01 219.04 Bituminous 0 0 0 0 0 101 45202 01 219.05 Wood Chips 7,214 9,000 12,691 12,000 12,000 Special Chips,Jaycee Playground 101 45202 01 220.00 Splash Pad Maintenance 0 0 0 0 7,500 Supplies,Power Washer,etc. 101 45202 01 221.00 Equipment Parts 17,500 101 45202 01 221.01 Playground Equipment Repair 4,643 4,935 7,847 6,000 8,000 Repairs on Aging Equipment 101 45202 01 221.02 Irrigation Repair(Non-Contract) 5,046 6,663 3,487 7,000 7,000 101 45202 01 221.03 Miscellaneous 1,599 2,142 2,340 2,500 2,500 Ballfield Fence Repair 101 45202 01 221.04 Park Sign Replacements 0 46 0 0 0 101 45202 01 223.00 Shelter Repair Supplies 6,000 101 45202 01 223.01 Paint,Stain,etc. 2,749 758 383 2,500 1,500 101 45202 01 223.02 Shingles,Boards,etc. 1,268 861 569 1,500 1,500 101 45202 01 223.03 Miscellaneous 1,647 206 992 1,500 1,500 101 45202 01 223.04 Shelter/Shed Repairs 3,018 1,106 2,200 1,500 1,500 101 45202 01 225.00 Landscaping Materials 5,000 101 45202 01 225.01 Trees,Shrubs,Sod,etc. 1,648 2,248 1,459 2,500 2,500 101 45202 01 225.02 Timbers,Fence,etc. 1,241 159 2,775 2,500 2,500 Field Fence Maintenance 101 45202 01 226.00 Sign Repair Materials 0 0 0 500 500 101 45202 01 229.00 Other Maintenance Supplies 12,276 13,368 21,173 16,000 20,000 Paint/Chalk/Field Dry(+Flint Hills) 101 45202 01 241.00 Small Tools 2,456 2,355 1,734 2,500 2,500 Hand Tools,Blades,Bits,etc. 101 45202 01 242.00 Minor Equipment 3,264 2,180 1,972 2,500 5,000 Weed Whips,Chain Saws,etc. 101 45202 01 303.00 Engineering Fees(GIS) 0 0 0 0 5,000 101 45202 01 305.00 Medical and Dental Fees 0 0 0 0 0 101 45202 01 318.00 Contract Engineer 1,750 2,000 2,500 1,800 6,400 101 45202 01 319.00 Other Professional Services 3,141 13,000 101 45202 01 319.01 Maintenance of Open Spaces 3,120 0 347 3,000 8,000 Prairies,Controlled Burns,etc. 101 45202 01 319.02 Landscaping&Flower Beds 0 0 3,924 0 5,000 101 45202 01 321.00 Telephone Costs 3,806 4,111 3,915 5,000 5,000 All Wireless,Including iPad 101 45202 01 323.00 Radio Units 1,211 1,116 1,045 1,500 1,500 24 Units @$300(Split 5 Ways) 101 45202 01 341.00 Employment Advertising 0 0 0 0 0 101 45202 01 381.00 Electric Utilities 25,000 Anticipated Rate Increase 101 45202 01 381.01 Skating Rinks 7,108 6,628 8,342 8,500 8,500 Service Connect/Disconnect 101 45202 01 381.02 Softball Fields 7,026 6,536 7,328 8,500 8,500 101 45202 01 381.03 Irrigation 3,461 4,668 6,339 5,500 8,000 Umore 2013,Flint Hills 2014 101 45202 01 383.00 Gas Utilities 2,124 1,572 2,070 2,000 2,100 101 45202 01 393.00 P.C.Hardware Purchases 320 1,800 2,833 3,000 1,000 101 45202 01 394.00 P.C.Software Purchases 4,574 7,200 101 45202 01 394.01 Licensing&Maintenance 4,779 4,212 6,500 6,200 Cartegraph,GIS 101 45202 01 394.02 Online Subscriptions 308 286 800 800 Pictometry 101 45202 01 394.03 New Software Purchases 2,031 235 500 200 . PAGE TOTALS 606,299 556,152 586,398 614,200 667,800 25 Page Two 2015 BUDGET WORKSHEETS PARKS&GROUNDS MAINTENANCE June 10,2014 2014 2015 Object 2015 2011 2012 2013 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 101 45202 01 403.00 Contracted Repair&Maintenance 12,000 101 45202 01 403.01 Irrigation Repairs 6,186 6,362 2,070 8,000 8,000 RPZ-Inspect/Replace&Blowout 101 45202 01 403.02 Electrical Repairs 3,484 1,662 2,811 3,000 3,000 101 45202 01 403.03 Miscellaneous Repairs 3,529 4,449 575 1,000 1,000 101 45202 01 409.00 Other Contracted Repair&Maint 53,700 101 45202 01 409.01 Chem lawn Services 1,947 1,947 0 0 0 101 45202 01 409.02 Library/St.Joe's/RCC 8,108 8,104 9,374 9,000 9,500 Mowing/Chemicals-VonBank 101 45202 01 409.03 Fire Station#1 3,500 3,529 4,080 4,000 4,200 Mowing/Chemicals-VonBank 101 45202 01 409.04 Fire Station#2 2,450 2,471 2,867 3,000 3,000 Mowing/Chemicals-VonBank 101 45202 01 409.05 City Hall/Central Park 6,000 6,043 6,948 6,500 7,000 Mowing/Chemicals-VonBank 101 45202 01 409.06 UMore Baseball Fields 0 15,000 15,000 15,000 15,000 UMore Baseball Field Maintenance 101 45202 01 409.07 FHR Soccer Fields 0 0 0 10,000 15,000 FHR Soccer Fields Maintenance 101 45202 01 416.00 Machinery Rental 29,500 101 45202 01 416.01 Mower Leases 27,855 15,562 16,203 17,500 28,000 3 Mowers,Buy 2 Cabs in 2014 101 45202 01 416.02 Miscellaneous Rentals 1,301 1,598 7,372 1,500 1,500 101 45202 01 433.00 Dues&Subscriptions 200 101 45202 01 433.01 MN Park Supervisors Ass'n 0 0 0 50 50 101 45202 01 433.02 Miscellaneous Dues 0 25 90 150 150 101 45202 01 435.00 Books&Pamphlets 0 0 0 0 0 101 45202 01 437.00 Conferences&Seminars 3,800 101 45202 01 437.01 Seminars&Workshops 659 514 719 2,500 1,200 Green Expo,MPSA,Playgrounds 101 45202 01 437.02 School&Tuition 1,771 1,126 1,031 1,300 1,300 Turf School,Power Limited Tech. 101 45202 01 437.03 CarteGraph,ESRI,GIS 157 105 120 1,500 1,300 User Group,Conference,Training 101 45202 01 439.00 Other Miscellaneous Charges 250 0 224 200 200 Contingencies 101 45202 01 530.00 Improvements Other Than Bldgs 64,988 64,185 75,000 135,000 150,000 Next 10-Yr Average Expenditures PAGE TOTALS $132,187 $132,682 $144,486 $219,200 $249,400 DEPARTMENT TOTALS $738,485 $688,834 $730,884 $833,400 $917,200 2 Page One 2015 BUDGET WORKSHEETS PARKS&RECREATION June 10,2014 2014 2015 Object 2015 2011 2012 2013 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 45100 101.00 Salaries&Benefits $703,800 $725,023 $741,601 $757,400 $790,600 Salary,Taxes,PERA&Benefits 101 45100 102.00 Full-Time Overtime 4,864 4,025 5,660 5,000 5,000 101 45100 103.00 Part-Time Salaries&Benefits 160,200 101 45100 10 103.00 P/T Receptionist 35,361 36,400 36,758 37,200 38,200 101 45100 12 103.00 Building Attendants 54,009 59,873 55,230 54,000 54,000 101 45100 15 103.00 P/T Recreation Coordinator 0 0 0 35,000 27,000 1/2 Time Starting 4/1/15 101 45100 83 103.00 Playground Recreation Leaders 18,501 25,631 26,362 24,000 24,000 101 45100 94 103.00 Warming House Attendants 14,523 12,839 16,287 15,000 15,000 101 45100 99 103.00 Park&Rec Committee 1,814 1,705 1,920 2,000 2,000 101 45100 01 203.00 Printed Forms&Paper 0 0 0 0 0 101 45100 01 205.00 Drafting Supplies 117 0 25 500 500 Laminating 101 45100 01 207.00 Training&Instructional Supplies 0 0 0 0 0 101 45100 01 208.00 Miscellaneous Supplies 60 43 0 0 0 101 45100 01 209.00 Other Office Supplies 119 378 190 500 500 Envelopes,Forms,Rulers,etc. 101 45100 01 211.00 Cleaning Supplies 4,326 4,254 5,233 4,500 4,500 101 45100 01 216.00 Chemicals&Chemical Products 109 124 282 0 0 Moved to"211.00" 101 45100 01 219.00 Other Operating Supplies 6,655 8,853 10,052 8,000 8,000 Rec Programs,1st Aid Sup,etc. 101 45100 01 221.00 Equipment Parts 6,050 8,688 7,074 8,000 8,000 101 45100 01 223.00 Building Repair Supplies 1,169 1,296 2,536 1,500 1,500 101 45100 01 229.00 Other Maintenance Supplies 0 0 5,367 5,000 5,000 Tournament Supplies 101 45100 01 312.00 Custodial Services 5,258 5,515 5,990 6,000 6,000 Custodial Services-Banquet Rm 101 45100 01 315.00 Special Programs 15,500 101 45100 01 315.01 Sunday Night Specials 5,329 5,633 5,039 5,500 5,500 Performances(Add Movies) 101 45100 01 315.02 Leprechaun Days 613 352 200 250 250 101 45100 01 315.03 Umore Maint.Agreement 0 0 4,000 2,000 2,000 2014-Full Year 101 45100 01 315.04 Ground Pounders(Running) 297 140 169 200 200 Ribbons&Mailings 101 45100 01 315.05 Nature Programs(Arbor Day) 4,291 4,402 4,741 0 0 Move to 101-41110-01-225.00 101 45100 01 315.06 Puppet Programs 54 0 54 150 150 Tapes,Fuses,Puppets,etc. 101 45100 01 315.07 Special Events 124 322 3,055 1,000 2,000 Publicity&Supplies 101 45100 01 315.08 Adopt-A-Park Program 389 75 67 500 500 Flyers,Signs 101 45100 01 315.09 Miscellaneous Programs 2,552 6,859 4,004 4,500 4,500 Community Gardens 101 45100 01 315.10 ADA Programs 0 0 0 400 400 ADA Program Supplies 101 45100 01 319.00 Other Professional Services 5,393 4,950 431 6,000 6,000 ADA Services/Eng.LA Sery Test 101 45100 01 321.00 Telephone Costs 3,898 4,181 3,750 4,000 4,000 Pagers&Cellular Phones 101 45100 01 331.00 Travel Expense 181 668 874 500 700 101 45100 01 341.00 Employment Advertising 100 0 0 0 0 101 45100 01 349.00 Other Advertising 34,400 101 45100 01 349.01 Brochures 28,889 30,611 29,427 28,000 29,000 City Newsletter(3 Per Year) 101 45100 01 349.02 Yellow Pages 1,430 1,352 643 1,500 1,500 Rec Ads 101 45100 01 349.03 Special Marketing 3,835 3,528 5,043 3,900 3,900 Garage Sale Ad 101 45100 01 381.00 Electric Utilities 30,295 30,969 37,269 30,000 30,000 101 45100 01 383.00 Gas Utilities 26,328 22,141 28,636 25,000 25,000 101 45100 01 384.00 Refuse Disposal 3,699 3,517 3,066 4,000 4,000 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 2,066 0 0 0 0 See"433.03"Below 101 45100 01 401.00 Contracted Building Repairs 11,486 6,602 14,693 8,000 10,000 101 45100 01 404.00 Contracted Mach&Equip Repairs 4,170 5,722 13,012 6,000 6,000 101 45100 01 409.00 Other Contracted Repair&Maint 24,745 24,187 24,599 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 16,827 23,704 22,872 24,000 24,000 Portable Toilets&Other(New Pks) 101 45100 01 433.00 Dues&Subscriptions 4,800 101 45100 01 433.01 MRPA Dues 1,576 1,391 1,520 1,700 1,700 Minn Recreation&Parks Ass'n 101 45100 01 433.02 Miscellaneous 1,927 2,008 2,469 400 400 Paper,Magazines,etc. 101 45100 01 433.03 On-Line Registrat'n Subscription 0 2,028 1,620 2,700 2,700 101 45100 01 435.00 Books&Pamphlets 0 5 0 100 100 101 45100 01 437.00 Conferences&Seminars 4,400 101 45100 01 437.01 MRPA State Conference 1,520 2,207 1,065 2,000 2,000 101 45100 01 437.03 Workshops,Schools,&Tuition 2,112 658 2,334 2,400 2,400 101 45100 01 439.00 Other Miscellaneous Charges 19,590 8,856 8,869 0 0 Donation Account 101 45100 01 530.00 Improvements Other Than Bldgs 0 0 0 0 0 ----------------------------- ----------------- ---- PAGE TOTALS $1,077,250 $1,108,514 $1,160,888 $1,169,100 $1,199,500 General Operating DEPARTMENT TOTALS $1,077,250 $1,108,514 $1,160,888 $1,169,100 $1,199,500 7- Page Two 2015 BUDGET WORKSHEETS PARKS&RECREATION "STEEPLE CENTER" June 10,2014 2014 2015 Object 2015 2011 2012 2013 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 101 38201.00 Rental Revenues $19,750 $17,830 $11,910 $8,000 $8,000 101 38203.00 Rental Revenue-Churches 500 0 0 0 0 101 38205.00 AN Rental Revenues 428 25 0 500 500 101 38209.00 Miscellaneous Revenues 280 93 0 0 0 101 38211.00 Security Services 2,050 1,050 1,729 1,000 1,000 ---------- ----------- - --- ----------- ------ TOTAL REVENUES $23,008 $18,998 $13,639 $9,500 $9,500 101 45100 30 103.00 Salaries&Benefits $15,000 Salary,Taxes,PERA&Benefits 101 45100 30 103.00 Building Attendants 15,425 14,435 13,485 15,000 15,000 Event Staff 101 45100 30 211.00 Cleaning Supplies 4,207 2,247 1,849 3,000 3,000 101 45100 30 219.00 Other Operating Supplies 1,538 1,205 2,531 1,500 1,500 Events Supplies 101 45100 30 221.00 Equipment Parts 990 145 656 1,000 1,000 101 45100 30 223.00 Building Repair Supplies 4,251 3,233 3,422 4,500 4,500 101 45100 30 241.00 Small Tools 0 0 187 500 500 101 45100 30 242.00 Minor Equipment 1,273 1,339 1,012 1,000 1,000 101 45100 30 312.00 Custodial Services 0 1,480 1,357 800 800 101 45100 30 321.00 Telephone Costs 1,751 2,069 1,760 2,000 2,000 101 45100 30 349.00 Other Advertising 325 0 0 500 500 101 45100 30 365.00 Workers'Comp Insurance 0 0 0 500 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,669 4,863 5,319 4,500 4,500 101 45100 30 383.00 Gas Utilities 9,905 7,023 7,971 7,000 7,000 101 45100 30 384.00 Refuse Disposal 1,142 1,149 1,150 1,200 1,200 101 45100 30 401.00 Contracted Building Repairs 11,523 8,493 5,645 11,000 8,000 101 45100 30 404.00 Contracted Mach&Equip Repairs 3,553 6,793 6,265 4,200 6,000 101 45100 30 409.00 Other Contracted Repairs&Main 0 0 0 2,500 2,500 Holiday Lights 101 45100 30 415.00 Other Equipment Rental 789 718 0 500 500 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 $62,340 $55,193 $52,608 $61,200 $59,500 "ACTIVITY CENTER" 2014 2015 Objed 2015 2011 2012 2013 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 101 38301.00 Rental Revenues $0 $0 $0 $750 $2,000 101 38305.00 AN Rental Revenues 0 0 0 50 200 101 38309.00 Miscellaneous Revenues 0 0 0 0 0 - ------------- - ----------- - --- TOTAL REVENUES $0 $0 $0 $800 $2,200 101 45100 31 103.00 Salaries&Benefits $19,000 Salary,Taxes,PERA&Benefits 101 45100 31 103.00 Building Attendants 0 0 0 8,800 19,000 Event Staff(1/2 Year) 101 45100 31 211.00 Cleaning Supplies 0 0 0 300 1,000 101 45100 31 219.00 Other Operating Supplies 0 0 0 400 1,000 Events Supplies 101 45100 31 221.00 Equipment Parts 0 0 0 400 500 101 45100 31 223.00 Building Repair Supplies 0 0 0 500 1,000 101 45100 31 242.00 Minor Equipment 0 0 0 300 1,000 101 45100 31 321.00 Telephone Costs 0 0 0 300 1,000 101 45100 31 349.00 Other Advertising 0 0 0 100 100 101 45100 31 365.00 Workers'Comp Insurance 0 0 0 200 0 Pay from Insurance Fund 101 45100 31 369.00 Other Insurance 0 0 0 500 0 Pay from Insurance Fund 101 45100 31 381.00 Electric Utilities 0 0 0 1,500 2,000 101 45100 31 383.00 Gas Utilities 0 0 0 500 3,000 101 45100 31 384.00 Refuse Disposal 0 0 0 300 600 101 45100 31 401.00 Contracted Building Repairs 0 0 0 500 1,000 101 45100 31 404.00 Contracted Mach&Equip Repairs 0 0 0 300 1,000 101 45100 31 415.00 Other Equipment Rental 0 0 0 100 500 101 45100 31 439.00 Other Miscellaneous Charges 0 0 0 0 0 -------------- ---- - --- PAGE/EXPENDITURE TOTALS $0 $0 $0 $15,000 $32,700 29 Page Three 2015 BUDGET WORKSHEETS PARKS&RECREATION June 10,2014 2014 2015 Object 2015 2011 2012 2013 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments $105,400 101 45100 80 Art Classes $0 $0 $0 $1,000 $0 101 45100 81 Softball 44,877 44,160 34,384 45,000 33,500 101 45100 82 Volleyball 0 0 0 0 0 101 45100 84 Tennis 1,065 1,767 1,943 1,600 1,600 101 45100 85 Tiny Tots 377 0 0 0 0 Eliminated Program in 2010 101 45100 86 Rosettes 1,747 1,646 1,927 1,700 1,700 101 45100 87 Trips 916 4,677 7,035 4,600 6,000 101 45100 88 Broomball 0 0 0 0 0 101 45100 90 Run for the Gold 4,693 4,615 4,892 4,500 4,500 101 45100 91 Camps 21,289 14,583 27,510 15,000 20,000 101 45100 92 Adult Basketball 0 0 0 600 600 101 45100 93 Other Programs 17,658 17,055 11,740 17,000 17,000 101 45100 95 T-Ball 4,960 4,894 4,308 5,000 5,000 101 45100 96 Teen Night 0 786 882 0 0 Eliminated Program in 2010 101 45100 97 Adult Soccer League 12,137 11,205 11,209 12,000 12,000 No League in 2009 101 45100 98 Youth Soccer Lessons 3,617 2,605 3,179 3,500 3,500 113,336 107,994 109,009 111,500 105,400 101 45100 80 219.00 Operating Supplies 0 0 0 1,000 0 101 45100 81 103.00 Part-Time Salaries 6,149 7,380 5,345 6,000 5,000 101 45100 81 219.00 Operating Supplies 9,041 10,318 6,386 9,000 6,000 101 45100 81 311.00 Officiating Fees 24,574 23,853 20,575 25,000 20,000 101 45100 81 319.00 Other Professional Services 5,113 2,609 2,079 5,000 2,500 101 45100 82 103.00 Part-Time Salaries 0 0 0 0 0 101 45100 82 219.00 Operating Supplies 0 0 0 0 0 101 45100 82 311.00 Officiating Fees 0 0 0 0 0 101 45100 82 319.00 Other Professional Services 0 0 0 0 0 101 45100 84 103.00 Part-Time Salaries 1,065 1,767 1,673 1,100 1,100 101 45100 84 219.00 Operating Supplies 0 0 270 500 500 101 45100 85 103.00 Part-Time Salaries 377 0 0 0 0 101 45100 85 219.00 Operating Supplies 0 0 0 0 0 101 45100 86 103.00 Part-Time Salaries 691 678 817 700 700 101 45100 86 219.00 Operating Supplies 1,056 968 1,110 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 407 274 0 500 500 101 45100 87 219.02 Adult/Senior Trips Supplies 509 4,403 7,035 4,100 5,500 101 45100 88 219.00 Operating Supplies 0 0 0 0 0 101 45100 88 311.00 Officiating Fees 0 0 0 0 0 101 45100 90 219.00 Operating Supplies 4,693 4,615 4,892 4,500 4,500 101 45100 91 103.00 Part-Time Salaries 11,623 3,434 14,013 4,000 9,000 101 45100 91 219.00 Operating Supplies 9,666 11,149 13,498 11,000 11,000 101 45100 92 219.00 Operating Supplies 0 0 0 600 600 101 45100 93 103.00 Part-Time Salaries 2,825 2,159 2,232 3,000 3,000 101 45100 93 219.00 Operating Supplies 14,833 14,476 9,507 14,000 14,000 101 45100 93 319.00 Other Professional Services 0 420 0 0 0 101 45100 95 103.00 Part-Time Salaries 3,514 3,289 2,878 3,500 3,500 101 45100 95 219.00 Operating Supplies 1,445 1,605 1,430 1,500 1,500 101 45100 96 103.00 Part-Time Salaries 0 0 0 0 0 101 45100 96 219.00 Operating Supplies 0 786 882 0 0 101 45100 97 103.00 Part-Time Salaries 0 0 0 0 0 101 45100 97 219.00 Operating Supplies 1,637 1,545 1,609 1,500 1,500 101 45100 97 311.00 Officiating Fees 10,500 9,660 9,600 10,500 10,500 101 45100 98 103.00 Part-Time Salaries 2,377 1,695 2,138 2,300 2,300 101 45100 98 219.00 Operating Supplies 1,240 910 1,040 1,200 1,200 ------------------- ----------------------- ----------- ------- SPECIAL PROGRAM TOTALS 113,336 107,994 109,009 111,500 105,400 GRAND TOTAL-PARK&REC $1,252,926 $1,271,700 $1,322,504 $1,356,800 $1,397,100 Page One 2015 BUDGET WORKSHEETS OTHER FINANCING USES June 10,2014 2014 2015 Object :015 2011 2012 2013 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 101-4e300'01 710.00 Transfers m*77.376 m115000 m115.000 w115.000 y130.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-4e300'01 720.00 Transfers 323.138 25,000 0 0 0 Excess FIB Transfers FUND TOTALS $800.514 m1*0.000 m115.000 w115.000 o130.000 Page One 2015 BUDGET WORKSHEETS INSURANCE-REVENUES June 10,2014 2014 2015 Object 2015 2011 2012 2013 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 $245,000 206 33100.00 Federal Grants&Aids 0 0 0 0 0 206 36210.00 Interest Earnings-Investments 8,360 6,408 6,562 7,000 7,000 206 36214.00 Net Change in FV-Investments 0 0 0 0 0 Annual Market Value Changes 206 36215.00 Interest Earnings 201 135 46 300 300 206 36260.00 Other Revenue 71,767 77,449 52,280 40,000 45,000 Insurance Refunds/Dividends 206 36265.00 Use of Reserve Funds 0 0 0 0 0 FUND TOTALS 325,328 328,992 303,887 292,300 297,300 INSURANCE-EXPENDITURES 2014 2015 Object 2015 2011 2012 2013 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 206 49006 01 221.00 Equipment Parts $10,834 $1,955 $515 $5,000 $5,000 Liability&Auto Deductible Pymts 206 49006 01 304.00 Legal Fees 500 4,230 500 500 500 Unreimbursable Legal Fees 206 49006 01 305.00 Medical&Dental Fees 9,742 3,597 11,489 6,000 6,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 18,300 Risk Management Consultant 206 49006 01 319.01 Risk Management Consultant 6,000 6,000 6,000 6,000 6,000 206 49006 01 319.02 CHESS Consultant 12,300 12,300 12,300 12,300 12,300 206 49006 01 365.00 Worker's Compensation Insurance 106,210 103,113 112,964 110,000 115,000 Annual Premium 206 49006 01 369.00 Other Insurance 80,309 89,713 89,163 95,000 95,000 Annual Premium-General Liability (Changed to High Deductible) 206 49006 01 403.00 Contracted R&M-Other Impr. 0 0 0 0 0 Liability&Auto Deductible Pymts 206 49006 01 409.00 Other Contracted Repair&Maint 57,602 49,577 65,465 55,000 55,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 0 0 37,176 0 0 2013-Replace Vehicle FUND TOTALS 285,997 272,986 338,072 292,300 297,300 (Changed to High Deductible) NOTE: Levy of$245,000 covers costs for all insurance premiums and general liability payments(changed to high deductible plan for 2011). All other expenditures covered through a combination of tax levies,interest earnings and insurance refunds/dividends. 3 ' Page One 2015 BUDGET WORKSHEETS PORT AUTHORITY-REVENUES May 20,2014 2014 2015 Object 2015 2011 2012 2013 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 201 31010.00 Current Ad Valorem Taxes $58,600 $58,600 $58,000 $58,000 $58,000 Operating Levy 201 31050.00 Tax Increments 0 0 0 0 0 Admin Fees Portion Only 201 33130.00 Federal Grants-CDBG 0 0 0 0 0 201 33425.00 Other State Grants&Aids 0 0 0 0 0 LCDA Downtown Grant 201 34109.00 Other Charges for Services 0 0 0 0 0 Genz-Ryan Tenant Utility Pymts 201 36210.00 Interest Earnings-Investments 81 50 50 100 100 Interest Earned on CD's 201 36215.00 Interest Earnings 39 86 35 100 100 Checking Interest&Misc 201 36230.00 Contributions/Donations 0 0 0 0 0 201 36260.00 Other Revenue 575 0 0 0 0 201 36265.00 Use of Reserve Funds 0 0 0 0 14,400 201 39101.00 Sales of General Fixed Assets 0 0 0 0 0 FUND TOTALS $59,295 $58,735 $58,086 $58,200 $72,600 EXPENDITURES 2014 2015 Object 2015 2011 2012 2013 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 $0 $0 $6,079 $0 $0 Part-Time Intern 201 46300 99 103.00 Part-Time Salaries&Benefits 3,868 3,302 2,509 5,000 4,000 Port Authority Members 201 46300 01 303.00 Engineering Fees 4,400 0 0 2,000 2,000 201 46300 01 304.00 Legal Fees 900 1,209 1,645 3,000 3,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 17,400 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,853 10,231 10,020 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 5,400 201 46300 01 319.07 Central Park Survey Work 0 0 0 0 0 201 46300 01 322.00 Postage Costs 87 0 446 800 0 201 46300 01 331.00 Travel Expense 0 0 0 0 0 201 46300 01 349.00 Other Advertising 3,972 2,939 7,094 10,000 27,000 Additional Marketing 201 46300 01 359.00 Other Printing&Binding Costs 321 0 0 2,000 3,000 201 46300 01 365.00 Workers Comp Insurance 521 540 540 500 500 Commissioners 201 46300 01 369.00 Other Insurance 2,282 1,532 394 2,000 2,000 Property Insurance 201 46300 01 381.00 Electric Utilities 223 287 309 500 500 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 0 0 201 46300 01 433.00 Dues&Subscriptions 1,700 Prof Organizations/Journals 201 46300 01 433.01 Professional Organizations/Journt 2,380 1,790 1,806 1,700 1,700 201 46300 01 433.02 Foreign Trade Zone Commission 0 0 0 0 0 201 46300 01 437.00 Conferences&Seminars 4,125 2,419 4,249 5,000 5,000 Development/TIF/Miscellaneous 201 46300 01 439.00 Other Miscellaneous Charges 48 110 434 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 0 0 0 0 201 46300 01 530.00 Improvements Other Than Bldgs 0 0 0 0 0 201 46300 01 710.00 Transfers 0 0 0 0 0 FUND TOTALS $39,979 $30,360 $41,525 $56,400 $72,600 32 Page One 2015 BUDGET WORKSHEETS DOWNTOWN/BROCKWAY DISTRICT(0108)-REVENUES May 20,2014 2014 2015 Object 2015 2011 2012 2013 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 242 31010.00 Current Ad Valorem Taxes $46,811 $0 $0 $0 $0 MVHC Payments 242 31050.00 Tax Increments 576,675 660,056 660,130 670,000 670,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 724 879 826 0 800 242 36215.00 Interest Earnings 130 75 14 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 39310.00 Bond Proceeds 0 0 0 0 0 FUND TOTALS $624,339 $661,010 $660,971 $670,000 $670,800 EXPENDITURES 2014 2015 Object 2015 2011 2012 2013 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,053 10,699 16,516 20,000 20,000 County TIF Charges(in 2011) 242 49042 01 522.00 Building&Structure Purchases 103 0 0 0 0 242 49042 01 530.00 Improvements Other Than Buildings 0 0 0 0 0 242 49042 01 533.00 Waterford Grant Reimbursement 0 0 0 0 0 242 49042 01 601.00 Principal on Waterford PAYG 19,108 44,979 52,953 63,000 59,000 Waterford Pay-As-You-Go 242 49042 01 611.00 Interest on Waterford PAYG 63,880 83,340 84,179 80,000 79,000 Waterford Pay-As-You-Go 242 49042 01 710.00 Transfers 350,000 350,000 400,000 400,000 400,000 P&I for 2008A&2008B Issues --------- ---- ------- ---------- FUND TOTALS $449,144 $489,018 $553,647 $563,000 $558,000 33 Page One 2015 BUDGET WORKSHEETS WATER UTILITY -REVENUES- June 10,2014 2014 2015 Object 2015 2011 2012 2013 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 601 33425.00 Other State Grants&Aids $0 $19,960 $0 $0 $0 601 34108.00 Administrative Fees-Other Funds 2,123 5,733 2,497 0 0 5%of 5%Fees-Const Projects 601 34109.00 Other Gen'I Govt Chgs for Services 0 14,000 12,250 0 0 601 36101.00 Principal-Special Assessments 54,354 59,342 55,362 50,000 55,000 601 36102.00 Penalties&Interest-S/A (5,989) (3,093) 224 0 0 601 36210.00 Interest Earnings-Investments 60,496 60,556 57,119 60,000 55,000 601 36214.00 Net Change in FV-Investments 3,794 5,131 (125,524) 0 0 Annual Market Value Changes 601 36215.00 Interest Earnings 1,280 427 70 500 500 601 36220.00 Rents&Royalties 80,745 84,223 88,052 90,000 90,000 Antenna Leases 601 36260.00 Other Revenues 750 0 128 0 0 601 36265.00 Use of Reserve Funds 0 0 0 0 49,600 601 37110.00 Residential Water Revenues 1,079,507 1,258,104 1,155,429 1,200,000 1,100,000 601 37120.00 Apartment Water Revenues 75,444 79,934 83,470 75,000 80,000 601 37125.00 Institutional Water Revenues 70,470 87,847 70,541 75,000 70,000 601 37130.00 Commercial Water Revenues 71,131 84,393 79,091 70,000 75,000 601 37140.00 Industrial Water Revenues 73,851 70,693 123,072 70,000 70,000 601 37160.00 Penalties-Water Revenues 9,378 10,470 9,896 8,000 9,000 601 37165.00 Meter Maint Water Revenues 0 0 0 0 0 601 37170.00 Other Water Revenues 0 0 0 0 0 601 37180.00 Water Meter Sales Revenue 27,498 42,497 46,529 35,000 40,000 601 39103.00 Gain or Loss from F/A Disposal (1,532) (739) (144) 0 0 601 39203.00 Transfer From 0 0 24,443 0 0 FUND TOTALS $1,603,302 $1,879,477 $1,682,505 $1,733,500 $1,694,100 3LJ Page One 2015 BUDGET WORKSHEETS WATER UTILITY -EXPENDITURES- June 10,2014 2014 2015 Object 2015 2011 2012 2013 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 601 49400 101.00 Salaries&Benefits $440,900 Salary,Taxes,PERA&Benefits 601 49400 77 101.00 Administrative 110,344 120,763 117,500 112,900 116,100 601 49400 78 101.00 Technical/Clerical 136,304 144,153 142,778 148,800 154,300 601 49400 79 101.00 Maintenance 138,854 146,589 157,164 165,600 170,500 601 49400 xx 101.00 Salary&Benefit Contingency 0 0 0 0 0 601 49400 102.00 Full-Time Overtime 9,378 7,794 15,629 8,000 8,000 601 49400 103.00 Part-Time Salaries&Benefits 6,289 6,112 5,697 8,000 8,000 601 49400 99 103.01 Utility Commission Wages(50%) 1,000 50%-601; 50%-602 601 49400 99 103.02 Maintenance Labor 7,000 100%-601 601 49400 01 203.00 Printed Forms&Paper 1,196 2,260 1,742 2,000 2,000 Inserts&Water Bill Statements 601 49400 01 209.00 Other Office Supplies 238 749 1,459 200 200 601 49400 01 216.00 Chemicals&Chemical Products 59,746 66,610 58,454 70,000 70,000 Chlorine,Flouride,Polyphos 601 49400 01 219.00 Other Operating Supplies 465 97 331 200 200 Maintenance Supplies 601 49400 01 220.00 Water Meter Purchases 113,000 Meters,MIU's&CU Horns 601 49400 01 220.01 For Replacements 0 0 43,441 40,000 45,000 New Meter Standards 601 49400 01 220.02 For New Homes 23,283 46,600 61,704 40,000 68,000 Water Rate Model(3%Growth) 601 49400 01 224.00 Street Maintenance Materials 3,720 637 0 2,500 2,500 Patching for Breaks 601 49400 01 225.00 Landscaping Materials 279 208 845 500 500 Topsoil,Seed&Sod 601 49400 01 228.00 Meter Repair Materials 0 0 29 0 0 601 49400 01 229.00 Other Maintenance Supplies 14,200 601 49400 01 229.01 Supplies for Hydrants 5,849 4,599 3,332 6,000 6,000 601 49400 01 229.02 Curb Shutoffs 554 1,097 565 1,000 1,000 601 49400 01 229.03 GV Repair/Replacement 0 2,574 0 2,200 2,200 Repairs Done By City Staff 601 49400 01 229.04 Miscellaneous Supplies 4,626 4,438 3,355 5,000 5,000 601 49400 01 241.00 Small Tools 1,513 1,792 614 2,000 2,000 Wrenches,Shovels,etc. 601 49400 01 242.00 Minor Equipment 2,095 609 2,860 3,000 3,000 601 49400 01 303.00 Engineering Fees 30,000 601 49400 01 303.01 WHPP 0 474 0 5,000 5,000 Groundwater Plan Implementation 601 49400 01 303.02 GIS 0 2,539 516 5,000 5,000 601 49400 01 303.03 Rate Study 0 0 0 7,500 0 601 49400 01 303.04 Miscellaneous Fees 40,828 28,450 20,093 20,000 20,000 601 49400 01 304.00 Legal Fees 94 1,269 0 1,000 1,000 601 49400 01 310.00 Testing Services 46,500 601 49400 01 310.01 Bacteria&Water Quality 1,734 1,560 1,585 2,000 2,500 Radon,Tri-Chl.,Pesticides,Etc. 601 49400 01 310.02 V.O.C.,Pesticides,etc. 1 0 0 1,000 0 601 49400 01 310.03 MDH Service Connection Fee 40,901 41,623 43,149 41,000 44,000 $6.36/Connection-Annual Fee 601 49400 01 312.00 Gopher State One-Call 2,098 2,559 2,303 3,500 2,500 601 49400 01 313.00 Temporary Service Fees 23,401 6,190 0 0 0 601 49400 01 318.00 Contract Engineer 7,000 8,000 10,000 7,000 25,000 601 49400 01 319.00 Other Professional Services 23,100 601 49400 01 319.01 Thaw Pipes,Check Leaks,etc. 200 311 0 1,500 1,500 601 49400 01 319.02 Supervisory Controls 3,015 910 15,648 5,000 5,000 SCADA 601 49400 01 319.03 Hazardous Chemical Permits 0 725 725 1,000 1,000 MN Department of Public Safety 601 49400 06 319.06 Contracted Hydrant Painting 9,800 9,922 10,004 10,000 10,000 120 Hydrants/Yr($82 each) 601 49400 01 319.07 Antenna Expenses 0 0 12,563 0 0 601 49400 01 319.08 Buxton Project 0 0 0 0 5,600 601 49400 01 320.00 Credit Card Activity Fees 0 0 3,324 2,000 3,000 1/3 Cost of C/C Pymt Processing 601 49400 01 321.00 Telephone Costs 2,354 2,646 2,745 2,500 3,000 Cell Phones,Modesm,GPS 601 49400 01 322.00 Postage Costs 4,504 4,678 4,556 5,000 5,000 Billings with Inserts 601 49400 01 323.00 Radio Units 1,211 1,116 1,045 1,500 1,500 24 Units'$300(Split 5 Ways) 601 49400 01 352.00 General Notices&Public Info 0 78 0 0 0 601 49400 01 365.00 Workers Comp Insurance 7,089 6,807 6,990 7,000 7,000 Water's Share of Premiums 601 49400 01 369.00 Other Insurance 10,487 10,746 6,181 12,000 12,000 Water's Share of Premiums 601 49400 01 391.00 P.C.Maintenance 491 2,700 601 49400 01 391.01 U/B Software Maintenance 0 1,827 2,081 2,000 2,000 Added to Utility Budgets in 2012 601 49400 01 391.02 Auto Read Software Support 0 585 585 700 700 Added to Utility Budgets in 2012 601 49400 01 392.00 P.C.Accessories&Supplies 128 0 0 200 200 601 49400 01 393.00 P.C.Hardware Purchases 320 1,637 4,093 3,000 12,000 Replace SCADA Hardware/Software 601 49400 01 394.00 P.C.Software Purchases 4,574 7,200 601 49400 01 394.01 Licensing&Maintenance 0 4,843 4,279 6,500 6,200 Cartegraph,GIS 601 49400 01 394.02 Online Subscriptions 0 308 286 800 800 Pictometry 601 49400 01 394.03 New Software Purchases 0 7,868 2,271 500 200 601 49400 01 395.00 P.C.Repairs 0 0 0 500 0 PAGE TOTALS 664,963 705,356 772,524 772,600 846,200 35 Page Two 2015 BUDGET WORKSHEETS WATER UTILITY -EXPENDITURES- June 10,2014 2014 2015 Object 2015 2011 2012 2013 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 601 49400 01 403.00 Contracted R&M-Other Impr 10,544 22,113 30,845 6,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 45 73 25 400 200 Suburban Utility Supt Assn 601 49400 01 435,00 Books&Pamphlets 0 23 0 300 200 Reference Materials 601 49400 01 437.00 Conferences&Seminars 3,800 601 49400 01 437.01 MDH Training(Water School) 588 755 816 2,000 1,500 Operator Licensure 601 49400 01 437.02 AWWA Conference 0 0 0 0 0 _ 601 49400 01 437,03 CarteGraph,ESRI,GIS 157 270 370 1,500 1,300 User Group,Conference,Training 601 49400 01 437.04 Miscellaneous Training 0 0 0 1,000 1,000 601 49400 01 439.00 Other Miscellaneous Charges 15,235 16,646 14,627 45,000 45,000 DNR Annual Water Use 601 49400 01 521.00 Building&Structure Purchases 0 0 0 10,000 10,000 Pymt on P.W.Building(17 of 20) 601 49400 01 530.00 Improvements Other Than Bldgs 475,600 601 49400 01 530.01 Well Inspections 560 560 490 600 600 601 49400 01 530.02 Miscellaneous Improvements 0 1,050 0 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 20,000 0 245,000 320,000 From Long-Term Project Schedule 601 49400 01 570.00 Office Equipment Purchases 0 58 107 1,000 1,000 601 49400 01 611.00 Interest on Lease Payments 3,232 2,893 2,538 0 0 P.W.Building Expansion(See 521) 601 49400 01 710.00 Transfers 298,666 200,000 139,194 0 0 Transfers for Other Improvements 601-49400-01 TOTALS 993,990 969,797 961,537 1,240,400 --- 1,412,000 601 49406 01 221.00 Equipment Parts 512 0 0 500 500 601 49406 01 223.00 Building Repair Supplies 0 0 0 200 200 601 49406 01 319.00 Other Professional Services 0 0 0 1,000 1,000 601 49406 01 381.00 Electric Utilities 1,304 995 1,045 1,300 1,300 Pumping&Lighting TOTAL-PRV 1,816 995 1,045 3,000 3,000 601 49407 01 221.00 Equipment Parts 779 5,968 1,401 500 1,500 601 49407 01 223.00 Building Repair Supplies 0 0 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 18,322 21,934 23,667 30,000 33,000 Pumping,Lighting,Tower Mixer 601 49407 01 409.00 Other Contracted Repairs&Maint 3,741 0 6,000 1,000 2,000 $800 for Lights in 2015 601 49407 01 439.00 Other Miscellaneous Charges 100 0 37 100 100 Contingencies 601 49407 01 530.00 Improvements Other Than Bldgs 3,219 101 0 0 0 -- ---- ---------------------------------------- TOTAL-WELL#7 26,370 28,213 31,316 32,100 37,100 601 49408 01 221.00 Equipment Parts 2,390 2,024 1,342 500 1,500 601 49408 01 223.00 Building Repair Supplies 0 15 0 200 200 601 49408 01 319.00 Other Professional Services 0 0 0 0 0 601 49408 01 381.00 Electric Utilities 14,969 21,917 23,841 25,000 25,000 Pumping&Lighting 601 49408 01 383.00 Gas Utilities 468 428 470 600 600 Heat Only 601 49408 01 409.00 Other Contracted Repairs&Maint 0 0 5,952 20,000 2,000 $800 for Lights in 2015 601 49408 01 439.00 Other Miscellaneous Charges 100 0 0 100 100 Contingencies 601 49408 01 530.00 Improvements Other Than Bldgs 1,809 0 0 0 0 --------------------------------------------- TOTAL-WELL#8 19,736 24,385 31,605 46,400 29,400 601 49409 01 221.00 Equipment Parts 1,009 3,955 2,831 1,000 1,500 601 49409 01 223.00 Building Repair Supplies 0 0 0 200 200 601 49409 01 319.00 Other Professional Services 0 0 0 0 0 601 49409 01 381.00 Electric Utilities 27,268 25,692 16,618 35,000 30,000 Pumping&Lighting 601 49409 01 383.00 Gas Utilities 547 627 795 1,500 1,500 Heat Only 601 49409 01 409.00 Other Contracted Repairs&Maint 0 0 837 1,000 2,000 $800 for Lights in 2015 601 49409 01 439.00 Other Miscellaneous Charges 100 259 0 100 100 Contingencies 601 49409 01 530.00 Improvements Other Than Bldgs 1,809 101 21,907 1,000 0 --------------------------------------- --- -------- TOTAL-WELL#9 30,732 30,633 42,988 39,800 35,300 310 Page Three 2015 BUDGET WORKSHEETS WATER UTILITY -EXPENDITURES- June 10,2014 2014 2015 Object 2015 2011 2012 2013 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 601 49410 01 219.00 Other Operating Supplies 0 1 0 500 500 601 49410 01 221.00 Equipment Parts 1,469 1,062 4,434 1,000 1,000 601 49410 01 223.00 Building Repair Supplies 9 0 213 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 12,489 13,189 16,623 15,000 17,000 Pumping&Lighting 601 49410 01 409.00 Other Contracted Repairs&Maint 0 1,703 9,957 500 2,000 $800 for Lights in 2015 601 49410 01 439.00 Other Miscellaneous Charges 50 0 0 100 100 Contingencies 601 49410 01 530.00 Improvements Other Than Bldgs 0 0 10,014 0 0 - - - TOTAL-WELL#10 14,782 16,720 42,005 17,300 20,800 Rural Water System 601 49411 01 221.00 Equipment Parts 1,565 0 0 0 0 601 49411 01 439.00 Other Miscellaneous Charges 50 0 0 0 0 TOTAL-WELL#11 1,615 0 0 0 0 Rural Water System(#2) 601 49412 01 221.00 Equipment Parts 1,134 1,847 0 1,000 1,500 601 49412 01 223.00 Building Repair Supplies 0 10 0 200 200 601 49412 01 319.00 Other Professional Services 0 0 0 0 0 601 49412 01 381.00 Electric Utilities 19,190 22,444 23,242 30,000 30,000 Pumping&Lighting 601 49412 01 409.00 Other Contracted Repairs&Maint 6,101 278 1,495 1,000 2,000 $800 for Lights in 2015 601 49412 01 439.00 Other Miscellaneous Charges 100 0 0 100 100 Contingencies ------------------------------------------------------- TOTAL-WELL#12 26,525 24,578 24,737 32,300 33,800 601 49414 01 221.00 Equipment Parts 1,104 1,063 0 500 1,500 601 49414 01 223.00 Building Repair Supplies 0 0 0 200 200 2014 2015 Object 2015 2011 2012 2013 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 601 33425.00 Other State Grants&Aids $0 $19,960 $0 $0 $0 601 34108.00 Administrative Fees-Other Funds 2,123 5,733 2,497 0 0 5%of 5%Fees-Const Projects 601 34109.00 Other Gen'I Govt Chgs for Services 0 14,000 12,250 0 0 601 36101.00 Principal-Special Assessments 54,354 59,342 55,362 50,000 55,000 601 36102.00 Penalties&Interest-S/A (5,989) (3,093) 224 0 0 601 36210.00 Interest Earnings-Investments 60,496 60,556 57,119 60,000 55,000 601 36214.00 Net Change in FV-Investments 3,794 5,131 (125,524) 0 0 Annual Market Value Changes 601 36215.00 Interest Earnings 1,280 427 70 500 500 601 36220.00 Rents&Royalties 80,745 84,223 88,052 90,000 90,000 Antenna Leases 601 36260.00 Other Revenues 750 0 128 0 0 601 36265.00 Use of Reserve Funds 0 0 0 0 49,600 601 37110.00 Residential Water Revenues 1,079,507 1,258,104 1,155,429 1,200,000 1,100,000 601 37120.00 Apartment Water Revenues 75,444 79,934 83,470 75,000 80,000 601 37125.00 Institutional Water Revenues 70,470 87,847 70,541 75,000 70,000 601 37130.00 Commercial Water Revenues 71,131 84,393 79,091 70,000 75,000 601 37140.00 Industrial Water Revenues 73,851 70,693 123,072 70,000 70,000 601 37160.00 Penalties-Water Revenues 9,378 10,470 9,896 8,000 9,000 601 37165.00 Meter Maint Water Revenues 0 0 0 0 0 601 37170.00 Other Water Revenues 0 0 0 0 0 601 37180.00 Water Meter Sales Revenue 27,498 42,497 46,529 35,000 40,000 601 39103.00 Gain or Loss from F/A Disposal (1,532) (739) (144) 0 0 601 39203.00 Transfer From 0 0 24,443 0 0 FUND TOTALS $1,603,302 $1,879,477 $1,682,505 $1,733,500 $1,694,100 Page Four 2015 BUDGET WORKSHEETS WATER UTILITY -EXPENDITURES- June 10,2014 2014 2015 Object 2015 2011 2012 2013 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 601 49415 01 221.00 Equipment Parts 122 0 0 500 500 Touch-up Paint 601 49415 01 319.00 Other Professional Services 0 0 0 0 0 601 49415 01 409.00 Other Contracted Repairs&Maint 0 0 0 500 500 601 49415 01 439.00 Other Miscellaneous Charges 100 0 0 200 200 Contingencies 601 49415 01 530.00 Improvements Other Than Bldgs 0 0 0 0 0 ---- ------------------------- ------- TOTAL-WATER TOWER#1 222 0 0 1,200 1,200 (Chippendale Water Tower) 601 49416 01 221.00 Equipment Parts 2,500 0 12 500 500 Touch-up Paint 601 49416 01 319.00 Other Professional Services 0 0 0 0 0 Tower Inspection 601 49416 01 381.00 Electric Utilities 712 429 1,338 1,400 4,500 New Water Mixers in 2014 601 49416 01 409.00 Other Contracted Repairs&Maint 2,945 0 0 500 500 601 49416 01 439.00 Other Miscellaneous Charges 0 0 0 200 200 Contingencies 601 49416 01 530.00 Improvements Other Than Bldgs 0 0 0 0 0 TOTAL-WATER TOWER#2 6,158 429 1,350 2,600 5,700 (Connemara Water Tower) 601 49417 01 221.00 Equipment Parts 4,261 0 0 500 500 601 49417 01 319.00 Other Professional Services 0 0 0 0 0 601 49417 01 381.00 Electric Utilities 4,267 5,345 5,374 6,000 6,000 601 49417 01 409.00 Other Contracted Repairs&Maint 122 0 0 7,000 500 601 49417 01 439.00 Other Miscellaneous Charges 0 0 96 200 200 Contingencies 601 49417 01 530.00 Improvements Other Than Bldgs 0 0 0 0 0 -- ----- ------------------------ --- TOTAL-WATER TOWER#4 8,651 5,345 5,470 13,700 7,200 (Bacardi Water Tower) 601 49418 01 221.00 Equipment Parts 0 0 0 500 500 601 49418 01 319.00 Other Professional Services 0 3,800 0 0 0 601 49418 01 381.00 Electric Utilities 1,648 1,885 3,359 3,000 4,000 New Water Mixers in 2014 601 49418 01 409.00 Other Contracted Repairs&Maint 0 792 519 500 500 601 49418 01 439.00 Other Miscellaneous Charges 0 28 0 200 200 Contingencies 601 49418 01 530.00 Improvements Other Than Bldgs 0 0 0 0 0 ---------------------------------------------------- TOTAL-WATER TOWER#3 1,648 6,505 3,878 4,200 5,200 (East Side Water Tower) GRAND TOTAL-ALL DEPTS. $1,191,281 $1,161,229 $1,202,036 $1,504,600 $1,694,100 39 Page One 2015 BUDGET WORKSHEETS SEWER UTILITY -REVENUES- June 10,2014 2014 2015 Object 2015 2011 2012 2013 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,123 5,733 2,497 0 0 5%of 5%Fees-Const Projects 602 36101.00 Principal-Special Assessments 77,214 192,425 98,077 80,000 90,000 602 36102.00 Penalties&Interest-S/A 2,775 1,783 327 0 0 602 36210.00 Interest Earnings-Investments 40,077 24,678 17,042 25,000 15,000 602 36214.00 Net Change in FV-Investments 3,447 725 (8,621) 0 0 Annual Market Value Changes 602 36215.00 Interest Earnings 282 240 76 500 500 602 36260.00 Other Revenues 2,212 0 0 0 0 602 36265.00 Use of Reserve Funds 0 0 0 323,800 240,400 602 37210.00 Residential Sewer Revenues 1,135,626 1,274,698 1,278,008 1,200,000 1,300,000 602 37220.00 Apartment Sewer Revenues 101,697 106,160 114,024 100,000 105,000 602 37225.00 Institutional Sewer Revenues 22,231 23,868 24,238 23,000 24,000 602 37230.00 Commercial Sewer Revenues 63,367 65,411 72,645 65,000 68,000 602 37240.00 Industrial Sewer Revenues 47,106 47,136 86,042 47,000 47,000 602 37260.00 Penalties-Sewer Revenues 11,327 12,809 12,567 10,000 12,000 602 39103.00 Gain or Loss from F/A Disposal (3,421) 0 0 0 0 602 39203.00 Transfer From 0 238,964 10,806 0 0 FUND TOTALS $1,506,064 $1,994,630 $1,707,729 $1,874,300 $1,901,900 -59 Page One 2015 BUDGET WORKSHEETS SEWER UTILITY -EXPENDITURES- June 10,2014 2014 2015 Object 2015 2011 2012 2013 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 602 49450 101.00 Salaries&Benefits $440,900 Salary,Taxes,PERA&Benefits 602 49450 77 101.00 Administrative 110,563 120,762 117,498 112,900 116,100 602 49450 78 101.00 Technical/Clerical 136,305 144,154 142,778 148,800 154,300 602 49450 79 101.00 Maintenance 138,718 146,589 157,163 165,600 170,500 602 49450 xx 101.00 Salary&Benefit Contingency 0 0 0 0 0 602 49450 102.00 Full-Time Overtime 9,029 7,794 15,629 7,500 7,500 602 49450 103.00 Part-Time Salaries&Benefits 8,880 8,025 5,531 9,000 9,000 602 49450 99 103.01 Utility Commission Wages(50%) 1,000 50%-602; 50%-601 602 49450 99 103.02 Maintenance Labor 8,000 100%-602 602 49450 01 203.00 Printed Forms&Paper 1,195 1,499 1,613 1,500 1,500 Inserts&Water Bill Statements 602 49450 01 209.00 Other Office Supplies 0 227 899 200 200 602 49450 01 216.00 Chemicals&Chemical Products 0 0 0 500 500 Root Killer,Degreaser 602 49450 01 219.00 Other Operating Supplies 0 0 304 200 200 602 49450 01 224.00 Street Maintenance Materials 1,425 0 0 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 Supplier 18 3,292 211 5,000 5,000 MH Castings Replacement Prog. 602 49450 01 241.00 Small Tools 417 802 165 500 500 Wrenches,Shovels,etc. 602 49450 01 242.00 Minor Equipment 1,285 414 2,990 3,000 3,000 602 49450 01 303.00 Engineering Fees 20,000 602 49450 01 303.01 GIS 129 2,539 516 5,000 5,000 602 49450 01 303.02 Rate Study 0 0 0 7,500 0 602 49450 01 303.04 Miscellaneous 4,148 2,395 7,402 15,000 15,000 Sewer System O&M Review 602 49450 01 304.00 Legal Fees 0 286 0 500 500 602 49450 01 312.00 Gopher State One-Call 2,092 2,559 2,303 3,500 2,500 602 49450 01 313.00 Temporary Service Fees 14,559 0 0 0 0 602 49450 01 318.00 Contract Engineer 7,000 8,000 10,000 7,000 25,000 602 49450 01 319.00 Other Professional Services 15,600 602 49450 01 319.01 Televising 1,720 531 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) 3,356 0 6,802 5,000 5,000 SCADA System 602 49450 01 319.04 Buxton Project 3,356 0 0 0 5,600 602 49450 01 320.00 Credit Card Activity Fees 0 0 3,324 2,000 3,000 1/3 Cost of C/C Pymt Processing 602 49450 01 321.00 Telephone Costs 2,312 2,646 2,745 2,500 3,000 Cell Phones,Modems,GPS 602 49450 01 322.00 Postage Costs 4,504 4,678 4,556 5,000 5,000 Billings with Inserts 602 49450 01 323.00 Radio Units 1,211 1,116 1,045 1,500 1,500 24 Units*$300(Split 5 Ways) 602 49450 01 365.00 Workers Comp Insurance 7,109 6,828 7,011 7,000 7,000 Sewer's Share of Premiums 602 49450 01 369.00 Other Insurance 5,307 6,443 10,777 12,000 12,000 Sewer's Share of Premiums 602 49450 01 391.00 P.C.Maintenance 491 0 0 2,700 602 49450 01 391.01 U/B Software Maintenance 0 1,827 2,081 2,000 2,000 Added to Utility Budgets in 2012 602 49450 01 391.02 Auto Read Software Support 0 585 585 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 320 1,362 4,093 3,000 12,000 Replace SCADA Hardware/Software 602 49450 01 394.00 P.C.Software Purchases 4,574 7,200 602 49450 01 394.01 Licensing&Maintenance 0 4,779 4,279 6,500 6,200 Cartegraph,GIS 602 49450 01 394.02 Online Subscriptions 0 308 286 800 800 Pictometry 602 49450 01 394.03 New Software Purchases 0 7,772 2,271 500 200 602 49450 01 395.00 P.C.Repairs 0 0 0 500 500 602 49450 01 403.00 Contracted R&M-Other Impr 0 3,533 2,581 5,000 5,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 23 50 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) 23 90 1,646 1,500 1,500 Operator Licensure$300 each(M) 602 49450 01 437.02 Collection System Conference 950 1,310 0 0 0 Duplicate of Sewer School 437.01 602 49450 01 437.03 CarteGraph,ESRI,GIS 158 270 120 1,500 1,300 User Group,Conference,Training 602 49450 01 437.04 Miscellaneous Training 0 0 0 1,000 1,000 602 49450 01 439.00 Other Miscellaneous Charges 144 153 148 100 100 Contingencies 602 49450 01 521.00 Building&Structure Purchases 0 0 0 10,000 10,000 Pymt on P.W.Building(16 of 20) 602 49450 01 530.00 Improvements Other Than Bldgs 160,000 602 49450 01 530.01 Miscellaneous Improvements 0 0 31 10,000 10,000 SCADA Reconfiguration,PCL's 602 49450 01 530.02 Misc.Improvements/Repairs 0 0 0 0 0 602 49450 01 530.03 CRP of Sewermain 0 0 0 150,000 150,000 Annual Pavement Management 602 49450 01 530.04 0 0 0 0 0 602 49450 01 540.00 Heavy Machinery Purchases 0 0 0 0 0 602 49450 01 560.00 Furniture&Fixture Purchases 0 0 0 500 500 602 49450 01 570.00 Office Equipment Purchases 0 0 0 500 500 --- -------- --------- --------------- PAGE TOTALS 471,320 493,620 519,385 733,100 771,500 u0 Page Two 2015 BUDGET WORKSHEETS SEWER UTILITY -EXPENDITURES- June 10,2014 2014 2015 Object 2015 2011 2012 2013 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 602 49450 01 602.00 Sewer Service Charges 981,478 940,900 1,007,195 1,090,300 1,090,300 MWCC Charges 602 49450 01 611.00 Interest on Lease Payments 3,232 2,893 2,538 0 0 P.W.Building Expansion(See 521) 602 49450 01 710.00 Transfers 172,451 10,493 116,948 0 0 Transfers for Other Improvements 602-49450-01 TOTALS 1,628,481 1,447,906 1,646,066 1,823,400 1,861,800 602 49451 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49451 01 221.00 Equipment Parts 4,215 21 0 800 800 602 49451 01 229.00 Other Maintenance Supplies 0 0 0 200 200 602 49451 01 303.00 Engineering Fees 5,499 0 0 0 0 602 49451 01 381.00 Electric Utilities 1,058 925 915 1,500 1,500 602 49451 01 403.00 Contracted R&M-Other Impr 0 0 0 200 200 602 49451 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies (City Hall) TOTAL-LIFT STATION#1 10,772 947 915 2,900 2,900 602 49452 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49452 01 221.00 Equipment Parts 2,697 59 1,060 800 800 602 49452 01 229.00 Other Maintenance Supplies 0 0 0 200 200 602 49452 01 321.00 Telephone Costs 211 105 0 0 0 602 49452 01 381.00 Electric Utilities 620 554 630 700 700 602 49452 01 403.00 Contracted R&M-Other Impr 0 0 0 200 200 602 49452 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies (Bloomfield 5th) TOTAL-LIFT STATION#7 3,528 719 1,691 2,100 2,100 602 49453 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49453 01 221.00 Equipment Parts 338 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,154 3,578 3,753 4,000 4,000 602 49453 01 403.00 Contracted R&M-Other Impr 0 230 0 200 200 602 49453 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies (Shannon Pond) TOTAL-LIFT STATION#3 3,492 3,808 3,753 5,400 5,400 602 49454 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49454 01 221.00 Equipment Parts 478 2,001 167 800 800 602 49454 01 229.00 Other Maintenance Supplies 0 0 0 200 200 602 49454 01 381.00 Electric Utilities 4,898 5,377 4,602 6,000 6,000 602 49454 01 403.00 Contracted R&M-Other Impr 3,195 0 1,582 10,000 2,000 Alarm Upgrades,SCADA,PLC 602 49454 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ----------- -- ---------- -------- ---------- (Hawkins) TOTAL-LIFT STATION#4 8,571 7,377 6,351 17,200 9,200 602 49455 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49455 01 221.00 Equipment Parts 31,500 0 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,609 5,879 5,569 7,000 6,000 602 49455 01 403.00 Contracted R&M-Other Impr 0 0 0 200 200 602 49455 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ---- ----------- ------ ------ (LeForet Add'n) TOTAL-LIFT STATION#5 37,108 5,879 5,569 8,400 7,400 602 49456 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49456 01 221.00 Equipment Parts 118 4,247 2,385 800 800 602 49456 01 229.00 Other Maintenance Supplies 0 0 0 200 200 602 49456 01 381.00 Electric Utilities 6,614 3,788 6,001 5,000 6,000 602 49456 01 403.00 Contracted R&M-Other Impr 0 0 0 3,000 200 Alarm Upgrades 602 49456 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies (Drumcliffe) TOTAL-LIFT STATION#6 6,732 8,035 8,385 9,200 7,400 LI I Page Three 2015 BUDGET WORKSHEETS SEWER UTILITY -EXPENDITURES- June 10,2014 2014 2015 Object 2015 2011 2012 2013 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,103 1,176 1,278 1,200 1,200 602 49457 01 403.00 Contracted R&M-Other Impr 0 0 0 200 200 602 49457 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ---- ------------ ---- ------- (Glendalough 5th) TOTAL-LIFT STATION#9 1,103 1,176 1,278 2,300 2,300 602 49458 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49458 01 221.00 Equipment Parts 6,612 353 1,269 500 500 602 49458 01 229.00 Other Maintenance Supplies 0 0 0 200 200 602 49458 01 381.00 Electric Utilities 552 522 633 800 800 602 49458 01 403.00 Contracted R&M-Other Impr 0 0 0 200 200 602 49458 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies ---------- -------------------- -------- (Meadows of) TOTAL-LIFT STATION#8 7,164 875 1,902 1,900 1,900 (Bloomfield) 602 49460 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49460 01 221.00 Equipment Parts 497 294 725 500 500 602 49460 01 229.00 Other Maintenance Supplies 0 0 0 200 200 602 49460 01 381.00 Electric Utilities 295 251 252 400 400 602 49460 01 403.00 Contracted R&M-Other Impr 0 0 0 200 200 602 49460 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies (Glen Rose) TOTAL-LIFT STATION#10 793 545 977 1,500 1,500 GRAND TOTAL-ALL DEPTS. $1,707,744 $1,477,266 $1,676,886 $1,874,300 $1,901,900 2-1Z Page One 2015 BUDGET WORKSHEETS STORM WATER UTILITY -REVENUES- June 10,2014 2014 2015 Object 2015 2011 2012 2013 Adopted Detail Proposed Account 4 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 34108.00 Administrative Fees-Other Funds 2,123 5,733 2,497 0 0 5%of 5%Fees-Const Projects 603 36101.00 Principal-Special Assessments 22,204 22,418 19,925 20,000 20,000 603 36102.00 Penalties&Interest-S/A 732 514 76 0 0 603 36210.00 Interest Earnings-Investments 45,136 24,205 21,458 20,000 20,000 603 36214.00 Net Change in FV-Investments 2,198 479 (48,916) 0 0 Annual Market Value Changes 603 36215.00 Interest Earnings 245 262 60 300 300 603 36260.00 Other Revenues 0 0 188,004 0 0 603 36265.00 Use of Reserve Funds 0 0 0 0 0 603 37300.00 Storm Water Utility Revenues 879,551 908,679 980,819 900,000 950,000 603 37360.00 Penalties-Storm Water Utility 3,690 5,416 5,956 4,700 5,000 603 39203.00 Transfer From 0 0 0 0 0 FUND TOTALS $955,878 $967,705 $1,169,878 $945,000 $995,300 Page One 2015 BUDGET WORKSHEETS STORM WATER UTILITY -EXPENDITURES- June 10,2014 2014 2015 Object 2015 2011 2012 2013 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 603 49500 101.00 Salaries&Benefits $183,300 Salary,Taxes,PERA&Benefits 603 49500 77 101.00 Administrative 0 4,036 10,586 11,000 11,300 603 49500 78 101.00 Technical/Clerical 76,109 88,359 80,607 81,800 85,000 603 49500 79 101.00 Maintenance 69,358 73,294 78,581 84,600 87,000 603 49500 xx 101.00 Salary&Benefit Contingency 0 0 0 0 0 603 49500 102.00 Full-Time Overtime 4,568 3,958 7,836 6,000 6,000 603 49500 99 103.00 Part-Time Salaries&Benefits 9,334 6,824 5,157 8,000 8,000 603 49500 01 203.00 Printed Forms&Paper 1,195 1,726 1,613 1,500 1,500 603 49500 01 204.00 Envelopes&Letterhead 0 0 0 0 0 603 49500 01 208.00 Miscellaneous Supplies 0 352 1,090 500 500 Stakes,Ribbons,Level,etc. 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 406 1,199 515 2,000 2,000 Patching Material for Washouts 603 49500 01 225.00 Landscaping Materials 4,000 603 49500 01 225.01 Rip-Rap,Matting,Rock,etc. 1,751 1,386 898 2,000 2,000 603 49500 01 225.02 Black Dirt,Seed,Sod,etc. 1,962 1,370 150 2,000 2,000 603 49500 01 226.00 Sign Repair Materials 926 0 0 500 500 603 49500 01 230.00 Equipment Repair Material 534 881 1,754 1,000 1,000 603 49500 01 241.00 Small Tools 0 87 349 1,000 1,000 603 49500 01 242.00 Minor Equipment 332 221 2,659 2,000 2,000 Misc.Nozzles for Vac Truck 603 49500 01 303.00 Engineering Fees 75,000 603 49500 01 303.01 Problem Area Investigations 10,003 3,501 79 10,000 10,000 603 49500 01 303.02 NPDES Phase II 0 29,749 14,115 30,000 30,000 603 49500 01 303.03 CSMP Update 22,880 36 4,850 0 0 603 49500 01 303.04 Miscellaneous 29,866 4,186 14,108 30,000 30,000 603 49500 01 303.05 GIS 0 1,672 344 5,000 5,000 603 49500 01 304.00 Legal Fees 234 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 0 0 500 2,500 603 49500 01 313.00 Temporary Service Fees 9,706 0 0 0 0 603 49500 01 315.00 Special Programs(County Program) 4,500 3,850 4,815 5,000 5,000 Wetland Health&Evaluation Proj 603 49500 01 318.00 Contract Engineer 7,000 8,000 10,000 7,000 25,000 603 49500 01 319.00 Other Professional Services 3,356 0 6,802 5,000 10,600 603 49500 01 319.01 SCADA 0 0 0 0 5,000 603 49500 01 319.02 Buxton Project 0 0 0 0 5,600 603 49500 01 320.00 Credit Card Activity Fees 0 0 3,324 2,000 3,000 1/3 Cost of C/C Pymt Processing 603 49500 01 321.00 Telephone Costs 2,312 2,647 2,745 2,500 3,000 Cell Phones,Modems,GPS 603 49500 01 322.00 Postage Costs 4,504 4,678 4,556 5,000 5,000 Billings&Info Mailings 603 49500 01 323.00 Radio Units 1,210 1,116 1,045 1,500 1,500 24 Units'$300(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,875 2,654 2,925 3,500 3,500 Storm Water's Share of Premiums 603 49500 01 369.00 Other Insurance 2,393 2,362 1,278 4,000 4,000 Storm Water's Share of Premiums 603 49500 01 384.00 Refuse Disposal 0 0 0 0 0 603 49500 01 389.00 Other Utility Services 0 0 0 0 0 603 49500 01 391.00 P.C.Maintenance 491 2,700 603 49500 01 391.01 U/B Software Maintenance 0 1,827 2,081 2,000 2,000 Added to Utility Budgets in 2012 603 49500 01 391.02 Auto Read Software Support 0 585 585 700 700 Added to Utility Budgets in 2012 603 49500 01 393.00 P.C.Hardware Purchases 320 1,362 4,093 3,000 12,000 Replace SCADA Hardware/Software 603 49500 01 394.00 P.C.Software Purchases 4,574 7,200 603 49500 01 394.01 Licensing&Maintenance 0 4,779 4,279 6,500 6,200 Cartegraph,GIS 603 49500 01 394.02 Online Subscriptions 0 308 286 800 800 Pictometry 603 49500 01 394.03 New Software Purchases 0 7,772 2,271 500 200 603 49500 01 403.00 Contracted R&M-Other Impr 65,000 603 49500 01 403.01 Ditching 0 0 4,330 5,000 5,000 603 49500 01 403.02 Miscellaneous Repairs 22,899 17,830 32,838 50,000 50,000 Catch Basins,Manholes,Etc. 603 49500 01 403.03 Pond Inspection&Maintenance 0 0 0 0 10,000 603 49500 01 416.00 Machinery Rental 43 0 64 4,000 4,000 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 0 500 500 Utility Information 603 49500 01 437.00 Conferences&Seminars 3,500 603 49500 01 437.01 Storm Water Management 875 965 112 1,200 1,200 Stormwater CoIlab,Flygt Training 603 49500 01 437.03 Wetlands Training 0 0 0 0 0 603 49500 01 437.04 Cartegraph,ESRI,GIS 157 270 120 1,500 1,300 User Group,Conference,Training 603 49500 01 437.05 Miscellaneous Training 0 0 0 1,000 1,000 603 49500 01 439.00 Other Miscellaneous Charges 144 153 908 0 0 603 49500 01 530.00 Improvements Other Than Bldgs 150,000 603 49500 01 530.01 CRP of Storm Sewer 2,669 597 6,523 150,000 150,000 Annual Pavement Management 603 49500 01 560.00 Furniture&Fixture Purchases 0 0 0 500 500 603 49500 01 580.00 Other Equipment Purchases 0 0 0 2,000 2,000 603 49500 01 586.00 Computer Equipment Purchases 0 0 0 500 500 PAGE TOTALS 299,624 284,731 321,410 548,800 600,000 L-(y Page Two 2015 BUDGET WORKSHEETS STORM WATER UTILITY -EXPENDITURES- June 10,2014 2014 2015 Object 2015 2011 2012 2013 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 603 49500 01 710.00 Transfers 50,000 603 49500 01 710.01 1/2 of 2011 P&I Payments(1996B) 0 0 0 0 0 Bonds Called 2/1/08 603 49500 01 710.02 1/2 of 2011 P&I Payments(1999C) 0 0 0 0 0 Bonds Called 2/1/08 603 49500 01 710.03 1/2 of 2011 P&I Payments(2001B) 0 0 0 0 0 Bonds Called 2/1/11 603 49500 01 710.04 1/2 of 2011 P&I Payments(2001D) 0 0 0 0 0 Bonds Paid off 2/1/08 603 49500 01 710.05 1/2 of 2011 P&I Payments(2002B) 8,000 0 0 0 0 Bonds Called 2/1/11 603 49500 01 710.06 1/2 of 2011 P&I Payments(2010A) 60,000 84,000 89,000 87,000 50,000 New Refunding Issue 12/10 603 49500 01 710.07 1/2 of 2011 P&I Payments(2003A) 90,000 0 0 0 0 Bonds Called 12/1/11 603 49500 01 710.10 Projects 233,607 68,296 81,225 0 0 603-49500-01 TOTALS 691,232 437,027 491,635 635,800 650,000 603 49511 01 221.00 Equipment Parts 0 0 410 500 500 603 49511 01 381.00 Electric Utilities 264 258 312 500 500 603 49511 01 403.00 Contracted Repair&Maintenance 0 0 0 0 1,000 - A - (Copper Pond) TOTAL-LIFT STATION#1 264 258 722 1,000 2,000 603 49512 01 221.00 Equipment Parts 880 390 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 0 0 1,000 (Schwarz Pond) TOTAL-LIFT STATION#2 -- 880 - -390 - 0 ^1,000 - - 2,000 603 49513 01 221.00 Equipment Parts 375 0 0 500 500 603 49513 01 381.00 Electric Utilities 4,401 2,698 5,176 4,500 4,500 603 49513 01 403.00 Contracted Repair&Maintenance 0 0 0 0 1,000 ----------------------------- - -------------------------- (Birger Pond) TOTAL-LIFT STATION#3 4,776 2,698 5,176 5,000 6,000 603 49514 01 221.00 Equipment Parts 931 0 0 500 500 603 49514 01 381.00 Electric Utilities 1,653 947 1,500 2,000 2,000 603 49514 01 403.00 Contracted Repair&Maintenance 0 0 0 3,000 1,000 Alarm Upgrades (Marcotte Pond) TOTAL-LIFT STATION#4 2,585 947 1,500 5,500 3,500 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 0 10,000 1,000 Alarm Upgrades,SCADA,PLC -------------------------- ------------------------------- --- (Hawkins Pond) TOTAL-LIFT STATION#5 0 0 0 11,000 2,000 603 49516 01 221.00 Equipment Parts 0 0 0 500 500 603 49516 01 381.00 Electric Utilities 415 460 449 500 500 603 49516 01 403.00 Contracted Repair&Maintenance 0 0 0 0 1,000 -------- ----------- - - ------------------ (Glendalough 7th) TOTAL-LIFT STATION#6 415 460 449 1,000 2,000 GRAND TOTAL-ALL DEPTS. $700,152 $441,779 $499,484 $660,300 $667,500 LI 5 Page One 2015 BUDGET WORKSHEETS ARENA-REVENUES June 10,2014 2014 2015 Object 2015 2011 2012 2013 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 650 36210.00 Interest Earnings-Investments $486 $897 $320 $0 $0 650 36215.00 Interest Earnings 137 142 35 100 100 650 36230.00 Contributions/Donations 0 0 0 0 0 650 36260.00 Other Revenue-Learn to Skate 30,122 33,551 31,950 31,000 31,000 Learn to Skate Program(LTS) 650 36265.00 Use of Reserve Funds 0 0 0 20,800 89,900 650 38060.00 Prime Time Ice Fees 251,519 238,721 243,303 245,000 245,000 650 38061.00 Non-Prime Time Ice Fees 73,792 55,772 72,984 65,000 65,000 650 38063.00 Open Skating Ice Fees 5,259 4,587 7,945 5,000 6,000 650 38064.00 Broomball Revenues 0 0 0 0 0 Moved to Prime/Non-Prime Times 650 38065.00 Other Events-Arena 0 0 0 0 0 Dry Floor Events 650 38066.00 Advertising Revenue-Arena 3,500 8,375 8,750 10,000 8,800 650 38067.00 Skate Sharpening Revenue-Arena 3,322 2,628 3,024 3,000 3,000 650 38090.00 Concessions 3,900 3,900 2,600 3,900 3,900 650 38091.00 Vending Machine Revenues 5,771 4,737 4,892 5,000 5,000 650 38095.00 Pro Shop Revenues 863 658 611 1,000 1,000 Tape,Laces,Mouthguards,etc. 650 39103.00 Gain or Loss from F/A Disposal 0 0 0 0 0 650 39201.00 Transfer From General Fund 115,000 115,000 115,000 115,000 130,000 Subsidy for Operations FUND TOTALS 493,669 468,968 491,413 504,800 588,700 Page One 2015 BUDGET WORKSHEETS ARENA-EXPENDITURES June 10,2014 2014 2015 Object 2015 2011 2012 2013 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 650 45130 101.00 Salaries&Benefits $165,500 Salary,Taxes,PERA&Benefits 650 45130 77 101.00 Administrative 42,725 40,250 42,768 41,900 43,100 650 45130 78 101.00 Technical/Clerical 35,363 36,545 37,657 38,900 40,500 650 45130 79 101.00 Maintenance 73,447 76,702 75,364 78,100 81,900 650 45130 xx 101.00 Salary&Benefit Contingency 0 0 0 0 0 650 45130 79 102.00 Full-Time Overtime 1,494 490 1,916 2,000 2,000 650 45130 103.00 Part-Time Salaries&Benefits 40,000 650 45130 89 103.00 Learn-To-Skate Program 16,286 16,975 17,512 17,000 17,000 650 45130 99 103.00 Building Attendants 22,000 26,885 23,718 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 100 0 0 100 100 650 45130 01 208.02 Other Supplies 484 0 0 600 600 650 45130 01 209.00 Other Office Supplies 0 47 107 500 500 Learn to Skate Program Supplies 650 45130 01 211.00 Cleaning Supplies 4,198 4,079 3,828 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 4,249 5,535 7,515 5,000 5,000 Cooling Tower 650 45130 01 219.00 Other Operating Supplies 156 209 1,289 500 500 Events Supplies 650 45130 01 221.00 Equipment Parts 7,425 4,836 6,133 6,000 6,000 650 45130 01 223.00 Building Repair Supplies 2,590 1,335 1,629 3,000 3,000 650 45130 01 265.00 Other Items for Resale 269 484 681 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,340 1,413 1,285 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 115 115 120 400 200 650 45130 01 365.00 Workers Comp Insurance 3,254 3,402 3,302 3,500 3,500 650 45130 01 369.00 Other Insurance 3,679 4,637 4,033 8,000 8,000 650 45130 01 381.00 Electric Utilities 125,740 130,420 134,898 125,000 130,000 650 45130 01 383.00 Gas Utilities 26,328 22,141 28,636 24,000 25,000 650 45130 01 384.00 Refuse Disposal 2,817 2,833 2,836 3,000 3,000 650 45130 01 401.00 Contracted Building Repairs 10,189 5,580 10,653 7,000 8,500 650 45130 01 404.00 Contracted Mach&Equip Repairs 22,730 35,889 28,128 25,000 25,000 650 45130 01 415.00 Other Equipment Rental 0 0 0 300 300 650 45130 01 433.00 Dues&Subscriptions 720 745 1,090 1,000 1,000 MIAMA&MRPA Dues 650 45130 01 437.00 Conferences&Seminars 0 0 0 400 400 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 0 0 0 0 650 45130 01 580.00 Other Equipment Purchases 12,000 15,541 80,176 75,000 145,000 Ice Resurfacer 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 429,196 446,587 524,772 504,800 588,700 L.-1--1