Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2017.01 January Monthly Report
To: Wally Bobkiewicz, City Manager Martin Lyons, Assistant City Manager/Chief Financial Officer From: Ashley King, Finance & Budget Manager Subject: January 2017 Monthly Financial Report Date: March 15, 2017 Please find attached the unaudited financial statements as of January 31, 2017. A summary by fund for revenues, expenditures, fund and cash balances is as follows: YTD Revenues YTD Expenses YTD Net YTD Fund Balance YTD Cash Balance 6,334,469 5,687,653 646,816 15,443,809 6,338,271 71,596 61 71,535 106,935 142,342 16,707 59,145 (42,438)542,207 545,237 83,333 (83,333)(83,333)916,667 87,188 317,504 (230,316)530,502 543,561 8 2,127 (2,118)(30,407)130,292 177,396 71,499 105,897 1,519,575 1,342,874 79,386 38,542 40,844 53,148 11,028 (192,276)(192,276) 58,303 (58,303)5,803 (294,700) 3,478 3,478 161,139 213,083 169,915 169,915 2,408 12,589 (10,181)(7,804)(17,850) 31,817 4,223 27,593 1,428,516 1,428,782 (11,849)638,150 9,421 372,553 (363,132)6,261,544 6,340,463 284 284 473,348 786,615 4,407 5,068 (660)(744)1,615 1,201 3,330 (2,128)415,132 423,453 (29,415)(29,415) 34,292 (34,292)100,785 100,785 502 502 78,796 78,796 280,326 280,326 1,026,381 1,041,176 44,281 41,667 2,614 9,636,431 12,150,896 84,333 21,952 62,381 361,597 3,058,060 427,473 247,928 179,546 11,666,415 8,132,497 1,670,241 700,011 970,230 6,261,652 7,310,507 1,209,198 359,543 849,655 6,543,576 4,065,914 423,547 87,259 336,288 (590,210)(1,235,496) 286,561 83,534 203,027 976,266 259,728 129,171 129,171 1,412,892 1,140,930 1,159,318 1,536,524 (377,206)(1,016,311)1,368,029 12,534,719 9,828,638 2,706,081 63,214,016 56,909,927 100 GENERAL FUND Fund Fund Description 180 GOOD NEIGHBOR FUND 185 LIBRARY FUND 176 HEALTH AND HUMAN SERVICES 175 GENERAL ASSISTANCE FUND 200 MOTOR FUEL TAX FUND 205 EMERGENCY TELEPHONE (E911) FUND 195 NEIGHBORHOOD STABILIZATION FUND 235 NEIGHBORHOOD IMPROVEMENT 220 CDBG LOAN 210 SPECIAL SERVICE AREA (SSA) #4 215 CDBG FUND 250 AFFORDABLE HOUSING FUND 186 LIBRARY DEBT SERVICE FUND 240 HOME FUND 310 HOWARD-HARTREY TIF 300 WASHINGTON NATIONAL TIF FUND305SPECIAL SERVICE AREA (SSA) #5 335 WEST EVANSTON TIF FUND 340 DEMPSTER-DODGE TIF FUND 330 HOWARD-RIDGE TIF FUND 320 DEBT SERVICE FUND 345 CHICAGO-MAIN TIF 350 SPECIAL SERVICE AREA (SSA) #6 505 PARKING SYSTEM FUND 510 WATER FUND 415 CAPITAL IMPROVEMENTS FUND 420 SPECIAL ASSESSMENT FUND 520 SOLID WASTE FUND 600 FLEET SERVICES FUND 515 SEWER FUND TOTALS 601 EQUIPMENT REPLACEMENT FUND 605 INSURANCE FUND Memorandum Included above are the ending balances as of January 31, 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. As of January 31, 2017, the General Fund is reporting a net surplus of $646,816. The General Fund balance is $15,443,809 with a cash balance of $6,338,271. This financial report is the first time that the Economic Development Fund has been merged with the General Fund—increasing both Fund and Cash balances. The attached supplemental charts show the General Fund Revenues at 5.33% of budget and expenses lower at 4.79%. This reflects the 1 ½ payrolls in January (1/2 of the first payroll accrued back to 2016 due to the actual days worked). These revenues and expenses are also low due to the lack of property tax receipts and distributions to the pension funds through January 31. Since pension property taxes are both revenu es and expenses of the General Fund, the timing is skewing the report. Through January 31, 2017, the SSA #4 Fund is showing a negative fund and cash balance of $192,276. This is due to the timing of payments to the Downtown Evanston group. Through January 31, 2017, the Home Fund is showing a negative cash balance of $17,850. Through January 31, 2017, the CDBG Fund is showing a negative cash balance of $294,700. This will be reimbursed with draw-downs during February. Through January 31, 2017, the Capital Fund is showing a fund balance of $9,636,431 and a cash balance of $12,150,896 . As the year-end close process for 2016 continues, expenses are anticipated to increase to reflect payables due to IDOT and other organizations which will be paid in 2017. This will reduce the fund balances Through January 31, 2017, the enterprise funds (Parking, Water, and Sewer) have balances above average due to the timing of capital projects for 2017. Through January 31, 2017, the Solid Waste Fund has a negative fund balance of $590,210 and a negative cash balance of $1,235,496. Through January 31, 2017, the Insurance Fund is showing a negative fund balance of $1,016,311 with a cash balance of $1,368,029. If there are any questions on the attached report, please contact me by phone at (847) 859-7884 or by email: aking@cityofevanston.org. Detailed fund summary reports can be found at: http://www.cityofevanston.org/city-budget/financial-reports/. Jan Feb Mar Apr May Jun Jul Aug Sept October November December 2016 Unreserved Fund Balance 11,859,782 2017 Unreserved Fund Balance 15,453,984 2016 Cash Balance 3,656,830 2017 Cash Balance 6,338,271 2016 v 2017 Fund and Cash Balance-- General Fund - 2,000,000 4,000,000 6,000,000 8,000,000 10,000,000 12,000,000 14,000,000 16,000,000 18,000,000 2016 Unreserved Fund Balance 2017 Unreserved Fund Balance 2016 Cash Balance 2017 Cash Balance Annual MTD YTD % of Prior Year Budget Amount Actual Amount Actual Amount Budget Total Actual 28,639,628 59,482 59,482 0.21% 27,302,687 49,402,274 4,200,513 4,200,513 8.50% 44,864,707 5,496,150 311,550 311,550 5.67% 5,398,478 11,648,000 243,027 243,027 2.09% 11,012,646 115,500 39,489 39,489 34.19% 70,395 3,810,000 93,087 93,087 2.44% 3,602,413 640,000 22,214 22,214 3.47% 646,695 5,650,895 322,648 322,648 5.71% 5,719,774 2,719,717 308,324 308,324 11.34% 2,798,972 7,705,774 653,187 653,187 8.48% 8,709,861 839,965 27,571 27,571 3.28% 779,687 2,060,829 50,780 50,780 2.46% 1,564,161 50,100 2,597 2,597 5.18% 30,285 REVENUE TOTAL 118,778,832 6,334,469 6,334,469 5.33% 112,500,763 13 - CITY COUNCIL 498,189 25,761 25,761 5.17% 424,171 14 - CITY CLERK 275,488 16,169 16,169 5.87% 293,975 15 - CITY MANAGER'S OFFICE 9,694,367 415,548 415,548 4.29% 6,907,220 17 - LAW 1,038,137 42,893 42,893 4.13% 1,046,582 19 - ADMINISTRATIVE SERVICES 9,700,879 409,740 409,740 4.22% 9,161,332 21 - COMMUNITY DEVELOPMENT 2,804,668 142,976 142,976 5.10% 2,505,921 22 - POLICE 38,223,842 1,915,780 1,915,780 5.01% 37,802,175 23 - FIRE MGMT & SUPPORT 24,294,001 1,138,446 1,138,446 4.69% 23,233,603 24 - HEALTH 3,582,312 193,772 193,772 5.41% 3,093,815 30 - PARKS, REC. AND COMMUNITY SERV. 12,361,460 503,920 503,920 4.08% 11,964,478 40 - PUBLIC WORKS AGENCY 16,212,848 882,645 882,645 5.44% 14,756,858 EXPENSE TOTAL 118,686,191 5,687,652 5,687,652 4.79% 111,190,129 118,778,832 6,334,469 6,334,469 5% 118,778,832 118,686,191 5,687,652 5,687,652 5% 111,190,129 92,641 646,817 646,817 7,588,703 Fund 100 - GENERAL FUND Net Gain (Loss) Fund 100 - GENERAL FUND Totals REVENUE TOTALS EXPENSE TOTALS Interfund Transfers Intergovernmental Revenue Other Revenue Interest Income Fines and Forfeitures Parking Charges for Services Parks and Recreation Charges for Services Other Charges for Services Property Taxes Other Taxes License Permit Fee Classification Fund 100 - GENERAL FUND January 2017 Financial Report Fund 100 - GENERAL FUND Annual MTD YTD % of Prior Year Budget Amount Actual Amount Actual Amount Budget Total Actual - 600 600 +++ 3,350 6,737,875 410,250 410,250 6.1% 6,319,024 65,000 - - 0.0% 168,500 4,120,636 - - 0.0% 3,711,768 12,125 - - 0.0% - 203,216 14,059 14,059 6.9% 195,895 35,070 2,564 2,564 7.3% 38,159 REVENUE TOTAL 11,173,922 427,473 427,473 3.8% 10,436,695 26,000 1,079 1,079 4.2% 26,465 1,117,119 62,829 62,829 5.6% 1,206,649 104,802 5,873 5,873 5.6% 105,009 3,222,411 31,116 31,116 1.0% 2,846,933 278,864 559 559 0.2% 237,610 3,020,000 - - 0.0% 2,867,258 524,102 40,248 40,248 7.7% 504,784 11,000 - - 0.0% 5,910 4,331,771 - - 0.0% 390,235 304,000 - - 0.0% 238,064 1,584,683 106,224 106,224 6.7% 1,303,783 EXPENSE TOTAL 14,524,752 247,928 247,928 1.7% 9,732,700 11,173,922 427,473 427,473 4% 10,436,695 14,524,752 247,928 247,928 2% 9,732,700 (3,350,830) 179,546 179,546 (5%) 703,995 Fund 505 - PARKING SYSTEM FUND Net January 2017 Financial Report Fund 505 - PARKING SYSTEM FUND Miscellaneous Interfund Transfers Fund 505 - PARKING SYSTEM FUND Totals REVENUE TOTALS EXPENSE TOTALS Supplies Capital Outlay Insurance and Other Chargebacks Contingencies Debt Service Employee Pay Benefits Pensions Services Interfund Transfers Intergovernmental Revenue Other Revenue Interest Income Permit Parking Charges for Services Parks and Recreation Charges for Services Classification Fund Category Proprietary Funds Fund Type Enterprise Funds Fund 505 - PARKING SYSTEM FUND Annual MTD YTD % of Prior Year Budget Amount Actual Amount Actual Amount Budget Total Actual 70,000 5,188 5,188 7.4% 90,592 17,324,000 1,656,184 1,656,184 9.6% 15,823,072 36,000 3,834 3,834 10.6% 51,737 135,000 (35) (35)0.0% 134,470 6,828,400 3,285 3,285 0.0% 258,384 1,600 1,784 1,784 111.5% 16,116 REVENUE TOTAL 24,395,000 1,670,241 1,670,241 6.8% 16,374,371 183,365 18,007 18,007 9.8% 193,328 4,037,387 249,129 249,129 6.2% 3,908,362 368,658 24,381 24,381 6.6% 393,195 2,250,760 25,877 25,877 1.1% 1,712,153 1,360,390 1,452 1,452 0.1% 900,145 14,982,119 - - 0.0% 166,709 1,174,064 82,640 82,640 7.0% 1,110,835 1,000 - - 0.0% 1,000 1,438,470 - - 0.0% 633,708 62,980 - - 0.0% 10,543 3,502,313 298,526 298,526 8.5% 12,156,871 EXPENSE TOTAL 29,361,507 700,011 700,011 2.4% 21,186,849 24,395,000 1,670,241 1,670,241 7% 16,374,371 29,361,507 700,011 700,011 5% 21,186,849 (4,966,507) 970,230 970,230 10% (4,812,478) Interfund Transfers Fund 510 - WATER FUND Totals REVENUE TOTALS EXPENSE TOTALS Fund 510 - WATER FUND Net Gain (Loss) Capital Outlay Insurance and Other Chargebacks Contingencies Debt Service Miscellaneous Benefits Pensions Services Supplies Other Charges for Services Other Revenue Interest Income Employee Pay Fee Water Charges for Services Sewer Charges for Services Classification Fund Category Proprietary Funds Fund Type Enterprise Funds Fund 510 - WATER FUND January 2017 Financial Report Fund 510 - WATER FUND Annual MTD YTD % of Prior Year Budget Amount Actual Amount Actual Amount Budget Total Actual 12,501,500 1,208,831 1,208,831 9.67% 13,027,160 19,650 - - 0.00% 21,600 604,165 - - 0.00% 3,087 1,000 367 367 36.72% 4,450 REVENUE TOTAL 13,126,315 1,209,198 1,209,198 9.21% 13,056,297 57,040 5,062 5,062 8.87% 37,763 859,043 52,495 52,495 6.11% 862,355 73,398 5,281 5,281 7.20% 85,100 908,500 - - 0.00% 535,327 92,300 243 243 0.26% 48,058 2,819,700 - - 0.00% 790,772 432,953 33,369 33,369 7.71% 414,270 8,370,946 180,453 180,453 2.16% 1,336,366 1,500 - - 0.00% 5,000 991,677 82,640 82,640 8.33% 773,873 EXPENSE TOTAL 14,607,057 359,543 359,543 2.46% 4,888,884 13,126,315 1,209,198 1,209,198 9% 13,056,297 14,607,057 359,543 359,543 2% 4,888,884 (1,480,742) 849,655 849,655 (57%) 8,167,412 Fund 515 - SEWER FUND Net Gain (Loss) January 2017 Financial Report Fund 515 - SEWER FUND Miscellaneous Interfund Transfers Fund 515 - SEWER FUND Totals REVENUE TOTALS EXPENSE TOTALS Services Supplies Capital Outlay Insurance and Other Chargebacks Debt Service Employee Pay Benefits Pensions Sewer Charges for Services Other Charges for Services Other Revenue Interest Income Classification Fund Category Proprietary Funds Fund Type Enterprise Funds Fund 515 - SEWER FUND Annual MTD YTD % of Prior Year Budget Amount Actual Amount Actual Amount Budget Total Actual 275,000 44,740 44,740 16.27% 125,404 3,632,394 290,359 290,359 7.99% 3,586,453 1,055,967 87,997 87,997 8.33% 1,055,967 238,000 450 450 0.19% 274,808 REVENUE TOTAL 5,201,361 423,547 423,547 8.14% 5,042,632 45,000 937 937 2.08% 43,025 644,768 31,722 31,722 4.92% 620,226 60,473 2,991 2,991 4.95% 63,448 3,679,126 952 952 0.03% 3,300,142 53,050 1,093 1,093 2.06% 54,768 25,750 - - 0.00% 6,034 149,325 7,498 7,498 5.02% 138,618 21,046 - - 0.00% 2,251 15,000 - - 0.00% 12,232 504,807 42,067 42,067 8.33% 499,493 EXPENSE TOTAL 5,198,345 87,259 87,259 1.68% 4,740,235 5,201,361 423,547 423,547 8% 5,042,632 5,198,345 87,259 87,259 2% 4,740,235 3,016 336,288 336,288 11,150% 302,397 REVENUE TOTALS EXPENSE TOTALS Fund 520 - SOLID WASTE FUND Net Gain Insurance and Other Chargebacks Debt Service Miscellaneous Interfund Transfers Fund 520 - SOLID WASTE FUND Totals Services Supplies Capital Outlay Interfund Transfers Other Revenue Employee Pay Benefits Pensions License Other Charges for Services Classification Fund Category Proprietary Funds Fund Type Enterprise Funds Fund 520 - SOLID WASTE FUND January 2017 Financial Report Fund 520 - SOLID WASTE FUND January YTD 2016 2017 2017 Actual 59,482 59,482 27,302,687 4,200,513 4,200,513 44,864,707 594,066 594,066 16,481,519 93,087 93,087 3,602,413 653,187 653,187 9,165,441 661,535 661,535 8,709,861 27,571 27,571 779,687 42,270 42,270 1,564,161 - - - - - - - - - 2,759 2,759 30,285 - - - - - - 6,334,469 6,334,469 112,500,763 3,891,093 3,891,093 61,447,382 290,553 290,553 11,800,411 3,691 3,691 194,933 817,508 817,508 28,062,250 - - 865,156 - - - - - 51,836 - - - 3,338 3,338 1,694,150 681,469 681,469 7,041,881 5,687,652 5,687,652 111,157,999 6,334,469 6,334,469 112,500,763 5,687,652 5,687,652 111,157,999 646,817 646,817 1,342,764 Starting Fund Balance 14,796,992 14,796,992 Net Change 92,641 646,817 Ending Fund Balance 14,889,633 15,443,809 REVENUE TOTALS 118,778,832 EXPENSE TOTALS 118,686,191 Fund 100 - GENERAL FUND Totals 92,641 Fund 100 - GENERAL FUND Totals Contingencies 213,519 Debt Service - Miscellaneous 1,200,481 Interfund Transfers 9,909,626 EXPENSE TOTALS 118,686,191 Insurance and Other Chargebacks 30,321,297 Community Sponsored Organizations 204,568 Depreciation Expense - Capital Outlay 499,000 Special Assessment - Reappropriation of Surplus - REVENUE TOTALS 118,778,832 EXPENSE Salary and Benefits 62,620,910 Services and Supplies 13,716,790 Insurance - Library Revenue - Interest Income 50,100 Intergovernmental Revenue 839,965 Other Revenue 2,060,829 Workers Compensation and Liability - Fines and Forfeitures 3,810,000 Charges for Services 9,010,612 Interfund Transfers 7,705,774 Licenses, Permits and Fees 17,259,650 Budget by Organization Report Through 01/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 100 - GENERAL FUND REVENUE Property Taxes 28,639,628 Other Taxes 49,402,274 Run by Ashley King on 03/02/2017 12:01:44 PM Page 1 of 45 January YTD 2016 2017 2017 Actual 2,891 2,891 827,615 - - - - - - - - - - - - - - - - - 167 13,759 13,759 49,423 - - - - - - - - - 58 58 802 - - - - - - 16,707 16,707 878,006 15,770 15,770 246,916 40,556 40,556 529,013 - - - 2,819 2,819 26,205 - - - - - - - - - - - - - - 2,723 - - - 59,145 59,145 804,857 16,707 16,707 878,006 59,145 59,145 804,857 (42,438) (42,438) 73,149 Starting Fund Balance 584,645 584,645 Net Change (252,971) (42,438) Ending Fund Balance 331,674 542,207 REVENUE TOTALS 926,000 EXPENSE TOTALS 1,178,971 Fund 175 - GENERAL (252,971) Fund 175 - GENERAL Contingencies - Debt Service - Miscellaneous 7,000 Interfund Transfers - EXPENSE TOTALS 1,178,971 Insurance and Other Chargebacks 30,968 Community Sponsored Organizations - Depreciation Expense - Capital Outlay - Special Assessment - Reappropriation of Surplus - REVENUE TOTALS 926,000 EXPENSE Salary and Benefits 282,103 Services and Supplies 858,900 Insurance - Library Revenue - Interest Income 1,000 Intergovernmental Revenue - Other Revenue 25,000 Workers Compensation and Liability - Fines and Forfeitures - Charges for Services - Interfund Transfers - Licenses, Permits and Fees - Budget by Organization Report Through 01/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 175 - GENERAL ASSISTANCE FUND REVENUE Property Taxes 900,000 Other Taxes - Run by Ashley King on 03/02/2017 12:01:44 PM Page 2 of 45 January YTD 2016 2017 2017 Actual - - - 71,596 71,596 884,794 - - - - - - 71,596 71,596 884,794 61 61 61 - - - - - 849,333 - - - 61 61 849,394 71,596 71,596 884,794 61 61 849,394 71,535 71,535 35,400 Starting Fund Balance 35,400 35,400 Net Change - 71,535 Ending Fund Balance 35,400 106,935 EXPENSE TOTALS 859,153 Fund 176 - HEALTH AND HUMAN - EXPENSE TOTALS 859,153 Fund 176 - HEALTH AND HUMAN REVENUE TOTALS 859,153 Capital Outlay - Community Sponsored Organizations 92,098 Miscellaneous - Services and Supplies 767,055 REVENUE Charges for Services - Interfund Transfers 859,153 Intergovernmental Revenue - Other Revenue - REVENUE TOTALS 859,153 EXPENSE Fund 176 - HEALTH AND HUMAN SERVICES Budget by Organization Report Through 01/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Ashley King on 03/02/2017 12:01:44 PM Page 3 of 45 January YTD 2016 2017 2017 Actual - - 1,000,000 - - 1,000,000 83,333 83,333 1,000,000 83,333 83,333 1,000,000 - - 1,000,000 83,333 83,333 1,000,000 (83,333) (83,333) (0) Starting Fund Balance - - Net Change - (83,333) Ending Fund Balance - (83,333) REVENUE TOTALS 1,000,000 EXPENSE TOTALS 1,000,000 Fund 180 - GOOD NEIGHBOR - Fund 180 - GOOD NEIGHBOR REVENUE Other Revenue 1,000,000 REVENUE TOTALS 1,000,000 EXPENSE Interfund Transfers 1,000,000 EXPENSE TOTALS 1,000,000 Fund 180 - GOOD NEIGHBOR FUND Budget by Organization Report Through 01/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Ashley King on 03/02/2017 12:01:44 PM Page 4 of 45 January YTD 2016 2017 2017 Actual 16,954 16,954 6,136,248 - - - 12,376 12,376 152,537 - - 235,800 2,000 2,000 75,418 150 150 66,689 55,591 55,591 337,011 117 117 4,717 87,188 87,188 7,008,420 236,155 236,155 4,246,657 24,233 24,233 1,658,209 - - 16,395 28,481 28,481 406,163 - - - - - - - - - - - 250,000 28,635 28,635 90,272 317,504 317,504 6,667,696 87,188 87,188 7,008,420 317,504 317,504 6,667,696 (230,316) (230,316) 340,724 Starting Fund Balance 760,818 760,818 Net Change - (230,316) Ending Fund Balance 760,818 530,502 EXPENSE TOTALS 7,250,345 Fund 185 - LIBRARY FUND Totals - EXPENSE TOTALS 7,250,345 Fund 185 - LIBRARY FUND Totals REVENUE TOTALS 7,250,345 Debt Service - Miscellaneous - Interfund Transfers 343,618 Insurance and Other Chargebacks 500,433 Depreciation Expense - Contingencies - Capital Outlay 5,400 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 Interfund Transfers 190,200 Intergovernmental Revenue 57,418 Other Revenue 24,849 Fines and Forfeitures 164,000 Budget by Organization Report Through 01/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 185 - LIBRARY FUND REVENUE Property Taxes 6,376,358 Other Taxes 46,100 Run by Ashley King on 03/02/2017 12:01:44 PM Page 5 of 45 January YTD 2016 2017 2017 Actual - - 364,827 - - 676,150 - - 1 - - 1,040,978 - - 12,349 - - 41,447 - - 385,696 - - - - - 439,491 - - 1,040,978 - - 439,491 - - 601,487 Starting Fund Balance (11,849) (11,849) Net Change - - Ending Fund Balance (11,849) (11,849) Fund 186 - LIBRARY DEBT - Fund 186 - LIBRARY DEBT REVENUE TOTALS 345,955 EXPENSE TOTALS 345,955 Debt Service 345,955 Miscellaneous - EXPENSE TOTALS 345,955 Capital Outlay - REVENUE Property Taxes 345,955 Other Revenue - Interest Income - REVENUE TOTALS 345,955 EXPENSE Services and Supplies - Fund 186 - LIBRARY DEBT SERVICE FUND Budget by Organization Report Through 01/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Ashley King on 03/02/2017 12:01:44 PM Page 6 of 45 January YTD 2016 2017 2017 Actual - - - - - 91,447 - - - 8 8 - 8 8 91,447 1,470 1,470 22,569 - - 6,060 - - 39,316 280 280 4,173 - - - - - 1,705 377 377 17,623 2,127 2,127 91,447 8 8 91,447 2,127 2,127 91,447 (2,118) (2,118) - Starting Fund Balance (28,289) (28,289) Net Change (303) (2,118) Ending Fund Balance (28,592) (30,407) EXPENSE TOTALS 98,899 Fund 195 - NEIGHBORHOOD 40,601 EXPENSE TOTALS 98,899 Fund 195 - NEIGHBORHOOD REVENUE TOTALS 139,500 Debt Service - Miscellaneous 50,000 Interfund Transfers 4,518 Services and Supplies 5,100 Capital Outlay 7,000 Insurance and Other Chargebacks 3,984 Salary and Benefits 28,297 REVENUE Licenses, Permits and Fees - Intergovernmental Revenue 139,500 Other Revenue - Interest Income - REVENUE TOTALS 139,500 EXPENSE Fund 195 - NEIGHBORHOOD STABILIZATION FUND Budget by Organization Report Through 01/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Ashley King on 03/02/2017 12:01:44 PM Page 7 of 45 January YTD 2016 2017 2017 Actual 176,701 176,701 1,896,461 - - - 695 695 6,613 - - - 177,396 177,396 1,903,074 - - - - - 130,789 - - - - - - - - - 71,499 71,499 2,189,000 71,499 71,499 2,319,789 177,396 177,396 1,903,074 71,499 71,499 2,319,789 105,897 105,897 (416,715) Starting Fund Balance 1,413,678 1,413,678 Net Change (327,990) 105,897 Ending Fund Balance 1,085,688 1,519,575 Fund 200 - MOTOR FUEL TAX (327,990) Fund 200 - MOTOR FUEL TAX REVENUE TOTALS 1,921,000 EXPENSE TOTALS 2,248,990 Miscellaneous - Interfund Transfers 857,990 EXPENSE TOTALS 2,248,990 Capital Outlay 1,391,000 Contingencies - Debt Service - Services and Supplies - REVENUE Intergovernmental Revenue 1,920,000 Other Revenue - Interest Income 1,000 Reappropriation of Surplus - REVENUE TOTALS 1,921,000 EXPENSE Fund 200 - MOTOR FUEL TAX FUND Budget by Organization Report Through 01/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Ashley King on 03/02/2017 12:01:44 PM Page 8 of 45 January YTD 2016 2017 2017 Actual 79,119 79,119 1,038,331 - - - - - - 267 267 2,472 79,386 79,386 1,040,803 23,177 23,177 509,028 3,982 3,982 263,105 - - 423,493 5,301 5,301 91,628 - - - - - - - - - - - - 6,081 6,081 142,207 38,542 38,542 1,429,460 79,386 79,386 1,040,803 38,542 38,542 1,429,460 40,844 40,844 (388,657) Starting Fund Balance 12,304 12,304 Net Change (8,718) 40,844 Ending Fund Balance 3,586 53,148 Fund 205 - EMERGENCY (8,718) Fund 205 - EMERGENCY REVENUE TOTALS 1,021,700 EXPENSE TOTALS 1,030,418 Miscellaneous - Interfund Transfers 72,977 EXPENSE TOTALS 1,030,418 Community Sponsored Organizations - Contingencies - Debt Service - Services and Supplies 282,400 Capital Outlay 55,000 Insurance and Other Chargebacks 102,517 Salary and Benefits 517,524 REVENUE Other Taxes 1,020,700 Intergovernmental Revenue - Other Revenue - Interest Income 1,000 REVENUE TOTALS 1,021,700 EXPENSE Fund 205 - EMERGENCY TELEPHONE (E911) FUND Budget by Organization Report Through 01/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Ashley King on 03/02/2017 12:01:44 PM Page 9 of 45 January YTD 2016 2017 2017 Actual - - 321,266 - - 2 - - 321,268 - - 323,000 - - - - - - - - 323,000 - - 321,268 - - 323,000 - - (1,732) Starting Fund Balance (192,276) (192,276) Net Change - - Ending Fund Balance (192,276) (192,276) EXPENSE TOTALS 320,000 Fund 210 - SPECIAL SERVICE - EXPENSE TOTALS 320,000 Fund 210 - SPECIAL SERVICE REVENUE TOTALS 320,000 Miscellaneous - REVENUE Property Taxes 320,000 Interest Income - REVENUE TOTALS 320,000 EXPENSE Services and Supplies 320,000 Debt Service - Fund 210 - SPECIAL SERVICE AREA (SSA) #4 Budget by Organization Report Through 01/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Ashley King on 03/02/2017 12:01:44 PM Page 10 of 45 January YTD 2016 2017 2017 Actual - - - - - - - - 2,016,478 - - 10,197 - - - - - 2,026,675 23,936 23,936 414,848 - - 6,219 - - 608,829 6,079 6,079 87,411 - - 360,315 - - - - - - - - 209,055 28,288 28,288 335,774 58,303 58,303 2,022,452 - - 2,026,675 58,303 58,303 2,022,452 (58,303) (58,303) 4,224 Starting Fund Balance 64,106 64,106 Net Change (9,484) (58,303) Ending Fund Balance 54,622 5,803 EXPENSE TOTALS 2,281,978 Fund 215 - CDBG FUND Totals (9,484) EXPENSE TOTALS 2,281,978 Fund 215 - CDBG FUND Totals REVENUE TOTALS 2,272,494 Debt Service - Miscellaneous 745,470 Interfund Transfers 829,458 Insurance and Other Chargebacks 93,120 Community Sponsored Organizations - Contingencies - Capital Outlay - Other Revenue - Interest Income - REVENUE TOTALS 2,272,494 EXPENSE Salary and Benefits 393,090 Services and Supplies 220,840 Intergovernmental Revenue 2,272,494 Budget by Organization Report Through 01/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 215 - CDBG FUND REVENUE Charges for Services - Interfund Transfers - Run by Ashley King on 03/02/2017 12:01:44 PM Page 11 of 45 January YTD 2016 2017 2017 Actual - - - 3,460 3,460 208,541 18 18 4,656 3,478 3,478 213,197 - - - - - 160,641 - - - - - - - - 160,641 3,478 3,478 213,197 - - 160,641 3,478 3,478 52,555 Starting Fund Balance 157,661 157,661 Net Change - 3,478 Ending Fund Balance 157,661 161,139 Fund 220 - CDBG LOAN Totals - Fund 220 - CDBG LOAN Totals REVENUE TOTALS 293,000 EXPENSE TOTALS 293,000 Miscellaneous - Interfund Transfers - EXPENSE TOTALS 293,000 Services and Supplies 293,000 REVENUE Intergovernmental Revenue - Other Revenue 293,000 Interest Income - REVENUE TOTALS 293,000 EXPENSE Salary and Benefits - Fund 220 - CDBG LOAN Budget by Organization Report Through 01/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Ashley King on 03/02/2017 12:01:44 PM Page 12 of 45 January YTD 2016 2017 2017 Actual - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 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) EXPENSE TOTALS 100,000 Fund 235 - NEIGHBORHOOD REVENUE TOTALS - Debt Service - Miscellaneous 100,000 Interfund Transfers - Capital Outlay - REVENUE Other Taxes - Interfund Transfers - Interest Income - REVENUE TOTALS - EXPENSE Services and Supplies - Fund 235 - NEIGHBORHOOD IMPROVEMENT Budget by Organization Report Through 01/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Ashley King on 03/02/2017 12:01:44 PM Page 13 of 45 January YTD 2016 2017 2017 Actual - - 246,511 2,407 2,407 27,259 1 1 14 2,408 2,408 273,784 2,243 2,243 31,964 10,025 10,025 248,410 - - - 320 320 3,998 - - - - - - - - 100 - - (8,295) 12,589 12,589 276,177 2,408 2,408 273,784 12,589 12,589 276,177 (10,181) (10,181) (2,393) Starting Fund Balance 2,377 2,377 Net Change (831) (10,181) Ending Fund Balance 1,546 (7,804) EXPENSE TOTALS 586,692 Fund 240 - HOME FUND Totals (831) EXPENSE TOTALS 586,692 Fund 240 - HOME FUND Totals REVENUE TOTALS 585,861 Debt Service - Miscellaneous 500 Interfund Transfers - Capital Outlay - Insurance and Other Chargebacks 4,987 Community Sponsored Organizations - Services and Supplies 540,200 REVENUE Intergovernmental Revenue 585,861 Other Revenue - Interest Income - REVENUE TOTALS 585,861 EXPENSE Salary and Benefits 41,005 Fund 240 - HOME FUND Budget by Organization Report Through 01/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Ashley King on 03/02/2017 12:01:44 PM Page 14 of 45 January YTD 2016 2017 2017 Actual - - 106,780 - - - - - - 31,667 31,667 525,343 150 150 1,392 31,817 31,817 633,515 2,243 2,243 34,138 - - 201 - - - 252 252 3,178 - - 735 - - - 1,728 1,728 187,956 - - - 4,223 4,223 226,207 31,817 31,817 633,515 4,223 4,223 226,207 27,593 27,593 407,308 Starting Fund Balance 1,400,923 1,400,923 Net Change (1,071,422) 27,593 Ending Fund Balance 329,501 1,428,516 Fund 250 - AFFORDABLE (1,071,422) Fund 250 - AFFORDABLE REVENUE TOTALS 635,830 EXPENSE TOTALS 1,707,252 Miscellaneous 102,500 Interfund Transfers - EXPENSE TOTALS 1,707,252 Insurance and Other Chargebacks 8,800 Community Sponsored Organizations 455,000 Debt Service - Capital Outlay - Other Revenue 585,600 Interest Income 230 REVENUE TOTALS 635,830 EXPENSE Salary and Benefits 63,452 Services and Supplies 1,077,500 Intergovernmental Revenue - Budget by Organization Report Through 01/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 250 - AFFORDABLE HOUSING FUND REVENUE Other Taxes 50,000 Interfund Transfers - Run by Ashley King on 03/02/2017 12:01:44 PM Page 15 of 45 January YTD 2016 2017 2017 Actual 7,837 7,837 4,729,649 - - - - - - - - - 1,584 1,584 14,012 9,421 9,421 4,743,661 - - - - - 2,750 - - 4,473 - - - - - 1,098,676 372,553 372,553 4,455,515 372,553 372,553 5,561,415 9,421 9,421 4,743,661 372,553 372,553 5,561,415 (363,132) (363,132) (817,754) Starting Fund Balance 6,624,676 6,624,676 Net Change (5,385,636) (363,132) Ending Fund Balance 1,239,040 6,261,544 EXPENSE TOTALS 10,540,636 Fund 300 - WASHINGTON (5,385,636) EXPENSE TOTALS 10,540,636 Fund 300 - WASHINGTON REVENUE TOTALS 5,155,000 Debt Service - Miscellaneous 100,000 Interfund Transfers 9,940,636 Capital Outlay - Other Revenue - Interest Income 10,000 REVENUE TOTALS 5,155,000 EXPENSE Salary and Benefits - Services and Supplies 500,000 Interfund Transfers - Budget by Organization Report Through 01/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 300 - WASHINGTON NATIONAL TIF FUND REVENUE Property Taxes 5,145,000 Other Taxes - Run by Ashley King on 03/02/2017 12:01:44 PM Page 16 of 45 January YTD 2016 2017 2017 Actual - - (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 - EXPENSE TOTALS - Fund 305 - SPECIAL SERVICE REVENUE TOTALS - Debt Service - Miscellaneous - Interfund Transfers - Services and Supplies - REVENUE Property Taxes - Interfund Transfers - Other Revenue - Interest Income - REVENUE TOTALS - EXPENSE Fund 305 - SPECIAL SERVICE AREA (SSA) #5 Budget by Organization Report Through 01/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Ashley King on 03/02/2017 12:01:44 PM Page 17 of 45 January YTD 2016 2017 2017 Actual - - 1,233,675 - - - 284 284 2,319 284 284 1,235,994 - - 2,488 - - - - - - - - - - - 129,192 - - 1,741,757 - - 1,873,437 284 284 1,235,994 - - 1,873,437 284 284 (637,443) Starting Fund Balance 473,064 473,064 Net Change (87,357) 284 Ending Fund Balance 385,707 473,348 REVENUE TOTALS - EXPENSE TOTALS 87,357 Fund 310 - HOWARD-HARTREY (87,357) Fund 310 - HOWARD-HARTREY Community Sponsored Organizations - Debt Service - Miscellaneous - Interfund Transfers 87,357 EXPENSE TOTALS 87,357 Capital Outlay - REVENUE Property Taxes - Other Revenue - Interest Income - REVENUE TOTALS - EXPENSE Services and Supplies - Fund 310 - HOWARD-HARTREY TIF Budget by Organization Report Through 01/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Ashley King on 03/02/2017 12:01:44 PM Page 18 of 45 January YTD 2016 2017 2017 Actual 22,679 22,679 10,438,928 256,961 256,961 3,079,968 - - 8,211,196 686 686 24,264 280,326 280,326 21,754,356 - - 149,553 - - 23,454,863 - - - - - - - - 23,604,416 280,326 280,326 21,754,356 - - 23,604,416 280,326 280,326 (1,850,061) Starting Fund Balance 746,055 746,055 Net Change (305,500) 280,326 Ending Fund Balance 440,555 1,026,381 EXPENSE TOTALS 14,431,137 Fund 320 - DEBT SERVICE FUND (305,500) EXPENSE TOTALS 14,431,137 Fund 320 - DEBT SERVICE FUND REVENUE TOTALS 14,125,637 Debt Service 14,310,887 Miscellaneous - Interfund Transfers - Services and Supplies 120,250 REVENUE Property Taxes 10,879,993 Interfund Transfers 3,244,144 Other Revenue - Interest Income 1,500 REVENUE TOTALS 14,125,637 EXPENSE Fund 320 - DEBT SERVICE FUND Budget by Organization Report Through 01/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Ashley King on 03/02/2017 12:01:44 PM Page 19 of 45 January YTD 2016 2017 2017 Actual 4,407 4,407 533,105 - - 282,307 0 0 374 4,407 4,407 815,787 - - 679,056 - - - - - - - - - 68 68 693 - - - 5,000 5,000 107,500 5,068 5,068 787,249 4,407 4,407 815,787 5,068 5,068 787,249 (660) (660) 28,537 Starting Fund Balance (84) (84) Net Change (13,200) (660) Ending Fund Balance (13,284) (744) Fund 330 - HOWARD-RIDGE TIF (13,200) Fund 330 - HOWARD-RIDGE TIF REVENUE TOTALS 1,585,400 EXPENSE TOTALS 1,598,600 Miscellaneous - Interfund Transfers 60,000 EXPENSE TOTALS 1,598,600 Insurance and Other Chargebacks - Community Sponsored Organizations - Debt Service 600 Capital Outlay 1,000,000 REVENUE Property Taxes 555,000 Other Revenue 1,030,000 Interest Income 400 REVENUE TOTALS 1,585,400 EXPENSE Services and Supplies 538,000 Fund 330 - HOWARD-RIDGE TIF FUND Budget by Organization Report Through 01/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Ashley King on 03/02/2017 12:01:44 PM Page 20 of 45 January YTD 2016 2017 2017 Actual - - - 1,028 1,028 11,311 173 173 1,684 1,201 1,201 12,995 - - 507 - - (1,028) - - - - - - 830 830 8,519 - - - 2,500 2,500 30,000 3,330 3,330 37,998 1,201 1,201 12,995 3,330 3,330 37,998 (2,128) (2,128) (25,003) Starting Fund Balance 417,260 417,260 Net Change (39,850) (2,128) Ending Fund Balance 377,410 415,132 Fund 335 - WEST EVANSTON TIF (39,850) Fund 335 - WEST EVANSTON TIF REVENUE TOTALS 150 EXPENSE TOTALS 40,000 Miscellaneous - Interfund Transfers 30,000 EXPENSE TOTALS 40,000 Insurance and Other Chargebacks - Contingencies - Debt Service 10,000 Capital Outlay - REVENUE Property Taxes - Other Revenue - Interest Income 150 REVENUE TOTALS 150 EXPENSE Services and Supplies - Fund 335 - WEST EVANSTON TIF FUND Budget by Organization Report Through 01/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Ashley King on 03/02/2017 12:01:44 PM Page 21 of 45 January YTD 2016 2017 2017 Actual - - - - - - - - - - - 971 - - - - - 28,444 - - 29,415 - - - - - 29,415 - - (29,415) Starting Fund Balance (29,415) (29,415) Net Change - - Ending Fund Balance (29,415) (29,415) EXPENSE TOTALS 40,000 Fund 340 - DEMPSTER-DODGE 10,000 EXPENSE TOTALS 40,000 Fund 340 - DEMPSTER-DODGE REVENUE TOTALS 50,000 Debt Service 40,000 REVENUE Property Taxes - Other Revenue 50,000 REVENUE TOTALS 50,000 EXPENSE Services and Supplies - Capital Outlay - Fund 340 - DEMPSTER-DODGE TIF FUND Budget by Organization Report Through 01/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Ashley King on 03/02/2017 12:01:44 PM Page 22 of 45 January YTD 2016 2017 2017 Actual - - - - - 1,580,000 - - 1,580,000 - - 437 - - 1,740,000 34,292 34,292 16,556 34,292 34,292 1,756,993 - - 1,580,000 34,292 34,292 1,756,993 (34,292) (34,292) (176,993) Starting Fund Balance 135,077 135,077 Net Change (60,000) (34,292) Ending Fund Balance 75,077 100,785 EXPENSE TOTALS 60,000 Fund 345 - CHICAGO-MAIN TIF (60,000) EXPENSE TOTALS 60,000 Fund 345 - CHICAGO-MAIN TIF REVENUE TOTALS - Debt Service 60,000 REVENUE Property Taxes - Other Revenue - REVENUE TOTALS - EXPENSE Services and Supplies - Capital Outlay - Fund 345 - CHICAGO-MAIN TIF Budget by Organization Report Through 01/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Ashley King on 03/02/2017 12:01:44 PM Page 23 of 45 January YTD 2016 2017 2017 Actual 502 502 223,296 - - 2 502 502 223,298 - - 145,003 - - - - - 145,003 502 502 223,298 - - 145,003 502 502 78,294 Starting Fund Balance 78,294 78,294 Net Change 500 502 Ending Fund Balance 78,794 78,796 Fund 350 - SPECIAL SERVICE 500 Fund 350 - SPECIAL SERVICE REVENUE TOTALS 220,500 EXPENSE TOTALS 220,000 EXPENSE TOTALS 220,000 REVENUE Property Taxes 220,000 Interest Income 500 REVENUE TOTALS 220,500 EXPENSE Services and Supplies 220,000 Interfund Transfers - Fund 350 - SPECIAL SERVICE AREA (SSA) #6 Budget by Organization Report Through 01/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Ashley King on 03/02/2017 12:01:44 PM Page 24 of 45 January YTD 2016 2017 2017 Actual - - 96,586 41,667 41,667 4,864,054 - - 1,527,914 - - 9,591,988 2,614 2,614 16,690 44,281 44,281 16,097,233 - - - - - 1,320,475 - - 8,435,603 - - - - - - 41,667 41,667 490,000 41,667 41,667 10,246,078 44,281 44,281 16,097,233 41,667 41,667 10,246,078 2,614 2,614 5,851,155 Starting Fund Balance 9,633,817 9,633,817 Net Change (8,583,512) 2,614 Ending Fund Balance 1,050,305 9,636,431 EXPENSE TOTALS 30,508,512 Fund 415 - CAPITAL (8,583,512) EXPENSE TOTALS 30,508,512 Fund 415 - CAPITAL REVENUE TOTALS 21,925,000 Debt Service - Miscellaneous - Interfund Transfers 500,000 Capital Outlay 30,008,512 Other Revenue 12,295,000 Interest Income - REVENUE TOTALS 21,925,000 EXPENSE Salary and Benefits - Services and Supplies - Intergovernmental Revenue 1,920,000 Budget by Organization Report Through 01/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 415 - CAPITAL IMPROVEMENTS FUND REVENUE Charges for Services - Interfund Transfers 7,710,000 Run by Ashley King on 03/02/2017 12:01:44 PM Page 25 of 45 January YTD 2016 2017 2017 Actual - - - - - - - - - - - - - - - - - - - - - - - 513,349 - - - - - - - - - 13,139 13,139 29,660 71,194 71,194 142,874 - - - 84,333 84,333 685,884 - - - - - 8,751 - - - - - - - - - - - - 21,952 21,952 360,698 21,952 21,952 369,449 84,333 84,333 685,884 21,952 21,952 369,449 62,381 62,381 316,435 Starting Fund Balance 299,216 299,216 Net Change (32,227) 62,381 Ending Fund Balance 266,989 361,597 REVENUE TOTALS 481,200 EXPENSE TOTALS 513,427 Fund 420 - SPECIAL (32,227) Fund 420 - SPECIAL Insurance and Other Chargebacks - Debt Service - Miscellaneous - Interfund Transfers 513,427 EXPENSE TOTALS 513,427 Capital Outlay - Special Assessment 180,167 Reappropriation of Surplus - REVENUE TOTALS 481,200 EXPENSE Salary and Benefits - Services and Supplies - Insurance - Library Revenue - Interest Income 51,033 Intergovernmental Revenue - Other Revenue 250,000 Workers Compensation and Liability - Fines and Forfeitures - Charges for Services - Interfund Transfers - Licenses, Permits and Fees - Budget by Organization Report Through 01/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 420 - SPECIAL ASSESSMENT FUND REVENUE Property Taxes - Other Taxes - Run by Ashley King on 03/02/2017 12:01:44 PM Page 26 of 45 January YTD 2016 2017 2017 Actual - - - - - - 600 600 3,350 - - - 410,250 410,250 6,487,524 - 343,386 3,711,768 - - - 14,059 14,059 195,895 2,564 2,564 38,159 427,473 770,860 10,436,695 69,781 69,781 1,338,122 31,675 31,675 3,084,543 - - 2,867,258 40,248 40,248 504,784 - - - - - - - - 5,910 - - 390,235 - - 238,064 106,224 106,224 1,303,783 247,928 247,928 9,732,700 427,473 427,473 10,436,695 247,928 247,928 9,732,700 179,546 179,546 703,995 Starting Fund Balance 11,486,869 11,486,869 Net Change (3,350,830) 179,546 Ending Fund Balance 8,136,039 11,666,415 Fund 505 - PARKING SYSTEM (3,350,830) Fund 505 - PARKING SYSTEM REVENUE TOTALS 11,173,922 EXPENSE TOTALS 14,524,752 Miscellaneous 304,000 Interfund Transfers 1,584,683 EXPENSE TOTALS 14,524,752 Depreciation Expense - Contingencies 11,000 Debt Service 4,331,771 Capital Outlay 3,020,000 Insurance and Other Chargebacks 524,102 Community Sponsored Organizations - Services and Supplies 3,501,275 Intergovernmental Revenue 12,125 Other Revenue 203,216 Interest Income 35,070 REVENUE TOTALS 11,173,922 EXPENSE Salary and Benefits 1,247,921 Fines and Forfeitures - Charges for Services 6,802,875 Interfund Transfers 4,120,636 Licenses, Permits and Fees - Budget by Organization Report Through 01/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 505 - PARKING SYSTEM FUND REVENUE Property Taxes - Other Taxes - Run by Ashley King on 03/02/2017 12:01:44 PM Page 27 of 45 January YTD 2016 2017 2017 Actual - - - 5,188 5,188 90,592 1,659,983 1,659,983 15,983,374 - - - - - - 3,285 3,285 258,384 1,784 1,784 16,116 1,670,241 1,670,241 16,348,466 291,516 291,516 4,494,885 27,329 27,329 2,612,299 - 241,755 82,640 82,640 1,110,835 - - - - - - - - 1,000 - - 633,708 - - 10,543 298,526 298,526 11,627,377 700,011 700,011 20,732,401 16,348,466 20,732,401 (4,383,935) Starting Fund Balance 5,291,422 5,291,422 Net Change (4,966,507) 970,230 Ending Fund Balance 324,915 6,261,652 EXPENSE TOTALS 29,361,507 Fund 510 - WATER FUND Totals (4,966,507) EXPENSE TOTALS 29,361,507 Fund 510 - WATER FUND Totals REVENUE TOTALS 24,395,000 Debt Service 1,438,470 Miscellaneous 62,980 Interfund Transfers 3,502,313 Community Sponsored Organizations - Depreciation Expense - Contingencies 1,000 Services and Supplies 3,611,150 Capital Outlay 14,982,119 Insurance and Other Chargebacks 1,174,064 Salary and Benefits 4,589,411 Interfund Transfers - Intergovernmental Revenue - Other Revenue 6,828,400 Interest Income 1,600 REVENUE TOTALS 24,395,000 EXPENSE Charges for Services 17,495,000 Budget by Organization Report Through 01/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 510 - WATER FUND REVENUE Other Taxes - Licenses, Permits and Fees 70,000 970,230 970,230 1,670,241 1,670,241 700,011 700,011 Run by Ashley King on 03/02/2017 12:01:44 PM Page 28 of 45 January YTD 2016 2017 2017 Actual 1,208,831 1,208,831 13,048,760 - - - - - 3,087 367 367 4,450 1,209,198 1,209,198 13,056,297 62,838 62,838 985,218 243 243 583,385 - - 756,544 33,369 33,369 414,270 - - - - - - 180,453 180,453 1,336,366 - - 5,000 82,640 82,640 773,873 359,543 359,543 4,854,656 1,209,198 1,209,198 13,056,297 359,543 359,543 4,854,656 849,655 849,655 8,201,641 Starting Fund Balance 5,693,921 5,693,921 Net Change (1,480,742) 849,655 Ending Fund Balance 4,213,179 6,543,576 Fund 515 - SEWER FUND Totals (1,480,742) Fund 515 - SEWER FUND Totals REVENUE TOTALS 13,126,315 EXPENSE TOTALS 14,607,057 Miscellaneous 1,500 Interfund Transfers 991,677 EXPENSE TOTALS 14,607,057 Depreciation Expense - Contingencies - Debt Service 8,370,946 Services and Supplies 1,000,800 Capital Outlay 2,819,700 Insurance and Other Chargebacks 432,953 Salary and Benefits 989,481 REVENUE Charges for Services 12,521,150 Interfund Transfers - Other Revenue 604,165 Interest Income 1,000 REVENUE TOTALS 13,126,315 EXPENSE Fund 515 - SEWER FUND Budget by Organization Report Through 01/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Ashley King on 03/02/2017 12:01:44 PM Page 29 of 45 January YTD 2016 2017 2017 Actual 44,740 44,740 125,404 290,359 290,359 3,586,453 87,997 87,997 1,055,967 - - - 450 450 274,808 - - - 423,547 423,547 5,042,632 35,649 35,649 726,698 2,045 2,045 3,354,910 - - 6,034 7,498 7,498 138,618 - - - - - - - - - - - 2,251 - - 12,232 42,067 42,067 499,493 87,259 87,259 4,740,235 423,547 423,547 5,042,632 87,259 87,259 4,740,235 336,288 336,288 302,397 Starting Fund Balance (926,498) (926,498) Net Change 3,016 336,288 Ending Fund Balance (923,482) (590,210) Fund 520 - SOLID WASTE FUND 3,016 Fund 520 - SOLID WASTE FUND REVENUE TOTALS 5,201,361 EXPENSE TOTALS 5,198,345 Miscellaneous 15,000 Interfund Transfers 504,807 EXPENSE TOTALS 5,198,345 Depreciation Expense - Contingencies - Debt Service 21,046 Capital Outlay 25,750 Insurance and Other Chargebacks 149,325 Community Sponsored Organizations - Services and Supplies 3,732,176 Intergovernmental Revenue - Other Revenue 238,000 Interest Income - REVENUE TOTALS 5,201,361 EXPENSE Salary and Benefits 750,241 Interfund Transfers 1,055,967 Budget by Organization Report Through 01/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 520 - SOLID WASTE FUND REVENUE Licenses, Permits and Fees 275,000 Charges for Services 3,632,394 Run by Ashley King on 03/02/2017 12:01:44 PM Page 30 of 45 January YTD 2016 2017 2017 Actual 283,620 283,620 3,387,680 - - - - - - 2,942 2,942 14,415 - - - 286,561 286,561 3,402,094 51,197 51,197 888,262 18,505 18,505 1,911,340 - - - 11,513 11,513 167,952 - - - - - - - - - - - - 2,319 2,319 26,762 83,534 83,534 2,994,316 286,561 286,561 3,402,094 83,534 83,534 2,994,316 203,027 203,027 407,779 Starting Fund Balance 773,239 773,239 Net Change (248,021) 203,027 Ending Fund Balance 525,218 976,266 EXPENSE TOTALS 3,719,237 Fund 600 - FLEET SERVICES (248,021) EXPENSE TOTALS 3,719,237 Fund 600 - FLEET SERVICES REVENUE TOTALS 3,471,216 Debt Service - Miscellaneous - Interfund Transfers 27,833 Insurance and Other Chargebacks 239,630 Depreciation Expense - Contingencies 450 Capital Outlay - 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 Intergovernmental Revenue - Budget by Organization Report Through 01/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 600 - FLEET SERVICES FUND REVENUE Charges for Services 3,388,435 Interfund Transfers - Run by Ashley King on 03/02/2017 12:01:44 PM Page 31 of 45 January YTD 2016 2017 2017 Actual 129,171 129,171 1,455,172 - - - - - 45,869 129,171 129,171 1,501,041 - - 57,041 - - 1,437,968 - - - - - - - - 1,495,009 129,171 129,171 1,501,041 - - 1,495,009 129,171 129,171 6,032 Starting Fund Balance 1,283,721 1,283,721 Net Change 229,853 129,171 Ending Fund Balance 1,513,574 1,412,892 Fund 601 - EQUIPMENT 229,853 Fund 601 - EQUIPMENT REVENUE TOTALS 1,760,275 EXPENSE TOTALS 1,530,422 Depreciation Expense - Miscellaneous - EXPENSE TOTALS 1,530,422 Capital Outlay 1,455,422 REVENUE Charges for Services 1,550,058 Interfund Transfers - Other Revenue 210,217 REVENUE TOTALS 1,760,275 EXPENSE Services and Supplies 75,000 Fund 601 - EQUIPMENT REPLACEMENT FUND Budget by Organization Report Through 01/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Ashley King on 03/02/2017 12:01:44 PM Page 32 of 45 January YTD 2016 2017 2017 Actual 13,534 13,534 441,246 68 68 820 669,659 669,659 9,994,682 86,137 86,137 89,822 389,903 389,903 6,546,063 16 16 218 1,159,318 1,159,318 17,072,851 37,880 37,880 448,109 31,341 31,341 2,538,464 - - - 1,466,500 1,466,500 14,347,295 - - - - - - - - - - - - - - 4,330 803 803 9,262 1,536,524 1,536,524 17,347,460 1,159,318 1,159,318 17,072,851 1,536,524 1,536,524 17,347,460 (377,206) (377,206) (274,609) Starting Fund Balance (639,105) (639,105) Net Change (224,815) (377,206) Ending Fund Balance (863,920) (1,016,311) Fund 605 - INSURANCE FUND (224,815) Fund 605 - INSURANCE FUND REVENUE TOTALS 18,850,796 EXPENSE TOTALS 19,075,611 Miscellaneous - Interfund Transfers 9,632 EXPENSE TOTALS 19,075,611 Depreciation Expense - Contingencies - Debt Service - Capital Outlay - Insurance and Other Chargebacks 16,146,290 Community Sponsored Organizations - Services and Supplies 2,385,248 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 Other Revenue 11,237,646 Budget by Organization Report Through 01/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 605 - INSURANCE FUND REVENUE Charges for Services 162,411 Interfund Transfers 4,987 Run by Ashley King on 03/02/2017 12:01:44 PM Page 33 of 45 January YTD 2016 2017 2017 Actual - - - - - - - - - 72,722 72,722 10,902,978 - - 1,559,737 72,722 72,722 12,462,715 717,010 717,010 8,429,695 - - - - - - - - - - - 174,111 717,010 717,010 8,603,806 72,722 72,722 12,462,715 717,010 717,010 8,603,806 (644,288) (644,288) 3,858,910 Starting Fund Balance 70,630,343 70,630,343 Net Change 4,636,709 (644,288) Ending Fund Balance 75,267,052 69,986,055 Fund 700 - FIRE PENSION FUND 4,636,709 Fund 700 - FIRE PENSION FUND REVENUE TOTALS 13,341,709 EXPENSE TOTALS 8,705,000 Debt Service - Miscellaneous - EXPENSE TOTALS 8,705,000 Community Sponsored Organizations - 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 - Interfund Transfers 43,000 Budget by Organization Report Through 01/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 700 - FIRE PENSION FUND REVENUE Property Taxes 7,868,709 Other Taxes 280,000 Run by Ashley King on 03/02/2017 12:01:44 PM Page 34 of 45 January YTD 2016 2017 2017 Actual - - - - - - - - - 109,618 109,618 16,285,169 - - 2,713,348 109,618 109,618 18,998,517 930,592 930,592 11,094,711 - - - - - - - - 272,795 930,592 930,592 11,367,506 109,618 109,618 18,998,517 930,592 930,592 11,367,506 (820,974) (820,974) 7,631,010 Starting Fund Balance 106,204,773 106,204,773 Net Change 6,627,200 (820,974) Ending Fund Balance 112,831,973 105,383,799 REVENUE TOTALS 18,444,200 EXPENSE TOTALS 11,817,000 Fund 705 - POLICE PENSION 6,627,200 Fund 705 - POLICE PENSION EXPENSE Salary and Benefits 11,817,000 Services and Supplies - Debt Service - Miscellaneous - EXPENSE TOTALS 11,817,000 Other Revenue 1,650,000 Interest Income 6,500,000 REVENUE TOTALS 18,444,200 Interfund Transfers 57,000 Budget by Organization Report Through 01/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 705 - POLICE PENSION FUND REVENUE Property Taxes 9,912,200 Other Taxes 325,000 Run by Ashley King on 03/02/2017 12:01:44 PM Page 35 of 45