Loading...
FY2017 4th Qtr Financial Summary Date: August 17, 2017 To: City Manager, City Council From: Jacklyn Budding, Budget & Compliance Officer Re: Quarterly Financial Summary for Period Ending June 30, 2017 Introduction Attached to this memorandum are the City’s quarterly financial reports as of June 30, 2017. The quarterly financial report includes combined summaries of all fund balances, revenues, and expenditures for fiscal year 2017 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 Eide Bailly. Revenue Analysis This revenue analysis pertains to the revenue reports, Revenues by Fund and Revenues by Type, on pages 4-6. In these two reports, the actual revenues would ideally be near 100% of budget since we have completed the fiscal year; however, not all of the accrued revenues have been received and posted yet. For the major governmental funds, their actual revenues appear to have finished the year very close to their revised budget estimates. The General Fund is at 100.7%, the Road Use Tax Fund is at 104.9%, the Employee Benefits Fund is at 100.0%, and the Debt Service Fund is at 98.9%. Some large accruals are still outstanding such as the final Hotel/Motel Tax receipt (Other City Taxes) in the General Fund, but overall, these funds appear to have received revenues in line with what we were anticipating. In the major enterprise funds, the actual revenues as a percentage of the budget ranged between 42.5% and 158.0%. The Wastewater Fund finished with revenues at 135.3% of budget and the Water Fund finished with revenues at 158.0% of budget. These percentages are misleading, however, as the actual figures include the unbudgeted bond proceeds. When the bond proceeds are removed from the totals, the actual percentages fall to 94.6% for the Wastewater Fund and to 98.7% for the Water Fund. These two funds also have a large accrual remaining for unbilled water/sewer fees which should push their actual revenue totals closer to 100%. Several funds are below the 100% benchmark due to the timing of grants. These funds include the Community Development Block Grant (CDBG) Fund at 60.0%, the HOME Fund at 36.5%, the Other Shared Revenue Fund at 48.8%, the Metro Planning Org of Johnson County at 77.1%, and the Transit Fund at 42.5%. Revenues for these funds are significantly below budget due to the timing of the state and federal grant revenues and private loan repayments. These revenues have not yet been received or earned and will be amended into next year’s budget. The combined total actual revenues for all budgetary funds through June are $188,745,280 or 103.4% of budget. When the two revenue bond refunding transactions are removed the total drops to $178,204,649 or 97.6% of budget. The budget shortfall of $4,357,582 is primarily due to the timing of the aforementioned grant revenues and other unrecorded accruals. Overall, the City’s revenues are not substantially different than projected, and most of 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 2017 through June is similar to the analysis for the City’s revenues. We generally expect the actual expenditure levels to be around 100% of budget at this time of year. Also, similar to the revenues, not all accruals have been recorded and posted yet. For the majority of the City’s funds, their actual expenditures are currently at or below 100% of their budgeted expenditures. The General Fund is at 93.7%, the Road Use Tax Fund is at 87.8%, and the Debt Service Fund is at 98.9%. The same is true for most of the City’s enterprise funds; however, the Parking fund finished at 120.1% primarily due to the Lease-Purchase Agreement debt payments after closing early on the debt agreement. Additionally the Housing Authority Funds finished at 110.9% of budget primarily due to landlord rent payments and the Airport Fund finished at 105.7% of budget primarily due to a number of major repairs that occurred. Note the Housing Authority Funds expenditures were largely offset by an increase in the fund’s revenues (105.9% of budget). Some of the other funds have actual expenditures that well are below the 100% benchmark. Those funds include the HOME Fund (24.0%), the Other Shared Revenue Fund (63.6%), and the Affordable Housing Fund (50.0%). Also well below budget are the Governmental Projects Fund (40.4%), and the Enterprise Projects Fund (25.4%). All of these funds contain a great deal of grant and project activity which does not always occur evenly throughout the fiscal year. Unexpended appropriations will be carried forward into the next fiscal year and amended into the fiscal year 2018 budget. The combined total actual expenditures for all budgetary funds through June are $175,427,080 or 72.4% of budget. When the capital project funds and the HOME, Other Shared Revenue, and Affordable Housing funds are removed from the calculation, the actual percentage of expenditures versus budget increases to 94.8%. 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 concerns to report with the City’s fund balances at year-end; most of the City’s fund balances finished the year near expectations or had explainable variances. Two funds, the Community Development Block Grant (CDBG) and Other Shared Revenue fund, are presented (on page 3) with negative fund balances at -$13,587 and -$70,853, respectively. These negative fund balances should be reversed following the next receipt of CDBG funds and FEMA funds for Hazard Mitigation. This year-end report is preliminary and accruals for revenues and expenditure are still outstanding. The City’s final financial performance will be available for the start of the fiscal year 2019 budget process in October. Additional information is available from the Finance Department upon request. 2 Beginning Ending Restricted,Unassigned Fund Year-to-Date Transfers Year-to-Date Transfers Fund Committed,Fund Balance Revenues In Expenditures Out Balance Assigned Balance Budgetary Funds General Fund 10** General Fund 48,135,654$ 50,385,252$ 10,655,199$ 51,942,547$ 17,804,258$ 39,429,299$ 15,063,886$ 24,365,413$ Special Revenue Funds 2100 Community Dev Block Gran 448,892 1,007,394 4,491 1,387,913 86,451 (13,587) - (13,587) 2110 HOME - 296,464 - 192,082 - 104,382 - 104,382 2200 Road Use Tax Fund 5,767,142 8,803,148 330,662 5,261,317 3,924,281 5,715,353 - 5,715,353 2300 Other Shared Revenue 152,415 421,765 5,163 650,196 - (70,853) - (70,853) 2350 Metro Planning Org of J.C.302,423 246,375 268,255 605,768 - 211,286 - 211,286 2400 Employee Benefits 1,670,848 11,145,984 - 947,891 9,427,583 2,441,357 - 2,441,357 2500 Affordable Housing Fund 1,000,000 2,591 - 500,000 35,824 466,767 466,767 2510 Peninsula Apartments 124,888 77,075 - 59,122 - 142,841 - 142,841 26** Tax Increment Financing 239,487 2,228,905 - - 1,987,732 480,660 476,815 3,845 2820 SSMID-Downtown District - 318,343 - 317,925 - 418 - 418 Debt Service Fund 5*** Debt Service 6,000,281 14,247,811 2,096,112 15,218,289 - 7,125,915 1,525,364 5,600,551 Permanent Funds 6001 Perpetual Care 116,266 - - - 116,266 - - - Enterprise Funds 710* Parking 10,742,693 5,795,295 1,100,821 4,223,651 2,054,185 11,360,973 5,500,000 5,860,973 715* Mass Transit 5,455,387 3,056,732 3,271,633 6,893,774 185,000 4,704,979 811,390 3,893,589 720* Wastewater 30,106,670 17,033,402 4,695,322 21,256,420 6,230,560 24,348,414 14,363,613 9,984,801 730* Water 16,240,827 14,399,086 1,881,033 12,324,333 2,573,073 17,623,540 9,358,062 8,265,478 7400 Refuse Collection 1,245,110 2,959,464 - 3,052,968 - 1,151,606 - 1,151,606 750* Landfill 24,926,190 6,886,640 1,203,886 4,931,921 1,510,773 26,574,021 24,703,421 1,870,600 7600 Airport 572,874 347,396 113,209 668,880 60,561 304,038 100,000 204,038 7700 Storm water 1,170,823 1,596,564 - 740,486 1,080,265 946,637 - 946,637 79** Housing Authority 6,350,911 9,112,627 - 8,615,724 46,087 6,801,726 3,087,194 3,714,533 Capital Project Funds Governmental Projects 21,966,585 33,988,452 20,148,574 32,000,665 373,674 43,729,271 - 43,729,271 Enterprise Projects 10,232,849 4,388,516 2,452,534 3,635,206 225,000 13,213,692 - 13,213,692 Total Budgetary Funds 192,969,216$ 188,745,280$ 48,226,893$ 175,427,080$ 47,721,575$ 206,792,734$ 74,989,744$ 131,802,990$ Non-Budgetary Funds Capital Project Funds Internal Service Projects 66,776$ 174$ (5,318)$ 61,633$ -$ -$ -$ -$ Internal Service Funds 810* Equipment 11,749,371 6,038,433 265,419 4,669,504 265,419 13,118,300 11,454,040 1,664,260 8200 Risk Management 3,414,156 1,614,469 - 1,236,981 - 3,791,644 - 3,791,644 830* Information Technology 2,516,722 2,139,921 154,561 1,619,223 654,561 2,537,420 437,378 2,100,042 8400 Central Services 667,695 239,214 - 200,951 - 705,958 - 705,958 8500 Health Insurance Reserves 9,902,794 8,111,669 - 7,325,378 - 10,689,085 4,282,539 6,406,546 8600 Dental Insurance Reserves 137,107 383,801 - 374,002 - 146,906 - 146,906 Total Non-Budgetary Funds 28,454,622$ 18,527,681$ 414,662$ 15,487,672$ 919,980$ 30,989,313$ 16,173,957$ 14,815,356$ Total All Funds 221,423,838$ 207,272,961$ 48,641,555$ 190,914,751$ 48,641,555$ 237,782,047$ 91,163,702$ 146,618,345$ City of Iowa City Fund Summary Fiscal Year 2017 through June 30, 2017 3 2016 Actual 2017 Budget 2017 Revised 2017 Actual Variance Percent Budgetary Fund Revenues General Fund 10** General Fund 48,667,850$ 50,044,369$ 50,055,719$ 50,385,252$ 329,533$ 100.7% Special Revenue Funds 2100 Community Dev Block Grant 989,380 706,000 1,678,012 1,007,394 (670,618) 60.0% 2110 HOME 614,958 421,000 813,343 296,464 (516,879) 36.5% 2200 Road Use Tax Fund 8,411,456 7,906,232 8,389,233 8,803,148 413,915 104.9% 2300 Other Shared Revenue 380,110 - 865,105 421,765 (443,340) 48.8% 2350 Metro Planning Org of Johnson Co 298,671 319,369 319,369 246,375 (72,994) 77.1% 2400 Employee Benefits 10,516,769 11,144,971 11,144,971 11,145,984 1,013 100.0% 2500 Affordable Housing Fund 1,000,000 - - 2,591 2,591 0.0% 2510 Peninsula Apartments 72,243 74,000 74,000 77,075 3,075 104.2% 26** Tax Increment Financing 1,030,833 2,276,953 2,276,953 2,228,905 (48,048) 97.9% 2820 SSMID-Downtown District 295,284 321,151 317,859 318,343 484 100.2% Debt Service Fund 5*** Debt Service 13,301,893 13,645,137 14,403,347 14,247,811 (155,536) 98.9% Permanent Funds 6001 Perpetual Care 384 500 500 - (500) 0.0% Enterprise Funds 710* Parking 11,016,908 5,625,275 5,680,448 5,795,295 114,847 102.0% 715* Mass Transit 4,582,386 7,120,613 7,196,613 3,056,732 (4,139,881) 42.5% 720* Wastewater 22,742,715 12,588,588 12,588,588 17,033,402 4,444,814 135.3% 730* Water 13,346,893 9,111,655 9,111,655 14,399,086 5,287,431 158.0% 7400 Refuse Collection 3,130,252 3,173,900 3,173,900 2,959,464 (214,436) 93.2% 750* Landfill 6,268,826 5,977,982 5,977,982 6,886,640 908,658 115.2% 7600 Airport 341,499 359,500 359,500 347,396 (12,104) 96.6% 7700 Storm Water 1,173,615 1,516,221 1,653,147 1,596,564 (56,583) 96.6% 79** Housing Authority 8,819,308 8,501,334 8,608,075 9,112,627 504,552 105.9% Capital Project Funds Governmental Projects 16,503,591 19,553,084 33,687,473 33,988,452 300,979 100.9% Enterprise Projects 1,911,092 2,690,898 4,186,439 4,388,516 202,077 104.8% Total Budgetary Revenues 175,416,916$ 163,078,732$ 182,562,231$ 188,745,280$ 6,183,049$ 103.4% Non-Budgetary Fund Revenues - Capital Project Funds Internal Service Projects 25,195$ -$ -$ 174$ 174$ 0.0% Internal Service Funds 810* Equipment 5,912,284 6,379,763 6,379,763 6,038,433 (341,330) 94.6% 8200 Risk Management 1,547,056 1,623,145 1,623,145 1,614,469 (8,676) 99.5% 830* Information Technology 1,870,446 2,150,510 2,150,510 2,139,921 (10,589) 99.5% 8400 Central Services 243,265 269,844 269,844 239,214 (30,630) 88.6% 8500 Health Insurance Reserves 7,217,213 8,027,508 8,027,508 8,111,669 84,161 101.0% 8600 Dental Insurance Reserves 364,364 382,627 382,627 383,801 1,174 100.3% Total Non-Budgetary Expenditures 17,179,823$ 18,833,397$ 18,833,397$ 18,527,681$ (305,890)$ 98.4% Total Revenues - All Funds 192,596,739$ 181,912,129$ 201,395,628$ 207,272,961$ 5,877,159$ 102.9% City of Iowa City Revenues by Fund Fiscal Year 2017 through June 30, 2017 4 2016 Actual 2017 Budget 2017 Revised 2017 Actual Variance Percent Budgetary Fund Revenues Property Taxes 52,020,805$ 55,330,224$ 55,330,224$ 55,357,358$ 27,134$ 100.0% Other City Taxes: TIF Revenues 1,027,218 2,276,953 2,276,953 2,226,302 (50,651) 97.8% Gas/Electric Excise Taxes 764,260 746,043 746,043 726,457 (19,586) 97.4% Mobile Home Taxes 65,497 68,265 68,265 65,153 (3,112) 95.4% Hotel/Motel Taxes 1,078,762 1,057,385 1,057,385 843,995 (213,390) 79.8% Utility Franchise Tax 874,235 901,690 901,690 939,387 37,697 104.2% Subtotal 3,809,972 5,050,336 5,050,336 4,801,293 (249,043) 95.1% Licenses, Permits, & Fees: General Use Permits 82,496 104,047 104,047 104,296 249 100.2% Food & Liquor Licenses 92,738 120,650 120,650 111,438 (9,212) 92.4% Professional License 18,700 18,660 18,660 12,015 (6,645) 64.4% Franchise Fees 733,644 720,000 720,000 539,482 (180,518) 74.9% Construction Permits & Insp Fees 2,102,624 1,463,225 1,463,225 2,578,024 1,114,799 176.2% Misc Lic & Permits 35,657 36,600 36,600 39,951 3,351 109.2% Subtotal 3,065,859 2,463,182 2,463,182 3,385,205 922,023 137.4% Intergovernmental: Fed Intergovernment Revenue 12,693,466 15,181,625 21,134,364 10,308,626 (10,825,738) 48.8% Property Tax Credits 2,088,758 1,671,368 1,668,076 1,590,863 (77,213) 95.4% Road Use Tax 8,320,117 7,837,116 8,320,117 8,672,279 352,162 104.2% State 28E Agreements 2,058,908 1,785,000 1,725,000 1,813,044 88,044 105.1% Operating Grants 104,197 89,743 129,743 138,474 8,731 106.7% Disaster Assistance 118,068 - 97,071 199,448 102,377 205.5% Other State Grants 6,711,203 4,978,045 6,884,525 12,486,602 5,602,077 181.4% Local 28E Agreements 1,378,455 1,038,149 1,038,149 1,476,869 438,720 142.3% Subtotal 33,473,172 32,581,046 40,997,045 36,686,206 (4,310,839) 89.5% Charges For Fees And Services: Building & Development 1,719,875 401,750 498,202 969,936 471,734 194.7% Police Services 112,112 44,121 44,121 143,562 99,441 325.4% Animal Care Services 10,400 10,000 10,000 11,545 1,545 115.4% Fire Services 9,244 9,000 9,000 10,370 1,370 115.2% Transit Fees 1,299,179 1,448,900 1,448,900 1,260,923 (187,977) 87.0% Culture & Recreation 761,363 812,093 812,093 780,147 (31,946) 96.1% Library Charges 22 - - 39 39 0.0% Misc Charges For Services 71,270 66,692 66,692 72,099 5,407 108.1% Water Charges 9,138,197 8,931,156 8,931,156 8,785,783 (145,373) 98.4% Wastewater Charges 12,264,380 12,201,600 12,201,600 11,526,745 (674,855) 94.5% Refuse Charges 3,491,480 3,608,800 3,608,800 3,382,169 (226,631) 93.7% Landfill Charges 5,686,853 5,341,722 5,341,722 6,168,978 827,256 115.5% Storm water Charges 1,167,517 1,477,710 1,477,710 1,435,201 (42,509) 97.1% Parking Charges 5,927,772 5,965,154 6,020,327 6,502,300 481,973 108.0% Subtotal 41,659,663 40,318,698 40,470,323 41,049,795 579,472 101.4% Miscellaneous: Code Enforcement 253,174 300,500 300,500 238,295 (62,205) 79.3% Parking Fines 549,575 620,000 620,000 578,713 (41,287) 93.3% Library Fines & Fees 155,519 160,000 160,000 154,425 (5,575) 96.5% Contributions & Donations 609,723 517,519 1,082,519 705,917 (376,602) 65.2% Printed Materials 49,456 44,326 44,326 43,411 (915) 97.9% Animal Adoption 14,190 13,000 13,000 12,015 (985) 92.4% Misc Merchandise 57,644 53,522 53,522 55,052 1,530 102.9% Intra-City Charges 3,112,634 4,003,742 4,003,742 3,795,296 (208,446) 94.8% Other Misc Revenue 739,617 708,915 1,720,423 1,643,705 (76,718) 95.5% Special Assessments 1,615 604 604 1,087 483 180.0% Subtotal 5,543,146$ 6,422,128$ 7,998,636$ 7,227,916$ (770,720)$ 90.4% City of Iowa City Revenues by Type Fiscal Year 2017 through June 30, 2017 5 2016 Actual 2017 Budget 2017 Revised 2017 Actual Variance Percent City of Iowa City Revenues by Type Fiscal Year 2017 through June 30, 2017 Use Of Money And Property: Interest Revenues 1,040,598$ 927,821$ 1,028,708$ 909,593$ (119,115)$ 88.4% Rents 1,265,519 1,256,057 1,256,057 1,391,523 135,466 110.8% Royalties & Commissions 149,751 113,814 113,814 140,491 26,677 123.4% Subtotal 2,455,867 2,297,692 2,398,579 2,441,607 43,028 101.8% Other Financial Sources: Debt Sales 23,897,097 16,187,000 23,335,480 33,795,498 10,460,018 144.8% Sale Of Assets 7,747,095 993,389 3,083,389 2,885,585 (197,804) 93.6% Loans 1,744,239 1,435,038 1,435,038 1,114,817 (320,221) 77.7% Subtotal 33,388,431 18,615,427 27,853,907 37,795,900 9,941,993 135.7% Total Budgetary Revenues 175,416,916$ 163,078,733$ 182,562,232$ 188,745,280$ 6,183,048 103.4% Non-Budgetary Fund Revenues Capital Project Funds 25,195$ -$ -$ 174$ 174$ 0.0% Internal Service Funds 17,154,628 18,833,397 18,833,397 18,527,507 (305,890) 98.4% Total Non-Budgetary Revenues 17,179,823$ 18,833,397$ 18,833,397$ 18,527,681$ (305,716)$ 98.4% Total Revenues - All Funds 192,596,739$ 181,912,130$ 201,395,629$ 207,272,961$ 5,877,332$ 102.9% 6 2016 Actual 2017 Budget 2017 Revised 2017 Actual Variance Percent Budgetary Fund Expenditures General Fund 10** General Fund 49,198,596$ 54,585,583$ 55,411,514$ 51,942,547$ 3,468,967$ 93.7% Special Revenue Funds 2100 Community Dev Block Grant 659,901 719,713 1,596,735 1,387,913 208,822 86.9% 2110 HOME 747,816 428,108 801,716 192,082 609,634 24.0% 2200 Road Use Tax Fund 5,436,882 5,969,763 5,989,213 5,261,317 727,896 87.8% 2300 Other Shared Revenue 446,465 - 1,022,683 650,196 372,487 63.6% 2350 Metro Planning Org of Johnson Co.558,489 616,729 616,729 605,768 10,961 98.2% 2400 Employee Benefits 1,054,857 1,212,865 1,212,865 947,891 264,974 78.2% 2500 Affordable Housing Fund - - 1,000,000 500,000 500,000 50.0% 2510 Peninsula Apartments 52,501 56,879 56,879 59,122 (2,243) 103.9% 26** Tax Increment Financing - 42,500 42,500 - 42,500 0.0% 2820 SSMID-Downtown District 295,284 321,151 317,859 317,925 (66) 100.0% Debt Service Fund 5*** Debt Service 15,016,250 15,146,227 15,390,400 15,218,289 172,111 98.9% Permanent Funds 6001 Perpetual Care - - - - - 0.0% Enterprise Funds 710* Parking 3,212,740 3,490,001 3,516,896 4,223,651 (706,755) 120.1% 715* Mass Transit 6,917,901 10,251,640 10,516,640 6,893,774 3,622,866 65.6% 720* Wastewater 10,674,085 10,593,521 21,258,521 21,256,420 2,101 100.0% 730* Water 7,686,557 8,558,936 12,732,640 12,324,333 408,307 96.8% 7400 Refuse Collection 2,935,579 3,142,730 3,159,730 3,052,968 106,762 96.6% 750* Landfill 4,550,095 4,505,413 4,929,566 4,931,921 (2,355) 100.0% 7600 Airport 408,276 372,709 632,709 668,880 (36,171) 105.7% 7700 Storm water 738,102 624,077 864,553 740,486 124,067 85.6% 79** Housing Authority 8,334,915 7,655,761 7,766,702 8,615,724 (849,022) 110.9% Capital Project Funds Governmental Projects 19,479,006 35,452,225 79,144,971 32,000,665 47,144,306 40.4% Enterprise Projects 3,893,109 4,517,923 14,319,041 3,635,206 10,683,835 25.4% Total Budgetary Expenditures 142,297,407$ 168,264,454$ 242,301,062$ 175,427,080$ 66,873,982$ 72.4% Non-Budgetary Funds Expenditures Capital Project Funds Internal Service Projects 424,014$ -$ 66,777$ 61,633$ 5,144 92.3% Internal Service Funds 810* Equipment 5,181,051 4,809,295 6,121,634 4,669,504 1,452,130 76.3% 8200 Risk Management 1,431,387 1,571,941 1,571,941 1,236,981 334,960 78.7% 830* Information Technology 1,834,060 2,108,294 2,108,294 1,619,223 489,071 76.8% 8400 Central Services 234,097 251,840 251,840 200,951 50,889 79.8% 8500 Health Insurance Reserves 7,934,757 8,002,151 8,002,151 7,325,378 676,773 91.5% 8600 Dental Insurance Reserves 370,061 375,896 375,896 374,002 1,894 99.5% Total Non-Budgetary Expenditures 17,409,427$ 17,119,417$ 18,498,533$ 15,487,672$ 3,010,861$ 83.7% Total Expenditures - All Funds 159,706,834$ 185,383,871$ 260,799,595$ 190,914,751$ 69,884,844$ 73.2% City of Iowa City Expenditures by Fund Fiscal Year 2017 through June 30, 2017 7 2016 Actual 2017 Budget 2017 Revised 2017 Actual Variance Percent Budgetary Funds Expenditures General Fund 10** General Fund City Council 107,734$ 109,426$ 109,426$ 108,314$ 1,112$ 99.0% City Clerk 524,931 536,351 536,351 499,432 36,919 93.1% City Attorney 681,567 738,002 742,002 731,107 10,895 98.5% City Manager 2,154,215 2,522,541 2,556,385 2,135,224 421,161 83.5% Finance 3,598,454 4,243,950 4,082,106 4,370,584 (288,478) 107.1% Police 12,443,824 13,313,329 13,456,740 13,065,704 391,036 97.1% Fire 7,486,024 7,876,882 7,973,264 7,700,985 272,279 96.6% Parks & Recreation 7,337,290 8,079,336 8,121,736 7,787,942 333,794 95.9% Library 6,083,035 6,347,022 6,347,022 6,277,367 69,655 98.9% Senior Center 823,993 954,090 1,010,358 886,505 123,853 87.7% Neighborhood & Development Services 6,614,830 6,892,339 7,503,809 6,003,220 1,500,589 80.0% Public Works 1,342,700 2,317,845 2,317,845 1,757,809 560,036 75.8%Transportation & Resource Management - 654,470 654,470 618,353 36,117 94.5% Total General Fund 49,198,596 54,585,583 55,411,514 51,942,547 3,468,967 93.7% Special Revenue Funds 2100 Community Dev Block Grant Neighborhood & Development Services 659,901 719,713 1,596,735 1,387,913 208,822 86.9% 2110 HOME Neighborhood & Development Services 747,816 428,108 801,716 192,082 609,634 24.0% 2200 Road Use Tax Fund Public Works 5,436,882 5,969,763 5,989,213 5,261,317 727,896 87.8% 2300 Other Shared Revenue Neighborhood & Development Services 446,465 - 1,022,683 650,196 372,487 63.6% 2350 Metro Planning Org of Johnson Co Neighborhood & Development Services 558,489 616,729 616,729 605,768 10,961 98.2% 2400 Employee Benefits Finance 1,054,857 1,212,865 1,212,865 947,891 264,974 78.2% 2500 Affordable Housing Fund Neighborhood & Development Services - - 1,000,000 500,000 500,000 50.0% 2510 Peninsula Apartments Neighborhood & Development Services 52,501 56,879 56,879 59,122 (2,243) 103.9% 26** Tax Increment Financing Finance - 42,500 42,500 - 42,500 0.0% 2820 SSMID-Downtown District Finance 295,284 321,151 317,859 317,925 (66) 100.0% Total Special Revenue Funds 9,252,195 9,367,708 12,657,179 9,922,215 2,734,964 78.4% Debt Service Fund 5*** Debt Service Finance 15,016,250 15,146,227 15,390,400 15,218,289 172,111 98.9% Total Debt Service Fund 15,016,250 15,146,227 15,390,400 15,218,289 172,111 98.9% Permanent Fund 6001 Perpetual Care Parks & Recreation - - - - - 0.0% Total Permanent Fund -$ -$ -$ -$ -$ 0.0% City of Iowa City Expenditures by Fund by Department Fiscal Year 2017 through June 30, 2017 8 2016 Actual 2017 Budget 2017 Revised 2017 Actual Variance Percent City of Iowa City Expenditures by Fund by Department Fiscal Year 2017 through June 30, 2017 Enterprise Funds 710* Parking Transportation & Resource Management 3,212,740$ 3,490,001$ 3,516,896$ 4,223,651$ (706,755)$ 120.1% 715* Mass Transit Transportation & Resource Management 6,917,901 10,251,640 10,516,640 6,893,774 3,622,866 65.6% 720* Wastewater Public Works 10,674,085 10,593,521 21,258,521 21,256,420 2,101 100.0% 730* Water Public Works 7,686,557 8,558,936 12,732,640 12,324,333 408,307 96.8% 7400 Refuse Collection Transportation & Resource Management 2,935,579 3,142,730 3,159,730 3,052,968 106,762 96.6% 750* Landfill Transportation & Resource Management 4,550,095 4,505,413 4,929,566 4,931,921 (2,355) 100.0% 7600 Airport Airport Operations 408,276 372,709 632,709 668,880 (36,171) 105.7% 7700 Storm water Public Works 738,102 624,077 864,553 740,486 124,067 85.6% 79** Housing Authority Neighborhood & Development Services 8,334,915 7,655,761 7,766,702 8,615,724 (849,022) 110.9% Total Enterprise Funds 45,458,251 49,194,788 65,377,957 62,708,157 2,669,800 95.9% Capital Project Funds Governmental Projects 19,479,006 35,452,225 79,144,971 32,000,665 47,144,306 40.4% Enterprise Projects 3,893,109 4,517,923 14,319,041 3,635,206 10,683,835 25.4% Total Capital Project Funds 23,372,115 39,970,148 93,464,012 35,635,872 57,828,140 38.1% Total Budgetary Expenditures 142,297,407$ 168,264,454$ 242,301,062$ 175,427,080$ 66,873,982$ 72.4% Non-Budgetary Funds Expenditures Capital Project Funds Internal Service Projects 424,014$ -$ 66,777$ 61,633$ 5,144$ 92.3% Total Capital Project Funds 424,014 - 66,777 61,633 5,144 92.3% Internal Service Funds 810* Equipment Public Works 5,181,051 4,809,295 6,121,634 4,669,504 1,452,130 76.3% 8200 Risk Management Finance 1,431,387 1,571,941 1,571,941 1,236,981 334,960 78.7% 830* Information Technology Finance 1,834,060 2,108,294 2,108,294 1,619,223 489,071 76.8% 8400 Central Services Finance 234,097 251,840 251,840 200,951 50,889 79.8% 8500 Health Insurance Reserves Finance 7,934,757 8,002,151 8,002,151 7,325,378 676,773 91.5% 8600 Dental Insurance Reserves Finance 370,061 375,896 375,896 374,002 1,894 99.5% Total Internal Service Funds 16,985,412 17,119,417 18,431,756 15,426,039 3,005,717 83.7% Total Non-Budgetary Expenditures 17,409,427$ 17,119,417$ 18,498,533$ 15,487,672$ 3,010,861$ 83.7% Total Expenditures - All Funds 159,706,834$ 185,383,871$ 260,799,595$ 190,914,751$ 69,884,844$ 73.2% 9