Loading...
HomeMy WebLinkAbout2016-05-23-D01 FY2016 Budget Amendment PH►�; Waukee `f-1NO;THE KEY TO GOOD LIVING AGENDA ITEM: CITY OF WAUKEE, IOWA CITY COUNCIL MEETING COMMUNICATION MEETING DATE: May 23`d, 2016 AGENDA ITEM: On an amendment to the FY2016 Budget FORMAT: Public Hearing SYNOPSIS INCLUDING PRO & CON: After review of the current FY 16 budget, the following changes were needed: Revenue Sources: Licenses & Permits Use of Money & Property Intergovernmental Charges for Services Miscellaneous Transfers In Total Revenue Increases: + $298,000 + $8,000 + $1, 950 + $16,750 + $4,750 + %4.533 Expenditure Programs: Public Safety + Public Works - Health & Social Services + Culture & Recreation + Community & Econ Dev + General Government + Debt Service + Capital Projects + Business Typc/Enterprises + Transfers Out + Total Expenditure Increases: FISCAL IMPACT INCLUDING COST/BENEFIT ANALYSIS: COMMISSION/BOARD/COMMITTEE COMMENT: $334,450 $142,335 $(38,422) $1,500 $30,016 $362,230 $30,750 $856,000 $0 $0 $5.000 $1,3 89,409 STAFF REVIEW AND COMMENT: Attached worksheets break down the increases by fund and departments. Review these worksheets and approve the FY2016 budget amendment as presented. RECOMMENDATION: Hold the public hearing. ATTACHMENTS: FYI 6 Notice of Public Hearing Amendment of Current City Budget FYI Budget Amendment Workshects PREPARED BY: Linda Burkhart J REVIEWED BY: PUBLIC NOTICE INFORMATION -- NAME OF PUBLICATION: Des Moines Register DATE OF PUBLICATION: May 13Lh, 2016 NOTICE OF PUBLIC HEARING Form e53.C1 AMENDMENT OF CURRENT CITY BUDGET The City Council of Waukee in DALLAS County, Iowa will meet at Waukee City Hall - 230 W Hickman Rd at 5:30 pm on 5/23/2016 rhour) r0ala) ,for the purpose of amending the current budget of the city for the fiscal year ending June 30, 2016 road 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 as certified or last amended Current Amendment Total Budget after Current Amendment Revenues & Other Financing Sources Taxes Levied on Property 1 9,113,927 9,113,927 Less: Uncollected Property Taxes -Levy Year 2 0 0 Net Current Property Taxes 3 9,113,927 0 9,113,927 Delinquent Property Taxes 4 0 0 TIF Revenues 5 3,388,430 3,388,430 Other City Taxes 6 79,737 79,737 Licenses & Permits 7 944,440 298,000 1,242,440 Use of Money and Property 8 238,925 8,000 246,925 Intergovernmental 9 2,381,580 1,950 2,383,530 Charges for Services 10 15,707,773 16,750 15,724,523 Special Assessments 11 27,000 27,000 Miscellaneous 12 277,450 4,750 282,200 Other Financing Sources 13 3,045,000 3,045,000 Transfers In 14 6,953,335 5,000 6,958,335 Total Revenues and Other Sources 15 42,157,597 334,450 42,492,047 Expenditures & Other Financing Uses Public Safety 16 4,428,830 142,335 4,571,165 Public Works 17 3,256,019 -38,422 3,217,597 Health and Social Services 18 4,000 1,500 5,500 Culture and Recreation 19 1,715,353 30,016 1,745,369 Community and Economic Development 20 882,055 362,230 1,244,285 General Government 21 887,331 30,750 918,081 Debt Service 22 6,169,803 856,000 7,025,803 Capital Projects 23 24,545,000 24,545,000 Total Government Activities Expenditures 24 41,888,391 1,384,409 43,272,800 Business Type / Enterprises 25 14,162,076 14,162,076 Total Gov Activities & Business Expenditures 26 56,050,467 1,384,409 57,434,876 Transfers Out 27 6,953,335 5,000 6,958,335 Total Expenditures/Transfers Out 28 63,003,802 1,389,409 64,393,211 Excess Revenues &Other Sources Over (Under) ExpenditurestTransfers Out Fiscal Year 29 .................... ............................................................... -20,846,205 .................... 1,054,959 .................... 21,901,164 Beginning Fund Balance July 1 30 64,176,557 64,176,557 Ending Fund Balance June 30 31 43,330,352 -1,054,959 42,275,393 Explanation of increases or decreases in revenue estimates, appropriations, or available cash Revenues- Major Changes - Bldg Permits, Construction Inspections, & Community Grants Expenditures - Major Changes - increase wages/OT/per call compensation, workers compensation, computer support, repair/maintenance bldgs,EnerGov/Incode/OpenGov software, rebranding signs/letterhead/paper, parks planning/consulting, econ develop consulting/developer rebates,2015C bond debt service; decrease health insurance, fuel, ambulance billing fees. 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/18/2016 Remaining 010 General Fund $8,715,014 $221,859 $8,936,873 $7,462,245 $1,474,628 060 Road Use Tax Fund $2,324,144 $0 $2,324,144 $1,901,959 $422,185 091 Hickman West Industrial Park TIF $422,542 $0 $422,542 $0 $422,542 092 Enterprise Business Park TIF $221,858 $0 $221,858 $0 $221,858 093 Waukee Urban Renewal Area TIF $4,498,378 $311,550 $4,809,928 $492,561 $4,317,367 094 Gateway Urban Renewal Area TIF $0 $0 $0 $2,788 ($2,788) 095 Autumn Ridge Urban Renewal Area TIF $0 $0 $0 $4,024 ($4,024) 110 Debt Service Fund $6,124,643 $856,000 $6,980,643 $6,848,965 $131,678 111 Special Assessments Fund $45,160 $0 $45,160 $45,160 $0 210 Employee Benefits $1,343,400 $0 $1,343,400 $0 $1,343,400 327 Capital Projects $24,545,000 $0 $24,545,000 $8,216,225 $16,328,775 510 Water Utility Fund $4,175,932 $0 $4,175,932 $4,498,921 ($322,989) 520 Sewer Utility Fund $3,063,609 $0 $3,063,609 $2,181,971 $881,638 540 Gas Utility Fund $4,937,135 $0 $4,937,135 $3,892,951 $1,044,184 560 Storm Water Utility Fund $637,120 $0 $637,120 $522,409 $114,711 570 Utility Bill Fund $254,500 $0 $254,500 $203,015 $51,485 590 Solid Waste Collect & Rcycl Fund $986,950 $0 $986,950 $930,222 $56,728 750 Golf Course Fund $659,917 $0 $659,917 $407,855 $252,062 810 Equipment Revolving Fund $0 $0 $0 $0 $0 O10 General Fund 060 Road Use Tax Fund 091 Hickman West Industrial Park TIF 092 Enterprise Business Park TIF 093 Waukee Urban Renewal Area TIF 094 Gateway Urban Renewal Area TIF 095 Autumn Ridge Urban Renewal Area TIF 110 Debt Service Fund 111 Special Assessments 210 Employee Benefits Fund 327 Capital Projects 330 City Wide Spec Assess -Sidewalk Prog 510 Water Utility Fund 520 Sewer Utility Fund 521 University Ave Trunk Sewer Fund 522 Waste Water Treatment Plant Fund 523 E Area Pump Station Fund 540 Gas Utility Fund 560 Storm Water Utility Fund 570 Utility Bill Fund 590 Solid Waste Collection Fund 750 Golf Course Fund 810 Equipment Revolving Fund Total Collected Original Increase/ Amended Year To Date Balance Budget Decrease Budget thru 5/18/2016 Remaining $8,800,923 $329,450 $9,130,373 $7,342,254 $1,788,119 $1,924,000 $0 $1,924,000 $1,494,034 $429,966 $561,972 $0 $561,972 $552,949 $9,023 $228,523 $0 $228,523 $225,961 $2,562 $2,604,135 $0 $2,604,135 $2,555,261 $48,874 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $6,738,241 $0 $6,738,241 $2,629,703 $4,108,538 $42,200 $0 $42,200 $28,827 $13,373 $1,385,441 $0 $1,385,441 $1,374,483 $10,958 $4,545,000 $0 $4,545,000 $3,339,639 $1,205,361 $0 $0 $0 $8,369 ($8,369) $3,850,180 $0 $3,850,180 $3,256,610 $593,570 $3,441,853 $0 $3,441,853 $3,431,860 $9,993 $0 $0 $0 $4,559 ($4,559) $0 $0 $0 $8 ($8) $0 $0 $0 $28 ($28) $5,649,140 $0 $5,649,140 $4,683,350 $965,790 $521,150 $0 $521,150 $480,524 $40,626 $234,400 $0 $234,400 $109,935 $124,465 $981,200 $0 $981,200 $881,750 $99,450 $629,300 $5,000 $634,300 $522,978 $111,322 $20,000 $20,000 $27 $19,973 Total Revenues $42,157,658 $334,450 $42,492,108 $32,923,109 $9,568,999 As of 5/18/2016 Original Amount Amended Total Expended Balance Budget to Amend Budget Year To Date Remaining Police $2,368,500 $54,400 $2,422,900 $2,062,357 $360,543 Warning Sirens $1,500 $ 3,900 $5,400 $3,763 $1,637 Westcom Dispatch $320,000 $ 35,000 $355,000 $324,670 $30,330 Fire $812,450 $3,320 $815,770 $699,373 $116,397 EMS $659,100 $37,955 $697,055 $592,142 $104,913 Code Compliance $266,280 $5,760 $272,040 $227,783 $44,257 Animal Control $1,000 $2,000 $3,000 $2,375 $625 Public Works $59,558 $11,800 $71,358 $22,543 $48,815 Public Works Building $10,000 ($10,000) $0 $132,736 ($132,736) Public Works Mechanic $194,550 $1,150 $195,700 $273,013 ($77,313) Engineering $644,916 ($38,532) $606,384 $351,693 $254,691 GIS $22,851 ($2,840) $20,011 $3,160 $16,851 Mosquito Control $4,000 $1,500 $5,500 $3,900 $1,600 Library $762,090 ($42,750) $719,340 $608,238 $111,102 Parks $445,634 $47,233 $492,867 $402,796 $90,071 Recreation $484,809 $18,333 $503,142 $400,191 $102,951 Community Center $22,820 $7,200 $30,020 $25,785 $4,235 Median Maintenance $14,000 $0 $14,000 $5,903 $8,097 Community Development $299,270 $67,500 $366,770 $288,754 $78,016 Development Services $378,785 ($16,820) $361,965 $309,115 $52,850 Mayor & Council $71,920 ($6,080) $65,840 $54,510 $11,330 Elections $8,000 $100 $8,100 $8,101 ($1) Communications $96,362 ($12,465) $83,897 $56,819 $27,078 Administration $328,580 $8,430 $337,010 $249,431 $87,579 City Hall $75,000 ($1,680) $73,320 $59,624 $13,696 Human Resources $59,745 $33,340 $93,085 $65,397 $27,688 Finance $147,724 $29,105 $176,829 $132,017 $44,812 City Attorney $100,000 ($20,000) $80,000 $96,056 ($16,056) Transfers $55,570 $5,000 $60,570 $0 $60,570 $8,715,014 $221,859 $8,936,873 $7,462,245 $1,474,628 Original Amount Amended. Total Collected Balance Budget to Amend Budget Year To Date Remaining Property Tax $5,392,658 $0 $5,392,658 $5,351,727 $40,931 Other City Tax $16,200 $0 $16,200 $13,314 $2,886 License, Permits & Fees $937,440 $298,000 $1,235,440 $995,755 $239,685 Use of Money & Property $153,025 $8,000 $161,025 $132,210 $28,815 Intergovernmental $234,700 $1,950 $236,650 $230,340 $6,310 Charges for Services $583,850 $16,750 $600,600 $490,977 $109,623 Misc $139,650 $4,750 $144,400 $127,594 $16,806 Other Finance Sources $0 $0 $0 $337 ($337) Transfersln $1,343,400 $0 $1,343,400 $0 $1,343,400 $8,800,923 $329,450 $9,130,373 $7,342,254 $1,788,119 FY2016 - Budget Amendment Summary Proposed Revenue Expenditures Reserve _13EELEOW,- Inc/(Dec) Inc/(Dec) Inc/(Dec) "Mim 1 - • - $ $ 5,600 (22,100) $ $ - 54,400 $ $ 5,600 (76,500) Police Dept Warning Sirens $ - $ 3,900 $ (3,900) Westcom Dispatch $ - $ 35,000 $ (35,000) Fire $ - $ 3,320 $ (3,320) EMS $ - $ 37,955 $ (37,955) Code Compliance $ 184,000 $ 5,760 $ 178,240 Animal Control $ - $ 2,000 $ (2,000) $ $ 161,900 - $ $ 142,335 11,800 $ $ 19,565 (11,800) Public Works Public Works Building $ - $ (10,000) $ 10,000 Public Works Mechanic $ 1,750 $ 1,150 $ 600 Engineering $ 112,500 $ (38,532) $ 151,032 CIS $ - $ (2,840) $ 2,840 $ $ 114,250 - $ $ (38,422) 1,500 $ $ 152,672 (1,500) Mosquito Control $ $ - 4,500 $ $ 1,500 (42,750) $ $ (1,500) 47,250 Library Parks $ 16,900 $ 47,233 $ (30,333) Recreation $ 15,300 $ 18,333 $ (3,033) Community Center $ 6,000 $ 7,200 $ (1,200) $ $ 42,700 - $ $ 30,016 - $ $ 12,684 - Median Maintenance Community Development $ - $ 67,500 $ (67,500) Development Services $ - $ (16,920) $ 16,820 $ $ - - $ $ 50,680 (6,080) $ $ (50,680) 6,080 Mayor & Council Elections $ - $ 100 $ (100) Communications $ - $ (12,465) $ 12,465 Administration $ - $ 8,430 $ (8,430) City Hall $ - $ (1,680) $ 1,680 Human Resources $ - $ 33,340 $ (33,340) Finance $ 5,000 $ 29,105 $ (24,105) City Attorney $ - $ (20,000) $ 20,000 $ 51000 $ 30,750 $ (25,750) Transfer to Commerce Bank Reserve $ - $ 5,000 $ (5,000) Sale Property $ - $ - $ - $ - $ 5,000 $ (5,000) 107,591 General Fund - FY2016 Proposed Revenue Budget Amendment Current Proposed G/L AcctN Budget YTD Actual Change Budget 010-10.1900.4300000 Total Property Taxes BUILDING PERMITS $ $ 175,000 $ 600,000 $ 425,000 $ 469,129 010-10.1900.4310100 SUBDIVISION PLATING FEES $ 3,500 $ 8,000 $ 6,000 $ 9,500 010-10.1900.4320100 SITE PLAN REVIEW FEES $ 3,000 $ 6,600 $ 4,500 $ 7,500 010-20.8900.4320600 CONSTRUCTION INSPECTION FEES $ 200,000 $ 220,579 $ 120,000 $ 320,000 010-20.8900.4320700 ENGINEER ADMINISTRATION FEES $ 14,500 $ 3,958 $ (7,500) $ 7,000 Total Licenses, Permits & fees $ rri 010-40A100.4530000 PARK SHELTER RENT $ 7,000 $ 7,530 $ 2,000 $ 9,000 010-40,4300.4531000 COMMUNITY CENTER RENT $ 10,000 $ 14,102 $ 6,000 $ 16,000 Total Use of Money & Property i 010-10.1100.4020300 RESOURCE OFFICER REIMBURSEMENT $ 130,300 $ 127,756 $ (2,550) $ 127,750 010-40.3100.4410000 LIBRARY OPEN ACCESS $ 21,000 $ 25,582 $ 4,500 $ 25,500 Total Intergovernmental 2,950 010-40.4200.4517000 WINTER PROGRAMS $ 10,000 $ 12,505 $ 2,500 $ 12,500 010-40.4200.4517500 SUMMER PROGRAMS $ 16,000 $ 20,962 $ 5,500 $ 21,500 010-40.4200.4540200 SOFTBALL -YOUTH REGISTRATIONS $ 32,000 $ 34,896 $ 5,000 $ 37,000 010-40.4200.4540210 T-BALL REGISTRATIONS $ 8,500 $ 8,263 $ 1,500 $ 10,000 010-40.4200.4540300 SOCCER -YOUTH REGISTRATIONS $ 3,500 $ 2,083 $ 500 $ 4,000 010-20.6150.6200600 MECHANIC FEES - ROADS $ 65,000 $ 46,724 $ (8,000) $ 57,000 010-20.6150.6201100 MECHANIC FEES - POLICE $ 1,500 $ 2,096 $ 1,000 $ 2,500 010-20.6150.6201400 MECHANIC FEES - FIRE $ - $ 497 $ 500 $ 500 010-20.6150.6204100 MECHANIC FEES - PARKS $ 17,500 $ 11,498 $ (4,500) $ 13,000 010-20.6150.6204200 MECHANIC FEES- RECREATION $ 500 $ 785 $ 250 $ 750 010-20.6150.6205100 MECHANIC FEES - WATER $ 25,500 $ 23,173 $ 3,500 $ 29,000 010-20.6150.6205200 MECHANIC FEES - SEWER $ 39,000 $ 33,383 $ 2,000 $ 41,000 010-20.6150.6205400 MECHANIC FEES - GAS $ 31,000 $ 35,046 $ 8,000 $ 39,000 010-20.6150.6205600 MECHANIC FEES - STORM WATER $ 3,500 $ 4,037 $ 1,000 $ 4,500 010-20.6150.6206000 MECHANIC FEES -PUBLIC WORKS $ 3,800 $ 1,854 $ (1,300) $ 2,500 010-20.6150.6207500 MECHANIC FEES - GOLF COURSE $ 3,000 $ 1,279 $ (1,500) $ 1,500 010-20.6150.6208950 MECHANIC FEES -GIS $ 500 $ 1,179 $ 800 $ 1,300 Total Charges For Services 16,750 Miscellaneous....... 010-00.0000.3760300 SALE OF OLD EQUIPMENT $ - $ 2,978 $ 3,000 $ 3,000 010-00.0000.6120000 LATE FEE PENALTIES $ 800 $ 2,894 $ 2,600 $ 3,400 010-10.1100.4010000 COURT FINES $ 65,000 $ 31,210 $ (29,000) $ 36,000 010-10.1100.4010100 CIVIL PENALTY $ 2,000 $ 5,875 $ 5,500 $ 7,500 010-10.1100.4030000 POLICE DONATIONS $ - $ 3,949 $ 3,950 $ 3,950 010-10.1900.3530100 SNOW REMOVAL FEES $ 1,500 $ - $ (1,500) $ - 010-40.4100.3770450 COMMUNITY GRANTS $ - $ 14,905 $ 14,900 $ 14,900 010-40.4200.4510200 4TH OFIULY CELEBRATION $ 4,000 $ 5,825 $ 1,800 $ 5,800 010-40.4200.4510600 BIKE FEST PROCEEDS $ 4,000 $ 782 $ (1,500) $ 2,500 010-60.8400.3775550 COMMERCE BANK REVENUE SHARE $ 20,000 $ 21,376 $ 5,000 $ 25,000 Total Miscellaneous $ 4,750 $ $ $ $ General Fund - FY2016 Proposed Expenditure Budget Amendment Current Proposed Health/Life/ Other Pre -Approved Changes Admin/Fin Proposed G/L Acctg Description Budget YTD Actual LTD/WC Change Change Reason Recommend Budget 010-10.1100.010000 SALARIES $ 1,256,960 $ 1,054,100 $ 43,040 $ 1,300,000 010-10.1100.010500 OVERTIME PAY $ 95,000 $ 96,772 $ 25,000 $ 120,000 010-10.1100.060000 FICA CONTRIBUTION $ 84,200 $ 71,393 $ 4,220 $ 88,420 010-10.1100.070000 MEDICARE CONTRIBUTION $ 19,710 $ 16,697 $ 990 $ 20,700 010-10.1100.080000 IPERS CONTR18UTION $ 137,740 $ 110,155 5 6,700 $ 144,440 010-10.1100.100000 HEALTH & LIFE INSURANCE $ 350,100 $ 227,095 $ (70,100) $ (70,100) $ 280,000 010-10.1100.120000 UNIFORMS $ 23,500 $ 29,306 $ 9,000 $ 32,500 010-10.1100,230000 CONSULTANT& PROFESSIONAL FEES $ 6,200 $ (6,845) $ (4,200) $ 2,000 010-10.1100.270000 DATA PROCESSING $ 6,000 $ (1,949) $ (4,000) $ 2,000 010-10-1100,270100 COMPUTERSUPPORT $ 13,600 $ 17,583 $ 6,400 $ 20,000 010-10.1300.270110 COPIER/PRINTER LEASE &MAINT $ - $ 10,058 $ 12,ODO $ 12,000 010-10.1100.290400 LAW ENFORCEMENT LIABILITY INS $ 8,000 $ 7,108 $ (800) S 7,200 010-10.1100.350100 PRINTING $ 1,500 $ 3,554 $ 2,000 $ 3,500 010-10.1100.390000 RENTAL/LEASE OF EQUIPMENT $ 3,500 S - $ (3,500) $ - 010-10.1100,400100 CUSTODIAL $ 3,000 $ 5,023 $ 3,200 $ 6,200 010-10.1100.410100 REPAIR/MAINTENANCE OF EQUIPMEN $ - $ 974 $ 1,000 $ 1,000 010-10.1100.410200 REPAIR/MAINTENANCE OF ELECTRON $ 7,000 $ 9,712 $ 4,000 $ 11,000 010-10.1100.450000 TELEPHONE $ 20,000 $ 13,455 $ (3,500) $ 16,500 010-10.1100.460200 PD COMMUNITY POLICING EXPENSES $ 30,000 $ 6,235 $ (15,000) $ 15,000 010-10.1100.470000 TRAINING/TRAVEL EXPENSE $ 30,100 $ 39,924 $ 14,900 $ 45,000 010-10.1100.S40000 MINOR EQUIPMENT 5 22,000 $ 31,923 $ 18,000 $ 40,000 010-10.1100.560000 MOTOR VEHICLE MAINT SUPPLIES $ 10,000 $ 5,336 $ (2,500) $ 7,500 010-10.1100.S70000 FUEL $ 50,000 $ 21,392 $ (20,000) $ 30,000 010-10.1100.590000 OPERATING SUPPLIES & MATERIALS $ 3,000 $ 5,896 $ 4,500 $ 7,500 010-10.1100.710000 AUTOMOTIVE EQUIPMENT $ 33,950 $ 50,438 $ 16,550 $ 50,500 010-10,1100.830100 Total Police LEASEHOLD IMPROVEMENTS Dept Proposed Amendment $ 56000 $ 62075 1 $ (70,100) 1 $ 5 6.500 $ t 8 62,500 $ - $ 388 $ 400 $ 400 010-10.1110.290300 Building& Contents Insurance 010-10.1110.400000 Total Warning Sirens Repairs/Maintenance-Sirens Dept Proposed Amendment $ 1500 $ 3374 $ $ 3,500 $ 3,900 $ 5,000 $ 320000 $ 295155 $ $ $ 35,000 35,000 $ 355,000 010-10.1300.230010 Westcom Dispatch Services F Total Westcom Dispatch Dept Proposed Amendment $ 248,250 $ 202,654 $ 6,750 $ 255,000 010-10.1400.010000 SALARIES 010-10.1400.010500 OVERTIME PAY $ 27,500 $ 24,292 $ 2,000 $ 29,500 010-10.1400,011500 PER CALL COMPENSATION $ 176,000 $ 141,591 $ (4,000) $ 172,000 010-10.1400.060000 FICA CONTRIBUTION $ 28,165 $ 22,675 $ 300 $ 28,465 010-10.1400.070000 MEDICARE CONTRIBUTION $ 6,660 $ 5,304 $ 70 $ 6,730 010-10.1400.080000 IPERS CONTRIBUTION $ 45,880 $ 35,403 $ 500 $ 46,380 010-10.1400.100000 HEALTH &LIFE INSURANCE $ 63,900 $ 50,063 $ (2,900) $ (2,900) $ 61,000 010-10.1400.102000 SECTION 125 FLEX BENEFIT $ 500 $ 625 $ 250 $ 250 $ 750 010-10.1400.110000 WORKERS COMPENSATION $ 67,045 $ 83,738 $ 16,700 $ 16,700 $ 83,745 010-10.1400.270100 COMPUTERSUPPORT $ 4,800 $ 1,784 $ (1,500) $ 3,300 010-10.1400.270110 COPIER/PRINTER LEASE &MAINT $ - $ 1,115 $ 1,500 $ 1,S00 010-10.1400.290100 VEHICLE INSURANCE $ 18,000 $ 15,258 $ (2,500) $ 15,500 010-10.1400.290300 BUILDING& CONTENTS INSURANCE $ 2,550 $ 2,920 $ 400 $ 2,950 010-10.1400.400000 REPAIR/MAINTENANCE Of BUILDING $ 6,000 $ 8,210 $ 5,000 $ 11,000 010-10.1400.570000 FUEL $ 9,000 $ 4,467 $ (2,500) $ 6,500 010-10,1400.570100 OIL/FILTERS/LURE $ - $ 432 S 750 $ 750 010-10.1400.710000 Total Fire AUTOMOTIVE EQUIPMENT Dept Proposed Amendment $ 35,000 $ 17,447 1 14,050 $ (17,500) $ 3,320 $ 17,500 L' 010-10.1500,010000 SALARIES $ 248,250 $ 198,487 $ 3,750 $ 252,000 010-10.1500.010500 OVERTIME PAY $ 19,000 $ 20,489 $ 6,000 $ 25,000 010-10.1500.011500 PER CALL COMPENSATION $ 110,000 $ 99,357 $ 10,000 $ 120,000 010-10.1500.060000 FICA CONTRIBUTION $ 23,565 $ 19,69S $ 1,250 $ 24,815 010-10.1500.070000 MEDICARE CONTRIBUTION $ 5,560 $ 4,605 $ 300 $ 5,860 010-10.1500.080000 IPERS CONTRIBUTION $ 38,330 $ 30,675 $ 1,950 $ 40,280 010-10.1500-100000 HEALTH & LIFE INSURANCE $ 63,900 $ 54,196 $ 1,600 $ 1,600 $ 65,500 010-10.1500.102000 SECTION 125 FLEX BENEFIT $ 500 $ 625 $ 250 $ 250 $ 750 010-10.1500.110000 WORKERS COMPENSATION $ 29,245 $ 42,663 $ 13,455 $ 13,455 $ 42,700 010-10.1500.110100 EMPLOYEE PHYSICALS $ 2,500 $ 2,817 $ 500 $ 500 $ 3,000 010-10.1500.130000 TUITION REIMBURSEMENT $ 4,700 $ 3,168 $ (1,100) 5 (1,100) $ 3,600 010-10,1500.231800 AMBULANCE BILLING FEES $ 38,000 $ 10,164 $ (22,500) $ 15,500 010-10.1500.400000 REPAIR/MAINTENANCE OF BLDG $ 6,000 $ 6,107 $ 1,000 $ 7,000 010-10.1500.410000 REPAIR OF VEHICLES $ 4,000 $ 6,596 $ 4,000 $ 8,000 010-10.1500.710000 AUTOMOTIVE EQUIPMENT $ - $ 17447 $ 17,500 $ 17,500 Current Proposed Health/Life/ Other Pre -Approved Changes Admin/Fin Proposed GA AcctR Description Budget YTD Actual LTD/WC Change Change Reason Recommend Budget 010-10.1900.010000 SALARIES $ 159,500 $ 115,317 $ (16,000) $ 143,500 010-10.1900,010500 OVERTIME PAY $ 5,000 $ 6,784 $ 3,000 $ 8,000 010-10.1900.060000 FICA CONTRIBUTION $ 10,400 $ 7,601 $ (800) $ 9,600 010-10.1900,070000 MEDICARE CONTRIBUTION $ 2,500 $ 1,778 $ (190) $ 2,310 010-10.1900.080000 IPERS CONTRIBUTION $ 14,900 $ 10,957 $ (1,150) $ 13,750 010-10-1900.100000 HEALTH &LIFE INSURANCE $ 47,700 $ 34,485 $ (5,700) $ (5,700) $ 42,000 010-10.1900.230000 CONSULTANT & PROFESSIONAL FEES $ - $ 3,681 $ 3,700 $ 3,700 O10-10.1900.230250 NUISANCES - SNOW REMOVAL $ 1,500 (1,500) $ - 010-10.1900.270000 DATA PROCESSING $ 2,500 $ 5,832 $ 4,500 $ 7,000 010-10.1900.270100 COMPUTER SUPPORT $ 2,400 $ 651 $ (1,500) $ 900 010-10.1900.270110 COPIER/PRINTER LEASE &MAINT $ - $ 1,156 $ 1,400 $ 1,400 O10-10.1900.740000 OFFICE EQUIPMENT $ - $ 17156 1 $ 20,000 EnerGov Installation $ 00,000 $ 20,000 Total Code D pt Proposed Amendment $ 20,000 60 $ 1,000 5 2, 375 $ 2,000 $ 3.000 10.2400.340000 Miscellaneous Contractual Total Animal Control Proposed Amendment t Total Public Safety Program Proposed Amendment $ (41,345) 20,000 $ 142,335 $ 77,600 $ 58,164 $ (7,100) $ (7,100) $ 70,500 010-20,6000,100000 HEALTH &LIFE INSURANCE 010-20.6000.110000 WORKERS COMPENSATION $ 3,500 $ 1,806 $ (1,650) $ (1,650) $ 1,850 010-20.6000.340000 MISCELLANEOUS CONTRACTUAL $ 3,000 $ - $ (3,000) $ - 010-20.6000.570000 FUEL $ 5,000 $ 1,899 $ (2,2% $ 2,750 010-20.6000.691100 PUBLIC WORKS BLDG REIMBURSE $ 10,074 $ - $ (700) $ 9,374 010-20.6000.780000 Total Public STREET SIGNS Works Proposed Amendment $ - $ 26374 $ (8,750)1 $ 26,500 Rebranding S 26,500 5 26,500 r $ 26,5nn $ - $ 5,493 $ 6,600 $ 6,600 010-20.6010.270110 COPIER/PRINTER LEASE&MAINT 010-20.6010,290300 BUILDING& CONTENTS INSURANCE $ 21,000 $ 16,921 $ (4,080) $ 16,920 010-20.6010.340000 MISCELLANEOUS CONTRACTUAL $ 5,000 $ - $ (2,500) $ 2,500 010-20.6010.400100 CUSTODIAL SERVICES $ 16,500 $ 13,075 $ (750) $ 15,750 010-20.6010.410100 REPAIR/MAINTENANCE EQUIPMENT $ 3,000 $ 178 $ (2,000) $ 1,000 010-20.6010.480000 UTILITY SERVICES $ 50,000 $ 29,262 $ (12,500) $ 37,500 010-20.6010.540000 MINOR EQUIPMENT $ - $ 2,124 $ 2,500 $ 2,500 010-20.6010.580000 OFFICE SUPPLIES $ 6,500 $ 7,107 $ 3,000 $ 9,500 010-20.6010.590000 OPERATING SUPPLIES & MATERIALS $ 17,000 $ 11,129 $ (2,000) $ 15,000 010-20.6010.690100 REIMBURSEMENT-PARKS(3%) $ (5,037) $ - $ 350 $ (4,687) 010-20.6010.690200 REIMBURSEMENT-RECREATION(3%) $ (5,037) $ - $ 350 $ (4,687) 010-20.6010,690300 REIMBURSEMENT-ENGINEERING(3%) $ (10,074) $ - $ 700 $ (9,374) 010-20.6010.690400 REIMBURSEMENT PUB WORKS(3%) $ (10,074) $ - $ 700 $ (9,374) 010-20.6010.690500 REIMBURSEMENT-ROADS(19%) $ (31,901) $ - $ 2,232 $ (29,669) 010-20.6010.690600 REIMBURSEMENT-WATER(19%) $ (31,901) $ - $ 2,232 $ (29,669) 010-20.6010.690700 REIMBURSEMENT-SEWER(19%) $ (31,901) $ - $ 2,233 $ (29,668) 010-20.6010.690800 REIMBURSEMENT-GAS(19%) $ (31,901) $ $ 2,233 $ (29,668) 010-20.6010.690900 REIMBURSEMENT -STORM WATER(6%) $ (10,074) $ $ 700 $ (9,374) 010-20.6010.740000 Total Public Works OFFICE EQUIPMENT Building Proposed Amendment $ 10,000 $ $ 1 $ $ (101000) (10,000 $ - $ 111,900 $ 101,006 $ 11,600F123,500010-20.6150.010500 010-20.6150.010000 SALARIES OVERTIME PAY $ 5,000 $ 4,898 $ 900010-20.6150.060000 FICA CONTRIBUTION $ 7,400 $ 6,430 $ 780010-20,6150.070000 MEDICARE CONTRIBUTION $ 1,800 $ 1,504 $ 190010-20.6150.080000 IPERS CONTRIBUTION $ 10,500 $ 9,450 $ 1,150010-20.6150.100000 HEALTH & LIFE INSURANCE $ 27,900 $ 20,715 $ (3,000)010-20.6150.110000 WORKERS COMPENSATION $ 2,200 $ 1,606 $ (590) 010-20.6150.270000 DATA PROCESSING $ 750 $ 910 $ 250 $ 1,000 010-20.6150.410000 REPAIR OF VEHICLES $ 3,500 $ 70 $ (2,750) $ 750 010-20,6150.410100 REPAIR/MAINTENANCE EQUIPMENT $ 60,000 $ 736 $ (56,500) $ 3,500 010-20.6150.450000 TELEPHONE $ 650 $ 1,044 $ 600 $ 1,250 010-20,6150.540000 MINOR EQUIPMENT $ 5,000 $ 8,450 $ 4,500 $ 9,500 010-20.6150.570100 COGS - OIL $ 3,000 $ 3,949 $ 1,500 $ 4,500 010-20.6150.570110 COGS - FILTERS $ 3,000 $ 4,473 $ 2,400 $ 5,400 010-20.6150.570120 COGS -LURE $ 500 $ - $ (500) $ - 010-20.6150.570130 COGS - PARTS $ 60,000 $ 65,320 $ 18,000 $ 78,000 010-20.6150.580000 OFFICE SUPPLIES $ - $ 101 $ 200 $ 200 010-20.6150.590000 OPERATING SUPPLIES & MATERIALS $ 23,000 $ 15,185 $ (3,500) $ 19,500 010-20.6150.690100 REIMBURSEMENT-PARKS(4%) $ (5,672) $ $ 617 $ (5,055)' 010-20.6150.690200 REIMBURSEMENT -RECREATION (4%) $ (5,672) $ - $ 617 $ (5,055) 010-20.6150.690300 REIMBURSEMENT -ENGINEERING (4%) $ (5,672) $ $ 617 $ (5,055) 010-20.6150.690500 REIMBURSEMENT-ROADS(19%) $ (26,942) $ - $ 2,929 $ (24,013) 010-20.6150.690600 REIMBURSEMENT-WATER(19%) $ (26,942) $ - $ 2,929 $ (24,013) 010-20.6150.690700 REIMBURSEMENT-SEWER(19%) $ (26,942) $ - $ 2,930 $ (24,012) 010-20.6150.690800 REIMBURSEMENT-GAS(19%) $ (26,942) $ - $ 2,930 $ (24,012) 010-20.6150.690900 REIMBURSEMENT -STORM WATER(8%) $ (11,344) $ - $ 1,234 $ (10,110) 010-20.6150.691000 REIMBURSEMENT -GOLF COURSE $ (5,672) $ - $ 617 $ (5,055) O10-20.6150.760000 OTHER CAPITAL EQUIPMENT I $ - $ 81812 1 1 IS 10,500 1 $ 10,500 Current Proposed Health/Life/ Other Pre -Approved Changes Admin/Fin Proposed GA Acct M Description Budget YTD Actual LTD/WC Change Change Reason Recommend Budget $ 65,000 $ 28,701 $ (20,000) $ 45,000 010-20.8900.010500 OVERTIME PAY 010-20.8900.060000 FICA CONTRIBUTION $ 15,470 $ 11,100 $ (1,240) $ 14,230 010-20,8900.070000 MEDICARE CONTRIBUTION $ 3,700 $ 2,596 $ (290) $ 3,410 030-20.8900.080000 IPERS CONTRIBUTION $ 22,350 $ 16,093 $ (1,780) $ 20,570 01030.8900.100000 HEALTH & LIFE INSURANCE $ 44,600 $ 34,180 $ (3,100) $ (3,100) $ 41,500 010-20.8900.110000 WORKERS COMPENSATION $ 3,200 $ 1,771 $ (1,430) $ (1,430) $ 1,770 010-20,8900.270100 COMPUTER SUPPORT $ 1,500 $ 1,369 $ 100 $ 1,600 010-20.8900.270110 COPIER/PRINTER LEASE &MAINT $ - $ 1,237 $ 1,500 $ 1,500 010-20.8900,290000 GENERAL LIABILITY INSURANCE $ 1,400 $ 613 $ (780) $ 620 010-20.8900.290100 VEHICLE INSURANCE $ 1,000 $ 725 $ (275) $ 725 010-20.8900.350100 PRINTING $ - S 84 $ 100 $ 100 010-20.8900.360000 POSTAGE & SHIPPING $ - $ 166 $ 250 $ 250 010-20.8900.410000 REPAIR OF VEHICLES $ - $ 250 $ 250 $ 250 010-20.8900,410050 REPAIR/MAINTENANCE WAUKEE MECH $ 6,000 $ 2,125 $ (2,000) $ 4,000 010-20.8900.470000 TRAINING/TRAVEL EXPENSE $ 12,770 $ 3,351 $ (6,270) $ 6,500 010-20.8900.691100 PUBLICWORKS BLDG REIMBURSMNT $ 10,074 $ - S (700) $ 9,374 010-20.8900.691200 MECHANIC REIMBURSEMENT $ 5,672 $ - $ (617) $ 5,055 010-20.8900.710000 AUTOMOTIVE EQUIPMENT 1 $ 32,000 $ 29,750 1 1 1 $ (2250 $ 29,750 $ 62,300 $ 53,083 $ 2,200 $64,500 010-20.8950.010000 SALARIES 010-20.8950.060000 FICA CONTRIBUTION $ 4,700 $ 3,761 $ 140 $ 4,840 010-20.8950.070000 MEDICARE CONTRIBUTION $ 1,100 $ 880 $ 30 $ 1,130 010-20.8950.080000 IPERS CONTRIBUTION $ 6,700 $ 4,780 $ 200 $ 6,900 010-20,8950,270000 DATA PROCESSING $ 800 $ 910 $ 120 $ 920 010-20.8950.270100 COMPUTER SUPPORT $ Soo $ 51 $ (400) $ 100 010-20.8950.290000 GENERAL LIABILITY INSURANCE $ - $ 613 $ 620 $ 620 010-20.8950.410000 REPAIR OF VEHICLES $ - $ 134 $ 150 $ 150 010-20.8950.410200 REPAIR/MAINTENANCE OF ELECTRON $ 7,500 $ - $ (4,500) $ 3,000 010-20.8950.450000 TELEPHONE $ 1,600 $ 852 $ (400) $ 1,200 010-20.8950.570000 FUEL 1 $ 1,500 $ 254 1 1 1 5 1,000 5 500 Total Public Works Program Proposed Amendment $ (13,280) $ 0 $ 4000 $ 3900 $ $ 5 $ 1.500 1,5w $ 5.500 010-30.3600.230800 MOSQUITO SPRAYING Total Mosquito Control Proposed Amendment Health & Social Semites Program Proposed Amendment 1 $ $ $ 115 ITotal $ 280,500 $ 254,906 $ 17,000 $ 297,500 010-40.3100,010000 SALARIES 010-40.3100.011000 PART TIME $ 127,600 $ 72,558 $ (32,600) $ 95,000 010-40.3100.060000 FICA CONTRIBUTION $ 25,500 $ 20,160 $ (970) $ 24,530 010-40.3100.070000 MEDICARE CONTRIBUTION $ 6,000 $ 4,715 $ (230) $ 5,770 01040.3100.080000 IPERS CONTRIBUTION $ 36,700 $ 26,218 $ (1,400) $ 35,300 010-40.3100.100000 HEALTH & LIFE INSURANCE $ 99,200 $ 57,769 S (26,200) $ (26,200) $ 73,000 010-40.3100.230000 CONSULTANT& PROFESSIONAL FEES $ - $ 3,015 $ 3,500 $ 3,500 010-40.3100.270000 DATA PROCESSING $ 14,000 $ 11,785 $ (1,500) $ 12,500 010-40.3100.270100 COMPUTER SUPPORT $ 3,500 $ 1,673 $ (1,400) $ 2,100 010-40.3100.270110 COPIER / PRINTER LEASE & MAINT $ - $ 2,281 $ 2,750 $ 2,750 010-40.3100.290300 BUILDING & CONTENTS INSURANCE $ 7,000 $ 12,266 $ 5,300 $ 12,300 010-40.3100.480000 UTILITY SERVICES 1 $ 45,000 $ 27,205 1 1 1 $ (7,000) $ 38,000 $ 44,200 $ 22,969 $ (15,200) $ (15,200) $ 29,000 010-40.4100.100000 HEALTH &LIFE INSURANCE 010-40.4100.230000 CONSULTANT& PROFESSIONAL FEES $ 10,000 $ 31,986 $ 25,000 $ 35,000 010-40.4100.290100 VEHICLE INSURANCE $ 1,000 $ 1,427 $ 500 $ 1,500 010-40.4100.290300 BUILDING& CONTENTS INSURANCE $ - $ 3,550 $ 3,600 $ 3,600 010-40.4100.340000 MISCELLANEOUS CONTRACTUAL $ 2,000 $ 13,905 $ 12,000 $ 14,000 010-40.4100,350100 PRINTING $ 250 $ 772 $ 5SO $ 800 010-40.4100.360000 POSTAGE&SHIPPING $ 250 $ 422 $ 200 $ 450 010-40.4100.410050 REPAIR/MAINT- WAUKEE MECHANIC $ 17,000 $ 11,280 $ (3,500) $ 13,500 010-40.4100.410100 REPAIR/MAINTENANCE OF EQUIPMEN $ 2,000 $ 8,836 $ 7,500 $ 9,500 010-40.4100.450000 TELEPHONE $ 1,000 $ 1,376 $ 500 $ 1,500 010-40.4100.461300 CHRISTMAS DECORATIONS $ 8,000 $ 11,821 $ 3,850 $ 11,850 010-40.4100.470000 TRAINING/TRAVEL EXPENSE $ 2,000 $ 2,545 $ 800 $ 2,800 010-40.4100.480000 UTILITY SERVICES $ 22,000 $ 11,903 $ (6,000) $ 16,000 010-40.4100.480100 UTILITIES -PARK IRRIGATION $ 1,500 $ 5,350 $ 4,500 $ 6,000 010-40.4100.570000 FUEL $ 25,000 $ 7,954 $ (12,500) $ 12,500 010-40.4100.590000 OFFICE SUPPLIES $ - $ 142 $ 200 $ 200 010-40.4100,590000 OPERATING SUPPLIES & MATERIALS $ 6,000 $ 6,409 $ 1,800 $ 7,800 010-40.4100.691100 PUBLIC WORKS BLDG REIMBURSMNT $ 5,037 $ - $ (350) $ 4,687 010-40,4100.691200 MECHANIC REIMBURSEMENT $ 5,672 $ - $ (617) $ 5,055 010-40.4100.760000 OTHER CAPITAL EQUIPMENT $ - $ 6,364 $ 6,400 $ 6,400 010-40.4100.760200 PROJECTS WITH DEVELOPERS FEES $ - $ 29,960 $ 30,000 $ 30,000 010-40.4100.882110 RIDGE POINT PARK IMPROVEMENTS 1 $ - $ (12,000) $ (12,000) $ (12,000) Current Proposed Pre -Approved Changes Admin/Fin Proposed G/LAcct# Descri tion Bud et YTD Actual Chan a Reason Recommend Bud et $ 192,500 $ 164,431 lHealth/Life/Other $ 7,000 $ 199,500 010-40.4200.010000 SALARIES 010-40.4200.060000 FICA CONTRIBUTION $ 14,100 $ 10,969 $ 450 $ 14,550 010-40.4200.070000 MEDICARE CONTRIBUTION $ 3,300 $ 2,565 $ 100 $ 3,400 010-40.4200.080000 IPERS CONTRIBUTION $ 20,200 $ 15,958 $ 650 $ 20,850 010-40.4200.100000 HEALTH & LIFE INSURANCE $ 47,700 $ 35,630 $ (4,700) $ 43,000 010-40.4200.110000 WORKERS COMPENSATION $ 1,350 $ 1,835 $ 500 $ 1,850 010-40.4200.210000 PUBLIC NOTIFICATION/ADVERTISIN $ 1,000 $ - $ (S00) $ Soo 010-40.4200.270110 COPIER/PRINTER LEASE &MAINT $ - $ 1,110 $ 1,350 $ 1,350 010-40.4200.350100 PRINTING $ 10,000 $ 13,111 $ 3,150 $ 13,150 010-40,4200.410050 REPAIR/MAINTENANCE WAUKEE MECH $ Soo $ 730 $ 1,000 $ 1,500 010-40.4200.460500 SUMMER RECREATION PROGRAMS $ 12,500 $ 15,326 $ 6,000 $ 18,500 010-40.4200.460510 YOUTH SPORTS LEAGUES $ 11,000 $ 11,651 $ 2,500 $ 13,500 01040.4200.460550 WINTER RECREATION PROGRAMS $ 4,500 $ 6,528 $ 2,050 $ 6,550 010-40.4200.460650 BIKE FEST EXPENSES $ 10,000 $ 1,470 $ (4,000) $ 6,000 010-40.4200,460900 FALL FESTIVAL $ 15,000 $ 13,378 $ 10,000 $ 25,000 010-40.4200.470000 TRAINING/TRAVEL EXPENSES $ 5,400 $ 1,274 $ (2,900) $ 2,500 010-40.4200.540000 MINOR EQUIPMENT $ 2,600 $ 528 $ (1,100) $ 1,500 010-40.4200.570000 FUEL $ 3,500 $ 1,291 $ (1,750) $ 1,750 010-40.4200.590000 OPERATING SUPPLIES & MATERIALS $ 1,000 $ 46 $ (500) $ 500 010-40.4200.691100 PUBLIC WORKS BLDG REIMBURSMNT $ 5,037 $ - $ (350) $ 4,687 010-40.4202.691200 Total MECHANIC REIMBURSEMENT 5A72 $ $ (617) $ 5,055 $ 1,000 $ 613 $ (380) $ 620 010-40.4300.290000 GENERAL LIABILITY INSURANCE 010-40.4300.290300 BUILDING& CONTENTS INSURANCE $ 1,500 $ 962 $ (530) $ 970 010-40.4300.400000 REPAIR/MAINTENANCE OF BUILDING $ 1,000 $ 2,213 $ 1,950 $ 2,950 010-40.4300.400100 CUSTODIAL SERVICES $ 4,500 $ 3,160 $ (700) $ 3,800 010-40.4300.410100 REPAIR/MAINTENANCE OF EQUIPMEN $ 500 $ 1,466 $ 1,000 $ 1,500 010-40.4300.420000 REPAIR/MAINT - VFW HALL BLDG $ - $ 8,408 $ 8,410 $ 8,410 010-40.4300.450000 TELEPHONE $ 500 $ - $ (500) $ - 010-40.4300.480000 UTILITY SERVICES $ 7,500 $ 4,927 $ (1,300) $ 6,200 010-40.4300.590000 OPERATING SUPPLIES & MATERIALS $ 1500 $ 559 $ 750)1 $ 750 Total Community Center Proposed Amendment $ $ $- 7,200 Total Culture & Recreation Program Proposed Amendment $ (45,600) $ $ 30,016 $ - $ $ - $ 010-50.6500.340000 MISCELLANEOUS CONTRACTUAL Total Median Maintenance Proposed Amendment $ 36,600 $ 26,340 $ $ (4,100) $ S $ (4,100) $ 32,500 010-50.8500. 100000 HEALTH &LIFE INSURANCE 010-50,8500.230000 CONSULTANT& PROFESSIONAL FEES $ 5,000 $ 61,022 $ 70,000 $ 75,000 010-50.8500.270000 DATA PROCESSING $ 800 $ 910 $ 150 $ 950 010-50.8500.270110 COPIER/PRINTER LEASE &MAINT $ - $ 1,115 $ 1,400 $ 1,400 010-50.8500.450000 TELEPHONE $ 800 $ 1,209 $ 650 $ 1,450 010-50.8500.580000 Total Community OFFICE SUPPLIES Development Proposed Amendment $ 1,000 $ 78 $ A20111) $ (600) $ 67,500 $ 400 $ 234,800 $ 181,503 $ (17,300) $ 217,500 010-50,8700.010000 SALARIES 010-50.8700.010500 OVERTIME PAY $ 7,500 $ 1,822 $ (4,000) $ 3,500 010-50.8700.060000 FICA CONTRIBUTION $ 15,100 $ 11,126 $ (1,320) $ 13,780 010-50.8700.070000 MEDICARE CONTRIBUTION $ 3,600 $ 2,602 $ (300) $ 3,300 010-50.8700.080000 IPERS CONTRIBUTION $ 21,700 $ 16,518 $ (1,900) $ 19,800 010-50.8700.100000 HEALTH & LIFE INSURANCE $ 35,500 $ 35,762 $ 8,000 $ 8,000 $ 43,500 010-50.8700.270000 DATA PROCESSING $ 850 $ 910 $ 150 $ 1,000 010-50.8700.270100 COMPUTERSUPPORT $ 1,350 $ 840 $ (200) $ 1,150 010-50.8700.270110 COPIER/PRINTER LEASE &MAINT $ - $ 1,094 $ 1,350 $ 1,350 010-50.8700.360000 POSTAGE & SHIPPING $ 900 $ 100 $ (700) $ 200 010-50.8700.450000 TELEPHONE $ 1,600 $ 1,696 $ 500 $ 2,100 010-50.8700.580000 Total Planning OFFICE SUPPLIES Proposed Amendment $ 3,000 $ 134 1 $ 8,000 1 (1,150)1 1 MERU= $ 1,850 Total Community & Economic Development Program Proposed Amendment $ 3,900 $ 50,680 $ - $ 114 $ 320 $ 320 010-60.8100.060000 FICA CONTRI BUTION 010-60.8100.080000 IPERS CONTRIBUTION $ 2,850 $ 2,044 010-60,8100.470000 Total Mayor TRAINING/TRAVEL EXPENSE & Council Proposed Amendment $ 21,000 $ 10.946 $ $ $ 8000 $ 8101 $ 1 $ $ 100 100 $ 8,100 010-60.8110.231600 ELECTION EXPENSE Total Elections Proposed Amendment -1$ Current Proposed Health/Life/ Other Pre -Approved Changes Admin/Fin Proposed GA Aoct # Descri tion Budget YTD Actual LTD/WC Change Change Reason Recommend Budget O10-60.8200.010000 SALARIES $ 73,500 $ 53,615 $ (7,500) 66000 010-60.8200.060000 FICA CONTRIBUTION $ 4,600 $ 3,027 $ (460) 4140 010-60.8200.070000 MEDICARE CONTRIBUTION $ 1,100 $ 708 $ (100) 1000 010-60.8200.080000 IPERS CONTRIBUTION $ 6,600 $ 4,788 $ (670) 5930 010-60.8200.100000 HEALTH &LIFE INSURANCE $ 20,000 $ 14,840 $ (2,000) $ (2,000) 18000 010-60.8200.210000 PUBLIC NOTIFICATION/ADVERTISIN $ 30,000 $ 5,180 $ (10,000) 20000 010-60.8200.230010 WEBSITE DEVELOPMENT/MAINTENANC $ 12,000 $ 13,805 $ 3,000 15000 010-60.8200.270100 COMPUTER SUPPORT $ 2,000 $ 150 $ (1,500) 500 010-60.8200.290000 GENERAL LIABILITY INSURANCE $ - $ 613 $ 615 615 010-60.8200.350100 PRINTING SERVICES $ 5,000 $ 1,204 $ (2,500) 2500 010-60.8200.350110 PHOTOGRAPHY &VIDEO SERVICES $ 2,000 $ 763 $ (800) 1200 010-60.8200.360000 POSTAGE & SHIPPING $ 2,000 $ - $ (2,000) 0 010-60.8200,450000 TELEPHONE $ - $ 405 $ 500 500 010-60.8200.461200 NEWSLETTER $ - $ 1,437 $ 9,500 9500 010-60.8200.47000D TRAINING/TRAVEL EXPENSE $ 2,500 $ 1,064 $ (1,000) 1500 010-60.8200.540000 MINOR EQUIPMENT $ 1,000 $ 3,492 $ 2,500 3500 010-60.8200.590000 OFFICE SUPPLIES $ 500 $ 666 $ 400 900 010-60.8200.590000 OPERATING SUPPLIES &MATERIALS $ 500 $ 16 1 1 (450) 50 Total Communications Proposed Amendment (2,000� $ 224,600 $ 183,399 $ (2,600) $ 222,000 010-60.8300.010000 SALARIES 010-60,8300,011000 PARTTIME $ 3,000 $ 840 $ (1,800) $ 1,200 010-60.8300.060000 FICA CONTRIBUTION $ 15,100 $ 9,647 $ (270) $ 14,830 010-60,8300.070000 MEDICARE CONTRIBUTION $ 3,520 $ 2,816 $ (60) $ 3,460 010-60.8300.080000 IPERS CONTRIBUTION $ 21,700 $ 17,102 $ (390) $ 21,310 010-60.8300.090000 CITY SHARE ICMA $ 4,000 $ 2,616 $ (800) $ 3,200 010-60.8300.100000 HEALTH & LIFE INSURANCE $ 37,400 $ 28,117 $ (3,400) $ (3,400) $ 34,000 010-60.8300.210000 PUBLIC NOTIFICATION/ADVERTISIN $ 15,000 $ 8,271 $ (2,000) $ 13,000 010-60.8300.210100 PROMOTION/CIITIZEN SURVEY $ - $ 14,811 $ 15,000 Rebranding $ 15,000 $ 15,000 O10-60.8300.270000 DATA PROCESSING $ 8,000 $ 9,377 $ 3,250 $ 11,250 010-60.8300.27010D COMPUTER SUPPORT $ 45,000 $ 23,595 $ (15,000) $ 30,000 010-60.8300.270110 COPIER/ PRINTER LEASE& MAINT $ - $ 1,170 $ 1,500 $ 1,500 010-60.8300.280000 DUES, MEMBERSHIPS & SUBSCRIPTI $ 13,500 $ 8,559 $ (4,500) $ 9,000 010-60.8300.350100 PRINTING $ 1,200 $ 2,605 $ 1,450 $ 2,650 010-60.8300.390400 NORTHVIEW RENTAL PROP EXPENSES $ 7,000 $ 5,811 $ (1,150) $ 5,850 010-60.8300.450000 TELEPHONE $ 1,500 $ 7,975 $ 8,200 $ 9,700 010-60.8300.459000 CONTRIBUTIONS $ 9,000 $ 5,000 $ (4,000) $ 5,000 010-60.8300.470000 TRAINING/TRAVEL EXPENSE $ 18,000 $ 5,277 $ (10,500) $ 7,510 010-60.8300.540000 MINOR EQUIPMENT $ 7,000 $ 1,012 $ (4,500) $ 2,500 010-60.8300.740050 Total Administration COMPUTER/SERVER EQUIP&SOFTWR Proposed Amendment 1 $ - $ 791, 1 1 $ 13,400) $ 30,000 $ 8,430 $ 30,000 $ - $ 2,287 $ 2,750 $ 2,750 010-60.8310.270110 COPIER/PRINTER LEASE&MAINT 010-60.8310.290300 BUILDING&CONTENTS INSURANCE $ 11,000 $ 8,631 $ (2,360) $ 8,640 O10-60.8310.390500 PROPERTY TAX EXPENSE $ 7,500 $ 4,828 $ (2,670) $ 4,830 010-60.8310.410100 REPAIR/MAINTENANCE OF EQUIPMEN $ 2,500 $ 3,727 $ 2,000 $ 4,500 010-60.8310.480000 UTILITY SERVICES $ 10,000 $ 6,583 $ (1,000) $ 9,000 010-60,8310.590000 OPERATING SUPPLIES & MATERIALS $ 9,000 $ 2,287 $ (4,000) $ 5,000 010-60.8310.832000 PROFESSIONAL PLAZA BUILDING $ - $ 3590 Rebrand/Sin $ 3,600 :r $ 3,600 $ 86,600 $ 72,302 $ 1,400 $ 88,000 010-60.8350.010000 SALARIES 010-60.9350.011000 PARTTIME $ - $ 16,789 $ 24,000 $ 24,000 010-60,8350.060000 FICA CONTRIBUTION $ 5,400 $ 5,604 $ 1,580 $ 6,980 010-60.8350.070000. MEDICARE CONTRIBUTION $ 1,300 $ 1,311 $ 370 $ 1,670 010-60,8350.080000 I PERS CONTRIBUTION $ 7,800 $ 8,072 $ 2,270 $ 10,070 010-60.8350.100000 HEALTH & LIFE INSURANCE $ 20,100 $ 5,838 $ (12,600) $ (12,600) $ 7,500 010-60,8350.210000 PUBLIC NOTIFICATION/ADVERTISE $ - $ 352 $ 350 $ 350 010-60.9350.230000 CONSULTANT& PROFESSIONAL FEES $ 1,000 $ 10,156 $ 9,200 $ 10,200 010-60,8350.270000 DATA PROCESSING $ 800 $ 5,405 $ 4,950 $ 5,750 010-60.8350.270100 COMPUTER SUPPORT $ 1,000 $ 125 $ (800) $ 200 010-60.8350.270110 COPIER/PRINTER LEASE &MAINT $ - $ 2,455 $ 3,000 $ 3,000 010-60.8350.280000 DUES, MEMBERSHIPS & SUBSCRIPT $ 500 $ 620 $ 120 $ 620 010-60.8350.450000 TELEPHONE $ 540 $ 669 $ 310 $ 850 010-60.8350.580000 OFFICE SUPPLIES $ 500 $ 529 $ 150 $ IS0 O10-60.8350.689000 EMPLOYEE APPRECIATION $ 4,750 $ 3,785 $ (9fi0) $ 3,790 Total Human Resources Proposed Amendment $ 147,500 $ 124,701 $ Ir t $ 13,000 $ 160,500 010-60.8400.010000 SALARIES 010-60.8400.010500 OVERTIME PAY $ 1,000 $ - $ (1,000) $ 010-60.8400.011000 PARTTIME $ 78,500 $ 22,741 $ (42,500) $ 36,000 010-60.8400.060000 FICA CONTRIBUTION $ 14,100 $ 8,952 $ (1,890) $ 12,210 010-60.8400.070000 MEDICARE CONTRIBUTION $ 3,400 $ 2,093 $ (4,10) $ 2,960 010-60.8400.080000 IPERS CONTRIBUTION $ 20,300 $ 13,183 $ (2,720) $ 17,580 010-60.8400.100000 HEALTH & LIFE INSURANCE $ 40,100 $ 29,787 $ (2,600) $ (2,600) $ 37,500 010-60.8400.102000 SECTION 125 FLEX BENEFIT $ 500 $ 500 $ 175 $ 675 010-60.8400.110000 WORKERS COMPENSATION $ 350 $ 175 $ (170) $ (170) $ 180 G/L Acct If Description Current Proposed Budget 1TD Actual Health/Life/ LTD/WC Change Other Pre -Approved Changes Change Reason Admin/Fin Recommend Proposed Budget 010-60.8400.230000 010-60.8400.270000 0.8400.270110 0.8400.390000 0.8400.470000 E0.8400.740101 CONSULTANT& PROFESSIONAL FEES DATA PROCESSING COPIER/PRINTER LEASE&MAINT RENTAL/LEASE OF EQUIPMENT TRAINING/TRAVEL EXPENSE COMPUTER SOFTWARE/EQUIPMENT $ $ $ $ $ $ 4,000 2,500 - 2,000 8,500 100000 $ $ $ $ $ $ 29,127 10,467 3,336 3,254 2,338 29346 82449 Contract Labor Incode V.X $ 26,000 $ 9,500 $ 4,000 $ 1,750 $ J4,000) $ 30,000 $ 30,000 $ 12,000 $ 4,000 $ 3,750 $ 4,500 $ 30,000 $ 80,000 $ 20,000) O10-60.8600.230000 CONSULTANT& PROFESSIONAL FEES Total TZI General City Attorney Government Proposed Amendment Program Proposed Amendment $ $ 20,000 - $ $ - - $ 25,000 $ 5,000 010-60.8400.970100 Transfer To Commerce Bank Reserve 59.000.6,97080 Transfer To GO Debt Service Other Funds - FY2016 Proposed Revenue Budget Amendment YTD.Inc/Dec Amended . -Budget �Propertv Taxes $ !Licenses. Permits. Fees i ,Use of Money & Property 7 $-- - ilntereovernmental $ Charees For Services Miscellaneous 1$ ,Other Financing Sources Transfer In-Finance/Comm Bank Equip Revolve • 20,000 000 rrr �810-50.8400.3988400 S 5,000 Total Proposed Other Funds Revenue Changes $ 5,000 ProposedOther Funds - FY2016 .•Budget Current Proposed Amended G/L Acct# Description Fund Budget YTD Actual Inc/Dec Budget Road Use Tax Fund $ - $ - $ - $ - 093-30.7850.210250 Economic Develop Grant Expense TIF Fund $ - $ 9,000 $ 9,000 $ 9,000 093-30.7850.210900 Developer Rebate - Knapp TIF Fund $ 160,000 $ 462,529 $ 302,550 i $ 462,550 110-30.7800.914621 GO 15C Corp Purpose Principal Debt Service Fund $ - $ 740,000 $ 740,000 $ 740,000 110-30.7800.924621 GO 15C Corp Purpose Interest Debt Service Fund $ - $ 116,000 $ 116,000 $ 116,000 oil Capital Projects $ - $ - $ - $ - Water Fund $ - $ - $ - $ - Water Fund Total Sewer Fund $ - $ - $ - $ - Sewer Fund Total Gas Fund $ - $ - $ - $ - Gas Fund Total Storm Water Fund $ - $ - $ - $ - Storm Water Fund Total Utility Billing Fund $ - $ - $ - $ - Utility Billing Fund Total Solid Waste Fund $ - $ - $ - $ - Solid Waste Fund Total Golf Course Fund $ - $ - $ - $ - Golf Course Fund Total $ $ - $ $ r