County of Santa Rosa of Public Instructions_Claims Premium with Expense_2020-2023.pdf
PDF 182 KB Posted
- Attached to
- Insurance Worksite Products
- Solicitation number
- RFP 23-06-WP
- Issued by
- Santa Rosa County, New Port Richey City, Florida
About this file
The document is a Claims Premium with Expense report from Davis Vision for the Santa Rosa Community School Board, covering vision insurance claims and expenses from 2020 to 2023. The report provides a detailed monthly breakdown of subscribers, members, number of claims, premiums billed, claims paid, administrative expenses, total expenses, and loss ratios for each year.
The data shows consistent fluctuations in the number of subscribers and members, with monthly claims ranging from 88 to 347 across the years. The loss ratio, which represents the total claims paid divided by premiums billed, varies significantly from month to month, ranging from a low of 55.96% (May 2020) to a high of 187.60% (August 2020). The annual totals indicate that the loss ratios have been relatively close to 100%, with 2021 at 106.00%, 2022 at 102.14%, and 2020 at 104.87%, suggesting that the premiums collected are generally in line with the claims paid out by Davis Vision for the Santa Rosa Community School Board.
View the file
Other files
Show all 18
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
Santa Rosa Community School Board
Year Month Subscribers Members # Claims Premiums
Billed
Claims Paid by Davis
Admin
Expense
Total
Expense
Loss
Ratio
2023 January 1,722 3,384 234 $17,456.57 $22,570.94 $1,920.22 $24,491.16 140.30%
2023 February 1,707 3,354 153 $18,919.89 $14,547.55 $2,081.19 $16,628.74 87.89%
2023 March 1,717 3,380 168 $17,978.98 $17,315.22 $1,977.69 $19,292.91 107.31%
2023 April - - - $0.00 $0.00 $0.00 $0.00
2023 May - - - $0.00 $0.00 $0.00 $0.00
2023 June - - - $0.00 $0.00 $0.00 $0.00
2023 July - - - $0.00 $0.00 $0.00 $0.00
2023 August - - - $0.00 $0.00 $0.00 $0.00
2023 September - - - $0.00 $0.00 $0.00 $0.00
2023 October - - - $0.00 $0.00 $0.00 $0.00
2023 November - - - $0.00 $0.00 $0.00 $0.00
2023 December - - - $0.00 $0.00 $0.00 $0.00 Total 1,715 3,373 555 $54,355.44 $54,433.71 $5,979.10 $60,412.81 111.14%
Year Month Subscribers Members # Claims Premiums
Billed
Claims Paid by Davis
Admin
Expense
Total
Expense
Loss
Ratio
2022 January 1,680 3,361 148 $17,452.61 $14,975.72 $1,919.79 $16,895.51 96.81%
2022 February 1,671 3,342 151 $17,253.34 $15,508.27 $1,897.87 $17,406.14 100.89%
2022 March 1,674 3,343 154 $17,139.13 $15,136.93 $1,885.30 $17,022.23 99.32%
2022 April 1,671 3,342 180 $17,320.62 $17,574.06 $1,905.27 $19,479.33 112.46%
2022 May 1,669 3,331 161 $16,991.80 $15,541.10 $1,869.10 $17,410.20 102.46%
2022 June 1,614 3,228 176 $16,819.16 $16,451.99 $1,850.11 $18,302.10 108.82%
2022 July 1,596 3,206 174 $16,358.55 $17,094.22 $1,799.44 $18,893.66 115.50%
2022 August 1,576 3,163 232 $16,459.48 $22,850.18 $1,810.54 $24,660.72 149.83%
2022 September 1,659 3,300 167 $15,908.07 $17,021.92 $1,749.89 $18,771.81 118.00%
2022 October 1,665 3,326 121 $18,052.20 $11,419.96 $1,985.74 $13,405.70 74.26%
2022 November 1,663 3,318 115 $17,162.55 $11,174.88 $1,887.88 $13,062.76 76.11%
2022 December 1,663 3,311 119 $17,125.13 $11,209.31 $1,883.76 $13,093.07 76.46% Total 1,650 3,298 1,898 $204,042.64 $185,958.53 $22,444.69 $208,403.22 102.14%
Year Month Subscribers Members # Claims Premiums
Billed
Claims Paid by Davis
Admin
Expense
Total
Expense
Loss
Ratio
2021 January 1,752 3,549 136 $18,440.55 $12,758.16 $2,028.46 $14,786.62 80.19%
2021 February 1,742 3,527 181 $17,774.96 $17,557.12 $1,955.25 $19,512.36 109.77%
2021 March 1,736 3,496 239 $18,124.03 $21,102.43 $1,993.64 $23,096.07 127.43%
2021 April 1,732 3,483 202 $17,948.53 $19,434.18 $1,974.34 $21,408.52 119.28%
2021 May 1,721 3,460 192 $18,100.40 $17,866.00 $1,991.04 $19,857.04 109.70%
2021 June 1,720 3,446 123 $17,797.64 $11,208.51 $1,957.74 $13,166.25 73.98%
2021 July 1,636 3,304 267 $17,149.03 $26,488.95 $1,886.39 $28,375.34 165.46%
2021 August 1,592 3,230 218 $16,947.30 $20,036.50 $1,864.20 $21,900.71 129.23%
2021 September 1,668 3,372 124 $16,388.80 $12,508.76 $1,802.77 $14,311.53 87.33%
2021 October 1,671 3,383 136 $18,072.27 $13,591.50 $1,987.95 $15,579.45 86.21%
2021 November 1,666 3,362 158 $17,461.14 $14,325.20 $1,920.73 $16,245.93 93.04%
Claims Premium with Expense
April 26, 2023
***CONFIDENTIAL & PROPRIETARY ***
Not for distribution outside of Davis Vision and client/broker/consultant relationship
Claims Premium with Expense
April 26, 2023 2021 December 1,663 3,352 147 $17,381.77 $14,134.72 $1,911.99 $16,046.71 92.32%
Total 1,692 3,414 2,123 $211,586.42 $201,012.02 $23,274.51 $224,286.53 106.00%
Claims Premium with Expense
April 26, 2023
Year Month Subscribers Members # Claims Premiums
Billed
Claims Paid by Davis
Admin
Expense
Total
Expense
Loss
Ratio
2020 January 1,762 3,544 254 $18,284.13 $24,167.29 $2,011.25 $26,178.54 143.18%
2020 February 1,762 3,535 183 $18,215.62 $19,140.66 $2,003.72 $21,144.37 116.08%
2020 March 1,765 3,537 139 $18,234.04 $12,997.52 $2,005.74 $15,003.26 82.28%
2020 April 1,757 3,528 190 $18,224.46 $15,993.11 $2,004.69 $17,997.80 98.76%
2020 May 1,759 3,530 88 $18,171.22 $8,168.88 $1,998.83 $10,167.72 55.96%
2020 June 1,753 3,515 124 $18,166.77 $13,816.48 $1,998.34 $15,814.82 87.05%
2020 July 1,692 3,415 217 $17,392.13 $21,918.71 $1,913.13 $23,831.85 137.03%
2020 August 1,675 3,382 347 $17,518.99 $30,938.44 $1,927.09 $32,865.52 187.60%
2020 September 1,650 3,335 128 $17,206.85 $11,263.79 $1,892.75 $13,156.54 76.46%
2020 October 1,702 3,424 172 $16,902.02 $15,668.06 $1,859.22 $17,527.28 103.70%
2020 November 1,702 3,432 145 $19,042.05 $12,827.20 $2,094.63 $14,921.82 78.36%
2020 December 1,698 3,420 160 $17,767.09 $15,039.11 $1,954.38 $16,993.48 95.65% Total 1,723 3,466 2,147 $215,125.37 $201,939.22 $23,663.79 $225,603.01 104.87%
File details come from the government source that posted it. Updated .