Using the following factor ratings, determine which location alternative (A,B, or C) should be chosen on the basis of the maximum composite score.

Location Scores

Factor (100 points each)	Weight	A	B	C
Convenience	.15	80	70	60
Parking facilities	.20	72	76	92
Display area	.18	88	90	90
Shopper traffic	.27	94	86	80
Operating Costs	.10	98	90	82
Neighborhood	.10	96	85	75

-----------------------------------------------------1.00------------------------------------

Using excel (please mention steps on excel) thank you.