CAT 2018 Slot 2 DILR Q11
- Data Interpretation and Logical Reasoning
- Data Interpretation › Tables
- Medium
- Multiple choice
- CAT_2018_SLOT2_DILR_Q11
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 11
The brand that had the highest profit in 2017 is:
Show answer and solution
Answer: (B)
Bysi
Solution
Concept: Market Growth Scaling, Price Elasticity Shock & Inter-Temporal Profit Optimization
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
• 2017 Volume Expansion & Market Share Shifts:
• Total volume expanded by to units.
• Cxqi gained percentage points share (); others lost each:
• **Azra**: $35\% \times 140x = 49x$.
• **Bysi**: $20\% \times 140x = 28x$.
• **Cxqi**: $30\% \times 140x = 42x$.
• **Dipq**: $15\% \times 140x = 21x$.
• 2017 Brand-Wise Profit Computation:
• Cxqi discounted USP to and margin to ; others kept 2016 values.
• Calculating 2017 profits ():
• **Azra**: $49x \times 15,000 \times 0.10 = \text{Rs. } 73,500x$.
• **Bysi**: $28x \times 20,000 \times 0.30 = \text{Rs. } 1,68,000x$.
• **Cxqi**: $42x \times 18,000 \times 0.20 = \text{Rs. } 1,51,200x$.
• **Dipq**: $21x \times 25,000 \times 0.30 = \text{Rs. } 1,57,500x$.
• Comparative Ranking & Profit Maximization:
• Ordering brands by 2017 profit in descending sequence:
$$\text{Profit}_{\text{Bysi}} (1,68,000x) > \text{Profit}_{\text{Dipq}} (1,57,500x) > \text{Profit}_{\text{Cxqi}} (1,51,200x) > \text{Profit}_{\text{Azra}} (73,500x)$$
• Bysi achieved the highest profit in 2017 ().
• Option Matching / Numerical Answer:
• Matches Option 2 ("Bysi").
• Distractors fail: Dipq (Option 4) yields ; Cxqi (Option 1) yields ; Azra (Option 3) yields .
Topper Take
• Discount trap: Cxqi'''s volume surged to , but unit profit collapsed to (a drop), lowering profit.
• Fast comparison: Comparing margin brands, Bysi'''s index is vs Dipq'''s . Bysi wins in 15 seconds.
Other questions in this set
- Q9. The brand that had the highest revenue in 2016 is:
- Q10. The brand that had the highest profit in 2016 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