Loading...
HomeMy WebLinkAbout2017.06 June Monthly Report To: Wally Bobkiewicz, City Manager Martin Lyons, Assistant City Manager/Chief Financial Officer From: Ashley King, Finance & Budget Manager Subject: June 2017 Monthly Financial Report Date: July 3, 2017 Please find attached the unaudited financial statements as of June 30, 2017. In order to present this report at the July 10th Council meeting, a number of revenues were estimated. At the end of a July, a finalized version of this report will be presented. A summary by fund for revenues, expenditures, fund and cash balances is as follows: YTD Revenues YTD Expenses YTD Net Fund Balance Cash Balance 54,060,222 54,163,809 (103,587)14,693,405 7,136,280 429,576 278,294 151,283 186,683 222,089 474,254 435,083 39,172 623,817 625,560 1,000,000 500,000 500,000 500,000 500,000 3,613,640 3,145,865 467,775 1,055,540 1,118,392 93 19,613 (19,520)(47,809) 112,890 976,191 428,995 547,196 1,960,874 1,784,173 485,514 488,597 (3,083)9,221 (165,494) 178,448 164,500 13,948 (178,328) (178,329) - 338,185 (338,185)(274,079) (274,078) 32,654 24,700 7,954 165,615 218,875 - - - 169,915 169,915 57,462 66,113 (8,651)(6,274) (6,274) 87,413 67,197 20,216 1,421,139 1,421,404 - 38,227 (38,227)151,629 (21,425) 2,454,591 2,284,654 169,937 6,794,613 5,873,532 1,320 1,244,660 (1,243,340)45,325 45,325 838,038 318,184 519,854 (230) 2,039 7,592 20,884 (13,292)403,968 412,290 - 37,110 (37,110)(66,525) (66,525) - 594,030 (594,030)61,047 61,047 117,200 116,356 844 79,138 79,138 7,498,467 1,982,485 5,515,982 6,262,037 5,631,840 684,511 3,526,957 (2,842,446)8,784,012 9,524,051 135,168 (135,168)(135,168) (135,168) 194,317 131,714 62,604 3,061,820 3,058,283 5,435,947 4,249,804 1,186,143 8,968,307 8,825,226 9,146,459 7,912,224 1,234,235 6,525,657 6,957,078 6,422,379 6,559,557 (137,177)5,556,744 2,672,693 2,446,398 2,279,930 166,469 (760,029) (1,440,365) 1,712,522 1,460,723 251,799 1,025,038 306,848 821,022 317,213 503,808 1,787,529 1,389,141 8,707,223 8,922,049 (214,826)(2,511,851) 312,517 107,883,452 102,252,879 5,630,574 66,312,777 56,172,967 Fund Fund Description 100 GENERAL FUND 176 HEALTH AND HUMAN SERVICES 175 GENERAL ASSISTANCE FUND 180 GOOD NEIGHBOR FUND 185 LIBRARY FUND 195 NEIGHBORHOOD STABILIZATION 200 MOTOR FUEL TAX FUND 205 EMERGENCY TELEPHONE (E911) 210 SPECIAL SERVICE AREA (SSA) #4 215 CDBG FUND 220 CDBG LOAN 235 NEIGHBORHOOD IMPROVEMENT 240 HOME FUND 250 AFFORDABLE HOUSING FUND 186 LIBRARY DEBT SERVICE 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 350 SPECIAL SERVICE AREA (SSA) #6 320 DEBT SERVICE FUND 415 CAPITAL IMPROVEMENTS FUND 187 LIBRARY CAPITAL 420 SPECIAL ASSESSMENT FUND 505 PARKING SYSTEM FUND 510 WATER FUND 515 SEWER FUND 605 INSURANCE FUND 520 SOLID WASTE FUND 600 FLEET SERVICES FUND 601 EQUIPMENT REPLACEMENT FUND Memorandum Included above are the ending balances as of June 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 property tax) due to the City and accounts payable/accrued expenses. During the 2016 Audit Process, a number of changes were made to the methodology behind Evanston’s financial reporting. As a result, 2017 fund balances since April look significantly different than those presented previously. In most instances, they are more closely aligned with cash. As of June 30, 2017, the General Fund is reporting a net deficit of $103,587. The General Fund balance is $14,693,415 with a cash balance of $7,136,280. There are a number of reasons that this number is different than the second quarter of 2016. June of 2017 included a third payroll; this was included in July 2016. 2017 includes an additional approximately $800,000 for pensions (both revenues and expenses) as well as the Economic Development Fund expenses. The attached supplemental charts show the General Fund Revenues at 45.51% of budget and expenses slightly higher at 45.64%. This revenue number reflects receipt of 50% of property taxes; permit revenue, however, is well-below estimates. Through June 30, 2017, the E911 Fund is showing a negative cash balance of $165,494. This is due to purchase of new software. Through June 30, 2017, the SSA #4 Fund is showing a negative fund and cash balance of $178,328. This is due to the timing of payments to the Downtown Evanston group. Through June 30, 2017, the Home Fund is showing a negative cash balance of $6,274. This will be reimbursed with draw-downs during June. Through June 30, 2017, the Library Debt Service Funds has negative fund and cash balances due to the timing of bond sales. Later in 2017, staff will request the initial reading of the 2017 Bond Ordinance which would bring in funding in the fall of 2017. Through June 30, 2017, the CDBG Fund is showing a negative cash and fund balance of $274,078. This will be reimbursed with draw-downs during July. Through June 30, 2017, the Capital Fund is showing a fund balance of $8,784,012 and a cash balance of $9,524,051. This decrease from May balances is due to the year-end close process. Now, expenses increased to reflect payables due to IDOT for work done in 2016 but recently billed in 2017. This reduces fund balances. Through June 30, 2017, the enterprise funds (Parking, Water, and Sewer) continue to spend down fund balance for capital projects during 2017. Fund   100 - GENERAL FUND 2017 Budget June Actual YTD Actual % 2016 Actual 28,639,628 1,933 15,049,361 52.55% 27,302,687 49,402,274 4,201,759 23,090,252 46.74% 44,156,868 5,496,150 148,081 1,746,809 31.78% 6,851,422 11,648,000 518,148 2,396,767 20.58% 11,012,646 115,500 1,705 92,670 80.23% 70,395 3,810,000 343,235 1,523,873 40.00% 3,611,901 640,000 (106,667) 342,214 53.47% 687,835 5,650,895 811,167 3,719,837 65.83% 5,401,563 2,642,500 150,640 1,323,901 50.10% 2,687,897 7,705,774 627,310 3,763,858 48.84% 8,099,626 839,965 352,924 587,059 69.89% 988,671 2,138,046 135,091 409,059 19.13% 1,588,331 50,100 3,404 14,563 29.07% 30,285 REVENUE TOTAL 118,778,832 7,188,730 54,060,222 45.51% 112,490,127 CITY COUNCIL 498,189 50,429 236,452 47.46% 433,601 CITY CLERK 275,488 32,991 147,038 53.37% 294,665 CITY MANAGER'S OFFICE 9,878,454 728,634 3,138,918 31.78% 7,471,734 LAW 854,050 80,552 370,273 43.35% 1,052,130 ADMINISTRATIVE SERVICES 9,700,879 973,387 4,376,095 45.11% 9,164,947 COMMUNITY DEVELOPMENT 2,804,668 286,380 1,158,213 41.30% 2,510,408 POLICE 38,223,842 3,018,849 19,315,157 50.53% 37,817,627 FIRE MGMT & SUPPORT 24,294,001 1,805,071 11,909,433 49.02% 23,235,714 HEALTH 3,582,312 345,296 1,486,464 41.49% 3,097,351 PUBLIC WORKS - - - (1,475) PARKS, REC. AND COMMUNITY SERV. 12,361,460 1,474,466 5,149,102 41.65% 11,997,476 PUBLIC WORKS AGENCY 16,212,848 1,536,769 6,876,665 42.41% 14,488,137 EXPENSE TOTAL 118,686,191 10,332,824 54,163,809 45.64% 111,562,315 REVENUE TOTALS 118,778,832 6,384,588 54,060,222 45% 112,490,127 EXPENSE TOTALS 118,686,191 10,332,824 54,163,809 46% 111,562,594 92,641 (3,948,236) (103,587) 927,533 Fines and Forfeitures June 2017 Financial Report Through 06/30/17 Summary Listing Classification Property Taxes Other Taxes License Permit Fee Fund   100 - GENERAL FUND Totals Fund   100 - GENERAL FUND Net Gain Interest Income Parking Charges for Services Parks and Recreation Charges for Services Other Charges for Services Interfund Transfers Intergovernmental Revenue Other Revenue Fund   505 - PARKING SYSTEM FUND 2017 Budget June Actual YTD Actual % 2016 Actual - 300 1,550 3,350 6,737,875 528,497 3,196,585 47.44% 6,340,992 65,000 - 56,000 86.15% 168,500 4,120,636 - 2,060,318 50.00% 3,711,768 12,125 - - 0.00% - 203,216 42,261 99,233 48.83% 195,895 35,070 4,600 22,260 63.47% 38,159 REVENUE TOTAL 11,173,922 575,658 5,435,947 48.65% 10,458,663 26,000 8,021 16,382 63.01% 26,465 1,117,119 123,423 501,525 44.89% 1,206,649 104,802 12,071 47,411 45.24% 229,588 3,222,411 222,868 1,511,138 46.89% 2,846,933 278,864 40,455 116,024 41.61% 237,610 3,020,000 265,795 876,433 29.02% (24,598) 524,102 46,180 263,002 50.18% 504,784 - - - 2,836,672 11,000 - 2,222 20.20% 5,910 4,331,771 - 141,632 3.27% 390,235 304,000 10,450 136,692 44.96% 255,626 1,584,683 106,224 637,342 40.22% 1,303,783 EXPENSE TOTAL 14,524,752 835,488 4,249,804 29.26% 9,819,656 REVENUE TOTALS 11,173,922 575,658 5,435,947 48.65% 10,458,663 EXPENSE TOTALS 14,524,752 835,488 4,249,804 29.26% 9,819,656 (3,350,830) (259,830) 1,186,143 639,007 June 2017 Financial Report Through 06/30/17 Summary Listing Classification Supplies Permit Parking Charges for Services Parks and Recreation Charges for Services Interfund Transfers Intergovernmental Revenue Other Revenue Interest Income Employee Pay Benefits Pensions Services Interfund Transfers Fund   505 - PARKING SYSTEM FUND Fund   505 - PARKING SYSTEM FUND Capital Outlay Insurance and Other Chargebacks Depreciation Expense Contingencies Debt Service Miscellaneous Fund   510 - WATER FUND 2017 Budget June Actual YTD Actual % 2016 Actual 70,000 9,509 47,654 68.08% 90,592 17,324,000 1,890,722 8,438,114 48.71% 15,851,052 36,000 4,026 22,601 62.78% 51,737 135,000 256 364 0.27% 168,482 6,828,400 589,467 622,490 9.12% 306,143 1,600 3,106 15,236 952.23% 16,536 REVENUE TOTAL 24,395,000 2,497,087 9,146,459 37.49% 16,484,543 183,365 29,301 79,623 43.42% 193,328 4,037,387 456,470 1,981,481 49.08% 3,898,385 368,658 44,126 187,264 50.80% 888,372 2,250,760 138,107 908,289 40.35% 1,743,992 1,360,390 65,796 374,544 27.53% 876,885 189,300 - - 0.00% 791 1,174,064 97,925 568,810 48.45% 1,110,835 - - - 1,973,593 1,000 - - 0.00% 1,000 1,438,470 - 421,769 29.32% 633,708 62,980 - - 0.00% 238,468 3,502,313 291,859 1,751,157 50.00% 3,502,313 EXPENSE TOTAL 14,568,688 1,123,585 6,272,936 43.06% 15,061,670 REVENUE TOTALS 24,395,000 2,497,087 9,146,459 37.49% 16,484,543 EXPENSE TOTALS 14,568,688 1,123,585 6,272,936 43.06% 15,061,670 9,826,312 1,373,502 2,873,523 1,422,873 June 2017 Financial Report Through 06/30/17 Summary Listing Classification Capital Outlay Fee Water Charges for Services Sewer Charges for Services Other Charges for Services Other Revenue Interest Income Employee Pay Benefits Pensions Services Supplies Fund   510 - WATER FUND Totals Fund   510 - WATER FUND Net Gain (Loss) Insurance and Other Chargebacks Depreciation Expense Contingencies Debt Service Miscellaneous Interfund Transfers Fund   515 - SEWER FUND 2017 Budget June Actual YTD Actual % 2016 Actual 12,501,500 1,278,678 6,418,522 51.34% 13,027,160 19,650 - - 0.00% 21,600 604,165 - - 0.00% 3,087 1,000 602 3,858 385.79% 4,450 REVENUE TOTAL 13,126,315 1,279,280 6,422,379 48.93% 13,056,297 57,040 5,711 17,902 31.38% 37,763 859,043 91,611 418,465 48.71% 862,355 73,398 8,930 39,897 54.36% 204,330 908,500 6,990 48,774 5.37% 109,493 92,300 3,249 20,080 21.75% 48,058 2,819,700 561,804 1,447,254 51.33% 15,370 432,953 35,666 214,021 49.43% 414,270 - - - 3,461,103 8,370,946 363,136 3,857,327 46.08% 1,336,366 1,500 - - 0.00% 5,000 991,677 82,640 495,838 50.00% 773,873 EXPENSE TOTAL 14,607,057 1,159,736 6,559,557 44.91% 7,267,980 REVENUE TOTALS 13,126,315 1,279,280 6,422,379 48.93% 13,056,297 EXPENSE TOTALS 14,607,057 1,159,736 6,559,557 44.91% 7,267,980 (1,480,742) 119,544 (137,177) 5,788,316 June 2017 Financial Report Through 06/30/17 Summary Listing Classification Depreciation Expense Sewer Charges for Services Other Charges for Services Other Revenue Interest Income Employee Pay Benefits Pensions Services Supplies Capital Outlay Insurance and Other Chargebacks Debt Service Miscellaneous Interfund Transfers Fund   515 - SEWER FUND Totals Fund   515 - SEWER FUND Net Gain (Loss) Fund   520 - SOLID WASTE FUND 2017 Budget June Actual YTD Actual % 2016 Actual 275,000 - 83,374 30.32% 170,144 3,632,394 304,536 1,792,618 49.35% 3,586,453 1,055,967 87,997 527,984 50.00% 1,055,967 238,000 7,964 42,424 17.83% 274,808 REVENUE TOTAL 5,201,361 400,497 2,446,398 47.03% 5,087,372 45,000 5,252 16,323 36.27% 43,025 644,768 60,936 278,021 43.12% 620,226 60,473 6,043 26,839 44.38% 151,916 3,679,126 518,058 1,622,870 44.11% 3,438,311 53,050 5,673 10,689 20.15% 54,768 25,750 28 10,650 41.36% 6,034 149,325 10,386 58,982 39.50% 138,618 21,046 - 920 4.37% 2,251 15,000 2,232 2,232 14.88% 12,232 504,807 42,067 252,404 50.00% 499,493 EXPENSE TOTAL 5,198,345 650,675 2,279,930 43.86% 4,966,872 REVENUE TOTALS 5,201,361 400,497 2,446,398 47.03% 5,087,372 EXPENSE TOTALS 5,198,345 650,675 2,279,930 43.86% 4,966,872 3,016 (250,179) 166,469 120,500 Benefits June 2017 Financial Report Through 06/30/17 Summary Listing Classification License Other Charges for Services Interfund Transfers Other Revenue Employee Pay Miscellaneous Interfund Transfers Fund   520 - SOLID WASTE FUND Totals Fund   520 - SOLID WASTE FUND Net Pensions Services Supplies Capital Outlay Insurance and Other Chargebacks Debt Service June YTD 2016 2017 2017 Actuals 1,933 15,049,361 27,302,687 4,201,759 23,090,252 44,156,868 667,934 4,236,245 17,934,463 343,235 1,523,873 3,611,901 855,140 5,385,952 8,777,295 627,310 3,763,858 8,099,626 352,924 587,059 988,671 135,091 409,049 1,588,331 - - - - - - - - - 3,404 14,573 30,285 - - - - - - 7,188,730 54,060,222 112,490,127 7,032,008 30,103,664 61,447,382 1,351,442 4,674,151 11,768,857 76,657 134,366 159,648 1,095,143 14,932,864 28,043,325 66,294 80,444 94,695 - - - 54 1,404 51,836 - - - 31,653 148,105 2,166,129 681,469 4,088,813 7,830,722 10,334,719 54,163,809 111,562,594 7,188,730 54,060,222 112,490,127 10,334,719 54,163,809 111,562,594 (3,145,989) (103,587) 927,533 Starting Fund Balance 14,796,992 14,796,992 Net Change 92,641 (103,587) Ending Fund Balance 14,889,633 14,693,405 REVENUE TOTALS 118,778,832 EXPENSE TOTALS 118,686,191 Fund 100 - GENERAL FUND Totals 92,641 EXPENSE TOTALS 118,686,191 Fund 100 - GENERAL FUND Totals Debt Service - Miscellaneous 1,200,481 Interfund Transfers 9,909,626 Community Sponsored Organizations 204,568 Depreciation Expense - Contingencies 213,519 Services and Supplies 13,716,790 Capital Outlay 499,000 Insurance and Other Chargebacks 30,321,297 REVENUE TOTALS 118,778,832 EXPENSE Salary and Benefits 62,620,910 Interest Income 50,100 Special Assessment - Reappropriation of Surplus - Workers Compensation and Liability - Insurance - Library Revenue - Interfund Transfers 7,705,774 Intergovernmental Revenue 839,965 Other Revenue 2,138,046 Licenses, Permits and Fees 17,259,650 Fines and Forfeitures 3,810,000 Charges for Services 8,933,395 Fund 100 - GENERAL FUND REVENUE Property Taxes 28,639,628 Other Taxes 49,402,274 Budget by Organization Report Through 06/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Ashley King on 07/03/2017 10:47:58 AM Page 1 of 48 June YTD 2016 2017 2017 Actuals - 457,194 827,615 - - - - - - - - - - - - - - - - - - - 16,497 49,590 - - - - - - - - - 130 564 802 - - - - - - 130 474,254 878,006 31,977 133,284 246,916 48,828 281,228 529,013 - - - 3,558 20,460 26,205 - - - - - - - - - - - - - 110 2,723 - - - 84,363 435,083 804,857 130 474,254 878,006 84,363 435,083 804,857 (84,232) 39,172 73,149 Starting Fund Balance 584,645 584,645 Net Change (252,971) 39,172 Ending Fund Balance 331,674 623,817 REVENUE TOTALS 926,000 EXPENSE TOTALS 1,178,971 Fund 175 - GENERAL ASSISTANCE FUND (252,971) EXPENSE TOTALS 1,178,971 Fund 175 - GENERAL ASSISTANCE FUND Debt Service - Miscellaneous 7,000 Interfund Transfers - Community Sponsored Organizations - Depreciation Expense - Contingencies - Services and Supplies 858,900 Capital Outlay - Insurance and Other Chargebacks 30,968 REVENUE TOTALS 926,000 EXPENSE Salary and Benefits 282,103 Interest Income 1,000 Special Assessment - Reappropriation of Surplus - Workers Compensation and Liability - Insurance - Library Revenue - Interfund Transfers - Intergovernmental Revenue - Other Revenue 25,000 Licenses, Permits and Fees - Fines and Forfeitures - Charges for Services - Fund 175 - GENERAL ASSISTANCE FUND REVENUE Property Taxes 900,000 Other Taxes - Budget by Organization Report Through 06/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Ashley King on 07/03/2017 10:47:58 AM Page 3 of 48 June YTD 2016 2017 2017 Actuals - - - 71,596 429,576 884,794 - - - - - - 71,596 429,576 884,794 - 121 61 - - - 11,742 278,172 849,333 - - - 11,742 278,294 849,394 71,596 429,576 884,794 11,742 278,294 849,394 59,854 151,283 35,400 Starting Fund Balance 35,400 35,400 Net Change - 151,283 Ending Fund Balance 35,400 186,683 EXPENSE TOTALS 859,153 Fund 176 - HEALTH AND HUMAN - Fund 176 - HEALTH AND HUMAN REVENUE TOTALS 859,153 Community Sponsored Organizations 92,098 Miscellaneous - EXPENSE TOTALS 859,153 EXPENSE Services and Supplies 767,055 Capital Outlay - Intergovernmental Revenue - Other Revenue - REVENUE TOTALS 859,153 Fund 176 - HEALTH AND HUMAN SERVICES REVENUE Charges for Services - Interfund Transfers 859,153 Budget by Organization Report Through 06/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Ashley King on 07/03/2017 10:47:58 AM Page 4 of 48 June YTD 2016 2017 2017 Actuals - 1,000,000 1,000,000 - 1,000,000 1,000,000 83,333 500,000 1,000,000 83,333 500,000 1,000,000 - 1,000,000 1,000,000 83,333 500,000 1,000,000 (83,333) 500,000 (0) Starting Fund Balance - - Net Change - 500,000 Ending Fund Balance - 500,000 EXPENSE TOTALS 1,000,000 Fund 180 - GOOD NEIGHBOR FUND Totals - Fund 180 - GOOD NEIGHBOR FUND Totals REVENUE TOTALS 1,000,000 EXPENSE Interfund Transfers 1,000,000 EXPENSE TOTALS 1,000,000 Fund 180 - GOOD NEIGHBOR FUND REVENUE Other Revenue 1,000,000 REVENUE TOTALS 1,000,000 Budget by Organization Report Through 06/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Ashley King on 07/03/2017 10:47:58 AM Page 5 of 48 June YTD 2016 2017 2017 Actuals 899 3,206,886 6,136,248 - - 4,141 13,246 75,539 152,537 30 170 - - - 235,800 - 4,920 75,418 13,211 43,887 67,943 7,152 107,040 339,027 344 2,146 4,717 34,881 3,440,587 7,015,830 496,437 2,001,831 4,246,657 166,239 734,678 1,733,725 - 314 57,842 42,632 237,233 406,708 - - - - - - - - - - - - 28,635 171,809 340,272 733,942 3,145,865 6,785,204 34,881 3,440,587 7,015,830 733,942 3,145,865 6,785,204 (699,061) 294,722 230,626 Starting Fund Balance 760,818 760,818 Net Change - 294,722 Ending Fund Balance 760,818 1,055,540 REVENUE TOTALS 7,250,345 EXPENSE TOTALS 7,250,345 Fund 185 - LIBRARY FUND Totals - EXPENSE TOTALS 7,250,345 Fund 185 - LIBRARY FUND Totals Debt Service - Miscellaneous - Interfund Transfers 343,618 Insurance and Other Chargebacks 500,433 Depreciation Expense - Contingencies - Salary and Benefits 4,460,836 Services and Supplies 1,940,058 Capital Outlay 5,400 Interest Income 5,400 REVENUE TOTALS 7,250,345 EXPENSE Intergovernmental Revenue 57,418 Other Revenue 24,849 Library Revenue 386,020 Fines and Forfeitures 164,000 Charges for Services - Interfund Transfers 190,200 Fund 185 - LIBRARY FUND REVENUE Property Taxes 6,376,358 Other Taxes 46,100 Budget by Organization Report Through 06/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Ashley King on 07/03/2017 10:47:58 AM Page 6 of 48 June YTD 2016 2017 2017 Actuals - 173,053 364,827 - - - - - 1 - 173,053 364,828 - - (1,007) - - - - 38,227 385,696 - - - - 38,227 384,689 - 173,053 364,828 - 38,227 384,689 - 134,826 (19,861) Starting Fund Balance 16,803 16,803 Net Change - 134,826 Ending Fund Balance 16,803 151,629 Fund 186 - LIBRARY DEBT SERVICE - Fund 186 - LIBRARY DEBT SERVICE REVENUE TOTALS 345,955 EXPENSE TOTALS 345,955 Miscellaneous - EXPENSE TOTALS 345,955 Services and Supplies - Capital Outlay - Debt Service 345,955 Interest Income - REVENUE TOTALS 345,955 EXPENSE Fund 186 - LIBRARY DEBT SERVICE FUND REVENUE Property Taxes 345,955 Other Revenue - Budget by Organization Report Through 06/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Ashley King on 07/03/2017 10:47:58 AM Page 8 of 48 June YTD 2016 2017 2017 Actuals - - - - - 91,447 - - - 19 93 - 19 93 91,447 2,519 10,706 22,569 - 1,860 6,060 - 2,642 39,316 373 2,147 4,173 - - - - - 1,705 377 2,259 17,623 3,269 19,613 91,447 19 93 91,447 3,269 19,613 91,447 (3,250) (19,520) - Starting Fund Balance (28,289) (28,289) Net Change (303) (19,520) Ending Fund Balance (28,592) (47,809) EXPENSE TOTALS 98,899 Fund 195 - NEIGHBORHOOD 40,601 Fund 195 - NEIGHBORHOOD REVENUE TOTALS 139,500 Miscellaneous 50,000 Interfund Transfers 4,518 EXPENSE TOTALS 98,899 Capital Outlay 7,000 Insurance and Other Chargebacks 3,984 Debt Service - EXPENSE Salary and Benefits 28,297 Services and Supplies 5,100 Other Revenue - Interest Income - REVENUE TOTALS 139,500 Fund 195 - NEIGHBORHOOD STABILIZATION FUND REVENUE Licenses, Permits and Fees - Intergovernmental Revenue 139,500 Budget by Organization Report Through 06/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Ashley King on 07/03/2017 10:47:58 AM Page 9 of 48 June YTD 2016 2017 2017 Actuals 165,352 969,816 1,896,461 - - - 1,369 6,375 6,613 - - - 166,721 976,191 1,903,074 - - - - - 130,789 - - - - - - - - - 71,499 428,995 2,189,000 71,499 428,995 2,319,789 166,721 976,191 1,903,074 71,499 428,995 2,319,789 95,221 547,196 (416,715) Starting Fund Balance 1,413,678 1,413,678 Net Change (327,990) 547,196 Ending Fund Balance 1,085,688 1,960,874 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 Interfund Transfers 857,990 EXPENSE TOTALS 2,248,990 Contingencies - Debt Service - Miscellaneous - EXPENSE Services and Supplies - Capital Outlay 1,391,000 Interest Income 1,000 Reappropriation of Surplus - REVENUE TOTALS 1,921,000 Fund 200 - MOTOR FUEL TAX FUND REVENUE Intergovernmental Revenue 1,920,000 Other Revenue - Budget by Organization Report Through 06/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Ashley King on 07/03/2017 10:47:58 AM Page 10 of 48 June YTD 2016 2017 2017 Actuals 80,550 483,038 1,038,331 - - - - - - 446 2,476 2,472 80,996 485,514 1,040,803 58,929 231,520 509,028 3,818 154,993 263,105 - 21,142 423,493 8,230 44,453 91,628 - - - - - - - - - - - - 6,081 36,489 142,207 77,059 488,597 1,429,460 80,996 485,514 1,040,803 77,059 488,597 1,429,460 3,937 (3,083) (388,657) Starting Fund Balance 12,304 12,304 Net Change (8,718) (3,083) Ending Fund Balance 3,586 9,221 Fund 205 - EMERGENCY TELEPHONE (8,718) Fund 205 - EMERGENCY TELEPHONE REVENUE TOTALS 1,021,700 EXPENSE TOTALS 1,030,418 Interfund Transfers 72,977 EXPENSE TOTALS 1,030,418 Contingencies - Debt Service - Miscellaneous - Capital Outlay 55,000 Insurance and Other Chargebacks 102,517 Community Sponsored Organizations - EXPENSE Salary and Benefits 517,524 Services and Supplies 282,400 Other Revenue - Interest Income 1,000 REVENUE TOTALS 1,021,700 Fund 205 - EMERGENCY TELEPHONE (E911) FUND REVENUE Other Taxes 1,020,700 Intergovernmental Revenue - Budget by Organization Report Through 06/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Ashley King on 07/03/2017 10:47:58 AM Page 11 of 48 June YTD 2016 2017 2017 Actuals 683 178,447 321,266 - 1 2 683 178,448 321,268 82,250 164,500 323,000 - - - - - - 82,250 164,500 323,000 683 178,448 321,268 82,250 164,500 323,000 (81,567) 13,948 (1,732) Starting Fund Balance (192,276) (192,276) Net Change - 13,948 Ending Fund Balance (192,276) (178,328) EXPENSE TOTALS 320,000 Fund 210 - SPECIAL SERVICE AREA (SSA) - Fund 210 - SPECIAL SERVICE AREA (SSA) REVENUE TOTALS 320,000 Debt Service - Miscellaneous - EXPENSE TOTALS 320,000 REVENUE TOTALS 320,000 EXPENSE Services and Supplies 320,000 Fund 210 - SPECIAL SERVICE AREA (SSA) #4 REVENUE Property Taxes 320,000 Interest Income - Budget by Organization Report Through 06/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Ashley King on 07/03/2017 10:47:58 AM Page 12 of 48 June YTD 2016 2017 2017 Actuals - - - - - - - - 2,016,478 - - 10,197 - - - - - 2,026,675 45,447 184,020 414,848 12 3,348 6,219 70,299 70,299 608,829 7,620 44,181 405,247 25,000 25,000 507,815 - - - - - - 5,485 6,958 61,555 730 4,379 17,938 154,593 338,185 2,022,452 - - 2,026,675 154,593 338,185 2,022,452 (154,593) (338,185) 4,224 Starting Fund Balance 64,106 64,106 Net Change (9,484) (338,185) Ending Fund Balance 54,622 (274,079) EXPENSE TOTALS 2,281,978 Fund 215 - CDBG FUND Totals (9,484) Fund 215 - CDBG FUND Totals REVENUE TOTALS 2,272,494 Miscellaneous 569,970 Interfund Transfers 829,458 EXPENSE TOTALS 2,281,978 Community Sponsored Organizations 175,500 Contingencies - Debt Service - Services and Supplies 220,840 Capital Outlay - Insurance and Other Chargebacks 93,120 REVENUE TOTALS 2,272,494 EXPENSE Salary and Benefits 393,090 Intergovernmental Revenue 2,272,494 Other Revenue - Interest Income - Fund 215 - CDBG FUND REVENUE Charges for Services - Interfund Transfers - Budget by Organization Report Through 06/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Ashley King on 07/03/2017 10:47:58 AM Page 13 of 48 June YTD 2016 2017 2017 Actuals - - - 7,904 32,453 208,541 5 201 4,656 7,909 32,654 213,197 - - - 23,250 24,700 160,641 - - - - - - 23,250 24,700 160,641 7,909 32,654 213,197 23,250 24,700 160,641 (15,341) 7,954 52,555 Starting Fund Balance 157,661 157,661 Net Change - 7,954 Ending Fund Balance 157,661 165,615 Fund 220 - CDBG LOAN Totals - Fund 220 - CDBG LOAN 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 REVENUE Intergovernmental Revenue - Other Revenue 293,000 Budget by Organization Report Through 06/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Ashley King on 07/03/2017 10:47:58 AM Page 14 of 48 June YTD 2016 2017 2017 Actuals - - 2,257,692 - - 47,500 - - - - - 271,359 - - 8,761 - - 2,585,312 1,718 1,718 539,508 - - 423,972 - - 241,180 177 177 73,245 - - - - - - - - - - - 1,845 - - 865,318 1,895 1,895 2,145,068 - - 2,585,312 1,895 1,895 2,145,068 (1,895) (1,895) 440,244 EXPENSE TOTALS - Fund 225 - ECONOMIC DEVELOPMENT - Fund 225 - ECONOMIC DEVELOPMENT REVENUE TOTALS - Miscellaneous - Interfund Transfers - EXPENSE TOTALS - Community Sponsored Organizations - Contingencies - Debt Service - Services and Supplies - Capital Outlay - Insurance and Other Chargebacks - REVENUE TOTALS - EXPENSE Salary and Benefits - Intergovernmental Revenue - Other Revenue - Interest Income - Fund 225 - ECONOMIC DEVELOPMENT FUND REVENUE Other Taxes - Interfund Transfers - Budget by Organization Report Through 06/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Ashley King on 07/03/2017 10:47:58 AM Page 15 of 48 June YTD 2016 2017 2017 Actuals - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Starting Fund Balance 169,915 169,915 Net Change (100,000) - Ending Fund Balance 69,915 169,915 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 06/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Ashley King on 07/03/2017 10:47:58 AM Page 16 of 48 June YTD 2016 2017 2017 Actuals - 43,758 178,211 2,282 13,692 27,259 3 12 14 2,285 57,462 205,484 4,817 19,299 31,964 - 44,348 180,110 - - - 404 2,340 (4,297) - - - - - - - 126 100 - - - 5,221 66,113 207,876 2,285 57,462 205,484 5,221 66,113 207,876 (2,936) (8,651) (2,392) Starting Fund Balance 2,377 2,377 Net Change (831) (8,651) Ending Fund Balance 1,546 (6,274) EXPENSE TOTALS 586,692 Fund 240 - HOME FUND Totals (831) Fund 240 - HOME FUND Totals REVENUE TOTALS 585,861 Miscellaneous 500 Interfund Transfers - EXPENSE TOTALS 586,692 Insurance and Other Chargebacks 4,987 Community Sponsored Organizations - Debt Service - Salary and Benefits 41,005 Services and Supplies 540,200 Capital Outlay - Interest Income - REVENUE TOTALS 585,861 EXPENSE Fund 240 - HOME FUND REVENUE Intergovernmental Revenue 585,861 Other Revenue - Budget by Organization Report Through 06/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Ashley King on 07/03/2017 10:47:58 AM Page 17 of 48 June YTD 2016 2017 2017 Actuals - 20,000 106,780 - - - - - - 417 65,833 448,343 183 1,580 1,392 600 87,413 556,515 4,817 19,298 34,138 - - 201 - - - 336 1,930 3,178 - - 735 - - - 32,708 45,969 110,956 - - - 37,861 67,197 149,207 600 87,413 556,515 37,861 67,197 149,207 (37,261) 20,216 407,308 Starting Fund Balance 1,400,923 1,400,923 Net Change (1,071,422) 20,216 Ending Fund Balance 329,501 1,421,139 Fund 250 - AFFORDABLE HOUSING FUND (1,071,422) Fund 250 - AFFORDABLE HOUSING FUND REVENUE TOTALS 635,830 EXPENSE TOTALS 1,707,252 Interfund Transfers - EXPENSE TOTALS 1,707,252 Community Sponsored Organizations 455,000 Debt Service - Miscellaneous 102,500 Services and Supplies 1,077,500 Capital Outlay - Insurance and Other Chargebacks 8,800 REVENUE TOTALS 635,830 EXPENSE Salary and Benefits 63,452 Intergovernmental Revenue - Other Revenue 585,600 Interest Income 230 Fund 250 - AFFORDABLE HOUSING FUND REVENUE Other Taxes 50,000 Interfund Transfers - Budget by Organization Report Through 06/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Ashley King on 07/03/2017 10:47:58 AM Page 18 of 48 June YTD 2016 2017 2017 Actuals - 2,439,860 4,729,649 - - - - - - - - - 3,170 14,730 14,012 3,170 2,454,591 4,743,661 - - - - - 2,750 - - 4,473 - - - 24,668 49,336 1,098,676 29,167 2,235,318 4,455,515 53,835 2,284,654 5,561,415 3,170 2,454,591 4,743,661 53,835 2,284,654 5,561,415 (50,665) 169,937 (817,754) Starting Fund Balance 6,624,676 6,624,676 Net Change (5,385,636) 169,937 Ending Fund Balance 1,239,040 6,794,613 EXPENSE TOTALS 10,540,636 Fund 300 - WASHINGTON NATIONAL TIF (5,385,636) Fund 300 - WASHINGTON NATIONAL TIF REVENUE TOTALS 5,155,000 Miscellaneous 100,000 Interfund Transfers 9,940,636 EXPENSE TOTALS 10,540,636 Services and Supplies 500,000 Capital Outlay - Debt Service - REVENUE TOTALS 5,155,000 EXPENSE Salary and Benefits - Interfund Transfers - Other Revenue - Interest Income 10,000 Fund 300 - WASHINGTON NATIONAL TIF FUND REVENUE Property Taxes 5,145,000 Other Taxes - Budget by Organization Report Through 06/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Ashley King on 07/03/2017 10:47:58 AM Page 19 of 48 June YTD 2016 2017 2017 Actuals - - (180) - - - - - - - - 35 - - (145) - - 5,652 - - 428,186 - - - - - 91,445 - - 525,284 - - (145) - - 525,284 - - (525,429) Starting Fund Balance - - Net Change - - Ending Fund Balance - - EXPENSE TOTALS - Fund 305 - SPECIAL SERVICE AREA (SSA) - Fund 305 - SPECIAL SERVICE AREA (SSA) REVENUE TOTALS - Miscellaneous - Interfund Transfers - EXPENSE TOTALS - EXPENSE Services and Supplies - Debt Service - Other Revenue - Interest Income - REVENUE TOTALS - Fund 305 - SPECIAL SERVICE AREA (SSA) #5 REVENUE Property Taxes - Interfund Transfers - Budget by Organization Report Through 06/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Ashley King on 07/03/2017 10:47:58 AM Page 20 of 48 June YTD 2016 2017 2017 Actuals - - 1,233,675 - - - - 1,320 2,319 - 1,320 1,235,994 - - 2,488 - - - - - - - - - 599,668 599,668 129,192 - - 1,741,757 599,668 599,668 1,873,437 - 1,320 1,235,994 599,668 599,668 1,873,437 (599,668) (598,347) (637,443) Starting Fund Balance 643,672 643,672 Net Change (513,865) (598,347) Ending Fund Balance 129,807 45,325 REVENUE TOTALS - EXPENSE TOTALS 513,865 Fund 310 - HOWARD-HARTREY TIF Totals (513,865) EXPENSE TOTALS 513,865 Fund 310 - HOWARD-HARTREY TIF Totals Debt Service - Miscellaneous - Interfund Transfers 513,865 Services and Supplies - Capital Outlay - Community Sponsored Organizations - Interest Income - REVENUE TOTALS - EXPENSE Fund 310 - HOWARD-HARTREY TIF REVENUE Property Taxes - Other Revenue - Budget by Organization Report Through 06/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Ashley King on 07/03/2017 10:47:58 AM Page 21 of 48 June YTD 2016 2017 2017 Actuals 1,668 5,947,345 10,438,928 256,961 1,541,765 2,999,879 - - 8,291,285 2,192 9,358 24,264 260,821 7,498,467 21,754,356 - 1,250 149,553 - 1,981,235 23,454,863 - - - - - - - 1,982,485 23,604,416 260,821 7,498,467 21,754,356 - 1,982,485 23,604,416 260,821 5,515,982 (1,850,061) Starting Fund Balance 746,055 746,055 Net Change (305,500) 5,515,982 Ending Fund Balance 440,555 6,262,037 EXPENSE TOTALS 14,431,137 Fund 320 - DEBT SERVICE FUND Totals (305,500) Fund 320 - DEBT SERVICE FUND Totals REVENUE TOTALS 14,125,637 Miscellaneous - Interfund Transfers - EXPENSE TOTALS 14,431,137 EXPENSE Services and Supplies 120,250 Debt Service 14,310,887 Other Revenue - Interest Income 1,500 REVENUE TOTALS 14,125,637 Fund 320 - DEBT SERVICE FUND REVENUE Property Taxes 10,879,993 Interfund Transfers 3,244,144 Budget by Organization Report Through 06/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Ashley King on 07/03/2017 10:47:58 AM Page 22 of 48 June YTD 2016 2017 2017 Actuals - 286,536 533,105 14,000 31,500 282,307 2 2 374 14,002 318,038 815,787 442 287,705 679,056 - - - - - - - - - 114 479 693 - - - 5,000 30,000 107,500 5,557 318,184 787,249 14,002 318,038 815,787 5,557 318,184 787,249 8,445 (146) 28,537 Starting Fund Balance (84) (84) Net Change (13,200) (146) Ending Fund Balance (13,284) (230) Fund 330 - HOWARD-RIDGE TIF FUND (13,200) Fund 330 - HOWARD-RIDGE TIF FUND REVENUE TOTALS 1,585,400 EXPENSE TOTALS 1,598,600 Interfund Transfers 60,000 EXPENSE TOTALS 1,598,600 Community Sponsored Organizations - Debt Service 600 Miscellaneous - Services and Supplies 538,000 Capital Outlay 1,000,000 Insurance and Other Chargebacks - Interest Income 400 REVENUE TOTALS 1,585,400 EXPENSE Fund 330 - HOWARD-RIDGE TIF FUND REVENUE Property Taxes 555,000 Other Revenue 1,030,000 Budget by Organization Report Through 06/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Ashley King on 07/03/2017 10:47:58 AM Page 23 of 48 June YTD 2016 2017 2017 Actuals - - - 2,057 6,170 11,311 283 1,422 1,684 2,340 7,592 12,995 - - 507 - - (1,028) - - - - - - 1,403 5,884 8,519 - - - 2,500 15,000 30,000 3,903 20,884 37,998 2,340 7,592 12,995 3,903 20,884 37,998 (1,564) (13,292) (25,003) Starting Fund Balance 417,260 417,260 Net Change (39,850) (13,292) Ending Fund Balance 377,410 403,968 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 06/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Ashley King on 07/03/2017 10:47:58 AM Page 24 of 48 June YTD 2016 2017 2017 Actuals - - - - - - - - - - - 971 - - - 4,678 37,110 28,444 4,678 37,110 29,415 - - - 4,678 37,110 29,415 (4,678) (37,110) (29,415) Starting Fund Balance (29,415) (29,415) Net Change - (37,110) Ending Fund Balance (29,415) (66,525) EXPENSE TOTALS 40,000 Fund 340 - DEMPSTER-DODGE TIF FUND 10,000 Fund 340 - DEMPSTER-DODGE TIF FUND REVENUE TOTALS 50,000 Capital Outlay - Debt Service 40,000 EXPENSE TOTALS 40,000 REVENUE TOTALS 50,000 EXPENSE Services and Supplies - Fund 340 - DEMPSTER-DODGE TIF FUND REVENUE Property Taxes - Other Revenue 50,000 Budget by Organization Report Through 06/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Ashley King on 07/03/2017 10:47:58 AM Page 25 of 48 June YTD 2016 2017 2017 Actuals - - - 520,000 520,000 1,580,000 520,000 520,000 1,580,000 - - 437 580,000 580,000 1,740,000 - 14,030 16,556 580,000 594,030 1,756,993 520,000 520,000 1,580,000 580,000 594,030 1,756,993 (60,000) (74,030) (176,993) Starting Fund Balance 135,077 135,077 Net Change (60,000) (74,030) Ending Fund Balance 75,077 61,047 EXPENSE TOTALS 60,000 Fund 345 - CHICAGO-MAIN TIF Totals (60,000) Fund 345 - CHICAGO-MAIN TIF Totals REVENUE TOTALS - Capital Outlay - Debt Service 60,000 EXPENSE TOTALS 60,000 REVENUE TOTALS - EXPENSE Services and Supplies - Fund 345 - CHICAGO-MAIN TIF REVENUE Property Taxes - Other Revenue - Budget by Organization Report Through 06/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Ashley King on 07/03/2017 10:47:58 AM Page 26 of 48 June YTD 2016 2017 2017 Actuals - 117,198 223,296 1 2 2 1 117,200 223,298 116,356 116,356 145,003 - - - 116,356 116,356 145,003 1 117,200 223,298 116,356 116,356 145,003 (116,355) 844 78,294 Starting Fund Balance 78,294 78,294 Net Change 500 844 Ending Fund Balance 78,794 79,138 Fund 350 - SPECIAL SERVICE AREA (SSA) 500 Fund 350 - SPECIAL SERVICE AREA (SSA) REVENUE TOTALS 220,500 EXPENSE TOTALS 220,000 Interfund Transfers - EXPENSE TOTALS 220,000 REVENUE TOTALS 220,500 EXPENSE Services and Supplies 220,000 Fund 350 - SPECIAL SERVICE AREA (SSA) #6 REVENUE Property Taxes 220,000 Interest Income 500 Budget by Organization Report Through 06/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Ashley King on 07/03/2017 10:47:58 AM Page 27 of 48 June YTD 2016 2017 2017 Actuals - 359,706 - 20,822 33,339 96,586 41,667 250,000 4,864,054 1,254 1,254 1,527,914 14,986 20,060 10,268,138 4,042 20,152 16,690 82,771 684,511 16,773,383 - - - 303,043 629,031 1,333,831 1,082,164 2,647,926 8,948,635 - - - - - - 41,667 250,000 490,000 1,426,873 3,526,957 10,772,466 82,771 684,511 16,773,383 1,426,873 3,526,957 10,772,466 (1,344,103) (2,842,446) 6,000,917 Starting Fund Balance 11,626,458 11,626,458 Net Change (8,583,512) (2,842,446) Ending Fund Balance 3,042,946 8,784,012 REVENUE TOTALS 21,925,000 EXPENSE TOTALS 30,508,512 Fund 415 - CAPITAL IMPROVEMENTS (8,583,512) EXPENSE TOTALS 30,508,512 Fund 415 - CAPITAL IMPROVEMENTS Debt Service - Miscellaneous - Interfund Transfers 500,000 Salary and Benefits - Services and Supplies - Capital Outlay 30,008,512 Interest Income - REVENUE TOTALS 21,925,000 EXPENSE Interfund Transfers 7,710,000 Intergovernmental Revenue 1,920,000 Other Revenue 12,295,000 Fund 415 - CAPITAL IMPROVEMENTS FUND REVENUE Licenses, Permits and Fees - Charges for Services - Budget by Organization Report Through 06/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Ashley King on 07/03/2017 10:47:58 AM Page 28 of 48 June YTD 2016 2017 2017 Actuals - - - - - - - - - - - - - - - - - - - - - - - 513,349 - - - - - - - - - 1,116 17,353 29,661 14,036 176,965 142,874 - - - 15,151 194,317 685,884 - - - - - 8,751 - - - - - - - - - - - - 21,952 131,714 360,698 21,952 131,714 369,449 15,151 194,317 685,884 21,952 131,714 369,449 (6,801) 62,604 316,435 Starting Fund Balance 2,999,216 2,999,216 Net Change (32,227) 62,604 Ending Fund Balance 2,966,989 3,061,820 REVENUE TOTALS 481,200 EXPENSE TOTALS 513,427 Fund 420 - SPECIAL ASSESSMENT FUND (32,227) EXPENSE TOTALS 513,427 Fund 420 - SPECIAL ASSESSMENT FUND Debt Service - Miscellaneous - Interfund Transfers 513,427 Services and Supplies - Capital Outlay - Insurance and Other Chargebacks - REVENUE TOTALS 481,200 EXPENSE Salary and Benefits - Interest Income 51,033 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 06/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Ashley King on 07/03/2017 10:47:58 AM Page 29 of 48 June YTD 2016 2017 2017 Actuals - - - - - - 300 1,550 3,350 - - - 528,497 3,252,585 6,509,492 - 2,060,318 3,711,768 - - - 42,261 99,233 195,895 4,600 22,260 38,159 575,658 5,435,947 10,458,663 143,516 565,318 1,462,702 263,323 1,627,162 3,084,543 265,795 876,433 (24,598) 46,180 263,002 504,784 - - - - - 2,836,672 - 2,222 5,910 - 141,632 390,235 10,450 136,692 255,626 106,224 637,342 1,303,783 835,488 4,249,804 9,819,656 575,658 5,435,947 10,458,663 835,488 4,249,804 9,819,656 (259,830) 1,186,143 639,007 Starting Fund Balance 7,782,164 7,782,164 Net Change (3,350,830) 1,186,143 Ending Fund Balance 4,431,334 8,968,307 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 Interfund Transfers 1,584,683 EXPENSE TOTALS 14,524,752 Contingencies 11,000 Debt Service 4,331,771 Miscellaneous 304,000 Insurance and Other Chargebacks 524,102 Community Sponsored Organizations - Depreciation Expense - Salary and Benefits 1,247,921 Services and Supplies 3,501,275 Capital Outlay 3,020,000 Interest Income 35,070 REVENUE TOTALS 11,173,922 EXPENSE Interfund Transfers 4,120,636 Intergovernmental Revenue 12,125 Other Revenue 203,216 Licenses, Permits and Fees - Fines and Forfeitures - Charges for Services 6,802,875 Fund 505 - PARKING SYSTEM FUND REVENUE Property Taxes - Other Taxes - Budget by Organization Report Through 06/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Ashley King on 07/03/2017 10:47:58 AM Page 30 of 48 June YTD 2016 2017 2017 Actuals - - - 9,509 47,654 90,592 1,895,004 8,461,079 16,071,271 - - - - - - 589,467 622,490 306,143 3,106 15,236 16,536 2,497,087 9,146,459 16,484,543 529,897 2,248,368 4,980,085 203,903 1,282,832 2,620,877 643,205 1,639,288 36,713 97,925 568,810 1,110,835 - - - - - 1,973,593 - - 1,000 - 421,769 633,708 - - 238,468 291,859 1,751,157 3,502,313 1,766,790 7,912,224 15,097,592 2,497,087 9,146,459 16,484,543 1,766,790 7,912,224 15,097,592 730,297 1,234,235 1,386,951 Starting Fund Balance 5,291,422 5,291,422 Net Change (4,966,507) 1,234,235 Ending Fund Balance 324,915 6,525,657 EXPENSE TOTALS 29,361,507 Fund 510 - WATER FUND Totals (4,966,507) Fund 510 - WATER FUND Totals REVENUE TOTALS 24,395,000 Miscellaneous 62,980 Interfund Transfers 3,502,313 EXPENSE TOTALS 29,361,507 Depreciation Expense - Contingencies 1,000 Debt Service 1,438,470 Capital Outlay 14,982,119 Insurance and Other Chargebacks 1,174,064 Community Sponsored Organizations - EXPENSE Salary and Benefits 4,589,411 Services and Supplies 3,611,150 Other Revenue 6,828,400 Interest Income 1,600 REVENUE TOTALS 24,395,000 Charges for Services 17,495,000 Interfund Transfers - Intergovernmental Revenue - Fund 510 - WATER FUND REVENUE Other Taxes - Licenses, Permits and Fees 70,000 Budget by Organization Report Through 06/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Ashley King on 07/03/2017 10:47:58 AM Page 31 of 48 June YTD 2016 2017 2017 Actuals 1,278,678 6,418,522 13,048,760 - - - - - 3,087 602 3,858 4,450 1,279,280 6,422,379 13,056,297 106,252 476,264 1,104,448 10,239 68,854 157,551 561,804 1,447,254 15,370 35,666 214,021 414,270 - - 3,461,103 - - - 363,136 3,857,327 1,336,366 - - 5,000 82,640 495,838 773,873 1,159,736 6,559,557 7,267,980 1,279,280 6,422,379 13,056,297 1,159,736 6,559,557 7,267,980 119,544 (137,177) 5,788,316 Starting Fund Balance 5,693,921 5,693,921 Net Change (1,480,742) (137,177) Ending Fund Balance 4,213,179 5,556,744 Fund 515 - SEWER FUND Totals (1,480,742) Fund 515 - SEWER FUND Totals REVENUE TOTALS 13,126,315 EXPENSE TOTALS 14,607,057 Interfund Transfers 991,677 EXPENSE TOTALS 14,607,057 Contingencies - Debt Service 8,370,946 Miscellaneous 1,500 Capital Outlay 2,819,700 Insurance and Other Chargebacks 432,953 Depreciation Expense - EXPENSE Salary and Benefits 989,481 Services and Supplies 1,000,800 Other Revenue 604,165 Interest Income 1,000 REVENUE TOTALS 13,126,315 Fund 515 - SEWER FUND REVENUE Charges for Services 12,521,150 Interfund Transfers - Budget by Organization Report Through 06/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Ashley King on 07/03/2017 10:47:58 AM Page 32 of 48 June YTD 2016 2017 2017 Actuals - 83,374 170,144 304,536 1,792,618 3,586,453 87,997 527,984 1,055,967 - - - 7,964 42,424 274,808 - - - 400,497 2,446,398 5,087,372 72,231 321,183 815,166 523,731 1,633,559 3,493,078 28 10,650 6,034 10,386 58,982 138,618 - - - - - - - - - - 920 2,251 2,232 2,232 12,232 42,067 252,404 499,493 650,675 2,279,930 4,966,872 400,497 2,446,398 5,087,372 650,675 2,279,930 4,966,872 (250,179) 166,469 120,500 Starting Fund Balance (926,498) (926,498) Net Change 3,016 166,469 Ending Fund Balance (923,482) (760,029) Fund 520 - SOLID WASTE FUND Totals 3,016 Fund 520 - SOLID WASTE FUND Totals REVENUE TOTALS 5,201,361 EXPENSE TOTALS 5,198,345 Interfund Transfers 504,807 EXPENSE TOTALS 5,198,345 Contingencies - Debt Service 21,046 Miscellaneous 15,000 Insurance and Other Chargebacks 149,325 Community Sponsored Organizations - Depreciation Expense - Salary and Benefits 750,241 Services and Supplies 3,732,176 Capital Outlay 25,750 Interest Income - REVENUE TOTALS 5,201,361 EXPENSE Interfund Transfers 1,055,967 Intergovernmental Revenue - Other Revenue 238,000 Fund 520 - SOLID WASTE FUND REVENUE Licenses, Permits and Fees 275,000 Charges for Services 3,632,394 Budget by Organization Report Through 06/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Ashley King on 07/03/2017 10:47:58 AM Page 33 of 48 June YTD 2016 2017 2017 Actuals 283,620 1,701,717 3,387,680 - - - - - - - 10,804 14,415 - - - 283,620 1,712,522 3,402,094 110,810 461,983 897,673 162,864 894,004 1,912,423 - - - 16,085 90,820 167,952 - - 44 - - - - - - - - - 2,319 13,917 26,762 292,078 1,460,723 3,004,854 283,620 1,712,522 3,402,094 292,078 1,460,723 3,004,854 (8,458) 251,799 397,241 Starting Fund Balance 773,239 773,239 Net Change (248,021) 251,799 Ending Fund Balance 525,218 1,025,038 EXPENSE TOTALS 3,719,237 Fund 600 - FLEET SERVICES FUND Totals (248,021) Fund 600 - FLEET SERVICES FUND Totals REVENUE TOTALS 3,471,216 Miscellaneous - Interfund Transfers 27,833 EXPENSE TOTALS 3,719,237 Depreciation Expense - Contingencies 450 Debt Service - Services and Supplies 2,380,057 Capital Outlay - Insurance and Other Chargebacks 239,630 REVENUE TOTALS 3,471,216 EXPENSE Salary and Benefits 1,071,267 Intergovernmental Revenue - Other Revenue 81,781 Interest Income 1,000 Fund 600 - FLEET SERVICES FUND REVENUE Charges for Services 3,388,435 Interfund Transfers - Budget by Organization Report Through 06/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Ashley King on 07/03/2017 10:47:58 AM Page 34 of 48 June YTD 2016 2017 2017 Actuals 129,171 775,028 1,455,172 - - - - 45,994 63,430 129,171 821,022 1,518,602 3,570 44,091 102,765 138,309 273,123 - - - 1,624,064 - - - 141,879 317,213 1,726,829 129,171 821,022 1,518,602 141,879 317,213 1,726,829 (12,707) 503,808 (208,226) Starting Fund Balance 1,283,721 1,283,721 Net Change 229,853 503,808 Ending Fund Balance 1,513,574 1,787,529 Fund 601 - EQUIPMENT REPLACEMENT 229,853 Fund 601 - EQUIPMENT REPLACEMENT REVENUE TOTALS 1,760,275 EXPENSE TOTALS 1,530,422 Miscellaneous - EXPENSE TOTALS 1,530,422 Services and Supplies 75,000 Capital Outlay 1,455,422 Depreciation Expense - Other Revenue 210,217 REVENUE TOTALS 1,760,275 EXPENSE Fund 601 - EQUIPMENT REPLACEMENT FUND REVENUE Charges for Services 1,550,058 Interfund Transfers - Budget by Organization Report Through 06/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Ashley King on 07/03/2017 10:47:58 AM Page 35 of 48 June YTD 2016 2017 2017 Actuals 13,534 81,206 441,246 68 410 - 917,300 5,210,693 9,995,502 83,342 549,972 89,822 522,481 2,864,816 6,546,063 19 127 218 1,536,744 8,707,223 17,072,851 66,357 303,219 448,109 239,576 586,674 4,004,399 - - - 1,278,836 8,027,340 14,539,279 - - - - - - - - - - - - - - 4,330 803 4,816 9,262 1,585,573 8,922,049 19,005,379 1,536,744 8,707,223 17,072,851 1,585,573 8,922,049 19,005,379 (48,828) (214,826) (1,932,528) Starting Fund Balance (639,105) (639,105) Net Change (224,815) (214,826) Ending Fund Balance (863,920) (853,931) Fund 605 - INSURANCE FUND Totals (224,815) Fund 605 - INSURANCE FUND Totals REVENUE TOTALS 18,850,796 EXPENSE TOTALS 19,075,611 Interfund Transfers 9,632 EXPENSE TOTALS 19,075,611 Contingencies - Debt Service - Miscellaneous - Insurance and Other Chargebacks 16,146,290 Community Sponsored Organizations - Depreciation Expense - Salary and Benefits 534,441 Services and Supplies 2,385,248 Capital Outlay - Interest Income 1,000 REVENUE TOTALS 18,850,796 EXPENSE Other Revenue 11,237,646 Workers Compensation and Liability 1,030,815 Insurance 6,413,937 Fund 605 - INSURANCE FUND REVENUE Charges for Services 162,411 Interfund Transfers 4,987 Budget by Organization Report Through 06/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Ashley King on 07/03/2017 10:47:58 AM Page 36 of 48 June YTD 2016 2017 2017 Actuals - - - - - - - - - 173,797 4,587,459 10,902,978 - 46 1,559,737 173,797 4,587,505 12,462,715 723,202 4,285,106 8,429,695 - - - - - - - - - - - 174,111 723,202 4,285,106 8,603,806 173,797 4,587,505 12,462,715 723,202 4,285,106 8,603,806 (549,405) 302,398 3,858,910 Starting Fund Balance 70,630,343 70,630,343 Net Change 4,636,709 302,398 Ending Fund Balance 75,267,052 70,932,741 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 Miscellaneous - EXPENSE TOTALS 8,705,000 Services and Supplies - Community Sponsored Organizations - Debt Service - REVENUE TOTALS 13,341,709 EXPENSE Salary and Benefits 8,705,000 Interfund Transfers 43,000 Other Revenue 1,050,000 Interest Income 4,100,000 Fund 700 - FIRE PENSION FUND REVENUE Property Taxes 7,868,709 Other Taxes 280,000 Budget by Organization Report Through 06/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Ashley King on 07/03/2017 10:47:58 AM Page 37 of 48 June YTD 2016 2017 2017 Actuals - - - - - - - - - 232,932 5,959,237 16,286,867 - 59 2,713,348 232,932 5,959,296 19,000,215 941,180 5,613,925 11,094,711 - - - - - - - - 272,795 941,180 5,613,925 11,367,506 232,932 5,959,296 19,000,215 941,180 5,613,925 11,367,506 (708,248) 345,371 7,632,708 Starting Fund Balance 106,204,773 106,204,773 Net Change 6,627,200 345,371 Ending Fund Balance 112,831,973 106,550,144 REVENUE TOTALS 18,444,200 EXPENSE TOTALS 11,817,000 Fund 705 - POLICE PENSION FUND Totals 6,627,200 EXPENSE TOTALS 11,817,000 Fund 705 - POLICE PENSION FUND Totals Services and Supplies - Debt Service - Miscellaneous - REVENUE TOTALS 18,444,200 EXPENSE Salary and Benefits 11,817,000 Interfund Transfers 57,000 Other Revenue 1,650,000 Interest Income 6,500,000 Fund 705 - POLICE PENSION FUND REVENUE Property Taxes 9,912,200 Other Taxes 325,000 Budget by Organization Report Through 06/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Ashley King on 07/03/2017 10:47:58 AM Page 38 of 48