Problem $8-9($Algo$)$

$\backslash$table$[[,,$Location Score$],[$Factor$,$Weight,A$,$B$,$C$],[$Convenience$,0\mathrm{.}15,85,85,82],[$Parking facilities,$0\mathrm{.}20,70,91,91],[$Display area,$0\mathrm{.}18,87,97,90],[$Shopper traffic,$0\mathrm{.}27,95,90,92],[$Operating costs,$0\mathrm{.}10,86,90,97],[$Neighborhood$,{0\mathrm{.}10}_{?},88,92,84],[,{1\mathrm{.}00}_{?},,,]]$

Click here for the Excel Data File

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

$\backslash$table$[[$Location$,\backslash$table$[[$Composite$],[$Score$]]],[$A$,],[$B$,],[$C$,]]$