Free Download Bcg Matrix

Posted on
  1. Free Download Bcg Matrix Software
  2. Free Download Bcg Matrix Software
  3. Free Download Bcg Matrix Template
  4. Bcg Matrix Template

The BCG matrix also called 'growth - market share'. It is a simple and intuitive tool for portfolio analysis. The availability and originality of the chart sectors names made it very popular among marketers and managers. Let’s consider the example of building a matrix in Excel.

Free Download Bcg Matrix

Examples of using the BCG matrix

Using the matrix of the Boston Consulting Group (BCG) you can quickly and visually analyze the product groups and branches of the company. You can proceed company analysis based on their share in the relevant market segment and in the market growth rate. The using of the tool is based on two hypotheses:

  1. The leader in the market has a competitive advantage in production costs. Consequently, the leading company has the highest profitability in the segment.
  2. An enterprise needs to invest a lot in the development of its product to work effectively in a fast-growing market. The presence in the segment with a low growth rate allows the company to reduce this expense item.

With the help of the BCG matrix, it is possible to quickly identify the most promising and the 'weakest' goods (branches, companies). You can make a decision on the basis of the received data: what assortment group (division) to develop, and which of them needs to be liquidated.

The BCG matrix is a strategic management tool that was created by the Boston Consulting Group, which helps in analysing the position of a strategic business unit and the potential it has to offer. The matrix consists of 4 classifications that are based on two dimensions. These first of these dimensions is the industry or market growth. The BCG Matrix is a framework that helps to assess the value of investments in the company’s portfolio management. It was created in 1968 by Boston Consulting Group founder, Bruce Henderson. This BCG Matrix Excel Template has been constructed by four quadrants which are Stars, Question Marks, Cash Cow and Poor Dog and each of them represents. BCG Matrix Template A free customizable BCG matrix template is provided to download and print. Quickly get a head-start when creating your own BCG matrix diagram. With the vivid clipart and callout shapes, your matrix will be more good-looking and information-rich. Download Template: Get EdrawMax Now! Free Download Popular Latest Flowchart. Signup Free to download The BCG Matrix is a growth-share matrix created by the Boston Consulting Group. This powerful financial planning tool classify an organisation’s services and products in four categories and help companies decide how to manage their assets regarding what to keep, sell or invest more in.

All the analyzed elements go into one of four quadrants after the analysis work:

Free Download Bcg Matrix Software

Download
  1. 'Problems'. Products represented in fast-growing industries, but having a low market share., You need significant financial investments to strengthen their position in the market. The enterprise decides whether it has sufficient funds for the development of this assortment group or division if these directions fall into this quadrant. The product does not develop without cash injections.
  2. 'Stars'. Business directions and products are leaders in a fast-growing market. The task of the enterprise is to support and strengthen these products. The best resources should be allocated to them because it is a stable source of profit.
  3. 'Moneybags'. Goods with a relatively high market share in the slowly growing segment. They are the main generator of money and do not need high investment. It’s sales revenues should go to the development of 'stars' or 'wild cats'.
  4. 'Dead weight'. A characteristic feature is the relatively low market share in the slowly growing segment. These directions do not make sense.

The BCG matrix: an example of construction and analysis in Excel

Let’s consider the construction of the BCG matrix on the example of an enterprise. Preparation:

  1. Collect data and build the source table. A list of elements to be analyzed is made up at the first stage. It can be goods, assortment groups, company branches or enterprises. It is necessary to specify the volume of sales (profit) and similar data of a key competitor (or a number of competitors) for each indicator. The initial data is entered in the table. * The analyzed period can be different (month, quarter, half a year). But the closer this indicator to the year, the higher it’s objectivity (since seasonality does not affect the figures).
  2. Calculation of the growth market rate. It is necessary to calculate how much the sales volume has increased/decreased in comparison with the previous period. To do this we need data on the sales for the previous period.
  3. The formula for calculating the growth market rate in Excel:* The percentage format is set for cells in column D.
  4. Calculation of the relative market share. For each of the analyzed products, you need to calculate the relative market share towards a similar product for a key competitor. To do this you have to divide the sales volume of the enterprise product by the sales volume of a similar product of the competitor.

Building the BCG matrix

The best tool for these purposes is a bubble chart in Excel.

Add the construction area to the sheet using the 'INSERT'-'Charts'-'Scatter'-'Bubble'. We enter the data for each line as follows:

After select: 'CHART TOOLS'-'DESIGN'-'Select Data'-'Add':

On the horizontal axis is the relative market share (set the logarithmic scale: 'CHART TOOLS'-'FORMAT'-'Current Selection'-'Horizontal (Value) Axis'). On the vertical is the rate of market growth. The area of the diagram is divided into 4 identical quadrants:

Template

Central value for the growth market rate is 80%. For the relative market share is 1.00. We will distribute commodity categories taking into account these data:

Free Download Bcg Matrix Software

Conclusions:

Free Download Bcg Matrix Template

  1. 'Problems' - Item №1 and №4. Investments are needed to develop these goods. Scheme of development is next: creating a competitive advantage - distribution - support.
  2. 'Stars' - Item №2 and №3. The company has such categories and this is a plus. At this stage, only support is needed.
  3. 'Cash Cows' - Item №5. Brings a good profit which can be used to finance other products.
  4. 'Deadweight' is not found.

Bcg Matrix Template

It is desirable to preserve this state of affairs as long as possible. Subsequently, we need to analyze the prospects of 'Difficult children' more deeply: is it possible to turn them into 'Stars'.