The URL can be used to link to this page

FY 2015 Budget Amendment No. 1_Public HearingTHE CITY OF Dui Masterpiece on the Mississippi TO: The Honorable Mayor and City Council Members FROM: Michael C. Van Milligen, City Manager SUBJECT: Fiscal Year 2015 First Budget Amendment DATE: September 8, 2014 Dubuque band AI -America City r 2007 • 2012 • 2013 Budget Director Jennifer Larson is recommending approval of the first Fiscal Year 2015 Budget Amendment, which amends the Fiscal Year 2015 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 2014 budget carryovers to Fiscal Year 2015 of encumbrances totaling $27,595,394, capital projects totaling $68,366,145 that were not completed during the prior Fiscal Year, and associated revenues totaling $55,439,820. There are operating budget appropriation carryovers of $575,567 and operating receivables of $1,239,834. Also, total transfers between funds of $5,338,148 are reflected. Pr, Michel 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 THE CITY OF Dust Masterpiece on the Mississippi TO: Michael C. Van Milligen, City Manager FROM: Jennifer Larson, Budget Director SUBJECT: Fiscal Year 2015 First Budget Amendment DATE: September 8, 2014 Dubuque band AI -America City 1111 r 2007 • 2012 •2013 The purpose of this memorandum is to provide an explanation regarding the first amendment for Fiscal Year 2015. This amendment is two fold. First, it amends the Fiscal Year 2015 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 2014 budget carryovers to Fiscal Year 2015 of encumbrances totaling $27,595,394, capital projects totaling $68,366,145 that were not completed during the prior Fiscal Year, and associated revenues totaling $55,439,820. There are operating budget appropriation carryovers of $575,567 and operating receivables of $1,239,834. Also, total transfers between funds of $5,338,148 are reflected. CARRYOVER AMENDMENT TO FISCAL YEAR 2015 During Fiscal Year 2014, a large number of projects were completed, which include Police Radio Accessories Replacement, Police Storage Area Network, Police Power Over Ethernet, Police Drug Task Force Car Replacement, Fire Ambulance Replacement, Improvements to Fire Headquarters, Improvements to Station 4, Fire Mobile Data/Wireless Network, Fire Portable Radio Accessories, Usha Park Parking Lot, Park Mulch/Flower Replacement, Eagle Point Park Paint Bridger/Veranda/Indian Room, Greenhouse Vent System, Lincoln Avenue Spillway Replacement, Allison -Henderson Exterior Improvements, McAleece Replace Plumbing, Electronic Locks on Restrooms, McAleece Sidewalks, Five Flags AudioNisual Sound Equipment, Grand River Center Replace Chairs, Grand River Center Fabric Wall Coverings, Grand River Center Outdoor Sign, Grand River Center Upgrade AudioNisual Equipment, Grand River Center Security Cameras, Grand River Center Replace Sink and Urinal Controls, Grand River Center Floor Vacuums, Grand River Center Recycling Containers, Grand River Center Copy Machine Replacement, Grand River Center Window Cleaning System, Bunker Hill Windows, Pool Bath House Improvements, Bunker Chemical Storage, Library Replace Sidewalks and Steps, Library Exterior Signage, Water Main Replacements, Bunker Hill Pump Station, Asbury Tank Painting, Water Main Relocation, Water Resource and Recovery Plant Co -Gen, Pumping Station Telemetry, Locust Street Parking Ramp Repair, Airport Field Drain Replacements, Airport Runway Painting, Public Works Asphalt Milling Program, Recycling Truck Replacement, Cold Storage Building Mezzanine, Wayfinding Sign Replacements, High Pressure Sewer Jet, Purina Drive Dock Replacement, Brunskill Road Bridge Replacement, Traffic Controller Replacement, Sanitary Sewer Manhole Replacement, Sidewalk Program City Owned, Tourism Signage Port of Dubuque, Street Light Replacement, Downtown Street Light Replacement, Decorative Concrete Maintenance, Sanitary Sewer Lining, Railroad Crossing Improvements, Pavement Marking, Relocation 30" Sanitary Sewer Main at Old Public Works Garage, Flood Plain Buyout, Street Camera Installation, One Way to Two Way Conversion, Downtown Security Cameras, Elm Complete Street, City Hall Tuckpointing, 5th Street Restroom, Kiosk Map Replacements, Digitize Dubuque City Director, All -America City Award, Conference Room Flat Monitors, Storage Area Network Upgrade, City -Wide Multifunction Printer Replacement, Data Domain Upgrade and City -Wide Computer Replacements. Many other enhancements are reflected throughout the community. Some significant projects were started and remain in process, which are carried forward into Fiscal Year 2015. The most significant of the capital project expenditure carryovers, including associated revenue, are: Airport Terminal ($10,450,608); Bee Branch Reconstruction ($7,390,109); $9.4 Million Green Alleys ($7,363,186); South Siegert Farm ($3,576,894); Millwork District Parking Improvements ($3,237,694); Sanitary Extension to Airport ($2,709,989);Intermodal Facility ($2,078,164); Water Extension to Airport ($1,930,611); Cedar Cross Reconstruction ($1,743,604); Multicultural Family Center Second Floor Renovation ($1,556,807); EB Lyons Expansion ($1,512,216); N Cascade Reconstruction ($1,479,979); Washington Neighborhood Downtown Incentives ($1,437,325); Downtown Housing Incentives ($1,227,240); Downtown TIF Loan Pool ($941,843); Millwork District Incentives ($670,000); Port of Dubuque Ramp Repairs ($620,736); University and Asbury Intersection ($463,539); Sanitary Sewer Improvements ($10,262,922); Water Improvements ($661,847); Stormwater Improvements ($3,207,465); and Community Development Block Grant funded projects ($483,882). OPERATING BUDGET CARRYOVER AMENDMENT The most significant operating budget carryovers into Fiscal Year 2014 include such items as Police Officer Training ($16,000); Police Department Grants ($97,670); Emergency Communications Overtime related to new software ($10,000); Airport Operations Radar Contract ($25,000); Airport FY14 Improvement Packages ($31,550); Human Rights Fair Housing Grant Appropriation ($20,445); Housing Every Child 1 Every Promise Grant Program ($75,000); Circles Program Grant ($24,908); Building Alley Lighting Grants ($34,900); Franchise Fee Refund ($57,392); Landscape Multicultural Family Center Planters ($9,800); AmeriCorps Grant ($14,976); and Community Development Block Grant ($2,266). FIRST AMENDMENT TO THE FISCAL YEAR 2015 CERTIFIED BUDGET There have been numerous actions by City Council and changes requiring amendments for the Fiscal Year 2015 budget. The capital budget amendments total an increase of $8,199,055, with an increase in associated revenue of $7,640,624. The amendment items include: Water Extension to Airport ($2,953,451) partially funded by a new borrowing of $1,592,970 which will be supported by a 2% rate increase in Fiscal Year 2016 and reallocation from other Water -2- projects; English Mill Water Extension ($1,945,700); Bus Storage Facility ($4,147,654); and Reconstruction of Signals at JFK/Wacker ($221,500) funded by reallocation from other traffic projects. OPERATING BUDGET AMENDMENT The operating budget amendments total a reduction of $206,798 due to decreasing the budgeted wage increase of 1.75% to the actual wage increase of 1.50%. The action step is for City Council to adopt the attached resolution approving the FY 2015 first budget amendment. Attachments JML -3- 31-288 CITY BUDGET AMENDMENT AND CERTIFICATION RESOLUTION To the Auditor of DUBUQUE County, Iowa: The City Council of Dubuque in said County/Counties met on 09/15/2014 ,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. 2 9 5 -14 A RESOLUTION AMENDING THE CURRENT BUDGET FOR THE FISCAL YEAR ENDING JUNE II 2015 (AS AMENDED LAST ON Be it Resolved by the Council of the City of Dubuque Section 1. Following notice published 09/05/2014 and the public hearing held, 09/15/2014 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: Total Budget as certified or last amended Current Amendment Total Budget after Current Amendment Revenues & Other Financing Sources Taxes Levied on Property 1 24,011,071 0 24,011,071 Less: Uncollected Property Taxes -Levy Year 2 0 0 0 Net Current Property Taxes 3 24,011,071 0 24,011,071 Delinquent Property Taxes 4 0 0 0 TIF Revenues 5 10,622,261 0 10,622,261 Other City Taxes 6 14,959,338 0 14,959,338 Licenses & Permits 7 1,344,102 0 1,344,102 Use of Money and Property 8 12,903,511 135,000 13,038,511 Intergovernmental 9 54,838,264 12,501,032 67,339,296 Charges for Services 10 37,704,466 1,000 37,705,466 Special Assessments 11 32,000 774,748 806,748 Miscellaneous 12 8,512,439 1,640,651 10,153,090 Other Financing Sources 13 68,220,993 54,605,995 122,826,988 Total Revenues and Other Sources 14 233,148,445 69,658,426 302,806,871 Expenditures & Other Financing Uses Public Safety 15 28,145,634 268,669 28,414,303 Public Works 16 12,382,658 263,595 12,646,253 Health and Social Services 17 1,125,838 27,855 1,153,693 Culture and Recreation 18 11,730,605 152,934 11,883,539 Community and Economic Development 19 13,443,888 162,040 13,605,928 General Government 20 7,832,880 125,847 7,958,727 Debt Service 21 8,982,241 135,000 9,117,241 Capital Projects 22 36,838,327 44,720,411 81,558,738 Total Government Activities Expenditures 23 120,482,071 45,856,351 166,338,422 Business Type / Enterprises 24 80,456,566 58,673,012 139,129,578 Total Gov Activities & Business Expenditures 25 200,938,637 104,529,363 305,468,000 Transfers Out 26 38,334,309 5,338,148 43,672,457 Total Expenditures/Transfers Out 27 239,272,946 109,867,511 349,140,457 Excess Revenues & Other Sources Over (Under) Expenditures/Transfers Out Fiscal Year 28 -6,124,501 -40,209,085 -46,333,586 Beginning Fund Balance July 1 29 67,083,198 40,209,085 107,292,283 Ending Fund Balance June 30 30 60,958,697 0 60,958,697 tignature City Clerk/Finance Officer d this 15 (Day) day of September 4,6; Signature Mayor FISCAL YEAR 2015 AMENDMENT #1 CITY COUNCIL 26 -Aug -14 FY 15 FY 15 Expense Revenue Department Program Description Amount Amount Fund ActivitylClP Account Explanation GENERAL FUND Police Department 1 Mobile Data Terminals - Micro -computer 60,841 100 1001120 71124 C/O Police Department 1 Administration - Full time employees 4,276 100 10011100 61010 Adjust to Actual Police Department 1 Administration -IPERS 60 100 10011100 61310 Adjust to Actual Police Department 1 Administration - MFPRSI 1,096 100 10011100 61370 Adjust to Actual Police Department 1 Administration - Social Security 90 100 10011100 61320 Adjust to Actual Police Department 1 Administration - Life Insurance 9 100 10011100 61416 Adjust to Actual Police Department 1 Administration - Wage Adjustment (6,425) 100 10011100 61099 Adjust to Actual Police Department 1 DARE - Full time employees (1,429) 100 10011180 61010 Adjust to Actual Police Department 1 DARE - Holiday Pay 2,401 100 10011180 61070 Adjust to Actual Police Department 1 DARE - MFPRSI 296 100 10011180 61370 Adjust to Actual Police Department 1 DARE - Life Insurance (2) 100 10011180 61416 Adjust to Actual Police Department 1 DARE - Wage Adjustment (1,491) 100 10011180 61099 Adjust to Actual Police Department 1 Staff Services - Full time employees 16 100 10011190 61010 Adjust to Actual Police Department 1 Staff Services - Holiday Pay 6,091 100 10011190 61070 Adjust to Actual Police Department 1 Staff Services - IPERS 201 100 10011190 61310 Adjust to Actual Police Department 1 Staff Services - MFPRSI 1,171 100 10011190 61370 Adjust to Actual Police Department 1 Staff Services - Social Security (182) 100 10011190 61320 Adjust to Actual Police Department 1 Staff Services - Wage Adjustment (8,704) 100 10011190 61099 Adjust to Actual Police Department 1 Records - Full time employees 977 100 10011220 61010 Adjust to Actual Police Department 1 Records - Holiday Pay 2,685 100 10011220 61070 Adjust to Actual Police Department 1 Records - IPERS 229 100 10011220 61310 Adjust to Actual Police Department 1 Records - MFPRSI 332 100 10011220 61370 Adjust to Actual Police Department 1 Records - Social Security 1,301 100 10011220 61320 Adjust to Actual Police Department 1 Records - Life Insurance 1 100 10011220 61416 Adjust to Actual Police Department 1 Records - Wage Adjustment (5,179) 100 10011220 61099 Adjust to Actual Police Department 1 Training - Full time employees (2,048) 100 10011250 61010 Adjust to Actual Police Department 1 Training - Holiday Pay 3,406 100 10011250 61070 Adjust to Actual Police Department 1 Training - MFPRSI 413 100 10011250 61370 Adjust to Actual Police Department 1 Training - Life Insurance (4) 100 10011250 61416 Adjust to Actual Police Department 1 Training - Wage Adjustment (2,087) 100 10011250 61099 Adjust to Actual Police Department 1 CID - Full time employees (37,337) 100 10011300 61010 Adjust to Actual Police Department 1 CID - Holiday Pay 51,577 100 10011300 61070 Adjust to Actual Police Department 1 CID - Social Security 262 100 10011300 61320 Adjust to Actual Police Department 1 CID - MFPRSI 4,330 100 10011300 61370 Adjust to Actual Police Department 1 CID - Life Insurance (75) 100 10011300 61416 Adjust to Actual Police Department 1 CID - Wage Adjustment (22,059) 100 10011300 61099 Adjust to Actual Police Department 1 COP - Full time employees (22,996) 100 10011500 61010 Adjust to Actual Police Department 1 COP - Holiday Pay 37,519 100 10011500 61070 Adjust to Actual Police Department 1 COP - Social Security 225 100 10011500 61320 Adjust to Actual Police Department 1 COP - MFPRSI 4,417 100 10011500 61370 Adjust to Actual Police Department 1 COP - Life Insurance (44) 100 10011500 61416 Adjust to Actual Police Department 1 COP - Wage Adjustment (22,515) 100 10011500 61099 Adjust to Actual Police Department 1 Patrol- Full time employees (118,335) 100 10011700 61010 Adjust to Actual Police Department 1 Patrol - Holiday Pay 187,367 100 10011700 61070 Adjust to Actual Police Department 1 Patrol - Social Security 1,147 100 10011700 61320 Adjust to Actual Police Department 1 Patrol - MFPRSI 21,902 100 10011700 61370 Adjust to Actual Page 1 FISCAL YEAR 2015 AMENDMENT #1 CITY COUNCIL Department Police Department Police Department Police Department Police Department Police Department Police Department Police Department Police Department Police Department Police Department Police Department Police Department Police Department Police Department Police Department Police Department Police Department Police Department Police Department Police Department Emergency Communi Emergency Communi Emergency Communi Emergency Communi Emergency Communi Emergency Communi Emergency Communi Emergency Communi Emergency Communi Fire Department Fire Department Fire Department Fire Department Fire Department Fire Department Fire Department Fire Department Fire Department Fire Department Fire Department Fire Department Fire Department Fire Department Fire Department Fire Department Fire Department Fire Department Program Description 1 Patrol - Life Insurance 1 Patrol - Wage Adjustment 1C Restore Police Car- Motor Vehicle Maintenance ICE Task Force - Equipment Police Patrol - False Alami Billings FY11 Jag Grant- Police Equipment FY12 Jag Grant- Police Equipment FY13 Jag Grant- Police Equipment Police Training - Education & Training Community Orientated Police - Education & Training Police Patrol - Education& Training GTSB Grant - Overtime GTSB Grant - Grant Domestic Abuse Grant Multijurisdictional Drug Law Enforcement Task Force Underage Party Patrol Grant Underage Party Patrol Grant Underage Party Patrol Grant Dictaphone Maintenance - County Dictaphone Maintenance Contract E911 - Full time employees E911 - Holiday Pay E911 - IPERS E911 - Social Security E911 - Life Insurance E911 - Wage Adjustment Emergency Communication Center - Overtime Emergency Communication Center - Software License Emergency Communication Center - Television Administration - Full time employees Administration - IPERS Administration - MFPRSI Administration - Social Security Administration - Life Insurance Administration - Wage Adjustment Fire Training - Full time employees Fire Training - MFPRSI Fire Training - Social Security Fire Training - Life Insurance Fire Training - Wage Adjustment Ambulance - Full time employees Ambulance - Holiday Pay Ambulance - MFPRSI Ambulance - Social Security Ambulance- Life Insurance Ambulance - Wage Adjustment Suppression - Full time employees FY 15 Expense Amount (234) (111,546) 4,016 64,123 6,602 4,660 8,729 11,000 2,000 3,000 11,540 Page 2 2,016 1,930 12,881 368 3,441 518 (29) (17,639) 10,000 6,500 1,000 2,617 61 587 (607) 5 (3,861) 1,266 384 19 3 (1,959) 12,674 477 3,998 727 (36) (20,069) 62,223 FY 15 Revenue Amount Fund Activity/CIP Account Explanation 100 10011700 61416 Adjust to Actual 100 10011700 61099 Adjust to Actual 100 1002280 62528 CIO 100 10011600 72218 CIO 1,000 100 10011700 51215 C/O 100 10011752 72218 C/O 100 10011753 72218 CIO 100 10011762 72218 C/O 100 10011250 62360 C/O 100 10011500 62360 CIO 100 10011700 62360 C/O 100 10011771 61050 CIO 16,003 100 10011771 45771 CIO 1,441 100 10011754 45771 C/O 3,226 100 10011320 45771 C/O 2,280 100 10011326 45771 CIO 2,016 100 10011326 45771 C/O 100 10011326 61051 CIO 827 100 10011220 53620 CIO 100 10011220 62060 C/O 100 10012100 61010 Adjust to Actual 100 10012100 61070 Adjust to Actual 100 10012100 61310 Adjust to Actual 100 10012100 61320 Adjust to Actual 100 10012100 61416 Adjust to Actual 100 10012100 61099 Adjust to Actual 100 10012100 61050 CIO 100 10012100 62663 CIO 100 10012100 72412 C/O 100 10013100 61010 Adjust to Actual 100 10013100 61310 Adjust to Actual 100 10013100 61370 Adjust to Actual 100 10013100 61320 Adjust to Actual 100 10013100 61416 Adjust to Actual 100 10013100 61099 Adjust to Actual 100 10013200 61010 Adjust to Actual 100 10013200 61370 Adjust to Actual 100 10013200 61320 Adjust to Actual 100 10013200 61416 Adjust to Actual 100 10013200 61099 Adjust to Actual 100 10013300 61010 Adjust to Actual 100 10013300 61070 Adjust to Actual 100 10013300 61370 Adjust to Actual 100 10013300 61320 Adjust to Actual 100 10013300 61416 Adjust to Actual 100 10013300 61099 Adjust to Actual 100 10013400 61010 Adjust to Actual 26 -Aug -14 FISCAL YEAR 2015 AMENDMENT #1 CITY COUNCIL Department Fire Department Fire Department Fire Department Fire Department Fire Department Fire Department Fire Department Fire Department Fire Department Fire Department Human Rights Human Human Human Human Human Human Human Human Human Human Human Rights Rights Rights Rights Rights Rights Rights Rights Rights Rights Rights Health Services Health Services Health Services Health Services Health Services Health Services Health Services Health Services Health Services Health Services Health Services Health Services Health Services Health Services Health Services Health Services Health Services Health Services Health Services Health Services Health Services Health Services Health Services Multicultural Family C' Multicultural Family C Program Description 1 Suppression - Holiday Pay 1 Suppression - MFPRSI 1 Suppression - Social Security 1 Suppression - Life Insurance 1 Suppression - Wage Adjustment 1 Prevention - Full time employees 1 Prevention - MFPRSI 1 Prevention - Social Security 1 Prevention - Life Insurance 1 Prevention - Wage Adjustment 3 Human Relations - Full time employee 3 Human Relations - IPERS 3 Human Relations - Social Security 3 Human Relations - Life Insurance 3 Human Relations - Wage Adjustment 3 Workforce Development - Full time employee 3 Workforce Development - IPERS 3 Workforce Development - Social Security 3 Workforce Development - Life Insurance 3 Workforce Development - Wage Adjustment 3 Human Rights - Printing and Binding 3 Human Rights - Fair Housing Training 3 Administration - Full time employees 3 Administration - IPERS 3 Administration - Social Security 3 Administration - Life Insurance 3 Administration - Wage Adjustment 1 Animal Control - Part-time employees 1 Animal Control - IPERS 1 Animal Control - Social Security 3 Inspections - Full time employees 3 Inspections - IPERS 3 Inspections - Social Security 3 Inspections - Life Insurance 3 Community Health - Full time employees 3 Community Health - IPERS 3 Community Health - Social Security 3 Community Health - Life Insurance 3 Health Administration - Mileage 1 Animal Control - Uniform Allowance 1 Animal Control - Uniform Purchases 1 Animal Control -Animal Control Supplies 3 Health Inspection - Lab Supplies 3 Community Health Services - Mileage 3 Lead Paint Program - Pay to other Agency 4 MFC - Full time employees 4 MFC - IPERS FY 15 Expense Amount 4,965 20,422 (34,181) (234) (98,918) 2,357 716 221 4 (3,654) 3,951 352 302 9 (5,398) 1,026 92 78 1 (1,393) 2,100 20,445 1,228 109 93 2 (6,421) 1,017 91 77 1,756 157 135 8 698 62 54 2 60 458 78 233 450 80 1,335 2,191 124 Page 3 FY 15 Revenue Amount Fund Activity/CIP Account Explanation 100 10013400 61070 Adjust to Actual 100 10013400 61370 Adjust to Actual 100 10013400 61320 Adjust to Actual 100 10013400 61416 Adjust to Actual 100 10013400 61099 Adjust to Actual 100 10013700 61010 Adjust to Actual 100 10013700 61370 Adjust to Actual 100 10013700 61320 Adjust to Actual 100 10013700 61416 Adjust to Actual 100 10013700 61099 Adjust to Actual 100 10016100 61010 Adjust to Actual 100 10016100 61310 Adjust to Actual 100 10016100 61320 Adjust to Actual 100 10016100 61416 Adjust to Actual 100 10016100 61099 Adjust to Actual 100 10016300 61010 Adjust to Actual 100 10016300 61310 Adjust to Actual 100 10016300 61320 Adjust to Actual 100 10016300 61416 Adjust to Actual 100 10016300 61099 Adjust to Actual 100 10016100 62090 C/O 100 10016200 62753 CIO 100 10017100 61010 Adjust to Actual 100 10017100 61310 Adjust to Actual 100 10017100 61320 Adjust to Actual 100 10017100 61416 Adjust to Actual 100 10017100 61099 Adjust to Actual 100 10017200 61020 Adjust to Actual 100 10017200 61310 Adjust to Actual 100 10017200 61320 Adjust to Actual 100 10017300 61010 Adjust to Actual 100 10017300 61310 Adjust to Actual 100 10017300 61320 Adjust to Actual 100 10017300 61416 Adjust to Actual 100 10017400 61010 Adjust to Actual 100 10017400 61310 Adjust to Actual 100 10017400 61320 Adjust to Actual 100 10017400 61416 Adjust to Actual 100 10017100 62340 C/O 100 10017200 61620 CIO 100 10017200 62011 C/O 100 10017200 62067 C/O 100 10017300 62065 CIO 100 10017400 62340 C/O 100 10017500 62761 CIO 100 10034600 61010 Adjust to Actual 100 10034600 61310 Adjust to Actual 26 -Aug -14 FISCAL YEAR 2015 AMENDMENT #1 CITY COUNCIL Department Program Multicultural Family C 4 Multicultural Family C 4 Multicultural Family C 4 Multicultural Family C 6C Parks Division 4 Parks Division 4 Parks Division 4 Parks Division 4 Parks Division 4 Parks Division 4 Parks Division 4 Parks Division 4 Parks Division 4 Parks Division 4 Parks Division 4 Parks Division 4 Parks Division 4 Parks Division 4 Parks Division 4 Parks Division 4 Parks Division 4 Parks Division 4 Parks Division 4 Parks Division 4 Parks Division 4 Parks Division 4 Parks Division 4 Parks Division 4 Parks Division 4 Parks Division 4 Parks Division 4 Parks Division 4 Parks Division 4 Parks Division 4 Parks Division 4 Parks Division 4 Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Descriptio n MFC - Social Security MFC - Life Insurance MFC - Wage Adjustment Multicultural Family Center Travel Conferences Admin - Full time employees Admin - IPERS Admin - Social Security Admin - Life Insurance Admin - Wage Adjustment Forestry - Full time employees Forestry - IPERS Forestry - Social Security Forestry - Life Insurance Forestry - Wage Adjustment Park Patrol - Full time employees Park Patrol - IPERS Park Patrol - Social Security Park Patrol - Life Insurance Park Patrol - Wage Adjustment Park Areas - Full time employees Park Areas - IPERS Park Areas - Social Security Park Areas - Life Insurance Park Areas - Wage Adjustment Park Equip Maint- Full time employees Park Equip Maint- IPERS Park Equip Maint- Social Security Park Equip Maint- Life Insurance Park Equip Maint - Wage Adjustment Downtown Maint - Part time employees Downtown Maint - IPERS Downtown Maint - Social Security Downtown Maint - Wage Adjustment Greenhouse - Full time employees Greenhouse - IPERS Greenhouse - Social Security 4 Greenhouse - Life Insurance 4 Greenhouse - Wage Adjustment 4 Technology Park - Full time employees 4 Technology Park - IPERS 4 Technology Park - Social Security 4 Technology Park - Life Insurance 4 Technology Park - Wage Adjustment 4 DICW Park - Full time employees 4 DICW Park - IPERS 4 DICW Park - Social Security 4 DICW Park - Wage Adjustment FY 15 Expense Amount 167 2 (3,004) 2,314 3,158 280 240 12 (4,300) 2,764 248 210 7 (3,773) 1,423 125 109 3 (1,926) 10,906 125 109 3 (14,875) 889 107 92 2 (1,613) 568 31 43 (778) 2,380 210 182 4 (3,203) 435 37 33 1 (584) 508 43 39 (680) Page 4 FY 15 Revenue Amount Fund ActivityICIP Account Explanation 100 10034600 61320 Adjust to Actual 100 10034600 61416 Adjust to Actual 100 10034600 61099 Adjust to Actual 100 10034600 62310 CIO 100 10030100 61010 Adjust to Actual 100 10030100 61310 Adjust to Actual 100 10030100 61320 Adjust to Actual 100 10030100 61416 Adjust to Actual 100 10030100 61099 Adjust to Actual 100 10030220 61010 Adjust to Actual 100 10030220 61310 Adjust to Actual 100 10030220 61320 Adjust to Actual 100 10030220 61416 Adjust to Actual 100 10030220 61099 Adjust to Actual 100 10030300 61010 Adjust to Actual 100 10030300 61310 Adjust to Actual 100 10030300 61320 Adjust to Actual 100 10030300 61416 Adjust to Actual 100 10030300 61099 Adjust to Actual 100 10030400 61010 Adjust to Actual 100 10030400 61310 Adjust to Actual 100 10030400 61320 Adjust to Actual 100 10030400 61416 Adjust to Actual 100 10030400 61099 Adjust to Actual 100 10030420 61010 Adjust to Actual 100 10030420 61310 Adjust to Actual 100 10030420 61320 Adjust to Actual 100 10030420 61416 Adjust to Actual 100 10030420 61099 Adjust to Actual 100 10030430 61020 Adjust to Actual 100 10030430 61310 Adjust to Actual 100 10030430 61320 Adjust to Actual 100 10030430 61099 Adjust to Actual 100 10030500 61010 Adjust to Actual 100 10030500 61310 Adjust to Actual 100 10030500 61320 Adjust to Actual 100 10030500 61416 Adjust to Actual 100 10030500 61099 Adjust to Actual 100 10030520 61010 Adjust to Actual 100 10030520 61310 Adjust to Actual 100 10030520 61320 Adjust to Actual 100 10030520 61416 Adjust to Actual 100 10030520 61099 Adjust to Actual 100 10030530 61010 Adjust to Actual 100 10030530 61310 Adjust to Actual 100 10030530 61320 Adjust to Actual 100 100305:0 61099 Adjust to Actual 26 -Aug -14 FISCAL YEAR 2015 AMENDMENT #1 CITY COUNCIL Department Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Am eri Corps AmeriCorps Am eri Corps Am eri Corps Civic Center Division Civic Center Division Civic Center Division Civic Center Division Civic Center Division Civic Center Division Civic Center Division Conference Center Recreation Recreation Recreation Program Description 4 POD - Seasonal employees 4 POD -IPERS 4 POD - Social Security 4 POD - Wage Adjustment 4 POD C Store - Seasonal employees 4 POD C Store -IPERS 4 POD C Store - Social Security 4 POD C Store - Wage Adjustment 4 POD Docks - Full-time employees 4 POD Docks - IPERS 4 POD Docks - Social Security 4 POD Docks - Wage Adjustment 4 Forestry - Tree Maintenance 4 Park Areas & Maintenance - Payments to Other Agency 4 Park Areas & Maintenance - Tree Donation 4 Port of Dubuque Maintenance - Landscape 4 Park Equipment Maintenance - Vehicle 4 Greenhouse - Landscaping MFC Planters 4 Technology Park Maintenance - Property Maint 4C Miller Riverview Rip Rap 2C NW Hike/Bike Trail - REAP Grant 4C Erosion Control Study 4C Park Drinking Fountains - Consultant Engineers 4C Urban Youth Corp Grant - Fed Grant 4C Urban Youth Corp Grant- Seasonal Employees 4C EB Lyons Expansion - Private Participation 4C EB Lyons Expansion - Fed Pass Thru 4C EB Lyons Expansion - IDOT Rec Trails 4C EB Lyons Expansion - Iowa DNR 4C EB Lyons Expansion - State Grants 4C EB Lyons Expansion - REAP Grant 4C EB Lyons Expansion - Land Acquisition 4 AmeriCorps Seasonal Employees 4 AmeriCorps Social Security 4 AmeriCorps Federal Grant 4 AmeriCorps Private Participant 4 Civic Center - Full -Time Employees 4 Civic Center - Wage Adjustment 4 Civic Center- IPERS 4 Civic Center - Social Security 4 Civic Center - Life Insurance 4 Civic Center - Pay to Other Agency 4C FF Improv - SMG Contrib 6C GRC - Concrete 4 Port of Dubuque Marina - Consultant Services 4 Recreation Administration - Scheduling Software 4 Recreation Administration - Ice Rental FY 15 Expense Amount 170 15 13 (222) 751 67 57 ( 1,025) 633 58 50 (869) 7,155 3,309 300 457 5,354 9,800 2,000 5,187 22,672 9,957 10,009 1,512,216 14,000 976 235 (320) 21 18 1 494 100,000 15,045 8,956 1,200 5,000 Page 5 FY 15 Revenue Amount Fund Activity/CIP Account Explanation 100 10030415 61030 Adjust to Actual 100 10030415 61310 Adjust to Actual 100 10030415 61320 Adjust to Actual 100 10030415 61099 Adjust to Actual 100 10030550 61030 Adjust to Actual 100 10030550 61310 Adjust to Actual 100 10030550 61320 Adjust to Actual 100 10030550 61099 Adjust to Actual 100 10030560 61010 Adjust to Actual 100 10030560 61310 Adjust to Actual 100 10030560 61320 Adjust to Actual 100 10030560 61099 Adjust to Actual 100 10030220 62720 CIO 100 10030400 62761 C/O 100 10030400 73311 C/O 100 10030415 62637 CIO 100 10030420 71312 C/O 100 10030500 73310 C/O 100 10030520 62431 CIO 100 1001170 73211 C/O 20,000 100 1002273 45707 C/O 100 1001987 62712 CIO 100 1002101 62712 C/O 8,460 100 1002343 45771 C/O 100 1002343 61030 CIO 630,525 100 1002171 53102 C/O 175,000 100 1002171 45771 C/O 170,500 100 1002171 45733 CIO 509,000 100 1002171 45731 C/O 60,000 100 1002171 45701 C/O 24,100 100 1002171 45707 CIO 100 1002171 73110 C/O 100 10034910 61030 C/O 100 10034910 61320 CIO 58,961 100 10034910 45771 C/O 66,544 100 10034910 53102 C/O 100 10032100 61010 Adjust to Actual 100 10032100 61099 Adjust to Actual 100 10032100 61310 Adjust to Actual 100 10032100 61320 Adjust to Actual 100 10032100 61416 Adjust to Actual 100 10032100 62761 Adjust to Actual 100 1002569 73210 CIO 100 1002390 73211 C/O 100 10030550 62716 C/O 100 10034100 71123 CIO 100 10034100 72761 C/O 26 -Aug -14 FISCAL YEAR 2015 AMENDMENT #1 CITY COUNCIL 26 -Aug -14 FY 15 FY 15 Expense Revenue Department Program Description Amount Amount Fund ActivityICIP Account Explanation Recreation 4 Admin - Full time employees 3,039 100 10034100 61010 Adjust to Actual Recreation 4 Admin -IPERS 264 100 10034100 61310 Adjust to Actual Recreation 4 Admin - Social Security 232 100 10034100 61320 Adjust to Actual Recreation 4 Admin - Life Insurance 6 100 10034100 61416 Adjust to Actual Recreation 4 Admin - Wage Adjustment (4,138) 100 10034100 61099 Adjust to Actual Recreation 4 Golf Ops - Seasonal employees 1,355 100 10034200 61030 Adjust to Actual Recreation 4 Golf Ops - IPERS 49 100 10034200 61310 Adjust to Actual Recreation 4 Golf Ops - Social Security 103 100 10034200 61320 Adjust to Actual Recreation 4 Golf Ops - Wage Adjustment (1,552) 100 10034200 61099 Adjust to Actual Recreation 4 Golf Maint - Seasonal employees 2,901 100 10034250 61010 Adjust to Actual Recreation 4 Golf Maint - IPERS 144 100 10034250 61310 Adjust to Actual Recreation 4 Golf Maint - Social Security 223 100 10034250 61320 Adjust to Actual Recreation 4 Golf Maint - Wage Adjustment (3,926) 100 10034250 61099 Adjust to Actual Recreation 4 Swimming - Seasonal employees 4,244 100 10034300 61030 Adjust to Actual Recreation 4 Swimming - IPERS 107 100 10034300 61310 Adjust to Actual Recreation 4 Swimming - Social Security 326 100 10034300 61320 Adjust to Actual Recreation 4 Swimming - Life Insurance 1 100 10034300 61416 Adjust to Actual Recreation 4 Swimming - Wage Adjustment (5,447) 100 10034300 61099 Adjust to Actual Recreation 4 Adult Athletics - Seasonal employees 1,408 100 10034400 61030 Adjust to Actual Recreation 4 Adult Athletics - IPERS 106 100 10034400 61310 Adjust to Actual Recreation 4 Adult Athletics - Social Security 107 100 10034400 61320 Adjust to Actual Recreation 4 Adult Athletics - Life Insurance 2 100 10034400 61416 Adjust to Actual Recreation 4 Adult Athletics - Wage Adjustment (1,906) 100 10034400 61099 Adjust to Actual Recreation 4 McAleece - Seasonal employees 241 100 10034410 61030 Adjust to Actual Recreation 4 McAleece -IPERS 13 100 10034410 61310 Adjust to Actual Recreation 4 McAleece - Social Security 18 100 10034410 61320 Adjust to Actual Recreation 4 McAleece - Wage Adjustment (319) 100 10034410 61099 Adjust to Actual Recreation 4 Children Activities - Seasonal employees 1,805 100 10034420 61030 Adjust to Actual Recreation 4 Children Activities - IPERS 70 100 10034420 61310 Adjust to Actual Recreation 4 Children Activities - Social Security 138 100 10034420 61320 Adjust to Actual Recreation 4 Children Activities - Life Insurance 1 100 10034420 61416 Adjust to Actual Recreation 4 Children Activities - Wage Adjustment (2,404) 100 10034420 61099 Adjust to Actual Recreation 4 Therapeutic Activities - Seasonal employees 313 100 10034430 61030 Adjust to Actual Recreation 4 Therapeutic Activities - IPERS 28 100 10034430 61310 Adjust to Actual Recreation 4 Therapeutic Activities - Social Security 23 100 10034430 61320 Adjust to Actual Recreation 4 Therapeutic Activities - Wage Adjustment (425) 100 10034430 61099 Adjust to Actual Recreation 4 Recreation - Seasonal employees 1,703 100 10034460 61030 Adjust to Actual Recreation 4 Recreation - IPERS 9,151 100 10034460 61310 Adjust to Actual Recreation 4 Recreation - Social Security 131 100 10034460 61320 Adjust to Actual Recreation 4 Recreation - Life Insurance 1 100 10034460 61416 Adjust to Actual Recreation 4 Recreation - Wage Adjustment (2,366) 100 10034460 61099 Adjust to Actual Library 4 Admin - Full time employees 2,905 100 10036100 61010 Adjust to Actual Library 4 Admin - IPERS 260 100 10036100 61310 Adjust to Actual Library 4 Admin - Social Security 222 100 10036100 61320 Adjust to Actual Library 4 Admin - Life Insurance 4 100 10036100 61416 Adjust to Actual Library 4 Admin - Wage Adjustment (3,960) 100 10036100 61099 Adjust to Actual Library 4 Adult Services - Full time employees 5,963 100 10036200 61010 Adjust to Actual Page 6 FISCAL YEAR 2015 AMENDMENT #1 CITY COUNCIL Department Library 4 Library 4 Library 4 Library 4 Library 4 Library 4 Library 4 Library 4 Library 4 Library 4 Library 4 Library 4 Library 4 Library 4 Library 4 Library 4 Library 4 Library 4 Library 4 Library 4 Library 4 Library 4 Library 4 Library 4 Library 4 Library 4 Library 4 Library 4 Library 4 Library 4 Library 4 Library 4 Airport Department 2 Airport Department 2 Airport Department 2 Airport Department 2 Airport Department 2 Airport Department 2 Airport Department 2 Airport Department 2 Airport Department 2 Airport Department 2 Airport Department 2 Airport Department 2 Airport Department 2 Airport Department 2 Airport Department 2 Program Description Adult Services - IPERS Adult Services - Social Security Adult Services - Life Insurance Adult Services - Wage Adjustment Children Services - Full time employees Children Services- IPERS Children Services - Social Security Children Services - Life Insurance Children Services - Wage Adjustment Circulation Services - Part -Time time employees Circulation Services - IPERS Circulation Services - Social Security Circulation Services - Life Insurance Circulation Services - Wage Adjustment Maint Services - Full -Time time employees Maint Services - IPERS Maint Services - Social Security Maint Services - Life Insurance Maint Services - Wage Adjustment IT - Full -Time time employees IT - IPERS IT - Social Security IT - Life Insurance IT - Wage Adjustment Technical Services - Full -Time time employees Technical Services- IPERS Technical Services - Social Security Technical Services - Life Insurance Technical Services - Wage Adjustment Library Administration - Travel Conferences Childrens Activities - Books Adult Services - Books Airport Admin - Full -Time time employees Airport Admin- IPERS Airport Admin - Social Security Airport Admin - Life Insurance Airport Admin - Wage Adjustment FBO - Full -Time time employees FBO- IPERS FBO - Social Security FBO - Wage Adjustment Airport Ops - Full -Time time employees Airport Ops- IPERS Airport Ops - Social Security Airport Ops - Life Insurance Airport Ops - Wage Adjustment Administration - Computer Peripherals FY 15 Expense Amount 532 456 9 (8,154) 4,130 370 315 4 (5,657) 4,052 366 313 1 (5,479) 1,527 135 117 3 (2,077) 1,713 152 130 2 (2,350) 5,113 461 393 5 (6,997) 976 1,551 2,811 3,957 353 302 2 (5,379) 4,115 366 314 (5,657) 4,696 419 (227) (263) (6,406) 10,500 Page 7 FY 15 Revenue Amount 26 -Aug -14 Fund Activity/CIP Account Explanation 100 10036200 61310 Adjust to Actual 100 10036200 61320 Adjust to Actual 100 10036200 61416 Adjust to Actual 100 10036200 61099 Adjust to Actual 100 10036210 61010 Adjust to Actual 100 10036210 61310 Adjust to Actual 100 10036210 61320 Adjust to Actual 100 10036210 61416 Adjust to Actual 100 10036210 61099 Adjust to Actual 100 10036220 61020 Adjust to Actual 100 10036220 61310 Adjust to Actual 100 10036220 61320 Adjust to Actual 100 10036220 61416 Adjust to Actual 100 10036220 61099 Adjust to Actual 100 10036300 61010 Adjust to Actual 100 10036300 61310 Adjust to Actual 100 10036300 61320 Adjust to Actual 100 10036300 61416 Adjust to Actual 100 10036300 61099 Adjust to Actual 100 10036440 61010 Adjust to Actual 100 10036440 61310 Adjust to Actual 100 10036440 61320 Adjust to Actual 100 10036440 61416 Adjust to Actual 100 10036440 61099 Adjust to Actual 100 10036500 61010 Adjust to Actual 100 10036500 61310 Adjust to Actual 100 10036500 61320 Adjust to Actual 100 10036500 61416 Adjust to Actual 100 10036500 61099 Adjust to Actual 100 10036100 62310 C/O 100 10036400 62651 C/O -Lost Book Revenue 100 10036200 62651 C/O -Lost Book Revenue 100 10051100 61010 Adjust to Actual 100 10051100 61310 Adjust to Actual 100 10051100 61320 Adjust to Actual 100 10051100 61416 Adjust to Actual 100 10051100 61099 Adjust to Actual 100 10051200 61010 Adjust to Actual 100 10051200 61310 Adjust to Actual 100 10051200 61320 Adjust to Actual 100 10051200 61099 Adjust to Actual 100 10051400 61010 Adjust to Actual 100 10051400 61310 Adjust to Actual 100 10051400 61320 Adjust to Actual 100 10051400 61416 Adjust to Actual 100 10051400 61099 Adjust to Actual 100 10051100 71120 CIO FISCAL YEAR 2015 AMENDMENT #1 CITY COUNCIL Department Airport Department Airport Department Airport Department Airport Department Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Program Description 2 FBO Operations - Maintenance Equip 2 FBO Operations - Radar Maint 2 Terminal Building Maint-Concession Equipment 2C Airport GIS - Consulting 2 Public Works Admin - Full -Time time employees 2 Public Works Admin- IPERS 2 Public Works Admin - Social Security 2 Pubic Works Admin - Life Insurance 2 Public Works Admin - Wage Adjustment 2 Riverfront - Full -Time time employees 2 Riverfront- IPERS 2 Riverfront - Social Security 2 Riverfront- Life Insurance 2 Riverfront - Wage Adjustment 2 Floodwall - Full -Time time employees 2 Floodwall- IPERS 2 Floodwall - Social Security 2 Floodwall - Wage Adjustment 2 Lights - Full -Time time employees 2 Lights- IPERS 2 Lights - Social Security 2 Lights - Life Insurance 2 Lights - Wage Adjustment 2 Signs - Full -Time time employees 2 Signs-IPERS 2 Signs - Social Security 2 Signs - Life Insurance 2 Signs - Wage Adjustment 2 POD - Full -Time time employees 2 POD- IPERS 2 POD - Social Security 2 POD - Life Insurance 2 POD - Wage Adjustment 2 Engineering Admin - Full -Time time employees 2 Engineering Admin- IPERS 2 Engineering Admin - Social Security 2 Engineering Admin - Life Insurance 2 Engineering Admin -Wage Adjustment 2 Project Engineering - Full -Time time employees 2 Project Engineering- IPERS 2 Project Engineering - Social Security 2 Project Engineering - Life Insurance 2 Project Engineering - Wage Adjustment 2 Traffic Engineering - Full -Time time employees 2 Traffic Engineering- IPERS 2 Traffic Engineering - Social Security 2 Traffic Engineering - Life Insurance FY 15 Expense Amount 21,050 25,000 11,350 9,372 4,598 411 352 9 (6,245) 561 50 43 1 (767) 480 42 35 (656) 1,776 158 135 3 (2,390) 1,522 134 117 2 (2,068) 973 855 75 1 (1,313) 2,742 244 209 4 (3,714) 5,296 470 404 10 (7,191) 935 84 72 2 Page 8 FY 15 Revenue Amount Fund Activity/CIP Account Explanation 100 10051400 71619 CIO 100 10051400 62614 C/O 100 10051700 72310 C/O 100 1002282 62712 CIO 100 10054100 61010 Adjust to Actual 100 10054100 61310 Adjust to Actual 100 10054100 61320 Adjust to Actual 100 10054100 61416 Adjust to Actual 100 10054100 61099 Adjust to Actual 100 10054330 61010 Adjust to Actual 100 10054330 61310 Adjust to Actual 100 10054330 61320 Adjust to Actual 100 10054330 61416 Adjust to Actual 100 10054330 61099 Adjust to Actual 100 10054340 61010 Adjust to Actual 100 10054340 61310 Adjust to Actual 100 10054340 61320 Adjust to Actual 100 10054340 61099 Adjust to Actual 100 10054430 61010 Adjust to Actual 100 10054430 61310 Adjust to Actual 100 10054430 61320 Adjust to Actual 100 10054430 61416 Adjust to Actual 100 10054430 61099 Adjust to Actual 100 10054435 61010 Adjust to Actual 100 10054435 61310 Adjust to Actual 100 10054435 61320 Adjust to Actual 100 10054435 61416 Adjust to Actual 100 10054435 61099 Adjust to Actual 100 10054450 61010 Adjust to Actual 100 10054450 61310 Adjust to Actual 100 10054450 61320 Adjust to Actual 100 10054450 61416 Adjust to Actual 100 10054450 61099 Adjust to Actual 100 10055100 61010 Adjust to Actual 100 10055100 61310 Adjust to Actual 100 10055100 61320 Adjust to Actual 100 10055100 61416 Adjust to Actual 100 10055100 61099 Adjust to Actual 100 10055400 61010 Adjust to Actual 100 10055400 61310 Adjust to Actual 100 10055400 61320 Adjust to Actual 100 10055400 61416 Adjust to Actual 100 10055400 61099 Adjust to Actual 100 10055700 61010 Adjust to Actual 100 10055700 61310 Adjust to Actual 100 10055700 61320 Adjust to Actual 100 10055700 61416 Adjust to Actual 26 -Aug -14 FISCAL YEAR 2015 AMENDMENT #1 CITY COUNCIL Department Engineering Engineering Engineering Engineering Engineering Building Building Building Building Building Building Building Building Building Building Building Building Building Building Building Building Building Building Building Building Building Building Building Building Building Building Building Building Building Building Building Building Building Building Building Building Building Building Building Building Economic Devlopmt Economic Devlopmt Program Description 2 Traffic Engineering - Wage Adjustment 2C Elm Complete Street - Fed Pass Thru Grant 4C Library Renovation - Construction 4C Library Renovation - Sale of Assets - Heade Painting 2C Riverwalk Security Camera - Camera Related Equipment 6 Admin - Alley Lighting Grants 1 Administration - Full time employees 1 Administration - IPERS 1 Administration - Social Security 1 Administration - Life Insurance 1 Administration - Wage Adjustment 1 Electrical - Full time employees 1 Electrical - IPERS 1 Electrical - Social Security 1 Electrical - Life Insurance 1 Electrical - Wage Adjustment 1 Building - Full time employees 1 Building - IPERS 1 Building - Social Security 1 Building - Life Insurance 1 Building - Wage Adjustment 6 City Hall - Full time employees 6 City Hall - IPERS 6 City Hall - Social Security 6 City Hall - Life Insurance 6 City Hall - Wage Adjustment 6 City Annex - Full time employees 6 City Annex - IPERS 6 City Annex - Social Security 6 City Annex - Wage Adjustment 6 Fed Bldg - Full time employees 6 Fed Bldg - IPERS 6 Fed Bldg - Social Security 6 Fed Bldg - Life Insurance 6 Fed Bldg - Wage Adjustment 6 MFC - Full time employees 6 MFC -IPERS 6 MFC - Social Security 6 MFC - Life Insurance 6 MFC - Wage Adjustment 1 Plumbing - Full time employees 1 Plumbing - IPERS 1 Plumbing - Social Security 1 Plumbing - Life Insurance 1 Plumbing - Wage Adjustment 5 Economic Dev - Full time employees 5 Economic Dev - IPERS FY 15 Expense Amount (1,269) 11,394 16,093 34,900 2,074 185 159 4 (2,823) 960 86 74 2 (1,316) 76,404 6,824 5,846 150 (5,033) 647 58 49 1 (878) 262 23 21 (356) 1,988 178 151 4 (2,713) 155 14 13 (10) (211) (71,153) (6,354) (5,443) (142) (2,985) (12,400) (1,107) Page 9 FY 15 Revenue Amount 349,779 243,336 26 -Aug -14 Fund Activity/CIP Account Explanation 100 10055700 61099 Adjust to Actual 100 1002502 45771 C/O 100 1001141 73210 C/O 100 1001141 54104 CIO - Heade Painting Receiv 100 1001963 72417 C/O 100 10057100 62765 C/O 100 10057100 61010 Adjust to Actual 100 10057100 61310 Adjust to Actual 100 10057100 61320 Adjust to Actual 100 10057100 61416 Adjust to Actual 100 10057100 61099 Adjust to Actual 100 10057200 61010 Adjust to Actual 100 10057200 61310 Adjust to Actual 100 10057200 61320 Adjust to Actual 100 10057200 61416 Adjust to Actual 100 10057200 61099 Adjust to Actual 100 10057400 61010 Adjust to Actual 100 10057400 61310 Adjust to Actual 100 10057400 61320 Adjust to Actual 100 10057400 61416 Adjust to Actual 100 10057400 61099 Adjust to Actual 100 10057500 61010 Adjust to Actual 100 10057500 61310 Adjust to Actual 100 10057500 61320 Adjust to Actual 100 10057500 61416 Adjust to Actual 100 10057500 61099 Adjust to Actual 100 10057510 61010 Adjust to Actual 100 10057510 61310 Adjust to Actual 100 10057510 61320 Adjust to Actual 100 10057510 61099 Adjust to Actual 100 10057520 61010 Adjust to Actual 100 10057520 61310 Adjust to Actual 100 10057520 61320 Adjust to Actual 100 10057520 61416 Adjust to Actual 100 10057520 61099 Adjust to Actual 100 10057540 61010 Adjust to Actual 100 10057540 61310 Adjust to Actual 100 10057540 61320 Adjust to Actual 100 10057540 61416 Adjust to Actual 100 10057540 61099 Adjust to Actual 100 10057700 61010 Adjust to Actual 100 10057700 61310 Adjust to Actual 100 10057700 61320 Adjust to Actual 100 10057700 61416 Adjust to Actual 100 10057700 61099 Adjust to Actual 100 10060700 61010 Adjust to Actual 100 10060700 61310 Adjust to Actual FISCAL YEAR 2015 AMENDMENT #1 CITY COUNCIL Department Economic Devlopmt Economic Devlopmt Economic Devlopmt Economic Devlopmt Economic Devlopmt Economic Devlopmt Economic Devlopmt Economic Devlopmt Housing & Comm De\ Economic Devlopmt Economic Devlopmt Economic Devlopmt Economic Devlopmt Economic Devlopmt Economic Devlopmt Economic Devlopmt Economic Devlopmt Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Program Description 5 Economic Dev - Social Security 5 Economic Dev - Life Insurance 5 Economic Dev - Wage Adjustment 5 Wash. Neigh - Full time employees 5 Wash. Neigh. - IPERS 5 Wash. Neigh. - Social Security 5 Wash. Neigh. - Life Insurance 5 Wash. Neigh. - Wage Adjustment 5 Administration - Pay to Other Agency 5 Arts - Part-time employees 5 Arts -IPERS 5 Arts - Social Security 5 Arts - Wage Adjustment 5C IFA Downtown Housing Loan Pool - Interest Payments 5C IFA Downtown Housing Loan Pool - Interest Receivable 5C Downtown Brownfields Grant - EPA Grant 5C Downtown Brownfields Grant - Consultants 5C Maint of Vacant/Abandoned - Property Maintenance 5C Maint of Vacant/Abandoned - Property Maintenance 5C Housing Trust Fund - Washington Neighborhood 5C Historic Preservation Revolving Loan 5C Historic Preservation Revolving Loans 5C NBHD Stabilization Grant -Construction 5C IFA Our Home Grant - Grants 5C IFA Housing Trust 13-17 - Construction 5 Administration - Full time employees 5 Administration - IPERS 5 Administration - Social Security 5 Administration - Life Insurance 5 Administration - Wage Adjustment 5 Healthy Homes - Full time employees 5 Healthy Homes- IPERS 5 Healthy Homes - Social Security 5 Healthy Homes - Life Insurance 5 Healthy Homes - Wage Adjustment 5 General Inspection - Full time employees 5 General Inspection - IPERS 5 General Inspection - Social Security 5 General Inspection - Life Insurance 5 General Inspection - Wage Adjustment 5 Circles - Full time employees 5 Circles - IPERS 5 Circles - Social Security 5 Circles - Life Insurance 5 Circles - Wage Adjustment 5 Circles Program - Promotion 5 Circles Program - Special Events FY 15 Expense Amount (948) (26) (4,348) 713 63 55 2 (981) 75,000 (5,200) (420) (398) (577) 135,000 Page 10 323,680 122,549 (48,000) (35,700) 200,000 56,416 250,000 (27,712) 391 35 (315) 1 (529) 1,620 143 123 3 (2,210) 2,282 203 175 4 (3,126) 589 53 45 2 (812) 16,881 5,489 26 -Aug -14 FY 15 Revenue Amount Fund Activity/CIP Account Explanation 100 10060700 61320 Adjust to Actual 100 10060700 61416 Adjust to Actual 100 10060700 61099 Adjust to Actual 100 10060900 61010 Adjust to Actual 100 10060900 61310 Adjust to Actual 100 10060900 61320 Adjust to Actual 100 10060900 61416 Adjust to Actual 100 10060900 61099 Adjust to Actual 100 10061100 62761 C/O 100 10072500 61020 Adjust to Actual 100 10072500 61310 Adjust to Actual 100 10072500 61320 Adjust to Actual 100 10072500 61099 Adjust to Actual 100 1002279 74112 C/O 135,000 100 1002279 43105 C/O 398,256 100 1002567 44170 CIO 100 1002567 62716 C/O 100 1001002 62431 C/O 100 1001002 62431 Shift to Homeownership 100 1001021 73210 C/O- Program Income 200,000 100 1001247 54210 C/O 100 1001247 62764 CIO 100 1002180 73210 C/O 100 1002269 62765 CIO 100 1002270 73210 CIO 100 10061100 61010 Adjust to Actual 100 10061100 61310 Adjust to Actual 100 10061100 61320 Adjust to Actual 100 10061100 61416 Adjust to Actual 100 10061100 61099 Adjust to Actual 100 10061136 61010 Adjust to Actual 100 10061136 61310 Adjust to Actual 100 10061136 61320 Adjust to Actual 100 10061136 61416 Adjust to Actual 100 10061136 61099 Adjust to Actual 100 10061700 61010 Adjust to Actual 100 10061700 61310 Adjust to Actual 100 10061700 61320 Adjust to Actual 100 10061700 61416 Adjust to Actual 100 10061700 61099 Adjust to Actual 100 10061922 61010 Adjust to Actual 100 10061922 61310 Adjust to Actual 100 10061922 61320 Adjust to Actual 100 10061922 61416 Adjust to Actual 100 10061922 61099 Adjust to Actual 100 10061922 62140 CIO 100 10061922 62645 C/O FISCAL YEAR 2015 AMENDMENT #1 CITY COUNCIL Department Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Planning Services Planning Services Planning Services Planning Services Planning Services Planning Services Planning Services Planning Services Planning Services Planning Services Planning Services Planning Services Planning Services Planning Services Planning Services Personnel Personnel Personnel Personnel Personnel Personnel Personnel Budget Budget Budget Budget Budget Public Information Public Information Public Information Public Information Public Information Public Information Public Information Public Information City Manager City Manager Program Description 5 Circles Program - Education & Training 5 Circles Program - Printing 5 General Housing Inspection - Education & Training 5 General Housing Inspection - Vehicle Outsourcing 5 Section 8 Voucher - Equipment 5 Section 8 Voucher - Pay to Other Agency 5 Rehab Program - Rehab Loan Escrow Accounts 5 Rehab Program - Loan Escrow Accounts Amendment 5 HOME Workshop - Promotion 5 445 Loras - Property Maintenance 5 Admin - Full time employees 5 Admin -IPERS 5 Admin - Social Security 5 Admin - Life Insurance 5 Admin - Wage Adjustment 5 Develop Services - Full time employees 5 Develop Services - IPERS 5 Develop Services - Social Security 5 Develop Services - Life Insurance 5 Develop Services - Wage Adjustment 5 Historic - Full time employees 5 Historic -IPERS 5 Historic - Social Security 5 Historic - Life Insurance 5 Historic - Wage Adjustment 6 Personnel - OSHA Compliance Agreement 6 Personnel - Leadership Training Program 6 Personnel - Full time employees 6 Personnel - IPERS 6 Personnel - Social Security 6 Personnel - Life Insurance 6 Personnel - Wage Adjustment 6 Budget - Full time employees 6 Budget -IPERS 6 Budget - Social Security 6 Budget - Life Insurance 6 Budget - Wage Adjustment 6 GIS - Full time employees 6 GIS - IPERS 6 GIS - Social Security 6 GIS - Life Insurance 6 GIS - Wage Adjustment 6C GIS Implementation - Consultant Services 6C GIS Training 6C City of Dbq 175th Birthday 6 Administration - Full time employees 6 Administration - IPERS FY 15 Expense Amount 538 2,000 4,500 1,369 3,450 5,342 1,946 1,845 1,790 12,660 386 34 30 1 (526) 4,019 359 307 10 (5,492) 3,231 288 209 5 (4,378) 14,375 4,005 2,857 (43) 219 6 (3,903) 2,857 (43) 219 6 (3,903) 138 13 10 2 (1,550) 9,977 6,750 3,390 6,710 752 Page 11 FY 15 Revenue Amount Fund Activity/CIP Account Explanation 100 10061922 62360 100 10061922 62090 100 10061700 62360 100 10061700 62528 100 10061600 71211 100 10061600 62761 100 10061300 62758 100 10061300 62758 100 10061100 62140 100 10061710 62431 100 10062100 61010 100 10062100 61310 100 10062100 61320 100 10062100 61416 100 10062100 61099 100 10062400 61010 100 10062400 61310 100 10062400 61320 100 10062400 61416 100 10062400 61099 100 10062700 61010 100 10062700 61310 100 10062700 61320 100 10062700 61416 100 10062700 61099 100 10072700 62716 100 10072700 62360 100 10072700 61010 100 10072700 61310 100 10072700 61320 100 10072700 61416 100 10072700 61099 100 10072400 61010 100 10072400 61310 100 10072400 61320 100 10072400 61416 100 10072400 61099 100 10072300 61010 100 10072300 61310 100 10072300 61320 100 10072300 61416 100 10072300 61099 100 1001070 62716 100 1002165 62360 100 1001948 62734 100 10072100 61010 100 10072100 61310 26 -Aug -14 C/O C/O C/O C/O C/O CDBG Funds C/O CDBG Funds C/O C/O C/O C/O Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual C/O C/O Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual C/O C/O C/O Adjust to Actual Adjust to Actual FISCAL YEAR 2015 AMENDMENT #1 CITY COUNCIL Department City Manager 6 City Manager 6 City Manager 6 City Manager 6 City Manager 6 City Manager 6 City Manager 6 City Manager 6 City Manager 6 City Manager 6 City Manager 6 City Manager 6 City Manager 6 City Manager 6 City Manager 6C City Manager 6C Sustainability 6 Sustainability 6 Sustainability 6 City Manager 6 City Clerk 6 City Clerk 6 City Clerk 6 City Clerk 6 City Clerk 6 City Clerk 6 City Clerk 6 City Clerk 6 City Clerk 6 Finance 6 Finance 6 Finance 6 Finance 6 Finance 6 Finance 6 Finance 6 Finance 6 Finance 6 Finance 6 Finance 6 Legal 6 Legal 6 Legal 6 Legal 6 Legal 6 Information Services 6 Information Services 6 Program Description Administration Administration Administration Administration Sustainability - Sustainability - Sustainability - Sustainability - Sustainability - Neighborhood Neighborhood Neighborhood Neighborhood Neighborhood - Social Security - Life Insurance - Car Allowance - Wage Adjustment Full time employees IPERS Social Security Life Insurance Wage Adjustment - Full time employees - IPERS - Social Security - Life Insurance - Wage Adjustment Climate Showcase Grant - Consultant Services Climate Showcase Grant - Federal Grants Sustainability - Special Events Sustainability - Pay to Other Agency Sustainability- ESMS Training Administration - Special Events Clerk - Full time employees Clerk - Car Allowance Clerk - IPERS Clerk - Social Security Clerk - Life Insurance Clerk - Wage Adjustment City Clerk - Software License City Clerk - Private Participant City Clerk - Consultant Services Electric Franchise Fee Refund Accounting - Full time employees Accounting - IPERS Accounting - Social Security Accounting - Life Insurance Accounting - Wage Adjustment Utility Billing - Full time employees Utility Billing - IPERS Utility Billing - Social Security Utility Billing - Life Insurance Utility Billing - Wage Adjustment Legal - Full time employees Legal - IPERS Legal - Social Security Legal - Life Insurance Legal - Wage Adjustment IS - Full time employees IS - IPERS FY 15 Expense Amount 113 (4) 113 (26,558) 977 88 75 3 (1,336) 564 50 43 2 (769) 96,669 5,000 16,375 3,600 712 (1,973) 55 (36) (146) (20) (1,956) 4,079 3,000 57,392 7,295 650 285 14 (9,927) 5,103 455 663 12 (6,950) 4,817 (330) 368 (8) (9,744) 8,411 752 Page 12 26 -Aug -14 FY 15 Revenue Amount Fund Activity/CIP Account Explanation 100 10072100 61320 Adjust to Actual 100 10072100 61416 Adjust to Actual 100 10072100 61655 Adjust to Actual 100 10072100 61099 Adjust to Actual 100 10072200 61010 Adjust to Actual 100 10072200 61310 Adjust to Actual 100 10072200 61320 Adjust to Actual 100 10072200 61416 Adjust to Actual 100 10072200 61099 Adjust to Actual 100 10072800 61010 Adjust to Actual 100 10072800 61310 Adjust to Actual 100 10072800 61320 Adjust to Actual 100 10072800 61416 Adjust to Actual 100 10072800 61099 Adjust to Actual 100 1002334 62716 CIO 96,669 100 1002334 44170 CIO 100 10072200 62645 C/O 100 10072200 62761 C/O 100 1002496 62360 CIO 100 10072100 62645 CIO - Landlord Training 100 10073100 61010 Adjust to Actual 100 10073100 61655 Adjust to Actual 100 10073100 61310 Adjust to Actual 100 10073100 61320 Adjust to Actual 100 10073100 61416 Adjust to Actual 100 10073100 61099 Adjust to Actual 100 10073100 62663 C/O - Permits Plus 3,000 100 10073100 53102 C/O -Handan, China 100 10073100 62716 C/O - Handan, China 100 10010100 62214 C/O 100 10074100 61010 Adjust to Actual 100 10074100 61310 Adjust to Actual 100 10074100 61320 Adjust to Actual 100 10074100 61416 Adjust to Actual 100 10074100 61099 Adjust to Actual 100 10074700 61010 Adjust to Actual 100 10074700 61310 Adjust to Actual 100 10074700 61320 Adjust to Actual 100 10074700 61416 Adjust to Actual 100 10074700 61099 Adjust to Actual 100 10076100 61010 Adjust to Actual 100 10076100 61310 Adjust to Actual 100 10076100 61320 Adjust to Actual 100 10076100 61416 Adjust to Actual 100 10076100 61099 Adjust to Actual 100 10077100 61010 Adjust to Actual 100 10077100 61310 Adjust to Actual FISCAL YEAR 2015 AMENDMENT #1 CITY COUNCIL Department Information Services Information Services Information Services Police Department Police Department Police Department Police Department Police Department Fire Department Fire Department Fire Department Fire Department Parks Division Parks Division Parks Division Parks Division Parks Division Civic Center Division Recreation Library Engineering Engineering Engineering Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Police Department Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Conference Center Conference Center Recreation Engineering Engineering Program Description 6 IS - Social Security 6 IS - Life Insurance 6 IS - Wage Adjustment 1 Replace Police/CAD Software 1C Replace Police/CAD Software - County Reimbursement 1C Replace Police/CAD Software - GO Bond Proceeds 1C Dictaphone System Upgrade - County Reimbursement 1C DLEC Telephone Upgrade 1C Outdoor Siren 1C Improvements to Station 4 1C Improvements to Station 4 1C Wireless Smoke Detectors 4C Eagle Point Stone 4C Marshall Park - Pool Repair 4C Catfish Creek Hike -Bike Trail Study - Consultant Services 4C Eagle Point Stone 4C Comiskey Park Building Alarm 4C Paint Arena Ceiling - Construction 4C Aquatic Center Feasibility 4C Library Integrated System 2C Safes Routes to School - Const Contract Not Building 2C Flood Plain Buyout - Land Acquisition 2C Accessibility Barriers - Construction 5C Maint of Vacant/Abandoned - Property Maintenance 5C Homeownership Grant 5C Homeownership Grants - Target 1C Police SAN - Computer 4C Comiskey Repair Siding - Construction 4C Comiskey New Entry - Construction 4C Comiskey Sidewalk Lighting 4C Eagle Point Stone 2C EPP - Paint BridgeNeranda/Indian Room 4C EPP - Riverfront Pavilion - Construction 4C EPP - Riverfront Pavilion - Consulting Engineers 4C Eagle Point Park Overlay Tennis Court Lot - Consulting 4C Eagle Point Park Overlay Tennis Court Lot- Construction 4C Comiskey Playground Replacement - Playground Equip 4C Comiskey Entry Sign - Signage 4C All Parks Replace Security Lights 4C Hilltop Park - 735 Calendonia Place Expansion 4C EPP Retaining Wall 4C EPP Clear Trees Bluff 6C GRC - Replace Outdoor Furniture 6C GRC - Cool Room Study 4C F&S Surge Tank Repair 2C Curb/Catch Basin Replacement -Construction 2C Decorative Concrete Maint - Construction FY 15 Expense Amount 643 18 (11,501) 244,674 Page 13 28,704 28,500 369 14,456 1,841 20,750 18,721 5,400 5,626 10,000 79,311 10,540 38,600 24,655 7,379 19,537 103 48,000 12,258 9,328 11,975 30,000 100,327 15,000 9,902 12,435 37,565 9,000 83,040 200,665 7,000 5,000 10,136 25,000 15,000 21,037 25,000 5,999 (2,992) 1,170 FY 15 Revenue Amount 100,000 139,080 9,008 26 -Aug -14 Fund Activity/CIP Account Explanation 100 10077100 61320 Adjust to Actual 100 10077100 61416 Adjust to Actual 100 10077100 61099 Adjust to Actual 101 1011167 71123 CIO 101 1011167 46205 C/O 101 1011167 54210 C/O 101 1012352 46205 CIO 101 1012457 62421 C/O 101 1011135 73410 C/O 101 1011444 73210 CIO 101 1011444 73210 C/O 101 1012453 72116 C/O 101 1011677 73211 CIO 101 1011983 73211 C/O 101 1012078 62716 C/O 101 1011677 73211 CIO Shift from Lincoln Ave 5 101 1012372 73210 C/O 101 1012117 73210 C/O 101 1012462 62716 CIO 101 1012469 71123 C/O 101 1011922 73211 CIO 101 1012419 73111 C/O 101 1011034 73210 C/O 101 1011002 62431 CIO 101 1011595 62765 Shift from Maint of Vacant/At 101 1011595 62765 C/O 102 1022454 71120 CIO 102 1021151 73210 C/O 102 1021544 73211 C/O 102 1022284 71517 CIO 102 1021677 73211 C/O 102 1022189 73210 CIO 102 1022190 62712 C/O 102 1022190 73210 CIO 102 1022289 62712 C/O 102 1022289 73211 CIO 102 1022292 72713 C/O 102 1022293 71227 C/O 102 1022368 73211 C/O 102 1022449 73211 C/O 102 1022459 73211 C/O 102 1022460 73211 C/O 102 1022306 71156 CIO 102 1022307 71156 C/O 102 1022463 73211 C/O 102 1021041 73211 C/O - Prespend FY15 102 1021630 73211 C/O FISCAL YEAR 2015 AMENDMENT #1 CITY COUNCIL Department Engineering Engineering Engineering Engineering Engineering Building Housing & Comm De\ Planning Services Planning Services Planning Services Public Information City Manager City Manager Finance Information Services Information Services TRANSIT FUND Parking Division Parking Division Parking Division Parking Division Transit Division Transit Division Transit Division Transit Division Transit Division Transit Division Transit Division Transit Division Transit Division Transit Division Transit Division Transit Division Transit Division Transit Division Transit Division Transit Division Transit Division Transit Division Transit Division Transit Division Transit Division Transit Division Transit Division Transit Division Transit Division Program Description 2C Ice Harbor Maintenance/Dredging 2C Ice Harbor Maintenance/Dredging 2C Federal Building Renovation - Construction 2C Intersection Preemption - Equipment 2C Fiber Optic Con - Priv & Misc 6C Downtown Urban Renewal ADA - Construction 5C Maint of Vacant/Abandoned - Property Maintenance 5C Annexation Study Implementation - Consultant Services 5C Historic Preservation Technical Assistance - Construction 5C Historic/Architectural & Evaluation - Consultant 6C GIS Enhancements - Peripherals, Computer 6C Sustainability Initiative - Consulting Engineers 6C Sustainability Initiative - Consultant Services 6C Finance Plus Upgrade - Employee Access Center 6C City -Wide Multifunction Replacement 6C 10G Backbone Upgrade TOTAL GENERAL FUND 8C Intermodel Facility - Construction 8C Intermodel Facility - FTA Capital 8C Intermodel Facility - Intercity Bus Grant 8C Intermodel Facility - Bond Proceeds 8 Transit Admin - Part -Time time employees 8 Transit Admin - IPERS 8 Transit Admin - Social Security 8 Transit Admin - Life Insurance 8 Transit Admin - Wage Adjustment 8 Bus Operations - Part -Time time employees 8 Bus Operations - IPERS 8 Bus Operations - Social Security 8 Bus Operations - Life Insurance 8 Bus Operations - Wage Adjustment 8 Minibus Operations - Part -Time time employees 8 Minibus Operations - IPERS 8 Minibus Operations - Social Security 8 Minibus Operations - Life Insurance 8 Minibus Operations - Wage Adjustment 8 Trolley Operations - Part -Time time employees 8 Trolley Operations - IPERS 8 Trolley Operations - Social Security 8 Trolley Operations - Wage Adjustment 8 Bus Maint- Part -Time time employees 8 Bus Maint- IPERS 8 Bus Maint- Social Security 8 Bus Maint- Life Insurance 8 Bus Maint - Wage Adjustment 8 Bus Operations - ICAAP Midtown Loop FY 15 Expense Amount 20,000 70,644 1,414 4,656 45,555 2,893 42,189 (1,659) 5,000 3,017 3,082 15,000 1,531 17,000 30,000 60,000 FY 15 Revenue Amount Page 14 4,849,655 3,424,011 2,078,164 1,855 (249) 555 1 (2,521) 12,326 (544) (437) (65) (15,499) 5,811 522 450 (70) (7,822) 585 53 45 (788) 1,163 105 89 1 (1,581) Fund Activity/CIP Acco unt Explanation 102 1021466 62811 CIO 102 1021466 73211 C/O 102 1021841 62712 C/O 102 1021023 73410 CIO 102 1021609 73410 C/O 102 1022424 73211 C/O 102 1021002 62431 CIO 102 1021012 62764 C/O 102 1022431 73210 C/O 102 1022432 62716 CIO 102 1021946 71120 C/O 102 1022218 62712 C/O 102 1022218 62716 CIO 102 1022166 71123 C/O 102 1022435 71116 C/O 102 1022488 71123 CIO 600 7,038,173 600 199,000 600 3,791, 881 600 600 600 600 600 600 600 600 600 600 600 600 600 600 600 600 600 600 600 600 600 600 600 600 600 98,789 600 6001614 73211 6001614 44150 6001614 45771 6001614 54210 60053100 61020 60053100 61310 60053100 61320 60053100 61416 60053100 61099 60053400 61020 60053400 61310 60053400 61320 60053400 61416 60053400 61099 60053500 61020 60053500 61310 60053500 61320 60053500 61416 60053500 61099 60053600 61020 60053600 61310 60053600 61320 60053600 61099 60053700 61020 60053700 61310 60053700 61320 60053700 61416 60053700 61099 60053400 45771 26 -Aug -14 C/O CIO - State of Good Repairs C/O - Intercity Grant C/O Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual CIO FISCAL YEAR 2015 AMENDMENT #1 CITY COUNCIL Department Transit Division Transit Division Transit Division Transit Division Transit Division Transit Division Transit Division Transit Division Transit Division Transit Division Transit Division Transit Division Transit Division Transit Division Transit Division Transit Division Program Description 8 Bus Operations - ICAAP Shopping Circulator 8 Bus Operations - ICAAP Nightrider 8 Bus Operations - Mobility Coordinator 8C Replace Fixed Route Buses - East Dubuque FTA 8C Replace Fixed Route Buses- Minibus Purchase 8C Replace Fixed Route Buses - State of Good Repair Grant 8C Replace Fixed Route Buses - ITS Project 8C Transit Roof Repair - State Grant 8C Transit Roof Repair - Construction 8C Transit Roof Repair - Consultant Engineers 8C Bus Stop Improvements - Construction 8C Bus Storage Facility - Consultant 8C Bus Storage Facility - Construction 8C Bus Storage Facility - State of Good Repairs Grant 8C Bus Storage Facility- DMATS STP Funds 8C Bus Storage Facility - State PTIG Grant TOTAL TRANSIT FUND DOWNTOWN LOAN POOL - TIF FUND Economic Devlopmt 5C Loan Pool, Downtown TIF - Loans Economic Devlopmt 5C Downtown Rehab Grant Program TOTAL DOWNTOWN LOAN POOL -TIF FUND ROAD USE TAX FUND Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works Engineering Engineering Engineering Engineering 2 Street - Full -Time time employees 2 Street- IPERS 2 Street - Social Security 2 Street - Life Insurance 2 Street - Wage Adjustment 2 Street Cleaning - Full -Time time employees 2 Street Cleaning- IPERS 2 Street Cleaning - Social Security 2 Street Cleaning - Life Insurance 2 Street Cleaning - Wage Adjustment 2 Snow - Full -Time time employees 2 Snow- IPERS 2 Snow - Social Security 2 Snow - Life Insurance 2 Snow - Wage Adjustment 2C Asphalt Milling Program - Construction 2C MSC Exhaust Fan - Construction 2C Snow & Ice Control - Salt 2C Brunskill Rd Bridge Repl - Construction 2C Railroad Cross Improvement - Construction 2C Traffic Signal Coordination - Consulting Engineers 2C LED Re -Lamp Schedule - Construction TOTAL ROAD USE TAX FUND FY 15 Expense Am ount 87,105 24,930 295,155 8,890 2,400 414,765 3,732,889 FY 15 Revenue Amount 38,827 32,516 18,595 87,105 19,995 257,800 961,827 2,585,827 600,000 6,638,283 15,730,335 941,843 80,397 1,022, 240 12,594 1,122 968 28 (17,255) 3,522 313 270 6 (4,802) 4,086 364 313 6 (5,582) 60,145 3,500 359,309 130,265 34,147 5,814 13,747 Page 15 602,880 26 -Aug -14 Fund Activity/CIP Acco unt Explanation 600 60053400 45771 CIO 600 60053400 45771 C/O 600 60053400 45771 C/O 600 6001224 44150 CIO 600 6001224 71312 C/O 600 6001224 44150 C/O 600 6001224 73411 CIO 600 6001613 45701 C/O 600 6001613 73210 C/O 600 6001613 62716 CIO 600 6002235 73210 C/O 600 6002446 62716 New Grant Appropriation 600 6002446 73211 New Grant Appropriation 600 6002446 44150 Shift from Intermodal 600 6002446 45725 New Grant 600 6002446 45701 New Grant 241 2411033 62764 C/O 241 2411942 62765 C/O 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 25054400 25054400 25054400 25054400 25054400 25054410 25054410 25054410 25054410 25054410 25054420 25054420 25054420 25054420 25054420 2501230 2502477 25054420 2501077 2502026 2501228 2501916 61010 61310 61320 61416 61099 61010 61310 61320 61416 61099 61010 61310 61320 61416 61099 73211 73210 62640 73211 73211 73211 73411 Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual C/O C/O CIO C/O C/O CIO C/O FISCAL YEAR 2015 AMENDMENT #1 CITY COUNCIL Department Program Description SPECIAL ASSESSMENT FUND Engineering Engineering Engineering Engineering Engineering 2C Special Assessment Receivable 2C Special Assessment Receivable 2C Special Assessment Receivable 2C Special Assessment Receivable 2C Special Assessment Receivable TOTAL SPECIAL ASSESSMENT FUND COMMUNITY DEVELOPMENT BLOCK GRANT FUND Multicultural Family C Recreation Recreation Recreation Recreation Engineering Engineering Economic Developme Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ 6C Multicultural Family Center - Construction 4 CD Target - Seasonal employees 4 CD Target -IPERS 4 CD Target - Social Security 4 CD Target - Wage Adjustment 2C Accessible Curb Ramps - Construction 5C Neighborhood Infrastructure Improvements - Construction 5C Commercial/Industrial Rehab Loan - CDBG 5C Homeownership Rehab Program -Loans 5C Homeownership Rehab Program -Loans 5C Homeownership Rehab Program -Home Repair 5C Rental Rehab - Loans 5C First Time Homebuyer Program -Loans 5C Historic Preservation Rehab Grant -Loans 5 CDBG Admin - Full time employees 5 CDBG Admin - IPERS 5 CDBG Admin - Social Security 5 CDBG Admin - Life Insurance 5 CDBG Admin - Wage Adjustment 5 CDBG Rehab - Full time employees 5 CDBG Rehab - IPERS 5 CDBG Rehab - Social Security 5 CDBG Rehab - Life Insurance 5 CDBG Rehab - Wage Adjustment 5 CDBG Inspection - Full time employees 5 CDBG Inspection - IPERS 5 CDBG Inspection - Social Security 5 CDBG Inspection - Life Insurance 5 CDBG Inspection - Wage Adjustment 5 CDBG Monitoring - Full time employees 5 CDBG Monitoring - IPERS 5 CDBG Monitoring - Social Security 5 CDBG Monitoring - Life Insurance 5 CDBG Monitoring - Wage Adjustment 5 Community Development Block Grant 5 General Housing Inspection - Education & Training 5 General Housing Inspection - Vehicle Outsourcing FY 15 Expense Am ount FY 15 Revenue Amount 124,000 307,000 95,917 212,000 35,831 Page 16 774,748 Fund ActivitylClP Account Explanation 255 25510255 255 25510255 255 25510255 255 25510255 255 25510255 52101 C/O 52101 CIO 52101 C/O 52101 C/O 52101 CIO 76,259 260 2601976 73210 700 260 26034500 61030 38 260 26034500 61310 53 260 26034500 61320 (930) 260 26034500 61099 37,952 260 2601236 73211 32,814 260 2601239 73211 185,806 260 2601235 62764 204 260 2601065 62764 221,150 260 2601065 62764 49,606 260 2601065 73210 34,042 260 2601233 62764 25,000 260 2601234 62764 7,059 260 2601237 62764 779 260 26061100 61010 69 260 26061100 61310 60 260 26061100 61320 1 260 26061100 61416 (1,056) 260 26061100 61099 3,255 260 26061300 61010 292 260 26061300 61310 248 260 26061300 61320 7 260 26061300 61416 (4,441) 260 26061300 61099 1,570 260 26061700 61010 139 260 26061700 61310 121 260 26061700 61320 3 260 26061700 61416 (2,163) 260 26061700 61099 882 260 26061800 61010 79 260 26061800 61310 67 260 26061800 61320 2 260 26061800 61416 (1,203) 260 26061800 61099 895,809 260 26061800 44205 488 260 26061700 62360 1,778 260 26061700 62525 26 -Aug -14 CIO CDBG Funds Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual CIO CDBG Funds CDBG Amend#1 C/O CDBG Funds CIO CDBG Interest Income C/O CDBG Interest Income C/O CDBG Interest Income CIO CDBG Funds C/O CDBG Funds C/O CDBG Funds Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual C/O CDBG Funds CIO CDBG Funds C/O CDBG Funds FISCAL YEAR 2015 AMENDMENT #1 CITY COUNCIL Department City Manager City Manager City Manager City Manager City Manager UDAG FUND Economic Devlopmt Economic Devlopmt Housing & Comm De\ Housing & Comm De\ Program Description 6 Neighborhood - Full time employees 6 Neighborhood - IPERS 6 Neighborhood - Social Security 6 Neighborhood - Life Insurance 6 Neighborhood - Wage Adjustment TOTAL COMMUNITY DEVELOPMENT BLOCK FUND 5C Job Creation - Loans 5C Airport Revenue Guarantee - Pay to Other Agency 5C Historic Preservation - Revolving Loans 5C Historic Preservation - Revolving Loans TOTAL UDAG FUND HOUSING TRUST FUND Housing & Comm De\ 5C Housing & Comm De\ 5C Housing & Comm De\ 5C Housing & Comm De\ 5C Housing & Comm De\ 5C Housing & Comm De\ 5C Housing & Comm De\ 5C Housing & Comm De\ 5C Housing & Comm De\ 5C Housing Trust Fund - Washington Neighborhood Housing Trust Fund - Washington Neighborhood Housing Trust Fund - Washington Neighborhood IFA Housing Trust 11-19 - Loans IFA Housing Trust 12-14 - Loans IFA Housing Trust 13-17 - Loans IFA Housing Trust 13-17 - Grants IFA Housing Trust 14-05 - Grants IFA Housing Trust 14-05 - Loans TOTAL HOUSING TRUST FUND STATE RENTAL REHAB FUND Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ 5C Homeownership Rehab Program -Construction 5C LHAP-Loans 5C Home - Rental Five Points TOTAL STATE RENTAL REHAB FUND LEAD PAINT GRANT FUND Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ SECTION 8 FUND Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ 5 Lead Paint - Full time employees 5 Lead Paint - IPERS 5 Lead Paint - Social Security 5 Lead Paint - Life Insurance 5 Lead Paint - Wage Adjustment TOTAL LEAD PAINT GRANT FUND 5 Section 8 Admin - Full time employees 5 Section 8 Admin - IPERS 5 Section 8 Admin - Social Security 5 Section 8 Admin - Life Insurance 5 Section 8 Admin - Wage Adjustment 5 Section 8 Voucher - Full time employees FY 15 Expense Amount 588 53 45 2 (802) 670,616 21,480 150,000 14,761 35,692 FY 15 Revenue Am ount 895,809 221,933 13,283 7,888 35,700 3,621 2,214 59,315 43,228 Fund Activity/CIP Account Explanation 260 26072800 61010 Adjust to Actual 260 26072800 61310 Adjust to Actual 260 26072800 61320 Adjust to Actual 260 26072800 61416 Adjust to Actual 260 26072800 61099 Adjust to Actual 265 265 265 265 268 268 268 268 268 268 108,357 268 43,228 268 268 165,249 158,251 23,911 439,956 151,585 622,118 2,430 215 185 5 (3,327) Page 17 (492) 391 35 30 1 (529) 7,330 2651246 2651796 2651247 2651247 2681021 2681021 2681021 2682285 2682443 2682270 2682270 2682285 2682285 62764 C/O 62761 CIO 62764 C/O 62764 C/O 62764 62764 62764 62764 62764 62764 45703 45703 62764 26 -Aug -14 CIO C/O- Program Income C/O- Program Income CIO C/O C/O CIO C/O C/O 270 2701065 73210 CIO 270 27061320 62764 C/O 270 2701250 73210 C/O 275 275 275 275 275 280 280 280 280 280 280 27561200 27561200 27561200 27561200 27561200 28061100 28061100 28061100 28061100 28061100 28061600 61010 Adjust to Actual 61310 Adjust to Actual 61320 Adjust to Actual 61416 Adjust to Actual 61099 Adjust to Actual 61010 Adjust to Actual 61310 Adjust to Actual 61320 Adjust to Actual 61416 Adjust to Actual 61099 Adjust to Actual 61010 Adjust to Actual CABLE TV FUNC Public Information FISCAL YEAR 2015 AMENDMENT #1 CITY COUNCIL Department Housing & Comm Housing & Comm Housing & Comm Housing & Comm Public Information Public Information Public Information Public Information Public Information Cable TV Cable TV Cable TV Cable TV Cable TV Program Description De\ 5 Section 8 Voucher- IPERS De\ 5 Section 8 Voucher- Social Security De\ 5 Section 8 Voucher- Life Insurance De\ 5 Section 8 Voucher- Wage Adjustment TOTAL SECTION 8 FUND 6 PIO - Full time employees 6 PIO -IPERS 6 PIO - Social Security 6 PIO - Life Insurance 6 PIO - Wage Adjustment 6 Public Information Office - Software License Exp 6 Cable TV - Full time employees 6 Cable TV - IPERS 6 Cable TV - Social Security 6 Cable TV - Life Insurance 6 Cable TV - Wage Adjustment TOTAL CABLE TV FUND STREET CONSTRUCTION FUND Public Works 2C Curb Replacement Program - Construction 2C Curb Ramp Program - Construction 2C Asphalt Milling Program - Construction 2C Downtown Sign Post Replacement- Signage 2C Truck Mounted New Concept Snow Plows 2C Guardrail Replacement - Construction 2C Corridor Study - Altematives 2C Brunskill Rd Bridge Repl - Fed Pass Thru Grant 2C Bridge Repairs/Maintenance - Construction 2C Southwest Arterial -Construction Not Building 2C Southwest Arterial-SAFETEA-LU 2C Southwest Arterial -County Match 2C Sidewalk Program City Owned 2C White Water Creek Bridge - Private Participant 2C White Water Creek Bridge - Lighting 2C N Cascade Road Reconstruction - Construction 2C N Cascade Road Reconstruction - State Highway 2C Sub -Divisions Subdrains - Construction Not Building 2C Sub -Divisions Subdrains - Consulting Engineers 2C Green Alley Pilot Project 2C Cedar Cross Reconstruction - Engineering Services 2C Cedar Cross Reconstruction - Land Acquisition 2C Cedar Cross Reconstruction - Construction 2C Cedar Cross Reconstruction - State Highway Assistance 2C Street Construction - General 2C Pavement Marking - Construction Public Works Public Works Public Works Public Works Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering FY 15 Expense Amount 656 562 17 (10,025) (1,532) 1,877 168 144 172 (2,565) 4,000 2,225 190 171 (7) (3,028) FY 15 Revenue Amount Page 18 3,347 14,972 49,072 25,503 40,000 31,312 5,001 200,000 192,085 350,432 (25,267) 10,000 1,479,919 23,360 28,125 24,775 239,530 307,507 1,196,567 (97,912) (48,690) 26 -Aug -14 Fund Activity/CIP Account Explanation 280 28061600 61310 Adjust to Actual 280 28061600 61320 Adjust to Actual 280 28061600 61416 Adjust to Actual 280 28061600 61099 Adjust to Actual 290 29072300 61010 290 29072300 61310 290 29072300 61320 290 29072300 61416 290 29072300 61099 290 29072300 62663 290 29075100 61010 290 29075100 61310 290 29075100 61320 290 29075100 61416 290 29075100 61099 300 3001226 73211 300 3001227 73211 300 3001230 73211 300 3001938 71227 300 3002221 71318 300 3001027 73211 300 3001039 62712 254,916 300 3001077 45771 300 3001258 73211 300 3001287 73211 1,143,638 300 3001287 45771 323,299 300 3001287 46205 300 3001425 73211 10,000 300 3001634 53102 300 3001634 62616 300 3002021 73211 1,031,233 300 3002021 45771 300 3002023 73211 300 3002023 62712 300 3002044 73211 300 3002139 62811 300 3002139 73111 300 3002139 73211 1,195,567 300 3002139 45771 300 3002142 73211 300 3002245 73211 Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual C/O Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O -Prespend FY15 C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O - Prespend FY15 C/O - Prespend FY15 FISCAL YEAR 2015 AMENDMENT #1 CITY COUNCIL Department Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Program Description Pennsylvania at Radford Intersection - Eng Division Services Pennsylvania at Radford Intersection - Construction University & Asbury Intersection University & Asbury Intersection - DMATS N Grandview Estates Road - Construction N Grandview Estates Road - Engineering N Grandview Estates Road - Reimbursements Manson Road Bridge- FEMA Manson Road Bridge - State Grant Asbury Road Grinding - Construction Signalization Program - Equipment Acquisition Traffic Control Batter Pack Traffic Signal Interconnect - Construction Not Building Signal Intersect Reconstruct -Construction Traffic Signal Fiber Optic Net - Construction Recon Signals/JFK-Wacker - Construction Recon Signals/JFK-Wacker - Construction Recon Signals/JFK-Wacker - Construction Traffic Signal Fiber Optic Net - Construction Recon Signals/JFK-Wacker - Construction Signalization Program - Equipment Acquisition Recon Signals/JFK-Wacker - Construction Traffic Signal Reconstruction - Construction Recon Signals/JFK-Wacker - Construction Cedar Cross Reconstruction - Construction Recon Signals/JFK-Wacker - Construction Traffic Signal Masterarm Retrofit - Construction Recon Signals/JFK-Wacker - Construction Painting Street Lights - Construction Recon Signals/JFK-Wacker - Construction Street Light Replacement - Construction Fiber Optic Conduit - Misc -Construction ITS Traffic Control Equipment Video Detection Camera Upgrade Surge & Ground Improvements - Signals Traffic Operations Video Software Traffic Operations Equipment Test Fiber Optics to Airport TOTAL STREET CONSTRUCTION FUND DICW CIP REPLACEMENT FUND Parks Division 4C DICW CIP Replacement TOTAL STREET CONSTRUCTION FUND SALES TAX INCREMENT CONSTRUCTION FUND Engineering 8C Bee Branch Alignment- Construction Engineering 8C Bee Branch Alignment- Flood Mitigation FY 15 Expense Amount 20,000 140,000 463,539 268,164 15,000 21,015 26,733 10,000 39,770 54,767 54,813 104,441 10,206 20,000 (20,000) 25,000 (25,000) 55,000 (55,000) 75,000 (75,000) 64,500 (64,500) 10,000 (10,000) 17,000 (17,000) 16,191 4,942 8,103 22,390 41,764 46,075 274,967 26 -Aug -14 FY 15 Revenue Amount Fund Activity/CIP Account Explanation 300 3002256 62811 CIO 300 3002256 73211 C/O 300 3002324 73211 C/O 340,000 300 3002324 45771 CIO 300 3002336 73211 C/O 300 3002336 62811 C/O 33,163 300 3002336 53620 CIO 186,963 300 3002349 44405 C/O 24,928 300 3002349 45701 C/O 300 3002482 73211 CIO 300 3001011 73410 C/O 300 3001229 73410 CIO 300 3001266 73211 C/O 300 3001615 73211 CIO 300 3001631 73410 C/O 300 3001919 73211 CIO 300 3001919 73211 C/O - Shift from LED ReplacF 300 3001919 73211 CIO - Shift from Traffic Signa 300 3001631 73410 Shift to Recon Signals JFK 300 3001919 73211 C/O - Shift from Signalization 300 3001011 73410 Shift to Recon Signals JFK 300 3001919 73211 Shift from Traffic Signal Recc 300 3001615 73211 Shift to Recon Signals JFK 300 3001919 73211 Shift from Cedar Cross Reco 300 3002139 73211 Shift to Recon Signals JFK 300 3001919 73211 Shift from Traffic Signal Mast 300 3001133 73211 Shift to Recon Signals JFK 300 3001919 73211 Shift from Painting Street Lig 300 3001917 73211 Shift to Recon Signals JFK 300 3001919 73211 Shift from Street Light Replc 300 3001549 73211 Shift to Recon Signals JFK 300 3002144 73211 CIO 300 3002253 73211 CIO 300 3002325 73410 C/O 300 3002420 73410 CIO 300 3002422 71123 CIO 300 3002423 71123 C/O 300 3002491 73411 CIO 5,689,171 4,543,707 3,374 325 3252568 72713 CIO 3,374 19, 849,482 340 3401654 73211 C/O 11,784,818 340 3401654 54215 CIO Page 19 FISCAL YEAR 2015 AMENDMENT #1 CITY COUNCIL Department Program Description TOTAL SALES TAX INCREMENT CONSTRUCTION FUND SALES TAX FUND (20%) Emergency Communi 1C Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Civic Center Division Civic Center Division Civic Center Division Civic Center Division Civic Center Division Civic Center Division Civic Center Division Conference Center Conference Center Recreation Library Library Public Works Public Works Engineering Engineering Engineering Engineering Engineering Engineering Engineering 4C 4C 4C 4C 4C 4C 4C 4C 4C 4C 4C 4C 4C 4C 4C 4C 4C 4C 4C 4C 4C 4C 4C 4C 4C 4C 4C 4C 4C 6C 6C 4C 4C 4C 2C 2C 2C 2C 2C 2C 2C 2C 2C Radio Equipment Tower Relocation Playground Improvements Northend Trail Lighting - Construction Renovate Park Water System - Consulting Renovate Park Water System - Construction Comiskey Park Replace Exterior Door Renovate Park Sidewalks - Construction EPP Replace Walkway - Const Cont - Not Bldg Street Tree Program - Tree Planting Veteran's Park - Renovate 32nd Storage Slattery Center Renovate Entrance Comiskey Park Amenity Replacement Plan Highway 20 Roses Madison Park - Fence EPP Paint Pavilions - Construction Miller Riverview Paving Maint Headquarters Restroom Rehab - Construction Electronic Locks Restrooms - Construction Bunker Replace Roof Main - Construction Roof Replacement Bunker/Patrol/MC Parking Lot Striping EPP Bridge Beam Support -Construction Flora Playground Equipment Theatre Tuckpoint Exterior - Construction Theatre Tuckpoint Exterior - Consultant Services Seal Concrete Walkways - Construction Arena Roof - Construction Arena Light Fixtures - Consulting Arena Light Fixtures - Construction Theatre Exterior Lights GRC - Maintenance GRC - Replace Sink/Urinal Controls Golf Course Irrigation Library Renovation Repairs - Construction Library Attic Access Floodwall Post Flood Repair - Construction Cold Storage Building Mezz - Construction Not Building Decorative Concrete Maint - Construction Sidewalk Financial Assistance Stone Retaining Walls - Construction Not Building Accessibility Barriers - Construction Riverfront Leasehold Improvements - Consultant Services Rehab Railroad Tracks Downtown Street Light Replacement FY 15 FY 15 Expense Revenue Amount Amount Fund ActivitylClP Account Explanation 19,849,482 11,784,818 Page 20 26 -Aug -14 843 350 3502353 72410 CIO 22,487 350 3501048 73410 C/O 31,227 350 3501129 73211 C/O 11,578 350 3501158 62712 CIO 24,456 350 3501158 73211 C/O 5,797 350 3501197 73210 C/O 19,050 350 3501438 73211 CIO 5,372 350 3501453 73211 C/O 3,749 350 3501458 73311 C/O 14,910 350 3501462 73210 CIO 29,300 350 3501468 73210 C/O 58,910 350 3501578 73211 C/O 15,000 350 3501588 73310 CIO 5,220 350 3502572 73211 C/O Shift from Murphy Park F 25,000 350 3502358 73210 C/O 25,000 350 3502362 73211 CIO 5,802 350 3502364 73210 C/O 4,239 350 3502365 73210 C/O 61,664 350 3502369 73210 CIO 1,943 350 3502370 73210 C/O 9,208 350 3502373 73211 C/O 17,039 350 3502376 73210 CIO 30,183 350 3502377 73410 C/O 242,216 350 3501708 73210 C/O 2,200 350 3501708 62716 CIO 17,852 350 3502303 73211 C/O 386,729 350 3502378 73210 C/O 10,461 350 3502379 62712 CIO 161,000 350 3502379 73210 C/O 6,945 350 3502381 73210 C/O 1,723 350 3501598 73210 CIO 5,767 350 3502465 73210 C/O 14,738 350 3501530 73210 C/O 90,836 350 3502308 73211 CIO 24,600 350 3502470 73210 C/O 27,818 350 3501445 73211 C/O 9,021 350 3502037 73211 CIO 32,003 350 3501630 73211 C/O 12,451 350 3501727 62761 C/O 83,782 350 3501029 73211 CIO 18,458 350 3501034 73210 C/O 100,574 350 3501053 62716 C/O 48,999 350 3501465 73211 CIO (2,048) 350 3501608 73410 C/O FISCAL YEAR 2015 AMENDMENT #1 CITY COUNCIL Department Building Building Building Building Planning Services Planning Services Planning Services Program Description 6C City Hall Remodeling - Construction 6C City Hall Annex Maint - Construction 6C Smart Meters - Construction 6C 18th St Building Improvements - Reimbursements 5C Trails/Complete Streets 5C Trails/Complete Streets - IDNR Reap Grant 5C Trails/Complete Streets - DMATS TE Grant TOTAL SALES TAX FUND GENERAL CONSTRUCTION FUND Multicultural Family C Parks Division Parks Division Parks Division Parks Division Parks Division Parking Division Parking Division Parking Division Transit Division Engineering Engineering Engineering Engineering Engineering Building Economic Devlopmt Economic Devlopmt Economic Devlopmt Economic Devlopmt Economic Devlopmt Economic Devlopmt Economic Devlopmt Economic Devlopmt Economic Devlopmt Economic Devlopmt Planning Services Planning Services Planning Services 6C Multicultural Family Center - Construction 4C Comiskey Landscape - Construction 4C Replace Park Signs 4C DICW Wildflowers - Landscaping 4C Granger Creek Trail - Construction 4C McAleece Sidewalks - Construction 8C Millwork District Parking Imp - Construction 8C Millwork District Parking Imp - Bond Proceeds 8C Port of Dubuque Ramp Repairs - Construction 7C Transit Roof Repair- Bond Proceeds 2C 1 Way to 2 Way Conversion 2C 18th Street Wall Reconstruction - Construction 2C HWY 52 Phase II Rehab - Construction 2C HWY 52 Phase II Rehab - IDOT Funding 2C Downtown Street Light Replacement 6C Downtown Urban Renewal ADA - Construction 5C Downtown Rehab Consultant - Financial Consultant 5C Design South Siegert Farm - Construction 5C Design South Siegert Farm - Rise Grant 5C Downtown Housing Incentive- Loans 5C Washington Neighborhood Facade Grants - Grants 5C Future Industrial Acquisitions - Consultant Services 5C Washington Neighborhood Downtown Incentives - Loans 5C Washington Neighborhood Downtown Incentives - Bond 5C Millwork District Incentives - Loans 5C Millwork District Incentives - GO Bond Proceeds 5C Riverfront 2000 Plan - Consulting 5C Historic Preservation Technical Assistance - Construction 5C Historic/Architectural & Evaluation - Consultant TOTAL GENERAL CONSTRUCTION FUND GOLF CONSTRUCTION FUND Recreation Recreation Recreation 4C Golf Tee Improvements 4C Golf Course Irrigation 4C Bunker Detention Basin #17 TOTAL GOLF CONSTRUCTION FUND FY 15 Expense Amount 141,883 37,654 165,310 297,000 FY 15 Revenue Amount Fund Activity/CIP Account Explanation 350 3501045 73210 CIO 350 3501757 73210 C/O 350 3502259 73210 C/O 672,207 350 3501975 53620 CIO 350 3502430 73210 C/O 200,000 350 3502430 45707 C/O 50,000 350 3502430 45707 CIO 2,365,949 1,480,548 50,000 10,000 164,970 192,026 20,401 3,237,694 620,736 28,734 136,185 35,059 12,484 21,861 89,186 3,576,894 1,227,240 153,129 107,804 1,437,325 670,000 15,000 10,000 10,000 922,207 360 3601976 73210 C/O 360 3601105 73210 C/O 360 3601774 71227 CIO 360 3602158 73310 C/O 360 3602371 73211 C/O 360 3602374 73211 CIO 360 3602250 73211 C/O 1,500,000 360 3602250 54210 C/O 360 3601957 73211 CIO 64,450 360 36010360 54210 C/O 360 3602442 73211 C/O 360 3602481 73211 CIO 360 3602483 73211 C/O 464,410 360 3602483 45771 CIO 360 3601608 73410 CIO 360 3602424 73211 C/O 360 3602157 62721 CIO 360 3602160 73211 CIO 229,247 360 3602160 45741 C/O 360 3602267 62764 CIO 360 3602436 62765 CIO 360 3602437 62716 C/O 360 3602438 62764 CIO 750,000 360 3602438 54210 CIO 360 3602439 62764 C/O 670,000 360 3602439 54210 CIO 360 3601015 62712 CIO 360 3602431 73210 C/O 360 3602432 62716 CIO 13,307,276 3,678,107 9,141 370 3701527 73211 CIO 85,306 370 3701530 73210 C/O 3,212 370 3702382 73210 CIO Page 21 97,659 26 -Aug -14 FISCAL YEAR 2015 AMENDMENT #1 CITY COUNCIL 26 -Aug -14 FY 15 FY 15 Expense Revenue Department Program Description Amount Amount Fund ActivitylClP Account Explanation AIRPORT CONSTRUCTION FUND Airport Department 2C Pavement Condition Index - Consulting Engineers 34,650 390 3901060 62712 C/O Airport Department 2C Pavement Condition Index - FAA Funds 33,000 390 3901060 44105 C/O Airport Department 2C FBO Counter/Office Floor- Construction 28,950 390 3901448 73210 CIO Airport Department 2C Terminal - RW 31 Parallel - Consulting Engineers 248,100 390 3901891 62712 C/O Airport Department 2C Terminal - RW 31 Parallel - Construction 3,181,772 390 3901891 73211 C/O Airport Department 2C Terminal - RW 31 Parallel -FAA Funds 3,295,567 390 3901891 44105 CIO Airport Department 2C Extend Gen'I Aviation Ramp - Consulting Engineers 5,000 390 3901893 62712 C/O Airport Department 2C Extend Gen'I Aviation Ramp - Construction 49,000 390 3901893 73211 C/O Airport Department 2C Terminal Sitework - Construction 250,000 390 3902009 73211 CIO Airport Department 2C Terminal Sitework - Consulting 14,000 390 3902009 62712 C/O Airport Department 2C Terminal Sitework - FAA Funds 345,800 390 3902009 44105 C/O Airport Department 2C Terminal Utility Improvement - Consulting Engineers 129,881 390 3902010 62712 CIO Airport Department 2C Terminal Utility Improvement - Construction 574,250 390 3902010 62712 C/O Airport Department 2C Terminal Utility Improvement - FAA Funds 333,988 390 3902010 44105 C/O Airport Department 2C Onsite Water and Wastewater- FAA Funds 1,414,863 390 3902010 44105 CIO Airport Department 2C Onsite Water and Wastewater - GO Bond Proceeds 636,823 390 3902010 54210 C/O Airport Department 2C Paint Hangar Exteriors - Construction 12,000 390 3902125 73210 C/O Airport Department 2C Terminal Boiler Replace - Construction 38,000 390 3902126 73211 CIO Airport Department 2C New Terminal Facility - Construction 1,284,362 390 3902213 72310 C/O Airport Department 2C New Terminal Facility - Consulting 336,243 390 3902213 62712 C/O Airport Department 2C New Terminal Facility- FAA Funds 1,914,801 390 3902213 44105 CIO Airport Department 2C Old Airline Terminal Assessment - Consulting 9 390 3902214 62712 C/O Airport Department 2C HVAC Joint Use Building - Construction 36,250 390 3902403 73210 C/O Airport Department 2C ADF Containment - Consultant Services 94,957 390 3902448 62716 CIO Airport Department 2C New Term Facilities Roads and Aprons - Construction 2,320,914 390 3902316 73211 C/O Airport Department 2C New Term Facilities Roads and Aprons - Consulting 26,236 390 3902316 62716 C/O Airport Department 2C New Term Facilities Roads and Aprons - FAA Funds 2,448,532 390 3902316 44105 CIO Airport Department 2C New Term Facilities Roads and Aprons - RISE Grant 15,756 390 3902316 44105 C/O Airport Department 2C New Terminal Parking Phase 1&2 - Construction 2,084,850 390 3902475 73211 C/O Airport Department 2C New Terminal Parking Phase 1&2- FAA Funds 1,876,365 390 3902475 44105 CIO TOTAL AIRPORT CONSTRUCTION FUND 10,749,424 12,315,495 BOND FUND Recreation 7 GO Bond Proceeds 14,694 440 44010440 54210 C/O TOTAL BOND FUND 14,694 SANITARY OPERATING FUND Water & Resource Re 8 Admin - Full -Time time employees 1,557 610 61043100 61010 Adjust to Actual Water & Resource Re 8 Admin-IPERS 139 610 61043100 61310 Adjust to Actual Water & Resource Re 8 Admin - Social Security 119 610 61043100 61320 Adjust to Actual Water & Resource Re 8 Admin - Life Insurance 3 610 61043100 61416 Adjust to Actual Water & Resource Re 8 Admin - Wage Adjustment (2,125) 610 61043100 61099 Adjust to Actual Water & Resource Re 8 Plant Ops - Full -Time time employees 10,703 610 61043400 61010 Adjust to Actual Water & Resource Re 8 Plant Ops- IPERS 154 610 61043400 61310 Adjust to Actual Water & Resource Re 8 Plant Ops - Social Security (6,954) 610 61043400 61320 Adjust to Actual Water & Resource Re 8 Plant Ops - Life Insurance 21 610 61043400 61416 Adjust to Actual Page 22 FISCAL YEAR 2015 AMENDMENT #1 CITY COUNCIL Department Program Water & Resource Re 8 Water & Resource Re 8 Water & Resource Re 8 Water & Resource Re 8 Water & Resource Re 8 Water & Resource Re 8 Public Works 8 Public Works 8 Public Works 8 Public Works 8 Public Works 8 Engineering 8 Engineering 8 Engineering 8 Engineering 8 Engineering 8 Descriptio n Plant Ops - Wage Adjustment Environ - Full -Time time employees Environ- IPERS Environ Ops - Social Security Environ - Life Insurance Environ - Wage Adjustment Sanitary- Full -Time time employees Sanitary- IPERS Sanitary - Social Security Sanitary - Life Insurance Sanitary - Wage Adjustment Sanitary Engineering - Full -Time time employees Sanitary Engineering- IPERS Sanitary Engineering - Social Security Sanitary Engineering - Life Insurance Sanitary Engineering - Wage Adjustment TOTAL SANITARY OPERATING FUND STORMWATER OPERATING FUND Parks Division 8 Public Works 8 Public Works 8 Public Works 8 Public Works 8 Public Works 8 Engineering 8 Engineering 8 Engineering 8 Engineering 8 Engineering 8 PARKING OPERATING FUND Parking Division 8 Parking Division 8 Parking Division 8 Parking Division 8 Parking Division 8 Parking Division 8 Parking Division 8 Parking Division 8 Parking Division 8 Parking Division 8 Parking Division 8 Parking Division 8 Parking Division 8 Parking Division 8 Storm Area Maintenance - Landscape Stormwater - Full -Time time employees Stormwater- IPERS Stormwater - Social Security Stormwater - Life Insurance Stormwater - Wage Adjustment Storm Engineering - Full -Time time employees Storm Engineering- IPERS Storm Engineering - Social Security Storm Engineering - Life Insurance Storm Engineering - Wage Adjustment TOTAL STORMWATER OPERATING FUND Locust - Full -Time time employees Locust- IPERS Locust - Social Security Locust - Life Insurance Locust - Wage Adjustment Iowa - Full -Time time employees Iowa- IPERS Iowa - Social Security Iowa - Life Insurance Iowa - Wage Adjustment 5th - Full -Time time employees 5th- IPERS 5th - Social Security 5th - Life Insurance FY 15 Expense Amount (14,517) 2,810 251 214 6 (3,818) 4,660 419 358 7 (6,399) 917 80 71 3 (1,243) FY 15 Revenue Amount (12,564) 2,969 1,401 308 108 2 (1,924) 1,070 94 82 3 (1,446) Page 23 2,667 2,078 187 42 4 (2,834) 2,010 181 392 4 (2,735) 797 72 61 1 Fund ActivityICIP Account Explanation 610 61043400 61099 Adjust to Actual 610 61043700 61010 Adjust to Actual 610 61043700 61310 Adjust to Actual 610 61043700 61320 Adjust to Actual 610 61043700 61416 Adjust to Actual 610 61043700 61099 Adjust to Actual 610 61054300 61010 Adjust to Actual 610 61054300 61310 Adjust to Actual 610 61054300 61320 Adjust to Actual 610 61054300 61416 Adjust to Actual 610 61054300 61099 Adjust to Actual 610 61055400 61010 Adjust to Actual 610 61055400 61310 Adjust to Actual 610 61055400 61320 Adjust to Actual 610 61055400 61416 Adjust to Actual 610 61055400 61099 Adjust to Actual 620 62030440 62637 620 62054310 61010 620 62054310 61310 620 62054310 61320 620 62054310 61416 620 62054310 61099 620 62055620 61010 620 62055620 61310 620 62055620 61320 620 62055620 61416 620 62055620 61099 630 630 630 630 630 630 630 630 630 630 630 630 630 630 63046300 63046300 63046300 63046300 63046300 63046310 63046310 63046310 63046310 63046310 63046320 63046320 63046320 63046320 61010 61310 61320 61416 61099 61010 61310 61320 61416 61099 61010 61310 61320 61416 C/O Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual 26 -Aug -14 FISCAL YEAR 2015 AMENDMENT #1 CITY COUNCIL Department Parking Division 8 Parking Division 8 Parking Division 8 Parking Division 8 Parking Division 8 Parking Division 8 Parking Division 8 Parking Division 8 Parking Division 8 Parking Division 8 Parking Division 8 Parking Division 8 Parking Division 8 Parking Division 8 Parking Division 8 Parking Division 8 Parking Division 8 Parking Division 8 Parking Division 8 Parking Division 8 Parking Division 8 Parking Division 8 Parking Division 8 Parking Division 8 Parking Division 8 Program Description 5th - Wage Adjustment Five Flags - Full -Time time employees Five Flags- IPERS Five Flags - Social Security Five Flags - Life Insurance Five Flags - Wage Adjustment Central - Full -Time time employees Central- IPERS Central - Social Security Central - Life Insurance Central - Wage Adjustment Lots - Full -Time time employees Lots- IPERS Lots - Social Security Lots - Life Insurance Lots - Wage Adjustment Meters - Full -Time time employees Meters- IPERS Meters - Social Security Meters - Life Insurance Meters - Wage Adjustment Enforcement - Part -Time time employees Enforcement- (PERS Enforcement - Social Security Enforcement- Wage Adjustment TOTAL PARKING OPERATING FUND WATER OPERATING FUND Water Department 8 Water Department 8 Water Department 8 Water Department 8 Water Department 8 Water Department 8 Water Department 8 Water Department 8 Water Department 8 Water Department 8 Water Department 8 Water Department 8 Water Department 8 Water Department 8 Water Department 8 Water Department 8 Water Department 8 Water Department 8 Water Department 8 Admin - Full -Time time employees Admin- IPERS Admin - Social Security Admin - Life Insurance Admin - Wage Adjustment Meters - Full -Time time employees Meters- IPERS Meters - Social Security Meters - Life Insurance Meters - Wage Adjustment Plant Op - Full -Time time employees Plant Op- IPERS Plant Op - Social Security Plant Op - Life Insurance Plant Op - Wage Adjustment Water Distrib - Full -Time time employees Water Distrib- IPERS Water Distrib - Social Security Water Distrib - Life Insurance FY 15 Expense Amount (1,074) 596 54 44 (810) 497 45 39 1 (691) 256 23 19 (347) 768 68 59 2 (1,050) 1,732 154 134 (2,380) FY 15 Revenue Am ount Page 24 (1,601) 3,088 275 236 (1) (4,211) 2,197 196 168 (20) (3,016) 9,097 814 696 (71) (12,309) 4,794 685 590 (102) Fund ActivityICIP Account Explanation 630 63046320 61099 Adjust to Actual 630 63046330 61010 Adjust to Actual 630 63046330 61310 Adjust to Actual 630 63046330 61320 Adjust to Actual 630 63046330 61416 Adjust to Actual 630 63046330 61099 Adjust to Actual 630 63046360 61010 Adjust to Actual 630 63046360 61310 Adjust to Actual 630 63046360 61320 Adjust to Actual 630 63046360 61416 Adjust to Actual 630 63046360 61099 Adjust to Actual 630 63046400 61010 Adjust to Actual 630 63046400 61310 Adjust to Actual 630 63046400 61320 Adjust to Actual 630 63046400 61416 Adjust to Actual 630 63046400 61099 Adjust to Actual 630 63046420 61010 Adjust to Actual 630 63046420 61310 Adjust to Actual 630 63046420 61320 Adjust to Actual 630 63046420 61416 Adjust to Actual 630 63046420 61099 Adjust to Actual 630 63046430 61020 Adjust to Actual 630 63046430 61310 Adjust to Actual 630 63046430 61320 Adjust to Actual 630 63046430 61099 Adjust to Actual 640 640 640 640 640 640 640 640 640 640 640 640 640 640 640 640 640 640 640 64042100 64042100 64042100 64042100 64042100 64042300 64042300 64042300 64042300 64042300 64042400 64042400 64042400 64042400 64042400 64042700 64042700 64042700 64042700 61010 61310 61320 61416 61099 61010 61310 61320 61416 61099 61010 61310 61320 61416 61099 61010 61310 61320 61416 Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual 26 -Aug -14 FISCAL YEAR 2015 AMENDMENT #1 CITY COUNCIL FY 15 FY 15 Expense Revenue Department Program Description Amount Amount Fund Activity/CIP Account Explanation Water Department 8 Water Distrib - Wage Adjustment (10,513) 640 64042700 61099 Adjust to Actual Finance 8 Meter - Full time employees 1,285 640 64074710 61010 Adjust to Actual Finance 8 Meter -IPERS 115 640 64074710 61310 Adjust to Actual Finance 8 Meter - Social Security 98 640 64074710 61320 Adjust to Actual Finance 8 Meter - Life Insurance 2 640 64074710 61416 Adjust to Actual Finance 8 Meter - Wage Adjustment (1,771) 640 64074710 61099 Adjust to Actual TOTAL WATER OPERATING FUND (7,678) REFUSE FUND Public Works 8 Refuse - Full -Time time employees 7,857 670 67054500 61010 Adjust to Actual Public Works 8 Refuse- IPERS 700 670 67054500 61310 Adjust to Actual Public Works 8 Refuse - Social Security 601 670 67054500 61320 Adjust to Actual Public Works 8 Refuse - Life Insurance 17 670 67054500 61416 Adjust to Actual Public Works 8 Refuse - Wage Adjustment (10,714) 670 67054500 61099 Adjust to Actual Public Works 8 Yard Waste - Full -Time time employees 1,164 670 67054510 61010 Adjust to Actual Public Works 8 Yard Waste- IPERS 103 670 67054510 61310 Adjust to Actual Public Works 8 Yard Waste - Social Security 87 670 67054510 61320 Adjust to Actual Public Works 8 Yard Waste - Life Insurance 3 670 67054510 61416 Adjust to Actual Public Works 8 Yard Waste - Wage Adjustment (1,586) 670 67054510 61099 Adjust to Actual Public Works 8 Large Item - Full -Time time employees 139 670 67054520 61010 Adjust to Actual Public Works 8 Large Item- IPERS 57 670 67054520 61310 Adjust to Actual Public Works 8 Large Item - Social Security 12 670 67054520 61320 Adjust to Actual Public Works 8 Large Item - Wage Adjustment (193) 670 67054520 61099 Adjust to Actual Public Works 8 Recycling - Full -Time time employees 6,422 670 67054530 61010 Adjust to Actual Public Works 8 Recycling- IPERS 575 670 67054530 61310 Adjust to Actual Public Works 8 Recycling - Social Security 493 670 67054530 61320 Adjust to Actual Public Works 8 Recycling - Life Insurance 15 670 67054530 61416 Adjust to Actual Public Works 8 Recycling - Wage Adjustment (8,755) 670 67054530 61099 Adjust to Actual Public Works 8C Dual Packer Recycle Vehicles 40,846 670 6701533 73410 C/O Public Works 8C Public Works Fleet GPS/AVL Project 4,611 670 6701935 73410 C/O Public Works 8C MSC Exhaust Fan - Consulting 825 670 6702477 62712 CIO Public Works 8C MSC Exhaust Fan - Construction 3,750 670 6702477 73210 C/O Public Works 8C Refuse Collection - Carts 6,000 670 67054500 71221 C/O Public Works 8C Recycling - Carts 5,686 670 67054530 71221 CIO Public Works 8C Intelligent Discard Mgmt - Pay to Other Agency 9,610 670 67054550 62761 C/O Public Works 8C Intelligent Discard Mgmt - Software 1,500 670 67054550 71123 C/O TOTAL REFUSE FUND 69,825 SALT OPERATIONS FUND Public Works 8C Purina Drive Barge Facility Scale 16,326 680 6802320 73211 CIO TOTAL SALT OPERATIONS FUND 16,326 AMERICA'S RIVER PROJECT FUND Economic Devlopmt 8C Art in Port of Dubuque - Consultant Services 100,474 700 7001853 62731 C/O TOTAL AMERICA'S RIVER PROJECT FUND 100,474 SANITARY SEWER CONSTRUCTION FUND Page 25 26 -Aug -14 FISCAL YEAR 2015 AMENDMENT #1 CITY COUNCIL Department Program Water & Resource Re 8C Water & Resource Re Water & Resource Re Water & Resource Re Water & Resource Re Water & Resource Re Public Works Public Works Public Works Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Public Information Description Scada System Upgrade - Construction - Not Building 8C WPC Plant Facility Study - Construction Building 8C WPC Plant Facility Study - SRF Bond Proceeds 8C Terminal Street Mag Meter Repair - Consulting 8C Bradley/Perry Force Main - Consulting 8C Bradley/Perry Force Main - Construction 8C Sewer Pipeline Inspection Equip 2C Mobile GIS System 8C High Pressure Sewer Jet - GO Bond Proceeds 8C Sewer Conn Asst -Low/Mod - Miscellaneous Services 8C Lateral Repl Asst. Low Inc - Eng. Division Services 8C Auburn - Custer Sanitary Sewer - Eng Division Services 8C Auburn - Custer Sanitary Sewer - Construction 8C Sewer Lateral Assistance - Eng Division Services 8C Sewer Lateral Assistance - Construction Not Bldg 8C Laterals - I&I Reduction 80 Alley Washington -Jackson Sewer- Construction 8C Loras/Walnut to Prairie St Sewer - Construction 8C Hwy 20 Annexation Sanitary Sewers - Construction 8C Monroe St Sanitary Sewer - Construction 8C Southfork Interceptor - Consulting Engineers 8C Southfork Interceptor - Const Cont - Not Bldg 8C Laurel St Sanitary Sewer - Eng Division Services 8C Laurel St Sanitary Sewer - Const Not Bldg 8C Brunswick Sanitary Sewer - Construction 8C Brunswick Sanitary Sewer - Engineering Division Services 8C Southgate Sanitary Sewer - Construction 8C Southgate Sanitary Sewer - Eng Division Services 8C Hawthorne Sanitary - Engineering 8C Hawthorne Sanitary - Construction 8C Knob Hill - Duggan Dr - Engineering 8C Knob Hill - Duggan Dr- Construction 8C Fox Blackhawk Sanitary - Engineering 8C Fox Blackhawk Sanitary - Construction 8C King St Sanitary - Engineering 8C King St Sanitary- Construction 8C Washington Elm 24th to 25th - Engineering 8C Washington Elm 24th to 25th - Construction 8C Washington Elm 24th to 25th - Go Bonds 8C Granger Creek Sanitary - Engineering 8C Granger Creek Sanitary - Construction 8C Granger Creek Sanitary - GO Bonds 8C Cedar Lift Pump/Generator/Trailer - Construction 80 $9.4 Green Alleys - SRF Proceeds 80 $9.4 Green Alleys - Engineering 8C $9.4 Green Alleys - Construction 8C GIS Enhancements - Peripherals, Computer FY 15 Expense Amount 42,929 426,364 290,535 5,045 90,000 2,459 7,552 31,277 20,000 40,000 271,065 46,448 53,565 27,201 130,000 54,542 257,721 6,947 22,374 213,628 28,724 300,000 58,819 8,203 34,000 4,000 4,000 15,187 15,000 94,024 9,748 85,533 7,365 43,284 5,000 55,000 270,000 2,439,989 99,749 90,000 7,273,186 5,291 FY 15 Revenue Amount Fund Activity/CIP Account Explanation 710 7101339 73211 0/0 710 7101837 73210 0/0 1,714,392 710 7101837 54230 0/0 710 7102211 62712 0/0 710 7102474 62712 0/0 710 7102474 73211 0/0 710 7101840 73410 0/0 710 7102225 73410 0/0 165,000 710 7102405 54210 0/0 710 7101067 62731 0/0 710 7101297 62811 0/0 710 7102571 62811 0/0 710 7102571 73510 0/0 710 7101309 62811 0/0 710 7101309 73211 0/0 710 7101320 73211 0/0 710 7101327 73211 0/0 710 7101328 73211 0/0 710 7101336 73211 0/0 710 7101797 73211 0/0 710 7101899 62712 0/0 710 7101899 73211 0/0 710 7102130 62811 0/0 710 7102130 73211 0/0 710 7102232 73211 0/0 710 7102232 62811 0/0 710 7102234 73211 0/0 710 7102234 62811 0/0 710 7102322 62811 0/0 710 7102322 73211 0/0 710 7102323 62811 0/0 710 7102323 73211 0/0 710 7102406 62811 0/0 710 7102406 73211 0/0 710 7102407 62811 0/0 710 7102407 73211 0/0 710 7102408 62811 0/0 710 7102408 73211 0/0 60,000 710 7102408 54210 0/0 710 7102409 62811 0/0 710 7102409 73211 0/0 2,446,722 710 7102409 54210 0/0 710 7102412 73211 0/0 8,986,802 710 7102450 54230 0/0 710 7102450 62811 0/0 710 7102450 73211 0/0 710 7101946 71120 0/0 Page 26 26 -Aug -14 FISCAL YEAR 2015 AMENDMENT #1 CITY COUNCIL Department Program Description TOTAL SANITARY SEWER CONST FUND STORM WATER CONSTRUCTION FUND Parks Division 8C Parks Division Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering 8C 8C 2C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C Eagle Point Park Stormwater - Construction Bee Branch Trees Forever- Tree Planting PW Fleet GPS Project- Pager/Radio Equipment Mobile GIS System Bee Branch Pump Station - Consulting Bee Branch Pump Station - Construction Flood High Water Alarm - Construction Bee Branch Gate Replacement Purina Drive Floodwall - Consulting Purina Drive Floodwall - Construction Storm Sewer Improvements - Construction Catch Basin/Westside - Construction Not Building Kaufmann Ave Storm - Engineering Kaufmann Ave Storm - Construction Kaufmann Ave Storni - Land Acquisition Wallis & Arrowhead Storm - Engineering Wallis & Arrowhead Storm - Construction Streambank Rehab - Construction Drain Tile Program - Construction Carter Road Culvert- Engineering Carter Road Culvert - Construction Detention Basin Maintenance - Construction Gunite Rock Stormsewer - Construction General Detention Basin Silt Removal - Construction Bee Branch Alignment- State Revolving Loan Funds Bee Branch Alignment- Private Participant Bee Branch Alignment- Construction Bee Branch Alignment- Construction Bee Branch Alignment- Construction Bee Branch Alignment- Construction Bee Branch Alignment- Construction Bee Branch Alignment- Flood Mitigation Storm Sewer Cleaning - Construction Amy Ct Storm Sewer Impry - Eng. Division Services Amy Ct Storm Sewer Improv - Construction 32nd & Grandview Storm Improvements - Eng Division Service<. Villa St Storm Sewer Proj - Eng Division Services Villa St Storm Sewer Proj - Construction Stormwater System Assessment Hillcrest/Keyway Storm Sewer - Construction Hillcrest/Keyway Storm Sewer- Consulting Engineers Green Alley Pilot Project - Construction NPDES - Erosion Control NPDES - Post Construction - IEDA Grant Catfish Partnership FY 15 FY 15 Expense Revenue Amount Amount Fund ActivitylClP Account Explanation 12, 985, 754 13, 372, 916 79,597 6,130 10,000 7,552 17,500 128,220 6,635 142,305 5,000 12,400 26,909 (1,677) 6,483 37,999 3,000 5,051 62,909 8,702 31,570 8,997 58,000 (3,846) 15,981 57,021 7,065,590 259 153,576 267,330 (19, 946,128) 44,902 1,710 10,097 38,378 11,551 95,000 322,985 30,000 4,300 18,033 12,095 Page 27 720 7202301 73211 720 7202337 73311 720 7201935 73410 720 7202225 73410 720 7202319 62712 720 7202319 73211 720 7202404 73211 720 7202478 62712 720 7202480 62712 720 7202480 73211 720 7201008 73211 720 7201081 73211 720 7201085 62811 720 7201085 73211 720 7201085 73110 720 7201208 62811 720 7201208 73211 720 7201352 73211 720 7201354 73211 720 7201356 62811 720 7201356 73211 720 7201359 73211 720 7201363 73211 720 7201375 73211 9,842,474 720 7201654 54230 14,385 720 7201654 53102 720 7201654 73211 720 7201654 73211 720 7201654 73211 720 7201654 73211 720 7201654 73211 (19,946,128) 720 7201654 45795 720 7201659 73211 720 7201666 62811 720 7201666 73211 720 7201808 62811 720 7201809 62811 720 7201809 73211 720 7202015 62712 720 7202016 73211 720 7202016 62712 720 7202044 73211 720 7202062 62811 187,330 720 7202065 45771 26 -Aug -14 CIO C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O - Prespend FY 15 C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O - Prespend FY 15 C/O C/O C/O C/O C/O CIO - Reimbursements C/O - Sale of Assets C/O - Shift from Lower Bridge CIO C/O C/O CIO C/O C/O CIO C/O C/O CIO C/O C/O CIO C/O FISCAL YEAR 2015 AMENDMENT #1 CITY COUNCIL Department Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Program Description 8C NPDES - Post Construction - Consultant Services 8C NPEDS - Public Education 8C NPEDS - Public Participation 8C Kane Kaufman Storm Sewer- Engineering 8C Kane Kaufman Storm Sewer - Construction 8C Peru Road Storm Sewer - Engineering 8C Peru Road Storm Sewer - Construction 8C Cedar Cross Rd Storm - Engineering 8C Cedar Cross Rd Storm - Construction 8C Floodwall Breach Analysis 8C Stormwater I & I 8C Stormwater I & I Prevention 8C Windsor Storm - Construction 8C 7th Street Storm - Construction 8C 14th St Reconstruction - Engineering 8C 14th St Reconstruction - Construction TOTAL STORM WATER CONST FUND PARKING CONSTRUCTION FUND 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C Parking Division Parking Division Parking Division Parking Division Parking Division Parking Division Parking Division Parking Division Parking Division Parking Division Parking Division Parking Division Parking Division Parking Division Parking Division Public Information Seal Coating Parking Lots - Consultant Services Seal Coating Parking Lots - Construction Contract Seal Coating Parking Lots - Bond Proceeds Major Maintenance on Ramps - Construction Locust Street Ramp Repairs - Construction Locust Street Ramp Repairs - Go Bonds Parking Meter Replacement - Equipment Acquisition Parking Meter Replacement - Bond Proceeds Parking Ramp OCC Certification Port of Dubuque Ramp Maint - Construction 7th Street Pedestrian Walkway Study - Consulting Locust & Iowa Bathroom Remodel - Construction Ramp Signage - Signage Smart Meters - Construction POD Lot Electrical Cab - Bond Proceeds GIS Enhancements - Peripherals, Computer TOTAL PARKING CONSTRUCTION FUND WATER CONSTRUCTION FUND 8C 8C 8C 8C 8C 8C 8C 8C 8C Water Department Water Department Water Department Water Department Water Department Water Department Water Department Water Department Water Department Water Extension - Airport - Construction Water Internal Lines/Loan - Construction Water Internal Lines/Loan - Consulting Engineers Water Internal Lines/Loan - Private Participant Water Main Replacement - Construction Main Extension - Construction Main Extension - GO Bond Proceeds Annual Tank Inspection Roosevelt Rd. Main Ext. - Consult Eng FY 15 Expense Am ount 54,081 2,548 5,204 22,957 149,384 3,128 10,567 5,000 10,000 54,199 27,546 17,595 39,278 22,529 15,491 108,355 FY 15 Revenue Amount (10,590,022) (9,901,939) Fund Activity/CIP Account Explanation 720 7202065 62716 CIO 720 7202066 62811 C/O 720 7202067 62811 C/O 720 7202133 62811 CIO 720 7202133 73211 C/O 720 7202134 62811 C/O 720 7202134 73211 CIO 720 7202238 62811 C/O 720 7202238 73211 C/O 720 7202239 62811 CIO 720 7202332 73211 C/O 720 7202333 73211 C/O 720 7202414 73211 CIO 720 7202417 73211 C/O 720 7202418 62811 C/O 720 7202418 73211 CIO 8,726 730 7301380 62716 C/O 130,414 730 7301380 73211 C/O 95,000 730 7301380 54210 CIO 62,081 730 7301385 73210 C/O 63,872 730 7301671 73211 C/O 75,457 730 7301671 54210 CIO 47,487 730 7301944 73410 C/O 50,000 730 7301944 54210 C/O 25,013 730 7302046 62712 CIO 307,854 730 7302162 73211 C/O 10,000 730 7302163 62712 C/O 90,000 730 7302227 73210 CIO 11,941 730 7302228 71227 C/O 59,000 730 7302259 73210 C/O 33,928 730 7302487 54210 CIO 5,291 730 7301946 71120 C/O Page 28 821,679 254,385 26 -Aug -14 361,464 740 7402395 73211 Shift from Sanitary TIF Borro' 185,000 740 7401398 73211 CIO 25,000 740 7401398 62712 C/O 210,000 740 7401398 53102 C/O (845,000) 740 7401405 73211 C/O - Prespend FY 15 516,925 740 7401411 73211 C/O 500,000 740 7401411 54210 C/O 28,000 740 7401412 62712 CIO 120,343 740 7401672 62712 C/O FISCAL YEAR 2015 AMENDMENT #1 CITY COUNCIL Department Water Department Water Department Water Department Water Department Water Department Water Department Water Department Water Department Water Department Water Department Water Department Water Department Water Department Water Department Water Department Water Department Water Department Water Department Water Department Water Department Water Department Water Department Water Department Water Department Water Department Water Department Water Department Water Department Water Department Water Department Water Department Water Department Water Department Public Works Public Works Public Information Program Description 8C Roosevelt Rd. Main Ext. - Construction 8C Roosevelt Rd. Main Ext. - Bond Proceeds 8C Green Alley Pilot Project - Construction 8C Water Service Repair Grant - Grants 8C Fire Hydrant Painting - Construction 8C Pump Replacement Vacuum Filter - Pumps 8C West 3rd Renovation 8C Ramp Utility Relocation - GO Bonds 8C Manson Road Water Main - FEMA 8C Manson Road Water Main - State Grant 8C Water Extension - GO Bonds 8C Water Extension - Airport - Construction 8C Water Extension - GO Bonds 8C Water Extension - Airport - Construction 8C Water Extension - Airport -Construction 8C Water Extension - Airport -GO Bond 8C North Softening Basin - Construction 8C Water Extension - Airport - Construction 8C Eagle Point Treatment - Construction 8C Water Usage Audit - Consulting 8C Brick Building - Repair- EPP PS - Consulting 8C Brick Building - Repair - EPP PS - Construction 8C Brick Building - Repair- EPP PS - Bond Proceeds 8C Offices/Control Room/Lab Remodel - Construction 8C Water ARC Flash Analysis 8C Paint Pump Room Pipes- Construction 8C North Cascade Road Main Extension - Engineering 8C North Cascade Road Main Extension - Construction 8C Water Extension - Airport - Construction 8C Water Extension - Airport - Construction 8C English Mill Water Main Extension - GO Bonds 8C English Mill Water Main Extension - Construction 8C English Mill Water Main Extension - Design 8C MSC Exhaust Fan - Consulting 8C MSC Exhaust Fan - Construction 8C GIS Enhancements - Peripherals, Computer TOTAL WATER CONSTRUCTION FUND ENGINEERING INTERNAL SERVICE FUND Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering 8 ISF Admin Engineering - Full -Time time employees 8 ISF Admin Engineering- IPERS 8 ISF Admin Engineering - Social Security 8 ISF Admin Engineering - Life Insurance 8 ISF Admin Engineering - Wage Adjustment 8 ISF Project Engineering - Full -Time time employees 8 ISF Project Engineering- (PERS 8 ISF Project Engineering - Social Security FY 15 Expense Amount 75,120 88,075 16,136 62,294 10,115 90,000 1,592,970 105,000 1,930,611 91,827 91,267 85,252 50,147 6,000 14,608 13,305 28,700 (30,000) (78,500) (799,250) 877,750 30,000 1,900,000 45,700 825 3,750 2,841 26 -Aug -14 FY 15 Revenue Amount Fund Activity/CIP Account Explanation 740 7401672 73211 CIO 200,000 740 7401672 54210 C/O 740 7402044 73211 C/O 740 7402200 62765 CIO 740 7402201 73211 C/O 740 7402205 71511 C/O 740 7402209 62712 CIO 107,741 740 7402261 54210 C/O 129,185 740 7402349 44405 C/O 17,225 740 7402349 45701 CIO 1,592,970 740 7402395 54210 Adjust to Actual 740 7402395 73211 Adjust to Actual 40,000 740 7402395 54210 CIO 740 7402395 73211 Shift from EPP Driveway/Par 740 7402395 62712 C/O 1,626,279 740 7402395 54210 CIO 740 7402396 73211 C/O 740 7402395 73211 Shift from McAleece Water Ir 740 7402398 73210 CIO 740 7402399 62712 C/O 740 7402400 62712 C/O 740 7402400 73211 CIO 36,000 740 7402400 54210 C/O 740 7402402 73210 C/O 740 7402473 62712 CIO 740 7401826 73210 Shift to Airport Utilities 740 7402525 62712 Shift to Airport Utilities 740 7402525 73211 Shift to Airport Utilities 740 7402395 73211 Shift from North Cascade 740 7402395 73211 Shift from Paint Pump Room 1,900,000 740 7402504 54210 New Appropriation 740 7402504 73211 New Appropriation 740 7402504 62712 New Appropriation 740 7402477 62712 CIO 740 7402477 73210 C/O 740 7401946 71120 C/O Page 29 6,696,275 6,359,400 3,836 342 293 (14) (5,193) 9,110 817 695 800 80055100 800 80055100 800 80055100 800 80055100 800 80055100 800 80055400 800 80055400 800 80055400 61010 Adjust to Actual 61310 Adjust to Actual 61320 Adjust to Actual 61416 Adjust to Actual 61099 Adjust to Actual 61010 Adjust to Actual 61310 Adjust to Actual 61320 Adjust to Actual FISCAL YEAR 2015 AMENDMENT #1 CITY COUNCIL Department Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Program Description 8 ISF Project Engineering - Life Insurance 8 ISF Project Engineering - Wage Adjustment 8 ISF Traffic Engineering - Full -Time time employees 8 ISF Traffic Engineering- IPERS 8 ISF Traffic Engineering - Social Security 8 ISF Traffic Engineering - Wage Adjustment 8 ISF Sanitary Engineering - Full -Time time employees 8 ISF Sanitary Engineering- IPERS 8 ISF Sanitary Engineering - Social Security 8 ISF Sanitary Engineering - Life Insurance 8 ISF Sanitary Engineering - Wage Adjustment 8 ISF Storm Engineering - Full -Time time employees 8 ISF Storm Engineering- IPERS 8 ISF Storm Engineering - Social Security 8 ISF Storm Engineering - Life Insurance 8 ISF Storm Engineering - Wage Adjustment TOTAL ENGINEERING INTERNAL SERVICE FUND GARAGE INTERNAL SERVICE FUND Public Works Public Works Public Works Public Works Public Works 8 Garage - Full -Time time employees 8 Garage-IPERS 8 Garage - Social Security 8 Garage - Life Insurance 8 Garage - Wage Adjustment TOTAL GARAGE INTERNAL SERVICE FUND STREET INTERNAL SERVICE FUND Public Works 8 Public Works 8 Public Works 8 Public Works 8 LANDFILL FUND Public Works 8 Public Works 8 Public Works 8 Public Works 8 Public Works 8 Public Works 8 Public Works 8 Public Works 8 Public Works 8 Public Works 8 Public Works 8 Public Works 8 Public Works 8 ISF Street - Full -Time time employees ISF Street- IPERS ISF Street - Social Security ISF Street- Wage Adjustment TOTAL STREET INTERNAL SERVICE FUND Landfill - Full -Time time employees Landfill- IPERS Landfill - Social Security Landfill - Life Insurance Landfill - Wage Adjustment Composting - Full -Time time employees Composting- IPERS Composting - Social Security Composting - Life Insurance Composting - Wage Adjustment Hazard - Full -Time time employees Hazard- IPERS Hazard - Social Security FY 15 Expense Amount 19 (12,360) 139 12 11 (190) 2,815 250 213 6 (3,809) 5,934 532 452 9 (8,043) FY 15 Revenue Amount (4,124) 9,739 871 745 18 (13,262) (1,889) Page 30 16 1 1 (22) (4) 7,712 690 592 16 (10,481) 264 42 35 1 (363) 532 49 41 Fund ActivityICIP Account Explanation 800 80055400 61416 Adjust to Actual 800 80055400 61099 Adjust to Actual 800 80055700 61010 Adjust to Actual 800 80055700 61310 Adjust to Actual 800 80055700 61320 Adjust to Actual 800 80055700 61099 Adjust to Actual 800 80055610 61010 Adjust to Actual 800 80055610 61310 Adjust to Actual 800 80055610 61320 Adjust to Actual 800 80055610 61416 Adjust to Actual 800 80055610 61099 Adjust to Actual 800 80055620 61010 Adjust to Actual 800 80055620 61310 Adjust to Actual 800 80055620 61320 Adjust to Actual 800 80055620 61416 Adjust to Actual 800 80055620 61099 Adjust to Actual 810 810 810 810 810 81054600 81054600 81054600 81054600 81054600 61010 Adjust to Actual 61310 Adjust to Actual 61320 Adjust to Actual 61416 Adjust to Actual 61099 Adjust to Actual 820 82054400 61010 Adjust to Actual 820 82054400 61310 Adjust to Actual 820 82054400 61320 Adjust to Actual 820 82054400 61099 Adjust to Actual 940 940 940 940 940 940 940 940 940 940 940 940 940 94054200 94054200 94054200 94054200 94054200 94054210 94054210 94054210 94054210 94054210 94054220 94054220 94054220 61010 61310 61320 61416 61099 61010 61310 61320 61416 61099 61010 61310 61320 Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual 26 -Aug -14 FISCAL YEAR 2015 AMENDMENT #1 CITY COUNCIL Department Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works TRANSFERS Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Recreation Recreation Water Department Water Department Parking Division Parking Division Airport Department Airport Department Airport Department Airport Department Airport Department Airport Department Airport Department Airport Department Airport Department Airport Department Program Description 8 Hazard - Life Insurance 8 Hazard - Wage Adjustment 8 E -Waste - Full -Time time employees 8 E -Waste- IPERS 8 E -Waste - Social Security 8 E -Waste - Wage Adjustment 8 Rural Recyc - Full -Time time employees 8 Rural Recyc - Overtime 8 Rural Recyc- IPERS 8 Rural Recyc - Social Security 8 Rural Recyc - Wage Adjustment 8 Methane - Full -Time time employees 8 Methane- IPERS 8 Methane - Social Security 8 Methane - Wage Adjustment 8C DMASWA Education & Communication TOTAL LANDFILL FUND Trans0l Transfer from GDTIF to General Fund Trans0l Transfer from GDTIF to General Fund Trans02 Transfer from Greater Downtown TIF to General Construction Trans02 Transfer from Greater Downtown TIF to General Construction Trans03 Transfer from General Const to DRA Distribution Trans03 Transfer from General Const to DRA Distribution Trans04 Transfer from Dubuque Indust Ctr to General Const Trans04 Transfer from Dubuque Indust Ctr to General Const Trans05 Transfer from DICW Fund to General Const Fund Trans05 Transfer from DICW Fund to General Const Fund Trans06 Transfer from General Const to DRA Distribution Trans06 Transfer from General Const to DRA Distribution Trans07 Transfer from GO Bonds to Golf Construction Fund Trans07 Transfer from GO Bonds to Golf Construction Fund Trans08 Transfer from Sanitary Sewer to Water Construction Trans08 Transfer from Sanitary Sewer to Water Construction Trans09 Transfer from General Const to Transit Fund Trans09 Transfer from General Const to Transit Fund Transl0 Transfer from DRA Distribution to Airport Construction Transl0 Transfer from DRA Distribution to Airport Construction Transl 1 Transfer from DRA Distribution to Airport Construction Transl 1 Transfer from DRA Distribution to Airport Construction Transl2 Transfer from PFC Fund to Airport Construction Fund Transl2 Transfer from PFC Fund to Airport Construction Fund Transl 3 Transfer from DRA Dist Fund to Airport Construction Fund Transl 3 Transfer from DRA Dist Fund to Airport Construction Fund Transl4 Transfer from PFC Fund to Airport Construction Fund Transl4 Transfer from PFC Fund to Airport Construction Fund FY 15 Expense Amount 1 (725) 431 38 32 (588) 129 500 57 10 (176) 267 33 20 (366) 3,426 FY 15 Revenue Amount 2,219 Transfer Out Transfer In Page 31 9,800 50,000 11,975 10,000 164,970 200,665 14,694 361,464 245,873 1,650 28,950 134,305 54,000 80,210 Fund ActivityICIP Account Explanation 940 94054220 61416 Adjust to Actual 940 94054220 61099 Adjust to Actual 940 94054240 61010 Adjust to Actual 940 94054240 61310 Adjust to Actual 940 94054240 61320 Adjust to Actual 940 94054240 61099 Adjust to Actual 940 94054250 61010 Adjust to Actual 940 94054250 61010 Adjust to Actual 940 94054250 61310 Adjust to Actual 940 94054250 61320 Adjust to Actual 940 94054250 61099 Adjust to Actual 940 94054260 61010 Adjust to Actual 940 94054260 61310 Adjust to Actual 940 94054260 61320 Adjust to Actual 940 94054260 61099 Adjust to Actual 940 94054230 62140 CIO 240 9,800 100 240 50,000 360 360 11,975 102 210 10,000 360 210 164,970 360 360 200,665 102 14,694 350 440 710 361,464 740 360 245,873 600 102 1,650 390 102 28,950 390 391 134,305 390 102 54,000 390 391 80,210 390 24060240 10030500 24060240 3601105 36010360 1021151 21060210 3601774 21060210 3602158 36010360 1022292 3501530 44010440 71010710 7402395 36010360 6001614 10210102 3901060 10210102 3901448 39110391 3901891 10210102 3901893 39110391 3902009 91100 59240 91360 59240 91102 59360 91360 59210 91360 59210 91102 59360 59440 91350 91740 59710 91600 59360 91390 59102 91390 59102 91390 59391 91390 59102 91390 59391 Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds 26 -Aug -14 FISCAL YEAR 2015 AMENDMENT #1 CITY COUNCIL Department Airport Department Airport Department Airport Department Airport Department Airport Department Airport Department Airport Department Airport Department Airport Department Airport Department Airport Department Airport Department Airport Department Airport Department Airport Department Airport Department Airport Department Airport Department Airport Department Airport Department Transit Division Transit Division Transit Division Transit Division Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Economic Devlopmt Economic Devlopmt Housing & Comm De\ Housing & Comm De\ Planning Services Planning Services Planning Services Planning Services Planning Services Planning Services Program Description Transl5 Transfer from GO Bonds to Airport Construction Fund Transl5 Transfer from GO Bonds to Airport Construction Fund Transl6 Transfer from DRA Distribution to Airport Construction Transl6 Transfer from DRA Distribution to Airport Construction Transl 7 Transfer from Sales Tax Const to Airport Construction Transl 7 Transfer from Sales Tax Const to Airport Construction Transl8 Transfer From CFC Fund to Airport Const. Fund Transl 8 Transfer From CFC Fund to Airport Const. Fund Transl9 Transfer From Passenger Facility to Airport Const. Fund Transl9 Transfer From Passenger Facility to Airport Const. Fund Trans20 Transfer from DRA Distrib to Airport Const. Fund Trans20 Transfer from DRA Distrib to Airport Const. Fund Trans2l Transfer from Customer Facility Charge to Airport Const. Fund Trans2l Transfer from Customer Facility Charge to Airport Const. Fund Trans22 Transfer from Sales Tax Const to Airport Const. Fund Trans22 Transfer from Sales Tax Const to Airport Const. Fund Trans23 Transfer from Customer Facility Charge to Airport Const. Fund Trans23 Transfer from Customer Facility Charge to Airport Const. Fund Trans24 Transfer from Sales Tax Const to Airport Construction Trans24 Transfer from Sales Tax Const to Airport Construction Trans25 Transfer from Greater Downtown TIF to Transit Trans25 Transfer from Greater Downtown TIF to Transit Trans26 Transfer from Sales Tax Const to Transit Fund Trans26 Transfer from Sales Tax Const to Transit Fund Trans27 Transfer from General Fund to Sanitary Sewer Fund Trans27 Transfer from General Fund to Sanitary Sewer Fund Trans28 Transfer from Spec. Assessment Fd to Sewer Const Fund Trans28 Transfer from Spec. Assessment Fd to Sewer Const Fund Trans29 Transfer From Sales Tax 20% Fd to Stormwater Const. Fund Trans29 Transfer From Sales Tax 20% Fd to Stormwater Const. Fund Trans30 Transfer from Spec. Assessment Fund to Street Const Trans30 Transfer from Spec. Assessment Fund to Street Const Trans3l Transfer from Spec. Assessment Fund to Street Const Trans3l Transfer from Spec. Assessment Fund to Street Const Trans32 Transfer from Spec. Assessment Fund to Street Const. Fund Trans32 Transfer from Spec. Assessment Fund to Street Const. Fund Trans33 Transfer from General Fund to America's River Fund Trans33 Transfer from General Fund to America's River Fund Trans34 Transfer from General Fund to DRA Gaming Fund Trans34 Transfer from General Fund to DRA Gaming Fund Trans35 Transfer from GDTIF to General Construction Trans35 Transfer from GDTIF to General Construction Trans36 Transfer from GDTIF to General Construction Trans36 Transfer from GDTIF to General Construction Trans37 Transfer from GDTIF to General Construction Trans37 Transfer from GDTIF to General Construction TOTAL TRANSFERS FY 15 Expense Amount 101,062 12,000 38,000 84,353 2,015,695 91,185 358,173 91,186 28,815 179,670 64,450 2,400 28,498 307,000 13,800 95,917 212,000 35,831 126,557 48,000 15,000 10,000 10,000 FY 15 Revenue Amount Fund ActivityICIP Acco unt Ex p lanatio n 440 44010440 91390 Trans Funds 101,062 390 3902010 59440 Trans Funds 102 10210102 91390 Trans Funds 12,000 390 3902125 59102 Trans Funds 350 35010350 91390 Trans Funds 38,000 390 3902126 59350 Trans Funds 350 35010350 91390 Trans Funds 84,353 390 3902213 59252 Trans Funds 391 39110391 91390 Trans Funds 2,015,695 390 3902213 59391 Trans Funds 102 10210102 91390 Trans Funds 91,185 390 3902316 5912 Trans Funds 252 25210252 91390 Trans Funds 358,173 390 3902316 59252 Trans Funds 350 35010350 91390 Trans Funds 91,186 390 3902316 59350 Trans Funds 252 25210252 91390 Trans Funds 28,815 390 3902475 59252 Trans Funds 350 35010350 91390 Trans Funds 179,670 390 3902475 59350 Trans Funds 360 36010360 91600 Trans Funds 64,450 600 6001613 59360 Trans Funds 350 35010350 91600 Trans Funds 2,400 600 6002235 59350 Trans Funds 28,498 710 7101067 59101 Trans Funds 101 10110101 91710 Trans Funds 255 25510255 91710 Trans Funds 307,000 710 7102130 59255 Trans Funds 350 35010350 91720 Trans Funds 13,800 720 7201666 59350 Trans Funds 255 25510255 91300 Trans Funds 95,917 300 3001972 59255 Trans Funds 255 25510255 91300 Trans Funds 212,000 300 3002139 59255 Trans Funds 255 25510255 91300 Trans Funds 35,831 300 3002141 59255 Trans Funds 100 10010100 91700 Trans Funds 126,557 700 7001853 59100 Trans Funds 100 10010100 91101 Trans Funds 48,000 101 1011595 59100 Trans Funds 240 24060240 91360 Trans Funds 15,000 360 3601015 59240 Trans Funds 240 24060240 91360 Trans Funds 10,000 360 3602431 59240 Trans Funds 240 24060240 91360 Trans Funds 10,000 360 3602432 59240 Trans Funds Page 32 5,338,148 5,338,148 26 -Aug -14 FISCAL YEAR 2015 AMENDMENT #1 CITY COUNCIL 26 -Aug -14 FY 15 FY 15 Expense Revenue Department Program Description Amount Amount Fund ActivitylClP Account Explanation 82,272,117.23 69,658,426.00 ENCUMBRANCE C/O's 27,595,394 Back out Non Budgeted Encumb Rollovers - Total Amend #1 with Enc, C/O's, and New 109,867,511 69,658,426 Page 33 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 05, 2014, and for which the charge is $142.54. Subscribed to before me, a ► .tar Public i .nd for Dubuque County, Iowa, this "a day o// - , 20 / otary Public in and for Dubuque County; Iowa. MARY K. WESTER 4EYEF1 Commission Number 154385 My Comm, Er?, FEB, 1, 2017 NOTICE OF PUBLIC HEARING. , AMENDMENT,OF CURRENT CITY BUDGET. ,Form 653.01 The City Council of Dubuque in DUBUQUE " will meet at.,.,. City Council Ghambers,at the Historic Federal Building " at . (,hour) (Date) the purpose of amending the current budget of the city.for the fiscal yer.ending June 30, by changing estimatesfof revenue and expenditure appropriations in the following programs 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 TotalkBudget after Current Amendment Revenues & Other Financing Sources Taxes Levied, on Property, 24,011,071, 0 24,011,071 Less: Uncollected Property Taxes -Levy Year 'Net Current Property Taxes "", Delinquent P"roperty,Taxes,, ,.; TIFRevenue§• Other City"Taxes. 2 0 0 0, 24,011,071' + u 24,011,071 0 10,622,261' 14,959,338 0 0 10,622261 1'4,959,338! Licenses & Permits Use of Money and Property Intergovernmental ` 0 35,000 54,838,264' Charges for Services 10 \ 37,704,466'. 12,50[1;032 1,000 1,344,102 13,038,511 67,339,296 7;705,466; S.ecial Assessments Miscellaneous Other Financing. Sources Total Revenues and,`Other Sources" Expenditures Public Safety, Public Works Health and Social Services 11 '1f 32,000 8,512,439 68,220,993 233,148,445 ..,54;005,995 69;658:,426. 806,748, 10,153;090; 122,826,988 302,Q06,871 Financing Uses ' 15 28;145,634' 28;414,303 16 12,382,658 263,595 17 1;1.25, 838 Culture and Recreation Community. and Economic Development General Government 1;730,605 19 13,443,888 27,855 832,880 Debt Service' '21 ,982,241' 125,847 12,646,253 1,153,693 11,883,539 13,605,928' 135,000 7,958,727 9,117,241 36,838,327 Capital Projects Total Government Activities Expenditures 23 , , „120,482,071 80,456,566 200,938,637 38,334,309 Business Type / Enterprises Total Gov Activities 8, Business Expenditures Transfers Out '24 25 26 44;720;,411 '81'558°738' 45,856,351 166,338,422 58,673,012 104,529,363 5,338,148 Total Expenditures/Transfers; Out Excess Revenues 8, Other Sources Over 27 239, 272,946: 109,867,511 139,129,578 305,468,000 43,672,457 349,140,457 (Under) Expenditures/Transfers Out for Fiscal 28 6,124,501 -40 209085 46,333,586 Begimmng,Fund Balance July,1.'.- Ending 'Fund Balance June.30' Explanation of,increases or decreases in revenue estimates„appropriations, or available cash:. 67,083,198 60,958,697 107,202,283 60,958,697 This amendment adds the capital budget carryovers of $68,366,145 & associated revenue of $55,439,820, & encumbrance carryovers of $27,595,394 (continuing appropriation authority,not requiring formal amendment/>for reporting purposes only). Adds operating budget carryovers-of$575,567 & associated revenue of $1,239,834, requiring a formal amendment. Also included in this amendment is $7,992,257 in new expense & associated revenue of $7;640,624 due to new funding: sources. Interfund tran5fers;"of $5,338„148 are included. There will be, no increase in tax levies to be paid in -the current fiscal year narnetl above. Any increase in expenditures 'set out above °will be met from the "increased non -property tax revenues'and cash'balances not budgeted or consicjered in,this current budget.This will provide fora balanced budget„ City Clerk/Finance Officer '9/5 adno=589941-0':'