HomeMy Public PortalAbout11-25-2019 COW Agenda and PacketCommittee of the Whole Workshop of the President and the Board of
Trustees
Monday, November 25, 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
October 14, 2019.
10-14-2019 COW Minutes
C.PRESIDENTIAL COMMENTS
C.1.Presentation to Trustee Newton
D.TRUSTEES COMMENTS
E.PUBLIC COMMENTS (3-5 minutes)
F.WORKSHOP
F.1.2020-2021 DRAFT FISCAL YEAR BUDGET
Staff will give an overview of the proposed Police Department Budget.
2020-2021 Draft Fiscal Year Police Budget Detail
Budget Performance Report through November 21, 2019
F.2.YEAR 2019 TAX LEVY
Year 2019 Tax Levy Staff Report
Police Pension Fund Valuation as of May 1, 2019
REMINDERS -
•November 28-29 Village Offices Closed
•December 2 Village Board Meeting – 7:00 p.m.
•December 3 Plan Commission – 7:00 p.m.
1
Committee of the Whole Workshop of the President and the Board of Trustees Page - 2
•December 9 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 October 14, 2019
In the Boardroom
Mayor Collins called the meeting to order at 7:00p.m. Board Present: Mayor Collins, Trustee
Wojowski, Trustee Benton, Trustee Bonuchi, Trustee Calkins, Trustee Larson, and Trustee Newton.
Others present: Brian Murphy, Administrator; 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 5 persons in the audience.
Trustee Bonuchi moved to approve the Minutes of the Committee of the Whole Workshop held on
September 23, 2019. Second by Trustee Larson. Voice Vote. All in favor, 0 opposed. Motion
carried. Motion carried.
PRESIDENTIAL COMMENTS
No Comments.
TRUSTEE COMMENTS
No Comments.
PUBLIC COMMENTS
No Comments.
WORKSHOP
1) 2019 AUDIT
Mr. Dan Berg and Ms. Sarah Montanari reviewed the 2018-2019 Fiscal Year Audit. Ms. Montanari
stated that they have issued a clean, unmodified opinion which is the best opinion that they can
provide to the Village.
2)FY 2019-2020 BUDGET UPDATE
Mrs. Traci Pleckham, Management Services Director, gave an update on the current fiscal year
budget. Mrs. Pleckham gave an overview of the current general fund revenues and expenses. Mrs.
Pleckham reviewed revenues including property taxes, municipal sales tax, local use tax, local
income tax, personal property replacement tax, building permit fees, refuse fees, local motor fuel tax,
and franchise fees. Mrs. Pleckham then gave a summary of general fund expenses.
Mayor Collins read the reminders.
On a motion from Trustee Larson and second by Trustee Bonuchi, the meeting adjourned at
7:38 p.m.
Michelle Gibas, Village Clerk
3
Ili IN .,,...._, ",.,.,at,, General Fund
I 4 ,-tP.,..,.r.,. I ;,:
P1 AI NFIELD Police 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
Total Police Department
Salaries and Wages 6,673,211 6,839,442 7,076,406 7,431,449 7,740,460 8,432,741
Benefits 2,840,912 3,064,648 3,342,703 3,485,115 3,563,659 3,960,448
Utilities 57,103 57,217 59,597 68,639 65,280 64,304
Supplies and Commodities 296,740 284,324 319,678 316,388 381,950 377,920
Contractual Services 1,040,595 1,067,694 981,636 1,083,725 1,251,667 1,304,274
Other 42,164 50,006 133,141 300,794 202,200 155,650
Total - Police Department $10,950,725 $11,363,331 $11,913,161 $12,686,110 $13,205,216 $14,295,337
Police Division Expense History
16,000,000
14,000,000
12,000,000
10,000,000
Other
al$8,000,000
Contractual Services
NI 11111 Ell III Supplies and Commodities
i $6,000,000
an al h. Utilities
4,000,000 1111
1111 a Benefits
2,000,000 .1111
Salaries and Wages
0 I
FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021
Actual Actual Actual Actual Adopted Proposed
Budget Budget
4
I General Fund
1-I .IIvI -°IE.
IiIi
5
1» mot iii ., L- General Fund
t i-n•s,i•n,q. .0
VILLAGE OF
PI,AINFIELD Police 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: 51-Police Operations
SAL-Salaries and Wages
Salaries-Full Time 3,329,740 3,612,010 3,972,682 4,105,555 4,778,497
Salaries-Part Time 0 257,795 245,263 275,000 265,000
Salaries-Overtime 263,296 331,280 306,702 350,000 300,000
Total:Salaries and Wages $3,593,036 $4,201,085 $4,524,647 $4,730,555 $5,343,497
BEN - Benefits
FICA 214,599 253,591 271,691 293,294 331,297
Medicare 50,935 59,593 64,010 68,593 77,481
IMRF 6,289 42,654 41,580 55,689 55,011
Employer Pension Contrib. 1,101,142 1,364,479 1,402,475 1,300,000 1,580,000
Employee Insurance 528,507 579,887 615,423 689,835 740,625
Deferred Comp. Contrib. 91,162 92,270 122,332 130,000 130,000
Travel/Training 35,571 32,525 32,232 36,000 43,000
Total: Benefits $2,028,205 $2,424,999 $2,549,743 $2,573,411 $2,957,414
UTIL- Utilities
Telephone/Internet 24,799 24,613 29,305 27,180 13,604
Cellular Phones/Pagers 5,005 5,368 5,365 5,500 20,844
Total: Utilities $29,804 $29,981 $34,670 $32,680 $34,448
SUPP-Supplies and Commodities
Office Supplies/Postage 13,298 12,680 14,553 13,500 13,500
Replacement Supplies 15,850 18,015 18,178 18,000 18,000
Dues&Subscriptions 1,388 1,223 1,124 3,400 3,900
Gas/Oil/Mileage/Carwash 63,833 81,113 91,570 85,000 85,000
K-9 Unit 4,514 4,578 4,655 4,000 4,000
Uniforms/Clothing 32,246 41,291 37,983 41,000 48,000
Ammunition/Weapons 25,791 27,884 32,522 28,000 28,000
Bike Unit 0 1,260 825 6,000 3,500
Total:Supplies&Commodities $156,920 $188,044 $201,410 $198,900 $203,900
Contrac-Contractual Services
Traffic Programs 21,124 21,518 20,302 24,800 21,400
Radio Maintenance 272 2,933 955 2,000 2,000
Maintenance Contracts/Lease 11,702 13,552 15,656 16,567 19,275
Vehicle Maintenance 68,997 61,079 78,393 60,000 65,000
Contractual Services 14,533 12,479 13,887 15,000 16,000
Contractual Svcs-WESCOM 564,842 582,731 602,845 603,000 608,000
Animal Control 0 6,710 4,440 14,000 9,000
Total:Contractual Services $681,470 $701,002 $736,478 $735,367 $740,675
Total: Police Operations 6,489,435 $7,545,111 $8,046,948 $8,270,913 $9,279,934
6
r, .,,1I,, General Fund
I *1...1 1 I-11 .1/-0I0 Ilt
vNG
PLAINFIELD Police 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: 52-Police Administration
SAL-Salaries and Wages
Salaries-Full Time 1,290,356 815,503 1,042,704 1,095,531 1,129,154
Salaries-Overtime 94,859 85,112 79,262 100,000 75,000
Total:Salaries and Wages $1,385,215 $900,615 $1,121,966 $1,195,531 $1,204,154
BEN -Benefits
FICA 84,084 63,061 68,145 74,123 74,658
Medicare 19,883 14,748 15,999 17,335 17,460
IMRF 0 0 6,773 8,195 8,400
Employee Insurance 210,770 167,976 177,746 186,309 182,720
Deferred Comp. Contrib. 40,468 26,657 39,548 45,000 45,000
Travel/Training 12,632 8,938 10,445 15,600 13,000
Total: Benefits $367,837 $281,380 $318,656 $346,562 $341,238
UTIL- Utilities
Telephone/Internet 1,593 1,728 2,238 1,500 1,404
Cellular Phones/Pagers 7,514 9,243 11,609 9,800 12,924
Total: Utilities 9,107 $10,971 $13,847 $11,300 $14,328
SUPP-Supplies and Commodities
Office Supplies/Postage 5,294 4,822 2,488 5,500 5,500
Replacement Supplies 269 4,824 893 4,000 4,000
Dues&Subscriptions 3,512 3,470 5,050 4,070 4,070
Gas/Oil/Mileage/Carwash 20,480 15,810 16,974 25,000 25,000
Crime Scene/Evidence Tech 7,338 10,649 7,851 8,000 5,000
Uniforms/Clothing 10,061 6,105 7,199 8,900 8,900
Total:Supplies&Commodities $46,954 $45,680 $40,455 $55,470 $52,470
Contrac-Contractual Services
Explorer Program 4,369 9,304 6,471 5,000 5,000
Radio Maintenance 0 415 0 500 500
Maintenance Contracts/Lease 4,048 3,825 3,735 4,200 5,420
Vehicle Maintenance 12,013 11,889 14,102 15,000 15,000
Background Check Svcs.995 1,764 2,330 2,500 2,500
Accreditation 8,437 4,595 4,595 4,100 8,000
Total:Contractual Services $29,862 $31,792 $31,233 $31,300 $36,420
Total: Police Administration 1,838,975 $1,270,438 $1,526,157 $1,640,163 $1,648,610
7
ie.. i_tw.... .•
ii . ,i General Fund
i..,-, ' 1-.11.I.i1+11 ...111
VILLAGE
PLAINFIELD Police 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: 53-Police Records
SAL-Salaries and Wages
Salaries-Full Time 401,678 445,733 216,142 222,150 230,738
Salaries-Part Time 0 21,248 27,636 36,311 37,219
Salaries-Overtime 10,112 7,263 6,235 6,000 6,000
Total:Salaries and Wages $411,790 $474,244 $250,013 $264,461 $273,957
BEN -Benefits
FICA 24,805 28,561 15,877 16,397 16,985
Medicare 5,806 6,680 3,713 3,835 3,972
IMRF 33,213 34,268 26,816 31,735 32,875
Employee Insurance 115,826 100,044 56,492 31,666 31,908
Deferred Comp. Contrib. 11,003 11,047 8,966 12,000 12,000
Travel/Training 1,797 4,063 2,136 2,750 2,750
Total: Benefits $192,450 $184,663 $114,000 $98,383 $100,490
UTIL-Utilities
Telephone/Internet 1,593 1,728 2,238 1,500 1,404
Total: Utilities 1,593 1,728 2,238 1,500 1,404
SUPP-Supplies and Commodities
Office Supplies/Postage 7,380 10,377 8,624 10,000 10,000
Dues&Subscriptions 87 50 15 480 350
Uniforms/Clothing 1,611 2,828 1,019 1,500 1,500
Total:Supplies&Commodities 9,078 $13,255 9,658 $11,980 $11,850
Contrac-Contractual Services
Maintenance Contracts/Lease 2,160 3,585 2,160 4,460 5,540
Total:Contractual Services 2,160 3,585 2,160 4,460 5,540
Total: Police Records 617,071 $677,475 $378,069 $380,784 $393,241
8
Nita,... "m. si""L,., General Fund
PLAINFIELD Police 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: 54-Seizure/Forfeiture
Contrac-Contractual Services
Seizure/Forfeiture Exp. 156,827 85,954 123,515 225,000 225,000
Total:Contractual Services $156,827 $85,954 $123,515 $225,000 $225,000
Total:Seizure/Forfeiture 156,827 $85,954 $123,515 $225,000 $225,000
Division:55-Police Special Activities
SAL-Salaries and Wages
Salaries-Special Activities 46,555 88,380 77,522 32,513 32,513
Total:Salaries and Wages $46,555 $88,380 $77,522 $32,513 $32,513
BEN - Benefits
FICA 2,621 4,949 4,927 2,016 2,016
Medicare 620 1,159 1,169 471 471
Total: Benefits 3,241 6,108 6,096 2,487 2,487
SUPP-Supplies and Commodities
Mobile Field Force 0 201 0 1,000 0
Total:Supplies&Commodities 0 201 0 1,000 0
Total: Police Special Activities 49,796 $94,689 $83,618 $36,000 $35,000
9
General Fund
I I-IP.1.,-t.,. III
VILLAGEE OF
PLAINPolice 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: 56-Community Services
SAL-Salaries and Wages
Salaries-Full Time 556,142 764,801 909,075 952,453 978,194
Salaries-Part Time 210,280 8,947) 203 0 0
Salaries-Overtime 28,729 49,411 46,408 40,000 45,000
Total:Salaries and Wages $795,151 $805,265 $955,686 $992,453 $1,023,194
BEN - Benefits
FICA 47,860 42,711 57,350 61,532 63,438
Medicare 11,231 10,033 13,508 14,391 14,836
IMRF 49,462 6,224 5,514 7,191 7,640
Employee Insurance 113,185 113,711 164,841 172,396 174,016
Deferred Comp. Contrib. 5,100 17,519 27,000 22,000 29,000
Travel/Training 10,133 14,172 12,670 20,000 15,000
Total:Benefits $236,971 $204,370 $280,883 $297,510 $303,930
UTIL- Utilities
Telephone/Internet 1,593 1,728 2,238 2,000 1,404
Cellular Phones/Pagers 2,759 2,721 2,709 3,000 3,036
Total: Utilities 4,352 4,449 4,947 5,000 4,440
SUPP-Supplies and Commodities
Office Supplies/Postage 2,898 1,333 2,661 3,100 3,600
Replacement Supplies 752 7,735 931 6,200 6,200
Dues&Subscriptions 1,904 1,260 1,319 2,200 2,200
Gas/Oil/Mileage/Carwash 14,878 8,793 9,783 16,000 13,000
Uniforms/Clothing 5,957 6,271 4,443 8,600 9,000
Total:Supplies&Commodities $26,389 $25,392 $19,137 $36,100 $34,000
Contrac-Contractual Services
Community Programs 3,590 7,508 4,895 5,500 8,500
Community Prog-Alc/Tobacco 145 128 152 2,500 2,500
Radio Maintenance 33,761 7,813 25,962 26,800 26,800
Maintenance Contracts 1,023 0 0 2,180 2,520
Vehicle Maintenance 22,653 8,627 16,321 25,000 20,000
DARE Program 1,983 4,818 4,159 5,000 5,000
Chaplaincy Program 2,655 1,330 1,097 3,000 3,000
Animal Control 7,140 0 0 0 0
Total:Contractual Services $72,950 $30,224 $52,586 $69,980 $68,320
OTHER-Other
Shop With a Cop 9,500 14,040 13,600 10,000 10,000
Total:OTHER-Other 9,500 $14,040 $13,600 $10,000 $10,000
Total:Community Services 1,145,313 $1,083,740 $1,326,839 $1,411,043 $1,443,884
10
i;1,! ,;,;;..._, ""i,,.,. General Fund
1..1-I 1 1-I1••J••-,•1. I l l
PLAIINFIELD Police 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: 57-Court Services
SAL-Salaries and Wages
Salaries-Full Time 121,359 126,146 129,880 134,680 142,714
Salaries- Part Time 37,461 24,116 25,268 25,476 40,800
Salaries-Overtime 0 110 100 1,000 1,000
Total:Salaries and Wages $158,820 $150,372 $155,248 $161,156 $184,514
BEN - Benefits
FICA 9,695 9,039 9,282 9,992 11,440
Medicare 2,267 2,114 2,171 2,337 2,675
IMRF 18,054 16,862 16,579 18,944 21,747
Employee Insurance 37,630 38,394 40,435 42,245 42,457
Deferred Comp. Contrib. 4,807 4,843 4,879 5,500 5,500
Travel/Training 161 993 2,252 3,000 3,000
Total: Benefits $72,614 $72,245 $75,598 $82,018 $86,819
UTIL-Utilities
Telephone/Internet 1,283 1,349 1,741 1,500 1,092
Total: Utilities 1,283 1,349 1,741 1,500 1,092
SUPP-Supplies and Commodities
Office Supplies/Postage 8,745 8,722 8,300 10,000 10,000
Dues&Subscriptions 8,151 8,986 9,808 9,800 10,000
Uniforms/Clothing 564 339 809 600 600
Total:Supplies&Commodities $17,460 $18,047 $18,917 $20,400 $20,600
Contrac-Contractual Services
Maintenance Contracts/Lease 1,920 1,920 1,920 1,920 2,160
Legal Fees 8,405 13,749 13,816 20,000 20,000
Total:Contractual Services $10,325 $15,669 $15,736 $21,920 $22,160
Total:Court Services 260,502 $257,682 $267,240 $286,994 $315,185
Division:91-Capital
OTHER-Other
Office Furniture& Equip. 5,864 716 4,590 8,000 8,000
Machinery and Equipment 13,396 103,600 262,011 162,200 115,650
Total:OTHER-Other $19,260 $104,316 $266,601 $170,200 $123,650
Total:Capital 19,260 $104,316 $266,601 $170,200 $123,650
Division:93-Contingencies
OTHER-Other
Contingencies 13,888 11,767 18,119 12,000 12,000
Total:OTHER-Other $13,888 $11,767 $18,119 $12,000 $12,000
Total:Contingencies 13,888 $11,767 $18,119 $12,000 $12,000
Total: Police Department 11,127,444 $11,670,140 $12,605,380 $13,051,045 $14,125,586 11
General Fund
VILLAGE OE
PLAINFIELD Police 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
Unit:07-PEMA
SAL-Salaries and Wages
Salaries-Full Time 124,512 122,865 0 0 0
Total:Salaries and Wages $124,512 $122,865 0 0 0
BEN - Benefits
FICA 7,126 7,685 0 0 0
Medicare 1,790 1,797 0 0 0
Employee Insurance 18,319 19,502 0 0 0
Deferred Comp. Contrib. 4,022 1,700 0 0 0
Travel/Training 572 1,299 1,377 4,000 4,000
Total:Benefits $31,829 $31,983 1,377 4,000 4,000
UTIL- Utilities
Telephone/Internet 5,347 6,263 6,590 6,000 6,000
Cellular Phones/Pagers 3,451 2,775 2,117 5,200 780
Total: Utilities 8,798 9,038 8,707 $11,200 6,780
SUPP-Supplies and Commodities
Office Supplies/Postage 303 185 739 1,000 1,000
Replacement Supplies 1,473 2,374 2,215 10,000 6,000
Dues&Subscriptions 1,910 2,228 3,153 4,000 4,000
Gas/Oil/Mileage/Carwash 5,236 5,313 4,461 8,000 8,000
Supplies/Hardware 182 585 1,245 2,000 2,000
Supplies/Hardware-ESDA 617 370 514 2,000 2,000
Uniforms/Clothing 4,075 4,215 2,094 6,000 6,000
Bike Unit 0 16 0 500 1,500
Total:Supplies&Commodities $13,796 $15,286 $14,421 $33,500 $30,500
Contrac-Contractual Services
Emergency Operation Center 0 0 933 1,000 1,000
Police Public Relations 0 0 524 2,000 3,000
Disaster Plan/Exercises/NIMS 26 0 216 3,000 3,000
Radio Maintenance 7,176 9,856 10,939 15,000 12,000
Maintenance Contracts/Lease 1,312 1,295 1,269 1,200 1,200
Building Maintenance 0 3,589 1,059 5,000 20,000
Vehicle Maintenance 19,361 16,904 17,620 20,000 20,000
Siren Maintenance 9,556 10,214 10,246 13,000 13,000
Contractual Services 740 1,315 194 5,250 5,250
CERT/Cadet Program 2,153 1,545 2,001 5,500 5,500
PEMA Search and Rescue 0 4,129 1,500 4,000 4,000
Total:Contractual Services $40,324 $48,847 $46,501 $74,950 $87,950
OTHER-Other
Office Furniture& Equipment 684 304 228 2,000 2,000
Machinery and Equipment 5,514 1,409 1,710 5,000 5,000
Contingencies 1,160 1,305 536 3,000 3,000
Total:OTHER-Other 7,358 3,018 2,474 $10,000 $10,000
Total: PEMA 226,617 $231,037 $73,480 $133,650 $139,230
12
I,;I;
m-_, ....,
a,.., General Fund
VILLAGEF
PLAINFIELD Police 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
Unit: 50-Police Commission
Division:02-Administration Program
SAL-Salaries and Wages
Salaries-Part Time 681 1,679 2,101 5,500 5,500
Total:Salaries and Wages 681 1,679 2,101 5,500 5,500
BEN - Benefits
FICA 35 105 118 341 341
Medicare 8 25 28 80 80
Travel/Training 0 0 138 1,000 1,000
Total: Benefits 43 130 284 1,421 1,421
SUPP-Supplies and Commodities
Office Supplies/Postage 133 496 412 2,000 2,000
Dues&Subscriptions 375 375 375 600 600
Total:Supplies&Commodities 508 871 787 2,600 2,600
Contrac-Contractual Services
Legal Fees 0 0 0 1,000 1,000
Police Testing/Hiring 8,038 8,664 4,078 10,000 20,000
Contractual Services 0 640 0 0 0
Total:Contractual Services 8,038 9,304 4,078 $11,000 $21,000
Total: Police Commission 9,270 $11,984 7,250 $20,521 $30,521
Police Division Total 11,363,331 $11,913,161 $12,686,110 $13,205,216 $14,295,337
13
Performance
ii1
1I7 um rtr__ 1 w r
i 1 --
VILLAGE o
r •, ,'
Fiscal Year to Date 11/21/19
PLAINFIELD Exclude R llup 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 YTD
Fund 01-General Fund
EXPENSE
Unit O5-Police Department
Division 02-Administration Program
1005 Salaries-Full Time 322,291.00 00 322,291.00 22,821.43 00 183,062.17 139,228.83 57 178,129.24
1015 Salaries-Part Time 35,000.00 00 35,000.00 2,450.48 00 18,632.35 16,367.65 53 19,514.36
1800 Salaries-Overtime 1,000.00 00 1,000.00 507.43 00 658.89 341.11 66 262.68
2000 FICA 22,214.00 00 22,214.00 1,521.99 00 12,003.30 10,210.70 54 11,732.00
2001 Medicare 5,195.00 00 5,195.00 355.94 00 2,807.20 2,387.80 54 2,743.77
2010 IMRF 24,728.00 00 24,728.00 1,409.23 00 11,073.50 13,654.50 45 12,824.24
2020 Employee Insurance 67,730.00 00 67,730.00 5,377.19 00 42,911.22 24,818.78 63 37,703.93
2025 Deferred Comp.Contribution 8,000.00 00 8,000.00 00 00 00 8,000.00 0 00
3000 Travel/Training 7,000.00 00 7,000.00 35.00 00 2,601.94 4,398.06 37 1,367.54
3001 Education/School 3,000.00 00 3,000.00 1,302.50 00 1,813.66 1,186.34 60 00
3015 IL Unemployment Insurance 20,000.00 00 20,000.00 00 00 8,861.10 11,138.90 44 8,844.70
4000 Telephone/Internet 1,300.00 00 1,300.00 00 00 347.03 952.97 27 1,199.47
4005 Cellular Phones/Pagers 800.00 00 800.00 56.28 00 335.98 464.02 42 413.69
5005 Office Supplies/Postage 8,000.00 00 8,000.00 282.01 00 2,075.07 5,924.93 26 3,323.93
5010 Replacement Supplies 3,500.00 00 3,500.00 34.94 00 1,627.17 1,872.83 46 640.48
5015 Dues&Subscriptions 5,000.00 00 5,000.00 00 00 2,184.00 2,816.00 44 2,127.05
5020 Gas/Oil/Mileage/Carwash 3,700.00 00 3,700.00 00 00 603.59 3,096.41 16 629.55
5095 Uniforms/Clothing 1,800.00 00 1,800.00 00 00 1,462.31 337.69 81 1,437.48
8035 Maintenance Contracts/Lease 7,190.00 00 7,190.00 565.59 00 3,571.00 3,619.00 50 3,225.53
8040 Custodian 60,000.00 00 60,000.00 626.32 00 20,982.52 39,017.48 35 19,721.65
8060 Vehicle Maintenance 2,500.00 00 2,500.00 223.72 00 262.63 2,237.37 11 62.49
8135 Contractual Services 8,000.00 00 8,000.00 454.00 00 1,895.00 6,105.00 24 1,395.93
Division 02-Administration Program Totals $617,948.00 0.00 $617,948.00 $38,024.05 0.00 $319,771.63 $298,176.37 52% $307,299.71
Division 51-Police Operations
1005 Salaries-Full Time 4,105,555.00 00 4,105,555.00 323,475.33 00 2,403,187.35 1,702,367.65 59 2,252,437.16
1015 Salaries-Part Time 275,000.00 00 275,000.00 21,904.24 00 161,762.69 113,237.31 59 145,989.28
1800 Salaries-Overtime 350,000.00 00 350,000.00 17,084.35 00 172,545.90 177,454.10 49 193,068.32
2000 FICA 293,294.00 00 293,294.00 21,776.41 00 165,108.86 128,185.14 56 157,125.14
2001 Medicare 68,593.00 00 68,593.00 5,149.57 00 38,670.83 29,922.17 56 36,747.03
2010 IMRF 55,689.00 00 55,689.00 3,109.54 00 23,745.71 31,943.29 43 25,934.74
2011 Employer Pension Contributions 1,300,000.00 00 1,300,000.00 102.91 00 1,267,745.36 32,254.64 98 1,386,394.66
2020 Employee Insurance 689,835.00 00 689,835.00 48,918.98 00 417,765.15 272,069.85 61 354,736.63
2025 Deferred Comp.Contribution 130,000.00 00 130,000.00 00 00 00 130,000.00 0 00
3000 Travel/Training 36,000.00 00 36,000.00 1,444.56 00 28,498.26 7,501.74 79 15,568.27
4000 Telephone/Internet 27,180.00 00 27,180.00 2,376.47 00 22,178.34 5,001.66 82 14,126.15
4005 Cellular Phones/Pagers 5,500.00 00 5,500.00 469.22 00 2,824.89 2,675.11 51 2,617.36
5005 Office Supplies/Postage 13,500.00 00 13,500.00 1,220.93 00 4,429.56 9,070.44 33 6,942.88
Run by Traci Pleckham on 11/21/2019 01:23:09 PM Page 1 of 6
14
B tnull... _i._inr, i .__-u„i w i Report
I-I 1 I I ....HPluUmIIls i III
VILLAGE OF
Fiscal Year to Date 11/21/19
PLAINFIELD Exclude RolUup 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 YTD
Fund 01-General Fund
EXPENSE
Unit 05-Police Department
Division 51-Police Operations
5010 Replacement Supplies 18,000.00 00 18,000.00 951.84 00 3,364.36 14,635.64 19 7,210.69
5015 Dues&Subscriptions 3,400.00 00 3,400.00 00 00 401.50 2,998.50 12 387.50
5020 Gas/Oil/Mileage/Carwash 85,000.00 00 85,000.00 104.00 00 53,235.25 31,764.75 63 50,020.70
5068 K-9 Unit 4,000.00 00 4,000.00 00 00 1,178.10 2,821.90 29 1,431.17
5095 Uniforms/Clothing 41,000.00 00 41,000.00 2,779.06 00 25,245.16 15,754.84 62 20,205.44
5100 Ammunition/Weapons 28,000.00 00 28,000.00 2,245.00 00 3,014.73 24,985.27 11 9,515.27
5115.001 Traffic Programs 24,800.00 00 24,800.00 4,247.00 00 8,522.00 16,278.00 34 4,130.76
8003 Radio Maintenance 2,000.00 00 2,000.00 00 00 00 2,000.00 0 519.99
8035 Maintenance Contracts/Lease 16,567.00 00 16,567.00 76.96 00 2,243.07 14,323.93 14 13,176.00
8060 Vehicle Maintenance 60,000.00 00 60,000.00 5,632.18 00 32,081.68 27,918.32 53 36,699.04
8069 Bike Unit 6,000.00 00 6,000.00 00 00 3,736.53 2,263.47 62 825.00
8135 Contractual Services 15,000.00 00 15,000.00 00 00 12,478.92 2,521.08 83 12,478.92
8265 Contractual Services-Wescom 603,000.00 00 603,000.00 00 00 350,828.94 252,171.06 58 351,659.56
8267 Animal Control 14,000.00 00 14,000.00 500.00 00 4,350.00 9,650.00 31 1,790.00
Division 51-Police Operations Totals $8,270,913.00 0.00 $8,270,913.00 $463,568.55 0.00 $5,209,143.14 $3,061,769.86 63% $5,101,737.66
Division 52-Police Administration
1005 Salaries-Full Time 1,095,531.00 00 1,095,531.00 73,629.72 00 588,593.29 506,937.71 54 595,280.47
1800 Salaries-Overtime 100,000.00 00 100,000.00 1,810.59 00 39,039.81 60,960.19 39 57,606.55
2000 FICA 74,123.00 00 74,123.00 4,542.63 00 38,056.15 36,066.85 51 39,714.24
2001 Medicare 17,335.00 00 17,335.00 1,062.40 00 8,900.22 8,434.78 51 9,287.99
2010 IMRF 8,195.00 00 8,195.00 503.36 00 3,760.18 4,434.82 46 3,959.73
2020 Employee Insurance 186,309.00 00 186,309.00 12,691.79 00 116,969.33 69,339.67 63 103,676.47
2025 Deferred Comp.Contribution 45,000.00 00 45,000.00 00 00 00 45,000.00 0 00
3000 Travel/Training 15,600.00 00 15,600.00 95.00 00 7,925.67 7,674.33 51 8,606.58
4000 Telephone/Internet 1,500.00 00 1,500.00 00 00 413.74 1,086.26 28 1,542.16
4005 Cellular Phones/Pagers 9,800.00 00 9,800.00 910.75 00 5,734.14 4,065.86 59' 5,937.93
5005 Office Supplies/Postage 5,500.00 00 5,500.00 855.70 00 1,566.64 3,933.36 28 1,589.11
5010 Replacement Supplies 4,000.00 00 4,000.00 00 00 00 4,000.00 0 64.00
5015 Dues&Subscriptions 4,070.00 00 4,070.00 00 00 2,617.65 1,452.35 64 3,620.00
5020 Gas/Oil/Mileage/Carwash 25,000.00 00 25,000.00 321.81 00 9,455.77 15,544.23 38 8,905.53
5040.002 Crime Scene/Evidence Tech Supply 8,000.00 00 8,000.00 00 00 4,083.17 3,916.83 51 2,501.05
5095 Uniforms/Clothing 8,900.00 00 8,900.00 947.85 00 4,867.00 4,033.00 55 4,527.05
5115.004 Community Programs-Explorer Program 5,000.00 00 5,000.00 590.20 00 10,015.58 5,015.58) 200 3,526.30
8003 Radio Maintenance 500.00 00 500.00 00 00 00 500.00 0 00
8035 Maintenance Contracts/Lease 4,200.00 00 4,200.00 41.22 00 1,544.33 2,655.67 37 1,650.00
8060 Vehicle Maintenance 15,000.00 00 15,000.00 3,068.87 00 10,375.69 4,624.31 69 10,677.56
8250 Background Check Services 2,500.00 00 2,500.00 00 00 872.80 1,627.20 35 1,243.83
Run by Traci Pleckham on 11/21/2019 01:23:09 PM Page 2 of 6
15
e1• 1 1..1.. 1
Ilii...
1 , ;1111 iiir r W!! Budget Performance Report
ui 'I 111
VILLAGE OP
s i Year to Date 11/2:1/19
PLAINFIELD Exclude RoHun 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 YTD
Fund 01-General Fund
EXPENSE
Unit 05-Police Department
Division 52-Police Administration
8268 Accreditation 4,100.00 00 4,100.00 00 00 4,595.00 495.00) 112 4,595.00
Division 52-Police Administration Totals $1,640,163.00 0.00 $1,640,163.00 $101,071.89 0.00 $859,386.16 $780,776.84 52% $868,511.55
Division 53-Police Records
1005 Salaries-Full Time 222,150.00 00 222,150.00 17,017.94 00 127,399.07 94,750.93 57 156,943.52
1015 Salaries-Part Time 36,311.00 00 36,311.00 2,607.94 00 20,060.77 16,250.23 55 12,285.47
1800 Salaries-Overtime 6,000.00 00 6,000.00 781.05 00 4,205.54 1,794.46 70 2,413.27
2000 FICA 16,397.00 00 16,397.00 1,258.96 00 9,359.73 7,037.27 57 10,503.34
2001 Medicare 3,835.00 00 3,835.00 294.43 00 2,188.97 1,646.03 57 2,456.42
2010 IMRF 31,735.00 00 31,735.00 1,950.92 00 14,556.37 17,178.63 46 18,545.45
2020 Employee Insurance 31,666.00 00 31,666.00 2,383.11 00 20,733.04 10,932.96 65 31,360.33
2025 Deferred Comp.Contribution 12,000.00 00 12,000.00 00 00 00 12,000.00 0 00
3000 Travel/Training 2,750.00 00 2,750.00 50.69 00 776.76 1,973.24 28 735.36
4000 Telephone/Internet 1,500.00 00 1,500.00 00 00 413.74 1,086.26 28 1,542.16
5005 Office Supplies/Postage 10,000.00 00 10,000.00 648.88 00 6,225.86 3,774.14 62 3,957.96
5015 Dues&Subscriptions 480.00 00 480.00 00 00 10.00 470.00 2 15.00
5095 Uniforms/Clothing 1,500.00 00 1,500.00 158.64 00 778.46 721.54 52 615.92
8035 Maintenance Contracts/Lease 4,460.00 00 4,460.00 60.82 00 4,128.93 331.07 93 1,080.00
Division 53-Police Records Totals $380,784.00 0.00 $380,784.00 $27,213.38 0.00 $210,837.24 $169,946.76 55% $242,454.20
Division 54-Seizure/Forfeiture
5012 Asset Seizure/Forfeiture Expense 225,000.00 00 225,000.00 00 00 5,725.28 219,274.72 3 58,751.42
5012.030 Asset Seizure/Forfeture-Federal(DOJ Equitable Share) 00 00 00 00 00 18,053.94 (18,053.94) +++ 00
Division 54-Seizure/Forfeiture Totals $225,000.00 0.00 $225,000.00 0.00 0.00 $23,779.22 $201,220.78 11% $58,751.42
Division 55-Police Special Activities
1005.061 Salaries-Special Activities 32,513.00 00 32,513.00 6,663.19 00 48,675.60 (16,162.60) 150 57,687.46
2000 FICA 2,016.00 00 2,016.00 392.01 00 2,946.76 930.76) 146 3,489.21
2001 Medicare 471.00 00 471.00 95.08 00 692.59 221.59) 147 816.05
5045 Mobile Field Force 1,000.00 00 1,000.00 00 00 00 1,000.00 0 00
Division 55-Police Special Activities Totals $36,000.00 0.00 $36,000.00 7,150.28 0.00 $52,314.95 ($16,314.95) 145% $61,992.72
Division 56-Community Services
1005 Salaries-Full Time 952,453.00 00 952,453.00 69,287.79 00 558,721.20 393,731.80 59 524,249.98
1800 Salaries-Overtime 40,000.00 00 40,000.00 7,955.67 00 36,092.14 3,907.86 90 34,688.54
2000 FICA 61,532.00 00 61,532.00 4,667.18 00 35,848.93 25,683.07 58 33,840.76
2001 Medicare 14,391.00 00 14,391.00 1,091.52 00 8,383.98 6,007.02 58 7,914.36
2010 IMRF 7,191.00 00 7,191.00 367.18 00 2,758.05 4,432.95 38 3,456.83
2020 Employee Insurance 172,396.00 00 172,396.00 12,665.79 00 106,468.15 65,927.85 62 95,729.42
2025 Deferred Comp.Contribution 22,000.00 00 22,000.00 00 00 00 22,000.00 0 00
3000 Travel/Training 20,000.00 00 20,000.00 385.00 00 8,314.88 11,685.12 42 8,889.95
Run by Traci Pleckham on 11/21/2019 01:23:09 PM Page 3 of 6
16
1,i..._._..._..II 6 w ,,Budget Performance Report
I••
le A I iI, n„ -
i...F.ay„:3 Year to Date11Ii il l nysi 111
VILLAGE OF
19
PLAINFIELD Exclude Ro lup Account
Adopted Budget Amended Current Month YTD YTD Budget-YTD %Used/
Account Account Description Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD
Fund 01-General Fund
EXPENSE
Unit 05-Police Department
Division 56-Community Services
4000 Telephone/Internet 2,000.00 00 2,000.00 00 00 508.40 1,491.60 25 1,542.17
4005 Cellular Phones/Pagers 3,000.00 00 3,000.00 222.01 00 1,327.48 1,672.52 44 1,362.54
5005 Office Supplies/Postage 3,100.00 00 3,100.00 57.63 00 651.81 2,448.19 21 553.11
5010 Replacement Supplies 6,200.00 00 6,200.00 129.88 00 2,874.38 3,325.62 46 875.36
5015 Dues&Subscriptions 2,200.00 00 2,200.00 40.00 00 149.00 2,051.00 7 194.00
5020 Gas/Oil/Mileage/Carwash 16,000.00 00 16,000.00 27.03 00 5,750.20 10,249.80 36 5,896.90
5095 Uniforms/Clothing 8,600.00 00 8,600.00 700.64 00 3,800.42 4,799.58 44 2,786.60
5115.002 Community Programs 5,500.00 00 5,500.00 136.42 00 3,359.37 2,140.63 61 1,968.62
5115.003 Community Prog.-Alcohol/Tobacco 2,500.00 00 2,500.00 00 00 24.13 2,475.87 1 37.98
8003 Radio Maintenance 26,800.00 00 26,800.00 00 00 9,476.74 17,323.26 35 9,765.83
8035 Maintenance Contracts/Lease 2,180.00 00 2,180.00 103.38 00 781.49 1,398.51 36 00
8060 Vehicle Maintenance 25,000.00 00 25,000.00 525.98 00 4,694.87 20,305.13 19 5,606.08
8245 D.A.R.E.Program 5,000.00 00 5,000.00 00 00 759.78 4,240.22 15 506.23
8246 Shop with a Cop 10,000.00 00 10,000.00 00 00 755.00 9,245.00 8 300.00
8266 Chaplaincy Program 3,000.00 00 3,000.00 00 00 829.91 2,170.09 28 1,056.74
Division 56-Community Services Totals $1,411,043.00 0.00 $1,411,043.00 $98,363.10 0.00 $792,330.31 $618,712.69 56% $741,222.00
Division 57-Court Services
1005 Salaries-Full Time 134,680.00 00 134,680.00 10,538.50 00 78,362.71 56,317.29 58 74,386.54
1015 Salaries-Part Time 25,476.00 00 25,476.00 1,880.18 00 15,629.27 9,846.73 61 14,490.28
1800 Salaries-Overtime 1,000.00 00 1,000.00 00 00 48.74 951.26 5 00
2000 FICA 9,992.00 00 9,992.00 742.95 00 5,656.64 4,335.36 57 5,301.94
2001 Medicare 2,337.00 00 2,337.00 173.76 00 1,322.91 1,014.09 57 1,239.97
2010 IMRF 18,944.00 00 18,944.00 1,211.82 00 9,149.44 9,794.56 48 9,918.72
2020 Employee Insurance 42,245.00 00 42,245.00 3,106.51 00 26,835.16 15,409.84 64 23,504.53
2025 Deferred Comp.Contribution 5,500.00 00 5,500.00 00 00 00 5,500.00 0 00
3000 Travel/Training 3,000.00 00 3,000.00 00 00 637.82 2,362.18 21 2,032.00
4000 Telephone/Internet 1,500.00 00 1,500.00 00 00 384.90 1,115.10 26 1,199.45
5005 Office Supplies/Postage 10,000.00 00 10,000.00 776.92 00 3,333.81 6,666.19 33 4,130.65
5015 Dues&Subscriptions 9,800.00 00 9,800.00 902.92 00 4,696.60 5,103.40 48 4,522.35
5095 Uniforms/Clothing 600.00 00 600.00 00 00 122.57 477.43 20 634.30
8035 Maintenance Contracts/Lease 1,920.00 00 1,920.00 00 00 1,158.11 761.89 60 960.00
8065 Legal Fees 20,000.00 00 20,000.00 00 00 11,500.00 8,500.00 58 11,858.75
Division 57-Court Services Totals $286,994.00 0.00 $286,994.00 $19,333.56 0.00 $158,838.68 $128,155.32 55% $154,179.48
Division 91-Capital
9115 Office Furniture&Equipment 8,000.00 00 8,000.00 00 00 00 8,000.00 0 00
9120 Machinery and Equipment 162,200.00 00 162,200.00 33,629.22 00 36,150.74 126,049.26 22 231,484.12
Mayonions 91-Capital Totals $170,200.00 0.00 $170,200.00 $33,629.22 0.00 $36,150.74 $134,049.26 21% $231,484.12
Run by Traci Pleckham on 11/21/2019 01:23:09 PM Page 4 of 6
17
IN li III
II irt! HI-1111"114-1 a I iidget Performance Report
1---I--II- r1---I- I I -1PUI.nysls 1-III
VILLAGE OF
Fiscal Year to Date 11/21/19
PLAINFIELD Exclude Roilup Account
Adopted Budget Amended Current Month YTD YTD Budget-YTD %Used/
Account Au '.;nt Description Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD
Fund 01-Gener&Fund
EXPENSE
Unit 05-Police Department
Division 93-Contingencies
9300 Contingencies 12,000.00 00 12,000.00 794.00 00 16,436.06 4,436.06) 137 4,176.44
Division 93-Contingencies Totals $12,000.00 0.00 $12,000.00 794.00 0.00 $16,436.06 ($4,436.06) 137%4,176.44
Unit 05-Police Department Totals $13,051,045.00 0.00 $13,051,045.00 $789,148.03 0.00 $7,678,988.13 $5,372,056.87 59% $7,771,809.30
Unit 07-PEMA
Division 07-PEMA Program
3000 Travel/Training 4,000.00 00 4,000.00 00 00 390.43 3,609.57 10 233.20
4000 Telephone/Internet 6,000.00 00 6,000.00 151.85 00 3,299.75 2,700.25 55 4,125.00
4005 Cellular Phones/Pagers 5,200.00 00 5,200.00 44.96 00 409.12 4,790.88 8 1,088.93
5005 Office Supplies/Postage 1,000.00 00 1,000.00 00 00 00 1,000.00 0 89.46
5010 Replacement Supplies 10,000.00 00 10,000.00 455.72 00 1,949.67 8,050.33 19 914.18
5015 Dues&Subscriptions 4,000.00 00 4,000.00 265.61 00 3,351.60 648.40 84 2,450.27
5020 Gas/Oil/Mileage/Carwash 8,000.00 00 8,000.00 64.21 00 2,638.75 5,361.25 33 2,205.25
5040 Supplies/Hardware 2,000.00 00 2,000.00 00 00 95.93 1,904.07 5 00
5040.001 Supplies/Hardware-ESDA 2,000.00 00 2,000.00 00 00 364.27 1,635.73 18 17.78
5095 Uniforms/Clothing 6,000.00 00 6,000.00 00 00 1,103.40 4,896.60 18 268.60
5110 Emergency Operation Center 1,000.00 00 1,000.00 00 00 00 1,000.00 0 00
5115 Police Public Relations 2,000.00 00 2,000.00 00 00 1,654.08 345.92 83 00
5120 Disaster Plan/Exercises/NIMS 3,000.00 00 3,000.00 00 00 00 3,000.00 0 00
8003 Radio Maintenance 15,000.00 00 15,000.00 00 00 00 15,000.00 0 1,520.00
8020 Building Maintenance 5,000.00 00 5,000.00 00 00 118.15 4,881.85 2 135.24)
8035 Maintenance Contracts/Lease 1,200.00 00 1,200.00 00 00 1,381.57 181.57) 115 656.16
8060 Vehicle Maintenance 20,000.00 00 20,000.00 1,038.47 00 1,865.46 18,134.54 9 15,586.04
8069 Bike Unit 500.00 00 500.00 00 00 00 500.00 0 00
8125 Siren Maintenance 13,000.00 00 13,000.00 443.70 00 1,866.45 11,133.55 14 4,049.11
8135 Contractual Services 5,250.00 00 5,250.00 00 00 00 5,250.00 0 74.00
8280 Cadet Program 5,500.00 00 5,500.00 1,751.10 00 1,751.10 3,748.90 32 1,565.62
8305 PEMA Search and Rescue 4,000.00 00 4,000.00 00 00 3,423.90 576.10 86 00
9115 Office Furniture&Equipment 2,000.00 00 2,000.00 00 00 00 2,000.00 0 00
9120 Machinery and Equipment 5,000.00 00 5,000.00 00 00 00 5,000.00 0 00
9300 Contingencies 3,000.00 00 3,000.00 00 00 220.00 2,780.00 7 00
Division 07-PEMA Program Totals $133,650.00 0.00 $133,650.00 4,215.62 0.00 $25,883.63 $107,766.37 19% $34,708.36
Unit 07-PEMA Totals $133,650.00 0.00 $133,650.00 4,215.62 0.00 $25,883.63 $107,766.37 19% $34,708.36
Unit 50-Police Commission
Division 02-Administration Program
1015 Salaries-Part Time 5,500.00 00 5,500.00 159.23 00 1,402.09 4,097.91 25 678.38
2000 FICA 341.00 00 341.00 9.52 00 84.94 256.06 25 42.05
2001 Medicare 80.00 00 80.00 2.23 00 19.88 60.12 25 9.84
Run by Traci Pleckham on 11/21/2019 01:23:09 PM Page 5 of 6
18
n i fit---- iiii.w udget Performance Report
1-•1 I I 111.I.u.lsl.i4i
VILLAGE OF
Fiscal Year to Date 11/21/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 YTD
Fund 01-General Fund
EXPENSE
Unit 50-Police Commission
Division 02-Administration Program
3000 Travel/Training 1,000.00 00 1,000.00 00 00 121.40 878.60 12 87.50
5005 Office Supplies/Postage 2,000.00 00 2,000.00 00 00 138.89 1,861.11 7 53.75
5015 Dues&Subscriptions 600.00 00 600.00 375.00 00 375.00 225.00 62 375.00
8065 Legal Fees 1,000.00 00 1,000.00 00 00 00 1,000.00 0 00
8115 Police Testing/Hiring 10,000.00 00 10,000.00 8,080.00 00 25,906.85 (15,906.85) 259 27.50
Division 02-Administration Program Totals $20,521.00 0.00 $20,521.00 8,625.98 0.00 $28,049.05 ($7,528.05) 137%1,274.02
Unit 50-Police Commission Totals $20,521.00 0.00 $20,521.00 8,625.98 0.00 $28,049.05 ($7,528.05) 137%1,274.02
EXPENSE TOTALS $13,205,216.00 0.00 $13,205,216.00 $801,989.63 0.00 $7,732,920.81 $5,472,295.19 59% $7,807,791.68
Fund 01-General Fund Totals
REVENUE TOTALS 00 00 00 00 00 00 00 +++ 00
EXPENSE TOTALS 13,205,216.00 00 13,205,216.00 801,989.63 00 7,732,920.81 5,472,295.19 59% 7,807,791.68
Fund 01-General Fund Totals ($13,205,216.00) 0.00 ($13,205,216.00) ($801,989.63) 0.00 ($7,732,920.81) ($5,472,295.19) 7,807,791.68)
Grand Totals
REVENUE TOTALS 00 00 00 00 00 00 00 +++ 00
EXPENSE TOTALS 13,205,216.00 00 13,205,216.00 801,989.63 00 7,732,920.81 5,472,295.19 59% 7,807,791.68
Grand Totals ($13,205,216.00) 0.00 ($13,205,216.00) ($801,989.63) 0.00 ($7,732,920.81) ($5,472,295.19) 7,807,791.68)
Run by Traci Pleckham on 11/21/2019 01:23:09 PM Page 6 of 6
19
1 i 1I I ff en ! . ," q E i
MEMORANDUM I-.1"I ten iu' i.. i i
VILLAGE OF
PLAINFIELD
To: Mayor Collins and the Board of Trustees
From: Traci Pleckham—Management Services Director
CC: Brian Murphy—Village Administrator
Date: November 18, 2019
Subject: Year 2019 Tax Levy
Attached please find the proposed 2019 tax levy calculations. Rather than calculating the tax
levy based on maintaining the same levy dollar amount, staff has calculated the 2019 levy by
maintaining the 2018 levy rate of.4669. Consistent with Village Board direction, this levy rate
has remained unchanged for the past six years.
Tax levy revenue and rate projections are largely a product of the Village's overall Equalized
Assessed Valuation (EAV). The EAV used in the property tax calculation averages the property
owner's assessed valuation over a three-year period. Based on preliminary information
received from Will and Kendall Counties,the overall EAV is estimated to increase this year by
approximately 5%. The Village's official EAV will not be available until the spring of 2020.
It is important to point out that the Village approves the annual tax levy based on dollars
requested (not rate).The County Clerk then calculates the tax rate needed to produce the
amount of dollars requested by each taxing district. Because of this, staff is using in its
calculations a higher overall Equalized Assessed Value (EAV). This higher EAV estimate is to
ensure that the Village captures the entire amount of the Village's EAV, while still maintaining
the 2018 levy rate of.4669. 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.
As a reminder,the information provided is specific only to the Village of Plainfield's portion of
the property tax bills. The Village of Plainfield'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 of
Plainfield.
The Village Board must approve the annual property tax levy ordinance and file in both Will and
Kendall Counties prior to the last Tuesday in December. The proposed 2019 tax levy timeline is
as follows:
December 2, 2019 Village Board Meeting: Motion to acknowledge the preliminary
estimate of the 2019 tax levy in the amount of$6,880,000
December 5, 2019: Newspaper publication of the Notice of the Public Hearing for the
Tax levy
December 16, 2019 Village Board Meeting: Public Hearing on the proposed 2019 Tax
Levy
December 16, 2019 Village Board Meeting: consideration of the 2019 Tax Levy
Ordinance for the Village of Plainfield 20
VILLAGE OF PLAINFIELD
2019 TAX LEVY WORKSHEET
2018 Equalized Assessed Valuation 1,390,180,402
Estimate of 2019 Equalized Assessed Valuation: 1,473,591,226
Recommended Levy
2018
2018 Extended Recommended Rate
Levy Levy Rate Levy Request Produced Percentage
Corporate 3,001,704 0.2159 3,270,000 0.2219 47.5291%
Police Protection 1,095,434 0.0788 1,300,000 0.0882 18.8953%
Immunity 400,353 0.0288 150,000 0.0102 2.1802%
IMRF 540,734 0.0389 550,000 0.0373 7.9942%
Audit 36,071 0.0026 30,000 0.0020 0.4360%
Police Pension 1,301,135 0.0936 1,580,000 0.1072 22.9651%
Operating Levy 6,375,431 0.4586 6,880,000 0.4669 100.00%
GO Bonds (1999A) 115,321 0.0083 0 0.0000
Total Levy 6,490,752 0.4669 6,880,000 0.4669
Increase over 2018
Operating Levy 504,569
Increase over 2018
Total Levy 389,248
21
Village of Plainfield
Village Property Tax Rates and Extensions
2009 through 2018 Tax Levy Years
Property Tax Rates
2009 2010 2011 2012 2013 2014 2015 2016 2017 2018
General 0.2053 0.2012 0.2032 0.2158 0.2210 0.2099 0.1974 0.1921 0.2002 0.2159
Debt Service 0.0024 0.0086 0.0090 0.0098 0.0098 0.0098 0.0097 0.0088 0.0089 0.0083
Police Pension 0.0503 0.0682 0.0721 0.0767 0.0783 0.0811 0.0911 0.1068 0.1057 0.0936
IMRF 0.0413 0.0436 0.0461 0.0490 0.0500 0.0492 0.0476 0.0448 0.0407 0.0389
Police Protection 0.0575 0.0607 0.0641 0.0682 0.0696 0.0683 0.0662 0.0624 0.0711 0.0788
Audit 0.0008 0.0029 0.0031 0.0030 0.0034 0.0033 0.0035 0.0033 0.0033 0.0026
Liability Insurance 0.0503 0.0227 0.0321 0.0342 0.0348 0.0453 0.0514 0.0487 0.0370 0.0288
Total 0.4079 0.4079 0.4297 0.4567 0.4669 0.4669 0.4669 0.4669 0.4669 0.4669
Extensions 5,715,080 5,367,321 5,349,693 5,381,842 5,368,140 5,478,241 5,658,448 5,988,257 6,215,904 6,490,752
Property Tax Extensions
7,000,000 e
6,000,000
4,000,000
3,000,000
2,000,000
1,000,000
0
I
2p09 2010 20112p12 2p13 2014 2015 2p16 201 20151
Property Tax Rates
0.4800
0.4400
0.4200 d _d
0.4000
0.3800
0.3600
20p9 2010 2011 2p12 2013 2p14 2015 2p1-6 2013 2p1g
22
Village of Plainfield - Will County
Comparison of Tax Rates per $100 of Assessed Valuation
2009 2012 2013 2014 2015 2016 2017 2018 Levy
Levy Levy Levy Levy Levy Levy Levy
Rates Rates Rates Rates Rates Rates Rates Tax Rate Percentage
Village of Plainfield 0.4079 0.4567 0.4669 0.4669 0.4669 0.4669 0.4669 0.4669 5.39%
Will County & Forest Preserve 0.6543 0.7244 0.8186 0.8410 0.8295 0.8091 0.7881 0.7431 8.57%
School District 202 4.5876 5.8323 6.2265 6.2622 6.2410 5.8941 5.7067 5.5732 64.29%
Joliet Junior College 525 0.2144 0.2768 0.2955 0.3085 0.3065 0.3099 0.2994 0.2924 3.37%
Plainfield Township Park District 0.1740 0.2433 0.2535 0.2742 0.2692 0.2560 0.2541 0.2591 2.99%
Plainfield Public Library District 0.1421 0.1894 0.2013 0.2057 0.2021 0.1939 0.1921 0.1893 2.19%
Plainfield Fire Protection District 0.8419 0.9216 0.9970 1.0122 1.0036 0.9674 0.9650 0.9537 11.00%
Township and Other 0.1483 0.1960 0.2106 0.2125 0.2091 0.1991 0.1952 0.1908 2.20%
Total Tax Rate 7.1705 8.8405 9.4699 9.5832 9.5279 9.0964 8.8675 8.6685 100.01%
Village of Plainfield
Township and Other 5.39%
Plainfield Public 2.20%
Library District Plainfield Fire
Plainfield Township
2.19% Protection District Will County&Forest
Park District 11.00% Preserve
2.99%
I
8.57%
Joliet Junior College
525
3.37%
School District 202
64.29%
23
VILLAGE OF PLAINFIELD
POLICE PENSION FUND
ACTUARIAL VALUATION
AS OF MAY 1,2019
CONTRIBUTIONS APPLICABLE TO THE
PLAN/FISCAL YEAR ENDING APRIL 30,2021
GASB 67/68 DISCLOSURE INFORMATION
AS OF APRIL 30,2019
FOSTER & FOSTER
24
r FOSTER & FOSTER
August 28,2019
Ms.Colleen Thornton
Village of Plainfield
24401 W.Lockport Street
Plainfield,IL 60544
Re: Actuarial Valuation Report(including GASB Statements No. 67 and No.68)—Village of
Plainfield Police Pension Fund
Dear Ms.Thornton:
We are pleased to present to the Village this report of the annual actuarial valuation of the Village of
Plainfield Police Pension Fund. Included are the related results for GASB Statements No.67 and No.
68. The funding valuation was performed to determine whether the assets and contributions are
sufficient to provide the prescribed benefits and to develop the appropriate funding requirements for the
applicable plan year. The calculation of the liability for GASB results was performed for the purpose of
satisfying the requirements of GASB Statements No.67 and No.68. Use of the results for other
purposes may not be applicable and could produce significantly different results.
The valuation has been conducted in accordance with generally accepted actuarial principles and
practices,including the applicable Actuarial Standards of Practice as issued by the Actuarial Standards
Board,and reflects laws and regulations issued to date pursuant to the provisions of Article 3,Illinois
Pension Code,as well as applicable federal laws and regulations. Due to an actuarial transition,we
were not able to perform a full review of the actuarial assumptions prior to the completion of this report
and have relied on some of the assumptions used by the prior actuary. A full review of every
assumption will be completed prior to next year's valuation.Future actuarial measurements may differ
significantly from the current measurements presented in this report for a variety of reasons including:
changes in applicable laws,changes in plan provisions, changes in assumptions,or plan experience
differing from expectations. Due to the limited scope of the valuation,we did not perform an analysis
of the potential range of such future measurements.
In conducting the valuation,we have relied on personnel,plan design, and asset information supplied
by the Village,financial reports prepared by the custodian bank and the actuarial assumptions and
methods described in the Actuarial Assumptions section of this report. While we cannot verify the
accuracy of all this information,the supplied information was reviewed for consistency and
reasonableness. As a result of this review,we have no reason to doubt the substantial accuracy of the
information and believe that it has produced appropriate results. This information,along with any
adjustments or modifications,is summarized in various sections of this report.
The total pension liability,net pension liability,and certain sensitivity information shown in the GASB
results are based on an actuarial valuation performed as of the valuation date.
The undersigned are familiar with the immediate and long-term aspects of pension valuations and meet
the Qualification Standards of the American Academy of Actuaries necessary to render the actuarial
opinions contained herein. All of the sections of this report are considered an integral part of the
actuarial opinions.
184 Shuman Blvd,Suite 305 Naperville,IL 60563•(630)620-0200•Fax(239)481-0634•www.foster-foster.com 25
To our knowledge,no associate of Foster&Foster, Inc. working on valuations of the program has any
direct financial interest or indirect material interest in the Village of Plainfield,nor does anyone at
Foster&Foster,Inc.act as a member of the Board of Trustees of the Village of Plainfield Police
Pension Fund. Thus,there is no relationship existing that might affect our capacity to prepare and
certify this actuarial report.
If there are any questions,concerns,or comments about any of the items contained in this report,please
contact us at 630-620-0200.
Respectfully submitted,
Foster&Foster,Inc.
By:
Jaso L.Franken, FSA,EA,MAAA
Wyk.
By:
Heidi E.Andorfer,FSA,EA, AAA
By:10
Paul M.Baugher,FSA,EMAAA
JLF/lke
Enclosures
26
TABLE OF CONTENTS
Section Title Page
Introduction
a. Summary of Report 5
b. Changes Since Prior Valuation 6
c. Comparative Summary of Principal
Valuation Results 7
II Valuation Information
a. Development of Amortization Payment 12
b. Statutory Minimum Required Contribution 13
c. Projection of Benefit Payments 14
d. Actuarial Assumptions and Methods 15
e. Glossary 17
f. Discussion of Risk 18
III Trust Fund 21
IV Member Statistics
a. Statistical Data 25
b. Age and Service Distribution 26
c. Valuation Participant Reconciliation 27
V Summary of Current Plan 28
VI Governmental Accounting Standards Board Statements
No. 67 and No.68 Disclosure Information 31
27
SUMMARY OF REPORT
The regular annual actuarial valuation of the Village of Plainfield Police Pension Fund,performed as of
May 1,2019,has been completed and the results are presented in this Report. The contribution amounts
set forth herein are applicable to the plan/fiscal year ended April 30,2021.
The contribution requirements, compared with those set forth in the May 1,2018 actuarial report,as
prepared by Timothy W. Sharpe,are as follows:
Valuation Date 5/1/2019 5/1/2018
Applicable to Fiscal Year Ending 4/30/2021 4/30/2020
Total Recommended Contribution 2,157,848 1,859,183
of Projected Annual Payroll 37.0% 33.7%
Member Contributions(Est.) 577,511 584,509
of Projected Annual Payroll 9.9% 10.6%
Village Recommended Contribution 1,580,337 1,274,674
of Projected Annual Payroll 27.1% 23.1%
As you can see,the Total Recommended Contribution shows an increase when compared to the results
determined in the May 1,2018 actuarial valuation report. The increase is primarily attributable to
assumption changes reflected in this valuation,which account for approximately$153,000 of the
increase. Other factors impacting the increase include method changes and actuarial transition losses.
Village of Plainfield Police Pension Fund FOSTER&FOSTER 15
28
CHANGES SINCE PRIOR VALUATION
Plan Changes Since Prior Valuation
No plan changes have occurred since the prior valuation.
Actuarial Assumption/Method Changes Since Prior Valuation
The valuation reflects the following assumption change:
The mortality rates were updated to reflect the PubS-2010 tables.
Since the prior valuation the following methods have been updated:
The administrative expenses have been included to determine the annual contribution to the fund.
Interest has been excluded in the determination of the expected member contributions to
determine the net contribution requirement for the Village.
Village of Plainfield Police Pension Fund FOSTER&FOSTER 16
29
COMPARATIVE SUMMARY OF PRINCIPAL VALUATION RESULTS
New Asmp/Mthd Old Asmp/Mthd
5/1/2019 5/1/2019 5/1/2018 '
A. Participant Data
Number Included
Actives 57 57 55
Service Retirees 6 6 6
Beneficiaries 1 1 1
Disability Retirees 2 2 2
Terminated Vested 2 2 1
Total 68 68 65
Total Annual Payroll 5,827,563 5,827,563 5,525,220
Payroll Under Assumed Ret.Age 5,827,563 5,827,563 5,525,220
Annual Rate of Payments to:
Service Retirees 411,462 411,462 394,292
Beneficiaries 13,578 13,578 13,578
Disability Retirees 96,830 96,830 96,830
Terminated Vested 22,163 22,163 22,163
B.Assets
Actuarial Value 35,321,046 35,321,046 32,192,657
Market Value 34,665,171 34,665,171 31,578,352
C.Liabilities
Present Value of Benefits
Actives
Retirement Benefits 41,495,924 39,605,131 N/A
Disability Benefits 3,196,465 3,145,808 N/A
Death Benefits 367,243 682,498 N/A
Vested Benefits 3,017,702 2,918,739 N/A
Service Retirees 6,679,988 6,402,619 N/A
Beneficiaries 91,568 85,224 N/A
Disability Retirees 1,706,351 1,687,450 N/A
Terminated Vested 221.007 213,438 N/A
Total 56,776,248 54,740,907 N/A
Values reported for 5/1/2018 are consistent with the report issued by Timothy W. Sharpe.
Village of Plainfield Police Pension Fund FOSTER&FOSTER 1 7
30
New Asmp/Mthd Old Asmp/Mthd
C.Liabilities-(Continued) 5/1/2019 5/1/2019 5/1/2018 '
Present Value of Future Salaries 55,597,425 55,405,651 N/A
Present Value of Future
Member Contributions 5,509,705 5,490,700 N/A
Normal Cost(Retirement) 1,059,306 1,009,731 N/A
Normal Cost(Disability) 183,822 181,956 N/A
Normal Cost(Death) 16,930 27,840 N/A
Normal Cost(Vesting) 147,420 142,914 N/A
Total Normal Cost 1,407,478 1,362,441 1,101,856
Present Value of Future
Normal Costs 12,309,971 11,872,118 N/A
Accrued Liability(Retirement) 31,905,395 30,492,188 N/A
Accrued Liability(Disability) 1,561,154 1,531,440 N/A
Accrued Liability(Death) 230,966 455,155 N/A
Accrued Liability(Vesting) 2,069,848 2,001,275 N/A
Accrued Liability(Inactives)8,698,914 8,388,731 N/A
Total Actuarial Accrued Liability 44,466,277 42,868,789 42,886,699
Unfunded Actuarial Accrued
Liability(UAAL) 9,145,231 7,547.743 10,694.042
Funded Ratio(AVA/AL) 79.4% 82.4% 75.1%
Values reported for 5/1/2018 are consistent with the report issued by Timothy W. Sharpe.
Village of Plainfield Police Pension Fund FOSTER&FOSTER 18
31
New Asmp/Mthd Old Asmp/Mthd
5/1/2019 5/1/2019 5/1/2018 '
D.Actuarial Present Value of Accrued Benefits
Vested Accrued Benefits
Inactives 8,698,914 8,388,731 N/A
Actives 9,920,425 9,410,207 N/A
Member Contributions 6,788,405 6,788,405 N/A
Total 25,407,744 24,587,343 N/A
Non-vested Accrued Benefits 2,561,766 2,458,649 N/A
Total Present Value Accrued Benefits 27,969,510 27,045,992 N/A
Funded Ratio(MVA/PVAB) 123.9% 128.2% N/A
Increase(Decrease)in Present Value of
Accrued Benefits Attributable to:
Plan Amendments 0 N/A
Assumption Changes 923,518 N/A
New Accrued Benefits 0 N/A
Benefits Paid 0 N/A
Interest 0 N/A
Other 0 N/A
Total 923,518 N/A
Values reported for 5/1/2018 are consistent with the report issued by Timothy W. Sharpe.
Village of Plainfield Police Pension Fund FOSTER&FOSTER I 9
32
New Asmp/Mthd Old Asmp/Mthd
Valuation Date 5/1/2019 5/1/2019 5/1/2018
Applicable to Fiscal Year Ending 4/30/2021 4/30/2021 4/30/2020 2
E.Pension Cost
Normal Cost ' 1,502,483 1,454,406 1,176,232
of Total Annual Payroll ' 25.8 25.0 21.3
Administrative Expenses ' 53,074 0 0
of Total Annual Payroll ' 0.9 0.0 0.0
Payment Required to Amortize
Unfunded Actuarial Accrued
Liability over 22 years
as of 5/1/2019) ' 602,291 497,082 682,951
of Total Annual Payroll ' 10.3 8.5 12.4
Total Recommended Contribution 2,157,848 1,951,488 1,859,183
of Total Annual Payroll ' 37.0 33.5 33.7
Expected Member Contributions ' 577,511 616,494 584.509
of Total Annual Payroll ' 9.9 10.6 10.6
Expected Village Contribution 1,580,337 1,334,994 1,274,674
of Total Annual Payroll ' 27.1 22.9 23.1
F.Past Contributions
Plan Years Ending: 4/30/2019
Total Recommended Contribution 1,801,978
Village Requirement 1,246,616
Actual Contributions Made:
Members(excluding buyback)555,362
Village 1,402,674
Total 1,958,036
G.Net Actuarial(Gain)/Loss 3,009,856)
Contributions developed as of 5/1/2019 displayed above have been adjusted to
account for assumed interest.
2 Values reported for 5/1/2018 are consistent with the report issued by Timothy W.
Sharpe,which did not consider the administrative expenses as part of the minimum
calculation. The report also reflected interest crediting on Member Contributions to
the end of the year,while the estimated Member Contributions as of 5/1/2019 do not
reflect interest.
Village of Plainfield Police Pension Fund FOSTER&FOSTER 1 10
33
H. Schedule Illustrating the Amortization of the Total Unfunded Actuarial Accrued Liability as of:
Projected Unfunded
Year Accrued Liability
2019 9,145,231
2020 9,160,243
2021 9,155,189
2026 8,749,576
2031 7,447,491
2036 4,763,829
2041 0
I. (i)3 Year Comparison of Actual and Assumed Salary Increases
Actual Assumed
Year Ended 4/30/2019 3.14% 4.38%
ii)3 Year Comparison of Investment Return on Actuarial Value
Actual Assumed
Year Ended 4/30/2019 5.26% 6.75%
Village of Plainfield Police Pension Fund FOSTER&FOSTER 111
34
DEVELOPMENT OF MAY 1,2019 AMORTIZATION PAYMENT
1) Unfunded Actuarial Accrued Liability as of May 1,2018 10,694,042
2) Sponsor Normal Cost developed as of May 1,2018 554,307
3) Expected administrative expenses for the year ended April 30,2019 0
4) Expected interest on(1),(2)and(3) 759,264
5) Sponsor contributions to the System during the year ended April 30,2019 1,402,674
6) Expected interest on(5) 47,340
7) Expected Unfunded Actuarial Accrued Liability' as of
April 30,2019, (1)+(2)+(3)+(4)-(5)-(6) 10,557,599
8) Change to UAAL due to Assumption Change 1,597,488
9) Change to UAAL due to Actuarial(Gain)/Loss 3,009,856)
10) Unfunded Accrued Liability as of May 1,2019 9,145,231
11) UAAL Subject to Amortization(100%AAL less Actuarial Assets)9,145,231
Date Years 5/1/2019 Amortization
Established Remaining Amount Amount
5/1/2019 22 9,145,231 564,207
Village of Plainfield Police Pension Fund FOSTER&FOSTER 1 12
35
STATUTORY MINIMUM REQUIRED CONTRIBUTION
Contribution requirements shown on this page are calculated according to statutory
minimum funding requirements of the Illinois Pension Code. We do not believe this
method is sufficient to fund future benefits;as such, we recommend funding according
to the contributions developed in Section E of this report.
Valuation Date 5/1/2019 5/1/2019 5/1/2018
Applicable to Fiscal Year Ending 4/30/2021 4/30/2021 4/30/2020 2
Actuarial Accrued Liability(PUC) 40,440,396 39,031,705 38,597,353
Actuarial Value of Assets 35,321,046 35,321,046 32,192,657
Unfunded Actuarial Accrued Liability(UAAL) 5,119,350 3,710,659 6,404,696
UAAL Subject to Amortization 1,075,310 0 2,544,961
Normal Cost ' 1,825,941 1,763,934 1,670,023
of Total Annual Payroll 1 31.3 30.3 30.3
Administrative Expenses ' 53,074 0 0
of Total Annual Payroll ' 0.9 0.0 0.0
Payment Required to Amortize
Unfunded Actuarial Accrued
Liability over 21 years
as of 5/1/2019) ' 73,177 0 162,528
of Total Annual Payroll ' 1.3 0.0 2.9
Total Required Contribution 1,952,192 1,763,934 1,832,551
of Total Annual Payroll 1 33.5 30.3 33.2
Expected Member Contributions ' 577,511 616,494 584,509
of Total Annual Payroll 1 9.9 10.6 10.6
Expected Village Contribution 1,374,681 1,147,440 1,248,042
of Total Annual Payroll ' 23.6 19.7 22.6
Assumptions and Methods:
Actuarial Cost Method Projected Unit Credit
Amortization Method 90%Funding by 2040
All other assumptions and methods are as described in the Actuarial Assumptions and Methods section.
Contributions developed as of 5/1/2019 displayed above have been adjusted to
account for assumed interest.
2 Values reported for 5/1/2018 are consistent with the report issued by Timothy W.
Sharpe,which did not consider the administrative expenses as part of the minimum
calculation. The report also reflected interest crediting on Member Contributions to
the end of the year,while the estimated Member Contributions as of 5/1/2019 do not
reflect interest.
Village of Plainfield Police Pension Fund FOSTER&FOSTER 1 13
36
PROJECTION OF BENEFIT PAYMENTS
Payments for Payments for Total
Year Current Actives Current Inactives Payments
2019 126,768 519,586 646,354
2020 253,238 528,476 781,714
2021 373,579 537,388 910,967
2022 530,036 552,839 1,082,875
2023 712,994 562,843 1,275,837
2024 913,129 572,554 1,485,683
2025 1,128,699 581,875 1,710,574
2026 1,365,158 590,705 1,955,863
2027 1,635,281 598,938 2,234,219
2028 1,961,196 627,975 2,589,171
2029 2,250,420 653,625 2,904,045
2030 2,598,237 661,047 3,259,284
2031 2,950,002 667,348 3,617,350
2032 3,326,514 672,398 3,998,912
2033 3,749,973 676,087 4,426,060
2034 4,134,898 678,328 4,813,226
2035 4,517,012 679,067 5,196,079
2036 4,877,116 678,323 5,555,439
2037 5,225,216 676,162 5,901,378
2038 5,567,158 695,230 6,262,388
2039 5,853,091 692,007 6,545,098
2040 6,134,358 687,669 6,822,027
2041 6,398,963 682,264 7,081,227
2042 6,682,118 675,809 7,357,927
2043 6,943,732 668,289 7,612,021
2044 7,162,578 659,630 7,822,208
2045 7,392,492 649,715 8,042,207
2046 7,593,644 638,418 8,232,062
2047 7,788,246 625,617 8,413,863
2048 7,994,719 611,211 8,605,930
2049 8,167,011 595,102 8,762,113
2050 8,323,863 577,196 8,901,059
2051 8,445,383 557,401 9,002,784
2052 8,545,061 535,626 9,080,687
2053 8,622,258 511,818 9,134,076
2054 8,676,391 486,024 9,162,415
2055 8,705,963 458,401 9,164,364
2056 8,708,537 429,212 9,137,749
2057 8,681,884 398,830 9,080,714
2058 8,624,128 367,696 8,991,824
Village of Plainfield Police Pension Fund FOSTER&FOSTER 114
37
ACTUARIAL ASSUMPTIONS AND METHODS
Interest Rate 6.75%per year compounded annually,net of investment related
expenses. This is supported by the target asset allocation of the
trust and the expected long-term return by asset class.
Mortality Rate Active Lives:
PubS-2010 Employee mortality,projected 5 years past the
valuation date with Scale MP-2018. 10%of active deaths are
assumed to be in the line of duty.
Inactive Lives:
PubS-2010 Healthy Retiree mortality,projected 5 years past the
valuation date with Scale MP-2018.
Beneficiaries:
PubS-2010 Survivor mortality,projected 5 years past the
valuation date with Scale MP-2018.
Disabled Lives:
PubS-2010 Disabled mortality,projected 5 years past the
valuation date with Scale MP-2018.
The mortality assumptions sufficiently accommodate anticipated
future mortality improvements.
Retirement Age See table later in this section. This is based on a 2017
experience study performed for the State of Illinois Department
of Insurance.
Disability Rate See table later in this section.60%of the disabilities are assumed
to be in the line of duty. This is based on a 2017 experience
study performed for the State of Illinois Department of
Insurance.
Termination Rate See table later in this section. This is based on a 2017
experience study performed for the State of Illinois Department
of Insurance.
Inflation 2.50%.
Cost-of-Living Adjustment Tier 1: 3.00%per year after age 55.Those that retire prior to age
55 receive an increase of 1/12 of 3.00%for each full month since
benefit commencement upon reaching age 55.
Tier 2: 1.25%per year after the later of attainment of age 60 or
first anniversary of retirement.
Village of Plainfield Police Pension Fund FOSTER&FOSTER 1 15
38
Salary Increases See table below. This is based on a 2017 experience study
performed for the State of Illinois Department of Insurance.
Salary Scale
Service Rate
0 11.00%
1 10.75%
2 8.75%
3 8.50%
4 7.00%
5 6.25%
6 5.25%
7 4.25%
8- 16 4.00%
17-32 3.75%
32+ 3.50%
Marital Status 80%of Members are assumed to be married.
Spouse's Age Males are assumed to be three years older than females.
Funding Method Entry Age Normal Cost Method.
Actuarial Asset Method Investment gains and losses are smoothed over a 5-year period.
Funding Policy Amortization Method The UAAL is amortized according to a Level Percentage of
Payroll method over a period ending in 2041. The initial
amortization amount is 100%of the Accrued Liability less the
Actuarial Value of Assets.
Payroll Growth 3.50%per year.
Administrative Expenses Expenses paid out of the fund other than investment-related
expenses are assumed to be equal to those paid in the previous
year.
Decrement Tables
Terminating %Becoming Disabled Retiring Retiring
During the Year During the Year During the Year(Tier 1) During the Year(Tier 2)
Age Rate Age Rate Age Rate Age Rate
20 14.00% 20 0.000% 50-51 15% 50-54 5%
25 10.40% 25 0.030% 52-54 20% 55 40%
30 5.60% 30 0.140% 55-64 25% 56-64 25%
35 3.10% 35 0.260% 65-69 40% 65-69 40%
40 1.90% 40 0.420% 70+100% 70+100%
45 1.50% 45 0.590%
50 1.50% 50 0.710%
56+ 0.00% 55 0.900%
60 1.150%
Village of Plainfield Police Pension Fund FOSTER&FOSTER 116
39
GLOSSARY
Total Annual Payroll is the projected annual rate of pay for the fiscal year following the valuation date of
all covered members.
Present Value of Benefits is the single sum value on the valuation date of all future benefits to be paid to
current Members,Retirees,Beneficiaries,Disability Retirees and Vested Terminations.
Normal(Current Year's)Cost is the current year's cost for benefits yet to be funded.
Unfunded Accrued Liability is a liability which arises when a pension plan is initially established or
improved and such establishment or improvement is applicable to all years of past service.
Total Recommended Contribution is equal to the Normal Cost plus an amount sufficient to amortize the
Unfunded Accrued Liability over a period ending in 2041. The recommended amount is adjusted for
interest according to the timing of contributions during the year.
Entry Age Normal Cost Method-Under this method,the normal cost is the sum of the individual normal
costs for all active participants. For an active participant,the normal cost is the participant's normal cost
accrual rate,multiplied by the participant's current compensation.
a)The normal cost accrual rate equals:
i)the present value of future benefits for the participant,determined as of the
participant's entry age,divided by
ii)the present value of the compensation expected to be paid to the participant for each
year of the participant's anticipated future service, determined as of the participant's
entry age.
b)In calculating the present value of future compensation,the salary scale is applied both
retrospectively and prospectively to estimate compensation in years prior to and subsequent to the
valuation year based on the compensation used for the valuation.
c)The accrued liability is the sum of the individual accrued liabilities for all participants and
beneficiaries. A participant's accrued liability equals the present value,at the participant's
attained age,of future benefits less the present value at the participant's attained age of the
individual normal costs payable in the future. A beneficiary's accrued liability equals the present
value,at the beneficiary's attained age,of future benefits. The unfunded accrued liability equals
the total accrued liability less the actuarial value of assets.
d)Under this method,the entry age used for each active participant is the participant's age at the
time he or she would have commenced participation if the plan had always been in existence
under current terms,or the age as of which he or she first earns service credits for purposes of
benefit accrual under the current terms of the plan.
Village of Plainfield Police Pension Fund FOSTER&FOSTER 17
40
DISCUSSION OF RISK
ASOP No. 51,Assessment and Disclosure of Risk Associated with Measuring Pension Obligations and
Determining Pension Plan Contributions, states that the actuary should identify risks that,in the actuary's
professional judgment,may reasonably be anticipated to significantly affect the plan's future financial
condition.
Throughout this report,actuarial results are determined under various assumption scenarios. These re-
sults are based on the premise that all future plan experience will align with the plan's actuarial assump-
tions;however,there is no guarantee that actual plan experience will align with the plan's assump-
tions. Whenever possible,the recommended assumptions in this report reflect conservatism to allow for
some margin of unfavorable future plan experience. However,it is still possible that actual plan experi-
ence will differ from anticipated experience in an unfavorable manner that will negatively impact the
plan's funded position.
Below are examples of ways in which plan experience can deviate from assumptions and the potential im-
pact of that deviation. Typically,this results in an actuarial gain or loss representing the current-year fi-
nancial impact on the plan's unfunded liability of the experience differing from assumptions;this gain or
loss is amortized over a period of time determined by the plan's amortization method. When assumptions
are selected that adequately reflect plan experience,gains and losses typically offset one another in the
long term,resulting in a relatively low impact on the plan's contribution requirements associated with
plan experience. When assumptions are too optimistic,losses can accumulate over time and the plan's
amortization payment could potentially grow to an unmanageable level.
Investment Return: When the rate of return on the Actuarial Value of Assets falls short of the as-
sumption,this produces a loss representing assumed investment earnings that were not real-
ized. Further, it is unlikely that the plan will experience a scenario that matches the assumed re-
turn in each year as capital markets can be volatile from year to year. Therefore,contribution
amounts can vary in the future.
Salary Increases:When a plan participant experiences a salary increase that was greater than as-
sumed,this produces a loss representing the cost of an increase in anticipated plan benefits for the
participant as compared to the previous year. The total gain or loss associated with salary in-
creases for the plan is the sum of salary gains and losses for all active participants.
Payroll Growth: The plan's payroll growth assumption, if one is used,causes a predictable annual
increase in the plan's amortization payment in order to produce an amortization payment that re-
mains constant as a percentage of payroll if all assumptions are realized. If payroll does not in-
crease according to the plan's payroll growth assumption,the plan's amortization payment can
increase significantly as a percentage of payroll even if all assumptions other than the payroll
growth assumption are realized.
Demographic Assumptions:Actuarial results take into account various potential events that could
happen to a plan participant,such as retirement,termination,disability,and death. Each of these
potential events is assigned a liability based on the likelihood of the event and the financial conse-
quence of the event for the plan. Accordingly,actuarial liabilities reflect a blend of financial con-
sequences associated with various possible outcomes(such as retirement at one of various possi-
ble ages). Once the outcome is known(e.g.the participant retires)the liability is adjusted to re-
flect the known outcome. This adjustment produces a gain or loss depending on whether the out-
come was more or less favorable than other outcomes that could have occurred.
Village of Plainfield Police Pension Fund FOSTER&FOSTER 1 18
41
Contribution risk: Risks associated with the items outlined above will inherently create varying
liabilities and assets resulting in volatility in contributions. Actuarial losses on assets and liabili-
ties will lead to higher contribution amounts,while actuarial gains on assets and liabilities will
lead to lower contribution amounts.
Impact of Plan Maturity on Risk
For newer pension plans,most of the participants and associated liabilities are related to active members
who have not yet reached retirement age. As pension plans continue in operation and active members
reach retirement ages, liabilities begin to shift from being primarily related to active members to being
shared amongst active and retired members. Plan maturity is a measure of the extent to which this shift
has occurred. It is important to understand that plan maturity can have an impact on risk tolerance and the
overall risk characteristics of the plan. For example,plans with a large amount of retired liability do not
have as long of a time horizon to recover from losses(such as losses on investments due to lower than
expected investment returns)as plans where the majority of the liability is attributable to active members.
For this reason,less tolerance for investment risk may be warranted for highly mature plans with a
substantial inactive liability. Similarly,mature plans paying substantial retirement benefits resulting in a
small positive or net negative cash flow can be more sensitive to near term investment volatility,
particularly if the size of the fund is shrinking,which can result in less assets being available for
investment in the market.
To assist with determining the maturity of the plan,we have provided some relevant metrics in the table
following titled"Plan Maturity Measures and Other Risk Metrics". Highlights of this information are
discussed below:
The Support Ratio,determined as the ratio of active to inactive members has decreased from
550%to 518%over the last two years,meaning the plan's maturity has remained consistent.
The Accrued Liability Ratio,determined as the ratio of the Inactive Accrued Liability,which is
generally the accrued liability associated with those receiving payments,to the Total Accrued
Liability,is 19.6%. With a plan of this maturity,losses due to lower than expected investment
returns or demographic factors can be made up over a longer time horizon than would be needed
for a more mature plan.
The Funded Ratio,determined as the ratio of the Actuarial Value of Assets to the Total Accrued
Liability has increased from 75.1%on May 1, 2018 to 79.4%on May 1,2019 due mainly to the
transition of actuarial services.
It is important to note that the actuary has identified the risks above as the most significant risks based on
the characteristics of the plan and the nature of the project,however,it is not an exhaustive list of
potential risks that could be considered. Additional advanced modelling,as well as the identification of
additional risks,can be provided at the request of the reader.
Village of Plainfield Police Pension Fund FOSTER&FOSTER 1 19
42
PLAN MATURITY MEASURES AND OTHER RISK METRICS
5/1/2018 5/1/2019
Support Ratio
Total Actives 55 57
Total Inactives 10 11
Actives/Inactives 550.0% 518.2%
Asset Volatility Ratio
Market Value of Assets(MVA) 31,578,352 34,665,171
Total Annual Payroll 5,525,220 5,827,563
MVA/Total Annual Payroll 571.5% 594.8%
Accrued Liability(AL)Ratio
Inactive Accrued Liability 8,354,902 8,698,914
Total Accrued Liability 42,886,699 44,466,277
Inactive AL/Total AL 19.5% 19.6%
Funded Ratio
Actuarial Value of Assets(AVA) 32,192,657 35,321,046
Total Accrued Liability 42,886,699 44,466,277
AVA/Total Accrued Liability 75.1% 79.4%
Village of Plainfield Police Pension Fund FOSTER&FOSTER 120
43
STATEMENT OF FIDUCIARY NET POSITION
April 30,2019.
ASSETS MARKET VALUE
Cash and Cash Equivalents:
Cash and short-term investments 230,525
Total Cash and Equivalents 230,525
Receivables:
Accrued Past Due Interest 108,865
Total Receivable 108,865
Investments:
Municipal Obligations 1,754,998
U.S. Gov't and Agency Obligations 12,694,380
Mutual Funds 19,877,856
Total Investments 34,327,234
Total Assets 34,666,624
LIABILITIES
Liabilities:
Payable:
Accounts Payable 1,453
Total Liabilities 1,453
Net Assets:
Active and Retired Members'Equity 34,665,171
NET POSITION RESTRICTED FOR PENSIONS 34,665,171
TOTAL LIABILITIES AND NET ASSETS 34,666,624
Village of Plainfield Police Pension Fund FOSTER&FOSTER 21
44
STATEMENT OF CHANGES IN FIDUCIARY NET POSITION
FOR THE YEAR ENDED April 30,2019
Market Value Basis
ADDITIONS
Contributions:
Member 555,362
Village 1,402,674
Total Contributions 1,958,036
Investment Income:
Net Increase in Fair Value of Investments 575,422
Interest&Dividends 1,219,956
Less Investment Expense ' 106,456)
Net Investment Income 1,688,922
Total Additions 3,646,958
DEDUCTIONS
Distributions to Members:
Benefit Payments 510,423
Total Distributions 510,423
Administrative Expenses 49,718
Total Deductions 560,141
Net Increase in Net Position 3,086,817
NET POSITION RESTRICTED FOR PENSIONS
Beginning of the Year 31,578,352
Adjustment to beginning of year 2
End of the Year 34,665,171
Investment Related expenses include investment advisory,
custodial and performance monitoring fees.
Village of Plainfield Police Pension Fund FOSTER&FOSTER 22
45
ACTUARIAL ASSET VALUATION
April 30, 2019
Actuarial Assets for funding purposes are developed by recognizing the total actuarial investment gain or
loss for each Plan Year over a five year period. In the first year,20%of the gain or loss is recognized. In
the second year 40%,in the third year 60%, in the fourth year 80%,and in the fifth year 100%of the gain or
loss is recognized. The actuarial investment gain or loss is defined as the actual return on investments
minus the actuarial assumed investment return. Actuarial Assets shall not be less than 80%nor greater than
120%of the Market Value of Assets.
Gains/(Losses)Not Yet Recognized
Plan Year Amounts Not Yet Recognized by Valuation Year
Ending Gain/(Loss) 2019 2020 2021 2022 2023
4/30/2016 1,896,017) (379,203) 0 0 0 0
4/30/2017 380,294 152,118 76,059 0 0 0
4/30/2018 61,588) 36,953) (24,635) (12,318) 0 0
4/30/2019 489,796) (391,837) (293,878) (195,918) (97,959) 0
Total 655,875) (242,454) (208,236) (97,959) 0
Development of Investment Gain/Loss
Market Value of Assets,4/30/2018 31,578,354
Contributions Less Benefit Payments&Administrative Expenses 1,397,895
Expected Investment Earnings' 2,178,718
Actual Net Investment Earnings 1,688,922
2019 Actuarial Investment Gain/(Loss) 489,796)
Expected Investment Earnings=6.75%x(31,578,354+0.5 x 1,397,895)
Development of Actuarial Value of Assets
Market Value of Assets,4/30/2019 34,665,171
Gains)/Losses Not Yet Recognized 655,875
Actuarial Value of Assets,4/30/2019 35,321,046
A)4/30/2018 Actuarial Assets: 32,192,657
I) Net Investment Income:
1. Interest and Dividends 1,219,956
2. Realized Gains(Losses) 0
3. Change in Actuarial Value 616,994
4. Investment Expenses 106,456)
Total 1,730,494
B)4/30/2019 Actuarial Assets: 35,321,046
Actuarial Asset Rate of Return=(2 x I)/(A+B-I): 5.26%
Market Value of Assets Rate of Return: 5.23%
4/30/2019 Limited Actuarial Assets: 35,321,046
Actuarial Gain/(Loss)due to Investment Return(Actuarial Asset Basis) 489,689)
Village of Plainfield Police Pension Fund FOSTER&FOSTER 123
46
CHANGES IN NET ASSETS AVAILABLE FOR BENEFITS
April 30,2019
Actuarial Asset Basis
INCOME
Contributions:
Member 555,362
Village 1,402,674
Total Contributions 1,958,036
Earnings from Investments
Interest&Dividends 1,219,956
Change in Actuarial Value 616,994
Total Earnings and Investment Gains 1,836,950
EXPENSES
Administrative Expenses:
Investment Related' 106,456
Other 49,718
Total Administrative Expenses 156,174
Distributions to Members:
Benefit Payments 510,423
Total Distributions 510,423
Change in Net Assets for the Year 3,128,389
Net Assets Beginning of the Year 32,192,657
Net Assets End of the Year2 35,321,046
Investment Related expenses include investment advisory,
custodial and performance monitoring fees.
2 Net Assets may be limited for actuarial consideration.
Village of Plainfield Police Pension Fund FOSTER&FOSTER 124
47
STATISTICAL DATA '
5/1/2016 5/1/2017 5/1/2018 5/1/2019
Actives-Tier 1
Number N/A N/A N/A 49
Average Current Age N/A N/A N/A 43.6
Average Age at Employment N/A N/A N/A 26.3
Average Past Service N/A N/A N/A 17.3
Average Annual Salary N/A N/A N/A 106,550
Actives-Tier 2
Number N/A N/A N/A 8
Average Current Age N/A N/A N/A 27.4
Average Age at Employment N/A N/A N/A 24.9
Average Past Service N/A N/A N/A 2.5
Average Annual Salary N/A N/A N/A 75,828
Service Retirees
Number N/A N/A 6 6
Average Current Age N/A N/A N/A 62.8
Average Annual Benefit N/A N/A 65,715 68,577
Beneficiaries
Number N/A N/A 1 1
Average Current Age N/A N/A N/A 82.3
Average Annual Benefit N/A N/A 13,578 13,578
Disability Retirees
Number N/A N/A 2 2
Average Current Age N/A N/A N/A 45.5
Average Annual Benefit N/A N/A 48,415 48,415
Terminated Vested
Number N/A N/A 1 2
Average Current Age N/A N/A N/A 50.2
Average Annual Benefit 2 N/A N/A 22,163 22,163
1 Foster&Foster does not have enough historical data to include complete data prior to 5/1/2019.
We will add historical data going forward.
2 Average Annual Benefit for Terminated Vested members reflects the benefit for members entitled to a
future annual benefit from the plan.
Village of Plainfield Police Pension Fund FOSTER&FOSTER 125
48
AGE AND SERVICE DISTRIBUTION
PAST SERVICE
AGE 0 1 2 3 4 5-9 10-14 15-19 20-24 25-29 30+ Total
15 - 19 0 0 0 0 0 0 0 0 0 0 0 0
20-24 0 1 0 0 0 0 0 0 0 0 0 1
25 -29 2 1 0 2 0 0 0 0 0 0 0 5
30-34 0 0 0 0 0 3 1 0 0 0 0 4
35 -39 0 0 0 0 0 0 9 4 0 0 0 13
40-44 0 0 0 0 0 0 4 8 1 0 0 13
45 -49 0 0 0 0 0 0 3 5 5 0 0 13
50-54 0 0 0 0 0 0 0 1 1 4 0 6
55 - 59 0 0 0 0 0 0 0 0 1 0 0 1
60-64 0 0 0 0 0 0 0 0 0 1 0 1
65+ 0 0 0 0 0 0 0 0 0 0 0 0
Total 2 2 0 2 0 3 17 18 8 5 0 57
Village of Plainfield Police Pension Fund FOSTER&FOSTER 126
49
VALUATION PARTICIPANT RECONCILIATION
1.Active lives
a. Number in prior valuation 5/1/2018 55
b. Terminations
i. Vested(partial or full)with deferred benefits 0
ii.Non-vested or full lump sum distribution received 0
iii. Transferred service to other fund 0
c. Deaths
i. Beneficiary receiving benefits 0
ii.No future benefits payable 0
d. Disabled 0
e. Retired 0
f. Continuing participants 55
g. New entrants 2
h. Total active life participants in valuation 57
2.Non-Active lives(including beneficiaries receiving benefits)
Service
Retirees,
Vested Receiving Receiving
Receiving Death Disability Vested
Benefits Benefits Benefits Deferred Total
a.Number prior valuation 6 1 2 1 10
Retired 0 0 0 0 0
Vested Deferred 0 0 0 0 0
Death,With Survivor 0 0 0 0 0
Death,No Survivor 0 0 0 0 0
Disabled 0 0 0 0 0
Refund of Contributions 0 0 0 0 0
Rehires 0 0 0 0 0
Expired Annuities 0 0 0 0 0
Data Corrections 0 0 0 1 1
Hired/Termed in Same Year 0 0 0 0 0
b.Number current valuation 6 1 2 2 11
Village of Plainfield Police Pension Fund FOSTER&FOSTER 127
50
SUMMARY OF CURRENT PLAN
Article 3 Pension Fund The Plan is established and administered as prescribed by"Article
3. Police Pension Fund—Municipalities 500,000 and Under"of
the Illinois Pension Code.
Plan Administration The Plan is a single employer defined benefit pension plan
administered by a Board of Trustees comprised of:
a) Two members appointed by the Municipality,
b) Two active Members of the Police Department
elected by the Membership,and
c) One retired Member of the Police Department
elected by the Membership.
Credited Service Complete years of service as a sworn police officer employed by
the Municipality.
Normal Retirement
Date Tier 1:Age 50 and 20 years of Credited Service.
Tier 2: Age 55 with 10 years of Credited Service.
Benefit Tier 1: 50%of annual salary attached to rank on last day of
service plus 2.50%of annual salary for each year of service over
20 years,up to a maximum of 75%of salary. The minimum
monthly benefit is$1,000 per month.
Tier 2: 2.50%per year of service times the average salary for the
eight consecutive years prior to retirement times the number of
years of service,up to a maximum of 75%of average salary.The
minimum monthly benefit is$1,000 per month.
Form of Benefit Tier 1: For married retirees,an annuity payable for the life of the
Member;upon the death of the member, 100%of the Member's
benefit payable to the spouse until death.For unmarried retirees,
the normal form is a Single Life Annuity.
Tier 2: Same as above,but with 66 2/3%of benefit continued to
spouse.
Early Retirement
Date Tier 1: Age 60 and 8 years of Credited Service.
Tier 2: Age 50 with 10 years of Credited Service.
Benefit Tier 1:Normal Retirement benefit with no minimum.
Tier 2:Normal Retirement benefit,reduced 6%each year before
age 55,with no minimum benefit.
Form of Benefit Same as Normal Retirement.
Village of Plainfield Police Pension Fund FOSTER&FOSTER 128
51
Disability Benefit
Eligibility Total and permanent as determined by the Board of Trustees.
Benefit Amount A maximum of:
a.) 65%of salary attached to the rank held by Member on
last day of service, and;
b.) The monthly retirement pension that the Member is
entitled to receive if he or she retired immediately.
For non-service connected disabilities, a benefit of 50%of salary
attached to rank held by Member on last day of service.
Cost-of-Living Adjustment Tier 1:
Retirees: An annual increase equal to 3.00%per year after age
55. Those that retire prior to age 55 receive an increase of 1/12 of
3.00%for each full month since benefit commencement upon
reaching age 55.
Disabled Retirees:An annual increase equal to 3.00%per year of
the original benefit amount beginning at age 60. Those that
become disabled prior to age 60 receive an increase of 3.00%of
the original benefit amount for each year since benefit
commencement upon reaching age 60.
Tier 2: An annual increase each January 1 equal to 3.00%per
year or one-half of the annual unadjusted percentage increase in
the consumer price index-u for the 12 months ending with the
September preceding each November 1,whichever is less, of the
original pension after the attainment of age 60 or first anniversary
of pension start date whichever is later.
Pre-Retirement Death Benefit
Service Incurred 100%of salary attached to rank held by Member on last day of
service.
Non-Service Incurred A maximum of:
a.) 50%of salary attached to the rank held by Member on
last day of service, and;
b.) The monthly retirement pension earned by the deceased
Member at the time of death,regardless of whether death
occurs before or after age 50.
For non-service deaths with less than 10 years of service, a refund
of member contributions is provided.
Village of Plainfield Police Pension Fund FOSTER&FOSTER 129
52
Vesting(Termination)
Vesting Service Requirement Tier 1: 8 years.
Tier 2: 10 years.
Non-Vested Benefit Refund of Member Contributions.
Vested Benefit Either the termination benefit,payable upon reaching age 60(55
for Tier 2),provided contributions are not withdrawn, or a refund
of member contributions. The termination benefit is 2.50%of
annual salary held in the year prior to termination(8-year final
average salary for Tier 2)times creditable service.
Contributions
Employee 9.91%of Salary.
Municipality Remaining amount necessary for payment of Normal(current
year's)Cost and amortization of the accrued past service liability.
Village of Plainfield Police Pension Fund FOSTER&FOSTER 30
53
GASB 67/68
SUMMARY OF PARTICIPANT DATA
Plan Membership:
5/1/2019 5/1/2018
Inactive Plan Members or Beneficiaries
Currently Receiving Benefits 9 9
Inactive Plan Members Entitled to But
Not Yet Receiving Benefits 2 1
Active Plan Members 57 55
Total 68 65
Covered Payroll 5,827,563 5,525,220
Village of Plainfield Police Pension Fund FOSTER&FOSTER 131
54
GASB 67/68
SCHEDULE OF CHANGES IN NET PENSION LIABILITY
GASB 68 Reporting Period Ending 04/30/2019 04/30/2018
Measurement Date 04/30/2019 04/30/2018
Total Pension Liability
Service Cost 1,313,637 1,273,722
Interest 3,076,159 2,879,343
Changes of Benefit Terms
Differences Between Expected and Actual Experience 4,863,845) 549,216)
Changes of Assumptions 1,585,849 1,138,995
Contributions -Buy Back
Benefit Payments,Including Refunds of Employee Contributions 510,423) 494,765)
Net Change in Total Pension Liability 601,377 4,248,079
Total Pension Liability-Beginning 42,886,699 38,638,620
Total Pension Liability-Ending(a)43,488,076 $ 42,886,699
Plan Fiduciary Net Position
Contributions -Employer 1,402,674 1,364,479
Contributions -Employee 555,362 524,835
Net Investment Income 1,688,922 2,098,694
Benefit Payments,Including Refunds of Employee Contributions 510,423) 494,765)
Administrative Expense 49,718) 42,745)
Net Change in Plan Fiduciary Net Position 3,086,817 3,450,498
Plan Fiduciary Net Position-Beginning 31,578,354 28,127,856
Plan Fiduciary Net Position-Ending(b) 34,665,171 $ 31,578,354
Net Pension Liability-Ending(a)- (b) 8,822,905 $ 11,308,345
Plan Fiduciary Net Position as a Percentage of the Total Pension
Liability 79.71% 73.63%
Covered Payroll 5,827,563 $ 5,525,220
Net Pension Liability as a Percentage of Covered Payroll 151.40% 204.67%
Changes reflected in April 30, 2019 results:
The results reflect the assumption changes noted in the assumptions section of the report.
Village of Plainfield Police Pension Fund FOSTER&FOSTER 132
55
GASB 68
STATEMENT OF CHANGES IN NET PENSION LIABILITY
Increase (Decrease)
Total Pension Plan Fiduciary Net Pension
Liability Net Position Liability
a) b) a)-(b)
Balances at April 30,2018 42,886,699 $ 31,578,354 $ 11,308,345
Changes for a Year:
Service Cost 1,313,637 1,313,637
Interest 3,076,159 3,076,159
Differences Between Expected and Actual Experience 4,863,845)4,863,845)
Changes of Assumptions 1,585,849 1,585,849
Changes of Benefit Terms
Contributions -Employer 1,402,674 (1,402,674)
Contributions -Employee 555,362 (555,362)
Net Investment Income 1,688,922 (1,688,922)
Benefit Payments,Including Refunds of Employee
Contributions 510,423) (510,423)
Administrative Expense 49,718) 49,718
Net Changes 601,377 3,086,817 (2,485,440)
Balances at April 30,2019 43,488,076 $ 34,665,171 $ 8,822,905
Sensitivity of Net Pension Liability to changes in the Discount Rate:
Current Discount
1% Decrease Rate 1% Increase
5.75% 6.75% 7.75%
Sponsor's Net Pension Liability 17,175,861 $ 8,822,905 $ 2,171,642
Pension Plan Fiduciary Net Position
Detailed information about the Pension Plan's Fiduciary Net Position is available in a separately issued Plan
financial report.
Village of Plainfield Police Pension Fund FOSTER&FOSTER 133
56
GASB 68
PENSION EXPENSE AND DEFERRED OUTFLOWS OF RESOURCES AND DEFERRED INFLOWS OF
RESOURCES RELATED TO PENSIONS
YEAR-END APRIL 30,2019
For the year ended April 30,2019,the Sponsor will recognize a pension expense of$1,921,167. On April 30,
2019,the Sponsor reported deferred outflows of resources and deferred inflows of resources related to pensions
from the following sources:
Deferred Deferred
Outflows of Inflows of
Resources Resources
Differences between actual and expected experience 0 5,042,310
Changes of assumptions 2,693,950 615,816
Net difference between projected and actual earnings on
pension plan investments 655,876 0
Total 3,349,826 5,658,126
Amounts reported as deferred outflows of resources and deferred inflows of resources related to pensions will be
recognized in pension expense as follows:
Year-ended April 30:
2020 215,730
2021 267,309)
2022 423,072)
2023 427,072)
2024 219,970)
Thereafter 1,186,607)
Village of Plainfield Police Pension Fund FOSTER&FOSTER 134
57
GASB 68
COMPONENTS OF PENSION EXPENSE
YEAR-END APRIL 30,2019
Net Pension Deferred Deferred Pension
Liability Inflows Outflows Expense
Beginning Balance 11,308,345 $ 1,904,728 $ 2,600,361
Total Pension Liability Factors:
Service Cost 1,313,637 1,313,637
Interest 3,076,159 3,076,159
Changes in Benefit Terms
Contributions-Buy Back
Differences Between Expected and Actual
Experience With Regard to Economic or 4,863,845) 4,863,845
Current Year Amortization 777,896) 777,896)
Changes in Assumptions About Future Economic or
Demographic Factors or Other Inputs 1,585,849 1,585,849
Current Year Amortization 104,375) (684,582)580,207
Benefit Payments,Including Refunds of Employee
Contributions 510,423)
Net Change 601,377 3,981.574 901,267 4,192,107
Plan Fiduciary Net Position:
Contributions-Employer 1,402,674
Contributions-Employee 555,362 555,362)
Projected Net Investment Income 2,178,718 2,178,718)
Difference Between Projected and Actual Earnings
on Pension Plan Investments 489,796) 489,796
Current Year Amortization 76,059) (489,481)413,422
Benefit Payments,Including Refunds of Employee
Contributions 510,423)
Administrative Expenses 49,718) 49,718
Net Change 3,086,817 76,059) 315 (2,270,940)
Ending Balance 8,822,905 $ 5,810,243 $ 3,501,943 $ 1,921.167
Village of Plainfield Police Pension Fund FOSTER&FOSTER 135
58
GASB
68
AMORTIZATION
SCHEDULE—
EXPERIENCE
Increase(
Decrease)
in
Pension
Expense
Arising
from
the
Recognition
of
the
Effects
of
Differences
between
Expected
and
Actual
Experience
Differences Between
Expected
Year
Base
and
Actual
Recognition
Established
Experience
Period(
Years)
2019
2020
2021
2022
2023
2024
2025
2026
2027
2019 $
4,
863,
845)
9
540,
429) $ (
540,
427) $ (
540,
427) $ (
540,
427) $ (
540,
427) $ (
540,
427) $ (
540,
427) $ (
540,
427) $ (
540,
427)
Prior
Years $
1,
236,
969)
N/
A $ (
237,
467) $ (
237,
467) $ (
237,
467) $ (
138,
170) $ (
105,
790) $ - $ - $ - $ -
Net
Increase(
Decrease)
in
Pension
Expense
777,
8%) (
777,
894) (
777,
894) (
678,
597) (
646,
217) (
540.
427) (
540.
427) $ (
540,
427) $ (
540,
427)
Village
of
Plainfield
Police
Pension
Fund
FOSTER&
FOSTER
136
59
GASB
68
AMORTIZATION
SCHEDULE—
CHANGES
OF
ASSUMPTIONS
Increase(
Decrease)
in
Pension
Expense
Arising
from
the
Recognition
of
the
Effects
of
Changes
of
Assumptions
Year
Base
Effects
of
Changes
Recognition
Established
in
Assumptions
Period(
Years)
2019
2020
2021
2022
2023
2024
2025
2026
2027
2019 $
1,
585,
849
9
176,
209 $
176,
205 $
176,
205 $
176,
205 $
176,
205 $
176,
205 $
176,
205 $
176,
205 $
176,
205
Prior
Years $
1,
884,
653
N/
A $
403,
998 $
403,
996 $
300,
161 $ (
30,
955) $ (
55,
019) $
144,
252 $ (
93,
941) $ - $ -
Net
Increase(
Decrease)
in
Pension
Expense
580,
207 $
580,
201 $
476,
366 $
145,
250 $
121,
186 $
320,
457 $
82,
264 $
176,
205 $
176,
205
Village
of
Plainfield
Police
Pension
Fund
FOSTER&
FOSTER
1
37
60
GASB
68
AMORTIZATION
SCHEDULE—
INVESTMENTS
Increase (
Decrease)
in
Pension
Expense
Arising
from
the
Recognition
of
the
Differences
Between
Projected
and
Actual
Earnings
on
Pension
Plan
Investments
Differences
Year
Base
Between
Projected
Recognition
Established
and
Actual
Earnings
Period(
Years)
2019
2020
2021
2022
2023
2024
2019 $
489,
796
5
97,
960 $
97,
959 $
97,
959 $
97,
959 $
97,
959 $
2018 $
61,
588
5
12,
318 $
12,
318 $
12,
318 $
12,
316 $
2017 $
380,
294)
5
76,
059) $ (
76,
059) $ (
76,
058) $
2016 $
1,
896,
017
5
379,
203 $
379,
205 $
Net
Increase (
Decrease)
in
Pension
Expense
413,
422 $
413,
423 $
34,
219 $
110,
275 $
97,
959 $
Village
of
Plainfield
Police
Pension
Fund
FOSTER&
FOSTER
138
61
GASB 67/68
SCHEDULE OF CONTRIBUTIONS
Contributions Contributions
in Relation to as a
Actuarially the Actuarially Contribution Percentage of
Determined Determined Deficiency Covered Covered
Plan Year-End Contribution Contributions Excess) Payroll Payroll
04/30/2019 1,246,616 1,402,674 156,058) 5,827,563 24.07%
04/30/2018 1,295,962 1,364,479 68,517) 5,525,220 24.70%
The following assumptions were used to determine the Actuarially Determined Contribution as of
May 1,2017:
Calculation Timing The Actuarially Determined Contribution is calculated as of May 1 one
year prior to the year in which contributions are reported.
Interest Rate 7.50%
Mortality Rate RP 2014 Mortality Table(BCHA)projected to 2017
using improvement scale MP-2016.
Assumptions All other assumptions and methods used for determining the
Actuarially Determined Contribution can be found in the May 1, 2017
Actuarial Valuation Report for the Village of Plainfield Police Pension
Fund prepared by Timothy W. Sharpe, Actuary,Geneva(IL).
Village of Plainfield Police Pension Fund FOSTER&FOSTER 139
62
GASB 67
SCHEDULE OF INVESTMENT RETURNS
For the year ended April 30,2019,the annual money-weighted return on Pension Plan investments,net of pension
plan investment expense,was 5.18 percent.The money-weighted rate of return expresses investment
performance,net of investment expense,adjusted for the changing amounts actually invested.
Annual Money-Weighted
Rate of Return Net of
Plan Year-End Investment Expense
04/30/2019 5.18%
04/30/2018 7.21%
Village of Plainfield Police Pension Fund FOSTER&FOSTER 140
63
GASB 67/68
ASSUMPTIONS—TOTAL PENSION LIABILITY
The valuation reflects the following assumption changes :
The mortality rates were updated to reflect the PubS-2010 tables.
The following assumptions were used to determine the Net Pension Liability:
Valuation Date May 1,2019
Measurement Date April 30,2019
GASB 68 Expense
Measurement Period May 1,2018-April 30,2019
Reporting Period May 1,2018-April 30, 2019
Discount Rate 6.75%
Mortality Rate Active Lives:
PubS-2010 Employee mortality,projected 5 years past the valuation date
with Scale MP-2018. 10%of active deaths are assumed to be in the line
of duty.
Inactive Lives:
PubS-2010 Healthy Retiree mortality,projected 5 years past the
valuation date with Scale MP-2018.
Beneficiaries:
PubS-2010 Survivor mortality,projected 5 years past the valuation date
with Scale MP-2018.
Disabled Lives:
PubS-2010 Disabled mortality,projected 5 years past the valuation date
with Scale MP-2018.
The mortality assumptions sufficiently accommodate anticipated future
mortality improvements.
Retirement Age See table later in this section. This is based on a 2017 experience study
performed for the State of Illinois Department of Insurance.
Disability Rate See table later in this section. 60%of the disabilities are assumed to be in
the line of duty. This is based on a 2017 experience study performed for
the State of Illinois Department of Insurance.
Termination Rate See table later in this section. This is based on a 2017 experience study
performed for the State of Illinois Department of Insurance.
Inflation 2.50%.
Village of Plainfield Police Pension Fund FOSTER&FOSTER 141
64
GASB 67/68
Cost-of-Living Adjustment Tier 1: 3.00%per year after age 55. Those that retire prior to age 55
receive an increase of 1/12 of 3.00%for each full month since benefit
commencement upon reaching age 55.
Tier 2: 1.25%per year after the later of attainment of age 60 or first
anniversary of retirement.
Salary Increases See table below. This is based on a 2017 experience study performed for
the State of Illinois Department of Insurance.
Salary Scale
Service Rate
0 11.00%
1 10.75%
2 8.75%
3 8.50%
4 7.00%
5 6.25%
6 5.25%
7 4.25%
8- 16 4.00%
17-32 3.75%
32+ 3.50%
Marital Status 80%of Members are assumed to be married.
Spouse's Age Males are assumed to be three years older than females.
Method Entry Age Normal Cost Method.
Decrement Tables
Terminating %Becoming Disabled Retiring Retiring
During the Year During the Year During the Year(Tier 1) During the Year(Tier 2)
Age Rate Age Rate Age Rate Age Rate
20 14.00% 20 0.000% 50-51 15% 50-54 5%
25 10.40% 25 0.030% 52-54 20% 55 40%
30 5.60% 30 0.140% 55-64 25% 56-64 25%
35 3.10% 35 0.260% 65-69 40% 65-69 40%
40 1.90% 40 0.420% 70+100% 70+100%
45 1.50% 45 0.590%
50 1.50% 50 0.710%
56+ 0.00% 55 0.900%
60 1.150%
Village of Plainfield Police Pension Fund FOSTER&FOSTER 142
65
GASB 67/68
NOTES TO THE FINANCIAL STATEMENTS
Support for Long-Term Expected Rate ofReturn
The Long-Term Expected Rate of Return on Pension Plan investments can be determined using a building-block
method in which best-estimate ranges of expected future real rates of return(expected returns,net of Pension Plan
investment expenses and inflation)are developed for each major asset class.
These ranges are combined to produce the Long-Term Expected Rate of Return by weighting the expected future
real rates of return by target asset allocation percentage and by adding expected inflation.
Best estimates of geometric real rates of return for each major asset class included in the Pension Plan's target
asset allocation adopted as of April 30,2019, as provided by Sawyer Falduto Asset Management,LLC,are
summarized in the following table:
Long Term
Expected Real
Asset Class Target Allocation Rate of Return
Large Cap Domestic Equity 35.10%6.60%
Small Cap Domestic Equity 11.65% 8.40%
International Equity 8.25% 6.40%
Fixed Income 45.00% 1.60%
Total 100.00%
Concentrations
The Plan did not hold investments in any one organization that represent 5 percent or more of the Pension Plan's
fiduciary net position.
Discount Rate
The Discount Rate used to measure the Total Pension Liability was 6.75 percent.
The projection of cash flows used to determine the Discount Rate assumed that Plan Member contributions will
be made at the current contribution rate and that Sponsor contributions will be made at rates equal to the
difference between actuarially determined contribution rates and the Member rate. Based on those assumptions,
the Pension Plan's Fiduciary Net Position was projected to be available to make all projected future benefit
payments of current plan members. Therefore,the Long-Term Expected Rate of Return on Pension Plan
investments(6.75 percent)was applied to all periods of projected benefit payments to determine the Total Pension
Liability.
For the purpose of this valuation,the expected rate of return on pension plan investments is 6.75 percent. The
municipal bond rate is 3.21 percent(based on the daily rate closest to,but not later than the measurement date of
the S&P Municipal Bond 20 Year High Grade Rate Index).The resulting single discount rate is 6.75 percent.
Village of Plainfield Police Pension Fund FOSTER&FOSTER 143
66
GASB 67/68
SUMMARY OF CURRENT PLAN
Article 3 Pension Fund The Plan is established and administered as prescribed by"Article 3.
Police Pension Fund—Municipalities 500,000 and Under"of the Illinois
Pension Code.
Plan Administration The Plan is a single employer defined benefit pension plan administered
by a Board of Trustees comprised of:
a) Two members appointed by the Municipality,
b) Two active Members of the Police Department elected by
the Membership,and
c) One retired Member of the Police Department elected by the
Membership.
Credited Service Complete years of service as a sworn police officer employed by the
Municipality.
Normal Retirement
Date Tier 1: Age 50 and 20 years of Credited Service.
Tier 2: Age 55 with 10 years of Credited Service.
Benefit Tier 1: 50%of annual salary attached to rank on last day of service plus
2.50%of annual salary for each year of service over 20 years,up to a
maximum of 75%of salary. The minimum monthly benefit is $1,000 per
month.
Tier 2:2.50%per year of service times the average salary for the eight
consecutive years prior to retirement times the number of years of service,
up to a maximum of 75%of average salary.The minimum monthly
benefit is$1,000 per month.
Form of Benefit Tier 1: For married retirees,an annuity payable for the life of the
Member;upon the death of the member, 100%of the Member's benefit
payable to the spouse until death.For unmarried retirees,the normal form
is a Single Life Annuity.
Tier 2: Same as above,but with 66 2/3%of benefit continued to spouse.
Early Retirement
Date Tier 1:Age 60 and 8 years of Credited Service.
Tier 2: Age 50 with 10 years of Credited Service.
Benefit Tier 1:Normal Retirement benefit with no minimum.
Tier 2:Normal Retirement benefit,reduced 6%each year before age 55,
with no minimum benefit.
Form of Benefit Same as Normal Retirement.
Village of Plainfield Police Pension Fund FOSTER&FOSTER 144
67
GASB 67/68
Disability Benefit
Eligibility Total and permanent as determined by the Board of Trustees.
Benefit Amount A maximum of:
a.) 65%of salary attached to the rank held by Member on last day of
service,and;
b.) The monthly retirement pension that the Member is entitled to
receive if he or she retired immediately.
For non-service connected disabilities,a benefit of 50%of salary attached
to rank held by Member on last day of service.
Cost-of-Living Adjustment Tier 1:
Retirees: An annual increase equal to 3.00%per year after age 55.Those
that retire prior to age 55 receive an increase of 1/12 of 3.00%for each
full month since benefit commencement upon reaching age 55.
Disabled Retirees: An annual increase equal to 3.00%per year of the
original benefit amount beginning at age 60. Those that become disabled
prior to age 60 receive an increase of 3.00%of the original benefit amount
for each year since benefit commencement upon reaching age 60.
Tier 2: An annual increase each January 1 equal to 3.00%per year or one-
half of the annual unadjusted percentage increase in the consumer price
index-u for the 12 months ending with the September preceding each
November 1,whichever is less,of the original pension after the attainment
of age 60 or first anniversary of pension start date whichever is later.
Pre-Retirement Death Benefit
Service Incurred 100%of salary attached to rank held by Member on last day of service.
Non-Service Incurred A maximum of:
a.) 50%of salary attached to the rank held by Member on last day of
service,and;
b.) The monthly retirement pension earned by the deceased Member
at the time of death,regardless of whether death occurs before or
after age 50.
For non-service deaths with less than 10 years of service,a refund of
member contributions is provided.
Village of Plainfield Police Pension Fund FOSTER&FOSTER 145
68
GASB 67/68
Vesting(Termination)
Vesting Service Requirement Tier 1: 8 years.
Tier 2: 10 years.
Non-Vested Benefit Refund of Member Contributions.
Vested Benefit Either the termination benefit,payable upon reaching age 60(55 for Tier
2),provided contributions are not withdrawn,or a refund of member
contributions.The termination benefit is 2.50%of annual salary held in
the year prior to termination(8-year final average salary for Tier 2)times
creditable service.
Contributions
Employee 9.91%of Salary.
Municipality Remaining amount necessary for payment of Normal(current year's)Cost
and amortization of the accrued past service liability.
Village of Plainfield Police Pension Fund FOSTER&FOSTER 146
69