Attachment_3_-_PWS_Exhibit_3_-_Claims_History_(Revised).xlsx
XLSX spreadsheet 14 KB Posted
- Attached to
- Dental Insurance Program
- Solicitation number
- CC14HQR0010
About this file
Attachment 5 - RFP Attachment 3 - Claims History (revised)
View the file
Other files
Show all 19
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
Sheet1
| 5-YEAR CLAIMS HISTORY | ||||
| Year - 2010 | Active Ees | Disabled Retirees | Non-Disabled Retirees | Grand Total |
| In-Network | $1,050,618.00 | $19,957.00 | $99,723.00 | $1,170,298.00 |
| Out of Network | $1,759,892.00 | $30,223.00 | $325,234.00 | $2,115,349.00 |
| Total Claims | $2,810,510.00 | $50,180.00 | $424,957.00 | $3,285,647.00 |
| Billed Premium | $3,568,682.00 | $83,214.00 | $403,123.00 | $4,055,019.00 |
| Loss Ratio | 79% | 60% | 105% | 81% |
| Headcount as of Dec. 31 | 2841 | 68 | 424 | 3333 |
| Year - 2011 | Active Ees | Disabled Retirees | Non-Disabled Retirees | Grand Total |
| In-Network | $1,091,826.00 | $20,174.00 | $110,234.00 | $1,222,234.00 |
| Out of Network | $1,773,982.00 | $34,875.00 | $349,864.00 | $2,158,721.00 |
| Total Claims | $2,865,808.00 | $55,049.00 | $460,098.00 | $3,380,955.00 |
| Billed Premium | $3,583,005.00 | $86,723.00 | $425,790.00 | $4,095,518.00 |
| Loss Ratio | 80% | 63% | 108% | 83% |
| Headcount as of Dec. 31 | 2843 | 71 | 466 | 3380 |
| Year - 2012 | Active Ees | Disabled Retirees | Non-Disabled Retirees | Grand Total |
| In-Network | $1,177,172.00 | $19,503.00 | $135,042.00 | $1,331,717.00 |
| Out of Network | $1,873,405.00 | $31,160.00 | $358,172.00 | $2,262,737.00 |
| Total Claims | $3,050,577.00 | $50,663.00 | $493,214.00 | $3,594,454.00 |
| Billed Premium | $3,972,729.00 | $88,710.00 | $452,891.00 | $4,514,330.00 |
| Loss Ratio | 77% | 57% | 109% | 80% |
| Headcount as of Dec. 31 | 3588 | 75 | 465 | 4128 |
| Year - 2013 | Active Ees | Disabled Retirees | Non-Disabled Retirees | Grand Total |
| In-Network | $1,796,518.00 | $41,000.00 | $198,469.00 | $2,035,987.00 |
| Out of Network | $1,785,919.00 | $32,222.00 | $343,253.00 | $2,161,394.00 |
| Total Claims | $3,582,437.00 | $73,222.00 | $541,722.00 | $4,197,381.00 |
| Billed Premium | $4,726,462.00 | $89,486.00 | $478,160.00 | $5,294,108.00 |
| Loss Ratio | 76% | 82% | 113% | 79% |
| Headcount as of Dec. 31 | 3759 | 71 | 503 | 4333 |
| Year - 2014 (Jan - Mar) | Active Ees | Disabled Retirees | Non-Disabled Retirees | Grand Total |
| In-Network | $463,911.00 | $7,726.00 | $54,559.00 | $526,196.00 |
| Out of Network | $452,397.00 | $6,892.00 | $88,250.00 | $547,539.00 |
| Total Claims | $916,308.00 | $14,618.00 | $142,809.00 | $1,073,735.00 |
| Billed Premium | $1,273,203.00 | $23,265.00 | $131,796.00 | $1,428,264.00 |
| Loss Ratio | 72% | 63% | 108% | 75% |
| Headcount as of Mar. 31 | 3732 | 69 | 520 | 4321 |
Sheet2
Sheet3
File details come from the government source that posted it. Updated .