Excel Calculations

Info Collection Calculations - 11192015.xlsx

Flammable Hazardous Materials by Rail Transportation

Excel Calculations

OMB: 2137-0628

Document [xlsx]
Download: xlsx | pdf
Sampling and Testing Plans Respondents Responses Hours per Response Total Hours Cost per hour Total Cost
Sampling and Testing Plan - Year 1 1,804 1,804 40 72,160.00 $75.05 $5,415,608.00
Sampling and Testing Plan - Subsequent year burden 1,804 1,804 10 18,040.00 $75.05 $1,353,902.00














Routing - Collection by Line Segment Respondents Responses Hours per Response Total Hours Cost per hour Total Cost
Class II Railroads 10 10 40 400.00 $62.25 $24,900.00
Class III Railroads 160 160 40 6,400.00 $62.25 $398,400.00
Subtotal 170 170
6,800
$423,300.00







Routing Security Analysis - Year 1 Respondents Responses Hours per Response Total Hours Cost per hour Total Cost
Class II Railroads 10 50 80 4,000.00 $62.25 $249,000.00
Class III Railroads 160 320 40 12,800.00 $62.25 $796,800.00
Subtotal 170 370
16,800
$1,045,800.00







Routing Analysis Year 2-20 Respondents Responses Hours per Response Total Hours Cost per hour Total Cost
Class II Railroads 10 50 16 800.00 $62.25 $49,800.00
Class III Railroads 160 320 8 2,560.00 $62.25 $159,360.00
Subtotal 170 370
3,360
$209,160.00







Alternate - Routing Security Analysis - Year 1 Respondents Responses Hours per Response Total Hours Cost per hour Total Cost
Class II Railroads 10 40 120 4,800.00 $62.25 $298,800.00
Class III Railroads 160 80 40 3,200.00 $62.25 $199,200.00
Subtotal 170 120
8,000
$498,000.00







Alternate - Routing Security Analysis - Year 2-20 Respondents Responses Hours per Response Total Hours Cost per hour Total Cost
Class II Railroads 10 40 12 480.00 $62.25 $29,880.00
Class III Railroads 64 32 4 128.00 $62.25 $7,968.00
Subtotal 74 72
608
$37,848.00







Tank Car Paperwork Burden Respondents Reponses Hours per Response Total Hours Cost per hour Total Cost
Tank Car Retrofit Burden 50 50 0.5 25 $67.96 $1,699.00
Second Year Burden






Respondents Responses Hours per Response Total Hours Cost per hour Total Cost
Crude Oil Incident Reporting 15 15 2 30.00 $62.95 $1,888.50













TOTAL PRA - USING Larger number between alternatives





First Year Burden 1,612 2,529
103,815
$6,888,295.50
Subsequent Year Burden 1,612 2,481
28,255
$1,989,949.50
File Typeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File Modified0000-00-00
File Created0000-00-00

© 2024 OMB.report | Privacy Policy