IPMAT Indore 2025
DILR
Tabular Data
Medium
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 (in lakhs of rupees) | Value of products returned (as a percentage of sales) | ||||
|---|---|---|---|---|---|---|
| Apparel | Footwear | Electronics | Apparel | Footwear | 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% |
For which categories the value of the products returned (as a percentage of sales) increased for three consecutive months?
For which categories the value of the products returned (as a percentage of sales) increased for three consecutive months?
✅ Correct Option: 3
We need to identify which product categories had the value of products returned (as a percentage of sales) increase for three consecutive months.The concept here is to track each category's return percentage month by month and look for patterns where the percentage consistently rises over three consecutive months. An increase means the current month's return percentage is higher than the previous month's return percentage.
For Apparel, we see increases from January to February to March (13% → 16% → 20%), which gives us three consecutive months of increase.
For Footwear, we see increases from October to November to December (8% → 9% → 10%).
For Electronics, we don't see any sequence of three consecutive increases either.
The key insight is that we're looking for a pattern where each month's return percentage is strictly greater than the previous month's percentage for three consecutive months.Therefore, only the Apparel and Footwear category had the value of products returned (as a percentage of sales) increase for three consecutive months.
For Apparel, we see increases from January to February to March (13% → 16% → 20%), which gives us three consecutive months of increase.
For Footwear, we see increases from October to November to December (8% → 9% → 10%).
For Electronics, we don't see any sequence of three consecutive increases either.
The key insight is that we're looking for a pattern where each month's return percentage is strictly greater than the previous month's percentage for three consecutive months.Therefore, only the Apparel and Footwear category had the value of products returned (as a percentage of sales) increase for three consecutive months.
Related questions:
IPMAT Indore 2020