CAT 2024 Slot 2 DILR Q17

  • Data Interpretation and Logical Reasoning
  • Data Interpretation › Scatter Plot
  • Easy
  • Multiple choice
  • CAT_2024_SLOT2_DILR_Q17

Data set · questions 14–17

The two plots below give the following information about six firms A, B, C, D, E, and F for 20192019 and 20232023.

PAT: The firm's profits after taxes in Rs. crores,

ES: The firm's employee strength, that is the number of employees in the firm, and

PRD: The percentage of the firm's PAT that they spend on Research and Development (R&D).

In the plots, the horizontal and vertical coordinates of point representing each firm gives their ES and PAT values respectively. The PRD values of each firm are proportional to the areas around the points representing each firm. The areas are comparable between the two plots, i.e., equal areas in the two plots represent the same PRD values for the two years.

Diagram

Question 17

Which among the firms C, D, E, and F had the least amount of R & D spending per employee in 2023?

  1. A

    Firm E

    Answer A in PrepSoc practice
  2. B

    Firm D

    Answer B in PrepSoc practice
  3. C

    Firm F

    Answer C in PrepSoc practice
  4. D

    Firm C

    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)

Firm D

Solution

Concept: Corporate Financial Metrics & Scatter Coordinate Analysis

Master State Table

FirmES '19PAT '19 (₹₹ Cr)PRD '19 (%)ES '23PAT '23 (₹₹ Cr)PRD '23 (%)PAT Growth (2023/20192023/2019)PAT / ES '23 (₹₹ Cr/Emp)Total R&D '23 (₹₹ Cr)R&D / ES '23 (₹₹ Cr/Emp)
A40204%4\%50305%5\%1.501.500.6000.6001.501.500.0300.030
B35255%5\%40456%6\%1.801.801.1251.1252.702.700.0680.068
C25309%9\%20602%2\%2.002.003.0003.0001.201.200.0600.060
D55356%6\%60403%3\%1.141.140.6670.6671.201.200.0200.020
E20106%6\%30507%7\%5.005.001.6671.6673.503.500.1170.117
F65557%7\%70708%8\%1.271.271.0001.0005.605.600.0800.080

Question Deduction

We determine which among the firms C,D,E,C, D, E, and FF had the least amount of R&D spending per employee in 2023.

• Metric Definition:

R&D per Employee=Total R&D2023ES2023=PAT2023×PRD2023ES2023×100\text{R\&D per Employee} = \frac{\text{Total R\&D}_{2023}}{\text{ES}_{2023}} = \frac{\text{PAT}_{2023} \times \text{PRD}_{2023}}{\text{ES}_{2023} \times 100}

• Computing Values for Candidate Firms:

• Firm C:

R&D=60×0.02=1.20 crore  ⟹  1.2020=0.060 crore/employee\text{R\&D} = 60 \times 0.02 = 1.20\text{ crore} \implies \frac{1.20}{20} = 0.060\text{ crore/employee}

• Firm D:

R&D=40×0.03=1.20 crore  ⟹  1.2060=0.020 crore/employee\text{R\&D} = 40 \times 0.03 = 1.20\text{ crore} \implies \frac{1.20}{60} = 0.020\text{ crore/employee}

• Firm E:

R&D=50×0.07=3.50 crore  ⟹  3.5030≈0.117 crore/employee\text{R\&D} = 50 \times 0.07 = 3.50\text{ crore} \implies \frac{3.50}{30} \approx 0.117\text{ crore/employee}

• Firm F:

R&D=70×0.08=5.60 crore  ⟹  5.6070=0.080 crore/employee\text{R\&D} = 70 \times 0.08 = 5.60\text{ crore} \implies \frac{5.60}{70} = 0.080\text{ crore/employee}

• Comparative Analysis:

Notice that Firm CC and Firm DD allocate identical total budgets to R&D (1.20 crore1.20\text{ crore}). However, Firm DD's expenditure is distributed across 6060 employees compared to Firm CC's 2020 employees, resulting in one-third the intensity (0.0200.020 vs 0.0600.060). This is the minimum among all candidate firms.

Therefore, Firm D had the least amount of R&D spending per employee in 2023 (Option 2).

Topper Take

• Numerator-Denominator Comparison: Between Firm C and Firm D, both spend identically 1.2 crore1.2\text{ crore} on R&D (60×0.02=40×0.03=1.260 \times 0.02 = 40 \times 0.03 = 1.2). Since Firm D has 33 times the employees (6060 vs 2020), Firm D immediately has the lower spend per employee (0.0200.020).

Other questions in this set

  1. Q14. Assume that the annual rate of growth in PAT over the previous year (ARG) remained constant over the years for each of…
  2. Q15. The ratio of the amount of money spent by Firm C on R&D in 2018 to that in 2023 is closest to
  3. Q16. Which among the firms A, C, E, and F had the maximum PAT per employee in 2023?

Scatter Plot questions from other CAT papers

  1. CAT 2025 Slot 2 DILR Q19
    What was the SI of E in 2016?
  2. CAT 2025 Slot 2 DILR Q20
    What was the SI of F in 2020?
  3. CAT 2025 Slot 2 DILR Q21
    What was the SI of C in 2024?
  4. CAT 2025 Slot 2 DILR Q22
    What was the SI of B in 2024?
  5. CAT 2022 Slot 2 DILR Q11
    Considering all three years, which company had the highest annual profit?

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

Practise in PrepSoc