Sightsavers' cost per treatment analysis [2018]

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z
1		Totals				Nigeria 4 States			Nigeria Benue			Guinea Conakry			Guinea-Bissau			DRC			Cameroon				Nigeria - Yobe State
2		Grand total	All 2017	All 2018	All 2019	2017	2018	2019	2017	2018	2019	2017	2018	2019	2017	2018	2019	2017	2018	2019	2017	2018	2019	2017	2018	2019

3	Costs
4	Capital Expenditure	$114,899	$66,987	$47,912	$0	$0	$37,064	$0	$40,285	$10,848		$24,056	$0	$0	$2,646	$0		$0	$0	$0	$0	$0	$0		$0	$0
5	Project Activities	$2,306,472	$669,836	$1,188,270	$448,366	$92,292	$138,933	$174,685	$128,166	$192,053		$120,973	$435,337	$149,216	$299,847	$208,322		$28,558	$27,349	$43,315	$0	$110,922	$15,977		$75,354	$65,173
6	Staff Costs	$619,774	$97,728	$312,798	$209,248	$0	$114,381	$114,381	$18,791	$43,645		$10,545	$44,856	$42,428	$39,721	$57,765		$16,800	$26,102	$25,800	$11,871	$14,230	$14,230		$11,819	$12,409
7	Administration Costs	$79,813	$23,291	$30,596	$25,926	$2,149	$6,303	$11,638	$1,258	$6,455		$360	$5,423	$3,361	$14,803	$4,842		$3,050	$5,015	$8,426	$1,671	$1,700	$1,600		$858	$901
8	Monitoring, Evaluation and Lesson Learning	$1,135,575	$282,941	$545,737	$306,897	$60,554	$118,653	$76,125	$37,251	$34,324		$28,178	$159,208	$135,800	$125,006	$4,000		$26,130	$77,794	$36,700	$5,822	$103,795	$3,000		$47,963	$55,272
9	Program Management	$614,089	$199,604	$216,622	$197,863	$27,120	$37,303	$64,993	$39,500	$42,380		$32,214	$31,588	$57,055	$84,340	$49,936		$13,042	$11,286	$19,704	$3,388	$41,893	$33,042		$2,236	$23,069
10	Overheads	$558,351	$110,884	$269,406	$178,061	$15,065	$54,513	$68,880	$21,943	$31,565		$17,896	$94,398	$60,467	$46,853	$26,723		$7,245	$18,238	$20,882	$1,882	$22,419	$3,383		$21,550	$24,449
11	Total costs	$5,428,973	$1,451,271	$2,611,341	$1,366,361	$197,180	$507,150	$510,702	$287,194	$361,270		$234,222	$770,810	$448,327	$613,216	$351,588		$94,825	$165,784	$154,827	$24,634	$294,959	$71,232		$159,780	$181,273
12	Sources for cost figures:	http://files.givewell.org/files/DWDA%202009/Sightsavers/Sightsavers_Financial_report_for_GiveWell_funded_projects_for_year_1_activities_2018.pdf
13		http://files.givewell.org/files/DWDA%202009/Sightsavers/Sightsavers_GiveWell-funded_projects_budget_for_wishlists_1_and_2_2018.pdf
14
15	Treatments (children aged between 5-15 years only)
16	STH Treatments	6,173,059	1,629,644	2,879,291	1,664,124	358,168	642,489	851,381	592,745	819,435		174,288	550,945	142,758	67,303	67,303		437,140	799,119	669,985					0	0
17	Schisto Treatments	14,771,722	4,765,108	5,270,898	4,735,715	3,034,190	2,099,509	3,537,995	775,420	938,315		174,288	550,945	142,758	341,082	221,869		440,128	804,581	674,565					655,679	380,397
18	Roughly estimated total treatments	15,651,170	4,966,784	5,639,573	5,044,813	3,034,190	2,099,509	3,537,995	775,420	938,315		174,288	550,945	142,758	341,082	221,869		641,804	1,173,256	983,663					655,679	380,397
19	Sources for treatment figures:	http://files.givewell.org/files/DWDA%202009/Sightsavers/Sightsavers_Consolidated_Logframe_September_2017.xlsx
20		http://files.givewell.org/files/DWDA%202009/Sightsavers/Sightsavers_GiveWell_outputs_and_outcomes_year_1_2018.pdf
21		http://files.givewell.org/files/DWDA%202009/Sightsavers/Sightsavers_2017-18_STH_treatments_including_via_LF_MDA.xlsx
22	Cost per treatment
23	Estimated cost per treatment		$0.29	$0.46		$0.06	$0.24	$0.14	$0.37	$0.39		$1.34	$1.40	$3.14	$1.80	$1.58		$0.15	$0.14	$0.16					$0.24	$0.48
24	Sightsavers' cost per treatment (including all 2017-2019 Cameroon costs)	$0.35
25	Discounting for expectation of coverage being lower than aimed for	11%
26	Sightsavers' cost per treatment after adjustment for expectations of coverage	$0.39
27
28
29	Sightsavers' estimated treatments in DRC using data shared with us by SCI
30	Total NTD spending in geographic areas receiving deworming treatments	$3,782,681
31	Total STH treatments delivered	5,793,284
32	Total schistosomiasis treatments delivered	5,832,884
33	Total deworming treatments delivered	8,505,623
34	Proportion of total treatments that are deworming treatments, geographic areas receiving deworming treatments only	26%
35	Cost per deworming treatment in DRC	$0.12
36	Sightsavers total costs 2017 (excl. program management and overheads)	$74,538
37	Sightsavers total costs 2018 (excl. program management and overheads)	$136,260
38	Sightsavers total costs 2019 (excl. program management and overheads)	$114,241
39	Sightsavers roughly estimated total treatments in 2017	641,804
40	Sightsavers roughly estimated total treatments in 2018	1,173,256
41	Sightsavers roughly estimated total treatments in 2019	983,663
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100