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 | AA | AB | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Value | Source | Notes | |||||||||||||||||||||||||
2 | Drug costs | |||||||||||||||||||||||||||
3 | Total spending on tablets between April 2011 and March 2014, GBP | £10,135,290 | Crown Agents Total ICOSA Procurement Spend (updated 2014) | Unpublished source. The units in the source file are not labelled. We have assumed the figures are in GBP. | ||||||||||||||||||||||||
4 | Total number of tablets procured and delivered by March 2014 | 127,191,000 | SCI ICOSA Mid-Year Report 2014, Pg 12 (Table 3). | This includes a large number of tablets held in reserve and not yet delivered as of March 2014. | ||||||||||||||||||||||||
5 | Drug cost per tablet | £0.08 | GiveWell calculation | |||||||||||||||||||||||||
6 | Wastage assumption | 10% | GiveWell judgment | This is the percentage of drugs we assume are wasted. We do not have data on actual wastage so are intuitively hypothesizing what seems reasonable. We note that a similar assumption was discussed in an paper we found (Utroska et al. 1989: http://files.givewell.org/files/DWDA%202009/SCI/Utroska%20et%20al.%201989.pdf), though this is quite dated and we do not know how the authors arrived at 10%. | ||||||||||||||||||||||||
7 | Drug costs per tablet, accounting for wastage, GBP | £0.09 | GiveWell calculation | |||||||||||||||||||||||||
8 | Average number of tablets per treatment | 2.5 | SCI ICOSA Mid-Year Report 2014, Pg 12. | |||||||||||||||||||||||||
9 | Drug costs per treatment, accounting for wastage, GBP | £0.22 | GiveWell calculation | |||||||||||||||||||||||||
10 | USD per GBP, April 2011 - March 2014 | 1.59 | GiveWell calculation | For simplicity, taking the simple average of monthly GBP/USD rate from April 2011 to March 2014 (the period over which the drugs were purchased) | ||||||||||||||||||||||||
11 | Drug costs per treament, accounting for wastage, USD | $0.35 | GiveWell calculation | |||||||||||||||||||||||||
12 | Drug costs per treatment, accounting for wastage, inflated to Apr15-Mar18 USD | $0.37 | GiveWell calculation | To inflate drug costs measured in Apr11-Mar14 USD to Apr15-Mar18 USD, we multiply by the ratio of the average consumer price index in Apr15-Mar18 to the average consumer price index Apr11-Mar14 | ||||||||||||||||||||||||
13 | Government costs | |||||||||||||||||||||||||||
14 | Government's share of total treatment costs | 30% | https://www.givewell.org/charities/Schistosomiasis-Control-Initiative#Shortcomings_of_our_analysis | We use a uniform percentage of total costs to estimate the share of the costs that the government incurs. See the linked source in the previous cell for details about this estimate. | ||||||||||||||||||||||||
15 | SCI's costs (excluding research), FY6-FY8 (April 2015 - March 2018) | |||||||||||||||||||||||||||
16 | Country expenditures, all programs included in cost per treatment analysis, FY6 (2015/16) | £5,898,959 | GiveWell calculation. See "GW 2015-16 costs and treatments" sheet | |||||||||||||||||||||||||
17 | Total central expenditures FY6 (2015/16) | £1,284,719 | "SCI 2015-16 BVA" sheet, cell L6 | |||||||||||||||||||||||||
18 | % of country expenditures on all programs included cost per treatment analysis, FY6 (2015/16) | 94% | GiveWell calculation | |||||||||||||||||||||||||
19 | Central expenditures for countries included in cost per treatment analysis, FY6 (2015/16) | £1,212,257 | GiveWell calculation | |||||||||||||||||||||||||
20 | SCI's spending included in the cost per treatment analysis, excluding drugs, FY 6 (2015/16) | £7,111,216 | GiveWell calculation | |||||||||||||||||||||||||
21 | ||||||||||||||||||||||||||||
22 | Country expenditures, all programs included in cost per treatment analysis, FY7 (2016/17) | £5,629,171 | "GW SCI 2016-17 BVA" sheet | |||||||||||||||||||||||||
23 | Total central expenditures FY7 (2016/17) | £1,894,660 | SCI Budget vs Actuals April 2016-March 2017 Redacted | "Summary" sheet | ||||||||||||||||||||||||
24 | % of country expenditures on all programs included cost per treatment analysis, FY7 (2016/17) | 100% | GiveWell calculation | |||||||||||||||||||||||||
25 | Central expenditures for countries included in cost per treatment analysis, FY7 (2016/17) | £1,889,929 | GiveWell calculation | |||||||||||||||||||||||||
26 | SCI's spending included in the cost per treatment analysis, excluding drugs, FY 7 (2016/17) | £7,519,100 | GiveWell calculation | |||||||||||||||||||||||||
27 | ||||||||||||||||||||||||||||
28 | Country expenditures, all programs included in cost per treatment analysis, FY8 (2017/18) | £6,932,830 | "GW SCI 2017-18 BVA (Implementation + Rolled over)" sheet | |||||||||||||||||||||||||
29 | Total central expenditures FY8 (2017/18) | £2,012,613 | "GW SCI 2017-18 BVA (Overall)" sheet | |||||||||||||||||||||||||
30 | % of country expenditures on all programs included cost per treatment analysis, FY8 (2017/18) | 72% | GiveWell calculation | |||||||||||||||||||||||||
31 | Central expenditures for countries included in cost per treatment analysis, FY8 (2017/18) | £1,442,712 | GiveWell calculation | |||||||||||||||||||||||||
32 | SCI's spending included in the cost per treatment analysis, excluding drugs, FY 8 (2017/18) | £8,375,542 | GiveWell calculation | |||||||||||||||||||||||||
33 | ||||||||||||||||||||||||||||
34 | SCI's spending, excluding drugs, FY6-8 | £23,005,858 | GiveWell calculation | |||||||||||||||||||||||||
35 | Portion of SCI's costs paid by Imperial College | 10% | GiveWell's non-verbatim summary of a conversation with Wendy Harrison and Najwa Al Abdallah on September 8, 2015 | This is a rough estimate, informed by the source linked in the previous cell. Imperial College supports SCI, for example, covering some legal and administrative expenses. These are not included in SCI's reported spending. SCI told us that 6% of its DFID grant was allocated to this but that it received more than that covered, so 10% seemed like a plausible estimate. | ||||||||||||||||||||||||
36 | SCI's total costs, excluding drugs, GBP | £25,562,065 | GiveWell calculation | |||||||||||||||||||||||||
37 | SCI's total costs, excluding drugs, USD | $35,186,531 | GiveWell calculation | We convert SCI's spending in each FY into dollars using the average GBP/USD monthly currency conversion rate within that year. We sum these amounts and make the adjustment for the portion of SCI's costs paid by Imperial College. | ||||||||||||||||||||||||
38 | Research costs | |||||||||||||||||||||||||||
39 | Research costs, FY6 | £35,403 | GiveWell calculation | Assume research spending in FY6 is the mean of research spending in FYs 7 and 8 | ||||||||||||||||||||||||
40 | Research costs, FY7 | £55,758 | http://givewell.org/files/DWDA%202009/SCI/SCI_Budget_vs_Actuals_April_2016-March_2017_Redacted.xlsx | |||||||||||||||||||||||||
41 | Research costs, FY8 | £15,048 | "GW SCI 2017-18 BVA (Overall)" sheet | |||||||||||||||||||||||||
42 | SCI's total research costs, GBP | £106,209 | GiveWell calculation | |||||||||||||||||||||||||
43 | SCI's total research costs, USD | $146,263 | GiveWell calculation | We convert SCI's spending in each FY into dollars using the average GBP/USD monthly currency conversion rate within that year, and then take the sum across years. | ||||||||||||||||||||||||
44 | Treatments delivered | |||||||||||||||||||||||||||
45 | Schistosomiasis treatments included in cost per treatment analysis, FY6 (2015-16) | 29,674,099 | See cell formula | |||||||||||||||||||||||||
46 | Schistosomiasis treatments included in cost per treatment analysis, FY7 (2016-17) | 44,643,801 | See cell formula | |||||||||||||||||||||||||
47 | Schistosomiasis treatments included in cost per treatment analysis, FY8 (2017-18) | 40,977,164 | See cell formula | |||||||||||||||||||||||||
48 | Adjustment rate for reported treatments | 0.95 | GiveWell summary of SCI coverage surveys | Sheet "Results," cell L29 | ||||||||||||||||||||||||
49 | Adjusted # of schistosomiasis treatments, FY6-8 | 109,530,310 | GiveWell calculation | |||||||||||||||||||||||||
50 | Cost per treatment estimates | |||||||||||||||||||||||||||
51 | Total cost per treatment (excluding research costs) | $0.99 | GiveWell calculation | |||||||||||||||||||||||||
52 | Cost per treatment, excluding drugs, including government costs | $0.46 | GiveWell calculation | |||||||||||||||||||||||||
53 | Cost per treatment, including drugs, excluding government costs | $0.69 | GiveWell calculation | |||||||||||||||||||||||||
54 | Cost per treatment, excluding drugs and government costs | $0.32 | GiveWell calculation | |||||||||||||||||||||||||
55 | ||||||||||||||||||||||||||||
56 | Total cost per treatment (including research costs) | $0.99 | GiveWell calculation | |||||||||||||||||||||||||
57 | Cost per treatment, excluding drugs, including government costs, including research costs | $0.46 | GiveWell calculation | |||||||||||||||||||||||||
58 | Cost per treatment, including drugs, excluding government costs, including research costs | $0.69 | GiveWell calculation | |||||||||||||||||||||||||
59 | Cost per treatment, excluding drugs and government costs, including research costs | $0.32 | GiveWell calculation | |||||||||||||||||||||||||
60 | ||||||||||||||||||||||||||||
61 | Cost breakdown: | |||||||||||||||||||||||||||
62 | SCI's total cost per treatment (including research costs) | $0.32 | GiveWell calculation | |||||||||||||||||||||||||
63 | Total cost of drugs per treatment | $0.37 | GiveWell calculation | |||||||||||||||||||||||||
64 | Total government costs per treatment | $0.30 | GiveWell calculation | |||||||||||||||||||||||||
65 | ||||||||||||||||||||||||||||
66 | % cost breakdown: | |||||||||||||||||||||||||||
67 | SCI's total cost per treatment (including research costs) | 33% | GiveWell calculation | |||||||||||||||||||||||||
68 | Total cost of drugs per treatment | 37% | GiveWell calculation | |||||||||||||||||||||||||
69 | Total government costs per treatment | 30% | GiveWell calculation | |||||||||||||||||||||||||
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 |