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