Ghar-Tak Retail sells groceries through four channels: its physical Stores, its Website, Phone orders, and a mobile App. The table below shows the company's total sales in each quarter of 2020 (in ₹ crore) and the percentage share of each channel in that quarter's sales. The national lockdown began towards the end of Q1, which explains the sharp shift between channels in Q2.
| Quarter | Total sales (₹ crore) | Stores (%) | Website (%) | Phone (%) | App (%) |
|---|---|---|---|---|---|
| Q1 | 200 | 60 | 20 | 10 | 10 |
| Q2 | 160 | 25 | 40 | 15 | 20 |
| Q3 | 240 | 35 | 35 | 10 | 20 |
| Q4 | 300 | 40 | 30 | 5 | 25 |
Assume that the shares add up to exactly 100% in each quarter and that all sales figures are exact.
| Quarter | Total sales (₹ crore) | Stores (%) | Website (%) | Phone (%) | App (%) |
|---|---|---|---|---|---|
| Q1 | 200 | 60 | 20 | 10 | 10 |
| Q2 | 160 | 25 | 40 | 15 | 20 |
| Q3 | 240 | 35 | 35 | 10 | 20 |
| Q4 | 300 | 40 | 30 | 5 | 25 |
Assume that the shares add up to exactly 100% in each quarter and that all sales figures are exact.
Question 1
Numerical answer
In how many quarters of 2020 did Website sales exceed ₹80 crore?
Show answer and solution
Answer: 2
Channel-wise sales (₹ crore):
| Quarter | Stores | Website | Phone | App |
|---|---|---|---|---|
| Q1 | 120 | 40 | 20 | 20 |
| Q2 | 40 | 64 | 24 | 32 |
| Q3 | 84 | 84 | 24 | 48 |
| Q4 | 120 | 90 | 15 | 75 |
| 2020 | 364 | 278 | 83 | 175 |
Website sales: Q1 = 40, Q2 = 64, Q3 = 84, Q4 = 90. Only Q3 and Q4 exceed ₹80 crore, so the answer is 2.
Trap: Q2 has the highest Website *share* (40%), but its total is the smallest, so its value is only ₹64 crore.
| Quarter | Stores | Website | Phone | App |
|---|---|---|---|---|
| Q1 | 120 | 40 | 20 | 20 |
| Q2 | 40 | 64 | 24 | 32 |
| Q3 | 84 | 84 | 24 | 48 |
| Q4 | 120 | 90 | 15 | 75 |
| 2020 | 364 | 278 | 83 | 175 |
Website sales: Q1 = 40, Q2 = 64, Q3 = 84, Q4 = 90. Only Q3 and Q4 exceed ₹80 crore, so the answer is 2.
Trap: Q2 has the highest Website *share* (40%), but its total is the smallest, so its value is only ₹64 crore.
Question 2
Single correct option
By approximately what percentage did Stores sales fall from Q1 to Q2?
- A. 35%
- B. 58.3%
- C. 66.7%
- D. 75%
Show answer and solution
Answer: (C) 66.7%
Stores sales: Q1 = 60% of 200 = ₹120 crore; Q2 = 25% of 160 = ₹40 crore.
Fall = (120 − 40)/120 × 100 = 66.67%.
Trap: the share fell from 60 to 25, i.e. by 35 percentage points (58.3% of the share), but the total also fell, so the value fell by more — 66.67%.
Fall = (120 − 40)/120 × 100 = 66.67%.
Trap: the share fell from 60 to 25, i.e. by 35 percentage points (58.3% of the share), but the total also fell, so the value fell by more — 66.67%.
Question 3
Single correct option
Which channel recorded the highest percentage increase in sales from Q2 to Q4?
- A. Stores
- B. Website
- C. Phone
- D. App
Show answer and solution
Answer: (A) Stores
Q2 → Q4 values (₹ crore):
- Stores: 40 → 120, +200%
- Website: 64 → 90, +40.6%
- Phone: 24 → 15, a fall
- App: 32 → 75, +134.4%
Stores had the highest percentage increase. Stores recovered sharply after the lockdown, from a very low Q2 base.
- Stores: 40 → 120, +200%
- Website: 64 → 90, +40.6%
- Phone: 24 → 15, a fall
- App: 32 → 75, +134.4%
Stores had the highest percentage increase. Stores recovered sharply after the lockdown, from a very low Q2 base.
Question 4
Single correct option
For the year 2020 as a whole, App sales were approximately what percentage of the company's total sales?
- A. 18.75%
- B. 19.4%
- C. 20.5%
- D. 17.8%
Show answer and solution
Answer: (B) 19.4%
Annual total = 200 + 160 + 240 + 300 = ₹900 crore.
App sales = 20 + 32 + 48 + 75 = ₹175 crore.
Share = 175/900 × 100 ≈ 19.4%.
Trap: averaging the four quarterly shares, (10 + 20 + 20 + 25)/4 = 18.75%, is wrong because the quarters have different totals. A simple average of shares is valid only when the bases are equal.
App sales = 20 + 32 + 48 + 75 = ₹175 crore.
Share = 175/900 × 100 ≈ 19.4%.
Trap: averaging the four quarterly shares, (10 + 20 + 20 + 25)/4 = 18.75%, is wrong because the quarters have different totals. A simple average of shares is valid only when the bases are equal.
Question 5
Numerical answer
In Q1 of 2021, total sales were 10% higher than in Q4 of 2020. The Stores share was 50%, the Phone share stayed the same as in Q4 of 2020, and App sales (in ₹ crore) were exactly the same as in Q4 of 2020. What were the Website sales in Q1 of 2021 (in ₹ crore)?
Show answer and solution
Answer: 73.5
Q1 2021 total = 1.1 × 300 = ₹330 crore.
- Stores = 50% of 330 = 165
- Phone = 5% of 330 = 16.5 (the same *share* as in Q4 2020)
- App = ₹75 crore (the same *value* as in Q4 2020, 25% of 300)
Website = 330 − 165 − 16.5 − 75 = 73.5.
Tip: watch whether each condition fixes a share or a value. That difference is the whole point of the question.
- Stores = 50% of 330 = 165
- Phone = 5% of 330 = 16.5 (the same *share* as in Q4 2020)
- App = ₹75 crore (the same *value* as in Q4 2020, 25% of 300)
Website = 330 − 165 − 16.5 − 75 = 73.5.
Tip: watch whether each condition fixes a share or a value. That difference is the whole point of the question.
Saved on this device. Sign in or create a free account to keep it on every device.