Loading...
FY2019 2nd Qtr Financial Summary Date: January 10, 2019 To: City Manager, City Council From: Jacklyn Fleagle, Budget & Compliance Officer Re: Quarterly Financial Summary for Period Ending December 31, 2018 Introduction Attached to this memorandum are the City’s quarterly financial reports as of December 31, 2018. The quarterly financial report includes combined summaries of all fund balances, revenues, and expenditures for fiscal year 2019 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 32% due to the timing of receipt for the federal operating grant; and the Risk Management fund has actual revenues at 98.3% due to the timing of the entries made for loss reserve payments to intra-city charges. Additionally, the Governmental Projects fund has revenues of 2.1% and the Enterprise Projects funds have revenues of 3.2% 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 30.1% and Utility Franchise Taxes at 31.1% 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 timing the of grants, 28E agreements or contributions receipts include State 28E Agreements at 119.5%, Other State Grants at 7%, Local 28E Agreements at 14.3%, and Contributions & Donations at 12.6%. Additionally, under Charges for Fees and Services, Building & Development revenues are at 196% of budgeted amounts due to an unbudgeted receipt for a Fee in Lieu of Affordable Housing payment. Police Services are also already at 170.6% 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 $75,943,851 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. 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 2019 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 5.8% due to the timing of projects.  Debt Service Fund expenditures are at 33.9%, because the general obligation bond principal payments are not due until June 1.  Wastewater fund is at 72.7% due to bond principal and interest payments paid in July.  Water fund is at 58.6% due to bond principal and interest payments paid in July.  Governmental Projects expenditures are at 24.2% and Enterprise Projects expenditures are at 18.0% because many of the capital projects are scheduled for construction this spring.  Central Services fund is at 28.7% due to the timing of equipment purchases and replacements. Overall, the combined total actual expenditures for all budgetary funds through December are $88,546,225 or 37.6% 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. One fund is presented (on page 3) with negative fund balance, the Community Development Block Grant fund at -$69,172. This 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. 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 36,401,765$ 29,263,872$ 5,346,466$ 27,362,993$ 2,244,151$ 41,404,959$ 6,898,526$ 34,506,433$ Special Revenue Funds 2100 Community Dev Block Grant (25,935) 290,014 2,700 301,217 34,734 (69,172) - (69,172) 2110 HOME 191,819 379,669 - 435,909 49,752 85,827 - 85,827 2200 Road Use Tax Fund 3,893,384 4,242,908 225,773 3,043,524 1,437,670 3,880,870 - 3,880,870 2300 Other Shared Revenue 3,968 3,279 - 2,786 - 4,461 - 4,461 2350 Metro Planning Org of J.C. 262,063 142,092 166,514 282,825 - 287,844 - 287,844 2400 Employee Benefits 2,847,078 6,757,695 - 562,716 5,472,121 3,569,935 - 3,569,935 2500 Affordable Housing Fund 1,208,851 405,982 - 500,000 - 1,114,833 - 1,114,833 2510 Peninsula Apartments 166,019 36,361 - 20,897 - 181,483 - 181,483 26** Tax Increment Financing 1,525,592 1,312,703 101,257 53,475 - 2,886,078 841,803 2,044,275 2820 SSMID-Downtown District - 199,267 - 110,012 - 89,255 - 89,255 Debt Service Fund 5*** Debt Service 8,135,315 6,375,228 - 4,655,678 - 9,854,865 1,294,909 8,559,956 Enterprise Funds 710* Parking 12,222,373 3,312,000 550,410 2,003,037 821,644 13,260,102 5,812,440 7,447,662 715* Mass Transit 6,159,101 1,449,270 1,789,067 3,278,799 - 6,118,639 777,476 5,341,163 720* Wastewater 20,759,108 5,812,361 1,465,978 9,651,540 2,135,717 16,250,191 4,780,318 11,469,873 730* Water 11,938,239 4,554,707 913,523 4,920,492 837,458 11,648,519 2,721,342 8,927,178 7400 Refuse Collection 1,281,369 1,622,421 3,598 1,676,038 - 1,231,350 - 1,231,350 750* Landfill 26,940,545 3,360,767 366,974 2,430,421 245,740 27,992,125 25,139,377 2,852,747 7600 Airport 216,770 178,758 50,000 206,583 - 238,945 100,000 138,945 7700 Storm Water 795,950 687,231 678 221,467 139,000 1,123,392 - 1,123,392 79** Housing Authority 7,017,559 5,026,110 49,752 5,627,920 23,975 6,441,526 3,169,408 3,272,118 Capital Project Funds Governmental Projects 41,854,944 411,966 1,817,305 18,021,119 - 26,063,097 - 26,063,097 Enterprise Projects 9,623,259 119,189 591,967 3,176,776 - 7,157,639 - 7,157,639 Total Budgetary Funds 193,419,135$ 75,943,851$ 13,441,961$ 88,546,225$ 13,441,961$ 180,816,762$ 51,535,598$ 129,281,163$ Non-Budgetary Funds Internal Service Funds 810* Equipment 13,604,405$ 3,479,612$ -$ 2,549,703$ -$ 14,534,314$ 13,114,599$ 1,419,715$ 8200 Risk Management 3,563,234 1,568,934 - 715,250 - 4,416,918 - 4,416,918 830* Information Technology 2,799,530 1,570,963 - 897,547 - 3,472,946 330,741 3,142,205 8400 Central Services 725,692 118,748 - 55,544 - 788,896 - 788,896 8500 Health Insurance Reserves 11,374,744 4,348,922 - 4,382,111 - 11,341,555 7,589,740 3,751,815 8600 Dental Insurance Reserves 190,915 205,008 - 169,447 - 226,476 - 226,476 Total Non-Budgetary Funds 32,258,521$ 11,292,187$ -$ 8,769,602$ -$ 34,781,105$ 21,035,080$ 13,746,026$ Total All Funds 225,677,656$ 87,236,038$ 13,441,961$ 97,315,827$ 13,441,961$ 215,597,867$ 72,570,678$ 143,027,189$ City of Iowa City Fund Summary Fiscal Year 2019 through December 31, 2018 3 2018 Actual 2019 Budget 2019 Revised 2019 Actual Variance Percent Budgetary Fund Revenues General Fund 10** General Fund 51,880,377$ 53,148,922$ 55,320,453$ 29,263,872$ (26,056,581)$ 52.9% Special Revenue Funds 2100 Community Dev Block Grant 658,178 906,507 1,218,413 290,014 (928,399) 23.8% 2110 HOME 666,926 534,166 1,012,382 379,669 (632,713) 37.5% 2200 Road Use Tax Fund 8,539,943 8,744,810 8,744,810 4,242,908 (4,501,902) 48.5% 2300 Other Shared Revenue 270,089 - 48,260 3,279 (44,981) 6.8% 2350 Metro Planning Org of Johnson Co 320,459 365,748 365,748 142,092 (223,656) 38.8% 2400 Employee Benefits 11,668,231 12,908,880 12,908,880 6,757,695 (6,151,185) 52.3% 2500 Affordable Housing Fund 415,749 - - 405,982 405,982 0.0% 2510 Peninsula Apartments 73,278 77,510 77,510 36,361 (41,149) 46.9% 26** Tax Increment Financing 2,473,728 2,631,772 2,631,772 1,312,703 (1,319,069) 49.9% 2820 SSMID-Downtown District 354,385 400,124 400,124 199,267 (200,857) 49.8% Debt Service Fund 5*** Debt Service 13,288,394 12,611,282 12,611,282 6,375,228 (6,236,054) 50.6% Enterprise Funds 710* Parking 8,486,558 6,003,966 6,003,966 3,312,000 (2,691,966) 55.2% 715* Mass Transit 8,276,309 4,524,070 4,524,070 1,449,270 (3,074,800) 32.0% 720* Wastewater 13,115,285 12,636,588 12,636,588 5,812,361 (6,824,227) 46.0% 730* Water 9,827,060 9,856,522 9,856,522 4,554,707 (5,301,815) 46.2% 7400 Refuse Collection 3,521,446 3,490,210 3,490,210 1,622,421 (1,867,789) 46.5% 750* Landfill 7,028,785 6,929,796 6,929,796 3,360,767 (3,569,029) 48.5% 7600 Airport 385,582 361,500 361,500 178,758 (182,742) 49.4% 7700 Storm Water 1,589,311 1,529,350 1,529,350 687,231 (842,119) 44.9% 79** Housing Authority 9,620,510 8,921,473 8,921,473 5,026,110 (3,895,363) 56.3% Capital Project Funds Governmental Projects 12,981,814 14,023,000 19,339,380 411,966 (18,927,414) 2.1% Enterprise Projects 1,919,909 3,056,708 3,701,492 119,189 (3,582,303) 3.2% Total Budgetary Revenues 167,362,305$ 163,662,904$ 172,633,981$ 75,943,851$ (96,690,130)$ 44.0% Non-Budgetary Fund Revenues Internal Service Funds 810* Equipment 6,910,467$ 6,559,773$ 6,559,773$ 3,479,612$ (3,080,161)$ 53.0% 8200 Risk Management 1,707,274 1,596,490 1,596,490 1,568,934 (27,556) 98.3% 830* Information Technology 2,294,690 2,348,876 2,348,876 1,570,963 (777,913) 66.9% 8400 Central Services 228,890 213,912 213,912 118,748 (95,164) 55.5% 8500 Health Insurance Reserves 8,401,738 8,700,966 8,700,966 4,348,922 (4,352,044) 50.0% 8600 Dental Insurance Reserves 407,695 424,330 424,330 205,008 (219,322) 48.3% Total Non-Budgetary Revenues 19,950,754$ 19,844,347$ 19,844,347$ 11,292,187$ (8,552,160)$ 56.9% Total Revenues - All Funds 187,313,059$ 183,507,251$ 192,478,328$ 87,236,038$ (105,242,290)$ 45.3% City of Iowa City Revenues by Fund Fiscal Year 2019 through December 31, 2018 4 2018 Actual 2019 Budget 2019 Revised 2019 Actual Variance Percent Budgetary Fund Revenues Property Taxes 56,525,799$ 59,173,825$ 59,173,825$ 30,450,629$ (28,723,196)$ 51.5% Other City Taxes: TIF Revenues 2,459,216 2,621,772 2,621,772 1,304,255 (1,317,517) 49.7% Gas/Electric Excise Taxes 684,299 676,411 676,411 334,015 (342,396) 49.4% Mobile Home Taxes 61,182 65,150 65,150 37,078 (28,072) 56.9% Hotel/Motel Taxes 1,045,696 1,251,720 1,251,720 376,187 (875,533) 30.1% Utility Franchise Tax 976,060 939,400 939,400 292,355 (647,045) 31.1% Subtotal 5,226,452 5,554,453 5,554,453 2,343,890 (3,210,563) 42.2% Licenses, Permits, & Fees: General Use Permits 71,654 100,920 100,920 19,009 (81,912) 18.8% Food & Liquor Licenses 110,377 111,440 111,440 65,719 (45,721) 59.0% Professional License 7,605 12,020 12,020 2,930 (9,090) 24.4% Franchise Fees 662,448 512,750 512,750 148,958 (363,792) 29.1% Construction Permits & Insp Fees 1,850,539 1,777,650 1,777,650 1,143,787 (633,863) 64.3% Misc Lic & Permits 40,881 38,680 38,680 27,678 (11,002) 71.6% Subtotal 2,743,504 2,553,460 2,553,460 1,408,080 (1,145,380) 55.1% Intergovernmental: Fed Intergovernment Revenue 13,152,242 11,664,896 15,128,902 5,217,076 (9,911,826) 34.5% Property Tax Credits 1,554,683 1,727,320 1,727,320 783,198 (944,122) 45.3% Road Use Tax 8,426,502 8,672,280 8,672,280 4,150,061 (4,522,219) 47.9% State 28E Agreements 2,003,939 1,724,430 1,724,430 2,060,750 336,320 119.5% Operating Grants 73,825 82,690 82,690 69,584 (13,106) 84.2% Disaster Assistance 110,085 - - - - 0.0% Other State Grants 5,483,837 3,094,020 5,160,636 362,604 (4,798,032) 7.0% Local 28E Agreements 1,151,557 5,182,453 5,182,453 741,255 (4,441,198) 14.3% Subtotal 31,956,672 32,148,089 37,678,711 13,384,528 (24,294,183) 35.5% Charges For Fees And Services: Building & Development 908,376 411,120 411,120 805,998 394,878 196.0% Police Services 127,496 56,530 56,530 96,443 39,913 170.6% Animal Care Services 10,775 11,540 11,540 6,540 (5,000) 56.7% Fire Services 7,632 10,370 10,370 3,360 (7,010) 32.4% Transit Fees 1,226,643 1,261,820 1,261,820 525,140 (736,680) 41.6% Culture & Recreation 774,778 790,848 790,848 305,491 (485,357) 38.6% Misc Charges For Services 69,449 79,217 79,217 37,070 (42,147) 46.8% Water Charges 9,475,186 9,743,172 9,743,172 4,488,945 (5,254,227) 46.1% Wastewater Charges 12,621,036 12,276,650 12,276,650 5,727,513 (6,549,137) 46.7% Refuse Charges 4,010,218 3,909,630 3,909,630 1,821,334 (2,088,296) 46.6% Landfill Charges 5,933,293 6,168,980 6,168,980 2,928,011 (3,240,969) 47.5% Storm Water Charges 1,551,384 1,522,290 1,522,290 687,550 (834,740) 45.2% Parking Charges 6,331,040 6,477,470 6,477,470 3,725,399 (2,752,071) 57.5% Subtotal 43,047,304 42,719,637 42,719,637 21,158,794 (21,560,843) 49.5% Miscellaneous: Code Enforcement 232,315 222,633 222,633 120,075 (102,558) 53.9% Parking Fines 475,356 578,720 578,720 285,480 (293,240) 49.3% Library Fines & Fees 143,285 154,420 154,420 68,604 (85,816) 44.4% Contributions & Donations 890,423 369,620 768,950 96,804 (672,146) 12.6% Printed Materials 42,374 41,900 41,900 28,992 (12,908) 69.2% Animal Adoption 12,955 12,020 12,020 26,040 14,020 216.6% Misc Merchandise 55,901 54,770 54,770 34,995 (19,775) 63.9% Intra-City Charges 3,962,198 4,277,635 4,277,635 2,163,702 (2,113,933) 50.6% Other Misc Revenue 908,993 933,261 1,195,261 332,192 (863,069) 27.8% Special Assessments 808 1,090 1,090 46 (1,044) 4.2% Subtotal 6,724,608$ 6,646,069$ 7,307,399$ 3,156,930$ (4,150,469)$ 43.2% City of Iowa City Revenues by Type Fiscal Year 2019 through December 31, 2018 5 2018 Actual 2019 Budget 2019 Revised 2019 Actual Variance Percent City of Iowa City Revenues by Type Fiscal Year 2019 through December 31, 2018 Use Of Money And Property: Interest Revenues 2,879,005$ 1,071,871$ 1,071,872$ 621,580$ (450,292)$ 58.0% Rents 1,385,468 1,367,800 1,367,800 639,851 (727,949) 46.8% Royalties & Commissions 108,843 136,080 136,080 51,767 (84,313) 38.0% Subtotal 4,373,315 2,575,751 2,575,752 1,313,198 (1,262,554) 51.0% Other Financial Sources: Debt Sales 12,174,462 10,623,000 10,623,000 - (10,623,000) 0.0% Sale Of Assets 3,633,506 703,393 3,107,518 1,322,739 (1,784,779) 42.6% Insurance Recoveries - - - 279,874 279,874 0.0% Loans 956,682 965,226 1,340,226 1,125,188 (215,038) 84.0% Subtotal 16,764,651 12,291,619 15,070,744 2,727,802 (12,342,943) 18.1% Total Budgetary Revenues 167,362,305$ 163,662,903$ 172,633,981$ 75,943,851$ (96,690,130) 44.0% Non-Budgetary Fund Revenues Internal Service Funds 19,950,754$ 19,844,347$ 19,844,347$ 11,292,187$ (8,552,160)$ 56.9% Total Non-Budgetary Revenues 19,950,754$ 19,844,347$ 19,844,347$ 11,292,187$ (8,552,160)$ 56.9% Total Revenues - All Funds 187,313,059$ 183,507,250$ 192,478,328$ 87,236,038$ (105,242,290)$ 45.3% 6 2018 Actual 2019 Budget 2019 Revised 2019 Actual Variance Percent Budgetary Fund Expenditures General Fund 10** General Fund 52,714,597$ 58,159,421$ 60,911,822$ 27,362,993$ 33,548,829$ 44.9% Special Revenue Funds 2100 Community Dev Block Grant 592,163 596,507 908,413 301,217 607,196 33.2% 2110 HOME 558,825 546,166 1,024,382 435,909 588,473 42.6% 2200 Road Use Tax Fund 6,059,424 6,165,809 6,432,985 3,043,524 3,389,461 47.3% 2300 Other Shared Revenue 333,421 - 48,260 2,786 45,474 5.8% 2350 Metro Planning Org of Johnson Co. 591,338 708,554 708,554 282,825 425,729 39.9% 2400 Employee Benefits 967,457 1,283,417 1,283,417 562,716 720,701 43.8% 2500 Affordable Housing Fund 325,000 750,000 1,000,000 500,000 500,000 50.0% 2510 Peninsula Apartments 50,641 59,878 59,878 20,897 38,981 34.9% 26** Tax Increment Financing 392,130 505,193 505,193 53,475 451,718 10.6% 2820 SSMID-Downtown District 354,385 400,124 400,124 110,012 290,112 27.5% Debt Service Fund 5*** Debt Service 13,469,600 13,722,450 13,722,450 4,655,678 9,066,772 33.9% Enterprise Funds 720* Wastewater 15,738,755 13,284,732 13,284,732 9,651,540 3,633,192 72.7% 730* Water 14,382,141 8,388,774 8,393,774 4,920,492 3,473,282 58.6% 7400 Refuse Collection 3,106,776 3,433,507 3,491,007 1,676,038 1,814,969 48.0% 750* Landfill 4,940,648 5,035,196 5,035,196 2,430,421 2,604,775 48.3% 7600 Airport 468,122 357,309 357,309 206,583 150,726 57.8% 7700 Storm Water 497,954 537,865 537,865 221,467 316,398 41.2% 79** Housing Authority 9,342,128 10,952,156 10,952,156 5,627,920 5,324,236 51.4% Capital Project Funds Governmental Projects 32,499,396 23,580,970 74,415,110 18,021,119 56,393,991 24.2% Enterprise Projects 9,353,681 5,040,308 17,660,204 3,176,776 14,483,428 18.0% Total Budgetary Expenditures 185,175,387$ 167,570,307$ 235,213,971$ 88,546,225$ 146,667,746$ 37.6% Non-Budgetary Funds Expenditures Internal Service Funds 810* Equipment 5,041,436$ 4,468,094$ 4,764,743$ 2,549,703$ 2,215,040$ 53.5% 8200 Risk Management 1,947,564 1,440,328 1,440,328 715,250 725,078 49.7% 830* Information Technology 2,034,623 2,160,935 2,160,935 897,547 1,263,388 41.5% 8400 Central Services 188,468 193,387 193,387 55,544 137,843 28.7% 8500 Health Insurance Reserves 7,848,190 8,381,923 8,381,923 4,382,111 3,999,812 52.3% 8600 Dental Insurance Reserves 364,128 409,442 409,442 169,447 239,995 41.4% Total Non-Budgetary Expenditures 17,424,410$ 17,054,109$ 17,350,758$ 8,769,602$ 8,581,156$ 50.5% Total Expenditures - All Funds 202,599,797$ 184,624,416$ 252,564,729$ 97,315,827$ 155,248,902$ 38.5% City of Iowa City Expenditures by Fund Fiscal Year 2019 through December 31, 2018 7 2018 Actual 2019 Budget 2019 Revised 2019 Actual Variance Percent Budgetary Funds Expenditures General Fund 10** General Fund City Council 109,461$ 120,391$ 120,391$ 60,881$ 59,510$ 50.6% City Clerk 491,517 533,577 533,577 279,642 253,935 52.4% City Attorney 765,417 780,796 780,796 361,014 419,782 46.2% City Manager 3,056,803 4,248,266 4,378,266 1,742,422 2,635,844 39.8% Finance 3,805,542 4,345,045 4,848,045 2,438,245 2,409,800 50.3% Police 13,809,546 14,419,896 14,763,762 6,642,258 8,121,504 45.0% Fire 8,030,716 8,262,751 8,278,847 3,960,975 4,317,872 47.8% Parks & Recreation 7,993,287 8,826,119 8,841,119 3,948,993 4,892,126 44.7% Library 6,400,495 6,671,933 6,671,933 3,033,463 3,638,470 45.5% Senior Center 888,544 974,355 986,855 388,216 598,639 39.3% Neighborhood & Development Services 4,965,448 5,824,548 7,556,487 3,207,794 4,348,693 42.5% Public Works 1,909,621 2,554,182 2,554,182 1,004,168 1,550,014 39.3% Transportation & Resource Management 488,203 597,562 597,562 294,922 302,640 49.4% Total General Fund 52,714,597 58,159,421 60,911,822 27,362,993 33,548,829 44.9% Special Revenue Funds 2100 Community Dev Block Grant Neighborhood & Development Services 592,163 596,507 908,413 301,217 607,196 33.2% 2110 HOME Neighborhood & Development Services 558,825 546,166 1,024,382 435,909 588,473 42.6% 2200 Road Use Tax Fund Public Works 6,059,424 6,165,809 6,432,985 3,043,524 3,389,461 47.3% 2300 Other Shared Revenue Neighborhood & Development Services 333,421 - 48,260 2,786 45,474 5.8% 2350 Metro Planning Org of Johnson Co Neighborhood & Development Services 591,338 708,554 708,554 282,825 425,729 39.9% 2400 Employee Benefits Finance 967,457 1,283,417 1,283,417 562,716 720,701 43.8% 2500 Affordable Housing Fund Neighborhood & Development Services 325,000 750,000 1,000,000 500,000 500,000 50.0% 2510 Peninsula Apartments Neighborhood & Development Services 50,641 59,878 59,878 20,897 38,981 34.9% 26** Tax Increment Financing Finance 392,130 505,193 505,193 53,475 451,718 10.6% 2820 SSMID-Downtown District Finance 354,385 400,124 400,124 110,012 290,112 27.5% Total Special Revenue Funds 10,224,785 11,015,648 12,371,206 5,313,363 7,057,843 42.9% Debt Service Fund 5*** Debt Service Finance 13,469,600 13,722,450 13,722,450 4,655,678 9,066,772 33.9% Total Debt Service Fund 13,469,600 13,722,450 13,722,450 4,655,678 9,066,772 33.9% City of Iowa City Expenditures by Fund by Department Fiscal Year 2019 through December 31, 2018 8 2018 Actual 2019 Budget 2019 Revised 2019 Actual Variance Percent City of Iowa City Expenditures by Fund by Department Fiscal Year 2019 through December 31, 2018 Enterprise Funds 710* Parking Transportation & Resource Management 6,516,098$ 6,612,092$ 6,631,261$ 2,003,037$ 4,628,224$ 30.2% 715* Mass Transit Transportation & Resource Management 11,920,706 7,449,879 7,449,879 3,278,799 4,171,080 44.0% 720* Wastewater Public Works 15,738,755 13,284,732 13,284,732 9,651,540 3,633,192 72.7% 730* Water Public Works 14,382,141 8,388,774 8,393,774 4,920,492 3,473,282 58.6% 7400 Refuse Collection Transportation & Resource Management 3,106,776 3,433,507 3,491,007 1,676,038 1,814,969 48.0% 750* Landfill Transportation & Resource Management 4,940,648 5,035,196 5,035,196 2,430,421 2,604,775 48.3% 7600 Airport Airport Operations 468,122 357,309 357,309 206,583 150,726 57.8% 7700 Storm Water Public Works 497,954 537,865 537,865 221,467 316,398 41.2% 79** Housing Authority Neighborhood & Development Services 9,342,128 10,952,156 10,952,156 5,627,920 5,324,236 51.4% Total Enterprise Funds 66,913,328 56,051,510 56,133,179 30,016,296 26,116,883 53.5% Capital Project Funds Governmental Projects 32,499,396 23,580,970 74,415,110 18,021,119 56,393,991 24.2% Enterprise Projects 9,353,681 5,040,308 17,660,204 3,176,776 14,483,428 18.0% Total Capital Project Funds 41,853,076 28,621,278 92,075,314 21,197,895 70,877,419 23.0% Total Budgetary Expenditures 185,175,387$ 167,570,307$ 235,213,971$ 88,546,225$ 146,667,746$ 37.6% Non-Budgetary Funds Expenditures Internal Service Funds 810* Equipment Public Works 5,041,436$ 4,468,094$ 4,764,743$ 2,549,703$ 2,215,040$ 53.5% 8200 Risk Management Finance 1,947,564 1,440,328 1,440,328 715,250 725,078 49.7% 830* Information Technology Finance 2,034,623 2,160,935 2,160,935 897,547 1,263,388 41.5% 8400 Central Services Finance 188,468 193,387 193,387 55,544 137,843 28.7% 8500 Health Insurance Reserves Finance 7,848,190 8,381,923 8,381,923 4,382,111 3,999,812 52.3% 8600 Dental Insurance Reserves Finance 364,128 409,442 409,442 169,447 239,995 41.4% Total Internal Service Funds 17,424,410 17,054,109 17,350,758 8,769,602 8,581,156 50.5% Total Non-Budgetary Expenditures 17,424,410$ 17,054,109$ 17,350,758$ 8,769,602$ 8,581,156$ 50.5% Total Expenditures - All Funds 202,599,797$ 184,624,416$ 252,564,729$ 97,315,827$ 155,248,902$ 38.5% 9