HomeMy WebLinkAboutFY2020 1st Qtr Financial SummaryDate: October 22, 2019
To: City Manager, City Council
From: Jacklyn Fleagle, Budget & Compliance Officer
Re: Quarterly Financial Summary for Period Ending September 30, 2019
Introduction
Attached to this memorandum are the City’s quarterly financial reports as of September 30,
2019. The quarterly financial report includes combined summaries of all fund balances,
revenues, and expenditures for fiscal year 2020 through the end of the first quarter, which is
25% 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 25% of
budget since we have completed one-fourth of the fiscal year; however, due to accruals back to
the previous year, many of these percentages are below 25%.
For the property tax supported funds, such as the General fund, Debt Service fund, and the
Employee Benefits fund, their actual revenues are at 12.1%, 8.5%, and 8.2%, respectively.
These funds have received a lower percentage of their revenue, because the City’s property tax
receipts are due twice during the year, October and April, and the City will receive the majority
of its property tax revenue at that time. This is not the same for the City’s enterprise funds.
The City’s enterprise funds are primarily supported by service charges which cause their actual
revenues to be closer to the 25% mark. For instance, on page 4, the Water fund is at 23.5%,
the Wastewater fund is at 21.5%, and the Landfill is at 26.4%. These funds’ revenues may still
be under the 25% benchmark due to the accrual of revenues back to last fiscal year.
Other funds with budget anomalies worth noting: the HOME fund has actual revenues at 2.6%
due to the timing of receipt of federal monies; and the Risk Management fund has actual
revenues at 90.5% due to the timing of the entries made for loss reserve payments to intra-city
charges. Additionally, the Governmental Projects fund (page 4) has revenues at 1.0% due to the
interest receivable accrual as well as the timing of the Bond Issuance that does not take place
until the Spring.
In addition, on page 5, Animal Adoption revenues are at 79.6% due to a larger amount of
adoptions so far this year. Interest Revenue is at 5.3% due to the interest receivable accrual
back to the prior fiscal year.
The combined total actual revenues for all budgetary funds through September are $24,785,345
or 13.6% of budget. Overall, the City’s revenues are not substantially different than projected,
and the anomalies and budget variances can be explained.
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 September is similar to the analysis for the City’s revenues. We
generally expect the actual expenditure levels to be around 25% of budget at this time of year.
1
Some of the funds have expenditure activity through the first quarter significantly above the 25%
mark. The following funds have a significant expenditure variance above 25%:
• Affordable Housing fund is at 89.1% due to payments made to the Housing Trust Fund
of Johnson County.
• Wastewater fund is at 43.7% due bond principal and interest payments paid in July.
• Water fund is at 37.6% due to bond principal and interest payments paid in July.
• Governmental Projects expenditures are at 9.0% and Enterprise Projects expenditures
are at 11.2% because many of the capital projects are scheduled for construction next
Spring.
• Housing Authority fund is at 32.5% due to landlord rents.
Overall, the combined total actual expenditures for all budgetary funds through September are
$41,536,807 or 18.4% of budget. Overall, the City’s expenditures through the first 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 September 30.
Two funds are presented (on page 3) with negative fund balances, the HOME fund at -$5,607
and the Other Shared Revenue fund at -$6,894. 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$ 6,681,042$ 2,836,418$ 14,419,933$ 1,442,634$ 32,950,592$ 9,068,825$ 23,881,768$
Special Revenue Funds
2100 Community Dev Block Grant - 120,580 - 105,832 - 14,748 - 14,748
2110 HOME - 32,687 - 18,992 19,302 (5,607) - (5,607)
2200 Road Use Tax Fund 3,363,436 2,014,343 121,203 1,639,892 776,388 3,082,702 - 3,082,702
2300 Other Shared Revenue (17,585) 12,500 - 1,810 - (6,894) - (6,894)
2350 Metro Planning Org of J.C.354,968 44,416 88,053 153,035 - 334,402 - 334,402
2400 Employee Benefits 3,954,489 1,069,453 - 467,218 2,906,563 1,650,161 - 1,650,161
2500 Affordable Housing Fund 1,635,738 5,231 250,000 891,258 - 999,711 - 999,711
2510 Peninsula Apartments 181,242 15,924 - 14,564 - 182,602 - 182,602
26** Tax Increment Financing 977,948 222,159 40,835 - - 1,240,942 1,042,516 198,427
2820 SSMID-Downtown District - 25,487 - - - 25,487 - 25,487
Debt Service Fund
5*** Debt Service 9,227,709 1,035,994 - - - 10,263,703 2,237,121 8,026,582
Enterprise Funds
710* Parking 11,195,768 1,728,259 255,305 887,861 392,739 11,898,731 4,191,301 7,707,431
715* Mass Transit 6,576,921 827,082 930,370 1,844,854 - 6,489,519 3,777,476 2,712,043
720* Wastewater 20,785,876 2,534,533 733,808 4,192,299 921,025 18,940,893 4,258,843 14,682,050
730* Water 12,578,951 2,260,476 500,499 3,318,187 381,245 11,640,494 2,439,471 9,201,024
7400 Refuse Collection 1,563,487 709,706 828 852,178 - 1,421,842 - 1,421,842
750* Landfill 24,896,657 1,853,051 89,301 1,354,766 - 25,484,242 22,505,282 2,978,960
7600 Airport 244,898 91,630 25,000 114,700 - 246,829 100,000 146,829
7700 Storm Water 931,736 324,504 156 134,340 60,000 1,062,056 - 1,062,056
79** Housing Authority 7,339,090 2,568,973 19,302 3,055,666 12,371 6,859,327 3,278,171 3,581,156
Capital Project Funds
Governmental Projects 31,000,076 262,574 808,691 5,924,687 - 26,146,654 - 26,146,654
Enterprise Projects 7,820,988 344,741 212,500 2,144,736 - 6,233,493 - 6,233,493
Total Budgetary Funds 183,908,092$ 24,785,345$ 6,912,267$ 41,536,807$ 6,912,267$ 167,156,630$ 52,899,004$ 114,257,625$
Non-Budgetary Funds
Internal Service Funds
810* Equipment 15,667,563$ 1,652,567$ -$ 910,808$ -$ 16,409,321$ 14,181,374$ 2,227,947$
8200 Risk Management 3,883,876 1,563,080 - 445,694 - 5,001,262 - 5,001,262
830* Information Technology 2,992,005 424,484 - 644,079 - 2,772,410 639,407 2,133,002
8400 Central Services 701,819 62,422 - 32,603 - 731,638 - 731,638
8500 Health Insurance Reserves 11,156,890 2,436,827 - 2,351,661 - 11,242,056 8,877,831 2,364,225
8600 Dental Insurance Reserves 258,467 102,121 - 78,224 - 282,364 - 282,364
Total Non-Budgetary Funds 34,660,620$ 6,241,501$ -$ 4,463,070$ -$ 36,439,051$ 23,698,612$ 12,740,439$
Total All Funds 218,568,711$ 31,026,846$ 6,912,267$ 45,999,877$ 6,912,267$ 203,595,681$ 76,597,617$ 126,998,064$
City of Iowa City
Fund Summary
Fiscal Year 2020 through September 30, 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$ 6,681,042$ (48,477,124)$ 12.1%
Special Revenue Funds
2100 Community Dev Block Grant 758,935 733,511 847,897 120,580 (727,317) 14.2%
2110 HOME 714,103 739,722 1,243,170 32,687 (1,210,483) 2.6%
2200 Road Use Tax Fund 8,955,947 8,514,360 8,514,360 2,014,343 (6,500,017) 23.7%
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 44,416 (342,450) 11.5%
2400 Employee Benefits 12,845,423 13,031,767 13,031,767 1,069,453 (11,962,314) 8.2%
2500 Affordable Housing Fund 422,309 - - 5,231 5,231 0.0%
2510 Peninsula Apartments 70,805 73,270 73,270 15,924 (57,346) 21.7%
26** Tax Increment Financing 2,598,651 3,460,835 3,460,835 222,159 (3,238,676) 6.4%
2820 SSMID-Downtown District 397,730 398,091 398,091 25,487 (372,604) 6.4%
Debt Service Fund
5*** Debt Service 12,811,836 12,190,584 12,190,584 1,035,994 (11,154,590) 8.5%
Enterprise Funds
710* Parking 6,192,536 6,083,351 6,083,351 1,728,259 (4,355,092) 28.4%
715* Mass Transit 4,535,779 4,401,002 4,739,999 827,082 (3,912,917) 17.4%
720* Wastewater 13,424,866 11,768,312 11,768,312 2,534,533 (9,233,779) 21.5%
730* Water 10,065,852 9,628,406 9,628,406 2,260,476 (7,367,930) 23.5%
7400 Refuse Collection 3,717,374 3,669,983 3,669,983 709,706 (2,960,277) 19.3%
750* Landfill 7,105,849 6,994,782 7,024,276 1,853,051 (5,171,225) 26.4%
7600 Airport 367,258 363,020 363,020 91,630 (271,390) 25.2%
7700 Storm Water 1,595,027 1,727,010 1,727,010 324,504 (1,402,506) 18.8%
79** Housing Authority 10,293,528 9,606,558 9,606,558 2,568,973 (7,037,585) 26.7%
Capital Project Funds
Governmental Projects 15,145,338 17,949,000 26,892,657 262,574 (26,630,083) 1.0%
Enterprise Projects 1,528,536 3,928,741 4,842,822 344,741 (4,498,081) 7.1%
Total Budgetary Revenues 170,213,979$ 170,133,482$ 181,696,381$ 24,785,345$ (156,911,036)$ 13.6%
Non-Budgetary Fund Revenues
Internal Service Funds
810* Equipment 7,327,947$ 7,206,938$ 7,206,938$ 1,652,567$ (5,554,371)$ 22.9%
8200 Risk Management 1,671,941 1,726,350 1,726,350 1,563,080 (163,270) 90.5%
830* Information Technology 2,444,853 2,347,559 2,347,559 424,484 (1,923,075) 18.1%
8400 Central Services 252,275 268,622 268,622 62,422 (206,200) 23.2%
8500 Health Insurance Reserves 8,887,214 9,230,807 9,230,807 2,436,827 (6,793,980) 26.4%
8600 Dental Insurance Reserves 411,909 440,037 440,037 102,121 (337,916) 23.2%
Total Non-Budgetary Revenues 20,996,138$ 21,220,313$ 21,220,313$ 6,241,501$ (14,978,812)$ 29.4%
Total Revenues - All Funds 191,210,117$ 191,353,795$ 202,916,694$ 31,026,846$ (171,889,848)$ 15.3%
City of Iowa City
Revenues by Fund
Fiscal Year 2020 through September 30, 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$ 5,252,383$ (55,044,270)$ 8.7%
Other City Taxes:
TIF Revenues 2,564,840 3,450,835 3,450,835 214,762 (3,236,073) 6.2%
Gas/Electric Excise Taxes 667,713 676,391 676,391 - (676,391) 0.0%
Mobile Home Taxes 58,354 61,180 61,180 14,080 (47,100) 23.0%
Hotel/Motel Taxes 1,301,827 1,045,700 1,045,700 - (1,045,700) 0.0%
Utility Franchise Tax 964,690 976,050 976,050 1,986 (974,064) 0.2%
Subtotal 5,557,424 6,210,156 6,210,156 230,828 (5,979,328) 3.7%
Licenses, Permits, & Fees:
General Use Permits 86,756 71,650 71,650 2,342 (69,308) 3.3%
Food & Liquor Licenses 126,709 110,380 110,380 28,979 (81,401) 26.3%
Professional License 6,150 7,610 7,610 495 (7,115) 6.5%
Franchise Fees 586,428 512,750 512,750 - (512,750) 0.0%
Construction Permits & Insp Fees 2,141,423 1,842,590 1,842,590 332,997 (1,509,593) 18.1%
Misc Lic & Permits 58,608 40,830 40,830 26,198 (14,632) 64.2%
Subtotal 3,006,074 2,585,810 2,585,810 391,011 (2,194,799) 15.1%
Intergovernmental:
Fed Intergovernment Revenue 13,349,850 17,803,758 20,781,252 2,779,328 (18,001,924) 13.4%
Property Tax Credits 1,559,040 1,759,102 1,759,102 - (1,759,102) 0.0%
Road Use Tax 8,820,138 8,426,500 8,426,500 1,955,661 (6,470,839) 23.2%
State 28E Agreements 2,060,750 2,045,110 2,095,110 - (2,095,110) 0.0%
Operating Grants 69,584 73,820 73,820 - (73,820) 0.0%
Other State Grants 3,203,172 3,122,281 5,862,081 435,331 (5,426,750) 7.4%
Local 28E Agreements 1,204,577 2,791,866 6,791,866 486,297 (6,305,569) 7.2%
Subtotal 30,267,112 36,022,437 45,789,731 5,656,617 (40,133,114) 12.4%
Charges For Fees And Services:
Building & Development 1,219,311 381,900 381,900 119,403 (262,497) 31.3%
Police Services 149,766 104,990 104,990 85,883 (19,107) 81.8%
Animal Care Services 14,922 10,780 10,780 4,120 (6,660) 38.2%
Fire Services 9,060 7,140 7,140 2,160 (4,980) 30.3%
Transit Fees 1,220,379 1,226,590 1,226,590 228,789 (997,801) 18.7%
Culture & Recreation 767,966 778,090 778,090 192,785 (585,305) 24.8%
Misc Charges For Services 69,454 73,416 73,416 15,877 (57,540) 21.6%
Water Charges 9,645,556 9,336,770 9,336,770 2,221,849 (7,114,922) 23.8%
Wastewater Charges 12,830,133 11,431,556 11,431,556 2,508,131 (8,923,425) 21.9%
Refuse Charges 4,056,934 4,075,450 4,075,450 845,999 (3,229,451) 20.8%
Landfill Charges 5,889,533 5,933,293 5,933,293 1,601,641 (4,331,652) 27.0%
Storm Water Charges 1,568,019 1,709,510 1,709,510 328,919 (1,380,591) 19.2%
Parking Charges 6,546,854 6,552,620 6,552,620 2,074,352 (4,478,269) 31.7%
Subtotal 43,987,887 41,622,105 41,622,105 10,229,905 (31,392,200) 24.6%
Miscellaneous:
Code Enforcement 278,070 235,180 235,180 59,576 (175,604) 25.3%
Parking Fines 602,260 475,360 475,360 73,077 (402,283) 15.4%
Library Fines & Fees 135,183 106,747 106,747 23,162 (83,585) 21.7%
Contributions & Donations 453,913 635,762 890,743 87,743 (803,000) 9.9%
Printed Materials 51,279 40,980 40,980 10,452 (30,528) 25.5%
Animal Adoption 45,839 27,960 27,960 22,255 (5,705) 79.6%
Misc Merchandise 57,232 58,450 58,450 27,084 (31,366) 46.3%
Intra-City Charges 4,428,621 4,541,411 4,541,411 1,172,347 (3,369,064) 25.8%
Other Misc Revenue 851,377 676,312 518,587 125,163 (393,424) 24.1%
Special Assessments 568 810 810 79 (731) 9.8%
Subtotal 6,904,343$ 6,798,972$ 6,896,228$ 1,600,938$ (5,295,290)$ 23.2%
City of Iowa City
Revenues by Type
Fiscal Year 2020 through September 30, 2019
5
2019
Actual
2020
Budget
2020
Revised
2020
Actual Variance Percent
City of Iowa City
Revenues by Type
Fiscal Year 2020 through September 30, 2019
Use Of Money And Property:
Interest Revenues 4,198,581$ 2,101,342$ 2,130,836$ 113,656$ (2,017,180)$ 5.3%
Rents 1,290,859 1,386,389 1,386,389 370,754 (1,015,635) 26.7%
Royalties & Commissions 106,717 111,080 111,080 27,701 (83,379) 24.9%
Subtotal 5,596,157 3,598,811 3,628,305 512,111 (3,116,194) 14.1%
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 496,651 (1,479,681) 25.1%
Insurance Recoveries 279,874 - - - - 0.0%
Loans 1,347,032 533,721 533,721 414,901 (118,820) 77.7%
Subtotal 15,779,580 12,998,538 14,667,393 911,551 (13,755,842) 6.2%
Total Budgetary Revenues 170,213,979$ 170,133,482$ 181,696,381$ 24,785,345$ (156,911,036) 13.6%
Non-Budgetary Fund Revenues
Internal Service Funds 20,996,138$ 21,220,313$ 21,220,313$ 6,241,501$ (14,978,812)$ 29.4%
Total Non-Budgetary Revenues 20,996,138$ 21,220,313$ 21,220,313$ 6,241,501$ (14,978,812)$ 29.4%
Total Revenues - All Funds 191,210,117$ 191,353,795$ 202,916,694$ 31,026,846$ (171,889,848)$ 15.3%
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$ 14,419,933$ 47,199,311$ 23.4%
Special Revenue Funds
2100 Community Dev Block Grant 628,016 685,421 840,215 105,832 734,383 12.6%
2110 HOME 799,452 583,882 1,024,015 18,992 1,005,023 1.9%
2200 Road Use Tax Fund 6,653,708 6,534,321 6,594,916 1,639,892 4,955,024 24.9%
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 153,035 594,689 20.5%
2400 Employee Benefits 806,781 1,292,628 1,293,641 467,218 826,423 36.1%
2500 Affordable Housing Fund 995,422 1,000,000 1,000,000 891,258 108,742 89.1%
2510 Peninsula Apartments 55,583 52,168 52,168 14,564 37,604 27.9%
26** Tax Increment Financing 418,306 1,176,394 1,176,394 - 1,176,394 0.0%
2820 SSMID-Downtown District 397,730 398,091 398,091 - 398,091 0.0%
Debt Service Fund
5*** Debt Service 13,678,214 13,039,775 13,039,775 - 13,039,775 0.0%
Enterprise Funds
720* Wastewater 12,613,542 9,447,539 9,597,991 4,192,299 5,405,692 43.7%
730* Water 8,285,265 8,680,649 8,831,586 3,318,187 5,513,399 37.6%
7400 Refuse Collection 3,440,755 3,718,219 3,794,403 852,178 2,942,225 22.5%
750* Landfill 6,064,090 5,209,997 5,264,081 1,354,766 3,909,315 25.7%
7600 Airport 395,866 364,678 365,273 114,700 250,573 31.4%
7700 Storm Water 451,277 670,948 715,551 134,340 581,211 18.8%
79** Housing Authority 10,030,518 9,339,315 9,416,062 3,055,666 6,360,396 32.5%
Capital Project Funds
Governmental Projects 38,704,611 21,807,822 65,808,418 5,924,687 59,883,731 9.0%
Enterprise Projects 5,595,026 9,555,460 19,226,252 2,144,736 17,081,516 11.2%
Total Budgetary Expenditures 180,138,561$ 167,714,426$ 225,855,661$ 41,536,807$ 184,318,854$ 18.4%
Non-Budgetary Funds Expenditures
Internal Service Funds
810* Equipment 5,141,589$ 6,440,370$ 6,464,296$ 910,808$ 5,553,488$ 14.1%
8200 Risk Management 1,351,299 1,674,769 1,740,084 445,694 1,294,390 25.6%
830* Information Technology 2,072,637 2,280,995 2,322,557 644,079 1,678,478 27.7%
8400 Central Services 176,149 213,785 214,706 32,603 182,103 15.2%
8500 Health Insurance Reserves 9,105,067 8,796,197 8,796,197 2,351,661 6,444,536 26.7%
8600 Dental Insurance Reserves 344,357 429,209 429,209 78,224 350,985 18.2%
Total Non-Budgetary Expenditures 18,191,098$ 19,835,325$ 19,967,049$ 4,463,070$ 15,503,979$ 22.4%
Total Expenditures - All Funds 198,329,658$ 187,549,751$ 245,822,710$ 45,999,877$ 199,822,833$ 18.7%
City of Iowa City
Expenditures by Fund
Fiscal Year 2020 through September 30, 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$ 31,705$ 121,360$ 20.7%
City Clerk 540,893 570,679 576,797 111,776 465,022 19.4%
City Attorney 751,266 873,609 879,960 191,042 688,918 21.7%
City Manager 3,944,970 4,223,782 4,436,901 919,598 3,517,303 20.7%
Finance 3,970,187 4,443,650 4,603,381 1,409,541 3,193,840 30.6%
Police 14,073,155 14,843,901 15,084,526 3,346,678 11,737,848 22.2%
Fire 8,292,055 8,517,508 8,625,237 2,056,222 6,569,015 23.8%
Parks & Recreation 8,191,404 9,327,678 9,742,469 2,062,171 7,680,298 21.2%
Library 6,403,794 6,920,059 6,976,883 1,563,112 5,413,771 22.4%
Senior Center 865,825 941,522 954,221 201,013 753,208 21.1%
Neighborhood & Development Services 5,619,169 5,092,304 6,251,177 1,837,380 4,413,797 29.4%
Public Works 2,105,423 2,666,172 2,712,024 558,897 2,153,127 20.6%
Transportation & Resource Management 625,773 617,078 622,603 130,797 491,806 21.0%
Total General Fund 55,494,496 59,191,007 61,619,244 14,419,933 47,199,311 23.4%
Special Revenue Funds
2100 Community Dev Block Grant
Neighborhood & Development Services 628,016 685,421 840,215 105,832 734,383 12.6%
2110 HOME
Neighborhood & Development Services 799,452 583,882 1,024,015 18,992 1,005,023 1.9%
2200 Road Use Tax Fund
Public Works 6,653,708 6,534,321 6,594,916 1,639,892 4,955,024 24.9%
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 153,035 594,689 20.5%
2400 Employee Benefits
Finance 806,781 1,292,628 1,293,641 467,218 826,423 36.1%
2500 Affordable Housing Fund
Neighborhood & Development Services 995,422 1,000,000 1,000,000 891,258 108,742 89.1%
2510 Peninsula Apartments
Neighborhood & Development Services 55,583 52,168 52,168 14,564 37,604 27.9%
26** Tax Increment Financing
Finance 418,306 1,176,394 1,176,394 - 1,176,394 0.0%
2820 SSMID-Downtown District
Finance 397,730 398,091 398,091 - 398,091 0.0%
Total Special Revenue Funds 11,403,510 12,462,301 13,167,091 3,292,600 9,874,491 25.0%
Debt Service Fund
5*** Debt Service
Finance 13,678,214 13,039,775 13,039,775 - 13,039,775 0.0%
Total Debt Service Fund 13,678,214 13,039,775 13,039,775 - 13,039,775 0.0%
City of Iowa City
Expenditures by Fund by Department
Fiscal Year 2020 through September 30, 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 September 30, 2019
Enterprise Funds
710* Parking
Transportation & Resource Management 6,534,781$ 6,609,133$ 6,638,931$ 887,861$ 5,751,070$ 13.4%
715* Mass Transit
Transportation & Resource Management 7,446,609 7,617,583 8,371,003 1,844,854 6,526,149 22.0%
720* Wastewater
Public Works 12,613,542 9,447,539 9,597,991 4,192,299 5,405,692 43.7%
730* Water
Public Works 8,285,265 8,680,649 8,831,586 3,318,187 5,513,399 37.6%
7400 Refuse Collection
Transportation & Resource Management 3,440,755 3,718,219 3,794,403 852,178 2,942,225 22.5%
750* Landfill
Transportation & Resource Management 6,064,090 5,209,997 5,264,081 1,354,766 3,909,315 25.7%
7600 Airport
Airport Operations 395,866 364,678 365,273 114,700 250,573 31.4%
7700 Storm Water
Public Works 451,277 670,948 715,551 134,340 581,211 18.8%
79** Housing Authority
Neighborhood & Development Services 10,030,518 9,339,315 9,416,062 3,055,666 6,360,396 32.5%
Total Enterprise Funds 55,262,703 51,658,061 52,994,881 15,754,852 37,240,029 29.7%
Capital Project Funds
Governmental Projects 38,704,611 21,807,822 65,808,418 5,924,687 59,883,731 9.0%
Enterprise Projects 5,595,026 9,555,460 19,226,252 2,144,736 17,081,516 11.2%
Total Capital Project Funds 44,299,637 31,363,282 85,034,670 8,069,422 76,965,248 9.5%
Total Budgetary Expenditures 180,138,561$ 167,714,426$ 225,855,661$ 41,536,807$ 184,318,854$ 18.4%
Non-Budgetary Funds Expenditures
Internal Service Funds
810* Equipment
Public Works 5,141,589$ 6,440,370$ 6,464,296$ 910,808$ 5,553,488$ 14.1%
8200 Risk Management
Finance 1,351,299 1,674,769 1,740,084 445,694 1,294,390 25.6%
830* Information Technology
Finance 2,072,637 2,280,995 2,322,557 644,079 1,678,478 27.7%
8400 Central Services
Finance 176,149 213,785 214,706 32,603 182,103 15.2%
8500 Health Insurance Reserves
Finance 9,105,067 8,796,197 8,796,197 2,351,661 6,444,536 26.7%
8600 Dental Insurance Reserves
Finance 344,357 429,209 429,209 78,224 350,985 18.2%
Total Internal Service Funds 18,191,098 19,835,325 19,967,049 4,463,070 15,503,979 22.4%
Total Non-Budgetary Expenditures 18,191,098$ 19,835,325$ 19,967,049$ 4,463,070$ 15,503,979$ 22.4%
Total Expenditures - All Funds 198,329,658$ 187,549,751$ 245,822,710$ 45,999,877$ 199,822,833$ 18.7%
9