Question

				Location Score
Factor (100 points each)	Weight			A	B	C
Convenience		.15		86	75	80
Parking facilities		.20		70	86	96
Display area		.18		88	90	91
Shopper traffic		.27		86	90	95
Operating costs		.10		95	91	96
Neighborhood		.10		88	88	91
		1.00

a. Using the above factor ratings, calculate the composite score for each location. (Do not round intermediate calculations. Round your final answers to 2 decimal places.)

Location	Composite Score
A
B
C

b. Determine which location alternative (A, B, or C) should be chosen on the basis of maximum composite score.

A

C

B

Answer 1

				Location Score
Factor	Weight			A	B	C
(100 points each)
Convenience		0.15		86	75	80
Parking facilities		0.2		70	86	96
Display area		0.18		88	90	91
Shopper traffic		0.27		86	90	95
Operating costs		0.1		95	91	96
Neighborhood		0.1		88	88	91
		1	Weighted score	84.26	86.85	91.93	(sumproduct(Weight,location score))
a. Using the above factor ratings, calculate the composite score for each location. (Do not round intermediate calculations. Round your final answers to 2 decimal places.)
								Location	Composite Score
A	84.26
B	86.85
C	91.93
b. Determine which location alternative (A, B, or C) should be chosen on the basis of maximum composite score.
A
C	Should be chosen
B