IPMAT Indore 2025 · Quantitative Ability · Question 42
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% |
- AOnly Electronics
- BOnly Apparel
- CBoth Apparel and Footwear
- DOnly Footwear
Answer & solution
Answer: Option C
Step 1 — read this straight off the percentage columns (no calculation needed — the table already gives returns as a percentage of sales).
Apparel: 13, 16, 20, 16, 12, 19, 17, 16, 10, 15, 14, 18
\text{Jan}13\to \text{Feb}16\to \text{Mar}20
Three consecutive months rising. ✓
Footwear: 7, 9, 7, 8, 6, 5, 9, 6, 9, 8, 9, 10
\text{Oct}8\to \text{Nov}9\to \text{Dec}10
Three consecutive months rising. ✓
Electronics: 2, 3, 2, 1, 4, 3, 4, 2, 5, 2, 4, 1
The longest rise anywhere is a single step (e.g. Jan→Feb, Apr→May). Never three in a row. ✗
Step 2 — conclude. Apparel and Footwear both show a three-month climb; Electronics does not.
Answer: Option 3 — Both Apparel and Footwear
More Tables questions
- Q41Which month had highest percentage decline in monthly sales as compared to previous month for the Apparel category?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.