IPMAT Indore 2025 · Quantitative Ability · Question 41
IPMAT Indore 2025 previous year question on Tables, with the answer and a step-by-step solution.
Set 2: E-commerce monthly sales and returns, 2024 — this question belongs to a set. Read the full set with all 5 questions →
The table given below provides the details of monthly sales (in lakhs of rupees) and the value of products returned by the customers (as a percentage of sales) of an e-commerce company for three product categories for the year 2024. Net sales (in lakhs of rupees) is defined as the difference between sales (in lakhs of rupees) and the value of products returned (in lakhs of rupees).
Month | Sales: Apparel | Sales: Footwear | Sales: Electronics | Returned %: Apparel | Returned %: Footwear | Returned %: Electronics |
|---|---|---|---|---|---|---|
January | 262 | 104 | 289 | 13% | 7% | 2% |
February | 279 | 113 | 387 | 16% | 9% | 3% |
March | 236 | 121 | 283 | 20% | 7% | 2% |
April | 258 | 58 | 325 | 16% | 8% | 1% |
May | 249 | 69 | 359 | 12% | 6% | 4% |
June | 230 | 111 | 321 | 19% | 5% | 3% |
July | 244 | 119 | 341 | 17% | 9% | 4% |
August | 252 | 60 | 336 | 16% | 6% | 2% |
September | 288 | 118 | 355 | 10% | 9% | 5% |
October | 222 | 108 | 383 | 15% | 8% | 2% |
November | 228 | 93 | 282 | 14% | 9% | 4% |
December | 221 | 86 | 268 | 18% | 10% | 1% |
Which month had highest percentage decline in monthly sales as compared to previous month for the Apparel category?
- A
June
- B
March
- C
December
- D
October
Answer & solution
Answer: Option D
Step 1 — only check the months where Apparel sales actually fell. Reading down the Apparel column: 262, 279, 236, 258, 249, 230, 244, 252, 288, 222, 228, 221.
Declines happen in March, May, June, October and December.
Step 2 — compute the percentage decline for each option.
|
Month |
Previous |
Current |
Decline |
|---|---|---|---|
|
March |
279 |
236 |
\frac{43}{279}=15.41\% |
|
June |
249 |
230 |
\frac{19}{249}=7.63\% |
|
October |
288 |
222 |
\frac{66}{288}=22.92\% |
|
December |
228 |
221 |
\frac{7}{228}=3.07\% |
Step 3 — October is clearly the largest. It follows September, the year’s peak month (288), and drops to the year’s near-low (222) — the biggest fall in both absolute and percentage terms.
Answer: Option 4 — October
More Tables questions
- Q42For which categories the value of the products returned (as a percentage of sales) increased for three consecutive…IPMAT Indore 2025 · Quantitative Ability · Tables
- Q43By what percentage the net sales for June increased as compared to May in the Footwear category?IPMAT Indore 2025 · Quantitative Ability · Tables
- Q44Among the following four months, for which month the contribution of the Apparel category in the total monthly sales…IPMAT Indore 2025 · Quantitative Ability · Tables
- Q45Among the following four months, for which month the value of the Footwear returned (in lakhs of rupees) was the…IPMAT Indore 2025 · Quantitative Ability · Tables
- Q13The highest possible age of an employee of company A is _____IPMAT Indore 2024 · Quantitative Ability · Tables
- Q14The median age of an employee across the eight companies is _____IPMAT Indore 2024 · Quantitative Ability · Tables
Take this paper as a timed test
Real exam timing, instant score, rank and topic-wise analysis.