Question: table [ [ Factor ( lee points each ) Weight,Location Score ] , [ Conventence , 0 . 1 5 , 8 , B

\table[[Factor (lee points each) Weight,Location Score],[Conventence,0.15,8,B,C],[Parking facilities,0.20,70,91,66],[Display area,0.18,89,98,97],[Shopper traffic,0.27,88,89,93],[Operating costs,0.10,96,89,82],[Neighborhood,0.10,85,97,97],[,1.00,,91,81]]
Click here for the Excel Data File
a. Using the above factor ratings, calculate the composite score for each location.
Note: Do not round intermediate calculations. Round your final answers to 2 decimal places.
\table[[Location,\table[[Composite],[Score]]],[A,],[B,],[C,]]
b. Determine which location alternative (A,B, or C) should be chosen on the basis of maximum composite score.
 \table[[Factor (lee points each) Weight,Location Score],[Conventence,0.15,8,B,C],[Parking facilities,0.20,70,91,66],[Display area,0.18,89,98,97],[Shopper traffic,0.27,88,89,93],[Operating costs,0.10,96,89,82],[Neighborhood,0.10,85,97,97],[,1.00,,91,81]] Click

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!