Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2018.03 March Monthly Report
To: Wally Bobkiewicz, City Manager From: Hitesh Desai, CFO/City Treasurer Ashley King, Budget & Finance Manager Kate Lewis-Lakin, Senior Management Analyst Subject: March 2018 Monthly Financial Report Date: May 4, 2018 Please find attached the unaudited financial statements as of March 31, 2018. A summary by fund for revenues, expenditures, fund and cash balances is as follows: YTD Revenues YTD Expenses YTD Net Fund Balance Cash Balance 34,953,599 30,145,087 4,808,511 17,933,253 12,288,418 498,379 216,416 281,963 926,462 926,462 207,136 34,833 172,303 184,080 161,487 235 250,000 (249,765) (247,881) 752,119 3,563,294 1,424,221 2,139,073 3,123,845 3,123,448 154,354 - 154,354 158,556 171,238 - - - 308,399 308,399 31 8,864 (8,833) (11,275) 86,136 488,888 614,498 (125,610) 2,248,120 2,083,532 231,598 187,844 43,754 229,247 (84,299) 156,453 - 156,453 (42,341) (42,341) 713 114,893 (114,180) (50,086) (50,073) 9,190 41,672 (32,482) 220,129 220,129 38 - 38 170,209 170,209 29,663 33,877 (4,215) 5,062 5,062 43,749 23,186 20,563 1,497,106 1,501,523 2,965,916 1,776,760 1,189,156 6,451,700 6,526,496 5,661,280 - 5,661,280 5,857,737 5,872,533 319,732 390,430 (70,698) 203,180 178,949 42,721 11,231 31,490 464,256 472,579 26,404 - 26,404 20,395 20,395 28,315 - 28,315 89,508 89,508 113,238 - 113,238 115,444 115,445 1,636,311 1,631,500 4,811 9,452,167 9,986,325 - 146,799 (146,799) 393,882 394,062 99,662 143,684 (44,022) 2,953,679 2,950,142 2,704,493 1,213,050 1,491,443 6,400,845 6,077,091 4,692,397 2,755,346 1,937,051 9,262,038 5,783,305 3,704,013 2,457,849 1,246,164 5,396,091 2,831,969 1,338,646 944,976 393,670 (775,344) (1,434,827) 753,638 673,078 80,560 438,797 (350,682) 333,909 328,203 5,706 1,082,682 855,224 4,370,907 4,613,076 (242,170) (5,590,204) (1,770,279) 69,128,901 50,181,373 18,947,527 68,869,738 60,219,684 605 INSURANCE FUND 520 SOLID WASTE FUND 600 FLEET SERVICES FUND 601 EQUIPMENT REPLACEMENT FUND 505 PARKING SYSTEM FUND 510 WATER FUND 515 SEWER FUND 415 CAPITAL IMPROVEMENTS FUND 416 CROWN CONSTRUCTION FUND 420 SPECIAL ASSESSMENT FUND 350 SPECIAL SERVICE AREA (SSA) #6 187 LIBRARY CAPITAL IMPROVEMENT FD 320 DEBT SERVICE FUND 335 WEST EVANSTON TIF FUND 340 DEMPSTER-DODGE TIF FUND 345 CHICAGO-MAIN TIF 250 AFFORDABLE HOUSING FUND 300 WASHINGTON NATIONAL TIF FUND 330 HOWARD-RIDGE TIF FUND 235 NEIGHBORHOOD IMPROVEMENT 240 HOME FUND 186 LIBRARY DEBT SERVICE FUND 210 SPECIAL SERVICE AREA (SSA) #4 215 CDBG FUND 220 CDBG LOAN FUND 195 NEIGHBORHOOD STABILIZATION FUND 200 MOTOR FUEL TAX FUND 205 EMERGENCY TELEPHONE (E911) FUND 176 HEALTH AND HUMAN SERVICES 180 GOOD NEIGHBOR FUND 185 LIBRARY FUND Fund Fund Description 100 GENERAL FUND 175 GENERAL ASSISTANCE FUND Memorandum Included above are the ending balances as of March 31, 2018 for both unreserved fund and cash balances. Of these two amounts, cash balance is the more meaningful metric since this represents liquid cash and/or invested assets which can be used (or easily sold) to support and fund current operations. While ending fund balance is also an important measurement of the City’s financial health, it usually includes illiquid assets or future cash receipts or disbursements such as receivables (including property t ax) due to the City and accounts payable/accrued expenses. The fund balances included in this financial report are based on unaudited 2017 year - end balances. These may change slightly during the Audit Process, which will be conducted during April 2018. As of March 31, 2018, the General Fund is reporting a net surplus of $4,808,511. The General Fund balance is $17,933,253 with a cash balance of $12,288,418. The attached supplemental charts show the General Fund Revenues at 30.4% of budget and expenses at 26.4%. Fund and cash balances increased significantly in the first quarter due to the first installment of property taxes being received. This is the first of two annual installments. Additionally, the Insurance and Other Chargebacks category shows a high year-to-date expense, as this includes the transfer of property tax pension to the Police and Fire pension funds. Through March 31, 2018, the Good Neighbor Fund is showing a negative fund balance of $247,881. This is because the revenue to this fund from Northwestern University is not received until later in the year. Transfers to other funds from the Good Neighbor Fund are made monthly to cover expenses throughout the year on designated projects. Through March 31, 2018, the Neighborhood Stabilization Fund is showing a negative fund balance of $11,275. This is due to the timing of grant funding revenues. Through March 31, 2018, the E911 Fund is showing negative cash balance of $84,299. This is due to timing of E911 revenues f rom the state and the expenses related to the replacement of Computer Aided Dispatch (CAD) and Police/Fire Records Software. Through March 31, 2018, the SSA #4 Fund is showing a negative fund and cash balance of $42,341. This is due to the timing of payments to the Downtown Evanston group. Through March 31, 2018, the CDBG fund is showing a negative fund balance of $50,086 and a negative cash balance of $50,073. This is due to a delay in reimbursements and will be repaid with draw-downs later in the year. Through March 31, 2018, the Capital Improvements Fund is showing a fund balance of $9,452,167 and a cash balance of $9,986,325. Bond proceeds from the 2017A General Obligation Bonds were received in October, significantly increasing fund and cash balances. January February March April May June July August 2017 Unreserved Fund Balance 15,453,984$ 17,244,431$ 19,450,955$ 2018 Unreserved Fund Balance 16,512,558$ 15,306,742$ 17,933,253$ 2017 Cash Balance 6,338,271$ 6,393,110$ 11,561,044$ 2018 Cash Balance 8,905,448$ 8,120,225$ 12,288,418$ 2017 v 2018 Fund and Cash Balance-- General Fund $- $5,000,000 $10,000,000 $15,000,000 $20,000,000 $25,000,000 2017 Unreserved Fund Balance 2018 Unreserved Fund Balance 2017 Cash Balance 2018 Cash Balance 2018 March YTD 2017 Budget 2018 2018 %Actual 28,849,196 9,231,027 15,591,170 54.0% 28,294,363 49,742,274 4,945,882 11,463,052 23.0% 47,103,324 12,397,400 662,204 2,117,412 17.1% 13,357,911 3,897,500 251,007 862,229 22.1% 3,484,050 10,077,550 703,854 2,146,589 21.3% 8,754,025 7,748,417 618,143 1,854,428 23.9% 8,590,717 778,100 61,516 280,957 36.1% 1,468,393 1,300,217 451,092 632,735 48.7% 1,376,447 50,100 1,580 5,026 10.0% 38,544 REVENUE TOTAL 114,840,754 16,926,306 34,953,599 30.4% 112,467,774 492,806 43,750 119,296 24.2% 498,172 191,784 13,699 34,729 18.1% 251,193 7,540,597 492,567 1,518,360 20.1% 7,621,948 736,346 59,333 161,702 22.0% 772,045 9,075,303 741,843 1,908,134 21.0% 9,314,164 3,614,774 332,400 740,827 20.5% 2,592,984 38,391,099 5,350,603 11,925,751 31.1% 39,067,047 23,934,390 3,677,433 7,669,995 32.0% 24,355,551 3,697,529 243,922 687,062 18.6% 3,071,334 11,955,812 743,246 1,994,044 16.7% 12,479,438 14,607,356 1,083,296 3,385,187 23.2% 13,983,314 EXPENSE TOTAL 114,237,796 12,782,093 30,145,087 26.4% 114,007,190 114,840,754 16,926,306 34,953,599 30.4% 112,467,774 114,237,796 12,782,093 30,145,087 26.4% 114,007,190 602,958 4,144,213 4,808,511 (1,539,417) Other Taxes Licenses, Permits and Fees Fines and Forfeitures March 2018 Financial Report Through 03/31/18 Summary Listing Fund 100 - GENERAL FUND Property Taxes REVENUE TOTALS EXPENSE TOTALS Fund 100 - GENERAL FUND Net Gain (Loss) Charges for Services Interfund Transfers Intergovernmental Revenue Other Revenue Interest Income HEALTH PARKS, REC. AND COMMUNITY SERV. PUBLIC WORKS AGENCY COMMUNITY DEVELOPMENT POLICE FIRE MGMT & SUPPORT Fund 100 - GENERAL FUND Totals CITY COUNCIL CITY CLERK CITY MANAGER'S OFFICE LAW ADMINISTRATIVE SERVICES 2018 March YTD 2017 Budget 2018 2018 %Actual - 600 1,513 100.0% 1,900 6,676,575 630,864 1,586,255 23.8% 6,303,624 4,217,040 347,253 1,041,760 24.7% 4,120,636 12,125 - - 0.0% - 193,316 21,517 66,186 34.2% 253,523 35,070 2,053 8,779 25.0% 62,067 REVENUE TOTAL 11,134,126 1,002,288 2,704,493 24.3% 10,741,750 1,849,028 137,512 367,240 19.9% 1,675,404 3,451,775 70,754 358,436 10.4% 3,167,070 2,450,000 8,254 8,254 0.3% 280,311 319,648 26,637 79,912 25.0% 319,648 - - - 100.0% 2,561,771 11,000 - - 0.0% 4,246 3,070,625 - - 0.0% 267,734 304,000 20,033 39,103 12.9% 267,436 1,440,417 120,035 360,104 25.0% 1,584,683 EXPENSE TOTAL 12,896,493 383,225 1,213,050 9.4% 10,128,302 11,134,126 1,002,288 2,704,493 24.3% 10,741,750 12,896,493 383,225 1,213,050 9.4% 10,128,302 (1,762,367) 619,064 1,491,443 613,448 Fund 505 - PARKING SYSTEM FUND Net Gain Interfund Transfers Fund 505 - PARKING SYSTEM FUND Totals REVENUE TOTALS EXPENSE TOTALS Other Revenue Interest Income Salary and Benefits Services and Supplies Capital Outlay Insurance and Other Chargebacks Depreciation Expense Contingencies Debt Service Miscellaneous Charges for Services Interfund Transfers Intergovernmental Revenue March 2018 Financial Report Through 03/31/18 Summary Listing Fund 505 - PARKING SYSTEM FUND Licenses, Permits and Fees 2018 March YTD 2017 Budget 2018 2018 %Actual 70,000 1,810 4,325 6.2% 86,063 18,267,000 1,634,628 4,646,574 25.4% 17,255,947 27,333,656 8,941 12,343 0.0% 294,812 25,000 16,154 29,155 116.6% 35,784 REVENUE TOTAL 45,695,656 1,661,533 4,692,397 10.3% 17,672,605 5,614,331 418,932 1,158,247 20.6% 5,958,873 4,655,410 151,176 447,006 9.6% 2,528,863 29,346,200 73,466 112,394 0.4% 11,408 468,492 39,041 117,123 25.0% 468,492 - - - 0.0% 2,470,280 1,000 - - 0.0% - 1,960,760 - - 0.0% 717,388 15,000 - - 0.0% (203,530) 3,602,313 306,859 920,577 25.6% 6,327,314 EXPENSE TOTAL 45,663,506 989,473 2,755,347 6.0% 18,279,088 45,695,656 1,661,533 4,692,397 10.3% 17,672,605 45,663,506 989,473 2,755,347 6.0% 18,279,088 32,150 672,060 1,937,049 (606,483) March 2018 Financial Report Through 03/31/18 Summary Listing Fund 510 - WATER FUND Salary and Benefits Services and Supplies Capital Outlay Insurance and Other Chargebacks Depreciation Expense Licenses, Permits and Fees Charges for Services Other Revenue Interest Income Fund 510 - WATER FUND Totals REVENUE TOTALS EXPENSE TOTALS Fund 510 - WATER FUND Net Gain (Loss) Contingencies Debt Service Miscellaneous Interfund Transfers 2018 March YTD 2017 Budget 2018 2018 %Actual 12,589,650 848,028 3,696,976 29.4% 12,477,657 2,104,000 - - 0.0% 14,870 5,000 4,015 7,037 140.7% 16,023 REVENUE TOTAL 14,698,650 852,043 3,704,013 25.2% 12,508,550 1,274,709 100,637 277,730 21.8% 1,313,154 2,558,630 3,528 7,759 0.3% 88,677 2,181,300 10,013 10,013 0.5% 7,676 269,988 22,499 67,497 25.0% 269,988 - - - 0.0% 3,530,787 7,540,066 1,276,838 1,846,931 24.5% 1,143,643 1,500 - - 0.0% 9,265 991,677 82,640 247,919 25.0% 1,141,676 EXPENSE TOTAL 14,817,870 1,496,154 2,457,849 16.6% 7,504,867 14,698,650 852,043 3,704,013 25.2% 12,508,550 14,817,870 1,496,154 2,457,849 16.6% 7,504,867 (119,220) (644,111) 1,246,163 5,003,683 March 2018 Financial Report Through 03/31/18 Summary Listing Fund 515 - SEWER FUND Services and Supplies Capital Outlay Insurance and Other Chargebacks Depreciation Expense Debt Service Charges for Services Other Revenue Interest Income Salary and Benefits EXPENSE TOTALS Fund 515 - SEWER FUND Net Gain (Loss) Miscellaneous Interfund Transfers Fund 515 - SEWER FUND Totals REVENUE TOTALS 2018 March YTD 2017 Budget 2018 2018 %Actual 410,000 260,915 260,915 63.6% - 275,000 14,448 14,448 5.3% 199,513 3,632,394 286,735 879,150 24.2% 3,611,308 705,967 58,831 176,492 25.0% 755,967 238,000 6,333 7,640 3.2% 250,687 REVENUE TOTAL 5,261,361 627,262 1,338,645 25.4% 4,817,475 993,616 68,414 192,507 19.4% 890,220 3,488,676 224,080 670,294 19.2% 3,482,141 275,750 1,434 1,434 0.5% 24,635 21,797 - - 0.0% 1,797 7,500 150 150 2.0% 3,057 322,362 26,864 80,591 25.0% 504,807 EXPENSE TOTAL 5,109,701 320,940 944,976 18.5% 4,906,657 5,261,361 627,262 1,338,645 25.4% 4,817,475 5,109,701 320,940 944,976 18.5% 4,906,657 151,660 306,322 393,670 (89,182) Licenses, Permits and Fees Charges for Services Interfund Transfers March 2018 Financial Report Through 03/31/18 Summary Listing Fund 520 - SOLID WASTE FUND Property Taxes EXPENSE TOTALS Fund 520 - SOLID WASTE FUND Net Gain (Loss) Other Revenue Salary and Benefits Services and Supplies Capital Outlay Debt Service Miscellaneous Interfund Transfers Fund 520 - SOLID WASTE FUND Totals REVENUE TOTALS March YTD 2017 2018 2018 Actuals 9,231,027 15,591,170 28,294,363 4,945,882 11,463,052 47,103,324 662,204 2,117,412 13,357,911 251,007 862,229 3,484,050 703,854 2,146,589 8,754,025 618,143 1,854,428 11,586,943 61,516 280,957 1,468,393 451,092 632,735 1,376,447 - - - - - - - - - 1,580 5,026 38,544 - - - - - - 16,926,306 34,953,599 115,464,000 5,294,202 15,899,550 71,659,904 842,655 1,875,680 13,414,590 3,105 7,878 361,427 5,961,485 10,344,886 20,883,996 - 1,315 124,131 - - - 73 106 4,090 - - - 41,062 97,143 917,815 639,510 1,918,530 6,641,237 12,782,093 30,145,087 114,007,190 16,926,306 34,953,599 115,464,000 12,782,093 30,145,087 114,007,190 4,144,213 4,808,511 1,456,809 Starting Fund Balance 13,124,742 13,124,742 Net Change 602,958 4,808,511 Ending Fund Balance 13,727,700 17,933,253 REVENUE TOTALS 114,840,754 EXPENSE TOTALS 114,237,796 Fund 100 - GENERAL FUND Totals 602,958 EXPENSE TOTALS 114,237,796 Fund 100 - GENERAL FUND Totals 7,704,802 Community Sponsored Organizations 123,886 Depreciation Expense - Contingencies 208,500 Debt Service - Miscellaneous 1,015,317 Interfund Transfers Services and Supplies 12,367,791 Capital Outlay 354,000 Insurance and Other Chargebacks 22,287,563 REVENUE TOTALS 114,840,754 EXPENSE Salary and Benefits 70,175,937 - Workers Compensation and Liability - Insurance - Library Revenue - Interest Income 50,100 Special Assessment - Reappropriation of Surplus Interfund Transfers 7,748,417 Intergovernmental Revenue 778,100 Other Revenue 1,300,217 Licenses, Permits and Fees 12,397,400 Fines and Forfeitures 3,897,500 Charges for Services 10,077,550 Fund 100 - GENERAL FUND REVENUE Property Taxes 28,849,196 Other Taxes 49,742,274 Budget by Organization Report Through 03/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 05/04/2018 09:09:15 AM Page 1 of 35 March YTD 2017 2018 2018 Actuals 291,033 492,274 933,020 - - - - - - - - - - - - - - - - - - 997 5,785 33,019 - - - - - - - - - 138 320 1,548 - - - - - - 292,168 498,379 967,586 30,933 84,569 324,972 41,913 131,857 579,392 - - - - - - - - - - - - - - - - - - - (10) 5,110 - - - 72,845 216,416 909,475 292,168 498,379 967,586 72,845 216,416 909,475 219,323 281,963 58,111 Starting Fund Balance 644,499 644,499 Net Change (312,421) 281,963 Ending Fund Balance 332,078 926,462 REVENUE TOTALS 953,500 EXPENSE TOTALS 1,265,921 Fund 175 - GENERAL ASSISTANCE FUND (312,421) EXPENSE TOTALS 1,265,921 Fund 175 - GENERAL ASSISTANCE FUND Debt Service - Miscellaneous 7,000 Interfund Transfers - Community Sponsored Organizations - Depreciation Expense - Contingencies - Services and Supplies 858,200 Capital Outlay - Insurance and Other Chargebacks - REVENUE TOTALS 953,500 EXPENSE Salary and Benefits 400,721 Interest Income 1,000 Special Assessment - Reappropriation of Surplus - Workers Compensation and Liability - Insurance - Library Revenue - Interfund Transfers - Intergovernmental Revenue - Other Revenue 27,500 Licenses, Permits and Fees - Fines and Forfeitures - Charges for Services - Fund 175 - GENERAL ASSISTANCE FUND REVENUE Property Taxes 925,000 Other Taxes - Budget by Organization Report Through 03/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 04/26/2018 12:09:29 PM Page 2 of 35 March YTD 2017 2018 2018 Actuals - - - 69,039 207,118 859,153 - - - - - - - 18 14 69,039 207,136 859,167 - - 22,593 - - 121 - - - 11,611 34,833 918,074 - - - 11,611 34,833 940,789 69,039 207,136 859,167 11,611 34,833 940,789 57,428 172,303 (81,622) Starting Fund Balance 11,777 11,777 Net Change (30,682) 172,303 Ending Fund Balance (18,905) 184,080 Fund 176 - HEALTH AND HUMAN (30,682) Fund 176 - HEALTH AND HUMAN REVENUE TOTALS 828,471 EXPENSE TOTALS 859,153 Miscellaneous - EXPENSE TOTALS 859,153 Services and Supplies 859,153 Capital Outlay - Community Sponsored Organizations - REVENUE TOTALS 828,471 EXPENSE Salary and Benefits - Intergovernmental Revenue - Other Revenue - Interest Income - Fund 176 - HEALTH AND HUMAN SERVICES REVENUE Charges for Services - Interfund Transfers 828,471 Budget by Organization Report Through 03/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 04/26/2018 12:09:29 PM Page 3 of 35 March YTD 2017 2018 2018 Actuals - - 1,000,000 96 235 1,884 96 235 1,001,884 83,333 250,000 1,000,000 83,333 250,000 1,000,000 96 235 1,001,884 83,333 250,000 1,000,000 (83,237) (249,765) 1,884 Starting Fund Balance 1,884 1,884 Net Change - (249,765) Ending Fund Balance 1,884 (247,881) REVENUE TOTALS 1,000,000 EXPENSE TOTALS 1,000,000 Fund 180 - GOOD NEIGHBOR FUND Totals - EXPENSE TOTALS 1,000,000 Fund 180 - GOOD NEIGHBOR FUND Totals REVENUE TOTALS 1,000,000 EXPENSE Interfund Transfers 1,000,000 Fund 180 - GOOD NEIGHBOR FUND REVENUE Other Revenue 1,000,000 Interest Income - Budget by Organization Report Through 03/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 04/26/2018 12:09:29 PM Page 4 of 35 March YTD 2017 2018 2018 Actuals 1,999,469 3,372,861 6,370,507 - - - 22,481 31,905 122,862 53 80 338 5,833 17,500 190,200 15,249 36,558 79,926 6,370 15,314 70,707 14,392 88,153 345,788 517 922 5,169 2,064,364 3,563,294 7,185,496 390,839 1,068,144 4,739,145 85,144 264,339 1,701,159 - - 9,904 - - - - - - - - - - - - - - 22 30,579 91,737 343,618 506,562 1,424,221 6,793,848 2,064,364 3,563,294 7,185,496 506,562 1,424,221 6,793,848 1,557,802 2,139,073 391,648 Starting Fund Balance 984,772 984,772 Net Change 221,912 2,139,073 Ending Fund Balance 1,206,684 3,123,845 REVENUE TOTALS 7,693,209 EXPENSE TOTALS 7,471,297 Fund 185 - LIBRARY FUND Totals 221,912 EXPENSE TOTALS 7,471,297 Fund 185 - LIBRARY FUND Totals Debt Service - Miscellaneous - Interfund Transfers 366,949 Insurance and Other Chargebacks - Depreciation Expense - Contingencies - Salary and Benefits 5,089,260 Services and Supplies 2,004,688 Capital Outlay 10,400 Interest Income 5,400 REVENUE TOTALS 7,693,209 EXPENSE Intergovernmental Revenue 152,418 Other Revenue 130,000 Library Revenue 324,620 Fines and Forfeitures 130,000 Charges for Services - Interfund Transfers 265,771 Fund 185 - LIBRARY FUND REVENUE Property Taxes 6,685,000 Other Taxes - Budget by Organization Report Through 03/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 04/26/2018 12:09:29 PM Page 5 of 35 March YTD 2017 2018 2018 Actuals 91,207 154,354 338,897 - - 778,745 - - 7 91,207 154,354 1,117,649 - - 8,587 - - - - - 1,134,570 - - - - - 112 - - 1,143,269 91,207 154,354 1,117,649 - - 1,143,269 91,207 154,354 (25,619) Starting Fund Balance 4,202 4,202 Net Change 12,386 154,354 Ending Fund Balance 16,588 158,556 EXPENSE TOTALS 333,404 Fund 186 - LIBRARY DEBT SERVICE FUND 12,386 Fund 186 - LIBRARY DEBT SERVICE FUND REVENUE TOTALS 345,790 Miscellaneous - Interfund Transfers - EXPENSE TOTALS 333,404 Services and Supplies - Capital Outlay - Debt Service 333,404 Interest Income - REVENUE TOTALS 345,790 EXPENSE Fund 186 - LIBRARY DEBT SERVICE FUND REVENUE Property Taxes 345,790 Other Revenue - Budget by Organization Report Through 03/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 04/26/2018 12:09:29 PM Page 6 of 35 March YTD 2017 2018 2018 Actuals - - - - - 1,431,106 - - - - - 1,431,106 - - 30,790 - - 1,091,917 - - - - - - - - 1,122,708 - - 1,431,106 - - 1,122,708 - - 308,399 Starting Fund Balance 308,399 308,399 Net Change - - Ending Fund Balance 308,399 308,399 Fund 187 - LIBRARY CAPITAL - Fund 187 - LIBRARY CAPITAL REVENUE TOTALS 10,095,000 EXPENSE TOTALS 10,095,000 Interfund Transfers - EXPENSE TOTALS 10,095,000 Services and Supplies - Capital Outlay 10,095,000 Debt Service - Interest Income - REVENUE TOTALS 10,095,000 EXPENSE Fund 187 - LIBRARY CAPITAL IMPROVEMENT FD REVENUE Property Taxes - Other Revenue 10,095,000 Budget by Organization Report Through 03/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 04/26/2018 12:09:29 PM Page 7 of 35 March YTD 2017 2018 2018 Actuals - - - - - 37,641 - - - 12 31 - 12 31 37,641 2,132 5,840 26,454 - 1,860 1,860 - - 2,642 - - (233) - - - - - 2,400 388 1,163 4,518 2,520 8,864 37,641 12 31 37,641 2,520 8,864 37,641 (2,509) (8,833) - Starting Fund Balance (2,442) (2,442) Net Change 326 (8,833) Ending Fund Balance (2,116) (11,275) EXPENSE TOTALS 94,821 Fund 195 - NEIGHBORHOOD 326 Fund 195 - NEIGHBORHOOD REVENUE TOTALS 95,147 Miscellaneous 50,000 Interfund Transfers 4,654 EXPENSE TOTALS 94,821 Capital Outlay 7,000 Insurance and Other Chargebacks - Debt Service - EXPENSE Salary and Benefits 28,067 Services and Supplies 5,100 Other Revenue - Interest Income - REVENUE TOTALS 95,147 Fund 195 - NEIGHBORHOOD STABILIZATION FUND REVENUE Licenses, Permits and Fees - Intergovernmental Revenue 95,147 Budget by Organization Report Through 03/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 04/26/2018 12:09:29 PM Page 8 of 35 March YTD 2017 2018 2018 Actuals 145,987 479,083 1,899,884 - - - 3,247 9,805 18,158 - - - 149,235 488,888 1,918,041 - - - 125,000 375,000 - - - - - - - - - - 79,833 239,498 957,990 204,833 614,498 957,990 149,235 488,888 1,918,041 204,833 614,498 957,990 (55,598) (125,610) 960,051 Starting Fund Balance 2,373,729 2,373,729 Net Change (535,990) (125,610) Ending Fund Balance 1,837,739 2,248,119 Fund 200 - MOTOR FUEL TAX FUND Totals (535,990) Fund 200 - MOTOR FUEL TAX FUND Totals REVENUE TOTALS 1,922,000 EXPENSE TOTALS 2,457,990 Interfund Transfers 957,990 EXPENSE TOTALS 2,457,990 Contingencies - Debt Service - Miscellaneous - EXPENSE Services and Supplies - Capital Outlay 1,500,000 Interest Income 12,000 Reappropriation of Surplus - REVENUE TOTALS 1,922,000 Fund 200 - MOTOR FUEL TAX FUND REVENUE Intergovernmental Revenue 1,910,000 Other Revenue - Budget by Organization Report Through 03/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 04/26/2018 12:09:29 PM Page 9 of 35 March YTD 2017 2018 2018 Actuals 77,351 229,200 978,523 - - - 863 863 - 93 1,536 7,178 78,307 231,598 985,701 47,724 131,355 585,510 27,011 33,786 239,161 - - 51,670 1,454 4,362 17,448 - - - - - - - - - - - - 6,114 18,341 72,977 82,303 187,844 966,766 78,307 231,598 985,701 82,303 187,844 966,766 (3,997) 43,754 18,935 Starting Fund Balance 185,493 185,493 Net Change 8,262 43,754 Ending Fund Balance 193,755 229,247 Fund 205 - EMERGENCY TELEPHONE 8,262 Fund 205 - EMERGENCY TELEPHONE REVENUE TOTALS 1,051,700 EXPENSE TOTALS 1,043,438 Interfund Transfers 73,366 EXPENSE TOTALS 1,043,438 Contingencies - Debt Service - Miscellaneous - Capital Outlay 55,000 Insurance and Other Chargebacks 17,448 Community Sponsored Organizations - EXPENSE Salary and Benefits 615,224 Services and Supplies 282,400 Other Revenue - Interest Income 1,000 REVENUE TOTALS 1,051,700 Fund 205 - EMERGENCY TELEPHONE (E911) FUND REVENUE Other Taxes 1,050,700 Intergovernmental Revenue - Budget by Organization Report Through 03/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 04/26/2018 12:09:29 PM Page 10 of 35 March YTD 2017 2018 2018 Actuals 138,407 156,436 322,477 17 17 5 138,424 156,453 322,482 - - 329,000 - - - - - - - - 329,000 138,424 156,453 322,482 - - 329,000 138,424 156,453 (6,518) Starting Fund Balance (198,794) (198,794) Net Change - 156,453 Ending Fund Balance (198,794) (42,341) EXPENSE TOTALS 370,000 Fund 210 - SPECIAL SERVICE AREA (SSA) - Fund 210 - SPECIAL SERVICE AREA (SSA) REVENUE TOTALS 370,000 Debt Service - Miscellaneous - EXPENSE TOTALS 370,000 REVENUE TOTALS 370,000 EXPENSE Services and Supplies 370,000 Fund 210 - SPECIAL SERVICE AREA (SSA) #4 REVENUE Property Taxes 370,000 Interest Income - Budget by Organization Report Through 03/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 04/26/2018 12:09:29 PM Page 11 of 35 March YTD 2017 2018 2018 Actuals - - - - - - - - 1,906,708 - 713 262 - - - - 713 1,906,970 32,675 89,526 431,440 393 3,321 3,797 10,895 10,895 645,289 1,454 4,362 392,279 - - 318,412 - - - - - - 4,551 4,551 95,606 746 2,239 20,145 50,713 114,893 1,906,970 - 713 1,906,970 50,713 114,893 1,906,970 (50,713) (114,180) - Starting Fund Balance 64,094 64,094 Net Change (109,388) (114,180) Ending Fund Balance (45,294) (50,086) EXPENSE TOTALS 2,439,512 Fund 215 - CDBG FUND Totals (109,388) Fund 215 - CDBG FUND Totals REVENUE TOTALS 2,330,124 Miscellaneous 569,970 Interfund Transfers 949,656 EXPENSE TOTALS 2,439,512 Community Sponsored Organizations 175,500 Contingencies - Debt Service - Services and Supplies 220,840 Capital Outlay - Insurance and Other Chargebacks 20,648 REVENUE TOTALS 2,330,124 EXPENSE Salary and Benefits 502,898 Intergovernmental Revenue 2,330,124 Other Revenue - Interest Income - Fund 215 - CDBG FUND REVENUE Charges for Services - Interfund Transfers - Budget by Organization Report Through 03/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 04/26/2018 12:09:29 PM Page 12 of 35 March YTD 2017 2018 2018 Actuals - - - 3,115 9,010 51,369 38 180 3,391 3,153 9,190 54,760 - - - 30,279 41,672 13,070 - - - - - - 30,279 41,672 13,070 3,153 9,190 54,760 30,279 41,672 13,070 (27,127) (32,482) 41,690 Starting Fund Balance 252,611 252,611 Net Change - (32,482) Ending Fund Balance 252,611 220,129 Fund 220 - CDBG LOAN FUND Totals - Fund 220 - CDBG LOAN FUND Totals REVENUE TOTALS 293,000 EXPENSE TOTALS 293,000 Interfund Transfers - EXPENSE TOTALS 293,000 Salary and Benefits - Services and Supplies 293,000 Miscellaneous - Interest Income - REVENUE TOTALS 293,000 EXPENSE Fund 220 - CDBG LOAN FUND REVENUE Intergovernmental Revenue - Other Revenue 293,000 Budget by Organization Report Through 03/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 04/26/2018 12:09:29 PM Page 13 of 35 March YTD 2017 2018 2018 Actuals - - - - - - 16 38 256 16 38 256 - - - - - - - - - - - - - - - - - - 16 38 256 - - - 16 38 256 Starting Fund Balance 170,171 170,171 Net Change (100,000) 38 Ending Fund Balance 70,171 170,209 EXPENSE TOTALS 100,000 Fund 235 - NEIGHBORHOOD (100,000) Fund 235 - NEIGHBORHOOD REVENUE TOTALS - Miscellaneous 100,000 Interfund Transfers - EXPENSE TOTALS 100,000 Services and Supplies - Capital Outlay - Debt Service - Interest Income - REVENUE TOTALS - EXPENSE Fund 235 - NEIGHBORHOOD IMPROVEMENT REVENUE Other Taxes - Interfund Transfers - Budget by Organization Report Through 03/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 04/26/2018 12:09:29 PM Page 14 of 35 March YTD 2017 2018 2018 Actuals 22,799 22,799 227,450 2,282 6,846 21,820 1 18 5,685 25,082 29,663 254,955 3,574 9,784 43,994 - 23,889 231,806 - - - 68 205 (27,871) - - - - - - - - 126 - - - 3,642 33,877 248,055 25,082 29,663 254,955 3,642 33,877 248,055 21,439 (4,215) 6,900 Starting Fund Balance 9,277 9,277 Net Change 615 (4,215) Ending Fund Balance 9,892 5,062 EXPENSE TOTALS 588,321 Fund 240 - HOME FUND Totals 615 Fund 240 - HOME FUND Totals REVENUE TOTALS 588,936 Miscellaneous 500 Interfund Transfers - EXPENSE TOTALS 588,321 Insurance and Other Chargebacks 820 Community Sponsored Organizations - Debt Service - Salary and Benefits 46,801 Services and Supplies 540,200 Capital Outlay - Interest Income - REVENUE TOTALS 588,936 EXPENSE Fund 240 - HOME FUND REVENUE Intergovernmental Revenue 588,936 Other Revenue - Budget by Organization Report Through 03/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 04/26/2018 12:09:29 PM Page 15 of 35 March YTD 2017 2018 2018 Actuals 10,000 10,000 97,000 - - - - - - 417 32,500 333,056 318 1,249 5,623 10,735 43,749 435,678 7,411 19,888 44,432 - - 209,772 - - - - - 11,532 2,398 2,398 8,927 - - - - 900 85,660 - - - 9,809 23,186 360,323 10,735 43,749 435,678 9,809 23,186 360,323 926 20,563 75,355 Starting Fund Balance 1,476,543 1,476,543 Net Change (38,470) 20,563 Ending Fund Balance 1,438,073 1,497,106 Fund 250 - AFFORDABLE HOUSING FUND (38,470) Fund 250 - AFFORDABLE HOUSING FUND REVENUE TOTALS 450,830 EXPENSE TOTALS 489,300 Interfund Transfers - EXPENSE TOTALS 489,300 Community Sponsored Organizations 70,000 Debt Service - Miscellaneous 43,000 Services and Supplies 279,500 Capital Outlay - Insurance and Other Chargebacks - REVENUE TOTALS 450,830 EXPENSE Salary and Benefits 96,800 Intergovernmental Revenue - Other Revenue 400,600 Interest Income 230 Fund 250 - AFFORDABLE HOUSING FUND REVENUE Other Taxes 50,000 Interfund Transfers - Budget by Organization Report Through 03/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 04/26/2018 12:09:29 PM Page 16 of 35 March YTD 2017 2018 2018 Actuals 1,265,707 2,959,303 5,249,949 - - - - - - - - - 2,355 6,613 45,924 1,268,061 2,965,916 5,295,873 - - - - - 2,007 - - - - - - - - 98,672 592,253 1,776,760 5,557,325 592,253 1,776,760 5,658,005 1,268,061 2,965,916 5,295,873 592,253 1,776,760 5,658,005 675,808 1,189,156 (362,132) Starting Fund Balance 5,262,544 5,262,544 Net Change (3,437,040) 1,189,156 Ending Fund Balance 1,825,504 6,451,700 EXPENSE TOTALS 9,207,040 Fund 300 - WASHINGTON NATIONAL TIF (3,437,040) Fund 300 - WASHINGTON NATIONAL TIF REVENUE TOTALS 5,770,000 Miscellaneous 100,000 Interfund Transfers 7,107,040 EXPENSE TOTALS 9,207,040 Services and Supplies 2,000,000 Capital Outlay - Debt Service - REVENUE TOTALS 5,770,000 EXPENSE Salary and Benefits - Interfund Transfers - Other Revenue - Interest Income 20,000 Fund 300 - WASHINGTON NATIONAL TIF FUND REVENUE Property Taxes 5,750,000 Other Taxes - Budget by Organization Report Through 03/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 04/26/2018 12:09:29 PM Page 17 of 35 March YTD 2017 2018 2018 Actuals 2,858,055 4,764,121 10,797,411 288,930 866,789 2,850,236 7,219 21,656 83,293 - - 8,883,103 3,558 8,714 36,782 3,157,760 5,661,280 22,650,825 - - 100,625 - - 23,099,797 - - (57) - - - - - 23,200,365 3,157,760 5,661,280 22,650,825 - - 23,200,365 3,157,760 5,661,280 (549,540) Starting Fund Balance 196,457 196,457 Net Change 274,759 5,661,280 Ending Fund Balance 471,216 5,857,737 REVENUE TOTALS 14,572,016 EXPENSE TOTALS 14,297,257 Fund 320 - DEBT SERVICE FUND Totals 274,759 EXPENSE TOTALS 14,297,257 Fund 320 - DEBT SERVICE FUND Totals Debt Service 14,177,257 Miscellaneous - Interfund Transfers - REVENUE TOTALS 14,572,016 EXPENSE Services and Supplies 120,000 Intergovernmental Revenue 83,292 Other Revenue - Interest Income 1,500 Fund 320 - DEBT SERVICE FUND REVENUE Property Taxes 10,879,993 Interfund Transfers 3,607,231 Budget by Organization Report Through 03/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 04/26/2018 12:09:29 PM Page 18 of 35 March YTD 2017 2018 2018 Actuals 297,942 318,714 583,827 1,013 1,013 32,000 5 5 22 298,960 319,732 615,848 126 126 307,391 125,000 375,000 - - - - - - - 97 304 995 - - - 5,000 15,000 60,000 130,224 390,430 368,386 298,960 319,732 615,848 130,224 390,430 368,386 168,736 (70,698) 247,462 Starting Fund Balance 273,878 273,878 Net Change (296,100) (70,698) Ending Fund Balance (22,222) 203,180 Fund 330 - HOWARD-RIDGE TIF FUND (296,100) Fund 330 - HOWARD-RIDGE TIF FUND REVENUE TOTALS 4,385,400 EXPENSE TOTALS 4,681,500 Interfund Transfers 60,000 EXPENSE TOTALS 4,681,500 Community Sponsored Organizations - Debt Service 960,000 Miscellaneous - Services and Supplies 461,500 Capital Outlay 3,200,000 Insurance and Other Chargebacks - Interest Income 400 REVENUE TOTALS 4,385,400 EXPENSE Fund 330 - HOWARD-RIDGE TIF FUND REVENUE Property Taxes 605,000 Other Revenue 3,780,000 Budget by Organization Report Through 03/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 04/26/2018 12:09:29 PM Page 19 of 35 March YTD 2017 2018 2018 Actuals 32,021 39,290 43,503 1,028 2,057 12,339 625 1,374 3,898 33,674 42,721 59,741 - - 2,007 - - - - - - - - - 1,198 3,731 12,227 - - - 2,500 7,500 30,000 3,698 11,231 44,235 33,674 42,721 59,741 3,698 11,231 44,235 29,976 31,490 15,506 Starting Fund Balance 432,766 432,766 Net Change (39,850) 31,490 Ending Fund Balance 392,916 464,256 Fund 335 - WEST EVANSTON TIF FUND (39,850) Fund 335 - WEST EVANSTON TIF FUND REVENUE TOTALS 150 EXPENSE TOTALS 40,000 Interfund Transfers 30,000 EXPENSE TOTALS 40,000 Contingencies - Debt Service 10,000 Miscellaneous - Services and Supplies - Capital Outlay - Insurance and Other Chargebacks - Interest Income 150 REVENUE TOTALS 150 EXPENSE Fund 335 - WEST EVANSTON TIF FUND REVENUE Property Taxes - Other Revenue - Budget by Organization Report Through 03/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 04/26/2018 12:09:29 PM Page 20 of 35 March YTD 2017 2018 2018 Actuals - 26,401 48,001 - - 2,067,512 3 3 1 3 26,404 2,115,514 - - 38,588 - - 2,000,000 - - 53,521 - - 2,092,108 3 26,404 2,115,514 - - 2,092,108 3 26,404 23,406 Starting Fund Balance (6,009) (6,009) Net Change 202,334 26,404 Ending Fund Balance 196,325 20,395 REVENUE TOTALS 275,000 EXPENSE TOTALS 72,666 Fund 340 - DEMPSTER-DODGE TIF FUND 202,334 EXPENSE TOTALS 72,666 Fund 340 - DEMPSTER-DODGE TIF FUND Services and Supplies - Capital Outlay - Debt Service 72,666 Interest Income - REVENUE TOTALS 275,000 EXPENSE Fund 340 - DEMPSTER-DODGE TIF FUND REVENUE Property Taxes 275,000 Other Revenue - Budget by Organization Report Through 03/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 04/26/2018 12:09:29 PM Page 21 of 35 March YTD 2017 2018 2018 Actuals 10,312 28,311 75,430 - - 3,520,189 2 3 9 10,315 28,315 3,595,628 - - 58,113 - - 3,580,000 - - 31,398 - - 3,669,511 10,315 28,315 3,595,628 - - 3,669,511 10,315 28,315 (73,884) Starting Fund Balance 61,193 61,193 Net Change 316,001 28,315 Ending Fund Balance 377,194 89,508 REVENUE TOTALS 425,000 EXPENSE TOTALS 108,999 Fund 345 - CHICAGO-MAIN TIF Totals 316,001 EXPENSE TOTALS 108,999 Fund 345 - CHICAGO-MAIN TIF Totals Services and Supplies - Capital Outlay - Debt Service 108,999 Interest Income - REVENUE TOTALS 425,000 EXPENSE Fund 345 - CHICAGO-MAIN TIF REVENUE Property Taxes 425,000 Other Revenue - Budget by Organization Report Through 03/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 04/26/2018 12:09:29 PM Page 22 of 35 March YTD 2017 2018 2018 Actuals 77,657 113,228 215,245 9 10 21 77,666 113,238 215,266 - - 213,354 - - 78,000 - - 291,354 77,666 113,238 215,266 - - 291,354 77,666 113,238 (76,088) Starting Fund Balance 2,206 2,206 Net Change - 113,238 Ending Fund Balance 2,206 115,444 Fund 350 - SPECIAL SERVICE AREA (SSA) - Fund 350 - SPECIAL SERVICE AREA (SSA) REVENUE TOTALS 221,500 EXPENSE TOTALS 221,500 Interfund Transfers - EXPENSE TOTALS 221,500 REVENUE TOTALS 221,500 EXPENSE Services and Supplies 221,500 Fund 350 - SPECIAL SERVICE AREA (SSA) #6 REVENUE Property Taxes 221,000 Interest Income 500 Budget by Organization Report Through 03/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 04/26/2018 12:09:29 PM Page 23 of 35 March YTD 2017 2018 2018 Actuals - - 359,706 - - 33,339 536,667 1,610,000 787,177 - - 530,812 - - 11,246,149 10,788 26,311 56,607 547,455 1,636,311 13,013,790 51,047 131,243 5,392 77,523 93,477 1,672,608 774,896 1,281,780 13,582,482 - - - - - - 41,667 125,000 500,000 945,133 1,631,500 15,760,481 547,455 1,636,311 13,013,790 945,133 1,631,500 15,760,481 (397,678) 4,811 (2,746,691) Starting Fund Balance 9,447,356 9,447,356 Net Change (7,655,527) 4,811 Ending Fund Balance 1,791,829 9,452,167 REVENUE TOTALS 22,642,000 EXPENSE TOTALS 30,297,527 Fund 415 - CAPITAL IMPROVEMENTS FUND Totals (7,655,527) EXPENSE TOTALS 30,297,527 Fund 415 - CAPITAL IMPROVEMENTS FUND Totals Debt Service - Miscellaneous - Interfund Transfers 500,000 Salary and Benefits 585,527 Services and Supplies - Capital Outlay 29,212,000 Interest Income - REVENUE TOTALS 22,642,000 EXPENSE Interfund Transfers 6,450,000 Intergovernmental Revenue 4,190,000 Other Revenue 12,002,000 Fund 415 - CAPITAL IMPROVEMENTS FUND REVENUE Licenses, Permits and Fees - Charges for Services - Budget by Organization Report Through 03/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 04/26/2018 12:09:29 PM Page 24 of 35 March YTD 2017 2018 2018 Actuals - - 649,512 - - 900,000 - - - - - 1,549,512 - 146,799 638,727 - - 369,924 - - - - 146,799 1,008,651 - - 1,549,512 - 146,799 1,008,651 - (146,799) 540,861 Starting Fund Balance 540,681 540,681 Net Change 1,866,000 (146,799) Ending Fund Balance 2,406,681 393,882 REVENUE TOTALS 11,500,000 EXPENSE TOTALS 9,634,000 Fund 416 - CROWN CONSTRUCTION FUND 1,866,000 EXPENSE TOTALS 9,634,000 Fund 416 - CROWN CONSTRUCTION FUND Services and Supplies 1,634,000 Capital Outlay 8,000,000 Interfund Transfers - Interest Income - REVENUE TOTALS 11,500,000 EXPENSE Fund 416 - CROWN CONSTRUCTION FUND REVENUE Interfund Transfers - Other Revenue 11,500,000 Budget by Organization Report Through 03/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 04/26/2018 12:09:29 PM Page 25 of 35 March YTD 2017 2018 2018 Actuals - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 6,806 14,388 31,207 32,246 85,275 237,012 - - - 39,051 99,662 268,219 5,558 15,327 694 - - 5,613 - - - - - - - - - - - - 42,786 128,357 263,427 48,344 143,684 269,734 39,051 99,662 268,219 48,344 143,684 269,734 (9,292) (44,022) (1,516) Starting Fund Balance 2,997,700 2,997,700 Net Change (123,850) (44,022) Ending Fund Balance 2,873,850 2,953,678 REVENUE TOTALS 461,367 EXPENSE TOTALS 585,217 Fund 420 - SPECIAL ASSESSMENT FUND (123,850) EXPENSE TOTALS 585,217 Fund 420 - SPECIAL ASSESSMENT FUND Debt Service - Miscellaneous - Interfund Transfers 513,427 Services and Supplies - Capital Outlay - Insurance and Other Chargebacks - REVENUE TOTALS 461,367 EXPENSE Salary and Benefits 71,790 Interest Income 31,200 Special Assessment 180,167 Reappropriation of Surplus - Workers Compensation and Liability - Insurance - Library Revenue - Interfund Transfers - Intergovernmental Revenue - Other Revenue 250,000 Licenses, Permits and Fees - Fines and Forfeitures - Charges for Services - Fund 420 - SPECIAL ASSESSMENT FUND REVENUE Property Taxes - Other Taxes - Budget by Organization Report Through 03/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 04/26/2018 12:09:29 PM Page 26 of 35 March YTD 2017 2018 2018 Actuals - - - - - - 600 1,513 1,900 - - - 630,864 1,586,255 6,303,624 347,253 1,041,760 4,120,636 - - - 21,517 66,186 253,523 2,053 8,779 62,067 1,002,288 2,704,493 10,741,750 137,512 367,240 1,675,404 70,754 358,436 3,167,070 8,254 8,254 280,311 26,637 79,912 319,648 - - - - - 2,561,771 - - 4,246 - - 267,734 20,033 39,103 267,436 120,035 360,104 1,584,683 383,225 1,213,050 10,128,302 1,002,288 2,704,493 10,741,750 383,225 1,213,050 10,128,302 619,064 1,491,443 613,448 Starting Fund Balance 4,909,402 4,909,402 Net Change (1,762,367) 1,491,443 Ending Fund Balance 3,147,035 6,400,845 Fund 505 - PARKING SYSTEM FUND Totals (1,762,367) Fund 505 - PARKING SYSTEM FUND Totals REVENUE TOTALS 11,134,126 EXPENSE TOTALS 12,896,493 Interfund Transfers 1,440,417 EXPENSE TOTALS 12,896,493 Contingencies 11,000 Debt Service 3,070,625 Miscellaneous 304,000 Insurance and Other Chargebacks 319,648 Community Sponsored Organizations - Depreciation Expense - Salary and Benefits 1,849,028 Services and Supplies 3,451,775 Capital Outlay 2,450,000 Interest Income 35,070 REVENUE TOTALS 11,134,126 EXPENSE Interfund Transfers 4,217,040 Intergovernmental Revenue 12,125 Other Revenue 193,316 Licenses, Permits and Fees - Fines and Forfeitures - Charges for Services 6,676,575 Fund 505 - PARKING SYSTEM FUND REVENUE Property Taxes - Other Taxes - Budget by Organization Report Through 03/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 04/26/2018 12:09:29 PM Page 27 of 35 March YTD 2017 2018 2018 Actuals - - - 1,810 4,325 86,063 1,634,628 4,646,574 17,255,947 - - - - - - 8,941 12,343 294,812 16,154 29,155 35,784 1,661,533 4,692,397 17,672,605 418,932 1,158,247 5,958,873 151,176 447,006 2,528,863 73,466 112,394 11,408 39,041 117,123 468,492 - - - - - 2,470,280 - - - - - 717,388 - - (203,530) 306,859 920,577 6,327,314 989,473 2,755,347 18,279,088 1,661,533 4,692,397 17,672,605 672,060 1,937,049 (1,619,478) Starting Fund Balance 7,324,987 7,324,987 Net Change 32,150 1,937,049 Ending Fund Balance 7,357,137 9,262,036 989,473 2,755,347 22% EXPENSE TOTALS 45,663,506 Fund 510 - WATER FUND Totals 32,150 Fund 510 - WATER FUND Totals REVENUE TOTALS 45,695,656 Miscellaneous 15,000 Interfund Transfers 3,602,313 EXPENSE TOTALS 45,663,506 Depreciation Expense - Contingencies 1,000 Debt Service 1,960,760 Capital Outlay 29,346,200 Insurance and Other Chargebacks 468,492 Community Sponsored Organizations - EXPENSE Salary and Benefits 5,614,331 Services and Supplies 4,655,410 Other Revenue 27,333,656 Interest Income 25,000 REVENUE TOTALS 45,695,656 Charges for Services 18,267,000 Interfund Transfers - Intergovernmental Revenue - Fund 510 - WATER FUND REVENUE Other Taxes - Licenses, Permits and Fees 70,000 Budget by Organization Report Through 03/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 04/26/2018 12:09:29 PM Page 28 of 35 March YTD 2017 2018 2018 Actuals 848,028 3,696,976 12,477,657 - - - - - 14,870 4,015 7,037 16,023 852,043 3,704,013 12,508,550 100,637 277,730 1,313,154 3,528 7,759 88,677 10,013 10,013 7,676 22,499 67,497 269,988 - - 3,530,787 - - - 1,276,838 1,846,931 1,143,643 - - 9,265 82,640 247,919 1,141,676 1,496,154 2,457,849 7,504,867 852,043 3,704,013 12,508,550 1,496,154 2,457,849 7,504,867 (644,111) 1,246,163 5,003,683 Starting Fund Balance 4,149,927 4,149,927 Net Change (119,220) 1,246,163 Ending Fund Balance 4,030,707 5,396,090 Fund 515 - SEWER FUND Totals (119,220) Fund 515 - SEWER FUND Totals REVENUE TOTALS 14,698,650 EXPENSE TOTALS 14,817,870 Interfund Transfers 991,677 EXPENSE TOTALS 14,817,870 Contingencies - Debt Service 7,540,066 Miscellaneous 1,500 Capital Outlay 2,181,300 Insurance and Other Chargebacks 269,988 Depreciation Expense - EXPENSE Salary and Benefits 1,274,709 Services and Supplies 2,558,630 Other Revenue 2,104,000 Interest Income 5,000 REVENUE TOTALS 14,698,650 Fund 515 - SEWER FUND REVENUE Charges for Services 12,589,650 Interfund Transfers - Budget by Organization Report Through 03/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 04/26/2018 12:09:29 PM Page 29 of 35 March YTD 2017 2018 2018 Actuals 260,915 260,915 - 14,448 14,448 199,513 286,735 879,150 3,611,308 58,831 176,492 755,967 - - - 6,333 7,640 250,687 - - - 627,262 1,338,645 4,817,475 68,414 192,507 890,220 224,080 670,294 3,482,141 1,434 1,434 24,635 - - - - - - - - - - - - - - 1,797 150 150 3,057 26,864 80,591 504,807 320,940 944,976 4,906,657 627,262 1,338,645 4,817,475 320,940 944,976 4,906,657 306,322 393,670 (89,182) Starting Fund Balance (1,169,015) (1,169,015) Net Change 151,660 393,670 Ending Fund Balance (1,017,355) (775,345) EXPENSE TOTALS 5,109,701 Fund 520 - SOLID WASTE FUND Totals 151,660 Fund 520 - SOLID WASTE FUND Totals REVENUE TOTALS 5,261,361 Miscellaneous 7,500 Interfund Transfers 322,362 EXPENSE TOTALS 5,109,701 Depreciation Expense - Contingencies - Debt Service 21,797 Capital Outlay 275,750 Insurance and Other Chargebacks - Community Sponsored Organizations - EXPENSE Salary and Benefits 993,616 Services and Supplies 3,488,676 Other Revenue 238,000 Interest Income - REVENUE TOTALS 5,261,361 Charges for Services 3,632,394 Interfund Transfers 705,967 Intergovernmental Revenue - Fund 520 - SOLID WASTE FUND REVENUE Property Taxes 410,000 Licenses, Permits and Fees 275,000 Budget by Organization Report Through 03/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 04/26/2018 12:09:29 PM Page 30 of 35 March YTD 2017 2018 2018 Actuals 249,053 747,160 2,478,435 - - - - - - 1,512 6,454 19,016 - 24 339 250,565 753,638 2,497,791 80,279 226,969 1,154,569 194,421 437,748 1,736,789 - - - - - - - - - - - - - - - - - - 2,787 8,360 27,833 277,486 673,078 2,919,191 250,565 753,638 2,497,791 277,486 673,078 2,919,191 (26,921) 80,560 (421,401) Starting Fund Balance 358,236 358,236 Net Change (192,655) 80,560 Ending Fund Balance 165,581 438,796 EXPENSE TOTALS 3,333,871 Fund 600 - FLEET SERVICES FUND Totals (192,655) Fund 600 - FLEET SERVICES FUND Totals REVENUE TOTALS 3,141,216 Miscellaneous - Interfund Transfers 33,442 EXPENSE TOTALS 3,333,871 Depreciation Expense - Contingencies 450 Debt Service - Services and Supplies 2,230,057 Capital Outlay - Insurance and Other Chargebacks - REVENUE TOTALS 3,141,216 EXPENSE Salary and Benefits 1,069,922 Intergovernmental Revenue - Other Revenue 81,781 Interest Income 1,000 Fund 600 - FLEET SERVICES FUND REVENUE Charges for Services 3,058,435 Interfund Transfers - Budget by Organization Report Through 03/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 04/26/2018 12:09:29 PM Page 31 of 35 March YTD 2017 2018 2018 Actuals 111,228 333,683 1,400,057 - - - - - 88,015 91 226 2,128 111,319 333,909 1,490,200 927 2,782 74,539 212,558 325,421 - - - 1,780,829 - - - 213,485 328,203 1,855,367 111,319 333,909 1,490,200 213,485 328,203 1,855,367 (102,167) 5,706 (365,167) Starting Fund Balance 1,076,977 1,076,977 Net Change (20,147) 5,706 Ending Fund Balance 1,056,830 1,082,683 EXPENSE TOTALS 1,597,977 Fund 601 - EQUIPMENT REPLACEMENT (20,147) Fund 601 - EQUIPMENT REPLACEMENT REVENUE TOTALS 1,577,830 Depreciation Expense - Miscellaneous - EXPENSE TOTALS 1,597,977 EXPENSE Services and Supplies 75,000 Capital Outlay 1,522,977 Other Revenue 210,217 Interest Income - REVENUE TOTALS 1,577,830 Fund 601 - EQUIPMENT REPLACEMENT FUND REVENUE Charges for Services 1,367,613 Interfund Transfers - Budget by Organization Report Through 03/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 04/26/2018 12:09:29 PM Page 32 of 35 March YTD 2017 2018 2018 Actuals 13,534 45,884 162,411 - - 2,300,000 - - - 875,128 2,399,776 10,926,377 170,180 511,769 1,032,678 568,597 1,413,128 5,611,626 141 350 382 1,627,580 4,370,907 20,033,473 61,830 175,694 606,021 33,121 201,227 3,594,432 - - - 1,455,813 4,233,747 17,164,869 - - - - - - - - - - - - - - - 803 2,408 9,632 1,551,566 4,613,076 21,374,954 1,627,580 4,370,907 20,033,473 1,551,566 4,613,076 21,374,954 76,013 (242,170) (1,341,481) Starting Fund Balance (5,348,035) (5,348,035) Net Change 653,342 (242,170) Ending Fund Balance (4,694,693) (5,590,205) EXPENSE TOTALS 18,439,931 Fund 605 - INSURANCE FUND Totals 653,342 Fund 605 - INSURANCE FUND Totals REVENUE TOTALS 19,093,273 Miscellaneous - Interfund Transfers 9,632 EXPENSE TOTALS 18,439,931 Depreciation Expense - Contingencies - Debt Service - Capital Outlay - Insurance and Other Chargebacks 15,315,824 Community Sponsored Organizations - EXPENSE Salary and Benefits 729,027 Services and Supplies 2,385,448 Insurance 5,811,177 Interest Income 1,000 REVENUE TOTALS 19,093,273 Intergovernmental Revenue - Other Revenue 10,867,028 Workers Compensation and Liability 2,196,415 Fund 605 - INSURANCE FUND REVENUE Charges for Services 162,411 Interfund Transfers 55,242 Budget by Organization Report Through 03/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 04/26/2018 12:09:29 PM Page 33 of 35 March YTD 2017 2018 2018 Actuals - - - - - - - - - (1,130,784) 2,711,474 15,218,533 221,835 499,101 2,072,811 (908,949) 3,210,576 17,291,343 752,807 2,247,061 8,682,009 - - - - - - - - - 3,922 32,744 136,256 756,729 2,279,804 8,818,265 (908,949) 3,210,576 17,291,343 756,729 2,279,804 8,818,265 (1,665,678) 930,771 8,473,079 Starting Fund Balance 79,101,435 79,101,435 Net Change 4,989,947 930,771 Ending Fund Balance 84,091,382 80,032,206 Fund 700 - FIRE PENSION FUND Totals 4,989,947 Fund 700 - FIRE PENSION FUND Totals REVENUE TOTALS 13,784,947 EXPENSE TOTALS 8,795,000 Miscellaneous - EXPENSE TOTALS 8,795,000 Services and Supplies - Community Sponsored Organizations - Debt Service - REVENUE TOTALS 13,784,947 EXPENSE Salary and Benefits 8,795,000 Interfund Transfers 10,000 Other Revenue 9,394,947 Interest Income 4,100,000 Fund 700 - FIRE PENSION FUND REVENUE Property Taxes - Other Taxes 280,000 Budget by Organization Report Through 03/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 04/26/2018 12:09:29 PM Page 34 of 35 March YTD 2017 2018 2018 Actuals - - - - - - - - - 1,957,487 3,812,385 24,497,048 298,059 602,789 2,830,019 2,255,546 4,415,175 27,327,068 996,903 2,968,069 11,624,574 - - - - - - - 60,238 264,371 996,903 3,028,307 11,888,945 2,255,546 4,415,175 27,327,068 996,903 3,028,307 11,888,945 1,258,643 1,386,867 15,438,122 Starting Fund Balance 121,645,511 121,645,511 Net Change 6,194,704 1,386,867 Ending Fund Balance 127,840,215 123,032,378 REVENUE TOTALS 18,719,704 EXPENSE TOTALS 12,525,000 Fund 705 - POLICE PENSION FUND Totals 6,194,704 EXPENSE TOTALS 12,525,000 Fund 705 - POLICE PENSION FUND Totals Services and Supplies - Debt Service - Miscellaneous 270,000 REVENUE TOTALS 18,719,704 EXPENSE Salary and Benefits 12,255,000 Interfund Transfers 57,000 Other Revenue 12,162,704 Interest Income 6,500,000 Fund 705 - POLICE PENSION FUND REVENUE Property Taxes - Other Taxes - Budget by Organization Report Through 03/31/18 Prior Fiscal Year Activity 2018 Classification Budget Run by Kate LewisLakin on 04/26/2018 12:09:29 PM Page 35 of 35