Reuse and Benefits to the Community Wells G&H Site Technical Appendix Positive Impacts: Employment Information for On-site Jobs Each on-site business was researched in the Dun & Bradstreet (D&B) Database, from which the number of employees and sales volume information was gathered. D&B is a company that 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, tele- communication providers, newspapers and publications, telephone interviews among other various sources (http://www.dnb.com/). 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 the purpose of identifying each business.1 Callahans Auto Service: 4 employees DUNS Number: 807491188 Sales Volume (US$): $270,000 Holland Arena, Inc.: 2 employees DUNS Number: 023214581 Sales Volume (US$): $110,000 Lenny's Auto Repair: 2 employees DUNS Number: 834066177 Sales Volume (US$): $160,000 Oliver Enterprises: 4 employees DUNS Number: 837891803 Sales Volume (US$): $600,000 Businesses featured in "Reuse and the Benefit to Community: Wells G&H" case study which did not report to D&B Two on-site businesses located at the Wells G&H site featured in the report do not submit data to D&B. These include: Atlantic Express Bus Yard and Winchester Dog Club. One job was assumed to be associated with each of these businesses. Positive Impacts: Wage and Income Information for On-site Jobs Wage and income information was gathered using the Bureau of Labor Statistics (BLS) data. 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. 1 D&B updates its company reports on an annual basis. Data from D&B used for this analysis was collected in May 2011. 1 ------- Average weekly wage data for each of the businesses located at the former Aberjona Auto Parts property was collected from the BLS Quarterly Census of Employment and Wages database. Average weekly wage data was identified by matching the six-digit North American Industry Classification System (NAICS) codes corresponding with each type of business with weekly wage data for corresponding businesses in Middlesex County.2 To determine the annual wages (mean annual) earned from jobs generated by each of the business located at the former Aberjona Auto Parts property, 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: Aberjona Auto Parts Property Businesses: NAICS Code and Title, Average Weekly Wage and Annual Wage per Employee On-site Business NAICS Code3 NAICS Title Average Weekly Wage (2009) Annual Wage (Mean Annual) per Employee (2009) Atlantic Express Bus Yard 811111b General Automotive Repair $767 $39,884 Callahans Auto Service 811111a General Automotive Repair $767 $39,884 Holland Arena, Inc. 561990 All other support services $1,079 $56,108 Lenny's Auto Repair 811118 Other automotive mechanical and electrical repair and maintenance $842 $43,784 Oliver Enterprises 561730a Landscaping Services $755 $39,260 Winchester Dog Club 812910b Pet Care (except Veterinary) Services $356 $18,512 Average Weekly Wage data source: BLS Quarterly Census of Employment and Wages (2009) Middlesex County, Massachusetts, http://www. bls.gov/cew/ Annual wage (Mean Annual) per Employee is based upon BLS Average Weekly Wage data. aNAICS code provided in D&B unless otherwise noted. bNAICS code assumed. 2 D&B uses six-digit NAICS codes to classify businesses reporting to D&B. For businesses not reporting to D&B, assumptions about the most appropriate NAICS code for those particular businesses were made. 2 ------- Table 2: Aberjona Auto Parts Property Businesses: Employees, Wages and Total Annual Wage On-site Business Employees3 Annual Wage (Mean Annual) per Employee15 Total Annual Wages c Atlantic Express Bus Yard 1 $39,884 $39,884 Callahans Auto Service 4 $39,884 $159,536 Holland Arena, Inc. 2 $56,108 $112,216 Lenny's Auto Repair 2 $43,784 $87,568 Oliver Enterprises 4 $39,260 $157,040 Winchester Dog Club 1 $18,512 $18,512 Total 14 NA $574,756 aAII employee data is from D&B, except for Atlantic Express Bus Yard and Winchester Dog Club. The total number of employees for each of these two businesses was assumed to be one. bTotal annual wage figures were derived by multiplying "Employees" by "Annual Wage (Mean Annual) per Employee." Positive Impacts: Local Tax Revenue Generated from Property Taxes Data on the most recently assessed property values and the estimated annual property taxes for the two parcels comprising the Aberjona Auto Parts property were collected from property records accessible through the City of Woburn Assessors on-line property records database (http://data.visionappraisal.com/WoburnMA/DEFAULT.asp) and through communications with the City's Treasurer/Collector's Office. Table 3. Estimated Property Values for Fisca Year 2010 for Former Aberjona Auto Parts Property Parcel ID Estimated Land Value (2010) Estimated Improvement Value (2010) Total Estimated Value (2010) 380106 $259,000 $301,500 $560,500 380105 $387,500 $501,900 $889,400 Total $646,500 $803,400 $1,449,900 Property values source: http://data.visionappraisal.com/WoburnMA/DEFAULT.asp 3 ------- Table 4. Tota Estimated Property Va ues and Annual Property Tax for Former Aberjona Auto Parts Property Total Estimated Total Estimated Estimated Annual Estimated Annual Value (Parcel ID Value Property Tax Property Tax Fiscal Year 380105) (Parcel ID 380106) (Parcel ID 380105) (Parcel ID 380106) 2000 $164,000 $537,000 $4,102 $12,665 2001 $164,000 $728,700 $3,787 $14,638 2002 $112,700 $694,100 $2,440 $14,076 2003 $112,700 $734,000 $1,237 $12,382 2004 $571,000 $615,900 $1,323 $13,566 2005 $571,000 $631,800 $1,310 $13,803 2006 $564,000 $630,800 $1,213 $12,916 2007 $564,000 $630,800 $1,239 $13,202 2008 $565,000 $621,700 $1,275 $13,366 2009 $565,000 $621,700 $1,387 $14,518 2010 $889,400 $560,500 $23,213 $13,921 Property values source: http://data.visionaDDraisal.com/WoburnMA/DEFAULT.asp and Don Jenson, Citv of Woburn Treasure/Collector. ProDerty tax data not available from the City's on-line DroDerty records database was made available by Don Jenson, City of Woburn Treasure/Collector (February 8, 2010). ------- |