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. |
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. |
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. |
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. |
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. |
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. |
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. |
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 Type | application/vnd.openxmlformats-officedocument.spreadsheetml.sheet |
File Modified | 0000-00-00 |
File Created | 0000-00-00 |