Loading...
FY2017 1st Qtr Financial Summary Date: October 25, 2016 To: City Manager, City Council From: Dennis Bockenstedt, Finance Director Re: Quarterly Financial Summary for Period Ending September 30, 2016 Introduction Attached to this memorandum are the City’s quarterly financial reports as of September 30, 2016. The quarterly financial report includes combined summaries of all fund balances, revenues, and expenditures for fiscal year 2017 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 11.2%, 7.9%, and 12.3%, 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, the Water fund is at 21.7%, the Wastewater fund is at 18.6%, and the Landfill is at 32.0%. These funds’ revenues may still be under the 25% benchmark due to the accrual of revenues back to last fiscal year or above the 25% due to seasonal variances. Other funds with budget anomalies worth noting: the Other Shared Revenue fund has actual revenues at -.2% due to the return of state grant monies; the Perpetual Care fund has revenues at -44.3% due to the timing of the accrual entry for interest revenue; and the Risk Management fund has actual revenues at 110.9% due to a double-entry for internal charges that will be corrected in October. In addition, Franchise Fee revenue is at -$136,489 or -19% (on page 5) due to the timing of an accounting entry which was corrected in October. The combined total actual revenues for all budgetary funds through September are $42,619,685 or 20.7% 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 2016 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%: • Other Shared Revenue fund is at 35.8% due to property acquisitions from grants. • Wastewater fund is at 75.9% due bond principal and interest payments paid in July. • Water fund is at 57.0% due to bond principal and interest payments paid in July. • Airport fund is at 91.9% due to the purchase of the FBO hangar building. • Risk Management fund is at 41.7% due to workers comp claims and internal charges. Overall, the combined total actual expenditures for all budgetary funds through September are $58,722,241 or 22.2% 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 balance, the Other Shared Revenue Fund at -$197,119 and the Employee Benefits fund at -187,697. These negative fund balances should reverse following the receipt of grant proceeds and the first installment of property tax revenues. 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 48,135,654$ 5,595,346$ 2,322,063$ 12,647,717$ 3,079,332$ 40,326,013$ 22,706,083$ 17,619,930$ Special Revenue Funds 2100 Community Dev Block Gran 448,892 42,497 - 287,130 81,051 123,209 - 123,209 2110 HOME - 47,680 - 17,808 - 29,872 - 29,872 2200 Road Use Tax Fund 5,767,142 1,893,540 82,650 1,282,689 605,083 5,855,560 - 5,855,560 2300 Other Shared Revenue 152,415 (2,000) - 347,534 - (197,119) - (197,119) 2350 Metro Planning Org of J.C.302,423 28,905 67,064 142,636 - 255,757 - 255,757 2400 Employee Benefits 1,670,848 883,864 - 385,901 2,356,508 (187,697) - (187,697) 2500 Affordable Housing Fund 1,000,000 567 - - 29,006 971,560 971,560 2510 Peninsula Apartments 124,888 18,369 - 9,974 - 133,283 - 133,283 26** Tax Increment Financing 239,487 190,129 - - - 429,616 236,684 192,932 2820 SSMID-Downtown District - 19,078 - - - 19,078 - 19,078 Debt Service Fund 5*** Debt Service 6,000,281 1,765,303 - 3,073,779 - 4,691,805 1,482,827 3,208,978 Permanent Funds 6001 Perpetual Care 116,266 (221) - - - 116,044 - 116,044 Enterprise Funds 710* Parking 10,742,693 1,549,670 - 778,136 57,091 11,457,136 5,885,583 5,571,553 715* Mass Transit 5,455,387 900,618 818,116 1,519,946 - 5,654,175 1,287,299 4,366,876 720* Wastewater 30,106,670 2,345,983 1,110,864 16,145,489 1,660,407 15,757,622 6,351,327 9,406,295 730* Water 16,240,827 1,972,731 486,240 7,248,702 483,516 10,967,580 2,845,931 8,121,649 7400 Refuse Collection 1,245,110 589,696 - 786,797 - 1,048,009 - 1,048,009 750* Landfill 24,926,190 1,910,111 57,091 1,160,185 - 25,733,207 23,399,662 2,333,545 7600 Airport 572,874 78,988 28,302 342,698 - 337,467 100,000 237,467 7700 Storm water 1,170,823 283,272 - 151,328 60,000 1,242,767 - 1,242,767 79** Housing Authority 6,350,911 2,373,689 - 2,577,555 11,522 6,135,523 3,054,872 3,080,651 Capital Project Funds Governmental Projects 21,966,585 12,373,905 3,344,308 6,293,108 - 31,391,689 - 31,391,689 Enterprise Projects 10,232,849 2,044,760 106,819 379,682 - 12,004,747 - 12,004,747 Total Budgetary Funds 192,969,216$ 36,906,481$ 8,423,517$ 55,578,794$ 8,423,517$ 174,296,903$ 67,350,268$ 106,946,634$ Non-Budgetary Funds Capital Project Funds Internal Service Projects 66,776$ 34$ -$ 6,560$ -$ 60,251$ -$ 60,251$ Internal Service Funds 810* Equipment 11,749,371 1,414,262 - 889,412 - 12,274,221 10,755,487 1,518,735 8200 Risk Management 3,414,156 1,800,419 - 655,211 - 4,559,363 - 4,559,363 830* Information Technology 2,516,722 332,988 - 315,097 - 2,534,613 567,408 1,967,205 8400 Central Services 667,695 67,459 - 48,372 - 686,781 - 686,781 8500 Health Insurance Reserves 9,902,794 2,005,750 - 1,140,536 - 10,768,008 4,282,539 6,485,469 8600 Dental Insurance Reserves 137,107 92,293 - 88,258 - 141,142 - 141,142 Total Non-Budgetary Funds 28,454,622$ 5,713,205$ -$ 3,143,447$ -$ 31,024,379$ 15,605,434$ 15,418,946$ Total All Funds 221,423,838$ 42,619,685$ 8,423,517$ 58,722,241$ 8,423,517$ 205,321,282$ 82,955,702$ 122,365,580$ City of Iowa City Fund Summary Fiscal Year 2017 through September 30, 2016 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,044,369$ 5,595,346$ (44,449,023)$ 11.2% Special Revenue Funds 2100 Community Dev Block Grant 989,380 706,000 1,678,012 42,497 (1,635,515) 2.5% 2110 HOME 614,958 421,000 813,343 47,680 (765,663) 5.9% 2200 Road Use Tax Fund 8,411,456 7,906,232 7,906,232 1,893,540 (6,012,692) 23.9% 2300 Other Shared Revenue 380,110 - 825,105 (2,000) (827,105) -0.2% 2350 Metro Planning Org of Johnson Co 298,671 319,369 319,369 28,905 (290,464) 9.1% 2400 Employee Benefits 10,516,769 11,144,971 11,144,971 883,864 (10,261,107) 7.9% 2500 Affordable Housing Fund 1,000,000 - - 567 567 0.0% 2510 Peninsula Apartments 72,243 74,000 74,000 18,369 (55,631) 24.8% 26** Tax Increment Financing 1,030,833 2,276,953 2,276,953 190,129 (2,086,824) 8.4% 2820 SSMID-Downtown District 295,284 321,151 317,859 19,078 (298,781) 6.0% Debt Service Fund 5*** Debt Service 13,301,893 13,645,137 14,302,460 1,765,303 (12,537,157) 12.3% Permanent Funds 6001 Perpetual Care 384 500 500 (221) (721) -44.3% Enterprise Funds 710* Parking 11,016,908 5,625,275 5,625,275 1,549,670 (4,075,605) 27.5% 715* Mass Transit 4,582,386 7,120,613 7,196,613 900,618 (6,295,995) 12.5% 720* Wastewater 22,742,715 12,588,588 12,588,588 2,345,983 (10,242,605) 18.6% 730* Water 13,346,893 9,111,655 9,111,655 1,972,731 (7,138,924) 21.7% 7400 Refuse Collection 3,130,252 3,173,900 3,173,900 589,696 (2,584,205) 18.6% 750* Landfill 6,268,826 5,977,982 5,977,982 1,910,111 (4,067,871) 32.0% 7600 Airport 341,499 359,500 359,500 78,988 (280,512) 22.0% 7700 Storm water 1,173,615 1,516,221 1,516,221 283,272 (1,232,949) 18.7% 79** Housing Authority 8,819,308 8,501,334 8,501,334 2,373,689 (6,127,645) 27.9% Capital Project Funds Governmental Projects 16,503,591 19,553,084 40,029,738 12,373,905 (27,655,833) 30.9% Enterprise Projects 1,911,092 2,690,898 3,450,366 2,044,760 (1,405,606) 59.3% Total Budgetary Revenues 175,416,916$ 163,078,732$ 187,234,345$ 36,906,481$ (150,327,864)$ 19.7% Non-Budgetary Fund Revenues - Capital Project Funds Internal Service Projects 25,195$ -$ -$ 34$ 34$ 0.0% Internal Service Funds 810* Equipment 5,912,284 6,379,763 6,379,763 1,414,262 (4,965,501) 22.2% 8200 Risk Management 1,547,056 1,623,145 1,623,145 1,800,419 177,274 110.9% 830* Information Technology 1,870,446 2,150,510 2,150,510 332,988 (1,817,522) 15.5% 8400 Central Services 243,265 269,844 269,844 67,459 (202,385) 25.0% 8500 Health Insurance Reserves 7,217,213 8,027,508 8,027,508 2,005,750 (6,021,758) 25.0% 8600 Dental Insurance Reserves 364,364 382,627 382,627 92,293 (290,334) 24.1% Total Non-Budgetary Expenditures 17,179,823$ 18,833,397$ 18,833,397$ 5,713,205$ (13,120,227)$ 30.3% Total Revenues - All Funds 192,596,739$ 181,912,129$ 206,067,742$ 42,619,685$ (163,448,091)$ 20.7% City of Iowa City Revenues by Fund Fiscal Year 2017 through September 30, 2016 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$ 4,682,597$ (50,647,627)$ 8.5% Other City Taxes: TIF Revenues 1,027,218 2,276,953 2,276,953 190,842 (2,086,111) 8.4% Gas/Electric Excise Taxes 764,260 746,043 746,043 - (746,043) 0.0% Mobile Home Taxes 65,497 68,265 68,265 16,783 (51,482) 24.6% Hotel/Motel Taxes 1,078,762 1,057,385 1,057,385 - (1,057,385) 0.0% Utility Franchise Tax 874,235 901,690 901,690 - (901,690) 0.0% Subtotal 3,809,972 5,050,336 5,050,336 207,625 (4,842,711) 4.1% Licenses, Permits, & Fees: General Use Permits 82,496 104,047 104,047 4,082 (99,966) 3.9% Food & Liquor Licenses 92,738 120,650 120,650 33,791 (86,859) 28.0% Professional License 18,700 18,660 18,660 4,085 (14,575) 21.9% Franchise Fees 733,644 720,000 720,000 (136,489) (856,489) -19.0% Construction Permits & Insp Fees 2,102,624 1,463,225 1,463,225 543,968 (919,257) 37.2% Misc Lic & Permits 35,657 36,600 36,600 15,680 (20,921) 42.8% Subtotal 3,065,859 2,463,182 2,463,182 465,117 (1,998,065) 18.9% Intergovernmental: Fed Intergovernment Revenue 12,693,466 15,181,625 22,356,506 2,149,040 (20,207,466) 9.6% Property Tax Credits 2,088,758 1,671,368 1,668,076 217 (1,667,859) 0.0% Road Use Tax 8,320,117 7,837,116 7,837,116 1,803,240 (6,033,876) 23.0% State 28E Agreements 2,058,908 1,785,000 1,785,000 - (1,785,000) 0.0% Operating Grants 104,197 89,743 89,743 41,500 (48,243) 46.2% Disaster Assistance 118,068 - 97,071 - (97,071) 0.0% Other State Grants 6,711,203 4,978,045 5,514,452 2,266,895 (3,247,557) 41.1% Local 28E Agreements 1,378,455 1,038,149 1,038,149 321,939 (716,210) 31.0% Subtotal 33,473,172 32,581,046 40,386,113 6,582,831 (33,803,282) 16.3% Charges For Fees And Services: Building & Development 1,719,875 401,750 437,612 195,102 (242,510) 44.6% Police Services 112,112 44,121 44,121 24,549 (19,572) 55.6% Animal Care Services 10,400 10,000 10,000 3,181 (6,820) 31.8% Fire Services 9,244 9,000 9,000 2,040 (6,960) 22.7% Transit Fees 1,299,179 1,448,900 1,448,900 247,045 (1,201,855) 17.1% Culture & Recreation 761,363 812,093 812,093 179,455 (632,638) 22.1% Library Charges 22 - - 8 8 0.0% Misc Charges For Services 71,270 66,692 66,692 20,182 (46,510) 30.3% Water Charges 9,138,197 8,931,156 8,931,156 1,966,328 (6,964,828) 22.0% Wastewater Charges 12,264,380 12,201,600 12,201,600 2,334,589 (9,867,011) 19.1% Refuse Charges 3,491,480 3,608,800 3,608,800 686,752 (2,922,048) 19.0% Landfill Charges 5,686,853 5,341,722 5,341,722 1,776,553 (3,565,169) 33.3% Storm water Charges 1,167,517 1,477,710 1,477,710 286,792 (1,190,918) 19.4% Parking Charges 5,927,772 5,965,154 5,965,154 1,901,599 (4,063,555) 31.9% Subtotal 41,659,663 40,318,698 40,354,560 9,624,175 (30,730,385) 23.8% Miscellaneous: Code Enforcement 253,174 300,500 300,500 33,104 (267,396) 11.0% Parking Fines 549,575 620,000 620,000 98,390 (521,610) 15.9% Library Fines & Fees 155,519 160,000 160,000 37,925 (122,075) 23.7% Contributions & Donations 609,723 517,519 1,082,519 255,162 (827,357) 23.6% Printed Materials 49,456 44,326 44,326 11,329 (32,997) 25.6% Animal Adoption 14,190 13,000 13,000 2,605 (10,395) 20.0% Misc Merchandise 57,644 53,522 53,522 30,729 (22,793) 57.4% Intra-City Charges 3,112,634 4,003,742 4,003,742 985,140 (3,018,602) 24.6% Other Misc Revenue 739,617 708,915 1,563,599 234,076 (1,329,523) 15.0% Special Assessments 1,615 604 604 8 (596) 1.3% Subtotal 5,543,146$ 6,422,128$ 7,841,812$ 1,688,468$ (6,153,344)$ 21.5% City of Iowa City Revenues by Type Fiscal Year 2017 through September 30, 2016 5 2016 Actual 2017 Budget 2017 Revised 2017 Actual Variance Percent City of Iowa City Revenues by Type Fiscal Year 2017 through September 30, 2016 Use Of Money And Property: Interest Revenues 1,040,598$ 927,821$ 927,821$ (208,782)$ (1,136,603)$ -22.5% Rents 1,265,519 1,256,057 1,256,057 366,524 (889,533) 29.2% Royalties & Commissions 149,751 113,814 113,814 25,259 (88,555) 22.2% Subtotal 2,455,867 2,297,692 2,297,692 183,001 (2,114,691) 8.0% Other Financial Sources: Debt Sales 23,897,097 16,187,000 28,992,000 12,805,000 (16,187,000) 44.2% Sale Of Assets 7,747,095 993,389 3,083,389 340,250 (2,743,139) 11.0% Loans 1,744,239 1,435,038 1,435,038 327,417 (1,107,621) 22.8% Subtotal 33,388,431 18,615,427 33,510,427 13,472,667 (20,037,760) 40.2% Total Budgetary Revenues 175,416,916$ 163,078,733$ 187,234,346$ 36,906,481$ (150,327,865) 19.7% Non-Budgetary Fund Revenues Capital Project Funds 25,195$ -$ -$ 34$ 34$ 0.0% Internal Service Funds 17,154,628 18,833,397 18,833,397 5,713,170 (13,120,227) 30.3% Total Non-Budgetary Revenues 17,179,823$ 18,833,397$ 18,833,397$ 5,713,205$ (13,120,192)$ 30.3% Total Revenues - All Funds 192,596,739$ 181,912,130$ 206,067,743$ 42,619,685$ (163,448,058)$ 20.7% 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$ 54,960,394$ 12,647,717$ 42,312,677$ 23.0% Special Revenue Funds 2100 Community Dev Block Grant 659,901 719,713 1,696,735 287,130 1,409,605 16.9% 2110 HOME 747,816 428,108 801,716 17,808 783,908 2.2% 2200 Road Use Tax Fund 5,436,882 5,969,763 5,985,013 1,282,689 4,702,324 21.4% 2300 Other Shared Revenue 446,465 - 970,712 347,534 623,178 35.8% 2350 Metro Planning Org of Johnson Co.558,489 616,729 616,729 142,636 474,093 23.1% 2400 Employee Benefits 1,054,857 1,212,865 1,212,865 385,901 826,964 31.8% 2510 Peninsula Apartments 52,501 56,879 56,879 9,974 46,905 17.5% 26** Tax Increment Financing - 42,500 42,500 - 42,500 0.0% 2820 SSMID-Downtown District 295,284 321,151 321,151 - 321,151 0.0% Debt Service Fund 5*** Debt Service 15,016,250 15,146,227 15,419,400 3,073,779 12,345,621 19.9% Permanent Funds 6001 Perpetual Care - - - - - 0.0% Enterprise Funds 710* Parking 3,212,740 3,490,001 3,490,001 778,136 2,711,865 22.3% 715* Mass Transit 6,917,901 10,251,640 10,346,640 1,519,946 8,826,694 14.7% 720* Wastewater 10,674,085 10,593,521 21,258,521 16,145,489 5,113,032 75.9% 730* Water 7,686,557 8,558,936 12,724,240 7,248,702 5,475,538 57.0% 7400 Refuse Collection 2,935,579 3,142,730 3,142,730 786,797 2,355,933 25.0% 750* Landfill 4,550,095 4,505,413 4,625,413 1,160,185 3,465,228 25.1% 7600 Airport 408,276 372,709 372,709 342,698 30,011 91.9% 7700 Storm water 738,102 624,077 662,627 151,328 511,299 22.8% 79** Housing Authority 8,334,915 7,655,761 7,655,761 2,577,555 5,078,206 33.7% Capital Project Funds Governmental Projects 19,479,006 35,452,225 85,483,245 6,293,108 79,190,137 7.4% Enterprise Projects 3,893,109 4,517,923 14,169,410 379,682 13,789,728 2.7% Total Budgetary Expenditures 142,297,407$ 168,264,454$ 246,015,391$ 55,578,794$ 190,436,597$ 22.6% Non-Budgetary Funds Expenditures Capital Project Funds Internal Service Projects 424,014$ -$ -$ 6,560$ (6,560) 0.0% Internal Service Funds 810* Equipment 5,181,051 4,809,295 5,953,508 889,412 5,064,096 14.9% 8200 Risk Management 1,431,387 1,571,941 1,571,941 655,211 916,730 41.7% 830* Information Technology 1,834,060 2,108,294 2,108,294 315,097 1,793,197 14.9% 8400 Central Services 234,097 251,840 251,840 48,372 203,468 19.2% 8500 Health Insurance Reserves 7,934,757 8,002,151 8,002,151 1,140,536 6,861,615 14.3% 8600 Dental Insurance Reserves 370,061 375,896 375,896 88,258 287,638 23.5% Total Non-Budgetary Expenditures 17,409,427$ 17,119,417$ 18,263,630$ 3,143,447$ 15,120,183$ 17.2% Total Expenditures - All Funds 159,706,834$ 185,383,871$ 264,279,021$ 58,722,241$ 205,556,780$ 22.2% City of Iowa City Expenditures by Fund Fiscal Year 2017 through September 30, 2016 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$ 29,879$ 79,547$ 27.3% City Clerk 524,931 536,351 536,351 116,818 419,533 21.8% City Attorney 681,567 738,002 738,002 170,400 567,602 23.1% City Manager 2,154,215 2,522,541 2,522,541 487,364 2,035,177 19.3% Finance 3,598,454 4,243,950 4,243,950 1,542,586 2,701,364 36.3% Police 12,443,824 13,313,329 13,395,570 2,947,245 10,448,325 22.0% Fire 7,486,024 7,876,882 7,969,064 1,887,971 6,081,093 23.7% Parks & Recreation 7,337,290 8,079,336 8,104,336 1,809,680 6,294,656 22.3% Library 6,083,035 6,347,022 6,347,022 1,520,222 4,826,801 24.0% Senior Center 823,993 954,090 994,808 197,060 797,748 19.8% Neighborhood & Development Services 6,614,830 6,892,339 7,027,009 1,416,217 5,610,792 20.2% Public Works 1,342,700 2,317,845 2,317,845 387,409 1,930,436 16.7%Transportation & Resource Management - 654,470 654,470 134,866 519,604 0.0% Total General Fund 49,198,596 54,585,583 54,960,394 12,647,717 42,312,677 23.0% Special Revenue Funds 2100 Community Dev Block Grant Neighborhood & Development Services 659,901 719,713 1,696,735 287,130 1,409,605 16.9% 2110 HOME Neighborhood & Development Services 747,816 428,108 801,716 17,808 783,908 2.2% 2200 Road Use Tax Fund Public Works 5,436,882 5,969,763 5,985,013 1,282,689 4,702,324 21.4% 2300 Other Shared Revenue Neighborhood & Development Services 446,465 - 970,712 347,534 623,178 35.8% 2350 Metro Planning Org of Johnson Co Neighborhood & Development Services 558,489 616,729 616,729 142,636 474,093 23.1% 2400 Employee Benefits Finance 1,054,857 1,212,865 1,212,865 385,901 826,964 31.8% 2510 Peninsula Apartments Neighborhood & Development Services 52,501 56,879 56,879 9,974 46,905 17.5% 26** Tax Increment FinancingNeighborhood & Development Services - 42,500 42,500 - 42,500 0.0% 2820 SSMID-Downtown District Neighborhood & Development Services 295,284 321,151 321,151 - 321,151 0.0% Total Special Revenue Funds 9,252,195 9,367,708 11,704,300 2,473,671 9,230,629 21.1% Debt Service Fund 5*** Debt Service Finance 15,016,250 15,146,227 15,419,400 3,073,779 12,345,621 19.9% Total Debt Service Fund 15,016,250 15,146,227 15,419,400 3,073,779 12,345,621 19.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 September 30, 2016 8 2016 Actual 2017 Budget 2017 Revised 2017 Actual Variance Percent City of Iowa City Expenditures by Fund by Department Fiscal Year 2017 through September 30, 2016 Enterprise Funds 710* Parking Transportation & Resource Management 3,212,740$ 3,490,001$ 3,490,001$ 778,136$ 2,711,865$ 22.3% 715* Mass Transit Transportation & Resource Management 6,917,901 10,251,640 10,346,640 1,519,946 8,826,694 14.7% 720* Wastewater Public Works 10,674,085 10,593,521 21,258,521 16,145,489 5,113,032 75.9% 730* Water Public Works 7,686,557 8,558,936 12,724,240 7,248,702 5,475,538 57.0% 7400 Refuse Collection Transportation & Resource Management 2,935,579 3,142,730 3,142,730 786,797 2,355,933 25.0% 750* Landfill Transportation & Resource Management 4,550,095 4,505,413 4,625,413 1,160,185 3,465,228 25.1% 7600 Airport Airport Operations 408,276 372,709 372,709 342,698 30,011 91.9% 7700 Storm water Public Works 738,102 624,077 662,627 151,328 511,299 22.8% 79** Housing Authority Neighborhood & Development Services 8,334,915 7,655,761 7,655,761 2,577,555 5,078,206 33.7% Total Enterprise Funds 45,458,251 49,194,788 64,278,642 30,710,837 33,567,805 47.8% Capital Project Funds Governmental Projects 19,479,006 35,452,225 85,483,245 6,293,108 79,190,137 7.4% Enterprise Projects 3,893,109 4,517,923 14,169,410 379,682 13,789,728 2.7% Total Capital Project Funds 23,372,115 39,970,148 99,652,655 6,672,790 92,979,865 6.7% Total Budgetary Expenditures 142,297,407$ 168,264,454$ 246,015,391$ 55,578,794$ 190,436,597$ 22.6% Non-Budgetary Funds Expenditures Capital Project Funds Internal Service Projects 424,014$ -$ -$ 6,560$ (6,560)$ 0.0% Total Capital Project Funds 424,014 - - 6,560 (6,560) 0.0% Internal Service Funds 810* Equipment Public Works 5,181,051 4,809,295 5,953,508 889,412 5,064,096 14.9% 8200 Risk Management Finance 1,431,387 1,571,941 1,571,941 655,211 916,730 41.7% 830* Information Technology Finance 1,834,060 2,108,294 2,108,294 315,097 1,793,197 14.9% 8400 Central Services Finance 234,097 251,840 251,840 48,372 203,468 19.2% 8500 Health Insurance Reserves Finance 7,934,757 8,002,151 8,002,151 1,140,536 6,861,615 14.3% 8600 Dental Insurance Reserves Finance 370,061 375,896 375,896 88,258 287,638 23.5% Total Internal Service Funds 16,985,412 17,119,417 18,263,630 3,136,887 15,126,743 17.2% Total Non-Budgetary Expenditures 17,409,427$ 17,119,417$ 18,263,630$ 3,143,447$ 15,120,183$ 17.2% Total Expenditures - All Funds 159,706,834$ 185,383,871$ 264,279,021$ 58,722,241$ 205,556,780$ 22.2% 9