GiveWell, Dispensers for Safe Water grant size, costs and room for more funding 2021 (redacted) (public)

	A	B	C	D	E
1	Cost per dispenser per year, during grant
2		Malawi	Uganda	Kenya	Source
3	# of dispensers, 2019	3,743	5,389	17,754	Dispensers for Safe Water 2019 monitoring data analysis, shared with GiveWell in July and Oct 2021. country program weighted average
4	Current Dispensers for Safe Water footprint
5	# maintenance years	4	4	3	"The grant covers maintenance of the current footprint for four years in Malawi and Uganda and three years in Kenya" GiveWell, Evidence Action's Dispensers for Safe Water program – General Support (January 2022)
6	Maintenance costs	$6,242,251	$7,600,053	$10,118,022	"Grant size" tab
7	Exit cost	$2,684,593	$3,173,340	$5,949,323	"Grant size" tab, "Source: Summary" tab
8	Exit phase, full scale and adherence equivalent dispenser years	1.25	1.25		GiveWell, Copy of DSW expansion model, 2021 (unpublished). Assumes full scale and adherence for the 11 months (when DSW would be discussing alternative water treatment option with the communities served) and then decreased scale/adherence afterwards, as DSW de-installs dispensers. See note for quote.
9	Current footprint, cost per dispenser year	$456	$387	$297	Calc
10
11	New footprint (expansion)
12	# new dispensers per country	12,000	12,000		Source: Summary' tab: "4 year + exit scenario 12,000 new dispensers per country (24,000 total)"
13	Scale up cost	$5,266,822	$5,416,885		Source: "Summary" tab. Subtracting $100k from Malawi and Uganda ($200k total) to account for increased management costs needed during the initial grant period to prepare for future scale up. Source: "Is the DSW management/country team as designed set DSW up for 6-10x expansion next year? If not, provide a rough budget for that cost. We think we would need an additional $200k per year for staffing to handle this type of expansion. We’ll likely need added capacity at the country level (e.g. add Deputy Country Directors), MLE (2 additional managers at the regional level)." DSW, Email, Nov. 1, 2021 (unpublished)
14	Scale up phase, full scale and adherence equivalent dispenser/years	0.25	0.20		MC_copy of expansion model (unpublished)
15	Maintenance costs	$13,149,095	$12,346,077		"Grant size" tab. Calc. Subtracting $100k from Malawi and Uganda ($200k total) to account for increased management costs needed during the initial grant period to prepare for future scale up. Source: "Is the DSW management/country team as designed set DSW up for 6-10x expansion next year? If not, provide a rough budget for that cost. We think we would need an additional $200k per year for staffing to handle this type of expansion. We’ll likely need added capacity at the country level (e.g. add Deputy Country Directors), MLE (2 additional managers at the regional level)." DSW, Email, Nov. 1, 2021 (unpublished)
16	Exit cost	$5,180,011	$4,862,397		"Grant size" tab
17	Exit phase, full scale and adherence equivalent dispenser years	1.25	1.25		MC_copy of expansion model (unpublished). Assumes full scale and adherence for the 11 months (when DSW would be discussing alternative water treatment option with the communities served) and then decreased scale/adherence afterwards, as DSW de-installs dispensers. See note for quote.
18	New dispensers, cost per dispenser year	$358	$346		Calc
19
20		Malawi	Uganda	Kenya
21	Cost per dispenser year, current footprint	$456	$387	$297	Calc
22	Cost per dispenser year, new dispensers	$358	$346	0	Calc
23
24	# old dispensers-years	19,556	27,813	54,009	DSW program and M&E 2021
25	# new dispensers-years	65,989	65,377	0	Calc
26
27	Weighted average (cost per dispenser year)	$380	$358	$297	Calc
28
29	Avg. No. of PEOPLE per Household (including <5 children), 2019	4.6	5.8	5.18	DSW program and M&E 2021
30	Avg. No. of Housholds per Dispenser, 2019	39.43	44.85	23.06	DSW program and M&E 2021
31
32	Average ppl per dispenser	181	260	119	Calc
33	Average cost per person, per year	$2.10	$1.38	$2.49	Calc
34	Short term cost per dispenser per year, as a % of long term costs	113%	113%	149%	Calc
35	Cost per dispenser per year, long term
36		Malawi	Uganda	Kenya
37	Current footprint
38	Maintenance cost, per year	$1,560,563	$1,900,013	$3,458,362	Calc
39	# maintenance years	10	10	10	Subjective guess.
40	Exit cost	$2,684,593	$3,173,340	$5,949,323	Calc
41	Exit phase, full scale and adherence equivalent dispenser years	1.25	1.25	1.25	MC_copy of expansion model (unpublished). Assumes full scale and adherence for the 11 months (when DSW would be discussing alternative water treatment option with the communities served) and then decreased scale/adherence afterwards, as DSW de-installs dispensers. See note for quote.
42	Current footprint, cost per dispenser/year	$436	$372	$200	Calc
43
44	New footprint
45	Scale up cost	$5,266,822	$5,416,885		Calc. Subtracting $100k from Malawi and Uganda ($200k total) to account for increased management costs needed during the initial grant period to prepare for future scale up. Source: "Is the DSW management/country team as designed set DSW up for 6-10x expansion next year? If not, provide a rough budget for that cost. We think we would need an additional $200k per year for staffing to handle this type of expansion. We’ll likely need added capacity at the country level (e.g. add Deputy Country Directors), MLE (2 additional managers at the regional level)." DSW, Email, Nov. 1, 2021 (unpublished)
46	Scale up phase, full scale and adherence equivalent dispenser years	0.25	0.20		MC_copy of expansion model (unpublished)
47	Maintenance cost, per year	$3,187,274	$2,986,519		Calc. Subtracting $100k from Malawi and Uganda ($200k total) to account for increased management costs needed during the initial grant period to prepare for future scale up. Source: "Is the DSW management/country team as designed set DSW up for 6-10x expansion next year? If not, provide a rough budget for that cost. We think we would need an additional $200k per year for staffing to handle this type of expansion. We’ll likely need added capacity at the country level (e.g. add Deputy Country Directors), MLE (2 additional managers at the regional level)." DSW, Email, Nov. 1, 2021 (unpublished)
48	# maintenance years	10	10		Subjective guess
49	Exit cost	$5,180,011	$4,862,397		Calc
50	Exit phase, full scale and adherence equivalent dispenser years	1.25	1.25		MC_copy of expansion model (unpublished). Assumes full scale and adherence for the 11 months (when DSW would be discussing alternative water treatment option with the communities served) and then decreased scale/adherence afterwards, as DSW de-installs dispensers. See note for quote.
51	New dispensers, cost per dispenser/year	$307	$292		Calc
52
53		Malawi	Uganda	Kenya
54	Cost per dispenser year, current footprint	$436	$372	$200	Calc
55	Cost per dispenser year, new dispensers	$307	$292	0	Calc
56
57	# old dispenser-years	41,924	59,625	202,459	DSW program and M&E 2021
58	# new dispenser-years	137,989	137,377	0	Calc
59
60	Cost per dispenser year, weighted average	$337	$316	$200	Calc
61	Average cost per person, per year	$1.86	$1.22	$1.68	Calc
62
63	Ministries of Health (MoH) costs
64	MoH costs, per year, per country	$150,035.00	$45,374.00	$0.00	"(i) Using a valuation approach alone, we would estimate the in-kind contribution of health workers in Malawi to be up to $138,701 annually. (ii) Using primarily a valuation approach we would estimate the in-kind contribution of chlorine storage in Uganda and Malawi to be up to $45,374 annually for Uganda and up to $11,334 annually for Malawi." (unpublished source)
65	Government costs, per person, per year	$0.22	$0.03	$0.00	Calc
66
67	Recurring vs. one-off costs
68	Recurring costs per person/year (maintenance)	$1.66	$1.08	$1.63	Calc
69	One off costs per person (set up and exit)	$4.80	$3.29	$4.05	Calc
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