What is BCG matrix template?

The BCG matrix template plots products or product categories against two variables: Relative Market Share (horizontal axis) – the higher the market share, the more cash likely being generated.

How do you create a BCG matrix?

How To Make A BCG matrix?

  1. Step 1: Choose the product. BCG matrix can be used to analyse Business Units, separate brands, products or a firm as a unit itself.
  2. Step 2: Define the market.
  3. Step 3: Calculate the relative market share.
  4. Step 4: Find out the market growth rate.
  5. Step 5: Draw the circles on a matrix.

What are the 4 BCG matrix?

The BCG growth-share matrix contains four distinct categories: “dogs,” “cash cows,” “stars,” and “question marks.”

What is dog in BCG matrix?

What Is a Dog? In business, a dog (also known as a “pet”) is one of the four categories or quadrants of the BCG Growth-Share matrix developed by Boston Consulting Group in the 1970s to manage different business units within a company. A dog is a business unit that has a small market share in a mature industry.

How do you insert a BCG matrix in Excel?

To insert the BCG Matrix into Excel, select columns A, B and C for all products. Market Growth will be measured using the values of Y axis. Market Share will be the bubble in the chart. Go to Ribbon > Insert > Other Charts and click Bubble Chart.

Why is it called a cash cow?

A cash cow is a metaphor for a dairy cow that produces milk over the course of its life and requires little to no maintenance. The phrase is applied to a business that is also similarly low-maintenance.

What is the best situation for any business in BCG matrix?

In a mature industry, it is advisable for a company to keep the sales volume high as the business unit is comparatively a good source to generate revenue.

What does cow symbolize in BCG matrix?

Cash Cows symbolize Stable in BCG matrix. Cash cows are the leaders in the marketplace and generate more cash than they consume. These are business units or products that have a high market share but low growth prospects.

How do you create a matrix chart in Excel?

To create a matrix chart excel, the users need to follow these steps:

  1. Step 1: Open excel and arrange the Data.
  2. Step 2: Select Bubble Chart.
  3. Step 3: Stylize the Matrix.
  4. Step 4: Save the Matrix.
  5. Step 1: Select Matrix Template.
  6. Step 2: Customize Your Matrix.
  7. Step 3: Save and Share.
  8. Excel Matrix Template.