The URL can be used to link to this page

Fiscal Year 2022 Second Budget Amendment_InitiateCity of Dubuque City Council Meeting Copyrighted April 18, 2022 Items to be set for Public Hearing # 4. ITEM TITLE: Fiscal Year 2022 Second Budget Amendment SUMMARY: City Manager recommending the second Fiscal Year 2022 Budget Amendment be set for public hearing for May 2, 2022. RESOLUTION Setting the date for the public hearing on Amendment No. 2 to the Fiscal Year 2022 Budget for the City of Dubuque SUGGESTED Receive and File; Adopt Resolution(s), Set Public Hearing for May 2, DISPOSITION: 2022Suggested Disposition: ATTACHMENTS: Description Type MVM Memo City Manager Memo Staff Memo Staff Memo Resolution Resolutions Council Amendment Detail Supporting Documentation Notice of Public Hearing 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 2022 Second Budget Amendment DATE: April 13, 2022 Dubuque All-Amarica City wvx?vv.iT;[u 2007-2012.2013 2017*2019 Director of Finance and Budget Jennifer Larson is recommending the second Fiscal Year 2022 Budget Amendment be set for public hearing for May 2, 2022. 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, Director of Finance and Budget THE C DUUB-.'&-FE Masterpiece on the Mississippi TO: Michael C. Van Milligen, City Manager FROM: Jennifer Larson, Director of Finance and Budget SUBJECT: Fiscal Year 2022 Second Budget Amendment DATE: April 13, 2022 Dubuque AII•Amerin City nwxnw�� Kw 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 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 2022 budget was adopted in September 2021 and adjustments to reflect new grants and reallocation of funding. A decrease of interfund transfers of $3,431,263 is also included. The amendment totals $6,484,238 in increased appropriation authority and an increase in resources of $7,129,164. Additional revenues added in this amendment with offsetting appropriations are: • Dubuque Industrial Center West General Obligation Bonds for property purchase ($5,200,000), • Healthy Homes Production Grant ($672,350) • Iowa Economic Development Authority CARES Act Grant ($521,469), • Community Development CARES Act Grant ($317,955), • Iowa SWAP Funds for Northwest Arterial Rehab ($1,431,420), • AmeriCorps Grants ($235,238) and related Private Participation ($3,710), • Sale of Rehabilitated Homes — Housing Rehab Program ($143,264), • Airport State Grant for New Hangars ($2,783,502), Reduced revenues reflected in this amendment with offsetting reductions in appropriations include: Transit Federal Transportation Administration Operating Assistance reduced by CARES Act funding (-$663,221), New Downtown Parking Ramp Bond Proceeds (-$2,948,570) ramp delayed, Dual Packer Recycling Vehicle Bond Proceeds (-$175,000) truck delayed, High Strength Waste Receive and Storage SRF Proceeds (-$857,395) replaced by American Rescue Plan Act Funds, Center Place Alley Sewer Reconstruction SRF Proceeds (-$372,000) replaced by American Rescue Plan Act Funds, and Southwest Arterial Water Main Extension Federal Grant (42,160,000). This amendment includes an increase of $728,753 for Community Development Block Grant (CDBG) related programs. The increase in CDBG programs include Mount Pleasant Elevator ($36,000), Purchase/Resale/Rehab ($233,749), First Time Homebuyer ($60,000), Henry Stout Apartments ($350,000), Four Mounds Build Dubuque ($152,425), AHNI Agreement ($221,900), Low/Mod Income Parks ($67,432), Window Replacement Program ($17,672), Rental and Mortgage Assistance ($28,000), and Energy Saver Program ($65,000). Decreases in CDBG programs include Rental Rehab Loans (-$125,000), Rental Rehab Unit (-$17,672), Neighborhood Related Improvements (-$42,800), St. Mark Community Center (-$10,000), Bus Stop Improvements (-$22,272), CD Target Area Program (-$34,425), Rehab Program (-$60,695), General Housing Inspection (-$34), Race in Heartland (-$1,983), Neighborhood Grants (-$8,586), Low Income Small Business Grant (-$25,000), Sidewalks (-$15,000), Credit Repair Program (-$50,000), and Aquaponics Systems (-$90,958). This amendment also creates a budget for the Mystique Community Ice Arena, which includes $632,941 in revenue and $844,909 in expense. The net deficit of $211,968 is funded by vacancy savings in various Leisure Services activities. In addition, this amendment adds the Leisure Services Project Manager position for the remainder of the fiscal year ($33,701), which is also funded by vacancy savings in various Leisure Services Activities. The vacancy savings by Leisure Services activity is as follows: Parks vacancies ($131,643), Port of Dubuque Marina vacancies ($35,128), Swimming Pool vacancies ($16,040), Multicultural Family Center vacancies ($62,864). American Rescue Plan Act Funds (ARPA) project allocation was revised during the Fiscal Year 2023 budget process. The reallocations that impact Fiscal Year 2022 projects include: • Reduction in funding to Catfish Creek Lift Station Force Main (-$3,546,614), • Increase in funding to Old Mill Lift Station (+$3,546,614), • Allocation of funding to Police Patrol Vehicles and Accessories (+$337,060), • Allocation of funding to Grand River Center Equipment (+$87,940), and • Reduction in funding to Utility Bill Assistance (-$400,000) In the first amendment in Fiscal Year 2023, additional amendments will be made to the allocation of American Rescue Plan Act Funds. It has been determined that using ARPA funds to purchase tipper carts for city-wide implementation is an allowable expense based on the United States Treasury final rules. However, due to a citizen objection, staff has determined that based on the availability of other funding, the tipper carts will be funded with Fiscal Year 2022 Dubuque Racing Association rent instead of ARPA funds. 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 2, 2022. Attachments JML 3 Prepared by Jennifer Larson Director of Finance and Budget 50 W. 13'h St Dubuque IA 52001 (563) 589 4322 Return to Adrienne N. Breitfelder, City Clerk, 50 W. 1311 St., Dubuque, IA 52001, (563) 589-4100 RESOLUTION NO. 139-22 SETTING THE DATE FOR THE PUBLIC HEARING ON AMENDMENT NO. 2 TO THE FISCAL YEAR 2022 BUDGET FOR THE CITY OF DUBUQUE Whereas, Iowa Code Section 384.18 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 384.16. 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 2022 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 2, 2022, 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 181h day of April 2022. Attest: Adrienne N. Breitfelder, City Clerk Bra avanagh, Mayor FISCAL YEAR 2022 AMENDMENT #2 COUNCIL DETAIL FY22 FY22 Expense Revenue Department Program Description Amount Amount Fund Activity/CIP Account Explanation GENERALFUND ENGINEERING 2C CATFISH CREEK LIFT STATIONS FORCE MAIN - ENGINEERING (1,200,000) 100 1001050 62712 Adjust to Actual ENGINEERING 2C CATFISH CREEK LIFT STATIONS FORCE MAIN - CONSTRUCTION (2,346,614) 100 1001050 73211 Adjust to Actual ENGINEERING 2C OLD MILL ROAD LIFT STATION DESIGN 3,546,614 100 1001653 62712 Adjust to Actual ENGINEERING 6C 18TH STREET BULDING IMPROVEMENTS- FULL-TIME EMPLOYEES 425 100 1001975 61010 Adjust to Actual ENGINEERING 6C 18TH STREET BULDING IMPROVEMENTS- IPERS 40 100 1001975 61310 Adjust to Actual ENGINEERING 6C 18TH STREET BULDING IMPROVEMENTS- SOCIAL SECURITY 31 100 1001975 61320 Adjust to Actual ENGINEERING 6C 18TH STREET BULDING IMPROVEMENTS- HEALTH 89 100 1001975 61410 Adjust to Actual ENGINEERING 6C 18TH STREET BULDING IMPROVEMENTS- CONSULTANT SERVICES 79,415 100 1001975 62716 Adjust to Actual ENGINEERING 2C SINKHOLE MINE REMEDIATION - REIMBURSEMENT 150,000 100 1002823 53620 Adjust to Actual ENGINEERING 2C SINKHOLE MINE REMEDIATION- FULL-TIME EMPLOYEES 7,788 100 1002823 61010 Adjust to Actual ENGINEERING 2C STREETS- SINKHOLE IPERS 735 100 1002823 61310 Adjust to Actual ENGINEERING 2C SINKHOLE MINE REMEDIATION - SOCIAL SECURITY 567 100 1002823 61320 Adjust to Actual ENGINEERING 2C STREETS- SINKHOLE HEALTH 1,125 100 1002823 61410 Adjust to Actual ENGINEERING 2C SINKHOLE MINE REMEDIATION - LIFE INSURANCE 6 100 1002823 61416 Adjust to Actual ENGINEERING 2C SINKHOLE MINE REMEDIATION - LEGAL SERVICES 41 100 1002823 62130 Adjust to Actual ENGINEERING 2C SINKHOLE MINE REMEDIATION - CONSTRUCTION CONTRACT 154,739 100 1002823 73211 Adjust to Actual PARKS 4C RENOVATE PAR WATER SYSTEM - CONSTRUCTION (7,000) 102 1021158 73211 Adjust to Actual PARKS 4C EAGLE VALLEY PARK DEV-CONSTRUCTION CONTRACT -NOT BUILDING (180,447) 102 1022288 73211 Adjust to Actual PARKS 4C RESTROOM ELECTRIC LOCKS - CONSTRUCTION (8,866) 102 1022708 73210 Adjust to Actual POLICE 10 POLICE ADMINISTRATION- FULL TIME EMPLOYEE EXPENSE (63,246) 100 10011100 61010 Shift to AmeriCorps POLICE 10 POLICE ADMINISTRATION- IPERS (5,971) 100 10011100 61310 Shift to AmeriCorps POLICE 10 POLICE ADMINISTRATION- SOCIAL SECURITY (4,838) 100 10011100 61320 Shift to AmeriCorps POLICE 10 POLICE ADMINISTRATION- LIFE INSURANCE (55) 100 10011100 61416 Shift to AmeriCorps POLICE 10 POLICE ADMINISTRATION- PROPERTY MAINTENANCE (34,000) 100 10011100 62431 Shift to Ammunition POLICE 10 POLICE TRAINING- AMMUNITION 34,000 100 10011250 62647 Shift from Prop Maint POLICE 10 POLICE PATROL VEHICLES 224,122 100 10011700 71310 Adjust to Actual POLICE 10 POLICE VEHICLE ACCESSORIES 112,938 100 10011700 71329 Adjust to Actual FIRE 10 AMBULANCE - REFUNDS 18,860 100 10013300 62204 Adjust to Actual FIRE 10 FIRE PREVENTION - REIMBURSEMENTS 25,500 100 10013700 53620 New Grant FIRE 10 FIRE PREVENTION - PROGRAM EQUIP 25,500 100 10013700 62668 New Grant Approp PARKS 40 PARK AREAS AND MAINTENANCE- FULL TIME EMPLOYEE (14,780) 100 10030400 61010 Shift to Ice Center PARKS 40 PARK AREAS AND MAINTENANCE- IPERS (1,395) 100 10030400 61310 Shift to Ice Center PARKS 40 PARK AREAS AND MAINTENANCE- SOCIAL SECURITY (1,131) 100 10030400 61320 Shift to Ice Center PARKS 40 PARK AREAS AND MAINTENANCE- UNEMPLOYMENT (28,500) 100 10030400 61417 Shift to Ice Center PARKS 40 DOWNTOWN MAINTENANCE- FULL TIME EMPLOYEES (27,283) 100 10030430 61010 Shift Sav to Ice Center PARKS 40 DOWNTOWN MAINTENANCE- PART TIME EMPLOYEES (33,642) 100 10030430 61020 Shift Sav to Ice Center PARKS 40 DOWNTOWN MAINTENANCE- IPERS (5,752) 100 10030430 61310 Shift Sav to Ice Center PARKS 40 DOWNTOWN MAINTENANCE- SOCIAL SECURITY (4,660) 100 10030430 61320 Shift Sav to Ice Center PARKS 40 GREENHOUSE -UNEMPLOYMENT (14,500) 100 10030500 61417 Shift to Ice Center RECREATION 40 POD MARINA CSTORE- FULL TIME EMPLOYEE (15,000) 100 10030550 61010 Shift Sav to Ice Center RECREATION 40 POD MARINA CSTORE- IPERS (1,416) 100 10030550 61310 Shift Sav to Ice Center RECREATION 40 POD MARINA CSTORE- SOCIAL SECURITY (1,148) 100 10030550 61320 Shift Sav to Ice Center RECREATION 40 POD MARINA DOCKS- FULL TIME EMPLOYEE (15,000) 100 10030560 61010 Shift Sav to Ice Center RECREATION 40 POD MARINA DOCKS- IPERS (1,416) 100 10030560 61310 Shift Sav to Ice Center RECREATION 40 POD MARINA DOCKS- SOCIAL SECURITY (1,148) 100 10030560 61320 Shift Sav to Ice Center CIVIC CENTER 40 CIVIC CENTER- FEDERAL GRANT 362,080 100 10032100 44170 New Grant CIVIC CENTER 40 CIVIC CENTER- PAY TO OTHER AGENCY 159,080 100 10032100 62761 Grant Approp CIVIC CENTER 40 CIVIC CENTER- EQUIPMENT ACQUISITION 203,000 100 10032100 73411 Grant Approp CONFERENCE CENTER 60 GRC EQUIPMENT ACQUISITION 87,940 100 10033300 73411 Adjust to Actual FISCAL YEAR 2022 AMENDMENT #2 COUNCIL DETAIL FY22 FY22 Expense Revenue Department Program Description Amount Amount Fund Activity/CIP Account Explanation RECREATION 40 RECREATION ADMINISTRATION- FULL TIME EMPLOYEES 13,926 100 10034100 61010 Adjust to Actual RECREATION 40 RECREATION ADMINISTRATION- IPERS 1,315 100 10034100 61310 Adjust to Actual RECREATION 40 RECREATION ADMINISTRATION- SOCIAL SECURITY 1,065 100 10034100 61320 Adjust to Actual RECREATION 40 RECREATION ADMINISTRATION- LIFE INSURANCE 15 100 10034100 61416 Adjust to Actual RECREATION 40 RECREATION ADMINISTRATION- OFFICE SUPPLIES 100 100 10034100 62010 Adjust to Actual RECREATION 40 RECREATION ADMINISTRATION- LEGAL NOTICES & ADS 2,000 100 10034100 62130 Adjust to Actual RECREATION 40 RECREATION ADMINISTRATION- MILEAGE/LOCAL TRANSP 200 100 10034100 62340 Adjust to Actual RECREATION 40 RECREATION ADMINISTRATION- TELEPHONE 206 100 10034100 62421 Adjust to Actual RECREATION 40 RECREATION ADMINISTRATION- DATA SERVICES 150 100 10034100 62667 Adjust to Actual RECREATION 40 RECREATION ADMINISTRATION- PERIPHERALS, COMPUTER 1,050 100 10034100 71120 Adjust to Actual RECREATION 40 RECREATION ADMINISTRATION- SOFTWARE 1,811 100 10034100 71123 Adjust to Actual RECREATION 40 RECREATION ADMINISTRATION- COMPUTER 2,400 100 10034100 71124 Adjust to Actual RECREATION 40 RECREATION ADMINISTRATION- DESKS/CHAIRS 4,000 100 10034100 71211 Adjust to Actual RECREATION 40 RECREATION ADMINISTRATION- OTHER SAFETY EQUIP 500 100 10034100 72113 Adjust to Actual RECREATION 40 RECREATION ADMINISTRATION- PAGER/RADIO EQUIP 4,188 100 10034100 72410 Adjust to Actual RECREATION 40 RECREATION ADMINISTRATION- TELEPHONE RELATED 775 100 10034100 72418 Adjust to Actual RECREATION 40 SWIMMING- SEASONAL EMPLOYEE (13,699) 100 10034300 61030 Shift Sav to Ice Center RECREATION 40 SWIMMING- IPERS (1,293) 100 10034300 61310 Shift Sav to Ice Center RECREATION 40 SWIMMING- SOCIAL SECURITY (1,048) 100 10034300 61320 Shift Sav to Ice Center RECREATION 40 ICE ARENA- GIFT CERTIFICATES- GOLF 2,691 100 10034550 51938 Adjust to Actual RECREATION 40 ICE ARENA- VARIOUS PROGRAM FEES 5,100 100 10034550 51950 Adjust to Actual RECREATION 40 ICE ARENA -MEETING ROOM FEES 850 100 10034550 51953 Adjust to Actual RECREATION 40 ICE ARENA- BEER 125,000 100 10034550 51959 Adjust to Actual RECREATION 40 ICE ARENA- FOOD 115,000 100 10034550 51960 Adjust to Actual RECREATION 40 ICE ARENA- LIQUOR 42,000 100 10034550 51962 Adjust to Actual RECREATION 40 ICE ARENA- EVENTS REVENUE 350 100 10034550 51965 Adjust to Actual RECREATION 40 ICE ARENA- PRO SHOP SALES 950 100 10034550 51966 Adjust to Actual RECREATION 40 ICE ARENA- BEVERAGE/ICE 70,000 100 10034550 51967 Adjust to Actual RECREATION 40 ICE ARENA- ICE RENTAL FEE 197,000 100 10034550 51969 Adjust to Actual RECREATION 40 ICE ARENA- FREESTYLE ICE RENT 2,200 100 10034550 51970 Adjust to Actual RECREATION 40 ICE ARENA- CIVIC CENTER RENT SKATES 10,200 100 10034550 51971 Adjust to Actual RECREATION 40 ICE ARENA- PUBLIC SKATING 26,000 100 10034550 51979 Adjust to Actual RECREATION 40 ICE ARENA- CREDIT CARD TIPS 16,000 100 10034550 51980 Adjust to Actual RECREATION 40 ICE ARENA- GIFT CARD- GOLF 7,500 100 10034550 51989 Adjust to Actual RECREATION 40 ICE ARENA- HOCKEY ICE RENT WALKIN 2,600 100 10034550 51990 Adjust to Actual RECREATION 40 ICE ARENA- MISCELLANEOUS REVENUE 1,500 100 10034550 53605 Adjust to Actual RECREATION 40 ICE ARENA- REIMBURSEMENTS- GENERAL 6,000 100 10034550 53620 Adjust to Actual RECREATION 40 ICE ARENA- SALES TAX COLLECTION 2,000 100 10034550 53630 Adjust to Actual RECREATION 40 ICE ARENA- FULL TIME EMPLOYEE 435 100 10034550 61010 Adjust to Actual RECREATION 40 ICE ARENA- SEASONAL EMPLOYEE 69,196 100 10034550 61030 Adjust to Actual RECREATION 40 ICE ARENA- OVERTIME 9,491 100 10034550 61050 Adjust to Actual RECREATION 40 ICE ARENA- IPERS 841 100 10034550 61310 Adjust to Actual RECREATION 40 ICE ARENA- SOCIAL SECURITY 6,053 100 10034550 61320 Adjust to Actual RECREATION 40 ICE ARENA- HEALTH INSURANCE 406 100 10034550 61410 Adjust to Actual RECREATION 40 ICE ARENA- LIFE INSURANCE 2 100 10034550 61416 Adjust to Actual RECREATION 40 ICE ARENA- EMPLOYEE PHYSICAL 1,562 100 10034550 61660 Adjust to Actual RECREATION 40 ICE ARENA- OFFICE SUPPLIES 1,525 100 10034550 62010 Adjust to Actual RECREATION 40 ICE ARENA- JANITORIAL SUPPLIES 15,200 100 10034550 62062 Adjust to Actual RECREATION 40 ICE ARENA- PROMOTION 275 100 10034550 62140 Adjust to Actual RECREATION 40 ICE ARENA- DRAM SHOP INSURANCE 2,600 100 10034550 62205 Adjust to Actual FISCAL YEAR 2022 AMENDMENT #2 COUNCIL DETAIL FY22 FY22 Expense Revenue Department Program Description Amount Amount Fund Activity/CIP Account Explanation RECREATION 40 ICE ARENA- PROPERTY INSURANCE 16,693 100 10034550 62206 Adjust to Actual RECREATION 40 ICE ARENA- SALES TAX 11,000 100 10034550 62210 Adjust to Actual RECREATION 40 ICE ARENA- MILEAGE/LOCAL TRANSP 77 100 10034550 62340 Adjust to Actual RECREATION 40 ICE ARENA- EDUCATION & TRAINING 986 100 10034550 62360 Adjust to Actual RECREATION 40 ICE ARENA- UTILITY EXP- ELECTRICITY 90,000 100 10034550 62411 Adjust to Actual RECREATION 40 ICE ARENA- UTILITY EXP- GAS 18,200 100 10034550 62412 Adjust to Actual RECREATION 40 ICE ARENA- UTILITY EXPENSE- STORMWATER 1,950 100 10034550 62415 Adjust to Actual RECREATION 40 ICE ARENA- UTILITY EXP- REFUSE 4,100 100 10034550 62418 Adjust to Actual RECREATION 40 ICE ARENA- TELEPHONE 650 100 10034550 62421 Adjust to Actual RECREATION 40 ICE ARENA- PROPERTY MAINTENANCE 15,000 100 10034550 62431 Adjust to Actual RECREATION 40 ICE ARENA- MACH/EQUIP MAINTENANCE 7,000 100 10034550 62611 Adjust to Actual RECREATION 40 ICE ARENA- EQUIP MAINT CONTRACT 282 100 10034550 62614 Adjust to Actual RECREATION 40 ICE ARENA- FOOD PRODUCTS 12,500 100 10034550 62642 Adjust to Actual RECREATION 40 ICE ARENA- BEER PRODUCTS 34,300 100 10034550 62643 Adjust to Actual RECREATION 40 ICE ARENA LIQUOR PRODUCTS 3,550 100 10034550 62644 Adjust to Actual RECREATION 40 ICE ARENA- BEVERAGE/ICE 24,000 100 10034550 62649 Adjust to Actual RECREATION 40 ICE ARENA- SOFTWARE LICENSE EXPENSE 4,000 100 10034550 62663 Adjust to Actual RECREATION 40 ICE ARENA- LICENSE/PERMIT FEES 2,479 100 10034550 62664 Adjust to Actual RECREATION 40 ICE ARENA- DATA SERVICES 1,600 100 10034550 62667 Adjust to Actual RECREATION 40 ICE ARENA- PROGRAM EQUIP/SUPPLIES 2,700 100 10034550 62668 Adjust to Actual RECREATION 40 ICE ARENA- PRO SHOP MERCHANDISE 500 100 10034550 62670 Adjust to Actual RECREATION 40 ICE ARENA- CONSULTANT SERVICES 750 100 10034550 62716 Adjust to Actual RECREATION 40 ICE ARENA- MACH/EQUIPMENT RENTAL 60 100 10034550 62747 Adjust to Actual RECREATION 40 ICE ARENA- PAY TO OTHER AGENCY 452,000 100 10034550 62761 Adjust to Actual RECREATION 40 ICE ARENA- HEAVY EQUIP -REPLACEMENT 17,500 100 10034550 71318 Adjust to Actual RECREATION 40 ICE ARENA- BATTERY BACKUP SYSTEM 3,361 100 10034550 71406 Adjust to Actual RECREATION 40 ICE ARENA- CUSTODIAL EQUIPMENT 12,085 100 10034550 71610 Adjust to Actual MFC 40 MULTICULTURAL FAMILY CENTER- FULL TIME EMPLOYEE EXPENSE (53,689) 100 10034600 61010 Shift Sav to Ice Center MFC 40 MULTICULTURAL FAMILY CENTER - IPERS (5,068) 100 10034600 61310 Shift Sav to Ice Center MFC 40 MULTICULTURAL FAMILY CENTER- SOCIAL SECURITY (4,107) 100 10034600 61320 Shift Sav to Ice Center AMERICORPS 40 AMERICORPS- FULL TIME EMPLOYEE 21,474 100 10034911 61010 Shift from Police AMERICORPS 40 AMERICORPS- IPERS 725 100 10034911 61310 Shift from Police AMERICORPS 40 AMERICORPS- SOCIAL SECURITY 3,460 100 10034911 61320 Shift from Police AMERICORPS 40 AMERICORPS- HEALTH INSURANCE 16,463 100 10034911 61410 Shift from Police AMERICORPS 40 AMERICORPS- WORKERS COMPENSATION 700 100 10034911 61415 Shift from Police AMERICORPS 40 AMERICORPS- LIFE INSURANCE 14 100 10034911 61416 Shift from Police AMERICORPS 40 AMERICORPS- OFFICE SUPPLIES 2,500 100 10034911 62010 Shift from Police AMERICORPS 40 AMERICORPS- OFFICE SUPPLIES 300 100 10034911 62010 Shift from Police AMERICORPS 40 AMERICORPS- UNIFORM PURCHASES 500 100 10034911 62011 Shift from Police AMERICORPS 40 AMERICORPS- COPYING/REPRODUCTION 600 100 10034911 62110 Shift from Police AMERICORPS 40 AMERICORPS- LEGAL NOTICES & ADS 1,600 100 10034911 62130 Shift from Police AMERICORPS 40 AMERICORPS- DUES & MEMBERSHIPS 1,000 100 10034911 62190 Shift from Police AMERICORPS 40 AMERICORPS- TRAVEL- CITY BUSINESS 410 100 10034911 62320 Shift from Police AMERICORPS 40 AMERICORPS- MILEAGE/LOCAL TRANSP 1,550 100 10034911 62340 Shift from Police AMERICORPS 40 AMERICORPS- MEETING/WITNESS/JURY EXP 39,260 100 10034911 62341 Shift from Police AMERICORPS 40 AMERICORPS- EDUCATION & TRAINING 1,000 100 10034911 62360 Shift from Police AMERICORPS 40 AMERICORPS- TELEPHONE 1,560 100 10034911 62421 Shift from Police AMERICORPS 40 AMERICORPS- DATA SERVICES 750 100 10034911 62667 Shift from Police AMERICORPS 40 AMERICORPS- PERIPHERALS, COMPUTER 1,050 100 10034911 71120 Shift from Police AMERICORPS 40 AMERICORPS- SOFTWARE 3,622 100 10034911 71123 Shift from Police FISCAL YEAR 2022 AMENDMENT #2 COUNCIL DETAIL FY22 FY22 Expense Revenue Department Program Description Amount Amount Fund Activity/CIP Account Explanation AMERICORPS 40 AMERICORPS- COMPUTER 4,400 100 10034911 71124 Shift from Police AMERICORPS 40 AMERICORPS- FURNITURE 12,000 100 10034911 71156 Shift from Police AMERICORPS 40 AMERICORPS- TELEPHONE RELATED 830 100 10034911 72418 Shift from Police AMERICORPS 40 AMERICORPS- TELEPHONE RELATED 1,080 100 10034911 72418 Shift from Police AMERICORPS 40 AMERICORPS- FED PASS THRU STATE GRANT 105,600 100 10034913 45771 New Grant AMERICORPS 40 AMERICORPS- PART TIME EMPLOYEE 5,157 100 10034913 61020 Grant Approp AMERICORPS 40 AMERICORPS- SEASONAL EMPLOYEE 84,864 100 10034913 61030 Grant Approp AMERICORPS 40 AMERICORPS- IPERS 64 100 10034913 61310 Grant Approp AMERICORPS 40 AMERICORPS- SOCIAL SECURITY 6,887 100 10034913 61320 Grant Approp AMERICORPS 40 AMERICORPS- HEALTH INSURANCE (8,393) 100 10034913 61410 Adjust to Actual AMERICORPS 40 AMERICORPS- WORKERS COMPENSATION 4,112 100 10034913 61415 Grant Approp AMERICORPS 40 AMERICORPS- LIFE INSURANCE 10 100 10034913 61416 Grant Approp AMERICORPS 40 AMERICORPS- OTHER MEDICAL COSTS 9,600 100 10034913 61665 Grant Approp AMERICORPS 40 AMERICORPS- UNIFORM PURCHASES 232 100 10034913 62011 Grant Approp AMERICORPS 40 AMERICORPS- TRAVEL/CONFERENCES (175) 100 10034913 62310 Adjust to Actual AMERICORPS 40 AMERICORPS- EDUCATION & TRAINING 300 100 10034913 62360 Grant Approp AMERICORPS 40 AMERICORPS- SOFTWARE LICENSE EXP 544 100 10034913 62663 Grant Approp AMERICORPS 40 AMERICORPS- FINANCIAL SERVICE FEES 540 100 10034913 62727 Grant Approp AMERICORPS 40 AMERICORPS- PAY TO OTHER AGENCY 1,858 100 10034913 62761 Grant Approp AMERICORPS 40 AMERICORPS- FED PASS THRU STATE GRANT 29,799 100 10034916 45771 New Grant AMERICORPS 40 AMERICORPS- PART TIME EMPLOYEE 17,042 100 10034916 61020 Grant Approp AMERICORPS 40 AMERICORPS- IPERS 1,608 100 10034916 61310 Grant Approp AMERICORPS 40 AMERICORPS- SOCIAL SECURITY 1,304 100 10034916 61320 Grant Approp AMERICORPS 40 AMERICORPS- HEALTH INSURANCE 4,561 100 10034916 61410 Grant Approp AMERICORPS 40 AMERICORPS- MILEAGE/LOCAL TRANSP 500 100 10034916 62340 Grant Approp AMERICORPS 40 AMERICORPS- SOFTWARE LICENSE EXP 3,100 100 10034916 62663 Grant Approp AMERICORPS 40 AMERICORPS- LEADERSHIP TRAINING 500 100 10034916 62755 Grant Approp AMERICORPS 40 AMERICORPS- PAY TO OTHER AGENCY 1,184 100 10034916 62761 Grant Approp AMERICORPS 40 AMERICORPS- FED PASS THRU STATE GRANT 99,839 100 10034918 45771 New Grant AMERICORPS 40 AMERICORPS- PRIVATE PARTICIPANT 3,710 100 10034918 53102 Private Participant AMERICORPS 40 AMERICORPS- PART TIME EMPLOYEE 9,770 100 10034918 61020 Grant Approp AMERICORPS 40 AMERICORPS- SEASONAL EMPLOYEE 74,868 100 10034918 61030 Grant Approp AMERICORPS 40 AMERICORPS- IPERS 179 100 10034918 61310 Grant Approp AMERICORPS 40 AMERICORPS- SOCIAL SECURITY 6,475 100 10034918 61320 Grant Approp AMERICORPS 40 AMERICORPS- HEALTH INSURANCE 9,947 100 10034918 61410 Grant Approp AMERICORPS 40 AMERICORPS- WORKERS COMPENSATION 1,038 100 10034918 61415 Grant Approp AMERICORPS 40 AMERICORPS- LIFE INSURANCE 7 100 10034918 61416 Grant Approp AMERICORPS 40 AMERICORPS- UNIFORM PURCHASES (31) 100 10034918 62011 Adjust to Actual AMERICORPS 40 AMERICORPS-TRAVEL/CONFERENCES (1,000) 100 10034918 62310 Adjust to Actual AMERICORPS 40 AMERICORPS- EDUCATION & TRAINING 1,030 100 10034918 62360 Grant Approp AMERICORPS 40 AMERICORPS- SOFTWARE LICENSE EXP 54 100 10034918 62663 Grant Approp AMERICORPS 40 AMERICORPS- FINANCIAL SERVICE FEES 171 100 10034918 62727 Grant Approp AMERICORPS 40 AMERICORPS- PAY TO OTHER AGENCY 1,041 100 10034918 62761 Grant Approp LIBRARY 40 ADULT SERVICES- EBOOKS 3,018 100 10036200 62652 Lost Books LIBRARY 40 CHILDREN SERVICES - EBOOKS 1,635 100 10036210 62605 Lost Books LIBRARY 40 CIRCULATION SERVICES - BOOK FINES 4,653 100 10036220 53406 Lost Books PUBLIC WORKS 20 ST. & TRAFFIC LTNG - TRAFFIC CONTROL EQUIPMENT (1,004) 100 10054430 71411 Shift to Test Equip PUBLIC WORKS 20 ST. & TRAFFIC LTNG - TEST EQUIPMENT, OTHER 1,004 100 10054430 72515 Shift from Traffic Control ENGINEERING 20 ENGINEERING ADMINISTRATION - LAND SALES 80,000 100 10055100 54105 Adjust to Actual ECONOMIC DEVELOP 50 ECONOMIC DEVELOPMENT- PART-TIME EMPLOYEES 2,156 100 10060700 61020 New Grant Approp FISCAL YEAR 2022 AMENDMENT #2 COUNCIL DETAIL FY22 FY22 Expense Revenue Department Program Description Amount Amount Fund Activity/CIP Account Explanation ECONOMIC DEVELOP 50 ECONOMIC DEVELOPMENT- SOCIAL SECURITY/MEDICARE 165 100 10060700 61310 New Grant Approp ECONOMIC DEVELOP 50 ECONOMIC DEVELOPMENT- IPERS 204 100 10060700 61320 New Grant Approp HOUSING 50 ADMINISTRATION - FULL-TIME EMPLOYEES 45,000 100 10061100 61010 Adjust to Actual HOUSING 50 HEALTHY HOMES PRODUCTION - HUD PAYMENTS 456,350 100 10061125 44310 New Grant HOUSING 50 HEALTHY HOMES PRODUCTION - FULL-TIME EMPLOYEES 139,550 100 10061125 61010 New Grant Approp HOUSING 50 HEALTHY HOMES PRODUCTION - LOANS 316,800 100 10061125 62764 New Grant Approp HOUSING 10 BLDG CODE ADMIN - IA DESTRICT COURT FINES (5,293) 100 10061410 53403 Adjust to Actual HOUSING 10 BLDG CODE ADMIN - FULL-TIME EMPLOYEES (45,000) 100 10061410 61010 Adjust to Actual HOUSING 10 BLDG CODE ADMIN - UNIFORM PURCHASES 1,000 100 10061410 62011 Adjust to Actual HOUSING 10 BLDG CODE ADMIN - PRINTING & BINDING 600 100 10061410 62090 Adjust to Actual HOUSING 10 BLDG CODE ADMIN - SUBSCRIPTIONS -BOOKS -MAPS 2,000 100 10061410 62170 Adjust to Actual HOUSING 10 BLDG CODE ADMIN - DUES & MEMBERSHIPS 1,500 100 10061410 62190 Adjust to Actual HOUSING 10 BLDG CODE ADMIN - GENERAL LIABILITY INSURANCE 450 100 10061410 62208 Adjust to Actual HOUSING 10 BLDG CODE ADMIN - EDUCATION & TRAINING 600 100 10061410 62360 Adjust to Actual HOUSING 10 BLDG CODE ADMIN - TELEPHONE 500 100 10061410 62421 Adjust to Actual HOUSING 10 BLDG CODE ADMIN - PROPERTY MAINTENANCE 500 100 10061410 62431 Adjust to Actual HOUSING 10 BLDG CODE ADMIN - RENTAL OF SPACE 1,000 100 10061410 62436 Adjust to Actual HOUSING 10 BLDG CODE ADMIN - SOFTWARE LICENSE EXP 20,417 100 10061410 62663 Adjust to Actual HOUSING 10 BLDG CODE ADMIN - DATA SERVICES 1,000 100 10061410 62667 Adjust to Actual HOUSING 10 ELECTRICAL CODE ENF - ELECTRICAL PERMITS 10,251 100 10061420 42210 Adjust to Actual HOUSING 10 ELECTRICAL CODE ENF - INSURANCE CLAIMS 11,500 100 10061420 53610 Adjust to Actual HOUSING 10 ELECTRICAL CODE ENF - FULL-TIME EMPLOYEES 17,855 100 10061420 61010 Adjust to Actual HOUSING 10 ELECTRICAL CODE ENF - IPERS 1,746 100 10061420 61310 Adjust to Actual HOUSING 10 ELECTRICAL CODE ENF - SOCIAL SECURITY 1,216 100 10061420 61320 Adjust to Actual HOUSING 10 ELECTRICAL CODE ENF - AUTO/JEEP REPLACEMENT 37,000 100 10061420 71310 Adjust to Actual HOUSING 10 BUILDING CODE ENF - BUILDING PERMITS 115,000 100 10061430 42205 Adjust to Actual HOUSING 10 BUILDING CODE ENF - PERMIT, MISC 329 100 10061430 42260 Adjust to Actual HOUSING 10 BUILDING CODE ENF - PLAN CHECK FEES 45,306 100 10061430 51914 Adjust to Actual HOUSING 10 BUILDING CODE ENF - FULL-TIME EMPLOYEES 16,878 100 10061430 61010 Adjust to Actual HOUSING 10 BUILDING CODE ENF - IPERS 5,746 100 10061430 61310 Adjust to Actual HOUSING 10 BUILDING CODE ENF - SOCIAL SECURITY 5,216 100 10061430 61320 Adjust to Actual HOUSING 10 BUILDING CODE ENF - FUEL, MOTOR VEHICLE 2,004 100 10061430 62511 Adjust to Actual HOUSING 10 BUILDING CODE ENF - DATA SERVICES 514 100 10061430 62667 Adjust to Actual HOUSING 10 BUILDING CODE ENF - AUTO/JEEP REPLACEMENT 10,100 100 10061430 71310 Adjust to Actual HOUSING 10 PLUMB/MECH CODE ENF - MECHANCIAL PERMITS 7,206 100 10061440 42215 Adjust to Actual HOUSING 10 PLUMB/MECH CODE ENF - PLUMBING PERMITS 4,752 100 10061440 42220 Adjust to Actual HOUSING 10 PLUMB/MECH CODE ENF - FULL-TIME EMPLOYEES 17,855 100 10061440 61010 Adjust to Actual HOUSING 10 PLUMB/MECH CODE ENF - IPERS 1,746 100 10061440 61310 Adjust to Actual HOUSING 10 PLUMB/MECH CODE ENF - SOCIAL SECURITY 1,216 100 10061440 61320 Adjust to Actual HOUSING 50 GENERAL HOUSING INSP. - PARENTAL LEAVE 3,552 100 10061700 61095 Adjust to Actual HOUSING 50 GENERAL HOUSING INSP. - PRINTING & BINDING 200 100 10061700 62090 Adjust to Actual HOUSING 50 GENERAL HOUSING INSP. - COPYING/REPRODUCTION 1,000 100 10061700 62110 Adjust to Actual HOUSING 50 GENERAL HOUSING INSP. - SUBSCRIPTIONS -BOOKS -MAPS 300 100 10061700 62170 Adjust to Actual HOUSING 50 GENERAL HOUSING INSP. - GENERAL LIABILITY INSURAN 3,943 100 10061700 62208 Adjust to Actual HOUSING 50 GENERAL HOUSING INSP. - COURT COSTS & RECORD FEES 1,000 100 10061700 62230 Adjust to Actual HOUSING 50 GENERAL HOUSING INSP. - TRAVEL -CONFERENCES 700 100 10061700 62310 Adjust to Actual HOUSING 50 GENERAL HOUSING INSP. - RENTAL OF SPACE 700 100 10061700 62436 Adjust to Actual FISCAL YEAR 2022 AMENDMENT #2 COUNCIL DETAIL FY22 FY22 Expense Revenue Department Program Description Amount Amount Fund Activity/CIP Account Explanation HOUSING 50 GENERAL HOUSING INSP. - MOTOR VEH. MAINT. OUTSOUR 3,529 100 10061700 62528 Adjust to Actual HOUSING 50 GENERAL HOUSING INSP. - CREDIT CARD CHARGE 1,000 100 10061700 62666 Adjust to Actual HOUSING 50 GENERAL HOUSING INSP. - DATA SERVICES 900 100 10061700 62667 Adjust to Actual HOUSING 50 GENERAL HOUSING INSP. - PERIPHERALS, COMPUTER 4,410 100 10061700 71120 Adjust to Actual HOUSING 50 VACANT ABANDONED PROPERTY - CONTRACTR SERVICES 4,500 100 10061720 62710 Adjust to Actual HOUSING 50 VACANT ABANDONED PROPERTY - BUILDING DEMOLITION 5,210 100 10061720 62741 Adjust to Actual CMO 60 CITY MANAGER'S OFFICE - MISCELLANEOUS REVENUE 216,078 100 10072100 53605 New Grant CMO 60 SUSTAINABILITY - STATE GRANT 62,987 100 10072200 45701 New Grant CMO 60 SUSTAINABILITY - REIMBURSEMENTS 12,619 100 10072200 53620 Fire RLF Repay CMO 60 SUSTAINABILITY - PAY TO OTHER AGENCY 12,619 100 10072200 62761 Adjust to Actual CMO 60 SUSTAINABILITY - OTHER EQUIPMENT 62,987 100 10072200 73410 New Grant Approp ECONOMIC DEVELOP 40 ARTS & CULTURAL AFFAIRS- FED PASS THRU STATE GRANT 22,500 100 10072500 45771 New Grant ECONOMIC DEVELOP 40 ARTS & CULTURAL AFFAIRS- PART-TIME EMPLOYEES 4,244 100 10072500 61020 New Grant Approp ECONOMIC DEVELOP 40 ARTS & CULTURAL AFFAIRS- SOCIAL SECURITY/MEDICARE 325 100 10072500 61310 New Grant Approp ECONOMIC DEVELOPMEN' 40 ARTS & CULTURAL AFFAIRS- IPERS 401 100 10072500 61320 New Grant Approp ECONOMIC DEVELOPMEN' 40 ARTS & CULTURAL AFFAIRS- CONSULTANT SERVICES 15,000 100 10072500 62716 New Grant Approp HUMAN RESOURCES 60 HUMAN RESOURCES - FULL-TIME EMPLOYEES 23,158 100 10072700 61010 Adjust to Actual HUMAN RESOURCES 60 HUMAN RESOURCES - IPERS 2,186 100 10072700 61310 Adjust to Actual HUMAN RESOURCES 60 HUMAN RESOURCES - SOCIAL SECURITY 1,771 100 10072700 61320 Adjust to Actual HUMAN RESOURCES 60 HUMAN RESOURCES - HEALTH INSURANCE 4,344 100 10072700 61410 Adjust to Actual HUMAN RESOURCES 60 HUMAN RESOURCES - LIFE INSURANCE 110 100 10072700 61416 Adjust to Actual OSPNS 50 OFFICE OF SHARED PROSPERITY NS - FULL TIME EMPLOYEE (25,000) 100 10072800 61010 Adjust to Actual OSPNS 50 OFFICE OF SHARED PROSPERITY NS- PART TIME EMPLOYEES (11,500) 100 10072800 61020 Adjust to Actual OSPNS 50 OFFICE OF SHARED PROSPERITY NS - IPERS (3,446) 100 10072800 61310 Adjust to Actual OSPNS 50 OFFICE OF SHARED PROSPERITY NS- SOCIAL SECURITY (2,792) 100 10072800 61320 Adjust to Actual FINANCE 60 UTILITY BILL/PARKING TKTS-GRANTS (400,000) 100 10074700 62765 Adjust to Actual TOTAL GENERAL FUND 2,122,287 2,453,707 TRANSIT FUND TRANSIT 80 TRANSIT ADMIN. - FTA OPERATING ASSISTANCE (530,282) 600 60053100 44160 Adjust to Actual TRANSIT 80 TRANSIT ADMIN. - FEDERAL STIMULUS GRANTS 304,549 600 60053100 44175 Adjust to Actual TRANSIT 80 BUS OPERATIONS - FTA OPERATING ASSISTANCE (732,663) 600 60053400 44160 Adjust to Actual TRANSIT 80 BUS OPERATIONS - FEDERAL STIMULUS GRANTS 473,743 600 60053400 44175 Adjust to Actual TRANSIT 80 MINI BUS OPERATIONS - FTA OPERATING ASSISTANCE (470,997) 600 60053500 44160 Adjust to Actual TRANSIT 80 MINI BUS OPERATIONS - FEDERAL STIMULUS GRANTS 304,549 600 60053500 44175 Adjust to Actual TRANSIT 80 BUS MAINTENANCE - FTA OPERATING ASSISTANCE (57,238) 600 60053700 44160 Adjust to Actual TRANSIT 80 BUS MAINTENANCE - FEDERAL STIMULUS GRANTS 45,118 600 60053700 44175 Adjust to Actual TOTAL TRANSIT FUND (663,221) ROAD USE TAX FUND PUBLIC WORKS 20 STREET MAINTENANCE - HEAVY EQUIP -REPLACEMENT (15,884) 250 25054400 71318 Shift to Dump Truck PUBLIC WORKS 2C AERIAL BUCKET TRUCK - TRUCK -REPLACEMENT (8,700) 250 2501839 71314 Shift to Dump Truck TOTAL ROAD USE TAX FUND (24,584) CUSTOMER FACILITY CHARGE FUND AIRPORT 2C NEW TERM GUIDANCE SIGNAGE - SIGNAGE 70,000 252 2522534 71227 Adjust to Actual TOTAL CUSTOMER FACILITY CHARGE FUND 70,000 FISCAL YEAR 2022 AMENDMENT #2 COUNCIL DETAIL FY22 FY22 Expense Revenue Department Program Description Amount Amount Fund Activity/CIP Account Explanation COMMUNITY DEVELOPMENT BLOCK GRANT FUND HOUSING 5C MOUNT PLEASANT ELEVATOR- CONST.CONTR-NOT BLDG 36,000 260 2601049 73211 CDBG Amend#2 HOUSING 5C RESIDENTIAL REHAB PROGRAM - LOANS (125,000) 260 2601065 62764 CDBG Amend#2 HOUSING 5C PURCHASE/RESALE/REHAB - SALE OF ASSETS OTHER 143,264 260 2601231 54104 CDBG Amend#3 HOUSING 5C PURCHASE/RESALE/REHAB - CONST CONTRACT-BLDG 233,749 260 2601231 73210 CDBG Amend#2 HOUSING 5C RENTAL REHAB UNIT - GRANTS (17,672) 260 2601233 62765 CDBG Amend#2 HOUSING 5C FIRST TIME HOMEBUYER PORG - LOANS 60,000 260 2601234 62764 CDBG Amend#3 HOUSING 2C NEIGHBORHOOD REL IMPROVEM - CONST.CONTR-NOT BLDG (42,800) 260 2601239 73211 CDBG Amend#2 HOUSING 5C HENRY STOUT APARTMENTS - CONST.CONTR-NOT BLDG 350,000 260 2601746 73211 CDBG Amend #3 HOUSING 5C ST MARK COMMUNITY CTR REH - GRANTS (10,000) 260 2601747 62765 CDBG Amend#2 HOUSING 5C FOUR MOUNDS BUILD DUBUQUE- GRANTS 152,425 260 2602082 62765 CDBG Amend #3 HOUSING 8C BUS STOP IMPROVEMENTS - EQUIP ACQUISITIONS (22,272) 260 2602235 73410 CDBG Amend#2 HOUSING 5C LOW INCOME SM BIZ GRANT - PRINCIPAL PAYMENTS 1,000 260 2602636 52101 CDBG Amend#2 HOUSING 40 CD TRAGET AREA FROG. - VARIOUS PROGRAM FEES 2,300 260 26034500 51950 CDBG Amend#3 HOUSING 40 CD TARGET AREA FROG. - SEASONAL EMPLOYEES (21,425) 260 26034500 61030 CDBG Amend#3 HOUSING 40 CD TARGET AREA FROG. - PROGRAM EQUIP/SUPPLIES (13,000) 260 26034500 62668 CDBG Amend#3 HOUSING 50 REHAB. PROGRAM - HOMEOWNER LOAN REPAYMENTS 20,000 260 26061300 43410 CDBG Amend#3 HOUSING 50 REHAB. PROGRAM - RENTAL LOAN REPAYMENTS 6,500 260 26061300 43415 CDBG Amend#3 HOUSING 50 REHAB. PROGRAM - FULL-TIME EMPLOYEES (60,695) 260 26061300 61010 CDBG Amend#2 HOUSING 50 GENERAL HOUSING INSP. - SOFTWARE LICENSE EXP (34) 260 26061700 62663 CDBG Amend#2 HOUSING 50 RACE IN HEARTLAND - GRANTS (1,983) 260 26061806 62765 CDBG Amend#2 HOUSING 50 AHNI AGREEMENT - GRANTS 221,900 260 26061820 62765 CDBG Amend#2 HOUSING 50 NEIGHBORHOOD GRANTS - GRANTS (8,586) 260 26072850 62765 CDBG Amend#2 HOUSING 50 NEIGHBORHOOD GRANTS - SERVICES FROM PLANNING 1,000 260 26072850 62834 CDBG Amend#2 HOUSING 5C LOW INCOME SM BIZ GRANTS - GRANTS (25,000) 260 2602636 62765 CDBG Amend#2 HOUSING 2C SIDEWALKS - CONST.CONTR-NOT BLDG (15,000) 260 2602776 73211 CDBG Amend#2 HOUSING 4C LOW/MOD INCOME PARKS - PLAYGROUND EQUIPMENT 148,881 260 2602891 72713 CDBG Amend#2 HOUSING 4C LOW/MOD INCOME PARKS - CONST.CONTR-NOT BLDG (81,449) 260 2602891 73211 CDBG Amend#2 HOUSING 5C CREDIT REPAIR PROGRAM - PAY TO OTHER AGENCY (50,000) 260 2602926 62761 CDBG Amend#2 HOUSING 5C WINDOW REPLACE PROGRAM - GRANTS 37,672 260 2602927 62765 CDBG Amend#2 HOUSING 5C WINDOW REPLACE PROGRAM - CONTR CONTRACT-BLDG (20,000) 260 2602927 73210 CDBG Amend#2 HOUSING 5C AQUAPONICS SYSTEMS - CONST.CONTR-NOT BLDG (90,958) 260 2602928 73211 CDBG Amend#2 HOUSING 5C RENTAL & MORTGAGE ASSIST - GRANTS 28,000 260 2602943 62765 CDBG Amend#2 HOUSING 5C ENERGY SAVER PROGRAM - GRANTS 65,000 260 2602945 62765 CDBG Amend#2 TOTAL COMMUNITY DEVELOPMENT BLOCK FUND 728,753 173,064 CDBG CARES ACT FUND HOUSING 50 CDBG CARES ACT - CD BLOCK GRANT 317,955 261 26161805 44205 New Grant HOUSING 50 CDBG CARES ACT - GRANTS 317,955 261 26161805 62765 New Grant Approp TOTAL CDBG CARES ACT FUND 317,955 317,955 STATE CDBG FUND HOUSING 5C IEDA CDBG-CV GRANT - CD BLOCK GRANT 521,469 263 2632341 44205 IEDA CARES Act HOUSING 5C IEDA CDBG-CV GRANT - GRANTS 521,469 263 2632341 62765 IEDA CARES Act TOTAL STATE CDBG FUND 521,469 521,469 OLDER ADULT MOD FUND HOUSING 50 OLDER ADULT MOD - HUD PAYMENTS 50,200 269 26961922 44310 Adjust to Actual HOUSING 50 OLDER ADULT MOD - PRIVATE PARTICIPANT (1,207) 269 26961922 53102 Adjust to Actual HOUSING 50 OLDER ADULT MOD - FULL TIME EMPLOYEES 12,000 269 26961922 61010 Adjust to Actual HOUSING 50 OLDER ADULT MOD - IPERS 1,200 269 26961922 61310 Adjust to Actual FISCAL YEAR 2022 AMENDMENT #2 COUNCIL DETAIL FY22 FY22 Expense Revenue Department Program Description Amount Amount Fund Activity/CIP Account Explanation HOUSING 50 OLDER ADULT MOD - SOCIAL SECURITY 1,000 269 26961922 61320 Adjust to Actual HOUSING 50 OLDER ADULT MOD - LIFE INSURANCE 10 269 26961922 61416 Adjust to Actual HOUSING 50 OLDER ADULT MOD - OFFICE SUPPLIES 500 269 26961922 62010 Adjust to Actual HOUSING 50 OLDER ADULT MOD - POSTAGE AND SHIPPING 50 269 26961922 62030 Adjust to Actual HOUSING 50 OLDER ADULT MOD - GRANTS 18,798 269 26961922 62765 Adjust to Actual TOTAL OLDER ADULT MOD FUND 33,558 48,993 LEAD PAINT ABATEMENT FUND HOUSING 5C HEALTHY HOMES GRANT - HUD PAYMENTS 216,000 275 2752340 44310 New Grant HOUSING 50 LEAD PAINT ABATEMENT - HUD PAYMENTS 66,400 275 27561200 44310 New Grant HOUSING 50 LEAD PAINT ABATEMENT - FULL-TIME EMPLOYEES 40,000 275 27561200 61010 New Grant Approp HOUSING 50 LEAD PAINT ABATEMENT - IPERS 2,500 275 27561200 61310 New Grant Approp HOUSING 50 LEAD PAINT ABATEMENT - SOCIAL SECURITY 2,000 275 27561200 61320 New Grant Approp HOUSING 50 LEAD PAINT ABATEMENT - HEALTH INSURANCE 6,000 275 27561200 61410 New Grant Approp HOUSING 50 LEAD PAINT ABATEMENT - LIFE INSURANCE 50 275 27561200 61416 New Grant Approp HOUSING 50 LEAD PAINT ABATEMENT - PRINTING & BINDING 200 275 27561200 62090 New Grant Approp HOUSING 50 LEAD PAINT ABATEMENT - LEGAL NOTICES & ADS 100 275 27561200 62130 New Grant Approp HOUSING 50 LEAD PAINT ABATEMENT - TRAVEL -CONFERENCES 500 275 27561200 62310 New Grant Approp HOUSING 50 LEAD PAINT ABATEMENT - DATA SERVICES 4,000 275 27561200 62667 New Grant Approp HOUSING 50 LEAD PAINT ABATEMENT - TELEPHONE RELATED 250 275 27561200 72418 New Grant Approp HOUSING 50 LEAD PAINT ABATEMENT - RELOCATIONS 10,800 275 27561200 73112 New Grant Approp HOUSING 5C HEALTHY HOMES GRANT - LOANS 216,000 275 2752340 62764 New Grant Approp HOUSING 5C LEAD HZRD REDUC PROG - HUD PAYMENTS 30,000 275 2752429 44310 New Grant HOUSING 5C LEAD HZRD REDUC PROG - CONTRIBUTIONS 24,000 275 2752429 53103 New Grant HOUSING 5C LEAD HZRD REDUC PROG - GRANTS 54,000 275 2752429 62765 New Grant Approp TOTAL LEAD PAINT ABATEMENT FUND 336,400 336,400 HOUSING CHOICE VOUCHER FUND HOUSING 50 MODERATE REHAB- HUD PAYMENTS 4,500 280 28061530 44310 Adjust to Actual HOUSING 50 VASH PROGRAM - HUD PAYMENTS (16,600) 280 28061590 44310 Adjust to Actual HOUSING 50 SECTION 8 VOUCHER - FSS COORDINATOR GRANT (133,507) 280 28061600 44215 Adjust to Actual HOUSING 50 SECTION 8 VOUCHER - HUD ADM FEE REIMBURSEMENT 34,800 280 28061600 44311 Adjust to Actual HOUSING 50 SECTION 8 VOUCHER - FULL-TIME EMPLOYEES (66,753) 280 28061600 61010 Adjust to Actual HOUSING 50 VOUCHER HAP - HUD PAYMENTS 77,870 280 28061601 44310 Adjust to Actual HOUSING 50 FAMILY UNIFICATION PROG - HUD PAYMENTS (11,000) 280 28061602 44310 Adjust to Actual HOUSING 50 FAMILY UNIFICATION PROG - HOUSING ASST. PAYMENT 115,270 280 28061602 62694 Adjust to Actual HOUSING 50 FSS PROGRAM VOUCHER - HUD PAYMENTS 25,700 280 28061640 44310 Adjust to Actual HOUSING 50 FSS PROGRAM VOUCHER - HUD PAYMENTS 133,507 280 28061640 44310 Adjust to Actual HOUSING 50 FSS PROGRAM VOUCHER - FSS, PARTICIPATE PAYMENTS 66,753 280 28061640 62774 Adjust to Actual TOTAL HOUSING CHOICE VOUCHER FUND 115,270 115,270 GENERAL GIFT TRUST FUND LIBRARY 40 GENERAL GIFT TRUST- CONSULTANT SERVICES 13,000 295 29536480 62716 Adjust to Actual LIBRARY 40 GENERAL GIFT TRUST- SPEAKERS/PROGRAMS 7,513 295 29536480 62734 Adjust to Actual TOTAL GENERAL GIFT TRUST FUND 20,513 STREET CONSTRUCTION FISCAL YEAR 2022 AMENDMENT #2 COUNCIL DETAIL FY22 FY22 Expense Revenue Department Program Description Amount Amount Fund Activity/CIP Account Explanation ENGINEERING 2C SIDEWALK PROGRAM CITY OWNED -CONSTRUCTION CONTRACT 125,000 300 3001425 73211 Shift from Pave Pres PUBLIC WORKS 2C DUMP TRK REPLC - HEAVY EQUIP -REPLACEMENT 8,700 300 3002539 71318 Shift from Aerial Trk PUBLIC WORKS 2C DUMP TRK REPLC - HEAVY EQUIP -REPLACEMENT 15,884 300 3002539 71318 Shift from Dump Trk ENGINEERING 2C PAVE PRESERVATION JOINT SEALING -CONSTRUCTION CONTRACT (125,000) 300 3002851 73211 Shift to Sidewalk ENGINEERING 2C NORTHWEST ARTERIAL REHAB RECONSTRUCT- STATE HIGHWAY 1,431,420 300 3002876 45725 SWAP NWA Rehab ENGINEERING 2C NORTHWEST ARTERIAL REHAB RECONSTRUCT -CONSTRUCTION CONTR, 1,431,420 300 3002876 73211 SWAP NWA Rehab TOTAL STREET CONSTRUCTION 1,456,004 1,431,420 SALES TAX CONSTRUCTION PARKS 4C PARK RETAINING WALLS - CONSTRUCTION (34,756) 350 3501055 73211 Adjust to Actual PARKS 4C RENOVATE PARK WATER SYSTEM - CONSTRUCTION (5,405) 350 3501158 73211 Adjust to Actual PARKS 4C FLOR/SUTTON POOL HEATERS - CONSTRUCTION (17,913) 350 3501446 73210 Adjust to Actual PARKS 4C WESTBROOK PARK DEVELOPMENT - ENGINEERING (20,000) 350 3501582 62811 Adjust to Actual PARKS 4C WESTBROOK PARK DEVELOPMENT - CONSTRUCTION CONTRACT - NOT 1 (194,000) 350 3501582 73211 Adjust to Actual PARKS 4C EAGLE VALLEY PARK DEV-CONSTRUCTION CONTRACT -NOT BUILDING (97,283) 350 3502288 73211 Adjust to Actual PARKS 4C EAGLE POINT PARK RETAINING WALL - CONSTRUCTION CONTRACT - NO (75,000) 350 3502459 73211 Adjust to Actual PUBLIC WORKS 2C PURINA DRIVE FLOODWALL-CONSULTING ENGINEERING (160) 350 3502480 62712 Adjust to Actual PUBLIC WORKS 2C PURINA DRIVE FLOODWALL - CONSTRUCTION NOT BUILDING (85,328) 350 3502480 73211 Adjust to Actual PARKS 4C DOG PARK - CONSULTANT SERVICES (20,000) 350 3502737 62716 Adjust to Actual TOTAL SALES TAX CONSTRUCTION (549,845) - GENERAL CONSTRUCTION ECONOMIC DEVELOPMEN' 5C DICW- GO BOND PROCEEDS 5,200,000 360 3601056 54210 Adjust to Actual ECONOMIC DEVELOPMEN' 5C DICW- LAND ACQUISITION 4,230,155 360 3601056 73110 Adjust to Actual PARKS 4C COMISKEY LANDSCAPE- PRIVATE PARTICIPANT 25,000 360 3601105 53102 New Grant PARKS 4C COMISKEY LANDSCAPE- CONSTRUCTION CONTRACT 25,000 360 3601105 73211 New Grant Approp PARKING 4C NEW DOWNTOWN RAMP - EQUIPMENT ACQUISITION 200,000 360 3601671 73411 Code Blue Phones PARKING 5C NEW DOWNTOWN RAMP - CONSULTANT (950,000) 360 3601671 62716 Adjust to Actual PARKING 5C NEW DOWNTOWN RAMP - ENGINEERING (35,000) 360 3601671 62811 Adjust to Actual PARKING 5C NEW DOWNTOWN RAMP - LAND ACQUISITION (369,000) 360 3601671 73113 Adjust to Actual PARKING 5C NEW DOWNTOWN RAMP - CONSTRUCTION (896,000) 360 3601671 73210 Adjust to Actual PARKS 4C ENGLISH RIDGE PARK -CONSTRUCTION CONTRACT -NOT BUILDING (86,534) 360 3602738 73211 Adjust to Actual ENGINEERING 2C ABC SUPPLY BUILDING DECONSTRUCT - CONSULTING (25,000) 360 3602854 62712 Adjust to Actual ENGINEERING 2C ABC SUPPLY BUILDING DECONSTRUCT - ENGINEERING (12,000) 360 3602854 62811 Adjust to Actual ENGINEERING 2C ABC SUPPLY BUILDING DECONSTRUCT - CONSTRUCTION (376,598) 360 3602854 73211 Adjust to Actual AIRPORT 2C NEW HANGARS - STATE GRANT 2,783,502 390 3901505 45701 New Grant AIRPORT 2C NEW HANGARS - CONSULTING ENGINEERS 278,350 390 3901505 62712 New Grant Approp AIRPORT 2C NEW HANGARS - CONST CONTRACT-BLDG 2,505,152 390 3901505 73210 New Grant Approp TOTAL GENERAL CONSTRUCTION 4,488,525 8,008,502 BOND PROCEEDS FUND CITY-WIDE 0 BOND PROCEEDS FUND - BOND PROCEEDS (2,948,570) 440 44010440 54210 Adjust to Actual TOTAL BOND PROCEEDS FUND - (2,948,570) SANITARY SEWER OPERATING FUND PUBLIC WORKS 80 SAN-SEWER MNTNCE - GAS SAFETY MONITOR (138) 610 61054300 72111 Shift to Jet Flusher PUBLIC WORKS 80 SAN-SEWER MNTNCE - JET FLUSHER HOSE 138 610 61054300 72816 Shift From Gas Monitor TOTAL SANITARY SEWER OPERATING FUND - WATER OPERATING FUND FISCAL YEAR 2022 AMENDMENT #2 COUNCIL DETAIL FY22 FY22 Expense Revenue Department Program Description Amount Amount Fund Activity/CIP Account Explanation WATER 80 WATER ADMINISTRATION - SEASONAL EMPLOYEES (11,000) 640 64042100 61030 Shift to Consulting WATER 80 WATER ADMINISTRATION - CONSULTANT SERVICES 11,000 640 64042100 62716 Shift from Seas Emp WATER 80 WATER ADMINISTRATION - CONSULTANT SERVICES 15,850 640 64042100 62716 Shift from Full -Time WATER 80 PLANT OPER. & MAINT - FULL-TIME EMPLOYEES (15,850) 640 64042400 61010 Shift to Consulting TOTAL WATER OPERATING FUND REFUSE FUND PUBLIC WORKS 8C DUAL PACKER RECYCLE VEH - DEBT PROCEEDS (175,000) 670 6701533 54210 Delayed PUBLIC WORKS 8C DUAL PACKER RECYCLE VEH - EQUIP ACQUISITION (175,000) 670 6701533 73410 Delayed TOTAL REFUSE FUND (175,000) (175,000) SANITARY SEWER CONSTRUCTION FUND ENGINEERING 8C ANNEXATION STUDY/IMPLEMENTATION- GO BOND 92,000 710 7101012 54230 Shift from Sewer Ext ENGINEERING 8C ANNEXATION STUDY/IMPLEMENTATION- ENG DIVISION 92,000 710 7101012 62811 Shift from Sewer Ext ENGINEERING 8C SANITARY SEWER MANHOLE REPLACEMENT- CONSTRUCTION CONTRAC (50,000) 710 7101335 73211 Shift to Force Main ENGINEERING 8C SEWER EXTENSIONS NEW DEVELOPMENTS- GO BOND (465,000) 710 7101350 54230 Shift to Other Proj ENGINEERING 8C SEWER EXTENSIONS NEW DEVELOPMENTS- ENGINEERING DIVISION (280,000) 710 7101350 62811 Shift to Annex Study ENGINEERING 8C SEWER EXTENSIONS NEW DEVELOPMENTS- CONSTRUCTION CONTRAC- (185,000) 710 7101350 73211 Shift to Other Proj ENGINEERING 8C CATFISHGRANGER LIFT IMPROVEMENTS- GO BOND 253,000 710 7102607 54230 Shift from Sewer Ext ENGINEERING 8C CATFISHGRANGER LIFT IMPROVEMENTS- ENGINEERING DIVISION 253,000 710 7102607 62811 Shift from Sewer Ext WRRC 8C HS WASTE RECEIVE & STORE - SRF PROCEEDS (857,395) 710 7102701 54230 Adjust to Actual WRRC 8C HS WASTE RECEIVE & STORE -ENGINEERING (387,200) 710 7102701 62811 Adjust to Actual WRRC 8C HS WASTE RECEIVE & STORE - CONSTRUCTION (470,195) 710 7102701 73211 Adjust to Actual ENGINEERING 8C TWIN RIDGE LIFT STATION ABANDON- GO BOND 120,000 710 7102754 54230 Shift from Sewer Ext ENGINEERING 8C TWIN RIDGE LIFT STATION ABANDON - ENGINEERING DIVISION 120,000 710 7102754 62811 Shift from Sewer Ext WRRC 8C UV DISINFECTION SYSTEM - ENGINEERING (10,000) 710 7102841 62811 Adjust to Actual WRRC 8C UV DISINFECTION SYSTEM - CONSTRUCTION (225,000) 710 7102841 73211 Adjust to Actual ENGINEERING 8C CENTER PLACE ALLEY SEWER RECONST - SRF PROCEEDS (372,000) 710 7102844 54230 Adjust to Actual ENGINEERING 8C CENTER PLACE ALLEY SEWER RECONST - CONSTRUCTION (372,000) 710 7102844 73211 Adjust to Actual ENGINEERING 8C FORCE MAIN STABILIZATION- CONSTRUCTION CONTRACT 50,000 710 7102846 73111 Shift from Manhole TOTAL SANITARY SEWER CONSTRUCTION FUND (1,464,395) (1,229,395) STORMWATER CONSTRUCTION FUND ENGINEERING 8C CEDAR CROSS ROAD STORM- CONSULTING ENGINEERS (11,000) 720 7202238 62712 Shift to Wilbricht ENGINEERING 8C CEDAR CROSS ROAD STORM- CONSTRUCTION CONTRACT (58,700) 720 7202238 73211 Shift to Wilbricht ENGINEERING 8C WILBRICHT DETENTION BASIN- CONSTRUCTION CONTRACT 69,700 720 7202722 73211 Shift from Cedar Cross TOTAL STORMWATER CONSTRUCTION FUND - - PARKING CONSTRUCTION FUND PARKING 8C DOWNTOWN PARKING RAMP - BOND PROCEEDS 898,570 730 7301671 54210 Adjust to Actual PARKING 8C PORT OF DBQ RAMP MAINT - CONSTR. CONTR-NOT BLDG 54,100 730 7302162 73211 Adjust to Actual TOTAL PARKING CONSTRUCTION FUND 54,100 898,570 WATER CONSTRUCTION FUND WATER 8C SCADA SYSTEM UPGRADE -ENGINEERING (10,000) 740 7401339 62811 Adjust to Actual WATER 8C SCADA SYSTEM UPGRADE - HARDWARE (80,250) 740 7401339 71126 Adjust to Actual WATER 8C WATER MAIN REPLACEMENTS - FULL-TIME EMPLOYEES 1,004 740 7401405 61010 Adjust to Actual WATER 8C WATER MAIN REPLACEMENTS - IPERS 95 740 7401405 61310 Adjust to Actual WATER 8C WATER MAIN REPLACEMENTS - SOCIAL SECURITY 74 740 7401405 61320 Adjust to Actual WATER 8C WATER MAIN REPLACEMENTS - HEALTH INSURANCE 148 740 7401405 61410 Adjust to Actual WATER 8C WATER MAIN REPLACEMENTS - LIFE INSURANCE 1 740 7401405 61416 Adjust to Actual FISCAL YEAR 2022 AMENDMENT #2 COUNCIL DETAIL FY22 FY22 Expense Revenue Department Program Description Amount Amount Fund Activity/CIP Account Explanation WATER 8C WATER MAIN REPLACEMENTS - CONSULTANT SERVICES 340,000 740 7401405 62716 Adjust to Actual WATER 8C WATER MAIN REPLACEMENTS - ENG. DIVISION SERVICES 14,118 740 7401405 62811 Adjust to Actual WATER 8C WATER MAIN REPLACEMENTS - BARRICADES/WARN SIGNALS 70,886 740 7401405 72115 Adjust to Actual WATER 8C WATER MAIN REPLACEMENTS - CONST.CONTR-NOT BLDG 747,500 740 7401405 73211 Adjust to Actual WATER 8C ROOSEVELT RD MAIN EXT. - CONTR.CONTR-NOT BLDG (7,884) 740 7401672 73211 Shift to Water Mn Rep WATER 8C SECURITY UPGRADES - CONTT. CONTR-NOT BLDG (14,200) 740 7401829 73211 Shift to Water Mn Rep WATER 8C SOUTHGATE WATER - CONST. CONTR-NOT BLDG (5,572) 740 7402234 73211 Shift to Water Mn Rep WATER 8C M CASCADE WATER MAIN - CONTT. CONTR-NOT BLDG (63,405) 740 7402525 73211 Shift to Water Mn Rep WATER 8C N CASCADE WATER MAIN -CONSTRUCTION CONTRACT -NOT BUILDING (100,000) 740 7402525 73211 Adjust to Actual WATER 8C GENERATOR - CONTT. CONTR-NOT BLDG (19,737) 740 7402527 73211 Shift to Water Mn Rep WATER 8C SW ARETERIAL MAIN EXT - FED PASS THRU STATE GRANT (2,160,000) 740 7402594 45771 Adjust to Actual WATER 8C SW ARETERIAL MAIN EXT - CONSULTING ENGINEERS (159,385) 740 7402594 62712 Eliminate Project WATER 8C SW ARETERIAL MAIN EXT - CONST.CONTR-NOT BLDG (1,107,904) 740 7402594 73211 Eliminate Project WATER 8C MAIN RELOC SEWER MANHOLE - CONTT. CONTR-NOT BLDG (25,000) 740 7402596 73211 Shift to Water Mn Rep WATER 8C LIME SLAKER REPLACE STUDY - CONSULTANT SERVICES (30,000) 740 7402653 62716 Shift to Water Mn Rep WATER 8C MAINT WTR MN -RETAIN WAL - END. DIVISION SERVICES (2,000) 740 7402655 62811 Shift to Water Mn Rep WATER 8C MAINT WTR MN -RETAIN WAL - CONTT. CONTR-NOT BLDG (18,000) 740 7402655 73211 Shift to Water Mn Rep WATER 8C GRANDVIEW/LORAS INTER IMP - CONSULTANT SERVICES (8,800) 740 7402705 73211 Shift to Water Mn Rep WATER 8C RPR/MAINT WATER LINE ISLA - CONSULTING ENGINEERS (629) 740 7402713 62712 Shift to Water Mn Rep WATER 8C BULK CO2 TANK REPLACEMENT - EQUIP ACQUISITION (75,000) 740 7402714 73410 Shift to Water Mn Rep WATER 8C PUBLIC LEAD LINE WATER -ENGINEERING (12,470) 740 7402744 62811 Adjust to Actual WATER 8C PUBLIC LEAD LINE WATER - CONSTRUCTION (94,363) 740 7402744 73211 Adjust to Actual WATER 8C COTTINGHAM RD WATER MAIN - CONST.CONTR-NOT BLDG (275,000) 740 7402746 73211 Shift to Water Mn Rep WATER 8C EPWP TRANSFORMER SAFETY - CONTT CONTRACT-BLDG (5,880) 740 7402748 73210 Shift to Water Mn Rep WATER 8C DAVENPORT RD EXTENSION/PMP STAT-CONSTRUCTION (2,400) 740 7402786 73211 Adjust to Actual WATER 8C WATER PLANT IMPROVEMENTS - CONST.CONTR - NOT BLDG (15,218) 740 7402839 73211 Shift to Water Mn Rep WATER 8C PUBLIC SAFETY WAY - CONST.CONTR-NOT BLDG (135,000) 740 7402873 73211 Shift to Water Mn Rep WATER 8C MCFADDEN WATER MAIN IMP - CONST.CONTR-NOT BLDG (235,000) 740 7402895 73211 Shift to Water Mn Rep WATER 8C SUPER 20 WATER CONNECTION - ENG DIVISION SERVICES (12,000) 740 7402896 62811 Shift to Water Mn Rep WATER 8C SUPER 20 WATER CONNECTION - CONST.CONTR-NOT BLDG (130,000) 740 7402896 73211 Shift to Water Mn Rep WATER 8C E 16TH HYDRANT RELOCATION - CONST.CONTR-NOT BLDG (24,000) 740 7402902 73211 Shift to Water Mn Rep WATER 8C E 16TH WATER MAIN REPLACE - DIVISION SERVICES (6,500) 740 7402933 62811 Shift to Water Mn Rep WATER 8C E 16TH WATER MAIN REPLACE - CONST.CONTR-NOT BLDG (65,000) 740 7402933 73211 Shift to Water Mn Rep TOTAL WATER CONSTRUCTION FUND (1,566,772) (2,160,000) TRANSFERS PARKS Trans1 TRANSFER FROM DRA DISTRIB TO SALES TAX CONSTRUCTION FUND (6,500) 350 3502288 59102 Adjust to Actual PARKS Trans1 TRANSFER FROM DRA DISTRIB TO SALES TAX CONSTRUCTION FUND (6,500) 102 10210102 91350 Adjust to Actual PARKS Trans2 TRANSFER FROM N CASCADE TIF TO GENERAL CONSTRUCTION FUND (86,534) 360 3602738 59216 Adjust to Actual PARKS Trans2 TRANSFER FROM N CASCADE TIF TO GENERAL CONSTRUCTION FUND (86,534) 216 21660216 91360 Adjust to Actual PARKING Trans3 TRANSFER FROM GO BOND PROCEEDS TO GENERAL CONSTRUCTION FUND (2,948,570) 360 3601671 59440 Adjust to Actual PARKING Trans3 TRANSFER FROM GO BOND PROCEEDS TO GENERAL CONSTRUCTION FI (2,948,570) 440 44010440 91360 Adjust to Actual PUBLIC WORKS Trans4 TRANSFER FROM ROAD USE TAX FUND TO STREET CONSTRUCTION FUN 8,700 250 25010250 91300 Trans Funds PUBLIC WORKS Trans4 TRANSFER FROM ROAD USE TAX FUND TO STREET CONSTRUCTION FUND 8,700 300 3002539 59250 Trans Funds PUBLIC WORKS Trans5 TRANSFER FROM ROAD USE TAX FUND TO STREET CONSTRUCTION FUND 15,884 300 3002539 59250 Trans Funds PUBLIC WORKS Trans5 TRANSFER FROM ROAD USE TAX FUND TO STREET CONSTRUCTION FUN 15,884 250 25010250 91300 Trans Funds ENGINEERING Trans6 TRANSFER FROM GDTIF TO GENERAL CONSTRUCTION FUND (414,243) 240 24060240 91360 Adjust to Actual ENGINEERING Trans6 TRANSFER FROM GDTIF TO GENERAL CONSTRUCTION FUND (414,243) 360 3602854 59240 Adjust to Actual TOTAL TRANSFERS (3,431,263) (3,431,263) FISCAL YEAR 2022 AMENDMENT #2 Department Program rc.�r��i!la►i.�:�: Description FY22 FY22 Expense Revenue Amount Amount Fund Activity/CIP Account 3,052,975 3,697,901 COUNCIL DETAIL Explanation NOTICE OF PUBLIC HEARING -AMENDMENT OF CURRENT BUDGET City of DUBUQUE Fiscal Year July 1, 2021 - June 30, 2022 The City of DUBUQUE will conduct a public hearing for the purpose of amending the current budget for fiscal year ending June 30, 2022 Meeting Date/Time: 5/2/2022 06:30 PM I 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. REVENUES & OTHER FINANCING SOURCES Total Budget as Certified or Last Amended Current Amendment Total Budget After Current Amendment Taxes Levied on Property 1 25,530,416 0 25,530,416 Less: Uncollected Delinquent Taxes - Levy Year 2 0 0 0 Net Current Property Tax 3 25,530,416 0 25,530,416 Delinquent Property Tax Revenue 41 0 0 0 TIF Revenues 5 11,666,215 0 11,666,215 Other City Taxes 6 20,772,861 0 20,772,861 Licenses & Permits 7 1,955,835 137,538 2,093,373 Use of Money & Property 8 16,020,342 26,500 16,046,842 Intergovernmental 9 73,910,619 3,848,150 77,758,769 Charges for Service 10 46,174,996 671,047 46,846,043 Special Assessments 11 187,000 1,000 188,000 Miscellaneous 12 9,902,450 476,060 10,378,510 Other Financing Sources 13 24,162,351 1,968,869 26,131,220 Transfers In 14 45,320,544 -3,431,263 41,889,281 Total Revenues & Other Sources 151 275,603,629 3,697,901 279,301,530 EXPENDITURES & OTHER FINANCING USES Public Safety 16 32,282,577 410,969 32,693,546 Public Works 17 16,470,685 -15,884 16,454,801 Health and Social Services 18 1,043,534 0 1,043,534 Culture and Recreation 19 15,305,370 1,361,522 16,666,892 Community and Economic Development 20 17,325,419 1,176,866 18,502,285 General Government 21 12,106,120 -204,885 11,901,235 Debt Service 22 9,804,328 0 9,804,328 Capital Projects 23 105,421,611 6,929,989 112,351,600 Total Government Activities Expenditures 24 209,759,644 9,658,577 219,418,221 Business Type/Enterprise 25 88,067,727 -3,174,339 84,893,388 Total Gov Activities & Business Expenditures 26 297,827,371 6,484,238 304,311,609 Tranfers Out 27 45,320,544 -3,431,263 41,889,281 Total Expenditures/Transfers Out 28 343,147,915 3,052,975 346,200,890 Excess Revenues & Other Sources Over Under Expenditures/Transfers Out 29 -67,544,286 644,926 -66,899,360 Beginning Fund Balance July 1, 2021 301 137,843,052 0 137,843,052 Ending Fund Balance June 30, 2022 311 70,298,766 644,926 70,943,692 Explanation of Changes: This amendment adds additional revenue from grants received, private funding, adjustments to the use of ARPA funds, and the appropriation to spend the monies. Adjustments to reflect actual budget of projects. 04/13/2022 08:57 AM Paae 1 of 1