Burden Hours Spreadsheet

---

Overview

12 Burden Hours Collection
14 Annual Cost to Fed Gov Est
Est Prof Wage Rate
NA Not Inc in Burden Hours

---

Sheet 1: 12 Burden Hours Collection

USDA RURAL BUSINESS COOPERATIVE SERVICE
GUIDELINES FOR DESIGNATING BIOBASED PRODUCTS FOR FEDERAL PROCUREMENT
INFORMATION COLLECTION BURDEN HOURS
OMB # 0570-0073
May 9, 2023
Estimated No. of Total Respondents (Applicants)		220							Total Estimated Burden for each individual application	$1,787.10
Average hours per response		40.000							Number of responses per respondent	1.00
Gray Columns have automatic formulas. DO NOT input numbers in these columns.					TOTAL	220		8,800		$393,162
(A)	(B)	(C)		(D)	(E)	(F)	(G)	(H)	(I)	(J)
Regulation Reference	Title	Form No. (If Any)	% of Respondents Line Item is Applicable To	Estimated # of Respondents	Reports Filed Annually	Total Responses (D) x (E)	Estimated # of Hours Per Response	Estimated Total Hours (F) x (G)	Prof. Wage Rate	Total Cost (H) x (I)
	Typical Biobased Products		27%	60	1	60	40.00	2,400	$44.68	107,226
	Intermediate Ingredients		7%	15	1	15	40.00	600	$44.68	26,807
	Finished Products Made from Designated Intermediate Ingredients		57%	125	1	125	40.00	5,000	$44.68	223,388
	Complex Assemblies		9%	20	1	20	40.00	800	$44.68	35,742

---

Sheet 2: 14 Annual Cost to Fed Gov Est

USDA RURAL BUSINESS COOPERATIVE SERVICE
GUIDELINES FOR DESIGNATING BIOBASED PRODUCTS FOR FEDERAL PROCUREMENT
ANNUALIZED COST TO THE FEDERAL GOVERNMENT
OMB # 0570-0073
May 9, 2023
OPM GS Pay Tables - Table 2023 DCB		https://www.opm.gov/policy-data-oversight/pay-leave/salaries-wages/2023/general-schedule
OPM SES Schedules - Table 2023-ES		Executive Senior Level (opm.gov)
Benefit % (OMB Memo M-08 13)	https://www.whitehouse.gov/wp-content/uploads/legacy_drupal_files/omb/memoranda/2008/m08-13.pdf									36.25%
Gray & Blue Columns have automatic formulas. DO NOT input numbers in these columns.						Total	69.00	$3,626.28		$178,582.00		Contractor 1		Contractor 2
Staff Position	GS Grade	GS Step	GS Salary	Hourly Rate Calc	Benefits Calc	Total Salary Rate Calc	Hours Required	Cost Subtotals	# of Responses	Total Costs		583,000		1,059,000
Typical Biobased Products - 60 Responses							14.00	$757.55	60	$45,452.76
Contractor 1							7.00	$314.42				18,865.38	3%
Contractor 2							5.00	$229.27						13,756.01	1%
Procurement Analyst	14	5	$150,016	$72.12	$26.14	$98.27	1.00	$98.27
Assistant Deputy Administrator	15	5	$176,458	$84.84	$30.75	$115.59	1.00	$115.59
Intermediate Ingredients - 15 Responses							14.00	$757.55	15	$11,363.19
Contractor 1							7.00	$314.42				4,716.35	1%
Contractor 2							5.00	$229.27						3,439.00	0.3%
Procurement Analyst	14	5	$150,016	$72.12	$26.14	$98.27	1.00	$98.27
Assistant Deputy Administrator	15	5	$176,458	$84.84	$30.75	$115.59	1.00	$115.59
Finished Products Made from Designated Intermediate Ingredients - 125 Responses							14.00	$757.55	125	$94,693.25
Contractor 1							7.00	$314.42				39,302.88	7%
Contractor 2							5.00	$229.27						28,658.35	3%
Procurement Analyst	14	5	$150,016	$72.12	$26.14	$98.27	1.00	$98.27
Assistant Deputy Administrator	15	5	$176,458	$84.84	$30.75	$115.59	1.00	$115.59
Complex Assemblies - 20 Responses							27.00	$1,353.64	20	$27,072.79
Contractor 1							18.00	$818.81				16,376.20	3%
Contractor 2							7.00	$320.97						6,419.47	1%
Procurement Analyst	14	5	$150,016	$72.12	$26.14	$98.27	1.00	$98.27
Assistant Deputy Administrator	15	5	$176,458	$84.84	$30.75	$115.59	1.00	$115.59
Typical Biobased Products - 60 Responses							14.00	$757.55	60	$45,452.76
Contractor			$80,000	$38.46	$13.94	$52.40	3.00	$157.21
Contractor			$60,000	$28.85	$10.46	$39.30	4.00	$157.21
Contractor			$70,000	$33.65	$12.20	$45.85	5.00	$229.27
Procurement Analyst	14	5	$150,016	$72.12	$26.14	$98.27	1.00	$98.27
Assistant Deputy Administrator	15	5	$176,458	$84.84	$30.75	$115.59	1.00	$115.59
				$0.00	$0.00	$0.00		$0.00
Intermediate Ingredients - 15 Responses							14.00	$757.55	15	$11,363.19
Contractor			$80,000	$38.46	$13.94	$52.40	3.00	$157.21
Contractor			$60,000	$28.85	$10.46	$39.30	4.00	$157.21
Contractor			$70,000	$33.65	$12.20	$45.85	5.00	$229.27
Procurement Analyst	14	5	$150,016	$72.12	$26.14	$98.27	1.00	$98.27
Assistant Deputy Administrator	15	5	$176,458	$84.84	$30.75	$115.59	1.00	$115.59
				$0.00	$0.00	$0.00		$0.00
				$0.00	$0.00	$0.00		$0.00
Finished Products Made from Designated Intermediate Ingredients - 125 Responses							14.00	$757.55	125	$94,693.26
Contractor			$80,000	$38.46	$13.94	$52.40	3.00	$157.21
Contractor			$60,000	$28.85	$10.46	$39.30	4.00	$157.21
Contractor			$70,000	$33.65	$12.20	$45.85	5.00	$229.27
Procurement Analyst	14	5	$150,016	$72.12	$26.14	$98.27	1.00	$98.27
Assistant Deputy Administrator	15	5	$176,458	$84.84	$30.75	$115.59	1.00	$115.59
				$0.00	$0.00	$0.00		$0.00
				$0.00	$0.00	$0.00		$0.00
				$0.00	$0.00	$0.00		$0.00
				$0.00	$0.00	$0.00		$0.00
				$0.00	$0.00	$0.00		$0.00
Complex Assemblies - 20 Responses							20.00	$1,032.67	20	$20,653.33
Contractor			$80,000	$38.46	$13.94	$52.40	5.00	$262.02
Contractor			$60,000	$28.85	$10.46	$39.30	6.00	$235.82
Contractor			$70,000	$33.65	$12.20	$45.85	7.00	$320.97
Procurement Analyst	14	5	$150,016	$72.12	$26.14	$98.27	1.00	$98.27
Assistant Deputy Administrator	15	5	$176,458	$84.84	$30.75	$115.59	1.00	$115.59
				$0.00	$0.00	$0.00		$0.00

---

Sheet 3: Est Prof Wage Rate

USDA RURAL BUSINESS COOPERATIVE SERVICE
GUIDELINES FOR DESIGNATING BIOBASED PRODUCTS FOR FEDERAL PROCUREMENT
ESTIMATED PROFESSIONAL WAGE RATE
OMB # 0570-0073
May 9, 2023
Profession	Median Weekly Employee Earnings 1	Median Hourly Rate (40 Hr/ Week)	Benefits 2	Total Hourly Wage	% Time Spent on Burden	Weighted Hourly Salary
Management Occupations	$1,658	$41.45	$12.23	$53.68	50%	$26.84
Manufacturing	$1,102	$27.55	$8.13	$35.68	50%	$17.84
TOTAL					100%	$44.68
1. U.S. Bureau of Laobr Statistics Current Population Survey Table 43, Industry, Manufacturing, Total					CPS Tables : U.S. Bureau of Labor Statistics (bls.gov)
2. U.S. Bureau of Labor Statistics Economic News Release, Employer Costs for Employee Compensation - December 2022, Private Industry Workers Benefits %				[Threaded comment] Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924 Comment: How to obtain the Benefits %: 1) Click the website 2) Choose "The PDF version of the news release" 3) The current release is dated March 2023 and the reported % is in the 3rd paragraph on page 1 and it is 29.5% https://www.bls.gov/news.release/ecec.toc.htm	29.50%
2. U.S. Bureau of Labor Statistics Economic News Release, Employer Costs for Employee Compensation - December 2022, Private Industry Workers Benefits %
	[Threaded comment] Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924 Comment: How to obtain the Benefits %: 1) Click the website 2) Choose "The PDF version of the news release" 3) The current release is dated March 2023 and the reported % is in the 3rd paragraph on page 1 and it is 29.5% https://www.bls.gov/news.release/ecec.toc.htm

---

Sheet 4: NA Not Inc in Burden Hours

USDA RURAL BUSINESS COOPERATIVE SERVICE
GUIDELINES FOR DESIGNATING BIOBASED PRODUCTS FOR FEDERAL PROCUREMENT
INFORMATION COLLECTION NOT INCLUDED IN BURDEN HOURS
OMB # 0570-0073
May 9, 2023
Gray Columns have automatic formulas. DO NOT input numbers in these columns.							Total Hours and Cost Not Included in Burden Hours:	0		0
(A)	(B)	(C)		(D)	(E)	(F)	(G)	(H)	(I)	(J)
NOFO Section	Title	Form No. (If Any)	% of Respondents Line Item is Applicable To	Estimated # of Respondents	Reports Filed Annually	Total Responses (D) x (E)	Estimated # of Hours Per Response	Estimated Total Hours (F) x (G)	Prof. Wage Rate	Total Cost (H) x (I)
Not Applicable For this Package