{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["12 Burden Hours Collection","12 Not Inc in Burden Hours","12 Est Prof Wage Rate","14 Annual Cost to Fed Gov Est"],"not_rendered":{"defined_names":92,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"12 Burden Hours Collection","index":0,"n_rows":27,"n_cols":11,"rows_kept":27}
["RURAL UTILITIES SERVICE"]
["REQUEST FOR APPROVAL TO SELL CAPITAL ASSETS (RUS FORM 369)"]
["INFORMATION COLLECTION BURDEN HOURS"]
["OMB # 0572 - 0020"]
["2025-06-18"]
[]
["Estimated No. of Total Respondents (Borrowers)",null,{"v":35,"d":"35 "}]
["Average hours per response",null,{"$f":"I9/G9","v":{"v":2.074074074074074,"d":"2.074"}},{"$nulls":6},"Number of responses per respondent",{"$f":"G9/C7","v":{"v":2.3142857142857145,"d":"2.31"}}]
["Gray Columns have automatic formulas.  DO NOT input numbers in these columns.  ",{"$nulls":4},"TOTAL",{"$f":"SUM(G12:G27)","v":81},null,{"$f":"SUM(I12:I27)","v":168},null,{"$f":"SUM(K12:K27)","v":{"v":16166.013359999999,"d":"$16,166"}}]
["(A) ","(B)","(C)  ","(D)","(E)  ","(F)","(G)","(H)","(I)","(J)","(K)"]
["Regulation Reference","Title","Form No. \n(If Any)","% of Respondents Line Item is Applicable To","Estimated # of Respondents","Reports Filed Annually ","Total Responses \n(E) x (F)  ","Estimated # of Hours Per Response ","Estimated Total Hours \n(G) x (H)","Prof. Wage Rate","Total Cost\n(I) x (J)"]
["1717.616(c)(4)","Exchanges or trades of plant in place between a RUS borrower and a Non-RUS borrower","Written",{"v":0.02857142857142857,"d":"3%"},{"$f":"D12*$C$7","v":{"v":1,"d":"1 "}},{"v":1,"d":"1 "},{"$f":"E12*F12","v":1},4,{"$f":"IF((H12*G12)=\"\",\"\",(H12*G12))","v":4},{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":96.22627,"d":"$96.23"}},{"$f":"IF((J12*I12)=\"\",\"\",(J12*I12))","v":{"v":384.90508,"d":"$385"}}]
["1717.616(b)","Sales without prior approval to RUS","Written",{"v":0.14285714285714288,"d":"14%"},{"v":5.000000000000001,"d":"5 "},{"v":1,"d":"1 "},{"v":5.000000000000001,"d":"5"},1,{"v":5.000000000000001,"d":"5"},{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":96.22627,"d":"$96.23"}},{"v":481.1313500000001,"d":"$481"}]
["1717.616(d)(2)(i)-(v), (d)(3)(i)-(ii), (e), (f)(3), (g)","Request to Sell Capital Assets","Written or RUS Form 369",{"v":1,"d":"100%"},{"v":35,"d":"35 "},{"v":1,"d":"1 "},35,3,105,{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":96.22627,"d":"$96.23"}},{"v":10103.75835,"d":"$10,104"}]
["1717.616(f)(2)","Condemnation Petition or Complaint","Written",{"v":0.02857142857142857,"d":"3%"},{"$f":"D15*$C$7","v":{"v":1,"d":"1 "}},{"v":1,"d":"1 "},{"$f":"E15*F15","v":1},2,{"$f":"IF((H15*G15)=\"\",\"\",(H15*G15))","v":2},{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":96.22627,"d":"$96.23"}},{"$f":"IF((J15*I15)=\"\",\"\",(J15*I15))","v":{"v":192.45254,"d":"$192"}}]
["1717.616(f)(4)","Sales of Real Estate and Plant in Place","Written",{"v":0.02857142857142857,"d":"3%"},{"$f":"D16*$C$7","v":{"v":1,"d":"1 "}},{"v":1,"d":"1 "},1,8,8,{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":96.22627,"d":"$96.23"}},{"v":769.81016,"d":"$770"}]
["1717.616(f)(5)","Installment Sales","Written",{"v":0.02857142857142857,"d":"3%"},{"v":1,"d":"1 "},{"v":1,"d":"1 "},1,3,3,{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":96.22627,"d":"$96.23"}},{"v":288.67881,"d":"$289"}]
["1717.616(f)(6)","Exchanges","Written",{"v":0.05714285714285714,"d":"6%"},{"$f":"D18*$C$7","v":{"v":2,"d":"2 "}},{"v":1,"d":"1 "},2,3,6,{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":96.22627,"d":"$96.23"}},{"v":577.35762,"d":"$577"}]
[null,"Recordkeeping Requirements","Written",{"v":1,"d":"100%"},{"$f":"D19*$C$7","v":{"v":35,"d":"35 "}},{"v":1,"d":"1 "},35,1,35,{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":96.22627,"d":"$96.23"}},{"v":3367.91945,"d":"$3,368"}]
[{"$nulls":4},{"v":0,"d":"0 "},null,0,null,0,{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":96.22627,"d":"$96.23"}},{"v":0,"d":"$0"}]
[{"$nulls":4},{"v":0,"d":"0 "},null,0,null,0,{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":96.22627,"d":"$96.23"}},{"v":0,"d":"$0"}]
[{"$nulls":4},{"v":0,"d":"0 "},null,0,null,0,{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":96.22627,"d":"$96.23"}},{"v":0,"d":"$0"}]
[{"$nulls":4},{"v":0,"d":"0 "},null,0,null,0,{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":96.22627,"d":"$96.23"}},{"v":0,"d":"$0"}]
[{"$nulls":4},{"v":0,"d":"0 "},null,0,null,0,{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":96.22627,"d":"$96.23"}},{"v":0,"d":"$0"}]
[{"$nulls":4},{"v":0,"d":"0 "},null,0,null,0,{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":96.22627,"d":"$96.23"}},{"v":0,"d":"$0"}]
[{"$nulls":4},{"$f":"D26*$C$7","v":{"v":0,"d":"0 "}},null,{"$f":"E26*F26","v":0},null,{"$f":"IF((H26*G26)=\"\",\"\",(H26*G26))","v":0},{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":96.22627,"d":"$96.23"}},{"$f":"IF((J26*I26)=\"\",\"\",(J26*I26))","v":{"v":0,"d":"$0"}}]
[{"$nulls":4},{"v":0,"d":"0 "},null,0,null,0,{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":96.22627,"d":"$96.23"}},{"v":0,"d":"$0"}]

{"sheet":"12 Not Inc in Burden Hours","index":1,"n_rows":18,"n_cols":11,"rows_kept":18}
[{"$f":"'12 Burden Hours Collection'!A1","v":"RURAL UTILITIES SERVICE"}]
[{"$f":"'12 Burden Hours Collection'!A2","v":"REQUEST FOR APPROVAL TO SELL CAPITAL ASSETS (RUS FORM 369)"}]
[{"$f":"'12 Burden Hours Collection'!A3","v":"INFORMATION COLLECTION BURDEN HOURS"}]
[{"$f":"'12 Burden Hours Collection'!A4","v":"OMB # 0572 - 0020"}]
[{"$f":"'12 Burden Hours Collection'!A5","v":"2025-06-18"}]
[]
["Estimated No. of Total Respondents (Applicants/Borrowers)",null,{"v":0,"d":"0 "},{"$nulls":6},"Estimated No. of Total Awards (Awardees)",{"$f":"'12 Burden Hours Collection'!K7","v":0}]
["Average hours per response",null,{"$f":"I9/G9","v":{"$error":"#DIV/0!"}},{"$nulls":6},"Number of responses per respondent",{"$f":"G9/C7","v":{"$error":"#DIV/0!"}}]
["Gray Columns have automatic formulas.  DO NOT input numbers in these columns.  ",{"$nulls":4},"TOTAL",{"$f":"SUM(G12:G18)","v":0},null,{"$f":"SUM(I12:I18)","v":0},null,{"$f":"SUM(K12:K18)","v":{"v":0,"d":"$0"}}]
["(A) ","(B)","(C)  ","(D)","(E)  ","(F)","(G)","(H)","(I)","(J)","(K)"]
["Regulation Reference","Title","Form No. \n(If Any)","% of Respondents Line Item is Applicable To","Estimated # of Respondents","Reports Filed Annually ","Total Responses \n(E) x (F)  ","Estimated # of Hours Per Response ","Estimated Total Hours \n(G) x (H)","Prof. Wage Rate","Total Cost\n(I) x (J)"]
[{"$nulls":4},{"$f":"D12*$C$7","v":0},null,{"$f":"E12*F12","v":0},null,{"$f":"IF((H12*G12)=\"\",\"\",(H12*G12))","v":0},{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":96.22627,"d":"$96.23"}},{"$f":"IF((J12*I12)=\"\",\"\",(J12*I12))","v":{"v":0,"d":"$0"}}]
[{"$nulls":4},{"$f":"D13*$C$7","v":0},null,0,null,0,{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":96.22627,"d":"$96.23"}},{"v":0,"d":"$0"}]
[{"$nulls":4},{"$f":"D14*$C$7","v":0},null,0,null,0,{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":96.22627,"d":"$96.23"}},{"v":0,"d":"$0"}]
[{"$nulls":4},{"$f":"D15*$K$7","v":0},null,0,null,0,{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":96.22627,"d":"$96.23"}},{"v":0,"d":"$0"}]
[{"$nulls":4},{"$f":"D16*$K$7","v":0},null,0,null,0,{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":96.22627,"d":"$96.23"}},{"v":0,"d":"$0"}]
[{"$nulls":4},{"$f":"D17*$K$7","v":0},null,0,null,0,{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":96.22627,"d":"$96.23"}},{"v":0,"d":"$0"}]
[{"$nulls":4},{"$f":"D18*$K$7","v":0},null,0,null,0,{"$f":"'12 Est Prof Wage Rate'!$G$36","v":{"v":96.22627,"d":"$96.23"}},{"v":0,"d":"$0"}]

{"sheet":"12 Est Prof Wage Rate","index":2,"n_rows":36,"n_cols":7,"rows_kept":36}
[{"$f":"'12 Burden Hours Collection'!A1","v":"RURAL UTILITIES SERVICE"}]
[{"$f":"'12 Burden Hours Collection'!A2","v":"REQUEST FOR APPROVAL TO SELL CAPITAL ASSETS (RUS FORM 369)"}]
[{"$f":"'12 Burden Hours Collection'!A3","v":"INFORMATION COLLECTION BURDEN HOURS"}]
[{"$f":"'12 Burden Hours Collection'!A4","v":"OMB # 0572 - 0020"}]
[{"$f":"'12 Burden Hours Collection'!A5","v":"2025-06-18"}]
[]
["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 2024) 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 (March 14, 2025) News Release for Employer Costs for Employee Compensation - December 2024 opens in separate tab."]
["     d.  On first page, second paragraph use the benefit costs % of: ",null,null,{"v":0.295,"d":"29.50%"}]
["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)"]
["Manager Professional","11-9199",{"v":72.06,"d":"$72.06"},{"$f":"IF(C25=0,\"\",(C25*$D$18))","v":{"v":21.2577,"d":"$21.26"}},{"$f":"IF(SUM(C25:D25)=0,\"\",SUM(C25:D25))","v":{"v":93.3177,"d":"$93.32"}},{"v":0.45,"d":"45%"},{"$f":"IF(E25=\"\",\"\",(E25*F25))","v":{"v":41.992965000000005,"d":"$41.99"}}]
["Administrative Assistant","43-9199",{"v":23.42,"d":"$23.42"},{"$f":"IF(C26=0,\"\",(C26*$D$18))","v":{"v":6.9089,"d":"$6.91"}},{"$f":"IF(SUM(C26:D26)=0,\"\",SUM(C26:D26))","v":{"v":30.3289,"d":"$30.33"}},{"v":0.1,"d":"10%"},{"$f":"IF(E26=\"\",\"\",(E26*F26))","v":{"v":3.03289,"d":"$3.03"}}]
["Attorney","23-1011",{"v":87.86,"d":"$87.86"},{"$f":"IF(C27=0,\"\",(C27*$D$18))","v":{"v":25.918699999999998,"d":"$25.92"}},{"$f":"IF(SUM(C27:D27)=0,\"\",SUM(C27:D27))","v":{"v":113.7787,"d":"$113.78"}},{"v":0.45,"d":"45%"},{"$f":"IF(E27=\"\",\"\",(E27*F27))","v":{"v":51.200415,"d":"$51.20"}}]
[{"$nulls":3},{"$f":"IF(C28=0,\"\",(C28*$D$18))","v":""},{"$f":"IF(SUM(C28:D28)=0,\"\",SUM(C28:D28))","v":""},null,{"$f":"IF(E28=\"\",\"\",(E28*F28))","v":""}]
{"$rows_empty":7}
["TOTAL",null,null,{"$f":"IF(C36=0,\"\",(C36*#REF!))","v":""},null,{"$f":"SUM(F25:F35)","v":{"v":1,"d":"100%"}},{"$f":"SUM(G25:G35)","v":{"v":96.22627,"d":"$96.23"}}]

{"sheet":"14 Annual Cost to Fed Gov Est","index":3,"n_rows":25,"n_cols":11,"rows_kept":25}
[{"$f":"'12 Burden Hours Collection'!A1","v":"RURAL UTILITIES SERVICE"}]
[{"$f":"'12 Burden Hours Collection'!A2","v":"REQUEST FOR APPROVAL TO SELL CAPITAL ASSETS (RUS FORM 369)"}]
[{"$f":"'12 Burden Hours Collection'!A3","v":"INFORMATION COLLECTION BURDEN HOURS"}]
[{"$f":"'12 Burden Hours Collection'!A4","v":"OMB # 0572 - 0020"}]
[{"$f":"'12 Burden Hours Collection'!A5","v":"2025-06-18"}]
[]
["1. OPM GS & SES Pay Tables:"]
["  Click Link ","Pay & Leave (opm.gov)"]
["  Click \"pay tables\" from first paragraph"]
["  Click current Year at top under Salaries & Wages"]
[]
["  a. OPM GS Pay Tables:  Under \"General Schedule (GS) & Locality Pay Tables\" click 20## GS Pay Tables (ex. 2024 GS Pay Tables)"]
["  Then choose Annual Rate Table for St. Louis - St. Charles - Farminton, MO-IL"]
[]
["  b. OPM SES Schedules:  Under \"Executive & Senior Level Employee Pay Tables\" click \"Rates of Pay for the Executive Schedule\""]
["  Then choose Annual Rate Table for Basic Rates of Pay for Members of the Senior Executive Service."]
[]
["2. Benefit % (OMB Memo M-08-13)","https://obamawhitehouse.archives.gov/sites/default/files/omb/assets/omb/memoranda/fy2008/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":"SUM(H22:H25)","v":{"v":7,"d":"7.00"}},{"$f":"SUM(I22:I25)","v":{"v":576.1180588942308,"d":"$576.12"}},null,{"$f":"SUM(K22:K25)","v":{"v":20164,"d":"$20,164"}}]
["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"]
["Engineering Branch Chief",14,5,{"v":144715,"d":"$144,715"},{"$f":"(D22/52)/40","v":{"v":69.57451923076923,"d":"$69.57"}},{"$f":"E22*$K$18","v":{"v":25.220763221153845,"d":"$25.22"}},{"$f":"E22+F22","v":{"v":94.79528245192307,"d":"$94.80"}},{"v":0.5,"d":"0.50"},{"$f":"H22*G22","v":{"v":47.397641225961536,"d":"$47.40"}},{"$f":"'12 Burden Hours Collection'!C7","v":{"v":35,"d":"35 "}},{"$f":"ROUND((I22*J22),0)","v":{"v":1659,"d":"$1,659"}}]
["Engineer",13,5,{"v":122465,"d":"$122,465"},{"$f":"(D23/52)/40","v":{"v":58.87740384615385,"d":"$58.88"}},{"v":21.34305889423077,"d":"$21.34"},{"$f":"E23+F23","v":{"v":80.22046274038462,"d":"$80.22"}},{"v":2,"d":"2.00"},{"$f":"H23*G23","v":{"v":160.44092548076924,"d":"$160.44"}},{"$f":"'12 Burden Hours Collection'!C7","v":{"v":35,"d":"35 "}},{"$f":"ROUND((I23*J23),0)","v":{"v":5615,"d":"$5,615"}}]
["Financial Operations Branch Chief",14,5,{"v":144715,"d":"$144,715"},{"$f":"(D24/52)/40","v":{"v":69.57451923076923,"d":"$69.57"}},{"v":25.220763221153845,"d":"$25.22"},{"$f":"E24+F24","v":{"v":94.79528245192307,"d":"$94.80"}},{"v":0.5,"d":"0.50"},{"v":47.397641225961536,"d":"$47.40"},{"$f":"'12 Burden Hours Collection'!C7","v":{"v":35,"d":"35 "}},{"$f":"ROUND((I24*J24),0)","v":{"v":1659,"d":"$1,659"}}]
["Loan Specialist ",13,5,{"v":122465,"d":"$122,465"},{"v":58.87740384615385,"d":"$58.88"},{"v":21.34305889423077,"d":"$21.34"},{"v":80.22046274038462,"d":"$80.22"},{"v":4,"d":"4.00"},{"v":320.8818509615385,"d":"$320.88"},{"$f":"'12 Burden Hours Collection'!C7","v":{"v":35,"d":"35 "}},{"$f":"ROUND((I25*J25),0)","v":{"v":11231,"d":"$11,231"}}]