Your task is to Develop a BCG Matrix for the companies in EXCEL Please show how to do this in EXCEL The one I created in excel doesn't look just right, so, I think I'm missing a step I'm not sure how I'm to factor in the Profit in my figures if that's even needed Division Revenues Profits profit RMSP IGR Midland 250 75 0 6 10 Odessa 500 90 0 8 2 Abilene 125 18 0 4 7 profit You calculate if needed industry growth rate percent 2 IGR RMSP relative market share position in the industry

The Answer is in the image, click to view ...

Question: Your task is to Develop a BCG Matrix for the companies in EXCEL. ** Please show how to do this in EXCEL. The one I

Your task is to Develop a BCG Matrix for the companies in EXCEL. ** Please show how to do this in EXCEL. The one I created in excel doesn't look just right, so, I think I'm missing a step. I'm not sure how I'm to factor in the % Profit in my figures if that's even needed?

Your task is to Develop a BCG Matrix for the companies in

Division Revenues Profits % profit RMSP IGR% Midland 250 75 0.6 10 Odessa 500 90 0.8 -2 Abilene 125 18 0.4 7 % profit You calculate if needed industry growth rate percent 2% IGR% RMSP relative market share position in the industry

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

The purpose of this assignment is to conduct internal and external research to determine previously attempted solutions and potential solutions that could be implemented to solve identified problem....

My Topic is Employee High Turnover Rate, I need help with completing an assignment with the problem that I have selected to solve within my organization. "Employee High Turnover Rate" Five Whys Root...

The purpose of this is to conduct internal and external research to determine viable solutions that could be implemented to solve an identified problem. For this, you will prepare an Excel...

The purpose of this assignment is to conduct internal and external research to determine viable solutions that could be implemented to solve an identified problem. For this assignment, you will...

This assignment is not making much sense to me . Are we using this table for all 3 graphs and how we figure out what the Anticipated Hypothesis Test is ? I could not find this in any of the study...

The purpose of this assignment is to conduct internal and external research to determine viable solutions that could be implemented to solve an identified problem. For this assignment, you will...

answer the question step by step, and if you using excel please show the screen Stphane Zanella took a second careful sip from the glass of the 2002 St Emilion in front of him. He spun the stem of...

MKT500 Discussion Board 10 "Marketing Strategy" Please respond to the attached questions. I have attached the question, scenario, and lecture notes. Thank You "Marketing Strategy" 1.) From the...

For some years now, you've owned a small specialty bookshop in a college town. You sell some textbooks but mainly cater to a broader customer base. Your store always stocks the latest fiction,...

For a certain kind of plaster? work, 0.7 cu yd. of sand are needed for every 100 sq. yd. of surface. How much sand will be needed for 320sq yd. of? surface? How many cu yd of sand will be needed for...

You are a manufacturer who distributes your product through a channel of distribution that includes wholesalers, retailers and consumers. The retailer sells at a retail price of $40.00 per unit and,...

A 1 0 year bond has a par value of $ 5 0 0 0 with a 6 % nominal rate, compounded semi annually. It has a coupon rate of 8 % and the coupon interest payments are semi annual. What is the current value...

We need a program that calculates a medicine dosage by age. The following table states the amount of mg according to age ranges AGE DOSE (MG) 100 Greater or equal to 5 220 Write a method int...