CAT 2019 Slot 2 DILR Q1

  • Data Interpretation and Logical Reasoning
  • Data Interpretation › Radar Chart
  • Medium
  • Type in the answer (TITA)
  • CAT_2019_SLOT2_DILR_Q01

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 1

What was the percentage profit of the store in 20182018?

Type-in-the-answer (TITA) question: no options are given; enter the value.

Answer this question Opens in practice mode, free, no sign-in.

Show answer and solution

Answer:

25

Solution

Concept: Multi-Variable System Normalization, Ternary Proportion Mapping & Aggregate Profitability

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

• Baseline Normalization & Cost Escalation:

• The ternary plots depict departmental percentage shares summing to %$ each year.

• Setting base totalcostas2016=100 total cost as {2016} = 100 index units.

• Clue 1 (%profitmargininprofit margin in) establishes:

63231R_{2016} = C_{2016} \times (1 + 1.00) = 20063231

• Clue 2 dictates that total cost doubled from toto:

63231C_{2018} = 2 \times C_{2016} = 2 \times 100 = 20063231

• 2018 Departmental Cost Allocation:

• Reading the costternarychartyieldsdepartmentalsharesof% cost ternary chart yields departmental shares of \% Clothing, %Produce,and% Produce, and \% Electronics:

• Cost of Produce: {\text{Produce}, 2018} = 50\% \times 200 = 100$.

• Cost of Clothing: {\text{Clothing}, 2018} = 20\% \times 200 = 40$.

• Cost of Electronics: {\text{Electronics}, 2018} = 30\% \times 200 = 60$.

• 2018 Revenue & Profit Derivation:

• Clue 4 couples revenue and cost across departments: in $, Clothing revenue equaled Produce cost:

63231R_{\text{Clothing}, 2018} = C_{\text{Produce}, 2018} = 10063231

• From the revenueternarychart,Clothingaccountsfor% revenue ternary chart, Clothing accounts for \% of total revenue:

632310.40 \times R_{2018} = 100 \implies R_{2018} = \frac{100}{0.40} = 25063231

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

• Percentage profit of the store in $:

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

• Option Matching / Numerical Answer:

• The overall store profit percentage in equals% equals \%.

• Confirms numerical TITA answer of $.

Topper Take

• Chaining clues directly bypasses irrelevant years: {2016} (100) o C_{2018} (200) o C_{\text{Produce}, 2018} (100) o R_{\text{Clothing}, 2018} (100) o R_{2018} (250)determinesdetermines profitability without solving $.

• With {2018} / C_{2018} = 250 / 200 = 1.25,the0%, the 0\% margin emerges mentally in under 45 seconds.

Other questions in this set

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

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

Practise in PrepSoc