HomeMy WebLinkAboutFY2020 2nd Qtr Financial Summary
Date: January 22, 2020
To: City Manager, City Council
From: Jacklyn Fleagle, Budget & Compliance Officer
Re: Quarterly Financial Summary for Period Ending December 31, 2019
Introduction
Attached to this memorandum are the City’s quarterly financial reports as of December 31,
2019. The quarterly financial report includes combined summaries of all fund balances,
revenues, and expenditures for fiscal year 2020 through the end of the second quarter, which is
50% of the way through the fiscal year. Below are some of the highlights from this quarter’s
financial activity.
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 50% of
budget since we have completed one-half of the fiscal year; however, due to accruals back to
the previous year and quarter, many of these percentages are below 50%.
Funds with budget anomalies on page 4 worth noting: the Transit fund has actual revenues at
33.3% due to the timing of receipt for the federal operating grant; and the Risk Management
fund has actual revenues at 95.1% due to the timing of the entries made for loss reserve
payments to intra-city charges. Additionally, the Governmental Projects fund has revenues of
10.1% and the Enterprise Projects funds have revenues of 9.0% due to the timing of funding for
CIP projects through grants and bond sales.
On page 5, a few examples of revenues that are below the 50% mark due to accruals include
Hotel/Motel Taxes at 40.8% and Utility Franchise Taxes at 28.6% under Other City Taxes. Both
of these revenue sources are received quarterly, and each had the first receipt during the fiscal
year accrued back to last fiscal year. The report appears as if these revenues are behind
budget projections; however, these two revenue sources are in line with last year. The utility
enterprise fund service charges have a similar presentation.
Other revenues on page 5 that are either above or below the 50% mark due to the timing of
grants, 28E agreements or contributions receipts include Federal Intergovernment Revenue at
28.0%, State 28E Agreements at 99.4%, Local 28E Agreements at 11.4%, and Contributions &
Donations at 18.5%. Additionally, under Charges for Fees and Services, Building &
Development revenues are at 73.6% of budgeted amounts due to higher than expected plan
check fees received. Police Services are also already at 130.8% due to higher than normal
utilization of the Department by the University of Iowa.
The combined total actual revenues for all budgetary funds through December are $80,009,908
or 44.0% of budget. Overall, the City’s revenues are not substantially different than projected,
and the anomalies and budget variances can be explained.
1
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 2020 through December is similar to the analysis for the City’s revenues. We
generally expect the actual expenditure levels to be around 50% of budget at this time of year.
Some of the funds have expenditure activity through the second quarter that differs significantly
from the 50% mark. The following funds have a significant expenditure variance above or below
50%:
• Other Shared Revenue fund is at 4.5% due to the timing of projects.
• Tax Increment Financing funds are at 3.8% due to the timing of rebate payments.
• Debt Service Fund expenditures are at 6.3%, because the general obligation bond
principal payments are not due until June 1.
• Wastewater fund is at 59.3% due to bond principal and interest payments paid in July.
• Water fund is at 57.6% due to bond principal and interest payments paid in July.
• Governmental Projects expenditures are at 22.6% and Enterprise Projects expenditures
are at 16.7% because many of the capital projects are scheduled for construction this
spring.
• Equipment fund is at 34.9% due to the timing of equipment purchases and
replacements.
Overall, the combined total actual expenditures for all budgetary funds through December are
$79,652,306 or 35.3% of budget. Overall, the City’s expenditures through the second quarter
have a few major anomalies; however, these can be explained and are not unusual.
Conclusion
Generally, there are no major concerns to report with the City’s fund balances at December 31.
Two funds are presented (on page 3) with negative fund balance, the Community Development
Block Grant fund at -$56,417 and the HOME fund at -$85,116. These negative fund balances
should reverse following the receipt of grant proceeds. The other fund balances appear healthy.
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 39,295,699$ 29,384,243$ 5,781,504$ 27,399,576$ 3,031,853$ 44,030,017$ 9,187,129$ 34,842,888$
Special Revenue Funds
2100 Community Dev Block Grant - 314,296 - 367,378 3,335 (56,417) - (56,417)
2110 HOME - 200,083 - 241,726 43,473 (85,116) - (85,116)
2200 Road Use Tax Fund 3,363,436 4,183,082 252,576 3,196,113 1,736,101 2,866,880 - 2,866,880
2300 Other Shared Revenue (17,585) 12,500 9,533 1,810 - 2,639 - 2,639
2350 Metro Planning Org of J.C.354,968 140,481 176,105 305,137 - 366,417 - 366,417
2400 Employee Benefits 3,954,489 6,922,897 - 973,741 5,931,964 3,971,681 - 3,971,681
2500 Affordable Housing Fund 1,635,738 16,067 500,000 915,402 - 1,236,403 - 1,236,403
2510 Peninsula Apartments 181,242 33,729 - 33,110 - 181,861 - 181,861
26** Tax Increment Financing 977,948 1,810,630 85,016 44,181 - 2,829,413 1,234,205 1,595,208
2820 SSMID-Downtown District - 196,412 - 107,742 - 88,670 - 88,670
Debt Service Fund
5*** Debt Service 9,227,709 6,405,776 - 824,976 - 14,808,509 2,011,304 12,797,205
Enterprise Funds
710* Parking 11,195,768 3,147,438 510,611 1,821,706 785,478 12,246,632 4,259,287 7,987,346
715* Mass Transit 6,576,921 1,576,625 1,860,740 4,088,147 - 5,926,139 3,616,616 2,309,523
720* Wastewater 20,785,876 6,005,720 1,468,121 5,693,638 1,851,261 20,714,819 4,835,318 15,879,501
730* Water 12,578,951 4,914,800 1,001,437 5,083,285 881,498 12,530,405 2,831,342 9,699,063
7400 Refuse Collection 1,563,487 1,652,441 3,139 1,790,775 - 1,428,292 - 1,428,292
750* Landfill 24,896,657 3,788,037 438,476 2,656,983 188,603 26,277,584 22,947,340 3,330,244
7600 Airport 244,898 184,331 50,000 219,554 - 259,675 100,000 159,675
7700 Storm Water 931,736 764,611 592 282,705 120,000 1,294,233 - 1,294,233
79** Housing Authority 7,339,090 5,194,733 43,473 5,525,525 24,741 7,027,029 3,313,481 3,713,548
Capital Project Funds
Governmental Projects 29,941,180 2,725,905 1,679,467 14,859,552 - 19,487,000 - 19,487,000
Enterprise Projects 7,741,844 435,071 480,351 3,219,545 - 5,437,721 - 5,437,721
Total Budgetary Funds 182,770,052$ 80,009,908$ 14,341,140$ 79,652,306$ 14,598,309$ 182,870,484$ 54,336,020$ 128,534,465$
Non-Budgetary Funds
Internal Service Funds
810* Equipment 15,667,563$ 3,666,513$ -$ 2,255,330$ (257,169)$ 17,335,916$ 14,542,156$ 2,793,760$
8200 Risk Management 3,883,876 1,641,103 - 883,436 - 4,641,543 - 4,641,543
830* Information Technology 2,992,005 923,108 - 1,373,064 - 2,542,049 633,673 1,908,377
8400 Central Services 701,819 149,996 - 82,167 - 769,648 - 769,648
8500 Health Insurance Reserves 11,156,890 5,180,197 - 5,077,767 - 11,259,320 8,877,831 2,381,489
8600 Dental Insurance Reserves 258,467 206,189 - 169,399 - 295,257 - 295,257
Total Non-Budgetary Funds 34,660,620$ 11,767,107$ -$ 9,841,163$ (257,169)$ 36,843,733$ 24,053,659$ 12,790,074$
Total All Funds 217,430,672$ 91,777,015$ 14,341,140$ 89,493,469$ 14,341,140$ 219,714,218$ 78,389,679$ 141,324,538$
City of Iowa City
Fund Summary
Fiscal Year 2020 through December 31, 2019
3
2019
Actual
2020
Budget
2020
Revised
2020
Actual Variance Percent
Budgetary Fund Revenues
General Fund
10** General Fund 56,279,461$ 54,484,311$ 55,158,166$ 29,384,243$ (25,773,923)$ 53.3%
Special Revenue Funds
2100 Community Dev Block Grant 758,935 733,511 847,897 314,296 (533,601) 37.1%
2110 HOME 714,103 739,722 1,243,170 200,083 (1,043,087) 16.1%
2200 Road Use Tax Fund 8,955,947 8,514,360 8,514,360 4,183,082 (4,331,278) 49.1%
2300 Other Shared Revenue 8,333 - 44,981 12,500 (32,481) 27.8%
2350 Metro Planning Org of Johnson Co 378,503 386,866 386,866 140,481 (246,385) 36.3%
2400 Employee Benefits 12,845,423 13,031,767 13,031,767 6,922,897 (6,108,870) 53.1%
2500 Affordable Housing Fund 422,309 - - 16,067 16,067 0.0%
2510 Peninsula Apartments 70,805 73,270 73,270 33,729 (39,541) 46.0%
26** Tax Increment Financing 2,598,651 3,460,835 3,460,835 1,810,630 (1,650,205) 52.3%
2820 SSMID-Downtown District 397,730 398,091 398,091 196,412 (201,679) 49.3%
Debt Service Fund
5*** Debt Service 12,811,836 12,190,584 12,190,584 6,405,776 (5,784,808) 52.5%
Enterprise Funds
710* Parking 6,192,536 6,083,351 6,083,351 3,147,438 (2,935,913) 51.7%
715* Mass Transit 4,535,779 4,401,002 4,739,999 1,576,625 (3,163,374) 33.3%
720* Wastewater 13,424,866 11,768,312 11,768,312 6,005,720 (5,762,592) 51.0%
730* Water 10,065,852 9,628,406 9,628,406 4,914,800 (4,713,606) 51.0%
7400 Refuse Collection 3,717,374 3,669,983 3,669,983 1,652,441 (2,017,542) 45.0%
750* Landfill 7,105,849 6,994,782 7,024,276 3,788,037 (3,236,239) 53.9%
7600 Airport 367,258 363,020 363,020 184,331 (178,689) 50.8%
7700 Storm Water 1,595,027 1,727,010 1,727,010 764,611 (962,399) 44.3%
79** Housing Authority 10,293,528 9,606,558 9,606,558 5,194,733 (4,411,825) 54.1%
Capital Project Funds
Governmental Projects 15,145,338 17,949,000 26,892,657 2,725,905 (24,166,752) 10.1%
Enterprise Projects 1,528,536 3,928,741 4,842,822 435,071 (4,407,751) 9.0%
Total Budgetary Revenues 170,213,979$ 170,133,482$ 181,696,381$ 80,009,908$ (101,686,473)$ 44.0%
Non-Budgetary Fund Revenues
Internal Service Funds
810* Equipment 7,327,947$ 7,206,938$ 7,206,938$ 3,666,513$ (3,540,425)$ 50.9%
8200 Risk Management 1,671,941 1,726,350 1,726,350 1,641,103 (85,247) 95.1%
830* Information Technology 2,444,853 2,347,559 2,347,559 923,108 (1,424,451) 39.3%
8400 Central Services 252,275 268,622 268,622 149,996 (118,626) 55.8%
8500 Health Insurance Reserves 8,887,214 9,230,807 9,230,807 5,180,197 (4,050,610) 56.1%
8600 Dental Insurance Reserves 411,909 440,037 440,037 206,189 (233,848) 46.9%
Total Non-Budgetary Revenues 20,996,138$ 21,220,313$ 21,220,313$ 11,767,107$ (9,453,206)$ 55.5%
Total Revenues - All Funds 191,210,117$ 191,353,795$ 202,916,694$ 91,777,015$ (111,139,680)$ 45.2%
City of Iowa City
Revenues by Fund
Fiscal Year 2020 through December 31, 2019
4
2019
Actual
2020
Budget
2020
Revised
2020
Actual Variance Percent
Budgetary Fund Revenues
Property Taxes 59,115,402$ 60,296,653$ 60,296,653$ 31,461,147$ (28,835,506)$ 52.2%
Other City Taxes:
TIF Revenues 2,564,840 3,450,835 3,450,835 1,781,264 (1,669,571) 51.6%
Gas/Electric Excise Taxes 667,713 676,391 676,391 338,758 (337,633) 50.1%
Mobile Home Taxes 58,354 61,180 61,180 35,874 (25,306) 58.6%
Hotel/Motel Taxes 1,301,827 1,045,700 1,045,700 426,272 (619,428) 40.8%
Utility Franchise Tax 964,690 976,050 976,050 279,347 (696,703) 28.6%
Subtotal 5,557,424 6,210,156 6,210,156 2,861,514 (3,348,642) 46.1%
Licenses, Permits, & Fees:
General Use Permits 86,756 71,650 71,650 4,121 (67,529) 5.8%
Food & Liquor Licenses 126,709 110,380 110,380 57,360 (53,020) 52.0%
Professional License 6,150 7,610 7,610 2,665 (4,945) 35.0%
Franchise Fees 586,428 512,750 512,750 144,580 (368,170) 28.2%
Construction Permits & Insp Fees 2,141,423 1,842,590 1,842,590 913,342 (929,248) 49.6%
Misc Lic & Permits 58,608 40,830 40,830 41,083 253 100.6%
Subtotal 3,006,074 2,585,810 2,585,810 1,163,152 (1,422,658) 45.0%
Intergovernmental:
Fed Intergovernment Revenue 13,349,850 17,803,758 20,781,252 5,822,562 (14,958,690) 28.0%
Property Tax Credits 1,559,040 1,759,102 1,759,102 763,477 (995,625) 43.4%
Road Use Tax 8,820,138 8,426,500 8,426,500 4,081,424 (4,345,076) 48.4%
State 28E Agreements 2,060,750 2,045,110 2,095,110 2,082,626 (12,484) 99.4%
Operating Grants 69,584 73,820 73,820 66,984 (6,836) 90.7%
Other State Grants 3,203,172 3,122,281 5,862,081 2,712,901 (3,149,180) 46.3%
Local 28E Agreements 1,204,577 2,791,866 6,791,866 777,093 (6,014,774) 11.4%
Subtotal 30,267,112 36,022,437 45,789,731 16,307,066 (29,482,665) 35.6%
Charges For Fees And Services:
Building & Development 1,219,311 381,900 381,900 280,936 (100,964) 73.6%
Police Services 149,766 104,990 104,990 137,375 32,385 130.8%
Animal Care Services 14,922 10,780 10,780 7,294 (3,486) 67.7%
Fire Services 9,060 7,140 7,140 5,580 (1,560) 78.2%
Transit Fees 1,220,379 1,226,590 1,226,590 544,982 (681,608) 44.4%
Culture & Recreation 767,966 778,090 778,090 312,099 (465,991) 40.1%
Misc Charges For Services 69,454 73,416 73,416 29,764 (43,652) 40.5%
Water Charges 9,645,556 9,336,770 9,336,770 4,735,233 (4,601,537) 50.7%
Wastewater Charges 12,830,133 11,431,556 11,431,556 5,716,463 (5,715,093) 50.0%
Refuse Charges 4,056,934 4,075,450 4,075,450 1,887,827 (2,187,623) 46.3%
Landfill Charges 5,889,533 5,933,293 5,933,293 3,126,861 (2,806,433) 52.7%
Storm Water Charges 1,568,019 1,709,510 1,709,510 756,203 (953,307) 44.2%
Parking Charges 6,546,854 6,552,620 6,552,620 3,507,783 (3,044,837) 53.5%
Subtotal 43,987,887 41,622,105 41,622,105 21,048,399 (20,573,706) 50.6%
Miscellaneous:
Code Enforcement 278,070 235,180 235,180 175,989 (59,191) 74.8%
Parking Fines 602,260 475,360 475,360 200,144 (275,216) 42.1%
Library Fines & Fees 135,183 106,747 106,747 42,563 (64,184) 39.9%
Contributions & Donations 453,913 635,762 890,743 164,932 (725,811) 18.5%
Printed Materials 51,279 40,980 40,980 23,784 (17,196) 58.0%
Animal Adoption 45,839 27,960 27,960 43,321 15,361 154.9%
Misc Merchandise 57,232 58,450 58,450 30,727 (27,723) 52.6%
Intra-City Charges 4,428,621 4,541,411 4,541,411 2,316,400 (2,225,011) 51.0%
Other Misc Revenue 851,377 676,312 518,587 321,512 (197,075) 62.0%
Special Assessments 568 810 810 224 (586) 27.7%
Subtotal 6,904,343$ 6,798,972$ 6,896,228$ 3,319,597$ (3,576,631)$ 48.1%
City of Iowa City
Revenues by Type
Fiscal Year 2020 through December 31, 2019
5
2019
Actual
2020
Budget
2020
Revised
2020
Actual Variance Percent
City of Iowa City
Revenues by Type
Fiscal Year 2020 through December 31, 2019
Use Of Money And Property:
Interest Revenues 4,198,581$ 2,101,342$ 2,130,836$ 1,883,450$ (247,386)$ 88.4%
Rents 1,290,859 1,386,389 1,386,389 641,696 (744,693) 46.3%
Royalties & Commissions 106,717 111,080 111,080 44,757 (66,323) 40.3%
Subtotal 5,596,157 3,598,811 3,628,305 2,569,903 (1,058,402) 70.8%
Other Financial Sources:
Debt Sales 12,565,848 12,157,340 12,157,340 - (12,157,340) 0.0%
Sale Of Assets 1,586,827 307,477 1,976,332 579,104 (1,397,228) 29.3%
Insurance Recoveries 279,874 - - - - 0.0%
Loans 1,347,032 533,721 533,721 700,026 166,305 131.2%
Subtotal 15,779,580 12,998,538 14,667,393 1,279,130 (13,388,263) 8.7%
Total Budgetary Revenues 170,213,979$ 170,133,482$ 181,696,381$ 80,009,908$ (101,686,473) 44.0%
Non-Budgetary Fund Revenues
Internal Service Funds 20,996,138$ 21,220,313$ 21,220,313$ 11,767,107$ (9,453,206)$ 55.5%
Total Non-Budgetary Revenues 20,996,138$ 21,220,313$ 21,220,313$ 11,767,107$ (9,453,206)$ 55.5%
Total Revenues - All Funds 191,210,117$ 191,353,795$ 202,916,694$ 91,777,015$ (111,139,680)$ 45.2%
6
2019
Actual
2020
Budget
2020
Revised
2020
Actual Variance Percent
Budgetary Fund Expenditures
General Fund
10** General Fund 55,494,496$ 59,191,007$ 61,619,244$ 27,399,576$ 34,219,668$ 44.5%
Special Revenue Funds
2100 Community Dev Block Grant 628,016 685,421 840,215 367,378 472,837 43.7%
2110 HOME 799,452 583,882 1,024,015 241,726 782,289 23.6%
2200 Road Use Tax Fund 6,653,708 6,534,321 6,594,916 3,196,113 3,398,803 48.5%
2300 Other Shared Revenue 29,885 - 39,927 1,810 38,117 4.5%
2350 Metro Planning Org of Johnson Co.618,626 739,396 747,724 305,137 442,587 40.8%
2400 Employee Benefits 806,781 1,292,628 1,293,641 973,741 319,900 75.3%
2500 Affordable Housing Fund 995,422 1,000,000 1,000,000 915,402 84,598 91.5%
2510 Peninsula Apartments 55,583 52,168 52,168 33,110 19,058 63.5%
26** Tax Increment Financing 418,306 1,176,394 1,176,394 44,181 1,132,213 3.8%
2820 SSMID-Downtown District 397,730 398,091 398,091 107,742 290,349 27.1%
Debt Service Fund
5*** Debt Service 13,678,214 13,039,775 13,039,775 824,976 12,214,799 6.3%
Enterprise Funds
720* Wastewater 12,613,542 9,447,539 9,597,991 5,693,638 3,904,353 59.3%
730* Water 8,285,265 8,680,649 8,831,586 5,083,285 3,748,301 57.6%
7400 Refuse Collection 3,440,755 3,718,219 3,794,403 1,790,775 2,003,628 47.2%
750* Landfill 6,064,090 5,209,997 5,264,081 2,656,983 2,607,098 50.5%
7600 Airport 395,866 364,678 365,273 219,554 145,719 60.1%
7700 Storm Water 451,277 670,948 715,551 282,705 432,846 39.5%
79** Housing Authority 10,030,518 9,339,315 9,416,062 5,525,525 3,890,537 58.7%
Capital Project Funds
Governmental Projects 38,704,611 21,807,822 65,808,418 14,859,552 50,948,866 22.6%
Enterprise Projects 5,595,026 9,555,460 19,226,252 3,219,545 16,006,707 16.7%
Total Budgetary Expenditures 180,138,561$ 167,714,426$ 225,855,661$ 79,652,306$ 146,203,355$ 35.3%
Non-Budgetary Funds Expenditures
Internal Service Funds
810* Equipment 5,141,589$ 6,440,370$ 6,464,296$ 2,255,330$ 4,208,966$ 34.9%
8200 Risk Management 1,351,299 1,674,769 1,740,084 883,436 856,648 50.8%
830* Information Technology 2,072,637 2,280,995 2,322,557 1,373,064 949,493 59.1%
8400 Central Services 176,149 213,785 214,706 82,167 132,539 38.3%
8500 Health Insurance Reserves 9,105,067 8,796,197 8,796,197 5,077,767 3,718,430 57.7%
8600 Dental Insurance Reserves 344,357 429,209 429,209 169,399 259,810 39.5%
Total Non-Budgetary Expenditures 18,191,098$ 19,835,325$ 19,967,049$ 9,841,163$ 10,125,886$ 49.3%
Total Expenditures - All Funds 198,329,658$ 187,549,751$ 245,822,710$ 89,493,469$ 156,329,241$ 36.4%
City of Iowa City
Expenditures by Fund
Fiscal Year 2020 through December 31, 2019
7
2019
Actual
2020
Budget
2020
Revised
2020
Actual Variance Percent
Budgetary Funds Expenditures
General Fund
10** General Fund
City Council 110,580$ 153,065$ 153,065$ 65,358$ 87,707$ 42.7%
City Clerk 540,893 570,679 576,797 220,841 355,956 38.3%
City Attorney 751,266 873,609 879,960 399,416 480,544 45.4%
City Manager 3,944,970 4,223,782 4,436,901 1,700,369 2,736,532 38.3%
Finance 3,970,187 4,443,650 4,603,381 2,180,271 2,423,110 47.4%
Police 14,073,155 14,843,901 15,084,526 6,711,412 8,373,114 44.5%
Fire 8,292,055 8,517,508 8,625,237 4,067,058 4,558,179 47.2%
Parks & Recreation 8,191,404 9,327,678 9,742,469 4,025,209 5,717,261 41.3%
Library 6,403,794 6,920,059 6,976,883 3,056,106 3,920,777 43.8%
Senior Center 865,825 941,522 954,221 419,587 534,635 44.0%
Neighborhood & Development Services 5,619,169 5,092,304 6,251,177 3,149,044 3,102,133 50.4%
Public Works 2,105,423 2,666,172 2,712,024 1,118,537 1,593,487 41.2%
Transportation & Resource Management 625,773 617,078 622,603 286,369 336,234 46.0%
Total General Fund 55,494,496 59,191,007 61,619,244 27,399,576 34,219,668 44.5%
Special Revenue Funds
2100 Community Dev Block Grant
Neighborhood & Development Services 628,016 685,421 840,215 367,378 472,837 43.7%
2110 HOME
Neighborhood & Development Services 799,452 583,882 1,024,015 241,726 782,289 23.6%
2200 Road Use Tax Fund
Public Works 6,653,708 6,534,321 6,594,916 3,196,113 3,398,803 48.5%
2300 Other Shared Revenue
Neighborhood & Development Services 29,885 - 39,927 1,810 38,117 4.5%
2350 Metro Planning Org of Johnson Co
Neighborhood & Development Services 618,626 739,396 747,724 305,137 442,587 40.8%
2400 Employee Benefits
Finance 806,781 1,292,628 1,293,641 973,741 319,900 75.3%
2500 Affordable Housing Fund
Neighborhood & Development Services 995,422 1,000,000 1,000,000 915,402 84,598 91.5%
2510 Peninsula Apartments
Neighborhood & Development Services 55,583 52,168 52,168 33,110 19,058 63.5%
26** Tax Increment Financing
Finance 418,306 1,176,394 1,176,394 44,181 1,132,213 3.8%
2820 SSMID-Downtown District
Finance 397,730 398,091 398,091 107,742 290,349 27.1%
Total Special Revenue Funds 11,403,510 12,462,301 13,167,091 6,186,339 6,980,752 47.0%
Debt Service Fund
5*** Debt Service
Finance 13,678,214 13,039,775 13,039,775 824,976 12,214,799 6.3%
Total Debt Service Fund 13,678,214 13,039,775 13,039,775 824,976 12,214,799 6.3%
City of Iowa City
Expenditures by Fund by Department
Fiscal Year 2020 through December 31, 2019
8
2019
Actual
2020
Budget
2020
Revised
2020
Actual Variance Percent
City of Iowa City
Expenditures by Fund by Department
Fiscal Year 2020 through December 31, 2019
Enterprise Funds
710* Parking
Transportation & Resource Management 6,534,781$ 6,609,133$ 6,638,931$ 1,821,706$ 4,817,225$ 27.4%
715* Mass Transit
Transportation & Resource Management 7,446,609 7,617,583 8,371,003 4,088,147 4,282,856 48.8%
720* Wastewater
Public Works 12,613,542 9,447,539 9,597,991 5,693,638 3,904,353 59.3%
730* Water
Public Works 8,285,265 8,680,649 8,831,586 5,083,285 3,748,301 57.6%
7400 Refuse Collection
Transportation & Resource Management 3,440,755 3,718,219 3,794,403 1,790,775 2,003,628 47.2%
750* Landfill
Transportation & Resource Management 6,064,090 5,209,997 5,264,081 2,656,983 2,607,098 50.5%
7600 Airport
Airport Operations 395,866 364,678 365,273 219,554 145,719 60.1%
7700 Storm Water
Public Works 451,277 670,948 715,551 282,705 432,846 39.5%
79** Housing Authority
Neighborhood & Development Services 10,030,518 9,339,315 9,416,062 5,525,525 3,890,537 58.7%
Total Enterprise Funds 55,262,703 51,658,061 52,994,881 27,162,318 25,832,563 51.3%
Capital Project Funds
Governmental Projects 38,704,611 21,807,822 65,808,418 14,859,552 50,948,866 22.6%
Enterprise Projects 5,595,026 9,555,460 19,226,252 3,219,545 16,006,707 16.7%
Total Capital Project Funds 44,299,637 31,363,282 85,034,670 18,079,097 66,955,573 21.3%
Total Budgetary Expenditures 180,138,561$ 167,714,426$ 225,855,661$ 79,652,306$ 146,203,355$ 35.3%
Non-Budgetary Funds Expenditures
Internal Service Funds
810* Equipment
Public Works 5,141,589$ 6,440,370$ 6,464,296$ 2,255,330$ 4,208,966$ 34.9%
8200 Risk Management
Finance 1,351,299 1,674,769 1,740,084 883,436 856,648 50.8%
830* Information Technology
Finance 2,072,637 2,280,995 2,322,557 1,373,064 949,493 59.1%
8400 Central Services
Finance 176,149 213,785 214,706 82,167 132,539 38.3%
8500 Health Insurance Reserves
Finance 9,105,067 8,796,197 8,796,197 5,077,767 3,718,430 57.7%
8600 Dental Insurance Reserves
Finance 344,357 429,209 429,209 169,399 259,810 39.5%
Total Internal Service Funds 18,191,098 19,835,325 19,967,049 9,841,163 10,125,886 49.3%
Total Non-Budgetary Expenditures 18,191,098$ 19,835,325$ 19,967,049$ 9,841,163$ 10,125,886$ 49.3%
Total Expenditures - All Funds 198,329,658$ 187,549,751$ 245,822,710$ 89,493,469$ 156,329,241$ 36.4%
9