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:

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 9

The brand that had the highest revenue in 2016 is:

  1. A

    Azra

    Answer A in PrepSoc practice
  2. B

    Bysi

    Answer B in PrepSoc practice
  3. C

    Dipq

    Answer C in PrepSoc practice
  4. D

    Cxqi

    Answer D in PrepSoc practice

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

Show answer and solution

Answer: (A)

Azra

Solution

Concept: Volume-Price Revenue Formulation, Market Share Decomposition & Base Normalization

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

• Baseline Volume & Market Share Partition:

• Total market volume in 2016 is set to V2016=100xV_{2016} = 100x units.

• Market shares yield unit sales: Azra (40x40x), Bysi (25x25x), Cxqi (15x15x), and Dipq (20x20x).

• Sum of shares satisfies 40%+25%+15%+20%=100%40\% + 25\% + 15\% + 20\% = 100\%, confirming full market partition.

• 2016 Brand-Wise Revenue Computation:

• Revenue equals units sold multiplied by unit selling price (Revenue=Volume×USP\text{Revenue} = \text{Volume} \times \text{USP}):

• **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 (40x40x) outweighed its lower unit price (Rs. 15,000\text{Rs. } 15,000).

• Option Matching / Numerical Answer:

• Matches Option 1 ("Azra").

• Distractors fail: Bysi (Option 2) and Dipq (Option 3) tie at Rs. 5,00,000x\text{Rs. } 5,00,000x; Cxqi (Option 4) records the lowest revenue (Rs. 4,50,000x\text{Rs. } 4,50,000x) despite its premium price.

Topper Take

• Revenue index shortcut: Scale prices by 1,0001,000 and volume by xx to calculate relative indices: Azra is 40×15=60040 \times 15 = 600, Bysi is 25×20=50025 \times 20 = 500, Dipq is 20×25=50020 \times 25 = 500, Cxqi is 15×30=45015 \times 30 = 450.

• Azra'''s 600600 is immediately evident as the maximum in under 15 seconds without full multiplication.

Other questions in this set

  1. Q10. The brand that had the highest profit in 2016 is:
  2. Q11. The brand that had the highest profit in 2017 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