Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2016.03 March Monthly Report
To: Wally Bobkiewicz, City Manager Martin Lyons, Assistant City Manager/Chief Financial Officer From: Ashley King, Finance Division Manager Subject: March 2016 Monthly Financial Report Date: May 13, 2016 Please find attached the unaudited financial statements as of March 31, 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 24,389,104 20,297,732 4,091,372 17,193,730 8,182,090 646,422 179,862 466,561 1,206,169 365,939 125,000 (125,000)916,667 875,000 3,322,150 1,453,798 1,868,352 3,895,673 2,948,965 4,913 17,256 (12,342)109,881 196,429 495,294 628,039 (132,744)1,155,333 1,555,286 127,465 241,493 (114,029)488,648 267,648 214,595 80,750 133,845 278,103 (56,699) 9,942 191,649 (181,707)294,434 (121,824) 26,714 26,714 2,478,383 185,079 503,678 428,880 74,797 2,756,074 2,174,004 109,881 169,915 26,512 25,637 875 4,633,883 5,645 147,554 6,661 140,893 2,854,407 1,098,053 2,688,908 1,627,084 1,061,824 8,034,389 7,583,172 287,026 287,026 876,453 812,455 742,803 445,780 297,023 1,602,780 1,639,210 326,944 20,735 306,208 482,230 279,856 2,373 8,512 (6,139)437,351 444,446 - 8,194 (8,194)303,876 303,876 5,989,034 13,468,087 (7,479,053)8,006,517 6,310,560 2,325,343 400,767 1,924,577 7,974,415 8,345,879 72,131 90,187 (18,056)2,664,378 2,661,188 2,344,814 1,424,400 920,414 11,431,692 11,261,199 7,082,534 7,635,804 (553,269)7,066,592 6,521,738 3,032,252 3,044,933 (12,681)4,407,356 2,457,374 1,196,442 793,976 402,465 (632,303) (1,195,379) 6,444 (6,444)288,690 28,961 850,110 454,059 396,051 669,509 94,836 375,825 3,200 372,625 2,272,054 1,255,243 5,515,899 4,540,038 975,861 (2,978,679) 2,826,471 62,746,783 57,648,958 5,097,825 91,278,566 69,476,615 Fund Fund Description 100 GENERAL FUND 195 NEIGHBORHOOD STABILIZATION 200 MOTOR FUEL TAX FUND 175 GENERAL ASSISTANCE FUND 180 GOOD NEIGHBOR FUND 185 LIBRARY FUND 205 EMERGENCY TELEPHONE (E911) 210 SPECIAL SERVICE AREA (SSA) #4 215 CDBG FUND 240 HOME FUND 250 AFFORDABLE HOUSING FUND 220 CDBG LOAN 225 ECONOMIC DEVELOPMENT FUND 235 NEIGHBORHOOD IMPROVEMENT 300 WASHINGTON NATIONAL TIF 305 SPECIAL SERVICE AREA (SSA) #5 310 HOWARD-HARTREY TIF 340 DEMPSTER-DODGE TIF FUND 345 CHICAGO-MAIN TIF 315 SOUTHWEST TIF FUND 330 HOWARD-RIDGE TIF FUND 335 WEST EVANSTON TIF FUND 320 DEBT SERVICE FUND 415 CAPITAL IMPROVEMENTS FUND 420 SPECIAL ASSESSMENT FUND 505 PARKING SYSTEM FUND 510 WATER FUND 515 SEWER FUND 601 EQUIPMENT REPLACEMENT FUND 605 INSURANCE FUND 520 SOLID WASTE FUND 176 HEALTH AND HUMAN SERVICES 600 FLEET SERVICES FUND NOTE: Negative Cash Balances (as seen above in the CDBG, SSA 4 & Solid Waste Fund) reflect internal account balances and not external bank balances, due to transaction timing at month end. Memorandum Included above are the ending balances as of March 31, 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 March 31, 2016, the General Fund is reporting a net surplus of $4,091,372. This is significantly higher than the February net amount due to the receipt of the first installment of property taxes. The attached supplemental charts show the General Fund Revenues at 21.75% of budget and expenses lower at 18.17%. The first quarter goal is 25%. Through March 31, 2016, the SSA #4 Fund is showing a negative cash balance of $56,669 due to the timing of payments to the Downtown Evanston group. Through March 31, 2016, the CDBG Fund is showing a negative cash balance of $121,824 which will be reimbursed from April draw-downs. Through March 31, 2016, the Economic Development Fund is showing a fund balance of $2,756,074 and a cash balance of $2,174,004. Special Service Area #5 received 2016 property taxes in error for the first installment. This is due to the first property tax installment always being 55% of the previous year ’s tax amount. This money will be refunded to the County during the second installment billing. The fund will then officially close. Through March 31, 2016, the enterprise funds (Parking, Water, and Sewer) have balances above average. As construction season begins, the balances in all three of these funds will be reduced. The Debt Service Fund made a $13 million payment in January in connection with the refinancing of the 2006B bonds. The fund balance of $8,006,517, includes the first installment of property taxes. Through March 31, 2016, the Solid Waste Fund is showing a fund balance of negative $632,303 and a cash balance of negative $1,195,379. This puts the fund back on schedule as the January and February payments to SWANCC were paid by Council in March. Through March 31, 2016, the Insurance Fund is showing a negative fund balance of $2,978,679 with a cash balance of $2,826,471. 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 negat ive fund balance as estimated. 2016 Budget March Actual YTD Actual %2015 Actual 27,417,407 5,042,340 7,102,082 25.90% 11,397,061 45,986,550 2,884,385 9,828,563 21.37% 44,079,076 5,329,777 91,287 1,098,205 20.61% 5,324,137 9,276,550 831,343 1,470,605 15.85% 6,704,846 125,700 9,626 37,621 29.93% 155,619 4,609,825 281,656 750,029 16.27% 3,548,230 640,000 - - 0.00% 640,000 5,374,751 432,309 1,116,125 20.77% 5,406,379 2,433,216 229,726 771,162 31.69% 2,239,528 8,842,365 646,242 1,938,725 21.93% 7,836,484 765,727 38,148 107,597 14.05% 670,245 1,286,843 68,875 166,688 12.95% 894,703 50,000 551 1,702 3.40% 6,572 112,138,711 10,556,488 24,389,104 21.75% 88,902,880 CITY COUNCIL 424,958 24,590 103,394 24.33% 419,962 CITY CLERK 263,203 24,140 71,227 27.06% 283,764 CITY MANAGER'S OFFICE 6,989,746 387,453 986,082 14.11% 1,814,469 LAW 1,130,000 85,159 240,656 21.30% 1,051,325 ADMINISTRATIVE SERVICES 9,634,173 767,491 1,942,345 20.16% 9,491,649 COMMUNITY DEVELOPMENT 2,740,032 203,300 606,867 22.15% 2,425,618 POLICE 37,696,278 1,956,323 6,751,967 17.91% 28,493,534 FIRE MGMT & SUPPORT 22,601,742 1,097,484 3,867,817 17.11% 14,954,025 HEALTH 3,544,226 190,399 520,897 14.70% 3,212,848 PUBLIC WORKS 18,148,755 PARKS 11,820,590 663,679 2,050,099 17.34% 11,180,116 PUBLIC WORKS AGENCY 14,861,248 952,656 3,156,381 21.24% - 111,706,196 6,352,673 20,297,732 18.17% 91,476,064 REVENUE TOTALS 112,138,711 11,037,579 24,389,104 88,902,880 EXPENSE TOTALS 111,706,196 6,352,673 20,297,732 91,476,064 432,515 4,684,906 4,091,372 (2,573,184) Fund 100 - GENERAL FUND Classification Fund Category Governmental Funds Fund Type GENERAL FUND Fund 100 - GENERAL FUND Property Taxes Other Taxes License Permit Fee Fines and Forfeitures Parking Charges for Services Parks and Recreation Charges for Services Other Charges for Services Interfund Transfers Intergovernmental Revenue Other Revenue Interest Income REVENUE TOTAL 13 14 15 17 19 21 22 23 Fund 100 - GENERAL FUND Net 24 26 30 40 EXPENSE TOTAL Fund 100 - GENERAL FUND Totals 2016 Budget March Actual YTD Actual %2015 Actual - - 1,200 -- 150 6,379,675 500,579 1,370,245 21.48% 6,010,558 65,000 - - 0.00% - 3,711,770 309,314 927,942 25.00% 2,925,296 12,125 - - 0.00% - 119,216 19,651 40,525 33.99% 300,923 35,070 1,959 4,902 13.98% 18,260 10,322,856 831,503 2,344,814 22.71% 9,255,187 23,000 4,739 9,540 41.48% 29,187 1,348,940 98,805 312,878 23.19% 1,125,491 113,349 7,506 22,363 19.73% 107,452 3,022,411 531,547 637,975 21.11% 2,703,537 278,864 51,496 52,334 18.77% 243,068 3,474,000 9,229 9,229 0.27% 128,726 319,648 - 53,275 16.67% 319,649 2,873,395 - - 0.00% 2,846,227 11,000 659 861 7.82% 6,951 3,917,652 - - 0.00% 503,423 252,000 - - 0.00% 23,687 1,303,783 106,667 325,946 25.00% 923,092 16,938,042 810,647 1,424,400 8.41% 8,960,489 REVENUE TOTALS 10,322,856 831,503 2,344,814 9,255,187 EXPENSE TOTALS 16,938,042 810,647 1,424,400 8,960,489 (6,615,186) 20,856 920,414 294,698 Fund 505 - PARKING SYSTEM Contingencies Debt Service Miscellaneous Interfund Transfers EXPENSE TOTAL Fund 505 - PARKING SYSTEM Pensions Services Supplies Capital Outlay Insurance and Other Chargebacks Depreciation Expense Other Revenue Interest Income REVENUE TOTAL Employee Pay Benefits Fund 505 - PARKING SYSTEM FUND Permit Parking Charges for Services Parks and Recreation Charges for Services Interfund Transfers Intergovernmental Revenue Fund 505 - PARKING SYSTEM FUND Classification Fund Category Proprietary Funds Fund Type Enterprise Funds 2016 Budget March Actual YTD Actual %2015 Actual 70,000 8,003 20,000 28.57% 105,483 15,133,000 1,100,189 4,042,067 26.71% 15,141,770 39,000 3,118 8,842 22.67% 40,911 126,000 - (70)-0.06% 125,545 - 2,000,000 3,000,000 2,354,582 22,348,400 3,553 8,931 0.04% 338,396 1,600 1,052 2,765 172.80% 3,448 37,718,000 3,115,915 7,082,534 18.78%18,110,135 210,465 5,851 28,883 13.72% 157,679 4,534,306 351,702 1,100,803 24.28% 4,547,958 360,355 28,598 82,572 22.91% 432,229 2,098,760 131,847 251,619 11.99% 1,227,907 1,392,190 69,384 147,366 10.59% 1,048,119 75,800 1,866,840 2,063,969 2722.91% 105 468,492 - 78,084 16.67% 468,493 - - - 2,096,633 1,000 - - 0.00% 933 1,053,288 - - 0.00% 432,628 62,980 6,928 6,928 11.00% (345,617) 3,502,313 2,280,797 3,875,578 110.66% 3,692,565 13,759,949 4,741,946 7,635,804 55.49% 13,759,630 REVENUE TOTALS 37,718,000 3,115,915 7,082,534 18,110,135 EXPENSE TOTALS 13,759,949 4,741,946 7,635,804 13,759,630 23,958,051 (1,626,031) (553,269) 4,350,505 Fund 510 - WATER FUND Totals Fund 510 - WATER FUND Net Depreciation Expense Contingencies Debt Service Miscellaneous Interfund Transfers EXPENSE TOTAL Benefits Pensions Services Supplies Capital Outlay Insurance and Other Chargebacks Interfund Transfers Other Revenue Interest Income REVENUE TOTAL Employee Pay Fund 510 - WATER FUND Licenses, Permits and Fees Fee Water Charges for Services Sewer Charges for Services Other Charges for Services Fund 510 - WATER FUND Classification Fund Category Proprietary Funds Fund Type Enterprise Funds 2016 Budget March Actual YTD Actual %2015 Actual 12,869,000 747,814 3,031,041 23.55% 12,491,290 19,650 - - 0.00% 19,650 984,165 - - 0.00% 12,521 1,000 319 1,211 121.09% 2,706 13,873,815 748,133 3,032,252 21.86% 12,526,166 57,040 1,682 10,139 17.77% 60,837 1,025,778 79,014 254,232 24.78% 1,000,833 86,092 6,509 19,909 23.13% 101,701 903,500 1,056 1,161 0.13% 90,234 92,300 2,718 5,308 5.75% 18,817 3,048,314 100,264 100,264 3.29% 13,609 269,988 20,958 107,871 39.95% 269,988 - - - 3,443,723 9,222,913 1,859,821 2,410,454 26.14% 1,550,407 1,500 5,000 5,000 333.33% 3,306 773,876 27,514 130,595 16.88% 735,235 15,481,301 2,104,534 3,044,933 19.67%7,288,691 REVENUE TOTALS 13,873,815 748,133 3,032,252 12,526,166 EXPENSE TOTALS 15,481,301 2,104,534 3,044,933 7,288,691 (1,607,486) (1,356,401) (12,681) 5,237,476 EXPENSE TOTAL Fund 515 - SEWER FUND Totals Fund 515 - SEWER FUND Net Capital Outlay Insurance and Other Chargebacks Depreciation Expense Debt Service Miscellaneous Interfund Transfers Employee Pay Benefits Pensions Services Supplies Fund 515 - SEWER FUND Sewer Charges for Services Other Charges for Services Other Revenue Interest Income REVENUE TOTAL Fund 515 - SEWER FUND Classification Fund Category Proprietary Funds Fund Type Enterprise Funds 2016 Budget March Actual YTD Actual %2015 Actual 275,000 40,031 40,031 14.56% 213,490 - 87,997 263,992 - 3,632,394 284,594 880,385 24.24% 3,561,584 1,055,967 - - 0.00% 1,055,967 238,000 9,143 12,035 5.06% 228,469 5,201,361 421,765 1,196,442 23.00% 5,059,510 25,000 1,675 14,975 59.90% 41,358 779,380 58,074 175,251 22.49% 697,534 63,718 4,641 13,227 20.76% 68,816 3,679,126 251,452 460,923 12.53% 3,644,097 53,050 1,285 4,726 8.91% 73,788 25,750 - - 0.00% 24,738 - - - 68,394 15,000 - - 0.00% - 499,493 14,761 124,873 25.00% 490,106 5,140,517 331,888 793,976 15.45%5,108,831 REVENUE TOTALS 5,201,361 421,765 1,196,442 23% 5,059,510 EXPENSE TOTALS 5,140,517 331,888 793,976 15% 5,108,831 60,844 89,877 402,465 661% (49,321) Fund 520 - SOLID WASTE FUND Fund 520 - SOLID WASTE FUND Supplies Capital Outlay Debt Service Miscellaneous Interfund Transfers EXPENSE TOTAL REVENUE TOTAL Employee Pay Benefits Pensions Services Fund 520 - SOLID WASTE FUND License Solid Waste Charges for Services Other Charges for Services Interfund Transfers Other Revenue Fund 520 - SOLID WASTE FUND Classification Fund Category Proprietary Funds Fund Type Enterprise Funds Mar-16 YTD 2015 Actual Transactions Transactions Total 5,042,340 7,102,082 11,397,061 2,884,385 9,828,563 44,079,076 932,256 2,606,431 12,184,602 281,656 750,029 3,548,230 662,035 1,887,287 8,285,907 646,242 1,938,725 7,836,484 38,148 107,597 670,245 68,875 166,688 894,703 - - - - - - - - - 551 1,702 6,572 - - - - - - 88,902,880 5,103,803 16,766,474 68,174,630 857,690 1,444,071 11,384,724 26,897 28,389 155,975 60,186 563,382 3,020,991 5,316 17,988 952,678 - - - - 89 30,529 - - - 147,266 345,026 1,750,170 151,516 1,132,312 5,301,854 6,352,673 20,297,732 90,771,551 88,902,880 6,352,673 20,297,732 90,771,551 (1,868,671) Starting Fund Balance 13,102,358 13,102,358 Net Change (567,485) 4,091,372 Ending Fund Balance 12,534,873 17,193,730 Budget by Organization Report Through 03/31/16 Prior Fiscal Year Activity Included Detail Listing 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 - 112,138,711 Insurance - Library Revenue - Interest Income 50,000 71,111,353 Services and Supplies 11,776,309 Capital Outlay 200,600 Special Assessment - Reappropriation of Surplus - REVENUE TOTALS Insurance and Other Chargebacks 20,282,973 Community Sponsored 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 REVENUE TOTALS 112,138,711 EXPENSE TOTALS 112,706,196 Fund 100 - GENERAL FUND (567,485) 4,203,815 4,091,372 10,556,489 24,389,104 10,556,489 24,389,104 EXPENSE Salary and Benefits Run by Ashley King on 05/04/2016 03:37:15 PM Page 1 of 50 Mar-16 YTD 2015 Actual Transactions Transactions Total 439,188 618,591 1,313,420 - - - - - - - - - - - - - - - - - 3,208 27,750 27,750 19,534 - - - - - - - - - 38 81 62 - - - - - - 466,975 646,422 1,336,224 20,181 55,826 183,547 42,337 123,927 591,542 - - - - - - - - - - - - - - - - - - 50 109 4,625 - - - 62,568 179,862 779,714 1,336,224 779,714 556,510 Starting Fund Balance 739,609 739,609 Net Change 38,167 466,561 Ending Fund Balance 777,776 1,206,169 Budget by Organization Report Through 03/31/16 Prior Fiscal Year Activity Included Detail Listing 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 - 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 - Depreciation Expense - Contingencies - Debt Service - Miscellaneous 7,000 Interfund Transfers - EXPENSE TOTALS 987,833 Fund 175 - GENERAL REVENUE TOTALS 1,026,000 EXPENSE TOTALS 987,833 Fund 175 - GENERAL 38,167 404,407 466,561 466,975 646,422 62,568 179,862 Run by Ashley King on 05/04/2016 03:37:15 PM Page 3 of 50 Mar-16 YTD 2015 Actual Transactions Transactions Total - - - 73,733 221,199 884,794 41,667 - - - - - 884,794 - - - - - - - 6,444 849,388 - - - - 6,444 849,388 884,794 - 6,444 849,388 35,406 Starting Fund Balance 48,295 73,936 Net Change 25,641 214,754 Ending Fund Balance 73,936 288,690 Budget by Organization Report Through 03/31/16 Prior Fiscal Year Activity Included Detail Listing 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 - Capital Outlay - Community Sponsored 859,153 Miscellaneous - EXPENSE TOTALS 859,153 Fund 176 - HEALTH AND REVENUE TOTALS 884,794 EXPENSE TOTALS 859,153 Fund 176 - HEALTH AND 25,641 115,400 221,199 115,400 221,199 115,400 214,754 Run by Ashley King on 05/04/2016 03:37:15 PM Page 4 of 50 Mar-16 YTD 2015 Actual Transactions Transactions Total - - - - - - 41,667 125,000 - 41,667 83,333 - - - - 41,667 83,333 - (41,667) (83,333) - Starting Fund Balance 1,000,000 1,000,000 Net Change - (83,333) Ending Fund Balance 1,000,000 916,667 Budget by Organization Report Through 03/31/16 Prior Fiscal Year Activity Included Detail Listing 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 REVENUE TOTALS 1,000,000 EXPENSE TOTALS 1,000,000 Fund 180 - GOOD NEIGHBOR - Run by Ashley King on 05/04/2016 03:37:15 PM Page 5 of 50 Mar-16 YTD 2015 Actual Transactions Transactions Total 2,275,060 3,219,566 5,916,852 - - 50,200 14,911 42,587 129,808 - - 171,000 2,220 2,605 181,283 (185) (185) 286 20,789 56,886 315,924 173 505 2,683 2,274,611 3,219,244 6,768,037 349,803 1,088,163 4,703,383 126,205 280,476 1,426,649 - 90 299,628 6,674 20,022 77,268 - - - - - - - - - 20,833 62,500 250,000 395 2,546 4,200 503,911 1,453,797 6,761,128 2,274,611 3,219,244 6,768,037 503,911 1,426,462 6,761,128 1,770,700 1,792,782 6,910 Starting Fund Balance 2,102,891 2,102,891 Net Change 20,015 1,792,782 Ending Fund Balance 2,122,906 3,895,673 Budget by Organization Report Through 03/31/16 Prior Fiscal Year Activity Included Detail Listing 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 20,015 EXPENSE TOTALS 6,997,142 Fund 185 - LIBRARY FUND REVENUE TOTALS Run by Ashley King on 05/04/2016 03:37:15 PM Page 6 of 50 Mar-16 YTD 2015 Actual Transactions Transactions Total 177,293 191,776 601,811 - - - 177,293 191,776 601,811 - - - (20,076) (20,076) - - - 562,740 - - - (20,076) (20,076) 562,740 177,293 191,776 601,811 (20,076) (20,076) 562,740 197,369 211,852 39,072 Starting Fund Balance 132,667 132,667 Net Change 211,852 Ending Fund Balance 132,667 344,519 Budget by Organization Report Through 03/31/16 Prior Fiscal Year Activity Included Detail Listing 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 REVENUE TOTALS 393,409 EXPENSE TOTALS 393,409 Fund 186 - LIBRARY DEBT - Run by Ashley King on 05/04/2016 03:37:15 PM Page 7 of 50 Mar-16 YTD 2015 Actual Transactions Transactions Total - - - 4,863 4,863 130,126 - - - 17 50 - 4,880 4,913 130,126 1,577 6,547 59,467 3,060 3,060 4,611 4,863 4,863 68,352 362 1,086 5,730 - - - - 1,700 179 - - (8,213) 9,862 17,256 130,126 4,880 4,913 130,126 9,862 17,256 130,126 (4,982) (12,343) - Starting Fund Balance 122,224 122,224 Net Change (303) (12,343) Ending Fund Balance 121,921 109,881 Budget by Organization Report Through 03/31/16 Prior Fiscal Year Activity Included Detail Listing 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 05/04/2016 03:37:15 PM Page 8 of 50 Mar-16 YTD 2015 Actual Transactions Transactions Total 163,640 494,117 2,465,781 - - - 485 1,177 819 - - - 164,125 495,294 2,466,600 - - - 80,789 80,789 1,583,238 - - - - - - - - - 182,417 547,250 833,000 263,205 628,039 2,416,238 164,125 495,294 2,466,600 263,205 628,039 2,416,238 (99,080) (132,744) 50,362 Starting Fund Balance 1,288,077 1,288,077 Net Change (478,000) (132,744) Ending Fund Balance 810,077 1,155,333 Budget by Organization Report Through 03/31/16 Prior Fiscal Year Activity Included Detail Listing 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 (478,000) Fund 200 - MOTOR FUEL TAX REVENUE TOTALS 1,711,000 EXPENSE TOTALS 2,189,000 Run by Ashley King on 05/04/2016 03:37:15 PM Page 9 of 50 Mar-16 YTD 2015 Actual Transactions Transactions Total 83,975 126,972 977,071 - - - - - 100 287 492 189 84,262 127,465 977,361 44,267 142,307 579,447 3,089 32,695 347,694 28,031 28,031 239,421 1,040 6,027 29,486 - - - - - 2,046 - - - - - 1,500 10,811 32,432 129,729 87,238 241,493 1,329,323 84,262 127,465 977,361 87,238 241,493 1,329,323 (2,976) (114,029) (351,962) Starting Fund Balance 602,677 602,677 Net Change (497,643) (114,029) Ending Fund Balance 105,034 488,648 Budget by Organization Report Through 03/31/16 Prior Fiscal Year Activity Included Detail Listing 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 - Contingencies 5,000 Debt Service - Miscellaneous - Interfund Transfers 129,729 EXPENSE TOTALS 1,516,643 Fund 205 - EMERGENCY (497,643) Fund 205 - EMERGENCY REVENUE TOTALS 1,019,000 EXPENSE TOTALS 1,516,643 Run by Ashley King on 05/04/2016 03:37:15 PM Page 10 of 50 Mar-16 YTD 2015 Actual Transactions Transactions Total 155,487 214,594 322,055 1 1 3 155,488 214,595 322,058 80,750 80,750 323,000 - - - - - - 80,750 80,750 323,000 155,488 214,595 322,058 80,750 80,750 323,000 74,738 133,845 (942) Starting Fund Balance 144,258 144,258 Net Change - 133,845 Ending Fund Balance 144,258 278,103 Budget by Organization Report Through 03/31/16 Prior Fiscal Year Activity Included Detail Listing 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 - EXPENSE TOTALS 320,000 Fund 210 - SPECIAL SERVICE REVENUE TOTALS Run by Ashley King on 05/04/2016 03:37:15 PM Page 11 of 50 Mar-16 YTD 2015 Actual Transactions Transactions Total - - - - - - - - 1,442,742 9,942 9,942 3,318 - - - 9,942 9,942 1,446,060 31,410 112,868 362,786 2,251 2,282 17,538 - 4,324 276,834 (2,273) 2,273 20,767 - - 235,459 - - - - - - 82 142 12,259 (69,760) 69,760 449,083 (38,290) 191,649 1,374,727 9,942 9,942 1,446,060 (38,290) 191,649 1,374,727 48,232 (181,706) 71,333 Starting Fund Balance 476,140 476,140 Net Change 375 (181,706) Ending Fund Balance 476,515 294,434 Budget by Organization Report Through 03/31/16 Prior Fiscal Year Activity Included Detail Listing 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 - 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 05/04/2016 03:37:15 PM Page 12 of 50 Mar-16 YTD 2015 Actual Transactions Transactions Total - - - 2,742 26,625 14,951 19 89 375 2,761 26,714 15,326 - - - - - 280,461 - - 1,919 - - - - - 282,380 2,761 26,714 15,326 - - 282,380 2,761 26,714 (267,054) Starting Fund Balance 2,451,669 2,451,669 Net Change 26,714 Ending Fund Balance 2,451,669 2,478,383 Budget by Organization Report Through 03/31/16 Prior Fiscal Year Activity Included Detail Listing 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 05/04/2016 03:37:15 PM Page 13 of 50 Mar-16 YTD 2015 Actual Transactions Transactions Total 3,416 491,277 2,116,843 - - - - - - 5,160 12,102 49,000 174 299 128 8,750 503,678 2,165,971 40,696 144,279 596,265 34,982 35,782 302,867 28,529 29,233 194,941 1,277 6,157 32,230 - - - - - - - - - 930 930 1,293,041 70,833 212,499 600,000 177,247 428,880 3,019,344 8,750 503,678 2,165,971 177,247 428,880 3,019,344 (168,497) 74,797 (853,373) Starting Fund Balance 2,681,277 2,681,277 Net Change (286,099) 74,797 Ending Fund Balance 2,395,178 2,756,074 Budget by Organization Report Through 03/31/16 Prior Fiscal Year Activity Included Detail Listing 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 - Contingencies - 2,262,600 Debt Service - Miscellaneous 16,000 Interfund Transfers 600,000 EXPENSE TOTALS 2,548,699 Fund 225 - ECONOMIC (286,099) EXPENSE TOTALS 2,548,699 Fund 225 - ECONOMIC REVENUE TOTALS Run by Ashley King on 05/04/2016 03:37:15 PM Page 14 of 50 Mar-16 YTD 2015 Actual Transactions Transactions Total - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Starting Fund Balance 169,915 169,915 Net Change (80,000) Ending Fund Balance 89,915 169,915 Budget by Organization Report Through 03/31/16 Prior Fiscal Year Activity Included Detail Listing 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 05/04/2016 03:37:15 PM Page 15 of 50 Mar-16 YTD 2015 Actual Transactions Transactions Total 19,788 19,788 465,961 2,282 6,721 6,402 0 3 19 22,070 26,512 472,382 2,516 2,516 12,388 11,923 22,985 282,753 - - - - 137 1,368 - - - - - - - - 45,747 - - 26,990 14,439 25,637 369,246 22,070 26,512 472,382 14,439 25,637 369,246 7,631 875 103,136 Starting Fund Balance 4,633,008 4,633,008 Net Change 875 Ending Fund Balance 4,633,008 4,633,883 Budget by Organization Report Through 03/31/16 Prior Fiscal Year Activity Included Detail Listing 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 - 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 05/04/2016 03:37:15 PM Page 16 of 50 Mar-16 YTD 2015 Actual Transactions Transactions Total - 36,667 100,000 - - - - - - 77,971 110,610 125,150 162 277 111 78,133 147,554 225,261 2,516 2,516 - - - 98 - - - - - - - - - 4,145 4,145 142,171 - - - 6,661 6,661 142,270 78,133 147,554 225,261 6,661 6,661 142,270 71,472 140,893 82,992 Starting Fund Balance 2,713,514 2,713,514 Net Change (313,719) 140,893 Ending Fund Balance 2,399,795 2,854,407 Budget by Organization Report Through 03/31/16 Prior Fiscal Year Activity Included Detail Listing 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 - Debt Service - Miscellaneous 76,000 Interfund Transfers - EXPENSE TOTALS 474,347 Fund 250 - AFFORDABLE REVENUE TOTALS 160,628 EXPENSE TOTALS 474,347 Fund 250 - AFFORDABLE (313,719) Run by Ashley King on 05/04/2016 03:37:15 PM Page 17 of 50 Mar-16 YTD 2015 Actual Transactions Transactions Total 1,450,984 2,686,756 4,921,484 - - - - - - - - - 805 2,152 3,530 1,451,788 2,688,908 4,925,014 - - - - - 1,408 4,473 4,473 198,823 - - 574,976 24,669 24,669 110,310 532,647 1,597,924 3,265,296 561,789 1,627,066 4,150,811 1,451,788 2,688,908 4,925,014 561,789 1,627,066 4,150,811 889,999 1,061,842 774,203 Starting Fund Balance 6,972,547 6,972,547 Net Change (2,640,683) 1,061,842 Ending Fund Balance 4,331,864 8,034,389 Budget by Organization Report Through 03/31/16 Prior Fiscal Year Activity Included Detail Listing 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 (2,640,683) EXPENSE TOTALS 7,787,683 Fund 300 - WASHINGTON REVENUE TOTALS Run by Ashley King on 05/04/2016 03:37:15 PM Page 18 of 50 Mar-16 YTD 2015 Actual Transactions Transactions Total 188,690 287,024 422,527 - - - - - - 2 2 4 188,691 287,026 422,531 - - - - - 297,150 - - - - - 297,150 188,691 287,026 422,531 - - 297,150 188,691 287,026 125,381 Starting Fund Balance 589,427 589,427 Net Change (467,971) 287,026 Ending Fund Balance 121,456 876,453 Budget by Organization Report Through 03/31/16 Prior Fiscal Year Activity Included Detail Listing 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 (467,971) Fund 305 - SPECIAL SERVICE REVENUE TOTALS 300 EXPENSE TOTALS 468,271 Run by Ashley King on 05/04/2016 03:37:15 PM Page 19 of 50 Mar-16 YTD 2015 Actual Transactions Transactions Total 726,904 742,308 1,248,231 136 495 1,985 727,040 742,803 1,250,216 - - 1,158 - 7,668 11,402 - - - - - - - - 2,162,381 146,038 438,113 148,010 146,038 445,780 2,322,950 727,040 742,803 1,250,216 146,038 445,780 2,322,950 581,003 297,023 (1,072,734) Starting Fund Balance 1,305,757 1,305,757 Net Change (650,450) 297,023 Ending Fund Balance 655,307 1,602,780 Budget by Organization Report Through 03/31/16 Prior Fiscal Year Activity Included Detail Listing 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 - 1,302,000 Debt Service - Miscellaneous 200,000 Interfund Transfers 1,752,450 EXPENSE TOTALS 1,952,450 Fund 310 - HOWARD- (650,450) EXPENSE TOTALS 1,952,450 Fund 310 - HOWARD- REVENUE TOTALS Run by Ashley King on 05/04/2016 03:37:15 PM Page 20 of 50 Mar-16 YTD 2015 Actual Transactions Transactions Total .00 .00 .00 .00 .00 .00 $0.00 $0.00 $0.00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 893,387.22 .00 .00 .00 $0.00 $0.00 $893,387.22 .00 .00 .00 .00 .00 893,387.22 $0.00 $0.00 ($893,387.22) Starting Fund Balance Net Change Ending Fund Balance Budget by Organization Report Through 03/31/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 315 - SOUTHWEST TIF FUND REVENUE Property Taxes .00 Interest Income .00 REVENUE TOTALS $0.00 EXPENSE Services and Supplies .00 Capital Outlay .00 Debt Service .00 Miscellaneous .00 Interfund Transfers .00 EXPENSE TOTALS $0.00 Fund 315 - SOUTHWEST TIF $0.00 Fund 315 - SOUTHWEST TIF REVENUE TOTALS .00 EXPENSE TOTALS .00 Run by Ashley King on 05/04/2016 03:37:15 PM Page 21 of 50 Mar-16 YTD 2015 Actual Transactions Transactions Total 3,815,004 5,450,815 11,156,231 114,451 345,466 1,642,654 - - 12,278,473 566 977 7,668 3,930,021 5,797,258 25,085,026 250 500 171,576 - 13,487,663 13,028,022 - - 3,062 - - - 250 13,488,163 13,202,661 3,930,021 5,797,258 25,085,026 250 13,488,163 13,202,661 3,929,771 (7,690,905) 11,882,365 Starting Fund Balance 15,697,422 15,697,422 Net Change (2,751,668) (7,690,905) Ending Fund Balance 12,945,754 8,006,517 Budget by Organization Report Through 03/31/16 Prior Fiscal Year Activity Included Detail Listing 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 (2,751,668) EXPENSE TOTALS 16,279,452 Fund 320 - DEBT SERVICE REVENUE TOTALS Run by Ashley King on 05/04/2016 03:37:15 PM Page 22 of 50 Mar-16 YTD 2015 Actual Transactions Transactions Total 287,081 293,284 540,576 18,550 33,569 64,176 33 91 1,815 305,663 326,944 606,568 1,399 5,569 587,839 - - (6,275) - - - 56 166 585 - - 350 5,000 15,000 107,500 6,456 20,735 689,999 305,663 326,944 606,568 6,456 20,735 689,999 299,208 306,208 (83,431) Starting Fund Balance 176,022 176,022 Net Change 24,000 306,208 Ending Fund Balance 200,022 482,230 Budget by Organization Report Through 03/31/16 Prior Fiscal Year Activity Included Detail Listing 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 - Debt Service 600 Miscellaneous - Interfund Transfers 107,500 EXPENSE TOTALS 1,646,100 Fund 330 - HOWARD-RIDGE REVENUE TOTALS 1,670,100 EXPENSE TOTALS 1,646,100 Fund 330 - HOWARD-RIDGE 24,000 Run by Ashley King on 05/04/2016 03:37:15 PM Page 23 of 50 Mar-16 YTD 2015 Actual Transactions Transactions Total - - - 1,028 2,057 - 113 317 257 1,142 2,373 257 - - 1,158 - (1,028) (11,205) - - - 689 2,041 7,185 - - 1,227 2,500 7,500 60,000 3,189 8,512 58,365 1,142 2,373 257 3,189 8,512 58,365 (2,048) (6,139) (58,107) Starting Fund Balance 443,490 443,490 Net Change (39,850) (6,139) Ending Fund Balance 403,640 437,351 Budget by Organization Report Through 03/31/16 Prior Fiscal Year Activity Included Detail Listing 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 REVENUE TOTALS 150 EXPENSE TOTALS 40,000 Fund 335 - WEST EVANSTON (39,850) Run by Ashley King on 05/04/2016 03:37:15 PM Page 24 of 50 Mar-16 YTD 2015 Actual Transactions Transactions Total - - - - - 2,000,000 - - 2,000,000 - - - - - 2,000,000 - - - - - 2,000,000 - - 2,000,000 - - 2,000,000 - - - Starting Fund Balance Net Change 10,000 Ending Fund Balance 10,000 Budget by Organization Report Through 03/31/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 340 - DEMPSTER-DODGE TIF FUND REVENUE Property Taxes - Other Revenue 50,000 REVENUE TOTALS 50,000 50,000 EXPENSE Services and Supplies - Capital Outlay - Debt Service 40,000 EXPENSE TOTALS 40,000 Fund 340 - DEMPSTER- 10,000 EXPENSE TOTALS 40,000 Fund 340 - DEMPSTER- REVENUE TOTALS Run by Ashley King on 05/04/2016 03:37:15 PM Page 25 of 50 Mar-16 YTD 2015 Actual Transactions Transactions Total - - - - - 900,000 - - 900,000 - - - - - 580,000 2,271 8,194 7,930 2,271 8,194 587,930 - - 900,000 2,271 8,194 587,930 (2,271) (8,194) 312,070 Starting Fund Balance 312,070 312,070 Net Change 31,500 (8,194) Ending Fund Balance 343,570 303,876 Budget by Organization Report Through 03/31/16 Prior Fiscal Year Activity Included Detail Listing 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 31,500 EXPENSE TOTALS 43,500 Fund 345 - CHICAGO-MAIN REVENUE TOTALS Run by Ashley King on 05/04/2016 03:37:15 PM Page 26 of 50 Mar-16 YTD 2015 Actual Transactions Transactions Total - - - - - - - - - - - - - - - - - - - - - - - - Starting Fund Balance Net Change 10,500 Ending Fund Balance 10,500 Budget by Organization Report Through 03/31/16 Prior Fiscal Year Activity Included Detail Listing 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 10,500 Fund 350 - SPECIAL SERVICE REVENUE TOTALS 210,500 EXPENSE TOTALS 200,000 Run by Ashley King on 05/04/2016 03:37:15 PM Page 27 of 50 Mar-16 YTD 2015 Actual Transactions Transactions Total - 24,028 87,391 456,333 1,647,333 - - 608,527 464,081 - 43,000 7,945,481 763 2,455 3,815 457,097 2,325,343 8,500,767 - - - 41,210 50,015 643,510 254,325 350,752 9,794,396 - - - - - 32,933 - - 490,000 295,535 400,767 10,960,839 457,097 2,325,343 8,500,767 295,535 400,767 10,960,839 161,562 1,924,577 (2,460,072) Starting Fund Balance 6,049,838 6,049,838 Net Change (2,209,000) 1,924,577 Ending Fund Balance 3,840,838 7,974,415 Budget by Organization Report Through 03/31/16 Prior Fiscal Year Activity Included Detail Listing 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 (2,209,000) EXPENSE TOTALS 22,769,615 Fund 415 - CAPITAL REVENUE TOTALS Run by Ashley King on 05/04/2016 03:37:15 PM Page 28 of 50 Mar-16 YTD 2015 Actual Transactions Transactions Total - - - - - - - - - - - - - - - - - - - - - - - 243,113 - - - - - - - - - 1,285 10,159 24,832 26,612 61,972 125,218 - - - 27,898 72,131 393,163 - - - - 12 1,879 - - 226,538 - - - - - - - - 534 30,058 90,147 - 30,058 90,159 228,951 27,898 72,131 393,163 30,058 90,159 228,951 (2,161) (18,028) 164,213 Starting Fund Balance 2,682,406 2,682,406 Net Change 98,950 (18,028) Ending Fund Balance 2,781,356 2,664,378 Budget by Organization Report Through 03/31/16 Prior Fiscal Year Activity Included Detail Listing 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 - 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 REVENUE TOTALS 481,200 EXPENSE TOTALS 382,250 Fund 420 - SPECIAL 98,950 Run by Ashley King on 05/04/2016 03:37:15 PM Page 29 of 50 Mar-16 YTD 2015 Actual Transactions Transactions Total - - - - - - - 1,200 150 - - - 500,579 1,370,245 6,081,495 309,314 927,942 2,925,296 - - - 19,651 40,525 300,923 1,959 4,902 18,260 831,503 2,344,814 9,326,124 111,830 345,561 1,251,729 583,043 690,310 2,946,605 9,229 9,229 128,726 - 53,275 319,649 - - - - - - 659 861 6,951 - - 503,423 - - 22,347 106,667 325,946 923,092 811,428 1,425,181 6,102,521 831,503 2,344,814 9,326,124 811,428 1,425,181 6,102,521 20,075 919,634 3,223,603 Starting Fund Balance 10,512,058 10,512,058 Net Change (6,615,186) 919,634 Ending Fund Balance 3,896,872 11,431,692 Budget by Organization Report Through 03/31/16 Prior Fiscal Year Activity Included Detail Listing 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 - 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 (6,615,186) Fund 505 - PARKING SYSTEM REVENUE TOTALS 10,322,856 EXPENSE TOTALS 16,938,042 Run by Ashley King on 05/04/2016 03:37:15 PM Page 30 of 50 Mar-16 YTD 2015 Actual Transactions Transactions Total - - - 8,003 20,000 105,483 1,103,307 4,050,838 15,308,225 2,000,000 3,000,000 2,354,582 - - - 3,553 8,931 338,396 1,052 2,647 3,448 3,115,915 7,082,417 18,110,135 386,150 1,212,259 5,098,939 201,231 398,985 2,276,026 1,866,840 2,063,969 105 - 78,084 468,493 - - - - - - - - 933 - - 432,628 6,928 6,928 (345,617) 2,280,797 3,875,578 3,692,565 4,741,946 7,635,804 11,624,071 3,115,915 7,082,417 18,110,135 4,741,946 7,635,804 11,624,071 (1,626,031) (553,387) 6,486,064 Starting Fund Balance 7,619,979 7,619,979 Net Change 23,958,051 (553,387) Ending Fund Balance 31,578,030 7,066,592 Budget by Organization Report Through 03/31/16 Prior Fiscal Year Activity Included Detail Listing 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 - 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 23,958,051 EXPENSE TOTALS 13,759,949 Fund 510 - WATER FUND REVENUE TOTALS Run by Ashley King on 05/04/2016 03:37:15 PM Page 31 of 50 Mar-16 YTD 2015 Actual Transactions Transactions Total 747,814 3,031,041 12,510,940 - - - - - 12,521 319 1,211 2,706 748,133 3,032,252 12,526,166 87,204 284,280 1,154,451 3,774 6,469 109,052 100,264 100,264 13,609 20,958 107,871 269,988 - - - - - - 1,859,821 2,410,454 1,550,407 5,000 5,000 3,306 27,514 130,595 735,235 2,104,534 3,044,933 3,836,047 748,133 3,032,252 12,526,166 2,104,534 3,044,933 3,836,047 (1,356,401) (12,681) 8,690,119 Starting Fund Balance 4,420,037 4,420,037 Net Change (1,607,486) (12,681) Ending Fund Balance 2,812,551 4,407,356 Budget by Organization Report Through 03/31/16 Prior Fiscal Year Activity Included Detail Listing 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 (1,607,486) Fund 515 - SEWER FUND REVENUE TOTALS 13,873,815 EXPENSE TOTALS 15,481,301 Run by Ashley King on 05/04/2016 03:37:15 PM Page 32 of 50 Mar-16 YTD 2015 Actual Transactions Transactions Total 40,031 40,031 213,490 372,591 1,144,376 3,561,584 - - 1,055,967 - - - 9,143 12,035 228,469 - - - 421,765 1,196,442 5,059,510 64,391 203,453 803,185 252,736 465,650 3,717,885 - - 24,738 - - - - - - - - - - - - - - 68,394 - - - 14,761 124,873 490,106 331,888 793,976 5,104,308 421,765 1,196,442 5,059,510 331,888 793,976 5,104,308 89,877 402,465 (44,798) Starting Fund Balance (1,034,768) (1,034,768) Net Change 60,844 402,465 Ending Fund Balance (973,924) (632,303) Budget by Organization Report Through 03/31/16 Prior Fiscal Year Activity Included Detail Listing 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 - Depreciation Expense - Contingencies - Debt Service - Miscellaneous 15,000 Interfund Transfers 499,493 EXPENSE TOTALS 5,140,517 Fund 520 - SOLID WASTE 60,844 Fund 520 - SOLID WASTE REVENUE TOTALS 5,201,361 EXPENSE TOTALS 5,140,517 Run by Ashley King on 05/04/2016 03:37:15 PM Page 33 of 50 Mar-16 YTD 2015 Actual Transactions Transactions Total (69) 846,971 3,289,009 - - - - - - - 3,139 46,933 - - - (69) 850,110 3,335,942 72,031 238,849 1,130,200 136,801 208,519 1,686,117 - - - 2,230 6,690 25,820 - - - - - - - - - - - - - - - 211,062 454,059 2,842,137 (69) 850,110 3,335,942 211,062 454,059 2,842,137 (211,131) 396,051 493,806 Starting Fund Balance 273,458 273,458 Net Change (244,277) 396,051 Ending Fund Balance 29,181 669,509 Budget by Organization Report Through 03/31/16 Prior Fiscal Year Activity Included Detail Listing 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 (244,277) EXPENSE TOTALS 3,644,146 Fund 600 - FLEET SERVICES REVENUE TOTALS Run by Ashley King on 05/04/2016 03:37:15 PM Page 34 of 50 Mar-16 YTD 2015 Actual Transactions Transactions Total 121,147 363,874 1,451,422 - - - 11,951 11,951 34,286 133,098 375,825 1,485,708 - 418 53,400 2,782 2,782 - - - - - - - 2,782 3,200 53,400 133,098 375,825 1,485,708 2,782 3,200 53,400 130,316 372,625 1,432,308 Starting Fund Balance 1,899,429 1,899,429 Net Change 146,216 372,625 Ending Fund Balance 2,045,645 2,272,054 Budget by Organization Report Through 03/31/16 Prior Fiscal Year Activity Included Detail Listing 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 146,216 Fund 601 - EQUIPMENT REVENUE TOTALS 1,661,638 EXPENSE TOTALS 1,515,422 Run by Ashley King on 05/04/2016 03:37:15 PM Page 35 of 50 Mar-16 YTD 2015 Actual Transactions Transactions Total (78) 6,868 162,411 - 137 306,051 835,655 4,097,423 10,182,110 6,364 36,338 1,034,405 262,802 1,375,164 5,304,769 9 47 136 1,104,753 5,515,976 16,989,882 38,365 113,199 512,385 63,447 823,484 1,305,086 - - - 1,224,521 3,603,354 14,301,173 - - - - - - - - - - - - - - (105,000) - - - 1,326,332 4,540,037 16,013,644 1,104,753 5,515,976 16,989,882 1,326,332 4,540,037 16,013,644 (221,579) 975,939 976,238 Starting Fund Balance (3,954,618) (3,954,618) Net Change 565,405 975,939 Ending Fund Balance (3,389,213) (2,978,679) Budget by Organization Report Through 03/31/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 605 - INSURANCE FUND REVENUE Charges for Services 162,411 Interfund Transfers - Other Revenue 10,111,694 Workers Compensation and 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 - Depreciation Expense - Contingencies - Debt Service - Miscellaneous - Interfund Transfers - EXPENSE TOTALS 17,192,633 Fund 605 - INSURANCE 565,405 Fund 605 - INSURANCE REVENUE TOTALS 17,758,038 EXPENSE TOTALS 17,192,633 Run by Ashley King on 05/04/2016 03:37:15 PM Page 36 of 50 Mar-16 YTD 2015 Actual Transactions Transactions Total 2,368,266 3,343,926 7,106,772 - 50,995 280,000 - - - 74,945 213,349 1,009,930 17 30 319,811 2,443,227 3,608,301 8,716,512 693,170 2,106,716 8,302,220 - - - - - - - - - - - - 693,170 2,106,716 8,302,220 2,443,227 3,608,301 8,716,512 693,170 2,106,716 8,302,220 1,750,058 1,501,585 414,293 Starting Fund Balance 68,529,102 68,529,102 Net Change 4,297,865 1,501,585 Ending Fund Balance 72,826,967 70,030,687 Budget by Organization Report Through 03/31/16 Prior Fiscal Year Activity Included Detail Listing 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 - Debt Service - Miscellaneous - EXPENSE TOTALS 8,163,000 Fund 700 - FIRE PENSION 4,297,865 Fund 700 - FIRE PENSION REVENUE TOTALS 12,460,865 EXPENSE TOTALS 8,163,000 Run by Ashley King on 05/04/2016 03:37:15 PM Page 37 of 50 Mar-16 YTD 2015 Actual Transactions Transactions Total 3,269,427 4,617,436 9,097,160 - 50,995 325,000 - - - 109,693 316,009 1,454,770 23 31 734,309 3,379,143 4,984,472 11,611,239 907,519 2,730,977 10,768,296 - - - - - - - - - 907,519 2,730,977 10,768,296 3,379,143 4,984,472 11,611,239 907,519 2,730,977 10,768,296 2,471,625 2,253,495 842,942 Starting Fund Balance 102,150,249 102,150,249 Net Change 68,529,102 2,253,495 Ending Fund Balance 170,679,351 104,403,744 Budget by Organization Report Through 03/31/16 Prior Fiscal Year Activity Included Detail Listing 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 REVENUE TOTALS 17,430,940 EXPENSE TOTALS 11,047,000 Fund 705 - POLICE PENSION 6,383,940 Run by Ashley King on 05/04/2016 03:37:15 PM Page 38 of 50