| A | B | C | D | E | ||
|---|---|---|---|---|---|---|
1 | CCTs for Immunizations: RCT Budget for November 2017 - May 2020 (see note in A53) | |||||
2 | Item | Projection in USD | Cost in NGN (see Notes) | Notes | ||
3 | Total Funding Seeking: | $5,944,203 | ||||
4 | Cost per Mother/Infant: | $38.83 | ||||
5 | # learning clinics: | 10 | See other key assumptions in the "Projections and Assumptions tab. | |||
6 | # months: | 22 | ||||
7 | # RCT clinics: | 80 | ||||
8 | # months: | 30 | ||||
9 | Management Costs (Yearly) | Total US and Nigerian management costs through May 2020: | $1,370,216 | Partial costs of October 2017 - June 2018 are supported by the Learning Grant. This covers remaining costs through the budget period. | ||
10 | Management Team (3 staff) | $250,800 | Assumes $66,000 per chief officer per year second half of 2017. Assumes $84,000 per chief officer per year in 2018. After taxes, this equates to approximately $5,300 per chief officer per month. Assumes $100,800 per chief officer per year in 2019. After taxes, this equates to approximately $6,300 per chief officer per month. Historically, NI founders have worked at very low salaries (of $2,000-$3,000 per month). The increase in salary is below market rates and is intended to cover living costs and contribute to savings. NI does not contribute to 401k or provide other benefits. | |||
11 | Payroll Taxes (US) | $19,186 | ||||
12 | Console Agents | $32,000 | Assumes 6 part-time Console Agents and 2 Console Managers at an average of $4/hour for 20 hours per week. | |||
13 | Insurance (Other) | $2,380 | ||||
14 | Payroll Fees | $420 | ||||
15 | Accounting | $8,740 | Assumes $45 for Xero per month; $2,000 for preparation and filing of annual federal 990, CA 199, and AG RRF-1 filings; $10,000 for discounted biennial audit; $100 review support per month | |||
16 | US Legal | $500 | Annual filing fees | |||
17 | Telephone, Internet, Office Stipend | $10,800 | $300 per chief officer per month | |||
18 | Travel (international and domestic) | $17,000 | Assumes 6 trips including international/domestic fares from Europe, 4 trips including international/domestic fares from the US per year | |||
19 | Office expenses (virtual mailbox, file storage, etc) | $740 | ||||
20 | Bank and CCT Transfer Fees | $800 | ||||
21 | Accident Insurance (for field staff) | $4,500 | Transportation and theft insurance for field staff. | |||
22 | IT Projects | $35,000 | Assumes $35,000 per year for engineering and database support | |||
23 | Nigeria Office | $3,000 | Potential HQ in a NW state and/or rent for biweekly meeting spaces. | |||
24 | Equipment for Staff in Nigeria | $3,000 | Assumes 12 laptops, at $500 each (assumes lasts for two years) | |||
25 | Nigeria Accounting and Legal | $2,500 | Required annual Nigerian financial audit, annual filing, setup of pension accounts, setup PAYE tax payments for each state | |||
26 | Field Director | $30,000 | ₦600,000 | Assumes 1 Field Director | ||
27 | Government Relations Manager | $20,000 | ₦500,000 | Assumes 1 mid-level to senior employee | ||
28 | Field Managers | $86,400 | ₦180,000 | Assumes 12 Field Managers, with room to retain and grow Managers | ||
29 | Payroll for Nigerian Senior Staff | $34,100 | Assumes 25% payroll taxes (required taxes: PAYE, National Housing Fund, Employee Compensation Fund) | |||
30 | Pension Contributions for Nigerian Staff | $27,280 | Assumes 20% for senior Nigerian salary costs (as of July 1 2014, all employers with 3 or more employees have to participate in the Contributory Pension Scheme) | |||
31 | Miscellaneous | $30,000 | ||||
32 | Clinic Screening Costs (Entire RCT Period) | Screening RCT Sites | $24,167 | ₦7,250,000 | This includes the cost of screening approximately 400 clinics for the RCT sites (treatment and control sites). Includes salary costs of 20 staff for 20 days or a total of 800,000 Naira. Bonus per staff of 10,000 Naira (500 Naira per day) since they work long days from 8am - 9pm; total bonus is 200,000 Naira. Assume daily transportation of 10,000 Naira for 4,000,000 in total. Lunch and refreshments for LGA stakeholders of 300,000 Naira. Buffer of 500,000 Naira. Multiplied by 1.25 in case need to extend into a fifth week. | |
33 | Field Costs for Clinics (Entire RCT Period) | Staff trainings, clinic trainings and community sensitization | $40,000 | ₦0 | Assumes four-week training for new NI staff members, including on-the-job training at the 10 learning sites. Assumes two engagement visits to communities of new clinics plus one training for clinic staff at new program sites. | |
34 | Clinic audits | $37,844 | ₦6,500 | Assumes audit costs for 2 clinics as follows: 3,000 NGN salary/day; 10,000 NGN transport/day. Assumes that clinics are audited at least every two months (used assumption of every 1.5 months) | ||
35 | Field Manager and Field Director transportation | $353,600 | ₦15,000 | Assumes an average of 15,000 Naira per day (for 16 days per month) | ||
36 | Printing (posters) | $5,333 | ₦20,000 | Assumes two posters per clinic at a rate of 10,000 Naira per poster. | ||
37 | Bimonthly refreshments for nurses | $61,133 | ₦7,000 | Assumes monthly pluses for clinic staff at a cost of 1,000 Naira per clinic staff member; assumes an average of 7 staff per clinic. | ||
38 | Phone for field staff | $14,556 | ₦20,000 | 60,000 NGN per phone including power bank and case. Works for at least one year (50 weeks), then potential replacement. Assumes each field staff can operate an average of 3 clinics/week | ||
39 | Technology per field staff (doForms, etc) | $14,483 | ₦59,700 | Assumes $149 doForms annual fee and $50 for other phone app and setup costs; assumes each field staff can operate an average of 3 clinics/week | ||
40 | Phone credit | $26,200 | ₦300 | Assumes 200 Naira per clinic day for general communications; assumes an average of 2.5 days per week per clinic | ||
41 | Internet for sending data | $26,200 | ₦300 | Assumes 200 Naira per clinic day; assumes an average of 2.5 days per week per clinic | ||
42 | Outreach and community sensitization | $87,333 | ₦10,000 | Assumes 10,000 Naira in outreach or community sensitization costs per clinic per month | ||
43 | Miscellaneous | $87,333 | ₦10,000 | Assumes 10,000 Naira in miscellanous costs per clinic per month | ||
44 | Field Costs for CCTs (Entire RCT Period) | Conditional cash transfers (CCT 1 - CCT 5) | $1,697,855 | ₦509,356,500 | See assumptions in "Projections and Assumptions" tab | |
45 | Staff salaries | $324,758 | ₦3,000 | Approximately 80-90 Field Volunteers / Officers. Assumes employee earns 2,500 NGN/day - 3,000 NGN salary/day and processes an average of 20 payouts per day. | ||
46 | Staff taxes | $81,189 | ₦750 | Includes Nigerian employer PAYE taxes and required fund contributions (National Housing Fund, Employee Compensation Fund) per officer employee day (assumes an employee processes an average of 20 payouts per day) | ||
47 | Field transportation | $324,758 | ₦3,000 | Assumes 3,000 Naira per day; employee process an average of 20 payouts per clinic visit | ||
48 | Field transportation (extra cost due to RCT buffer zones) | $324,758 | ₦15,000 | Assumes 15,000 Naira per day for 20% of clinics due to clinic layout for RCT; employee process an average of 20 payouts per clinic visit | ||
49 | Printing (leaflets) | $59,254 | ₦130 | Assumes each caretaker/infant benefits from one All Babies card @100 Naira per card with sticker and shipping, one marketing flyer @25 Naira per flyer, and 5 tags @5 Naira per tag | ||
50 | Upwork transcription | $162,379 | Upwork transcription / creation of infant immunization data based on data submitted by field staff from each CCT disbursement session. Assumes $0.25 per disbursement visit based on three data entry flows per disbursement and random data quality audits. | |||
51 | SMS reminders | $12,990 | ₦43 | Assume one message/ payout; average Twilio message is 1 cent, 1 cent for Textit = 2 cents per message. Assume 4.75 payouts per caretaker/infant. | ||
52 | Miscellaneous | $173,204 | ₦51,961,200 | Assumes 80 Naira miscellaneous costs per disbursement | ||
53 | Planning for Negative Scenario / Phase-Out (May 2020 - September 2020) | Management Team (3 staff) | $126,000 | 4 months of core HQ and staff severance costs to phaseout program and close organization if study results are disappointing. One additional month for management salaries to finalize the shutdown. | ||
54 | Payroll Taxes (US) | $9,639 | ||||
55 | Console Agents | $10,667 | ||||
56 | Insurance (Other) | $793 | ||||
57 | Payroll Fees | $140 | ||||
58 | Accounting | $2,913 | ||||
59 | US Legal | $167 | ||||
60 | Travel (international and domestic) | $5,667 | ||||
61 | Office expenses (virtual mailbox, file storage, etc) | $247 | ||||
62 | Bank and CCT Transfer Fees | $267 | ||||
63 | Accident Insurance (for field staff) | $1,500 | ||||
64 | Nigeria Office | $1,000 | ||||
65 | Nigeria Accounting and Legal | $833 | ||||
66 | Field Director | $10,000 | ||||
67 | Government Relations Manager | $6,667 | ||||
68 | Field Managers | $28,800 | ||||
69 | Payroll for Nigerian Senior Staff | $11,367 | ||||
70 | Pension Contributions for Nigerian Staff | $9,093 | ||||
71 | Field Staff Salaries and Taxes | $46,800 | ||||
72 | Miscellaneous | $30,000 | ||||
73 | Mass marketing in settlements of all clinic catchment areas | $150,000 | Mass communication campaign in clinic catchment areas to inform caretakers that the program will be ending. Communication across all settlements of every catchment area on multiple days and times. | |||
74 | One month of normal program operations | $182,101 | Once the negative scenario decision is made, the clinics will be shut down within a month while doing mass communications. | |||