CAT 2020 Slot 2 DILR Q20

  • Data Interpretation and Logical Reasoning
  • Data Interpretation › Tables
  • Medium
  • Multiple choice
  • CAT_2020_SLOT2_DILR_Q20

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.

DelhiMumbaiBengaluruKolkata
Sales Amounts (Crore Rupees)20182019201820192018201920182019
Apparels54
Electronics789882102907080100
Home Decor100728054


The following additional information is known.
  1. The sales amounts in the Apparel departments were the same for Delhi and Kolkata in2018.
  2. 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.
  3. The sales amounts in the Home Decor departments were the same for Mumbai and Kolkata in 2018.
  4. 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.
  5. The total sales amounts of the four Home Decor departments increased by Rs 70 Crores from 2018 to 2019.
  6. The sales amounts in the Home Decor departments of Delhi and Bengaluru each increased by Rs 20 Crores from 2018 to 2019.
  7. 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.
  8. The sales amounts in the Apparel departments of Delhi, Kolkata and Bengaluru in 2019 followed an Arithmetic Progression.

Question 20

What was the total sales amount, in Crore Rupees, in 2019 for the chain of departmental stores?

  1. A

    600

    Answer A in PrepSoc practice
  2. B

    150

    Answer B in PrepSoc practice
  3. C

    750

    Answer C in PrepSoc practice
  4. D

    900

    Answer D in PrepSoc practice

Answer this questionOr tap an option. Opens in practice mode, free, no sign-in.

Show answer and solution

Answer: (D)

900

Solution

Concept: Macro-Level Aggregation, Multi-Axis Reconciliation & Chain-Wide Revenue Accounting

Master State Table

DepartmentDelhi (2018 / 2019)Mumbai (2018 / 2019)Bengaluru (2018 / 2019)Kolkata (2018 / 2019)Total (2018 / 2019)
Apparels42 / 50 (+19.05%)50 / 62 (+24.00%)50 / 58 (+16.00%)42 / 54 (+28.57%)184 / 224 (+21.74%)
Electronics78 / 98 (+25.64%)82 / 102 (+24.39%)90 / 70 (-22.22%)80 / 100 (+25.00%)330 / 370 (+12.12%)
Home Decor80 / 100 (+25.00%)48 / 72 (+50.00%)60 / 80 (+33.33%)48 / 54 (+12.50%)236 / 306 (+29.66%)
Total Sales200 / 248 (+24.00%)180 / 236 (+31.11%)200 / 208 (+4.00%)170 / 208 (+22.35%)750 / 900 (+20.00%)

Question Deduction

• Department-Wise Revenue Aggregation for 2019:

• The chain's total 2019 sales is the sum of all three departments across all four cities:

• Apparels 2019: Delhi (50) + Mumbai (62) + Bengaluru (58) + Kolkata (54) =224= 224 Crore.

• Electronics 2019: Delhi (98) + Mumbai (102) + Bengaluru (70) + Kolkata (100) =370= 370 Crore.

• Home Decor 2019: Delhi (100) + Mumbai (72) + Bengaluru (80) + Kolkata (54) =306= 306 Crore.

• Summing across the three departments:

$$\text{Total Sales}_{2019} = 224 + 370 + 306 = 900\text{ Crore}$$

• City-Wise Dual-Axis Cross-Verification:

• Summing across cities for 2019:

• Delhi Total: $50 + 98 + 100 = 248$ Crore

• Mumbai Total: $62 + 102 + 72 = 236$ Crore

• Bengaluru Total: $58 + 70 + 80 = 208$ Crore

• Kolkata Total: $54 + 100 + 54 = 208$ Crore

• Network total: 248+236+208+208=900248 + 236 + 208 + 208 = 900 Crore, perfectly corroborating the departmental sum.

• Macro Growth Accounting Reconciliation:

• 2018 baseline sales: 184 (Apparel)+330 (Electronics)+236 (Home Decor)=750184\text{ (Apparel)} + 330\text{ (Electronics)} + 236\text{ (Home Decor)} = 750 Crore.

• Net growth increments: ΔA=40\Delta A = 40, ΔE=40\Delta E = 40, ΔH=70  ⟹  ΔTotal=150\Delta H = 70 \implies \Delta \text{Total} = 150 Crore.

• Total sales in 2019: 750+150=900750 + 150 = 900 Crore.

• Option Matching:

• Matches Option 4 (900).

• Distractor check: Option 1 (600) undercounts revenue; Option 2 (150) is the net increase from 2018 to 2019 (900−750=150900 - 750 = 150), not total sales; Option 3 (750) is the total sales in 2018.

Topper Take

• Macro Triage: Electronics 2019 (370370) and Home Decor 2019 (306306) sum to 676 Crore. Adding Apparel 2019 must push the total well above 676 Crore, eliminating 600, 150, and leaving only 750 or 900.

• Since 4 Apparel outlets easily exceed 4×50=2004 \times 50 = 200 Crore, the total must exceed 676+200=876676 + 200 = 876 Crore, making 900 the only possible answer. Option 3 (750) is the 2018 base and Option 2 (150) is the net increase.

Other questions in this set

  1. Q17. In the Home Decor departments, which cities had the highest sales amounts in 2018 and 2019, respectively?
  2. Q18. What was the increase in sales amount, in Crore Rupees, in the Apparel department of Mumbai from 2018 to 2019?
  3. Q19. Among all the 12 departments (i.e., the 3 departments in each of the 4 cities), what was the maximum percentage…

Tables questions from other CAT papers

  1. CAT 2024 Slot 3 DILR Q10
    Which one among the countries 1 through 8, has the smallest population in 2024?
  2. CAT 2024 Slot 3 DILR Q11
    The ratio of Country 4’s GDP to Country 5’s GDP in 2026 will be closest to
  3. CAT 2024 Slot 3 DILR Q12
    Which one among the countries 1, 4, 5, and 7 will have the largest population in 2027?
  4. CAT 2024 Slot 3 DILR Q13
    For how many countries among Country 1 through Country 8 will the GDP per capita in 2027 be lower than that…
  5. CAT 2024 Slot 3 DILR Q19
    How many foodgrains had a higher amount of carbohydrate per 100 grams of nutrients than M1?

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

Practise in PrepSoc