Section J - List of Exhibits.xlsx

XLSX spreadsheet 44 KB Posted Aug 2, 2022

Attached to: Health & Life Insurance Services for U. S. Embassy Panama
Solicitation number: 19PM0722R0001
Issued by: Department of State

View the file

Other files

File	Type	Posted
HL_SF30_0006_123022.pdf	PDF	Dec 30, 2022
HL_SF30_0005_121322.pdf	PDF	Dec 13, 2022
HL_SF30_0004_110922.pdf	PDF	Nov 9, 2022
HL_SF30_0003_100522.pdf	PDF	Oct 5, 2022
Panama QA2 Response 100522.docx	DOCX document	Oct 5, 2022
Updated Section J List of Exhibits.xlsx	XLSX spreadsheet	Sep 8, 2022
HL_PreproposalMinutes.pdf	PDF	Sep 8, 2022
HL_QA1_090722.docx	DOCX document	Sep 8, 2022
HL_SF30_A002_090722.pdf	PDF	Sep 8, 2022
HL_SF30_A001_083022.pdf	PDF	Aug 30, 2022
HL_RFQLetter signed.pdf	PDF	Aug 2, 2022
HL_22R0001_Solicitation 080122.pdf	PDF	Aug 2, 2022

Show all 12

On GovTribe

Work with this file

Download the original file
Contacts named in this file
Similar government files
Ask GovTribe AI about this file

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

EXHIBIT A - EMPLOYEE STATISTIC

FEMALE		MALE
Age	Annual Salary	Age	Annual Salary
22	13,845.00	23	8,793.00
24	20,121.00	24	9,655.00
29	21,965.00	27	10,673.00
30	21,965.00	27	10,673.00
30	21,965.00	27	9,655.00
30	33,512.00	27	11,865.00
30	28,679.00	29	10,539.00
31	27,523.00	29	25,211.00
32	13,845.00	29	44,157.00
32	8,793.00	30	26,367.00
32	26,367.00	31	30,696.00
33	23,809.00	31	16,385.00
34	15,826.00	31	9,655.00
34	29,835.00	32	14,480.00
35	30,991.00	32	29,835.00
36	28,679.00	33	16,385.00
36	21,965.00	34	16,551.00
36	48,029.00	34	33,512.00
37	39,083.00	35	17,276.00
37	25,211.00	35	15,826.00
37	25,653.00	35	27,523.00
37	46,093.00	35	51,348.00
38	20,121.00	35	10,673.00
38	15,826.00	35	47,592.00
39	42,221.00	35	10,673.00
40	20,121.00	35	20,121.00
40	65,478.00	36	17,276.00
41	36,771.00	36	16,041.00
41	21,965.00	37	33,512.00
42	21,965.00	37	17,655.00
42	8,793.00	37	28,679.00
42	13,845.00	37	33,512.00
42	79,608.00	37	17,020.00
43	34,459.00	38	14,959.00
43	8,793.00	38	15,173.00
43	25,211.00	38	20,901.00
43	72,543.00	38	47,592.00
43	39,144.00	38	11,161.00
45	24,526.00	38	18,925.00
46	19,451.00	39	8,793.00
46	25,211.00	39	15,553.00
46	42,221.00	39	27,497.00
47	39,083.00	39	10,673.00
47	8,793.00	39	25,211.00
47	8,793.00	40	20,901.00
47	39,083.00	40	53,703.00
48	24,731.00	40	13,845.00
48	55,773.00	40	27,523.00
48	25,211.00	40	27,523.00
49	30,263.00	41	15,750.00
49	45,533.00	41	13,845.00
49	45,533.00	41	65,453.00
49	47,592.00	42	16,041.00
49	27,497.00	42	14,577.00
50	44,776.00	42	13,113.00
50	65,453.00	42	19,135.00
50	61,581.00	42	43,368.00
50	21,043.00	42	12,909.00
50	8,793.00	43	35,615.00
50	34,459.00	43	11,423.00
50	42,221.00	43	32,147.00
52	109,018.00	43	20,195.00
52	25,653.00	43	51,901.00
52	51,901.00	43	16,041.00
52	30,263.00	43	44,776.00
52	26,575.00	43	14,577.00
52	57,709.00	43	16,529.00
52	28,679.00	43	28,419.00
53	51,901.00	44	11,423.00
53	65,453.00	44	10,673.00
53	19,451.00	44	13,601.00
53	44,776.00	44	16,041.00
54	36,328.00	45	35,165.00
54	65,453.00	45	12,137.00
54	47,592.00	45	33,521.00
54	44,776.00	45	25,211.00
54	109,018.00	45	14,041.00
55	35,615.00	46	13,475.00
55	8,793.00	46	17,437.00
56	21,965.00	46	23,809.00
56	23,809.00	46	23,801.00
56	47,592.00	46	33,303.00
56	39,083.00	46	28,679.00
57	79,608.00	46	22,351.00
57	44,776.00	47	22,887.00
57	31,185.00	47	59,645.00
57	28,679.00	47	83,226.00
57	105,794.00	48	19,135.00
58	39,083.00	48	24,731.00
58	31,185.00	48	53,703.00
58	47,592.00	48	24,526.00
58	51,901.00	49	18,569.00
59	39,083.00	49	8,793.00
60	46,093.00	49	11,865.00
60	57,709.00	49	14,041.00
61	43,368.00	49	22,351.00
61	39,083.00	49	39,083.00
61	74,898.00	49	46,184.00
64	31,185.00	49	65,453.00
65	30,263.00	49	61,581.00
65	65,453.00	50	15,115.00
67	65,453.00	50	16,385.00
68	31,185.00	50	13,601.00
70	39,083.00	51	36,771.00
		51	24,731.00
		51	47,592.00
		51	22,351.00
		51	12,625.00
		52	39,083.00
		52	16,041.00
		52	12,137.00
		52	11,161.00
		52	11,649.00
		53	74,898.00
		53	34,459.00
		53	25,656.00
		53	15,750.00
		54	16,529.00
		54	25,653.00
		55	59,645.00
		55	65,453.00
		55	16,529.00
		55	23,076.00
		55	21,465.00
		55	29,835.00
		55	33,303.00
		55	61,581.00
		56	14,959.00
		56	21,465.00
		57	19,135.00
		57	19,135.00
		57	13,601.00
		57	24,526.00
		57	12,625.00
		57	14,959.00
		57	65,453.00
		57	39,083.00
		57	19,135.00
		58	21,626.00
		58	21,465.00
		58	20,830.00
		58	19,135.00
		59	14,959.00
		59	31,185.00
		59	8,793.00
		59	15,826.00
		59	14,959.00
		59	19,135.00
		60	35,615.00
		60	20,176.00
		60	8,793.00
		60	16,529.00
		61	65,453.00
		61	15,826.00
		61	11,649.00
		61	21,465.00
		62	47,592.00
		62	21,465.00
		62	16,529.00
		62	21,465.00
		62	17,020.00
		62	79,608.00
		63	19,135.00
		63	21,465.00
		63	21,465.00
		63	11,865.00
		64	19,135.00
		64	20,830.00
		64	23,076.00
		64	79,608.00
		64	22,960.00
		66	12,625.00
		67	21,626.00

&14

&"Calibri"&11&K000000 &1#&"Times New Roman"&10&K000000SENSITIVE BUT UNCLASSIFIED

EXHIBIT B-ORE EMPLOYEES RIDER

AMB Residence Staff
Gender	Age	Annual Salaries

F	52	$18,540.00
M	56	$12,360.00
M	70	$9,900.00
M	52	$25,200.00
M	58	$7,512.00

Future Staff
M	57	$11,124.00
F		$7,512.00

DCM Residence Staff

M	53	$13,596.00
F	54	$9,579.00
F	56	$8,652.00

EXHIBIT C-AERA EMPLOYEES RIDER

FEMALE
Age	Annual Salaries
21	$7,380.00
30	$4,900.00
33	$23,640.00
45	$9,600.00

EXHIBIT D–GRANDFATHERED RETIREE

MALE	FEMALE
Age	Age
62	59
65	62
66	65
	66
	68
	69
	71
	71
	73
	74
	79

&14

&"Calibri"&11&K000000 &1#&"Times New Roman"&10&K000000SENSITIVE BUT UNCLASSIFIED

EXHIBIT E – CLAIMS PAID

EMBASSY OF THE UNITED STATES OF AMERICA, PANAMA

GROUP LIFE AND HEALTH

CLAIMS PAID REPORT

CLAIMS PAID PER CATEGORY

2018 - 2019			EMPLOYEES	RETIREES
Month	Life Insurance Reimbursement	Health Insurance Reimbursement	Health Insurance Reimbursement	Health Insurance Reimbursement
Dec-2018	- 0	17,481.06	16,125.74	1,355.32
Jan-2019	- 0	40,359.77	36,838.59	3,521.18
Feb-2019	- 0	48,645.78	47,232.13	1,413.65
Mar-2019	- 0	26,250.78	25,854.63	396.15
Apr-2019	- 0	30,421.07	30,253.19	167.88
May-2019	- 0	61,653.27	60,726.07	927.20
Jun-2019	- 0	38,725.57	36,005.70	2,719.87
Jul-2019	- 0	37,214.08	36,971.35	242.73
Aug-2019	- 0	42,059.09	41,542.22	516.87
Sep-2019	- 0	29,742.68	27,059.42	2,683.26
Oct-2019	- 0	36,899.54	35,788.43	1,111.11
Nov-2019	- 0	22,108.08	21,685.45	422.63
TOTAL	- 0	431,560.77	416,082.92	15,477.85

2019 - 2020			EMPLOYEES	RETIREES
Month	Life Insurance Reimbursement	Health Insurance Reimbursement	Health Insurance Reimbursement	Health Insurance Reimbursement
Dec-2019	- 0	25,500.25	18,451.17	7,049.08
Jan-2020	- 0	73,670.65	69,074.57	4,596.08
Feb-2020	- 0	24,402.56	21,011.51	3,391.05
Mar-2020	- 0	69,996.23	66,140.73	3,855.50
Apr-2020	- 0	53,779.01	52,814.38	964.63
May-2020	- 0	24,045.40	23,532.38	513.02
Jun-2020	- 0	27,245.17	26,958.72	286.45
Jul-2020	- 0	29,128.44	23,016.89	6,111.55
Aug-2020	- 0	30,017.80	27,380.42	2,637.38
Sep-2020	- 0	42,042.49	38,099.46	3,943.03
Oct-2020	- 0	30,761.48	25,430.76	5,330.72
Nov-2020	- 0	50,231.37	43,066.13	7,165.24
TOTAL	- 0	480,820.85	434,977.12	45,843.73

2020 - 2021			EMPLOYEES	RETIREES
Month	Life Insurance Reimbursement	Health Insurance Reimbursement	Health Insurance Reimbursement	Health Insurance Reimbursement
Dec-2020	- 0	61,387.14	28,614.79	32,772.35
Jan-2021	- 0	41,933.02	36,338.20	5,594.82
Feb-2021	- 0	34,775.04	24,911.59	9,863.45
Mar-2021	- 0	29,232.66	14,932.88	14,299.78
Apr-2021	- 0	7,616.66	6,310.03	1,306.63
May-2021	- 0	94,129.24	84,976.99	9,152.25
Jun-2021	- 0	116,558.06	110,793.90	5,764.16
Jul-2021	- 0	91,340.47	78,856.89	12,483.58
Aug-2021	- 0	129,833.61	70,922.39	58,911.22
Sep-2021	- 0	41,203.01	38,608.01	2,595.00
Oct-2021	- 0	60,742.01	58,587.00	2,155.01
Nov-2021	- 0	40,558.80	39,171.21	1,387.59
TOTAL	- 0	749,309.72	593,023.88	156,285.84

2021 - 2022			EMPLOYEES	RETIREES
Month	Life Insurance Reimbursement	Health Insurance Reimbursement	Health Insurance Reimbursement	Health Insurance Reimbursement
Dec-2021	- 0	64,029.57	60,419.56	3,610.01
Jan-2022	- 0	63,712.43	62,547.76	1,164.67
Feb-2022	- 0	57,873.29	55,774.03	2,099.26
Mar-2022	- 0	41,652.98	39,109.89	2,543.09
Apr-2022	- 0	37,893.41	34,887.79	3,005.62
May-2022	- 0	34,884.61	31,067.54	3,817.07
Jun-2022	- 0	169,959.99	166,656.78	3,303.21
TOTAL	- 0	470,006.28	450,463.35	19,542.93

TOTAL - 0 2,131,697.62

&1#&"Times New Roman"&10&K000000SENSITIVE BUT UNCLASSIFIED

File details come from the government source that posted it. Updated Aug 2, 2022.