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%

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

September

July

June

March

✅ Correct Option: 2

The value of products returned is given as a percentage of sales, so we need to calculate the actual value in lakhs of rupees using:

$\text{Value of products returned} = \dfrac{\text{Return percentage}}{100} \times \text{Sales}$

Month	Calculation	Value Returned (lakhs)
September	$\frac{9}{100} \times 118$	$10.62$
July	$\frac{9}{100} \times 119$	$10.71$
June	$\frac{5}{100} \times 111$	$5.55$
March	$\frac{7}{100} \times 121$	$8.47$

July has the highest value of products returned.

The value of returns depends on both the return percentage and the total sales volume.

July -> combines a high return percentage (9%) with substantial sales (119 lakhs), creating the largest absolute return amount.

September -> percentage is the same but the sales is lower.

June -> sales is around the same but percentage is almost half.

March -> percentage is 2% lower and sales are only 2 lakh more than July, which is 119 -> 121, it is definitely lower than 2 percent.

Question 26

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

Question 27

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

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?

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

Solution

More from this set:

Keyboard Shortcuts

IPMAT Indore Past Year Questions (Topic-Wise)