Loading...
Fiscal Year 2011 Budget Second AmendmentMasterpiece on the Mississippi September 1, 2010 TO: The Honorable Mayor and City Council Members FROM: Michael C. Van Milligen, City Manager SUBJECT: Fiscal Year 2011 Second Budget Amendment Dubuque r AII- America City 1 2007 Budget Director Jennifer Larson is recommending the second Fiscal Year 2011 Budget Amendment be set for public hearing for September 20, 2010. concur with the recommendation and respectfully request Mayor and City Council approval. MCVM /jml Attachment cc: Barry Lindahl, City Attorney Cindy Steinhauser, Assistant City Manager Jennifer Larson, Budget Director Michel C. Van Milligen Floodwall Levee Slope Repair, Flood Control Levee Certification, Refuse Dual Packer Recycling Vehicle, Oak Grove Sanitary Sewer, North Fork Sanitary/Storm Improvements, Louise Street Bridge Replacement, Montrose Steps Reconstruction, Highway 52 Resurfacing, Green Alley Pilot Program Phase I, Locust 9 to 17 Kephart Building Improvements, North Siegert Farm Phase II, Purchase of Former Tri -State Building, Finance Community Plus Software Upgrade, Finance Purchase Card Software Component, and Finance Plus Software 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 2011. The most significant of the capital project expenditure carryovers, including associated revenue, are: Water Pollution Control Plant Upgrade ($11,848,340); 10 and Central Parking Ramp Construction ($9,639,719); Bee Branch Restoration ($8,723,186); Millwork District Street Improvements ($5,082,095); Transient Boat Docks ($3,769,544); Downtown Housing Incentives ($2,465,000); Airport Terminal Runway 31 Construction ($2,686,100); Sanitary Sewer Improvements ($2,333,220); Northwest Arterial Capacity Improvements ($1,718,952); Water Annexation Study /Implementation ($1,505,528); US 61/151 Corridor Improvements ($895,403); North Siegert Farm ($870,764); Community Development Block Grant funded projects ($615,148); Fire Station Expansion /Relocation ($603,059); Rivers to the Sea Exhibit ($553,268); Kaufmann Avenue Resurfacing ($518,761); US 52 /Central Traffic Improvements ($486,039); EB Lyons Expansion Project ($479,970); and Main Street Sidewalk Improvements ($467,276). OPERATING BUDGET CARRYOVER AMENDMENT The most significant operating budget carryovers into Fiscal Year 2011 include such items as Police Department Grants ($246,486); Federal Building Maintenance ($85,396); Section 8 Voucher Software ($69,585); Housing Administration Every Child 1 Every Promise Grants ($50,000); Human Rights Grant Appropriation ($57,799); Building Services Washington Neighborhood Alley Light Grant Program ($35,000); Refuse Collection Carts ($32,500); Police Patrol Training ($31,585); Fire CPAT Costs ($31,160); Purchase of Service Every Child 1 Every Promise ($25,000); Building Services Software ($20,782); Transit Equipment ($16,000); Airport Radar Maintenance Fee ($25,000); and Community Development Block Grant ($23,531). FIRST AMENDMENT TO THE FISCAL YEAR 2011 CERTIFIED BUDGET There have been numerous actions by City Council and changes requiring amendments for the Fiscal Year 2011 budget. The capital budget amendments total $9,912,103, with an increase in associated revenue of $11,501,757. The amendment items include: Market Rate Downtown Housing Loan Pool ($4,350,000) funded by Iowa Finance Authority; Bee Branch Construction and Property Acquisition ($3,416,936) from General Obligation Bonds abated with Stormwater User Fees; Airport Hangar Replacement and Repair ($589,200) from Insurance Reimbursement; US 52 /Central Traffic Improvements ($500,000) from Energy Efficiency and Conservation Block Grant: Home Rehab Loan Proaram Grants ($250.000) funded by Iowa Finance Authority Our Authority I -JOBS Affordable Housing Assistance Grants; Northwest Arterial Hike /Bike Trail Phase 3 ($200,000) funded by an Iowa Department of Natural Resources REAP grant; Housing Trust Grants ($157,250) funded by Iowa Finance Authority Housing Trust Grant; Market Rate Downtown Housing Loan Interest Repayment ($135,000) funded by repayments from developers; Green Alley Pilot Project ($91,182) funded by Community Development Block Grant - Recovery ; Kephart Building Improvements ($76,259) funded by Community Development Block Grant; and Street Improvements Related to the Closing of Cox Street ($50,125) funded by the purchase of Cox Street by Loras College. OPERATING BUDGET AMENDMENT The operating budget amendments total $981,872, with associated increase in revenue of $992,764. The amendment items include Public Works Salt Operations at Purina Drive ($769,986) funded by salt partner purchases; Library Reorganization of Staff ($15,354) funded with City -Wide General Liability Premium Savings; Arts and Cultural Affairs Coordinator Additional Hours ($13,022) funded with Iowa Community Cultural Grant; Water Department Debt Service for Additional Borrowings ($90,974); and Transit Division Grant Match and Contract Custodial ($57,540). 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 20, 2010. Attachments JML Attest: RESOLUTION NO. 347 -10 SETTING THE DATE FOR THE PUBLIC HEARING ON AMENDMENT NO. 2 TO THE FISCAL YEAR 2011 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. 2 to the Fiscal Year 2011 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 20, 2010, 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 7th day of September 2010. eanne F. Schneider, City Clerk Roy D. oI, Mayor Nov -07 NOTICE OF PUBLIC HEARING Form 653.C1 AMENDMENT OF CURRENT CITY BUDGET The City Council of DUBUQUE in DUBUQUE will meet at City Council Chambers at the Historic Federal Building at 6:30 p.m. on 9/20/10 (hour) (Date) ,for the purpose of amending the current budget of the city for the fiscal year ending June 30, County, Iowa 2011 Near) by changing estimates of revenue and expenditure appropriations in the following functions for the reasons given. Additional detail is available at the city clerk's office showing revenues and expenditures by fund type and by activity. Explanation of increases or decreases in revenue estimates, appropriations, or available cash: This amendment adds the capital budget carryovers of $69,855,029 & its associated revenue of $60,394,542, & encumbrance carryovers of $20,990,781 (continuing appropriation authority,not requiring formal amendment/ for reporting purposes only). It also adds operating budget carryovers of $952,135 & its associated revenue of $4,171,654, requiring a formal amendment. Also included in this amendment is $10,893,975 in new expense & associated revenue of $12,494,521 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 Total Budget as certified or last amended Current Amendment Total Budget after Current Amendment Revenues & Other Financing Sources 1 ................ ::.... 19,177,697 ................. 19,177,697 Taxes Levied on Property Less: Uncollectted Property Taxes -Levy Year 2 0 0 Net Current Property Taxes 3 19,177,697 0 19,177,697 Delinquent Property Taxes 4 0 0 TIF Revenues 5 9,080,612 9,080,612 Other City Taxes 6 14,628,325 14,628,325 Licenses & Permits 7 1,187,750 1,187,750 Use of Money and Property 8 17,204,673 135,000 17,339,673 Intergovernmental 9 41,810,047 33,533,137 75,343,184 Charges for Services 10 29,537,134 739,427 30,276,561 Special Assessments 11 229,000 857,809 1,086,809 Miscellaneous 12 6,930,645 2,178,512 9,109,157 Other Financing Sources 13 51,008,769 45,711,134 96,719,903 Total Revenues and Other Sources 14 190,794,652 83,155,019 273,949,671 Expenditures & Other Financing Uses 15 .................. .......................... .................. .......................... .................. .......................... .................. .......................... .................. .......................... .................. 23,226,178 .................. ............................... .................. ............................... .................. ............................... .................. ............................... .................. ............................... .................. 618,728 .................. .................. .................. .................. .................. .................. 23,844,906 Public Safety Public Works 16 11,236,376 1,129,909 12,366,285 Health and Social Services 17 864,254 98,118 962,372 Culture and Recreation 18 9,392,532 117,954 9,510,486 Community and Economic Development 19 11,678,675 380,312 12,058,987 GeneralGovemment 20 6,912,832 272,989 7,185,821 Debt Service 21 5,716,743 90,974 5,807,717 Capital Projects 22 37,105,080 50,390,346 87,495,426 Total Govemment Activities Expenditures 23 106,132,670 53,099,330 159,232,000 Business Type / Enterprises 24 61,034,759 49,592,589 110,627,348 Total Gov Activities & Business Expenditures 25 167,167,429 102,691,919 269,859,348 Transfers Out 26 23,426,759 6,094,302 29,521,061 Total Expenditures/Transfers Out 27 190,594,188 108,786,221 299,380,409 Excess Revenues & Other Sources Over (Under) Expenditures/Transfers Out Fiscal Year 28 .................. 200,464 .................. - 25,631,202 ........... .. - 25,430,738 Continuing Appropriation 29 N/A 0 Beginning Fund Balance July 1 30 23,257,306 26,483,909 49,741,215 Ending Fund Balance June 30 31 23,457,770 852,707 24,310,477 Nov -07 NOTICE OF PUBLIC HEARING Form 653.C1 AMENDMENT OF CURRENT CITY BUDGET The City Council of DUBUQUE in DUBUQUE will meet at City Council Chambers at the Historic Federal Building at 6:30 p.m. on 9/20/10 (hour) (Date) ,for the purpose of amending the current budget of the city for the fiscal year ending June 30, County, Iowa 2011 Near) by changing estimates of revenue and expenditure appropriations in the following functions for the reasons given. Additional detail is available at the city clerk's office showing revenues and expenditures by fund type and by activity. Explanation of increases or decreases in revenue estimates, appropriations, or available cash: This amendment adds the capital budget carryovers of $69,855,029 & its associated revenue of $60,394,542, & encumbrance carryovers of $20,990,781 (continuing appropriation authority,not requiring formal amendment/ for reporting purposes only). It also adds operating budget carryovers of $952,135 & its associated revenue of $4,171,654, requiring a formal amendment. Also included in this amendment is $10,893,975 in new expense & associated revenue of $12,494,521 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 Form 653.C1 NOTICE OF PUBLIC HEARING AMENDMENT OF CURRENT CITY BUDGET The City Council of DUBUQUE in DUBUQUE wit meet at City Council Chambers at the Historic Federal Building at 6:30 p m on 09/20/2010 County, Iowa (hour) (Date) ,for the purpose of amending the current budget of the city for the fiscal year ending June 30, 2011 (year) 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. Explanation of increases or decreases in revenue estimates, appropriations, or available cash This amendment adds the capital budget carryovers of $69,855,029 & its associated revenue of $60,394,542, & encumbrance carryovers of $20,990,781 (continuing appropriation authority,not requiring formal amendment/ for reporting purposes only). It also adds operating budget carryovers of $952,135 & its associated revenue of $4,171,654, requiring a formal amendment. Also included in this amendment is $10,893,975 in new expense & associated revenue of $12,494,521 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. Jeanne Schneider City Clerk Total Budget as certified or last amended Current Amendment Total Budget after Current Amendment Revenues & Other Financing Sources 19,177,697 19,177,697 Taxes Levied on Property 1 Less. Uncollectted Property Taxes -Levy Year 2 0 0 Net Current Property Taxes 3 19,177,697 0 19,177,697 Delinquent Property Taxes 4 0 0 TIF Revenues 5 9,080,612 9,080,612 Other City Taxes 6 14,628,325 14,628,325 Licenses & Permits 7 1,187,750 1,187,750 Use of Money and Property 8 17,204,673 135,000 17,339,673 Intergovernmental 9 41,810,047 33,533,137 75,343,184 Charges for Services 10 29,537,134 739,427 30,276,561 Special Assessments 11 229,000 857,809 1,086,809 Miscellaneous 12 6,930,645 2,178,512 9,109,157 Other Financing Sources 13 51,008,769 45,711,134 96,719,903 o a - avenues an. 1 er ources 'r , r • ,•� •, Expenditures & Other Financing Uses 23,226,178 618,728 1 1 23,844,906 Public Safety 15 Public Works 16 11,236,376 1,129,909 12,366,285 Health and Social Services 17 864,254 98,118 962,372 Culture and Recreation 18 9,392,532 117,954 9,510,486 Community and Economic Development 19 11,678,675 380,312 12,058,987 General Govemment 20 6,912,832 272,989 7,185,821 Debt Service 21 5,716,743 90,974 5,807,717 Capital Projects 22 37,105,080 50,390,346 87,495,426 Total Government Activities Expenditures 23 106,132,6(0 53,099,330 159,232,000 Business Type / Enterprises 24 61,034,759 167,167,429 49,592,589 102,691,919 110,627,348 269,859,348 1 otal Lov Activities & Business txpendrtures 25 Transfers Out 26 23,426,759 6,094,302 29,521,061 Total Expenditures/Transfers Out 27 190,594,188 108,786,221 299,380,409 Excess Revenues & Other Sources Over ( Under) Expenditures /Transfers Out for Fiscal Year 28 200,464 - 25,631,202 - 25,430,738 Continuing Appropriation 29 N/A 0 Beginning Fund Balance July 1 30 23,257,306 26,483,909 49,741,215 Ending Fund Balance June 30 31 23,457,770 852,707 24,310,477 Form 653.C1 NOTICE OF PUBLIC HEARING AMENDMENT OF CURRENT CITY BUDGET The City Council of DUBUQUE in DUBUQUE wit meet at City Council Chambers at the Historic Federal Building at 6:30 p m on 09/20/2010 County, Iowa (hour) (Date) ,for the purpose of amending the current budget of the city for the fiscal year ending June 30, 2011 (year) 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. Explanation of increases or decreases in revenue estimates, appropriations, or available cash This amendment adds the capital budget carryovers of $69,855,029 & its associated revenue of $60,394,542, & encumbrance carryovers of $20,990,781 (continuing appropriation authority,not requiring formal amendment/ for reporting purposes only). It also adds operating budget carryovers of $952,135 & its associated revenue of $4,171,654, requiring a formal amendment. Also included in this amendment is $10,893,975 in new expense & associated revenue of $12,494,521 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. Jeanne Schneider City Clerk 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/20/10 ,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. A RESOLUTION AMENDING THE CURRENT BUDGET FOR THE FISCAL YEAR ENDING JUNE 30, 2011 (AS AMENDED LAST ON JULY 19, 2010 .) Be it Resolved by the Council of the City of DUBUQUE Section 1. Following notice published and the public hearing held, 9/20/10 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: Signature City Clerk/Finance Officer Passed this 20th day of September, 2010 (DY) (Month/Year) 31 -288 Signature Mayor Total Budget as certified or last amended Current Amendment Total Budget after Current Amendment Revenues & Other Financing Sources 19,177,697 0 19,177,697 Taxes Levied on Property 1 Less: Uncollectted Property Taxes -Levy Year 2 0 0 0 Net Current Property Taxes 3 19,177,697 0 19,177,697 Delinquent Property Taxes 4 0 0 0 TIF Revenues 5 9,080,612 0 9,080,612 Other City Taxes 6 14,628,325 0 14,628,325 Licenses & Permits 7 1,187,750 0 1,187,750 Use of Money and Property 8 17,204,673 135,000 17,339,673 Intergovernmental 9 41,810,047 33,533,137 75,343,184 Charges for Services 10 29,537,134 739,427 30,276,561 Special Assessments 11 229,000 857,809 1,086,809 Miscellaneous 12 6,930,645 2,178,512 9,109,157 Other Financing Sources 13 51,008,769 45,711,134 96,719,903 Total Revenues and Other Sources 14 190,794,652 83,155,019 273,949,671 Expenditures & Other Financing Uses P 9 23,226,178 618,728 23,844,906 Public Safety 15 Public Works 16 11,236,376 1,129,909 12,366,285 Health and Social Services 17 864,254 98,118 962,372 Culture and Recreation 18 9,392,532 117,954 9,510,486 Community and Economic Development 19 11,678,675 380,312 12,058,987 General Government 20 6,912,832 272,989 7,185,821 Debt Service 21 5,716,743 90,974 5,807,717 Capital Projects 22 37,105,080 50,390,346 87,495,426 Total Government Activities Expenditures 23 106,132,670 53,099,330 159,232,000 Business Type / Enterprises 24 61,034,759 49,592,589 110,627,348 Total Gov Activities & Business Expenditures 25 167,167,429 102,691,919 269,859,348 Transfers Out 26 23,426,759 6,094,302 29,521,061 Total Expenditures/Transfers Out 27 190,594,188 108,786,221 299,380,409 Excess Revenues & Other Sources Over (Under) Expenditures/Transfers Out Fiscal Year 28 200,464 - 25,631,202 - 25,430,738 Continuing Appropriation 29 0 N/A 0 Beginning Fund Balance July 1 30 23,257,306 26,483,909 49,741,215 Ending Fund Balance June 30 31 23,457,770 852,707 24,310,477 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/20/10 ,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. A RESOLUTION AMENDING THE CURRENT BUDGET FOR THE FISCAL YEAR ENDING JUNE 30, 2011 (AS AMENDED LAST ON JULY 19, 2010 .) Be it Resolved by the Council of the City of DUBUQUE Section 1. Following notice published and the public hearing held, 9/20/10 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: Signature City Clerk/Finance Officer Passed this 20th day of September, 2010 (DY) (Month/Year) 31 -288 Signature Mayor FiSCAL YEAR 2011 AMENDMENT #2 ('ITV COUNCIL Department Program Description FY 11 FY 11 Expense Revenue Amount Amount Fund Activity/CIP Account Explanation 31- Aug -10 GENERAL FUND Police Departmei 1C Dbq Police Firearms Range - R.O.W. 7,500 101 1011589 73113 C/O Police Departmei 1C Dbq Police Firearms Range - Construction 20,000 101 1011589 73211 C/O Police Departmei 1C Police Admin Office Remodel - Construction 46,932 101 1011863 73210 CIO Police Departmei 1C Police Wireless Data Trans System - Computer Peripherals 327,000 101 1012092 71120 C/O Police Departmei 1C Police Wireless Data Trans System - Consulting 10,500 101 1012092 62712 C/O Police Departmei 1 Records and ID - Part-time Employee 21,477 100 10011220 61020 Approved in FY 11 Budget Police Departmei 1 Records and ID - Social Security 1,643 100 10011220 61320 Approved in FY11 Budget Police Departmei 1 Records and ID - IPERS 1,493 100 10011220 61310 Approved in FYI 1 Budget Police Departmei 1 Staff Services - Desks /Chairs 15,698 100 10011190 71211 C/O Police Departmei 1 Staff Services - Partitions 1,480 100 10011190 71224 C/O Police Departmei 1 Police Training - Training for Early Hires 15,284 100 10011250 62360 C/O Police Departmei 1 Criminal Investigation - Vehicle Replacement 2,310 100 10011300 71310 C/O Police Departmei 1 Criminal Investigation - Lighting Equipment 2,400 100 10011300 71310 C/O Police Departmei 1 Police Patrol - Police Honor Guard Dress Jackets 1,680 100 10011700 62011 C/O Police Departmei 1 Police Patrol - Training 31,585 100 10011700 62360 C/O Police Departmei 1 Police Patrol - Vehicle Replacement 11,000 100 10011700 71310 C/O Police Departmei 1 Police Patrol - Lighting Equipment 2,180 100 10011700 71510 C/O Police Departmei 1 Police Patrol - Visibars 8,526 100 10011700 72210 C/O Police Departmei 1 2009 Justice Assistance Stimulus Grant - Reimbursable OT 104,381 100 10011740 61051 C/O Police Departmei 1 2009 Justice Assistance Stimulus Grant - Misc Op Supplies 87,847 100 10011740 62671 C/O Police Departmei 1 2009 Justice Assistance Grant - Reimb OT 3,638 100 10011775 61051 C/O Police Departmei 1 2009 Justice Assistance Grant- Misc Op Supplies 11,772 100 10011775 62671 CIO Police Departmei 1 2008 Justice Assistance Grant- Reimb OT 8,360 100 10011774 61051 CIO Police Departmei 1 2008 Justice Assistance Grant - Police Equipment 5,159 100 10011774 72218 C/0 Police Departmei 1 2007 Justice Assistance Grant - Reimb OT 2,688 100 10011752 61051 C/O Police Departmei 1 2007 Justice Assistance Grant- Police Equipment 46 100 10011752 72218 C/O Police Departmei 1 Domestic Abuse Grant- Reimb OT 2,041 100 10011754 61051 C/O Police Departmei 1 Domestic Abuse Grant - Federal Grant 2,041 100 10011754 44135 C/O Police Departmei 1 Domestic Abuse Grant- Reimb OT 307 100 10011754 61051 Increase based on new grant award Police Departmei 1 Domestic Abuse Grant- Federal Grant 307 100 10011754 44135 Increase based on new grant award Police Departmei 1 Helping Services of IA Grant - Underage Alcohol - Reimb OT 1,820 100 10011324 61051 C/O Police Departmei 1 Helping Services of IA Grant - Underage Alcohol - Grant 1,820 100 10011324 45771 CIO Police Departmei 1 2009 Meth Hot Spots Grant 6,409 100 10011319 61051 C/O Police Departmei 1 2009 Meth Hot Spots Grant 6,617 100 10011319 45771 C/O Police Departmei 1 2010 Multijurisdictional Drug Law Enforcement Grant 54,258 100 10011320 61051 C/0 Police Departmei 1 2010 Multijurisdictional Drug Law Enforcement Grant - Stimulus 54,258 100 10011320 44176 C/O Police Departmei 1 Bulletproof Vest Grant - 2009 3,045 100 10011704 44125 C/O Police Departmei 1 Governor's Traffic Safety Bureau Grant - 2009 14,865 100 10011771 44125 C/O Police Departmei 1 Governor's Traffic Safety Bureau Grant - 2009- Reimb OT 7,233 100 10011771 61051 C/O Police Departmei 1 Governor's Traffic Safety Bureau Grant - 2009- Training 1,250 100 10011771 62360 CIO Police Departmei 1 Drug Task Force Grant - Stimulus Grant 8,379 100 10011321 45771 CIO Emergency Cone 1 Emergency Communication Center - Desks /Chairs 1,200 100 10012100 71211 C/O Fire Department 1 C Pumper Replacement 106,617 100 1001016 71318 CIO Page 1 FISCAL YEAR 2011 AMENDMENT #2 CITY ('Ot'' \CI1. Department Fire Department Fire Department Fire Department Fire Department Fire Department Fire Department Fire Department Human Rights Human Rights Human Rights Human Rights Human Rights Human Rights Human Rights Health Services Health Services Health Services Health Services Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Program Description 1C Station #4 Improvements 1C Exterior Imprv- Station #4 1C Fire Station Expansion/Relocation 1C Fire Station Expansion/Relocation 1 Administration - Miscellaneous Services - CPAT costs 1 Fire Training - Education and Training 1 Suppression - Software - GIS Link Drawing 3 Human Rights Grant -Mist Services 3 Human Rights Grant -Fair Housing Training 3 Human Rights Grant - Training & Education 3 Human Rights Grant - Printing & Binding 3 Human Relations - Travel & Conferences 3 Human Relations - Consulting Services 3 Human Relations - Travel & Conferences 3 Health Services Administration - Travel & Conferences 3 Animal Control - Computer 3 Community Health Service - Preparedness Grant 3 Lead Paint Program - Childhood Lead Poisoning Grant 4C HWY 20 Landscape Design 4C Flora Park Storm Sewer Extension - Construction 4C Westbrook Park Development - Eng. Division Svcs 4C Westbrook Park Development - Construction 2C NW Hike/Bike Trail - REAP Grant 2C NW Hike/Bike Trail - Construction Not Building 2C NW Hike/Bike Trail - REAP Grant 2C NW Hike/Bike Trail - Construction Not Building 2C Trolley Line Trail - REAP Grant 4C Dubuque History Trail - Federal Grants 4C Dubuque History Trail - Consultant Services 4C Dubuque History Trail - Equipment Acquisition 4C Marshall Park - Pool Repair 4C Erosion Control Study 4C Catfish Creek Hike -Bike Trail Study - Consultant Services 4C Dubuque Community Ice Arena - Pay to Other Agency 4C EPP - Replace Fence - Const Cont - Not Bldg 4C BMX Bike Course 4C Roosevelt Property - Repair Rd - Const Contr - Supplement 4C Greenhouse - Addition - Consulting Engineers 4C Greenhouse - Addition - Const Contr - Bldg 4C Security Cameras - Equip Acquisition 4C Old Park Blueprint Preservation - Consultant Services 4C Grandview/Rockdale Park Dev - Const Cont Not Bldg 4C Grandview/Rockdale Park Dev - Private Participant 4C Mines of Spain Exhibit - Private Participant 4C Mines of Spain Exhibit - Federal Grant FY 11 Expense Amount 16,175 49,674 603,059 31,160 (705) 7,000 10,897 36,740 8,092 21,059 13,000 5,000 (10,983) 500 5,500 17,987 5,000 17,000 62,200 1,447 200,000 14,850 133,650 20,000 31,240 15,400 50,000 10,000 8,209 10,000 9,000 85,400 3,541 6,436 55,680 Page 2 FY 11 Revenue Amount Fund Activity/CIP Account 101 1011460 73210 101 1011555 62712 650,000 101 1011864 54205 101 1011864 73211 100 10013100 62731 100 10013100 62360 100 10013400 71123 100 10016200 62731 100 10016200 62753 100 10016200 62360 100 10016200 62090 100 10016100 62310 100 10016100 62310 100 10016100 62310 100 10017100 62310 100 10017200 71124 4,488 100 10017400 45771 10,728 100 10017500 45771 100 1001114 73310 101 1011211 73211 101 1011582 62811 101 1011582 73211 20,000 100 1001157 45707 100 1001157 73211 200,000 100 1002273 45707 100 1002273 73211 17,940 100 1001989 45707 148,500 100 1001956 44170 100 1001956 62716 100 1001956 73411 101 1011983 73211 100 1001987 62712 101 1012078 62716 100 1002084 62761 101 1012096 73211 102 1021871 73211 102 1022103 73510 102 1022104 62712 102 1022104 73210 102 1022105 73410 100 1002176 62716 100 1002181 73211 84,225 100 1002181 53102 125,000 100 1002056 53102 100,000 100 1002056 44170 31- Aug -10 Explanation C/O C/O C/O C/O C/O C/O - Prespend FY 11 C/O C/O Fair Housing Grant Exp C/O Fair Housing Grant Exp C/O Fair Housing Grant Exp C/O Fair Housing Grant Exp C/O C/O C/O - Prespend FY 11 C/O C/O C/O C/O - Childhood Lead Grant C/O C/O C/O C/O C/O C/O - Shift from Flora Storm Sewer New REAP Grant Grant Appropriation C/O C/O C/O C/O C/O C/O C/O C/O C/O Fr CIP 1002101 - $5,000 102210543,20! C/O C/O C/O C/O C/O C/O C/O C/O C/O FISCAL YEAR 2011 AMENDMENT #2 CITY COUNCIL Department Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Parks Division Civic Center Div Recreation Divis Recreation Divis Library Departm( Library Departm( Library Departmt Library Departm( Library Departim Library Departmi Library Departim Library Departim Library Departim Library Departim Library Departim Library Depart Library Departim Library Departmi Library Departim Library Departim Library Departmt Library Departim Library Departml Library Departml Library Departim Library Departim Library Departim Library Departim Library Departim Library Departml Library Departim Library Departm( Library Departml Library Departm( Library Departm( Library Departmt Library Departim Library Departmi Program Description 4C Mines of Spain Exhibit Construction 4C EB Lyons Expansion - Private Participant 4C EB Lyons Expansion - Vision Iowa Grant 4C EB Lyons Expansion - State Legislation 4C EB Lyons Expansion - State Solid Waste Alternative Program 4C EB Lyons Expansion - Const Contract Bldg 4C Dubuque Water Trail - State DNR Grant 4C Dubuque Water Trail - Signage 4C Theater- Refurbish Brass - Const Contr-Bldg 4C Flora Pool Paint Filter Tank - Construction Not Building 4C Flora Pool - Sand Playground - Construction Not Building 4 Adult Services - Full -Time Employee 4 Adult Services - Social Security 4 Adult Services - IPERS 4 Adult Services - Health Insurance 4 Adult Services - Life Insurance 4 Circulation Services - Part-Time Employee 4 Circulation Services - Social Security 4 Circulation Services - IPERS 4 Adult Services - Part-Time Employee 4 Adult Services - Social Security 4 Adult Services - IPERS 4 Technical Services - Part-Time Employee 4 Technical Services - Social Security 4 Technical Services - IPERS 4 Library Administration - Part-Time Employee 4 Library Administration - Social Security 4 Library Administration - IPERS 4 Library Administration - Overtime 4 Library Administration - Social Security 4 Library Administration - IPERS 4 Technical Services - Part-Time Employee 4 Technical Services - Social Security 4 Technical Services - IPERS 4 Circulation Services - Part-Time Employee 4 Circulation Services - Social Security 4 Circulation Services - IPERS 4 Library Administration - Part-Time Employee 4 Library Administration - Social Security 4 Library Administration - IPERS 4 Adult Services - Full -Time Employee 4 Adult Services - Social Security 4 Adult Services - IPERS 4 Adult Services - Health Insurance 4 Adult Services - Life Insurance FY 11 Expense Amount 50,000 479,970 6,000 10,000 35,549 80,000 (54,935) (4,203) (3,818) (8,700) (110) (7,355) (563) (511) (21,077) (1,612) (1,465) (4,839) (370) (336) (4,750) (363) (330) (3,000) (230) (209) 16,078 1,230 1,117 21,077 1,612 1,465 24,116 1,845 1,676 48,097 3,679 3,342 8,700 96 Page 3 FY 11 Revenue Amount 776,994 58,806 100,000 20,000 6,000 Fund Activity/CIP Account Explanation 100 1002056 73210 C/O 100 1002171 53102 C/O 100 1002171 45761 C/O 100 1002171 45701 C/O 100 1002171 45701 C/O 100 1002171 73210 C/O 100 1002277 45701 New Grant 100 1002277 73411 New Grant Appropriation 102 1022119 73210 CIO 101 1011999 73211 C/O 102 1022120 73211 C/O 100 10036200 61010 FYI 1 Reorganization of Staff 100 10036200 61320 FY11 Reorganization of Staff 100 10036200 61310 FY11 Reorganization of Staff 100 10036200 61410 FY11 Reorganization of Staff 100 10036200 61416 FY 1 I Reorganization of Staff 100 10036220 61020 FY I1 Reorganization of Staff 100 10036220 61320 FY11 Reorganization of Staff 100 10036220 61310 FY 11 Reorganization of Staff 100 10036200 61020 FYI1 Reorganization of Staff 100 10036200 61320 FYI 1 Reorganization of Staff 100 10036200 61310 FY 11 Reorganization of Staff 100 10036500 61020 FYI 1 Reorganization of Staff 100 10036500 61320 FY11 Reorganization of Staff 100 10036500 61310 FY 11 Reorganization of Staff 100 10036100 61020 FY11 Reorganization of Staff 100 10036100 61320 FY11 Reorganization of Staff 100 10036100 61310 FYl I Reorganization of Staff 100 10036100 61020 FY11 Reorganization of Staff 100 10036100 61320 FY11 Reorganization of Staff 100 10036100 61310 FY11 Reorganization of Staff 100 10036500 61020 FY11 Reorganization of Staff 100 10036500 61320 FY11 Reorganization of Staff 100 10036500 61310 FY11 Reorganization of Staff 100 10036220 61020 FYI 1 Reorganization of Staff 100 10036220 61320 FYI 1 Reorganization of Staff 100 10036220 61310 FY11 Reorganization of Staff 100 10036100 61020 FYI 1 Reorganization of Staff 100 10036100 61320 FY11 Reorganization of Staff 100 10036100 61310 FY11 Reorganization of Staff 100 10036200 61010 FYI 1 Reorganization of Staff 100 10036200 61320 FY11 Reorganization of Staff 100 10036200 61310 FY11 Reorganization of Staff 100 10036200 61410 FY11 Reorganization of Staff 100 10036200 61416 FY11 Reorganization of Staff 31- Aug -10 FISCAL YEAR 2011 AMENDMENT #2 ('1'F\ COUNCIL Department Program Description Library Departim Library Departim Library Departim Library Departim Library Departmi Library Departm4 Library Departim Library Departim Library Departrm Library Departmm Library Departml Library Departim Library Departin Library Departim Library Departrm Library Departm4 Library Departm■ Library Departm4 Library Departmm Airport Departmi Airport Departim Airport Departtm Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works Engineering Engineering Engineering Engineering Engineering 4 Technical Services - Misc Op Supplies 4 Adult Services - Mileage 4 Adult Services - Conferences 4 Adult Services - Promotion 4 Adult Services - Library Video Materials 4 Library Administration - Mileage 4 Library Administration - Travel Conferences 4 Library Administration - Travel City Business 4 Children Services -Misc Op Supplies 4 Children Services - Conferences 4 Adult Services - Library Books 4 Adult Services - AudioNisual 4 Adult Services - Video Material 4 Adult Services - Periodicals 4 Youth Services - Library Books 4 Youth Services - Pool Rental 4C Library Window Treatments 4C Audio - Visual Listening/Viewing Stations - Equip. Acquisition 4C Library Landscaping 2C Safety Mgmt Systems Grant - Construction Not Building 2C Safety Mgmt Systems Grant - Safety Mgmt Systems 2 Airport Operations Misc Services - Radar Maint Fee 2 Street & Traffic Lighting - Traffic Control Equipment 2C Heritage Trail - Principal Route - Consultant Services 2C Underground Tank Removal - Construction Not Building 2C Bi- Lingual Trail Signage - Signage 2C Bi- Lingual Trail Signage - State Grant 2C PW Fleet GPS Project - Pager/Radio Equipment 2C PW Fleet GPS Project - Pager/Radio Equipment 2 Public Works Salt Ops Purina Drive - Salt Storage Revenue 2 Public Works Salt Ops Purina Drive - Salt Handling Revenue 2 Public Works Salt Ops Purina Drive - Salt Sale Revenue 2 Public Works Salt Ops Purina Drive - Handling Fees 2 Public Works Salt Ops Purina Drive - Scale 2 Public Works Salt Ops Purina Drive - Handling Fees 2 Public Works Salt Ops Purina Drive - Tarping Fees 2 Public Works Salt Ops Purina Drive - Salt Purchase 2 Public Works Salt Ops Purina Drive - Hauling Fees 2 Public Works Administration - Typewriter 2 Public Works Administration - Conferences 2C Sewer Conn Asst - Low/Mod - Miscellaneous Services 2C Fiber Optic Con - Priv & Misc - Eng Division Svc 2C Fiber Optic Con - Priv & Misc - Construction 2C Recon Signals /JFK- Wacker - Eng. Division Services 2C Recon Signals /JFK - Wacker - Construction FY 11 Expense Amount 148 100 (200) 63 24 261 1,210 88 9 (360) 1,553 258 391 39 1,423 (225) 253 7,716 36,080 48,156 25,000 4,902 (348) 28,000 15,271 14,947 5,546 150,000 60,000 55,665 13,627 487,092 3,602 700 (974) 15,000 66,614 138,506 19,283 123,843 Page 4 FY 11 Revenue Amount Fund Activity/CIP Account 100 10036500 62671 100 10036200 62340 100 10036200 62310 100 10036200 62140 100 10036200 62659 100 10036100 62340 100 10036100 62310 100 10036100 62320 100 10036210 62671 100 10036210 62310 100 10036200 62651 100 10036200 62652 100 10036200 62659 100 10036200 62653 100 10036400 62651 100 10036400 62671 100 1001570 73410 101 1011786 73410 100 1002006 73211 100 1001969 73211 48,156 100 1001969 44105 100 10051400 62731 100 10054430 71411 100 1001028 62716 100 1002152 73211 100 1002169 71227 29,239 100 1002169 45701 100 1001935 72410 101 1011935 72410 60,000 100 10054425 51977 150,000 100 10054425 51976 604,802 100 10054425 51975 100 10054425 62782 100 10054425 71530 100 10054425 62782 100 10054425 62783 100 10054425 62640 100 10054425 62780 100 10054100 71112 100 10054100 62310 100 1001067 62731 102 1021609 62811 102 1021609 73211 101 1011919 62811 101 1011919 73211 31- Aug -10 Explanation C/O C/0 C/O - Prespend FY 11 C/O C/O C/O C/O C/O C/O C/O - Prespend FY11 Lost book money Lost book money Lost book money Lost book money Lost book money C/O - Prespend FY 11 C/O C/O C/O C/O C/O C/O C/O Purchase Order Budget Canceled C/O C/O C/O C/O C/O Morton Agreement Morton Agreement Partner Salt Agreements Morton Handling Fees Scale for Salt Ops Partner Handling Fees Partner Tarping Fees Partner Salt Purchases Partner Permit Fees C/O C/O - Prespend FY 11 C/O C/O C/O C/O C/O FISCAL YEAR 2011 AMENDMENT #2 ('En COI NCI I. Department Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Building Service: Building Service: Building Service: Building Service: Building Service: Economic Devlol Economic Devlol Economic Devlol Economic Devlol Economic Devlol Economic Devlol Economic Devlol Economic Devloi Housing & Comr Housing & Comr Housing & Comr Program Description 2C 5 Points Intersection Signal - Eng. Division Services 2C 5 Points Intersection Signal - Construction 2C Safes Routes to School - Const Contract Not Building 2C Hempstead Safety Improvements - Const Contract Not Bldg 2C Hempstead Safety Improvements - State Traffic Grant 2C Hempstead Safety Improvements - Private Participation 2C Derby Grange Intersection - Construction Not Building 2C Shot Tower Restoration - Construction 2C Shot Tower Restoration -State Grant 2C Riverfront Leasehold Improvements - Consultant Services 2C Sidewalk Repair/Maintenance 2C Decorative Concrete Maint - Construction 2C Heeb Street Wall - Construction 2C Loras/Cox Street - Land Sales - Loras College 2C Loras/Cox Street - Construction Not Building 2C Accessibility Barriers - Construction 2C Tourism Signage Program - Signage 4C Library Renovation - Construction 4C Library Renovation - Contributions 4C Library Renovation - Sale of Assets - Heade Painting 2C Rivers to the Sea Exhibit - Construction 2C Rivers to the Sea Exhibit - State Grant 2C Transient Docks - Main Channel - Consulting Engineers 2C Woodward Museum Restoration - Fed Pass Thru Grant 2C Woodward Museum Restoration - Private Part. -DCHS 2C Woodward Museum Restoration 2C Railroad Depot Phase II -Fed Pass Thru Grant 2C Railroad Depot Phase II - Private Part. -DCHS 2C Railroad Depot Phase II 6 1157 Central Ave Maint - Utility Exp - Electricity 1 Building Services Admin - Eng Division Services 1 Building Services Admin - Education and Training 1 Building Services Admin - Software 1 Building Services Admin - Pager/Radio Equipment 5C IFA Downtown Loan Pool - Loan Proceeds 5C IFA Downtown Loan Pool - Interest Repayments 5C IFA Downtown Loan Pool - Interest Expense 5C IFA Downtown Loan Pool - Loans to Developers 5C Brownfields Grant - Consulting Engineers 5C Port of DBQ- Develop.Standards (Int Write Down) 5C Port of DBQ- Develop.Standards (Int Write Down) 5C Warehouse Master Planning - Private Participant 5 Housing Administration - Consultant Services 6 Federal Building Maintenance - Property Maintenance 5 445 Loras - Property Maintenance FY 11 Expense Amount 7,478 85,000 19,733 152,164 157,536 12,076 12,000 (10,987) 37,827 (40,000) 50,125 19,537 25,553 253,710 553,268 620,135 241,929 17,430 4,000 35,000 (958) 20,782 12,750 135,000 4,350,000 3,865 35,353 15,000 50,000 85,396 15,720 Page 5 FY 11 Revenue Amount Fund Activity/CIP Account Explanation 102 1021920 62811 102 1021920 73211 101 1011922 73211 101 1012077 73211 500,000 101 1012077 45701 47,602 101 1012077 53102 101 1012077 73211 100 1001854 73211 100,000 100 1001854 45701 101 1011053 62716 100 1001108 73211 102 1021630 73211 100 1002086 73211 50,125 100 1002076 54105 100 1002076 73211 101 1011034 73210 102 1021512 71227 100 1001141 73210 318,318 100 1001141 53103 253,710 100 1001141 54104 100 1001856 73210 1,286,964 100 1001856 45771 101 1011861 62712 185,849 100 1001967 45771 58,271 100 1001967 53102 100 1001967 73210 15,179 100 1001968 45771 3,795 100 1001968 53102 100 1001968 73210 100 10057540 62411 100 10057100 67765 100 10057100 62360 100 10057100 71123 100 10057100 72410 4,350,000 100 1002279 54205 135,000 100 1002279 43105 100 1002279 74112 100 1002279 62764 100 1001111 62712 100 1001207 62764 102 1021207 62764 15,000 100 1002081 53102 100 10061100 62761 100 10061150 62431 100 10061710 62431 31- Aug -10 C/O C/O C/O C/O New Grant Dubuque Community School District C/O C/O C/O CIO - Shift from Police Admin Remod C /O- Prespend FY 11 C/O Purchase Order Adjustment Cox St Sale to Loras Improvements related to Cox Street C/O C/O C/O C/O - Pledges Receivable CIO - Heade Painting Receivable C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O - Paid by School District in FY 10 C/O C/O - Prespend FY11 C/O C/O IFA Loan Proceeds Developer Interest Repayments IFA Interest Repayment Developer Loans C/O C/O C/O CO - John Gronen C/O - Every Child/Every Promise C/O C/O FISCAL YEAR 2011 AMENDMENT #2 ('1'1'l (OIUN('l1. Department Housing & Conn Housing & Comr Housing & Conn Housing & Comr Housing & Comr Housing & Comr Housing & Comr Housing & Conn Housing & Comr Housing & Comr Housing & Conn Housing & Comr Housing & Comr Housing & Comr Housing & Comr Housing & Comr Housing & Comr Housing & Comr Planning Service Planning Service Planning Service Planning Service Planning Service, Planning Service, Planning Service, Planning Service Planning Service. City Mgr- Person City Manager City Manager City Manager City Manager City Manager City Manager City Manager City Manager City Manager City Manager City Manager City Manager City Manager City Manager City Manager City Manager City Manager Program Description 5 Shelter Plus Care Grant - Federal Grants Receivable 5 Bridges Out of Poverty - Program Fees 5 Bridges Out of Poverty - Seasonal Employees 5C Maint of Vacant/Abandoned - Property Maintenance 5C Maint of Vacant/Abandoned - Property Maintenance 5C Housing Trust - IA Finance - Grants 5C Historic Preservation Revolving Loan 5C Historic Preservation Revolving Loans 5C Homeless Prevention Grant - Federal Stimulus Grant 5C NBHD Stabilization Grant - State Grant 5C NBHD Stabilization Grant - Land Acquisition with Improv. 5C IFA Our Home Grant - Grants 5C IFA Our Home Grant - Iowa Finance Authority 5C IFA Housing Trust - Grants 5C IFA Housing Trust - Iowa Finance Authority 5C IFA I -Jobs Affordable Housing Assist - Grants 5C IFA I -Jobs Affordable Housing Assist - Ia Finance Authority 5C Homeownership Grants - Target 5C Historic District Improvements - Construction 5C Historic District Improvements - Construction 5C Annexation Study/Implementation- Consultant Services 5C Riverfront 2000 Plan - Consulting Engineers 5 City Planning - Full -time employees 5 City Planning - Social Security 5 City Planning - IPERS 5 City Planning - Health Insurance 5 City Planning - Life Insurance 6 Personnel - Travel - Conferences 6 Administration - Conferences 4 Arts and Cultural Affairs Office - Consultant Services 4 Arts and Cultural Affairs - ICCG Grant 4 Arts and Cultural Affairs - Part -time Wages 4 Arts and Cultural Affairs - Social Security 4 Arts and Cultural Affairs - IPERS 4C Art Museum CAT Grant 4C Art Museum CAT Grant - Pay to Other Agency 5C Neighborhood Grants 6C GIS Implementation - Consultant Services 6C GIS Implementation - Software 6C RAGBRAI - Pay to Other Agency 6C RAGBRAI - General Reimbursement - Chamber 6C Consultant Services - Lyle Sumek 6C GIS Enhancements - Peripherals, Computer 6C City of Dbq 175th Birthday 6C Americas River Fest Equip FY 11 Expense Amount 5,263 830 23,045 151,717 200,000 313,680 250,000 157,250 234,700 350,610 46,575 121,143 35,002 2,333 (16,246) (1,243) (1,129) (2,610) (33) 248 (381) 3,263 11,363 869 790 10,000 2,079 11,127 4,500 25,000 40,664 3,124 7,032 14,587 Page 6 FY 11 Revenue Amount Fund 8,816 100 4,000 100 100 101 100 100 200,000 100 100 373,222 100 372,513 100 100 100 250,000 100 100 157,250 100 100 240,000 100 101 100 102 102 102 100 100 100 100 100 100 100 100 13,021 100 100 100 100 10,000 100 100 100 100 100 101 14,329 101 100 102 100 100 Activity/CIP 10061915 10061920 10061920 1011002 1001002 1001021 1001247 1001247 1002175 1002180 1002180 1002269 1002269 1002270 1002270 1002271 1002271 1011595 1001010 1021010 1021012 1021015 10062700 10062700 10062700 10062700 10062700 10072700 10072700 10072500 10072500 10072500 10072500 10072500 1002275 1002275 1001238 1001070 1001070 1012278 1012278 10072100 1021946 1001948 1002050 Account 44170 51950 61030 73210 73210 62765 54210 62764 44175 45771 73111 62765 45703 62765 45703 62765 45703 62765 62711 73210 62716 62712 61010 61320 61310 61410 61416 62310 62310 62761 45701 61020 61320 61310 45671 62761 62765 62716 71123 62761 53620 62716 71120 62734 72115 31- Aug -10 Explanation C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O New Grant Appropriation New Grant Appropriation New Grant Appropriation New Grant Appropriation New Grant Appropriation New Grant Appropriation 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 C/O C/O - Prespend FY I 1 C/O New Grant Grant Appropriation Grant Appropriation Grant Appropriation New Grant Grant Appropriation C/O C/O C/O Shift from Police Remodel Reimb from Chamber for Police & Fire C/O - 2008 & 2009 Goal Setting C/O C/O C/O FISCAL YEAR 2011 AMENDMENT #2 CITY COI 'NCI I. Department Program Description City Manager 6C GIS Training City Manager 6C Generation Green EPA Grant City Manager 6C Electric PILOT Program Power Fund Grant City Manager 6C Electric PILOT Program Power Fund Grant City Manager 6C Electric PILOT Program Power Fund Grant City Clerk 6 City Clerk - Code Supplements Information Sery 6C Internet, Micros & Printer - DRA Distribution Information Sery 6C Internet, Micros & Printer - DRA Distribution Information Sery 6C Multi- Function Copier - Copier Machine Purchase of Sery 0 Pay to Other Agency - NE IA Community College Purchase of Sery 0 Pay to Other Agency - Every Child Every Promise Purchase of Sery 0 Pay to Other Agency - Burlington Trailways TOTAL GENERAL FUND TRANSIT FUND Transit Division 8C Transit Division 8 Transit Division 8 Transit Division 8 Transit Division 8C Transit Division 8 Transit Division 8 Transit Division 8 Transit Division 8C Transit Division 8 Transit Division 8 Transit Division 8 Transit Division 8 Transit Division 8C Transit Division 8C ROAD USE TAX FUND Engineering Engineering Engineering Intermodel Feasibility Study - FTA Capital Transit Admin - FTA Capital Transit Minibus - FTA Capital - ED RTA Amount Transit Minibus - FTA Capital - ED RTA Amount Intermodel Feasibility Study - State Grants Transit Minibus - FTA Capital - ED RTA Amount Transit Admin - Advertising Revenue Bus Operations - Promotion (Estate $) Intermodel Feasibility Study - Consultant Services Transit Minibus - Contract Custodial Bus Operations - Pay to Other Agency Bus Operations - Pay to Other Agency Bus Maintenance - Security Cameras Exterior Keyline Windows - Construction Keyline Facility Improvements - Construction TOTAL TRANSIT FUND GREATER DOWNTOWN TIF - TIF FUND Economic Devloi 5C Downtown Rehab Consultant - Financial Consultant TOTAL GREATER DOWNTOWN TIF - TIF FUND DOWNTOWN LOAN POOL - TIF FUND Economic Devlol 5C Loan Pool, Downtown TIF - Loans Economic Devloi 5C Downtown Rehab Grant Program TOTAL DOWNTOWN LOAN POOL -TIF FUND 2C NW Arterial Capacity Imp - State Grant - ICAAP 2C Traffic Signal Coordination - Consulting Engineers 2C NW Arterial Capacity Improvements - Consulting Engineers FY 11 Expense Amount 12,100 14,386 (2,000) (4,575) 5,000 (61,254) (35,000) 5,000 25,000 5,600 13,432,889 5,410 450,000 6,540 34,000 17,000 16,000 2,000 13,000 543,950 25,000 25,000 317,733 29,889 347,622 66,681 48,490 Page 7 FY 11 Revenue Amount Fund Activity /CIP Account 100 1002165 62360 100 1002182 62731 100 1002272 62716 100 1002272 62761 1,325,000 100 1002272 45701 100 10073100 62120 102 1021069 71124 20,000 102 1021069 46205 100 1002057 71116 100 10079450 62761 100 10079450 62761 100 10079195 62761 13,614,174 150,000 879,668 102,434 44,000 300,000 (44,000) (51,048) 1,381,054 600 6001614 44150 600 60053100 44150 600 60053500 44150 600 60053500 44150 600 6001614 45701 600 60053500 51715 600 60053100 51730 600 60053400 62140 600 6001614 62716 600 60053400 62733 600 60053400 62761 600 60053400 62761 600 60053700 72417 600 6001217 73210 600 6002045 73210 240 2402157 62721 CIO 241 2411033 241 2411942 448,086 250 2501814 250 2501228 250 2501814 62764 CIO 62765 C/O 45701 C/O 62712 CIO 62712 C/O Explanation C/O C/O C/O - Prespend FYI 1 C/O - Prespend FYI 1 C/O Increased cost in code updates C/O - Prespend FY11 C/O - County Cancel Purchase Order Budget C/O - NE IA Community College C/O - Every Child Every Promise CIO - Burlington Trailways C/O C/O - FTA C/O - FTA Shift from Contract Revenue C/O Shift to FTA Reduce to Estimated C/O C/O Custodial Svcs for Minibuses ECIA Sprinter Van Match Match on FTA 2.5 Buses C/O C/O C/O 31- Aug -10 FISCAL YEAR 2011 AMENDMENT #2 ('IT1 ('OI' \CII. Department Engineering Engineering Engineering Engineering Engineering Public Works Information Sery Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Public Works Engineering Engineering Engineering Engineering COMMUNITY Housing & Comr Housing & Comr Planning Service. Planning Service Planning Service. Planning Service Planning Service, Housing & Comr Recreation Divis Economic Devel( Economic Devel( Housing & Comr Housing & Comr Housing & Comr Program Description 2C Traffic Consultant Sery - Consulting Engineers 2C Traffic Consultant Sery - Consulting Engineers 2C Signalization Program -Eng Division Sery 2C LED Re -Lamp Schedule - Eng. Division Services 2C Brunskill Rd Bridge Repl - Eng Division Sery 2C Snow & Ice Control Camera - Projector /Camera 6C Internet, Micros & Printer - Road Use Tax Fund 2C Traffic Signal Coordination - Right of Way Acquisition 2C Fiber Optic Conduit Project - Construction 2C NW Arterial Capacity Improvements - Construction 2C NW Arterial Capacity Improvements - Construction 2C NW Arterial Capacity Improvements - Construction 2C NW Arterial Capacity Improvements - Construction 2C NW Arterial Capacity Improvements - Construction 2C Traffic Signal Video Detection - Construction 2C LED Re -Lamp Schedule - Construction 2C Brunskill Rd Bridge Repl - Construction 2C Railroad Cross Improvement - Construction 2C Stone Retaining Walls - Construction Not Building 2C Railroad Signal Line - Construction 2C Traffic Controller Battery Pack - Equipment Acquisition 2C Traffic Controller Replacement - Equip Acquisition TOTAL ROAD USE TAX FUND SPECIAL ASSESSMENT FUND 2C Special Assessments - Sidewalk Liens 2C Special Assessments - Principal Payments 2C Special Assessments - Interest Payments TOTAL SPECIAL ASSESSMENT FUND DEVELOPMENT BLOCK GRANT FUND 5 CDBG Admin/Monitoring -CD Block Grant Receivable 5 CDBG Admin/Monitoring -CD Block Grant Receivable 5 City Planning - Full -time employees 5 City Planning - IPERS 5 City Planning - Social Security 5 City Planning - Health Insurance 5 City Planning - Life Insurance 5 Housing Rehab Sery & Staff - Software License Exp 4 CD Target Area Prog - Pay to Other Agency 5C Commercial/Industrial Rehab Loan - CDBG 5C Commercial/Industrial Rehab Loan - CDBG 5C Lead Paint Abatement Program - Loans 5C Rental Rehab - Loans 5C First Time Homebuyer Program -Loans FY11 Expense Amount (97,611) (117,383) 3,519 3,000 48,089 1,609 18,624 44,316 91,158 97,611 42,919 70,000 59,236 448,086 5,822 33,810 128,000 107,475 4,574 45,000 (1,500) 72,008 1,223,533 16,550 1,129 1,243 2,610 33 5,878 8,076 72,535 108,218 40,653 40,000 43,136 Page 8 FY 11 Revenue Amount 448,086 15,673 786,450 71,359 873,482 Fund Activity/CIP Account Explanation 250 2501815 62712 Shift to NW Arterial Capacity Improv 250 2501815 62712 C /O- PrespendFYll 250 2501011 62811 250 2501916 62811 250 2501077 62811 250 2502183 71118 250 2501069 71124 250 2501228 73113 250 2501017 73211 250 2501814 73211 250 2501814 73211 250 2501814 73211 250 2501814 73211 250 2501814 73211 250 2501816 73211 250 2501916 73211 250 2501077 73211 250 2502026 73211 250 2501029 73211 250 2502143 73211 250 2501229 73410 250 2501274 73410 255 25510255 255 25510255 255 25510255 510,543 260 26061800 44205 107,824 260 26061800 44205 260 26062700 61010 260 26062700 61310 260 26062700 61320 260 26062700 61410 260 26062700 61416 260 26061300 62663 260 26034500 62761 260 2601235 62764 260 2601746 62764 260 2601232 62764 260 2601233 62764 260 2601234 62764 31- Aug -10 C/O C/O C/O C/O C/O C/O C/O Shift from Traffic Consultant Sery Shift from City Hall to Locust Improv Shift from Signalization Program C/O C/O C/O C/O C/O C/O C/O C/O C /O- Prespend FY 11 C/O 51911 C/0 Special Assessment Revenue 52101 C/O Special Assessment Revenue 52102 CIO Special Assessment Revenue C/O CDBG Funds Increased FY11 CDBG Allocation CDBG Amend #1 CDBG Amend #1 CDBG Amend #1 CDBG Amend #1 CDBG Amend #1 CIO CDBG Funds C/O CDBG Funds C/O CDBG Funds C/0 CDBG Funds C/O CDBG Funds C/0 CDBG Funds C/0 CDBG Funds FISCAL YEAR 2011 AMENDMENT #2 ('1'1'1 ('OUNCI1. Department Housing & Comr City Manager Housing & Comr City Manager Building Service; Housing & Comr Housing & Comr Engineering COMMUNITY Housing & Comr Housing & Comr Engineering UDAG FUND Economic Devlol Economic Devloj Economic Devlol LEAD PAINT GRANT FUND Housing & Comr Housing & Comr Housing & Comr SECTION 8 VOUCHER FUND Housing & Comr Housing & Comr CABLE TV FUND Cable TV 6 Information Sery 6C Cable TV 6 Cable TV 6 Information Sery 6C Program Description 5C Historic Preservation Rehab Grant -Loans 5C Neighborhood Grants 5 Housing Rehab Sery & Staff - Software 4 Neighborhood Development - Computer 6C Kephart Building Improvement - Construction 5C Homeownership Rehab Program -Loans 5C Purchase/Resale/Rehab - Construction 2C Accessible Curb Ramps - Construction TOTAL CDBG FUND DEVELOPMENT BLOCK GRANT - RECOVERY FUND 5 CDBG -R Admin/Monitoring-CD Block Grant 5 CDBG -R Admin/Monitoring -CD Block Employee Expense 2C Green Alley Pilot Project TOTAL CDBG -R FUND 5C Airport Revenue Guarantee - Pay to Other Agency 5C Job Creation - Loans 5C Historic Preservation - Revolving Loans TOTAL UDAG FUND STATE RENTAL REHAB FUND Housing & Comr 5 LHAP Grant - Loans TOTAL STATE RENTAL REHAB FUND 5 Lead Paint Abatement Program -HUD Lead Paint Grant 5 Lead Paint Abatement Program - General Reimbursements 5 Lead Paint Abatement Program - Grants TOTAL LEAD PAINT GRANT FUND 5 Section 8 Voucher - Software 5 Section 8 Voucher - Micro Computer TOTAL SECTION 8 VOUCHER FUND Cable TV Administration - Software Internet, Micros & Printer - Cable TV Cable TV Administration - Servers Cable TV Administration - Desks /Chairs Structured Wiring Update TOTAL CABLE TV FUND FY 11 Expense Amount 34,459 25,867 6,877 2,700 76,259 93,318 52,842 11,830 644,213 1,108 91,182 92,290 150,000 21,480 59,097 230,577 18,958 18,958 (76,069) (76,069) 69,585 3,797 73,382 15,880 2,837 4,585 2,000 4,700 30,002 Page 9 FY 11 Revenue Amount 618,367 95,794 61,751 Fund Activity/CIP Account 260 2601237 62764 260 2601238 62765 260 26061300 71123 260 26072800 71124 260 2601976 73210 260 2601065 73210 260 2601231 73210 260 2601236 73211 95,794 262 26261800 262 26261800 262 2622044 265 2651796 62761 C/0 265 2651246 62764 C/0 265 2651247 62764 C/O 270 27061320 62764 C/0 49,687 275 27561200 12,064 275 27561200 275 27561200 280 28061600 71123 C/O 280 28061600 71124 C/0 290 29075100 71123 290 2901069 71124 290 29075100 71125 290 29075100 71211 290 2902167 73210 Explanation C/0 CDBG Funds C/0 CDBG Funds C/O CDBG Funds C/O -CDBG Funds CDBG Amend #1 C/0 CDBG Funds C/0 CDBG Funds CIO CDBG Funds 44175 CDBG -R Funds 61010 CDBG -R Funds 73211 CDBG -R Funds 44310 C/O 53605 FY II Actual Reimbursements 62765 C/0 - Prespend FY11 C/O C/O CIO C/O C/O 31- Aug -10 FISCAL YEAR 2011 AMENDMENT #2 ('ITN COI \ Cll. Department Program Description STREET CONSTRUCTION FUND Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Public Works Public Works Engineering Engineering Engineering Engineering Engineering Engineering 2C Southwest Arterial -STP Funding 2C Southwest Arterial - DOT/Federal Highway Sec 330 2C Southwest Arterial - Federal Stimulus State Pass Thru Grant 2C US 61/151 Corridor - State Grants 2C US 52 /Central Traffic Improvements - EECBG Grant 2C White Water Creek Bridge - State Grant 2C Bridge Repairs/Maintenance - IDOT Funding 2C HWY 52 Resurfacing - State Highway Assistance 2C Locust - 9th to 17th St - DMATS Funding 2C Cedar Cross Reconstruction - State Highway Assistance 2C Traffic Signal Operations Center -State Pass -Thru Grant 2C US 61/151 Corridor - Federal Pass Thru Grant 2C NW Arterial Capacity Imp - Federal Pass Thru Grant 2C NW Arterial Capacity Imp - Federal Pass Thru Grant - USTEP 2C Kaufmann Ave Resurfacing - Fed Pass thru State Grant 2C Southwest Arterial -County Match 2C White Water Creek Bridge - Private Participant 2C FY 2008 Annual St Program- Private Participant Loras College 2C US 61/151 Corridor - Consulting Engineers 2C NW Arterial Capacity Imp - Consulting Engineers 2C Southwest Arterial - Consulting Eng 2C Main St Sidewalk Impr - Consulting 2C N Cascade Road Reconstruction - Consulting Engineers 2C Sub - Divisions Subdrains - Consulting Engineers 2C Special Assessment Assist 2C Fiber Optic Conduit - Misc - Engineering Division Services 2C US 52 /Central Traffic Improvements - Eng Division Services 2C US 52 /Central Traffic Improvements - Eng Division Services 2C Main St Sidewalk lmpr - Eng Division Services 2C Cedar Cross Reconstruction - Eng. Division Services 2C Kaufmann Ave Resurfacing - Engineering Division Services 2C Sunset Ridge Reconstruction - Engineering Division Services 2C US 52 /Central Traffic Improvements - Traffic Equipment 2C US 52 /Central Traffic Improvements - Traffic Equipment 2C US 52 /Central Traffic Improvements - Traffic Equipment 2C Cedar Cross Reconstruction - Land Acquisition 2C Concrete Section Repair - Construction Not Building 2C Curb Ramp Program - Construction Not Building 2C Street Light Replacement - Construction 2C Signal Intersect Reconstruct - Construction 2C Traffic Signal Fiber Optic Net - Construction 2C US 61/151 Corridor - Const. Contr Not Building 2C NW Arterial Capacity Imp - Const. Contr Not Building 2C Fiber Optic Conduit - Misc - Construction FY 11 Expense Amount 115,403 163,140 (1,661,006) 1,278 49,507 28,125 30,000 5,000 5,296 7,910 71,878 26,427 3,377 16,546 73,426 100,000 105,000 300,000 1,313 437 14,487 (42,026) 16,335 780,000 1,000,000 25,000 Page 10 FY 11 Revenue Amount 3,946,090 950,000 10,566 400,000 500,000 85,250 31,000 1,895 92,204 280,000 6,232 354,545 1,000,000 110,000 480,000 194,085 10,000 13,756 Fund Activity/CIP Account Explanation 300 3001287 44145 300 3001287 44170 300 3001287 44176 300 3002028 45701 300 3002274 45701 300 3001634 45701 300 3001258 45725 300 3002025 45725 300 3002068 45725 300 3002139 45725 300 3001852 45771 300 3002028 45771 300 3002029 45771 300 3002029 45771 300 3002140 45771 300 3001287 46205 300 3001634 53102 300 3001953 53102 300 3002028 62712 300 3002029 62712 300 3001287 62712 300 3001633 62712 300 3002021 62712 300 3002023 62712 300 3001256 62761 300 3002144 62811 300 3002274 62811 300 3002274 62811 300 3001633 62811 300 3002139 62811 300 3002140 62811 300 3002141 62811 300 3002274 71411 300 3002274 71411 300 3002274 71411 300 3002139 73111 300 3001006 73211 300 3001227 73211 300 3001549 73211 300 3001615 73211 300 3001631 73211 300 3002028 73211 300 3002029 73211 300 3002144 73211 31- Aug -10 C/O C/O C/O C/O New Grant C/O State Share of 3rd St Overpass C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O C /O- Prespend FYI1 C/O C/O C/O C/O C/O C/O -Shift from FY10 Traffic Sig Mastei C/O -Shift from FY10 Traffic Sig Mastei C/O C/O C/O C/O C/O -Shift from FY10 Traffic Sig Inter Shift from Traffic Signal Interconnect Shift from Traffic Signal Masterarm C/O C/O C/O C/O C /O- Prespend FY 11 C/O C/O C/O C/O FISCAL YEAR 2011 AMENDMENT #2 ('I'l'l ('01 NCI l Department Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering SALES TAX FUN Engineering Parks Division Parks Division Parks Division Engineering Engineering Parks Division Civic Center Div Civic Center Div Civic Center Div Civic Center Div Civic Center Div Civic Center Div Parks Division Parks Division Civic Center Div Engineering Engineering Building Service! Program Description 2C US 52 /Central Traffic Improvements - Construction 2C Traffic Signal Interconnect - Construction Not Building 2C US 52 /Central Traffic Improvements - Construction 2C US 52 /Central Traffic Improvements - Construction 2C Traffic Signal Mastarm Rep. - Construction 2C US 52 /Central Traffic Improvements - Construction 2C US 52 /Central Traffic Improvements - Construction 2C Pennsylvania at Radford Intersection Signal - Construction 2C US 52 /Central Traffic Improvements - Construction 2C Guardrail Replacement - Construction 2C Brunskill Rd Bridge Repl - Construction 2C Bridge Repairs/Maintenance - Construction 2C Bridge Repairs/Maintenance - Construction 2C Main St Sidewalk Impr - Construction 2C White Water Creek Bridge - Construction 2C Sub - Divisions Subdrains - Construction Not Building 2C Locust - 9th to 17th St - Construction Not Building 2C Kaufmann Ave Resurfacing - Construction Not Building 2C Street Const General - Construction Not Building 2C Signalization Program - Equipment Acquisition 2C Signalization Program - Equipment Acquisition 2C Traffic Signal Operations Center - Contract 2C Traffic Signal Operations Center - Contract TOTAL STREET CONSTRUCTION FUND D (20 %) 2C Transient Docks - Main Channel - Big Tier Grant 4C Renovate Park Sidewalks - Consulting Engineers 4C EPP Replace Walkway - Consulting Engineers 4C Grand River Center Level Floors 2C Riverfront Leasehold Improvements - Consultant Services 2C Sidewalk Financial Assist - Pay to Other Agency 4C Grand River Center Chairs 4C Replace Portable Chairs 4C Replace Tables 4C Pipe & Drain - Misc Equip 4C Floor Scrubber - Misc Equip 4C Espresso Machine & Kiosk - Concession Equip 4C Meeting Room AV Equip - Video Equip 4C Grand River Center Level Floors 4C GRC - Paint Meeting Rooms - Const Cont Bldg 4C Step & Aisle Lighting - Construction 2C Accessibility Barriers - Construction 2C Federal Building Renovation - Construction 6C City Hall Annex Maintenance - Construction FY 11 FY 11 Expense Revenue Amount Amount Fund Activity/CIP Account Explanation 500,000 300 (100,000) 300 12,544 300 24,771 300 (105,000) 300 262,092 300 100,000 300 (60,000) 300 60,000 300 28,408 300 94,555 300 31,000 300 10,314 300 394,120 300 135,280 300 173,360 300 (115,337) 300 515,384 300 (60,293) 300 73,830 300 (70,000) 300 (42,919) 300 60,148 300 3,159,110 8,465,623 700 7,000 2,000 (835) 12,451 16,437 90,231 31,500 24,310 25,000 21,250 24,440 22,000 20,000 12,562 23,458 37,663 19,897 Page 11 3,037,802 350 350 350 350 350 350 350 350 350 350 350 350 350 350 350 350 350 350 350 31- Aug -10 3002274 73211 New Grant Appropriation 3001266 73211 Shift to US 52 /Central Traffic Improv 3002274 73211 C/O -Shift from FY10 Traffic Sig Mastei 3002274 73211 C/O -Shift from FY10 Traffic Sig Mastei 3001133 73211 Shift to US 52 /Central Traffic Improv 3002274 73211 C/O -Shift from FY10 Derby Grange Int( 3002274 73211 C/O -Shift from Rockdale Corridor Stud} 3002256 73211 Shift to US 52 /Central Traffic Improv 3002274 73211 Shift from Penn. At Radford Intersect 3001027 73211 CIO 3001077 73211 C/O 3001258 73211 State Share of 3rd St Overpass 3001258 73211 CIO 3001633 73211 C/O 3001634 73211 C/O 3002023 73211 CIO 3002068 73211 C /O -FYI1 Prespend 3002140 73211 C/O 3002142 73211 C /O- Prespend FY1 l 3001011 73410 CIO 3001011 73410 Shift to NW Arterial Capacity Improv 3001852 73510 Shift to NW Arterial Capacity Improv 3001852 73510 C/O 3501861 3501438 3501453 3501991 3501053 3501727 3501990 3501998 3502115 3502263 3502265 3502262 3502264 3501991 3502109 3501887 3501034 3501841 3501757 44170 62712 62712 62712 62716 62761 71212 71212 71213 71550 71550 72310 72416 73210 73210 73210 73210 73210 73210 C/O C/0 C/0 C/O C/O C/O C/O C/O C/O C/O C/0 C/O C/O C/O C/O C/O C/O C/0 C/O FISCAL YEAR 2011 AMENDMENT #2 ('ITV COUNCIL Department Program Description Parks Division 4C Parks Division 4C Parks Division 4C Public Works 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Parks Division 4C Engineering 2C Public Works 2C Engineering Economic Devlol Building Service; Economic Devloj Economic Devloj Economic Devloi Economic Devloj Economic Devloi Engineering Engineering Economic Devloi Economic Devloi Renovate Park Sidewalks - Const Contr - Not Bldg EPP Replace Walkway - Const Cont - Not Bldg Pet Park Terminal Street - Construction Cold Storage Building Mezz - Construction Not Building Curb /Catch Basin Replacement - Construction Sidewalk Program City Owned Steps, Railings and Fencing - Construction Not Building Decorative Concrete Maint - Construction Cooper Place Wall - Construction Stone Retaining Walls - Construction Not Building Rehab Railroad Tracks Ice Harbor Maintenance/Dredging Transient Docks - Main Channel - Construction Playground Improvements - Equip. Acquisition Streetscape/Plaza Amenity - Equip Acquisition Port Amenities Maint TOTAL SALES TAX FUND GENERAL CONSTRUCTION FUND Engineering 2C Millworking District Street - TIGER Grant Building Service: 6C 2C 5C 6C 5C 5C 5C 5C 5C 2C 2C 5C 5C AIRPORT CONSTRUCTION FUND Airport Departmi Airport Departim Airport Departmi Airport Departim Airport Departmi Airport Departmi Airport Departim Airport Departim Airport Departmi 18th Street Building Improvement - CHC Stimulus Grant Millworking District Streetscape - Iowa Great Places Industrial Site Development - North Siegert - RISE Grant Kephart Building Improvement - General Reimbursements DICW - Synergy Court - Consulting Engineers DICW - Wildflowers - Consulting Engineers Millwork District Parking Imp - Consulting Engineers Downtown Housing Incentive- Pay to Other Agency DICW - Purchase former Tri -State Bldg - IDOT Contract Port of Dubuque Parking Ramp - Construction Millworking District Street - Construction Industrial Site Development - North Siegert - Construction DICW - Wildflowers - Landscaping Contract TOTAL GENERAL CONSTRUCTION FUND 2C Pavement Condition Index -FAA Funds 2C Runway Safety Area -FAA Funds 2C Terminal - Land Acquisition - FAA Funds 2C Terminal - RW 31 Parallel -FAA Funds 2C Terminal - Sche /Site Design -FAA Funds 2C Terminal Sitework - FAA Funds 2C Terminal Utility Improvements - FAA Funds 2C Terminal Water Reservoir - FAA Funds 2C Terminal - Sche /Site Design -State Grants FY 11 Expense Amount 6,536 57,524 101,000 20,297 (42,867) (83,079) (1,986) 182,122 146,803 19,280 79,507 123,764 3,149,409 15,192 18,197 3,837 4,185,600 5,220 10,000 (29,701) 2,465,000 282,752 175,318 5,082,095 870,764 154,970 9,016,418 Page 12 FY 11 Revenue Amount 3,037,802 5,600,000 180,000 134,668 285,002 6,500 6,206,170 Fund 350 350 350 350 350 350 350 350 350 350 350 350 350 350 350 350 360 360 360 360 360 360 360 360 360 360 360 360 360 360 Activity/CIP 3501438 3501453 3501978 3502037 3501041 3501425 3501432 3501630 3502088 3501029 3501465 3501466 3501861 3501048 3501273 3502038 3602137 3601976 3602136 3601943 3601976 3601687 3602158 3602250 3602267 3602159 3601957 3602137 3601943 3602158 Account 73211 73211 73211 73211 73211 73211 73211 73211 73211 73211 73211 73211 73211 73410 73410 73510 44175 44175 45701 45741 53620 62712 62712 62712 62761 73113 73211 73211 73211 73310 28,500 390 3901060 44105 C/O 97,344 390 3901788 44105 C/O 257,071 390 3901795 44105 C/O 2,551,795 390 3901891 44105 C/O 511,087 390 3901892 44105 C/O 228,380 390 3902009 44105 C/O 309,510 390 3902010 44105 C/O 72,580 390 3902011 44105 C/O 347,327 390 3901892 45701 CIO C/O New Grant C/O C/O C/O Alliant Rebate C/O C/O C/O PrespendFY11 C/O C/O C/O C/O C/O Includes Bergfeld Trail C/O 31- Aug -10 Explanation C/O C/O C/O C/O C /O- Prespend FY 11 C /O- Prespend FY 11 C /O- Prespend FY 11 C/O C/O C/O C/O C/O C/O C/O plus $5,000 from CIP #3501427 C/O C/O FISCAL YEAR 2011 AMENDMENT #2 CI'I'1 COU'NCI1. 31- Aug -10 FY 11 FY 11 Expense Revenue Department Program Description Amount Amount Fund Activity /CIP Account Explanation Airport Departmc 2C Terminal Utility Improvements - State Grants 16,290 390 3902010 45701 C/O Airport Departmc 2C Pavement Condition Index - Consultant Engineers 30,000 390 3901060 62712 C/0 Airport Departmc 2C Terminal - RW 31 Parallel - Consulting Engineers 248,100 390 3901891 62712 C/O Airport Depart/tic 2C Terminal - Sche /Site Design - Consulting Engineers 407,865 390 3901892 62712 C/0 Airport Departim 2C Extend Gen? Aviation Ramp - Consulting Engineers 5,000 390 3901893 62712 C/0 Airport Departmc 2C Asphalt Parking Lots - Consulting Engineers 7,356 390 3902007 62712 C/0 Airport Departmc 2C Terminal Sitework - Consulting Engineers 240,400 390 3902009 62712 C/0 Airport Departmc 2C Terminal Utility Improvements - Consulting Engineers 325,800 390 3902010 62712 C/O Airport Departmc 2C Terminal Water Reservoir - Consulting Engineers 76,400 390 3902011 62712 C/0 Airport Departmc 2C Terminal - Land Acquisition - Relocations 213,998 390 3901795 73112 C/0 Airport Departmc 2C Hangar Repair - Construction 355 390 3902276 73210 C/O -Shift from Replace Carpet Airport Departmc 2C Hangar Repair - Construction 552,135 390 3902276 73210 Actual Bid on Hangar Replacement Airport Departmc 2C Hangar Repair - Engineering 37,065 390 3902276 62712 Actual Bid on Hangar Replacement Airport Departmc 2C Hangar Repair - Insurance Claim 599,975 390 3902276 53610 Actual Insurance Reimbursement Airport Departmc 2C Runway Safety Area - Construction 52,666 390 3901788 73210 C/0 Airport Departmc 2C FBO Hanger Heating System - Construction 14,543 390 3902123 73210 C/0 Airport Departmc 2C Iowa Hanger Heater Replacement - Construction 1,377 390 3902124 73210 C/O Airport Departmc 2C Paint Hangar Exteriors - Construction 8,040 390 3902125 73210 C/0 Airport Departmc 2C Terminal Boiler Replacement - Construction 1,669 390 3902126 73210 C/0 Airport Deparpnc 2C Chlorine System Update - Construction 14,027 390 3902127 73210 C/O Airport Departmc 2C New T -Hanger Ramp - Construction 12,000 390 3901690 73211 C/0 Airport Departmc 2C Terminal - RW 31 Parallel - Construction 2,438,000 390 3901891 73211 C/O Airport Departmt 2C Extend Gen? Aviation Ramp - Construction 49,000 390 3901893 73211 C/0 Airport Departmc 2C Asphalt Parking Lots - Construction Not Building 64,063 390 3902007 73211 C/0 Airport Departmc 2C Airport Runway Painting - Construction 2,568 390 3902128 73211 C/O TOTAL AIRPORT CONSTRUCTION FUND 4,802,427 5,019,859 DEBT SERVICE FUND Debt Service 0 GO Bond Proceeds 2,500,000 440 44010440 54210 C/O TOTAL DEBT SERVICE FUND 2,500,000 WATER OPERATING FUND Water Departmer 7 Water Debt Service - Principle Payment Water Departmei 7 Water Debt Service - Interest Payment TOTAL WATER OPERATING FUND 30,908 60,066 90,974 Page 13 640 64042100 74111 Increase Debt Service 640 64042100 74112 Increase Debt Service REFUSE FUND Public Works 8 Recycling - DMASWA Grants 10,265 670 67054530 46110 C/O Public Works 8 Refuse Collection - Printing and Binding 1,782 670 67054500 62090 C/O Public Works 8 Yard Waste - Printing and Binding 500 670 67054510 62090 C/O Public Works 8 Recycling - Printing and Binding 528 670 67054530 62090 C/O Public Works 8 Refuse Collection - Legal Notices and Ads 400 670 67054500 62130 C/O Public Works 8 Yard Waste - Legal Notices and Ads 686 670 67054510 62130 C/O Public Works 8 Recycling - Legal Notices and Ads 2,000 670 67054530 62130 CIO Public Works 8 Refuse Collection - Promotion 1,783 670 67054500 62140 CIO FISCAL YEAR 2011 AMENDMENT #2 ('I'l'l COI \ClI. Department Public Works Public Works Public Works Public Works Public Works Public Works Program Description 8 Yard Waste - Promotion 8 8 8 8 8C AMERICA'S RIVER PROJECT FUND Engineering Public Works Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Water Pollution ( Engineering Water Pollution ( Water Pollution Water Pollution ( Engineering Engineering Water Pollution ( Public Works Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering City Manager Recycling - Promotion Refuse Collection - Misc Service Refuse Collection - Carts Recycling - Recycling Container Dual Packer Recycle Vehicles TOTAL REFUSE FUND 8C Shot Tower Restoration - Federal Grant 2C Heritage Trail - Principal Route - Consultant Services 8C Shot Tower Restoration - Consultant 8C Art in Port of Dubuque - Consultant Services 8C Shot Tower Restoration - Engineering Division Services TOTAL AMERICA'S RIVER PROJECT FUND SANITARY SEWER CONSTRUCTION FUND Engineering 8C North Fork Sanitary Sewer Improvements - FEMA Public Assist 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C Catfish Inter Recon - State Grant Sanitary Sewer Internal Main - Private Participant Annexation Study / Implementation - GO Bond Proceeds Sewer Extensions New Development - GO Bond Proceeds Annexation Middle Road - GO Bond Proceeds Sunset Ridge Sanitary Sewer - GO Bond Proceeds Southfork Interceptor - GO Bond Proceeds Historic Millwork - Sanitary Sewer - GO Bond Proceeds WPC Plant Facility Study - SRF Bond Proceeds Catfish Inter Recon - SRF Bond Proceeds Perry St Pumping Upgrades - Consulting Engineers Terminal St Sluice Grates - Consulting Engineers Standby Generator Catfish - Consulting Engineers Sunset Ridge Sanitary Sewer - Consulting Engineers Southfork Interceptor - Consulting Engineers WPC Plant Facility Study - Consultant Services Sanitary Sewer Root Foam - Miscellaneous Services Sewer Conn Asst - Low/Mod - Miscellaneous Services Lateral Repl Asst. Low Inc - Pay to Other Agency Lateral Repl Asst. Low Inc - Eng. Division Services Sewer Lateral Assistance - Eng Division Services Hwy 20 Annexation Sanitary Sewers - Eng Division Sery Annexation Middle Road - Eng Division Services Monroe St Sanitary Sewer - Engineering Division Services Century Sewer Manholes - Engineering Laurel St Sanitary Sewer - Eng Division Services GIS Enhancements - Peripherals, Computer FY 11 Expense Amount 1,350 1,556 2,000 32,500 6,114 363,499 414,698 (16,954) (126,456) 200,034 25,623 82,247 8,500 5,000 10,000 121,577 44,462 11,848,340 947 34,717 25,000 19,951 41,948 20,326 56,594 942 4,000 30,827 5,291 Page 14 FY 11 Revenue Amount 10,265 Fund 670 670 670 670 670 670 173,694 700 700 700 700 700 173,694 974,089 191,425 92,683 1,498,000 212,420 433,000 68,000 125,000 110,000 12,058,360 310,350 710 710 710 710 710 710 710 710 710 710 710 710 710 710 710 710 710 710 710 710 710 710 710 710 710 710 710 710 Activity/CIP 67054510 67054530 67054500 67054500 67054530 6701533 7001854 7001028 7001854 7001853 7001854 7102178 7101802 7101293 7101012 7101350 7101641 7101801 7101899 7102129 7101837 7101802 7102212 7102034 7102149 7101801 7101899 7101837 7101341 7101067 7101297 7101297 7101309 7101336 7101641 7101797 7101905 7102130 7101946 Account 62140 62140 62731 71221 72818 73410 Explanation C/O C/O C/O C/O C/O C/O 31- Aug -10 44170 C/O 62716 Purchase Order Budget Canceled 62716 Purchase Order Adjustment 62731 C/O 62811 C/O 44405 45701 53102 54210 54210 54210 54210 54210 54210 54230 54230 62712 62712 62712 62712 62712 62716 62731 62731 62761 62811 62811 62811 62811 62811 62811 62811 71120 C/O C/O C/O C/O C/O C/O C/0 C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O FISCAL YEAR 2011 AMENDMENT #2 CITI COUNCIL I1. Department Program Information Sery 8C Water Pollution ( 8C Water Pollution ( 8C Water Pollution ( 8C Water Pollution ( 8C Water Pollution ( 8C Water Pollution ( 8C Engineering 8C Engineering 8C Engineering 8C Engineering 8C Engineering 8C Engineering 8C Engineering 8C Engineering 8C Engineering 8C Engineering 8C Engineering 8C Engineering 8C Engineering 8C Engineering 8C Engineering 8C Engineering 8C Engineering 8C Engineering 8C Engineering 8C Engineering 8C Engineering 8C Water Pollution ( 8C Water Pollution ( 8C Public Works 8C Public Works 8C Engineering 8C Engineering 8C Engineering 8C Engineering 8C Engineering 8C Description Internet, Micros & Printer - Sewer Fund Scada System Upgrade - Construction - Not Building 02 Plant Mixers/Repair - Construction Not Building Standby Generator - Term St - Construction Standby Generator - Term St - Construction Switch Gear Pumping Station - Construction Contract Standby Generator Catfish - Construction Contract Annexation Study / Implementation - Construction Not Bldg 1 &I Reduction Program - Construction Not Bldg Sewer Lateral Assistance - Construction Not Bldg Cox Street Sanitary Sewer - Construction Alley Washington- Jackson Sewer - Construction Loras/Walnut to Prairie St Sewer - Construction Hwy 20 Annexation Sanitary Sewers - Construction Sewer Extensions New Development - Const Not Bldg Sewer Clearing/Grubbing - Const. Sanitary Sewer Lining Program - Const Not Bldg Street Program/Related - Const Not Bldg Annexation Middle Road - Construction Not Bldg Monroe St Sanitary Sewer - Construction Sunset Ridge Sanitary Sewer - Construction Catfish Inter Recon - Construction Not Building Southfork Interceptor - Const Cont - Not Bldg Century Sewer Manholes - Construction Four Mounds Septic Replacement - Const Not Bldg Historic Millwork - Sanitary Sewer - Const Not Bldg Laurel St Sanitary Sewer - Const Not Bldg Sanitary Utility Relocate - 10th and Central Ramp - Const Pumping Station Telemetry - Equipment Acquisition 02 Plant Mixers/Repair - Equipment Acquisition Sewer Pipeline Inspection Equipment - Equipment PW Fleet GPS Project - Pager/Radio Equipment Sanitary Sewer Internal Main - Construction Lateral Repl Asst. Low Inc - Const Cont Supp Rockdale Road Sanitary Sewer - Construction Laterals - I &I Reduction - Construction Sewer Extensions New Development - Construction Supp TOTAL SANITARY SEWER CONST FUND STORM WATER CONSTRUCTION FUND Engineering 8C Keyway Channel & Culvert Imp - State Stimulus Grant Engineering 8C Bee Branch Alignment - GO Bond Proceeds Engineering 8C Bee Branch Alignment - GO Bond Proceeds Engineering 8C Millwork District Storm Sewer - GO Bond Proceeds Engineering 8C Bee Branch Alignment - State Revolving Loan Funds FY 11 Expense Amount 3,339 34,923 14,000 6,519 61,000 13,283 120,000 1,748,913 43,280 25,216 62,000 130,000 54,572 401,116 181,291 11,504 (1,324) 290,415 376,000 6,005 450,000 100,000 125,000 15,000 42,148 82,763 206,000 13,427 55,000 135,114 (15,523) 3,194 584,307 15,000 167,447 18,771 172,131 18,030,253 Page 15 FY 11 Revenue Amount 16,073,327 183,402 2,850,000 1,408,426 115,250 5,588,521 Fund Activity/CIP Account 710 7101069 71124 710 7101339 73211 710 7101931 73211 710 7102035 73211 710 7102035 73211 710 7102036 73211 710 7102149 73211 710 7101012 73211 710 7101294 73211 710 7101309 73211 710 7101326 73211 710 7101327 73211 710 7101328 73211 710 7101336 73211 710 7101350 73211 710 7101636 73211 710 7101637 73211 710 7101638 73211 710 7101641 73211 710 7101797 73211 710 7101801 73211 710 7101802 73211 710 7101899 73211 710 7101905 73211 710 7102014 73211 710 7102129 73211 710 7102130 73211 710 7102261 73211 710 7101930 73410 710 7101931 73410 710 7101840 73410 710 7101935 73410 710 7101293 73510 710 7101297 73510 710 7101307 73510 710 7101320 73510 710 7101350 73510 720 7201662 45790 720 7201654 54210 720 7201654 54210 720 7202131 54210 720 7201654 54230 31- Aug -10 Explanation C/O C/O C/O C/O C/O - Shift from Centrifuge scroll C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O Prespend FYI 1 C/O C/O C/O C/O C/O C/O C/O C/O - Lower Bee Branch Bridges C/O - Property Acquisitions C/O C/O FISCAL YEAR 2011 AMENDMENT #2 CITY (01 \CI1. 31- Aug -10 FY 11 FY 11 Expense Revenue Department Program Description Amount Amount Fund Activity /CIP Account Explanation Engineering 8C Bee Branch Alignment - State Revolving Loan Funds 2,341,436 720 7201654 54230 Increased Cost for Dredging Public Works 2C Flood Control Levee Certification - Consulting Engineers (10,103) 720 7202155 62712 C/O - Prespend FY 11 Engineering 8C Stormwater System Assessment 275,596 720 7202015 62712 C/0 Engineering 8C Hillcrest/Keyway Storm Sewer - Consulting Engineers 4,300 720 7202016 62712 C/0 Engineering 8C NPDES Program - Consultant Services 6,135 720 7201355 62716 C/0 Engineering 8C Bee Branch Alignment - Engineering Division (404,000) 720 7201654 62811 Shift to Property Acquisitions Engineering 8C Storm Sewer Cleaning - Eng. Division Serv. 67,347 720 7201659 62811 C/0 Engineering 8C Amy Ct Storm Sewer Impry - Eng. Division Services 1,800 720 7201666 62811 C/0 Engineering 8C 32nd & Grandview Storm Improvements - Eng Division Service 38,378 720 7201808 62811 C/0 Engineering 8C Villa St Storm Sewer Proj - Eng Division Services 11,579 720 7201809 62811 C/0 Engineering 8C NPDES - Public Education - Eng. Division Services 3,143 720 7202066 62811 C/0 Engineering 8C NPDES - Public Participation - Eng. Division Services 13,207 720 7202067 62811 C/0 Engineering 8C Iowa Street Storm Sewer - Engineering 3,500 720 7202132 62811 C/0 Engineering 8C Kane Kaufman Storm Sewer - Engineering 21,000 720 7202133 62811 C/0 Engineering 8C Peru Road Storm Sewer - Engineering 3,000 720 7202133 62811 C/0 Public Works 8C GIS Mobile Mapping - Pager/Radio Equipment 161 720 7202043 72410 C/0 Engineering 8C Bee Branch Alignment - Right -of -Way Acquisition 404,000 720 7201654 73113 Shift from Engineering Division Engineering 8C Bee Branch Alignment - Right -of -Way Acquisition 1,075,500 720 7201654 73113 Increased Cost for 151/61 Property Engineering 8C Bee Branch Alignment - Right -of -Way Acquisition 975,017 720 7201654 73113 C/0 Engineering 8C Stormwater Ditch Remediation 40,117 720 7201004 73211 C/0 Engineering 8C Catch Basin/Westside - Construction Not Building 56,504 720 7201081 73211 C/0 Engineering 8C Streambank Rehab - Construction 32,729 720 7201352 73211 C/0 Engineering 8C W 32nd Street Detention Basin - Construction 1,002 720 7201357 73211 C/0 Engineering 8C Gunite Rock Stormsewer - Construction 112,942 720 7201363 73211 C/0 Engineering 8C Bee Branch Alignment - Construction 2,341,436 720 7201654 73211 Increased Cost for Dredging Engineering 8C Bee Branch Alignment - Construction 7,748,169 720 7201654 73211 C/0 Engineering 8C Storm Sewer Cleaning - Construction 114,917 720 7201659 73211 C/0 Engineering 8C Amy Ct Storm Sewer Improv - Construction 12,000 720 7201666 73211 C/0 Engineering 8C Villa St Storm Sewer Proj - Construction 95,000 720 7201809 73211 C/0 Engineering 8C Hillcrest/Keyway Storm Sewer - Construction 30,000 720 7202016 73211 C/0 Engineering 8C Millwork District Storm Sewer - Construction 114,829 720 7202131 73211 C/0 Engineering 8C Iowa Street Storm Sewer - Construction 35,509 720 7202132 73211 C/O Engineering 8C Kane Kaufman Storm Sewer - Construction 148,382 720 7202133 73211 C/0 Engineering 8C Peru Road Storm Sewer - Construction 10,486 720 7202133 73211 C/0 Public Works 8C Sewer Pipeline Inspection Equipment - Equipment 6,871 720 7201840 73410 C/0 Engineering 8C Detention Basin Maintenance - Construction Cont Supplem 6,874 720 7201359 73510 C/0 TOTAL STORM WATER CONST FUND 13,397,327 12,487,035 PARKING CONSTRUCTION FUND Parking Division 8C 10th/Central Parking Ramp - EDA Grant 1,500,000 730 7302179 44115 C/0 Parking Division 8C Major Maintenance on Ramps - Architectural Serv. 14,405 730 7301385 62711 C/0 Parking Division 8C Parking Ramp Occ Cert - Consulting Engineers 16,250 730 7302046 62712 C/0 Parking Division 8C 7th St Pedestrian Walkway - Consulting Engineers 10,000 730 7302163 62712 C/0 Parking Division 8C Seal Coating Parking Lots - Consultant Services 13,451 730 7301380 62716 C/0 Parking Division 8C POD Ramp Special Expenses - Consultant Services 522 730 7302260 62716 C/0 Page 16 FISCAL YEAR 2011 AMENDMENT #2 (11'1 CO1'NCI1 Department Program City Manager Information Sery Parking Division Parking Division Parking Division Parking Division Parking Division Parking Division Water Departmet Water Departmet Water Departmet Water Departmet Water Departmet Water Departmet Water Departmei Water Departmei Water Departmet Water Departmei Water Departmet Water Departmet Water Departmet Water Departmet Water Departmet Water Departmei Water Departmet Water Departmet Water Departmet Water Departmet Water Departmei City Manager Water Departmet Water Departmei Water Departmet Water Departmet Water Departmet Water Departmet Water Departmet City Manager Information Sery Information Sery Water Departmei Water Departmei 8C 8C 8C 8C 8C 8C 8C 8C WATER CONSTRUCTIO 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C 8C Description GIS Enhancements - Peripherals, Computer Internet, Micros & Printer - Parking Fund Major Maintenance on Ramps - Construction 10th/Central Parking Ramp - Construction 10th /Central Parking Ramp - Construction 10th/Central Ramp -Fire Headquarters - Construction Seal Coating Parking Lots - Construction Contract Port of Dubuque Ramp Maint - Construction Not Building TOTAL PARKING CONSTRUCTION FUND N FUND ADA Improvements -Water Plant - Water Rev Bond Proceeds Water Main Replacements - Water Revenue Bond Proceeds Water Main Replacements - Water Revenue Bond Proceeds Shallow Well Rehab - Water Revenue Bond Proceeds Roosevelt Rd. Main Ext. - Water Revenue Bond Proceeds Annexation Study/Implementation - Water Rev Bond Proceeds Vacuum Filter Back -Up - Water Revenue Bond Proceeds Warehouse Dist Water Main - Water Revenue Bond Proceeds Annexation Study - Phase II - Water Revenue Bond Proceeds Annexation Study - Phase II - Water Revenue Bond Proceeds Drinking Water Study - Water Revenue Bond Proceeds Fluoride Tank Upgrade - Water Revenue Bond Proceeds Ramp Water Utility Relocate - Water Revenue Bond Proceeds Water Conservation - Water Revenue Bond Proceeds Water Meter Replacement Program - SRF GO Bond Proceeds GIS Maintenance/Upgrade - Consulting Engineers Water Main Extension /Annexation Related - Consult Eng Roosevelt Rd. Main Ext. - Consult Eng Drinking Water Study - Consulting Engineers GIS Maintenance/Upgrade - Consulting Services Service Line Assistance - Misc Services GIS Implementation Service Line Assistance - Consulting Engineers Water Internal Lines/Loan - Eng. Division Services Water Main Extension /Annexation Related -Eng. Division Annexation Study/Implementation - Eng Division Warehouse Dist Water Main - Eng Division Services Warehouse Dist Water Main - Construction Not Building Annexation Study - Phase II - Eng Division Services GIS Enhancements - Peripherals, Computer Internet, Micros & Printer - Water Fund Internet, Micros & Printer - Water Fund ADA Improvements -Water Plant - Construction Chlorine Sample Stations - Construction FY 11 Expense Amount 5,291 11,178 67,810 10,710 9,086,557 542,452 190,993 145,846 10,115,465 45,853 5,500 8,668 45,000 470 64,412 2,503 2,500 20,000 41,976 65,500 16,575 198,925 45,000 2,841 2,000 42,785 66,090 2,469 Page 17 FY 11 Revenue Amount 1,500,000 30,000 599,780 155,000 200,220 25,000 655,000 28,000 215,500 200,000 100,000 45,000 63,540 150,000 500,000 1,527,194 Fund Activity/CIP Account 730 7301946 71120 730 7301069 71124 730 7301385 73210 730 7302179 73210 730 7302179 73210 730 7302266 73210 730 7301380 73211 730 7302162 73211 740 7401402 54210 740 7401405 54210 740 7401405 54210 740 7401415 54210 740 7401672 54210 740 7401954 54210 740 7402030 54210 740 7402052 54210 740 7402146 54210 740 7402146 54210 740 7402147 54210 740 7402148 54210 740 7402261 54210 740 74010740 54210 740 7402052 54230 740 7401389 62712 740 7401411 62712 740 7401672 62712 740 7402147 62712 740 7401389 62716 740 7401390 62731 740 7401070 62731 740 7401390 62811 740 7401398 62811 740 7401411 62811 740 7401954 62811 740 7402052 62811 740 7402052 62811 740 7402146 62811 740 7401946 71120 740 7401069 71122 740 7401069 71124 740 7401402 73210 740 7401832 73210 Explanation C/O C/O C/O C/O C/O C/O C/O C/O C/O Additional Borrowing C/O Additional Borrowing C/O C/O C/O Additional Borrowing C/O Additional Borrowing Additional Borrowing Additional Borrowing Additional Borrowing Additional Borrowing C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O C/O 31- Aug -10 FISCAL YEAR 2011 AMENDMENT #2 ('Il'l ('Ol \CIL Water Departmei Water Departmei Water Departmei Water Departmei Water Departmei Water Departmei Water Departmei Water Departmei Water Departmei Water Departmei Water Departmei Water Departmei Department Program Description 8C Water Service Repair - Grants 8C Fluoride Tank Upgrade - Construction 8C Water Internal Lines/Loan - Construction 8C Water Main Extensions - Construction 8C Water Main Extension/Annexation Related - Construction 8C Roosevelt Rd. Main Ext. - Construction 8C Annexation Study/Implementation - Construction 8C Vacuum Filter Back -Up - Construction 8C Olympic Heights Pump Station - Construction 8C Water Meter Replacement Program - Const Not Building 8C Annexation Study - Phase 11- Construction Not Building 8C Ramp Water Utility Relocate - Const Not Bldg TOTAL WATER CONSTRUCTION FUND GARAGE SERVICE FUND Information Sery LANDFILL FUND Information Sery 8C Public Works 2 TRANSFERS Parks Division Parks Division Civic Center Div Civic Center Div Civic Center Div Civic Center Div Recreation Divis Recreation Divis Water Departmei Water Departmei Water Pollution ( Water Pollution ( Parking Division Parking Division Airport Departim Airport Departim Airport Departim 8C Internet, Micros & Printer - Garage Service Fund TOTAL GARAGE SERVICE FUND FY 2010 Encumbrance Carry Over's - Continuing Appropriation Authority Trans(] Trans01 Trans02 Trans02 Trans03 Trans03 Trans04 Trans04 Trans05 Trans05 Trans06 Trans06 Trans07 Trans07 Trans08 Trans08 Trans09 Internet, Micros & Printer - Landfill Fund Landfill - Recycling Containers TOTAL LANDFILL FUND GRAND TOTAL AMENDMENT #2 Transfer from General Fund to Sales Tax Construction Transfer from General Fund to Sales Tax Construction Transfer from General Fund to Sales Tax Construction Transfer from General Fund to Sales Tax Construction Transfer from DRA Distrib. Fund to Sales Tax Const. Fund Transfer from DRA Distrib. Fund to Sales Tax Const. Fund Golf Activities(Profit) -Trans General Fd to Golf Constr Golf Activities(Profit) -Trans General Fd to Golf Constr Transfer from Water Operating to Water Construction Transfer from Water Operating to Water Construction Transfer from WPC Operating to WPC Construction Transfer from WPC Operating to WPC Construction Transfer from Parking Operating to Parking Construction Transfer from Parking Operating to Parking Construction Transfer from PFC Fund to Airport Construction Fund Transfer from PFC Fund to Airport Construction Fund Transfer from PFC Fund to Airport Construction Fund FY 11 Expense Amount (400) 63,540 240,504 58,607 503,052 12,751 589,500 2,895 18,558 (330,150) 255,000 (282,487) 1,810,437 7,011 7,011 500 940 9401069 71124 CIO 2,325 940 94054200 72818 C/O 2,825 - 20,990,780 102,691,919 77,060,717 Transfer Out 3,000 Page 18 FY 11 Revenue Amount 4,494,234 Transfer In Fund Activity/CIP Account 740 7401832 73210 740 7402148 73210 740 7401398 73211 740 7401399 73211 740 7401411 73211 740 7401672 73211 740 7401954 73211 740 7402030 73211 740 7402031 73211 740 7402052 73211 740 7402146 73211 740 7402261 73211 810 8101069 71124 C/O 100 10010100 91350 3,000 350 3501978 59100 8,336 100 10010100 91350 8,336 350 3501998 59100 11,518 102 10210102 91350 11,518 350 3501998 59102 49,499 100 10010100 91370 49,499 370 37010370 59100 (464,150) 640 64010640 91740 (464,150) 740 74010740 59640 500,000 610 61010610 91710 500,000 710 71010710 59610 550,000 630 63010630 91730 550,000 730 73010730 59630 1,500 390 3901060 59391 1,500 391 39110391 91390 17,939 390 3901788 59391 Explanation C/O -Pre spend FY11 C/O C/O C/O C/O C/O C/O C/O C/O C/O - Prespend FY11 C/O C/O - Prespend FY 11 Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds 31- Aug -10 FISCAL YEAR 2011 AMENDMENT #2 ('1'1'1 COUNCIL Department Airport Departmc Airport Departmc Airport Departmc Airport Departmc Airport Departmc Airport Departmc Airport Departmc Airport Departing Airport Departmc Airport Departmc Airport Departmc Airport Departmc Airport Departing Airport Departmc Airport Departing Airport Departmc Airport Departmc Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Program Trans09 Transl0 Trans 10 Trans]] Transll Trans 12 Transl2 Transl3 Trans 13 Transl4 Transl4 Transl5 Transl5 Transl6 Transl6 Trans 17 Transll Transl8 Transl8 Transl9 Transl9 Trans20 Trans20 Trans2l Transll Trans22 Trans22 Trans23 Trans23 Trans24 Trans24 Trans25 Trans25 Trans26 Trans26 Trans27 Trans27 Trans28 Trans28 Trans29 Trans29 Trans30 Trans30 Trans3l Trans31 Description Transfer from PFC Fund to Airport Construction Fund Transfer from PFC Fund to Airport Construction Fund Transfer from PFC Fund to Airport Construction Fund Transfer from PFC Fund to Airport Construction Fund Transfer from PFC Fund to Airport Construction Fund Transfer from DRA Dist Fund to Airport Construction Fund Transfer from DRA Dist Fund to Airport Construction Fund Transfer From Sales Tax 20% Fd to Airport Const. Fund Transfer From Sales Tax 20% Fd to Airport Const. Fund Transfer from PFC Fund to Airport Construction Fund Transfer from PFC Fund to Airport Construction Fund Transfer from PFC Fund to Airport Construction Fund Transfer from PFC Fund to Airport Construction Fund Transfer From Sales Tax 20% Fd to Airport Const. Fund Transfer From Sales Tax 20% Fd to Airport Const. Fund Transfer From General Fd to Customer Facility Charge Fund Transfer From General Fd to Customer Facility Charge Fund Transfer from DRA Gaming Fund to Sanitary Sewer Fund Transfer from DRA Gaming Fund to Sanitary Sewer Fund Transfer from Spec. Assessment Fd to Sewer Const Fund Transfer from Spec. Assessment Fd to Sewer Const Fund Transfer from Spec. Assessment Fd to Sewer Const Fund Transfer from Spec. Assessment Fd to Sewer Const Fund Transfer from Spec. Assessment Fd to Sewer Const Fund Transfer from Spec. Assessment Fd to Sewer Const Fund Transfer from Spec. Assessment Fd to Sewer Const Fund Transfer from Spec. Assessment Fd to Sewer Const Fund Transfer from Spec. Assessment Fd to Sewer Const Fund Transfer from Spec. Assessment Fd to Sewer Const Fund Transfer from Spec. Assessment Fund to Stormwater Fund Transfer from Spec. Assessment Fund to Stormwater Fund Transfer From Sales Tax 20% Fd to Stormwater Const. Fund Transfer From Sales Tax 20% Fd to Stormwater Const. Fund Transfer From Street Const Fd to Road Use Tax Fund Transfer From Street Const Fd to Road Use Tax Fund Transfer From Street Const Fd to Road Use Tax Fund Transfer From Street Const Fd to Road Use Tax Fund Transfer from General Fund to Street Const Fund Transfer from General Fund to Street Const Fund Transfer from General Fund to Street Const Fund Transfer from General Fund to Street Const Fund Transfer from General Fund to America's River Fund Transfer from General Fund to America's River Fund Transfer from Special Assessment Fund to General Fund Transfer from Special Assessment Fund to General Fund FY 11 Expense Amount 17,939 134,305 21,876 54,000 21,462 12,020 3,820 14,027 17,436 28,498 60,000 124,000 58,042 531,246 110,000 3,026 13,800 42,919 70,000 17,840 100,000 194,041 26,565 Page 19 FY 11 Revenue Amount Fund Activity/CIP Account Explanation 391 39110391 91390 Trans Funds 134,305 390 3901891 59391 Trans Funds 391 39110391 91390 Trans Funds 21,876 390 3901892 59391 Trans Funds 391 39110391 91390 Trans Funds 102 10210102 91390 Trans Funds 54,000 390 3901893 59102 Trans Funds 350 35010350 91390 Trans Funds 21,462 390 3902007 59350 Trans Funds 12,020 390 3902009 59391 Trans Funds 391 39110391 91390 Trans Funds 3,820 390 3902011 59391 Trans Funds 391 39110391 91390 Trans Funds 350 35010350 91390 Trans Funds 14,027 390 3902127 59350 Trans Funds 100 10010100 91252 Trans Funds 17,436 252 25251400 59100 Trans Funds 28,498 710 7101067 59101 Trans Funds 101 10110101 91710 Trans Funds 255 25510255 91710 Trans Funds 60,000 710 7101307 59255 Trans Funds 255 25510255 91710 Trans Funds 124,000 710 7101336 59255 Trans Funds 255 25510255 91710 Trans Funds 58,042 710 7101638 59255 Trans Funds 255 25510255 91710 Trans Funds 531,246 710 7101801 59255 Trans Funds 255 25510255 91710 Trans Funds 110,000 710 7102130 59255 Trans Funds 255 25510255 91720 Trans Funds 3,026 720 7201359 59255 Trans Funds 350 35010350 91720 Trans Funds 13,800 720 7201666 59350 Trans Funds 42,919 250 2501814 59300 Trans Funds 300 30010300 91250 Trans Funds 70,000 250 2501814 59300 Trans Funds 300 30010300 91250 Trans Funds 17,840 300 3002274 59101 Trans Funds 101 10110101 91300 Trans Funds 100,000 300 3002274 59100 Trans Funds 100 10010100 91300 Trans Funds 194,041 700 7001853 59100 Trans Funds 100 10010100 91700 Trans Funds 255 25510255 91100 Trans Funds 26,565 100 1001108 59255 Trans Funds 31- Aug -10 FISCAL YEAR 2011 AMENDMENT #2 ('I'I'l ('Ol \CIL Department Engineering Engineering Engineering Engineering Engineering Engineering Economic Devloi Economic Devlo] Economic Devloj Economic Devloi City Mgr - Person City Mgr - Person Program Description Trans32 Transfer from Spec. Assessment Fund to Street Const. Fund Trans32 Transfer from Spec. Assessment Fund to Street Const. Fund Trans33 Transfer from Spec. Assessment Fund to Street Const. Fund Trans33 Transfer from Spec. Assessment Fund to Street Const. Fund Trans34 Transfer from DRA Distrib. Fund to Sales Tax Const. Fund Trans34 Transfer from DRA Distrib. Fund to Sales Tax Const. Fund Trans35 Trans35 Trans36 Trans36 Trans37 Trans37 Transfer from DICW to General Construction Fund Transfer from DICW to General Construction Fund Transfer from Bond Proceeds to General Construction Fund Transfer from Bond Proceeds to General Construction Fund Transfer from CDBG to General Fund Transfer from CDBG to General Fund TOTAL TRANSFERS FY 11 Expense Amount 471,000 FY 11 Revenue Amount Fund 255 471,000 300 318,053 255 318,053 300 186,417 102 186,417 350 282,752 240 282,752 360 2,500,000 360 2,500,000 440 (485) 260 (485) 100 6,094,302 6,094,302 GRAND TOTAL WITH TRANSFERS 108,786,221 83,155,019 Page 20 Activity/CIP 25510255 3001633 25510255 3001972 10210102 3501861 24060240 3602159 3602267 44010440 26061700 10072700 Account 91300 59255 91300 59255 91350 59102 91360 59240 59440 91360 91100 59260 Explanation Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds Trans Funds 31- Aug -10