Loading...
First Budget Amendment Fiscal Year 2010Dubuque THE CITY OF Dj TjZ ~ A~AmerlcaCi~ ~J lJ i Masterpiece on the Mississippi 2007 September 16, 2009 TO: The Honorable Mayor and City Council Members FROM: Michael C. Van Milligen, City Manager SUBJECT: Fiscal Year 2010 First Budget Amendment Budget Director Jennifer Larson is recommending approval of the first Fiscal Year 2010 Budget Amendment, which amends the Fiscal Year 2010 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 2009 budget carryovers to Fiscal Year 2010 of encumbrances totaling $14,866,196, capital projects totaling $53,687,781that were not completed during the prior Fiscal Year, and associated revenues totaling $38,559,719. There are operating budget appropriation carryovers of $939,737 and operating receivables of $2,152,392. Also, total transfers between funds of $10,845,998 are reflected. I concur with the recommendation and respectfully request Mayor and City Council approval. Mic ael C. Van Milligen MCVM/JML Attachment cc: Barry Lindahl, City Attorney Cindy Steinhauser, Assistant City Manager Jennifer Larson, Budget Director THE CTTY E3F Dubuque -~~ DT TR ~ AIaAm~IcaCAy ~J i.J ' / Masterpiece on the Mississippi I 2007 September 1, 2009 TO: Michael C. Van Milligen, City Manager FROM: Jennifer Larson, Budget Director~~e SUBJECT: Fiscal Year 2010 First Budget Amendment The purpose of this memorandum is to provide an explanation regarding the first amendment for Fiscal Year 2010. This amendment is two fold. First, it amends the Fiscal Year 2010 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 2009 budget carryovers to Fiscal Year 2010 of encumbrances totaling $14,866,196, capital projects totaling $53,687,781 that were not completed during the prior Fiscal Year, and associated revenues totaling $38,559,719. There are operating budget appropriation carryovers of $939,737 and operating receivables of $2,152,392. Also, total transfers between funds of $10,845,998 are reflected. CARRYOVER AMENDMENT TO FISCAL YEAR 2010 During Fiscal Year 2009, a large number of projects were completed, which include finalizing additional America's River Projects, Police Mobile Data Computers, Fire Station #2 and #5 Interior and Exterior Improvements, Playground Improvements, Heron Pond Improvements, Town Clock Renovation, Park Maintenance Headquarters Improvements, Eagle Point Park Improvements, Skate Park Rebuild Ramps, Veterans Restroom Building, Carver Elementary School Play Unit, Five Flags Roof Replacement, Flora Pool Ozone Disinfectant, Bunker Cart Paths, Pond Renovation, and Fairway & Tee Mower, Replacement of Pool Drains, Water Shallow Well Rehab, Water Meter Replacement Program Study, Water Pollution Control Plant Final Clarifier Drive Replacement, Port of Dubuque Public Parking Ramp, Walkway from Iowa Ramp to NICC, Parking Locust Office Remodel, Airport Terminal Land Acquisition, Airport Asphalt Parking Lots, Transit System Study, Bee Branch Pump Auxiliary, Public Works Fleet GPS Project, Public Works Bucket Truck, Endloader, Dump Truck and Asphalt Paver Replacements, Floodwall Levee Slope Repair, West 32"d Street Detention Basin, Renovation of Economic Development/Sustainability Community Coordinator/Budget Offices, Grove Terrace Retaining Wall, High BlufflThomas Place Retaining Wall, St. Mary's Retaining Wall, Ice Harbor Transient Boat Docks, East/West Corridor Study, North Siegert Farm Phase I, Downtown Design Guidelines, Zoning Code Update, City Website Redesign and Enhancement, and City Phone System Upgrade. Many other enhancements are reflected throughout the community. Some significant projects were started and remain in process, which are carried forward into Fiscal Year 2010. The most significant of the capital project expenditure carryovers, including associated revenue, are: Sanitary Sewer System Improvements ($6,781,924); Rivers to the Sea Exhibit ($6,202,815); Airport Terminal Land Acquisition and Construction ($3,450,886); Storm Water System Improvements ($9,048,088); Transient Docks -Main Channel ($3,784,064); Southwest Arterial ($5,475,336); Traffic/Fiber Improvements ($2,206,623); Community Development Block Grant funded projects ($823,508); Water System Improvements ($2,186,780); Park Projects ($1,837,554); Bridge Improvements ($534,488); America's River Project ($678,153); Refuse Dual Packer Recycle Vehicles ($662,079); Homeownership Grants -Targeted Neighborhoods ($354,128); and Ice Harbor Maintenance/Dredging ($140,299). OPERATING BUDGET CARRYOVER AMENDMENT The most significant operating budget carryovers into Fiscal Year 2010 include such items as Library Materials ($40,827); Police Department Grants ($42,614); Human Rights Grant Appropriation ($57,080); Fire CPAT Costs ($31,160); Information Services Equipment and Training ($77,421); City Clerk Code Update and Civil Service Tests ($50,000); Transit Equipment ($62,379); Engineering Software and Education and Training ($36,623); Airport Radar Maintenance Fee ($25,000); Building Washington Neighborhood Alley Light Grant Program ($35,000); and Community Development Block Grant ($55,210). FIRST AMENDMENT TO THE FISCAL YEAR 2010 CERTIFIED BUDGET There have been numerous actions by City Council and changes requiring amendments for the Fiscal Year 2010 budget. The capital budget amendments total $594,084, with an increase in associated revenue of $3,990,765. The amendment items include: Green Alley Pilot Project ($246,202) funded by Community Development Block Grant -Recovery; Northwest Hike/Bike Trail ($157,392) from a REAP Grant; Public Works Street Sweeper ($165,000) from Fire Headquarters Green Roof Project; Multicultural Family Center ($93,457) from East/West Corridor Study and Port of Dubuque Outdoor Plaza savings; Library Renovation ($250,000) funded by an Iowa Great Places Grant; Millworking District Streetscape ($150,000) funded by an Iowa Great Places Grant; Hempstead Safety Improvements ($500,000) funded by an Iowa Department of Transportation grant; a reduction to the budget of North Siegert Farm to reflect actual project cost (-$1,400,000); North Fork Catfish Interceptor Reconstruction FEMA grant ($1,665,513); and Housing Trust, Homeless Prevention, and Neighborhood Stabilization Grants ($1,279,741) funded by various Federal and State grants. OPERATING BUDGET AMENDMENT The operating budget amendments total $904,644, with associated increase in revenue of $1,019,517. The amendment items include new Police Grants ($500,068); Community Development Block Grant -Recovery Funds ($328,369); AmeriCorps American Recovery and Reinvestment Act Grant ($184,344); Washington Neighborhood Development Corporation ($100,000) funded from Homeownership Grants -Targeted Neighborhoods; and Advertising for the 2010 Census ($25,000) from FY 2009 Department Savings; The action step is for City Council to adopt the attached resolution approving the FY 2010 first budget amendment. Attachments JML ~~ I i ~ ~ ~~ ~ ~~; CITY BUDGET AMENDMENT AND CERTIFICATION RESOLUTION To the Auditor of DUBUQUE County, Iowa: The City Council of DUBUQUE in said County/Counties met on 9/21/09 ,at the place and hour set in the notice, a copy of which accompanies this certificate and is certified as to publication. Upon taking up the proposed amendment, it was considered and taxpayers were heard for and against the amendment. The Council, after hearing all taxpayers wishing to be heard and considering the statements made by them, gave final consideration to the proposed amendment(s) to the budget and modifications proposed at the hearing, if any. thereupon, the following resolution was introduced. RESOLUTION No. 363-09 A RESOLUTION AMENDING THE CURRENT BUDGET FOR THE FISCAL YEAR ENDING JUNE : 2010 (AS AMENDED LAST ON .) Be it Resolved by the Council of the City of DUBUQUE Section 1. Following notice published and the public hearing held, 9/21/09 the current budget (as previously amended) is amended as set out herein and in the detail by fund type and activity that supports this resolution which was considered at that hearing: Total Budget as certified or last amended Current Amendment Total Budget after Current Amendment r R ven es & O her Financin Sou ces e u t 9 ~ . Taxes Levied on Property 1 18,331,912 0 18,331,912 Less: Uncollectted Property Taxes-Levy Year 2 0 0 0 Net Current Property Taxes 3 18,331, 912 0 18,331, 912 Delinquent Property Taxes 4 0 0 0 TIF Revenues 5 6,610,851 0 6,610,851 Other City Taxes 6 13,913,509 0 13,913,509 Licenses & Permits 7 1,336,745 0 1,336,745 Use of Money and Property 8 12,833,420 3,162 12,836,582 Intergovernmental 9 32,378,001 28,976,442 61,354,443 Charges for Services 10 27,378,276 44,000 27,422,276 Special Assessments 11 278,000 1,321,650 1,599,650 Miscellaneous 12 6,350,736 1,900,815 8,251,551 other Financing Sources 13 101,166,396 24,322,322 125,488,718 Total Revenues and other Sources 14 220,577,846 56,568,391 277,146,237 i r h r Financin Uses Ex end to es & Ot e p 9 ~ Public Safety 15 21,766,430 900,829 22,667,259 Public Works 16 11,593,287 280,110 11,873,397 Health and Social Services 17 847,063 111,332 958,395 Culture and Recreation 18 8,955,550 104,979 9,060,529 Community and Economic Development 19 11,584,447 658,272 12,242,719 General Government 20 6,547,820 315,537 6,863,357 Debt Service 21 5,970,043 0 5,970,043 Capital Projects 22 30,619,440 44,707,574 75,327,014 Total Government Activities Expenditures 23 97,884,080 47,078,633 144,962,713 Business Type /Enterprises 24 70,940,795 23,913,809 94,854,604 Total Gov Activities & Business Expenditures 25 168,824,875 70,992,442 239,817,317 Transfers Out 26 56,921,932 10,845,998 67,767,930 Total Expenditures/Transfers Out 27 225,746,807 81,838,440 307,585,247 Ex es Revenues & Other Sources Over c s (Under) Expenditures/Transfers Out Fiscal Year 28 -5,168,961 -25,270,049 -30,439,010 Continuing Appropriation 29 0 N/A 0 Beginning Fund Balance July 1 30 30,078,556 13,520,014 43,598,570 Ending Fund Balance June 30 31 24,909,595 -11,750,035 13,159,560 ,. . .... ,; r r T- ~ f ~'~ Signature €, ' City Clerk/Finance Officer Passed thS 2~st (Day) day of September, ?.009 ~ ~~ ....,.. < , .. - -.-_®} - l Signature ~~! Mayor Pro-Tem FISCAL YEAR 2010 AMENDMENT #1 14-Sep-09 Department Program Description FY 10 FY 10 Expense Revenue Amount Amount Fund Activity/CIP Account Explanation GENERAL FUND Police Departme: 1 C Comp Storage System-Tape/SAN -County Share 69,039 101 1011752 46205 Police Departme: 1 C In-Car Video Recorders -Equipment Acquisition 30,575 101 1011580 73410 Police Departme: 1C Dbq Police Firearms Range -R.O.W. 7,500 101 1011589 73113 Police Departme: 1 C Dbq Police Firearms Range -Construction 20,000 101 1011589 73211 Police Departme: I C Police Admin Office Remodel -Equipment Acquisition 30,000 1 O 1 1011863 73410 Police Departme: 1C Police Admin Office Remodel -Consulting Engineers 9,383 101 ]Ol 1863 62712 Police Departme: 1C Police Admin Office Remodel -Construction 64,776 101 1011863 73210 Police Departme: ] Drug Task Force Grant 13,444 100 10011321 44140 Police Departme: 1 Drug Task Force Grant 4,851 100 10011321 61051 Police Departme: 1 2009 Byrne-JAG Stimulus Grant 137,022 100 10011321 45771 Police Departme: 1 2009 Byrne-JAG Stimulus Grant 137,022 100 10011321 62761 Police Departme: 1 Helping Services of IA Grant -Underage Alcohol 2,570 100 10011324 45771 Police Departme: 1 Helping Services of IA Grant -Underage Alcohol (6,580) 100 10011324 61051 Police Departme: 1 Bulletproof Vest Grant - 2006 68 100 10011702 44120 Police Departme: ] Bulletproof Vest Grant -2007 1,917 100 10011703 44120 Police Departme: 1 Bulletproof Vest Grant - 2008 9,510 100 10011704 44120 Police Departme: 1 Governor's Traffic Safety Bureau Grant 16,090 100 10011773 44125 Police Departme: 1 2007 Justice Assistance Grant 19,809 100 10011752 61051 Police Departme: 1 2006 Justice Assistance Grant (18,500) 100 10011753 61051 Police Departme: 1 2008 Justice Assistance Grant 17,954 100 10011774 61051 Police Departme: 1 2008 Justice Assistance Grant (6,540) 100 10011774 72218 Police Departme: 1 2008 Justice Assistance Grant (11,260) 100 10011774 61050 Police Departme: 1 2008 Justice Assistance Grant (2,240) 100 10011774 62671 Police Departme: 1 Domestic Abuse Grant 1,565 100 10011754 44135 Police Departme: 1 Domestic Abuse Grant 2,726 100 10011754 44135 Police Departme: 1 Domestic Abuse Grant 2,726 100 10011754 61051 Police Departme: 1 2009 Justice Assistance Stimulus Grant 360,320 100 10011740 44175 Police Departme: 1 2009 Justice Assistance Stimulus Grant -Pay to Other Agency 46,897 100 10011754 62761 Police Departme: 1 2009 Justice Assistance Stimulus Grant -Reimbursable OT 313,423 100 10011754 62761 Police Departme: 1 Police Administration -Other Medical Costs 12,005 100 10011100 61675 Police Departme: 1 Staff Services -Desks/Chairs 12,348 100 10011190 71211 Police Departme: 1 Staff Services -Partitions 1,480 100 10011190 71224 Police Departme: 1 Police Training -Training for Early Hires 13,572 100 10011250 62360 Police Departme: 1 Criminal Investigation -Lighting Equipment 1,200 100 10011300 71517 Police Departme: 1 Police Patrol -Police Honor Guard Dress Jackets 1,680 100 10011700 62011 Police Departme: 1 Police Patrol -Motor Vehicle MainUOutsourcing 1,764 100 10011700 62528 Police Departme: 1 Police Patrol - Machine/Equipment Outsourcing 5,010 100 10011700 62611 Police Departme: 1 Police Patrol -Vehicle Replacement 10,899 100 10011700 71310 Police Departme: 1 Police Patrol - Visibars 3,148 100 10011700 72210 Police Departme: 1 Police Patrol - Pager/Radio Equipment 14,434 100 10011700 72410 Police Departme: 1 Police Patrol -Camera Related 5,400 100 10011700 72417 Emergency Comi 1 Emergency Communication Center -Desks/Chairs 3,825 100 10012100 71211 C/O C/O C/O C/O C/O C/O C/O C/O C/O New Grant New Grant Appropriation C/O Adjust budget to actual C/O C/O C/O C/O C/O Adjust budget to actual C/O Adjust budget to actual Adjust budget to actual Adjust budget to actual C/O New Grant New Grant Appropriation New Grant New Grant Appropriation New Grant Appropriation C/O - FY09 expenses paid in FY10 C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O Page 1 FISCAL YEAR 2010 AMENDMENT #1 14-Sep-09 FY 10 FY 10 Expense Revenue Department Program Description Amount Amount Fund Activity/CIP Account Explanation Emergency Come 1 Emergency Communication Center -Travel Conferences 3,917 100 10012100 62310 C/O Emergency Conn 1 Emergency Communication Center -Education and Training 1,466 100 10012100 62360 C/O Fire Department 1 C Pumper Replacement 17,198 101 1011016 71318 C/O Fire Department 1C Foam Trailer -Federal Grant (48,000) 101 1012095 44170 Grant received in FY09 Fire Department 1 C Station #4 Improvements 88,962 101 1011460 73210 C/O Fire Department 1C Fire Station Expansion/Relocation 650,000 101 1011864 54205 C/O Fire Department 1C Fire Station Expansion/Relocation 603,059 101 1011864 73211 C/O Fire Department 1 Administration -Miscellaneous Services - CPAT costs 31,160 100 10013100 62731 C/O Human Rights 3 Human Relations -Education & Training (2,180) 100 10016100 62360 Prespend FY 10 Budget Human Rights 3 Human Relations -Travel & Conferences (2,180) 100 10016100 62310 Prespend FY10 Budget Human Rights 3 Human Relations -Media Plan Printing & Binding 19,750 100 10016100 62090 C/O Human Rights 3 Human Relations -Miscellaneous Services 14,900 100 10016100 62731 C/O Human Rights 3 Human Relations -Consultant Services 3,146 100 10016100 62716 C/O -Department Brochures Human Rights 3 Human Rights Grant-Misc Services 7,200 100 10016200 62731 C/O Fair Housing Grant Exp Human Rights 3 Human Rights Grant-Fair Housing Training 32,200 100 10016200 62753 C/O Fair Housing Grant Exp Human Rights 3 Human Rights Grant-Training & Education 3,524 100 10016200 62360 C/O Fair Housing Grant Exp Human Rights 3 Human Rights Grant-Printing & Binding 14,156 100 10016200 62090 C/O Fair Housing Grant Exp Health Services 3 Lead Paint Program -Childhood Lead Poisoning Grant 7,063 100 10017500 45771 C/O -Childhood Lead Grant Health Services 3 Health Services Administration -Travel & Conferences 3,804 100 10017100 62310 C/O Health Services 3 Health Services Administration -Travel & Conferences (125) 100 10017100 62310 Prespend FY10 Budget Health Services 3 Health Services Administration -Misc Services -Urban Deer 1,944 100 10017100 62731 C/O Health Services 3 Animal Control -Education & Training - NACA Training 2,541 100 10017200 62360 C/O Health Services 3 Insp. -Food Establishments -Travel & Conferences 224 100 10017300 62310 C/O Health Services 3 Insp. -Food Establishments -Travel & Conferences (275) 100 10017300 62310 Prespend FY10 Budget Health Services 3 Community Health Service - Prepazedness Grant 4,904 100 10017400 45771 C/O Health Services 3 Community Health Service -Laptop Computer 2,326 100 10017400 71124 C/O Parks Division 4 Greenhouse Activity -Other Maintenance Equipment 1,500 100 10030500 71619 C/O Pazks Division 4 Park Areas & Maintenance -Water Fountains 6,000 t00 10030400 73411 C/O Parks Division 4 Park Areas & Maintenance -Leaf Blower 12,000 100 10030400 71619 C/O Pazks Division 4C Old Park Blueprint Preservation -Consultant Services 10,000 100 1002176 62716 From Petrakis Infield Project Pazks Division 4C HWY 20 Landscape Design 17,987 100 1001114 73310 C/O Parks Division 4C Murphy Park Maintenance Building 10,000 101 1011189 73210 C/O Parks Division 4C Flora Park Storm Sewer Extension - Eng Division Svc 8,583 101 1011211 6281 I C/O Parks Division 4C Flora Park Storm Sewer Extension -Construction 32,901 101 1011211 73211 C/O Pazks Division 4C Westbrook Park Development -Eng. Division Sacs 17,000 101 1011582 62811 C/O Pazks Division 4C Westbrook Park Development -Construction 62,200 101 1011582 73211 C/O Pazks Division 4C Highway 20 Water on Corners -Construction 5,000 102 1021606 73211 C/O Parks Division 4C Roosevelt Park Design Study 10,000 100 1001739 62711 C/O Pazks Division 4C EPP Storm Sewer Work -Construction 50,000 102 1021760 73210 C/O Pazks Division 4C Main. HQ/Greenhouse Improvements -Construction 27,500 102 1021776 73210 C/O Pazks Division 4C Well Park Development-Construction 15,152 102 1021865 73211 C/O Parks Division 4C McAleece Storage Building 16,208 101 1011872 73211 C/O Pazks Division 4C Ham House Museum Drainage -Construction 11,500 101 1011882 73211 C/O Pazks Division 4C Dubuque History Trail -Federal Grants 148,500 100 1001956 44170 C/O Page 2 FISCAL YEAR 2010 AMENDMENT #1 14-Sep-09 FY 10 FY 10 Expense Revenue Department Program Description Amount Amount Parks Division 4C Dubuque History Trail -Consultant Services 14,850 Pazks Division 4C Dubuque History Trail -Equipment Acquisition 133,650 Pazks Division 4C Marshall Park -Pool Repair 20,000 Parks Division 4C Erosion Control Study 50,000 Parks Division 4C Trolley Line Trail -EPP -State REAP Grant 20,000 Parks Division 4C Trolley Line Trail -EPP -Consultant Services 164,868 Pazks Division 4C Catfish Creek Hike-Bike Trail Study -Consultant Services 15,400 Parks Division 4C Dubuque Community Ice Arena -Pay to Other Agency 50,000 Pazks Division 4C Mines of Spain Exhibit -Private Participant 150,000 Pazks Division 4C Mines of Spain Exhibit -Federal Grant 150,000 Parks Division 4C Mines of Spain Exhibit -Construction 300,000 Parks Division 4C EB Lyons Expansion 19,000 Parks Division 4C EB Lyons Expansion 19,000 Pazks Division 4C EB Lyons Expansion 440,000 Parks Division 4C EB Lyons Expansion 440,000 Recreation Divis 4C Flora Pool Paint Filter Tank 36,049 Library Departm 4C Library Window Treatments 6,578 Library Departm 4C Audio-Visual ListeningNiewing Stations -Equip. Acquisition 7,716 Library Departm 4C Library Landscaping 1,530 Library Depaztm 4 Children Services-Library Books 945 Library Departm 4 Library Administration -Education & Training (1,383) Library Departm 4 Library Administration -Travel & Conferences (300) Library Departm 4 Children Services-Speakers/Programs (256) Library Departm 4 Children Services-Video Materials 2,192 Library Departm 4 Children Services-Misc Operating Supplies 135 Library Deparhn 4 Children Services-Misc Operating Supplies (100) Library Departm 4 Children Services-Education & Training (480) Library Departm 4 Maintenance Services-Misc Operating Supplies 45 Library Departm 4 Adult Services - Misc Op Supplies 20 Library Departm 4 Adult Services - Library Cont/Serials 6,028 Library Departm 4 Adult Services - Library Cont/Serials 5,000 Library Departm 4 Adult Services - Librazy Books 5,059 Library Depaztm 4 Adult Services -Library Books (5,000) Library Departm 4 Adult Services - Videos 24,065 Library Departm 4 Adult Services -Office Equipment Maint 186 Library Departm 4 Adult Services - AudioNisuals 184 Library Departm 4 Circulation Services - Bill Collection Services 442 Library Departm 4 Technical Services - Library Books 322 Library Departm 4 Technical Services -Data Processing 1,364 Library Departm 4 Adult Services-DVDNideo 272 Library Departm 4 Adult Services-Library Books 1,494 Library Departm 4 Adult Services-AudioNisual 180 Library Departm 4 Adult Services-Periodicals 30 Library Departm 4 Youth Services-Library Books 383 Page 3 Fund Activity/CIP 100 1001956 100 1001956 101 1011983 100 1001987 100 1001989 100 1001989 101 1012078 100 1002084 100 1002056 100 1002056 100 1002056 100 1002171 100 1002171 100 1002171 100 1002171 101 1011999 100 1001570 101 1011786 100 1002006 100 10036210 100 10036100 100 10036100 100 10036210 100 10036210 100 10036210 100 10036210 100 10036210 100 10036300 100 10036200 100 10036200 100 10036200 100 10036200 100 10036200 100 10036200 100 10036200 100 10036200 100 10036220 100 10036500 100 10036500 100 10036200 100 10036200 100 10036200 100 10036200 100 10036210 Account 62716 73411 73211 62712 45701 73211 62716 62761 53102 44170 73210 73210 45771 73210 45761 73211 73410 73410 62712 62651 62360 62310 62734 62659 62671 62671 62360 62671 62671 62654 62654 62651 62651 62659 62050 62652 62725 62651 62660 62659 62651 62652 62653 62651 Explanation C/O C/O C/O C/O C/O C/O C/O Shift from various projects 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 FY10 Budget Prespend FY10 Budget Prespend FY10 Budget C/O C/O Prespend FY10 Budget Prespend FY10 Budget C/O C/O C/O From Library Books C/O Shift to Video Materials C/O C/O C/O C/O C/O C/O C/O -Lost Book Revenue-FY09 C/O -Lost Book Revenue-FY09 C/O -Lost Book Revenue-FY09 C/O -Lost Book Revenue-FY09 C/O -Lost Book Revenue-FY09 FISCAL YEAR 2010 AMENDMENT #1 14-Sep-09 FY 10 FY 10 Expense Revenue Department Program Description Amount Amount Fund Activity/CIP Account Explanation Airport Departm~ 2 Airport Administration-TDD Telephone 540 100 10051100 72418 C/O Airport Departm~ 2 Airport Administration-Furniture 1,500 100 10051100 71156 C/O Airport Departm~ 2 Airport Operations Signage 6,000 100 10051400 71227 C/O Airport Departm~ 2 Airport Operations Misc Services -Radar Maint Fee 25,000 100 10051400 62731 C/O Airport Departm~ 2 Airport Operations Pressure Sprayer 8,000 100 10051400 71421 C/O Airport Departm~ 2 Terminal Building Maint Custodial Equipment 500 100 10051700 71610 C/O Airport Departm~ 2C Safety Management Systems Grant 50,405 100 1001969 44105 C/O Airport Departm~ 2C Safety Management Systems Grant 87,966 100 1001969 73211 C/O Public Works 2 Street & Traffic Lighting -Traffic Control Equipment 1,390 100 10054430 71411 C/O Public Works 2C NW HikeBike Trail -REAP Grant 200,000 100 1001157 45707 New Grant Public Works 2C NW HikeBike Trail -REAP Grant 157,392 100 1001157 62716 New Grant Appropriation Public Works 2C Floodwall Levee Slope -Construction 43,280 100 1002042 73211 Adjust to Actual Cost Public Works 2C Bi-Lingual Trail Signage 22,925 100 1002169 71227 C/O Public Works 2C Bi-Lingual Trail Signage 33,305 100 1002169 45701 C/O Public Works 2C PW Fleet GPS Project -Pager/Radio Equipment 5,614 101 1011935 72410 C/O Engineering 2 Engineering Administration -Micro Computer 2,500 100 10055100 71124 C/O Engineering 2C Riverwalk Security Camera System -Camera Equipment 27,704 100 1001963 72417 C/O Engineering 2C Federal Building Renovation -Construction (5,726) 100 1001841 73210 PO Adjustment Engineering 2C Federal Building Renovation -Signage (24,828) 100 1001841 71227 PO Adjustment Engineering 2C Federal Building Renovation -Consulting Eng (6,221) 100 1001841 62712 PO Adjustment Engineering 2C Rivers to the Sea Exhibit -Construction 5,583,235 100 1001856 73210 C/O Engineering 2C Rivers to the Sea Exhibit -Consultant Services 619,580 100 1001856 62716 C/O Engineering 2C Rivers to the Sea Exhibit -State Grant 5,000,000 100 1001856 45771 C/O Engineering 2C Rivers to the Sea Exhibit -Private Participant 1,250,000 100 1001856 53102 C/O Engineering 2C Sewer Conn Asst -Low/Mod -Miscellaneous Services 15,000 100 1001067 62731 C/O Engineering 2C Sidewalk Repair/Maintenance 30,224 100 1001108 73211 C/O Engineering 2C Decorative Concrete Maint -Construction 56,787 102 1021630 73211 C/O Engineering 2C Rockdale Corridor Study -Consulting Engineers 100,000 100 1001818 62712 C/O Engineering 2C Derby Grange Intersection -Consultant Services (175) 100 1002086 73211 Prespend FY 10 Project Engineering 2C Heeb Street Wall -Construction 210,374 100 1002086 73211 C/O Engineering 2C Garfield Wall -Construction 119,662 100 1002087 73211 C/O Engineering 2C Fiber Optic Conduit Project -Construction 48,875 102 1021017 73211 C/O Engineering 2C Accessibility Barriers -Eng Division Services 2,500 101 1011034 62811 C/O Engineering 2C Accessibility Barriers -Construction 35,957 101 1011034 73210 C/O Engineering 2C Corridor Study/Alternates- Consulting Eng. 48,069 100 1001039 62712 C/O Engineering 2C Fiber Conduit NW Arterial -Construction 11,460 100 1001113 73211 C/O Engineering 2C Burlington Depot Restoration 27,181 100 1001201 73210 C/O Engineering 2C Tourism Signage Program -HRDP State Grant 3,000 100 1001512 45701 C/O Engineering 2C Tourism Signage Program -Signage 26,704 102 1021512 71227 C/O Engineering 2C Downtown St Light Replacement -Eng Division Svc 3,862 102 1021608 62811 C/O Engineering 2C Fiber Optic Con -Priv &Misc -Eng Division Svc 66,653 102 1021609 62811 C/O Engineering 2C Fiber Optic Con -Priv &Misc -Construction 168,963 102 1021609 73211 C/O Engineering 2C Shot Tower Restoration -Construction 177,406 100 1001854 73211 C/O Page 4 FISCAL YEAR 2010 AMENDMENT #1 14-Sep-09 FY 10 FY 10 Expense Revenue Department Program Description Amount Amount Fund Activity/CIP Account Explanation Engineering 2C Shot Tower Restoration -Construction 54,670 100 1001854 73211 Add Contingency Funds Engineering 2C Shot Tower Restoration -State Grant 100,000 100 1001854 45701 C/O Engineering 4C Library Renovation -Construction 430,703 100 1001141 73210 C/O Engineering 4C Library Renovation -Construction (276,000) 100 1001141 73210 Remove FY10 Contingency Budget Engineering 4C Library Renovation -Iowa Great Places Grant 250,000 100 1001141 45701 New Grant Engineering 4C Library Renovation -Bond Interest Earnings 3,162 100 1001141 43110 Bond Proceeds Earnings Engineering 4C Library Renovation -Contributions 37,066 100 1001141 53103 Library Pledges Received Engineering 2C Transient Docks -Main Channel -Consulting Engineers 624,895 101 1011861 62712 C/O Engineering 2C Safes Routes to School - Const Contract Not Building 9,733 101 1011922 73211 C/O Engineering 2C Woodward Museum Restoration -Fed Pass Thru Grant 185,849 100 1001967 45771 C/O Engineering 2C Woodward Museum Restoration -Private Part. -DCHS 58,271 100 1001967 53102 C/O Engineering 2C Woodward Museum Restoration 242,161 100 1001967 73210 C/O Engineering 2C Railroad Depot Phase II-Fed Pass Thru Grant 15,179 100 1001968 45771 C/O Engineering 2C Railroad Depot Phase II -Private Part. -DCHS 3,795 100 1001968 53102 C/O Engineering 2C Railroad Depot Phase II 18,507 100 1001968 73210 C/O Engineering 2C Hempstead Safety Improvements - Const Contract Not Bldg 529,280 101 1012077 73211 C/O Engineering 2C Hempstead Safety Improvements -State Traffic Grant 500,000 101 1012077 45701 New Grant Engineering 2C Hempstead Safety Improvements -Private Participation 47,602 101 1012077 53102 Dubuque Community School District Engineering 2C Traffic Signal Mastarm Rep. -Eng Division Services 14,048 101 1011133 62811 C/O Engineering 2C Traffic Signal Mastarm Rep. -Construction 79,383 101 1011133 73211 C/O Engineering 2C Street Light Replacement -Eng Division Serv 8,986 100 1001549 62811 C/O Engineering 2C Street Light Replacement -Construction 13,087 100 1001549 73211 C/O Engineering 2C Street Light Replacement -Eng Division Serv 9,840 101 1011549 62811 C/0 Engineering 2C Street Light Replacement -Construction 1,569 101 1011549 73211 C/O Engineering 2C Recon Signals/JFK-Wacker -Eng. Division Services 23,967 101 1011919 62811 C/O Engineering 2C Recon Signals/JFK-Wacker -Construction 150,000 101 1011919 73211 C/O Engineering 2C 5 Points Intersection Signal -Eng. Division Services 10,000 102 1021920 62811 C/O Engineering 2C 5 Points Intersection Signal -Construction 85,000 102 1021920 73211 C/O Building Service 1 Building Services Admin -Eng Division Services 35,000 100 10057100 67765 C/O Building Service 1 Building Services Admin -Software 17,982 100 10057100 71123 C/O Economic Devlo SC Brownfields Grant -Consulting Engineers 3,865 100 1001111 62712 C/O Economic Devlo SC Port of DBQ- Develop.Standards (Int Write Down) 35,353 100 1001207 62764 C/O Economic Devlo SC Port of DBQ- Develop.Standards (Int Write Down) 15,000 102 1021207 62764 C/O Economic Devlo 5 Economic Development -Pay to other agency 30,000 100 10060700 62761 Hotel/Motel for Julien Per Agreement Housing & Comi SC Maint of Vacant/Abandoned -Property Maintenance 132,786 100 1001002 73210 C/O Housing & Comt SC Housing Trust - IA Finance -Grants 333,875 100 1001021 62765 New Grant Appropriation Housing & Comt SC Housing Trust - IA Finance 350,000 100 1001021 54205 New Grant Housing & Comt SC Historic Preservation Revolving Loan 200,000 100 1001247 54210 C/O Housing & Comt SC Historic Preservation Revolving Loans 197,808 100 1001247 62764 C/O Housing & Comt SC Homeownership Grants -Target 354,128 101 1011595 62765 C/O Housing & Comt SC Downtown Plan Implementation 41,477 101 1011596 62716 C/O Housing & Comt SC Homeless Prevention Grant 501,538 100 1002175 62360 New Grant Appropriation Housing & Conu SC Homeless Prevention Grant -Grant 502,294 100 1002175 44170 New Grant Housing & Comp 5 445 Loras -Property Maintenance 13,851 100 10061710 62431 C/O Page 5 FISCAL YEAR 2010 AMENDMENT #1 14-Sep-09 FY 10 Expense Department Program Description Amount Housing & Conn 5 Housing Administration -Consultant Services 25,000 Housing & Corm 6 Federal Building Maintenance -Property Maintenance 21,441 Housing & Corm 5 Americorp -State Pass Thnt Grants Housing & Corm 5 AmeriCorps -Private Participant Housing & Corm 5 AmeriCorps ARRA -State Pass Thru Grants Housing & Corm 5 AmeriCorps 2 -State Pass Thru Grants Housing & Corm 5 AmeriCorps 2 -Private Participant Housing & Conu 5 AmeriCorps 3 -State Pass Thru Grants Housing & Corm 5 AmeriCorps 3 -Private Participant Housing & Coma 5 AmeriCorps -Part-time wages (44,968) Housing & Court 5 AmeriCorps -Seasonal wages (128,755) Housing & Corm 5 AmeriCorps -IPERS (2,990) Housing & Court 5 AmeriCorps -Social Security (13,290) Housing & Corm 5 AmeriCorps -Worker's Compensation (731) Housing & Corm 5 AmeriCorps -Part-time wages (5,285) Housing & Court 5 AmeriCorps -Miscellaneous (5,400) Housing & Corm 5 AmeriCorps -Social Security (1,755) Housing & Comr 5 AmeriCorps -Mileage (880) Housing & Corm 5 AmeriCorps -Education & Training (8,500) Housing & Corm 5 AmeriCorps -Misc. Operating Expense (12,987) Housing & Corm 5 AmeriCorps - ARRA -Part-time wages 174,347 Housing & Corm 5 AmeriCorps - ARRA -Social Security 13,338 Housing & Comr 5 AmeriCorps - ARRA -Uniforms 1,050 Housing & Comr 5 AmeriCorps - ARRA -Miscellaneous 2,658 Housing & Comr 5 AmeriCorps - ARRA -Education & Training 2,500 Housing & Comr 5 AmeriCorps - ARRA -Criminal Background Check 235 Housing & Corm 5 AmeriCorps 2 -Part-time wages 7,500 Housing & Comr 5 AmeriCorps 2 -Seasonal Wages 26,154 Housing & Corm 5 AmeriCorps 2 - IPERS 1,028 Housing & Corm 5 AmeriCorps 2 -Social Security 2,001 Housing & Corm 5 AmeriCorps 2 -Office Supplies 238 Housing & Corru 5 AmeriCorps 2 -Uniforms 309 Housing & Corru 5 AmeriCorps 2 -Miscellaneous 839 Housing & Comr 5 AmeriCorps 2 -Mileage 454 Housing & Corm 5 AmeriCorps 2 -Education & Training 500 Housing & Corm 5 AmeriCorps 2 -Criminal Background Check 62 Housing & Corm 5 AmeriCorps 3 -Part-Time Wages 37,500 Housing & Corm 5 AmeriCorps 3 -Seasonal Wages 130,770 Housing & Corm 5 AmeriCorps 3 -IPERS 5,138 Housing & Corm 5 AmeriCorps 3 -Social Security 10,004 Housing & Corm 5 AmeriCorps 3 -Part-Time Wages 1,187 Housing & Corm 5 AmeriCorps 3 -Uniforms 1,546 Housing & Corm 5 AmeriCorps 3 -Miscellaneous 4,195 Housing & Corm 5 AmeriCorps 3 -Mileage 2,271 Page 6 FY 10 Revenue Amount Fund Activity/CIP Account Explanation 100 10061100 62761 C/O -Washington VisioningfGreen Cty 100 10061150 62431 C/O CDBG Funds (203,919) 100 10061910 45771 Adjust budget to actual (54,436) 100 10061910 53102 Adjust budget to actual 184,344 100 10061914 45771 New Grant 33,888 100 10061916 45771 Adjust budget to actual 10,310 100 10061916 53102 Adjust budget to actual 169,441 100 10061916 45771 Adjust budget to actual 51,552 100 10061916 53102 Adjust budget to actual 100 10061910 61020 Adjust budget to actual 100 10061910 61030 Adjust budget to actual 100 10061910 61310 Adjust budget to actual 100 10061910 61320 Adjust budget to actual 100 10061910 61415 Adjust budget to actual 100 10061910 62010 Adjust budget to actual 100 10061910 62240 Adjust budget to actual 100 10061910 62320 Adjust budget to actual 100 10061910 62340 Adjust budget to actual 100 10061910 62360 Adjust budget to actual 100 10061910 62661 Adjust budget to actual 100 10061914 61020 New Grant Appropriation 100 10061914 61320 New Grant Appropriation 100 10061914 62011 New Grant Appropriation 100 10061914 62240 New Grant Appropriation 100 10061914 62360 New Grant Appropriation 100 10061914 62717 New Grant Appropriation 100 10061916 61020 Adjust budget to actual 100 10061916 61030 Adjust budget to actual 100 10061916 61310 Adjust budget to actual 100 10061916 61320 .Adjust budget to actual 100 10061916 62010 Adjust budget to actual 100 10061916 62011 Adjust budget to actual 100 10061916 62240 Adjust budget to actual 100 10061916 62340 Adjust budget to actual 100 10061916 62360 Adjust budget to actual 100 10061916 62717 Adjust budget to actual 100 10061917 61020 Adjust budget to actual 100 10061917 61030 Adjust budget to actual 100 10061917 61310 Adjust budget to actual 100 10061917 61320 Adjust budget to actual 100 10061917 62010 Adjust budget to actual 100 10061917 62011 Adjust budget to actual 100 10061917 62240 Adjust budget to actual 100 10061917 62340 Adjust budget to actual FISCAL YEAR 2010 AMENDMENT #1 14-Sep-09 FY 10 FY 10 Expense Revenue Department Program Description Amount Amount Housing & Corm 5 AmeriCorps 3 -Education & Training 2,500 Housing & Comr 5 AmeriCorps 3 -Telephone 308 Housing & Comr SC NBHD Stabilization Grant - State Grant 444,328 Housing & Comr SC NBHD Stabilization Grant -Land Acquisition with Improv. 444,328 Housing & Coma SC Homeownership Grants -Targeted Neighborhoods - Grants (100,000) Housing & Comr 5 Washington Neighborhood Develop Corp -Rental of Space 7,200 Housing & Comr 5 Washington Neighborhood Develop Corp -Utility Exp -Gas 1,200 Housing & Comr 5 Washington Neighborhood Develop Corp -Utility Exp - Elec 600 Housing & Comr 5 Washington Neighborhood Develop Corp -Utility Exp - Water 400 Housing & Corru 5 Washington Neighborhood Develop Corp -Telephone 1,050 Housing & Comr 5 Washington Neighborhood Develop Corp - O/E Maint Contr 1,095 Housing & Comr 5 Washington Neighborhood Develop Corp -Full-time employee 50,000 Housing & Comr 5 Washington Neighborhood Develop Corp -Social Security 3,600 Housing & Comr 5 Washington Neighborhood Develop Corp -Health Insurance 7,200 Housing & Comr 5 Washington Neighborhood Develop Corp - Worlcmans Comp 640 Housing & Corm 5 Washington Neighborhood Develop Corp - Gen'1 Liab Insur 1,450 Housing & Corm 5 Washington Neighborhood Develop Corp -Property Insur 200 Housing & Coma 5 Washington Neighborhood Develop Corp - Misc Services 7,165 Housing & Coma 5 Washington Neighborhood Develop Corp -Printing 1,500 Housing & Comr 5 Washington Neighborhood Develop Corp -Postage & Shippin€ 600 Housing & Comr 5 Washington Neighborhood Develop Corp - Office Supplies 400 Housing & Comr 5 Washington Neighborhood Develop Corp -Audit Services 1,000 Housing & Comr 5 Washington Neighborhood Develop Corp - Educ & Training 3,500 Housing & Comr 5 Washington Neighborhood Develop Corp -Consultant Services 7,800 Housing & Corm 5 Washington Neighborhood Develop Corp -Telephone 100 Housing & Comr 5 Washington Neighborhood Develop Corp - Micro-Computer 3,300 Housing & Comr 5 Housing & Community Development -Consultant Services 2,490 Planning Service SC Historic District Improvements - Construction 61,965 Planning Service SC Historic District Improvements - Construction 111,143 Planning Service SC Annexation Study/Implementation-Legal Fees 7,325 Planning Service SC Annexation Study/Implementation-Consultant Services 75,000 Planning Service SC Downtown Design Guidelines - State Grant 16,117 Planning Service 5 City Planning -Full-time employees (4,197) Planning Service 5 City Planning -Social Security (321) Planning Service 5 City Planning - IPERS (279) Planning Service 5 City Planning - Health Insurance (560) Planning Service 5 City Planning -Life Insurance (9) City Council 6 City Council - Travel Conferences (395) City Council 6 City Council - Dues & Memberships 680 City Council 6 Legislation & Policy - Travel Conferences (395) City Manager-Br 6 Budget - Education & Training 3,000 City Manager-Br 6 Budget -Computer (2,548) City Mgr-Person 6 Personnel - OSHA Compliance Assessment 9,270 City Mgr-Person 6 Personnel - GASB-45 Actuarial Evaluation 8,500 Page 7 Fund Activity/CiP 100 10061917 100 10061917 100 1002180 100 1002180 101 1011595 100 10061125 100 10061125 100 10061125 100 10061125 100 10061125 100 10061125 100 10061125 100 10061125 100 10061125 100 10061125 100 10061125 100 10061125 100 10061125 100 10061125 100 10061125 100 10061125 100 10061125 100 10061125 100 10061125 100 10061125 100 10061125 100 10061100 100 1001010 102 1021010 102 1021012 102 1021012 100 1001860 100 10062700 100 10062700 100 10062700 100 10062700 100 10062700 100 10070100 100 10070100 100 10070100 100 10072400 100 10072400 100 10072700 100 ]0072700 Account 62360 62421 45771 73111 62765 62436 62412 62411 62416 62421 62060 61010 61320 61410 61415 62208 62206 62731 62090 62030 62010 62726 62360 62716 62421 71124 62716 62711 73210 62713 62716 45701 61010 61320 61310 61410 61416 62310 62190 62310 62360 71124 62716 62716 Explanation Adjust budget to actual Adjust budget to actual New Grant New Grant Appropriation Shift to Wash Nbad Develop Corp Wash Neighborhood Dev Corp Wash Neighborhood Dev Corp Wash Neighborhood Dev Corp Wash Neighborhood Dev Corp Wash Neighborhood Dev Corp Wash Neighborhood Dev Corp Wash Neighborhood Dev Corp Wash Neighborhood Dev Corp Wash Neighborhood Dev Corp Wash Neighborhood Dev Corp Wash Neighborhood Dev Corp Wash Neighborhood Dev Corp Wash Neighborhood Dev Corp Wash Neighborhood Dev Corp Wash Neighborhood Dev Corp Wash Neighborhood Dev Corp Wash Neighborhood Dev Corp Wash Neighborhood Dev Corp Wash Neighborhood Dev Corp Wash Neighborhood Dev Corp Wash Neighborhood Dev Corp Section 8 Crime Activity Survey C/O C/O C/O C/O C/O CDBG Amend # 1 CDBG Amend # 1 CDBG Amend # 1 CDBG Amend # 1 CDBG Amend #1 Prespend FY10 Budget Sister Cities International Membership Prespend FY10 Budget C/O - NCDA Training Prespend FY10 Budget C/O C/O FISCAL YEAR 2010 AMENDMENT #1 14-Sep-09 FY 10 FY 10 Expense Revenue Department Program Description Amount Amount Fund Activity/CIP Account Explanation City Mgr-Person 6 Personnel -Leadership Training 4,600 100 10072700 62716 C/O City Manager 6 City Manager's Office Administration -Travel -Conferences 25,000 100 10072100 62310 NLC Boston from Insurance Savings City Manager 6C GIS Implementation -Consultant Services 66,225 100 1001070 62716 C/O City Manager 6C GIS Implementation - Softwaze 4,500 100 1001070 71123 C/O City Manager 6C GIS Enhancements -Peripherals, Computer 3,124 102 1021946 71120 C/O City Manager 6C City of Dbq 175th Birthday 9,681 100 1001948 62734 C/O City Manager 6C Americas River Fest Equip 200 100 1002050 72115 C/O City Manager 6C Asst City Manager Office Remodel 10,000 100 1002051 71110 C/O City Manager 6C Sustainable Coordinator Office Space -Construction 765 100 1001977 73211 Sust Coord Office Components City Manager 6C FY09 Community Disaster Grant 4,058 100 1002174 62761 New Grant Appropriation City Manager 6C Budget Office Remodel -Furniture 9,131 100 1002177 71156 C/O City Manager 4 Arts and Cultural Affairs Office -Consultant Services 2,000 100 10072500 62716 Shift from Travel Conferences City Manager 4 Arts and Cultural Affairs Office -Travel Conferences (2,000) 100 10072500 62310 Shift to Consultant Services City Manager 6 City Manager's Office -Miscellaneous Services 25,000 100 10072100 62731 Advertising for Census City Manager 6 Human Resources -Travel Conferences (2,200) 100 10072700 62310 Prespend FY10 Budget City Manager 6 City Manager's Office -Travel Conferences (440) 100 10072100 62310 Prespend FY10 Budget City Manager 6 City Manager's Office -Consultant Services 5,667 100 10072100 62716 Consultant for Parking Stimulus Grant City Manager 6 City Man~~Pr's Office -Consultant Services 25,000 100 10072100 62716 Fund PT Millwork District Dev Dir City Manager 6 City Manager's Office -Consultant Services 6,311 100 10072100 62716 C/0 Sus*~~^~~le City Durrant City Manager 6 City Manager's Office -Consultant Services 18,000 100 10072100 62716 Ferguson Group 3 month retainer City Manager- P~ 6 Public Information -Part-time Wages (29,946) 100 10072300 61020 Shift to Cable TV Fund City Manager- P~ 6 Public Information -Social Security (2,291) 100 10072300 61320 Shift to Cable TV Fund City Manager- P~ 6 Public Information - IPERS (1,991) 100 10072300 61310 Shift to Cable TV Fund City Manager- P~ 6 Public Information -Office Supplies (150) 100 10072300 62010 Shift to Cable TV Fund City Manager- Pi 6 Public Information -Mileage (250) 100 10072300 62340 Shift to Cable TV Fund City Manager- P~ 6 Public Information -Education & Training (500) 100 10072300 62360 Shift to Cable TV Fund City Manager- P~ 6 Public Information -Dues & Memberships (45) 100 10072300 62190 Shift to Cable TV Fund City Clerk 6 City Clerk/Administration -Code Supplement 15,000 100 10073100 62120 C/O City Clerk 6 City Clerk/Administration -Civil Service Tests 25,000 100 10073100 62684 C/O City Clerk 6 City C1erWAdministration -Legal Services -Code Update 10,000 100 10073100 62713 C/O City Clerk 6 City Clerk/Administration -Scanner 2,450 100 10073100 71129 C/O Finance 6C Purchase Card Component - Softwaze 18,000 100 1002054 71123 C/O Information Serv 6 Information Services -Servers 8,000 100 10077100 71125 C/O - 2 Servers Information Serv 6 Information Services - Misc Office Equipment 250 100 10077100 71110 C/O -Air Purifier Information Serv 6 Information Services -Peripherals, Computer 30,000 100 10077100 71120 C/O -Intrusion Detection Information Serv 6 Information Services -Software 9,600 100 10077100 71120 C/O -Remote Management Information Serv 6 Information Services -Construction -Not Building 24,000 100 10077100 73211 C/O - I-Net Phase I Information Serv 6 Information Services -Education & Training 5,571 100 10077100 62360 C/O -Computer Training Information Serv 6C Business Cont for Servers -Consultant Services 2,000 102 1021949 62716 C/O Information Serv 6C Internet, Micros & Printer - DRA Distribution 23,741 102 1021069 71124 C/0 Information Serv 6C Internet, Micros & Printer - DRA Distribution 20,000 102 1021069 46205 C/O Purchase of Serv 0 Pay to Other Agency - NE IA Community College 5,000 100 10079450 62761 C/0 - NE IA Community College Purchase of Serv 0 Pay to Other Agency -Every Child Every Promise 25,000 100 10079450 62761 C/O -Every Child Every Promise TOTAL GENERAL FUND 16,003,212 11,617,291 Page 8 FISCAL YEAR 2010 AMENDMENT #1 14-Sep-09 FY 10 FY 10 Expense Revenue Department P rogram Description Amount Amount Fund Activity/CIP Account Explanation TRANSIT FUND Transit Division 8 Transit Admin -FTA Capital 880,833 600 60053100 44150 C/0 -FTA Transit Division 8 Transit Admin -State-Aid Operating 13,428 600 60053100 45721 C/O Transit Division 8 Mini Bus Operations -East Dubuque Contract Revenue 44,000 600 60053500 51715 C/O Transit Division 8 Transit Admin - Misc Equipment 62,379 600 60053100 71550 C/O Transit Division 8 Bus Operations -Promotion (Estate $) 12,201 600 60053400 62140 C/O Transit Division 8 Bus Operations - Pay to Other Agency - DuRide 13,500 600 60053400 62761 C/O Transit Division 8 Bus Maintenance -Security Cameras 16,000 600 60053700 72417 C/O Transit Division 8 Bus Maintenance -Vehicle Maint 31,683 600 60053700 62521 C/O Transit Division 8C Exterior Keyline Windows -FTA Capital 8,000 600 6001217 44150 C/O Transit Division 8C Exterior Keyline Windows -Construction 10,000 600 6001217 73210 C/O 145,763 946,261 DOWNTOWN LOAN POOL -TIF FUND Economic Devlo SC Loan Pool, Downtown TIF -Loans 17,733 241 2411033 62764 C/O Economic Devlo SC Downtown Rehab Grant Program 47,964 241 2411942 62765 C/O TOTAL DOWNTOWN LOAN POOL-TIF FUND 65,697 - ROAD USE TAX FUND Public Works 2C Street Sweeper 165,000 250 2501209 71321 Shift from FY08 Improv to Fire Headgt~ Engineering 2 Project Engineering -Education & Training 12,973 250 25055400 62360 C/O Engineering 2 Project Engineering -Software 8,079 250 25055400 62663 C/O Engineering 2 Project Engineering -Traffic Control Equipment 11,022 250 25055400 71411 C/O Engineering 2 Project Engineering -Micro Computer 1,147 250 25055400 71124 C/O Engineering 2 Traffic Engineering -Education & Training 3,402 250 25055700 62360 C/O Engineering 2 Traffic Engineering -Traffic Control Equipment 3,600 250 25055700 71411 C/O Engineering 2C Signalization Program -Eng Division Serv 3,764 250 2501011 62811 C/O Engineering 2C Louise Lane Bridge -Construction 13,621 250 2501020 73211 C/O Engineering 2C Brunskill Rd Bridge Repl -Eng Division Serv 48,424 250 2501077 62811 C/O Engineering 2C Brunskill Rd Bridge Repl -Construction 128,000 250 2501077 73211 C/O Engineering 2C Montrose Steps Reconstruction -Eng. Division Services 5,000 250 2501620 62811 C/O Engineering 2C Montrose Steps Reconstruction -Construction 25,000 250 2501620 73211 C/O Engineering 2C Ramona/Pamela Joint Repair -Eng. Division Services 5,757 250 2501819 62811 C/O Engineering 2C Ramona/Pamela Joint Repair -Construction 46,728 250 2501819 73211 C/O Engineering 2C Railroad Cross Improvement -Construction 85,230 250 2502026 73211 C/O Engineering 2C Traffic Signal Coordination - Right of Way Acquisition 44,467 250 2501228 73113 C/O Engineering 2C Traffic Signal Coordination -Consulting Engineers 66,694 250 2501228 62712 C/O Engineering 2C Traffic Controller Replacement - Equipm Acquisition 56,638 250 2501274 73410 C/O Engineering 2C Signal Intersec Reconstruc-Construction 16,400 250 2501615 73211 C/O Engineering 2C NW Arterial Capacity Improvements -Consulting Engineers 50,000 250 2501814 62712 C/O Engineering 2C NW Arterial Capacity Improvements -Construction 150,000 250 2501814 73211 C/O Engineering 2C Traffic Consultant Serv -Consulting Engineers 32,031 250 2501815 62712 C/O Engineering 2C Traffic Signal Video Detection -Construction 12,260 250 2501816 73211 C/O Page 9 FISCAL YEAR 2010 AMENDMENT #1 14-Sep-09 FY 10 FY 10 Expense Revenue Department Program Description Amount Amount Fund Activity/CIP Account Explanation Engineering 2C LED Re-Lamp Schedule -Eng. Division Services 3,000 250 2501916 62811 C/O Engineering 2C LED Re-Lamp Schedule -Construction 33,810 250 2501916 73211 C/0 Information Serv 6C Internet, Micros & Printer -Road Use Tax Fund 13,500 250 2501069 71124 C/O TOTAL ROAD USE TAX FUND 1,045,547 - SPECIAL ASSE SSMEN T FUND Engineering 2C Special Assessments-Principal Payments 1,223,400 255 25510255 52101 C/O Special Assessment Revenue Engineering 2C Special Assessments-Interest Payments 98,250 255 25510255 52102 C/O Special Assessment Revenue TOTAL SPECIAL ASSESSMENT FUND - 1,321,650 COMMUNITY DEVELOPMENT BLOCK GRANT FUND Engineering 2C Accessible Curb Ramps -Construction 24,214 260 2601236 73211 C/O CDBG Funds Engineering 2C Neighborhood Related Improvements -Construction 5,946 260 2601239 73211 C/O CDBG Funds Economic Dever SC CommerciaUIndustrial Rehab Loan -CDBG 69,160 260 2601746 62764 C/O CDBG Funds Housing & Conn 5 Housing Rehab Serv & Staff -Education & Training 6,082 260 26061300 62360 C/O CDBG Funds Housing & Corm 5 Housing Rehab Serv & Staff -Software Maintenance 5,039 260 26061300 62663 C/O CDBG Funds Housing & Corm 5 Housing Rehab Serv & Staff -Software 7,097 260 26061300 71123 C/O CDBG Funds Housing & Corm 5 Housing Code Enforcement -Education 1,259 260 26061700 62360 C/O CDBG Funds Housing & Corm 5 CDBG Admin/Monitoring-CD Block Grant Receivable 1,157,000 260 26061800 44205 C/O CDBG Funds Housing & Corm 5 Rehab Program -Education & Training (2,460) 260 26061300 62360 Prespend FY10 Budget Housing & Corm SC Housing Trust -Grants 10,607 260 2601021 62764 C/O CDBG Funds Housing & Corru SC Homeownership Rehab Program-Loans 100,609 260 2601065 62764 C/O CDBG Funds Housing & Corm SC Homeownership Rehab Program-Loans 85,418 260 2601065 73210 C/O CDBG Funds Housing & Corm SC Purchase/Resale/Rehab -Construction 69,958 260 2601231 73210 C/O CDBG Funds Housing & Corru SC Lead Paint Abatement Program -Loans 43,060 260 2601232 62764 C/O CDBG Funds Housing & Corm SC First Time Homebuyer Program-Loans 37,450 260 2601234 62764 C/O CDBG Funds Housing & Corm SC Historic Preservation Rehab Grant-Loans 19,917 260 2601237 62764 C/O CDBG Funds Planning Service 5 City Planning -Full-time employees 4,197 260 26062700 61010 CDBG Amend # 1 Planning Service 5 City Planning -Social Security 321 260 26062700 61320 CDBG Amend # 1 Planning Service 5 City Planning - IPERS 279 260 26062700 61310 CDBG Amend # 1 Planning Service 5 City Planning -Health Insurance 560 260 26062700 61410 CDBG Amend #1 Planning Service 5 City Planning -Life Insurance 9 260 26062700 61416 CDBG Amend #1 City Manager SC Neighborhood Grants 6,517 260 2601238 62765 C/O CDBG Funds TOTAL CDBG FUND 495,239 1,157,000 COMMUNITY DEVELOPMENT BLOCK GRANT -RECOVERY FUND Engineering 2C Green Alley Pilot Project 246,202 262 2622044 73211 CDBG-R Funds Housing & Corm 5 CDBG-R Admin/Monitoring-CD Block Employee Expense 32,827 262 26261800 61010 CDBG-R Funds Housing & Corm 5 CDBG-R Admin/Monitoring-CD Block Grant 328,269 262 26261800 44175 CDBG-R Funds Housing & Corm SC Homeownership Rehab Program-Loans 49,240 262 2621065 62764 CDBG-R Funds TOTAL CDBG-R FUND 328,269 328,269 UDAG FUND. Economic Devlo SC Historic Preservation -Revolving Loans 52,864 265 2651247 62764 C/O Page 10 FISCAL YEAR 2010 AMENDMENT #1 14-Sep-09 Department Program Description Economic Devlo SC Job Creation -Loans Economic Devlo SC Airport Revenue Guarantee -Pay to Other Agency Economic Devlo: SC Economic Development -UDAG Loans TOTAL UDAG FUND STATE RENTAL REHAB FUND Housing & Comi 5 LHAP Grant -Loans TOTAL STATE RENTAL REHAB FUND LEAD PAINT GRANT FUND Housing & Conn 5 Lead Paint Abatement Program -Education & Training Housing & Corm 5 Housing & Community Development -Lead Paint -Travel TOTAL LEAD PAINT GRANT FUND FY 10 FY 10 Expense Revenue Amount Amount Fund Activity/CIP Account Explanation 21,480 265 2651246 62764 C/O 150,000 265 2651796 62761 C/O 300,000 265 2651246 62764 Payment for 40 Main LLC Loan 524,344 - 14,099 270 27061320 62764 C/O 14,099 - 17,410 275 27561200 62360 C/O (5,342) 275 27561200 62310 Prespend FY10 Budget 12,068 - SECTION 8 VOUCHER FUND Housing & Comt 5 Section 8 Voucher -Micro Computer TOTAL SECTION 8 VOUCHER FUND 9,026 280 28061600 71124 C/O 9,026 - CABLE TV FUND City Manager- P~ 6 Public Information -Part-time Wages 29,946 290 29072300 61020 Shift from General Fund City Manager- P~ 6 Public Information -Social Security 2,291 290 29072300 6]320 Shift from General Fund City Manager- P~ 6 Public Information - IPERS 1,991 290 29072300 61310 Shift from General Fund City Manager- Pi 6 Public Information -Office Supplies 150 290 29072300 62010 Shift from General Fund City Manager- Pi 6 Public Information -Mileage 250 290 29072300 62340 Shift from General Fund City Manager- Pi 6 Public Information -Education & Training 500 290 29072300 62360 Shift from General Fund City Manager- Pi 6 Public Tnformation -Dues & Memberships 45 290 29072300 62190 Shift from General Fund Information Serv 6C Internet, Micros & Printer -Cable TV 2,500 290 2901069 71124 C/O TOTAL CABLE TV FUND 37,673 - STREET CONSTR UCTION FUND Engineering 2C Locust - 9th to 17th St - DMATS Funding 488,800 300 3002068 45725 DMATS Funding Engineering 2C Locust - 9th to 17th St -Construction Not Building 108,316 300 3002068 73211 C/O Engineering 2C Street Const General -Construction Not Building 54,706 300 3002142 73211 C/O Engineering 2C Signalization Program -Construction 16,212 300 3001011 73410 C/O Engineering 2C Guardrail Replacement -Construction 87,392 300 3001027 73211 C/O Engineering 2C Brunskill Rd Bridge Repl -Construction 124,416 300 3001077 73211 C/O Engineering 2C University Ave Ext to 20-STP Funds 1,082,136 300 3001254 44145 C/O Engineering 2C University Ave Ext to 20 -Construction 623,204 300 3001254 73211 C/O Engineering 2C Bridge Repairs/Maintenance -Eng. Division Services 5,000 300 3001258 62811 C/O Engineering 2C Bridge Repairs/Maintenance -Construction 49,915 300 3001258 73211 C/O Engineering 2C Special Assessment Assist 35,000 300 3001256 62761 C/O Engineering 2C Main St Sidewalk Impr - Eng Division Services 71,878 300 3001633 62811 C/O Engineering 2C Main St Sidewalk Impr -Construction 394,120 300 3001633 73211 C/O Engineering 2C Main St Sidewalk Impr -Consulting 1,278 300 3001633 62712 C/O Page 11 FISCAL YEAR 2010 AMENDMENT #1 14-Sep-09 FY 10 FY 10 Expense Revenue Department Program Description Amount Amount Fund Activity/CIP Account Explanation Engineering 2C White Water Creek Bridge -Construction 165,112 300 3001634 73211 C/O Engineering 2C White Water Creek Bridge -State Grant 85,250 300 3001634 45701 C/O Engineering 2C White Water Creek Bridge -Private Participant 10,000 300 3001634 53102 C/O Engineering 2C Ramona/Pamela Joint Repair -Construction (773) 300 3001819 73211 Prespend FY 10 Project Engineering 2C Main St (1st-5th)- Construction 142,235 300 3001915 73211 C/O Engineering 2C FY 2008 Annual St Program-Private Participant Loras College 21,036 300 3001953 53102 C/O Engineering 2C N Cascade Road Reconstruction - Consulting Engineers 52,623 300 3002021 62712 C/0 Engineering 2C Foye/Merchant/Gold Street Reconstruction -Consulting Eng 85,935 300 3002022 62712 C/O Engineering 2C Sub-Divisions Sundrains -Construction Not Building 173,360 300 3002023 73211 C/O Engineering 2C Sub-Divisions Sundrains -Consulting Engineers 28,125 300 3002023 62712 C/O Engineering 2C HWY 52 Resurfacing -State Highway Assistance 716,103 300 3002025 45725 C/0 Engineering 2C US 61/151 Condor - Const. Contr Not Building 380,000 300 3002028 73211 C/O Engineering 2C US 61/151 Corridor -Consulting Engineers 119,315 300 3002028 62712 C/O Engineering 2C US 61/151 Condor-State Grants 400,000 300 3002028 45701 C/O Engineering 2C US 61/151 Corridor- State Highway Assistance 80,000 300 3002028 45725 C/O Engineering 2C Southwest Arterial-STP Funding 4,320,000 300 3001287 44145 C/O Engineering 2C Southwest Arterial-State Highway Assistance 901,483 300 3001287 45725 C/O Engineering 2C Southwest Arterial-DOT/Federal Highway Sec 330 395,653 300 3001287 44170 C/O Engineering 2C Southwest Arterial-County Match 93,430 300 3001287 46205 C/O Engineering 2C Southwest Arterial-Consulting Eng 3,415,486 300 3001287 62712 C/O Engineering 2C Southwest Arterial-Right-of--Way Acquisition 2,059,850 300 3001287 73113 C/O Engineering 2C NW Arterial Capacity Imp - Const. Contr Not Building 525,000 300 3002029 73211 C/O Engineering 2C NW Arterial Capacity Imp -Consulting Engineers 198,257 300 3002029 62712 C/O Engineering 2C NW Arterial Capacity Imp -State Grants 500,000 300 3002029 45701 C/O Engineering 2C Cedar Cross Reconstuction -Eng. Division Services (22,191) 300 3002139 62811 Prespend FY 10 Project Engineering 2C Traffic Signal Mastazm Rep. -Eng Division Services 10,000 300 3001133 62811 C/O Engineering 2C Traffic Signal Mastazm Rep. -Construction 57,500 300 3001133 73211 C/O Engineering 2C Warning Flashers-Hawthorne 25,000 300 3001252 73411 C/O Engineering 2C Traffic Signal Interconnect -Eng Division Services 8,449 300 3001266 62811 C/O Engineering 2C Traffic Signal Interconnect -Construction Contract - Supplem 90,000 300 3001266 73510 C/O Engineering 2C Signal Intersec Reconst-vc-Construction 27,133 300 3001615 73211 C/O Engineering 2C Traffic Signal Fiber Optic Net -Construction 84,636 300 3001631 73211 C/O Engineering 2C Traffic Signal Operations Center-Contract 62,023 300 3001852 73510 C/0 Engineering 2C Traffic Signal Operations Center-State Pass-Thru Grant 15,717 300 3001852 45771 C/0 TOTAL STREET CONSTRUCTION FUND 9,258,512 9,109,608 SALES TAX F UND (20%) Parks Division 4C Playground Improvements -Equip. Acquisition 5,464 350 3501048 73410 C/O Parks Division 4C Street Tree Program -Tree Planting 3,676 350 3501458 73311 C/O Pazks Division 4C EPP Improvements 6,126 350 3501866 62811 C/O Pazks Division 4C Flora -Renovate Basketball Ct -Construction 23,100 350 3501867 73211 C/O Pazks Division 4C Pet Park Terminal Street -Construction 98,000 350 3501978 73211 C/O Pazks Division 4C Burden Park Renovation 18,709 350 3501981 73211 C/O Pazks Division 4C Grand River Center Chairs 30,000 350 3501990 71212 C/O Page 12 FISCAL YEAR 2010 AMENDMENT #1 14-Sep-09 FY 10 FY 10 Expense Revenue Department Program Description Amount Amount Fund Activity/CIP Account Explanation Parks Division 4C Grand River Center Level Floors 2,000 350 3501991 62712 C/0 Parks Division 4C Grand River Center Level Floors 22,000 350 3501991 73210 C/O Parks Division 4C Grand River Center Paint Exterior 85,180 350 3501993 73210 $40,000 from GRC Paint Pre-function Civic Center Div 4C Step & Aisle Lighting -Construction 12,562 350 3501887 73210 C/O Civic Center Div 4C Replace Portable Chairs 19,066 350 3501998 71212 C/O Library Departm 4C Library HVAC Maintenance -Equipment Acquisition 11,089 350 3501787 73410 C/O Public Works 2C Port Amenities Maint 7,306 350 3502038 73510 C/O Public Works 2C Wayfinding Sign Replace (1,068) 350 3502151 71619 FY10 Project started early Engineering 2C Federal Building Renovation -Construction 45,211 350 3501841 73210 C/O Engineering 2C Federal Building Renovation -Consulting Eng 30,000 350 3501841 62712 C/O Engineering 2C Curb/Catch Basin Replacement-Construction 87,396 350 3501041 73211 C/O Engineering 2C Streetscape/Plaza Amenity -Equip Acquisition 37,781 350 3501273 73410 C/O Engineering 2C Sidewalk Program City Owned (15,583) 350 3501425 73211 Prespend FY 10 Project Engineering 2C Decorative Concrete Maint -Construction 75,000 350 3501630 73211 C/O Engineering 2C Sidewalk Financial Assist -Pay to Other Agency 12,451 350 3501727 62761 C/O Engineering 2C City Hall Sustain Project -Consulting Engineers 33,152 350 3502027 62712 C/O Engineering 2C Cooper Piace Wall -Construction 151,800 350 3502088 73211 C/O Engineering 2C Accessibility Barriers -Construction (142) 350 3501034 73210 Prespend FY 10 Project Engineering 2C Rehab Railroad Tracks 79,507 350 3501465 73211 C/0 Engineering 2C Ice Harbor Maintenance/Dredging -Eng Division Services 1,632 350 3501466 62811 C/O Engineering 2C Ice Harbor Maintenance/Dredging 138,667 350 3501466 73211 C/O Engineering 2C Transient Docks -Main Channel -Construction 3,159,169 350 3501861 73211 C/O Engineering 2C Transient Docks -Main Channel -Big Tier Grant 3,037,802 350 3501861 44170 C/O Engineering 2C Downtown St Light Replacement -Eng Division Svc 6,000 350 3501608 62811 C/O Engineering 2C Downtown St Light Replacement -Construction Not Building 41,000 350 3501608 73211 C/O Building Service 6C City Hall Remodeling -Construction 25,4]4 350 3501045 73210 C/O Building Service 6C City Hall Annex Maintenance -Construction 9,897 350 3501757 73210 C/O Building Service 6C General Building Maintenance -Construction 42,558 350 3501428 73210 C/O TOTAL SALES TAX FUND 4,304,120 3,037,802 GENERAL CONSTRUCTION FUND Engineering 2C McGraw Hill Project -Consultant (20,570) 360 3601855 62716 PO Adjustment Engineering 2C Port of Dubuque Parking Ramp -Construction 458,920 360 3601957 73211 C/0 Engineering 2C Millworking District Streetscape -Iowa Great Places 150,000 360 3602136 45701 New Grant Building Service 6C Kephart Building Improvement -Construction 2,443 360 3601976 73210 Shift from McGraw Hill Proj #3601855 Building Service 6C Kephart Building Improvement -Construction 91,014 360 3601976 73210 Shift from Corridor Study #1001039 Building Service 6C Kephart Building Improvement -Construction (57,358) 360 3601976 73210 C/O Economic Devlo 5C DICW -Additions (Site B)- RISE Grant 396,038 360 3601481 4574] C/O Economic Devlo SC DICW -Additions (Site B)-Construction 708,626 360 3601481 73211 C/O Economic Devlo: SC Community Marketing -Pay to Other Agency 100,000 360 3601842 62761 C/O Economic Devlo SC Industrial Site Development -North Siegert -Construction 363,805 360 3601943 73211 C/O Economic Devlo SC Industrial Site Development -North Siegert -Consult Eng (53,168) 360 3601943 62712 Adjust budget to actual Economic Devlo SC Industrial Site Development -North Siegert -Construction (1,346,832) 360 3601943 73211 Adjust budget to actual Economic Devlo SC Industrial Site Development -North Siegert -REAP (200,000) 360 3601943 45707 Adjust budget to actual Page 13 FISCAL YEAR 2010 AMENDMENT #1 14-Sep-09 FY 10 FY 10 Expense Revenue Department Program Description Amount Amount Fund Activity/CIP Account Explanation Economic Devlo SC Industrial Site Development -North Siegert -Rise Grant (400,000) 360 3601943 45741 Adjust budget to actual TOTAL GENERAL CONSTRUCTION FUND 246,880 (53,962) AIRPORT CONSTRUCTION FUND. Airport Departm~ 2C Replace Cazpet 13,149 390 3901500 71223 C/O Airport Departm~ 2C New T-Hanger Ramp -Construction 12,000 390 3901690 73211 C/O Airport Departm~ 2C Lazge Hanger Repair -Construction 19,500 390 3901694 73211 C/O Airport Departm~ 2C Runway Safety Area -Relocations 298,000 390 3901788 73112 C/O Airport Departm~ 2C Runway Safety Area -Right-Of--Way Acquisition 79,661 390 3901788 73113 C/O Airport Departm~ 2C Runway Safety Area -Construction 38,495 390 3901788 73210 C/O Airport Departm~ 2C Runway Safety Area-FAA Funds 363,477 390 3901788 44105 C/O Airport Departm~ 2C Field Drain Replacements -Engineering Division Services 5,640 390 3901793 62811 C/O Airport Departm~ 2C Field Drain Replacements -Construction 593 390 3901793 73210 C/O Airport Departm~ 2C Terminal -Land Acquisition -Construction 139,786 390 3901795 73210 C/O Airport Departm~ 2C Terminal -Land Acquisition -Relocations 104,000 390 3901795 73112 C/O Airport Departm~ 2C Terminal -Land Acquisition -FAA Funds 273,020 390 3901795 44105 C/O Airport Depaztm~ 2C Radar Display System -Other Safety Equipment 984 390 3901862 71314 C/O Airport Depaztrm 2C Radar Display System -FAA Funds 984 390 3901862 44105 C/O Airport Departm~ 2C Terminal - RW 31 Pazallel -Consulting Engineers 248,100 390 3901891 62712 C/0 Airport Departm~ 2C Terminal - RW 31 Pazallel -Construction 2,438,000 390 3901891 73211 C/0 Airport Departm~ 2C Terminal - RW 31 Pazallel-FAA Funds 2,551,795 390 3901891 44105 C/O Airport Departm~ 2C Terminal -Sche/Site Design -Consulting Engineers 521,000 390 3901892 62712 C/O Airport Departm~ 2C Terminal -Sche/Site Design-FAA Funds 494,950 390 3901892 44105 C/O Airport Departm~ 2C Terminal -Sche/Site Design-State Grants 26,050 390 3901892 45701 C/O Airport Departm~ 2C Extend Gen'1 Aviation Ramp -Consulting Engineers 5,000 390 3901893 62712 C/O Airport Departm~ 2C Extend Gen'1 Aviation Ramp -Construction 49,000 390 3901893 73211 C/O Airport Departm~ 2C Diesel Tank Replacement -Construction 11,697 390 3901894 73211 C/O Airport Departm~ 2C Asphalt Parking Lots -Consulting Engineers 4,401 390 3902007 62712 C/O Airport Departm~ 2C Asphalt Parking Lots -Construction Not Building 17,062 390 3902007 73211 C/O TOTAL AIRPORT CONSTRUCTION FUND 4,006,068 3,710,276 DEBT SERVICE FiIND Debt Service 0 GO Bond Proceeds 7,500,616 440 44010440 54210 C/O TOTAL DEBT SERVICE FUND - 7,500,616 WATER OPERATING FUND Finance 8 Utility Bill/Pazking Tickets - Van/Pickup/Wag Replacement 19,000 640 64074710 71312 C/0 Finance 8 Utility Bill/Pazking Tickets - Van/Pickup/Wag Replacement 3,000 640 64074710 71312 Additional cost for van TOTAL WATER OPERATING FUND 22,000 - REFUSE FiIND Public Works 8C Dual Packer Recycle Vehicles 662,079 670 6701533 73410 C/O City Manager 8C Budget Office Remodel -Furniture 447 670 6702177 71156 C/O TOTAL REFUSE FUND 662,526 - Page 14 FISCAL YEAR 2010 AMENDMENT #1 14-Sep-09 Department Program Description FY 10 FY 10 Expense Revenue Amount Amount Fund Activity/CIP Account Explanation AMERICA'S RIVER PROTECT FUND Engineering 8C Mississippi Riverwalk Project-Private Participation 72,252 700 7001054 53102 C/O Engineering 8C Art in Port ofDubuque -Consultant Services 223,014 700 7001853 62731 C/O Engineering 8C Shot Tower Restoration -Consultant 442,930 700 7001854 62716 C/O Engineering 8C Shot Tower Restoration -Federal Grant 290,742 700 7001854 44170 C/O Engineering 8C Ice Harbor Transient Boat Docks - Const Contract Not Bldg 12,209 700 7001961 73211 C/O TOTAL AMERICA'S RIVER PROJECT FUND 678,153 362,994 SANITARY SEW ER CONSTRUCTION FUND, Water Pollution i 8C Automatic Bar Screens -Equipment Acquisition 16,000 710 7101304 73410 C/O Water Pollution ~ 8C Automatic Bar Screens -Construction -Not Building 3,200 710 7101304 73211 C/O Water Pollution ~ 8C Reroof Int Lift Station -Construction 13,500 710 7101316 73210 C/O Water Pollution ~ 8C Paint Doors/Windows -Construction 6,425 710 7101317 73210 C/O Water Pollution ~ 8C Scada System Upgrade -Construction -Not Building 48,390 710 7101339 73211 C/O Water Pollution ~ 8C Terminal St Motor Control -Construction 196,105 710 7101648 73211 C/O Water Pollution i 8C Primary Clarifier - PainUSand -Construction 28,000 710 7101649 73211 C/O Water Pollution i 8C Rebuild Centrifuge Scroll -Consultant Services 64,000 710 7101833 62716 C/O Water Pollution ~ 8C Lab/Administrative Building Remodel -Construction 182,000 710 7101838 73210 C/O Water Pollution ~ 8C Lab/Administrative Building Remodel -Consulting Engineers 18,000 710 7101838 62712 C/O Water Pollution ~ 8C Flow Equalization -Consultant Services 5,000 710 7101926 62716 C/O Water Pollution ~ 8C Flow Equalization -Construction Not Building 100,000 710 7101926 73211 C/O Water Pollution ~ 8C Flow Equalization -Equipment Acquisition 15,000 710 7101926 73410 C/O Water Pollution i 8C Ins Fiberglass Blend Tank -Consultant Services 2,500 710 7101927 62716 C/O Water Pollution ~ 8C Ins Fiberglass Blend Tank -Construction Not Building - 20,000 710 710]927 73211 C/O Water Pollution ~ 8C Power Factor Corr Capacitor -Equipment Acquisition 38,000 710 7101928 73410 C/O Water Pollution ~ 8C Primary Dome Sealing -Construction Not Building 40,000 710 7101929 73211 C/O Water Pollution ~ 8C Primary Dome Sealing -Consultant Services 3,500 710 7101929 62716 C/O Water Pollution ~ 8C Pumping Station Telemetry -Equipment Acquisition 55,000 710 7101930 73410 C/O Water Pollution i 8C 02 Plant Mixers/Repair -Construction Not Building 14,000 710 7101931 73211 C/O Water Pollution i 8C 02 Plant Mixers/Repair -Equipment Acquisition 138,196 710 7101931 73410 C/O Water Pollution ~ 8C Active Sludge Basin Repair -Consultant Services 40,000 710 7101932 62716 C/O Water Pollution ~ 8C Active Sludge Basin Repair -Construction Not Building 80,000 710 7101932 73211 C/O Water Pollution ~ 8C WPC Plant Landscape/Stormwater -Consulting Engineers 4,000 710 7101934 62712 C/O Water Pollution i 8C WPC Plant Landscape/Stormwater -Construction Contract 24,313 710 7101934 73211 C/O Water Pollution i 8C Replace Plant Intercom System - PA System 15,000 710 7102032 72419 C/O Water Pollution ~ 8C Replace Plant Intercom System -Construction Not Building 3,100 710 7102032 73211 C/O Water Pollution ~ 8C Shower Room Update in SPU -Construction Not Building 18,000 710 7102033 73211 C/O Water Pollution ~ 8C Terminal St Sluice Gates -Consulting Engineers 5,000 710 7102034 62712 C/O Water Pollution ~ 8C Terminal St Sluice Gates -Construction Contract 180,000 710 7102034 73211 C/O Water Pollution ~ 8C Standby Generator Term St -Consulting Engineers 2,403 710 7102035 62712 C/O Water Pollution ~ 8C Standby Generator Term St -Construction Contract 53,800 710 7102035 73211 C/0 Water Pollution i 8C Switch Gear Pumping Station -Construction Contract 15,000 710 7102036 73211 C/O Water Pollution ~ 8C WPC Plant Facility Study -Consultant Services (535,996) 710 7101837 62716 C/O Page 15 FISCAL YEAR 2010 AMENDMENT #1 14-Sep-09 FY 10 FY 10 Expense Revenue Department Program Description Amount Amount Water Pollution i 8C WPC Plant Facility Study - SRF Bond Proceeds 1,476,327 Public Works 8C GIS Mobile Mapping 1,091 Public Works 8C PW Fleet GPS Project -Equipment Acquisition 3,795 Engineering 8C Annexation Study /Implementation -Construction 256,172 Engineering 8C Sewer Conn Asst -Low/Mod -Miscellaneous Services 56,219 Engineering 8C Sanitary Sewer Internal Main -Construction 490,046 Engineering 8C Sanitary Sewer Internal Main -Private Participant 171,178 Engineering 8C I&I Reduction Program -Construction Not Bldg 152,316 Engineering 8C Lateral Repl Asst. Low Inc - Const Cont Supp 15,000 Engineering 8C Lateral Repl Asst. Low Inc -Eng. Division Services 19,951 Engineering 8C Lateral Repl Asst. Low Inc -Pay to Other Agency 25,000 Engineering 8C Rockdale Road Sanitary Sewer -Construction 167,447 Engineering 8C Sewer Lateral Assistance -Eng Division Services 37,644 Engineering 8C Laterals - I&I Reduction -Construction 18,771 Engineering 8C Cox Street Sanitary Sewer -Construction 62,000 Engineering 8C Alley Washington-Jackson Sewer -Construction 130,000 Engineering 8C Loras/Walnut to Prairie St Sewer -Construction 54,572 Engineering 8C Sanitary Sewer Manhole Replacement 69,979 Engineering 8C Hwy 20 Annexation Sanitary Sewers -Eng Division Serv 20,814 Engineering 8C Hwy 20 Annexation Sanitary Sewers -Construction 406,780 Engineering 8C Sewer Extensions New Development -Construction 479,075 Engineering 8C Sewer Clearing/Grubbing - Const. 33,733 Engineering 8C Sanitary Sewer Lining Program -Eng. Division Serv. 11,213 Engineering 8C Sanitary Sewer Lining Program - Const. 56,054 Engineering 8C Monroe St Sanitary Sewer -Construction 6,005 Engineering 8C Monroe St Sanitary Sewer -Engineering Division Services 996 Engineering 8C Sunset Ridge Sanitary Sewer -Consulting Engineers 63,303 Engineering 8C Sunset Ridge Sanitary Sewer -Construction 450,000 Engineering 8C Sunset Ridge Sanitary Sewer - SRF Bond Proceeds 68,000 Engineering 8C Catfish Inter Recon - Enviro Testing 38,400 Engineering 8C Catfish Inter Recon -Construction Not Building 2,542,870 Engineering 8C Catfish Inter Recon - SRF Bond Proceeds 1,077,194 Engineering 8C Catfish Inter Recon -Federal FEMA 1,435,688 Engineering 8C Catfish Inter Recon -State HSEM 191,425 Engineering 8C Catfish Inter Recon -State UST 38,400 Engineering 8C Southfork Interceptor -Consulting Engineers 50,388 Engineering 8C Century C1 Sewer Manholes -Engineering 4,000 Engineering 8C Century CI Sewer Manholes -Construction 15,000 Engineering 8C H&W Sanitary Sewer Project -Consulting Engineers 11,000 Engineering 8C H&W Sanitary Sewer Project -Construction Not Building 71,000 Engineering 8C Four Mounds Septic Replacement -Construction Not Building 42,520 City Manager 8C GIS Enhancements -Peripherals, Computer 5,291 City Manager 8C Budget Office Remodel -Furniture 804 Information Serv 8C Internet, Micros & Printer -Sewer Fund 1,239 Fund Activity/CIP Account Explanation 710 7101837 54230 C/O 710 7102043 72410 C/O 710 7101935 73410 C/O 710 7101012 73211 C/O 710 7101067 62731 C/O 710 7101293 73510 C/O 710 7101293 53102 C/O 710 7101294 73211 C/O 710 7101297 73510 C/O 710 7101297 62811 C/O 710 7101297 62761 C/O 710 7101307 73510 C/O 710 7101309 62811 C/O 710 7101320 73510 C/O 710 7101326 73211 C/O 710 7101327 73211 C/O 710 7101328 73211 C/O 710 7101335 73211 C/O 710 7101336 62811 C/O 710 7101336 73211 C/O 710 7101350 73510 C/O 710 7101636 73211 C/O 710 7101637 62811 C/O 710 7101637 73211 C/O 710 7101797 73211 C/O 710 7101797 62811 C/O 710 7101801 62712 C/O 710 7101801 73211 C/O 710 7101801 54230 C/O 710 7101802 62767 C/O 710 7101802 73211 C/O 710 7101802 54230 C/O 710 7101802 44405 New Grant 710 7101802 45701 New Grant 710 7101802 45701 New Grant 710 7101899 62712 C/O 710 7101905 62811 C/O 710 7101905 73211 C/O 710 7102013 62712 C/O 710 7102013 73211 C/O 710 7102014 73211 C/O 710 7101946 71120 C/O 710 7102177 71156 C/O 710 7101069 71124 C/O Page 16 FISCAL YEAR 2010 AMENDMENT #1 14-Sep-09 FY 10 FY 10 Expense Revenue Department Program Description Amount Amount Fund Activity/CIP Account Explanation TOTAL SANITARY SEWER CONST FUND 6,781,924 4,458,212 STORM WATER CONSTRUCTION FUND, Public Works 8C Bee Branch Pump Control -Eng. Division Services 5,175 720 7201668 62811 C/O Public Works 8C Bee Branch Pump Control -Construction 36,474 720 7201668 73211 C/O Public Works 8C GIS Mobile Mapping 1,245 720 7202043 72410 C/O Public Works 8C PW Fleet GPS Project -Equipment Acquisition 3,795 720 7201935 73410 C/O Engineering 8C Stonnwater Ditch Remediation 207,788 720 7201004 73211 C/O Engineering 8C General Repairs - Const Contract Supple (10,594) 720 7201066 73510 C/O Engineering 8C Streambank Rehab -Construction 32,811 720 7201352 73211 C/O Engineering 8C W 32nd Street Detention Basin -Construction 24,460 720 7201357 73211 C/O Engineering 8C W 32nd Street Detention Basin - SRF Bond Proceeds 89,120 720 7201357 54230 C/O Engineering 8C Detention Basin Maintenance -Construction Cont Supplem 20,669 720 7201359 73510 C/O Engineering 8C Gunite Rock Stormsewer -Construction 28,618 720 7201363 73211 C/O Engineering 8C Clifford and Lagen Storm -Consulting Eng 33,000 720 7201368 62712 C/O Engineering 8C Clifford and Lagen Storm -Construction Not Bldg 222,000 720 7201368 73211 C/O Engineering 8C Gen'1 Detention Basin Silt Removal. -Eng. Division Serv. 32,023 720 7201375 62811 C/0 Engineering 8C Gen'1 Detention Basin Silt Removal. -Construction 244,215 720 7201375 73211 C/O Engineering 8C Penn/JFK Culvert Improvements -Eng. Division Serv. 7,823 720 7201655 62811 C/O Engineering 8C Penn/JFK Culvert Improvements -Construction 144,125 720 7201655 73211 C/O Engineering 8C Storm Sewer Cleaning -Eng. Division Serv. 62,349 720 7201659 62811 C/O Engineering 8C Storm Sewer Cleaning -Construction 72,142 720 7201659 73211 C/O Engineering 8C Keyway Channel & Culvert Imp -Eng Division Services 67,223 720 7201662 62811 C/O Engineering 8C Keyway Channel & Culvert Imp -Construction 438,339 720 7201662 73211 C/O Engineering 8C Amy Ct Storm Sewer Imprv -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 Imprv -Construction 572,551 720 7201807 73211 C/O Engineering 8C Keyway/Rosemont Channel Imprv - SRF Bond Proceeds 319,396 720 7201807 54230 C/O Engineering 8C Villa St Storm Sewer Proj -Eng Division Services 12,081 720 7201809 62811 C/O Engineering 8C Villa St Storm Sewer Proj -Construction 95,000 720 7201809 73211 C/O Engineering 8C US 52 Storm Sewer -Private Participant 35,689 720 7201810 53102 C/O Engineering 8C Rosemont Culvert Improv. -Eng. Division Services 4,800 720 7201911 62811 C/O Engineering 8C Rosemont Culvert Improv. -Construction 77,409 720 7201911 73211 C/O Engineering 8C Stormwater System Assessment 226,741 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 H&W Storm Sewer -Construction 48,000 720 7202017 73211 C/O Engineering 8C H&W Storm Sewer -Consulting Engineers 7,000 720 7202017 62712 C/O Engineering 8C Rosemont/NW Arterial Channel -Construction 130,477 720 7202018 73211 C/O Engineering 8C Rosemont/NW Arterial Channel -Consulting Engineers 20,000 720 7202018 62712 C/O Engineering 8C Foye Storm Sewer Program -Construction 55,000 720 7202019 73211 C/O Engineering 8C Foye Storm Sewer Program -Consulting Engineers 8,000 720 7202019 62712 C/O Engineering 8C NPDES -Erosion Control -Eng. Division Services (26,491) 720 7202062 62811 FY10 Project started early Engineering 8C NPDES -Public Education -Eng. Division Services (9,366) 720 7202066 62811 C/O Page 17 FISCAL YEAR 2010 AMENDMENT #1 14-Sep-09 FY 10 FY 10 Expense Revenue Department Program Description Amount Amount Fund Activity/CIP Account Explanation Engineering 8C NPDES -Public Participation -Eng. Division Services (2,793) 720 7202067 62811 C/0 Engineering 8C Bee Branch Alignment -State Revolving Loan Funds 1,745,671 720 7201654 54230 C/O Engineering 8C Bee Branch Alignment -Eng. Division Services 3,856,939 720 7201654 73113 C/O Engineering 8C Bee Branch Alignment -Eng. Division Services 594,440 720 7201654 62811 C/0 Engineering 8C Bee Branch Alignment - Land/Acq-W/Improvements 1,629,850 720 7201654 73111 C/0 City Manager 8C Budget Office Remodel -Furniture 179 720 7202177 71156 C/O TOTAL STORM WATER CONST FUND 9,021,597 2,189,876 PARKING CON STRUCTION FiJND Pazking Division 8C Seal Coating Parking Lots -Consultant Services 8,451 730 7301380 62716 C/O Pazking Division 8C Seal Coating Pazking Lots -Construction Contract 120,993 730 7301380 73211 C/0 Pazking Division 8C Surface Sealing of 5th St -Construction 11,663 730 7301382 73210 C/O Pazking Division 8C Major Maintenance on Ramps -Architectural Serv. 4,901 730 7301385 62711 C/O Pazking Division 8C Major Maintenance on Ramps -Construction 35,287 730 7301385 73210 C/0 Pazking Division 8C Parking Equipment -Equip Acquisition 7,899 730 7301958 73410 C/O Pazking Division 8C Parking Ramp Occ Cert -Consulting Engineers 15,000 730 7302046 62712 C/0 Pazking Division 8C Locust St Ramp Sidewalk -Construction Not Building 21,155 730 7302047 73211 C/O Parking Division 8C 5th St Ramp Stair Doors -Construction Contract Building 3,988 730 7302048 73210 C/O Parking Division 8C Port of Dubuque Ramp Maint -Construction Not Building 84,993 730 7302162 73211 C/O Pazking Division 8C Locust Office Remodel -Construction (45,133) 730 7302170 73210 FY10 Project started early Parking Division 8C Walkway IA Ramp to NICC -Private Participant 36,500 730 7302049 53102 C/O City Manager 8C GIS Enhancements -Peripherals, Computer 5,291 730 7301946 71120 C/0 City Manager 8C Budget Office Remodel -Furniture 90 730 7302177 71156 C/O Information Serv 8C Internet, Micros & Printer -Pazking Fund 1,492 730 7301069 71124 C/O TOTAL PA ~"{rNG CONSTRUCTION FUND 276,070 36,500 WATER CONSTRUCTI ON FUND Water Departme~ 8C GIS MaintenanceNpgrade -Consulting Engineers 40,690 740 7401389 62712 C/O Water Departme~ 8C GIS Maintenance/Upgrade -Consulting Engineers 470 740 7401389 62716 C/O Water Departme~ 8C Service Line Assistance - Misc Services 24,685 740 7401390 62731 C/0 Water Deparlme~ 8C Service Line Assistance -Consulting Engineers 2,000 740 7401390 62811 C/O Water Departme~ 8C Water Line - DICW -Consulting Engineers 5,000 740 7401391 62712 C/O Water Departme~ 8C Service Line Assistance -Consulting Engineers 55,000 740 7401391 73211 C/O Water Departme~ 8C Water Internal Lines/Loan -Construction 195,504 740 7401398 73211 C/0 Water Departmei 8C Water Internal Lines/Loan -Eng. Division Services 15,000 740 7401398 62811 C/O Water Departme~ 8C Water Main Extensions -Construction 196,101 740 7401399 73211 C/0 Water Departme~ 8C Water Main Replacements -Eng. Division Services 36,000 740 7401405 62811 C/0 Water Depaztme~ 8C Water Main Replacements -Construction 37,171 740 7401405 73211 C/O Water Departmei 8C Fire Hydrant Replacements -Equip Acquisition 3,917 740 7401409 73410 C/O Water Departme~ 8C Valve Replacements -Construction 3,142 740 7401410 73211 C/O Water Depaztme~ 8C Valve Replacements -Construction 3,404 740 7401410 73410 C/O Water Departme~ 8C Water Main Extension/Annexation Related-Consult Eng 5,500 740 7401411 62712 C/0 Water Departme~ 8C Water Main Extension/Annexation Related-Construction 432,564 740 7401411 73211 C/O Water Depaztme~ 8C Water Main Extension/Annexation Related-Eng. Division 26,976 740 7401411 62811 C/O Page 18 FISCAL YEAR 2010 AMENDMENT #1 14-Sep-09 Department Program Description Water Departmei 8C Annual Tank Inspection -Consult Eng Water Departme~ 8C Annual Tank Inspection -Consultant Services Water Departme~ 8C Roosevelt Rd. Main Ext. -Consult Eng Water Departmei 8C Roosevelt Rd. Main Ext. -Construction Water Departme~ 8C IDSE Study for Distribution System -Construction Water Departme~ 8C Annexation Study/Implementation -Eng Division Water Departmei 8C Annexation Study/Implementation -Construction Water Departme~ 8C Vacuum Filter Back-Up -Construction Water Departrne~ 8C Olympic Heights Pump Station -Construction Water Departmei 8C ADA Improvements-Water Plant Water Departmei 8C Clear Well Reservoirs -Rehab -Consultant Services Water Departme~ 8C Clear Well Reservoirs -Rehab -Construction Water Departmei 8C Chlorine Sample Stations -Construction City Manager 8C GIS Implementation City Manager 8C GIS Enhancements -Peripherals, Computer City Manager 8C Budget Office Remodel -Furniture Information Serv 8C Intemet, Micros & Printer -Water Fund Information Serv 8C Internet, Micros & Printer -Water Fund TOTAL WATER CONSTRUCTION FUND LANDFILL FUND City Manager 8C Budget Office Remodel -Furniture Information Serv 8C Internet, Micros & Printer -Landfill Fund TOTAL LANDFILL FUND FY l0 FY 10 Expense Revenue Amount Amount Fund Activity/CIP Account Explanation 4,000 740 7401412 62712 C/O 14,302 740 7401412 62716 C/O 11,000 740 7401672 62712 C/O 32,868 740 7401672 73211 C/O 25,000 740 7401923 73211 C/O 65,500 740 7401954 62811 C/O 589,500 740 7401954 73211 C/O 72,125 740 7402030 73211 C/O 18,590 740 7402031 73211 C/O 36,090 740 7401402 73210 C/0 2,249 740 7401828 627]2 C/O 166,666 740 7401828 73210 C/O 16,363 740 7401832 73210 C/O 2,503 740 7401070 62731 C/O 2,841 740 7401946 71120 C/O 625 740 7402177 71156 C/O 2,000 740 7401069 71122 C/O 41,434 740 7401069 71124 C/O 2,186,780 - 179 940 9402177 71156 C/O 500 940 9401069 71124 C/O 679 - FY 2009 Encumbrance Carry Over's -Continuing Appropriation Authority GRAND TOTAL AMENDMENT #1 TRANSFERS Parks Division Trans0l Transfer from DRA Dist Fund to General Fund Parks Division Trans01 Transfer from DRA Dist Fund to General Fund Parks Division Trans02 Transfer from Sales Tax (20%) Fund to General Fund Parks Division Trans02 Transfer from Sales Tax (20%) Fund to General Fund Recreation Divis Trans03 Golf Activities(Profit)-Trans General Fd to Golf Constr Recreation Divis Trans03 Golf Activities(Profit)-Trans General Fd to Golf Constr Water Departmei Trans04 Transfer from Bond Proceeds Fd to Water Construction Fund Water Departme~ Trans04 Transfer from Bond Proceeds Fd to Water Construction Fund Water Departme~ Trans05 Transfer from Bond Proceeds Fd to Water Construction Fund Water Departme~ Trans05 Transfer from Bond Proceeds Fd to Water Construction Fund 14,866,196 70,992,442 45,722,393 Transfer Out Transfer In 10,000 100 1002084 59102 Trans Funds 10,000 102 10210102 91100 Trans Funds 12,000 100 1002084 59350 Trans Funds 12,000 350 35010350 91100 Trans Funds 72,803 100 10010100 91370 Golf Self Supporting-Intl Gen Fd PB 72,803 370 37010370 59100 Golf Self Supporting-Intl Gen Fd PB 155,000 740 7401405 59440 Trans Funds 155,000 440 44010440 91740 Trans Funds 25,000 740 7401672 59440 Trans Funds 25,000 440 44010440 91740 Trans Funds Page 19 FISCAL YEAR 2010 AMENDMENT #1 14-Sep-09 FY 10 FY 10 Expense Revenue Department Program Description Amount Amount Fund Activity/CIP Account Explanation Water Departme~ Trans06 Transfer from Bond Proceeds Fd to Water Construction Fund 655,000 740 7401954 59440 Trans Funds Water Departme~ Trans06 Transfer from Bond Proceeds Fd to Water Construction Fund 655,000 440 44010440 91740 Trans Funds Water Departmei Trans07 Transfer from Bond Proceeds Fd to Water Construction Fund 28,000 740 7402030 59440 Trans Funds Water Departme~ Trans07 Transfer from Bond Proceeds Fd to Water Construction Fund 28,000 440 44010440 91740 Trans Funds Water Departme~ Trans08 Transfer from Bond Proceeds Fd to Water Construction Fund 30,000 740 7401402 59440 Trans Funds Water Departme~ Trans08 Transfer from Bond Proceeds Fd to Water Construction Fund 30,000 440 44010440 91740 Trans Funds Airport Departm~ Trans09 Transfer from Sales Tax (20%) Fund to Airport Const. Fund 13,149 390 3901500 59350 Trans Funds Airport Departrn~ Trans09 Transfer from Sales Tax (20%) Fund to Airport Const. Fund 13,149 350 35010350 91390 Trans Funds Airport Departm~ Trans10 Transfer from DRA Gaming Fund to Airport Const. Fund 19,500 390 3901694 59101 Trans Funds Airport Departm~ Trans10 Transfer from DRA Gaming Fund to Airport Const. Fund 19,500 101 10110101 91390 Trans Funds Airport Departm~ Transl l Transfer from PFC Fund to Airport Construction Fund 21,632 391 39110391 91390 Trans Funds Airport Departm~ Transl l Transfer from PFC Fund to Airport Construction Fund 21,632 390 3901788 59391 Trans Funds Airport Departrrn Trans12 Transfer from PFC Fund to Airport Construction Fund 134,305 391 39110391 91390 Trans Funds Airport Departm~ Trans12 Transfer from PFC Fund to Airport Construction Fund 134,305 390 3901891 59391 Trans Funds Airport Departm~ Trans13 Transfer from DRA Dist Fund to Airport Construction Fund 54,000 102 10210102 91390 Trans Funds Airport Departm~ Transl3 Transfer from DRA Dist Fund to Airport Construction Fund 54,000 390 3901891 59102 Trans Funds Airport Departm~ Trans14 Transfer From Sales Tax 20% Fd to Airport Const. Fund 11,697 350 35010350 91390 Trans Funds Airport Departm~ Trans14 Transfer From Sales Tax 20%Fd to Airport Const. Fund 11,697 390 3901894 59350 Trans Funds Airport Departm~ Trans15 Transfer From Sales Tax 20% Fd to Airport Const. Fund 21,462 350 35010350 91390 Trans Funds Airport Departm~ Trans15 Transfer From Sales Tax 20% Fd to Airport Const. Fund 21,462 390 3902007 59350 Trans Funds Engineering Trans16 Transfer from DRA Gaming Fund to Sanitary Sewer Fund 50,000 101 10110101 91710 Trans Funds Engineering Trans16 Transfer from DRA Gaming Fund to Sanitary Sewer Fund 50,000 710 7101067 59101 Trans Funds Engineering Trans17 Transfer from Spec. Assessment Fd to Sewer Const Fund 60,000 255 25510255 91710 Trans Funds Engineering Trans17 Transfer from Spec. Assessment Fd to Sewer Const Fund 60,000 710 7101307 59255 Trans Funds Engineering Trans18 Transfer from Spec. Assessment Fd to Sewer Const Fund 124,000 255 25510255 91710 Trans Funds Engineering Trans18 Transfer from Spec. Assessment Fd to Sewer Const Fund 124,000 710 7101336 59255 Trans Funds Engineering Trans19 Transfer from Spec. Assessment Fd to Sewer Const Fund 52,500 255 25510255 91710 Trans Funds Engineering Trans19 Transfer from Spec. Assessment Fd to Sewer Const Fund 52,500 710 7101344 59255 Trans Funds Engineering Trans20 Trans from GO Bond Proceeds to Sewer Const Fund 212,420 440 44010440 91710 Trans Funds Page 20 FISCAL YEAR 2010 AMENDMENT #1 14-Sep-09 FY 10 FY 10 Expense Revenue Department Program Description Amount Amount Fund Activity/CIP Account Explanation Engineering Trans20 Trans from GO Bond Proceeds to Sewer Const Fund 212,420 710 7101350 59440 Trans Funds Engineering Trans2l Transfer from Spec. Assessment Fd to Sewer Const Fund 330,861 255 25510255 91710 Trans Funds Engineering Trans2l Transfer from Spec. Assessment Fd to Sewer Const Fund 330,861 710 7101638 59255 Trans Funds Engineering Trans22 Transfer from Spec. Assessment Fd to Sewer Const Fund 322,000 255 25510255 91710 Trans Funds Engineering Trans22 Transfer from Spec. Assessment Fd to Sewer Const Fund 322,000 710 7101801 59255 Trans Funds Engineering Trans23 Transfer from Spec. Assessment Fund to Stormwater Fund 2,000 255 25510255 91720 Trans Funds Engineering Trans23 Transfer from Spec. Assessment Fund to Stormwater Fund 2,000 720 7201359 59255 Trans Funds Engineering Trans24 Transfer from DRA Gaming Fund to Stormwater Fund 28,618 101 10110101 91720 Trans Funds Engineering Trans24 Transfer from DRA Gaming Fund to Stormwater Fund 28,618 720 7201363 59101 Trans Funds Engineering Trans25 Transfer From Sales Tax 20% Fd to Stormwater Const. Fund 13,800 350 35010350 91720 Trans Funds Engineering Trans25 Transfer From Sales Tax 20% Fd to Stormwater Const. Fund 13,800 720 7201666 59350 Trans Funds Engineering Trans26 Trans from GO Bond Proceeds to Stormwater Const Fund 55,000 440 44010440 91720 Trans Funds Engineering Trans26 Trans from GO Bond Proceeds to Stormwater Const Fund 55,000 720 7202017 59440 Trans Funds Engineering Trans27 Trans from GO Bond Proceeds to Stormwater Const Fund 150,477 440 44010440 91720 Trans Funds Engineering Trans27 Trans from GO Bond Proceeds to Stormwater Const Fund 150,477 720 7202018 59440 Trans Funds Engineering Trans28 Trans from GO Bond Proceeds to Stormwater Const Fund 63,000 440 44010440 91720 Trans Funds Engineering Trans28 Trans from GO Bond Proceeds to Stormwater Const Fund 63,000 720 7202019 59440 Trans Funds Engineering Trans29 Transfer from Special Assessment Fund to General Fund 15,055 100 1001108 59255 Trans Funds Engineering Trans29 Transfer from Special Assessment Fund to General Fund 15,055 255 25510255 91100 Trans Funds Engineering Trans30 Transfer from Spec. Assessment Fund to Street Const. Fund 471,000 255 25510255 91300 Trans Funds Engineering Trans30 Transfer from Spec. Assessment Fund to Street Const. Fund 471,000 300 3001633 59255 Trans Funds Engineering Trans3l Transfer from General Fund to Street Const Fund 157,517 100 10010100 91300 Trans Funds Engineering Trans3l Transfer from General Fund to Street Const Fund 157,517 300 3001633 59100 Trans Funds Engineering Trans32 Transfer from Spec. Assessment Fund to Street Const. Fund 204,000 255 25510255 91300 Trans Funds Engineering Trans32 Transfer from Spec. Assessment Fund to Street Const. Fund 204,000 300 3001972 59255 Trans Funds Engineering Trans33 Transfer from Spec. Assessment Fund to Street Const. Fund 90,000 255 25510255 91300 Trans Funds Engineering Trans33 Transfer from Spec. Assessment Fund to Street Const. Fund 90,000 300 3002022 59255 Trans Funds Engineering Trans34 Transfer from General Fund to America's River Fund 220,014 100 10010100 91700 Trans Funds Engineering Trans34 Transfer from General Fund to America's River Fund 220,014 700 7001853 59100 Trans Funds Page 21 FISCAL YEAR 2010 AMENDMENT #1 14-Sep-09 Department Program Description Engineering Trans35 Transfer from General Fund to America's River Fund Engineering Trans35 Transfer from General Fund to America's River Fund Engineering Trans36 Transfer from Sales Tax 20% Fund to General Fund Engineering Trans36 Transfer from Sales Tax 20% Fund to General Fund Engineering Trans37 Transfer from General Fund to DRA Gaming Fund E^~~^Pering Trans37 Transfer from General Fund to DRA Gaming Fund Engineering Trans38 Transfer from DRA Distrib. Fund to General Fund Engineering Trans38 Transfer from DRA Distrib. Fund to General Fund Engineering Trans39 Transfer from DRA Distrib. Fund to Sales Tax Const. Fund Engineering Trans39 Transfer from DRA Distrib. Fund to Sales Tax Const. Fund Engineering Trans40 Transfer from General Fund to Street Const Fund Engineering Trans40 Transfer from General Fund to Street Const Fund Engineering Trans41 Trans from GO Bond Proceeds to Stormwater Const Fund Engineering Trans41 Trans from GO Bond Proceeds to Stormwater Const Fund Building Service Trans42 Transfer from General Fund to General Const Fund Building Service Trans42 Transfer from General Fund to General Const Fund Economic Devlo Trans43 Trans from General Const Fund to UDAG Fund Economic Devlo Trans43 Trans from General Const Fund to UDAG Fund Planning Service Trans44 Trans from General Fund to DRA Distribution Fund Planning Service Trans44 Trans from General Fund to DRA Distribution Fund Planning Service Trans45 Trans from Street Const Fund to DRA Distribution Fund Planning Service Trans45 Trans from Street Const Fund to DRA Distribution Fund Economic Devlo Trans46 Transfer from GO Bond Fund to General Construction Fund Economic Devlo Trans46 Industrial Site Development -North Siegert -From GO Bonds TOTAL TRANSFERS GRAND TOTAL WITH TRANSFERS FY 10 FY 10 Expense Revenue Amount Amount 134,301 134,301 5,000 5,000 6,227 6,227 100,000 100,000 186,417 186,417 10,510 10,510 6,726,719 6,726,719 91,014 91,014 300,000 300,000 88,000 88,000 Fund Activity/CIP Account Explanation 100 10010100 91700 Trans Funds 700 7001854 59100 Trans Funds 350 35010350 91101 Trans Funds 101 1011034 59350 Trans Funds 100 10010100 91101 Trans Funds 101 1011034 59100 Trans Funds 102 10210102 91100 Trans Funds 100 1001854 59102 Trans Funds 102 350 100 300 440 720 360 100 360 265 100 102 (88,000) 102 (88,000) 360 (600,000) 440 (600,000) 360 10,845,998 10,845,998 81,838,440 56,568,391 Page 22 10210102 91350 C/O 3501861 59102 C/O 10010100 91300 C/O 3001252 59100 C/O 44010440 91720 Trans Funds 7201654 59440 Trans Funds 3601976 59102 Trans Funds 10010100 91360 Trans Funds 36010360 91265 Trans Funds 26510265 59360 Trans Funds 10010100 91102 Trans Funds 10210102 59100 Trans Funds 1021010 91360 Trans Funds 3602020 59102 Trans Funds 44010440 91360 Trans Funds 3601943 59440 Trans Fund THE CITY OF DuB E Masterpiece on the Mississippi September 3, 2009 TO: The Honorable Mayor and City Council Members FROM: Michael C. Van Milligen, City Manager SUBJECT: Fiscal Year 2010 First Budget Amendment ~S ~/ Dubuque ~~a~~°y M-AmeriCaCihr 2007 Budget Director Jennifer Larson is recommending the first Fiscal Year 2010 Budget Amendment be set for public hearing for September 21, 2009. I concur with the recommendation and respectfully request Mayor and City Council approval. Mi hael C. Van Milligen MCVM/jml Attachment cc: Barry Lindahl, City Attorney Cindy Steinhauser, Assistant City Manager Jennifer Larson, Budget Director THE CITY OF Dubuque _~ ~T T~ ~ A~ AmericaCity ~J Masterpiece on the Mississippi 2007 September 1, 2009 TO: Michael C. Van Milligen, City Manager FROM: Jennifer Larson, Budget Director SUBJECT: Fiscal Year 2010 First Budget Amendment The purpose of this memorandum is to provide an explanation regarding the first amendment for Fiscal Year 2010. This amendment is two fold. First, it amends the Fiscal Year 2010 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 2009 budget carryovers to Fiscal Year 2010 of encumbrances totaling $14,866,196, capital projects totaling $53,687,781 that were not completed during the prior Fiscal Year, and associated revenues totaling $38,559,719. There are operating budget appropriation carryovers of $939,737 and operating receivables of $2,152,392. Also, total transfers between funds of $10,845,998 are reflected. CARRYOVER AMENDMENT TO FISCAL YEAR 2010 During Fiscal Year 2009, a large number of projects were completed, which include finalizing additional America's River Projects, Police Mobile Data Computers, Fire Station #2 and #5 Interior and Exterior Improvements, Playground Improvements, Heron Pond Improvements, Town Clock Renovation, Park Maintenance Headquarters Improvements, Eagle Point Park Improvements, Skate Park Rebuild Ramps, Veterans Restroom Building, Carver Elementary School Play Unit, Five Flags Roof Replacement, Flora Pool Ozone Disinfectant, Bunker Cart Paths, Pond Renovation, and Fairway & Tee Mower, Replacement of Pool Drains, Water Shallow Well Rehab, Water Meter Replacement Program Study, Water Pollution Control Plant Final Clarifier Drive Replacement, Port of Dubuque Public Parking Ramp, Walkway from Iowa Ramp to NICC, Parking Locust Office Remodel, Airport Terminal Land Acquisition, Airport Asphalt Parking Lots, Transit System Study, Bee Branch Pump Auxiliary, Public Works Fleet GPS Project, Public Works Bucket Truck, Endloader, Dump Truck and Asphalt Paver Replacements, Floodwall Levee Slope Repair, West 32"d Street Detention Basin, Renovation of Economic Development/Sustainability Community Coordinator/Budget Offices, Grove Terrace Retaining Wall, High Bluff/Thomas Place Retaining Wall, St. Mary's Retaining Wall, Ice Harbor Transient Boat Docks, East/West Corridor Study, North Siegert Farm Phase I, Downtown Design Guidelines, Zoning Code Update, City Website Redesign and Enhancement, and City Phone System Upgrade. Many other enhancements are reflected throughout the community. Some significant projects were started and remain in process, which are carried forward into Fiscal Year 2010. The most significant of the capital project expenditure carryovers, including associated revenue, are: Sanitary Sewer System Improvements ($6,781,924); Rivers to the Sea Exhibit ($6,202,815); Airport Terminal Land Acquisition and Construction ($3,450,886); Storm Water System Improvements ($9,048,088); Transient Docks -Main Channel ($3,784,064); Southwest Arterial ($5,475,336); Traffic/Fiber Improvements ($2,206,623); Community Development Block Grant funded projects ($823,508); Water System Improvements ($2,186,780); Park Projects ($1,837,554); Bridge Improvements ($534,488); America's River Project ($678,153); Refuse Dual Packer Recycle Vehicles ($662,079); Homeownership Grants -Targeted Neighborhoods ($354,128); and Ice Harbor Maintenance/Dredging ($140,299). OPERATING BUDGET CARRYOVER AMENDMENT The most significant operating budget carryovers into Fiscal Year 2010 include such items as Library Materials ($40,827); Police Department Grants ($42,614); Human Rights Grant Appropriation ($57,080); Fire CPAT Costs ($31,160); Information Services Equipment and Training ($77,421); City Clerk Code Update and Civil Service Tests ($50,000); Transit Equipment ($62,379); Engineering Software and Education and Training ($36,623); Airport Radar Maintenance Fee ($25,000); Building Washington Neighborhood Alley Light Grant Program ($35,000); and Community Development Block Grant ($55,210). FIRST AMENDMENT TO THE FISCAL YEAR 2010 CERTIFIED BUDGET There have been numerous actions by City Council and changes requiring amendments for the Fiscal Year 2010 budget. The capital budget amendments total $594,084, with an increase in associated revenue of $3,990,765. The amendment items include: Green Alley Pilot Project ($246,202) funded by Community Development Block Grant -Recovery; Northwest Hike/Bike Trail ($157,392) from a REAP Grant; Public Works Street Sweeper ($165,000) from Fire Headquarters Green Roof Project; Multicultural Family Center ($93,457) from East/West Corridor Study and Port of Dubuque Outdoor Plaza savings; Library Renovation ($250,000) funded by an Iowa Great Places Grant; Millworking District Streetscape ($150,000) funded by an Iowa Great Places Grant; Hempstead Safety Improvements ($500,000) funded by an Iowa Department of Transportation grant; a reduction to the budget of North Siegert Farm to reflect actual project cost (-$1,400,000); North Fork Catfish Interceptor Reconstruction FEMA grant ($1,665,513); and Housing Trust, Homeless Prevention, and Neighborhood Stabilization Grants ($1,279,741) funded by various Federal and State grants. OPERATING BUDGET AMENDMENT The operating budget amendments total $904,644, with associated increase in revenue of $1,019,517. The amendment items include new Police Grants ($500,068); Community Development Block Grant -Recovery Funds ($328,369); AmeriCorps American Recovery and Reinvestment Act Grant ($184,344); Washington Neighborhood Development Corporation ($100,000) funded from Homeownership Grants -Targeted Neighborhoods; and Advertising for the 2010 Census ($25,000) from FY 2009 Department Savings; 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 21, 2009. Attachments JML RESOLUTION NO. -09 SETTING THE DATE FOR THE PUBLIC HEARING ON AMENDMENT NO. 1 TO THE FISCAL YEAR 2010 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 2010 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 21, 2009, 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 8th day of September 2009. Attest: Roy D. Buol, Mayor Jeanne F. Schneider, City Clerk Nov-07 NOTICE OF PUBLIC HEARING Form 653.C1 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 on 9/21/09 (hour) (Dare) ,for the purpose of amending the current budget of the city for the fiscal year ending June 30, 2010 /vearl 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. Total Budget as certified or last amended Current Amendment Total Budget after Current Amendment Revenues 8 Other Financing Sources Taxes Levied on Property 1 .................. 18,331,912 .................. .................. 18,331,912 Less: Uncollectted Property Taxes-Levy Year 2 0 0 Net Current Property Taxes 3 18,331,912 0 18,331,912 Delinquent Properly Taxes 4 0 0 TIF Revenues 5 6,610,851 6,610,851 Other City Taxes s 13,913,509 13,913,509 Licenses ~ Permits 7 1,336,745 1,336, 745 Use of Money and Property s 12,833,420 3,162 12,836,582 Intergovernmental s 32,378,001 28,976,442 61,354,443 Charges for services 10 27,378,276 44,000 27,422,276 Special Assessments 11 278,000 1,321,650 1,599,650 Miscellaneous t2 6,350,736 1,900,815 8,251,551 Other Financing Sources 13 101,166,396 24,322,322 125,488,718 Total Revenues and Other Sources 14 220,577,846 56,568,391 277,146,237 penditures & Other Financina Uses Public Safety 15 .................. .................. .................. .................. .................. ................... .................. ...... ........... .... . ........... 21,766,430 .................. ................... .................. ................... .................. ................... .................. ................... ................... 900,829 .................. ................... .................. ................... .................. ................... .................. ................... ................... ........ 22,667,259 Public works 16 11,593,287 280,110 11,873,397 Health and Social Services t7 847,063 111,332 958,395 Culture and Recreation 19 8,955,550 104,979 9,060,529 Community and Economic Development is 11,584,447 658,272 12,242,719 General Govemment 20 6,547,820 315,537 6,863,357 Debt Service 21 5,970,043 0 5,970,043 Capital Projects 22 30,619,440 44,707,574 75,327,014 Total Govemment Activities Expenditures 23 97,884,080 47,078,633 144,962,713 Business Type /Enterprises 24 70,940,795 23,913,809 94,854,604 Total Gov Activlties 8 Business Expenditures 25 168,824,875 70,992,442 239,817,317 Transfers Out 26 56,921,932 10,845,998 67,767,930 Total Expenditures/Transfers Out 27 225,746,807 81,838,440 307,585,247 Excess Revenues & Other Sources Over (Under) Expenditures/Transfers Out Fiscal Year 2s .................. -5,168,961 .................. -25,270,049 .................. -30,439,010 Continuing Appropriation 29 N/A 0 Beginning Fund Balance July 1 3o 30,078,556 13,520,014 43,598,570 Ending Fund Balance June 30 3t 24,909,595 -11,750,035 13,159,560 Explanation of increases or decreases in revenue estimates, appropriations, or available cash This amendment adds the capital budget carryovers of $53,687,781 & its associated revenue of $38,559,719, & encumbrance carryovers of $14,866,196 (continuing appropriation authority,not requiring formal amendmenU for reporting purposes only). It also adds operating budget carryovers of $939,737 & its associated revenue of $2,152,392, requiring a formal amendment. Also included in this amendment is $1,498,728 in new expense 8 associated revenue of $5,010,282 due to new funding sources. 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