Burden Hours Spreadsheet 2024 10 12

Burden Hours Biobased Markets 2024 10 02.xlsm

Biobased Markets Program

Burden Hours Spreadsheet 2024 10 12

OMB: 0570-0083

Document [xlsx]
Download: xlsx | pdf

Overview

12 Burden Hours Collection
13 Burden to Respondent
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
BIOBASED MARKETS PROGRAM: FEDERAL PROCUREMENT AND VOLUNTARY LABELING
INFORMATION COLLECTION BURDEN HOURS
OMB # 0570-NEW
October 2, 2024











Estimated No. of Total Respondents (Applicants)
520





Total Estimated Burden for each individual application $379.01
Average hours per response
6.5572





Number of responses per respondent 5.8019
Gray Columns have automatic formulas. DO NOT input numbers in these columns.



TOTAL 3,017
19,783
$1,143,473
(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)
§4270.9(a) Application
100% 520 2 1,040 12.00 12,480 $57.80 721,354
§4270.9(b)(2)(ii), (c)(2), (d) Biobased Content and Testing
100% 520 2 1,040 2.00 2,080 $57.80 120,226
§4270.9 & .14 Maintaing Records and Notice of Certification
57% 295 1 295 4.00 1,180 $57.80 68,205
§4270.12 Appeals
10% 52 1 52 4.00 208 $57.80 12,023
§4270.15 Oversight and Monitoring
57% 295 2 590 6.50 3,835 $57.80 221,666













































Sheet 2: 13 Burden to Respondent

USDA RURAL BUSINESS COOPERATIVE SERVICE
BIOBASED MARKETS PROGRAM: FEDERAL PROCUREMENT AND VOLUNTARY LABELING
ESTIMATED TOTAL ANNUAL COST BURDEN TO RESPONDENTS
OMB # 0570-NEW
October 2, 2024


Gray Columns have automatic formulas. DO NOT input numbers in these columns.
Estimated Annualized Testing Costs
Number of Respondents (Applicants) 520
# of Applications per Respondents 2
# of Single Product or Product Family per Application 1
Estimated # of Products or Product Families for Testing 1,040
Estimated # of Tests per Prodcuts or Product Families 1
Total # of Tests 1,040
Cost per Test $400
Annualized Factor (over 10yrs @ 3.5% interest) 0.22148
Annualized Testing Cost $92,136
Estimated Respondent Labor Costs
Estimated # of Hours per Test 2
Total Annual Burden Hours - Respondents 2,080
Labor Cost per Hour $57.80
Total Annualized Labor Costs $120,226
Total Annualized Cost to Respondents $212,361

Sheet 3: 14 Annual Cost to Fed Gov Est

USDA RURAL BUSINESS COOPERATIVE SERVICE




BIOBASED MARKETS PROGRAM: FEDERAL PROCUREMENT AND VOLUNTARY LABELING




ANNUALIZED COST TO THE FEDERAL GOVERNMENT




OMB # 0570-NEW




October 2, 2024




















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 33.00 $1,059.79
$936,596.20
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
Application (Including Biobased Content/Testing) - 1,040 Responses 19.00 $708.23 1,040 $736,557.84




Contractor 1





12.00 $381.19


396,440.00 68%

Contractor 2





5.00 $101.83




105,900.00 10%
Procurement Analyst 14 5 $157,982 $75.95 $27.53 $103.49 1.00 $103.49






Assistant Deputy Administrator 15 5 $185,824 $89.34 $32.39 $121.72 1.00 $121.72






Maintaing Records and Notice of Certification - 295 Responses 5.00 $143.01 295 $42,188.31




Contractor 1





4.00 $39.53


11,660.00 2%

Procurement Analyst 14 5 $157,982 $75.95 $27.53 $103.49 1.00 $103.49






Appeals - 52 Responses 6.00 $669.30 52 $34,803.43




Procurement Analyst 14 5 $157,982 $75.95 $27.53 $103.49 4.00 $413.94






Assistant Deputy Administrator 15 5 $185,824 $89.34 $32.39 $121.72 1.00 $121.72






Administrator

$204,000 $98.08 $35.55 $133.63 1.00 $133.63






Oversight & Monitoring - 590 Responses 9.00 $208.55 590 $123,046.63




Contractor 1





6.00 $69.17


40,810.00 7%

Contractor 2





2.00 $35.90




21,180.00 2%
Procurement Analyst 14 5 $157,982 $75.95 $27.53 $103.49 1.00 $103.49







Sheet 4: Est Prof Wage Rate

USDA RURAL BUSINESS COOPERATIVE SERVICE
BIOBASED MARKETS PROGRAM: FEDERAL PROCUREMENT AND VOLUNTARY LABELING
ESTIMATED PROFESSIONAL WAGE RATE
OMB # 0570-NEW
October 2, 2024







Instructions:





1. Use the U.S. Bureau of Labor Statistics Occupational Emplyment and Wage Statistics Link below to complete Columns A, B, C for the table below.





a. Click the link: [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 navigate to obtain Prof. Wage Rate: 1) Click the website 2) Under the latest Month Year choose Occupation Profiles 3) Select 11-0000 Management Occupations 4) Select 11-1021 General Operations Managers 5) Use the Mean Hourly Wage https://www.bls.gov/oes/tables.htm




b. Under the latest Month Year (May 2023) click Occupation Profiles





c. Use the Occupational Titles to choose which professions (A) need to be added to the table below. You can more than one occupation or just one.





d. The code in front of each Occupational Title is the Occupation Code that goes in (B) for the table below.





e. When you click on each Occupational Titles, choose the Mean Hourly Wage to input in (C) for the table below.





2. Use the U.S. Bureau of Labor Economic News Release, Employer Costs for Employee Compension to complete Column D for the table below.





a. Click the link: [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




b. Choose "The PDF verison of the news release" link





c. The latest (September 10, 2024) News Release for Employer Costs for Employee Compensation - June 2024 opens in separate tab.





d. On first page, second paragraph use the benefit costs % of:

29.70%


3. For each profession fill in the % for (F). The total for the column should be 100%.





a. Note that if there is only one profession then (F) would be 100%.












Gray Columns have automatic formulas. DO NOT input numbers in these columns.





(A) (B) (C) (D) (E) (F) (G)
Profession Bureau of Labor Occupation Code 1.d Mean Wage 1.e Benefits 2
(C) * (2.d)
Total Hourly Wage
(C ) + (D)
% Time Spent on Burden Weighted Hourly Salary
(E) * (F)
Management Occupations 11-0000 $66.23 $19.67 $85.90 50% $42.95
Production Occupations 51-0000 $22.90 $6.80 $29.70 50% $14.85










































TOTAL



100% $57.80

Sheet 5: NA Not Inc in Burden Hours

USDA RURAL BUSINESS COOPERATIVE SERVICE
BIOBASED MARKETS PROGRAM: FEDERAL PROCUREMENT AND VOLUNTARY LABELING
INFORMATION COLLECTION NOT INCLUDED IN BURDEN HOURS
OMB # 0570-NEW
October 2, 2024











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
File Typeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File Modified0000-00-00
File Created0000-00-00

© 2025 OMB.report | Privacy Policy