Introduction
Understanding
your competitive strengths and weaknesses is a prerequisite to developing a
winning marketing strategy. The Competitive 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. 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.
User
Instructions
Open
the Competitive Index Calculator worksheet.
The
cells in Green
are the data input fields.
The
following data should be entered:
Enter your Company Name
Enter the Purchasing
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.
Enter
the Name of each Competitor
(you may analyse up to 5 competitors)
For each Purchasing Factor rate each competitor on a scale of 1 to 5 relative to
your organisation as follows:
Competitive Ratings
5 = Much stronger than your
organisation
4 = Slightly stronger than your
organisation
3 = Equal to your organisation
2 = Somewhat weaker than your
organisation
1 = Much weaker than your
organisation
The
weighting ratings are calculated for each competitor based on the weighting of
each factor in the purchasing decision
A Total Competitive Score is calculated and Bar and Radar Charts are
automatically generated.
Enjoy!
