Sugar CQE Analysis at Posts

---

Overview

Western Hemisphere
Total World

---

Sheet 1: Western Hemisphere

Post	Position	Time Per Month (Hours)	Time Per Year (Hours)	Hourly Salary	Annual Salary	Total Cost (Hours * Hourly Salary)
Colombia	Counselor	0.5	6	$65.86		$395.16
Colombia	Attache	1.5	18	$39.85		$717.30
Colombia	Ag. Specialist	10	120	$38.61	$80,316	$4,633.62
Colombia	Clerk/Messanger	3	36	$6.73	$14,005	$242.39
Colombia, Total						$5,988.47
Argentina	Counselor	2	24	$65.86		$1,580.64
Argentina	Ag. Specialist	2	24	$32.52	$67,636	$780.42
Argentina	Clerk/Messanger	6	72	$15.00	$31,207	$1,080.24
Argentina, Total						$3,441.30
Brazil	Counselor	1	12	$65.86		$790.32
Brazil	Attache	0.25	3	$39.85		$119.55
Brazil	Ag. Specialist	6	72	$18.63	$38,760	$1,341.69
Brazil, Total						$2,251.56
Canada	Attache	0.25	3	$47.38		$142.14
Canada	Ag. Specialist	0.25	3	$50.95	$105,976	$152.85
Canada	Admin.	0.5	6	$40.07	$83,349	$240.43
Canada, Total						$535.42
Peru	Ag. Specialist	8	96	$43.96	$91,444	$4,220.49
Peru	Clerk/Messanger	1	12	$15.61	$32,462	$187.28
Ecuador	Ag. Specialist	1	12	$21.59	$44,916	$259.13
Dominican Republic	Ag. Specialist	0.1	1.2	$23.91	$49,740	$28.70
Dominican Republic	Clerk/Messanger	0.5	6	$5.48	$11,400	$32.88
Guatemala	Counselor	0.5	6	$65.86		$395.16
Guatemala	Attache	0.5	6	$39.85		$239.10
Guatemala	Ag. Specialist	0.75	9	$36.46	$75,844	$328.17
Guatemala	Marketing Specialist	1	12	$31.71	$65,965	$380.57
Guatemala	Admin.	0.25	3	$15.33	$31,889	$45.99
Costa Rica	Counselor	0.25	3	$65.86		$197.58
Costa Rica	Attache	0.5	6	$47.38		$284.28
Costa Rica	Ag. Specialist	2	24	$49.35	$102,652	$1,184.45
Costa Rica	Clerk/Messanger	0.5	6	$7.39	$15,371	$44.34
Panama	Ag. Specialist	2	24	$29.60	$61,568	$710.40
Panama	Admin.	1	12	$16.60	$34,532	$199.22
Nicaragua	Ag. Specialist	2	24	$15.59	$32,428	$374.17
			661
					Total	$27,799.34

---

Sheet 2: Total World

Post (Red means no CQEs issued.) (Purple means FTA CQEs issued.)	FY 2019 Number of CQEs	Position	Time Per Month (Hours)	Time Per Year (Hours)	Hourly Salary	Annual Salary	Total Cost (Hours * Hourly Salary)
Argentina	50
		See worksheet one
Australia	25
		Ag. Specialist	1	12	$15.59	$32,428	$187.08
		Attache	0.5	6	$47.38		$284.28
		Counselor	1	12	$65.86		$790.32
		Subtotal		30			$1,261.68
Barbados	5
		Ag. Specialist	0.5	6	$15.59		$93.54
Belize	10
		Ag. Specialist	1	12	$15.59	$32,428	$187.08
Bolivia	15
		Ag. Specialist	1.5	18	$15.59	$32,428	$280.63
Brazil	50
		See worksheet one
Canada	700
		See worksheet one
Colombia	650
		See worksheet one
Congo, Brazzaville	0
Costa Rica	15
		See worksheet one
Cote d'Ivoire	0
Dominican Republic	100
		See worksheet one
Ecuador	20
		See worksheet one
El Salvador	25
		Ag. Specialist	3	36	$15.59	$32,428	$561.25
		Attache	0.25	3	$47.38		$142.14
		Subtotal		39			$703.39
Eswatini, Swaziland	35	Ag. Specialist	4	48	$15.59	$32,428	$748.34
Fiji	10	Ag. Specialist	1	12	$15.59	$32,428	$187.08
Gabon	0
Guatemala	70
		See worksheet one
Guyana	20	Ag. Specialist	1.5	18	$15.59	$32,428	$280.63
Haiti	0
Honduras	30
		Ag. Specialist	2	24	$15.59	$32,428	$374.17
		Attache	0.5	6	$47.38		$284.28
		Subtotal		30			$658.45
India	100
		Ag. Specialist	4	48	$15.59	$32,428	$748.34
		Attache	2	24	$47.38		$1,137.12
		Counselor	0.5	6	$65.86		$395.16
		Subtotal		78			$2,280.62
Jamaica	15	Ag. Specialist	1.5	18	$15.59	$32,428	$280.63
Madagascar	0
Malawi	200
		Ag. Specialist	3	36	$15.59	$32,428	$561.25
Mauritius	200	Ag. Specialist	3	36	$15.59	$32,428	$561.25
Mexico	0
Mozambique	25
		Ag. Specialist	2	24	$15.59	$32,428	$374.17
Nicaragua	25
		See worksheet one
Panama	60
		See worksheet one
Papua New Guinea	0
Paraguay	100
		Ag. Specialist	4	48	$15.59	$32,428	$748.34
		Attache	1	12	$47.38		$568.56
		Counselor	0.25	3	$65.86		$197.58
				63			$1,316.90
Peru	15
		See worksheet one
Philippines	100
		Ag. Specialist	4	48	$15.59	$32,428	$748.34
		Attache	2	24	$47.38		$1,137.12
		Counselor	2	24	$65.86		$1,580.64
		Subtotal		96			$3,466.10
South Africa	15
		Ag. Specialist	1.5	18	$15.59	$32,428	$280.63
		Attache	0.25	3	$47.38		$142.14
		Subtotal		21			$422.77
St. Kitts and Nevis	0
Taiwan	0
Thailand	25
		Ag. Specialist	2	24	$15.59	$32,428	$374.17
		Attache	0.5	6	$47.38		$284.28
		Subtotal		30			$658.45
Trinidad-Tobago	0
Uruguay	0
Zimbabwe	6
		Ag. Specialist	0.5	6	$15.59		$93.54
Total WTO	2,716
Total FTA	1,000
Grand Total	3,716
Western Hemisphere				661			$21,328.66
Rest of World				621			$14,416.51
Grand Total				1,282			$35,745.17