ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAO
1
Care Group Beneficiary Worksheet
2
DIRECTIONS: Fill out the Green Cells with your population & project and the Rest of the Worksheet will Calculate Automatically. The Yellow Cells are locked with the password "cg". If you unlock them you will risk altering the formulas.
3
* Note this sheet assumes your Care Groups include preg. women and women with children < 2 years of age and that children < 5 years of age will benefit from other services (e.g., GMP, EPI, and/or Deworming)
ValidB1512345678910111213141516
4
5
% or #Source & Calculation Notes Website
6
WRA 21.68%US Census Bureau - Determine total population of females 15 and 49 years of age then divide by total population. (DHS can also provide this number using % of population, not actual numbers)http://www.census.gov/ipc/www/idb/informationGateway.php
7
% of population that is female50.78%US Census Bureau or DHS taking total # of females divided by total popualation. (Use 50% if you cannot find that information.)
8
Children <5 yrs18.40%DHS Table "Household population by age, sex, and residence" or the US Census Bureau 2010. (This is often ~18%.)
9
Children <2 yrs7.36%Multiply the % of children < 5 years by 40% (if age distribution is equal then 2 years/ 5 years means that ~40% of the children < 5 will be < 2). (This is often ~7%.)
10
Pregnant Women3.80%UNICEF Country Statistics: Take the total population and divide by # of births in a year to get an estimated % of pregnant women. (This is often ~4%.) http://www.unicef.org/infobycountry/
11
Average Household Size5Get this from the DHS Table, "Household Composition"
12
Mothers per child 0-24m1.02Calculated based on highest ratio in a review of data from three countries. See the worksheet "children per woman" to see how to calculate this specific for your country, or accept this figure if you want a reasonable estimate.
13
Mothers per child 0-59m1.62Calculated based on highest ratio in a review of data from three countries. See the worksheet "children per woman" to see how to calculate this specific for your country., or accept this figure if you want a reasonable estimate.
14
% of women who gave birth less than 24 months since preceding birth21.23%Calculated based on average from three countries. See the worksheet "children per woman" to see how to calculate this specific for your country.
15
% of women who gave birth less than 60 months since preceding birth91.70%Calculated based on average from two countries. See the worksheet "children per woman" to see how to calculate this specific for your country.
16
Total Direct BeneficiariesDefinitionMothers of children < 5 years + Pregnant Women who are not mothers of children < 5 years + Children < 5 years (this depends on who your program targets)
17
Total InDirect BeneficiariesDefinition((Households with Children < 5 years/mothers per child 0-59m) + (Pregnant women who don't have children < 5 years of age)) * Average Household Size
18
Number of Mother Beneficiaries (MB) per Care Group Volunteer (CGV)10The number of Mother Beneficiaries (MB), Mother Leaders (ML aka Care Group Volunteers), the ratio of Care Groups to Promoters and Supervisors to Promoters is part of the project design and will depend on budget, population density, geography, and the mode of transport for ML and Promoters. We have set upper and lower limits according to the Care Group Criteria document posted at www.CareGroupInfo.org and do not suggest exceeding those limits.http://www.caregroupinfo.org/blog/criteria
19
Number of CGV in each Care Group12
20
Number of Care Groups per Promoter6
21
Number of Promoters per Supervisor5
22
23
Care Group Direct and Indirect Beneficiaries
24
Project Area (District)Total PopulationWRAChildren <5Children <2Children 2-5 yrsHousholds with Children < 2Households with Pregnant Women (who do not have a child under 2)Households with Pregnant Women (who do not have a child under 5)Household with Mothers of Children < 5 Total Direct Beneficiaries Total Indirect
25
26
Area A10,0002,1681,8407361,1047213031721,1362,86510,058
27
Area B5,0001,084920368552361152865681,4325,029
28
Area C30,0006,5055,5202,2083,3122,1639105153,4078,59430,175
29
0000000000
30
0000000000
31
0000000000
32
0000000000
33
0000000000
34
0000000000
35
0000000000
36
0000000000
37
0000000000
38
Totals45,0009,7578,2803,3124,9683,2451,3667735,11112,89045,263
39
40
Care Group Mother Beneficiaries and Mother Leaders
41
Project Area (District)Women reached by CGVs# of beneficiary mother groupings# of CG Volunteers# of Care Groups# of Promoters needed (rounded up)# of Supervisors needed (combine areas if poss.)# of Supervisors needed (rounded up, no sharing)
42
43
Area A1,025939382.000.401.00
44
Area B512474741.000.201.00
45
Area C3,074279279234.000.801.00
46
00000.000.000.00
47
00000.000.000.00
48
00000.000.000.00
49
00000.000.000.00
50
00000.000.000.00
51
00000.000.000.00
52
00000.000.000.00
53
00000.000.000.00
54
00000.000.000.00
55
Totals4,61041941935713
56
57
Male and Female Direct and Indirect Beneficiaries
58
Project Area (District)Total Direct Male BeneficiariesTotal Direct Female BeneficiariesTotal Indirect Male BeneficiariesTotal Indirect Female Beneficiaries
59
60
Area A9201,9455,0295,029
61
Area B4609722,5152,515
62
Area C2,7605,83415,08815,088
63
0000
64
0000
65
0000
66
0000
67
0000
68
0000
69
0000
70
0000
71
0000
72
Totals4,1408,75022,63222,632
73
74
75
This form was created by Food for the Hungry, Nov 5 2010
76
For questions please contact: Carolyn Wetzel, Director of Health Programs
77
cwetzel@fh.org
78
Reposting with proper attribution to FH is authorized.
79
80
Remember, to unlock cells, password is "cg" (Tools, Protection, Unprotect sheet, cg in Excel.)
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100