Appendix_A.pdf

PDF 135 KB Posted

Attached to
Insurance Broker Services 2024
Solicitation number
23-0864-RFP
Issued by
Pinellas County, Florida

About this file

The document is a comprehensive claims summary report for Pinellas County Board of County Commissioners (BOCC) prepared by Johns Eastern Company, Inc., covering insurance claims data from August 1, 2018, to August 1, 2023. The report provides a detailed breakdown of claims across multiple coverage types including Auto Liability, Auto Physical Damage, Employment Practice Liability, General Liability, Public Official Liability, Property, and Incident categories, segmented by fiscal years from 2017-2018 through 2022-2023.

The report reveals a total of 4,329 claims with an overall incurred total of $16,522,850.78, of which $12,295,428.38 has been paid to date, leaving $4,227,422.40 in reserve. Medical claims constitute the largest portion at $11,948,436.44, followed by indemnity claims at $3,442,082.13. The claims are categorized into different coverage types, with the majority being medical-only and indemnity claims. The data shows variations in claim volumes and total incurred amounts across different fiscal years, with the highest incurred total of $4,563,542.49 in the 2018-2019 fiscal year. The report also tracks recoveries, which totaled $88,226.60 across the five-year period.

View the file

Other files

File Type Posted
Insurance_Broker_Services_2024_(Addendum_#2_Revision).pdf PDF
Appendix_B_(1).pdf PDF

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

5 Complete Years - 8/1/18 - 8/1/23

Claim Count - 5 Years

Pinellas County Government

Report Name: All Departments & Appoint Claim Summary FY22

Report Name:

Averill, LauraRun By:Template Name: Claim Summary

Claim Summary Created By: Averill, LauraReport Category:

Reset Page NumberPage BreakGroup TotalSort OrderGroupField

Sort Criteria:

NoNoYesAscYesPeriod1) NoNoYesAscYes2) Coverage

NoNoYesAscNo3) Status

Other Info:

Incurred Formula: Paid Total

Prior Valuation: 8/1/2023

By Occurrence: No

Include Incidents: Yes

Period Type: Fiscal Year

Include Voided Claims: No

STARS Client: Pinellas County Government

(Loss Date [Claim, LossDate] is between Wednesday, August 1, 2018 and Tuesday, August 1, 2023 and Major Coverage

[Coverage, MajorCoverageCode] includes any General Liability, Public Official Liability, Vehicle Accidents, Incident, Property )

Selection Criteria:

9:57:09AM

8/1/2023

Pinellas County Government

5 Complete Years - 8/1/18 - 8/1/23

Paid Total

Coverage Incurred Total Paid Total O/S Reserve TotalClaim Count Average

Incurred Loss

Largest

Incurred Loss

Valued as of: 8/1/2023

Period: 10/ 1/2017 - 9/30/2018 (10/1/2017 - 9/30/2018)

AL - Auto Liability 1,475.77 1,475.77 1 1,475.77 1,475.77 0.00

APD - Auto Physical Damage 39,628.73 39,628.73 21 21,078.29 1,887.08 0.00

EPL - Employment Practice Liability 0.00 0.00 2 0.00 0.00 0.00

GL - General Liability 166,329.72 166,329.72 79 53,732.67 2,105.44 0.00

PR - Property 30,958.86 30,958.86 44 4,452.37 703.61 0.00

Total by Period 238,393.08 238,393.08 53,732.67 1,621.72 0.00 147

Period: 10/ 1/2018 - 9/30/2019 (10/1/2018 - 9/30/2019)

AL - Auto Liability 371,857.54 350,857.54 33 120,651.56 11,268.41 21,000.00

APD - Auto Physical Damage 200,685.37 200,685.37 146 14,481.01 1,374.56 0.00

EPL - Employment Practice Liability 7,483.65 7,483.65 3 7,483.65 2,494.55 0.00

GL - General Liability 896,997.39 859,630.77 467 147,380.33 1,920.77 37,366.62

PO - Public Official Liability 0.00 0.00 2 0.00 0.00 0.00

PR - Property 734,046.72 734,046.72 190 466,133.24 3,863.40 0.00

Total by Period 2,152,704.05 2,211,070.67 466,133.24 2,629.10 58,366.62 841

Period: 10/ 1/2019 - 9/30/2020 (10/1/2019 - 9/30/2020)

AL - Auto Liability 78,534.73 78,534.73 24 28,025.00 3,272.28 0.00

APD - Auto Physical Damage 119,865.95 119,865.95 166 11,258.07 722.08 0.00

EPL - Employment Practice Liability 25,000.00 25,000.00 6 25,000.00 4,166.67 0.00

GL - General Liability 686,620.56 583,172.91 342 103,082.15 2,007.66 103,447.65

PR - Property 517,972.34 517,972.34 174 76,602.88 2,976.85 0.00

Total by Period 1,324,545.93 1,427,993.58 103,082.15 2,005.61 103,447.65 712

Period: 10/ 1/2020 - 9/30/2021 (10/1/2020 - 9/30/2021)

AL - Auto Liability 110,477.12 110,477.12 28 35,607.10 3,945.61 0.00

APD - Auto Physical Damage 120,801.70 120,801.70 149 8,819.18 810.75 0.00

EPL - Employment Practice Liability 8,818.00 7,818.00 6 6,831.00 1,469.67 1,000.00

GL - General Liability 502,659.26 371,546.26 386 201,050.00 1,302.23 131,113.00

PR - Property 722,959.25 720,548.68 208 74,262.35 3,475.77 2,410.57

Total by Period 1,331,191.76 1,465,715.33 201,050.00 1,886.38 134,523.57 777

Period: 10/ 1/2021 - 9/30/2022 (10/1/2021 - 9/30/2022)

AL - Auto Liability 121,093.09 74,146.03 37 17,427.01 3,272.79 46,947.06

APD - Auto Physical Damage 88,396.01 87,312.64 109 17,167.67 810.97 1,083.37

GL - General Liability 309,764.24 262,871.61 505 94,405.04 613.39 46,892.63

IN - Incident 0.00 0.00 76 0.00 0.00 0.00

-2- 8/1/2023

9:57:01AM

Pinellas County Government

5 Complete Years - 8/1/18 - 8/1/23

Paid Total

Coverage Incurred Total Paid Total O/S Reserve TotalClaim Count Average

Incurred Loss

Largest

Incurred Loss

Valued as of: 8/1/2023

Period: 10/ 1/2021 - 9/30/2022 (10/1/2021 - 9/30/2022)

PR - Property 533,788.82 342,528.39 303 60,455.03 1,761.68 191,260.43

Total by Period 766,858.67 1,053,042.16 94,405.04 1,022.37 286,183.49 1,030

Period: 10/ 1/2022 - 9/30/2023 (10/1/2022 - 9/30/2023)

AL - Auto Liability 66,564.32 44,964.32 26 24,935.50 2,560.17 21,600.00

APD - Auto Physical Damage 56,182.27 38,592.24 39 18,591.48 1,440.57 17,590.03

GL - General Liability 104,192.06 76,915.67 454 23,365.56 229.50 27,276.39

IN - Incident 0.00 0.00 42 0.00 0.00 0.00

PR - Property 215,803.59 139,789.65 261 21,204.38 826.83 76,013.94

Total by Period 300,261.88 442,742.24 24,935.50 538.62 142,480.36 822

4,329 6,838,957.06 6,113,955.37 725,001.69 466,133.24 1,579.80Grand Totals:

-3- 8/1/2023

9:57:01AM

Filter: LOB in (General Liability, Property, Vehicle/Auto, Workers Compensation) and Loss Date is between '08/01/2018' and

'08/01/2023' and Client = 'Pinellas County BOCC' and Policy Set = Y

Loss Run by Claim Summary

Report Criteria:

Pinellas County BOCC

Run Date: 08/03/2023 11:46 AM

Valuation :08/01/2023

Begin Period Date: 8/1/2018 Financials As Of 8/1/2023

Johns Eastern Company, Inc.

Group 1: Claim Year / Policy Dates: Claim Year 2017 10/01/17 - 09/30/2018

Group 2: Party Current Coverage Type: Indemnity

Group 2: Indemnity Totals IncurredReserve BalanceReserve Type: All Paid to DateOpen PTDClosed PTD

Expense: $28,696.90 $30,975.09$2,278.19$22,975.09 $5,721.81

Indemn: $33,925.46 $33,925.46$0.00$23,893.20 $10,032.26

Medical: $215,943.39$208,280.85 $7,662.54$175,943.39 $32,337.46

Total: $280,843.94$9,940.73$270,903.21$222,811.68 $48,091.53

1 6 7 Total Claims:in Closed:in Open:Claim 7 6

Group 2: Party Current Coverage Type: Medical Only

Group 2: Medical Only Totals IncurredReserve BalanceReserve Type: All Paid to DateOpen PTDClosed PTD

Expense: $9,558.39 $9,565.34$6.95$9,558.39 $0.00

Medical: $137,352.43$137,352.43 $0.00$137,352.43 $0.00

Total: $146,917.77$6.95$146,910.82$146,910.82 $0.00

$142,000.12 $142,007.07

RECOVERIES: SUB: $4,910.70 Recoveries:

Net w/Recvoeries:

$4,910.70$4,910.70

0 79 79 Total Claims:in Closed:in Open:Claim 79 79

Group 2: Party Current Coverage Type: Report Only

Group 2: Report Only Totals IncurredReserve BalanceReserve Type: All Paid to DateOpen PTDClosed PTD

Total: $0.00$0.00$0.00$0.00 $0.00

0 57 57 Total Claims:in Closed:in Open:Claim 57 57

Group 1: Claim Year 2017 10/01/17 - 09/30/2018 Totals IncurredReserve BalanceReserve Type: All Paid to DateOpen PTDClosed PTD

Expense: $38,255.29 $40,540.43$2,285.14$32,533.48 $5,721.81

Indemn: $33,925.46 $33,925.46$0.00$23,893.20 $10,032.26

Medical: $345,633.28 $353,295.82$7,662.54$313,295.82 $32,337.46

Total: $427,761.71$9,947.68$417,814.03$48,091.53$369,722.50

$412,903.33 $422,851.01

SUB:RECOVERIES: $4,910.70

Net w/Recvoeries:

Recoveries: $4,910.70 $4,910.70

1 142 143 Total Claims:in Closed:in Open:Claim 143 142

Left Margin "IN PERIOD ACTIVITY" INDICATORS: "$" Payments. "&" Reserves. "+" Opened. "*"Closed. "^" Reopened.

Appendix A

Filter: LOB in (General Liability, Property, Vehicle/Auto, Workers Compensation) and Loss Date is between '08/01/2018' and

'08/01/2023' and Client = 'Pinellas County BOCC' and Policy Set = Y

Loss Run by Claim Summary

Report Criteria:

Pinellas County BOCC

Run Date: 08/03/2023 11:46 AM

Valuation :08/01/2023

Begin Period Date: 8/1/2018 Financials As Of 8/1/2023

Johns Eastern Company, Inc.

Group 1: Claim Year / Policy Dates: Claim Year 2018 10/01/18 - 09/30/2019

Group 2: Party Current Coverage Type: Indemnity

Group 2: Indemnity Totals IncurredReserve BalanceReserve Type: All Paid to DateOpen PTDClosed PTD

Expense: $150,579.63 $192,912.12$42,332.49$47,412.12 $103,167.51

Indemn: $933,033.98 $1,457,384.36$524,350.38$439,381.36 $493,652.62

Medical: $2,266,368.24$1,721,209.71 $545,158.53$985,357.94 $735,851.77

Total: $3,916,664.72$1,111,841.40$2,804,823.32$1,472,151.42 $1,332,671.90

$2,788,405.32 $3,900,246.72

RECOVERIES: SUB: $16,418.00 Recoveries:

Net w/Recvoeries:

$16,418.00$16,418.00

11 55 66 Total Claims:in Closed:in Open:Claim 66 55

Group 2: Party Current Coverage Type: Medical Only

Group 2: Medical Only Totals IncurredReserve BalanceReserve Type: All Paid to DateOpen PTDClosed PTD

Expense: $35,083.29 $35,445.05$361.76$33,445.05 $1,638.24

Medical: $611,432.72$589,627.05 $21,805.67$581,432.72 $8,194.33

Total: $646,877.77$22,167.43$624,710.34$614,877.77 $9,832.57

$598,596.66 $620,764.09

RECOVERIES: SUB: $26,113.68 Recoveries:

Net w/Recvoeries:

$26,113.68$26,113.68

1 393 394 Total Claims:in Closed:in Open:Claim 394 393

Group 2: Party Current Coverage Type: Report Only

Group 2: Report Only Totals IncurredReserve BalanceReserve Type: All Paid to DateOpen PTDClosed PTD

Total: $0.00$0.00$0.00$0.00 $0.00

0 332 332 Total Claims:in Closed:in Open:Claim 332 332

Group 1: Claim Year 2018 10/01/18 - 09/30/2019 Totals IncurredReserve BalanceReserve Type: All Paid to DateOpen PTDClosed PTD

Expense: $185,662.92 $228,357.17$42,694.25$80,857.17 $104,805.75

Indemn: $933,033.98 $1,457,384.36$524,350.38$439,381.36 $493,652.62

Medical: $2,310,836.76 $2,877,800.96$566,964.20$1,566,790.66 $744,046.10

Total: $4,563,542.49$1,134,008.83$3,429,533.66$1,342,504.47$2,087,029.19

$3,387,001.98 $4,521,010.81

SUB:RECOVERIES: $42,531.68

Net w/Recvoeries:

Recoveries: $42,531.68 $42,531.68

12 780 792 Total Claims:in Closed:in Open:Claim 792 780

Left Margin "IN PERIOD ACTIVITY" INDICATORS: "$" Payments. "&" Reserves. "+" Opened. "*"Closed. "^" Reopened.

Filter: LOB in (General Liability, Property, Vehicle/Auto, Workers Compensation) and Loss Date is between '08/01/2018' and

'08/01/2023' and Client = 'Pinellas County BOCC' and Policy Set = Y

Loss Run by Claim Summary

Report Criteria:

Pinellas County BOCC

Run Date: 08/03/2023 11:46 AM

Valuation :08/01/2023

Begin Period Date: 8/1/2018 Financials As Of 8/1/2023

Johns Eastern Company, Inc.

Group 1: Claim Year / Policy Dates: Claim Year 2019 10/01/19 - 09/30/2020

Group 2: Party Current Coverage Type: Indemnity

Group 2: Indemnity Totals IncurredReserve BalanceReserve Type: All Paid to DateOpen PTDClosed PTD

Expense: $110,733.11 $122,621.22$11,888.11$67,421.32 $43,311.79

Indemn: $315,069.92 $380,210.46$65,140.54$139,210.46 $175,859.46

Medical: $1,637,498.36$1,446,105.93 $191,392.43$1,037,998.36 $408,107.57

Total: $2,140,330.04$268,421.08$1,871,908.96$1,244,630.14 $627,278.82

$1,853,408.96 $2,121,830.04

RECOVERIES: SUB: $18,500.00 Recoveries:

Net w/Recvoeries:

$18,500.00$18,500.00

4 142 146 Total Claims:in Closed:in Open:Claim 146 142

Group 2: Party Current Coverage Type: Medical Only

Group 2: Medical Only Totals IncurredReserve BalanceReserve Type: All Paid to DateOpen PTDClosed PTD

Expense: $48,528.99 $54,480.69$5,951.70$42,730.69 $5,798.30

Medical: $850,304.46$791,609.58 $58,694.88$750,304.46 $41,305.12

Total: $904,785.15$64,646.58$840,138.57$793,035.15 $47,103.42

$828,569.03 $893,215.61

RECOVERIES: SUB: $11,569.54 Recoveries:

Net w/Recvoeries:

$11,569.54$11,569.54

3 306 309 Total Claims:in Closed:in Open:Claim 309 306

Group 2: Party Current Coverage Type: Report Only

Group 2: Report Only Totals IncurredReserve BalanceReserve Type: All Paid to DateOpen PTDClosed PTD

Total: $0.00$0.00$0.00$0.00 $0.00

0 336 336 Total Claims:in Closed:in Open:Claim 336 336

Group 1: Claim Year 2019 10/01/19 - 09/30/2020 Totals IncurredReserve BalanceReserve Type: All Paid to DateOpen PTDClosed PTD

Expense: $159,262.10 $177,101.91$17,839.81$110,152.01 $49,110.09

Indemn: $315,069.92 $380,210.46$65,140.54$139,210.46 $175,859.46

Medical: $2,237,715.51 $2,487,802.82$250,087.31$1,788,302.82 $449,412.69

Total: $3,045,115.19$333,067.66$2,712,047.53$674,382.24$2,037,665.29

$2,681,977.99 $3,015,045.65

SUB:RECOVERIES: $30,069.54

Net w/Recvoeries:

Recoveries: $30,069.54 $30,069.54

7 784 791 Total Claims:in Closed:in Open:Claim 791 784

Left Margin "IN PERIOD ACTIVITY" INDICATORS: "$" Payments. "&" Reserves. "+" Opened. "*"Closed. "^" Reopened.

Filter: LOB in (General Liability, Property, Vehicle/Auto, Workers Compensation) and Loss Date is between '08/01/2018' and

'08/01/2023' and Client = 'Pinellas County BOCC' and Policy Set = Y

Loss Run by Claim Summary

Report Criteria:

Pinellas County BOCC

Run Date: 08/03/2023 11:46 AM

Valuation :08/01/2023

Begin Period Date: 8/1/2018 Financials As Of 8/1/2023

Johns Eastern Company, Inc.

Group 1: Claim Year / Policy Dates: Claim Year 2020 10/01/20 - 09/30/2021

Group 2: Party Current Coverage Type: Indemnity

Group 2: Indemnity Totals IncurredReserve BalanceReserve Type: All Paid to DateOpen PTDClosed PTD

Expense: $131,326.15 $164,429.12$33,102.97$73,260.66 $58,065.49

Indemn: $569,970.03 $704,230.91$134,260.88$226,642.37 $343,327.66

Medical: $2,311,470.67$1,316,477.16 $994,993.51$769,317.04 $547,160.12

Total: $3,180,130.70$1,162,357.36$2,017,773.34$1,069,220.07 $948,553.27

$2,011,706.78 $3,174,064.14

RECOVERIES: SUB: $6,066.56 Recoveries:

Net w/Recvoeries:

$6,066.56$6,066.56

10 147 157 Total Claims:in Closed:in Open:Claim 157 147

Group 2: Party Current Coverage Type: Medical Only

Group 2: Medical Only Totals IncurredReserve BalanceReserve Type: All Paid to DateOpen PTDClosed PTD

Expense: $40,298.17 $48,417.35$8,119.18$37,948.01 $2,350.16

Medical: $403,845.91$384,016.45 $19,829.46$350,922.94 $33,093.51

Total: $452,263.26$27,948.64$424,314.62$388,870.95 $35,443.67

$421,666.50 $449,615.14

RECOVERIES: SUB: $2,648.12 Recoveries:

Net w/Recvoeries:

$2,648.12$2,648.12

5 324 329 Total Claims:in Closed:in Open:Claim 329 324

Group 2: Party Current Coverage Type: Report Only

Group 2: Report Only Totals IncurredReserve BalanceReserve Type: All Paid to DateOpen PTDClosed PTD

Total: $0.00$0.00$0.00$0.00 $0.00

0 354 354 Total Claims:in Closed:in Open:Claim 354 354

Group 1: Claim Year 2020 10/01/20 - 09/30/2021 Totals IncurredReserve BalanceReserve Type: All Paid to DateOpen PTDClosed PTD

Expense: $171,624.32 $212,846.47$41,222.15$111,208.67 $60,415.65

Indemn: $569,970.03 $704,230.91$134,260.88$226,642.37 $343,327.66

Medical: $1,700,493.61 $2,715,316.58$1,014,822.97$1,120,239.98 $580,253.63

Total: $3,632,393.96$1,190,306.00$2,442,087.96$983,996.94$1,458,091.02

$2,433,373.28 $3,623,679.28

SUB:RECOVERIES: $8,714.68

Net w/Recvoeries:

Recoveries: $8,714.68 $8,714.68

15 825 840 Total Claims:in Closed:in Open:Claim 840 825

Left Margin "IN PERIOD ACTIVITY" INDICATORS: "$" Payments. "&" Reserves. "+" Opened. "*"Closed. "^" Reopened.

Filter: LOB in (General Liability, Property, Vehicle/Auto, Workers Compensation) and Loss Date is between '08/01/2018' and

'08/01/2023' and Client = 'Pinellas County BOCC' and Policy Set = Y

Loss Run by Claim Summary

Report Criteria:

Pinellas County BOCC

Run Date: 08/03/2023 11:46 AM

Valuation :08/01/2023

Begin Period Date: 8/1/2018 Financials As Of 8/1/2023

Johns Eastern Company, Inc.

Group 1: Claim Year / Policy Dates: Claim Year 2021 10/01/21 - 09/30/2022

Group 2: Party Current Coverage Type: Indemnity

Group 2: Indemnity Totals IncurredReserve BalanceReserve Type: All Paid to DateOpen PTDClosed PTD

Expense: $173,644.01 $273,699.02$100,055.01$55,338.44 $118,305.57

Indemn: $364,127.37 $618,068.89$253,941.52$134,868.89 $229,258.48

Medical: $1,844,828.16$1,325,607.73 $519,220.43$490,708.05 $834,899.68

Total: $2,736,596.07$873,216.96$1,863,379.11$680,915.38 $1,182,463.73

$1,863,129.11 $2,736,346.07

RECOVERIES: SUB: $250.00 Recoveries:

Net w/Recvoeries:

$250.00$250.00

16 58 74 Total Claims:in Closed:in Open:Claim 74 58

Group 2: Party Current Coverage Type: Medical Only

Group 2: Medical Only Totals IncurredReserve BalanceReserve Type: All Paid to DateOpen PTDClosed PTD

Expense: $45,119.39 $50,534.06$5,414.67$41,534.19 $3,585.20

Medical: $406,062.86$378,102.14 $27,960.72$327,212.86 $50,889.28

Total: $456,596.92$33,375.39$423,221.53$368,747.05 $54,474.48

$421,471.53 $454,846.92

RECOVERIES: SUB: $1,750.00 Recoveries:

Net w/Recvoeries:

$1,750.00$1,750.00

7 260 267 Total Claims:in Closed:in Open:Claim 267 260

Group 2: Party Current Coverage Type: Report Only

Group 2: Report Only Totals IncurredReserve BalanceReserve Type: All Paid to DateOpen PTDClosed PTD

Expense: $9.45 $18.90$9.45$9.45 $0.00

Total: $18.90$9.45$9.45$9.45 $0.00

0 390 390 Total Claims:in Closed:in Open:Claim 390 390

Group 1: Claim Year 2021 10/01/21 - 09/30/2022 Totals IncurredReserve BalanceReserve Type: All Paid to DateOpen PTDClosed PTD

Expense: $218,772.85 $324,251.98$105,479.13$96,882.08 $121,890.77

Indemn: $364,127.37 $618,068.89$253,941.52$134,868.89 $229,258.48

Medical: $1,703,709.87 $2,250,891.02$547,181.15$817,920.91 $885,788.96

Total: $3,193,211.89$906,601.80$2,286,610.09$1,236,938.21$1,049,671.88

$2,284,610.09 $3,191,211.89

SUB:RECOVERIES: $2,000.00

Net w/Recvoeries:

Recoveries: $2,000.00 $2,000.00

23 708 731 Total Claims:in Closed:in Open:Claim 731 708

Left Margin "IN PERIOD ACTIVITY" INDICATORS: "$" Payments. "&" Reserves. "+" Opened. "*"Closed. "^" Reopened.

Filter: LOB in (General Liability, Property, Vehicle/Auto, Workers Compensation) and Loss Date is between '08/01/2018' and

'08/01/2023' and Client = 'Pinellas County BOCC' and Policy Set = Y

Loss Run by Claim Summary

Report Criteria:

Pinellas County BOCC

Run Date: 08/03/2023 11:46 AM

Valuation :08/01/2023

Begin Period Date: 8/1/2018 Financials As Of 8/1/2023

Johns Eastern Company, Inc.

Group 1: Claim Year / Policy Dates: Claim Year 2022 10/01/22 - 09/30/2023

Group 2: Party Current Coverage Type: Indemnity

Group 2: Indemnity Totals IncurredReserve BalanceReserve Type: All Paid to DateOpen PTDClosed PTD

Expense: $24,754.46 $81,543.24$56,788.78$12,228.24 $12,526.22

Indemn: $151,198.06 $248,262.05$97,063.99$27,162.05 $124,036.01

Medical: $781,384.94$508,281.70 $273,103.24$99,446.96 $408,834.74

Total: $1,111,190.23$426,956.01$684,234.22$138,837.25 $545,396.97

22 21 43 Total Claims:in Closed:in Open:Claim 43 21

Group 2: Party Current Coverage Type: Medical Only

Group 2: Medical Only Totals IncurredReserve BalanceReserve Type: All Paid to DateOpen PTDClosed PTD

Expense: $27,007.59 $67,691.01$40,683.42$19,136.51 $7,871.08

Medical: $481,944.30$296,093.30 $185,851.00$197,494.30 $98,599.00

Total: $549,635.31$226,534.42$323,100.89$216,630.81 $106,470.08

50 166 216 Total Claims:in Closed:in Open:Claim 216 166

Group 2: Party Current Coverage Type: Report Only

Group 2: Report Only Totals IncurredReserve BalanceReserve Type: All Paid to DateOpen PTDClosed PTD

Total: $0.00$0.00$0.00$0.00 $0.00

0 218 218 Total Claims:in Closed:in Open:Claim 218 218

Group 1: Claim Year 2022 10/01/22 - 09/30/2023 Totals IncurredReserve BalanceReserve Type: All Paid to DateOpen PTDClosed PTD

Expense: $51,762.05 $149,234.25$97,472.20$31,364.75 $20,397.30

Indemn: $151,198.06 $248,262.05$97,063.99$27,162.05 $124,036.01

Medical: $804,375.00 $1,263,329.24$458,954.24$296,941.26 $507,433.74

Total: $1,660,825.54$653,490.43$1,007,335.11$651,867.05$355,468.06

72 405 477 Total Claims:in Closed:in Open:Claim 477 405

Left Margin "IN PERIOD ACTIVITY" INDICATORS: "$" Payments. "&" Reserves. "+" Opened. "*"Closed. "^" Reopened.

Filter: LOB in (General Liability, Property, Vehicle/Auto, Workers Compensation) and Loss Date is between '08/01/2018' and

'08/01/2023' and Client = 'Pinellas County BOCC' and Policy Set = Y

Loss Run by Claim Summary

Report Criteria:

Pinellas County BOCC

Run Date: 08/03/2023 11:46 AM

Valuation :08/01/2023

Begin Period Date: 8/1/2018 Financials As Of 8/1/2023

Johns Eastern Company, Inc.

Grand Totals IncurredReserve BalanceAll Paid to DateOpen PTDReserve Type: Closed PTD

$1,132,332.21Expense: $825,339.53 $306,992.68$462,998.16 $362,341.37

Indemn: $2,367,324.82 $3,442,082.13$1,074,757.31$991,158.33 $1,376,166.49

$9,102,764.03 $11,948,436.44Medical: $2,845,672.41$5,903,491.45 $3,199,272.58

$16,522,850.78$12,295,428.38 $4,227,422.40Total: $7,357,647.94 $4,937,780.44

$12,207,201.78 $16,434,624.18

RECOVERIES: SUB: $88,226.60 $88,226.60 $88,226.60

Net w/Recvoeries:

Recoveries:

Total Claims: 3,774 Claim Open: Closed: 130 3,644 in in 3,774 3,644

Left Margin "IN PERIOD ACTIVITY" INDICATORS: "$" Payments. "&" Reserves. "+" Opened. "*"Closed. "^" Reopened.

Appendix A
Work_Comp_Claims_08-01-18_to_08-01-23

File details come from the government source that posted it. Updated .