Burden Calculation Tables

---

Overview

ICR summary
Final State Summary
Present Value Costs
2015NAAcount
2015MarNAAcount
2015 Marg bumpups
Prel2020determinations
NAAs by State
2015Areas by Class
new2008Sev15
2008serious
Table 6 and 7
Table10
Reg lookup
Updated labor rates

---

Sheet 1: ICR summary

The totals below update automatically
labor hours:		119,133			119,133	does not include R9 labor costs (25,200 hours) to develop SIP requirements for 2 CA tribal areas
annual labor cost:		$8,420,380
cost per state:		$271,625			85,133	Difference in this ICR & the previous ICR annual hours
State respondents:		31
hrs/response:		1,241
Responses/state:		3.10
# state respondents:		96

---

Sheet 2: Final State Summary

							$73.50	2019 Estimated total weighted direct and indirect hourly equivalent salary																														Table 8 in SS
				2015 NAAQS			2015 NAAQS			2015 NAAQS			2015 NAAQS			2015 NAAQS			2015 NAAQS			2015 NAAQS			2015 NAAQS			2008 NAAQS			2008 NAAQS			1997 NAAQS
ST	Region	OTR State RACT	Unit Hours	Cost	MAR	Unit Hours	Cost	Marginal B-U	Unit Hours	Cost	MOD	Unit Hours	Cost	SER	Unit Hours	Cost	SEV15	Unit Hours	Cost	SEV17	Unit Hours	Cost	EX	Unit Hours	Cost	2008 Serious to SEV15	Unit Hours	Cost	2nd MPs	Unit Hours	Cost	2nd MPs	Unit Hours	Cost	STATE TOTAL	STATE TOTAL HOURS	State Abrv.	State	EPA Region	No. of Areas/OTR State	Yr 1 hrs	Yr 2 hrs	Yr 3 hrs	Yr 1 cost	Yr 2 cost	Yr 3 cost
AZ	9	0	0	$-	1	100	$7,350	1	5100	$374,850	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	1	100	$7,350	$389,550	5,300	AZ	Arizona	9	3	2,650	1,325	1,325	$194,775	$97,388	$97,388
CA	9	0	0	$-	7	700	$51,450	3	15300	$1,124,550	4	20000	$1,470,000	1	20000	$1,470,000	2	10000	$735,000	0	0	$-	2	40000	$2,940,000	3	15000	$1,102,500	0	0	$-	1	100	$7,350	$8,900,850	121,100	CA	California	9	23	60,550	30,275	30,275	$4,450,425	$2,225,213	$2,225,213
CO	8	0	0	$-	0	0	$-	1	5100	$374,850	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	1	5000	$367,500	0	0	$-	0	0	$-	$742,350	10,100	CO	Colorado	8	2	5,050	2,525	2,525	$371,175	$185,588	$185,588
CT	1	1	500	$36,750	0	0	$-	1	5100	$374,850	1	5000	$367,500	0	0	$-	0	0	$-	0	0	$-	0	0	$-	1	5000	$367,500	0	0	$-	0	0	$-	$1,146,600	15,600	CT	Connecticut	1	4	7,800	3,900	3,900	$573,300	$286,650	$286,650
DC	1	1	500	$36,750	0	0	$-	1	5100	$374,850	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	$411,600	5,600	DC	District of Columbia	1	2	2,800	1,400	1,400	$205,800	$102,900	$102,900
DE	3	1	500	$36,750	0	0	$-	1	5100	$374,850	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	$411,600	5,600	DE	Delaware	3	2	2,800	1,400	1,400	$205,800	$102,900	$102,900
GA	4	0	0	$-	1	100	$7,350	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	1	100	$7,350	$14,700	200	GA	Georgia	4	2	100	50	50	$7,350	$3,675	$3,675
IL	5	0	0	$-	0	0	$-	2	10200	$749,700	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	1	5000	$367,500	0	0	$-	0	0	$-	$1,117,200	15,200	IL	Illinois	5	3	7,600	3,800	3,800	$558,600	$279,300	$279,300
IN	5	0	0	$-	0	0	$-	2	10200	$749,700	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	1	5000	$367,500	0	0	$-	0	0	$-	$1,117,200	15,200	IN	Indiana	5	3	7,600	3,800	3,800	$558,600	$279,300	$279,300
KY	4	0	0	$-	0	0	$-	2	10200	$749,700	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	$749,700	10,200	KY	Kentucky	4	2	5,100	2,550	2,550	$374,850	$187,425	$187,425
MA	1	1	500	$36,750	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	$36,750	500	MA	Massachusetts	1	1	250	125	125	$18,375	$9,188	$9,187.50
MD	3	1	500	$36,750	0	0	$-	3	15300	$1,124,550	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	$1,161,300	15,800	MD	Maryland	3	4	7,900	3,950	3,950	$580,650	$290,325	$290,325
ME	1	1	500	$36,750	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	$36,750	500	ME	Maine	1	1	250	125	125	$18,375	$9,188	$9,187.50
MI	5	0	0	$-	0	0	$-	4	20400	$1,499,400	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	$1,499,400	20,400	MI	Michigan	5	4	10,200	5,100	5,100	$749,700	$374,850	$374,850
MO	7	0	0	$-	0	0	$-	1	5100	$374,850	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	1	100	$7,350	$382,200	5,200	MO	Missouri	7	2	2,600	1,300	1,300	$191,100	$95,550	$95,550
NH	1	1	500	$36,750	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	1	100	$7,350	$44,100	600	NH	New Hampshire	1	2	300	150	150	$22,050	$11,025	$11,025.00
NJ	2	1	500	$36,750	0	0	$-	1	5100	$374,850	1	5000	$367,500	0	0	$-	0	0	$-	0	0	$-	0	0	$-	1	5000	$367,500	0	0	$-	0	0	$-	$1,146,600	15,600	NJ	New Jersey	2	4	7,800	3,900	3,900	$573,300	$286,650	$286,650
NM	6	0	0	$-	0	0	$-	1	5100	$374,850	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	$374,850	5,100	NM	New Mexico	6	1	2,550	1,275	1,275	$187,425	$93,713	$93,713
NV	9	0	0	$-	0	0	$-	1	5100	$374,850	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	1	100	$7,350	$382,200	5,200	NV	Nevada	9	2	2,600	1,300	1,300	$191,100	$95,550	$95,550
NY	2	1	500	$36,750	0	0	$-	0	0	$-	1	5000	$367,500	0	0	$-	0	0	$-	0	0	$-	0	0	$-	1	5000	$367,500	0	0	$-	0	0	$-	$771,750	10,500	NY	New York	2	3	5,250	2,625	2,625	$385,875	$192,938	$192,938
OH	5	0	0	$-	1	100	$7,350	2	10200	$749,700	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	$757,050	10,300	OH	Ohio	5	3	5,150	2,575	2,575	$378,525	$189,263	$189,263
PA	3	1	500	$36,750	0	0	$-	1	5100	$374,850	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	$411,600	5,600	PA	Pennsylvania	3	2	2,800	1,400	1,400	$205,800	$102,900	$102,900
RI	1	1	500	$36,750	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	$36,750	500	RI	Rhode Island	1	1	250	125	125	$18,375	$9,188	$9,187.50
TX	6	0	0	$-	1	100	$7,350	2	10200	$749,700	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	2	10000	$735,000	0	0	$-	0	0	$-	$1,492,050	20,300	TX	Texas	6	5	10,150	5,075	5,075	$746,025	$373,013	$373,013
UT	8	0	0	$-	1	100	$7,350	2	10200	$749,700	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	$757,050	10,300	UT	Utah	8	3	5,150	2,575	2,575	$378,525	$189,263	$189,263
VA	3	1	500	$36,750	0	0	$-	1	5100	$374,850	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	$411,600	5,600	VA	Virginia	3	2	2,800	1,400	1,400	$205,800	$102,900	$102,900
VT	1	1	500	$36,750	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	$36,750	500	VT	Vermont	1	1	250	125	125	$18,375	$9,188	$9,187.50
WI	5	0	0	$-	1	100	$7,350	3	15300	$1,124,550	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	1	5000	$367,500	0	0	$-	0	0	$-	$1,499,400	20,400	WI	Wisconsin	5	5	10,200	5,100	5,100	$749,700	$374,850	$374,850
																										$12									$26,239,500
	28	13	6500	$477,750	13	1300	$95,550	36	183600	$13,494,600	7	35000	$2,572,500	1	20000	$1,470,000	2	10000	$735,000	0	0	$0	2	40000	$2,940,000	12	60000	$4,410,000	0	0	$0	6	600	$44,100	$26,239,500	357,000	92	# of RESPONSES for NAAs		92	178,500	89,250	89,250	$13,119,750	$6,559,875	$6,559,875
# of state respondents for NAAs & OTR
(States with no nonattainment areas)										$-			$-			$-			$-			$-			$-											28	COUNT OF STATES with NAAs & OTR
WV	3				0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-				0	0	$-	0	0	$-	$-		WV		3	0	0	0	0	$-	$-	$-
AL	4				0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-				0	0	$-	0	0	$-	$-		AL		4	0	0	0	0	$-	$-	$-
FL	4				0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-				0	0	$-	0	0	$-	$-		FL		4	0	0	0	0	$-	$-	$-
MS	4				0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-				0	0	$-	0	0	$-	$-		MS		4	0	0	0	0	$-	$-	$-
NC	4				0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-				1	100	$7,350	1	100	$7,350	$14,700	200	NC	North Carolina	4	2	100	50	50	$7,350	$3,675	$3,675.00
SC	4				0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-				1	100	$7,350	0	0	$-	$7,350	100	SC	South Carolina	4	1	50	25	25	$3,675	$1,838	$1,837.50
TN	4				0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-				1	100	$7,350	0	0	$-	$7,350	100	TN	Tennessee	4	1	50	25	25	$3,675	$1,838	$1,837.50
MN	5				0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-				0	0	$-	0	0	$-	$-		MN		5	0	0	0	0	$-	$-	$-
AR	6				0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-				0	0	$-	0	0	$-	$-		AR	Arkansas	6	0	0	0	0	$-	$-	$-
LA	6				0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-				0	0	$-	0	0	$-	$-		LA	Louisiana	6	0	0	0	0	$-	$-	$-
OK	6				0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-				0	0	$-	0	0	$-	$-		OK		6	0	0	0	0	$-	$-	$-
IA	7				0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-				0	0	$-	0	0	$-	$-		IA		7	0	0	0	0	$-	$-	$-
KS	7				0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-				0	0	$-	0	0	$-	$-		KS		7	0	0	0	0	$-	$-	$-
NE	7				0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-				0	0	$-	0	0	$-	$-		NE		7	0	0	0	0	$-	$-	$-
MT	8				0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-				0	0	$-	0	0	$-	$-		MT		8	0	0	0	0	$-	$-	$-
ND	8				0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-				0	0	$-	0	0	$-	$-		ND		8	0	0	0	0	$-	$-	$-
SD	8				0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-				0	0	$-	0	0	$-	$-		SD		8	0	0	0	0	$-	$-	$-
WY	8				0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-				0	0	$-	0	0	$-	$-		WY	Wyoming	8	0	0	0	0	$-	$-	$-
HI	9				0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-				0	0	$-	0	0	$-	$-		HI		9	0	0	0	0	$-	$-	$-
AK	10				0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-				0	0	$-	0	0	$-	$-		AK		10	0	0	0	0	$-	$-	$-
ID	10				0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-				0	0	$-	0	0	$-	$-		ID		10	0	0	0	0	$-	$-	$-
OR	10				0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-				0	0	$-	0	0	$-	$-		OR		10	0	0	0	0	$-	$-	$-
WA	10				0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-	0	0	$-				0	0	$-	0	0	$-	$-		WA		10	0	0	0	0	$-	$-	$-
					0			0			0			0			0			0			0						3	300	$22,050	1	100	$7,350	$29,400	400				4	200	100	100	14,700	7,350	7,350	0
		13	6500	$477,750	13	1300	$95,550	36	183600	$13,494,600	7	35000	$2,572,500	1	20000	$1,470,000	2	10000	$735,000	0	0	$-	2	40000	$2,940,000	12	60000	$4,410,000	3	300	$22,050	7	700	$51,450	$26,268,900	357,400	96			96	178,700	89,350	89,350	$13,134,450	$6,567,225	$6,567,225	$26,268,900
																																				3	COUNT OF STATES with no NAAs with 2nd MPs
Total # of State reqmnts							86	356,400	State hours
	31							Sum hrs
	(Does not include 2 tribal areas in R9
(2 Tribal areas in CA that R9 will Implement)										$-			$-			$-			$-			$-			$-												(2 Tribal areas in CA that R9 will Implement)	GRAND TOTAL W/O TRIBAL AREAS IN CA		96	178,700	89,350	89,350	13,134,450	6,567,225	6,567,225
R9	9	0	0	0	0	0	$-	1	5100	$374,850	0	0	$-	1	20000	$1,470,000	0	0	$-	0	0	$-	0	0	$-							1	100	$7,350	$1,852,200	25,200	R9	California Tribal Land	9	2	12,600	6300	6300	$926,100	$463,050	463,050
Total areas with R9 tribal areas & OTR States		13	6,500	$477,750	13	1,300	$95,550	37	188,700	$13,869,450	7	35,000	$2,572,500	2	40,000	$2,940,000	2	10,000	$735,000	0	0	$0	2	40,000	$2,940,000	12	60,000	$4,410,000	3	300	$22,050				$28,062,300	381,800
								381,600	State hours & R9 hours for 2 tribal areas

---

Sheet 3: Present Value Costs

			EPA								Alternative to 50% 1st year then 25%
Region	State Total Hours by Region	State Total Cost by Region	Yr 1 EPA Region hrs	Yr 2 EPA Region hrs	Yr 3 EPA Reg. Hr	EPA Regional Total	Yr 1 EPA Region Cost	Yr 2 EPA Region Cost	Yr 3 EPA Region Cost	EPA Regional Total	Yr 1 EPA Region hrs (37.5)	Yr 2 EPA Region hrs (37.5)	Yr 3 EPA Reg. Hr (25)
1	23,800	$1,749,300	1,190	595	595	2,380	$87,465	$43,733	$43,733	$174,930	893	893	595
2	26,100	$1,918,350	1,305	653	653	2,610	$95,918	$47,959	$47,959	$191,835	979	979	653
3	32,600	$2,396,100	1,630	815	815	3,260	$119,805	$59,903	$59,903	$239,610	1223	1223	815
4	10,800	$793,800	540	270	270	1,080	$39,690	$19,845	$19,845	$79,380	405	405	270
5	81,500	$5,990,250	4,075	2,038	2,038	8,150	$299,513	$149,756	$149,756	$599,025	3056	3056	2038
6	25,400	$1,866,900	1,270	635	635	2,540	$93,345	$46,673	$46,673	$186,690	953	953	635
7	5,200	$382,200	260	130	130	520	$19,110	$9,555	$9,555	$38,220	195	195	130
8	20,400	$1,499,400	1,020	510	510	2,040	$74,970	$37,485	$37,485	$149,940	765	765	510
9	131,600	$9,672,600	6,580	3,290	3,290	13,160	$483,630	$241,815	$241,815	$967,260	4935	4935	3290
2 tribes in R9 (2015 Mar-Mod * 2 2008 Ser-Sev)	-	$-	12,600	6,300	6,300	25,200	$856,296	$428,148	$428,148	$1,712,592	4,725	4,725	3,150
10	-	$-	-	-	-	-	$-	$-	$-	$-	0	0	0
	357,400	$26,268,900	30,470	15,235	15,235	60,940	2,169,741	$1,084,871	$1,084,871	$4,339,482	18128	18128	12085
HEADQUARTERS			3,047	1,524	1,524	6,094	$216,974	$108,487	$108,487	$433,948	1813	1813	1209
TOTAL EPA BURDEN			33,517	16,759	16,759	67,034	$2,386,715	$1,193,358	$1,193,358	$4,773,430	19940	19940	13294
Average Yearly Burden (hours)
States	119,133	Moved 25,200 to Regional hrs for R9 hours to develop SIP requirements for 2 tribal areas in CA including 2nd MP for 1997 Pechanga							Adjusted formula to have Region 9 incur burden of developing the Tribal planning and control requirements for the 2 tribal nonattainment areas – Morongo Band of Mission Indians and Pechanga Band of Luiseno Mission Indians of the Pechanga Reservation. Pechanga bumped up for 2015 Marginal to Moderate & both tribal areas bumped up 2008 Serious to Severe. Pechanga has a 2nd MP for 1997 ozone included.
EPA	22,345
Total	141,478
			Discount rate at 3.25% from Larry Sorrells in June 2020
Present value costs		2nd year rate	1.066056	3rd year rate	1.100703078125
	2nd year	3rd year	Subtotal	Total
States	$6,160,299	$5,966,391	$12,126,690	$25,261,140	$8,420,379.94		$205,375
EPA	$1,119,413	$1,084,178	$2,203,591	$4,590,306	$1,530,101.98
Total	$7,279,712	$7,050,569	$14,330,281	$29,851,446	$9,950,481.92
		Total 3-yr burden hours		424,434
				Highlighted numbers needed in ICR

---

Sheet 4: 2015NAAcount

Actual NA Area name	Count of State
Allegan County, MI	1
Amador County, CA	1
Atlanta, GA	1
Baltimore, MD	1
Berrien County, MI	1
Butte County, CA	1
Calaveras County, CA	1
Chicago, IL-IN-WI	3
Cincinnati, OH-KY	2
Cleveland, OH	1
Columbus, OH	1
Dallas-Fort Worth, TX	1
Denver Metro/North Front Range, CO	1
Detroit, MI	1
Door County, WI	1
Greater Connecticut, CT	1
Houston-Galveston-Brazoria, TX	1
Imperial County, CA	1
Kern County (Eastern Kern), CA	1
Las Vegas, NV	1
Los Angeles-San Bernardino Counties (West Mojave Desert), CA	1
Los Angeles-South Coast Air Basin, CA	1
Louisville, KY-IN	2
Manitowoc County, WI	1
Mariposa County, CA	1
Morongo Band of Mission Indians, CA	1
Muskegon County, MI	1
Nevada County (Western part), CA	1
New York-Northern New Jersey-Long Island, NY-NJ-CT	3
Northern Milwaukee/Ozaukee Shoreline, WI	1
Northern Wasatch Front, UT	1
Pechanga Band of Luiseño Mission Indians of the Pechanga Reservation, CA	1
Philadelphia-Wilmington-Atlantic City, PA-NJ-MD-DE	4
Phoenix-Mesa, AZ	1
Riverside County (Coachella Valley), CA	1
Sacramento Metro, CA	1
San Antonio, TX	1
San Diego County, CA	1
San Francisco Bay Area, CA	1
San Joaquin Valley, CA	1
San Luis Obispo (Eastern part), CA	1
Sheboygan County, WI	1
Southern Wasatch Front, UT	1
St. Louis, MO-IL	2
Sutter Buttes, CA	1
Tuolumne County, CA	1
Tuscan Buttes, CA	1
Uinta Basin, UT	1
Ventura County, CA	1
Washington, DC-MD-VA	3
Yuma, AZ	1
Dona Ana County (Sunland Park Area), NM	1		52
Total Result	64

---

Sheet 5: 2015MarNAAcount

Count of Classification	Classification
2015 NAAQS Nonattainment Area	Marginal	Total Result
Allegan County, MI	1	1
Baltimore, MD	1	1
Berrien County, MI	1	1
Chicago, IL-IN-WI	1	1
Cincinnati, OH-KY	1	1
Cleveland, OH	1	1
Dallas-Fort Worth, TX	1	1
Denver Metro/North Front Range, CO	1	1
Detroit, MI	1	1
Dona Ana County (Sunland Park), NM	1	1
Greater Connecticut, CT	1	1
Houston-Galveston-Brazoria, TX	1	1
Imperial County, CA	1	1
Las Vegas, NV	1	1
Louisville, KY-IN	1	1
Mariposa County, CA	1	1
Muskegon County, MI	1	1
Northern Milwaukee/Ozaukee Shoreline, WI	1	1
Northern Wasatch Front, UT	1	1
Pechanga Band of Luiseno Mission Indians, CA	1	1
Philadelphia-Wilmington-Atlantic City, PA-NJ-MD-DE	1	1
Phoenix-Mesa, AZ	1	1
Sheboygan County, WI	1	1
St. Louis, MO-IL	1	1
Tuolumne County, CA	1	1
Uinta Basin, UT	1	1
Washington, DC-MD-VA	1	1
Total Result	27	27

---

Sheet 6: 2015 Marg bumpups

Count of Status	Status
2015 NAAQS Nonattainment Area	Nonattainment	Total Result
Allegan County, MI	1	1
Baltimore, MD	1	1
Berrien County, MI	1	1
Chicago, IL-IN-WI	1	1
Cincinnati, OH-KY	1	1
Cleveland, OH	1	1
Dallas-Fort Worth, TX	1	1
Denver Metro/North Front Range, CO	1	1
Detroit, MI	1	1
Dona Ana County (Sunland Park), NM	1	1
Greater Connecticut, CT	1	1
Houston-Galveston-Brazoria, TX	1	1
Imperial County, CA	1	1
Las Vegas, NV	1	1
Louisville, KY-IN	1	1
Mariposa County, CA	1	1
Muskegon County, MI	1	1
Northern Milwaukee/Ozaukee Shoreline, WI	1	1
Northern Wasatch Front, UT	1	1
Pechanga Band of Luiseno Mission Indians, CA	1	1
Philadelphia-Wilmington-Atlantic City, PA-NJ-MD-DE	1	1
Phoenix-Mesa, AZ	1	1
Sheboygan County, WI	1	1
St. Louis, MO-IL	1	1
Tuolumne County, CA	1	1
Uinta Basin, UT	1	1
Washington, DC-MD-VA	1	1
Total Result	27	27

---

Sheet 7: Prel2020determinations

2015 ozone Marginal areas preliminary meets NAAQS determination from September 2020
2015 NAAQS Nonattainment Area	Status	Classification	Meets 2015 NAAQS?
Allegan County, MI	Nonattainment	Marginal	No
Baltimore, MD	Nonattainment	Marginal	No
Berrien County, MI	Nonattainment	Marginal	No
Chicago, IL-IN-WI	Nonattainment	Marginal	No
Cincinnati, OH-KY	Nonattainment	Marginal	No
Cleveland, OH	Nonattainment	Marginal	No
Dallas-Fort Worth, TX	Nonattainment	Marginal	No
Denver Metro/North Front Range, CO	Nonattainment	Marginal	No
Detroit, MI	Nonattainment	Marginal	No
Dona Ana County (Sunland Park), NM	Nonattainment	Marginal	No
Greater Connecticut, CT	Nonattainment	Marginal	No
Houston-Galveston-Brazoria, TX	Nonattainment	Marginal	No
Imperial County, CA	Nonattainment	Marginal	No
Las Vegas, NV	Nonattainment	Marginal	No
Louisville, KY-IN	Nonattainment	Marginal	No
Mariposa County, CA	Nonattainment	Marginal	No
Muskegon County, MI	Nonattainment	Marginal	No
Northern Milwaukee/Ozaukee Shoreline, WI	Nonattainment	Marginal	No
Northern Wasatch Front, UT	Nonattainment	Marginal	No
Pechanga Band of Luiseno Mission Indians, CA	Nonattainment	Marginal	No
Philadelphia-Wilmington-Atlantic City, PA-NJ-MD-DE	Nonattainment	Marginal	No
Phoenix-Mesa, AZ	Nonattainment	Marginal	No
Sheboygan County, WI	Nonattainment	Marginal	No
St. Louis, MO-IL	Nonattainment	Marginal	No
Tuolumne County, CA	Nonattainment	Marginal	No
Uinta Basin, UT	Nonattainment	Marginal	No
Washington, DC-MD-VA	Nonattainment	Marginal	No
Door County, WI	Nonattainment	Marginal - RTA	No
Atlanta, GA	Nonattainment	Marginal	Yes
Manitowoc County, WI	Nonattainment	Marginal	Yes
San Antonio, TX	Nonattainment	Marginal	Yes
Tuscan Buttes, CA	Nonattainment	Marginal	Yes
Butte County, CA	Nonattainment	Marginal	Yes
Calaveras County, CA	Nonattainment	Marginal	Yes
San Luis Obispo (Eastern part), CA	Nonattainment	Marginal	Yes
Southern Wasatch Front, UT	Nonattainment	Marginal	Yes
Yuma, AZ	Nonattainment	Marginal	Yes
Amador County, CA	Nonattainment	Marginal	Yes
Columbus, OH	Maintenance	Marginal	Yes
Sutter Buttes, CA	Nonattainment	Marginal	Yes
San Francisco Bay Area, CA	Nonattainment	Marginal	Yes

---

Sheet 8: NAAs by State

Nonattainment Areas by Classification
Actual NA Area name	_state_name	State	70 ppb	NAAs for Marginal to Moderate bumpup based on 2020 preliminary data	Marginal to Moderate bumpup based preliminary 2020 data		Area Name	Simple Area Name	Common Area Mapping ID	Region
Phoenix-Mesa, AZ		AZ	Marginal	Phoenix-Mesa, AZ	Moderate		Phoenix-Mesa	Phoenix-Mesa	Ozone_8-hr.2015.Phoenix	9
Yuma, AZ		AZ	Marginal				Yuma	Yuma	Ozone_8-hr.2015.Yuma	9
Amador County, CA		CA	Marginal			0	Amador County	Amador and Calaveras Counties (Central Mountain Counties)	Ozone_8-hr.2015.Amador_Co	9
Butte County, CA		CA	Marginal				Butte County	Chico	Ozone_8-hr.2015.Chico	9
Calaveras County, CA		CA	Marginal				Calaveras County	Amador and Calaveras Counties (Central Mountain Counties)	Ozone_8-hr.2015.Calaveras_Co	9
Imperial County, CA		CA	Marginal	Imperial County, CA	Moderate		Imperial County	Imperial County	Ozone_8-hr.2015.Imperial_Co	9
Kern County (Eastern Kern), CA		CA	Moderate				Kern County (Eastern Kern)	San Joaquin Valley	Ozone_8-hr.2015.East_Kern	9
Los Angeles-San Bernardino Counties (West Mojave Desert), CA		CA	Severe-15				Los Angeles-San Bernardino Counties (West Mojave Desert)	Southeast Desert Modified AQMA	Ozone_8-hr.2015.LA-Desert	9
Los Angeles-South Coast Air Basin, CA		CA	Extreme				Los Angeles-South Coast Air Basin	Los Angeles-South Coast Air Basin	Ozone_8-hr.2015.LA-South_Coast	9
Mariposa County, CA		CA	Marginal	Mariposa County, CA	Moderate		Mariposa County	Mariposa and Tuolumne Counties (Southern Mountain Counties)	Ozone_8-hr.2015.Mariposa_Co	9
Nevada County (Western part), CA		CA	Moderate				Nevada County (Western part)	Nevada County (Western part)	Ozone_8-hr.2015.Nevada_Co	9
Riverside County (Coachella Valley), CA		CA	Severe-15				Riverside County (Coachella Valley)	Southeast Desert Modified AQMA	Ozone_8-hr.2015.Coachella_Valley	9
Sacramento Metro, CA		CA	Moderate				Sacramento Metro	Sacramento Metro	Ozone_8-hr.2015.Sacramento	9
San Diego County, CA		CA	Moderate				San Diego County	San Diego	Ozone_8-hr.2015.San_Diego	9
San Francisco Bay Area, CA		CA	Marginal				San Francisco Bay Area	San Francisco-Bay Area	Ozone_8-hr.2015.San_Francisco	9
San Joaquin Valley, CA		CA	Extreme				San Joaquin Valley	San Joaquin Valley	Ozone_8-hr.2015.San_Joaquin_Valley	9
San Luis Obispo (Eastern part), CA		CA	Marginal				San Luis Obispo (Eastern part)	San Luis Obispo	Ozone_8-hr.2015.San_Luis_Obispo	9
Sutter Buttes, CA		CA	Marginal				Sutter Buttes	Yuba City	Ozone_8-hr.2015.Sutter_Buttes	9
Tuolumne County, CA		CA	Marginal	Tuolumne County, CA	Moderate		Tuolumne County	Mariposa and Tuolumne Counties (Southern Mountain Counties)	Ozone_8-hr.2015.Tuolumne_Co	9
Tuscan Buttes, CA		CA	Marginal			Marginal (Rural Transport)	Tuscan Buttes	Tuscan Buttes	Ozone_8-hr.2015.Tuscan_Buttes	9
Ventura County, CA		CA	Serious				Ventura County	Ventura County	Ozone_8-hr.2015.Ventura_Co	9
Denver Metro/North Front Range, CO		CO	Marginal	Denver Metro/North Front Range, CO	Moderate		Denver Metro/North Front Range	Denver-Boulder-Greeley-Ft. Collins-Loveland	Ozone_8-hr.2015.Denver	8
Greater Connecticut, CT		CT	Marginal	Greater Connecticut, CT	Moderate		Greater Connecticut	Greater Connecticut	Ozone_8-hr.2015.Connecticut	1
New York-Northern New Jersey-Long Island, NY-NJ-CT		CT	Moderate				New York-Northern New Jersey-Long Island	New York-N. New Jersey-Long Island	Ozone_8-hr.2015.New_York	1
Washington, DC-MD-VA		DC	Marginal	Washington, DC-MD-VA	Moderate		Washington	Washington	Ozone_8-hr.2015.Washington	3
Philadelphia-Wilmington-Atlantic City, PA-NJ-MD-DE		DE	Marginal	Philadelphia-Wilmington-Atlantic City, PA-NJ-MD-DE	Moderate		Philadelphia-Wilmington-Atlantic City	Philadelphia-Wilmington-Atlantic City	Ozone_8-hr.2015.Philadelphia	3
Atlanta, GA		GA	Marginal				Atlanta	Atlanta	Ozone_8-hr.2015.Atlanta	4
Chicago, IL-IN-WI		IL	Marginal	Chicago, IL-IN-WI	Moderate		Chicago	Chicago-Joliet-Naperville	Ozone_8-hr.2015.Chicago	5
St. Louis, MO-IL		IL	Marginal	St. Louis, MO-IL	Moderate		St. Louis	St. Louis	Ozone_8-hr.2015.St_Louis	5
Chicago, IL-IN-WI		IN	Marginal	Chicago, IL-IN-WI	Moderate		Chicago	Chicago-Joliet-Naperville	Ozone_8-hr.2015.Chicago	5
Louisville, KY-IN		IN	Marginal	Louisville, KY-IN	Moderate		Louisville	Louisville	Ozone_8-hr.2015.Louisville	5
Cincinnati, OH-KY		KY	Marginal	Cincinnati, OH-KY	Moderate		Cincinnati	Cincinnati-Middletown-Wilmington	Ozone_8-hr.2015.Cincinnati	4
Louisville, KY-IN		KY	Marginal	Louisville, KY-IN	Moderate		Louisville	Louisville	Ozone_8-hr.2015.Louisville	4
Baltimore, MD		MD	Marginal	Baltimore, MD	Moderate		Baltimore	Baltimore	Ozone_8-hr.2015.Baltimore	3
Philadelphia-Wilmington-Atlantic City, PA-NJ-MD-DE		MD	Marginal	Philadelphia-Wilmington-Atlantic City, PA-NJ-MD-DE	Moderate		Philadelphia-Wilmington-Atlantic City	Philadelphia-Wilmington-Atlantic City	Ozone_8-hr.2015.Philadelphia	3
Washington, DC-MD-VA		MD	Marginal	Washington, DC-MD-VA	Moderate		Washington	Washington	Ozone_8-hr.2015.Washington	3
Allegan County, MI		MI	Marginal	Allegan County, MI	Moderate		Allegan County	Allegan County	Ozone_8-hr.2015.Allegan_Co	5
Berrien County, MI		MI	Marginal	Berrien County, MI	Moderate		Berrien County	Benton Harbor	Ozone_8-hr.2015.Benton_Harbor	5
Detroit, MI		MI	Marginal	Detroit, MI	Moderate		Detroit	Detroit-Ann Arbor	Ozone_8-hr.2015.Detroit	5
Muskegon County, MI		MI	Marginal	Muskegon County, MI	Moderate		Muskegon County	Muskegon	Ozone_8-hr.2015.Muskegon	5
St. Louis, MO-IL		MO	Marginal	St. Louis, MO-IL	Moderate		St. Louis	St. Louis	Ozone_8-hr.2015.St_Louis	7
New York-Northern New Jersey-Long Island, NY-NJ-CT		NJ	Moderate		#N/A		New York-Northern New Jersey-Long Island	New York-N. New Jersey-Long Island	Ozone_8-hr.2015.New_York	2
Philadelphia-Wilmington-Atlantic City, PA-NJ-MD-DE		NJ	Marginal	Philadelphia-Wilmington-Atlantic City, PA-NJ-MD-DE	Moderate		Philadelphia-Wilmington-Atlantic City	Philadelphia-Wilmington-Atlantic City	Ozone_8-hr.2015.Philadelphia	2
Dona Ana County (Sunland Park Area), NM		NM	Marginal	Dona Ana County (Sunland Park Area), NM	Moderate		Doña Ana County (Sunland Park Area)	Sunland Park	Ozone_8-hr.2015.Sunland_Park	6
Las Vegas, NV		NV	Marginal	Las Vegas, NV	Moderate		Las Vegas	Las Vegas	Ozone_8-hr.2015.Las_Vegas	9
New York-Northern New Jersey-Long Island, NY-NJ-CT		NY	Moderate		#N/A		New York-Northern New Jersey-Long Island	New York-N. New Jersey-Long Island	Ozone_8-hr.2015.New_York	2
Cincinnati, OH-KY		OH	Marginal	Cincinnati, OH-KY	Moderate		Cincinnati	Cincinnati-Middletown-Wilmington	Ozone_8-hr.2015.Cincinnati	5
Cleveland, OH		OH	Marginal	Cleveland, OH	Moderate		Cleveland	Cleveland-Akron-Elyria	Ozone_8-hr.2015.Cleveland	5
Columbus, OH		OH	Marginal				Columbus	Columbus-Marion-Chillicothe	Ozone_8-hr.2015.Columbus	5
Philadelphia-Wilmington-Atlantic City, PA-NJ-MD-DE		PA	Marginal	Philadelphia-Wilmington-Atlantic City, PA-NJ-MD-DE	Moderate		Philadelphia-Wilmington-Atlantic City	Philadelphia-Wilmington-Atlantic City	Ozone_8-hr.2015.Philadelphia	3
Morongo Band of Mission Indians, CA		R9	Serious				Morongo Band of Mission Indians	Los Angeles-South Coast Air Basin	Ozone_8-hr.2015.Morongo	9
Pechanga Band of Luiseño Mission Indians of the Pechanga Reservation, CA		R9	Marginal	Pechanga Band of Luiseño Mission Indians of the Pechanga Reservation, CA	Moderate		Pechanga Band of Luiseño Mission Indians of the Pechanga Reservation	Los Angeles-South Coast Air Basin	Ozone_8-hr.2015.Pechanga	9
Dallas-Fort Worth, TX		TX	Marginal	Dallas-Fort Worth, TX	Moderate		Dallas-Fort Worth	Dallas-Fort Worth	Ozone_8-hr.2015.Dallas	6
Houston-Galveston-Brazoria, TX		TX	Marginal	Houston-Galveston-Brazoria, TX	Moderate		Houston-Galveston-Brazoria	Houston-Sugar Land-Baytown	Ozone_8-hr.2015.Houston	6
San Antonio, TX		TX	Marginal				San Antonio	San Antonio	Ozone_8-hr.2015.San_Antonio	6
Northern Wasatch Front, UT		UT	Marginal	Northern Wasatch Front, UT	Moderate		Northern Wasatch Front	Salt Lake City	Ozone_8-hr.2015.Salt_Lake	8
Southern Wasatch Front, UT		UT	Marginal				Southern Wasatch Front	Provo	Ozone_8-hr.2015.Provo	8
Uinta Basin, UT		UT	Marginal	Uinta Basin, UT	Moderate		Uinta Basin	Uinta Basin	Ozone_8-hr.2015.Uinta_Basin	8
Washington, DC-MD-VA		VA	Marginal	Washington, DC-MD-VA	Moderate		Washington	Washington	Ozone_8-hr.2015.Washington	3
Chicago, IL-IN-WI		WI	Marginal	Chicago, IL-IN-WI	Moderate		Chicago	Chicago-Joliet-Naperville	Ozone_8-hr.2015.Chicago	5
Door County, WI		WI	Marginal (Rural Transport)	Door County, WI	Do not bump up Rural transport areas	Marginal (Rural Transport)	Door County	Door County	Ozone_8-hr.2015.Door_Co	5
Manitowoc County, WI		WI	Marginal				Manitowoc County	Manitowoc County	Ozone_8-hr.2015.Manitowoc_Co	5
Northern Milwaukee/Ozaukee Shoreline, WI		WI	Marginal	Northern Milwaukee/Ozaukee Shoreline, WI	Moderate		Northern Milwaukee/Ozaukee Shoreline	Milwaukee-Racine	Ozone_8-hr.2015.Milwaukee	5
Sheboygan County, WI		WI	Marginal	Sheboygan County, WI	Moderate		Sheboygan County	Sheboygan	Ozone_8-hr.2015.Sheboygan	5
64	Total by State
2	Tribal areas in R9	Extreme	2
62	Less tribal	Severe 17	0
DOES NOT INCLUDE OTR STATES - USED Final State Summary response number		Severe 15	0
		Serious	2
		Moderate	7
		Marginal	50
		Marginal (Rural Transport)	1
			62

---

Sheet 9: 2015Areas by Class

Nonattainment Areas by Classification Options for 70 ppb NAAQS		Change Rural transpost to Marginal & bumping up some Marginal			Original classifications
Actual NA Area name	_state_name	Use in Final state summary	Area Name	State	70 ppb	Estimated 3-year Burden (hours)		Simple Area Name	Common Area Mapping ID	Region
Los Angeles-South Coast Air Basin, CA		Extreme	Los Angeles-South Coast Air Basin	CA	Extreme	20,000		Los Angeles-South Coast Air Basin	Ozone_8-hr.2015.LA-South_Coast	9
San Joaquin Valley, CA		Extreme	San Joaquin Valley	CA	Extreme	20,000		San Joaquin Valley	Ozone_8-hr.2015.San_Joaquin_Valley	9
Allegan County, MI		Marginal	Allegan County	MI	Marginal	100		Allegan County	Ozone_8-hr.2015.Allegan_Co	5
Amador County, CA		Marginal	Amador County	CA	Marginal	100		Amador and Calaveras Counties (Central Mountain Counties)	Ozone_8-hr.2015.Amador_Co	9
Atlanta, GA		Marginal	Atlanta	GA	Marginal	100		Atlanta	Ozone_8-hr.2015.Atlanta	4
Baltimore, MD		Marginal	Baltimore	MD	Marginal	100		Baltimore	Ozone_8-hr.2015.Baltimore	3
Berrien County, MI		Marginal	Berrien County	MI	Marginal	100		Benton Harbor	Ozone_8-hr.2015.Benton_Harbor	5
Butte County, CA		Marginal	Butte County	CA	Marginal	100		Chico	Ozone_8-hr.2015.Chico	9
Calaveras County, CA		Marginal	Calaveras County	CA	Marginal	100		Amador and Calaveras Counties (Central Mountain Counties)	Ozone_8-hr.2015.Calaveras_Co	9
Chicago, IL-IN-WI		Marginal	Chicago	IL	Marginal	100		Chicago-Joliet-Naperville	Ozone_8-hr.2015.Chicago	5
Chicago, IL-IN-WI		Marginal	Chicago	IN	Marginal	100		Chicago-Joliet-Naperville	Ozone_8-hr.2015.Chicago	5
Chicago, IL-IN-WI		Marginal	Chicago	WI	Marginal	100		Chicago-Joliet-Naperville	Ozone_8-hr.2015.Chicago	5
Cincinnati, OH-KY		Marginal	Cincinnati	KY	Marginal	100		Cincinnati-Middletown-Wilmington	Ozone_8-hr.2015.Cincinnati	4
Cincinnati, OH-KY		Marginal	Cincinnati	OH	Marginal	100		Cincinnati-Middletown-Wilmington	Ozone_8-hr.2015.Cincinnati	5
Cleveland, OH		Marginal	Cleveland	OH	Marginal	100		Cleveland-Akron-Elyria	Ozone_8-hr.2015.Cleveland	5
Columbus, OH		Marginal	Columbus	OH	Marginal	100		Columbus-Marion-Chillicothe	Ozone_8-hr.2015.Columbus	5
Dallas-Fort Worth, TX		Marginal	Dallas-Fort Worth	TX	Marginal	100		Dallas-Fort Worth	Ozone_8-hr.2015.Dallas	6
Denver Metro/North Front Range, CO		Marginal	Denver Metro/North Front Range	CO	Marginal	100		Denver-Boulder-Greeley-Ft. Collins-Loveland	Ozone_8-hr.2015.Denver	8
Detroit, MI		Marginal	Detroit	MI	Marginal	100		Detroit-Ann Arbor	Ozone_8-hr.2015.Detroit	5
Doña Ana County (Sunland Park Area), NM		Marginal	Doña Ana County (Sunland Park Area)	NM	Marginal	100		Sunland Park	Ozone_8-hr.2015.Sunland_Park	6
Greater Connecticut, CT		Marginal	Greater Connecticut	CT	Marginal	100		Greater Connecticut	Ozone_8-hr.2015.Connecticut	1
Houston-Galveston-Brazoria, TX		Marginal	Houston-Galveston-Brazoria	TX	Marginal	100		Houston-Sugar Land-Baytown	Ozone_8-hr.2015.Houston	6
Imperial County, CA		Marginal	Imperial County	CA	Marginal	100		Imperial County	Ozone_8-hr.2015.Imperial_Co	9
Las Vegas, NV		Marginal	Las Vegas	NV	Marginal	100		Las Vegas	Ozone_8-hr.2015.Las_Vegas	9
Louisville, KY-IN		Marginal	Louisville	IN	Marginal	100		Louisville	Ozone_8-hr.2015.Louisville	5
Louisville, KY-IN		Marginal	Louisville	KY	Marginal	100		Louisville	Ozone_8-hr.2015.Louisville	4
Manitowoc County, WI		Marginal	Manitowoc County	WI	Marginal	100		Manitowoc County	Ozone_8-hr.2015.Manitowoc_Co	5
Mariposa County, CA		Marginal	Mariposa County	CA	Marginal	100		Mariposa and Tuolumne Counties (Southern Mountain Counties)	Ozone_8-hr.2015.Mariposa_Co	9
Muskegon County, MI		Marginal	Muskegon County	MI	Marginal	100		Muskegon	Ozone_8-hr.2015.Muskegon	5
Northern Milwaukee/Ozaukee Shoreline, WI		Marginal	Northern Milwaukee/Ozaukee Shoreline	WI	Marginal	100		Milwaukee-Racine	Ozone_8-hr.2015.Milwaukee	5
Northern Wasatch Front, UT		Marginal	Northern Wasatch Front	UT	Marginal	100		Salt Lake City	Ozone_8-hr.2015.Salt_Lake	8
Pechanga Band of Luiseño Mission Indians of the Pechanga Reservation, CA		Marginal	Pechanga Band of Luiseño Mission Indians of the Pechanga Reservation	CA	Marginal	100		Los Angeles-South Coast Air Basin	Ozone_8-hr.2015.Pechanga	9
Philadelphia-Wilmington-Atlantic City, PA-NJ-MD-DE		Marginal	Philadelphia-Wilmington-Atlantic City	DE	Marginal	100		Philadelphia-Wilmington-Atlantic City	Ozone_8-hr.2015.Philadelphia	3
Philadelphia-Wilmington-Atlantic City, PA-NJ-MD-DE		Marginal	Philadelphia-Wilmington-Atlantic City	MD	Marginal	100		Philadelphia-Wilmington-Atlantic City	Ozone_8-hr.2015.Philadelphia	3
Philadelphia-Wilmington-Atlantic City, PA-NJ-MD-DE		Marginal	Philadelphia-Wilmington-Atlantic City	NJ	Marginal	100		Philadelphia-Wilmington-Atlantic City	Ozone_8-hr.2015.Philadelphia	2
Philadelphia-Wilmington-Atlantic City, PA-NJ-MD-DE		Marginal	Philadelphia-Wilmington-Atlantic City	PA	Marginal	100		Philadelphia-Wilmington-Atlantic City	Ozone_8-hr.2015.Philadelphia	3
Phoenix-Mesa, AZ		Marginal	Phoenix-Mesa	AZ	Marginal	100		Phoenix-Mesa	Ozone_8-hr.2015.Phoenix	9
San Antonio, TX		Marginal	San Antonio	TX	Marginal	100		San Antonio	Ozone_8-hr.2015.San_Antonio	6
San Francisco Bay Area, CA		Marginal	San Francisco Bay Area	CA	Marginal	100		San Francisco-Bay Area	Ozone_8-hr.2015.San_Francisco	9
San Luis Obispo (Eastern part), CA		Marginal	San Luis Obispo (Eastern part)	CA	Marginal	100		San Luis Obispo	Ozone_8-hr.2015.San_Luis_Obispo	9
Sheboygan County, WI		Marginal	Sheboygan County	WI	Marginal	100		Sheboygan	Ozone_8-hr.2015.Sheboygan	5
Southern Wasatch Front, UT		Marginal	Southern Wasatch Front	UT	Marginal	100		Provo	Ozone_8-hr.2015.Provo	8
St. Louis, MO-IL		Marginal	St. Louis	IL	Marginal	100		St. Louis	Ozone_8-hr.2015.St_Louis	5
St. Louis, MO-IL		Marginal	St. Louis	MO	Marginal	100		St. Louis	Ozone_8-hr.2015.St_Louis	7
Sutter Buttes, CA		Marginal	Sutter Buttes	CA	Marginal	100		Yuba City	Ozone_8-hr.2015.Sutter_Buttes	9
Tuolumne County, CA		Marginal	Tuolumne County	CA	Marginal	100		Mariposa and Tuolumne Counties (Southern Mountain Counties)	Ozone_8-hr.2015.Tuolumne_Co	9
Uinta Basin, UT		Marginal	Uinta Basin	UT	Marginal	100		Uinta Basin	Ozone_8-hr.2015.Uinta_Basin	8
Washington, DC-MD-VA		Marginal	Washington	DC	Marginal	100		Washington	Ozone_8-hr.2015.Washington	3
Washington, DC-MD-VA		Marginal	Washington	MD	Marginal	100		Washington	Ozone_8-hr.2015.Washington	3
Washington, DC-MD-VA		Marginal	Washington	VA	Marginal	100		Washington	Ozone_8-hr.2015.Washington	3
Yuma, AZ		Marginal	Yuma	AZ	Marginal	100		Yuma	Ozone_8-hr.2015.Yuma	9
Door County, WI		Marginal	Door County	WI	Marginal (Rural Transport)	100		Door County	Ozone_8-hr.2015.Door_Co	5
Tuscan Buttes, CA		Marginal	Tuscan Buttes	CA	Marginal (Rural Transport)	100		Tuscan Buttes	Ozone_8-hr.2015.Tuscan_Buttes	9
Kern County (Eastern Kern), CA		Moderate	Kern County (Eastern Kern)	CA	Moderate	5,000		San Joaquin Valley	Ozone_8-hr.2015.East_Kern	9
Nevada County (Western part), CA		Moderate	Nevada County (Western part)	CA	Moderate	5,000		Nevada County (Western part)	Ozone_8-hr.2015.Nevada_Co	9
New York-Northern New Jersey-Long Island, NY-NJ-CT		Moderate	New York-Northern New Jersey-Long Island	CT	Moderate	5,000		New York-N. New Jersey-Long Island	Ozone_8-hr.2015.New_York	1
New York-Northern New Jersey-Long Island, NY-NJ-CT		Moderate	New York-Northern New Jersey-Long Island	NJ	Moderate	5,000		New York-N. New Jersey-Long Island	Ozone_8-hr.2015.New_York	2
New York-Northern New Jersey-Long Island, NY-NJ-CT		Moderate	New York-Northern New Jersey-Long Island	NY	Moderate	5,000		New York-N. New Jersey-Long Island	Ozone_8-hr.2015.New_York	2
Sacramento Metro, CA		Moderate	Sacramento Metro	CA	Moderate	5,000		Sacramento Metro	Ozone_8-hr.2015.Sacramento	9
San Diego County, CA		Moderate	San Diego County	CA	Moderate	5,000		San Diego	Ozone_8-hr.2015.San_Diego	9
Morongo Band of Mission Indians, CA		Serious	Morongo Band of Mission Indians	CA	Serious			Los Angeles-South Coast Air Basin	Ozone_8-hr.2015.Morongo	9
Ventura County, CA		Serious	Ventura County	CA	Serious	20,000		Ventura County	Ozone_8-hr.2015.Ventura_Co	9
Los Angeles-San Bernardino Counties (West Mojave Desert), CA		Severe-15	Los Angeles-San Bernardino Counties (West Mojave Desert)	CA	Severe-15	20,000		Southeast Desert Modified AQMA	Ozone_8-hr.2015.LA-Desert	9
Riverside County (Coachella Valley), CA		Severe-15	Riverside County (Coachella Valley)	CA	Severe-15	20,000		Southeast Desert Modified AQMA	Ozone_8-hr.2015.Coachella_Valley	9
						140,100
64	Total by State
2	Tribal areas in R9	2		Extreme	2
62	Less tribal	0		Severe-17	0
		0		Severe-15	2
		2		Serious	2
		7		Moderate	7
		51		Marginal	51
		0		Marginal (Rural Transport)	0
		62			64

---

Sheet 10: new2008Sev15

This tab should not be used but left in case included in formulas
Count of State	State
2008 NAAQS Nonattainment Area	CA	CO	CT	IL	IN	NJ	NY	TX	WI	Total Result
Chicago-Naperville, IL-IN-WI				1	1				1	3
Dallas-Fort Worth, TX								1		1
Denver-Boulder-Greeley-Ft. Collins-Loveland, CO		1								1
Houston-Galveston-Brazoria, TX								1		1
Kern County (Eastern Kern), CA	1									1
Nevada County (Western part), CA	1									1
New York-N. New Jersey-Long Island, NY-NJ-CT			1			1	1			3
San Diego County, CA	1									1
Total Result	3	1	1	1	1	1	1	2	1	12
		8	NAAs

---

Sheet 11: 2008serious

States that might have to submit Severe SIP revisions for 2008 ozone if the areas is bumped up from Serious to Severe 15
2008 NAAQS Nonattainment Area	State	Bump up Serious to Severe for 2008 NAAQS
Chicago-Naperville, IL-IN-WI	IL	Severe-15
Chicago-Naperville, IL-IN-WI	IN	Severe-15
Chicago-Naperville, IL-IN-WI	WI	Severe-15
Denver-Boulder-Greeley-Ft. Collins-Loveland, CO	CO	Severe-15
Houston-Galveston-Brazoria, TX	TX	Severe-15
Dallas-Fort Worth, TX	TX	Severe-15
Kern County (Eastern Kern), CA	CA	Severe-15
Nevada County (Western part), CA	CA	Severe-15
New York-N. New Jersey-Long Island, NY-NJ-CT	CT	Severe-15
New York-N. New Jersey-Long Island, NY-NJ-CT	NJ	Severe-15
New York-N. New Jersey-Long Island, NY-NJ-CT	NY	Severe-15
San Diego County, CA	CA	Severe-15

---

Sheet 12: Table 6 and 7

2008 ozone maintenance areas with 2nd MPs due in ICR renewal period -- 1/2021 to 1/2024
Area Name	State	Area Name with State(s)	Redesignation Final Approval Effective Date	2nd MP due date	Pollutant
Charlotte-Rock Hill	NC	Charlotte-Rock Hill, NC-SC	8/27/2015	8/27/2023	Ozone-8Hr (2008)
Charlotte-Rock Hill	SC	Charlotte-Rock Hill, NC-SC	1/11/2016	1/11/2024	Ozone-8Hr (2008)
Knoxville	TN	Knoxville, TN	8/12/2015	8/12/2023	Ozone-8Hr (2008)
1997 ozone maintenance areas with 2nd MPs due
Area Name	State	Area Name with State(s)	Redesignation Final Approval Effective Date	2nd MP due date	Pollutant
Atlanta Area	GA	Atlanta Area, GA	1/2/2014	1/2/2022	Ozone-8Hr (1997)
Boston-Manchester-Portsmouth (SE) Area	NH	Boston-Manchester-Portsmouth (SE) Area, NH	3/4/2013	3/4/2021	Ozone-8Hr (1997)
Charlotte-Gastonia-Rock Hill Area	NC	Charlotte-Gastonia-Rock Hill Area, NC-SC	1/2/2014	1/2/2022	Ozone-8Hr (1997)
Las Vegas	NV	Las Vegas, NV	2/7/2013	2/7/2021	Ozone-8Hr (1997)
Pechanga Band of Luiseno Mission Indians of the Pechanga Reservation	R9	Pechanga Band of Luiseno Mission Indians of the Pechanga Reservation, CA	4/3/2015	4/3/2023	Ozone-8Hr (1997)
Phoenix-Mesa	AZ	Phoenix-Mesa, AZ	10/17/2014	10/17/2022	Ozone-8Hr (1997)
San Diego	CA	San Diego, CA	7/5/2013	7/5/2021	Ozone-8Hr (1997)
St. Louis Area	MO	St. Louis Area, MO-IL	2/20/2015	2/20/2023	Ozone-8Hr (1997)

---

Sheet 13: Table10

Region	Sum of STATE TOTAL HOURS			EPA Regional Office	Total State Respondents' Burden	Year 1 Agency Regional Office Burden	Year 2 Agency Regional Office Burden	Year 3 Agency Regional Office Burden
1	0			1	23,800	1,190	595	595
2	0			2	26,100	1,305	653	653
3	0			3	32,600	1,630	815	815
4	0			4	10,800	540	270	270
5	0			5	81,500	4,075	2,038	2,038
6	0			6	25,400	1,270	635	635
7	0			7	5,200	260	130	130
8	0			8	20,400	1,020	510	510
9	0			9	131,600	6,580	3,290	3,290
Total Result	0			R9 tribal areas		12,600	6,300	6,300		25,200	100% for R9 instead of 10%
				Grand Total	357,400	30,470	15,235	15,235		60,940	Check against Present Value Costs tab
					R9 has 1st years hours of the 25,200 (3 yr total) hours for 2 tribal areas in CA -- should include in EPA burden not State burden
				Regional burden is 10% of state hours plus 100% of R9 tribal hours	35,740
				If instead of 50%, 25% & 25% used 37.5%, 37.5% & 25% in years 1,2, & 3
						22,853	22,853	15,235		60,940
				Agency burden is 10% of Regional hours	3,574
				Agency burden at 50%, 25% & 25% in years 1,2, & 3
						3,047	1,524	1,524		6,094
										67,034

---

Sheet 14: Reg lookup

Abbn	State	EPA Region
AK	Alaska	10
AL	Alabama	4
AR	Arkansas	6
AZ	Arizona	9
CA	California	9
CO	Colorado	8
CT	Connecticut	1
DC	District of Columbia	3
DE	Delaware	3
FL	Florida	4
GA	Georgia	4
HI	Hawaii	9
IA	Iowa	7
ID	Idaho	10
IL	Illinois	5
IN	Indiana	5
KS	Kansas	7
KY	Kentucky	4
LA	Louisiana	6
MA	Massachusetts	1
ME	Maine	1
MD	Maryland	3
MI	Michigan	5
MN	Minnesota	5
MO	Missouri	7
MS	Mississippi	4
MT	Montana	8
NC	North Carolina	4
ND	North Dakota	8
NE	Nebraska	7
NH	New Hampshire	1
NJ	New Jersey	2
NM	New Mexico	6
NV	Nevada	9
NY	New York	2
OH	Ohio	5
OK	Oklahoma	6
OR	Oregon	10
PA	Pennsylvania	3
RI	Rhode Island	1
SC	South Carolina	4
SD	South Dakota	8
TN	Tennessee	4
TX	Texas	6
UT	Utah	8
VT	Vermont	1
VA	Virginia	3
WA	Washington	10
WI	Wisconsin	5
WV	West Virginia	3
WY	Wyoming	8

---

Sheet 15: Updated labor rates

	2009 weighted direct salary per employee							2009 weighted indirect cost per employee				2009 Estimated total weighted direct and indirect hourly equivalent salary
LOCALITY PAY AREA	GS-11 Step 3 (Staff)	GS-13 Step 3 (Mgmt)	1/11 of GS-13 Step 3	GS-6 Step 6 (Support staff)	1/8 of GS-6 Step 6	Weighted direct labor estimate total		Benefits - 16% weighted labor rate	Sick/Annual leave - 10% weighted labor rate	Overhead - 32% weighted labor rate
SAN JOSE-SAN FRANCISCO-OAKLAND, CA
WASHINGTON-BALTIMORE-NORTHERN VIRGINIA, DC-MD-VA-WV-
Average labor rates	$33.34	$47.51		$22.17
Weighted direct labor estimate parts	$33.34		$4.32		$2.77
Weighted direct labor estimate total						$40.43		$6.47	$4.04	$12.94		$63.88
									Subtotal	$23.45
			Matched if used 16% for support staff instead of 1/8 ratio
						$41.20		$6.59	$4.12	$13.18		$65.10
									Subtotal	$23.90
	2012 weighted direct salary per employee							2012 weighted indirect cost per employee				2012 Estimated total weighted direct and indirect hourly equivalent salary
LOCALITY PAY AREA	GS-11 Step 3 (Staff)	GS-13 Step 3 (Mgmt)	1/11 of GS-13 Step 3	GS-6 Step 6 (Support staff)	1/8 of GS-6 Step 6	Weighted direct labor estimate total		Benefits - 16% weighted labor rate	Sick/Annual leave - 10% weighted labor rate	Overhead - 32% weighted labor rate
SAN JOSE-SAN FRANCISCO-OAKLAND, CA	$34.74	$49.51		$23.10
WASHINGTON-BALTIMORE-NORTHERN VIRGINIA, DC-MD-VA-WV-	$31.93	$45.51		$21.23
Average labor rates	$33.34	$47.51		$22.17
Weighted direct labor estimate parts	$33.34		$4.32		$2.77
Weighted direct labor estimate total						$40.42		$6.47	$4.04	$12.94		$63.87
									Subtotal	$23.45
	2019 weighted direct salary per employee							2019 weighted indirect cost per employee				2019 Estimated total weighted direct and indirect hourly equivalent salary
LOCALITY PAY AREA	GS-11 Step 3 (Staff)	GS-13 Step 3 (Mgmt)	1/11 of GS-13 Step 3	GS-6 Step 6 (Support staff)	1/8 of GS-6 Step 6	Weighted direct labor estimate total		Benefits - 16% weighted labor rate	Sick/Annual leave - 10% weighted labor rate	Overhead - 32% weighted labor rate
SAN JOSE-SAN FRANCISCO-OAKLAND, CA	$39.91	$56.88		$26.54
WASHINGTON-BALTIMORE-NORTHERN VIRGINIA, DC-MD-VA-WV-	$36.81	$52.47		$24.48
Average labor rates	$38.36	$54.68		$25.51
Weighted direct labor estimate parts	$38.36		$4.97		$3.19
Weighted direct labor estimate total						$46.52		$7.44	$4.65	$14.89		$73.50
									Subtotal	$26.98