68-69 / 148
I. Cost Versus Funding
Plan Year: January 1, 2016 - December 31, 2016
ABC Company
6 Month Reporting Period: January 1, 2016 - June 30, 2016
E. Cost versus funding
—
By month
January 2016
2,722 $165,813 $1,225,499 $555,221
$0
$1,780,720
$654
$1,946,533
$715
$2,601,597
$956
74.8%
February 2016
2,720 $165,694 $1,145,013 $611,669
$0
$1,756,682
$646
$1,922,376
$707
$2,601,070
$956
73.9%
March 2016
2,719 $165,629 $1,531,552 $582,615
$0
$2,114,166
$778
$2,279,795
$838
$2,602,750
$957
87.6%
April 2016
2,719 $165,629 $1,718,657 $560,663
$0
$2,279,321
$838
$2,444,949
$899
$2,603,607
$958
93.9%
May 2016
2,715 $165,385 $1,758,537 $693,728
$0
$2,452,265
$903
$2,617,650
$964
$2,601,719
$958
100.6%
June 2016
2,701 $164,533 $1,906,865 $594,159
$0
$2,501,024
$926
$2,665,558
$987
$2,593,706
$960
102.8%
July 2016
August 2016
September 2016
October 2016
November 2016
December 2016
Total
2,716 $992,683 $9,286,123 $3,598,055
$0
$12,884,178 $791 $13,876,861 $852 $15,604,449 $958
88.9%
F. Employee versus employer funding
—
By month
January 2016
2,722
$2,601,597
$956
$791,627
$291
30.4%
$1,809,970
$665
69.6%
February 2016
2,720
$2,601,070
$956
$788,933
$290
30.3%
$1,812,137
$666
69.7%
March 2016
2,719
$2,602,750
$957
$787,460
$290
30.3%
$1,815,291
$668
69.7%
April 2016
2,719
$2,603,607
$958
$784,932
$289
30.1%
$1,818,676
$669
69.9%
May 2016
2,715
$2,601,719
$958
$779,695
$287
30.0%
$1,822,025
$671
70.0%
June 2016
2,701
$2,593,706
$960
$776,812
$288
29.9%
$1,816,894
$673
70.1%
July 2016
August 2016
September 2016
October 2016
November 2016
December 2016
Total
2,716
$15,604,449 $958
$4,709,458
$289
30.2%
$10,894,991 $669
69.8%
Subs
Fixed
Costs
Medical
Claims
Pharmacy
Claims
> Specific
Claims
Employer Funding (Total Less Employee)
Claims
Total Cost (Claims + Fixed)
Total Funding
Net
Claims
PSPM
Claims
Total
Cost
PSPM
Cost
Total
Funding
PSPM
Funding
Loss
Ratio
Total Funding (EE + ER)
Employee Funding
% Employer
Funding
Subs
Total
Funding
PSPM
Funding
Employee
Funding
PSPM
Funding
% Employee
Funding
Employer
Funding
PSPM
Funding
4