Appendix C Burden table.xlsx

---

Overview

FRN main table
Staff interviews_v2
Staff interviews
Admin data_v2
Admin data_v1

---

Sheet 1: FRN main table

					Respondents					Non-respondents
Affected public	Data collection activity	Appendix Reference	Respondents type	Sample size	Estimated number of respondents	Frequency of response	Total annual responses	Average burden hours per response	Total annual burden estimate (hours)	Estimated number of non-respondents	Frequency of response	Total annual responses	Average burden hours per response	Total annual burden estimate (hours)	GRAND TOTAL BURDEN ESTIMATE					Responses	Respondents
Individuals and households	Invitation call script	F-1	Parent/ caretaker	750	300	1	300	0.0350	10.50	450	1	225	0.0350	7.88	18.38
	Confirmation letter	F-2	Parent/ caretaker	750	300	1	300	0.0150	4.50	450	1	112.5	0.0150	1.69	6.19
	Reminder call script	F-3	Parent/ caretaker	750	300	1	300	0.0100	3.00	450	1	112.5	0.0100	1.13	4.13
	Consent form	M	Parent/ caretaker	750	300	1	300	0.0200	6.00	450	0	0	0.00	0.00	6.00
	In-person interview	E	Parent/ caretaker	750	300	1	300	1.5000	450.00	450	0	0	0.00	0.00	450.00
Subtotal individuals and households				750	300	5	1500	0.316	474.00	450	1	450	0.02375	11	485					1,950	750
State and local government	Template for email from FNS Regional Office to State SNAP agency	N-1	12 State SNAP agency directors, 12 SNAP policy directors, 12 SNAP data managers, 2 SNAP local office directors	50	50	1	50	0.0130	0.65	0	1	0	0.0130	0.00	0.65
	Template for email from FNS headquarters to State SNAP agency	N-2	12 State SNAP agency directors, 12 SNAP policy directors, 12 SNAP data managers, 2 SNAP local office directors	50	50	1	50	0.0130	0.65	0	1	0	0.0130	0.00	0.65
	Template for email from Office of Child Support Enforcement to State child support agency	N-3	12 State Child Support agency directors, 12 Child Support policy directors, 12 Child Support data managers, and 2 Child Support local office agency directors	50	50	1	50	0.0130	0.65	0	1	0	0.0130	0.00	0.65
	Template for email from study team to State child support and SNAP agencies	N-4	12 State SNAP agency directors, 12 SNAP policy directors, 12 SNAP data managers, 2 SNAP local office directors	50	50	1	50	0.0130	0.65	0	1	0	0.0130	0.00	0.65
	Template for email from study team to local child support and SNAP agencies	N-5	12 State Child Support agency directors, 12 Child Support policy directors, 12 Child Support data managers, and 2 Child Support local office agency directors	50	50	1	50	0.0130	0.65	0	1	0	0.0130	0.00	0.65
	Project fact sheet	N-6	SNAP: 12 State SNAP agency directors, 12 SNAP policy directors, 12 SNAP data managers, 2 SNAP local office directors; Child Support: 12 State Child Support agency directors, 12 Child Support policy directors, 12 Child Support data managers, and 2 Child Support local office agency directors	100	100	1	100	0.0130	1.30	0	1	0	0.0130	0.00	1.30
	In-person interview	D-1	State or local agency director/ manager (Same breakdown as depicted in cell above)	100	100	1	100	1.00	100.00	0	0	0	0.00	0.00	100.00
	In-person interview	D-1 and D-2	State or local (SNAP: 105 SNAP direct service staff; Child Support: 105 Child Support direct service staff)	210	210	1	210	1.77	371.70	0	0	0	0.00	0.00	371.70
	Template for email from Office of Child Support Enforcement to State child support agency	N-3	Representative or staff from State legislature or judicial system	12	12	1	12	0.0130	0.16	0	1	0	0.0130	0.00	0.16
	Template for email from study team to State child support and SNAP agencies	N-4	Representative or staff from State legislature or judicial system	12	12	1	12	0.0130	0.16	0	1	0	0.0130	0.00	0.16
	Project fact sheet	N-6	Representative or staff from State legislature or judicial system	12	12	1	12	0.0130	0.16	0	1	0	0.0130	0.00	0.16
	In-person interview	D-1	Representative or staff from State legislature or judicial system	12	12	1	12	1.00	12.00	0	0	0	0.00	0.00	12.00
	Written data collection request; any needed clarifying discussions	N-4 / N-5	State or local agency director/ manager	24	24	1	24	2.00	48.00	0	1	0	2.00	0.00	48.00
	Provide SNAP agency adminsitrative data	G	State or local agency director/ manager	12	12	1	12	17.50	210.00	0	0	0	17.50	0.00	210.00
	Provide Child Support agency adminsitrative data	H	State or local agency director/ manager	12	12	1	12	17.50	210.00	0	0	0	17.50	0.00	210.00
	Written data collection request; any needed clarifying discussions	N-4 / N-5	State or local agency director/ manager	6	6	2	12	1.00	12.00	0	1	0	0.0835	0.00	12.00
	Provide cost data	I	State or local agency director/ manager	6	6	2	12	4.00	48.00	0	0	0	0.00	0.00	48.00	468.00	0.309172616422813
Subtotal State, Local and Tribal government				352	352	2.21590909090909	780	1.30348461538462	1,016.72	0	--	0	--	0	1,016.72					780	352
(Business-for-profit or not-for-Profit) Private sector	Template for email from study team to local child support and SNAP agencies	N-5	Advocate or other stakeholder	12	12	1	12	0.0130	0.16	0	1	0	0.0130	0.00	0.16
	Project fact sheet	N-6	Advocate or other stakeholder	12	12	1	12	0.0130	0.16	0	1	0	0.0130	0.00	0.16
	In-person interview	D-3	Advocate or other stakeholder	12	12	1	12	1.00	12.00	0	0	0	0.00	0.00	12.00
Subtotal private sector				12	12	3	36	0.342	12.31	0	--	0	--	0	12.31					36	12
Grand total				1,114	664	3.48795180722892	2,316	0.648976683937824	1,503.03	450	1	450	0.0238	10.69	1,513.72					2,766	1,114

---

Sheet 2: Staff interviews_v2

		Per state				Total
	# of states	# of managers and sups	# frontline	Legislator or court staff	Advocate	# of managers and sups	# frontline	Legislator or court staff	Advocate
Implementation assessment	7	10	30	1	1	70	210	7	7
Considering	3	6	0	1	1	18	0	3	3
Formerly implementing	2	6	0	1	1	12	0	2	2
Total	12					100	210	12	12	334
In the new version we need a weighted average of interview duration for the frontline staff
	Staff	Duration
Process mapping	16	2.00	32
Interviews	14	1.50	21
Total	30	1.77	53

---

Sheet 3: Staff interviews

		Per state				Total
	# of states	# of managers and sups	# frontline	Stakeholders (i.e. judicial system representatives, advocates, legislators)	# of managers and sups	# frontline	Stakeholders (i.e. judicial system representatives, advocates, legislators)
Implementation assessment	7	10	Andrew Gothro: 2.5 frontline staff per interview, on average. 4 staff for proces mapping (2 hour time slot but 90minute discussion) 3 staff for one on one frontline staff interviews (1 hour each) 14	2	70	98	14
Considering	3	6	0	2	18	0	6
Formerly implementing	2	6	0	2	12	0	4
Total	12				100	98	24	222
Post QA:
		Per state				Total
	# of states	# of managers and sups	# frontline	Legislator or court staff	Advocate	# of managers and sups	# frontline	Legislator or court staff	Advocate
Implementation assessment	7	10	Andrew Gothro: 2.5 frontline staff per interview, on average. 14	1	1	70	98	7	7
Considering	3	6	0	1	1	18	0	3	3
Formerly implementing	2	6	0	1	1	12	0	2	2
Total	12					100	98	12	12	222

---

Sheet 4: Admin data_v2

Evaluation of Child Support Requirements in SNAP:
Respondent Burden for Administrative Data Collection
	Number of states	Agencies per state	Total respondents	Hours per respondent	Total hours
Impact study states:	9	2	18	40	720
Feasibility only states:	3	2	6	20	120
Total	12	2	24	35	840

---

Sheet 5: Admin data_v1

	Implementing states
	Request data from two years before through the present
	Previously implemented
	Request four years of data
	Implementing	Previously implemented	Weighted average
States	7	2	9
Months	150	48	127.33
	Implementors	Most recently since:	Years of data through 2020
	Michigan	1996	26
	Florida	2001	21
	Kansas	2015	7
	Maine	2018	4
	Mississippi	1996	26
	South Dakota	2017	5
	Idaho	2015	7
	Arkansas	2019	3
			12.4	years
			148.5	months