NREGA_Budget_SupplementaryCalculations_FY24-25

	B	C	D	E	G	H	I	J	L	M	N	O
1	This sheet estimates the minimum budget required for NREGA to function in FY 24-25. This is a conservative calculation - we only use 4.9 crore households that were active in FY 23-24, not the total registered households.
2
3
4	For wage rate @ 249				For wage rate @ 400				For wage rate @ 800
5	Total hh demanded work in FY 23-24	6.5 crores			Total hh demanded work in FY 23-24	6.5 crores			Total hh demanded work in FY 23-24	6.5 crores
6	Number of days	100			Number of days	100			Number of days	100
7	Wage Rate	249			Wage Rate	400			Wage Rate	800
8	Wage Bill	1,61,850 crores	249 * 100 * 6.5 crores	161850	Wage Bill	2,60,000 crores	400 * 100 * 6.5 crores	260000	Wage Bill	5,20,000 crores	800 * 100 * 4.9 crores	520000
9	Total Wage Bill + Material Costs	2,69,750 crores	(100/60) * 1,61,850 crores	269750	Total Wage Bill + Material Costs	4,33,333 crores	(100/60) * 2,60,000 crores	433333	Total Wage Bill + Material Costs	8,66,667 crores	(100/60) * 5,20,000 crores	866667
10	Total Material Costs	1,07,900 crores	2,69,750 crores - 1,61,850 crores	107900	Total Material Costs	1,73,333 crores	4,33,333 crores - 2,60,000 crores	173333	Total Material Costs	3,46,667 crores	8,66,667 crores - 5,20,000 crores	346667
11	Centre's share of material costs	80,925 crores	0.75 * 1,07,900 crores	80925	Centre's share of material costs	1,30,000 crores	0.75 * 1,73,333 crores	130000	Centre's share of material costs	2,60,000 crores	0.75 * 3,46,667 crores	260000
12	Wage Bill + Material Costs + Admin Costs	2,79,447 crores	(100/96.53) * 2,69,750 crores	279447	Wage Bill + Material Costs + Admin Costs	4,48,910 crores	(100/96.53) * 4,33,333 crores	448910	Wage Bill + Material Costs + Admin Costs	8,97,821 crores	(100/96.53) * 8,66,667 crores	897821
13	Admin costs	9,697 crores	2,79,447 crores - 2,69,750 crores	9697	Admin costs	15,577 crores	4,48,910 crores - 4,33,333 crores	15577	Admin costs	31,154 crores	8,97,821 crores - 8,66,667 crores	31154
14	Recommended budget for FY25-26 (without factoring in the pending payments)	2,52,472 crores	1,61,850 crores + 80,925 crores + 9,697 crores	252472	Recommended budget for FY25-26 (without factoring in the pending payments)	4,05,577 crores	2,60,000 crores + 1,30,000 crores + 15,577 crores	405577	Recommended budget for FY25-26 (without factoring in the pending payments)	8,11,154 crores	5,20,000 crores + 2,60,000 crores + 31,154 crores	811154
15
16
17		249	34.06318324
18		400	21.20435824
19		800	10.60217912
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
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