Burden Excel Chart

---

Overview

RecordKeeping
Reporting
60 day Summ
Burden Summary
Notes

---

Sheet 1: RecordKeeping

Recordkeeping
				A	B	C = (A*B)	D	E= (C*D)	F	G =E-F
Prgm Rule	CFR Citation	65	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	Total Difference
State Agency Level
Milk	215.7	SA maintains applications submitted by, and agreements executed with, SFAs and sponsors.		Source:NDB 54 State Agencies 54	Avg per SA of 5569 total institutions Source: NDB 103.13	5,569	0.58	3,202	4,654	-1,452
Milk	215.11(b)(2)	SA maintains records of civil rights site visits.		54	Average per SA Source: NDB 3847 SFAs (possible CRE review every 3 years) 22.50	1,215	Decreased from over an hour to 15 min 0.25	304	2,134	-1,830
Milk	215.11(b)(3)	Documentation of Program assistance.		54	Average per SA Source: NDB 3847 SFAs (possible CRE review every 3 years) 22.50	1,215	0.36	437	800	-363
Milk	215.11(c)(1)	Maintenance of Program records to support reimbursement payments (accounting records of the receipt, custody, and disbursement of Federal funds).		54	24.40	1,317.60	0.0952	125.45	132	-7
Milk				54	Avg institutions * 12 months 1,176	63,504	0.08	5,080	12,555	-7,475
Milk	215.12	Records of corrective actions taken on improper claims.		54	Avg of 2 per SA have corrective action 2	108	0.33	36	1,254	-1,218
Milk	215.13(a)	A-133 Audit, Audit Plan, and Management Evaluations including records of the receipt and expenditure of funds under the Program.		54	Reduced to 5 per SA 1	54	Decreased from over an hour to 15 min 0.25	14	2,443	-2,430
Milk		A133-Audit Plan (merged into the above)		0	0	0	0.00	0	35	-35
		State Agency Level Total		54	1,351.53	72,983	0.12604	9,199	24,007	-14,808
Institution Level
Milk	215.7(d)(1)	Records of Program revenues and expenditures to demonstrate nonprofitability.THIS BURDEN HAS BEEN TRANSFERRED TO THE FNS-10 ICR.		Source: NDB 3847 SFAs 0	0	0	0.00	0	2,075	-2,075
Milk	215.7(d)(8)	Currently approved and denied applications for free milk.BURDEN MOVED TO FNS-10		Source: NDB 3847 SFAs 0	0	0	0.00	0	2,075	-2,075
Milk	215.7(d)(7) and 215.10	Program records, including documentation of the consolidation of participation, revenue, and cost into claims.THIS BURDEN HAS BEEN TRANSFERRED TO THE FNS10 ICR.		Source: NDB 3847 SFAs 0	monthly for SFAs (10 months) 0	0	0.00	0	20,750	-20,750
Milk				Source: NDB 965 CCIs 0	monthly for CCIs (12 months) 0	0	0.00	0	3,558	-3,558
Milk				Source: NDB 965 summer camps 0	monthly for summer camps (3 months) 0	0	0.00	0	1,445	-1,445
Milk	215.14a	Compliance with procurement requirements		Source: NDB 965 CCIs + 757 summer camps Source: NDB 3847 SFAs 5,569	1	5,569	1.00	5,569	17,118	-11,549
		Institution Level Total		5,569	1.00	5,569	1.00	5,569	47,021	-41,452
Site Level
Milk	215.7	Records of cash collected from paying children at the point of service (moved into institution level)		0	0	0	0	0	127,507	-127,507
Milk	215.10	Claims for reimbursement (removed duplicate burden captured under institution level)		0	0	0	0	0	127,508	-127,508
Milk				0	0	0	0	0	20,014	-20,014
Milk				0	0	0	0	0	10,834	-10,834
		Site Level Total		0	0	0	0	0	285,863	-285,863
		Total Recordkeeping Burden		5,623	14	78,552	0.19	14,768	356,891	-342,123
			Prgm Rule	Estimated # Record-keepers	Records Per Recordkeeper	Total Annual Records	Estimated Avg. # of Hours Per Record	Estimated Total Hours	Current OMB Approved Burden Hrs	Total Difference
			Milk	5,623	13.96970	78,552	0.188	14,768	356,891	(342,123)
			0	-	-	-	-	-	-	-
			0	-	-	-	-	-	-	-
			0	-	-	-	-	-	-	-	"Please un-hide the colums 40-47 for more data"
			0	-	-	-	-	-	-	-
			Total	5,623	#REF!	#REF!	#REF!	#REF!	#REF!	#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	Justification		Data Validation - List
State Agency Level
Milk	215.5(a)	SA requests cash to pay SMP claims.		Source: SAE 57 State Agencies 54	24	1,296	0.33	428	451			-24	-24
Milk	215.11(c)(2)	SA justification supporting the adjustment reported on the FNS-10. THIS BURDEN HAS BEEN TRANSFERRED TO THE FNS 10 ICR.		0	0	0	0.00	0	684			-684	-684			Milk
Milk	215.11(c)(2)	Federal funds obligated and expended for the SMP to date.		54	4	216	1.44	311	328			-17	-17
Milk	215.13(a)	A-133 Audit report and response to A-133 audit findings. Burden determined negligible.		0	0	0	0.00	0	70			-70	-70
Milk		Response to USDA audits of the SA and of SFAs/sponsors under the SA's jurisdiction. Burden determined negligible.		0	0	0	0.00	0	12			-12	-12
Milk	215.16	Grant Closeout Reports		54	2	108	1.44	156	164				-9
		State Agency Level Total		54	30	1,620	0.55	894	1,710	0	0	-807	-816
Institution Level
Milk	§215.10(a)&(b)	SFAs submit original and revised claim forms to SA for reimbursement. THIS BURDEN HAS BEEN TRANSFERRED TO THE FNS10 ICR.		Source: NDB 3847 SFAs	monthly for SFAs (10 months)	0	0.00	0	34,238			-34,238	-34,238
Milk				Source: NDB 965 CCIs	monthly for CCIs (12 months)	0	0.00	0	5,782			-5,782	-5,782
Milk				Source: NDB 965 summer camps	monthly for summer camps (3 months)	0	0.00	0	2,167			-2,167	-2,167
Milk	§215.7(d)	SFA must submit to SA an application and agreement to operate the SMP.	FNS-66	10	1	10	1.50	15	0				15
Milk	§215.13(a)	Response to USDA audit findings. Copy of A - 133 Audit Report and responses to A - 133 findings.		5,569	1	5,569	1.00	5,569	6,321			-6,321	-752
		Institution Level Total		5,569	1.0018	5,579	1.0009	5,584	48,508	0	0	-48,508	-42,924
Site Level
Milk	215.7(d)(6)	Totals of cash collected from paying children (not reported … under recordkeeping only)		0	0	0	0	0	5,038			-5,038	-5,038
Milk	215.10(a)	Totals of daily point-of-service counts of milk served to children (removed duplicate burden captured under institution level)THIS BURDEN HAS BEEN TRANSFERRED TO THE FNS10 ICR.		Source: NDB 4004 schools (pub,pvt, RCCI)	monthly for SFAs (10 months)	0	0	0	96,339			-96,339	-96,339
		Site Level Total		0	0	0	0	0	101,377	0	0	-101,377	-101,377
		Total Reporting Burden		5,623	1.28	7,199	0.90	6,478	151,595	0	0	-150,692	-145,117
			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
			Milk	5,623	1.28028	7,199	0.89988	6,478	151,595	0	0	(150,692)	(145,117)
			0	-	-	-	-	-	-				-
			0	-	-	-	-	-	-				-
			0	-	-	-	-	-	-				-		"Please un-hide the colums 40-47 for more data"
			0	-	-	-	-	-	-				-
			Total	5,623	#REF!	#REF!	#REF!	#REF!	#REF!	0	0	-150,692	#REF!

---

Sheet 3: 60 day Summ

SUMMARY OF BURDEN RECORDKEEPING & REPORTING
TOTAL NO. RESPONDENTS	5,623
AVERAGE NO. RESPONSES PER RESPONDENT	15.2500
TOTAL ANNUAL RESPONSES	85,751
AVERAGE HOURS PER RESPONSE	0.247763125164576
TOTAL BURDEN HOURS FOR PART 215 WITH REVISION	21,246
CURRENT OMB INVENTORY FOR PART 215	508,485		This is the Current OMB Approved Burden Hrs column 'J'
DIFFERENCE (NEW BURDEN REQUESTED WITH REVISION)	-487,240

---

Sheet 4: Burden Summary

OMB Control #0584-0005 - Burden Summary - 7 CFR Part 215, Special Milk 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	54	1,352	72,983	0	9,199
Institution Level	5,569	1	5,569	1	5,569
Site Level	-		-		-
Recordkeeping Total	5,623	13.97	78,552	0.19	14,768
Reporting
State Agency Level	54	30	1,620	1	894
Institution Level	5,569	1	5,579	1	5,584
Site Level	-		-		-
Reporting Total	5,623	1.28	7,199	0.90	6,478
TOTAL BURDEN FOR (Title)	5,623	15.2500	85,751	0.2478	21,246
Add total number of recordkeepers to the total annual responses.

---

Sheet 5: Notes

Date	User Initials	Comments
11/1/11	SW	This is a DRAFT of the Special Milk Program Burden doc using the redesigned template
11/2/11	SW	Burden reduction for renewal. Need to eliminate burden associated with the FNS-10 and FNS-777 to not duplicate burden in those ICRs.
11/22/11	BB	Removed duplicate burden at site level; regulatory language puts burden of information collection at insitution level
1/11/12	BB	revised notice to incorporate PRAB comments; returned to PRAB 1.12.12
2/8/12	BB/SW	reformated Excel spreadsheet