Record for the Proposed Section 316(b) Rule for Phase III Facilities

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

A B

Author: Abt Associates Inc.

Date Created:

Date Modified: 3/14/2011

Purpose: This file pulls together facility information such as weights, firm size, and sector revenue from various sources by facility ID.

File Contents:

Worksheet Contents

Facility Information Contains information from the technical portion of the 316(b) industry survey for facilities

In-scope Only List of in-scope facilities and their tech weight, NAICS code, and sector

Baseline Closures Summary of baseline closures by sector and weight

Facility Counts Summarizes universe of facilities by weight type (tech or econ) and DIF threshold (2 or 125 MGD)

RevBySector Cacluates total revenue by industry sector

RevByFlow&Sector Presents weighted revenue by sector and DIF threshold

NAICS-Sector Assigns sector title to each NAICS code present in facility universe

PPI Looksup PPI for each industry sector to adjust revenue from 1998 to 2007

GDP Deflator Series Contains GDP deflator for various years; used to adjust facility revenue to 2009$

Input Files:

External data used in calculations/analysis:

Steel Profile Table.xls

Petroleum Profile Tables.xls

Paper Profile Tables.xls

Chemicals Profile Tables.xls

Aluminum Profile Table.xls

Food & Bev Profile Tables.xls

dq_eco_wgts.xls

GDP_Deflator.xls

In scope NAICS_SIC map_tm.xls

Man_Facility_Impact.xls

Man_Parent_Info_Size.xls

MN_Financial_Data.xls

P3 MN NPDES.xls

P3P4 Joint Master_w MW MAF 120109.xls

PPI_1998_2010_322224xls.xls

PPI_1998_2010_325998.xls

The original version of this file contains, or is linked to a file that contains, confidential business information (CBI), or information that could be used to reveal CBI. As 

a result, the values for any variables determined by EPA to be CBI, or that could be used to reveal CBI, have been concealed. 

November 1, 2004 1 of 44 EPA-HQ-OW-2008-0667-DRAFT-1540.xls - File Info
Record for the Proposed Section 316(b) Rule for Phase III Facilities

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

A B C D E F G H I

Existing Facilities Rule Manufacturers Facility Information

1 2 3 4 5 6 7 8 9

2 8

SURVEY STATUS

Survey ID 

(Westat/SAIC) Survey ID (Abt) Facility Name Status

Baseline 

Closure 

(1=yes, 

0=no)

Incomplete 

Survey (1=yes, 

0=no)

Econ Data 

Weight

Tech Data 

Weight

Benefits 

Weight

November 1, 2004 2 of 44 EPA-HQ-OW-2008-0667-DRAFT-1540.xls - Facility Information
Record for the Proposed Section 316(b) Rule for Phase III Facilities

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

J K L M N O P Q R S T U V

10 11 12 13 14 15 16 17 18 19 20 21 22

23 14 2 5 28 29 3 8 12

FACILITY INFORMATION

SIC Code NAICS Code Sector

Facility 

Employment Waterbody Type

Freshwater/M

arine CWS Type CCRS Type

Recirculating 

System? State Region

FWS Region 

(Inland Only)

Design Intake 

Capacity - Facility 

Level (MGD)

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

OCEAN M

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

ESTUARY/TIDAL RIVER M

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

LAKE/RESERVOIR FW

LAKE/RESERVOIR FW

FRESHWATER STREAM/RIVER FW

LAKE/RESERVOIR FW

FRESHWATER STREAM/RIVER FW

ESTUARY/TIDAL RIVER M

FRESHWATER STREAM/RIVER FW

LAKE/RESERVOIR FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

November 1, 2004 3 of 44 EPA-HQ-OW-2008-0667-DRAFT-1540.xls - Facility Information
Record for the Proposed Section 316(b) Rule for Phase III Facilities

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

W X Y Z AA AB AC AD AE AF

23 24 25 26 27 28 29 30 31 32

14 7 183 186 184 24 21 25

Daily Average 

Flow- Facility 

Level (MGD)

Exceeds 5% 

Mean Annual 

Flow

Generate 

Electricity 

(1=Yes, 2=No)

Use CW in 

Generation 

(1=Yes, 2=No) EIA Code Capacity (MW)

Generation 

(KWh)

Capacity 

Utilization

Generation per 

unit flow 

(MWh/MGD) NPDES ID

November 1, 2004 4 of 44 EPA-HQ-OW-2008-0667-DRAFT-1540.xls - Facility Information
Record for the Proposed Section 316(b) Rule for Phase III Facilities

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

AH AI AJ AK AL AM AN AO AP

34 35 36 37 38 39 40 41 42

9 12 25 updated

IN SCOPE STATUS

2009 (Phase V) Final Parent Name

NAICS 

Code Sector Size < 2 MGD

CW < 25% 

of Average 

Flow

In Scope 

Status Reason Out of Scope

Facility 

Employment 

Range

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

November 1, 2004 5 of 44 EPA-HQ-OW-2008-0667-DRAFT-1540.xls - Facility Information
Record for the Proposed Section 316(b) Rule for Phase III Facilities

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

AQ AR AS AT AU AV AW AX AY AZ BA BB BC BD

43 44 45 46 47 48 Billion gallons per year 52 54

2 Primary Manufacturing Industries #REF!

Other Industries #REF!

Revenue 

(1998$)

NAICS level of 

PPI data

Revenue (as of 

2007 in 2009$)

Weighted 

Revenue (as of 

2007 in 2009$)

Waterbody 

Type (for 

Options)

Flow Category 

1 (for Options)

Flow Category 

2 (for Options) Weighted AIF

Weighted 

DIF

316(b) 

Baseline 

Closure

Weighted 

316(b) 

Baseline 

Closure

6

6

6

4

4

6

6

6

6

5

6

4

6

6

4

4

5

4

6

4

6

5

6

6

6

6

6

6

6

5

5

6

4

6

5

4

5

6

4

6

5

6

6

5

6

6

4

6

November 1, 2004 6 of 44 EPA-HQ-OW-2008-0667-DRAFT-1540.xls - Facility Information
Record for the Proposed Section 316(b) Rule for Phase III Facilities

4

5

6

A B C D E F G H I

SURVEY STATUS

Survey ID 

(Westat/SAIC) Survey ID (Abt) Facility Name Status

Baseline 

Closure 

(1=yes, 

0=no)

Incomplete 

Survey (1=yes, 

0=no)

Econ Data 

Weight

Tech Data 

Weight

Benefits 

Weight

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

80

81

82

83

84

85

86

87

88

89

90

91

92

93

94

95

96

97

98

99

100

101

102

103

104

105

November 1, 2004 7 of 44 EPA-HQ-OW-2008-0667-DRAFT-1540.xls - Facility Information
Record for the Proposed Section 316(b) Rule for Phase III Facilities

4

5

6

J K L M N O P Q R S T U V

FACILITY INFORMATION

SIC Code NAICS Code Sector

Facility 

Employment Waterbody Type

Freshwater/M

arine CWS Type CCRS Type

Recirculating 

System? State Region

FWS Region 

(Inland Only)

Design Intake 

Capacity - Facility 

Level (MGD)

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

80

81

82

83

84

85

86

87

88

89

90

91

92

93

94

95

96

97

98

99

100

101

102

103

104

105

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

GREAT LAKE M

GREAT LAKE M

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

ESTUARY/TIDAL RIVER M

LAKE/RESERVOIR FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

ESTUARY/TIDAL RIVER M

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

LAKE/RESERVOIR FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

ESTUARY/TIDAL RIVER M

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

GREAT LAKE M

FRESHWATER STREAM/RIVER FW

GREAT LAKE M

OCEAN M

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

GREAT LAKE M

LAKE/RESERVOIR FW

LAKE/RESERVOIR FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

ESTUARY/TIDAL RIVER M

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

LAKE/RESERVOIR FW

November 1, 2004 8 of 44 EPA-HQ-OW-2008-0667-DRAFT-1540.xls - Facility Information
Record for the Proposed Section 316(b) Rule for Phase III Facilities

4

5

6

W X Y Z AA AB AC AD AE AF

Daily Average 

Flow- Facility 

Level (MGD)

Exceeds 5% 

Mean Annual 

Flow

Generate 

Electricity 

(1=Yes, 2=No)

Use CW in 

Generation 

(1=Yes, 2=No) EIA Code Capacity (MW)

Generation 

(KWh)

Capacity 

Utilization

Generation per 

unit flow 

(MWh/MGD) NPDES ID

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

80

81

82

83

84

85

86

87

88

89

90

91

92

93

94

95

96

97

98

99

100

101

102

103

104

105

November 1, 2004 9 of 44 EPA-HQ-OW-2008-0667-DRAFT-1540.xls - Facility Information
Record for the Proposed Section 316(b) Rule for Phase III Facilities

4

5

6

AH AI AJ AK AL AM AN AO AP

IN SCOPE STATUS

2009 (Phase V) Final Parent Name

NAICS 

Code Sector Size < 2 MGD

CW < 25% 

of Average 

Flow

In Scope 

Status Reason Out of Scope

Facility 

Employment 

Range

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

80

81

82

83

84

85

86

87

88

89

90

91

92

93

94

95

96

97

98

99

100

101

102

103

104

105

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

November 1, 2004 10 of 44 EPA-HQ-OW-2008-0667-DRAFT-1540.xls - Facility Information
Record for the Proposed Section 316(b) Rule for Phase III Facilities

4

5

6

AQ AR AS AT AU AV AW AX AY AZ BA BB BC BD

Other Industries #REF!

Revenue 

(1998$)

NAICS level of 

PPI data

Revenue (as of 

2007 in 2009$)

Weighted 

Revenue (as of 

2007 in 2009$)

Waterbody 

Type (for 

Options)

Flow Category 

1 (for Options)

Flow Category 

2 (for Options) Weighted AIF

Weighted 

DIF

316(b) 

Baseline 

Closure

Weighted 

316(b) 

Baseline 

Closure

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

80

81

82

83

84

85

86

87

88

89

90

91

92

93

94

95

96

97

98

99

100

101

102

103

104

105

4

5

6

4

6

4

6

6

6

5

4

5

5

6

4

6

6

6

6

6

5

5

6

5

4

5

6

4

6

5

6

6

5

4

4

6

6

6

4

5

6

6

5

4

6

6

4

6

4

4

6

6

November 1, 2004 11 of 44 EPA-HQ-OW-2008-0667-DRAFT-1540.xls - Facility Information
Record for the Proposed Section 316(b) Rule for Phase III Facilities

4

5

6

A B C D E F G H I

SURVEY STATUS

Survey ID 

(Westat/SAIC) Survey ID (Abt) Facility Name Status

Baseline 

Closure 

(1=yes, 

0=no)

Incomplete 

Survey (1=yes, 

0=no)

Econ Data 

Weight

Tech Data 

Weight

Benefits 

Weight

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

November 1, 2004 12 of 44 EPA-HQ-OW-2008-0667-DRAFT-1540.xls - Facility Information
Record for the Proposed Section 316(b) Rule for Phase III Facilities

4

5

6

J K L M N O P Q R S T U V

FACILITY INFORMATION

SIC Code NAICS Code Sector

Facility 

Employment Waterbody Type

Freshwater/M

arine CWS Type CCRS Type

Recirculating 

System? State Region

FWS Region 

(Inland Only)

Design Intake 

Capacity - Facility 

Level (MGD)

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

GREAT LAKE M

FRESHWATER STREAM/RIVER FW

ESTUARY/TIDAL RIVER M

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

ESTUARY/TIDAL RIVER M

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

OCEAN M

FRESHWATER STREAM/RIVER FW

GREAT LAKE M

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

GREAT LAKE M

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

ESTUARY/TIDAL RIVER M

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

ESTUARY/TIDAL RIVER M

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

GREAT LAKE M

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

LAKE/RESERVOIR FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

November 1, 2004 13 of 44 EPA-HQ-OW-2008-0667-DRAFT-1540.xls - Facility Information
Record for the Proposed Section 316(b) Rule for Phase III Facilities

4

5

6

W X Y Z AA AB AC AD AE AF

Daily Average 

Flow- Facility 

Level (MGD)

Exceeds 5% 

Mean Annual 

Flow

Generate 

Electricity 

(1=Yes, 2=No)

Use CW in 

Generation 

(1=Yes, 2=No) EIA Code Capacity (MW)

Generation 

(KWh)

Capacity 

Utilization

Generation per 

unit flow 

(MWh/MGD) NPDES ID

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

November 1, 2004 14 of 44 EPA-HQ-OW-2008-0667-DRAFT-1540.xls - Facility Information
Record for the Proposed Section 316(b) Rule for Phase III Facilities

4

5

6

AH AI AJ AK AL AM AN AO AP

IN SCOPE STATUS

2009 (Phase V) Final Parent Name

NAICS 

Code Sector Size < 2 MGD

CW < 25% 

of Average 

Flow

In Scope 

Status Reason Out of Scope

Facility 

Employment 

Range

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

November 1, 2004 15 of 44 EPA-HQ-OW-2008-0667-DRAFT-1540.xls - Facility Information
Record for the Proposed Section 316(b) Rule for Phase III Facilities

4

5

6

AQ AR AS AT AU AV AW AX AY AZ BA BB BC BD

Other Industries #REF!

Revenue 

(1998$)

NAICS level of 

PPI data

Revenue (as of 

2007 in 2009$)

Weighted 

Revenue (as of 

2007 in 2009$)

Waterbody 

Type (for 

Options)

Flow Category 

1 (for Options)

Flow Category 

2 (for Options) Weighted AIF

Weighted 

DIF

316(b) 

Baseline 

Closure

Weighted 

316(b) 

Baseline 

Closure

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

6

4

6

6

6

6

4

6

6

4

6

4

5

5

5

4

6

4

4

6

6

5

5

6

4

5

6

6

5

6

6

6

5

6

6

4

6

6

6

5

5

6

6

6

6

5

6

5

6

6

5

4

November 1, 2004 16 of 44 EPA-HQ-OW-2008-0667-DRAFT-1540.xls - Facility Information
Record for the Proposed Section 316(b) Rule for Phase III Facilities

4

5

6

A B C D E F G H I

SURVEY STATUS

Survey ID 

(Westat/SAIC) Survey ID (Abt) Facility Name Status

Baseline 

Closure 

(1=yes, 

0=no)

Incomplete 

Survey (1=yes, 

0=no)

Econ Data 

Weight

Tech Data 

Weight

Benefits 

Weight

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

November 1, 2004 17 of 44 EPA-HQ-OW-2008-0667-DRAFT-1540.xls - Facility Information
Record for the Proposed Section 316(b) Rule for Phase III Facilities

4

5

6

J K L M N O P Q R S T U V

FACILITY INFORMATION

SIC Code NAICS Code Sector

Facility 

Employment Waterbody Type

Freshwater/M

arine CWS Type CCRS Type

Recirculating 

System? State Region

FWS Region 

(Inland Only)

Design Intake 

Capacity - Facility 

Level (MGD)

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

FRESHWATER STREAM/RIVER FW

LAKE/RESERVOIR FW

GREAT LAKE M

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

GREAT LAKE M

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

LAKE/RESERVOIR FW

GREAT LAKE M

FRESHWATER STREAM/RIVER FW

LAKE/RESERVOIR FW

LAKE/RESERVOIR FW

LAKE/RESERVOIR FW

ESTUARY/TIDAL RIVER M

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

ESTUARY/TIDAL RIVER M

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

ESTUARY/TIDAL RIVER M

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

GREAT LAKE M

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

LAKE/RESERVOIR FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

GREAT LAKE M

FRESHWATER STREAM/RIVER FW

ESTUARY/TIDAL RIVER M

FRESHWATER STREAM/RIVER FW

ESTUARY/TIDAL RIVER M

FRESHWATER STREAM/RIVER FW

ESTUARY/TIDAL RIVER M

FRESHWATER STREAM/RIVER FW

ESTUARY/TIDAL RIVER M

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

November 1, 2004 18 of 44 EPA-HQ-OW-2008-0667-DRAFT-1540.xls - Facility Information
Record for the Proposed Section 316(b) Rule for Phase III Facilities

4

5

6

W X Y Z AA AB AC AD AE AF

Daily Average 

Flow- Facility 

Level (MGD)

Exceeds 5% 

Mean Annual 

Flow

Generate 

Electricity 

(1=Yes, 2=No)

Use CW in 

Generation 

(1=Yes, 2=No) EIA Code Capacity (MW)

Generation 

(KWh)

Capacity 

Utilization

Generation per 

unit flow 

(MWh/MGD) NPDES ID

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

November 1, 2004 19 of 44 EPA-HQ-OW-2008-0667-DRAFT-1540.xls - Facility Information
Record for the Proposed Section 316(b) Rule for Phase III Facilities

4

5

6

AH AI AJ AK AL AM AN AO AP

IN SCOPE STATUS

2009 (Phase V) Final Parent Name

NAICS 

Code Sector Size < 2 MGD

CW < 25% 

of Average 

Flow

In Scope 

Status Reason Out of Scope

Facility 

Employment 

Range

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

November 1, 2004 20 of 44 EPA-HQ-OW-2008-0667-DRAFT-1540.xls - Facility Information
Record for the Proposed Section 316(b) Rule for Phase III Facilities

4

5

6

AQ AR AS AT AU AV AW AX AY AZ BA BB BC BD

Other Industries #REF!

Revenue 

(1998$)

NAICS level of 

PPI data

Revenue (as of 

2007 in 2009$)

Weighted 

Revenue (as of 

2007 in 2009$)

Waterbody 

Type (for 

Options)

Flow Category 

1 (for Options)

Flow Category 

2 (for Options) Weighted AIF

Weighted 

DIF

316(b) 

Baseline 

Closure

Weighted 

316(b) 

Baseline 

Closure

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

5

6

6

5

6

6

6

5

6

6

5

5

5

6

5

6

5

6

5

5

6

6

5

5

6

4

5

6

6

4

6

6

6

6

4

5

5

5

4

5

5

6

4

6

6

4

4

3

3

3

November 1, 2004 21 of 44 EPA-HQ-OW-2008-0667-DRAFT-1540.xls - Facility Information
Record for the Proposed Section 316(b) Rule for Phase III Facilities

4

5

6

A B C D E F G H I

SURVEY STATUS

Survey ID 

(Westat/SAIC) Survey ID (Abt) Facility Name Status

Baseline 

Closure 

(1=yes, 

0=no)

Incomplete 

Survey (1=yes, 

0=no)

Econ Data 

Weight

Tech Data 

Weight

Benefits 

Weight

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247 facility has split intakes

November 1, 2004 22 of 44 EPA-HQ-OW-2008-0667-DRAFT-1540.xls - Facility Information
Record for the Proposed Section 316(b) Rule for Phase III Facilities

4

5

6

J K L M N O P Q R S T U V

FACILITY INFORMATION

SIC Code NAICS Code Sector

Facility 

Employment Waterbody Type

Freshwater/M

arine CWS Type CCRS Type

Recirculating 

System? State Region

FWS Region 

(Inland Only)

Design Intake 

Capacity - Facility 

Level (MGD)

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

ESTUARY/TIDAL RIVER M

FRESHWATER STREAM/RIVER FW

GREAT LAKE M

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

GREAT LAKE M

GREAT LAKE M

ESTUARY/TIDAL RIVER M

LAKE/RESERVOIR FW

FRESHWATER STREAM/RIVER FW

OCEAN M

ESTUARY/TIDAL RIVER M

FRESHWATER STREAM/RIVER FW

GREAT LAKE M

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

FRESHWATER STREAM/RIVER FW

November 1, 2004 23 of 44 EPA-HQ-OW-2008-0667-DRAFT-1540.xls - Facility Information
Record for the Proposed Section 316(b) Rule for Phase III Facilities

4

5

6

W X Y Z AA AB AC AD AE AF

Daily Average 

Flow- Facility 

Level (MGD)

Exceeds 5% 

Mean Annual 

Flow

Generate 

Electricity 

(1=Yes, 2=No)

Use CW in 

Generation 

(1=Yes, 2=No) EIA Code Capacity (MW)

Generation 

(KWh)

Capacity 

Utilization

Generation per 

unit flow 

(MWh/MGD) NPDES ID

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

November 1, 2004 24 of 44 EPA-HQ-OW-2008-0667-DRAFT-1540.xls - Facility Information
Record for the Proposed Section 316(b) Rule for Phase III Facilities

4

5

6

AH AI AJ AK AL AM AN AO AP

IN SCOPE STATUS

2009 (Phase V) Final Parent Name

NAICS 

Code Sector Size < 2 MGD

CW < 25% 

of Average 

Flow

In Scope 

Status Reason Out of Scope

Facility 

Employment 

Range

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

In Scope

November 1, 2004 25 of 44 EPA-HQ-OW-2008-0667-DRAFT-1540.xls - Facility Information
Record for the Proposed Section 316(b) Rule for Phase III Facilities

4

5

6

AQ AR AS AT AU AV AW AX AY AZ BA BB BC BD

Other Industries #REF!

Revenue 

(1998$)

NAICS level of 

PPI data

Revenue (as of 

2007 in 2009$)

Weighted 

Revenue (as of 

2007 in 2009$)

Waterbody 

Type (for 

Options)

Flow Category 

1 (for Options)

Flow Category 

2 (for Options) Weighted AIF

Weighted 

DIF

316(b) 

Baseline 

Closure

Weighted 

316(b) 

Baseline 

Closure

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

3

3

3

3

3

3

3

4

6

6

6

6

6

6

6

6

6

6

4

5

6

6

5

4

6

4

6

4

6

6

4

5

November 1, 2004 26 of 44 EPA-HQ-OW-2008-0667-DRAFT-1540.xls - Facility Information
3

8 11 12

Survey ID Name Tech Weight NAICS Sector
3

8 11 12

Survey ID Name Tech Weight NAICS Sector
3

8 11 12

Survey ID Name Tech Weight NAICS Sector
3

8 11 12

Survey ID Name Tech Weight NAICS Sector
Unweighted Weighted Tech Weighted

Sector Universe

Baseline 

Closures

Percent 

Baseline 

Closures

Operating In 

Baseline Universe

Baseline 

Closures

Percent 

Baseline 

Closures

Operating In 

Baseline Universe

Baseline 

Closures

Percent 

Baseline 

Closures

Operatin

g In 

Baseline

Paper 94 12 13% 82 230 32 14% 198 225 0 0% 225

Chemicals 49 1 2% 48 171 4 3% 167 179 0 0% 179

Petroleum 29 5 17% 24 36 5 15% 30 39 0 0% 39

Steel 29 8 28% 21 68 22 32% 46 68 0 0% 68

Aluminum 9 1 11% 8 27 3 12% 24 26 0 0% 26

Food 12 2 17% 10 37 7 18% 31 37 0 0% 37

Primary Manufacturing 

Industries 222 29 13% 193 569 73 13% 496 575 0 0% 575

Other 13 3 23% 10 10 3 30% 7 17.12657 0 0% 17.12657

Total 235 32 14% 203 579 76 13% 503 592 0 0% 592
Technical Analysis Facilities Meeting or Exceeding DIF Thresholds

Facilities Baseline Closures Facilities Passing Baseline Closure Test

Unweighted Weighted Unweighted Weighted Unweighted Weighted

2 234 592 32 73 203 518

125 40 64 6 7 34 57

Economic Analysis Facilities Meeting or Exceeding DIF Thresholds

Facilities Baseline Closures Facilities Passing Baseline Closure Test

Unweighted Weighted Unweighted Weighted Unweighted Weighted

2 220 579 32 76 188 503

125 37 63 6 7 31 55

Threshold

Threshold
12 22 45

7

Survey ID Sector DIF

Revenue (2007, in 

2008$) Econ. Weight

 Weighted Rev. 

(2007, in 2008$) 
Millions, 2008$

Sector All DIF > 10 MGD

Food $ 16,438 $ 11,603

Paper $ 70,142 $ 61,128

Chemicals $ 74,823 $ 68,442

Petroleum $ 216,321 $ 174,378

Steel $ 62,508 $ 55,241

Aluminum $ 22,254 $ 16,792

Primary Manufacturing $ 462,485 $ 387,584

Other* $ 3,163 $ -

Total $ 465,648 $ 387,584

* Values were not adjusted to 2007 using PPI, as these facilities are outside of 

the primary manufacturing industries
12 22 45

7

Survey ID Sector DIF

Revenue (2007, in 

2008$) Econ. Weight

 Weighted Rev. 

(2007, in 2008$) 

12 22 45

7

Survey ID Sector DIF

Revenue (2007, in 

2008$) Econ. Weight

 Weighted Rev. 

(2007, in 2008$) 

12 22 45

7

Survey ID Sector DIF

Revenue (2007, in 

2008$) Econ. Weight

 Weighted Rev. 

(2007, in 2008$) 

316(b) Baseline Closure (All)

Sum of Weighted RevenueFlow Category 2 (for Options)

Sector 2-10 MGD 10-20 MGD 20-50 MGD 50+ MGD Grand Total

Food $2,095,799,757 $2,233,288,830 $4,837,340,789 $5,583,072,314 $14,749,501,690

Paper $9,217,758,553 $8,688,411,584 $29,815,216,889 $21,408,564,148 $69,129,951,173

Petroleum $12,008,563,972 $4,894,463,490 $16,531,901,438 $28,500,904,114 $61,935,833,013

Chemicals $6,205,388,449 $13,205,907,159 $24,478,932,069 $33,906,476,760 $77,796,704,437

Steel $5,717,029,692 $7,777,597,505 $35,806,543,291 $49,301,170,488

Aluminum $5,041,703,866 $3,574,840,536 $824,502,214 $5,900,066,136 $15,341,112,752

Other $639,560,613 $21,896,360 $47,607,445 $2,414,548,235 $3,123,612,654

Grand Total $40,925,804,901 $32,618,807,959 $84,313,098,349 $133,520,174,998 $291,377,886,208

MGD Threshold for Regulation under 316(b) Phase V

2 10 20 50 2007 Sector VOS 10+ % VOS

Food $14,750 $12,654 $10,420 $5,583 $688,885 2% 1%

Paper $69,130 $59,912 $51,224 $21,409 $179,751 33% 29%

Petroleum $61,936 $49,927 $45,033 $28,501 $618,856 8% 7%

Chemicals $77,797 $71,591 $58,385 $33,906 $739,791 10% 10%

Steel $49,301 $43,584 $43,584 $35,807 $126,561 34% 23%

Aluminum $15,341 $10,299 $6,725 $5,900 $44,973 23% 19%

Other $3,124 $2,484 $2,462 $2,415

Total $291,378 $250,452 $217,833 $133,520

Sector
1 2

NAICS 

Code Sector

111991 Other

212210 Other

212391 Other

311211 Food

311221 Food

311312 Food

311313 Food

312140 Food

313311 Other

321113 Other

322110 Paper

322121 Paper

322121 Paper

322122 Paper

322130 Paper

322222 Paper

322224 Paper

322299 Paper

324110 Petroleum

325110 Chemicals

325120 Chemicals

325131 Chemicals

325181 Chemicals

325188 Chemicals

325199 Chemicals

325211 Chemicals

325221 Chemicals

325222 Chemicals

325311 Chemicals

325312 Chemicals

325412 Chemicals

325611 Chemicals

325998 Chemicals

331111 Steel

331112 Steel

331210 Steel

331221 Steel

331222 Steel

331311 Aluminum

331312 Aluminum

331314 Aluminum

331315 Aluminum

331419 Other

332211 Other

336412 Other

339115 Other

332999 Other

325411 Chemicals
1 2 3 4 5 6

NAICS Sector Column 1998 2007 % Change

322110 Paper 2 125.1 163.1 30.4%

32212 Paper 4 144.5 170.8 18.2%

322130 Paper 6 165.1 224.4 35.9%

331312 Aluminum 2 112.4 192 70.8%

331315 Aluminum 4 145.4 187 28.6%

3251 Chemicals 2 153.0 165.7 8.4%

3252 Chemicals 4 119.5 172.5 44.3%

3253 Chemicals 6 136.1 268.0 96.9%

3254 Chemicals 8 213.2 276.5 29.7%

311 Food 2 126.3 158.6 25.6%

3121 Food 4 127.2 155.2 22.0%

324110 Petroleum 2 62.3 266.9 328.4%

331111 Steel 10 111.3 172 54.5%

331112 Steel 11 170.2 265.8 56.2%

331221 Steel 12 114.5 171.7 50.0%

331222 Steel 13 125.3 169.8 35.5%

331210 Steel 14 132.7 240.1 80.9%

2 12

322222 Paper ** 135.5 173.8 28.3%

322224 Paper Annual 107.3 137.0 27.7%

322299 Paper ** 135.5 173.8 28.3%

325998 Chemicals Annual 134.7 201.4 49.5%

331311 Aluminum ** 128.9 189.5 47.0%

331314 Aluminum ** 128.9 189.5 47.0%

** No data available prior to 2003 from BLS. Used averages from 

other analyzed NAICS classifications in the same sector
Record for the Proposed Section 316(b) Rule for Phase III Facilities

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

A B

Year Value

1995 1.346

1996 1.321

1997 1.298

1998 1.284

1999 1.265

2000 1.238

2001 1.211

2002 1.192

2003 1.167

2004 1.134

2005 1.098

2006 1.063

2007 1.033

2008 1.012

GDP Adjustments to 2009

November 1, 2004 44 of 44 EPA-HQ-OW-2008-0667-DRAFT-1540.xls - GDP Deflator Series