Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2017.11 November Monthly Report
YTD Revenues YTD Expenses YTD Net Fund Balance Cash Balance 100,726,239 102,225,986 (1,499,747) 13,093,607 7,340,223 965,926 816,593 149,333 735,721 735,721 787,571 714,821 72,750 72,750 143,556 1,001,428 916,667 84,761 84,761 1,084,761 6,810,637 5,913,709 896,928 1,547,583 1,547,545 178 34,456 (34,278) (34,278) 98,132 1,759,882 786,491 973,391 2,387,069 2,210,369 923,509 855,825 67,684 230,745 (94,727) 322,482 329,000 (6,518) (198,794) (198,794) 263,188 1,174,312 (911,124) (847,018) (847,018) 92,332 31,245 61,087 272,008 272,008 194 - 194 170,109 170,109 328,494 358,138 (29,644) (27,267) (27,267) 207,393 320,731 (113,338) 1,287,850 1,287,850 1,117,649 1,153,592 (35,943) (6,234) (19,140) 5,284,281 5,478,552 (194,271) 5,430,405 5,509,324 (44,005) 599,668 (643,672) - - 642,348 362,683 279,665 279,581 281,850 58,136 40,328 17,808 435,068 443,390 2,115,514 2,092,108 23,406 (6,009) (6,009) 3,595,628 3,669,221 (73,594) 61,483 61,483 214,913 213,354 1,559 79,853 79,853 1,431,106 1,037,798 393,308 393,308 393,308 22,338,391 23,291,775 (953,385) (207,388) (192,591) 13,418,098 12,399,693 1,018,405 12,523,569 13,047,631 1,400,000 - 1,400,000 1,400,000 1,400,000 218,645 247,088 (28,442) 2,970,774 2,967,237 10,099,302 12,351,365 (2,252,063) 5,500,601 5,125,372 18,703,934 15,613,188 3,090,747 10,626,825 7,777,896 11,455,109 11,406,233 48,875 4,660,973 2,835,650 4,465,744 4,185,053 280,692 (692,091) (1,265,121) 2,839,129 2,646,216 192,913 955,657 247,962 1,339,460 699,523 639,938 1,525,271 1,525,271 16,005,534 17,920,494 (1,914,959) (4,911,984) (1,321,616) 230,888,370 229,885,905 1,002,466 59,294,508 52,114,218 601 EQUIPMENT REPLACEMENT 605 INSURANCE FUND 510 WATER FUND 515 SEWER FUND 600 FLEET SERVICES FUND 520 SOLID WASTE FUND 415 CAPITAL IMPROVEMENTS FUND 420 SPECIAL ASSESSMENT FUND 505 PARKING SYSTEM FUND 350 SPECIAL SERVICE AREA (SSA) 187 LIBRARY CAPITAL 320 DEBT SERVICE FUND 186 LIBRARY DEBT SERVICE FUND 416 CROWN CONSTRUCTION FUND 300 WASHINGTON NATIONAL TIF 310 HOWARD-HARTREY TIF 330 HOWARD-RIDGE TIF FUND 335 WEST EVANSTON TIF FUND 340 DEMPSTER-DODGE TIF FUND 345 CHICAGO-MAIN TIF 235 NEIGHBORHOOD IMPROVEMENT 240 HOME FUND 250 AFFORDABLE HOUSING FUND 210 SPECIAL SERVICE AREA (SSA) 215 CDBG FUND 220 CDBG LOAN 195 NEIGHBORHOOD 200 MOTOR FUEL TAX FUND 205 EMERGENCY TELEPHONE (E911) 176 HEALTH AND HUMAN SERVICES 180 GOOD NEIGHBOR FUND 185 LIBRARY FUND Fund Fund Description 100 GENERAL FUND 175 GENERAL ASSISTANCE FUND To: Wally Bobkiewicz, City Manager Martin Lyons, Assistant City Manager/Chief Financial Officer From: Ashley King, Finance & Budget Manager Subject: November 2017 Monthly Financial Report Date: January 4, 2018 Please find attached the unaudited financial statements as of November 30, 2017. A summary by fund for revenues, expenditures, fund and cash balances is as follows: Memorandum Included above are the ending balances as of November 30, 2017 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 propert y tax) due to the City and accounts payable/accrued expenses. As of November 30, 2017, the General Fund is reporting a net deficit of $1,499,747. The General Fund balance is $13,093,607 with a cash balance of $7,340,223. The attached supplemental charts show the General Fund Revenues at 84.80% of budget and expenses slightly higher at 86.13%. This does include changes to interfund transfers proposed by staff in July 2017. Staff will continue to monitor the General Fund through the close of the year and will provide an update on any final budget balancing measures taken. Both revenues and expenses are substantially under budget through November 30, 2017. Through November 30, 2017, the Neighborhood Stabilization Fund is showing a negative fund balance of $34,278. This is due to the timing of grant funding revenues. Through November 30, 2017, the E911 Fund is showing negative cash balance of $94,727. This is due to timing of E911 revenues from the state and the expen ses related to the replacement of Computer Aided Dispatch (CAD) and Police/Fire Records Software. Staff will monitor the fund for the remainder of the year to ensure a positive ending balance. Through November 30, 2017, the SSA #4 Fund is showing a negative fund and cash balance of $198,794. This is due to the timing of payments to the Downtown Evanston group. Through November 30, 2017, the CDBG Fund is showing a negative fund and cash balance of $847,018. This has since been reimbursed by $1,391,841 in revenue received in December 2017. The new revenue will be reflected in the December monthly report. Through November 30, 2017, the Home Fund is showing a negative fund and cash balance of $27,267. This is reimbursed with draw-downs in December. Staff will monitor the fund for the remainder of the year to ensure a positive ending balance Through November 30, 2017, the Library Debt Service Fund has a negative fund balance of $6,234 and a negative fund balance of $19,140. This is due to the inclusion of bond issuance costs for the 2017A Bonds, which will be moved to the Library Capital Improvements Fund. Jan Feb Mar Apr May Jun Jul Aug Sept October November 2016 Unreserved Fund Balance 11,859,782 14,097,256 17,193,730 16,597,583 18,375,173 21,225,995 15,790,000 17,674,579 15,983,833 12,732,816 13,695,971 2017 Unreserved Fund Balance 15,453,984 17,244,431 19,734,012 18,292,843 17,839,404 14,612,957 13,603,487 16,910,096 14,723,355 14,354,436 13,093,607 2016 Cash Balance 3,656,830 2,587,845 8,182,090 7,808,208 7,101,333 12,919,440 10,046,315 10,473,240 9,442,294 7,391,338 6,849,781 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 7,340,223 2016 v 2017 Fund and Cash Balance-- General Fund - 5,000,000 10,000,000 15,000,000 20,000,000 25,000,000 2016 Unreserved Fund Balance 2017 Unreserved Fund Balance 2016 Cash Balance 2017 Cash Balance Fund 100 - GENERAL FUND 2017 November YTD 2016 Budget 2017 Actual %Actual 28,639,628 48,872 28,294,363 98.79% 27,302,687 49,402,274 3,218,956 41,713,696 84.44% 44,156,868 5,496,150 926,389 3,365,473 61.23% 6,851,422 11,648,000 374,860 6,736,964 57.84% 11,012,646 115,500 45,536 202,350 175.19% 70,395 3,810,000 300,222 3,118,295 81.85% 3,611,901 640,000 53,333 608,881 95.14% 687,835 5,650,895 204,730 5,283,693 93.50% 5,401,563 2,642,500 221,935 2,288,520 86.60% 2,687,897 7,455,774 606,476 6,671,240 89.48% 8,099,626 1,089,965 97,962 1,235,582 113.36% 1,238,785 2,138,046 192,877 1,171,691 54.80% 1,338,382 50,100 282 35,490 70.84% 30,285 REVENUE TOTAL 118,778,832 6,292,430 100,726,239 84.80% 112,490,292 CITY COUNCIL 498,189 39,068 434,650 87.25% 433,601 CITY CLERK 275,488 15,083 228,727 83.03% 294,665 CITY MANAGER'S OFFICE 9,878,454 512,805 6,169,152 62.45% 7,471,734 LAW 854,050 57,480 671,694 78.65% 1,052,130 ADMINISTRATIVE SERVICES 9,700,879 844,692 7,980,354 82.26% 9,164,947 COMMUNITY DEVELOPMENT 2,804,668 235,598 2,215,719 79.00% 2,510,408 POLICE 38,223,842 2,349,852 35,441,756 92.72% 37,817,627 FIRE MGMT & SUPPORT 24,294,001 1,325,079 22,272,535 91.68% 23,235,714 HEALTH 3,582,312 228,472 2,722,548 76.00% 3,097,351 PARKS, REC. AND COMMUNITY SERV. 12,361,460 849,361 11,078,600 89.62% 11,997,476 PUBLIC WORKS AGENCY 16,212,848 1,095,769 13,010,251 80.25% 14,488,137 EXPENSE TOTAL 118,686,191 7,553,259 102,225,986 86.13% 111,563,790 118,778,832 6,292,430 100,726,239 84.80% 112,490,292 118,686,191 7,553,259 102,225,986 86.13% 111,563,790 92,641 (1,260,829) (1,499,747) 926,503 REVENUE TOTALS EXPENSE TOTALS Fund 100 - GENERAL FUND Net Gain (Loss) 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 Fines and Forfeitures Property Taxes Other Taxes License Intergovernmental Revenue November 2017 Report Through 11/30/17 Classification Permit Fee Fund 505 - PARKING SYSTEM FUND 2017 November YTD 2016 Budget 2017 Actual %Actual - - 1,900 0.00% 3,350 6,737,875 705,988 5,659,903 84.00% 6,340,992 65,000 - 61,000 93.85% 168,500 4,120,636 2,060,318 4,120,636 100.00% 3,711,768 12,125 - - 0.00% - 203,216 22,352 213,638 105.13% 195,895 35,070 1,298 42,225 120.40% 38,159 REVENUE TOTAL 11,173,922 2,789,956 10,099,302 90.38% 10,458,663 26,000 641 23,767 91.41% 26,465 1,117,119 97,214 963,891 86.28% 1,206,649 104,802 8,970 90,497 86.35% 229,588 3,222,411 202,462 2,642,648 82.01% 2,846,933 278,864 6,923 164,711 59.06% 237,610 3,020,000 360,695 2,250,540 74.52% (24,598) 524,102 47,883 501,316 95.65% 504,784 - - - 0.00% 2,836,672 11,000 1,642 4,246 38.60% 5,910 4,331,771 4,015,465 4,330,993 99.98% 390,235 304,000 - 210,298 69.18% 255,626 1,584,683 106,224 1,168,460 73.73% 1,303,783 EXPENSE TOTAL 14,524,752 4,848,118 12,351,365 85.04% 9,819,656 11,173,922 2,789,956 10,099,302 90.38% 10,458,663 14,524,752 4,848,118 12,351,365 85.04% 9,819,656 (3,350,830) (2,058,162) (2,252,063) 639,007 REVENUE TOTALS EXPENSE TOTALS Fund 505 - PARKING SYSTEM FUND Net Gain Debt Service Miscellaneous Interfund Transfers Fund 505 - PARKING SYSTEM FUND Totals Capital Outlay Insurance and Other Chargebacks Depreciation Expense Contingencies Pensions Services Supplies Interest Income Employee Pay Benefits Parking Charges for Services Parks and Recreation Charges for Services Interfund Transfers Intergovernmental Revenue Permit November 2017 Report Through 11/30/17 Classification Other Revenue Fund 510 - WATER FUND 2017 November YTD 2016 Budget 2017 Actual %Actual 70,000 7,770 81,127 115.90% 90,592 17,324,000 1,355,657 15,415,782 88.99% 15,851,052 36,000 3,838 45,096 125.27% 51,737 135,000 62 139,963 103.68% 168,482 6,828,400 1,747,627 2,992,850 43.83% 306,143 1,600 2,784 29,117 1819.78% 16,536 REVENUE TOTAL 24,395,000 3,117,739 18,703,934 76.67% 16,484,543 183,365 13,528 152,932 83.40% 193,328 4,037,387 314,138 3,507,400 86.87% 3,898,385 368,658 29,646 331,975 90.05% 888,372 2,250,760 258,292 1,881,347 83.59% 1,743,992 1,360,390 100,056 763,151 56.10% 876,885 14,982,119 168,077 2,974,906 19.86% 36,713 1,174,064 94,252 1,052,064 89.61% 1,110,835 - - - 0.00% 1,973,593 1,000 - - 0.00% 1,000 1,438,470 1,283,439 1,738,960 120.89% 633,708 62,980 - - 0.00% 238,468 3,502,313 291,859 3,210,454 91.67% 3,502,313 EXPENSE TOTAL 29,361,507 2,553,288 15,613,188 53.18% 15,097,592 24,395,000 3,117,739 18,703,934 76.67% 16,484,543 29,361,507 2,553,288 15,613,188 53.18% 15,097,592 (4,966,507) 564,451 3,090,747 1,386,951 Services Supplies EXPENSE TOTALS Fund 510 - WATER FUND Net Gain (Loss) Miscellaneous Interfund Transfers Fund 510 - WATER FUND Totals REVENUE TOTALS Capital Outlay Insurance and Other Chargebacks Depreciation Expense Contingencies Debt Service Employee Pay Benefits Pensions Water Charges for Services Sewer Charges for Services Other Charges for Services Other Revenue Fee November 2017 Report Through 11/30/17 Classification Interest Income Fund 515 - SEWER FUND 2017 November YTD 2016 Budget 2017 Actual %Actual 12,501,500 667,031 11,408,929 91.26% 13,027,160 19,650 - 21,750 110.69% 21,600 604,165 (581,734) 11,989 1.98% 3,087 1,000 2,663 12,441 1244.08% 4,450 REVENUE TOTAL 13,126,315 87,960 11,455,109 87.27% 13,056,297 57,040 773 28,634 50.20% 37,763 859,043 69,838 752,158 87.56% 862,355 73,398 6,473 71,484 97.39% 204,330 908,500 258,040 612,378 67.41% 109,493 92,300 4,322 46,441 50.32% 48,058 2,819,700 44,033 823,704 29.21% 15,370 432,953 37,010 397,024 91.70% 414,270 - - - 0.00% 3,461,103 8,370,946 1,237,941 7,765,374 92.77% 1,336,366 1,500 - - 0.00% 5,000 991,677 82,640 909,036 91.67% 773,873 EXPENSE TOTAL 14,607,057 1,741,071 11,406,233 78.09% 7,267,980 13,126,315 87,960 11,455,109 87.27% 13,056,297 14,607,057 1,741,071 11,406,233 78.09% 7,267,980 (1,480,742) (1,653,110) 48,875 5,788,316 EXPENSE TOTALS Fund 515 - SEWER FUND Net Gain (Loss) Miscellaneous Interfund Transfers Fund 515 - SEWER FUND Totals REVENUE TOTALS Insurance and Other Chargebacks Depreciation Expense Debt Service Pensions Services Supplies Employee Pay Benefits Sewer Charges for Services Other Charges for Services Capital Outlay November 2017 Report Through 11/30/17 Classification Other Revenue Interest Income Fund 520 - SOLID WASTE FUND 2017 November YTD 2016 Budget 2017 Actual %Actual 275,000 - 127,255 46.27% 170,144 3,632,394 136,229 3,127,804 86.11% 3,586,453 1,055,967 87,997 967,970 91.67% 1,055,967 238,000 173,232 242,715 101.98% 274,808 REVENUE TOTAL 5,203,378 399,474 4,465,744 85.82% 5,089,388 45,000 1,315 30,132 66.96% 43,025 644,768 49,832 489,958 75.99% 620,226 60,473 4,641 46,993 77.71% 151,916 3,679,126 308,981 2,962,702 80.53% 3,438,311 53,050 7,340 40,489 76.32% 54,768 25,750 514 23,626 91.75% 6,034 149,325 10,187 104,310 69.85% 138,618 21,046 20,126 21,046 100.00% 2,251 15,000 442 3,057 20.38% 12,232 504,807 42,067 462,740 91.67% 499,493 EXPENSE TOTAL 5,198,345 445,445 4,185,053 80.51% 4,966,872 5,201,361 397,457 4,465,744 85.82% 5,087,372 5,198,345 445,445 4,185,053 80.51% 4,966,872 3,016 (47,988) 280,692 120,500 EXPENSE TOTALS Fund 520 - SOLID WASTE FUND Net Gain (Loss) Services Supplies Capital Outlay Insurance and Other Chargebacks REVENUE TOTALS Debt Service Miscellaneous Interfund Transfers Fund 520 - SOLID WASTE FUND Totals Benefits Pensions Other Charges for Services Interfund Transfers Other Revenue License November 2017 Report Through 11/30/17 Classification Employee Pay November YTD 2016 2017 2017 Actuals 48,872 28,294,363 27,302,687 3,218,956 41,713,696 44,156,868 1,346,785 10,304,787 17,934,463 300,222 3,118,295 3,611,901 479,999 8,181,094 8,777,295 606,476 6,671,240 8,099,626 97,962 1,235,582 1,238,785 192,877 1,171,691 1,338,382 - - - - - - - - - 282 35,490 30,285 - - - - - - 6,292,430 100,726,239 112,490,292 4,912,827 53,898,742 61,447,382 838,329 11,495,194 11,768,857 44,506 282,406 159,648 1,011,478 28,963,096 28,043,325 30,308 132,141 94,695 - - - - 2,809 51,836 - - - 34,342 605,442 2,166,129 681,469 6,846,157 7,830,722 7,553,259 102,225,986 111,562,594 6,292,430 100,726,239 112,490,292 7,553,259 102,225,986 111,562,594 (1,260,829) (1,499,747) 927,698 Starting Fund Balance 14,593,354 14,593,354 Net Change 92,641 (1,499,747) Ending Fund Balance 14,685,995 13,093,607 Budget by Organization Report Through 11/30/17 Prior Fiscal Year Activity 2017 Classification Budget Fund 100 - GENERAL FUND REVENUE Property Taxes 28,639,628 Other Taxes 49,402,274 Licenses, Permits and Fees 17,259,650 Fines and Forfeitures 3,810,000 Charges for Services 8,933,395 Interfund Transfers 7,455,774 Intergovernmental Revenue 1,089,965 Other Revenue 2,138,046 Workers Compensation and Liability - Insurance - Library Revenue - Interest Income 50,100 Special Assessment - Reappropriation of Surplus - REVENUE TOTALS 118,778,832 EXPENSE Salary and Benefits 62,620,910 Services and Supplies 13,716,790 Capital Outlay 499,000 Insurance and Other Chargebacks 30,321,297 Community Sponsored Organizations 204,568 Depreciation Expense - Contingencies 213,519 Debt Service - Miscellaneous 1,200,481 Interfund Transfers 9,909,626 EXPENSE TOTALS 118,686,191 Fund 100 - GENERAL FUND Totals REVENUE TOTALS 118,778,832 EXPENSE TOTALS 118,686,191 Fund 100 - GENERAL FUND Totals 92,641 Run by Kate LewisLakin on 01/03/2018 03:11:35 PM Page 1 of 36 November YTD 2016 2017 2017 Actuals 3,014 932,025 827,615 - - - - - - - - - - - - - - - - - - - 32,539 49,590 - - - - - - - - - 255 1,363 802 - - - - - - 3,269 965,926 878,006 23,252 242,415 246,916 41,182 530,866 529,013 - - - 3,571 38,336 26,205 - - - - - - - - - - - - 700 4,976 2,723 - - - 68,706 816,593 804,857 3,269 965,926 878,006 68,706 816,593 804,857 (65,437) 149,333 73,149 Starting Fund Balance 586,388 586,388 Net Change (252,971) 149,333 Ending Fund Balance 333,417 735,721 Budget by Organization Report Through 11/30/17 Prior Fiscal Year Activity 2017 Classification Budget Fund 175 - GENERAL ASSISTANCE FUND REVENUE Property Taxes 900,000 Other Taxes - Licenses, Permits and Fees - Fines and Forfeitures - Charges for Services - Interfund Transfers - Intergovernmental Revenue - Other Revenue 25,000 Workers Compensation and Liability - Insurance - Library Revenue - Interest Income 1,000 Special Assessment - Reappropriation of Surplus - REVENUE TOTALS 926,000 EXPENSE Salary and Benefits 282,103 Services and Supplies 858,900 Capital Outlay - Insurance and Other Chargebacks 30,968 Community Sponsored Organizations - Depreciation Expense - Contingencies - Debt Service - Miscellaneous 7,000 Interfund Transfers - EXPENSE TOTALS 1,178,971 Fund 175 - GENERAL ASSISTANCE FUND REVENUE TOTALS 926,000 EXPENSE TOTALS 1,178,971 Fund 175 - GENERAL ASSISTANCE FUND (252,971) Run by Kate LewisLakin on 01/03/2018 03:11:35 PM Page 2 of 36 November YTD 2016 2017 2017 Actuals - - - 71,596 787,557 884,794 - - - - - - 14 14 - 71,610 787,571 884,794 - 121 61 - - - 11,611 714,699 849,333 - - - 11,611 714,821 849,394 71,610 787,571 884,794 11,611 714,821 849,394 59,999 72,750 35,400 Starting Fund Balance 70,806 70,806 Net Change - 72,750 Ending Fund Balance 70,806 143,556 Budget by Organization Report Through 11/30/17 Prior Fiscal Year Activity 2017 Classification Budget Fund 176 - HEALTH AND HUMAN SERVICES REVENUE Charges for Services - Interfund Transfers 859,153 Intergovernmental Revenue - Other Revenue - Interest Income - REVENUE TOTALS 859,153 EXPENSE Services and Supplies 767,055 Capital Outlay - Community Sponsored Organizations 92,098 Miscellaneous - EXPENSE TOTALS 859,153 Fund 176 - HEALTH AND HUMAN REVENUE TOTALS 859,153 EXPENSE TOTALS 859,153 Fund 176 - HEALTH AND HUMAN - Run by Kate LewisLakin on 01/03/2018 03:11:35 PM Page 3 of 36 November YTD 2016 2017 2017 Actuals - 1,000,000 1,000,000 1,428 1,428 - 1,428 1,001,428 1,000,000 83,333 916,667 1,000,000 83,333 916,667 1,000,000 1,428 1,001,428 1,000,000 83,333 916,667 1,000,000 (81,906) 84,761 (0) Starting Fund Balance - - Net Change - 84,761 Ending Fund Balance - 84,761 Budget by Organization Report Through 11/30/17 Prior Fiscal Year Activity 2017 Classification Budget Fund 180 - GOOD NEIGHBOR FUND REVENUE Other Revenue 1,000,000 Interest Income - REVENUE TOTALS 1,000,000 EXPENSE Interfund Transfers 1,000,000 EXPENSE TOTALS 1,000,000 Fund 180 - GOOD NEIGHBOR FUND Totals REVENUE TOTALS 1,000,000 EXPENSE TOTALS 1,000,000 Fund 180 - GOOD NEIGHBOR FUND Totals - Run by Kate LewisLakin on 01/03/2018 03:11:35 PM Page 4 of 36 November YTD 2016 2017 2017 Actuals 12,397 6,368,794 6,136,248 - - 4,141 10,297 119,426 152,537 30 323 - - - 235,800 - 22,092 75,418 7,192 67,839 67,943 74,216 227,573 339,027 1,028 4,590 4,717 105,161 6,810,637 7,015,830 327,809 3,669,838 4,246,657 179,303 1,478,547 1,733,725 - 314 57,842 43,988 450,005 406,708 - - - - - - - - - - 22 - 28,635 314,983 340,272 579,735 5,913,709 6,785,204 105,161 6,810,637 7,015,830 579,735 5,913,709 6,785,204 (474,574) 896,928 230,626 Starting Fund Balance 650,655 650,655 Net Change - 896,928 Ending Fund Balance 650,655 1,547,583 Budget by Organization Report Through 11/30/17 Prior Fiscal Year Activity 2017 Classification Budget Fund 185 - LIBRARY FUND REVENUE Property Taxes 6,376,358 Other Taxes 46,100 Fines and Forfeitures 164,000 Charges for Services - Interfund Transfers 190,200 Intergovernmental Revenue 57,418 Other Revenue 24,849 Library Revenue 386,020 Interest Income 5,400 REVENUE TOTALS 7,250,345 EXPENSE Salary and Benefits 4,460,836 Services and Supplies 1,940,058 Capital Outlay 5,400 Insurance and Other Chargebacks 500,433 Depreciation Expense - Contingencies - Debt Service - Miscellaneous - Interfund Transfers 343,618 EXPENSE TOTALS 7,250,345 Fund 185 - LIBRARY FUND Totals REVENUE TOTALS 7,250,345 EXPENSE TOTALS 7,250,345 Fund 185 - LIBRARY FUND Totals - Run by Kate LewisLakin on 01/03/2018 03:11:35 PM Page 5 of 36 November YTD 2016 2017 2017 Actuals - 338,897 364,827 - 778,745 676,150 - 7 1 - 1,117,649 1,040,978 11,911 19,022 12,349 - - - 196,699 1,134,570 385,696 - - - - - 650,000 208,610 1,153,592 1,048,044 - 1,117,649 1,040,978 208,610 1,153,592 1,048,044 (208,610) (35,943) (7,066) Starting Fund Balance 29,709 29,709 Net Change - (35,943) Ending Fund Balance 29,709 (6,234) Budget by Organization Report Through 11/30/17 Prior Fiscal Year Activity 2017 Classification Budget Fund 186 - LIBRARY DEBT SERVICE FUND REVENUE Property Taxes 345,955 Other Revenue - Interest Income - REVENUE TOTALS 345,955 EXPENSE Services and Supplies - Capital Outlay - Debt Service 345,955 Miscellaneous - Interfund Transfers - EXPENSE TOTALS 345,955 EXPENSE TOTALS 345,955 Fund 186 - LIBRARY DEBT SERVICE FUND - Fund 186 - LIBRARY DEBT SERVICE FUND REVENUE TOTALS 345,955 Run by Kate LewisLakin on 01/03/2018 03:11:35 PM Page 6 of 36 November YTD 2016 2017 2017 Actuals - - - - 1,431,106 - - - - - 1,431,106 - - 20,355 - 35,153 1,017,443 - - - - - - - 35,153 1,037,798 - - 1,431,106 - 35,153 1,037,798 - (35,153) 393,308 - Starting Fund Balance - - Net Change - 393,308 Ending Fund Balance - 393,308 Budget by Organization Report Through 11/30/17 Prior Fiscal Year Activity 2017 Classification Budget Fund 187 - LIBRARY CAPITAL IMPROVEMENT FD REVENUE Property Taxes - Other Revenue 3,774,500 Interest Income - REVENUE TOTALS 3,774,500 EXPENSE Services and Supplies - Capital Outlay 3,774,500 Debt Service - Interfund Transfers - EXPENSE TOTALS 3,774,500 Fund 187 - LIBRARY CAPITAL - Fund 187 - LIBRARY CAPITAL REVENUE TOTALS 3,774,500 EXPENSE TOTALS 3,774,500 Run by Kate LewisLakin on 01/03/2018 03:11:35 PM Page 7 of 36 November YTD 2016 2017 2017 Actuals - - - - - 91,447 - - - 24 178 - 24 178 91,447 1,597 19,026 22,569 - 1,860 6,060 - 2,642 39,316 (3,311) 4,387 4,173 - - - 2,400 2,400 1,705 377 4,142 17,623 1,063 34,456 91,447 24 178 91,447 1,063 34,456 91,447 (1,038) (34,278) - Starting Fund Balance - - Net Change 40,601 (34,278) Ending Fund Balance 40,601 (34,278) Budget by Organization Report Through 11/30/17 Prior Fiscal Year Activity 2017 Classification Budget Fund 195 - NEIGHBORHOOD STABILIZATION FUND REVENUE Licenses, Permits and Fees - Intergovernmental Revenue 139,500 Other Revenue - Interest Income - REVENUE TOTALS 139,500 EXPENSE Salary and Benefits 28,297 Services and Supplies 5,100 Capital Outlay 7,000 Insurance and Other Chargebacks 3,984 Debt Service - Miscellaneous 50,000 Interfund Transfers 4,518 EXPENSE TOTALS 98,899 EXPENSE TOTALS 98,899 Fund 195 - NEIGHBORHOOD 40,601 Fund 195 - NEIGHBORHOOD REVENUE TOTALS 139,500 Run by Kate LewisLakin on 01/03/2018 03:11:35 PM Page 8 of 36 November YTD 2016 2017 2017 Actuals 164,584 1,744,262 1,896,461 - - - 1,953 15,621 6,613 - - - 166,537 1,759,882 1,903,074 - - - - - 130,789 - - - - - - - - - 71,499 786,491 2,189,000 71,499 786,491 2,319,789 166,537 1,759,882 1,903,074 71,499 786,491 2,319,789 95,038 973,391 (416,715) Starting Fund Balance 1,413,678 1,413,678 Net Change (327,990) 973,391 Ending Fund Balance 1,085,688 2,387,069 Budget by Organization Report Through 11/30/17 Prior Fiscal Year Activity 2017 Classification Budget Fund 200 - MOTOR FUEL TAX FUND REVENUE Intergovernmental Revenue 1,920,000 Other Revenue - Interest Income 1,000 Reappropriation of Surplus - REVENUE TOTALS 1,921,000 EXPENSE Services and Supplies - Capital Outlay 1,391,000 Contingencies - Debt Service - Miscellaneous - Interfund Transfers 857,990 EXPENSE TOTALS 2,248,990 Fund 200 - MOTOR FUEL TAX FUND Totals (327,990) Fund 200 - MOTOR FUEL TAX FUND Totals REVENUE TOTALS 1,921,000 EXPENSE TOTALS 2,248,990 Run by Kate LewisLakin on 01/03/2018 03:11:35 PM Page 9 of 36 November YTD 2016 2017 2017 Actuals 73,181 917,304 1,038,331 - - - - - - 656 6,204 2,472 73,837 923,509 1,040,803 41,967 435,913 509,028 4,869 231,094 263,105 3,846 36,167 423,493 8,253 85,755 91,628 - - - - - - - - - - - - 6,081 66,896 142,207 65,017 855,825 1,429,460 73,837 923,509 1,040,803 65,017 855,825 1,429,460 8,820 67,684 (388,657) Starting Fund Balance 163,061 163,061 Net Change (8,718) 67,684 Ending Fund Balance 154,343 230,745 Budget by Organization Report Through 11/30/17 Prior Fiscal Year Activity 2017 Classification Budget Fund 205 - EMERGENCY TELEPHONE (E911) FUND REVENUE Other Taxes 1,020,700 Intergovernmental Revenue - Other Revenue - Interest Income 1,000 REVENUE TOTALS 1,021,700 EXPENSE Salary and Benefits 517,524 Services and Supplies 282,400 Capital Outlay 55,000 Insurance and Other Chargebacks 102,517 Community Sponsored Organizations - Contingencies - Debt Service - Miscellaneous - Interfund Transfers 72,977 EXPENSE TOTALS 1,030,418 Fund 205 - EMERGENCY TELEPHONE (8,718) Fund 205 - EMERGENCY TELEPHONE REVENUE TOTALS 1,021,700 EXPENSE TOTALS 1,030,418 Run by Kate LewisLakin on 01/03/2018 03:11:35 PM Page 10 of 36 November YTD 2016 2017 2017 Actuals - 322,477 321,266 - 5 2 - 322,482 321,268 82,250 329,000 323,000 - - - - - - 82,250 329,000 323,000 - 322,482 321,268 82,250 329,000 323,000 (82,250) (6,518) (1,732) Starting Fund Balance (192,276) (192,276) Net Change - (6,518) Ending Fund Balance (192,276) (198,794) Budget by Organization Report Through 11/30/17 Prior Fiscal Year Activity 2017 Classification Budget Fund 210 - SPECIAL SERVICE AREA (SSA) #4 REVENUE Property Taxes 320,000 Interest Income - REVENUE TOTALS 320,000 EXPENSE Services and Supplies 320,000 Debt Service - Miscellaneous - EXPENSE TOTALS 320,000 EXPENSE TOTALS 320,000 Fund 210 - SPECIAL SERVICE AREA (SSA) - Fund 210 - SPECIAL SERVICE AREA (SSA) REVENUE TOTALS 320,000 Run by Kate LewisLakin on 01/03/2018 03:11:35 PM Page 11 of 36 November YTD 2016 2017 2017 Actuals - - - - - - 15,000 262,927 2,016,478 262 262 10,197 - - - 15,262 263,188 2,026,675 26,064 315,417 414,848 - 3,751 6,219 - 154,514 608,829 151,049 394,965 405,247 162,500 270,912 507,815 - - - - - - 19,543 26,725 61,555 730 8,027 17,938 359,886 1,174,312 2,022,452 15,262 263,188 2,026,675 359,886 1,174,312 2,022,452 (344,624) (911,124) 4,224 Starting Fund Balance 64,106 64,106 Net Change (9,484) (911,124) Ending Fund Balance 54,622 (847,018) Budget by Organization Report Through 11/30/17 Prior Fiscal Year Activity 2017 Classification Budget Fund 215 - CDBG FUND REVENUE Charges for Services - Interfund Transfers - Intergovernmental Revenue 2,272,494 Other Revenue - Interest Income - REVENUE TOTALS 2,272,494 EXPENSE Salary and Benefits 393,090 Services and Supplies 220,840 Capital Outlay - Insurance and Other Chargebacks 93,120 Community Sponsored Organizations 175,500 Contingencies - Debt Service - Miscellaneous 569,970 Interfund Transfers 829,458 EXPENSE TOTALS 2,281,978 EXPENSE TOTALS 2,281,978 Fund 215 - CDBG FUND Totals (9,484) Fund 215 - CDBG FUND Totals REVENUE TOTALS 2,272,494 Run by Kate LewisLakin on 01/03/2018 03:11:35 PM Page 12 of 36 November YTD 2016 2017 2017 Actuals - - - 18,310 92,083 208,541 26 248 4,656 18,336 92,332 213,197 - - - 5,900 31,245 160,641 - - - - - - 5,900 31,245 160,641 18,336 92,332 213,197 5,900 31,245 160,641 12,436 61,087 52,555 Starting Fund Balance 210,921 210,921 Net Change - 61,087 Ending Fund Balance 210,921 272,008 Budget by Organization Report Through 11/30/17 Prior Fiscal Year Activity 2017 Classification Budget Fund 220 - CDBG LOAN REVENUE Intergovernmental Revenue - Other Revenue 293,000 Interest Income - REVENUE TOTALS 293,000 EXPENSE Salary and Benefits - Services and Supplies 293,000 Miscellaneous - Interfund Transfers - EXPENSE TOTALS 293,000 Fund 220 - CDBG LOAN Totals - Fund 220 - CDBG LOAN Totals REVENUE TOTALS 293,000 EXPENSE TOTALS 293,000 Run by Kate LewisLakin on 01/03/2018 03:11:35 PM Page 13 of 36 November YTD 2016 2017 2017 Actuals - - - - - - 194 194 - 194 194 - - - - - - - - - - - - - - - - - - - 194 194 - - - - 194 194 - Starting Fund Balance 169,915 169,915 Net Change (100,000) 194 Ending Fund Balance 69,915 170,109 Budget by Organization Report Through 11/30/17 Prior Fiscal Year Activity 2017 Classification Budget Fund 235 - NEIGHBORHOOD IMPROVEMENT REVENUE Other Taxes - Interfund Transfers - Interest Income - REVENUE TOTALS - EXPENSE Services and Supplies - Capital Outlay - Debt Service - Miscellaneous 100,000 Interfund Transfers - EXPENSE TOTALS 100,000 EXPENSE TOTALS 100,000 Fund 235 - NEIGHBORHOOD (100,000) Fund 235 - NEIGHBORHOOD REVENUE TOTALS - Run by Kate LewisLakin on 01/03/2018 03:11:35 PM Page 14 of 36 November YTD 2016 2017 2017 Actuals - 303,296 178,211 2,282 25,102 27,259 33 96 14 2,315 328,494 205,484 2,929 34,557 31,964 22,883 341,258 180,110 - - - (14,551) (17,803) (4,297) - - - - - - - 126 100 - - - 11,260 358,138 207,876 2,315 328,494 205,484 11,260 358,138 207,876 (8,945) (29,644) (2,392) Starting Fund Balance 2,377 2,377 Net Change (831) (29,644) Ending Fund Balance 1,546 (27,267) Budget by Organization Report Through 11/30/17 Prior Fiscal Year Activity 2017 Classification Budget Fund 240 - HOME FUND REVENUE Intergovernmental Revenue 585,861 Other Revenue - Interest Income - REVENUE TOTALS 585,861 EXPENSE Salary and Benefits 41,005 Services and Supplies 540,200 Capital Outlay - Insurance and Other Chargebacks 4,987 Community Sponsored Organizations - Debt Service - Miscellaneous 500 Interfund Transfers - EXPENSE TOTALS 586,692 EXPENSE TOTALS 586,692 Fund 240 - HOME FUND Totals (831) Fund 240 - HOME FUND Totals REVENUE TOTALS 585,861 Run by Kate LewisLakin on 01/03/2018 03:11:35 PM Page 15 of 36 November YTD 2016 2017 2017 Actuals 10,000 70,000 106,780 - - - - - - 1,806 132,639 448,343 1,376 4,754 1,392 13,181 207,393 556,515 2,929 34,557 34,138 4,640 214,890 201 - - - 7,424 12,026 3,178 - 3,238 735 - - - - 56,021 110,956 - - - 14,992 320,731 149,207 13,181 207,393 556,515 14,992 320,731 149,207 (1,810) (113,338) 407,308 Starting Fund Balance 1,401,188 1,401,188 Net Change (1,071,422) (113,338) Ending Fund Balance 329,766 1,287,850 Budget by Organization Report Through 11/30/17 Prior Fiscal Year Activity 2017 Classification Budget Fund 250 - AFFORDABLE HOUSING FUND REVENUE Other Taxes 50,000 Interfund Transfers - Intergovernmental Revenue - Other Revenue 585,600 Interest Income 230 REVENUE TOTALS 635,830 EXPENSE Salary and Benefits 63,452 Services and Supplies 1,077,500 Capital Outlay - Insurance and Other Chargebacks 8,800 Community Sponsored Organizations 455,000 Debt Service - Miscellaneous 102,500 Interfund Transfers - EXPENSE TOTALS 1,707,252 Fund 250 - AFFORDABLE HOUSING FUND (1,071,422) Fund 250 - AFFORDABLE HOUSING FUND REVENUE TOTALS 635,830 EXPENSE TOTALS 1,707,252 Run by Kate LewisLakin on 01/03/2018 03:11:35 PM Page 16 of 36 November YTD 2016 2017 2017 Actuals 5,052 5,243,510 4,729,649 - - - - - - - - - 4,269 40,771 14,012 9,321 5,284,281 4,743,661 - - - 147 1,722 2,750 - - 4,473 - - - 24,668 98,672 1,098,676 2,089,485 5,378,159 4,455,515 2,114,299 5,478,552 5,561,415 9,321 5,284,281 4,743,661 2,114,299 5,478,552 5,561,415 (2,104,978) (194,271) (817,754) Starting Fund Balance 5,624,676 5,624,676 Net Change (5,385,636) (194,271) Ending Fund Balance 239,040 5,430,405 Budget by Organization Report Through 11/30/17 Prior Fiscal Year Activity 2017 Classification Budget Fund 300 - WASHINGTON NATIONAL TIF FUND REVENUE Property Taxes 5,145,000 Other Taxes - Interfund Transfers - Other Revenue - Interest Income 10,000 REVENUE TOTALS 5,155,000 EXPENSE Salary and Benefits - Services and Supplies 500,000 Capital Outlay - Debt Service - Miscellaneous 100,000 Interfund Transfers 9,940,636 EXPENSE TOTALS 10,540,636 EXPENSE TOTALS 10,540,636 Fund 300 - WASHINGTON NATIONAL TIF (5,385,636) Fund 300 - WASHINGTON NATIONAL TIF REVENUE TOTALS 5,155,000 Run by Kate LewisLakin on 01/03/2018 03:11:35 PM Page 17 of 36 November YTD 2016 2017 2017 Actuals - - 1,233,675 - (45,325) - - 1,320 2,319 - (44,005) 1,235,994 - - 2,488 - - - - - - - - - - 599,668 129,192 - - 1,741,757 - 599,668 1,873,437 - (44,005) 1,235,994 - 599,668 1,873,437 - (643,672) (637,443) Starting Fund Balance 643,672 643,672 Net Change (513,865) (643,672) Ending Fund Balance 129,807 (0) Budget by Organization Report Through 11/30/17 Prior Fiscal Year Activity 2017 Classification Budget Fund 310 - HOWARD-HARTREY TIF REVENUE Property Taxes - Other Revenue - Interest Income - REVENUE TOTALS - EXPENSE Services and Supplies - Capital Outlay - Community Sponsored Organizations - Debt Service - Miscellaneous - Interfund Transfers 513,865 EXPENSE TOTALS 513,865 Fund 310 - HOWARD-HARTREY TIF Totals REVENUE TOTALS - EXPENSE TOTALS 513,865 Fund 310 - HOWARD-HARTREY TIF Totals (513,865) Run by Kate LewisLakin on 01/03/2018 03:11:35 PM Page 18 of 36 November YTD 2016 2017 2017 Actuals 17,787 10,797,411 10,438,928 250,020 2,550,216 2,999,879 6,941 76,352 80,089 - 8,883,103 8,211,196 8,716 31,308 24,264 283,464 22,338,391 21,754,356 107,190 192,035 149,553 11,275,113 23,099,797 23,454,863 - (57) 57 - - - 11,382,303 23,291,775 23,604,473 283,464 22,338,391 21,754,356 11,382,303 23,291,775 23,604,473 (11,098,839) (953,385) (1,850,118) Starting Fund Balance 745,997 745,997 Net Change (305,500) (953,385) Ending Fund Balance 440,497 (207,388) Budget by Organization Report Through 11/30/17 Prior Fiscal Year Activity 2017 Classification Budget Fund 320 - DEBT SERVICE FUND REVENUE Property Taxes 10,879,993 Interfund Transfers 3,160,852 Intergovernmental Revenue 83,292 Other Revenue - Interest Income 1,500 REVENUE TOTALS 14,125,637 EXPENSE Services and Supplies 120,250 Debt Service 14,310,887 Miscellaneous - Interfund Transfers - EXPENSE TOTALS 14,431,137 Fund 320 - DEBT SERVICE FUND Totals REVENUE TOTALS 14,125,637 EXPENSE TOTALS 14,431,137 Fund 320 - DEBT SERVICE FUND Totals (305,500) Run by Kate LewisLakin on 01/03/2018 03:11:35 PM Page 19 of 36 November YTD 2016 2017 2017 Actuals - 583,827 533,105 8,500 58,500 282,307 - 22 374 8,500 642,348 815,787 418 306,780 679,056 - - - - - - - - - 94 903 693 - - - 5,000 55,000 107,500 5,512 362,683 787,249 8,500 642,348 815,787 5,512 362,683 787,249 2,988 279,665 28,537 Starting Fund Balance (84) (84) Net Change (13,200) 279,665 Ending Fund Balance (13,284) 279,581 Budget by Organization Report Through 11/30/17 Prior Fiscal Year Activity 2017 Classification Budget Fund 330 - HOWARD-RIDGE TIF FUND REVENUE Property Taxes 555,000 Other Revenue 1,030,000 Interest Income 400 REVENUE TOTALS 1,585,400 EXPENSE Services and Supplies 538,000 Capital Outlay 1,000,000 Insurance and Other Chargebacks - Community Sponsored Organizations - Debt Service 600 Miscellaneous - Interfund Transfers 60,000 EXPENSE TOTALS 1,598,600 Fund 330 - HOWARD-RIDGE TIF FUND (13,200) Fund 330 - HOWARD-RIDGE TIF FUND REVENUE TOTALS 1,585,400 EXPENSE TOTALS 1,598,600 Run by Kate LewisLakin on 01/03/2018 03:11:35 PM Page 20 of 36 November YTD 2016 2017 2017 Actuals 503 43,387 - 1,028 11,311 11,311 355 3,438 1,684 1,886 58,136 12,995 147 1,722 507 - - (1,028) - - - - - - 1,156 11,106 8,519 - - - 2,500 27,500 30,000 3,803 40,328 37,998 1,886 58,136 12,995 3,803 40,328 37,998 (1,917) 17,808 (25,003) Starting Fund Balance 417,260 417,260 Net Change (39,850) 17,808 Ending Fund Balance 377,410 435,068 Budget by Organization Report Through 11/30/17 Prior Fiscal Year Activity 2017 Classification Budget Fund 335 - WEST EVANSTON TIF FUND REVENUE Property Taxes - Other Revenue - Interest Income 150 REVENUE TOTALS 150 EXPENSE Services and Supplies - Capital Outlay - Insurance and Other Chargebacks - Contingencies - Debt Service 10,000 Miscellaneous - Interfund Transfers 30,000 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 Run by Kate LewisLakin on 01/03/2018 03:11:35 PM Page 21 of 36 November YTD 2016 2017 2017 Actuals - 48,001 - - 2,067,512 - - 1 - - 2,115,514 - 10,966 38,588 971 - 2,000,000 - - 53,521 28,444 10,966 2,092,108 29,415 - 2,115,514 - 10,966 2,092,108 29,415 (10,966) 23,406 (29,415) Starting Fund Balance (29,415) (29,415) Net Change - 23,406 Ending Fund Balance (29,415) (6,009) Budget by Organization Report Through 11/30/17 Prior Fiscal Year Activity 2017 Classification Budget Fund 340 - DEMPSTER-DODGE TIF FUND REVENUE Property Taxes - Other Revenue 50,000 Interest Income - REVENUE TOTALS 50,000 EXPENSE Services and Supplies - Capital Outlay - Debt Service 40,000 EXPENSE TOTALS 40,000 Fund 340 - DEMPSTER-DODGE TIF FUND REVENUE TOTALS 50,000 EXPENSE TOTALS 40,000 Fund 340 - DEMPSTER-DODGE TIF FUND 10,000 Run by Kate LewisLakin on 01/03/2018 03:11:35 PM Page 22 of 36 November YTD 2016 2017 2017 Actuals - 75,430 - - 3,520,189 1,580,000 6 9 - 6 3,595,628 1,580,000 16,170 57,823 437 - 3,580,000 1,740,000 - 31,398 16,556 16,170 3,669,221 1,756,993 6 3,595,628 1,580,000 16,170 3,669,221 1,756,993 (16,164) (73,594) (176,993) Starting Fund Balance 135,077 135,077 Net Change (60,000) (73,594) Ending Fund Balance 75,077 61,483 Budget by Organization Report Through 11/30/17 Prior Fiscal Year Activity 2017 Classification Budget Fund 345 - CHICAGO-MAIN TIF REVENUE Property Taxes - Other Revenue - Interest Income - REVENUE TOTALS - EXPENSE Services and Supplies - Capital Outlay - Debt Service 60,000 EXPENSE TOTALS 60,000 Fund 345 - CHICAGO-MAIN TIF Totals REVENUE TOTALS - EXPENSE TOTALS 60,000 Fund 345 - CHICAGO-MAIN TIF Totals (60,000) Run by Kate LewisLakin on 01/03/2018 03:11:35 PM Page 23 of 36 November YTD 2016 2017 2017 Actuals 228 214,891 223,296 15 21 2 243 214,913 223,298 96,998 213,354 145,003 - - - 96,998 213,354 145,003 243 214,913 223,298 96,998 213,354 145,003 (96,755) 1,559 78,294 Starting Fund Balance 78,294 78,294 Net Change 500 1,559 Ending Fund Balance 78,794 79,853 Budget by Organization Report Through 11/30/17 Prior Fiscal Year Activity 2017 Classification Budget Fund 350 - SPECIAL SERVICE AREA (SSA) #6 REVENUE Property Taxes 220,000 Interest Income 500 REVENUE TOTALS 220,500 EXPENSE Services and Supplies 220,000 Interfund Transfers - EXPENSE TOTALS 220,000 Fund 350 - SPECIAL SERVICE AREA (SSA) 500 Fund 350 - SPECIAL SERVICE AREA (SSA) REVENUE TOTALS 220,500 EXPENSE TOTALS 220,000 Run by Kate LewisLakin on 01/03/2018 03:11:35 PM Page 24 of 36 November YTD 2016 2017 2017 Actuals - 359,706 - - 33,339 96,586 41,667 1,395,023 4,864,054 - 336,425 2,177,914 213 11,246,149 9,591,988 4,435 47,457 16,690 46,314 13,418,098 16,747,233 - - - 175,332 1,777,600 1,320,475 3,363,884 10,163,759 8,948,635 - - - - - - 41,667 458,333 490,000 3,580,882 12,399,693 10,759,111 46,314 13,418,098 16,747,233 3,580,882 12,399,693 10,759,111 (3,534,568) 1,018,405 5,988,122 Starting Fund Balance 11,505,164 11,505,164 Net Change (8,583,512) 1,018,405 Ending Fund Balance 2,921,652 12,523,569 Budget by Organization Report Through 11/30/17 Prior Fiscal Year Activity 2017 Classification Budget Fund 415 - CAPITAL IMPROVEMENTS FUND REVENUE Licenses, Permits and Fees - Charges for Services - Interfund Transfers 7,710,000 Intergovernmental Revenue 1,920,000 Other Revenue 12,295,000 Interest Income - REVENUE TOTALS 21,925,000 EXPENSE Salary and Benefits - Services and Supplies - Capital Outlay 30,008,512 Debt Service - Miscellaneous - Interfund Transfers 500,000 EXPENSE TOTALS 30,508,512 Fund 415 - CAPITAL IMPROVEMENTS REVENUE TOTALS 21,925,000 EXPENSE TOTALS 30,508,512 Fund 415 - CAPITAL IMPROVEMENTS (8,583,512) Run by Kate LewisLakin on 01/03/2018 03:11:35 PM Page 25 of 36 November YTD 2016 2017 2017 Actuals - 500,000 - - 900,000 - - - - - 1,400,000 - - - - - - - - - - - - - - 1,400,000 - - - - - 1,400,000 - Budget by Organization Report Through 11/30/17 Prior Fiscal Year Activity 2017 Classification Budget Fund 416 - CROWN CONSTRUCTION FUND REVENUE Interfund Transfers - Other Revenue - Interest Income - REVENUE TOTALS - EXPENSE Services and Supplies - Capital Outlay - Interfund Transfers - EXPENSE TOTALS - Fund 416 - CROWN CONSTRUCTION FUND REVENUE TOTALS - EXPENSE TOTALS - Fund 416 - CROWN CONSTRUCTION FUND - Run by Kate LewisLakin on 01/03/2018 03:11:35 PM Page 26 of 36 November YTD 2016 2017 2017 Actuals - - - - - - - - - - - - - - - - - - - - - - - 513,349 - - - - - - - - - 1,594 24,491 29,661 4,304 194,155 142,874 - - - 5,898 218,645 685,884 - - - 5,613 5,613 8,751 - - - - - - - - - - - - 21,952 241,475 360,698 27,565 247,088 369,449 5,898 218,645 685,884 27,565 247,088 369,449 (21,668) (28,442) 316,435 Starting Fund Balance 2,999,216 2,999,216 Net Change (32,227) (28,442) Ending Fund Balance 2,966,989 2,970,774 Budget by Organization Report Through 11/30/17 Prior Fiscal Year Activity 2017 Classification Budget Fund 420 - SPECIAL ASSESSMENT FUND REVENUE Property Taxes - Other Taxes - Licenses, Permits and Fees - Fines and Forfeitures - Charges for Services - Interfund Transfers - Intergovernmental Revenue - Other Revenue 250,000 Workers Compensation and Liability - Insurance - Library Revenue - Interest Income 51,033 Special Assessment 180,167 Reappropriation of Surplus - REVENUE TOTALS 481,200 EXPENSE Salary and Benefits - Services and Supplies - Capital Outlay - Insurance and Other Chargebacks - Debt Service - Miscellaneous - Interfund Transfers 513,427 EXPENSE TOTALS 513,427 Fund 420 - SPECIAL ASSESSMENT FUND REVENUE TOTALS 481,200 EXPENSE TOTALS 513,427 Fund 420 - SPECIAL ASSESSMENT FUND (32,227) Run by Kate LewisLakin on 01/03/2018 03:11:35 PM Page 27 of 36 November YTD 2016 2017 2017 Actuals - - - - - - - 1,900 3,350 - - - 705,988 5,720,903 6,509,492 2,060,318 4,120,636 3,711,768 - - - 22,352 213,638 195,895 1,298 42,225 38,159 2,789,956 10,099,302 10,458,663 106,825 1,078,155 1,462,702 209,385 2,807,358 3,084,543 360,695 2,250,540 (24,598) 47,883 501,316 504,784 - - - - - 2,836,672 1,642 4,246 5,910 4,015,465 4,330,993 390,235 - 210,298 255,626 106,224 1,168,460 1,303,783 4,848,118 12,351,365 9,819,656 2,789,956 10,099,302 10,458,663 4,848,118 12,351,365 9,819,656 (2,058,162) (2,252,063) 639,007 Starting Fund Balance 7,752,664 7,752,664 Net Change (3,350,830) (2,252,063) Ending Fund Balance 4,401,834 5,500,601 Budget by Organization Report Through 11/30/17 Prior Fiscal Year Activity 2017 Classification Budget Fund 505 - PARKING SYSTEM FUND REVENUE Property Taxes - Other Taxes - Licenses, Permits and Fees - Fines and Forfeitures - Charges for Services 6,802,875 Interfund Transfers 4,120,636 Intergovernmental Revenue 12,125 Other Revenue 203,216 Interest Income 35,070 REVENUE TOTALS 11,173,922 EXPENSE Salary and Benefits 1,247,921 Services and Supplies 3,501,275 Capital Outlay 3,020,000 Insurance and Other Chargebacks 524,102 Community Sponsored Organizations - Depreciation Expense - Contingencies 11,000 Debt Service 4,331,771 Miscellaneous 304,000 Interfund Transfers 1,584,683 EXPENSE TOTALS 14,524,752 Fund 505 - PARKING SYSTEM FUND Totals (3,350,830) Fund 505 - PARKING SYSTEM FUND Totals REVENUE TOTALS 11,173,922 EXPENSE TOTALS 14,524,752 Run by Kate LewisLakin on 01/03/2018 03:11:35 PM Page 28 of 36 November YTD 2016 2017 2017 Actuals - - - 7,770 81,127 90,592 1,359,557 15,600,841 16,071,271 - - - - - - 1,747,627 2,992,850 306,143 2,784 29,117 16,536 3,117,739 18,703,934 16,484,543 357,312 3,992,306 4,980,085 358,348 2,644,498 2,620,877 104,012 2,974,906 36,713 94,252 1,052,064 1,110,835 - - - - - 1,973,593 - - 1,000 1,283,439 1,738,960 633,708 - - 238,468 291,859 3,210,454 3,502,313 2,489,223 15,613,188 15,097,592 3,117,739 18,703,934 16,484,543 2,489,223 15,613,188 15,097,592 628,516 3,090,747 1,386,951 Starting Fund Balance 7,536,078 7,536,078 Net Change (4,966,507) 3,090,747 Ending Fund Balance 2,569,571 10,626,825 Budget by Organization Report Through 11/30/17 Prior Fiscal Year Activity 2017 Classification Budget Fund 510 - WATER FUND REVENUE Other Taxes - Licenses, Permits and Fees 70,000 Charges for Services 17,495,000 Interfund Transfers - Intergovernmental Revenue - Other Revenue 6,828,400 Interest Income 1,600 REVENUE TOTALS 24,395,000 EXPENSE Salary and Benefits 4,589,411 Services and Supplies 3,611,150 Capital Outlay 14,982,119 Insurance and Other Chargebacks 1,174,064 Community Sponsored Organizations - Depreciation Expense - Contingencies 1,000 Debt Service 1,438,470 Miscellaneous 62,980 Interfund Transfers 3,502,313 EXPENSE TOTALS 29,361,507 EXPENSE TOTALS 29,361,507 Fund 510 - WATER FUND Totals (4,966,507) Fund 510 - WATER FUND Totals REVENUE TOTALS 24,395,000 Run by Kate LewisLakin on 01/03/2018 03:11:35 PM Page 29 of 36 November YTD 2016 2017 2017 Actuals 667,031 11,430,679 13,048,760 - - - (581,734) 11,989 3,087 2,663 12,441 4,450 87,960 11,455,109 13,056,297 77,084 852,276 1,104,448 262,362 658,819 157,551 44,033 823,704 15,370 37,010 397,024 414,270 - - 3,461,103 - - - 1,237,941 7,765,374 1,336,366 - - 5,000 82,640 909,036 773,873 1,741,071 11,406,233 7,267,980 87,960 11,455,109 13,056,297 1,741,071 11,406,233 7,267,980 (1,653,110) 48,875 5,788,316 Starting Fund Balance 4,612,098 4,612,098 Net Change (1,480,742) 48,875 Ending Fund Balance 3,131,356 4,660,973 Budget by Organization Report Through 11/30/17 Prior Fiscal Year Activity 2017 Classification Budget Fund 515 - SEWER FUND REVENUE Charges for Services 12,521,150 Interfund Transfers - Other Revenue 604,165 Interest Income 1,000 REVENUE TOTALS 13,126,315 EXPENSE Salary and Benefits 989,481 Services and Supplies 1,000,800 Capital Outlay 2,819,700 Insurance and Other Chargebacks 432,953 Depreciation Expense - Contingencies - Debt Service 8,370,946 Miscellaneous 1,500 Interfund Transfers 991,677 EXPENSE TOTALS 14,607,057 Fund 515 - SEWER FUND Totals (1,480,742) Fund 515 - SEWER FUND Totals REVENUE TOTALS 13,126,315 EXPENSE TOTALS 14,607,057 Run by Kate LewisLakin on 01/03/2018 03:11:35 PM Page 30 of 36 November YTD 2016 2017 2017 Actuals - 127,255 170,144 136,229 3,127,804 3,586,453 87,997 967,970 1,055,967 - - - 173,232 242,715 274,808 - - - 397,457 4,465,744 5,087,372 55,788 567,083 815,166 316,321 3,003,191 3,493,078 514 23,626 6,034 10,187 104,310 138,618 - - - - - - - - - 20,126 21,046 2,251 442 3,057 12,232 42,067 462,740 499,493 445,445 4,185,053 4,966,872 397,457 4,465,744 5,087,372 445,445 4,185,053 4,966,872 (47,988) 280,692 120,500 Starting Fund Balance (972,783) (972,783) Net Change 3,016 280,692 Ending Fund Balance (969,767) (692,091) Budget by Organization Report Through 11/30/17 Prior Fiscal Year Activity 2017 Classification Budget Fund 520 - SOLID WASTE FUND REVENUE Licenses, Permits and Fees 275,000 Charges for Services 3,632,394 Interfund Transfers 1,055,967 Intergovernmental Revenue - Other Revenue 238,000 Interest Income - REVENUE TOTALS 5,201,361 EXPENSE Salary and Benefits 750,241 Services and Supplies 3,732,176 Capital Outlay 25,750 Insurance and Other Chargebacks 149,325 Community Sponsored Organizations - Depreciation Expense - Contingencies - Debt Service 21,046 Miscellaneous 15,000 Interfund Transfers 504,807 EXPENSE TOTALS 5,198,345 Fund 520 - SOLID WASTE FUND Totals 3,016 Fund 520 - SOLID WASTE FUND Totals REVENUE TOTALS 5,201,361 EXPENSE TOTALS 5,198,345 Run by Kate LewisLakin on 01/03/2018 03:11:35 PM Page 31 of 36 November YTD 2016 2017 2017 Actuals 283,620 2,819,816 3,387,680 - - - - - - 1,623 19,016 14,415 297 297 - 285,540 2,839,129 3,402,094 70,673 821,327 897,673 145,909 1,627,846 1,912,423 - - - 16,128 171,529 167,952 - - 44 - - - - - - - - - 2,319 25,514 26,762 235,030 2,646,216 3,004,854 285,540 2,839,129 3,402,094 235,030 2,646,216 3,004,854 50,510 192,913 397,241 Starting Fund Balance 762,744 762,744 Net Change (248,021) 192,913 Ending Fund Balance 514,723 955,657 Budget by Organization Report Through 11/30/17 Prior Fiscal Year Activity 2017 Classification Budget Fund 600 - FLEET SERVICES FUND REVENUE Charges for Services 3,388,435 Interfund Transfers - Intergovernmental Revenue - Other Revenue 81,781 Interest Income 1,000 REVENUE TOTALS 3,471,216 EXPENSE Salary and Benefits 1,071,267 Services and Supplies 2,380,057 Capital Outlay - Insurance and Other Chargebacks 239,630 Depreciation Expense - Contingencies 450 Debt Service - Miscellaneous - Interfund Transfers 27,833 EXPENSE TOTALS 3,719,237 EXPENSE TOTALS 3,719,237 Fund 600 - FLEET SERVICES FUND Totals (248,021) Fund 600 - FLEET SERVICES FUND Totals REVENUE TOTALS 3,471,216 Run by Kate LewisLakin on 01/03/2018 03:11:35 PM Page 32 of 36 November YTD 2016 2017 2017 Actuals 129,171 1,270,886 1,455,172 - - - 8,890 66,961 63,430 1,614 1,614 - 139,676 1,339,460 1,518,602 3,570 61,630 102,765 3,630 637,893 - - - 1,624,064 - - - 7,200 699,523 1,726,829 139,676 1,339,460 1,518,602 7,200 699,523 1,726,829 132,476 639,938 (208,226) Starting Fund Balance 885,333 885,333 Net Change 229,853 639,938 Ending Fund Balance 1,115,186 1,525,271 Budget by Organization Report Through 11/30/17 Prior Fiscal Year Activity 2017 Classification Budget Fund 601 - EQUIPMENT REPLACEMENT FUND REVENUE Charges for Services 1,550,058 Interfund Transfers - Other Revenue 210,217 Interest Income - REVENUE TOTALS 1,760,275 EXPENSE Services and Supplies 75,000 Capital Outlay 1,455,422 Depreciation Expense - Miscellaneous - EXPENSE TOTALS 1,530,422 EXPENSE TOTALS 1,530,422 Fund 601 - EQUIPMENT REPLACEMENT 229,853 Fund 601 - EQUIPMENT REPLACEMENT REVENUE TOTALS 1,760,275 Run by Kate LewisLakin on 01/03/2018 03:11:35 PM Page 33 of 36 November YTD 2016 2017 2017 Actuals 13,534 148,877 441,246 68 752 - - - - 914,981 9,784,349 9,995,502 83,610 974,810 89,822 471,056 5,096,406 6,546,063 66 340 218 1,483,317 16,005,534 17,072,851 27,966 468,972 448,109 651,885 2,190,896 4,704,399 - - - 1,431,864 15,251,796 14,539,279 - - - - - - - - - - - - - - 4,330 803 8,829 9,262 2,112,518 17,920,494 19,705,379 1,483,317 16,005,534 17,072,851 2,112,518 17,920,494 19,705,379 (629,201) (1,914,959) (2,632,528) Starting Fund Balance (2,997,025) (2,997,025) Net Change (224,815) (1,914,959) Ending Fund Balance (3,221,840) (4,911,984) Budget by Organization Report Through 11/30/17 Prior Fiscal Year Activity 2017 Classification Budget Fund 605 - INSURANCE FUND REVENUE Charges for Services 162,411 Interfund Transfers 4,987 Intergovernmental Revenue - Other Revenue 11,237,646 Workers Compensation and Liability 1,030,815 Insurance 6,413,937 Interest Income 1,000 REVENUE TOTALS 18,850,796 EXPENSE Salary and Benefits 534,441 Services and Supplies 2,385,248 Capital Outlay - Insurance and Other Chargebacks 16,146,290 Community Sponsored Organizations - Depreciation Expense - Contingencies - Debt Service - Miscellaneous - Interfund Transfers 9,632 EXPENSE TOTALS 19,075,611 EXPENSE TOTALS 19,075,611 Fund 605 - INSURANCE FUND Totals (224,815) Fund 605 - INSURANCE FUND Totals REVENUE TOTALS 18,850,796 Run by Kate LewisLakin on 01/03/2018 03:11:35 PM Page 34 of 36 November YTD 2016 2017 2017 Actuals - - - - - - - - - 911,841 15,690,035 10,902,978 88,111 1,225,316 1,559,737 999,952 16,915,351 12,462,715 718,537 7,936,666 8,429,695 - - - - - - - - - - 88,046 174,111 718,537 8,024,713 8,603,806 999,952 16,915,351 12,462,715 718,537 8,024,713 8,603,806 281,415 8,890,638 3,858,910 Starting Fund Balance 70,599,998 70,599,998 Net Change 4,636,709 8,890,638 Ending Fund Balance 75,236,707 79,490,636 Budget by Organization Report Through 11/30/17 Prior Fiscal Year Activity 2017 Classification Budget Fund 700 - FIRE PENSION FUND REVENUE Property Taxes 7,868,709 Other Taxes 280,000 Interfund Transfers 43,000 Other Revenue 1,050,000 Interest Income 4,100,000 REVENUE TOTALS 13,341,709 EXPENSE Salary and Benefits 8,705,000 Services and Supplies - Community Sponsored Organizations - Debt Service - Miscellaneous - EXPENSE TOTALS 8,705,000 Fund 700 - FIRE PENSION FUND Totals 4,636,709 Fund 700 - FIRE PENSION FUND Totals REVENUE TOTALS 13,341,709 EXPENSE TOTALS 8,705,000 Run by Kate LewisLakin on 01/03/2018 03:11:35 PM Page 35 of 36 November YTD 2016 2017 2017 Actuals - - - - - - - - - 2,067,299 23,807,268 16,286,867 164,306 2,339,917 2,713,348 2,231,605 26,147,185 19,000,215 1,101,014 10,661,635 11,094,711 - - - - - - 46,140 248,527 272,795 1,147,154 10,910,162 11,367,506 2,231,605 26,147,185 19,000,215 1,147,154 10,910,162 11,367,506 1,084,451 15,237,024 7,632,708 Starting Fund Balance 106,191,545 106,191,545 Net Change 6,627,200 15,237,024 Ending Fund Balance 112,818,745 121,428,569 Budget by Organization Report Through 11/30/17 Prior Fiscal Year Activity 2017 Classification Budget Fund 705 - POLICE PENSION FUND REVENUE Property Taxes 9,912,200 Other Taxes 325,000 Interfund Transfers 57,000 Other Revenue 1,650,000 Interest Income 6,500,000 REVENUE TOTALS 18,444,200 EXPENSE Salary and Benefits 11,817,000 Services and Supplies - Debt Service - Miscellaneous - EXPENSE TOTALS 11,817,000 Fund 705 - POLICE PENSION FUND Totals REVENUE TOTALS 18,444,200 EXPENSE TOTALS 11,817,000 Fund 705 - POLICE PENSION FUND Totals 6,627,200 Run by Kate LewisLakin on 01/03/2018 03:11:35 PM Page 36 of 36