- 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
| Quarter | Revenue | Cost |
|---|---|---|
| Q1 | 800 | 600 |
| Q2 | 900 | 720 |
| Q3 | 1000 | 850 |
| Q4 | 1200 | 900 |
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.
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. 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)?
- 3,800
- 4,000
- 4,100
- 3,900
Show answer
Answer: D. 800 + 900 + 1,000 + 1,200 = 3,900.
-
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?
- 20%
- 25%
- 30%
- 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. 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?
- 20%
- 15%
- 25%
- 30%
Show answer
Answer: A. (720 − 600) ÷ 600 × 100 = 120 ÷ 600 × 100 = 20%.
-
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?
- Q4 alone
- Q2
- Q1 and Q4 equally
- 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. 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?
- 15%
- 17.6%
- 20%
- 18.5%
Show answer
Answer: B. Profit = 1,000 − 850 = 150; 150 ÷ 850 × 100 ≈ 17.6%. (15% is profit on revenue, the wrong base.)
Sign in to keep track of the lessons you finish.