Weighted Scoring Tool

Continue to work your way across the columns, selecting the most reasonable response, based on your knowledge of the case. (I have bold the columns for the calculations)

Use these numbers to calculate an Impact Analysis number (using the first 4 columns), paying attention to the weight given to each of the columns. Then do the same to calculate a Value Analysis number (using the last 4 columns). Resource: How to calculate weighted average

Weighted Scoring Tool

Impact Analysis (100%) Value Analysis (100%)

Initial Funding	Timeline	Resources	Training	Strategic Plan	Satisfaction	Reliability	Financial ROI
Weight = 25%	Weight = 25%	Weight = 35%	Weight = 15%	Weight = 25%	Weight = 25%	Weight = 15%	Weight = 35%
High = 5 >$100,000	High = 5 > 2 years	High = 5 >10 staff	High = 5 Full training	High = 5 90%-100% aligned	High = 5 High satisfaction	High = 3 Improvements	High = 5 < 3 years
Medium = 3 $100-$1,000	Medium = 3 1-2 years	Medium = 3 5-10 staff	Medium = 3 Refresher only	Medium = 2 50%-90% aligned	Medium = 3 Low satisfaction	Medium = 3 No change	Medium = 3 3-5 years
Low = 1 <$1,000	Low = 1 <1 year	Low = 1 <5 staff	Low = 1 No training	Low = 0 < 50% aligned	Low = 0 No/negative impact	Low = 0 Unpredictable	Low = 1 5+ years/no ROI
			Final Impact Analysis Number:				Final Value Analysis Number: