Loading...
Fiscal Year 2012 Budget Amendment No. 1Masterpiece on the Mississippi September 13, 2011 TO: The Honorable Mayor and City Council Members FROM: Michael C. Van Milligen, City Manager SUBJECT: Fiscal Year 2012 First Budget Amendment Dubuque hail All-America City r 1 ' 2007 Budget Director Jennifer Larson is recommending approval of the first Fiscal Year 2012 Budget Amendment, which 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 $69,855,059 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. I concur with the recommendation and respectfully request Mayor and City Council approval. Michel C. Van Milligen MCVM /JML Attachment cc: Barry Lindahl, City Attorney Cindy Steinhauser, Assistant City Manager Jennifer Larson, Budget Director Masterpiece on the Mississippi September 13, 2011 TO: Michael C. Van Milligen, City Manager FROM: Jennifer Larson, Budget Director�-�`. SUBJECT: Fiscal Year 2012 First Budget Amendment Dubuque hfriti All- America 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 1 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 approving the FY 2012 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/19/2011 ,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 eouncil 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. 322-11 A RESOLUTION AMENDING THE CURRENT BUDGET FOR THE FISCAL YEAR ENDING JUNE 30 2012 Dubuque (AS AMENDED LAST ON Be it Resolved by the Council of the City of Section 1. Following notice published and the public hearing held, 09/19/2011 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 Signature City Clerk/Finance Officer 19th (Day) day of September 2011 (Month/Year) /2/,-- Signature Mayor Pro -Tem Total Budget as certified or last amended Current Amendment Total Budget after Current Amendment Revenues & Other Financing Sources g 20,559,847 0 .... 20,559,847 Taxes Levied on Property 1 Less: Uncollectted Property Taxes -Levy Year 2 0 0 0 Net Current Property Taxes 3 20,559,847 0 20,559,847 Delinquent Property Taxes 4 0 0 0 TI F Revenues 5 10,151,097 0 10,151,097 Other City Taxes 6 14,904,342 0 14,904,342 Licenses & Permits 7 1,254,672 0 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 itures &Other Financing Uses e 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 Govemment 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 s Over Excess Revenues & Other Source O (Under) Expenditures /Transfers Out Fiscal Year 28 _ ____ - 3,572,952 - 25,529,322 _ - 29,102,274 Continuing Appropriation 29 , - 0 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 Passed this Signature City Clerk/Finance Officer 19th (Day) day of September 2011 (Month/Year) /2/,-- Signature Mayor Pro -Tem FISCAL YEAR 2012 AMENDMENT #1 CITY COUNCIL Department Program Description 13- Sep -11 FY12 FY12 Expense Revenue Amount Amount Fund Activity/CIP Account Explanation GENERAL FUND Police Departmei 1 C Replace Police /CAD Software 600,000 102 1021167 71123 C/O Police Departmei 1C Replace Police /CAD Software - County Reimbursement 400,000 102 1021 167 53102 C/O Police Departmei 1C Police Wireless Data Trans System - Computer Peripherals 9,833 101 1012092 71 120 C/O Police Departmei IC Police Wireless Data Trans System - Consulting 1 0,500 101 1012092 62712 C/O Police Departmei IC Restore Police Car - Private Contributions 10,613 100 1002280 62528 C/O Police Departmei 1 Target Crime Prevention Grant 1,750 100 10011760 62671 C/O Police Departmei I 2009 Justice Assistance Grant - Reimb OT 3,076 100 10011775 61051 C/O Police Departmci 1 2009 Justice Assistance Grant- Misc Op Supplies 2,257 100 1001 1775 62671 C/O Police Departmei 1 2009 Justice Assistance Stimulus Grant - Reimbursable OT 100,459 100 10011740 61051 C/O Police Departmei I 2009 Justice Assistance Stimulus Grant - Misc Op Supplies 78,853 100 1001 1740 62671 C/O Police Departmei 1 2009 Justice Assistance Stimulus Grant - Misc Op Supplies 3,000 100 1001 1740 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 1001 1776 61051 C/O Police Departmei 1 2010 Justice Assistance Stimulus Grant - Special Equip 34,883 100 1001 1776 72218 C/O Police Departmei 1 Police Training - Training 46,539 100 1001 1250 62360 C/O Police Departmei 1 Police Patrol - Training 48,021 100 10011700 62360 C/O Police Departmei 1 Community Policing - Training 2,263 100 1001 1500 62360 C/O Police Departmei 1 Police Patrol - Police Honor Guard Dress Jackets 1,680 100 1001 1700 6201 1 C/O Police Departmei I Police Patrol - Radio /Pager Fees 23,534 100 10011700 62424 C/O Police Departmci 1 Police Patrol - Maintenance Outsourced 6,000 100 10011700 62528 C/O Police Departmei 1 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 1001 1320 61051 C/O Police Departmei I JAG Stimulus Grant 59,197 100 1001 1320 44176 New Grant Police Departmci 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 FY 10 Traffic Service Grant 3,152 100 1001 1772 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 1C Pumper Replacement 147 100 1001016 71318 C/O Fire Department 1 C Intersection Preemption - Equipment Acquisition 14,557 101 1011023 73410 C/O Fire Department IC 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 Eire 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 1 Fire Suppression - Radio Access Fees 10,819 100 10013400 62424 Radio Access Fees Fire Department IC Fire Station Expansion/Relocation 650,000 101 1011864 54205 C/O Fire Department IC 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 Departm( Library Departm Library Departm( Library Departm( 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 - AudioNisual 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 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/0 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/0 C/O C/O C/O - Prespend FY 12 Lost Book Fees Lost Book Fees 13- Sep -11 FISCAL YEAR 2012 AMENDMENT #1 CITY COUNCI1. Department Airport Departm( Airport Departm Airport Departmi Airport Departm( Airport Departm( Airport Departm 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 Dcvlol Economic Dcvlol Program Description 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) FY 12 FY 12 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 1 9,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 13-Sep-11 Explanation C/O C/O C/O C/O C/O C/O C/O C/O - FY 12 Prespend C/0 - FY12 Prespend C/0 - Prespend FY12 C/0 C/O C/O C/O C/O C/0 - 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/0 C/0 - DCSD C/0 C/O C/0 C/0 New Grant Appropriation New Grant C/0 C/0 C/O C/0 C/O C/O C /O- Prespend FY12 C/O C/0 FISCAL YEAR 2012 AMENDMENT #1 CITY COUNCIL Department Economic Dcvlol Economic Devlol Economic Dcvlol Economic Devlol Economic Devlol Economic Devlol Housing & Comr Housing & Comr Housing & Comr Housing & Comr Housing & Comr Housing & Comr Housing & Comr I lousing & Comr Housing & Comr Housing & Comr Housing & Comr Housing & Comr Housing & Comr Housing & Comr Housing & Comr I lousing & Comr Housing & Corm Housing & Comr Housing & Comr Housing & Comr Housing & Comr Housing & Comr Housing & Comr Housing & Comr Housing & Comr Housing & Comr Housing & Comr Housing & Comr Housing & Comr Housing & Comr Housing & Comr Housing & Comr Housing & Comr Housing & Comr Housing & Comr Housing & Comr Housing & Comr Housing & Comr Housing & Comr Program SC 5C 5C 5C 5C 5C SC 5C 5C 5C 5C 5C 5C 5C 5C 5C 5C 5C 5C 5C 5C 5C 5C 5C 5C 5C 5C 5C 5C 5C 5C 5C 5C 5C 5C 5C 5C 5C 5C 5C 5C 5C 5C 5 5 Description Port of DBQ- Develop.Standards (Int Write Down) Warehouse Master Planning - Private Participant IFA Downtown Loan Pool - Loan Proceeds IPA Downtown Loan Pool - Interest Repayments IFA Downtown Loan Pool - Interest Expense IFA Downtown Loan Pool - Loans to Developers Maint of Vacant /Abandoned - Property Maintenance Maint of Vacant /Abandoned - Property Maintenance Housing Trust - IA Finance - Grants Purchase/Resale /Rehab - Land Acquisition Historic Preservation Revolving Loan Historic Preservation Revolving Loans Homeownership Grants - Target Homeownership Grants - Target Homeless Prevention Grant - Federal Stimulus Grant Homeless Prevention Grant - Pay to Other Agency NBHD Stabilization Grant - Stimulus Fed Pass Thru Grant NBHD Stabilization Grant - Land Acquisition with Improv. IFA I -Jobs Affordable Housing Assist - la Finance Authority IFA Housing Trust - Grants Healthy Homes Grant - Federal Grant Healthy Homes Grant - Full -time Employees Healthy Homes Grant - IPERS Healthy Homes Grant - Social Security Healthy Homes Grant - Health Insurance Healthy Homes Grant - Workers Compensation Healthy Homes Grant - Life Insurance Healthy Homes Grant - Office Supplies Healthy Homes Grant - Postage Healthy Homes Grant - Printing & Binding Healthy Homes Grant - Copying & Reproduction Healthy Homes Grant - Legal Notice & Ads Healthy Homes Grant - General Liability Insurance Healthy Homes Grant - Mileage Healthy Homes Grant - Education & Training Healthy Homes Grant - Telephone Healthy Homes Grant - Miscellaneous Services Healthy Homes Grant - Grants Healthy Homes Grant - Computer IFA Our Home Grant - Grants 1FA Our Home Grant - Iowa Finance Authority IFA Housing Trust - Grants IFA Housing Trust 11-19 - Grants Shelter Plus Care Grant - Grant Shelter Plus Care Grant - Administrative Costs FY 12 Expense Amount 15,000 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 1 48,750 4,200 250,000 147,677 1 57,250 10,680 Page 4 FY 12 Revenue Amount Fund Activity/CIP Account Explanation 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 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 13- Sep -11 FISCAL YEAR 2012 AMENDMENT #1 CITY COUNCIL Department Housing & Corm Housing & Comr Housing & Comr Housing & Comr Housing & Conn Housing & Conn Housing & Comr Housing & Comr Housing & Corr Housing & Comr 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 Expense Amount 21,138 80,000 30,000 10,028 103,578 1,817 6.055 7,146 2,497 1,967 34,075 85.873 30,881 3.241 1,852 3,082 4,810 14,587 7,760 22,642 383,690 68.000 1,500 12,000 2,432 212,563 (274) 1.500 5,214 2.295 18,190 1,391 1,467 4,620 46 (175) 4,500 3,065 11,600 37,572 4,000 FY 12 Revenue Amount Fund Activity /CIP Account 100 10061915 62694 100 10061100 62761 100 10061125 62761 100 10061130 61010 100 10061150 62431 100 10061920 62320 100 10061921 62320 100 10061922 61020 100 10061922 62320 100 10061300 62211 100 1001010 62711 102 1021010 73210 102 1021012 62716 100 10070100 62662 100 1001070 62716 102 1021946 71120 100 1001948 62734 100 1002050 72115 100 1002165 62360 102 1022218 62716 525,000 100 1002272 45701 100 1002334 62716 100 1002334 61010 100 1002334 62010 100 1002334 62090 100 1002334 62310 473,136 100 1002334 44170 100 1002338 62716 227,005 100 1002338 44175 5,000 100 1002275 45761 100 10072200 62190 100 10072400 62360 100 10072500 62761 100 10072100 62756 100 10072100 61010 100 10072100 61320 100 10072100 61310 100 10072100 61410 100 10072100 61415 100 10073100 62360 100 1002166 71123 100 1002216 71123 100 1002217 71123 100 1002342 71125 100 10079195 62761 Page 5 13- Sep -11 Explanation 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 Mgrnt Fellow Hours Increase Mgmt Fellow Hours Increase Mgrnt 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 Intern-lode] 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 FOUND GREATER DOWNTOWN TIF - TIF FUND Economic Devloi 5C Downtown Rehab Consultant - Financial Consultant TOTAL GREATER DOWNTOWN TIF - TIF FUND DOWNTOWN LOAN POOL - TIF FUND Economic Devloi 5C Economic Devloi 5C 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 Loan Pool, Downtown TIF - Loans Downtown Rehab Grant Program TOTAL DOWNTOWN LOAN POOL -TIF FUND 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 FY 12 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 13- Sep -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 Engineering Engineering Building Service! Economic Develc Economic Develc Housing & Comr Housing & Corm Housing & Comi Housing & Conn Housing & Conn Housing & Comr Housing & Conu Housing & Comr (-lousing & Corm Housing & Conn Housing & Comr Housing & Comr DEVELOPMENT BLOCK GRANT FUND 2C Accessible Curb Ramps - Construction 5C Neighborhood Infrastructure Improvements - Construction 6C Kephart Building Improvement - Construction 5C Commercial /Industrial Rehab Loan - CDBG 5C Commercial /Industrial Rehab Loan - CDBG 5C Homeownership Rehab Program -Loans 5C Purchase /Resale /Rehab - Construction 5C Lead Paint Abatement Program - Loans 5C Rental Rehab - Loans 5C First Time Homebuyer Program -Loans 5C Historic Preservation Rehab Grant -Loans 5 CDBG Admin /Monitorinb CD Block Grant Receivable 5 Housing Rehab Sery & Staff - Education & Training 5 Housing Rehab Sery & Staff - Software 5 Housing Rehab Sery & Staff - Software 5 Housing Code Enforcement - Software License 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 5C Homeownership Rehab Program - Construction 5C HOME Loan Repayments 5 LHAP Grant - Loans TOTAL STATE RENTAL REHAB FUND Housing & Conn Housing & Comr Housing & Comr FY 12 Expense Amount 31,815 (313) (1,205) 150,148 FY 12 Revenue Amount 448,086 197,000 197,000 Fund Activity /CIP 250 2501916 250 25055400 250 25055400 Account Explanation 73211 C/O 62310 C /O- Prespend FY 12 62310 C /O- Prespend FY l2 255 25510255 52101 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 2,617 260 26061300 62360 6,826 260 26061300 71123 6,992 260 26061300 71123 1,280 260 26061700 62663 5,460 260 26061700 71124 641,243 723,659 Increased Assessments C/O CDBG Funds CDBG Amend# I 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 CDBG Funds C/O 13- Sep -l1 8,900,000 263 2632341 44205 New CDBG Grant 8,892,500 263 2632341 62761 New CDBG Grant Appropriation 8,892,500 8,900.000 21,480 62764 C/O 44,760 62764 C/O 150,000 62761 C/O 216,240 546,272 73210 C/O 9,371 73210 C/O 21.430 62764 C/O 577,073 Page 7 265 2651246 265 2651247 265 2651796 270 2701065 270 2701250 270 27061320 FISCAL YEAR 2012 AMENDMENT #1 CITY COUNCIL Department Program Description 13- Sep -11 FY 12 FY 12 Expense Revenue Amount Amount Fund Activity /CIP Account Explanation LEAD PAINT GRANT FUND Housing & Comi 5 Lead Paint Abatement Program - State Grant (4,000) 275 27561200 45701 Move to new activity Housing & Comr 5 Lead Paint Abatement Program -Lead Grant (1.061,839) 275 27561200 44310 Move to new activity Housing & Corm 5 Lcad Paint Abatement Program - Homeowner Repayments (23,075) 275 27561200 43410 Move to new activity Housing & Comr 5 Lead Paint Abatement Program - State Grant 4,000 275 27561211 45701 Move to new activity Housing & Comr 5 Lead Paint Abatement Program -Lead Grant 1,061,839 275 27561211 44310 Move to new activity Housing & Comr 5 Lead Paint Abatement Program - Homeowner Repayments 23,075 275 27561211 43410 Move to new activity Housing & Comr 5 Lead Paint Abatement Program - Full -time Employees (155,224) 275 27561200 61010 Move to new activity Housing & Comr 5 Lead Paint Abatement Program - Full -time Employees 155,224 275 27561211 61010 Move to new activity Housing & Comr 5 Lead Paint Abatement Program - IPERS (12,527) 275 27561200 61310 Move to new activity Housing & Comr 5 Lcad Paint Abatement Program - IPERS 12,527 275 27561211 61310 Move to new activity Housing & Comr 5 Lead Paint Abatement Program - SS (11,876) 275 27561200 61320 Move to new activity Housing & Comr 5 Lead Paint Abatement Program - SS 11,876 275 27561211 61320 Move to new activity Housing & Comr 5 Lead Paint Abatement Program - Health (27.720) 275 27561200 61410 Move to new activity Housing & Comr 5 Lead Paint Abatement Program - Health 27,720 275 27561211 61410 Move to new activity 1- lousing & Comr 5 Lead Paint Abatement Program - Workers' Compensation (3,078) 275 27561200 61415 Move to new activity Housing & Comr 5 Lead Paint Abatement Program - Workers' Compensation 3,078 275 27561211 61415 Move to new activity Housing & Comr 5 Lead Paint Abatement Program - Life (310) 275 27561200 61416 Move to new activity Housing & Comr 5 Lead Paint Abatement Program - Life 310 275 27561211 61416 Move to new activity Housing & Comr 5 Lead Paint Abatement Program - Office Supplies (910) 275 27561200 62010 Move to new activity Housing & Comr 5 Lead Paint Abatement Program - Office Supplies 910 275 27561211 62010 Move to new activity Housing & Comr 5 Lead Paint Abatement Program - Postage (4,672) 275 27561200 62030 Move to new activity Housing & Comr 5 Lead Paint Abatement Program - Postage 4,672 275 27561211 62030 Move to new activity Housing & Comr 5 Lead Paint Abatement Program - Printing (2,100) 275 27561200 62090 Move to new activity Housing & Comr 5 Lead Paint Abatement Program - Printing 2,100 275 27561211 62090 Move to new activity I lousing & Comr 5 Lead Paint Abatement Program - Copying (837) 275 27561200 62110 Move to new activity Housing & Comr 5 Lead Paint Abatement Program - Copying 837 275 27561211 62110 Move to new activity Housing & Comr 5 Lead Paint Abatement Program - Legal Notices (3,120) 275 27561200 62130 Move to new activity Housing & Comr 5 Lead Paint Abatement Program - Legal Notices 3,120 275 27561211 62130 Move to new activity Housing & Comr 5 Lead Paint Abatement Program - General Liability (2,071) 275 27561200 62208 Move to new activity Housing & Comr 5 Lead Paint Abatement Program - General Liability 2,071 275 27561211 62208 Move to new activity Housing & Comr 5 Lead Paint Abatement Program - Conferences (6,160) 275 27561200 62310 Move to new activity Housing & Comr 5 Lead Paint Abatement Program - Conferences 6,160 275 27561211 62310 Move to new activity Housing & Comr 5 Lead Paint Abatement Program - Mileage (250) 275 27561200 62340 Move to new activity Housing & Comr 5 Lcad Paint Abatement Program - Mileage 250 275 27561211 62340 Move to new activity Housing & Comr 5 Lead Paint Abatement Program - Education & Training (7.000) 275 27561200 62360 Move to new activity Housing & Comr 5 Lead Paint Abatement Program - Education & Training 9,870 275 27561211 62360 Move to new activity Housing & Comr 5 Lead Paint Abatement Program - Telephone (2,220) 275 27561200 62421 Move to new activity Housing & Comr 5 Lead Paint Abatement Program - Telephone 2,220 275 27561211 62421 Move to new activity Housing & Comr 5 Lead Paint Abatement Program - Rental of Space (768) 275 27561200 62436 Move to new activity Housing & Comr 5 Lead Paint Abatement Program - Rental of Space 768 275 27561211 62436 Move to new activity Housing & Comr 5 Lead Paint Abatement Program - Mach/Equip (128) 275 27561200 62611 Move to new activity Housing & Comr 5 Lead Paint Abatement Program - Mach/Equip 128 275 27561211 62611 Move to new activity Page 8 FISCAL PEAR 2012 AMENDMENT #1 CITY COUNCIL Department Housing & Conn Housing & Conn Housing & Comi Housing & Conn 1-lousing & Conn Housing & Conn Housing & Comr 1-lousing & Corm Housing & Comi Housing & Comr Housing & Comr Housing & Comr Housing & Comr Housing & Comi 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 & Comr Housing & Conn Housing & Comr 5 MOD Rehab - Housing Assistance Payments 5 Section 8 Voucher - Software 5 Section 8 Voucher - Software TOTAL SECTION 8 VOUCHER FUND STREET CONSTRUCTION FUND Public Works 2C Asphalt Milling Program - Construction Not Building 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 Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering FY 12 Expense Amount (799) 799 (1,684) 1,684 (27,018) 27,018 (4,743) 4,743 (81 1,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 CIO 766,423 300 3001287 73113 C/O 22,031 300 3001634 45701 C/O Page 9 1 13- Sep -11 FISCAL YEAR 2012 AMENDMENT #1 CITY COUNCIL 13-Sep-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 FY 12 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 Masterarm 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 a 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 Parks Division Parks Division Parks Division Parks Division Parks Division Civic Center Div Civic Center Div Civic Center Div Civic Center Div Conference Cent Conference Cent( Public Works Public Works Public Works Public Works Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Building Service: Building Service: Building Service: Building Service: Building Service: Program 4C 4C 4C 4C 4C 4C 4C 4C 4C 6C 6C 2C 2C 2C 2C 2C 2C 2C 2C 2C 2C 2C 2C 2C 2C 2C 2C 2C 6C 6C 6C 6C 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 Engineering Engineering Economic Devloi Economic Devloi Economic Devloi Economic Devlol Economic Devloi Economic Devloi 2C 2C 2C 5C 5C 5C 5C 5C 5C Millworking District Street - Construction Millworking District Street - TIGER Grant Port of Dubuque Ramp - Construction Industrial Site Development - North Siegert - Construction Industrial Site Development - North Siegert - RISE Grant DICW - Wildflowers - Landscaping Contract DICW - Wildflowers - Consulting Engineers Design South Siegert Farm - Construction 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 13- Sep -11 Explanation C/0 C/0 C/0 C/0 C/0 C/0 C/0 C/0 C/0 C/0 C/0 C/0 C/0 C/0 C/0 C/0 C/0 C/0 c/0 C/0 - Conrad Reimbursement C/0 C/0 C/0 C/0 C/0 C/0 C/0 C/0 C/0 C/0 C/0 C/0 C/0 360 3602137 73211 C/0 4,192,182 360 3602137 44175 C/0 360 3601957 73211 C/0 360 3601943 73211 C/0 57.736 360 3601943 45741 C/0 360 3602158 73310 C/0 360 3602158 62712 C/0 360 3602160 73211 C/0 370,633 360 3602160 54210 C/0 - Includes Bergfeld Trail FISCAL YEAR 2012 AMENDMENT #1 CITY COUNCIL 13- Sep -11 FY 12 FY 12 Expense Revenue Department Program Description Amount Amount Fund Activity/CIP Account Explanation Economic Devlol 5C Millwork District Parking Imp - Construction 1,593,411 360 3602250 73211 C/O Economic Devloi 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 Departmm 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 Departme 2C Runway Safety Area -FAA Funds 211,408 390 3901788 44105 C/O Airport Departm 2C Terminal - Land Acquisition - Relocations 5,000 390 3901795 73112 C/O Airport Departmm 2C Terminal - Land Acquisition - FAA Funds 5.000 390 3901795 44105 C/O Airport Departme 2C Terminal - RW 31 Parallel - Consulting Engineers 248,100 390 3901891 62712 C/O Airport Departm 2C Terminal - RW 31 Parallel - Construction 3,181,772 390 3901891 73211 C/O Airport Departm■ 2C Terminal - RW 31 Parallel -FAA Funds 3,295,567 390 3901891 44105 C/O Airport Departme 2C Terminal - Sche /Site Design -FAA Funds 198,595 390 3901892 44105 C/O Airport Departme 2C Extend Gen'l Aviation Ramp - Consulting Engineers 5,000 390 3901893 62712 C/O Airport Departmt 2C Extend Gen'l Aviation Ramp - Construction 49,000 390 3901893 73211 C/O Airport Departme 2C Hanger Repairs/Replace - Construction 9,990 390 3902008 73210 C/O Airport Departm 2C Terminal Sitework - Consulting Engineers 3,794,911 390 3902009 62712 C/O Airport Departme 2C Terminal Sitework - FAA Funds 3,605,165 390 3902009 44105 C/O Airport Departm( 2C Terminal Utility Improvements - Consulting Engineers 2,570,120 390 3902010 62712 C/O Airport Departm■ 2C Terminal Utility Imnprovements - FAA Funds 2,441,614 390 3902010 44105 C/O Airport Departm 2C Terminal Utility Improvements - State Grants 128,506 390 3902010 45701 C/O Airport Departm■ 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 Ranger Heating System - Construction 8,093 390 3902123 73210 C/O Airport Departme 2C Iowa Hanger Heater Replacement - Construction 7 390 3902124 73210 C/O Airport Departm■ 2C Paint Hangar Exteriors - Construction 5,541 390 3902125 73210 C/O Airport Departmm 2C Terminal Boiler Replacement - Construction 9 390 3902126 73210 C/O Airport Departm■ 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 Departmm 2C New Terminal Facility Design - Consulting Engineers 29,381 390 3902213 62712 CIO Airport Departm■ 2C New Terminal Facility Design - FAA Funds 1,716,636 390 3902213 44105 C/O Airport Departmm 2C Old Airline Terminal Assessment - Consultant Engineers 20,044 390 3902214 62712 C/O Airport Departme 2C Replace Runway Regulators - Construction 30,067 390 3902215 73211 C/O Airport Departm 2C New Term Facilities Roads and Aprons - Consultant Services (2,000) 390 3902316 62716 C/O - Prespend FY 12 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 Recylcic 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 &1 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 172,936 172,936 42,929 (789,580) 1149,282) 78.590 14,000 135,096 12,755 8,500 75.827 5,000 13.283 26.900 3,918 23,935 13,194 10.000 2,518,213 34,717 (24,544) 736,773 51,930 79,782 40,000 268,439 Page 13 C/O C/O New Contract C/O C/O C/O C/O C/O C/O 700 7001853 62731 C/O 710 7101339 73211 C/O 710 7101 837 73210 C/O - Prespend FY12 710 7101837 73210 C/O - Prespend FY l2 12,563,555 710 7101837 54230 C/O 710 7101930 73410 C/O 710 7101931 73211 C/O 710 7101931 73410 C/O 710 7102211 62712 C/O 710 7102212 62712 C/O 710 7102212 73210 C/O 710 7102034 62712 C/O 710 7102036 73211 C/O 710 7102149 73211 C/O 710 7101341 62731 C/0 710 7101840 73410 C/O 710 7101935 73410 C/O 710 7102225 73410 C/O 710 7101012 73211 C/O 2,268,000 710 7101012 54210 C/O 710 7101067 62731 C/O 710 7101289 73211 C/O - Prespend FY 12 710 7101293 73510 C/O 218,739 710 7101293 53102 C/O 710 7101294 73211 C/O 710 7101297 62811 C/O 710 7101301 62811 C/O 710 7101301 73510 C/O 1 13- Sep -11 FISCAL YEAR 2012 AMENDMENT #1 CITY'' COUNCIL 13- Sep -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 &1 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 FY12 Engineering 8C I Iwy 20 Annexation Sanitary Sewers - Construction 264,167 710 7101336 73211 CIO 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 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 - Prespcnd FY12 Engineering 8C Catch Basin/Westsidc - Construction Not Building 39,805 720 7201081 73211 C/O Enginccring 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 Stornisewer - Construction 36,310 720 7201363 73211 C/O Enginccring 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 Enginccring 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 - SRI-. GO Bond Proceeds 10,958 720 7201662 54230 CIO 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 Stoinm Sewer Proj - Eng Division Services 11,579 720 7201809 62811 C/O Engineering 8C Villa St Storm Sewer I'roj - 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 Stonn - 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,1 19 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 L 13- Sep -11 FISCAL YEAR 2012 AMENDMENT #1 CITY COUNCIL Department 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 Program Description 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- tamping 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 WATER CONSTRUCTION FUND Water Departmet Water Departmet Water Departmet Water Departmet Water Departmet Water Departmei Water Departmet Water Departmet Water Departmer Water Departmet Water Departmei Water Departmer Water Departmei Water Departmer Water Departmer Water Departmet Water Departmet Water Departmet Water Departmer Water Departmer Water Departmer Water Departmer Water Departmet Water Departmer Water Departmer Water Departmer 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 1I - Eng Division Services 8C Annexation Study - Phase 11- 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 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 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 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 CIO - Fire Headquarters C/O C/O C/O C/O C/O C/O C/O - Prespend FY 12 C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O CIO - Prespend FYI2 C/O - Prespend FYI2 C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O - Prespend FY 12 C/O - Prespend FY12 C/O C/O C/O C/O 13- Sep -11 FISCAL YEAR 2012 AMENDMENT #1 CITY COUNCIL Department Program Water Departmer 8C Water Departmer 8C Water Departmer 8C Water Departmer 8C Water Departmer 8C Water Departmer 8C Water Departmer 8C Water Departmer 8C Water Departmer 8C Water Departmer 8C Water Departmer 8C Water Departmer 8C City Manager 8C City Manager 8C Information Sery 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 Departm Airport Departmt Airport Departnu Airport Departm( Airport Departm( Airport Departm( Airport Departmc Airport Departnu Airport Departm( Airport Departm( Airport Departmt Airport Departmt Airport Departmt Airport Departmt Trans01 Trans01 Trans02 Trans02 Trans03 Trans03 Trans04 Trans04 Trans05 Trans05 Trans06 Trans06 Trans07 Trans07 Trans08 Trans08 Trans09 Trans09 Transl0 Trans10 Transll 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 15,932 Transfer In 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 CIO 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 C/O 740 7402210 62716 C/O 740 7402261 73211 C/O 740 7401402 73210 C/O 740 7401070 62731 C/O 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 13- Sep -11 FISCAL YEAR 2012 AMENDMENT #1 CITY COUNCIL 13- Sep -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 Trans12 Transfer from General Fund to Sanitary Sewer Fund 28,498 101 101 10101 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 Trans 14 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 Trans 15 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 Trans16 Tranfer from Spec. Assessment Fd to Sewer Const Fund 307,000 255 25510255 91710 Trans Funds Engineering Trans16 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 Transl8 Transfer From Sales Tax 20% Fd to Stormwater Const. Fund 13,800 720 7201666 59350 Trans Funds Engineering Trans I9 Transfer from Spec. Assessment Fund to Street Const. Fund 255,217 255 25510255 91300 Trans Funds Engineering Transl9 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 Trans2l 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 101 10101 91100 Trans Funds Engineering Trans23 Transfer from DRA Gaming to General Fund 7,716 100 1001 141 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 41 with Enc, C /O's, and New 124,829,205 99,299,883 Page 18 It 97 Form 653.C1 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, by changing estimates of revenue and expenditure appropriations in the following programs for the reasons given. Additional detail is available at the city clerk's office showing revenues and expenditures by fund type and by activity. 2012 (year) 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. Kevin S Firnstahl City Clerk 475876- O1A49 -7 STATE OF IOWA {SS: DUBUQUE COUNTY CERTIFICATION OF PUBLICATION I, Suzanne Pike, a Billing Clerk for Woodward Communications, Inc., an Iowa corporation, publisher of the Telegraph Herald,a newspaper of general circulation published in the City of Dubuque, County of Dubuque and State of Iowa; hereby certify that the attached notice was published in said newspaper on the following dates: September 07, 2011, and for which the charge is $127.75. r) l -tot IAAA-C_ fu Subscribed to before me, a No y Public in and for Dubuque County, Iowa, this 9 day 20 ,/ . ■ Notary Public in and for Dubuque County, Iowa. MARY K. WESTERME`i Commission Number 154 Total Budget as certified or last amended Current Amendment Total Budget after Current Amendment Revenues & Other Financing Sources 20,559,847 0 20,559,847 Taxes Levied on Property 1 Less: Uncollectted Property Taxes -Levy Year 2 0 0 0 Net Current Property Taxes 3 20,559,847 0 20,559,847 Delinquent Property Taxes 4 0 0 0 TIF Revenues 5 10,151,097 0 10,151,097 Other City Taxes 6 14,904,342 0 14,904,342 Licenses & Permits 7 1,254,672 0 1,254,672 Use of Money and Properly 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 Protects 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 I Enterprises 24 76,139,146 181,661,614 38,562,757 117,963.461 114,701,903 299,625,075 Total Gov Activities & Business Expenditures 25 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 for Fiscal Ye. 28 - 3,572,952 - 25,529,322 - 29,102,274 Continuing Appropriation 29 0 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. Kevin S Firnstahl City Clerk 475876- O1A49 -7 STATE OF IOWA {SS: DUBUQUE COUNTY CERTIFICATION OF PUBLICATION I, Suzanne Pike, a Billing Clerk for Woodward Communications, Inc., an Iowa corporation, publisher of the Telegraph Herald,a newspaper of general circulation published in the City of Dubuque, County of Dubuque and State of Iowa; hereby certify that the attached notice was published in said newspaper on the following dates: September 07, 2011, and for which the charge is $127.75. r) l -tot IAAA-C_ fu Subscribed to before me, a No y Public in and for Dubuque County, Iowa, this 9 day 20 ,/ . ■ Notary Public in and for Dubuque County, Iowa. MARY K. WESTERME`i Commission Number 154