• Practice
  • About 13 min
  • 5 practice questions

Mixed data sets and traps

Work with two related rows (revenue and cost), compute profit percentages and avoid common DI traps.

If something looks wrong, please tell us.

Harder DI sets give two linked series, such as revenue and cost, and ask you to derive a third, such as profit or profit percentage. Take care to use the right base.

The practice data

A company's quarterly figures (in lakh rupees)
QuarterRevenueCost
Q1800600
Q2900720
Q31000850
Q41200900

Profit = Revenue − Cost. So the profits are Q1: 200, Q2: 180, Q3: 150 and Q4: 300.

Worked example 1

Question: The total profit of the four quarters. Working: 200 + 180 + 150 + 300 = 830. Answer: ₹830 lakh.

Worked example 2

Question: Profit percentage in Q2, on cost. Working: 180 ÷ 720 × 100 = 25%. Answer: 25%.

Worked example 3: a trap

Question: In which quarter is the profit percentage on cost the highest? Working: Q1: 200 ÷ 600 = 33.3%. Q2: 25%. Q3: 150 ÷ 850 = 17.6%. Q4: 300 ÷ 900 = 33.3%. Q1 and Q4 are tied, even though Q4 has the largest profit in rupees. Answer: Q1 and Q4 are equal.

Highest profit in rupees is not the highest profit percentage. State the base, and compare like with like.

— Rule to remember

Key takeaways: derive the missing series first; note whether percentages are on cost or revenue; and watch for ties and look-alike options.

Check your understanding

  1. 1. Quarterly revenue and cost (₹ lakh): Q1 800 and 600, Q2 900 and 720, Q3 1,000 and 850, Q4 1,200 and 900. Profit = revenue − cost. What is the total revenue over the four quarters (₹ lakh)?

    1. 3,800
    2. 4,000
    3. 4,100
    4. 3,900
    Show answer

    Answer: D. 800 + 900 + 1,000 + 1,200 = 3,900.

  2. 2. Quarterly revenue and cost (₹ lakh): Q1 800 and 600, Q2 900 and 720, Q3 1,000 and 850, Q4 1,200 and 900. Profit = revenue − cost. Q4 profit is what percentage of Q4 revenue?

    1. 20%
    2. 25%
    3. 30%
    4. 33.3%
    Show answer

    Answer: B. Profit = 1,200 − 900 = 300; 300 ÷ 1,200 × 100 = 25%. (On cost it would be 33.3%, so read the base carefully.)

  3. 3. Quarterly revenue and cost (₹ lakh): Q1 800 and 600, Q2 900 and 720, Q3 1,000 and 850, Q4 1,200 and 900. Profit = revenue − cost. What is the percentage increase in cost from Q1 to Q2?

    1. 20%
    2. 15%
    3. 25%
    4. 30%
    Show answer

    Answer: A. (720 − 600) ÷ 600 × 100 = 120 ÷ 600 × 100 = 20%.

  4. 4. Quarterly revenue and cost (₹ lakh): Q1 800 and 600, Q2 900 and 720, Q3 1,000 and 850, Q4 1,200 and 900. Profit = revenue − cost. In which quarter is the profit percentage on cost the highest?

    1. Q4 alone
    2. Q2
    3. Q1 and Q4 equally
    4. Q3
    Show answer

    Answer: C. Q1: 200 ÷ 600 = 33.3%. Q2: 180 ÷ 720 = 25%. Q3: 150 ÷ 850 ≈ 17.6%. Q4: 300 ÷ 900 = 33.3%. Q1 and Q4 tie, although Q4 has the bigger profit in rupees.

  5. 5. Quarterly revenue and cost (₹ lakh): Q1 800 and 600, Q2 900 and 720, Q3 1,000 and 850, Q4 1,200 and 900. Profit = revenue − cost. What is the Q3 profit percentage on cost, to one decimal place?

    1. 15%
    2. 17.6%
    3. 20%
    4. 18.5%
    Show answer

    Answer: B. Profit = 1,000 − 850 = 150; 150 ÷ 850 × 100 ≈ 17.6%. (15% is profit on revenue, the wrong base.)

Privacy · Terms · Refunds · Delivery