Loading...
FY2016 1st Qtr Financial Summary  Licenses, Permits & Fees: FY2016 revenues are at 24.9% of the revised budget. This revenue is primarily from construction permit and inspection fees and cable franchise fees in the General Fund (page 12). First quarter revenues for construction permit and inspection fees are 38.9% of the revised budget and 20% higher than this time last year due to several larger projects. Other revenues are consistent with the first quarter of FY2015.  Use of Money and Property: FY2016 revenues are at 16.3% of the revised budget. Interest income is lower in the first quarter due to accruals back to the prior year. All of the major funds include this revenue source. Rents and Royalties and Commissions are on target at 27.2% and 40.2% of the revised budget, respectively.  Intergovernmental Revenue: FY2016 revenues are at 20.1% of the revised budget. The budget for intergovernmental revenue includes a variety of federal, state and other local government revenues that are either for operating or capital assistance. It also includes state backfill for commercial and industrial property valuation rollback changes. Major funds that receive property tax backfill include: General Fund (page 12), Employee Benefits Fund (page 15) and the Debt Service Fund (page 16). Intergovernmental revenue is a primary revenue source for the CDBG Fund (page 13), Road Use Tax Fund (page 14), Transit Fund (page 18), and also the Housing Authority Fund (page 24). Other funds receive intergovernmental revenue on an inconsistent basis. o Federal receipts are at 13.4% of the revised budget. Receipts in the first quarter are primarily for the Housing Authority, CDBG, HOME and Capital Projects funds. Federal transit assistance is usually received in the 4th quarter. Grant funding for capital projects is not received on a consistent basis. There are no issues at this time. o Property Tax Credits are at 0%. This includes the property tax backfill for commercial and industrial property which is received in the second and fourth quarters of the fiscal year. o Disaster Assistance is also 0% of the revised budget. This is the State match for FEMA funded projects. Timing is based on project completion dates. o State 28E Agreements are 107.2% of the revised budget. This revenue is for fire protection services provided to the University of Iowa. It is received once a year for the prior year services and receipted into the General Fund, Employee Benefits Fund and the Capital Projects Fund for fire equipment. FY2016 revenue is 3% above FY2015 revenue.  Charges for Fees and Services: FY2016 revenues are at 21.2% of the revised budget. All of the major funds include charges for fees and services except for the CDBG Fund, Employee Benefits Fund, Debt Service Fund and the Housing Authority Fund. o Culture & Recreation fees are on track at 23.3% of the revised budget in the General Fund (page 12). o Police Services revenue is 49.8% of the revised budget. These revenues are received inconsistently from forfeitures and requests for special police services. o Miscellaneous Charges for Services is 43.9% of the revised budget. Revenues are primarily from cemetery interment fees. Revenues are approximately the same as this time in FY2015. o The utility funds Wastewater (page 19), Water (page 20), and Refuse (page 21) are between 17% and 19% of the revised budget at this time. This represents two months of activity rather than three months due to accrual of July receipts back to the prior fiscal year. Actual revenue is based on when services are delivered and revenues are earned. o Parking Charges are 33.4% of the revised budget and consistent with prior year revenues. 2  Miscellaneous: FY2016 revenues are at 21.6% of the revised budget. The miscellaneous revenue category includes fines, contributions and donations, intra-city charges, and other miscellaneous revenues such as reimbursement of expenses. All of the major funds include at least one of the above as a revenue source. Miscellaneous revenue is not received on a consistent basis. o Parking fines are 23.6% of the revised budget and are receipted in the General Fund (page 12) and the Parking Fund (page 17), depending on the type of violation. Revenue from Code Enforcement, Parking Fines and Library Fines are slightly lower than the first quarter of FY2015. o Contributions & Donations are 15% of the revised budget. This revenue is typically received in the Library, Senior Center and Capital Improvement Projects. o Other Miscellaneous Revenue is 16.6% of the revised budget. It includes reimbursement of expenses, and intra-department energy efficiency revolving loan program revenues which do not occur on a regular basis.  Other Financial Sources: FY2016 revenues are 6.7% of the revised budget. Sources include debt sales, sale of assets and loans (from external sources). Major funds with Other Financial Sources include the General Fund (page 12), CDBG Fund (page 13) and the Debt Service Fund (page 16). o Sale of assets is 32.7% of the revised budget primarily due to sale of 5 properties in the UniverCity program within the General Fund (page 12). o Loans are 18.2% of the revised budget also related to external loan financing of the UniverCity program, which is repaid as the houses are sold. o Debt sales are 0% of the revised budget. The General Obligation bond sale for capital improvement projects typically occurs in the fourth quarter of the fiscal year. Expenditures by Fund by Department (page 8-9): FY2016 expenditures for all budgetary funds are 16.3% of the revised budget. Fund and department expenditure highlights are as follows:  General Fund / Finance Department: Overall the fund expenses are 21.1% of the revised budget (page 12). However, Finance Department expenditures are 31.2% of the revised budget due to property and liability insurance annual payments from the Tort Division which have already occurred for the year.  Home Fund / Neighborhood & Development Services Department: Expenditures are 79.6% of the revised budget with a number of program loans disbursed early in the fiscal year.  Wastewater and Water Funds / Public Works Department: Expenses are above 25% of the revised budget (page 19-20). Expenses are higher due to debt service payments that occur at the beginning of the fiscal year.  Housing Authority Fund / Neighborhood & Development Services Department: Housing Authority expenses are 32.9% of the revised budget (page 24). Voucher Rental assistance payments have increased due to twenty additional vouchers authorized for the veterans’ supportive housing (VASH) program. Also, a new payment standards schedule became effective in May 2015, which increased the maximum amount per unit that the Housing Authority pays in rental assistance.  Capital Project Funds: Expenses in these funds are only 0.8% of the revised budget. CIP expenditures do not occur evenly throughout the year and vary according to what phase of design or construction the projects are in. Also, contract retainage expense is reflected when the work is performed rather than when it is paid. Enterprise Capital 3 Projects show a negative expense at this time due to the accrual process for contract retainage between FY2015 and FY2016. Expenditures by State Program by Department (page 11): Expenditures have a fund and department classification as mentioned above. They also have a program classification for state reporting purposes. By Iowa code, the City cannot exceed its budget authority adopted by City Council in any of the nine budgeted program areas. Internal Service funds are not within the budgeted program areas and do not fall under this restriction. The Budgetary Expenditures by Program chart (page 11) presents the actual expenditures for each program area versus its appropriated level. FY2016 expenditures for all budgetary funds are 16.3% of the revised budget, including capital improvement projects. Health and Social Services and General Government are the only two program areas that have expenditures in excess of 25% of the revised budget at this time.  Health and Social Services: Expenditures are 28.4% of the revised budget. Expenditures in this program area are from the Human Services activity in the General Fund (page 12). Expenditures are above 25% due to full payment at the beginning of the year for a few agencies. Most are disbursed on a quarterly basis.  General Government: Expenditures are 28.3% of the revised budget. The Finance department is 37.5% of the revised budget, due to payment of the workers compensation insurance payment from the Employee Benefits Fund, and to annual property and liability insurance payment from the Tort Liability Division. All other department expenditures are less than 25% of the revised budget at this time. Conclusion Overall, the City’s revenues and expenditures for the fiscal year are within budget and generally have no fund balance issues to report. The HOME fund and Other Shared Revenue fund both have negative balances which will be funded by grants. Capital improvement projects, grants and economic development capital acquisitions such as the UniverCity program tend to fluctuate more than operating budgets and will not compare evenly throughout the year to budget estimates. The modified accrual basis for budget to actual comparison tends to make first quarter reporting less intuitive since several revenue categories appear below budget due to accruals to the prior fiscal year; however there are no major trends to be concerned about at the macro level. The Finance Department believes in an open and transparent system. Any of the information presented in this report is available in greater detail if requested. 4 Estimated Unassigned Fund Fund Restricted,Fund Balance Transfers Transfers Balance Committed,Balance 7/1/2015 Revenues In Expenditures Out 9/30/2015 Assigned 9/30/2015 Budgetary Funds General Fund 10** General Fund 49,045,399$ 6,530,416$ 3,868,605$ 11,277,973$ 2,063,106$ 46,103,341$ 29,443,488$ 16,659,852$ Special Revenue Funds 2100 Community Dev Block Grant 144,414 40,108 - 98,655 - 85,867 - 85,867 2110 HOME 132,858 154,668 - 439,265 - (151,739) - (151,740) 2200 Road Use Tax Fund 5,564,215 1,777,340 99,093 1,029,902 293,398 6,117,348 - 6,117,348 2300 Other Shared Revenue (109) - - 550 - (659) - (659) 2310 Energy Eff & Cons Block Grant - - - - - - - - 2315 UniverCity Neighborhood Pship - - - - - - - - 2350 Metro Planning Org of Johnson Co 292,006 36,457 67,559 128,020 - 268,002 - 268,002 2400 Employee Benefits 1,592,570 949,312 - 143,671 2,347,317 50,894 - 50,894 2510 Peninsula Apartments 105,146 19,009 - 13,405 - 110,750 - 110,751 26** Tax Increment Financing 835 89,111 - - - 89,946 - 89,946 2820 SSMID-Downtown District - 7,765 - - - 7,765 - 7,765 Debt Service Fund 5*** Debt Service 6,444,718 843,929 - 3,094,328 - 4,194,319 669,265 3,525,054 Permanent Funds 6001 Perpetual Care 115,882 (83) - - - 115,799 - 115,799 Enterprise Funds 710* Parking 3,713,076 1,571,074 - 723,184 55,361 4,505,605 385,583 4,120,022 715* Mass Transit 4,762,385 768,164 777,637 1,216,813 7,413 5,083,960 1,268,156 3,815,804 720* Wastewater 19,788,658 2,249,308 1,183,019 5,232,095 1,308,019 16,680,871 6,901,767 9,779,104 730* Water 12,332,979 1,848,826 502,679 2,825,793 503,205 11,355,486 2,982,900 8,372,586 7400 Refuse Collection 1,050,437 561,042 - 674,781 - 936,698 - 936,698 750* Landfill 24,052,855 1,292,829 62,774 775,233 - 24,633,225 21,619,664 3,013,561 7600 Airport 611,028 77,966 30,482 64,241 - 655,235 100,000 555,235 7700 Stormwater 1,571,993 208,137 - 95,495 - 1,684,635 - 1,684,635 780* Cable Television 1,571,324 - - - 1,571,324 - - - 79** Housing Authority 5,911,702 2,012,928 - 2,483,658 11,295 5,429,677 2,996,600 2,433,077 Capital Project Funds Governmental Projects 12,886,726 1,324,923 1,664,393 1,664,527 221,328 13,990,187 - 13,990,186 Enterprise Projects 8,108,609 261,680 125,526 (1,135,866) - 9,631,681 - 9,631,681 Total Budgetary Funds 159,799,706$ 22,624,909$ 8,381,767$ 30,845,723$ 8,381,766$ 151,578,893$ 66,367,423$ 85,211,468$ Non-Budgetary Funds Capital Project Funds Internal Service Projects 465,596$ 807$ -$ 238,323$ -$ 228,080$ -$ 228,080$ Internal Service Funds 810* Equipment 11,018,138 1,411,988 - 759,536 - 11,670,590 8,193,984 3,476,606 8200 Risk Management 3,298,488 2,345 - 188,509 - 3,112,324 - 3,112,324 830* Information Technology 2,530,336 237,923 - 388,017 - 2,380,242 - 2,380,242 8400 Central Services 658,527 49,097 - 44,390 - 663,234 - 663,235 8500 Health Insurance Reserves 10,620,338 1,791,901 - 2,012,017 - 10,400,222 3,614,448 6,785,774 8600 Dental Insurance Reserves 142,803 90,797 - 85,189 - 148,411 - 148,412 Total Non-Budgetary Funds 28,734,226$ 3,584,858$ -$ 3,715,981$ -$ 28,603,103$ 11,808,432$ 16,794,673$ Total All Funds 188,533,932$ 26,209,767$ 8,381,767$ 34,561,704$ 8,381,766$ 180,181,996$ 78,175,855$ 102,006,141$ FY2016 Through The Quarter Ended September 30, 2015 All Fund Summary City of Iowa City 5 2015 Actual 2016 Budget 2016 Revised 2016 Year-to-Date 2016 Variance Pct of Revised Budgetary Fund Revenues Property Taxes 51,492,986$ 52,033,986$ 52,033,986$ 3,339,789$ (48,694,197)$ 6.4% Delinquent Property Taxes 3,366 - - - - TIF Revenues 640,244 1,020,126 1,020,126 89,111 (931,015) 8.7% Other City Taxes 2,877,888 2,786,289 2,786,289 10,369 (2,775,920) 0.4% General Use Permits 103,958 87,011 87,011 5,912 (81,099) 6.8% Food & Liq Licenses 120,434 99,912 99,912 20,995 (78,917) 21.0% Professional License 18,704 16,610 16,610 5,080 (11,530) 30.6% Franchise Fees 750,167 727,698 727,698 15,631 (712,067) 2.1% Const Per & Ins Fees 1,537,002 1,280,144 1,280,144 498,605 (781,539) 38.9% Misc Lic & Permits 38,115 37,960 37,960 14,151 (23,809) 37.3% Licenses, Permits, & Fees 2,568,380 2,249,335 2,249,335 560,374 (1,688,961) 24.9% Interest Revenues 1,139,734 742,838 742,838 (27,642) (770,480) -3.7% Rents 1,291,672 1,192,640 1,192,640 324,310 (868,330) 27.2% Royalties & Commissions 105,454 80,634 80,634 32,453 (48,181) 40.2% Use Of Money And Property 2,536,860 2,016,112 2,016,112 329,121 (1,686,991) 16.3% Fed Intergovnt Revenue 13,160,509 16,406,042 22,498,825 3,010,133 (19,488,692) 13.4% Property Tax Credits 1,135,396 2,152,703 2,152,703 202 (2,152,501) 0.0% Road Use Tax 7,230,663 6,744,663 6,744,663 1,773,736 (4,970,927) 26.3% State 28E Agreements 1,753,673 1,684,894 1,684,894 1,806,870 121,976 107.2% Operating Grants 84,126 90,067 90,067 17,936 (72,131) 19.9% Disaster Assistance 61,259 - 86,927 - (86,927) 0.0% Other State Grants 10,543,117 2,237,352 3,029,538 581,106 (2,448,432) 19.2% Local 28E Agreements 989,787 980,701 980,701 319,496 (661,205) 32.6% Intergovernmental 34,958,530 30,296,422 37,268,318 7,509,479 (29,758,839) 20.1% Building & Devlpmt 694,796 358,082 358,082 78,881 (279,201) 22.0% Police Services 226,621 31,335 31,335 15,607 (15,728) 49.8% Animal Care Services 9,945 10,000 10,000 2,942 (7,058) 29.4% Fire Services 11,404 7,500 7,500 2,130 (5,370) 28.4% Transit Fees 1,448,151 1,385,691 1,385,691 217,666 (1,168,025) 15.7% Culture & Recreation 741,912 805,961 805,961 187,559 (618,402) 23.3% Library Charges 39 - - 14 14 Misc Charges For Services 67,073 52,236 52,236 22,930 (29,306) 43.9% Water Charges 8,531,499 9,271,112 9,271,112 1,833,557 (7,437,555) 19.8% Wastewater Charges 12,180,738 12,555,993 12,555,993 2,209,926 (10,346,067) 17.6% Refuse Charges 3,925,946 3,446,256 3,446,256 664,858 (2,781,398) 19.3% Landfill Charges 5,043,246 5,269,970 5,269,970 1,150,686 (4,119,284) 21.8% Stormwater Charges 1,147,390 1,140,000 1,140,000 209,030 (930,970) 18.3% Parking Charges 5,972,285 5,751,956 5,751,956 1,918,379 (3,833,577) 33.4% Charges For Fees And Services 40,001,045 40,086,092 40,086,092 8,514,165 (31,571,927) 21.2% Code Enforcement 322,537 415,841 415,841 42,718 (373,123) 10.3% Parking Fines 614,363 512,997 512,997 121,307 (391,690) 23.6% Library Fines & Fees 166,785 175,666 175,666 37,295 (138,371) 21.2% Contrib & Donations 547,781 413,318 647,349 97,347 (550,002) 15.0% Printed Materials 49,104 43,136 43,136 11,198 (31,938) 26.0% Animal Adoption 12,912 11,060 11,060 4,520 (6,540) 40.9% Misc Merchandise 66,801 59,036 59,036 37,315 (21,721) 63.2% Intra-City Charges 2,760,448 2,766,196 2,834,951 693,295 (2,141,656) 24.5% Other Misc Revenue 930,739 634,418 634,419 105,578 (528,841) 16.6% All Funds City of Iowa City FY2016 Through The Quarter Ended September 30, 2015 Revenues by Type 6 2015 Actual 2016 Budget 2016 Revised 2016 Year-to-Date 2016 Variance Pct of Revised All Funds City of Iowa City FY2016 Through The Quarter Ended September 30, 2015 Revenues by Type Special Assessments 604 979 979 126 (853) Miscellaneous 5,472,074 5,032,647 5,335,434 1,150,699 (4,184,735) 21.6% Debt Sales 7,866,773 12,982,068 12,982,068 - (12,982,068) 0.0% Sale Of Assets 2,316,495 494,150 2,909,982 952,749 (1,957,233) 32.7% Loans 2,339,448 927,412 927,412 169,053 (758,359) 18.2% Other Financial Sources 12,522,716 14,403,630 16,819,462 1,121,802 (15,697,660) 6.7% Total Budgetary Revenues 153,074,089$ 149,924,639$ 159,615,153$ 22,624,909$ (136,990,244)$ 14.2% Non-Budgetary Fund Revenues Capital Project Funds 100,760$ 100,000$ 100,000$ 807$ (99,193)$ 0.8% Internal Service Funds 17,812,864 18,491,211 18,491,211 3,584,051 (14,907,160) 19.4% Total Non-Budgetary Revenues 17,913,624$ 18,591,211$ 18,591,211$ 3,584,858$ (15,006,353)$ 19.3% Total Revenues - All Funds 170,987,713$ 168,515,850$ 178,206,365$ 26,209,767$ (151,996,598)$ 14.7% $- $5,000,000 $10,000,000 $15,000,000 $20,000,000 $25,000,000 $30,000,000 $35,000,000 $40,000,000 $45,000,000 $50,000,000 $55,000,000 All Funds Budgetary Revenues by Type FY2016 Through the Quarter Ended September 30, 2015 FY 2016 Revised FY 2016 Year-to-Date 7 2015 Actual 2016 Budget 2016 Revised 2016 Year-to-Date 2016 Variance Pct of Revised Budgetary Funds Expenditures General Fund 10** General Fund City Council 97,273$ 119,412$ 119,412$ 26,442$ (92,970)$ 22.1% City Clerk 518,724 576,888 576,888 100,052 (476,836) 17.3% City Attorney 690,901 712,939 712,939 143,492 (569,447) 20.1% City Manager 1,805,223 2,260,704 2,290,704 479,266 (1,811,438) 20.9% Finance 3,751,801 4,097,972 4,097,969 1,278,891 (2,819,078) 31.2% Police 12,389,622 12,892,439 12,963,803 2,463,920 (10,499,883) 19.0% Fire 7,598,771 7,754,662 7,784,201 1,599,837 (6,184,364) 20.6% Parks & Recreation 7,628,887 8,147,163 8,207,788 1,564,116 (6,643,672) 19.1% Library 5,908,777 6,150,211 6,280,211 1,369,036 (4,911,175) 21.8% Senior Center 834,813 898,419 934,017 157,542 (776,475) 16.9% Neighborhood & Dvlpmnt Services 6,958,307 5,326,434 8,159,526 1,894,323 (6,265,203) 23.2% Public Works 1,137,570 1,390,342 1,390,342 201,056 (1,189,286) 14.5% Transportation & Resource Managemen - - - - - Total General Fund 49,320,669 50,327,585 53,517,800 11,277,973 (42,239,826) 21.1% Special Revenue Funds 2100 Community Dev Block Grant Neighborhood & Dvlpmnt Services 535,735 753,955 832,605 98,655 (733,950) 11.8% 2110 HOME Neighborhood & Dvlpmnt Services 387,664 551,612 551,612 439,265 (112,347) 79.6% 2200 Road Use Tax Fund Public Works 5,563,554 5,840,581 5,919,223 1,029,902 (4,889,321) 17.4% 2300 Other Shared Revenue Neighborhood & Dvlpmnt Services 129,831 - - 550 550 2350 Metro Planning Org of Johnson Co Neighborhood & Dvlpmnt Services 541,601 610,325 610,325 128,020 (482,304) 21.0% 2400 Employee Benefits Finance 976,606 951,539 951,539 143,671 (807,868) 15.1% 2510 Peninsula Apartments Neighborhood & Dvlpmnt Services 59,957 48,206 48,206 13,405 (34,801) 27.8% 26** Tax Increment Financing Neighborhood & Dvlpmnt Services 18,670 42,500 42,500 - (42,500) 0.0% 2820 SSMID-Downtown District Neighborhood & Dvlpmnt Services 296,141 294,092 294,092 - (294,092) 0.0% Total Special Revenue Funds 8,509,759 9,092,810 9,250,102 1,853,468 (7,396,634) 20.0% Debt Service Fund 5*** Debt Service Finance 17,208,781 13,207,838 13,212,238 3,094,328 (10,117,910) 23.4% Total Debt Service Fund 17,208,781 13,207,838 13,212,238 3,094,328 (10,117,910) 23.4% Expenditures by Fund by Department FY2016 Through The Quarter Ended September 30, 2015 Budgetary Funds City of Iowa City 8 2015 Actual 2016 Budget 2016 Revised 2016 Year-to-Date 2016 Variance Pct of Revised Expenditures by Fund by Department FY2016 Through The Quarter Ended September 30, 2015 Budgetary Funds City of Iowa City Enterprise Funds 710* Parking Transportation & Resource Managemen 11,228,816$ 3,270,015$ 3,368,951$ 723,184$ (2,645,767)$ 21.5% 715* Mass Transit Transportation & Resource Managemen 6,556,267 6,879,486 7,250,374 1,216,813 (6,033,561) 16.8% 720* Wastewater Public Works 10,384,032 10,395,608 10,512,521 5,232,095 (5,280,426) 49.8% 730* Water Public Works 7,646,828 8,423,501 8,543,229 2,825,793 (5,717,436) 33.1% 7400 Refuse Collection Transportation & Resource Managemen 2,922,269 3,088,438 3,048,482 674,781 (2,373,701) 22.1% 750* Landfill Transportation & Resource Managemen 4,677,884 4,437,980 4,295,046 775,233 (3,519,813) 18.0% 7600 Airport Airport Operations 365,460 346,072 346,072 64,241 (281,831) 18.6% 7700 Stormwater Public Works 1,095,239 786,064 828,840 95,495 (733,345) 11.5% 780* Cable Television City Manager 687,397 - - - - 79** Housing Authority Neighborhood & Dvlpmnt Services 7,730,524 7,537,903 7,537,903 2,483,658 (5,054,245) 32.9% Total Enterprise Funds 53,294,716 45,165,067 45,731,418 14,091,293 (31,640,125) 30.8% Capital Project Funds Governmental Projects 24,859,198 36,301,340 54,033,844 1,664,527 (52,369,317) 3.1% Enterprise Projects 6,485,716 3,892,758 13,646,306 (1,135,866) (14,782,172) -8.3% Total Capital Project Funds 31,344,914 40,194,098 67,680,150 528,661 (67,151,489) 0.8% Total Budgetary Expenditures 159,678,840$ 157,987,398$ 189,391,707$ 30,845,723$ (158,545,984)$ 16.3% Non-Budgetary Funds Expenditures Capital Project Funds Internal Service Projects 62,526$ 100,000$ 601,800$ 238,323$ (363,477)$ 39.6% Total Capital Project Funds 62,526 100,000 601,800 238,323 (363,477) 39.6% Internal Service Funds 810* Equipment Public Works 5,194,488 5,990,748 5,990,748 759,536 (5,231,212) 12.7% 8200 Risk Management Finance 1,435,706 1,329,373 1,329,373 188,509 (1,140,864) 14.2% 830* Information Technology Finance 1,786,707 2,018,404 2,018,404 388,017 (1,630,387) 19.2% 8400 Central Services Finance 308,846 308,458 315,258 44,390 (270,868) 14.1% 8500 Health Insurance Reserves Finance 7,285,127 7,880,283 7,880,283 2,012,017 (5,868,266) 25.5% 8600 Dental Insurance Reserves Finance 354,318 359,275 359,275 85,189 (274,086) 23.7% Total Internal Service Funds 16,365,192 17,886,541 17,893,341 3,477,658 (14,415,683) 19.4% Total Non-Budgetary Expenditures 16,427,718$ 17,986,541$ 18,495,141$ 3,715,981$ (14,779,160)$ 20.1% Total Expenditures - All Funds 176,106,558$ 175,973,939$ 207,886,848$ 34,561,704$ (173,325,144)$ 16.6% 9 $- $5,000,000 $10,000,000 $15,000,000 $20,000,000 $25,000,000 $30,000,000 City of Iowa City Budgetary Funds Operating Expenditures by Department FY2016 Through The Quarter Ended September 30, 2015 FY 2016 Year-to-Date FY 2016 Revised 10 2015 Actual 2016 Budget 2016 Revised 2016 Year-to-Date 2016 Variance Pct of Revised Budgetary Funds Expenditures Public Safety 22,217,987 22,668,141 22,769,044 4,110,638 (18,658,406) 18.1% Public Works 7,186,876 7,815,170 7,893,812 1,342,051 (6,551,761) 17.0% Health and Social Services 319,723 283,833 303,833 86,208 (217,625) 28.4% Culture and Recreation 12,904,240 13,332,011 13,792,780 2,856,137 (10,936,643) 20.7% Community and Economic Dvlpmnt 7,649,800 6,486,418 9,185,249 2,238,005 (6,947,244) 24.4% General Government 7,551,806 8,834,822 8,823,190 2,498,402 (6,324,788) 28.3% Debt Service 17,208,782 13,207,838 13,212,238 3,094,328 (10,117,910) 23.4% Capital Projects 24,859,198 36,301,340 54,033,844 1,664,527 (52,369,317) 3.1% Enterprise 59,780,431 49,057,825 59,417,680 12,955,427 (46,462,253) 21.8%- Total Budgetary Expenditures 159,678,843$ 157,987,398$ 189,431,670$ 30,845,723$ (158,585,947)$ 16.3% Non-Budgetary Funds Expenditures Capital Projects - Internal Service 62,526 100,000 601,800 238,323 (363,477) 39.6% Internal Service 16,365,194 17,886,541 17,893,341 3,477,658 (14,415,683) 19.4% Total Non-Budgetary Expenditures 16,427,720$ 17,986,541$ 18,495,141$ 3,715,981$ (14,779,160)$ 20.1% Total Expenditures - All Funds 176,106,563$ 175,973,939$ 207,926,811$ 34,561,704$ (173,365,107)$ 16.6% Expenditures by State Program FY2016 Through The Quarter Ended September 30, 2015 All Funds City of Iowa City - 2,500,000 5,000,000 7,500,000 10,000,000 12,500,000 15,000,000 17,500,000 20,000,000 22,500,000 25,000,000 27,500,000 30,000,000 32,500,000 35,000,000 37,500,000 40,000,000 42,500,000 45,000,000 47,500,000 50,000,000 52,500,000 55,000,000 57,500,000 60,000,000 62,500,000 Public Safety Public Works Health and Social Services Culture and Recreation Community and Economic Dvlpmnt General Government Debt Service Capital Projects Enterprise Budgetary Expenditures by Program FY2016 Through The Quarter Ended September 30, 2015 FY 2016 Revised FY 2016 Year-to-Date 11 2015 2016 2016 2016 2016 Pct of Actual Budget Revised Year-to-Date Variance Revised Fund Balance*, July 1 47,793,327$ 43,209,518$ 49,045,399$ 49,045,399$ -$ 100.0% Revenues: Property Taxes 29,419,594$ 29,804,437$ 29,804,437$ 1,916,547$ (27,887,890)$ 6.4% Delinquent Property Taxes 1,937 - - - - Other City Taxes 2,487,767 2,428,855 2,428,855 5,984 (2,422,871) 0.2% Licenses And Permits 1,805,901 2,235,526 2,235,526 553,117 (1,682,409) 24.7% Use Of Money And Property 800,227 556,656 556,656 63,876 (492,780) 11.5% Intergovernmental 3,519,060 3,801,259 3,801,259 1,704,266 (2,096,993) 44.8% Charges For Fees And Services 1,509,496 1,277,691 1,277,691 341,707 (935,984) 26.7% Miscellaneous 4,446,754 4,478,841 4,627,596 953,466 (3,674,130) 20.6% Other Financial Sources 2,762,834 951,781 3,367,613 991,453 (2,376,160) 29.4% Sub-Total Revenues 46,753,570 45,535,046 48,099,633 6,530,416 (41,569,217) 13.6% Transfers In: Operating Transfers In 10,642,456 10,684,362 10,684,362 3,868,605 (6,815,757) 36.2% Sub-Total Transfers In 10,642,456 10,684,362 10,684,362 3,868,605 (6,815,757) 36.2% Total Revenues & Transfers In 57,396,026$ 56,219,408$ 58,783,995$ 10,399,021$ (48,384,974)$ 17.7% Expenditures by Department: City Council 97,273$ 119,412$ 119,412$ 26,442$ (92,970)$ 22.1% City Clerk 518,724 576,888 576,888 100,052 (476,836) 17.3% City Attorney 690,901 712,939 712,939 143,492 (569,447) 20.1% City Manager 1,805,223 2,260,704 2,290,704 479,267 (1,811,437) 20.9% Finance 3,751,801 4,097,972 4,097,969 1,278,891 (2,819,078) 31.2% Police 12,389,622 12,892,439 12,963,803 2,463,920 (10,499,883) 19.0% Fire 7,598,771 7,754,662 7,784,201 1,599,836 (6,184,365) 20.6% Parks and Recreation 7,628,887 8,147,163 8,207,788 1,564,116 (6,643,672) 19.1% Library 5,908,777 6,150,211 6,280,211 1,369,035 (4,911,176) 21.8% Senior Center 834,813 898,419 934,017 157,542 (776,475) 16.9% Neighborhood & Development Services 6,958,307 5,326,434 8,159,526 1,894,323 (6,265,203) 23.2% Public Works 1,137,570 1,390,342 1,390,342 201,056 (1,189,286) 14.5% Sub-Total Expenditures 49,320,669 50,327,585 53,517,800 11,277,973 (42,239,826) 21.1% Transfers Out: Capital Project Fund 1,605,164 22,017,600 22,017,600 1,214,315 (20,803,285) 5.5% GO Bond Abatement 195,537 160,052 160,052 - (160,052) 0.0% General Levy 187,489 219,996 219,996 53,049 (166,947) 24.1% Emergency Fund 1,338,516 - - - - Transfers Out - Transit Fund 2,972,534 3,110,548 3,110,548 777,637 (2,332,911) 25.0% Misc Transfers Out 524,045 72,422 72,422 18,105 (54,317) 25.0% Sub-Total Transfers Out 6,823,285 25,580,618 25,580,618 2,063,106 (23,517,512) 8.1% Total Expenditures & Transfers Out 56,143,954$ 75,908,203$ 79,098,418$ 13,341,079$ (65,757,338)$ 16.9% Fund Balance*, June 30 49,045,399$ 23,520,723$ 28,730,976$ 46,103,340$ 17,372,364$ 160.5% Adjustments due to Cable TV Fund Merged (169,954) Adjusted Fund Balance*, June 30 49,045,399 23,520,723 28,730,976 45,933,386 17,202,410 159.9% Restricted / Committed /Assigned 29,738,181 5,432,221 8,016,729 29,273,534 21,256,805 365.2% Unassigned Balance 19,307,218$ 18,088,502$ 20,714,247$ 16,659,852$ (4,054,395)$ 80.4% Fund Summary FY 2016 Through The Quarter Ended September 30, 2015 General Fund (1000 - 1023) City of Iowa City 12 2015 2016 2016 2016 2016 Pct of Actual Budget Revised Year-to-Date Variance Revised Fund Balance*, July 1 (5,447)$ 151,196$ 144,414$ 144,414$ -$ 100.0% Revenues: Use Of Money And Property Interest Revenues 3,883$ 5,337$ 5,337$ 1,073$ (4,264)$ 20.1% Intergovernmental Federal Intergovernmental Revenue 324,990 705,000 705,000 13,953 (691,047) 2.0% Miscellaneous Other Misc Revenue 1,325 1,100 1,100 - (1,100) 0.0% Other Financial Sources Loans 355,398 148,525 148,525 25,082 (123,443) 16.9% Total Revenues 685,596$ 859,962$ 859,962$ 40,108$ (819,854)$ 4.7% Expenditures: CDBG & CDBG Rehab 535,735$ 753,955$ 832,605$ 98,655$ (733,950)$ 11.8% Sub-Total Expenditures 535,735 753,955 832,605 98,655 (733,950) 11.8% Transfers Out: Misc Transfers Out - - - - - Sub-Total Transfers Out - - - - - Total Expenditures & Transfers Out 535,735$ 753,955$ 832,605$ 98,655$ (733,950)$ 11.8% Fund Balance*, June 30 144,414$ 257,203$ 171,771$ 85,867$ (85,904)$ 50.0% Restricted / Committed /Assigned - - - - - Unassigned Balance 144,414$ 257,203$ 171,771$ 85,867$ (85,904)$ 50.0% Fund Summary FY 2016 Through The Quarter Ended September 30, 2015 CDBG & CDBG Rehab (2100) City of Iowa City 13 2015 2016 2016 2016 2016 Pct of Actual Budget Revised Year-to-Date Variance Revised Fund Balance*, July 1 4,539,578$ 4,553,197$ 5,564,215$ 5,564,215$ -$ 100.0% Revenues: Intergovernmental Fed Intergovnt Rev 60,482$ -$ -$ -$ -$ Disaster Assistance 6,579 - - - - Other State Grants 14,187 - - - - Road Use Tax 7,230,663 6,744,663 6,744,663 1,773,736 (4,970,927) 26.3% Charges For Fees And Services - Building & Devlpmt 49,597 22,735 22,735 (1,460) (24,195) -6.4% Miscellaneous - Misc Merchandise - 2,041 2,041 - (2,041) 0.0% Other Misc Revenue 52,364 25,188 25,188 5,064 (20,124) 20.1% Other Financial Sources - Sale Of Assets 1,054 - - - - Sub-Total Revenues 7,414,926 6,794,627 6,794,627 1,777,340 (5,017,287) 26.2% Transfers In: Transfers In-Govt Activities 390,414 396,370 396,370 99,093 (297,277) 25.0% Sub-Total Transfers In 390,414 396,370 396,370 99,093 (297,277) 25.0% Total Revenues & Transfers In 7,805,340$ 7,190,997$ 7,190,997$ 1,876,433$ (5,314,564)$ 26.1% Expenditures: Road Use Tax Administration 77,691$ 82,172$ 82,172$ -$ (82,172)$ 0.0% Sidewalk Inspection 74,162 81,523 81,523 6,729 (74,794) 8.3% Traffic Engineering 1,430,031 1,417,669 1,477,390 302,839 (1,174,551) 20.5% Streets System Maintenance 3,981,670 4,259,217 4,278,138 720,334 (3,557,804) 16.8% Sub-Total Expenditures 5,563,554 5,840,581 5,919,223 1,029,902 (4,889,321) 17.4% Transfers Out: Capital Project Fund 921,954 915,000 1,215,000 228,750 (986,250) 18.8% Misc Transfers Out 295,195 283,111 283,111 64,648 (218,463) 22.8% Sub-Total Transfers Out 1,217,149 1,198,111 1,498,111 293,398 (1,204,713) 19.6% Total Expenditures & Transfers Out 6,780,703$ 7,038,692$ 7,417,334$ 1,323,300$ (6,094,034)$ 17.8% Fund Balance*, June 30 5,564,215$ 4,705,502$ 5,337,878$ 6,117,348$ 779,470$ 114.6% Restricted / Committed /Assigned - - - - - Unassigned Balance 5,564,215$ 4,705,502$ 5,337,878$ 6,117,348$ 779,470$ 114.6% Fund Summary FY 2016 Through The Quarter Ended September 30, 2015 Road Use Tax (2200) City of Iowa City 14 2015 2016 2016 2016 2016 Pct of Actual Budget Revised Year-to-Date Variance Revised Fund Balance*, July 1 1,713,207$ 1,494,118$ 1,592,570$ 1,592,570$ -$ 100.0% Revenues: Property Taxes 9,068,205$ 9,652,480$ 9,652,480$ 620,703$ (9,031,777)$ 6.4% Delinquent Property Taxes 597 - - - - Other City Taxes 162,998 157,935 157,935 1,938 (155,997) 1.2% Intergovernmental - Property Tax Credits 183,244 383,367 383,367 - (383,367) 0.0% State 28E Agreements 315,605 287,179 287,179 326,586 39,407 113.7% Miscellaneous - Other Misc Revenue 51,828 - - 85 85 Total Revenues 9,782,477$ 10,480,961$ 10,480,961$ 949,312$ (9,531,649)$ 9.1% Expenditures: General Government Employee Benefits 378,169$ 367,313$ 367,313$ 112,288$ (255,025)$ 30.6% Public Safety Employee Benefits 598,437 584,226 584,226 31,383 (552,843) 5.4% Sub-Total Expenditures 976,606 951,539 951,539 143,671 (807,868) 15.1% Transfers Out: Empl Benefits Levy to Gen Fund & RUT 8,926,508 9,389,267 9,389,267 2,347,317 (7,041,950) 25.0% Sub-Total Transfers Out 8,926,508 9,389,267 9,389,267 2,347,317 (7,041,950) 25.0% Total Expenditures & Transfers Out 9,903,114$ 10,340,806$ 10,340,806$ 2,490,988$ (7,849,818)$ 24.1% Fund Balance*, June 30 1,592,570$ 1,634,273$ 1,732,725$ 50,894$ (1,681,831)$ 2.9% Restricted / Committed /Assigned - - - - - Unassigned Balance 1,592,570$ 1,634,273$ 1,732,725$ 50,894$ (1,681,831)$ 2.9% Fund Summary FY 2016 Through The Quarter Ended September 30, 2015 Employee Benefits (2400) City of Iowa City 15 2015 2016 2016 2016 2016 Pct of Actual Budget Revised Year-to-Date Variance Revised Fund Balance*, July 1 8,868,053$ 6,175,774$ 6,444,718$ 6,444,718$ -$ 100.0% Revenues: Property Taxes 12,724,396$ 12,312,386$ 12,312,386$ 794,775$ (11,517,611)$ 6.5% Delinquent Property Taxes 833 - - - - Other City Taxes 227,123 199,499 199,499 2,447 (197,052) 1.2% Use Of Money And Property Interest Revenues 74,553 45,929 45,929 1,835 (44,094) 4.0% Intergovernmental Property Tax Credits 255,366 483,825 483,825 - (483,825) 0.0% Charges For Fees And Services Building & Development 190,785 - - - - Other Financial Sources Loan Repayments 178,166 188,411 188,411 44,872 (143,539) 23.8% Sub-Total Revenues 13,651,222 13,230,050 13,230,050 843,929 (12,386,121) 6.4% Transfers In Transfers-In 1,134,225 1,420,503 1,420,503 - (1,420,503) 0.0% Sub-Total Transfers In 1,134,225 1,420,503 1,420,503 - (1,420,503) 0.0% Total Revenues & Transfers In 14,785,447$ 14,650,553$ 14,650,553$ 843,929$ (13,806,624)$ 5.8% Expenditures: Financial Services & Charges -$ -$ 4,400$ -$ (4,400)$ 0.0% GO Bonds Principal 15,525,000 11,385,000 11,385,000 3,085,000 (8,300,000) 27.1% GO Bonds Interest 1,608,447 1,617,503 1,617,503 9,328 (1,608,175) 0.6% Revenue Bonds Principal - 130,000 130,000 - (130,000) 0.0% Revenue Bonds Interest 75,335 75,335 75,335 - (75,335) 0.0% Total Expenditures & Transfers Out 17,208,782$ 13,207,838$ 13,212,238$ 3,094,328$ (10,117,910)$ 23.4% Fund Balance*, June 30 6,444,718$ 7,618,489$ 7,883,033$ 4,194,319$ (3,688,714)$ 53.2% Restricted / Committed /Assigned 667,748 811,288 816,378 669,265 (147,113) 82.0% Unassigned Balance 5,776,970$ 6,807,201$ 7,066,655$ 3,525,054$ (3,541,601)$ 49.9% Fund Summary FY 2016 Through The Quarter Ended September 30, 2015 Debt Service Fund (5000 - 5999) City of Iowa City 16 2015 2016 2016 2016 2016 Pct of Actual Budget Revised Year-to-Date Variance Revised Fund Balance*, July 1 6,867,952$ 3,039,145$ 3,713,076$ 3,713,076$ -$ 100.0% Revenues: Use Of Money And Property Interest Revenues 35,207$ 27,765$ 27,765$ (2,547)$ (30,312)$ -9.2% Charges For Fees And Services Parking Charges 5,253,011 5,076,208 5,076,208 1,525,183 (3,551,025) 30.0% Miscellaneous Parking Fines 248,840 197,578 197,578 39,280 (158,298) 19.9% Other Misc Revenue 82,593 27,325 27,325 9,158 (18,167) 33.5% Sub-Total Revenues 5,619,651 5,328,876 5,328,876 1,571,074 (3,757,802)$ 29.5% Transfers In: Transfer In - Interfund Loan from Landfill Res 2,495,350 - - - - 1) Bond Ordinance Transfer 3,943,875 - - - - Sub-Total Transfers In 6,439,225 - - - - Total Revenues & Transfers In 12,058,876$ 5,328,876$ 5,328,876$ 1,571,074$ (3,757,802)$ 29.5% Expenditures: Parking Administration 1,227,039$ 1,140,019$ 1,215,705$ 258,419$ (957,286)$ 21.3% On Street Operations 833,273 925,984 949,234 207,366 (741,868) 21.8% Parking Ramp Operations 1,194,952 1,204,012 1,204,012 257,399 (946,613) 21.4% Parking Debt Service 7,973,550 - - - - Sub-Total Expenditures 11,228,814 3,270,015 3,368,951 723,184 (2,645,767) 21.5% Transfers Out: Capital Improvement Projects (103,318) 670,000 670,000 - (670,000) 0.0% 1) Debt Service Transfers 3,943,875 - - - - Interfund Loan Repayment to Landfill 144,381 221,437 221,437 55,361 (166,076) 25.0% Sub-Total Transfers Out 3,984,938 891,437 891,437 55,361 (836,076) 6.2% Total Expenditures & Transfers Out 15,213,752$ 4,161,452$ 4,260,388$ 778,545$ (3,481,843)$ 18.3% Fund Balance*, June 30 3,713,076$ 4,206,569$ 4,781,564$ 4,505,605$ (275,959)$ 94.2% Restricted / Committed /Assigned 385,583 385,583 385,583 385,583 - 100.0% Unassigned Balance 3,327,493$ 3,820,986$ 4,395,981$ 4,120,022$ (275,959)$ 93.7% City of Iowa City Parking (7100 - 7102) Fund Summary FY 2016 Through The Quarter Ended September 30, 2015 17 2015 2016 2016 2016 2016 Pct of Actual Budget Revised Year-to-Date Variance Revised Fund Balance*, July 1 3,965,749$ 4,248,445$ 4,762,385$ 4,762,385$ -$ 100.0% Revenues: Use Of Money And Property Interest Revenues 16,063$ 2,521$ 2,521$ (719)$ (3,240)$ -28.5% Rents 131,943 128,739 128,739 44,002 (84,737) 34.2% Intergovernmental - Fed Intergovnt Rev 1,439,334 1,440,000 1,440,000 - (1,440,000) 0.0% Other State Grants 642,210 565,742 565,742 128,909 (436,833) 22.8% Local 28E Agreements 32,562 35,522 35,522 12,000 (23,522) 33.8% Charges For Fees And Services Transit Fees 1,445,831 1,384,791 1,384,791 217,666 (1,167,125) 15.7% Misc Charges For Svc 2,665 410 410 1,037 627 252.9% Refuse Charges 810 1,738 1,738 70 (1,668) 4.0% Parking Charges 675,232 645,578 645,578 363,566 (282,012) 56.3% Miscellaneous Printed Materials 30 - - - - Misc Merchandise 1,098 376 376 - (376) 0.0% Other Misc Revenue 32,061 1,251 1,251 1,633 382 130.5% Sub-Total Revenues 4,419,839 4,206,668 4,206,668 768,164 (3,438,504) 18.3% Transfers In: Transfer In - Transit Property Tax Levy 2,972,534 3,110,548 3,110,548 777,637 (2,332,911) 25.0% Transfer In - Operations to Bus Reserve 136,238 136,000 136,000 - (136,000) 0.0% Sub-Total Transfers In 3,108,772 3,246,548 3,246,548 777,637 (2,468,911) 24.0% Total Revenues & Transfers In 7,528,611$ 7,453,216$ 7,453,216$ 1,545,801$ (5,907,415)$ 20.7%- Expenditures: Mass Transit Admin 436,567$ 427,978$ 427,978$ 56,018$ (371,960)$ 13.1% Mass Transit Operations 4,528,972 4,653,290 4,653,290 846,499 (3,806,791) 18.2% Fleet Maintenance 1,420,642 1,645,090 1,645,090 286,291 (1,358,799) 17.4% Court St Transportation Center 170,085 153,128 153,128 28,005 (125,123) 18.3% Bus Replacement Reserve - - 370,888 - (370,888) 0.0% Sub-Total Expenditures 6,556,266 6,879,486 7,250,374 1,216,813 (6,033,561) 16.8% Transfers Out: Capital Project Fund (16,917) 50,000 50,000 - (50,000) 0.0% InterFund Loan Repay Landfill 56,388 29,651 29,651 7,413 (22,238) 25.0% Bus Reserve Transfers Out 136,238 136,000 136,000 - (136,000) 0.0% Sub-Total Transfers Out 175,709 215,651 215,651 7,413 (208,238) 3.4% Total Expenditures & Transfers Out 6,731,975$ 7,095,137$ 7,466,025$ 1,224,226$ (6,241,799)$ 16.4% Fund Balance*, June 30 4,762,385$ 4,606,524$ 4,749,576$ 5,083,960$ 334,384$ 107.0% Restricted / Committed /Assigned 1,268,156 1,200,718 1,033,268 1,268,156 234,888 122.7% Unassigned Balance 3,494,229$ 3,405,806$ 3,716,308$ 3,815,804$ 99,496$ 102.7% City of Iowa City Transit (7150 - 7151) Fund Summary FY 2016 Through The Quarter Ended September 30, 2015 18 2015 2016 2016 2016 2016 Pct of Actual Budget Revised Year-to-Date Variance Revised Fund Balance*, July 1 24,069,885$ 17,892,588$ 19,788,658$ 19,788,658$ -$ 100.0% Revenues: Licenses And Permits Misc Permits & Lic 8,012$ 7,484$ 7,484$ 7,256$ (228)$ 97.0% Intergovernmental Fed Intergovnt Rev 21,427 - - - - Disaster Assistance 2,064 - - - - Use Of Money And Property Interest Revenues 286,055 331,426 331,426 11,625 (319,801) 3.5% Royalties & Commiss 208 277 277 45 (232) 16.2% Charges For Fees And Services Misc Charges For Svc 1,410 2,016 2,016 - (2,016) 0.0% Wastewater Charges 12,180,738 12,555,993 12,555,993 2,209,926 (10,346,067) 17.6% Refuse Charges 719 1,223 1,223 - (1,223) 0.0% Miscellaneous Misc Merchandise 4,149 1,375 1,375 180 (1,195) 13.1% Other Misc Revenue 86,459 65,360 65,360 20,276 (45,084) 31.0% Other Financial Sources Sale Of Assets 1,187 - - - - Sub-Total Revenues:12,592,428 12,965,154 12,965,154 2,249,308 (10,715,846) 17.3% Transfers In: Interfund Loans 200,000 200,000 200,000 - (200,000) 0.0%1) Bond Ordinance Trans 4,763,163 4,488,036 4,488,036 1,183,019 (3,305,017) 26.4% Misc Transfers In 203,200 - - - - Sub-Total Transfers In 5,166,363 4,688,036 4,688,036 1,183,019 (3,505,017) 25.2% Total Revenues & Transfers In 17,758,791$ 17,653,190$ 17,653,190$ 3,432,327$ (14,220,863)$ 19.4% Expenditures: Wastewater Administration 1,621,484$ 1,648,538$ 1,764,251$ 285,837$ (1,478,414)$ 16.2% Wastewater Treatment Plant Ops 3,242,645 3,076,661 3,076,661 621,952 (2,454,709) 20.2% Lift Stations 6,419 - - - - Wastewater Collection Systems 838,584 975,290 975,290 182,725 (792,565) 18.7% Wastewater Debt Service 4,674,900 4,695,119 4,696,319 4,141,581 (554,738) 88.2% Sub-Total Expenditures 10,384,032 10,395,608 10,512,521 5,232,095 (5,280,426) 49.8% Transfers Out: Capital Project Fund 689,624 3,050,000 3,050,000 125,000 (2,925,000) 4.1% 1) Debt Service Funding 4,763,162 4,488,036 4,488,036 1,183,019 (3,305,017) 26.4% Interfund Loans 6,000,000 - - - Misc Transfers Out 203,200 - - Sub-Total Transfers Out 11,655,986 7,538,036 7,538,036 1,308,019 (6,230,017) 17.4% Total Expenditures & Transfers Out 22,040,018$ 17,933,644$ 18,050,557$ 6,540,114$ (11,510,443)$ 36.2% Fund Balance*, June 30 19,788,658$ 17,612,134$ 19,391,291$ 16,680,871$ (2,710,420)$ 86.0% Restricted / Committed /Assigned 9,860,329 9,653,245 9,652,046 6,901,767 (2,750,279) 71.5% Unassigned Balance 9,928,329$ 7,958,889$ 9,739,245$ 9,779,104$ 39,859$ 100.4% City of Iowa City Wastewater Treatment (7200 - 7201) Fund Summary FY 2016 Through The Quarter Ended September 30, 2015 19 2015 2016 2016 2016 2016 Pct of Actual Budget Revised Year-to-Date Variance Revised Fund Balance*, July 1 11,541,132$ 11,682,431$ 12,332,979$ 12,332,979$ -$ 100.0% Revenues: Use Of Money And Property Interest Revenues 170,614$ 130,169$ 130,169$ 2,186$ (127,983)$ 1.7% Rents - 750 750 - (750) 0.0% Royalties & Commiss 772 723 723 175 (548) 24.2% Intergovernmental Fed Intergovnt Rev 41,920 - - - - Disaster Assistance 347 - - - - Other State Grants 270 - - - - Charges For Fees And Services Water Charges 8,525,988 9,265,018 9,265,018 1,832,032 (7,432,986) 19.8% Miscellaneous Printed Materials 29 - - 8 8 Misc Merchandise 12,802 8,537 8,537 12,425 3,888 145.5% Intra-City Charges 2,000 2,000 2,000 2,000 - 100.0% Other Misc Revenue (1,611) 5,259 5,259 - (5,259) 0.0% Other Financial Sources Sale Of Assets 48 - - - - Sub-Total Revenues 8,753,179 9,412,456 9,412,456 1,848,826 (7,563,630) 19.6% Transfers In:1) Bond Ordinance Transfers In 2,008,715 2,010,716 2,010,716 502,679 (1,508,037) 25.0% Sub-Total Transfers In 2,008,715 2,010,716 2,010,716 502,679 (1,508,037) 25.0% Total Revenues & Transfers In 10,761,894$ 11,423,172$ 11,423,172$ 2,351,505$ (9,071,667)$ 20.6% Expenditures: Water Administration 1,221,916$ 1,442,472$ 1,448,300$ 279,021$ (1,169,279)$ 19.3% Water Treatment Plant Ops 2,017,234 2,258,399 2,371,099 357,301 (2,013,798) 15.1% Water Distribution System 1,090,836 1,527,193 1,527,193 199,347 (1,327,846) 13.1% Water Customer Service 1,271,251 1,150,856 1,150,856 264,587 (886,269) 23.0% Water Public Relations 56,077 57,365 57,365 11,179 (46,186) 19.5% Water Debt Service 1,989,515 1,987,216 1,988,416 1,714,358 (274,058) 86.2% Sub-Total Expenditures 7,646,829 8,423,501 8,543,229 2,825,793 (5,717,436) 33.1% Transfers Out: Capital Project Fund - 1,346,500 1,346,500 526 (1,345,974) 0.0% 1) Debt Service Funding 2,008,715 2,010,716 2,010,716 502,679 (1,508,037) 25.0% GO Bond Abatement 314,503 306,800 306,800 - (306,800) 0.0% Sub-Total Transfers Out 2,323,218 3,664,016 3,664,016 503,205 (3,160,811) 13.7% Total Expenditures & Transfers Out 9,970,047$ 12,087,517$ 12,207,245$ 3,328,998$ (8,878,247)$ 27.3% Fund Balance*, June 30 12,332,979$ 11,018,086$ 11,548,906$ 11,355,486$ (193,420)$ 98.3% Restricted / Committed /Assigned 4,194,579 4,218,079 4,216,879 2,982,900 (1,233,979) 70.7% Unassigned Balance 8,138,400$ 6,800,007$ 7,332,027$ 8,372,586$ 1,040,559$ 114.2% Fund Summary FY 2016 Through The Quarter Ended September 30, 2015 Water (7300 - 7301) City of Iowa City 20 2015 2016 2016 2016 2016 Pct of Actual Budget Revised Year-to-Date Variance Revised Fund Balance*, July 1 890,410$ 801,587$ 1,050,437$ 1,050,437$ -$ 100.0% Revenues: Licenses And Permits General Use Permits 4,300$ 6,325$ 6,325$ -$ (6,325)$ 0.0% Use Of Money And Property Interest Revenues 2,928 357 357 (468) (825) -131.1% Charges For Fees And Services Refuse Charges 3,175,020 3,050,190 3,050,190 561,571 (2,488,619) 18.4% Miscellaneous Other Misc Revenue 48 150 150 (61) (211) -40.7% Total Revenues 3,182,296$ 3,057,022$ 3,057,022$ 561,042$ (2,495,980)$ 18.4% Expenditures: Refuse Administration 485,585$ 501,735$ 501,735$ 72,681$ (429,054)$ 14.5% Refuse Operations 1,297,720 1,296,257 1,296,257 331,898 (964,359) 25.6% Yard Waste Collection 318,484 340,582 340,582 83,518 (257,064) 24.5% Curbside Recycling Collection 682,433 765,233 765,233 151,445 (613,788) 19.8% White Goods/Bulky Collection 138,047 184,631 184,631 35,239 (149,392) 19.1% Sub-Total Expenditures 2,922,269 3,088,438 3,088,438 674,781 (2,413,657) 21.8% Transfers Out: Capital Project Fund 100,000 - - - - Sub-Total Transfers Out 100,000 - - - - Total Expenditures 3,022,269$ 3,088,438$ 3,088,438$ 674,781$ (2,413,657)$ 21.8% Fund Balance*, June 30 1,050,437$ 770,171$ 1,019,021$ 936,698$ (82,323)$ 91.9% Restricted / Committed /Assigned - - - - - Unassigned Balance 1,050,437$ 770,171$ 1,019,021$ 936,698$ (82,323)$ 91.9% Fund Summary FY 2016 Through The Quarter Ended September 30, 2015 Refuse Collection (7400) City of Iowa City 21 2015 2016 2016 2016 2016 Pct of Actual Budget Revised Year-to-Date Variance Revised Fund Balance*, July 1 24,265,434$ 22,412,057$ 24,052,855$ 24,052,855$ -$ 100.0% Revenues: Use Of Money And Property Interest Revenues 122,495$ 69,207$ 69,207$ 8,687$ (60,520)$ 12.6% Rents 49,655 50,245 50,245 11,804 (38,441) 23.5% Intergovernmental Fed Intergovnt Rev 24,542 - - - - Charges For Fees And Services Refuse Charges 743,007 392,531 392,531 103,150 (289,381) 26.3% Landfill Charges 5,043,246 5,269,970 5,269,970 1,150,686 (4,119,284) 21.8% Miscellaneous Contrib & Donations 382 - - 165 165 Misc Merchandise 20,839 20,219 20,219 17,821 (2,398) 88.1% Other Misc Revenue 33,001 31,092 31,092 516 (30,576) 1.7% Sub-Total Revenues 6,037,167 5,833,264 5,833,264 1,292,829 (4,540,435) 22.2% Transfer In: Interfund Loans 879,914 251,088 251,088 62,774 (188,314) 25.0% Misc Transfers In 583,754 825,327 825,327 - (825,327) 0.0% Sub-Total Transfers In 1,463,668 1,076,415 1,076,415 62,774 (1,013,641) 5.8% Total Revenues & Transfers In 7,500,835$ 6,909,679$ 6,909,679$ 1,355,603$ (5,554,076)$ 19.6% Expenditures: Landfill Administration 1,018,633$ 810,504$ 667,570$ 109,872$ (557,698)$ 16.5% Landfill Operations 3,564,600 3,532,583 3,532,583 645,697 (2,886,886) 18.3% Solid Waste Surcharge Reserve 94,651 94,893 94,893 19,664 (75,229) 20.7% Sub-Total Expenditures 4,677,884 4,437,980 4,295,046 775,233 (3,519,813) 18.0% Transfers Out: Capital Project Funding (43,575) - - - - Misc Transfers Out 583,755 825,327 825,327 - (825,327) 0.0% Interfund Loan 2,495,350 - - - - Sub-Total Transfers Out 3,035,530 825,327 825,327 - (825,327) 0.0% Total Expenditures & Transfers Out 7,713,414$ 5,263,307$ 5,120,373$ 775,233$ (4,345,140)$ 15.1% Fund Balance*, June 30 24,052,855$ 24,058,429$ 25,842,161$ 24,633,225$ (1,208,936)$ 95.3% Restricted / Committed /Assigned 21,559,542 22,097,161 22,788,034 21,619,664 (1,168,370) 94.9% Unassigned Balance 2,493,313$ 1,961,268$ 3,054,127$ 3,013,561$ (40,566)$ 98.7% Fund Summary FY 2016 Through The Quarter Ended September 30, 2015 Landfill (7500 - 7504) City of Iowa City 22 2015 2016 2016 2016 2016 Pct of Actual Budget Revised Year-to-Date Variance Revised Fund Balance*, July 1 1,342,320$ 1,838,688$ 1,571,993$ 1,571,993$ -$ 100.0% Revenues: Use Of Money And Property Interest Revenues 5,641$ 834$ 834$ (893)$ (1,727)$ -107.1% Intergovernmental - Fed Intergovnt Rev 200,055 - - - - Disaster Assistance 21,026 - - - - Other State Grants 376 - - - - Charges For Fees And Services Storm Water Charges 1,147,390 1,140,000 1,140,000 209,030 (930,970) 18.3% Miscellaneous Printed Materials 425 - - - - Other Misc Revenue - 144 144 - (144) 0.0% Sub-Total Revenues 1,374,913 1,140,978 1,140,978 208,137 (932,841) 18.2% Transfers In: Misc Transfers In - - - - - Sub-Total Transfers In - - - - - Total Revenues 1,374,913$ 1,140,978$ 1,140,978$ 208,137$ (932,841)$ 18.2% Expenditures: Storm Water Operations 1,095,240$ 786,064$ 828,840$ 95,495$ (733,345)$ 11.5% Sub-Total Expenditures 1,095,240 786,064 828,840 95,495 (733,345) 11.5% Transfers Out: Capital Project Fund 50,000 500,000 500,000 - (500,000) 0.0% Sub-Total Transfers Out 50,000 500,000 500,000 - (500,000) 0.0% Total Expenditures & Transfers Out 1,145,240$ 1,286,064$ 1,328,840$ 95,495$ (1,233,345)$ 7.2% Fund Balance*, June 30 1,571,993$ 1,693,602$ 1,384,131$ 1,684,635$ 300,504$ 121.7% Change in Accounting Method - - - - - Adjusted Fund Balance*, June 30 1,571,993 1,693,602 1,384,131 1,684,635 300,504 121.7% Restricted / Committed /Assigned - - - - - Unassigned Balance 1,571,993$ 1,693,602$ 1,384,131$ 1,684,635$ 300,504$ 121.7% Fund Summary FY 2016 Through The Quarter Ended September 30, 2015 Storm Water Management (7700) City of Iowa City 23 2015 2016 2016 2016 2016 Pct of Actual Budget Revised Actual Variance Revised Fund Balance*, July 1 5,606,540$ 5,611,798$ 5,911,702$ 5,911,702$ -$ 100.0% Revenues: Use Of Money And Property Interest Revenues 20,787$ 4,680$ 4,680$ (5,168)$ (9,848)$ -110.4% Rents 237,306 213,333 213,333 67,766 (145,567) 31.8% Royalties & Commissions 38,635 30,509 30,509 8,873 (21,636) 29.1% Intergovernmental Fed Intergovnt Rev 7,629,448 7,759,721 7,759,721 1,892,121 (5,867,600) 24.4% Miscellaneous Other Misc Revenue 23,099 20,648 20,648 4,654 (15,994) 22.5% Other Financial Sources Loan Repayments 142,387 26,349 26,349 44,682 18,333 169.6% Sub-Total Revenues 8,091,662 8,055,240 8,055,240 2,012,928 (6,042,312) 25.0% Misc Transfers In 8,760 - - - - Sub-Total Transfers In 8,760 - - - - Total Revenues & Transfers In 8,100,422$ 8,055,240$ 8,055,240$ 2,012,928$ (6,042,312)$ 25.0% Expenditures: Voucher Program 7,205,702$ 7,052,696$ 7,052,696$ 2,431,383$ (4,621,313)$ 34.5% Public Housing Program 524,821 485,207 485,207 52,275 (432,932) 10.8% Sub-Total Expenditures 7,730,523 7,537,903 7,537,903 2,483,658 (5,054,245) 32.9% Transfers Out: Operating Subsidy - PILOT Gen Fund 18,727 18,914 18,914 4,728 (14,186) 25.0% Misc Transfers Out - Director Reimb 46,010 26,270 26,270 6,567 (19,703) 25.0% Sub-Total Transfers Out 64,737 45,184 45,184 11,295 (33,889) 25.0% Total Expenditures & Transfers Out 7,795,260$ 7,583,087$ 7,583,087$ 2,494,953$ (5,088,134)$ 32.9% Fund Balance*, June 30 5,911,702$ 6,083,951$ 6,383,855$ 5,429,677$ (954,178)$ 85.1% Restricted / Committed /Assigned 2,954,019 2,885,424 2,985,048 2,996,600 11,552 100.4% Unassigned Balance 2,957,683$ 3,198,527$ 3,398,807$ 2,433,077$ (965,730)$ 71.6% Fund Summary FY 2016 Through The Quarter Ended September 30, 2015 Housing Authority (7900 - 7922) City of Iowa City 24