CAT 2018 Slot 1 DILR Q18

  • Data Interpretation and Logical Reasoning
  • Data Interpretation › Other Charts
  • Easy
  • Multiple choice
  • CAT_2018_SLOT1_DILR_Q18

Data set · questions 17–20

The multi-layered pie-chart below shows the sales of LED television sets for a big retail electronics outlet during 2016 and 2017. The outer layer shows the monthly sales during this period, with each label showing the month followed by sales figure of that month. For some months, the sales figures are not given in the chart. The middle-layer shows quarterwise aggregate sales figures (in some cases, aggregate quarter-wise sales numbers are not given next to the quarter). The innermost layer shows annual sales. It is known that the sales figures during the three months of the second quarter (April, May, June) of 2016 form an arithmetic progression, as do the three monthly sales figures in the fourth quarter (October, November, December) of that year.

Diagram

Question 18

In which quarter of 2017 was the percentage increase in sales from the same quarter of 2016 the highest?

  1. A

    Q2

    Answer A in PrepSoc practice
  2. B

    Q1

    Answer B in PrepSoc practice
  3. C

    Q4

    Answer C in PrepSoc practice
  4. D

    Q3

    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)

Q1

Solution

Concept: Multi-Layer Pie-Chart Aggregation, Year-over-Year (YoY) Quarterly Growth & Ratio Comparison

Master State Table

QuarterMonth2016 Sales (Units)2017 Sales (Units)
Q1January80120
Q1February60100
Q1March100160
Q1 TotalQuarterly Aggregate240380
Q2April4060
Q2May50 (AP)75
Q2June60 (AP)65
Q2 TotalQuarterly Aggregate150200
Q3July7560
Q3August12090 (Balance)
Q3September5570
Q3 TotalQuarterly Aggregate250220
Q4October100150
Q4November120 (AP)170
Q4December140 (AP)180 (Balance)
Q4 TotalQuarterly Aggregate360500
Annual TotalFull Year Aggregate1,0001,300

Question Deduction

• Quarterly Aggregate Sales Derivations:

• Q1: = 80 + 60 + 100 = 240;=120+100+160=380; = 120 + 100 + 160 = 380 units.

• Q2: = 150(giveninchart;APwith=10 (given in chart; AP with =10 gives , 50, 60);=60+75+65=200); = 60 + 75 + 65 = 200 units.

• Q3: = 75 + 120 + 55 = 250;=220; = 220 (given in chart).

• Q4: = 360(giveninchart;APwith=20 (given in chart; AP with =20 gives , 120, 140);=500); = 500 (given in chart).

• Year-over-Year Growth Evaluation Across All Quarters:

• Q1: Δ=380−240=140\Delta = 380 - 240 = 140; Growth=140240×100%=712×100%≈58.33%\text{Growth} = \frac{140}{240} \times 100\% = \frac{7}{12} \times 100\% \approx 58.33\%.

• Q2: Δ=200−150=50\Delta = 200 - 150 = 50; Growth=50150×100%=13×100%≈33.33%\text{Growth} = \frac{50}{150} \times 100\% = \frac{1}{3} \times 100\% \approx 33.33\%.

• Q3: Δ=220−250=−30\Delta = 220 - 250 = -30; contraction of .00%$, eliminated immediately.

• Q4: Δ=500−360=140\Delta = 500 - 360 = 140; Growth=140360×100%=718×100%≈38.89%\text{Growth} = \frac{140}{360} \times 100\% = \frac{7}{18} \times 100\% \approx 38.89\%.

• Comparative Analysis & Option Matching:

• Ranking positive growth: Q1(58.33%)>Q4(38.89%)>Q2(33.33%)\text{Q1} (58.33\%) > \text{Q4} (38.89\%) > \text{Q2} (33.33\%).

• Option 1 (Q2): .33%$, lower than Q1.

• Option 2 (Q1): .33%$, strictly the highest percentage increase.

• Option 3 (Q4): .89%$, lower than Q1.

• Option 4 (Q3): Negative growth (569X12%$), lowest.

• Confirms Option 2 as the correct choice.

Topper Take

• Observe the numerators: Q1 and Q4 both grew by exactly units(−240=140 units ( - 240 = 140 vs - 360 = 140).Withidenticalnumerators,thesmallerbasedenominator(<360). With identical numerators, the smaller base denominator ( < 360) guarantees the higher growth rate (\frac{140}{240} > \frac{140}{360}).

• Eliminating Q3 (dropped from toto) and noting Q2 grew by only /3$ leaves Q1 as a 15-second visual deduction.

Other questions in this set

  1. Q17. What is the percentage increase in sales in December 2017 as compared to the sales in December 2016?
  2. Q19. During which quarter was the percentage decrease in sales from the previous quarter’s sales the highest?
  3. Q20. During which month was the percentage increase in sales from the previous month’s sales the highest?

Other Charts questions from other CAT papers

  1. CAT 2025 Slot 1 DILR Q1
    How much is Japan's export to India worth?
  2. CAT 2025 Slot 1 DILR Q2
    Which among the following is the highest?
  3. CAT 2025 Slot 1 DILR Q3
    What is the trade surplus/trade deficit of India with UK?
  4. CAT 2025 Slot 1 DILR Q4
    Among France and UK, who has/have trade surplus(es) with US?
  5. CAT 2025 Slot 3 DILR Q6
    Who had solved the largest number of puzzles by the 20-th minute from the start of the competition?

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

Practise in PrepSoc