DATA ANALYSIS & REPORTING Select Sample Reports

1 data ANALYSIS & REPORTINGS elect Sample ReportsIntegrated Charts and GraphingDrill-Down to Individual Transaction/EOBB enchmark Plan Performance Normative Comparison Summary Key Utilization Indicators Claim ANALYSIS OverviewCtbA G Cost by Age Group Utilization Benchmark Summary Preventable Conditions Top Ranked Procedures, Providers, DrugsBenefit Informatics, | (4636) data Integration & Warehousing data ANALYSIS & REPORTING Plan Modeling & Forecasting Member & Provider CommunicationNormative Comparison Summary A1 Manufacturing - Group ID: DEMO3 Output Generated: 5/6/2010 Date Range: Check Date 4/1/2009 through 3/31/2010 Comparisons: None Enrollments, Payments & SavingsTotal Health Plan Contracts236 Total Health Plan Members576 Members per Member Employee Facility$228, Facility$434, Professional$4, Professional$574, $156, Plan Payment$1,398, Charges$3,238, Plan Payment$1,398, Responsibility$212, Insurance COB$18, Covered$849, N/W Savings Amount$759, N/W Savings * Derived from: Employer Health Benefits 2009 Annual Survey (#7936), The Henry J.

2 Kaiser Family Foundation and HRET, September 2009, This information was reprinted with permission from the Henry J. Kaiser Family Foundation. The Kaiser Family Foundation is a non-profit private operating foundation, based in Menlo Park, California, dedicated to producing and communicating the best possible ANALYSIS and information on health Statistics Claim Type Statistics Group Norm % DifferenceNorm CategoryAll Medical ClaimsServices/1000 Members20,113 Plan Payment/Member$2, Plan Payment/Contract$5, $8, National, Overall* Plan Payment/Contract$5, $9, 200 or More EEs* Plan Payment/Contract$5, $8, Midwest Region* Plan Payment/Contract$5, $8, Agriculture/Mining/Construction*Inpatien t FacilityServices/1000 Members2.

3 267 Plan Payment/Member$ Plan Payment/Contract$ Admissions/1000 Members 85 Average Length of Stay (Days) Days/1000 Members115 Outpatient FacilityServices/1000 Members7,641 Plan Payment/Member$ Plan Payment/Contract$1, Inpatient ProfessionalServices/1000 Members30 Plan Payment/Member$ Plan Payment/Contract$ Outpatient ProfessionalServices/1000 Members10,238 Plan Payment/Member$ Plan Payment/Contract$2, Per-Network SavingsPPOC hargesExclusionsDiscount Amount% SavingsABCPPO$2,336, $ $745, $41, $ $ $860, $ $13, $3,238, $ $759, StatisticsNumber of Services10425( )Plan Payment$878, ( )Claim Type% Services Plan Five Payees by Plan PaymentPayee% of Payments PaymentsASSOCIATED $375, $207, $97, $46, MEDICAL $44, Other $627, Key Utilization Indicators Date Range 1: Check Date 1/1/2009 through 4/30/2009 (120 days) Date Range 2: Check Date 1/1/2010 through 4/30/2010 (120 days) Comparisons: None A1 Manufacturing - Group ID.

4 DEMO3 Check Date 1/1/2009 - 4/30/2009 Check Date 1/1/2010 - 4/30/2010% DifferenceEnrollment Average Member Employee of Enrollment per Inpatient Facility$8, $71, Facility$68, $143, Professional$36, $ Professional$251, $175, $52, $50, Payments$418, $440, Cost Payment per Enrollment Contract$1, $1, per Member$ $ Facility Admissions/1000 Length of Stay(Days) , , $ $ $ $ $ $ Facility Services/1000 , $ $ $ $ $ $ Professional Services/1000 $ $ $ $ $ $ Professional Services/1000 Members4, , $ $ $ $ $1, $ report provides an overview of your group s medical cost and utilization. Key indicators can help identify both where positive changes have occurred and where potential problems ANALYSIS Overview A1 Manufacturing - Group ID: DEMO3 Output Generated: 5/6/2010 Date Range: Check Date 1/1/2010 through 3/31/2010 Comparisons.

5 None Total% of Total ChargesEmployee% Employee% of Total ChargesDependent% Dependent% of Total ChargesTotal Number of Claims Processed1,735 678 1,057 Total Number of Services3,940 1,501 2,439 Total Charges$731, $297, $433, Total Provider Reductions$340, $121, $219, Employee Responsibility$52, $16, $36, Exclusions$ $ $ Other Insurance$6, $ $5, Plan Payment$331, $159, $172, report provides an overview of claim expenditures, provider reductions and employee responsibility.

6 These costs are broken out by employee and dependent for further ANALYSIS . Cost by Age Group A1 Manufacturing - Group ID: DEMO3 Output Generated: 5/7/2010 Date Range: Check Date 1/1/2010 through 4/30/2010 Comparisons: None Age Group# of Clmnts# of Empl Clmnts# of Dep Clmnts# of SvcsClaim AmountDiscount AmountDiscount Amount% of ChargesEmployee RespEmployee Resp % of ChargesPlan PaymentPlan Payment% of Charges0-973073460$42, $10, $5, $19, $111, $19, $9, $57, $112, $27, $11, $39, $200, $47, $14, $90, 1,378$211, $51, $21, $83, ,737$330, $50, $27, $188, $101, $21, $11, $58, $26, $2, $3, $6, $ $ $ $ ,999$1,137, $229, $105, $544, & Over1165205$40, $5, $4, $13, report can be used to monitor claim amounts and network discounts by age bands for your plan.

7 Utilization Benchmark Summary This application displays a summary of your group's utilization versus selected benchmark values. The benchmark values were derived from information supplied through the United States Department of Health and Human Services, Centers for Disease Control and Prevention. Note that if a particular service is not available through your plan, this application will show little or no utilization for that service category. A1 Manufacturing - Group ID: DEMO3 Output Generated: 5/6/2010 Date Range: Check Date 1/31/2010 through 3/31/2010 Comparisons: None Benchmark TypeValue For GroupNational BenchmarkValuePercent Variancefrom BenchmarkMedical Encounters % persons having at least one office visit.

8 Home visit or ER Services % persons under 18 who had at least one ER % persons under 6 who had at least one ER visitN/AN/AN/A % persons between 6 and 17 who had at least one ER % persons between 18 and 64 who had at least one ER % persons 65 and older who had at least one ER Services % persons under 18 who had at least one dental % persons between 18 and 64 who had at least one dental Services % women age 40 and over who received a % women age 40 to 49 who received a % women age 50 to 64 who received a % women age 65 and over who received a Diseases % persons presenting Hepatitis ,807% % persons presenting Tuberculosis % persons presenting STD cases (Syphilis, Chlamydia, Gonorrhea) % persons presenting Symptomatic HIV ,537%Cancers % persons presenting Cancer cases (All Types) % persons presenting Lung Cancer % persons presenting Colon and Rectum Cancer % persons presenting Prostate Cancer % persons presenting Breast Cancer % persons presenting Leukemia % persons having services associated with physician-diagnosed, non-pregnancy Conditions This table displays your group's experience with certain illnesses that may be modifiable using disease prevention and health promotion initiatives.

9 Diseases and injuries are categorized as preventable when there is a modifiable factor that influences the development or severity of the condition. For example, hypertension, dietary fat, cholesterol, tobacco use, inadequate exercise and obesity are all modifiable factors that influence the risk of heart disease and stroke. Genetic predisposition and age also influence the risk of heart disease and stroke, but these factors cannot be modified. A1 Manufacturing - Group ID: DEMO3 Output Generated: 10/29/2010 Date Range: Check Date 1/1/2009 through 9/30/2010 Comparisons: None Diagnosis Category# of AdmissionsAvg Length of StayAvg Plan Payment per day# of Services# of PatientsAvg Plan Payment per patientTotal ChargesTotal Plan PaymentDiagnosis Prefixes ConsideredCerebrovascular Disease- Cerebral $ $15, $ - 432- Occlusion Cerebral $ $ $ - 434- Trans-ischemic $ $1, $ $ $2, $1, Other Cerebrovascular $ $ $ - 438 Heart Disease- Heart $9, $39, $19, & 412 - 413- Other Acute Heart $1, $35, $18, & 420 - 427 & 429- Chronic Heart $5, $96, $47, Congestive Heart $ $ $ Diabetes & , $1, $57, $31, & & & & $ $12, $6, Disease- $ $ $ $ $ $ - 442- Peripheral Vascular $ $1, $ Disease- $ $ $ $ $ $ Varicose $1, $12, $3.

10 $1, $278, $130, 30 Procedure Codes by Plan Payment Amount A1 Plan ANALYSIS - Group ID: DEMO3 Output Generated: 10/29/2010 Date Range: Check Date 1/1/2010 through 9/30/2010 (Paid data )Comparisons: Procedure Code <> '' Procedure CodeNumber ofClaimsNumber ofServicesTotal Charge AmountDiscount AmountEmployee Responsibility AmountOther AmountPlan PaymentAmount99213 - OFFICE/OUTPATIENT VISIT, EST650656$56, $27, $5, $ $23, - DENTAL PROPHYLAXIS ADULT398399$26, $3, $ $ $22, - PERIODIC ORAL EVALUATION466467$15, $2, $ $ $12, - OFFICE/OUTPATIENT VISIT, EST195198$26, $11, $2, $ $12, - ZOLEDRONIC ACID88$10, $1, $ $ $9, - HIT ANTIBIOTIC TOTAL DIEM22$10, $3, $ $ $7, - TISSUE EXAM BY PATHOLOGIST2941$10, $3, $ $ $6, - LOW BACK DISK SURGERY36$82, $76, $ $ $6, - DECOMPRESS SPINAL CORD22$7, $ $ $ $6, - PREV VISIT, EST, AGE 40-646161$10, $4, $ $ $5, - OBSTETRICAL CARE44$13, $6, $ $ $5, - OFFICE/OUTPATIENT VISIT.