The URL can be used to link to this page

Home My WebLink About2018.10 October Monthly Report YTD Revenues YTD Expenses YTD Net Fund Balance Cash Balance 97,780,333 94,770,705 3,009,628 16,225,727 11,463,410 929,623 782,015 147,608 792,107 792,107 713,188 682,027 31,161 20,346 20,345 2,567 833,620 (831,053) (829,169) 170,831 7,197,459 5,552,625 1,644,834 2,687,138 2,629,209 333,896 63,311 270,585 274,674 274,674 2,157,728 1,296,849 860,879 1,169,278 1,169,278 43,494 31,842 11,653 11,653 100,328 1,604,836 2,048,325 (443,489) 1,930,241 1,763,760 1,188,787 743,158 445,630 627,626 317,577 341,959 277,500 64,459 (134,335) (134,336) 720,366 870,204 (149,838) (85,731) (85,732) 97,196 109,899 (12,703) 239,909 239,908 899 132 766 170,937 170,937 203,268 199,680 3,588 12,865 12,865 145,511 183,273 (37,762) 1,438,783 1,443,199 5,742,887 5,561,708 181,179 5,443,723 5,522,643 20,836,742 9,115,589 11,721,153 11,962,934 12,038,803 4,184,600 1,869,886 2,314,713 2,562,091 2,564,361 231,957 42,771 189,186 621,952 630,274 136,937 75,630 61,307 55,298 55,298 222,258 109,087 113,171 174,364 174,364 115,221 - 115,221 117,428 117,428 15,912,459 10,912,481 4,999,978 13,758,451 13,384,517 26,944,199 3,488,818 23,455,381 23,996,242 23,996,242 458,551 792,154 (333,604) 2,664,096 2,660,560 8,784,075 6,246,545 2,537,530 7,248,231 7,168,388 19,736,232 15,909,394 3,826,837 10,389,632 8,104,922 12,685,312 10,315,450 2,369,862 6,407,617 3,776,470 4,204,437 4,065,630 138,806 (923,160) (1,418,269) 2,507,081 2,586,020 (78,939) 262,404 (518,755) 1,155,955 1,045,435 110,520 960,039 960,039 15,116,223 18,477,750 (3,361,528) (7,700,033) (4,889,637) 252,436,233 199,059,514 53,376,719 102,553,357 94,676,007 Fund Fund Description 100 GENERAL FUND 176 HEALTH AND HUMAN SERVICES 175 GENERAL ASSISTANCE FUND 180 GOOD NEIGHBOR FUND 185 LIBRARY FUND 195 NEIGHBORHOOD STABILIZATION 200 MOTOR FUEL TAX FUND 205 EMERGENCY TELEPHONE (E911) 210 SPECIAL SERVICE AREA (SSA) #4 215 CDBG FUND 220 CDBG LOAN FUND 235 NEIGHBORHOOD IMPROVEMENT 240 HOME FUND 186 LIBRARY DEBT SERVICE FUND 250 AFFORDABLE HOUSING FUND 300 WASHINGTON NATIONAL TIF 330 HOWARD-RIDGE TIF FUND 335 WEST EVANSTON TIF FUND 340 DEMPSTER-DODGE TIF FUND 345 CHICAGO-MAIN TIF 350 SPECIAL SERVICE AREA (SSA) #6 187 LIBRARY CAPITAL 320 DEBT SERVICE FUND 415 CAPITAL IMPROVEMENTS FUND 416 CROWN CONSTRUCTION FUND 420 SPECIAL ASSESSMENT FUND 505 PARKING SYSTEM FUND 510 WATER FUND 515 SEWER FUND 520 SOLID WASTE FUND 600 FLEET SERVICES FUND 601 EQUIPMENT REPLACEMENT FUND 605 INSURANCE FUND To: Wally Bobkiewicz, City Manager From: Hitesh Desai, CFO/City Treasurer Kate Lewis-Lakin, Senior Management Analyst Subject: October 2018 Monthly Financial Report Date: November 19, 2018 Please find attached the unaudited financial statements as of October 31, 2018. A summary by fund for revenues, expenditures, fund and cash balances is as follows: Memorandum Included above are the ending balances as of October 31, 2018 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 can 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, 2018, the General Fund is reporting a net surplus of $3,009,628 The fund balance in the General Fund is $16,225,727 with a cash balance of $11,463,410. The attached financials show the General Fund Revenues at 85.1% of budget and expenses at 83.0%. Fund and cash balances had increased during summer primarily because of the receipt of the second installment of property taxes. To date, the General Fund has received 97.3% of property tax revenue for the year. Through October 31, 2018, the Good Neighbor Fund is showing a negative fund balance of $829,169. This is because the revenue to this fund from Northwestern University is not received until later in the year. Transfers to other funds from the Good Neighbor Fund are made monthly to cover expenses throughout the year on designated projects. Through October 31, 2018, the SSA #4 Fund is showing a negative fund and cash balance of $134,335. Through October 31, 2018, the CDBG Fund is showing a negative fund and cash balance of $85,731. This is due to a delay in reimbursements and will be recovered in draw downs during November. Through October 31, 2018, the Capital Fund is showing a fund balance of $13,758,451 and a cash balance of $13,384,517. The fund continues to spend down balances from the 2017A General Obligation Bonds that were received in October 2017. Proceeds from the 2018B General Obligation Bonds were received in August, increasing fund and cash balances. Through October 31, 2018, the Crown Construction fund is showing a fund and cash balance of $23,996,242. Proceeds from the 2018A General Obligation Bonds were received in August, increasing fund and cash balances. Through October 31, 2018, the enterprise funds (Parking, Water, and Sewer) continue to spend down fund balance for capital projects. Through October 31, 2018, the Water Fund appears low on revenue and expenses. This is because the clearwell treated water storage project that was budgeted in 2018 was delayed to 2019. This delay causes Capital Outlay and Other Revenue (IEPA loan proceeds) to appear far below budget in the Water Fund. This project is budgeted again in 2019. As seen in the Water Fund, Evanston bills the Village of Skokie at a rate of $2.06 per 1,000 gallons. Skokie is currently paying $0.78 per 1,000 gallons. This issue is being challenged in court. Through October 31, 2018, the Solid Waste Fund has a negative fund balance of $923,160 and a negative cash balance of $1,418,269. The Solid Waste Fund is receiving property tax revenue for the first time in 2018, and has received $410,000 in Property Taxes to date. Through October 31, 2018, the Insurance Fund is showing a negative fund balance of $7,700,033 and a negative cash balance of $4,889,637. Fund balance is lower than cash balance due to accrued liabilities for pending litigation. If there are any questions on the attached report, please contact me by phone at (847) 448-8082 or by email: hdesai@cityofevanston.org. Detailed fund summary reports can be found at: 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, Hitesh Desai, Treasurer of the City of Evanston, hereby affirm that I have reviewed the October 31, 2018 year-to-date financial information and reports which to the best of my knowledge appear accurate and complete. January February March April May June July August September October 2017 Unreserved Fund Balance 15,453,984$ 17,244,431$ 19,450,955$ 18,292,843$ 17,839,404$ 14,612,957$ 13,603,487$ 16,910,096$ 14,723,355$ 14,354,436$ 2018 Unreserved Fund Balance 16,512,558$ 15,306,742$ 17,933,253$ 17,384,626$ 18,479,429$ 15,488,721$ 17,279,434$ 18,345,522$ 16,923,253$ 16,225,727$ 2017 Cash Balance 6,338,271$ 6,393,110$ 11,561,044$ 10,901,398$ 10,376,936$ 6,169,276$ 7,179,518$ 10,652,102$ 8,595,629$ 8,439,222$ 2018 Cash Balance 8,905,448$ 8,120,225$ 12,288,418$ 11,184,339$ 12,226,888$ 9,006,016$ 10,816,697$ 12,252,460$ 10,763,842$ 11,463,410$ 2017 v 2018 Fund and Cash Balance-- General Fund $- $5,000,000 $10,000,000 $15,000,000 $20,000,000 $25,000,000 2017 Unreserved Fund Balance 2018 Unreserved Fund Balance 2017 Cash Balance 2018 Cash Balance October YTD 2017 2018 2018 %Actual 28,849,196 174,504 28,057,406 97.3% 28,294,363 49,742,274 4,030,586 40,943,511 82.3% 46,951,377 12,397,400 479,502 8,155,815 65.8% 13,357,911 3,882,500 379,800 3,171,165 81.7% 3,467,694 10,077,550 555,337 8,662,941 86.0% 8,754,025 7,748,417 618,143 6,181,427 79.8% 11,586,943 793,100 132,392 1,135,295 143.1% 1,234,749 1,300,217 176,159 1,402,373 107.9% 1,858,106 50,100 15,162 70,401 140.5% 38,544 114,840,754 6,561,584 97,780,333 85.1% 115,543,711 CITY COUNCIL 492,806 40,940 443,066 89.9% 498,172 CITY CLERK 191,784 16,707 172,436 89.9% 251,193 CITY MANAGER'S OFFICE 7,540,597 319,413 5,526,691 73.3% 7,539,496 LAW 736,346 38,808 525,264 71.3% 772,045 ADMINISTRATIVE SERVICES 9,075,303 774,067 7,239,014 79.8% 9,314,164 COMMUNITY DEVELOPMENT 3,614,774 284,272 2,701,780 74.7% 2,592,984 POLICE 38,391,099 2,198,798 32,876,360 85.6% 39,067,047 FIRE MGMT & SUPPORT 23,934,390 1,400,630 21,415,158 89.5% 24,355,551 HEALTH 3,697,529 242,045 2,566,005 69.4% 3,071,334 PARKS, REC. AND COMMUNITY SERV. 11,955,812 864,889 10,595,129 88.6% 12,479,438 PUBLIC WORKS AGENCY 14,607,356 1,078,542 10,709,802 73.3% 13,983,314 EXPENSE TOTALS 114,237,796 7,259,111 94,770,705 83.0% 113,924,739 114,840,754 6,561,584 97,780,333 85.1% 115,543,711 114,237,796 7,259,111 94,770,705 83.0% 113,924,739 602,958 (697,526) 3,009,628 1,618,972 Starting Fund Balance 13,216,099 13,216,099 Net Change 602,958 3,009,628 Ending Fund Balance 13,819,057 16,225,727 EXPENSE TOTALS Fund 100 - GENERAL FUND Totals Fund 100 - GENERAL FUND Totals REVENUE TOTALS REVENUE TOTALS EXPENSE 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/18 Prior Fiscal Year Activity Included 2018 Classification Budget Fund 100 - GENERAL FUND October YTD 2017 2018 2018 %Actual 150 2,398 0.0% 1,900 656,804 5,380,980 80.6% 6,303,624 (87,576) 3,037,704 72.0% 4,120,636 - - 0.0% - 14,129 278,451 144.0% 253,523 12,543 84,542 241.1% 62,067 596,050 8,784,075 78.9% 10,741,750 139,533 1,404,875 76.0% 1,675,404 237,804 2,967,392 86.0% 3,172,070 - 200,976 8.2% 280,311 26,637 266,373 83.3% 319,648 - - 0.0% 2,561,771 - - 0.0% 4,246 - 53,131 1.7% 267,734 43,840 153,449 50.5% 267,436 120,035 1,200,348 83.3% 1,584,683 567,849 6,246,545 48.4% 10,133,302 596,050 8,784,075 78.9% 10,741,750 567,849 6,246,545 48.4% 10,133,302 28,201 2,537,530 608,448 Starting Fund Balance 4,710,701 4,710,701 Net Change (1,762,367) 2,537,530 Ending Fund Balance 2,948,334 7,248,231 Budget by Organization Report Through 10/31/18 Prior Fiscal Year Activity Included 2018 Classification Budget Fund 505 - PARKING SYSTEM FUND REVENUE Licenses, Permits and Fees - Charges for Services 6,676,575 Interfund Transfers 4,217,040 Intergovernmental Revenue 12,125 Other Revenue 193,316 Interest Income 35,070 REVENUE TOTALS 11,134,126 EXPENSE Salary and Benefits 1,849,028 Services and Supplies 3,451,775 Capital Outlay 2,450,000 Insurance and Other Chargebacks 319,648 Depreciation Expense - Contingencies 11,000 Debt Service 3,070,625 Miscellaneous 304,000 Interfund Transfers 1,440,417 EXPENSE TOTALS 12,896,493 Fund 505 - PARKING SYSTEM FUND (1,762,367) Fund 505 - PARKING SYSTEM FUND REVENUE TOTALS 11,134,126 EXPENSE TOTALS 12,896,493 October YTD 2017 2018 2018 %Actual (233) 43,238 61.8% 86,063 1,361,333 13,718,444 75.1% 17,255,947 52,856 5,791,679 21.2% 294,812 31,717 182,871 731.5% 35,784 1,445,673 19,736,232 43.2% 17,672,605 429,107 4,403,319 78.4% 5,958,873 307,973 2,760,125 59.3% 2,528,863 1,491,070 4,787,828 16.3% (192,124) 39,041 390,410 83.3% 468,492 - - 0.0% 2,470,280 - - 0.0% - 33,752 499,122 25.5% 717,388 - - 0.0% 2 306,859 3,068,591 85.2% 6,327,314 2,607,802 15,909,395 34.8% 18,279,088 1,445,673 19,736,232 43.2% 17,672,605 2,607,802 15,909,395 34.8% 18,279,088 (1,162,129) 3,826,836 (606,483) Budget by Organization Report Through 10/31/18 Prior Fiscal Year Activity Included 2018 Classification Budget Fund 510-513 - WATER FUND REVENUE Licenses, Permits and Fees 70,000 Charges for Services 18,267,000 Other Revenue 27,333,656 Interest Income 25,000 REVENUE TOTALS 45,695,656 EXPENSE Salary and Benefits 5,614,331 Services and Supplies 4,655,410 Capital Outlay 29,346,200 Insurance and Other Chargebacks 468,492 Depreciation Expense - Contingencies 1,000 Debt Service 1,960,760 Miscellaneous 15,000 Interfund Transfers 3,602,313 EXPENSE TOTALS 45,663,506 EXPENSE TOTALS 45,663,506 Fund 510 - WATER FUND Totals 32,150 Fund 510 - WATER FUND Totals REVENUE TOTALS 45,695,656 October YTD 2017 2018 2018 %Actual 1,285,812 10,783,159 85.7% 12,477,657 - 1,868,230 88.8% 14,870 7,205 33,923 678.5% 16,023 1,293,017 12,685,312 86.3% 12,508,550 94,328 1,052,240 82.5% 1,313,154 42,289 325,663 12.7% 88,677 391 729,666 33.5% 16,941 22,499 224,990 83.3% 269,988 - - 0.0% 3,530,787 266,839 7,156,379 94.9% 1,143,643 115 115 7.7% - 82,640 826,398 83.3% 1,141,676 509,101 10,315,450 69.6% 7,504,867 1,293,017 12,685,312 86.3% 12,508,550 509,101 10,315,450 69.6% 7,504,867 783,917 2,369,862 5,003,683 Budget by Organization Report Through 10/31/18 Prior Fiscal Year Activity Included 2018 Classification Budget Fund 515 - SEWER FUND REVENUE Charges for Services 12,589,650 Other Revenue 2,104,000 Interest Income 5,000 REVENUE TOTALS 14,698,650 EXPENSE Salary and Benefits 1,274,709 Services and Supplies 2,558,630 Capital Outlay 2,181,300 Insurance and Other Chargebacks 269,988 Depreciation Expense - Debt Service 7,540,066 Miscellaneous 1,500 Interfund Transfers 991,677 EXPENSE TOTALS 14,817,870 Fund 515 - SEWER FUND Totals (119,220) Fund 515 - SEWER FUND Totals REVENUE TOTALS 14,698,650 EXPENSE TOTALS 14,817,870 October YTD 2017 2018 2018 %Actual - 410,000 100.0% - 992 199,023 53.1% 329,039 308,179 2,917,491 78.2% 3,699,121 58,831 588,306 83.3% 755,967 2,398 89,618 235.8% 33,348 370,399 4,204,437 79.9% 4,817,475 76,548 769,792 77.5% 890,220 557,152 2,846,457 81.6% 3,482,141 164,921 176,393 64.0% 24,635 - 665 3.1% 1,797 - 3,688 49.2% 3,057 26,864 268,635 83.3% 504,807 825,484 4,065,630 79.6% 4,906,657 370,399 4,204,437 79.9% 4,817,475 825,484 4,065,630 79.6% 4,906,657 (455,085) 138,806 (89,182) Budget by Organization Report Through 10/31/18 Prior Fiscal Year Activity Included 2018 Classification Budget Fund 520 - SOLID WASTE FUND REVENUE Property Taxes 410,000 Licenses, Permits and Fees 375,000 Charges for Services 3,732,394 Interfund Transfers 705,967 Other Revenue 38,000 REVENUE TOTALS 5,261,361 EXPENSE Salary and Benefits 993,616 Services and Supplies 3,488,676 Capital Outlay 275,750 Debt Service 21,797 Miscellaneous 7,500 Interfund Transfers 322,362 EXPENSE TOTALS 5,109,701 EXPENSE TOTALS 5,109,701 Fund 520 - SOLID WASTE FUND Totals 151,660 Fund 520 - SOLID WASTE FUND Totals REVENUE TOTALS 5,261,361 October YTD 2017 2018 2018 Actual 174,504 28,057,406 28,294,363 4,030,586 40,943,511 46,951,377 479,502 8,155,815 13,357,911 379,800 3,171,165 3,467,694 555,337 8,662,941 8,754,025 618,143 6,181,427 11,586,943 132,392 1,135,295 1,234,749 176,159 1,402,373 1,858,106 15,162 70,401 38,544 6,561,584 97,780,333 115,543,711 5,341,121 56,507,492 71,659,904 702,000 9,592,056 13,414,590 97,592 254,643 361,427 400,659 21,328,903 20,883,996 23,132 69,377 124,131 - 106 4,090 55,097 623,026 835,363 639,510 6,395,100 6,641,237 7,259,111 94,770,705 113,924,739 6,561,584 97,780,333 115,543,711 7,259,111 94,770,705 113,924,739 (697,526) 3,009,628 1,618,972 Starting Fund Balance 13,216,099 13,216,099 Net Change 602,958 3,009,628 Ending Fund Balance 13,819,057 16,225,727 EXPENSE TOTALS 114,237,796 Fund 100 - GENERAL FUND Totals 602,958 Fund 100 - GENERAL FUND Totals REVENUE TOTALS 114,840,754 Miscellaneous 1,015,317 Interfund Transfers 7,704,802 EXPENSE TOTALS 114,237,796 Insurance and Other Chargebacks 22,287,563 Community Sponsored Organizations 123,886 Contingencies 208,500 Salary and Benefits 70,175,937 Services and Supplies 12,367,791 Capital Outlay 354,000 Interest Income 50,100 REVENUE TOTALS 114,840,754 EXPENSE Interfund Transfers 7,748,417 Intergovernmental Revenue 793,100 Other Revenue 1,300,217 Licenses, Permits and Fees 12,397,400 Fines and Forfeitures 3,882,500 Charges for Services 10,077,550 Fund 100 - GENERAL FUND REVENUE Property Taxes 28,849,196 Other Taxes 49,742,274 Budget by Organization Report Through 10/31/18 Prior Fiscal Year Activity Included 2018 Classification Budget Run by Kate LewisLakin on 11/16/2018 03:01:37 PM Page 1 of 35 October YTD 2017 2018 2018 Actual 6,341 909,285 933,020 597 12,990 33,019 1,494 7,348 1,548 8,432 929,623 967,586 30,554 313,211 324,972 52,046 464,694 579,392 (20) 4,110 5,110 82,580 782,015 909,475 8,432 929,623 967,586 82,580 782,015 909,475 (74,148) 147,608 58,111 Starting Fund Balance 644,499 644,499 Net Change (312,421) 147,608 Ending Fund Balance 332,078 792,107 REVENUE TOTALS 953,500 EXPENSE TOTALS 1,265,921 Fund 175 - GENERAL ASSISTANCE FUND (312,421) EXPENSE TOTALS 1,265,921 Fund 175 - GENERAL ASSISTANCE FUND Salary and Benefits 400,721 Services and Supplies 858,200 Miscellaneous 7,000 Interest Income 1,000 REVENUE TOTALS 953,500 EXPENSE Fund 175 - GENERAL ASSISTANCE FUND REVENUE Property Taxes 925,000 Other Revenue 27,500 Budget by Organization Report Through 10/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 11/16/2018 03:01:37 PM Page 2 of 35 October YTD 2017 2018 2018 Actual 69,039 690,393 859,153 - 22,593 - - 202 14 69,039 713,188 859,167 - - 22,593 - 43,229 121 16,818 631,299 918,074 - 7,500 - 16,818 682,027 940,789 69,039 713,188 859,167 16,818 682,027 940,789 52,221 31,161 (81,622) Starting Fund Balance (10,815) (10,815) Net Change (30,682) 31,161 Ending Fund Balance (41,497) 20,346 Fund 176 - HEALTH AND HUMAN (30,682) Fund 176 - HEALTH AND HUMAN REVENUE TOTALS 828,471 EXPENSE TOTALS 859,153 Miscellaneous - EXPENSE TOTALS 859,153 Salary and Benefits - Services and Supplies 859,153 Community Sponsored Organizations - Interest Income - REVENUE TOTALS 828,471 EXPENSE Fund 176 - HEALTH AND HUMAN SERVICES REVENUE Interfund Transfers 828,471 Other Revenue - Budget by Organization Report Through 10/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 11/16/2018 03:01:37 PM Page 3 of 35 October YTD 2017 2018 2018 Actual - - 1,000,000 421 2,567 1,884 421 2,567 1,001,884 73 287 - 83,333 833,333 1,000,000 83,406 833,620 1,000,000 421 2,567 1,001,884 83,406 833,620 1,000,000 (82,985) (831,053) 1,884 Starting Fund Balance 1,884 1,884 Net Change - (831,053) Ending Fund Balance 1,884 (829,169) Fund 180 - GOOD NEIGHBOR FUND Totals - Fund 180 - GOOD NEIGHBOR FUND Totals REVENUE TOTALS 1,000,000 EXPENSE TOTALS 1,000,000 Interfund Transfers 1,000,000 EXPENSE TOTALS 1,000,000 REVENUE TOTALS 1,000,000 EXPENSE Services and Supplies - Fund 180 - GOOD NEIGHBOR FUND REVENUE Other Revenue 1,000,000 Interest Income - Budget by Organization Report Through 10/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 11/16/2018 03:01:37 PM Page 4 of 35 October YTD 2017 2018 2018 Actual 42,333 6,566,597 6,370,507 13,612 89,104 122,862 19 283 338 5,833 58,333 190,200 7,214 210,258 74,206 8,385 54,105 70,807 44,100 186,060 362,608 7,708 32,720 5,169 129,205 7,197,459 7,196,696 380,118 3,918,914 4,739,145 257,261 1,327,428 1,712,359 - 492 9,904 - - 22 30,579 305,791 343,618 667,958 5,552,625 6,805,048 129,205 7,197,459 7,196,696 667,958 5,552,625 6,805,048 (538,753) 1,644,834 391,648 Starting Fund Balance 1,042,304 1,042,304 Net Change 216,912 1,644,834 Ending Fund Balance 1,259,216 2,687,138 Fund 185 - LIBRARY FUND Totals 216,912 Fund 185 - LIBRARY FUND Totals REVENUE TOTALS 7,693,209 EXPENSE TOTALS 7,476,297 Interfund Transfers 366,949 EXPENSE TOTALS 7,476,297 Services and Supplies 2,024,688 Capital Outlay 10,400 Miscellaneous - REVENUE TOTALS 7,693,209 EXPENSE Salary and Benefits 5,074,260 Other Revenue 130,000 Library Revenue 324,620 Interest Income 5,400 Charges for Services - Interfund Transfers 265,771 Intergovernmental Revenue 152,418 Fund 185 - LIBRARY FUND REVENUE Property Taxes 6,685,000 Fines and Forfeitures 130,000 Budget by Organization Report Through 10/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 11/16/2018 03:01:37 PM Page 5 of 35 October YTD 2017 2018 2018 Actual - 333,896 338,897 - - 778,745 - - 7 - 333,896 1,117,649 - 8,349 8,587 - 54,962 1,134,570 - - 112 - 63,311 1,143,269 - 333,896 1,117,649 - 63,311 1,143,269 - 270,585 (25,619) Starting Fund Balance 4,089 4,089 Net Change 12,386 270,585 Ending Fund Balance 16,475 274,674 EXPENSE TOTALS 333,404 EXPENSE TOTALS 333,404 Fund 186 - LIBRARY DEBT SERVICE FUND 12,386 Fund 186 - LIBRARY DEBT SERVICE FUND REVENUE TOTALS 345,790 Services and Supplies - Debt Service 333,404 Interfund Transfers - Interest Income - REVENUE TOTALS 345,790 EXPENSE Fund 186 - LIBRARY DEBT SERVICE FUND REVENUE Property Taxes 345,790 Other Revenue - Budget by Organization Report Through 10/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 11/16/2018 03:01:37 PM Page 6 of 35 October YTD 2017 2018 2018 Actual - 2,157,728 1,431,106 - - - - 2,157,728 1,431,106 - 22,350 30,790 7,834 24,498 1,091,917 - 1,250,000 - 7,834 1,296,849 1,122,708 - 2,157,728 1,431,106 7,834 1,296,849 1,122,708 (7,834) 860,879 308,399 Starting Fund Balance 308,399 308,399 Net Change - 860,879 Ending Fund Balance 308,399 1,169,278 Fund 187 - LIBRARY CAPITAL - Fund 187 - LIBRARY CAPITAL REVENUE TOTALS 10,095,000 EXPENSE TOTALS 10,095,000 Capital Outlay 10,095,000 Interfund Transfers - EXPENSE TOTALS 10,095,000 REVENUE TOTALS 10,095,000 EXPENSE Services and Supplies - Fund 187 - LIBRARY CAPITAL IMPROVEMENT FD REVENUE Other Revenue 10,095,000 Interest Income - Budget by Organization Report Through 10/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 11/16/2018 03:01:37 PM Page 7 of 35 October YTD 2017 2018 2018 Actual 10,000 42,755 37,641 155 739 - 10,155 43,494 37,641 2,208 22,321 26,454 5 1,880 1,860 - 7,008 2,642 - (5,369) (233) - 2,124 2,400 388 3,878 4,518 2,601 31,842 37,641 10,155 43,494 37,641 2,601 31,842 37,641 7,554 11,653 - Starting Fund Balance - - Net Change 326 11,653 Ending Fund Balance 326 11,653 EXPENSE TOTALS 94,821 Fund 195 - NEIGHBORHOOD 326 Fund 195 - NEIGHBORHOOD REVENUE TOTALS 95,147 Miscellaneous 50,000 Interfund Transfers 4,654 EXPENSE TOTALS 94,821 Services and Supplies 5,100 Capital Outlay 7,000 Insurance and Other Chargebacks - REVENUE TOTALS 95,147 EXPENSE Salary and Benefits 28,067 Fund 195 - NEIGHBORHOOD STABILIZATION FUND REVENUE Intergovernmental Revenue 95,147 Interest Income - Budget by Organization Report Through 10/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 11/16/2018 03:01:37 PM Page 8 of 35 October YTD 2017 2018 2018 Actual 136,014 1,562,861 1,899,884 2,035 41,975 18,158 - - - 138,049 1,604,836 1,918,041 125,000 1,250,000 - 79,833 798,325 957,990 204,833 2,048,325 957,990 138,049 1,604,836 1,918,041 204,833 2,048,325 957,990 (66,783) (443,489) 960,051 Starting Fund Balance 2,373,730 2,373,730 Net Change (535,990) (443,489) Ending Fund Balance 1,837,740 1,930,241 Fund 200 - MOTOR FUEL TAX FUND Totals (535,990) Fund 200 - MOTOR FUEL TAX FUND Totals REVENUE TOTALS 1,922,000 EXPENSE TOTALS 2,457,990 Capital Outlay 1,500,000 Interfund Transfers 957,990 EXPENSE TOTALS 2,457,990 Reappropriation of Surplus - REVENUE TOTALS 1,922,000 EXPENSE Fund 200 - MOTOR FUEL TAX FUND REVENUE Intergovernmental Revenue 1,910,000 Interest Income 12,000 Budget by Organization Report Through 10/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 11/16/2018 03:01:37 PM Page 9 of 35 October YTD 2017 2018 2018 Actual 120,675 1,177,210 978,523 - 863 - 443 10,714 7,178 121,118 1,188,787 985,701 44,264 469,016 585,510 3,941 197,617 239,161 846 846 51,670 1,454 14,540 17,448 6,114 61,138 72,977 56,619 743,158 966,766 121,118 1,188,787 985,701 56,619 743,158 966,766 64,499 445,630 18,935 Starting Fund Balance 181,996 181,996 Net Change 8,262 445,630 Ending Fund Balance 190,258 627,626 Fund 205 - EMERGENCY TELEPHONE 8,262 Fund 205 - EMERGENCY TELEPHONE REVENUE TOTALS 1,051,700 EXPENSE TOTALS 1,043,438 Insurance and Other Chargebacks 17,448 Interfund Transfers 73,366 EXPENSE TOTALS 1,043,438 Salary and Benefits 615,224 Services and Supplies 282,400 Capital Outlay 55,000 Interest Income 1,000 REVENUE TOTALS 1,051,700 EXPENSE Fund 205 - EMERGENCY TELEPHONE (E911) FUND REVENUE Other Taxes 1,050,700 Other Revenue - Budget by Organization Report Through 10/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 11/16/2018 03:01:37 PM Page 10 of 35 October YTD 2017 2018 2018 Actual - 341,934 322,477 - 25 5 - 341,959 322,482 92,500 277,500 329,000 92,500 277,500 329,000 - 341,959 322,482 92,500 277,500 329,000 (92,500) 64,459 (6,518) Starting Fund Balance (198,794) (198,794) Net Change - 64,459 Ending Fund Balance (198,794) (134,335) EXPENSE TOTALS 370,000 EXPENSE TOTALS 370,000 Fund 210 - SPECIAL SERVICE AREA (SSA) - Fund 210 - SPECIAL SERVICE AREA (SSA) REVENUE TOTALS 370,000 REVENUE TOTALS 370,000 EXPENSE Services and Supplies 370,000 Fund 210 - SPECIAL SERVICE AREA (SSA) #4 REVENUE Property Taxes 370,000 Interest Income - Budget by Organization Report Through 10/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 11/16/2018 03:01:37 PM Page 11 of 35 October YTD 2017 2018 2018 Actual 275,444 706,282 1,906,708 - 14,084 262 275,444 720,366 1,906,970 35,455 352,138 431,440 25 3,599 3,797 98,996 113,555 645,289 1,454 137,185 392,279 161,448 161,448 318,412 79,644 94,817 95,606 746 7,463 20,145 377,768 870,204 1,906,970 275,444 720,366 1,906,970 377,768 870,204 1,906,970 (102,324) (149,838) - Starting Fund Balance 64,107 64,107 Net Change (109,388) (149,838) Ending Fund Balance (45,281) (85,731) EXPENSE TOTALS 2,439,512 EXPENSE TOTALS 2,439,512 Fund 215 - CDBG FUND Totals (109,388) Fund 215 - CDBG FUND Totals REVENUE TOTALS 2,330,124 Community Sponsored Organizations 175,500 Miscellaneous 569,970 Interfund Transfers 949,656 Services and Supplies 220,840 Capital Outlay - Insurance and Other Chargebacks 20,648 REVENUE TOTALS 2,330,124 EXPENSE Salary and Benefits 502,898 Fund 215 - CDBG FUND REVENUE Intergovernmental Revenue 2,330,124 Other Revenue - Budget by Organization Report Through 10/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 11/16/2018 03:01:37 PM Page 12 of 35 October YTD 2017 2018 2018 Actual 3,694 95,595 51,369 488 1,600 3,391 4,182 97,196 54,760 - - - 652 109,899 13,070 652 109,899 13,070 4,182 97,196 54,760 652 109,899 13,070 3,530 (12,703) 41,690 Starting Fund Balance 252,612 252,612 Net Change - (12,703) Ending Fund Balance 252,612 239,909 Fund 220 - CDBG LOAN FUND Totals - Fund 220 - CDBG LOAN FUND Totals REVENUE TOTALS 293,000 EXPENSE TOTALS 293,000 Services and Supplies 293,000 EXPENSE TOTALS 293,000 REVENUE TOTALS 293,000 EXPENSE Salary and Benefits - Fund 220 - CDBG LOAN FUND REVENUE Other Revenue 293,000 Interest Income - Budget by Organization Report Through 10/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 11/16/2018 03:01:37 PM Page 13 of 35 October YTD 2017 2018 2018 Actual 283 899 256 283 899 256 49 132 - - - - 49 132 - 283 899 256 49 132 - 234 766 256 Starting Fund Balance 170,171 170,171 Net Change (100,000) 766 Ending Fund Balance 70,171 170,937 EXPENSE TOTALS 100,000 EXPENSE TOTALS 100,000 Fund 235 - NEIGHBORHOOD (100,000) Fund 235 - NEIGHBORHOOD REVENUE TOTALS - EXPENSE Services and Supplies - Miscellaneous 100,000 Fund 235 - NEIGHBORHOOD IMPROVEMENT REVENUE Interest Income - REVENUE TOTALS - Budget by Organization Report Through 10/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 11/16/2018 03:01:37 PM Page 14 of 35 October YTD 2017 2018 2018 Actual - 174,817 227,450 2,407 28,219 21,820 22 233 5,685 2,429 203,268 254,955 2,630 28,823 43,994 5 163,634 231,806 68 7,223 (27,871) - - 126 2,704 199,680 248,055 2,429 203,268 254,955 2,704 199,680 248,055 (275) 3,588 6,900 Starting Fund Balance 9,277 9,277 Net Change 615 3,588 Ending Fund Balance 9,892 12,865 Fund 240 - HOME FUND Totals 615 Fund 240 - HOME FUND Totals REVENUE TOTALS 588,936 Miscellaneous 500 EXPENSE TOTALS 588,321 EXPENSE TOTALS 588,321 Salary and Benefits 46,801 Services and Supplies 540,200 Insurance and Other Chargebacks 820 Interest Income - REVENUE TOTALS 588,936 EXPENSE Fund 240 - HOME FUND REVENUE Intergovernmental Revenue 588,936 Other Revenue - Budget by Organization Report Through 10/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 11/16/2018 03:01:37 PM Page 15 of 35 October YTD 2017 2018 2018 Actual - 35,700 97,000 31,667 97,917 333,056 1,982 11,895 5,623 33,649 145,511 435,678 6,468 65,627 44,432 299 57,001 209,772 - 25,674 11,532 - 10,995 8,927 3,735 23,976 85,660 10,501 183,273 360,323 33,649 145,511 435,678 10,501 183,273 360,323 23,147 (37,762) 75,355 Starting Fund Balance 1,476,544 1,476,544 Net Change (38,470) (37,762) Ending Fund Balance 1,438,074 1,438,783 Fund 250 - AFFORDABLE HOUSING FUND (38,470) Fund 250 - AFFORDABLE HOUSING FUND REVENUE TOTALS 450,830 EXPENSE TOTALS 489,300 Community Sponsored Organizations 70,000 Miscellaneous 43,000 EXPENSE TOTALS 489,300 Salary and Benefits 96,800 Services and Supplies 279,500 Insurance and Other Chargebacks - Interest Income 230 REVENUE TOTALS 450,830 EXPENSE Fund 250 - AFFORDABLE HOUSING FUND REVENUE Other Taxes 50,000 Other Revenue 400,600 Budget by Organization Report Through 10/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 11/16/2018 03:01:37 PM Page 16 of 35 October YTD 2017 2018 2018 Actual 16,172 5,711,010 5,249,949 3,992 31,877 45,924 20,164 5,742,887 5,295,873 - - 2,007 24,668 74,004 98,672 157,424 5,487,704 5,557,325 182,092 5,561,708 5,658,005 20,164 5,742,887 5,295,873 182,092 5,561,708 5,658,005 (161,928) 181,179 (362,132) Starting Fund Balance 5,262,544 5,262,544 Net Change (3,437,040) 181,179 Ending Fund Balance 1,825,504 5,443,723 EXPENSE TOTALS 9,207,040 Fund 300 - WASHINGTON NATIONAL TIF (3,437,040) Fund 300 - WASHINGTON NATIONAL TIF REVENUE TOTALS 5,770,000 Miscellaneous 100,000 Interfund Transfers 7,107,040 EXPENSE TOTALS 9,207,040 REVENUE TOTALS 5,770,000 EXPENSE Services and Supplies 2,000,000 Fund 300 - WASHINGTON NATIONAL TIF FUND REVENUE Property Taxes 5,750,000 Interest Income 20,000 Budget by Organization Report Through 10/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 11/16/2018 03:01:37 PM Page 17 of 35 October YTD 2017 2018 2018 Actual 63,802 10,471,243 10,797,411 288,929 3,070,960 2,895,561 7,219 72,187 - - 7,106,441 8,966,396 27,078 115,912 36,782 387,028 20,836,742 22,696,150 6 58,311 100,625 - 9,057,278 23,099,797 - - (57) 6 9,115,589 23,200,365 387,028 20,836,742 22,696,150 6 9,115,589 23,200,365 387,022 11,721,153 (504,215) Starting Fund Balance 241,781 241,781 Net Change 128,349 11,721,153 Ending Fund Balance 370,130 11,962,934 EXPENSE TOTALS 14,297,257 Fund 320 - DEBT SERVICE FUND Totals 128,349 Fund 320 - DEBT SERVICE FUND Totals REVENUE TOTALS 14,425,606 Debt Service 14,177,257 Miscellaneous - EXPENSE TOTALS 14,297,257 REVENUE TOTALS 14,425,606 EXPENSE Services and Supplies 120,000 Intergovernmental Revenue 83,292 Other Revenue - Interest Income 1,500 Fund 320 - DEBT SERVICE FUND REVENUE Property Taxes 10,879,993 Interfund Transfers 3,460,821 Budget by Organization Report Through 10/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 11/16/2018 03:01:37 PM Page 18 of 35 October YTD 2017 2018 2018 Actual 174 622,171 583,827 (100,234) 3,562,309 32,000 0 120 22 (100,059) 4,184,600 615,848 - 490,502 307,391 133,656 1,328,253 - 125 1,131 995 5,000 50,000 60,000 138,781 1,869,886 368,386 (100,059) 4,184,600 615,848 138,781 1,869,886 368,386 (238,840) 2,314,713 247,462 Starting Fund Balance 247,378 247,378 Net Change (296,100) 2,314,713 Ending Fund Balance (48,722) 2,562,091 Fund 330 - HOWARD-RIDGE TIF FUND (296,100) Fund 330 - HOWARD-RIDGE TIF FUND REVENUE TOTALS 4,385,400 EXPENSE TOTALS 4,681,500 Interfund Transfers 60,000 EXPENSE TOTALS 4,681,500 Services and Supplies 461,500 Capital Outlay 3,200,000 Debt Service 960,000 Interest Income 400 REVENUE TOTALS 4,385,400 EXPENSE Fund 330 - HOWARD-RIDGE TIF FUND REVENUE Property Taxes 605,000 Other Revenue 3,780,000 Budget by Organization Report Through 10/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 11/16/2018 03:01:37 PM Page 19 of 35 October YTD 2017 2018 2018 Actual 5,271 216,514 43,503 - 8,226 12,339 922 7,217 3,898 6,193 231,957 59,741 - 3,863 2,007 1,536 13,908 12,227 2,500 25,000 30,000 4,036 42,771 44,235 6,193 231,957 59,741 4,036 42,771 44,235 2,157 189,186 15,506 Starting Fund Balance 432,766 432,766 Net Change (39,850) 189,186 Ending Fund Balance 392,916 621,952 EXPENSE TOTALS 40,000 Fund 335 - WEST EVANSTON TIF FUND (39,850) Fund 335 - WEST EVANSTON TIF FUND REVENUE TOTALS 150 EXPENSE TOTALS 40,000 Services and Supplies - Debt Service 10,000 Interfund Transfers 30,000 Interest Income 150 REVENUE TOTALS 150 EXPENSE Fund 335 - WEST EVANSTON TIF FUND REVENUE Property Taxes - Other Revenue - Budget by Organization Report Through 10/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 11/16/2018 03:01:37 PM Page 20 of 35 October YTD 2017 2018 2018 Actual - 136,927 48,001 - - 2,067,512 - 10 1 - 136,937 2,115,514 - 1,526 38,588 - - 2,053,521 - 74,104 - - 75,630 2,092,108 - 136,937 2,115,514 - 75,630 2,092,108 - 61,307 23,406 Starting Fund Balance (6,009) (6,009) Net Change 202,334 61,307 Ending Fund Balance 196,325 55,298 EXPENSE TOTALS 72,666 Fund 340 - DEMPSTER-DODGE TIF FUND 202,334 Fund 340 - DEMPSTER-DODGE TIF FUND REVENUE TOTALS 275,000 EXPENSE TOTALS 72,666 Services and Supplies - Debt Service 72,666 Interfund Transfers - Interest Income - REVENUE TOTALS 275,000 EXPENSE Fund 340 - DEMPSTER-DODGE TIF FUND REVENUE Property Taxes 275,000 Other Revenue - Budget by Organization Report Through 10/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 11/16/2018 03:01:37 PM Page 21 of 35 October YTD 2017 2018 2018 Actual 2,889 222,235 75,430 - - 3,520,189 - 23 9 2,889 222,258 3,595,628 - 1,526 58,113 - - 580,000 - - 3,031,398 - 107,561 - - 109,087 3,669,511 2,889 222,258 3,595,628 - 109,087 3,669,511 2,889 113,171 (73,884) Starting Fund Balance 61,193 61,193 Net Change 316,001 113,171 Ending Fund Balance 377,194 174,364 Fund 345 - CHICAGO-MAIN TIF Totals 316,001 Fund 345 - CHICAGO-MAIN TIF Totals REVENUE TOTALS 425,000 EXPENSE TOTALS 108,999 Interfund Transfers - EXPENSE TOTALS 108,999 Services and Supplies - Capital Outlay - Debt Service 108,999 Interest Income - REVENUE TOTALS 425,000 EXPENSE Fund 345 - CHICAGO-MAIN TIF REVENUE Property Taxes 425,000 Other Revenue - Budget by Organization Report Through 10/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 11/16/2018 03:01:37 PM Page 22 of 35 October YTD 2017 2018 2018 Actual 1,494 115,188 215,245 1 33 21 1,495 115,221 215,266 - - 213,354 - - 78,000 - - 291,354 1,495 115,221 215,266 - - 291,354 1,495 115,221 (76,088) Starting Fund Balance 2,207 2,207 Net Change - 115,221 Ending Fund Balance 2,207 117,428 Fund 350 - SPECIAL SERVICE AREA (SSA) - Fund 350 - SPECIAL SERVICE AREA (SSA) REVENUE TOTALS 221,500 EXPENSE TOTALS 221,500 Interfund Transfers - EXPENSE TOTALS 221,500 REVENUE TOTALS 221,500 EXPENSE Services and Supplies 221,500 Fund 350 - SPECIAL SERVICE AREA (SSA) #6 REVENUE Property Taxes 221,000 Interest Income 500 Budget by Organization Report Through 10/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 11/16/2018 03:01:37 PM Page 23 of 35 October YTD 2017 2018 2018 Actual - - 359,706 11,447 59,066 33,339 536,667 5,366,667 787,177 - 51,221 530,812 - 10,274,896 11,246,149 32,652 160,610 56,607 580,766 15,912,459 13,013,790 51,401 512,105 5,392 89,884 846,838 1,672,608 922,921 9,136,872 13,582,482 41,667 416,667 500,000 1,105,873 10,912,481 15,760,481 580,766 15,912,459 13,013,790 1,105,873 10,912,481 15,760,481 (525,106) 4,999,978 (2,746,691) Starting Fund Balance 8,758,473 8,758,473 Net Change (7,655,527) 4,999,978 Ending Fund Balance 1,102,946 13,758,451 Fund 415 - CAPITAL IMPROVEMENTS (7,655,527) Fund 415 - CAPITAL IMPROVEMENTS REVENUE TOTALS 22,642,000 EXPENSE TOTALS 30,297,527 Interfund Transfers 500,000 EXPENSE TOTALS 30,297,527 Salary and Benefits 85,527 Services and Supplies - Capital Outlay 29,712,000 Interest Income - REVENUE TOTALS 22,642,000 EXPENSE Interfund Transfers 6,450,000 Intergovernmental Revenue 4,190,000 Other Revenue 12,002,000 Fund 415 - CAPITAL IMPROVEMENTS FUND REVENUE Licenses, Permits and Fees - Charges for Services - Budget by Organization Report Through 10/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 11/16/2018 03:01:37 PM Page 24 of 35 October YTD 2017 2018 2018 Actual - - 649,512 - 1,250,000 - 11,435 25,634,054 900,000 24,885 60,145 - 36,320 26,944,199 1,549,512 196,605 1,715,782 638,727 477,680 1,773,035 369,924 674,285 3,488,818 1,008,651 36,320 26,944,199 1,549,512 674,285 3,488,818 1,008,651 (637,965) 23,455,381 540,861 Starting Fund Balance 540,861 540,861 Net Change 1,866,000 23,455,381 Ending Fund Balance 2,406,861 23,996,242 EXPENSE TOTALS 9,634,000 Fund 416 - CROWN CONSTRUCTION FUND 1,866,000 Fund 416 - CROWN CONSTRUCTION FUND REVENUE TOTALS 11,500,000 EXPENSE TOTALS 9,634,000 EXPENSE Services and Supplies 1,634,000 Capital Outlay 8,000,000 Other Revenue 11,500,000 Interest Income - REVENUE TOTALS 11,500,000 Fund 416 - CROWN CONSTRUCTION FUND REVENUE Interfund Transfers - Intergovernmental Revenue - Budget by Organization Report Through 10/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 11/16/2018 03:01:37 PM Page 25 of 35 October YTD 2017 2018 2018 Actual - 277,004 - 3,243 42,300 31,207 - 139,246 237,012 3,243 458,551 268,219 5,803 58,619 694 5 1,943 5,613 - 303,736 - 42,786 427,856 263,427 48,594 792,154 269,734 3,243 458,551 268,219 48,594 792,154 269,734 (45,351) (333,604) (1,516) Starting Fund Balance 2,997,700 2,997,700 Net Change (123,850) (333,604) Ending Fund Balance 2,873,850 2,664,096 Fund 420 - SPECIAL ASSESSMENT FUND (123,850) Fund 420 - SPECIAL ASSESSMENT FUND REVENUE TOTALS 461,367 EXPENSE TOTALS 585,217 Interfund Transfers 513,427 EXPENSE TOTALS 585,217 Salary and Benefits 71,790 Services and Supplies - Debt Service - Special Assessment 180,167 REVENUE TOTALS 461,367 EXPENSE Fund 420 - SPECIAL ASSESSMENT FUND REVENUE Other Revenue 250,000 Interest Income 31,200 Budget by Organization Report Through 10/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 11/16/2018 03:01:37 PM Page 26 of 35 October YTD 2017 2018 2018 Actual 150 2,398 1,900 656,804 5,380,980 6,303,624 (87,576) 3,037,704 4,120,636 - - - 14,129 278,451 253,523 12,543 84,542 62,067 596,050 8,784,075 10,741,750 139,533 1,404,875 1,675,404 237,804 2,967,392 3,172,070 - 200,976 280,311 26,637 266,373 319,648 - - 2,561,771 - - 4,246 - 53,131 267,734 43,840 153,449 267,436 120,035 1,200,348 1,584,683 567,849 6,246,545 10,133,302 596,050 8,784,075 10,741,750 567,849 6,246,545 10,133,302 28,201 2,537,530 608,448 Starting Fund Balance 4,710,701 4,710,701 Net Change (1,762,367) 2,537,530 Ending Fund Balance 2,948,334 7,248,231 EXPENSE TOTALS 12,896,493 Fund 505 - PARKING SYSTEM FUND Totals (1,762,367) Fund 505 - PARKING SYSTEM FUND Totals REVENUE TOTALS 11,134,126 EXPENSE TOTALS 12,896,493 Debt Service 3,070,625 Miscellaneous 304,000 Interfund Transfers 1,440,417 Insurance and Other Chargebacks 319,648 Depreciation Expense - Contingencies 11,000 Salary and Benefits 1,849,028 Services and Supplies 3,451,775 Capital Outlay 2,450,000 Interest Income 35,070 REVENUE TOTALS 11,134,126 EXPENSE Interfund Transfers 4,217,040 Intergovernmental Revenue 12,125 Other Revenue 193,316 Fund 505 - PARKING SYSTEM FUND REVENUE Licenses, Permits and Fees - Charges for Services 6,676,575 Budget by Organization Report Through 10/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 11/16/2018 03:01:37 PM Page 27 of 35 October YTD 2017 2018 2018 Actual (233) 43,238 86,063 1,361,333 13,718,444 17,255,947 52,856 5,791,679 294,812 31,717 182,871 35,784 1,445,673 19,736,232 17,672,605 429,107 4,403,319 5,958,873 307,973 2,760,125 2,528,863 1,491,070 4,787,828 (192,124) 39,041 390,410 468,492 - - 2,470,280 - - - 33,752 499,122 717,388 - - 2 306,859 3,068,591 6,327,314 2,607,802 15,909,395 18,279,088 1,445,673 19,736,232 17,672,605 2,607,802 15,909,395 18,279,088 (1,162,129) 3,826,836 (606,483) Starting Fund Balance 6,562,795 6,562,795 Net Change 32,150 3,826,836 Ending Fund Balance 6,594,945 10,389,631 Fund 510 - WATER FUND Totals 32,150 Fund 510 - WATER FUND Totals REVENUE TOTALS 45,695,656 Interfund Transfers 3,602,313 EXPENSE TOTALS 45,663,506 EXPENSE TOTALS 45,663,506 Contingencies 1,000 Debt Service 1,960,760 Miscellaneous 15,000 Capital Outlay 29,346,200 Insurance and Other Chargebacks 468,492 Depreciation Expense - EXPENSE Salary and Benefits 5,614,331 Services and Supplies 4,655,410 Other Revenue 27,333,656 Interest Income 25,000 REVENUE TOTALS 45,695,656 Fund 510-513 - WATER FUND REVENUE Licenses, Permits and Fees 70,000 Charges for Services 18,267,000 Budget by Organization Report Through 10/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 11/16/2018 03:01:37 PM Page 28 of 35 October YTD 2017 2018 2018 Actual 1,285,812 10,783,159 12,477,657 - 1,868,230 14,870 7,205 33,923 16,023 1,293,017 12,685,312 12,508,550 94,328 1,052,240 1,313,154 42,289 325,663 88,677 391 729,666 16,941 22,499 224,990 269,988 - - 3,530,787 266,839 7,156,379 1,143,643 115 115 - 82,640 826,398 1,141,676 509,101 10,315,450 7,504,867 1,293,017 12,685,312 12,508,550 509,101 10,315,450 7,504,867 783,917 2,369,862 5,003,683 Starting Fund Balance 4,037,755 4,037,755 Net Change (119,220) 2,369,862 Ending Fund Balance 3,918,535 6,407,617 Fund 515 - SEWER FUND Totals (119,220) Fund 515 - SEWER FUND Totals REVENUE TOTALS 14,698,650 EXPENSE TOTALS 14,817,870 Miscellaneous 1,500 Interfund Transfers 991,677 EXPENSE TOTALS 14,817,870 Insurance and Other Chargebacks 269,988 Depreciation Expense - Debt Service 7,540,066 Salary and Benefits 1,274,709 Services and Supplies 2,558,630 Capital Outlay 2,181,300 Interest Income 5,000 REVENUE TOTALS 14,698,650 EXPENSE Fund 515 - SEWER FUND REVENUE Charges for Services 12,589,650 Other Revenue 2,104,000 Budget by Organization Report Through 10/31/18 Prior Fiscal Year Activity Included 2018 Classification Budget Run by Kate LewisLakin on 11/16/2018 03:01:37 PM Page 29 of 35 October YTD 2017 2018 2018 Actual - 410,000 - 992 199,023 329,039 308,179 2,917,491 3,699,121 58,831 588,306 755,967 2,398 89,618 33,348 370,399 4,204,437 4,817,475 76,548 769,792 890,220 557,152 2,846,457 3,482,141 164,921 176,393 24,635 - 665 1,797 - 3,688 3,057 26,864 268,635 504,807 825,484 4,065,630 4,906,657 370,399 4,204,437 4,817,475 825,484 4,065,630 4,906,657 (455,085) 138,806 (89,182) Starting Fund Balance (1,061,966) (1,061,966) Net Change 151,660 138,806 Ending Fund Balance (910,306) (923,160) EXPENSE TOTALS 5,109,701 Fund 520 - SOLID WASTE FUND Totals 151,660 Fund 520 - SOLID WASTE FUND Totals REVENUE TOTALS 5,261,361 Miscellaneous 7,500 Interfund Transfers 322,362 EXPENSE TOTALS 5,109,701 Services and Supplies 3,488,676 Capital Outlay 275,750 Debt Service 21,797 REVENUE TOTALS 5,261,361 EXPENSE Salary and Benefits 993,616 Charges for Services 3,732,394 Interfund Transfers 705,967 Other Revenue 38,000 Fund 520 - SOLID WASTE FUND REVENUE Property Taxes 410,000 Licenses, Permits and Fees 375,000 Budget by Organization Report Through 10/31/18 Prior Fiscal Year Activity Included 2018 Classification Budget Run by Kate LewisLakin on 11/16/2018 03:01:37 PM Page 30 of 35 October YTD 2017 2018 2018 Actual 249,053 2,490,533 2,478,435 187 16,523 19,016 - 24 339 249,240 2,507,081 2,497,791 92,497 850,251 1,154,569 142,982 1,707,783 1,744,972 - - - 118 118 - 2,787 27,868 27,833 238,384 2,586,020 2,927,375 249,240 2,507,081 2,497,791 238,384 2,586,020 2,927,375 10,856 (78,939) (429,584) Starting Fund Balance 341,343 341,343 Net Change (262,450) (78,939) Ending Fund Balance 78,893 262,404 EXPENSE TOTALS 3,333,871 Fund 600 - FLEET SERVICES FUND Totals (262,450) Fund 600 - FLEET SERVICES FUND Totals REVENUE TOTALS 3,071,421 Miscellaneous - Interfund Transfers 33,442 EXPENSE TOTALS 3,333,871 Salary and Benefits 1,069,922 Services and Supplies 2,230,057 Contingencies 450 Interest Income 1,000 REVENUE TOTALS 3,071,421 EXPENSE Fund 600 - FLEET SERVICES FUND REVENUE Charges for Services 2,988,640 Other Revenue 81,781 Budget by Organization Report Through 10/31/18 Prior Fiscal Year Activity Included 2018 Classification Budget Run by Kate LewisLakin on 11/16/2018 03:01:37 PM Page 31 of 35 October YTD 2017 2018 2018 Actual 111,228 1,112,277 1,400,057 - - - - 39,603 88,015 1,411 4,075 2,128 112,639 1,155,955 1,490,200 3,240 30,908 74,539 654 1,014,527 - - - 1,780,829 - - - 3,895 1,045,435 1,855,367 112,639 1,155,955 1,490,200 3,895 1,045,435 1,855,367 108,744 110,520 (365,167) Starting Fund Balance 849,519 849,519 Net Change (53,028) 110,520 Ending Fund Balance 796,491 960,039 EXPENSE TOTALS 1,597,977 Fund 601 - EQUIPMENT REPLACEMENT (53,028) Fund 601 - EQUIPMENT REPLACEMENT REVENUE TOTALS 1,544,949 Depreciation Expense - Miscellaneous - EXPENSE TOTALS 1,597,977 EXPENSE Services and Supplies 75,000 Capital Outlay 1,522,977 Other Revenue 210,217 Interest Income - REVENUE TOTALS 1,544,949 Fund 601 - EQUIPMENT REPLACEMENT FUND REVENUE Charges for Services 1,334,732 Interfund Transfers - Budget by Organization Report Through 10/31/18 Prior Fiscal Year Activity Included 2018 Classification Budget Run by Kate LewisLakin on 11/16/2018 03:01:37 PM Page 32 of 35 October YTD 2017 2018 2018 Actual 13,538 140,627 162,411 - - 2,300,000 863,536 8,503,321 10,926,377 171,610 1,741,893 1,032,678 536,104 4,727,505 5,611,626 - 2,878 382 1,584,789 15,116,223 20,033,473 37,172 464,258 606,021 630,148 4,450,301 3,594,432 - 33,222 - 1,289,808 13,521,943 17,164,869 803 8,027 9,632 1,957,930 18,477,750 21,374,954 1,584,789 15,116,223 20,033,473 1,957,930 18,477,750 21,374,954 (373,141) (3,361,528) (1,341,481) Starting Fund Balance (4,338,505) (4,338,505) Net Change 653,342 (3,361,528) Ending Fund Balance (3,685,163) (7,700,033) EXPENSE TOTALS 18,439,931 Fund 605 - INSURANCE FUND Totals 653,342 Fund 605 - INSURANCE FUND Totals REVENUE TOTALS 19,093,273 Insurance and Other Chargebacks 15,315,824 Interfund Transfers 9,632 EXPENSE TOTALS 18,439,931 Salary and Benefits 729,027 Services and Supplies 2,385,448 Capital Outlay - Interest Income 1,000 REVENUE TOTALS 19,093,273 EXPENSE Other Revenue 10,867,028 Workers Compensation and Liability 2,196,415 Insurance 5,811,177 Fund 605 - INSURANCE FUND REVENUE Charges for Services 162,411 Interfund Transfers 55,242 Budget by Organization Report Through 10/31/18 Prior Fiscal Year Activity Included 2018 Classification Budget Run by Kate LewisLakin on 11/16/2018 03:01:37 PM Page 33 of 35 October YTD 2017 2018 2018 Actual - - - - - - 121,232 10,541,944 15,225,459 - 1,202,518 2,065,885 121,232 11,744,463 17,291,343 787,159 7,670,168 8,682,009 - 38,072 136,256 787,159 7,708,240 8,818,265 121,232 11,744,463 17,291,343 787,159 7,708,240 8,818,265 (665,926) 4,036,222 8,473,079 Starting Fund Balance 79,073,077 79,073,077 Net Change 4,989,947 4,036,222 Ending Fund Balance 84,063,024 83,109,299 EXPENSE TOTALS 8,795,000 Fund 700 - FIRE PENSION FUND Totals 4,989,947 Fund 700 - FIRE PENSION FUND Totals REVENUE TOTALS 13,784,947 EXPENSE TOTALS 8,795,000 EXPENSE Salary and Benefits 8,795,000 Miscellaneous - Other Revenue 9,394,947 Interest Income 4,100,000 REVENUE TOTALS 13,784,947 Fund 700 - FIRE PENSION FUND REVENUE Other Taxes 280,000 Interfund Transfers 10,000 Budget by Organization Report Through 10/31/18 Prior Fiscal Year Activity Included 2018 Classification Budget Run by Kate LewisLakin on 11/16/2018 03:01:37 PM Page 34 of 35 October YTD 2017 2018 2018 Actual - - - 168,630 15,798,085 24,497,983 - 2,103,169 2,829,084 168,630 17,901,254 27,327,068 996,071 9,984,096 11,624,574 - 199,053 264,371 996,071 10,183,149 11,888,945 168,630 17,901,254 27,327,068 996,071 10,183,149 11,888,945 (827,440) 7,718,104 15,438,122 Starting Fund Balance 121,629,667 121,629,667 Net Change 6,194,704 7,718,104 Ending Fund Balance 127,824,371 129,347,771 EXPENSE TOTALS 12,525,000 Fund 705 - POLICE PENSION FUND Totals 6,194,704 Fund 705 - POLICE PENSION FUND Totals REVENUE TOTALS 18,719,704 Salary and Benefits 12,255,000 Miscellaneous 270,000 EXPENSE TOTALS 12,525,000 Interest Income 6,500,000 REVENUE TOTALS 18,719,704 EXPENSE Fund 705 - POLICE PENSION FUND REVENUE Interfund Transfers 57,000 Other Revenue 12,162,704 Budget by Organization Report Through 10/31/18 Prior Fiscal Year Activity Included 2018 Classification Budget Run by Kate LewisLakin on 11/16/2018 03:01:37 PM Page 35 of 35