agenda - wednesday, june 10, 2020 › lists › events › attachments › 5437 › ag … ·...

KANE COUNTY SURGES, Lenert, Allan, Barreiro, Davoust, Hoscheit, Lewis

HUMAN SERVICES COMMITTEE

WEDNESDAY, JUNE 10, 2020

County Board Room Agenda 9:00 AM

Kane County Government Center, 719 S. Batavia Ave., Bldg. A, Geneva, IL 60134

Kane County Page 1

1. Call to Order

2. Approval of Minutes: May 13, 2020

3. Public Comment

4. Monthly Financial Reports

A. May Monthly Reports (attached)

5. Veteran's Assistance Commission

A. Monthly Report (attached)

6. Department of Human Resource Management

A. Monthly Blue Cross Blue Shield Invoice (attached)

B. Monthly BCBS/MERP Graph (attached)

C. Monthly Staff and Applicant Changes (attached)

D. Monthly Workers' Compensation Report (attached)

E. Monthly Sexual Harassment Compliance Training Update (attached)

F. Monthly Benefit Administration System Implementation Timeline (attached)

G. Presentation by Group Alternatives/Assured (attached)

7. Compliance

8. Old Business

9. New Business

10. Reports Placed On File

11. Executive Session (If Needed)

12. Adjournment

Current Month Transactions

Total Amended Budget

YTD Actual Transactions

Total % Received

120 Human Resource Management 984$ 495$ 50.27%246 Employee Events Fund 984$ 495$ 50.27%

660 Veterans' Commission 16,363$ 334,505$ 18,188$ 5.44%380 Veterans' Commission 16,363$ 334,505$ 18,188$ 5.44%

Grand Total 16,363$ 335,489$ 18,683$ 5.57%

Human Services Committee Revenue Report - SummaryThrough May 31, 2020 (50.0% YTD)

Packet Pg. 2




YTD Encumbrances Total % Used

120 Human Resource Management 66,201$ 4,111,485$ 3,006,725$ -$ 73.13%001 General Fund 16,851$ 298,687$ 108,900$ -$ 36.46%010 Insurance Liability 49,350$ 3,811,814$ 2,897,824$ -$ 76.02%246 Employee Events Fund 984$ -$ -$ 0.00%

660 Veterans' Commission 19,790$ 334,505$ 129,580$ -$ 38.74%380 Veterans' Commission 19,790$ 334,505$ 129,580$ -$ 38.74%

Grand Total 85,991$ 4,445,990$ 3,136,305$ -$ 70.54%

Human Services Committee Expenditure Report - Summary Through May 31, 2020 (50.0% YTD, 46.15% Payroll)

Packet Pg. 3




YTD Encumbrances Total % Used

120 Human Resource Management 66,201$ 4,111,485$ 3,006,725$ -$ 73.13%001 General Fund 16,851$ 298,687$ 108,900$ -$ 36.46%

Personnel Services- Salaries & Wages 13,078$ 193,199$ 77,787$ -$ 40.26%Personnel Services- Employee Benefits 1,385$ 56,838$ 15,813$ -$ 27.82%Commodities 240$ 6,300$ 1,610$ -$ 25.55%Contractual Services 2,149$ 42,350$ 13,691$ -$ 32.33%

010 Insurance Liability 49,350$ 3,811,814$ 2,897,824$ -$ 76.02%Personnel Services- Salaries & Wages 10,586$ 139,129$ 63,513$ -$ 45.65%Personnel Services- Employee Benefits 2,316$ 43,243$ 17,252$ -$ 39.89%Contractual Services 36,448$ 3,629,442$ 2,817,059$ -$ 77.62%

246 Employee Events Fund -$ 984$ -$ -$ 0.00%Commodities -$ 984$ -$ -$ 0.00%

660 Veterans' Commission 19,790$ 334,505$ 129,580$ -$ 38.74%380 Veterans' Commission 19,790$ 334,505$ 129,580$ -$ 38.74%

Personnel Services- Salaries & Wages 14,882$ 194,547$ 89,295$ -$ 45.90%Personnel Services- Employee Benefits 4,480$ 89,309$ 37,430$ -$ 41.91%Commodities 188$ 3,086$ 437$ -$ 14.16%Contractual Services 240$ 47,563$ 2,418$ -$ 5.08%

Grand Total 85,991$ 4,445,990$ 3,136,305$ -$ 70.54%

Human Services Committee Expenditure Report - Detail Through May 31, 2020 (50.0% YTD, 46.15% Payroll)

Packet Pg. 4

Vendor Invoice No. Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice AmountFund 001 - General Fund

Department 120 - Human Resource ManagementSub-Department 120 - Human Resource Management

Account 52140 - Repairs and Maint- Copiers4371 - Toshiba Business Solutions, Inc. 5258545 TOBAJQC Copier

Charges 2/1/20-4/30/20

Paid by Check # 370909

05/04/2020 05/13/2020 05/13/2020 05/26/2020 263.76

Account 52140 - Repairs and Maint- Copiers Totals Invoice Transactions 1 $263.76Account 55000 - Miscellaneous Contractual Exp

3854 - Identisys, Inc. 486019 ID Service Agreement 6.1.2020 - 5.31.2021

Paid by EFT # 59409

05/11/2020 05/13/2020 05/13/2020 05/26/2020 1,885.00

Account 55000 - Miscellaneous Contractual Exp Totals Invoice Transactions 1 $1,885.00Account 60000 - Office Supplies

12287 - Century Springs/Ove Water Services

2455653 Fin Water Deliveries April 2020

Paid by EFT # 59345

04/30/2020 05/07/2020 05/07/2020 05/26/2020 13.25

4907 - HR Direct INV9063346 HR Personnel Folders Paid by Check # 370868

05/07/2020 05/08/2020 05/08/2020 05/26/2020 182.98

3578 - Warehouse Direct Office Products 4666711-0 Office Supplies Paid by EFT # 59519

05/14/2020 05/11/2020 05/11/2020 05/26/2020 44.04

Account 60000 - Office Supplies Totals Invoice Transactions 3 $240.27Sub-Department 120 - Human Resource Management Totals Invoice Transactions 5 $2,389.03

Department 120 - Human Resource Management Totals Invoice Transactions 5 $2,389.03Fund 001 - General Fund Totals Invoice Transactions 5 $2,389.03

Fund 010 - Insurance LiabilityDepartment 120 - Human Resource Management

Sub-Department 130 - Insurance Liability- HRMAccount 50000 - Project Administration Services

8258 - CCMSI 0126625-IN 2020 May Administration/Claims Fee

Paid by EFT # 59126

05/01/2020 04/28/2020 04/28/2020 05/11/2020 5,791.67

Account 50000 - Project Administration Services Totals Invoice Transactions 1 $5,791.67Account 53000 - Liability Insurance

1063 - Meade Inc. 687912 Traffic signal, Stearns/Mclean

Paid by EFT # 59226

04/22/2019 04/28/2020 04/28/2020 05/11/2020 2,729.61

1654 - Northern Contracting, Inc. 8367 LaFox - Rt 38 Guardrail Paid by EFT # 59451

05/05/2020 05/13/2020 05/13/2020 05/26/2020 1,451.90

Account 53000 - Liability Insurance Totals Invoice Transactions 2 $4,181.51Account 53010 - Workers Compensation

8258 - CCMSI 0085160-IN WC Reimbursements April 2020

Paid by EFT # 59125

04/30/2020 04/28/2020 04/28/2020 05/11/2020 82,969.94

Run by Finance Reports on 06/03/2020 09:07:13 AM Page 1 of 2

Human Services Accounts Payable by GL Distribution

Payment Date Range 05/01/20 - 05/31/20

Packet Pg. 5

javascript:void(window.open('https://countyerp.co.kane.il.us/nwerp/LogosSuite/CommonPages/ModalDialogContainer.aspx?Page=https://countyerp.co.kane.il.us/nwerp/FM/Inquiries/InquiryInvoiceSingle.aspx&ID=319693','',%20'dialogHeight:650px;%20dialogwidth:1010px;%20scroll:yes;%20status:no;%20unadorned:on;%20help:%20off'));javascript:void(window.open('https://countyerp.co.kane.il.us/nwerp/LogosSuite/CommonPages/ModalDialogContainer.aspx?Page=https://countyerp.co.kane.il.us/nwerp/FM/Inquiries/InquiryInvoiceSingle.aspx&ID=319729','',%20'dialogHeight:650px;%20dialogwidth:1010px;%20scroll:yes;%20status:no;%20unadorned:on;%20help:%20off'));javascript:void(window.open('https://countyerp.co.kane.il.us/nwerp/LogosSuite/CommonPages/ModalDialogContainer.aspx?Page=https://countyerp.co.kane.il.us/nwerp/FM/Inquiries/InquiryInvoiceSingle.aspx&ID=319269','',%20'dialogHeight:650px;%20dialogwidth:1010px;%20scroll:yes;%20status:no;%20unadorned:on;%20help:%20off'));javascript:void(window.open('https://countyerp.co.kane.il.us/nwerp/LogosSuite/CommonPages/ModalDialogContainer.aspx?Page=https://countyerp.co.kane.il.us/nwerp/FM/Inquiries/InquiryInvoiceSingle.aspx&ID=319317','',%20'dialogHeight:650px;%20dialogwidth:1010px;%20scroll:yes;%20status:no;%20unadorned:on;%20help:%20off'));javascript:void(window.open('https://countyerp.co.kane.il.us/nwerp/LogosSuite/CommonPages/ModalDialogContainer.aspx?Page=https://countyerp.co.kane.il.us/nwerp/FM/Inquiries/InquiryInvoiceSingle.aspx&ID=320868','',%20'dialogHeight:650px;%20dialogwidth:1010px;%20scroll:yes;%20status:no;%20unadorned:on;%20help:%20off'));javascript:void(window.open('https://countyerp.co.kane.il.us/nwerp/LogosSuite/CommonPages/ModalDialogContainer.aspx?Page=https://countyerp.co.kane.il.us/nwerp/FM/Inquiries/InquiryInvoiceSingle.aspx&ID=319170','',%20'dialogHeight:650px;%20dialogwidth:1010px;%20scroll:yes;%20status:no;%20unadorned:on;%20help:%20off'));javascript:void(window.open('https://countyerp.co.kane.il.us/nwerp/LogosSuite/CommonPages/ModalDialogContainer.aspx?Page=https://countyerp.co.kane.il.us/nwerp/FM/Inquiries/InquiryInvoiceSingle.aspx&ID=318995','',%20'dialogHeight:650px;%20dialogwidth:1010px;%20scroll:yes;%20status:no;%20unadorned:on;%20help:%20off'));javascript:void(window.open('https://countyerp.co.kane.il.us/nwerp/LogosSuite/CommonPages/ModalDialogContainer.aspx?Page=https://countyerp.co.kane.il.us/nwerp/FM/Inquiries/InquiryInvoiceSingle.aspx&ID=319669','',%20'dialogHeight:650px;%20dialogwidth:1010px;%20scroll:yes;%20status:no;%20unadorned:on;%20help:%20off'));javascript:void(window.open('https://countyerp.co.kane.il.us/nwerp/LogosSuite/CommonPages/ModalDialogContainer.aspx?Page=https://countyerp.co.kane.il.us/nwerp/FM/Inquiries/InquiryInvoiceSingle.aspx&ID=319169','',%20'dialogHeight:650px;%20dialogwidth:1010px;%20scroll:yes;%20status:no;%20unadorned:on;%20help:%20off'));

Vendor Invoice No. Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice AmountFund 010 - Insurance Liability

Department 120 - Human Resource ManagementSub-Department 130 - Insurance Liability- HRM

Account 53010 - Workers Compensation8258 - CCMSI 0085317-IN Advanced Funding

18D45F800771Paid by EFT # 59125

05/01/2020 05/01/2020 05/01/2020 05/11/2020 34,996.41

Account 53010 - Workers Compensation Totals Invoice Transactions 2 $117,966.35Sub-Department 130 - Insurance Liability- HRM Totals Invoice Transactions 5 $127,939.53

Department 120 - Human Resource Management Totals Invoice Transactions 5 $127,939.53Fund 010 - Insurance Liability Totals Invoice Transactions 5 $127,939.53

Fund 380 - Veterans' CommissionDepartment 660 - Veterans' Commission

Sub-Department 660 - Veterans' CommissionAccount 52140 - Repairs and Maint- Copiers

8338 - Copy King Office Solutions Inc 52631 Copy Machine Repair Paid by EFT # 59151

04/28/2020 04/28/2020 04/28/2020 04/28/2020 05/11/2020 195.95

Account 52140 - Repairs and Maint- Copiers Totals Invoice Transactions 1 $195.95Account 53130 - General Association Dues

4526 - Fifth Third Bank 8705-JZ-04/20 Purchasing Card Purchases

Paid by EFT # 59382

05/04/2020 06/04/2020 05/14/2020 05/14/2020 05/26/2020 240.00

Account 53130 - General Association Dues Totals Invoice Transactions 1 $240.00Account 60000 - Office Supplies

12287 - Century Springs/Ove Water Services

2466938 Water Cooler Rental for May

Paid by EFT # 59345

04/30/2020 05/30/2020 05/14/2020 04/30/2020 05/26/2020 2.50

Account 60000 - Office Supplies Totals Invoice Transactions 1 $2.50Account 60060 - Computer Software- Non Capital

4526 - Fifth Third Bank 8705-JZ-04/20 Purchasing Card Purchases

Paid by EFT # 59382

05/04/2020 06/04/2020 05/14/2020 05/14/2020 05/26/2020 185.25

Account 60060 - Computer Software- Non Capital Totals Invoice Transactions 1 $185.25Sub-Department 660 - Veterans' Commission Totals Invoice Transactions 4 $623.70

Department 660 - Veterans' Commission Totals Invoice Transactions 4 $623.70Fund 380 - Veterans' Commission Totals Invoice Transactions 4 $623.70

Grand Totals Invoice Transactions 14 $130,952.26


Human Services Accounts Payable by GL Distribution

Payment Date Range 05/01/20 - 05/31/20

Packet Pg. 6

javascript:void(window.open('https://countyerp.co.kane.il.us/nwerp/LogosSuite/CommonPages/ModalDialogContainer.aspx?Page=https://countyerp.co.kane.il.us/nwerp/FM/Inquiries/InquiryInvoiceSingle.aspx&ID=319187','',%20'dialogHeight:650px;%20dialogwidth:1010px;%20scroll:yes;%20status:no;%20unadorned:on;%20help:%20off'));javascript:void(window.open('https://countyerp.co.kane.il.us/nwerp/LogosSuite/CommonPages/ModalDialogContainer.aspx?Page=https://countyerp.co.kane.il.us/nwerp/FM/Inquiries/InquiryInvoiceSingle.aspx&ID=319131','',%20'dialogHeight:650px;%20dialogwidth:1010px;%20scroll:yes;%20status:no;%20unadorned:on;%20help:%20off'));javascript:void(window.open('https://countyerp.co.kane.il.us/nwerp/LogosSuite/CommonPages/ModalDialogContainer.aspx?Page=https://countyerp.co.kane.il.us/nwerp/FM/Inquiries/InquiryInvoiceSingle.aspx&ID=319722','',%20'dialogHeight:650px;%20dialogwidth:1010px;%20scroll:yes;%20status:no;%20unadorned:on;%20help:%20off'));javascript:void(window.open('https://countyerp.co.kane.il.us/nwerp/LogosSuite/CommonPages/ModalDialogContainer.aspx?Page=https://countyerp.co.kane.il.us/nwerp/FM/Inquiries/InquiryInvoiceSingle.aspx&ID=319727','',%20'dialogHeight:650px;%20dialogwidth:1010px;%20scroll:yes;%20status:no;%20unadorned:on;%20help:%20off'));javascript:void(window.open('https://countyerp.co.kane.il.us/nwerp/LogosSuite/CommonPages/ModalDialogContainer.aspx?Page=https://countyerp.co.kane.il.us/nwerp/FM/Inquiries/InquiryInvoiceSingle.aspx&ID=319722','',%20'dialogHeight:650px;%20dialogwidth:1010px;%20scroll:yes;%20status:no;%20unadorned:on;%20help:%20off'));

Vendor Invoice No. Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice AmountFund 120 - Grand Victoria Casino Elgin

Department 010 - County BoardSub-Department 020 - Riverboat

Account 45420 - Tuition Reimbursement11129 - Gabriela Allison 1907-01 PACE111P-Career

Exploration & WRTG112 Intro Academic Writing


11/21/2019 11/22/2019 11/26/2019 12/09/2019 1,497.00

9457 - Ellen Fultz-Schmid 1906-01 Internet Librarian Conference

Paid by EFT # 56450

09/25/2019 11/22/2019 11/26/2019 12/09/2019 649.00

12398 - Jessica Orsini 1904-01 LEJA513 Public Policy & LEJA504 Civil Criminal Liability


12/18/2019 12/26/2019 11/30/2019 01/06/2020 1,019.46

12399 - Jasmine Pease 1905-01 SWK6720; SWK6500; SWK6250; SWK5300


12/20/2019 12/26/2019 11/30/2019 01/06/2020 2,400.00

Account 45420 - Tuition Reimbursement Totals Invoice Transactions 4 $5,565.46Sub-Department 020 - Riverboat Totals Invoice Transactions 4 $5,565.46Department 010 - County Board Totals Invoice Transactions 4 $5,565.46

Fund 120 - Grand Victoria Casino Elgin Totals Invoice Transactions 4 $5,565.46Grand Totals Invoice Transactions 4 $5,565.46


Tuition Reimbursement FYTDPayment Date Range 12/01/19 - 05/31/20

Packet Pg. 7

javascript:void(window.open('https://countyerp.co.kane.il.us/nwerp/LogosSuite/CommonPages/ModalDialogContainer.aspx?Page=https://countyerp.co.kane.il.us/nwerp/FM/Inquiries/InquiryInvoiceSingle.aspx&ID=309350','',%20'dialogHeight:650px;%20dialogwidth:1010px;%20scroll:yes;%20status:no;%20unadorned:on;%20help:%20off'));javascript:void(window.open('https://countyerp.co.kane.il.us/nwerp/LogosSuite/CommonPages/ModalDialogContainer.aspx?Page=https://countyerp.co.kane.il.us/nwerp/FM/Inquiries/InquiryInvoiceSingle.aspx&ID=309351','',%20'dialogHeight:650px;%20dialogwidth:1010px;%20scroll:yes;%20status:no;%20unadorned:on;%20help:%20off'));javascript:void(window.open('https://countyerp.co.kane.il.us/nwerp/LogosSuite/CommonPages/ModalDialogContainer.aspx?Page=https://countyerp.co.kane.il.us/nwerp/FM/Inquiries/InquiryInvoiceSingle.aspx&ID=311613','',%20'dialogHeight:650px;%20dialogwidth:1010px;%20scroll:yes;%20status:no;%20unadorned:on;%20help:%20off'));javascript:void(window.open('https://countyerp.co.kane.il.us/nwerp/LogosSuite/CommonPages/ModalDialogContainer.aspx?Page=https://countyerp.co.kane.il.us/nwerp/FM/Inquiries/InquiryInvoiceSingle.aspx&ID=311614','',%20'dialogHeight:650px;%20dialogwidth:1010px;%20scroll:yes;%20status:no;%20unadorned:on;%20help:%20off'));

VETERANS ASSISTANCE COMMISSION

Transaction Date Merchant Name Additional Information Transaction Amount

5/14/2020 IACO PAXTON ($180.00)

5/27/2020 SOUTHERN COMPUTER WARE TEL8774686729 $151.60

5/30/2020 AMZN MKTP US M72SR4SH2 AMZN.COM/BILL $39.99

5/31/2020 AMAZON.COM MY9KJ3OY0 AMZN.COM/BILL $29.99

Total: $41.58

Total all: $41.58

1 of 1 6/5/2020 9:38:13 AM

Kane County Purchasing Card InformationHuman Services Committee

May 2020 Statement

Packet Pg. 8

Revenue652.800.000.38000 ‐ Investment Income ‐ 652.800.000.38910 ‐ Healthcare Employer Portion 5,763,988.39 652.800.000.38915 ‐ Dental Employer Portion 202,428.28 652.800.000.38920 ‐ Healthcare Employee Portion 1,220,725.25 652.800.000.38921 ‐ Dental Employee Portion 128,816.90 652.800.000.38927 ‐ MERP Employer Portion 368,431.99 652.800.000.38930 ‐ Retiree Payments ‐ Healthcare 322,880.05 652.800.000.38935 ‐ Retiree Payments ‐ Dental 948.41 652.800.000.38940 ‐ Cobra Payments ‐ Healthcare 35,991.42 652.800.000.38945 ‐ Cobra Payments ‐ Dental 1,459.87 Total Revenue 8,045,670.56

Expenses ‐ Health Insurance General652.800.814.50150 ‐ Contractual/Consulting Services 57,200.00 652.800.814.50520 ‐ Healthcare Admin Services 4,336.00 652.800.814.53005 ‐ Healthcare ‐ Stop Loss Insurance (435,419.71) 652.800.814.53031 ‐ Self Insured Healthcare Claims ‐ 652.800.814.53032 ‐ Self Insured Healthcare Claims Administration ‐ 652.800.814.53036 ‐ Healthcare Taxes ‐ 652.800.814.53038 ‐ Healthcare ‐ Vision Insurance 48,456.60 652.800.814.53039 ‐ Affordable Care Act Fee ‐ 652.800.814.53300 ‐ Healthcare ‐ Health Insurance ‐ 652.800.814.53310 ‐ Healthcare ‐ Dental Insurance 442,286.04 652.800.814.53320 ‐ Healthcare ‐ Life Insurence 20,245.61 652.800.814.53380 ‐ Healthcare ‐ Wellness 425.00 652.800.814.53385 ‐ Financial Wellness 2,500.00 652.800.814.53390 ‐ Change in IPBC Terminal Reserve ‐ Total Health Insurance General Expenses 140,029.54

Health Insurance FundRevenue and Expenses

As of Transactions Processed for Fiscal Year 2020 through June 4, 2020

Packet Pg. 9

Health Insurance FundRevenue and Expenses


Expenses ‐ Health Insurance MERP652.800.814.53340 ‐ MERP ‐ Premium Reimbursement 28,679.56 652.800.814.45100 ‐ MERP FICA/SS on Premium Reimbursement 2,178.39 652.800.814.53330 ‐ MERP ‐ Medical Expense Reimbursement 69,258.27 652.800.814.53350 ‐ MERP ‐ Shared Savings with Administrator 53,269.41 Total MERP Expenses 153,385.63

Expenses ‐ Health Insurance PPO652.800.817.53005 ‐ Healthcare ‐ Stop Loss Insurance 197,619.22 652.800.817.53031 ‐ Self Insured Healthcare Claims 2,711,678.87 652.800.817.53032 ‐ Self Insured Healthcare Claims Administration 87,653.00 652.800.817.53033 ‐ Healthcare Facility Access Fee 13,879.09 652.800.817.53037 ‐ Healthcare Credits (58,804.10) Total Health Insurance PPO Expenses 2,952,026.08

Expenses ‐ Health Insurance HMO652.800.818.53005 ‐ Healthcare ‐ Stop Loss Insurance 170,713.35 652.800.818.53031 ‐ Self Insured Healthcare Claims 1,934,432.76 652.800.818.53032 ‐ Self Insured Healthcare Claims Administration 167,941.50 652.800.818.53034 ‐ Healthcare HMO Managed Care Fee 37,534.11 652.800.818.53035 ‐ Healthcare Physician Services Fee 1,111,853.78 652.800.818.53036 ‐ Healthcare Taxes ‐ 652.800.818.53037 ‐ Healthcare Credits (112,667.55) Total Health Insurance HMO Expenses 3,309,807.95

Total Expenses 6,555,249.20

Revenue Net Expenses 1,490,421.36

Packet Pg. 10

10000 Beginning Cash Balance 5,715,346.82 11900 Change in Investments‐ Fair Value Adjust ‐ 12000 Change in Interest Receivable ‐ 12400 Change in Accounts Receivable (4,515.10) 12410 Change in Healthcare Receivable 281,730.00 12490 Change in Other Accounts Receivable 2,920.39 13000 Change in Due From Other Funds 695,633.95 15000 Change in Prepaid Expense 10,878.33 15310 Change in Advance Funding ‐ FSA (26,271.99) 20000 Change in Accounts Payable (1,700,031.93) 20010 Change in Accrued Liabilities (909,608.74) 25050 Change in Unearned Revenue ‐ 30000‐99999 Revenue net Expenses 1,490,421.36 10000 Ending Cash Balance 5,556,503.09

Health Insurance FundCash Flow Statement (Reconciliation)


Packet Pg. 11

Jul‐19 Aug‐19 Sep‐19 Oct‐19 Nov‐19 Dec‐19 Jan‐20 Feb‐20 Mar‐20 Apr‐20 May‐20 Jun‐20Target * 9,000,000 9,000,000 9,000,000 9,000,000 9,000,000 9,000,000 9,000,000 9,000,000 9,000,000 9,000,000 9,000,000 9,000,000Actual 4,364,635 5,326,113 5,474,088 6,366,371 5,715,347 5,455,087 5,369,335 5,412,562 5,441,790 5,282,530 5,588,851 5,556,503

Total Health Insurance General Expenses

Health Insurance Fund Rolling Cash Balances as of June 4, 2020

Prepared by Finance Department for Human Services Committee

‐

1,000,000

2,000,000

3,000,000

4,000,000

5,000,000

6,000,000

7,000,000

8,000,000

9,000,000

10,000,000

Jul‐19 Aug‐19 Sep‐19 Oct‐19 Nov‐19 Dec‐19 Jan‐20 Feb‐20 Mar‐20 Apr‐20 May‐20 Jun‐20

Health Insurance Fund Rolling 12‐Month Cash Balances

Target Cash Balance = $9,000,000

Rolling 12 Month Cash Balance

Target Shortfall

Packet Pg. 12

Organized under Chapter 330, Section 45 of the Illinois Compiled Statutes,

a statutory body comprised of the veterans organizations in Kane County, Illinois.

COUNTY OF KANE VETERANS ASSISTANCE COMMISSION

Monthly Report on Commission Activities

99

100.2

99.798.8 98.3

96.6

104.5

99.394.4 97.9

102 103.9

106.8103.5

99.7

48.544.7 44.7

64.760.9

40

50

60

70

80

90

100

110

Average Days Pending for Claims Fiscal YTD

Average IllinoisCompensation

VACCompensation

Average ILPension

VAC Pension

8,966 9,3499,761 9,456

8,349

154 127 159 154 144

0

2,000

4,000

6,000

8,000

10,000

12,000

Total Claims Pending

All IL

VAC

JACOB A. ZIMMERMAN

Superintendent

COUNTY GOVERNMENT CENTER

719 South Batavia Avenue, Building A

Geneva, Illinois 60134-3077

Phone: (630) 232-3550

Fax: (630) 232-5403

www.countyofkane.org/pages/veterans.aspx

Packet Pg. 13

Organized under Chapter 330, Section 45 of the Illinois Compiled Statutes,

a statutory body comprised of the veterans organizations in Kane County, Illinois.

020406080

100120140160

134

12 5 540 43

10

11 2

3 8

Claims Applications Filed

April

ThroughMarch

969

97

0

200

400

600

800

1,000

1,200

Forms

Forms Completed

April

ThroughMarch

$490,155.82

$1,842,725.63

New VA Payments to Claimants Fiscal YTD

April

ThroughMarch

Financial Assistance Expenditures

Shelter Gas Electric

Water Sewage Garbage

Food Personal Burial

Packet Pg. 14

VETERANS ASSISTANCE COMMISSION CLAIM REPORT

Category December January February M arch Apr il M ay June July August September October November FY 2020 Total

Service-Connected Disability Claims 28 37 40 29 10 144

Non-Service Connected Pension Claims 4 2 2 4 1 13

Dependent's Compensation Claims 1 2 2 0 1 6

Survivor's Pension Claims 1 0 2 2 2 7

Intent-to-File 24 32 19 13 6 94

VA Health Care Applications 10 12 12 6 3 43

Claims Follow Up or Decision Review 30 76 58 37 24 225

Notice of Disagreement (Appeal) 1 0 0 0 0 1

Supplemental Claim (Appeal) 2 7 11 3 6 29

Higher Level Review (Appeal) 1 0 2 4 2 9

Substantive Appeal (Appeal) 1 1 0 0 0 2

Board Appeal (Appeal) 3 3 2 2 0 10

Burial Benefits Applications 7 6 3 7 1 24

Military or Other Record Request 34 44 34 14 1 127

Corrections / Upgrade Military Records 3 3 1 2 0 9

Federal Ancillary Benefit Applications 6 6 8 9 1 30

State Ancillary Benefit Applications 11 6 5 6 4 32

Dependent's Ancillary Applications 2 5 4 6 0 17

Total Forms or Letters Completed 242 311 203 213 97 1,066

Total Claims Pending 154 127 159 154 144

Intent-to-File Pending 184 176 172 156 146

New VA Monetary Awards 399,943.34$ $485,140.23 339,552.47$ 618,089.59$ 490,155.82$ 2,332,881.45$

Packet Pg. 15

Packet Pg. 16

Employees Spouses Dependents MERP995 464 816 51

Kane County BCBS/MERP Enrollees as of 4/28/2020

0

200

400

600

800

1000

1200

Employees Spouses Dependents MERP

Kane County BCBS/MERP Enrollees as of 4/28/2020

Packet Pg. 17

Department Employee Name Termination DateBuilding Management MOORE, ALEXANDER E 05/01/20Regional Office of Education MUNTNER, MATTHEW R 05/13/20Sheriff/Court Security SCHWER, BOB L 05/15/20

Total Terminations 3

Termination Report from 05/01/2020 - 05/31/2020

Page 1 of 1

Packet Pg. 18

Title Post Date - Deadline Open/Closed ApplicantsAnimal Control (Brett Youngsteadt, Administrator)

Warden 08/19/2019 - N/A Closed on 4/13/2020 1Part Time Kennel Assistant 01/02/2020 - N/A Closed on 4/17/2020 2Full Time Kennel Assistant 01/27/2020 - N/A Closed on 5/11/2020 6Total Animal Control Applicants 9

Building Management (Rickey Sparks, Executive Director)Maintenance - Corrections/Sheriff's facility 03/25/2019 - N/A Open 1Maintenance-Building Management Operations 03/25/2019 - N/A Open 3Maintenance-Building Management Opeations 04/14/2020 - N/A Open 2Director of Capital Projects 05/14/2020 - N/A Open 6Mail Clerk-Utility Person 05/14/2020 - N/A Open 3Total Building Management Applicants 15

Community Reinvestment and Workforce Development (Scott Berger, Director)Business Services Representative 08/05/2019 - N/A Open 14Career Specialist 08/05/2019 - N/A Open 8Special Programs Representative 12/06/2019 - N/A Open 1Administrative Coordinator - Workforce Development

02/07/2020 - N/A Closed on 5/19/2020 13

Project Manager 04/16/2020 - N/A Open 11Total Community Reinvestment and Workforce Development Applicants 47

County Board (Chris Lauzen, County Board Chairman)Receptionist/Recording Secretary 04/16/2020 - N/A Closed on 4/16/2020 0Receptionist/Recording Secretary 04/16/2020 - N/A Closed on 5/19/2020 72Total County Board Applicants 72

Court Services (Lisa Aust, Executive Director)Intern/Volunteer N/A Open 1Youth Counselor 02/27/2020 - N/A Closed on 4/16/2020 5Total Court Services Applicants 6

Finance (Joseph Onzick, Executive Director)Accounting Clerk 04/28/2020 - N/A Open 9Payroll Clerk 04/28/2020 - N/A Open 11Total Finance Applicants 20

Job Applicants for April 2020 by Position

Printed on 6/3/2020 2:53 PM Page1 of 3

Packet Pg. 19

Human Resource Management (Sylvia Wetzel, Executive Director)FMLA Senior Human Resource Generalist II 03/02/2020 - N/A Closed on 4/9/2020 0Total Human Resource Management Applicants 0

Information Technologies (Roger Fahnestock, Executive Director)Desktop Support Analyst I 10/04/2019 - N/A Open 9Total Information Technologies Applicants 9

KDOT (Carl Schoedel, Director and County Engineer Transportation)Construction Resident Engineer 02/01/2019 - N/A Open 1Construction Technician/Manager 01/28/2020 - N/A Closed on 5/29/2020 2Traffic/Permit Engineer or Engineering Technician 02/13/2020 - N/A Closed on 4/6/2020 1Highway Maintainer I 03/11/2020 - N/A Closed on 4/9/2020 8Total KDOT Applicants 12

Public Health Department (Barbara Jeffers, Executive Director)Intern/Volunteer N/A Open 3CHS II: Public Health Nurse 04/12/2019 - N/A Open 3CHS II Public Health Nurse (Grant funded position for the Nurse Family Partnership Program

07/09/2019 - N/A Open 4

Division Director of Disease Prevention 12/17/2019 - N/A Open 3Workforce Development Specialist 01/17/2020 - N/A Open 6Community Health Specialist III: Emergency Response Coordinator

02/27/2020 - N/A Closed on 5/18/2020 6

Public Health Intern/Volunteer (Trap Collection for West Nile Program)

04/17/2020 - N/A Open 1

COVID-19 Communicable Disease Coordinator-Seasonal Position

05/05/2020 - N/A Open 10

COVID-19 Communications Coordinator-Seasonal Position

05/05/2020 - N/A Open 7

COVID-19 Environmental Health Specialist-Full Time Seasonal

05/05/2020 - N/A Open 10

COVID-19 Long Term Care Facility Liaison-Seasonal Position

05/05/2020 - N/A Open 11

COVID-19 Surveillance Specialist-Seasonal Position

05/05/2020 - N/A Open 19

COVID-19 Outbreak Investigations Liaison (FT Seasonal Position)

05/15/2020 - N/A Open 11

COVID-19 Workforce Onboarding Specialist (FT Seasonal Position)

05/15/2020 - N/A Open 10


Packet Pg. 20

Total Public Health Department Applicants 104

Sheriff (Ron Hain, Sheriff)Court Security Officer 11/19/2019 - N/A Open 19Information Data Processor 02/18/2020 - N/A Open 11Total Sheriff Applicants 30

State's Attorney (Joseph McMahon, Elected Official States Attorney)Intern/Volunteer N/A Open 2Criminal Investigator 05/07/2020 - N/A Open 17Total State's Attorney Applicants 19

Total Applicants for April 343


Packet Pg. 21

Department Employee Name Job Title Employee Status Hire Date

ACOSTA PONCE DE LEON, NICOLE Kennel Assistant ACTIVE 05/06/2020

VANDERFOREST, RICHARD A Program Manager ACTIVE 05/05/2020

DAUFENBACH, SUSAN M Recording Secretary ACTIVE 05/29/2020

MATTHEWS, KELLY M Senior HR Generalist ACTIVE 05/05/2020

TORRES, MYRA Administrative Assistant ACTIVE 05/05/2020

NORKUS, SARAH J Law Clerk ACTIVE 05/12/2020

HOHERTZ, DORIS A Traffic Permit Civil Engineer I ACTIVE 05/04/2020Engineering Co-op Intern ACTIVE 05/18/2020Intern ACTIVE 05/18/2020

TRAFTON, ALEK W N Intern ACTIVE 05/11/2020

Total New Hires 9

New Hire Report from 05/01/2020 - 05/31/2020

Animal Control

Community Reinvestment

County Board

Human Resource Management

Regional Office of Education

State's Attorney

Transportation

JONES, NOAH S

Page 1 of 1

Packet Pg. 22

Packet Pg. 23

Packet Pg. 24

Packet Pg. 25

Packet Pg. 26

Packet Pg. 27

Packet Pg. 28

Packet Pg. 29

Packet Pg. 30

Type of Training

Delivered Training Title Source of Training Departments invited

Total number of attendees Deadline

Webinar Prevention of Harassment at work - Employee

Illinois Chamber of Commerce All 586 1-Oct-20

Webinar Prevention of Harassment at work - Manager/Elected Official

Illinois Chamber of Commerce All 110 1-Oct-20

Training Report as of June 2020

Packet Pg. 31

Client Name: Implementation Start Go Live for Employees Enrollment End Total Weeks

Today’s Date: 5/20/20 10/1/20 TBD 19

Category Phase Assigned To Assigned Date Due Date Task Status Completed Date NotesComplete, Sign, and Return Carrier Authorization Form Essentials 1. Discovery Client/Broker 5/20/20 5/28/20 Complete 5/27/20Complete Scope Tab in Discovery Profile and Send to Client Essentials 1. Discovery SmartBen PDA 5/20/20 5/28/20 Complete 5/27/20Confirm Username and Password Conventions Essentials 1. Discovery Client/Broker 5/20/20 6/4/20 Complete 5/27/20 Username - KANE + EMPLOYEE IDConfirm Go Live Dates: New Hire / Life Events / Open Enrollment Essentials 1. Discovery Client/Broker 5/20/20 5/26/20 Complete 5/20/20Confirm Active or Passive Open Enrollment and New Hire Creation Status Essentials 1. Discovery SmartBen PDA 6/2/20 6/4/20 In Process just need to confirm New Hire Creation StatusSubmit HR Master / HR Admin Users (Name, Email, Title, Phone Number, Access Level) Essentials 1. Discovery Client/Broker 5/20/20 5/28/20 Complete 5/27/20Submit Official Logo in .jpeg or .png Format Essentials 1. Discovery Client/Broker 5/20/20 5/28/20 Complete 5/22/20

Confirm Sentry (Dependent Verification) Go Live Date Sentry 1. Discovery Client/Broker 5/20/20 5/26/20 Complete 5/20/20Will audit newly added dependents (as opposed to full population audit up front)

Complete and return Paytype Tab and Effective and Termination Rules Tabs in the Discovery Profile Essentials 1. Discovery Client/Broker 5/20/20 5/28/20 Behind Schedule waiting on payroll review. Will be completed by 6/5Submit Facility Code List Essentials 1. Discovery Client/Broker 5/20/20 5/26/20 Not ApplicableCreate Client's Site within SmartBen and upload logo Essentials 2. Configuration SmartBen PDA 5/22/20 5/28/20 Complete 5/28/20Setup HR Master and HR Admin Login Credentials Essentials 2. Configuration SmartBen PDA 5/22/20 6/4/20 Complete 6/1/20 will provide to everyone by 6/4Confirm Tax IDs, Admin/Measurement/Stability Periods Gatekeeper 1. Discovery Client/Broker 5/28/20 6/4/20 Complete 5/28/20Confirm Loading Historical Data Capabilities Gatekeeper 1. Discovery Client/Broker 5/28/20 6/4/20 In Process Alma is looking into capabilities Create Internal Site Set-up (SharePoint/Email/Telephone/etc.) Assist 2. Configuration EBRC Implementation Analyst 5/28/20 5/28/20 Complete 5/28/20Customize and Provide HR User Manual to Client Essentials 4. Training SmartBen PDA 5/28/20 6/4/20 In ProcessConfigure Paytypes in SmartBen Essentials 2. Configuration SmartBen PDA 6/3/20 6/9/20 In ProcessConfigure Facility Codes in SmartBen Essentials 2. Configuration SmartBen PDA 5/27/20 6/2/20Complete and return current plan year Benefit Tabs in the Discovery Profile Essentials 1. Discovery Client/Broker 6/2/20 6/15/20 In ProcessComplete and return Life Event and Relationship Types Tabs in the Discovery Profile Essentials 1. Discovery Client/Broker 6/2/20 6/15/20 In Process HR reviewing once more Provide Plan Summaries and SBC Documents Essentials 1. Discovery Client/Broker 6/2/20 6/15/20 In Process will collect through emailComplete Site Builder Training Essentials 4. Training SmartBen PDA TBD TBDPopulate Site Builder Items Essentials 2. Configuration Client/Broker 6/2/20 6/15/20Provide Initial SmartBen Demographic Layout to Client for Review per confirmed Paytypes, Facility Codes, and Username and Password Conventions Essentials 3. Data SmartBen DA 6/4/20 6/4/20Import Tester Demographics in SmartBen Essentials 3. Data SmartBen DA 6/4/20 6/4/20Provide Official SmartBen Demographic Layout per any Determined Changes to Client Essentials 3. Data SmartBen DA 6/4/20 6/4/20Request Specifications from Carriers per Carrier Authorization Form Essentials 3. Data SmartBen DA 6/4/20 6/10/20Provide HRIS/Payroll File Specifications to H-M Data Analyst Essentials 3. Data Client/Broker 6/4/20 6/10/20Submit SmartBen Employee Demographic File to H-M Data Analyst for Testing and Approval Essentials 3. Data Client/Broker 6/4/20 6/24/20Build current plan year benefits in SmartBen and Provide Audit(s) to Client Essentials 2. Configuration SmartBen PDA 6/4/20 6/17/20Submit HRIS/Payroll File to Payroll Contact for Testing and Approval Essentials 3. Data SmartBen DA 6/4/20 6/17/20Complete Overview of How to Test the SmartBen System Essentials 4. Training SmartBen PDA 6/10/20 6/10/20Complete Gatekeeper Discovery Profile Gatekeeper 1. Discovery Client/Broker 6/10/20 6/16/20Submit HR Gatekeeper Access List to Gatekeeper PDA Gatekeeper 1. Discovery Client/Broker 6/10/20 6/16/20Populate Site Builder Plan Descriptions Essentials 2. Configuration SmartBen PDA 6/10/20 6/16/20Update Pathfinder Configuration per Provided Summaries and SBC Documents Essentials 2. Configuration SmartBen PDA 6/10/20 6/16/20Test benefit structures, rates, contributions, and enrollment verbiage Essentials 5. Testing SmartBen PDA 6/10/20 6/23/20Test benefit structures, rates, contributions, and enrollment verbiage Essentials 5. Testing Client/Broker 6/10/20 6/23/20Update Standard Message Boards on SmartBen Homepage Assist 2. Configuration EBRC Implementation Analyst 6/10/20 6/23/20Review, Sign, and Return current plan year Benefit Audit(s) Essentials 2. Configuration Client/Broker 6/17/20 6/23/20Import Approved Employee Demographic File in SmartBen Essentials 3. Data SmartBen DA 6/17/20 6/30/20Schedule Recurring SmartBen Employee Demographic File Essentials 3. Data Client/Broker 6/17/20 6/30/20Complete Site Build in Gatekeeper Gatekeeper 2. Configuration Gatekeeper PDA 6/17/20 6/30/20Create and Provide HR Login Credentials to Client Gatekeeper 2. Configuration Gatekeeper PDA 6/17/20 6/30/20Complete Employee Management Training Essentials 4. Training SmartBen PDA 6/24/20 6/24/20Finalize HR Support Pack Grids (QLE, OAD, EOI) HR Support Pack 2. Configuration EBRC Implementation Analyst 6/24/20 7/7/20Update QLE Messaging throughout SmartBen HR Support Pack 2. Configuration EBRC Implementation Analyst 6/24/20 7/7/20Provide Benefit Import Layouts to Client Essentials 3. Data SmartBen DA 7/1/20 7/1/20Provide Dependent/Beneficiary Import Layout to Client Essentials 3. Data SmartBen DA 7/1/20 7/1/20Complete and return enroll plan year Discovery Profile Essentials 1. Discovery Client/Broker 7/1/20 7/7/20Submit Benefit Import File(s) to H-M Data Analyst for Testing and Approval Essentials 3. Data Client/Broker 7/1/20 7/14/20Submit Dependent/Beneficiary Import File(s) to H-M Data Analyst for Testing and Approval Essentials 3. Data Client/Broker 7/1/20 7/14/20Finalize EOI Carrier Underwriting Decision Support Access for HRSP Team HR Support Pack 2. Configuration Client/Broker 7/1/20 7/14/20Provide Historical Determinations File Layout to Client Gatekeeper 3. Data Gatekeeper PDA 7/8/20 7/8/20Provide Hours Worked File Layout to Client Gatekeeper 3. Data Gatekeeper PDA 7/8/20 7/8/20Provide Employment History File Layout to Client Gatekeeper 3. Data Gatekeeper PDA 7/8/20 7/8/20Complete and return SmartBen Avatar Document Essentials 1. Discovery Client/Broker 7/8/20 7/14/20Build SmartBen NOW tiles per Discovery Profile specifications SmartBen NOW 2. Configuration SmartBen PDA 7/8/20 7/14/20Build enroll plan year Benefits and send Audit(s) Essentials 2. Configuration SmartBen PDA 7/8/20 7/14/20Test Open Enrollment and/or New Hire Pending Rules Essentials 5. Testing SmartBen PDA 7/8/20 7/14/20Import Approved Benefit Import File(s) in SmartBen Essentials 3. Data SmartBen DA 7/8/20 7/21/20Import Approved Dependent/Beneficiary File(s) in SmartBen Essentials 3. Data SmartBen DA 7/8/20 7/21/20Submit Historical Determinations File to Gatekeeper DA for Testing and Approval Gatekeeper 3. Data Client/Broker 7/8/20 7/21/20Submit Hours Worked File to Gatekeeper DA for Testing and Approval Gatekeeper 3. Data Client/Broker 7/8/20 7/21/20Submit Employment History File to Gatekeeper DA for Testing and Approval Gatekeeper 3. Data Client/Broker 7/8/20 7/21/20Complete My Self-Serve Training Essentials 4. Training SmartBen DA 7/15/20 7/15/20Provide SmartBen NOW Import File(s) Layouts to Client SmartBen NOW 3. Data SmartBen DA 7/15/20 7/15/20Submit SmartBen NOW File(s) to H-M Data Analyst for Testing and Approval SmartBen NOW 3. Data Client/Broker 7/15/20 7/21/20Test SmartBen NOW Tiles and App Functionality SmartBen NOW 5. Testing SmartBen PDA 7/15/20 7/21/20

MAJOR MILESTONESCounty of Kane

6/2/2020

Packet Pg. 32

Test SmartBen NOW Tiles and App Functionality SmartBen NOW 5. Testing Client/Broker 7/15/20 7/21/20Provide H-M Data Analyst with samples of current reports to be mirrored in SmartBen for Self-Serve or Custom Reporting Essentials 3. Data Client/Broker 7/15/20 7/21/20Update SmartBen Avatar Settings and Apply Provided Verbiage in SmartBen Essentials 2. Configuration SmartBen PDA 7/15/20 7/21/20Review, Sign, and Return enroll plan year Audit(s) Essentials 2. Configuration Client/Broker 7/15/20 7/28/20Complete Standard Operating Procedures (SOP) Document and Provide to Client Assist 2. Configuration EBRC Implementation Analyst 7/15/20 7/28/20Finalize Sentry (Dependent Verification) Packets Sentry 2. Configuration Sentry PDA 7/15/20 7/28/20Complete Pending Management Training Essentials 4. Training SmartBen PDA 7/22/20 7/22/20Test Open Enrollment and/or New Hire Pending Rules Essentials 5. Testing Client/Broker 7/22/20 7/28/20Import Historical Determinations File in Gatekeeper Gatekeeper 3. Data Gatekeeper DA 7/22/20 7/28/20Import Hours Worked File in Gatekeeper Gatekeeper 3. Data Gatekeeper DA 7/22/20 7/28/20Import Employment History File in Gatekeeper Gatekeeper 3. Data Gatekeeper DA 7/22/20 7/28/20Schedule Recurring Gatekeeper Imports Gatekeeper 3. Data Client/Broker 7/22/20 7/28/20Import SmartBen NOW File(s) in SmartBen SmartBen NOW 3. Data SmartBen DA 7/22/20 7/28/20Schedule Recurring SmartBen NOW Imports SmartBen NOW 3. Data Client/Broker 7/22/20 7/28/20Update Over Age Dependent Email Notification in SmartBen HR Support Pack 2. Configuration EBRC Implementation Analyst 7/22/20 8/4/20Complete Cohort and Push Notification Training SmartBen NOW 4. Training SmartBen PDA 7/29/20 7/29/20Send Final Checklist and Important System Rules Documents to Client Essentials 6. Go Live SmartBen PDA 7/29/20 7/29/20Sign and Return Final Checklist Essentials 6. Go Live Client/Broker 7/29/20 8/4/20Sign and Return Important System Rules Documents to SmartBen PDA Essentials 6. Go Live Client/Broker 7/29/20 8/4/20Complete Sentry System Training Sentry 4. Training Sentry PDA 8/5/20 8/5/20Complete Gatekeeper System Training Gatekeeper 4. Training Gatekeeper PDA 8/5/20 8/5/20Sign off on the Case Setup Report in Gatekeeper Gatekeeper 6. Go Live Client/Broker 8/5/20 8/11/20Move SmartBen Site into Production Essentials 6. Go Live SmartBen PDA 10/1/20 10/1/20Setup Enrollment Status Reports if live for Open Enrollment Essentials 6. Go Live SmartBen DA 10/1/20 10/1/20Move SmartBen NOW into Production SmartBen NOW 6. Go Live SmartBen PDA 10/1/20 10/1/20Move Gatekeeper Site into Production Gatekeeper 6. Go Live Gatekeeper PDA 10/1/20 10/1/20New Pending Management Review for Open Enrollment Essentials 7. Post OE SmartBen PDA 10/1/20 TBDReview and update incomplete benefits - PDA/DA to assist in providing reports for review. Essentials 7. Post OE Client/Broker TBD #VALUE!Review and remove over age dependents reaching max age before enroll plan year Essentials 7. Post OE TBD #VALUE!Review and update pending benefits that can be approved at this time Essentials 7. Post OE TBD #VALUE!Send Open Enrollment files and provide confirmation to client Essentials 7. Post OE SmartBen DA #VALUE! #VALUE!Manually update carriers on any OE changes that occur after the file has been sent - including terminations. Essentials 7. Post OE Client/Broker #VALUE! #VALUE!

Packet Pg. 33

Kane CountyJune HSC Meeting

06.10.20

Presented by: Group Alternatives

Packet Pg. 34

Agenda

2

GROUP ALTERNATIVES AND ASSURED PARTNERS

FINANCIAL TRACKER DATA ANALYTICS WELLNESS COMMUNICATION

Packet Pg. 35

Group Alternatives is part of AssuredPartners, bringing national solutions to the market. AssuredPartners is the fastest growing

independent insurance agency in the US. This Partnership gives the ability to have a national presence and provides us with the tools,

relationships and resources reserved only for the best of the best nationally.

LARGEST P&C BROKER IN THE US

5th 10thLARGEST BROKER

IN THE US

40STATES, 150 CITIES,

2 COUNTRIES

200+PHYSICAL OFFICE

LOCATIONS

6,000 400,000DEDICATED

PROFESSIONALS ON STAFFHAPPY CLIENTS AND

COUNTING!

Local Service: Global Resources

3Packet Pg. 36

Claims & Funding

4 Packet Pg. 37

2019-20 Global Financial Tracker

5

*All Other includes Interactive Health Service, Group Alternatives fee, dental, vision, life and EAP services

*All Other July 2019 includes a 90,000 Transition Credit from BCBSIL

**BCBSIL experienced system issues for ASO HMO resulting in January capitation not being included in January's billing. January's HMO Capitation was included in March's billing.

***Medical Runout not included in claims: July '19 is 299,789 and August '19 is 95,383.

98,458 99,137 98,481 99,560 99,292 100,022 100,230 99,671 99,775 99,104

208,702

563,298 595,388

752,138

920,277

1,116,041

803,207

641,946532,624

402,452

102,138

238,088247,614

274,493

313,907

307,734

350,441

308,588

375,981

290,159

216,579

217,930213,389

216,047

218,171

220,807

0

213,041

454,235

223,071

76,85376,092

76,199

76,544

76,398

76,353 76,064

79,177

77,372

613,154

1,195,306 1,230,964

1,418,437

1,628,191

1,821,002

1,330,231 1,339,310

1,541,792

1,092,158

1,391,406 1,397,672

1,384,822 1,405,930 1,403,148 1,403,712

1,405,891 1,397,383

1,398,496 1,392,689

0

100,000

200,000

300,000

400,000

500,000

600,000

700,000

800,000

900,000

1,000,000

1,100,000

1,200,000

1,300,000

1,400,000

1,500,000

1,600,000

1,700,000

1,800,000

1,900,000

Jul-19 Aug-19 Sep-19 Oct-19 Nov-19 Dec-19 Jan-20 Feb-20 Mar-20 Apr-20 May-20 Jun-20

Jul-19 Aug-19 Sep-19 Oct-19 Nov-19 Dec-19 Jan-20 Feb-20 Mar-20 Apr-20 May-20 Jun-20

All Other* -12,723 76,853 76,092 76,199 76,544 76,398 76,353 76,064 79,177 77,372

Capitation** 216,579 217,930 213,389 216,047 218,171 220,807 0 213,041 454,235 223,071

Rx Claims 102,138 238,088 247,614 274,493 313,907 307,734 350,441 308,588 375,981 290,159

Medical Claims after SL Reimbursements*** 208,702 563,298 595,388 752,138 920,277 1,116,041 803,207 641,946 532,624 402,452

Medical/Rx Fixed Cost 98,458 99,137 98,481 99,560 99,292 100,022 100,230 99,671 99,775 99,104

Total Cost 613,154 1,195,306 1,230,964 1,418,437 1,628,191 1,821,002 1,330,231 1,339,310 1,541,792 1,092,158

Total Funding 1,391,406 1,397,672 1,384,822 1,405,930 1,403,148 1,403,712 1,405,891 1,397,383 1,398,496 1,392,689

Total Funding Towards Reserve 778,252 202,366 153,859 (12,507) (225,043) (417,290) 75,660 58,073 (143,297) 300,532

Global Financial TrackerAmount Toward Reserve(7.1.2019 - 4.30.2020):

$770,604

Packet Pg. 38

Year Over Year

2018-19 IPBC2019-20 IPBC

Renewal2019-20 BCBSIL

Direct YTD

Avg. Employee Headcount*

993 993 993

Average per Month Fixed Cost + Medical/Rx Claims

$1,308,252 $1,348,380 $1,252,222

Average PEPM $1,317 $1,358 $1,261

*Headcounts are based on current average.

6Packet Pg. 39

7

Data Analytics

7Packet Pg. 40

Wellness Communication

8

This article is for informational purposes only and is not intended as medical advice. For further information, please consult a medical professional. © 2008, 2010-2011, 2014, 2017-2018 Zywave, Inc. All rights reserved.

Health and wellness tips for your work, home and life—brought to you by the insurance professionals at

AssuredPartners

FOLLOWING THE DOCTOR’S ORDERS

Following a physician’s instructions is known as medical

adherence. A surprising number of patients do not

follow their doctors’ orders, which can be very risky for

their health.

Not following orders can include not filling a

prescription, not taking medication as directed, not

attending or scheduling a follow-up appointment and

failing to make a lifestyle change as directed.

Given that many diseases are curable, preventable or

treatable, following your doctor’s orders is vital for

achieving and maintaining good health. Your doctor’s

diagnosis and treatment plan are useless if you do not

follow his or her advice.

Patients who do not follow their doctors’ orders,

especially patients with chronic conditions, may

experience health complications, rapid disease

progression, decreased quality of life and even

premature death.

Tips for Patients

The following tips will help you take a proactive role in

your health:

• Gather basic information from your doctor

about any conditions you suffer from and the

potential treatment options. The more you

know, the more likely you will take action.

• Seek clarification right away for anything that

you do not understand.

• Ask family and friends to assist you in

following the orders that your doctor has

outlined for you.

• Create health care goals for yourself and

incorporate treatment and taking medication

into your plans for achieving those goals.

• Talk with your doctor about potential barriers

that prevent you from following his or her

orders, and come up with solutions to

overcome those barriers.

• Tailor your medical routine to your daily

routine and lifestyle. This could be as simple as

using specialized pill containers for your

medications and placing them next to your

toothbrush.

• Ask your pharmacist to send refill reminders

via email, text or telephone.

• Create reminders for yourself to avoid

forgetting to take medication, to get your daily

exercise or to check your insulin levels.

Packet Pg. 41

AgendaReport: FinanceReport: VeteransReport: Insurance BillingReport: BCBS/MERPReport: TermsReport: ApplicantsReport: New HiresReport: WCReport: TrainingReport: Ben AdminPresentation: Group Alternatives