Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2018.02 February Monthly Report
YTD Revenues YTD Expenses YTD Net Fund Balance Cash Balance 18,027,293 17,362,995 664,298 15,306,742 8,120,225 206,210 143,570 62,640 707,139 707,139 138,097 23,222 114,875 126,652 126,652 139 166,667 (166,527) (164,643) 835,356 1,498,930 917,659 581,271 1,566,043 1,566,005 19 6,343 (6,324) (8,766) 88,645 339,653 409,665 (70,012) 2,303,717 2,139,130 153,292 105,541 47,750 233,244 (80,303) 18,029 - 18,029 (180,766) (180,766) 713 64,180 (63,467) 627 640 6,037 11,393 (5,356) 247,255 247,256 22 - 22 170,193 170,193 4,581 30,235 (25,654) (16,377) (16,377) 33,014 13,376 19,637 1,496,181 1,500,598 63,147 - 63,147 67,349 54,443 1,697,855 1,184,507 513,348 5,775,892 5,852,525 20,772 260,206 (239,434) 34,444 10,213 9,047 7,532 1,515 434,281 442,603 26,401 - 26,401 20,392 20,392 18,000 - 18,000 79,193 79,193 35,572 - 35,572 37,778 37,779 - - - 308,399 308,399 2,503,519 - 2,503,519 2,699,976 2,714,773 1,088,856 686,367 402,489 9,849,845 10,293,551 - 146,799 (146,799) 393,882 540,861 60,611 95,340 (34,729) 2,962,971 2,959,434 1,630,228 829,826 800,403 5,709,805 5,336,116 3,028,307 1,765,873 1,262,435 8,587,421 5,340,689 2,851,971 961,696 1,890,275 6,040,202 3,207,076 711,408 624,036 87,373 (1,081,642) (1,539,782) 503,073 395,591 107,481 465,718 (323,761) 222,590 114,718 107,872 1,184,849 915,232 2,743,327 3,061,510 (318,183) (5,666,218) (1,846,292) 37,640,713 29,388,847 8,251,865 59,691,778 49,627,837 Fund Fund Description 100 GENERAL FUND 175 GENERAL ASSISTANCE FUND 176 HEALTH AND HUMAN SERVICES 180 GOOD NEIGHBOR FUND 185 LIBRARY FUND 195 NEIGHBORHOOD STABILIZATION FUND 200 MOTOR FUEL TAX FUND 205 EMERGENCY TELEPHONE (E911) FUND 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 FUND 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 IMPROVEMENT FD 320 DEBT SERVICE FUND 415 CAPITAL IMPROVEMENTS 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 416 CROWN CONSTRUCTION FUND 420 SPECIAL ASSESSMENT FUND To: Wally Bobkiewicz, City Manager From: Ashley King, Interim CFO/City Treasurer Subject: January 2018 Monthly Financial Report Date: March 13, 2018 Please find attached the unaudited financial statements as of February 28, 2018. A summary by fund for revenues, expenditures, fund and cash balances is as follows: Memorandum Included above are the ending balances as of February 28, 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. The fund balances included in this financial report are based on unaudited 2017 year- end balances. These may change slightly during the Audit Process, which will be conducted during April 2018. As of February 28, 2018, the General Fund is reporting a net surplus of $664,298. The General Fund balance is $15,306,742 with a cash balance of $8,120,225. The attached supplemental charts show the General Fund Revenues at 15.7% of budget and expenses slightly lower at 15.2%. Through February 28, 2018, the Good Neighbor Fund is showing a negative fund balance of $164,643. 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 February 28, 2018, the Neighborhood Stabilization Fund is showing a negative fund balance of $8,766. This is due to the timing of grant funding revenues. Through February 28, 2018, the E911 Fund is showing negative cash balance of $80,303. This is due to timing of E911 revenues from the state and the expenses related to the replacement of Computer Aided Dispatch (CAD) and Police/Fire Records Software. Through February 28, 2018, the SSA #4 Fund is showing a negative fund and cash balance of $180,766. This negative balance has carried through from 2016 and will need to be addressed during 2018. Through February 28, 2018, the Home Fund is showing a negative cash and fund balance of $16,677. This is reimbursed with draw-downs in February 2018. Through February 28, 2018, the Capital Fund is showing a fund balance of $9,849,845 and a cash balance of $10,293,551. Bond proceeds from the 2017A General Obligation Bonds were received in October, significantly increasing fund and cash balances. Through February 28, 2018, the enterprise funds (Parking, Water, and Sewer) continue to spend down fund balance for capital projects. Fund 100 - GENERAL FUND 2018 February YTD 2017 Budget 2018 2018 %Actual 28,849,196 3,229,452 6,360,143 22.0% 28,294,363 49,742,274 2,660,196 6,517,170 13.1% 47,415,437 5,548,000 502,406 959,325 17.3% 4,998,033 6,681,900 158,916 468,735 7.0% 7,990,628 167,500 6,692 27,148 16.2% 238,240 3,897,500 294,761 611,222 15.7% 3,484,050 1,373,500 19,578 19,578 1.4% 662,214 5,885,750 684,715 976,708 16.6% 5,471,036 2,818,300 117,820 446,449 15.8% 2,620,775 7,748,417 618,143 1,236,285 16.0% 8,590,717 778,100 80,273 219,441 28.2% 1,468,393 1,300,217 147,206 181,643 14.0% 1,345,658 50,100 1,156 3,445 6.9% 38,544 REVENUE TOTAL 114,840,754 8,521,314 18,027,293 15.7% 112,618,089 CITY COUNCIL 492,806 44,751 75,546 15.3% 498,172 CITY CLERK 191,784 11,610 21,030 11.0% 251,193 CITY MANAGER'S OFFICE 7,540,597 544,013 1,025,792 13.6% 7,294,226 LAW 736,346 61,673 102,370 13.9% 772,045 ADMINISTRATIVE SERVICES 9,075,303 766,347 1,166,291 12.9% 9,314,164 COMMUNITY DEVELOPMENT 3,614,774 244,602 408,427 11.3% 2,592,984 POLICE 38,391,099 3,713,005 6,575,148 17.1% 39,067,047 FIRE MGMT & SUPPORT 23,934,390 2,072,261 3,992,562 16.7% 24,207,459 HEALTH 3,697,529 247,484 443,140 12.0% 3,071,334 PARKS, REC. AND COMMUNITY SERV. 11,955,812 766,242 1,250,798 10.5% 12,474,508 PUBLIC WORKS AGENCY 14,607,356 1,279,030 2,301,891 15.8% 13,959,679 EXPENSE TOTAL 114,237,796 9,751,018 17,362,995 15.2% 113,502,811 REVENUE TOTALS 114,840,754 8,521,314 18,027,293 15.7% 112,618,089 EXPENSE TOTALS 114,237,796 9,751,018 17,362,995 15.2% 113,502,811 602,958 (1,229,705) 664,298 (884,722) February 2018 Financial Report Through 02/28/18 Summary Listing Classification Permit Fee Fines and Forfeitures Property Taxes Other Taxes License Intergovernmental Revenue Fund 100 - GENERAL FUND Net Gain Fund 100 - GENERAL FUND Totals Other Revenue Interest Income Parking Charges for Services Parks and Recreation Charges for Services Other Charges for Services Interfund Transfers Fund 505 - PARKING SYSTEM FUND 2018 February YTD 2017 Budget 2018 2018 %Actual - - 913 0.0% 1,900 6,611,575 469,763 883,415 13.4% 6,242,624 65,000 - - 0.0% 61,000 4,217,040 347,253 694,507 16.5% 4,120,636 12,125 - - 0.0% - 193,316 14,089 44,668 23.1% 224,872 35,070 3,368 6,726 19.2% 62,067 REVENUE TOTAL 11,134,126 834,474 1,630,228 14.6% 10,713,099 26,000 1,910 4,164 16.0% 26,304 1,495,875 105,447 179,253 12.0% 1,135,239 89,203 9,042 15,967 17.9% 105,899 3,172,911 231,618 269,488 8.5% 2,905,390 278,864 17,331 18,195 6.5% 234,614 2,450,000 - - 0.0% 2,391,090 557,598 43,593 83,619 15.0% 552,831 11,000 - - 0.0% 4,246 3,070,625 - - 0.0% 4,330,993 304,000 19,070 19,070 6.3% 267,436 1,440,417 120,035 240,070 16.7% 1,584,683 EXPENSE TOTAL 12,896,493 548,045 829,826 6.4% 13,538,725 11,134,126 834,474 1,630,228 14.6% 10,713,099 12,896,493 548,045 829,826 6.4% 13,538,725 (1,762,367) 286,429 800,403 (2,825,627) EXPENSE TOTALS Fund 505 - PARKING SYSTEM FUND Net Miscellaneous Interfund Transfers Fund 505 - PARKING SYSTEM FUND REVENUE TOTALS Capital Outlay Insurance and Other Chargebacks Contingencies Debt Service Pensions Services Supplies Interest Income Employee Pay Benefits Parking Charges for Services Parks and Recreation Charges for Services Interfund Transfers Intergovernmental Revenue Permit February 2018 Financial Report Through 02/28/18 Summary Listing Classification Other Revenue Fund 510 - WATER FUND 2018 February YTD 2017 Budget 2018 2018 %Actual 70,000 1,170 2,515 3.6% 86,063 18,047,500 1,410,429 3,003,954 16.6% 17,069,646 49,500 3,657 7,939 16.0% 49,220 170,000 - 53 0.0% 139,998 27,333,656 (340) 6,261 0.0% 1,266,352 25,000 3,718 7,586 30.3% 34,587 REVENUE TOTAL 45,695,656 1,418,634 3,028,307 6.6% 18,645,866 264,525 10,424 32,240 12.2% 188,857 4,287,543 316,731 564,520 13.2% 4,068,421 369,371 28,296 51,557 14.0% 382,358 2,884,420 217,398 230,451 8.0% 2,442,214 1,770,990 65,870 65,378 3.7% 907,614 29,346,200 38,927 38,927 0.1% 3,436,079 1,161,384 90,418 169,080 14.6% 1,158,869 1,000 - - 0.0% - 1,960,760 - - 0.0% 1,631,712 15,000 - - 0.0% (227,922) 3,602,313 306,859 613,718 17.0% 6,327,314 EXPENSE TOTAL 45,663,506 1,074,923 1,765,872 3.9% 20,315,515 45,695,656 1,418,634 3,028,307 6.6% 18,645,866 45,663,506 1,074,923 1,765,872 3.9% 20,315,515 32,150 343,711 1,262,436 (1,669,650)Fund 510 - WATER FUND Net Gain (Loss) Interfund Transfers Fund 510 - WATER FUND Totals REVENUE TOTALS EXPENSE TOTALS Insurance and Other Chargebacks Contingencies Debt Service Miscellaneous Services Supplies Fee February 2018 Financial Report Through 02/28/18 Summary Listing Classification Interest Income Employee Pay Benefits Pensions Water Charges for Services Sewer Charges for Services Other Charges for Services Other Revenue Capital Outlay Fund 515 - SEWER FUND 2018 February YTD 2017 Budget 2018 2018 %Actual 12,570,000 977,029 2,848,949 22.7% 12,455,907 19,650 - - 0.0% 21,750 2,104,000 - - 0.0% 2 5,000 1,410 3,022 60.4% 16,023 REVENUE TOTAL 14,698,650 978,439 2,851,971 19.4% 12,493,682 57,040 592 4,822 8.5% 35,510 988,098 78,474 137,872 14.0% 869,416 78,549 6,904 12,468 15.9% 82,975 2,466,330 2,584 2,584 0.1% 943,749 92,300 1,647 1,647 1.8% 44,136 2,181,300 - - 0.0% 1,227,662 421,010 34,359 66,929 15.9% 437,253 7,540,066 205,395 570,094 7.6% 1,541,842 1,500 - - 0.0% - 991,677 82,640 165,280 16.7% 1,141,676 EXPENSE TOTAL 14,817,870 412,594 961,696 6.5% 6,324,218 14,698,650 978,439 2,851,971 19.4% 12,493,682 14,817,870 412,594 961,696 6.5% 6,324,218 (119,220) 565,845 1,890,275 6,169,464 Fund 515 - SEWER FUND Net Gain (Loss) Interfund Transfers Fund 515 - SEWER FUND Totals REVENUE TOTALS EXPENSE TOTALS Insurance and Other Chargebacks Debt Service Miscellaneous Pensions Services Supplies Employee Pay Benefits Sewer Charges for Services Other Charges for Services Capital Outlay February 2018 Financial Report Through 02/28/18 Summary Listing Classification Other Revenue Interest Income Fund 520 - SOLID WASTE FUND 2018 February YTD 2017 Budget 2018 2018 %Actual 410,000 - - 0.0% - 275,000 - - 0.0% 199,513 3,632,394 302,339 592,415 16.3% 3,611,308 705,967 (29,167) 117,661 16.7% 755,967 238,000 542 1,332 0.6% 250,687 REVENUE TOTAL 5,261,361 273,714 711,408 13.5% 4,817,475 45,000 967 1,377 3.1% 36,745 778,425 57,481 97,718 12.6% 567,411 47,944 5,081 8,624 18.0% 54,923 3,411,626 276,222 441,656 12.9% 3,433,713 77,050 3,010 4,559 5.9% 48,428 275,750 - - 0.0% 24,635 122,247 8,991 16,374 13.4% 116,954 21,797 - - 0.0% 21,046 7,500 - - 0.0% 3,057 322,362 26,864 53,727 16.7% 504,807 EXPENSE TOTAL 5,109,701 378,616 624,036 12.2% 4,811,719 5,261,361 273,714 711,408 13.5% 4,817,475 5,109,701 378,616 624,036 12.2% 4,811,719 151,660 (104,902) 87,373 5,756 EXPENSE TOTALS Fund 520 - SOLID WASTE FUND Net Gain Services Supplies Capital Outlay Fund 520 - SOLID WASTE FUND Totals REVENUE TOTALS Insurance and Other Chargebacks Debt Service Miscellaneous Interfund Transfers Employee Pay Benefits Pensions Other Charges for Services Interfund Transfers Other Revenue Property Taxes License February 2018 Financial Report Through 02/28/18 Summary Listing Classification February YTD 2017 2018 2018 Actuals 3,229,452 6,360,143 28,294,363 2,660,196 6,517,170 47,415,437 668,014 1,455,208 13,226,901 294,761 611,222 3,484,050 822,114 1,442,735 8,754,025 618,143 1,236,285 8,590,717 80,273 219,441 1,468,393 147,206 181,643 1,345,658 - - - - - - - - - 1,156 3,445 38,544 - - - - - - 8,521,314 18,027,293 112,618,089 5,418,809 9,308,417 62,232,769 782,250 1,033,024 13,086,902 750 4,773 361,427 2,950,133 5,680,331 30,134,474 1,315 1,315 174,131 - - - 33 33 4,090 - - - 46,216 56,081 867,781 551,513 1,279,020 6,641,237 9,751,018 17,362,995 113,502,811 8,521,314 18,027,293 112,618,089 9,751,018 17,362,995 113,502,811 (1,229,705) 664,298 (884,722) Starting Fund Balance 14,642,444 14,642,444 Net Change 602,958 664,298 Ending Fund Balance 15,245,402 15,306,742 REVENUE TOTALS 114,840,754 EXPENSE TOTALS 114,237,796 Fund 100 - GENERAL FUND Totals 602,958 EXPENSE TOTALS 114,237,796 Fund 100 - GENERAL FUND Totals Debt Service - Miscellaneous 965,317 Interfund Transfers 7,704,802 Community Sponsored Organizations 173,886 Depreciation Expense - Contingencies 208,500 Services and Supplies 12,366,791 Capital Outlay 354,000 Insurance and Other Chargebacks 31,279,188 REVENUE TOTALS 114,840,754 EXPENSE Salary and Benefits 61,185,312 Interest Income 50,100 Special Assessment - Reappropriation of Surplus - Workers Compensation and Liability - Insurance - Library Revenue - Interfund Transfers 7,748,417 Intergovernmental Revenue 778,100 Other Revenue 1,300,217 Licenses, Permits and Fees 12,397,400 Fines and Forfeitures 3,897,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 02/28/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 03/27/2018 10:48:27 AM Page 1 of 35 February YTD 2017 2018 2018 Actuals 99,830 201,241 933,020 - - - - - - - - - - - - - - - - - - 17 4,788 33,019 - - - - - - - - - 80 182 1,548 - - - - - - 99,926 206,210 967,586 26,738 46,983 282,139 43,647 89,945 579,392 - - - 3,813 6,653 42,833 - - - - - - - - - - - - (10) (10) 5,110 - - - 74,189 143,570 909,475 99,926 206,210 967,586 74,189 143,570 909,475 25,737 62,640 58,111 Starting Fund Balance 644,499 644,499 Net Change (312,421) 62,640 Ending Fund Balance 332,078 707,139 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 Debt Service - Miscellaneous 7,000 Interfund Transfers - Community Sponsored Organizations - Depreciation Expense - Contingencies - Services and Supplies 858,200 Capital Outlay - Insurance and Other Chargebacks 44,541 REVENUE TOTALS 953,500 EXPENSE Salary and Benefits 356,180 Interest Income 1,000 Special Assessment - Reappropriation of Surplus - Workers Compensation and Liability - Insurance - Library Revenue - Interfund Transfers - Intergovernmental Revenue - Other Revenue 27,500 Licenses, Permits and Fees - Fines and Forfeitures - Charges for Services - Fund 175 - GENERAL ASSISTANCE FUND REVENUE Property Taxes 925,000 Other Taxes - Budget by Organization Report Through 02/28/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 03/27/2018 10:48:27 AM Page 2 of 35 February YTD 2017 2018 2018 Actuals - - - 69,039 138,079 859,153 - - - - - - 8 18 14 69,047 138,097 859,167 - - 121 - - - 23,222 23,222 918,074 - - - 23,222 23,222 918,196 69,047 138,097 859,167 23,222 23,222 918,196 45,825 114,875 (59,029) Starting Fund Balance 11,777 11,777 Net Change (30,682) 114,875 Ending Fund Balance (18,905) 126,652 REVENUE TOTALS 828,471 EXPENSE TOTALS 859,153 Fund 176 - HEALTH AND HUMAN (30,682) EXPENSE TOTALS 859,153 Fund 176 - HEALTH AND HUMAN Capital Outlay - Community Sponsored Organizations - Miscellaneous - REVENUE TOTALS 828,471 EXPENSE Services and Supplies 859,153 Intergovernmental Revenue - Other Revenue - Interest Income - Fund 176 - HEALTH AND HUMAN SERVICES REVENUE Charges for Services - Interfund Transfers 828,471 Budget by Organization Report Through 02/28/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 03/27/2018 10:48:27 AM Page 3 of 35 February YTD 2017 2018 2018 Actuals - - 1,000,000 62 139 1,884 62 139 1,001,884 83,333 166,667 1,000,000 83,333 166,667 1,000,000 62 139 1,001,884 83,333 166,667 1,000,000 (83,271) (166,527) 1,884 Starting Fund Balance 1,884 1,884 Net Change - (166,527) Ending Fund Balance 1,884 (164,643) REVENUE TOTALS 1,000,000 EXPENSE TOTALS 1,000,000 Fund 180 - GOOD NEIGHBOR FUND Totals - EXPENSE TOTALS 1,000,000 Fund 180 - GOOD NEIGHBOR FUND Totals REVENUE TOTALS 1,000,000 EXPENSE Interfund Transfers 1,000,000 Fund 180 - GOOD NEIGHBOR FUND REVENUE Other Revenue 1,000,000 Interest Income - Budget by Organization Report Through 02/28/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 03/27/2018 10:48:27 AM Page 4 of 35 February YTD 2017 2018 2018 Actuals 681,400 1,373,392 6,370,507 - - - (170) 9,425 122,862 - 27 338 5,833 11,667 190,200 - 21,309 22,092 (94) 8,944 70,707 (24) 73,761 345,788 244 405 5,169 687,189 1,498,930 7,127,662 342,459 602,263 4,234,540 161,823 179,196 1,700,800 - - 9,904 43,020 75,042 504,605 - - - - - - - - - - - 22 30,579 61,158 343,618 577,881 917,659 6,793,489 687,189 1,498,930 7,127,662 577,881 917,659 6,793,489 109,307 581,271 334,173 Starting Fund Balance 984,772 984,772 Net Change 221,912 581,271 Ending Fund Balance 1,206,684 1,566,043 REVENUE TOTALS 7,693,209 EXPENSE TOTALS 7,471,297 Fund 185 - LIBRARY FUND Totals 221,912 EXPENSE TOTALS 7,471,297 Fund 185 - LIBRARY FUND Totals Debt Service - Miscellaneous - Interfund Transfers 366,949 Insurance and Other Chargebacks 493,468 Depreciation Expense - Contingencies - Salary and Benefits 4,595,792 Services and Supplies 2,004,688 Capital Outlay 10,400 Interest Income 5,400 REVENUE TOTALS 7,693,209 EXPENSE Intergovernmental Revenue 152,418 Other Revenue 130,000 Library Revenue 324,620 Fines and Forfeitures 130,000 Charges for Services - Interfund Transfers 265,771 Fund 185 - LIBRARY FUND REVENUE Property Taxes 6,685,000 Other Taxes - Budget by Organization Report Through 02/28/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 03/27/2018 10:48:27 AM Page 5 of 35 February YTD 2017 2018 2018 Actuals 31,097 63,147 338,897 - - 778,745 - - 7 31,097 63,147 1,117,649 - - 8,587 - - - - - 1,134,570 - - - - - 112 - - 1,143,269 31,097 63,147 1,117,649 - - 1,143,269 31,097 63,147 (25,619) Starting Fund Balance 4,202 4,202 Net Change 12,386 63,147 Ending Fund Balance 16,588 67,349 EXPENSE TOTALS 333,404 Fund 186 - LIBRARY DEBT SERVICE FUND 12,386 Fund 186 - LIBRARY DEBT SERVICE FUND REVENUE TOTALS 345,790 Miscellaneous - Interfund Transfers - EXPENSE TOTALS 333,404 Services and Supplies - Capital Outlay - Debt Service 333,404 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 02/28/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 03/27/2018 10:48:27 AM Page 6 of 35 February YTD 2017 2018 2018 Actuals - - - - - 1,431,106 - - - - - 1,431,106 - - 30,790 - - 1,091,917 - - - - - - - - 1,122,708 - - 1,431,106 - - 1,122,708 - - 308,399 Starting Fund Balance 308,399 308,399 Net Change - - Ending Fund Balance 308,399 308,399 Fund 187 - LIBRARY CAPITAL - Fund 187 - LIBRARY CAPITAL REVENUE TOTALS 10,095,000 EXPENSE TOTALS 10,095,000 Interfund Transfers - EXPENSE TOTALS 10,095,000 Services and Supplies - Capital Outlay 10,095,000 Debt Service - Interest Income - REVENUE TOTALS 10,095,000 EXPENSE Fund 187 - LIBRARY CAPITAL IMPROVEMENT FD REVENUE Property Taxes - Other Revenue 10,095,000 Budget by Organization Report Through 02/28/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 03/27/2018 10:48:27 AM Page 7 of 35 February YTD 2017 2018 2018 Actuals - - - - - 34,999 - - - 7 19 - 7 19 34,999 1,771 3,076 21,969 1,860 1,860 1,860 - - 2,642 361 632 4,252 - - - - - 2,400 388 776 4,518 4,380 6,343 37,641 7 19 34,999 4,380 6,343 37,641 (4,373) (6,324) (2,642) Starting Fund Balance (2,442) (2,442) Net Change 326 (6,324) Ending Fund Balance (2,116) (8,766) 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 Capital Outlay 7,000 Insurance and Other Chargebacks 4,267 Debt Service - EXPENSE Salary and Benefits 23,800 Services and Supplies 5,100 Other Revenue - Interest Income - REVENUE TOTALS 95,147 Fund 195 - NEIGHBORHOOD STABILIZATION FUND REVENUE Licenses, Permits and Fees - Intergovernmental Revenue 95,147 Budget by Organization Report Through 02/28/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 03/27/2018 10:48:27 AM Page 8 of 35 February YTD 2017 2018 2018 Actuals 168,507 333,095 1,899,884 - - - 2,734 6,558 18,158 - - - 171,241 339,653 1,918,041 - - - 125,000 250,000 - - - - - - - - - - 79,833 159,665 957,990 204,833 409,665 957,990 171,241 339,653 1,918,041 204,833 409,665 957,990 (33,591) (70,012) 960,051 Starting Fund Balance 2,373,729 2,373,729 Net Change (535,990) (70,012) Ending Fund Balance 1,837,739 2,303,717 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 Interfund Transfers 957,990 EXPENSE TOTALS 2,457,990 Contingencies - Debt Service - Miscellaneous - EXPENSE Services and Supplies - Capital Outlay 1,500,000 Interest Income 12,000 Reappropriation of Surplus - REVENUE TOTALS 1,922,000 Fund 200 - MOTOR FUEL TAX FUND REVENUE Intergovernmental Revenue 1,910,000 Other Revenue - Budget by Organization Report Through 02/28/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 03/27/2018 10:48:27 AM Page 9 of 35 February YTD 2017 2018 2018 Actuals 78,053 151,849 982,020 - - - - - - 733 1,443 7,178 78,786 153,292 989,198 40,770 71,919 507,288 3,346 6,774 239,161 - - 51,670 8,147 14,620 95,670 - - - - - - - - - - - - 6,114 12,228 72,977 58,376 105,541 966,766 78,786 153,292 989,198 58,376 105,541 966,766 20,409 47,750 22,432 Starting Fund Balance 185,493 185,493 Net Change 8,262 47,750 Ending Fund Balance 193,755 233,243 Fund 205 - EMERGENCY TELEPHONE 8,262 Fund 205 - EMERGENCY TELEPHONE REVENUE TOTALS 1,051,700 EXPENSE TOTALS 1,043,438 Interfund Transfers 73,366 EXPENSE TOTALS 1,043,438 Contingencies - Debt Service - Miscellaneous - Capital Outlay 55,000 Insurance and Other Chargebacks 97,125 Community Sponsored Organizations - EXPENSE Salary and Benefits 535,547 Services and Supplies 282,400 Other Revenue - Interest Income 1,000 REVENUE TOTALS 1,051,700 Fund 205 - EMERGENCY TELEPHONE (E911) FUND REVENUE Other Taxes 1,050,700 Intergovernmental Revenue - Budget by Organization Report Through 02/28/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 03/27/2018 10:48:27 AM Page 10 of 35 February YTD 2017 2018 2018 Actuals 18,028 18,028 322,477 0 0 5 18,029 18,029 322,482 - - 329,000 - - - - - - - - 329,000 18,029 18,029 322,482 - - 329,000 18,029 18,029 (6,518) Starting Fund Balance (198,794) (198,794) Net Change - 18,029 Ending Fund Balance (198,794) (180,765) EXPENSE TOTALS 370,000 Fund 210 - SPECIAL SERVICE AREA (SSA) - Fund 210 - SPECIAL SERVICE AREA (SSA) REVENUE TOTALS 370,000 Debt Service - Miscellaneous - EXPENSE 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 02/28/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 03/27/2018 10:48:27 AM Page 11 of 35 February YTD 2017 2018 2018 Actuals - - - - - - - - 1,906,708 113 713 262 - - - 113 713 1,906,970 27,209 47,541 361,255 1,887 2,929 3,797 - - 645,289 6,774 12,218 462,464 - - 318,412 - - - - - - - - 95,606 746 1,493 20,145 36,616 64,180 1,906,970 113 713 1,906,970 36,616 64,180 1,906,970 (36,503) (63,467) - Starting Fund Balance 64,094 64,094 Net Change (109,388) (63,467) Ending Fund Balance (45,294) 627 EXPENSE TOTALS 2,439,512 Fund 215 - CDBG FUND Totals (109,388) Fund 215 - CDBG FUND Totals REVENUE TOTALS 2,330,124 Miscellaneous 569,970 Interfund Transfers 949,656 EXPENSE TOTALS 2,439,512 Community Sponsored Organizations 175,500 Contingencies - Debt Service - Services and Supplies 220,840 Capital Outlay - Insurance and Other Chargebacks 91,176 REVENUE TOTALS 2,330,124 EXPENSE Salary and Benefits 432,370 Intergovernmental Revenue 2,330,124 Other Revenue - Interest Income - Fund 215 - CDBG FUND REVENUE Charges for Services - Interfund Transfers - Budget by Organization Report Through 02/28/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 03/27/2018 10:48:27 AM Page 12 of 35 February YTD 2017 2018 2018 Actuals - - - 2,985 5,895 51,369 54 143 3,391 3,039 6,037 54,760 - - - 11,340 11,393 13,070 - - - - - - 11,340 11,393 13,070 3,039 6,037 54,760 11,340 11,393 13,070 (8,302) (5,356) 41,690 Starting Fund Balance 252,611 252,611 Net Change - (5,356) Ending Fund Balance 252,611 247,255 Fund 220 - CDBG LOAN FUND Totals - Fund 220 - CDBG LOAN FUND Totals REVENUE TOTALS 293,000 EXPENSE TOTALS 293,000 Interfund Transfers - EXPENSE TOTALS 293,000 Salary and Benefits - Services and Supplies 293,000 Miscellaneous - Interest Income - REVENUE TOTALS 293,000 EXPENSE Fund 220 - CDBG LOAN FUND REVENUE Intergovernmental Revenue - Other Revenue 293,000 Budget by Organization Report Through 02/28/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 03/27/2018 10:48:27 AM Page 13 of 35 February YTD 2017 2018 2018 Actuals - - - - - - 10 22 256 10 22 256 - - - - - - - - - - - - - - - - - - 10 22 256 - - - 10 22 256 Starting Fund Balance 170,171 170,171 Net Change (100,000) 22 Ending Fund Balance 70,171 170,193 EXPENSE TOTALS 100,000 Fund 235 - NEIGHBORHOOD (100,000) Fund 235 - NEIGHBORHOOD REVENUE TOTALS - Miscellaneous 100,000 Interfund Transfers - EXPENSE TOTALS 100,000 Services and Supplies - Capital Outlay - Debt Service - Interest Income - REVENUE TOTALS - EXPENSE Fund 235 - NEIGHBORHOOD IMPROVEMENT REVENUE Other Taxes - Interfund Transfers - Budget by Organization Report Through 02/28/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 03/27/2018 10:48:27 AM Page 14 of 35 February YTD 2017 2018 2018 Actuals - - 227,450 2,282 4,564 21,820 0 17 5,685 2,282 4,581 254,955 3,249 5,641 39,955 23,689 23,889 231,806 - - - 393 705 (23,832) - - - - - - - - 126 - - - 27,331 30,235 248,055 2,282 4,581 254,955 27,331 30,235 248,055 (25,049) (25,654) 6,900 Starting Fund Balance 9,277 9,277 Net Change 615 (25,654) Ending Fund Balance 9,892 (16,377) EXPENSE TOTALS 588,321 Fund 240 - HOME FUND Totals 615 Fund 240 - HOME FUND Totals REVENUE TOTALS 588,936 Miscellaneous 500 Interfund Transfers - EXPENSE TOTALS 588,321 Insurance and Other Chargebacks 4,657 Community Sponsored Organizations - Debt Service - Salary and Benefits 42,964 Services and Supplies 540,200 Capital Outlay - Interest Income - REVENUE TOTALS 588,936 EXPENSE Fund 240 - HOME FUND REVENUE Intergovernmental Revenue 588,936 Other Revenue - Budget by Organization Report Through 02/28/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 03/27/2018 10:48:27 AM Page 15 of 35 February YTD 2017 2018 2018 Actuals - - 97,000 - - - - - - 417 32,083 333,056 465 930 5,623 882 33,014 435,678 6,720 11,312 40,348 - - 209,772 - - - 692 1,165 15,617 - - 8,927 - - - 900 900 85,660 - - - 8,311 13,376 360,323 882 33,014 435,678 8,311 13,376 360,323 (7,429) 19,637 75,355 Starting Fund Balance 1,476,543 1,476,543 Net Change (38,470) 19,637 Ending Fund Balance 1,438,073 1,496,180 Fund 250 - AFFORDABLE HOUSING FUND (38,470) Fund 250 - AFFORDABLE HOUSING FUND REVENUE TOTALS 450,830 EXPENSE TOTALS 489,300 Interfund Transfers - EXPENSE TOTALS 489,300 Community Sponsored Organizations 70,000 Debt Service - Miscellaneous 43,000 Services and Supplies 279,500 Capital Outlay - Insurance and Other Chargebacks 3,837 REVENUE TOTALS 450,830 EXPENSE Salary and Benefits 92,963 Intergovernmental Revenue - Other Revenue 400,600 Interest Income 230 Fund 250 - AFFORDABLE HOUSING FUND REVENUE Other Taxes 50,000 Interfund Transfers - Budget by Organization Report Through 02/28/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 03/27/2018 10:48:27 AM Page 16 of 35 February YTD 2017 2018 2018 Actuals 1,402,130 1,693,597 5,249,949 - - - - - - - - - 1,396 4,258 45,924 1,403,526 1,697,855 5,295,873 - - - - - 2,007 - - - - - - - - 98,672 592,253 1,184,507 5,557,325 592,253 1,184,507 5,658,005 1,403,526 1,697,855 5,295,873 592,253 1,184,507 5,658,005 811,272 513,348 (362,132) Starting Fund Balance 5,262,544 5,262,544 Net Change (3,437,040) 513,348 Ending Fund Balance 1,825,504 5,775,892 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 Services and Supplies 2,000,000 Capital Outlay - Debt Service - REVENUE TOTALS 5,770,000 EXPENSE Salary and Benefits - Interfund Transfers - Other Revenue - Interest Income 20,000 Fund 300 - WASHINGTON NATIONAL TIF FUND REVENUE Property Taxes 5,750,000 Other Taxes - Budget by Organization Report Through 02/28/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 03/27/2018 10:48:27 AM Page 17 of 35 February YTD 2017 2018 2018 Actuals 970,589 1,906,066 10,797,411 288,930 577,859 2,850,236 7,219 14,437 83,293 - - 8,883,103 2,496 5,157 36,782 1,269,233 2,503,519 22,650,825 - - 100,625 - - 23,099,797 - - (57) - - - - - 23,200,365 1,269,233 2,503,519 22,650,825 - - 23,200,365 1,269,233 2,503,519 (549,540) Starting Fund Balance 196,457 196,457 Net Change 274,759 2,503,519 Ending Fund Balance 471,216 2,699,976 REVENUE TOTALS 14,572,016 EXPENSE TOTALS 14,297,257 Fund 320 - DEBT SERVICE FUND Totals 274,759 EXPENSE TOTALS 14,297,257 Fund 320 - DEBT SERVICE FUND Totals Debt Service 14,177,257 Miscellaneous - Interfund Transfers - REVENUE TOTALS 14,572,016 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,607,231 Budget by Organization Report Through 02/28/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 03/27/2018 10:48:27 AM Page 18 of 35 February YTD 2017 2018 2018 Actuals 20,772 20,772 583,827 - - 32,000 - - 22 20,772 20,772 615,848 - - 307,391 125,000 250,000 - - - - - - - 108 206 995 - - - 5,000 10,000 60,000 130,108 260,206 368,386 20,772 20,772 615,848 130,108 260,206 368,386 (109,336) (239,434) 247,462 Starting Fund Balance 273,878 273,878 Net Change (296,100) (239,434) Ending Fund Balance (22,222) 34,444 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 Community Sponsored Organizations - Debt Service 960,000 Miscellaneous - Services and Supplies 461,500 Capital Outlay 3,200,000 Insurance and Other Chargebacks - 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 02/28/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 03/27/2018 10:48:27 AM Page 19 of 35 February YTD 2017 2018 2018 Actuals 2,556 7,270 43,503 1,028 1,028 12,339 508 749 3,898 4,092 9,047 59,741 - - 2,007 - - - - - - - - - 1,325 2,532 12,227 - - - 2,500 5,000 30,000 3,825 7,532 44,235 4,092 9,047 59,741 3,825 7,532 44,235 268 1,515 15,506 Starting Fund Balance 432,766 432,766 Net Change (39,850) 1,515 Ending Fund Balance 392,916 434,281 Fund 335 - WEST EVANSTON TIF FUND (39,850) Fund 335 - WEST EVANSTON TIF FUND REVENUE TOTALS 150 EXPENSE TOTALS 40,000 Interfund Transfers 30,000 EXPENSE TOTALS 40,000 Contingencies - Debt Service 10,000 Miscellaneous - Services and Supplies - Capital Outlay - Insurance and Other Chargebacks - Interest Income 150 REVENUE TOTALS 150 EXPENSE Fund 335 - WEST EVANSTON TIF FUND REVENUE Property Taxes - Other Revenue - Budget by Organization Report Through 02/28/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 03/27/2018 10:48:27 AM Page 20 of 35 February YTD 2017 2018 2018 Actuals 26,401 26,401 48,001 - - 2,067,512 - - 1 26,401 26,401 2,115,514 - - 38,588 - - 2,000,000 - - 53,521 - - 2,092,108 26,401 26,401 2,115,514 - - 2,092,108 26,401 26,401 23,406 Starting Fund Balance (6,009) (6,009) Net Change 202,334 26,401 Ending Fund Balance 196,325 20,392 REVENUE TOTALS 275,000 EXPENSE TOTALS 72,666 Fund 340 - DEMPSTER-DODGE TIF FUND 202,334 EXPENSE TOTALS 72,666 Fund 340 - DEMPSTER-DODGE TIF FUND Services and Supplies - Capital Outlay - Debt Service 72,666 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 02/28/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 03/27/2018 10:48:27 AM Page 21 of 35 February YTD 2017 2018 2018 Actuals 17,999 17,999 75,430 - - 3,520,189 1 1 9 18,000 18,000 3,595,628 - - 58,113 - - 3,580,000 - - 31,398 - - 3,669,511 18,000 18,000 3,595,628 - - 3,669,511 18,000 18,000 (73,884) Starting Fund Balance 61,193 61,193 Net Change 316,001 18,000 Ending Fund Balance 377,194 79,193 REVENUE TOTALS 425,000 EXPENSE TOTALS 108,999 Fund 345 - CHICAGO-MAIN TIF Totals 316,001 EXPENSE TOTALS 108,999 Fund 345 - CHICAGO-MAIN TIF Totals 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 02/28/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 03/27/2018 10:48:27 AM Page 22 of 35 February YTD 2017 2018 2018 Actuals 29,735 35,571 215,245 1 1 21 29,736 35,572 215,266 - - 213,354 - - 78,000 - - 291,354 29,736 35,572 215,266 - - 291,354 29,736 35,572 (76,088) Starting Fund Balance 2,206 2,206 Net Change - 35,572 Ending Fund Balance 2,206 37,778 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 02/28/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 03/27/2018 10:48:27 AM Page 23 of 35 February YTD 2017 2018 2018 Actuals - - 359,706 - - 33,339 536,667 1,073,333 787,177 - - 530,812 - - 11,246,149 8,767 15,523 56,607 545,434 1,088,856 13,013,790 46,369 71,392 4,715 159,752 15,953 1,672,608 613,886 506,884 13,443,314 5,418 8,804 677 - - - - - - 41,667 83,333 500,000 867,092 686,367 15,621,313 545,434 1,088,856 13,013,790 867,092 686,367 15,621,313 (321,658) 402,489 (2,607,523) Starting Fund Balance 9,447,356 9,447,356 Net Change (7,655,527) 402,489 Ending Fund Balance 1,791,829 9,849,845 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 Insurance and Other Chargebacks - Debt Service - Miscellaneous - 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 02/28/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 03/27/2018 10:48:27 AM Page 24 of 35 February YTD 2017 2018 2018 Actuals - - 649,512 - - 900,000 - - - - - 1,549,512 146,799 146,799 638,727 - - 369,924 - - - 146,799 146,799 1,008,651 - - 1,549,512 146,799 146,799 1,008,651 (146,799) (146,799) 540,861 Starting Fund Balance 540,681 540,681 Net Change 1,866,000 (146,799) Ending Fund Balance 2,406,681 393,882 REVENUE TOTALS 11,500,000 EXPENSE TOTALS 9,634,000 Fund 416 - CROWN CONSTRUCTION FUND 1,866,000 EXPENSE TOTALS 9,634,000 Fund 416 - CROWN CONSTRUCTION FUND Services and Supplies 1,634,000 Capital Outlay 8,000,000 Interfund Transfers - Interest Income - REVENUE TOTALS 11,500,000 EXPENSE Fund 416 - CROWN CONSTRUCTION FUND REVENUE Interfund Transfers - Other Revenue 11,500,000 Budget by Organization Report Through 02/28/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 03/27/2018 10:48:27 AM Page 25 of 35 February YTD 2017 2018 2018 Actuals - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 874 7,582 31,203 13,550 53,029 237,016 - - - 14,424 60,611 268,219 4,898 8,696 612 - - 5,613 - - - 661 1,073 83 - - - - - - 42,786 85,571 263,427 48,344 95,340 269,734 14,424 60,611 268,219 48,344 95,340 269,734 (33,920) (34,729) (1,516) Starting Fund Balance 2,997,700 2,997,700 Net Change (123,850) (34,729) Ending Fund Balance 2,873,850 2,962,971 REVENUE TOTALS 461,367 EXPENSE TOTALS 585,217 Fund 420 - SPECIAL ASSESSMENT FUND (123,850) EXPENSE TOTALS 585,217 Fund 420 - SPECIAL ASSESSMENT FUND Debt Service - Miscellaneous - Interfund Transfers 513,427 Services and Supplies - Capital Outlay - Insurance and Other Chargebacks - REVENUE TOTALS 461,367 EXPENSE Salary and Benefits 71,790 Interest Income 31,200 Special Assessment 180,167 Reappropriation of Surplus - Workers Compensation and Liability - Insurance - Library Revenue - Interfund Transfers - Intergovernmental Revenue - Other Revenue 250,000 Licenses, Permits and Fees - Fines and Forfeitures - Charges for Services - Fund 420 - SPECIAL ASSESSMENT FUND REVENUE Property Taxes - Other Taxes - Budget by Organization Report Through 02/28/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 03/27/2018 10:48:27 AM Page 26 of 35 February YTD 2017 2018 2018 Actuals - - - - - - - 913 1,900 - - - 469,763 883,415 6,303,624 347,253 694,507 4,120,636 - - - 14,089 44,668 224,872 3,368 6,726 62,067 834,474 1,630,228 10,713,099 116,399 199,385 1,267,442 248,949 287,682 3,140,005 - - 2,341,090 43,593 83,619 552,831 - - - - - - - - 4,246 - - 4,330,993 19,070 19,070 267,436 120,035 240,070 1,584,683 548,045 829,826 13,488,725 834,474 1,630,228 10,713,099 548,045 829,826 13,488,725 286,429 800,403 (2,775,627) Starting Fund Balance 4,909,402 4,909,402 Net Change (1,762,367) 800,403 Ending Fund Balance 3,147,035 5,709,805 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 Interfund Transfers 1,440,417 EXPENSE TOTALS 12,896,493 Contingencies 11,000 Debt Service 3,070,625 Miscellaneous 304,000 Insurance and Other Chargebacks 557,598 Community Sponsored Organizations - Depreciation Expense - Salary and Benefits 1,611,078 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 Licenses, Permits and Fees - Fines and Forfeitures - Charges for Services 6,676,575 Fund 505 - PARKING SYSTEM FUND REVENUE Property Taxes - Other Taxes - Budget by Organization Report Through 02/28/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 03/27/2018 10:48:27 AM Page 27 of 35 February YTD 2017 2018 2018 Actuals - - - 1,170 2,515 86,063 1,414,086 3,011,946 17,258,865 - - - - - - (340) 6,261 1,266,352 3,718 7,586 34,587 1,418,634 3,028,307 18,645,866 355,451 648,317 4,639,636 283,267 295,829 3,349,828 38,927 38,927 3,436,079 90,418 169,080 1,158,869 - - - - - - - - - - - 1,631,712 - - (227,922) 306,859 613,718 6,327,314 1,074,923 1,765,872 20,315,515 1,418,634 3,028,307 18,645,866 1,074,923 1,765,872 20,315,515 343,711 1,262,436 (1,669,650) Starting Fund Balance 7,324,987 7,324,987 Net Change 32,150 1,262,436 Ending Fund Balance 7,357,137 8,587,423 EXPENSE TOTALS 45,663,506 Fund 510 - WATER FUND Totals 32,150 Fund 510 - WATER FUND Totals REVENUE TOTALS 45,695,656 Miscellaneous 15,000 Interfund Transfers 3,602,313 EXPENSE TOTALS 45,663,506 Depreciation Expense - Contingencies 1,000 Debt Service 1,960,760 Capital Outlay 29,346,200 Insurance and Other Chargebacks 1,161,384 Community Sponsored Organizations - EXPENSE Salary and Benefits 4,921,439 Services and Supplies 4,655,410 Other Revenue 27,333,656 Interest Income 25,000 REVENUE TOTALS 45,695,656 Charges for Services 18,267,000 Interfund Transfers - Intergovernmental Revenue - Fund 510 - WATER FUND REVENUE Other Taxes - Licenses, Permits and Fees 70,000 Budget by Organization Report Through 02/28/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 03/27/2018 10:48:27 AM Page 28 of 35 February YTD 2017 2018 2018 Actuals 977,029 2,848,949 12,477,657 - - - - - 2 1,410 3,022 16,023 978,439 2,851,971 12,493,682 85,970 155,162 987,901 4,231 4,231 987,884 - - 1,227,662 34,359 66,929 437,253 - - - - - - 205,395 570,094 1,541,842 - - - 82,640 165,280 1,141,676 412,594 961,696 6,324,218 978,439 2,851,971 12,493,682 412,594 961,696 6,324,218 565,845 1,890,275 6,169,464 Starting Fund Balance 4,149,927 4,149,927 Net Change (119,220) 1,890,275 Ending Fund Balance 4,030,707 6,040,202 Fund 515 - SEWER FUND Totals (119,220) Fund 515 - SEWER FUND Totals REVENUE TOTALS 14,698,650 EXPENSE TOTALS 14,817,870 Interfund Transfers 991,677 EXPENSE TOTALS 14,817,870 Contingencies - Debt Service 7,540,066 Miscellaneous 1,500 Capital Outlay 2,181,300 Insurance and Other Chargebacks 421,010 Depreciation Expense - EXPENSE Salary and Benefits 1,123,687 Services and Supplies 2,558,630 Other Revenue 2,104,000 Interest Income 5,000 REVENUE TOTALS 14,698,650 Fund 515 - SEWER FUND REVENUE Charges for Services 12,589,650 Interfund Transfers - Budget by Organization Report Through 02/28/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 03/27/2018 10:48:27 AM Page 29 of 35 February YTD 2017 2018 2018 Actuals - - - - - 199,513 302,339 592,415 3,611,308 (29,167) 117,661 755,967 - - - 542 1,332 250,687 - - - 273,714 711,408 4,817,475 63,529 107,720 659,079 279,232 446,215 3,482,141 - - 24,635 8,991 16,374 116,954 - - - - - - - - - - - 21,046 - - 3,057 26,864 53,727 504,807 378,616 624,036 4,811,719 273,714 711,408 4,817,475 378,616 624,036 4,811,719 (104,902) 87,373 5,756 Starting Fund Balance (1,169,015) (1,169,015) Net Change 151,660 87,373 Ending Fund Balance (1,017,355) (1,081,642) 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 Depreciation Expense - Contingencies - Debt Service 21,797 Capital Outlay 275,750 Insurance and Other Chargebacks 122,247 Community Sponsored Organizations - EXPENSE Salary and Benefits 871,369 Services and Supplies 3,488,676 Other Revenue 238,000 Interest Income - REVENUE TOTALS 5,261,361 Charges for Services 3,632,394 Interfund Transfers 705,967 Intergovernmental Revenue - Fund 520 - SOLID WASTE FUND REVENUE Property Taxes 410,000 Licenses, Permits and Fees 275,000 Budget by Organization Report Through 02/28/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 03/27/2018 10:48:27 AM Page 30 of 35 February YTD 2017 2018 2018 Actuals 249,053 498,107 2,478,435 - - - - - - 4,942 4,942 19,016 11 24 339 254,006 503,073 2,497,791 72,354 124,639 953,736 219,204 243,327 1,736,789 - - - 11,994 22,052 191,454 - - - - - - - - - - - - 2,787 5,574 27,833 306,338 395,591 2,909,812 254,006 503,073 2,497,791 306,338 395,591 2,909,812 (52,332) 107,481 (412,022) Starting Fund Balance 358,236 358,236 Net Change (192,655) 107,481 Ending Fund Balance 165,581 465,717 EXPENSE TOTALS 3,333,871 Fund 600 - FLEET SERVICES FUND Totals (192,655) Fund 600 - FLEET SERVICES FUND Totals REVENUE TOTALS 3,141,216 Miscellaneous - Interfund Transfers 33,442 EXPENSE TOTALS 3,333,871 Depreciation Expense - Contingencies 450 Debt Service - Services and Supplies 2,230,057 Capital Outlay - Insurance and Other Chargebacks 185,266 REVENUE TOTALS 3,141,216 EXPENSE Salary and Benefits 884,656 Intergovernmental Revenue - Other Revenue 81,781 Interest Income 1,000 Fund 600 - FLEET SERVICES FUND REVENUE Charges for Services 3,058,435 Interfund Transfers - Budget by Organization Report Through 02/28/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 03/27/2018 10:48:27 AM Page 31 of 35 February YTD 2017 2018 2018 Actuals 111,228 222,455 1,400,057 - - - 3,786 - 88,015 60 135 2,128 115,074 222,590 1,490,200 1,855 1,855 74,539 112,863 112,863 42,159 - - - - - - 114,718 114,718 116,698 115,074 222,590 1,490,200 114,718 114,718 116,698 356 107,872 1,373,502 Starting Fund Balance 1,076,977 1,076,977 Net Change (20,147) 107,872 Ending Fund Balance 1,056,830 1,184,849 EXPENSE TOTALS 1,597,977 Fund 601 - EQUIPMENT REPLACEMENT (20,147) Fund 601 - EQUIPMENT REPLACEMENT REVENUE TOTALS 1,577,830 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,577,830 Fund 601 - EQUIPMENT REPLACEMENT FUND REVENUE Charges for Services 1,367,613 Interfund Transfers - Budget by Organization Report Through 02/28/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 03/27/2018 10:48:27 AM Page 32 of 35 February YTD 2017 2018 2018 Actuals 16,845 32,349 162,411 68 137 2,300,820 - - - 874,744 1,523,891 10,917,001 169,360 341,589 1,032,678 426,431 845,152 5,620,181 35 209 382 1,487,483 2,743,327 20,033,473 55,401 100,218 534,038 166,771 168,106 4,969,432 - - - 1,370,768 2,791,580 16,774,833 - - - - - - - - - - - - - - - 803 1,605 9,632 1,593,744 3,061,510 22,287,935 1,487,483 2,743,327 20,033,473 1,593,744 3,061,510 22,287,935 (106,260) (318,183) (2,254,462) Starting Fund Balance (5,348,035) (5,348,035) Net Change 653,342 (318,183) Ending Fund Balance (4,694,693) (5,666,218) EXPENSE TOTALS 18,439,931 Fund 605 - INSURANCE FUND Totals 653,342 Fund 605 - INSURANCE FUND Totals REVENUE TOTALS 19,093,273 Miscellaneous - Interfund Transfers 9,632 EXPENSE TOTALS 18,439,931 Depreciation Expense - Contingencies - Debt Service - Capital Outlay - Insurance and Other Chargebacks 15,387,920 Community Sponsored Organizations - EXPENSE Salary and Benefits 656,931 Services and Supplies 2,385,448 Insurance 5,815,014 Interest Income 1,000 REVENUE TOTALS 19,093,273 Intergovernmental Revenue - Other Revenue 10,858,534 Workers Compensation and Liability 2,196,415 Fund 605 - INSURANCE FUND REVENUE Charges for Services 162,411 Interfund Transfers 59,899 Budget by Organization Report Through 02/28/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 03/27/2018 10:48:27 AM Page 33 of 35 February YTD 2017 2018 2018 Actuals - - - - - - - - - 790,595 3,842,258 15,218,533 90,621 277,267 2,072,811 881,216 4,119,525 17,291,343 748,265 1,494,254 8,682,009 - - - - - - - - - 18,498 28,822 136,256 766,762 1,523,076 8,818,265 881,216 4,119,525 17,291,343 766,762 1,523,076 8,818,265 114,454 2,596,449 8,473,079 Starting Fund Balance 79,101,435 79,101,435 Net Change 4,989,947 2,596,449 Ending Fund Balance 84,091,382 81,697,884 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 Miscellaneous - EXPENSE TOTALS 8,795,000 Services and Supplies - Community Sponsored Organizations - Debt Service - REVENUE TOTALS 13,784,947 EXPENSE Salary and Benefits 8,795,000 Interfund Transfers 10,000 Other Revenue 9,394,947 Interest Income 4,100,000 Fund 700 - FIRE PENSION FUND REVENUE Property Taxes - Other Taxes 280,000 Budget by Organization Report Through 02/28/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 03/27/2018 10:48:27 AM Page 34 of 35 February YTD 2017 2018 2018 Actuals - - - - - - - - - (2,426,566) 1,854,899 24,497,048 183,302 304,730 2,830,019 (2,243,263) 2,159,629 27,327,068 987,497 1,971,167 11,624,574 - - - - - - - 60,238 264,371 987,497 2,031,405 11,888,945 (2,243,263) 2,159,629 27,327,068 987,497 2,031,405 11,888,945 (3,230,760) 128,224 15,438,122 Starting Fund Balance 121,645,511 121,645,511 Net Change 6,194,704 128,224 Ending Fund Balance 127,840,215 121,773,735 REVENUE TOTALS 18,719,704 EXPENSE TOTALS 12,525,000 Fund 705 - POLICE PENSION FUND Totals 6,194,704 EXPENSE TOTALS 12,525,000 Fund 705 - POLICE PENSION FUND Totals Services and Supplies - Debt Service - Miscellaneous 270,000 REVENUE TOTALS 18,719,704 EXPENSE Salary and Benefits 12,255,000 Interfund Transfers 57,000 Other Revenue 12,162,704 Interest Income 6,500,000 Fund 705 - POLICE PENSION FUND REVENUE Property Taxes - Other Taxes - Budget by Organization Report Through 02/28/18 Prior Fiscal Year Activity Included2018 Classification Budget Run by Kate LewisLakin on 03/27/2018 10:48:27 AM Page 35 of 35