CAT 2018 Slot 1 DILR Q20
- Data Interpretation and Logical Reasoning
- Data Interpretation › Other Charts
- Easy
- Multiple choice
- CAT_2018_SLOT1_DILR_Q20
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.
Question 20
During which month was the percentage increase in sales from the previous month’s sales the highest?
Show answer and solution
Answer: (B)
October of 2017
Solution
Concept: Month-over-Month Growth Velocity, Sequential Delta Evaluation & Fractional Reciprocal Mapping
Master State Table
| Quarter | Month | 2016 Sales (Units) | 2017 Sales (Units) |
|---|---|---|---|
| Q1 | January | 80 | 120 |
| Q1 | February | 60 | 100 |
| Q1 | March | 100 | 160 |
| Q1 Total | Quarterly Aggregate | 240 | 380 |
| Q2 | April | 40 | 60 |
| Q2 | May | 50 (AP) | 75 |
| Q2 | June | 60 (AP) | 65 |
| Q2 Total | Quarterly Aggregate | 150 | 200 |
| Q3 | July | 75 | 60 |
| Q3 | August | 120 | 90 (Balance) |
| Q3 | September | 55 | 70 |
| Q3 Total | Quarterly Aggregate | 250 | 220 |
| Q4 | October | 100 | 150 |
| Q4 | November | 120 (AP) | 170 |
| Q4 | December | 140 (AP) | 180 (Balance) |
| Q4 Total | Quarterly Aggregate | 360 | 500 |
| Annual Total | Full Year Aggregate | 1,000 | 1,300 |
Question Deduction
• Month-over-Month Growth Velocity Formula:
• The percentage increase from the previous month is calculated as:
$\text{Growth Rate} = \frac{\text{Sales}_m - \text{Sales}_{m-1}}{\text{Sales}_{m-1}} \times 100\%$.
• The four options evaluate four specific month-over-month transitions across 2016-2017.
• Evaluation of Candidate Options:
• March of 2017 (Option 1):
• February 2017 100$; March 2017 160$; $\Delta = 60$.
• $\text{Growth Rate} = \frac{60}{100} \times 100\% = 60.00\%$.
• October of 2017 (Option 2):
• September 2017 70$; October 2017 150$; $\Delta = 80$.
• $\text{Growth Rate} = \frac{80}{70} \times 100\% = \frac{8}{7} \times 100\% = \left(1 + \frac{1}{7}\right) \times 100\% \approx 114.29\%$.
• March of 2016 (Option 3):
• February 2016 60$; March 2016 100$; $\Delta = 40$.
• $\text{Growth Rate} = \frac{40}{60} \times 100\% = \frac{2}{3} \times 100\% \approx 66.67\%$.
• October of 2016 (Option 4):
• September 2016 55$; October 2016 100$; $\Delta = 45$.
• $\text{Growth Rate} = \frac{45}{55} \times 100\% = \frac{9}{11} \times 100\% \approx 81.82\%$.
• Option Matching / Numerical Answer:
• Ranking growth rates: .
• October 2017 is the sole month where sales more than doubled ( increase).
• Confirms Option 2 as the correct choice.
Topper Take
• Apply the doubling filter: identify if sales more than doubled (). October 2017 jumped from (), making it the only month exceeding %$ growth.
• The remaining candidates all fall below %, March 2016 at .7%), securing the answer in 10 seconds without division.
Other questions in this set
- Q17. What is the percentage increase in sales in December 2017 as compared to the sales in December 2016?
- Q18. In which quarter of 2017 was the percentage increase in sales from the same quarter of 2016 the highest?
- Q19. During which quarter was the percentage decrease in sales from the previous quarter’s sales the highest?
Other Charts questions from other CAT papers
- CAT 2025 Slot 1 DILR Q1
- CAT 2025 Slot 1 DILR Q2
- CAT 2025 Slot 1 DILR Q3
- CAT 2025 Slot 1 DILR Q4
- CAT 2025 Slot 3 DILR Q6
Practise this question with timing, notes and your mistake notebook.
Practise in PrepSoc