Loading...
HomeMy WebLinkAbout2016.02 February Monthly Report To: Wally Bobkiewicz, City Manager Martin Lyons, Assistant City Manager/Chief Financial Officer From: Ashley King, Finance Division Manager Subject: February 2016 Monthly Financial Report Date: April 6, 2016 Please find attached the unaudited financial statements as of February 29, 2015. A summary by fund for revenues, expenditures, fund and cash balances is as follows: YTD Revenues YTD Expenses YTD Net Fund Balance Cash Balance 13,929,044 12,934,146 994,898 14,097,256 2,587,845 43 117,295 (117,251)622,357 400,718 - 6,444 (6,444)41,851 28,962 - 41,667 (41,667)958,333 958,333 944,633 944,775 (142)2,102,749 1,072,809 33 7,394 (7,360)114,864 206,274 331,169 251,833 79,336 1,367,413 1,824,631 43,203 142,405 (99,202)503,475 282,474 59,107 - 59,107 203,365 (131,438) - 160,134 (160,134)316,006 (100,251) 23,953 - 23,953 2,475,622 182,319 494,928 231,046 263,882 2,945,159 2,363,088 - - - 114,864 169,915 4,442 11,130 (6,687)4,626,321 (1,917) 69,421 - 69,421 2,782,935 1,026,581 1,237,120 561,814 675,306 7,647,853 7,196,654 98,335 - 98,335 687,762 623,764 15,763 166,409 (150,646)1,155,111 1,191,540 21,280 14,280 7,001 183,023 (19,351) 1,232 5,323 (4,091)439,399 446,494 - - - - - 5,923 (5,923)306,147 306,147 1,866,861 13,487,913 (11,621,052)2,488,580 2,319,860 1,272,747 105,232 1,167,515 7,217,353 7,922,243 40,211 51,795 (11,584)2,670,822 2,667,660 1,202,850 582,606 620,244 11,132,302 10,849,774 3,966,647 2,883,823 1,082,824 8,702,803 8,225,910 2,284,032 924,170 1,359,861 5,779,898 3,227,593 774,625 435,226 339,399 (695,369) (1,181,856) 567,546 242,997 324,550 598,008 23,334 242,315 418 241,897 2,141,326 1,124,515 2,830,916 2,643,781 187,134 (3,767,484) 2,752,893 Grand Totals 32,322,456 36,959,979 (4,637,523) 79,960,101 58,547,517 Fund Description GENERAL FUND GENERAL ASSISTANCE FUND HEALTH AND HUMAN SERVICES GOOD NEIGHBOR FUND LIBRARY FUND NEIGHBORHOOD STABILIZATION MOTOR FUEL TAX FUND EMERGENCY TELEPHONE (E911) SPECIAL SERVICE AREA (SSA) #4 CDBG FUND CDBG LOAN ECONOMIC DEVELOPMENT FUND NEIGHBORHOOD IMPROVEMENT HOME FUND AFFORDABLE HOUSING FUND WASHINGTON NATIONAL TIF SPECIAL SERVICE AREA (SSA) #5 HOWARD-HARTREY TIF HOWARD-RIDGE TIF FUND WEST EVANSTON TIF FUND DEMPSTER-DODGE TIF FUND CHICAGO-MAIN TIF DEBT SERVICE FUND CAPITAL IMPROVEMENTS FUND SPECIAL ASSESSMENT FUND PARKING SYSTEM FUND WATER FUND SEWER FUND SOLID WASTE FUND INSURANCE FUND FLEET SERVICES FUND EQUIPMENT REPLACEMENT FUND NOTE: Negative Cash Balances (as seen above in the SSA 4 & CDBG Fund) reflect internal account balances and not external bank balances, due to transaction timing at month end. Memorandum 1 Included above are the ending balances as of February 29, 2016 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 may 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 February 29, 2016, the General Fund is reporting a net surplus of $994,898. There were lower than anticipated February expenses due to delays in issuing purchase orders. This was caused by the reorganization of multiple City departments and the creation of the Public Works Agency which changed the General Ledger string for many funds. Expenses will be caught up by the March financial report. First installment property taxes will also be shown on the March 2016 financial reports. The attached supplemental charts show the General Fund Revenues at 12.4% of budget and expenses slightly lower at 11.6%. The two month goal is 16.6%. Through February 29, 2016, the CDBG Fund is showing a negative cash balance of $100,251 which will be reimbursed from March draw-downs. Through February 29, 2016, the SSA #4 Fund and Howard Ridge TIF funds show negative cash balances due to the timing of property taxes. This will be eliminated in the March report as monies have been received in March 2016. Through February 29, 2016, the Economic Development Fund is showing a fund balance of $2,945,159 and a cash balance of $2,363,088. The Parking Fund made the $3.2 million Sherman Garage deck payment in December, reducing their fund balance to $11,132,302. The Debt Service Fund made a $13 million payment in January in connection with the refinancing of the 2006B bonds. Through February 29, 2016, the Solid Waste Fund is showing a fund balance of $339,399 and a cash balance of negative $1,181,856. The January and February payments to SWANCC were approved by Council in March. Though operating at a $324,550 surplus for the year, the Fleet Fund is showing a negative $23,334 cash balance through February 29, 2016. Through February 29, 2016, the Insurance Fund is showing a negative fund balance of $3,767,484 with a cash balance of $2,752,893. This negative balance is primarily for claims/cases being expensed. These claims/cases have not been settled, and therefore there is no guarantee the City will actually experience this negative fund balance as estimated. 2 3 Annual MTD YTD Prior Year Budget Amount Actual Amount Actual Amount %Total Actual 27,417,407 2,235,796 2,256,262 8 11,397,061 45,986,550 3,445,161 6,942,230 15 43,866,276 5,329,777 672,504 994,203 19 5,324,137 9,276,550 377,984 630,145 7 6,704,846 125,700 5,121 24,819 20 155,619 4,609,825 218,509 464,162 10 3,548,230 640,000 - - 0 640,000 5,374,751 372,061 683,815 13 5,406,379 2,433,216 225,070 535,126 22 2,239,528 8,842,365 646,242 1,229,984 15 7,836,484 765,727 49,462 69,449 9 670,245 1,286,843 58,816 97,698 8 693,088 50,000 465 1,151 2 6,572 112,138,711 8,307,190 13,929,044 12.4% 88,488,464 424,958 42,117 76,540 18.0% 417,571 263,203 27,015 45,685 17.4% 281,913 6,989,746 316,320 561,363 8.0% 1,804,588 1,130,000 84,956 149,478 13.2% 1,044,228 9,634,173 664,228 1,110,212 11.5% 9,538,936 2,740,032 219,891 387,812 14.2% 2,407,297 37,696,278 2,542,339 4,507,321 12.0% 28,321,088 22,601,742 1,380,017 2,605,614 11.5% 14,837,447 3,544,226 173,933 309,468 8.7% 3,198,674 11,820,590 736,053 1,314,519 11.1% 11,143,556 14,861,248 1,040,007 1,866,134 12.6% - EXPENSES 111,706,196 7,226,877 12,934,146 11.6% 72,995,299 112,138,711 8,307,190 13,929,044 88,488,464 111,706,196 7,226,877 12,934,146 72,995,299 432,515 1,080,313 994,898 15,493,166 General Fund Through 02/29/16 Summary Listing Classification Fund   100 - GENERAL FUND Fines and Forfeitures Parking Charges for Services Parks and Recreation Charges for Other Charges for Services Property Taxes Other Taxes License Permit Fee   14 - CITY CLERK   13 - CITY COUNCIL Interfund Transfers Intergovernmental Revenue Other Revenue Interest Income REVENUE TOTALS EXPENSE TOTALS Fund   100 - GENERAL   23 - FIRE MGMT & SUPPORT   22 - POLICE   40 - PUBLIC WORKS AGENCY   30 - PARKS, REC. AND   24 - HEALTH REVENUE Fund   100 - GENERAL   21 - COMMUNITY   19 - ADMINISTRATIVE   17 - LAW   15 - CITY MANAGER'S 4 Annual MTD YTD % of Prior Year Budget Amount Actual Amount Actual Amount Budget Total Actual - 300 1,200 +++ 150 6,379,675 495,547 868,519 13.61% 6,081,495 65,000 - - 0.00% - 3,711,770 309,314 309,314 8.33% 2,925,296 12,125 - - 0.00% - 119,216 7,083 20,874 17.51% 153,545 35,070 1,477 2,943 0.00% 18,260 10,322,856 813,721 1,202,850 11.65% 9,178,746 23,000 1,278 4,801 20.87% 29,187 1,348,940 114,998 198,386 14.71% 1,136,557 113,349 7,627 14,857 13.11% 99,018 3,022,411 72,322 106,428 3.52% 2,698,537 278,864 240 838 0.30% 243,068 3,474,000 - - 0.00% 2,107,697 319,648 26,637 68,964 21.58% 319,649 2,873,395 - - 0.00% - 11,000 202 202 1.83% 6,951 3,917,652 - - 0.00% 3,917,650 252,000 - - 0.00% - 1,303,783 108,649 188,131 14.43% 923,092 16,938,042 331,953 582,606 3.44% 11,481,405 10,322,856 813,721 1,202,850 9,178,746 16,938,042 331,953 582,606 11,481,405 (6,615,186) 481,768 620,244 (2,302,659) EXPENSE TOTALS Fund   505 - PARKING SYSTEM REVENUE EXPENSES Debt Service Miscellaneous Interfund Transfers Fund   505 - PARKING SYSTEM REVENUE TOTALS Supplies Capital Outlay Insurance and Other Chargebacks Depreciation Expense Contingencies Employee Pay Benefits Pensions Services Interfund Transfers Intergovernmental Revenue Other Revenue Interest Income Permit Parking Charges for Services Parks and Recreation Charges for Parking Fund Through 02/29/16 Summary Listing Classification Fund Category   Proprietary Funds Fund Type   Enterprise Funds Fund   505 - PARKING SYSTEM FUND 5 Annual MTD YTD % of Prior Year Budget Amount Actual Amount Actual Amount Budget Total Actual 12,869,000 1,198,069 2,283,140 17.74% 13,003,876 19,650 - - 0.00% 19,650 984,165 - - 0.00% - 1,000 356 892 89.16% 2,706 13,873,815 1,198,425 2,284,032 13,026,232 57,040 6,047 8,457 14.83% 60,837 1,025,778 92,068 163,181 15.91% 1,005,582 86,092 7,025 13,401 15.57% 91,066 903,500 - 105 0.01% 898,075 92,300 286 2,590 2.81% 18,817 3,048,314 - - 0.00% 500,881 269,988 43,457 98,741 36.57% 269,988 9,222,913 205,395 550,633 5.97% 1,911,503 1,500 - - 0.00% 3,306 773,876 43,532 87,063 11.25% 735,235 15,481,301 397,810 924,170 5,495,290 13,873,815 1,198,425 2,284,032 13,026,232 15,481,301 397,810 924,170 5,495,290 (1,607,486) 800,615 1,359,861 7,530,942 Fund   515 - SEWER FUND Net Gain (Loss) REVENUE EXPENSES 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 Sewer Fund Through 02/29/16 Summary Listing Classification Fund Category   Proprietary Funds Fund Type   Enterprise Funds Fund   515 - SEWER FUND 6 Annual MTD YTD % of Prior Year Budget Amount Actual Amount Actual Amount Budget Total Actual 275,000 - - - 357,583 - 87,997 175,995 - - 3,632,394 306,202 595,739 16 3,557,884 1,055,967 - - - 1,055,967 238,000 1,908 2,892 1 228,394 5,201,361 396,107 774,625 5,199,828 25,000 9,177 13,301 53 41,358 779,380 70,555 106,369 14 702,238 63,718 5,546 8,586 13 60,582 3,679,126 209,083 209,472 6 3,644,097 53,050 520 3,442 6 73,788 25,750 - - - 24,738 - - 10,808 - - - - - - 85,326 15,000 - - - - 499,493 41,624 83,249 17 490,106 5,140,517 336,505 435,226 5,122,233 5,201,361 396,107 774,625 0 5,199,828 5,140,517 336,505 435,226 0 5,122,233 60,844 59,602 339,399 6 77,595 REVENUE EXPENSES Fund   520 - SOLID WASTE FUND Totals REVENUE TOTALS EXPENSE TOTALS Fund   520 - SOLID WASTE FUND Net Capital Outlay Insurance and Other Chargebacks Debt Service Miscellaneous Interfund Transfers Pensions Services Supplies Interfund Transfers Other Revenue Employee Pay Benefits License Solid Waste Charges for Services Other Charges for Services Solid Waste Fund Through 02/29/16 Summary Listing Classification Fund Category   Proprietary Funds Fund Type   Enterprise Funds Fund   520 - SOLID WASTE FUND 7 Annual MTD YTD % of Prior Year Budget Amount Actual Amount Actual Amount Budget Total Actual 70,000 6,113 11,997 17.1% 105,483 15,133,000 2,126,983 2,941,836 19.4% 15,310,824 39,000 5,723 5,723 14.7% 45,102 126,000 - - 0.0% 125,545 22,348,400 4,155 5,378 0.0% 6,109,981 - - 1,000,000 8,550,000 1,600 710 1,713 107.1% 5,981 2,665,000 16,822 16,822 0.6% 395,395 24,700,306 195,063 196,535 0.8% 8,293,392 65,083,306 2,355,569 4,180,004 38,941,704 210,465 8,385 23,032 10.9% 157,679 4,534,306 395,715 695,293 15.3% 4,510,838 360,355 28,122 53,974 15.0% 386,339 2,098,760 88,065 102,949 4.9% 1,228,170 1,392,190 54,929 77,983 5.6% 961,136 75,800 - 595 0.8% 583,227 468,492 39,042 132,921 28.4% 468,493 1,000 - - 0.0% 854 1,053,288 - - 0.0% 981,389 62,980 - - 0.0% 875 3,502,313 291,859 1,583,719 45.2% 11,875,155 13,759,949 906,117 2,670,466 21,154,154 65,083,306 2,355,569 4,180,004 38,941,704 13,759,949 906,117 2,670,466 21,154,154 51,323,357 1,449,452 1,509,537 17,787,550 EXPENSE TOTALS Fund   510 - WATER FUND Net Gain Interest Income REVENUES EXPENSES Debt Service Miscellaneous Interfund Transfers Fund   510 - WATER FUND Totals REVENUE TOTALS Services Supplies Capital Outlay Insurance and Other Chargebacks Contingencies Salary and Benefits Employee Pay Benefits Pensions Interfund Transfers Services Capital Outlay Other Charges for Services Other Revenue Licenses, Permits and Fees Fee Water Charges for Services Sewer Charges for Services Water Fund Through 02/29/16 Summary Listing Classification Fund Category   Proprietary Funds Fund Type   Enterprise Funds Fund   510 - WATER FUND 8 Feb-16 YTD 2015 Actual Transaction s Transactions 2,235,796 2,256,262 11,397,061 3,445,161 6,942,230 43,866,276 1,055,609 1,649,167 12,184,602 218,509 464,162 3,548,230 597,131 1,218,941 8,285,907 646,242 1,229,984 7,836,484 49,462 69,449 670,245 58,816 97,698 693,088 465 1,151 6,572 8,307,190 13,929,044 88,488,464 6,191,466 10,942,128 68,445,218 364,663 553,902 11,417,224 13,189 14,680 142,786 253,098 506,196 3,020,991 12,673 12,673 952,678 89 89 30,529 102,629 197,761 1,740,204 377,437 706,717 5,301,854 7,315,245 12,934,146 91,051,485 8,307,190 13,929,044 88,488,464 7,315,245 12,934,146 91,051,485 991,945 994,898 (2,563,021) Starting Fund Balance 13,102,358 13,102,358 Net Change (567,485)994,898 Ending Fund Balance 12,534,873 14,097,256 Budget by Organization Report Through 02/29/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 100 - GENERAL FUND REVENUE Property Taxes 27,417,407 Other Taxes 45,986,550 Licenses, Permits and Fees 14,732,027 Fines and Forfeitures 4,609,825 Charges for Services 8,447,967 Interfund Transfers 8,842,365 Intergovernmental Revenue 765,727 Other Revenue 1,286,843 Workers Compensation and Liability Insurance Library Revenue Interest Income 50,000 Special Assessment Reappropriation of Surplus REVENUE TOTALS 112,138,711 EXPENSE Salary and Benefits 71,111,353 Services and Supplies 11,776,309 Capital Outlay 200,600 Insurance and Other Chargebacks 20,282,973 Community Sponsored Organizations 925,029 Depreciation Expense Contingencies 213,505 Debt Service Miscellaneous 1,661,899 Interfund Transfers 6,534,528 EXPENSE TOTALS 112,706,196 Fund 100 - GENERAL FUND Totals REVENUE TOTALS 112,138,711 EXPENSE TOTALS 112,706,196 Fund 100 - GENERAL FUND Totals (567,485) Run by Ashley King on 04/06/2016 01:16:07 PM Page 1 of 50 9 Feb-16 YTD 2015 Actual Transaction s Transaction s 1,313,420 3,208 19,534 36 43 62 36 43 1,336,224 19,066 33,875 183,547 40,660 81,590 591,542 1,770 59 4,625 59,726 117,295 779,714 36 43 1,336,224 59,726 117,295 779,714 (59,690)(117,251)556,510 Starting Fund Balance 739,609 739,609 Net Change 38,167 (117,251) Ending Fund Balance 777,776 622,357 Budget by Organization Report Through 02/29/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 175 - GENERAL ASSISTANCE FUND REVENUE Property Taxes 1,000,000 Other Taxes Licenses, Permits and Fees Fines and Forfeitures Charges for Services Interfund Transfers Intergovernmental Revenue Other Revenue 25,000 Workers Compensation and Liability Insurance Library Revenue Interest Income 1,000 Special Assessment Reappropriation of Surplus REVENUE TOTALS 1,026,000 EXPENSE Salary and Benefits 221,933 Services and Supplies 758,900 Capital Outlay Insurance and Other Chargebacks Community Sponsored Organizations Depreciation Expense Contingencies Debt Service Miscellaneous 7,000 Interfund Transfers EXPENSE TOTALS 987,833 Fund 175 - GENERAL ASSISTANCE REVENUE TOTALS 1,026,000 EXPENSE TOTALS 987,833 Fund 175 - GENERAL ASSISTANCE 38,167 Run by Ashley King on 04/06/2016 01:16:07 PM Page 3 of 50 10 Feb-16 YTD 2015 Actual Transaction s Transaction s - - - - - 884,794 - - - - - - - - 884,794 - - - - - - - 6,444 849,388 - - - - 6,444 849,388 - - 884,794 - 6,444 849,388 - (6,444) 35,406 Starting Fund Balance 48,295 48,295 Net Change 25,641 (6,444) Ending Fund Balance 73,936 41,851 Budget by Organization Report Through 02/29/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 176 - HEALTH AND HUMAN SERVICES REVENUE Charges for Services - Interfund Transfers 884,794 Intergovernmental Revenue - Other Revenue - REVENUE TOTALS 884,794 EXPENSE Services and Supplies - 884,794 Capital Outlay - Community Sponsored Organizations 859,153 Miscellaneous - EXPENSE TOTALS 859,153 Fund 176 - HEALTH AND HUMAN 25,641 EXPENSE TOTALS 859,153 Fund 176 - HEALTH AND HUMAN REVENUE TOTALS Run by Ashley King on 04/06/2016 01:16:07 PM Page 4 of 50 11 Feb-16 YTD 2015 Actual Transaction s Transaction s - - - - - - 41,667 41,667 - 41,667 41,667 - - - - 41,667 41,667 - (41,667) (41,667) - Starting Fund Balance 1,000,000 1,000,000 Net Change - (41,667) Ending Fund Balance 1,000,000 958,333 Budget by Organization Report Through 02/29/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 180 - GOOD NEIGHBOR FUND 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 REVENUE TOTALS 1,000,000 EXPENSE TOTALS 1,000,000 Fund 180 - GOOD NEIGHBOR FUND - Run by Ashley King on 04/06/2016 01:16:07 PM Page 5 of 50 12 Feb-16 YTD 2015 Actual Transaction s Transaction s 928,087 944,507 5,916,852 - - 50,200 (125) (125) 189,929 - - 171,000 - - 238,203 - - 286 - (81) 315,890 115 333 2,683 928,076 944,633 6,885,044 382,267 699,833 4,354,576 128,800 154,271 1,437,572 - 90 37,508 6,674 47,719 77,268 - - - - - - - - - 20,833 20,833 250,000 849 22,028 4,200 539,423 944,775 6,161,123 928,076 944,633 6,885,044 539,423 944,775 6,161,123 388,653 (142) 723,921 Starting Fund Balance 2,102,891 2,102,891 Net Change 20,015 (142) Ending Fund Balance 2,122,906 2,102,749 Budget by Organization Report Through 02/29/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 185 - LIBRARY FUND REVENUE Property Taxes 6,104,180 Other Taxes 50,200 Fines and Forfeitures - Interfund Transfers 185,800 Intergovernmental Revenue 94,177 Other Revenue 247,500 Library Revenue 333,300 Interest Income 2,000 REVENUE TOTALS 7,017,157 EXPENSE Salary and Benefits 4,751,497 Services and Supplies 1,872,573 Capital Outlay 32,800 Insurance and Other Chargebacks 80,089 Depreciation Expense - Contingencies - 7,017,157 Debt Service - Miscellaneous 250,000 Interfund Transfers 10,183 EXPENSE TOTALS 6,997,142 Fund 185 - LIBRARY FUND Totals 20,015 EXPENSE TOTALS 6,997,142 Fund 185 - LIBRARY FUND Totals REVENUE TOTALS Run by Ashley King on 04/06/2016 01:16:07 PM Page 6 of 50 13 Feb-16 YTD 2015 Actual Transaction s Transaction s 14,483 14,483 601,811 - - - 14,483 14,483 601,811 - - 14,550 - - 277,553 - - 562,740 - - - - - 854,842 14,483 14,483 601,811 - - 854,842 14,483 14,483 (253,031) Starting Fund Balance 132,667 132,667 Net Change 14,483 Ending Fund Balance 132,667 147,150 Budget by Organization Report Through 02/29/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 186 - LIBRARY DEBT SERVICE FUND REVENUE Property Taxes 393,409 Interest Income - REVENUE TOTALS 393,409 EXPENSE Services and Supplies - Capital Outlay - Debt Service 393,409 Miscellaneous - EXPENSE TOTALS 393,409 Fund 186 - LIBRARY DEBT SERVICE REVENUE TOTALS 393,409 EXPENSE TOTALS 393,409 Fund 186 - LIBRARY DEBT SERVICE - Run by Ashley King on 04/06/2016 01:16:07 PM Page 7 of 50 14 Feb-16 YTD 2015 Actual Transaction s Transaction s - - - - - 131,113 - - - 14 33 213 14 33 131,327 2,420 4,548 59,467 - - 4,611 - - 69,203 362 1,146 5,730 - - - 1,700 1,700 180 - - (8,213) 4,482 7,394 130,978 14 33 131,327 4,482 7,394 130,978 (4,468) (7,360) 348 Starting Fund Balance 122,224 122,224 Net Change (303) (7,360) Ending Fund Balance 121,921 114,864 Budget by Organization Report Through 02/29/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 195 - NEIGHBORHOOD STABILIZATION FUND REVENUE Licenses, Permits and Fees - Intergovernmental Revenue 198,651 Other Revenue - Interest Income - REVENUE TOTALS 198,651 EXPENSE Salary and Benefits 33,648 Services and Supplies 5,100 Capital Outlay 35,000 Insurance and Other Chargebacks 4,344 198,651 Debt Service - Miscellaneous 120,862 Interfund Transfers - EXPENSE TOTALS 198,954 Fund 195 - NEIGHBORHOOD (303) EXPENSE TOTALS 198,954 Fund 195 - NEIGHBORHOOD REVENUE TOTALS Run by Ashley King on 04/06/2016 01:16:07 PM Page 8 of 50 15 Feb-16 YTD 2015 Actual Transaction s Transaction s 162,370 330,477 2,485,781 - - - 378 692 819 - - - 162,747 331,169 2,486,600 - - - - - 1,500,228 - - - - - - - - - 182,417 251,833 833,000 182,417 251,833 2,333,228 162,747 331,169 2,486,600 182,417 251,833 2,333,228 (19,669) 79,336 153,372 Starting Fund Balance 1,288,077 1,288,077 Net Change (478,000)79,336 Ending Fund Balance 810,077 1,367,413 Budget by Organization Report Through 02/29/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 200 - MOTOR FUEL TAX FUND REVENUE Intergovernmental Revenue 1,710,000 Other Revenue - Interest Income 1,000 Reappropriation of Surplus - REVENUE TOTALS 1,711,000 EXPENSE Services and Supplies - Capital Outlay - Contingencies - Debt Service - Miscellaneous - Interfund Transfers 2,189,000 EXPENSE TOTALS 2,189,000 Fund 200 - MOTOR FUEL TAX FUND (478,000) Fund 200 - MOTOR FUEL TAX FUND REVENUE TOTALS 1,711,000 EXPENSE TOTALS 2,189,000 Run by Ashley King on 04/06/2016 01:16:07 PM Page 9 of 50 16 Feb-16 YTD 2015 Actual Transaction s Transaction s 650 42,998 1,168,737 - - - - - 100 109 205 189 759 43,203 1,169,026 50,725 91,582 579,447 8,296 29,606 347,694 - - 239,421 2,494 10,406 29,486 - - - - - 2,046 - - - - - 1,500 10,811 10,811 129,729 72,326 142,405 1,329,323 759 43,203 1,169,026 72,326 142,405 1,329,323 (71,567) (99,202) (160,297) Starting Fund Balance 602,677 602,677 Net Change (497,643)(99,202) Ending Fund Balance 105,034 503,475 Budget by Organization Report Through 02/29/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 205 - EMERGENCY TELEPHONE (E911) FUND REVENUE Other Taxes 1,018,000 Intergovernmental Revenue - Other Revenue - Interest Income 1,000 REVENUE TOTALS 1,019,000 EXPENSE Salary and Benefits 580,773 Services and Supplies 377,600 Capital Outlay 393,615 Insurance and Other Chargebacks 29,926 Community Sponsored Organizations - Contingencies 5,000 Debt Service - Miscellaneous - Interfund Transfers 129,729 EXPENSE TOTALS 1,516,643 Fund 205 - EMERGENCY TELEPHONE (497,643) Fund 205 - EMERGENCY TELEPHONE REVENUE TOTALS 1,019,000 EXPENSE TOTALS 1,516,643 Run by Ashley King on 04/06/2016 01:16:07 PM Page 10 of 50 17 Feb-16 YTD 2015 Actual Transaction s Transaction s 59,107 59,107 322,055 0 0 3 59,107 59,107 322,058 - - 323,000 - - - - - - - - 323,000 59,107 59,107 322,058 - - 323,000 59,107 59,107 (942) Starting Fund Balance 144,258 144,258 Net Change - 59,107 Ending Fund Balance 144,258 203,365 Budget by Organization Report Through 02/29/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 210 - SPECIAL SERVICE AREA (SSA) #4 REVENUE Property Taxes 320,000 Interest Income - REVENUE TOTALS 320,000 320,000 EXPENSE Services and Supplies 320,000 Debt Service - Miscellaneous - EXPENSE TOTALS 320,000 Fund 210 - SPECIAL SERVICE AREA - EXPENSE TOTALS 320,000 Fund 210 - SPECIAL SERVICE AREA REVENUE TOTALS Run by Ashley King on 04/06/2016 01:16:07 PM Page 11 of 50 18 Feb-16 YTD 2015 Actual Transaction s Transaction s - - - - - - - - 1,750,089 - - 3,318 - - - - - 1,753,407 42,397 75,863 362,786 26 31 28,988 4,324 4,324 276,834 2,273 9,920 20,767 - - 235,459 - - - - - - 3,560 60 72,142 69,760 69,937 449,083 122,341 160,134 1,446,060 - - 1,753,407 122,341 160,134 1,446,060 (122,341) (160,134) 307,347 Starting Fund Balance 476,140 476,140 Net Change 375 (160,134) Ending Fund Balance 476,515 316,006 Budget by Organization Report Through 02/29/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 215 - CDBG FUND REVENUE Charges for Services - Interfund Transfers - Intergovernmental Revenue 2,595,000 Other Revenue - Interest Income - REVENUE TOTALS 2,595,000 EXPENSE Salary and Benefits 452,432 Services and Supplies 3,800 Capital Outlay - Insurance and Other Chargebacks 26,989 Community Sponsored Organizations - Contingencies - 2,595,000 Debt Service - Miscellaneous 1,274,280 Interfund Transfers 837,124 EXPENSE TOTALS 2,594,625 Fund 215 - CDBG FUND Totals 375 EXPENSE TOTALS 2,594,625 Fund 215 - CDBG FUND Totals REVENUE TOTALS Run by Ashley King on 04/06/2016 01:16:07 PM Page 12 of 50 19 Feb-16 YTD 2015 Actual Transaction s Transaction s - - - 20,710 23,883 237,317 23 70 375 20,733 23,953 237,692 - - - - - 198,070 - - 1,919 - - - - - 199,989 20,733 23,953 237,692 - - 199,989 20,733 23,953 37,703 Starting Fund Balance 2,451,669 2,451,669 Net Change 23,953 Ending Fund Balance 2,451,669 2,475,622 Budget by Organization Report Through 02/29/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 220 - CDBG LOAN REVENUE Intergovernmental Revenue - Other Revenue 350,000 Interest Income - REVENUE TOTALS 350,000 EXPENSE Salary and Benefits - Services and Supplies 340,000 Miscellaneous 10,000 Interfund Transfers - EXPENSE TOTALS 350,000 Fund 220 - CDBG LOAN Totals - Fund 220 - CDBG LOAN Totals REVENUE TOTALS 350,000 EXPENSE TOTALS 350,000 Run by Ashley King on 04/06/2016 01:16:07 PM Page 13 of 50 20 Feb-16 YTD 2015 Actual Transaction s Transaction s 26,572 487,861 2,104,007 - - - - - - 6,042 6,942 49,000 66 125 128 32,681 494,928 2,153,135 54,583 96,298 596,265 - 800 295,851 946 704 194,941 2,440 12,411 32,230 - - - - - - - - - - - 1,293,041 70,833 120,833 600,000 128,802 231,046 3,012,329 32,681 494,928 2,153,135 128,802 231,046 3,012,329 (96,121) 263,882 (859,193) Starting Fund Balance 2,681,277 2,681,277 Net Change (286,099)263,882 Ending Fund Balance 2,395,178 2,945,159 Budget by Organization Report Through 02/29/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 225 - ECONOMIC DEVELOPMENT FUND REVENUE Other Taxes 2,165,000 Interfund Transfers 47,500 Intergovernmental Revenue - Other Revenue 50,000 Interest Income 100 REVENUE TOTALS 2,262,600 EXPENSE Salary and Benefits 734,229 Services and Supplies 912,200 Capital Outlay 253,500 Insurance and Other Chargebacks 32,770 Community Sponsored Organizations - Contingencies - 2,262,600 Debt Service - Miscellaneous 16,000 Interfund Transfers 600,000 EXPENSE TOTALS 2,548,699 Fund 225 - ECONOMIC DEVELOPMENT (286,099) EXPENSE TOTALS 2,548,699 Fund 225 - ECONOMIC DEVELOPMENT REVENUE TOTALS Run by Ashley King on 04/06/2016 01:16:07 PM Page 14 of 50 21 Feb-16 YTD 2015 Actual Transaction s Transaction s - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Starting Fund Balance 169,915 169,915 Net Change (80,000) Ending Fund Balance 89,915 169,915 Budget by Organization Report Through 02/29/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 235 - NEIGHBORHOOD IMPROVEMENT REVENUE Other Taxes 20,000 Interfund Transfers - Interest Income - REVENUE TOTALS 20,000 EXPENSE Services and Supplies - Capital Outlay - 20,000 Debt Service - Miscellaneous 100,000 Interfund Transfers - EXPENSE TOTALS 100,000 Fund 235 - NEIGHBORHOOD (80,000) EXPENSE TOTALS 100,000 Fund 235 - NEIGHBORHOOD REVENUE TOTALS Run by Ashley King on 04/06/2016 01:16:07 PM Page 15 of 50 22 Feb-16 YTD 2015 Actual Transaction s Transaction s - - 518,870 2,157 4,439 33,633 0 3 19 2,157 4,442 552,523 - - 12,388 11,061 11,061 458,168 - - - 68 68 1,368 - - - - - - - - 680 - - 26,990 11,130 11,130 499,594 2,157 4,442 552,523 11,130 11,130 499,594 (8,972) (6,687) 52,929 Starting Fund Balance 4,633,008 4,633,008 Net Change (6,687) Ending Fund Balance 4,633,008 4,626,321 Budget by Organization Report Through 02/29/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 240 - HOME FUND REVENUE Intergovernmental Revenue 393,868 Other Revenue 8,300 Interest Income - REVENUE TOTALS 402,168 EXPENSE Salary and Benefits 48,348 Services and Supplies 352,500 Capital Outlay - Insurance and Other Chargebacks 820 Community Sponsored Organizations - 402,168 Debt Service - Miscellaneous 500 Interfund Transfers - EXPENSE TOTALS 402,168 Fund 240 - HOME FUND Totals - EXPENSE TOTALS 402,168 Fund 240 - HOME FUND Totals REVENUE TOTALS Run by Ashley King on 04/06/2016 01:16:07 PM Page 16 of 50 23 Feb-16 YTD 2015 Actual Transaction s Transaction s 16,667 36,667 100,000 - - - - - - 31,667 32,639 142,315 62 115 111 48,395 69,421 242,426 - - - - - 98 - - - - - - - - - - - 116,148 - - - - - 116,246 48,395 69,421 242,426 - - 116,246 48,395 69,421 126,180 Starting Fund Balance 2,713,514 2,713,514 Net Change (313,719)69,421 Ending Fund Balance 2,399,795 2,782,935 Budget by Organization Report Through 02/29/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 250 - AFFORDABLE HOUSING FUND REVENUE Other Taxes 30,000 Interfund Transfers - Intergovernmental Revenue - Other Revenue 130,400 Interest Income 228 REVENUE TOTALS 160,628 EXPENSE Salary and Benefits 48,347 Services and Supplies 350,000 Capital Outlay - Community Sponsored Organizations - Debt Service - Miscellaneous 76,000 Interfund Transfers - EXPENSE TOTALS 474,347 Fund 250 - AFFORDABLE HOUSING FUND TotalsREVENUE TOTALS 160,628 EXPENSE TOTALS 474,347 Fund 250 - AFFORDABLE HOUSING FUND Totals (313,719) Run by Ashley King on 04/06/2016 01:16:07 PM Page 17 of 50 24 Feb-16 YTD 2015 Actual Transaction s Transaction s 1,235,773 1,235,773 4,921,484 - - - - - - - - - 621 1,347 3,530 1,236,394 1,237,120 4,925,014 - - - - - 1,408 - - 198,823 - - 574,976 - - 98,670 532,647 561,814 3,265,296 532,647 561,814 4,139,172 1,236,394 1,237,120 4,925,014 532,647 561,814 4,139,172 703,746 675,306 785,843 Starting Fund Balance 6,972,547 6,972,547 Net Change (2,640,683)675,306 Ending Fund Balance 4,331,864 7,647,853 Budget by Organization Report Through 02/29/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 300 - WASHINGTON NATIONAL TIF FUND REVENUE Property Taxes 5,145,000 Other Taxes - Interfund Transfers - Other Revenue - Interest Income 2,000 REVENUE TOTALS 5,147,000 EXPENSE Salary and Benefits - Services and Supplies 1,000,000 Capital Outlay - 5,147,000 Debt Service - Miscellaneous 500,000 Interfund Transfers 6,287,683 EXPENSE TOTALS 7,787,683 Fund 300 - WASHINGTON NATIONAL (2,640,683) EXPENSE TOTALS 7,787,683 Fund 300 - WASHINGTON NATIONAL REVENUE TOTALS Run by Ashley King on 04/06/2016 01:16:07 PM Page 18 of 50 25 Feb-16 YTD 2015 Actual Transaction s Transaction s 98,335 98,335 422,527 - - - - - - 0 0 4 98,335 98,335 422,531 - - - - - 297,150 - - - - - 297,150 98,335 98,335 422,531 - - 297,150 98,335 98,335 125,381 Starting Fund Balance 589,427 589,427 Net Change (467,971)98,335 Ending Fund Balance 121,456 687,762 Budget by Organization Report Through 02/29/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 305 - SPECIAL SERVICE AREA (SSA) #5 REVENUE Property Taxes - Interfund Transfers - Other Revenue - Interest Income 300 REVENUE TOTALS 300 EXPENSE Services and Supplies 51,399 Debt Service 416,872 Miscellaneous - EXPENSE TOTALS 468,271 Fund 305 - SPECIAL SERVICE AREA (467,971) Fund 305 - SPECIAL SERVICE AREA REVENUE TOTALS 300 EXPENSE TOTALS 468,271 Run by Ashley King on 04/06/2016 01:16:07 PM Page 19 of 50 26 Feb-16 YTD 2015 Actual Transaction s Transaction s 15,404 15,404 1,248,231 154 359 1,985 15,558 15,763 1,250,216 - - 1,158 7,668 7,668 11,402 - - - - - - - - 2,153,374 146,038 158,742 148,010 153,705 166,409 2,313,943 15,558 15,763 1,250,216 153,705 166,409 2,313,943 (138,147) (150,646) (1,063,726) Starting Fund Balance 1,305,757 1,305,757 Net Change (650,450)(150,646) Ending Fund Balance 655,307 1,155,111 Budget by Organization Report Through 02/29/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 310 - HOWARD-HARTREY TIF REVENUE Property Taxes 1,300,000 Interest Income 2,000 REVENUE TOTALS 1,302,000 EXPENSE Services and Supplies - Capital Outlay - Community Sponsored Organizations - 1,302,000 Debt Service - Miscellaneous 200,000 Interfund Transfers 1,752,450 EXPENSE TOTALS 1,952,450 Fund 310 - HOWARD-HARTREY TIF ($650,450.00) EXPENSE TOTALS 1,952,450 Fund 310 - HOWARD-HARTREY TIF REVENUE TOTALS Run by Ashley King on 04/06/2016 01:16:07 PM Page 20 of 50 27 Feb-16 YTD 2015 Actual Transaction s Transaction s - - - - - - - - - - - - - - - - - - - - 893,387 - - - - - 893,387 - - - - - 893,387 - - (893,387) Starting Fund Balance Net Change Ending Fund Balance Budget by Organization Report Through 02/29/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 315 - SOUTHWEST TIF FUND REVENUE Property Taxes - Interest Income - REVENUE TOTALS - EXPENSE Services and Supplies - Capital Outlay - Debt Service - Miscellaneous - Interfund Transfers - EXPENSE TOTALS - Fund 315 - SOUTHWEST TIF FUND Totals - Fund 315 - SOUTHWEST TIF FUND TotalsREVENUE TOTALS - EXPENSE TOTALS - Run by Ashley King on 04/06/2016 01:16:07 PM Page 21 of 50 28 Feb-16 YTD 2015 Actual Transaction s Transactions 1,605,011 1,635,811 11,156,231 115,508 115,508 1,642,654 - 115,133 12,278,473 188 411 7,668 1,720,707 1,866,861 25,085,026 250 250 171,576 - 13,487,663 13,028,022 - - 880 - - - 250 13,487,913 13,200,479 1,720,707 1,866,861 25,085,026 250 13,487,913 13,200,479 1,720,457 (11,621,052) 11,884,547 Starting Fund Balance 15,697,422 15,697,422 Net Change (2,751,668)(11,621,052) Ending Fund Balance 12,945,754 4,076,370 Budget by Organization Report Through 02/29/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 320 - DEBT SERVICE FUND REVENUE Property Taxes 10,879,993 Interfund Transfers 2,646,291 Other Revenue - Interest Income 1,500 REVENUE TOTALS 13,527,784 EXPENSE Services and Supplies 315,770 13,527,784 Debt Service 15,963,682 Miscellaneous - Interfund Transfers - EXPENSE TOTALS 16,279,452 Fund 320 - DEBT SERVICE FUND Totals (2,751,668) EXPENSE TOTALS 16,279,452 Fund 320 - DEBT SERVICE FUND Totals REVENUE TOTALS Run by Ashley King on 04/06/2016 01:16:07 PM Page 22 of 50 29 Feb-16 YTD 2015 Actual Transaction s Transaction s - 6,204 540,576 9,822 15,019 64,176 28 58 1,815 9,850 21,280 606,568 4,102 4,170 587,839 - - (6,275) - - - 59 110 585 - - 15 5,000 10,000 107,500 9,161 14,280 689,664 9,850 21,280 606,568 9,161 14,280 689,664 689 7,001 (83,097) Starting Fund Balance 176,022 176,022 Net Change 24,000 7,001 Ending Fund Balance 200,022 183,023 Budget by Organization Report Through 02/29/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 330 - HOWARD-RIDGE TIF FUND REVENUE Property Taxes 550,000 Other Revenue 1,120,000 Interest Income 100 REVENUE TOTALS 1,670,100 EXPENSE Services and Supplies 538,000 Capital Outlay 1,000,000 Community Sponsored Organizations - Debt Service 600 Miscellaneous - Interfund Transfers 107,500 EXPENSE TOTALS 1,646,100 Fund 330 - HOWARD-RIDGE TIF FUND REVENUE TOTALS 1,670,100 EXPENSE TOTALS 1,646,100 Fund 330 - HOWARD-RIDGE TIF FUND 24,000 Run by Ashley King on 04/06/2016 01:16:07 PM Page 23 of 50 30 Feb-16 YTD 2015 Actual Transaction s Transaction s - - - 1,028 1,028 - 102 203 257 1,131 1,232 257 - - 1,158 - (1,028) (11,205) - - - 724 1,351 7,185 - - - 2,500 5,000 60,000 3,224 5,323 57,137 1,131 1,232 257 3,224 5,323 57,137 (2,094) (4,091) (56,880) Starting Fund Balance 443,490 443,490 Net Change (39,850)(4,091) Ending Fund Balance 403,640 439,399 Budget by Organization Report Through 02/29/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 335 - WEST EVANSTON TIF FUND REVENUE Property Taxes - Other Revenue - Interest Income 150 REVENUE TOTALS 150 EXPENSE Services and Supplies - Capital Outlay - Contingencies - Debt Service 10,000 Miscellaneous - Interfund Transfers 30,000 EXPENSE TOTALS 40,000 Fund 335 - WEST EVANSTON TIF FUND TotalsREVENUE TOTALS 150 EXPENSE TOTALS 40,000 Fund 335 - WEST EVANSTON TIF FUND Totals (39,850) Run by Ashley King on 04/06/2016 01:16:07 PM Page 24 of 50 31 Feb-16 YTD 2015 Actual Transaction s Transaction s - - - - - - - - - - - - - - - - - - - - - - - - - - - Starting Fund Balance Net Change 10,000 Ending Fund Balance 10,000 Budget by Organization Report Through 02/29/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 340 - DEMPSTER-DODGE TIF FUND REVENUE Property Taxes - Other Revenue 50,000 REVENUE TOTALS 50,000 EXPENSE Services and Supplies - Debt Service 40,000 EXPENSE TOTALS 40,000 Fund 340 - DEMPSTER-DODGE TIF 10,000 Fund 340 - DEMPSTER-DODGE TIF REVENUE TOTALS 50,000 EXPENSE TOTALS 40,000 Run by Ashley King on 04/06/2016 01:16:07 PM Page 25 of 50 32 Feb-16 YTD 2015 Actual Transaction s Transaction s - - - - - 900,000 - - 900,000 - - - - - 580,000 2,962 5,923 7,930 2,962 5,923 587,930 - - 900,000 2,962 5,923 587,930 (2,962) (5,923) 312,070 Starting Fund Balance 312,070 312,070 Net Change 31,500 (5,923) Ending Fund Balance 343,570 306,147 Budget by Organization Report Through 02/29/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 345 - CHICAGO-MAIN TIF REVENUE Property Taxes 75,000 Other Revenue - REVENUE TOTALS 75,000 75,000 EXPENSE Services and Supplies - Capital Outlay - Debt Service 43,500 EXPENSE TOTALS 43,500 Fund 345 - CHICAGO-MAIN TIF Totals 31,500 EXPENSE TOTALS 43,500 Fund 345 - CHICAGO-MAIN TIF Totals REVENUE TOTALS Run by Ashley King on 04/06/2016 01:16:07 PM Page 26 of 50 33 Feb-16 YTD 2015 Actual Transaction s Transaction s - - - - - - - - - - - - - - - - - - - - - - - - Starting Fund Balance Net Change 10,500 Ending Fund Balance 10,500 Budget by Organization Report Through 02/29/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 350 - SPECIAL SERVICE AREA (SSA) #6 REVENUE Property Taxes 210,000 Interest Income 500 REVENUE TOTALS 210,500 EXPENSE Services and Supplies 200,000 EXPENSE TOTALS 200,000 Fund 350 - SPECIAL SERVICE AREA 10,500 Fund 350 - SPECIAL SERVICE AREA REVENUE TOTALS 210,500 EXPENSE TOTALS 200,000 Run by Ashley King on 04/06/2016 01:16:07 PM Page 27 of 50 34 Feb-16 YTD 2015 Actual Transaction s Transaction s 530 24,028 87,391 595,500 595,500 - 608,527 608,527 464,081 - 43,000 7,945,481 719 1,691 3,815 1,205,276 1,272,747 8,500,767 - - - 8,733 8,805 643,510 90,748 96,427 9,269,789 - - - - - - - - 490,000 99,481 105,232 10,403,299 1,205,276 1,272,747 8,500,767 99,481 105,232 10,403,299 1,105,795 1,167,515 (1,902,532) Starting Fund Balance 6,049,838 6,049,838 Net Change (2,209,000)1,167,515 Ending Fund Balance 3,840,838 7,217,353 Budget by Organization Report Through 02/29/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 415 - CAPITAL IMPROVEMENTS FUND REVENUE Charges for Services - Interfund Transfers 6,471,000 Intergovernmental Revenue 4,841,615 Other Revenue 9,248,000 Interest Income - REVENUE TOTALS 20,560,615 EXPENSE Salary and Benefits - Services and Supplies 2,256,962 Capital Outlay 20,022,653 20,560,615 Debt Service - Miscellaneous - Interfund Transfers 490,000 EXPENSE TOTALS 22,769,615 Fund 415 - CAPITAL IMPROVEMENTS (2,209,000) EXPENSE TOTALS 22,769,615 Fund 415 - CAPITAL IMPROVEMENTS REVENUE TOTALS Run by Ashley King on 04/06/2016 01:16:07 PM Page 28 of 50 35 Feb-16 YTD 2015 Actual Transaction s Transaction s - - - - - - - - - - - - - - - - - - - - - - - 243,113 - - - - - - - - - 1,483 8,152 24,832 2,868 32,059 125,218 - - - 4,351 40,211 393,163 - - - - 12 1,879 - - 226,538 - 21,725 - - - - - - - 30,058 30,058 - 30,058 51,795 228,417 4,351 40,211 393,163 30,058 51,795 228,417 (25,707) (11,584) 164,746 Starting Fund Balance 2,682,406 2,682,406 Net Change 98,950 (11,584) Ending Fund Balance 2,781,356 2,670,822 Budget by Organization Report Through 02/29/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 420 - SPECIAL ASSESSMENT FUND REVENUE Property Taxes - Other Taxes - Licenses, Permits and Fees - Fines and Forfeitures - Charges for Services - Interfund Transfers - Intergovernmental Revenue - Other Revenue 250,000 Workers Compensation and Liability - Insurance - Library Revenue - Interest Income 51,033 Special Assessment 180,167 Reappropriation of Surplus - REVENUE TOTALS 481,200 EXPENSE Salary and Benefits - Services and Supplies - Capital Outlay - Insurance and Other Chargebacks - Debt Service - Miscellaneous - Interfund Transfers 382,250 EXPENSE TOTALS 382,250 Fund 420 - SPECIAL ASSESSMENT FUND TotalsREVENUE TOTALS 481,200 EXPENSE TOTALS 382,250 Fund 420 - SPECIAL ASSESSMENT FUND Totals 98,950 Run by Ashley King on 04/06/2016 01:16:07 PM Page 29 of 50 36 Feb-16 YTD 2015 Actual Transaction s Transaction s - - - - - - 300 1,200 150 - - - 495,547 868,519 6,081,495 309,314 309,314 2,925,296 - - - 7,083 20,874 153,545 1,477 2,943 18,260 813,721 1,202,850 9,178,746 123,903 218,043 1,264,762 72,562 107,266 2,941,605 - - 2,107,697 26,637 68,964 319,649 - - - - - - 202 202 6,951 - - 3,917,650 - - - 108,649 188,131 923,092 331,953 582,606 11,481,405 813,721 1,202,850 9,178,746 331,953 582,606 11,481,405 481,768 620,244 (2,302,659) Starting Fund Balance 10,512,058 10,512,058 Net Change (6,615,186)620,244 Ending Fund Balance 3,896,872 11,132,302 Budget by Organization Report Through 02/29/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 505 - PARKING SYSTEM FUND REVENUE Property Taxes - Other Taxes - Licenses, Permits and Fees - Fines and Forfeitures - Charges for Services 6,444,675 Interfund Transfers 3,711,770 Intergovernmental Revenue 12,125 Other Revenue 119,216 Interest Income 35,070 REVENUE TOTALS 10,322,856 EXPENSE Salary and Benefits 1,485,289 Services and Supplies 3,301,275 Capital Outlay 3,474,000 Insurance and Other Chargebacks 319,648 Community Sponsored Organizations - Depreciation Expense 2,873,395 Contingencies 11,000 Debt Service 3,917,652 Miscellaneous 252,000 Interfund Transfers 1,303,783 EXPENSE TOTALS 16,938,042 Fund 505 - PARKING SYSTEM FUND (6,615,186) Fund 505 - PARKING SYSTEM FUND REVENUE TOTALS 10,322,856 EXPENSE TOTALS 16,938,042 Run by Ashley King on 04/06/2016 01:16:07 PM Page 30 of 50 37 Feb-16 YTD 2015 Actual Transaction s Transaction s - - - 6,113 11,997 105,483 2,132,706 2,947,559 15,481,471 - - - - - - 4,155 5,378 6,109,981 506 1,213 3,448 2,143,480 2,966,147 21,700,384 432,222 772,300 5,054,856 142,994 180,932 2,189,307 - 595 583,227 39,042 132,921 468,493 - - - - - - - - 854 - - 981,389 - - 875 291,859 1,583,719 11,875,155 906,117 2,670,466 21,154,154 2,143,480 2,966,147 21,700,384 906,117 2,670,466 21,154,154 1,237,363 295,681 546,229 Starting Fund Balance 7,619,979 7,619,979 Net Change 23,958,051 295,681 Ending Fund Balance 31,578,030 7,915,660 Budget by Organization Report Through 02/29/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 510 - WATER FUND REVENUE Other Taxes - Licenses, Permits and Fees 70,000 Charges for Services 15,298,000 Interfund Transfers - Intergovernmental Revenue - Other Revenue 22,348,400 Interest Income 1,600 REVENUE TOTALS 37,718,000 EXPENSE Salary and Benefits 5,105,126 Services and Supplies 3,490,950 Capital Outlay 75,800 Insurance and Other Chargebacks 468,492 Community Sponsored Organizations - Depreciation Expense - Contingencies 1,000 37,718,000 Debt Service 1,053,288 Miscellaneous 62,980 Interfund Transfers 3,502,313 EXPENSE TOTALS 13,759,949 Fund 510 - WATER FUND Totals 23,958,051 EXPENSE TOTALS 13,759,949 Fund 510 - WATER FUND Totals REVENUE TOTALS Run by Ashley King on 04/06/2016 01:16:07 PM Page 31 of 50 38 Feb-16 YTD 2015 Actual Transaction s Transaction s - - - - - - 121 315 1,207 121 315 1,207 - - - - - - - - - - - - 121 315 1,207 - - - 121 315 1,207 Starting Fund Balance Net Change 315 Ending Fund Balance 315 Budget by Organization Report Through 02/29/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 511 - WATER - BOND AND INTEREST REVENUE Interfund Transfers - Other Revenue - Interest Income - REVENUE TOTALS - EXPENSE Services and Supplies - Debt Service - Miscellaneous - EXPENSE TOTALS - Fund 511 - WATER - BOND AND REVENUE TOTALS - EXPENSE TOTALS - Fund 511 - WATER - BOND AND - Run by Ashley King on 04/06/2016 01:16:07 PM Page 32 of 50 39 Feb-16 YTD 2015 Actual Transaction s Transaction s 42 95 792 42 95 792 - - - - - - - - - - - - 42 95 792 - - - 42 95 792 Starting Fund Balance Net Change 95 Ending Fund Balance 95 Budget by Organization Report Through 02/29/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 512 - WATER-BOND RESERVE REVENUE Interest Income - REVENUE TOTALS - EXPENSE - Services and Supplies - Miscellaneous - Interfund Transfers - EXPENSE TOTALS - Fund 512 - WATER-BOND RESERVE Totals - EXPENSE TOTALS - Fund 512 - WATER-BOND RESERVE TotalsREVENUE TOTALS Run by Ashley King on 04/06/2016 01:16:07 PM Page 33 of 50 40 Feb-16 YTD 2015 Actual Transaction s Transaction s - 1,000,000 8,550,000 - - - - - - 42 89 534 42 1,000,089 8,550,534 16,822 16,822 395,395 195,063 196,535 8,293,392 - - - - - - 211,885 213,357 8,688,787 42 1,000,089 8,550,534 211,885 213,357 8,688,787 (211,843) 786,733 (138,254) Starting Fund Balance Net Change (27,365,306)786,733 Ending Fund Balance (27,365,306)786,733 Budget by Organization Report Through 02/29/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 513 - WATER DEPR IMPRV & EXTENSION REVENUE Interfund Transfers - Intergovernmental Revenue - Other Revenue - Interest Income - REVENUE TOTALS - EXPENSE Services and Supplies 2,665,000 - Capital Outlay 24,700,306 Miscellaneous - Interfund Transfers - EXPENSE TOTALS 27,365,306 Fund 513 - WATER DEPR IMPRV & (27,365,306) EXPENSE TOTALS 27,365,306 Fund 513 - WATER DEPR IMPRV & REVENUE TOTALS Run by Ashley King on 04/06/2016 01:16:07 PM Page 34 of 50 41 Feb-16 YTD 2015 Actual Transaction s Transaction s 1,198,069 2,283,140 13,023,526 - - - - - - 356 892 2,706 1,198,425 2,284,032 13,026,232 105,140 185,039 1,157,485 286 2,695 916,892 - - 500,881 43,457 98,741 269,988 - - - - - - 205,395 550,633 1,911,503 - - 3,306 43,532 87,063 735,235 397,810 924,170 5,495,290 1,198,425 2,284,032 13,026,232 397,810 924,170 5,495,290 800,615 1,359,861 7,530,942 Starting Fund Balance 4,420,037 4,420,037 Net Change (1,607,486)1,359,861 Ending Fund Balance 2,812,551 5,779,898 Budget by Organization Report Through 02/29/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 515 - SEWER FUND REVENUE Charges for Services 12,888,650 Interfund Transfers - Other Revenue 984,165 Interest Income 1,000 REVENUE TOTALS 13,873,815 EXPENSE Salary and Benefits 1,168,910 Services and Supplies 995,800 Capital Outlay 3,048,314 Insurance and Other Chargebacks 269,988 Depreciation Expense - Contingencies - Debt Service 9,222,913 Miscellaneous 1,500 Interfund Transfers 773,876 EXPENSE TOTALS 15,481,301 Fund 515 - SEWER FUND Totals (1,607,486) Fund 515 - SEWER FUND Totals REVENUE TOTALS 13,873,815 EXPENSE TOTALS 15,481,301 Run by Ashley King on 04/06/2016 01:16:07 PM Page 35 of 50 42 Feb-16 YTD 2015 Actual Transaction s Transaction s - - 357,583 394,199 771,733 3,557,884 - - 1,055,967 - - - 1,908 2,892 228,394 - - - 396,107 774,625 5,199,828 85,278 128,255 804,178 209,603 212,914 3,717,885 - - 24,738 - 10,808 - - - - - - - - - - - - 85,326 - - - 41,624 83,249 490,106 336,505 435,226 5,122,233 396,107 774,625 5,199,828 336,505 435,226 5,122,233 59,602 339,399 77,595 Starting Fund Balance (1,034,768)(1,034,768) Net Change 60,844 339,399 Ending Fund Balance (973,924)(695,369) Budget by Organization Report Through 02/29/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 520 - SOLID WASTE FUND REVENUE Licenses, Permits and Fees 275,000 Charges for Services 3,632,394 Interfund Transfers 1,055,967 Intergovernmental Revenue - Other Revenue 238,000 Interest Income - REVENUE TOTALS 5,201,361 EXPENSE Salary and Benefits 868,098 Services and Supplies 3,732,176 Capital Outlay 25,750 Insurance and Other Chargebacks - Community Sponsored Organizations - Depreciation Expense - Contingencies - Debt Service - Miscellaneous 15,000 Interfund Transfers 499,493 EXPENSE TOTALS 5,140,517 Fund 520 - SOLID WASTE FUND Totals 60,844 Fund 520 - SOLID WASTE FUND Totals REVENUE TOTALS 5,201,361 EXPENSE TOTALS 5,140,517 Run by Ashley King on 04/06/2016 01:16:07 PM Page 36 of 50 43 Feb-16 YTD 2015 Actual Transaction s Transaction s 282,370 564,408 3,289,009 - - - - - - 3,139 3,139 46,933 - - - 285,508 567,546 3,335,942 83,750 151,474 1,173,877 71,656 71,718 1,741,844 - - - 2,230 19,805 25,820 - - - - - - - - - - - - - - - 157,636 242,997 2,941,540 285,508 567,546 3,335,942 157,636 242,997 2,941,540 127,872 324,550 394,402 Starting Fund Balance 273,458 273,458 Net Change (244,277)324,550 Ending Fund Balance 29,181 598,008 Budget by Organization Report Through 02/29/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 600 - FLEET SERVICES FUND REVENUE Charges for Services 3,317,088 Interfund Transfers - Intergovernmental Revenue - Other Revenue 81,781 Interest Income 1,000 REVENUE TOTALS 3,399,869 EXPENSE Salary and Benefits 1,236,877 Services and Supplies 2,380,057 Capital Outlay - Insurance and Other Chargebacks 26,762 Depreciation Expense - Contingencies 450 3,399,869 Debt Service - Miscellaneous - Interfund Transfers - EXPENSE TOTALS 3,644,146 Fund 600 - FLEET SERVICES FUND (244,277) EXPENSE TOTALS 3,644,146 Fund 600 - FLEET SERVICES FUND REVENUE TOTALS Run by Ashley King on 04/06/2016 01:16:07 PM Page 37 of 50 44 Feb-16 YTD 2015 Actual Transaction s Transaction s 121,364 242,315 1,451,422 - - - - - 7,585 121,364 242,315 1,459,006 - 418 53,400 - - - - - - - - - - 418 53,400 121,364 242,315 1,459,006 - 418 53,400 121,364 241,897 1,405,607 Starting Fund Balance 1,899,429 1,899,429 Net Change 146,216 241,897 Ending Fund Balance 2,045,645 2,141,326 Budget by Organization Report Through 02/29/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 601 - EQUIPMENT REPLACEMENT FUND REVENUE Charges for Services 1,451,421 Interfund Transfers - Other Revenue 210,217 REVENUE TOTALS 1,661,638 EXPENSE Services and Supplies 60,000 Capital Outlay 1,455,422 Depreciation Expense - Miscellaneous - EXPENSE TOTALS 1,515,422 Fund 601 - EQUIPMENT REPLACEMENT 146,216 Fund 601 - EQUIPMENT REPLACEMENT REVENUE TOTALS 1,661,638 EXPENSE TOTALS 1,515,422 Run by Ashley King on 04/06/2016 01:16:07 PM Page 38 of 50 45 Feb-16 YTD 2015 Actual Transactions Transactions 13,534 27,069 162,411 68 137 - 841,824 1,682,647 10,182,110 94,522 181,499 1,034,405 474,624 939,526 5,304,769 27 38 136 1,424,599 2,830,916 16,683,830 39,818 74,835 483,455 240,925 292,638 2,214,473 - - - 1,107,496 2,265,498 14,663,593 - - - - - - - - - - - - - - (105,000) - 10,811 - 1,388,240 2,643,781 17,256,521 16,683,830 17,256,521 (572,691) Starting Fund Balance (3,954,618)(3,954,618) Net Change 565,405 187,134 Ending Fund Balance (3,389,213)(3,767,484) Budget by Organization Report Through 02/29/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 605 - INSURANCE FUND REVENUE Charges for Services 162,411 Interfund Transfers - Other Revenue 10,111,694 Workers Compensation and Liability 1,023,094 Insurance 6,459,839 Interest Income 1,000 REVENUE TOTALS 17,758,038 EXPENSE Salary and Benefits 479,323 Services and Supplies 1,385,248 Capital Outlay - Insurance and Other Chargebacks 15,328,062 Community Sponsored Organizations - Depreciation Expense - Contingencies - Debt Service - Miscellaneous - Interfund Transfers - EXPENSE TOTALS 17,192,633 Fund 605 - INSURANCE FUND 565,405 Fund 605 - INSURANCE FUND REVENUE TOTALS 17,758,038 EXPENSE TOTALS 17,192,633 36,359 187,134 1,424,599 2,830,916 1,388,240 2,643,781 Run by Ashley King on 04/06/2016 01:16:07 PM Page 1 of 2 46 Feb-16 YTD % u 2015 Actual Transaction s Transactions R e 960,362 975,660 7,106,772 - 50,995 280,000 - - - 74,679 138,404 1,009,930 10 14 319,811 1,035,051 1,165,073 8,716,512 716,818 1,413,546 8,302,220 - - - - - - - - - - - - 716,818 1,413,546 8,302,220 1,035,051 1,165,073 8,716,512 716,818 1,413,546 8,302,220 318,232 (248,473) 414,293 102,150,249 Starting Fund Balance 68,529,102 68,529,102 Net Change 4,297,865 (248,473) Ending Fund Balance 72,826,967 68,280,629 Budget by Organization Report Through 02/29/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 700 - FIRE PENSION FUND REVENUE Property Taxes 7,070,865 Other Taxes 280,000 Interfund Transfers - Other Revenue 1,010,000 Interest Income 4,100,000 REVENUE TOTALS 12,460,865 EXPENSE Salary and Benefits 8,163,000 Services and Supplies - Community Sponsored Organizations - Debt Service - Miscellaneous - EXPENSE TOTALS 8,163,000 Fund 700 - FIRE PENSION FUND Totals 4,297,865 Fund 700 - FIRE PENSION FUND Totals REVENUE TOTALS 12,460,865 EXPENSE TOTALS 8,163,000 Run by Ashley King on 04/06/2016 01:16:07 PM Page 41 of 50 47 Feb-16 YTD % u 2015 Actual Transaction s Transactions R e 1,326,611 1,348,009 9,097,160 - 50,995 325,000 - - - 112,601 206,316 1,454,770 3 8 734,309 1,439,215 1,605,328 11,611,239 909,794 1,823,458 10,768,296 - - - - - - - - - 909,794 1,823,458 10,768,296 1,439,215 1,605,328 11,611,239 909,794 1,823,458 10,768,296 529,420 (218,130) 842,942 Starting Fund Balance 102,150,249 ########## Net Change 68,529,102 (218,130) Ending Fund Balance 170,679,351 ########## Budget by Organization Report Through 02/29/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 705 - POLICE PENSION FUND REVENUE Property Taxes 9,055,940 Other Taxes 325,000 Interfund Transfers - Other Revenue 1,550,000 Interest Income 6,500,000 REVENUE TOTALS 17,430,940 EXPENSE Salary and Benefits 11,047,000 Services and Supplies - Debt Service - Miscellaneous - EXPENSE TOTALS 11,047,000 Fund 705 - POLICE PENSION FUND REVENUE TOTALS 17,430,940 EXPENSE TOTALS 11,047,000 Fund 705 - POLICE PENSION FUND 6,383,940 Run by Ashley King on 04/06/2016 01:16:07 PM Page 42 of 50 48