IPMAT Indore 2025 · Quantitative Ability · Question 43

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%

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

A
62.58 percent
B
7.21 percent
C
18.97 percent
D
60.87 percent

Pick an option, then check.

Answer & solution

Answer: Option A

Step 1 — recall the definition given in the set.

\text{Net sales}=\text{Sales}-\text{Value returned}=\text{Sales}\times \left( 1-\text{return rate}\right)

Step 2 — May, Footwear. Sales 69, returns 6%:

69\times 0.94=64.86

Step 3 — June, Footwear. Sales 111, returns 5%:

111\times 0.95=105.45

Step 4 — percentage increase.

\frac{105.45-64.86}{64.86}\times 100=\frac{40.59}{64.86}\times 100\approx 62.58\%

Watch the trap: option 4 (60.87%) is the rise in gross sales alone (\frac{111-69}{69}). The question asks about net sales, so the return rates must be applied first.

Answer: Option 1 — 62.58 percent

IPMAT Indore 2025 · Quantitative Ability · Question 43

More Tables questions