CAT 2018 Slot 2 DILR Q10
- Data Interpretation and Logical Reasoning
- Data Interpretation › Tables
- Medium
- Multiple choice
- CAT_2018_SLOT2_DILR_Q10
Data set · questions 9–12
There are only four brands of entry level smartphones called Azra, Bysi, Cxqi, and Dipq in a country. Details about their market
share, unit selling price, and profitability (defined as the profit as a percentage of the revenue) for the year 2016 are given in the
table below:
| Brand | Market Share (%) | Unit Selling Price (Rs.) | Profitability (%) |
| Azra | 40 | 15,000 | 10 |
| Bysi | 25 | 20,000 | 30 |
| Cxqi | 15 | 30,000 | 40 |
| Dipq | 20 | 25,000 | 30 |
In 2017, sales volume of entry level smartphones grew by 40% as compared to that in 2016. Cxqi offered a 40% discount on its
unit selling price in 2017, which resulted in a 15% increase in its market share. Each of the other three brands lost 5% market
share. However, the profitability of Cxqi came down to half of its value in 2016. The unit selling prices of the other three brands
and their profitability values remained the same in 2017 as they were in 2016.
Question 10
The brand that had the highest profit in 2016 is:
Show answer and solution
Answer: (D)
Cxqi
Solution
Concept: Profitability Margin Application, Margin-Volume Tradeoff & Absolute Profit Maximization
Master State Table
| Brand & Year | Market Share (%) | Volume Sold (Base ) | Unit Selling Price (Rs.) | Revenue (Rs. ) | Profitability (%) | Total Profit (Rs. ) |
|---|---|---|---|---|---|---|
| Azra (2016) | 40% | 15,000 | 6,00,000 | 10% | 60,000 | |
| Azra (2017) | 35% | 15,000 | 7,35,000 | 10% | 73,500 | |
| Bysi (2016) | 25% | 20,000 | 5,00,000 | 30% | 1,50,000 | |
| Bysi (2017) | 20% | 20,000 | 5,60,000 | 30% | 1,68,000 | |
| Cxqi (2016) | 15% | 30,000 | 4,50,000 | 40% | 1,80,000 | |
| Cxqi (2017) | 30% | 18,000 | 7,56,000 | 20% | 1,51,200 | |
| Dipq (2016) | 20% | 25,000 | 5,00,000 | 30% | 1,50,000 | |
| Dipq (2017) | 15% | 25,000 | 5,25,000 | 30% | 1,57,500 | |
| Total (2016) | 100% | — | 20,50,000 | — | 5,40,000 | |
| Total (2017) | 100% | — | 25,76,000 | — | 5,50,200 |
Question Deduction
• Profit Margin Formulation:
• Profitability is defined as profit as a percentage of revenue:
$$\text{Profit} = \text{Revenue} \times \text{Profitability (\%)} = \text{Volume} \times \text{USP} \times \text{Margin}$$
• Equivalently, unit profit is .
• 2016 Brand-Wise Profit Computation:
• Applying profitability margins to 2016 revenues from the Master State Table:
• **Azra**: $6,00,000x \times 0.10 = \text{Rs. } 60,000x$.
• **Bysi**: $5,00,000x \times 0.30 = \text{Rs. } 1,50,000x$.
• **Dipq**: $5,00,000x \times 0.30 = \text{Rs. } 1,50,000x$.
• **Cxqi**: $4,50,000x \times 0.40 = \text{Rs. } 1,80,000x$.
• Comparative Ranking & Strategic Tradeoff:
• Ordering brands by 2016 profit in descending sequence:
$$\text{Profit}_{\text{Cxqi}} (1,80,000x) > \text{Profit}_{\text{Bysi}} (1,50,000x) = \text{Profit}_{\text{Dipq}} (1,50,000x) > \text{Profit}_{\text{Azra}} (60,000x)$$
• Cxqi generated the highest profit in 2016 ().
• Strategic tradeoff: Cxqi'''s price and margin yielded unit profit, eclipsing Azra'''s volume-heavy but thin margin ( unit profit).
• Option Matching / Numerical Answer:
• Matches Option 4 ("Cxqi").
• Distractors fail: Bysi (Option 1) and Dipq (Option 3) yield ; Azra (Option 2) yields .
Topper Take
• Unit profit shortcut: Profit per phone is Azra , Bysi , Cxqi , Dipq .
• Multiply by volume shares: Azra , Bysi , Dipq , Cxqi . Cxqi is highest in under 15 seconds.
Other questions in this set
- Q9. The brand that had the highest revenue in 2016 is:
- Q11. The brand that had the highest profit in 2017 is:
- Q12. The complete list of brands whose profits went up in 2017 from 2016 is:
Tables questions from other CAT papers
- CAT 2024 Slot 3 DILR Q10
- CAT 2024 Slot 3 DILR Q11
- CAT 2024 Slot 3 DILR Q12
- CAT 2024 Slot 3 DILR Q13
- CAT 2024 Slot 3 DILR Q19
Practise this question with timing, notes and your mistake notebook.
Practise in PrepSoc