HomeMy WebLinkAboutFY2016 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