The VP of Manufacturing has brought manufacturing process improvement projects to the executive team. Project A is an improvement that will decrease annual manufacturing costs. Project B is an improvement that will decrease carbon emissions and bring them into compliance with new legislation expected to take effect five years from now. Project C is an improvement that will allow for much shorter manufacturing lead times, improving customer experience and increasing revenue. As a Project Manager in the manufacturing group, you are expected to prioritize the projects and make a recommendation on which should be done first.

Each member of the executive team has scored the three projects in five categories. In addition, estimates of cost and income (both revenue increases and expense decreases) impacts for the next five years are provided.

1. Calculate the NPV for each project using an 18% cost of capital.

2. Calculate the binary score for each project assuming that a 2 or 3 equates to a yes and a 1 equates to no.

3. Calculate the weighted score for each project assuming the weights are 20% strategic fit, 20% revenue growth, 30% regulatory need, 10% expense savings, and 20% internal capabilities.

Answer the questions below about your results.

1. Based on the NPV scoring method, which project is the best?

2. Based on the binary scoring method, which project is the best choice?

3. Based on the weighted scoring method, which project is the best choice?

4. (short answer) Based on your answers to 1-3, what do you conclude about the quantitative scoring methods?

5. Based on the data provided, what factors might you consider that arent captured in the quantitative scoring methods?

6. Given your above answers, which project would your recommend as the first priority and why?

\begin{tabular}{|l|l|r|r|r} \hline & & Project A & Project B & \multicolumn{1}{l}{ Project C } \\ \hline 2 & Cost* & $250,000.00 & $100,000.00 & $3,000,000.00 \\ \hline 3 & Income year 1 & $50,000.00 & $20,000.00 & $1,000,000.00 \\ \hline 4 & Income year 2 & $100,000.00 & $20,000.00 & $1,000,000.00 \\ \hline 5 & Income year 3 & $150,000.00 & $20,000.00 & $2,000,000.00 \\ \hline 6 & Income year 4 & $150,000.00 & $20,000.00 & $2,000,000.00 \\ \hline 7 & Income year 5 & $150,000.00 & $20,000.00 & $2,000,000.00 \\ \hline \end{tabular} Assume all costs are incurred immediately Scores represent average score across 5 members of the executive team \begin{tabular}{|l|r|r|r|r|} \hline Category & Project A & Project B & Project C & Weights \\ \hline Strategic Fit & 2 & 1 & 3 & 0.2 \\ \hline Revenue Growth & 1 & 1 & 3 & 0.2 \\ \hline Regulatory Need & 1 & 3 & 1 & 0.3 \\ \hline Expense Savings & 3 & 1 & 1 & 0.1 \\ \hline Internal Capabilities & 3 & 3 & 1 & 0.2 \\ \hline \end{tabular}