The URL can be used to link to this page

Fiscal Year 2012 Second Budget AmendmentMasterpiece on the Mississippi March 23, 2012 TO: The Honorable Mayor and City Council Members FROM: Michael C. Van Milligen, City Manager SUBJECT: Fiscal Year 2012 Second Budget Amendment Dubuque bierd All-America City 1 2007 Budget Director Jennifer Larson is recommending the second Fiscal Year 2012 Budget Amendment be set for public hearing for April 16, 2012. I concur with the recommendation and respectfully request Mayor and City Council approval. Michael C. Van Milligen MCVM /jml Attachment cc: Barry Lindahl, City Attorney Cindy Steinhauser, Assistant City Manager Jennifer Larson, Budget Director Masterpiece on the Mississippi March 23, 2012 TO: Michael C. Van Milligen, City Manager FROM: Jennifer Larson, Budget Director SUBJECT: Fiscal Year 2012 Second Budget Amendment Dubuque bierd All-America City 1 2007 The purpose of this memorandum is to present a summary of the action items approved by City Council throughout the year subject to a future budget amendment and to set the public hearing date for the formal budget amendment process as required by Section 384.16 of the Code of Iowa. This budget amendment includes items, which have been authorized by City Council since the first amendment to the Fiscal Year 2012 budget was adopted in September 2011 and adjustments to reflect the amended Community Development Annual Plan. This amendment also reflects reappropriations of completed or canceled projects to fund increased operating and capital expenses. A reduction of interfund transfers of $969,942 is also included. The amendment totals $4,948,164 in decreased appropriation authority and a decrease in resources of $1,437,447. Additional revenues added in this amendment with offsetting appropriations are: • Iowa Resource Enhancement and Protection Grant ($200,000) for EB Lyons Expansion, • AmeriCorps Grant ($163,192) for AmeriCorps staff, • State Transit Assistance Infrastructure Grant ($245,000) for Transit facility roof repairs, • State of Good Repairs Grant ($8,000,000) for phase 1 of the Intermodal Facility, • General Obligation Borrowing ($4,020,000) for City match on the State of Good Repairs Grant for the Intermodal Facility, • Federal Freedom Grant ($86,475) for Transit Mobility Coordinator, • State Urban -State Traffic Engineering Program Grant ($152,347) for US 61/151 Corridor, • General Obligation Borrowing ($3,477,354) for 7th Street Improvements, • Iowa RISE Grant ($680,892) for 7th Street Improvements, • General Obligation Borrowing ($1,764,246) for the one -way to two -way traffic conversion from 9th to 11th Streets, • General Obligation Borrowing ($350,000) for Historic Millwork District Complete Streets, • State Highway Assistance ($171,379) for Central Avenue Pavement Rehabilitation, • Federal Grant ($141,859) for Dubuque County Historical Society's Railroad Depot Phase I, • Mississippi River Trail Grant ($100,000) for Bee Branch Creek Restoration Project, • National Scenic By -ways Trail Grant ($1,000,000) for Bee Branch Creek Restoration Project, • Refunding General Obligation Issuance ($1,935,000) for short -term Lower Bee Branch Creek Restoration bridges, and • National Endowment for Arts Our Town Grant ($100,000) for Historic Millwork District Arts. Reduced revenues reflected in this amendment with offsetting reductions in appropriations are: • Loan Proceeds (- $650,000) for Fire Station Expansion /Relocation due to project delay, • General Obligation Borrowing (- $2,657,000) for Water Annexation Study /Implementation due to project delay until requested, • Federal Aviation Administration Grant (- $2,441,614) for Airport Terminal Utility Improvements due to project delay, • State Aviation Administration Grant (- $127,306) for Airport Terminal Utility Improvements due to project delay, • Federal Aviation Administration Grant (- $643,842) for Airport Terminal Water Reservoir due to project no longer needed, • Federal Transit Authority Grant (- $1,270,000) for Intermodal Facility due to change in funding sources from other grants, • Federal Aid to Urban Systems (- $6,081,891) for Southwest Arterial to reflect actual funding -to -date, • State Highway Assistance (- $1,339,533) for Southwest Arterial to reflect actual funding -to -date, • Federal Pass Thru Grants (- $1,215,093) for Southwest Arterial to reflect actual funding -to -date, • County Share (- $1,888,906) for Southwest Arterial to reflect actual funding agreement, • Special Assessments (- $1,460,688) for Historic Millwork District Complete Streets to reflect actual anticipated assessments to be received, • General Obligation Borrowing (- $731,420) for New Development Sewer Extensions due to delay of project until requested, • General Obligation Borrowing (- $3,477,000) for Annexation Study /Implementation due to delay of project until requested, • State Revolving Loan Funds (- $304,286) for North Fork Sanitary Sewer Improvements to reflect actual funding, • Iowa Finance Authority Housing Trust Grants ($- 157,250) for Housing projects to reflect actual funding, • Shelter Plus Care Grant (- $436,612) for homeless prevention to reflect actual funding, • Community Development Block Grant (- $217,086) for various programs due to cut in Federal funding, • Section 8 Voucher HUD Payments (- $870,516) due to the decrease in the number of vouchers held, and • Section 8 vouchers HUD Administrative Fee (- $173,620) due to decrease in the number of vouchers held. This amendment provides for the purchase of property on South Grandview at the entrance of Murphy Park for $130,000 which funded by savings from Grand River Center project savings of $96,000 with the remainder paid by land sales. In addition, the Purina Drive Salt Operations required utility relocations for the scale house with a total cost of $115,646 which is funded by the sale of salt to bidding partners. The Police software project was reduced $600,000 and the Transit Bus Stop Improvements project was reduced $298,357 to represent the correct amount of both of these projects. 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 State law. The attached resolution authorizes the City Clerk to publish notification for a public hearing to be held April 16, 2012. Attachments JML RESOLUTION NO. 86 -12 SETTING THE DATE FOR THE PUBLIC HEARING ON AMENDMENT NO. 2 TO THE FISCAL YEAR 2012 BUDGET FOR THE CITY OF DUBUQUE Whereas, Iowa Code Section 384.16 provides that the City Council shall set a time and place for a public hearing on amendments to the budget and publish notice before the hearing as provided in Iowa Code Section 362.3. NOW THEREFORE, BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF DUBUQUE, IOWA: Section 1. That the City Council shall conduct a public hearing on proposed Amendment No. 2 to the Fiscal Year 2012 budget for the City of Dubuque at the City Council Chambers at the Historic Federal Building, 350 West 6th Street, Dubuque, Iowa, on Monday, April 16, 2012, 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 2nd day of April 2012. Attest: Kevin 'irnstahl, City Clerk Za-e, Roy D. ol, Mayor Fiscal Year 2012 Amendment #2 CITY COUNCIL Department Program Description FY 12 Expense Ain ount FY 12 Revenue Amount Fund Activity /CIP Account 3/23/12 Explanation GENERAL FUND Police Department 1C Police Department 1C Police Department 1C Police Department 1C Police Department 1C Police Department 10 Police Department 10 Police Department 10 Police Department 10 Police Department 10 Police Department 10 Police Department 10 Police Department 10 Police Department 10 Police Department 10 Fire Department 1C Fire Department 1C Fire Department 1C Fire Department 1C Fire Department 10 Health Services 30 Health Services 30 Park Division 4C Park Division 4C Park Division 4C Park Division 4C Park Division 4C Park Division 4C Park Division 4C Park Division 4C Park Division 4C Park Division 4C Park Division 4C Park Division 40 Park Division 40 Park Division 40 Park Division 40 Park Division 40 Americorps 40 Americorps 40 Americorps 40 Americorps 40 Americorps 40 Americorps 40 Americorps 40 Americorps 40 Americorps 40 Americorps 40 Police Historical Car Rehab - Private Participant Police Historical Car Rehab - Misc Revenue Police Histoncal Car Rehab - Vehicle Marnt Replace Police /CAD Software - Software Replace Police /CAD Software - County Contribution Records And Id - Tenant Background Check Police Patrol - IA Distnct Court Fines 2011 Jag Grant - Federal Grant 2011 Jag Grant - Seasonal Employees 2011 Jag Grant - Overtime Pay 2011 Jag Grant - Police Equipment Police Traffic Sery Grant - Federal Grant Police Traffic Sery Grant - Overtime Pay Police Traffic Sery Grant - Education & Training Police Traffic Sery Grant - Police Equipment Improvements To Fire Headquarters - Const Fire Station Expansion /Relocation - Consulting Fire Station Expansion /Relocation - Con struction Fire Station Expansion /Relocation - Loan Proceeds Fire Training - Video Equipment Food Inspections - Misc Revenue Food Inspections - Misc Operating Supplies EB Lyons Expansion - REAP Grant EB Lyons Expansion - Land Acquisition Urban Youth Corp Grant - Federal Grant Urban Youth Corp Grant - Seasonal Employees Urban Youth Corp Grant - Social Secunty Urban Youth Corp Grant - Uniform Purchases Urban Youth Corp Grant - Landscaping Urban Youth Corp Grant - Equipment Urban Youth Corp Grant - Consultant Services South Grandview Park Entrance - Legal South Grandview Park Entrance - Land Acq Greenhouse - Seasonal Employes Greenhouse - IPERS Greenhouse - Social Security Greenhouse - Landscaping Greenhouse - Flower Baskets Amencorp 10/11 - Federal Grant Amencorp 10/11 - Private Participant Amencorp 10/11 - Full -Time Employees Amencorp 10/11 - Seasonal Employees Amencorp 10/11 - IPERS Amencorp 10/11 - Social Secunty Amencorp 10/11 - Health Insurance Amencorp 10/11 - Workers Compensation Amencorp 10/11 - Life Insurance Amencorp 10/11 - Office Supplies 14,520 (600,000) 38,300 5,000 9,855 43,003 22,175 1,000 700 (6,500) (2,159) (603,059) 6,500 1,250 200,000 5,578 427 518 6,726 425 243 500 129,500 2,841 229 217 4,315 25,680 1,234 32,450 100 2,558 (1,136) 5,705 (1) 11,163 Page 1 of 9 12,600 100 1,920 100 100 102 (400,000) 102 100 163,620 100 57,858 100 100 100 100 23,875 100 100 100 100 101 101 101 (650,000) 101 100 1,250 100 100 200,000 100 100 13,917 100 100 100 100 100 100 100 100 100 100 100 100 100 100 47,926 100 38,017 100 100 100 100 100 100 100 100 100 1002280 1002280 1002280 1021167 1021167 10011220 10011700 10011752 10011752 10011752 10011752 10011771 10011771 10011771 10011771 1011139 1011864 1011864 1011864 10013200 10017300 10017300 1002171 1002171 1002343 1002343 1002343 1002343 1002343 1002343 1002343 1002440 1002440 10030500 10030500 10030500 10030500 10030500 10034910 10034910 10034910 10034910 10034910 10034910 10034910 10034910 10034910 10034910 53102 Increased Fundraising for Project 53605 Increased Fundraising for Project 62528 Fundraising Appropriation 71123 Adjust to Actual 53102 Adjust to Actual 62717 Increase in Landlord Participation 53403 Increase in IA District Court Fines 44125 New Grant 61030 New Grant Appropriation 61050 New Grant Appropriation 72218 New Grant Appropriation 44125 New Grant 61050 New Grant Appropriation 62360 New Grant Appropriation 72218 New Grant Appropriation 73210 Shift to Fire Training Video Equipment 62712 Cancel Project 73211 Cancel Project 54205 Cancel Project 72416 Shift from Improvements to Fire Headquarters 53605 State Radon Grant 62671 State Radon Grant Appropriation 45707 REAP Grant - Mines of Spain PropertyAcquisrtrc 73110 REAP Grant - Mines of Spain Property Acqu isrtrc 45771 New Grant 61030 New Grant Appropriation 62011 New Grant Appropriation 62011 New Grant Appropriation 62637 New Grant Appropriation 73411 New Grant Appropriation 73411 New Grant Appropriation 62713 Legal Fees Related to Grandview Property Acq 73111 Land Acquisition Related to Grandview Prop Acq 61030 Millwork Distnct /Bee Branch Summer Flowers 61310 Millwork Distnct /Bee Branch Summer Flowers 61320 Millwork Distnct /Bee Branch Summer Flowers 62637 Millwork Distnct /Bee Branch Summer Flowers 62637 Millwork Distnct /Bee Branch Summer Flowers 45771 Amend AmeriCorp Grant to Actual 53102 Amend AmeriCorp 61010 Amend AmeriCorp 61030 Amend AmeriCorp 61310 Amend AmeriCorp 61320 Amend AmeriCorp 61410 Amend AmeriCorp 61415 Amend AmeriCorp 61416 Amend AmeriCorp 62010 Amend AmeriCorp 3rant 3rant 3rant Srant 3rant 3rant Srant 3rant 3rant to Actual to Actual to Actual to Actual to Actual to Actual to Actual to Actual to Actual Department Amencorps Amencorps Amencorps Amencorps Amencorps Amencorps Amencorps Amencorps Amencorps Amencorps Amencorps Amencorps Amencorps Amencorps Amencorps Amencorps Amencorps Amencorps Amencorps Amencorps Amencorps Amencorps Amencorps Amencorps Amencorps Amencorps Amencorps Amencorps Amencorps Amencorps Amencorps Amencorps Amencorps Conf Center Operation Conf Center Operation Library Library Engineering Engineering Engineering Engineering Engineering Building Safety Economic Development Economic Development Economic Development 50 Housing & Community Dev 5C Housing & Community Dev 5C Housing & Community Dev 5C Housing & Community Dev 5C Housing & Community Dev 5C Housing & Community Dev 5C Prog 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 6C 6C 40 40 2C 2C 2C 2C 20 10 5C 5C ram Description Amencorp 10/11 - Uniform Purchases Amencorp 10/11 - Copying Amencorp 10/11 - Miscellaneous Amencorp 10/11 - Travel - Conferences Amencorp 10/11 - Travel - City Business Amencorp 10/11 - Mileage Amencorp 10/11 - Education & Training Amencorp 10/11 - Telephone Amencorp 10/11 - Background Check Amencorp Supp 10/11 - Federal Grant Amencorp Supp 10/11 - Private Participant Amencorp Supp 10/11 - Full -Time Employees Amencorp Supp 10/11 - Seasonal Employees Amencorp Supp 10/11 - IPERS Amencorp Supp 10/11 - Social Security Amencorp Supp 10/11 - Uniform Purchases Amencorp Supp 10/11 - Education & Training Amencorp Supp 10/11 - Background Check Amencorps 11/12 - Federal Grant Amencorps 11/12 - Full -Time Employees Amencorps 11/12 - Seasonal Employees Amencorps 11/12 - IPERS Amencorps 11/12 - Health Insurance Amencorps 11/12 - Workers Compensation Amencorps 11/12 - Life Insurance Amencorps 11/12 - Office Supplies Amencorps 11/12 - Uniform Purchases Amencorps 11/12 - Copying Amencorps 11/12 - Travel - Conferences Amencorps 11/12 - Mileage Amencorps 11/12 - Education & Training Amencorps 11/12 - Telephone Amencorps 11/12 - Misc Operating Expense GRC - Paint Exhibit Hall GRC - Replace Carpet Adult Services - Library Video Materials Youth Services - Library Books Recon Signals /J1k- Wacker- Federal Grant Recon Signals /J1k- Wacker- Construction Railroad Depot Phase I - Fed Pass Thru Grant Railroad Depot Phase I- Construction Engineenng Admin - Pay to Other Agency Building Service Administration - Grants IFA Downtown Housing Loan Pool - Loan Proceeds IFA Downtown Housing Loan Pool - Loans Economic Development - Pay to Other Agency Maint Of Vacant /Abandoned Buildings - Ins Claims Maint Of Vacant /Abandoned Buildings -Reimb Maint Of Vacant /Abandoned Buildings - Construction Neighborhood Stabilization Grant - Federal Grant Neighborhood Stabilization Grant - Federal Grant IFA Housing Trust - Grants FY 12 Expense Amount 443 118 1,251 42 (224) (125) (670) 226 (55) FY 12 Revenue Amount Fund Activity /CIP Account Explanation 100 10034910 62011 Amend AmeriCorp Grant to Actua 100 10034910 100 10034910 100 10034910 100 10034910 100 10034910 100 10034910 100 10034910 100 10034910 4,204 100 10034916 3,260 100 10034916 1,691 100 10034916 (2,759) 100 10034916 136 100 10034916 (81) 100 10034916 (75) 100 10034916 (111) 100 10034916 (14) 100 10034916 163,192 100 10034918 33,086 100 10034918 127,356 100 10034918 1,653 100 10034918 7,145 100 10034918 5,505 100 10034918 75 100 10034918 430 100 10034918 752 100 10034918 170 100 10034918 440 100 10034918 1,580 100 10034918 2,000 100 10034918 800 100 10034918 2,200 100 10034918 (30,000) 100 1002197 (66,000) 102 1022113 2,560 100 10036200 156 100 10036400 9,960 101 1011919 9,960 101 1011919 141,859 100 1001201 141,859 100 1001201 39,600 100 10055100 34,900 100 10057100 34,233 100 1002279 34,233 100 1002279 30,000 100 10060700 927 100 1001002 30,522 100 1001002 31,449 100 1001002 (256,090) 100 1002180 256,090 100 1002180 (157,250) 100 1002270 Page 2 of 9 62110 Amend AmeriCorp Grant to Actua 62240 Amend AmeriCorp Grant to Actua 62310 Amend AmeriCorp Grant to Actua 62320 Amend AmeriCorp Grant to Actua 62340 Amend AmeriCorp Grant to Actua 62360 Amend AmeriCorp Grant to Actua 62421 Amend AmeriCorp Grant to Actua 62717 Amend AmeriCorp Grant to Actua 45771 Amend AmeriCorp Grant to Actua 53102 Amend AmeriCorp Grant to Actua 61010 Amend AmeriCorp Grant to Actua 61030 Amend AmeriCorp Grant to Actua 61310 Amend AmeriCorp Grant to Actua 61320 Amend AmeriCorp Grant to Actua 62011 Amend AmeriCorp Grant to Actua 62360 Amend AmeriCorp Grant to Actua 62717 Amend AmeriCorp Grant to Actua 45771 Amend AmeriCorp Grant to Actua 61010 Amend AmeriCorp Grant to Actua 61030 Amend AmeriCorp Grant to Actua 61310 Amend AmeriCorp Grant to Actua 61410 Amend AmeriCorp Grant to Actua 61415 Amend AmeriCorp Grant to Actua 61416 Amend AmeriCorp Grant to Actua 62010 Amend AmeriCorp Grant to Actua 62011 Amend AmeriCorp Grant to Actua 62110 Amend AmeriCorp Grant to Actua 62310 Amend AmeriCorp Grant to Actua 62340 Amend AmeriCorp Grant to Actua 62360 Amend AmeriCorp Grant to Actua 62421 Amend AmeriCorp Grant to Actua 62661 Amend AmeriCorp Grant to Actua 73210 Shift to S Grandview Park Entrance 73210 Shift to S Grandview Park Entrance 62659 Lost Book Revenue Appropnation 62651 Lost Book Revenue Appropnation 45771 Adjust to Actual 73211 Adjust to Actual 45771 Additional Funding 73210 Additional Funding 62761 Museum Lease Low Income Rebate 62765 C/0 Alley Lighting Grant Program 54205 Adjust to Actual 62764 Adjust to Actual 62761 Hotel Julien Hotel /Motel Tax Marketing 53610 Adjust to Actual 53620 Adjust to Actual 73210 Adjust to Actual 44176 Reclassify as Federal Grant 45771 Reclassify as Federal Grant 45703 Adjust to Actual Department Housing & Community Housing & Community Housing & Community Housing & Community Housing & Community Housing & Community Housing & Community Housing & Community Housing & Community Housing & Community Housing & Community Housing & Community Housing & Community Housing & Community Housing & Community Housing & Community Housing & Community Housing & Community Housing & Community Housing & Community Housing & Community Housing & Community Housing & Community Housing & Community Housing & Community Housing & Community Housing & Community Planning Services Planning Services Planning Services Planning Services Planning Services Planning Services Planning Services Planning Services Planning Services Planning Services Planning Services Planning Services Planning Services Planning Services Planning Services Planning Services Planning Services Planning Services Planning Services Planning Services City Manager'S Office City Manager'S Office City Manager'S Office City Manager'S Office City Manager'S Office Program Description Dev 5C IFA Housing Trust - Construction Dev 50 Housing Administration - Misc Services Dev 50 Shelter Plus Care Grant - Federal Grant Dev 5O Shelter Plus Care Grant - Administration Cost Dev 50 Shelter Plus Care Grant - Housing Assistance Dev 50 Bridges Out Of Poverty- Program Fees Dev 50 Bridges Out Of Poverty - Office Supplies Dev 50 Bridges Out Of Poverty- Materials Dev 50 Bridges Out Of Poverty- Printing Dev 50 Bridges Out Of Poverty- Copying Dev 50 Bridges Out Of Poverty- Mileage Dev 50 Bridges Out Of Poverty- Education & Training Dev 50 Bridges Out Of Poverty- Rental of Space Dev 50 Bridges Out Of Poverty- Hospitality Dev 5O Bridges Out Of Poverty- Pay to Other Agency Dev 50 Getting Ahead Getting By- Seasonal Employees Dev 50 Getting Ahead Getting By- Education & Training Dev 5O Getting Ahead Getting By- Telephone Dev 50 Getting Ahead Getting By- Custodial Services Dev 50 Circles - Program Fees Dev 50 Circles - Sesaon al Employees Dev 50 Circles - Matenals Dev 50 Circles - Travel - Conferences Dev 50 Circles - Education & Training Dev 5O Circles - Telephone Dev 50 Circles - Speakers /Programs Dev 50 Circles - Contract Service 50 City Planning/Historic Preservation- Full -Time Emp 50 City Planning/Historic Preservation - Seasonal Emp 50 City Planning/Historic Preservation - IPERS 50 City Planning/Historic Preservation - Social Security 50 City Planning /Histonc Preservation - Health Ins 50 City Planning/Historic Preservation - Life Ins 50 City Planning/Historic Preservation - Office Supp 50 City Planning/Historic Preservation - Postage 50 City Planning/Historic Preservation - Equip Maint 50 City Planning/Historic Preservation - Pnnting 50 City Planning /Histonc Preservation - Legal Notices 50 City Planning/Historic Preservation - Subscriptions 50 City Planning /Histonc Preservation - Dues 50 City Planning /Histonc Preservation - General Liab 50 City Planning /Histonc Preservation - Travel- Conf 50 City Planning/Historic Preservation - Mileage 50 City Planning/Historic Preservation - Education 50 City Planning/Historic Preservation - Misc Op 50 City Planning/Historic Preservation - Pay to Other Agency 50 City Planning/Historic Preservation - Computer 60 Sustainable Comm Coord - Dues & Memberships 60 Sustainable Comm Coord - Lodging 60 Sustainable Comm Coord - Temp Help 60 Sustainable Comm Coord - Equipment 60 Greencorps - Pay to Other Agency FY 12 FY 12 Expense Revenue Amount Amount Fund Activity /CIP Account Explanation (157,250) 100 1002270 73210 Adjust to Actual 325 100 10061100 62731 C/O Class Fees (436,612) 100 10061915 44170 Adjust to Actua 4,320 100 10061915 61413 Adjust to Actua (68,959) 100 10061915 62694 Adjust to Actua (11,395) 100 10061920 51950 Adjust to Actua (4,094) 100 10061920 62010 Adjust to Actua 7 100 10061920 62031 Adjust to Actua (150) 100 10061920 62090 Adjust to Actua (20) 100 10061920 62110 Adjust to Actua (250) 100 10061920 62340 Adjust to Actua (4,590) 100 10061920 62360 Adjust to Actua (300) 100 10061920 62436 Adjust to Actua (1,115) 100 10061920 62641 Adjust to Actua (2,700) 100 10061920 62761 Adjust to Actua 6,000 100 10061921 61030 Addition of Get ing Ahead Interns (12,427) 100 10061921 62360 Adjust to Actua 15 100 10061921 62421 Adjust to Actua 357 100 10061921 62433 Adjust to Actua 10,500 100 10061922 51950 Adjust to Actua (12,529) 100 10061922 61030 Adjust to Actua 40 100 10061922 62031 Adjust to Actua 333 100 10061922 62310 Adjust to Actua (14,471) 100 10061922 62360 Adjust to Actua 90 100 10061922 62421 Adjust to Actua 1,778 100 10061922 62734 Adjust to Actua 18,000 100 10061922 62737 Adjust to Actua Contract 20,383 100 10062700 61010 CDBG Amend #2 2,200 100 10062700 61030 CDBG Amend #2 1,505 100 10062700 61310 CDBGAmend #2 1,882 100 10062700 61320 CDBGAmend #2 2,725 100 10062700 61410 CDBG Amend #2 50 100 10062700 61416 CDBG Amend #2 223 100 10062700 62010 CDBG Amend #2 1,677 100 10062700 62030 CDBGAmend #2 3,384 100 10062700 62061 CDBG Amend #2 237 100 10062700 62090 CDBG Amend #2 57 100 10062700 62130 CDBG Amend #2 519 100 10062700 62170 CDBG Amend #2 184 100 10062700 62190 CDBG Amend #2 150 100 10062700 62208 CDBG Amend #2 3,090 100 10062700 62310 CDBG Amend #2 108 100 10062700 62340 CDBG Amend #2 871 100 10062700 62360 CDBG Amend #2 216 100 10062700 62671 CDBG Amend #2 2,561 100 10062700 62761 CDBG Amend #2 1,350 100 10062700 71124 CDBGAmend #2 (10,591) 100 10072200 62190 Shift to GreenCorps Activity (704) 100 10072200 62342 Shift to GreenCorps Activity (250) 100 10072200 62732 Shift to GreenCorps Activity (2,131) 100 10072200 72515 Shift to GreenCorps Activity 13,676 100 10072600 62761 Shift from Sustainable Community Activity Page 3 of 9 Department Sustainable Comm Coord City Manager'S Office City Manager'S Office City Manager'S Office City Manager'S Office City Manager'S Office City Manager'S Office Program Description 60 Sustainable Community 40 Arts And Cultural Affairs - Federal Grant 40 Arts And Cultural Affairs - Pay to Other Agency 40 Arts And Cultural Affairs - Part-Time Employees 40 Arts And Cultural Affairs - IPERS 40 Arts And Cultural Affairs - Social Security 40 Arts And Cultural Affairs - Pay to Other Agency TOTAL GENERAL FUND TRANSIT FUND Transit Division 8C Transit Division 8C Transit Division 8C Transit Division 8C Transit Division 8C Transit Division 8C Transit Division 8C Transit Division 8C Transit Division 8C Transit Division 8C Transit Division 8C Transit Division 8C Transit Division 8C Transit Division 8C Transit Division 8C Transit Division 8C Transit Division 8C Transit Division 8C Transit Division 80 Transit Division 80 Transit Division 80 SPECIAL ASSESSMENTS FUND Engineering 2C Engineering 2C Engineering 2C COMMIINITI DEVELOPMEN Human Rights 30 Recreation Division 40 Recreation Division 40 Engineering 2C Engineering 2C Economic Development 5C Economic Development 5C Housing & Community Dev 5C Housing & Community Dev 5C Housing & Community Dev 5C Housing & Community Dev 5C Housing & Community Dev 5C Used Vehicles for Expansion - Vehicles Used Vehicles for Expansion - FTA Capital Replace Mini Buses - State Grants Replace Mini Buses - Federal Grants Transit Roof Maint /Repair- Construction Transit Roof Maint /Repair- State Grant ntermodal Facility- State of Good Repairs Grant ntermodal Facility- State Grants ntermodal Facility- GO Bond Proceeds ntermodal Facility- Consultant Services ntermodal Facility- Construction ntermodal Facility- Construction Jule Facility Improvements - Construction Jule Facility Improvents - State Grant Jule Facility Improvements - Construction Jule Facility Improvents - FTA Capital Grant Bus Stop Improvements - Construction Bus Stop Improvements - State Grant Transit Admin - FTA Freedom Grant Transit Admin - Pay to Other Agency Mini Bus Operations - Fed Pass Thru Grant TOTAL TRANSIT FUND Special Assessments - Principal Special Assessments - Principal Special Assessments - Interest TOTAL SPECIAL ASSESSMENTS FUND T BLOCK GRANT FUND Human Relations - CDBG Promotion CDBG Target Area Prog - Pay to Other Agency CDBG Senior Center - Pay to Other Agency Wheel Chair Ramps - Construction Neighborhood Related Improvements - Construction Economic Development Project - CDBG Loans Commercial /Industnal Rehab Loan -CDBG Loans Residential Rehab Program Residential Rehab Program Residential Rehab Program Rental Rehab Unit First Time Homebuyer Prog FY 12 FY 12 Expense Revenue Amount Amount Fund Activity /CIP Account Explanation 19,000 100 10072200 62761 Community GHG 50% Study 100,000 100 10072500 44170 N EA Our Town Grant for Histonc Millwork Distnc 100,000 100 10072500 62761 N EA Our Town Grant for Histonc Millwork Distnc 13,734 100 10072500 61020 Adjust to Actual 1,109 100 10072500 61310 Adjust to Actual 1,050 100 10072500 61320 Adjust to Actual (5,214) 100 10072500 62761 Shift to Arts Coordinator (302,980) (595,617) (55,816) 245,000 (1,270,000) 8,000,000 4,020,000 12,800 (81,600) (298,357) 86,475 10,658,502 600 (34,860) 600 (426,620) 600 426,620 600 600 245,000 600 8,000,000 600 (1,270,000) 600 4,020,000 600 600 600 600 600 12,800 600 600 (81,600) 600 600 (298,357) 600 86,475 600 600 (13,404) 600 10,666,054 (168) (25,401) (4,200) (35,000) (20,000) (9,730) 9,730 (26,082) 41,082 115,310 (6,720) (197,007) Page 4 of 9 (1,460,688) 255 2,585,521 255 312,402 255 1,437,235 6002236 6002236 6001222 6001222 6001613 6001613 6001614 6001614 6001614 6001614 6001614 6001614 6002045 6002045 6002045 6002045 6002235 6002235 60053100 60053100 60053500 25510255 25510255 25510255 260 26016100 260 26034500 260 26079180 260 2601236 260 2601239 260 2601235 260 2601746 260 2601065 260 2601065 260 2601065 260 2601233 260 2601234 71312 Cancel Project 44150 Cancel Project 45701 Shift to Federal Pass Thru Grant 45771 Shift from State Grants 73210 STA Infrastructure Grant Appropriation 45701 STA Infrastructure Grant 45701 State of Good Repairs Grant 45701 Adjust to Actual 54210 Adjust to Actual 62716 Adjust to Actual 73210 State of Good Repairs Grant 73210 Adjust to Actual 73210 STA Infrastructure Grant Appropriation 45701 STA Infrastructure Grant 73210 Adjust to Actual 44150 Adjust to Actual 73210 Adjust to Actual 45701 Adjust to Actual 44160 Freedom Grant - Mobility Coordinator 62761 Freedom Grant Appropriation 45771 Adjust to Actual 52101 Adjust Special Assessments to Actual 52101 Adjust Special Assessments to Actual 52102 Adjust Special Assessments to Actual 62140 CDBGAmend #2 62761 CDBGAmend #2 62761 CDBGAmend #2 73211 CDBGAmend #2 73211 CDBGAmend #2 62764 CDBGAmend #2 62764 CDBGAmend #2 62764 CDBGAmend #2 62766 CDBGAmend #2 73210 CDBGAmend #2 62764 CDBGAmend #2 62764 CDBGAmend #2 Department Program Housing & Community Dev 50 Housing & Community Dev 50 Planning Services 50 Planning Services 50 Planning Services 50 Planning Services 50 Planning Services Planning Services Planning Services Planning Services Planning Services Planning Services Planning Services Planning Services Planning Services Planning Services Planning Services Planning Services Planning Services Planning Services Planning Services Planning Services City Manager'S Office City Manager'S Office Purchase Of Services Purchase Of Services Purchase Of Services Description Rehab Program - Custodial Services CDBG Admin /Monitoring - CDBG Block Grant City Planning/Historic Preservation- Full -Time Emp City Planning/Historic Preservation - Seasonal Emp City Planning/Historic Preservation - IPERS City Planning/Historic Preservation - Social Security 50 City Planning / Histonc Preservation - Health Ins 50 City Planning/Historic Preservation - Life Ins 50 City Planning/Historic Preservation - Office Supp 50 City Planning/Historic Preservation - Postage 50 City Planning/Historic Preservation - Equip Maint 50 City Planning/Historic Preservation - Pnnting 50 City Planning / Histonc Preservation - Legal Notices 50 City Planning/Historic Preservation - Subscriptions 50 City Planning / Histonc Preservation - Dues 50 City Planning / Histonc Preservation - General Liab 50 City Planning / Histonc Preservation - Travel- Conf 50 City Planning/Historic Preservation - Mileage 50 City Planning/Historic Preservation - Education 50 City Planning/Historic Preservation - Misc Op 50 City Planning/Historic Preservation - Pay to Other Agency 50 City Planning/Historic Preservation - Computer 5C Neighborhood Grants - CDBG Grants 50 Washington Tool Library - Pay to Other Agency 30 Project Concem - Day Care - Pay to Other Agency 30 Project Concem Information /Referral - Pay to Other Agency 30 Opening Doors - Pay to Other Agency TOTAL CDBG FUND URBAN DEVELOPMENT ACTION GRANT Economic Development 5C Historic Preservation Loan - Repayments Economic Development 5C Historic Preservation Loan - Loans TOTAL UDAG FUND STATE RENTAL REHAB FUND Housing & Community Dev 5C Housing & Community Dev 5C Housing & Community Dev 5C Housing & Community Dev 50 Housing & Community Dev 50 SECTION 8 FUND Housing & Community Dev 50 Housing & Community Dev 50 Housing & Community Dev 50 LIBRARY TRUST FUND Library 40 Library 40 Residential Rehab Program - Insurance Claims Residential Rehab Program - Reimbursements Residential Rehab Program - Construction Housing LHAP Grant - Loan Interest Housing LHAP Grant - Loans TOTAL STATE RENTAL REHAB FUND Section 8 Voucher- HUD Payments Section 8 Voucher- HUD Administrative Fee Section 8 Voucher- HUD Assistance Payments TOTAL SECTION 8 FUND General Gift Trust - Promotion General Gift Trust - Miscellaneous FY 12 Expense Amount (2,349) FY 12 Revenue Amount Fund Activity /CIP Account Explanation 260 26061300 62433 CDBGAmend #2 (217,086) 260 26061800 44205 CDBGAmend #2 (20,383) 260 26062700 61010 CDBG Amend#2 (2,200) 260 26062700 61030 CDBGAmend #2 (1,505) 260 26062700 61310 CDBG Amend#2 (1,882) 260 26062700 61320 CDBGAmend #2 (2,725) 260 26062700 61410 CDBG Amend#2 (50) 260 26062700 61416 CDBG Amend#2 (223) 260 26062700 62010 CDBG Amend#2 (1,677) 260 26062700 62030 CDBG Amend#2 (3,384) 260 26062700 62061 CDBG Amend#2 (237) 260 26062700 62090 CDBG Amend#2 (57) 260 26062700 62130 CDBGAmend #2 (519) 260 26062700 62170 CDBGAmend #2 (184) 260 26062700 62190 CDBGAmend #2 (150) 260 26062700 62208 CDBGAmend #2 (3,090) 260 26062700 62310 CDBG Amend#2 (108) 260 26062700 62340 CDBG Amend#2 (871) 260 26062700 62360 CDBG Amend#2 (216) 260 26062700 62671 CDBGAmend #2 (2,561) 260 26062700 62761 CDBG Amend#2 (1,350) 260 26062700 71124 CDBG Amend#2 (3,360) 260 2601238 62765 CDBGAmend #2 (2,604) 260 26079220 62761 CDBG Amend#2 (1,527) 260 26079200 62761 CDBG Amend#2 (4,337) 260 26079210 62761 CDBG Amend#2 (1,680) 260 26079400 62761 CDBG Amend#2 (217,415) (217,086) 14,179 265 2651247 43410 Adjust to Actual 14,179 265 2651247 62764 Adjust to Actual 14,179 14,179 5,643 270 2701065 53610 Adjust to Actual 2,950 270 2701065 53620 Adjust to Actual 8,593 270 2701065 73210 Adjust to Actual 7,129 270 27061320 43105 Adjust to Actual 7,129 270 27061320 62764 Adjust to Actual 15,722 15,722 (870,156) 280 28061600 (173,620) 280 28061600 (386,472) 280 28061600 (386,472) (1,043,776) 44310 Adjust to Actual - Decrease in Vouchers 44311 Adjust to Actual - Decrease in Vouchers 62694 Adjust to Actual - Decrease in Vouchers 6,500 295 29536480 62140 Amend to actual 1,320 295 29536480 62240 Amend to actual Page 5 of 9 Department Library Library Library Library Library Program Description 40 General Gift Trust - Library Books 40 General Gift Trust - Library AudioNisual 40 General Gift Trust - Library Video Material 40 General Gift Trust - Speakers/Programs 40 Robert P Maher Trust Fund - Speakers/Programs TOTAL LIBRARY TRUST FUND STREET CONSTRUCTION FUND Engineering 2C Engineering 2C Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering 2C 2C 2C 2C 2C 2C 2C 2C 2C 2C 2C 2C 2C 2C 2C 2C 2C 2C 2C 2C SALES TAX FUND (20 °°) Building Safety 6C GENERAL CONSTRUCTION FUND Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Engineering 2C Economic Development 5C Economic Development 5C Economic Development 5C Economic Development 5C Economic Development 5C Southwest Artenal - Investment Earnings Southwest Arterial - Farm Land Rent Southwest Artenal - Fed Aid to Urban Systems Southwest Artenal - State Highway Assistance Southwest Artenal - Fed Pass Thru State Grant Southwest Artenal - County Share Southwest Arterial - Construction Southwest Arterial - Construction Southwest Arterial - Construction Southwest Arterial - Construction Southwest Arterial - Construction Southwest Arterial - Construction US 61/151 Corridor Fed Pass Thru US 61/151 Corridor Construction US 61/151 Corridor Construction Central Ave Payment Rehab - State Highway Assist Central Ave Payment Rehab - Construction St Light /Signal Knockdown - Insurance Claims St Light /Signal Knockdown - Traffic Control Equip US 52 /Central Traffic Imp - State Grants US 52 /Central Traffic Imp - Traffic Control Equip Us 52 /Central Traffic Imp - Construction TOTAL STREET CONSTRUCTION FUND City Hall Remodeling - Construction TOTAL SALES TAX FUND East 7th Street - Bond Proceeds East 7th Street - RISE Grant East 7th Street - Construction East 7th Street - Construction 2 -Way Traffic Conversoin 9th to 11th - Bond Proceeds 2 -Way Traffic Conversoin 9th to 11th - Construction Millwork District Complete Streets - Bond Proceeds Millwork District Complete Streets - Construction Millwork District Complete Streets - Bond Proceeds Millwork District Complete Streets - Construction Industiral Site Development - N Siegert - Construction DICW South Siegert Farm - Construction Downtown Housing Incentives - Interest Revenue Downtown Housing Incentives - Investment Earnings Downtown Housing Incentives - Principal Repayments FY 12 Expense Amount 17,058 864 353 9,926 7,290 43,311 FY 12 Revenue Amount Fund Activity /CIP Account Explanation 295 29536480 62651 Amend to actual 295 29536480 62652 Amend to actual 295 29536480 62659 Amend to actual 295 29536480 62734 Amend to actual 295 29536495 62734 Amend to actual 1,293 (1,888,906) 15,763 (6,081,891) (1,215,093) (1,339,533) 108,305 152,347 171,379 75,976 23,646 (108,305) (10,085,019) 1,060 300 14,703 300 (6,081,891) 300 (1,339,533) 300 (1,215,093) 300 (1,888,906) 300 300 300 300 300 300 300 152,347 300 300 300 171,379 300 300 75,976 300 300 23,646 300 300 300 (10,086,312) 3001287 43110 Bond Proceed Interest 3001287 43242 Farmland Rent 3001287 44145 Amend to actual 3001287 45725 Reduced State Highway Assistance 3001287 45771 Reduced Fed Pass Thru State Grant 3001287 46205 Reduced County Share 3001287 73211 Additional Bond Proceeds 3001287 73211 Reduced County Share 3001287 73211 Additional Interest & Farmland Rent 3001287 73211 Reduced Fed Aid to Urban Systems 3001287 73211 Reduced Fed Pass Thru State Grant 3001287 73211 Reduced State Highway Assistance 3002028 45771 Increased U -STEP Grant 3002028 73211 Shift from US52 /Central Traffic Improv 3002028 73211 Increased U -STEP Grant 3002248 45725 Increased State Highway Assistance 3002248 73211 Increased State Highway Assistance 3002252 53610 Increased Insurance Claim Reimbursement 3002252 71411 Increased Insurance Claim Reimbursement 3002274 45701 Additional State Reimbursement 3002274 71411 Additional State Reimbursement 3002274 73211 Shift to US 61/151 Corridor 125,320 350 3501045 73210 Adjust HVAC to Actual (Covered by IA Court Fin( 125,320 3,477,354 680,892 680,892 3,400,000 1,725,000 350,000 (1,460,688) (1,000,000) 1,000,000 Page 6 of 9 1,764,246 350,000 350,000 3,358 9,667 9,590 360 3602441 54210 New Project - Bond Proceeds 360 3602441 45741 New Project - RISE Grant 360 3602441 73211 New Project Appropnation 360 3602441 73211 New Project Appropriation 360 3602442 54210 New Project - Bond Proceeds 360 3602442 73211 New Project Appropnation 360 3602137 54210 Additional Bond Proceeds 360 3602137 73211 Additional Bond Proceeds 360 3602137 54210 Additional Bond Proceeds 360 3602137 73211 Adjust Special Assessments to Actual 360 3601943 73211 Shift to South Siegert Farm Development 360 3602160 73211 Shift from North Siegert Farm Development 360 3602267 43105 Adjust to Actual 360 3602267 43110 Adjust to Actual 360 3602267 43405 Adjust to Actual Department Program Description Economic Development 5C Downtown Housing Incentives - Pay to Other Agency TOTAL GENERAL CONSTRUCTION FUND AIRPORT CONSTRUCTION FUND Airport 2C Airport 2C Airport Airport Airport Airport Airport Airport Airport Airport DEBT SERVICE FUND Fire Department Fire Department 2C 2C 2C 2C 2C 2C 2C 2C Airport Termina Airport Termina Airport Termina Airport Termina Airport Termina Airport Termina Airport Termina Airport Termina Airport Termina Airport Termina Utility Improvement - FAA Funds Utility Improvement - State Grants Utility Improvement - Consulting Eng Design /Build - FAA Funds Design /Build - State Funds Design /Build - PFC Borrowng Sitework - Consulting Eng Sitework - Construction Water Reservoir - FAA funds Water Reservoir- Consulting Engineers TOTAL AIRPORT CONSTRUCTION FUND 10 Fire Debt Service - Prinicipal Payment 10 Fire Debt Service - Interest Payment TOTAL DEBT SERVICE FUND SANITARY SEWER OPERATING FUND Water & Resource Recove 80 WRRC Administration - Pay to Other Agency TOTAL SANITARY SEWER OPERATING FUND STORM WATER OPERATING FUND Engineering 80 Engineering 80 Engineering 80 Stormwater Maintenance - GO Bond Proceeds Stormwater Maintenance - Pnncipal Payment Stormwater Maintenance - Interest Payment TOTAL STORM WATER OPERATING FUND SALT OPERATIONS FUND Public Works 8C Punna Dr Barge Facility- Scale TOTAL SALT OPERATIONS FUND SANITARY SEWER CONSTRUCTION FUND Engineering 8C Forcemain Repair- Insurance Claims Engineering 8C Forcemain Repair- Construction Engineering 8C Sewer Extensions - New Development - GO Bond Engineering 8C Sewer Extensions - New Development - Construction Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering 8C Sewer Extensions - New Development - Construction 8C Sanitary Sewer Internal Main Revolving Loan - Const 8C Annexation Study /Implementation - Construction 8C Annexation Study /Implementation - GO Bond 8C Annexation Middle Road - GO Bond 8C Annexation Middle Road - Eng Div Services 8C Annexation Middle Road - Construction 8C I &I Reduction Program - Truck 8C I &I Reduction Program - Construction 8C North Fork Sanitary Sewer Improv - SRF Proceeds 8C Sep Green Alleys - Construction FY 12 Expense Amount 22,615 4,717,819 FY 12 Revenue Amount Fund Activity /CIP Account Explanation 360 3602267 62761 Adjust to Actual (2,568,920) (3,265,011) 3,265,011 (677,728) (3,246,648) (52,815) (32,185) (85,000) 6,645,107 (2,441,614) 390 (127,306) 390 390 (373,280) 390 (109,297) 390 482,577 390 390 390 (643,842) 390 390 (3,212,762) 3902010 3902010 3902010 3902213 3902213 3902213 3902009 3902009 3902011 3902011 44105 Adjust to Actua 45701 Adjust to Actua 62712 Adjust to Actua 44105 Adjust to Actua 45701 Adjust to Actua 54210 Adjust to Actua 62712 Shift to Construction 73211 Shift to Construction 44105 Adjust to Actual 62712 Adjust to Actual 400 40013800 74111 Cancel Debt Service 400 40013800 74112 Cancel Debt Service (163,155) 610 61043100 62761 Shift to SEP Green Alleys (163,155) 1,819,702 (85,324) 1,935,000 620 620 620 1,734,378 1,935,000 62055620 62055620 62055620 54210 Refunding of Short-Tenn Bndge Loan 74111 Refunding of Short-Tenn Bndge Loan 74111 Refunding of Short-Tenn Bndge Loan 115,646 680 6802320 73210 Utilities to Scale House 115,646 19,957 (666,291) (206,131) (534,373) (3,284,130) (56,594) (376,000) 35,102 (35,102) 163,155 19,957 710 710 (731,420) 710 710 710 710 710 (3,044,000) 710 (433,000) 710 710 710 710 710 (304,286) 710 710 Page 7 of 9 7102347 53610 Insurance Proceeds 7102347 73211 Insurance Proceeds 7101350 54210 Cancel Project 7101350 73211 Cancel Project 7101350 73510 Cancel Project 7101293 73510 Cancel Project 7101012 73211 Cancel Project 7101012 54210 Cancel Project 7101641 54210 Cancel Project 7101641 62811 Cancel Project 7101641 73211 Cancel Project 7101294 71315 I &I and Snow Removal Truck 7101294 73211 I &I and Snow Removal Truck 7102178 54230 Adjust SRF Loan to Actual 7102350 73211 Shift from WRRC Pay to Other Agency Department Program Description TOTAL SANITARY SEWER CONST FUND STORM WATER CONSTRUCTION FUND Engineering 8C Bee Branch Creek - Trail Grant Engineering 8C Bee Branch Creek - Trail Grant Engineering 8C Bee Branch Creek - Construction Engineering Engineering Engineering Engineering Engineering 8C Bee Branch Creek - Construction 8C NPDES- Post Construction - State Grant 8C NPDES- Post Construction - Travel 8C Stormwater Infiltration & Inflow- Eng Div Services 8C Stormwater Infiltration & Inflow -Truck TOTAL STORM WATER CONST FUND PARKING CONSTRUCTION FUND Parking Division 8C Parking Division 8C WATER CONSTRUCTION FUND Water Water Water Water Water Water Water Water Water Water Water TRANSFERS Central Parking Ramp - Construction Port of Dubuque Ramp Special Expenses TOTAL PARKING CONSTRUCTION FUND 8C Annexation Study /Implementation - GO Bond 8C Annexation Study /Implementation - Construction 8C Annexation Study /Implementation - Consulting 8C Main Extension - Annexation - Consulting 8C Main Extension - Annexation - Construction 8C Annexation Study /Implementation - GO Bond 8C Annexation Study /Implementation - Construction 8C Annexation Study /Implementation - Eng Div Svcs 8C Annexation Study Phase II -GO Bond 8C Annexation Study Phase 11 - Eng Div Services 8C Annexation Study Phase 11 - Construction TOTAL WATER CONSTRUCTION FUND Fire Department Transi Fire Department Transi Engineering Transl0 Engineering Transl0 Housing & Community Dev Transl1 Housing & Community Dev Transl1 Sustainable Comm Coord Transl2 Sustainable Comm Coord Transl2 Police Department Trans2 Police Department Trans2 Park Division Trans3 Park Division Trans3 Park Division Trans4 Park Division Trans4 Water & Resource Recove Transs Water & Resource Recove Transs Parking Division Trans6 GRAND TOTAL AMENDMENT #2 Transfer from General Fund to Debt Service Fund Transfer from General Fund to Debt Service Fund Transfer from Special Assessments to General Const Transfer from Special Assessments to General Const Transfer from General Fund to Section 8 Fund Transfer from General Fund to Section 8 Fund Transfer from Refuse Fund to General Fund Transfer from Refuse Fund to General Fund Transfer from Gaming to General Fund Transfer from Gaming to General Fund Transfer From DRA Distribution To General Fund Transfer From DRA Distribution To General Fund Transfer From General Const To General Fund Transfer From General Const To General Fund Transfer from Sanitary Operating to Sanitary Const Transfer from Sanitary Operating to Sanitary Const Transfer from Parking Construction to Parking Const FY 12 Expense Amount (4,940,407) FY 12 Revenue Amount Fund Activity /CIP Account (4,492,749) Explanation 100,000 720 7201654 45701 MRT Trail Grant 1,000,000 720 7201654 45771 NSB Trail Grant 1,000,000 720 7201654 73211 NSB Trail Grant Appropriation 100,000 720 7201654 73211 MRT Trail Grant Appropnation 24,500 720 7202065 45701 Catfish Creek Watershed Management Grant 720 7202065 62320 Catfish Creek Watershed Management Grant 720 7202333 62811 I &I and Snow Removal Truck 720 7202333 71315 I &I and Snow Removal Truck 24,500 (35,102) 35,102 1,124,500 1,124,500 (289,585) 730 7302179 73211 Shift to Port of Dubuque Ramp Special Expense. 289,585 730 7302260 62731 Shift from Central Ave Ramp (475,000) (25,000) (36,400) (407,103) (1,611,200) (245,800) (45,000) (255,000) (3,100,503 ) (500,000) 740 740 740 740 740 (1,857,000) 740 740 740 (300,000) 740 740 740 (2,657,000) (3,978,2_2_2_) (467,505) Transfer Out Transfer In (85,000) (1,460,688) 33,375 19,000 6,500 66,000 34,000 163,155 289,585 Page 8 of 9 100 (85,000) 400 (1,460,688) 360 255 100 33,375 280 670 19,000 100 101 6,500 100 102 66,000 100 360 34,000 100 610 163,155 710 730 7401012 7401012 7401012 7401411 7401411 7401954 7401954 7401954 7402146 7402146 7402146 10010100 40013800 3602137 25510255 10010100 28061600 67054100 10072200 1011139 10013200 1022113 1002440 36010360 1002440 61043100 7102350 7302179 54210 Cancel Project 73211 Cancel Project 62712 Cancel Project 62712 Cancel Project 73211 Cancel Project 54210 Cancel Project 73211 Cancel Project 62811 Cancel Project 54210 Cancel Project 62811 Cancel Project 73211 Cancel Project 91400 Transfer Funds 59100 Transfer Funds 59255 Transfer Funds 91360 Transfer Funds 91280 Transfer Funds 59100 Transfer Funds 91100 Transfer Funds 59670 Transfer Funds 91100 Transfer Funds 59101 Transfer Funds 91100 Transfer Funds 59102 Transfer Funds 91100 Transfer Funds 59360 Transfer Funds 91710 Transfer Funds 59610 Transfer Funds 91730 Trans Funds FY 12 FY 12 Expense Revenue Department Program Description Amount Amount Fund Activity /CIP Account Parking Division Trans6 Transfer from Parking Construction to Parking Const 289,585 730 7302260 59730 Trans Funds Airport Trans7 Transfer from PFC Fund to Airport Construction Fund (16,206) 390 3902011 59391 Trans Funds Airport Trans7 Transfer from PFC Fund to Airport Construction Fund (16,206) 391 39110391 91390 Trans Funds Transit Division Trans8 Transfer from General Fund to Transit Fund (20,956) 600 6002236 59100 Transfer Funds Transit Division Trans8 Transfer from General Fund to Transit Fund (20,956) 100 10010100 91600 Transfer Funds Engineering Trans9 Transfer from GO Bond Proceeds to Street Const 1,293 300 3001287 59440 Trans Funds Engineering Trans9 Transfer from GO Bond Proceeds to Street Const 1,293 440 44010440 91300 Trans Funds TOTAL TRANSFERS (969,942) (969,942) GRAND TOTAL WITH TRANSFERS (4,948,164) (1,437,447) Page 9 of 9 Explanation Nov -07 NOTICE OF PUBLIC HEARING Form 653 CI 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 04/16/2012 (hour) (Date) ,for the purpose of amending the current budget of the city for the fiscal year ending June 30, County, Iowa 2012 (veal) 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 additional revenue from grants received, private funding, bond proceeds, and the appropriation to spend the monies Adjustments to reflect the amended Community Development Annual Plan budget are included along with savings from completed or cancelled projects and available cash balance is used to fund increased operations There will be no increase in tax levies to be paid in the current fiscal year named above Any increase in expenditures set out above will be met from the increased non - property tax revenues and cash balances not budgeted or considered in this current budget This will provide for a balanced budget City Clerk! Finance Officer Name Total Budget as certified or last amended Current Amendment Total Budget after Current Amendment Revenues & Other Financing Sources 20,559,847 20,559,847 Taxes Levied on Property 1 Less Uncollectted Property Taxes -Levy Year 2 0 Net Current Property Taxes 3 20,559,847 0 20,559,847 Delinquent Property Taxes 4 0 0 TIF Revenues 5 10,151,097 10,151,097 Other City Taxes 6 14,904,342 14,904,342 Licenses & Permits 7 1,254,672 1,254,672 Use of Money and Property 8 12,774,846 59,686 12,834,532 Intergovernmental 9 93,300,233 - 6,513,877 86,786,356 Charges for Services 10 32,839,797 -895 32,838,902 Special Assessments 11 441,100 1,437,235 1,878,335 Miscellaneous 12 8,190,899 - 43,358 8,147,541 Other Financing Sources 13 104,119,675 3,623,762 107,743,437 Total Revenues and Other Sources 14 298,536,508 - 1,437,447 297,099,061 Expenditures & Other Financing Uses 24,690,365 161,433 24,851,798 Public Safety 15 Public Works 16 12,038,363 39,600 12,077,963 Health and Social Services 17 1,020,504 -6,462 1,014,042 Culture and Recreation 18 9,999,106 395,445 10,394,551 Community and Economic Development 19 13,348,997 - 444,636 12,904,361 General Govemment 20 7,146,386 19,000 7,165,386 Debt Service 21 7,019,294 - 85,000 6,934,294 Capital Protects 22 109,660,157 - 9,486,563 100,173,594 Total Govemment Activities Expenditures 23 184,923,172 - 9,407,183 175,515,989 Business Type ( Enterprises 24 114,701,903 5,428,961 120,130,864 Total Gov Activities & Business Expenditures 25 299,625,075 - 3,978,222 295,646,853 Transfers Out 26 28,013,707 - 969,942 27,043,765 Total Expenditures/Transfers Out 27 327,638,782 - 4,948,164 322,690,618 Excess Revenues & Other Sources Over ( Under) ExpendrtureslTransfers Out Fiscal Year 28 - 29,102,274 3,510,717 - 25,591,557 Continuing Appropnation 29 N/A 0 Beginning Fund Balance July 1 30 39,718,581 39,718,581 Ending Fund Balance June 30 31 10,616,307 3,510,717 14,127,024 Explanation of increases or decreases in revenue estimates, appropriations, or available cash This amendment adds additional revenue from grants received, private funding, bond proceeds, and the appropriation to spend the monies Adjustments to reflect the amended Community Development Annual Plan budget are included along with savings from completed or cancelled projects and available cash balance is used to fund increased operations 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 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 04/16/2012 County, Iowa (hour) (Dare) ,for the purpose of amending the current budget of the city for the fiscal year ending June 30, 2012 (mar) 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: t�� giglF- °p�__ l - _ao10 F = ===ECM �'_=�ENPMs=w=MOB'- �===='= 94 g �Es m3=•=�__e_ 14e �° s��9E��8 ==- �Ilisi=- =�9� = ° -- s��e� - = = =�= =- °_-- o�o��- =�_ - -� 6_ � - WF�� = -= °moo E s1(_ This amendment adds additional revenue from grants received, private funding, bond proceeds, and the appropriation to spend the monies. Adjustments to reflect the amended Community Development Annual Plan budget are included along with savings from completed or cancelled projects and available cash balance is used to fund increased operations. 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 bal -...� not budgeted or considered in this current budget. This will provide for a balanced budget. / APISA ■ erk/ Finance Officer ' ame Total Budget as certified or last amended Current Amendment Total Budget after Current Amendment Revenues & Other Financing Sources 1 .gp.°== ___mvUU^ °t 20,559,847 = p EE - ° -- ° ;_gil :2 , „ -i. _ - „50I Taxes Levied on Property 20,559,847 Less: Uncollectted Property :faxes -Levy Year 2 0 Net Current Property Taxes 3 20,559,847 0 20,559,847 Delinquent Property Taxes 4 0 0 TIF Revenues 5 10,151,097 10,151,097 Other City Taxes 6 14,904,342 14,904,342 Licenses & Permits 7 1,254,672 1,254,672 Use of Money and Property 8 12,774,846 59,686 12,834,532 Intergovernmental 9 93,300,233 - 6,513,877 86,786,356 Charges for Services 10 32,839,797 -895 32,838,902 Special Assessments 11 441,100 1,437,235 1,878,335 Miscellaneous 12 8,190,899 - 43,358 8,147,541 Other Financing Sources 13 104,119,675 3,623,762 107,743,437 Total Revenues and Other Sources 14 298,536,508 - 1,437,447 297,099,061 Expenditures Sr Other Financing Uses 15 met ' °- °SEE io E__= a A�� _�= _- _c -_ @=; .,t�7�p�_'�as = =, 161,433 24,851,798 Public Safety 24,690,365 Public Works 16 12,038,363 39,600 12,077,963 Health and Social Services 17 1,020,504 -6,462 1,014,042 Culture and Recreation 18 9,999,106 395,445 10,394,551 Community and Economic Development 19 13,348,997 - 444,636 12,904,361 General Government 20 7,146,386 19,000 7,165,386 Debt Service 21 7,019,294 - 85,000 6,934,294 Capital Projects 22 109,660,157 - 9,486,563 100,173,594 Total Government Activities Expenditures 23 184,923,172 - 9,407,183 175,515,989 Business Type / Enterprises 24 114,701,903 5,428,961 120,130,864 Total Gov Activities & Business Expenditures 25 299,625,075 - 3,978,222 295,646,853 Transfers Out 26 28,013,707 - 969,942 27,043,765 Total Expenditures/Transfers Out 27 327,638,782 - 4,948,164 322,690,618 Excess Revenues & Other Sources Over (Under) Expenditures/Transfers Out Fiscal Year 28 i @9M� =EHm aM � � - 29,102,274 cmg .�_M == a = =M,i. 3,510,717 F =€ 0==_' - 25,591,557 Continuing Appropriation 29 N/A 0 Beginning Fund Balance July 1 30 39,718,581 39,718,581 Ending Fund Balance June 30 31 10,616,307 3,510,717 14,127,024 Explanation of increases or decreases in revenue estimates, appropriations, or available cash: t�� giglF- °p�__ l - _ao10 F = ===ECM �'_=�ENPMs=w=MOB'- �===='= 94 g �Es m3=•=�__e_ 14e �° s��9E��8 ==- �Ilisi=- =�9� = ° -- s��e� - = = =�= =- °_-- o�o��- =�_ - -� 6_ � - WF�� = -= °moo E s1(_ This amendment adds additional revenue from grants received, private funding, bond proceeds, and the appropriation to spend the monies. Adjustments to reflect the amended Community Development Annual Plan budget are included along with savings from completed or cancelled projects and available cash balance is used to fund increased operations. 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 bal -...� not budgeted or considered in this current budget. This will provide for a balanced budget. / APISA ■ erk/ Finance Officer ' ame