HomeMy WebLinkAboutFY2022 4th Qtr Financial Summary
Date: August 30, 2022
To: City Manager, City Council
From: Angie Ogden, Budget Management Analyst
Re: Quarterly Financial Summary for Period Ending June 30, 2022
Introduction
Attached to this memorandum are the City’s quarterly financial reports as of June 30, 2022.
The quarterly financial report includes combined summaries of all fund balances, revenues, and
expenditures for fiscal year 2022 through the end of the fiscal year. This report represents the
entire fiscal year’s activities, but the totals presented are still preliminary and unaudited.
Accruals will continue to be posted through August and September and until the annual financial
audit is completed by Bohnsack & Frommelt.
Revenue Analysis
This revenue analysis pertains to the revenue reports, Revenues by Fund and Revenues by
Type, on pages 4-6. In these two reports, the actual revenues would ideally be near 100% of
budget since we have completed the fiscal year; however, not all of the accrued revenues have
been received and posted yet.
For the major governmental funds, their actual revenues appear to have finished the year
slightly under or at their revised budget estimates. The General Fund is at 98.8%, the Road
Use Tax Fund is at 100%, the Employee Benefits Fund is at 99.9%, and the Debt Service Fund
is at 100.1%. The General Fund has also experienced revenue shortfalls in Intergovernmental
revenues due to timing of Capital Improvement Projects and Culture & Recreation charges for
services and Police Services revenues due to the pandemic recovery. Library Fees are no
longer assessed due to Library policy changes.
In the major enterprise funds, the actual revenues as a percentage of the budget ranged
between 27.7% and 120.8%. The Water Fund finished with revenues at 93% of budget, the
Housing Authority Fund at 100.9% of budget and the Wastewater Fund at 90.5% of budget.
Some large accruals have yet to be made within the major enterprise funds for unbilled services
and receivables at year end. The major enterprise funds will finish the year with revenues close
to or higher than 100% of budget primarily due to conservative revenue budgeting for Charges
for Fees and Services.
The Transit Fund actual revenues currently stand at 27.7% of budget This difference in the
Transit Fund will be made up with the accrual of the Federal Operating grant. In addition, we are
expecting receipt of CARES Act funding to make up for the Transit Fund revenue shortfalls.
Transit Fees for Services are also under budget sitting at 72.5% of expected revenues due to
lower ridership levels.
Several funds are below the 100% benchmark due to the timing of grants. These funds include
the Community Development Block Grant (CDBG) Fund at 63.2% and the HOME Fund at
10.1%. Additionally, both the Governmental Projects and the Enterprise Projects Capital Funds
are significantly below budget at 65.1% and 48.3%, respectively. Revenues for these funds are
significantly below budget due to the timing of the state and federal grant revenues and private
loan repayments. These revenues have not yet been received or earned and will be amended
into next year’s budget.
1
The Affordable Housing Fund has revenues significantly over budget primarily due to the receipt
of an affordable housing fee in lieu of payment from a developer. This is also contributing to the
Building and Development Fees and Services to be at 996.8% of budget.
The combined total actual revenues for all budgetary funds through June are $185,083,785 or
90.2% of budget. The budget shortfall of $20,048,608 is primarily due to the timing of the
aforementioned grant revenues and other unrecorded accruals. Overall, the City’s revenues are
slightly less than projected, and most of the anomalies and budget variances can be explained
either through timing of accruals or grants.
Expenditure Analysis
This expenditure analysis pertains to the expenditure reports, Expenditures by Fund and
Expenditures by Fund by Department on pages 7-9. The analysis of the City’s expenditures for
fiscal year 2022 through June is similar to the analysis for the City’s revenues. We generally
expect the actual expenditure levels to be around 100% of budget at this time of year. Also,
similar to the revenues, not all accruals have been recorded and posted yet.
For the majority of the City’s funds, their actual expenditures are currently at or below 100% of
their budgeted expenditures. The General Fund is at 90.1% due to unspent monies within the
City Manager’s Department for Black Lives Matter and Economic Development, that will be
carried forward to fiscal year 2023.
Some of the other funds have actual expenditures that are well below the 100% benchmark.
Those funds include:
The HOME Fund (6.6%) and CDBG Fund (64.5%) due to timing of the pay out of
loans and grant applicants.
Other Shared Revenue (9.2%) primarily because of American Rescue Plan Act funds
budgeted but not yet spent.
Emergency Levy Fund (26.0%) due to unspent capital outlay budgets.
The Equipment Fund (73.3%) due to extended lead times when ordering equipment.
Also, well below budget are the Governmental Projects Fund (35.6%), and the
Enterprise Projects Fund (29.4%) due to capital projects scheduled for construction
this spring.
Most of these funds contain a great deal of grant and project activity which does not always
occur evenly throughout the fiscal year. Unexpended appropriations will be carried forward into
the next fiscal year and amended into the fiscal year 2023 budget.
There are several funds currently above 100% of their budgeted expenditures. The Iowa City
Property Management Fund is at 283.8% due to unplanned maintenance expenses
and Tax Increment Financing is at 114.3% due to energy efficiency grants. The Airport Fund
finished at 103.5% primarily due to unbudgeted maintenance.
The combined total actual expenditures for all budgetary funds through June are $174,079,032
or 68.4% of budget. When the Capital Project Funds, HOME, CDBG, Other Shared Revenues
and Emergency Levy Funds are removed from the calculation, the actual percentage of
expenditures versus budget increases to 96.7%. Overall, the City’s expenditures are expected
to finish at or below budget.
Conclusion
Generally, there are no major immediate concerns to report with the City’s fund balances at
year-end. Two funds present negative fund balances at year-end. Both the CDBG and TIF fund
balances are expected to be corrected due to timing of funding streams. This year-end report is
preliminary and accruals for revenues and expenditures are still outstanding. The City’s final
financial performance will be available for the start of the fiscal year 2024 budget process in
October. Additional information is available from the Finance Department upon request.
2
Beginning Ending Restricted, Unassigned
Fund Year-to-Date Transfers Year-to-Date Transfers Fund Committed, Fund
Balance Revenues In Expenditures Out Balance Assigned Balance
Budgetary Funds
General Fund
10** General Fund 50,838,356$ 58,718,064$ 19,238,734$ 60,807,594$ 12,229,481$ 55,758,079$ 21,090,422$ 34,667,657$
Special Revenue Funds
2100 Community Dev Block Grant 19,924 765,231 - 706,002 94,090 (14,936) - (14,936)
2110 HOME 4,434 290,694 - 182,162 - 112,966 - 112,966
2200 Road Use Tax Fund 4,405,316 9,298,029 628,877 6,676,459 3,390,398 4,265,364 - 4,265,364
2300 Other Shared Revenue 8,813,343 9,808,784 - 1,731,346 - 16,890,781 - 16,890,781
2350 Metro Planning Org of J.C. 438,463 431,671 390,715 759,879 - 500,970 - 500,970
2400 Employee Benefits 3,630,989 14,891,999 - 1,302,276 13,090,017 4,130,695 - 4,130,695
2450 Emergency Levy Fund 794,225 1,042,548 - 280,977 350,000 1,205,796 - 1,205,796
2500 Affordable Housing Fund 3,598,374 3,076,974 1,000,000 873,449 1,520,000 5,281,899 - 5,281,899
2510 Peninsula Apartments 194,571 243,332 - 204,873 - 233,030 - 233,030
26** Tax Increment Financing 1,421,524 4,060,035 243,891 2,984,842 3,864,075 (1,123,467) 959,892 (2,083,359)
2820 SSMID-Downtown District - 467,815 - 467,815 - - - -
Debt Service Fund
5*** Debt Service 7,245,357 11,231,311 1,827,877 13,185,763 - 7,118,783 - 7,118,783
Enterprise Funds
710* Parking 2,272,962 5,316,052 1,090,000 4,143,957 2,455,461 2,079,596 303,702 1,775,894
715* Mass Transit 8,519,509 3,144,400 4,122,880 12,090,537 92,575 3,603,678 2,508,657 1,095,021
720* Wastewater 24,842,383 11,436,194 4,120,291 9,916,696 6,276,894 24,205,278 10,482,390 13,722,888
730* Water 12,833,162 10,073,276 3,104,220 9,157,704 4,383,141 12,469,814 6,365,083 6,104,730
7400 Refuse Collection 1,268,644 3,687,488 7,022 4,005,202 (6,125) 964,077 - 964,077
750* Landfill 25,728,087 7,688,112 1,581,458 5,501,012 2,958,395 26,538,250 24,091,862 2,446,389
7600 Airport 263,541 450,535 100,000 434,849 63,523 315,704 136,299 179,405
7700 Storm Water 1,487,988 1,617,558 1,501,324 562,470 3,125,000 919,399 264,000 655,399
79** Housing Authority 5,925,597 12,034,382 - 11,718,930 51,836 6,189,214 1,293,526 4,895,688
Capital Project Funds
Governmental Projects 29,917,442 14,321,129 7,737,699 19,357,255 - 32,619,015 - 32,619,015
Enterprise Projects 12,179,641 988,172 8,568,773 7,026,985 425,000 14,284,601 - 14,284,601
Total Budgetary Funds 206,643,834$ 185,083,785$ 55,263,760$ 174,079,032$ 54,363,760$ 218,548,586$ 67,495,833$ 151,052,754$
Non-Budgetary Funds
Internal Service Funds
810* Equipment 18,029,196$ 7,644,662$ 483,287$ 4,669,837$ 1,308,287$ 20,179,021$ 17,481,457$ 2,697,564$
8200 Risk Management 4,314,361 1,272,634 - 1,519,371 - 4,067,623 - 4,067,623
830* Information Technology 3,545,082 3,140,886 58,085 2,645,066 133,085 3,965,902 1,553,785 2,412,117
8400 Central Services 798,111 236,591 - 220,080 - 814,622 - 814,622
8500 Health Insurance Reserves 12,309,571 11,465,512 - 9,448,606 - 14,326,476 9,697,868 4,628,608
8600 Dental Insurance Reserves 423,567 402,133 - 356,454 - 469,246 - 469,246
Total Non-Budgetary Funds 39,419,888$ 24,162,418$ 541,371$ 18,859,415$ 1,441,371$ 43,822,891$ 28,733,109$ 15,089,782$
Total All Funds 246,063,722$ 209,246,203$ 55,805,131$ 192,938,447$ 55,805,131$ 262,371,477$ 96,228,942$ 166,142,535$
City of Iowa City
Fund Summary
Fiscal Year 2022 through June 30, 2022
3
2021
Actual
2022
Budget
2022
Revised
2022
Actual Variance Percent
Budgetary Fund Revenues
General Fund
10** General Fund 59,021,824$ 58,854,140$ 59,406,832$ 58,718,064$ (688,768)$ 98.8%
Special Revenue Funds
2100 Community Dev Block Grant 1,431,648 826,573 1,210,198 765,231 (444,967) 63.2%
2110 HOME 323,187 665,356 2,884,958 290,694 (2,594,264) 10.1%
2200 Road Use Tax Fund 10,241,077 9,293,500 9,293,500 9,298,029 4,529 100.0%
2300 Other Shared Revenue 9,162,595 - 10,021,499 9,808,784 (212,715) 97.9%
2350 Metro Planning Org of Johnson Co 385,456 394,296 394,296 431,671 37,375 109.5%
2400 Employee Benefits 14,799,472 14,901,826 14,901,826 14,891,999 (9,827) 99.9%
2450 Emergency Levy Fund 1,039,399 1,046,152 1,046,152 1,042,548 (3,604) 99.7%
2500 Affordable Housing Fund 1,836,537 - - 3,076,974 3,076,974 0.0%
2510 Iowa City Property Management 85,162 127,933 127,933 243,332 115,399 190.2%
26** Tax Increment Financing 2,679,150 4,125,528 3,983,340 4,060,035 76,695 101.9%
2820 SSMID-Downtown District 503,091 470,394 470,394 467,815 (2,579) 99.5%
Debt Service Fund
5*** Debt Service 11,517,947 11,220,220 11,220,220 11,231,311 11,091 100.1%
Enterprise Funds
710* Parking 3,817,435 5,977,526 5,977,526 5,316,052 (661,474) 88.9%
715* Mass Transit 4,614,597 11,360,399 11,360,399 3,144,400 (8,215,999) 27.7%
720* Wastewater 12,340,861 12,630,210 12,630,210 11,436,194 (1,194,016) 90.5%
730* Water 10,045,311 10,815,680 10,828,954 10,073,276 (755,678) 93.0%
7400 Refuse Collection 3,915,932 3,936,670 3,956,436 3,687,488 (268,948) 93.2%
750* Landfill 8,365,111 7,329,338 7,329,338 7,688,112 358,774 104.9%
7600 Airport 398,016 373,100 373,100 450,535 77,435 120.8%
7700 Storm Water 1,714,836 1,744,660 1,744,660 1,617,558 (127,102) 92.7%
79** Housing Authority 10,236,325 10,656,382 11,930,650 12,034,382 103,732 100.9%
Capital Project Funds
Governmental Projects 15,049,424 13,150,000 21,992,030 14,321,129 (7,670,901) 65.1%
Enterprise Projects 1,733,157 292,500 2,047,942 988,172 (1,059,770) 48.3%
Total Budgetary Revenues 185,257,551$ 180,192,383$ 205,132,393$ 185,083,785$ (20,048,608)$ 90.2%
Non-Budgetary Fund Revenues
Internal Service Funds
810* Equipment 7,496,050$ 7,629,691$ 7,726,205$ 7,644,662$ (81,543)$ 98.9%
8200 Risk Management 1,624,378 1,689,680 1,689,680 1,272,634 (417,046) 75.3%
830* Information Technology 2,910,525 2,833,011 2,833,011 3,140,886 307,875 110.9%
8400 Central Services 198,909 236,009 236,009 236,591 582 100.2%
8500 Health Insurance Reserves 10,559,371 11,118,580 11,118,580 11,465,512 346,932 103.1%
8600 Dental Insurance Reserves 396,698 441,458 441,458 402,133 (39,325) 91.1%
Total Non-Budgetary Revenues 23,185,931$ 23,948,429$ 24,044,943$ 24,162,418$ 117,475$ 100.5%
Total Revenues - All Funds 208,443,482$ 204,140,812$ 229,177,336$ 209,246,203$ (19,931,133)$ 91.3%
City of Iowa City
Revenues by Fund
Fiscal Year 2022 through June 30, 2022
4
2021
Actual
2022
Budget
2022
Revised
2022
Actual Variance Percent
Budgetary Fund Revenues
Property Taxes 66,780,996$ 66,911,637$ 66,911,637$ 66,604,726$ (306,911)$ 99.5%
Other City Taxes:
TIF Revenues 2,637,854 4,125,528 3,983,340 4,015,077 31,737 100.8%
Gas/Electric Excise Taxes 643,961 636,270 636,270 684,491 48,221 107.6%
Mobile Home Taxes 63,002 51,710 51,710 56,796 5,086 109.8%
Hotel/Motel Taxes 938,048 1,134,862 1,134,862 1,167,899 33,037 102.9%
Utility Franchise Tax 993,852 883,660 883,660 891,146 7,486 100.8%
Subtotal 5,276,717 6,832,030 6,689,842 6,815,410 125,568 101.9%
Licenses, Permits, & Fees:
General Use Permits 18,029 63,210 63,210 101,740 38,530 161.0%
Food & Liquor Licenses 24,651 95,480 95,480 172,830 77,350 181.0%
Professional License 3,760 5,050 5,050 2,755 (2,295) 54.6%
Franchise Fees 441,264 581,900 581,900 407,159 (174,741) 70.0%
Construction Permits & Insp Fees 1,707,958 1,774,840 1,774,840 1,897,087 122,247 106.9%
Misc Lic & Permits 73,547 54,990 54,990 72,071 17,081 131.1%
Subtotal 2,269,210 2,575,470 2,575,470 2,653,641 78,171 103.0%
Intergovernmental:
Fed Intergovernmental Revenue 26,721,430 20,789,970 42,627,648 25,255,210 (17,372,438) 59.2%
Property Tax Credits 1,593,623 1,544,912 1,544,912 1,554,618 9,706 100.6%
Road Use Tax 10,076,978 9,163,300 9,163,300 9,108,511 (54,789) 99.4%
State 28E Agreements 2,128,143 1,964,420 2,014,420 2,093,406 78,986 103.9%
Operating Grants 61,849 66,980 66,980 58,765 (8,215) 87.7%
Disaster Assistance 2,700 - 27,043 25,085 (1,958) 0.0%
Other State Grants 2,257,948 1,532,465 4,310,043 1,902,398 (2,407,645) 44.1%
Local 28E Agreements 1,343,940 1,313,480 2,913,480 1,492,534 (1,420,946) 51.2%
Subtotal 44,186,611 36,375,527 62,667,825 41,490,526 (21,177,299) 66.2%
Charges For Fees And Services:
Building & Development 2,678,588 413,910 413,910 4,125,917 3,712,007 996.8%
Police Services 13,523 98,710 98,710 51,726 (46,984) 52.4%
Animal Care Services 11,742 13,480 13,480 19,403 5,923 143.9%
Fire Services 11,734 8,880 8,880 11,340 2,460 127.7%
Transit Fees 668,695 1,220,390 1,220,390 885,264 (335,126) 72.5%
Culture & Recreation 267,221 696,126 696,126 570,136 (125,990) 81.9%
Misc Charges For Services 57,336 61,234 61,234 66,099 4,865 107.9%
Water Charges 9,937,678 9,851,600 9,851,600 9,423,505 (428,095) 95.7%
Wastewater Charges 12,152,455 12,353,930 12,353,930 11,300,061 (1,053,869) 91.5%
Refuse Charges 4,640,676 4,334,880 4,334,880 4,288,030 (46,850) 98.9%
Landfill Charges 7,258,589 6,450,049 6,450,049 6,663,449 213,400 103.3%
Storm Water Charges 1,700,792 1,730,060 1,730,060 1,599,209 (130,851) 92.4%
Parking Charges 4,154,129 6,435,076 6,435,076 5,676,287 (758,789) 88.2%
Subtotal 43,553,158 43,668,325 43,668,325 44,680,425 1,012,100 102.3%
Miscellaneous:
Code Enforcement 67,546 306,900 306,900 115,031 (191,869) 37.5%
Parking Fines 505,391 488,220 488,220 611,270 123,050 125.2%
Library Fines & Fees 4,328 50,000 50,000 2,941 (47,059) 5.9%
Contributions & Donations 400,403 355,050 640,050 354,079 (285,971) 55.3%
Printed Materials 20,871 38,175 38,175 22,185 (15,990) 58.1%
Animal Adoption 49,080 45,000 45,000 57,840 12,840 128.5%
Misc Merchandise 17,176 41,330 41,330 21,637 (19,693) 52.4%
Intra-City Charges 5,025,342 5,812,165 5,812,165 5,673,304 (138,861) 97.6%
Other Misc Revenue 938,489 824,129 840,529 1,587,313 746,784 188.8%
Special Assessments 2,134 290 290 1,381 1,091 476.2%
Subtotal 7,030,759$ 7,961,259$ 8,262,659$ 8,446,981$ 184,322$ 102.2%
City of Iowa City
Revenues by Type
Fiscal Year 2022 through June 30, 2022
5
2021
Actual
2022
Budget
2022
Revised
2022
Actual Variance Percent
City of Iowa City
Revenues by Type
Fiscal Year 2022 through June 30, 2022
Use Of Money And Property:
Interest Revenues 981,957$ 1,484,392$ 1,484,392$ 838,949$ (645,443)$ 56.5%
Rents 1,084,618 1,264,564 1,264,564 1,511,674 247,110 119.5%
Royalties & Commissions 120,765 108,354 108,354 147,441 39,087 136.1%
Subtotal 2,187,340 2,857,310 2,857,310 2,498,064 (359,246) 87.4%
Other Financial Sources:
Debt Sales 12,744,378 12,150,000 10,100,000 10,790,326 690,326 106.8%
Sale Of Assets 616,257 521,242 1,059,742 412,307 (647,435) 38.9%
Loans 612,124 339,583 339,583 691,379 351,796 203.6%
Subtotal 13,972,759 13,010,825 11,499,325 11,894,012 394,687 103.4%
Total Budgetary Revenues 185,257,550$ 180,192,383$ 205,132,393$ 185,083,785$ (20,048,608) 90.2%
Non-Budgetary Fund Revenues
Internal Service Funds 23,185,931$ 23,948,429$ 24,044,943$ 24,162,418$ 117,475$ 100.5%
Total Non-Budgetary Revenues 23,185,931$ 23,948,429$ 24,044,943$ 24,162,418$ 117,475$ 100.5%
Total Revenues - All Funds 208,443,481$ 204,140,812$ 229,177,336$ 209,246,203$ (19,931,133)$ 91.3%
6
2021
Actual
2022
Budget
2022
Revised
2022
Actual Variance Percent
Budgetary Fund Expenditures
General Fund
10** General Fund 55,608,874$ 63,527,010$ 67,525,478$ 60,807,594$ 6,717,884$ 90.1%
Special Revenue Funds
2100 Community Dev Block Grant 1,253,229 798,093 1,093,741 706,002 387,740 64.5%
2110 HOME 281,357 522,164 2,741,766 182,162 2,559,604 6.6%
2200 Road Use Tax Fund 6,893,442 6,715,409 6,855,409 6,676,459 178,949 97.4%
2300 Other Shared Revenue 351,891 - 18,875,573 1,731,346 17,144,227 9.2%
2350 Metro Planning Org of Johnson Co. 759,938 813,751 813,751 759,879 53,872 93.4%
2400 Employee Benefits 1,790,332 1,426,486 1,426,486 1,302,276 124,210 91.3%
2450 Emergency Levy Fund 147,787 946,142 1,082,204 280,977 801,227 26.0%
2500 Affordable Housing Fund 860,507 1,000,000 1,000,000 873,449 126,551 87.3%
2510 Iowa City Property Management 76,763 72,187 72,187 204,873 (132,686) 283.8%
26** Tax Increment Financing 984,345 2,489,511 2,611,853 2,984,842 (372,989) 114.3%
2820 SSMID-Downtown District 507,191 470,394 470,394 467,815 2,579 99.5%
Debt Service Fund
5*** Debt Service 14,652,318 13,084,764 13,191,264 13,185,763 5,501 100.0%
Enterprise Funds
710* Parking 3,359,425 3,876,340 4,493,285 4,143,957 349,328 92.2%
715* Mass Transit 6,858,026 12,222,896 12,300,596 12,090,537 210,060 98.3%
720* Wastewater 9,722,217 10,036,454 10,150,067 9,916,696 233,371 97.7%
730* Water 9,063,101 9,272,922 9,555,148 9,157,704 397,444 95.8%
7400 Refuse Collection 3,798,095 4,033,627 4,093,888 4,005,202 88,686 97.8%
750* Landfill 5,617,439 5,731,930 5,756,277 5,501,012 255,265 95.6%
7600 Airport 417,765 372,257 372,257 434,849 (62,592) 116.8%
7700 Storm Water 597,005 648,988 648,988 562,470 86,518 86.7%
79** Housing Authority 11,967,304 10,390,103 11,317,990 11,718,930 (400,940) 103.5%
Capital Project Funds
Governmental Projects 17,905,672 18,165,470 54,304,592 19,357,255 34,947,337 35.6%
Enterprise Projects 5,316,333 6,638,000 23,864,580 7,026,985 16,837,596 29.4%
Total Budgetary Expenditures 158,790,354$ 173,254,898$ 254,617,773$ 174,079,032$ 80,538,742$ 68.4%
Non-Budgetary Funds Expenditures
Internal Service Funds
810* Equipment 6,650,876$ 5,419,368$ 6,367,391$ 4,669,837$ 1,697,554$ 73.3%
8200 Risk Management 1,423,612 1,710,211 1,710,211 1,519,371 190,840 88.8%
830* Information Technology 2,620,181 2,559,874 2,692,385 2,645,066 47,318 98.2%
8400 Central Services 146,775 207,587 239,587 220,080 19,507 91.9%
8500 Health Insurance Reserves 10,550,091 11,078,100 11,078,100 9,448,606 1,629,494 85.3%
8600 Dental Insurance Reserves 347,747 398,636 398,636 356,454 42,182 89.4%
Total Non-Budgetary Expenditures 21,739,282$ 21,373,776$ 22,486,310$ 18,859,415$ 3,626,894$ 83.9%
Total Expenditures - All Funds 180,529,636$ 194,628,674$ 277,104,083$ 192,938,447$ 84,165,636$ 69.6%
City of Iowa City
Expenditures by Fund
Fiscal Year 2022 through June 30, 2022
7
2021
Actual
2022
Budget
2022
Revised
2022
Actual Variance Percent
Budgetary Funds Expenditures
General Fund
10** General Fund
City Council 148,836$ 152,427$ 152,427$ 158,711$ (6,284)$ 104.1%
City Clerk 530,843 625,557 625,947 560,078 65,869 89.5%
City Attorney 823,919 871,284 872,818 850,566 22,252 97.5%
City Manager 4,078,706 4,391,026 5,789,138 4,095,138 1,694,000 70.7%
Finance 3,853,885 4,696,984 4,769,810 4,075,624 694,186 85.4%
Police 14,471,307 16,146,156 16,399,742 14,882,051 1,517,692 90.7%
Fire 8,899,332 9,194,319 9,194,319 9,160,257 34,063 99.6%
Parks & Recreation 8,340,197 10,351,897 10,687,972 9,688,849 999,123 90.7%
Library 6,083,482 7,104,248 7,129,720 6,944,038 185,681 97.4%
Senior Center 927,263 1,059,527 1,075,527 1,031,992 43,535 96.0%
Neighborhood & Development Services 4,274,656 5,147,115 7,036,588 5,859,162 1,177,426 83.3%
Public Works 2,568,025 3,148,619 3,148,619 2,847,189 301,431 90.4%
Transportation & Resource Management 608,423 637,850 642,850 653,939 (11,089) 101.7%
Total General Fund 55,608,874 63,527,010 67,525,478 60,807,594 6,717,884 90.1%
Special Revenue Funds
2100 Community Dev Block Grant
Neighborhood & Development Services 1,253,229 798,093 1,093,741 706,002 387,740 64.5%
2110 HOME
Neighborhood & Development Services 281,357 522,164 2,741,766 182,162 2,559,604 6.6%
2200 Road Use Tax Fund
Public Works 6,893,442 6,715,409 6,855,409 6,676,459 178,949 97.4%
2300 Other Shared Revenue
Neighborhood & Development Services 351,891 - 18,875,573 1,731,346 17,144,227 9.2%
2350 Metro Planning Org of Johnson Co
Neighborhood & Development Services 759,938 813,751 813,751 759,879 53,872 93.4%
2400 Employee Benefits
Finance 1,790,332 1,426,486 1,426,486 1,302,276 124,210 91.3%
2450 Emergency Levy Fund
City Manager 147,787 946,142 1,082,204 280,977 801,227 26.0%
2500 Affordable Housing Fund
Neighborhood & Development Services 860,507 1,000,000 1,000,000 873,449 126,551 87.3%
2510 Iowa City Property Management
Neighborhood & Development Services 76,763 72,187 72,187 204,873 (132,686) 283.8%
26** Tax Increment Financing
Finance 984,345 2,489,511 2,611,853 2,984,842 (372,989) 114.3%
2820 SSMID-Downtown District
Finance 507,191 470,394 470,394 467,815 2,579 99.5%
Total Special Revenue Funds 13,906,781 15,254,137 37,043,364 16,170,080 20,873,284 43.7%
Debt Service Fund
5*** Debt Service
Finance 14,652,318 13,084,764 13,191,264 13,185,763 5,501 100.0%
Total Debt Service Fund 14,652,318 13,084,764 13,191,264 13,185,763 5,501 100.0%
City of Iowa City
Expenditures by Fund by Department
Fiscal Year 2022 through June 30, 2022
8
2021
Actual
2022
Budget
2022
Revised
2022
Actual Variance Percent
City of Iowa City
Expenditures by Fund by Department
Fiscal Year 2022 through June 30, 2022
Enterprise Funds
710* Parking
Transportation & Resource Management 3,359,425$ 3,876,340$ 4,493,285$ 4,143,957$ 349,328$ 92.2%
715* Mass Transit
Transportation & Resource Management 6,858,026 12,222,896 12,300,596 12,090,537 210,060 98.3%
720* Wastewater
Public Works 9,722,217 10,036,454 10,150,067 9,916,696 233,371 97.7%
730* Water
Public Works 9,063,101 9,272,922 9,555,148 9,157,704 397,444 95.8%
7400 Refuse Collection
Transportation & Resource Management 3,798,095 4,033,627 4,093,888 4,005,202 88,686 97.8%
750* Landfill
Transportation & Resource Management 5,617,439 5,731,930 5,756,277 5,501,012 255,265 95.6%
7600 Airport
Airport Operations 417,765 372,257 372,257 434,849 (62,592) 116.8%
7700 Storm Water
Public Works 597,005 648,988 648,988 562,470 86,518 86.7%
79** Housing Authority
Neighborhood & Development Services 11,967,304 10,390,103 11,317,990 11,718,930 (400,940) 103.5%
Total Enterprise Funds 51,400,377 56,585,517 58,688,496 57,531,356 1,157,140 98.0%
Capital Project Funds
Governmental Projects 17,905,672 18,165,470 54,304,592 19,357,255 34,947,337 35.6%
Enterprise Projects 5,316,333 6,638,000 23,864,580 7,026,985 16,837,596 29.4%
Total Capital Project Funds 23,222,004 24,803,470 78,169,172 26,384,240 51,784,932 33.8%
Total Budgetary Expenditures 158,790,354$ 173,254,898$ 254,617,773$ 174,079,032$ 80,538,742$ 68.4%
Non-Budgetary Funds Expenditures
Internal Service Funds
810* Equipment
Public Works 6,650,876$ 5,419,368$ 6,367,391$ 4,669,837$ 1,697,554$ 73.3%
8200 Risk Management
Finance 1,423,612 1,710,211 1,710,211 1,519,371 190,840 88.8%
830* Information Technology
Finance 2,620,181 2,559,874 2,692,385 2,645,066 47,318 98.2%
8400 Central Services
Finance 146,775 207,587 239,587 220,080 19,507 91.9%
8500 Health Insurance Reserves
Finance 10,550,091 11,078,100 11,078,100 9,448,606 1,629,494 85.3%
8600 Dental Insurance Reserves
Finance 347,747 398,636 398,636 356,454 42,182 89.4%
Total Internal Service Funds 21,739,282 21,373,776 22,486,310 18,859,415 3,626,894 83.9%
Total Non-Budgetary Expenditures 21,739,282$ 21,373,776$ 22,486,310$ 18,859,415$ 3,626,894$ 83.9%
Total Expenditures - All Funds 180,529,636$ 194,628,674$ 277,104,083$ 192,938,447$ 84,165,636$ 69.6%
9