ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBE
1
2
PMI States
3
4
Current PlanProposed PlanCurrent PlanProposed PlanExpected as of November 2021, assuming AMF purchases 2023 LLINs
5
Prev. index (1 bad)Distribution Cycle: 2009 to 2011GapDistribution Cycle: 2012 to 2014GapDistribution Cycle: 2015 to 2017GapDistribution Cycle: 2018 to 2020GapDistribution Cycle: 2021 to 2024GapDistribution Cycle: 2021 to 2024# months brought forward
6
StateMonthYearMonthsMonthYearMonthsMonthYearMonthsMonthYearMonthsMonthYearMonthsMonthYear2021202220232024202120222023202120222023202420252026
7
1Kebbi52%1 Jun 06200972 Jun 06201535 May 05201834 Mar 032021 2,889,253 - - 2,889,253 - - 2,889,253 - - 2,889,253
8
2Oyo24%16 Jun 06201340 Oct 10201656 Jun 062021 5,082,630 - - 5,082,630 - - 5,082,630 - - 5,082,630
9
3Sokoto36%2 Jun 09200951 Dec 12201348 Dec 12201744 Aug 08202144 3,218,835 - - 3,218,835 - - 3,218,835 - - 3,218,835
10
4Nasarawa14%28 Dec 12201042 Jun 06201445 Mar 03201844 Nov 11202136 Mar 03202108 1,629,838 - - 1,629,838 - - 1,629,838 - - 1,629,838
11
5Akwa Ibom23%17 Jun 06201054 Dec 12201445 Sep 09201842 Mar 03202236 Sep 09202106 - 3,678,413 - 3,678,413 - -
-
3,678,413 - 3,678,413
12
6Bauchi31%10 Mar 03201056 Nov 11201449 Dec 12201842 Jun 06202236 Dec 12202106 - 4,406,799 - 4,406,799 - -
-
4,406,799 - 4,406,799
13
7Cross River20%24 Jan 01201153 Jun 06201548 Jun 06201945 Mar 03202336 Jun 06202209 - - 2,608,663 - 2,608,663 - - 2,608,663 - 2,608,663
14
8Ebonyi31%11 Jun 06201151 Sep 09201550 Nov 11201943 Jun 06202336 Nov 11202207 - - 1,940,415 - 1,940,415 - - 1,940,415 - 1,940,415
15
10Plateau21%19 Dec 12201054 Jun 06201556 Feb 02202049 Mar 03202436 Feb 02202313 - - - 4,047,766 - - 4,047,766 - - 4,047,766 4,047,766
16
11Zamfara36%3 Mar 03201154 Sep 09201559 Aug 08202046 Jun 06202436 Aug 08202310 - - - 2,998,634 - - 2,998,634 - - 2,998,634 2,998,634
17
9Benue13%31 Jun 06201158 Apr 04201655 Nov 11202046 Sep 09202436 Nov 11202310 - - - 3,208,255 - - 3,208,255 - - 3,208,255 3,208,255
18
4512,820,5558,085,2124,549,07810,254,65620,905,7674,549,07810,254,656
no accounting for pop growth so #s prob 5 to 10% higher
19
20
37-42 months
3 to 3 1/2 years
PMI budget
PMI Funding (USD, M)
Total funding required (if all PMI)
21
43-48 months
3 1/2 to 4 years
Cost/net
$2.86$36.7$23.1$13.0$29.3$36.7$13.0$36.7$13.0 - $59.8$13.0$29.3
22
49-54 months
4 to 4 1/2 years
Non-net cost/net
$1.48$19.0$12.0$6.7$15.2$30.9$6.7$15.2$19.0$18.7 15.18 $30.9$6.7$15.2
23
55-60 months
4 1/2 to 5 years
haTotal$4.34$55.6$35.1$19.7$44.5$67.6$19.7$15.2$55.6$31.7$15.2$90.7$19.7$44.5
2024 new vs 2024 old:
+104%
24
Total in 2021-2023
$110.5+$12.0-$15.3-$4.6$102.5$155.0high
25
-$7.9
Funding required vs prior cycle
26
Months to be checked
AMF budget
+63%-44%+125%
27
Cost/net$2.40Overall (Δ%):+40%
28
Monitoring cost/net
$0.25Overall (Δ$,m):+$44.5
29
30
PMI fundsPMI funds
If PMI funding increased by 10%
31
left for 2022
for 2023$30.3$31.9$6.5
32
$23.1$23.1$30.9$6.7$15.2
funds cover non-nets first
33
NeededNeeded$61.2$38.6$21.7
34
$19.7$44.5$121.5
35
SurplusDeficit
36
$3.4$21.4$29.5-$18.9$22.8
If 10% incr, amount not covered by PMI
37
# nets AMF funds
7.5$33.5
No consideration of 30 months
38
Cost to AMF (nets only)
$17.9
# of nets @$2.20
15.2
39
Deficit$44.5Monitoring$1.9
40
# of nets
10.25465557
Total 2023
$19.8
PMI Δ in funding 2021-23 due to AMF involvement
Funds contributed by AMF
41
Cost of nnc to PMI (USD)
$15.2
42
# PMI nets to free up
5.306604982
IF AMF DOES NOT HAVE TO COVER NON-NET COSTS
Akwa Ibom
AMF has relieved PMI of these costs:
(USD, m)(USD, m)
43
Cost of nets to AMF
$12.7# of nets3.7Akwa Ibom nets-$10.5
Akwa Ibom nets + monitoring
+$6.9
44
Total nets AMF funds
15.56126056
Cost of nets brought forward funded by AMF (USD, M)
$8.8Bauchi nets-$12.6
Bauchi nets + monitoring
+$5.1
45
AMF monitoring costs (USD, M)
$0.9-$23.1+$12.1
46
20218.09
Total cost to AMF (USD, M)
$9.7
47
20220.00
PMI are taking on these costs pre end 2023
48
20237.48
IF AMF DOES NOT HAVE TO COVER NON-NET COSTS
Bauchi
Plateau non-net costs
+$6.0
Plateau nets + monitoring
+$10.7
49
15.56126# of nets4.4
Zamfara non-net cost
+$4.4
Zamfara nets + monitoring
+$7.9
50
Cost of nets brought forward funded by AMF (USD, M)
$10.6
Benue non-net costs
+$4.7
Benue nets + monitoring
+$8.5
51
Cost of nets
$37.3
AMF monitoring costs (USD, M)
$1.1+$15.2+$27.2
52
Cost of monioring
$3.9
Total cost to AMF (USD, M)
$11.7
53
Total$41.2
Net PMI incr/(decr) in cost
-$7.9PMI funding+$39.2
54
IF AMF DOES NOT HAVE TO COVER NON-NET COSTS
Both
55
# of nets8.1
56
Cost of nets brought forward funded by AMF (USD, M)
$19.4+$39.2
57
AMF monitoring costs (USD, M)
$2.0Total
58
Total cost to AMF (USD, M)
$21.4This one$41.2
59
60
202120222023Total
61
Scenario A - Both
$21.4$19.8$41.2This one
62
Scenario B - Akwa Ibon only
$9.7$11.7$19.8$41.2
63
64
65
IF AMF ALSO HAS TO COVER NON-NET COSTS
Akwa Ibom
PMI fundsPMI funds
66
Non-net costs to born by PMI (USD, M)
$5.4
left for 2022
for 2023
67
Additional number of nets for AMF to free up those funds
1.9035$35.1$35.1
68
Cost of those nets that AMF funds (USD, M)
$4.6NeededNeeded
69
Total # of nets funded by AMF
5.5819$19.7$44.5
70
Total cost of nets funded by AMF (USD, M)
$13.4SurplusDeficit
71
Total AMF monitoring costs (USD, M)
$1.4$15.3$9.4
72
Total cost to AMF (USD, M)
$14.83.3
# nets AMF funds
73
$7.9
Cost to AMF (nets only)
74
IF AMF ALSO HAS TO COVER NON-NET COSTS
Bauchi$0.8Monitoring
75
Cost of nets brought forward funded by AMF (USD, M)
$10.6$8.7Total 2023
76
Non-net costs to born by PMI (USD, M)
$6.5
77
Additional number of nets for AMF to free up those funds
2.2804
78
Cost of those nets that AMF funds (USD, M)
$5.5
79
Total # of nets funded by AMF
6.6872
80
Total cost of nets funded by AMF (USD, M)
$16.0
81
Total AMF monitoring costs (USD, M)
$1.7
82
Total cost to AMF (USD, M)
$17.7
83
84
IF AMF ALSO HAS TO COVER NON-NET COSTS
BOTH
85
Total AMF funding for nets
$29.4
86
Total AMF funding for monitoring
$3.1
87
Total AMF funding
$32.5
88
89
202120222023Total
90
Scenario C - Both
$32.5$8.7$41.2
91
Scenario D - Akwa Ibon only
$14.8$17.7$8.7$41.2
92
93
ALL SCENARIOS202120222023Total
94
IF AMF DOES NOT HAVE TO COVER NON-NET COSTS
Scenario A - Both
$21.4$19.8$41.2
95
Scenario B - Akwa Ibon only
$9.7$11.7$19.8$41.2
96
IF AMF ALSO HAS TO COVER NON-NET COSTS
Scenario C - Both
$32.5$8.7$41.2
97
Scenario D - Akwa Ibon only
$14.8$17.7$8.7$41.2
98
99
# of nets
100
202120222023