The URL can be used to link to this page

Fiscal Year 2014 Budget Amendment No. 1_Public HearingMasterpiece on the Mississippi TO: The Honorable Mayor and City Council Members FROM: Michael C. Van Milligen, City Manager SUBJECT: Fiscal Year 2014 First Budget Amendment DATE: August 26, 2013 Dubuque band AI- America City 1 2007 • 2012 • 2013 Budget Director Jennifer Larson is recommending approval of the first Fiscal Year 2014 Budget Amendment, which amends the Fiscal Year 2014 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 2013 budget carryovers to Fiscal Year 2014 of encumbrances totaling $26,819,835, capital projects totaling $108,808,494 that were not completed during the prior Fiscal Year, and associated revenues totaling $88,166,804. There are operating budget appropriation carryovers of $1,232,984 and operating receivables of $1,688,429. Also, total transfers between funds of $4,338,689 are reflected. I concur with the recommendation and respectfully request Mayor and City Council approval. bt/A44 V',,,,„t4ii„ Michael C. Van Milligen MCVM /jml Attachment cc: Barry Lindahl, City Attorney Cindy Steinhauser, Assistant City Manager Teri Goodmann, Assistant City Manager Jennifer Larson, Budget Director Masterpiece on the Mississippi TO: Michael C. Van Milligen, City Manager FROM: Jennifer Larson, Budget Director SUBJECT: Fiscal Year 2014 First Budget Amendment DATE: August 13, 2013 Dubuque band AI- America City 1111 ' 2007 • 2012 •2013 The purpose of this memorandum is to provide an explanation regarding the first amendment for Fiscal Year 2014. This amendment is two fold. First, it amends the Fiscal Year 2014 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 2013 budget carryovers to Fiscal Year 2014 of encumbrances totaling $26,819,835, capital projects totaling $108,808,494 that were not completed during the prior Fiscal Year, and associated revenues totaling $88,166,804. There are operating budget appropriation carryovers of $1,232,984 and operating receivables of $1,688,429. Also, total transfers between funds of $4,338,689 are reflected. CARRYOVER AMENDMENT TO FISCAL YEAR 2014 During Fiscal Year 2013, a large number of projects were completed, which include Police Restore Historic Police Car, Police Radio Accessories Replacement, Fire Ambulance Replacement, Improvements to Fire Headquarters, Fire Wireless Smoke Detectors Grant, Northend Trail Lighting, Northwest Arterial Hike /Bike Trail Phase III, Ham House Repairs, Allison- Henderson Remodel, McAleece Replace Fence Fabric, Murphy Park Fence on Bluff, Greenhouse Vent System, Marshall School Play Unit, Main Street Table and Chairs, Roof Replacements Park Buildings, Flexsteel Landscaping, Five Flags Ice Machine Replacement, Five Flags Main Doors Crash Bars, Five Flags Theatre Exterior Lights, Five Flags Lockers, Grand River Center Floor Leveling, Grand River Center Replace Clouds, Grand River Center Security Cameras, Grand River Center Wireless Network, Flora and Sutton Pools Refinish Slides, Flora and Sutton Pools Replace Pool Heaters, Flora and Sutton Pools Flow Meters, Bunker Hill Golf Tee Signs, Bunker Hill Window Replacements, Bunker Cart Paths, Flora and Sutton Bath House Improvements, Bunker Detention Basin #17 Improvements, Library Replace Windows, Library Exterior Improvements, Water Meter Exchange, Water Main Replacements, Fire Hydrant Replacements, Shallow Well Rehab, Bunker Hill Pump Station, Green Alley Projects, Water Valve Box Maintenance, Asbury Tank Painting, Water Pump Replace Vacuum Filter, Park Hill Pumping Roof, Water Mobile GIS System, Well Field Electrical Upgrades, Generator Maintenance Program, North Plant Motor Control Upgrade, Terminal Street Motor Repair, Bradley Street Pump Station Upgrade, Parking Ramp OCC Certification, Locust Ramp Video Cameras, Iowa Street Ramp Video Cameras, Port of Dubuque Lot Electrical Cabinet, Airport Runway Safety Area, Airport Field Drain Replacements, Airport Hangar Repair, Airport Paint Hangar Exteriors, Airport Runway Painting, Old Airline Terminal Assessment, Airport Replace Runway Regulators, Airport GIS, Airport Hangar Paving, Transit ARC Bus Transfer Station, Public Works Asphalt Milling Program, Public Works Street Sweeper Replacement, Refuse Dual Packer Recycle Vehicles, Sanitary Sewer Pipeline Inspection Equipment, Public Works Enloader Purchase, Downtown Sign Replacement, Port Amenities Maintenance, Truck Mounted New Concept Snow Plows, Downtown Litter and Recycling Receptacles, Salt Operations Scale, Hesco Flood Control Units, SEP Green Alley, Detention Basin Maintenance, Iowa Street Storm, Stormwater Infiltration & Inflow Prevention, West 32nd Detention Basin Improvement, White Water Creek Bridge, Safe Routes to School, US 61/151 Corridor, Millwork District Complete Streets, Kaufmann Avenue Resurfacing, Pavement Marking, Flood Plain Buyout, Fiber Optic Conduit, NW Arterial Capacity Improvements, Traffic Signal Video Detection, Five Points Intersection Signal, School Zone Countdown Pedestrian Signal, Traffic Operations Center Video Software, Purchase /Rehab /Resale, Homeless Prevention Grant, Neighborhood Stabilization grant, All America City Award, Community Plus Upgrade, Certified Annual Financial Reporting Software, 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 2014. The most significant of the capital project expenditure carryovers, including associated revenue, are: Bee Branch Reconstruction ($27,819,181); Intermodal Facility ($12,578,257); $9.4 million Green Alleys ($9,291,351); South Siegert Farm ($3,820,092); W &RRC Plant Upgrade ($3,674,723); Airport Terminal ($8,042,825); Millwork District Parking Improvements ($3,919,514); EB Lyons Expansion ($1,945,025);Water Extension to Airport ($2,162,130); Cedar Cross Construction ($1,844,507); Washington Neighborhood Downtown Incentives ($1,499,576); Multicultural Family Center Second Floor ($1,478,153); One -Way to Two -Way Conversion ($1,398,427); Downtown Housing Incentives ($1,074,990); Southwest Arterial ($927,923); N Cascade Reconstruction ($863,500); Downtown TIF Loan Pool ($765,521); Brunskill Road Bridge Replacement ($676,934); Millwork District Incentives ($670,000); Port of Dubuque Ramp Repairs ($620,736); Port of Dubuque Outdoor Plaza ($600,000); Relocation 30" Main Old Public Works ($550,778); University and Asbury Intersection ($463,539); Homeownership Rehab Program ($453,869); Annexation Study /Implementation ($447,860); Five Flags Arena Roof ($385,341); Southfork Interceptor ($372,379); Replace Fixed Route Buses ($338,637); Sanitary Sewer Improvements ($4,174,062); Water Improvements ($1,376,325); Stormwater Improvements ($1,535,923); and Community Development Block Grant funded projects ($573,873). OPERATING BUDGET CARRYOVER AMENDMENT The most significant operating budget carryovers into Fiscal Year 2013 include such items as Police Officer Training ($135,509); Police Department Grants ($103,580); Police Training ($108,984); Parks Area & Maintenance Mowing Equipment ($70,500); Airport Operations Radar Contract ($50,000); Human Rights Fair Housing Grant Appropriation ($83,456); Housing Every Child 1 Every Promise Grant Program ($117,500); Federal Building Maintenance ($104,180); and Community Development Block Grant ($4,315). -2- FIRST AMENDMENT TO THE FISCAL YEAR 2013 CERTIFIED BUDGET There have been numerous actions by City Council and changes requiring amendments for the Fiscal Year 2014 budget. The capital budget amendments total an increase of $1,572,499, with an increase in associated revenue of $1,745,025. The amendment items include: Police Mobile Data Computers ($258,183); 5th and Bluff Public Restroom ($142,000) funded by bond reallocation from 7th Street Improvements; and Millwork District Parking Improvements ($1,248,827) funded by bond reallocation from 7th Street Improvements. OPERATING BUDGET AMENDMENT The operating budget amendments total $270,964, with associated increase in revenue of $108,420. The amendment items include the replacement of Lost Books from Library Fees ($5,984); Port of Dubuque Marina Budget ($256,780) and Human Rights attendance of National Coalition for Dialogue & Deliberation Conference ($8,200). The action step is for City Council to adopt the attached resolution approving the FY 2014 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/03/2013 ,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. 282 -13 A RESOLUTION AMENDING THE CURRENT BUDGET FOR THE FISCAL YEAR ENDING JUNE: 2014 (AS AMENDED LAST ON .) Be it Resolved by the Council of the City of Dubuque Section 1. Following notice published and the public hearing held, 09/03/2013 the current budget (as previously amended) is amended as set out herein and in the detail by fund type and activity that supports this resolution which was considered at that hearing: Passed this AIW / r /Signature City Clerk/Finance Officer 3rd (Day) day of September 2 Signature Mayor Total Budget as certified or last amended Current Amendment Total Budget after Current Amendment n Sources Revenues & Other Financing ina 23,197,623 0 .23,197,623 Taxes Levied on Property 1 Less: Uncollected Property Taxes -Levy Year 2 0 0 0 Net Current Property Taxes 3 23,197,623 0 23,197,623 Delinquent Property Taxes 4 0 0 0 TIF Revenues 5 9,752,170 0 9,752,170 Other City Taxes 6 15,560,397 0 15,560,397 Licenses & Permits 7 1,368,930 0 1,368,930 Use of Money and Property 8 14,021,131 143,000 14,164,131 Intergovernmental 9 32,651,928 38,271,207 70,923,135 Charges for Services 10 35,954,213 102,615 36,056,828 Special Assessments 11 55,038 904,970 960,008 Miscellaneous 12 7,874,906 2,961,746 10,836,652 Other Financing Sources 13 26,950,892 49,325,140 • 76,276,032 Total Revenues and Other Sources 14 167,387,228 91,708,678 259,095,906 Financing Uses a Expenditures & Fr 'n 27,115,833 624,393 27,740,226 Public Safety 15 Public Works 16 12,223,715 548,316 12,772,031 Health and Social Services 17 998,450 202,364 1,200,814 Culture and Recreation 18 10,916,031 547,564 11,463,595 Community and Economic Development 19 13,343,613 423,201 13,766,814 General Government 20 7,472,570 303,787 7,776,357 Debt Service 21 7,613,632 0 7,613,632 Capital. Projects 22 25,588,595 58,864,545 84,453,140 Total Government Activities Expenditures 23 105,272,439 61,514,170 166,786,609 Business Type / Enterprises 24 43,723,844 77,190,606 120,914,450 Total Gov Activities & Business Expenditures 25 148,996,283 138,704,776 287,701,059 Transfers Out 26 20,747,941 4,338,689 25,086,630 Total Expenditures /Transfers Out 27 169,744,224 143,043,465 312,787,689 Excess Revenues & Other Sources Over (Under) Expenditures/Transfers Out Fiscal Year 28 - 2,356,996 - 51,334,787 - 53,691,783 29 ' .... ............ Beginning Fund Balance July 1 30 25,076,317 51,334,787 76,411,104 Ending Fund Balance June 30 31 22,719,321 0 22,719,321 Passed this AIW / r /Signature City Clerk/Finance Officer 3rd (Day) day of September 2 Signature Mayor t FISCAL YEAR 2014 AMENDMENT #1 CITY COUNCIL Department Program Description FY 14 Expense Amount FY 14 Revenue Amount Fund Activity /CIP Account Explanation 14- Aug -13 GENERAL FUND, Police Departmen 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 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 Fire Department Fire Department Pay to Other Agency Patrol - Visibar Lights Patrol - Vehicle Accessories Narcotics Grant Investigation - Byrne /Jag Grant ICE Enforcement - Reimbursable Overtime ICE Enforcement - Reimbursable Overtime Records - Software Maintenance Administration - Accreditation Criminal Investigation - Forensic Computer Patrol - False Alarm Billings Patrol - Vehicle Accessories FY10 JAG Grant FY 11 JAG Grant FY 12 JAG Grant Police Training - Officer Training Police COP - Officer Training Police Patrol - Officer Training Helping Services Grant Governor's Traffic Safety Bureau - Grant Governor's Traffic Safety Bureau - Overtime Governor's Traffic Safety Bureau - Overtime Governor's Traffic Safety Bureau - Education & Training Governor's Traffic Safety Bureau - Educational Material Domestic Abuse Grant Domestic Abuse Grant - Equipment 2011 Bulletproof Vest Grant 2011 Bulletproof Vest Grant - Equipment Target Crime Prevention Grant - Police Equipment Target Crime Prevention Grant - Private Participant Mobile Data Terminals - Computer Mobile Data Terminals - Computer Replace Police /CAD Software Replace Police /CAD Software - County Reimbursement Computer Storage - Server Restore Police Car - Private Contributions Restore Police Car - Motor Vehicle Maintenance Dictaphone System Upgrade Dictaphone System Upgrade - County Reimbursement E911 Center Needs Analysis Study Television Entry Level Testing Software Pumper Replacement Pumper Replacement Page 1 (890) 100 10011100 62761 (1,845) 100 10011700 72210 (4,101) 100 10011700 71329 3,162 100 10011320 45771 11,322 100 10011600 62672 6,137 100 10011600 72218 20,606 100 10011220 62663 3,550 100 10011100 62761 9,011 100 10011300 71120 1,445 100 10011700 51215 7,074 100 10011700 71329 20,655 100 10011776 72218 23,831 100 10011752 72218 21,531 100 10011753 72218 95,108 100 10011250 62360 5,625 100 10011500 62360 34,776 100 10011700 62360 2,560 100 10011326 45771 14,031 100 10011772 45771 3,565 100 10011772 61050 10,709 100 10011772 61051 1,000 100 10011772 62360 700 100 10011772 72218 1,154 100 10011754 44135 1,539 100 10011754 72218 2,291 100 10011702 44120 2,291 100 10011702 72218 1,000 100 10011760 72218 1,000 100 10011760 53102 116,183 100 1001120 71124 65,989 100 1001120 71124 693 101 1011167 71123 100,000 101 1011167 46205 7,785 101 1011752 71125 180 100 1002280 62528 3,506 100 1002280 62528 19,582 101 1012352 71111 9,008 101 1012352 46205 15,155 102 1022354 62716 1,000 100 10012100 72412 5,715 100 10012100 71123 13,051 102 1021016 71318 15,132 101 1011016 71318 C/O - Prespend FY14 C/O - Encumbrance Canceled C/O - Encumbrance Canceled 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 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 Shift from Radio Tower Shift from Flood Buyout C/O C/O C/O C/O Additional Contributions C/O C/O C/O C/O C/O C/O C/O C/O FISCAL YEAR 2014 AMENDMENT #1 CITY COUNCIL 14- Aug -13 FY 14 FY 14 Expense Revenue Department Program Description Amount Amount Fund Activity /CIP Account Explanation GENERAL FUND, Police Departmen t 1 Pay to Other Agency (890) 100 10011100 62761 C/O Prespend FY14 Fire Department 1C Improvements to Station 4 68,401 101 1011444 73210 C/O Fire Department 1C 900 MHZ Safety Data Radio - Radio Equipment 19,000 101 1012355 72410 C/O Fire Department 1C Assist Fire Fighter Grant - Video Conferencing 204,000 100 1002356 72416 C/O Fire Department 1C Assist Fire Fighter Grant - Video Conferencing 163,200 100 1002356 44170 C/O Fire Department 1C Portable Radio Accessories - Radio Equipment 16,900 101 1012357 72410 C/O Fire Department 1 Ambulance Revenue Receivable 217,096 101 10113300 53620 C/O Fire Department 1 Fire Suppression Off Road Vehicle 750 100 10013400 71310 C/O Human Relations 3 Education & Training (806) 100 10016100 62360 C/O - Prespend FY14 Human Relations 3 Travel - Conferences (680) 100 10016300 62310 C/O Prespend FY14 Human Relations 3 Travel - Conferences (680) 100 10016100 62310 C/O Prespend FY14 Human Relations 3 Education & Training (680) 100 10016100 62360 C/O Prespend FY14 Human Relations 3 Travel - Conferences (2,425) 100 10016300 62310 C/O Prespend FY14 Human Relations 3 Interpreter Certification 7,759 100 10016100 62360 C/O Human Relations 3 Interpreter Certification 954 100 10016100 62360 C/O Human Relations 3 Printing & Binding - Move to MFC 2,100 100 10016100 62090 C/O Human Relations 3 Dubuque Dispute Resolution Center Printing - Move to MFC 210 100 10016100 62734 C/O Human Relations 3 Multifunction Device for Move to MFC 11,600 100 10016100 71122 C/O Human Relations 3 Moving Expenses to MFC 700 100 10016100 62340 C/O Human Relations 3 (2) City Life Sessions 5,500 100 10016100 62734 C/O Human Relations 3 Mind Mixer Pilot - Software License 9,000 100 10016100 62663 C/O Human Relations 3 Volunteer Generation Grant - Federal Grant 42,694 100 10016500 45771 C/O Human Relations 3 Volunteer Generation Grant - Training & Education 42,652 100 10016500 62360 C/O Human Relations 3 HUD Fair Housing - Printing & Binding 32,275 100 10016200 62090 C/O Human Relations 3 HUD Fair Housing - Education & Training 9,994 100 10016200 62360 C/O Human Relations 3 HUD Fair Housing - Miscellaneous Services 15,570 100 10016200 62731 C/O Human Relations 3 HUD Fair Housing - Fair Housing Training 35,611 100 10016200 62753 C/O Human Relations 3 ICRC Case Processing 1,600 100 10016100 51918 C/O Human Relations 3 Computer - Peripherals 4,440 100 10016100 71120 C/O Human Relations 3 Travel - Conferences 5,000 100 10016100 62310 National Coalition Dialogue Human Relations 3 Travel - Conferences 3,200 100 10016300 62310 National Coalition Dialogue Health Services 3 Travel - Conferences 762 100 10017100 62310 C/O Health Services 3 Animal Control - Animal Traps 476 100 10017200 62067 C/O Health Services 3 Travel - Conferences 743 100 10017300 62310 C/O Health Services 3 Animal Control - Education & training 1,100 100 10017200 62360 C/O Health Services 3 Animal Control - Uniform Allowance 500 100 10017200 61620 C/O Health Services 3 Animal Control - Smartphones 798 100 10017200 72418 C/O Parks Division 4 Port of Dubuque Marina C -Store - ATM Fees 120 100 10030550 51955 FY14 Marina Budget Parks Division 4 Port of Dubuque Marina -C -Store - Beer 19,800 100 10030550 51959 FY14 Marina Budget Parks Division 4 Port of Dubuque Marina - C- Store- Food 15,500 100 10030550 51960 FY14 Marina Budget Parks Division 4 Port of Dubuque Marina - C -Store -Boat Supplies 3,500 100 10030550 51966 FY14 Marina Budget Parks Division 4 Port of Dubuque Marina - C- Store - Beverage /Ice 9,550 100 10030550 51967 FY14 Marina Budget Parks Division 4 Port of Dubuque Marina - C- Store- ShowerAaundry fees 600 100 10030550 53530 FY14 Marina Budget Page 2 FISCAL YEAR 2014 AMENDMENT #1 CITY COUNCIL 14- Aug -13 FY 14 FY 14 Expense Revenue Department Program Description Amount Amount Fund Activity /CIP Account Explanation GENERAL FUND, Police Departmen 1 Pay to Other Agency (890) 100 10011100 62761 C/O - Prespend FY14 Parks Division 4 Port of Dubuque Marina - C- Store - Cigarettes 4,500 100 10030550 51968 FY14 Marina Budget Parks Division 4 Port of Dubuque Marina - C- Store - Lottery Sales 2,200 100 10030550 51927 FY14 Marina Budget Parks Division 4 Port of Dubuque Marina - C- Store - Seasonal Employees 22,750 100 10030550 61030 FY14 Marina Budget Parks Division 4 Port of Dubuque Marina - C- Store -IPERS 1,972 100 10030550 61310 FY14 Marina Budget Parks Division 4 Port of Dubuque Marina - C- Store - Social Security 1,741 100 10030550 61320 FY14 Marina Budget Parks Division 4 Port of Dubuque Marina - C- Store - Worker's Comp 460 100 10030550 61415 FY14 Marina Budget Parks Division 4 Port of Dubuque Marina - C- Store - Unemployment 4,000 100 10030550 61417 FY14 Marina Budget Parks Division 4 Port of Dubuque Marina - C- Store - Office Supplies 100 100 10030550 62010 FY14 Marina Budget Parks Division 4 Port of Dubuque Marina - C- Store - Uniforms 200 100 10030550 62011 FY14 Marina Budget Parks Division 4 Port of Dubuque Marina - C- Store - Postage 200 100 10030550 62030 FY14 Marina Budget Parks Division 4 Port of Dubuque Marina - C- Store - Janitorial Supplies 600 100 10030550 62062 FY14 Marina Budget Parks Division 4 Port of Dubuque Marina - C- Store - Printing & Binding 200 100 10030550 62090 FY14 Marina Budget Parks Division 4 Port of Dubuque Marina - C- Store - Promotion 6,500 100 10030550 62140 FY14 Marina Budget Parks Division 4 Port of Dubuque Marina - C- Store -Dues & memberships 300 100 10030550 62190 FY14 Marina Budget Parks Division 4 Port of Dubuque Marina - C- Store -Dram Shop Insurance 1,000 100 10030550 62205 FY14 Marina Budget Parks Division 4 Port of Dubuque Marina - C- Store - Property Insurance 2,231 100 10030550 62206 FY14 Marina Budget Parks Division 4 Port of Dubuque Marina - C- Store - General Liability 7,900 100 10030550 62208 FY14 Marina Budget Parks Division 4 Port of Dubuque Marina - C- Store - Education & Training 100 100 10030550 62360 FY14 Marina Budget Parks Division 4 Port of Dubuque Marina - C- Store - Electricity 3,300 100 10030550 62411 FY14 Marina Budget Parks Division 4 Port of Dubuque Marina - C- Store -Gas 6,600 100 10030550 62412 FY14 Marina Budget Parks Division 4 Port of Dubuque Marina - C- Store - Refuse 975 100 10030550 62418 FY14 Marina Budget Parks Division 4 Port of Dubuque Marina - C- Store - Telephone 1,880 100 10030550 62421 FY14 Marina Budget Parks Division 4 Port of Dubuque Marina - C- Store - Property Maintenance 200 100 10030550 62431 FY14 Marina Budget Parks Division 4 Port of Dubuque Marina - C- Store - Diesel Fuel 22,330 100 10030550 62513 FY14 Marina Budget Parks Division 4 Port of Dubuque Marina - C- Store - Machinery Maintenance 100 100 10030550 62611 FY14 Marina Budget Parks Division 4 Port of Dubuque Marina - C- Store -Beer Products 15,150 100 10030550 62643 FY14 Marina Budget Parks Division 4 Port of Dubuque Marina - C- Store - Beverage /Ice 8,600 100 10030550 62643 FY14 Marina Budget Parks Division 4 Port of Dubuque Marina - C- Store -Food 9,000 100 10030550 62642 FY14 Marina Budget Parks Division 4 Port of Dubuque Marina - C- Store - Software License 200 100 10030550 62663 FY14 Marina Budget Parks Division 4 Port of Dubuque Marina - C- Store - License /Permit Fees 660 100 10030550 62664 FY14 Marina Budget Parks Division 4 Port of Dubuque Marina - C- Store - Credit Card Charge 1,650 100 10030550 62666 FY14 Marina Budget Parks Division 4 Port of Dubuque Marina - C- Store - Program Equip /Supplies 1,800 100 10030550 62668 FY14 Marina Budget Parks Division 4 Port of Dubuque Marina - C- Store -Pro Shop Merchandise 2,500 100 10030550 62670 FY14 Marina Budget Parks Division 4 Port of Dubuque Marina - C- Store - Consultant Services 11,750 100 10030550 62716 FY14 Marina Budget Parks Division 4 Port of Dubuque Marina - C- Store - Criminal Background Check 160 100 10030550 62717 FY14 Marina Budget Parks Division 4 Port of Dubuque Marina - C- Store - Catering Services 400 100 10030550 62736 FY14 Marina Budget Parks Division 4 Port of Dubuque Marina - C- Store - Machinery Rental 50 100 10030550 62747 FY14 Marina Budget Parks Division 4 Port of Dubuque Marina - C- Store - Lottery Tickets 12,090 100 10030550 62601 FY14 Marina Budget Parks Division 4 Port of Dubuque Marina - C- Store - Cigarettes 3,000 100 10030550 62602 FY14 Marina Budget Parks Division 4 Port of Dubuque Marina Maintenance - Catering 450 100 10030560 51963 FY14 Marina Budget Parks Division 4 Port of Dubuque Marina Maintenance - Events 200 100 10030560 51965 FY14 Marina Budget Parks Division 4 Port of Dubuque Marina Maintenance - Pump out Fees 250 100 10030560 53530 FY14 Marina Budget Page 3 FISCAL YEAR 2014 AMENDMENT #1 CITY COUNCIL Department Program Description FY 14 Expense Amount FY 14 Revenue Amount Fund Activity /CIP Account Explanation 14- Aug -13 GENERAL FUND, Police Departmen 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 Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division 1 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4C 4C 4C 4C 4C 4C 4C 4C Pay to Other Agency Port of Dubuque Marina Maintenance Port of Dubuque Marina Maintenance Port of Dubuque Marina Maintenance Port of Dubuque Marina Maintenance Port of Dubuque Marina Maintenance Port of Dubuque Marina Maintenance Port of Dubuque Marina Maintenance Port of Dubuque Marina Maintenance Port of Dubuque Marina Maintenance Port of Dubuque Marina Maintenance Port of Dubuque Marina Maintenance Port of Dubuque Marina Maintenance Port of Dubuque Marina Maintenance Port of Dubuque Marina Maintenance Port of Dubuque Marina Maintenance Port of Dubuque Marina Maintenance Port of Dubuque Marina Maintenance Port of Dubuque Marina Maintenance Port of Dubuque Marina Maintenance - Slip Rental - Fuel Sales - Seasonal Employee - IPERS - Social Security - Safety Equipment - Uniform Purchases - Education & Training - Electricity - Refuse - Telephone - Property Maintenance - Diesel Fuel - Mach /Equip Maint - Software License - Credit Card Charge - Consultant Services - Criminal Background - Mach /Equip Rental Park Areas & Maintenance - Mowing Equipment Park Areas & Maintenance - Pick -up Accessories MFC Planters Irrigation Veteran's Memorial Port of Dubuque Marina C -Store - Promotion Port of Dubuque Marina C -Store - Property Insurance Port of Dubuque Marina C -Store - General Liability Insurance Port of Dubuque Marina C -Store - Pro Shop Merchandise Port of Dubuque Marina C -Store - Consultant Services Port of Dubuque Marina C -Store - Criminal Background Check Port of Dubuque Marina Maintenance - Property Maintenance Port of Dubuque Marina Maintenance - Equipment Maint Port of Dubuque Marina Maintenance - Software License Port of Dubuque Marina Maintenance - Consultant Services Port of Dubuque Marina Maintenance - Criminal Background Cl- Comiskey Repair Siding - Construction Miller Riverview Rip Rap Vets Memorial Park Bal!field - Construction Comiskey Sidewalk Lights - Consulting Comiskey Sidewalk Lights - Construction Comiskey Sidewalk Lights - Construction Westbrook Park Development - Eng. Division Svcs Westbrook Park Development - Construction Page 4 (890) 100 10011100 62761 8,000 100 10030560 43327 43,750 100 10030560 51536 15,154 100 10030560 61030 1,313 100 10030560 61310 1,158 100 10030560 61320 200 100 10030560 61640 200 100 10030560 62011 200 100 10030560 62360 8,100 100 10030560 62411 975 100 10030560 62418 941 100 10030560 62421 430 100 10030560 62431 22,500 100 10030560 62513 600 100 10030560 62611 800 100 10030560 62663 1,300 100 10030560 62666 50,000 100 10030560 62716 160 100 10030560 62717 100 100 10030560 62747 70,500 100 10030400 71611 3,067 100 10030400 71312 9,800 100 10030500 73310 6,729 100 10030400 62761 700 100 10030550 62140 316 100 10030550 66205 6,500 100 10030550 66208 2,500 100 10030550 62670 12,500 100 10030550 62716 120 100 10030550 62717 500 100 10030560 62431 100 100 10030560 62611 300 100 10030560 62663 12,500 100 10030560 62716 120 100 10030560 62717 11,831 102 1021151 73210 18,591 100 1001170 73211 10,212 102 1021214 73211 10,000 102 1021544 62712 90,000 102 1021544 73211 30,131 102 1021544 73211 12,498 101 1011582 62712 83,680 101 1011582 73211 CIO - Prespend FY14 FY14 Marina Budget FY14 Marina Budget FY14 Marina Budget FY14 Marina Budget FY14 Marina Budget FY14 Marina Budget FY14 Marina Budget FY14 Marina Budget FY14 Marina Budget FY14 Marina Budget FY14 Marina Budget FY14 Marina Budget FY14 Marina Budget FY14 Marina Budget FY14 Marina Budget FY14 Marina Budget FY14 Marina Budget FY14 Marina Budget FY14 Marina Budget 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 C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O FISCAL YEAR 2014 AMENDMENT #1 CITY COUNCIL Department Program Description FY 14 Expense Amount FY 14 Revenue Amount Fund Activity /CIP Account Explanation 14- Aug -13 GENERAL FUND, Police Departmen 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 Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Civic Center Division Civic Center Division Conference Center Conference Center 1 Pay to Other Agency 4C Highway 20 Roses Plan - Consulting 4C Eagle Point Stone 4C BMX Bike Course 4C Schmitt Island Master Plan - Consulting 4C Dubuque History Trail - Equipment Acquisition 4C Marshall Park - Pool Repair 4C Erosion Control Study 4C Catfish Creek Hike -Bike Trail Study - Consultant Services 4C Park Drinking Fountains - Consultant Engineers 4C Greenhouse - Addition - Const Contr - Bldg 4C EB Lyons Expansion - Land Acquisition 4C EB Lyons Expansion - REAP Grant 4C EB Lyons Expansion - REAP Grant 4C EB Lyons Expansion - Land & Water Conservation Grant 4C EB Lyons Expansion - State Recreational Trails Grant 4C EB Lyons Expansion - EB Lyons Trust 4C EB Lyons Expansion - Private Participant 4C EB Lyons Expansion -IDNR Master Plan & Kiosks 4C EB Lyons Expansion -IDNR Park Maintenance Building 4C NW Hike /Bike Trail - REAP Grant 4C Dubuque Water Trail 4C EPP - Paint BridgeNeranda /Indian Room 4C EPP - Riverfront Pavilion - Construction 4C EPP - Riverfront Pavilion - Consulting Engineers 4C Eagle Valley Park Development - Consulting 4C Eagle Valley Park Development - Construction 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 Greenhouse Vent System - Construction 4C Lincoln Ave Spillway Replant - Construction 4C Urban Youth Corp Grant - Fed Grant 4C Urban Youth Corp Grant - Seasonal Employees 4C All Parks - Security Lights 4C Comiskey Park Building Alarm 4C Creekwood Park 4C Hilltop Park - 735 Calendonia Place Expansion 4C Paint Arena Ceiling - Construction 4C Five Flags Audio Equipment - PA System 6C GRC - Replace Outdoor Furniture 6C GRC - Cool Room Study Page 5 (890) 21,000 20,750 2,379 100,000 31,522 18,721 22,672 5,400 9,957 85,173 1,945,025 1,000 20,140 12,435 131,847 5,770 90,000 9,000 83,040 200,000 7,000 7,273 17,700 10,009 20,000 10,000 95,791 10,136 81,433 37,475 35,000 25,000 100 10011100 62761 102 1021588 62712 101 1011677 73211 102 1021871 73211 102 1021883 62712 100 1001956 73411 101 1011983 73211 100 1001987 62712 101 1012078 62716 100 1002101 62712 102 1022104 73210 100 1002171 73110 200,000 100 1002171 45707 200,000 100 1002171 45707 175,000 100 1002171 45771 170,500 100 1002171 45733 471,000 100 1002171 53102 159,525 100 1002171 53102 60,000 100 1002171 45701 509,000 100 1002171 45731 20,000 100 1002273 45707 100 1002277 73411 102 1022189 73210 102 1022190 62712 102 1022190 73210 102 1022288 62712 102 1022288 73211 102 1022289 62712 102 1022289 73211 102 1022292 72713 102 1022293 71227 101 1012297 73210 101 1012298 73211 8,460 100 1002343 45771 100 1002343 61030 102 1022368 73211 101 1012372 73210 101 1012375 73211 102 1022449 73211 101 1012117 73210 101 1012302 72419 102 1022306 71156 102 1022307 71156 C/O Prespend FY14 C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O New Grant New Grant New Grant Private Trust Private Participant New Grant New Grant 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 C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O FISCAL YEAR 2014 AMENDMENT #1 CITY COUNCIL 14- Aug -13 FY 14 FY 14 Expense Revenue Department Program Description Amount Amount Fund Activity /CIP Account Explanation GENERAL FUND, Police Departmen t 1 Pay to Other Agency (890) 100 10011100 62761 C/O Prespend FY14 Conference Center 6C GRC - Upgrade AV Equipment 50,000 102 1022389 72416 C/O Conference Center 6C GRC - Concrete 38,500 100 1002390 73211 C/O Conference Center 6C GRC - Security Cameras 9,359 101 1012392 72417 C/O Recreation 4 Mystique Community Ice Center- Ice Time 7,760 100 10034100 62761 C/O Recreation 4 St. Mark's Purchase of Service 15,000 100 10034100 62761 C/O Recreation 4 Computer Software - Team Scheduling 1,200 100 10034100 71123 C/O Recreation 4 Utility Tractor Replacement 23,638 100 10034250 71313 C/O Recreation 4 Deck Chairs - Lifeguard Stands 2,800 100 10034300 72712 C/O Recreation 4C Flora & Sutton Recaulk Pool Decks - Construction 10,000 102 1021098 73210 C/O Recreation 4C Bath House Improvements 1,780 101 1012172 73210 C/O Recreation 4C AmeriCorps - Federal Pass Thru Grant 58,990 100 10034912 45771 C/O Recreation 4C AmeriCorps - Private Participant 51,965 100 10034912 53102 C/O Library 4 Speakers /Programs (1,000) 100 10036210 62734 C/O - Prespend FY14 Library 4 Speakers /Programs (140) 100 10036210 62734 C/O - Prespend FY14 Library 4 Technical Assistance - Travel Conferences 967 100 10036500 62310 C/O Library 4 Circulation Services - Travel Conferences 74 100 10036220 62310 C/O Library 4 Adult Services - Travel Conferences 778 100 10036200 62310 C/O Library 4 Adult Services - AV Materials 3,947.00 100 10036200 62652 Lost Book Money Library 4 Youth Services - Video 2,037.00 100 10036400 62652 Lost Book Money Library 4 Information Technology - Travel Conferences 150 100 10036440 62310 C/O Library 4 Adult Services - Education & Training 670 100 10036200 62360 C/O Library 4 Children Services - Education & Training 700 100 10036210 62360 C/O Library 4 Children Services - Travel Conferences 534 100 10036210 62310 C/O Library 4 Technical Assistance - Education & Training 457 100 10036500 62360 C/O Library 4 Administration - Education & Training 1,184 100 10036100 62360 C/O Library 4 Administration - Travel Conferences 497 100 10036100 62310 C/O Airport Department 2C Airport GIS - Consulting 10,872 100 1002282 62712 CIO Airport Department 2C Airport GIS - Grant 10,872 100 1002282 44105 CIO Airport Department 2 Airport Administration - Promotion 9,548 100 10051100 62140 C/O Airport Department 2 Airport FBO - Promotion 6,308 100 10051200 62140 C/O Airport Department 2 Airport Operations - Radar Contract 50,000 100 10051400 62614 C/O Public Works 2 Travel - Conferences (204) 100 10054100 62310 C/O - Prespend FY14 Public Works 2C Bi- Lingual Trail Signage - Signage 14,595 100 1002169 71227 C/O Engineering 2 Travel - Conferences (725) 100 10055400 62310 C/O - Prespend FY14 Engineering 2 Subscriptions /Books /Maps (299) 100 10055100 62170 C/O - Prespend FY14 Engineering 2 Travel - Conferences (605) 100 10055400 62310 C/O - Prespend FY14 Engineering 2 Travel - Conferences (198) 100 10055100 62310 C/O - Prespend FY14 Engineering 2 Travel - Conferences (695) 100 10055100 62310 C/O - Prespend FY14 Engineering 2 Travel - Conferences (725) 100 10055100 62310 C/O - Prespend FY14 Engineering 2 Travel - Conferences (495) 100 10055100 62310 C/O - Prespend FY14 Engineering 2 Travel - Conferences (725) 100 10055400 62310 C/O - Prespend FY14 Engineering 2C Intersection Preemption - Equipment 4,650 101 1011023 73410 C/O Page 6 FISCAL YEAR 2014 AMENDMENT #1 CITY COUNCIL Department Program Description FY 14 Expense Amount FY 14 Revenue Amount Fund Activity /CIP Account Explanation 14- Aug -13 GENERAL FUND, Police Departmen Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering 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\ 1 Pay to Other Agency 4C Library Renovation - Construction 4C Library Renovation - Sale of Assets - Heade Painting 2C Federal Building Renovation - Construction 2C Port of Dubuque Outdoor Plaza - Eng Division Services 2C Port of Dubuque Outdoor Plaza - Construction 2C Port of Dubuque Outdoor Plaza - Private Participant 2C Riverwalk Security Camera - Camera Related Equipment 2C Ice Harbor Maintenance /Dredging 2C Ice Harbor Maintenance /Dredging 2C Decorative Concrete Maint - Construction 2C Safes Routes to School - Const Contract Not Building 2C Safes Routes to School - IDOT Grant 2C Flood Plain Buyout - FEMA 2C Flood Plain Buyout - Land Acquisition 2C Accessibility Barriers - Construction 2C Tourism Signage Program - Signage 2C Port of Dubuque - Leasehold Improvements 2C Port of Dubuque - Leasehold Improvements 2C Downtown Street Light Replacement 2C Fiber Optic Con - Priv & Misc - Eng Division Svc 2C Recon Signals/JFK-Wacker - Construction 2C Downtown Security Cameras 5C Port of DBQ- Develop.Standards (Int Write Down) 5C Port of DBQ- Develop.Standards (Int Write Down) 5C Warehouse Master Planning - Private Participant 5 Housing Administration - Pay to Other Agency 5 General Fund Section 8 Vouchers - Misc Office Equip 5 General Fund Section 8 Vouchers - Desk Chairs 6 Federal Building Maintenance - Property Maintenance 5 Circles Program - Pay to other Agency - Circles 5 445 Loras Property - Property Maintenance 5 Getting Ahead Program - Education & Training 5 Circles Program - Unspent Donations 5 Circles Program - Special Events 5 Home Workshops - Pay to Other Agency 5C Maint of Vacant /Abandoned - Property Maintenance 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 Homeownership Grants - Target Page 7 (890) 100 10011100 62761 22,506 100 1001141 73210 243,711 100 1001141 54104 49,652 102 1021841 62712 100,000 100 1001855 62811 600,000 100 1001855 73211 450,000 100 1001855 53102 20,111 100 1001963 72417 10,000 102 1021466 62811 141,500 102 1021466 73211 7,185 102 1021630 73211 35,607 101 1011922 73211 70,750 101 1011922 45701 43,285 101 1012419 44405 23,642 101 1012419 73111 19,537 101 1011034 73210 24,853 102 1021512 71227 11,187 102 1022330 73211 1,974 101 1012330 73211 51,925 102 1021608 73410 49,256 102 1021609 73211 141,937 101 1011919 73211 33,000 100 1002494 72417 35,353 100 1001207 62765 15,000 102 1021207 62765 11,000 100 1002081 53102 117,500 100 10061100 62761 250 100 10061600 71211 3,200 100 10061600 71211 104,180 100 10061150 62431 5,550 100 10061600 62761 15,994 100 10061710 62431 2,551 100 10061921 62360 19,305 100 10061922 62140 11,445 100 10061922 62645 1,180 100 10061100 62731 71,606 101 1011002 73210 50,000 102 1021002 73210 102,256 100 1001002 73210 29,625 100 1001021 73210 200,000 100 1001247 54210 200,000 100 1001247 62764 247,206 101 1011595 62765 C/O Prespend FY14 C/O C/O - Heade Painting 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 C/O C/O C/O C/O C/O C/O C/O C/O C/O CO - John Gronen 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 C/O C/O C/O C/O FISCAL YEAR 2014 AMENDMENT #1 CITY COUNCIL Department Program Description FY 14 Expense Amount FY 14 Revenue Amount Fund Activity /CIP Account Explanation 14- Aug -13 GENERAL FUND, Police Departmen 1 Pay to Other Agency Housing & Comm De\ 5C Homeownership Grants - Target Housing & Comm De\ 5C NBHD Stabilization Grant - Land Acquisition with Improv. Housing & Comm De\ 5C Healthy Homes Grant - HUD Payments Housing & Comm De\ 5C Healthy Homes Grant - Grants Housing & Comm De\ 5C IFA Our Home Grant - Grants Housing & Comm De\ 5C IFA Our Home Grant - Iowa Finance Authority Housing & Comm De\ 5C IFA Housing Grant 12 -14 Housing & Comm De\ 5C IFA Housing Grant 12 -14 Planning Services 5C Historic District Improvements - Construction Planning Services 5C Historic District Improvements - Construction Planning Services 5C Historic Preservation Technical Assistance - Construction Planning Services 5C Historic/Architectural & Evaluation - Consultant Planning Services 5C Historic/Architectural & Evaluation - State Grants City Council 6 Travel - Conferences Sustainability 6 Speakers /Programs Sustainability 6 Green Sustainability Conference Keynote Speaker Sustainability 6 Sustainability Community Grants Sustainability 6 Sustainability Software Sustainability 6 Sustainability Pay to Other Agency Climate Action Plan City Manager's Office 6 Travel - Conferences Personnel Office 6 Leadership Training Program City Manager 6C GIS Implementation - Consultant Services City Manager 6C GIS Enhancements- Peripherals, Computer City Manager 6C City of Dbq 175th Birthday City Manager 6C GIS Training City Manager 6C Americas River Fest Equip City Manager 6C Sustainability Initiative - Consultant Services City Manager 6C Climate Showcase Grant - Consultant Services City Manager 6C Climate Showcase Grant - Federal Grants City Manager 6C EECBG Grant - Grants City Manager 6C EECBG Grant - Federal Grants City Manager 6C Marketing Grant - Vision Iowa City Manager 4 Special Arts Projects Grant Funds City Clerk 6 Legal Notices & Ads City Clerk 6 Court Costs & Recording Fees City Clerk 6 Education & Training Finance 6C Finance Plus Upgrade - Software Finance 6C Software Upgrade E -Gov - Software Finance 6 Education & Training Legal Services 6 Education & Training Legal Services 6 Education & Training Legal Services 6 Travel - Conferences Page 8 (890) 100 10011100 62761 45,000 102 1021595 62765 35,752 100 1002180 73111 307,035 100 1002340 44310 14,943 100 1002340 62765 250,000 100 1002269 62765 250,000 100 1002269 45703 25,523 100 1002443 45703 11,256 100 1002443 62765 4,015 100 1001010 62711 4,673 102 1021010 73210 5,000 102 1022431 73210 25,000 102 1022432 62716 10,000 102 1022432 45701 (495) 100 10070100 62310 (575) 100 10072200 62734 674 100 10072200 62645 30,000 100 10072200 62761 50,000 100 10072200 71123 28,912 100 10072200 62761 (325) 100 10072100 62310 25,000 100 10072700 62360 9,977 100 1001070 62716 3,082 102 1021946 71120 3,390 100 1001948 62734 6,750 100 1002165 62360 909 100 1002050 72115 15,701 102 1022218 62716 166,154 100 1002334 62716 116,442 100 1002334 44170 97,014 100 1002338 62716 97,337 100 1002338 44175 5,000 100 1002275 45761 5,704 100 10072500 62761 (4,063) 100 10073100 62130 (1,741) 100 10073100 62230 (350) 100 10073100 62360 2,448 100 1002166 71123 6,521 100 1002217 71123 (270) 100 10074100 62360 (318) 100 10076100 62360 (318) 100 10076100 62360 (1,049) 100 10076100 62310 C/O Prespend FY14 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 C/O - Prespend FY14 CIO - Prespend FY14 C/O C/O C/O C/O C/O - Prespend FY14 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 C/O - Encumbrance Canceled CIO - Encumbrance Canceled C/O - Prespend FY14 C/O C/O C/O - Prespend FY14 C/O - Prespend FY14 C/O - Prespend FY14 C/O - Prespend FY14 t FISCAL YEAR 2014 AMENDMENT #1 CITY COUNCIL Department Program Description FY 14 Expense Amount FY 14 Revenue Amount Fund Activity /CIP Account Explanation 14- Aug -13 GENERAL FUND, Police Departmen Information Services Information Services Information Services Information Services Information Services Purchase of Service Purchase of Service TRANSIT FUND 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 1 Pay to Other Agency 6C City -Wide Computer Replacements 6C City-Wide Multifunction Replacement 6 Travel - Conferences 6 Travel - Conferences 6 Information Services - E -mail retrieval system 5 Pay to Other Agency - Opening Doors 5 Pay to Other Agency - Other POS TOTAL GENERAL FUND 8C Replace Fixed Route Buses - State of Good Repair Grant 8C Replace Fixed Route Buses - Equipment 8C Transit Roof Repair - State Grant 8C Transit Roof Repair- Construction 8C Intemiodal Feasibility Study - Consulting 8C Intemiodal Feasibility Study - Construction 8C Intermodal Feasibility Study - FTA Capital 8C Intemiodal Feasibility Study - Intercity Bus Grant 8C Keyline Facility Improvements 8C Keyline Facility Improvements - State Grant 8C Bus Stop Improvements - ARC Transfer Station 8C Bus Stop Improvements - Public Transportation Infrast. Grant 8 Bus Operations - Pay to Other Agency 8 Bus Operations - Camera Equipment 8 FTA Operating Assistance 8 Bus Operations - ICAAP Grant 8 Bus Operations - Private Participant 8 Administration - Radio /Pager Fee 8 Administration - Property Maintenance 8 Administration - Custodial Services 8 Bus Operations - Radio /Pager Fee 8 Mini Bus Operations - Radio /Pager Fee 8 Bus Maintenance - Electricity 8 Bus Maintenance - Gas 8 Bus Maintenance - Radio /Pager Fee 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 (890) 33,000 175,900 (495) (325) 16,800 (5,725) 5,725 8,556,030 4,593,056 558,409 338,637 245,000 243,510 1,200,000 11,378,257 8,000,000 199,000 33,200 12,610 25,707 118,819 2,255 570 294,240 417,750 5,681 (200) (2,308) (130) (440) (210) (8,885) (15,000) (45) 13,194,918 9,851,509 Page 9 765,521 84,975 850,496 100 10011100 62761 101 1011069 71124 102 1022435 71116 100 10077100 62310 100 10077100 62310 100 10077100 71123 100 10079400 62761 100 10079450 62761 600 6001224 44150 600 6001224 73411 600 6001613 45701 600 6001613 73210 600 6001614 62716 600 6001614 62716 600 6001614 44150 600 6001614 45771 600 6002045 73210 600 6002045 45701 600 6002235 73210 600 6002235 45701 600 60053400 62731 600 60053400 72418 600 60053100 44160 600 60053400 45771 600 60053400 53102 600 60053100 62424 600 60053100 62431 600 60053100 62433 600 60053400 62424 600 60053500 62424 600 60053700 62411 600 60053700 62412 600 60053700 62424 C/O - Prespend FY14 C/O C/O C/O - Prespend FY14 C/O - Prespend FY14 C/O Shift to other POS Shift from Opening Doors GF C/O C/O C/O C/O C/O C/O C/O - State of Good Repairs C/O Intercity Grant C/O C/O C/O C/O C/O - EC IA C/O - Fixed Route Cameras C/O C/O - Nightrider & Midtown CIO - Loras College - Nightride CIO - Over Encumbered CIO - Over Encumbered C/O - Over Encumbered C/O - Over Encumbered C/O - Over Encumbered C/O - Over Encumbered C/O - Over Encumbered C/O - Over Encumbered 241 2411033 62764 C/O 241 2411942 62765 C/O FISCAL YEAR 2014 AMENDMENT #1 CITY COUNCIL Department Program Description FY 14 Expense Amount FY 14 Revenue Amount Fund Activity /CIP Account Explanation 14- Aug -13 GENERAL FUND, Police Departmen 1 ROAD USE TAX FUND Public Works 2 Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Pay to Other Agency Street Maintenance - Truck Replacement Brunskill Rd Bridge Repl - Construction Railroad Cross Improvement - Construction Fiber Optic Conduit Project - Construction Traffic Signal Coordination - Consulting Engineers LED Re -Lamp Schedule - Construction TOTAL ROAD USE TAX FUND RESTRICTED TERMINAL PROJECT FUND Airport Department 2C Restricted Terminal Project - Private Participant TOTAL RESTRICTED TERMINAL PROJECT FUND SPECIAL ASSESSMENT FUND Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Special Assessment Receivable Special Assessment Receivable Special Assessment Receivable Millwork Streets Special Assessment Receivable Special Assessment Receivable Special Assessment Receivable TOTAL SPECIAL ASSESSMENT FUND COMMUNITY DEVELOPMENT BLOCK GRANT FUND Human Relations 3 Dubuque Resolution Center Engineering 2C Accessible Curb Ramps - Construction Engineering 5C Neighborhood Infrastructure Improvements - Construction Building Services 6C Multicultural Family Center - Construction Economic Developme 5C Commercialflndustrial Rehab Loan - CDBG Housing & Comm De\ 5 Travel - City Business Housing & Comm De\ 5 Housing Rehab Services - Education & Training Housing & Comm De\ 5 Community Development Block Grant Housing & Comm De\ 5 General Housing Inspection - Software License Housing & Comm De\ 5C Homeownership Rehab Program -Loans Housing & Comm De\ 5C Lead Paint Abatement Program - Loans Housing & Comm De\ 5C Rental Rehab - Loans Housing & Comm De\ 5C First Time Homebuyer Program -Loans Housing & Comm De\ 5C Historic Preservation Rehab Grant -Loans Purchase of Service 5 Pay to Other Agency - Information Referral Purchase of Service 5 Pay to Other Agency - Opening Doors TOTAL CDBG FUND (890) 100 10011100 62761 C/O - Prespend FY14 30,048 146,425 23,966 30,465 5,814 35,073 271,791 9,880 9,880 Page 10 728 17,978 15,333 76,259 185,806 (1,077) 1,721 2,943 172,849 7,016 65,358 21,900 7,059 (5,725) 5,725 573,873 110,000 124,000 307,000 102,748 212,000 49,222 904,970 250 250 250 250 250 250 25054400 2501077 2502026 2501017 2501228 2501916 71314 C/O 73211 C/O 73211 C/O 73211 C/O 73211 C/O 73411 C/O 252 2522447 73210 C/O 255 255 255 255 255 255 260 260 260 260 260 260 260 683,725 260 260 260 260 260 260 260 260 260 683,725 25510255 25510255 25510255 25510255 25510255 25510255 26016100 2601236 2601239 2601976 2601235 26061300 26016100 26061800 26061700 2601065 2601232 2601233 2601234 2601237 26079210 26079400 52101 52101 52101 52101 52101 52101 62360 73211 73211 73210 62764 62320 62360 44205 62663 73210 62764 62764 62764 62764 62761 62761 C/O C/O C/O C/O C/O C/O C/O C/O CDBG Funds CDBG Amend #1 C/O CDBG Funds C/O CDBG Funds C/O - Prespend FY14 C/O CDBG Funds C/O CDBG Funds C/O CDBG Funds C/O CDBG Funds CIO CDBG Funds CIO CDBG Funds CIO CDBG Funds CIO CDBG Funds Shift to Opening Doors Shift from Information Referral FISCAL YEAR 2014 AMENDMENT #1 CITY COUNCIL Department Program Description FY 14 Expense Amount FY 14 Revenue Amount Fund Activity /CIP Account Explanation 14- Aug -13 GENERAL FUND, Police Departmen t 1 Pay to Other Agency CARADCO COMMUNITY DEVELOPMENT BLOCK GRANT FUND Economic Devlopmt 5C CDBG Grant - Caradco Economic Devlopmt 5C CDBG Grant - Caradco TOTAL CARADCO CDBG FUND UDAG FUND Economic Devlopmt 5C Job Creation - Loans Economic Devlopmt 5C Historic Preservation - Revolving Loans Economic Devlopmt 5C Airport Revenue Guarantee - Pay to Other Agency TOTAL UDAG FUND STATE RENTAL REHAB FUND Housing & Comm De\ Housing & Comm De\ Housing & Comm De\ 5 Housing LHAP Construction 5C Homeownership Rehab Program- Construction 5C Home - Rental Five Points TOTAL STATE RENTAL REHAB FUND LEAD PAINT GRANT FUND Housing & Comm De\ 5C Housing & Comm De\ 5C Housing & Comm De\ 5C CABLE TV FUND City Manager City Manager City Manager City Manager Lead Paint Grant Lead Paint Grant - Grants Lead Paint Grant - Grants TOTAL LEAD PAINT GRANT FUND 6 Public Information - Promotion City Expo 6 Public Information - Hospitality Expense 6 Public Information - Consultant Services 6 Public Information - Printing and Binding TOTAL CABLE TV FUND LIBRARY TRUST FUND Library 4 General Gift Trust - Speakers /Programs TOTAL LIBRARY TRUST FUND STREET CONSTRUCTION FUND Public Works Engineering Engineering Engineering Engineering Engineering Engineering 2C Curb Ramp Program - Construction 2C Guardrail Replacement - Construction 2C Brunskill Rd Bridge Repl - Construction 2C Brunskill Rd Bridge Repl - State Grant 2C Bridge Repairs /Maintenance - Construction 2C Southwest Arterial- Construction Not Building 2C Southwest Arterial - SAFETEA -LU (890) 100 10011100 62761 C/O - Prespend FY14 3,368 10,892 263 2632341 45771 C/O 263 2632341 62761 C/O 3,368 21,480 40,247 150,000 211,727 12,985 453,869 68,199 535,053 83,182 39,720 122,902 3,000 3,000 4,300 32,000 42,300 10,892 265 2651246 62764 C/O 265 2651247 62764 C/O 265 2651796 62761 C/O 270 27061320 73210 C/O 270 2701065 73210 C/O 270 2701250 73210 C/O 452,500 275 2752429 44310 C/O 275 2752429 62765 C/O 275 2752429 62765 C/O - Training Reimbursement. 452,500 290 29072300 62140 C/O 290 29072300 62641 C/O 290 29072300 62641 C/O 290 29072300 62090 C/O 1,070 295 29536480 62734 C/O Page 11 1,070 50,022 25,001 676,934 24,280 927,923 710,623 2,070,936 300 300 300 300 300 300 300 3001227 3001027 3001077 3001077 3001258 3001287 3001287 73211 C/O 73211 C/O 73211 C/O 45701 C/O 73211 C/O 73211 C/O 45771 C/O FISCAL YEAR 2014 AMENDMENT #1 CITY COUNCIL 14- Aug -13 FY 14 FY 14 Expense Revenue Department Program Description Amount Amount Fund Activity /CIP Account Explanation GENERAL FUND, Police Departmen 1 Pay to Other Agency (890) 100 10011100 62761 C/O Prespend FY14 Engineering 2C Southwest Arterial- County Match 828,820 300 3001287 46205 C/O Engineering 2C White Water Creek Bridge - Private Participant 10,000 300 3001634 53102 C/O Engineering 2C White Water Creek Bridge - State Grant 2,600 300 3001634 45701 C/O Engineering 2C White Water Creek Bridge - Construction (35,595) 300 3001634 73211 C/O Engineering 2C Painting Street Lights/Signals - Engineering 2,000 300 3001917 62811 C/O Engineering 2C Painting Street Lights/Signals - Construction 8,000 300 3001917 73211 C/O Engineering 2C N Cascade Road Reconstruction - Consulting Engineers 12,699 300 3002021 62712 C/O Engineering 2C N Cascade Road Reconstruction - Construction 863,500 300 3002021 73211 C/O Engineering 2C N Cascade Road Reconstruction - State Highway 690,800 300 3002021 45725 C/O Engineering 2C Sub - Divisions Subdrains - Construction Not Building 173,360 300 3002023 73211 C/O Engineering 2C Sub - Divisions Subdrains- Consulting Engineers 28,125 300 3002023 62712 C/O Engineering 2C Green Alley Pilot Project 78,536 300 3002044 73211 CIO Engineering 2C Cedar Cross Reconstruction - State Highway Assistance 1,536,000 300 3002139 45725 CIO Engineering 2C Cedar Cross Reconstruction - Land Acquisition 307,507 300 3002139 73111 C/O Engineering 2C Cedar Cross Reconstruction - Construction 1,537,000 300 3002139 73211 CIO Engineering 2C Cedar Cross Reconstruction - Consulting Eng 243,773 300 3002139 62712 C/O Engineering 2C Pavement Marking - Construction (46,002) 300 3002245 73211 C/O - Prespend FY14 Engineering 2C SW Arterial - US 20 Cap Imp - Consulting 43,927 300 3002247 62712 C/O Engineering 2C SW Arterial - US 20 Cap Imp - State Grants 100,000 300 3002247 45701 C/O Engineering 2C N Grandview Estates Road - Construction 208,164 300 3002336 73211 C/O Engineering 2C N Grandview Estates Road - Reimbursements 33,163 300 3002336 53620 C/O Engineering 2C Manson Road Bridge - FEMA 75,000 300 3002349 44405 C/O Engineering 2C Signalization Program - Equipment Acquisition 52,133 300 3001011 73410 C/O Engineering 2C Fiber Optic Conduit Project - Construction 40,356 300 3001017 73211 C/O Engineering 2C Traffic Signal Masterami Rep. - Construction 56,101 300 3001133 73211 C/O Engineering 2C Traffic Signal Interconnect - Construction Not Building 44,983 300 3001266 73211 C/O Engineering 2C Traffic Controller Replacement- Equip Acquisition 18,258 300 3001274 73410 C/O Engineering 2C Street Light Replacement - Construction 26,726 300 3001549 73211 C/O Engineering 2C Signal lntersec Reconstruc- Construction 55,032 300 3001615 73211 C/O Engineering 2C Traffic Signal Fiber Optic Net - Construction 65,769 300 3001631 73211 C/O Engineering 2C Traffic Operations Center 2,909 300 3002423 73211 C/O Engineering 2C Traffic Signal Video Detection 6,154 300 3001816 73211 C/O Engineering 2C Fiber Optic Conduit - Misc - Construction 53,060 300 3002144 73211 C/O Engineering 2C Crosswalk blaming Devices 20,000 300 3002246 73211 C/O Engineering 2C Street Light /Signal Knockdown - Construction 22,314 300 3002252 73211 C/O - Prespend Engineering 2C Street Light /Signal Knockdown - Insurance Proceed 50,000 300 3002252 53610 C/O - Insurance Engineering 2C ITS Traffic Control Equipment 77,829 300 3002253 73211 C/O Engineering 2C JFK @ Wacker Signal Reconstruction - Construction 14,488 300 3001919 73211 C/O Engineering 2C Pennsylvania at Radford Intersection - Eng Division Services 20,000 300 3002256 62811 C/O Engineering 2C Pennsylvania at Radford Intersection - Construction 140,000 300 3002256 73211 C/O Engineering 2C Portable Radar Speed Sign 10,624 300 3002257 73211 C/O Engineering 2C University & Asbury Intersection 463,539 300 3002324 73211 C/O Page 12 FISCAL YEAR 2014 AMENDMENT #1 CITY COUNCIL Department Program Description FY 14 Expense Amount FY 14 Revenue Amount Fund Activity /CIP Account Explanation 14- Aug -13 GENERAL FUND, Police Departmen Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering 1 Pay to Other Agency 2C University & Asbury Intersection - Fed Aid 2C University & Asbury Intersection - State Highway 2C Video Detection Camera Upgrade 2C Cedar Cross Lighting 2C Catfish Creek Bridge Fiber 2C Surge & Ground Improvements - Signals 2C Street Camera Install 2C Traffic Operations Video Software 2C Traffic Operations Equipment Test TOTAL STREET CONSTRUCTION FUND SALES TAX FUND (20 %) Emergency Communi 1C Parks Division 4C Parks Division 4C Parks Division 4C Parks Division 4C Parks Division 4C Parks Division 4C Parks Division 4C Parks Division 4C Parks Division 4C Parks Division 4C Parks Division 4C Parks Division 4C Parks Division 4C Parks Division 4C Parks Division 4C Parks Division 4C Parks Division 4C Parks Division 4C Parks Division 4C Parks Division 4C Parks Division 4C Parks Division 4C Parks Division 4C Parks Division 4C Parks Division 4C Parks Division 4C Parks Division 4C Parks Division 4C Parks Division 4C Radio Equipment Tower Relocation Miller Riverview Campsite Playground Improvements - Equipment Playground Improvements- Equipment Northend Trail Lighting - Construction Renovate Park Water System - Consulting Renovate Park Water System - Construction 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 Highway 20 Roses Plan - Landscape Riverwalk Baskets - Irrigate Pet Park Terminal Street - Construction Mulch Replacement Murphy Park Fence EPP Paint Pavilions - Construction AH Exterior Improvements McAleece French Drains McAleece Replace Plumbing Miller Riverview Paving Maint Headquarters Restroom Rehab - Construction Electronic Locks Restrooms - Construction Ecological Restoration - Landscape Bunker Replace Roof Main - Construction Roof Replacement - Bunker /Patrol /Maintenance Page 13 (890) 30,860 16,001 8,881 22,443 8,405 6,784 56,886 6,469, 689 142,119 272 23,217 153 31,227 11,578 24,349 36 10,205 9,050 5,372 3,729 14,884 30,000 58,808 15,000 12,000 94,308 21,030 5,220 25,000 5,223 10,000 4,347 25,000 5,792 30,000 10,000 74,935 16,165 100 10011100 62761 C/O Prespend FY14 116,000 300 3002324 44145 C/O 224,000 300 3002324 45725 C/O 300 3002325 73410 C/O 300 3002326 73211 C/O 300 3002327 62712 C/O 300 3002420 73410 C/O 300 3002421 73410 C/O 300 3002422 71123 C/O 300 3002423 71123 C/O 6,447,942 350 3502353 72410 C/O 350 3501024 73210 C/O 350 3501048 73410 C/O 350 3501048 73410 C/O shift from Marshall Play l 350 3501129 73211 C/O 350 3501158 62712 C/O 350 3501158 73211 C/O 350 3501158 73211 C/O 350 3501197 73210 C/O 350 3501438 73211 C/O 350 3501453 73211 C/O 350 3501458 73311 C/O 350 3501462 73210 C/O 350 3501468 73210 C/O 350 3501578 73211 C/O 350 3501588 73310 C/O 350 3501937 73211 C/O 350 3501978 73211 C/O 350 3501986 73310 C/O 350 3502296 73211 C/O 350 3502358 73210 C/O 350 3502359 73210 C/O 350 3502360 73210 C/O 350 3502361 73210 C/O 350 3502362 73211 C/O 350 3502364 73210 C/O 350 3502365 73210 C/O 350 3502367 73310 C/O 350 3502369 73210 C/O 350 3502370 73210 C/O FISCAL YEAR 2014 AMENDMENT #1 CITY COUNCIL Department Program Description FY 14 Expense Amount FY 14 Revenue Amount Fund Activity /CIP Account Explanation 14- Aug -13 GENERAL FUND, Police Departmen Parks Division Parks Division Parks Division Civic Center Division Civic Center Division Civic Center Division Civic Center Division Civic Center Division Civic Center Division Conference Center Conference Center Conference Center Conference Center Conference Center Recreation Recreation Recreation Library Library Library Public Works Public Works Public Works Public Works Public Works Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Building Services Building Services Building Services Building Services Building Services Building Services Planning Services Planning Services Planning Services 1 Pay to Other Agency 4C Parking Lot Striping 4C EPP Bridge Beam Support - Construction 4C Flora Playground Equipment 4C Theatre Tuckpoint Exterior - Construction 4C Theatre Tuckpoint Exterior - Consultant Services 4C Seal Concrete Walkways - Construction 4C Arena Roof - Construction 4C Arena Light Fixtures - Consulting 4C Arena Light Fixtures - Construction 6C Grand River Center Chairs 6C GRC - Paint Ballrooms 6C GRC - Fabric Wall Covering - Consulting 6C GRC - Fabric Wall Covering - Construction 6C GRC - Outdoor Sign 4C Flora & Sutton Pool Storage 4C Golf Course Irrigation - Construction 4C Bunker Building Windows - Construction 4C Library Exterior Improvements - Construction 4C Library Renovation Repairs - Construction 4C Library Repair & Replace Windows 2C Floodwall Post Flood Repair- Construction 2C Cold Storage Building Mezz - Construction Not Building 2C Port of Dubuque Amenities 2C Wayfinding Sign Replacement 2C Ice Harbor Gates Timber 2C Stone Retaining Walls - Construction Not Building 2C Ice Harbor Maintenance /Dredging 2C Decorative Concrete Maint - Construction 2C Sidewalk Financial Assistance 2C Accessibility Barriers - Construction 2C Riverfront Leasehold Improvements - Consultant Services 2C Rehab Railroad Tracks 2C Downtown Street Light Replacement 6C City Hall Remodeling 6C General Building Maintenance 6C City Hall Annex Maintenance - Construction 6C 18th Street Building Improvements - Tax Credits 6C Smart Meters - Construction 6C Smart Meters - Consultant 5C Riverfront 2000 Plan - Consulting 5C Trails /Complete Streets 5C Trails /Complete Streets -Grant Page 14 (890) 100 10011100 62761 C/O Prespend FY14 4,208 350 3502373 73211 C/O 25,000 350 3502376 73210 C/O 30,131 350 3502377 73410 C/O 242,216 350 3501708 73210 C/O 2,200 350 3501708 62716 C/O 25,000 350 3502303 73211 C/O 385,341 350 3502378 73210 C/O 9,903 350 3502379 62712 C/O 161,000 350 3502379 73210 C/O 28,545 350 3501990 71212 C/O 18,000 350 3502110 73210 C/O 3,500 350 3502112 62712 C/O 31,500 350 3502112 73210 C/O 62,065 350 3502388 73211 C/O 7,756 350 3501090 73210 C/O 14,694 350 3501530 73210 C/O 3,425 350 3501775 73210 C/O 21 350 3501681 73211 C/O 90,886 350 3502308 73211 C/O 176 350 3502393 73210 C/O 74,300 350 3501445 73211 C/O 44,732 350 3502037 73211 C/O 3,294 350 3502038 73510 C/O 5,000 350 3502151 71619 C/O 18,958 350 3502222 73211 C/O 132,499 350 3501029 73211 C/O 65,448 350 3501466 73211 C/O 150,391 350 3501630 73211 C/O 12,451 350 3501727 62761 C/O 68,458 350 3501034 73210 C/O 131,844 350 3501053 62716 C/O 79,507 350 3501465 73211 C/O 3,269 350 3501608 73410 C/O 250,852 350 3501045 73210 C/O 12,691 350 3501428 73210 C/O 29,929 350 3501757 73210 C/O 672,207 350 3501975 53620 C/O 159,633 350 3502259 73210 C/O 5,985 350 3502259 62712 C/O 5,000 350 3501015 62712 C/O 247,000 350 3502430 73210 C/O 200,000 350 3502430 45707 C/O FISCAL YEAR 2014 AMENDMENT #1 CITY COUNCIL Department Program Description FY 14 Expense Amount FY 14 Revenue Amount Fund Activity /CIP Account Explanation 14- Aug -13 GENERAL FUND, Police Departmen t 1 Planning Services 5C Pay to Other Agency Kiosk Map Replacements TOTAL SALES TAX FUND GENERAL CONSTRUCTION 4C 4C 4C 4C 4C 4C 4C 4C 4C 4C 8C 8C 2C 6C 6C 6C 8C 5C 5C 5C 5C 5C 5C 5C 5C 5C 5C 5C 5C 5C 5C 5C 5C 5C 5C 5C 5C 5C Parks Division Parks Division Parks Division Parks Division Parks Division Recreation Recreation Recreation Recreation Recreation Parking Division Transit Division Engineering Building Services Building Services Building Services Building Services Economic Devlopmt Economic Devlopmt Economic Devlopmt Economic Devlopmt Economic Devlopmt Economic Devlopmt Economic Devlopmt Economic Devlopmt 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 FUND Comiskey Landscape Replace Park Signs DICW Wildflowers Granger Creek Trail - Construction McAleece Sidewalks - Construction Mystique Ice Center - Air Conditioning Mystique Ice Center - Electrical Improvements Mystique Ice Center - Ice Decking Mystique Ice Center - Generator Mystique Ice Center - Power Factor Port of Dubuque Ramp Repairs - Construction Rail Platform 1 Way to 2 Way Conversion 5th & Bluff Public Restroom 5th & Bluff Public Restroom Multicultural Family Center - Construction Downtown UR Area ADA Millwork District Parking Imp - Construction Millwork District Parking Imp - Construction Millwork District Parking Imp - Bond Proceeds Industrial Site Development - North Siegert - RISE Grant Downtown Rehab Consultant - Financial Consultant Design South Siegert Farm - Construction Design South Siegert Farm - Construction Design South Siegert Farm - Construction Design South Siegert Farm - RISE Grant Downtown Housing Incentive- Pay to Other Agency IFA Downtown Housing Loan Pool - Interest Payments IFA Downtown Housing Loan Pool - Interest Receivable Washington Neighborhood Business Incentives - Grants Future Industrial Acquisitions - Consultant Services Washington Neighborhood Downtown Incentives - Grants Washington Neighborhood Downtown Incentives - Bond Millwork District Incentives - Grants Millwork District Incentives - GO Bond Proceeds Historic District Improvements - Construction Riverfront 2000 Plan - Consulting Historic Preservation Technical Assistance - Construction Page 15 (890) 10,000 3,375, 827 50,000 10,000 164,970 192,856 104,288 75,226 29,060 6,392 91,198 10,099 620,736 245,523 1,398,427 142,000 195,917 1,478,153 28,007 1,248, 327 2,671,187 89,000 8,429 3,820,092 229,247 1,074,990 135,000 222,748 107,616 1,499,576 670,000 25,055 25,000 10,000 100 10011100 62761 C/O - Prespend FY14 350 3502433 73211 C/O 872,207 360 3601105 73210 360 3601774 71227 360 3602158 73310 360 3602371 73211 360 3602374 73211 360 3602383 73210 360 3602384 73210 360 3602385 73210 360 3602386 73210 360 3602387 73210 360 3601957 73211 360 3602426 73211 360 3602442 73211 360 3602425 73211 360 3602425 73211 360 3601976 73210 360 3602424 73211 360 3602250 73211 360 3602250 73211 1,500,000 360 3602250 54210 39,366 360 3601943 45741 360 3602157 62721 360 3602160 73211 360 3602160 73211 360 3602160 73211 229,247 360 3602160 45741 360 3602267 62765 360 3602267 74112 135,000 360 3602267 43105 360 3602436 62765 360 3602436 62765 360 3602436 62765 750,000 360 3602436 54210 360 3602439 62765 670,000 360 3602439 54210 360 3601010 73210 360 3601015 62712 360 3602431 73210 C10 C!O C!O C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O Shift from 7th St Improvements C/O C/O C/O Shift from 7th St Improvements C/O C/O Property Acquisition C/O C/O C/O Shift from N. Siegert 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 C/O C/O FISCAL YEAR 2014 AMENDMENT #1 CITY COUNCIL Department Program Description FY 14 Expense Amount FY 14 Revenue Amount Fund Activity /CIP Account Explanation 14- Aug -13 GENERAL FUND, Police Departmen Cable TV 1 Pay to Other Agency 6C Telecommunications Study TOTAL GENERAL CONSTRUCTION FUND GOLF CONSTRUCTION FUND Recreation 4C Golf Course Irrigation - Construction Recreation 4C Bunker Detention Project #17 TOTAL GOLF CONSTRUCTION FUND AIRPORT CONSTRUCTION 2C 2C 2C 2C 2C 2C 2C 2C 2C 2C 2C 2C 2C 2C 2C 2C 2C 2C 2C 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 FUND Terminal - RW 31 Parallel - Consulting Engineers Terminal - RW 31 Parallel - Construction Terminal - RW 31 Parallel -FAA Funds Extend Gen'I Aviation Ramp - Consulting Engineers Extend Gen'I Aviation Ramp - Construction Terminal Sitework - Consultant Engineers Terminal Sitework - Construction Terminal Sitework - FAA Funds Onsite Water and Wastewater - Consulting New Terminal Facility - Consulting Engineers New Terminal Facility - Construction New Terminal Facility - FAA Funds New Terminal Facility - State Grants New Term Facilities Roads and Aprons - Construction New Term Facilities Roads and Aprons - FAA Funds New Term Facilities Roads and Aprons - RISE Grant Hangar Paving - FAA HVAC Joint Use Building - Construction ADF Containment - Consultant Services TOTAL AIRPORT CONSTRUCTION FUND WATER & RESOURCE RECOVERY CENTER OPERATING FUND Water & Resource Re 8 Laboratory Equipment TOTAL WATER & RESOURCE RECOVERY CENTER STORMWATER OPERATING FUND Engineering 2 Engineering 2 REFUSE FUND Public Works Public Works Travel - Conferences Travel - Conferences TOTAL STORMWATER OPERATING FUND 8C Dual Packer Recycle Vehicles 8C Public Works Fleet GPS /AVL Project (890) 110,000 16,789,119 85,306 3,212 88,518 3,323, 613 248,100 3,181,772 3,295,567 5,000 49,000 114,000 250,000 345,800 14,710 473,075 1,310,550 6,718,588 298,777 3,077,428 3,223,558 44,848 10,580 36,157 94,706 8,854, 498 13,937, 718 100 10011100 62761 C/O - Prespend FY14 360 3601534 62716 C/O 370 3701530 73211 C/O 370 3702382 73210 C/O 390 3901891 62712 CIO 390 3901891 73211 C/O 390 3901891 44105 C/O 390 3901893 62712 CIO 390 3901893 73211 C/O 390 3902009 62712 C/O 390 3902009 73211 C/O 390 3902009 44105 C/O 390 3902011 62712 C/O 390 3902213 62712 C/O 390 3902213 73210 C/O 390 3902213 44105 C/O 390 3902213 45701 C/O 390 3902316 73211 C/O 390 3902316 44105 C/O 390 3902316 45741 C/O 390 3902346 41105 C/O 390 3902403 73210 C/O 390 3902448 62716 C/O 39,890 610 61043700 71413 C/O 39,890 (495) (495) (990) 620 62055620 62310 C/O - Prespend FY14 620 62055620 62310 C/O - Prespend FY14 40,846 670 6701533 73410 C/O 4,611 670 6701935 73410 C/O Page 16 FISCAL YEAR 2014 AMENDMENT #1 CITY COUNCIL 14- Aug -13 FY 14 FY 14 Expense Revenue Department Program Description Amount Amount Fund Activity /CIP Account Explanation GENERAL FUND, Police Departmen 1 Pay to Other Agency (890) 100 10011100 62761 C/O - Prespend FY14 TOTAL REFUSE FUND 45,457 - SALT OPERATIONS FUND Public Works 8C Purina Drive Barge Facility Scale 31,326 680 6802320 73211 C/O TOTAL SALT OPERATIONS FUND 31,326 - AMERICA'S RIVER PROJECT FUND Engineering 8C Art in Port of Dubuque - Consultant Services 125,895 700 7001853 62731 C/O TOTAL AMERICA'S RIVER PROJECT FUND 125,895 SANITARY SEWER CONSTRUCTION FUND Water & Resource Re 8C Scada System Upgrade - Construction - Not Building 42,929 710 7101339 73211 C/O Water & Resource Re 8C WPC Plant Facility Study - Construction Building 87,037 710 7101837 73210 C/O Shift from Bradley Pumpi Water & Resource Re 8C WPC Plant Facility Study - Construction Building 3,200,843 710 7101837 73210 C/O Water & Resource Re 8C WPC Plant Facility Study - SRF Bond Proceeds 9,550,814 710 7101837 54230 C/O Water & Resource Re 8C WPC Cogen - Private Participant (Jeld -Wen) 386,843 710 7101837B 53102 C/O Water & Resource Re 8C WPC Cogen - Construction 386,843 710 7101837B 73210 C/O Water & Resource Re 8C Pumping Station Telemetry - Equipment Acquisition 36,590 710 7101930 73410 C/O Water & Resource Re 8C Terminal Street Mag Meter Repair- Consulting 288,761 710 7102211 62712 C/O Water & Resource Re 8C Terminal Street Mag Meter Repair - Consulting 884 710 7102211 62712 C/O Public Works 8C Mobile GIS System - Equipment 7,552 710 7102225 73410 C/O Public Works 8C Sanitary Sewer Root Foam Project (12,209) 710 7101341 62731 C/O Prespend FY14 Public Works 8C Sewer Pipeline Inspection Equipment 2,459 710 7101840 73410 C/O Public Works 8C High Pressure Sewer Jet - Equipment 165,000 710 7102405 71550 C/O Public Works 8C High Pressure Sewer Jet - GO Bond Proceeds 165,000 710 7102405 54210 C/O Engineering 8C Annexation Study /Implementation 447,860 710 7101012 73211 C/O Engineering 8C Annexation Study /Implementation - GO Bond 450,000 710 7101012 54210 C/O Engineering 8C Sewer Conn Asst - Low /Mod - Miscellaneous Services 34,717 710 7101067 62731 C/O Engineering 8C Sanitary Sewer Internal Main - Construction 253,000 710 7101293 73510 C/O Engineering 8C Sanitary Sewer Internal Main - Private Participant 241,416 710 7101293 53102 C/O Engineering 8C I &I Reduction Program (69,828) 710 7101294 73211 C/O Prespend FY14 Engineering 8C Lateral Repl Asst. Low Inc - Eng. Division Services 20,000 710 7101297 62811 C/O Engineering 8C Nightengale Lane Sanitary Sewer - Eng Division Services 40,000 710 7101301 62811 C/O Engineering 8C Nightengale Lane Sanitary Sewer - Construction 270,566 710 7101301 73510 C/O Engineering 8C Sewer Lateral Assistance - Eng Division Services 46,448 710 7101309 62811 C/O Engineering 8C Sewer Lateral Assistance - Construction Not Bldg 53,565 710 7101309 73211 C/O Engineering 8C Laterals - I &I Reduction 17,660 710 7101320 73211 C/O Engineering 8C Alley Washington - Jackson Sewer- Construction 130,000 710 7101327 73211 C/O Engineering 8C Loras/Walnut to Prairie St Sewer - Construction 54,542 710 7101328 73211 C/O Engineering 8C Sanitary Sewer Manhole Replacement 85,735 710 7101335 73211 C/O Engineering 8C Hwy 20 Annexation Sanitary Sewers - Construction 257,721 710 7101336 73211 C/O Engineering 8C Sewer Clearing /Grubbing - Construction (299) 710 7101636 73211 C/O Prespend FY14 Page 17 FISCAL YEAR 2014 AMENDMENT #1 CITY COUNCIL Department Program Description FY 14 Expense Amount FY 14 Revenue Amount Fund Activity /CIP Account Explanation 14- Aug -13 GENERAL FUND, Police Departmen 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 City Manager STORM WATER Parks Division Parks Division Public Works 1 Pay to Other Agency 8C Sanitary Sewer Lining Program - Const Not Bldg 8C Street Program /Related - Const Not Bldg 8C Monroe St Sanitary Sewer - Construction 8C Southfork Interceptor - Consulting Engineers 8C Southfork Interceptor - Const Cont - Not Bldg 8C Century Sewer Manholes - Engineering 8C Century Sewer Manholes - Construction 8C Historic Millwork - Sanitary Sewer - Const 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 Fairway Dr Sanitary Sewer - Construction 8C Fairway Dr Sanitary Sewer - Engineering Division Services 8C Southgate Sanitary Sewer - Construction 8C Southgate Sanitary Sewer - Eng Division Services 8C Hawthome Sanitary - Engineering 8C Hawthome 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 - Construction 8C Private Lateral CCTV Inspection 8C Cedar Lift Pump/Generator/Trailer - Construction 8C Relocation 30" Main Old Public Works - Engineering 8C Relocation 30" Main Old Public Works - Construction 8C $9.4 Green Alleys - SRF Proceeds 8C $9.4 Green Alleys - Engineering 8C $9.4 Green Alleys - Construction 8C GIS Enhancements- Peripherals, Computer TOTAL SANITARY SEWER CONST FUND CONSTRUCTION FUND 8C Eagle Point Park Stormwater - Construction 8C Bee Branch Trees Forever - Tree Planting 8C PW Fleet GPS Project - Pager /Radio Equipment Page 18 (890) 210,698 8,108 6,947 25,141 372,379 4,000 15,000 (517) 28,724 300,000 58,653 8,203 20,000 3,500 34,000 4,000 4,000 15,126 15,000 93,741 9,748 85,191 7,365 43,102 5,000 55,000 271,640 150,000 141,369 12,776 538,002 90,000 9,201,351 5,291 17,690, 914 79,597 6,130 10,000 100 10011100 62761 710 7101637 73211 710 7101638 73211 710 7101797 73211 710 7101899 62712 710 7101899 73211 710 7101905 62811 710 7101905 73211 710 7102129 73211 710 7102130 62811 710 7102130 73211 710 7102232 73211 710 7102232 62811 710 7102233 73211 710 7102233 62811 710 7102234 73211 710 7102234 62811 710 7102322 62811 710 7102322 73211 710 7102322 62811 710 7102322 73211 710 7102406 62811 710 7102406 73211 710 7102407 62811 710 7102407 73211 710 7102408 62811 710 7102408 73211 60,000 710 7102408 54210 710 7102409 73211 710 7102410 62811 710 7102412 73211 710 7102413 62811 710 7102413 73211 9,305,183 710 7102450 54230 710 7102450 62811 710 7102450 73211 710 7101946 71120 20,159, 256 C/O Prespend FY14 C/O C/O C/O C/O C/O C/O C/O C/O - Over Encumbered 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 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 C/O C/O 720 7202301 73211 C/O 720 7202337 73311 C/O 720 7201935 73410 C/O FISCAL YEAR 2014 AMENDMENT #1 CITY COUNCIL 14- Aug -13 FY 14 FY 14 Expense Revenue Department Program Description Amount Amount Fund Activity /CIP Account Explanation GENERAL FUND, Police Departmen 1 Pay to Other Agency (890) 100 10011100 62761 C/O Prespend FY14 Public Works 8C Mobile GIS System - Equipment 7,552 720 7202225 73410 C/O Public Works 8C Bee Branch Pump Station 97,370 720 7202319 73211 C/O Public Works 8C Flood High Water Alarm - Construction 4,500 720 7202404 73211 C/O Engineering 8C Catch Basin/Westside - Construction Not Building 44,130 720 7201081 73211 C/O Engineering 8C Streambank Rehab - Construction 4,611 720 7201352 73211 C/O Engineering 8C Drain Tile Program - Construction 11,638 720 7201354 73211 C/O Engineering 8C NPDES Program 4,922 720 7201355 62811 C/O Engineering 8C Carter Road Culvert - Engineering 8,997 720 7201356 62811 C/O Engineering 8C Carter Road Culvert - Construction 58,000 720 7201356 73211 C/O Engineering 8C Detention Basin Maintenance - Engineering 864 720 7201359 62811 C/O Engineering 8C Gunite Rock Stormsewer- Construction 36,310 720 7201363 73211 C/O Engineering 8C General Detention Basin Silt Removal - Construction 88,774 720 7201375 73211 C/O Engineering 8C Bee Branch Alignment - State Revolving Loan Funds 14,684,687 720 7201654 54230 C/O Engineering 8C Bee Branch Alignment - State Trail Grant 100,000 720 7201654 45701 C/O Engineering 8C Bee Branch Alignment - National Trail Grant 1,000,000 720 7201654 45701 C/O Engineering 8C Bee Branch Alignment - RECAT Grant 2,040,858 720 7201654 45701 C/O Engineering 8C Bond Proceeds - Bee Branch 10,052,739 720 7201654 54210 C/O Engineering 8C Bee Branch - Private Participant Wahlert Foundation 30,000 720 7201654 53102 C/O Engineering 8C Bee Branch - DMATS Enhancement Funds 700,000 720 7201654 45725 C/O Engineering 8C Bee Branch Alignment - Land Acquisition 1,694,590 720 7201654 73111 C/O Engineering 8C Bee Branch Alignment - Construction 25,424,591 720 7201654 73211 C/O Engineering 8C Bee Branch Alignment - Construction 700,000 720 7201654 73211 C/O Engineering 8C Stomi Sewer Cleaning - Construction 161,956 720 7201659 73211 C/O Engineering 8C Century Drive Storm (30) 720 7201663 73211 C/O Prespend FY14 Engineering 8C Amy Ct Stomp Sewer Impry - Eng. Division Services 1,710 720 7201666 62811 C/O Engineering 8C Amy Ct Storm Sewer Improv - Construction 12,000 720 7201666 73211 C/O Engineering 8C 32nd & Grandview Storm Improvements - Eng Division Service. 38,378 720 7201808 62811 C/O Engineering 8C Villa St Storm Sewer Proj - Eng Division Services 11,551 720 7201809 62811 C/O Engineering 8C Villa St Storm Sewer Proj - Construction 95,000 720 7201809 73211 C/O Engineering 8C Stormwater System Assessment 294,254 720 7202015 62712 C/O Engineering 8C Hillcrest /Keyway Storm Sewer - Construction 30,000 720 7202016 73211 C/O Engineering 8C Hillcrest /Keyway Storm Sewer - Consulting Engineers 4,300 720 7202016 62712 C/O Engineering 8C Green Alley Pilot Project - Construction 18,055 720 7202044 73211 C/O Engineering 8C NPDES Erosion Control 830 720 7202062 62811 C/O Engineering 8C NPDES Illicit Discharge 775 720 7202063 62811 C/O Engineering 8C NPDES Municipal Operation 2,229 720 7202064 62811 C/O Engineering 8C NPDES Post Construction 1,589 720 7202065 62811 C/O Engineering 8C NPDES Public Education 1,306 720 7202066 62811 C/O Engineering 8C NPDES Public Participation 2,586 720 7202067 62811 C/O Engineering 8C Kane Kaufman Storm Sewer- Engineering 22,957 720 7202133 62811 C/O Engineering 8C Kane Kaufman Storm Sewer - Construction 148,881 720 7202133 73211 C/O Engineering 8C Peru Road Stomi Sewer- Engineering 3,128 720 7202133 62811 C/O Page 19 FISCAL YEAR 2014 AMENDMENT #1 CITY COUNCIL Department Program Description FY 14 Expense Amount FY 14 Revenue Amount Fund Activity /CIP Account Explanation 14- Aug -13 GENERAL FUND, Police Departmen Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering 1 Pay to Other Agency 8C Peru Road Storm Sewer - Construction 8C Millwork District Storm Sewer - Construction 8C Cedar Cross Rd Storm - Engineering 8C Cedar Cross Rd Storm - Construction 8C Floodwall Breach Analysis 8C Drainage Basin Master Plan 8C Lower Bee Branch Construction 8C Stormwater I & I 8C Stormwater I & I Prevention 8C Windsor Storm - Construction 8C Detention Basin Security 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 Parking Division Parking Division Parking Division Parking Division Parking Division Parking Division Parking Division Parking Division Parking Division Parking Division Parking Division Building Services City Manager Seal Coating Parking Lots - Consultant Services Seal Coating Parking Lots - Construction Contract Major Maintenance on Ramps - Construction Locust Street Ramp Repairs - Construction Locust Street Ramp Repairs - Bond Proceeds Ramp Structural Evalation - Consulting Engineers Port of Dubuque Ramp Maint - Construction 7th Street Pedestrian Walkway Study - Consulting Locust & Iowa Bathroom Remodel - Construction Ramp Signage - Signage POD Electrical Cabinet Smart Meters - Construction 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 GIS Maintenance /Upgrade - Consulting Engineers Service Line Assistance - Misc Services Eagle Point Plant Office & Lab Pump Room - Construction Water Internal Lines /Loan - Construction Water Internal Lines /Loan - Consulting Engineers Water Internal Lines /Loan - Private Participant Water Main Extensions - Construction Water Meter Exchange Fire Hydrant Replacements - Equipment (890) 10,526 (1,152) 5,000 10,000 8,862 10,070 1,398 38,113 (126) 39,149 53,874 22,474 15,491 169,350 29,517, 060 Page 20 100 10011100 62761 720 7202133 73211 720 7202131 62712 720 7202238 62811 720 7202238 73211 720 7202239 62811 720 7202240 62712 720 7202281 73211 720 7202332 73211 720 7202333 73211 720 7202414 73211 720 7202415 73211 720 7202417 73211 720 7202418 62811 720 7202418 73211 28,608,284 C/O Prespend FY14 C/O C/O - Over Encumbered C/O C/O C/O C/O C/O C/O C/O FY14 Prespend C/O C/O C/O C/O C/O 3,726 730 7301380 62716 C/O 167,559 730 7301380 73211 C/O 92,103 730 7301385 73210 C/O 241,758 730 7301671 73210 C/O (192,014) 730 7301671 54210 C/O Central Ramp /POD Ram 730 7302046 62712 C/O 730 7302162 73211 C/O 730 7302163 62712 C/O 730 7302227 73210 C/O 730 7302228 71227 C/O 730 7302487 73211 C/O Prespend FY14 730 7302259 73210 C/O 730 7301946 71120 C/O 5,013 288,729 10,000 90,000 11,941 (33,928) 59,000 5,291 941,192 (192,014) 44,891 740 7401389 62712 C/O 8,161 740 7401390 62731 C/O 50,832 740 7401397 73210 C/O 150,000 740 7401398 73211 C/O 20,000 740 7401398 62712 C/O 170,000 740 7401398 53102 C/O 48,419 740 7401399 73211 C/O 6,805 740 7401400 73410 C/O 433 740 7401409 73410 C/O FISCAL YEAR 2014 AMENDMENT #1 CITY COUNCIL Department Program Description FY 14 Expense Amount FY 14 Revenue Amount Fund Activity /CIP Account Explanation 14- Aug -13 GENERAL FUND, Police Departmen 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 City Manager Information Services LANDFILL FUND Public Works TRANSFERS Parks Division 1 Pay to Other Agency 8C Valve Replacement - Construction 8C Main Extension - Construction 8C Annual Tank Inspection 8C Roosevelt Rd. Main Ext. - Consult Eng 8C Roosevelt Rd. Main Ext. - Construction 8C Roosevelt Rd. Main Ext. - Bond Proceeds 8C Green Alley Pilot Project - Construction 8C Millwork Dist - Water Main - Construction 8C Drinking Water Study - Consulting Engineers 8C Water Service Repair Grant - Grants 8C Fire Hydrant Painting - Construction 8C Water Valve Box Maintenance 8C Pump Replacement Vacuum Filter- Pumps 8C Mobile GIS System 8C Ramp Water Utility Relocate - Const Not Bldg 8C Ramp Water Utility Relocate - Bond Proceeds 8C Eagle Point Plant Driveway and Parking Lot - Construction 8C Eagle Point Plant Driveway and Parking Lot - Consulting 8C Eagle Point Plant Driveway and Parking Lot - GO Bonds 8C Filter Maintenance Program - Construction 8C Auto Meter Read System Maintenance Program 8C Water Extension - Airport - Consulting 8C Water Extension - Airport - Construction 8C Water Extension - Airport -GO Bond 8C North Softening Basin - Construction 8C McAleece Water Improvements - 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 GIS Enhancements- Peripherals, Computer 8C Computer Replacements TOTAL WATER CONSTRUCTION FUND 8C DMASWA Education - Promotion TOTAL LANDFILL FUND Transl Transfer from GDTIF to General Fund (890) 27,441 74,074 12,000 11,543 75,083 88,062 (1,604) 27,821 6,766 25,625 9,206 10,115 458 107,741 100,000 5,000 25,000 13,670 254,893 1,907, 237 119,923 90,941 84,946 49,967 6,000 30,000 14,165 2,841 30,000 3,538, 455 100 10011100 62761 C/O Prespend FY14 740 7401410 73211 C/O 740 7401411 73211 C/O 740 7401412 62712 C/O 740 7401672 62712 C/O 740 7401672 73211 C/O 75,000 740 7401672 54210 C/O 740 7402044 73211 C/O 740 7402145 73211 C/O - Over Encumbered 740 7402147 62712 C/O 740 7402200 62765 C/O 740 7402201 73211 C/O 740 7402203 62431 C/O 740 7402205 71511 C/O 740 7402225 73510 C/O 740 7402261 73211 C/O 107,741 740 7402261 54210 C/O 740 7402309 73211 C/O 740 7402309 62712 C/O 40,000 740 7402309 54210 C/O 740 7402311 73211 C/O 740 7402314 73211 C/O 740 7402395 62712 C/O 740 7402395 62712 C/O 1,626,279 740 7402395 54210 C/O 740 7402396 73211 C/O 740 7402397 73211 C/O 740 7402398 73210 C/O 740 7402399 62712 C/O 740 7402400 62712 C/O 740 7402400 73211 C/O 36,000 740 7402400 54210 C/O 740 7402402 73210 C/O 740 7401946 71120 C/O 740 7401069 71124 C/O 2,055,020 4,683 940 94054230 62140 C/O - Match IDNR EMS Grant 4,683 Transfer Out 9,800 Page 21 Transfer In 240 24060240 91100 Trans Funds FISCAL YEAR 2014 AMENDMENT #1 CITY COUNCIL Department Program Description FY 14 Expense Amount FY 14 Revenue Amount Fund Activity /CIP Account Explanation 14- Aug -13 GENERAL FUND, Police Departmen Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Recreation Recreation Recreation Recreation 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 Engineering 1 Transl Trans2 Trans2 Trans3 Trans3 Trans4 Trans4 Trans5 Trans5 Trans6 Trans6 Trans7 Trans7 Trans08 Trans08 Trans09 Trans09 Transl0 Transl 0 Transll Transl 1 Transl 2 Transl2 Transl 3 Transl 3 Transl3 Transl 3 Transl 4 Transl4 Transl5 Transl5 Transl6 Transl 6 Transl 7 Transl7 Transl 8 Transl 8 Transl9 Transl 9 Trans20 Trans20 Trans21 Pay to Other Agency Transfer from GDTIF to General Fund Transfer from DRA Gaming to Sales Tax Construction Transfer from DRA Gaming to Sales Tax Construction Transfer from Greater Downtown TIF to General Construction Transfer from Greater Downtown TIF to General Construction Transfer from Dubuque Indust Ctr to General Const Transfer from Dubuque Indust Ctr to General Const Transfer from Dubuque Indust Ctr to General Const Transfer from Dubuque Indust Ctr to General Const Transfer from Golf Construction to General Fund Transfer from Golf Construction to General Fund Transfer from Bond Fund to Sales Tax Construction Transfer from Bond Fund to Sales Tax Construction Transfer from PFC Fund to Airport Construction Fund Transfer from PFC Fund to Airport Construction Fund Transfer from DRA Dist Fund to Airport Construction Fund Transfer from DRA Dist Fund to Airport Construction Fund Transfer from PFC Fund to Airport Construction Fund Transfer from PFC Fund to Airport Construction Fund Transfer from PFC Fund to Airport Construction Fund Transfer from PFC Fund to Airport Construction Fund Transfer From CFC Fund to Airport Const. Fund Transfer From CFC Fund to Airport Const. Fund Transfer From PFC Fund to Airport Const. Fund Transfer From PFC Fund to Airport Const. Fund Transfer from Transfer from Transfer from Transfer from Transfer from Transfer from Transfer from Transfer from Transfer from Transfer from Transfer from Transfer from Transfer Transfer Transfer Transfer Transfer Sales Tax Const to Transit Fund Sales Tax Const to Transit Fund Sales Tax Const to Transit Fund Sales Tax Const to Transit Fund General Fund to Sanitary Sewer Fund General Fund to Sanitary Sewer Fund Spec. Assessment Fd to Sewer Const Fund Spec. Assessment Fd to Sewer Const Fund Spec. Assessment Fd to Sewer Const Fund Spec. Assessment Fd to Sewer Const Fund Spec. Assessment Fd to Sewer Const Fund Spec. Assessment Fd to Sewer Const Fund From Sales Tax 20% Fd From Sales Tax 20% Fd from Spec. Assessment from Spec. Assessment from Spec. Assessment to Stormwater Const. Fund to Stormwater Const. Fund Fund to Street Const Fund to Street Const Fund to Street Const Page 22 (890) 153 50,000 10,000 164,970 7,138 14,694 134,305 54,000 80,210 2,015,695 84,353 358,173 20,400 30,000 28,498 110,000 124,000 307,000 13,800 102,748 212,000 100 9,800 100 101 153 350 240 50,000 360 210 10,000 360 210 164,970 360 370 7,138 100 440 14,694 350 391 134,305 390 102 54,000 390 391 80,210 390 391 2,015,695 390 252 84,353 390 252 358,173 390 350 20,400 600 350 30,000 600 28,498 710 101 255 110,000 710 255 124,000 710 255 307,000 710 350 13,800 720 255 102,748 300 255 10011100 10030500 10110101 3501048 24060240 3601105 21060210 3601774 21060210 3602158 37010370 10034250 44010440 3501530 39110391 3901891 10210102 3901893 39110391 3902009 39110391 3902213 25210252 3902213 25210252 3902316 35010350 6002045 35010350 6002235 7101067 10110101 25510255 7101301 25510255 7101336 25510255 7102130 35010350 7201666 25510255 3001972 25510255 62761 59240 91350 59101 91360 59240 91360 59210 91360 59210 91100 59370 91350 59440 91390 59391 91390 59102 91390 59391 91390 59391 91390 59252 91390 59252 91600 59350 91600 59350 59101 91710 91710 59255 91710 59255 91710 59255 91720 59350 91300 59255 91300 C/O - Prespend FY14 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 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 FISCAL YEAR 2014 AMENDMENT #1 CITY COUNCIL Department Program Description FY 14 Expense Amount FY 14 Revenue Amount Fund Activity /CIP Account Explanation 14- Aug -13 GENERAL FUND, Police Departmen Engineering Engineering Engineering Engineering Engineering Planning Services Planning Services Planning Services Planning Services Sustainability Sustainability Police Department Police Department Police Department Police Department 1 Trans21 Trans22 Trans22 Trans23 Trans23 Trans24 Trans24 Trans25 Trans25 Trans26 Trans26 Trans26 Trans26 Trans27 Trans27 Pay to Other Agency Transfer from Transfer from Transfer from Transfer from Transfer from Transfer from Transfer from Transfer from Transfer from Transfer from Transfer from Spec. Assessment Fund to Street Const Spec. Assessment Fund to Street Const. Fund Spec. Assessment Fund to Street Const. Fund General Fund to America's River Fund General Fund to America's River Fund GDTIF to General Construction GDTIF to General Construction GDTIF to General Construction GDTIF to General Construction Refuse Fund to General Fund Refuse Fund to General Fund Transfer from Sales Tax Const to General Fund Transfer from Sales Tax Const to General Fund Transfer from DRA Gaming to General Fund Transfer from DRA Gaming to General Fund TOTAL TRANSFERS ENCUMBRANCE C /O's Back out Non Budgeted Encumb Rollovers Total Amend #1 with Enc, C /O's, and New (890) 49,222 127,258 25,000 10,000 28,912 100,371 65,989 4,338, 689 212,000 49,222 127,258 25,000 10,000 28,912 100,371 65,989 4,338,689 116,223,630 27,644,706 (824,871) 143,043,465 96,047, 367 96,047,367 Page 23 100 300 255 300 100 700 240 360 240 360 670 100 350 100 101 100 10011100 3002139 25510255 3002141 10010100 7001853 24060240 3601015 24060240 3601015 67054100 10072200 35010350 1001120 10110101 1001120 62761 59255 91300 59255 91700 59100 91360 59240 91360 59240 91100 59670 91100 59350 91100 59101 C/O - Prespend FY14 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 Nov e7 NOTICE OF PUBLIC HEARING Fonns53.ct AMENDMENT OF CURRENT CITY BUDGET The City Council of ! Dubuque in DUBUQUE County, Iowa will meet at City Council Chambers at the Historic Federal Building at 6:30 p.m. on 09103/2013 (how) (Date) for the purpose of amending the current budget of the city for the fiscal year ending June 30 2014 vear4 by changing estimates of revenue and expenditure appropriations in the fo lowing functions for the reasons given. Additional detail is available at the city clerk's office showing revenues and expenditures by fund type and by activity. Total Budget as certified or last amended Current Amendment Total Budget after Current Amendment Revenues & Other Financing Sources ; 23,197,623 23,197,623 Taxes Levied on Property 1 Less: Uncollected Property Taxes-Le vyYear 2 0 Net Current Property Taxes 3 23,197,623 0 23,137,623 Delinquent Property Taxes 4 0 TIF Revenues 5 9,752,170 9,752,170 Other City Taxes s 1'5,560,397 15,560,397 Licenses & Permits 7 1,368,930 1,368,930 Use of Money and Property B 14,021,131 143,000 14,164,131 intergovernmental 9 32,651,928 38,271,207 70,923,135 Charges forServices 10 35,954,213 102,615 36,056,828 Special Assessments 11 55,038 904,970 960,008 Miscellaneous 12 7,874,906 2,961,746 10,836,652 other Financing Sources 13 26,950,892 49,325,140 76,276,032 Total Revenues and other sources '14 167,387,228 91,708;678 259,095,906 Extaenditures & Other Financing Uses 27 5,83 624,393 27,740,226 Public Safety 15 Public Works 15 12,223,715 548,316 12,772,031 Health and Social Services 17 998,450 202,364 1,200,814 Culture and Recreation 18 10,916,031 547,564 11,463,595 Community and Economic Development 19 13 343,613 423;201 13,766,814 General Government- 20 7,472,570 303,787 7,776,357 Debt Service 21 7,613,632 0 7,613,632 Capital Projects 22 25,588,595 58,864,545 84,453,140 Total' Government Activities Expenditures 23 105,272,439 61,514,170 166,786,609 Business Type l Enterprises 24 43,723,844 148,996,283 77,190,606 138,704,776 120,914,450 287,701,059 Total Gov Activities & Business Expenditures 25 Transfers Out 2 20,747,941 4,338,689 25,086,630 Total Expenditures!Transfers Out 27 169,744,224 143,043465 312,787 689 Excess Revenues & OFher5ources Over (Under) Expenditures /Transfers Otit Fiscal Year 28 .... . ...... .. 2 356,99 . :•. ... 51 334787 53 ,691,783 Beginning Fund Balance Jury 1 30 25,076,317 51,334,787 76,411,104 Ending Fund Balance June 30 31 22,719,321 0 22,719,321 Explanation of increases or decreases in revenue estimates appropriations or available cash This amendment adds the capital budget carryovers of 5108,808,494 & associated revenue of 588,166,804, & encumbrance carryovers of $26,819,835 (continuing appropriation authority,not requiring formal amendment/ for reporting purposes only). Adds operating budget carryovers of 91,232,984 & associated revenue of $1,688,429, requiring a formal amendment. Also included in this amendment is $1,843,463 in new expense & associated revenue of $1,853,445 due to new funding sources. Interfund transfers of $4,338,689 are included. There will be no increase in tax levies to be paid in the current fiscal year named above. Any increase in expenditures set out above will be met from the increased non - property tax revenues and cash balances not budgeted or considered in this current budget, This will provide for a balanced budget ' iy City Clerk/ Finance 0 €ricer wane it 8/23 552387- 0IA(8 -23: 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: August 23, 2013, and for which the charge is $160.55. Subscribed to before me, a Notary Public in and for Dubuque County, Iowa, this day of , 20 /, Notary Public in and for Dubuque County, Iowa.