CAT 2019 Slot 2 DILR Q4

  • Data Interpretation and Logical Reasoning
  • Data Interpretation › Radar Chart
  • Medium
  • Multiple choice
  • CAT_2019_SLOT2_DILR_Q04

Data set · questions 1–4

A large store has only three departments, Clothing, Produce, and Electronics. The following figure shows the percentages of revenue an cost from the three departments for the years 2016, 20172017 and 2018. The dotted lines depict percentage levels. So for example, in 2016, 50%50\% of store's revenue came from its Electronics department while 40%40 \% of its costs were incurred in the Produce department.

Revenue by department
Cost by department

In this setup, Profit is computed as (Revenue - Cost) and Percentage Profit as Profit/Cost ×100%\times 100 \%.

It is known that

  1. The percentage profit for the store in 20162016 was 100%100 \%.

  2. The store's revenue doubled from 20162016 to 2017, and its cost doubled from 20162016 to 20182018.

  3. There was no profit from the Electronics department in 20172017.

  4. In 2018, the revenue from the Clothing department was the same as the cost incurred in the Produce department.

Question 4

What was the approximate difference in profit percentages of the store in 2017 and 2018?

  1. A

    8.3

    Answer A in PrepSoc practice
  2. B

    15.5

    Answer B in PrepSoc practice
  3. C

    25.0

    Answer C in PrepSoc practice
  4. D

    33.3

    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)

8.3

Solution

Concept: Comparative Longitudinal Margin Analysis & Break-Even Constraint Resolution

Master State Table

Year & MetricClothingProduceElectronicsTotal StoreProfit Margin
2016 Revenue40 (20%)60 (30%)100 (50%)200 (100%)—
2016 Cost30 (30%)40 (40%)30 (30%)100 (100%)—
2016 Profit+10+20+70+100+100.0%
2017 Revenue120 (30%)160 (40%)120 (30%)400 (100%)—
2017 Cost90 (30%)90 (30%)120 (40%)300 (100%)—
2017 Profit+30+700+100+33.33%
2018 Revenue100 (40%)100 (40%)50 (20%)250 (100%)—
2018 Cost40 (20%)100 (50%)60 (30%)200 (100%)—
2018 Profit+600-10+50+25.0%

Question Deduction

• 2017 Profit Percentage Derivation:

• Normalized base parameters: {2016} = 100and2016=200 and {2016} = 200 index units.

• Revenue doubled from toto: {2017} = 2 \times 200 = 400$.

• Electronics generated %ofof revenue: {\text{Electronics}, 2017} = 30% \times 400 = 120$.

• Clue 3 states zero profit from Electronics in $, so cost equals revenue:

63231C_{\text{Electronics}, 2017} = R_{\text{Electronics}, 2017} = 12063231

• Since Electronics accounted for %oftotalcostsinof total costs in:

632310.40 \times C_{2017} = 120 \implies C_{2017} = \frac{120}{0.40} = 30063231

• Store profit in is2017−C2017=400−300=100 is {2017} - C_{2017} = 400 - 300 = 100.

• Profit percentage in $:

63231\text{Percentage Profit}_{2017} = \frac{100}{300} \times 100\% = \frac{1}{3} \times 100\% \approx 33.33\%63231

• 2018 Profit Percentage Derivation:

• Total cost doubled from toto, giving {2018} = 2 \times 100 = 200$.

• Produce cost in is%×200=100 is \% \times 200 = 100.

• Clue 4 equates Clothing revenue to Produce cost in :Clothing,2018=100: {\text{Clothing}, 2018} = 100.

• With Clothing generating %ofrevenue:2018=100/0.40=250 of revenue: {2018} = 100 / 0.40 = 250.

• Store profit in is2018−C2018=250−200=50 is {2018} - C_{2018} = 250 - 200 = 50.

• Profit percentage in $:

63231\text{Percentage Profit}_{2018} = \frac{50}{200} \times 100\% = 25.00\%63231

• Profit Percentage Difference Computation:

• Computing the absolute difference in profit percentages:

63231\Delta = ert 33.33\% - 25.00\% ert = 8.33\% \approx 8.3\%63231

• Option Matching / Numerical Answer:

• Matches Option 1 ("8.3").

• Distractors fail: Option 3 (.0)istheunadjusted) is the unadjusted margin, Option 4 (.3)isthe) is the margin, and Option 2 (.5$) is an arithmetic error.

Topper Take

• Beware of intermediate value traps: options .0and.3 and .3 represent the individual margins for andand respectively.

• Always verify the question stem asks for the difference: calculating .33% - 25.00% = 8.33%$ directly eliminates traps in under 30 seconds.

Other questions in this set

  1. Q1. What was the percentage profit of the store in 2018 ?
  2. Q2. What was the ratio of revenue generated from the Produce department in 2017 to that in 2018?
  3. Q3. What percentage of the total profits for the store in 2016 was from the Electronics department?

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

Practise in PrepSoc