Appendix_C_(1-_Embassy_Egypt_CS_Claims_Analysis__1MAY2013_through_30APR2014).pdf

CS Claims Analysis by Client and Sub office Client code: 0312* Paid date from : 2013-5-1 to : 2014-4-30

Claims Paid by Benefit Category

Client / Suboffice Inpatient Outpatient Op Medication

Maternity Dental Optical Other Services

Total % of Total

0312A 001 AMERICAN EMBASSY 890,186 787,871 1,943,060 50,293 185,902 145,148 940 4,003,399 36% 0312B 001 AMERICAN EMBASSY 1,518,188 1,125,259 1,366,564 311,829 236,963 210,296 4,273 4,773,370 43%

0312C 001 AMERICAN EMBASSY 68,428 48,138 149,457 5,100 6,400 277,523 3%

0312D 001 AMERICAN EMBASSY 103,891 77,364 173,436 14,134 16,798 385,622 4%

0312E 001 AMERICAN EMBASSY 118,968 175,191 131,726 15,658 28,936 32,532 503,011 5%

0312F 001 AMERICAN EMBASSY 5,884 23,501 2,035 31,420 0%

0312H 001 AMERICAN EMBASSY 2,381 10,587 5,966 2,935 1,000 1,600 24,468 0%

0312I 001 AMERICAN EMBASSY USAID 93,542 83,835 144,889 11,733 24,752 16,475 1,242 376,468 3% 0312J 001 AMERICAN EMBASSY USAID 162,262 60,498 76,786 14,769 28,962 25,022 158 368,457 3%

0312K 001 AMERICAN EMBASSY 3,739 5,779 1,000 1,600 12,118 0%

0312M 001 A.E.C.W.A 21,937 23,740 46,247 5,950 2,400 100,273 1% 0312N 001 A.E.C.W.A 6,682 34,808 13,484 33,267 6,485 4,734 99,461 1%

0312G 001 AMERICAN EMBASSY 3,675 5,869 13,072 45 22,661 0%

Total 2,990,137 2,442,782 4,093,967 440,485 541,218 463,050 6,612 10,978,251 100%

Inpatient 27%

Outpatient 22%

Op Medication 37%

Maternity 4%

Dental 5%

Optical 4%

Other Ser...

0%

Inpatient 27%

Outpatient 22%

Op Medication 37%

Maternity 4%

Dental 5%

Optical 4%

Other Ser...

0%

PercentagePaid_usd

Inpatient Outpatient Op Medication Maternity Dental Optical Other Services

Cash vs. PPO Claims

Client / Suboffice CASH PPO Total % of Total

0312A 001 AMERICAN EMBASSY 452,761 3,550,638 4,003,399 36%

0312B 001 AMERICAN EMBASSY 774,424 3,998,946 4,773,370 43%

0312C 001 AMERICAN EMBASSY 12,724 264,799 277,523 3%

0312D 001 AMERICAN EMBASSY 39,305 346,318 385,622 4%

0312E 001 AMERICAN EMBASSY 82,149 420,861 503,011 5%

0312F 001 AMERICAN EMBASSY 2,080 29,339 31,420 0%

0312G 001 AMERICAN EMBASSY 170 22,490 22,661 0%

0312H 001 AMERICAN EMBASSY 4,209 20,259 24,468 0%

0312I 001 AMERICAN EMBASSY USAID 70,357 306,111 376,468 3%

0312J 001 AMERICAN EMBASSY USAID 118,424 250,032 368,457 3%

0312K 001 AMERICAN EMBASSY 3,597 8,521 12,118 0%

0312M 001 A.E.C.W.A 17,635 82,638 100,273 1% 0312N 001 A.E.C.W.A 21,483 77,978 99,461 1% Total 1,599,319 9,378,932 10,978,251 100%

CASH

15%

PPO

85%

CASH

15%

PPO

85%

CASH

PPO

User: Maged Hamdy 1 of 14 May 5, 2019 3:08:30 PM

Paid date from : 2013-5-1 to : 2014-4-30

Cash Claims by Benefit Category

Client / Suboffice Inpatient Outpatient Op Medication

Maternity Dental Optical Other Services

Total % of Total

0312A 001 AMERICAN EMBASSY 21,110 40,312 32,818 27,079 185,902 145,148 392 452,761 28% 0312B 001 AMERICAN EMBASSY 88,535 56,353 83,519 95,332 236,855 210,296 3,535 774,424 48%

0312C 001 AMERICAN EMBASSY 986 237 5,100 6,400 12,724 1%

0312D 001 AMERICAN EMBASSY 2,785 5,588 14,134 16,798 39,305 2%

0312E 001 AMERICAN EMBASSY 778 7,319 2,741 9,844 28,936 32,532 82,149 5%

0312F 001 AMERICAN EMBASSY 46 2,035 2,080 0%

0312H 001 AMERICAN EMBASSY 500 799 309 1,000 1,600 4,209 0%

0312I 001 AMERICAN EMBASSY USAID 13,612 9,969 2,653 2,896 24,752 16,475 70,357 4% 0312J 001 AMERICAN EMBASSY USAID 44,236 6,988 3,009 10,207 28,962 25,022 118,424 7%

0312K 001 AMERICAN EMBASSY 663 334 1,000 1,600 3,597 0%

0312M 001 A.E.C.W.A 6,858 2,382 45 5,950 2,400 17,635 1% 0312N 001 A.E.C.W.A 775 265 232 8,992 6,485 4,734 21,483 1%

0312G 001 AMERICAN EMBASSY 84 41 45 170 0%

Total 176,402 128,951 131,528 154,350 541,110 463,050 3,928 1,599,319 100%

Inpatient 11%

Outpatient 8%

Op Medication 8%

Maternity 10%

Dental 34%

Optical 29%

Other Ser...

0%

Inpatient 11%

Outpatient 8%

Op Medication 8%

Maternity 10%

Dental 34%

Optical 29%

Other Ser...

Op Medication Maternity Dental Optical Other Services

PPO Claims by Benefit Category

Client / Suboffice Inpatient Outpatient Op Medication

Maternity Dental Other Services

Total % of Total

0312B 001 AMERICAN EMBASSY 1,429,653 1,068,906 1,283,045 216,496 108 738 3,998,946 43%

0312A 001 AMERICAN EMBASSY 869,076 747,559 1,910,242 23,214 547 3,550,638 38%

0312C 001 AMERICAN EMBASSY 68,428 47,152 149,220 264,799 3%

0312D 001 AMERICAN EMBASSY 103,891 74,579 167,848 346,318 4%

0312E 001 AMERICAN EMBASSY 118,190 167,871 128,985 5,814 420,861 4%

0312G 001 AMERICAN EMBASSY 3,675 5,785 13,031 22,490 0%

0312H 001 AMERICAN EMBASSY 1,880 9,788 5,656 2,935 20,259 0%

0312I 001 AMERICAN EMBASSY USAID 79,930 73,866 142,235 8,838 1,242 306,111 3%

0312J 001 AMERICAN EMBASSY USAID 118,026 53,510 73,776 4,562 158 250,032 3%

0312M 001 A.E.C.W.A 15,079 21,357 46,202 82,638 1% 0312N 001 A.E.C.W.A 5,907 34,544 13,252 24,275 77,978 1%

0312F 001 AMERICAN EMBASSY 5,838 23,501 29,339 0%

0312K 001 AMERICAN EMBASSY 3,076 5,445 8,521 0%

Total 2,813,735 2,313,831 3,962,439 286,135 108 2,685 9,378,932 100%

Inpatient 30%

Outpatient 25%

Op Medication 42%

Maternity 3%

Dental 0%

Other Ser...

0%

Inpatient 30%

Outpatient 25%

Op Medication 42%

Maternity 3%

Dental 0%

Other Ser...

Op Medication Maternity Dental Other Services

User: Maged Hamdy 2 of 14 May 5, 2019 3:08:30 PM

Paid date from : 2013-5-1 to : 2014-4-30

Monthly Claims Paid Amount

Year- Month

Inpatient Outpatient Op Medication

Maternity Dental Optical Other Services

Total

May-2013 102,676 145,858 302,258 12,702 9,262 16,408 1,718 590,882 Jun-2013 116,497 167,807 302,070 26,661 32,855 37,708 1,072 684,671 Jul-2013 184,829 167,912 355,935 30,152 24,234 24,674 686 788,423 Aug-2013 225,187 192,366 284,608 24,672 23,991 18,255 769,078 Sep-2013 399,943 197,396 406,876 69,824 46,155 48,530 245 1,168,970 Oct-2013 152,124 180,334 223,118 46,491 43,308 53,172 698,548 Nov-2013 316,391 252,765 252,088 31,648 69,212 60,413 982,518 Dec-2013 143,644 177,320 516,257 30,301 71,320 49,967 735 989,545 Jan-2014 404,598 203,217 387,236 37,742 48,208 45,445 438 1,126,885 Feb-2014 301,430 278,523 387,245 40,545 58,932 31,085 280 1,098,039 Mar-2014 262,786 220,194 337,531 66,254 73,692 40,997 1,176 1,002,630 Apr-2014 380,032 259,090 338,744 23,492 40,048 36,395 263 1,078,063 Total 2,990,137 2,442,782 4,093,967 440,485 541,218 463,050 6,612 10,978,251

200,000

400,000

600,000

800,000

1,000,000

1,200,000

May-2013 Jun-2013

Jul-2013 Aug-2013

Sep-2013 Oct-2013

Nov-2013 Dec-2013

Jan-2014 Feb-2014

Mar-2014 Apr-2014

Benefit_Category Inpatient Outpatient Op Medication Maternity Dental Optical Other Services

Year-Month

Pa id

_u sd

Monthly Claims Count

Year-Month Inpatient Outpatient Op Medication Maternity Dental Optical Other Services May-2013 24 914 1,662 43 31 23 10 Jun-2013 26 1,474 1,664 58 69 51 6 Jul-2013 35 1,400 2,027 75 50 32 3 Aug-2013 36 1,659 1,464 93 55 24 Sep-2013 48 1,702 2,161 100 95 65 1 Oct-2013 32 1,466 1,364 81 68 72 Nov-2013 59 2,098 1,645 98 119 85 Dec-2013 35 1,507 3,001 114 110 65 1 Jan-2014 51 1,689 2,359 104 82 60 2 Feb-2014 46 2,362 2,251 95 117 43 1 Mar-2014 60 1,980 2,125 116 137 54 5 Apr-2014 36 2,038 1,916 115 85 48 1 Total 488 20,289 23,639 1,092 1,018 622 30

1,000

2,000

3,000

4,000

5,000

6,000

May-2013 Jun-2013

Jul-2013 Aug-2013

Sep-2013 Oct-2013

Nov-2013 Dec-2013

Jan-2014 Feb-2014

Mar-2014 Apr-2014

Benefit_Category Inpatient Outpatient Op Medication Maternity Dental Optical Other Services

Year-Month

Cl ai m _c ou nt

User: Maged Hamdy 3 of 14 May 5, 2019 3:08:30 PM

Paid date from : 2013-5-1 to : 2014-4-30

Claims based on Paid Amount Range

Paid Amount Range No.of claims %of total claims Paid Amount % of Total

<= 250 38,135 82% 3,005,840 27%

251-500 4,213 9% 1,493,772 14%

501-1000 3,183 7% 2,306,183 21%

1001-2500 568 1% 865,335 8%

2501-5000 193 0% 719,440 7%

5001-10000 130 0% 914,575 8%

>=10000 55 0% 1,673,106 15%

Total 46,477 100% 10,978,251 100%

Top 10 Daignosis Codes based on Paid Amount

Top 10 Diagnosis Number of Claimant

Paid Amount % to Total

HYPERTENSION 550 872,584 8%

DIABETES MELLITUS (DM) 487 817,360 7%

ISCHEMIC HEART DISEASE (IHD) 204 737,337 7%

DENTAL 805 541,169 5%

OPTICAL 610 463,140 4%

HYPERLIPIDEMIA 426 290,913 3%

LUMBAGO / LOW BACK PAIN 690 281,473 3%

CAESAREAN SECTION DELIVERY (MEDICALLY NECESSARY) - MATERNITY 58 230,903 2%

BRONCHIAL ASTHMA 268 188,419 2%

OSTEOARTHRITIS 320 172,970 2%

Top 10 4,596,267 42%

Others 6,381,984 58%

Summary 10,978,251 100%

User: Maged Hamdy 4 of 14 May 5, 2019 3:08:30 PM

Paid date from : 2013-5-1 to : 2014-4-30

Top 10 Claimant based on Paid Amount

Top 10 Claimant

Paid Amount % of Total

Major Conditions

1 163,284 1% BACK PAIN

CHEST PAIN (UNSPECIFIC REASON)

CONJUNCTIVITIS, ACUTE

CORONARY ARTERY DISEASE (CAD)/ CORONARY INSUFFICIENCY

DIABETES MELLITUS (DM)

DRY EYE

EYE DISORDER - UNSPECIFIC

GASTRITIS

GENERAL SYMPTOMS

HYPERLIPIDEMIA

HYPERTENSION

ISCHEMIC HEART DISEASE (IHD)

LUMBAGO / LOW BACK PAIN

ONYCHIA / PARONYCHIA OF FINGER

ONYCHIA / PARONYCHIA OF TOE

RETINAL DETACHMENT

RETINAL HAEMORRHAGE

VERTIGO / DIZZINESS / GIDDINESS

2 123,913 1% ABDOMINAL PAIN

PERITONITIS

3 122,168 1% ABDOMINAL PAIN

BRONCHITIS, ACUTE

CHEST PAIN (UNSPECIFIC REASON)

DIABETES MELLITUS (DM)

GASTROENTERITIS / ENTERITIS OR COLITIS

HEPATITIS

HEPATITIS C

HYPERLIPIDEMIA

HYPERTENSION

ISCHEMIC HEART DISEASE (IHD)

MALAISE / FATIGUE

RENAL FAILURE UNSPECIFIC

RENAL FAILURE, ACUTE

RENAL FAILURE, CHRONIC

SEBACEOUS CYST

SHORTNESS OF BREATH (SOB) / DYSPNEA

TRAUMA DUE TO ANY CAUSE

User: Maged Hamdy 5 of 14 May 5, 2019 3:08:30 PM

Paid date from : 2013-5-1 to : 2014-4-30

Top 10 Claimant based on Paid Amount

Top 10 Claimant

Paid Amount % of Total

Major Conditions

3 122,168 1% UPPER RESPIRATORY INFECTION (URTI / URI)

VARICOSE VEINS LEG

WOUND

4 106,101 1% ANXIETY

DEPRESSION

HYPERLIPIDEMIA

HYPERTENSION

ISCHEMIC HEART DISEASE (IHD)

5 100,165 1% ALLERGIC RHINITIS / RHINORRHEA / HAY FEVER

ANGINA PECTORIS

BRONCHITIS, ACUTE

CATARRH / COLD / CORYZA / NASOPHARYNTIGIS /RHINOPHARINGITIS

CHEST PAIN (UNSPECIFIC REASON)

DIARRHAEA

HYPERLIPIDEMIA

HYPERTENSION

IRRITABLE COLON / IRRITABLE BOWEL SYNDROME (IBS)

ISCHEMIC HEART DISEASE (IHD)

LUMBAGO / LOW BACK PAIN

NEURALGIA / NEURITIS

OPTICAL

PALPITATIONS

PROSTATIC HYPERTROPHY

RENAL COLIC

SCIATICA / SCIATIC PAIN

6 98,333 1% BACK PAIN

BRONCHITIS, ACUTE

CATARRH / COLD / CORYZA / NASOPHARYNTIGIS /RHINOPHARINGITIS

CHEST PAIN (UNSPECIFIC REASON)

DERMATOLOGY /SKIN GENERAL

DIABETES MELLITUS (DM)

EPIGASTRIC PAIN

HYPERTENSION

IRRITABLE COLON / IRRITABLE BOWEL SYNDROME (IBS)

ISCHEMIC HEART DISEASE (IHD)

TRAUMA DUE TO ANY CAUSE

7 94,984 1% ANAL / RECTAL FISSURE

User: Maged Hamdy 6 of 14 May 5, 2019 3:08:30 PM

Paid date from : 2013-5-1 to : 2014-4-30

Top 10 Claimant based on Paid Amount

Top 10 Claimant

Paid Amount % of Total

Major Conditions

7 94,984 1% CHEST PAIN (UNSPECIFIC REASON)

CONJUNCTIVITIS, ACUTE

DEAFNESS / HEARING LOSS

HYPERTENSION

ISCHEMIC HEART DISEASE (IHD)

KNEE PAIN

MITRAL VALVE DISORDER

OPTICAL

OSTEOARTHRITIS

PITYRIASIS / TINEA VERSICOLOR

RHEUMATIC HEART DISEASE

8 90,979 1% ABDOMINAL PAIN

ABSCESS / CELLULITIS

ANAEMIA IRON DEFICIENCY

ANAEMIA UNSPECIFIC

BACK PAIN

BEHCET'S SYNDROME

DERMATITIS (& CONTACT) / ECZEMA

DIABETES MELLITUS (DM)

DRY EYE

EPIGASTRIC PAIN

EPILEPSY / EPILEPTIC CONVULSIONS / FITS OR SEIZURES

GASTRITIS

GASTROENTERITIS / ENTERITIS OR COLITIS

HEMORRHAGE OF RECTUM AND ANUS / MELENA

HYPERTENSION

INTERTRIGO (CANDIDAL)

IRRITABLE COLON / IRRITABLE BOWEL SYNDROME (IBS)

LUMBAGO / LOW BACK PAIN

LYMPHADENITIS

PHARYNGITIS

RENAL COLIC

SINUSITIS, ACUTE

SORE THROAT / PHARYNGITIS, ACUTE

TONSILLITIS, ACUTE

TRAUMA DUE TO ANY CAUSE

ULCERATIVE COLITIS

User: Maged Hamdy 7 of 14 May 5, 2019 3:08:30 PM

Paid date from : 2013-5-1 to : 2014-4-30

Top 10 Claimant based on Paid Amount

Top 10 Claimant

Paid Amount % of Total

Major Conditions

8 90,979 1% UVEITIS / IRIDOCYCLITIS UNSPECIFIC

VERTIGO / DIZZINESS / GIDDINESS

9 87,048 1% BRONCHITIS, ACUTE

CATARACT

CONJUNCTIVITIS, ACUTE

CORONARY ARTERY DISEASE (CAD)/ CORONARY INSUFFICIENCY

DIABETES MELLITUS (DM)

DRY EYE

EYE DISORDER - UNSPECIFIC

GLAUCOMA

HYPERLIPIDEMIA

HYPERTENSION

ISCHEMIC HEART DISEASE (IHD)

NECK PAIN / CERVICALGIA

NEURALGIA / NEURITIS

RETINA EXUDATES/DEPOSITS

VISUAL FIELD DEFECT

10 84,922 1% ARTHROPATHY / ARTHRITIS

ASTHMATIC BRONCHITIS

BRONCHIAL ASTHMA

BRONCHITIS, ACUTE

CARDIAC DYSRHYTHMIA

CARDIOMYOPATHY

CATARRH / COLD / CORYZA / NASOPHARYNTIGIS /RHINOPHARINGITIS

CHEST PAIN (UNSPECIFIC REASON)

DIABETES MELLITUS (DM)

GASTRITIS

GOUT / HYPERURICEMIA

HYPERLIPIDEMIA

HYPERTENSION

INTERVERTEBRAL DISC

ISCHEMIC HEART DISEASE (IHD)

LUMBAGO / LOW BACK PAIN

NEURALGIA / NEURITIS

OSTEOARTHRITIS

OSTEOPOROSIS

User: Maged Hamdy 8 of 14 May 5, 2019 3:08:30 PM

Paid date from : 2013-5-1 to : 2014-4-30

Top 10 Claimant based on Paid Amount

Top 10 Claimant

Paid Amount % of Total

Major Conditions

10 84,922 1% REFLUX ESOPHAGITIS

SHORTNESS OF BREATH (SOB) / DYSPNEA

SORE THROAT / PHARYNGITIS, ACUTE

UPPER RESPIRATORY INFECTION (URTI / URI)

VENTRICULAR FIBRILLATION (VF)

Top 10 1,071,897 10%

Others 9,906,355 90%

Summary 10,978,251 100%

User: Maged Hamdy 9 of 14 May 5, 2019 3:08:30 PM

Paid date from : 2013-5-1 to : 2014-4-30

Top 10 Providers based on Paid Amount

Top 10 Providers Paid Amount Claim_Count % of Total

AS-SALAM INT'L HOSPITAL 1,566,150 694 17%

EZABY PHARMACY 1,094,430 3,292 12%

CLEOPATRA HOSPITAL 687,716 459 7%

Dr. El Hakim Pharmacy 610,474 1,746 7%

Al Nakheel Hospital 534,805 418 6%

EL SANBAWY PHAMACY 510,376 957 5%

DR. AMINA PHARMACY 434,088 1,140 5%

DR. KAMAL HUSSIEN PHARMACY 425,851 1,245 5%

CAIRO MEDICAL CENTRER 369,396 218 4%

AL SALAM HOSPITAL 320,678 548 3%

Top 10 6,553,964 70%

User: Maged Hamdy 10 of 14 May 5, 2019 3:08:30 PM

Paid date from : 2013-5-1 to : 2014-4-30

001 A.E.C.W.A Top 10 Providers Paid Amount % of Total

Al Nakheel Hospital 39,439 25%

EZABY PHARMACY 21,216 13%

Eye Subspeciality Center 12,745 8%

CLEOPATRA HOSPITAL 12,291 8%

AS-SALAM INT'L HOSPITAL 12,128 8%

AL SALAM HOSPITAL 11,532 7%

DR. AMINA PHARMACY 10,526 7%

DR. KAMAL HUSSIEN PHARMACY 9,189 6%

Baklawi Pharmacy 7,629 5%

Dr. El Hakim Pharmacy 6,887 4%

Top 10 143,582 89%

Others 17,034 11%

001 A.E.C.W.A 160,616 100%

001 AMERICAN EMBASSY

Top 10 Providers Paid Amount % of Total

AS-SALAM INT'L HOSPITAL 1,396,843 16%

EZABY PHARMACY 1,037,374 12%

CLEOPATRA HOSPITAL 638,829 7%

Dr. El Hakim Pharmacy 601,220 7%

EL SANBAWY PHAMACY 506,592 6%

Al Nakheel Hospital 474,147 5%

DR. KAMAL HUSSIEN PHARMACY 415,089 5%

DR. AMINA PHARMACY 401,686 5%

CAIRO MEDICAL CENTRER 367,726 4%

AL SALAM HOSPITAL 293,103 3%

Top 10 6,132,609 71%

Others 2,529,564 29%

001 AMERICAN EMBASSY 8,662,172 100%

001 AMERICAN EMBASSY USAID

Top 10 Providers Paid Amount % of Total

AS-SALAM INT'L HOSPITAL 157,180 28%

ANEES & RAMZY PHARMACY 129,834 23%

CLEOPATRA HOSPITAL 36,597 7%

EZABY PHARMACY 35,839 6%

DR. AMINA PHARMACY 21,877 4%

Al Nakheel Hospital 21,218 4%

User: Maged Hamdy 11 of 14 May 5, 2019 3:08:30 PM

Paid date from : 2013-5-1 to : 2014-4-30

Top 10 Providers Paid Amount % of Total

ALFA SCAN 20,432 4%

Al Hayat Medical Center 16,326 3%

AL SALAM HOSPITAL 16,043 3%

DR. MOAMENA KAMEL LABORA 12,403 2%

Top 10 467,748 84%

Others 88,396 16%

001 AMERICAN EMBASSY USAID 556,144 100%

User: Maged Hamdy 12 of 14 May 5, 2019 3:08:30 PM

Paid date from : 2013-5-1 to : 2014-4-30

CASH Claims Detail CASH Claims - Paid Amount Paid Amount

Country 001 A.E.C.W.A 39,118

AMERICAN EMBASSY 1,371,420

AMERICAN EMBASSY USAID 187,781

Sub total 1,598,319

001 AMERICAN EMBASSY USAID 1,000

Sub total 1,000

Total 1,599,319

CASH Claims - Claim Count Claim_Count

Country 001 A.E.C.W.A 56

AMERICAN EMBASSY 3,262

AMERICAN EMBASSY USAID 432

Sub total 3,750

001 AMERICAN EMBASSY USAID 1

Sub total 1

Total 3,751

PPO Claims Detail PPO Claims - Paid Amount Paid Amount

Country 001 A.E.C.W.A 160,616

AMERICAN EMBASSY 8,662,172

AMERICAN EMBASSY USAID 556,144

Sub total 9,378,932

Total 9,378,932

PPO Claims - Claim Count Claim_Count

Country 001 A.E.C.W.A 1,107

AMERICAN EMBASSY 43,335

AMERICAN EMBASSY USAID 2,282

Sub Total 46,724

Total 46,724

User: Maged Hamdy 13 of 14 May 5, 2019 3:08:30 PM

Paid date from : 2013-5-1 to : 2014-4-30

Claims by Insured Type Insured Op Medication Outpatient Inpatient Maternity Dental Optical Other Services Total % of Total

Employees 2,552,824 1,063,425 1,202,490 62,233 245,127 192,866 2,182 5,321,147 48%

Spouse 1,096,500 783,514 1,211,768 378,197 155,868 114,840 476 3,741,164 34%

Child 444,642 595,843 575,879 55 140,223 155,344 3,954 1,915,941 17%

Total 4,093,967 2,442,782 2,990,137 440,485 541,218 463,050 6,612 10,978,251 100%

Claims by Age Range Age Range Paid Amount Claim count

Male Female Total Female Male Total

Under 21 577,188 529,603 1,106,791 4,613 5,286 9,899

21-25 215,487 288,803 504,290 1,194 822 2,016

26-30 156,355 217,671 374,026 1,113 638 1,751

31-35 134,532 420,003 554,535 1,916 947 2,863

36-40 301,235 564,366 865,602 2,429 1,594 4,023

41-45 477,460 582,795 1,060,255 2,374 2,753 5,127

46-50 583,415 637,278 1,220,693 2,051 2,649 4,700

51-55 536,736 671,207 1,207,942 1,848 2,327 4,175

56-60 1,329,509 609,654 1,939,163 2,001 4,308 6,309

61-65 1,394,008 469,293 1,863,301 1,188 3,479 4,667

66-69 123,255 134,497 257,752 336 488 824

70 and above 23,635 266 23,901 1 122 123

Total 5,852,815 5,125,436 10,978,251 21,064 25,413 46,477

Note: All amounts are in Policy Currency

User: Maged Hamdy 14 of 14 May 5, 2019 3:08:30 PM