|
2013 - 2014 Renewal Calculation 1 1 J
<br />G -4 Page 226
<br />Employees
<br />FFS Medical
<br />Pharmacy
<br />Total Claims
<br />Stop -loss
<br />Credits
<br />Total Mature
<br />Claims
<br />J anuary-12
<br />957
<br />$427,257.00
<br />$132,246.00
<br />$570,937.00
<br />$23,375.00
<br />$428,514.83
<br />February -12
<br />951
<br />$594,745.00
<br />$125,732.00
<br />$732,349.00
<br />$18,429.00
<br />$713,654.00
<br />March -12
<br />950
<br />$751,150.00
<br />$118,569.00
<br />$880,898.00
<br />$34,854.00
<br />$845,935.00
<br />April -12
<br />951
<br />$651,071.00
<br />$126,401.00
<br />$789,262.00
<br />$86,088.00
<br />$703,174.00
<br />May -12
<br />951
<br />$927,553.72
<br />$116,779.50
<br />$1,056,123.22
<br />$48,805.00
<br />$1,007,318.22
<br />June-12
<br />936
<br />$898,047.00
<br />$131,728.00
<br />$1,041,205.00
<br />$224,473.00
<br />$816,732.00
<br />J uly-12
<br />940
<br />$575,316.28
<br />$102,601.76
<br />$677,918.04
<br />$172,822.00
<br />$482,699.54
<br />August -12
<br />933
<br />$659,171.00
<br />$96,350.00
<br />$755,690.00
<br />$113,143.00
<br />$642,547.00
<br />September -12
<br />927
<br />$493,686.00
<br />$88,777.00
<br />$582,512.00
<br />$1,511.00
<br />$581,001.00
<br />October -12
<br />932
<br />$477,837.00
<br />$105,185.00
<br />$584,819.00
<br />$4,084.00
<br />$580,373.00
<br />November -12
<br />927
<br />$529,727.00
<br />$85,061.00
<br />$614,987.00
<br />$16,833.00
<br />$598,154.00
<br />December -12
<br />924
<br />$390,240.00
<br />$83,208.00
<br />$473,646.00
<br />$26,184.00
<br />$447,462.00
<br />Total
<br />11,279
<br />$7,375,801.00
<br />$1,312,638.26
<br />$8,760,346.26
<br />$770,601.00
<br />$7,847,564.59
<br />2013 -2014 Renewal Calculation
<br />Incurred Claims 1/12 thru 12/12
<br />$7,847,564.59
<br />Clm /ee
<br />T rended Claims 8% 18 Months of trend - (12 %)
<br />$8,789,272.34
<br />Benefit Change
<br />$7,031,417.87
<br />Employee Count
<br />11,279
<br />Fixed Cost
<br />$1,307,123.31
<br />$115.89
<br />HSAs - $1,000
<br />$271,000.00
<br />Wellness Center
<br />$396,000.00
<br />Estimate 2013 - 2014 Cost
<br />$8,734,541.18
<br />Budgeted
<br />PPACA - Fee for Comparative Effectiveness Research Agency -
<br />7/31/13
<br />$1,313.00
<br />PPACA - Women's Health Benefits
<br />$78,475.65
<br />PPACA - Transitional Reinsurance Fee - 2014 - 2016 - 1/15/14 1st
<br />Payment
<br />$83,160.00
<br />Total - 2013 - 2014 Cost
<br />$9,168,489.83
<br />Budgeted 2012 - 2013 Cost
<br />$7,802,699.41
<br />$691.79
<br />Increase
<br />117.50%
<br />$774.41
<br />Fees Avoided in 2014
<br />PPACA - Health Insurance Industry Fee - Not Paid
<br />$229,212.25
<br />State of North Carolina Premium Tax
<br />$183,369.80
<br />Total
<br />$412,582.04
<br />G -4 Page 226
<br />
|