Loading...
Fiscal Year 2013 First Budget AmendmentNOTICE OF PUBLIC HEARING AMENDMENT OF CURRENT CITY BUDGET Form 653.C1 The City Council of Dubuque In DUBUQUE will meet at City Council Chambers at the Historic Federal Building at 6:30 p.m. ? on 09/17/2012 (hour) (Date) ,for the purpose of amending the current budget of the city for the fiscal year ending June 30, by changing estimates of revenue and expenditure appropriations In the following programs for the reasons given. Additional detail Is available at the city clerk's office showing revenues and expenditures by fund type and by activity. County, Iowa 2013 (Year) Explanation of Increases or decreases in revenue estimates, approeatlonnss, or available cash: This amendment adds the capital budget carryovers of $77,397,388 & associated revenue of $62,233,518, & encumbrance carryovers of $20,209,008 (continuing appropriation "authority,not requiring formal amendment! or reporting purposes only). Adds operating budget carryovers of $1,065,112 & associated revenue of $1 ,361,319, requiring a formal amendment. Reduction of $1,915,103 in new expense & associated reduced revenue of $9,888,455 due to project borrowing done in previous fiscal year. Reduction in interfund transfers of $3,067,539, 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, ...9/5 Kevin S. Fimstahl, CMC City Clerk 518505 -01 -5 STATE OF IOWA {SS: DUBUQUE COUNTY CERTIFICATION OF PUBLICATION I, Suzanne Pike, a Billing Clerk for Woodward Communications, Inc., an Iowa corporation, publisher of the Telegraph Herald,a newspaper of general circulation published in the City of Dubuque, County of Dubuque and State of Iowa; hereby certify that the attached notice was published in said newspaper on the following dates: September 05, 2012, and for which the charge is $146.98. Subscribed to before me, a tary Public in and for Dubuque County, Iowa, , 20 7.. this /1r0 day of •1. -� Notary Public in and for Dubuque County, Iowa. Commti io Nui1bS(154, 9 Total Budget as cerlilied or I at amended Current Amendment Total Budget after Current Amendment Revenues & Other Flnanclna Sources 1 22,007,300 0 . 122,007,300 Taxes Levied on Propert Less: Uncollected Pro •erlyTaxes-Lev Year , 2 -. 0 0 0 Nat Current Pro • e Taxes 3 22,007,300. 0 22,007,300 Delin, cent Propel' Taxes 4 0 0 0 TIF Revenues 5 10,289,839 0 10,289,839 Other City Taxes 6 14,922 912 0 14,922,012 Licenses & Permits 7 1,339,574 0 0 MEM 12,385;426 Use of Mona and Pro.erty 8 12,366,426 Inte •ovemmental 9 50224931 40,.5916 91,08 0 1 Char as for Services `10 34,178,789 33,000 -34,211 789 S , eclal Assessments 11 74,273 1,769,541. Miscellaneous 12 6,759,820 1,784,648 Other Financin. Sources 13 92,703,315 6,207;492 98,91'., '07 Total Revenues and Other Sources ' 14 244,865,078 50,858,841 296,6$$` -;6 Expenditures & Other Flnanclna Uses 115 25,339,063. 508 630 25,045,893 Public Safet Public Works 18 12,049,060 398,928 12,447,988 Health and Social Serviced 17 1,030,919 105,134 1,136 053 Culture and Recreation 18 10 548195 128,007 10,674, 02 Communit and Economic Development 19 12,781,522 282,850 13,084,372 General Government 20 ,317,326 269,1103 7,504 919 Debt Service 21 0 6,994,075 Ca , Ital Pro ects 22 44 312,974 56,145,710 ' 100 458,;94 Total Government ActiVitba Expenditures 23 120,371,334 9 ` Business T is I Enter rises 24 94,088,699 214,480,033 36,999,E 3 96,838,385 133,088,432 311,296,418 Total Gov Activities & Business Expenditures 25 Transfers Out 28 32,484,076 - 3,087,539 29,398,537 Total Ex . enditureslTransfers Out 27 - 246,924,109 340 2,955 Ekcess Revenues & Other Sources Over Under Ex . endlturesrfransfers Out for Fiscal Yei 28 � -;. _ 2 059 031 8g03,768,846 - 43,110,005 - 451.89,036 22,279,858 43,110,005 65,389,883 Ele . Innin. Fund Balance Jul 1 39 ndln. Fund Balance June 30 31 20,220,527 0 20 220,827 Explanation of Increases or decreases in revenue estimates, approeatlonnss, or available cash: This amendment adds the capital budget carryovers of $77,397,388 & associated revenue of $62,233,518, & encumbrance carryovers of $20,209,008 (continuing appropriation "authority,not requiring formal amendment! or reporting purposes only). Adds operating budget carryovers of $1,065,112 & associated revenue of $1 ,361,319, requiring a formal amendment. Reduction of $1,915,103 in new expense & associated reduced revenue of $9,888,455 due to project borrowing done in previous fiscal year. Reduction in interfund transfers of $3,067,539, 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, ...9/5 Kevin S. Fimstahl, CMC City Clerk 518505 -01 -5 STATE OF IOWA {SS: DUBUQUE COUNTY CERTIFICATION OF PUBLICATION I, Suzanne Pike, a Billing Clerk for Woodward Communications, Inc., an Iowa corporation, publisher of the Telegraph Herald,a newspaper of general circulation published in the City of Dubuque, County of Dubuque and State of Iowa; hereby certify that the attached notice was published in said newspaper on the following dates: September 05, 2012, and for which the charge is $146.98. Subscribed to before me, a tary Public in and for Dubuque County, Iowa, , 20 7.. this /1r0 day of •1. -� Notary Public in and for Dubuque County, Iowa. Commti io Nui1bS(154, 9 31 -288 CITY BUDGET AMENDMENT AND CERTIFICATION RESOLUTION To the Auditor of DUBUQUE County, Iowa: The City Council of Dubuque in said County /Counties met on 09/17/2012 at the place and hour set in the notice, a copy of which accompanies this certificate and is certified as to publication. Upon taking up the proposed amendment, it was considered and taxpayers were heard for and against the amendment. The Council, after hearing all taxpayers wishing to be heard and considering the statements made by them, gave final consideration to the proposed amendment(s) to the budget and modifications proposed at the hearing, if any. thereupon, the following resolution was introduced. RESOLUTION No. 2 5 7 -12 A RESOLUTION AMENDING THE CURRENT BUDGET FOR THE FISCAL YEAR ENDING JUNE 31 2013 (AS AMENDED LAST ON 4 -16 -2012 .) Be it Resolved by the Council of the City of Dubuque Section 1. Following notice published 9 -18 -2012 and the public hearing held, 09/17/2012 the current budget (as previously amended) is amended as set out herein and in the detail by fund type and activity that supports this resolution which was considered at that hearing: Total Budget as certified or last amended Current Amendment Total Budget after Current Amendment Revenues & Other Financing Sources Taxes Levied on Property 1 22,007,300 22,007,300 Less: Uncollected Property Taxes -Levy Year 2 0 0 0 Net Current Property Taxes 3 22,007,300 0 22,007,300 Delinquent Property Taxes 4 0 0 0 TIF Revenues 5 10,289,639 0 10,289,639 Other City Taxes 6 14,922,012 0 14,922,012 Licenses & Permits 7 1,339,574 0 1,339,574 Use of Money and Property 8 12,365,425 0 12,365,425 Intergovernmental 9 50,224,931 40,859,160 91,084,091 Charges for Services 10 34,178,789 33,000 34,211,789 Special Assessments 11 74,273 1,769,541 1,843,814 Miscellaneous 12 6,759,820 1,789,648 8,549,468 Other Financing Sources 13 92,703,315 6,207,492 98,910,807 Total Revenues and Other Sources 14 244,865,078 50,658,841 295,523,919 Expenditures & Other Financing Uses Public Safety 15 25,339,063 506,630 25,845,693 Public Works 16 12,049,060 398,928 12,447,988 Health and Social Services 17 1,030,919 105,134 1,136,053 Culture and Recreation 18 10,546,195 128,007 10,674,202 Community and Economic Development 19 12,781,522 282,850 13,064,372 General Government 20 7,317,526 269,393 7,586,919 Debt Service 21 6,994,075 0 6,994,075 Capital Projects 22 44,312,974 56,145,710 100,458,684 Total Government Activities Expenditures 23 120,371,334 57,836,652 178,207,986 Business Type / Enterprises 24 94,088,699 38,999,733 133,088,432 Total Gov Activities & Business Expenditures 25 214,460,033 96,836,385 311,296,418 Transfers Out 26 32,464,076 - 3,067,539 29,396,537 Total Expenditures/Transfers Out 27 246,924,109 93,768,846 340,692,955 Excess Revenues & Other Sources Over (Under) Expenditures/Transfers Out Fiscal Year 28 - 2,059,031 - 43,110,005 - 45,169,036 29 Beginning Fund Balance July 1 30 22,279,858 43,110,005 65,389,863 Ending Fund Balance June 30 31 20,220,827 0 20,220,827 City Clerk/Finance Officer 17 (Day) day of Se ' tember 2 (Mont Signature Mayor FISCAL YEAR 2013 AMEN DM ENT #1 CITY COUNCIL 11- Sep -12 FY 13 FY 13 Expense Revenue Department Program Description Amount Amount Fund Activity /CIP Account Explanation GENERALFUND Police Department 1C Replace Police /CAD Software 600,000 101 1011167 71123 C/O Police Department 1C Replace Police /CAD Software - County Reimbursement 400,000 101 1011167 46205 C/O Police Department 1C Restore Police Car - Private Contributions 9,160 100 1002280 62528 C/O - Additional Contributions Police Department 1C Restore Police Car- Motor Vehicle Maintenance 11,288 100 1002280 62528 C/O Police Department 1 C Computer Storage System - Servers 22,683 101 1011752 71125 C/O Police Department 1C In -Car Video Recorders 7,183 101 1011580 73410 C/O Police Department 1 School Resource Officer - Dubuque Community Schools 62,600 100 10011322 53102 C/O Police Department 1 Narcotics Grant Investigation - Byrne /Jag Grant 23,458 101 1011320 44176 C/O Police Department 1 Records and ID - DCSO shared server 10,000 100 10011220 53620 C/O Police Department 1 2009 Justice Assistance Grant - Reimb OT 1,974 100 10011775 61051 C/O Police Department 1 2009 Justice Assistance Grant- Supplies /Equipment 1,334 100 10011775 72218 C/O Police Department 1 2009 Justice Assistance Stimulus Grant - Reimbursable OT 69,865 100 10011740 61051 C/O Police Department 1 2009 Justice Assistance Stimulus Grant - Misc Op Supplies 7,702 100 10011740 62671 C/O Police Department 1 2010 Justice Assistance Stimulus Grant - Reimbursable OT 16,498 100 10011776 61051 C/O Police Department 1 2010 Justice Assistance Stimulus Grant - Special Equip 29,064 100 10011776 72218 C/O Police Department 1 2010 Justice Assistance Stimulus Grant - Special Equip 39,979 100 10011752 72218 C/O Police Department 1 Domestic Abuse Grant - Federal Grant 1,972 100 10011754 44135 C/O Police Department 1 Police Traffic Service Grant - Governor's Traffic Safety 12,376 100 10011771 44125 C/O Police Department 1 Police Traffic Service Grant - Travel 849 100 10011771 62360 C/O Police Department 1 Police Traffic Service Grant - Reimb OT 7,658 100 10011771 61050 C/O Police Department 1 Police Admin - Training (30) 100 10011100 62360 C/O - Prespend FY13 Police Department 1 Police Training- Training 56,724 100 10011250 62360 C/O Police Department 1 Police Patrol - Training 52,260 100 10011700 62360 C/O Police Department 1 Police Patrol - Training (1,200) 100 10011700 62360 C /O- Prespend FY13 Police Department 1 Community Policing - Training 6,403 100 10011500 62360 C/O Police Department 1 Community Policing - Training (100) 100 10011500 62360 C/O - Prespend FY13 Emergency Communii 1 C Emergency Dispatch Protocols Software 60,000 100 1002186 71123 C/O Fire Department 1 Fire Training - Education & Training 7,505 100 10013200 62360 C/O Fire Department 1 Fire Suppression - Backup Camera 4,078 100 10013400 72113 C/O Fire Department 1C Pumper Replacement 17,752 102 1021016 71318 C/O Fire Department 1C Improvements to Fire Headquarters 27,363 101 1011139 73210 C/O Fire Department 1C Fire Protection Equipment Replacements 9,013 101 1012286 72116 C/O Fire Department 1C Fire Protection Equipment Replacements - Federal Grant 7,244 101 1012286 44170 C/O - Assistance to Firefighters Grant Fire Department 1C Smoke Detectors /Fire Extinguishers- Prevention Grant 22,421 101 1012345 44170 C/O Fire Department 1C Smoke Detectors /Fire Extinguishers- Safety Equipment 14,802 101 1012345 72116 C/O Fire Department 1C Station #6 Improvements - Construction 4,786 101 1012287 73210 C/O Human Relations 3 Human Relations Administration - Misc Operating Supplies 600 100 10016100 62671 C/O Human Relations 3 Human Relations Administration - Travel Conferences (2,105) 100 10016100 62310 C/O - Prespend FY13 Human Relations 3 Human Relations Administration - Travel City Business (100) 100 10016100 6232 C/O - Prespend FY13 Human Relations 3 Human Relations Grant Funds- Printing & Binding 32,275 100 10016200 62090 C/O Human Relations 3 Human Relations Grant Funds- Education & Training 13,589 100 10016200 62360 C/O Human Relations 3 Human Relations Grant Funds- Misc Services 17,089 100 10016200 62731 C/O Human Relations 3 Human Relations Grant Funds- Fair Housing Training 35,611 100 10016200 62753 C/O Health Services 1 Animal Control - Education & Training 427 100 10017200 62360 C/O Health Services 1 Animal Control - Uniforms 296 100 10017200 62011 C/O Health Services 3 Health Services Admin - Dues & Memberships (200) 100 10017100 62190 C/O - Prespend FY13 Health Services 3 Health Services Admin - Travel (455) 100 10017100 62310 C/O - Prespend FY13 Health Services 3 Community Health Services - Conferences 500 100 10017400 62310 C/O Page I FISCAL YEAR 2013 AMEN DM ENT #1 CITY COUNCIL 11- Sep -12 FY 13 FY 13 Expense Revenue Department Program Description Amount Amount Fund Activity /CIP Account Explanation Health Services 3 Community Health Services - Emergency Preparedness 2,000 100 10017400 45771 C/O Health Services 3 Lead Paint Program - Childhood Lead Grant 5,289 100 10017500 45701 C/O Health Services 3 Lead Paint Program - Childhood Lead Grant 4,945 100 10017500 45701 C/O Health Services 3 Lead Paint Program - Education & Training 2,500 100 10017500 62360 C/O Health Services 3 Food Inspections - Radon Grant 2,500 100 10017300 45701 C/O Health Services 3 Food Inspections - Travel Conferences 500 100 10017300 62310 C/O Parks Division 4C Ham House Repairs - Construction 30,000 102 1022184 73210 C/O - Shift from Retaining Walls Parks Division 4C Comiskey Repair Siding - Construction 15,675 102 1021151 73210 C/O Parks Division 4C Miller Riverview Rip Rap 57,816 100 1001170 73211 C/O Parks Division 4C Vets Memorial Park Ballfield - Construction 23,093 102 1021214 73211 C/O Parks Division 4C Comiskey Sidewalk Lights - Consulting 10,000 102 1021544 62712 C/O Parks Division 4C Comiskey Sidewalk Lights - Construction 90,000 102 1021544 73211 C/O Parks Division 4C Westbrook Park Development- Eng. Division Svcs 12,600 101 1011582 62712 C/O Parks Division 4C Westbrook Park Development- Construction 53,447 101 1011582 73211 C/O Parks Division 4C Highway 20 Roses Plan - Consulting 21,000 102 1021588 62712 C/O Parks Division 4C Eagle Point Park Stone - Construction 25,000 101 1011677 73211 C/O Parks Division 4C BMX Bike Course 4,379 102 1021871 73211 C/O Parks Division 4C Schmitt Island Master Plan - Consulting 100,000 102 1021883 62712 C/O Parks Division 4C Dubuque History Trail - Federal Grants 148,500 100 1001956 44170 C/O Parks Division 4C Dubuque History Trail - Consultant Services 14,850 100 1001956 62716 C/O Parks Division 4C Dubuque History Trail - Equipment Acquisition 133,650 100 1001956 73411 C/O Parks Division 4C Marshall Park - Pool Repair 18,721 101 1011983 73211 C/O Parks Division 4C Erosion Control Study 19,610 100 1001987 62712 C/O Parks Division 4C Roosevelt Property- Road Repair 1,246 102 1022103 73510 C/O Parks Division 4C Ham House Repairs - Construction 6,000 102 1022184 73210 C/O - Shift from Erosion Control Parks Division 4C Catfish Creek Hike -Bike Trail Study- Consultant Services 5,400 101 1012078 62716 C/O Parks Division 4C Park Drinking Fountains - Consultant Engineers 9,957 100 1002101 62712 C/O Parks Division 4C Greenhouse - Addition - Contt Contr - Bldg 85,173 102 1022104 73210 C/O Parks Division 4C EB Lyons Expansion - REAP Grant 200,000 100 1002171 45707 C/O Parks Division 4C EB Lyons Expansion - Land Acquisition 200,000 100 1002171 73110 C/O Parks Division 4C EPP - Rivertront Pavilion - Construction 12,435 102 1022190 62712 C/O Parks Division 4C EPP - Rivertront Pavilion - Consulting Engineers 131,847 102 1022190 73210 C/O Parks Division 2C NW Hike /Bike Trail - REAP Grant 20,000 100 1002273 45707 C/O Parks Division 2C NW Hike /Bike Trail - Construction Not Building 47,925 100 1002273 73211 C/O Parks Division 4C Dubuque Water Trail - State DNR Grant 6,000 100 1002277 45701 C/O Parks Division 4C Eagle Valley Park Development - Consulting 5,770 102 1022288 62712 C/O Parks Division 4C Eagle Valley Park Development - Construction 90,000 102 1022288 73211 C/O Parks Division 4C Eagle Point Park Overlay Tennis Court Lot - Consulting 9,000 102 1022289 62712 C/O Parks Division 4C Eagle Point Park Overlay Tennis Court Lot - Construction 83,040 102 1022289 73211 C/O Parks Division 4C Comiskey Entry Sign - Signage 7,000 102 1022293 71227 C/O Parks Division 4C Comiskey Playground Replacement - Playground Equip 200,000 102 1022292 72713 C/O Parks Division 4C Greenhouse Vent System - Construction 11,800 101 1012297 73210 C/O Parks Division 4C Lincoln Ave Spillway Replant - Construction 17,700 101 1012298 73211 C/O Parks Division 4C Hilltop Park - 735 Calendonia Place Expansion 17,094 102 1022449 73211 C/O - Shift from Elec to Pole Sheds Parks Division 4C Urban Youth Corp Grant - Fed Grant 6,275 100 1002343 45771 C/O Parks Division 4C S Grandview Park Entrance - Land Acquisition 11,460 100 1002440 73111 C/O Parks Division 4 Park Areas - Truck Replacement 26,000 100 10030400 71314 C/O Parks Division 4 Park Areas - Snow Blade 5,000 100 10030400 71619 C/O Parks Division 4 Greenhouse - truck accessories 4,496 100 10030500 71312 C/O Civic Center Division 4C Paint Arena Ceiling - Construction 95,000 101 1012117 73210 C/O Page 2 FISCAL YEAR 2013 AMEN DM ENT #1 CITY COUNCIL 11- Sep -12 FY 13 FY 13 Expense Revenue Department Program Description Amount Amount Fund Activity /CIP Account Explanation Civic Center Division 4C Five Flags Entryway Renovation - Misc Equipment 7,513 101 1012283 71550 C/O Civic Center Division 4C Five Flags Audio Equipment - PA System 37,475 101 1012302 72419 C/O Civic Center Division 4C Ice Machine Replacement - Concession Equipment 14,000 100 1002304 72310 C/O Conference Center 6C GRC- Replace Clouds 35,000 102 1022305 73210 C/O Conference Center 6C GRC- Replace Outdoor Furniture 35,000 102 1022306 71156 C/O Conference Center 6C GRC- Cool Room Study 25,000 102 1022307 71156 C/O Recreation 4C Flora & Sutton Pool Storage 1,738 101 1012334 73210 C/O - A/C Concession Stands Library 4 Children Services- Books 1,324 100 10036400 62651 Lost Book Fees Library 4 Children Services - Speakers /Programs (425) 100 10036400 62734 C/O - Prespend FY13 Library 4 Adult Services - Books 3,242 100 10036200 62659 Lost Book Fees Library 4 Adult Services - Travel City Business (400) 100 10036200 62310 C/O - Prespend FY13 Library 4 Children Services - Travel Conferences (400) 100 10036210 62310 C/O - Prespend FY13 Airport Department 2 Airport Operations - Misc Services 25,000 100 10051400 62731 C/O Public Works 2C Underground Tank Removal 750 100 1002152 73211 C/O Public Works 2C Bi- Lingual Trail Signage- Signage 14,595 100 1002169 71227 C/O Engineering 2C Accessibility Barriers- Construction 19,537 101 1011034 73210 C/O Engineering 2C Curb /Catch Basin Replacement- Construction 43,290 102 1021041 73211 C/O Engineering 2C Riverfront Leasehold Improvements- Consultant Services 12,000 101 1011053 62716 C/O Engineering 4C Library Renovation - Construction 8,382 100 1001141 73210 C/O Engineering 4C Library Renovation - Contributions 29,813 100 1001141 53103 C/O - Pledges Receivable Engineering 4C Library Renovation - Sale of Assets - Heade Painting 253,710 100 1001141 54104 C/O - Heade Painting Receivable Engineering 2C Decorative Concrete Maint- Construction 33,703 102 1021630 73211 C/O Engineering 2C Federal Building Renovation - Construction 68,499 102 1021841 62712 C/O Engineering 2C Port of Dubuque Outdoor Plaza - Eng Division Services 100,000 100 1001855 62811 C/O Engineering 2C Port of Dubuque Outdoor Plaza - Construction 600,000 100 1001855 73211 C/O Engineering 2C Port of Dubuque Outdoor Plaza - Private Participant 450,000 100 1001855 53102 C/O Engineering 2C Riverwalk Security Camera- Camera Related Equipment 29,578 100 1001963 72417 C/O Engineering 2C Ice Harbor Maintenance /Dredging 101,500 102 1021466 73211 C/O Engineering 2C Tourism Signage Program - Signage 24,853 102 1021512 71227 C/O Engineering 2C Downtown Street Light Replacement 33,971 102 1021608 73410 C/O Engineering 2C Fiber Optic Con - Priv & Misc - Eng Division Svc 49,256 102 1021609 73211 C/O Engineering 2C Transient Docks- Main Channel - Consulting Engineers 60,450 101 1011861 62712 C/O Engineering 2C Safes Routes to School - Const Contract Not Building 104,156 101 1011922 73211 C/O Engineering 2C Safes Routes to School - IDOT Grant 70,750 101 1011922 45701 C/O Engineering 2C Riverwalk Security Camera- Camera Related Equipment 5,000 102 1021963 72417 C/O Engineering 2C Flood Plain Buyout (336) 101 1012419 73111 C /O- Prespend FY13 Engineering 2C Port of Dubuque - Leasehold Improvements 27,584 102 1022330 73211 C/O Engineering 2C Port of Dubuque - Leasehold Improvements 3,500 101 1012330 73211 C/O Engineering 2C Recon Sign als /JFK- Wacker- Construction 147,965 101 1011919 73211 C/O Engineering 2C 5 Points Intersection Signal - Construction 77,712 102 1021920 73211 C/O Building Services 1 Building Services Admin - Light Grants 34,900 100 10057100 62765 C/O Building Services 1 Building Services Admin - Travel (335) 100 10057100 62310 C/O - Prespend FY13 Economic Developme 5C Port of DBQ- Develop.Standards (Int Write Down) 35,353 100 1001207 62764 C/O Economic Developme 5C Port of DBQ- Develop.Standards (Int Write Down) 15,000 102 1021207 62764 C/O Economic Developme 5C Warehouse Master Planning - Private Participant 11,000 100 1002081 53102 CO - John Gronen Housing & Comm Deg 6 Federal Building - Property Maintenance 118,881 100 10061150 62431 C/O Housing & Comm Deg 5C Maint of Vacant /Abandoned - Property Maintenance 105,641 101 1011002 73210 C/O Housing & Comm Deg 5C Maint of Vacant /Abandoned - Property Maintenance 102,256 100 1001002 73210 C/O Housing & Comm Deg 5C Purchase /Resale /Rehab- Land Acquisition 50,000 102 1021231 73111 C/O Housing & Comm Deg 5C Historic Preservation Revolving Loan 200,000 100 1001247 54210 C/O Page 3 FISCAL YEAR 2013 AMEN DM ENT #1 CITY COUNCIL 11- Sep -12 Page 4 FY 13 FY 13 Expense Revenue Department Program Description Amount Amount Fund Activity /CIP Account Explanation Housing & Comm Deg 5C Historic Preservation Revolving Loans 200,000 100 1001247 62764 C/O Housing & Comm Deg 5C Homeownership Grants - Target 277,197 101 1011595 62765 C/O Housing & Comm Deg 5C Homeownership Grants - Target 70,000 102 1021595 62765 C/O Housing & Comm Deg 5C Homeless Prevention Grant - Federal Stimulus Grant 988 100 1002175 44175 C/O Housing & Comm Deg 5C NBHD Stabilization Grant - Stimulus Fed Pass Thru Grant 134,728 100 1002180 44176 C/O Housing & Comm Deg 5C NBHD Stabilization Grant - Land Acquisition with Improv. 67,098 100 1002180 73111 C/O Housing & Comm Deg 5C NBHD Stabilization Grant - Land Acquisition with Improv. 2,812 100 1002180 73111 C/O Housing & Comm Deg 5C NBHD Stabilization Grant - Land Acquisition with Improv. 750 100 1002180 73111 C/O Housing & Comm Deg 5C NBHD Stabilization Grant - Land Acquisition with Improv. 52,000 100 1002180 73111 C/O Housing & Comm Deg 5C Healthy Homes Grant - HUD Payments 249,113 100 1002340 44310 C/O Housing & Comm Deg 5C Healthy Homes Grant- Grants 39,146 100 1002340 62765 C/O Housing & Comm Deg 5C IFA Our Home Grant - Grants 250,000 100 1002269 62765 C/O Housing & Comm Deg 5C IFA Our Home Grant - Iowa Finance Authority 250,000 100 1002269 45703 C/O Housing & Comm Deg 5C IFA Housing Grant 10 -10 4,500 100 1002270 62765 C/O Housing & Comm Deg 5C IFA Housing Grant 11 -19 92,607 100 1002285 62765 C/O Housing & Comm Deg 5C IFA Housing Grant 12 -14 132,637 100 1002443 45703 C/O Housing & Comm Deg 5 Rehab Program - Property Taxes 7,783 100 10061300 62211 C/O Housing & Comm Deg 5 445 Loras - Maintenance 8,386 100 10061710 62431 C/O Housing & Comm Deg 5 Getting Ahead - Programming 5,600 100 10061921 62140 C/O Housing & Comm Deg 5 Circles - Programming 10,194 100 10061922 62140 C/O Housing & Comm Deg 5 Housing Circles Program - Furniture (3,200) 100 10061922 71211 C/O - Prespend FY13 Housing & Comm Deg 5 Housing Circles Program - Computer (2,100) 100 10061922 71124 C/O - Prespend FY13 Housing & Comm Deg 5 Housing Circles Program - Phone (250) 100 10061922 71110 C/O - Prespend FY13 Housing & Comm Deg 5 Section 8 Voucher- Furniture (3,500) 100 10061600 71211 C /O- Prespend FY13 Housing & Comm Deg 5 Section 8 Voucher- Computer (4,200) 100 10061600 71124 C /O- Prespend FY13 Housing & Comm Deg 5 Section 8 Voucher- Phone (250) 100 10061600 71110 C /O- Prespend FY13 Housing & Comm Deg 5 Section 8 Voucher- Construction (7,000) 100 10061600 73210 C /O- Prespend FY13 Housing & Comm Deg 5 Housing Administration - Phone (250) 100 10061100 71110 C/O - Prespend FY13 Housing & Comm Deg 5 Housing Administration - Pay to Other Agency 105,000 100 10061100 62761 C/O Planning Services 5C Historic District Improvements - Construction 25,305 100 1001010 62711 C/O Planning Services 5C Historic District Improvements - Construction 95,873 102 1021010 73210 C/O Planning Services 5C Annexation Study /Implementation - Consultant Services 10,199 102 1021012 62716 C/O Planning Services 5 Development Services - Travel Conferences 2,000 100 10062400 62310 C/O - Smart Growth Conference City Council 6 City Council - Travel Conferences (295) 100 10070100 62310 C/O - Prespend FY13 City Manager 6C GIB Implementation - Consultant Services 1,852 100 1001070 62716 C/O City Manager 6C GIB Enhancements - Peripherals, Computer 3,082 102 1021946 71120 C/O City Manager 6C City of Dbq 175th Birthday 3,390 100 1001948 62734 C/O City Manager 6C GIB Training 7,760 100 1002165 62360 C/O City Manager 6C Americas River Fest Equip 14,587 100 1002050 72115 C/O City Manager 6C Sustainability Initiative - Consultant Services 17,064 102 1022218 62716 C/O City Manager 6C Electric PILOT Program Consultant Services 2,980 100 1002272 62716 C/O City Manager 6C Climate Showcase Grant - Consultant Services 310,394 100 1002334 62716 C/O City Manager 6C Climate Showcase Grant - Federal Grants 313,467 100 1002334 44170 C/O City Manager 6C EECBG Grant - Grants 102,042 100 1002338 62716 C/O City Manager 6C EECBG Grant - Federal Grants 102,042 100 1002338 44175 C/O City Manager 6C Marketing Grant - Vision Iowa 5,000 100 1002275 45761 C/O City Manager 6 City Manager - Full Time Employee 7,887 100 10072100 61010 FY13 Manager Increase City Manager 6 City Manager - Social Security 117 100 10072100 61320 FY13 Manager Increase City Manager 6 City Manager- IPERS 459 100 10072100 61310 FY13 Manager Increase City Manager 6 City Manager - Life Insurance 16 100 10072100 61416 FY13 Manager Increase Page 4 FISCAL YEAR 2013 AMEN DM ENT #1 CITY COUNCIL 11- Sep -12 Department City Manager City Manager City Manager City Manager City Manager City Manager City Manager City Manager City Manager City Manager City Clerk Finance Finance Information Services TRANSIT FUND Transit Division Transit Division Transit Division Transit Division Transit Division Transit Division Transit Division Transit Division Transit Division Transit Division Transit Division Transit Division Transit Division Transit Division Transit Division Transit Division Transit Division Program Description 6 City Manager - Car Allowance 6 Administration - Spirit Expense 6 Administration - Travel Conference 6 Administration - Travel Conference 6 Budget- Education & Training 6 Special Projects Art Grants - Pay to Other Agency 6 Our Town NEA Grant 6 Our Town NEA Grant - Pay to Other Agency 6 Public Information - Travel Conferences 6 Sustainability- Seasonal Employees 6 Administration - Education & Training 6C Finance Plus Upgrade - Software 6C Software Upgrade E -Gov- Software 6 City -Wide Computer Replacements TOTAL GENERAL FUND 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C FY 13 FY 13 Expense Revenue Amount Amount 179 3,342 (155) (665) 1,500 5,341 100,000 100,000 (455) 3,000 4,000 4,500 6,241 2,100 7,015,975 3,238,828 Fund Activity /CIP Account Explanation 100 10072100 61655 FY13 Manager Increase 100 10072100 62756 C/O 100 10072100 62310 C/O - Prespend FY13 100 10072100 62320 C/O - Prespend FY13 100 10072400 62360 C/O - NCDA speaker revenue 100 10072500 62761 C/O 100 10072500 44170 C/O 100 10072500 62761 C/O 100 10072300 62310 C/O - Prespend FY13 100 10072200 61030 C/O - SD Intern 100 10073100 62360 C/O 100 1002166 71123 C/O 100 1002217 71123 C/O 102 1021069 71124 C/O - Park Patrol Replace Mini Buses - Clean Fuels Grant 64,622 600 6001222 44150 C/O Replace Fixed Route Buses - State of Good Repair Grant 698,885 600 6001224 44150 C/O Replace Fixed Route Buses - Equipment 557,150 600 6001224 73411 C/O Transit Roof Repair - State Grant 245,000 600 6001613 45701 C/O Transit Roof Repair- Construction 243,510 600 6001613 73210 C/O Intermodal Feasibility Study - Construction 12,308,405 600 6001614 62716 C/O Intermodal Feasibility Study- State Grants 8,000,000 600 6001614 45701 C/O Keyline Facility Improvements 33,200 600 6002045 73210 C/O Keyline Facility Improvements - State Grant 12,610 600 6002045 45701 C/O Electronic Fare Boxes 477,525 600 6002321 71120 C/O Bus Stop Improvements - ARC Transfer Station 265,063 600 6002235 73210 C/O Bus Stop Improvements - Public Transportation Infrast. Grant 254,248 600 6002235 45701 C/O Intermodal Feasibility Study- Consulting 120,000 600 6001614 62716 C/O - shift from 1 -Wayto 2 -Way Intermodal Feasibility Study- Consulting 1,230,000 600 6001614 62716 C /O- shift from Millwork Parking Transit Administration - FTA Operating Assistance 440,058 600 60053100 44160 C/O Minibus Operations - East Dubuque Contract 33,000 600 60053500 51715 C/O Transit Administration - State Transit Assistance 23,396 600 60053100 45701 State Transit Assistance TOTAL TRANSIT FUND 15,234,853 9,771,819 DUBUQUE INDUSTRIAL PARK Economic Developme 5 Dubuque Industrial West - BAB Subsidy Parks Division 4 Industrial Center West - accessories for truck TOTAL DUBUQUE INDUSTRIAL CENTER -TIF FUND TECHNOLOGY PARK SOUTH Parks Division 4 Tech Park South - accessories for truck TOTAL TECHNOLOGY PARK SOUTH -TIF FUND GREATER DOWNTOWN T1F -TIF FUND Economic Developme 5C Downtown Rehab Consultant - Financial Consultant TOTAL GREATER DOWNTOWN T1F -TIF FUND DOWNTOWN LOAN POOL - T1F FUND Economic Developme 5C Loan Pool, Downtown TIF - Loans 28,370 210 21060210 44100 BAB Subsidy 1,768 210 21030530 71315 C/O 1,768 28,370 6Y�ir�Ybi�YbY�irb9Aii Ki 6�NL�] 30,000 240 2402157 62721 C/O 30,000 537,733 241 2411033 62764 C/O Page 5 FISCAL YEAR 2013 AMEN DM ENT #1 CITY COUNCIL FY 13 FY 13 Expense Revenue Department Program Description Amount Amount Fund Activity /CIP Account Explanation Economic Developme 5C Downtown Rehab Grant Program 34,467 241 2411942 62765 C/O TOTAL DOWNTOWN LOAN POOL -T1F FUND 572,200 - ROAD USE TAX FUND Engineering 2C Fiber Optic Conduit Project - Construction 61,669 250 2501017 73211 C/O Engineering 2C Brunskill Rd Bridge Repl - Construction 173,091 250 2501077 73211 C/O Engineering 2C Railroad Cross Improvement - Construction 9,208 250 2502026 73211 C/O Engineering 2C NW Arterial Capacity Imp 42,343 250 2501814 73211 C/O Engineering 2C LED Re -Lamp Schedule- Construction 41,063 250 2501916 73211 C/O TOTAL ROAD USE TAX FUND 327,374 - RESTRICTED TERMINAL PROJECT FUND Airport Department 2C Restricted Terminal Project - Private Participant 9,927 252 2522447 73210 C/O Airport Department 2C Restricted Terminal Project - Investment Fees (230) 252 2522447 73210 C/O TOTAL RESTRICTED TERMINAL PROJECT FUND 9,697 - SPECIAL ASSESSMENT FUND Engineering 2C Special Assessment Receivable 217,772 255 25510255 52101 C/O Engineering 2C Special Assessment Receivable 296,000 255 25510255 52101 C/O Engineering 2C Special Assessment Receivable 212,000 255 25510255 52101 C/O Engineering 2C Special Assessment Receivable 89,000 255 25510255 52101 C/O Engineering 2C Special Assessment Receivable 110,000 255 25510255 52101 C/O Engineering 2C Special Assessment Receivable 233,650 255 25510255 52101 C/O Engineering 2C Special Assessment Receivable 124,000 255 25510255 52101 C/O Engineering 2C Special Assessment Receivable 180,119 255 25510255 52101 C/O Engineering 2C Special Assessment Receivable 307,000 255 25510255 52101 C/O TOTAL SPECIAL ASSESSMENT FUND - 1,769,541 COMMUNITY DEVELOPMENT BLOCK GRANT FUND City Manager 6C Neighborhood Grants 5,174 260 2601238 62765 C/O Engineering 2C Accessible Curb Ramps - Construction 22,787 260 2601236 73211 C/O CDBG Funds Building Services 6C Kephart Building Improvement- Construction 76,259 260 2601976 73210 C/O CDBG Funds Economic Developme 5C Commercial /Industrial Rehab Loan - CDBG 60,562 260 2601235 62764 C/O CDBG Funds Economic Developme 5C Commercial /Industrial Rehab Loan - CDBG 117,948 260 2601746 62764 C/O CDBG Funds Housing & Comm Deg 5C Homeownership Rehab Program -Loans 91,660 260 2601065 62764 C/O CDBG Funds Housing & Comm Deg 5C Homeownership Rehab Program -Loans 68,669 260 2601065 73210 C/O CDBG Funds Housing & Comm Deg 5C Purchase /Resale /Rehab- Construction 29,369 260 2601231 73210 C/O CDBG Funds Housing & Comm Deg 5C Lead Paint Abatement Program - Loans 14,426 260 2601232 62764 C/O CDBG Funds Housing & Comm Deg 5C Rental Rehab - Loans 46,960 260 2601233 62764 C/O CDBG Funds Housing & Comm Deg 5C First Time Homebuyer Program -Loans 50,000 260 2601234 62764 C/O CDBG Funds Housing & Comm Deg 5C Historic Preservation Rehab Grant -Loans 7,059 260 2601237 62764 C/O CDBG Funds City Manager 5 Neighborhood Development- Zoning Enforcement 3,139 260 26072800 62834 C/O - CDBG Housing & Comm Deg 5 Housing Rehab - NeighborWorks Certification 5,068 260 26061300 62360 C/O - CDBG Human Relations 3 Community Development Block Grant - Dispute Resolution 332 260 26016100 62140 C/O CDBG Funds Human Relations 3 Community Development Block Grant - Dispute Resolution 500 260 26016100 62360 C/O CDBG Funds Housing & Comm Deg 5 Community Development Block Grant 663,121 260 26061800 44205 C/O CDBG Funds Engineering 5C Neighborhood Infrastructure Improvements- Construction 17,131 260 2601239 73211 CDBG Amend #1 TOTAL CDBG FUND 617,043 663,121 CARADCO COMMUNITY DEVELOPMENT BLOCK GRANT FUND Page 6 11- Sep -12 FISCAL YEAR 2013 AMEN DM ENT #1 CITY COUNCIL FY 13 FY 13 Expense Revenue Department Program Description Amount Amount Fund Activity /CIP Account Explanation Economic Developme 5C CDBG Grant - Caradco 1,705,556 263 2632341 45771 C/O TOTAL CARADCO CDBG FUND - 1,705,556 UDAG FUND Economic Developme 5C Job Creation - Loans 21,480 265 2651246 62764 C/O Economic Developme 5C Historic Preservation - Revolving Loans 31,247 265 2651247 62764 C/O Economic Developme 5C Airport Revenue Guarantee - Pay to Other Agency 150,000 265 2651796 62761 C/O TOTAL UDAG FUND 202,727 - STATE RENTAL REHAB FUND Housing & Comm Deg 5C Homeownership Rehab Program- Construction 480,837 270 2701065 73210 C/O Housing & Comm Deg 5C Homeownership Rehab Program- Construction 9,293 270 2701065 73210 C/O Housing & Comm Deg 5C Home - Rental Five Points 36,845 270 2701250 73210 C/O TOTAL STATE RENTAL REHAB FUND 526,975 - LEAD PAINT GRANT FUND Housing & Comm Deg 5 Lead Paint Grant 275,630 275 2752429 44310 C/O Housing & Comm Deg 5 Lead Paint Grant - Training Fees 5,665 275 27561211 62360 C/O Housing & Comm Deg 5 Lead Paint Grant - Software 33,668 275 27561200 71123 C/O Housing & Comm Deg 5 Lead Paint Grant - Grants 24,650 275 2752429 62764 C/O TOTAL LEAD PAINT GRANT FUND 63,983 275,630 CABLE TV FUND City Manager 6 Public Information - Printing & Binding 20,000 290 29072300 62090 C/O TOTAL CABLE TV FUND 20,000 - STREET CONSTRUCTION FUND Engineering 2C Signalization Program - Equipment Acquisition 79,381 300 3001011 73410 C/O Engineering 2C Fiber Optic Conduit Project - Construction 78,173 300 3001017 73211 C/O Engineering 2C Brunskill Rd Bridge Repl - Construction 718,169 300 3001077 73211 C/O Engineering 2C Brunskill Rd Bridge Repl - State Grant 722,000 300 3001077 45701 C/O Engineering 2C Bridge Repairs /Maintenance - Construction 2,600 300 3001258 73211 C/O Engineering 2C Southwest Arterial- Construction Not Building 3,931,675 300 3001287 73113 C/O Engineering 2C Southwest Arterial - SAFETEA -LU 6,958,717 300 3001287 45771 C/O Engineering 2C Southwest Arterial- County Match 511,885 300 3001287 46205 C/O Engineering 2C White Water Creek Bridge - State Grant 13,650 300 3001634 45701 C/O Engineering 2C White Water Creek Bridge - Private Participant 10,000 300 3001634 53102 C/O Engineering 2C Sub - Divisions Subdrains - Construction Not Building 173,360 300 3002023 73211 C/O Engineering 2C Sub - Divisions Subdrains- Consulting Engineers 28,125 300 3002023 62712 C/O Engineering 2C US 61/151 Corridor- State Grants - ICAAP 19,953 300 3002028 45701 C/O Engineering 2C US 61/151 Corridor- Federal Pass Thru Grant - USTEP 5,323 300 3002028 45771 C/O Engineering 2C US 61/151 Corridor- Federal Pass Thru Grant - STP 12,889 300 3002028 45771 C/O Engineering 2C US 61/151 Corridor -3R Primary 2,908 300 3002028 45771 C/O Engineering 2C NW Arterial Capacity Imp - Contt. Contr Not Building 132,349 300 3002029 73211 C/O Engineering 2C Cedar Cross Reconstruction - State Highway Assistance 1,280,000 300 3002139 45725 C/O Engineering 2C Cedar Cross Reconstruction - Land Acquisition 307,498 300 3002139 73111 C/O Engineering 2C Cedar Cross Reconstruction - Construction 1,412,000 300 3002139 73211 C/O Engineering 2C Cedar Cross Reconstruction - Consulting Eng 49,817 300 3002139 62712 C/O Engineering 2C Kaufmann Ave Resurfacing - Fed Pass thru State Grant 36,177 300 3002140 45771 C/O Engineering 2C SW Arterial - US 20 Cap Imp - Consulting 43,927 300 3002247 62712 C/O Page 7 11- Sep -12 FISCAL YEAR 2013 AMEN DM ENT #1 CITY COUNCIL 11- Sep -12 Page 8 FY 13 FY 13 Expense Revenue Department Program Description Amount Amount Fund Activity /CIP Account Explanation Engineering 2C SW Arterial - US 20 Cap Imp - State Grants 100,000 300 3002247 45701 C/O Engineering 2C N Grandview Estates Road- Construction 210,204 300 3002336 73211 C/O Engineering 2C N Grandview Estates Road- Reimbursements 33,163 300 3002336 53620 C/O Engineering 2C Manson Road Bridge - FEMA 75,000 300 3002349 44405 C/O Engineering 2C Signalization Program - Equipment Acquisition 76,868 300 3001011 73410 C/O Engineering 2C Traffic Signal Masterarm Rep. - Construction 15,097 300 3001133 73211 C/O Engineering 2C Traffic Signal Interconnect - Construction Not Building 41,854 300 3001266 73211 C/O Engineering 2C Traffic Controller Replacement - Equip Acquisition 52,000 300 3001274 73410 C/O Engineering 2C Street Light Replacement - Construction 42,698 300 3001549 73211 C/O Engineering 2C Signal Intersec Reconstruc- Construction 14,359 300 3001615 73211 C/O Engineering 2C Traffic Signal Fiber Optic Net - Construction 57,175 300 3001631 73211 C/O Engineering 2C Traffic Signal Video Detection 6,804 300 3001816 73211 C/O Engineering 2C Ramona /Pamela- Eng Division Services (290) 300 3001819 62811 C /O- Prespend FY13 Engineering 2C Fiber Optic Conduit - Misc - Construction 51,466 300 3002144 73211 C/O Engineering 2C Crosswalk Warning Devices 20,000 300 3002246 73211 C/O Engineering 2C Central Avenue Payment - IDOT 59,846 300 3002248 45725 C/O Engineering 2C Street Light /Signal Knockdown - Construction 23,135 300 3002252 73211 C/O Engineering 2C ITS Traffic Control Equipment 27,829 300 3002253 73211 C/O Engineering 2C JFK @ Wacker Signal Reconstruction - Construction 44,500 300 3002254 73211 C/O Engineering 2C Pennsylvania at Radford Intersection - Eng Division Services 20,000 300 3002256 62811 C/O Engineering 2C Pennsylvania at Radford Intersection - Construction 140,000 300 3002256 73211 C/O Engineering 2C Portable Radar Speed Sign 13,373 300 3002257 73211 C/O Engineering 2C University & Asbury Intersection 189,539 300 3002324 73211 C/O Engineering 2C University & Asbury Intersection - Fed Aid 116,000 300 3002324 44145 C/O Engineering 2C Video Detection Camera Upgrade 40,000 300 3002325 73410 C/O Engineering 2C Cedar Cross Lighting 16,000 300 3002326 73211 C/O Engineering 2C Catfish Creek Bridge Fiber 9,434 300 3002327 62712 C/O Engineering 2C School Zone Count -Down 4,000 300 3002328 73211 C/O Public Works 2C Curb Ramp Program - Construction (33,399) 300 3001230 73211 C /O- Prespend FY13 Public Works 2C Downtown Sign /Post Replacement - Signage (11,269) 300 3001938 71227 C /O- Prespend FY13 Engineering 2C White Water Creek Bridge - Construction (15,183) 300 3001634 73211 C /O - Prespend FY13 Engineering 2C N Cascade Road Reconstruction - Consulting Engineers (18,608) 300 3002021 62712 C /O- Prespend FY13 Engineering 2C Green Alley Pilot Project (1,267) 300 3002044 73211 C /O- Prespend FY13 Engineering 2C Street Construction - General (60,000) 300 3002142 73211 C /O- Prespend FY13 Engineering 2C US 61/151 Corridor - Construction (117,932) 300 3002028 73211 C /O- Reduce Encumbrances Engineering 2C Central Avenue Payment - Construction (574,458) 300 3002248 73211 C/O - Reduce Encumbrances Public Works 2C Curb Ramp Program - Construction 52,015 300 3001230 73211 C /O- Shift from Asphalt Milling Public Works 2C Downtown Sign /Post Replacement - Signage 11,269 300 3001938 71227 C /O- Shift from Asphalt Milling Engineering 2C Traffic Consultant Serv- Consulting Engineers (28,494) 300 3001815 62712 C /O- Prespend FY13 TOTAL STREET CONSTRUCTION FUND 7,275,793 9,957,511 SALES TAX FUND (20 %) Parks Division 4C Northend Trail Lighting - Construction 145,000 350 3501129 73211 C/O Parks Division 4C Renovate Park Water System - Consulting 11,578 350 3501158 62712 C/O Parks Division 4C Renovate Park Water System - Construction 31,794 350 3501158 73211 C/O Parks Division 4C Renovate Park Water System - Construction 388 350 3501158 73211 C/O Parks Division 4C Renovate Park Sidewalks - Construction 9,050 350 3501438 73211 C/O Parks Division 4C EPP Replace Walkway - Connt Cont- Not Bldg 5,372 350 3501453 73211 C/O Parks Division 4C Street Tree Program - Tree Planting 7,483 350 3501458 73311 C/O Parks Division 4C Riverwalk Baskets - Irrigate 12,000 350 3501937 73211 C/O Page 8 FISCAL YEAR 2013 AMEN DM ENT #1 CITY COUNCIL 11- Sep -12 Page 9 FY 13 FY 13 Expense Revenue Department Program Description Amount Amount Fund Activity /CIP Account Explanation Parks Division 4C Pet Park Terminal Street - Construction 94,308 350 3501978 73211 C/O Parks Division 4C Allison- Henderson Remodel Interior- Construction 4,854 350 3502291 73210 C/O Parks Division 4C McAleece Replace Fence Fabric- Construction 11,125 350 3502294 73211 C/O Parks Division 4C McAleece Fence on Bluff- Construction 5,220 350 3502296 73211 C/O Civic Center Division 4C Theatre Tuck -point Exterior - Construction 247,000 350 3501708 73210 C/O Civic Center Division 4C Theatre Tuckpoint Exterior- Consultant Services 2,200 350 3501708 62716 C/O Civic Center Division 4C Seal Concrete Walkways - Construction 25,000 350 3502303 73211 C/O Conference Center 6C Grand River Center Chairs 3,850 350 3501990 71212 C/O Conference Center 6C Grand River Center Level Floors 20,234 350 3501991 73210 C/O Library 4C Elm Veneer Replacement 10,425 350 3502308 73210 C/O Public Works 2C Steps, Railings and Fencing - Construction Not Building 9,417 350 3501432 73211 C/O Public Works 2C Floodwall Post Flood Repair- Construction 34,033 350 3501445 73211 C/O Public Works 2C Cold Storage Building Mezz- Construction Not Building 17,782 350 3502037 73211 C/O Public Works 2C Ice Harbor Gates Timber 18,958 350 3502222 73211 C/O Public Works 2C Port Amenities Project 1,420 350 3502038 73510 C/O Engineering 2C Stone Retaining Walls- Construction Not Building 1,270 350 3501029 73211 C/O Engineering 2C Accessibility Barriers- Construction 58,458 350 3501034 73210 C/O Engineering 2C Rivertront Leasehold Improvements- Consultant Services 66,284 350 3501053 62716 C/O Engineering 2C Decorative Concrete Maint- Construction 154,795 350 3501630 73211 C/O Engineering 2C Sidewalk Financial Assistance 12,451 350 3501727 62761 C/O Engineering 2C Rehab Railroad Tracks 79,507 350 3501465 73211 C/O Engineering 2C Ice Harbor Maintenance /Dredging 288,106 350 3501466 73211 C/O Engineering 2C Transient Docks - Main Channel - Big Tier Grant 1,272,671 350 3501861 45771 C/O Engineering 2C Millwork District Security Cameras 66,372 350 3502329 72417 C/O Engineering 2C Downtown Street Light Replacement- Construction 4,979 350 3501608 73211 C/O Building Services 6C City Hall Annex Maintenance - Construction 28,577 350 3501757 73210 C/O Building Services 6C Smart Meters - Construction 259,713 350 3502259 73210 C/O Building Services 6C Smart Meters - Consultant 13,400 350 3502259 62712 C/O Planning Services 5C Rivertront 2000 Plan - Consulting 5,000 350 3501015 62712 C/O Building Services 6C 18th Street Building Improvements 207,000 350 3501975 73210 C /O- Land Sales Engineering 2C Stone Retaining Walls- Construction Not Building (9,348) 350 3501029 73211 C /O- Prespend FY13 Building Services 6C 18th Street Building Improvements - Tax Credits 672,207 350 3501975 53620 C/O Building Services 6C 18th Street Building Improvements (48,988) 350 3501975 73210 C /O- Prespend FY13 Parks Division 4C Street Tree Program - Tree Planting 5,750 350 3501458 73311 C/O - Private Participant Conference Center 6C Grand River Center Level Floors 70,768 350 3501991 73210 C/O - shift from carpet Conference Center 6C Grand River Center Level Floors 12,000 350 3501991 73210 C/O - Shift from Mechanic Room Conference Center 6C Grand River Center Level Floors 70,202 350 3501991 73210 C/O - shift from paint Conference Center 6C Grand River Center Level Floors 130,250 350 3501991 73210 C/O - shift from Vet's Ballfeld TOTAL SALES TAX FUND 2,205,037 1,944,878 GENERAL CONSTRUCTION FUND Parking Division 8C Port of Dubuque Ramp Repairs - Construction 620,786 360 3601957 73211 C/O Engineering 2C Millworking District Street- Construction (25,271) 360 3602137 73211 C/O Engineering 2C 7th Street Improvements - Construction 3,988,376 360 3602441 73211 C/O Engineering 2C 7th Street Improvements - RISE Grant 680,892 360 3602441 45741 C/O Economic Devlopmt 5C Industrial Site Development - North Sievert - RISE Grant 57,736 360 3601943 45741 C/O Economic Devlopmt 5C DICW - Wildflowers - Landscaping Contract 154,970 360 3602158 73310 C/O Economic Devlopmt 5C DICW - Wildflowers - Consulting Engineers 10,000 360 3602158 62712 C/O Economic Devlopmt 5C Design South Sievert Farm - Construction 4,067,150 360 3602160 73211 C/O Economic Devlopmt 5C Design South Sievert Farm - Construction 82,776 360 3602160 73211 C/O - Shift from N. Sievert Page 9 FISCAL YEAR 2013 AMEN DM ENT #1 CITY COUNCIL 11- Sep -12 Page 10 FY 13 FY 13 Expense Revenue Department Program Description Amount Amount Fund Activity /CIP Account Explanation Economic Devlopmt 5C Design South Sievert Farm - Construction 5,400 360 3602160 73211 C/O Economic Devlopmt 5C Design South Sievert Farm - Construction 1,127 360 3602160 73211 C/O Economic Devlopmt 5C Design South Sievert Farm - Construction 1,020 360 3602160 73211 C/O Economic Devlopmt 5C Downtown Housing Incentive- Pay to Other Agency 1,858,509 360 3602267 62761 C/O Economic Devlopmt 5C Downtown Housing Incentive- Pay to Other Agency 1,072 360 3602267 62761 C/O Economic Devlopmt 5C Downtown Housing Incentive- Pay to Other Agency 4,589 360 3602267 62761 C/O Economic Devlopmt 5C Downtown Housing Incentive- Pay to Other Agency 5,793 360 3602267 62761 C/O Economic Devlopmt 5C Millwork District Parking Imp - Construction 1,553,049 360 3602250 73211 C/O Economic Devlopmt 5C Millwork District Parking Imp - Construction 11,735 360 3602250 73211 C/O Economic Devlopmt 5C Millwork District Parking Imp - Construction (1,230,000) 360 3602250 73211 C/O - Shift to Intermodal Engineering 2C 1 Way to 2 Way Conversion 1,493,216 360 3602442 73211 C/O Engineering 2C 1 Way to 2 Way Conversion (120,000) 360 3602442 73211 C /O- Shift to Intermodal TOTAL GENERAL CONSTRUCTION FUND 12,484,297 738,628 AIRPORT CONSTRUCTION FUND Airport Department 2C Runway Safety Area 24,205 390 3901788 73210 C/O Airport Department 2C Terminal - RW 31 Parallel - Consulting Engineers 248,100 390 3901891 62712 C/O Airport Department 2C Terminal - RW 31 Parallel - Construction 3,181,772 390 3901891 73211 C/O Airport Department 2C Terminal - RW 31 Parallel -FAA Funds 3,295,567 390 3901891 44105 C/O Airport Department 2C Extend Gem's Aviation Ramp - Consulting Engineers 5,000 390 3901893 62712 C/O Airport Department 2C Extend Gem's Aviation Ramp - Construction 49,000 390 3901893 73211 C/O Airport Department 2C Hanger Repairs /Replace - Construction 3,054 390 3902008 73210 C/O Airport Department 2C Terminal Site work - Consulting Engineers 15,330 390 3902009 62712 C/O Airport Department 2C Terminal Site work - Construction - 15% Contingency 28,462 390 3902009 73211 C/O Airport Department 2C Terminal Site work - FAA Funds 2,411,404 390 3902009 44105 C/O Airport Department 2C Paint Hangar Exteriors - Construction 13,332 390 3902125 73210 C/O Airport Department 2C Paint Hangar Exteriors - Construction 20 390 3902125 73210 C/O Airport Department 2C New Terminal Facility- Construction 6,861,886 390 3902213 72310 C/O Airport Department 2C New Terminal Facility- FAA Funds 6,413,565 390 3902213 44105 C/O Airport Department 2C New Terminal Facility- State Grants 431,298 390 3902213 45701 C/O Airport Department 2C New Term Facilities Roads and Aprons - Construction 106,127 390 3902316 62716 C/O Airport Department 2C New Term Facilities Roads and Aprons - FAA Funds 103,948 390 3902316 44105 C/O Airport Department 2C New Terminal Facilities Roads and Aprons - RISE Grant 116,804 390 3902316 45741 C/O Airport Department 2C Hangar Paving - Construction 68,332 390 3902346 73211 C/O Airport Department 2C Hangar Paving - FAA 91,156 390 3902346 41105 C/O Airport Department 2C Terminal Sitework - Construction 540,775 390 3902009 73211 C /O- incr. FAA Airport Department 2C Terminal Sitework- Consulting Engineers 82 390 3902009 62712 C /O -int Airport Department 2C Terminal Sitework- Consulting Engineers 550 390 3902009 62712 C/O -reimb TOTAL AIRPORT CONSTRUCTION FUND 11,146,027 12,863,742 DEBT SERVICE FUND Debt Service 7 Debt Service - BAB Subsidy 1,914 400 40055400 44100 BAB Subsidy Debt Service 7 Debt Service - BAB Subsidy 21,749 400 40013800 44100 BAB Subsidy Debt Service 7 Debt Service - BAB Subsidy 3,532 400 40051300 44100 BAB Subsidy TOTAL DEBT SERVICE FUND - 27,195 BOND PROCEEDS FUND Debt Service 7 Bond Proceeds (6,321,967) 440 44010440 54210 Borrowing done in FY12 TOTAL BOND PROCEEDS FUND - (6,321,967) Page 10 FISCAL YEAR 2013 AMEN DM ENT #1 CITY COUNCIL 11- Sep -12 Department Program Description STORMWATER OPERATING FUND Engineering 8 Stormwater Debt Service TOTAL STORMWATER OPERATING FUND PARKING OPERATING FUND Parking Division 8 Parking Debt Service TOTAL PARKING OPERATING FUND FY 13 FY 13 Expense Revenue Amount Amount Fund Activity /CIP Account Explanation 17,843 620 62055620 44100 BAB Subsidy 17,843 141,532 630 63046360 44100 BAB Subsidy 141,532 REFUSE FUND Public Works 8C Dual Packer Recylcle Vehicles 587,769 670 6701533 73410 C/O Public Works 8C Public Works Fleet GPS /AVL Project 20,000 670 6701935 73410 C/O Public Works 8C Litter and Recycling Receptacle - Receptacles 60,000 670 6702226 72821 C/O Public Works 8 Refuse Collection - Tipper Carts and lids 1,110 670 67054500 71221 C/O Public Works 8 Yard Waste Collection - Legal Notice & Ads 365 670 67054510 62130 C/O Public Works 8 Yard Waste Collection - Promotion 500 670 67054510 62140 C/O Public Works 8 Recycling- Printing and Binding 559 670 67054530 62090 C/O Public Works 8 Recycling- Legal Notices &Ads 865 670 67054530 62130 C/O Public Works 8 Recycling- Promotion 3,303 670 67054530 62140 C/O Public Works 8 Recycling- Recycling Containers 14,529 670 67054530 72818 C/O TOTAL REFUSE FUND 689,000 - AMERICA'S RIVER PROJECT FUND Engineering 8C Art in Port of Dubuque - Consultant Services 156,593 700 7001853 62731 C/O TOTAL AMERICA'S RIVER PROJECT FUND 156,593 - SANITARY SEWER CONSTRUCTION FUND Water & Resource Re 8C Beadle System Upgrade - Construction - Not Building 42,929 710 7101339 73211 C/O Water & Resource Re 8C WPC Plant Facility Study- SRF Bond Proceeds 11,696,491 710 7101837 54230 C/O Water & Resource Re 8C Pumping Station Telemetry - Equipment Acquisition 61,590 710 7101930 73410 C/O Water & Resource Re 8C Terminal Street Mag Meter Repair - Consulting 287,755 710 7102211 62712 C/O Water & Resource Re 8C Terminal Street Mag Meter Repair- Consulting 1,006 710 7102211 62712 C/O Water & Resource Re 8C Bradley Street Pumping Station - Consulting Engineers 8,925 710 7102315 62712 C/O Water & Resource Re 8C Bradley Street Pumping Station - Construction 93,812 710 7102315 73211 C/O Water & Resource Re 8C Bradley Street Pumping Station - Construction 432 710 7102315 73211 C/O Public Works 8C Sewer Pipeline Inspection Equipment - Equipment 14,486 710 7101840 73410 C/O Public Works 8C Mobile GIB System - Equipment 10,000 710 7102225 73410 C/O Engineering 8C Green Alley Pilot Project - Bond Proceeds (50,000) 710 7102044 54210 FY12 Borrowed Engineering 8C King Street Sanitary Sewer- Bond proceeds (50,500) 710 7102407 54210 FY12 Borrowed Engineering 8C Green Alley SEP Project - Bond Proceeds (180,000) 710 7102411 54210 FY12 Borrowed Engineering 8C Cedar Lift Pump /Generator /Trailer- Bond Proceeds (225,000) 710 7102412 54210 FY12 Borrowed Engineering 8C Relocate 30" Main Old Garage- Bond Proceeds (849,124) 710 7102412 54210 FY12 Borrowed Engineering 8C Sewer Conn Asst -Low /Mod - Miscellaneous Services 34,717 710 7101067 62731 C/O Engineering 8C Sanitary Sewer Internal Main - Construction 226,000 710 7101293 73510 C/O Engineering 8C Sanitary Sewer Internal Main - Private Participant 222,362 710 7101293 53102 C/O Engineering 8C I &I Reduction Program - Construction Not Bldg 6,712 710 7101294 73211 C/O Engineering 8C Lateral Repl Asst. Low Inc- Eng. Division Services 20,000 710 7101297 62811 C/O Engineering 8C Nightengale Lane Sanitary Sewer- Eng Division Services 40,000 710 7101301 62811 C/O Engineering 8C Nightengale Lane Sanitary Sewer- Construction 269,908 710 7101301 73510 C/O Engineering 8C Sewer Lateral Assistance - Eng Division Services 46,448 710 7101309 62811 C/O Engineering 8C Sewer Lateral Assistance - Construction Not Bldg 55,216 710 7101309 73211 C/O Page 11 FISCAL YEAR 2013 AMEN DM ENT #1 CITY COUNCIL 11- Sep -12 FY 13 FY 13 Expense Revenue Department Program Description Amount Amount Fund Activity /CIP Account Explanation Engineering 8C Laterals - I &I Reduction 10,966 710 7101320 73211 C/O Engineering 8C Alley Washington- Jackson Sewer - Construction 130,000 710 7101327 73211 C/O Engineering 8C LorasA/Valnut to Prairie St Sewer- Construction 54,572 710 7101328 73211 C/O Engineering 8C Hwy 20 Annexation Sanitary Sewers - Construction 262,973 710 7101336 73211 C/O Engineering 8C Sanitary Sewer Lining Program - Const Not Bldg 111,501 710 7101637 73211 C/O Engineering 8C Street Program /Related- Const Not Bldg 224,475 710 7101638 73211 C/O Engineering 8C Monroe St Sanitary Sewer- Construction 6,947 710 7101797 73211 C/O Engineering 8C Southfork Interceptor- Consulting Engineers 26,340 710 7101899 62712 C/O Engineering 8C Southfork Interceptor- Const Cont - Not Bldg 371,991 710 7101899 73211 C/O Engineering 8C Century Sewer Manholes - Engineering 4,000 710 7101905 62811 C/O Engineering 8C Century Sewer Manholes - Construction 15,000 710 7101905 73211 C/O Engineering 8C Green Alley Pilot Project - Construction 50,183 710 7102044 73211 C/O Engineering 8C Laurel St Sanitary Sewer- Eng Division Services 28,777 710 7102130 62811 C/O Engineering 8C Laurel St Sanitary Sewer - Const Not Bldg 300,000 710 7102130 73211 C/O Engineering 8C North Fork Sanitary Sewer Improvements- SRF 362,057 710 7102178 54230 C/O Engineering 8C Brunswick Sanitary Sewer - Construction 58,490 710 7102232 73211 C/O Engineering 8C Brunswick Sanitary Sewer- Engineering Division Services 8,146 710 7102232 62811 C/O Engineering 8C Fairway Dr Sanitary Sewer - Construction 20,000 710 7102233 73211 C/O Engineering 8C Fairway Dr Sanitary Sewer- Engineering Division Services 3,500 710 7102233 62811 C/O Engineering 8C Southgate Sanitary Sewer - Construction 34,000 710 7102234 73211 C/O Engineering 8C Southgate Sanitary Sewer- Eng Division Services 4,000 710 7102234 62811 C/O Engineering 8C SEP Green Alleys 15,288 710 7102350 73211 C/O Engineering 8C Hawthorne Sanitary - Engineering 4,000 710 7102322 62811 C/O Engineering 8C Hawthorne Sanitary - Construction 15,065 710 7102322 73211 C/O Engineering 8C Knob Hill - Duggan Dr- Engineering 15,000 710 7102322 62811 C/O Engineering 8C Knob Hill - Duggan Dr- Construction 93,394 710 7102322 73211 C/O Engineering 8C Forcemain Repair 650,000 710 7102347 54210 C/O City Manager 8C GIB Enhancements - Peripherals, Computer 5,291 710 7101946 71120 C/O Water & Resource Re 8C WPC Plant Facility Study- Construction Building 8,840,716 710 7101837 73210 C/O Water & Resource Re 8C WPC Plant Facility Study- Construction Building 626 710 7101837 73210 C/O Water & Resource Re 8C WPC Plant Facility Study- Construction Building 501,397 710 7101837 73210 C/O Water & Resource Re 8C WPC Plant Facility Study- Construction Building 5,150 710 7101837 73210 C/O Water & Resource Re 8C WPC Plant Facility Study- Construction Building 149,096 710 7101837 73210 C/O - Shift from 02 Mixers Water & Resource Re 8C WPC Plant Facility Study- Construction Building 70,291 710 7101837 73210 C/O - Shift from Perry St Pumping Water & Resource Re 8C WPC Plant Facility Study- Construction Building 2,049 710 7101837 73210 C/O - Shift from Sluice Grates Water & Resource Re 8C WPC Plant Facility Study- Construction Building 24,617 710 7101837 73210 C/O - Shift from Standby Generator Water & Resource Re 8C WPC Plant Facility Study- Construction Building 13,283 710 7101837 73210 C/O - Shift from Switch Gear Engineering 8C Historic Millwork - Sanitary Sewer - Const Not Bldg (53,146) 710 7102129 73211 C/O - Over Encumbered Water & Resource Re 8C WPC Plant Facility Study- Construction Building (270,531) 710 7101837 73210 C /O- Prespend FY13 Engineering 8C Historic Millwork - Sanitary Sewer- Const Not Bldg (118,458) 710 7102129 73211 C/O - Prespend FY13 TOTAL SANITARY SEWER CONST FUND 12,258,925 11,576,286 STORM WATER CONSTRUCTION FUND Parks Division 8C Eagle Point Park Stormwater - Construction 112,312 720 7202301 73211 C/O Parks Division 8C Bee Branch Trees Forever- Tree Planting 6,130 720 7202337 73311 C/O Public Works 8C Sewer Pipeline Inspection Equipment - Equipment 5,404 720 7201840 73410 C/O Public Works 8C PW Fleet GPS Project- Pager /Radio Equipment 10,000 720 7201935 73410 C/O Public Works 8C Mobile GIB System - Equipment 10,000 720 7202225 73410 C/O Public Works 8C Bee Branch Pump Station 97,370 720 7202319 73211 C/O Engineering 8C Green Alley Pilot Project - Bond Proceeds (33,000) 720 7202044 54210 FY12 Borrowed Page 12 FISCAL YEAR 2013 AMEN DM ENT #1 CITY COUNCIL 11- Sep -12 Page 13 FY 13 FY 13 Expense Revenue Department Program Description Amount Amount Fund Activity /CIP Account Explanation Engineering 8C Windsor Storm - Bond Proceeds (39,200) 720 7202414 54210 FY12 Borrowed Engineering 8C W 32nd Detention Basin - Bond Proceeds (41,500) 720 7202416 54210 FY12 Borrowed Engineering 8C Millwork District - Bond Proceeds (91,000) 720 7202131 54210 FY12 Borrowed Engineering 8C 14th Street - Bond Proceeds (200,000) 720 7202418 54210 FY12 Borrowed Engineering 8C Catch BasinA/Vestside - Construction Not Building 77,457 720 7201081 73211 C/O Engineering 8C Carter Road Culvert - Eng Division Services 9,000 720 7201356 62811 C/O Engineering 8C Carter Road Culvert- Construction 58,000 720 7201356 73211 C/O Engineering 8C Gunite Rock Stormsewer- Construction 36,310 720 7201363 73211 C/O Engineering 8C General Detention Basin Silt Removal - Construction 89,523 720 7201375 73211 C/O Engineering 8C Bee Branch Alignment - State Revolving Loan Funds 4,672,385 720 7201654 54230 C/O Engineering 8C Bee Branch Alignment - State Trail Grant 100,000 720 7201654 45701 C/O Engineering 8C Bee Branch Alignment- National Trail Grant 1,000,000 720 7201654 45771 C/O Engineering 8C Bee Branch Alignment- Construction 3,524,874 720 7201654 73211 C/O Engineering 8C Bee Branch Alignment- Construction (1,928,327) 720 7201654 73211 Adjust to actual Engineering 8C Bond Proceeds- Bee Branch 1,472,179 720 7201654 54210 C/O Engineering 8C Storm Sewer Cleaning - Construction 179,888 720 7201659 73211 C/O Engineering 8C Stoneman Road Storm Sewer- Construction 91,845 720 7201664 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 32nd & Grandview Storm Improvements - Eng Division Services 38,378 720 7201808 62811 C/O Engineering 8C Villa St Storm Sewer Prot - Eng Division Services 11,551 720 7201809 62811 C/O Engineering 8C Villa St Storm Sewer Prot - Construction 95,000 720 7201809 73211 C/O Engineering 8C Stormwater System Assessment 295,242 720 7202015 62712 C/O Engineering 8C Hillcrest /Keyway Storm Sewer - Construction 30,000 720 7202016 73211 C/O Engineering 8C Hillcrest /Keyway Storm Sewer- Consulting Engineers 4,300 720 7202016 62712 C/O Engineering 8C Green Alley Pilot Project - Construction 33,000 720 7202044 73211 C/O Engineering 8C Iowa Street Storm Sewer- Engineering 2,933 720 7202132 62811 C/O Engineering 8C Iowa Street Storm Sewer- Construction 35,509 720 7202132 73211 C/O Engineering 8C Kane Kaufman Storm Sewer- Engineering 22,788 720 7202133 62811 C/O Engineering 8C Kane Kaufman Storm Sewer- Construction 148,382 720 7202133 73211 C/O Engineering 8C Peru Road Storm Sewer- Engineering 3,144 720 7202133 62811 C/O Engineering 8C Peru Road Storm Sewer- Construction 10,486 720 7202133 73211 C/O Engineering 8C Cedar Cross Rd Storm - Engineering 5,000 720 7202238 62811 C/O Engineering 8C Cedar Cross Rd Storm - Construction 10,000 720 7202238 73211 C/O Engineering 8C Floodwall Breach Analysis 30,000 720 7202239 62811 C/O Engineering 8C Ice Harbor /Maus Aux Pump 50,000 720 7202240 62811 C/O Engineering 8C Lower Bee Branch Construction 910 720 7202281 73211 C/O Engineering 8C Millwork District Storm Sewer- Construction (86,064) 720 7202131 73211 C /O- Over Encumbered Engineering 8C Millwork District Storm Sewer- Construction (91,000) 720 7202131 73211 C /O- Prespend FY13 Engineering 8C Windsor Storm - Construction (26) 720 7202414 73211 C /O - Prespend FY13 TOTAL STORM WATER CONST FUND 3,043,119 6,839,864 PARKING CONSTRUCTION FUND Parking Division 8C Seal Coating Parking Lots - Consultant Services 10,000 730 7301380 62716 C/O Parking Division 8C Seal Coating Parking Lots - Construction Contract 250,000 730 7301380 73211 C/O Parking Division 8C Locust Ramp Video Cameras - Bond Proceeds (175,000) 730 7302427 54210 FY12 Borrowed Parking Division 8C Locust Street Ramp Repairs - Construction 250,000 730 7301671 73210 C/O Parking Division 8C Port of Dubuque Ramp Maint - Construction 273,090 730 7302162 73211 C/O Parking Division 8C 7th Street Pedestrian Walkway Study- Consulting 10,000 730 7302163 62712 C/O Parking Division 8C POD Ramp Special Expenses 25,558 730 7302260 73211 C/O Page 13 FISCAL YEAR 2013 AMEN DM ENT #1 CITY COUNCIL 11- Sep -12 Page 14 FY 13 FY 13 Expense Revenue Department Program Description Amount Amount Fund Activity /CIP Account Explanation Building Services 8C Smart Meters - Construction 59,000 730 7302259 73210 C/O City Manager 8C GIB Enhancements - Peripherals, Computer 5,291 730 7301946 71120 C/O TOTAL PARKING CONSTRUCTION FUND 882,939 (175,000) WATER CONSTRUCTION FUND Water Department 8C GIB Maintenance /Upgrade- Consulting Engineers 31,906 740 7401389 62712 C/O Water Department 8C Service Line Assistance - Misc Services 28,761 740 7401390 62731 C/O Water Department 8C Eagle Point Plant Office & Lab Pump Room - Construction 50,671 740 7401397 73210 C/O Water Department 8C Water Internal Lines /Loan - Construction 330,530 740 7401398 73211 C/O Water Department 8C Water Internal Lines /Loan - Consulting Engineers 30,000 740 7401398 62712 C/O Water Department 8C Water Internal Lines /Loan - Private Participant 288,503 740 7401398 53102 C/O Water Department 8C Water Meter Exchange 50,952 740 7401400 73410 C/O Water Department 8C Annual Tank Inspection 12,000 740 7401412 62712 C/O Water Department 8C Shallow Well Rehab 4,035 740 7401415 73211 C/O Water Department 8C Water Main Replacements - Bond Proceeds (400,000) 740 7401389 54210 Borrowed FY12 Water Department 8C Fire Hydrant Replacements- Bond Proceeds (42,000) 740 7401409 54210 Borrowed FY12 Water Department 8C Main Extension - Bond Proceeds (125,000) 740 7401411 54210 Borrowed FY12 Water Department 8C Bunker Hill Pump Station - Bond Proceeds (325,000) 740 7401422 54210 Borrowed FY12 Water Department 8C Asbury Tank Painting (592,500) 740 7402204 54210 Borrowed FY12 Water Department 8C North Softening Basin - Bond Proceeds (120,000) 740 7402396 54210 Borrowed FY12 Water Department 8C McAleece Water Improvements (91,000) 740 7402397 54210 Borrowed FY12 Water Department 8C Eagle Point Treatment- Bond Proceeds (85,000) 740 7402398 54210 Borrowed FY12 Water Department 8C Water Usage Audit - Bond Proceeds (50,000) 740 7402399 54210 Borrowed FY12 Water Department 8C North Plant Motor Control - Bond Proceeds (20,000) 740 7402401 54210 Borrowed FY12 Water Department 8C Bunker Hill Pump Station - Construction 239,347 740 7401422 73211 C/O Water Department 8C Bunker Hill Pump Station - Construction 878 740 7401422 73211 C/O Water Department 8C Roosevelt Rd. Main Ext. - Consult Eng 21,493 740 7401672 62712 C/O Water Department 8C Roosevelt Rd. Main Ext. - Construction 75,000 740 7401672 73211 C/O Water Department 8C Roosevelt Rd. Main Ext. - Bond Proceeds 75,000 740 7401672 54210 C/O Water Department 8C Olympic Heigths Pump Station - Construction 18,558 740 7402031 73211 C/O Water Department 8C Drinking Water Study- Consulting Engineers 32,959 740 7402147 62712 C/O Water Department 8C Drinking Water Study- Consulting Engineers 108 740 7402147 62712 C/O Water Department 8C Fire Hydrant Painting - Miscellaneous Services 88,150 740 7402201 62731 C/O Water Department 8C Water Circulator System - Construction 31,657 740 7402202 73510 C/O Water Department 8C Water Circulator System - Construction 192 740 7402202 73510 C/O Water Department 8C Asbury Tank Painting - Consulting 10,000 740 7402204 62712 C/O Water Department 8C Asbury Tank Painting - Construction Not Building 75,253 740 7402204 73211 C/O Water Department 8C Asbury Tank Painting - Construction Not Building 346 740 7402204 73211 C/O Water Department 8C Pump Replacement Vacuum Filter- Pumps 25,000 740 7402205 71511 C/O Water Department 8C Park Hill Pumping Roof- Construction 15,179 740 7402207 73210 C/O Water Department 8C Electrical Usage Integrated - Equipment 62,280 740 7402210 62716 C/O Water Department 8C Electrical Usage Integrated - Equipment 466 740 7402210 62716 C/O Water Department 8C Mobile GIB System 40,000 740 7402225 73510 C/O Water Department 8C Ramp Water Utility Relocate- Const Not Bldg 131,327 740 7402261 73211 C/O Water Department 8C Ramp Water Utility Relocate - Const Not Bldg 534 740 7402261 73211 C/O Water Department 8C Eagle Point Plant Driveway and Parking Lot - Construction 60,000 740 7402309 73211 C/O Water Department 8C Eagle Point Plant Driveway and Parking Lot - Consulting 5,000 740 7402309 62712 C/O Water Department 8C Well Field Electrical Updates- Consulting 22,671 740 7402309 62712 C/O Water Department 8C Well Field Electrical Updates- Construction 141,439 740 7402309 73211 C/O Water Department 8C Well Field Electrical Updates- Construction 696 740 7402309 73211 C/O Page 14 FISCAL YEAR 2013 AMEN DM ENT #1 CITY COUNCIL 11- Sep -12 Department Program Description Water Department 8C Manson Road Bridge Water Main - FEMA Water Department 8C #7 Well House Structure Update - Construction Water Department 8C #7 Well House Structure Update - Construction Water Department 8C Auto Meter Reading System Maintenance - Construction City Manager 8C GIB Enhancements - Peripherals, Computer Information Services 8C Water Micro-Computers Water Department 8C Millwork Dist - Water Main - Construction 12,000 100 TOTAL WATER CONSTRUCTION FUND LANDFILL FUND Public Works 8 Landfill - Consulting Engineers TOTAL LANDFILL FUND FY 13 FY 13 Expense Revenue Amount Amount Fund 150,000 740 10,935 740 89 740 15,000 740 2,841 740 57,257 740 (66,566) 740 1,656,944 (1,336,997) Activity /CIP Accoun 7402349 44405 7402313 73211 7402313 73211 7402314 73211 7401946 71120 7401069 71124 7402145 73211 t Explanation C/O C/O C/O C/O C/O C/O C/O - Over Encumberec 125,578 940 94054200 62712 C/O - Correct PO Budget 125,578 TRANSFERS Transfer Out Transfer In Parks Division Trans01 Transfer from General Fund to DRA Distribution 6,000 100 10010100 91102 Trans Funds Parks Division Trans01 Transfer from General Fund to DRA Distribution 6,000 102 1022184 59100 Trans Funds Conference Center Trans02 Transfer from General Fund to Sales Tax Const Fund 12,000 100 10010100 91350 Trans Funds Conference Center Trans02 Transfer from General Fund to Sales Tax Const Fund 12,000 350 3501991 59100 Trans Funds Conference Center Trans03 Transfer from DRA Dist Fund to Sales Tax Const Fund 130,250 102 10210102 91350 Trans Funds Conference Center Trans03 Transfer from DRA Dist Fund to Sales Tax Const Fund 130,250 350 3501991 59102 Trans Funds Airport Department Trans04 Transfer from PFC Fund to Airport Construction Fund 134,305 391 39110391 91390 Trans Funds Airport Department Trans04 Transfer from PFC Fund to Airport Construction Fund 134,305 390 3901891 59391 Trans Funds Airport Department Trans05 Transfer from DRA Dist Fund to Airport Construction Fund 54,000 102 10210102 91390 Trans Funds Airport Department Trans05 Transfer from DRA Dist Fund to Airport Construction Fund 54,000 390 3901893 59102 Trans Funds Airport Department Trans06 Transfer from Gen Fund to Airport Construction Fund 28,462 100 10010100 91390 Trans Funds Airport Department Trans06 Transfer from Gen Fund to Airport Construction Fund 28,462 390 3902009 59100 Trans Funds Airport Department Trans07 Transfer from PFC Fund to Airport Construction Fund 67,179 391 39110391 91390 Trans Funds Airport Department Trans07 Transfer from PFC Fund to Airport Construction Fund 67,179 390 3902009 59391 Trans Funds Airport Department Trans08 Transfer from DRA Distrib Fund to Airport Construction Fund 9,000 102 10210102 91390 Trans Funds Airport Department Trans08 Transfer from DRA Distrib Fund to Airport Construction Fund 9,000 390 3902125 59102 Trans Funds Airport Department Trans09 Transfer From CFC Fund to Airport Const. Fund 170,443 350 35010350 91390 Trans Funds Airport Department Trans09 Transfer From CFC Fund to Airport Const. Fund 170,443 390 3902213 59252 Trans Funds Airport Department Trans10 Transfer from DRA Dist Fund to Airport Construction Fund 216,923 102 10210102 91390 Trans Funds Airport Department Trans10 Transfer from DRA Dist Fund to Airport Construction Fund 216,923 390 3902316 59102 Trans Funds Airport Department Trans11 Transfer from General Fund to Airport Construction Fund 23,504 100 10010100 91390 Trans Funds Airport Department Trans11 Transfer from General Fund to Airport Construction Fund 23,504 390 3902346 59100 Trans Funds Transit Division Trans12 Transfer from General Const to Transit Fund 1,230,000 360 3602250 91600 Trans Funds Transit Division Trans12 Transfer from General Const to Transit Fund 1,230,000 600 6001614 59360 Trans Funds Transit Division Trans13 Transfer from General Const to Transit Fund 120,000 360 3602442 91600 Trans Funds Transit Division Trans13 Transfer from General Const to Transit Fund 120,000 600 6001614 59360 Trans Funds Transit Division Trans14 Transfer from Sales Tax Const to Transit Fund 20,400 350 35010350 91600 Trans Funds Transit Division Trans14 Transfer from Sales Tax Const to Transit Fund 20,400 600 6002045 59350 Trans Funds Transit Division Trans15 Transfer from Sales Tax Const to Transit Fund 24,000 350 35010350 91600 Trans Funds Transit Division Trans15 Transfer from Sales Tax Const to Transit Fund 24,000 600 6002235 59350 Trans Funds Engineering Trans16 Transfer from General Fund to Sanitary Sewer Fund 28,498 710 7101067 59101 Trans Funds Engineering Trans16 Transfer from General Fund to Sanitary Sewer Fund 28,498 101 10110101 91710 Trans Funds Engineering Trans17 Transfer from Spec. Assessment Fund to Street Construction 296,000 255 25510255 91300 Trans Funds Engineering Trans17 Transfer from Spec. Assessment Fund to Street Construction 296,000 300 30010300 59255 Trans Funds Engineering Trans17 Transfer from Spec. Assessment Fund to General Const. Fund 233,650 255 25510255 91360 Trans Funds Engineering Trans17 Transfer from Spec. Assessment Fund to General Const. Fund 233,650 300 3001972 59255 Trans Funds Page 15 FISCAL YEAR 2013 AMEN DM ENT #1 CITY COUNCIL FY 13 FY 13 Expense Revenue Department Program Description Amount Amount Fund Activity /CIP Account Explanation Engineering Trans17 Transfer from Spec. Assessment Fund to General Const. Fund 217,772 255 25510255 91360 Trans Funds Engineering Trans17 Transfer from Spec. Assessment Fund to General Const. Fund 217,772 360 3602137 59255 Trans Funds Engineering Trans18 Transfer from Spec. Assessment Fund to Street Const 212,000 255 25510255 91300 Trans Funds Engineering Trans18 Transfer from Spec. Assessment Fund to Street Const 212,000 300 3002139 59255 Trans Funds Engineering Trans19 Transfer from Spec. Assessment Fund to Street Const. Fund 89,000 255 25510255 91300 Trans Funds Engineering Trans19 Transfer from Spec. Assessment Fund to Street Const. Fund 89,000 300 3002141 59255 Trans Funds Engineering Trans20 Transfer from Spec. Assessment Fd to Sewer Con st Fund 110,000 255 25510255 91710 Trans Funds Engineering Trans20 Transfer from Spec. Assessment Fd to Sewer Con st Fund 110,000 710 7101301 59255 Trans Funds Engineering Trans21 Transfer from Spec. Assessment Fd to Sewer Con st Fund 124,000 255 25510255 91710 Trans Funds Engineering Trans21 Transfer from Spec. Assessment Fd to Sewer Con st Fund 124,000 710 7101336 59255 Trans Funds Engineering Trans22 Transfer from Spec. Assessment Fd to Sewer Con st Fund 180,119 255 25510255 91710 Trans Funds Engineering Trans22 Transfer from Spec. Assessment Fd to Sewer Con st Fund 180,119 710 7101801 59255 Trans Funds Engineering Trans23 Transfer from Spec. Assessment Fd to Sewer Con st Fund 307,000 255 25510255 91710 Trans Funds Engineering Trans23 Transfer from Spec. Assessment Fd to Sewer Con st Fund 307,000 710 7102130 59255 Trans Funds Engineering Trans24 Transfer From Sales Tax 20% Fd to Stormwater Const. Fund 13,800 350 35010350 91720 Trans Funds Engineering Trans24 Transfer From Sales Tax 20% Fd to Stormwater Const. Fund 13,800 720 7201666 59350 Trans Funds Engineering Trans25 Transfer from General Fund to America's River Fund 142,856 100 10010100 91700 Trans Funds Engineering Trans25 Transfer from General Fund to America's River Fund 142,856 700 7001853 59100 Trans Funds Economic Developme Trans26 Transfer from Bond Proceeds Fund to General Const Fund (991,733) 440 44010440 91360 Trans Funds Economic Developme Trans26 Transfer from Bond Proceeds Fund to General Const Fund (991,733) 360 36010360 59440 Trans Funds Economic Developme Trans27 Transfer from Bond Proceeds Fund to General Const Fund (1,814,863) 440 44010440 91360 Trans Funds Economic Developme Trans27 Transfer from Bond Proceeds Fund to General Const Fund (1,814,863) 360 3602160 59440 Trans Funds Economic Developme Trans28 Transfer from Bond Proceeds Fund to General Const Fund (750,000) 440 44010440 91360 Trans Funds Economic Developme Trans28 Transfer from Bond Proceeds Fund to General Const Fund (750,000) 360 3602438 59440 Trans Funds Economic Developme Trans29 Transfer from General Const Fund to Water Const Fund (650,000) 360 36010360 91740 Trans Funds Economic Developme Trans29 Transfer from General Const Fund to Water Const Fund (650,000) 740 7402395 59360 Trans Funds Economic Developme Trans30 Transfer from General Const Fund to Sewer Const Fund (391,733) 360 36010360 91710 Trans Funds Economic Developme Trans30 Transfer from General Const Fund to Sewer Const Fund (391,733) 710 7102409 59360 Trans Funds Fire Department Trans29 Transfer from Bond Proceeds Fund to DRA Gaming (278,255) 440 44010440 91101 Trans Funds Fire Department Trans29 Transfer from Bond Proceeds Fund to DRA Gaming (278,255) 101 1011016 59440 Trans Funds Fire Department Trans3 Transfer from Bond Proceeds Fund to DRA Gaming (68,800) 440 44010440 91101 Trans Funds Fire Department Trans30 Transfer from Bond Proceeds Fund to DRA Gaming (68,800) 101 1011555 59440 Trans Funds Engineering Trans31 Transfer from Bond Proceeds Fund to DRA Gaming (112,500) 440 44010440 91101 Trans Funds Engineering Trans31 Transfer from Bond Proceeds Fund to DRA Gaming (112,500) 101 1012419 59440 Trans Funds Building Services Trans32 Transfer from Bond Proceeds Fund to Sales Tax Const (575,000) 440 44010440 91350 Trans Funds Building Services Trans32 Transfer from Bond Proceeds Fund to Sales Tax Const (575,000) 350 3501045 59440 Trans Funds Recreation Trans33 Transfer from Bond Proceeds Fund to Sales Tax Const (10,000) 440 44010440 91350 Trans Funds Recreation Trans33 Transfer from Bond Proceeds Fund to Sales Tax Const (10,000) 350 3501090 59440 Trans Funds Recreation Trans34 Transfer from Bond Proceeds Fund to Sales Tax Const (10,000) 440 44010440 91350 Trans Funds Recreation Trans34 Transfer from Bond Proceeds Fund to Sales Tax Const (10,000) 350 3501775 59440 Trans Funds Library Trans35 Transfer from Bond Proceeds Fund to Sales Tax Const (70,000) 440 44010440 91350 Trans Funds Library Trans35 Transfer from Bond Proceeds Fund to Sales Tax Const (70,000) 350 3502308 59440 Trans Funds Emergency Communii Trans36 Transfer from Bond Proceeds Fund to Sales Tax Const (242,628) 440 44010440 91350 Trans Funds Emergency Communii Trans36 Transfer from Bond Proceeds Fund to Sales Tax Const (242,628) 350 3502353 59440 Trans Funds Parks Division Trans37 Transfer from Bond Proceeds Fund to Sales Tax Const (75,000) 440 44010440 91350 Trans Funds Parks Division Trans37 Transfer from Bond Proceeds Fund to Sales Tax Const (75,000) 350 3502369 59440 Trans Funds Civic Center Trans38 Transfer from Bond Proceeds Fund to Sales Tax Const (385,560) 440 44010440 91350 Trans Funds Civic Center Trans38 Transfer from Bond Proceeds Fund to Sales Tax Const (385,560) 350 3502378 59440 Trans Funds Civic Center Trans39 Transfer from Bond Proceeds Fund to Sales Tax Const (171,000) 440 44010440 91350 Trans Funds Civic Center Trans39 Transfer from Bond Proceeds Fund to Sales Tax Const (171,000) 350 3502379 59440 Trans Funds Page 16 11- Sep -12 FISCAL YEAR 2013 AMEN DM ENT #1 CITY COUNCIL 11- Sep -12 Department Program Description Conference Center Trans40 Transfer from Bond Proceeds Fund to Sales Tax Const Conference Center Trans40 Transfer from Bond Proceeds Fund to Sales Tax Const Airport Department Trans41 Transfer from Bond Proceeds Fund to Airport Const Airport Department Trans41 Transfer from Bond Proceeds Fund to Airport Const Airport Department Trans42 Transfer from Bond Proceeds Fund to Airport Const Airport Department Trans42 Transfer from Bond Proceeds Fund to Airport Const Airport Department Trans43 Transfer from Bond Proceeds Fund to Airport Const Airport Department Trans43 Transfer from Bond Proceeds Fund to Airport Const Building Services Trans44 Transfer from General Fund to Sales Tax Const Fund Building Services Trans44 Transfer from General Fund to Sales Tax Const Fund TOTAL TRANSFERS ENCUMBRANCE C /O's Back out Non Budgeted Encumb Rollovers Total Amend #1 with Enc, C /O's, and New FY 13 FY 13 Expense Revenue Amount Amount Fund Activity /CIP Account Explanation (62,100) 440 44010440 91350 Trans Funds (62,100) 350 3502388 59440 Trans Funds (35,000) 440 44010440 91350 Trans Funds (35,000) 390 3902008 59440 Trans Funds (613,016) 440 44010440 91350 Trans Funds (613,016) 390 3902316 59440 Trans Funds (56,512) 440 44010440 91350 Trans Funds (56,512) 390 3902403 59440 Trans Funds 95,000 100 1002338 91350 Trans Funds - EECBG 95,000 350 3501045 59100 Trans Funds - EECBG (3,067,539) (3,067,539) 73,479,838 50,658,841 20,418,998 (129,990) 93,768,846 50,658,841 Page 17