Problem $8-9($Static$)$

$\backslash$table$[[$Factor $(100$ points,Weight,,Location Score,$],[$each$),0\mathrm{.}15,$A$,$B$,$C$],[$Convenience$,0\mathrm{.}15,80,70,60],[$Parking facilities,$0\mathrm{.}20,72,76,92],[$Display area,$0\mathrm{.}18,88,90,90],[$Shopper traffic,$0\mathrm{.}27,94,86,80],[$Operating costs,$0\mathrm{.}10,98,90,82],[$Neighborhood$,\frac{0\mathrm{.}10}{1\mathrm{.}00},96,85,75],[,,,,],[$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.

$\backslash$table$[[$Location$,\backslash$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.

A

B

C