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% |
Among the following four months, for which month the contribution of the Apparel category in the total monthly sales was the highest?
Among the following four months, for which month the contribution of the Apparel category in the total monthly sales was the highest?
✅ Correct Option: 2
The contribution of Apparel to Total Sales is calculated as:
Let's find the total sales for each month by adding sales from all three categories:
Now let's calculate the exact contribution percentage for each month:
Conceptual understanding:Contribution percentage measures what portion of the total monthly revenue comes from the Apparel category.Even though January had higher absolute Apparel sales (262 vs 258), April had proportionally lower sales from other categories, making Apparel's share of the total pie larger.Therefore, April had the highest contribution of Apparel category to total monthly sales at 40.25%.
Let's find the total sales for each month by adding sales from all three categories:
| Month | Apparel Sales | Footwear Sales | Electronics Sales | Total Sales |
|---|---|---|---|---|
| January | 262 | 104 | 289 | 655 |
| April | 258 | 58 | 325 | 641 |
| August | 252 | 60 | 336 | 648 |
| December | 221 | 86 | 268 | 575 |
Now let's calculate the exact contribution percentage for each month:
| Month | Apparel Sales | Total Sales | Calculation | Contribution % |
|---|---|---|---|---|
| January | 262 | 655 | 40.00% | |
| April | 258 | 641 | 40.25% | |
| August | 252 | 648 | 38.89% | |
| December | 221 | 575 | 38.43% |
Conceptual understanding:Contribution percentage measures what portion of the total monthly revenue comes from the Apparel category.Even though January had higher absolute Apparel sales (262 vs 258), April had proportionally lower sales from other categories, making Apparel's share of the total pie larger.Therefore, April had the highest contribution of Apparel category to total monthly sales at 40.25%.
Related questions:
IPMAT Indore 2020