The table below presents the quarterly administrative software licensing costs (in ₹ Lakhs) for four governmental departments during the fiscal year 2025-26:
| Department | Q1 | Q2 | Q3 | Q4 |
|---|---|---|---|---|
| Dept A | 45 | 50 | 60 | 55 |
| Dept B | 30 | 35 | 40 | 45 |
| Dept C | 80 | 75 | 90 | 120 |
| Dept D | 25 | 30 | 35 | 40 |
What is the absolute difference in Rupees between the average quarterly cost of Dept C and the combined cost of Dept B in the first half of the fiscal year (Q1 and Q2)?
- A₹ 26.25
- B₹ 58,75,000
- ₹ 26,25,000Answer
- D₹ 2,10,00,000
Answer
₹ 26,25,000
The average quarterly cost for Dept C is calculated by adding its four quarters and dividing by 4: (80 + 75 + 90 + 120) / 4 = 365 / 4 = 91.25 Lakhs. The combined cost for Dept B in Q1 and Q2 is 30 + 35 = 65 Lakhs. The absolute difference is 91.25 - 65 = 26.25 Lakhs. Since the table scale is in Lakhs (where 1 Lakh = 1,00,000), the absolute difference in Rupees is 26.25 * 1,00,000 = ₹ 26,25,000.
Step-by-Step Solution
Key Concept
Extracting targeted data points from a grid, calculating averages and sums, and applying chart scale multipliers accurately.