**SP_Survey_Benefits_Inputs_05.13.13.xls**

Author: Abt Associates Inc. Created: 05/15/13

**Worksheet Description**  State_AIF_Frac Presents the distribution of regional AIF across states. State_List Presents a crosswalk matching states to SP survey regions. HH_Survey

_Reg Presents the total number of households in each SP survey region.

HH_State Presents state-level household data from Census 2010 used for calculations. Rule_Changes Input sheet for percentage changes in commercial fish, fish population, and aquatic ecosystem condition attributes. All are set to zero because EPA did not estimate WTP for changes in these attributes under the final rule and options considered. Implicit_Prices Input sheet for implicit prices for fish saved. Includes placeholders for implicit prices for unweighted linear and weighted quadratic models. These are set to zero because EPA's analysis of WTP for the final rule and options considered was limited to the weighted linear model. Purpose: This in an input file for the 316(b) Stated Preference (SP) Survey Benefits Model. Key inputs include implicit prices for the fish saved attribute and household counts.**State Region** **AI F**  **Frac_A IF** 

CA CAL 525,277,722.8 0.3157 HI CAL 1,138,658,433.3 0.6843 IL GL 800,620,000.0 0.0598 IN GL 1,814,834,157.0 0.1356 MI GL 6,505,069,500.0 0.4859 MN GL 126,333,333.3 0.0094 NY GL 121,076,701.4 0.0090 OH GL 876,404,222.2 0.0655 PA GL 0.0 0.0000 WI GL 3,142,759,666.7 0.2348 AK INL 35,470,000.0 0.0003 AL INL 8,046,724,328.0 0.0650 AR INL 2,132,446,543.0 0.0172 AZ INL 290,530,000.0 0.0023 CA INL 1,200,000.0 0.0000 CO INL 114,286,378.1 0.0009 CT INL 194,046,666.7 0.0016 DC INL 0.0 0.0000 DE INL 33,000,000.0 0.0003 FL INL 582,703,435.9 0.0047 GA INL 3,124,198,700.0 0.0252 IA INL 2,347,340,493.0 0.0190 IL INL 9,106,363,354.0 0.0735 IN INL 6,324,500,144.3 0.0511 KS INL 2,159,048,453.3 0.0174 KY INL 3,008,140,763.3 0.0243 LA INL 6,855,345,487.5 0.0553 MA INL 138,598,600.0 0.0011 MD INL 388,412,382.0 0.0031 ME INL 110,541,238.1 0.0009 MI INL 2,215,641,836.0 0.0179 MN INL 2,151,422,847.0 0.0174 MO INL 6,255,161,834.7 0.0505 MS INL 818,581,352.7 0.0066 MT INL 176,798,666.7 0.0014 NC INL 7,961,451,559.3 0.0643 ND INL 903,598,676.0 0.0073 NE INL 3,015,303,333.3 0.0243 NH INL 227,504,830.3 0.0018 NJ INL 44,654,000.3 0.0004 NM INL 46,563,325.0 0.0004 NV INL 0.0 0.0000 NY INL 670,926,137.2 0.0054 OH INL 4,846,862,307.9 0.0391 OK INL 1,890,128,195.8 0.0153 OR INL 48,999,629.8 0.0004 PA INL 4,847,021,658.6 0.0391 SC INL 6,014,451,297.3 0.0486 SD INL 2,960,354.7 0.0000 TN INL 7,613,628,215.0 0.0615 TX INL 22,563,560,408.5 0.1822 UT INL 39,359,227.3 0.0003 VA INL 1,607,753,829.8 0.0130 VT INL 323,466,666.7 0.0026WA INL 166,811,500.9 0.0013

WI INL 1,554,439,206.3 0.0125 WV INL 2,646,499,162.1 0.0214 WY INL 223,110,731.4 0.0018 DE MA 1,430,625,000.0 0.0834 MD MA 6,766,151,948.9 0.3942 NJ MA 4,719,584,409.0 0.2750 NY MA 416,149,190.4 0.0242 PA MA 48,412,000.0 0.0028 VA MA 3,782,235,917.7 0.2204 FL Mex 5,976,100,253.3 0.5636 LA Mex 902,465,887.8 0.0851 MS Mex 302,570,000.0 0.0285 TX Mex 3,422,522,478.7 0.3228 VI Mex 0.0 0.0000 CT NA 1,957,331,020.0 0.3302 MA NA 2,578,369,333.3 0.4349 ME NA 207,868,333.3 0.0351 NH NA 909,388,333.0 0.1534 RI NA 275,355,333.3 0.0464 WA PNW 0.0 0.0000 FL SA 3,896,006,559.3 0.6541 GA SA 40,849,116.7 0.0069 NC SA 1,426,889,633.0 0.2395 SC SA 592,852,500.0 0.0995**State SP_Survey_Region** 

AK Inland AL Southeast AR Inland AZ Inland CA Pacific CO Inland CT Northeast DC Northeast DE Northeast FL Southeast GA Southeast HI Pacific IA Inland IL Inland IN Inland KS Inland KY Inland LA Southeast MA Northeast MD Northeast ME Northeast MI Inland MN Inland MO Inland MS Southeast MT Inland NC Southeast ND Inland NE Inland NH Northeast NJ Northeast NM Inland NV Inland NY Northeast OH Inland OK Inland OR Pacific PA Northeast RI Northeast SC Southeast SD Inland TN Inland TX Southeast UT Inland VA Southeast VI Inland VT Northeast WA Pacific WI Inland WV Inland WY Inland**SP_survey_region Num_Households** 

Northeast 23,980,830 Southeast 33,259,632 Inland 42,045,922 Pacific 16,716,512 National 116,002,896

### 2

**State Total Households**  **SP Region Data Source:**  Alabama 1883791 Southeast U.S. Census Bureau, 2010 Census. Alaska

- - Summary File 1, Tables P17, P18, P28, P29, P37, P38, and P39. Arizona 2380990 Inland Arkansas 1147084 Inland 

### Accessed on: California 12577498 Pacific 8/8/2012 Colorado 1972868 Inland Connecticut 1371087 Northeast Delaware 342297 Northeast District of Columbia 266707 Northeast Florida 7420802 Southeast Georgia 3585584 Southeast Hawaii

- - Idaho 579408 Inland Illinois 4836972 Inland Indiana 2502154 Inland Iowa 1221576 Inland Kansas 1112096 Inland Kentucky 1719965 Inland Louisiana 1728360 Southeast Maine 557219 Northeast Maryland 2156411 Northeast Massachusetts 2547075 Northeast Michigan 3872508 Inland Minnesota 2087227 Inland Mississippi 1115768 Southeast Missouri 2375611 Inland Montana 409607 Inland Nebraska 721130 Inland Nevada 1006250 Inland New Hampshire 518973 Northeast New Jersey 3214360 Northeast New Mexico 791395 Inland New York 7317755 Northeast North Carolina 3745155 Southeast North Dakota 281192 Inland Ohio 4603435 Inland Oklahoma 1460450 Inland Oregon 1518938 Pacific Pennsylvania 5018904 Northeast Rhode Island 413600 Northeast South Carolina 1801181 Southeast South Dakota 322282 Inland Tennessee 2493552 Inland Texas 8922933 Southeast Utah 877692 Inland Vermont 256442 Northeast Virginia 3056058 Southeast Washington 2620076 Pacific West Virginia 763831 Inland Wisconsin 2279768 Inland Wyoming 226879 Inland Puerto Rico

- -U.S. Census Bureau, 2010 Census. Summary

File 1, Tables P17, P18, P28, P29, P37, P38, and P39.**SP_survey_region option_name**  **per_com_fish per_fish_pop**  **per_aquatic**

Northeast option.tmn1 0 0 0 Southeast option.tmn1 0 0 0 Inland option.tmn1 0 0 0 Pacific option.tmn1 0 0 0 National option.tmn1 0 0 0 Northeast option.tmn2 0 0 0 Southeast option.tmn2 0 0 0 Inland option.tmn2 0 0 0 Pacific option.tmn2 0 0 0 National option.tmn2 0 0 0 Northeast option.tmn3 0 0 0 Southeast option.tmn3 0 0 0 Inland option.tmn3 0 0 0 Pacific option.tmn3 0 0 0 National option.tmn3 0 0 0 Northeast baseline 0 0 0 Southeast baseline 0 0 0 Inland baseline 0 0 0 Pacific baseline 0 0 0 National baseline 0 0 0**SP_survey_region Value**  **Model IP_fish_sav**  **IP_fish_sav_sq fish_sav_sig** 

Northeast mean linear 0.000 0.000yes Southeast mean linear 0.000 0.000yes Inland mean linear 0.000 0.000yes Pacific mean linear 0.000 0.000yes National mean linear 0.000 0.000yes Northeast low linear 0.000 0.000yes Southeast low linear 0.000 0.000yes Inland low linear 0.000 0.000yes Pacific low linear 0.000 0.000yes National low linear 0.000 0.000yes Northeast high linear 0.000 0.000yes Southeast high linear 0.000 0.000yes Inland high linear 0.000 0.000yes Pacific high linear 0.000 0.000yes National high linear 0.000 0.000yes Northeast mean weighted_linear 1.437 0.000yes Southeast mean weighted_linear 0.625 0.000yes Inland mean weighted_linear 0.495 0.000yes Pacific mean weighted_linear 1.771 0.000yes National mean weighted_linear 0.664 0.000yes Northeast low weighted_linear 0.947 0.000yes Southeast low weighted_linear 0.417 0.000yes Inland low weighted_linear 0.280 0.000yes Pacific low weighted_linear 1.067 0.000yes National low weighted_linear 0.279 0.000yes Northeast high weighted_linear 2.072 0.000yes Southeast high weighted_linear 0.834 0.000yes Inland high weighted_linear 0.701 0.000yes Pacific high weighted_linear 2.616 0.000yes National high weighted_linear 1.070 0.000yes Northeast mean weighted_quadratic 0.000 0.000yes Southeast mean weighted_quadratic 0.000 0.000yes Inland mean weighted_quadratic 0.000 0.000yes Pacific mean weighted_quadratic 0.000 0.000yes National mean weighted_quadratic 0.000 0.000yes Northeast low weighted_quadratic 0.000 0.000yes Southeast low weighted_quadratic 0.000 0.000yes Inland low weighted_quadratic 0.000 0.000yes Pacific low weighted_quadratic 0.000 0.000yes National low weighted_quadratic 0.000 0.000yes Northeast high weighted_quadratic 0.000 0.000yes Southeast high weighted_quadratic 0.000 0.000yes Inland high weighted_quadratic 0.000 0.000yes Pacific high weighted_quadratic 0.000 0.000yes National high weighted_quadratic 0.000 0.000yes**fish_sav_sq_sig fish_sav_WTP_threshold** 

na 100

na 100

na 100

na 100

na 100

na 100

na 100

na 100

na 100

na 100

na 100

na 100

na 100

na 100

na 100

na 100

na 100

na 100

na 100

na 100

na 100

na 100

na 100

na 100

na 100

na 100

na 100

na 100

na 100

na 100
yes 100
yes 100
yes 100
yes 100
yes 100
yes 100
yes 100
yes 100
yes 100
yes 100
yes 100
yes 100
yes 100
yes 100
yes 100