Loading...
Set Public Hearing for the Fiscal Year 2024 Second Budget AmendmeiCity of Dubuque City Council Meeting Copyrighted May 6, 2024 Items to be set for Public Hearing # 09. ITEM TITLE: Set Public Hearing for the Fiscal Year 2024 Second Budget Amendment SUMMARY: City Manager recommending the second Fiscal Year 2024 Budget Amendment be set for public hearing for May 20, 2024. RESOLUTION Setting the date for the public hearing on Amendment No. 2 to the Fiscal Year 2024 Budget for the City of Dubuque SUGGESTED Receive and File; Adopt Resolution(s), Set Public Hearing for May 20, DISPOSITION: 2024Suggested Disposition: ATTACHMENTS: Description Type MVM Memo City Manager Memo Staff Memo Staff Memo Resolution Resolutions Notice of Public Hearing Supporting Documentation FY24 Amend #2 Council Detail Supporting Documentation THE C DUUB-.'&-FE Masterpiece on the Mississippi TO: The Honorable Mayor and City Council Members FROM: Michael C. Van Milligen, City Manager SUBJECT: Fiscal Year 2024 Second Budget Amendment DATE: April 30, 2024 Dubuque All -America City wuxnv rn 2007-2012.2013 2017*2019 Chief Financial Officer Jennifer Larson is recommending the second Fiscal Year 2024 Budget Amendment be set for public hearing for May 20, 2024. I concur with the recommendation and respectfully request Mayor and City Council approval. Michael C. Van Milligen MCVM/jml Attachment cc: Crenna Brumwell, City Attorney Cori Burbach, Assistant City Manager Jennifer Larson, Chief Financial Officer Laura Bendorf, Budget Manager THE C DUUB-.'&-FE Masterpiece on the Mississippi TO: Michael C. Van Milligen, City Manager FROM: Jennifer Larson, Chief Financial Officer SUBJECT: Fiscal Year 2024 Second Budget Amendment DATE: April 30, 2024 Dubuque All -America City wuxnv rn 2007-2012.2013 2017*2019 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 2024 budget was adopted in October 2023 and adjustments to reflect new grants and reallocation of funding. An increase in interfund transfers of $298,298 is also included. The amendment totals $10,308,297 in increased appropriation authority and an increase in resources of $9,682,720. Additional revenues added in this amendment with offsetting appropriations are: • Airport Minimum Revenue Guarantee Federal Grant ($1,500,000), • Street Signs & Markings Insurance Settlements ($75,998), • Tenant Based Rental Assistance HOME Grants ($84,625), • Bloomberg Youth Climate Action Private Contribution ($50,000), • Hyperflow Pilot Grant ($80,000), • Harbor Area Maintenance Grants ($417,500), • Granger Creek Lift Station Improvements Federal Grant ($1,000,000), • Bee Branch Gate & Pump Federal Grant ($5,200,000). Reduced revenues reflected in this amendment with offsetting reductions in appropriations include: • Library General Gift Trust (-$60,000) reduced to actual. This amendment includes an increase of $366,749 for Community Development Block Grant (CDBG) related programs. The increase in CDBG programs include Affordable Housing Network Inc ($528,100), Visiting Nurse Association ($20,000), Administration ($18,279), Capital Projects ($409,414), Code Enforcement ($2,500), Ecumenical Towers ($380,000), Homebuyer Assistance Loans ($50,000), Homeowner Rehab Loans ($125,000), Four Mounds Heart ($85,000), Low/Moderate Income Parks ($39,100), and IEDA ($37,713). Decreases in CDBG programs include Property Rehab (-$197,599), Broadband CARES Act (-$19,456), Neighborhood Reinvestment (-$926,490), and Lincoln Elementary Wellness Project (-$263,632). This amendment also includes a delay in Public Works Refuse Truck purchases in the amount of $998,255, street maintenance reimbursements of $81,510, corrects Housing Choice Vouchers in the amount of $80,279, corrects Accounting Technology Services for $365,574, and corrects Refuse Collection Grants in the amount of $19,350. 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 May 20, 2024. Attachments JML Prepared by Jennifer Larson, Chief Financial Officer, 50 W. 13th St., Dubuque, IA 52001, (563) 589-4322 Return to Adrienne N. Breitfelder, City Clerk, 50 W. 13t' St., Dubuque, IA 52001, (563) 589-4100 RESOLUTION NO. 123-24 SETTING THE DATE FOR THE PUBLIC HEARING ON AMENDMENT NO. 2 TO THE FISCAL YEAR 2024 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 2024 budget for the City of Dubuque at the City Council Chambers at the Historic Federal Building, 350 West 6th Street, Dubuque, Iowa, on Monday, May 20, 2024, 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 6th day of May 2024. . • 11 . �,/. • Attest: VAdrienne N. Breitfelder, City Clerk NOTICE OF PUBLIC HEARING -AMENDMENT OF CURRENT BUDGET City of DUBUQUE Fiscal Year July 1, 2023 - June 30, 2024 The City of DUBUQUE will conduct a ublic hearin for the purpose of amendingthe current budget for fiscal year endingJune 30, 2024 MeetingDate/Time: 5/20/2024 06:30 PM Contact: Jennifer Larson I Phone: 563 589-4398 Meeting Location: City Council Chambers at the Historic Federal Building, 350 West 6th Street, Dubuque, Iowa There will be no increase in taxes. Any residents or taxpayers will be heard for or against the proposed amendment at the time and place specified above. A detailed statement of: additional receipts, cash balances on hand at the close of the preceding fiscal year, and proposed disbursements, both past and anticipated, will be available at the hearing. Budget amendments are subject to protest. If protest petition requirements are met, the State Appeal Board will hold a local hearing. For more information, consult htt s://dom.iowa.gov/local-gov-appeals. REVENUES & OTHER FINANCING SOURCES Total Budget as Certified or Last Amended Current Amendment Total Budget After Current Amendment Taxes Levied on Property 1 25,929,410 0 25,929,410 Less: Uncollected Delinquent Taxes - Levy Year 2 0 0 0 Net Current Property Tax 3 25,929,410 0 25,929,410 Delinquent Property Tax Revenue 4 0 0 0 TIF Revenues 5 12,193,208 0 12,193,208 Other City Taxes 6 23,073,236 0 23,073,236 Licenses & Permits 7 2,355,200 0 2,355,200 Use of Money & Property 8 18,109,883 -3,299 18,106,584 Intergovernmental 9 73,970,793 9,292,261 83,263,054 Charges for Service 10 53,878,113 0 53,878,113 Special Assessments 11 115,000 0 115,000 Miscellaneous 12 13,206,663 393,758 13,600,421 Other Financing Sources 13 51,752,136 0 51,752,136 Transfers In 14 73,074,875 298,298 73,373,173 Total Revenues & Other Sources 15 347,658,517 9,981,018 357,639,535 EXPENDITURES & OTHER FINANCING USES Public Safety 16 38,911,682 -7 38,911,675 Public Works 17 18,204,420 1,561,498 19,765,918 Health and Social Services 18 913,248 -3,089 910,159 Culture and Recreation 19 20,093,384 50,737 20,144,121 Community and Economic Development 20 18,960,655 1,085,263 20,045,918 General Government 21 16,555,454 515,574 17,071,028 Debt Service 22 13,007,373 0 13,007,373 Capital Projects 23 146,833,874 1,882,076 148,715,950 Total Government Activities Expenditures 24 273,480,090 5,092,052 278,572,142 Business Type/Enterprise 25 109,927,081 5,216,245 115,143,326 Total Gov Activities & Business Expenditures 26 383,407,171 10,308,297 393,715,468 Transfers Out 27 73,074,875 298,298 73,373,173 Total Expenditures/Transfers Out 281 456,482,046 10,606,595 467,088,641 Excess Revenues & Other Sources Over Under Expenditures/Transfers Out 29 -108,823,529 -625,577 -109,449,106 Beginning Fund Balance July 1, 2023 30 252,186,179 0 252,186,179 Ending Fund Balance June 30, 2024 31 143,362,650 -625,577 142,737,073 Explanation of Changes: This amendment adds additional revenue from grants received, private funding, and the appropriation to spend the monies. Adjustment to reflect actual budget of projects. 04/30/2024 08:16 AM Paae 1 of 1 FISCAL YEAR 2024 AMENDMENT #2 COUNCIL DETAIL FY24 FY24 Department Program Description Expense Revenue Fund Account Explanation GENERALFUND Police 10 Administration - Technology Equipment (20,000.00) 100 -10-110-1101-00-01-65045 Shift to Vehicles Police 10 Police Patrol - Vehicles 20,000.00 100 -10-110-1109-00-01-67100 Shift from Tech Equip Airport 20 Airport Minimum Revenue Guarantee - Federal Grants - 1,500,000.00 100 -20-280-5150-04-01-44000 New Grant Airport 20 Airport Minimum Revenue Guarantee - Payments to Other Agencies 1,500,000.00 - 100 -20-280-5101-00-01-64130 New Grant Public Works 20 Street Signs and Markings - Insurance Settlements 75,998.00 100 -20-240-5405-03-01-47200 Adjust to Actual Public Works 20 Street Maintenance - Building Maintenance (3,300.00) 100 -20-210-5406-00-01-63100 Shift to Mow Equip Public Works 20 Street Maintenance - Technology Equipment 4,500.00 100 -20-210-5406-00-01-65045 Shift from Other Eq Public Works 20 Street Maintenance - Building Maintenance (14,500.00) 100 -20-210-5406-00-01-63100 Shift to Cons Eng Economic Development 40 Arts and Cultural Affairs - Spec Pay - Moving Allowance (1,500.00) 100 -40-520-6002-00-01-60760 Shift to Otr Cont Sery Economic Development 40 Arts and Cultural Affairs - Other Contractual Service 1,500.00 100 -40-520-6002-00-01-64990 Shift from Moving Allow Economic Development 50 Administration - Payments to Other Agencies 25,000.00 100 -50-520-6001-00-01-64130 Adjust to Actual Housing 50 HOME Grant - Tenant Based Rental As - Contrib - Private Sources - 28,750.00 100 -50-530-6150-04-04-47050 New Grant Housing 50 HOME Grant - Tenant Based Rental As - Federal Grants - 55,875.00 100 -50-530-6150-04-04-44000 New Grant Housing 50 HOME Grant - Tenant Based Rental As - Grants 84,625.00 - 100 -50-530-6150-00-01-64135 New Grant City Manager's Office 60 Sustainability - Contrib - Private Sources - 50,000.00 100 -60-610-7202-04-01-47050 New Grant City Manager's Office 60 Sustainability - Payments to Other Agencies 40,000.00 - 100 -60-610-7202-00-01-64130 New Grant City Manager's Office 60 Sustainability - Salaries -Regular Full Time 4,987.00 100 -60-610-7202-00-01-60100 New Grant City Manager's Office 60 Sustainability - FICA - City Contribution 382.00 100 -60-610-7202-00-01-61100 New Grant City Manager's Office 60 Sustainability - IPERS - City Contribution 471.00 100 -60-610-7202-00-01-61300 New Grant City Manager's Office 60 Sustainability - Health Insurance 1,007.00 100 -60-610-7202-00-01-61510 New Grant City Manager's Office 60 Sustainability - Life Insurance 3.00 100 -60-610-7202-00-01-61540 New Grant City Manager's Office 60 Sustainability - Program Materials 1,000.00 100 -60-610-7202-00-01-65025 New Grant City Manager's Office 60 Sustainability - Special Events 2,150.00 100 -60-610-7202-00-01-64115 New Grant City Manager's Office 60 Administration - Other Professional Service 100,000.00 100 -60-610-7201-00-01-64900 Adjust to Actual City Clerk 60 Elections - Election (10,800.00) 100 -60-620-7302-00-01-64950 Shift to Tech Sery City Clerk 60 Administration - Technology Services 10,800.00 100 -60-620-7301-00-01-64190 Shift from Election Exp Finance 60 Accounting - Technology Services 365,574.00 100 -60-620-7401-00-01-64190 Adjust to Actual Purchase of Services 30 Purchase of Services - Payments to Other Agencies (3,089.00) 100 -30-399-7901-00-01-64130 Adjust to Actual Planning 76 CLG Voelker Highlands Survey - Other Professional Service (7,000.00) 102 -76-750-6270-00-02-64900 Shift to 6254000003 Planning 76 Two CLG 20th C Surveys - Other Professional Service 7,000.00 102 -76-750-6270-00-02-64900 Shift from 6254000004 TOTAL GENERAL FUND 2,108,810 1,710,623 ROAD USE TAX Public Works 20 Street Maintenance - Vehicles 75,998.00 - 110 -20-210-5406-00-01-67100 Adjust to Actual Public Works 20 Street Cleaning - Mowing Equipment 3,300.00 110 -20-270-5407-00-01-67110 Shift from Bld Mtn Public Works 20 Street Maintenance - Other Equipment (4,500.00) 110 -20-210-5406-00-01-65050 Shift to Tech Sery Public Works 20 Street Maintenance - Reimbursements - 81,510.00 110 -20-210-5406-03-01-47100 Adjust to Actual TOTAL ROAD USE TAX 74,798 81,510 DOWNTOWN LOAN POOL -TIF FUND Economic Development 76 Downtown Rehab Grant Program - Loans 640,000.00 160 -76-750-6070-00-02-64134 Adjust to Actual TOTAL DOWNTOWN LOAN POOL - TIF FUND 640,000.00 LIBRARY GENERAL GIFT TRUST FUND Library 40 General Gift Trust - Refunds - (60,000.00) 170 -40-410-3661-03-01-47150 Adjust to Actual Library 40 General Gift Trust - Other Professional Service (60,000.00) 170 -40-410-3661-00-01-64900 Adjust to Actual Library 40 General Gift Trust - Printing 4,114.00 170 -40-410-3661-00-01-64140 Adjust to Actual Library 40 General Gift Trust - Sales Tax Expense 373.00 170 -40-410-3661-00-01-64180 Adjust to Actual Library 40 General Gift Trust - Speakers 1,031.00 170 -40-410-3661-00-01-64860 Adjust to Actual Library 40 General Gift Trust - Other Professional Service 98,432.00 170 -40-410-3661-00-01-64900 Adjust to Actual Library 40 General Gift Trust - Library Materials 1,381.00 170 -40-410-3661-00-01-65020 Adjust to Actual Library 40 General Gift Trust - Salaries -Regular Full Time 121.00 170 -40-410-3661-00-01-60100 Adjust to Actual FISCAL YEAR 2024 AMENDMENT #2 COUNCIL DETAIL FY24 FY24 Department Program Description Library 40 General Gift Trust - Program Materials TOTAL LIBRARY GENERAL GIFT TRUST FUND COMMUNITY DEVELOPMENT BLOCK GRANT FUND Health 76 Capital Projects - Payments to Other Agencies Parks 76 Low/Mod Park Equipment - Other Capital Equipment Parks 76 Avon Park Equipment - Other Capital Equipment Parks 76 Comiskey Pk Bld- SC Alrm - Safety Equipment Parks 76 Low/mod inc park improvements Other Capital Outlay Parks 76 COMISKEY PARK NEW ENTRY - Other Capital Outlay Parks 76 Low/mod inc park improvements Other Capital Outlay Public Works 76 Capital Projects - Other Capital Outlay Economic Development 76 Low/Mod Small Biz Grants - Loans Economic Development 76 CDBG - FY24 ED Microenterprise - Grants Housing 10 Inspect and Construction Svcs - Workers' Compensation Housing 50 Grants - Salaries -Regular Full Time Housing 50 Grants - FICA - City Contribution Housing 50 Grants - IPERS - City Contribution Housing 50 Grants - Health Insurance Housing 50 Grants - Life Insurance Housing 50 Grants - Workers' Compensation Housing 50 Grants - Association Dues Housing 50 Grants - Mileage Housing 50 Grants - Education Reimbursement Housing 50 Grants - Telecommunications Housing 50 Grants - Accounting & Auditing Housing 50 Grants - Advertising Housing 50 Grants - Printing Housing 50 Grants - Office Supplies Housing 50 Grants - Postage/Shipping Housing 50 CDBG Administration - Salaries -Regular Full Time Housing 50 CDBG Administration - FICA - City Contribution Housing 50 CDBG Administration - IPERS - City Contribution Housing 50 CDBG Administration - Health Insurance Housing 50 CDBG Administration - Life Insurance Housing 50 CDBG Administration - Workers' Compensation Housing 50 CDBG Administration - Association Dues Housing 50 CDBG Administration - Mileage Housing 50 CDBG Administration - Education Reimbursement Housing 50 CDBG Administration - Telecommunications Housing 50 CDBG Administration - Accounting & Auditing Housing 50 CDBG Administration - Advertising Housing 50 CDBG Administration - Printing Housing 50 CDBG Administration - Office Supplies Housing 50 CDBG Administration - Postage/Shipping Housing 50 Administration - Salaries -Regular Full Time Housing 50 Administration - FICA - City Contribution Housing 50 Administration - IPERS - City Contribution Housing 50 Administration - Health Insurance Housing 50 Administration - Life Insurance Housing 50 Administration - Workers' Compensation Housing 50 Administration - Association Dues Expense Revenue Fund Account Explanation 5,285.00 170 -40-410-3661-00-01-65025 Adjust to Actual 50,737.00 (60,000.00) 20,000.00 180 -76-750-1770-00-02-64130 CDBG AMEND#2 (17,055.00) 180 -76-750-3070-00-02-67270 CDBG AMEND#2 99,995.00 180 -76-750-3070-00-02-67270 CDBG AMEND#2 (10,000.00) 180 -76-750-3070-00-02-65054 CDBG AMEND#2 (150,000.00) 180 -76-750-3070-00-02-67990 CDBG AMEND#2 (27,746.00) 180 -76-750-3070-00-02-67990 CDBG AMEND#2 143,906.00 180 -76-750-3070-00-02-67990 CDBG AMEND#2 58,305.00 180 -76-750-5470-00-02-67990 CDBG AMEND#2 (50,000.00) 180 -76-750-6070-00-02-64134 CDBG AMEND#2 50,000.00 180 -76-750-6070-00-02-64135 CDBG AMEND#2 (7.00) 180 -10-530-6103-00-01-61600 CDBG AMEND#2 (102,125.00) 180 -50-530-6150-00-01-60100 CDBG AMEND#2 (7,387.00) 180 -50-530-6150-00-01-61100 CDBG AMEND#2 (9,114.00) 180 -50-530-6150-00-01-61300 CDBG AMEND#2 (16,242.00) 180 -50-530-6150-00-01-61510 CDBG AMEND#2 (55.00) 180 -50-530-6150-00-01-61540 CDBG AMEND#2 (165.00) 180 -50-530-6150-00-01-61600 CDBG AMEND#2 (1,000.00) 180 -50-530-6150-00-01-62100 CDBG AMEND#2 (50.00) 180 -50-530-6150-00-01-62325 CDBG AMEND#2 (3,200.00) 180 -50-530-6150-00-01-62500 CDBG AMEND#2 (624.00) 180 -50-530-6150-00-01-63730 CDBG AMEND#2 (3,502.00) 180 -50-530-6150-00-01-64010 CDBG AMEND#2 (256.00) 180 -50-530-6150-00-01-64020 CDBG AMEND#2 (200.00) 180 -50-530-6150-00-01-64140 CDBG AMEND#2 (175.00) 180 -50-530-6150-00-01-65060 CDBG AMEND#2 (70.00) 180 -50-530-6150-00-01-65080 CDBG AMEND#2 76,960.00 180 -50-530-6150-00-01-60100 CDBG AMEND#2 7,387.00 180 -50-530-6150-00-01-61100 CDBG AMEND#2 9,114.00 180 -50-530-6150-00-01-61300 CDBG AMEND#2 16,242.00 180 -50-530-6150-00-01-61510 CDBG AMEND#2 55.00 180 -50-530-6150-00-01-61540 CDBG AMEND#2 165.00 180 -50-530-6150-00-01-61600 CDBG AMEND#2 1,000.00 180 -50-530-6150-00-01-62100 CDBG AMEND#2 50.00 180 -50-530-6150-00-01-62325 CDBG AMEND#2 3,200.00 180 -50-530-6150-00-01-62500 CDBG AMEND#2 624.00 180 -50-530-6150-00-01-63730 CDBG AMEND#2 3,502.00 180 -50-530-6150-00-01-64010 CDBG AMEND#2 256.00 180 -50-530-6150-00-01-64020 CDBG AMEND#2 200.00 180 -50-530-6150-00-01-64140 CDBG AMEND#2 175.00 180 -50-530-6150-00-01-65060 CDBG AMEND#2 70.00 180 -50-530-6150-00-01-65080 CDBG AMEND#2 (102,261.00) 180 -50-530-6101-00-01-60100 CDBG AMEND#2 (2,722.00) 180 -50-530-6101-00-01-61100 CDBG AMEND#2 (3,359.00) 180 -50-530-6101-00-01-61300 CDBG AMEND#2 (3,356.00) 180 -50-530-6101-00-01-61510 CDBG AMEND#2 (11.00) 180 -50-530-6101-00-01-61540 CDBG AMEND#2 (57.00) 180 -50-530-6101-00-01-61600 CDBG AMEND#2 (140.00) 180 -50-530-6101-00-01-62100 CDBG AMEND#2 FISCAL YEAR 2024 AMENDMENT #2 COUNCIL DETAIL FY24 FY24 Department Program Description Expense Revenue Fund Account Explanation Housing 50 Administration - Subscriptions (170.00) 180 -50-530-6101-00-01-62200 CDBG AMEND#2 Housing 50 Administration - Mileage (271.00) 180 -50-530-6101-00-01-62325 CDBG AMEND#2 Housing 50 Administration - Meetings & Conferences (8,075.00) 180 -50-530-6101-00-01-62400 CDBG AMEND#2 Housing 50 Administration - Education Reimbursement (7,055.00) 180 -50-530-6101-00-01-62500 CDBG AMEND#2 Housing 50 Administration - Telecommunications (347.00) 180 -50-530-6101-00-01-63730 CDBG AMEND#2 Housing 50 Administration - Advertising (250.00) 180 -50-530-6101-00-01-64020 CDBG AMEND#2 Housing 50 Administration - Recording Fees (250.00) 180 -50-530-6101-00-01-64050 CDBG AMEND#2 Housing 50 Administration - Printing (40.00) 180 -50-530-6101-00-01-64140 CDBG AMEND#2 Housing 50 Administration - Copying (50.00) 180 -50-530-6101-00-01-64145 CDBG AMEND#2 Housing 50 Administration - Rental - Land/Bldgs/Parking (60.00) 180 -50-530-6101-00-01-64160 CDBG AMEND#2 Housing 50 Administration - Technology Services (720.00) 180 -50-530-6101-00-01-64190 CDBG AMEND#2 Housing 50 Administration - IT Recharges (8,853.00) 180 -50-530-6101-00-01-64191 CDBG AMEND#2 Housing 50 Administration - Office Supplies (800.00) 180 -50-530-6101-00-01-65060 CDBG AMEND#2 Housing 50 Administration - Postage/Shipping (80.00) 180 -50-530-6101-00-01-65080 CDBG AMEND#2 Housing 50 CDBG Administration - Salaries -Regular Full Time 98,334.00 180 -50-530-6101-00-01-60100 CDBG AMEND#2 Housing 50 CDBG Administration - FICA - City Contribution 2,722.00 180 -50-530-6101-00-01-61100 CDBG AMEND#2 Housing 50 CDBG Administration - IPERS - City Contribution 3,359.00 180 -50-530-6101-00-01-61300 CDBG AMEND#2 Housing 50 CDBG Administration - Health Insurance 3,356.00 180 -50-530-6101-00-01-61510 CDBG AMEND#2 Housing 50 CDBG Administration - Life Insurance 11.00 180 -50-530-6101-00-01-61540 CDBG AMEND#2 Housing 50 CDBG Administration - Workers' Compensation 57.00 180 -50-530-6101-00-01-61600 CDBG AMEND#2 Housing 50 CDBG Administration - Association Dues 140.00 180 -50-530-6101-00-01-62100 CDBG AMEND#2 Housing 50 CDBG Administration - Subscriptions 170.00 180 -50-530-6101-00-01-62200 CDBG AMEND#2 Housing 50 CDBG Administration - Mileage 271.00 180 -50-530-6101-00-01-62325 CDBG AMEND#2 Housing 50 CDBG Administration - Meetings & Conferences 8,075.00 180 -50-530-6101-00-01-62400 CDBG AMEND#2 Housing 50 CDBG Administration - Education Reimbursement 7,055.00 180 -50-530-6101-00-01-62500 CDBG AMEND#2 Housing 50 CDBG Administration - Telecommunications 347.00 180 -50-530-6101-00-01-63730 CDBG AMEND#2 Housing 50 CDBG Administration - Advertising 250.00 180 -50-530-6101-00-01-64020 CDBG AMEND#2 Housing 50 CDBG Administration - Recording Fees 250.00 180 -50-530-6101-00-01-64050 CDBG AMEND#2 Housing 50 CDBG Administration - Printing 40.00 180 -50-530-6101-00-01-64140 CDBG AMEND#2 Housing 50 CDBG Administration - Copying 50.00 180 -50-530-6101-00-01-64145 CDBG AMEND#2 Housing 50 CDBG Administration - Rental - Land/Bldgs/Parking 60.00 180 -50-530-6101-00-01-64160 CDBG AMEND#2 Housing 50 CDBG Administration - Technology Services 720.00 180 -50-530-6101-00-01-64190 CDBG AMEND#2 Housing 50 CDBG Administration - IT Recharges 8,853.00 180 -50-530-6101-00-01-64191 CDBG AMEND#2 Housing 50 CDBG Administration - Office Supplies 800.00 180 -50-530-6101-00-01-65060 CDBG AMEND#2 Housing 50 CDBG Administration - Postage/Shipping 80.00 180 -50-530-6101-00-01-65080 CDBG AMEND#2 Housing 50 Property Rehab Program - Salaries -Regular Full Time (197,599.00) 180 -50-530-6102-00-01-60100 CDBG AMEND#2 Housing 50 Property Rehab Program - FICA - City Contribution (15,117.00) 180 -50-530-6102-00-01-61100 CDBG AMEND#2 Housing 50 Property Rehab Program - IPERS - City Contribution (18,655.00) 180 -50-530-6102-00-01-61300 CDBG AMEND#2 Housing 50 Property Rehab Program - Health Insurance (36,109.00) 180 -50-530-6102-00-01-61510 CDBG AMEND#2 Housing 50 Property Rehab Program - Life Insurance (123.00) 180 -50-530-6102-00-01-61540 CDBG AMEND#2 Housing 50 Property Rehab Program - Workers' Compensation (3,963.00) 180 -50-530-6102-00-01-61600 CDBG AMEND#2 Housing 50 Property Rehab Program - Association Dues (61.00) 180 -50-530-6102-00-01-62100 CDBG AMEND#2 Housing 50 Property Rehab Program - Education Reimbursement (1,666.00) 180 -50-530-6102-00-01-62500 CDBG AMEND#2 Housing 50 Property Rehab Program - Vehicle Ops - Gasoline (700.00) 180 -50-530-6102-00-01-63312 CDBG AMEND#2 Housing 50 Property Rehab Program - Vehicle Repair - Internal (672.00) 180 -50-530-6102-00-01-63320 CDBG AMEND#2 Housing 50 Property Rehab Program - Vehicle Repair - Outsourced (85.00) 180 -50-530-6102-00-01-63321 CDBG AMEND#2 Housing 50 Property Rehab Program - Recording Fees (4,133.00) 180 -50-530-6102-00-01-64050 CDBG AMEND#2 Housing 50 Property Rehab Program - Printing (40.00) 180 -50-530-6102-00-01-64140 CDBG AMEND#2 Housing 50 Property Rehab Program - Copying (1,116.00) 180 -50-530-6102-00-01-64145 CDBG AMEND#2 Housing 50 Property Rehab Program - Rental - Equipment (26.00) 180 -50-530-6102-00-01-64150 CDBG AMEND#2 Housing 50 Property Rehab Program - Rental - Land/Bldgs/Parking (2,256.00) 180 -50-530-6102-00-01-64160 CDBG AMEND#2 Housing 50 Property Rehab Program - Technology Services (7,700.00) 180 -50-530-6102-00-01-64190 CDBG AMEND#2 FISCAL YEAR 2024 AMENDMENT #2 COUNCIL DETAIL FY24 FY24 Department Program Description Expense Revenue Fund Account Explanation Housing 50 Property Rehab Program - IT Recharges (7,607.00) 180 -50-530-6102-00-01-64191 CDBG AMEND#2 Housing 50 Property Rehab Program - Technology Equipment (2,514.00) 180 -50-530-6102-00-01-65045 CDBG AMEND#2 Housing 50 Property Rehab Program - Office Supplies (100.00) 180 -50-530-6102-00-01-65060 CDBG AMEND#2 Housing 50 Property Rehab Program - Postage/Shipping (564.00) 180 -50-530-6102-00-01-65080 CDBG AMEND#2 Housing 50 CDBG Projects - Salaries -Regular Full Time 47,371.00 180 -50-530-6102-00-01-60100 CDBG AMEND#2 Housing 50 CDBG Projects - FICA - City Contribution 15,117.00 180 -50-530-6102-00-01-61100 CDBG AMEND#2 Housing 50 CDBG Projects - IPERS - City Contribution 18,655.00 180 -50-530-6102-00-01-61300 CDBG AMEND#2 Housing 50 CDBG Projects - Health Insurance 36,109.00 180 -50-530-6102-00-01-61510 CDBG AMEND#2 Housing 50 CDBG Projects - Life Insurance 123.00 180 -50-530-6102-00-01-61540 CDBG AMEND#2 Housing 50 CDBG Projects -Workers' Compensation 3,963.00 180 -50-530-6102-00-01-61600 CDBG AMEND#2 Housing 50 CDBG Projects - Association Dues 61.00 180 -50-530-6102-00-01-62100 CDBG AMEND#2 Housing 50 CDBG Projects - Education Reimbursement 1,666.00 180 -50-530-6102-00-01-62500 CDBG AMEND#2 Housing 50 CDBG Projects - Vehicle Ops - Gasoline 700.00 180 -50-530-6102-00-01-63312 CDBG AMEND#2 Housing 50 CDBG Projects - Vehicle Repair - Internal 672.00 180 -50-530-6102-00-01-63320 CDBG AMEND#2 Housing 50 CDBG Projects - Vehicle Repair - Outsourced 85.00 180 -50-530-6102-00-01-63321 CDBG AMEND#2 Housing 50 CDBG Projects - Recording Fees 4,133.00 180 -50-530-6102-00-01-64050 CDBG AMEND#2 Housing 50 CDBG Projects - Printing 40.00 180 -50-530-6102-00-01-64140 CDBG AMEND#2 Housing 50 CDBG Projects - Copying 1,116.00 180 -50-530-6102-00-01-64145 CDBG AMEND#2 Housing 50 CDBG Projects - Rental - Equipment 26.00 180 -50-530-6102-00-01-64150 CDBG AMEND#2 Housing 50 CDBG Projects - Rental - Land/Bldgs/Parking 2,256.00 180 -50-530-6102-00-01-64160 CDBG AMEND#2 Housing 50 CDBG Projects - Technology Services 7,700.00 180 -50-530-6102-00-01-64190 CDBG AMEND#2 Housing 50 CDBG Projects - IT Recharges 7,607.00 180 -50-530-6102-00-01-64191 CDBG AMEND#2 Housing 50 CDBG Projects - Technology Equipment 2,514.00 180 -50-530-6102-00-01-65045 CDBG AMEND#2 Housing 50 CDBG Projects - Office Supplies 100.00 180 -50-530-6102-00-01-65060 CDBG AMEND#2 Housing 50 CDBG Projects - Postage/Shipping 564.00 180 -50-530-6102-00-01-65080 CDBG AMEND#2 Housing 50 CDBG - Code Enforcement - Salaries -Regular Full Time 2,500.00 180 -50-530-6103-00-01-60100 CDBG AMEND#2 Housing 50 CDBG Administration - Community Dev Block Grants - 201,019.00 180 -50-530-6150-04-01-44050 CDBG AMEND#2 Housing 50 CDBG Administration - Community Dev Block Grants 881,758.00 180 -50-530-6150-04-01-44050 CDBG AMEND#2 Housing 50 CDBG Administration - Community Dev Block Grants 779,904.00 180 -50-530-6150-04-01-44050 CDBG AMEND#2 Housing 76 Capital Projects - Loans 163,201.00 - 180 -76-750-6170-00-02-64134 CDBG AMEND#2 Housing 76 Neighborhood Reinvestment - Loans (103,000.00) 180 -76-750-6170-00-02-64134 CDBG AMEND#2 Housing 76 CDBG - FY24 Homebuyer Assistance - Loans 50,000.00 180 -76-750-6170-00-02-64134 CDBG AMEND#2 Housing 76 Neighborhood Reinvestment - Loans (183,880.00) 180 -76-750-6170-00-02-64134 CDBG AMEND#2 Housing 76 CDBG - FY24 Homeowner Rehab - Loans 125,000.00 180 -76-750-6170-00-02-64134 CDBG AMEND#2 Housing 76 Neighborhood Reinvestment - Loans (234,473.00) 180 -76-750-6170-00-02-64134 CDBG AMEND#2 Housing 76 Capital Projects - Loans 16,350.00 180 -76-750-6170-00-02-64134 CDBG AMEND#2 Housing 76 CDBG LHH Match - 2021 - Loans 155,551.00 180 -76-750-6170-00-02-64134 CDBG AMEND#2 Housing 76 AHNI - 90 Main - Grants 528,100.00 180 -76-750-6170-00-02-64135 CDBG AMEND#2 Housing 76 Neighborhood Reinvestment - Grants (234,114.00) 180 -76-750-6170-00-02-64135 CDBG AMEND#2 Housing 76 CDBG - Ecumenical Towers - Grants 380,000.00 180 -76-750-6170-00-02-64135 CDBG AMEND#2 Housing 76 Capital Projects - Grants (4,485.00) 180 -76-750-6170-00-02-64135 CDBG AMEND#2 Housing 76 Capital Projects - Grants 4,485.00 180 -76-750-6170-00-02-64135 CDBG AMEND#2 Housing 76 HOMELESS SHELTER REHAB - Grants (130,078.00) 180 -76-750-6170-00-02-64135 CDBG AMEND#2 Housing 76 Capital Projects - Grants (32,000.00) 180 -76-750-6170-00-02-64135 CDBG AMEND#2 Housing 76 Neighborhood Reinvestment - Grants (295,363.00) 180 -76-750-6170-00-02-64135 CDBG AMEND#2 Housing 76 Lincoln Elementary Wellness Project - Other Capital Outlay (263,632.00) 180 -76-750-6170-00-02-67990 CDBG AMEND#2 Housing 76 Capital Projects - Grants 281,863.00 180 -76-750-6170-00-02-64135 CDBG AMEND#2 Housing 76 CDBG - Minor Const - MTCC - Grants 50,000.00 180 -76-750-6170-00-02-64135 CDBG AMEND#2 Housing 76 CDBG - FY24 PS Four Mounds - Grants 85,000.00 180 -76-750-6170-00-02-64135 CDBG AMEND#2 Housing 76 Capital Projects - Payments to Other Agencies (20,000.00) 180 -76-750-6170-00-02-64130 CDBG AMEND#2 Housing 76 Neighborhood Reinvestment - Payments to Other Agencies 93,796.00 180 -76-750-6170-00-02-64130 CDBG AMEND#2 Housing 76 Credit Repair Program - Payments to Other Agencies (29,997.00) 180 -76-750-6170-00-02-64130 CDBG AMEND#2 FISCAL YEAR 2024 AMENDMENT #2 COUNCIL DETAIL FY24 FY24 Department Program Description Expense Revenue Fund Account Explanation Housing 76 IEDA - Shelter Rehabilitation - Payments to Other Agencies (10,608.00) 180 -76-750-6170-00-02-64130 CDBG AMEND#2 Housing 76 IEDA - NPSG - Opening Doors - Payments to Other Agencies 16,107.00 180 -76-750-6170-00-02-64130 CDBG AMEND#2 Housing 76 IEDA - NPSG - Dream Center - Payments to Other Agencies 16,107.00 180 -76-750-6170-00-02-64130 CDBG AMEND#2 Housing 76 IEDA - NPSG - Riverview Center - Payments to Other Agencies 16,107.00 180 -76-750-6170-00-02-64130 CDBG AMEND#2 Planning 50 CDBG - Zoning Enforcement - Services Other Depts (1,000.00) 180 -50-510-6201-00-01-64005 CDBG AMEND#2 Planning 50 Administration - Services Other Depts (8,710.00) 180 -50-510-6201-00-01-64005 CDBG AMEND#2 Planning 50 CDBG - FY24 Zoning Enforcement - Services Other Depts 8,710.00 180 -50-510-6201-00-01-64005 CDBG AMEND#2 Housing 76 Neighborhood Reinvestment - Grants 30,544.00 181 -76-750-6170-00-02-64135 CDBG AMEND#2 Housing 76 BROADBAND CARES ACT - Grants (19,456.00) 181 -76-750-6170-00-02-64135 CDBG AMEND#2 Housing 76 Dubuque Area Labor Harvest - Grants (23,954.00) 181 -76-750-6170-00-02-64135 CDBG AMEND#2 TOTAL COMMUNITY DEVELOPMENT BLOCK FUND 366,749.00 1,862,681.00 STATE RENTAL REHAB FUND Housing 50 CDBG Administration - Community Dev Block Grants - (201,019.00) 186 -50-530-6150-04-01-44050 Adjust to Actual Housing 50 CDBG Administration - Community Dev Block Grants (881,758.00) 186 -50-530-6150-04-01-44050 Adjust to Actual Housing 50 CDBG Administration - Community Dev Block Grants (779,904.00) 186 -50-530-6150-04-01-44050 Adjust to Actual TOTAL STATE RENTAL REHAB FUND (1,862,681.00) HOUSING CHOICE VOUCHER FUND Housing 50 HCV Admin Fee - Housing & Urban Development (38,389.00) 189 -50-530-6107-04-01-44100 Adjust to Actual Housing 50 Housing Choice Voucher - Housing & Urban Development (74,592.00) 189 -50-530-6107-04-01-44100 Adjust to Actual Housing 50 Housing Choice Voucher Program(HCV) - Housing & Urban Development 1,350,017.00 189 -50-530-6107-04-01-44100 Adjust to Actual Housing 50 Housing Choice Voucher Program(HCV) - Housing Assistance Payment 1,153,458.00 - 189 -50-530-6107-00-01-64088 Adjust to Actual Housing 50 Housing Choice Voucher - Interest (3,299.00) 189 -50-530-6107-60-01-43000 Adjust to Actual TOTAL HOUSING CHOICE VOUCHER FUND 1,153,458.00 1,233,737.00 STREET CONSTRUCTION FUND Engineering 76 Hyperflow Pilot Grant - Traffic Sig - Federal Grants - 80,000.00 301 -76-750-5570-05-02-44000 New Grant Engineering 76 Hyperflow Pilot Grant - Traffic Sig - Traffic St Light Comp/Equip 80,000.00 - 301 -76-750-5570-00-02-65055 New Grant TOTAL STREET CONSTRUCTION FUND 80,000.00 80,000.00 SALES TAX FUND (20%) Engineering 76 Harbor Area Maintenance - Contrib - Private Sources - 100,000.00 304 -76-750-5570-00-02-47050 New Grant Engineering 76 Harbor Area Maintenance - Other Capital Outlay 100,000.00 - 304 -76-750-5570-00-02-67990 New Grant Engineering 76 Harbor Area Maintenance - Iowa Dept of Natural Resources - 200,000.00 304 -76-750-5570-05-02-44500 New Grant Engineering 76 Harbor Area Maintenance - Contrib - Private Sources - 117,500.00 304 -76-750-5570-00-02-47050 New Grant Engineering 76 Harbor Area Maintenance - Other Capital Outlay 317,500.00 - 304 -76-750-5570-00-02-67990 New Grant TOTAL SALES TAX FUND 417,500.00 417,500.00 GENERAL CONSTRUCTION FUND Engineering 76 3rd Main Chamber Ext Patio Repair - Engineering - Internal 25,000.00 - 305 -76-750-5570-00-02-64075 Adjust to Actual Engineering 76 3rd Main Chamber Ext Patio Repair - Buildings 175,000.00 305 -76-750-5570-00-02-67500 Adjust to Actual TOTAL GENERAL CONSTRUCTION FUND 200,000.00 SANITARY OPERATING FUND Engineering 80 Project Engineering - Vehicles (35,000.00) 610 -80-815-5502-00-01-67100 Adjust to Actual TOTAL SANITARY OPERATING FUND (35,000.00) SANITARY SEWER CONSTRUCTION FUND Engineering 80 Granger Creek Lift St Improv Federal Grants - 1,000,000.00 611 -80-815-5570-03-02-44000 New Grant Engineering 80 Granger Creek Lift St Improv Other Capital Outlay 1,000,000.00 - 611 -80-815-5570-00-02-67990 New Grant TOTAL SANITARY SEWER CONST FUND 1,000,000.00 1,000,000.00 STORMWATER OPERATING FUND Public Works 82 Stormwater Maintenance - Consulting Engineers 14,500.00 620 -82-865-5417-00-01-64850 Shift from Bld Mtn Engineering 82 Stormwater Operations - Vehicles 35,000.00 620 -82-865-5507-00-01-67100 Adjust to Actual TOTAL STORMWATER OPERATING FUND 49,500.00 STORM WATER CONSTRUCTION FUND Engineering 80 Bee Branch Gate&pump replc - Other Capital Outlay 5,200,000.00 621 -80-865-5570-00-02-67990 New Grant FISCAL YEAR 2024 AMENDMENT #2 Department Program Description Engineering 82 Bee Branch Gate&pump replc - Federal Grants TOTAL STORM WATER CONST FUND REFUSE COLLECTION OPERATING Public Works 85 Recycling Collection - Other Local Grants/Contrib TOTAL REFUSE COLLECTION OPERATING REFUSE COLLECTION CAPITAL Public Works 85 Solid Waste Vehicles Other Capital Equipment Public Works 85 Solid Waste Vehicles Other Capital Equipment TOTAL REFUSE COLLECTION CAPITAL TRANSFERS Engineering Trans1 Transfer from GDTIF to General Construction Fund Engineering Trans1 Transfer from GDTIF to General Construction Fund Public Works Trans2 Transfer from General Fund to Road Use Tax Public Works Trans2 Transfer from General Fund to Road Use Tax Public Works Trans3 Transfer from General Fund to Stormwater Operating Fund Public Works Trans3 Transfer from General Fund to Stormwater Operating Fund TOTAL TRANSFERS TOTAL AMEND #2 COUNCIL DETAIL FY24 FY24 Expense Revenue Fund Account Explanation - 5,200,000.00 621 -82-865-5570-05-02-44000 New Grant 5,200,000.00 5,200,000.00 19,350.00 670 -85-840-5414-04-01-44900 Adjust to Actual 19,350.00 (628,843.00) - 671 -85-840-5470-00-02-67270 Adjust to Actual (369,412.00) 671 -85-840-5470-00-02-67270 Adjust to Actual (998,255.00) 200,000.00 126 -50-520-0000-00-01-69305 Transfer Funds - 200,000.00 305 -76-750-5570-90-02-49126 Transfer Funds 83,798.00 - 100 -00-000-0000-00-01-69110 Transfer Funds - 83,798.00 110 -20-210-5406-90-01-49100 Transfer Funds 14,500.00 - 100 -00-000-0000-00-01-69620 Transfer Funds - 14,500.00 620 -82-865-5507-90-01-49100 Transfer Funds 298,298.00 298,298.00 10,606,595 9,981,018