A Consumer Electronics Company, After Three Months of the Launch

Essay

A consumer electronics company, after three months of the launch of five new products in the market, arrived at the following results. $$\begin{array} { l | c | c | c } \text { Products } & \text { Profit (\%) } & \text { Market share (\%) } & \text { Cost (\$) } \\\hline \text { A } & 19 & 18 & 4500 \\\text { B } & 28 & 12 & 3000 \\\text { C } & 15 & 25 & 8750 \\\text { D } & 22 & 35 & 6250 \\\text { E } & 16 & 10 & 2500\end{array}$$
a. Create a bubble chart where the market share is along the horizontal axis, the profit is on the vertical axis, and the size of the bubbles represents the cost. Format this chart for best presentation by adding axes labels and labelling each bubble with the product name.
b. The manager of the company is interested in producing the product that increases the profit for a given level of market share and cost. From the bubble chart in part a, identify the product which needs to be produced in larger quantity.
c. From the bubble chart in part (a), now identify the product which needs to be produced in larger quantity taking into account its market share, cost, increase in profit.