Bcg matrix template word download7/30/2023 How to Use the Template (without market shares) You simply scroll down to find the map and then copy and paste it as a PICTURE into your relevant document. Step 7 = View and copy/paste your BCG MatrixĪt this stage your BCG matrix should be complete and will be updated automatically. You can set each circle size to be the same number if required. Excel will map these circles on a relative basis, so the larger the differences in these numbers, the larger the differences in the circle sizes. So the larger the revenue the larger the circle. The final step in setting up your BCG matrix is to determine the size of the circles, which is typically based on an estimation of revenue. Step 6 = Add Revenues, which determine Circle Sizes This percentage is used to plot on the vertical axis. In this step you will enter the relevant market growth percentage rate for each of the portfolios/brands that you are using in your matrix. The template will automatically calculate relative market share, which is used to plot the portfolios/brands on the horizontal axis. In these two steps, you enter the market shares (as a percentage) for each of the portfolios/brands (in Step 3) and then you enter the market share for the largest player in that market (in Step 4). This is where you enter the names of the portfolios (or products, brands, firms or SBU’s) that you will be using in your BCG matrix. Step 2 = List the Portfolios (Brands/Firms) to be included
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |