Competitor Index Calculator
Introduction
Understanding your competitive strengths and weaknesses is a prerequisite to developing a winning marketing strategy. The Competitor Rating Calculator allows you to rate your offering against that of up to five main competitors. Competitors can be rated on the basis of the most important factors in the purchasing decision. Bar and radar charts are automatically generated based on the ratings input. The ratings are then adjusted on the basis of the importance/weighting you have given to each of the factors in the purchasing decision The weighted ratings are automatically calculated and bar and radar charts are generated. A Total Competitive Score is also calculated and a corresponding Bar Chart is produced. A Total Adjusted Competitive Score is also calculated and a corresponding Bar Chart is produced.
© 2004 Business Tools & Templates www.business-tools-templates.com
(c) 2004 Copyright Business Tools Templates
Page 1
www.business-tools-templates.com
Competitor Index Calculator
© 2004 Business Tools & Templates www.business-tools-templates.com
User Instructions
Open the Competitor Index Calculator worksheet. The cells in Green are the data input fields. Cells in Red can not be modified in the evaluation copy. These Red cells are fully editable in the full working copy available from www.business-tools-templates.com The following data should be entered: Edit Company Name Edit the Competitor Factors you consider most important and the Weighting for each in the Purchasing Decision. Start with the most important factor and assign the weighting to each. Note that the weighting must add up to a total of 100 Edit the Name of each Competitor (you may analyse up to 5 competitors) For each Competitor Factor rate each competitor on a scale of 1 to 10 as follows: Competitive Ratings 10 = Very strong/best in class Performer 5 = Average performer 1 = Extremely weak Performer
The weighting ratings are calculated for each competitor based on the weighting of each factor in the purchasing decisio A Total Competitive Score is calculated and Bar and Radar Charts are automatically generated.
Bar and radar charts are automatically generated based on the ratings input.
The ratings are then adjusted on the basis of the importance/weighting you have given to each of the factors in the purch Bar and radar charts are automatically generated based on the weighted ratings.generated. A Total Competitive Score is calculated and a corresponding Bar Chart is produced. A Total Adjusted Competitive Score is also calculated and a corresponding Bar Chart is produced. Enjoy!
lculator
odified in the evaluation copy.
m www.business-tools-templates.com
ghting for each in the Purchasing Decision.
weighting of each factor in the purchasing decision
e automatically generated.
g you have given to each of the factors in the purchasing decision
ed ratings.generated.
nding Bar Chart is produced.
Competitor Index Calculator
© 2004 Business Tools & Templates www.business-tools-templates.com Company Name Competitor Factors Price Quality Customer Service Product Range Distribution Outlets Other 1 Other 2 My Company Inc Weighting 25% 20% 20% 15% 10% 5% 5% 100% Competitive Ratings 10 = Very strong/best in class Performer 5 = Average performer 1 = Extremely weak Performer
Competitor Rating
Competitors My Company Inc Sample Competitor 1 Sample Competitor 2 Sample Competitor 3 Sample Competitor 4 Sample Competitor 5 Price 10 9 1 4 2 8 Quality 6 4 9 7 1 2 Customer Service 8 8 1 3 6 9 Product Range 5 3 7 3 4 1 Distribution Outlets Other 1 7 3 5 5 1 3 Other 2 5 3 3 3 3 7 9 5 1 3 2 9 My Company Inc Sample Competitor 1 Sample Competitor 2 Sample Competitor 3 Sample Competitor 4 Sample Competitor 5 Total Score 50 35 27 28 19 39
Weighted Rating
Competitors My Company Inc Sample Competitor 1 Sample Competitor 2 Sample Competitor 3 Sample Competitor 4 Sample Competitor 5 Price 2.5 2.25 0.25 1 0.5 2 Quality Customer Service Product Range Distribution Outlets 1.2 1.6 0.75 0.7 0.8 1.6 0.45 0.3 1.8 0.2 1.05 0.5 1.4 0.6 0.45 0.5 0.2 1.2 0.6 0.1 0.4 1.8 0.15 0.3 Other 1 0.25 0.15 0.15 0.15 0.15 0.35 Other 2 0.45 0.25 0.05 0.15 0.1 0.45 My Company Inc Sample Competitor 1 Sample Competitor 2 Sample Competitor 3 Sample Competitor 4 Sample Competitor 5 Total Score 7.45 5.8 4 4.25 2.85 5.45
(c) 2005 Copyright Business Tools Templates
Page 4
www.business-tools-templates.com
Score
(c) 2005 Copyright Business Tools Templates
Page 5
www.business-tools-templates.com
Competitor Radar Chart
Price 10
9 8 7 Other 2 6 5 4 3 2 1 0 Quality
My Company Inc Sample Competitor 1 Sample Competitor 2 Sample Competitor 3 Sample Competitor 4 Sample Competitor 5
Other 1
Customer Service
Distribution Outlets
Product Range
(c) 2005 Copyright Business Tools Templates
www.business-tools-templates.com
Adjusted Competitor Radar Chart
Price
2.5 2 1.5 1
Quality
My Company Inc Sample Competitor 1 Sample Competitor 2 Sample Competitor 3 Sample Competitor 4 Sample Competitor 5
Other 2
0.5
0
Other 1 Customer Service
Distribution Outlets
(c) 2004 Copyright Business Tools Templates Page 7
Product Range
www.business-tools-templates.com
Competitor Rating
My Company Inc Sample Competitor 1 Sample Competitor 2 Sample Competitor
Price
Quality
Customer Service
Product Range
mpetitor Rating
Sample Competitor 3 Sample Competitor 4 Sample Competitor 5
Product Range
Distribution Outlets
Other 1
Other 2
Adjusted Competitor Rating
My Company Inc Sample Competitor 1 Sample Competitor 2 Sample Competitor 3 Sample Competitor 4 Sample Competitor 5
Price
Quality
Customer Service
Product Range
Distribution Outlets
Other 1
Other 2
(c) 2004 Copyright Business Tools Templates
Page 10
www.business-tools-templates.com
Total Competitor Score
Sample Competitor 5
Sample Competitor 4
Sample Competitor 3
Sample Competitor 2
Sample Competitor 1
My Company Inc
0
5
10
15
20
25
r Score
Total Score
30
35
40
45
50
Total Adjusted Competitor Score
Total Score
Sample Competitor 5
Sample Competitor 4
Sample Competitor 3
Sample Competitor 2
Sample Competitor 1
My Company Inc
0
1
2
3
4
5
6
7
8
(c) 2004 Copyright Business Tools Templates
Page 13
www.business-tools-templates.com