Data Interpretation Discussion

**Common Information**

Company XYZ manufactures seven different products - P, Q, R, S, T, U and V. The following pie- charts give the product wise split-up of the total production, total expenses and total sales of the company in a year.

For any product,

$[\text{Profit} = \text{Sales (by value)} - \text{Expenses}]$

$[\text{Profitability (%)} = \dfrac{\text{Profit}}{\text{Sales (by value)}}×100]$

It is known that the company made a profit on each of its products and the units of any product sold in a year are only those that are manufactured in the same year.

Q. |
If the total sales were 1.5 times the total expenses, then for how many products was the profitability more than 25%? |

✖ A. |
2 |

✖ B. |
4 |

✔ C. |
5 |

✖ D. |
3 |

**Solution:**

Option(**C**) is correct

Edit:If the total sales were 1.5 times the expenses, then the value of expenses, sales and profitability for different products, assuming the total expenses to be 100. would be as follows:

Table below can be scrolled horizontally

Product | Expenses | Sales | Profitability |
---|---|---|---|

P |
10 |
18 |
44.4% |

Q |
13 |
18 |
28% |

R |
15 |
24 |
37.5% |

S |
16 |
21 |
24% |

T |
14 |
16.5 |
15% |

U |
12 |
25.5 |
53% |

V |
20 |
27 |
26% |

only for products P, Q, R, U and V, is the profitability is more than 25%.

So there are total **5** such products.

**Edit:** To see the calculations used to arrive at the table values, check comment by **Sneha.**

**Ajay**

*()
*

It is mentioned in the question that total sales were 1.5 times the expenses. Now, in the solution, total expenses are assumed to be 100. So, total sales would be 150.

Now, as per the sales chart (by value), we calculate the sales numbers.

For P,

Expenses = 10

Sales = 12% of 150

$=\dfrac{12*150}{100}$

$=18$

And

$[\text{Profitability (%)} = \dfrac{\text{Profit}}{\text{Sales (by value)}}×100]$

$=\dfrac{18-10}{18} * 100$

$=44.4\%$

Similarly we can calculate for other products as well and make the table as given in the solution.

How is the sale column taken?