The URL can be used to link to this page

Fiscal Year 2012 First Budget AmendmentMasterpiece on the Mississippi TO: FROM: SUBJECT: August 30, 2011 The Honorable Mayor and City Council Members Michael C. Van Milligen, City Manager Fiscal Year 2012 First Budget Amendment Budget Director Jennifer Larson is recommending the first Fiscal Year Amendment be set for public hearing for September 19, 2011. I concur with the recommendation and respectfully request Mayor and approval. Dubuque bitil All-America City 1 2007 2012 Budget City Council Michas( C. Van Milligen MCVM /jml Attachment cc: Barry Lindahl, City Attorney Cindy Steinhauser, Assistant City Manager Jennifer Larson, Budget Director Masterpiece on the Mississippi August 30, 2011 TO: Michael C. Van Milligen, City Manager FROM: Jennifer Larson, Budget Director SUBJECT: Fiscal Year 2012 First Budget Amendment Dubuque Itztrd All- AmedcaCity I'll! 2007 The purpose of this memorandum is to provide an explanation regarding the first amendment for Fiscal Year 2012. This amendment is two fold. First, it amends the Fiscal Year 2012 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 2011 budget carryovers to Fiscal Year 2012 of encumbrances totaling $41,730,906, capital projects totaling $65,395,750 that were not completed during the prior Fiscal Year, and associated revenues totaling $78,362,041. There are operating budget appropriation carryovers of $1,539,636 and operating receivables of $4,471,357. Also, total transfers between funds of $6,865,744 are reflected. CARRYOVER AMENDMENT TO FISCAL YEAR 2012 During Fiscal Year 2012, a large number of projects were completed, which include Police Administration Office Remodel, Police Handgun Replacement, Police Tactical Deployment Vehicle, Fire Pumper Replacement, Fire Headquarters New Bay Addition, Fire Station #4 Exterior Improvements, Fire Gear Cleaning Equipment, Playground Improvements, Highway 20 Landscape Design, Northwest Arterial Hike /Bike Trail Phase I & II, Flora Park Storm Sewer Extension, Renovate Park Sidewalks, Park Maintenance Headquarters Boiler, Bergfeld Trail Extension, Eagle Point Park Storm Sewer Work, Grandview /Rockdale Park Development, Ham House Cupola Roof Repair, McAleece Parking Lot Asphalting, Comiskey Park Lighting, EB Lyons Expansion and Exhibits, Five Flags Replacement of Portable Chairs and Tables, Five Flags Concert Lighting, Five Flags Dasher Boards, Five Flags Espresso Machine and Kiosk, Five Flags Pipe and Drain, Five Flags Meeting Room AV Equipment, Five Flags Floor Scrubber, Grand River Center Paint Meeting Rooms, Grand River Center Replace Furniture, Grand River Center Replace Fabric Wall Covering, Grand River Center Replace Carpeting, Flora and Sutton Pools Water Playground Repairs, Flora and Sutton Pools Replace Lockers, Flora Pool New Sand Playground, Flora and Sutton Pools Repair Building Roofs, Flora and Sutton Pools Paint Tanks, Bunker Hill Golf Course Irrigation, Library Renovation, Library Tuckpointing, Water Main Replacements, Fire Hydrant Replacements, Water Annual Tank Inspections, Water Circulation System Potable, Water Replace #6 Well House Roof, Water Resource and Recovery Plant Rebuild Centrifuge Scroll, Central Avenue Parking Ramp, Re- Lamping Locust Street Ramp, Re- Lamping 5th Street Ramp, Airport New T- Hangars, Airport Runway Safety Area, Airport Terminal Land Acquisition, Airport Asphalt parking Lots, Airport Runway Painting, Public Works Asphalt Milling Program, Public Works Motor Grader Replacement, Public Works Loader - Mounted Snow Blower, Public Works Liquid Deicer Blender System, Public Works HESCO Flood Control Units, Public Works Flood Control Levee Certification, Keyway Channel and Culvert Improvements, Keyway /Rosemont Channel Improvements, Lower Bee Branch Bridges, Montrose Steps Reconstruction, Rehabilitation and Relocation of White Water Creek Bridge, Green Alley Pilot Project, Heeb Street Retaining Wall, Cooper Retaining Wall, Sunset Ridge Reconstruction, Central Avenue Pavement Rehabilitation Phase I, Northwest Arterial Capacity Improvements, Pavement Marking, US 52 /Central Traffic Improvements, North Siegert Farm Grading, and 40 Main Landscaping. Many other enhancements are reflected throughout the community. Some significant projects were started and remain in process, which are carried forward into Fiscal Year 2012. The most significant of the capital project expenditure carryovers, including associated revenue, are: Southwest Arterial ($9,549,333 ); Historic Millwork District Complete Streets ($4,404,579 ); Iowa Finance Authority Downtown Loan Pool ($4,350,000 ); Airport Terminal Sitework ($3,794,911); Airport Terminal Runway 31 Parallel ($3,429,872 ); Airport Terminal Utility Improvements ($2,570,120 ); Downtown Housing Incentives ($2,095,894); Historic Millwork District Parking ($1,593,411); Transient Boat Docks ($2,006,972); Bee Branch Creek Restoration ($1,354,045); Central Avenue Parking Ramp ($1,002,484); 18th Street Building Improvements ($1,049,425); Jule Bus Replacements ($1,559,908 ); Brunskill Road Bridge Replacement ($979,927); US 61/151 Corridor ($784,062); Recycling Vehicles ($737,647); Airport Terminal Water Reservoir ($677,728); North Siegert Farm Development ($646,077); Intermodel Facility ($621,728); Fire Station Expansion /Relocation ($603,059); Port of Dubuque Outdoor Plaza ($600,000); Replace Police /CAD Software ($600,000); Homeownership Rehabilitation ($546,272); Kaufmann Avenue Resurfacing ($501,212); Greater Downtown TIF Loans ($487,733); Design South Siegert Farm ($469,530); Rivers to the Sea Exhibit ($392,910); Homeownership Grants in Targeted Neighborhoods ($329,182); Cedar Cross Reconstruction ($307,507); Bus Stop Improvements — ARC Transfer Station ($298,357); Sanitary Sewer Improvements ($6,106,533); Water Improvements ($1,869,474); Stormwater Improvements ($1,482,074 ); and Community Development Block Grant funded projects ($618,068). OPERATING BUDGET CARRYOVER AMENDMENT The most significant operating budget carryovers into Fiscal Year 2012 include such items as Water Resource and Recovery Plant Consent Decree ($370,000); Federal Building Property Maintenance ($103,578); Police Department Training ($94,560); Police Department Grants ($290,970; Section 8 Voucher Software ($33,775); Housing Administration Every Child Every Promise Grants ($80,000); Human Rights Grant Appropriation ($94,595); Airport Radar Maintenance Fee ($50,000); and Community Development Block Grant ($23,175). FIRST AMENDMENT TO THE FISCAL YEAR 2012 CERTIFIED BUDGET There have been numerous actions by City Council and changes requiring amendments for -2- the Fiscal Year 2012 budget. The capital budget amendments total $9,186,292, with an increase in associated revenue of $9,460,064. The amendment items include: Community Development Block Grant for the Caradco Project in the Historic Millwork District ($8,892,500); Housing Trust Grants ($157,250) funded by Iowa Finance Authority Housing Trust Grant; and Smoke Detectors and Fire Extinguishers Training Program ($65,792) funded by a Fire Prevention Grant. OPERATING BUDGET AMENDMENT The operating budget amendments total $110,877, with associated increase in revenue of $140,677. The amendment items include extension of the ICMA Fellow contract thru June 30, 2012 ($25,714); Police JAG Stimulus Grant ($59,197); and Fire Radio Access Fees ($15,932). In addition, the Library reorganized their Technical Services department creating an overall savings of $14,497 in FY 2012. This amendment includes increasing the Full -Time Equivalents in Technical Services by adding an Intern ( +0.50 FTE or 1,044 hours annually) with a cost of $13,893 which will be covered by the savings of the reorganization of staff in Technical Services. The action step is for City Council to adopt the attached resolution setting the public hearing date for the formal budget amendment process as required by Section 384.16 of the Code of Iowa. The attached resolution authorizes the City Clerk to publish notification for a public hearing to be held September 19, 2011. Attachments JML 3 RESOLUTION NO. 301 -11 SETTING THE DATE FOR THE PUBLIC HEARING ON AMENDMENT NO. 1 TO THE FISCAL YEAR 2012 BUDGET FOR THE CITY OF DUBUQUE Whereas, Iowa Code Section 384.16 provides that the City Council shall set a time and place for a public hearing on amendments to the budget and publish notice before the hearing as provided in Iowa Code Section 362.3. NOW THEREFORE, BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF DUBUQUE, IOWA: Section 1. That the City Council shall conduct a public hearing on proposed Amendment No. 1 to the Fiscal Year 2012 budget for the City of Dubuque at the City Council Chambers at the Historic Federal Building, 350 West 6th Street, Dubuque, Iowa, on Monday, September 19, 2011, beginning at 6:30 p.m. Section 2. That the City Clerk be and is hereby authorized and directed to publish notice of the public hearing, according to law, together with the required budget information. Passed, approved and adopted this 6th day of September 2011. Attest: Ke in Firnsta , City Cler DL/ Roy D. ' ol, Mayor Nov -07 Form 653 Cl NOTICE OF PUBLIC HEARING 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 09/19/2011 (hour) (Date) ,for the purpose of amending the current budget of the city for the fiscal year ending June 30, 2012 Near by changing estimates of revenue and expenditure appropriations in the following functions for the reasons given. Additional detail is available at the city clerk's office showing revenues and expenditures by fund type and by activity. Explanation of increases or decreases in revenue estimates, appropriations, or available cash: This amendment adds the capital budget carryovers of $65,395,750 & its associated revenue of $78,362,041, & encumbrance carryovers of $41,730,906 (continuing appropriation authority,not requiring formal amendment/ for reporting purposes only). It also adds operating budget carryovers of $1,539,636 & its associated revenue of $4,471,357, requiring a formal amendment. Also included in this amendment is $9,297,169 in new expense & associated revenue of $9,600,741 due to new funding sources. Interfund transfers of $6,865,744 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. City Clerk/ Finance Officer Name Total Budget as certified or last amended Current Amendment Total Budget after Current Amendment Revenues & Other Financing Sources 20,559,847 20,559,847 Taxes Levied on Property 1 Less: Uncollectted Property Taxes -Levy Year 2 0 Net Current Property Taxes 3 20,559,847 0 20,559,847 Delinquent Property Taxes 4 0 TIF Revenues 5 10,151,097 10,151,097 Other City Taxes 6 14,904,342 14,904,342 Licenses & Permits 7 1,254,672 1,254,672 Use of Money and Property 8 12,639,846 135,000 12,774,846 Intergovernmental 9 33,190,214 60,110,019 93,300,233 Charges for Services 10 32,758,317 81,480 32,839,797 Special Assessments 11 244,100 197,000 441,100 Miscellaneous 12 6,556,190 1,634,709 8,190,899 Other Financing Sources 13 66,978,000 37,141,675 104,119,675 Total Revenues and Other Sources 14 199,236,625 99,299,883 298,536,508 Expenditures & Other Financing Uses 24,073,368 616,997 24,690,365 Public Safety 15 Public Works 16 11,669,809 368,554 12,038,363 Health and Social Services 17 914,521 105,983 1,020,504 Culture and Recreation 18 9,891,483 107,623 9,999,106 Community and Economic Development 19 13,006,091 342,906 13,348,997 General Government 20 6,912,736 233,650 7,146,386 Debt Service 21 7,019,294 0 7,019,294 Capital Projects 22 32,035,166 77,624,991 109,660,157 Total Government Activities Expenditures 23 105,522,468 79,400,704 184,923,172 Business Type /Enterprises 24 76,139,146 38,562,757 114,701,903 Total Gov Activities & Business Expenditures 25 181,661,614 117,963,461 299,625,075 Transfers Out 26 21,147,963 6,865,744 28,013,707 Total Expenditures /Transfers Out 27 202,809,577 124,829,205 327,638,782 Excess Revenues & Other Sources Over (Under) Expenditures /Transfers Out Fiscal Year 28 - 3,572,952 - 25,529,322 - 29,102,274 Continuing Appropriation 29 N/A 0 Beginning Fund Balance July 1 30 22,846,457 16,872,124 39,718,581 Ending Fund Balance June 30 31 19,273,505 - 8,657,198 10,616,307 Explanation of increases or decreases in revenue estimates, appropriations, or available cash: This amendment adds the capital budget carryovers of $65,395,750 & its associated revenue of $78,362,041, & encumbrance carryovers of $41,730,906 (continuing appropriation authority,not requiring formal amendment/ for reporting purposes only). It also adds operating budget carryovers of $1,539,636 & its associated revenue of $4,471,357, requiring a formal amendment. Also included in this amendment is $9,297,169 in new expense & associated revenue of $9,600,741 due to new funding sources. Interfund transfers of $6,865,744 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. City Clerk/ Finance Officer Name FISCAL YEAR 2012 AMENDMENT #1 CITY COUNCIL Department Program Description 30- Aug - l 1 FY 12 FY 12 Expense Revenue Amount Amount Fund Activity/CIP Account Explanation GENERAL FUND Police Departmei 1C Replace Police /CAD Software 600,000 102 1021167 71123 C/O Police Departmei 1C Replace Police /CAD Software - County Reimbursement 400,000 102 1021167 53102 C/O Police Departmei 1C Police Wireless Data Trans System - Computer Peripherals 9,833 101 1012092 71120 C/O Police Departmei 1C Police Wireless Data Trans System - Consulting 10,500 101 1012092 62712 C/O Police Departmei 1C Restore Police Car - Private Contributions 10,613 100 1002280 62528 C/O Police Departmet 1 Target Crime Prevention Grant 1,750 100 10011760 62671 C/O Police Departmei 1 2009 Justice Assistance Grant - Reimb OT 3,076 100 10011775 61051 C/O Police Departmei 1 2009 Justice Assistance Grant- Misc Op Supplies 2,257 100 10011775 62671 C/O Police Departmei 1 2009 Justice Assistance Stimulus Grant - Reimbursable OT 100,459 100 10011740 61051 C/O Police Departmei 1 2009 Justice Assistance Stimulus Grant - Misc Op Supplies 78,853 100 10011740 62671 C/O Police Departmei I 2009 Justice Assistance Stimulus Grant - Misc Op Supplies 3,000 100 10011740 62671 C/O Police Departmei 1 2009 Justice Assistance Stimulus Grant - Special Equip 11,888 100 10011740 72218 C/O Police Departmei 1 2010 Justice Assistance Grant- Misc Op Supplies 12,897 100 10011776 62671 C/O Police Departmei 1 2010 Justice Assistance Stimulus Grant - Reimbursable OT 16,586 100 10011776 61051 C/O Police Departmei 1 2010 Justice Assistance Stimulus Grant - Special Equip 34,883 100 10011776 72218 C/O Police Departmei 1 Police Training - Training 46,539 100 10011250 62360 CIO Police Departmei 1 Police Patrol - Training 48,021 100 10011700 62360 C/O Police Departmei 1 Community Policing - Training 2,263 100 10011500 62360 C/O Police Departmei 1 Police Patrol - Police Honor Guard Dress Jackets 1,680 100 10011700 62011 C/O Police Departmet 1 Police Patrol - Radio/Pager Fees 23,534 100 10011700 62424 C/O Police Departmei 1 Police Patrol - Maintenance Outsourced 6,000 100 10011700 62528 C/O Police Departmei I Bulletproof Vest Grant 3,340 100 10011703 72213 C/O Police Departmei 1 Bulletproof Vest Grant 2,132 100 10011703 44125 C/O Police Departmei 1 2009 Meth Hot Spots Grant 153 100 10011319 45771 C/O Police Departmei 1 JAG Stimulus Grant 13,699 100 10011320 44176 C/O Police Departmei 1 JAG Stimulus Grant 13,699 100 10011320 61051 C/O Police Departmei 1 JAG Stimulus Grant 59,197 100 10011320 44176 New Grant Police Departmei 1 JAG Stimulus Grant 59,197 100 10011320 61051 New Grant Appropriation Police Departmei 1 Helping Services of IA Grant - Underage Alcohol - Reimb OT 2,890 100 10011324 61051 C/O Police Departmei 1 Helping Services of IA Grant - Underage Alcohol - Grant 2,890 100 10011324 45771 C/O Police Departmei 1 FY10 Traffic Service Grant 5,258 100 10011772 44125 C/O Police Departmei 1 FY10 Traffic Service Grant 3,152 100 10011772 61051 C/O Police Departmei 1 Domestic Abuse Grant- Reimb OT 2,240 100 10011754 61051 C/O Police Departmei 1 Domestic Abuse Grant - Federal Grant 1,427 100 10011754 44135 C/O Fire Department IC Pumper Replacement 147 100 1001016 71318 C/O Fire Department 1C Intersection Preemption - Equipment Acquisition 14,557 101 1011023 73410 C/O Fire Department 1C Smoke Detectors/Fire Extinguishers - Prevention Grant 54,814 101 1012345 44170 New Grant Fire Department IC Smoke Detectors/Fire Extinguishers - Safety Equipment 65,792 101 1012345 72116 New Grant Appropriation Fire Department 1 Fire Suppression - Radio Access Fees 5,113 100 10013400 62424 Radio Access Fees Fire Department IC Station #4 Improvements - Landscaping 3,500 101 1011460 73210 C/O Fire Department I Fire Suppression - Radio Access Fees 10,819 100 10013400 62424 Radio Access Fees Fire Department 1C Fire Station Expansion/Relocation 650,000 101 1011864 54205 C/O Fire Department I C Fire Station Expansion/Relocation 603,059 101 1011864 73211 C/O Page 1 FISCAL YEAR 2012 AMENDMENT #1 CITY COUNCIL Department Human Rights Human Rights Human Rights Human Rights 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 Div Civic Center Div Conference Cent Conference Cent Conference Cent Library Departm( Library Departmt Library Departm Library Departm Library Departmi Library Departm Library Library Program Description 3 Human Rights Grant -Misc Services 3 Human Rights Grant -Fair Housing Training 3 Human Rights Grant - Training & Education 3 Human Rights Grant - Printing & Binding 2C NW Hike/Bike Trail - REAP Grant 4C Miller Riverview Rip Rap 4C Westbrook Park Development - Eng. Division Svcs 4C Westbrook Park Development - Construction 4C BMX Bike Course 4C Dubuque History Trail - Federal Grants 4C Dubuque History Trail - Consulatant Services 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 EPP - Replace Fence - Const Cont - Not Bldg 4C Park Drinking Fountains - Consultant Engineers 4C Greenhouse - Addition - Consulting Engineers 4C Greenhouse - Addition - Const Contr - Bldg 4C Grandview/Rockdale Park Dev - Private Participant 4C EPP - Riverfront Pavilion - Construction 4C EPP - Riverfront Pavilion - Consulting Engineers 2C NW Hike/Bike Trail - REAP Grant 2C NW Hike/Bike Trail - Construction Not Building 4C Dubuque Water Trail - State DNR Grant 4C Dubuque Water Trail - Signage 4C Mines of Spain Exhibit - Federal Grant 4C Mines of Spain Exhibit - Private Participant 4C EB Lyons Expansion - Private Participant 4C EB Lyons Expansion - State Solid Waste Alternative Program 4 Downtown Maintenance - Sweeper - Non Street 4 Greenhouse - Vehicle Replacement 4C Theater - Refurbish Brass - Const Contr -Bldg 4C Five Flags Entryway Renovation - Misc Equipment 6C GRC - Paint Exhibit Hall 6C GRC - Paint Exhibit Hall 6C GRC - Mechanic Room 4 Adult Services - Library Cont/Serials 4 Adult Services - Promotion 4 Adult Services - Audio/Visual 4 Adult Services - Library Video Materials 4 Children Services -Misc Mileage 4 Children Services- Summer Reading Program 4 Children Services - Books 4 Adult Services - Books FY 12 Expense Amount 19,850 34,039 13,431 27,275 90,000 17,000 53,447 4,379 14,850 133,650 20,000 28,673 5,400 10,000 9,957 9,000 85,173 35,856 17,000 21,275 6,000 30,000 27,000 10,000 10,759 5,000 75,000 12,000 2,494 265 445 23 38 (100) 1,843 3,533 Page 2 FY 12 Revenue Amount Fund Activity/CIP Account 100 10016200 62731 100 10016200 62753 100 10016200 62360 100 10016200 62090 20,000 100 1001157 45707 100 1001170 73211 101 1011582 62811 101 1011582 73211 102 1021871 73211 148,500 100 1001956 44170 100 1001956 62716 100 1001956 73411 101 1011983 73211 100 1001987 62712 101 1012078 62716 101 1012096 73211 100 1002101 62712 102 1022104 62712 102 1022104 73210 9,204 100 1002181 53102 102 1022190 73210 102 1022190 62712 20,000 100 1002273 45707 100 1002273 73211 6,000 100 1002277 45701 100 1002277 73411 25,000 100 1002056 44170 25,000 100 1002056 53102 5,876 100 1002171 53102 20,000 100 1002171 45701 100 10030430 71322 100 10030500 71312 102 1022119 73210 101 1012283 71550 100 1002197 62716 100 1002197 73210 100 1002198 73210 100 10036200 62340 100 10036200 62140 100 10036200 62652 100 10036200 62659 100 10036210 62340 100 10036210 62340 100 10036400 62651 100 10036200 62659 30- Aug -11 Explanation C/O Fair Housing Grant Exp C/O Fair Housing Grant Exp C/O Fair Housing Grant Exp C/O Fair Housing Grant Exp C/O C/O C/O C/O CIO 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 CIO 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 FY12 Lost Book Fees Lost Book Fees FISCAL YEAR 2012 AMENDMENT #1 CITY COUNCIL Department Program Description Airport Departmi Airport Departmi Airport Departmi Airport Departmi Airport Departmi Airport Departmi Public Works Public Works Public Works Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Building Service: Building Service: Building Service: Building Service: Building Service: Building Service: Building Service: Economic Devlol Economic Devlol 2C Safety Mgmt Systems Grant - Construction Not Building 2C Safety Mgmt Systems Grant - Safety Mgmt Systems 2C Airport GIS - FAA Funds 2 Airport Administration - Promotion 2 FBO Operation - Promotion 2 Airport Operations - Misc Services 2C Bi- Lingual Trail Signage - Signage 2 Administration - Conferences 2 Administration - Conferences 2C Port of Dubuque - Leasehold Improvements 2C Decorative Concrete Maint - Construction 2C Shot Tower Restoration - Construction 2C Accessibility Barriers - Construction 2C Riverfront Leasehold Improvements - Consultant Services 4C Library Renovation - Construction 4C Library Renovation - Contributions 4C Library Renovation - Sale of Assets - Heade Painting 2C Ice Harbor Maintenance/Dredging 2C Tourism Signage Program - Signage 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 Rivers to the Sea Exhibit - Construction 2C Rivers to the Sea Exhibit - State Grant 2C Transient Docks - Main Channel - Consulting Engineers 2C Riverwalk Security Camera - Camera Related Equipment 2C Street Light Replacement - Construction 2C Fiber Optic Con - Priv & Misc - Eng Division Svc 2C Hempstead Safety Improvements - Private Participation 2C Recon Signals /JFK- Wacker - Eng. Division Services 2C Recon Signals /JFK- Wacker - Construction 2C 5 Points Intersection Signal - Construction 2C Safes Routes to School - Const Contract Not Building 2C Safes Routes to School - Const Contract Not Building 2C Safes Routes to School - IDOT Grant 6C 18th Street Building Improvement - Construction 6C 18th Street Building Improvement - Consultant 6C 18th Street Building Improvement - Office of Energy Independence 6C 18th Street Building Improvement - Health Center Grant 6C Kephart Building - Construction 6C Kephart Building - Alliant Rebate 1 Administration - Conferences 5C Brownfields Grant - Consulting Engineers 5C Port of DBQ- Develop.Standards (Int Write Down) FY12 FY12 Expense Revenue Amount Amount 46,470 24,417 141,599 12,053 5,403 50,000 14,595 (625) (625) (1,000) 33,703 2,714 19,537 12,000 36,871 101,500 25,553 99,986 100,000 600,000 392,910 620,135 24,578 (54) 49,256 19,227 123,843 78,538 27,697 70,750 964,005 85,420 8,676 (100) 3,865 35,353 Page 3 Fund Activity/CIP Account 100 1001969 62712 100 1001969 44105 100 1002282 44105 100 10051100 62140 100 10051200 62140 100 10051400 62731 100 1002169 71227 100 10054100 62310 100 10054100 62310 102 1022330 73211 102 1021630 73211 100 1001854 73211 101 1011034 73210 101 1011053 62716 100 1001141 73210 153,448 100 1001141 53103 253,710 100 1001141 54104 102 1021466 73211 102 1021512 71227 102 1021841 62712 100 1001855 62811 100 1001855 73211 450,000 100 1001855 53102 100 1001856 73210 729,486 100 1001856 45771 101 1011861 62712 100 1001963 72417 101 1011549 73211 102 1021609 73211 55,381 101 1012077 53102 101 1011919 62811 101 1011919 73211 102 1021920 73211 101 1011922 73211 101 1011922 73211 70,750 101 1011922 45701 102 1021975 73210 102 1021975 62712 10,800 102 1021975 44176 169,766 102 1021975 44175 102 1021976 73210 6,500 102 1021976 53620 100 10057100 62731 100 1001111 62712 100 1001207 62764 30 -Aug -11 Explanation C/O C/O C/O C/O C/O C/O C/O C/O - FYI2 Prespend C/O - FY12 Prespend C/O - Prespend FY12 C/O C/O C/O C/O C/O C/O - Pledges Receivable C/O - Heade Painting Receivable C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O C /O- Prespend FY12 C/O C/O - DCSD C/O C/O C/O C/O New Grant Appropriation New Grant C/O C/O C/O C/O C/O C/O C /O- Prespend FY12 C/O C/O FISCAL YEAR 2012 AMENDMENT #1 CITY COUNCIL Department Program Description Economic Devloi Economic Devloi Economic Devloi Economic Devloi Economic Devlol Economic Devloi Housing & Corns Housing & Comr Housing & Comr Housing & Corns Housing & Comr Housing & Corns Housing & Corns Housing & Corns Housing & Corns Housing & Corns Housing & Comr Housing & Comr Housing & Comr Housing & Comr Housing & Comr Housing & Comr Housing & Comr Housing & Corns Housing & Comr Housing & Corns Housing & Corns Housing & Corns Housing & Comr Housing & Corns Housing & Corns Housing & Comr Housing & Coins Housing & Comr Housing & Comr Housing & Comr Housing & Comr Housing & Corns Housing & Corns Housing & Comr Housing & Comr Housing & Comr Housing & Comr Housing & Corns Housing & Comr 5C Port of DBQ- Develop.Standards (Int Write Down) 5C Warehouse Master Planning - Private Participant 5C IFA Downtown Loan Pool - Loan Proceeds SC IFA Downtown Loan Pool - Interest Repayments 5C IFA Downtown Loan Pool - Interest Expense 5C IFA Downtown Loan Pool - Loans to Developers 5C Maint of Vacant/Abandoned - Property Maintenance 5C Maint of Vacant/Abandoned - Property Maintenance 5C Housing Trust - IA Finance - Grants 5C Purchase/Resale /Rehab - Land Acquisition 5C Historic Preservation Revolving Loan 5C Historic Preservation Revolving Loans 5C Homeownership Grants - Target 5C Homeownership Grants - Target 5C Homeless Prevention Grant - Federal Stimulus Grant 5C Homeless Prevention Grant - Pay to Other Agency 5C NBHD Stabilization Grant - Stimulus Fed Pass Thru Grant 5C NBHD Stabilization Grant - Land Acquisition with Improv. 5C IFA I -Jobs Affordable Housing Assist - Ia Finance Authority 5C IFA Housing Trust - Grants 5C Healthy Homes Grant - Federal Grant 5C Healthy Homes Grant - Full -time Employees 5C Healthy Homes Grant - IPERS 5C Healthy Homes Grant - Social Security 5C Healthy Homes Grant - Health Insurance 5C Healthy Homes Grant - Workers Compensation 5C Healthy Homes Grant - Life Insurance 5C Healthy Homes Grant - Office Supplies 5C Healthy Homes Grant - Postage 5C Healthy Homes Grant - Printing & Binding 5C Healthy Homes Grant - Copying & Reproduction 5C Healthy Homes Grant - Legal Notice & Ads 5C Healthy Homes Grant - General Liability Insurance 5C Healthy Homes Grant - Mileage 5C Healthy Homes Grant - Education & Training 5C Healthy Homes Grant - Telephone 5C Healthy Homes Grant - Miscellaneous Services 5C Healthy Homes Grant - Grants 5C Healthy Homes Grant - Computer 5C IFA Our Home Grant - Grants 5C IFA Our Home Grant - Iowa Finance Authority 5C IFA Housing Trust - Grants 5C IFA Housing Trust 11 -19 - Grants 5 Shelter Plus Care Grant - Grant 5 Shelter Plus Care Grant - Administrative Costs FY 12 FY 12 Expense Revenue Amount Amount Fund Activity /CIP Account Explanation 15,000 102 1021207 62764 C/O 15,000 100 1002081 53102 4,350,000 100 1002279 54205 135,000 100 1002279 43105 100 1002279 74112 100 1002279 62764 101 1011002 73210 100 1001002 73210 100 1001021 62765 102 1021231 73111 200,000 100 1001247 54210 100 1001247 62764 101 1011595 62765 102 1021595 62765 146,587 100 1002175 44175 100 1002175 62761 256,090 100 1002180 44176 100 1002180 73111 56,299 100 1002271 45703 100 1002285 62765 347,728 100 1002340 44170 100 1002340 61010 100 1002340 61310 100 1002340 61320 100 1002340 61410 100 1002340 61415 100 1002340 61416 100 1002340 62010 100 1002340 62030 100 1002340 62090 100 1002340 62110 100 1002340 62130 100 1002340 62208 100 1002340 62340 100 1002340 62360 100 1002340 62421 100 1002340 62731 100 1002340 62765 100 1002340 71124 100 1002269 62765 250,000 100 1002269 45703 100 1002270 62765 100 1002270 62765 403,791 100 10061915 44170 100 10061915 61413 135,000 4,350,000 5,055 74,991 16,053 50,000 200,000 329,182 70,000 1,000 153,829 157,250 85,566 13,811 6,546 24,610 2,568 172 400 3,300 1,600 837 14,200 2,350 620 8,265 1,080 17,725 148,750 4,200 250,000 147,677 157,250 10,680 Page 4 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 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 New Grant C/O C/O 30- Aug -11 FISCAL YEAR 2012 AMENDMENT #1 CITY COUNCIL Department Housing & Comr Housing & Corm Housing & Corm Housing & Corm Housing & Corm Housing & Comr Housing & Corm Housing & Conn Housing & Comr Housing & Corns Planning Service: Planning Service: Planning Service: City Council City Manager City Manager City Manager City Manager City Manager City Manager City Manager City Manager City Manager City Manager City Manager City Manager City Manager City Manager City Manager City Manager City Manager City Manager City Manager City Manager City Manager City Manager City Manager City Manager City Manager City Clerk Finance Finance Finance Information Sery Purchase of Sery Program Description 5 Shelter Plus Care Grant - Housing Assistance Payments 5 Housing Administration - Consultant Services 5 Washington Neighborhood Development - Pay to Other Agency 5 Neighborhood Stabilization - Admin Wages 6 Federal Building Maintenance - Property Maintenance 5 Bridges Out of Poverty - Training 5 Getting Ahead - Training 5 Circles Coach - Wages 5 Circles Coach - Training 5 General Rehab Homeowner Escrow 5C Historic District Improvements - Construction 5C Historic District Improvements - Construction 5C Annexation Study /Implementation - Consultant Services 6 Sister City - Travel 6C GIS Implementation - Consultant Services 6C GIS Enhancements - Peripherals, Computer 6C City of Dbq 175th Birthday 6C Americas River Fest Equip 6C GIS Training 6C Sustainability Initiative - Consultant Services 6C Electric PILOT Program Power Fund Grant 6C Climate Showcase Grant - Consultant Services 6C Climate Showcase Grant - Full -time Employees 6C Climate Showcase Grant - Office Supplies 6C Climate Showcase Grant - Printing 6C Climate Showcase Grant - Conferences 6C Climate Showcase Grant - Federal Grants 6C EECBG Grant - Grants 6C Climate Showcase Grant - Federal Grants 6C Marketing Grant - Vision Iowa 6 Sustainability - Dues & Memberships 6 Budget - Education & Training - NCDA Grant 6 Arts & Cultural Affairs - Consultant Services 6 Spirit Expense - Watches 6 Administration - Full -time Employee 6 Administration - Social Security 6 Administration - IPERS 6 Administration - Health Insurance 6 Administration - Life Insurance 6 Administration - Education & Training 6C Finance Plus Upgrade - Software 6C Optiosoftware Upgrade - Software 6C Software Upgrade E -Gov - Software 6 COGNOS upgrade & Pentamation Server 6 Burlington Trailways Lease FY 12 FY 12 Expense Revenue Amount Amount Fund Activity/CIP Account Explanation 21,138 100 10061915 62694 80,000 100 10061100 62761 30,000 100 10061125 62761 10,028 100 10061130 61010 103,578 100 10061150 62431 1,817 100 10061920 62320 6,055 100 10061921 62320 7,146 100 10061922 61020 2,497 100 10061922 62320 1,967 100 10061300 62211 34,075 100 1001010 62711 85,873 102 1021010 73210 30,881 102 1021012 62716 3,241 100 10070100 62662 1,852 100 1001070 62716 3,082 102 1021946 71120 4,810 100 1001948 62734 14,587 100 1002050 72115 7,760 100 1002165 62360 22,642 102 1022218 62716 525,000 100 1002272 45701 383,690 100 1002334 62716 68,000 100 1002334 61010 1,500 100 1002334 62010 12,000 100 1002334 62090 2,432 100 1002334 62310 473,136 100 1002334 44170 212,563 100 1002338 62716 227,005 100 1002338 44175 5,000 100 1002275 45761 (274) 100 10072200 62190 1,500 100 10072400 62360 5,214 100 10072500 62761 2,295 100 10072100 62756 18,190 100 10072100 61010 1,391 100 10072100 61320 1,467 100 10072100 61310 4,620 100 10072100 61410 46 100 10072100 61415 (175) 100 10073100 62360 4,500 100 1002166 71123 3,065 100 1002216 71123 11,600 100 1002217 71123 37,572 100 1002342 71125 4,000 100 10079195 62761 Page 5 30- Aug -11 C/O C/O - Every Child/Every Promise C/O -WNDC C/O C/O C/O C/O C/O C/O C/O CDBG Funds 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 Increase Mgmt Fellow Hours Increase Mgmt Fellow Hours Increase Mgmt Fellow Hours Increase Mgmt Fellow Hours Increase Mgmt Fellow Hours C /O- Prespend FY12 C/O C/O C/O C/O C/O FISCAL YEAR 2012 AMENDMENT #1 CITY COUNCIL Department Program Description TOTAL GENERAL FUND TRANSIT FUND Transit Division 8C Transit Division 8C Transit Division 8C Transit Division 8C Transit Division 8C Transit Division 8C Transit Division 8C Transit Division 8C Transit Division 8C Transit Division 8C Transit Division 8C Transit Division 8C Transit Division 8 Replace Fixed Route Buses - State of Good Repair Grant Replace Mini Buses - Bus Replacements Replace Mini Buses - Clean Fuels Grant Replace Mini Buses - Capital Investment Assist Project Intermodel Feasibility Study - Consultant Services Intermodel Feasibility Study - State Grants Intermodel Feasibility Study - FTA Capital Intermodel Feasibility Study - FTA Capital Bus Stop Improvements - ARC Transfer Station Bus Stop Improvements - Public Transportation Infrast. Grant Transit Mobile Data Termininals - Computer Transit Mobile Data Termininals - Illinois ARRA Grant Transit Admin - FTA Operating TOTAL TRANSIT FUND GREATER DOWNTOWN TIF - TIF FUND Economic Devlol 5C Downtown Rehab Consultant - Financial Consultant TOTAL GREATER DOWNTOWN TIF - TIF FUND DOWNTOWN LOAN POOL - TIF FUND Economic Devlol 5C Loan Pool, Downtown TIF - Loans Economic Devlol 5C Downtown Rehab Grant Program TOTAL DOWNTOWN LOAN POOL -TIF FUND ROAD USE TAX FUND Public Works 2C Public Works 2 Public Works 2 Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Loader - Mounted Snow Blower Street Maintenance - Signage Street Maintenance - Equipment Stone Retaining Walls - Construction Not Building Brunskill Rd Bridge Repl - Eng Division Sery Brunskill Rd Bridge Repl - Construction Railroad Cross Improvement - Construction Signalization Program -Eng Division Sery Fiber Optic Conduit Project - Construction Traffic Signal Coordination - Right of Way Acquisition Traffic Signal Coordination - Consulting Engineers Traffic Signal Coordination - Right of Way Acquisition Traffic Signal Coordination - Consulting Engineers Traffic Controller Replacement - Equip Acquisition NW Arterial Capacity Imp - State Grant - ICAAP Traffic Consultant Sery - Consulting Engineers Traffic Signal Video Detection - Construction FY 12 FY 12 Expense Revenue Amount Amount 14,016, 718 10,925,643 938,180 621 ,728 298,357 414 1,858,679 20,000 20,000 487,733 4,467 492,200 434 22,250 (5,433) 2,107 46,986 126,105 14,368 3,519 72,299 (44,316) (55,684) 44,316 63,630 7,319 (180,000) 1,951 Page 6 Fund Activity/CIP Account Explanation 2,300,000 600 6001224 44150 600 6001222 73411 1,500,000 600 6001222 44150 426,620 600 6001222 45701 600 6001614 62716 226,938 600 6001614 45701 150,000 600 6001614 44150 237,500 600 6001614 44150 600 6002235 73210 298,357 600 6002235 45701 600 6002237 71124 44,137 600 6002237 45723 409,348 600 60053100 44160 5,592,900 C/O C/O C/O C/O C/O C/O C/O New Grant C/O C/O C/O C/O C/O - FTA 240 2402157 62721 C/O 241 2411033 241 2411942 62764 C/O 62765 C/O 250 2502220 71616 250 25054400 71227 250 25054400 71550 250 2501029 73211 250 2501077 62811 250 2501077 73211 250 2502026 73211 250 2501011 62811 250 2501017 73211 250 2501228 73113 250 2501228 62712 250 2501228 73113 250 2501228 62712 250 2501274 73410 448,086 250 2501814 45701 250 2501815 62712 250 2501816 73211 C/O C/O C /O- Prespend FY12 C/O C/O C/O C/O C/O C/O Shift to US 61/151 Shift to US 61/151 C/O C/O C/O C/O C /O- Prespend FY12 C/O 30-Aug-11 FISCAL YEAR 2012 AMENDMENT #1 CITY COUNCIL Department Engineering Engineering Engineering Program Description 2C LED Re -Lamp Schedule - Construction 2 Project Engineering - Conferences 2 Project Engineering - Conferences TOTAL ROAD USE TAX FUND SPECIAL ASSESSMENT FUND Engineering 8C Laurel St Sanitary Sewer - Special Assessments TOTAL SPECIAL ASSESSMENT FUND COMMUNITY DEVELOPMENT BLOCK GRANT FUND Engineering 2C Accessible Curb Ramps - Construction Engineering 5C Neighborhood Infrastructure Improvements - Construction Building Service: 6C Kephart Building Improvement - Construction Economic Develc 5C CommerciaLIndustrial Rehab Loan - CDBG Economic Develc 5C Commercial /Industrial Rehab Loan - CDBG Housing & Comr 5C Homeownership Rehab Program -Loans Housing & Comr 5C Purchase/Resale /Rehab - Construction Housing & Comr 5C Lead Paint Abatement Program - Loans Housing & Conu 5C Rental Rehab - Loans Housing & Comr 5C First Time Homebuyer Program -Loans Housing & Comr 5C Historic Preservation Rehab Grant -Loans Housing & Comr 5 CDBG Admin/Monitoring -CD Block Grant Receivable Housing & Corm 5 Housing Rehab Sery & Staff - Education & Training Housing & Conu 5 Housing Rehab Sery & Staff - Software Housing & Comr 5 Housing Rehab Sery & Staff - Software Housing & Comr 5 Housing Code Enforcement - Software License Housing & Comr 5 Housing Code Enforcement - Computers TOTAL CDBG FUND CARADCO COMMUNITY DEVELOPMENT BLOCK GRANT FUND Economic Devlol 5C CDBG Grant - Caradco Economic Devlol 5C CDBG Grant - Caradco - Pay to Other Agency TOTAL CARADCO CDBG FUND UDAG FUND Economic Devlol 5C Economic Devlol 5C Economic Devlol 5C Job Creation - Loans Historic Preservation - Revolving Loans Airport Revenue Guarantee - Pay to Other Agency TOTAL UDAG FUND STATE RENTAL REHAB FUND Housing & Comr 5C Homeownership Rehab Program - Construction Housing & Comr 5C HOME Loan Repayments Housing & Comr 5 LHAP Grant - Loans TOTAL STATE RENTAL REHAB FUND FY 12 Expense Amount 31,815 (313) (1,205) 150,148 FY 12 Revenue Amount 448,086 Fund Activity/CIP Account Explanation 250 2501916 73211 C/O 250 25055400 62310 C /O- Prespend FY12 250 25055400 62310 C /O- Prespend FY12 197,000 255 25510255 52101 Increased Assessments 197,000 64,017 260 2601236 73211 14,213 260 2601239 73211 76,259 260 2601976 73210 70,292 260 2601235 62764 108,218 260 2601746 62764 26,082 260 2601065 62764 36,927 260 2601231 73210 30,001 260 2601232 62764 90,000 260 2601233 62764 95,000 260 2601234 62764 7,059 260 2601237 62764 723,659 260 26061800 44205 260 26061300 62360 260 26061300 71123 260 26061300 71123 260 26061700 62663 260 26061700 71124 2,617 6,826 6,992 1,280 5,460 641,243 723,659 8,892,500 8,892,500 21,480 44,760 150,000 216,240 546,272 9,371 21,430 577,073 C/O CDBG Funds CDBG Amend#1 C/O CD/3G Funds C/O CDBG Funds C/O CDBG Funds C/O CDBG Funds C/O CDBG Funds C/O CDBG Funds C/O CDBG Funds C/O CDBG Funds C/O CDBG Funds C/O CDBG Funds C/O CDBG Funds C/O CDBG Funds C/O CDBG Funds C/O CDBG Funds C/O 30- Aug -11 8,900,000 263 2632341 44205 New CDBG Grant 263 2632341 62761 New CDBG Grant Appropriation 8,900,000 Page 7 265 2651246 265 2651247 265 2651796 270 2701065 270 2701250 270 27061320 62764 C/O 62764 C/O 62761 C/O 73210 C/O 73210 C/O 62764 C/O FISCAL YEAR 2012 AMENDMENT #1 CITY COUNCIL Department Program Description LEAD PAINT GRANT FUND Housing & Comr 5 Lead Paint Abatement Program Housing & Corns 5 Lead Paint Abatement Program Housing & Corns 5 Lead Paint Abatement Program Housing & Comr 5 Lead Paint Abatement Program Housing & Corns 5 Lead Paint Abatement Program Housing & Comr 5 Lead Paint Abatement Program Housing & Corns 5 Lead Paint Abatement Program Housing & Corns 5 Lead Paint Abatement Program Housing & Comr 5 Lead Paint Abatement Program Housing & Comr 5 Lead Paint Abatement Program Housing & Corns 5 Lead Paint Abatement Program Housing & Comr 5 Lead Paint Abatement Program Housing & Corns 5 Lead Paint Abatement Program Housing & Corns 5 Lead Paint Abatement Program Housing & Comr 5 Lead Paint Abatement Program Housing & Corns 5 Lead Paint Abatement Program Housing & Comr 5 Lead Paint Abatement Program Housing & Corns 5 Lead Paint Abatement Program Housing & Corns 5 Lead Paint Abatement Program Housing & Comr 5 Lead Paint Abatement Program Housing & Comi 5 Lead Paint Abatement Program Housing & Corns 5 Lead Paint Abatement Program Housing & Corns 5 Lead Paint Abatement Program Housing & Comr 5 Lead Paint Abatement Program Housing & Corns 5 Lead Paint Abatement Program Housing & Comr 5 Lead Paint Abatement Program Housing & Comr 5 Lead Paint Abatement Program Housing & Corns 5 Lead Paint Abatement Program Housing & Comr 5 Lead Paint Abatement Program Housing & Comr 5 Lead Paint Abatement Program Housing & Comr 5 Lead Paint Abatement Program Housing & Corns 5 Lead Paint Abatement Program Housing & Comr 5 Lead Paint Abatement Program Housing & Corns 5 Lead Paint Abatement Program Housing & Comr 5 Lead Paint Abatement Program Housing & Corns 5 Lead Paint Abatement Program Housing & Comr 5 Lead Paint Abatement Program Housing & Corns 5 Lead Paint Abatement Program Housing & Comr 5 Lead Paint Abatement Program Housing & Comr 5 Lead Paint Abatement Program Housing & Coms 5 Lead Paint Abatement Program Housing & Corns 5 Lead Paint Abatement Program - State Grant -Lead Grant - Homeowner Repayments - State Grant -Lead Grant - Homeowner Repayments - Full -time Employees - Full -time Employees - IPERS - IPERS - SS - SS - Health - Health - Workers' Compensation - Workers' Compensation - Life - Life - Office Supplies - Office Supplies - Postage - Postage - Printing - Printing - Copying - Copying - Legal Notices - Legal Notices - General Liability - General Liability - Conferences - Conferences - Mileage - Mileage - Education & Training - Education & Training - Telephone - Telephone - Rental of Space - Rental of Space - Mach/Equip - Mach/Equip FY 12 Expense Amount (155,224) 155,224 (12,527) 12,527 (11,876) 11,876 (27,720) 27,720 (3,078) 3,078 (310) 310 (910) 910 (4,672) 4,672 (2,100) 2,100 (837) 837 (3,120) 3,120 (2,071) 2,071 (6,160) 6,160 (250) 250 (7,000) 9,870 (2,220) 2,220 (768) 768 (128) 128 Page 8 FY 12 Revenue Amount (4,000) (1,061,839) (23,075) 4,000 1,061,839 23,075 Fund Activity/CIP Account Explanation 275 27561200 45701 Move to new activity 275 27561200 44310 Move to new activity 275 27561200 43410 Move to new activity 275 27561211 45701 Move to new activity 275 27561211 44310 Move to new activity 275 27561211 43410 Move to new activity 275 27561200 61010 Move to new activity 275 27561211 61010 Move to new activity 275 27561200 61310 Move to new activity 275 27561211 61310 Move to new activity 275 27561200 61320 Move to new activity 275 27561211 61320 Move to new activity 275 27561200 61410 Move to new activity 275 27561211 61410 Move to new activity 275 27561200 61415 Move to new activity 275 27561211 61415 Move to new activity 275 27561200 61416 Move to new activity 275 27561211 61416 Move to new activity 275 27561200 62010 Move to new activity 275 27561211 62010 Move to new activity 275 27561200 62030 Move to new activity 275 27561211 62030 Move to new activity 275 27561200 62090 Move to new activity 275 27561211 62090 Move to new activity 275 27561200 62110 Move to new activity 275 27561211 62110 Move to new activity 275 27561200 62130 Move to new activity 275 27561211 62130 Move to new activity 275 27561200 62208 Move to new activity 275 27561211 62208 Move to new activity 275 27561200 62310 Move to new activity 275 27561211 62310 Move to new activity 275 27561200 62340 Move to new activity 275 27561211 62340 Move to new activity 275 27561200 62360 Move to new activity 275 27561211 62360 Move to new activity 275 27561200 62421 Move to new activity 275 27561211 62421 Move to new activity 275 27561200 62436 Move to new activity 275 27561211 62436 Move to new activity 275 27561200 62611 Move to new activity 275 27561211 62611 Move to new activity 30- Aug -11 FISCAL YEAR 2012 AMENDMENT #1 CITY COUNCIL Department Housing & Comr Housing & Comr Housing & Comi Housing & Comr Housing & Comr Housing & Comr Housing & Comr Housing & Comr Housing & Comr Housing & Comr Housing & Comr Housing & Conu Housing & Comr Housing & Comr Program Description 5 Lead Paint Abatement Program - Misc Operating Supplies 5 Lead Paint Abatement Program - Misc Operating Supplies 5 Lead Paint Abatement Program - Legal Services 5 Lead Paint Abatement Program - Legal Services 5 Lead Paint Abatement Program - Dust Wipe Testing 5 Lead Paint Abatement Program - Dust Wipe Testing 5 Lead Paint Abatement Program - Pay to Other Agency 5 Lead Paint Abatement Program - Pay to Other Agency 5 Lead Paint Abatement Program - Grants 5 Lead Paint Abatement Program - Grants 5 Lead Paint Abatement Program - Computer 5 Lead Paint Abatement Program - Computer 5 Lead Paint Abatement Program - Education & Training 5 Lead Paint Abatement Program - Software TOTAL LEAD PAINT GRANT FUND SECTION 8 VOUCHER FUND Housing & Comi 5 MOD Rehab - Housing Assistance Payments Housing & Comr 5 Section 8 Voucher - Software Housing & Comr 5 Section 8 Voucher - Software TOTAL SECTION 8 VOUCHER FUND STREET CONSTRUCTION FUND Public Works 2C Asphalt Milling Program - Construction Not Building Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering 2C Guardrail Replacement - Constuction 2C Stone Retaining Walls - Construction Not Building 2C Brunskill Rd Bridge Repl - Construction 2C Brunskill Rd Bridge Repl - State Grant 2C Bridge Repairs/Maintenance - Construction 2C Southwest Arterial - SAFETEA -LU Final Engineering 2C Southwest Arterial- Final Engineering County Match 2C Southwest Arterial - SAFETEA -LU Property Acquisition 2C Southwest Arterial - Property Acquisition County Match 2C Southwest Arterial - SAFETEA -LU Grade/Pave - North Cascade 2C Southwest Arterial -North Cascade County Match 2C Southwest Arterial - SAFETEA -LU Const Eng - North Cascade 2C Southwest Arterial -North Cascade County Match 2C Southwest Arterial- 2010 Omnibus Funds 2C Southwest Arterial -2009 THUD 2C Southwest Arterial - SAFETEA -LU - Not Obligated 2C Southwest Arterial - Federal Stimulus State Pass Thru Grant 2C Southwest Arterial -Land Acquisitions 2C Southwest Arterial- Right -of -Way Acquisition 2C Southwest Arterial- Construction Not Building 2C White Water Creek Bridge - State Grant FY 12 Expense Amount (799) 799 (1,684) 1,684 (27,018) 27,018 (4,743) 4,743 (811,599) 813,387 (2,100) 2,100 43,867 25,000 73,525 9,790 33,375 400 43,565 FY 12 Revenue Amount Fund Activity/CIP Account 275 27561200 62671 275 27561211 62671 275 27561200 62713 275 27561211 62713 275 27561200 62729 275 27561211 62729 275 27561200 62761 275 27561211 62761 275 27561200 62765 275 27561211 62765 275 27561200 71124 275 27561211 71124 275 27561200 62360 275 27561200 71123 Explanation Move to new activity Move to new activity Move to new activity Move to new activity Move to new activity Move to new activity Move to new activity Move to new activity Move to new activity Move to new activity Move to new activity Move to new activity C/O C/O 280 28061530 62694 C/O 280 28061600 71123 C/O 280 28061600 71123 C/O 5,076 300 3001230 73211 C/O 52,844 300 3001027 73211 C/O 5,000 300 3001029 73211 C/O 806,836 300 3001077 73211 C/O 722,000 300 3001077 45701 C/O 12,303 300 3001258 73211 C/O 5,290,487 300 3001287 45771 C/O 1,015,730 300 3001287 46205 C/O 5,517,429 300 3001287 45771 C/O 840,232 300 3001287 46205 C/O 1,647,290 300 3001287 45771 C/O 164,729 300 3001287 46205 C/O 349,493 300 3001287 45771 C/O 34,949 300 3001287 46205 C/O 950,000 300 3001287 45725 C/O 389,533 300 3001287 45725 C/O 415,862 300 3001287 45771 C/O 10,566 300 3001287 44176 C/O 5,065,000 300 3001287 73110 C/O 3,717,910 300 3001287 73113 C/O 766,423 300 3001287 73113 C/O 22,031 300 3001634 45701 C/O Page 9 30- Aug -11 FISCAL YEAR 2012 AMENDMENT #1 CITY COUNCIL 30 -Aug -11 FY 12 FY 12 Expense Revenue Department Program Description Amount Amount Fund Activity/CIP Account Explanation Engineering 2C White Water Creek Bridge - Private Participant 10,000 300 3001634 53102 C/O Engineering 2C N Cascade Road Reconstruction - Consulting Engineers 24,367 300 3002021 62712 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 US 61/151 Corridor - Const. Contr Not Building 784,062 300 3002028 73211 C/O Engineering 2C US 61/151 Corridor - State Grants 400,000 300 3002028 45701 C/O Engineering 2C US 61/151 Corridor - Federal Pass Thru Grant 354,545 300 3002028 45771 C/O Engineering 2C NW Arterial Capacity Imp - Const. Contr Not Building 58,703 300 3002029 73211 C/O Engineering 2C NW Arterial Capacity Imp - Federal Pass Thru Grant 22,306 300 3002029 45771 C/O Engineering 2C Green Alley Pilot Project 60,315 300 3002044 73211 C/O Engineering 2C Cedar Cross Reconstruction - State Highway Assistance 280,000 300 3002139 45725 C/O Engineering 2C Cedar Cross Reconstruction - Land Acquisition 307,507 300 3002139 73111 C/O Engineering 2C Kaufmann Ave Resurfacing - Fed Pass thru State Grant 480,000 300 3002140 45771 C/O Engineering 2C Kaufmann Ave Resurfacing - Construction Not Building 501,212 300 3002140 73211 C/O Engineering 2C Sunset Ridge Reconstruction 1,414 300 3002141 73211 C/O Engineering 2C Fiber Optic Conduit - Misc - Construction 32,537 300 3002144 73211 C/O Engineering 2C Central Avenue Payment - Construction (625,238) 300 3002248 73211 C/O - Prespend FY12 Engineering 2C Central Avenue Payment - State Highway Assistance 104,805 300 3002248 45725 C/O Engineering 2C N Grandview Estates Road - Construction 214,316 300 3002336 73211 C/O Engineering 2C N Grandview Estates Road - Reimbursements 33,163 300 3002336 53620 C/O Engineering 2C Signalization Program - Equipment Acquisition 45,876 300 3001011 73410 C/O Engineering 2C Fiber Optic Conduit Project - Construction 78,173 300 3001017 73211 C/O Engineering 2C Traffic Signal Masterann Rep. - Construction 25,598 300 3001133 73211 C/O Engineering 2C US 61/151 Corridor - Const. Contr Not Building 100,000 300 3002028 73211 Shift from Traffic Signal Coordination Engineering 2C Traffic Signal Interconnect - Construction Not Building (1,779) 300 3001266 73211 C /O- Prespend FY12 Engineering 2C Street Light Replacement - Construction 29,330 300 3001549 73211 C/O Engineering 2C Pavement Marking (75,000) 300 3002245 73211 C /O- Prespend FY12 Engineering 2C Signal Intersec Reconstruc - Construction 6,431 300 3001615 73211 C/O Engineering 2C Traffic Signal Fiber Optic Net - Construction 61,169 300 3001631 73211 C/O Engineering 2C Traffic Signal Operations Center- Contract 10,997 300 3001852 73510 C/O Engineering 2C Crosswalk Warning Devices 20,000 300 3002246 73211 C/O Engineering 2C SW Arterial - US 20 Cap Imp - Consulting 200,000 300 3002247 62712 C/O Engineering 2C SW Arterial - US 20 Cap Imp - State Grants 100,000 300 3002247 45701 C/O Engineering 2C Street Light/Signal Knockdown - Construction (14,326) 300 3002252 73211 C/O Engineering 2C JFK @ Wacker Signal Reconstruction - Eng. Division Services 10,000 300 3002254 62811 C/O Engineering 2C JFK @ Wacker Signal Reconstruction - Construction 50,000 300 3002254 73211 C/O Engineering 2C Sunset Ridge Lighting - Construction 22,735 300 3002255 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 US 52 /Central Traffic Improvements - Construction 1,474 300 3002274 73211 C/O Engineering 2C ITS Traffic Control Equipment 2,829 300 3002253 73211 C/O TOTAL STREET CONSTRUCTION FUND 12,725,579 19,155,150 SALES TAX FUND (20 %) Parks Division 4C Renovate Park Water System - Consulting 14,578 350 3501158 62712 C/O Page 10 FISCAL YEAR 2012 AMENDMENT #1 CITY COUNCIL Department Program Parks Division 4C Parks Division 4C Parks Division 4C Parks Division 4C Parks Division 4C Civic Center Div 4C Civic Center Div 4C Civic Center Div 4C Civic Center Div 4C Conference Cent 6C Conference Cent 6C Public Works 2C Public Works 2C Public Works 2C Public Works 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Building Service: 6C Building Service: 6C Building Service: 6C Building Service: 6C Building Service: 6C Description Renovate Park Water System - Construction EPP Replace Walkway - Consulting Engineers EPP Replace Walkway - Const Cont - Not Bldg Street Tree Program - Tree Planting Pet Park Terminal Street - Construction Theatre Tuckpoint Exterior - Construction Theatre Tuckpoint Exterior - Consultant Services Step & Aisle Lighting - Construction Meeting Room AV Equip - Video Equip Grand River Center Chairs Grand River Center Level Floors Ice Harbor Gates Timber Floodwall Post Flood Repair - Construction Steps, Railings and Fencing - Construction Not Building Cold Storage Building Mezz - Construction Not Building Stone Retaining Walls - Construction Not Building Curb /Catch Basin Replacement- Construction Decorative Concrete Maint - Construction Sidewalk Financial Assist - Pay to Other Agency Cooper Place Wall - Construction Accessibility Barriers - Construction Riverfront Leasehold Improvements - Consultant Services Rehab Railroad Tracks Ice Harbor Maintenance/Dredging Federal Building Renovation - Construction Transient Docks - Main Channel - Construction Transient Docks - Main Channel - Big Tier Grant Downtown Street Light Replacement - Construction City Hall Remodeling - Construction City Hall Annex Maintenance - Construction Smart Meters - Construction Smart Meters - Consultant General Building Maintenance - Construction TOTAL SALES TAX FUND GENERAL CONSTRUCTION FUND Engineering 2C Millworking District Street - Construction Engineering 2C Millworking District Street - TIGER Grant Engineering 2C Port of Dubuque Ramp - Construction Economic Devlol 5C Industrial Site Development - North Siegert - Construction Economic Devlol 5C Industrial Site Development - North Siegert - RISE Grant Economic Devlol 5C DICW - Wildflowers - Landscaping Contract Economic Devlol 5C DICW - Wildflowers - Consulting Engineers Economic Devlol 5C Design South Siegert Farm - Construction Economic Devlol 5C Design South Siegert Farm - Bond Proceeds FY 12 Expense Amount 37,262 4,400 30,000 6,710 101,000 247,000 2,200 12,562 825 21,000 23.816 58,316 24,768 20,124 42,093 48,616 12,042 105,813 12,451 48,458 13,752 79,507 288,106 15,374 1,386,837 18,248 13,026 26,685 259,345 20,000 20,471 3,015,385 4,404,579 110,748 646,077 154,970 10,000 469,530 FY 12 Revenue Amount Fund Activity/CIP Account 350 3501158 73211 350 3501453 62712 350 3501453 73211 350 3501458 73311 350 3501978 73211 350 3501708 73210 350 3501708 62716 350 3501887 73210 350 3502264 72416 350 3501990 71212 350 3501991 73210 350 3502222 73211 350 3501445 73211 350 3501432 73211 350 3502037 73211 350 3501029 73211 350 3501041 73211 350 3501630 73211 350 3501727 62761 5,500 350 3502088 53102 350 3501034 73210 350 3501053 62716 350 3501465 73211 350 3501466 73211 350 3501841 73210 350 3501861 73211 3,037,802 350 3501861 44170 350 3501608 73211 350 3501045 73210 350 3501757 73210 350 3502259 73210 350 3502259 62712 350 3501428 73210 Page 11 3,043,302 30-Aug-11 Explanation 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 Conrad Reimbursement 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 360 3602137 73211 C/O 4,192,182 360 3602137 44175 C/O 360 3601957 73211 C/O 360 3601943 73211 C/O - Includes Bergfeld Trail 57,736 360 3601943 45741 C/O 360 3602158 73310 C/O 360 3602158 62712 C/O 360 3602160 73211 C/O 370,633 360 3602160 54210 C/O FISCAL YEAR 2012 AMENDMENT #1 CITY COUNCIL 30- Aug -11 FY 12 FY 12 Expense Revenue Department Program Description Amount Amount Fund Activity/CIP Account Explanation Economic Devloi 5C Millwork District Parking Imp - Construction 1,593,411 360 3602250 73211 CIO Economic Devlol 5C 40 Main Landscaping - Landscaping Contract 43 360 3602251 73310 C/O Economic Devlol 5C Downtown Housing Incentive- Pay to Other Agency 2,095,894 360 3602267 62761 C/O TOTAL GENERAL CONSTRUCTION FUND 9,485,252 4,620,551 AIRPORT CONSTRUCTION FUND Airport Departmc 2C New T- Hangar Ramp - Construction 12,000 390 3901690 73211 C/O Airport Departm( 2C Pavement Condition Index -FAA Funds 10,244 390 3901060 44105 C/O Airport Departmc 2C Runway Safety Area -FAA Funds 211,408 390 3901788 44105 C/O Airport Departmc 2C Terminal - Land Acquisition - Relocations 5,000 390 3901795 73112 C/O Airport Departmc 2C Terminal - Land Acquisition - FAA Funds 5,000 390 3901795 44105 C/O Airport Departm( 2C Terminal - RW 31 Parallel - Consulting Engineers 248,100 390 3901891 62712 C/O Airport Departmc 2C Terminal - RW 31 Parallel - Construction 3,181,772 390 3901891 73211 C/O Airport Departmc 2C Terminal - RW 31 Parallel -FAA Funds 3,295,567 390 3901891 44105 C/O Airport Departm( 2C Terminal - Sche /Site Design -FAA Funds 198,595 390 3901892 44105 C/O Airport Departmc 2C Extend Gen'l Aviation Ramp - Consulting Engineers 5,000 390 3901893 62712 C/O Airport Departmc 2C Extend Gen'l Aviation Ramp - Construction 49,000 390 3901893 73211 C/O Airport Departm( 2C Hanger Repairs/Replace - Construction 9,990 390 3902008 73210 C/O Airport Departmt 2C Terminal Sitework - Consulting Engineers 3,794,911 390 3902009 62712 C/O Airport Departm( 2C Terminal Sitework - FAA Funds 3,605,165 390 3902009 44105 C/O Airport Departmc 2C Terminal Utility Improvements - Consulting Engineers 2,570,120 390 3902010 62712 C/O Airport Departmc 2C Terminal Utility Imnprovements - FAA Funds 2,441,614 390 3902010 44105 C/O Airport Departmc 2C Terminal Utility Improvements - State Grants 128,506 390 3902010 45701 C/O Airport Departmc 2C Terminal Water Reservoir - Consulting Engineers 677,728 390 3902011 62712 C/O Airport Departm( 2C Terminal Water Reservoir - FAA Funds 643,842 390 3902011 44105 C/O Airport Departm( 2C FBO Hanger Heating System - Construction 8,093 390 3902123 73210 C/O Airport Departm( 2C Iowa Hanger Heater Replacement - Construction 7 390 3902124 73210 C/O Airport Departmc 2C Paint Hangar Exteriors - Construction 5,541 390 3902125 73210 C/O Airport Departm( 2C Terminal Boiler Replacement - Construction 9 390 3902126 73210 C/O Airport Departmc 2C Chlorine System Update - Construction 14,027 390 3902127 73210 C/O Airport Departm( 2C Airport Runway Painting - Construction 2,573 390 3902128 73211 C/O Airport Departm( 2C New Terminal Facility Design - Consulting Engineers 29,381 390 3902213 62712 C/O Airport Departmc 2C New Terminal Facility Design - FAA Funds 1,716,636 390 3902213 44105 C/O Airport Departmc 2C Old Airline Terminal Assessment - Consultant Engineers 20,044 390 3902214 62712 C/O Airport Departm 2C Replace Runway Regulators - Construction 30,067 390 3902215 73211 C/O Airport Departmc 2C New Term Facilities Roads and Aprons - Consultant Services (2,000) 390 3902316 62716 C/O Prespend FY12 TOTAL AIRPORT CONSTRUCTION FUND 10,661,363 12,256,577 DEBT SERVICE FUND Debt Service 0 Bond Proceeds - Bee Branch 2,909,000 440 44010440 54210 C/O TOTAL DEBT SERVICE FUND 2,909,000 SANITARY SEWER OPERATING FUND Water Pollution ( 8 Administration - Pay to Other Agency - Consent Decree 370,000 610 61043100 62761 C/O TOTAL SANITARY SEWER OPERATING FUND 370,000 Page 12 FISCAL YEAR 2012 AMENDMENT #1 CITY COUNCIL Department REFUSE FUND Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works Program Description 8C Litter and Recycling Receptacle - Receptacles 8C Dual Packer Recylcle Vehicles 8 Recycling - Recycable Sales 8 Refuse Collection - Tipper Carts and lids 8 Refuse Collection - Printing & Binding 8 Recycling - Printing and Binding 8 Refuse Collection - Promotion 8 Recycling - Promotion 8 Recycling - Recycling Container TOTAL REFUSE FUND AMERICA'S RIVER PROJECT FUND Engineering 8C Art in Port of Dubuque - Consultant Services TOTAL AMERICA'S RIVER PROJECT FUND SANITARY SEWER CONSTRUCTION FUND Water Pollution ( 8C Scada System Upgrade - Construction - Not Building Water Pollution ( 8C WPC Plant Facility Study - Construction Building Water Pollution ( 8C WPC Plant Facility Study - Construction Building Water Pollution ( 8C WPC Plant Facility Study - SRF Bond Proceeds Water Pollution ( 8C Pumping Station Telemetry - Equipment Acquisition Water Pollution ( 8C 02 Plant Mixers/Repair - Construction Not Building Water Pollution ( 8C 02 Plant Mixers/Repair - Equipment Acquisition Water Pollution ( 8C Terminal Street Mag Meter Repair - Consulting Water Pollution ( 8C Perry St Pumping Upgrades - Consulting Engineers Water Pollution ( 8C Perry St Pumping Upgrades - Construction Building Water Pollution ( 8C Terminal St Sluice Grates - Consulting Engineers Water Pollution ( 8C Switch Gear Pumping Station - Construction Contract Water Pollution ( 8C Standby Generator Catfish - Construction Contract Public Works 8C Sanitary Sewer Root Foam - Miscellaneous Services Public Works 8C Sewer Pipeline Inspection Equipment - Equipment Public Works 8C PW Fleet GPS Project - Pager/Radio Equipment Public Works 8C Mobile GIS System - Equipment Engineering 8C Annexation Study / Implementation - Construction Not Bldg Engineering 8C Annexation Study / Implementation - GO Bond Proceeds Engineering 8C Sewer Conn Asst - Low/Mod - Miscellaneous Services Engineering 8C General Sanitary Repairs- Construction Engineering 8C Sanitary Sewer Internal Main - Construction Engineering 8C Sanitary Sewer Internal Main - Private Participant Engineering 8C 1 &I Reduction Program - Construction Not Bldg Engineering 8C Lateral Repl Asst. Low Inc - Eng. Division Services Engineering 8C Nightengale Lane Sanitary Sewer - Eng Division Services Engineering 8C Nightengale Lane Sanitary Sewer - Construction FY 12 Expense Amount FY 12 Revenue Amount Fund Activity/CIP Account Explanation 30,000 670 6702226 72821 737,647 670 6701533 73410 81,480 670 67054530 51665 2,020 670 67054500 71221 3,292 670 67054500 62090 186 670 67054530 62090 3,444 670 67054500 62140 3,556 670 67054530 62140 14,404 670 67054530 72818 794,549 81,480 C/O C/O New Contract C/O C/O C/0 C/O C/O C/0 172,936 700 7001853 62731 C/0 172,936 - 42,929 710 7101339 73211 C/O (789,580) 710 7101837 73210 (149,282) 710 7101837 73210 12,563,555 710 7101837 54230 78,590 710 7101930 73410 14,000 710 7101931 73211 135,096 710 7101931 73410 12,755 710 7102211 62712 8,500 710 7102212 62712 75,827 710 7102212 73210 5,000 710 7102034 62712 13,283 710 7102036 73211 26,900 710 7102149 73211 3,918 710 7101341 62731 23,935 710 7101840 73410 13,194 710 7101935 73410 10,000 710 7102225 73410 2,518,213 710 7101012 73211 2,268,000 710 7101012 54210 34,717 710 7101067 62731 (24,544) 710 7101289 73211 736,773 710 7101293 73510 218,739 710 7101293 53102 51,930 710 7101294 73211 79,782 710 7101297 62811 40,000 710 7101301 62811 268,439 710 7101301 73510 Page 13 C/O - Prespend FY12 C/0 - Prespend FY12 C/0 C/0 C/O C/O C/O C/0 C/0 C/0 C/O C/O C/O C/0 C/O C/O C/O C/O C/0 C/0 - Prespend FY12 C/O C/O C/O C/0 C/0 C/O 30- Aug -l1 FISCAL YEAR 2012 AMENDMENT #1 CITY COUNCIL 30-Aug-11 FY 12 FY 12 Expense Revenue Department Program Description Amount Amount Fund Activity /CIP Account Explanation Engineering 8C Sewer Lateral Assistance - Eng Division Services 46,448 710 7101309 62811 C/O Engineering 8C Sewer Lateral Assistance - Construction Not Bldg 55,216 710 7101309 73211 C/O Engineering 8C Laterals - I &I Reduction 16,921 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,572 710 7101328 73211 C/O Engineering 8C Sanitary Sewer Manhole Replacement (3,287) 710 7101335 73211 C/O - Prespend FY 12 Engineering 8C Hwy 20 Annexation Sanitary Sewers - Construction 264,167 710 7101336 73211 C/O Engineering 8C Sewer Extensions New Development - Const Not Bldg 435,291 710 7101350 73211 C/O Engineering 8C Sewer Extensions New Development - Construction Supp 172,131 710 7101350 73510 C/O Engineering 8C Sewer Extensions New Development - GO Bond Proceeds 466,420 710 7101350 54210 C/O Engineering 8C Sewer Clearing/Grubbing - Const. 65,570 710 7101636 73211 C/O Engineering 8C Sanitary Sewer Lining Program - Const Not Bldg 9,056 710 7101637 73211 C/O Engineering 8C Street Program/Related - Const Not Bldg 261,474 710 7101638 73211 C/O Engineering 8C Annexation Middle Road - Eng Division Services 56,594 710 7101641 62811 C/O Engineering 8C Annexation Middle Road - Construction Not Bldg 376,000 710 7101641 73211 C/O Engineering 8C Annexation Middle Road - GO Bond Proceeds 433,000 710 7101641 54210 C/O Engineering 8C Monroe St Sanitary Sewer - Construction 6,005 710 7101797 73211 C/O Engineering 8C Monroe St Sanitary Sewer - Engineering Division Services 942 710 7101797 62811 C/O Engineering 8C Sunset Ridge Sanitary Sewer - Construction 70,829 710 7101801 73211 C/O Engineering 8C Southfork Interceptor - Consulting Engineers 44,462 710 7101899 62712 C/O Engineering 8C Southfork Interceptor - Const Cont - Not Bldg 244,819 710 7101899 73211 C/O Engineering 8C Century Sewer Manholes - Engineering 4,000 710 7101905 62811 C/O Engineering 8C Century Sewer Manholes - Construction 15,000 710 7101905 73211 C/O Engineering 8C Four Mounds Septic Replacement - Const Not Bldg 42,020 710 7102014 73211 C/O Engineering 8C Historic Millwork - Sanitary Sewer - Const Not Bldg 1,675 710 7102129 73211 C/O Engineering 8C Laurel St Sanitary Sewer - Eng Division Services 30,000 710 7102130 62811 C/O Engineering 8C Laurel St Sanitary Sewer - Const Not Bldg 300,000 710 7102130 73211 C/O Engineering 8C North Fork Sanitary Sewer Improvements - FEMA 974,089 710 7102178 44405 C/O Engineering 8C North Fork Sanitary Sewer Improvements - SRF 666,343 710 7102178 54230 C/O Engineering 8C North Fork Sanitary Sewer Improvements - State HSEM 191,425 710 7102178 45701 C/O Engineering 8C Brunswick Sanitary Sewer - Construction 58,000 710 7102232 73211 C/O Engineering 8C Brunswick Sanitary Sewer - Engineering Division Services 8,146 710 7102232 62811 C/O Engineering 8C Fairway Dr Sanitary Sewer - Construction 20,000 710 7102233 73211 C/O Engineering 8C Fairway Dr Sanitary Sewer - Engineering Division Services 3,500 710 7102233 62811 C/O Engineering 8C Southgate Sanitary Sewer - Construction 34,000 710 7102234 73211 C/O Engineering 8C Southgate Sanitary Sewer - Eng Division Services 4,000 710 7102234 62811 C/O Engineering 8C Sanitary Utility Relocate - 10th and Central Ramp - Const 43,316 710 7102261 73211 C/O City Manager 8C GIS Enhancements - Peripherals, Computer 5,291 710 7101946 71120 C/O TOTAL SANITARY SEWER CONST FUND 6,106,533 17,781,571 STORM WATER CONSTRUCTION FUND Parks Division 8C Bee Branch Trees Forever - Tree Planting 6,130 720 7202337 73311 C/O Public Works 8C Sewer Pipeline Inspection Equipment - Equipment 5,404 720 7201840 73410 C/O Public Works 8C PW Fleet GPS Project - Pager/Radio Equipment 10,000 720 7201935 73410 C/O Public Works 8C Mobile GIS System - Equipment 10,000 720 7202225 73410 C/O Page 14 FISCAL YEAR 2012 AMENDMENT #1 CITY COUNCIL 30 -Aug -11 FY 12 FY 12 Expense Revenue Department Program Description Amount Amount Fund Activity /CIP Account Explanation Public Works 8C Stormwater Ditch Remediation 22,610 720 7201004 73211 C/O Engineering 8C Storm Sewer Improvements - Construction (17,494) 720 7201008 73211 C/O Prespend FY 12 Engineering 8C Catch Basin/Westside - Construction Not Building 39,805 720 7201081 73211 C/O Engineering 8C Streambank Rehab - Construction 32,729 720 7201352 73211 C/O Engineering 8C NPDES Program - Consultant Services 10,773 720 7201355 62716 C/O Engineering 8C Gunite Rock Stormsewer - Construction 36,310 720 7201363 73211 C/O Engineering 8C General Detention Basin Silt Removal - Construction 63,963 720 7201375 73211 C/O Engineering 8C Bee Branch Alignment - State Revolving Loan Funds 778,204 720 7201654 54230 C/O Engineering 8C Bee Branch Alignment - Iowa Finance Authority 2,747,176 720 7201654 54230 C/O Engineering 8C Bee Branch Alignment - Right -of -Way Acquisition 500,000 720 7201654 73113 C/O Engineering 8C Bee Branch Alignment - Construction 1,323,805 720 7201654 73211 C/O Engineering 8C Bee Branch Alignment - Right -of -Way Acquisition (469,760) 720 7201654 73113 C/O Engineering 8C Goethe /Sheridan Storm Sewer - Engineering Division Services 5,000 720 7201656 62811 C/O Engineering 8C Goethe /Sheridan Storm Sewer - Construction 36,000 720 7201656 73211 C/O Engineering 8C Storm Sewer Cleaning - Construction 182,264 720 7201659 73211 C/O Engineering 8C Keyway Channel & Culvert Imp - SRF GO Bond Proceeds 10,958 720 7201662 54230 C/O Engineering 8C Amy Ct Storm Sewer Impry - Eng. Division Services 1,800 720 7201666 62811 C/O Engineering 8C Amy Ct Storm Sewer Improv - Construction 12,000 720 7201666 73211 C/O Engineering 8C Keyway/Rosemont Channel Improvements - Construction 19,541 720 7201807 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,579 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 293,219 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 Millwork District Storm Sewer - Construction 169,927 720 7202131 73211 C/O Engineering 8C Iowa Street Storm Sewer - Engineering 3,708 720 7202132 62811 C/O Engineering 8C Iowa Street Storm Sewer - Construction 35,509 720 7202132 73211 C/O Engineering 8C Kane Kaufman Storm Sewer - Engineering 21,906 720 7202133 62811 C/O Engineering 8C Kane Kaufman Storm Sewer - Construction 148,382 720 7202133 73211 C/O Engineering 8C Peru Road Storm Sewer - Engineering 3,073 720 7202133 62811 C/O Engineering 8C Peru Road Storm Sewer - Construction 10,486 720 7202133 73211 C/O Engineering 8C Cedar Cross Rd Storm - Engineering 5,000 720 7202238 62811 C/O Engineering 8C Cedar Cross Rd Storm - Construction 10,000 720 7202238 73211 C/O Engineering 8C Floodwall Breach Analysis 30,000 720 7202239 62811 C/O Engineering 8C Ice Harbor/Maus Aux Pump 50,000 720 7202240 62811 C/O Engineering 8C Sunset Ridge Storm - Construction Not Building 23,772 720 7202242 73211 C/O Engineering 8C Kaufmann & Trygg Storm - Engineering 3,000 720 7202243 62811 C/O Engineering 8C Kaufmann & Trygg Storm - Construction Not Building 18,000 720 7202243 73211 C/O TOTAL STORM WATER CONST FUND 2,836,119 3,536,338 PARKING CONSTRUCTION FUND Parking Division 8C Seal Coating Parking Lots - Consultant Services 18,451 730 7301380 62716 C/O Parking Division 8C Seal Coating Parking Lots - Construction Contract 260,993 730 7301380 73211 C/O Parking Division 8C Major Maintenance on Ramps - Architectural Serv. 14,405 730 7301385 62711 C/O Page 15 FISCAL YEAR 2012 AMENDMENT #1 CITY COUNCIL Department Program Description Parking Division Parking Division Parking Division Parking Division Parking Division Parking Division Parking Division Parking Division Parking Division Parking Division Parking Division Parking Division Parking Division Building Service: City Manager Information Sery WATER CONS Water Departmer Water Departmer Water Departmer Water Departmer Water Departmer Water Departmer Water Departmer Water Departmer Water Departmer Water Departmer Water Departmer Water Departmer Water Departmet Water Departmer Water Departmer Water Departmer Water Departmer Water Departmer Water Departmer Water Departmer Water Departmer Water Departmer Water Departmet Water Departmer Water Departmer Water Departmer 8C Major Maintenance on Ramps - Construction 8C Port of Dubuque Ramp Maint - Construction Not Building 8C 7th St Pedestrian Walkway - Consulting Engineers 8C 10th /Central Parking Ramp - Construction 8C 10th/Central Parking Ramp - EDA Grant 8C 10th/Central Parking Ramp - Construction 8C Parking Ramp Signage - Consultant Services 8C Parking Ramp Signage - Signage 8C Re- lamping Locust St - Lighting 8C Re- lamping 5th Street - Lighting 8C POD Ramp Special Expenses - Miscellaneous 8C POD Ramp Special Expenses - Bond Proceeds 8C Re- Lamping Iowa Street Ramp - Construction 8C Smart Meters - Construction 8C GIS Enhancements - Peripherals, Computer 8C Internet, Micros & Printer - Parking Fund TOTAL PARKING CONSTRUCTION FUND TRUCTION FUND 8C GIS Maintenance/Upgrade - Consulting Engineers 8C GIS Maintenance/Upgrade - Consulting Services 8C Service Line Assistance - Misc Services 8C Service Line Assistance - Consulting Engineers 8C Water Internal Lines/Loan - Construction 8C Water Internal Lines/Loan - Eng. Division Services 8C Water Internal Lines/Loan - Private Participant 8C Water Main Extensions - Construction 8C Water Main Replacements - Water Main Replacements 8C Fire Hydrant Replacements - Equipment 8C Water Main Extension/Annexation Related - Consult Eng 8C Water Main Extension /Annexation Related - Construction 8C Shallow Well Rehab - Construction 8C Bunker Hill Pump Station - Construction 8C Roosevelt Rd. Main Ext. - Consult Eng 8C Annexation Study/Implementation - Eng Division 8C Annexation Study/Implementation - Construction 8C Annexation Study/Implementation - Water Rev Bond Proceeds 8C Vacuum Filter Back -Up - Construction 8C Olympic Heigths Pump Station - Construction 8C Water Meter Replacement Program - Const Not Building 8C Water Meter Replacement Program - SRF Loan 8C Millwork Dist - Water Main - Construction 8C Annexation Study - Phase II - Eng Division Services 8C Annexation Study - Phase II - Construction Not Building 8C Annexation Study - Phase II - GO Bond Proceeds FY 12 Expense Amount 33,500 205,559 10,000 1,002,484 (255,710) 10,000 50,000 5,768 6,601 (243,526) (56,423) 59,000 5,291 50,000 1,176,393 FY 12 Revenue Amount Fund Activity/CIP Account 730 7301385 73210 730 7302162 73211 730 7302163 62712 730 7302179 73210 407,052 730 7302179 44115 730 7302179 73210 730 7302228 62716 730 7302228 71227 730 7302229 71517 730 7302230 71517 730 7302260 62731 578,000 730 7302260 54210 730 7302318 73211 730 7302259 73210 730 7301946 71120 730 7301069 71124 43,768 1,906 51,754 2,500 285,530 25,000 42,205 (437,505) (11,220) 36,400 460,522 18,400 15,274 21,493 119,050 892,950 3,728 18,558 (1,200,892) 419,138 45,000 255,000 Page 16 985,052 740 7401389 62712 740 7401389 62716 740 7401390 62731 740 7401390 62811 740 7401398 73211 740 7401398 62811 246,898 740 7401398 53102 740 7401399 73211 740 7401405 73211 740 7401405 73211 740 7401411 62712 740 7401411 73211 740 7401415 73211 740 7401422 73210 740 7401672 73211 740 7401954 62811 740 7401954 73211 1,012,000 740 7401954 54210 740 7402030 73211 740 7402031 73211 740 7402052 73211 (281,068) 740 7402052 54230 740 7402145 73211 740 7402146 62811 740 7402146 73211 300,000 740 7402146 54210 Explanation C/O C/O C/O C/O C/O C/O - Fire Headquarters C/O C/O C/O C/O C/O C/O C/O - Prespend FY12 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 FY12 C/O - Prespend FY12 C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O - Prespend FY12 C/O - Prespend FY12 C/O C/O C/O C/O 30 -Aug -11 FISCAL YEAR 2012 AMENDMENT #1 CITY COUNCIL Department Water Departmet Water Departmet Water Departmet Water Departmet Water Departmet Water Departmet Water Departmet Water Departmet Water Departmet Water Departmei Water Departmet Water Departmet City Manager City Manager Information Sew Program 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C LANDFILL FUND Public Works 8C Public Works 8 TRANSFERS Fire Department Fire Department Parks Division Parks Division Recreation Divis Recreation Divis Airport Departmt Airport Departmt Airport Departmt Airport Departmt Airport Departmt Airport Departmt Airport Departmt Airport Departmt Airport Departmt Airport Departmt Airport Departmt Airport Departmt Airport Departmt Airport Departmt Airport Departmt Airport Departmt Trans01 Trans0l Trans02 Trans02 Trans03 Trans03 Trans04 Trans04 Trans05 Trans05 Trans06 Trans06 Trans07 Trans07 Trans08 Trans08 Trans09 Trans09 Trans10 Trans 10 Trans 11 Transll Description Drinking Water Study - Consulting Engineers Flouride Tank Upgrade - Construction Water Service Repair Grant - Grants Fire Hydrant Painting - Miscellaneous Services Water Valve Box Maintenance - Property Maintenance Asbury Tank Painting - Consulting Asbury Tank Painting - Construction Not Building Pump Room Roof Replacement Park Hill Pumping Roof - Construction Electrical Usage Integrated - Equipment Ramp Water Utility Relocate - Const Not Bldg ADA Improvements -Water Plant - Construction GIS Implementation GIS Enhancements - Peripherals, Computer Internet, Micros & Printer - Water Fund TOTAL WATER CONSTRUCTION FUND Landfill Environmental Management - Recycling DMASWA Education - Promotion TOTAL LANDFILL FUND Transfer from DRA Gaming to General Fund Transfer from DRA Gaming to General Fund Transfer from General Fund to Sales Tax Construction Transfer from General Fund to Sales Tax Construction Golf Activities(Profit) -Trans General Fd to Golf Constr Golf Activities(Profit) -Trans General Fd to Golf Constr 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 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 Sales Tax 20% Fd to Airport Const. Fund Transfer From Sales Tax 20% Fd to Airport Const. Fund Transfer From CFC Fund to Airport Const. Fund Transfer From CFC Fund to Airport Const. Fund Transfer from PFC Fund to Airport Construction Fund Transfer from PFC Fund to Airport Construction Fund FY 12 Expense Amount 51,464 1,931 1,096 24,960 14,039 10,000 75,253 100,725 31,160 177,205 131,225 97,309 2,503 2,841 39,204 1,869,474 34,835 2,246 37,081 FY 12 Revenue Amount 1,277,830 Transfer Out Transfer In 15,932 3,000 652 1,500 134,305 54,000 189,746 16,206 14,027 25,236 191,260 Page 17 15,932 3,000 652 1,500 134,305 54,000 189,746 16,206 14,027 25,236 191,260 Fund Activity/CIP Account Explanation 740 7402147 62712 C/O 740 7402148 73210 C/O 740 7402200 62765 C/O 740 7402201 62731 C/O 740 7402203 62431 C/O 740 7402204 62712 C/O 740 7402204 73211 C/O 740 7402206 73210 C/O 740 7402207 73210 CIO 740 7402210 62716 C/O 740 7402261 73211 C/O 740 7401402 73210 C/O 740 7401070 62731 CIO 740 7401946 71120 C/O 740 7401069 71124 C/O 940 9402268 72818 C/O 940 94054230 62140 C/O 100 101 100 350 100 370 391 390 391 390 102 390 391 390 391 390 350 390 350 390 391 390 10010100 10110101 10010100 3501978 10010100 37010370 39110391 3901060 39110391 3901891 10210102 3901893 39110391 3902009 39110391 3902011 35010350 3902127 35010350 3902213 39110391 3902213 91101 59100 91350 59100 91370 59100 91390 59391 91390 59391 91390 59102 91390 59391 91390 59391 91390 59350 91390 59252 91390 59391 Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds 30- Aug -I 1 FISCAL YEAR 2012 AMENDMENT #1 CITY COUNCIL 30- Aug -11 FY 12 FY 12 Expense Revenue Department Program Description Amount Amount Fund Activity /CIP Account Explanation Engineering Trans 12 Transfer from General Fund to Sanitary Sewer Fund 28,498 710 7101067 59101 Trans Funds Engineering Transl2 Transfer from General Fund to Sanitary Sewer Fund 28,498 101 10110101 91710 Trans Funds Engineering Trans 13 Tranfer from Spec. Assessment Fd to Sewer Const Fund 110,000 255 25510255 91710 Trans Funds Engineering Trans 13 Tranfer from Spec. Assessment Fd to Sewer Const Fund 110,000 710 7101301 59255 Trans Funds Engineering Transl4 Tranfer from Spec. Assessment Fd to Sewer Const Fund 124,000 255 25510255 91710 Trans Funds Engineering Trans 14 Tranfer from Spec. Assessment Fd to Sewer Const Fund 124,000 710 7101336 59255 Trans Funds Engineering Trans15 Tranfer from Spec. Assessment Fd to Sewer Const Fund 531,246 255 25510255 91710 Trans Funds Engineering Trans 15 Tranfer from Spec. Assessment Fd to Sewer Const Fund 531,246 710 7101801 59255 Trans Funds Engineering Transl6 Tranfer from Spec. Assessment Fd to Sewer Const Fund 307,000 255 25510255 91710 Trans Funds Engineering Transl6 Tranfer from Spec. Assessment Fd to Sewer Const Fund 307,000 710 7102130 59255 Trans Funds Engineering Trans17 Transfer from Bond Fund to Stormwater Fund 2,909,000 440 44010440 91720 Trans Funds Engineering Trans 17 Transfer from Bond Fund to Stormwater Fund 2,909,000 720 7201654 59440 Trans Funds Engineering Trans 18 Transfer From Sales Tax 20% Fd to Stormwater Const. Fund 13,800 350 35010350 91720 Trans Funds Engineering Trans 18 Transfer From Sales Tax 20% Fd to Stormwater Const. Fund 13,800 720 7201666 59350 Trans Funds Engineering Trans 19 Transfer from Spec. Assessment Fund to Street Const. Fund 255,217 255 25510255 91300 Trans Funds Engineering Trans 19 Transfer from Spec. Assessment Fund to Street Const. Fund 255,217 300 3001972 59255 Trans Funds Engineering Trans20 Transfer from Spec. Assessment Fund to General Const. Fund 1,678,460 255 25510255 91360 Trans Funds Engineering Trans20 Transfer from Spec. Assessment Fund to General Const. Fund 1,678,460 360 3602137 59255 Trans Funds Engineering Trans21 Transfer from Spec. Assessment Fund to Street Const. Fund 89,000 255 25510255 91300 Trans Funds Engineering Trans2l Transfer from Spec. Assessment Fund to Street Const. Fund 89,000 300 3002141 59255 Trans Funds Engineering Trans22 Transfer from General Fund to America's River Fund 165,943 100 10010100 91700 Trans Funds Engineering Trans22 Transfer from General Fund to America's River Fund 165,943 700 7001853 59100 Trans Funds Engineering Trans23 Transfer from DRA Gaming to General Fund 7,716 101 10110101 91100 Trans Funds Engineering Trans23 Transfer from DRA Gaming to General Fund 7,716 100 1001141 59101 Trans Funds TOTAL TRANSFERS 6,865,744 6,865,744 83,098,299.00 99,299,883.00 ENCUMBRANCE C /O's 41,902,508 Back out Non Budgeted Encumb Rollovers (171,602) Total Amend #1 with Enc, C /O's, and New 124,829,205 99,299,883 Page 18