IPMAT Indore 2025 · Quantitative Ability · Question 45

IPMAT Indore 2025 previous year question on Tables, with the answer and a step-by-step solution.

TablesData InterpretationMultiple choiceMedium

Set 2: E-commerce monthly sales and returns, 2024 — this question belongs to a set. Read the full set with all 5 questions →

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: Apparel	Sales: Footwear	Sales: Electronics	Returned %: Apparel	Returned %: Footwear	Returned %: 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?

A
September
B
July
C
June
D
March

Pick an option, then check.

Answer & solution

Answer: Option B

Step 1 — convert the percentage into a rupee value. The table gives returns as a percentage; the question asks for the value in lakhs:

Step 2 — compute for the four months offered.

Month	Footwear sales	Return rate	Value returned
September	118	9%	10.62
July	119	9%	10.71
June	111	5%	5.55
March	121	7%	8.47

Step 3 — compare. July and September share the same 9% rate, so the higher sales figure decides it: 119>118. March has the highest sales of the four (121) but a lower rate, and June’s 5% rate makes it the smallest.

Answer: Option 2 — July

IPMAT Indore 2025 · Quantitative Ability · Question 45

More Tables questions