IPMAT Indore 2025
DILR
Tabular Data
Easy
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% |
Which month had highest percentage decline in monthly sales as compared to previous month for the Apparel category?
Which month had highest percentage decline in monthly sales as compared to previous month for the Apparel category?
✅ Correct Option: 4
We don't need to calculate exact percentages - we can compare the fractions directly to find the largest one.
From the Apparel sales data, let's identify consecutive months where sales decreased:
February -> March:September -> October:
Comparing via fractions -> March: and October: - October has a numerator (66) that is about 1.5 times larger than March's numerator (43)- October has a denominator (288) that is only about 1.03 times larger than March's denominator (279)Since the numerator grows much faster than the denominator, October's fraction is larger than March's fraction .
October had the highest percentage decline in Apparel sales, dropping from 288 lakhs in September to 222 lakhs in October.
From the Apparel sales data, let's identify consecutive months where sales decreased:
| Month Transition | Sales Change (Lakhs) | Change Type | Analysis |
|---|---|---|---|
| January → February | 262 → 279 | Increase (+17) | - |
| February → March | 279 → 236 | Decrease (-43) | Significant decrease - Consider |
| March → April | 236 → 258 | Increase (+22) | - |
| April → May | 258 → 249 | Decrease (-9) | Ignore - Minimal decrease while in the 250s range |
| May → June | 249 → 230 | Decrease (-19) | Ignore - Same reason as May |
| June → July | 230 → 244 | Increase (+14) | - |
| July → August | 244 → 252 | Increase (+8) | - |
| August → September | 252 → 288 | Increase (+36) | - |
| September → October | 288 → 222 | Decrease (-66) | Much higher decrease - Consider with March |
| October → November | 222 → 228 | Increase (+6) | - |
| November → December | 228 → 221 | Decrease (-7) | Ignore - Same reason as May |
February -> March:September -> October:
Comparing via fractions -> March: and October: - October has a numerator (66) that is about 1.5 times larger than March's numerator (43)- October has a denominator (288) that is only about 1.03 times larger than March's denominator (279)Since the numerator grows much faster than the denominator, October's fraction is larger than March's fraction .
October had the highest percentage decline in Apparel sales, dropping from 288 lakhs in September to 222 lakhs in October.
Related questions:
IPMAT Indore 2020