CAT 2018 Slot 2 DILR Q9
- Data Interpretation and Logical Reasoning
- Data Interpretation › Tables
- Medium
- Multiple choice
- CAT_2018_SLOT2_DILR_Q09
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 9
The brand that had the highest revenue in 2016 is:
Show answer and solution
Answer: (A)
Azra
Solution
Concept: Volume-Price Revenue Formulation, Market Share Decomposition & Base Normalization
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
• Baseline Volume & Market Share Partition:
• Total market volume in 2016 is set to units.
• Market shares yield unit sales: Azra (), Bysi (), Cxqi (), and Dipq ().
• Sum of shares satisfies , confirming full market partition.
• 2016 Brand-Wise Revenue Computation:
• Revenue equals units sold multiplied by unit selling price ():
• **Azra**: $40x \times 15,000 = \text{Rs. } 6,00,000x$.
• **Bysi**: $25x \times 20,000 = \text{Rs. } 5,00,000x$.
• **Dipq**: $20x \times 25,000 = \text{Rs. } 5,00,000x$.
• **Cxqi**: $15x \times 30,000 = \text{Rs. } 4,50,000x$.
• Comparative Ranking & Revenue Drivers:
• Ordering 2016 revenues in descending sequence:
$$\text{Revenue}_{\text{Azra}} (6,00,000x) > \text{Revenue}_{\text{Bysi}} (5,00,000x) = \text{Revenue}_{\text{Dipq}} (5,00,000x) > \text{Revenue}_{\text{Cxqi}} (4,50,000x)$$
• Azra produced the highest revenue in 2016. Its high volume () outweighed its lower unit price ().
• Option Matching / Numerical Answer:
• Matches Option 1 ("Azra").
• Distractors fail: Bysi (Option 2) and Dipq (Option 3) tie at ; Cxqi (Option 4) records the lowest revenue () despite its premium price.
Topper Take
• Revenue index shortcut: Scale prices by and volume by to calculate relative indices: Azra is , Bysi is , Dipq is , Cxqi is .
• Azra'''s is immediately evident as the maximum in under 15 seconds without full multiplication.
Other questions in this set
- Q10. The brand that had the highest profit 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