Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My Public Portal
About
12-09-2019 COW Agenda and Packet
Committee of the Whole Workshop of the President and the Board of Trustees Monday, December 09, 2019 7:00 PM 24401 W. Lockport Street Plainfield, IL 60544 In the Boardroom Agenda A.CALL TO ORDER, ROLL CALL, PLEDGE B.APPROVAL OF THE MINUTES B.1.Approval of the Minutes of the Committee of the Whole Workshop held on November 25, 2019. 11-25-2019 COW Minutes C.PRESIDENTIAL COMMENTS D.TRUSTEES COMMENTS E.PUBLIC COMMENTS (3-5 minutes) F.WORKSHOP F.1.2020-2021 DRAFT FISCAL YEAR BUDGET Staff will provide an overview of the draft Administration, Planning, Building, and Street Department Budgets; overview of the Village’s General Fund Revenues, and Miscellaneous Funds. 2020-2021 DRAFT Fiscal Year Budget Detail Budget Performance Report through December 5, 2019 G.EXECUTIVE SESSION G.1.Seeking Board consideration of a motion to adjourn to Executive Session as permitted under the Open Meetings Act under Section 2 (c)(3) to discuss the selection, appointment, performance, discipline or removal of a Public Official, not to reconvene. REMINDERS - 1 Committee of the Whole Workshop of the President and the Board of Trustees Page - 2 •December 11 Coffee with the Mayor – 9:00 a.m. •December 16 Village Board Meeting – 7:00 p.m. •December 17 Plan Commission – 7:00 p.m. •December 23 Next Committee of the Workshop – 7:00 p.m. 2 Minutes of the Committee of the Whole Workshop of the President and the Board of Trustees Held on November 25, 2019 In the Boardroom Mayor Collins called the meeting to order at 7:00 p.m. Board Present: Mayor Collins, Trustee Calkins, Trustee Larson, Trustee Newton, Trustee Wojowski, Trustee Benton, Trustee Bonuchi. Others present: Brian Murphy, Administrator; Michelle Gibas, Village Clerk; Allen Persons, Public Works Director; Jon Proulx, Planning Director; Lonnie Spires, Building Official; Traci Pleckham, Management Services Director; and John Konopek, Chief of Police. There were approximately 4 persons in the audience. Trustee Bonuchi moved to approve the Minutes of the Committee of the Whole Workshop held on October 14, 2019. Second by Trustee Larson. Voice Vote. All in favor, 0 opposed. Motion carried. Motion carried. PRESIDENTIAL COMMENTS Mayor Collins presented a plaque to Trustee Newton recognizing his years of service. Trustee Newton commented about community service and responsibilities and thanked the residents that elected him. TRUSTEE COMMENTS Trustee Bonuchi thanked Trustee Newton for his service and wished him well. Trustee Larson: Thanked Trustee Newton for his service. Encouraged everyone to shop on Small Business Saturday. Reminded everyone of the Heart of Christmas Event in Downtown Plainfield. Trustee Wojowski: Thanked Trustee Newton for his service. Commented on the Budget Process. Trustee Benton thanked Trustee Newton for his service. Trustee Calkins thanked Trustee Newton for his service. PUBLIC COMMENTS No Comments. WORKSHOP 1) 2020-2021 DRAFT FISCAL YEAR AUDIT Chief Konopek reviewed the Mission Statement, Police Department values, surrounding community population, 5-year crime index, crime stats and trends, cellphone violations, railroad violations, red light cameras, officers’ years of service, retirements, staffing and organizational study, PEMA, and organizational considerations and proposed changes. Traci Pleckham reviewed the Budget Detail for the Police Department. 3 Village of Plainfield Meeting Minutes – November 25, 2019 Page 2 2)YEAR 2019 TAX LEVY Traci Pleckham reviewed the proposed 2019 tax levy calculations. Staff has calculated the 2019 levy by maintaining the 2018 tax levy rate of .4669. Consistent with Board direction, this levy rate has remained unchanged for the past six years. The 2019 levy represents a total request of $6,880,000; however, the actual dollar amount the Village will receive is anticipated to be less. The Village’s portion of the 2018 tax levy was 5.39%, or for every dollar paid in property taxes by Village residents, 5.39 cents is paid to the Village. Mrs. Pleckham reviewed the timeline for the 2019 tax levy. A Public Hearing is scheduled to be held at the December 16, 2019 Village Board Meeting. Mayor Collins read the reminders. On a motion from Trustee Larson and second by Trustee Benton, the meeting adjourned at 8:55 p.m. Michelle Gibas, Village Clerk 4 General Fund PLAINFIFLD Administration/Finance Summary 2020-2021 Fiscal Year Budget FY 2020 2021 FY 2016 FY 2017 FY 2018 FY 2019 Adopted Proposed Classification Actual Actual Actual Actual Budget Budget Fund: 01- General Fund Expenditures Unit: 04-Administration/Finance Salaries and Wages 1,279,816 1,272,722 1,380,447 1,419,084 1,448,000 1,611,000 Benefits 492,620 505,693 536,021 551,280 599,100 651,655 Utilities 9,382 11,066 11,892 14,389 14,250 15,000 Supplies and Commodities 90,263 96,020 95,485 123,471 117,450 117,650 Contractual Services 3,806,041 4,355,814 4,633,183 4,586,998 4,763,600 4,995,350 Other 439,745 103,520 255,551 313,378 348,700 404,300 Sub-total $6,117,867 $6,344,835 $6,912,579 $7,008,600 $7,291,100 $7,794,955 Transfers 2,378,289 2,189,567 532,831 1,359,212 450,000 0 Total Administration/Finance $8,496,156 $8,534,402 $7,445,410 $8,367,812 $7,741,100 $7,794,955 Admin/Finance Expense History 9,000,000 8,000,000 Other 7,000,000 # contractual Services 6,000,000 Supplies and Commodities 5,000,000mil NI Utilities inn Benefits 4,000,000 - 3,000,000 Salaries and Wages 2,000,000 1,000,000 11110 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 2021 Actual Actual Actual Actual Adopted Proposed Budget Budget 5 II .util,., General Fund 4_*1».1 1 I-II.e+u.uI'I ( III PLAIzNFIELD Administration/Finance Detail 2020-2021 Fiscal Year Budget FY 2020 FY 2021 FY 2017 FY 2018 FY 2019 Adopted Proposed Description Actual Actual Actual Budget Budget Expenditures Unit: 04-Administration/Finance Division: 00- Non-Divisional Contrac-Contractual Services Fees to Refuse Hauler 3,669,782 3,821,167 3,982,891 4,134,000 4,300,000 Bad Debt Expense 134,093 272,422 0 0 0 3982891 $4,134,0+ 1 1, , 1 Division: 01 - Legislative Program SAL-Salaries and Wages Salaries-President 20,000 23,667 24,000 24,000 24,000 Salaries-Elected Officials 24,100 24,200 23,800 25,000 25,000 Salaries-Liquor Commissioner 1,500 1,500 1,500 1,500 1,500 Salaries-Treasurer 2,500 2,500 2,500 2,500 2,500 Total:Salaries and Wages $48,100 51,867 51,800 53,000 53,000 BEN - Benefits FICA 2,783 3,055 3,037 3,300 3,300 Medicare 651 714 710 780 780 IMRF 862 233 0 0 0 Employee Insurance 92 141 139 150 150 Travel/Training 3,844 6,145 4,393 10,000 10,000 Total: Benefits 8,232 10,288 8,279 14,230 14,230 SUPP-Supplies and Commodities Replacement Supplies 85 0 0 3,000 3,000 Dues &Subscriptions 38,761 33,946 56,001 40,000 40,000 Total:Supplies&Commodities $38,846 33,946 56,001 43,000 43,000 Contrac-Contractual Services Public Relations 113,975 82,765 100,472 115,000 115,000 Cable TV 17,086 20 0 10,000 10,000 Total:Contractual Services $131,061 82,785 $100,472 $125,000 $125,000 OTHER-Other Economic Incentive Rebate 36,008 165,532 189,796 175,000 225,000 Total:Other $36,008 $165,532 $189,796 $175,000 $225,000 gislative're 96 343 s 10 230 6 iii 111 ,fi.0 General Fund PLAINFIELD Administration/Finance Detail 2020-2021 Fiscal Year Budget FY 2020 FY 2021 FY 2017 FY 2018 FY 2019 Adopted Proposed Description Actual Actual Actual Budget Budget Division: 02-Administration Program SAL-Salaries and Wages Salaries-Full Time 688,352 718,382 744,712 755,000 790,000 Salaries-Part Time 45,066 52,773 53,127 55,000 55,000 Salaries-Overtime 339 2,734 878 3,000 3,000 Total:Salaries and Wages $733,757 $773,889 $798,717 $813,000 $848,000 BEN - Benefits FICA 40,633 44,176 45,116 50,400 52,500 Medicare 10,673 11,215 11,560 11,800 12,500 IMRF 83,198 86,552 84,813 92,000 93,500 Employee Insurance 102,071 99,560 103,736 105,000 111,000 Deferred Comp. Contribution 24,321 22,077 23,458 28,000 28,000 Travel/Training 9,488 9,320 12,055 15,000 15,000 IL Unemployment Insurance 3,506 3,876 4,043 5,000 5,000 Total: Benefits $273,890 $276,776 $284,781 $307,200 $317,500 UTIL- Utilities Telephone/Internet 4,094 4,736 6,346 5,500 5,500 Cellular Phones/Pagers 3,004 2,262 2,146 3,000 3,000 Total: UTIL-Utilities 7,098 6,998 8,492 8,500 8,500 SUPP-Supplies and Commodities Office Supplies/Postage 30,163 31,370 32,003 32,000 32,000 Dues &Subscriptions 4,072 3,759 3,716 5,000 5,000 Gas/Oil/Mileage/Carwash 8,260 8,205 8,919 9,500 9,500 Total:Supplies&Commodities $42,495 43,334 44,638 46,500 46,500 Contrac-Contractual Services Maintenance Contracts/Lease 7,908 7,908 8,719 8,000 8,000 Recording Fees 1,379 398 1,579 1,500 1,500 Legal Notices 1,600 2,085 2,328 2,500 2,500 Legal Fees 30,736 41,774 48,478 45,000 45,000 Contractual Services 85,320 59,102 95,535 80,000 80,000 Engineering Fees 2,283 0 0 0 0 Total:Contractual Services $129,226 $111,267 $156,639 $137,000 $137,000 OTHER-Other Office Furniture & Equipment 4,632 641 1,748 5,000 5,000 Contingencies 18,750 0 37,696 45,000 45,000 Total:OTHER-Other $23,382 641 39,444 50,000 50,000 otal_tk-s st 4O9,848 Mk__,,,, k 4 .22c00., i,, -- , 7 General Fund PLAINFIELD Administration/Finance Detail 2020-2021 Fiscal Year Budget FY 2020 FY 2021 FY 2017 FY 2018 FY 2019 Adopted Proposed Description Actual Actual Actual Budget Budget Division: 03 -Community Relations Program SAL-Salaries and Wages Salaries-Full Time 96,782 99,201 102,251 105,000 108,000 Total:Salaries and Wages $96,782 99,201 $102,251 $105,000 $108,000 BEN - Benefits FICA 5,592 5,680 5,901 6,510 6,700 Medicare 1,308 1,328 1,380 1,525 1,600 IMRF 11,059 11,231 11,010 12,075 12,075 Employee Insurance 18,563 19,865 21,094 22,500 23,500 Deferred Comp. Contribution 3,561 3,608 3,656 4,000 4,000 Travel/Training 143 155 251 1,500 1,500 Total: Benefits $40,226 41,867 43,292 48,110 49,375 UTIL- Utilities Telephone/Internet 409 474 635 650 700 Total: UTIL-Utilities 409 474 635 650 700 SUPP-Supplies and Commodities Office Supplies/Postage 81 94 0 500 500 Dues&Subscriptions 525 1,316 530 850 850 Gas/Oil/Mileage/Carwash 0 0 0 100 100 Total:Supplies&Commodities 606 1,410 530 1,450 1,450 Contrac-Contractual Services Public Relations 8,157 10,647 10,799 12,500 13,000 Marketing and Promotions 0 500 173 2,000 1,500 Settler's Park 4,863 6,892 6,191 7,500 8,500 Contractual Services 0 336 3,850 4,000 4,000 Total:Contractual Services $13,020 18,375 21,013 26,000 27,000 5 a " ,.>, :,. c ,tea.. -, :, 8 General Fund ILLAGE OP PLAINFIFLD Administration/Finance Detail 2020-2021 Fiscal Year Budget FY 2020 FY 2021 FY 2017 FY 2018 FY 2019 Adopted Proposed Description Actual Actual Actual Budget Budget Division: 04- Facility Management Program SAL-Salaries and Wages Salaries-Full Time 33,937 45,909 50,139 51,000 53,000 Salaries-Overtime 1,705 4,673 4,226 3,000 3,000 Total:Salaries and Wages $35,642 50,582 54,365 54,000 56,000 BEN - Benefits FICA 2,245 2,996 3,227 3,400 3,400 Medicare 525 701 755 800 800 IMRF 4,221 5,586 5,766 5,900 5,900 Employee Insurance 9,200 11,946 15,300 15,000 17,500 Deferred Comp. Contribution 0 343 777 0 0 Total: Benefits $16,191 21,572 25,825 25,100 27,600 SUPP-Supplies and Commodities Building Supplies 9,970 11,614 10,387 12,000 12,000 Total:Supplies&Commodities 9,970 11,614 10,387 12,000 12,000 Contrac-Contractual Services Contractual Services 32,624 46,024 43,067 40,000 40,000 Total:Contractual Services $32,624 46,024 43,067 40,000 40,000 OTHER-Other Building Improvements 0 28,178 5,987 40,000 30,000 Total: OTHER-Other 0 28,178 5,987 40,000 30,000 cttal 04 Facilttli,Ma 1 a s $165 6 ate. :., ,,_ 1.__ ._ ,, _-A _ _tea _ ,A , 9 lilin flim" 1t lil General Fund I-•I _lII-1I.lIunyI•1 III PLAITNFIFLD Administration/Finance Detail 2020-2021 Fiscal Year Budget FY 2020 FY 2021 FY 2017 FY 2018 FY 2019 Adopted Proposed Description Actual Actual Actual Budget Budget Division: 06- Human Resources Program SAL-Salaries and Wages Salaries-Full Time 135,412 163,895 166,248 170,000 180,000 Salaries-Overtime 0 0 50 500 500 Total:Salaries and Wages $135,412 $163,895 $166,298 $170,500 $180,500 BEN - Benefits FICA 8,014 9,803 9,972 10,550 11,000 Medicare 1,874 2,293 2,332 2,500 2,500 IMRF 15,422 18,321 17,738 19,650 19,650 Employee Insurance 25,578 35,224 38,063 40,000 42,500 Deferred Comp. Contribution 2,895 5,595 6,580 7,000 7,000 Travel/Training 4,494 5,979 8,688 6,500 6,500 Total:Benefits $58,277 77,215 83,373 86,200 89,150 UTIL- Utilities Telephone/Internet 819 947 1,269 1,000 1,000 Cellular Phones/Pagers 120 551 667 600 600 Total: UTIL-Utilities 939 1,498 1,936 1,600 1,600 SUPP-Supplies and Commodities Office Supplies/Postage 969 774 518 1,500 1,500 Dues &Subscriptions 613 928 7,804 9,000 9,000 Gas/Oil/Mileage/Carwash 282 303 341 1,200 1,200 Total:Supplies&Commodities 1,864 2,005 8,663 11,700 11,700 Contrac-Contractual Services Public Relations 10,627 11,134 4,149 12,300 12,300 Contractual Services 6,463 4,128 5,473 8,000 8,000 Total:Contractual Services $17,090 15,262 9,622 20,300 20,300 Total:06-Human Re source s k 10 11,II ,i,ii,,, General FundI...-.I-it..-I I ............... . ISI PLAINFIELD Administration/Finance Detail 2020-2021 Fiscal Year Budget FY 2020 FY 2021 FY 2017 FY 2018 FY 2019 Adopted Proposed Description Actual Actual Actual Budget Budget Division:08- IT Program SAL-Salaries and Wages Salaries-Full Time 222,850 241,013 245,653 252,000 365,000 Salaries-Overtime 179 0 0 500 500 Total:Salaries and Wages $223,029 $241,013 $245,653 $252,500 $365,500 BEN - Benefits FICA 13,700 14,804 15,004 15,600 22,500 Medicare 3,204 3,462 3,509 3,660 5,300 IMRF 25,141 26,929 26,162 29,000 40,000 Employee Insurance 39,121 39,617 42,083 46,000 60,000 Deferred Comp. Contribution 8,525 8,540 6,926 9,500 9,000 Travel/Conventions/Training 19,186 14,951 12,046 14,500 17,000 Total: Benefits $108,877 $108,303 $105,730 $118,260 $153,800 UTIL- Utilities Telephone/Internet 409 474 669 500 500 Cellular Phones/Pagers 2,211 2,448 2,657 3,000 3,700 Total: UTIL-Utilities 2,620 2,922 3,326 3,500 4,200 SUPP-Supplies and Commodities Office Supplies/Postage 1,425 1,759 1,869 1,400 1,400 Dues &Subscriptions 539 484 675 700 700 Gas/Oil/Mileage/Carwash 275 630 340 400 400 Uniforms 0 303 368 300 500 Total:Supplies&Commodities 2,239 3,176 3,252 2,800 3,000 Contrac-Contractual Services Software Licensing/Renewals 220,552 248,071 256,683 265,000 289,950 Contractual Services 8,366 17,810 16,611 16,300 56,100 Total:Contractual Services $228,918 $265,881 $273,294 $281,300 $346,050 OTHER-Other Server/Network Supplies 33,661 49,883 55,355 58,700 74,300 Computers 10,469 11,317 22,796 25,000 25,000 Total: OTHER-Other $44,130 61,200 78,151 83,700 99,300 6 .aha ,,, s. I Transfers Transfer to Capital 2,189,567 532,831 1,359,212 450,000 0 Total:Transfer y t Total:Administration/Finance 8,534,402 $7,445,410 $8,367,812 $7,741,100 $7,794,955 11 aloft•••11, V"IP,, General Fund 1--1 '1 1 1-iN 1 uM1 ...li/ PLAINFIELD Planning Division Summary 2020-2021 Fiscal Year Budget FY 2020 FY 2021 FY 2016 FY 2017 FY 2018 FY 2019 Adopted Proposed Classification Actual Actual Actual Actual Budget Budget Fund: 01 - General Fund Expenditures Unit: 09 - Community Development Division: 20 - Planning Program Salaries and Wages 256,570 288,831 343,473 347,822 366,000 381,000 Benefits 106,885 110,520 150,362 154,115 165,500 171,600 Utilities 2,766 3,214 3,276 4,146 4,800 4,800 Supplies and Commodities 11,964 15,206 20,465 26,728 15,750 15,750 Contractual Services 2,217 12,801 32,415 61,036 55,000 55,000 Total: 20 - Planning Program $380,402 $430,572 $549,991 $593,847 $607,050 $628,150 Planning Division Expense History 700,000 600,000 Contractual Services 500,000 Supplies and Commodities I $400,000 Utilities 300,000 ( Benefits 200,000 11111 IIII Salaries and Wages 100,000 0 3__.. s a... FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Actual Actual Actual Actual Adopted Proposed Budget Budget 12 1Uti wwwu w w „wwiw,,General Fund wi.w...w w ,.-u.q$..grs_I www PLAIwNFIELD Planning Division Detail 2020-2021 Fiscal Year Budget FY 2020 FY 2021 FY 2017 FY 2018 FY 2019 Adopted Proposed Description Actual Actual Actual Budget Budget Fund:01- General Fund Expenditures Unit:09-Community Development Division: 20- Planning Program SAL-Salaries and Wages Salaries-Full Time 283,526 338,816 343,839 360,000 375,000 Salaries-Overtime 2,460 1,867 2,845 2,500 2,500 Salaries-Commissioner 2,845 2,790 1,138 3,500 3,500 Total:Salaries and Wages $288,831 $343,473 $347,822 $366,000 $381,000 BEN - Benefits FICA 17,020 20,877 21,162 22,700 23,500 Medicare 3,980 4,883 4,949 5,300 5,500 IMRF 31,198 38,123 37,018 41,000 41,100 Employee Insurance 51,716 72,259 76,347 79,000 84,000 Deferred Comp. Contribution 3,400 5,371 5,420 8,500 8,500 Travel/Training 2,567 7,965 8,341 8,000 8,000 IL Unemployment Insurance 639 884 878 1,000 1,000 Total: Benefits $110,520 $150,362 $154,115 $165,500 $171,600 UTIL- Utilities Telephone/Internet 2,047 2,400 3,173 3,000 3,000 Cellular Phones/Pagers 1,167 876 973 1,800 1,800 Total:Utilities 3,214 3,276 4,146 4,800 4,800 SUPP-Supplies and Commodities Office Supplies/Postage 11,812 15,490 22,702 10,000 10,000 Dues&Subscriptions 3,394 4,927 3,776 5,000 5,000 Gas/Oil/Mileage/Carwash 0 48 250 750 750 Total:Supplies&Commodities $15,206 20,465 26,728 15,750 15,750 Contrac-Contractual Services Maintenance Contracts/Lease 600 600 550 2,000 2,000 Vehicle Maintenance 0 0 0 1,000 1,000 Legal Notices 0 0 0 5,000 5,000 Legal Fees 2,354 2,801 4,199 4,000 4,000 Special Projects and Programs 3,709 15,150 9,924 15,000 15,000 Contractual Services 1,692 1,919 30,913 20,000 20,000 Engineering Fees 4,446 11,945 15,450 8,000 8,000 Total:Contractual Services $12,801 32,415 61,036 55,000 55,000 Total:20-Planning Program $430,572 $549,991 $593,847 $607,050 $628,150 13 r;,,, General Fund i Iii PLAINFIELD Building Division Summary 2020-2021 Fiscal Year Budget FY 2020 FY 2021 FY 2016 FY 2017 FY 2018 FY 2019 Adopted Proposed Classification Actual Actual Actual Actual Budget Budget Fund: 01 - General Fund Expenditures Unit: 09 -Community Development Division: 21 - Building Program Salaries and Wages 402,711 438,346 579,510 645,504 668,000 638,000 Benefits 155,893 197,534 269,032 296,055 334,175 325,000 Utilities 4,693 3,909 4,278 4,621 5,500 5,500 Supplies and Commodities 10,204 8,164 9,710 7,489 18,900 15,900 Contractual Services 35,247 7,590 3,166 10,496 23,000 13,000 Total Building Program $608,748 $655,543 $865,696 $964,165 $1,049,575 $997,400 Building Division Expense History 1,200,000 3 1,000,000 Contractual Services I Supplies and Commodities 800,000 Utilities I Benefits 600,000 III IIII II Salaries and Wages 400,000 E 200,000 ----III III 1111 I j 0 3 3 -E FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Actual Actual Actual Actual Adopted Proposed Budget Budget 14 General Fund PLA MITE LD Building Division Detail 2020-2021 Fiscal Year Budget FY 2020 FY 2021 FY 2017 FY 2018 FY 2019 Adopted Proposed Description Actual Actual Actual Budget Budget Fund:01- General Fund Expenditures Unit:09-Community Development Division: 21- Building Program SAL-Salaries and Wages Salaries-Full Time 431,841 578,507 642,943 665,000 635,000 Salaries-Part Time 6,364 0 0 0 0 Salaries-Overtime 141 1,003 2,561 3,000 3,000 Total:SAL-Salaries and Wages $438,346 $579,510 $645,504 $668,000 $638,000 BEN -Benefits FICA 26,489 34,478 38,083 41,500 40,000 Medicare 6,195 8,063 8,906 9,700 9,500 IMRF 49,418 64,335 67,963 76,475 72,000 Employee Insurance 97,664 138,327 152,094 185,000 175,000 Deferred Comp. Contribution 8,257 8,674 16,344 10,000 15,000 Travel/Training 8,511 13,655 11,188 10,000 12,000 IL Unemployment Insurance 1,000 1,500 1,477 1,500 1,500 Total: Benefits $197,534 $269,032 $296,055 $334,175 $325,000 UTIL-Utilities Telephone/Internet 409 538 810 1,000 1,000 Cellular Phones/Pagers 3,500 3,740 3,811 4,500 4,500 Total: Utilities 3,909 4,278 4,621 5,500 5,500 SUPP-Supplies and Commodities Office Supplies/Postage 7,112 7,831 6,265 13,000 10,000 Dues&Subscriptions 520 564 675 4,000 4,000 Gas/Oil/Mileage/Carwash 32 818 57 1,000 1,000 Uniforms/Clothing 500 497 492 900 900 Total:Supplies&Commodities 8,164 9,710 7,489 18,900 15,900 Contrac-Contractual Services Recording Fees 0 1,720 1,079 3,000 3,000 Contractual Services 7,590 1,446 9,417 20,000 10,000 Total:Contractual Services 7,590 3,166 10,496 23,000 13,000 Total:21-Building Program $655,543 $865,696 $964,165 $1,049,575 $997,400 15 la.,. IliruMAM ...riii,,General Fund1.-I.»•I 1 I-q.q.....i.i. I lit PLAINFIELD Streets Division Summary 2020-2021 Fiscal Year Budget FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Actual Actual Actual Actual Adopted Proposed Classification Budget Budget Fund: 01 - General Fund Expenditures Unit: 08-Street Division Salaries and Wages 1,376,325 1,410,078 1,566,120 1,644,082 1,668,635 1,719,000 Benefits 566,772 581,553 626,529 659,144 719,600 721,900 Utilities 344,406 287,349 290,125 249,654 283,500 253,500 Supplies and Commodities 386,303 355,609 424,591 496,484 451,300 536,300 Contractual Services 699,719 636,567 956,824 929,129 921,000 1,006,000 Total Street Division $3,373,525 $3,271,156 $3,864,189 $3,978,493 $4,044,035 $4,236,700 Streets Division Expense History 4,500,000 4,000,000 Contractual Services 3,500,000 Supplies and Commoditiesim3,000,000 En IN 1111 MI utilities 2,500,000 MI 11111 Benefits111111111111112,000,000 all IIIIIIIIII all al Salaries and Wages 1,500,000 in al IN Elli 11111,000,000 AI IIIII 1111 1111500,000 NI NI al0IIII FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Actual Actual Actual Actual Adopted Proposed Budget Budget 16 General FundI...m-0.e j-III PLAINFIELD Streets Division Detail 2020-2021 Fiscal Year Budget FY 2020 FY 2021 FY 2017 FY 2018 FY 2019 Adopted Proposed Description Actual Actual Actual Budget Budget Fund:01- General Fund Expenditures Unit: 08-Street Department Division:02-Administration Program SAL-Salaries and Wages Salaries-Full Time 272,912 286,073 351,002 375,135 390,000 Total:Salaries and Wages $272,912 $286,073 $351,002 $375,135 $390,000 BEN - Benefits FICA 16,763 17,845 21,110 23,500 24,500 Medicare 4,078 4,285 5,062 5,500 5,700 IMRF 31,773 33,185 37,925 43,200 43,200 Employee Insurance 51,855 53,141 69,871 80,000 85,000 Deferred Comp. Contribution 8,716 8,023 9,433 9,500 10,000 Travel/Conventions/Training 9,710 9,506 12,212 10,000 10,000 IL Unemployment Insurance 3,652 4,696 4,000 4,500 4,500 Total: Benefits $126,547 $130,681 $159,613 $176,200 $182,900 UTIL- Utilities Telephone/Internet 22,891 27,957 31,749 25,000 25,000 Cellular Phones/Pagers 7,348 7,808 8,948 8,500 8,500 Total: UTIL-Utilities $30,239 35,765 40,697 33,500 33,500 SUPP-Supplies and Commodities Office Supplies/Postage 3,583 2,935 5,237 3,000 3,000 Dues &Subscriptions 2,968 2,533 2,881 3,000 3,000 Gas/Oil/Mileage/Carwash 80 120 318 300 300 Supplies/Hardware 0 200 705 500 500 Total:Supplies&Commodities 6,631 5,788 9,141 6,800 6,800 Contrac- Contractual Services Building Maintenance 6,476 8,488 7,124 20,000 20,000 Legal Notices 0 0 0 1,000 1,000 Total:Contractual Services 6,476 8,488 7,124 21,000 21,000 17 i. .... General Funda,.„_., . ;-„a.,....,.,• , ill PLAIINFIELD Streets Division Detail 2020-2021 Fiscal Year Budget FY 2020 FY 2021 FY 2017 FY 2018 FY 2019 Adopted Proposed Description Actual Actual Actual Budget Budget Division: 60-Street Maintenance Program SAL-Salaries and Wages Salaries-Full Time 721,757 792,901 813,414 832,500 860,000 Salaries-Part Time 62,433 77,421 71,643 70,000 75,000 Salaries-Overtime 106,836 127,378 134,402 90,000 100,000 Total:Salaries and Wages $891,026 $997,700 $1,019,459 $992,500 $1,035,000 BEN - Benefits FICA 52,747 58,850 60,326 62,000 63,500 Medicare 12,336 13,763 14,109 15,000 15,000 IMRF 91,864 100,729 98,715 104,000 105,000 Employee Insurance 173,326 187,138 199,481 210,000 215,500 Deferred Comp. Contribution 21,869 21,893 21,725 25,000 25,000 Total: Benefits $352,142 $382,373 $394,356 $416,000 $424,000 UTIL- Utilities Electricity/Gas 257,110 254,360 208,957 250,000 220,000 Total: Utilities $257,110 $254,360 $208,957 $250,000 $220,000 SUPP-Supplies and Commodities Gas/Oil/Mileage/Carwash 53,295 62,695 51,796 65,000 65,000 Supplies/Hardware 11,681 17,984 17,352 15,000 15,000 Supplies-Salt Purchase 232,041 274,578 356,106 300,000 385,000 Street Sign Maintenance 29,486 41,345 37,318 40,000 40,000 Aggregate Materials 5,240 4,480 2,711 4,000 4,000 Uniforms/Clothing 10,439 8,347 10,428 10,000 10,000 Total:Supplies&Commodities $342,182 $409,429 $475,711 $434,000 $519,000 Contrac-Contractual Services Radio Maintenance 1,692 2,383 3,956 5,000 5,000 Vehicle Maintenance 25,637 20,497 26,194 35,000 35,000 Street Light Maintenance 113,358 116,194 94,787 115,000 115,000 Street Maintenance 115,168 80,740 97,537 130,000 140,000 Storm Sewer Improvements 1,491 11,446 16,940 15,000 20,000 Contractual Services 108,462 72,004 95,073 115,000 120,000 Contractual Snow Removal 169,521 539,611 468,986 350,000 400,000 Sidewalk Maintenance 1,497 0 0 5,000 5,000 Equipment Maintenance 77,488 83,503 105,630 90,000 100,000 Total:Contractual Services $614,314 $926,378 $909,103 $860,000 $940,000 i r 2,952,500 $ 18 tilll un . u ti,t General Fund j-.f...f 1 f•If.lsuq+f+ (111 PLAINFIELD Streets Division Detail 2020-2021 Fiscal Year Budget FY 2020 FY 2021 FY 2017 FY 2018 FY 2019 Adopted Proposed Description Actual Actual Actual Budget Budget Division: 62- Forestry Program SAL-Salaries and Wages Salaries-Full Time 49,733 73,478 74,795 82,000 83,000 Salaries-Overtime 6,677 7,249 7,219 6,000 8,000 Total:Salaries and Wages $56,410 80,727 82,014 88,000 91,000 BEN - Benefits FICA 3,635 5,239 5,558 5,500 6,000 Medicare 850 1,225 1,300 1,300 1,400 IMRF 6,754 9,671 9,785 10,000 10,000 Employee Insurance 11,057 13,100 13,719 19,000 15,000 Deferred Comp. Contribution 1,817 2,889 2,253 3,000 3,000 Total: Benefits $24,113 32,124 32,615 38,800 35,400 SUPP-Supplies and Commodities Supplies/Hardware 6,796 9,374 11,557 10,000 10,000 Uniforms/Clothing 0 0 75 500 500 Total:Supplies&Commodities 6,796 9,374 11,632 10,500 10,500 Contrac-Contractual Services Tree Removal 11,865 11,009 11,765 20,000 20,000 Contractual Services 3,912 10,949 1,137 20,000 25,000 Total:Contractual Services $15,777 21,958 12,902 40,000 45,000 Division: 63-Vehicle Maintenance Program SAL-Salaries and Wages Salaries-Full Time 186,525 194,308 183,376 205,000 195,000 Salaries-Overtime 3,205 7,312 8,231 8,000 8,000 Total:Salaries and Wages $189,730 $201,620 $191,607 $213,000 $203,000 BEN - Benefits FICA 11,275 12,136 11,381 13,500 12,600 Medicare 2,637 2,838 2,662 3,100 3,000 IMRF 21,387 22,779 20,495 23,500 21,500 Employee Insurance 37,236 37,343 34,877 41,000 35,000 Deferred Comp. Contribution 6,216 6,255 3,145 7,500 7,500 Total: Benefits $78,751 81,351 72,560 88,600 79,600 Total:Street Division 3,271,156 $3,864,189 $3,978,493 $4,044,035 $4,236,700 19 lull i-t""'' 12"i-!. General FundI , ....4..,..-,.,.1 111 PLAINFIELD Revenue & Expense Summary 2020-2021 Fiscal Year Budget FY 2020 FY 2021 FY 2017 FY 2018 FY 2019 Adopted Proposed Classification Actual Actual Actual Budget Budget Fund: 01 - General Fund Revenues Property Taxes 5,220,898 5,538,793 5,929,329 6,233,500 6,919,900 State of Illinois Taxes 10,126,278 10,334,450 10,870,272 10,640,000 10,905,000 Other Taxes 969,144 1,106,952 1,124,341 1,158,500 1,107,800 Licenses & Permits 1,166,151 1,094,102 1,318,572 1,132,200 1,163,200 Fines and Forfeits 662,328 641,082 611,677 705,500 708,000 Charges for Services 4,535,305 4,761,507 4,927,437 5,083,700 5,305,000 Grants 38,749 56,545 147,994 35,750 35,750 Franchise Fees 742,997 676,567 658,354 690,000 625,000 Investment Income 78,688 116,511 270,129 126,326 185,000 Miscellaneous 284,574 712,604 409,787 126,500 137,500 Intergovernmental 445,881 467,448 452,080 490,000 475,000 Interfund Transfers 12,000 18,000 25,000 225,000 225,000 Vi574497ez _ A s Expenses Administration/Finance 8,534,402 7,445,410 8,367,812 7,741,100 7,794,955 Police Department 11,363,331 11,913,161 12,686,110 13,205,216 14,295,337 Street Department 3,271,156 3,864,189 3,978,493 4,044,035 4,236,700 Planning Program 430,572 549,991 593,847 607,050 628,150 Building Program 655,543 865,696 964,165 1,049,575 997,400 24,255,0Q4 $ hf 26,64M70,976 Total: General Fund 27,989 $886,114 $154,545 0 ($160,392) Revenue History by Type30,000,000 Interfund Transfers 25,000,000 Intergovernmental LI a Miscellaneous 20,000,000 MI" ii Investment Income 15,000,000 Franchise FeesIII 1111 Grantsan 10,000,000 1111 Charges for Services 1111 Fines and Forfeits 5,000,000 1111 1111 1111 OtherLicensesTaxes& Permits 0 FY 2017 Actual FY 2018 Actual FY 2019 Actual FY 2020 FY 2021 Adopted Proposed f Budget Budget 20 sa, .. iii III".tit,, General FundTim 1--1.,.II I II-UII '•I'I' 1 111 VILLAGE OE PLAINFIELD Revenue Detail 2020-2021 Fiscal Year Budget FY 2020 FY 2021 FY 2017 FY 2018 FY 2019 Adopted Proposed Description Actual Actual Actual Budget Budget Fund:01 - General Fund Revenues PROPTX - Property Taxes Property Tax Revenue 3,186,940 3,238,347 3,607,982 4,018,500 4,414,900 Property Tax Rev-Road & 357,161 362,941 377,733 375,000 375,000 Property Tax-Police Pen 1,101,142 1,364,479 1,402,475 1,300,000 1,580,000 Property Tax Rev-IMRF 575,655 573,026 541,139 540,000 550,000 Total: Property Taxes $5,220,898 $5,538,793 $5,929,329 $6,233,500 $6,919,900 STTAX-State of Illinois Taxes Municipal Sales Tax 5,354,048 5,642,698 5,754,207 5,900,000 6,000,000 Illinois Income Tax 3,741,387 3,589,279 3,842,879 3,600,000 3,750,000 Replacement Tax 56,645 55,764 48,665 55,000 55,000 Local Use Tax 974,198 1,046,709 1,224,521 1,085,000 1,100,000 Total:State of Illinois Taxes $10,126,278 $10,334,450 $10,870,272 $10,640,000 $10,905,000 OTHTX-Other Taxes Hotel/Motel Tax 199 1,438 1,097 1,500 800 Amusement Tax 9,893 8,220 7,168 7,000 7,000 Local Motor Fuel Tax 959,052 1,097,294 1,116,076 1,150,000 1,100,000 Total: Other Taxes $969,144 $1,106,952 $1,124,341 $1,158,500 $1,107,800 LIC&PER- Licenses and Permits Liquor License 103,568 112,919 103,150 100,000 100,000 Contractors License 47,200 50,100 44,400 45,000 45,000 Cigarette License 7,000 6,500 8,000 6,000 6,000 Scavenger License 100 100 100 200 200 Business License 37,788 40,488 41,438 40,000 40,000 Building Permit 952,317 855,481 1,087,619 925,000 950,000 Sign Permit 7,763 4,394 3,895 5,000 5,000 Special Movement Permit 8,630 21,950 26,540 10,000 15,000 Solicitors Permit 1,785 2,170 3,430 1,000 2,000 Total: Licenses& Permits $1,166,151 $1,094,102 $1,318,572 $1,132,200 $1,163,200 FIN - Fines and Forfeits Will County Court Fines 367,797 319,256 353,322 325,000 330,000 Aministrative Fines(P-Tkts) 135,528 128,239 179,769 135,000 135,000 Aministrative Fines - Late fees 9,960 8,940 9,020 10,000 9,000 Asset Seizure 100,190 51,270 43,815 225,000 225,000 Alarm Fees 2,025 3,100 650 3,000 1,000 Kendall County Court Fines 1,166 2,228 2,213 1,500 2,000 21 General Fundi/Irt tuns ni u1Ln I-/ 1 I 1 "11 IIR uI'I'.1.111 VILLAGE OF PLAINFIELD Revenue Detail 2020-2021 Fiscal Year Budget FY 2020 FY 2021 FY 2017 FY 2018 FY 2019 Adopted Proposed Description Actual Actual Actual Budget Budget Fund: 01- General Fund Revenues (continued) Asset Seizure (DO1) 44,741 128,049 22,888 5,000 5,000 Asset Seizure (US Treas) 921 0 0 1,000 1,000 Total: Fines and Forfeits $662,328 $641,082 $611,677 $705,500 $708,000 SERV- Charges for Services Garbage Fee 3,992,763 4,157,777 4,320,878 4,475,000 4,665,000 Garbage Penalties 55,336 55,380 55,301 50,000 55,000 Engineering Services 33,590 13,375 0 15,000 5,000 Zoning Applications 13,162 28,056 37,634 10,000 20,000 Accident Report Fees 4,585 5,876 5,969 4,500 5,000 Copies-Maps & Ordinances 2,367 2,639 2,512 2,000 2,000 Impound Fee 22,853 26,250 32,762 25,000 25,000 Parking Lot Revenue 4,532 1,950 8,566 4,000 4,000 Tower Rent 38,191 41,837 42,910 45,000 45,800 Rental Income 45,100 49,200 49,200 49,200 49,200 Rental-Community/Multi 4,547 4,259 3,740 4,000 4,000 Special Detail/OT 68,279 124,908 117,965 50,000 75,000 Water & Sewer Service 250,000 250,000 250,000 350,000 350,000 Total:Charges for Services $4,535,305 $4,761,507 $4,927,437 $5,083,700 $5,305,000 GRNTS- Grants Grant Revenue 17,545 20,698 98,848 0 0 Bulletproof Vest Grant 3,415 5,325 3,425 3,000 3,000 Tobacco Grant 2,750 1,375 2,750 2,750 2,750 Traffic Grant 15,039 29,147 42,971 30,000 30,000 Total:Grants $38,749 56,545 $147,994 35,750 35,750 FRAN - Franchise Fees AT&T Franchise Payment 209,381 153,127 126,384 160,000 125,000 Cable TV- Franchise 533,616 523,440 531,970 530,000 500,000 Total: Franchise Fees $742,997 $676,567 $658,354 $690,000 $625,000 INT- Investment Income Interest Income 88,416 124,418 225,089 126,326 185,000 Realized Gain/Loss 17 14,898 829)0 0 Unrealized Gain/Loss 9,745)22,805) 45,869 0 0 Total: Investment Income $78,688 $116,511 $270,129 $126,326 $185,000 22 f.. .i.„,-"I, nwii,,`, General Fund VILLAGE OF PLAINFIELD Revenue Detail 2020-2021 Fiscal Year Budget FY 2020 FY 2021 FY 2017 FY 2018 FY 2019 Adopted Proposed Description Actual Actual Actual Budget Budget Fund:01 - General Fund Revenues (continued) MISC- Miscellaneous Event Sponsorship Program 4,097 4,950 5,729 4,000 5,000 Amphitheater Rent 200 1,375 250 500 500 Restitution Program 9,700 0 0 0 0 Donation/Contribution 16,377 20,772 17,083 15,000 15,000 Sales-Fixed Assets 3,769 4,500 0 2,000 2,000 Liability Write Off 151,127 453,380 238,525 0 0 Other Reimbursements 86,085 210,915 99,015 80,000 90,000 Other Receipts 13,219 16,712 49,185 25,000 25,000 Total: Miscellaneous $284,574 $712,604 $409,787 $126,500 $137,500 INTERGOV- Intergovernmental School Liaison 431,373 454,895 441,774 475,000 465,000 HIDTA/Organized Crime 14,508 12,553 10,306 15,000 10,000 Total: Intergovernmental $445,881 $467,448 $452,080 $490,000 $475,000 INTER - Interfund Transfers Transfer From MFT 0 0 0 150,000 150,000 Transfer From TIF 0 0 0 50,000 50,000 Transfer From Alcohol Enforc. 12,000 18,000 25,000 25,000 25,000 Total: Interfund Transfers $12,000 18,000 25,000 $225,000 $225,000 Revenues Total $24,282,993 $25,524,561 $26,744,972 $26,646,976 $27,792,150 23 8a E. ,il..,*".,. -:,.qi$.1 Miscellaneous Funds PLAINFIELD Revenue & Expenses by Fund Summary 2020-2021 Fiscal Year Budget Downtown Rt.30 Other MFT Bond and Tort Audit Police DARE TIF TIF Alcohol Funds Fund Interest Immunity Fund Pension Fund Fund Fund Enforcement Totals REVENUES Property Taxes 150,000 30,000 730,000 1,000 911,000 State of Illinois Taxes 1,575,000 1,575,000 Fines And Forfeits 15,000 15,000 Interest Income 75,000 8,000 5,000 400 1,150,000 100 10,000 50 500 1,249,050 Other Employer Contributions 1,580,000 - 1,580,000 Employee Contributions 620,000 - 620,000 DARE Contributions 20,000 20,000 Interfund Transfers 3,014,800 3,014,800 Total 1,650,000 3,022,800 155,000 30,400 3,350,000 20,100 740,000 1,050 15,500 8,984,850 EXPENDITURES Salaries&Wages 700,000 - 700,000 Benefits 5,000 - 5,000 Supplies/Commodities 7,500 23,000 30,500 Contractual Services 450,336 42,000 35,000 - 527,336 Other Debt Service 3,014,800 3,014,800 Capital Outlay 1,500,000 540,000 2,040,000 Miscellaneous 115,000 - 115,000 Interfund Transfers 150,000 550,000 25,000 725,000 Total 1,650,000 3,014,800 450,336 42,000 862,500 23,000 1,090,000 25,000 7,157,636 EXCESS/(DEFICIENCY) 8,000 (295,336) (11,600) 2,487,500 (2,900) (350,000) 1,050 9,500) 1,827,214 24 a.„ aim M III t% Motor Fuel Tax Fund 1 I -1u'I',+j PLAINFIELD Revenue & Expense Detail 2020-2021 Fiscal Year Budget FY 2020 FY 2020 FY 2021 Adopted Estimated Proposed Description 2017 Actual 2018 Actual 2019 Actual Budget Amount Budget Fund:04-Motor Fuel Tax Revenues State of Illinois Taxes MFT Entitlements 1,105,594 1,110,842 1,103,351 1,100,000 1,380,000 1,575,000 Total:State of Illinois Taxes $1,105,594 $1,110,842 $1,103,351 $1,100,000 $1,380,000 $1,575,000 Investment Income Interest Income 15,411 38,101 72,787 50,000 80,000 75,000 Total:Investment Income 15,411 $38,101 $72,787 $50,000 $80,000 $75,000 i5 $1,148,945 $1 176138` Expenditures Division:91-Capital Street Improvements 863,120 1,052,089 875,331 1,000,000 1,000,000 1,500,000 Total:Other 863,120 $1,052,089 $875,331 $1,000,000 $1,000,000 $1,500,000 Division Total:91-Capital 863,120 $1,052,089 $875,331 $1,000,000 $1,000,000 $1,500,000 Division:99-Transfers Transfer to General 0 0 0 150,000 150,000 150,000 Total:99-Transfers 0 0 0 $150,000 $150,000 $150,000 Total: Non-Departmental 863,120 $1,052,089 $875,331 $1,150,000 $1,150,000 $1,650,000 Total 863,120 $1,02,085 0-45 ,000 $1,150,000 44t8UWt Total:04-Motor Fuel Tax 257,885 $96,854 $300,807 0 $310,000 0 MFT has a 4/30/19 Fund Balance of$3,474,726 MFT Revenue History 1,700,000 1,600,000 1,500,000 1,400,000 1,300,000 MFT 1,200,000 - Entitlements 1,100,000 1,000,000 2017 Actual 2018 Actual 2019 Actual FY 2020 FY 2021 Adopted Proposed Budget Budget 25 L,. Bond & Interest Fund PLAINFIELD Revenue & Expense Detail 2020-2021 Fiscal Year Budget FY 2020 FY 2020 FY 2021 FY 2017 FY 2018 FY 2019 Adopted Estimated Proposed Description Actual Actual Actual Budget Amount Budget Fund:05- Bond and Interest Fund Revenues Property Taxes Property Tax Revenue 117,214 118,519 118,114 114,400 114,000 0 Total:Property Taxes 117,214 $118,519 $118,114 $114,400 $114,000 0 Investment Income Interest Income 798 6,287 12,403 8,000 12,000 8,000 Total: Investment Income 798 6,287 $12,403 8,000 $12,000 8,000. Interfund Transfers Transfer From Water&Sewer 970,900 979,300 976,800 981,000 981,000 983,800 Transfer From Capital 2,032,264 2,023,992 2,018,731 2,035,850 2,035,850 2,031,000 Total: Interfund Transfers 3,003,164 $3,003,292 $2,995,531 $3,016,850 $3,016,850 $3,014,800 Bond & Interest Revenue History 3,500,000 3,000,000 w,® 2,500,000 2,000,000 1,500,000 =_ 4--Property Tax Revenue 1,000,000 500,000 Interfund Transfers 0 - FY 2017 ActualFY 2018 ActualFY 2019 Actual FY 2020 FY 2021 Adopted Proposed Budget Budget 26 Bond & Interest Fund 1-.1...1 1 1-Ilitl iqh 1 III PLAINFIELD Revenue & Expense Detail 2020-2021 Fiscal Year Budget FY 2020 FY 2020 FY 2021 FY 2017 FY 2018 FY 2019 Adopted Estimated Proposed Description Actual Actual Actual Budget Amount Budget Expenditures Unit: 00- Non-Departmental Division:92 - Bonds OTHER-Other 2007 Bond (Principal) 725,000 755,000 170,000 0 0 0 2007 Bond (Interest) 75,100 42,475 8,500 0 0 0 2009 Refunding Bond(Princ) 100,000 100,000 105,000 110,000 110,000 0 2009 Refunding Bond (Int) 16,100 12,600 8,600 4,400 4,400 0 2010 Bond (Principal) 720,000 750,000 770,000 805,000 805,000 840,000 2010 Bond (Interest) 250,900 229,300 206,800 176,000 176,000 143,800 2012 Refunding Bond (Princ) 645,000 660,000 680,000 695,000 695,000 715,000 2012 Refunding Bond (Int) 188,100 175,200 155,400 135,000 135,000 114,150 2014 Refunding Bond (Princ) 125,000 130,000 750,000 950,000 950,000 965,000 2014 Refunding Bond (Int) 275,950 273,450 270,850 255,850 255,850 236,850 Total:OTHER-Other 3,121,150 $3,128,025 $3,125,150 $3,131,250 $3,131,250 $3,014,800 Expenditures Total -- $3,121 15Q $3,128,025 $3,125,150 „$3331250 $101.411 : 31, &809, Total: Bond & Interest 26 73 898 8,000 $11,600 8,000 27 signs ni- Tort Immunity FundIPttu-t+t• t III PLA I1 ELD Revenue & Expense Detail 2020-2021 Fiscal Year Budget FY 2020 FY 2020 FY 2021 FY 2017 FY 2018 FY 2019 Adopted Estimated Proposed Description Actual Actual Actual Budget Amount Budget Fund: 07-Tort Immunity Fund Revenues Property Taxes Property Tax Revenue 621,535 623,114 491,668 400,000 395,500 150,000 Total: Property Taxes 621,535 $623,114 $491,668 $400,000 $395,500 $150,000 Investment Income Interest Income 165 2,447 8,101 3,000 8,000 5,000 Total: Investment Income 165 $2,447 $8,101 $3,000 $8,000 5,000 MISC- Miscellaneous Other Reimbursements 55 0 451 0 0 0 Total: Miscellaneous 55 0 451 0 0 0 Revenues Total 621,755 $625,561 $500,220 $403,000 $403,500 $155,000 Expenditures Unit: 00- Non-Departmental Contractual Services Bond-Treasurer 336 336 336 500 336 336 Comm. Umbrella Liability 268,633 157,858 170,959 200,000 156,000 200,000 Workman's Comp. Ins. 325,852 221,340 180,488 250,000 190,000 250,000 Total:Contractual Services 594,821 $379,534 $351,783 $450,500 $346,336 $450,336 Expenditures Tot„ 94,821 $379,534 $351,783 50,500 $346,336 .,450r336 Total: Tort Immunity Fund 26,934 $246,027 $148,437 ($47,500) $57,164 ($295,336) Tort Immunity Fund has a 4/30/19 Fund Balance of$442,523 Tort Immunity Revenue History 700,000 600,000 500,000 400,000 Property Tax Revenue 300,000 200,000 100,000 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Actual Actual Actual Adopted Proposed Budget Budget 28 r, Audit Fund PLAII NFIELD Revenue & Expense Detail 2020-2021 Fiscal Year Budget FY 2020 FY 2020 FY 2021 FY 2017 FY 2018 FY 2019 Adopted Estimated Proposed Description Actual Actual Actual Budget Amount Budget Fund:08-Audit Fund Revenues Property Taxes Property Tax Revenue 42,252 42,274 44,169 35,000 35,800 30,000 Total: Property Taxes 42,252 $42,274 $44,169 $35,000 $35,800 $30,000 Investment Income Interest Income 72 236 532 400 500 400 Total: Investment Income 72 236 532 400 500 400 Revenues 4 $42,510 $44,7011 $35,400 ,-t-436,300,--k $30,400 Expenditures Unit:00- Non-Departmental Division: 00- Non-Divisional Contrac-Contractual Services Audit Village 39,142 35,875 38,085 42,000 40,000 42,000 Total:Contractual Services 39,142 $35,875 $38,085 $42,000 $40,000 $42,000 Expenditures Total r35875 $38,08. $42 000 2,000 Total: Audit Fund 3,182 $6,635 $6,616 ($6,600) ($3,700) ($11,600) Audit Fund has a 4/30/19 Fund Balance of$22,593 Audit Fund Revenue History 50,000 i 45,000 40,000 35,000 111PropertyTax Revenue 30,000 25,000 20,000 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Actual Actual Actual Adopted Proposed Budget Budget 29 Oil it - " Police Pension Fund I.•.—. I I-tm....",.,. , ,,, PLAINFIELD Revenue & Expense Detail 2020-2021 Fiscal Year Budget FY 2020 FY 2020 FY 2021 FY 2017 FY 2018 FY 2019 Adopted Estimated Proposed Description Actual Actual Actual Budget Amount Budget Fund: 10- Police Pension Fund Revenues Investment Income Interest Income 784,140 1,200,928 1,219,956 700,000 700,000 700,000 Realized Gain/Loss 66,866) 80,837 339,712 150,000 150,000 150,000 Unrealized Gain/Loss 1,646,913 916,507 235,710 300,000 300,000 300,000 Total: Investment Income 2,364,187 $2,198,272 $1,795,378 $1,150,000 $1,150,000 $1,150,000 MISC- Miscellaneous Other Receipts 0 0 200 0 0 0 Employee Contributions 509,526 524,835 555,362 570,000 580,000 620,000 Employer Contributions 1,101,142 1,364,479 1,402,475 1,300,000 1,284,423 1,580,000 Total: Miscellaneous 1,610,668 $1,889,314 $1,958,037 $1,870,000 $1,864,423 $2,200,000 Revenues Yota 4,18 ,58 $x,73,415' $3,OO,t)00 $3,014,423' Police Pension Contribution History 1,800,000 1,600,000 1,400,000 1,200,000 1,000,000 S Employee Contributions 800,000 600, 000EmployerContributions 400,000 200,000 5i 0 _€1 9 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Actual Actual Actual Adopted Proposed Budget Budget i 30 w. Police Pension FundiiiIN yi w ,... "'atlt''' cm I ....".......i. , 111_ PLAI;NFIELD Revenue & Expense Detail 2020-2021 Fiscal Year Budget FY 2020 FY 2020 FY 2021 FY 2017 FY 2018 FY 2019 Adopted Estimated Proposed Description Actual Actual Actual Budget Amount Budget Expenditures Unit: 00- Non-Departmental Division: 00- Non-Divisional Salaries and Wages Pension Payments 442,742 494,765 510,423 625,000 640,000 700,000 Total:Salaries&Wages 442,742 $494,765 $510,423 $625,000 $640,000 $700,000 Benefits Travel/Training 4,170 3,197 7,153 5,000 7,200 5,000 Total: Benefits 4,170 3,197 7,153 5,000 7,200 5,000 Supplies and Commodities Office Supplies/Postage 0 0 0 500 200 500 Dues &Subscriptions 5,560 5,740 6,421 5,800 7,111 7,000 Total:Supplies&Commodities 5,560 5,740 6,421 6,300 7,311 7,500 Contractual Services Contractual Services 32,082 33,807 36,143 35,000 35,000 35,000 Total:Contractual Services 32,082 $33,807 $36,143 $35,000 $35,000 $35,000 Other Investment Expense 87,300 99,577 106,456 100,000 115,000 115,000 Total: OTHER-Other 87,300 $99,577 $106,456 $100,000 $115,000 $115,000 Total: Non-Divisional 571,854 $637,086 $666,596 $771,300 $804,511 $862,500 771,300 862,500 Total: Police Pension Fund 3,403,001 $3,450,500 $3,086,819 $2,248,700 $2,209,912 $2,487,500 31 i D.A.R.E. Fund11111Iln, __l,,ta1,, I-.I...I I I-II•lIU...I.I. I III PLAINFIELD Revenue & Expense Detail 2020-2021 Fiscal Year Budget FY 2020 FY 2020 FY 2021 FY 2017 FY 2018 FY 2019 Adopted Estimated Proposed Description Actual Actual Actual Budget Amount Budget Fund: 14- D.A.R.E. Fund Revenues Investment Income Interest Income 45 118 315 100 100 100 Total: Investment Income 45 118 315 100 100 100 Miscellaneous DARE Contributions 18,295 22,320 24,819 22,000 14,000 20,000 Total: Miscellaneous 18,295 $22,320 $24,819 $22,000 $14,000 $20,000 Revenues Total 18,340 $22,43, S22,1!, 14,10! -, $20,100 Expenditures Unit: 00- Non-Departmental Division: 00 - Non-Divisional D.A.R.E. Program 21,530 15,950 18,948 23,000 15,000 23,000 Total: Non-Divisional 21,530 $15,950 $18,948 $23,000 $15,000 $23,000 Expenditures T'otai" y A t------,- 7,,-' - Total: D.A.R.E. Fund 3,190) $6,488 $6,186 900) ($900) ($2,900) DARE Fund has a 4/30/19 Fund Balance of$12,240 IDARE Contribution History 30,000 25,000 20,000 15,000 DARE Contributions 10,000 5,000 0 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Actual Actual Actual Adopted Proposed Budget Budget 32 two ., Downtown Tax Increment Financing Fund PLAT FIELD Revenue & Expense Detail 2020-2021 Fiscal Year Budget FY 2020 FY 2020 FY 2021 FY 2017 FY 2018 FY 2019 Adopted Estimated Proposed Description Actual Actual Actual Budget Amount Budget Fund: 17-Tax Increment Financing Fund-Downtown Revenues Property Taxes Property Tax Revenue 736,922 718,508 726,816 730,000 730,500 730,000 Total: Property Taxes 736,922 $718,508 $726,816 $730,000 $730,500 $730,000 INT- Investment Income Interest Income 5,190 7,686 17,553 10,000 16,000 10,000 Total: Investment Income 5,190 7,686 $17,553 $10,000 $16,000 $10,000 74436 Expenditures Unit: 00- Non-Departmental Division: 91 - Capital Other Contractual Services 429,676 944,580 81,868 260,000 70,000 500,000 Facade Improvements 157,162 127,118 2,500 40,000 8,000 40,000 Total:Capital 586,838 $1,071,698 $84,368 $300,000 $78,000 $540,000 Division: 99-Transfers OTHER- Other Transfer to General Fund 0 0 0 50,000 50,000 50,000 Transfer to Capital Fund 500,000 0 500,000 500,000 500,000 500,000 Total:Transfers 500,000 0 $500,000 $550,000 $550,000 $550,000 838 - 0*t Total:Tax Increment Financing Fund ($344,726) ($345,504) $160,001 ($110,000) $118,500 ($350,000) TIF Fund has a 4/30/19 Fund Balance of$355,037 TIF Property Tax Revenue History 780,000 730,000 ------46"•...••-.....+ 680,000 630,000 580,000 s-Property Tax Revenue 530,000 480,000 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Actual Actual Actual Adopted Proposed Budget Budget 33 Ili It Cuoar.,a _. «, . Route 30 Tax Increment Financing Fund PLAINFIELD Revenue & Expense Detail 2020-2021 Fiscal Year Budget FY 2020 FY 2020 FY 2021 FY 2019 Adopted Estimated Proposed Description Actual Budget Amount Budget Fund: 18-Tax Increment Financing Fund -Rt 30 Revenues Property Taxes Property Tax Revenue 0 0 1,000 1,000 Total: Property Taxes 0 0 1,000 1,000 INT- Investment Income Interest Income 0 0 50 50 Total: Investment Income 0 0 50 50 Revenues Expenditures Unit: 00- Non-Departmental Division:91 - Capital Other Contractual Services 0 0 0 0 Total:Capital 0 0 0 0 Total:Tax Increment Financing Fund 0 0 1,050 1,050 Rt. 30 TIF Property Tax Revenue History 980,000 880,000 780,000 680,000 4—Property Tax Revenue 580,000 480,000 FY 2019 Actual FY 2020 Adopted FY 2021 Proposed Budget Budget 34 Irbil aim t- "n t Alcohol Enforcement Fund Oil. PLAINFIELD Revenue & Expense Detail 2020-2021 Fiscal Year Budget FY 2020 FY 2020 FY 2021 FY 2017 FY 2018 FY 2019 Adopted Estimated Proposed Description Actual Actual Actual Budget Amount Budget Fund: 27-Alcohol Enforcement Fund Revenues Fines and Forfeits Alcohol Fines 16,645 16,893 22,680 15,000 20,000 15,000 Total: Fines and Forfeits 16,645 $16,893 $22,680 $15,000 $20,000 $15,000 Investment Income Interest Income 207 562 1,164 500 1,000 500 Total: Investment Income 207 562 $1,164 500 $1,000 500 evenues Total r$17,455 $23,844 4 $15,500 Expenditures Unit: 00 - Non-Departmental Division: 99 -Transfers Other Transfer to General 12,000 18,000 25,000 25,000 25,000 25,000 Total: Other 12,000 $18,000 $25,000 $25,000 $25,000 $25,000 4urs Tot 12 00{ 5,01 000 :',$25A00 $25 004 Total:Alcohol Enforcement Fund 4,852 545) ($1,156) ($9,500) ($4,000) ($9,500) Alcohol Enforcement Fund has a 4/30/19 Fund Balance of$41,047 Alcohol Fines History 24,200 22,200 20,200 18,200 14N.16,200 14,200 e-Alcohol Fines 12,200 10,200 8,200 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Actual Actual Actual Adopted Proposed Budget Budget 35 Budget Performance Reportloanrrtnr •nr >tma., ,, I- -I I I I -II lII'iI'I' I III VILLAGE OF Fiscal Year to Date 12/05/19 PLAINFIELD Exclude Rollup Account Adopted Budget Amended Current Month YTD YTD Budget-YTD %Used/ Account Account Description Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year Total Fund 01-General Fund REVENUE 0400.401 Property Tax Revenue 4,018,500.00 00 4,018,500.00 00 00 4,044,281.93 (25,781.93) 101 3,607,982.47 0400.402 Property Tax Rev-Road&Bridge 375,000.00 00 375,000.00 00 00 376,378.14 1,378.14) 100 377,733.12 0400.403 Property Tax Rev-Police Pension 1,300,000.00 00 1,300,000.00 00 00 1,284,423.69 15,576.31 99 1,402,474.77 0400.404 Property Tax Revenue-IMRF 540,000.00 00 540,000.00 00 00 533,779.38 6,220.62 99 541,139.30 0450.451 Municipal Sales Tax 5,900,000.00 00 5,900,000.00 00 00 3,418,675.33 2,481,324.67 58 5,754,206.78 0450.452 Illinois Income Tax 3,600,000.00 00 3,600,000.00 00 00 2,610,326.78 989,673.22 73 3,842,879.11 0450.453 Replacement Tax 55,000.00 00 55,000.00 00 00 34,893.61 20,106.39 63 48,664.91 0450.455 Local Use Tax 1,085,000.00 00 1,085,000.00 00 00 726,841.95 358,158.05 67 1,224,520.85 0500.500 Hotel/Motel Tax 1,500.00 00 1,500.00 00 00 513.50 986.50 34 1,097.28 0500.501 Amusement Tax 7,000.00 00 7,000.00 00 00 2,691.48 4,308.52 38 7,168.08 0500.503 Local Motor Fuel Tax 1,150,000.00 00 1,150,000.00 00 00 635,593.30 514,406.70 55 1,116,076.09 0550.551 Liquor License 100,000.00 00 100,000.00 1,660.80 00 107,843.80 7,843.80) 108 103,149.90 0550.552 Contractors License 45,000.00 00 45,000.00 350.00 00 36,850.00 8,150.00 82 44,400.00 0550.553 Cigarette License 6,000.00 00 6,000.00 00 00 6,045.00 45.00) 101 8,000.00 0550.554 Scavenger License 200.00 00 200.00 00 00 100.00 100.00 50 100.00 0550.558 Business License 40,000.00 00 40,000.00 2,362.50 00 20,012.50 19,987.50 50 41,437.50 0570.555 Building Permit 925,000.00 00 925,000.00 7,693.09 00 758,546.99 166,453.01 82 1,087,619.01 0570.556 Sign Permit 5,000.00 00 5,000.00 25.00 00 2,406.40 2,593.60 48 3,895.47 0570.557 Special Movement Permit 10,000.00 00 10,000.00 00 00 51,675.00 (41,675.00) 517 26,540.00 0570.560 Solicitors Permit 1,000.00 00 1,000.00 00 00 1,960.00 960.00) 196 3,430.00 0600.601 County Court Fines 325,000.00 00 325,000.00 00 00 194,067.94 130,932.06 60 353,321.80 0600.602 Administrative Fines(P-Tickets) 135,000.00 00 135,000.00 1,965.00 00 98,795.01 36,204.99 73 179,769.00 0600.603 Asset Seizure-Non Federal 225,000.00 00 225,000.00 00 00 3,919.84 221,080.16 2 43,814.70 0600.604 Alarm Fees 3,000.00 00 3,000.00 00 00 500.00 2,500.00 17 650.00 0600.605 Kendall County Court Fines 1,500.00 00 1,500.00 00 00 1,220.47 279.53 81 2,213.24 0600.607 Administrative Fines-Late Fee 10,000.00 00 10,000.00 60.00 00 4,550.00 5,450.00 46 9,020.00 0600.630 Asset Seizure-Federal(Dept of Justice Equitable Share) 5,000.00 00 5,000.00 00 00 114,413.20 (109,413.20) 2288 22,887.93 0600.632 Asset Seizure-Federal(U.S.Treasury Equitable Share) 1,000.00 00 1,000.00 00 00 00 1,000.00 0 00 0620.655 Garbage Fee 4,475,000.00 00 4,475,000.00 140.90) 00 2,970,951.14 1,504,048.86 66 4,320,878.46 0620.656 Garbage Penalties 50,000.00 00 50,000.00 22.56) 00 32,122.97 17,877.03 64 55,301.05 0640.500 Engineering Services 15,000.00 00 15,000.00 00 00 00 15,000.00 0 00 0650.651 Zoning Applications 10,000.00 00 10,000.00 00 00 16,411.00 6,411.00) 164 37,634.00 0650.653 Accident Report Fees 4,500.00 00 4,500.00 15.00 00 5,650.00 1,150.00) 126 5,969.00 0650.654 Copies-Maps&Ordinances 2,000.00 00 2,000.00 00 00 1,382.00 618.00 69 2,511.97 0650.670 Impound Fee 25,000.00 00 25,000.00 250.00 00 19,250.00 5,750.00 77 32,762.50 0650.815 Parking Lot Revenue 4,000.00 00 4,000.00 00 00 900.00 3,100.00 22 8,566.40 0650.818 Tower Rent 45,000.00 00 45,000.00 00 00 14,490.00 30,510.00 32 42,910.17 0650.825 Rental Income 49,200.00 00 49,200.00 2,100.00 00 30,800.00 18,400.00 63 49,200.00 0650.830 Rental-Community/Multi Room 4,000.00 00 4,000.00 45.00 00 1,992.50 2,007.50 50 3,740.00 Run by Traci Pleckham on 12/05/2019 11:49:35 AM Page 1 of 13 36 Budget Performance ReporttHllmitti.inilIIImill la I• EC.' 11 ".11.111011.1111 I ill VILLAGE OF Fiscal Year to Date 12/05/19 PLAINFIELD Exclude Rollup Account Adopted Budget Amended Current Month YTD YTD Budget-YTD %Used/ Account Account Description Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year Total Fund 01-General Fund REVENUE 0650.904 Special Detail/OT Reimbursement 50,000.00 00 50,000.00 00 00 80,061.52 (30,061.52) 160 117,965.35 0690.902 Water&Sewer Service Charge 350,000.00 00 350,000.00 00 00 00 350,000.00 0 250,000.00 0700.650 Grant Revenue 00 00 00 00 00 00 00 +++ 98,847.54 0700.704 Bulletproof Vest Grant 3,000.00 00 3,000.00 00 00 2,663.69 336.31 89 3,424.69 0700.710 Tobacco Grant 2,750.00 00 2,750.00 00 00 1,375.00 1,375.00 50 2,750.00 0700.717 Traffic Grant 30,000.00 00 30,000.00 00 00 17,755.62 12,244.38 59 42,970.66 0750.750 AT&T Franchise Fees 160,000.00 00 160,000.00 00 00 59,488.16 100,511.84 37 126,384.48 0750.751 Cable TV-Franchise Fees 530,000.00 00 530,000.00 2,574.34) 00 360,745.04 169,254.96 68 531,969.81 0800.800 Interest Income 126,326.00 00 126,326.00 00 00 124,341.00 1,985.00 98 225,088.80 0800.826 Realized Gain/Loss On Investment 00 00 00 00 00 00 00 +++ 829.41) 0800.827 Unrealized Gain/Loss 00 00 00 00 00 8,764.62 8,764.62) +++ 5,579.97 0800.830 Unrealized Gain/Loss IMET 00 00 00 00 00 30,872.37 (30,872.37) +++ 40,288.67 0801.200 Event Sponsorship Program 4,000.00 00 4,000.00 00 00 3,300.00 700.00 82 5,729.00 0801.801 Reimbursement Police Training 00 00 00 00 00 3,879.74 3,879.74) +++ 00 0801.802 Amphitheater Rent 500.00 00 500.00 00 00 125.00) 625.00 -25 250.00 0801.822 Donation/Contribution 15,000.00 00 15,000.00 00 00 15,335.00 335.00) 102 17,083.32 0803.000 Sales-Fixed Assets 2,000.00 00 2,000.00 00 00 4,740.00 2,740.00) 237 00 0805.000 Other Reimbursements 80,000.00 00 80,000.00 150.00 00 92,690.44 (12,690.44) 116 99,014.57 0806.000 Other Receipts 25,000.00 00 25,000.00 7.50 00 10,816.29 14,183.71 43 49,184.60 0840.001 Liability Write off 00 00 00 00 00 00 00 +++238,525.00 0860.804 School Liaison Reimbursement 475,000.00 00 475,000.00 00 00 250,789.22 224,210.78 53 441,773.75 0860.819 HIDTA/Organized Crime Reimb 15,000.00 00 15,000.00 00 00 5,738.40 9,261.60 38 10,306.28 0999.904 Transfer From MFT 150,000.00 00 150,000.00 00 00 00 150,000.00 0 00 0999.917 Transfer From TIF 50,000.00 00 50,000.00 00 00 00 50,000.00 0 00 0999.927 Transfer From Alcohol Enforc. 25,000.00 00 25,000.00 00 00 00 25,000.00 0 25,000.00 REVENUE TOTALS $26,646,976.00 0.00 $26,646,976.00 13,946.09 0.00 $19,238,485.96 $7,408,490.04 72% $26,744,971.94 EXPENSE Unit 00-Non-Departmental Division 94-Contra 2020.001 Contra Insurance Account 00 00 00 00 00 00 00 +++ (93,699.99) Division 94-Contra Totals 0.00 0.00 0.00 0.00 0.00 0.00 0.00 +++ ($93,699.99) Unit 00-Non-Departmental Totals 0.00 0.00 0.00 0.00 0.00 0.00 0.00 +++ ($93,699.99) Unit 04 Administration/Finance Division 00-Non-Divisional 8100 Fees to Refuse Hauler 4,134,000.00 00 4,134,000.00 00 00 2,052,276.38 2,081,723.62 50 3,982,890.82 Division 00-Non-Divisional Totals $4,134,000.00 0.00 $4,134,000.00 0.00 0.00 $2,052,276.38 $2,081,723.62 50% $3,982,890.82 Division 01-Legislative Program 1000 Salaries-President 24,000.00 00 24,000.00 00 00 14,000.00 10,000.00 58 24,000.00 1002 Salaries-Elected Officials 25,000.00 00 25,000.00 00 00 16,900.00 8,100.00 68 23,800.00 Run by Traci Pleckham on 12/05/2019 11:49:35 AM Page 2 of 13 37 Budget Performance Report111_ is iii lit Iia•iiI 111111 1. -1. 1 1 1 -1-21 '=1.1. 1 111 VILLAGE OF Fiscal Year to Date 12/05/19 PLAINFIELD Exclude Rollup Account Adopted Budget Amended Current Month YTD YTD Budget-YTD %Used/ Account Account Description Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year Total Fund 01-General Fund EXPENSE Unit 04-Administration/Finance Division 01-Legislative Program 1003 Salaries-Liquor Commissioner 1,500.00 00 1,500.00 00 00 875.00 625.00 58 1,500.00 1004 Salaries-Treasurer 2,500.00 00 2,500.00 00 00 1,458.31 1,041.69 58 2,499.96 2000 FICA 3,300.00 00 3,300.00 00 00 2,041.86 1,258.14 62 3,037.38 2001 Medicare 780.00 00 780.00 00 00 477.54 302.46 61 710.36 2020 Employee Insurance 150.00 00 150.00 00 00 77.70 72.30 52 138.60 3000 Travel/Training 10,000.00 00 10,000.00 00 00 1,919.13 8,080.87 19 4,393.22 5010 Replacement Supplies 3,000.00 00 3,000.00 00 00 00 3,000.00 0 00 5015 Dues&Subscriptions 40,000.00 00 40,000.00 1,856.15 00 16,315.15 23,684.85 41 56,001.37 8070 Public Relations 115,000.00 00 115,000.00 8,327.83 00 60,164.70 54,835.30 52 100,472.26 8074 Cable TV 10,000.00 00 10,000.00 00 00 00 10,000.00 0 00 8078 Economic Incentive Rebate 175,000.00 00 175,000.00 00 00 61,387.26 113,612.74 35 189,796.00 Division 01-Legislative Program Totak $410,230.00 0.00 $410,230.00 $10,183.98 0.00 $175,616.65 $234,613.35 43% $406,349.15 Division 02-Administration Program 1005 Salaries-Full Time 755,000.00 00 755,000.00 00 00 474,099.83 280,900.17 63 744,711.67 1015 Salaries-Part Time 55,000.00 00 55,000.00 00 00 34,659.87 20,340.13 63 53,127.40 1800 Salaries-Overtime 3,000.00 00 3,000.00 00 00 204.49 2,795.51 7 877.50 2000 FICA 50,400.00 00 50,400.00 00 00 28,204.18 22,195.82 56 45,116.29 2001 Medicare 11,800.00 00 11,800.00 00 00 7,319.38 4,480.62 62 11,560.00 2010 IMRF 92,000.00 00 92,000.00 00 00 48,223.16 43,776.84 52 84,812.66 2020 Employee Insurance 105,000.00 00 105,000.00 119.00 00 73,317.72 31,682.28 70 103,736.25 2025 Deferred Comp.Contribution 28,000.00 00 28,000.00 00 00 00 28,000.00 0 23,457.60 3000 Travel/Training 15,000.00 00 15,000.00 00 00 3,943.28 11,056.72 26 12,055.11 3015 IL Unemployment Insurance 5,000.00 00 5,000.00 00 00 1,730.56 3,269.44 35 4,042.94 4000 Telephone/Internet 5,500.00 00 5,500.00 00 00 3,891.80 1,608.20 71 6,345.92 4005 Cellular Phones/Pagers 3,000.00 00 3,000.00 00 00 941.67 2,058.33 31 2,145.49 5005 Office Supplies/Postage 32,000.00 00 32,000.00 366.21 00 19,018.53 12,981.47 59 32,003.26 5015 Dues&Subscriptions 5,000.00 00 5,000.00 00 00 3,048.80 1,951.20 61 3,716.00 5020 Gas/Oil/Mileage/Carwash 9,500.00 00 9,500.00 00 00 5,078.05 4,421.95 53 8,919.23 8035 Maintenance Contracts/Lease 8,000.00 00 8,000.00 149.83 00 2,999.92 5,000.08 37 8,718.65 8045 Recording Fees 1,500.00 00 1,500.00 00 00 166.00 1,334.00 11 1,579.00 8050 Legal Notices 2,500.00 00 2,500.00 00 00 1,397.50 1,102.50 56 2,328.43 8065 Legal Fees 45,000.00 00 45,000.00 3,137.00 00 18,300.82 26,699.18 41 48,478.10 8135 Contractual Services 80,000.00 00 80,000.00 00 00 29,082.70 50,917.30 36 88,670.03 8135.008 Settlement Charges 00 00 00 00 00 5,192.11 5,192.11) +++ 6,865.51 9115 Office Furniture&Equipment 5,000.00 00 5,000.00 00 00 9,981.72 4,981.72) 200 1,747.90 9300 Contingencies 45,000.00 00 45,000.00 00 00 7,054.06 37,945.94 16 37,696.00 Division 02-Administration Program Total- $1,362,200.00 0.00 $1,362,200.00 3,772.04 0.00 $777,856.15 $584,343.85 57% $1,332,710.94 Run by Traci Pleckham on 12/05/2019 11:49:35 AM Page 3 of 13 38 Budget Performance Report 1..1-.1 1 I "91161111111111111 I III VILLAGE OF Fiscal Year to Date 12/05/19 PLAINFIELD Exclude Rollup Account 00--.........0".........00-•-..00-4... Adopted Budget Amended Current Month YTD YTD Budget-YTD %Used/ Account Account Description Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year Total Fund 01-General Fund EXPENSE Unit 04-Administration/Finance Division 03-Community Relations Program 1005 Salaries-Full Time 105,000.00 00 105,000.00 00 00 64,026.35 40,973.65 61 102,251.54 2000 FICA 6,510.00 00 6,510.00 00 00 3,635.56 2,874.44 56 5,900.82 2001 Medicare 1,525.00 00 1,525.00 00 00 850.25 674.75 56 1,380.03 2010 IMRF 12,075.00 00 12,075.00 00 00 6,140.06 5,934.94 51 11,010.31 2020 Employee Insurance 22,500.00 00 22,500.00 00 00 14,932.12 7,567.88 66 21,093.88 2025 Deferred Comp.Contribution 4,000.00 00 4,000.00 00 00 00 4,000.00 0 3,655.60 3000 Travel/Training 1,500.00 00 1,500.00 00 00 100.00 1,400.00 7 251.32 4000 Telephone/Internet 650.00 00 650.00 00 00 453.34 196.66 70 634.57 5005 Office Supplies/Postage 500.00 00 500.00 00 00 00 500.00 0 00 5015 Dues&Subscriptions 850.00 00 850.00 00 00 170.00 680.00 20 530.00 5020 Gas/Oil/Mileage/Carwash 100.00 00 100.00 00 00 00 100.00 0 00 8070 Public Relations 12,500.00 00 12,500.00 00 00 5,591.27 6,908.73 45 10,798.95 8071 Marketing and Promotions 2,000.00 00 2,000.00 00 00 00 2,000.00 0 173.00 8072 Settler's Park 7,500.00 00 7,500.00 608.00 00 4,048.13 3,451.87 54 6,190.78 8135 Contractual Services 4,000.00 00 4,000.00 00 00 00 4,000.00 0 3,850.00 Division 03-Community Relations Program Totals $181,210.00 0.00 $181,210.00 608.00 0.00 $99,947.08 $81,262.92 55% $167,720.80 Division 04-Facility Management Program 1005 Salaries-Full Time 51,000.00 00 51,000.00 00 00 32,076.95 18,923.05 63 50,139.30 1800 Salaries-Overtime 3,000.00 00 3,000.00 00 00 2,067.73 932.27 69 4,226.07 2000 FICA 3,400.00 00 3,400.00 00 00 2,027.14 1,372.86 60 3,227.44 2001 Medicare 800.00 00 800.00 00 00 474.11 325.89 59 754.85 2010 IMRF 5,900.00 00 5,900.00 00 00 3,264.29 2,635.71 55 5,766.42 2020 Employee Insurance 15,000.00 00 15,000.00 00 00 10,711.94 4,288.06 71 15,299.94 2025 Deferred Comp.Contribution 00 00 00 00 00 00 00 +++ 776.90 5000 Building Supplies 12,000.00 00 12,000.00 1,517.70 00 5,787.87 6,212.13 48 10,386.97 8135 Contractual Services 40,000.00 00 40,000.00 127.00 00 24,532.00 15,468.00 61 43,066.74 9105 Building Improvements 40,000.00 00 40,000.00 00 00 00 40,000.00 0 5,987.28 Division 04-Facility Management Program Totals $171,100.00 0.00 $171,100.00 1,644.70 0.00 $80,942.03 $90,157.97 47% $139,631.91 Division 06-Human Resources Program 1005 Salaries-Full Time 170,000.00 00 170,000.00 00 00 105,647.64 64,352.36 62 166,248.26 1800 Salaries-Overtime 500.00 00 500.00 00 00 00 500.00 0 49.53 2000 FICA 10,550.00 00 10,550.00 00 00 6,253.69 4,296.31 59 9,972.02 2001 Medicare 2,500.00 00 2,500.00 00 00 1,462.55 1,037.45 59 2,332.18 2010 IMRF 19,650.00 00 19,650.00 00 00 10,166.83 9,483.17 52 17,737.75 2020 Employee Insurance 40,000.00 00 40,000.00 00 00 27,310.28 12,689.72 68 38,063.46 2025 Deferred Comp.Contribution 7,000.00 00 7,000.00 00 00 00 7,000.00 0 6,579.60 3000 Travel/Training 6,500.00 00 6,500.00 00 00 75.00 6,425.00 1 8,687.55 Run by Traci Pleckham on 12/05/2019 11:49:35 AM Page 4 of 13 39 Budget Performance ReportMitwilltttllmlit ,, 1. .1.--1 1 1 -11-.1....1.1. I III VILLAGE OF Fiscal Year to Date 12/05/19 PLAINFIELD Exclude Rollup Account Adopted Budget Amended Current Month YTD YTD Budget-YTD %Used/ Account Account Description Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year Total Fund 01-General Fund EXPENSE Unit 04-Administration/Finance Division 06-Human Resources Program 4000 Telephone/Internet 1,000.00 00 1,000.00 00 00 714.20 285.80 71 1,269.18 4005 Cellular Phones/Pagers 600.00 00 600.00 00 00 335.98 264.02 56 666.60 5005 Office Supplies/Postage 1,500.00 00 1,500.00 00 00 529.77 970.23 35 518.34 5015 Dues&Subscriptions 9,000.00 00 9,000.00 00 00 189.00 8,811.00 2 7,804.00 5020 Gas/Oil/Mileage/Carwash 1,200.00 00 1,200.00 00 00 24.36 1,175.64 2 340.67 8070 Public Relations 12,300.00 00 12,300.00 00 00 7,845.56 4,454.44 64 4,149.07 8135 Contractual Services 8,000.00 00 8,000.00 1,212.00 00 2,979.00 5,021.00 37 5,473.00 Division ,I k.,,,,,111nn Resources Program Totals $290,300.00 0.00 $290,300.00 1,212.00 0.00 $163,533.86 $126,766.14 56% $269,891.21 Division 08-IT Pru. „. 1005 Salaries-Full Time 252,000.00 00 252,000.00 00 00 163,941.68 88,058.32 65 245,653.23 1800 Salaries-Overtime 500.00 00 500.00 00 00 00 500.00 0 00 2000 FICA 15,600.00 00 15,600.00 00 00 9,974.91 5,625.09 64 15,003.82 2001 Medicare 3,660.00 00 3,660.00 00 00 2,332.85 1,327.15 64 3,508.96 2010 IMRF 29,000.00 00 29,000.00 00 00 15,682.57 13,317.43 54 26,161.76 2020 Employee Insurance 46,000.00 00 46,000.00 00 00 30,532.82 15,467.18 66 42,082.57 2025 Deferred Comp.Contribution 9,500.00 00 9,500.00 00 00 00 9,500.00 0 6,926.00 3000 Travel/Training 14,500.00 00 14,500.00 1,158.78 00 2,976.46 11,523.54 21 12,046.12 4000 Telephone/Internet 500.00 00 500.00 00 00 357.10 142.90 71 669.24 4005 Cellular Phones/Pagers 3,000.00 00 3,000.00 00 00 1,349.28 1,650.72 45 2,657.31 5005 Office Supplies/Postage 1,400.00 00 1,400.00 00 00 418.79 981.21 30 1,868.87 5015 Dues&Subscriptions 700.00 00 700.00 00 00 564.00 136.00 81 675.00 5020 Gas/Oil/Mileage/Carwash 400.00 00 400.00 00 00 268.86 131.14 67 339.93 5095 Uniforms/Clothing 300.00 00 300.00 00 00 00 300.00 0 367.50 8030 Server/Network Supplies 58,700.00 00 58,700.00 00 00 17,272.37 41,427.63 29 55,355.26 8031 Software Licensing/Renewals 265,000.00 00 265,000.00 3,850.00 1,844.55 198,660.01 64,495.44 76 256,682.75 8135 Contractual Services 16,300.00 00 16,300.00 00 00 5,191.28 11,108.72 32 16,611.32 9111 Computers 25,000.00 00 25,000.00 00 00 821.65 24,178.35 3 22,795.69 Division 08-IT Program Totals $742,060.00 0.00 $742,060.00 5,008.78 1,844.55 $450,344.63 $289,870.82 61% $709,405.33 Division 99-Transfers 9911 Transfer to Capital Improvements 450,000.00 00 450,000.00 00 00 00 450,000.00 0 1,359,212.00 Division 99-Transfers Totals $450,000.00 0.00 $450,000.00 0.00 0.00 0.00 $450,000.00 0% $1,359,212.00 Unit 04-Administration/Finance Totals $7,741,100.00 0.00 $7,741,100.00 22,429.50 1,844.55 $3,800,516.78 $3,938,738.67 49% $8,367,812.16 Unit 08-Street Department Division 02-Administration Program 1005 Salaries-Full Time 375,135.00 00 375,135.00 00 00 236,684.38 138,450.62 63 351,001.99 2000 FICA 23,500.00 00 23,500.00 00 00 14,364.57 9,135.43 61 21,109.87 2001 Medicare 5,500.00 00 5,500.00 00 00 3,425.86 2,074.14 62 5,062.15 Run by Traci Pleckham on 12/05/2019 11:49:35 AM Page 5 of 13 40 IIIIIIIIII 111111 1-i Budget Performance Report 1- .1---1 I I -1PIII "I'I' I III VILLAGE OF Fiscal Year to Date 12/05/19 PLAINFIELD Exclude Rollup Account Adopted Budget Amended Current Month YTD YTD Budget-YTD %Used/ Account Account Description Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year Total Fund 01-General Fund EXPENSE Unit 08-Street Department Division 02-Administration Program 2010 IMRF 43,200.00 00 43,200.00 00 00 23,257.46 19,942.54 54 37,925.16 2020 Employee Insurance 80,000.00 00 80,000.00 00 00 54,528.13 25,471.87 68 69,870.77 2025 Deferred Comp.Contribution 9,500.00 00 9,500.00 00 00 00 9,500.00 0 9,432.90 3000 Travel/Training 10,000.00 00 10,000.00 362.07 00 8,911.85 1,088.15 89 12,212.22 3015 IL Unemployment Insurance 4,500.00 00 4,500.00 00 00 2,233.56 2,266.44 50 4,000.00 4000 Telephone/Internet 25,000.00 00 25,000.00 00 00 21,167.48 3,832.52 85 31,749.16 4005 Cellular Phones/Pagers 8,500.00 00 8,500.00 00 00 4,162.84 4,337.16 49 8,947.71 5005 Office Supplies/Postage 3,000.00 00 3,000.00 00 00 3,918.82 918.82) 131 5,237.15 5015 Dues&Subscriptions 3,000.00 00 3,000.00 00 00 2,699.70 300.30 90 2,881.36 5020 Gas/Oil/Mileage/Carwash 300.00 00 300.00 00 00 158.58 141.42 53 318.11 5040 Supplies/Hardware 500.00 00 500.00 00 00 80.00 420.00 16 705.48 8020 Building Maintenance 20,000.00 00 20,000.00 1,003.21 00 4,111.65 15,888.35 21 7,124.20 8050 Legal Notices 1,000.00 00 1,000.00 00 00 246.73 753.27 25 00 Division 02-Administration Program Totals $612,635.00 0.00 $612,635.00 1,365.28 0.00 $379,951.61 $232,683.39 62% $567,578.23 Division 60-Street Maintenance Program 1005 Salaries-Full Time 832,500.00 00 832,500.00 00 00 484,677.76 347,822.24 58 813,413.90 1015 Salaries-Part Time 70,000.00 00 70,000.00 00 00 57,816.38 12,183.62 83 71,643.34 1800 Salaries-Overtime 90,000.00 00 90,000.00 00 00 83,514.07 6,485.93 93 134,401.53 2000 FICA 62,000.00 00 62,000.00 00 00 38,621.12 23,378.88 62 60,326.33 2001 Medicare 15,000.00 00 15,000.00 00 00 9,032.42 5,967.58 60 14,108.62 2010 IMRF 104,000.00 00 104,000.00 00 00 53,785.42 50,214.58 52 98,715.04 2020 Employee Insurance 210,000.00 00 210,000.00 00 00 125,885.56 84,114.44 60 199,481.23 2025 Deferred Comp.Contribution 25,000.00 00 25,000.00 00 00 00 25,000.00 0 21,724.84 4015 Electricity/Gas 250,000.00 00 250,000.00 2,421.56 00 102,947.18 147,052.82 41 208,957.00 5005 Office Supplies/Postage 00 00 00 37.32 00 37.32 37.32) +++ 00 5020 Gas/Oil/Mileage/Carwash 65,000.00 00 65,000.00 25,259.63 00 51,734.19 13,265.81 80 51,795.95 5040 Supplies/Hardware 15,000.00 00 15,000.00 1,070.23 00 6,293.70 8,706.30 42 17,351.97 5040.003 Supplies/Hardware-Salt Purchase 300,000.00 00 300,000.00 24,906.61 00 24,906.61 275,093.39 8 356,106.49 5055 Street Sign Maintenance 40,000.00 00 40,000.00 2,245.00 00 23,523.25 16,476.75 59 37,317.92 5060 Aggregate Materials 4,000.00 00 4,000.00 772.93 00 2,628.79 1,371.21 66 2,711.16 5095 Uniforms/Clothing 10,000.00 00 10,000.00 756.98 00 4,584.09 5,415.91 46 10,427.99 8003 Radio Maintenance 5,000.00 00 5,000.00 00 00 2,292.90 2,707.10 46 3,955.90 8060 Vehicle Maintenance 35,000.00 00 35,000.00 5,540.68 00 18,817.77 16,182.23 54 26,194.32 8130 Street Light Maintenance 115,000.00 00 115,000.00 12,703.68 00 74,243.93 40,756.07 65 94,786.75 8131 Street Maintenance 130,000.00 00 130,000.00 1,079.25 00 160,324.06 (30,324.06) 123 97,536.52 8132 Storm Sewer Improvements 15,000.00 00 15,000.00 3,300.65 00 9,987.94 5,012.06 67 16,939.65 8135 Contractual Services 115,000.00 00 115,000.00 2,935.54 00 99,264.81 15,735.19 86 95,072.81 Run by Traci Pleckham on 12/05/2019 11:49:35 AM Page 6 of 13 41 Budget Performance ReportNMIIli111111itt ai ' 1. .1"-, 1 1 -iP.I."4.1. 1 III C ry y VILLAGE OF Fiscal Year to Date 12t/V 11 PLAIN F I E LD Exclude Rollup Account Adopted Budget Amended Current Month YTD YTD Budget-YTD %Used/ Account Account Description Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year Total Fund 01-General Fund EXPENSE Unit 08-Street Department Division 60-Street Maintenance Program 8135.004 Snow Removal 350,000.00 00 350,000.00 7,173.10 00 7,173.10 342,826.90 2 468,986.00 8150 Sidewalk Maintenance 5,000.00 00 5,000.00 00 00 00 5,000.00 0 00 8160 Equipment Maintenance 90,000.00 00 90,000.00 1,032.17 00 103,741.67 (13,741.67) 115 105,629.90 Division 60-Street Maintenance Program Totak $2,952,500.00 0.00 $2,952,500.00 $91,235.33 0.00 $1,545,834.04 $1,406,665.96 52% $3,007,585.16 ivision 62-Forestry Program 1005 Salaries-Full Time 82,000.00 00 82,000.00 00 00 49,922.72 32,077.28 61 74,794.79 1800 Salaries-Overtime 6,000.00 00 6,000.00 00 00 11,578.88 5,578.88) 193 7,219.05 2000 FICA 5,500.00 00 5,500.00 00 00 3,736.85 1,763.15 68 5,558.25 2001 Medicare 1,300.00 00 1,300.00 00 00 873.91 426.09 67 1,299.86 2010 IMRF 10,000.00 00 10,000.00 00 00 5,891.01 4,108.99 59 9,785.07 2020 Employee Insurance 19,000.00 00 19,000.00 00 00 8,464.86 10,535.14 45 13,718.80 2025 Deferred Comp.Contribution 3,000.00 00 3,000.00 00 00 00 3,000.00 0 2,253.30 5040 Supplies/Hardware 10,000.00 00 10,000.00 444.15 00 8,133.43 1,866.57 81 11,556.53 5095 Uniforms/Clothing 500.00 00 500.00 00 00 00 500.00 0 75.00 8135 Contractual Services 20,000.00 00 20,000.00 00 00 1,645.00 18,355.00 8 1,137.35 8135.002 Tree Removal 20,000.00 00 20,000.00 00 00 18,850.00 1,150.00 94 11,765.00 Division 62-Forests-=,r Program Total; $177,300.00 0.00 $177,300.00 444.15 0.00 $109,096.66 $68,203.34 62% $139,163.00 Division 63-Vehicle Maintenance Program 1005 Salaries-Full Time 205,000.00 00 205,000.00 00 00 111,716.22 93,283.78 54 183,375.68 1800 Salaries-Overtime 8,000.00 00 8,000.00 00 00 5,539.06 2,460.94 69 8,231.39 2000 FICA 13,500.00 00 13,500.00 00 00 7,112.92 6,387.08 53 11,381.49 2001 Medicare 3,100.00 00 3,100.00 00 00 1,663.51 1,436.49 54 2,661.72 2010 IMRF 23,500.00 00 23,500.00 00 00 11,209.57 12,290.43 48 20,494.58 2020 Employee Insurance 41,000.00 00 41,000.00 00 00 22,121.90 18,878.10 54 34,877.05 2025 Deferred Comp.Contribution 7,500.00 00 7,500.00 00 00 00 7,500.00 0 3,145.00 Division 63-Vehicle Mamtenance Program Totals $301,600.00 0.00 $301,600.00 0.00 0.00 $159,363.18 $142,236.82 53% $264,166.91 Unit 08-Street Department Total= $4,044,035.00 0.00 $4,044,035.00 $93,044.76 0.00 $2,194,245.49 $1,849,789.51 54% $3,978,493.30 Unit 09-Community Development Division 20-Planning Program 1005 Salaries-Full Time 360,000.00 00 360,000.00 00 00 205,806.90 154,193.10 57 343,839.27 1045 Salaries-Commissioner 3,500.00 00 3,500.00 00 00 1,750.00 1,750.00 50 2,845.00 1800 Salaries-Overtime 2,500.00 00 2,500.00 00 00 99.49 2,400.51 4 1,138.26 2000 FICA 22,700.00 00 22,700.00 00 00 12,567.34 10,132.66 55 21,161.80 2001 Medicare 5,300.00 00 5,300.00 00 00 2,939.18 2,360.82 55 4,949.09 2010 IMRF 41,000.00 00 41,000.00 00 00 19,751.60 21,248.40 48 37,018.57 2020 Employee Insurance 79,000.00 00 79,000.00 00 00 50,927.86 28,072.14 64 76,346.64 2025 Deferred Comp.Contribution 8,500.00 00 8,500.00 00 00 00 8,500.00 0 5,420.40 Run by Traci Pleckham on 12/05/2019 11:49:35 AM Page 7 of 13 42 llr „arI,iI ,, Budget Performance Report i-.....1---1 1 1 -11..1....1.1. l III VILLAGE OF Fiscal Year to Date 12/05/19 PLAINFIELD Exclude Rollup Account Adopted Budget Amended Current Month YTD YTD Budget-YTD %Used/ Account Account Description Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year Total Fund 01-General Fund EXPENSE Unit 09-Community Development Division 20-Planning Program 3000 Travel/Training 8,000.00 00 8,000.00 00 00 2,896.95 5,103.05 36 8,341.10 3015 IL Unemployment Insurance 1,000.00 00 1,000.00 00 00 365.32 634.68 37 877.95 4000 Telephone/Internet 3,000.00 00 3,000.00 00 00 2,106.29 893.71 70 3,172.95 4005 Cellular Phones/Pagers 1,800.00 00 1,800.00 00 00 291.92 1,508.08 16 972.89 5005 Office Supplies/Postage 10,000.00 00 10,000.00 00 00 3,106.82 6,893.18 31 22,701.80 5015 Dues&Subscriptions 5,000.00 00 5,000.00 00 00 3,612.85 1,387.15 72 3,775.67 5020 Gas/Oil/Mileage/Carwash 750.00 00 750.00 00 00 199.77 550.23 27 249.96 8035 Maintenance Contracts/Lease 2,000.00 00 2,000.00 149.83 00 1,096.69 903.31 55 550.00 8050 Legal Notices 5,000.00 00 5,000.00 860.00 00 7,372.18 2,372.18) 147 00 8060 Vehicle Maintenance 1,000.00 00 1,000.00 00 00 00 1,000.00 0 00 8065 Legal Fees 4,000.00 00 4,000.00 00 00 1,487.25 2,512.75 37 4,198.75 8097 Special Projects and Programs 15,000.00 00 15,000.00 00 00 5,492.50 9,507.50 37 9,924.50 8135 Contractual Services 20,000.00 00 20,000.00 00 00 3,968.18 16,031.82 20 30,912.72 8225 Engineering Fees 8,000.00 00 8,000.00 00 00 8,908.55 908.55) 111 15,449.63 Division 20-Planning Program Totals $607,050.00 0.00 $607,050.00 1,009.83 0.00 $334,747.64 $272,302.36 55% $593,846.95 Division 21-Building Program 1005 Salaries-Full Time 665,000.00 00 665,000.00 00 00 416,048.57 248,951.43 63 642,943.15 1800 Salaries-Overtime 3,000.00 00 3,000.00 00 00 640.56 2,359.44 21 2,561.11 2000 FICA 41,500.00 00 41,500.00 00 00 24,935.62 16,564.38 60 38,082.66 2001 Medicare 9,700.00 00 9,700.00 00 00 5,831.69 3,868.31 60 8,906.42 2010 IMRF 76,475.00 00 76,475.00 00 00 39,864.11 36,610.89 52 67,962.86 2020 Employee Insurance 185,000.00 00 185,000.00 00 00 119,734.38 65,265.62 65 152,093.83 2025 Deferred Comp.Contribution 10,000.00 00 10,000.00 00 00 00 10,000.00 0 16,344.28 3000 Travel/Training 10,000.00 00 10,000.00 00 00 3,010.93 6,989.07 30 11,188.09 3015 IL Unemployment Insurance 1,500.00 00 1,500.00 00 00 741.67 758.33 49 1,477.37 4000 Telephone/Internet 1,000.00 00 1,000.00 00 00 677.89 322.11 68 810.54 4005 Cellular Phones/Pagers 4,500.00 00 4,500.00 00 00 1,738.76 2,761.24 39 3,810.82 5005 Office Supplies/Postage 13,000.00 00 13,000.00 00 00 5,305.04 7,694.96 41 6,264.72 5015 Dues&Subscriptions 4,000.00 00 4,000.00 210.00 00 210.00 3,790.00 5 675.00 5020 Gas/Oil/Mileage/Carwash 1,000.00 00 1,000.00 00 00 546.83 453.17 55 56.55 5095 Uniforms/Clothing 900.00 00 900.00 260.00 00 368.00 532.00 41 491.73 8045 Recording Fees 3,000.00 00 3,000.00 492.00 00 1,384.00 1,616.00 46 1,079.25 8135 Contractual Services 20,000.00 00 20,000.00 258.89 00 2,587.73 17,412.27 13 9,416.60 Division 21-Building Progri Totals, $1,049,575.00 0.00 $1,049,575.00 1,220.89 0.00 $623,625.78 $425,949.22 59% $964,164.98 Unit 09-Community Development Totals;. $1,656,625.00 0.00 $1,656,625.00 2,230.72 0.00 $958,373.42 $698,251.58 58% $1,558,011.93 EXPENSE TOTALS $13,441,760.00 0.00 $13,441,760.00 $117,704.98 1,844.55 $6,953,135.69 $6,486,779.76 52% $13,810,617.40 Run by Traci Pleckham on 12/05/2019 11:49:35 AM Page 8 of 13 43 rn' ttt111111min . •IIlEI i t Budget Performance Report 7-.1. ..1---1 1 1 -11..ifinq.i• I ill VILLAGE OF Fiscal Year to Date 12/05/19 PLAINFIELD Exclude Rollup Account Adopted Budget Amended Current Month YTD YTD Budget-YTD %Used/ Account Account Description Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year Total Fund 01_General Fund Totals REVENUE TOTALS 26,646,976.00 00 26,646,976.00 13,946.09 00 19,238,485.96 7,408,490.04 72% 26,744,971.94 EXPENSE TOTALS 13,441,760.00 00 13,441,760.00 117,704.98 1,844.55 6,953,135.69 6,486,779.76 52% 13,810,617.40 Fund 01-General Fund Totals. $13,205,216.00 0.00 $13,205,216.00 ($103,758.89) ($1,844.55) $12,285,350.27 $921,710.28 12,934,354.54 Fund 04-Motor Fuel Taw REVENUE 0450.457 MFT Entitlements 1,100,000.00 00 1,100,000.00 00 00 738,359.22 361,640.78 67 1,103,351.17 0800.800 Interest Income 50,000.00 00 50,000.00 00 00 42,233.81 7,766.19 84 72,786.51 REVENUE TOTALS $1,150,000.00 0.00 $1,150,000.00 0.00 0.00 $780,593.03 $369,406.97 68% $1,176,137.68 EXPENSE Unit 00-Non-f w aro wr r'_'. .; Division 91-Capital 9150 Street Improvements 1,000,000.00 00 1,000,000.00 77,000.46 00 1,161,318.23 (161,318.23) 116 875,330.71 Division 91-Capital Totals $1,000,000.00 0.00 $1,000,000.00 77,000.46 0.00 $1,161,318.23 ($161,318.23) 116% $875,330.71 Division 99-Transfers 9901 Transfer to General 150,000.00 00 150,000.00 00 00 00 150,000.00 0 00 Division 99-Transfers Totals $150,000.00 0.00 $150,000.00 0.00 0.00 0.00 $150,000.00 0% 0.00 Unit 00-Non-Departmental Totals $1,150,000.00 0.00 $1,150,000.00 77,000.46 0.00 $1,161,318.23 ($11,318.23) 101% $875,330.71 EXPENSE TOTALS $1,150,000.00 0.00 $1,150,000.00 77,000.46 0.00 $1,161,318.23 ($11,318.23) 101% $875,330.71 Fund 04-Motor Fuel Tax Totals REVENUE TOTALS 1,150,000.00 00 1,150,000.00 00 00 780,593.03 369,406.97 68% 1,176,137.68 EXPENSE TOTALS 1,150,000.00 00 1,150,000.00 77,000.46 00 1,161,318.23 (11,318.23) 101% 875,330.71 Fund 04-Motor Fuel Tax Iota!, 0.00 0.00 0.00 ($77,000.46) 0.00 ($380,725.20) $380,725.20 300,806.97 Fund 05-Bond and Interest Fund REVENUE 0400.401 Property Tax Revenue 114,400.00 00 114,400.00 00 00 113,661.13 738.87 99 118,113.84 0800.800 Interest Income 8,000.00 00 8,000.00 00 00 10,596.87 2,596.87) 132 12,402.64 0999.902 Transfer From Water and Sewer 981,000.00 00 981,000.00 00 00 981,000.00 00 100 976,800.00 0999.911 Transfer From Capital 2,035,850.00 00 2,035,850.00 00 00 2,022,925.00 12,925.00 99 2,018,730.88 REVENUE TOTALS $3,139,250.00 0.00 $3,139,250.00 0.00 0.00 $3,128,183.00 $11,067.00 100% $3,126,047.36 EXPENSE Unit 00-Non-Departmental Division 92-Bonds 9200.020 2007 Bond(Principal) 00 00 00 00 00 00 00 +++170,000.00 9200.021 2007 Bond(Interest) 00 00 00 00 00 00 00 +++ 8,500.00 9200.024 2009 Refunding Bond(Principal) 110,000.00 00 110,000.00 00 00 110,000.00 00 100 105,000.00 9200.025 2009 Refunding Bond(Interest) 4,400.00 00 4,400.00 00 00 4,400.00 00 100 8,600.00 9200.026 2010 Bond(Principal) 805,000.00 00 805,000.00 00 00 805,000.00 00 100 770,000.00 9200.027 2010 Bond(Interest) 176,000.00 00 176,000.00 00 00 176,000.00 00 100 206,800.00 9200.028 2012 Refunding Bond(Principal) 695,000.00 00 695,000.00 00 00 695,000.00 00 100 680,000.00 Run by Traci Pleckham on 12/05/2019 11:49:35 AM Page 9 of 13 44 lBudget Performance Report1M111IllittiSI'II 111 ie MI"M1" ! I I aal"INr`IIIIr I' 111 VILLAGE OF Fiscal Year to Date 12/05/19 PLAINFIELD Exclude Rollup Account Adopted Budget Amended Current Month YTD YTD Budget-YTD %Used/ Account Account Description Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year Total Fund 05-Bond and Interest Fund EXPENSE Unit 00-Non-Departmental Division 92-Bonds 9200.029 2012 Refunding Bond(Interest) 135,000.00 00 135,000.00 00 00 135,000.00 00 100 155,400.00 9200.030 2014 Refunding-2007 Bond(Principal) 950,000.00 00 950,000.00 00 00 950,000.00 00 100 750,000.00 9200.031 2014 Refunding-2007 Bond(Interest) 255,850.00 00 255,850.00 00 00 255,850.00 00 100 270,850.00 Division 92-Bonds Totals $3,131,250.00 0.00 $3,131,250.00 0.00 0.00 $3,131,250.00 0.00 100% $3,125,150.00 Unit 00-Non-Departmental Totals $3,131,250.00 0.00 $3,131,250.00 0.00 0.00 $3,131,250.00 0.00 100% $3,125,150.00 EXPENSE TOTALS $3,131,250.00 0.00 $3,131,250.00 0.00 0.00 $3,131,250.00 0.00 100% $3,125,150.00 Fund 0S-Bond and Interest Fund Totals REVENUE TOTALS 3,139,250.00 00 3,139,250.00 00 00 3,128,183.00 11,067.00 100% 3,126,047.36 EXPENSE TOTALS 3,131,250.00 00 3,131,250.00 00 00 3,131,250.00 00 100% 3,125,150.00 Fund 05-Bond and Interest Fund Tot& 8,000.00 0.00 8,000.00 0.00 0.00 ($3,067.00) $11,067.00 897.36 Fund 07-Tort l,."niunity Fund REVENUE 0400.401 Property Tax Revenue 400,000.00 00 400,000.00 00 00 395,459.11 4,540.89 99 491,667.64 0800.800 Interest Income 3,000.00 00 3,000.00 00 00 4,441.14 1,441.14) 148 8,100.86 0805.000 Other Reimbursements 00 00 00 00 00 00 00 +++ 451.12 REVENUE TOTALS $403,000.00 0.00 $403,000.00 0.00 0.00 $399,900.25 3,099.75 99% $500,219.62 EXPENSE Unit 00-Non-Departmental Division 00-Non-Divisional 8275 Bond-Treasurer 500.00 00 500.00 00 00 336.00 164.00 67 336.00 8300 Commercial Umbrella Liability 200,000.00 00 200,000.00 00 00 155,936.00 44,064.00 78 170,959.00 8310 Workman's Compensation Ins. 250,000.00 00 250,000.00 00 00 189,364.00 60,636.00 76 180,488.00 Division 00-Non-Divisional Totals $450,500.00 0.00 $450,500.00 0.00 0.00 $345,636.00 $104,864.00 77% $351,783.00 Unit 00-Non-Departmental Totals $450,500.00 0.00 $450,500.00 0.00 0.00 $345,636.00 $104,864.00 77% $351,783.00 EXPENSE TOTALS $450,500.00 0.00 $450,500.00 0.00 0.00 $345,636.00 $104,864.00 77% $351,783.00 Fund 07-Tort Immunity Fund Totals REVENUE TOTALS 403,000.00 00 403,000.00 00 00 399,900.25 3,099.75 99% 500,219.62 EXPENSE TOTALS 450,500.00 00 450,500.00 00 00 345,636.00 104,864.00 77% 351,783.00 Fund 07-Tort Immunity Fund Totals ($47,500.00) 0.00 ($47,500.00) 0.00 0.00 54,264.25 ($101,764.25)148,436.62 Fund 08-Audit Fund REVENUE 0400.401 Property Tax Revenue 35,000.00 00 35,000.00 00 00 35,791.93 791.93) 102 44,169.31 0800.800 Interest Income 400.00 00 400.00 00 00 355.55 44.45 89 531.69 REVENUE TOTALS $35,400.00 0.00 $35,400.00 0.00 0.00 36,147.48 747.48) 102% $44,701.00 Run by Traci Pleckham on 12/05/2019 11:49:35 AM Page 10 of 13 45 tk II ill lit .IIII II Him .I. Budget Performance Report I III VILLAGE OF Fiscal Year to Date 12/05/19 PLAINFIELD Exclude Rollup Account Adopted Budget Amended Current Month YTD YTD Budget-YTD %Used/ Account Account Description Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year Total Fund 08-Audit Fund EXPENSE Unit 00-Non-Departmental Division 00-Non-Divisional 8315 Audit Village 42,000.00 00 42,000.00 00 00 39,565.00 2,435.00 94 38,085.00 Division 00-Non-Divisional Totals $42,000.00 0.00 42,000.00 0.00 0.00 39,565.00 2,435.00 94% $38,085.00 Unit 00-Non-Departmental Total=42,000.00 0.00 42,000.00 0.00 0.00 $39,565.00 2,435.00 94% $38,085.00 EXPENSE TOTALS $42,000.00 0.00 42,000.00 0.00 0.00 39,565.00 2,435.00 94% $38,085.00 Fund 08-Audit Fund Totals REVENUE TOTALS 35,400.00 00 35,400.00 00 00 36,147.48 747.48) 102%44,701.00 EXPENSE TOTALS 42,000.00 00 42,000.00 00 00 39,565.00 2,435.00 94%38,085.00 Fund 08-Audit Fund Totals ($6,600.00) 0.00 ($6,600.00) 0.00 0.00 ($3,417.52) ($3,182.48) 6,616.00 Fund 10-Police Pension Fund REVENUE 0800.800 Interest Income 700,000.00 00 700,000.00 00 00 295,513.62 404,486.38 42 1,219,956.39 0800.824 Realized Gain/Loss-SawyerFalduto 150,000.00 00 150,000.00 00 00 (43,571.39)193,571.39 -29 339,711.61 0800.829 Unrealized Gain/Loss Sawyer/Fald 300,000.00 00 300,000.00 00 00 810,543.80 (510,543.80) 270 235,709.93 0806.000 Other Receipts 00 00 00 00 00 00 00 +++ 199.64 0818.000 Employee Contributions 570,000.00 00 570,000.00 00 00 288,022.07 281,977.93 51 555,361.62 0819.000 Employer Contributions 1,300,000.00 00 1,300,000.00 00 00 1,284,423.69 15,576.31 99 1,402,474.77 REVENUE TOTALS $3,020,000.00 0.00 $3,020,000.00 0.00 0.00 $2,634,931.79 $385,068.21 87% $3,753,413.96 EXPENSE Unit 00-Non-Departmental Division 00-Non-Divisional 3000 Travel/Training 5,000.00 00 5,000.00 00 00 6,765.48 1,765.48) 135 7,153.41 5005 Office Supplies/Postage 500.00 00 500.00 00 00 122.72 377.28 25 00 5015 Dues&Subscriptions 5,800.00 00 5,800.00 00 00 7,111.27 1,311.27) 123 6,421.14 8135 Contractual Services 35,000.00 00 35,000.00 00 00 14,950.43 20,049.57 43 36,143.01 8137 Investment Expense 100,000.00 00 100,000.00 00 00 57,805.00 42,195.00 58 106,456.00 8330 Pension Payments 625,000.00 00 625,000.00 00 00 348,399.99 276,600.01 56 510,423.48 D T -Non-Divisional olx $771,300.00 0.00 $771,300.00 0.00 0.00 $435,154.89 $336,145.11 56% $666,597.04 Unit Ott Non-Departmental Tot.,:4 $771,300.00 0.00 $771,300.00 0.00 0.00 $435,154.89 $336,145.11 56% $666,597.04 EXPENSE TOTALS $771,300.00 0.00 $771,300.00 0.00 0.00 $435,154.89 $336,145.11 56% $666,597.04 Fund 10-Police Pension Fund Totals REVENUE TOTALS 3,020,000.00 00 3,020,000.00 00 00 2,634,931.79 385,068.21 87°70 3,753,413.96 EXPENSE TOTALS 771,300.00 00 771,300.00 00 00 435,154.89 336,145.11 56% 666,597.04 sand 10-Police Pension Fund Totals $2,248,700.00 0.00 $2,248,700.00 0.00 0.00 $2,199,776.90 $48,923.10 3,086,816.92 Run by Traci Pleckham on 12/05/2019 11:49:35 AM Page 11 of 13 46 Budget Performance Report1EIr1 ,,, 1...1-1 I 1 11IPN1.'1a1l 1 111 VILLAGE OF Fiscal Year to Date 12/05/19 PLAINFIELD Exclude Rollup Account Adopted Budget Amended Current Month YTD YTD Budget-YTD %Used/ Account Account Description Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year Total Fund 14-D.A.R.E.Fund REVENUE 0800.800 Interest Income 100.00 00 100.00 00 00 157.48 57.48) 157 314.73 0801.840 DARE Contribution 22,000.00 00 22,000.00 00 00 13,987.46 8,012.54 64 24,820.28 REVENUE TOTALS $22,100.00 0.00 22,100.00 0.00 0.00 14,144.94 7,955.06 64%25,135.01 EXPENSE Unit 00-Non-Departmental Division 00-Non-Divisional 8245 D.A.R.E.Program 23,000.00 00 23,000.00 00 00 13,478.81 9,521.19 59 18,948.30 Division 00-Non-Divisional Totals $23,000.00 0.00 23,000.00 0.00 0.00 13,478.81 9,521.19 59% $18,948.30 Unit 00-Non-Departmental Totals 23,000.00 0.00 23,000.00 0.00 0.00 13,478.81 9,521.19 59%18,948.30 EXPENSE TOTALS $23,000.00 0.00 $23,000.00 0.00 0.00 $13,478.81 9,521.19 59%18,948.30 Fund 14-D.A.R.E.Fund Totals REVENUE TOTALS 22,100.00 00 22,100.00 00 00 14,144.94 7,955.06 64%25,135.01 EXPENSE TOTALS 23,000.00 00 23,000.00 00 00 13,478.81 9,521.19 59% 18,948.30 Fund 14-D.A.R.E.Fund Totals 900.00) 0.00 900.00) 0.00 0.00 666.13 ($1,566.13) 6,186.71 r ' 17-Tax Increment Financing-Downtown REVENUE 0400.401 Property Tax Revenue 730,000.00 00 730,000.00 00 00 730,522.10 522.10) 100 726,815.80 0800.800 Interest Income 10,000.00 00 10,000.00 00 00 8,583.98 1,416.02 86 17,553.21 REVENUE TOTALS $740,000.00 0.00 $740,000.00 0.00 0.00 $739,106.08 893.92 100% $744,369.01 EXPENSE Unit 00-Non-Departme•> . Division 91-Capital 8135 Contractual Services 260,000.00 00 260,000.00 2,795.00 00 45,031.11 214,968.89 17 81,868.29 9199 Facade Improvements 40,000.00 00 40,000.00 00 00 00 40,000.00 0 2,500.00 Division 91-Capital Totais $300,000.00 0.00 $300,000.00 2,795.00 0.00 45,031.11 $254,968.89 15% $84,368.29 Division 99-Transfers 9901 Transfer to General 50,000.00 00 50,000.00 00 00 00 50,000.00 0 00 9911 Transfer to Capital Improvements 500,000.00 00 500,000.00 00 00 00 500,000.00 0 500,000.00 Division 99-Transfers TotaE: $550,000.00 0.00 $550,000.00 0.00 0.00 0.00 $550,000.00 0% $500,000.00 Unit 00-Non-Departmental Totals $850,000.00 0.00 $850,000.00 2,795.00 0.00 45,031.11 $804,968.89 50/ 0 $584,368.29 EXPENSE TOTALS $850,000.00 0.00 $850,000.00 2,795.00 0.00 $45,031.11 $804,968.89 5% $584,368.29 Fund 17-Tax Increment Financing-Downtown Totals REVENUE TOTALS 740,000.00 00 740,000.00 00 00 739,106.08 893.92 100% 744,369.01 EXPENSE TOTALS 850,000.00 00 850,000.00 2,795.00 00 45,031.11 804,968.89 5% 584,368.29 Fund 17-Tax Increment Financing-Downtown Totals ($110,000.00) 0.00 ($110,000.00) ($2,795.00) 0.00 $694,074.97 ($804,074.97)160,000.72 Run by Traci Pleckham on 12/05/2019 11:49:35 AM Page 12 of 13 47 U .. Wm_ 1!1 Budget Performance Report 1-11. •1 1 1 . -11..0...1.1. 1 111 VILLAGE OF Fiscal Year to Date 12/05/19 PLAINFIELD Exclude Rollup Account Adopted Budget Amended Current Month YTD YTD Budget-YTD %Used/ Account Account Description Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year Total Fund 18-Tax Increment Financing-Rt 30 REVENUE 0400.401 Property Tax Revenue 00 00 00 00 00 967.05 967.05) +++ 00 REVENUE TOTALS 0.00 0.00 0.00 0.00 0.00 967.05 967.05) +++ 0.00 Fund 18-Tax Increment Financing-Rt 30 Totals REVENUE TOTALS 00 00 00 00 00 967.05 967.05) +++ 00 EXPENSE TOTALS 00 00 00 00 00 00 00 +++ 00 Fund 18-Tax Increment Financing-Rt 30 Total. 0.00 0.00 0.00 0.00 0.00 967.05 967.05) 0.00 Fund 27-Alcohol Enforcement Fund REVENUE 0600.610 Alcohol Fines 15,000.00 00 15,000.00 00 00 11,419.00 3,581.00 76 22,680.00 0800.800 Interest Income 500.00 00 500.00 00 00 545.95 45.95) 109 1,163.72 REVENUE TOTALS 15,500.00 0.00 15,500.00 0.00 0.00 11,964.95 3,535.05 77% $23,843.72 EXPENSE Unit 00-Non-Departmental Division 99-Transfers 9901 Transfer to General 25,000.00 00 25,000.00 00 00 00 25,000.00 0 25,000.00 Division 99-Transfers Totals 25,000.00 0.00 $25,000.00 0.00 0.00 0.00 $25,000.00 0% $25,000.00 Unit 00-Non-Departmental Totals $25,000.00 0.00 25,000.00 0.00 0.00 0.00 $25,000.00 0% $25,000.00 EXPENSE TOTALS 25,000.00 0.00 25,000.00 0.00 0.00 0.00 $25,000.00 0% $25,000.00 Fund 27-Alcohol Enforcement Fund Totals REVENUE TOTALS 15,500.00 00 15,500.00 00 00 11,964.95 3,535.05 77%23,843.72 EXPENSE TOTALS 25,000.00 00 25,000.00 00 00 00 25,000.00 0%25,000.00 Fund 27-Alcohol Enforcement Fund Totals ($9,500.00) 0.00 ($9,500.00) 0.00 0.00 11,964.95 ($21,464.95)1,156.28) Grand Totals REVENUE TOTALS 35,172,226.00 00 35,172,226.00 13,946.09 00 26,984,424.53 8,187,801.47 77% 36,138,839.30 EXPENSE TOTALS 19,884,810.00 00 19,884,810.00 197,500.44 1,844.55 12,124,569.73 7,758,395.72 61% 19,495,879.74 Grand Tota, $15,287,416.00 0.00 $15,287,416.00 ($183,554.35) ($1,844.55) $14,859,854.80 $429,405.75 16,642,959.56 Run by Traci Pleckham on 12/05/2019 11:49:35 AM Page 13 of 13 48