CAT 2020 Slot 2 DILR Q18
- Data Interpretation and Logical Reasoning
- Data Interpretation › Tables
- Medium
- Multiple choice
- CAT_2020_SLOT2_DILR_Q18
Data set · questions 17–20
A chain of departmental stores has outlets in Delhi, Mumbai, Bengaluru and Kolkata. The sales are categorized by its three departments - 'Apparel', 'Electronics', and 'HomeDecor'. An Accountant has been asked to prepare a summary of the 2018 and 2019 sales amounts for an internal report. He has collated partial information and prepared the following table.
| Delhi | Mumbai | Bengaluru | Kolkata | |||||
| Sales Amounts (Crore Rupees) | 2018 | 2019 | 2018 | 2019 | 2018 | 2019 | 2018 | 2019 |
| Apparels | 54 | |||||||
| Electronics | 78 | 98 | 82 | 102 | 90 | 70 | 80 | 100 |
| Home Decor | 100 | 72 | 80 | 54 | ||||
The following additional information is known.
- The sales amounts in the Apparel departments were the same for Delhi and Kolkata in2018.
- The sales amounts in the Apparel departments were the same for Mumbai and Bengaluru in 2018. This sales amount matched the sales amount in the Apparel department for Delhi in2019.
- The sales amounts in the Home Decor departments were the same for Mumbai and Kolkata in 2018.
- The sum of the sales amounts of four Electronics departments increased by the same amount as the sum of the sales amounts of four Apparel departments from 2018 to 2019.
- The total sales amounts of the four Home Decor departments increased by Rs 70 Crores from 2018 to 2019.
- The sales amounts in the Home Decor departments of Delhi and Bengaluru each increased by Rs 20 Crores from 2018 to 2019.
- The sales amounts in the Apparel departments of Delhi and Bengaluru each increased by the same amount in 2019 from 2018. The sales amounts in the Apparel departments of Mumbai and Kolkata also each increased by the same amount in 2019 from 2018.
- The sales amounts in the Apparel departments of Delhi, Kolkata and Bengaluru in 2019 followed an Arithmetic Progression.
Question 18
What was the increase in sales amount, in Crore Rupees, in the Apparel department of Mumbai from 2018 to 2019?
Show answer and solution
Answer: (D)
12
Solution
Concept: Multi-Variable Algebraic Systems, Arithmetic Progression Constraints & Departmental Growth Mapping
Master State Table
| Department | Delhi (2018 / 2019) | Mumbai (2018 / 2019) | Bengaluru (2018 / 2019) | Kolkata (2018 / 2019) | Total (2018 / 2019) |
|---|---|---|---|---|---|
| Apparels | 42 / 50 (+19.05%) | 50 / 62 (+24.00%) | 50 / 58 (+16.00%) | 42 / 54 (+28.57%) | 184 / 224 (+21.74%) |
| Electronics | 78 / 98 (+25.64%) | 82 / 102 (+24.39%) | 90 / 70 (-22.22%) | 80 / 100 (+25.00%) | 330 / 370 (+12.12%) |
| Home Decor | 80 / 100 (+25.00%) | 48 / 72 (+50.00%) | 60 / 80 (+33.33%) | 48 / 54 (+12.50%) | 236 / 306 (+29.66%) |
| Total Sales | 200 / 248 (+24.00%) | 180 / 236 (+31.11%) | 200 / 208 (+4.00%) | 170 / 208 (+22.35%) | 750 / 900 (+20.00%) |
Question Deduction
• Electronics and Apparel Growth Linkage:
• Total Electronics sales: and Crore Crore.
• By Clue 4, total increase in Apparel sales across all four cities is also Crore.
• Apparel Variable Setup & Increments:
• Clue 1: Let 2018 Apparel sales for Delhi and Kolkata be .
• Clue 2: Let 2018 Apparel sales for Mumbai and Bengaluru be , which also equals Delhi 2019 Apparel sales.
• Clue 7 establishes paired equal increments:
• Delhi increase is $y - x \implies \text{Bengaluru}_{2019} = y + (y - x) = 2y - x$.
• Kolkata increase is $54 - x \implies \text{Mumbai}_{2019} = y + (54 - x) = y - x + 54$.
• Solving the Linear System:
• Clue 8: Delhi (), Kolkata (), and Bengaluru () form an AP in 2019:
$$54 - y = (2y - x) - 54 \implies x = 3y - 108 \quad \text{--- (1)}$$
• Clue 4: Total Apparel growth is 40 Crore:
$$2(y - x) + 2(54 - x) = 40 \implies 2x - y = 34 \quad \text{--- (2)}$$
• Substituting (1) into (2):
$$2(3y - 108) - y = 34 \implies 5y = 250 \implies y = 50, \quad x = 42$$
• Computing Mumbai Apparel Increase:
• By Clue 7, Mumbai Apparel increase equals Kolkata Apparel increase:
$$\Delta A_{\text{Mumbai}} = 54 - x = 54 - 42 = 12\text{ Crore}$$
• Consistently, Mumbai Apparel sales rose from to Crore ( Crore).
• Option Matching:
• Matches Option 4 (12).
• Distractor check: Option 1 (10) violates AP spacing; Option 2 (5) violates 40 Crore total growth; Option 3 (8) is the increase for Delhi/Bengaluru ().
Topper Take
• Clue 7 equates Mumbai's Apparel increase to Kolkata's increase: . Once is solved from the 2-variable AP system, Crore is obtained instantly.
• Avoid computing Mumbai's 2019 absolute value (); evaluating the delta () directly saves critical exam time.
Other questions in this set
- Q17. In the Home Decor departments, which cities had the highest sales amounts in 2018 and 2019, respectively?
- Q19. Among all the 12 departments (i.e., the 3 departments in each of the 4 cities), what was the maximum percentage…
- Q20. What was the total sales amount, in Crore Rupees, in 2019 for the chain of departmental stores?
Tables questions from other CAT papers
- CAT 2024 Slot 3 DILR Q10
- CAT 2024 Slot 3 DILR Q11
- CAT 2024 Slot 3 DILR Q12
- CAT 2024 Slot 3 DILR Q13
- CAT 2024 Slot 3 DILR Q19
Practise this question with timing, notes and your mistake notebook.
Practise in PrepSoc