Loading...
HomeMy WebLinkAbout6c. 2014 Utility BudgetsROSEM0UNTEXECUTIVE SUMMARY UTILITY COMMISSION Utility Commission Meeting: July 8, 2013 AGENDA ITEM: 2014 Utility Budgets AGENDA SECTION: PREPARED BY: Andrew J. Brotzler, PE, Director of Public City AGENDA NO. j ` Increasing from $10,000 to $40,000. New meter standards. Works / Engineer l� ATTACHMENTS: Proposed 2014 Utility Budgets APPROVED BY: RECOMMENDED ACTION: Motion to Recommend City Council Approval of the 2014 Utility Budgets study. Fee Rate Study BACKGROUND Attached for your consideration are the proposed 2014 Utility Budgets for water, sanitary sewer, and storm sewer. Public Works staff has worked to develop a proposed budget that meets the goals of Council while maintaining service levels. Following is an overview of the proposed changes. Water Utility Fund — Increase 13.0% 2013 Adopted Budget $1,330,300 2014 Proposed Budget $1,503,900 601 - 49400 -01- 220.01 Increasing from $10,000 to $40,000. New meter standards. Water Meter Replacements Must replace old meters instead of repairing them. 601- 49400 -01- 220.02 Increasing from $30,000 to $40,000. Price increase and more Water Meter New Homes new homes expected in 2014. 601 - 49400 -01- 303.03 Increasing from $0 to $7,500. WSB to perform trunk fee rate Engineering Fees — Trunk study. Fee Rate Study 601 - 49400 -01- 394.01 Increasing from $4,800 to $6,500. Cartegraph and GIS price Licensing & Maintenance increases. 601 - 49400 -01- 394.02 Increasing from 5300 to $800. Pictometry increase (fees based Online Subscriptions on area rather than population beginning in 2014). 601 - 49400 -01- 439.00 Increasing from $15,000 to $45,000. DNR annual water use Other Misc Charges fee increase. G: \2014 Budget \20130708 UC utihty budgets.docx Water Utility Fund - continued Increasing from $150,000 to $245,000, representing the 601 - 48400 -01- 530.04 estimated 5 -year average expenditure for water system Improvement Other Than improvements. 2014 proposed improvements include a pump Buildings - Inspection & recondition for Well 12, and possible interior and /or exterior Maintenance painting of a water tower (pending results from inspections to be performed in 2013). 601 - 49407 -01- 381.00 Increasing from $22,000 to $30,000. Estimated increase due to Electric Utilities — Well 7 general rate increase and possible withdrawal from the peak shaving program. 601 - 49408 -01- 381.00 Increasing from $15,000 to $25,000. Estimated rate increase. Electric Utilities — Well 8 601 - 49409 -01- 381.00 Increasing from $28,000 to $35,000. Estimated increase due to Electric Utilities — Well 9 general rate increase and possible withdrawal from the peak shaving program. 601 - 49412 -01- 381.00 Increasing from $25,000 to $30,000. Estimated increase due to general rate increase and withdrawal from the peak shaving Electric Utilities — Well 12 program. 601 - 49414 -01- 409.00 Increasing from $3,000 to $7,000. SCADA reconfiguration Other Contracted Repair & (PLC) Maintenance — Well 14 601 - 49417 -01- 381.00 Electric Utilities — Bacardi Increasing from $2,000 to $6,000. Estimated rate increase. Tower 601- 49417 -01- 409.00 Other Contracted Repair & Increasing from $500 to $7,000. SCADA reconfiguration Maintenance — Bacardi (PLC) Tower Sanitary Sewer Utility Fund - Increase 1.5% 2013 Adopted Budget $1,782,200 2014 Proposed Budget $1,809,325 602 - 49450 -01- 303.02 Increasing from $0 to $7,500. WSB to perform think fee rate Engineering Fees — Trunk study. Fee Rate Study Increasing from $300 to $800. Pictometry increase (fees based 602 - 49450 -01- 394.01 Increasing from $4,800 to $6,500. Cartegraph and GIS price Licensing & Maintenance increases. 602 - 49450 -01- 394.02 Increasing from $300 to $800. Pictometry increase (fees based Online Subscriptions on area rather than population beginning in 2014). 602 - 49454 -01- 403.00 Increasing from $200 to $10,000. SCADA reconfiguration Other Contracted Repair & (PLC) and alarm upgrades. Maintenance — Lift 4 602 - 49456 -01- 403.00 Other Contracted Repair & Increasing from $200 to $3,000. Alarm upgrades. Maintenance — Lift 6 Storm Sewer Utility Fund — Increase 1.8% 2013 Adopted Budget $647,600 2014 Proposed Budget $659,500 603 - 49500 -01- 394.01 Increasing from $4,800 to $6,500. Cartegraph and GIS price Licensing & Maintenance increases. 603 - 49500 -01- 394.02 Increasing from $300 to $800. Pictometry increase (fees based Online Subscriptions on area rather than population beginning in 2014). 603 - 49514 -01- 403.00 Increasing from $0 to $3,000. New line item for alarm Other Contracted Repair & upgrades. Maintenance — Marcotte 603 - 49515 -01- 403.00 Increasing from $0 to $10,000. New line item for SCADA Other Contracted Repair & reconfiguration (PLC) and alarm upgrades. Maintenance — Hawkins SUMMARY Staff is requesting Utility Commission recommendation to the City Council to approve the proposed 2014 Utility Budgets. Page One April 2, 2013 Account # 601 33425.00 601 34108.00 601 34109.00 601 36101.00 601 36102.00 601 36210.00 601 36214.00 601 36215.00 601 36220.00 601 36260.00 601 36265.00 601 37110.00 601 37120.00 601 37125.00 601 37130.00 601 37140.00 601 37160.00 601 37165.00 601 37170.00 601 37180.00 601 39103.00 601 39203.00 Page One 2014 BUDGET WORKSHEETS WATER UTILITY - REVENUES - 2013 2014 Object 2014 2010 2011 2012 Adopted Detail Proposed Description Actual Actual Actual Budget Amount Budget Comments Other State Grants & Aids $1,208 $0 $19,960 $0 $0 Administrative Fees -Other Funds 590 2,123 5,733 0 0 5% of 5% Fees -Const Projects Other Gen'l Govt Chgs for Services 10,380 0 14,000 0 0 Principal - Special Assessments 48,772 54,354 59,342 50,000 50,000 Penalties & Interest - S/A 10,808 (5,989) (3,093) 0 0 Interest Earnings - Investments 72,361 60,496 60,556 60,000 60,000 Net Change in FV- Investments (6,319) 3,794 5,131 0 0 Annual Market Value Changes Interest Earnings 736 1,280 427 1,000 1,000 Rents & Royalties 70,594 80,745 84,223 80,000 80,000 Antenna Leases Other Revenues 0 750 0 0 0 Use of Reserve Funds 0 0 0 0 0 Residential Water Revenues 999,856 1,079,507 1,258,104 1,050,000 1,050,000 Apartment Water Revenues 71,064 75,444 79,934 73,000 73,000 Institutional Water Revenues 72,159 70,470 87,847 70,000 70,000 Commercial Water Revenues 71,616 71,131 84,393 65,000 65,000 Industrial Water Revenues 64,269 73,851 70,693 70,000 70,000 Penalties - Water Revenues 8,861 9,378 10,470 8,000 8,000 Meter Maint Water Revenues 0 0 0 0 0 Other Water Revenues 0 0 0 0 0 Water Meter Sales Revenue 32,138 27,498 42,497 30,000 30,000 Gain or Loss from F/A Disposal 0 (1,532) (739) 0 0 Transfer From 0 0 0 0 0 FUND TOTALS $1,529,091 $1,603,302 $1,879,477 $1,557,000 $1,557,000 2014 BUDGET WORKSHEETS WATER UTILITY - EXPENDITURES - April 2, 2013 2013 2014 Object 2014 2010 2011 2012 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 601 49400 101.00 Salaries & Benefits $421,600 Salary, Taxes, PERA & Benefits 601 49400 77 101.00 Administrative 117,561 110,344 120,763 107,300 110,400 6014940078 101.00 Technical /Clerical 158,239 136,304 144,153 144,200 148,400 601 49400 79 101.00 Maintenance 137,759 138,854 146,589 159,300 162,800 601 49400 xx 101.00 Salary & Benefit Contingency 0 0 0 0 0 601 49400 102.00 Full -Time Overtime 8,493 9,378 7,794 8,000 8,000 601 49400 103.00 Part-Time Salaries & Benefits 8,521 6,289 6,112 8,000 8,000 6014940099 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,832 1,196 2,260 2,000 2,000 Inserts & Water Bill Statements 601 49400 01 209.00 Other Office Supplies 97 238 749 200 200 601 49400 01 216.00 Chemicals & Chemical Products 62,382 59,746 66,610 65,000 70,000 Chlorine, Flouride, Polyphos 601 49400 01 219.00 Other Operating Supplies 0 465 97 200 200 Maintenance Supplies 601 49400 01 220.00 Water Meter Purchases 80,000 Meters, MIU's & CU Horns 601 4940001 220.01 For Replacements 6,275 0 0 10,000 40,000 New meter standards 601 49400 01 220.02 For New Homes 53,511 23,283 46,600 30,000 40.000 Water Rate Model (3% Growth) 601 4940001 224.00 Street Maintenance Materials 1,468 3,720 637 2,500 2,500 Patching for Breaks 601 4940001 225.00 Landscaping Materials 0 279 208 500 500 Topsoil, Seed & Sod 601 4940001 2280 0 0 0 309 0 601 49400 01 229.00 Other Maintenance Supplies 14,200 601 4940001 229.01 Supplies for Hydrants 5,398 5,849 4,599 6,000 6,000 6014940001 229.02 Curb Shutoffs 1,355 554 1,097 1,000 1,000 601 49400 01 229.03 GV Repair /Replacement 0 0 2,574 2,200 2,200 601 49400 01 229.04 Miscellaneous Supplies 2,035 4,626 4,438 5,000 5,000 601 49400 01 241.00 Small Tools 1,607 1,513 1,792 2,000 2,000 Wrenches, Shovels, etc. 601 49400 01 242.00 Minor Equipment 3.000 60149400 -01 242,01 2,897 2,995 609 3.900 3:909 601 49400 01 303.00 Engineering Fees 37,500 601 4940001 303.01 WHPP 0 0 474 0 5,000 Groundwater Plan Implementation 601 49400 01 303.02 GIS 0 0 2,539 10,000 5,000 601 49400 01 303.03 Rate Study 159 0 0 0 7,500 601 4940001 303.04 Miscellaneous Fees 30,959 40,828 28,450 20,000 20,000 6014940001 304.00 Legal Fees 0 94 1,269 1,000 1,000 601 49400 01 310.00 Testing Services 44,000 6014940001 310.01 Bacteria & Water Quality 1,616 1,734 1,560 2,000 2,000 Radon,Tri-Chl. 601 49400 01 310.02 V.O.C., Pesticides, etc. 0 1 0 1,000 1,000 601 49400 01 310.03 CU -PB Testing 40,487 40,901 41,623 41,000 41,000 $6.36/Connection - Annual Fee (M) 601 49400 01 312.00 Gopher State One -Call 2,315 2,098 2,559 3,500 3,500 Gopher State One -Call (M) 601 49400 01 313.00 Temporary Service Fees 1,913 23,401 6,190 0 0 601 49400 01 315.00 Special Programs 0 601 49400 01 315.01 Public Information 0 0 0 0 0 601 49400 01 315.02 Plan Amendments 0 0 0 0 0 601 49400 01 315.03 Seminars 0 0 0 0 0 601 49400 01 318.00 Contract Engineer 6,000 7,000 8,000 7,000 7,000 Contracted Engineer for City(20 %) 601 49400 01 319.00 Other Professional Services 17,500 601 49400 01 319.01 Thaw Pipes, Check Leaks, etc. 870 200 311 1,500 1,500 601 49400 01 319.02 Supervisory Controls 7,329 3,015 910 5,000 5,000 SCADA 601 49400 01 319.03 Hazardous Chemical Permits 0 0 725 1,000 1,000 MN Department of Public Safety 601 49400 -91 319 -,94 Annual Drinking WaI6F Repo 9 0 9 0 9 601- 4940081 2490 0 9 0 i A90 0 601 4940006 319.06 Contracted Hydrant Painting 9,996 9,800 9,922 10,000 10,000 120 Hydrants / Yr ($82 each) 601 49400 01 320.00 Credit Card Activity Fees 0 0 0 0 0 1/3 Cost of C/C Pymt Processing 601 49400 01 321.00 Telephone Costs 2,284 2,354 2,646 2,500 2,500 Cell Phones, Modesm, GPS 601 4940001 322.00 Postage Costs 4,299 4,504 4,678 5,000 5,000 Billings with Inserts 601 4940001 323.00 Radio Units 1,083 1,211 1,116 1,500 1,500 24 Units' $300 (Split 5 Ways) 601 4940081 3330 r•' ^'" n E°^•866 E°^O^°eS 0 9 9 190 0 Mail 'P Repa Fs 601- 49400 -91 341.0 FmployrnentAdvertising 9 0 0 0 9 601- 4940001 349 -:00 OtherAdverisiR 0 0 0 509 0 601 49400 01 352.00 General Notices & Public Info 0 0 78 500 0 Newsletters 601 49400 01 365.00 Workers Comp Insurance 6,641 7,089 6,807 6,000 6,000 Water's Share of Premiums 601 49400 01 369.00 Other Insurance 19,414 10,487 10,746 20,000 20,000 Water's Share of Premiums 601 49400 01 391.00 P.C. Maintenance 467 491 2,700 601 49400 01 391.01 U/B Software Maintenance 0 0 1,827 2,000 2,000 Added to Utility Budgets in 2012 601 49400 01 391.02 Auto Read Software Support 0 0 585 700 700 Added to Utility Budgets in 2012 601 49400 01 392.00 P.C. Accessories & Supplies 359 128 0 200 200 601 49400 01 393.00 P.C. Hardware Purchases 11,488 320 1,637 4,000 3,000 AV Enhancements at PW 601 49400 01 394.00 P.C. Software Purchases 5,378 4,574 7,800 601 49400 01 394.01 Licensing & Maintenance 0 0 4,843 4,800 6,500 Cartegraph, GIS 601 49400 01 394.02 Online Subscriptions 0 0 308 300 800 Pictometry 601 49400 01 394.03 New Software Purchases 0 0 7,868 4,400 500 AV Enhancements at PW 601 49400 01 395.00 P.C. Repairs 0 0 0 500 500 PAGE TOTALS -- -- ----- - ----- 722,489 ------ --------- - - 664,963 - - - --- - - - - - -- 705,356 ------- -- ---- - -- 713,800 ---------- ------ --- ------- - - - --- 771,900 Page Two 2014 BUDGET WORKSHEETS WATER UTILITY - EXPENDITURES - April 2, 2013 2013 2014 Object 2014 2010 2011 2012 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments 601 49400 01 403.00 Contracted R & M - Other Impr 970 10,544 22,113 6,000 6,000 Watermain Breaks 601 49400 01 416.00 Machinery Rental 0 0 0 1,000 0 601 4940001 433.00 Dues & Subscriptions 1,794 45 73 1,800 400 Suburban Utility Supt Assn, AkYW 4 601 49400 01 435.00 Books & Pamphlets 0 0 23 300 300 Reference Materials 601 49400 01 437.00 Conferences & Seminars 4.500 601 4940001 437.01 MDH Training (Water School) 778 588 755 1,000 2,000 Operator Licensure (M) 604 4949481 337 -02 AWWA Cariferang 0 0 0 500 0 601 49400 01 437.03 CarteGraph, ESRI, GIS 0 157 270 1,500 1,500 User Group, Conference, Training 601 4940001 437.04 Miscellaneous Training 1,000 601 4940001 439.00 Other Miscellaneous Charges 12,741 15,235 16,646 15,000 45.000 DNR Annual Water Use (M) 601 49400 01 521.00 Building & Structure Purchases 0 0 0 10,000 10,000 Pymt on P.W. Building (16 of 20) 601 49400 01 530.00 Improvements Other Than Bldgs 400.600 6014940001 530.01 Well Inspections 560 560 560 600 600 601 49400 01 530.02 Miscellaneous Improvements 5,237 0 1,050 5,000 5,000 601 49400 01 530.03 CRP of Watermain 0 0 0 150,000 150,000 Annual Pavement Management 601 4940001 530.04 Inspection & Maintenance 0 0 20,000 150,000 245,000 Next 5 -year Average Expenditure 60-1- 49400 -93 560-00 Furniture P Fixture PUFGhaSeS 0 0 0 0 0 601 49400 01 570.00 Office Equipment Purchases 42 0 58 1,000 1,000 X49400 04 585 Q Q0FReJt9F Eq6i PFR8Rt P FGhA9PA 0 0 0 0 0 601 49400 01 611.00 Interest on Lease Payments 3,554 3,232 2,893 0 0 P.W. Building Expansion(See 521) 601 49400 01 710.00 Transfers 0 298,666 200,000 0 0 Transfers for Other Improvements 601- 49400 -01 TOTALS 748,165 - 993,991 969,798 1,057,500 1,239,700 601 49406 01 221.00 Equipment Parts 77 512 0 500 500 601 49406 01 223.00 Building Repair Supplies 0 0 0 200 200 601 4940601 319.00 Other Professional Services 0 0 0 1,000 1,000 601 4940601 381.00 Electric Utilities 1,003 1,304 995 1,300 1,300 Pumping & Lighting 6014949644 38300 Gas - Utilities 0 0 0 0 9 Heat On' TOTAL - PRV --------- - - - - -- ----------- 1,080 - - - - -- -------- 1,816 - - - - -- 995 ------ - - - - -- --------- 3,000 - - - - -- ----- - - - - -- 3,000 601 49407 01 221.00 Equipment Parts 720 779 5,968 2,000 500 GhIGRAat0F ($1300 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 19,548 18,322 21,934 22,000 30,000 Pumping & Lighting 601 49407 01 409.00 Other Contracted Repairs & Maint 0 3,741 0 4,500 1,000 601 49407 01 439.00 Other Miscellaneous Charges 0 100 0 100 100 Contingencies 601 4940701 530.00 Improvements Other Than Bldgs 0 3,219 101 0 0 - - -- TOTAL - WELL #7 -- --- - - - - -- -_- 20,479 - - - 26,370 -- - 28,213 - - - - - -- -- 29,100 - - -- - 32,100 601 4940801 221.00 Equipment Parts 491 2,390 2,024 2,000 500 F.laleRFIAtnr ;$1304) 601 49408 01 223.00 Building Repair Supplies 0 0 15 200 200 601 49408 01 319.00 Other Professional Services 0 0 0 0 0 601 4940801 381.00 Electric Utilities 3,060 14,969 21,917 15,000 25,000 Pumping & Lighting 601 49408 01 383.00 Gas Utilities 497 468 428 600 600 Heat Only 601 49408 01 409.00 Other Contracted Repairs & Maint 0 0 0 7,000 20,000 Driveway, sidewalk, curb & gutter 601 49408 01 439.00 Other Miscellaneous Charges 0 100 0 100 100 Contingencies 6014940801 530.00 Improvements Other ThanBldgs 11,700 1,809 0 1,000 0 BaG149P Pad for GeReFRtAF TOTAL - WELL #8 -- 15,748 - 19,736 24,385 25,900 - 46,400 6014940901 221.00 Equipment Parts 10,602 1,009 3,955 3,000 1,000 601 49409 01 223.00 Building Repair Supplies 34 0 0 200 200 601 49409 01 319.00 Other Professional Services 0 0 0 0 0 601 49409 01 381.00 Electric Utilities 20,988 27,268 25,692 28,000 35.000 Pumping & Lighting 6014940901 383.00 Gas Utilities 609 547 627 1,500 1,500 Heat Only 601 4940901 409.00 Other Contracted Repairs & Maint 0 0 0 2,000 1, 000 Goiters, -Ra Rt Generates A Beer 601 49409 01 439.00 Other Miscellaneous Charges 0 100 259 100 100 Contingencies 6014940901 530.00 Improvements Other ThanBldgs 13,000 1,809 101 22,500 1,000 TOTAL - WELL #9 -- ---- -- -- - - --- -- -- 45,234 -- -- -- -- --- -- -- ---- 30,732 - ----------- 30,633 ---- - ----------- ---- 57,300 ------ --- - --- -- --- - - -- --- 39,800 Page Three 2014 BUDGET WORKSHEETS WATER UTILITY -EXPENDITURES - April 2, 2013 2013 2014 Object 2014 2010 2011 2012 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments 601 49410 01 219.00 Other Operating Supplies 0 0 1 500 500 6014941001 221.00 Equipment Parts 4,150 1,469 1,062 3,500 1000 601 49410 01 223.00 Building Repair Supplies 0 9 0 200 200 601 49410 01 321.00 Telephone Costs 765 765 765 800 0 Removing Phone Line in 2013 601 49410 01 381.00 Electric Utilities 12,182 12,489 13,189 14,000 15.000 Pumping & Lighting 601 49410 01 409.00 Other Contracted Repairs & Maint 0 0 1,703 1,500 500 - cabers 601 49410 01 439.00 Other Miscellaneous Charges 0 50 0 100 100 Contingencies 601 49410 01 530.00 Improvements Other Than Bldgs 0 0 0 1,000 0 TOTAL - WELL #10 - 17,097 14,782 16,720 21,600 - 17.300 Rural Water System 601 49411 01 221.00 Equipment Parts 1,426 1,565 0 0 0 6501 49411 -01 381 00 FieGt , lT^° 0 0 0 0 0 601 49411 01 439.00 Other Miscellaneous Charges 0 50 0 0 0 TOTAL - WELL #11 --- ---- - ---- -- 1,426 -- --------- ---- -- 1,615 --- --- - -- --- 0 - ----- -- ------- -- ' - -- 0 ° - -- - 0 Rural Water System (#2) 6014941201 221.00 Equipment Parts 550 1,134 1,847 1,000 1,000 601 49412 01 223.00 Building Repair Supplies 0 0 10 200 200 601 49412 01 319.00 Other Professional Services 0 0 0 0 0 601 49412 01 381.00 Electric Utilities 15,214 19,190 22,444 25,000 30,000 Pumping & Lighting 604 49412 -01 38390 GaslJt I t es 0 0 9 0 9 EIestris ty Q ty 601 4941201 409.00 Other Contracted Repairs & Maint 0 6,101 278 5,000 1.000 - Gaiters 601 4941201 439.00 Other Miscellaneous Charges 0 100 0 100 100 Contingencies TOTAL - WELL #12 - - - - - °- 15,764 - - - - - -- 26,525 -- - - -- 24,578 - - - - - --- ---------- 31,300 - 3= -, 6014941401 221.00 Equipment Parts 1,545 1,104 1,063 500 500 601 4941401 223.00 Building Repair Supplies 0 0 0 200 200 601 4941401 319.00 Other Professional Services 0 0 1,097 1,000 1,000 601 49414 01 381.00 Electric Utilities 27,328 29,008 24,193 30,000 30,000 Pumping & Lighting 604 49444 01 38300 n^I,.,• - •:^° 0 0 9 0 0 EIesk+sily9nty 601 49414 01 409.00 Other Contracted Repairs & Maint 0 2,138 0 3,000 7,000 SCADA Reconfiguration, PLC 601 4941401 439.00 Other Miscellaneous Charges 0 100 0 100 100 Contingencies 601 49414 01 530.00 Improvements Other Than Bldgs 0 0 0 22,500 1,000 TOTAL - WELL #14 ' - - - --- - 28,872 - - - - -- 32,349 - '-- --" 26,353 - -- -- ----- ---------- - --- -- 57,300 - ---- - - -- 39,800 6014942501 221.00 Equipment Parts 1,962 1,096 3,629 500 500 601 49425 01 223.00 Building Repair Supplies 0 0 0 200 200 601 49425 01 319.00 Other Professional Services 0 353 0 500 500 601 49425 01 381.00 Electric Utilities 27,050 25,190 23,461 30,000 30,000 Pumping & Lighting 601 49425 01 383.00 Gas Utilities 0 0 0 0 0 Electricity Only 601 49425 01 409.00 Other Contracted Repairs & Maint 0 0 0 2,500 500 601 49425 01 439.00 Other Miscellaneous Charges 0 48 185 100 100 Contingencies 601 49425 01 530.00 Improvements Other Than Bldgs 0 0 0 0 0 TOTAL - WELL #15 29,012 26,687 27,276 33,800 31,800 Page Four 2014 BUDGET WORKSHEETS WATER UTILITY - EXPENDITURES - April 2, 2013 2013 2014 Object 2014 2010 2011 2012 Adopted Detail Proposed Account# Description Actual Actual Actual — ---- Budget Amount --------- – ---- – - – – - – – -------- Budget ------------------ Comments ----------- – – – --------------- – – – --- – -- – – - 601 49415 01 221.00 Equipment Parts 600 122 0 500 500 Touch-up Paint 601 49415 01 319.00 Other Professional Services 0 0 0 0 0 T-GW@F IRSI38GtiG 691 4941rGl 26I QQ F='eGtF'G I Itil't AP 0 9 9 9 0 601 49415 01 409.00 Other Contracted Repairs & Maint 0 0 0 500 500 601 49415 01 439.00 Other Miscellaneous Charges 0 100 0 200 200 Contingencies 601 49415 01 530.00 Improvements Other Than Bldgs 0 0 0 0 0 TOTAL - WATER TOWER #1 600 222 0 1,200 1,200 (Chippendale Water Tower) 601 4941601 221.00 Equipment Parts 383 2,500 0 500 500 Touch-up Paint 601 49416 01 319.00 Other Professional Services 0 0 0 0 0 Tower Inspection C94 4941601 224-00 Telephone -Costs 0 0 9 Q 0 6014941601 381.00 Electric Utilities 1,325 712 429 1,400 1,400 601 49416 01 409.00 Other Contracted Repairs & Maint 0 2.945 0 500 500 601 4941601 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 1,708 6,158 429 2,600 2,600 (Connemara Water Tower) 601 49417 01 221.00 Equipment Parts 28 4,261 0 500 500 601 49417 01 319.00 Other Professional Services 0 0 0 0 0 Tower IRSP8019 601 49417 01 32-3,90 Telephone Costs Q 0 0 0 G 601 49417 01 381.00 Electric Utilities 4,539 4,267 5,345 2,000 6.000 601 49417 01 409.00 Other Contracted Repairs & Maint 0 122 0 500 7.000 SCADA Reconfiguration. PLC 601 49417 01 439.00 Other Miscellaneous Charges 0 0 0 200 200 Contingencies 601 4941701 530.00 Improvements Other Than Bldgs 0 0 0 300 0 geRGies TOTAL - WATER TOWER #4 4,567 8,651 5,345 3,500 13,700 (Bacardi Water Tower) 601 4941801 221.00 Equipment Parts 0 0 0 500 500 6014941801 319.00 Other Professional Services 0 0 3.800 0 0 Tower InspeGlIOR 601- 4941803 32380 T81epheRe Costs 0 0 G 0 0 6014941801 381.00 Electric Utilities 1,885 1,648 1,885 5.000 3,000 601 4941801 409.00 Other Contracted Repairs & Maint 3,000 0 792 500 500 601 49418 01 439.00 Other Miscellaneous Charges 0 0 28 200 200 Contingencies 601 49418 01 530.00 Improvements Other Than Bldgs 0 0 0 0 0 TOTAL - WATER TOWER #3 4,885 1,648 6,505 6.200 4,200 (East Side Water Tower) GRAND TOTAL - ALL DEPTS. $934,635 $1.191,281 $1,161,230 $1,330,300 $1,503,900 130% Page One April 2, 2013 Account # 602 33425.00 602 34108.00 602 36101.00 602 36102.00 602 36210.00 602 36214.00 602 36215.00 602 36260.00 602 36265.00 602 37210.00 602 37220.00 602 37225.00 602 37230.00 602 37240.00 602 37260.00 602 39103.00 602 39203.00 Page One 2014 BUDGET WORKSHEETS SEWER UTILITY - REVENUES- 2013 2014 Object 2014 2010 2011 2012 Adopted Detail Proposed Description Actual Actual Actual Budget Amount Budget Comments Other State Grants & Aids $1,208 $0 $0 $0 $0 Administrative Fees -Other Funds 590 2,123 5,733 0 0 5% of 5% fees -Const Projects Principal - Special Assessments 69,472 77,214 192,425 75,000 75,000 Penalties 8 Interest -S /A 0 2,775 1,783 0 0 Interest Earnings - Investments 58,124 40,077 24,678 50,000 50,000 Net Change in FV- Investments (2,364) 3,447 725 0 0 Annual Market Value Changes Interest Earnings 754 282 240 500 500 Other Revenues 0 2,212 0 0 0 Use of Reserve Funds 0 0 0 267,700 267,700 Residential Sewer Revenues 1,080,354 1,135,626 1,274,698 1,150,000 1,150,000 Apartment Sewer Revenues 95,269 101,697 106,160 100,000 100,000 Institutional Sewer Revenues 21,443 22,231 23,868 21,000 21,000 Commercial Sewer Revenues 61,252 63,367 65,411 61,000 61,000 Industrial Sewer Revenues 47,286 47,106 47,136 47,000 47,000 Penalties - Sewer Revenues 11,308 11,327 12,809 10,000 10,000 Gain or Loss from F/A Disposal 0 (3,421) 0 0 0 Transfer From 0 0 238,964 0 0 FUND TOTALS $1,444,695 $1,506,064 $1,994,630 $1,782,200 $1,782,200 2014 BUDGET WORKSHEETS SEWER UTILITY - EXPENDITURES - April 2, 2013 2013 2014 Object 2014 2010 2011 2012 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments - All Salary Costs Inclusive of 602 49450 101.00 Salaries & Benefits $421,600 Salary, Taxes, PERA & Benefits 602 49450 77 101.00 Administrative 117,536 110,563 120,762 107,300 110,400 602 49450 78 101.00 Technical /Clerical 158,239 136,305 144,154 144,200 148,400 602 49450 79 101.00 Maintenance 137,759 138,718 146,589 159,300 162,800 602 49450 xx 101.00 Salary & Benefit Contingency 0 0 0 0 0 602 49450 102.00 Full -Time Overtime 8,493 9,029 7,794 7,500 7,500 602 49450 103.00 Part-Time Salaries & Benefits 8,291 8,880 8,025 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,258 1,195 1,499 1,500 1,500 Inserts & Water Bill Statements 602 49450 01 209.00 Other Office Supplies 0 0 227 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 0 200 200 602 49450 01 224.00 Street Maintenance Materials 1,550 1,425 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 Supplies 667 18 3,292 5,000 5,000 MH Castings Replacement Prog. 602 49450 01 241.00 Small Tools 185 417 802 500 500 Wrenches, Shovels, etc. 602 49450 01 242.00 Minor Equipment 2,897 1,285 414 3,000 3,000 602 49450 01 303.00 Engineering Fees 27,500 602 49450 01 303.01 GIS 121 129 2,539 5,000 5,000 602 49450 01 303.02 Rate Study 0 0 0 0 7,500 602 4945493 30202 4 2i52 Sewer Stud 9 0 9 0 A 602 49450 01 303.04 Miscellaneous 4,721 4,148 2,395 15,000 15,000 Sewer System O &M Review 602 49450 01 304.00 Legal Fees 0 0 286 500 500 602 49450 01 312.00 Gopher State One -Call 2,315 2,092 2,559 3,500 3,500 Gopher State One -Call (M) 602 49450 01 313.00 Temporary Service Fees 1,913 14,559 0 0 0 602 49450 01 318.00 Contract Engineer 6,000 7,000 8,000 7,000 7,000 Contracted Engineer for City(20 %) 602 49450 01 319.00 Other Professional Services 10,000 6024945001 319.01 Televising 1,550 1,720 531 3,000 3,000 602 49450 01 319.02 Root Control 2,307 0 0 2,000 2,000 602 49450 01 319.03 Supervisory Controls(Maint Cont) 0 3,356 0 5,000 5,000 SCADA System 602 49450 01 320.00 Credit Card Activity Fees 0 0 0 0 0 1/3 Cost of C/C Pymt Processing 602 49450 01 321.00 Telephone Costs 2,284 2,312 2,646 2,500 2,500 Cell Phones, Modems, GPS 602 49450 01 322.00 Postage Costs 4,299 4,504 4,678 5,000 5,000 Billings with Inserts 6024945001 323.00 Radio Units 1,083 1,211 1,116 1,500 1,500 24 Units' $300 (Split 5 Ways) 6024945493 3310 TFavel FxpeRse 9 0 9 9 9 -Use 4370 602 4945441 233.99 CF61ig ! & Express Expenses 9 9 9 489 390 Mail IR RePail'S 6024945001 344 99 0 9 9 399 9 6924945493 34909 OtheF- Advertising 9 9 0 a89 0 602 49450 01 365.00 Workers Comp Insurance 6,643 7,109 6,828 7,000 7,000 Sewer's Share of Premiums 602 49450 01 369.00 Other Insurance 10,766 5.307 6,443 15,000 15,000 Sewer's Share of Premiums 602 49450 01 391.00 P.C. Maintenance 467 491 0 2,700 602 49450 01 391.01 U/B Software Maintenance 0 0 1,827 2,000 2,000 Added to Utility Budgets in 2012 602 49450 01 391.02 Auto Read Software Support 0 0 585 700 700 Added to Utility Budgets in 2012 602 49450 01 392.00 P.C. Accessories & Supplies 138 0 0 200 200 602 49450 01 393.00 P.C. Hardware Purchases 1,370 320 1,362 4,000 3,000 AV Enhancements at PW 602 49450 01 394.00 P.C. Software Purchases 5,378 4,574 7.800 602 49450 01 394.01 Licensing & Maintenance 0 0 4,779 4,800 6,500 Cartegraph, GIS 602 49450 01 394.02 Online Subscriptions 0 0 308 300 800 Pictometry 602 49450 01 394.03 New Software Purchases 0 0 7,772 4,400 500 AV Enhancements at PW 602 49450 01 395.00 P.C. Repairs 0 0 0 500 500 602 49450 01 40100 Contracted R & M - Other Impr 18,926 0 3,533 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 50 23 50 100 125 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 1,001 4,000 602 49450 01 437.01 MPCA Training (Sewer School) 0 23 90 800 1,500 Operator Licensure $300ea (M) 602 49450 01 437.02 Collection System Conference 0 950 1,310 1,000 0 Duplicate of Sewer School 437 01 602 49450 01 437.03 CarteGraph, ESRI, GIS 0 158 270 1,500 1,500 User Group, Conference, Training 602 49450 01 437.04 Miscellaneous Training 1,000 602 49450 01 439.00 Other Miscellaneous Charges 145 144 153 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 0 10,000 10,000 SCADA Reconfiguration, PLC'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 ^ 508,353 ^- 467,964 493,620 712,900 728,425 Page Two 2014 BUDGET WORKSHEETS SEWER UTILITY - EXPENDITURES - April 2, 2013 Account# Description 602 49450 01 602.00 Sewer Service Charges 602 49450 01 611.00 Interest on Lease Payments 602 49450 01 710.00 Transfers 602 - 49450 -01 TOTALS 602 49451 01 219.00 Other Operating Supplies 602 49451 01 221.00 Equipment Parts 602 49451 01 229.00 Other Maintenance Supplies 602 49451 01 303.00 Engineering Fees 602 4945181 321,00 Telephone Costs 602 49451 01 381.00 Electric Utilities 602 49451 01 403.00 Contracted R & M - Other Impr 602 49451 01 439.00 Other Miscellaneous Charges (City Hall) TOTAL - LIFT STATION #1 602 49452 01 219.00 Other Operating Supplies 602 49452 01 221.00 Equipment Parts 602 49452 01 229.00 Other Maintenance Supplies 60:2 4845281 32-1 -00 Telephone -Costs 602 49452 01 381.00 Electric Utilities 602 49452 01 403.00 Contracted R & M - Other Impr 602 49452 01 439.00 Other Miscellaneous Charges (Bloomfield 5th) TOTAL - LIFT STATION #7 602 49453 01 219.00 Other Operating Supplies 602 49453 01 221.00 Equipment Parts 602 49453 01 229.00 Other Maintenance Supplies 6024945301 32109 Telephone Costs 602 49453 01 381.00 Electric Utilities 602 49453 01 403.00 Contracted R & M - Other Impr 602 49453 01 439.00 Other Miscellaneous Charges (Shannon Pond) TOTAL - LIFT STATION #3 602 49454 01 219.00 Other Operating Supplies 602 49454 01 221.00 Equipment Parts 602 49454 01 229.00 Other Maintenance Supplies -002-0845401 32180 TelephGRe -Costs 602 49454 01 381.00 Electric Utilities 602 49454 01 403.00 Contracted R & M - Other Impr 602 49454 01 439.00 Other Miscellaneous Charges (Hawkins) TOTAL - LIFT STATION #4 602 49455 01 219.00 Other Operating Supplies 602 49455 01 221.00 Equipment Parts 602 49455 01 229.00 Other Maintenance Supplies 602 49455 01 303.00 Engineering Fees 602 49455 01 310.00 Testing Services &02- 49455 -01 321 00 Telephone CG6t 602 49455 01 381.00 Electric Utilities 602 49455 01 403.00 Contracted R & M - Other Impr 602 49455 01 439.00 Other Miscellaneous Charges (Blrger Pond) TOTAL - LIFT STATION #5 602 49456 01 219.00 Other Operating Supplies 602 49456 01 221.00 Equipment Parts 602 49456 01 229.00 Other Maintenance Supplies 6824945694 32100 Telephone Costs 602 49456 01 381.00 Electric Utilities 602 49456 01 403.00 Contracted R & M - Other Impr 602 49456 01 439.00 Other Miscellaneous Charges (Drumcliffe) TOTAL - LIFT STATION #6 2013 2014 Object 2014 2010 2011 2012 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments 923,221 981,478 940,900 1,030,000 1,030,000 MWCC Charges 3,554 3,232 2,893 0 0 P.W. Building Expansion(See 521) 0 172,451 10,493 0 0 Transfers for Other Improvements -- --- --- - -- 1,435,129 ---- ---- - --- 1,625,124 --- - - -- - -- 1,447,906 --- --- ----- -- -- -- ------ -- -- --- 1,742,900 ---- - - --- 1,758,425 0 0 0 100 100 182 4,215 21 800 800 0 0 0 200 200 0 5,499 0 0 0 0 0 8 0 0 948 1,058 925 1,500 1,500 0 0 0 200 200 0 0 0 100 100 Contingencies 1,129 - -- - -- 10,772 -__ - -- 947 ----- ---- -- -------- -- - - -- --------------- 2,900 2,900 0 0 0 100 100 0 2,697 59 800 800 0 0 0 200 200 2-44 211 485 0 0 _ _ -- 558 620 554 700 700 0 0 0 200 200 0 0 0 100 100 Contingencies 769 3,528 719 2,100 2,100 0 0 0 100 100 9,421 338 0 800 800 0 0 0 200 200 0 0 0 0 0 3,546 3,154 3,578 3,500 4,000 0 0 230 200 200 0 0 0 100 100 Contingencies 12,967 3,492 3,808 4,900 5,400 0 0 0 100 100 3,387 478 2,001 800 800 0 0 0 200 200 e 0 0 e e 5,560 4,898 5,377 6,000 6,000 0 3,195 0 200 10.000 Alarm Upgrades, SCADA, PLC 0 0 0 100 100 Contingencies 8,947 8,571 7,377 7,400 17,200 0 0 0 100 100 724 31,500 0 800 800 0 0 0 200 200 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5,125 5,609 5,879 6,000 7,000 0 0 0 200 200 0 0 0 100 100 Contingencies -- - - -- 5,849 - - - - -- 37,108 - - -- 5,879 - - - -- - - - -- 7,400 - - - - -- 8,400 0 0 0 100 100 203 118 4,247 800 800 0 0 0 200 200 0 0 0 0 0 5,060 6,614 3,788 7,500 5,000 0 0 0 200 3,000 Alarm Upgrades 0 0 0 100 100 Contingencies - - - -- 5,263 - -- - -- 6,732 - - - - -- 8,035 ---- --- - -- --- - - -- -- 8,900 ------ - - -- 9,200 Page Three 2014 BUDGET WORKSHEETS SEWER UTILITY - EXPENDITURES - April 2, 2013 2013 2014 Obiecl 2014 2010 2011 2012 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 1,659 0 0 500 500 602 49457 01 229.00 Other Maintenance Supplies 0 0 0 200 200 602 49457 01 321.00 Telephone Costs 0 0 0 0 0 6024945701 381.00 Electric Utilities 982 1,103 1,176 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 2,641 1,103 1,176 2,300 2,300 602 49458 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49458 01 221.00 Equipment Parts 237 6,612 353 500 500 602 49458 01 229.00 Other Maintenance Supplies 0 0 0 200 200 602 49458 01 321.00 Telephone Costs 0 0 0 0 0 602 49458 01 381.00 Electric Utilities 473 552 522 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 710 7,164 875 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 0 497 294 500 500 602 49460 01 229.00 Other Maintenance Supplies 0 0 0 200 200 602 49460 01 321.00 Telephone Costs 0 0 0 0 0 602 49460 01 381.00 Electric Utilities 183 295 251 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 -- -- ------------ 183 -- -- --- -- - - ---- 793 ------- ------- 545 -- -- ----- ------ 1,500 ---- -- ---- - --- -- ----- - - --- 1,500 GRAND TOTAL - ALLDEPTS. $1,473,586 --- - - - - -- --------- $1,704,387 --- - - - - -- --- - - - - -- $1,477,266 --- - - - - -- --- - - - - -- $1,782,200 -- - - - - - -- --- - - - - -- $1,809,325 -- - - -- -- --- - - - - -- -- - - - - -- --- - - - - -- 1.5 i Page One April 2, 2013 Account # 603 33400.00 603 33425.00 603 34108.00 603 36101.00 603 36102.00 603 36210.00 603 36214.00 603 36215.00 603 36260.00 603 36265.00 603 37300.00 603 37360.00 603 39203.00 Page One 2014 BUDGET WORKSHEETS STORM WATER UTILITY -REVENUES- 2013 2014 Object 2014 2010 2011 2012 Adopted Detail Proposed Description ---- — -------------- — — — — — — ------ — — — — — -- Actual --------- — — — — --- Actual — ------------ Actual ---------- — ----- Budget Amount - — ----- — ------- ----- — — -------- Budget ---- Comments State Grants & Aids $3,816 $0 $0 $0 $0 Other State Grants & Aids 1,208 0 0 0 0 Administrative Fees-Other Funds 590 2,123 5,733 0 0 5% of 5% Fees-Const Projects Principal - Special Assessments 17,868 22,204 22,418 20.000 20,000 Penalties & Interest - S/A 0 732 514 0 0 Interest Earnings - Investments 28,485 45,136 24,205 30,000 30,000 Net Change in FV-Investments (11.555) 2,198 479 0 0 Annual Market Value Changes Interest Earnings 617 245 262 400 400 Other Revenues 0 0 0 0 0 Use of Reserve Funds 0 0 0 0 0 Storm Water Utility Revenues 835,434 879,551 908,679 860,000 860,000 Penalties - Storm Water Utility 3,901 3,690 5,416 3,600 3,600 Transfer From 0 0 0 0 0 FUND TOTALS $880,364 $955,878 $967,705 $914,000 $914.000 2014 BUDGET WORKSHEETS STORM WATER UTILITY - EXPENDITURES - April 2, 2013 2013 2014 Object 2014 2010 2011 2012 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments -- - - - - -- - - - -- ------ ---- --- - - - - -- - - - - - -- ---- --- - -- ---- -- -- -- All Salary Costs Inclusive of 603 49500 101.00 Salaries & Benefits $176,800 Salary, Taxes, PERA & Benefits 603 49500 77 101.00 Administrative 0 0 4,036 10,700 11,000 603 49500 78 101.00 Technical /Clerical 95,473 76,109 88,359 79,600 81,600 603 49500 79 101.00 Maintenance 68,879 69,358 73,294 81,400 84,200 603 49500 xx 101.00 Salary & Benefit Contingency 0 0 0 0 0 603 49500 102.00 Full -Time Overtime 4,296 4,568 3,958 6,000 6,000 603 49500 99 103.00 Part-Time Salaries & Benefits 7,954 9,334 6,824 8,000 8,000 6034950001 203.00 Printed Forms &Paper 1,258 1,195 1,726 1,500 1,500 603 49500 01 204.00 Envelopes & Letterhead 0 0 0 0 0 603 49500 01 208.00 Miscellaneous Supplies 0 0 352 1,600 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 1,578 406 1,199 2,000 2,000 Blacktop & Gravel Washouts 603 49500 01 225.00 Landscaping Materials 4,000 603 49500 01 225.01 Rip -Rap, Matting, Rock, etc. 408 1,751 1,386 2,000 2,000 603 49500 01 225.02 Black Dirt, Seed, Sod, etc. 299 1,962 1,370 2,000 2,000 603 - 4850041 nine 03 _ _ 0 0 0 8 0 _ 603 49500 01 226.00 Sign Repair Materials 287 926 0 500 500 603 49500 01 230.00 Equipment Repair Material 204 534 881 1,000 1,000 603 49500 01 241.00 Small Tools 0 0 87 1,000 1,000 603 49500 01 242.00 Minor Equipment 2,747 332 221 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 31,441 10,003 3,501 10,000 10,000 603 49500 01 303.02 NPDES Phase II 28,763 0 29,749 30,000 30,000 603 49500 01 303.03 CSMP Update 15,076 22,880 36 0 0 603 49500 01 303.04 Miscellaneous 8,525 29,866 4,186 30,000 30,000 603 49500 01 303.05 GIS 0 0 1,672 5,000 5,000 603 49500 01 304.00 Legal Fees 0 234 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 Contract Inspection Fees 0 0 0 500 500 3rd Part Inspection Program (M) 603 49500 01 313.00 Temporary Service Fees 1,275 9,706 0 0 0 603 49500 01 315.00 Special Programs (County Program) 4,500 4,500 3,850 5,000 5,000 Wetland Health & Evaluation Proj 603 49500 01 318.00 Contract Engineer 6,000 7,000 8,000 7,000 7,000 Contracted Engineer for City(20 %) 603 49500 01 319.00 Other Professional Services 0 3,356 0 5,000 5,000 SCADA 603 49500 01 320.00 Credit Card Activity Fees 0 0 0 0 0 1/3 Cost of C/C Pymt Processing 603 49500 01 321.00 Telephone Costs 2,284 2,312 2,647 2,500 2,500 Cell Phones, Modems, GPS 603 49500 01 322.00 Postage Costs 4,299 4,504 4,678 5,000 5,000 Billings & Info Mailings 603 49500 01 323.00 Radio Units 1,083 1,210 1,116 1,500 1,500 24 Units' $300 (Split 5 Ways) 603 - 4950841 334 08 TFavel Expens 0 0 9 0 0 - -_ - 603 49500 01 352.00 General Notices & Public Info 58 0 0 1,000 1,000 Public Info Brochure 603 49500 01 365.00 Workers Comp Insurance 2,640 2,875 2,654 3,500 3,500 Storm Water's Share of Premiums 603 49500 01 369.00 Other Insurance 4,927 2,393 2,362 6,000 6,000 Storm Waters Share of Premiums 603 4850841 384 00 Refuse Disposal 9 0 0 600 0 &ea9side- Debris 602 48500 W 380 09 9 0 0 500 0 als Disposal 603 49500 01 391.00 P.C. Maintenance 467 491 2,700 603 49500 01 391.01 U/B Software Maintenance 0 0 1,827 2,000 2,000 Added to Utility Budgets in 2012 603 49500 01 391.02 Auto Read Software Support 0 0 585 700 700 Added to Utility Budgets in 2012 603 49500 01 393.00 P.C. Hardware Purchases 0 320 1,362 4,000 3,000 AV Enhancements at PW 603 49500 01 394.00 P.C. Software Purchases 5,378 4,574 7,800 603 49500 01 394.01 Licensing & Maintenance 0 0 4,779 4,800 6,500 Cartegraph, GIS 603 49500 01 394.02 Online Subscriptions 0 0 308 300 800 Pictometry 603 49500 01 394.03 New Software Purchases 0 0 7,772 4,400 500 AV Enhancements at PW 603 49500 01 403.00 Contracted R & M - Other Impr 55,000 603 49500 01 403.01 Ditching 0 0 0 5,000 5,000 603 49500 01 403.02 Miscellaneous Repairs 46,150 22,899 17,830 50,000 50,000 Storm System Maint., Catch Basins 603 49500 01 416.00 Machinery Rental 939 43 0 4,000 4,000 Pumps 603 49500 01 433.00 Dues & Subscriptions 140 140 140 0 0 603 49500 01 435.00 Books & Pamphlets 0 0 0 500 500 Utility Information 603 49500 01 437.00 Conferences & Seminars 3,700 603 49500 01 437.01 Storm Water Management 875 875 965 1,000 1.200 Stormwater Collab, Flygt Training 60349509 03 4270 Hydresa9 Tsa a ng 0 0 0 0 0 692 48594$1 43702 Wetiandr TFa RiR 0 0 9 590 9 603 49500 01 437.04 Carlegraph, ESRI, GIS 0 157 270 1,500 1,500 User Group, Conference, Training 603 49500 01 437.05 Miscellaneous Training 1,000 603 49500 01 439.00 Other Miscellaneous Charges 145 144 153 0 0 603 49500 01 530.00 Improvements Other Than Bldgs 150,000 603 49500 01 530.01 CRP of Storm Sewer 11,997 2,669 597 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 -- -------- - ---- ------------- 360,346 -- 299,624 ­­-­- - ----- 284,731 -- -------•----- -- 547,100 -- ------ -- ------- -- -- -- - - -- - -- 548,000 Page Two un^ BUDGET WORKSHEETS STORM WATER UTILITY sxpswoITvnsx April 2,uno 2013 2014 Object u/w xum 2011 e012 Adopted ovm/ pmnoso Account # ___________ oescn*m" a*"� __ ---------- ----------------- Actual ----------------- �mo o�om ____ ---- xm°�` ______________ a�u� Comments 603*950001 710.00 Transfers 87,000 6034950001 710.01 1mof2011px/p"'menmo996e> o o o o o Bonds Called 2/,mu 6034950001 rmuu 1mm2011p&/p°vmenw(1999o` o o o o o Bonds Called o1mo 603*950001 no.m 1om2011pu/povmenm(2001 a) o*.mm o o o o Bonds Called mo11 6034950 001 no.o* 1mm2011px/p°r"umvn0 1o/ o o o o o Bonds Paid off m1mo 6034950 001 ,m.00 1mm2011px/paymomo2002o) 33,000 8.000 o o o Bonds Called 21o11 603495001 710.06 1/2 of 2011p&/mymenmm1OA) o 60.000 84.000 89,000 87,000 New Refunding Issue 12n0 6034950001 ,m.m 1mm2011pu/paym°m"(2003A) 42,000 90.000 o o o Bonds Called ,2/vn 6034950001 num Projects 9,542 zm*m 68,296 o o 603-49500-01 TOTALS 498,888 e1.232 437,027 mm.,m 635,000 omwmvo, 221.00 Equipment Parts 1.771 o o mw mm 6034951101 381.00 Electric Utilities mm mw um mm mm 60349511 01 403,00 Contracted Repair &Maintenance o (Copper Pond) TOTAL ' LIFT STATION #1 u.o*n 26* uoo 1.000 _____--------------- 1.000 6034951201 221.00 Equipment Parts zn mm mm mm mm 6034951201 381o0 Electric Utilities o u o mm mm 6on^nmzo,^o1ooContracted Repair mMaintenance o (Schwarz Pond) TOTAL ' LIFT STATION #2 uor mm 000 1.000 1.000 voowm,3o1cu1.00 Equipment Parts o `,o o mm 000 mmwmmo,ox`.00 Electric Utilities /.mw *.^v, 2.698 *.mm ^.mm voo^s,3o`^ozoo Contracted Repair xMaintenance v (Binger Pond) ron`L LIFT STATION *m ,.ww *.nn 2,698 5,000 5,000 mmwewo, 221.00 Equipment Parts o 931 o 500 mm mmwmwv,ov,.vv Electric Utilities ,�mm ,.ma o^r ,.000 x.mm �`wm,+o, wm.� c���n�*^m��=� `,mm Alarm Upgrades (m°""ttep"nd) TOTAL ' LIFT STATION #4 ,,ms 2,585 o^r ,.ovv 5,500 vvawm,00,o1.00 Equipment Parts o o o vvv 000 000*o5,00,ou,.00 Electric Utilities o o o mm 000 603 4ymoo`*o3»o Contracted Repair uMaintenance `o,000 Alarm Upgrades, s:Au^,PLC (Hawkins Pond) TOTAL ' LIFT STATION wo -------------- o __ ---------- ----------------- o o ------- ------ 1.000 ------ ___ --- _______ 11,000 mmwm,00, 221.00 Equipment Parts v o o mm mm mmwmmo, 381.00 Electric Utilities ^o wo wm mm mm oo3^w`vv,^moo Contracted Repair uMaintenance n (o/^"dmmwhnm) TOTAL ' LIFT STATION #6 *a *m wm 1.000 1,000 GRAND TOTAL ' ALL ospro m510,73 $700152 w441.779 *647.600 $659,500