Hi All,
For those of you involved in marketing, the GE Matrix (sometimes referred to as the "GE/McKinsey Matrix") is a mechanism for plotting Market Attractiveness against Competitive Positioning as a bubble chart using a pair of 1-9 ratings. One variant adds a third factor of Market Size by sizing the plot-point bubbles.
The attached Excel workbook uses tables to support drop-down selection of ratings for each question in a scorecard sheet and then calculates weighted averages using assigned weighting factors. It also uses a lookup table to assign market size ratings
The tables need to be tuned for any environment in which the matrix will be used and this is relatively easy to action, but requires some common-sense when deciding on values to assign. A good rule of thumb is to work from the perspective of the company when assessing market size ratings and avoid absolute size from market surveys. In other words, if the entire market segment sales potential across all products is a billion dollars, but the company product portfolio is a restricted subset of the market needs, then prorate the market size down accordingly.
The sample attached has been dummied up for a fictitious software house developing applications for local authorities in a fictitious market.
Please feel free to use with the usual caveats...
Attachment 238132
Have fun... (I know I did!
)
Dave
Bookmarks