CAT 2022 Slot 2 DILR Q14

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

Data set · questions 11–15

The two plots below show data for four companies code-named A, B, C, and D over three years - 2019, 2020, and 20212021. The first plot shows the revenues and costs incurred by the companies during these years. For example, in 2021, company C earned Rs. 100100 crores in revenue and spent Rs. 3030 crores. The profit of a company is defined as its revenue minus its costs.

Diagram

The second plot shows the number of employees employed by the company (employee strength) at the start of each of these three years, as well as the number of new employees hired each year (new hires). For example, Company B had 250250 employees at the start of 2021, and 3030 new employees joined the company during the year.

Diagram

Question 14

The total number of employees lost in 2019 and 2020 was the least for:

  1. A

    Company C

    Answer A in PrepSoc practice
  2. B

    Company B

    Answer B in PrepSoc practice
  3. C

    Company A

    Answer C in PrepSoc practice
  4. D

    Company D

    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)

Company B

Solution

Concept: Scatter Plot Coordinate Extraction, Financial Metrics & Workforce Attrition Flow

Master State Table

CompanyYearRevenue (₹ Cr)Cost (₹ Cr)Annual Profit (₹ Cr)Profit/Cost RatioStart Strength (SS)New Hires (HH)End StrengthEmployees Lost (S+H−SnextS+H-S_{\text{next}})
A2019908555/85≈0.0595/85 \approx 0.05940050350100
A202070551515/55≈0.27315/55 \approx 0.2733503032060
A202180602020/60≈0.33320/60 \approx 0.33332030——
B2019100752525/75≈0.33325/75 \approx 0.3332204024020
B202090504040/50=0.80040/50 = 0.8002402025010
B202175453030/45≈0.66730/45 \approx 0.66725030——
C2019232033/20=0.1503/20 = 0.15080309020
C202040202020/20=1.00020/20 = 1.000902510015
C2021100307070/30≈2.33370/30 \approx 2.333100———
D201950401010/40=0.25010/40 = 0.2501503012060
D20202050-30 (Loss 30)Negative1201010030
D202160402020/40=0.50020/40 = 0.500100———

Question Deduction

• Workforce Flow Balance Equation:

• For any year tt:

$$S_{t+1} = S_t + H_t - L_t \implies L_t = S_t + H_t - S_{t+1}$$

• Where StS_t is starting strength, HtH_t is new hires, and LtL_t is employees lost (attrition).

• Total lost over 2019 and 2020:

$$L_{\text{total}} = L_{2019} + L_{2020} = (S_{2019} + H_{2019} - S_{2020}) + (S_{2020} + H_{2020} - S_{2021}) = S_{2019} + H_{2019} + H_{2020} - S_{2021}$$

• Calculating for Each Company:

• Company A:

• $S_{2019} = 400, H_{2019} = 50, H_{2020} = 30, S_{2021} = 320$.

• $L_{\text{total}} = 400 + 50 + 30 - 320 = 160$.

• Company B:

• $S_{2019} = 220, H_{2019} = 40, H_{2020} = 20, S_{2021} = 250$.

• $L_{\text{total}} = 220 + 40 + 20 - 250 = 30$.

• Company C:

• $S_{2019} = 80, H_{2019} = 30, H_{2020} = 25, S_{2021} = 100$.

• $L_{\text{total}} = 80 + 30 + 25 - 100 = 35$.

• Company D:

• $S_{2019} = 150, H_{2019} = 30, H_{2020} = 10, S_{2021} = 100$.

• $L_{\text{total}} = 150 + 30 + 10 - 100 = 90$.

• Comparison:

• The least number of employees lost is 30, belonging to Company B.

• Option Matching:

• Matches Option 2 (Company B).

Topper Take

• Telescoping Sum: Total lost =S19+H19+H20−S21= S_{19} + H_{19} + H_{20} - S_{21}. For Company B: 220+40+20−250=30220 + 40 + 20 - 250 = 30, which is the minimum.

Other questions in this set

  1. Q11. Considering all three years, which company had the highest annual profit?
  2. Q12. Which of the four companies experienced the highest annual loss in any of the years?
  3. Q13. The ratio of a company's annual profit to its annual costs is a measure of its performance. Which of the four…
  4. Q15. Profit per employee is the ratio of a company's profit to its employee strength. For this purpose, the employee…

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 2024 Slot 2 DILR Q14
    Assume that the annual rate of growth in PAT over the previous year (ARG) remained constant over the years…

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

Practise in PrepSoc