OFB Puts Diapers on 20% of Two Month Old Babies in Rideau-Vanier in 2014

Description

Subject to the assumptions described below, the finding is that the Ottawa Food Bank puts diapers on approximately 1 in 5 two month old babies in the Rideau-Vanier ward. The impact of this speaks for itself.

What fraction of ordered is being delivered?

WardNum	Size_N	Size_1	Size_2	Size_3	Size_4
1	NA	2.00	NA	NA	NA
2	NA	1.50	0.71	0.71	0.54
7	0.00	1.07	0.79	0.94	0.48
8	NA	NA	0.83	1.12	0.63
10	0.00	NA	0.40	0.92	0.35
11	0.00	0.31	0.25	0.46	0.26
12	0.00	1.03	0.65	0.88	0.45
13	0.08	1.00	0.32	0.94	0.42
14	0.00	0.94	0.84	1.03	0.44
15	0.00	1.20	0.75	0.93	0.39
16	NA	0.76	0.56	0.64	0.25
17	0.00	0.53	0.26	0.67	0.30
18	0.00	1.00	0.47	1.00	0.46

What fraction of needed is being ordered?

WardNum	Size_N	Size_1	Size_2	Size_3	Size_4
1	NA	0.00	NA	NA	NA
2	NA	0.00	0.00	0.00	0.00
7	0	0.05	0.01	0.01	0.01
8	NA	NA	0.00	0.00	0.00
10	0	NA	0.00	0.00	0.00
11	0	0.02	0.01	0.01	0.01
12	0	0.19	0.11	0.04	0.04
13	0	0.01	0.01	0.01	0.01
14	0	0.11	0.07	0.04	0.03
15	0	0.02	0.01	0.00	0.01
16	NA	0.03	0.02	0.01	0.01
17	0	0.02	0.00	0.00	0.01
18	0	0.01	0.00	0.00	0.01

Comments

• From Amazon, a Size 1 baby uses 215 diapers per month
  
• From Amazon, there are 216 Size 1 diapers in a 13.314.812.6 package (cubic inches)
  
• This yields 11.48 cubic inches per Size 1 diaper
  
• Assume a ‘standard case’ size of 17.511.510.5 (cubic inches)
  
• This means a standard case has 184 Size 1 diapers
  
• Rideau Vanier has 4315 Population in private households for income status|Less than 18 years from the NHS data
  
• Assume 3/18 are less than 3 yrs old
  
• Split into age groups accordingly
  
• Amazon says Size 1 diapers are for 8-14 lb babies
  
• Via growth tables, this translates to 1.5 -> 3.25 month old babies
  
• Do all the arithmetic, yields ordered are about 19% of total needed to ward, OFB supplying 103% of orders.