CAT 2019 Slot 2 DILR Q3

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

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 3

What percentage of the total profits for the store in 20162016 was from the Electronics department?

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:

70

Solution

Concept: Departmental Profit Decomposition & Component Contribution Ratio

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

• 2016 Baseline Parameters & Total Profit:

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

• Clue 1 states that the store achieved a %percentageprofitinpercentage profit in:

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

• Total store profit in $ is:

63231\text{Total Profit}_{2016} = R_{2016} - C_{2016} = 200 - 100 = 10063231

• Electronics Department Profit Breakdown:

• From the revenueternarychart,Electronicsaccountedfor% revenue ternary chart, Electronics accounted for \% of total revenue:

63231R_{\text{Electronics}, 2016} = 50\% \times 200 = 10063231

• From the costternarychart,Electronicsaccountedfor% cost ternary chart, Electronics accounted for \% of total cost:

63231C_{\text{Electronics}, 2016} = 30\% \times 100 = 3063231

• Profit generated specifically by Electronics:

63231\text{Profit}_{\text{Electronics}, 2016} = 100 - 30 = 7063231

• Contribution Percentage & Cross-Check:

• Computing Electronics share of the store's total profit:

63231\text{Contribution} = \frac{\text{Profit}_{\text{Electronics}, 2016}}{\text{Total Profit}_{2016}} \times 100\% = \frac{70}{100} \times 100\% = 70\%63231

• Conservation check: Clothing profit is - 30 = 10(% (\%) and Produce profit is - 40 = 20(% (\%); their sum + 20 + 70 = 100$ confirms total consistency.

• Option Matching / Numerical Answer:

• The Electronics department contributed exactly %oftotalstoreprofitsinof total store profits in.

• Confirms numerical TITA answer of $.

Topper Take

• Normalizing base cost to makestotalprofit−100=100 makes total profit - 100 = 100, so any department's absolute profit index directly equals its percentage share of total profit.

• Direct mental math: {\text{Electronics}} = 0.50 \times 200 = 100,Electronics=0.30×100=30  ⟹  100−30=70, {\text{Electronics}} = 0.30 \times 100 = 30 \implies 100 - 30 = 70 in under 20 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. 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