The Custom Bike Company has set up a weighted scoring matrix for evaluation of potential projects. Following are five projects under consideration. 1. Using the scoring matrix below, which project would you rate highest? Lowest? 2. If the weight for Strong Sponsor is changed from 2.0 to 5.0, will the project selection change? What are the three highest weighted project scores with this new weight?

\begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline & A & B & C & D & E & F & G & H & I \\ \hline 1 & & \begin{tabular}{r} Strong \\ sponsor \end{tabular} & \begin{tabular}{r} Supports \\ business \\ strategy \end{tabular} & Urgency & \begin{tabular}{r} 10% of sales \\ from new \\ products \end{tabular} & Competition & \begin{tabular}{r} Fill \\ market \\ gap \end{tabular} & \begin{tabular}{r} Weighted \\ Total \end{tabular} & \\ \hline 2 & Weight & 2 & 5 & 4 & 3 & 1 & 3 & & \\ \hline 3 & Project 1 & 9 & 5 & 2 & 0 & 2 & 5 & 68 & = =SUMPRODUCT ($B$2:$G$2,B3:G3) \\ \hline 4 & Project 2 & 3 & 7 & 2 & 0 & 5 & 1 & 57 & \\ \hline 5 & Project 3 & 6 & 8 & 2 & 3 & 6 & 8 & 99 & \\ \hline 6 & Project 4 & 1 & 0 & 5 & 10 & 6 & 9 & 85 & \\ \hline 7 & Project 5 & 3 & 10 & 10 & 1 & 8 & 0 & 107 & \\ \hline \end{tabular}