Loading...
HomeMy WebLinkAbout2020-05-18-G03 FY2020 Budget Amendment_PHG3 240 Jun-19 NOTICE OF PUBLIC HEARING Form 653.C1 AMENDMENT OF FY2019-2020 CITY BUDGET The City Council of Waukee in DALLAS County, Iowa will meet at at 5:30 pm on 05/18/2020 (hour)(Date) ,for the purpose of amending the current budget of the city for the fiscal year ending June 30, 2020 (year) by changing estimates of revenue and expenditure 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 Total Budget as certified Current after Current or last amended Amendment Amendment Revenues & Other Financing Sources Taxes Levied on Property 1 15,115,776 15,115,776 Less: Uncollected Property Taxes-Levy Year 2 0 0 Net Current Property Taxes 3 15,115,776 0 15,115,776 Delinquent Property Taxes 4 0 0 TIF Revenues 5 5,263,083 5,263,083 Other City Taxes 6 2,456,905 5,500 2,462,405 Licenses & Permits 7 1,528,130 185,150 1,713,280 Use of Money and Property 8 525,180 237,500 762,680 Intergovernmental 9 3,941,633 2,867 3,944,500 Charges for Services 10 21,574,860 2,843,000 24,417,860 Special Assessments 11 12,750 12,750 Miscellaneous 12 1,334,000 105,050 1,439,050 Other Financing Sources 13 18,395,000 172,800 18,567,800 Transfers In 14 13,221,320 630,383 13,851,703 Total Revenues and Other Sources 15 83,368,637 4,182,250 87,550,887 Expenditures & Other Financing Uses Public Safety 16 7,795,845 -5,860 7,789,985 Public Works 17 2,967,540 131,400 3,098,940 Health and Social Services 18 2,000 2,000 Culture and Recreation 19 2,612,454 -76,535 2,535,919 Community and Economic Development 20 831,960 73,510 905,470 General Government 21 1,900,016 675,460 2,575,476 Debt Service 22 8,633,160 699,895 9,333,055 Capital Projects 23 26,670,000 26,670,000 Total Government Activities Expenditures 24 51,412,975 1,497,870 52,910,845 Business Type / Enterprises 25 22,154,756 1,433,388 23,588,144 Total Gov Activities & Business Expenditures 26 73,567,731 2,931,258 76,498,989 Transfers Out 27 13,221,320 630,383 13,851,703 Total Expenditures/Transfers Out 28 86,789,051 3,561,641 90,350,692 Excess Revenues & Other Sources Over (Under) Expenditures/Transfers Out Fiscal Year 29 -3,420,414 620,609 -2,799,805 Beginning Fund Balance July 1 30 65,955,806 65,955,806 Ending Fund Balance June 30 31 62,535,392 620,609 63,156,001 Explanation of increases or decreases in revenue estimates, appropriations, or available cash: 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. City Clerk/ Finance Officer Name conducted via Zoom - see meeting link information below Linda Burkhart, Finance Director PH shall be conducted via Zoom at: https://zoom.us/j/352651371 - Meeting ID #352-51-371 or by phone: 1- 646-558-8656 or 1-312-626-6799 or 1-301-715-8592 Revenues - Increased building permits, interest earnings, utility user fees, sale of assets and transfers in. Expenditures - decrease in health insurance, increases for property purchased, water & gas COGS, transfers out. Proposed Revenue Expenditures Reserve General Fund Inc/(Dec)Inc/(Dec)Inc/(Dec) General Fund Non-Department 2,765$ -$ 2,765$ Public Safety Program Police Dept 10,150$ (2,900)$ 13,050$ Warning Sirens -$ -$ -$ Westcom Dispatch -$ 10,000$ (10,000)$ Fire 33,100$ 28,090$ 5,010$ EMS 128,550$ (1,300)$ 129,850$ Code Compliance 178,500$ 14,750$ 163,750$ Animal Control (15,000)$ (54,500)$ 39,500$ 335,300$ (5,860)$ 341,160$ Public Works Program Public Works -$ (2,800)$ 2,800$ Public Works Building -$ 10,200$ (10,200)$ Public Works Mechanic (12,550)$ (12,550)$ -$ Engineering 8,000$ 150,550$ (142,550)$ GIS -$ (14,000)$ 14,000$ (4,550)$ 131,400$ (135,950)$ Health & Social Services Program Mosquito Control -$ -$ -$ -$ -$ -$ Culture & Recreation Program Library 7,250$ (13,450)$ 20,700$ Parks 10,300$ (28,750)$ 39,050$ Recreation -$ (34,335)$ 34,335$ Community Center -$ -$ -$ 17,550$ (76,535)$ 94,085$ Community & Economic Development Program Median Maintenance -$ 12,500$ (12,500)$ Community Development -$ (19,840)$ 19,840$ Development Services -$ (14,150)$ 14,150$ -$ (21,490)$ 21,490$ General Government Mayor & Council -$ (18,250)$ 18,250$ Elections -$ (4,800)$ 4,800$ Communications -$ (6,000)$ 6,000$ Administration -$ 659,850$ (659,850)$ City Hall -$ 172,710$ (172,710)$ Human Resources 15,000$ 14,700$ 300$ Finance -$ (65,350)$ 65,350$ City Attorney -$ (85,000)$ 85,000$ Information Technology -$ 7,600$ (7,600)$ 15,000$ 675,460$ (660,460)$ Other Financing Sources/Uses Transfers In/Out 170,227$ -$ 170,227$ Sale Property 172,800$ -$ 172,800$ 343,027$ -$ 343,027$ General Fund Totals 709,092$ 702,975$ 6,117$ FY2020 - Budget Amendment Summary FY2020 - Budget Amendment Summary Proposed Revenue Expenditures Reserve Other Funds Inc/(Dec)Inc/(Dec)Inc/(Dec) Road Use Fund 33,750$ -$ 33,750$ TIF Funds 20,500$ 785,383$ (764,883)$ Debt Service & Special Assessment Funds 451,378$ 699,895$ (248,517)$ Employee Benefits Fund (5,620)$ (5,620)$ Local Option Sales Tax Fund 36,500$ 36,500$ Project Improvement Fund 12,000$ 12,000$ Capital Projects Funds -$ -$ Water Fund 974,100$ 778,025$ 196,075$ Sewer Fund 1,239,000$ 652,613$ 586,387$ Gas Fund 593,400$ 104,100$ 489,300$ Storm Water Fund 84,450$ (141,350)$ 225,800$ Utility Billing Fund 7,200$ (5,000)$ 12,200$ Solid Waste Fund 26,500$ 45,000$ (18,500)$ Golf Course Fund -$ -$ -$ Equipment Reserve Fund -$ (60,000)$ 60,000$ Other Fund Totals 3,473,158$ 2,858,666$ 614,492$ FY20 Grand Totals 4,182,250$ 3,561,641$ 620,609$ Current G/L Acct #Description Budget Change Budget Property Taxes -$ Other City Taxes 010-00.0000.3011000 HOTEL/MOTEL TAXES -$ 5,500$ 5,500$ 5,500$ Licenses, Permits & Fees 010-00.0000.3210200 LIQUOR LICENSES 14,100$ 2,900$ 17,000$ 010-00.0000.3240100 CABLE TELEVISION FRANCHISE 68,000$ 4,000$ 72,000$ 010-10.1900.4300000 BUILDING PERMITS 900,000$ 150,000$ 1,050,000$ 010-10.1900.4310000 ZONING FEES -$ 010-10.1900.4310100 SUBDIVISION PLATING FEES 8,000$ 4,000$ 12,000$ 010-10.1900.4320100 SITE PLAN REVIEW FEES 10,000$ 4,000$ 14,000$ 010-10.1900.4320300 RIGHT OF WAY PERMITS 2,000$ 15,500$ 17,500$ 010-10.1900.4320400 SUBDIVISION PLAT FEES-WARNING SIRENS 5,000$ 5,000$ 10,000$ 010-10.2400.4031000 DOG LICENSES 31,000$ (15,000)$ 16,000$ 010-40.4100.4520100 DOG PARK LICENSE 13,000$ 4,500$ 17,500$ 010-20.8900.4320000 ENGINEER REVIEW REIMBURSEMENT 75,000$ 115,000$ 190,000$ 010-20.8900.4320600 CONSTRUCTION INSPECTION FEES 350,000$ (110,000)$ 240,000$ 010-20.8900.4320700 ENGINEER ADMINISTRATION FEES 5,000$ 3,000$ 8,000$ 182,900$ Use of Money & Property 010-00.0000.3610000 INTEREST ON DEPOSITS -$ 010-40.4100.4530000 PARK SHELTER RENT -$ 010-40.4100.4530200 BALL FIELD RENT -$ 010-40.4300.4531000 COMMUNITY CENTER RENT -$ -$ Intergovernmental 010-00.0000.3010100 COMMERCIAL & INDUSTRIAL BACKFILL 169,885$ (21,635)$ 148,250$ 010-10.1100.4020100 LAW ENFORCEMENT GRANTS 55,000$ 20,000$ 75,000$ 010-10.1100.4020210 OFFICER CONTRACT BUY OUT -$ 6,850$ 6,850$ 010-10.1100.4020300 RESOURCE OFFICER REIMBURSEMENT 152,000$ (4,300)$ 147,700$ 010-10.1400.4110000 TOWNSHIP FIRE TAX 30,000$ 10,600$ 40,600$ 010-40.3100.4410000 LIBRARY OPEN ACCESS 20,000$ 7,250$ 27,250$ 010-40.3100.4430000 COUNTY LIBRARY SERVICES -$ 010-40.4100.4400100 IOWA DEPT NAT RESOURCES GRANT -$ 18,765$ Charges For Services 010-10.1100.4030201 POLICE OFFICER LABOR REIMBURSEMENT -$ 16,000$ 16,000$ 010-10.1400.4010200 FIRE REPORTS 600$ 2,900$ 3,500$ 010-10.1500.3529900 AMBULANCE TRANSPORTS 330,000$ 125,000$ 455,000$ 010-10.1900.3988300 ADMIN/RECORDING FEES -$ 010-40.4100.6010010 PLANT SOME SHADE -$ 010-40.4200.4516400 CITIZEN TRIPS/OUTINGS -$ 010-40.4200.4517000 WINTER PROGRAMS -$ 010-20.6150.6200600 MECHANIC FEES - ROADS 55,000$ (8,000)$ 47,000$ 010-20.6150.6201100 MECHANIC FEES - POLICE 3,000$ (1,400)$ 1,600$ 010-20.6150.6201900 MECHANIC FEES - BLDG INSPECT 450$ 350$ 800$ 010-20.6150.6204100 MECHANIC FEES - PARKS 16,000$ (11,500)$ 4,500$ 010-20.6150.6204200 MECHANIC FEES - RECREATION -$ 010-20.6150.6205100 MECHANIC FEES - WATER 30,000$ 1,000$ 31,000$ 010-20.6150.6205200 MECHANIC FEES - SEWER -$ 010-20.6150.6205400 MECHANIC FEES - GAS -$ 010-20.6150.6205600 MECHANIC FEES - STORM WATER 5,000$ 3,000$ 8,000$ 010-20.6150.6206000 MECHANIC FEES - PUBLIC WORKS 3,000$ 5,500$ 8,500$ 010-20.6150.6208950 MECHANIC FEES - GIS 1,500$ (1,500)$ -$ 131,350$ Miscellaneous 010-00.0000.3770000 MISCELLANEOUS 2,500$ 7,500$ 10,000$ 010-00.0000.3775000 DAMAGE REIMBURSEMENT -$ 2,500$ 2,500$ 010-00.0000.6120000 LATE FEE PENALTIES 3,000$ 2,000$ 5,000$ 010-10.1100.4010000 COURT FINES 50,000$ (35,000)$ 15,000$ 010-10.1100.4010100 CIVIL PENALTY -$ Proposed General Fund - FY2020 Proposed Revenue Budget Amendment Total Licenses, Permits & Fees Total Use of Money & Property Total Intergovernmental Total Charges For Services Total Property Taxes Total Other City Taxes Current G/L Acct #Description Budget Change Budget Proposed 010-10.1100.4030000 POLICE DONATIONS -$ 6,600$ 6,600$ 010-10.1400.3760300 SALE OF EQUIPMENT (FIRE)1,250$ 3,750$ 5,000$ 010-10.1400.4120000 FIRE / EMS DONATIONS -$ 15,850$ 15,850$ 010-10.1500.3760300 SALE OF EQUIPMENT (EMS)1,250$ 3,550$ 4,800$ 010-40.4100.3760300 SALE OF EQUIPMENT (PARKS)1,200$ 5,800$ 7,000$ LIBRARY FINES & BOOK CHARGES -$ LIBRARY DONATIONS -$ 010-40.4200.3761200 CORPORATE SPONSORSHIP -$ 010-60.8350.3770010 WELLNESS REIMBURSEMENTS 2,400$ 15,000$ 17,400$ 27,550$ Other Financing Sources 010-00.0000.3755000 SALE OF PROPERTY -$ 172,800$ 172,800$ 010-00.0000.3980300 TRANSFER FROM TIF (LMI)-$ 230,227$ 230,227$ 010-00.0000.3980600 TRANSFER FROM CAP PROJECTS 327 -$ -$ 010-00.0000.3987000 TRANSFER FROM VEH/EQUIPM RESERVE 010-60.8400.3989010 TRANSFER FROM COMMERCE BANK RESERVE 60,000$ (60,000)$ -$ 343,027$ 709,092$ 702,975$ 6,117$ Total Proposed FY20 Excess to General Fund Reserves Total Proposed FY20 General Fund Revenue Increase Total Proposed FY20 General Fund Expenditure Increase Total Miscellaneous Total Other Financing Sources Current Proposed G/L Acct #Description Budget Recommend Budget Police 010-10.1100.100000 HEALTH & LIFE INSURANCE 514,500$ (39,500)$ 475,000$ 010-10.1100.110000 WORKERS COMPENSATION 24,500$ (6,000)$ 18,500$ 010-10.1100.120000 UNIFORMS 31,500$ 6,000$ 37,500$ 010-10.1100.210000 PUBLIC NOTIFICATION/ADVERTISING 1,000$ 2,000$ 3,000$ 010-10.1100.230000 CONSULTANT & PROFESSIONAL FEES 6,200$ 2,800$ 9,000$ 010-10.1100.270000 DATA PROCESSING 6,000$ 7,000$ 13,000$ 010-10.1100.270110 COPIER / PRINTER LEASE & MAINT -$ 13,500$ 13,500$ 010-10.1100.280000 DUES, MEMBERSHIPS & SUBSCRIPT 3,500$ 1,300$ 4,800$ 010-10.1100.390000 RENTAL/LEASE OF EQUIPMENT 3,500$ (3,500)$ -$ 010-10.1100.400000 REPAIR/MAINTENANCE OF BUILDING 19,000$ 8,000$ 27,000$ 010-10.1100.400100 CUSTODIAL 5,100$ 5,900$ 11,000$ 010-10.1100.410000 REPAIR OF VEHICLES 12,000$ 13,000$ 25,000$ 010-10.1100.410050 REPAIR/MAINT - WAUKEE MECHANIC 3,000$ (1,400)$ 1,600$ 010-10.1100.410200 REPAIR/MAINT OF ELECTRONICS 7,000$ (4,000)$ 3,000$ 010-10.1100.450000 TELEPHONE 20,000$ (5,000)$ 15,000$ 010-10.1100.470000 TRAINING/TRAVEL EXPENSE 50,750$ (5,750)$ 45,000$ 010-10.1100.48000 UTILITY SERVICES 13,750$ 3,250$ 17,000$ 010-10.1100.560000 MOTOR VEHICLE MAINT SUPPLIES 10,000$ (10,000)$ -$ 010-10.1100.570000 FUEL 45,000$ (6,000)$ 39,000$ 010-10.1100.580000 OFFICE SUPPLIES 6,500$ (2,500)$ 4,000$ 010-10.1100.590000 OPERATING SUPPLIES & MATERIALS 3,000$ 8,500$ 11,500$ 010-10.1100.710000 AUTOMOTIVE EQUIPMENT 129,000$ 3,000$ 132,000$ 010-10.1100.760000 OTHER CAPITAL EQUIPMENT -$ 6,500$ 6,500$ (2,900)$ Warning Sirens 010-10.1110.290300 Building & Contents Insurance -$ -$ Westcom Dispatch 010-10.1300.230010 WESTCOM DISPATCH SERVICES 580,000$ 10,000$ 590,000$ 010-10.1300.740000 OFFICE EQUIPMENT -$ 10,000$ Fire 010-10.1400.100000 HEALTH & LIFE INSURANCE 133,000$ (23,000)$ 110,000$ 010-10.1400.110000 WORKERS COMPENSATION 101,500$ 5,500$ 107,000$ 010-10.1400.230000 CONSULTANT & PROFESSIONAL -$ 4,000$ 4,000$ 010-10.1400.270000 DATA PROCESSING 1,800$ 300$ 2,100$ 010-10.1400.270100 COMPUTER SUPPORT 1,000$ (700)$ 300$ 010-10.1400.280000 DUES MEMBERSHIPS SUBSCRIPTIONS 1,360$ (660)$ 700$ 010-10.1400.270110 COPIER / PRINTER LEASE & MAINT -$ 1,650$ 1,650$ 010-10.1400.410000 REPAIR OF VEHICLES 16,000$ 14,000$ 30,000$ 010-10.1400.460100 SERVICE TO CHILDREN 1,500$ 14,500$ 16,000$ 010-10.1400.480000 UTILITY SERVICES 9,000$ 2,500$ 11,500$ 010-10.1400.570000 FUEL 10,000$ (2,500)$ 7,500$ 010-10.1400.710000 AUTOMOTIVE EQUIPMENT 29,000$ 12,500$ 41,500$ 28,090$ EMS 010-10.1500.100000 HEALTH & LIFE INSURANCE 133,000$ (13,000)$ 120,000$ 010-10.1500.110000 WORKERS COMPENSATION 101,500$ (40,000)$ 61,500$ 010-10.1500.120000 UNIFORMS 2,700$ 3,700$ 6,400$ 010-10.1500.230000 CONSULTANT & PROFESSIONAL FEES -$ 3,950$ 3,950$ 010-10.1500.231800 AMBULANCE BILLING FEES 15,500$ 34,500$ 50,000$ 010-10.1500.290000 GENERAL LIABILITY INSURANCE 1,400$ 850$ 2,250$ 010-10.1500.290100 VEHICLE INSURANCE 4,000$ (500)$ 3,500$ 010-10.1500.290300 BUILDING & CONTENTS INSURANCE 3,000$ (400)$ 2,600$ 010-10.1500.480000 UTILITY SERVICES 9,400$ 1,600$ 11,000$ 010-10.1500.540000 MINOR EQUIPMENT 5,000$ 8,000$ 13,000$ 010-10.1500.570000 FUEL -$ (1,300)$ Code 010-10.1900.010000 SALARIES 331,000$ 9,000$ 340,000$ 010-10.1900.010500 OVERTIME PAY 14,000$ (7,000)$ 7,000$ 010-10.1900.011000 PART TIME -$ 8,000$ 8,000$ 010-10.1900.060000 FICA CONTRIBUTION 21,500$ 650$ 22,150$ Total EMS Dept Proposed Amendment General Fund - FY2020 Proposed Expenditure Budget Amendment Total Police Dept Proposed Amendment Total Warning Sirens Dept Proposed Amendment Total Westcom Dispatch Dept Proposed Amendment Total Fire Dept Proposed Amendment Current Proposed G/L Acct #Description Budget Recommend Budget 010-10.1900.080000 IPERS CONTRIBUTION 33,000$ 500$ 33,500$ 010-10.1900.100000 HEALTH & LIFE INSURANCE 93,000$ (3,000)$ 90,000$ 010-10.1900.110000 WORKERS COMPENSATION 3,000$ (1,500)$ 1,500$ 010-10.1900.270000 DATA PROCESSING 3,000$ 7,000$ 10,000$ 010-10.1900.270110 COPIER / PRINTER LEASE & MAINT -$ 1,600$ 1,600$ 010-10.1900.280000 DUES MEMBERSHIPS & SUBSCRIPTIONS 500$ 300$ 800$ 010-10.1900.410000 REPAIR OF VEHICLES 500$ 2,200$ 2,700$ 010-10.1900.570000 FUEL 5,000$ (2,500)$ 2,500$ 010-10.1900.590000 OPERATING SUPPLIES & MATERIALS 1,000$ (500)$ 500$ 14,750$ Animal Control 10.2400.340000 Miscellaneous Contractual 70,500$ (54,500)$ 16,000$ (54,500)$ (5,860)$ Public Works 010-20.6000.100000 HEALTH & LIFE INSURANCE 75,000$ (4,000)$ 71,000$ 010-20.6000.110000 WORKERS COMPENSATION 3,500$ (2,000)$ 1,500$ 010-20.6000.710000 AUTOMOTIVE EQUIPMENT 38,000$ 3,200$ 41,200$ (2,800)$ Public Works Building 010-20.6010.230000 CONSULTANT & PROFESSIONAL FEES -$ 3,100$ 3,100$ 010-20.6010.270110 COPIER / PRINTER LEASE & MAINT -$ 8,500$ 8,500$ 010-20.6010.290300 BUILDING & CONTENTS INSURANCE 21,000$ (4,000)$ 17,000$ 010-20.6010.340000 MISCELLANEOUS CONTRACTUAL 5,000$ (5,000)$ -$ 010-20.6010.400000 REPAIR/MAINTENANCE BUILDING 80,000$ (20,000)$ 60,000$ 010-20.6010.400100 CUSTODIAL SERVICES 17,000$ 1,100$ 18,100$ 010-20.6010.410100 REPAIR/MAINTENANCE EQUIPMENT 3,000$ 1,000$ 4,000$ 010-20.6010.510100 GARBAGE PICK UP 1,300$ 2,500$ 3,800$ 010-20.6010.540000 MINOR EQUIPMENT -$ 2,500$ 2,500$ 010-20.6010.740000 OFFICE EQUIPMENT -$ 20,500$ 20,500$ 10,200$ Public Works Mechanic 010-20.6150.010000 SALARIES 138,000$ (20,000)$ 118,000$ 010-20.6150.010500 OVERTIME PAY 5,000$ 4,000$ 9,000$ 010-20.6150.060000 FICA CONTRIBUTION 9,000$ (1,000)$ 8,000$ 010-20.6150.070000 MEDICARE CONTRIBUTION 2,500$ (500)$ 2,000$ 010-20.6150.080000 IPERS CONTRIBUTION 13,500$ (1,500)$ 12,000$ 010-20.6150.100000 HEALTH & LIFE INSURANCE 40,000$ (2,000)$ 38,000$ 010-20.6150.110000 WORKERS COMPENSATION 1,500$ (400)$ 1,100$ 010-20.6150.450000 TELEPHONE 750$ 750$ 1,500$ 010-20.6150.470000 TRAINING/TRAVEL EXPENSES 5,000$ (3,500)$ 1,500$ 010-20.6150.570000 FUEL 3,000$ (1,500)$ 1,500$ 010-20.6150.570130 COGS - PARTS 80,000$ 41,000$ 121,000$ 010-20.6150.690100 REIMBURSEMENT - PARKS (17,414)$ (2,790)$ (20,204)$ 010-20.6150.690500 REIMBURSEMENT - ROADS (43,538)$ (6,975)$ (50,513)$ 010-20.6150.690600 REIMBURSEMENT - WATER (34,830)$ (5,580)$ (40,410)$ 010-20.6150.690700 REIMBURSEMENT - SEWER (34,830)$ (5,580)$ (40,410)$ 010-20.6150.690800 REIMBURSEMENT - GAS (34,830)$ (5,580)$ (40,410)$ 010-20.6150.690900 REIMBURSEMENT - STORM WATER (8,708)$ (1,395)$ (10,103)$ (12,550)$ Engineering 010-20.8900.0100000 SALARIES 315,000$ 10,000$ 325,000$ 010-20.8900.010500 OVERTIME PAY 60,000$ (20,000)$ 40,000$ 010-20.8900.060000 FICA CONTRIBUTION 24,000$ (500)$ 23,500$ 010-20.8900.080000 IPERS CONTRIBUTION 36,500$ (1,000)$ 35,500$ 010-20.8900.110000 WORKERS COMPENSATION 3,500$ (1,900)$ 1,600$ 010-20.8900.140000 UNEMPLOYMENT TAXES -$ 7,000$ 7,000$ 010-20.8900.230000 CONSULTANT & PROFESSIONAL FEES 3,000$ 22,000$ 25,000$ 010-20.8900.231200 DEVELOPERS ENGINEERING REVIEW 75,000$ 135,000$ 210,000$ 010-20.8900.270110 COPIER / PRINTER LEASE & MAINT -$ 1,650$ 1,650$ 010-20.8900.450000 TELEPHONE 4,500$ 800$ 5,300$ 010-20.8900.570000 FUEL 10,000$ (2,500)$ 7,500$ 150,550$ Total Public Safety Program Proposed Amendment Total Public Works Proposed Amendment Total Code Dept Proposed Amendment Total Animal Control Proposed Amendment Total Public Works Mechanic Proposed Amendment Total Enginerring Proposed Amendment Total Public Works Building Proposed Amendment Current Proposed G/L Acct #Description Budget Recommend Budget GIS 010-20.8950.010000 SALARIES 86,000$ (14,000)$ 72,000$ 010-20.8950.230000 CONSULTANT & PROFESSIONAL FEES -$ 800$ 800$ 010-20.8950.270000 DATA PROCESSING 800$ 1,200$ 2,000$ 010-20.8950.270100 COMPUTER SUPPORT 500$ (500)$ -$ 010-20.8950.470000 TRAINING/TRAVEL EXPENSE 2,600$ (1,500)$ 1,100$ (14,000)$ 131,400$ Mosquito Control 010-30.3600.230800 MOSQUITO SPRAYING -$ -$ Total Health & Social Services Program Proposed Amendment -$ Library 010-40.3100.010000 SALARIES 460,000$ (30,000)$ 430,000$ 010-40.3100.010500 OVERTIME PAY 2,500$ 1,500$ 4,000$ 010-40.3100.060000 FICA CONTRIBUTION 38,000$ (1,500)$ 36,500$ 010-40.3100.070000 MEDICARE CONTRIBUTION 9,500$ (500)$ 9,000$ 010-40.3100.080000 IPERS CONTRIBUTION 58,000$ (2,500)$ 55,500$ 010-40.3100.100000 HEALTH & LIFE INSURANCE 141,000$ (36,000)$ 105,000$ 010-40.3100.120000 UNIFORMS 500$ 300$ 800$ 010-40.3100.270000 DATA PROCESSING 15,000$ 2,500$ 17,500$ 010-40.3100.270100 COMPUTER SUPPORT 500$ (500)$ -$ 010-40.3100.270110 COPIER / PRINTER LEASE & MAINT -$ 3,250$ 3,250$ 010-40.3100.290000 GENERAL LIABILITY INSURANCE 1,200$ (500)$ 700$ 010-40.3100.290300 BUILDING & CONTENTS INSURANCE 12,000$ (1,400)$ 10,600$ 010-40.3100.360000 POSTAGE & SHIPPING 1,500$ 900$ 2,400$ 010-40.3100.400100 CUSTODIAL SERVICES 14,000$ (4,000)$ 10,000$ 010-40.3100.480000 UTILITY SERVICES 40,000$ (5,000)$ 35,000$ 010-40.3100.540000 MINOR EQUIPMENT 8,000$ 4,000$ 12,000$ 010-40.3100.580000 OFFICE SUPPLIES 9,000$ (4,000)$ 5,000$ 010-40.3100.880000 FACILITIES 25,000$ 60,000$ 85,000$ (13,450)$ Parks 010-40.4100.110000 WORKERS COMPENSATION 3,500$ (1,300)$ 2,200$ 010-40.4100.270100 COMPUTER SUPPORT 1,500$ 900$ 2,400$ 010-40.4100.280000 DUES MEMBERSHIPS & SUBSCRIPTIONS 1,000$ 500$ 1,500$ 010-40.4100.290000 GENERAL LIABILITY INSURANCE 2,500$ 200$ 2,700$ 010-40.4100.290100 VEHICLE INSURANCE 2,000$ (900)$ 1,100$ 010-40.4100.290300 BUILDING & CONTENTS INSURANCE 4,000$ 3,000$ 7,000$ 010-40.4100.410050 REPAIR/MAINT - WAUKEE MECH 13,000$ (8,500)$ 4,500$ 010-40.4100.410300 REPAIR/MAINTENANCE FACILITIES 35,000$ (10,000)$ 25,000$ 010-40.4100.410310 REPAIR/MAINTENANCE-DOG PARK 4,000$ 2,000$ 6,000$ 010-40.4100.450000 TELEPHONE 1,000$ 1,500$ 2,500$ 010-40.4100.460000 COMMUNITY SERVICES 15,000$ (15,000)$ -$ 010-40.4100.461300 CHRISTMAS DECORATIONS 7,500$ 850$ 8,350$ 010-40.4100.470000 TRAINING/TRAVEL EXPENSE 3,000$ 3,000$ 6,000$ 010-40.4100.480050 UTILITIES-TRAILS 12,000$ (12,000)$ -$ 010-40.4100.540000 MINOR EQUIPMENT 8,000$ 8,500$ 16,500$ 010-40.4100.570000 FUEL 15,000$ (2,500)$ 12,500$ 010-40.4100.760000 OTHER CAPITAL EQUIPMENT 32,000$ 1,000$ 33,000$ (28,750)$ Recreation 010-40.4200.010000 SALARIES 343,000$ (13,000)$ 330,000$ 010-40.4200.080000 FICA CONTRIBUTION 25,000$ (750)$ 24,250$ 010-40.4200.070000 MEDICARE CONTRIBUTION 6,000$ (200)$ 5,800$ 010-40.4200.080000 IPERS CONTRIBUTION 38,500$ (1,250)$ 37,250$ 010-40.4200.100000 HEALTH & LIFE INSURANCE 76,500$ (18,500)$ 58,000$ 010-40.4200.110000 WORKERS COMPENSATION 5,500$ (4,500)$ 1,000$ 010-40.4200.270100 COMPUTER SUPPORT 3,500$ (1,300)$ 2,200$ 010-40.4200.270110 COPIER / PRINTER LEASE & MAINT -$ 1,650$ 1,650$ 010-40.4200.290000 GENERAL LIABILITY INSURANCE 2,200$ 260$ 2,460$ 010-40.4200.290100 VEHICLE INSURANCE 600$ (245)$ 355$ 010-40.4200.450000 TELEPHONE 2,000$ 1,000$ 3,000$ 010-40.4200.450200 CREDIT CARD FEES 3,500$ 2,500$ 6,000$ (34,335)$ Total Public Works Program Proposed Amendment Total Recreation Proposed Amendment Total Library Proposed Amendment Total Parks Proposed Amendment Total GIS Proposed Amendment Total Mosquito Control Proposed Amendment Current Proposed G/L Acct #Description Budget Recommend Budget Community Center 010-40.4300.290000 GENERAL LIABILITY INSURANCE -$ (76,535)$ Median Maintenance 010-50.6500.480050 UTILITIES - TRAILS 15,500$ 12,500$ 28,000$ 12,500$ Community Development 010-50.8500.080000 IPERS CONTRIBUTION 12,000$ (3,900)$ 8,100$ 010-50.8500.090000 CITY SHARE ICMA 5,040$ (1,440)$ 3,600$ 010-50.8500.100000 HEALTH & LIFE INSURANCE 20,000$ (1,000)$ 19,000$ 010-50.8500.470000 TRAINING/TRAVEL EXPENSE 13,500$ (11,000)$ 2,500$ 010-50.8500.470100 ENTERTAINMENT & MEALS 2,500$ (2,500)$ -$ (19,840)$ Development Services 010-50.8700.010500 OVERTIME PAY 7,500$ (4,500)$ 3,000$ 010-50.8700.100000 HEALTH & LIFE INSURANCE 64,000$ (3,000)$ 61,000$ 010-50.8700.110000 WORKERS COMPENSATION 2,500$ 500$ 3,000$ 010-50.8700.230000 CONSULTANT & PROFESSIONAL FEES 40,000$ (10,000)$ 30,000$ 010-50.8700.270110 COPIER / PRINTER LEASE & MAINT -$ 1,650$ 1,650$ 010-50.8700.280000 DUES MEMEBERSHIPS & SUBSCRIPT 1,500$ 200$ 1,700$ 010-50.8700.470000 TRAINING/TRAVEL EXPENSES 8,000$ 1,000$ 9,000$ (14,150)$ Total Community & Economic Development Program Proposed Amendment (21,490)$ Mayor & Council 010-60.8100.290000 GENERAL LIABILITY INSURANCE 9,000$ 400$ 9,400$ 010-60.8100.290500 PROFESSIONAL INSURANCE 650$ (650)$ -$ 010-60.8100.470000 TRAINING/TRAVEL EXPENSE 21,000$ (17,000)$ 4,000$ 010-60.8100.580100 PROCLAMATION/RECOGNITION 1,500$ (1,000)$ 500$ (18,250)$ Elections 010-60.8110.231600 ELECTION EXPENSE 10,000$ (4,800)$ 5,200$ (4,800)$ Communications 010-60.8200.010000 SALARIES 140,000$ 5,000$ 145,000$ 010-60.8200.100000 HEALTH & LIFE INSURANCE 31,000$ (2,000)$ 29,000$ 010-60.8200.230000 CONSULTANT & PROFESSIONAL FEES 5,000$ (3,000)$ 2,000$ 010-60.8200.350100 PRINTING SERVICES 6,000$ (1,000)$ 5,000$ 010-60.8200.350110 PHOTOGRAPHY & VIDEO SERVICES 2,000$ (500)$ 1,500$ 010-60.8200.460000 SPECIAL PROGRAMS/EVENT SERVICES 5,000$ (1,000)$ 4,000$ 010-60.8200.461200 NEWSLETTER/PUBLICATIONS 25,500$ (5,000)$ 20,500$ 010-60.8200.540000 MINOR EQUIPMENT 3,000$ 1,500$ 4,500$ (6,000)$ Administration 010-60.8300.010000 SALARIES 283,000$ (8,000)$ 275,000$ 010-60.8300.011200 INTERNS/WORK STUDY 36,500$ (30,000)$ 6,500$ 010-60.8300.060000 FICA CONTRIBUTION 20,600$ (2,000)$ 18,600$ 010-60.8300.070000 MEDICARE CONTRIBUTION 4,850$ (500)$ 4,350$ 010-60.8300.080000 IPERS CONTRIBUTION 31,500$ (3,000)$ 28,500$ 010-60.8300.110000 WORKERS COMPENSATION 500$ (300)$ 200$ 010-60.8300.230000 CONSULTANT & PROFESSIONAL FEES 60,000$ 25,000$ 85,000$ 010-60.8300.270100 COMPUTER SUPPORT 5,000$ (4,500)$ 500$ 010-60.8300.270110 COPIER / PRINTER LEASE & MAINT -$ 1,650$ 1,650$ 010-60.8300.290000 GENERAL LIABILITY INSURANCE 1,600$ (900)$ 700$ 010-60.8300.290600 BONDING INSURANCE 3,600$ (3,600)$ -$ 010-60.8300.350100 PRINTING -$ 900$ 900$ 010-60.8300.390300 CITY PROPERTY TAXES 5,000$ 8,600$ 13,600$ 010-60.8300.390400 NORTHVIEW RENTAL PROPERTY EXP 7,000$ 3,500$ 10,500$ 010-60.8300.450000 TELEPHONE 11,000$ 3,000$ 14,000$ 010-60.8300.850000 LAND PURCHASES -$ 670,000$ 670,000$ Total Community Center Proposed Amendment Total Planning Proposed Amendment Total Community Development Proposed Amendment Total Mayor & Council Proposed Amendment Total Median Maintenance Proposed Amendment Total Culture & Recreation Program Proposed Amendment Total Elections Proposed Amendment Total Communications Proposed Amendment Current Proposed G/L Acct #Description Budget Recommend Budget 659,850$ City Hall 010-60.8310.270110 COPIER / PRINTER LEASE & MAINT -$ 3,500$ 3,500$ 010-60.8310.290000 CITY HALL-ANNEX INSURANCE -$ 760$ 760$ 010-60.8310.290300 BUILDING & CONTENTS INSURANCE 10,000$ (900)$ 9,100$ 010-60.8310.390100 CITY HALL ANNEX LEASE -$ 47,000$ 47,000$ 010-60.8310.390500 PROPERTY TAX EXPENSE 5,500$ 3,350$ 8,850$ 010-60.8310.400100 CUSTODIAL SERVICES 9,000$ 7,500$ 16,500$ 010-60.8310.480000 UTILITY SERVICES 10,000$ 5,000$ 15,000$ 010-60.8310.540000 MINOR EQUIPMENT 2,500$ 11,500$ 14,000$ 010-60.8310.590000 OPERATING SUPPLIES & MATERIALS 5,000$ 1,000$ 6,000$ 010-60.8310.832000 PROFESSIONAL PLAZA BUILDING -$ 402,000$ 402,000$ 010-60.8310.832010 CITY HALL ANNEX LEASE 350,000$ (308,000)$ 42,000$ 172,710$ Human Resources 010-60.8350.010000 SALARIES 115,000$ (5,000)$ 110,000$ 010-60.8350.100050 EMPLOYEE WELLNESS -$ 15,000$ 15,000$ 010-60.8350.110000 WORKERS COMPENSATION 500$ (400)$ 100$ 010-60.8350.140000 UNEMPLOYMENT CLAIMS -$ 6,100$ 6,100$ 010-60.8350.230000 CONSULTANT & PROFESSIONAL FEES 6,000$ (5,000)$ 1,000$ 010-60.8350.270110 COPIER / PRINTER LEASE & MAINT -$ 2,500$ 2,500$ 010-60.8350.290000 GENERAL LIABILITY INSURANCE 650$ 50$ 700$ 010-60.8350.350100 PRINTING 200$ 400$ 600$ 010-60.8350.689000 EMPLOYEE APPRECIATION 5,000$ 1,050$ 6,050$ 14,700$ Finance 010-60.8400.010000 SALARIES 247,000$ 3,000$ 250,000$ 010-60.8400.010500 OVERTIME PAY 1,000$ 1,000$ 2,000$ 010-60.8400.011000 PART TIME 49,000$ (4,000)$ 45,000$ 010-60.8400.100000 HEALTH & LIFE INSURANCE 51,000$ (3,000)$ 48,000$ 010-60.8400.110000 WORKERS COMPENSATION 500$ (300)$ 200$ 010-60.8400.290000 GENERAL LIABILITY INSURANCE 650$ 50$ 700$ 010-60.8400.290600 BONDING INSURANCE 600$ (600)$ -$ 010-60.8400.350100 PRINTING 2,000$ 1,500$ 3,500$ 010-60.8400.470000 TRAINING/TRAVEL EXPENSE 8,500$ (3,000)$ 5,500$ 010-60.8400.740101 COMPUTER SOFTWARE / EQUIPMENT 60,000$ (60,000)$ -$ (65,350)$ City Attorney 010-60.8600.230000 CONSULTANT & PROFESSIONAL FEES 110,000$ (85,000)$ 25,000$ (85,000)$ INFORMATION TECHNOLOGY 010-60.8800.100000 HEALTH & LIFE INSURANCE 23,000$ 5,000$ 28,000$ 010-60.8800.290300 BUILDING & CONTENTS INSURANCE 3,500$ (1,000)$ 2,500$ 010-60.8800.540000 MINOR EQUIPMENT 7,500$ 25,000$ 32,500$ 010-60.8800.740210 SERVER EQUIPMENT 61,400$ (36,400)$ 25,000$ 010-60.8800.740230 NETWORK SOFTWARE 60,000$ 15,000$ 75,000$ 7,600$ Total General Government Program Proposed Amendment 675,460$ Transfers 010-60.8400.970100 Transfer To Commerce Bank Reserve -$ 702,975$ Total General Fund Changes Total Administration Proposed Amendment Total Finance Proposed Amendment Total City Attorney Proposed Amendment Total Transfers Proposed Amendment Total City Hall Proposed Amendment Total Information Technology Proposed Amendment Total Human Resources Proposed Amendment Current Amended G/L Acct #Description Fund Budget Inc/Dec Budget Property Taxes -$ -$ -$ -$ Licenses, Permits, Fees 060-30.1600.4310300 DEVELOPER STREET LIGHT REIMB ROAD USE TAX FUND -$ 2,250$ 2,250$ 2,250$ Use of Money & Property 091-30.7850.3610000 INTEREST ON DEPOSITS TIF FUND 30,000$ (12,500)$ 17,500$ 093-30.7850.3610000 INTEREST ON DEPOSITS TIF FUND 10,000$ 22,000$ 32,000$ 094-30.7850.3610000 INTEREST ON DEPOSITS TIF FUND -$ 5,000$ 5,000$ 095-30.7850.3610000 INTEREST ON DEPOSITS TIF FUND -$ 6,000$ 6,000$ 110-30.7800.3610000 INTEREST ON DEPOSITS DEBT SERVICE FUND 14,000$ 1,500$ 15,500$ 210-00.0000.3610000 INTEREST ON DEPOSITS EMPLOYEE BENEFITS -$ 211-00.0000.3610000 INTEREST ON DEPOSITS LOCAL OPTION SALES 2,500$ 36,500$ 39,000$ 212-00.0000.3610000 INTEREST ON DEPOSITS PIF FUND -$ 12,000$ 12,000$ 327-90.2200.3610000 INTEREST ON DEPOSITS CAPITAL PROJECTS -$ 510-30.6510.3610000 INTEREST ON DEPOSITS WATER FUND 80,000$ 45,000$ 125,000$ 510-30.6510.3620000 WATER TOWER RENTAL WATER FUND 71,000$ 2,000$ 73,000$ 520-30.6520.3610000 INTEREST ON DEPOSITS SEWER FUND 60,000$ 95,000$ 155,000$ 540-30.6540.3610000 INTEREST ON DEPOSITS GAS FUND 40,000$ 20,000$ 60,000$ 560-80.5300.3610000 INTEREST ON DEPOSITS STORM WATER FUND 16,000$ 2,000$ 18,000$ 590-30.5400.3610000 INTEREST ON DEPOSITS SOLID WASTE FUND 4,000$ 3,000$ 7,000$ 750-80.8750.4533100 GOLF APARTMENT RENT GOLF COURSE FUND -$ 237,500$ Intergovernmental 110-30.7800.3010100 COMMERICAL & INDUST BACKFILL DEBT SERVICE FUND 80,578$ (10,278)$ 70,300$ 210-00.0000.3071950 COMMERICAL & INDUST BACKFILL EMPLOYEE BENE FUND 44,170$ (5,620)$ 38,550$ (15,898)$ Charges For Services 510-30.6510.4321000 DEVELOPER REIMBURSEMENT WATER FUND -$ 510-30.6510.6010000 METERED SALES WATER FUND 4,585,400$ 614,600$ 5,200,000$ 510-30.6510.6140100 METER FEES WATER FUND 250,000$ 100,000$ 350,000$ 510-30.6510.6140500 DEVELOPMENT CAPITAL FEES WATER FUND 200,000$ 200,000$ 400,000$ 520-30.6520.6010000 METERED SALES SEWER FUND 4,667,000$ 83,000$ 4,750,000$ 520-30.6520.6140100 CONNECTION FEES SEWER FUND 300,000$ 900,000$ 1,200,000$ 520-30.6520.6140500 DEVELOPMENT CAPITAL FEES SEWER FUND 400,000$ 150,000$ 550,000$ 540-30.6540.6010000 METERED SALES GAS FUND 7,033,000$ 467,000$ 7,500,000$ 540-30.6540.6120000 CUSTOMER PENALTIES GAS FUND 5,000$ 2,500$ 7,500$ 540-30.6540.6140150 COMMERCIAL METER FEES GAS FUND 18,600$ 81,400$ 100,000$ 560-80.5300.6010100 RESIDENTIAL FEES STORM WATER FUND 533,050$ 17,000$ 550,050$ 560-80.5300.6010200 COMMERCIAL FEES STORM WATER FUND 382,550$ 57,450$ 440,000$ 560-80.5300.6145100 RESIDENTIAL COMPLIANCE FEES STORM WATER FUND 50,000$ 8,000$ 58,000$ 570-30.6550.3370300 POSTING FEES UTILITY BILLING FUND 30,000$ (8,800)$ 21,200$ 570-30.6550.3770210 CREDIT CARD PROCESSING FEES UTILITY BILLING FUND 34,000$ 16,000$ 50,000$ 590-30.5400.3431000 SOLID WASTE COLLECTION SOLID WASTE FUND 1,352,500$ 23,500$ 1,376,000$ 2,711,650$ Miscellaneous 060-30.1600.3775600 PATRONAGE REBATE ROAD USE TAX FUND -$ 5,600$ 5,600$ 060-30.7100.3760300 SALE OF OLD EQUIPMENT ROAD USE TAX FUND 4,200$ 3,000$ 7,200$ 060-30.7100.3770000 MISCELLANEOUS ROAD USE TAX FUND -$ 17,600$ 17,600$ 060-30.7100.3775000 DAMAGE REIMBURSEMENT ROAD USE TAX FUND -$ 5,300$ 5,300$ 510-30.6510.3760300 SALE OF OLD EQUIPMENT WATER FUND 1,700$ 10,300$ 12,000$ 510-30.6510.3775000 DAMAGE REIMBURSEMENT WATER FUND -$ 2,200$ 2,200$ 520-30.6520.3760300 SALE OF OLD EQUIPMENT SEWER FUND 26,200$ 6,000$ 32,200$ 520-30.6520.3770000 MISCELLANEOUS SEWER FUND -$ 5,000$ 5,000$ 540-30.6540.3760300 SALE OF OLD EQUIPMENT GAS FUND 28,200$ 3,400$ 31,600$ 540-30.6540.3775000 DAMAGE REIMBURSEMENT GAS FUND -$ 4,900$ 4,900$ 540-30.6540.4321050 CONSTRUCTION SUPPORT GAS FUND 17,500$ 14,200$ 31,700$ 77,500$ Other Funds - FY2020 Proposed Revenue Budget Amendment Proposed Current Amended G/L Acct #Description Fund Budget Inc/Dec Budget Proposed Other Financing Sources 110-30.7800.3980211 TRANSFER FROM LOST DEBT SERVICE FUND -$ 110-30.7800.3980300 TRANSFER FROM URA2000 TIF DEBT SERVICE FUND -$ 110-30.7800.3980310 TRANSFER FROM HICKMAN TIF DEBT SERVICE FUND -$ 110-30.7800.3980321 TRANSFER FROM GATEWAY TIF DEBT SERVICE FUND 513,306$ 460,156$ 973,462$ 570-30.6550.3988400 TRANSFER FROM EQUIP/COMBK UTILITY BILLING FUND -$ 460,156$ 3,473,158$ Total Proposed Other Funds Revenue Changes Current Amended G/L Acct #Description Fund Budget Inc/Dec Budget Road Use Tax Fund 060-30.1600.290350 PROPERTY INSURANCE ROAD USE TAX FUND 8,500$ (5,800)$ 2,700$ 060-30.1600.480000 UTILITY SERVICES ROAD USE TAX FUND 230,000$ (65,000)$ 165,000$ 060-30.1600.760000 OTHER CAPITAL EQUIPMENT ROAD USE TAX FUND -$ 22,000$ 22,000$ 060-30.1601.230000 CONSULTANT & PROFESSIONAL FEES ROAD USE TAX FUND 10,000$ (10,000)$ -$ 060-30.1601.410300 REPAIR/MAINTENANCE FACILITIES ROAD USE TAX FUND 15,000$ 3,000$ 18,000$ 060-30.1601.480000 UTILITY SERVICES ROAD USE TAX FUND 15,000$ 4,000$ 19,000$ 060-30.7100.010000 SALAIRES ROAD USE TAX FUND 327,000$ (12,000)$ 315,000$ 060-30.7100.010500 OVERTIME PAY ROAD USE TAX FUND 17,500$ (5,500)$ 12,000$ 060-30.7100.110000 WORKERS COMPENSATION ROAD USE TAX FUND 10,500$ 1,100$ 11,600$ 060-30.7100.230000 CONSULTANT & PROFESSIONAL FEES ROAD USE TAX FUND 60,000$ (20,000)$ 40,000$ 060-30.7100.270100 COMPUTER SUPPORT ROAD USE TAX FUND -$ 2,050$ 2,050$ 060-30.7100.290000 GENERAL LIABILITY INSURANCE ROAD USE TAX FUND 3,500$ (1,225)$ 2,275$ 060-30.7100.290100 VEHICLE INSURANCE ROAD USE TAX FUND 16,000$ (1,300)$ 14,700$ 060-30.7100.410050 REPAIR/MAINT-WAUKEE MECHANIC ROAD USE TAX FUND 55,000$ (8,000)$ 47,000$ 060-30.7100.410100 REPAIR/MAINT-EQUIPMENT ROAD USE TAX FUND 20,000$ (8,000)$ 12,000$ 060-30.7100.450000 TELEPHONE ROAD USE TAX FUND 3,600$ 7,400$ 11,000$ 060-30.7100.470000 TRAINING/TRAVEL EXPENSE ROAD USE TAX FUND 11,250$ (4,750)$ 6,500$ 060-30.7100.570000 FUEL ROAD USE TAX FUND 28,000$ (5,000)$ 23,000$ 060-30.7100.590000 OPERATING SUPPLIES & MATERIALS ROAD USE TAX FUND 30,000$ (18,000)$ 12,000$ 060-30.7100.590300 ROAD STONE ROAD USE TAX FUND 50,000$ 70,000$ 120,000$ 060-30.7100.590400 ROAD REPAIR - PATCH ROAD USE TAX FUND 150,000$ 53,525$ 203,525$ 060-30.7100.591200 ROAD SALT ROAD USE TAX FUND 85,000$ 10,000$ 95,000$ 060-30.7100.591300 CALCIUM CHLORIDE ROAD USE TAX FUND 15,000$ (8,500)$ 6,500$ -$ TIF Fund 091-50.7850.970500 TRANSFER TO DEBT SERVICE TIF FUND -$ 093-30.7850.970500 TRANSFER TO DEBT SERVICE TIF FUND -$ 093-30.7850.970600 TRANSFER TO GENERAL FUND (LMI)TIF FUND -$ 85,000$ 85,000$ 094-30.7850.230000 CONSULTANT & PROFESSIONAL FEES TIF FUND -$ 95,000$ 95,000$ 094-30.7850.970500 TRANSFER TO DEBT SERVICE TIF FUND 513,306$ 460,156$ 973,462$ 095-30.7850.970600 TRANSFER TO GENERAL FUND (LMI)TIF FUND -$ 145,227$ 145,227$ 096-30.7850.230000 CONSULTANT & PROFESSIONAL FEES TIF FUND -$ 097-30.7850.230000 CONSULTANT & PROFESSIONAL FEES TIF FUND -$ 785,383$ Debt Service Fund 110-30.7850.918421 GO 19A CORP PURPOSE PRINCIPAL DEBT SERVICE FUND -$ 545,000$ 545,000$ 110-30.7850.928421 GO 19A CORP PURPOSE INTEREST DEBT SERVICE FUND -$ 154,895$ 154,895$ 699,895$ 211-00.0000.970500 TRANSFER TO DEBT SERVICE LOCAL OPTION SALES -$ -$ Capital Projects Fund 327-90.2200.970600 TRANSFER TO GEN FUND (BOND PREM)CAPITAL PROJECTS -$ -$ -$ Business Type/Enterprise Funds 510-30.6510.010000 SALARIES WATER FUND 298,000$ 22,000$ 320,000$ 510-30.6510.011000 PART TIME WATER FUND 39,000$ (19,000)$ 20,000$ 510-30.6510.100000 HEALTH & LIFE INSURANCE WATER FUND 60,000$ 25,000$ 85,000$ 510-30.6510.100100 LONG TERM DISABILITY WATER FUND 400$ 600$ 1,000$ 510-30.6510.110000 WORKERS COMPENSATION WATER FUND 5,000$ 1,500$ 6,500$ 510-30.6510.120000 UNIFORMS WATER FUND 2,500$ 500$ 3,000$ 510-30.6510.220500 MAP UPDATE WATER FUND 15,000$ (15,000)$ -$ 510-30.6510.230000 CONSULTANT & PROFESSIONAL FEES WATER FUND 65,000$ 50,000$ 115,000$ 510-30.6510.250000 TESTING FEES WATER FUND 12,000$ 7,000$ 19,000$ 510-30.6510.270000 DATA PROCESSING WATER FUND 20,000$ (8,000)$ 12,000$ 510-30.6510.290000 GENERAL LIABILITY INSURANCE WATER FUND 3,500$ 1,450$ 4,950$ 510-30.6510.290100 VEHICLE INSURANCE WATER FUND 1,000$ 200$ 1,200$ 510-30.6510.290300 BUILDING & CONTENTS INSURANCE WATER FUND 6,000$ (3,900)$ 2,100$ 510-30.6510.340000 MISCELLANEOUS CONTRACTUAL WATER FUND 30,000$ (22,500)$ 7,500$ 510-30.6510.410400 REPAIR/MAINT OF DELIVERY SYSTEM WATER FUND 15,000$ 24,500$ 39,500$ 510-30.6510.450000 TELEPHONE WATER FUND 4,100$ 2,400$ 6,500$ 510-30.6510.470000 TRAINING/TRAVEL EXPENSE WATER FUND 9,100$ (3,100)$ 6,000$ 510-30.6510.570000 FUEL WATER FUND 20,000$ (6,000)$ 14,000$ 510-30.6510.592000 METER PURCHASE WATER FUND 450,000$ 50,000$ 500,000$ 510-30.6510.650000 COST OF GOOD SOLD WATER FUND 1,250,025$ 149,975$ 1,400,000$ 510-30.6510.650010 DSMWW OPERATING & MAINTENANCE WATER FUND 73,500$ 46,500$ 120,000$ Proposed Other Funds - FY2020 Proposed Expenditure Budget Amendment Local Option Sales Tax Fund Current Amended G/L Acct #Description Fund Budget Inc/Dec Budget Proposed 510-30.6510.880903 NW AREA WATER MAIN EXT - PH II WATER FUND -$ 180,000$ 180,000$ 510-30.6510.882420 CHLORAMINATION FACILITY WATER FUND -$ 225,200$ 225,200$ 510-30.6510.930300 DEBT ISSUANCE COSTS WATER FUND -$ 68,700$ 68,700$ 778,025$ 520-30.6520.010000 SALARIES SEWER FUND 299,000$ (47,000)$ 252,000$ 520-30.6520.100000 HEALTH & LIFE INSURANCE SEWER FUND 60,000$ 8,000$ 68,000$ 520-30.6520.110000 WORKERS COMPENSATION SEWER FUND 2,500$ (900)$ 1,600$ 520-30.6520.220500 MAP UPDATE SEWER FUND 15,000$ (15,000)$ -$ 520-30.6520.230000 CONSULTANT & PROFESSIONAL FEES SEWER FUND 100,000$ (60,000)$ 40,000$ 520-30.6520.250000 TESTING FEES SEWER FUND -$ 1,500$ 1,500$ 520-30.6520.290000 GENERAL LIABILITY INSURANCE SEWER FUND -$ 6,000$ 6,000$ 520-30.6520.290300 BUILDING & CONTENTS INSURANCE SEWER FUND 8,500$ (6,000)$ 2,500$ 520-30.6520.450000 TELEPHONE SEWER FUND 5,000$ 500$ 5,500$ 520-30.6520.470000 TRAINING/TRAVEL EXPENSE SEWER FUND 12,300$ (4,300)$ 8,000$ 520-30.6520.480000 UTILITY SERVICES SEWER FUND 25,000$ 4,000$ 29,000$ 520-30.6520.570000 FUEL SEWER FUND 22,500$ (9,500)$ 13,000$ 520-30.6520.650010 WRA OPERATING & MAINTENANCE SEWER FUND 455,687$ 20,313$ 476,000$ 520-30.6520.880500 WASTE WATER TREATMENT FACILITY SEWER FUND 750,000$ (750,000)$ -$ 520-30.6520.883000 OUTFALL CONNECTION SEWER FUND -$ 180,000$ 180,000$ 520-30.6520.883060 LITTLE WALNUT CREEK SEWER SEWER FUND -$ 125,000$ 125,000$ 520-30.6520.883091 NW AREA TRUNK SEWER EXT SEWER FUND -$ 100,000$ 100,000$ 520-30.6520.883093 TREATMENT PLANT DEMOLITION SEWER FUND -$ 1,100,000$ 1,100,000$ 652,613$ 540-30.6540.010000 SALARIES GAS FUND 349,000$ (11,000)$ 338,000$ 540-30.6540.100000 HEALTH & LIFE INSURANCE GAS FUND 103,000$ (5,000)$ 98,000$ 540-30.6540.110000 WORKERS COMPENSATION GAS FUND 4,000$ 700$ 4,700$ 540-30.6540.120000 UNIFORMS GAS FUND -$ 540-30.6540.210000 PUBLIC NOTIFICATION/ADVERTISING GAS FUND 8,000$ 4,000$ 12,000$ 540-30.6540.220500 MAP UPDATE GAS FUND 15,000$ (15,000)$ -$ 540-30.6540.230000 CONSULTANT & PROFESSIONAL FEES GAS FUND 30,000$ 35,000$ 65,000$ 540-30.6540.270000 DATA PROCESSING GAS FUND 9,000$ 1,500$ 10,500$ 540-30.6540.270100 COMPUTER SUPPORT GAS FUND 7,500$ (1,600)$ 5,900$ 540-30.6540.280000 DUES MEMBERSHIPS & SUBSCRIPT GAS FUND 35,000$ 60,000$ 95,000$ 540-30.6540.390000 RENTAL/LEASE OF EQIPMENT GAS FUND 8,000$ 4,500$ 12,500$ 540-30.6540.570000 FUEL GAS FUND 20,000$ (4,000)$ 16,000$ 540-30.6540.590100 DEVELOPER MATERIALS GAS FUND 100,000$ 75,000$ 175,000$ 540-30.6540.590200 INSTALLATION MATERIALS GAS FUND 125,000$ (75,000)$ 50,000$ 540-30.6540.592000 METER PURCHASE GAS FUND 250,000$ 35,000$ 285,000$ 540-30.6540.650000 COST OF GAS SOLD GAS FUND -$ 540-30.6540.685400 GAS REBATE GAS FUND -$ 540-30.6540.691100 PUBLIC WORKS BLDG REIMBURSEMENT GAS FUND -$ 540-30.6540.691200 MECHANIC REIMBURSEMENT GAS FUND -$ 104,100$ 560-80.5300.010000 SALARIES STORM WATER FUND 255,000$ (103,000)$ 152,000$ 560-80.5300.010500 OVERTIME PAY STORM WATER FUND 2,000$ 1,000$ 3,000$ 560-80.5300.100000 HEALTH & LIFE INSURANCE STORM WATER FUND 60,000$ (22,000)$ 38,000$ 560-80.5300.110000 WORKERS COMPENSATION STORM WATER FUND 2,500$ (900)$ 1,600$ 560-80.5300.220500 MAP UPDATE STORM WATER FUND 15,000$ (15,000)$ -$ 560-80.5300.270100 COMPUTER SUPPORT STORM WATER FUND 1,500$ 1,500$ 3,000$ 560-80.5300.450000 TELEPHONE STORM WATER FUND 3,000$ 1,100$ 4,100$ 560-80.5300.470000 TRAINING/TRAVEL EXPENSES STORM WATER FUND 6,550$ (4,050)$ 2,500$ 560-80.5300.691200 MECHANIC REIMBURSEMENT STORM WATER FUND -$ STORM WATER FUND -$ -$ -$ (141,350)$ 570-30.6550.010000 SALARIES UTILITY BILLING FUND 170,000$ (5,000)$ 165,000$ 570-30.6550.010500 OVERTIME PAY UTILITY BILLING FUND 3,000$ 1,000$ 4,000$ 570-30.6550.100000 HEALTH & LIFE INSURANCE UTILITY BILLING FUND 38,000$ (10,000)$ 28,000$ 570-30.6550.390000 RENTAL/LEASE OF EQUIPMENT UTILITY BILLING FUND 7,500$ 1,000$ 8,500$ 570-30.6550.450200 CREDIT CARD FEES UTILITY BILLING FUND 37,000$ 8,000$ 45,000$ 570-30.6550.740101 COMPUTER SOFTWARE UTILITY BILLING FUND -$ (5,000)$ 590-30.5400.231300 RESIDENTIAL SOLID WASTE COLLECTION SOLID WASTE FUND 1,250,000$ 45,000$ 1,295,000$ 590-30.5400.240100 LANDFILL FEES SOLID WASTE FUND -$ 590-30.5400.240400 NDCL PLANNING FEES 28E SOLID WASTE FUND -$ 45,000$ 750-80.8750.540000 MINOR EQUIPMENT GOLF COURSE FUND 4,000$ 200,000$ 204,000$ 750-80.8750.710000 GOLF CARTS / AUTOMOTIVE EQUIP GOLF COURSE FUND 200,000$ (200,000)$ -$ WATER FUND TOTAL SEWER FUND TOTAL GAS FUND TOTAL STORM WATER FUND TOTAL UTILITY BILLING FUND TOTAL SOLID WASTE FUND TOTAL Current Amended G/L Acct #Description Fund Budget Inc/Dec Budget Proposed -$ 1,433,388$ Transfers 810-50.8400.970600 TRANSFER TO GENERAL FUND (FINANCE)EQUIP RESERVE FUND 60,000$ (60,000)$ -$ 810-50.6550.970600 TRANSFER TO UTILITY BILLING FUND EQUIP RESERVE FUND -$ -$ (60,000)$ 2,858,666$ Total Proposed Expenditure Changes GOLF COURSE FUND TOTAL Business Type/Enterprise Funds Total