Reuse and the Benefit to Community
South Andover 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
Andover Cinema: 40 employees
DUNS Number: 016552999
Sales Volume (US$):	$1,200,000
Belli Capelli The Salon: 13 employees
DUNS Number: 148697068
Sales Volume (US$):	$300,000
Caribou Coffee Company, Inc.: 14 employees
DUNS Number: 929261522
Sales Volume (US$):	Not provided
Courtyards of Andover Events Center: 20 employees
DUNS Number: 50283386
Sales Volume (US$):	$490,000
Daisy Nails: 2 employees
DUNS Number: 784941499
Sales Volume (US$):	$50,000
Fantastic Sams Andover: 2 employees
DUNS Number: 826513280
Sales Volume (US$):	$65,000
Festival Bakery Andover: 6 employees
DUNS Number: 626779651
Sales Volume (US$):	$180,000
1 D&B updates its company reports on an annua! basis. Data from D&B used for this analysis was collected in
March 2011.
1

-------
Festival Foods: 97 employees
DUNS Number: not available
Sales Volume (US$):	not available
Nail Spa: 2 employees
DUNS Number: 137907106
Sales Volume (US$):	$44,000
Northgate Liquors Andover: 2 employees
DUNS Number: 137913484
Sales Volume (US$):	$170,000
Tanners Steakhouse and Bar (Rgw, LLC): 70 employees
DUNS Number: 832514132
Sales Volume (US$):	$720,000
Target Corporation: 200 employees
DUNS Number: 783347904
Sales Volume (US$):	not provided
Walgreen Company: 40 employees
DUNS Number: 807969394
Sales Volume (US$):	not provided
Businesses featured in "Reuse and the Benefit to Community: South Andover Site" case study which did not
report to D&B
Several on-site business located at Andover Station do not submit data to D&B. Employee data for Festival Foods
grocery store was collected from the 2009 City of Andover Comprehensive Annual Financial Report.
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.
Average weekly wage data for each of the businesses located at Andover Station 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 Anoka County.2 To determine the annual wages
(mean annual) earned from jobs generated by each of the business located at Andover Station, 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.
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 1: Andover Station 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)
Andover Cinema
512131
Motion Picture Theaters
(except Drive-Ins)
$188
$9,776
Belli Capelli The
Salon
812113
Nail Salons
$243c
$12,636
Caribou Coffee
Company, Inc.
722211
Limited-Service
Restaurants
$215
$11,180
Courtyards of
Andover Events
Center
812990
All Other Personal Services
$247
$12,844
Daisy Nails
812113
Nail Salons
$243c
$12,636
Fantastic Sams
Andover
812112
Beautv Salons
$345
$17,940
Festival Bakery
Andover
311811b
Retail Bakeries
$215
$11,180
Festival Foods
445110b
Supermarkets and Other
Grocery(except
Convenience) Stores
$465
$24,180
Nail Spa
812113a
Nail Salons
$243c
$12,636
Northgate Liquors
Andover
445310
Beer, Wine, and Liauor
Stores
$281
$14,612
Tanners Steakhouse
and Bar (Rgw, LLC)
722110b
Full-Service Restaurants
$269
$13,988
Target Corporation
452112
Discount Department
Stores
$377
$19604
Walgreen Co.
446110
Pharmacies and Drug
Stores
$701
$36,452
-Average Weekly Wage data source: BLS Quarterly Census of Employment and Wages (2009) Anoka County,
Minnesota, 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.
c Average weekly wage BLS data corresponding with Nail Spa is from 2007; data for 2008 and 2009 was not made
available.
3

-------
Table 2: Andover Station Businesses: Employees, Wages and Total Annual Wage
On-site Business
Employees3
Annual Wage (Mean Annual)
per Employee15
Total Annual Wages c
Andover Cinema
40
$9,776
$391,040
Belli Capelli The Salon
13
$12,636
$164,268
Caribou Coffee
Company, Inc.
14
$11,180
$156,520
Courtyards of Andover
Events Center
20
$12,844
$256,880
Daisy Nails
2
$12,636
$25,272
Fantastic Sams Andover
2
$17,940
$35,880
Festival Bakery
Andover
6
$11,180
$67,080
Festival Foods
97
$24,180
$2,345,460
Nail Spa
2
$12,636
$25,272
Northgate Liquors
Andover
2
$14,612
$29,224
Tanners Steakhouse
and Bar (Rgw, LLC)
70
$13,988
$979,160
Target Corporation
200
$19,604
$3,920,800
Walgreen Co.
40
$36,452
$1,458,080
Total
508
NA
$9,854,936
-Employee data for Festival Foods is from the 2009 City of Andover Comprehensive Annual Financial Report. All
other employee data is from D&B.
-Total 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 total tax amount for the parcels comprising Andover
Station were collected from property records accessible through Anoka County's online property records
database (http://www.co.anoka.mn.us/vl departments/div-property-rec-tax/index.asp).
Table 3. Estimated Property Values (2010) and Tax Amount (2009) for Andover Station
Parcel ID No.
Estimated Land Value
(2010)($)
Estimated
Improvement
Value (2010) ($)
Total Estimated
Value (2010) ($)
Total Tax Amount
(2009)($)
34-32-24-31-0034
668,700
1,235,000
1,903,700
29,758
34-32-24-31-0035
1,474,000
0
1,474,000
0
34-32-24-31-0036
1,199,000
0
1,199,000
0
34-32-24-31-0154
555,300
0
555,300
7,996
34-32-24-31-0155
599,900
989,600
1,589,500
18,288
34-32-24-31-0156
496,000
648,900
1,144,900
7,085
34-32-24-32-0028
3,146,200
3,947,500
7,093,700
110,165
34-32-24-42-0025
726,000
2,100,600
2,826,600
44,841
34-32-24-42-0026
675,600
910,600
1,586,200
51,366
34-32-24-42-0027
606,400
949,400
1,555,800
23,839
4

-------
Parcel ID No.
Estimated Land Value
(2010)($)
Estimated
Improvement
Value (2010) ($)
Total Estimated
Value (2010) ($)
Total Tax Amount
(2009)($)
34-32-24-42-0029
0
-
0
0
34-32-24-42-0030
3,664,400
7,375,700
11,040,100
172,615
34-32-24-42-0031
710,500
890,900
1,601,400
23,367
34-32-24-42-0028
532,600
3,157,400
3,690,000
114,329
34-32-24-32-0027
34,500
355,200
389,700
11,009
34-32-24-31-0038
100
-
100
3
34-32-24-31-0039
112,500
-
112,500
2,657
34-32-24-42-0015
123,700
465,800
589,500
17,468
34-32-24-42-0016
109,000
359,000
468,000
13,699
34-32-24-42-0017
263,900
297,100
561,000
16,534
34-32-24-42-0018
258,300
266,900
525,200
15,422
34-32-24-42-0019
130,100
468,000
598,100
18,352
34-32-24-42-0020
135,400
444,200
579,600
17,440
34-32-24-42-0021
233,100
256,400
489,500
15,016
34-32-24-42-0022
233,100
256,400
489,500
15,901
34-32-24-42-0023
96,300
520,600
616,900
22,102
34-32-24-42-0024
118,300
644,500
762,800
22,456
Total
16,902,900
26,539,700
43,442,600
791,708
Property values source: Anoka County, Property Records & Taxation Department, Property Information On-Line.
Notes: Total tax amount excludes all interest, penalties and costs. Anoka County is responsible for collecting
property taxes and distributing tax collections to the City of Andover.
5

-------