Applyo - College Application Platform

CAT 2022 Slot 2 DILR Question & Solution

Data InterpretationEasy

Data Set

The two plots below show data for four companies code-named A, B, C, and D over three years - 2019, 2020, and 2021.

The first plot shows the revenues and costs incurred by the companies during these years. For example, in 2021, company C earned Rs.100 crores in revenue and spent Rs.30 crores. The profit of a company is defined as its revenue minus its costs

Question Figure

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 250 employees at the start of 2021, and 30 new employees joined the company during the year.

Question Figure

Question 1

Considering all three years, which company had the highest annual profit?

Company A
Company D
Company B
Company C
Solution:

It is given,

Question Figure

Company A:

Revenue = 240 and cost incurred = 180

Profit = 240 - 180 = 60

Company B:

Revenue = 220 and cost incurred = 145

Profit = 220 - 145 = 75

Company C:

Revenue = 195 and cost incurred = 110

Profit = 195 - 110 = 85

Company D:

Revenue = 140 and cost incurred = 160

No profit.

Company C had the highest annual profit.

The answer is option D.

Question 2

Which of the four companies experienced the highest annual loss in any of the years?

Company C
Company A
Company B
Company D
Solution:
Question Figure

For all the companies in all three years, cost incurred is less than Revenue except for D in 2020.

Revenue is 20 and cost incurred is 50

Company D experienced the highest annual loss in 2020.

The answer is option D.

Question 3

The ratio of a company's annual profit to its annual costs is a measure of its performance. Which of the four companies had the lowest value of this ratio in 2019?

Company A
Company D
Company B
Company C
Solution:

It is given,

Question Figure

Measure of A's performance in 2019 = $\frac{90-85}{85}=\frac{5}{85}=0.06$

Measure of B's performance in 2019 = $\frac{100-75}{75}=\frac{25}{75}=0.33$

Measure of C's performance in 2019 = $\frac{25-20}{25}=\frac{5}{25}=0.2$

Measure of D's performance in 2019 = $\frac{50-40}{40}=\frac{10}{40}=0.25$

Company A had the lowest value.

The answer is option A.

Question 4

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

Company B
Company D
Company A
Company C
Solution:

It is given,

Question Figure

Company A:

The number of employees in the beginning of 2019 = 150

The number of employees hired in 2019 = 20

The number of employees should be at the beginning of 2020 is 150+20, i.e. 170 but there are 140 only. This implies 30 left company A in 2019.

The number of employees in the beginning of 2020 = 140

The number of employees hired in 2020 = 35

The number of employees should be at the beginning of 2021 is 140+35, i.e. 175 but there are 150 only. This implies 25 left company A in 2020.

The number of employees left company A in 2019 and 2020 = 30 + 25 = 55

Company B:

Similarly, the number of employees left company B in 2019 = 210 + 35 - 240 = 5

The number of employees left company B in 2020 = 240 + 45 - 250 = 35

The number of employees left company B in 2019 and 2020 = 5 + 35 = 40

Company C:

Similarly, the number of employees left company C in 2019 = 320 + 45 - 320 = 45

The number of employees left company C in 2020 = 320 + 40 - 320 = 40

The number of employees left company C in 2019 and 2020 = 45 + 40 = 85

Company D:

Similarly, the number of employees left company D in 2019 = 400 + 30 - 410 = 20

The number of employees left company D in 2020 = 410 + 35 - 400 = 45

The number of employees left company D in 2019 and 2020 = 20 + 45 = 65

The total number of employees lost in 2019 and 2020 is least for company B.

The answer is option A.

Question 5

Profit per employee is the ratio of a company's profit to its employee strength. For this purpose, the employee strength in a year is the average of the employee strength at the beginning of that year and the beginning of the next year. In 2020, which of the four companies had the highest profit per employee?

Company D
Company C
Company B
Company A
Solution:

It is given,

Question Figure Question Figure


Company A = $\frac{90-65}{145}=\frac{25}{145}=\frac{50}{290}$

Company B = $\frac{90-40}{245}=\frac{50}{245}$

Company C = $\frac{70-60}{320}=\frac{10}{320}$

Company B had the highest profit per employee.

The answer is option C.