Skip to main contentSkip to solution

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.

Figure for CAT 2018 DILR question 20 (Data Interpretation)

During which month was the percentage increase in sales from the previous month’s sales the highest?

Solution

✅ Correct Option: 2

We need to find which month had the highest percentage increase compared to the previous month.

Percentage increase formula:

New Value−Old ValueOld Value×100\dfrac{\text{New Value} - \text{Old Value}}{\text{Old Value}} \times 100


From the chart, we have most monthly sales figures. We need to find the missing values for 2016.

For Q2 2016 (Apr, May, Jun): Forms arithmetic progression with Jun =500= 500 and quarter total =1440= 1440

Let Apr =a= a, May =a+d= a + d, Jun =a+2d=500= a + 2d = 500

Sum: 3a+3d=14403a + 3d = 1440, so a+d=480a + d = 480

Since a+2d=500a + 2d = 500, we get d=20d = 20

Therefore: Apr =460= 460, May =480= 480, Jun =500= 500

For Q4 2016 (Oct, Nov, Dec): Forms arithmetic progression with Dec =840= 840 and quarter total =2280= 2280

Let Oct =b= b, Nov =b+e= b + e, Dec =b+2e=840= b + 2e = 840

Sum: 3b+3e=22803b + 3e = 2280, so b+e=760b + e = 760

Since b+2e=840b + 2e = 840, we get e=80e = 80

Therefore: Oct =680= 680, Nov =760= 760, Dec =840= 840


Calculating percentage increases for each month:

2016:

• Feb: 320−240240×100=33.33%\dfrac{320 - 240}{240} \times 100 = 33.33\%

• Mar: 360−320320×100=12.50%\dfrac{360 - 320}{320} \times 100 = 12.50\%

• Apr: 460−360360×100=27.78%\dfrac{460 - 360}{360} \times 100 = 27.78\%

• May: 480−460460×100=4.35%\dfrac{480 - 460}{460} \times 100 = 4.35\%

• Jun: 500−480480×100=4.17%\dfrac{500 - 480}{480} \times 100 = 4.17\%

• Jul: 600−500500×100=20.00%\dfrac{600 - 500}{500} \times 100 = 20.00\%

• Aug: 680−600600×100=13.33%\dfrac{680 - 600}{600} \times 100 = 13.33\%

• Sep: 720−680680×100=5.88%\dfrac{720 - 680}{680} \times 100 = 5.88\%

• Oct: 680−720720×100=−5.56%\dfrac{680 - 720}{720} \times 100 = -5.56\% (decrease)

• Nov: 760−680680×100=11.76%\dfrac{760 - 680}{680} \times 100 = 11.76\%

• Dec: 840−760760×100=10.53%\dfrac{840 - 760}{760} \times 100 = 10.53\%

2017:

• Jan: 900−840840×100=7.14%\dfrac{900 - 840}{840} \times 100 = 7.14\%

• Feb: 960−900900×100=6.67%\dfrac{960 - 900}{900} \times 100 = 6.67\%

• Mar: 1020−960960×100=6.25%\dfrac{1020 - 960}{960} \times 100 = 6.25\%

• Apr: 1080−10201020×100=5.88%\dfrac{1080 - 1020}{1020} \times 100 = 5.88\%

• May: 1140−10801080×100=5.56%\dfrac{1140 - 1080}{1080} \times 100 = 5.56\%

• Jun: 1200−11401140×100=5.26%\dfrac{1200 - 1140}{1140} \times 100 = 5.26\%

• Jul: 1320−12001200×100=10.00%\dfrac{1320 - 1200}{1200} \times 100 = 10.00\%

• Aug: 1400−13201320×100=6.06%\dfrac{1400 - 1320}{1320} \times 100 = 6.06\%

• Sep: 1480−14001400×100=5.71%\dfrac{1480 - 1400}{1400} \times 100 = 5.71\%

• Oct: 1560−14801480×100=5.41%\dfrac{1560 - 1480}{1480} \times 100 = 5.41\%

• Nov: 1620−15601560×100=3.85%\dfrac{1620 - 1560}{1560} \times 100 = 3.85\%

• Dec: 1680−16201620×100=3.70%\dfrac{1680 - 1620}{1620} \times 100 = 3.70\%


The highest percentage increase is 33.33%33.33\% in February 2016.

Therefore, February 2016 had the highest percentage increase in sales from the previous month.

Keyboard Shortcuts

  • Left arrow: Previous question
  • Right arrow: Next question
  • S key: Jump to solution
  • Q key: Jump to question