Attachment B - Excel Burden Chart for 0584-0012 School Breakfast Program Final 8.24.15

---

Overview

RecordKeeping
Reporting
60 day Summ
Burden Summary

---

Sheet 1: RecordKeeping

Recordkeeping
				A	B	C = (A*B)	D	E= (C*D)	F				G =E-F
Child Nutrition Program	CFR Citation	Regulation	Form Number	Estimated # Record-keepers	Records Per Recordkeeper	Total Annual Records	Estimated Avg. # of Hours Per Record	Estimated Total Hours	Current OMB Approved Burden Hrs	Due to Authorizing Statute	Due to Program Change - Proposed Rule	Due to an Adjustment	Total Difference
State Agency Level
Breakfast	§220.12(a)	SAs must establish rules on competitive foods		56	1	56	1.00	56.00	56				0
Breakfast	§220.13(b)(1)	SA maintains Program records as necessary to support the reimbursement payments and reports.		Source: NDB 56 State Agencies 56	per SWRO FM staff each SA averages 3 requests per month (3x12) 36	2,016	0.083	167	167				0
Breakfast	§220.13(c)	SA maintains evidence of complaint investigations and actions.		56	1	56	2.00	112.00	112				0
Breakfast	§220.14(d)	SA maintains all records pertaining to claims against SFAs.		56	Avg of 12 per SA 12	672	0.25	168.00	776			-607	-608
Breakfast	§220.9(d)	SA determination of severe need.		0	1	0	0.50	0.00	28			-28	-28
Breakfast	§220.11(b)	duplicate (this is SFA/school burden, not SA)		0	0	0	0.00	0.00	34,742			-34,742	-34,742
		State Agency Level Total		56	50.00	2,800	0.18	503	35,881	0	0	-35,377	-35,377
Institution Level
Breakfast	§220.11(b)	SFA maintains Program records to support claims.		Source: NDB 20,386 SFAs 20,386	10 monthly claims per school year 10	203,860	0.083	16,920.38	103,485			-86,565	-86,565
						0		0.00					0
		School Food Authority Level Total		20,386	10.00	203,860	0.08	16,920	103,485	0	0	-86,565	-86,565
Site Level
Breakfast	§220.11(b)	Schools record breakfasts by category at point of service.		Source: NDB Schools operating SBP for FY14 89,828	Number of school days 180	16,169,040	0.10	1,616,904.00	1,597,842			19,062	19,062
Breakfast	§220.8(a)(3) & 220.9(a)	Schools record menu, food production, and recent nutrition analysis.		89,828	180	16,169,040	0.12	1,940,284.80	1,917,410			22,875	22,875
		School Level Total		89,828	360	32,338,080	0.11	3,557,189	3,515,252	0	0	41,937	41,937
		Total Recordkeeping Burden		110,270	295.14	32,544,740	0.11	3,574,613	3,654,618	0	0	-80,005	-80,005
			Child Nutrition Program	Estimated # Record-keepers	Records Per Recordkeeper	Total Annual Records	Estimated Avg. # of Hours Per Record	Estimated Total Hours	Current OMB Approved Burden Hrs	Due to Authorizing Statute	Due to Program Change - Proposed Rule	Due to an Adjustment	Total Difference
			Breakfast	110,270	295.13634	32,544,684	0.110	3,574,557	3,654,562	0	0	(80,005)	(80,005)
			0	-	-	-	-	-	-				-
			0	-	-	-	-	-	-				-
			0	-	-	-	-	-	-				-	"Please un-hide the colums 40-47 for more data"
			#REF!	-	-	#REF!	-	#REF!	#REF!				#REF!
			0	-	-	-	-	-	-				-
			Total	110,270	295.14	#REF!	0.11	#REF!	#REF!	0	0	-80,005	#REF!

---

Sheet 2: Reporting

Reporting
				A	B	C = (A*B)	D	E= (C*D)	F				G =E-F
Prgm Rule	CFR Citation	Title	Form Number	Estimated # Respondents	Responses per Respondents	Total Annual Records	Estimated Avg. # of Hours Per Response	Estimated Total Hours	Current OMB Approved Burden Hrs	Due to Authorizing Statute	Due to Program Change -	Due to an Adjustment	Total Difference
State Agency Level
Breakfast	§220.5	SA submits requests for funds to pay SBP claims.		Source: SAE 56 State agencies 56	per SWRO FM staff each SA averages 3 requests per month (3x12) 36	2,016	0.25	504.00	504				0
Breakfast	§220.13(b)(2)	SA submits quarterly report (FNS-777). THIS BURDEN WAS TRANSFERRED TO THE FPRS ICR.		0	4	0	3.20	0.00	717			-717	-717
Breakfast	§220.15(b)	SA provides records for MEs and audits.		1/3 of SAs annually receive MEs & audits 19	1	19	3.00	57.00	57				0
Breakfast	§220.19	SA termination for failure to comply.		0	1	0	2.00	0.00	112			-112	-112
		State Agency Level Total		56	36.34	2,035	0.28	561	1,390	0	0	-829	-829
School Food Authority Level
Breakfast	§220.7(a)	SFA must submit to SA an application to operate the SBP in a new school.		Estimate an average of 3 SFAs per SA submiting a new application (56x3). 168	1	168	0.25	42.00	42				0
Breakfast	§220.11(a)	SFAs submit monthly claims to SA		Source: NDB 20,386 SFAs 20,386	10	203,860	1.00	203,860.00	223,528			-19,668	-19,668
Breakfast	§220.11(b)	SFAs requesting a claim exception		Estimate 1% of SFAs submit an exception for a late claim (20,386* .01 = 204) 204	1	204	0.75	153.00	776			-623	-623
Breakfast	§220.15(c)	SFAs will provide records for audits.		(Burden determined negligible during last renewal, but wasn't in the burden chart.) 82	1	82	2.00	164.00	164				0
		School Food Authority Level Total		20,386	10.02	204,314	1.00	204,219	224,510	0	0	-20,291	-20,291
School Level
Breakfast	§220.11(b)	Schools submit breakfast counts by category to SFA.		Source: NDB Schools operating SBP for FY14 89,828	10 monthly claims per school year 10	898,280	0.05	44,914.00	44,385			530	530
		School Level Total		89,828	10	898,280	0	44,914	44,385	0	0	530	530
		Total Reporting Burden		110,270	10.02	1,104,629	0.23	249,694	270,284	0	0	-20,590	-20,590
			Prgm Rule	Estimated # Respondents	Responses per Respondents	Total Annual Records	Estimated Avg. # of Hours Per Response	Estimated Total Hours	Current OMB Approved Burden Hrs	Due to Authorizing Statute	Due to Program Change -	Due to an Adjustment	Total Difference
			Breakfast	110,270	10.01749	1,104,629	0.22604	249,694	270,284	0	0	(20,590)	(20,590)
			0	-	-	-	-	-	-				-
			0	-	-	-	-	-	-				-
			0	-	-	-	-	-	-				-	"Please un-hide the colums 40-47 for more data"
			0	-	-	-	-	-	-				-
			0	-	-	-	-	-	-				-
			0	-	-	-	-	-	-				-
			Total	110,270	10.02	1,104,629	0.23	249,694	270,284	0	0	-20,590	-20,590

---

Sheet 3: 60 day Summ

SUMMARY OF BURDEN RECORDKEEPING & REPORTING
TOTAL NO. RESPONDENTS	110,270
AVERAGE NO. RESPONSES PER RESPONDENT	305.1543
TOTAL ANNUAL RESPONSES	33,649,369
AVERAGE HOURS PER RESPONSE	0.113651655934469
TOTAL BURDEN HOURS WITH REVISION	3,824,307
CURRENT OMB INVENTORY	3,924,902		This is the Current OMB Approved Burden Hrs column 'J'
DIFFERENCE (NEW BURDEN REQUESTED WITH REVISION)	-100,595

---

Sheet 4: Burden Summary

OMB Control #0584-0012 - Burden Summary - 7 CFR Part 220, School Breakfast Program Regulations
	Estimated # Respondents	Responses Per Respondent	Total Annual Responses (Col. BxC)	Estimated Avg. # of Hours Per Response	Estimated Total Hours (Col. DxE)
Recordkeeping
State Agency Level	56	50.00	2,800	0.18	503
Institution Level	20,386	10.00	203,860	0.08	16,920
Site Level	89,828	360	32,338,080	0.11	3,557,189
Recordkeeping Total	110,270	295.14	32,544,740	0.11	3,574,613
Reporting
State Agency Level	56	36.34	2,035	0.28	561
Institution Level	20,386	10.02	204,314	1.00	204,219
Site Level	89,828	10.00	898,280	0.05	44,914
Reporting Total	110,270	10.02	1,104,629	0.23	249,694
TOTAL BURDEN FOR (Title)	110,270	305.1543	33,649,369	0.1137	3,824,307