{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["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"],"not_rendered":{"defined_names":92,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"12 Burden Hours Collection","index":0,"n_rows":16,"n_cols":11,"rows_kept":16}
["USDA RURAL BUSINESS COOPERATIVE SERVICE"]
["BIOBASED MARKETS PROGRAM: FEDERAL PROCUREMENT AND VOLUNTARY LABELING"]
["INFORMATION COLLECTION BURDEN HOURS"]
["OMB # 0570-NEW"]
["2024-10-02"]
[]
["Estimated No. of Total Respondents (Applicants)",null,{"v":520,"d":"520 "},{"$nulls":6},"Total Estimated Burden for each individual application",{"$f":"K9/G9","v":{"v":379.010051479947,"d":"$379.01"}}]
["Average hours per response",null,{"$f":"I9/G9","v":{"v":6.557176002651641,"d":"6.5572"}},{"$nulls":6},"Number of responses per respondent",{"$f":"G9/C7","v":{"v":5.801923076923077,"d":"5.8019"}}]
["Gray Columns have automatic formulas.  DO NOT input numbers in these columns. ",{"$nulls":4},"TOTAL",{"$f":"SUM(G12:G20)","v":{"v":3017,"d":"3,017"}},null,{"$f":"SUM(I12:I20)","v":{"v":19783,"d":"19,783"}},null,{"$f":"SUM(K12:K20)","v":{"v":1143473.325315,"d":"$1,143,473"}}]
["(A) ","(B)","(C)  ",null,"(D)","(E)  ","(F)","(G)","(H)","(I)","(J)"]
["Regulation Reference","Title","Form No. \n(If Any)","% of Respondents Line Item is Applicable To","Estimated # of Respondents","Reports Filed Annually ","Total Responses \n(D) x (E)  ","Estimated # of Hours Per Response ","Estimated Total Hours \n(F) x (G)","Prof. Wage Rate","Total Cost\n(H) x (I)"]
["§4270.9(a)","Application",null,{"v":1,"d":"100%"},{"$f":"D12*$C$7","v":{"v":520,"d":"520 "}},{"v":2,"d":"2 "},{"$f":"E12*F12","v":{"v":1040,"d":"1,040"}},{"v":12,"d":"12.00"},{"$f":"IF((H12*G12)=\"\",\"\",(H12*G12))","v":{"v":12480,"d":"12,480"}},{"$f":"'Est Prof Wage Rate'!$G$33","v":{"v":57.800805,"d":"$57.80"}},{"$f":"IF((J12*I12)=\"\",\"\",(J12*I12))","v":{"v":721354.0464,"d":"721,354"}}]
["§4270.9(b)(2)(ii), (c)(2), (d)","Biobased Content and Testing",null,{"v":1,"d":"100%"},{"$f":"D13*$C$7","v":{"v":520,"d":"520 "}},{"v":2,"d":"2 "},{"$f":"E13*F13","v":{"v":1040,"d":"1,040"}},{"v":2,"d":"2.00"},{"$f":"IF((H13*G13)=\"\",\"\",(H13*G13))","v":{"v":2080,"d":"2,080"}},{"$f":"'Est Prof Wage Rate'!$G$33","v":{"v":57.800805,"d":"$57.80"}},{"$f":"IF((J13*I13)=\"\",\"\",(J13*I13))","v":{"v":120225.67439999999,"d":"120,226"}}]
["§4270.9 & .14","Maintaing Records and Notice of Certification",null,{"v":0.5673076923076923,"d":"57%"},{"$f":"D14*$C$7","v":{"v":295,"d":"295 "}},{"v":1,"d":"1 "},{"$f":"E14*F14","v":295},{"v":4,"d":"4.00"},{"$f":"IF((H14*G14)=\"\",\"\",(H14*G14))","v":{"v":1180,"d":"1,180"}},{"$f":"'Est Prof Wage Rate'!$G$33","v":{"v":57.800805,"d":"$57.80"}},{"v":68204.94989999999,"d":"68,205"}]
["§4270.12","Appeals",null,{"v":0.1,"d":"10%"},{"v":52,"d":"52 "},{"v":1,"d":"1 "},52,{"v":4,"d":"4.00"},{"$f":"IF((H15*G15)=\"\",\"\",(H15*G15))","v":208},{"$f":"'Est Prof Wage Rate'!$G$33","v":{"v":57.800805,"d":"$57.80"}},{"$f":"IF((J15*I15)=\"\",\"\",(J15*I15))","v":{"v":12022.567439999999,"d":"12,023"}}]
["§4270.15","Oversight and Monitoring",null,{"v":0.5673076923076923,"d":"57%"},{"v":295,"d":"295 "},{"v":2,"d":"2 "},590,{"v":6.5,"d":"6.50"},{"v":3835,"d":"3,835"},{"$f":"'Est Prof Wage Rate'!$G$33","v":{"v":57.800805,"d":"$57.80"}},{"v":221666.087175,"d":"221,666"}]

{"sheet":"13 Burden to Respondent","index":1,"n_rows":23,"n_cols":2,"rows_kept":23}
[{"$f":"'12 Burden Hours Collection'!A1","v":"USDA RURAL BUSINESS COOPERATIVE SERVICE"}]
[{"$f":"'12 Burden Hours Collection'!A2","v":"BIOBASED MARKETS PROGRAM: FEDERAL PROCUREMENT AND VOLUNTARY LABELING"}]
["ESTIMATED TOTAL ANNUAL COST BURDEN TO RESPONDENTS "]
[{"$f":"'12 Burden Hours Collection'!A4","v":"OMB # 0570-NEW"}]
[{"$f":"'12 Burden Hours Collection'!A5","v":"2024-10-02"}]
[]
["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",{"$f":"B9*B10","v":{"v":1040,"d":"1,040"}}]
["Estimated # of Tests per Prodcuts or Product Families",1]
["Total # of Tests ",{"$f":"B12*B13","v":{"v":1040,"d":"1,040"}}]
["Cost per Test",{"v":400,"d":"$400"}]
["Annualized Factor (over 10yrs @ 3.5% interest)",0.22148]
["Annualized Testing Cost",{"$f":"B14*B15*B16","v":{"v":92135.68000000001,"d":"$92,136"}}]
["Estimated Respondent Labor Costs"]
["Estimated # of Hours per Test ",2]
["Total Annual Burden Hours - Respondents",{"$f":"B19*B14","v":{"v":2080,"d":"2,080"}}]
["Labor Cost per Hour",{"$f":"'Est Prof Wage Rate'!G33","v":{"v":57.800805,"d":"$57.80"}}]
["Total Annualized Labor Costs",{"$f":"B21*B20","v":{"v":120225.67439999999,"d":"$120,226"}}]
["Total Annualized Cost to Respondents",{"$f":"B22+B17","v":{"v":212361.3544,"d":"$212,361"}}]

{"sheet":"14 Annual Cost to Fed Gov Est","index":2,"n_rows":28,"n_cols":16,"rows_kept":28}
[{"$f":"'12 Burden Hours Collection'!A1","v":"USDA RURAL BUSINESS COOPERATIVE SERVICE"}]
[{"$f":"'12 Burden Hours Collection'!A2","v":"BIOBASED MARKETS PROGRAM: FEDERAL PROCUREMENT AND VOLUNTARY LABELING"}]
["ANNUALIZED COST TO THE FEDERAL GOVERNMENT"]
[{"$f":"'12 Burden Hours Collection'!A4","v":"OMB # 0570-NEW"}]
[{"$f":"'12 Burden Hours Collection'!A5","v":"2024-10-02"}]
[]
["OPM GS Pay Tables - Table 2023 DCB",null,"https://www.opm.gov/policy-data-oversight/pay-leave/salaries-wages/2023/general-schedule  "]
["OPM SES Schedules - Table 2023-ES",null,"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 ",{"$nulls":8},{"v":0.3625,"d":"36.25%"}]
[]
["Gray & Blue Columns have automatic formulas.  DO NOT input numbers in these columns.",{"$nulls":5},"Total  ",{"$f":"H13+H18+H25","v":{"v":33,"d":"33.00"}},{"$f":"I13+I18+I25","v":{"v":1059.7935208197523,"d":"$1,059.79"}},null,{"$f":"SUM(K13:K29)","v":{"v":936596.2026802885,"d":"$936,596.20"}},null,"Contractor 1",null,"Contractor 2"]
["Staff \nPosition","GS Grade","GS Step","GS \nSalary","Hourly Rate Calc","Benefits Calc","Total Salary Rate Calc","Hours Required","Cost Subtotals","# of Responses","Total Costs",null,{"v":583000,"d":"583,000"},null,{"v":1059000,"d":"1,059,000"}]
["Application (Including Biobased Content/Testing) - 1,040 Responses",{"$nulls":6},{"$f":"SUM(H14:H17)","v":{"v":19,"d":"19.00"}},{"$f":"SUM(I14:I17)","v":{"v":708.2286899038462,"d":"$708.23"}},{"v":1040,"d":"1,040"},{"$f":"J13*I13","v":{"v":736557.8375,"d":"$736,557.84"}}]
["Contractor 1",{"$nulls":6},{"v":12,"d":"12.00"},{"$f":"M14/J13","v":{"v":381.1923076923077,"d":"$381.19"}},{"$nulls":3},{"$f":"M12*N14","v":{"v":396440,"d":"396,440.00"}},{"v":0.68,"d":"68%"}]
["Contractor 2",{"$nulls":6},{"v":5,"d":"5.00"},{"$f":"O15/J13","v":{"v":101.82692307692308,"d":"$101.83"}},{"$nulls":5},{"$f":"O12*P15","v":{"v":105900,"d":"105,900.00"}},{"v":0.1,"d":"10%"}]
["Procurement Analyst",14,5,{"v":157982,"d":"$157,982"},{"$f":"(D16/52)/40","v":{"v":75.95288461538462,"d":"$75.95"}},{"$f":"E16*$K$9","v":{"v":27.532920673076923,"d":"$27.53"}},{"$f":"E16+F16","v":{"v":103.48580528846153,"d":"$103.49"}},{"v":1,"d":"1.00"},{"$f":"H16*G16","v":{"v":103.48580528846153,"d":"$103.49"}}]
["Assistant Deputy Administrator",15,5,{"v":185824,"d":"$185,824"},{"$f":"(D17/52)/40","v":{"v":89.33846153846153,"d":"$89.34"}},{"$f":"E17*$K$9","v":{"v":32.38519230769231,"d":"$32.39"}},{"$f":"E17+F17","v":{"v":121.72365384615384,"d":"$121.72"}},{"v":1,"d":"1.00"},{"$f":"H17*G17","v":{"v":121.72365384615384,"d":"$121.72"}}]
["Maintaing Records and Notice of Certification - 295 Responses",{"$nulls":6},{"$f":"SUM(H19:H20)","v":{"v":5,"d":"5.00"}},{"$f":"SUM(I19:I20)","v":{"v":143.0112290172751,"d":"$143.01"}},295,{"$f":"J18*I18","v":{"v":42188.31256009616,"d":"$42,188.31"}}]
["Contractor 1",{"$nulls":6},{"v":4,"d":"4.00"},{"$f":"M19/J18","v":{"v":39.52542372881356,"d":"$39.53"}},{"$nulls":3},{"$f":"M12*N19","v":{"v":11660,"d":"11,660.00"}},{"v":0.02,"d":"2%"}]
["Procurement Analyst",14,5,{"v":157982,"d":"$157,982"},{"$f":"(D20/52)/40","v":{"v":75.95288461538462,"d":"$75.95"}},{"$f":"E20*$K$9","v":{"v":27.532920673076923,"d":"$27.53"}},{"$f":"E20+F20","v":{"v":103.48580528846153,"d":"$103.49"}},{"v":1,"d":"1.00"},{"$f":"H20*G20","v":{"v":103.48580528846153,"d":"$103.49"}}]
["Appeals - 52 Responses",{"$nulls":6},{"$f":"SUM(H22:H24)","v":{"v":6,"d":"6.00"}},{"$f":"SUM(I22:I24)","v":{"v":669.2966826923077,"d":"$669.30"}},52,{"$f":"J21*I21","v":{"v":34803.427500000005,"d":"$34,803.43"}}]
["Procurement Analyst",14,5,{"v":157982,"d":"$157,982"},{"$f":"(D22/52)/40","v":{"v":75.95288461538462,"d":"$75.95"}},{"$f":"E22*$K$9","v":{"v":27.532920673076923,"d":"$27.53"}},{"$f":"E22+F22","v":{"v":103.48580528846153,"d":"$103.49"}},{"v":4,"d":"4.00"},{"$f":"H22*G22","v":{"v":413.94322115384614,"d":"$413.94"}}]
["Assistant Deputy Administrator",15,5,{"v":185824,"d":"$185,824"},{"$f":"(D23/52)/40","v":{"v":89.33846153846153,"d":"$89.34"}},{"v":32.38519230769231,"d":"$32.39"},{"v":121.72365384615384,"d":"$121.72"},{"v":1,"d":"1.00"},{"$f":"H23*G23","v":{"v":121.72365384615384,"d":"$121.72"}}]
["Administrator",null,null,{"v":204000,"d":"$204,000"},{"$f":"(D24/52)/40","v":{"v":98.07692307692307,"d":"$98.08"}},{"$f":"E24*$K$9","v":{"v":35.55288461538461,"d":"$35.55"}},{"$f":"E24+F24","v":{"v":133.62980769230768,"d":"$133.63"}},{"v":1,"d":"1.00"},{"$f":"H24*G24","v":{"v":133.62980769230768,"d":"$133.63"}}]
["Oversight & Monitoring - 590 Responses",{"$nulls":6},{"$f":"SUM(H26:H28)","v":{"v":9,"d":"9.00"}},{"$f":"SUM(I26:I28)","v":{"v":208.55360189863103,"d":"$208.55"}},590,{"$f":"J25*I25","v":{"v":123046.6251201923,"d":"$123,046.63"}}]
["Contractor 1",{"$nulls":6},{"v":6,"d":"6.00"},{"$f":"M26/J25","v":{"v":69.16949152542374,"d":"$69.17"}},{"$nulls":3},{"$f":"M12*N26","v":{"v":40810.00000000001,"d":"40,810.00"}},{"v":0.07,"d":"7%"}]
["Contractor 2",{"$nulls":6},{"v":2,"d":"2.00"},{"$f":"O27/J25","v":{"v":35.898305084745765,"d":"$35.90"}},{"$nulls":5},{"$f":"O12*P27","v":{"v":21180,"d":"21,180.00"}},{"v":0.02,"d":"2%"}]
["Procurement Analyst",14,5,{"v":157982,"d":"$157,982"},{"$f":"(D28/52)/40","v":{"v":75.95288461538462,"d":"$75.95"}},{"$f":"E28*$K$9","v":{"v":27.532920673076923,"d":"$27.53"}},{"$f":"E28+F28","v":{"v":103.48580528846153,"d":"$103.49"}},{"v":1,"d":"1.00"},{"$f":"H28*G28","v":{"v":103.48580528846153,"d":"$103.49"}}]

{"sheet":"Est Prof Wage Rate","index":3,"n_rows":33,"n_cols":7,"rows_kept":33}
[{"$f":"'12 Burden Hours Collection'!A1","v":"USDA RURAL BUSINESS COOPERATIVE SERVICE"}]
[{"$f":"'12 Burden Hours Collection'!A2","v":"BIOBASED MARKETS PROGRAM: FEDERAL PROCUREMENT AND VOLUNTARY LABELING"}]
["ESTIMATED PROFESSIONAL WAGE RATE"]
[{"$f":"'12 Burden Hours Collection'!A4","v":"OMB # 0570-NEW"}]
[{"$f":"'12 Burden Hours Collection'!A5","v":"2024-10-02"}]
[]
["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:","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:","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: ",null,null,{"v":0.297,"d":"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\n(C) * (2.d)","Total Hourly Wage\n(C ) + (D)","% Time Spent on Burden","Weighted Hourly Salary\n(E) * (F)"]
["Management Occupations","11-0000",{"v":66.23,"d":"$66.23"},{"$f":"IF(C25=0,\"\",(C25*$D$18))","v":{"v":19.67031,"d":"$19.67"}},{"$f":"IF(SUM(C25:D25)=0,\"\",SUM(C25:D25))","v":{"v":85.90031,"d":"$85.90"}},{"v":0.5,"d":"50%"},{"$f":"IF(E25=\"\",\"\",(E25*F25))","v":{"v":42.950155,"d":"$42.95"}}]
["Production Occupations","51-0000",{"v":22.9,"d":"$22.90"},{"$f":"IF(C26=0,\"\",(C26*$D$18))","v":{"v":6.8012999999999995,"d":"$6.80"}},{"$f":"IF(SUM(C26:D26)=0,\"\",SUM(C26:D26))","v":{"v":29.701299999999996,"d":"$29.70"}},{"v":0.5,"d":"50%"},{"$f":"IF(E26=\"\",\"\",(E26*F26))","v":{"v":14.850649999999998,"d":"$14.85"}}]
[]
[]
[]
[]
[]
[]
["TOTAL",null,null,{"$f":"IF(C33=0,\"\",(C33*#REF!))","v":""},null,{"$f":"SUM(F25:F32)","v":{"v":1,"d":"100%"}},{"$f":"SUM(G25:G32)","v":{"v":57.800805,"d":"$57.80"}}]

{"sheet":"NA Not Inc in Burden Hours","index":4,"n_rows":10,"n_cols":11,"rows_kept":10}
[{"$f":"'12 Burden Hours Collection'!A1","v":"USDA RURAL BUSINESS COOPERATIVE SERVICE"}]
[{"$f":"'12 Burden Hours Collection'!A2","v":"BIOBASED MARKETS PROGRAM: FEDERAL PROCUREMENT AND VOLUNTARY LABELING"}]
["INFORMATION COLLECTION NOT INCLUDED IN BURDEN HOURS"]
[{"$f":"'12 Burden Hours Collection'!A4","v":"OMB # 0570-NEW"}]
[{"$f":"'12 Burden Hours Collection'!A5","v":"2024-10-02"}]
[]
["Gray Columns have automatic formulas.  DO NOT input numbers in these columns.",{"$nulls":6},"Total Hours and Cost Not Included in Burden Hours:",{"$f":"SUM(I10:I29)","v":0},null,{"$f":"SUM(K10:K29)","v":0}]
["(A) ","(B)","(C)  ",null,"(D)","(E)  ","(F)","(G)","(H)","(I)","(J)"]
["NOFO\nSection","Title","Form No. \n(If Any)","% of Respondents Line Item is Applicable To","Estimated # of Respondents","Reports Filed Annually ","Total Responses \n(D) x (E)  ","Estimated # of Hours Per Response ","Estimated Total Hours \n(F) x (G)","Prof. Wage Rate","Total Cost\n(H) x (I)"]
["Not Applicable For this Package"]