Food Basket (Al amin-2).xlsx

	B	C	D	E	F	G	H	J	K
1
2
3
4
5
6
7
8	Food Basket Analysis
9
10	Worker Name:MD. Hafizur Rahman				ID No:020215020145
11	Designation:Loder				Section:Fabric store
12	Location:Master bari bazar				Date: 16.02.2020
13	Basic Food Basket Per Person
14	S. No.	Items	Rate (Tk./ Kg.)	Calorific Value (K.Cal/ Kg)	Quantity (Gram/day)	Calrie Value intake	Subtotal (BDT./day)
15	1	Rice	42	2000	300	600	12.60	30	378
16	2	Wheat	26	3290	140	460.6	3.64	30	109.2
17	3	Dal & Pulses	80	1037	50	51.85	4.00	30	120
18	4	Meat (Chicken)	120	1436	80	114.88	9.60	30	288
19	5	Fish	110	2058	85	174.93	9.35	30	280.5
20	6	Egg	120	1551	60	93.06	7.20	30	216
21	7	Vegetables	45	652	200	130.4	9.00	30	270
22	8	Oil, fat,…	95	8841	60	530.46	5.70	30	171
23	9	Masala	200	3205	30	96.15	6.00	30	180
24	10	Sugar	60	3867	10	38.67	0.60	30	18
25	11	Fruits - Banana	160	700	100	70	16.00	30	480
26	Total			28637		2361	83.69
27		Total (Per month)					2510.70
28
29	Average monthly family expenses information
30		S.No.	Category	Cost in local currency	Number of individual	Total
31		1	Education of Children			0
32		2	Transport	1040		0
33		3	Food	2510.70	2	5021.4
34		4	Clothing	300	2	600
35		5	Energy and water consumption	180		180
36		6	Housing	1800		1800
37		7	Unexpected events	500		500
38		Total P. M				8101.4
39			Savings @ 5%	0		405.07
40			Total Family Basket			8506.47
41
42	Living wage estimation
43
44		Calculation Process	Total family basket	X	110%
45		Calculation Process		Number of wage earners per family
46
47		Calculation	8506.47	X	110%
48		Calculation		1
49
50		Living Wage	9357.117
51
52
53
54	Assessor					Admin
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
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