4>EPA www.epa.gov 1 Reuse and the Benefit to Community Koppers Coke Superfund Site Technical Appendix Positive Impacts: Employment Information for On-site Jobs The Dun & Bradstreet (D&B) database provided information on the number of employees and sales volume for on-site businesses. D&B provides information on businesses and corporations. It maintains a database of over 179 million companies globally and over 53 million professional contact names using a variety of sources, including public records, trade references, telecommunication providers, newspapers and publications, and telephone interviews. The Data Universal Numbering System (DUNS) number is a unique nine-digit identification number assigned by D&B to each business and its location within the D&B database for identifying each business. The Saint Paul Port Authority also collects data on Energy Park tenants; this analysis compared data provided by the Port Authority with the data provided by D&B. In most cases, the analysis selected the lower of the two employment estimates to be conservative. The analysis selected the Port Authority's employment estimates for two on-site businesses, Prometric and US Bancorp Information Services Corporation, rather than data from D&B, because the Port Authority's estimates appeared to be more accurate. Positive Impacts: Wage and Income Information for On-site Jobs The U.S. Bureau of Labor Statistics (BLS) provided wage and income information. The BLS is a governmental statistical agency that collects, processes, analyzes and disseminates essential statistical data to the American public, the U.S. Congress and other federal agencies in the broad field of labor economics and statistics. The data provided by the BLS has high standards of accuracy and consistently high statistical quality, and impartiality in both subject matter and presentation. The BLS Quarterly Census of Employment and Wages database provided average weekly wage data for each of the businesses located at the Koppers Coke site. Average weekly wage data was identified by matching the North American Industry Classification System (NAICS) codes corresponding with each type of business with weekly wage data for corresponding businesses in Ramsey County. If not available at the county level, the wage data were sought by state or national level, respectively. In cases where wage data was not available for the six-digit NAICS code, higher level (less detailed) NAICs codes were used to obtain the wage data. To determine the annual wages (mean annual) earned from jobs generated by each of the businesses at the Koppers Coke site, the average weekly wage figure was multiplied by the number of weeks in a year (52) and by the number of jobs (employees) for each of the businesses. ------- Table 1: Koppers Coke Site Businesses: NAICS Code and Title, Average Weekly Wage, Employees, Annual Wages and Total Annual Wage per Employee On-site Business NAICS Code3 NAICS Title Employees'3 Average Weekly Wage (2010)c Annual Wage (Mean Annual) per Employee Total Annual Wagesd US Bancorp Information Services Corporation 518210 Data Processing, Hosting, and Related Services l,250e $1,473 $76,596 $95,745,000 Kemps LLC 31151 Dairy Product, Except Frozen, Manufacturing 171 $1,084 $56,368 $9,638,928 Prometric 541380 Testing Laboratories 89e $1,151 $59,852 $5,326,828 Power/Mation Division, Inc. 423840 Industrial Supplies Merchant Wholesalers 63e $896 $46,592 $2,935,296 Metropolitan State University 9231 Administration of Human Resource Programs 50 $1,056 $54,912 $2,745,600 Minnesota Bureau of Mediation Services 926150 Licensing and Regulating Commercial Sectors 13 $1,138 $59,176 $769,288 Evergreen Medical Technology LLC 541720 Social Sciences and Humanities Research 8 $884 $45,968 $367,744 Minnesota Health Professional Service Program (HPSP) 813920 Professional Organizations 5e $1,346 $69,992 $349,960 Headwaters Software Inc (FISDAT) 517110 Wired Telecommunications Carriers 5e $1,010 $52,520 $262,600 DRIASI 524298 All Other Insurance Related Activities 5e $1,407 $73,164 $365,820 USA Central Station 56162 Security Systems Services 3 $919 $47,788 $143,364 The Law Firm of Roberts & Stotzheim Pic 541110 Offices of Lawyers 2 $1,285 $66,820 $133,640 Aramark Corp 541611 Administrative Management and General Management Consulting Services 2 $1,064 $55,328 $110,656 Beneficial Cleaning Services Inc. 561790 Other Services to Buildings and Dwellings 1 $684 $35,568 $35,568 Totals: 1,667 $118,930,292 a NAICS code provided in D&B database. b Employee data is from D&B database, except where otherwise indicated. c Average weekly wage per employee based upon BLS Average Weekly Wage data. d Total annual wage figures were derived by multiplying "Employees" by "Annual Wage (Mean Annual) per Employee." 0 Employee number obtained from Saint Paul Port Authority. 2 ------- Positive Impacts: Local Tax Revenue Generated from Property Taxes Property records accessible through Ramsey County's online property records database (http://maps.metro- inet.us/RamsevCoGIS/CXviewer.htm) provided data on the most recently assessed property values and taxes for property parcels at the Koppers Coke site in March 2012. Table 2. Estimated Property Values and Annual Tax Amounts (2011) Parcel Number Market Value - Land (2011) Market Value - Building (2011) Total Market Value (2011) Total Tax Payable (2011) 272923410039 $6,272,700.00 $12,537,300.00 $18,810,000.00 $762,888.00 272923420077 $823,100 $4,876,900.00 $5,700,000.00 $213,640.00 272923420073 $737,300.00 $2,112,700.00 $2,850,000.00 $107,500.00 272923420086 $546,300.00 $2,303,700.00 $2,850,000.00 $107,500.00 272923420085 $221,500.00 $0.00 $221,500.00 $0.00 272923420071 $420,000.00 $1,297,200.00 $1,717,200.00 $65,484.00 272923310105 $1,937,300.00 $7,400,300.00 $9,337,600.00 $360,408.00 272923310004 $184,200.00 $0.00 $184,200.00 $7,056.00 Totals: $11,142,400.00 $30,528,100.00 $41,670,500.00 $1,624,476.00 3 ------- |