Employer Group ABC
Incurred:
Apr 2014 thru Dec 2015
Paid:
Apr 2014 thru Mar 2016
42
|
Page
5.2 Financial Analyses
47
Table 5.2.1 Medical and Pharmacy Claims by Month ( Apr 14 - Dec 14 )
Table 5.2.2 Medical and Pharmacy Claims by Month ( Apr 15 - Dec 15 )
Service
Date
Category
Medical
Medical
PMPM
Pharmacy
Pharmacy
PMPM
Total
Total
PMPM
Apr-14
$7,439,201
$439
$0
$0
$7,439,201
$439
May-14
$6,955,405
$416
$0
$0
$6,955,405
$416
Jun-14
$7,443,233
$459
$0
$0
$7,443,233
$459
Jul-14
$7,487,985
$470
$0
$0
$7,487,985
$470
Aug-14
$6,478,106
$414
$0
$0
$6,478,106
$414
Sep-14
$6,627,535
$421
$0
$0
$6,627,535
$421
Oct-14
$6,780,810
$433
$0
$0
$6,780,810
$433
Nov-14
$6,382,041
$425
$0
$0
$6,382,041
$425
Dec-14
$7,117,782
$474
$0
$0
$7,117,782
$474
Total
$62,712,098
$439
$0
$0
$62,712,098
$439
Service
Date
Category
Medical
Medical
PMPM
Pharmacy
Pharmacy
PMPM
Total
Total
PMPM
Apr-15
$6,272,035
$459
$0
$0
$6,272,035
$459
May-15
$6,041,726
$450
$0
$0
$6,041,726
$450
Jun-15
$5,155,410
$290
$0
$0
$5,155,410
$290
Jul-15
$5,854,421
$335
$0
$0
$5,854,421
$335
Aug-15
$6,227,403
$358
$0
$0
$6,227,403
$358
Sep-15
$5,671,783
$329
$0
$0
$5,671,783
$329
Oct-15
$6,320,678
$367
$0
$0
$6,320,678
$367
Nov-15
$5,850,229
$342
$0
$0
$5,850,229
$342
Dec-15
$6,331,701
$376
$0
$0
$6,331,701
$376
Total
$53,725,386
$363
$0
$0
$53,725,386
$363
47
Note:
In any of the months or 'Total' column, when Medical MM is not equal to Rx MM in one or both time period(s) (current or prior), Total PMPM is not equal to sum of Medical PMPM and Rx PMPM for
that/those time period(s).
Medical PMPM includes Non-PBM drug spend (J-Codes).