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:

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 10

The brand that had the highest profit in 2016 is:

  1. A

    Bysi

    Answer A in PrepSoc practice
  2. B

    Azra

    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: (D)

Cxqi

Solution

Concept: Profitability Margin Application, Margin-Volume Tradeoff & Absolute Profit Maximization

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

• 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 USP×Profitability (%)\text{USP} \times \text{Profitability (\%)}.

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

• Strategic tradeoff: Cxqi'''s Rs. 30,000\text{Rs. } 30,000 price and 40%40\% margin yielded Rs. 12,000\text{Rs. } 12,000 unit profit, eclipsing Azra'''s volume-heavy but thin 10%10\% margin (Rs. 1,500\text{Rs. } 1,500 unit profit).

• Option Matching / Numerical Answer:

• Matches Option 4 ("Cxqi").

• Distractors fail: Bysi (Option 1) and Dipq (Option 3) yield Rs. 1,50,000x\text{Rs. } 1,50,000x; Azra (Option 2) yields Rs. 60,000x\text{Rs. } 60,000x.

Topper Take

• Unit profit shortcut: Profit per phone is Azra =1,500= 1,500, Bysi =6,000= 6,000, Cxqi =12,000= 12,000, Dipq =7,500= 7,500.

• Multiply by volume shares: Azra =60= 60, Bysi =150= 150, Dipq =150= 150, Cxqi =180= 180. Cxqi is highest in under 15 seconds.

Other questions in this set

  1. Q9. The brand that had the highest revenue 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