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:

BrandMarket Share (%)Unit Selling Price (Rs.)Profitability (%)
Azra4015,00010
Bysi2520,00030
Cxqi1530,00040
Dipq2025,00030

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:

  1. A

    Cxqi

    Answer A in PrepSoc practice
  2. B

    Bysi

    Answer B in PrepSoc practice
  3. C

    Azra

    Answer C in PrepSoc practice
  4. D

    Dipq

    Answer D in PrepSoc practice

Answer this questionOr tap an option. Opens in practice mode, free, no sign-in.

Show answer and solution

Answer: (B)

Bysi

Solution

Concept: Market Growth Scaling, Price Elasticity Shock & Inter-Temporal Profit Optimization

Master State Table

Brand & YearMarket Share (%)Volume Sold (Base 100x100x)Unit Selling Price (Rs.)Revenue (Rs. xx)Profitability (%)Total Profit (Rs. xx)
Azra (2016)40%40x40x15,0006,00,00010%60,000
Azra (2017)35%49x49x15,0007,35,00010%73,500
Bysi (2016)25%25x25x20,0005,00,00030%1,50,000
Bysi (2017)20%28x28x20,0005,60,00030%1,68,000
Cxqi (2016)15%15x15x30,0004,50,00040%1,80,000
Cxqi (2017)30%42x42x18,0007,56,00020%1,51,200
Dipq (2016)20%20x20x25,0005,00,00030%1,50,000
Dipq (2017)15%21x21x25,0005,25,00030%1,57,500
Total (2016)100%100x100x—20,50,000—5,40,000
Total (2017)100%140x140x—25,76,000—5,50,200

Question Deduction

• 2017 Volume Expansion & Market Share Shifts:

• Total volume expanded by 40%40\% to V2017=140xV_{2017} = 140x units.

• Cxqi gained 15%15\% percentage points share (30%30\%); others lost 5%5\% 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 Rs. 18,000\text{Rs. } 18,000 and margin to 20%20\%; others kept 2016 values.

• Calculating 2017 profits (Volume×USP×Margin\text{Volume} \times \text{USP} \times \text{Margin}):

• **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 (Rs. 1,68,000x\text{Rs. } 1,68,000x).

• Option Matching / Numerical Answer:

• Matches Option 2 ("Bysi").

• Distractors fail: Dipq (Option 4) yields Rs. 1,57,500x\text{Rs. } 1,57,500x; Cxqi (Option 1) yields Rs. 1,51,200x\text{Rs. } 1,51,200x; Azra (Option 3) yields Rs. 73,500x\text{Rs. } 73,500x.

Topper Take

• Discount trap: Cxqi'''s volume surged to 42x42x, but unit profit collapsed to Rs. 3,600\text{Rs. } 3,600 (a 70%70\% drop), lowering profit.

• Fast comparison: Comparing 30%30\% margin brands, Bysi'''s index is 28×20=56028 \times 20 = 560 vs Dipq'''s 21×25=52521 \times 25 = 525. Bysi wins in 15 seconds.

Other questions in this set

  1. Q9. The brand that had the highest revenue in 2016 is:
  2. Q10. The brand that had the highest profit in 2016 is:
  3. Q12. The complete list of brands whose profits went up in 2017 from 2016 is:

Tables questions from other CAT papers

  1. CAT 2024 Slot 3 DILR Q10
    Which one among the countries 1 through 8, has the smallest population in 2024?
  2. CAT 2024 Slot 3 DILR Q11
    The ratio of Country 4’s GDP to Country 5’s GDP in 2026 will be closest to
  3. CAT 2024 Slot 3 DILR Q12
    Which one among the countries 1, 4, 5, and 7 will have the largest population in 2027?
  4. CAT 2024 Slot 3 DILR Q13
    For how many countries among Country 1 through Country 8 will the GDP per capita in 2027 be lower than that…
  5. CAT 2024 Slot 3 DILR Q19
    How many foodgrains had a higher amount of carbohydrate per 100 grams of nutrients than M1?

Practise this question with timing, notes and your mistake notebook.

Practise in PrepSoc