Embassy Egypt CS Claims Analysis May 1 through Oct 31 2018.pdf
PDF 210 KB Posted
- Attached to
- Health and Life Insurance, US Embassy Cairo
- Solicitation number
- 19GE5021R0009
About this file
This solicitation seeks health and life insurance proposals for locally engaged staff at the US Embassy in Cairo, Egypt. Offerors must submit pricing in the required Microsoft Excel spreadsheet by February 26, 2021 at 15:00 German Time to the Regional Procurement Support Office in Frankfurt. Questions are due by February 9, 2021 and will be answered via amendment. The selected contractor must have an active SAM registration. The contract type is not specified but the pricing sheet requests firm fixed unit prices. The Department of State is the contracting agency and the incumbent is not identified.
View the file
Other files
Show all 28
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
CS Claims Analysis by Client and Sub office Client code: 0312* Paid date from : 2018-05-01 to : 2018-10-31
Claims Paid by Benefit Category
Client / Suboffice Inpatient Outpatient Op Medication
Maternity Dental Optical Other Services
Total % of Total
0312A 001 AMERICAN EMBASSY 1,614,778 1,450,278 2,204,901 39,709 169,067 101,463 0 5,580,196 34% 0312B 001 AMERICAN EMBASSY 2,375,348 2,095,010 2,109,258 279,813 257,085 153,960 0 7,270,474 45%
0312C 001 AMERICAN EMBASSY 964,449 126,837 311,443 3,587 845 1,407,162 9%
0312D 001 AMERICAN EMBASSY 24,950 81,808 172,928 10,424 5,633 295,743 2%
0312E 001 AMERICAN EMBASSY 234,747 155,800 190,628 15,467 22,397 13,966 633,006 4%
0312F 001 AMERICAN EMBASSY 17,834 16,739 61,072 1,718 97,363 1%
0312G 001 AMERICAN EMBASSY 9,632 6,917 23,545 1,940 685 42,719 0%
0312H 001 AMERICAN EMBASSY 15,959 14,249 4,911 2,000 45 37,164 0%
0312I 001 AMERICAN EMBASSY USAID 165,043 181,711 187,343 25,436 21,129 5,365 586,028 4% 0312J 001 AMERICAN EMBASSY USAID 17,763 156,818 127,158 17,787 19,510 21,830 0 360,866 2%
0312K 001 AMERICAN EMBASSY 892 233 1,126 0%
Total 5,440,502 4,287,059 5,393,422 378,213 508,858 303,792 0 16,311,846 100% Inpatient
33%
Outpatient 26%
Op Medication 33%
Maternity 2%
Dental 3%
Optical 2%
Inpatient 33%
Outpatient 26%
Op Medication 33%
Maternity 2%
Dental 3%
Optical 2%
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 171,543 5,408,653 5,580,196 34%
0312B 001 AMERICAN EMBASSY 643,929 6,626,546 7,270,474 45%
0312C 001 AMERICAN EMBASSY 141,849 1,265,313 1,407,162 9%
0312D 001 AMERICAN EMBASSY 21,985 273,758 295,743 2%
0312E 001 AMERICAN EMBASSY 42,056 590,950 633,006 4%
0312F 001 AMERICAN EMBASSY 900 96,463 97,363 1%
0312G 001 AMERICAN EMBASSY 1,152 41,567 42,719 0%
0312H 001 AMERICAN EMBASSY 1,000 36,164 37,164 0%
0312I 001 AMERICAN EMBASSY USAID 61,497 524,531 586,028 4%
0312J 001 AMERICAN EMBASSY USAID 89,807 271,058 360,866 2%
0312K 001 AMERICAN EMBASSY 1,126 1,126 0%
Total 1,175,718 15,136,128 16,311,846 100%
CASH
7%
PPO
93%
CASH
7%
PPO
93%
CASH
PPO
User: Maged Hamdy 1 of 13 Mar 3, 2021 5:33:37 PM
Paid date from : 2018-05-01 to : 2018-10-31
Cash Claims by Benefit Category
Client / Suboffice Inpatient Outpatient Op Medication
Maternity Dental Optical Other Services
Total % of Total
0312A 001 AMERICAN EMBASSY 6,371 33,611 4,150 14,331 95,923 17,156 171,543 15%
0312B 001 AMERICAN EMBASSY 264,701 121,812 16,336 70,573 139,330 31,177 0 643,929 55%
0312C 001 AMERICAN EMBASSY 127,653 5,740 7,956 500 141,849 12%
0312D 001 AMERICAN EMBASSY 11,963 2,419 219 5,784 1,600 21,985 2%
0312E 001 AMERICAN EMBASSY 9,973 2,310 631 8,530 13,912 6,700 42,056 4%
0312F 001 AMERICAN EMBASSY 900 900 0%
0312G 001 AMERICAN EMBASSY 77 125 950 1,152 0%
0312H 001 AMERICAN EMBASSY 1,000 1,000 0%
0312I 001 AMERICAN EMBASSY USAID 23,129 2,139 13,455 19,214 3,560 61,497 5%
0312J 001 AMERICAN EMBASSY USAID 40,632 1,960 15,287 17,756 14,172 0 89,807 8%
Total 420,661 229,730 33,515 122,176 295,270 74,366 0 1,175,718 100%
Inpatient 36%
Outpatient 20%
Op Medica...
3%
Maternity 10%
Dental 25%
Optical 6%
Inpatient 36%
Outpatient 20%
Op Medica...
3%
Maternity 10%
Dental 25%
Optical 6%
Op Medication Maternity Dental Optical Other Services
PPO Claims by Benefit Category
Client / Suboffice Inpatient Outpatient Op Medication
Maternity Dental Optical Other Services
Total % of Total
0312A 001 AMERICAN EMBASSY 1,608,407 1,416,666 2,200,751 25,378 73,144 84,306 0 5,408,653 36% 0312B 001 AMERICAN EMBASSY 2,110,647 1,973,198 2,092,922 209,241 117,755 122,783 6,626,546 44%
0312C 001 AMERICAN EMBASSY 836,796 121,097 303,488 3,087 845 1,265,313 8%
0312D 001 AMERICAN EMBASSY 12,987 79,389 172,709 4,640 4,033 273,758 2%
0312E 001 AMERICAN EMBASSY 224,774 153,490 189,997 6,937 8,485 7,266 590,950 4%
0312F 001 AMERICAN EMBASSY 17,834 16,739 61,072 818 96,463 1%
0312G 001 AMERICAN EMBASSY 9,632 6,840 23,420 990 685 41,567 0%
0312H 001 AMERICAN EMBASSY 15,959 14,249 4,911 1,000 45 36,164 0%
0312I 001 AMERICAN EMBASSY USAID 165,043 158,583 185,205 11,981 1,915 1,805 524,531 3% 0312J 001 AMERICAN EMBASSY USAID 17,763 116,186 125,198 2,500 1,754 7,658 271,058 2%
0312K 001 AMERICAN EMBASSY 892 233 1,126 0%
Total 5,019,841 4,057,328 5,359,907 256,037 213,588 229,426 0 15,136,128 100% Inpatient
33%
Outpatient 27%
Op Medication 35%
Maternity 2%
Dental 1%
Optical 2%
Inpatient 33%
Outpatient 27%
Op Medication 35%
Maternity 2%
Dental 1%
Optical 2%
Op Medication Maternity Dental Optical Other Services
User: Maged Hamdy 2 of 13 Mar 3, 2021 5:33:37 PM
Paid date from : 2018-05-01 to : 2018-10-31
Monthly Claims Paid Amount
Year- Month
Inpatient Outpatient Op Medication
Maternity Dental Optical Other Services
Total
May-2018 819,543 952,381 783,276 40,363 99,179 74,703 0 2,769,444 Jun-2018 479,698 595,038 1,016,052 33,950 69,684 55,474 1,379 2,251,275 Jul-2018 575,395 571,587 891,159 31,957 88,088 29,784 -1,379 2,186,592 Aug-2018 1,496,474 584,132 894,730 79,529 95,834 22,070 3,172,768 Sep-2018 842,550 842,722 848,855 90,242 69,766 20,595 2,714,729 Oct-2018 1,226,842 741,198 959,351 102,173 86,307 101,166 3,217,037 Total 5,440,502 4,287,059 5,393,422 378,213 508,858 303,792 0 16,311,846
-500,000
500,000
1,000,000
1,500,000
2,000,000
2,500,000
3,000,000
3,500,000
May-2018 Jun-2018 Jul-2018 Aug-2018 Sep-2018 Oct-2018
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-2018 61 3,420 2,967 95 195 112 1 Jun-2018 51 2,095 3,594 64 145 110 3 Jul-2018 40 2,254 2,907 63 161 40 4 Aug-2018 80 2,359 3,215 93 193 48 Sep-2018 57 2,903 2,984 95 132 50 Oct-2018 92 2,798 3,239 101 188 141 Total 381 15,829 18,906 511 1,014 501 8
1,000
2,000
3,000
4,000
5,000
6,000
7,000
8,000
May-2018 Jun-2018 Jul-2018 Aug-2018 Sep-2018 Oct-2018
Benefit_Category Inpatient Outpatient Op Medication Maternity Dental Optical Other Services
Year-Month
Cl ai m _c ou nt
User: Maged Hamdy 3 of 13 Mar 3, 2021 5:33:37 PM
Paid date from : 2018-05-01 to : 2018-10-31
Claims based on Paid Amount Range
Paid Amount Range No.of claims %of total claims Paid Amount % of Total
<= 250 25,333 69% 2,731,168 17%
251-500 5,471 15% 1,956,032 12%
501-1000 4,248 12% 3,055,680 19%
1001-2500 1,178 3% 1,691,281 10%
2501-5000 253 1% 912,158 6%
5001-10000 183 0% 1,229,766 8%
>=10000 161 0% 4,735,761 29%
Total 36,827 100% 16,311,846 100%
Top 10 Daignosis Codes based on Paid Amount
Top 10 Diagnosis Number of Claimant
Paid Amount % to Total
DIABETES MELLITUS (DM) 379 1,187,285 7%
HYPERTENSION 444 727,492 4%
DENTAL 787 515,181 3%
RESPIRATORY DISTRESS SYNDROME 5 488,772 3%
ISCHEMIC HEART DISEASE (IHD) 121 481,775 3%
BREAST TUMOR - MALIGNANT -FEMALE 12 474,172 3%
LUMBAGO / LOW BACK PAIN 851 446,605 3%
OSTEOARTHRITIS 372 352,585 2%
HYPERLIPIDEMIA 361 319,922 2%
OPTICAL 483 311,276 2%
Top 10 5,305,065 33%
Others 11,006,781 67%
Summary 16,311,846 100%
User: Maged Hamdy 4 of 13 Mar 3, 2021 5:33:37 PM
Paid date from : 2018-05-01 to : 2018-10-31
Top 10 Claimant based on Paid Amount
Top 10 Claimant
Paid Amount % of Total
Major Conditions
1 239,822 1% ANAEMIA UNSPECIFIC
ARTHROPATHY / ARTHRITIS
CATARRH / COLD / CORYZA / NASOPHARYNTIGIS /RHINOPHARINGITIS
CEREBROVASCULAR DISEASE ( STROKE )
CHRONIC INFLAMMATORY DEMYELINATING POLYNEURITIS
CYSTIC FIBROSIS
DIABETES MELLITUS (DM)
DIABETES WITH KETOACIDOSIS
FOLLOW-UP EXAMINATION FOLLOWING SURGERY UNSPECIFIED
HEADACHE / HEAD PAIN
HYPERTENSION
INTERVERTEBRAL DISC
ISCHEMIC HEART DISEASE (IHD)
JOINT PAIN
KNEE PAIN
LUMBAGO / LOW BACK PAIN
NEURALGIA / NEURITIS
NEUROPATHY UNSPECIFIC
OSTEOARTHRITIS
OTHER FOLLOW-UP EXAMINATION
POLYDACTYLY OF FINGERS
RENAL COLIC
SPONDYLOSIS, CERVICAL
SPONDYLOSIS, LUMBOSACRAL
UNSPECIFIED INFLAMMATORY AND TOXIC NEUROPATHY
WOUND
2 232,102 1% ABDOMINAL PAIN
ABNORMAL LEVEL OF BLOOD / LIVER ENZYME.
ALLERGIC RHINITIS / RHINORRHEA / HAY FEVER
ANAEMIA IRON DEFICIENCY
ANEMIA UNSPECIFIED
ARTHROPATHY / ARTHRITIS
BRONCHIAL ASTHMA
BRONCHITIS, ACUTE
DENTAL
DIABETES MELLITUS (DM)
DIARRHAEA
User: Maged Hamdy 5 of 13 Mar 3, 2021 5:33:37 PM
Paid date from : 2018-05-01 to : 2018-10-31
Top 10 Claimant based on Paid Amount
Top 10 Claimant
Paid Amount % of Total
Major Conditions
2 232,102 1% GASTRITIS
GASTROENTERITIS / ENTERITIS OR COLITIS
GOUT / HYPERURICEMIA
HELICOBACTER PYLORI INFECTION
HYPOCALCEMIA
ILLNESS OF UNKNOWN REASON / UNSPECIFIED CONDITIONS
IMMUNE THROMBOCYTOPENIC PURPURA
IRRITABLE COLON / IRRITABLE BOWEL SYNDROME (IBS)
MALAISE / FATIGUE
PALLOR
PANCYTOPENIA
PEPTIC ULCER
PHARYNGITIS
REFLUX ESOPHAGITIS
SORE THROAT / PHARYNGITIS, ACUTE
THROMBOCYTOPENIA
TONSILLITIS, ACUTE
UNSPECIFIED FUNCTIONAL DISORDER OF INTESTINE
URTICARIA
VITAMIN D DEFICIENCY (RICKETS)
3 218,289 1% ARTHROPATHY / ARTHRITIS
ASPRAINS AND STRAINS NKLE / ANKLE & FOOT SPRAIN
BREAST TUMOR - MALIGNANT -FEMALE
ILLNESS OF UNKNOWN REASON / UNSPECIFIED CONDITIONS
LUMBAGO / LOW BACK PAIN
URINARY TRACT INFECTION (UTI)
4 200,000 1% RESPIRATORY DISTRESS SYNDROME
5 196,625 1% ANGINA PECTORIS
ARTHROPATHY / ARTHRITIS
BRONCHIAL ASTHMA
CEREBROVASCULAR DISEASE ( STROKE )
DENTAL
DIABETES MELLITUS (DM)
DRY EYE
HEADACHE / HEAD PAIN
HYPERTENSION
INTERVERTEBRAL DISC
User: Maged Hamdy 6 of 13 Mar 3, 2021 5:33:37 PM
Paid date from : 2018-05-01 to : 2018-10-31
Top 10 Claimant based on Paid Amount
Top 10 Claimant
Paid Amount % of Total
Major Conditions
5 196,625 1% ISCHEMIC HEART DISEASE (IHD)
LUMBAGO / LOW BACK PAIN
OPTICAL
SCIATICA / SCIATIC PAIN
SHOULDER PAIN
SPRAIN UNSPECIFIC
UPPER RESPIRATORY INFECTION (URTI / URI)
VERTIGO / DIZZINESS / GIDDINESS
6 180,000 1% POST LIVER TRANSPLANT
7 171,622 1% ABDOMINAL PAIN
ABNORMAL LEVEL OF BLOOD / LIVER ENZYME.
BREAST TUMOR - MALIGNANT -FEMALE
CATARRH / COLD / CORYZA / NASOPHARYNTIGIS /RHINOPHARINGITIS
DIABETES MELLITUS (DM)
GASTRITIS
GASTROENTERITIS / ENTERITIS OR COLITIS
GENERALIZED WEAKNESS
GLAUCOMA
HYPERTENSION
ILLNESS OF UNKNOWN REASON / UNSPECIFIED CONDITIONS
IRRITABLE COLON / IRRITABLE BOWEL SYNDROME (IBS)
LUMBAGO / LOW BACK PAIN
NEURALGIA / NEURITIS
PELVIC PAIN / LOWER ABDOMINAL PAIN
TINEA
TUMOR - MALIGNANT (UNSPECIFIED)
UNSPECIFIED DISORDER OF LIVER
VERTIGO / DIZZINESS / GIDDINESS
VITAMIN D DEFICIENCY (RICKETS)
WOUND
8 161,307 1% ABNORMAL LEVEL OF BLOOD / LIVER ENZYME.
BRONCHITIS, ACUTE
CATARRH / COLD / CORYZA / NASOPHARYNTIGIS /RHINOPHARINGITIS
DERMATITIS (& CONTACT) / ECZEMA
FATTY LIVER
FOLLOW-UP EXAMINATION FOLLOWING OTHER SURGERY
HEADACHE / HEAD PAIN
User: Maged Hamdy 7 of 13 Mar 3, 2021 5:33:37 PM
Paid date from : 2018-05-01 to : 2018-10-31
Top 10 Claimant based on Paid Amount
Top 10 Claimant
Paid Amount % of Total
Major Conditions
8 161,307 1% HEPATOMEGALY / LIVER HYPERTROPHY
KIDNEY TRANSPLANTATION
POST HEART TRANSPLANT
POST LIVER TRANSPLANT
RENAL FAILURE, CHRONIC
9 160,013 1% ABDOMINAL PAIN
APPENDICITIS
BENIGN CARCINOID TUMOR OF THE APPENDIX
BRONCHITIS, ACUTE
CHEST PAIN (UNSPECIFIC REASON)
CLAVICLE FRACTURE - OPEN
DENTAL
DIABETES MELLITUS (DM)
IRRITABLE COLON / IRRITABLE BOWEL SYNDROME (IBS)
LARGE BOWEL / COLON TUMOR - BENIGN
MALAISE / FATIGUE
MALIGNANT CARCINOID TUMOR OF THE APPENDIX
NEED FOR OTHER SPECIFIED PROPHYLACTIC MEASURE
OVARIAN TUMOR - MALIGNANT
PERIPHERAL VASCULAR DISEASE / ISCHEMIA
TUMOR - MALIGNANT (UNSPECIFIED)
UNSPECIFIED GASTRITIS AND GASTRODUODENITIS WITHOUT MENTION OF HEMORRHAGE
UTERUS TUMOR - MALIGNANT
WOUND
10 139,398 1% ABDOMINAL PAIN
ALLERGY
ANAEMIA IRON DEFICIENCY
ARTHROPATHY / ARTHRITIS
BACK PAIN
BEHCET'S SYNDROME
BRONCHITIS, ACUTE
CATARRH / COLD / CORYZA / NASOPHARYNTIGIS /RHINOPHARINGITIS
CEREBROVASCULAR DISEASE ( STROKE )
CHEST PAIN (UNSPECIFIC REASON)
CONJUNCTIVITIS, ACUTE
CONSTIPATION
DERMATITIS (& CONTACT) / ECZEMA
User: Maged Hamdy 8 of 13 Mar 3, 2021 5:33:37 PM
Paid date from : 2018-05-01 to : 2018-10-31
Top 10 Claimant based on Paid Amount
Top 10 Claimant
Paid Amount % of Total
Major Conditions
10 139,398 1% DIABETES MELLITUS (DM)
DYSFUNCTIONAL UTERINE BLEEDING (DUB)
DYSPLASIA OF VAGINA
GASTRITIS
GASTROENTERITIS / ENTERITIS OR COLITIS
HERNIA, INGUINAL
HYPERLIPIDEMIA
HYPERTENSION
INTERVERTEBRAL DISC
IRRITABLE COLON / IRRITABLE BOWEL SYNDROME (IBS)
ISCHEMIC HEART DISEASE (IHD)
LUMBAGO / LOW BACK PAIN
NECK PAIN / CERVICALGIA
NEURALGIA / NEURITIS
OSTEOPOROSIS
OTITIS MEDIA
PELVIC PAIN / LOWER ABDOMINAL PAIN
PEPTIC ULCER
PITYRIASIS / TINEA VERSICOLOR
REFLUX ESOPHAGITIS
RENAL COLIC
RHEUMATOID ARTHRITIS
TINEA
ULCERATIVE COLITIS
UNSPECIFIED GASTRITIS AND GASTRODUODENITIS WITHOUT MENTION OF HEMORRHAGE
URINARY TRACT INFECTION (UTI)
URINARY-GENITAL TRACT FISTULA FEMALE
URTICARIA
VITILIGO
WOUND
Top 10 1,899,179 12%
Others 14,412,667 88%
Summary 16,311,846 100%
User: Maged Hamdy 9 of 13 Mar 3, 2021 5:33:37 PM
Paid date from : 2018-05-01 to : 2018-10-31
Top 10 Providers based on Paid Amount
Top 10 Providers Paid Amount Claim_Count % of Total
AS-SALAM INT'L HOSPITAL 2,302,407 541 15%
EZABY PHARMACY 1,563,007 3,313 10%
Al Nakheel Hospital 1,317,665 601 9%
Dr. El Hakim Pharmacy 834,614 1,817 6%
ANEES & RAMZY PHARMACY 715,865 1,625 5%
CLEOPATRA HOSPITAL 647,877 281 4%
SAUDI GERMAN HOSPITAL 598,630 272 4%
DR. KAMAL HUSSIEN PHARMACY 441,982 703 3%
ROUSHDY PHARMACIES 356,137 1,257 2%
CAIRO MEDICAL CENTRER 346,701 185 2%
Top 10 9,124,884 61%
User: Maged Hamdy 10 of 13 Mar 3, 2021 5:33:37 PM
Paid date from : 2018-05-01 to : 2018-10-31
001 AMERICAN EMBASSY
Top 10 Providers Paid Amount % of Total
AS-SALAM INT'L HOSPITAL 2,196,965 15%
EZABY PHARMACY 1,505,422 10%
Al Nakheel Hospital 1,262,610 9%
Dr. El Hakim Pharmacy 831,690 6%
CLEOPATRA HOSPITAL 627,496 4%
SAUDI GERMAN HOSPITAL 583,357 4%
ANEES & RAMZY PHARMACY 555,810 4%
DR. KAMAL HUSSIEN PHARMACY 436,375 3%
CAIRO MEDICAL CENTRER 346,551 2%
ROUSHDY PHARMACIES 342,310 2%
Top 10 8,688,586 61%
Others 5,651,953 39%
001 AMERICAN EMBASSY 14,340,538 100%
001 AMERICAN EMBASSY USAID
Top 10 Providers Paid Amount % of Total
ANEES & RAMZY PHARMACY 160,056 20%
AS-SALAM INT'L HOSPITAL 105,442 13%
AL SALAM HOSPITAL 68,040 9%
EZABY PHARMACY 57,585 7%
Al Nakheel Hospital 55,054 7%
Alfa Lab 43,023 5%
ALFA SCAN 33,220 4%
Eye Subspeciality Center 23,632 3%
CLEOPATRA HOSPITAL 20,380 3%
SEIF PHARMACY 18,696 2%
Top 10 585,128 74%
Others 210,461 26%
001 AMERICAN EMBASSY USAID 795,590 100%
User: Maged Hamdy 11 of 13 Mar 3, 2021 5:33:37 PM
Paid date from : 2018-05-01 to : 2018-10-31
CASH Claims Detail CASH Claims - Paid Amount Paid Amount america 001 AMERICAN EMBASSY 2,963
Sub total 2,963
Country 001 AMERICAN EMBASSY 1,021,451
AMERICAN EMBASSY USAID 151,304
Sub total 1,172,755
Total 1,175,718
CASH Claims - Claim Count Claim_Count america 001 AMERICAN EMBASSY 2
Sub total 2
Country 001 AMERICAN EMBASSY 1,303
AMERICAN EMBASSY USAID 249
Sub total 1,552
Total 1,554
PPO Claims Detail PPO Claims - Paid Amount Paid Amount
Country 001 AMERICAN EMBASSY 14,340,538
AMERICAN EMBASSY USAID 795,590
Sub total 15,136,128
Total 15,136,128
PPO Claims - Claim Count Claim_Count
Country 001 AMERICAN EMBASSY 36,794
AMERICAN EMBASSY USAID 2,036
Sub Total 38,830
Total 38,830
User: Maged Hamdy 12 of 13 Mar 3, 2021 5:33:37 PM
Paid date from : 2018-05-01 to : 2018-10-31
Claims by Insured Type Insured Op Medication Outpatient Inpatient Maternity Dental Optical Other Services Total % of Total
Employees 2,936,851 1,905,106 2,531,297 72,530 217,380 117,746 0 7,780,910 48%
Spouse 1,715,744 1,319,028 1,715,829 305,594 136,324 84,040 5,276,559 32%
Child 740,828 1,062,924 1,193,377 89 155,154 102,005 0 3,254,377 20%
Total 5,393,422 4,287,059 5,440,502 378,213 508,858 303,792 0 16,311,846 100%
Claims by Age Range Age Range Paid Amount Claim count
Male Female Total Female Male Total
Under 21 1,341,982 962,370 2,304,352 4,124 4,602 8,726
21-25 481,624 318,923 800,547 1,098 613 1,711
26-30 115,968 335,802 451,769 893 409 1,302
31-35 224,611 509,432 734,043 1,642 909 2,551
36-40 523,952 713,701 1,237,653 1,876 1,679 3,555
41-45 1,368,354 1,242,038 2,610,392 2,185 2,408 4,593
46-50 1,059,663 1,012,057 2,071,720 2,168 2,484 4,652
51-55 1,033,412 944,643 1,978,055 1,365 2,241 3,606
56-60 1,603,407 631,647 2,235,054 1,168 2,558 3,726
61-65 1,275,625 525,269 1,800,895 533 1,719 2,252
66-69 67,338 9,241 76,579 37 94 131
70 and above 10,653 134 10,787 1 21 22
Total 9,106,589 7,205,256 16,311,846 17,090 19,737 36,827
Note: All amounts are in Policy Currency
User: Maged Hamdy 13 of 13 Mar 3, 2021 5:33:37 PM
File details come from the government source that posted it. Updated .