Burden Calculation Tables

2696t01.xlsx

Underground Storage Tank Finder Application

Burden Calculation Tables

OMB: 2080-0086

Document [xlsx]
Download: xlsx | pdf

Overview

Respondent & Agency Data
Respondent Yr1
Respondent Yr2
Respondent Yr3
Agency Yr1
Agency Yr2
Agency Yr3
Summary


Sheet 1: Respondent & Agency Data

Number of Respondents and Burden









Description Total # Respondents Year 1 Total # Respondents Year 2 Total # Respondents Year 3 Initial Hours Semiannual Hours Subcontractor Hours
Responses Year 1 Responses Year 2 Responses Year 3
The 50 states, territories, and the District of Columbia. 56 56 56






Option 1 0 6 12 240 1

0 12 24
Option 2 18 15 12 58 3

36 30 24
Option 3 22 19 16 152 11

44 38 32
Option 4 16 16 16 0 0

0 0 0








80 80 80
EPA Burden









Description Total # Respondents Year 1 Total # Respondents Year 2 Total # Respondents Year 3 Initial Hours/each state Semiannual Hours/ each state




The 50 states, territories, and the District of Columbia. 56 56 56






Option 1 0 6 12 6 4




Option 2 18 15 12 8 4




Option 3 22 19 16 7 4




Option 4 16 16 16 8 4




We assume the initial and semiannual hours for EPA to administer this program average to one third full time equivalent (52 weeks x 40 hr/week x 0.33 = 686 hours total) over the three-year period of this ICR.










Sheet 2: Respondent Yr1

Table 1: Annual Respondent Burden and Cost – Underground Storage Tank Finder Application


Year 1











Burden Item A B C D E F G H I


Person-hours
per occurrence
Annual occurrences
per respondent
Person-hours
per respondent
per year (AxB)
Respondents
per year a
Technical hours per
year (CxD)
Management hours per year (Ex0.05) Clerical hours
per year
(Ex0.10)
Subcontractor hours
per year
Annual cost
($) b, c



A. Option 1: Push UST/LUST data to EPA's Virtual Exchange Server









Labor Rates - State Agency
1. Initial program set-up d









Management $69.04
a. Set up Node Administration account. 48 1 48 0 0 0 0
$0
Technical $51.23
b. Review data, develop data query to match EPA schema 192 1 192 0 0 0 0
$0
Clerical $27.73
c. Subcontractor technical assistance e 38 1 38 0 0 0 0 0 $0


2. Sending data semiannually f









Labor Rates - Subcontractor
a. Verify, quality check, and gather state agency data 1 2 1 0 0 0 0
$0
Technical $122.66
b. Establish connection to VES 0.25 2 1 0 0 0 0
$0


c. Import data exchange and map data 0.25 2 1 0 0 0 0
$0


B. Option 2: Share UST/LUST data with EPA via link to existing state agency website











1. Initial program set-up d











a. Set up approved file sharing method with EPA 8 1 8 18 144 7 14
$8,274


b. Review and compile minimum data elements from existing databases; verify and update data 50 1 50 18 900 45 90
$51,710


c. Subcontractor technical assistance e 10 1 10 0.9 0 0 0 9 $1,104


2. Sending data semiannually f











a. Verify, quality check, and gather state agency data 1.5 2 3 18 54 3 5
$3,103


b. Save database(s) in preferred file format on state agency website 1 2 2 18 36 2 4
$2,068


c. Notify EPA that data is available 0.5 2 1 18 18 1 2
$1,034


C. Option 3: Send UST/LUST data to EPA file sharing site











1. Initial program set-up d











a. Set up approved file sharing method with EPA 8 1 8 22 176 9 18
$10,112


b. Review and compile minimum data elements from existing databases; verify and update data 144 1 144 22 3,168 158 317
$182,017


c. Subcontractor technical assistance e 29 1 29 1.1 0 0 0 32 $3,886


2. Sending data semiannually f











a. Verify, quality check, and gather state agency data 9.5 2 19 22 418 21 42
$24,016


b. Save database(s) in preferred file format 0.5 2 1 22 22 1 2
$1,264


c. Send UST/LUST data to EPA 0.5 2 1 22 22 1 2
$1,264


d. Notify EPA that data has been sent 0.5 2 1 22 22 1 2
$1,264


D. Option 4: EPA pulls existing UST/LUST data from existing state agency website











1. No respondent action required g 0 0 0 16 0 0 0
$0


Reporting Subtotal



5,727 41 $291,116


E. Recordkeeping requirements h











a. Plan activities 1 1 1 40 40 2 4 0 $2,298


b. Record activities 0.5 2 1 40 40 2 4 0 $2,298


Recordkeeping Subtotal



92
$4,596


TOTAL LABOR BURDEN AND COSTS (rounded) i



5,819
$295,700


TOTAL CAPITAL AND O&M COST (rounded) i







$0


GRAND TOTAL (rounded) i







$295,700















Assumptions:











a EPA estimates an average of 40 states/territories will comply voluntarily with EPA's request for data in year 1 of the program, using Options 2 or 3. EPA estimates that, beginning in year 2, 6 states per year will transition to using Option 1. EPA assumes it will retrieve data for the remaining 16 states that do not submit data using Options 1 through 3.


b This ICR uses the following labor rate for subcontractors: $122.66 per hour for Technical labor. This rate is from the United States Department of Labor, Bureau of Labor Statistics, September 2020, “Table 2. Civilian Workers, by occupational and industry group.” The rate is from column 1, “Total compensation.” The BLS rate has been increased by 110 percent to account for the benefit packages available to those employed by private industry.


c This cost is based on the following labor rates which incorporates a 1.6 benefits multiplication factor to account for government overhead expenses. This ICR uses a Managerial rate of $69.04 (GS-13, Step 5, $43.15 + 60%), Technical rate of $51.23 (GS-12, Step 1, $32.02 + 60%), and Clerical rate of $27.73 (GS-6, Step 3, $17.33 + 60%). These rates are from the Office of Personnel Management (OPM), 2021 General Schedule, which excludes locality rates of pay.


d EPA assumes that, in the first year of the program, each respondent will require time to set up their systems to accommodate the data exchange. This involves assessing which data is desired by EPA, re-writing database queries, verifying that queries are correct, and obtaining management permission to share data. As states transition to using Option 1, they will incur burden only once for the initial set-up to implement this Option.


e Based on interview responses, EPA assumes that 5% of states will use outside contractors to initially set up their processes to accommodate the data exchange. This initial set-up will begin in year 1 for states choosing Options 2 and 3 and year 2 for states choosing Option 1. EPA also assumes that subcontractor labor for the initial set-up will be an additional 20% of state agency hours.


f Based on interview responses, EPA assumes that, on average, each respondent will share their UST/LUST data on a semiannual basis.


g Respondents choosing Option 4 will have no initial burden in Year 1 or recurring burden in subsequent years.


h EPA assumes that respondents will keep records of all data made available to the Agency. Planning will occur in year 1 and recordkeeping will occur semiannually.


i Total+A3:J53s have been rounded to 3 significant figures. Figures may not add exactly due to rounding.



Sheet 3: Respondent Yr2

Table 2: Annual Respondent Burden and Cost – Underground Storage Tank Finder Application


Year 2











Burden Item A B C D E F G H I


Person-hours
per occurrence
Annual occurrences
per respondent
Person-hours
per respondent
per year (AxB)
Respondents
per year a
Technical hours per
year (CxD)
Management hours per year (Ex0.05) Clerical hours
per year
(Ex0.10)
Subcontractor hours
per year
Annual cost
($) b, c



A. Option 1: Push UST/LUST data to EPA's Virtual Exchange Server









Labor Rates - State Agency
1. Initial program set-up d









Management $69.04
a. Set up Node Administration account. 48 1 48 6 288 14 29
$16,547
Technical $51.23
b. Review data, develop data query to match EPA schema 192 1 192 6 1,152 58 115
$66,188
Clerical $27.73
c. Subcontractor technical assistance e 38 1 38 0.3 0 0 0 12 $1,413


2. Sending data semiannually f









Labor Rates - Subcontractor
a. Verify, quality check, and gather state agency data 1 2 1 6 6 0 1
$345
Technical $122.66
b. Establish connection to VES 0.25 2 1 6 3 0 0
$172


c. Import data exchange and map data 0.25 2 1 6 3 0 0
$172


B. Option 2: Share UST/LUST data with EPA via link to existing state agency website











1. Initial program set-up d











a. Set up approved file sharing method with EPA 8 1 8 0 0 0 0
$0


b. Review and compile minimum data elements from existing databases; verify and update data 50 1 50 0 0 0 0
$0


c. Subcontractor technical assistance e 10 1 10 0 0 0 0 0 $0


2. Sending data semiannually f











a. Verify, quality check, and gather state agency data 2 2 3 15 45 2 5
$2,585


b. Save database(s) in preferred file format on state agency website 1 2 2 15 30 2 3
$1,724


c. Notify EPA that data is available 0.5 2 1 15 15 1 2
$862


C. Option 3: Send UST/LUST data to EPA file sharing site











1. Initial program set-up d











a. Set up approved file sharing method with EPA 8 1 8 0 0 0 0
$0


b. Review and compile minimum data elements from existing databases; verify and update data 144 1 144 0 0 0 0
$0


c. Subcontractor technical assistance e 29 1 29 0 0 0 0 0 $0


2. Sending data semiannually f











a. Verify, quality check, and gather state agency data 9.5 2 19 19 361 18 36
$20,741


b. Save database(s) in preferred file format 0.5 2 1 19 19 1 2
$1,092


c. Send UST/LUST data to EPA 0.5 2 1 19 19 1 2
$1,092


d. Notify EPA that data has been sent 0.5 2 1 19 19 1 2
$1,092


D. Option 4: EPA pulls existing UST/LUST data from existing state agency website











1. No respondent action required g 0 0 0 16 0 0 0
$0


Reporting Subtotal



2,254 12 $114,025


E. Recordkeeping requirements h











a. Plan activities 1 1 1 0 0 0 0 0 $0


b. Record activities 0.5 2 1 40 40 2 4 0 $2,298


Recordkeeping Subtotal



46
$2,298


TOTAL LABOR BURDEN AND COSTS (rounded) i



2,300
$116,300


TOTAL CAPITAL AND O&M COST (rounded) i







$0


GRAND TOTAL (rounded) i







$116,300















Assumptions:











a EPA estimates an average of 40 states/territories will comply voluntarily with EPA's request for data in year 1 of the program, using Options 2 or 3. EPA estimates that, beginning in year 2, 6 states per year will transition to using Option 1. EPA assumes it will retrieve data for the remaining 16 states that do not submit data using Options 1 through 3.


b This ICR uses the following labor rate for subcontractors: $122.66 per hour for Technical labor. This rate is from the United States Department of Labor, Bureau of Labor Statistics, September 2020, “Table 2. Civilian Workers, by occupational and industry group.” The rate is from column 1, “Total compensation.” The BLS rate has been increased by 110 percent to account for the benefit packages available to those employed by private industry.


c This cost is based on the following labor rates which incorporates a 1.6 benefits multiplication factor to account for government overhead expenses. This ICR uses a Managerial rate of $69.04 (GS-13, Step 5, $43.15 + 60%), Technical rate of $51.23 (GS-12, Step 1, $32.02 + 60%), and Clerical rate of $27.73 (GS-6, Step 3, $17.33 + 60%). These rates are from the Office of Personnel Management (OPM), 2021 General Schedule, which excludes locality rates of pay.


d EPA assumes that, in the first year of the program, each respondent will require time to set up their systems to accommodate the data exchange. This involves assessing which data is desired by EPA, re-writing database queries, verifying that queries are correct, and obtaining management permission to share data. As states transition to using Option 1, they will incur burden only once for the initial set-up to implement this Option.


e Based on interview responses, EPA assumes that 5% of states will use outside contractors to initially set up their processes to accommodate the data exchange. This initial set-up will begin in year 1 for states choosing Options 2 and 3 and year 2 for states choosing Option 1. EPA also assumes that subcontractor labor for the initial set-up will be an additional 20% of state agency hours.


f Based on interview responses, EPA assumes that, on average, each respondent will share their UST/LUST data on a semiannual basis.


g Respondents choosing Option 4 will have no initial burden in Year 1 or recurring burden in subsequent years.


h EPA assumes that respondents will keep records of all data made available to the Agency. Planning will occur in year 1 and recordkeeping will occur semiannually.


i Totals have been rounded to 3 significant figures. Figures may not add exactly due to rounding.



Sheet 4: Respondent Yr3

Table 3: Annual Respondent Burden and Cost – Underground Storage Tank Finder Application


Year 3











Burden Item A B C D E F G H I


Person-hours
per occurrence
Annual occurrences
per respondent
Person-hours
per respondent
per year (AxB)
Respondents
per year a
Technical hours per
year (CxD)
Management hours per year (Ex0.05) Clerical hours
per year
(Ex0.10)
Subcontractor hours
per year
Annual cost
($) b, c



A. Option 1: Push UST/LUST data to EPA's Virtual Exchange Server









Labor Rates - State Agency
1. Initial program set-up d









Management $69.04
a. Set up Node Administration account. 48 1 48 6 288 14 29
$16,547
Technical $51.23
b. Review data, develop data query to match EPA schema 192 1 192 6 1,152 58 115
$66,188
Clerical $27.73
c. Subcontractor technical assistance e 38 1 38 0.3 0 0 0 12 $1,413


2. Sending data semiannually f









Labor Rates - Subcontractor
a. Verify, quality check, and gather state agency data 1 2 1 12 12 1 1
$689
Technical $122.66
b. Establish connection to VES 0.25 2 1 12 6 0 1
$345


c. Import data exchange and map data 0.25 2 1 12 6 0 1
$345


B. Option 2: Share UST/LUST data with EPA via link to existing state agency website











1. Initial program set-up d











a. Set up approved file sharing method with EPA 8 1 8 0 0 0 0
$0


b. Review and compile minimum data elements from existing databases; verify and update data 50 1 50 0 0 0 0
$0


c. Subcontractor technical assistance e 10 1 10 0 0 0 0 0 $0


2. Sending data semiannually f











a. Verify, quality check, and gather state agency data 2 2 3 12 36 2 4
$2,068


b. Save database(s) in preferred file format on state agency website 1 2 2 12 24 1 2
$1,379


c. Notify EPA that data is available 0.5 2 1 12 12 1 1
$689


C. Option 3: Send UST/LUST data to EPA file sharing site











1. Initial program set-up d











a. Set up approved file sharing method with EPA 8 1 8 0 0 0 0
$0


b. Review and compile minimum data elements from existing databases; verify and update data 144 1 144 0 0 0 0
$0


c. Subcontractor technical assistance e 29 1 29 0 0 0 0 0 $0


2. Sending data semiannually f











a. Verify, quality check, and gather state agency data 9.5 2 19 16 304 15 30
$17,466


b. Save database(s) in preferred file format 0.5 2 1 16 16 1 2
$919


c. Send UST/LUST data to EPA 0.5 2 1 16 16 1 2
$919


d. Notify EPA that data has been sent 0.5 2 1 16 16 1 2
$919


D. Option 4: EPA pulls existing UST/LUST data from existing state agency website











1. No respondent action required g 0 0 0 16 0 0 0
$0


Reporting Subtotal



2,171 12 $109,888


E. Recordkeeping requirements h











a. Plan activities 1 1 1 0 0 0 0 0 $0


b. Record activities 0.5 2 1 40 40 2 4 0 $2,298


Recordkeeping Subtotal



46
$2,298


TOTAL LABOR BURDEN AND COSTS (rounded) i



2,217
$112,200


TOTAL CAPITAL AND O&M COST (rounded) i







$0


GRAND TOTAL (rounded) i







$112,200















Assumptions:











a EPA estimates an average of 40 states/territories will comply voluntarily with EPA's request for data in year 1 of the program, using Options 2 or 3. EPA estimates that, beginning in year 2, 6 states per year will transition to using Option 1. EPA assumes it will retrieve data for the remaining 16 states that do not submit data using Options 1 through 3.


b This ICR uses the following labor rate for subcontractors: $122.66 per hour for Technical labor. This rate is from the United States Department of Labor, Bureau of Labor Statistics, September 2020, “Table 2. Civilian Workers, by occupational and industry group.” The rate is from column 1, “Total compensation.” The BLS rate has been increased by 110 percent to account for the benefit packages available to those employed by private industry.


c This cost is based on the following labor rates which incorporates a 1.6 benefits multiplication factor to account for government overhead expenses. This ICR uses a Managerial rate of $69.04 (GS-13, Step 5, $43.15 + 60%), Technical rate of $51.23 (GS-12, Step 1, $32.02 + 60%), and Clerical rate of $27.73 (GS-6, Step 3, $17.33 + 60%). These rates are from the Office of Personnel Management (OPM), 2021 General Schedule, which excludes locality rates of pay.


d EPA assumes that, in the first year of the program, each respondent will require time to set up their systems to accommodate the data exchange. This involves assessing which data is desired by EPA, re-writing database queries, verifying that queries are correct, and obtaining management permission to share data. As states transition to using Option 1, they will incur burden only once for the initial set-up to implement this Option.


e Based on interview responses, EPA assumes that 5% of states will use outside contractors to initially set up their processes to accommodate the data exchange. This initial set-up will begin in year 1 for states choosing Options 2 and 3 and year 2 for states choosing Option 1. EPA also assumes that subcontractor labor for the initial set-up will be an additional 20% of state agency hours.


f Based on interview responses, EPA assumes that, on average, each respondent will share their UST/LUST data on a semiannual basis.


g Respondents choosing Option 4 will have no initial burden in Year 1 or recurring burden in subsequent years.


h EPA assumes that respondents will keep records of all data made available to the Agency. Planning will occur in year 1 and recordkeeping will occur semiannually.


i Totals have been rounded to 3 significant figures. Figures may not add exactly due to rounding.



Sheet 5: Agency Yr1

Table 4: Average Annual EPA Burden and Cost – Underground Storage Tank Finder Application


Year 1






















Burden Item A B C D E F G H


EPA
person-hours
per occurrence
Annual occurrences
per respondent
EPA
person-hours
per respondent
per year (AxB)
Respondents
per year a
Technical hours
per year
(CxD)
Management
hours per year
(Ex0.05)
Clerical hours
per year
(Ex0.10)
Annual cost
($) b



A. Option 1: Push UST/LUST data to EPA's Virtual Exchange Server c








Labor Rates
1. Participate in meetings with state agency d 2 1 2 0 0 0 0 $0
Management $69.04
2. Provide support throughout the Virtual Exchange Server registration and set-up process d 4 1 4 0 0 0 0 $0
Technical $51.23
3. Review and perform quality control checks on submitted data e 1.9 2 3.8 0 0 0 0 $0
Clerical $27.73
4. Perform geocoding of data that only includes textual address information and not latitude and longitude data e 1.9 2 3.8 0 0 0 0 $0


B. Option 2: Share UST/LUST data with EPA via link to existing state agency website c










1. Set up approved file sharing method with state agency d 1 1 1 18 18 1 2 $1,034


2. Develop an extraction script for downloading the data from state agency website f 3.5 1 3.5 18 63 3 6 $3,620


3. Develop a transform script that translates data to the required format g 3.5 1 3.5 18 63 3 6 $3,620


4. Review and perform quality control checks on submitted data e 1.9 2 3.8 18 68 3 7 $3,930


5. Perform geocoding of data that only includes textual address information and not latitude and longitude data e 1.9 2 3.8 18 68 3 7 $3,930


C. Option 3: Send UST/LUST data to EPA file sharing site c










1. Provide instructions for how to use approved data submission methods (e.g., e-mail, SharePoint, GoAnywhere) d 1 1 1 22 22 1 2 $1,264


2. Provide instructions for how to notify EPA when a data submission has been updated d 0.5 1 0.5 22 11 1 1 $632


3. Develop a customized Extract, Transform, Load (ETL) script that translates data to the required format g 5.5 1 5.5 22 121 6 12 $6,952


4. Perform quality control checks on submitted data e 1.9 2 3.8 22 84 4 8 $4,803


5. Perform geocoding of data that only includes textual address information and not latitude and longitude data e 1.9 2 3.8 22 84 4 8 $4,803


D. Option 4: EPA pulls existing UST/LUST data from existing state agency website c










1. Extract data from agency website and transform data to the required format g 8 1 8 16 128 6 13 $7,354


2. Perform quality control checks on submitted data e 1.9 2 3.8 16 61 3 6 $3,493


3. Perform geocoding of data that only includes textual address information and not latitude and longitude data e 1.9 2 3.8 16 61 3 6 $3,493


TOTAL (rounded) h
979 $48,900














Assumptions:










a EPA estimates an average of 40 states/territories will comply voluntarily with EPA's request for data in year 1 of the program, using Options 2 or 3. EPA estimates that, beginning in year 2, 6 states per year will transition to using Option 1. EPA assumes it will retrieve data for the remaining 16 states that do not submit data using Options 1 through 3.


b This cost is based on the following labor rates which incorporates a 1.6 benefits multiplication factor to account for government overhead expenses. This ICR uses a Managerial rate of $69.04 (GS-13, Step 5, $43.15 + 60%), Technical rate of $51.23 (GS-12, Step 1, $32.02 + 60%), and Clerical rate of $27.73 (GS-6, Step 3, $17.33 + 60%). These rates are from the Office of Personnel Management (OPM), 2021 General Schedule, which excludes locality rates of pay.


c In the first year of the program, EPA will review its own existing UST database, develop a schema for a revised version, and configure the central database.


d In the first year of the program, EPA will assist each respondent in setting up their systems to accommodate the data exchange. This involves assessing which data is desired by EPA, agreeing on a schema and file format, obtaining the permissions required on both sides of the exchange, and other administrative burden. As states transition to using Option 1 in years 2 and 3, the Agency will incur burden for assisting states in implementing Option 1.


e EPA will gather the UST/LUST data from the states/territories on a semiannual basis. The Agency will review and perform quality control checks on submitted data, and provide geocoding for data submitted as addresses. EPA will communicate with states regarding problems and provide ongoing support as needed.


f In the first year of the program, for states utilizing Option 2, EPA will develop an extraction script for downloading the data from the state agency website.


g In the first year of the program, for states utilizing Options 2, 3, and 4, EPA will develop a customized Extract, Transform, Load (ETL) script that translates data to the required format.


h Totals have been rounded to 3 significant figures. Figures may not add exactly due to rounding.



Sheet 6: Agency Yr2

Table 5: Average Annual EPA Burden and Cost – Underground Storage Tank Finder Application


Year 2






















Burden Item A B C D E F G H


EPA
person-hours
per occurrence
Annual occurrences
per respondent
EPA
person-hours
per respondent
per year (AxB)
Respondents
per year a
Technical hours
per year
(CxD)
Management
hours per year
(Ex0.05)
Clerical hours
per year
(Ex0.10)
Annual cost
($) b



A. Option 1: Push UST/LUST data to EPA's Virtual Exchange Server c








Labor Rates
1. Participate in meetings with state agency d 2 1 2 6 12 1 1 $689
Management $69.04
2. Provide support throughout the Virtual Exchange Server registration and set-up process d 4 1 4 6 24 1 2 $1,379
Technical $51.23
3. Review and perform quality control checks on submitted data e 1.9 2 3.8 6 23 1 2 $1,310
Clerical $27.73
4. Perform geocoding of data that only includes textual address information and not latitude and longitude data e 1.9 2 3.8 6 23 1 2 $1,310


B. Option 2: Share UST/LUST data with EPA via link to existing state agency website c










1. Set up approved file sharing method with state agency d 1 0 0 0 0 0 0 $0


2. Develop an extraction script for downloading the data from state agency website f 3.5 1 3.5 0 0 0 0 $0


3. Develop a transform script that translates data to the required format g 3.5 1 3.5 0 0 0 0 $0


4. Review and perform quality control checks on submitted data e 1.9 2 3.8 15 57 3 6 $3,275


5. Perform geocoding of data that only includes textual address information and not latitude and longitude data e 1.9 2 3.8 15 57 3 6 $3,275


C. Option 3: Send UST/LUST data to EPA file sharing site c










1. Provide instructions for how to use approved data submission methods (e.g., e-mail, SharePoint, GoAnywhere) d 1 1 1 0 0 0 0 $0


2. Provide instructions for how to notify EPA when a data submission has been updated d 0.5 1 0.5 0 0 0 0 $0


3. Develop a customized Extract, Transform, Load (ETL) script that translates data to the required format g 5.5 1 5.5 0 0 0 0 $0


4. Perform quality control checks on submitted data e 1.9 2 3.8 19 72 4 7 $4,148


5. Perform geocoding of data that only includes textual address information and not latitude and longitude data e 1.9 2 3.8 19 72 4 7 $4,148


D. Option 4: EPA pulls existing UST/LUST data from existing state agency website c










1. Extract data from agency website and transform data to the required format g 8 1 8 0 0 0 0 $0


2. Perform quality control checks on submitted data e 1.9 2 3.8 16 61 3 6 $3,493


3. Perform geocoding of data that only includes textual address information and not latitude and longitude data e 1.9 2 3.8 16 61 3 6 $3,493


TOTAL (rounded) h
531 $26,500














Assumptions:










a EPA estimates an average of 40 states/territories will comply voluntarily with EPA's request for data in year 1 of the program, using Options 2 or 3. EPA estimates that, beginning in year 2, 6 states per year will transition to using Option 1. EPA assumes it will retrieve data for the remaining 16 states that do not submit data using Options 1 through 3.


b This cost is based on the following labor rates which incorporates a 1.6 benefits multiplication factor to account for government overhead expenses. This ICR uses a Managerial rate of $69.04 (GS-13, Step 5, $43.15 + 60%), Technical rate of $51.23 (GS-12, Step 1, $32.02 + 60%), and Clerical rate of $27.73 (GS-6, Step 3, $17.33 + 60%). These rates are from the Office of Personnel Management (OPM), 2021 General Schedule, which excludes locality rates of pay.


c In the first year of the program, EPA will review its own existing UST database, develop a schema for a revised version, and configure the central database.


d In the first year of the program, EPA will assist each respondent in setting up their systems to accommodate the data exchange. This involves assessing which data is desired by EPA, agreeing on a schema and file format, obtaining the permissions required on both sides of the exchange, and other administrative burden. As states transition to using Option 1 in years 2 and 3, the Agency will incur burden for assisting states in implementing Option 1.


e EPA will gather the UST/LUST data from the states/territories on a semiannual basis. The Agency will review and perform quality control checks on submitted data, and provide geocoding for data submitted as addresses. EPA will communicate with states regarding problems and provide ongoing support as needed.


f In the first year of the program, for states utilizing Option 2, EPA will develop an extraction script for downloading the data from the state agency website.


g In the first year of the program, for states utilizing Options 2, 3, and 4, EPA will develop a customized Extract, Transform, Load (ETL) script that translates data to the required format.


h Totals have been rounded to 3 significant figures. Figures may not add exactly due to rounding.



Sheet 7: Agency Yr3

Table 6: Average Annual EPA Burden and Cost – Underground Storage Tank Finder Application


Year 3






















Burden Item A B C D E F G H


EPA
person-hours
per occurrence
Annual occurrences
per respondent
EPA
person-hours
per respondent
per year (AxB)
Respondents
per year a
Technical hours
per year
(CxD)
Management
hours per year
(Ex0.05)
Clerical hours
per year
(Ex0.10)
Annual cost
($) b



A. Option 1: Push UST/LUST data to EPA's Virtual Exchange Server c








Labor Rates
1. Participate in meetings with state agency d 2 1 2 6 12 1 1 $689
Management $69.04
2. Provide support throughout the Virtual Exchange Server registration and set-up process d 4 1 4 6 24 1 2 $1,379
Technical $51.23
3. Review and perform quality control checks on submitted data e 1.9 2 3.8 12 46 2 5 $2,620
Clerical $27.73
4. Perform geocoding of data that only includes textual address information and not latitude and longitude data e 1.9 2 3.8 12 46 2 5 $2,620


B. Option 2: Share UST/LUST data with EPA via link to existing state agency website c










1. Set up approved file sharing method with state agency d 1 0 0 0 0 0 0 $0


2. Develop an extraction script for downloading the data from state agency website f 3.5 1 3.5 0 0 0 0 $0


3. Develop a transform script that translates data to the required format g 3.5 1 3.5 0 0 0 0 $0


4. Review and perform quality control checks on submitted data e 1.9 2 3.8 12 46 2 5 $2,620


5. Perform geocoding of data that only includes textual address information and not latitude and longitude data e 1.9 2 3.8 12 46 2 5 $2,620


C. Option 3: Send UST/LUST data to EPA file sharing site c










1. Provide instructions for how to use approved data submission methods (e.g., e-mail, SharePoint, GoAnywhere) d 1 1 1 0 0 0 0 $0


2. Provide instructions for how to notify EPA when a data submission has been updated d 0.5 1 0.5 0 0 0 0 $0


3. Develop a customized Extract, Transform, Load (ETL) script that translates data to the required format g 5.5 1 5.5 0 0 0 0 $0


4. Perform quality control checks on submitted data e 1.9 2 3.8 16 61 3 6 $3,493


5. Perform geocoding of data that only includes textual address information and not latitude and longitude data e 1.9 2 3.8 16 61 3 6 $3,493


D. Option 4: EPA pulls existing UST/LUST data from existing state agency website c










1. Extract data from agency website and transform data to the required format g 8 1 8 0 0 0 0 $0


2. Perform quality control checks on submitted data e 1.9 2 3.8 16 61 3 6 $3,493


3. Perform geocoding of data that only includes textual address information and not latitude and longitude data e 1.9 2 3.8 16 61 3 6 $3,493


TOTAL (rounded) h
531 $26,500














Assumptions:










a EPA estimates an average of 40 states/territories will comply voluntarily with EPA's request for data in year 1 of the program, using Options 2 or 3. EPA estimates that, beginning in year 2, 6 states per year will transition to using Option 1. EPA assumes it will retrieve data for the remaining 16 states that do not submit data using Options 1 through 3.


b This cost is based on the following labor rates which incorporates a 1.6 benefits multiplication factor to account for government overhead expenses. This ICR uses a Managerial rate of $69.04 (GS-13, Step 5, $43.15 + 60%), Technical rate of $51.23 (GS-12, Step 1, $32.02 + 60%), and Clerical rate of $27.73 (GS-6, Step 3, $17.33 + 60%). These rates are from the Office of Personnel Management (OPM), 2021 General Schedule, which excludes locality rates of pay.


c In the first year of the program, EPA will review its own existing UST database, develop a schema for a revised version, and configure the central database.


d In the first year of the program, EPA will assist each respondent in setting up their systems to accommodate the data exchange. This involves assessing which data is desired by EPA, agreeing on a schema and file format, obtaining the permissions required on both sides of the exchange, and other administrative burden. As states transition to using Option 1 in years 2 and 3, the Agency will incur burden for assisting states in implementing Option 1.


e EPA will gather the UST/LUST data from the states/territories on a semiannual basis. The Agency will review and perform quality control checks on submitted data, and provide geocoding for data submitted as addresses. EPA will communicate with states regarding problems and provide ongoing support as needed.


f In the first year of the program, for states utilizing Option 2, EPA will develop an extraction script for downloading the data from the state agency website.


g In the first year of the program, for states utilizing Options 2, 3, and 4, EPA will develop a customized Extract, Transform, Load (ETL) script that translates data to the required format.


h Totals have been rounded to 3 significant figures. Figures may not add exactly due to rounding.



Sheet 8: Summary

Table 7: Summary of Annual Respondent and Agency Burden and Cost – Underground Storage Tank Finder Application




























Respondent Burden COSTS

HOURS




Year 1 Year 2 Year 3 $ Total $ Average
(rounded)

Year 1 Year 2 Year 3 Total Average
(rounded)



Option 1 - Reporting $0 $84,838 $85,527 $170,365 $57,000
0 1,681 1,695 3,376 1,130


Option 2 - Reporting $67,292 $5,171 $4,137 $76,600 $26,000
1,334 104 83 1,520 510


Option 3 - Reporting $223,824 $24,016 $20,224 $268,064 $89,000
4,434 481 405 5,319 1,770


Option 4 - Reporting $0 $0 $0 $0 $0
0 0 0 0 0


Reporting Total $291,116 $114,025 $109,888 $515,029 $172,000
5,768 2,266 2,183 10,216 3,410


Recordkeeping Total $4,596 $2,298 $2,298 $9,193 $3,000
92 46 46 184 60
responses hr/response/yr
Total $295,712 $116,323 $112,186
$175,000
5,860 2,312 2,229 10,400 3,470
80 43.4













$3,125 $/respondent
Agency Burden COSTS

HOURS

62 hrs/respondent

Year 1 Year 2 Year 3 $ Total $ Average
(rounded)

Year 1 Year 2 Year 3 Total Average
(rounded)



Option 1 $0 $4,688 $7,308 $11,997 $4,000
0 94 146 240 80


Option 2 $15,099 $6,550 $5,240 $26,889 $9,000
323 131 105 559 186


Option 3 $18,455 $8,297 $6,987 $33,738 $11,200
369 166 140 675 225


Option 4 $14,341 $6,987 $6,987 $28,314 $9,400
287 140 140 567 189


Total $47,895 $26,521 $26,521
$33,600
979 531 531 2,041 680


File Typeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File Modified0000-00-00
File Created0000-00-00

© 2024 OMB.report | Privacy Policy