Data Interpretation

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)
Month	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?

Only Electronics

Only Apparel

Both Apparel and Footwear

Only Footwear

✅ 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.

Question 26

Which month had highest percentage decline in monthly sales as compared to previous month for the Apparel category?

Question 28

By what percentage the net sales for June increased as compared to May in the Footwear category?

Question 29

Among the following four months, for which month the contribution of the Apparel category in the total monthly sales was the highest?

Question 30

Among the following four months, for which month the value of the Footwear returned (in lakhs of rupees) was the highest?

For which categories the value of the products returned (as a percentage of sales) increased for three consecutive months?

Solution

More from this set:

Keyboard Shortcuts

IPMAT Indore Past Year Questions (Topic-Wise)