The URL can be used to link to this page

Fiscal Year 2017 First Budget Amendment Copyright 2014 City of Dubuque Public Hearings # 6. ITEM TITLE: Fiscal Year 2017 First Budget Amendment SUMMARY: Proof of publication on notice of public hearing to consider approval of the first Fiscal Year 2017 Budget Amendment, which amends the Fiscal Year 2017 budget for City Council actions since the beginning of the fiscal year. RESOLUTION Amending the Current Budget for the Fiscal Year Ending June 30, 2017 SUGGESTED DISPOSITION: Suggested Disposition: Receive and File; Adopt Resolution(s) ATTACHMENTS: Description Type MVM Memo City Manager Memo Staff Memo Staff Memo Council Detail Supporting Documentation Resolution Resolutions Proof of Publication Supporting Documentation THE CITY OF Dubuque UBE I erica .i Masterpiece on the Mississippi 2007-2012-2013 TO: The Honorable Mayor and City Council Members FROM: Michael C. Van Milligen, City Manager SUBJECT: Fiscal Year 2017 First Budget Amendment DATE: September 15, 2016 Budget Director Jennifer Larson is recommending approval of the first Fiscal Year 2017 Budget Amendment, which amends the Fiscal Year 2017 budget for City Council actions since the beginning of the fiscal year and includes items which City Council has expressed support. Second, the amendment includes Fiscal Year 2016 budget carryovers to Fiscal Year 2017 of encumbrances totaling $35,793,871, capital projects totaling $51,588,789 that were not completed during the prior Fiscal Year, and associated revenues totaling $41,273,732. There are operating budget appropriation carryovers of$2,172,862 and operating receivables of $2,103,595. Also, total transfers between funds of$2,839,761 are reflected. Part of the amendment relates to the amount of the City general fund reserve. The City maintains a general fund reserve, or working balance, to allow for unforeseen expenses that may occur. The Fiscal Year 2016 budget recommendation anticipated an additional contribution to the general fund reserve of $608,480. The actual fiscal results of 2016 has allowed for another $391,520 in addition to the $608,480 to be added to the general fund reserve to reach a one million dollar contribution. This is possible from revenues performing better than expected and operating expense savings in departments. The estimated unrestricted General Fund Reserve balance as of June 301 2016 will now be $8,720,163 on an accrual basis, which is estimated to be 15.95% of general fund revenues. These balances will be refined when the June 30, 2016 audited Certified Annual Financial Report is completed in December 2016. Moody's Investor Service recommends a factor of 20 percent for "AX rated cities and the City continues to work towards that number. The level of contribution approved in the Fiscal Year 2017 budget process was $3.2 million (41 .5%) increase over the next six years to a total of$10,924,931 in Fiscal year 2021 : FY2016 FY2017 FY2018 FY2019 FY2020 FY2021 Contribution $608,480 $596,288 $500,000 $500,000 $500,000 $500,000 City's Spendable General Fund Cash $8,328,643 $8,924,931 $9,424,931 $9,924,931 $10,424,931 $10,924,931 Reserve Fund Balance The level of contribution will now be $3.6 million (46.6%) increase over the next six years to a total of$11 ,316,451 in Fiscal Year 2021 : FY2016 FY2017 FY2018 FY2019 FY2020 FY2021 Contribution $1,000,000 $596,288 $500,000 $500,000 $500,000 $500,000 City's Spendable General Fund Cash $8,720,163 $9,316,451 $9,816,451 $10,316,451 $10,816,451 $11,316,451 Reserve Fund Balance It was previously anticipated that the City would reach 20% general fund reserve in Fiscal Year 2022. It is now projected that the City will reach the 20% general fund reserve in Fiscal Year 2021 . I concur with the recommendation and respectfully request Mayor and City Council approval. /ems Michael C. Van Milligen MCVM/jml Attachment cc: Barry Lindahl, City Attorney Cindy Steinhauser, Assistant City Manager Teri Goodmann, Assistant City Manager Jennifer Larson, Budget Director 2 THE CITY OF Dubuque U� TE 111 111 I.-America Ci i Masterpiece on the Mississippi 2007-2012-2013 TO: Michael C. Van Milligen, City Manager FROM: Jennifer Larson, Budget Director SUBJECT: Fiscal Year 2017 First Budget Amendment DATE: September 15, 2016 The purpose of this memorandum is to provide an explanation regarding the first amendment for Fiscal Year 2017. This amendment is twofold. First, it amends the Fiscal Year 2017 budget for City Council actions since the beginning of the Fiscal Year and includes items which City Council has expressed support. Second, the amendment includes Fiscal Year 2016 budget carryovers to Fiscal Year 2017 of encumbrances totaling $35,793,871, capital projects totaling $51,588,789 that were not completed during the prior Fiscal Year, and associated revenues totaling $41,273,732. There are operating budget appropriation carryovers of $2,172,862 and operating receivables of $2,103,595. Also, total transfers between funds of $2,839,761 are reflected. During Fiscal Year 2016, a large number of projects were completed. These projects include the following: Five Flags Renovate Employee Area Police In-Car Video Recorders Five Flags Theatre Air Conditioning E911 Emergency Dispatch Protocols Grand River Center Network Upgrade Fire Improvement to Fire Headquarters Grand River Center Custodial Equipment Fire Outdoor Siren Grand River Center Kitchen Equipment Fire Station#2 Improvements Bunker Irrigation Project Phase 2 Fire Station#3 Kitchen Remodel Pool Security Cameras Comiskey Replace Exterior Door Pool Internet Access Veterans Park Storage Building Library New Front Doors Grand River Center Plasma Screens Library Switch EB Lyons Expansion Airport Water Extension Ham House Repairs Water North Softening Basin Renovation Eagle Point Park Paint Bridge Retro Clean Diesel Project Eagle Point Park— Overlay Lot Tennis Ct Purchase Key West Water/Sanitary Miller Riverview Pave Lowell Street Water/Sanitary All Parks Security Lights Airport SCADA System Parks Parking Lot Striping W&RRC Concrete Pad Gas Cond. Hilltop Park Parking Sealcoating Lots Park Electrical Panel Replacement Intermodal Facility Parking Meter Replacement Engineering Harbor Area Maintenance Elm Street Parking Lot Reconstruction JFK/Wacker Signals Airport New Terminal Pavement Marking Annual Program Airport Runway Painting Portable Radar Speed Sign Airport HVAC Joint Use Building Airport Sanitary Extension Airport Administrative Offices Asbury Road Grinding Airport FBO Hangar Security Door Airport Fiber Optics Transit Security Cameras Grandview/Delhi Roundabout Public Works End loader Replacement Building Permit Tracking Software Public Works Dump Truck Replacement Street Light Audit Public Works New Concept Snow Plows Industrial Park Land Acquisitions Public Works LED Lighting 10G Backbone Upgrade Public Works Radio Replacement Data Mining/Open Data Landfill Cell #9 Phase 2 City-Wide Multifunction Replacement Engineering Sidewalk Program City Owned City-Wide Computer Replacements Engineering Steps Railing and Fencing Many other enhancements are reflected throughout the community. CARRYOVER AMENDMENT TO FISCAL YEAR 2016 CAPITAL BUDGET CARRYOVER AMENDMENT Some significant projects were started and remain in process, which are carried forward into Fiscal Year 2017. The most significant of the capital project expenditure carryovers, including associated revenue, are: Southwest Arterial ($4,328,474) Sponsorship Green Alleys ($656,389) Terminal Runway 31 Parallel ($3,429,872) Washington Recon 81h to 91h ($639,363) New Terminal Roads and Apron ($3,179,975) Airport Onsite Water ($498,288) New Terminal Taxiway F ($2,982,375) Water Main Ext ($464,892) Bee Branch Gate Replacement ($1 ,980,730) Flood Control Maint. Facility ($451 ,524) Bee Branch ($1 ,845,468) Granger Creek Sanitary ($445,606) Catfish Creek Watershed ($700,000) Homeownership Grants ($441 ,428) New Terminal Parking 1&2 ($1 ,739,864) Skate Park ($782,735) Millwork District Parking ($1 ,641 ,531) HOME Program ($439,956) Multicultural Family Center ($1 ,337,635) IFA Housing Trust ($401 ,900) Airport Terminal Construction ($1 ,207,764) Washington Neighborhood ($397,403) North Cascade Road ($1 ,851 ,348) Five Flags Arena Roof ($384,227) Corridor Study Alternates ($1 ,000,000) Curb Ramp Program ($352,207) Roosevelt Road Main Ext ($815,165) Residential Rehab ($342,376) SW Arterial Water Main ($783,351) SRF Green Alley ($318,846) - 2 - OPERATING BUDGET CARRYOVER AMENDMENT The most significant operating budget carryovers into Fiscal Year 2016 include such items as: Asphalt Program ($309,301) Park Downtown Maint Vehicle ($27,000) Water Internal Line Loans ($205,000) Park Maintenance Mower ($25,000) Forestry Aerial Truck ($187,250) Water Meter Testing ($25,000) Stormwater I&I Prevention ($160,534) Airport Tower Maintenance ($25,000) Water Main Replace ($113,044) Transit Vehicle Replace ($22,500) Water Leak Survey ($69,950) Sustainability Community Grants ($22,090) Park Maintenance ($68,413) Traffic Engineering Consulting ($21 ,728) Floodwall Breach Analysis ($67,913) Storm Sewer Cleaning ($21 ,096) Police ICE Enforcement ($61 ,939) Grand River Center Maint. ($21 ,062) Police JAG Grant Video Equip ($61 ,230) Police Unclaimed Property ($20,900) Water Usage & System Audit ($50,322) Detention Basin Maintenance ($20,175) Stormwater NPDES Programs ($47,219) Streambank Rehab ($18,220) HOME Program Grants ($47,093) Circles Program Donations ($18,040) AmeriCorps Local Match ($29,794) Third Grade Level Reading ($16,020) Garage Vehicle Hoist ($29,000) Water Storage Tank Inspect ($15,000) Stormwater Ditch Remediation ($28,791) Water Service Line Assist ($15,000) Fair Housing Grant Funds ($28,763) Water Online Processor ($14,547) FIRST AMENDMENT TO THE FISCAL YEAR 2017 CERTIFIED BUDGET There have been numerous actions by City Council and changes requiring amendments for the Fiscal Year 2017 budget. CAPITAL BUDGET AMENDMENT The capital budget amendments total a decrease of$11 ,774,505, with an increase in associated revenue of$1 ,033,726. The capital amendment items include a decrease of $9,785,850 to the Bee Branch Project due to moving a portion of the project related to the Railroad to Fiscal Year 2018 and a decrease of$1 ,944,500 due to pre-spending the Fiscal Year 2017 budget; decrease of$100,000 to the CDBG Residential Rehab program due to shifting funds to Purchase/Rehab/Resale; decrease of$53,342 to the Library Renovation project due to the project being complete and offsetting the balance remaining in the project to the receivable from the Heade painting sale; decrease of$55,044 in Stormwater maintenance projects due to eliminating encumbrances and moving the capital budget to the operating budget; and decrease of$120,427 to a combination of Pavement Markings, Traffic Signal Masterarm, Traffic Controller Battery Pack and Kerper Sanitary Sewer due to pre- spending the Fiscal Year 2017 budget. The capital amendment items include an increase of$108,695 for CDBG Purchase/Rehab/Resale and an increase of$175,963 for capital costs associated with the new Lead Hazard Control and Healthy Homes grant. - 3 - OPERATING BUDGET AMENDMENT The operating budget amendments total an increase of$68,467, with an increase in associated revenue of$84,992. The operating amendment items include a decrease of $13,294 for CDBG funded programs related to eliminating encumbrances that were not closed out prior to year-end; a decrease of$360 for Engineering regular cell phones that were replaced with smart phones during the budget process; and a decrease of$4,111 to the NPDES Erosion control program due to pre-spending the Fiscal Year 2017 budget. The operating amendment items include an increase of$49,607 for the new Lead Hazard Control and Healthy Homes grant to adjust employee expense to actual cost; $20,405 for the purchase of software for document writing for Budget; $9,600 for picnic tables in Jackson Park that were approved during the Fiscal Year 2017 budget process; $5,161 for the purchase of replacements from lost Library books fines; $850 for Home Workshops funded by registration fees from Fiscal Year 2016; and $400 for electricity expense related to the West 3rd ICN lease site. In addition, the City maintains a general fund reserve, or working balance, to allow for unforeseen expenses that may occur. The Fiscal Year 2016 budget recommendation anticipated an additional contribution to the general fund reserve of$608,480. The actual fiscal results of 2016 has allowed for another $391 ,520 in addition to the $608,480 to be added to the general fund reserve to reach a one million dollar contribution. This is possible from revenues performing better than expected in riverfront leases, DRA distribution, local option sales tax and ambulance fees and operating expense savings in departments. The estimated unrestricted General Fund Reserve balance as of June 30, 2016 will now be $8,720,163 on an accrual basis, which is estimated to be 15.95% of general fund revenues. These balances will be refined when the June 30, 2016 audited Certified Annual Financial Report is completed in December 2016. Moody's Investor Service recommends a factor of 20 percent for "AA" rated cities and the City continues to work towards that number. The action step is for City Council to adopt the attached resolution approving the FY 2017 first budget amendment. Attachments JML - 4 - FISCAL YEAR 2017 AMENDMENT#1 CIN COUNCIL 29-Aug-16 FY 17 FY 17 Expense Revenue Department Program Description Amount Amount Fund Activity/CIP Account Explanation GENERALFUND Police Department 1C Restore Police Car-Motor Vehicle Maintenance 4,373 100 1002280 62528 C/O Police Department 10 Community Orientated Police- Phones 2,267 100 10011500 72418 C/O Police Department 10 Patrol-Weapons 5,439 100 10011700 72211 C/O Police Department 10 Patrol-Alarm Billings 2,360 100 10011700 51215 C/O Police Department 10 Patrol-Equipment 250 100 10011700 72218 C/O Police Department 10 DARE- Private Participant 1,000 100 10011180 53102 C/O Police Department 10 ICE Enforcement- Equipment 43,057 100 10011600 72218 C/O Police Department 10 ICE Enforcement- Equipment 7,549 100 10011600 72218 C/O Police Department 10 ICE Enforcement- Equipment 11 100 10011600 72218 C/O Police Department 10 ICE Enforcement- Equipment 11,322 100 10011600 72218 C/O Police Department 10 Staff Services- Equipment 20,900 100 10011600 72218 C/O Police Department 10 JAG Grant-Video Equipment 61,230 100 10011752 72416 C/O Police Department 10 FY15 JAG Grant-Seasonal Employee 8,360 100 10011776 61030 C/O Police Department 10 FY15 JAG Grant- Reimbursable OT 6,505 100 10011776 61051 C/O Police Department 10 FY15 JAG Grant-Social Security 640 100 10011776 61320 C/O Police Department 10 GTSB Grant- Reimbursable OT 5,303 100 10011772 61051 C/O Police Department 10 GTSB Grant-Child Restraint System 1,900 100 10011772 72218 C/O Police Department 10 GTSB Grant-Grant 4,045 100 10011772 45771 C/O Human Rights 30 Human Rights- Dues&Memberships 902 100 10016100 62190 C/O Human Rights 30 Human Rights-Speakers/Programs(City Life) 2,000 100 10016100 62734 C/O Human Rights 30 HUD Voluntary Compliance Agreement-Fair Housing Tra 28,763 100 10016200 62753 C/O Human Rights 30 HUD Voluntary Compliance Agreement-Education &Tra 6,500 100 10016600 62360 C/O Human Rights 30 Workforce Development-Leadership Training 3,000 100 10016300 62360 C/O Multicultural Family Ce 40 Multicultural Family Center-Telephone 2,268 100 10034600 62421 Shift from Building Services Park Division 40 Forestry-Tree Maintenance 8,164 100 10030220 62720 C/O Park Division 40 Forestry- Equipment 187,250 100 10030220 71614 C/O Park Division 40 Park Patrol- Body Armor 650 100 10030300 72213 C/O Park Division 40 Park Maintenance- Picnic Tables Jackson Park 9,600 100 10030400 72710 Adjust to Actual Park Division 40 Park Maintenance- Landscaping 4,945 100 10030400 62637 C/O Park Division 40 Park Maintenance-Sign Supplies 1,397 100 10030400 62685 C/O Park Division 40 Park Maintenance- Lawn Care 8,493 100 10030400 62781 C/O Park Division 40 Park Maintenance- Mowing Equipment 5,164 100 10030400 71611 C/O Park Division 40 Park Maintenance- Mowing Equipment 25,000 100 10030400 71611 C/O Park Division 40 Park Maintenance-Vehicle Replacement 8,470 100 10030400 71310 C/O Park Division 40 Port of Dubuque Maintenance-Property Maintenance 2,131 100 10030415 62431 C/O Park Division 40 Port of Dubuque Maintenance-Property Maintenance 1,678 100 10030415 62637 C/O Park Division 40 Downtown Maintenance- Property Maintenance 7,176 100 10030430 62431 C/O Park Division 40 Downtown Maintenance-Vehicle Replacement 27,000 100 10030430 71312 C/O Park Division 40 Greenhouse- Landscape 10,379 100 10030500 62637 C/O-Includes Grandview Ave Park Division 40 Technology Park Maint- Property Maintenance 6,000 100 10030520 62431 C/O-Granger Creek Trail Repairs Park Division 40 Technology Park Maint- Landscape 2,803 100 10030520 62637 C/O Park Division 40 Industrial Center West- Landscape 3,850 100 10030530 62637 C/O Park Division 40 Industrial Center West-Tree Maintenance 2,000 100 10030530 62720 C/O Park Division 40 Park Maintenance- Property Maintenance 22,267 100 10030400 62431 C/O- Moved to operating from CIP Park Division 40 Park Maintenance- Property Maintenance 15,765 100 10030500 62637 C/O- Moved to operating from CIP Park Division 4C NW Bike/Hike Trail Phase 3-Construction 146,983 100 1002273 73211 C/O Park Division 4C NW Bike/Hike Trail Phase 3-REAP Grant 359,978 100 1002273 45707 C/O Park Division 40 Park Maintenance- Property Maintenance 7,944 100 10030400 62431 C/O- Moved to operating from CIP Park Division 40 Park Maintenance- Property Maintenance 15,000 100 10030400 62431 C/O-Moved to operating from CIP Pagel FISCAL YEAR 2017 AMENDMENT#1 CIN COUNCIL 29-Aug-16 FY 17 FY 17 Expense Revenue Department Program Description Amount Amount Fund Activity/CIP Account Explanation Park Division 40 Park Maintenance- Property Maintenance 15,381 100 10030400 62431 C/O-Moved to operating from CIP Park Division 40 Park Maintenance- Property Maintenance 7,060 100 10030400 62431 C/O-Moved to operating from CIP Park Division 4C ITC Grant Tree/Park Development- Playground 32,880 100 1002637 72713 C/O Civic Center 4C Five Flags Improvements-SMG 30,000 100 1002569 73210 C/O Conference Center 60 Maintenance Contract 10,000 100 10033300 62061 C/O Conference Center 60 Grand River Center Maintenance-Property Maintenance 21,062 100 10033300 62431 C/O Recreation 40 Computer Devices- Handhelds 6,964 100 10034200 71120 C/O Recreation 40 Administration-Third Grade Level Reading 16,020 100 10034100 62668 C/O Recreation 40 Administration- Pay to other agency 29,794 100 10034100 62761 C/O-Americorps match/ice rental Recreation 40 Administration- Program Supplies (19,568) 100 10034100 62668 Shift to CDBG Library 40 Administration-Conferences 1,448 100 10036100 62310 C/O Library 40 Adult Services-On line info Service 120 100 10036200 62655 C/O Library 40 Adult Services-Books 311 100 10036200 62651 C/O Library 40 Adult Services-Audio Book 77 100 10036200 62652 C/O Library 40 Adult Services-E-Book 3,180 100 10036200 62605 Lost Books Library 40 Adult Services-E-Book 263 100 10036200 62605 Damage Reimbursement Library 40 Children Services- Books 1,718 100 10036210 62651 Lost Books Library 40 Maintenance Services-Custodial Services 116 100 10036300 62433 C/O Library 40 Maintenance Services-HVAC Maintenance 80 100 10036300 62434 C/O Library 40 Maintenance Services-Property Maintenance 704 100 10036300 62431 C/O Library 40 Technical Services- Processing Materials 31 100 10036500 62031 C/O Airport 20 Airport Operations- Equipment Maintenance 25,000 100 10051400 62614 C/O Airport 20 Terminal Building-Concession Equipment 5,594 100 10051700 72310 C/O Engineering 20 Leases-Electricity Utility Expense 400 100 10055150 62411 Adjust to Actual Engineering 20 Project Engineering-Cell Phone (180) 100 10055400 72418 Adjust to Actual Engineering 4C Library Renovation-Architectural Services (40,842) 100 1001141 62711 Project Complete Engineering 4C Library Renovation-Architectural Services (12,500) 100 1001141 73210 Project Complete Engineering 4C Library Renovation- Heade Painting Sale 178,601 100 1001141 54104 C/O Engineering 20 Traffic Engineering-Consulting Engineers 21,728 100 10055700 62712 C/O Building Services 60 Multicultural Family Center- Fulltime Employee 6,376 100 10057540 61010 Adjust to Actual Building Services 60 Multicultural Family Center-Social Security 488 100 10057540 61320 Adjust to Actual Building Services 60 Multicultural Family Center- IPERS 569 100 10057540 61310 Adjust to Actual Building Services 60 Multicultural Family Center-Health Insurance 2,226 100 10057540 61410 Adjust to Actual Building Services 60 Multicultural Family Center-Life Insurance 13 100 10057540 61416 Adjust to Actual Building Services 60 Federal Building- Full-time Employees 18,216 100 10057520 61010 Shift Custodial from Housing Building Services 60 Federal Building-Social Security 1,394 100 10057520 61320 Shift Custodial from Housing Building Services 60 Federal Building- IPERS 1,627 100 10057520 61310 Shift Custodial from Housing Building Services 60 Federal Building- Health Insurance 6,360 100 10057520 61410 Shift Custodial from Housing Building Services 60 Federal Building-Life Insurance 36 100 10057520 61416 Shift Custodial from Housing Building Services 60 Federal Building-Admin Overhead (27,633) 100 10057520 63311 Shift Custodial from Housing Building Services 60 City Hall Annex-Full-Time Employees (774) 100 10057510 61010 Adjust to Actual Building Services 60 City Hall Annex-Social Security (59) 100 10057510 61320 Adjust to Actual Building Services 60 City Hall Annex-IPERS (69) 100 10057510 61310 Adjust to Actual Building Services 60 City Hall Annex-Health Insurance (270) 100 10057510 61410 Adjust to Actual Building Services 60 City Hall Annex-Life Insurance (2) 100 10057510 61416 Adjust to Actual Building Services 60 Multicultural Family Center-Telephone (2,268) 100 10057540 62421 Shift to Multicultural Family Center Building Services 6C Permit Tracking System 13,200 100 1001178 71123 C/O Economic Developmei 5C Brownfelds Grant-Consulting Engineers 15,583 100 1001111 62712 C/O Economic Developmei 5C Brownfelds Grant- EDA Grant 171,699 100 1001111 44170 C/O Economic Developmei 5C Downtown Brownfelds Assessment-EDA Grant 55,747 100 1002567 44170 C/O Page 2 FISCAL YEAR 2017 AMENDMENT#1 CITY COUNCIL 29-Aug-16 FY 17 FY 17 Expense Revenue Department Program Description Amount Amount Fund Activity/CIP Account Explanation Economic Developmei 5C Downtown Brownfields Assessment-EDA Grant 55,747 100 1002567H 44170 C/O Housing&Community 50 Housing Administration- Home Workshop 730 100 10061100 62140 C/O Housing&Community 50 Housing Administration- Home Workshop 850 100 10061100 62140 Adjust to Actual Housing&Community 50 Rehab Program-Escrow payment 9,304 100 10061300 62758 C/O Housing&Community 50 Continuum Care Grant-Rental of Space 2,867 100 10061915 62436 C/O Housing&Community 50 General Housing Inspection-Fulltime Employees (2,960) 100 10061700 61010 Shift Custodial to Building Services Housing&Community 50 General Housing Inspection-Social Security (226) 100 10061700 61320 Shift Custodial to Building Services Housing&Community 50 General Housing Inspection-IPERS (264) 100 10061700 61310 Shift Custodial to Building Services Housing&Community 50 General Housing Inspection-Health Insurance (1,034) 100 10061700 61410 Shift Custodial to Building Services Housing&Community 50 General Housing Inspection-Life Insurance (6) 100 10061700 61416 Shift Custodial to Building Services Housing&Community 60 Federal Building-Admin Overhead 27,633 100 10061150 63311 Shift Custodial from Housing Housing&Community 50 Circles-Workforce Development Grant 39,500 100 10061922 51950 C/O Housing&Community 50 Housing Inspection-Computer 2,883 100 10061700 71124 C/O Housing&Community 5C Neighborhood Stabilization-Construction 33,629 100 1002180 73210 C/O Public Info/GIS 6C GIS Consultant Services-Consultant 9,970 100 1001070 62716 C/O Public Info/GIS 6C GIS Education and Training 6,750 100 1002165 62360 C/O City Managers Office 60 Budget-Consulting Services 2,297 100 10072400 62716 C/O-SunGard Budget Review City Managers Office 60 Budget- Phone 455 100 10072400 72418 Adjust to Actual City Managers Office 60 Budget-Software 19,950 100 10072400 71123 Adjust to Actual City Managers Office 60 Sustainability Community Grants-Grants 22,090 100 10072200 62761 C/O City Managers Office 60 Sustainability-Conference Speakers 11,000 100 10072200 62734 C/O City Managers Office 60 Sustainability- Private Participant- U of I Grant 1,494 100 10072200 53102 C/O Park Division 4C Eagle Park Stone-Construction 20,750 101 1011677 73211 C/O Park Division 4C Catfish Creek Hike/Bike Study-Consultant Service 5,400 101 1012078 62716 C/O Park Division 4C Comiskey Security Alarm-Construction 10,000 101 1012372 73210 C/O Civic Center 4C Paint Arena Ceiling-Construction 79,311 101 1012117 73210 C/O Housing&Community 5C Homeownership Grants-Grants 56,165 101 1011595 62765 C/O Police Department 1C Body Video Cameras-Cameras 11,786 102 1022574 71118 C/O Police Department 1C Body Video Cameras-Cameras 15,325 102 1022574 71118 C/O-Donations Multicultural Family Ce 6C Multicultural Center Renovation-Construction 7,434 102 1021976 73210 C/O Park Division 4C Comiskey Repair Siding-Construction 11,997 102 1021151 73210 C/O Park Division 4C Ham House Repairs-Construction 863 102 1022184 73210 C/O Park Division 4C Comiskey Playground Replace- Playground Equip 201,190 102 1022292 62716 C/O Park Division 4C All Parks-Security Lights-Construction 3,108 102 1022368 73211 C/O Park Division 4C Electrical Panel Replacement-Construction 7,784 102 1022579 73210 C/O Conference Center 6C Grandriver Center Kitchen Equipment-Concession Equip 14,563 102 1022588 72310 C/O Conference Center 6C Paint Bridge-Construction 30,000 102 1022589 73210 C/O Recreation 4C Marina Security Cameras-Cameras 20,000 102 1022587 72417 C/O Recreation 4C Flora/Sutton Annual Maintenance-Construction 67,014 102 1021890 73210 C/O Engineering 2C Riverwalk Security Camera-Cameras 10,000 102 1021963 72417 C/O Planning 5C Comprehensive Plan- Printing and Binding 2,500 102 1022623 62090 C/O Planning 5C Comprehensive Plan- Promotion 20,655 102 1022623 62140 C/O Planning 5C Historical Archeological Surveys-CLG Grant 15,000 102 1022432 45707 C/O TOTAL GENERAL FUND 1,686,265 885,171 TRANSIT FUND Parking Division 8C Intermodal Transportation Facility-Construction 2,050 600 6001614 73211 C/O Parking Division 8C Intermodal Transportation Facility- FTA Funds 324,446 600 6001614 44150 C/O Transit Division 80 Transit Admin-FTA Operating 22,465 600 60053100 44160 C/O Transit Division 80 Bus Operations- FTA Operating 247,118 600 60053400 44160 C/O Transit Division 80 Mini Bus Operations- FTA Operating 157,257 600 60053500 44160 C/O Page 3 FISCAL YEAR 2017 AMENDMENT#1 CITY COUNCIL 29-Aug-16 FY 17 FY 17 Expense Revenue Department Program Description Amount Amount Fund Activity/CIP Account Explanation Transit Division 80 Bus Maintenance-FTA Operating 22,465 600 60053700 44160 C/O Transit Division 80 Transit Admin-Vehicle Replacement 22,500 600 60053100 71312 C/O Transit Division 80 Transit Admin-State Grant- ICAAP 18,149 600 60053100 45771 C/O Transit Division 80 Bus Operations-State Grant-ICAAP 435,573 600 60053400 45771 C/O Transit Division 80 Bus Maintenance-State Grant- ICAAP 151,241 600 60053700 45771 C/O Transit Division 8C Bus Storage Facility-Consulting Engineers 59,300 600 6002446 62712 C/O Transit Division 8C Bus Storage Facility- FTA Capital 228,720 600 6002446 44150 C/O Transit Division 8C Bus Stop Improvements-Construction 20,547 600 6002235 73211 C/O TOTAL TRANSIT FUND 104,397 1,607,434 DOWNTOWN LOAN POOL-TIF FUND Economic Developmei 5C Downtown Loan Pool- Loans 300,000 241 2411033 62764 C/O Economic Developmei 5C Downtown Rehab Grant-Grant 25,750 241 2411942 62765 C/O TOTAL DOWNTOWN LOAN POOL-TF FUND 325,750 - ROAD USE TAX FUND Public Works 2C Asphalt Milling Program-Construction 145,019 250 2501230 73211 C/O Public Works 20 Street Maintenance-Asphalt 309,301 250 25054400 62618 C/O Public Works 20 Street Maintenance-Cracksealing 11,772 250 25054400 62686 C/O Engineering 2C Brunskill Road Bridge Replace-Construction 87,283 250 2501077 73211 C/O Engineering 2C Brunskill Road Bridge Replace- Federal Pass Thru 114,085 250 2501077 45771 C/O Engineering 2C Railroad Crossing Improvements-Construction 36,031 250 2502026 73211 C/O 589,406 114,085 COMMUNITY DEVELOPMENT BLOCK GRANT FUND Multicultural Family Ce 6C Multicultural Center Renovation-Construction 76,259 260 26079220 62761 Eliminate Encumbrances Recreation 40 Senior Center-Pay to Agency (16,380) 260 26079180 62761 Eliminate Encumbrances Recreation 40 Administration- Program Supplies 19,568 260 26034100 62668 Shift from General Fund Engineering 2C Wheel Chair Ramps-Construction 20,711 260 2601236 73211 C/O Economic Developmei 5C Microenterprise Assistance-Loans 149,970 260 2602636 62764 C/O Housing&Community 50 General Housing Inspection-Fulltime Employees (2,960) 260 26061700 61010 Shift Custodial to Building Services Housing&Community 50 General Housing Inspection-Social Security (226) 260 26061700 61320 Shift Custodial to Building Services Housing&Community 50 General Housing Inspection-IPERS (264) 260 26061700 61310 Shift Custodial to Building Services Housing&Community 50 General Housing Inspection-Health Insurance (1,034) 260 26061700 61410 Shift Custodial to Building Services Housing&Community 50 General Housing Inspection-Life Insurance (6) 260 26061700 61416 Shift Custodial to Building Services Housing&Community 50 Rehab Program-Fulltime employees (5,920) 260 26061300 61010 Shift Custodial to Building Services Housing&Community 50 Rehab Program-Social Security (453) 260 26061300 61320 Shift Custodial to Building Services Housing&Community 50 Rehab Program-IPERS (529) 260 26061300 61310 Shift Custodial to Building Services Housing&Community 50 Rehab Program-Health Insurance (2,067) 260 26061300 61410 Shift Custodial to Building Services Housing&Community 50 Rehab Program-Life Insurance (12) 260 26061300 61416 Shift Custodial to Building Services Housing&Community 50 Community Development Block Grant 9,295 260 26061800 44205 Adjust to Actual Housing&Community 50 Community Development Block Grant 833,787 260 26061800 44205 C/O-CDBG FY2016 Plan Year Housing&Community 50 Community Development Block Grant 36,481 260 26061800 44205 C/O-CDBG for FY16 Expense Housing&Community 50 Community Development Block Grant 84,418 260 26061800 44205 C/O-CDBG for FY16 Expense Housing&Community 30 Four Mounds HEART- Pay to Other Agency 10,000 260 26079115 62761 CDBG Amend#1 Housing&Community 50 Purchase of Services-Pay to Other Agency (30,000) 260 26079450 62761 CDBG Amend#1 Housing&Community 50 Housing Rehab-Education &Training 3,279 260 26061300 62360 CDBG Amend#1 Housing&Community 50 St Mark Youth Enrichment-Pay to Other Agency 20,000 260 26079216 62761 CDBG Amend#1 Housing&Community 5C Residential Rehab- Loans 290,656 260 2601065 62764 C/O-CDBG Housing&Community 5C Residential Rehab- Loans (100,000) 260 2601065 62764 CDBG Amend#1 Housing&Community 5C Purchase/Rehab/Resale-Construction 108,695 260 2601231 73211 CDBG Amend#1 Page 4 FISCAL YEAR 2017 AMENDMENT#1 CITY COUNCIL 29-Aug-16 FY 17 FY 17 Expense Revenue Department Program Description Amount Amount Fund Activity/CIP Account Explanation Housing&Community 5C Purchase/Rehab/Resale- Land Acquisition 70,760 260 2601231 73111 C/O-CDBG Housing&Community 5C Lead Paint Abatement-Loans 28,400 260 2601232 62764 C/O-CDBG Housing&Community 5C Rental Rehab Unit- Loans 87,424 260 2601233 62764 C/O-CDBG Housing&Community 5C First Time Homebuyer Program-Loans 15,000 260 2601234 62764 C/O-CDBG Housing&Community 5C Historic Preservation Grant- Loans 10,000 260 2601237 62764 C/O-CDBG Housing&Community 5C Salvia House Elevator-Grants 49,750 260 2602689 62765 C/O Neighborhood Develol 50 Washington Tool Library-Pay to Other Agency (193) 260 26079220 62761 Eliminate Encumbrances TOTAL COMMUNITY DEVELOPMENT BLOCK FUND 800,428 963,981 UDAG FUND Economic Developmei 5C Job Creation-Loans 21,480 265 2651246 62764 C/O Economic Developmei 5C Historic Preservation Revolving Loan-Loans 62,276 265 2651247 62764 C/O Economic Developmei 5C Airport Revenue Guarantee- Pay to Other Agency 150,000 265 2651796 62761 C/O TOTAL UDAG FUND 233,756 - HOUSING TRUST FUND Housing&Community 5C Washington Neighborhood-Housing Trust Funds 401,900 268 2681021 62764 C/O Housing&Community 5C Washington Neighborhood-IFA Grant 332,604 268 2681021 45703 C/O TOTAL HOUSING TRUST FUND 401,900 332,604 CIRCLES DONATIONS FUND Housing&Community 50 Circles-Postage 200 269 26961922 62030 C/O Housing&Community 50 Circles-Education and Training 2,540 269 26961922 62360 C/O Housing&Community 50 Circles-Hospitality 1,500 269 26961922 62641 C/O Housing&Community 50 Circles-Special Events 1,000 269 26961922 62645 C/O Housing&Community 50 Circles-Programming 300 269 26961922 62669 C/O Housing&Community 50 Circles-Speakers 2,000 269 26961922 62734 C/O Housing&Community 50 Circles-Leadership Training 500 269 26961922 62755 C/O Housing&Community 50 Circles-Grants 10,000 269 26961922 62765 C/O TOTAL CIRCLES DONATIONS FUND 18,040 - STATE RENTAL REHAB FUND Housing&Community 50 HOME Program-Grants 47,093 270 27061320 62764 C/O Housing&Community 5C Residential Rehab-Construction 342,376 270 2701065 73210 C/O Housing&Community 5C HOME Program-Construction 439,956 270 2701250 73210 C/O TOTAL STATE RENTAL REHAB FUND 829,425 - LEAD PAINT ABATEMENT Housing&Community 50 Lead Paint Abatement-Full-Time Employees 23,212 275 27561211 61010 Adjust to Actual Housing&Community 50 Lead Paint Abatement-IPERS 2,075 275 27561211 61310 Adjust to Actual Housing&Community 50 Lead Paint Abatement-Social Security 1,774 275 27561211 61320 Adjust to Actual Housing&Community 50 Lead Paint Abatement-Life Insurance 46 275 27561211 61416 Adjust to Actual Housing&Community 50 Lead Paint Abatement-Lead Grant 27,107 275 27561211 44310 Adjust to Actual Housing&Community 50 Lead Paint Abatement-Education and Training 2,500 275 27561211 62310 Adjust to Actual Housing&Community 50 Lead Paint Abatement-Relocations 20,000 275 27561211 73112 Adjust to Actual Housing&Community 50 Lead Paint Abatement-Lead Grant 26,090 275 27561211 44310 Adjust to Actual Housing&Community 50 Lead Paint Abatement-Lead Grant 22,500 275 27561211 44310 Adjust to Actual Housing&Community 5C Healthy Homes Supplemental- Loan 128,738 275 2752429 62765 Adjust to Actual Housing&Community 5C Healthy Homes Supplemental- HUD Payments 128,738 275 2752429 44310 Adjust to Actual Housing&Community 5C Healthy Homes Supplemental-Owner Contribution 17,225 275 2752429 53103 Adjust to Actual Page 5 FISCAL YEAR 2017 AMENDMENT#1 CITY COUNCIL 29-Aug-16 FY 17 FY 17 Expense Revenue Department Program Description Amount Amount Fund Activity/CIP Account Explanation Housing&Community 5C Healthy Homes Supplemental-Grant 17,225 275 2752429 62764 Adjust to Actual Housing&Community 5C Healthy Homes Supplemental- HUD Payments 30,000 275 2752429 44310 Adjust to Actual Housing&Community 5C Healthy Homes Supplemental- Loans 30,000 275 2752429 62765 Adjust to Actual Housing&Community 50 Lead Paint Abatement-Lead Grant 46,242 275 27561211 44310 C/O TOTAL LEAD PAINT ABATEMENT 225,570 297,902 SECTION 8 FUND Housing&Community 50 Section 8 Voucher-Software 3,573 280 28061600 71123 C/O Housing&Community 50 Section 8 Voucher- Fulltime Employees (11,840) 280 28061600 61010 Shift Custodial to Building Services Housing&Community 50 Section 8 Voucher-Social Security (906) 280 28061600 61320 Shift Custodial to Building Services Housing&Community 50 Section 8 Voucher- IPERS (1,057) 280 28061600 61310 Shift Custodial to Building Services Housing&Community 50 Section 8 Voucher- Health (4,134) 280 28061600 61410 Shift Custodial to Building Services Housing&Community 50 Section 8 Voucher- Life Insurance (24) 280 28061600 61416 Shift Custodial to Building Services TOTAL SECTION 8 FUND (14,388) - CABLE TV FUND Public Info/GIS 60 Public Information-Consultant Services 4,000 290 29072300 62716 C/O Cable TV 60 Cable TV- Legal Services 6,000 290 29075100 62713 C/O TOTAL CABLE TV FUND 10,000 - STREET CONSTRUCTION FUND Public Works 2C Concrete Section Repair-Construction 16,287 300 3001006 73211 C/O Public Works 2C Curb Replacement Program-Construction 37,856 300 3001226 73211 C/O Public Works 2C Curb Ramp Program-Construction 352,207 300 3001227 73211 C/O Public Works 2C Asphalt Milling Program-Construction 22,876 300 3001230 73211 C/O Public Works 2C Floodwall Post Flood Repair-Construction 25,000 300 3001445 73211 C/O Public Works 2C Wayfinding Sign Replace-Signage 3,024 300 3002151 71227 C/O Public Works 2C Mobile GIS System- Equipment Acquisition 9,459 300 3002225 73410 C/O Public Works 2C Dump Truck Replace- Heavy Equipment 49,254 300 3002539 71318 C/O Public Works 2C MSC LED Lighting-Lighting 5,987 300 3002541 71517 C/O Engineering 2C Guardrail Replacement-Construction 2,408 300 3001027 73211 C/O Engineering 2C Corridor Study-Alternates-Consulting Engineers 1,000,000 300 3001039 62712 C/O Engineering 2C Corridor Study-Alternates- Federal Pass Thru 800,000 300 3001039 45771 C/O Engineering 2C Curb/Catch Basin Replacement-Construction 15,858 300 3001041 73211 C/O Engineering 2C Grandview Ave Light Poles-Equipment 33,441 300 3001210 73410 C/O Engineering 2C Special Assessment Assist- Pay to Other 60,000 300 3001256 62761 C/O Engineering 2C Bridge Repairs and Maint-Construction 223,239 300 3001258 73211 C/O Engineering 2C Southwest Arterial- Right-of-Way 4,328,474 300 3001287 73211 C/O Engineering 2C Southwest Arterial-County Share 2,333,897 300 3001287 46205 C/O Engineering 2C Southwest Arterial- DMATS 12,500,000 300 3001287 45771 C/O Engineering 2C Sidewalk Program City Owned-Construction 416 300 3001425 73211 C/O Engineering 2C Decorative Concrete Maint-Construction 46,287 300 3001630 73211 C/O Engineering 2C White Water Creek Bridge- Lighting 10,000 300 3001634 62616 C/O Engineering 2C White Water Creek Bridge- Private Participant 10,000 300 3001634 53102 C/O Engineering 2C Safe Routes to School-Construction 5,000 300 3001922 73211 C/O Engineering 2C North Cascade Rd Reconst-Construction 1,197,348 300 3002021 73211 C/O Engineering 2C North Cascade Rd Reconst- DMATS 702,800 300 3002021 45771 C/O Engineering 2C North Cascade Rd Reconst-Construction 554,000 300 3002021 73211 C/O Engineering 2C North Cascade Rd Reconst- Engineering 100,000 300 3002021 62811 C/O Engineering 2C North Cascade Rd Reconst- DMATS 654,000 300 3002021 45771 C/O Page 5 FISCAL YEAR 2017 AMENDMENT#1 CIN COUNCIL 29-Aug-16 FY 17 FY 17 Expense Revenue Department Program Description Amount Amount Fund Activity/CIP Account Explanation Engineering 2C Street Construction-General-Construction 2,738 300 3002142 73211 C/O Engineering 2C Pennsylvania at Radford- Engineering 80,000 300 3002256 62811 C/O Engineering 2C University&Asbury Intersection-Construction 68,650 300 3002324 73211 C/O Engineering 2C University&Asbury Intersection- Federal Pass Thru 800,000 300 3002324 45771 C/O Engineering 2C N Grandview Estates Road- Engineering 15,000 300 3002336 62811 C/O Engineering 2C N Grandview Estates Road- Engineering 279,001 300 3002336 73211 C/O Engineering 2C Key West Dr Reconstruction-Construction 9,814 300 3002694 73211 C/O Engineering 2C Grandview/Delhi Roundabout-Construction 99,968 300 3002611 73211 C/O Engineering 2C Grandview/Delhi Roundabout- Federal Pass Thru 500,000 300 3002611 45771 C/O Engineering 2C ROW Management- Engineering 90,908 300 3002613 62811 C/O Engineering 2C NW Arterial Left Turn Lane-Engineering 8,000 300 3002695 62811 Shift from Heeb Wall 3002612 Engineering 2C NW Arterial Left Turn Lane-Construction 149,564 300 3002695 73211 Shift from Heeb Wall 3002612 Engineering 2C Key West Dr Reconstruction-Construction 4,887 300 3002694 73211 C/O Engineering 2C Washington Neighborhood Street Lights-Construction 4,797 300 3002615 73211 C/O Engineering 2C JFK Coordination Wacker/Asbury-Construction 238,991 300 3002617 73211 C/O Engineering 2C Stone Retaining Walls-Construction 50,749 300 3001029 73211 C/O Engineering 2C Accessibility Barriers-Construction 9,833 300 3001034 73211 C/O Engineering 2C Steps, Railing, Fencing-Construction 353 300 3001432 73211 C/O Engineering 2C Harbor Area Maintenance-Construction 35,000 300 3001466 73211 C/O Engineering 2C Smarter Travel Project- Pay to Other Agency 25,737 300 3002634 62761 C/O Engineering 2C Signalization Program-Equipment 21,278 300 3001011 73410 C/O Engineering 2C Intersection Preemption-Equipment 7,747 300 3001023 73410 C/O Engineering 2C Traffic Signal Interconnect-Traffic Controller Equipment 19,372 300 3001266 71411 C/O Engineering 2C Traffic Controller Replacement- Equipment 25,806 300 3001274 73410 C/O Engineering 2C Streetlight Replacement- Equipment 21,257 300 3001549 73410 C/O Engineering 2C Signal Intersection Reconstruction-Equipment 22,937 300 3001615 73411 C/O Engineering 2C Traffic Signal Fiber Optics- Equipment 21,515 300 3001631 73410 C/O Engineering 2C Traffic Signal Video Detection- Equipment 3,289 300 3001816 71411 C/O Engineering 2C LED Re-Lamp Schedule 15,556 300 3001916 73211 C/O Engineering 2C Reconstruct Signals JFKNVacker-Construction 19,865 300 3001919 73211 C/O Engineering 2C Fiber Optic Conduit Misc- Equipment 20,443 300 3002144 71411 C/O Engineering 2C Crosswalk Warning Devices-Construction 31,000 300 3002246 73211 C/O Engineering 2C Street Light/Signal Knockdown- Equipment 13,643 300 3002252 71411 C/O Engineering 2C ITS Traffic Control Equipment-Construction 6,442 300 3002253 73211 C/O Engineering 2C Catfish Creek Bridge Fiber-Construction 317,159 300 3002327 73211 C/O Engineering 2C Surge and Ground Improvements-Equipment 29,272 300 3002420 73410 C/O Engineering 2C Street Camera Install-Cameras 19,800 300 3002421 73410 C/O Engineering 2C Traffic Ops Video Software-Software 53,802 300 3002422 71123 C/O Engineering 2C Traffic Ops Equipment Test-Software 29,844 300 3002423 71123 C/O Engineering 2C LED Streetlight Retrofit- Equipment 21,616 300 3002484 73410 C/O Engineering 2C Fiber Optics to Airport-Construction 50,877 300 3002491 73211 C/O Engineering 2C Flash Yellow Left Turn- Lighting Equipment 19,883 300 3002557 71517 C/O Engineering 2C Replace LED Signs Beacons- Lighting Equipment 20,000 300 3002558 71517 C/O Engineering 2C Grandview Signal Recon Construction 8,174 300 3002559 73211 C/O Engineering 2C West Locust Communications/Cameras-Construction 80,240 300 3002618 73211 C/O Engineering 2C University/Asbury-Fiber/Cameras 12,484 300 3002619 71411 C/O Engineering 2C Fiber/Network Management Program 34,004 300 3002620 71123 C/O Recreation 4C POD Marina Signage-Signage 28,104 300 3002692 71227 C/O-Shift from DT Sign Post Recreation 4C POD Marina Signage-Signage 4,000 300 3002692 71227 C/O-Shift from Wayfinding Sign Engineering 2C Pavement Markings-Construction (89,906) 300 3002245 73211 Prespend FY 2017 Page 7 FISCAL YEAR 2017 AMENDMENT#1 CITY COUNCIL 29-Aug-16 FY 17 FY 17 Expense Revenue Department Program Description Amount Amount Fund Activity/CIP Account Explanation Engineering 2C Traffic Signal Masterarm- Equipment (1,348) 300 3001133 71411 Prespend FY 2017 Engineering 2C Traffic Controller Battery Pack-Equipment (2,791) 300 3001229 73410 Prespend FY 2017 TOTAL STREET CONSTRUCTION FUND 10,157,775 18,300,697 DICW CIP REPLACEMENT FUND Park Division 4C DICW CIP Replacement- Playground Replacement 11,229 325 3252568 72713 C/O TOTAL DICW CIP REPLACEMENT FUND 11,229 - SALES TAX INCREMENT CONSTRUCTION FUND Engineering 8C Bee Branch-Construction 1,845,468 340 3401654 73211 C/O Engineering 8C Gate Replacement-Construction 1,980,730 340 3402608 73211 C/O Engineering 8C Flood Control Maintenance Facility-Land Acquisition 451,524 340 3402609 73111 C/O TOTAL SALES TAX INCREMENT CONSTRUCTION FUI 4,277,722 - SALES TAX FUND(20%) Police Department 1C CJISI-Software 75,000 350 3502503 71123 C/O Fire 1C Improvements to Fire Headquarters-Construction 8,486 350 3501139 73210 C/O Fire 1C Improvements to Fire Headquarters- Federal Grant 12,118 350 3501139 44170 C/O Fire 1C Mechanical/Electrical Systems-Consultant 50,000 350 3502575 62716 C/O Fire 1C Ambulance Replacement- Heavy Equipment 227,833 350 3502507 71318 C/O Multicultural Family Ce 6C Multicultural Center Renovation-Construction 5,000 350 3501976 73210 C/O Park Division 4C Northend Trail Lighting-Construction 31,227 350 3501129 73211 C/O Park Division 4C Renovate Park Water System-Consultant Engineers 11,578 350 3501158 62712 C/O Park Division 4C Ham House Improvements-Construction 186,506 350 3501212 73210 C/O Park Division 4C Renovate Park Sidewalks-Consulting Engineers 700 350 3501438 62712 C/O Park Division 4C Renovate Park Sidewalks-Construction 11,161 350 3501438 73211 C/O Park Division 4C Murphy Play Equipment- Equipment 82,125 350 3501450 73411 C/O Park Division 4C EPP Replace Walkway-Construction 4,687 350 3501453 73211 C/O Park Division 4C Slattery Center Entrance-Construction 10,495 350 3501468 73210 C/O Park Division 4C Comiskey Park New Entrance-Construction 30,147 350 3501544 73211 C/O Park Division 4C Comiskey Park Amenity Replacement-Construction 59,595 350 3501578 73211 C/O Park Division 4C Plan Highway 20 Roses-Landscaping Contract 35,000 350 3501588 73210 C/O Park Division 4C Flora Park Restroom-Consultant Services 10,300 350 3501767 62716 C/O Park Division 4C Flora Park Restroom-Construction 76,200 350 3501767 73210 C/O Park Division 4C Marshall Park Pool Repair-Construction 18,721 350 3501986 73211 C/O Park Division 4C EPP Rivertront Pavilion-Consulting Engineers 5,000 350 3502190 62712 C/O Park Division 4C EPP Paint Pavilions-Construction 22,760 350 3502358 73210 C/O Park Division 4C Maint Headquarters Restroom-Construction 3,453 350 3502364 73210 C/O Park Division 4C All Parks-Security Lights-Construction 2,451 350 3502368 73211 C/O Park Division 4C Flora Park Playground Replace- Equipment 30,338 350 3502377 73410 C/O Park Division 4C Hilltop Park-Construction 3,931 350 3502449 73211 C/O Park Division 4C EPP Retaining Wall-Construction 25,000 350 3502459 73211 C/O Park Division 4C EPP Clear Trees on Bluff-Construction 1,625 350 3502460 73211 C/O Park Division 4C Skate Park-Construction 782,735 350 3502461 73211 C/O Park Division 4C Skate Park- Private Participant 185,000 350 3502461 53102 C/O Park Division 4C Skate Park-GO Bond Proceeds 547,813 350 3502461 54210 C/O Park Division 4C EPP Rivertront Pavilion-Construction 56,639 350 3502508 73210 C/O Park Division 4C EPP Bridge Complex-Consulting Engineers 2,000 350 3502509 62712 C/O Park Division 4C EPP Bridge Complex-Construction 50,412 350 3502509 73210 C/O Park Division 4C Madison Park-Landscaping Contract 5,220 350 3502572 73310 C/O Park Division 4C Replace Interpretive Signs-Signage 16,000 350 3502580 71227 C/O Park Division 4C Parks Retaining Walls-Construction 15,000 350 3501055 73211 C/O Page 8 FISCAL YEAR 2017 AMENDMENT#1 CIN COUNCIL 29-Aug-16 FY 17 FY 17 Expense Revenue Department Program Description Amount Amount Fund Activity/CIP Account Explanation Park Division 4C Flora Paint Tennis Courts-Consulting Engineers 6,000 350 3501557 62712 C/O Park Division 4C Flora Paint Tennis Courts-Construction 29,000 350 3501557 73211 C/O Park Division 4C Flora Park Roof Brick Pavilion-Construction 10,000 350 3501766 73210 C/O Civic Center 4C Locker/Shower Facilities-Construction 13,000 350 3501617 73210 C/O Civic Center 4C Theatre Tuckpoint-Construction 205,116 350 3501708 73210 C/O Civic Center 4C Seal Concrete Walkways-Construction 16,737 350 3502303 73211 C/O Civic Center 4C Arena Roof-Construction 384,227 350 3502378 73210 C/O Civic Center 4C Arena Light Fixtures-Consulting Engineers 10,461 350 3502379 62712 C/O Civic Center 4C Arena Light Fixtures-Construction 162,209 350 3502379 73210 C/O Civic Center 4C Theatre Exterior Lights-Construction 6,945 350 3502381 73210 C/O Civic Center 4C Market Building Study-Consultant Study 50,000 350 3502584 62716 C/O Civic Center 4C Market Building Study- Private Participant SMG 30,000 350 3502584 53102 C/O Civic Center 4C Theatre Fire Escape-Construction 35,000 350 3502511 73210 C/O Civic Center 4C Arena Replace Curtains-Curtain 4,705 350 3502512 72320 C/O Conference Center 6C Fabric Wall Covering-Construction 100,000 350 3502112 73210 C/O Conference Center 6C Grand River Center Chairs-Side Chairs 30,000 350 3501990 71212 C/O Conference Center 6C Replace Carpet-Consultant Services 7,000 350 3502113 62716 C/O Conference Center 6C Replace Carpet-Construction 73,000 350 3502113 73210 C/O Conference Center 6C Outdoor Furniture Replacement- Furniture 21,037 350 3502306 71156 C/O Conference Center 6C Grand River Center Painting-Construction 29,500 350 3502391 73210 C/O Conference Center 6C Energy Efficiency Improvements-Consultant Services 5,000 350 3502590 62716 C/O Conference Center 6C Energy Efficiency Improvements-Construction 15,000 350 3502590 73210 C/O Conference Center 6C Landscape Improvement-Construction 15,000 350 3502591 73210 C/O Recreation 4C Flora/Sutton Pool Heaters-Construction 31,000 350 3501446 73210 C/O Recreation 4C Golf Irrigation-Construction 4,139 350 3501530 73211 C/O Library 4C Renovation Repairs-Construction 15,370 350 3502308 73211 C/O Library 4C Library Attic Access-Construction 24,600 350 3502470 73210 C/O Library 4C HVAC Handling Units-HVAC 12,000 350 3502521 71520 C/O Library 4C Library Switch-Computer 1,800 350 3502593 71120 C/O Public Works 2C Mooring Dolphin Install- Eng Division Services 15,917 350 3502605 62811 C/O Engineering 6C Federal Building Renovation- Engineering Services 25,478 350 3501841 62811 C/O Engineering 6C Federal Building Renovation-Construction 239,758 350 3501841 73210 C/O Engineering 2C Sidewalk Financial Assistance- Pay to Other Agency 12,451 350 3501727 62761 C/O Engineering 2C Accessibility Barriers-Construction 18,170 350 3501034 73210 C/O Engineering 2C Riverfront Leasehold Improvements -Consultant Service 81,812 350 3501053 62716 C/O Engineering 2C Rehab RR Track-Construction 16,590 350 3501465 73211 C/O Engineering 2C Harbor Area Maintenance-Construction 6,292 350 3501466 73211 C/O Engineering 2C Private Fiber Optic- Equipment 20,447 350 3501609 73410 C/O Building Services 6C City Hall Remodeling-Construction 145,488 350 3501045 73210 C/O Building Services 6C City Hall Annex Maint-Construction 23,587 350 3501757 73210 C/O Building Services 6C General Building Maintenance-Construction 11,531 350 3501428 73210 C/O Planning 5C Trails and Complete Streets-Construction 10,000 350 3502430 73210 C/O Public Info/GIS 6C Augmented Data Support Service-Consultant Service 50,000 350 3502624 62716 C/O Public Info/GIS 6C GeoEvent Processor Ext ArcGIS-Servers 10,000 350 3502625 71125 C/O Public Info/GIS 6C GIS Consultant Services-Consultant 41,713 350 3501070 62716 C/O Public Info/GIS 6C ADA Compliance Software-Software 59,100 350 3502564 71123 C/O Information Services 6C Test Environment-Software 35,000 350 3502626 71123 C/O Information Services 6C Novell File Management Suite-Software 26,475 350 3502628 71123 C/O Information Services 6C 10 GBE Network Card Cable-Software 17,255 350 3502565 71123 C/O Information Services 6C Internet, Micros& Printer-Micro-Computer 8,100 350 3501069 71124 C/O for Building Services Laptops Page 9 FISCAL YEAR 2017 AMENDMENT#1 CITY COUNCIL 29-Aug-16 FY 17 FY 17 Expense Revenue Department Program Description Amount Amount Fund Activity/CIP Account Explanation Information Services 6C Internet, Micros& Printer-Micro-Computer 5,400 350 3501069 71124 C/O for Kiosks Five Flags/GRC Park Division 4C Street Tree Program-Tree Planting 11,003 350 3501458 73311 CO TOTAL SALES TAX FUND 4,166,738 774,931 GENERAL CONSTRUCTION FUND Multicultural Family Ce 6C Multicultural Center Renovation-Construction 1,248,942 360 3601976 73210 C/O Park Division 4C Comiskey Landscape-Construction 50,000 360 3601105 73210 C/O Park Division 4C Replace Park Signs DICW-Signage 10,000 360 3601774 71227 C/O Park Division 4C McAleece Sidewalks-Construction 20,439 360 3602374 73211 C/O Park Division 4C Creekwood Park-Construction 150,000 360 3602375 73211 C/O Civic Center 4C Arena Roof A/C Unit Replacement-Construction 150,000 360 3602583 73210 C/O Civic Center 4C Arena Roof A/C Unit Replacement-Bond Proceeds 150,000 360 3602583 54210 C/O Water 8C SW Arterial-Construction 253,000 360 3602594 73211 C/O Parking Division 8C Millwork District Parking Improvements-Construction 1,641,531 360 3602250 73211 C/O Transit Division 8C Bus Storage Facility- DMATS Federal Pass Thru 217,500 360 3602446 45771 C/O Transit Division 8C Bus Storage Facility-GO Bond Proceeds 125,580 360 3602446 54210 C/O Engineering 2C Washington Reconst. 8th to 9th- Engineering 38,641 360 3602552 62811 C/O Engineering 2C Washington Reconst. 8th to 9th-Construction 600,722 360 3602552 73211 C/O Engineering 2C 11th St Stairs Recon-Construction 21,235 360 3602554 73211 C/O Engineering 2C Downtown Security Cameras 278,115 360 3602494 72417 C/O Building Services 1C Downtown ADA Assistance- Construction 1,499 360 3602424 73211 C/O Economic Developmei 5C Workforce Development-Consultant Services 12,500 360 3601842 62716 C/O Economic Developmei 5C South Siegert Farm Develop-Construction 31,345 360 3602160 73211 C/O Economic Developmei 5C Downtown Housing Incentives-Grant 127,211 360 3602267 62765 C/O Economic Developmei 5C Future Industrial Acquisitions-Land Acquisitions 293,015 360 3602437 73110 C/O Economic Developmei 5C Washington Neighborhood Incentives-Grant 397,403 360 3602438 62765 C/O Housing&Community 5C Homeownership Grants- Pay to Other Agency 48,000 360 3601595 62761 C/O Housing&Community 5C Homeownership Grants- Loans 125,294 360 3601595 62764 C/O Housing&Community 5C Homeownership Grants-Construction 211,969 360 3601595 73210 C/O Housing&Community 5C Community Housing Initiative- Pay to Other Agency 65,756 360 3602573 62761 C/O Economic Developmei 5C Washington Neighborhood Business Incentives-grant 100,000 360 3602436 62765 C/O-Shift from 3602438 TOTAL GENERAL CONSTRUCTION FUND 5,876,617 493,080 AIRPORT CONSTRUCTION FUND Airport 2C Pavement Condition Index-Consulting Engineers 34,650 390 3901060 62712 C/O Airport 2C Pavement Condition Index-FAA Funds 33,000 390 3901060 44105 C/O Airport 2C Terminal Runway 31 Parallel-Consulting Engineers 248,100 390 3901891 62712 C/O Airport 2C Terminal Runway 31 Parallel-Construction 3,181,772 390 3901891 73211 C/O Airport 2C Terminal Runway 31 Parallel- FAA Funds 3,295,567 390 3901891 44105 C/O Airport 2C Extend General Aviation Ramp-Consulting Engineers 1,170 390 3901893 62712 C/O Airport 2C Extend General Aviation Ramp-Construction 48,650 390 3901893 73211 C/O Airport 2C Hanger Repairs/Replace-Construction 26,663 390 3902008 73210 C/O Airport 2C Terminal Sitework-Construction 214,000 390 3902009 73211 C/O Airport 2C Terminal Sitework- FAA Funds 324,844 390 3902009 44105 C/O Airport 2C Onsite Water&Wastewater-Construction 498,288 390 3902011 73210 C/O Airport 2C Onsite Water&Wastewater-FAA Funds 272,646 390 3902011 44105 C/O Airport 2C Paint Hangar Exteriors-Construction 10,000 390 3902125 73210 C/O Airport 2C Terminal Boiler Replacement-Construction 38,000 390 3902126 73211 C/O Airport 2C Terminal Design and Build-Construction 1,207,764 390 3902213 73210 C/O Airport 2C Terminal Design and Build- FAA Funds 1,484,702 390 3902213 44105 C/O Page 10 FISCAL YEAR 2017 AMENDMENT#1 CITY COUNCIL 29-Aug-16 FY 17 FY 17 Expense Revenue Department Program Description Amount Amount Fund Activity/CIP Account Explanation Airport 2C Replace Runway Regulators-Construction 35,004 390 3902215 73211 C/O Airport 2C New Terminal Roads&Apron-Consulting Engineer 85,696 390 3902316 62716 C/O Airport 2C New Terminal Roads&Apron-Construction 3,094,279 390 3902316 73211 C/O Airport 2C New Terminal Roads&Apron- FAA Funds 3,486,057 390 3902316 44105 C/O Airport 2C ADF Containment-Consultant Services 79,022 390 3902448 62716 C/O Airport 2C New Terminal Parking 1&2 Consulting 28,140 390 3902475 62712 C/O Airport 2C New Terminal Parking 1&2 Construction 1,711,724 390 3902475 73211 C/O Airport 2C New Terminal Parking 1&2- FAA funds 2,363,680 390 3902475 44105 C/O Airport 2C Electric Fuel Tank Gauge System-Construction 25,000 390 3902602 73211 C/O Airport 2C New Terminal Furnishing&Equipment-FAA Funds 332,965 390 3902531 44105 C/O Airport 2C New Terminal Furnishing&Equipment-State Airport Grant 330,000 390 3902531 45701 C/O Airport 2C New Terminal Passenger Bridge-Construction 34,761 390 3902532 73211 C/O Airport 2C New Terminal Passenger Bridge- FAA Funds 136,065 390 3902532 44105 C/O Airport 2C New Terminal Taxiway F-Construction 2,982,375 390 3902533 73211 C/O Airport 2C New Terminal Taxiway F-FAA Funds 2,684,138 390 3902533 44105 C/O Airport 2C New Terminal Taxiway F-GO Bonds 298,237 390 3902533 54210 C/O Airport 2C New Terminal Guidance Signage-Consultant Engineers 35,348 390 3902534 62712 C/O Airport 2C New Terminal Guidance Signage- FAA Funds 146,894 390 3902534 44105 C/O Airport 2C New Terminal Guidance Signage-Signage 123,000 390 3902534 71227 C/O Airport 2C New Terminal Landscaping-Consulting 22,857 390 3902535 62712 C/O TOTAL AIRPORT CONSTRUCTION FUND 13,766,263 15,188,795 BOND PROCEEDS FUND City-Wide 7C Bond Proceeds- Bonds 303,145 440 44010440 54210 C/O TOTAL BOND PROCEEDS FUND - 303,145 SANITARY OPERATING FUND Engineering 80 Project Engineering-Cell Phone (120) 610 61055400 72418 Adjust to Actual TOTAL SANITARY OPERATING FUND (120) - STORMWATER OPERATING FUND Engineering 80 Stormwater Operating-Cellphone (60) 620 62055620 72418 Adjust to Actual Park Division 80 Bee Branch Maintenance-Landscape 8,286 620 62030440 62637 C/O Engineering 80 NPDES- Illicit Discharge- Engineering 3,153 620 62055752 62716 C/O Engineering 80 NPDES- Municipal Operation Engineering 6,158 620 62055753 62716 C/O Engineering 80 NPDES- Post Construction 12,654 620 62055756 62716 C/O Engineering 80 NPDES- Public Education- Engineering 11,621 620 62055754 62716 C/O Engineering 80 NPDES-Public Participation- Engineering 13,633 620 62055755 62716 C/O Engineering 80 Stormwater Ditch Remediation-Consultant Services 28,791 620 62055910 62716 C/O- Moved to operating from CIP Engineering 80 Streambank Rehab-Consulting 18,220 620 62055911 62716 C/O- Moved to operating from CIP Engineering 80 Detention Basin Maintenance- Lawn Care Services 20,175 620 62055920 62781 C/O- Moved to operating from CIP Engineering 80 Storm Sewer Cleaning-Property Maintenance 21,096 620 62055930 62716 C/O- Moved to operating from CIP Engineering 80 Floodwall Breach Analysis-Consulting Engineers 67,913 620 62055620 62716 C/O- Moved to operating from CIP Engineering 80 Stormwater I&I Prevention-Consulting 160,534 620 62055900 62716 C/O- Moved to operating from CIP Engineering 80 NPDES-Erosion Control (4,111) 620 62055751 62716 Prespend FY 2017 TOTAL STORMWATER OPERATING FUND 368,063 - PARKING OPERATING FUND Parking Division 80 Port of Dubuque Ramp-Hauling 5,000 630 63046350 62780 Shift from De-Icing Parking Division 80 Port of Dubuque Surface Lot- Hauling 7,500 630 63046410 62780 Shift from De-Icing Page 11 FISCAL YEAR 2017 AMENDMENT#1 CITY COUNCIL 29-Aug-16 FY 17 FY 17 Expense Revenue Department Program Description Amount Amount Fund Activity/CIP Account Explanation Parking Division 80 Iowa Street Ramp- Hauling 5,000 630 63046310 62780 Shift from Parks Parking Division 80 Iowa Street Ramp-Services From Parks (5,000) 630 63046310 62832 Shift to Hauling Parking Division 80 Port of Dubuque Ramp-Deicing (5,000) 630 63046350 62636 Shift to Hauling Parking Division 80 Port of Dubuque Surface Lot- Deicing Products (7,500) 630 63046410 62636 Shift to Hauling TOTAL PARKING OPERATING FUND - - WATER OPERATING FUND Water 80 Storage Tank Inspection-Consultant 15,000 640 64042705 62716 C/O Water 80 Auto Meter Read System Maintenance-Construction 8,330 640 64042710 73211 C/O Water 80 GIS Maintenance-Software License 14,253 640 64042730 62663 C/O Water 80 Internal Lines Loan- Engineering 25,000 640 64042750 62811 C/O Water 80 Internal Lines Loan-Construction 180,000 640 64042750 73211 C/O Water 80 Service Line Assistance-Grants 15,000 640 64042735 62731 C/O Water 80 Water Main Replacements- Engineering 56,000 640 64042755 62811 C/O Water 80 Water Main Replacements-Construction 57,044 640 64042755 73211 C/O Water 80 Water Meter Exchange-Water Meters 8,570 640 64042760 71516 C/O Water 80 Water Leak Repair Grant-Grants 8,248 640 64042765 62765 C/O Water 80 Computerized Leak Survey-Consultant 69,950 640 64042785 62716 C/O Water 80 Water Usage and System Audit-Consultant Engineers 50,322 640 64042786 62712 C/O Water 80 Water Meter Testing-Construction 25,000 640 64042790 73211 C/O Water 80 Online Process Analyzer- Equipment 14,547 640 64042792 73410 C/O TOTAL WATER OPERATING FUND 547,264 - REFUSE FUND Public Works 8C Recycling Vehicle-Equipment 179,827 670 6701533 73410 C/O Public Works 8C Security Cameras-Cameras 19,833 670 6702542 72417 C/O TOTAL REFUSE FUND 199,660 - AMERICA'S RIVER PROJECT FUND Economic Developmei 5C Art in the Port of Dubuque 57,484 700 7001853 62731 C/O TOTAL AMERICA'S RIVER PROJECT FUND 57,484 - SANITARY SEWER CONSTRUCTION FUND W&RRC 8C W&RRC Plant Renovation-Construction 269,961 710 7101837 73210 C/O W&RRC 8C W&RRC Plant Renovation-SRF Loan Proceeds 5,000 710 7101837 54230 C/O W&RRC 8C Terminal St Mag Meter Repair-Consulting Engineers 209,873 710 7102211 62712 C/O W&RRC 8C Bradley/Perry Force Main-Consulting Engineers 5,045 710 7102474 62712 C/O W&RRC 8C Bradley/Perry Force Main-Construction 90,000 710 7102474 73211 C/O W&RRC 8C Nutrient Reduction Strategy-Consulting Engineers 5,000 710 7102529 62712 C/O W&RRC 8C FOG Receiving Station-Construction 75,351 710 7102597 73210 C/O W&RRC 8C Clarifier Realign/Repair-Construction 33,765 710 7102598 73210 C/O W&RRC 8C Kerper Pump Motor/Control-Construction 35,000 710 7102599 73210 C/O W&RRC 8C Replacement of Radios 6,785 710 7102601 72410 C/O Public Works 8C Sanitary Sewer Root Foam- Miscellaneous Services 10,373 710 7101341 62731 C/O Public Works 8C Mobile GIS System- Equipment Acquisition 7,552 710 7102225 73410 C/O Engineering 8C Sewer Connection Assistance-Grants 27,456 710 7101067 62765 C/O Engineering 8C Sanitary Sewer Internal Main- Private Participant 246,000 710 7101293 53102 C/O Engineering 8C Sanitary Sewer Internal Main-Construction 246,000 710 7101293 73211 C/O Engineering 8C Lateral Replacement Assistance-Construction 8,332 710 7101297 73211 C/O Engineering 8C Sewer Lateral Assistance- Engineering Division 46,448 710 7101309 62811 C/O Page 12 FISCAL YEAR 2017 AMENDMENT#1 CITY COUNCIL 29-Aug-16 FY 17 FY 17 Expense Revenue Department Program Description Amount Amount Fund Activity/CIP Account Explanation Engineering 8C Sewer Lateral Assistance-Construction 49,056 710 7101309 73211 C/O Engineering 8C Laterals-I&I Reduction- Engineering Division 10,000 710 7101320 62811 C/O Engineering 8C Laterals-I&I Reduction-Construction 77,650 710 7101320 73211 C/O Engineering 8C Loras-Walnut to Prairie St-Construction 41,416 710 7101328 73211 C/O Engineering 8C Sanitary Sewer Lining Program-Construction 68,855 710 7101637 73211 C/O Engineering 8C Street Program Sanitary- Engineering 13,955 710 7101638 62811 C/O Engineering 8C Street Program Sanitary-Construction 130,283 710 7101638 62811 C/O Engineering 8C Monroe Sanitary-Construction 6,947 710 7101797 73211 C/O Engineering 8C Brunswick Sanitary- Engineering 8,203 710 7102232 62811 C/O Engineering 8C Brunswick Sanitary-Construction 59,223 710 7102232 73211 C/O Engineering 8C Hawthorne Sanitary- Engineering 4,000 710 7102322 62811 C/O Engineering 8C Hawthorne Sanitary-Construction 15,276 710 7102322 73211 C/O Engineering 8C Knob Hill-Duggan Dr Sanitary- Engineering 15,000 710 7102323 62811 C/O Engineering 8C Knob Hill-Duggan Dr Sanitary-Construction 94,565 710 7102323 73211 C/O Engineering 8C Granger Creek Sanitary-Construction 445,606 710 7102409 73211 C/O Engineering 8C Cedar Lift Pump/Generator/Trailer 114,539 710 7102412 73211 C/O Engineering 8C $9.4M Green Alleys-Construction 656,389 710 7102450 73211 C/O Engineering 8C $9.4M Green Alleys-SRF Loan Proceeds 3,425,457 710 7102450 54230 C/O Engineering 8C Sanitary Connection Fee-Construction 30,000 710 7102545 73211 C/O Engineering 8C Track Line Sanitary Sewer-Engineering 21,385 710 7102546 62811 C/O Engineering 8C Track Line Sanitary Sewer-Construction 229,200 710 7102546 73211 C/O Engineering 8C Washington St 7th to 9th- Engineering 47,176 710 7102547 62811 C/O Engineering 8C Washington St 7th to 9th-Construction 170,456 710 7102547 73211 C/O Engineering 8C Auburn &Custer Sanitary- Engineering 34,643 710 7102571 62811 C/O Engineering 8C Auburn &Custer Sanitary-Construction 212,580 710 7102571 73211 C/O Engineering 8C Cedar/Terminal Assessments-Construction 116,807 710 7102606 73211 C/O Engineering 8C Catfish/Granger Lift Improvements-Construction 86,072 710 7102607 73211 C/O Engineering 8C Private Water/Sewer Purchase-Construction 66,306 710 7102633 73211 C/O Engineering 8C Lake Eleanor Lift Station-Construction 89,816 710 7102638 73211 C/O Engineering 8C Sewer Extensions New Development-Construction 201,421 710 7101350 73211 C/O-$61,623 shift from 7102408 Engineering 8C Kerper Sanitary- Engineering (16,332) 710 7102663 62811 Prespend FY 2017 Engineering 8C Kerper Sanitary-Construction (10,050) 710 7102663 73211 Prespend FY 2017 TOTAL SANITARY SEWER CONST FUND 4,167,384 3,676,457 STORM WATER CONSTRUCTION FUND Park Division 4C EPP-Storm Sewer-Construction 79,597 720 7202301 73211 C/O Public Works 8C Purina Drive Floodwall-Consulting Engineers 5,000 720 7202480 62712 C/O Public Works 8C Purina Drive Floodwall-Construction 12,400 720 7202480 73211 C/O Public Works 8C Mobile GIS System- Equipment Acquisition 7,552 720 7202225 73410 C/O Engineering 8C Stormsewer Improvement-Construction 78,583 720 7201008 73211 C/O Engineering 8C Catfish Creek Bridge-Construction 13,357 720 7202693 73211 C/O-shift from 7201066 Engineering 8C Catch BasinA/Vestside Storage-Engineering 4,241 720 7201081 62811 C/O Engineering 8C Catch BasinA/Vestside Storage-Construction 30,000 720 7201081 73211 C/O Engineering 8C Kaufmann Avenue Storm- Engineering 6,483 720 7201085 62811 C/O Engineering 8C Kaufmann Avenue Storm- Land Acquisition 3,000 720 7201085 73110 C/O Engineering 8C Kaufmann Avenue Storm-Construction 37,999 720 7201085 73211 C/O Engineering 8C Drain Tile Program-Engineering 1,783 720 7201354 62811 C/O Engineering 8C Drain Tile Program-Construction 44,583 720 7201354 73211 C/O Engineering 8C Detention Basin Maintenance-Lawn Care Services (11,480) 720 7201359 62781 Remove Encumbrances Engineering 8C Gunite Rock Storm Sewer-Engineering 5,000 720 7201363 62811 C/O Page 13 FISCAL YEAR 2017 AMENDMENT#1 CITY COUNCIL 29-Aug-16 FY 17 FY 17 Expense Revenue Department Program Description Amount Amount Fund Activity/CIP Account Explanation Engineering 8C Gunite Rock Storm Sewer-Construction 50,981 720 7201363 73211 C/O Engineering 8C S Grandview(Cangenelli)- Engineering 20,000 720 7202632 62811 C/O-Shift from 7201437 Engineering 8C S Grandview(Cangenelli)-Construction 130,000 720 7202632 73211 C/O-Shift from 7201437 Engineering 8C Bee Branch-Construction (1,944,500) 720 7201654 73211 Prespend FY 2017 Engineering 8C Bee Branch-Construction (9,785,850) 720 7201654 73211 Adjust to Actual Engineering 8C Bee Branch-SRF Loan Proceeds (1,148,212) 720 7201654 54230 Adjust to Actual Engineering 8C Bee Branch- Federal Pass Thru Grant 778,262 720 7201654 45771 DMATS&NSB to be received in FY 1 Engineering 8C Bee Branch- EDA Grant 721,180 720 7201654 44115 Remaining to be Received Engineering 8C Bee Branch-State Grant (2,303) 720 7201654 45701 Received in FY16,reduce amount to t Engineering 8C Bee Branch-Vision Iowa Grant 508,836 720 7201654 45761 Addtl to be received in FY 17 Engineering 8C Storm Sewer Cleaning- Property Maintenance (6,165) 720 7201659 62431 Remove Encumbrances Engineering 8C Villa St Storm Sewer-Engineering 11,369 720 7201809 62811 C/O Engineering 8C Villa St Storm Sewer-Construction 94,884 720 7201809 73211 C/O Engineering 8C Catfish Creek Bridge-Construction 48,392 720 7202693 73211 C/O-shift from 7202015 Engineering 8C Hillcrest/Keyway Storm-Consulting Engineers 4,300 720 7202016 62712 C/O Engineering 8C Hillcrest/Keyway Storm-Construction 30,000 720 7202016 73211 C/O Engineering 8C Catfish Creek Bridge-Construction 11,567 720 7202693 73211 C/O-shift from 7202044 Engineering 8C Floodwall Breach Analysis-Consulting Engineers (37,399) 720 7202239 62712 Remove Encumbrances Engineering 8C Catfish Creek Watershed Partnership-Construction 700,000 720 7202331 73211 C/O Engineering 8C Catfish Creek Watershed Partnership-State Grant 700,000 720 7202331 45701 C/O Engineering 8C Stormwater I&I-Construction 18,589 720 7202332 73211 C/O Engineering 8C Windsor Storm-Construction 39,447 720 7202414 73211 C/O Engineering 8C Washington 7th to 9th-Engineering 5,000 720 7202547 62811 C/O Engineering 8C Washington 7th to 9th-Construction 33,456 720 7202547 73211 C/O Engineering 8C Center Grove Storm- Engineering 8,625 720 7202550 62811 C/O Engineering 8C Center Grove Storm-Construction 58,000 720 7202550 73211 C/O Engineering 8C Admiral Sheehy Flood Gate-Engineering 8,000 720 7202610 62811 C/O Engineering 8C Admiral Sheehy Flood Gate-Construction 38,000 720 7202610 73211 C/O Engineering 8C Ice Harbor/Maus Pump- Engineering 75,000 720 7202629 62811 C/O TOTAL STORM WATER CONST FUND (10,070,206) 1,557,763 PARKING CONSTRUCTION FUND Parking Division 8C Sealcoat Lots-Construction 126,937 730 7301380 73211 C/O Parking Division 8C Major Maintenance on Ramps-Construction 57,607 730 7301385 73210 C/O Parking Division 8C Parking Meter Replacement- Equipment 11,623 730 7301944 73410 C/O Parking Division 8C Parking Ramp OCC Cert-Consulting Engineers 14,435 730 7302046 62712 C/O Parking Division 8C Port of Dubuque Ramp Maint-Construction 285,491 730 7302162 73211 C/O Parking Division 8C 5 Flags Ramp Relight-Consulting Engineers 92,099 730 7302563 62712 C/O TOTAL PARKING CONSTRUCTION FUND 588,192 - WATER CONSTRUCTION FUND Water 8C Water Main Extension Annexation-Consulting Engineers 3,051 740 7401411 62712 C/O Water 8C Water Main Extension Annexation-Construction 461,841 740 7401411 73211 C/O Water 8C Roosevelt Road Main Extension-Construction 815,165 740 7401672 73211 C/O Water 8C Green Alley Pilot Project-Construction 88,102 740 7402044 73211 C/O Water 8C Online Process Analyzer-Equipment 15,070 740 7402524 73410 C/O Water 8C SRF Green Alley-Construction 318,846 740 7402526 73211 C/O Water 8C Generator-Construction 230,263 740 7402527 73211 C/O Water 8C SW Arterial-Construction 530,351 740 7402594 73211 C/O Water 8C Creek Crossing Restoration-Consulting 10,893 740 7402595 62716 C/O Page 14 FISCAL YEAR 2017 AMENDMENT#1 CITY COUNCIL 29-Aug-16 FY 17 FY 17 Expense Revenue Department Program Description Amount Amount Fund Activity/CIP Account Explanation Water 8C Creek Crossing Restoration-Construction 36,055 740 7402595 73211 C/O Water 8C Main Relocate Sewer Manhole-Construction 20,094 740 7402596 73211 C/O Water 8C Private Water Purchase- Pay to Other Agency 14,511 740 7402633 62761 C/O Water 8C Private Water Purchase-Construction 143,202 740 7402633 73211 C/O Water 8C Airport SCADA System-Software 14,555 740 7402641 71123 C/O TOTAL WATER CONSTRUCTION FUND 2,701,999 - GARAGE INTERNAL SERVICE FUND Public Works 80 Garage Service-Vehicle Hoist 29,000 810 81054600 71535 C/O TOTAL GARAGE INTERNAL SERVICE FUND 29,000 - LANDFILL FUND Public Works 9C Landfill Short-Term Facilities-Consultant Services 781,547 940 9402685 62716 C/O Public Works 9C Landfill Environment Management-Construction 44,393 940 9402268 73211 C/O TOTAL LANDFILL FUND 825,940 - TRANSFERS Transfer Out Transfer In Park Division Trans3 Transfer from General Const Fund to General Fund 11,975 102 1021151 59360 Transfer Funds Park Division Trans6 Transfer from General Const Fund to General Fund 200,665 102 1022292 59360 Transfer Funds Engineering Trans24 Transfer from Road Use Tax to Street Const Fund 512,418 300 3002021 59250 Transfer Funds Park Division Trans4 Transfer from Bond Proceeds to Sales Tax Const Fund 86,500 350 3501767 59440 Transfer Funds Fire Trans1 Transfer from Bond Proceeds to Sales Tax Const Fund 216,645 350 3502507 59440 Transfer Funds Public Info/GIS Trans28 Transfer from Street Construction to Sales Tax Const 28,198 350 3502564 59300 Transfer Funds Park Division Trans2 Transfer from GDTIF to General Construction Fund 50,000 360 3601105 59240 Transfer Funds Housing&Community Trans27 Transfer from N Cascade Housing to General Const 65,543 360 3601595 59215 Transfer Funds Park Division Trans5 Transfer from DICW to General Const Fund 10,000 360 3601774 59210 Transfer Funds Park Division Trans29 Transfer from N Cascade Housing to General Const 150,000 360 3602375 59215 Transfer Funds Engineering Trans25 Transfer from GDTIF to General Construction Fund 327,000 360 3602494 59240 Transfer Funds Water Trans7 Transfer from Water Fund to General Const Fund 253,000 360 3602594 59740 Transfer Funds Airport Trans9 Transfer from Sales Tax Const to Airport Const Fund 1,650 390 3901060 59350 Transfer Funds Airport Trans8 Transfer from Sales Tax Const to Airport Const Fund 23,260 390 3901448 59350 Transfer Funds Airport Trans10 Transfer from Passenger Facility to Airport Const Fund 134,305 390 3901891 59391 Transfer Funds Airport Trans11 Transfer from Sales Tax Const to Airport Const Fund 49,800 390 3901893 59350 Transfer Funds Airport Trans12 Transfer from Sales Tax Const to Airport Const Fund 26,663 390 3902008 59350 Transfer Funds Airport Trans13 Transfer from Passenger Facility to Airport Const Fund 80,210 390 3902009 59391 Transfer Funds Airport Trans14 Transfer from Sales Tax Const to Airport Const Fund 22,000 390 3902125 59350 Transfer Funds Airport Trans15 Transfer from Sales Tax Const to Airport Const Fund 38,000 390 3902126 59350 Transfer Funds Airport Trans16 Transfer from Customer Facility Charge to Airport Const 72,547 390 3902213 59252 Transfer Funds Airport Trans17 Transfer from Sales Tax Const to Airport Const Fund 35,000 390 3902215 59350 Transfer Funds Airport Trans18 Transfer from Customer Facility Charge to Airport Const 245,517 390 3902316 59252 Transfer Funds Airport Trans20 Transfer from Sales Tax Const to Airport Const Fund 70,328 390 3902535 59350 Transfer Funds Airport Trans21 Transfer from Sales Tax Const to Airport Const Fund 16,106 390 3902538 59350 Transfer Funds Airport Trans19 Transfer from General Fund to Airport Const Fund 25,000 390 3902602 59102 Transfer Funds Economic Developmei Trans26 Transfer From General Fund to America's River Fund 62,754 700 7001853 59100 Transfer Funds Engineering Trans22 Transfer from General Fund to Sanitary Sewer Fund 22,801 710 7101067 59101 Transfer Funds Engineering Trans23 Transfer from General Fund to Sanitary Sewer Fund 1,876 710 7101067 59102 Transfer Funds Economic Developmei Trans26 Transfer From General Fund to America's River Fund 62,754 100 10010100 91700 Transfer Funds Engineering Trans22 Transfer from General Fund to Sanitary Sewer Fund 22,801 101 10110101 91710 Transfer Funds Airport Trans19 Transfer from General Fund to Airport Const Fund 25,000 102 10210102 91390 Transfer Funds Engineering Trans23 Transfer from General Fund to Sanitary Sewer Fund 1,876 102 10210102 91710 Transfer Funds Page 15 FISCAL YEAR 2017 AMENDMENT#1 CITY COUNCIL 29-Aug-16 FY 17 FY 17 Expense Revenue Department Program Description Amount Amount Fund Activity/CIP Account Explanation Park Division Trans5 Transfer from DICW to General Const Fund 10,000 210 21060210 91360 Transfer Funds Housing&Community Trans27 Transfer from N Cascade Housing to General Const 65,543 215 21560215 91360 Transfer Funds Park Division Trans29 Transfer from N Cascade Housing to General Const 150,000 215 21560215 91360 Transfer Funds Park Division Trans2 Transfer from GDTIF to General Construction Fund 50,000 240 24060240 91360 Transfer Funds Engineering Trans25 Transfer from GDTIF to General Construction Fund 327,000 240 24060240 91360 Transfer Funds Engineering Trans24 Transfer from Road Use Tax to Street Const Fund 512,418 250 25010250 91300 Transfer Funds Airport Trans16 Transfer from Customer Facility Charge to Airport Const 72,547 252 25210252 91390 Transfer Funds Airport Trans18 Transfer from Customer Facility Charge to Airport Const 245,517 252 25210252 91390 Transfer Funds Public Info/GIS Trans28 Transfer from Street Construction to Sales Tax Const 28,198 300 30010300 91350 Transfer Funds Airport Trans8 Transfer from Sales Tax Const to Airport Const Fund 23,260 350 35010350 91390 Transfer Funds Airport Trans9 Transfer from Sales Tax Const to Airport Const Fund 1,650 350 35010350 91390 Transfer Funds Airport Trans11 Transfer from Sales Tax Const to Airport Const Fund 49,800 350 35010350 91390 Transfer Funds Airport Trans12 Transfer from Sales Tax Const to Airport Const Fund 26,663 350 35010350 91390 Transfer Funds Airport Trans14 Transfer from Sales Tax Const to Airport Const Fund 22,000 350 35010350 91390 Transfer Funds Airport Trans15 Transfer from Sales Tax Const to Airport Const Fund 38,000 350 35010350 91390 Transfer Funds Airport Trans17 Transfer from Sales Tax Const to Airport Const Fund 35,000 350 35010350 91390 Transfer Funds Airport Trans20 Transfer from Sales Tax Const to Airport Const Fund 70,328 350 35010350 91390 Transfer Funds Airport Trans21 Transfer from Sales Tax Const to Airport Const Fund 16,106 350 35010350 91390 Transfer Funds Park Division Trans3 Transfer from General Const Fund to General Fund 11,975 360 36010360 91102 Transfer Funds Park Division Trans6 Transfer from General Const Fund to General Fund 200,665 360 36010360 91102 Transfer Funds Airport Trans10 Transfer from Passenger Facility to Airport Const Fund 134,305 391 39110391 91390 Transfer Funds Airport Trans13 Transfer from Passenger Facility to Airport Const Fund 80,210 391 39110391 91390 Transfer Funds Fire Trans1 Transfer from Bond Proceeds to Sales Tax Const Fund 216,645 440 44010440 91350 Transfer Funds Park Division Trans4 Transfer from Bond Proceeds to Sales Tax Const Fund 86,500 440 44010440 91350 Transfer Funds Water Trans7 Transfer from Water Fund to General Const Fund 253,000 740 74010740 91360 Transfer Funds TOTAL TRANSFERS 2,839,761 2,839,761 45,721,314.00 47,335,806.00 ENCUMBRANCE C/O's 35,793,871 Back out Non Budgeted Encumber Rollovers Total Amend#1 with Enc,C/O's,and New 81,515,185 47,335,806 Page 15 31 -288 CITY BUDGET AMENDMENT AND CERTIFICATION RESOLUTION - FY 2017 - AMENDMENT #1 To the Auditor of DUBUQUE County, Iowa: The City Council of Dubuque in said County/Counties met on 09/19/2016 ,at the place and hour set in the notice, a copy of which accompanies this certificate and is certified as to publication. Upon taking up the proposed amendment, it was considered and taxpayers were heard for and against the amendment. The Council, after hearing all taxpayers wishing to be heard and considering the statements made by them, gave final consideration to the proposed amendment(s) to the budget and modifications proposed at the hearing, if any. thereupon, the following resolution was introduced. RESOLUTION No. 333-16 A RESOLUTION AMENDING THE CURRENT BUDGET FOR THE FISCAL YEAR ENDING JUNE 30 2017 (AS AMENDED LAST ON N/A .) Be it Resolved by the Council of the City of Dubuque Section 1. Following notice published 09/08/2016 and the public hearing held, 09/19/2016 the current budget (as previously amended) is amended as set out herein and in the detail by fund type and activity that supports this resolution which was considered at that hearing: Passed this Signatun City Clerk/Finance Officer 19 (Day) day of Mayor Pro -Tem Total Budget as certified.Current or last amende Amendment Total Budget after Current Amendment Revenues & Other Financing Sources 0 25,555,634 Taxes Levied on Property 1 25,555,634 Less: Uncollected Property Taxes -Levy Year 2 0 0 0 Net Current Property Taxes 3 25,555,634 0 25,555,634 Delinquent Property Taxes 4 0 0 0 TIF Revenues 5 11,112,649 '0 11,112,649 Other City Taxes 6 18,106,679 0 18,106;679 Licenses & Permits 7 1,505,981 0 1,505,981 Use of Money and Property 8 12,893,350 0 12,893,350 Intergovernmental 9 34,561,978 40,077,845 74,639,823 Charges for Services 10 59,462,089 41,860 59,503,949 Special Assessments 11 0 0 0 Miscellaneous 12 1,705,918 490,719 2,196,637 Other Financing Sources 13 14,996,651 3,885,621 18,882,272 Transfers In 14 28,536,128 2,839,761 31,375,889 Total Revenues and Other Sources 15 208,437„057 47,335,806 255,772,863 Expenditures & Other Financing Uses 29,240,936492,119 29,733,055 Public Safety 16 Public works 17 13,514,802 920,463 14,435,265 Health and Social Services 18 994,825 51,323 1,046,148 Culture and Recreation 19 11,967,321 618,540 12,585,861 Community and Economic Development 20 14,203,680 123,069 14,326,749 GeneralGovemment 21 9,131,313 377,493 9,508,806 Debt Service 22 10,088,563 0 10,088,563 Capital Projects 23 27,315,838 52,457,784 79,773,622 Total Government Activities Expenditures 24 116,457,278 55,040,791 171,498,069 Business Type / Enterprises 25 68,698,070 22,808,693 . 91,506,763 Total Gov Activities & Business Expenditures 26 185,155,348 77,849,484 263,004,832 Transfers Out 27 28,536,128 2,839,761 31,375,889 Total Expenditures/Transfers Out 28 213,691,476 80,689,245 294,380,721 Excess Revenues & Other Sources Over (Under) Expenditures/Transfers Out Fiscal Year 29 -5,254,419 -33,353,439 -38,607,858 ..... . .... ................30 Beginning Fund Balance July1. 29,641,135 46,223,249 75,864,384 Ending Fund Balance June 30 31 24,386,716 12,869,810 37,256,526 Passed this Signatun City Clerk/Finance Officer 19 (Day) day of Mayor Pro -Tem STATE OF IOWA {SS: DUBUQUE COUNTY CERTIFICATION OF PUBLICATION I, Suzanne Pike, a Billing Clerk for Woodward Communications, Inc., an Iowa corporation, publisher of the Telegraph Herald,a newspaper of general circulation published in the City of Dubuque, County of Dubuque and State of Iowa; hereby certify that the attached notice was published in said newspaper on the following dates: September 08, 2016, and for which the charge is $191.88. Subscribed to before me, a Wary Public in and for Dubuque County, Iowa, this day o , 20 ✓� Notary Public in and for ubuque County, Iowa. ,0A1 MARY K.WESTERMEYER f� Commission Number 154885 ,num hiy Comm, Exp. FEB. 1.2017 NOTICEbF PUBLIC HEARING AMENDMENT`OF FY2016-2017 CITY BUDGET" The City Council of .:Dubuque mx DUBUQUE County,Iowa will meet at •' City Council Chambers at the'Hisforic Federal Building - at 6100 p.m. _ on 0911,9120116 (hour) (Date) ,for the purpose of amending the current budget of the city for the fiscal year ending June 3, 0,,;.:,: ;;2017__ (year) bychanging estimates of revenue and expenditure.appropriationsin the:follow n'gprograms for the reasons ' _,. given.Additional detail is available at the city,clerk's office showing revenues and expenditures by fund type ` and by activity. "x k r ` "» "rxa Total Budget Total Budget as.certified Current after Current or last.amended Amendment Amendment Revenues&Other Financing Sources Taxes Levied on Property. 1 25,555,634 0 25,555,634 Less`.Uncollected:Property Taxes-Levy Year 2 0 ^io . " Net Current Property Taxes 3 25,555,634 0 25,5551634 Delinquent Property Taxes 4 0 _ 0 0 TIF Revenues 5 11,112,649 _0 .- 11,112,649 , Other City Taxes6 18,106,67,9 0 ;18,106;,679 Licenses&,Permits 7 1,505,981' ,- ,.I,, 6', 1,505,981, Use.of Money and Property, 8 12,893,350 ; ,. p 12,893;350 Intergovemmentah 9" , "`34,561,978 40,077,845 74,639,823; Charges for Services 10 59,462;089 41,860 59,5034949 Special,Assessments „ 11 0 0 0 Miscellaneous 12 1,705,918 490,719 21196;637 Other Financing Sources13 14,996,651 3,885;621 18,882,272 Tran fers In, 14 f ;28,536;128 ` 2;839;761 "31,375,889 Total Revenues and Other Sources 15 208,437,057 47;335,806 '.255;772,$63 Expenditures&"Other Financing Uses 1r " ? a k Public Safety`' - .16 29,240,936 492,11.9 -29,733,055, Public Works? 1;7, 13 514;802 920,463 14,435;265; Health,and Social Services 18 994;825 51;323 :1,046,148 Culture and Recreation ..19 x '11,967,321 " =618,540 1'`12585;861 Community and Economic Development 20 14,203,680 123,069 14,326;749 Plan eral,Government21 9,1`31,313 377,;493 9,508,806 Debt Service 22 10,088,563 " 0 .10,088;563: Capital,Projects :LL 23 27,315,838 ' 52,457„784 79,773;622' Total Gov emmentActivities Expenditures 24 116,457,278 55,040;791 971;498;069 698 070 Business,Type%Enterprises „ ,,25, , .... 808;693 .... "91,506;763 Total-Gov Activities:& Expenditures 26 185,1"55,348 77,849;484 , , 263,004;;832 Transfers,Ogt, :` 27 28,536,128 2,839;761 "31,375,889 Total Expenditures/Transfers Out 28 ,• 213169„1,476 80,6894245 294;380,721` Excess Revenues&Other Sources Over Under Ex enditures/Transfers Out for Fiscal YearN 29 5,254,419 33,353,43 � � P - ,439 i -38,607;858 Beginning Fund Balance July 1 H, 30 - '29,641,135 46,223,249 75,864;384 Ending Fund Balance June 30 31 24,386,il6 12,869,810 37,256;526 w Explanation of increases or decreases in revenue estimates appropriations oravailable cash: „y� t'c 4. y4h1'wh\* fir* -rm4,,!a f� « >n^, ,rug� This'amendme ifadds capital budget`'carryovers'of$51,588',789'&'associated revenue of$41,273,732&encumbrance carryovers of•$35;793;871,(cont numg appropriation-authority).{•_Adds operatic b d etilcarryovers of$2,172,862& associated revenue of$2,103,595„requiring a'formal amendment. Also"included;is$11;706;038 in reduction'in expense` due to prespending the Fiscal Year2017 budget and reducing the BeeBranch project for the Railroad,portiorn.Revenue increase-of$1 118,718 related to grants.Interfund transfers of$2,839,761. There will be`no increase in tax levies to be paid in the current fiscal year named above..Any increase in - expenditures'setout;above•-will be met from the increased non-property and-cash balances not budgeted or considered in this current budget- This'will provide fora balanced.budget ir . Kevin F.imstahl,City Clerk"'! City Clerk/Finance Officer '1t gig ;adno=650764-01