Loading...
HomeMy WebLinkAbout2017-05-15-H02 FY2017 Budget Amendment_PHNMI Wou kee ' WWI ♦ THE KEY TO GOOD IIVENG AGENDA ITEM: CITY OF WAUKEE, IOWA CITY COUNCIL MEETING COMMUNICATION MEETING DATE: May 151h 2017 AGENDA ITEM: On an amendment to the FY2017 Budget FORMAT: Public Hearing SYNOPSIS INCLUDING PRO & CON: After review of the current FY 17 budget, the following changes were needed: Revenue Sources: Licenses & Permits Use of Money & Property Intergovernmental Charges for Services Miscellaneous Other Financing Sources Transfers In Total Revenue Increases: Expenditure Programs: Public Safety Public Works Health & Social Services Culture & Recreation Community & Econ Dev General Government Debt Service Capital Projects Business Type/Enterprises Transfers Out Total Expenditure Increases: + $302,630 + $3,100 + $13,570 + $1,7I 7, 825 + $140, 645 + $1,720,000 + $(M000) $3,987,770 + $49,590 $(164,075) + $o + $66,895 + $44,095 + $518,260 + $1,725,389 + $0 + $1,529, 640 + $(10.000) FISCAL IMPACT INCLUDING COSTBENEFIT ANALYSIS: COMMISSION/BOARD/COMMITTEE COMMENT: $3,759,794 STAFF REVIEW AND COMMENT: Attached worksheets break down the increases by fund and departments. Review these worksheets and approve the FY2017 budget amendment as presented. RECOMMENDATION: Hold the public hearing. ATTACHMENTS: FY17 Notice of Public Hearing Amendment of Current City Budget FYI Budget Amendment Worksheets PREPARED BY: Linda Burkhart �� REVIEWED BY: PUBLIC NOTICE INFORMATION — NAME OF PUBLICATION: Dallas County News DATE OF PUBLICATION: May 4", 2017 Jun-15 NOTICE OF PUBLIC HEARING Fo,m 656C1 AMENDMENT OF FY2016-2017 CITY BUDGET The City Council of Waukee in DALLAS County, Iowa will meet at _Waukee City Hall 230 W Hickman Rd Waukee at 5:30 pm on 05/15/2017 MO roarer ,for the purpose of amending the current budget of the city for the fiscal year ending June 30, 2017 b changing estimates of revenue and expenditure a `n Y 9 9 p appropriations in the following functions for the reasons given. Additional detail is available at the city clerk's office showing revenues and expenditures by fund type and by activity. Total Budget as certified or last amended Current Amendment Total Budget after Current Amendment Revenues & Other Financing Sources Taxes Levied on Property 1 9 911 813 9,911,813 Less: Uncollected Property Taxes -Levy Year 2 0 0 Net Current Property Taxes 3 9,911,813 0 9,911,813 Delinquent Property Taxes 4 0 0 TIF Revenues 5 3,351,300 3,351,300 Other City Taxes 6 79,546 79,546 Licenses & Permits 7 1,077,850 302,630 1,380,480 Use of Money and Property 8 218,675 3,100 221,775 Intergovernmental 9 2,340,876 13,570 2,354,446 Charges for Services 10 15,985,000 1,717,825 17,702,825 Special Assessments 11 27,000 27,000 Miscellaneous 12 1,354,750 140,645 1,495,395 Other Financing Sources 13 15,045,600 1,720,000 16,765,600 Transfers In 14 5,691,972 -10,000 5,681,972 Total Revenues and Other Sources 15 55,084,382 3,887,770 58,972,152 Expenditures 8 Other Financing Uses Public Safety 16 5,086,730 777 49,5905136,320 777777777 Public works 17 3,043,254 -164,075 2,879,179 Health and Social Services 18 6,500 6,500 Culture and Recreation 19 1,880,554 66,895 1,947,449 Community and Economic Development 20 1,052,775 44,095 1,096,870 General Government 21 971,958 518,260 1,490,218 Debt Service 22 6,997,179 1,725,389 8,722,568 Capital Projects 23 11,653,500 11,653,500 Total Government Activities Expenditures 24 30,692,450 2,240,154 32,932,604 Business Type/Enterprises 25 18,799,001 1,529,640 20,328,641 Total Gov Activities& Business Expenditures 26 49,491,451 1 3,769,794 53,261,245 Transfers Out 27 5,691,972 -10,000 5,681,972 Total Expend ituresfTransfersOut 28 55,183,423 3,759,794 58,943,217 Excess Revenues & Other Sources Over (Untler) Expentldure!R7nsfers Out Fiscal Year 29 7777777777777777777777777777 -99 041 127,976 28,935 Beginning Fund Balance July 1 30 31,449,940 31,449,940 Ending Fund Balance June 30 31 31,350,899 127.976 31,478,875 Explanation of increases or decreases In revenue estimates, appropriations, or available cash Revenue -Major Changes - Bldg Permits, Park Trail Fees, Community Grant, Debt Service Bond Refunding Proceeds, and Utility User & Developer Fees Expenditure - Major Changes - Reduced Health & Property Insurance, Increased Police, Westcom and Fire/EMS, Bike Trails, Park Land Purchases, ROW acquisition, Debt Service Bond Refuding, Water COGS, and Sewer Projects There will be no increase in tax levies to be paid in the current fiscal year named above related to the proposed budget amendment. Any increase in expenditures set out above will be met from the increased non -property tax revenues and cash balances not budgeted or considered in this current budget. Linda Burkhart, Finance Director City Clerk/ Finance Officer Name Total Expended Original Increase/ Amended Year To Date Balance Budget Decrease Budget thru 5/10/2017 Remaining O10 General Fund $9,736,705 $460,735 $10,197,440 $8,004,255 $2,193,185 060 Road Use Tax Fund $2,145,066 $0 $2,145,066 $1,844,541 $300,525 091 Hickman West Industrial Park TIF $421,355 $0 $421,355 $0 $421,355 092 Enterprise Business Park TIF $232,550 $0 $232,550 $0 $232,550 093 Waukee Urban Renewal Area TIF $2,988,360 $44,030 $3,032,390 $28,547 $3,003,843 094 Gateway Urban Renewal Area TIF $0 $0 $0 $14,411 ($14,411) 095 Autumn Ridge Urban Renewal Area TIF $0 $0 $0 $521 ($521) 110 Debt Service Fund $6,951,481 $1,725,389 $8,676,870 $8,643,467 $33,403 111 Special Assessments Fund $45,698 $0 $45,698 $45,698 $0 210 Employee Benefits $1,500,285 $0 $1,500,285 $0 $1,500,285 327 Capital Projects $11,653,500 $0 $11,653,500 $5,300,396 $6,353,104 510 Water Utility Fund $3,910,801 $400,250 $4,311,051 $2,682,811 $1,628,240 520 Sewer Utility Fund $7,003,697 $1,096,250 $8,099,947 $6,824,244 $1,275,703 540 Gas Utility Fund $5,590,810 $0 $5,590,810 $3,628,193 $1,962,617 560 Storm Water Utility Fund $1,148,970 $0 $1,148,970 $686,974 $461,996 570 Utility Bill Fund $264,790 $0 $264,790 $193,583 $71,207 590 Solid Waste Collect & Rcycl Fund $1,081,760 $33,140 $1,114,900 $1,009,035 $105,865 750 Golf Course Fund $507,595 $0 $507,595 $466,654 $40,941 810 Equipment Revolving Fund $0 $0 $0 $0 $0 Total Collected Original Increase/ Amended Year To Date Balance Budget Decrease Budget thru 5/10/2017 Remaining O10 General Fund $9,520,350 $540,590 $10,060,940 $9,972,516 $88,424 060 Road Use Tax Fund $1,822,167 $0 $1,822,167 $1,799,756 $22,411 091 Hickman West Industrial Park TIF $576,400 $0 $576,400 $571,702 $4,698 092 Enterprise Business Park TIF $600 $0 $600 $1,018 ($418) 093 Waukee Urban Renewal Area TIF $2,780,500 $0 $2,780,500 $2,763,209 $17,291 094 Gateway Urban Renewal Area TIF $0 $0 $0 $0 $0 095 Autumn Ridge Urban Renewal Area TIF $0 $0 $0 $0 $0 110 Debt Service Fund $6,999,755 $1,720,000 $8,719,755 $4,461,940 $4,257,815 111 Special Assessments $42,200 $0 $42,200 $32,533 $9,667 210 Employee Benefits Fund $1,504,285 $0 $1,504,285 $1,450,108 $54,177 327 Capital Projects $11,653,500 $0 $11,653,500 $1,283,744 $10,369,756 330 City Wide Spec Assess -Sidewalk Prog $0 $0 $0 $5,025 ($5,025) 510 Water Utility Fund $3,671,507 $429,110 $4,100,617 $3,812,942 $287,675 520 Sewer Utility Fund $3,714,066 $1,132,030 $4,846,096 $4,284,133 $561,963 521 University Ave Trunk Sewer Fund $0 $0 $0 $5,956 ($5,956) 522 Waste Water Treatment Plant Fund $0 $0 $0 $112 ($112) 523 E Area Pump Station Fund $0 $0 $0 $392 ($392) 540 Gas Utility Fund $5,491,100 $0 $5,491,100 $5,076,424 $414,676 560 Storm Water Utility Fund $891,150 $0 $891,150 $831,503 $59,647 570 Utility Bill Fund $264,750 $0 $264,750 $192,151 $72,599 590 Solid Waste Collection Fund $1,101,160 $76,040 $1,177,200 $980,121 $197,079 750 Golf Course Fund $592,300 ($10,000) $582,300 $405,914 $176,386 810 Equipment Revolving Fund $30,000 $30,000 $427 $29,573 Original Amount Amended Total Expended Balance Budget to Amend Budget Year To Date Remaining Police $2,661,080 $30,770 $2,691,850 $2,232,482 $459,368 Warning Sirens $2,000 $ - $2,000 $989 $1,011 Westcom Dispatch $430,500 $ 43,500 $474,000 $414,845 $59,155 Fire $830,720 ($36,810) $793,910 $647,544 $146,366 EMS $762,600 $27,095 $789,695 $640,939 $148,756 Code Compliance $398,830 ($23,465) $375,365 $309,587 $65,778 Animal Control $1,000 $8,500 $9,500 $5,700 $3,800 Public Works $73,644 ($14,810) $58,834 ($47,249) $106,083 Public Works Building $0 ($29,800) ($29,800) $156,716 ($186,516) Public Works Mechanic $171,750 $50,930 $222,680 $283,450 ($60,770) Engineering $625,139 ($182,885) $442,254 $371,550 $70,704 GIS $27,655 $12,490 $40,145 $1,179 $38,966 Mosquito Control $6,500 $0 $6,500 $0 $6,500 Library $852,275 ($2,490) $849,785 $637,918 $211,867 Parks $480,297 $80,255 $560,552 $405,874 $154,678 Recreation $523,662 ($8,795) $514,867 $443,685 $71,182 Community Center $24,320 ($2,075) $22,245 $15,404 $6,841 Median Maintenance $14,000 $0 $14,000 $6,924 $7,076 Community Development $324,240 $30,260 $354,500 $278,158 $76,342 Development Services $524,535 ($30,195) $494,340 $311,252 $183,088 Mayor & Council $72,840 ($6,350) $66,490 $52,299 $14,191 Elections $8,000 ($8,000) $0 $0 $0 Communications $114,808 ($8,000) $106,808 $34,462 $72,346 Administration $348,250 $545,915 $894,165 $581,107 $313,058 City Hall $79,000 ($16,170) $62,830 $48,556 $14,274 Human Resources $80,138 $3,395 $83,533 $31,154 $52,379 Finance $168,922 ($15,195) $153,727 $68,358 $85,369 City Attorney $100,000 $0 $100,000 $66,100 $33,900 Information Technology $0 $22,665 $22,665 $5,272 $17,393 Transfers $30,000 ($10,000) $20,000 $0 $20,000 $9,736,705 $460,735 $10,197,440 $8,004,255 $2,193,185 Original Amount Amended Total Collected Balance Budget to Amend Budget Year To Date Remaining Property Tax $5,722,340 $0 $5,722,340 $5,510,820 $211,520 Other City Tax $16,700 $0 $16,700 $11,300 $5,400 License, Permits & Fees $1,070,850 $308,280 $1,379,130 $1,204,092 $175,038 Use of Money & Property $135,025 $3,100 $138,125 $126,894 $11,231 Intergovernmental $359,350 $13,570 $372,920 $368,480 $4,440 Charges for Services $571,350 $74,995 $646,345 $541,171 $105,174 Misc $144,450 $140,645 $285,095 $270,753 $14,342 Other Finance Sources $0 $0 $0 $0 $0 Transfers In $1,500,285 $0 $1,500,285 $1,939,006 ($438,721) $9,520,350 $540,590 $10,060,940 $9,972,516 $88,424 Budget, Proposed Revenue Expenditures Reserve Inc/(Dec) Inc/(Dec) Inc/(Dec) $ 15,175 $ 30,770 $ (15,595) Police Dept Warning Sirens $ - $ _ $ - Westcom Dispatch $ - $ 43,500 $ (43,500) Fire $ 9,165 $ (36,810) $ 45,975 EMS $ 1,150 $ 27,095 $ (25,945) Code Compliance $ 263,600 $ (23,465) $ 287,065 Animal Control $ 5,650 $ 8,500 $ (2,850) $ $ 294,740 - $ $ 49,590 (14,810) $ $ 245,150 14,810 Public Works Public Works Building $ - $ (29,800) $ 29,800 Public Works Mechanic $ 31,500 $ 50,930 $ (19,430) Engineering $ (44,500) $ (182,885) $ 138,385 GIS $ - $ 12,490 $ 12,490) $ $ (13,000) - $ $ (164,075) _ $ $ 151,075 - Mosquito Control $ $ 6,080 $ $ (2,490) $ $ 8,570 Library Parks $ 231,470 $ 80,255 $ 151,215 Recreation $ 23,800 $ (8,795) $ 32,595 Community Center $ 7,500 $ (2,075) $ 9,575 $ 268,850 $ 66,895 $ 201,955 Median Maintenance $ - $ - $ _ Community Development $ - $ 30,260 $ (30,260) Development Services $ - $ (30,195) $ 30,195 $ $ - - $ $ 65 (6,350) $ $ (65) 6,350 Mayor & Council Elections $ - $ (8,000) $ 8,000 Communications $ - $ (8,000) $ 8,000 Administration $ - $ 545,915 $ (545,915) City Hall $ - $ (16,170) $ 16,170 Human Resources $ - $ 3,395 $ (3,395) Finance $ (10,000) $ (15,195) $ 5,195 City Attorney $ _ $ _ Information Technology $ - $ 22,665 $ (22,665) $ (10,000) $ 518,260 $ (528,260) Transfer to Commerce Bank Reserve $ - $ (10,000) $ 10,000 Sale Property $ - $ _ $ - $ - $ (10,000) $ 10,000 General Fund Totals $ •, , Road Use Fund TIF Funds Debt Service Fund Capital Projects Funds Water Fund Sewer Fund Gas Fund Storm Water Fund Utility Billing Fund Solid Waste Fund Golf Course Fund Equipment Reserve Fund Proposed Revenue Expenditures Reserve Inc/(Dec) Inc/(Dec) Inc/(Dec) $ - $ 44,030 $ (44,030) $ 1,720,000 $ 1,725,389 $ (5,389) $ 429,110 $ 400,250 $ 28,860 $ 1,132,030 $ 1,096,250 $ 35,780 $ 76,040 $ 33,140 $ 42,900 $ (10,000) $ - $ (10,000) :0 Current Proposed G/L Acd IF Budget YTD Actual Change Budget 010-10.1900,4300000 BUILDING PERMITS $ 275,000 $ 800,000 $ 525,000 $ 678,391 010-10.1900.4300010 RENTAL INSPECTION FEES $ 30,000 $ - $ (30,000) $ 010-10.1900.4310100 SUBDIVISION PLATING FEES $ 3,500 $ 9,150 $ 7,000 $ 10,500 010-10.1900.4320100 SITE PI -AN REVIEW FEES $ 4,000 $ 12,000 $ 11,000 $ 15,000 010-10.1900.4320300 RIGHT OF WAY PERMITS $ 400 $ 2,000 $ 1,600 $ 2,000 010-10,1900,4320400 SUBDIVISION PLAT FEES -WARNING SIRENS $ 2,000 $ 3,535 $ 2,500 $ 4,500 010-10.2400.4031000 DOG LICENSES $ 600 $ 276 $ 5,400 $. 6,000 010-10.2400.4031100 CAT LICENSES $ 50 $ 38 $ 250 $ 300 010-40.4100.4520000 PARKLAND DEDICATION FEES $ - $ 4,163 $ 4,160 $ 4,160 010-40.4100.4520050 BIKE TRAIL FEES $ - $ 75,869 $ 75,870 $ 75,870 010-20.8900.4320000 ENGINEER REVIEW REIMBURSEMENT $ 200,000 $ 20,272 $ (155,000) $ 45,000 010-20.9900.4320600 CONSTRUCTION INSPECTION FEES $ 200,000 $ 194,430 $ 120,000 $ 320,000 010-20.8900.4320700 ENGINEER ADMINISTRATION FEES $ 14,500 $ 3,433 $ (9,500) r: :I $ 5,000 $ 60,000 $ 27,300 O70-40.4100,4530050 PARK LAND RENT $ (5,400) $ 54,600 010-40.4100.4530200 BALL FIELD RENT $ 1,500 $ 1,675 $ 1,000 $ 2,500 010-40.4300.4531000 COMMUNITY CENTER RENT $ 10,000 $ 15,363 $ 7,500 $ 17,500 $ 122,950 $ 127,590 O10-30.1100.4020300 RESOURCE OFFICER REIMBURSEMENT $ 4,640 $ 127,590 010-10.1400.4110000 TOWNSHIP FIRE TAX $ 56,000 $ 58,776 $ 5,000 $ 61,000 010-10.1400.4130000 FIRE TRAINING GRANT $ - $ 1,450 $ 1,450 $ 1,450 010-10.1500.4130000 EMT TRAINING GRANT $ - $ 1,000 $ 1,000 $ 1,000 010-40.3100.4410000 LIBRARY OPEN ACCESS $ 21,000 $ 24,401 $ 3,400 $ 24,400 01040.3100.4430000 COUNTY LIBRARY SERVICES $ 12,000 $ 9,337 $ (1,920) $ 10,080 030-40.3100.4410000 LIBRARY OPEN ACCESS $ - r $ 6,500 $ 6,745 O10-10.1100.4010200 POLICE ACCIDENT REPORTS $ 1,255 $ 7,755 010-10.1100.4030300 SAFETY CITY REGISTRATION FEES $ 12,000 $ 14,000 $ 4,000 $ 16,000 010-10.1400.4010200 FIRE REPORTS $ - $ 1,885 $ 2,000 $ 2,000 010-40,3100.3770100 COPIES, FAXES, MAPS $ 4,000 $ 1,903 $ (1,300) $ 2,700 010-40,4100.6010010 PLANTSOME SHADE $ - $ 17,841 $ 17,940 $ 17,840 010-40.4200.4516400 CITIZEN TRIPS/OUTINGS $ 1,500 $ 6,349 $ 6,000 $ 7,500 01040.4200.4517000 WINTER PROGRAMS $ 10,000 $ 23,704 $ 13,700 $ 23,700 010-20.6150.6200600 MECHANIC FEES - ROADS $ 45,000 $ 36,540 $ 14,000 $ 59,000 010-20.6150.6201100 MECHANIC FEES - POLICE $ 1,500 $ 1,167 $ 600 $ 2,100 010-20.6150.6204100 MECHANIC FEES - PARKS $ 16,000 $ 9,021 $ (1,500) $ 14,500 010-20.6150.6205100 MECHANIC FEES - WATER $ 24,000 $ 19,813 $ 8,000 $ 32,000 010-20.6150.6205200 MECHANIC FEES SEWER $ 39,000 $ 26,458 $ 6,000 $ 45,000 010-20.6150.6205400 MECHANIC FEES GAS $ 31,000 $ 23,346 $ 6,000 $ 37,000 010-20.6150.6205600 MECHANIC FEES - STORM WATER $ 4,500 $ 1,473 $ 500 $ 5,000 010-20.6150.6207500 MECHANIC FEES - GOLF COURSE $ 3,000 $ 130 $ (2,000) $ 1,000 010-20.6150.6208900 MECHANIC FEES - ENGINEERING $ 3,300 $ 1,624 $ (1,000) $ 2,300 010-20.6150.6208950 MECHANIC FEES -GIS $ 500 $ 1,195 $ 900 $ 1,400 Miscellaneous 010-10.1100.4030000 POLICE DONATIONS $ - $ 5,280 $ 5,280 $ 5,280 010-10.1400.3760300 SALE OF OLD EQUIPMENT $ - $ 562 $ 565 $ 565 010-10,1400.3775600 PATRONAGE REBATE $ - $ 150 $ ISO $ 150 010-10.1500.3775600 PATRONAGE REBATE $ - $ 150 $ 150 $ 150 010-10.1900.3530000 MOWNG WEEDS $ 2,500 $ 190 $ (2,000) $ Soo 010-10.1900.3530100 SNOW REMOVAL FEES $ 1,500 $ - $ (1,500) $ 030-40.3100A450000 LIBRARY FINES &BOOK CHARGES $ 9,000 $ 7,954 $ 1,400 $ 10,400 010-40.3100.4460000 LIBRARY DONATIONS $ 1,500 $ 5,964 $ 4,500 $ 6,000 010-40.4100.3770450 COMMUNITY GRANTS $ 12,000 $ 150,000 $ 138,000 $ 150,000 010-40.4200,3761400 FALL FESTIVAL DONATIONS $ - $ 2,000 $ 2,000 $ 2,000 010-40.4200.4511000 FALL FESTIVAL PROCEEDS $ - $ 1,000 $ 1,000 $ 1,000 010-40.4200.4511100 WAUKTOBER FEST PROCEEDS $ 2,000 $ 3,091 $ 1,100 $ 3,100 010-60.8400.3775550 COMMERCE BANK REVENUE SHARE $ 30,000 $ 18,671 $ (10,000) $ 20,000 General Fund - FY2017 Proposed Expenditure Budget Amendment Current Proposed Health/Life/ Other Pre -Approved Changes Admin/Fin Proposed G/L ALct It Description Budget YTD Actual LTD/WC Change Change Reason Recommend Budget 010-10-1100.010MO SALARIES $ _ 010-10-1100.010500 OVERTIME PAY $ 120,000 $ 96,893 $ 10,000 $ 130,000 010-10.1100-100000 HEALTH &LIFE INSURANCE $ 341,100 $ 254,075 $ (30,100) $ (30,100) $ 311,000 010-10.3300A02000 SECTION 125 FLEX BENEFIT $ 3,000 $ 1,125 $ (1,500) $ (1,500) $ 1,500 010-10.1100.110000 WORKERS COMPENSATION $ 22,920 $ 20,149 $ (2,770) $ (2,770) $ 20,150 010-10.1100.120000 UNIFORMS $ 19,750 $ 27,990 $ 14,250 $ 34,000 010-10-1100.150000 EMPLOYEE ASSISTANCE PROGRAM $ 450 $ - $ (450) $ (450) $ 010-10.1100.230000 CONSULTANT& PROFESSIONAL FEES $ 6,200 $ 2,746 $ 3,800 $ 10,000 010-10.1100.270000 DATA PROCESSING $ 6,000 $ 845 $ (4,000) $ 2,000 010-10.1100.270100 COMPUTER SUPPORT $ 13,600 $ 18,994 $ 8,900 $ 22,500 010-10. 1100.270110 COPIER / PRINTER LEASE & MAINT $ 12,400 $ 11,253 $ 2,600 $ 15,000 010-10.1100.280000 DUES, MEMBERSHIPS&SUBSCRIPT $ 3,500 $ 3,302 $ 500 $ 4,000 010-10.1100.290000 GENERAL LIABILITY INSURANCE $ 1,200 $ 310 $ (890) ANNUAL RENEWAL CHG $ (890) $ 310 010-10.1100.290100 VEHICLE INSURANCE $ 3,000 $ 715 $ (2,280)ANNUAL RENEWAL CHG $ (2,280) $ 720 010-10.1100.290300 BUILDING& CONTENTS INSURANCE $ 6,000 $ 1,203 $ (4,790) ANNUALRENEWALCHG $ (4,790) $ 1,210 010-10.1100.290400 LAW ENFORCEMENT LIABILITY INS $ 8,000 $ 1,743 $ (6,250) ANNUAL RENEWAL CHG $ (6,250) $ 1,750 010-10.1100,360000 POSTAGE&SHIPPING $ 600 $ 588 $ 250 $ 850 010-10.1100.390000 RENTAL/LEASE OF EQUIPMENT $ 3,500 $ $ (3,500) $ 010-10.1300.400100 CUSTODIAL $ 5,100 $ 7,726 $ ,00 $ 1,000 010-10.1300.410000 REPAIR OF VEHICLES $ 12,000 $ 14,560 $ 6 6,0000 $ 18,000 010-10.1100.410050 REPAIR/MAINTENANCE-WAUKEE MECH $ 3,000 $ 1,167 $ (1,400) $ 1,600 010-10.1100.410100 REPAIR/MAINTENANCE OF EQUIPMEN $ - $ 200 $ 200 $ 200 010-10.1100.410200 REPAIR/MAINTENANCE OF ELECTRON $ 7,000 $ 1,545 $ (2,500) $ 4,500 010-10.1100.450000 TELEPHONE $ 70,000 $ 17,295 $ 4,000 $ 24,000 010-10.1100.470010 AMMUNITION $ - $ 11,891 $ 12,500 $ 12,500 010-10.1100.540000 MINOR EQUIPMENT $ 16,000 $ 33,281 $ 19,000 $ 35,000 010-10.1300.560000 MOTOR VEHICLE MAINT SUPPLIES $ 10,000 $ 3,794 $ (2,500) $ 7,500 010-10.1100.570000 FUEL $ 45,000 $ 23,655 $ (10,000) $ 35,000 010-10.1100.590000 OPERATING SUPPLIES & MATERIALS $ 3,000 $ 10,294 $ 11,000 $ 14,000 010-10.1100.710000 AUTOMOTIVE EQUIPMENT $ 117,200 $ 121,928 $ 4,800 $ 122,000 010-10.1100.830100 LEASEHOLD IMPROVEMENTS $ I I $ - 010-10.1110.290300 Building & Contents Insurance 010-10.1110.400000 Total Warning Repairs/Maintenance-Sirens Sirens Dept Proposed Amendment MOM $ 425,500 $ 381,082 5 $ $ $ 23,500 $ 449,000 010-10.1300.230010 Westcom Dispatch Services 010-10.1300.740000 Total Westcom OFFICE EQUIPMENT Dispatch Dept Proposed Amendment - $ $ 20,000 RMS SYSTEM $ 20,000 $ 20,000 $ s 20.0w $ $ t 010-10.1400.010000 SALARIES 010-10.1400.010500 OVERTIME PAY $ 27,500 $ 26,532 $ 5,000 $ 32,500 010-10-1400.011000 PARTTIME $ - $ 3,520 $ 3,520 $ 3,520 010-10.1400.011500 PER CALL COMPENSATION $ 150,000 $ 112,041 $ 5,000 $ 155,000 010-10.1400.060000 FICA CONTRIBUTION $ 28,570 $ 21,130 $ 840 $ 29,410 010-10.1400.070000 MEDICARE CONTRIBUTION $ 6,870 $ 4,943 $ 200 $ 7,070 010-10.1400,080000 IPERS CONTRIBUTION $ 45,290 $ 31,751 $ 1,370 $ 46,660 010-10.1400,100000 HEALTH & LIFE INSURANCE $ 72,700 $ 48,646 $ (12,200) $ (12,200) $ 60,500 010-10.1400.102000 SECTION 125 FLEX BENEFIT $ _ 010-10.1400.130000 WORKERS COMPENSATION $ 90,750 $ 69,122 $ (21,250) $ (21,250) $ 69,500 010-10.1400-150000 EMPLOYEE ASSISTANCE PROGRAM $ 90 $ - $ (90) $ (90) $ 010-10.1400.270100 COMPUTERSUPPORT $ 010-10.1400.290000 GENERAL LIABILITY INSURANCE $ 2,500 $ 647 $ (1,850) ANNUAL RENEWAL CHG $ (1,850) $ 650 010-10.1400.290100 VEHICLE INSURANCE $ 18,000 $ 3,850 $(14,150) ANNUAL RENEWAL CHG $ (14,150) $ 3,850 010-10,1400.290300 BUILDING& CONTENTS INSURANCE $ 4,000 $ 797 $ (3,200) ANNUAL RENEWAL CHG $ (3,200) $ 800 010-10.1400.740000 OFFICE EQUIPMENT $ - $ $ $ _ _ $ 010-10.1500.010000 SALARIES 030-10A500.030500 OVERTIME PAY $ 19,000 $ 26,466 $ 17,000 $ 36,000 010-10A500.011500 PER CALL COMPENSATION $ 140,000 $ 112,335 $ 10,000 $ 150,000 010-10.1500.060000 FICA CONTRIBUTION $ 27,470 $ 21,262 $ 1,67S $ 29,145 010-10.1500.070000 MEDICARE CONTRIBUTION $ 6,470 $ 4,971 $ 400 $ 6,870 010-10.1500.080000 IPERS CONTRIBUTION $ 43,490 $ 32,329 $ 2,740 $ 46,230 010-10.1500.100000 HEALTH & LIFE INSURANCE $ 72,700 $ 54,263 $ (6,500) $ (1,870) $ 010-10.1500.110000 WORKERS COMPENSATION $ 47,750 $ 49,619 $ 1,870 $ 1,890 $ 49,620 49,62- 010-30.1500.150000 EMPLOYEE ASSISTANCE PROGRAM $ 90 $ - $ (90) $ (90) $ - 010-10.1500.710000 AUTOMOTIVE EQUIPMENT $ Current Proposed Health/Life/ Other Pre -Approved Changes Admin/Fin Proposed G/LAW# Description Budget WD Actual LTD/WC Change Change Reason Recommend Budget 010-10.1900.010000 SALARIES $ 215,100 $ 163,348 $ 5,700 $ 220,800 010-10.1900,060000 FICA CONTRIBUTION $ 13,660 $ 10,286 $ 360 $ 14,020 010-10.1900.070000 MEDICARE CONTRIBUTION $ 3,270 $ 2,405 $ 85 $ 3,355 010-10.1900-080000 IPERS CONTRIBUTION $ 19,700 $ 15,032 $ 510 $ 20,210 010-10-1900-100000 HEALTH & LIFE INSURANCE $ 78,700 $ 36,116 $ (33,500) $ (33,500) $ 45,200 010-10-1900-110000 WORKERS COMPENSATION $ 2,720 $ 1,492 $ (1,220) $ (1,220) $ 1,500 010-10-1900.150000 EMPLOYEE ASSISTANCE PROGRAM $ 80 $ - $ (80) $ (80) $ 010-10.1900.230000 CONSULTANT & PROFESSIONAL FEES $ - $ 665 $ 1,000 $ 1,000 010-10.1900.230250 NUISANCES - SNOW REMOVAL $ 1,500 $ - $ (1,500) $ - 010-10.1900.290000 GENERAL LIABILITY INSURANCE $ 700 $ 155 $ (540) ANNUAL RENEWAL CHG $ (540) $ 160 O10-10.1900.290100 VEHICLE INSURANCE $ 600 $ 120 $ (480) ANNUAL RENEWAL CHG $ (480) $ 120 010-10.1900.710000 AUTOMOTIVE EQUIPMENT $ 25,000 $ 24,370 $ (fi00) $ 24,400 010-10.1900-740000 OFFICE EQUIPMENT $ $ 2,500 1,000 $ $ 9,269 4,620 rr r r $ 5 6,800 8,500 $ $ 9,300 9,500 10,2400.340000 Miscellaneous Contractual Total Animal Control Proposed Amendment ITotal Public Safety Program Proposed Amendment $ 78,680 $ 54,278 $ $ (107,790) (11,680) $ (14,430) is $ $ 8,50 (11,680) $ 67,000 010-20.6000.100000 HEALTH &LIFE INSURANCE 010-20.6000.110000 WORKERS COMPENSATION $ 2,200 $ 1,653 $ (540) $ (540) $ 1,660 010-20.6000.150000 EMPLOYEE ASSISTANCE PROGRAM $ 100 $ - $ (100) $ (100) $ 010-20.6000.290000 GENERAL LIABILITY INSURANCE $ 2,900 $ 807 $ (2,090) ANNUAL RENEWAL CHG $ (2,090) $ 810 010-20.6000.290100 VEHICLE INSURANCE $ 500 $ 91 $ (400) ANNUAL RENEWAL CHG $ (400) $ 100 010-20.6000.691100 PUBLIC WORKS BLDG REIMBURSE $ - 030-20.6000.780000 STREETSIGNS $ $ - 010-20.6010.270110 COPIER/PRINTER LEASE &MAINT 010-20.6010.290300 BUILDING& CONTENTS INSURANCE $ 21,000 $ 4,672 $(16,300) ANNUAL RENEWAL CHG $ (16,300) $ 4,700 010-20.6010.480000 UTILITY SERVICES $ 54,000 $ 22,678 $ (14,000) $ 30p00 010-20.6010.880100 Total Public Works PUBLIC WORKS BUILDING IMPROVE Building $ - $ 10,500 $ 10,500 $ 10,500 Proposed Amendment $ (16,300) $ $ 800 - 010-20.6150.010000 SALARIES 010-20.6150-100000 HEALTH &LIFE INSURANCE $ 27,500 $ 19,278 $ (3,500) $ (3,500) $ 24,000 010-20.6150.110000 WORKERS COMPENSATION $ 1,900 $ 1,612 $ (280) $ (280) $ 1,620 010-20.6150.150000 EMPLOYEE ASSISTANCE PROGRAM $ 50 $ - $ (50) $ (50) $ - 030-20.6150.290100 VEHICLE INSURANCE $ 300 $ 57 $ (240) ANNUAL RENEWAL CHG $ (240) $ 60 010-20.6150.570130 COGS - PARTS $ 60,000 $ 82,181 $ 55,000 $ I35,000 010-20.6150.760000 OTHER CAPITAL EQUIPMENTTotal Public Works Mechanic Proposed Amendment $ 190,900 $ 171,293 (3,830) $ .r $ 54,100 $ 245,000 010-20.8900.0100000 SALARIES 010-20A900.010500 OVERTIME PAY $ 55,000 $ 27,580 $ (1,0) $ 45,000 O10-20.8900.060000 FICA CONTRIBUTION $ 15,300 $ 12,289 $ 2 ,75]50 $ 1818,050 010-20.8900.070000 MEDICARE CONTRIBUTION $ 3,600 $ 2,874 $ 50 $ 4,50 O10-20.8900.080000 IPERS CONTRIBUTION $ 22,000 $ 17,695 $ 3,950 $ 25,950 010-20.8900.102000 SECTION 125 FLEX BENEFIT $ - $ 83 $ 210 $ 210 010-20-8900.110000 WORKERS COMPENSATION $ 2,100 $ 1,589 $ (510) $ (510) $ 1,590 010-20.8900.150000 EMPLOYEE ASSISTANCE PROGRAM $ 75 $ - $ (75) $ (75) $ - 010-20,8900.190100 PERSONNEL SERVICES REIMBURSEMENT $ - $ (52,810) $ (52,810) $ (52,810) 010-20.8900.210000 PUBLIC NOTIFICATION/ADVERTISING $ - $ 835 $ 850 $ 850 010-20.8900.231200 DEVELOPERS ENGINEERING REVIEW $ 200,000 $ 24,152 $ (161,000) $ 39,000 O10-20.8900.290000 GENERAL LIABILITY INSURANCE $ 600 $ 155 $ (440) ANNUAL RENEWAL CHG $ (440) $ 160 010-20.8900.290100 VEHICLE INSURANCE $ 500 $ 190 $ (310)ANNUAL RENEWAL CHG $ (310) $ 190 010-20.8900.470000 TRAINING/TRAVEL EXPENSE $ 13,600 $ 2,647 $ (8,200) $ 5,400 010-20.8900,740000 OFFICE EQUIPMENT $ 25,000 $ 12,924 $ (12,050) $ 12,950 $ 66,800 $ 51,586 $ 3,000 $ 69,800 010-20.8950.010000 SALARIES 010-20.8950.060000 FICA CONTRIBUTION $ 5,700 $ 3,961 $ 190 $ 5,890 010-20.8950.070000 MEDICARE CONTRIBUTION $ 1,400 $ 926 $ 45 $ 1,445 010-20.8950.080000 IPERS CONTRIBUTION $ 9,200 $ 5,147 $ 270 $ 8,470 010-20.8950.100000 HEALTH &LIFE INSURANCE $ 7,800 $ 5,350 $ (1,000) $ (1,000) $ 6,800 010-20.8950.102000 SECTION 125 FLEX BENEFIT $ - $ 375 $ 5 $ 500 010-20.8950.150000 EMPLOYEE ASSISTANCE PROGRAM $ 25 $ - $ (25) $ (252S) $ - 010-20,8950.270100 COMPUTER SUPPORT $ 3,500 $ 42 $ (3,000) $ S00 010-20.8950.290000 GENERAL LIABILITY INSURANCE $ 600 $ 155 $ ("0) ANNUAL RENEWAL CHG $ (440) $ 160 010-20.8950.740000 Total Public Works Program OFFICE EQUIPMENT Proposed Amendment $ - $ 12,924 $ (17,760) 1 $ (20,220) $ $ $ 12,950 (164,07S) $ 12,950 010-30.3600.230800 MOSQUITO SPRAYING Current Proposed Health Life Other Pre -Approved Changes Admin/Fin Proposed G/L Acd# Description Budget YTD Actual LTD/WC Change Change Reason Recommend Bud et $ _ 010-40.3100.D10D00 SALARIES 010-40.3100.290000 GENERAL LIABILITY INSURANCE $ 1,200 $ 310 $ (890) $ 310 03040.3300.290100 BUILDING& CONTENTS INSURANCE $ 5,000 $ 3,344 $ (1,600) ANNUAL RENEWAL CHG $ (1,600) $ 3,400 010-40.3100.480000 Total Library UTILITY SERVICES Proposed Amendment $ 31,500 $ 22,187 $ $ - (4,300) $ (1,600) $ $ $ 490 (4,300) $ 27,200 01040.4100.100000 HEALTH & LIFE INSURANCE 01040.4100.110000 WORKERS COMPENSATION $ 4,700 $ 3,057 $ (1,640) $ (1,640) $ 3,060 010-40.4100.150000 EMPLOYEE ASSISTANCE PROGRAM $ 50 $ - $ (50) $ (50) $ - 010-40.4100.290000 GENERAL LIABILITY INSURANCE $ 2,000 $ 505 $ (1,490) ANNUAL RENEWAL CHG $ (1,490) $ 510 010-40.4100.290300 VEHICLE INSURANCE $ 1,000 $ 374 $ (625) ANNUAL RENEWAL CHG $ (625) $ 375 01040.4100.290300 BUILDING& CONTENTS INSURANCE $ 4,000 $ 836 $ (3,160) ANNUAL RENEWAL CHG $ (3,160) $ ME 010-40.4100.460101 PLANT SOME SHADE $ - $ 16,871 $ 16,870 $ 16,870 010-40.4100.790000 VEHICLE OR EQIPMENT PURCHASE $ 22,000 $ - $ 5,000 $ 27,000 010-40.4100,881110 BIKETRAILS $ - $ 69,648 $ 69,650 $ 69,650 $ - 01040.4200,010000 SALARIES 01040.4200.100000 HEALTH & LIFE INSURANCE $ 47,000 $ 33,215 $ (6,000) $ (6,000) $ 41,000 01040.4200.110000 WORKERS COMPENSATION $ 1,900 $ 1,300 $ (600) $ (600) $ 1,300 010-40,4200.150000 EMPLOYEE ASSISTANCE PROGRAM $ 75 $ - $ (75) $ (75) $ 010-40,4200.290000 GENERAL LIABILITY INSURANCE $ 2,200 $ 486 $ (1,710) ANNUAL RENEWAL CHG $ (1,710) $ 490 010-40.4200.290100 VEHICLE INSURANCE $ 600 $ 184 $ (410) ANNUAL RENEWAL CHG $ (410) $ 190 010-40.4200.691200 MECHANIC REIMBURSEMENT $ _ $ 11000 $ 155 $ (845) ANNUAL RENEWAL CHG $ (845) $ 155 010-40.4300.290000 GENERAL LIABILITY INSURANCE 010-40.4300.290300 BUILDING& CONTENTS INSURANCE $ 1,500 $ 264 $ (1,230) ANNUAL RENEWAL CHG $ (1,230) $ 270 010-40.4300.590000 Total Community OPERATING SUPPLIES & MATERIALS Center Proposed Amendment $ S; (2, $ _ $ - $ $ 030-50.6500.340000 MISCELLANEOUS CONTRACTUAL Total Median Maintenance Proposed Amendment $ 34,900 $ 24,625 $ (4,000) $ $ (4,000) $ 30,900 010-50-8500.100000 HEALTH & LIFE INSURANCE 010-50.8500.110000 WORKERS COMPENSATION $ 1,600 $ 1,339 $ (250) $ (250) $ 1,350 030-50.8500.150000 EMPLOYEE ASSISTANCE PROGRAM $ 50 $ - $ (50) $ (50) $ 010-50.8500.230000 CONSULTANT& PROFESSIONAL FEES $ 10,000 $ 34,18] $ 35,000 $ 45,000 010-50.8500.290000 GENERAL LIABILITY INSURANCE $ 750 $ 308 $ (440) ANNUAL RENEWAL CHG $ (440) $ 310 010-50.8500.580000 Total Community OFFICE SUPPLIES Development Proposed Amendment $ 238,500 $ 163,458 $ $ .r (18,500) $ 220,000 010-50.8700.010000 SALARIES 010-50.8700,010500 OVERTIME PAY $ 7,500 $ 2,883 $ (3,000) $ 4,500 010-50.8700.060000 FICA CONTRIBUTION $ 15,300 $ 10,111 $ (1,300) $ 14,000 010-50.8700.070000 MEDICARE CONTRIBUTION $ 3,600 $ 2,365 $ (320) $ 3,280 010-50.8700-080000 IPERS CONTRIBUTION $ 22,000 $ 15,041 $ (1,910) $ 20,090 010-SO.8700.100000 HEALTH & LIFE INSURANCE $ 47,000 $ 33,195 $ (5,600) $ (5,600) $ 41,400 010-50.8700.110000 WORKERS COMPENSATION $ 3,500 $ 2,950 $ (550) $ (550) $ 2,950 010-50.8700.150000 EMPLOYEE ASSISTANCE PROGRAM $ 75 $ - $ (75) $ (75) $ - 010-50.8700.270110 COPIER/PRINTER LEASE &MAINT $ - $ 11083 $ 1,S00 $ 1,500 010-50.8700,290000 GENERAL LIABILITY INSURANCE $ 600 $ 155 $ (440) ANNUAL RENEWAL CHG $ (400) $ 160 010-50.8700.580000 Total Planning Total Community & Economic OFFICE SUPPLIES Proposed Amendment Development Program Proposed Amendment rg =16mm".) $ (10,525) $ (880) $ $ _ 65 $ 8,500 $ 2,150 $ (6,350) ANNUAL RENEWALCHG 010-60.8100.290000 GENERAL LIABILITY INSURANCE 010-60.9100.470000 Total Mayor TRAINING/TRAVEL EXPENSE & Council Proposed Amendment $ 8,000 $ - $ $ (6,350) $ $ (6,350) (8,000) $ DID -60.8110.231600 ELECTION EXPENSE $ 81,500 $ 75,500 7 $ (6,000) 75500 010-60.8200.010000 SALARIES 1 010-60.8200.100000 HEALTH & LIFE INSURANCE $ 19,700 $ 13,929 $ (2,000) $ (2,000) 17700 010-60,8200.590000 Total Communications OPERATING SUPPLIES & MATERIALS Proposed Amendment $ rr Current pro osed Health/Life/ Other Pre -Approved Changes Admin/Fin Proposed G/L Ater at Description Bud at YTD Actual LTD/WC Change Change Reason Recommend Budget $ 228,000 $ 174,473 $ 7,500 $ 235,500 010-60.8300.010000 SALARIES 010-60.8300.010500 OVERTIME PAY $ - 3,500 $ 3,657 $ 1,400 $ 4,900 010-60.8300.060000 FICA CONTRIBUTION $ 15,300 $ 8,766 $ 560 $ 15,860 010-60.8300.070000 MEDICARE CONTRIBUTION $ 3,600 $ 2,709 $ 130 $ 3,730 010-60.8300.080000 IPERS CONTRIBUTION $ 22,000 $ 16,357 $ 800 $ 22,900 010-60.8300.100000 HEALTH & LIFE INSURANCE $ 37,400 $ 26,415 $ (4,900) $ (4,900) $ 32,500 010-60.8300.110000 WORKERS COMPENSATION $ 370 $ 282 $ (85) $ (85) $ 285 010-60.8300.150000 EMPLOYEE ASSISTANCE PROGRAM $ 50 $ - $ (50) $ (50) $ - 010-60.8300.230000 CONSULTANT & PROFESSIONAL FEES $ 35,000 $ 42,391 $ 27,000 $ 62,000 010-60.8300.290000 GENERAL LIABILITY INSURANCE $ 1,600 $ 155 $ (1,440) ANNUAL RENEWAL CHG $ (1,440) $ 160 010-60.8300.450000 TELEPHONE $ 5,000 $ 5,517 $ 2,500 $ 7,500 010-60.8300.720000 OFFICE FURNITURE $ - $ 15,000 $ 15,000 $ 15,000 010-60.8300.740050 COMPUTER/SERVER EQUIP& SOFTWR $ 12,500 $ 21,206 $ 12,500 $ 25,000 010-60.8300.850000 LAND PURCHASES $ $ - - $ $ 300,000 2,019 $ $ 485,000 2,700 $ $ 485,000 2,700 010-60.8310.270110 COPIER / PRINTER LEASE & MAINT 010-60.3310.290300 BUILDING& CONTENTS INSURANCE $ 11,000 $ 2,362 $ (8,630) ANNUAL RENEWAL CHG $ (8,630) $ 2,370 010-60.8310.390500 PROPERTY TAX EXPENSE $ 7,500 $ 4,510 $ (2,990) $ 4,510 010-60.9310.390600 PROF PLAZA CAM EXPENSES $ 14,500 $ 4,133 $ (7,750) $ 6,750 030-60.8310.470000 TELEPHONE $ 7,000 $ 5,460 $ Soo $ 7,500 010-60.8310.832000 City PROFESSIONAL PLAZA BUILDING Hall Proposed Amendment $Total _ $ 0,630 $ 010-60.8350.010000 SALARIES 010-60.8350.100000 HEALTH & LIFE INSURANCE $ 7,800 $ 5,3507$(25) $ (1,100) $ 6,700 010-60.8350,150000 EMPLOYEE ASSISTANCE PROGRAM $ 25 $ - $ (25) $ 010-60.8350.230000 CONSULTANT& PROFESSIONAL FEES $ 010-60.8350.270000 DATA PROCESSING $ 5,300 $ 8,440 $ 3,700 $ 9,000 010-60.8350.270100 COMPUTER SUPPORT $ 1,000 $ 102 $ (700) $ 300 010-60.8350.270110 COPIER/ PRINTER LEASE& MAINT $ 2,000 $ 2,267 $ 1,600 $ 3,600 010-60.8350.280000 DUES, MEMBERSHIPS & SUBSCRIPT $ 740 $ 940 $ 110 $ 850 010-60.8350.290000 GENERAL LIABILITY INSUANCE $ 600 $ 155 $ ("0) ANNUAL RENEWAL CHG $ IUD) $ 160 010-60.8350.350100 PRINTING $ - $ 235 $ 250 $ 250 010-60.8350.689000 EMPLOYEE APPRECIATION $ $ 030-60.8400.010000 SALARIES 010-60.8400.100000 HEALTH & LIFE INSURANCE $ 57,200 $ 31,705 $ (17,600) $ (17,600) $ 39,600 010-60.8400.102000 SECTION 125 FLEX BENEFIT $ WORKERS COMPENSATION $ 350 $ 215 $ (130) $ (130) $ 220 010-60,8400-150000 EMPLOYEE ASSISTANCE PROGRAM $ 75 $ - $ (75) $ (75) $010-60.8400.110000 010-60.9400.270000 DATA PROCESSING $ 2,500 $ 4,273 $ 1,800 $ 4,300 010-60.8400.290000 GENERAL LIABILITY INSURANCE $ 650 $ 155 $ (490) ANNUALRENEWAL CHG $ (490) $ 160 010-60.8400.350100 PRINTING $ 1,500 $ 2,625 $ 1,300 $ 2,800 010-60.8400.740101 COMPUTER SOFTWARE/EQUIPMENT = I $ 010-60.8600.230000 CONSULTANT & PROFESSIONAL FEES Total City Attorney Proposed Amendment t t $ - $ - 5 $ 15,800 $ 010-60.8800-010000 SALARIES 010-60.8800.060000 FICA CONTRIBUTION $ - $ $ 980 $ 15,800 010-60.8800.070000 MEDICARE CONTRIBUTION $ - $ $ 230 $ 980 010-60.8800.080000 IPERS CONTRIBUTION $ - $ $ 230 010-60.8800.100000 HEALTH & LIFE INSURANCE $ - $ - 1,410 $ 1,410 010-60.8800.100100 LONG TERM DISABILITY $ - $ - $ 3,050 $ 3,050 010-60.8800.102000 SECTION 125 FLEX BENEFIT $ - $ $ $ 20 85 $ $ 20 85 010-60.8800.110000 WORKERS COMPENSATION $ - $ $ 100 $ 100 010-60.3800.120000 UNIFORMS $ - $ - $ 100 $ 100 010-60.8800.190100 PERSONNEL SERVICES REIMBURSEMENT $ - $ - $ (8,710) $ (8,710) 030-60.8800.450000 TELEPHONE $ - $ - $ Soo $ 500 010-60.8800.540000 MINOR EQUIPMENT $ - $ - $ 5,000 010-60.8800.580000 OFFICESUPPLIES $ - $ $ 5,000 010-60-8800.690100 SUPPLIES/SERVICES REIMBURSEMENT $ - $ $ $ 500 (6,400) $ $ 500 (6,400) 010-60.8800,740300 Total Information FIBER NETWORK Technology Proposed Amendment $ - $ 5,2]2 $ 10000 ,665 $ 10,000 S $ $ 30,000 $ - $ .t (10,000) :$20 110 030-60.8400.970100 Transfer To Commerce Bank Reserve 59.000.6.97080 Transfer To GO Debt Service Other Funds - FY2017 Proposed Revenue Budget Amendment Current Proposed Amended G/L Acct# Description Fund Budget YTD Actual Inc/Dec Budget Ila�El- 510-30.6510.6010000 METERED SALES WATER FUND $ 3,320,890 $ 2,886,782 $ 429,110 $ 3,750,000 520-30.6520.6010000 METERED SALES SEWER FUND $ 3,321,400 $ 2,593,153 $ 136,600 $ 3,458,000 520-30.6520.6120000 CUSTOMER PENALTIES SEWER FUND $ 7,500 $ 7,928 $ 3,000 $ 10,500 520-30.6520.6140110 CONNECTION FEE -SUGAR CRK SEWER FUND $ - $ 14,853 $ 14,860 $ 14,860 520-30.6520.6140120 CONNECTION FEE-ALICES ROAD SEWER FUND $ - $ 43,857 $ 43,860 $ 43,860 520-30.6520.6140130 CONNECTION FEE -LITTLE WALNUT SEWER FUND $ - $ 327,013 $ 327,020 $ 327,020 520-30.6520.6140140 CONNECTION FEE -SOUTH AREA SEWER FUND $ - $ 31,693 $ 31,690 $ 31,690 520-30.6520.6140500 DEVELOPMENT CAPITAL FEES SEWERFUND $ 275,000 $ 699,527 $ 575,000 $ 850,000 590-30.5400.3431000 SOLID WASTE COLLECTION SOLID WASTE FUND $ 1,099,960 $ 876,745 $ 76,040 $ 1,176,000 .r 16 110-30.7800.3756000 PROCEEDS FROM GO BONDS DEBT SERVICE FUND $ - $ 1,720,000 $ 1,720,000 $ 1,720,000 810-50.8400.3988400 TRANFER IN-FINANCE/COMM BNK EQUIP REVOLVE FUND $ 30,000 $ 20,000 $ (10,000) $ 20,000 0 off 110-30.7800.930300 110-30.7800.914000 110-30.7800.914510 110-30.7800.914622 110-30.7800.924000 110-30.7800.924510 110-30.7800.924622 110-30.7850.918370 110-30.7850.928370 ECONOMIC DEVELOPMENT GRANT CONSULTANT & PROFESSIONAL FEES DEBT ISSUANCE COSTS GO 03/05 GOLF PRINCIPAL GO 08B SOUTHFORK SEWER PRINCIPAL GO 16B PRINCIPAL GO 03/05 GOLF INTEREST GO O8B SOUTHFORK SEWER INTEREST GO 16B INTEREST TIF 08C URBAN RENEW PRINCIPAL TIF 08C URBAN RENEW INTEREST YTD Actual USE TAX FUND 1 $ - $ FUND $ - $ 14,021 $ 14,030 $ 14,030 FUND $ - $ 8,094 1 $ 30,000 $ 30,000 SERVICE FUND $ - $ 32,823 $ 32,850 $ 32,850 $ 48,800 $ 29,701 $ 11,000 $ 59,800 $ 105,000 $ 565,000 $ 460,000 $ 565,000 $ - $ 280,000 $ 280,000 $ 280,000 $ 12,610 $ 3,389 $ (6,200) $ 6,410 $ 22,908 $ 7,000 $ (15,908) $ 7,000 $ - $ 12,465 $ 12,465 $ 12,465 $ 170,000 $ 1,155,000 $ 985,000 $ 1,155,000 $ 48,698 $ 14,880 $ (33,818) $ 14,880 CAPITAL PROJECTS 1 $ - $ - 1 $ - $ - 10-30.6510.592000 METER PURCHASE WATER FUNE 10-30.6510.650000 COST OF GOODS SOLD 10-30.6510.650010 DSMWW OPERATING & MAINTENANCE WATER FUND TOTAL 20-30.6520.930300 DEBT ISSUANCE SEWER FUND 20-30.6520.883091 NW AREA TRUNK SEWER EXT SEWERFUND 20-30.6520.921110 16C INTEREST SEWER FUND SEWER FUND TOTAL GASFUND GAS FUND TOTAL $ 165,000 $ 336,653 $ 250,000 $ 415,000 $ 749,750 $ 584,194 $ 130,250 $ 880,000 $ 65,000 $ 63,133 $ 20,000 $ 85,000 (STORM WATER FUND $ STORM WATER FUND TOTAL , UTILITY BILLING FUND $ UTILITY BILLING FUND TOTAL , RESIDENTIAL SOLID WASTE COLLECTION SOLID WASTE FUND $ SOLID WAST FUND TOTAL , GOLF COURSE FUND $ GOLF COURSE FUND TOTAL $ 60,000 $ 60,000 $ 60,000 $ 1,000,000 $ 1,000,000 $ 1,000,000 - $ - $ 36,250 $ 36,250 $ 0 $ 1,010,000 $ - $ - 1 $ - $