The URL can be used to link to this page

Home My WebLink About2015.10 October Monthly Report To: Wally Bobkiewicz, City Manager Martin Lyons, Assistant City Manager/Chief Financial Officer From: Ashley King, Assistant Director of Administrative Services David Meimers, Accounting Manager Subject: October 2015 Monthly Financial Report Date: December 4, 2015 Please find attached the unaudited financial statements as of October 31, 2015. A summary by fund for revenues, expenditures, fund and cash balances is as follows: YTD Revenues YTD Expenses YTD Net Fund Balance Cash Balance 73,420,702 73,113,948 306,754 15,290,720 6,629,607 1,333,940 652,924 681,016 864,115 642,476 6,500,872 4,883,697 1,617,176 2,996,146 2,207,505 195,307 119,958 75,349 75,349 224,599 1,008,413 2,022,790 (1,014,378)765,653 1,222,872 766,369 891,446 (125,077)783,276 591,611 322,058 242,250 79,808 225,008 (109,794) 1,117,489 957,739 159,750 344,652 (87,714) 164,065 31,072 132,993 2,483,654 253,656 2,085,616 2,708,878 (623,263)2,917,208 2,335,137 169,915 169,915 488,386 431,478 56,908 4,636,987 8,749 3,920,732 191,644 44,396 147,248 2,694,168 937,814 598,014 126,892 471,122 564,717 468,713 4,923,680 2,976,944 1,946,736 8,133,440 7,682,242 422,531 21,075 401,456 865,502 801,504 1,249,700 1,747,215 (497,514)1,871,969 1,908,398 893,387 (893,387)278 607,483 669,813 (62,330)196,789 (5,586) 195 47,786 (47,591)452,779 459,874 2,900,000 2,292,102 607,898 607,898 607,898 13,113,556 3,637,837 9,475,719 13,272,506 11,532,083 639,021 5,864,230 (5,225,210)2,945,716 3,685,651 103,715 202,253 (98,538)2,420,030 2,415,960 7,659,424 6,098,567 1,560,857 14,375,574 14,098,930 12,943,379 14,872,877 (1,929,498)5,524,609 4,059,682 11,076,199 10,528,231 547,968 4,953,905 2,703,094 4,180,992 3,997,322 183,670 (928,405)(1,377,008) 2,788,143 2,396,510 391,633 270,689 (303,985) 1,261,917 1,303,136 (41,219)2,142,567 1,125,757 13,802,387 14,079,119 (276,732)(3,658,659)1,284,308 165,865,198 157,855,872 8,009,325 92,179,488 66,173,947 LIBRARY ENDOWMENT FUND245 601 EQUIPMENT REPLACEMENT 605 INSURANCE FUND 520 SOLID WASTE FUND 600 FLEET SERVICES FUND 515 SEWER FUND 505 PARKING SYSTEM FUND 510 WATER FUND 415 CAPITAL IMPROVEMENTS FUND 420 SPECIAL ASSESSMENT FUND 320 DEBT SERVICE FUND 345 CHICAGO-MAIN TIF 335 WEST EVANSTON TIF FUND 330 HOWARD-RIDGE TIF FUND 310 HOWARD-HARTREY TIF 315 SOUTHWEST TIF FUND 300 WASHINGTON NATIONAL TIF 305 SPECIAL SERVICE AREA (SSA) 250 AFFORDABLE HOUSING FUND 186 LIBRARY DEBT SERVICE FUND 240 HOME FUND 235 NEIGHBORHOOD IMPROVEMENT 220 CDBG LOAN 225 ECONOMIC DEVELOPMENT 210 SPECIAL SERVICE AREA (SSA) 215 CDBG FUND 200 MOTOR FUEL TAX FUND 205 EMERGENCY TELEPHONE 195 NEIGHBORHOOD STABILIZATION 185 LIBRARY FUND 100 GENERAL FUND 175 GENERAL ASSISTANCE FUND Fund Fund Description Memorandum Included above are the ending balances as of October 31, 2015 for both unreserved fund and cash balances. Of these two amounts, cash balance is the more meaningful metric since this represents liquid cash and/or invested assets which may be used (or easily sold) to support and fund current operations. While ending fund balance is also an important measurement of the City’s financial health, it usually includes illiquid assets or future cash receipts or disbursements such as receivables (including property tax) due to the City and accounts payable/accrued expenses. As of October 31, 2015, the General Fund is reporting a net surplus of $306,751. This is primarily due to the timing of revenues. At this point, approximately 97% of property taxes have been received. As can be seen in the chart on page four of this memorandum, the General Fund expenditures are 80.12% of budget and revenues are 80.29% of budget. Through October 31, 2015, the Community Development Block Grant (CDBG) Fund is showing a negative cash balance of $87,714. This amount will be reimbursed from draw-downs from HUD during November. Through October 31, 2015, the Economic Development Fund is showing a fund balance of $2,917,208 and a cash balance of $2,335,137. The Parking Fund (fund balance of $14,375,574) has capital projects in process including the Civic Center Lot ($1.3 million), and will have work scheduled for periodic parking deck maintenance/capital improvements in 2016. Through October 31, 2015, the Solid Waste Fund is showing a negative fund balance of $928,405 and a negative cash balance of $1,377,008. Though operating at a surplus for the year, the Fleet Fund is showing a negative cash balance of $303,985 through October 31, 2015. The fund balance for the Fleet Fund is $270,689. This is a significant improvement over the end of 2014 fund balance of negative $113,833. Through October 31, 2015, the Insurance Fund is showing a negative fund balance of $3,658,659. This negative balance is primarily for claims/cases being expensed. These claims/cases have not been settled, and therefore there is no guarantee the City will actually experience this negative fund balance as estimated. The Insurance Fund’s cash balance of $1,345,082 includes transfers from the IPBC Health Insurance Pool. If there are any questions on the attached report, please contact me by phone at (847) 859-7884 or by email: aking@cityofevanston.org. Detailed fund summary reports can be found at the following link: http://www.cityofevanston.org/city-budget/financial- reports/. CERTIFICATION OF ATTACHED FINANCIAL REPORTS As required per Illinois Statute 65 ILCS 5/3.1-35-45 I, Martin Lyons, Treasurer of the City of Evanston, hereby affirm that I have reviewed the October 31, 2015 year-to-date financial information and reports which to the best of my knowledge appear accurate and complete. _______________________________ Martin Lyons, Treasurer Annual MTD YTD % of Prior Year Budget Amount Actual Amount Actual Amount Budget Total Actual 11,637,118 20,045 11,321,381 97 11,547,828 43,689,300 3,857,383 36,301,788 83 42,686,089 4,001,877 96,773 1,752,024 44 3,640,206 8,139,082 627,923 5,967,826 73 9,400,120 1,756,200 30,661 1,412,901 80 1,840,274 4,495,774 336,341 2,942,230 65 3,357,965 47,027 1,757 132,697 282 416,946 640,000 0 641,667 5,367,751 187,315 4,851,917 90 5,339,742 1,692,616 111,176 1,389,750 82 1,536,216 7,892,893 686,402 6,418,533 81 7,794,625 723,700 (455,921)361,611 50 627,970 1,311,343 (25,123)563,041 43 1,362,838 50,000 614 5,002 10 13,037 91,444,681 5,475,345 73,420,702 80%90,205,523 CITY COUNCIL 427,044.0 28,923.0 334,136.3 78 450,773 CITY CLERK 249,979 20,284 221,665 89 259,908 CITY MANAGER'S OFFICE 1,903,126 109,431 1,421,355 75 1,911,831 LAW 1,129,534 74,605 830,995 74 1,060,790 ADMINISTRATIVE SERVICES 10,371,388 553,000 7,580,790 73 8,382,105 COMMUNITY DEVELOPMENT 2,427,257 178,204 1,864,907 77 2,627,186 POLICE 27,745,569 2,128,934 22,922,140 83 28,272,128 FIRE MGMT & SUPPORT 14,462,599 1,164,547 11,900,037 82 14,806,150 HEALTH 3,658,702 832,579 2,646,783 72 3,030,175 PUBLIC WORKS 18,048,955 1,320,644 14,192,704 79 18,454,528 PARKS, REC. AND COMMUNITY SERV.10,836,161 743,793 9,198,434 85 12,350,340 91,260,314 7,154,943 73,113,948 80%91,605,914 91,444,681 5,475,345 73,420,702 90,205,523 91,260,314 7,154,943 73,113,948 91,605,914 184,367 (1,679,598)306,754 (1,400,391) Starting Fund Balance 14,983,966 14,983,966 Net Change 174,321 306,754 Ending Fund Balance 15,158,287 15,290,720 Income Statement Through 10/31/15 Summary Listing Organization Fund 100 - GENERAL FUND Property Taxes Other Taxes License Permit Fee Fines and Forfeitures Health Department Charges Parking Charges for Services Parks and Recreation Charges Other Charges for Services Interfund Transfers Intergovernmental Revenue Other Revenue Interest Income Fund 100 - Fund 100 - Expense Total Revenue Total Revenue Total Expense Total Annual MTD YTD % of Prior Year Budget Amount Actual Amount Actual Amount Budget Total Actual 3,227,325 229,825 2,430,524 75 2,715,744 (48,660) 694,140 59,307 585,849 84 660,944 5,262,436 352,170 3,698,617 70 4,412,973 1,280,700 35,144 944,434 74 1,296,314 10,464,601 676,446 7,659,424 1 9,037,314 10,464,601 676,446 7,659,424 1 9,037,314 4,929,138 192,410 2,205,065 45 1,978,168 1,213,609 89,282 813,379 67 429,634 629,856 57,399 323,702 51 417,414 176,400 13,200 7 174,100 (140,642) 5,832,240 140,071 1,026,253 18 2,904,338 1,658,921 120,114 658,750 40 1,898,137 29,482 66,845 227 4,398 1,189,648 99,137 991,374 83 1,188,891 15,659,294 698,413 6,098,567 8,854,437 15,659,294 698,413 6,098,567 8,854,437 10,464,601 676,446 7,659,424 1 9,037,314 15,659,294 698,413 6,098,567 8,854,437 (5,194,693)(21,967)1,560,857 182,877 Starting Fund Balance 12,814,717 12,814,717 Net Change (5,194,693)1,560,857 Ending Fund Balance 7,620,024 14,375,574 Income Statement Through 10/31/15 Summary Listing Organization Organization Description Fund Category Proprietary Funds Fund Type Enterprise Funds Fund 505 - PARKING SYSTEM FUND REVENUE Department 19 - ADMINISTRATIVE SERVICES 7005 PARKING SYSTEM MGT 7015 PARKING LOTS & METERS 7025 CHURCH STREET GARAGE 7036 SHERMAN GARAGE 7037 MAPLE GARAGE Department 19 - ADMINISTRATIVE SERVICES Totals REVENUE TOTALS EXPENSE Department 19 - ADMINISTRATIVE SERVICES 7005 PARKING SYSTEM MGT 7015 PARKING LOTS & METERS 7025 CHURCH STREET GARAGE 7030 PARKING GARAGE BONDS 7035 CHURCH/CHICAGO GARAGE 7036 SHERMAN GARAGE 7037 MAPLE GARAGE 7039 2010B BONDS-PARKING DEBT SERV. 7050 TRANSFERS Fund 505 - PARKING SYSTEM FUND Net Gain (Loss) Department 19 - ADMINISTRATIVE SERVICES Totals EXPENSE TOTALS Fund 505 - PARKING SYSTEM FUND Totals REVENUE TOTALS EXPENSE TOTALS Annual MTD YTD % of Prior Year Budget Amount Actual Amount Actual Amount Budget Total Actual 28,014,100 1,128,055 12,911,135 46 15,054,698 +++350 45,000 30,878 69 +++5,672 +++8,508 411 1,366 +++56 28,059,100 1,128,466 12,943,379 46%15,069,284 28,059,100 1,128,466 12,943,379 46%15,069,284 1,059,638 96,006 756,483 71 3,502,605 2,426,701 216,455 1,737,583 72 2,023,601 2,612,781 186,014 1,598,696 61 2,331,616 1,724,142 132,399 1,264,024 73 1,444,158 194,336 12,522 158,262 81 280,083 527,500 11,882 166,506 32 204,980 419,000 5,445 120,704 29 72,953 18,402,600 217,056 1 12,430 67,505 33,752 67,505 100 92,168 6,238 7 13,750 240,920 51,105 21 102,909 300,694 62,847 21 121,718 149,171 37,086 25 91,461 3,662,545 305,212 3,052,122 83 3,838,052 5,500,000 +++5,500,000 195,941 76,660 39 45,218 32,075,642 999,686 14,872,877 46%19,585,533 32,075,642 999,686 14,872,877 46%19,585,533 28,059,100 1,128,466 12,943,379 46%15,069,284 32,075,642 999,686 14,872,877 46%19,585,533 (4,016,542)128,779 (1,929,498)48%(4,516,249) Starting Fund Balance 7,454,107 7,454,107 Net Change 32,075,642 (1,929,498) Ending Fund Balance 39,529,749 5,524,609 Income Statement Through 10/31/15 Summary Listing Organization Organization Description Fund Category Proprietary Funds Fund Type Enterprise Funds Fund 510 - WATER FUND REVENUE Department 71 - UTILITIES 7100 WATER GENERAL SUPPORT 7105 PUMPING 7110 FILTRATION 7130 WATER CAPITAL OUTLAY 7131 CAPITAL IMPROVEMENTS 7300 WATER BOND AND INTEREST Department 71 - UTILITIES Totals REVENUE TOTALS EXPENSE Department 71 - UTILITIES 7100 WATER GENERAL SUPPORT 7105 PUMPING 7110 FILTRATION 7115 DISTRIBUTION 7120 WATER METER MAINTENANCE 7125 OTHER OPERATIONS 7130 WATER CAPITAL OUTLAY 7131 CAPITAL IMPROVEMENTS 7133 ARRA / IEPA LOAN DS (L173382) 7140 2010B BONDS 7145 2011A BONDS EXPENSE TOTALS 7150 2012A BONDS 7151 2013A BONDS 7160 INTERFUND TRANSFERS Fund 510 - WATER FUND Totals REVENUE TOTALS EXPENSE TOTALS Fund 510 - WATER FUND Net Gain (Loss) 7165 TRANSFER TO DEP.,IMP.,EXT 7509 2014A BONDS Department 71 - UTILITIES Totals Annual MTD YTD % of Prior Year Budget Amount Actual Amount Actual Amount Budget Total Actual 13,077,865 1,329,565 10,836,890 83 12,770,136 42,831 239,309 +++18,150 13,077,865 1,372,396 11,076,199 85%12,788,286 13,077,865 1,372,396 11,076,199 85%12,788,286 1,779,750 239,446 1,342,627 75 5,113,395 103,300 26,406 26 23,879 818,608 68,217 682,173 83 622,316 13,500 11,249 83 2,821 1,055,000 44,902 1,009,676 96 208,204 +++(3,424) 80,000 40,028 50 11,000 0 24,551 1,662 7 3,663 49,772 10,558 21 21,260 IEPA 9,009,468 266,839 7,336,489 .81 1,563,329 254,850 22,425 9 53,520 +++(56,824) 189,836 44,938 24 93,211 13,389,635 619,405 10,528,231 79%7,645,350 13,389,635 619,405 10,528,231 79%7,645,350 13,077,865 1,372,396 11,076,199 85%12,788,286 13,389,635 619,405 10,528,231 79%7,645,350 (311,770)752,991 547,968 (176%)5,142,936 Starting Fund Balance 4,405,937 4,405,937 Net Change (311,770) 547,968 Ending Fund Balance 4,094,167 4,953,905 Income Statement Through 10/31/15 Summary Listing Organization Organization Description Fund Category Proprietary Funds Fund Type Enterprise Funds Fund 515 - SEWER FUND REVENUE Department 71 - UTILITIES 7400 SEWER MAINTENANCE 7420 SEWER IMPROVEMENTS Department 71 - UTILITIES Totals REVENUE TOTALS EXPENSE Department 71 - UTILITIES 7400 SEWER MAINTENANCE 7410 SEWER OTHER OPERATIONS 7411 INTERFUND TRANSFERS 7415 CAPITAL OUTLAY 7420 SEWER IMPROVEMENTS 7425 LONG RANGE SEWER IMPROVE 7477 IEPA (L 174775) 7478 IEPA (L 17-5240) 7511 2010B BONDS 7512 2011 A BONDS- SEWER DEBT SERV. 7525 7590 2007 BONDS (1997)SEWER1 7596 2008 GO BONDS-SEWER 7597 2008C GO BONDS DEBT SERVICE REVENUE TOTALS EXPENSE TOTALS Fund 515 - SEWER FUND Net Gain (Loss) Department 71 - UTILITIES Totals EXPENSE TOTALS Fund 515 - SEWER FUND Totals Annual MTD YTD % of Prior Year Budget Amount Actual Amount Actual Amount Budget Total Actual 4,683,361 381,929 3,833,344 82 4,649,654 179,000 6,930 310,619 174 140,559 220,000 2,890 37,029 17 236,967 5,082,361 391,750 4,180,992 82%5,027,180 5,082,361 391,750 4,180,992 82%5,027,180 1,321 +++2,912 3,209,621 193,134 2,386,460 74 2,876,007 1,281,949 101,072 1,082,543 84 1,210,051 700,250 76,630 526,997 75 676,135 5,191,820 370,835 3,997,322 77%4,765,105 0 0 0 +++502 0 0 0 +++90,089 0 0 0 +++90,591 5,191,820 370,835 3,997,322 77%4,855,696 5,082,361 391,750 4,180,992 82%5,027,180 5,191,820 370,835 3,997,322 77%4,855,696 (109,459)20,914 183,670 (168%)171,484 Starting Fund Balance (1,112,075) (1,112,075) Net Change (109,459) 183,670 Ending Fund Balance (1,221,534) (928,405) Income Statement Through 10/31/15 Summary Listing Organization Organization Description Fund Category Proprietary Funds Fund Type Enterprise Funds Fund 520 - SOLID WASTE FUND REVENUE Department 26 - PUBLIC WORKS 7685 REFUSE COLLECT & DISPOSAL 7690 RESIDENTIAL RECYCLING COL 7695 YARD WASTE COLLECTION Department 26 - PUBLIC WORKS Totals REVENUE TOTALS EXPENSE Department 26 - PUBLIC WORKS 7651 GENRAL SUPPORT 7685 REFUSE COLLECT & DISPOSAL 7690 RESIDENTIAL RECYCLING COL 7695 YARD WASTE COLLECTION Department 26 - PUBLIC WORKS Totals Department 71 - UTILITIES 7685 REFUSE COLLECT & DISPOSAL 7690 RESIDENTIAL RECYCLING COL Department 71 - UTILITIES Totals EXPENSE TOTALS Fund 520 - SOLID WASTE FUND Totals REVENUE TOTALS EXPENSE TOTALS Fund 520 - SOLID WASTE FUND Net Gain (Loss) Oct 2015 YTD 2014 Transactions Transactions Actual 11,637,118 20,045 11,321,381 11,547,828 43,689,300 3,857,383 36,301,788 42,686,089 13,897,159 755,357 9,132,752 14,880,600 4,495,774 336,341 2,942,230 3,357,965 7,747,394 300,247 6,374,363 7,934,572 7,892,893 686,402 6,418,533 7,794,625 723,700 (455,921)361,611 627,970 1,311,343 (25,123)563,041 1,362,838 50,000 614 5,002 13,037 91,444,681 5,475,345 73,420,702 90,205,523 68,404,181 5,159,672 55,162,321 69,079,362 11,407,830 1,063,027 8,812,284 11,645,408 185,600 9,248 88,343 204,704 3,019,098 251,646 2,518,413 2,949,778 966,029 618,317 759,535 677,669 212,967 30,433 57,117 1,661,041 202,244 1,335,852 1,685,166 5,478,568 (149,211)4,406,766 5,306,709 91,335,314 7,154,943 73,113,948 91,605,914 91,444,681 5,475,345 90,205,523 91,335,314 7,154,943 73,113,948 91,605,914 109,367 (1,679,598) 306,754 (1,400,391) Starting Fund Balance 14,983,966 14,983,966 Net Change 109,367 306,754 Ending Fund Balance 15,093,333 15,290,720 REVENUE TOTALS EXPENSE TOTALS Fund 100 - GENERAL FUND Totals Interfund Transfers EXPENSE TOTALS Fund 100 - GENERAL FUND Totals Contingencies Debt Service Miscellaneous Insurance and Other Chargebacks Community Sponsored Organizations Depreciation Expense EXPENSE Salary and Benefits Services and Supplies Capital Outlay Special Assessment Reappropriation of Surplus REVENUE TOTALS Insurance Library Revenue Interest Income Intergovernmental Revenue Other Revenue Workers Compensation and Liability Fines and Forfeitures Charges for Services Interfund Transfers REVENUE Property Taxes Other Taxes Licenses, Permits and Fees Budget by Organization Report Through 10/31/15 Prior Fiscal Year Activity Included Classification Fund 100 - GENERAL FUND 2015 Budget Run by Ashley King on 12/01/2015 09:21:01 AM Page 1 of 48 Oct 2015 YTD 2014 Transactions Transactions Actual 1,348,553 1,313,420 1,762,916 3,208 1,992 25,000 2,974 17,269 491,066 1,000 8 44 88 1,374,553 2,982 1,333,940 2,256,061 215,319 16,633 139,962 146,369 1,155,050 39,349 508,377 694,669 105,445 163 4,585 1,308 1,370,369 56,146 652,924 947,791 1,374,553 2,982 1,333,940 2,256,061 1,370,369 56,146 652,924 947,791 4,184 (53,164) 681,016 1,308,270 Starting Fund Balance 183,099 183,099 Net Change 1,370,369 681,016 Ending Fund Balance 1,553,468 864,115 REVENUE TOTALS EXPENSE TOTALS Fund 175 - GENERAL ASSISTANCE Interfund Transfers EXPENSE TOTALS Fund 175 - GENERAL ASSISTANCE Contingencies Debt Service Miscellaneous Insurance and Other Chargebacks Community Sponsored Organizations Depreciation Expense EXPENSE Salary and Benefits Services and Supplies Capital Outlay Special Assessment Reappropriation of Surplus REVENUE TOTALS Insurance Library Revenue Interest Income Intergovernmental Revenue Other Revenue Workers Compensation and Liability Fines and Forfeitures Charges for Services Interfund Transfers REVENUE Property Taxes Other Taxes Licenses, Permits and Fees Budget by Organization Report Through 10/31/15 Prior Fiscal Year Activity Included Classification Fund 175 - GENERAL ASSISTANCE FUND 2015 Budget Run by Ashley King on 12/01/2015 09:21:01 AM Page 2 of 48 Oct 2015 YTD 2014 Transactions Transactions Actual 884,794 73,733 737,328 884,794 73,733 737,328 859,153 631,847 859,153 631,847 884,794 73,733 737,328 859,153 631,847 25,641 73,733 105,482 Starting Fund Balance 0 - Net Change 25,641 105,482 Ending Fund Balance 25,641 105,482 Fund 176 - HEALTH AND HUMAN 2015 Budget Fund 176 - HEALTH AND HUMAN REVENUE TOTALS EXPENSE TOTALS Community Sponsored Organizations Miscellaneous EXPENSE TOTALS REVENUE TOTALS EXPENSE Services and Supplies Capital Outlay REVENUE Charges for Services Interfund Transfers Intergovernmental Revenue Budget by Organization Report Through 10/31/15 Prior Fiscal Year Activity Included Classification Fund 176 - HEALTH AND HUMAN SERVICES Run by Ashley King on 12/01/2015 09:21:01 AM Page 3 of 48 Oct 2015 YTD 2014 Transactions Transactions Actual 5,813,505 19,698 5,847,914 5,205,279 50,200 50,200 156,000 14,710 165,260 157,637 8,245 88,175 94,962 171,000 171,000 199,315 94,177 93,108 93,108 97,108 (1,028)361 22,662 346,810 7,906 133,057 255,774 501 1,998 2,869 6,631,692 143,139 6,500,872 6,085,806 4,710,919 340,588 3,472,217 4,130,680 1,542,994 109,030 1,101,042 1,262,675 46,430 34,214 69,995 77,268 6,439 64,390 114,597 250,000 20,664 208,333 210,000 4,081 350 3,500 4,081 6,631,692 477,072 4,883,697 5,792,028 6,631,692 143,139 6,500,872 6,085,806 6,631,692 477,072 4,883,697 5,792,028 (333,933) 1,617,176 293,777 Starting Fund Balance 1,378,970 1,378,970 Net Change - 1,617,176 Ending Fund Balance 1,378,970 2,996,146 REVENUE TOTALS EXPENSE TOTALS Fund 185 - LIBRARY FUND Totals Interfund Transfers EXPENSE TOTALS Fund 185 - LIBRARY FUND Totals Contingencies Debt Service Miscellaneous Capital Outlay Insurance and Other Chargebacks Depreciation Expense REVENUE TOTALS EXPENSE Salary and Benefits Services and Supplies Other Revenue Library Revenue Interest Income Charges for Services Interfund Transfers Intergovernmental Revenue REVENUE Property Taxes Other Taxes Fines and Forfeitures Budget by Organization Report Through 10/31/15 Prior Fiscal Year Activity Included Classification Fund 185 - LIBRARY FUND 2015 Budget Run by Ashley King on 12/01/2015 09:21:01 AM Page 4 of 48 Oct 2015 YTD 2014 Transactions Transactions Actual 605,138 884 598,014 746,112 1,000 606,138 884 598,014 746,112 14,550 5,009 71,940 605,138 40,402 748,521 605,138 5,009 126,892 748,521 606,138 884 598,014 746,112 605,138 5,009 126,892 748,521 1,000 (4,125) 471,122 (2,409) Starting Fund Balance 93,595 93,595 - Net Change 1,000 471,122 Ending Fund Balance 94,595 564,717 REVENUE TOTALS EXPENSE TOTALS Fund 186 - LIBRARY DEBT SERVICE Miscellaneous EXPENSE TOTALS Fund 186 - LIBRARY DEBT SERVICE EXPENSE Services and Supplies Capital Outlay Debt Service REVENUE Property Taxes Interest Income REVENUE TOTALS Budget by Organization Report Through 10/31/15 Prior Fiscal Year Activity Included Classification Fund 186 - LIBRARY DEBT SERVICE FUND 2015 Budget Run by Ashley King on 12/01/2015 09:21:01 AM Page 5 of 48 Oct 2015 YTD 2014 Transactions Transactions Actual 59,687 1,107,077 500,000 135,461 42,412 26 #VALUE! 500,000 26 195,307 1,149,489 53,661 3,723 50,087 90,126 3,250 4,377 4,265 155,000 60,539 660,448 4,191 349 3,493 7,951 159,994 180 339,920 7,500 128 1,283 46,779 383,596 4,201 119,958 1,149,489 500,000 26 195,307 1,149,489 383,596 4,201 119,958 1,149,489 116,404 (4,175) 75,349 Starting Fund Balance - - Net Change 116,404 75,349 Ending Fund Balance 116,404 75,349 EXPENSE TOTALS Fund 195 - NEIGHBORHOOD 2015 Budget EXPENSE TOTALS Fund 195 - NEIGHBORHOOD REVENUE TOTALS Debt Service Miscellaneous Interfund Transfers Services and Supplies Capital Outlay Insurance and Other Chargebacks Interest Income REVENUE TOTALS EXPENSE Salary and Benefits REVENUE Licenses, Permits and Fees Intergovernmental Revenue Other Revenue Budget by Organization Report Through 10/31/15 Prior Fiscal Year Activity Included Classification Fund 195 - NEIGHBORHOOD STABILIZATION FUND Run by Ashley King on 12/01/2015 09:21:01 AM Page 6 of 48 Oct 2015 YTD 2014 Transactions Transactions Actual 322,396 1,750,000 1,007,793 1,871,619 1,000 67 620 277 1,751,000 67 1,008,413 2,194,292 1,700,000 200,000 1,328,624 893,829 833,000 69,417 694,167 833,000 2,533,000 269,417 2,022,790 1,726,829 1,751,000 67 1,008,413 2,194,292 2,533,000 269,417 2,022,790 1,726,829 (782,000) (269,350) (1,014,378) 467,463 Starting Fund Balance 1,780,031 1,780,031 Net Change (782,000) (1,014,378) Ending Fund Balance 998,031 765,653 EXPENSE TOTALS Fund 200 - MOTOR FUEL TAX FUND 2015 Budget EXPENSE TOTALS Fund 200 - MOTOR FUEL TAX FUND REVENUE TOTALS Debt Service Miscellaneous Interfund Transfers EXPENSE Services and Supplies Capital Outlay Contingencies Interest Income Reappropriation of Surplus REVENUE TOTALS REVENUE Charges for Services Intergovernmental Revenue Other Revenue Budget by Organization Report Through 10/31/15 Prior Fiscal Year Activity Included Classification Fund 200 - MOTOR FUEL TAX FUND Run by Ashley King on 12/01/2015 09:21:01 AM Page 7 of 48 Oct 2015 YTD 2014 Transactions Transactions Actual 1,038,239 57,878 766,082 939,451 100 1,751 1,000 9 187 99 1,039,239 57,888 766,369 941,302 559,058 46,528 461,275 512,750 653,661 44,910 299,998 346,506 40,000 (4,552)238,052 12,038 1,003 10,032 11,622 5,000 2,046 2,046 1,500 147,177 12,265 122,648 143,398 1,416,934 106,752 891,446 1,253,827 1,039,239 57,888 766,369 941,302 1,416,934 106,752 891,446 1,253,827 (377,695) (48,864) (125,077) (312,526) Starting Fund Balance 908,353 908,353 Net Change (136,734) (125,077) Ending Fund Balance 771,619 783,276 Fund 205 - EMERGENCY TELEPHONE 2015 Budget Fund 205 - EMERGENCY TELEPHONE REVENUE TOTALS EXPENSE TOTALS Miscellaneous Interfund Transfers EXPENSE TOTALS Community Sponsored Organizations Contingencies Debt Service Services and Supplies Capital Outlay Insurance and Other Chargebacks Interest Income REVENUE TOTALS EXPENSE Salary and Benefits REVENUE Licenses, Permits and Fees Charges for Services Other Revenue Budget by Organization Report Through 10/31/15 Prior Fiscal Year Activity Included Classification Fund 205 - EMERGENCY TELEPHONE (E911) FUND Run by Ashley King on 12/01/2015 09:21:01 AM Page 8 of 48 Oct 2015 YTD 2014 Transactions Transactions Actual 320,000 322,055 310,595 3 4 320,000 322,058 310,599 320,000 80,750 242,250 320,000 320,000 80,750 242,250 320,000 320,000 322,058 310,599 320,000 80,750 242,250 320,000 (80,750) 79,808 (9,401) Starting Fund Balance 145,200 145,200 Net Change - 79,808 Ending Fund Balance 145,200 225,008 EXPENSE TOTALS Fund 210 - SPECIAL SERVICE AREA 2015 Budget EXPENSE TOTALS Fund 210 - SPECIAL SERVICE AREA REVENUE TOTALS EXPENSE Services and Supplies Debt Service Miscellaneous REVENUE Property Taxes Interest Income REVENUE TOTALS Budget by Organization Report Through 10/31/15 Prior Fiscal Year Activity Included Classification Fund 210 - SPECIAL SERVICE AREA (SSA) #4 Run by Ashley King on 12/01/2015 09:21:01 AM Page 9 of 48 Oct 2015 YTD 2014 Transactions Transactions Actual 1,400,000 251,832 1,114,447 590,111 3,042 13,196 1,990,111 251,832 1,117,489 13,196 430,821 29,294 285,995 268,181 21,823 124 26,246 70,199 827,211 56,947 188,836 6,227 519 5,189 3,035 281,500 80,250 216,528 210,737 55,500 52,561 63,399 74,660 367,029 30,343 303,434 596,849 1,990,111 193,091 957,739 1,412,496 1,990,111 251,832 1,117,489 13,196 1,990,111 193,091 957,739 1,412,496 58,741 159,750 (1,399,300) Starting Fund Balance 184,902 184,902 Net Change - 159,750 Ending Fund Balance 184,902 344,652 EXPENSE TOTALS Fund 215 - CDBG FUND Totals 2015 Budget EXPENSE TOTALS Fund 215 - CDBG FUND Totals REVENUE TOTALS Debt Service Miscellaneous Interfund Transfers Insurance and Other Chargebacks Community Sponsored Organizations Contingencies EXPENSE Salary and Benefits Services and Supplies Capital Outlay Other Revenue Interest Income REVENUE TOTALS REVENUE Charges for Services Interfund Transfers Intergovernmental Revenue Budget by Organization Report Through 10/31/15 Prior Fiscal Year Activity Included Classification Fund 215 - CDBG FUND Run by Ashley King on 12/01/2015 09:21:01 AM Page 10 of 48 Oct 2015 YTD 2014 Transactions Transactions Actual 237,000 (5,873) 9,643 163,816 45,376 100 39 250 237,100 9,682 164,065 39,503 237,100 23,819 27,230 39,503 171 3,843 237,100 23,989 31,072 39,503 237,100 9,682 164,065 39,503 237,100 23,989 31,072 39,503 (14,308) 132,993 Starting Fund Balance 2,350,661 2,350,661 Net Change - 132,993 Ending Fund Balance 2,350,661 2,483,654 Fund 220 - CDBG LOAN Totals 2015 Budget Fund 220 - CDBG LOAN Totals REVENUE TOTALS EXPENSE TOTALS Miscellaneous Interfund Transfers EXPENSE TOTALS REVENUE TOTALS EXPENSE Salary and Benefits Services and Supplies REVENUE Intergovernmental Revenue Other Revenue Interest Income Budget by Organization Report Through 10/31/15 Prior Fiscal Year Activity Included Classification Fund 220 - CDBG LOAN Run by Ashley King on 12/01/2015 09:21:01 AM Page 11 of 48 Oct 2015 YTD 2014 Transactions Transactions Actual 1,800,000 561,876 2,044,419 1,913,372 47,500 65,500 3,958 41,083 45,500 3,700 6 113 2,831 1,916,700 565,840 2,085,616 1,961,703 672,310 51,373 482,198 558,123 912,200 29,612 247,996 738,622 253,500 1,500 158,960 94,978 14,782 1,232 12,318 14,271 181 916,000 1,292,866 52,105 483,736 51,454 514,540 470,155 3,252,528 135,170 2,708,878 1,928,435 1,916,700 565,840 2,085,616 1,961,703 3,252,528 135,170 2,708,878 1,928,435 (1,335,828) 430,670 (623,263) 33,268 Starting Fund Balance 3,540,471 3,540,471 Net Change (1,335,828) (623,263) Ending Fund Balance 2,204,643 2,917,208 EXPENSE TOTALS Fund 225 - ECONOMIC DEVELOPMENT 2015 Budget EXPENSE TOTALS Fund 225 - ECONOMIC DEVELOPMENT REVENUE TOTALS Debt Service Miscellaneous Interfund Transfers Insurance and Other Chargebacks Community Sponsored Organizations Contingencies EXPENSE Salary and Benefits Services and Supplies Capital Outlay Other Revenue Interest Income REVENUE TOTALS REVENUE Other Taxes Charges for Services Interfund Transfers Budget by Organization Report Through 10/31/15 Prior Fiscal Year Activity Included Classification Fund 225 - ECONOMIC DEVELOPMENT FUND Run by Ashley King on 12/01/2015 09:21:01 AM Page 12 of 48 Oct 2015 YTD 2014 Transactions Transactions Actual 20,000 20,000 20,000 20,000 50,000 50,000 20,000 20,000 50,000 (30,000)20,000 Starting Fund Balance 169,915 169,915 Net Change (30,000) - Ending Fund Balance 139,915 169,915 EXPENSE TOTALS Fund 235 - NEIGHBORHOOD 2015 Budget EXPENSE TOTALS Fund 235 - NEIGHBORHOOD REVENUE TOTALS Debt Service Miscellaneous Interfund Transfers REVENUE TOTALS EXPENSE Services and Supplies Capital Outlay REVENUE Other Taxes Interfund Transfers Interest Income Budget by Organization Report Through 10/31/15 Prior Fiscal Year Activity Included Classification Fund 235 - NEIGHBORHOOD IMPROVEMENT Run by Ashley King on 12/01/2015 09:21:01 AM Page 13 of 48 Oct 2015 YTD 2014 Transactions Transactions Actual 216,000 16,540 459,428 225,200 2,282 28,944 27,384 1 14 63 441,200 18,823 488,386 27,447 38,171 12,388 22,164 402,529 16,540 417,330 924,053 146 500 60 620 716 114 1,140 13,143 441,200 16,714 431,478 960,223 441,200 18,823 488,386 27,447 441,200 16,714 431,478 960,223 2,109 56,908 (932,776) Starting Fund Balance 4,580,079 4,580,079 Net Change - 56,908 Ending Fund Balance 4,580,079 4,636,987 EXPENSE TOTALS Fund 240 - HOME FUND Totals 2015 Budget EXPENSE TOTALS Fund 240 - HOME FUND Totals REVENUE TOTALS Debt Service Miscellaneous Interfund Transfers Capital Outlay Insurance and Other Chargebacks Community Sponsored Organizations REVENUE TOTALS EXPENSE Salary and Benefits Services and Supplies REVENUE Intergovernmental Revenue Other Revenue Interest Income Budget by Organization Report Through 10/31/15 Prior Fiscal Year Activity Included Classification Fund 240 - HOME FUND Run by Ashley King on 12/01/2015 09:21:01 AM Page 14 of 48 Oct 2015 YTD 2014 Transactions Transactions Actual 919 353,383 354,302 209,376 209,376 354,302 209,376 144,927 Starting Fund Balance 3,920,732 3,920,732 Net Change - - Ending Fund Balance 3,920,732 3,920,732 REVENUE TOTALS EXPENSE TOTALS Fund 245 - LIBRARY ENDOWMENT Interfund Transfers EXPENSE TOTALS Fund 245 - LIBRARY ENDOWMENT EXPENSE Services and Supplies Capital Outlay Miscellaneous REVENUE Other Revenue Interest Income REVENUE TOTALS Budget by Organization Report Through 10/31/15 Prior Fiscal Year Activity Included Classification Fund 245 - LIBRARY ENDOWMENT FUND 2015 Budget Run by Ashley King on 12/01/2015 09:21:01 AM Page 15 of 48 Oct 2015 YTD 2014 Transactions Transactions Actual 30,000 60,000 30,000 374,772 31,817 131,539 160,525 228 5 105 256 405,000 31,822 191,644 190,781 350,000 98 23,949 55,000 44,298 57,000 13,990 405,000 44,396 94,939 405,000 31,822 191,644 190,781 405,000 44,396 94,939 31,822 147,248 95,842 Starting Fund Balance 2,546,920 2,546,920 Net Change - 147,248 Ending Fund Balance 2,546,920 2,694,168 REVENUE TOTALS EXPENSE TOTALS Fund 250 - AFFORDABLE HOUSING Interfund Transfers EXPENSE TOTALS Fund 250 - AFFORDABLE HOUSING Community Sponsored Organizations Debt Service Miscellaneous EXPENSE Salary and Benefits Services and Supplies Capital Outlay Other Revenue Interest Income REVENUE TOTALS REVENUE Other Taxes Charges for Services Interfund Transfers Budget by Organization Report Through 10/31/15 Prior Fiscal Year Activity Included Classification Fund 250 - AFFORDABLE HOUSING FUND 2015 Budget Run by Ashley King on 12/01/2015 09:21:01 AM Page 16 of 48 Oct 2015 YTD 2014 Transactions Transactions Actual 4,900,000 386 4,921,484 4,969,568 10,000 525 2,196 13,420 4,910,000 911 4,923,680 4,982,987 1,070 36,978 1,800,000 11,644 165,804 246 575,000 14,988 577,280 500,000 24,668 74,003 74,003 3,265,296 272,108 2,721,080 3,256,296 6,140,296 308,420 2,976,944 3,944,802 4,910,000 911 4,923,680 4,982,987 6,140,296 308,420 2,976,944 3,944,802 (1,230,296) (307,509) 1,946,736 1,038,186 Starting Fund Balance 6,186,704 6,186,704 Net Change (1,230,296) 1,946,736 Ending Fund Balance 4,956,408 8,133,440 EXPENSE TOTALS Fund 300 - WASHINGTON NATIONAL 2015 Budget EXPENSE TOTALS Fund 300 - WASHINGTON NATIONAL REVENUE TOTALS Debt Service Miscellaneous Interfund Transfers EXPENSE Salary and Benefits Services and Supplies Capital Outlay Other Revenue Interest Income REVENUE TOTALS REVENUE Property Taxes Other Taxes Interfund Transfers Budget by Organization Report Through 10/31/15 Prior Fiscal Year Activity Included Classification Fund 300 - WASHINGTON NATIONAL TIF FUND Run by Ashley King on 12/01/2015 09:21:01 AM Page 17 of 48 Oct 2015 YTD 2014 Transactions Transactions Actual 425,000 422,527 428,515 300 4 5 425,300 422,531 428,521 425,175 21,075 442,050 425,175 21,075 442,050 425,300 422,531 428,521 425,175 21,075 442,050 125 401,456 (13,529) Starting Fund Balance 464,046 464,046 Net Change 125 401,456 Ending Fund Balance 464,171 865,502 Fund 305 - SPECIAL SERVICE AREA 2015 Budget Fund 305 - SPECIAL SERVICE AREA REVENUE TOTALS EXPENSE TOTALS Debt Service Miscellaneous EXPENSE TOTALS Interest Income REVENUE TOTALS EXPENSE Services and Supplies REVENUE Property Taxes Interfund Transfers Other Revenue Budget by Organization Report Through 10/31/15 Prior Fiscal Year Activity Included Classification Fund 305 - SPECIAL SERVICE AREA (SSA) #5 Run by Ashley King on 12/01/2015 09:21:01 AM Page 18 of 48 Oct 2015 YTD 2014 Transactions Transactions Actual 1,150,000 1,248,231 1,140,311 4,500 166 1,469 13,819 1,154,500 166 1,249,700 1,154,130 1,070 1,003,464 1,000,000 8,434 246 776,153 2,500,000 424,055 1,614,369 217,435 148,010 12,334 123,342 144,400 3,648,010 436,389 1,747,215 2,141,697 1,154,500 166 1,249,700 1,154,130 3,648,010 436,389 1,747,215 2,141,697 (2,493,510) (436,223) (497,514) (987,566) Starting Fund Balance 2,369,483 2,369,483 Net Change (2,493,510) (497,514) Ending Fund Balance (124,027) 1,871,969 EXPENSE TOTALS Fund 310 - HOWARD-HARTREY TIF 2015 Budget EXPENSE TOTALS Fund 310 - HOWARD-HARTREY TIF REVENUE TOTALS Debt Service Miscellaneous Interfund Transfers EXPENSE Services and Supplies Capital Outlay Community Sponsored Organizations REVENUE Property Taxes Interest Income REVENUE TOTALS Budget by Organization Report Through 10/31/15 Prior Fiscal Year Activity Included Classification Fund 310 - HOWARD-HARTREY TIF Run by Ashley King on 12/01/2015 09:21:01 AM Page 19 of 48 Oct 2015 YTD 2014 Transactions Transactions Actual 607,662 6 607,668 861,217 1,978 15,600 893,387 29,500 861,217 893,387 47,077 607,668 861,217 893,387 47,077 (861,217) (893,387) 560,591 Starting Fund Balance 893,665 893,665 Net Change (861,217) (893,387) Ending Fund Balance 32,448 278 Fund 315 - SOUTHWEST TIF FUND 2015 Budget Fund 315 - SOUTHWEST TIF FUND REVENUE TOTALS EXPENSE TOTALS Miscellaneous Interfund Transfers EXPENSE TOTALS EXPENSE Services and Supplies Capital Outlay Debt Service REVENUE Property Taxes Interest Income REVENUE TOTALS Budget by Organization Report Through 10/31/15 Prior Fiscal Year Activity Included Classification Fund 315 - SOUTHWEST TIF FUND Run by Ashley King on 12/01/2015 09:21:01 AM Page 20 of 48 Oct 2015 YTD 2014 Transactions Transactions Actual 10,879,993 16,142 11,038,214 11,237,317 2,743,836 206,928 2,069,284 1,797,563 1,500 1,307 6,058 11,934 13,625,329 224,378 13,113,556 13,046,814 292,320 2,500 9,053 79,120 13,432,509 3,628,784 12,780,039 193,285 13,918,114 2,500 3,637,837 12,859,158 13,625,329 224,378 13,113,556 13,046,814 13,918,114 2,500 3,637,837 12,859,158 (292,785) 221,878 9,475,719 187,656 Starting Fund Balance 3,796,787 3,796,787 Net Change (292,785) 9,475,719 Ending Fund Balance 3,504,002 13,272,506 EXPENSE TOTALS Fund 320 - DEBT SERVICE FUND Totals 2015 Budget EXPENSE TOTALS Fund 320 - DEBT SERVICE FUND Totals REVENUE TOTALS Debt Service Miscellaneous Interfund Transfers Interest Income REVENUE TOTALS EXPENSE Services and Supplies REVENUE Property Taxes Interfund Transfers Other Revenue Budget by Organization Report Through 10/31/15 Prior Fiscal Year Activity Included Classification Fund 320 - DEBT SERVICE FUND Run by Ashley King on 12/01/2015 09:21:01 AM Page 21 of 48 Oct 2015 YTD 2014 Transactions Transactions Actual 545,000 9,791 540,576 444,587 300,500 12,675 65,108 61,932 500 5 1,798 211 846,000 22,471 607,483 506,731 490,000 2,317 586,109 553,958 200,000 (6,380)166,921 600 49 486 2,507 15 107,500 8,958 89,583 105,500 798,100 11,324 669,813 828,885 846,000 22,471 607,483 506,731 798,100 11,324 669,813 828,885 47,900 11,147 (62,330) (322,154) Starting Fund Balance 259,119 259,119 Net Change 47,900 (62,330) Ending Fund Balance 307,019 196,789 REVENUE TOTALS EXPENSE TOTALS Fund 330 - HOWARD-RIDGE TIF FUND Interfund Transfers EXPENSE TOTALS Fund 330 - HOWARD-RIDGE TIF FUND Community Sponsored Organizations Debt Service Miscellaneous REVENUE TOTALS EXPENSE Services and Supplies Capital Outlay REVENUE Property Taxes Other Revenue Interest Income Budget by Organization Report Through 10/31/15 Prior Fiscal Year Activity Included Classification Fund 330 - HOWARD-RIDGE TIF FUND 2015 Budget Run by Ashley King on 12/01/2015 09:21:01 AM Page 22 of 48 Oct 2015 YTD 2014 Transactions Transactions Actual 105,000 100,262 100 19 195 765 105,100 19 195 101,027 1,070 1,978 (1,028)(9,254)246 10,000 599 5,970 14,122 95,000 61,950 60,000 5,000 50,000 60,000 165,000 4,570 47,786 138,295 105,100 19 195 101,027 165,000 4,570 47,786 138,295 (59,900) (4,551) (47,591) (37,269) Starting Fund Balance 500,370 500,370 Net Change (59,900) (47,591) Ending Fund Balance 440,470 452,779 REVENUE TOTALS EXPENSE TOTALS Fund 335 - WEST EVANSTON TIF FUND Interfund Transfers EXPENSE TOTALS Fund 335 - WEST EVANSTON TIF FUND Contingencies Debt Service Miscellaneous REVENUE TOTALS EXPENSE Services and Supplies Capital Outlay REVENUE Property Taxes Other Revenue Interest Income Budget by Organization Report Through 10/31/15 Prior Fiscal Year Activity Included Classification Fund 335 - WEST EVANSTON TIF FUND 2015 Budget Run by Ashley King on 12/01/2015 09:21:01 AM Page 23 of 48 Oct 2015 YTD 2014 Transactions Transactions Actual Starting Fund Balance - - Net Change - - Ending Fund Balance - - Fund 340 - DEMPSTER-DODGE TIF 2015 Budget Fund 340 - DEMPSTER-DODGE TIF REVENUE TOTALS EXPENSE TOTALS EXPENSE Services and Supplies Debt Service EXPENSE TOTALS REVENUE Property Taxes Other Revenue REVENUE TOTALS Budget by Organization Report Through 10/31/15 Prior Fiscal Year Activity Included Classification Fund 340 - DEMPSTER-DODGE TIF FUND Run by Ashley King on 12/01/2015 09:21:01 AM Page 24 of 48 Oct 2015 YTD 2014 Transactions Transactions Actual 2,900,000 2,900,000 2,900,000 2,900,000 2,900,000 2,000,000 2,290,000 2,102 2,102 2,900,000 2,002,102 2,292,102 2,900,000 2,900,000 2,900,000 2,002,102 2,292,102 (2,002,102) 607,898 Starting Fund Balance - - Net Change 607,898 - Ending Fund Balance 607,898 - EXPENSE TOTALS Fund 345 - CHICAGO-MAIN TIF Totals 2015 Budget EXPENSE TOTALS Fund 345 - CHICAGO-MAIN TIF Totals REVENUE TOTALS EXPENSE Services and Supplies Capital Outlay Debt Service REVENUE Property Taxes Other Revenue REVENUE TOTALS Budget by Organization Report Through 10/31/15 Prior Fiscal Year Activity Included Classification Fund 345 - CHICAGO-MAIN TIF Run by Ashley King on 12/01/2015 09:21:01 AM Page 25 of 48 Oct 2015 YTD 2014 Transactions Transactions Actual 1,590 86,437 110,620 400,000 487,563 875,000 936,500 10,198,000 14,946,300 150,000 10,048,514 20,000 219 2,584 20,380 26,039,300 1,809 639,021 11,603,577 4,472 60,000 41,191 398,380 701,494 17,482,150 1,491,546 5,057,517 7,288,509 190,364 980,000 40,833 408,333 1,547,810 18,522,150 1,573,570 5,864,230 9,732,649 26,039,300 1,809 639,021 11,603,577 18,522,150 1,573,570 5,864,230 9,732,649 7,517,150 (1,571,761) (5,225,210) 1,870,927 Starting Fund Balance 8,170,926 8,170,926 Net Change (5,912,500) (5,225,210) Ending Fund Balance 2,258,426 2,945,716 REVENUE TOTALS EXPENSE TOTALS Fund 415 - CAPITAL IMPROVEMENTS Interfund Transfers EXPENSE TOTALS Fund 415 - CAPITAL IMPROVEMENTS Capital Outlay Debt Service Miscellaneous REVENUE TOTALS EXPENSE Salary and Benefits Services and Supplies Intergovernmental Revenue Other Revenue Interest Income REVENUE Licenses, Permits and Fees Charges for Services Interfund Transfers Budget by Organization Report Through 10/31/15 Prior Fiscal Year Activity Included Classification Fund 415 - CAPITAL IMPROVEMENTS FUND 2015 Budget Run by Ashley King on 12/01/2015 09:21:01 AM Page 26 of 48 Oct 2015 YTD 2014 Transactions Transactions Actual 250,000 506,435 51,033 355 21,979 32,271 180,167 495 81,736 137,960 481,200 850 103,715 676,665 95 3,251 501,000 100,620 202,158 53,738 620 3,084 260,698 169,848 761,698 100,620 202,253 230,541 481,200 850 103,715 676,665 761,698 100,620 202,253 230,541 (280,498) (99,770) (98,538) 446,124 Starting Fund Balance 2,518,568 2,518,568 Net Change (280,498) (98,538) Ending Fund Balance 2,238,070 2,420,030 REVENUE TOTALS EXPENSE TOTALS Fund 420 - SPECIAL ASSESSMENT Interfund Transfers EXPENSE TOTALS Fund 420 - SPECIAL ASSESSMENT Insurance and Other Chargebacks Debt Service Miscellaneous EXPENSE Salary and Benefits Services and Supplies Capital Outlay Special Assessment Reappropriation of Surplus REVENUE TOTALS Insurance Library Revenue Interest Income Intergovernmental Revenue Other Revenue Workers Compensation and Liability Fines and Forfeitures Charges for Services Interfund Transfers REVENUE Property Taxes Other Taxes Licenses, Permits and Fees Budget by Organization Report Through 10/31/15 Prior Fiscal Year Activity Included Classification Fund 420 - SPECIAL ASSESSMENT FUND 2015 Budget Run by Ashley King on 12/01/2015 09:21:01 AM Page 27 of 48 Oct 2015 YTD 2014 Transactions Transactions Actual (36) 150 850 6,602,525 411,589 5,086,811 5,988,594 3,711,770 243,775 2,437,747 2,925,296 115,236 19,339 119,639 90,966 35,070 1,743 15,077 31,645 10,464,601 676,446 7,659,424 9,037,314 1,442,683 101,696 1,004,831 1,358,672 3,318,189 371,457 2,364,695 2,811,302 3,529,850 121,621 1,434,610 (79,159) 1,943,217 2,785,161 12,965 76 2,400 9,686 3,917,652 256,414 727,892 252,000 1,242,738 103,562 1,035,617 1,240,883 15,659,294 698,413 6,098,567 8,854,437 10,464,601 676,446 7,659,424 9,037,314 15,659,294 698,413 6,098,567 8,854,437 (5,194,693) (21,967) 1,560,857 182,877 Starting Fund Balance 12,814,717 12,814,717 Net Change (5,194,693) 1,560,857 Ending Fund Balance 7,620,024 14,375,574 Fund 505 - PARKING SYSTEM FUND 2015 Budget Fund 505 - PARKING SYSTEM FUND REVENUE TOTALS EXPENSE TOTALS Miscellaneous Interfund Transfers EXPENSE TOTALS Depreciation Expense Contingencies Debt Service Capital Outlay Insurance and Other Chargebacks Community Sponsored Organizations REVENUE TOTALS EXPENSE Salary and Benefits Services and Supplies Intergovernmental Revenue Other Revenue Interest Income Fines and Forfeitures Charges for Services Interfund Transfers REVENUE Property Taxes Other Taxes Licenses, Permits and Fees Budget by Organization Report Through 10/31/15 Prior Fiscal Year Activity Included Detail Listing Classification Fund 505 - PARKING SYSTEM FUND Run by Ashley King on 12/01/2015 09:21:01 AM Page 28 of 48 Oct 2015 YTD 2014 Transactions Transactions Actual 70,000 7,846 88,552 118,038 15,418,000 1,003,000 12,470,304 14,554,926 50,000 8,760 104,139 84,886 12,511,100 108,376 278,209 293,882 10,000 483 2,174 17,552 28,059,100 1,128,466 12,943,379 15,069,284 5,132,341 395,593 4,005,997 4,767,985 3,339,890 253,543 1,624,331 2,565,308 18,752,100 278,136 12,663 1,569,014 1,000 356 356 756 1,046,399 33,752 301,440 438,227 12,480 489 875 770,057 3,791,432 315,953 8,661,742 9,461,523 32,075,642 999,686 14,872,877 19,585,533 28,059,100 1,128,466 12,943,379 15,069,284 32,075,642 999,686 14,872,877 19,585,533 (4,016,542) 128,779 (1,929,498) (4,516,249) Starting Fund Balance 7,454,107 7,454,107 Net Change 32,075,642 (1,929,498) Ending Fund Balance 39,529,749 5,524,609 EXPENSE TOTALS Fund 510 - WATER FUND Totals 2015 Budget EXPENSE TOTALS Fund 510 - WATER FUND Totals REVENUE TOTALS Debt Service Miscellaneous Interfund Transfers Community Sponsored Organizations Depreciation Expense Contingencies Services and Supplies Capital Outlay Insurance and Other Chargebacks Interest Income REVENUE TOTALS EXPENSE Salary and Benefits Interfund Transfers Intergovernmental Revenue Other Revenue REVENUE Other Taxes Licenses, Permits and Fees Charges for Services Budget by Organization Report Through 10/31/15 Prior Fiscal Year Activity Included Classification Fund 510 - WATER FUND Run by Ashley King on 12/01/2015 09:21:01 AM Page 29 of 48 Oct 2015 YTD 2014 Transactions Transactions Actual 133 898 6,856 133 898 6,856 26,008 26,008 133 898 6,856 26,008 133 898 (19,152) REVENUE TOTALS EXPENSE TOTALS Fund 511 - WATER - BOND AND Miscellaneous EXPENSE TOTALS Fund 511 - WATER - BOND AND REVENUE TOTALS EXPENSE Services and Supplies Debt Service REVENUE Interfund Transfers Other Revenue Interest Income Budget by Organization Report Through 10/31/15 Prior Fiscal Year Activity Included Classification Fund 511 - WATER - BOND AND INTEREST 2015 Budget Run by Ashley King on 12/01/2015 09:21:01 AM Page 30 of 48 Oct 2015 YTD 2014 Transactions Transactions Actual 64 648 661 64 648 661 64 648 661 64 648 661 EXPENSE TOTALS Fund 512 - WATER-BOND RESERVE 2015 Budget EXPENSE TOTALS Fund 512 - WATER-BOND RESERVE REVENUE TOTALS Services and Supplies Miscellaneous Interfund Transfers REVENUE Interest Income REVENUE TOTALS EXPENSE Budget by Organization Report Through 10/31/15 Prior Fiscal Year Activity Included Classification Fund 512 - WATER-BOND RESERVE Run by Ashley King on 12/01/2015 09:21:01 AM Page 31 of 48 Oct 2015 YTD 2014 Transactions Transactions Actual 5,500,000 5,500,000 513,007 14,557 96 413 473 96 6,013,419 5,515,030 29,982 190,300 277,229 1,171,087 6,302,129 1,045,841 1,201,070 6,492,429 1,323,070 96 6,013,419 5,515,030 1,201,070 6,492,429 1,323,070 (1,200,974) (479,010) 4,191,959 REVENUE TOTALS EXPENSE TOTALS Fund 513 - WATER DEPR IMPRV & Interfund Transfers EXPENSE TOTALS Fund 513 - WATER DEPR IMPRV & EXPENSE Services and Supplies Capital Outlay Miscellaneous Other Revenue Interest Income REVENUE TOTALS REVENUE Charges for Services Interfund Transfers Intergovernmental Revenue Budget by Organization Report Through 10/31/15 Prior Fiscal Year Activity Included Classification Fund 513 - WATER DEPR IMPRV & EXTENSION 2015 Budget Run by Ashley King on 12/01/2015 09:21:01 AM Page 32 of 48 Oct 2015 YTD 2014 Transactions Transactions Actual 13,072,700 1,329,350 10,854,688 12,785,065 4,165 42,831 219,659 1,000 215 1,852 3,221 13,077,865 1,372,396 11,076,199 12,788,286 1,121,635 88,127 923,340 1,263,185 1,009,800 152,647 871,048 266,642 628,500 28,023 436,751 212,183 3,367,923 9,619,477 266,839 7,456,100 1,735,371 5,000 3,306 1,005,223 83,769 837,686 800,045 13,389,635 619,405 10,528,231 7,645,350 13,077,865 1,372,396 11,076,199 12,788,286 13,389,635 619,405 10,528,231 7,645,350 (311,770) 752,991 547,968 5,142,936 Starting Fund Balance 4,405,937 4,405,937 Net Change (311,770) 547,968 Ending Fund Balance 4,094,167 4,953,905 Fund 515 - SEWER FUND Totals 2015 Budget Fund 515 - SEWER FUND Totals REVENUE TOTALS EXPENSE TOTALS Miscellaneous Interfund Transfers EXPENSE TOTALS Depreciation Expense Contingencies Debt Service Services and Supplies Capital Outlay Insurance and Other Chargebacks Interest Income REVENUE TOTALS EXPENSE Salary and Benefits REVENUE Charges for Services Interfund Transfers Other Revenue Budget by Organization Report Through 10/31/15 Prior Fiscal Year Activity Included Classification Fund 515 - SEWER FUND Run by Ashley King on 12/01/2015 09:21:01 AM Page 33 of 48 Oct 2015 YTD 2014 Transactions Transactions Actual 175,000 269,350 125,497 3,616,394 300,450 2,971,368 3,590,758 1,055,967 87,997 879,973 1,055,967 235,000 3,303 60,301 254,958 5,082,361 391,750 4,180,992 5,027,180 850,669 62,730 665,334 884,329 3,750,546 264,302 2,899,425 3,435,696 25,000 2,961 11,208 20,309 60,000 12,933 31,274 15,500 490,105 40,842 408,421 475,202 5,191,820 370,835 3,997,322 4,846,811 5,082,361 391,750 4,180,992 5,027,180 5,191,820 370,835 3,997,322 4,846,811 (109,459) 20,914 183,670 180,369 Starting Fund Balance (1,112,075) (1,112,075) Net Change (109,459) 183,670 Ending Fund Balance (1,221,534) (928,405) EXPENSE TOTALS Fund 520 - SOLID WASTE FUND Totals 2015 Budget EXPENSE TOTALS Fund 520 - SOLID WASTE FUND Totals REVENUE TOTALS Debt Service Miscellaneous Interfund Transfers Capital Outlay Insurance and Other Chargebacks Contingencies REVENUE TOTALS EXPENSE Salary and Benefits Services and Supplies Intergovernmental Revenue Other Revenue Interest Income REVENUE Licenses, Permits and Fees Charges for Services Interfund Transfers Budget by Organization Report Through 10/31/15 Prior Fiscal Year Activity Included Classification Fund 520 - SOLID WASTE FUND Run by Ashley King on 12/01/2015 09:21:01 AM Page 34 of 48 Oct 2015 YTD 2014 Transactions Transactions Actual 24,798 3,317,088 273,900 2,741,210 3,130,282 56,781 773 46,933 50,010 1,000 3,399,667 274,672 2,788,143 3,180,292 1,262,046 110,494 978,198 1,278,713 2,256,021 149,093 1,396,796 2,108,163 25,820 2,152 21,516 24,927 357 450 3,544,337 261,739 2,396,510 3,412,159 3,399,667 274,672 2,788,143 3,180,292 3,544,337 261,739 2,396,510 3,412,159 (144,670) 12,934 391,633 (231,867) Starting Fund Balance (120,944) (120,944) Net Change (144,670) 391,633 Ending Fund Balance (265,614) 270,689 REVENUE TOTALS EXPENSE TOTALS Fund 600 - FLEET SERVICES FUND Interfund Transfers EXPENSE TOTALS Fund 600 - FLEET SERVICES FUND Contingencies Debt Service Miscellaneous Capital Outlay Insurance and Other Chargebacks Depreciation Expense REVENUE TOTALS EXPENSE Salary and Benefits Services and Supplies Intergovernmental Revenue Other Revenue Interest Income REVENUE Fines and Forfeitures Charges for Services Interfund Transfers Budget by Organization Report Through 10/31/15 Prior Fiscal Year Activity Included Classification Fund 600 - FLEET SERVICES FUND 2015 Budget Run by Ashley King on 12/01/2015 09:21:01 AM Page 35 of 48 Oct 2015 YTD 2014 Transactions Transactions Actual 1,451,421 120,952 1,209,518 2,524,231 210,217 52,399 53,210 1,661,638 120,952 1,261,917 2,577,440 60,000 2,567 47,276 90,671 1,455,422 150,735 1,255,860 62,978 1,476,384 6,674 1,515,422 153,302 1,303,136 1,636,707 1,661,638 120,952 1,261,917 2,577,440 1,515,422 153,302 1,303,136 1,636,707 146,216 (32,350) (41,219) 940,734 Starting Fund Balance 2,183,786 2,183,786 Net Change 146,216 (41,219) Ending Fund Balance 2,330,002 2,142,567 REVENUE TOTALS EXPENSE TOTALS Fund 601 - EQUIPMENT REPLACEMENT Miscellaneous EXPENSE TOTALS Fund 601 - EQUIPMENT REPLACEMENT EXPENSE Services and Supplies Capital Outlay Depreciation Expense REVENUE Interfund Transfers Other Revenue REVENUE TOTALS Budget by Organization Report Through 10/31/15 Prior Fiscal Year Activity Included Classification Fund 601 - EQUIPMENT REPLACEMENT FUND 2015 Budget Run by Ashley King on 12/01/2015 09:21:01 AM Page 36 of 48 Oct 2015 YTD 2014 Transactions Transactions Actual 162,411 13,534 135,343 162,411 336,911 10,152,079 863,307 8,350,088 10,237,720 1,023,094 85,346 866,071 1,016,359 6,524,424 517,044 4,450,781 6,321,506 1,000 37 105 119 17,863,008 1,479,269 13,802,387 18,075,025 453,768 37,600 386,132 407,401 1,395,248 86,740 1,510,071 2,520,329 7,932 15,360,736 1,122,890 12,287,917 14,787,200 (105,000)6,426 17,209,752 1,247,230 14,079,119 17,729,288 17,863,008 1,479,269 13,802,387 18,075,025 17,209,752 1,247,230 14,079,119 17,729,288 653,256 232,039 (276,732) 345,737 Starting Fund Balance (3,381,927) (3,381,927) Net Change 653,256 (276,732) Ending Fund Balance (2,728,671) (3,658,659) EXPENSE TOTALS Fund 605 - INSURANCE FUND Totals 2015 Budget EXPENSE TOTALS Fund 605 - INSURANCE FUND Totals REVENUE TOTALS Debt Service Miscellaneous Interfund Transfers Community Sponsored Organizations Depreciation Expense Contingencies Services and Supplies Capital Outlay Insurance and Other Chargebacks Interest Income REVENUE TOTALS EXPENSE Salary and Benefits Other Revenue Workers Compensation and Liability Insurance REVENUE Fines and Forfeitures Charges for Services Interfund Transfers Budget by Organization Report Through 10/31/15 Prior Fiscal Year Activity Included Classification Fund 605 - INSURANCE FUND Run by Ashley King on 12/01/2015 09:21:01 AM Page 37 of 48 Oct 2015 YTD 2014 Transactions Transactions Actual 6,061,575 6,154 6,044,514 6,130,815 280,000 280,000 280,000 978,500 72,262 785,545 919,874 850,000 7 (26,919)3,665,995 8,170,075 78,423 7,083,141 10,996,684 7,886,630 686,251 6,743,145 7,971,699 7,886,630 686,251 6,743,145 7,971,699 8,170,075 78,423 7,083,141 10,996,684 7,886,630 686,251 6,743,145 7,971,699 283,445 (607,828) 339,996 3,024,986 Starting Fund Balance 68,241,712 68,241,712 Net Change 283,445 339,996 Ending Fund Balance 68,525,157 68,581,708 Fund 700 - FIRE PENSION FUND Totals 2015 Budget Fund 700 - FIRE PENSION FUND Totals REVENUE TOTALS EXPENSE TOTALS Debt Service Miscellaneous EXPENSE TOTALS EXPENSE Salary and Benefits Services and Supplies Community Sponsored Organizations Other Revenue Interest Income REVENUE TOTALS REVENUE Property Taxes Other Taxes Interfund Transfers Budget by Organization Report Through 10/31/15 Prior Fiscal Year Activity Included Classification Fund 700 - FIRE PENSION FUND Run by Ashley King on 12/01/2015 09:21:01 AM Page 38 of 48 Oct 2015 YTD 2014 Transactions Transactions Actual 8,380,207 9,932 8,346,010 8,476,543 325,000 325,000 325,000 1,500,000 109,711 1,167,614 1,565,053 2,800,000 9 106 9,139,372 13,005,207 119,653 9,838,731 19,505,968 10,542,500 873,300 8,634,036 10,252,264 1,698 10,542,500 873,300 8,634,036 10,253,962 13,005,207 119,653 9,838,731 19,505,968 10,542,500 873,300 8,634,036 10,253,962 2,462,707 (753,648) 1,204,694 9,252,006 Starting Fund Balance 99,687,542 99,687,542 Net Change 2,462,707 1,204,694 Ending Fund Balance 102,150,249 100,892,236 REVENUE TOTALS EXPENSE TOTALS Fund 705 - POLICE PENSION FUND Miscellaneous EXPENSE TOTALS Fund 705 - POLICE PENSION FUND EXPENSE Salary and Benefits Services and Supplies Debt Service Other Revenue Interest Income REVENUE TOTALS REVENUE Property Taxes Other Taxes Interfund Transfers Budget by Organization Report Through 10/31/15 Prior Fiscal Year Activity Included Detail Listing Classification Fund 705 - POLICE PENSION FUND 2015 Budget Run by Ashley King on 12/01/2015 09:21:01 AM Page 39 of 48