HomeMy WebLinkAbout2018.11 November Monthly Report
To: Wally Bobkiewicz, City Manager
From: Hitesh Desai, CFO/City Treasurer
Kate Lewis-Lakin, Senior Management Analyst
Subject: November 2018 Monthly Financial Report
Date: December 17, 2018
Please find attached the unaudited financial statements as of November 30, 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
105,058,988 104,475,304 583,684 13,799,783 9,825,856
934,443 883,493 50,950 695,449 695,508
782,227 706,916 75,311 64,496 76,440
1,002,667 916,972 85,695 87,579 87,579
7,540,414 6,320,478 1,219,936 2,262,240 2,204,330
333,896 63,311 270,585 274,674 274,674
2,157,728 1,296,849 860,879 1,169,278 1,169,278
45,794 31,446 14,348 14,348 100,888
1,785,886 2,253,158 (467,272) 1,906,458 1,739,531
1,189,910 826,258 363,652 545,648 235,775
341,959 277,500 64,459 (134,335) (134,335)
785,595 1,347,806 (562,211) (498,104) (497,650)
116,073 124,886 (8,812) 243,800 244,459
966 145 821 170,992 170,992
262,254 259,732 2,522 11,799 11,799
149,973 285,853 (135,880) 1,340,664 1,352,225
5,747,009 6,306,876 (559,867) 4,702,677 4,781,764
21,197,466 9,115,596 12,081,870 12,323,651 12,399,520
4,150,404 2,007,502 2,142,902 2,390,280 2,392,717
236,500 47,563 188,937 621,703 630,044
136,937 75,797 61,139 55,130 55,298
222,258 109,254 113,003 174,196 174,364
115,276 - 115,276 117,483 117,482
16,466,167 11,935,187 4,530,979 13,289,452 13,479,856
27,001,460 4,635,749 22,365,711 22,906,572 22,906,702
467,916 842,897 (374,981) 2,622,719 2,619,183
9,181,241 7,041,716 2,139,525 6,850,226 7,144,914
20,890,986 17,491,874 3,399,112 9,961,907 8,107,408
13,088,091 11,847,641 1,240,450 5,278,205 4,155,242
4,733,648 4,531,010 202,638 (859,328) (1,165,885)
2,758,376 2,966,658 (208,282) 133,061 (554,286)
1,267,519 1,050,454 217,065 1,066,584 1,069,582
16,596,398 20,747,268 (4,150,870) (8,489,375) (4,903,690)
Grand Total 266,746,421 220,823,148 45,923,274 95,099,912 90,967,564
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
340 DEMPSTER-DODGE TIF FUND
345 CHICAGO-MAIN TIF
350 SPECIAL SERVICE AREA (SSA) #6
300 WASHINGTON NATIONAL TIF
330 HOWARD-RIDGE TIF FUND
335 WEST EVANSTON TIF FUND
320 DEBT SERVICE FUND
240 HOME FUND
186 LIBRARY DEBT SERVICE FUND
250 AFFORDABLE HOUSING FUND
187 LIBRARY CAPITAL IMPROVEMENT
215 CDBG FUND
220 CDBG LOAN FUND
235 NEIGHBORHOOD IMPROVEMENT
200 MOTOR FUEL TAX FUND
205 EMERGENCY TELEPHONE (E911)
210 SPECIAL SERVICE AREA (SSA) #4
180 GOOD NEIGHBOR FUND
185 LIBRARY FUND
195 NEIGHBORHOOD STABILIZATION
Fund Fund Description
100 GENERAL FUND
176 HEALTH AND HUMAN SERVICES
175 GENERAL ASSISTANCE FUND
Memorandum
Included above are the ending balances as of November 30, 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
tax) due to the City and accounts payable/accrued expenses.
As of November 30, 2018, the General Fund is reporting a net surplus of $583,684.
The fund balance in the General Fund is $13,799,783 with a cash balance of
$9,825,856. The attached financials show the General Fund revenues at 91.5% of
budget and expenses also at 91.5% of budget. Fund and cash balances were highest
during summer primarily because of the receipt of the second installment of property
taxes. To date, the General Fund has received 97.6% of property tax revenue for the
year.
Through November 30, 2018, the SSA #4 Fund is showing a negative fund and cash
balance of $134,335.
Through November 30, 2018, the CDBG Fund is showing a negative fund balance of
$498,104 and negative cash balance of $497,650 . This is due to a delay in
reimbursements and will be recovered with future draw downs.
Through November 30, 2018, the Capital Fund is showing a fund balance of
$13,289,452 and a cash balance of $13,479,856. The fund continues to spend down
balances from the 2017A General Obligation Bonds received in October 2017 and from
the 2018B General Obligation Bonds received in August 2018.
Through November 30, 2018, the Crown Construction fund is showing a fund and cash
balance of $22,906,572. Proceeds from the 2018A General Obligation Bonds were
received in August 2018.
Through November 30, 2018, the Water Fund appears low on revenue and expenses.
This is because the clearwell treated water storage project that was budgeted in 2018
was delayed to 2019. This delay causes Capital Outlay and Other Revenue (IEPA loan
proceeds) to appear far below budget in the Water Fund. This project is budgeted again
in 2019.
The W ater Fund revenues reflect payment from the Village of Skokie at the rate of
$0.78 per 1000 gallons against the billed rate of $2.06 per 1000 gallons. This issue is
currently being challenged in the court.
Through November 30, 2018, the Solid Waste Fund has a negative fund balance of
$859,328 and a negative cash balance of $1,165,885. The Solid Waste Fund received
property tax revenue for the first time in 2018, and has to date received the full
$410,000 budgeted in property taxes. This amount will increase to $820,000 in 2019.
Through November 30, 2018, the Insurance Fund is showing a negative fund balance of
$8,489,375 and a negative cash balance of $4,903,690. Fund balance is lower than
cash balance due to accrued liabilities for pending litigation.
If there are any questions on the attached report, please contact me by phone at (847)
448-8082 or by email: hdesai@cityofevanston.org. Detailed fund summary reports can
be found at: http://www.cityofevanston.org/city-budget/financial-reports/.
CERTIFICATION OF ATTACHED FINANCIAL REPORTS
As required per Illinois Statute 65 ILCS 5/3.1 -35-45 I, Hitesh Desai, Treasurer of the
City of Evanston, hereby affirm that I have reviewed the November 30, 2018 year-to-
date financial information and reports which to the best of my knowledge appear
accurate and complete.
January February March April May June July August September October November
2017 Unreserved
Fund Balance 15,453,984$ 17,244,431$ 19,450,955$ 18,292,843$ 17,839,404$ 14,612,957$ 13,603,487$ 16,910,096$ 14,723,355$ 14,354,436$ 13,093,607$
2018 Unreserved
Fund Balance 16,512,558$ 15,306,742$ 17,933,253$ 17,384,626$ 18,479,429$ 15,488,721$ 17,279,434$ 18,345,522$ 16,923,253$ 16,225,727$ 13,799,783$
2017 Cash Balance 6,338,271$ 6,393,110$ 11,561,044$ 10,901,398$ 10,376,936$ 6,169,276$ 7,179,518$ 10,652,102$ 8,595,629$ 8,439,222$ 7,340,223$
2018 Cash Balance 8,905,448$ 8,120,225$ 12,288,418$ 11,184,339$ 12,226,888$ 9,006,016$ 10,816,697$ 12,252,460$ 10,763,842$ 11,463,410$ 9,825,856$
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
November YTD 2017
2018 2018 %Actuals
96,159 28,153,565 97.6% 28,294,363
3,635,703 44,570,339 89.6% 46,951,377
1,633,894 9,769,590 78.8% 13,357,911
401,307 3,563,482 91.8% 3,467,694
757,784 9,420,075 93.5% 8,754,025
618,143 6,799,569 87.8% 11,586,943
84,838 1,220,133 153.8% 1,234,749
112,887 1,480,645 113.9% 1,858,106
11,190 81,590 162.9% 38,544
7,351,903 105,058,988 91.5% 115,543,711
CITY COUNCIL 48,682 491,748 99.8% 498,172
CITY CLERK 23,587 196,023 102.2% 251,193
CITY MANAGER'S OFFICE 584,050 6,110,741 81.0% 7,539,496
LAW 70,536 595,800 80.9% 772,045
ADMINISTRATIVE SERVICES 907,026 8,146,040 89.8% 9,314,164
COMMUNITY DEVELOPMENT 404,722 3,106,502 85.9% 2,592,984
POLICE 3,295,350 36,233,379 94.4% 39,067,047
FIRE MGMT & SUPPORT 1,719,003 23,072,492 96.4% 24,355,551
HEALTH & HUMAN SERV. 303,427 2,869,432 77.6% 3,071,334
PARKS, REC. AND COMMUNITY SERV. 1,065,280 11,660,362 97.5% 12,479,438
PUBLIC WORKS AGENCY 1,282,935 11,992,783 82.1% 13,983,314
9,704,600 104,475,304 91.5% 113,924,739
7,351,903 105,058,988 91.5% 115,543,711
9,704,600 104,475,304 91.5% 113,924,739
(2,352,696) 583,684 1,618,972
Budget by Organization Report
Through 11/30/18
Prior Fiscal Year Activity Included
Summary Listing2018
Classification Budget
Property Taxes
Fund 100 - GENERAL FUND
REVENUE
28,849,196
49,742,274 Other Taxes
12,397,400
3,882,500
10,077,550
Licenses, Permits and Fees
Fines and Forfeitures
Charges for Services
7,748,417
793,100
1,300,217
Interfund Transfers
Intergovernmental Revenue
Other Revenue
50,100
114,840,754
Interest Income
REVENUE TOTALS
EXPENSE
492,806
191,784
7,540,597
736,346
9,075,303
3,614,774
14,607,356
38,391,099
23,934,390
3,697,529
EXPENSE TOTALS 114,237,796
11,955,812
Fund 100 - GENERAL FUND Totals
REVENUE TOTALS 114,840,754
EXPENSE TOTALS 114,237,796
Fund 100 - GENERAL FUND Totals 602,958
November YTD 2017
2018 2018 %Actual
- 2,398 0.0% 1,900
350,996 5,749,163 86.1% 6,303,624
- 3,037,704 72.0% 4,120,636
- - 0.0% -
18,122 296,574 153.4% 253,523
10,860 95,402 272.0% 62,067
379,978 9,181,241 82.5% 10,741,750
194,056 1,598,931 86.5% 1,675,404
425,889 3,393,281 98.3% 3,172,070
- 200,976 8.2% 280,311
26,637 293,011 91.7% 319,648
- - 0.0% 2,561,771
- - 0.0% 4,246
- 53,131 1.7% 267,734
28,554 182,004 59.9% 267,436
120,035 1,320,382 91.7% 1,584,683
795,171 7,041,716 54.6% 10,133,302
379,978 9,181,241 82.5% 10,741,750
795,171 7,041,716 54.6% 10,133,302
(415,193) 2,139,525 608,448
Starting Fund Balance 4,710,701 4,710,701
Net Change (1,762,367) 2,139,525
Ending Fund Balance 2,948,334 6,850,226
Budget by Organization Report
Through 11/30/18
2018
Classification Budget
Fund 505 - PARKING SYSTEM FUND
REVENUE
193,316
Licenses, Permits and Fees -
Charges for Services 6,676,575
Interest Income 35,070
REVENUE TOTALS 11,134,126
EXPENSE
Interfund Transfers 4,217,040
Intergovernmental Revenue 12,125
Other Revenue
Salary and Benefits 1,849,028
Services and Supplies 3,451,775
Capital Outlay 2,450,000
304,000
Insurance and Other Chargebacks 319,648
Depreciation Expense -
Interfund Transfers 1,440,417
EXPENSE TOTALS 12,896,493
Contingencies 11,000
Debt Service 3,070,625
Miscellaneous
Fund 505 - PARKING SYSTEM FUND (1,762,367)
Fund 505 - PARKING SYSTEM FUND
REVENUE TOTALS 11,134,126
EXPENSE TOTALS 12,896,493
November YTD 2017
2018 2018 %Actual
4,040 47,278 67.5% 86,063
1,048,125 14,766,568 80.8% 17,255,947
67,854 5,859,532 21.4% 294,812
34,736 217,607 870.4% 35,784
1,154,754 20,890,986 45.7% 17,672,605
618,598 5,021,917 89.4% 5,958,873
367,086 3,127,210 67.2% 2,528,863
169,591 4,953,418 16.9% (192,124)
39,041 429,451 91.7% 468,492
- - 0.0% 2,470,280
- - 0.0% -
85,306 584,427 29.8% 717,388
- - 0.0% 2
306,859 3,375,450 93.7% 6,327,314
1,586,480 17,491,874 38.3% 18,279,088
1,154,754 20,890,986 45.7% 17,672,605
1,586,480 17,491,874 38.3% 18,279,088
(431,726) 3,399,112 (606,483)
Starting Fund Balance 6,562,795 6,562,795
Net Change 32,150 3,399,112
Ending Fund Balance 6,594,945 9,961,907
Budget by Organization Report
Through 11/30/18
2018
Classification Budget
Fund 510 - WATER FUND
REVENUE
Licenses, Permits and Fees 70,000
45,695,656
Charges for Services 18,267,000
EXPENSE
Salary and Benefits 5,614,331
Services and Supplies 4,655,410
Other Revenue 27,333,656
Interest Income 25,000
REVENUE TOTALS
Capital Outlay 29,346,200
Insurance and Other Chargebacks 468,492
Depreciation Expense -
Contingencies 1,000
Debt Service 1,960,760
Miscellaneous 15,000
Interfund Transfers 3,602,313
EXPENSE TOTALS 45,663,506
EXPENSE TOTALS 45,663,506
Fund 510 - WATER FUND Totals 32,150
Fund 510 - WATER FUND Totals
REVENUE TOTALS 45,695,656
November YTD 2017
2018 2018 %Actual
390,079 11,173,238 88.7% 12,477,657
- 1,868,230 88.8% 14,870
12,699 46,623 932.5% 16,023
402,779 13,088,091 89.0% 12,508,550
144,438 1,196,677 93.9% 1,313,154
258,178 583,841 22.8% 88,677
- 729,666 33.5% 16,941
22,499 247,489 91.7% 269,988
- - 0.0% 3,530,787
1,024,321 8,180,701 108.5% 1,143,643
115 230 15.3% -
82,640 909,037 91.7% 1,141,676
1,532,191 11,847,641 80.0% 7,504,867
402,779 13,088,091 89.0% 12,508,550
1,532,191 11,847,641 80.0% 7,504,867
(1,129,412) 1,240,450 5,003,683
Starting Fund Balance 4,037,755 4,037,755
Net Change (119,220) 1,240,450
Ending Fund Balance 3,918,535 5,278,205
Budget by Organization Report
Through 11/30/18
2018
Classification Budget
14,698,650
Fund 515 - SEWER FUND
REVENUE
Charges for Services 12,589,650
EXPENSE
Salary and Benefits 1,274,709
Services and Supplies 2,558,630
Other Revenue 2,104,000
Interest Income 5,000
REVENUE TOTALS
1,500
Capital Outlay 2,181,300
Insurance and Other Chargebacks 269,988
Depreciation Expense -
Interfund Transfers 991,677
EXPENSE TOTALS 14,817,870
Debt Service 7,540,066
Miscellaneous
Fund 515 - SEWER FUND Totals (119,220)
Fund 515 - SEWER FUND Totals
REVENUE TOTALS 14,698,650
EXPENSE TOTALS 14,817,870
November YTD 2017
2018 2018 %Actual
- 410,000 100.0% -
14,063 213,086 56.8% 329,039
454,355 3,371,718 90.3% 3,699,121
58,831 647,136 91.7% 755,967
2,091 91,709 241.3% 33,348
529,340 4,733,648 90.0% 4,817,475
113,887 883,679 88.9% 890,220
320,593 3,167,051 90.8% 3,482,141
2,436 178,829 64.9% 24,635
- 665 3.1% 1,797
1,600 5,288 70.5% 3,057
26,864 295,499 91.7% 504,807
465,380 4,531,010 88.7% 4,906,657
529,340 4,733,648 90.0% 4,817,475
465,380 4,531,010 88.7% 4,906,657
63,960 202,638 (89,182)
Starting Fund Balance (1,061,966) (1,061,966)
Net Change 151,660 202,638
Ending Fund Balance (910,306) (859,328)
Budget by Organization Report
Through 11/30/18
2018
Classification Budget
Fund 520 - SOLID WASTE FUND
REVENUE
Property Taxes 410,000
Licenses, Permits and Fees 375,000
5,261,361
Charges for Services 3,732,394
Interfund Transfers 705,967
EXPENSE
Salary and Benefits 993,616
Services and Supplies 3,488,676
Other Revenue 38,000
REVENUE TOTALS
Capital Outlay 275,750
Debt Service 21,797
Miscellaneous 7,500
Interfund Transfers 322,362
EXPENSE TOTALS 5,109,701
EXPENSE TOTALS 5,109,701
Fund 520 - SOLID WASTE FUND Totals 151,660
Fund 520 - SOLID WASTE FUND Totals
REVENUE TOTALS 5,261,361
November YTD 2017
2018 2018 Actuals
96,159 28,153,565 28,294,363
3,635,703 44,570,339 46,951,377
1,633,894 9,769,590 13,357,911
401,307 3,563,482 3,467,694
757,784 9,420,075 8,754,025
618,143 6,799,569 11,586,943
84,838 1,220,133 1,234,749
112,887 1,480,645 1,858,106
11,190 81,590 38,544
7,351,903 105,058,988 115,543,711
7,952,651 64,460,143 71,659,904
686,112 10,278,168 13,414,590
22,378 277,020 361,427
300,955 21,629,859 20,883,996
47,598 116,976 124,131
- 106 4,090
55,395 678,421 835,363
639,510 7,034,610 6,641,237
9,704,600 104,475,304 113,924,739
7,351,903 105,058,988 115,543,711
9,704,600 104,475,304 113,924,739
(2,352,696) 583,684 1,618,972
Starting Fund Balance 13,216,099 13,216,099
Net Change 602,958 583,684
Ending Fund Balance 13,819,057 13,799,783
Budget by Organization Report
Through 11/30/18
2018
Classification Budget
Fund 100 - GENERAL FUND
REVENUE
Property Taxes 28,849,196
Other Taxes 49,742,274
Licenses, Permits and Fees 12,397,400
Fines and Forfeitures 3,882,500
Charges for Services 10,077,550
Interest Income 50,100
Interfund Transfers 7,748,417
Intergovernmental Revenue 793,100
Other Revenue 1,300,217
REVENUE TOTALS 114,840,754
EXPENSE
Salary and Benefits 70,175,937
Services and Supplies 12,367,791
Capital Outlay 354,000
Insurance and Other Chargebacks 22,287,563
Miscellaneous 1,015,317
Interfund Transfers 7,704,802
Community Sponsored Organizations 123,886
Contingencies 208,500
EXPENSE TOTALS 114,237,796
Fund 100 - GENERAL FUND Totals
REVENUE TOTALS 114,840,754
EXPENSE TOTALS 114,237,796
Fund 100 - GENERAL FUND Totals 602,958
Run by Kate LewisLakin on 12/17/2018 09:01:42 AM Page 1 of 35
November YTD 2017
2018 2018 Actuals
3,320 912,605 933,020
- 12,990 33,019
1,500 8,848 1,548
4,820 934,443 967,586
45,714 358,925 324,972
55,705 520,400 579,392
59 4,169 5,110
101,478 883,493 909,475
4,820 934,443 967,586
101,478 883,493 909,475
(96,658) 50,950 58,111
Starting Fund Balance 644,499 644,499
Net Change (312,421) 50,950
Ending Fund Balance 332,078 695,449
Budget by Organization
Report
Through 11/30/18
2018
Classification Budget
Interest Income 1,000
Other Revenue 27,500
Fund 175 - GENERAL ASSISTANCE FUND
REVENUE
Property Taxes 925,000
Miscellaneous 7,000
Services and Supplies 858,200
REVENUE TOTALS 953,500
EXPENSE
Salary and Benefits 400,721
EXPENSE TOTALS 1,265,921
Fund 175 - GENERAL ASSISTANCE FUND
REVENUE TOTALS 953,500
EXPENSE TOTALS 1,265,921
Fund 175 - GENERAL ASSISTANCE FUND (312,421)
Run by Kate LewisLakin on 12/17/2018 09:01:42 AM Page 2 of 35
November YTD 2017
2018 2018 Actuals
69,039 759,432 859,153
- 22,593 -
- 202 14
69,039 782,227 859,167
- - 22,593
- 43,229 121
24,889 656,187 918,074
- 7,500 -
24,889 706,916 940,789
69,039 782,227 859,167
24,889 706,916 940,789
44,150 75,311 (81,622)
Starting Fund Balance (10,815) (10,815)
Net Change (30,682) 75,311
Ending Fund Balance (41,497) 64,496
Budget by Organization
Report
Through 11/30/18
2018
Classification Budget
Other Revenue -
Interest Income -
Fund 176 - HEALTH AND HUMAN SERVICES
REVENUE
Interfund Transfers 828,471
Services and Supplies 859,153
Community Sponsored Organizations -
REVENUE TOTALS 828,471
EXPENSE
Salary and Benefits -
Miscellaneous -
EXPENSE TOTALS 859,153
Fund 176 - HEALTH AND HUMAN (30,682)
Fund 176 - HEALTH AND HUMAN
REVENUE TOTALS 828,471
EXPENSE TOTALS 859,153
Run by Kate LewisLakin on 12/17/2018 09:01:42 AM Page 3 of 35
November YTD 2017
2018 2018 Actuals
1,000,000 1,000,000 1,000,000
101 2,667 1,884
1,000,101 1,002,667 1,001,884
19 305 -
83,333 916,667 1,000,000
83,352 916,972 1,000,000
1,000,101 1,002,667 1,001,884
83,352 916,972 1,000,000
916,748 85,695 1,884
Starting Fund Balance 1,884 1,884
Net Change - 85,695
Ending Fund Balance 1,884 87,579
Budget by Organization
Report
Through 11/30/18
2018
Classification Budget
Fund 180 - GOOD NEIGHBOR FUND
REVENUE
Other Revenue 1,000,000
Interest Income -
Interfund Transfers 1,000,000
EXPENSE TOTALS 1,000,000
REVENUE TOTALS 1,000,000
EXPENSE
Services and Supplies -
EXPENSE TOTALS 1,000,000
Fund 180 - GOOD NEIGHBOR FUND Totals -
Fund 180 - GOOD NEIGHBOR FUND Totals
REVENUE TOTALS 1,000,000
Run by Kate LewisLakin on 12/17/2018 09:01:42 AM Page 4 of 35
November YTD 2017
2018 2018 Actuals
22,400 6,588,997 6,370,507
7,381 96,484 122,862
49 332 338
201,604 259,938 190,200
- 210,258 74,206
77,112 131,216 70,807
25,703 211,762 362,608
8,706 41,426 5,169
342,954 7,540,414 7,196,696
576,101 4,495,016 4,739,145
160,485 1,487,913 1,712,359
687 1,179 9,904
- - 22
30,579 336,370 343,618
767,852 6,320,478 6,805,048
342,954 7,540,414 7,196,696
767,852 6,320,478 6,805,048
(424,898) 1,219,936 391,648
Starting Fund Balance 1,042,304 1,042,304
Net Change 216,912 1,219,936
Ending Fund Balance 1,259,216 2,262,240
Fund 185 - LIBRARY FUND
REVENUE
Property Taxes 6,685,000
Budget by Organization
Report
Through 11/30/18
2018
Classification Budget
Fines and Forfeitures 130,000
Charges for Services -
Interfund Transfers 265,771
Intergovernmental Revenue 152,418
Other Revenue 130,000
Library Revenue 324,620
Interest Income 5,400
REVENUE TOTALS 7,693,209
EXPENSE
Miscellaneous -
Interfund Transfers 366,949
Salary and Benefits 5,074,260
Services and Supplies 2,024,688
Capital Outlay 10,400
EXPENSE TOTALS 7,476,297
Fund 185 - LIBRARY FUND Totals
REVENUE TOTALS 7,693,209
EXPENSE TOTALS 7,476,297
Fund 185 - LIBRARY FUND Totals 216,912
Run by Kate LewisLakin on 12/17/2018 09:01:42 AM Page 5 of 35
November YTD 2017
2018 2018 Actual
- 333,896 338,897
- - 778,745
- - 7
- 333,896 1,117,649
- 8,349 8,587
- 54,962 1,134,570
- - 112
- 63,311 1,143,269
- 333,896 1,117,649
- 63,311 1,143,269
- 270,585 (25,619)
Starting Fund Balance 4,089 4,089
Net Change 12,386 270,585
Ending Fund Balance 16,475 274,674
EXPENSE TOTALS 333,404
EXPENSE TOTALS 333,404
Fund 186 - LIBRARY DEBT SERVICE FUND 12,386
Fund 186 - LIBRARY DEBT SERVICE FUND
REVENUE TOTALS 345,790
Services and Supplies -
Debt Service 333,404
Interfund Transfers -
Interest Income -
REVENUE TOTALS 345,790
EXPENSE
-
Budget by Organization Report
Through 11/30/18
2018
Classification Budget
Fund 186 - LIBRARY DEBT SERVICE FUND
REVENUE
Property Taxes 345,790
Other Revenue
Run by Kate LewisLakin on 12/17/2018 09:01:42 AM Page 6 of 35
November YTD 2017
2018 2018 Actuals
- 2,157,728 1,431,106
- 2,157,728 1,431,106
- 22,350 30,790
- 24,498 1,091,917
- 1,250,000 -
- 1,296,849 1,122,708
- 2,157,728 1,431,106
- 1,296,849 1,122,708
- 860,879 308,399
Starting Fund Balance 308,399 308,399
Net Change - 860,879
Ending Fund Balance 308,399 1,169,278
Fund 187 - LIBRARY CAPITAL IMPROVEMENT FD
REVENUE
Other Revenue 10,095,000
Budget by Organization
Report
Through 11/30/18
2018
Classification Budget
Services and Supplies -
Capital Outlay 10,095,000
REVENUE TOTALS 10,095,000
EXPENSE
Interfund Transfers -
EXPENSE TOTALS 10,095,000
Fund 187 - LIBRARY CAPITAL -
Fund 187 - LIBRARY CAPITAL
REVENUE TOTALS 10,095,000
EXPENSE TOTALS 10,095,000
Run by Kate LewisLakin on 12/17/2018 09:01:42 AM Page 7 of 35
November YTD 2017
2018 2018 Actuals
12,135 44,890 37,641
164 903 -
12,299 45,794 37,641
3,041 25,361 26,454
5 1,885 1,860
- 7,008 2,642
(3,889) (9,259) (233)
60 2,184 2,400
388 4,266 4,518
(396) 31,446 37,641
12,299 45,794 37,641
(396) 31,446 37,641
12,695 14,348 -
Starting Fund Balance - -
Net Change 326 14,348
Ending Fund Balance 326 14,348
Budget by Organization
Report
Through 11/30/18
2018
Classification Budget
Interest Income -
REVENUE TOTALS 95,147
Fund 195 - NEIGHBORHOOD STABILIZATION FUND
REVENUE
Intergovernmental Revenue 95,147
Capital Outlay 7,000
Insurance and Other Chargebacks -
EXPENSE
Salary and Benefits 28,067
Services and Supplies 5,100
Miscellaneous 50,000
Interfund Transfers 4,654
EXPENSE TOTALS 94,821
EXPENSE TOTALS 94,821
Fund 195 - NEIGHBORHOOD 326
Fund 195 - NEIGHBORHOOD
REVENUE TOTALS 95,147
Run by Kate LewisLakin on 12/17/2018 09:01:42 AM Page 8 of 35
November YTD 2017
2018 2018 Actuals
178,452 1,741,313 1,899,884
2,598 44,573 18,158
181,050 1,785,886 1,918,041
125,000 1,375,000 -
79,833 878,158 957,990
204,833 2,253,158 957,990
181,050 1,785,886 1,918,041
204,833 2,253,158 957,990
(23,782) (467,272) 960,051
Starting Fund Balance 2,373,730 2,373,730
Net Change (535,990) (467,272)
Ending Fund Balance 1,837,740 1,906,458
Fund 200 - MOTOR FUEL TAX FUND
REVENUE
Intergovernmental Revenue 1,910,000
Budget by Organization
Report
Through 11/30/18
2018
Classification Budget
EXPENSE
Capital Outlay 1,500,000
Interest Income 12,000
REVENUE TOTALS 1,922,000
Interfund Transfers 957,990
EXPENSE TOTALS 2,457,990
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
Run by Kate LewisLakin on 12/17/2018 09:01:42 AM Page 9 of 35
November YTD 2017
2018 2018 Actuals
- 1,177,210 978,523
- 863 -
1,122 11,837 7,178
1,122 1,189,910 985,701
71,495 540,511 585,510
4,037 201,654 239,161
- 846 51,670
1,454 15,994 17,448
6,114 67,252 72,977
83,100 826,258 966,766
1,122 1,189,910 985,701
83,100 826,258 966,766
(81,978) 363,652 18,935
Starting Fund Balance 181,996 181,996
Net Change 8,262 363,652
Ending Fund Balance 190,258 545,648
Fund 205 - EMERGENCY TELEPHONE (E911) FUND
REVENUE
Other Taxes 1,050,700
Budget by Organization
Report
Through 11/30/18
2018
Classification Budget
Other Revenue -
Interest Income 1,000
REVENUE TOTALS 1,051,700
Capital Outlay 55,000
Insurance and Other Chargebacks 17,448
EXPENSE
Salary and Benefits 615,224
Services and Supplies 282,400
Interfund Transfers 73,366
EXPENSE TOTALS 1,043,438
Fund 205 - EMERGENCY TELEPHONE 8,262
Fund 205 - EMERGENCY TELEPHONE
REVENUE TOTALS 1,051,700
EXPENSE TOTALS 1,043,438
Run by Kate LewisLakin on 12/17/2018 09:01:42 AM Page 10 of 35
November YTD 2017
2018 2018 Actuals
- 341,934 322,477
- 25 5
- 341,959 322,482
- 277,500 329,000
- 277,500 329,000
- 341,959 322,482
- 277,500 329,000
- 64,459 (6,518)
Starting Fund Balance (198,794) (198,794)
Net Change - 64,459
Ending Fund Balance (198,794) (134,335)
Budget by Organization
Report
Through 11/30/18
2018
Classification Budget
Fund 210 - SPECIAL SERVICE AREA (SSA) #4
REVENUE
Property Taxes 370,000
Interest Income -
EXPENSE TOTALS 370,000
REVENUE TOTALS 370,000
EXPENSE
Services and Supplies 370,000
EXPENSE TOTALS 370,000
Fund 210 - SPECIAL SERVICE AREA (SSA) -
Fund 210 - SPECIAL SERVICE AREA (SSA)
REVENUE TOTALS 370,000
Run by Kate LewisLakin on 12/17/2018 09:01:42 AM Page 11 of 35
November YTD 2017
2018 2018 Actuals
65,229 771,511 1,906,708
- 14,084 262
65,229 785,595 1,906,970
49,835 401,973 431,440
660 4,259 3,797
329,885 443,440 645,289
96,475 233,661 392,279
- 161,448 318,412
- 94,817 95,606
746 8,209 20,145
477,602 1,347,806 1,906,970
65,229 785,595 1,906,970
477,602 1,347,806 1,906,970
(412,373) (562,211) -
Starting Fund Balance 64,107 64,107
Net Change (109,388) (562,211)
Ending Fund Balance (45,281) (498,104)
Budget by Organization
Report
Through 11/30/18
2018
Classification Budget
Intergovernmental Revenue 2,330,124
Other Revenue -
Fund 215 - CDBG FUND
REVENUE
REVENUE TOTALS 2,330,124
EXPENSE
Salary and Benefits 502,898
Community Sponsored Organizations 175,500
Services and Supplies 220,840
Capital Outlay -
Insurance and Other Chargebacks 20,648
Miscellaneous 569,970
Interfund Transfers 949,656
EXPENSE TOTALS 2,439,512
EXPENSE TOTALS 2,439,512
Fund 215 - CDBG FUND Totals (109,388)
Fund 215 - CDBG FUND Totals
REVENUE TOTALS 2,330,124
Run by Kate LewisLakin on 12/17/2018 09:01:42 AM Page 12 of 35
November YTD 2017
2018 2018 Actuals
18,852 114,059 51,369
414 2,015 3,391
19,266 116,073 54,760
14,987 124,886 13,070
14,987 124,886 13,070
19,266 116,073 54,760
14,987 124,886 13,070
4,279 (8,812) 41,690
Starting Fund Balance 252,612 252,612
Net Change - (8,812)
Ending Fund Balance 252,612 243,800
Fund 220 - CDBG LOAN FUND
REVENUE
Other Revenue 293,000
Budget by Organization
Report
Through 11/30/18
2018
Classification Budget
Interest Income -
REVENUE TOTALS 293,000
EXPENSE
EXPENSE TOTALS 293,000
Services and Supplies 293,000
Fund 220 - CDBG LOAN FUND Totals -
Fund 220 - CDBG LOAN FUND Totals
REVENUE TOTALS 293,000
EXPENSE TOTALS 293,000
Run by Kate LewisLakin on 12/17/2018 09:01:42 AM Page 13 of 35
November YTD 2017
2018 2018 Actuals
68 966 256
68 966 256
13 145 -
- - -
13 145 -
68 966 256
13 145 -
55 821 256
Starting Fund Balance 170,171 170,171
Net Change (100,000) 821
Ending Fund Balance 70,171 170,992
Fund 235 - NEIGHBORHOOD IMPROVEMENT
REVENUE
Budget by Organization
Report
Through 11/30/18
2018
Classification Budget
Interest Income -
REVENUE TOTALS -
EXPENSE
Miscellaneous 100,000
EXPENSE TOTALS 100,000
Services and Supplies -
EXPENSE TOTALS 100,000
Fund 235 - NEIGHBORHOOD (100,000)
Fund 235 - NEIGHBORHOOD
REVENUE TOTALS -
Run by Kate LewisLakin on 12/17/2018 09:01:42 AM Page 14 of 35
November YTD 2017
2018 2018 Actuals
56,805 231,622 227,450
2,282 30,376 21,820
24 257 5,685
59,111 262,254 254,955
3,834 32,657 43,994
66,365 229,999 231,806
(10,148) (2,924) (27,871)
- - 126
60,052 259,732 248,055
59,111 262,254 254,955
60,052 259,732 248,055
(941) 2,522 6,900
Starting Fund Balance 9,277 9,277
Net Change 615 2,522
Ending Fund Balance 9,892 11,799
Budget by Organization
Report
Through 11/30/18
2018
Classification Budget
Fund 240 - HOME FUND
REVENUE
Intergovernmental Revenue 588,936
Other Revenue -
Salary and Benefits 46,801
Services and Supplies 540,200
Interest Income -
REVENUE TOTALS 588,936
EXPENSE
Miscellaneous 500
EXPENSE TOTALS 588,321
Insurance and Other Chargebacks 820
EXPENSE TOTALS 588,321
Fund 240 - HOME FUND Totals 615
Fund 240 - HOME FUND Totals
REVENUE TOTALS 588,936
Run by Kate LewisLakin on 12/17/2018 09:01:42 AM Page 15 of 35
November YTD 2017
2018 2018 Actuals
3,000 38,700 97,000
31,667 98,333 333,056
1,045 12,939 5,623
35,711 149,973 435,678
9,116 74,743 44,432
59,271 116,272 209,772
13,541 39,216 11,532
5,459 16,454 8,927
15,193 39,169 85,660
102,580 285,853 360,323
35,711 149,973 435,678
102,580 285,853 360,323
(66,869) (135,880) 75,355
Starting Fund Balance 1,476,544 1,476,544
Net Change (38,470) (135,880)
Ending Fund Balance 1,438,074 1,340,664
Budget by Organization
Report
Through 11/30/18
2018
Classification Budget
Other Revenue 400,600
Interest Income 230
Fund 250 - AFFORDABLE HOUSING FUND
REVENUE
Other Taxes 50,000
Services and Supplies 279,500
Insurance and Other Chargebacks -
REVENUE TOTALS 450,830
EXPENSE
Salary and Benefits 96,800
EXPENSE TOTALS 489,300
Community Sponsored Organizations 70,000
Miscellaneous 43,000
Fund 250 - AFFORDABLE HOUSING FUND (38,470)
Fund 250 - AFFORDABLE HOUSING FUND
REVENUE TOTALS 450,830
EXPENSE TOTALS 489,300
Run by Kate LewisLakin on 12/17/2018 09:01:42 AM Page 16 of 35
November YTD 2017
2018 2018 Actuals
174 5,711,185 5,249,949
3,947 35,824 45,924
4,121 5,747,009 5,295,873
168 168 2,007
500,000 500,000 -
- 74,004 98,672
245,000 5,732,704 5,557,325
745,168 6,306,876 5,658,005
4,121 5,747,009 5,295,873
745,168 6,306,876 5,658,005
(741,046) (559,867) (362,132)
Starting Fund Balance 5,262,544 5,262,544
Net Change (3,437,040) (559,867)
Ending Fund Balance 1,825,504 4,702,677
Budget by Organization
Report
Through 11/30/18
2018
Classification Budget
Interest Income 20,000
Fund 300 - WASHINGTON NATIONAL TIF FUND
REVENUE
Property Taxes 5,750,000
Services and Supplies 2,000,000
Capital Outlay -
REVENUE TOTALS 5,770,000
EXPENSE
Miscellaneous 100,000
Interfund Transfers 7,107,040
EXPENSE TOTALS 9,207,040
EXPENSE TOTALS 9,207,040
Fund 300 - WASHINGTON NATIONAL TIF (3,437,040)
Fund 300 - WASHINGTON NATIONAL TIF
REVENUE TOTALS 5,770,000
Run by Kate LewisLakin on 12/17/2018 09:01:42 AM Page 17 of 35
November YTD 2017
2018 2018 Actual
36,026 10,507,269 10,797,411
288,929 3,359,889 2,895,561
7,219 79,405 -
- 7,106,441 8,966,396
28,550 144,462 36,782
360,724 21,197,466 22,696,150
6 58,318 100,625
- 9,057,278 23,099,797
- - (57)
6 9,115,596 23,200,365
360,724 21,197,466 22,696,150
6 9,115,596 23,200,365
360,717 12,081,870 (504,215)
Starting Fund Balance 241,781 241,781
Net Change 128,349 12,081,870
Ending Fund Balance 370,130 12,323,651
EXPENSE TOTALS 14,297,257
Fund 320 - DEBT SERVICE FUND Totals 128,349
Debt Service 14,177,257
Miscellaneous -
REVENUE TOTALS 14,425,606
EXPENSE TOTALS 14,297,257
Fund 320 - DEBT SERVICE FUND Totals
REVENUE TOTALS 14,425,606
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,460,821
Budget by Organization Report
Through 11/30/18
2018
Classification Budget
Run by Kate LewisLakin on 12/17/2018 09:01:42 AM Page 18 of 35
November YTD 2017
2018 2018 Actuals
174 622,345 583,827
(34,370) 3,527,939 32,000
0 120 22
(34,195) 4,150,404 615,848
168 490,670 307,391
132,313 1,460,566 -
135 1,267 995
5,000 55,000 60,000
137,616 2,007,502 368,386
(34,195) 4,150,404 615,848
137,616 2,007,502 368,386
(171,811) 2,142,902 247,462
Starting Fund Balance 247,378 247,378
Net Change (296,100) 2,142,902
Ending Fund Balance (48,722) 2,390,280
Budget by Organization
Report
Through 11/30/18
2018
Classification Budget
Fund 330 - HOWARD-RIDGE TIF FUND
REVENUE
Property Taxes 605,000
Other Revenue 3,780,000
Interest Income 400
REVENUE TOTALS 4,385,400
EXPENSE
Debt Service 960,000
Services and Supplies 461,500
Capital Outlay 3,200,000
Interfund Transfers 60,000
EXPENSE TOTALS 4,681,500
Fund 330 - HOWARD-RIDGE TIF FUND (296,100)
Fund 330 - HOWARD-RIDGE TIF FUND
REVENUE TOTALS 4,385,400
EXPENSE TOTALS 4,681,500
Run by Kate LewisLakin on 12/17/2018 09:01:42 AM Page 19 of 35
November YTD 2017
2018 2018 Actuals
1,436 217,949 43,503
2,057 10,283 12,339
1,051 8,269 3,898
4,543 236,500 59,741
630 4,493 2,007
1,662 15,570 12,227
2,500 27,500 30,000
4,792 47,563 44,235
4,543 236,500 59,741
4,792 47,563 44,235
(248) 188,937 15,506
Starting Fund Balance 432,766 432,766
Net Change (39,850) 188,937
Ending Fund Balance 392,916 621,703
Budget by Organization
Report
Through 11/30/18
2018
Classification Budget
Fund 335 - WEST EVANSTON TIF FUND
REVENUE
Property Taxes -
Other Revenue -
Debt Service 10,000
Services and Supplies -
Interest Income 150
REVENUE TOTALS 150
EXPENSE
Interfund Transfers 30,000
EXPENSE TOTALS 40,000
Fund 335 - WEST EVANSTON TIF FUND (39,850)
Fund 335 - WEST EVANSTON TIF FUND
REVENUE TOTALS 150
EXPENSE TOTALS 40,000
Run by Kate LewisLakin on 12/17/2018 09:01:42 AM Page 20 of 35
November YTD 2017
2018 2018 Actuals
- 136,927 48,001
- - 2,067,512
- 10 1
- 136,937 2,115,514
168 1,693 38,588
- - 2,053,521
- 74,104 -
168 75,797 2,092,108
- 136,937 2,115,514
168 75,797 2,092,108
(168) 61,139 23,406
Starting Fund Balance (6,009) (6,009)
Net Change 202,334 61,139
Ending Fund Balance 196,325 55,130
Budget by Organization
Report
Through 11/30/18
2018
Classification Budget
Fund 340 - DEMPSTER-DODGE TIF FUND
REVENUE
Property Taxes 275,000
Other Revenue -
Services and Supplies -
Debt Service 72,666
Interest Income -
REVENUE TOTALS 275,000
EXPENSE
Interfund Transfers -
EXPENSE TOTALS 72,666
Fund 340 - DEMPSTER-DODGE TIF FUND 202,334
Fund 340 - DEMPSTER-DODGE TIF FUND
REVENUE TOTALS 275,000
EXPENSE TOTALS 72,666
Run by Kate LewisLakin on 12/17/2018 09:01:42 AM Page 21 of 35
November YTD 2017
2018 2018 Actuals
- 222,235 75,430
- - 3,520,189
- 23 9
- 222,258 3,595,628
168 1,693 58,113
- - 580,000
- - 3,031,398
- 107,561 -
168 109,254 3,669,511
- 222,258 3,595,628
168 109,254 3,669,511
(168) 113,003 (73,884)
Starting Fund Balance 61,193 61,193
Net Change 316,001 113,003
Ending Fund Balance 377,194 174,196
Budget by Organization
Report
Through 11/30/18
2018
Classification Budget
Fund 345 - CHICAGO-MAIN TIF
REVENUE
Property Taxes 425,000
Other Revenue -
Interest Income -
REVENUE TOTALS 425,000
EXPENSE
Services and Supplies -
Capital Outlay -
Debt Service 108,999
Interfund Transfers -
EXPENSE TOTALS 108,999
Fund 345 - CHICAGO-MAIN TIF Totals 316,001
Fund 345 - CHICAGO-MAIN TIF Totals
REVENUE TOTALS 425,000
EXPENSE TOTALS 108,999
Run by Kate LewisLakin on 12/17/2018 09:01:42 AM Page 22 of 35
November YTD 2017
2018 2018 Actuals
54 115,242 215,245
0 33 21
54 115,276 215,266
- - 213,354
- - 78,000
- - 291,354
54 115,276 215,266
- - 291,354
54 115,276 (76,088)
Starting Fund Balance 2,207 2,207
Net Change - 115,276
Ending Fund Balance 2,207 117,483
Budget by Organization
Report
Through 11/30/18
2018
Classification Budget
Fund 350 - SPECIAL SERVICE AREA (SSA) #6
REVENUE
Property Taxes 221,000
Interest Income 500
REVENUE TOTALS 221,500
EXPENSE
Services and Supplies 221,500
Interfund Transfers -
EXPENSE TOTALS 221,500
Fund 350 - SPECIAL SERVICE AREA (SSA) -
Fund 350 - SPECIAL SERVICE AREA (SSA)
REVENUE TOTALS 221,500
EXPENSE TOTALS 221,500
Run by Kate LewisLakin on 12/17/2018 09:01:42 AM Page 23 of 35
November YTD 2017
2018 2018 Actuals
- - 359,706
783 59,849 33,339
536,667 5,903,333 787,177
- 51,221 530,812
- 10,274,896 11,246,149
16,257 176,867 56,607
553,707 16,466,167 13,013,790
73,019 585,124 5,392
184,598 1,031,436 1,672,608
723,422 9,860,294 13,582,482
41,667 458,333 500,000
1,022,706 11,935,187 15,760,481
553,707 16,466,167 13,013,790
1,022,706 11,935,187 15,760,481
(468,999) 4,530,979 (2,746,691)
Starting Fund Balance 8,758,473 8,758,473
Net Change (7,655,527) 4,530,979
Ending Fund Balance 1,102,946 13,289,452
Budget by Organization
Report
Through 11/30/18
2018
Classification Budget
Fund 415 - CAPITAL IMPROVEMENTS FUND
REVENUE
Licenses, Permits and Fees -
Charges for Services -
Interfund Transfers 6,450,000
Intergovernmental Revenue 4,190,000
Other Revenue 12,002,000
Interest Income -
REVENUE TOTALS 22,642,000
EXPENSE
Interfund Transfers 500,000
Salary and Benefits 85,527
Services and Supplies -
Capital Outlay 29,712,000
EXPENSE TOTALS 30,297,527
Fund 415 - CAPITAL IMPROVEMENTS
REVENUE TOTALS 22,642,000
EXPENSE TOTALS 30,297,527
Fund 415 - CAPITAL IMPROVEMENTS (7,655,527)
Run by Kate LewisLakin on 12/17/2018 09:01:42 AM Page 24 of 35
November YTD 2017
2018 2018 Actuals
- - 649,512
- 1,250,000 -
11,360 25,645,414 900,000
45,901 106,046 -
57,261 27,001,460 1,549,512
- 1,715,782 638,727
1,146,932 2,919,967 369,924
- - -
1,146,932 4,635,749 1,008,651
57,261 27,001,460 1,549,512
1,146,932 4,635,749 1,008,651
(1,089,670) 22,365,711 540,861
Starting Fund Balance 540,861 540,861
Net Change 1,866,000 22,365,711
Ending Fund Balance 2,406,861 22,906,572
Fund 416 - CROWN CONSTRUCTION FUND 1,866,000
Fund 416 - CROWN CONSTRUCTION FUND
REVENUE TOTALS 11,500,000
EXPENSE TOTALS 9,634,000
EXPENSE TOTALS 9,634,000
Services and Supplies 1,634,000
Capital Outlay 8,000,000
Debt Service -
Interest Income -
REVENUE TOTALS 11,500,000
EXPENSE
Interfund Transfers -
Intergovernmental Revenue -
Other Revenue 11,500,000
Fund 416 - CROWN CONSTRUCTION FUND
REVENUE
Budget by Organization
Report
Through 11/30/18
2018
Classification Budget
Run by Kate LewisLakin on 12/17/2018 09:01:42 AM Page 1 of 1
November YTD 2017
2018 2018 Actuals
- 277,004 -
4,233 46,534 31,207
5,132 144,378 237,012
- - -
9,365 467,916 268,219
7,952 66,571 694
5 1,948 5,613
- 303,736 -
42,786 470,641 263,427
50,742 842,897 269,734
9,365 467,916 268,219
50,742 842,897 269,734
(41,377) (374,981) (1,516)
Starting Fund Balance 2,997,700 2,997,700
Net Change (123,850) (374,981)
Ending Fund Balance 2,873,850 2,622,719
Other Revenue 250,000
Fund 420 - SPECIAL ASSESSMENT FUND
REVENUE
Budget by Organization
Report
Through 11/30/18
2018
Classification Budget
Interest Income 31,200
Special Assessment 180,167
Reappropriation of Surplus -
REVENUE TOTALS 461,367
EXPENSE
Salary and Benefits 71,790
Debt Service -
Interfund Transfers 513,427
Services and Supplies -
EXPENSE TOTALS 585,217
Fund 420 - SPECIAL ASSESSMENT FUND
REVENUE TOTALS 461,367
EXPENSE TOTALS 585,217
Fund 420 - SPECIAL ASSESSMENT FUND (123,850)
Run by Kate LewisLakin on 12/17/2018 09:01:42 AM Page 26 of 35
November YTD 2017
2018 2018 Actual
- 2,398 1,900
350,996 5,749,163 6,303,624
- 3,037,704 4,120,636
- - -
18,122 296,574 253,523
10,860 95,402 62,067
379,978 9,181,241 10,741,750
194,056 1,598,931 1,675,404
425,889 3,393,281 3,172,070
- 200,976 280,311
26,637 293,011 319,648
- - 2,561,771
- - 4,246
- 53,131 267,734
28,554 182,004 267,436
120,035 1,320,382 1,584,683
795,171 7,041,716 10,133,302
379,978 9,181,241 10,741,750
795,171 7,041,716 10,133,302
(415,193) 2,139,525 608,448
Starting Fund Balance 4,710,701 4,710,701
Net Change (1,762,367) 2,139,525
Ending Fund Balance 2,948,334 6,850,226
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
304,000
Insurance and Other Chargebacks 319,648
Depreciation Expense -
Contingencies 11,000
Debt Service 3,070,625
Miscellaneous
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
Fund 505 - PARKING SYSTEM FUND
REVENUE
193,316
Licenses, Permits and Fees -
Charges for Services 6,676,575
Interfund Transfers 4,217,040
Intergovernmental Revenue 12,125
Other Revenue
Budget by Organization Report
Through 11/30/18
2018
Classification Budget
Run by Kate LewisLakin on 12/17/2018 09:01:42 AM Page 27 of 35
November YTD 2017
2018 2018 Actual
4,040 47,278 86,063
1,048,125 14,766,568 17,255,947
67,854 5,859,532 294,812
34,736 217,607 35,784
1,154,754 20,890,986 17,672,605
618,598 5,021,917 5,958,873
367,086 3,127,210 2,528,863
169,591 4,953,418 (192,124)
39,041 429,451 468,492
- - 2,470,280
- - -
85,306 584,427 717,388
- - 2
306,859 3,375,450 6,327,314
1,586,480 17,491,874 18,279,088
1,154,754 20,890,986 17,672,605
1,586,480 17,491,874 18,279,088
(431,726) 3,399,112 (606,483)
Starting Fund Balance 6,562,795 6,562,795
Net Change 32,150 3,399,112
Ending Fund Balance 6,594,945 9,961,907
Fund 510 - WATER FUND Totals 32,150
Fund 510 - WATER FUND Totals
REVENUE TOTALS 45,695,656
Interfund Transfers 3,602,313
EXPENSE TOTALS 45,663,506
EXPENSE TOTALS 45,663,506
Contingencies 1,000
Debt Service 1,960,760
Miscellaneous 15,000
Capital Outlay 29,346,200
Insurance and Other Chargebacks 468,492
Depreciation Expense -
EXPENSE
Salary and Benefits 5,614,331
Services and Supplies 4,655,410
Fund 510 - WATER FUND
REVENUE
Licenses, Permits and Fees 70,000
45,695,656
Charges for Services 18,267,000
Other Revenue 27,333,656
Interest Income 25,000
REVENUE TOTALS
Budget by Organization Report
Through 11/30/18
2018
Classification Budget
Run by Kate LewisLakin on 12/17/2018 09:01:42 AM Page 28 of 35
November YTD 2017
2018 2018 Actual
390,079 11,173,238 12,477,657
- 1,868,230 14,870
12,699 46,623 16,023
402,779 13,088,091 12,508,550
144,438 1,196,677 1,313,154
258,178 583,841 88,677
- 729,666 16,941
22,499 247,489 269,988
- - 3,530,787
1,024,321 8,180,701 1,143,643
115 230 -
82,640 909,037 1,141,676
1,532,191 11,847,641 7,504,867
402,779 13,088,091 12,508,550
1,532,191 11,847,641 7,504,867
(1,129,412) 1,240,450 5,003,683
Starting Fund Balance 4,037,755 4,037,755
Net Change (119,220) 1,240,450
Ending Fund Balance 3,918,535 5,278,205
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
1,500
Capital Outlay 2,181,300
Insurance and Other Chargebacks 269,988
Depreciation Expense -
Debt Service 7,540,066
Miscellaneous
EXPENSE
Salary and Benefits 1,274,709
Services and Supplies 2,558,630
14,698,650
Fund 515 - SEWER FUND
REVENUE
Charges for Services 12,589,650
Other Revenue 2,104,000
Interest Income 5,000
REVENUE TOTALS
Budget by Organization Report
Through 11/30/18
2018
Classification Budget
Run by Kate LewisLakin on 12/17/2018 09:01:42 AM Page 29 of 35
November YTD 2017
2018 2018 Actual
- 410,000 -
14,063 213,086 329,039
454,355 3,371,718 3,699,121
58,831 647,136 755,967
2,091 91,709 33,348
529,340 4,733,648 4,817,475
113,887 883,679 890,220
320,593 3,167,051 3,482,141
2,436 178,829 24,635
- 665 1,797
1,600 5,288 3,057
26,864 295,499 504,807
465,380 4,531,010 4,906,657
529,340 4,733,648 4,817,475
465,380 4,531,010 4,906,657
63,960 202,638 (89,182)
Starting Fund Balance (1,061,966) (1,061,966)
Net Change 151,660 202,638
Ending Fund Balance (910,306) (859,328)
Fund 520 - SOLID WASTE FUND Totals 151,660
Fund 520 - SOLID WASTE FUND Totals
REVENUE TOTALS 5,261,361
Interfund Transfers 322,362
EXPENSE TOTALS 5,109,701
EXPENSE TOTALS 5,109,701
Capital Outlay 275,750
Debt Service 21,797
Miscellaneous 7,500
EXPENSE
Salary and Benefits 993,616
Services and Supplies 3,488,676
5,261,361
Charges for Services 3,732,394
Interfund Transfers 705,967
Other Revenue 38,000
REVENUE TOTALS
Fund 520 - SOLID WASTE FUND
REVENUE
Property Taxes 410,000
Licenses, Permits and Fees 375,000
Budget by Organization Report
Through 11/30/18
2018
Classification Budget
Run by Kate LewisLakin on 12/17/2018 09:01:42 AM Page 30 of 35
November YTD 2017
2018 2018 Actuals
249,053 2,739,587 2,478,435
2,242 18,765 19,016
- 24 339
251,295 2,758,376 2,497,791
141,822 992,073 1,154,569
236,030 1,943,812 1,744,972
- - -
- 118 -
2,787 30,655 27,833
380,639 2,966,658 2,927,375
251,295 2,758,376 2,497,791
380,639 2,966,658 2,927,375
(129,343) (208,282) (429,584)
Starting Fund Balance 341,343 341,343
Net Change (262,450) (208,282)
Ending Fund Balance 78,893 133,061
Budget by Organization
Report
Through 11/30/18
2018
Classification Budget
Other Revenue 81,781
Interest Income 1,000
Fund 600 - FLEET SERVICES FUND
REVENUE
Charges for Services 2,988,640
Contingencies 450
Services and Supplies 2,230,057
REVENUE TOTALS 3,071,421
EXPENSE
Salary and Benefits 1,069,922
Miscellaneous -
Interfund Transfers 33,442
EXPENSE TOTALS 3,333,871
EXPENSE TOTALS 3,333,871
Fund 600 - FLEET SERVICES FUND Totals (262,450)
Fund 600 - FLEET SERVICES FUND Totals
REVENUE TOTALS 3,071,421
Run by Kate LewisLakin on 12/17/2018 09:01:42 AM Page 31 of 35
November YTD 2017
2018 2018 Actuals
111,228 1,223,504 1,400,057
- 39,603 88,015
336 4,412 2,128
111,564 1,267,519 1,490,200
6,336 37,244 74,539
(1,317) 1,013,211 -
- - 1,780,829
5,019 1,050,454 1,855,367
111,564 1,267,519 1,490,200
5,019 1,050,454 1,855,367
106,544 217,065 (365,167)
Starting Fund Balance 849,519 849,519
Net Change (53,028) 217,065
Ending Fund Balance 796,491 1,066,584
Fund 601 - EQUIPMENT REPLACEMENT FUND
REVENUE
Charges for Services 1,334,732
Budget by Organization
Report
Through 11/30/18
2018
Classification Budget
Other Revenue 210,217
Interest Income -
REVENUE TOTALS 1,544,949
Depreciation Expense -
EXPENSE TOTALS 1,597,977
EXPENSE
Services and Supplies 75,000
Capital Outlay 1,522,977
EXPENSE TOTALS 1,597,977
Fund 601 - EQUIPMENT REPLACEMENT (53,028)
Fund 601 - EQUIPMENT REPLACEMENT
REVENUE TOTALS 1,544,949
Run by Kate LewisLakin on 12/17/2018 09:01:42 AM Page 32 of 35
November YTD 2017
2018 2018 Actuals
13,534 154,161 162,411
- - 2,300,000
854,217 9,357,537 10,926,377
171,101 1,912,994 1,032,678
441,323 5,168,828 5,611,626
- 2,878 382
1,480,175 16,596,398 20,033,473
56,967 521,225 606,021
944,305 5,394,607 3,594,432
- 33,222 -
1,267,443 14,789,386 17,164,869
803 8,829 9,632
2,269,518 20,747,268 21,374,954
1,480,175 16,596,398 20,033,473
2,269,518 20,747,268 21,374,954
(789,343) (4,150,870) (1,341,481)
Starting Fund Balance (4,338,505) (4,338,505)
Net Change 653,342 (4,150,870)
Ending Fund Balance (3,685,163) (8,489,375)
Budget by Organization Report
Through 11/30/18
2018
Classification Budget
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
Insurance 5,811,177
Interest Income 1,000
REVENUE TOTALS 19,093,273
EXPENSE
Salary and Benefits 729,027
Services and Supplies 2,385,448
Interfund Transfers 9,632
EXPENSE TOTALS 18,439,931
Capital Outlay -
Insurance and Other Chargebacks 15,315,824
EXPENSE TOTALS 18,439,931
Fund 605 - INSURANCE FUND Totals 653,342
Fund 605 - INSURANCE FUND Totals
REVENUE TOTALS 19,093,273
Run by Kate LewisLakin on 12/17/2018 09:01:42 AM Page 33 of 35
November YTD 2017
2018 2018 Actuals
- - -
- - -
114,409 6,620,873 15,225,459
- 1,273,072 2,065,885
114,409 7,893,945 17,291,343
781,354 8,461,204 8,682,009
- 60,360 136,256
781,354 8,521,564 8,818,265
114,409 7,893,945 17,291,343
781,354 8,521,564 8,818,265
(666,945) (627,619) 8,473,079
Starting Fund Balance 79,073,077 79,073,077
Net Change 4,989,947 (627,619)
Ending Fund Balance 84,063,024 78,445,458
Fund 700 - FIRE PENSION FUND
REVENUE
Other Taxes 280,000
Budget by Organization
Report
Through 11/30/18
2018
Classification Budget
Interfund Transfers 10,000
Other Revenue 9,394,947
Interest Income 4,100,000
REVENUE TOTALS 13,784,947
EXPENSE
Salary and Benefits 8,795,000
Miscellaneous -
EXPENSE TOTALS 8,795,000
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
Run by Kate LewisLakin on 12/17/2018 09:01:42 AM Page 34 of 35
November YTD 2017
2018 2018 Actuals
- - -
178,308 17,636,285 24,497,983
- 2,222,801 2,829,084
178,308 19,859,086 27,327,068
996,071 10,991,135 11,624,574
- 249,289 264,371
996,071 11,240,424 11,888,945
178,308 19,859,086 27,327,068
996,071 11,240,424 11,888,945
(817,763) 8,618,662 15,438,122
Starting Fund Balance 121,629,667 121,629,667
Net Change 6,194,704 8,618,662
Ending Fund Balance 127,824,371 130,248,329
Fund 705 - POLICE PENSION FUND
REVENUE
Budget by Organization Report
Through 11/30/18
2018
Classification Budget
Interfund Transfers 57,000
Other Revenue 12,162,704
Interest Income 6,500,000
Miscellaneous 270,000
REVENUE TOTALS 18,719,704
EXPENSE
Salary and Benefits 12,255,000
EXPENSE TOTALS 12,525,000
Fund 705 - POLICE PENSION FUND Totals
REVENUE TOTALS 18,719,704
EXPENSE TOTALS 12,525,000
Fund 705 - POLICE PENSION FUND Totals 6,194,704
Run by Kate LewisLakin on 12/17/2018 09:01:42 AM Page 35 of 35