[go: up one dir, main page]
Scribd
Upload
29 views4 pages

StrategyPunk - BCG Matrix - Excel Model

The document presents a data input sheet detailing the revenues, market growth rates, market shares, and competitor shares for eight products. It includes a BCG matrix diagram categorizing these products into stars, cash cows, and dogs based on their market share and growth rates. Overall, the total revenue for all products is 102,500 kEUR.

Uploaded by

Mohamed Mamdouh
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
29 views4 pages

StrategyPunk - BCG Matrix - Excel Model

The document presents a data input sheet detailing the revenues, market growth rates, market shares, and competitor shares for eight products. It includes a BCG matrix diagram categorizing these products into stars, cash cows, and dogs based on their market share and growth rates. Overall, the total revenue for all products is 102,500 kEUR.

Uploaded by

Mohamed Mamdouh
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 4

Data Input Sheet

Market
% of
Revenues Market Market Share of
Products Corporate
in kEUR Growth Rate Share Largest
Revenues
Competitor
Product 1 29,000 28% 5% 35% 20%
Product 2 19,000 19% 18% 20% 15%
Product 3 16,000 16% 3% 30% 25%
Product 4 14,000 14% -5% 10% 15%
Product 5 10,000 10% 25% 15% 10%
Product 6 8,000 8% 23% 10% 25%
Product 7 4,000 4% 18% 30% 50%
Product 8 2,500 2% 28% 15% 30%
102,500
BCG Matrix Diagram

in kEUR
Relative
Market 30%
Share Stars
high
1.75
1.33 25%
1.20
0.67
1.50 20%
0.40
Market Growth Rate

0.60
0.50 15%

10%
1.9 1.8 1.6 1.5 1.3 1.2 1.0 0.9 0.7 0.6

5%

0%

-5%

low Cash
Cows -10%

high Relative Market Share


0% Question Description
Marks
Placeholder, place your own description here
5%
Placeholder, place your own description here
0%
Placeholder, place your own description here

5% Placeholder, place your own description here

0% Placeholder, place your own description here


0.9 0.7 0.6 0.4 0.3 0.1
Placeholder, place your own description here
%
Placeholder, place your own description here
%
Placeholder, place your own description here

5% Placeholder, place your own description here


Poor
10% Dogs Placeholder, place your own description here

et Share low
ption here

ption here

ption here

ption here

ption here

ption here

ption here

ption here

ption here

ption here

You might also like