Loading...
FY2020 4th Qtr Financial SummaryDate: August 13, 2020 To: City Manager, City Council From: Jacklyn Fleagle, Budget & Compliance Officer Re: Quarterly Financial Summary for Period Ending June 30, 2020 Introduction Attached to this memorandum are the City’s quarterly financial reports as of June 30, 2020. The quarterly financial report includes combined summaries of all fund balances, revenues, and expenditures for fiscal year 2020 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 5-7. 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, and the COVID-19 pandemic has also had a significant impact on several funds. For the major governmental funds, their actual revenues appear to have finished the year slightly under their revised budget estimates. The General Fund is at 95.8%, the Road Use Tax Fund is at 95.9%, the Employee Benefits Fund is at 97.3%, and the Debt Service Fund is at 98.3%. Some large accruals are still outstanding such as the final Hotel/Motel Tax receipt (Other City Taxes) in the General Fund. Additionally, these funds, except for the Road Use Tax Fund, received less than budgeted property tax revenue due to the COVID-19 pandemic. The General Fund has also experienced revenue shortfalls in Licenses, Permit, and Fee revenues, Culture & Recreation charges for services, Library Fines, and Rent revenues due to the pandemic. The Road Use Tax Fund actuals should reach budgeted amounts following the accrual of June’s road use tax collections. In the major enterprise funds, the actual revenues as a percentage of the budget ranged between 61.7% and 108.1%. The Water Fund finished with revenues at 101.0% of budget, the Housing Authority Fund at 108.1% of budget and the Wastewater Fund at 102.3% 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 and interest income. Proctor & Gamble also had actuals for Water and Wastewater that exceeded their budgeted consumption due to the timing of relocating part of their operations out of state. The Parking and Mass Transit Funds may finish below budget due to revenues lost during the COVID-19 pandemic. The Parking Fund currently stands at 77.3% of budget compared to 107.3% of budget for the preliminary June 30 quarterly report for 2019. The Parking Fund will finish well under budgeted revenues due to the COVID-19 pandemic. The Transit Fund actual revenues currently stand at 61.7% of budget compared to 107.1% in 2019. Some of 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. 1 Several funds are below the 100% benchmark due to the timing of grants. These funds include the Community Development Block Grant (CDBG) Fund at 52.8%, the HOME Fund at 61.3%, the Other Shared Revenue Fund at 27.8%, and the Metro Planning Org of Johnson County at 83.8%. Additionally, both the Governmental Projects and the Enterprise Projects Capital Funds are significantly below budget at 57.8% and 74.1%, respectively. Revenues for these funds are significantly below budget due to the timing of the state and federal grant revenues and private loan repayments and not due to the pandemic. These revenues have not yet been received or earned and will be amended into next year’s budget. The combined total actual revenues for all budgetary funds through June are $163,546,674 or 89.2% of budget. The budget shortfall of $19,701,071 is primarily due to the timing of the aforementioned grant revenues and other unrecorded accruals in addition to decreased revenues due to the COVID-19 pandemic. 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 or through pandemic related revenue losses. Expenditure Analysis This expenditure analysis pertains to the expenditure reports, Expenditures by Fund and Expenditures by Fund by Department on pages 8-10. The analysis of the City’s expenditures for fiscal year 2019 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, and the COVID-19 pandemic has had a significant impact on some funds. 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.8% due to budget cuts related to the pandemic that were not amended out of the budget that was certified to the State. This includes cuts to travel and training, consulting services, and personnel wages and benefits. The Debt Service Fund is at 99.9%; however, the Employee Benefits Fund is at 106.7% primarily due to large worker’s compensation claims. The same is true for most of the City’s enterprise funds; however, the Airport fund finished at 106.7% primarily due to unbudgeted contracted improvements. Some of the other funds have actual expenditures that well are below the 100% benchmark. Those funds include the HOME Fund (82.7%), the CDBG Fund (56.9%), and the Other Shared Revenues Fund (4.5%). Also, well below budget are the Governmental Projects Fund (34.5%), and the Enterprise Projects Fund (32.6%). All of these funds contain a great deal of grant and project activity which does not always occur evenly throughout the fiscal year, and the actual results were not due to the COVID-19 pandemic. Unexpended appropriations will be carried forward into the next fiscal year and amended into the fiscal year 2021 budget. The combined total actual expenditures for all budgetary funds through June are $169,586,181 or 71.9% of budget. When the capital project funds, the CDBG, and Other Shared Revenues funds are removed from the calculation, the actual percentage of expenditures versus budget increases to 92.7%. Overall, the City’s expenditures are expected to finish at or below budget and in compliance with State law. Conclusion Generally, there are no major immediate concerns to report with the City’s fund balances at year-end other than the Parking Fund; most of the City’s fund balances finished the year near expectations or had explainable variances. The Parking Fund saw a large decrease in fund balance as a result of a steep decline in revenues due to the COVID-19 pandemic and the payoff of the Harrison Street Parking Ramp Lease Purchase Agreement. Four funds, the Community Development Block Grant (CDBG), HOME, Tax Increment Financing, and SSMID funds, are presented (on page 3) with negative fund balances at -$47,693, -$148,731, - $550,640 and -$2,762, respectively. These negative fund balances should be reversed following 2 the next receipt of CDBG funds and FEMA funds for Hazard Mitigation. The SSMID fund’s negative balance will reverse once accrual entries have been made. 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 2021 budget process in October. Additional information is available from the Finance Department upon request. 3 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$ 53,372,132$ 15,338,290$ 57,129,559$ 9,435,532$ 41,441,029$ 11,414,278$ 30,026,751$ Special Revenue Funds 2100 Community Dev Block Grant - 664,553 -708,911 3,335 (47,693) -(47,693) 2110 HOME - 761,884 -847,052 63,563 (148,731) -(148,731) 2200 Road Use Tax Fund 3,363,436 8,161,578 515,321 6,537,801 3,124,807 2,377,726 -2,377,726 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 324,021 352,210 666,417 -364,782 -364,782 2400 Employee Benefits 3,954,489 12,675,730 -1,380,902 11,982,766 3,266,551 -3,266,551 2500 Affordable Housing Fund 1,635,738 (54,333) 1,000,000 986,779 - 1,594,625 -1,594,625 2510 Peninsula Apartments 181,242 65,585 -60,736 -186,091 -186,091 26** Tax Increment Financing 977,948 3,455,123 153,693 1,536,157 2,282,448 768,159 1,318,800 (550,640) 2820 SSMID-Downtown District - 364,415 -367,177 -(2,762) -(2,762) Debt Service Fund 5*** Debt Service 9,227,709 11,977,852 1,079,685 13,038,331 -9,246,915 2,025,364 7,221,550 Enterprise Funds 710* Parking 11,195,768 4,817,582 6,513,823 13,141,966 6,940,286 2,444,921 -2,444,921 715* Mass Transit 6,576,921 2,924,445 3,721,479 8,101,933 151,894 4,969,019 3,616,616 1,352,403 720* Wastewater 20,785,876 12,037,246 13,286,071 8,926,458 14,573,311 22,609,424 11,872,368 10,737,057 730* Water 12,578,951 9,729,473 6,157,350 8,354,182 7,606,401 12,505,191 6,204,724 6,300,467 7400 Refuse Collection 1,563,487 3,521,137 5,773 3,685,452 -1,404,946 -1,404,946 750* Landfill 24,896,657 7,214,451 1,336,171 5,272,902 3,292,873 24,881,503 22,789,814 2,091,689 7600 Airport 244,898 375,528 184,271 421,723 216,471 166,503 127,071 39,432 7700 Storm Water 931,736 1,630,892 1,101,088 600,233 2,090,000 973,483 110,000 863,483 79** Housing Authority 7,339,090 10,549,534 63,563 9,898,931 49,483 8,003,773 3,343,668 4,660,105 Capital Project Funds Governmental Projects 29,941,180 16,556,840 5,492,297 22,207,582 -29,782,736 -29,782,736 Enterprise Projects 7,741,844 2,408,508 6,995,997 5,713,190 1,750,000 9,683,159 -9,683,159 Total Budgetary Funds 182,770,052$ 163,546,674$ 63,306,616$ 169,586,181$ 63,563,171$ 176,473,991$ 62,822,703$ 113,651,288$ Non-Budgetary Funds Internal Service Funds 810* Equipment 15,667,563$ 7,099,446$ -$5,802,908$ (256,554)$ 17,220,655$ 14,202,153$ 3,018,502$ 8200 Risk Management 3,883,876 1,742,910 -1,511,332 - 4,115,454 - 4,115,454 830* Information Technology 2,992,005 2,696,968 (8,890) 2,430,267 (8,890) 3,258,706 756,299 2,502,407 8400 Central Services 701,819 243,869 -188,400 -757,288 - 757,288 8500 Health Insurance Reserves 11,156,890 10,276,533 -9,229,655 -12,203,769 8,877,831 3,325,938 8600 Dental Insurance Reserves 258,467 411,519 -295,202 -374,784 -374,784 Total Non-Budgetary Funds 34,660,620$ 22,471,246$ (8,890)$ 19,457,764$ (265,444)$ 37,930,657$ 23,836,283$ 14,094,374$ Total All Funds 217,430,672$ 186,017,920$ 63,297,726$ 189,043,945$ 63,297,726$ 214,404,647$ 86,658,986$ 127,745,661$ City of Iowa City Fund Summary Fiscal Year 2020 through June 30, 2020 4 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,713,051$ 53,372,132$ (2,340,919)$ 95.8% Special Revenue Funds 2100 Community Dev Block Grant 758,935 733,511 1,258,319 664,553 (593,766) 52.8% 2110 HOME 714,103 739,722 1,243,170 761,884 (481,286) 61.3% 2200 Road Use Tax Fund 8,955,947 8,514,360 8,514,360 8,161,578 (352,783) 95.9% 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 324,021 (62,845) 83.8% 2400 Employee Benefits 12,845,423 13,031,767 13,031,767 12,675,730 (356,037) 97.3% 2500 Affordable Housing Fund 422,309 - - (54,333) (54,333) 0.0% 2510 Peninsula Apartments 70,805 73,270 73,270 65,585 (7,685) 89.5% 26** Tax Increment Financing 2,598,651 3,460,835 3,460,835 3,455,123 (5,712) 99.8% 2820 SSMID-Downtown District 397,730 398,091 398,091 364,415 (33,676) 91.5% Debt Service Fund 5*** Debt Service 12,811,836 12,190,584 12,190,584 11,977,852 (212,732) 98.3% Enterprise Funds 710* Parking 6,192,536 6,083,351 6,228,683 4,817,582 (1,411,101) 77.3% 715* Mass Transit 4,535,779 4,401,002 4,739,999 2,924,445 (1,815,554) 61.7% 720* Wastewater 13,424,866 11,768,312 11,768,312 12,037,246 268,934 102.3% 730* Water 10,065,852 9,628,406 9,628,406 9,729,473 101,067 101.0% 7400 Refuse Collection 3,717,374 3,669,983 3,677,983 3,521,137 (156,846) 95.7% 750* Landfill 7,105,849 6,994,782 7,130,406 7,214,451 84,045 101.2% 7600 Airport 367,258 363,020 376,520 375,528 (992) 99.7% 7700 Storm Water 1,595,027 1,727,010 1,727,010 1,630,892 (96,118) 94.4% 79** Housing Authority 10,293,528 9,606,558 9,761,797 10,549,534 787,737 108.1% Capital Project Funds Governmental Projects 15,145,338 17,949,000 28,642,793 16,556,840 (12,085,953) 57.8% Enterprise Projects 1,528,536 3,928,741 3,250,542 2,408,508 (842,034) 74.1% Total Budgetary Revenues 170,213,979$ 170,133,482$ 183,247,745$ 163,546,674$ (19,701,071)$ 89.2% Non-Budgetary Fund Revenues Internal Service Funds 810* Equipment 7,327,947$ 7,206,938$ 7,207,545$ 7,099,446$ (108,099)$ 98.5% 8200 Risk Management 1,671,941 1,726,350 1,726,350 1,742,910 16,560 101.0% 830* Information Technology 2,444,853 2,347,559 2,381,939 2,696,968 315,029 113.2% 8400 Central Services 252,275 268,622 268,622 243,869 (24,753) 90.8% 8500 Health Insurance Reserves 8,887,214 9,230,807 10,261,979 10,276,533 14,554 100.1% 8600 Dental Insurance Reserves 411,909 440,037 440,037 411,519 (28,518) 93.5% Total Non-Budgetary Revenues 20,996,138$ 21,220,313$ 22,286,472$ 22,471,246$ 184,774$ 100.8% Total Revenues - All Funds 191,210,117$ 191,353,795$ 205,534,217$ 186,017,920$ (19,516,297)$ 90.5% City of Iowa City Revenues by Fund Fiscal Year 2020 through June 30, 2020 5 2019 Actual 2020 Budget 2020 Revised 2020 Actual Variance Percent Budgetary Fund Revenues Property Taxes 59,115,402$ 60,296,653$ 60,296,653$ 58,758,084$ (1,538,569)$ 97.4% Other City Taxes: TIF Revenues 2,564,840 3,450,835 3,450,835 3,408,978 (41,857) 98.8% Gas/Electric Excise Taxes 667,713 676,391 676,391 677,091 700 100.1% Mobile Home Taxes 58,354 61,180 61,180 49,566 (11,614) 81.0% Hotel/Motel Taxes 1,301,827 1,045,700 1,338,597 962,431 (376,166) 71.9% Utility Franchise Tax 964,690 976,050 976,050 696,255 (279,795) 71.3% Subtotal 5,557,424 6,210,156 6,503,053 5,794,320 (708,733) 89.1% Licenses, Permits, & Fees: General Use Permits 86,756 71,650 71,650 15,063 (56,587) 21.0% Food & Liquor Licenses 126,709 110,380 110,380 95,476 (14,904) 86.5% Professional License 6,150 7,610 7,610 3,925 (3,685) 51.6% Franchise Fees 586,428 512,750 512,750 438,753 (73,997) 85.6% Construction Permits & Insp Fees 2,141,423 1,842,590 1,842,590 1,742,746 (99,844) 94.6% Misc Lic & Permits 58,608 40,830 40,830 68,060 27,230 166.7% Subtotal 3,006,074 2,585,810 2,585,810 2,364,024 (221,786) 91.4% Intergovernmental: Fed Intergovernment Revenue 13,349,850 17,803,758 20,010,750 12,217,316 (7,793,434) 61.1% Property Tax Credits 1,559,040 1,759,102 1,759,102 1,519,888 (239,214) 86.4% Road Use Tax 8,820,138 8,426,500 8,426,500 8,022,350 (404,150) 95.2% State 28E Agreements 2,060,750 2,045,110 2,083,110 2,107,692 24,582 101.2% Operating Grants 69,584 73,820 73,820 66,984 (6,836) 90.7% Other State Grants 3,203,172 3,122,281 9,316,962 5,281,394 (4,035,568) 56.7% Local 28E Agreements 1,204,577 2,791,866 5,191,866 1,348,211 (3,843,655) 26.0% Subtotal 30,267,112 36,022,437 46,862,110 30,563,834 (16,298,276) 65.2% Charges For Fees And Services: Building & Development 1,219,311 381,900 394,900 463,736 68,836 117.4% Police Services 149,766 104,990 104,990 188,901 83,911 179.9% Animal Care Services 14,922 10,780 10,780 13,484 2,704 125.1% Fire Services 9,060 7,140 7,140 8,880 1,740 124.4% Transit Fees 1,220,379 1,226,590 1,226,590 953,234 (273,356) 77.7% Culture & Recreation 767,966 778,090 778,090 467,105 (310,985) 60.0% Misc Charges For Services 69,454 73,416 73,416 53,024 (20,392) 72.2% Water Charges 9,645,556 9,336,770 9,336,770 9,378,985 42,215 100.5% Wastewater Charges 12,830,133 11,431,556 11,431,556 11,533,095 101,539 100.9% Refuse Charges 4,056,934 4,075,450 4,095,450 3,896,422 (199,028) 95.1% Landfill Charges 5,889,533 5,933,293 5,933,293 5,918,052 (15,241) 99.7% Storm Water Charges 1,568,019 1,709,510 1,709,510 1,610,745 (98,765) 94.2% Parking Charges 6,546,854 6,552,620 6,697,952 5,350,213 (1,347,739) 79.9% Subtotal 43,987,887 41,622,105 41,800,437 39,835,875 (1,964,562) 95.3% Miscellaneous: Code Enforcement 278,070 235,180 235,180 293,702 58,522 124.9% Parking Fines 602,260 475,360 475,360 430,486 (44,874) 90.6% Library Fines & Fees 135,183 106,747 106,747 60,545 (46,202) 56.7% Contributions & Donations 453,913 635,762 917,189 343,221 (573,968) 37.4% Printed Materials 51,279 40,980 40,980 39,128 (1,852) 95.5% Animal Adoption 45,839 27,960 27,960 62,646 34,686 224.1% Misc Merchandise 57,232 58,450 58,450 36,506 (21,944) 62.5% Intra-City Charges 4,428,621 4,541,411 4,541,411 4,667,718 126,307 102.8% Other Misc Revenue 851,377 676,312 547,467 831,766 284,299 151.9% Special Assessments 568 810 810 262 (548) 32.3% Subtotal 6,904,343$ 6,798,972$ 6,951,554$ 6,765,982$ (185,572)$ 97.3% City of Iowa City Revenues by Type Fiscal Year 2020 through June 30, 2020 6 2019 Actual 2020 Budget 2020 Revised 2020 Actual Variance Percent City of Iowa City Revenues by Type Fiscal Year 2020 through June 30, 2020 Use Of Money And Property: Interest Revenues 4,198,581$ 2,101,342$ 2,135,836$ 3,344,837$ 1,209,001$ 156.6% Rents 1,290,859 1,386,389 1,368,819 1,158,982 (209,837) 84.7% Royalties & Commissions 106,717 111,080 111,080 100,348 (10,732) 90.3% Subtotal 5,596,157 3,598,811 3,615,735 4,604,166 988,431 127.3% Other Financial Sources: Debt Sales 12,565,848 12,157,340 11,972,340 13,012,385 1,040,045 108.7% Sale Of Assets 1,586,827 307,477 2,126,332 901,476 (1,224,856) 42.4% Insurance Recoveries 279,874 - - 2,258 2,258 0.0% Loans 1,347,032 533,721 533,721 944,270 410,549 176.9% Subtotal 15,779,580 12,998,538 14,632,393 14,860,389 227,996 101.6% Total Budgetary Revenues 170,213,979$ 170,133,482$ 183,247,745$ 163,546,674$ (19,701,071) 89.2% Non-Budgetary Fund Revenues Internal Service Funds 20,996,138$ 21,220,313$ 22,286,472$ 22,471,246$ 184,774$ 100.8% Total Non-Budgetary Revenues 20,996,138$ 21,220,313$ 22,286,472$ 22,471,246$ 184,774$ 100.8% Total Revenues - All Funds 191,210,117$ 191,353,795$ 205,534,217$ 186,017,920$ (19,516,297)$ 90.5% 7 2019 Actual 2020 Budget 2020 Revised 2020 Actual Variance Percent Budgetary Fund Expenditures General Fund 10** General Fund 55,494,496$ 59,191,007$ 62,925,981$ 57,129,559$ 5,796,422$ 90.8% Special Revenue Funds 2100 Community Dev Block Grant 628,016 685,421 1,246,952 708,911 538,041 56.9% 2110 HOME 799,452 583,882 1,024,015 847,052 176,963 82.7% 2200 Road Use Tax Fund 6,653,708 6,534,321 6,671,348 6,537,801 133,547 98.0% 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,796 666,417 81,379 89.1% 2400 Employee Benefits 806,781 1,292,628 1,293,641 1,380,902 (87,261) 106.7% 2500 Affordable Housing Fund 995,422 1,000,000 1,415,160 986,779 428,381 69.7% 2510 Peninsula Apartments 55,583 52,168 55,706 60,736 (5,030) 109.0% 26** Tax Increment Financing 418,306 1,176,394 1,846,394 1,536,157 310,237 83.2% 2820 SSMID-Downtown District 397,730 398,091 398,091 367,177 30,914 92.2% Debt Service Fund 5*** Debt Service 13,678,214 13,039,775 13,048,333 13,038,331 10,002 99.9% Enterprise Funds 720* Wastewater 12,613,542 9,447,539 9,616,719 8,926,458 690,261 92.8% 730* Water 8,285,265 8,680,649 8,834,151 8,354,182 479,969 94.6% 7400 Refuse Collection 3,440,755 3,718,219 3,837,547 3,685,452 152,095 96.0% 750* Landfill 6,064,090 5,209,997 5,476,780 5,272,902 203,878 96.3% 7600 Airport 395,866 364,678 395,286 421,723 (26,437) 106.7% 7700 Storm Water 451,277 670,948 715,551 600,233 115,318 83.9% 79** Housing Authority 10,030,518 9,339,315 11,703,168 9,898,931 1,804,237 84.6% Capital Project Funds Governmental Projects 38,704,611 21,807,822 64,420,852 22,207,582 42,213,270 34.5% Enterprise Projects 5,595,026 9,555,460 17,541,142 5,713,190 11,827,952 32.6% Total Budgetary Expenditures 180,138,561$ 167,714,426$ 235,729,365$ 169,586,181$ 66,143,184$ 71.9% Non-Budgetary Funds Expenditures Internal Service Funds 810* Equipment 5,141,589$ 6,440,370$ 7,554,203$ 5,802,908$ 1,751,295$ 76.8% 8200 Risk Management 1,351,299 1,674,769 1,740,084 1,511,332 228,753 86.9% 830* Information Technology 2,072,637 2,280,995 2,458,386 2,430,267 28,119 98.9% 8400 Central Services 176,149 213,785 214,706 188,400 26,306 87.7% 8500 Health Insurance Reserves 9,105,067 8,796,197 10,088,009 9,229,655 858,354 91.5% 8600 Dental Insurance Reserves 344,357 429,209 429,209 295,202 134,007 68.8% Total Non-Budgetary Expenditures 18,191,098$ 19,835,325$ 22,484,597$ 19,457,764$ 3,026,833$ 86.5% Total Expenditures - All Funds 198,329,658$ 187,549,751$ 258,213,962$ 189,043,945$ 69,170,017$ 73.2% City of Iowa City Expenditures by Fund Fiscal Year 2020 through June 30, 2020 8 2019 Actual 2020 Budget 2020 Revised 2020 Actual Variance Percent Budgetary Funds Expenditures General Fund 10** General Fund City Council 110,580$ 153,065$ 165,465$ 149,211$ 16,254$ 90.2% City Clerk 540,893 570,679 576,797 488,933 87,864 84.8% City Attorney 751,266 873,609 880,104 831,480 48,624 94.5% City Manager 3,944,970 4,223,782 4,485,968 3,685,170 800,798 82.1% Finance 3,970,187 4,443,650 4,953,657 4,076,444 877,213 82.3% Police 14,073,155 14,843,901 15,396,668 14,503,544 893,124 94.2% Fire 8,292,055 8,517,508 8,644,937 8,476,996 167,941 98.1% Parks & Recreation 8,191,404 9,327,678 9,976,996 8,546,420 1,430,576 85.7% Library 6,403,794 6,920,059 6,976,883 6,326,197 650,686 90.7% Senior Center 865,825 941,522 971,109 913,616 57,493 94.1% Neighborhood & Development Services 5,619,169 5,092,304 6,466,035 6,051,359 414,676 93.6% Public Works 2,105,423 2,666,172 2,807,112 2,477,765 329,347 88.3% Transportation & Resource Management 625,773 617,078 624,250 602,424 21,826 96.5% Total General Fund 55,494,496 59,191,007 62,925,981 57,129,559 5,796,422 90.8% Special Revenue Funds 2100 Community Dev Block Grant Neighborhood & Development Services 628,016 685,421 1,246,952 708,911 538,041 56.9% 2110 HOME Neighborhood & Development Services 799,452 583,882 1,024,015 847,052 176,963 82.7% 2200 Road Use Tax Fund Public Works 6,653,708 6,534,321 6,671,348 6,537,801 133,547 98.0% 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,796 666,417 81,379 89.1% 2400 Employee Benefits Finance 806,781 1,292,628 1,293,641 1,380,902 (87,261) 106.7% 2500 Affordable Housing Fund Neighborhood & Development Services 995,422 1,000,000 1,415,160 986,779 428,381 69.7% 2510 Peninsula Apartments Neighborhood & Development Services 55,583 52,168 55,706 60,736 (5,030) 109.0% 26** Tax Increment Financing Finance 418,306 1,176,394 1,846,394 1,536,157 310,237 83.2% 2820 SSMID-Downtown District Finance 397,730 398,091 398,091 367,177 30,914 92.2% Total Special Revenue Funds 11,403,510 12,462,301 14,739,030 13,093,741 1,645,289 88.8% Debt Service Fund 5*** Debt Service Finance 13,678,214 13,039,775 13,048,333 13,038,331 10,002 99.9% Total Debt Service Fund 13,678,214 13,039,775 13,048,333 13,038,331 10,002 99.9% City of Iowa City Expenditures by Fund by Department Fiscal Year 2020 through June 30, 2020 9 2019 Actual 2020 Budget 2020 Revised 2020 Actual Variance Percent City of Iowa City Expenditures by Fund by Department Fiscal Year 2020 through June 30, 2020 Enterprise Funds 710* Parking Transportation & Resource Management 6,534,781$ 6,609,133$ 14,103,822$ 13,141,966$ 961,856$ 93.2% 715* Mass Transit Transportation & Resource Management 7,446,609 7,617,583 8,371,003 8,101,933 269,070 96.8% 720* Wastewater Public Works 12,613,542 9,447,539 9,616,719 8,926,458 690,261 92.8% 730* Water Public Works 8,285,265 8,680,649 8,834,151 8,354,182 479,969 94.6% 7400 Refuse Collection Transportation & Resource Management 3,440,755 3,718,219 3,837,547 3,685,452 152,095 96.0% 750* Landfill Transportation & Resource Management 6,064,090 5,209,997 5,476,780 5,272,902 203,878 96.3% 7600 Airport Airport Operations 395,866 364,678 395,286 421,723 (26,437) 106.7% 7700 Storm Water Public Works 451,277 670,948 715,551 600,233 115,318 83.9% 79** Housing Authority Neighborhood & Development Services 10,030,518 9,339,315 11,703,168 9,898,931 1,804,237 84.6% Total Enterprise Funds 55,262,703 51,658,061 63,054,027 58,403,779 4,650,248 92.6% Capital Project Funds Governmental Projects 38,704,611 21,807,822 64,420,852 22,207,582 42,213,270 34.5% Enterprise Projects 5,595,026 9,555,460 17,541,142 5,713,190 11,827,952 32.6% Total Capital Project Funds 44,299,637 31,363,282 81,961,994 27,920,771 54,041,223 34.1% Total Budgetary Expenditures 180,138,561$ 167,714,426$ 235,729,365$ 169,586,181$ 66,143,184$ 71.9% Non-Budgetary Funds Expenditures Internal Service Funds 810* Equipment Public Works 5,141,589$ 6,440,370$ 7,554,203$ 5,802,908$ 1,751,295$ 76.8% 8200 Risk Management Finance 1,351,299 1,674,769 1,740,084 1,511,332 228,753 86.9% 830* Information Technology Finance 2,072,637 2,280,995 2,458,386 2,430,267 28,119 98.9% 8400 Central Services Finance 176,149 213,785 214,706 188,400 26,306 87.7% 8500 Health Insurance Reserves Finance 9,105,067 8,796,197 10,088,009 9,229,655 858,354 91.5% 8600 Dental Insurance Reserves Finance 344,357 429,209 429,209 295,202 134,007 68.8% Total Internal Service Funds 18,191,098 19,835,325 22,484,597 19,457,764 3,026,833 86.5% Total Non-Budgetary Expenditures 18,191,098$ 19,835,325$ 22,484,597$ 19,457,764$ 3,026,833$ 86.5% Total Expenditures - All Funds 198,329,658$ 187,549,751$ 258,213,962$ 189,043,945$ 69,170,017$ 73.2% 10