Tables and Data Grids

16 questions

Question 1Question

The table below presents the quarterly administrative software licensing costs (in ₹ Lakhs) for four governmental departments during the fiscal year 2025-26:

DepartmentQ1Q2Q3Q4
Dept A45506055
Dept B30354045
Dept C807590120
Dept D25303540

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)?

Show answer & explanation

Answer: ₹ 26,25,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

1
Calculate the average quarterly cost for Dept C.
91.25 Lakhs
The average is the total of all four quarters divided by 4: (80 + 75 + 90 + 120) / 4 = 365 / 4 = 91.25.
2
Calculate the combined cost for Dept B in the first half of the year (Q1 and Q2).
65 Lakhs
The combined cost is the direct sum of Q1 and Q2 values: 30 + 35 = 65.
3
Find the absolute numeric difference between the two calculated values.
26.25
91.25 - 65 = 26.25.
4
Convert the numeric difference into actual Rupees using the scale multiplier.
₹ 26,25,000
The table header specifies the values are in '₹ Lakhs'. 1 Lakh is equal to 1,00,000. Multiplying 26.25 by 1,00,000 gives 26,25,000.

Key Concept

Extracting targeted data points from a grid, calculating averages and sums, and applying chart scale multipliers accurately.
Question 2Question

The table below presents the quarterly renewable energy generation (in Megawatts, MW) of four geographical zones of a state in 2025:

ZoneQ1 (MW)Q2 (MW)Q3 (MW)Q4 (MW)
North Zone120150180150
South Zone200220250210
East Zone90110130110
West Zone160180200160

Based on the table, what is the average quarterly renewable energy generation (in MW) for the South Zone in 2025?

Show answer & explanation

Answer: 220

Answer

The average quarterly renewable energy generation for the South Zone in 2025 is 220 MW220\text{ MW}.
The correct average is obtained by summing the four quarterly generation figures of the South Zone (200+220+250+210=880 MW200 + 220 + 250 + 210 = 880\text{ MW}) and dividing by 44, giving 220 MW220\text{ MW}.

Step-by-Step Solution

1
Locate the row for the South Zone and extract data for all four quarters.
Q1 = 200 MW200\text{ MW}, Q2 = 220 MW220\text{ MW}, Q3 = 250 MW250\text{ MW}, Q4 = 210 MW210\text{ MW}.
Data needs to be aggregated across the full year.
2
Calculate total annual generation for the South Zone.
Total = 200+220+250+210=880 MW200 + 220 + 250 + 210 = 880\text{ MW}.
Summing values is required before finding the average.
3
Divide total generation by the number of quarters.
Average = 8804=220 MW\frac{880}{4} = 220\text{ MW}.
An average across four periods requires dividing the total sum by 4.

Key Concept

Average calculation from a tabular dataset
Question 3Question

The table below shows the annual wheat production (in metric tonnes) across four agricultural zones from 2021 to 2023:

Agricultural Zone202120222023
Zone A150180210
Zone B200250300
Zone C100120150
Zone D300330360

Which of the following statements regarding the data given in the table are correct?

Select all that apply

Show answer & explanation

Answer: Zone A registered a 20%20\% growth in wheat production from 2021 to 2022.; In 2023, the wheat production of Zone B was exactly double that of Zone C.

Answer

The correct statements are that Zone A registered a 20%20\% growth in wheat production from 2021 to 2022, and in 2023, the wheat production of Zone B was exactly double that of Zone C.
Zone A's production grew from 150150 to 180180 tonnes, which is a growth of 30150×100%=20%\frac{30}{150} \times 100\% = 20\%. In 2023, Zone B produced 300300 tonnes while Zone C produced 150150 tonnes, making Zone B's production exactly double that of Zone C.

Step-by-Step Solution

1
Calculate the percentage growth for Zone A from 2021 to 2022.
Percentage increase = 180150150×100%=20%\frac{180 - 150}{150} \times 100\% = 20\%. Statement is correct.
To verify the growth statement for Zone A using the base year 2021 value (150150).
2
Compare Zone B and Zone C production figures for the year 2023.
Zone B produced 300300 tonnes and Zone C produced 150150 tonnes. Ratio = 300150=2\frac{300}{150} = 2. Statement is correct.
To check if Zone B production was double that of Zone C in 2023.
3
Calculate the percentage increase for Zone D from 2021 to 2022.
Percentage increase = 330300300×100%=10%15%\frac{330 - 300}{300} \times 100\% = 10\% \neq 15\%. Statement is incorrect.
To evaluate the claim regarding Zone D's percentage growth.
4
Calculate the total wheat production of Zone C across 2021, 2022, and 2023.
Total = 100+120+150=370100 + 120 + 150 = 370 tonnes 400\neq 400 tonnes. Statement is incorrect.
To verify the three-year total production claim for Zone C.

Key Concept

Tabular Data Interpretation and Percentage Growth Analysis
Question 4Question

The table below details the renewable energy generation (in Gigawatt-hours, GWh) across four zones in 2025:

ZoneSolarWindHydroBiomass
North12015020050
South18022016040
East906025080
West21019010070

What is the total solar energy generation (in GWh) across all four zones combined in 2025?

Show answer & explanation

Answer: 600

Answer

The total solar energy generation across all four zones in 2025 is 600 GWh.
Summing the values in the Solar column (120+180+90+210120 + 180 + 90 + 210) yields a total of 600600 GWh.

Step-by-Step Solution

1
Locate and extract the values under the 'Solar' column for all four zones.
North = 120, South = 180, East = 90, West = 210.
The question asks specifically for total solar energy generation.
2
Sum the extracted values across all rows.
120+180+90+210=600120 + 180 + 90 + 210 = 600 GWh.
Combining values across all four zones yields the overall total for the solar category.

Key Concept

Data Extraction and Summation from Tables
Question 5Question

The table below presents the operational metrics for Agricultural Processing Units across four districts of a state for FY 2025–26:

DistrictTotal Processing Capacity (in '000 MT)Operational Units CountTotal Raw Produce Received (in '000 MT)Processing Efficiency Rate (%)
District A4501836085%85\%
District B6002448090%90\%
District C5002042080%80\%
District D3501432075%75\%

*Note: Processing Efficiency Rate is defined as the percentage of Total Raw Produce Received that is converted into finished products. The remaining portion of received raw produce is lost as processing waste.*

What is the overall average processing waste (in '000 Metric Tonnes) per operational unit across all four districts combined?

Show answer & explanation

Answer: 3.5

Answer

The overall average processing waste per operational unit across all four districts combined is 3.53.5 thousand Metric Tonnes.
The correct answer is derived by first finding the waste volume for each district based on raw produce received: District A (360×0.15=54360 \times 0.15 = 54), District B (480×0.10=48480 \times 0.10 = 48), District C (420×0.20=84420 \times 0.20 = 84), and District D (320×0.25=80320 \times 0.25 = 80). Summing these gives a combined total waste of 266266 thousand MT. Dividing this total waste by the total count of operational units (18+24+20+14=7618 + 24 + 20 + 14 = 76) yields 26676=3.5\frac{266}{76} = 3.5 thousand MT per unit.

Step-by-Step Solution

1
Calculate the processing waste percentage for each district
District A waste rate = 100%85%=15%100\% - 85\% = 15\%; District B waste rate = 100%90%=10%100\% - 90\% = 10\%; District C waste rate = 100%80%=20%100\% - 80\% = 20\%; District D waste rate = 100%75%=25%100\% - 75\% = 25\%.
Processing waste is the complement of processing efficiency rate.
2
Calculate total processing waste generated in each district in '000 MT
District A waste = 360×0.15=54360 \times 0.15 = 54 '000 MT; District B waste = 480×0.10=48480 \times 0.10 = 48 '000 MT; District C waste = 420×0.20=84420 \times 0.20 = 84 '000 MT; District D waste = 320×0.25=80320 \times 0.25 = 80 '000 MT.
Absolute waste is obtained by multiplying Total Raw Produce Received by the waste rate.
3
Calculate total waste and total operational units across all four districts combined
Total Waste = 54+48+84+80=26654 + 48 + 84 + 80 = 266 '000 MT. Total Operational Units = 18+24+20+14=7618 + 24 + 20 + 14 = 76 units.
Aggregating metrics across districts is required to find the combined weighted average.
4
Divide total combined waste by total combined operational units
Average Waste per Unit = 26676=3.5\frac{266}{76} = 3.5 '000 MT per unit.
Overall average metric equals total aggregate waste divided by total aggregate count of units.

Key Concept

Weighted Average and Percentage Calculation from Data Grids
Estimated Time:2m 30s
Question 6Question

The table below presents the operational performance and energy distribution metrics of four regional power grids during FY 2025–26. Net available energy for distribution is determined by first deducting transmission and storage losses from total generation, and then subtracting auxiliary station consumption.

Regional GridTotal Energy Generated (GWh)Transmission & Storage Loss (%)Auxiliary Station Consumption (GWh)Commercial Sector Share of Net Available Energy (%)
Northern Grid12,00015%20040%
Southern Grid15,00012%40035%
Eastern Grid10,00020%30050%
Western Grid18,00010%20025%

Based on the data provided, what is the ratio of the total energy distributed to the commercial sector by the Southern Grid to the combined energy distributed to the commercial sector by the Northern and Western Grids?

Show answer & explanation

Answer: 14 : 25

Answer

The ratio of energy distributed to the commercial sector by the Southern Grid to the combined commercial distribution of the Northern and Western Grids is 14 : 25.
The correct option stating '14 : 25' accurately follows the prescribed two-stage deduction process. For the Southern Grid, subtracting 12% loss (1,800 GWh1,800\text{ GWh}) from 15,000 GWh15,000\text{ GWh} gives 13,200 GWh13,200\text{ GWh}, and subtracting 400 GWh400\text{ GWh} auxiliary consumption leaves 12,800 GWh12,800\text{ GWh}. Applying 35%35\% yields 4,480 GWh4,480\text{ GWh}. For the Northern Grid, net energy is (12,0001,800)200=10,000 GWh(12,000 - 1,800) - 200 = 10,000\text{ GWh}, giving 40%×10,000=4,000 GWh40\% \times 10,000 = 4,000\text{ GWh}. For the Western Grid, net energy is (18,0001,800)200=16,000 GWh(18,000 - 1,800) - 200 = 16,000\text{ GWh}, giving 25%×16,000=4,000 GWh25\% \times 16,000 = 4,000\text{ GWh}. Combining Northern and Western gives 8,000 GWh8,000\text{ GWh}. The ratio 4,4808,000\frac{4,480}{8,000} simplifies precisely to 14:2514 : 25.

Step-by-Step Solution

1
Calculate the net available energy and commercial distribution for the Southern Grid.
Net Available = (15,0000.12×15,000)400=(15,0001,800)400=12,800 GWh(15,000 - 0.12 \times 15,000) - 400 = (15,000 - 1,800) - 400 = 12,800\text{ GWh}. Commercial Distribution = 35% of 12,800=4,480 GWh35\% \text{ of } 12,800 = 4,480\text{ GWh}.
Transmission loss must be deducted from total generation first, followed by auxiliary consumption.
2
Calculate the net available energy and commercial distribution for the Northern Grid.
Net Available = (12,0000.15×12,000)200=(12,0001,800)200=10,000 GWh(12,000 - 0.15 \times 12,000) - 200 = (12,000 - 1,800) - 200 = 10,000\text{ GWh}. Commercial Distribution = 40% of 10,000=4,000 GWh40\% \text{ of } 10,000 = 4,000\text{ GWh}.
Required to compute the combined baseline for Northern and Western grids.
3
Calculate the net available energy and commercial distribution for the Western Grid.
Net Available = (18,0000.10×18,000)200=(18,0001,800)200=16,000 GWh(18,000 - 0.10 \times 18,000) - 200 = (18,000 - 1,800) - 200 = 16,000\text{ GWh}. Commercial Distribution = 25% of 16,000=4,000 GWh25\% \text{ of } 16,000 = 4,000\text{ GWh}.
Required to complete the denominator sum of the target ratio.
4
Compute the target ratio of Southern Grid commercial distribution to Northern + Western Grid commercial distribution.
Combined Northern + Western = 4,000+4,000=8,000 GWh4,000 + 4,000 = 8,000\text{ GWh}. Ratio = 4,480:8,000=14:254,480 : 8,000 = 14 : 25.
Simplifying 4,4808,000\frac{4,480}{8,000} by dividing both terms by their greatest common divisor 160160 yields 14:2514 : 25.

Key Concept

Multi-step tabular data interpretation involving sequential percentage reduction, absolute deductions, and ratio simplification.
Question 7Question

The table below details raw material procurement, fabric output, and sales revenues across four regional textile development clusters for FY 2024–25:

Textile ClusterRaw Cotton Procured ('000 MT)Fabric Produced ('000 metres)Export Value (₹ Crores)Domestic Sales (₹ Crores)
Cluster A40320160240
Cluster B50500300200
Cluster C60480240360
Cluster D30240180120

What is the absolute difference (in ₹ Crores) between the average domestic sales across all four clusters and the domestic sales of the cluster that achieved the highest fabric production efficiency per unit of raw cotton procured?

Show answer & explanation

Answer: ₹30 Crores

Answer

The absolute difference is ₹30 Crores.
The correct answer is ₹30 Crores. Fabric production efficiency per unit of raw cotton is calculated as Fabric Produced ('000 metres) divided by Raw Cotton Procured ('000 MT). Cluster B yields 500 / 50 = 10 metres/MT, which is the highest among all clusters (others yield 8 metres/MT). Cluster B's domestic sales are ₹200 Crores. The average domestic sales across all clusters is (240 + 200 + 360 + 120) / 4 = ₹230 Crores. The absolute difference between ₹230 Crores and ₹200 Crores is ₹30 Crores.

Step-by-Step Solution

1
Calculate fabric production efficiency per unit of raw cotton procured for each cluster
Cluster A: 320 / 40 = 8 metres/MT; Cluster B: 500 / 50 = 10 metres/MT; Cluster C: 480 / 60 = 8 metres/MT; Cluster D: 240 / 30 = 8 metres/MT.
To identify which cluster achieved the highest fabric production per unit of raw cotton procured.
2
Identify the domestic sales of the most efficient cluster
Cluster B achieved the highest efficiency (10 metres/MT). Its domestic sales volume is ₹200 Crores.
This provides the targeted cluster's metric for comparison.
3
Calculate the average domestic sales across all four clusters
Total Domestic Sales = 240 + 200 + 360 + 120 = ₹920 Crores. Average Domestic Sales = 920 / 4 = ₹230 Crores.
To determine the benchmark average domestic sales across the dataset.
4
Compute the absolute difference
| ₹230 Crores - ₹200 Crores | = ₹30 Crores.
To answer the final question requirement.

Key Concept

Data grid ratio comparison and benchmark deviation analysis
Question 8Question

The table below presents the organic horticulture harvest (in metric tonnes) across four agricultural zones in a state for the years 2022 to 2025:

Agricultural Zone2022202320242025
Zone A320360400480
Zone B450500550620
Zone C280310350420
Zone D550630700780

Based on the table, what is the percentage share of Zone B in the total horticulture harvest across all four agricultural zones combined in the year 2024?

Show answer & explanation

Answer: 27.5

Answer

The percentage share of Zone B in the total horticulture harvest across all four zones combined in 2024 is 27.5%27.5\%.
The total harvest across all four zones in 2024 is 400+550+350+700=2000400 + 550 + 350 + 700 = 2000 metric tonnes. Zone B contributed 550550 metric tonnes in 2024. Dividing 550550 by 20002000 and multiplying by 100100 yields exactly 27.5%27.5\%.

Step-by-Step Solution

1
Calculate total harvest for all zones in 2024
Total harvest in 2024 = 400+550+350+700=2000400 + 550 + 350 + 700 = 2000 metric tonnes
To find the baseline total harvest across all zones for the target year.
2
Locate the specific harvest for Zone B in 2024
Zone B harvest in 2024 = 550550 metric tonnes
To isolate the target numerator specified in the question.
3
Compute the percentage share
Percentage share = (5502000)×100=27.5%\left( \frac{550}{2000} \right) \times 100 = 27.5\%
Dividing the specific zone harvest by the total harvest yields the fractional share, which is converted to percentage by multiplying by 100.

Key Concept

Tabular Percentage Share Calculation
Estimated Time:1m 30s
Question 9Question

The table below presents the operational metrics for four Inland Freight Terminals in a state for FY 2025–26:

Freight TerminalTotal Cargo Handled (in thousand metric tonnes)Rail Transshipment Share (%)Average Dwell Time per Container (days)Revenue Generated per Tonne (₹)
North45040%4.5800
South60065%3.0750
East35050%5.0900
West50030%6.0850

What is the total revenue generated from cargo moved specifically via rail transshipment across all four freight terminals combined during FY 2025–26?

Show answer & explanation

Answer: ₹72.15 crore

Answer

₹72.15 crore
To find the total rail transshipment revenue, compute the rail-moved tonnage for each terminal: North (1.80 lakh tonnes), South (3.90 lakh tonnes), East (1.75 lakh tonnes), and West (1.50 lakh tonnes). Multiplying each by its respective revenue per tonne yields ₹14.40 crore, ₹29.25 crore, ₹15.75 crore, and ₹12.75 crore. Summing these four values gives exactly ₹72.15 crore.

Step-by-Step Solution

1
Convert cargo volumes from thousand metric tonnes to tonnes for each terminal
North: 4,50,000 tonnes; South: 6,00,000 tonnes; East: 3,50,000 tonnes; West: 5,00,000 tonnes.
The table header specifies cargo handled in 'thousand metric tonnes'.
2
Calculate the rail transshipment volume for each terminal
North: 4,50,000 × 40% = 1,80,000 tonnes
South: 6,00,000 × 65% = 3,90,000 tonnes
East: 3,50,000 × 50% = 1,75,000 tonnes
West: 5,00,000 × 30% = 1,50,000 tonnes
Rail transshipment share percentage is applied to total cargo volume of each terminal.
3
Compute revenue from rail transshipment for each terminal
North: 1,80,000 × ₹800 = ₹14,40,00,000 (₹14.40 crore)
South: 3,90,000 × ₹750 = ₹29,25,00,000 (₹29.25 crore)
East: 1,75,000 × ₹900 = ₹15,75,00,000 (₹15.75 crore)
West: 1,50,000 × ₹850 = ₹12,75,00,000 (₹12.75 crore)
Multiply rail transshipment tonnes by revenue per tonne.
4
Sum the rail transshipment revenues across all terminals
₹14.40 crore + ₹29.25 crore + ₹15.75 crore + ₹12.75 crore = ₹72.15 crore (₹72,15,00,000).
Total combined rail revenue is the sum of terminal-level rail revenues.

Key Concept

Multi-step weighted calculation from data grids involving unit scale factors and percentages.
Question 10Question

The table below presents the operational and processing metrics for four municipal water treatment plants in a coastal state for FY 2025–26:

Plant LocationTotal Raw Water Processed (Million Liters)Purified Water Output (%)Operational Cost per Million Liters (₹ Thousand)
Northern Zone45080%12
Southern Zone60085%10
Eastern Zone50078%15
Western Zone75092%14

Based on the table above, calculate the average volume of purified water output (in Million Liters) produced per plant across the four zones.

Show answer & explanation

Answer: 487.5

Answer

The average volume of purified water output per plant is 487.5487.5 Million Liters.
The purified water volume outputs for Northern, Southern, Eastern, and Western zones are 360360, 510510, 390390, and 690690 Million Liters respectively. Summing these values gives a total output of 19501950 Million Liters. Dividing this total by the 44 plants gives an average purified water output of 487.5487.5 Million Liters per plant.

Step-by-Step Solution

1
Calculate the purified water volume for each of the four treatment plants
Northern Zone = 360360 Million Liters, Southern Zone = 510510 Million Liters, Eastern Zone = 390390 Million Liters, Western Zone = 690690 Million Liters
Purified water output volume is calculated by multiplying Total Raw Water Processed by the Purified Water Output percentage.
2
Sum the purified water volumes across all four zones
Total purified output = 19501950 Million Liters
The aggregate sum is required to compute the mean value across all plants.
3
Divide the total purified output by the number of plants (4)
Average purified output = 487.5487.5 Million Liters
Dividing the total sum by the count of entities yields the arithmetic average.

Key Concept

Tabular Data Extraction and Weighted Average Calculation
Question 11Question

The table below presents the operational and storage metrics for the State Warehousing Corporation across four district hubs for FY 2024–25:

District HubTotal Storage Capacity ('000 MT)Actual Grain Stored ('000 MT)Spoilage Rate (%)Milling Processing Fee (₹/MT)
Hub Alpha2502502002004%4\%150150
Hub Beta4004003503502%2\%120120
Hub Gamma3003002402405%5\%200200
Hub Delta5005004504503%3\%100100

Note: 1 MT=1 Metric Tonne1\text{ MT} = 1\text{ Metric Tonne}; figures in capacity and stored columns are in thousands of MT.

If the government procurement cost of grain is 20,000₹20,000 per Metric Tonne, what is the total financial loss (in ₹ Lakhs₹\text{ Lakhs}) incurred due to grain spoilage across Hub Alpha and Hub Gamma combined?

Show answer & explanation

Answer: 4,000 Lakhs₹4,000\text{ Lakhs}

Answer

The total financial loss incurred due to grain spoilage across Hub Alpha and Hub Gamma combined is 4,000 Lakhs₹4,000\text{ Lakhs}.
To find the total financial loss due to spoilage across Hub Alpha and Hub Gamma, we calculate the spoiled quantity for each hub based on the actual grain stored (in MT):
- Hub Alpha: 200,000 MT×4%=8,000 MT200,000\text{ MT} \times 4\% = 8,000\text{ MT}
- Hub Gamma: 240,000 MT×5%=12,000 MT240,000\text{ MT} \times 5\% = 12,000\text{ MT}
Total spoiled quantity =8,000+12,000=20,000 MT= 8,000 + 12,000 = 20,000\text{ MT}.
At 20,000₹20,000 per MT, total loss =20,000×20,000=400,000,000= 20,000 \times 20,000 = ₹400,000,000. Expressed in Lakhs (1 Lakh=100,0001\text{ Lakh} = 100,000), this equals 4,000 Lakhs₹4,000\text{ Lakhs}.

Step-by-Step Solution

1
Calculate the actual quantity of spoiled grain in Hub Alpha
Spoiled grain in Alpha = 4%×200,000 MT=8,000 MT4\% \times 200,000\text{ MT} = 8,000\text{ MT}
Actual grain stored in Alpha is 200×1,000=200,000 MT200 \times 1,000 = 200,000\text{ MT} and spoilage rate is 4%4\%.
2
Calculate the actual quantity of spoiled grain in Hub Gamma
Spoiled grain in Gamma = 5%×240,000 MT=12,000 MT5\% \times 240,000\text{ MT} = 12,000\text{ MT}
Actual grain stored in Gamma is 240×1,000=240,000 MT240 \times 1,000 = 240,000\text{ MT} and spoilage rate is 5%5\%.
3
Find the combined total quantity of spoiled grain
Total spoiled grain = 8,000 MT+12,000 MT=20,000 MT8,000\text{ MT} + 12,000\text{ MT} = 20,000\text{ MT}
Combine the spoiled quantities from both hubs.
4
Compute the total financial loss in Rupees and convert to Lakhs
Total Loss = 20,000 MT×20,000/MT=400,000,000=4,000 Lakhs20,000\text{ MT} \times ₹20,000/\text{MT} = ₹400,000,000 = ₹4,000\text{ Lakhs}
Multiply total spoiled MT by the cost per MT (20,000₹20,000) and divide by 100,000100,000 to express in Lakhs.

Key Concept

Data Interpretation from Tables: Multi-step calculation involving unit scale conversion, percentage bases, and aggregation
Question 12Question

The table below presents the freshwater fish production and pricing metrics across four regional inland lake zones managed by the State Fisheries Development Board for the year 2025:

Lake ZoneTotal Catch (in Tonnes)Export Grade Share (%)Local Market Price (in ₹ per kg)Export Market Price (in ₹ per kg)
Lake Alpha40030%150350
Lake Beta50040%160400
Lake Gamma35020%140300
Lake Delta60025%180420

Note: 1 Tonne=1,000 kg1\text{ Tonne} = 1,000\text{ kg} and 1 Lakh=100,0001\text{ Lakh} = 100,000.

Based on the table, calculate the total revenue (in ₹ Lakhs) generated by Lake Beta from both local and export market sales combined.

Show answer & explanation

Answer: 1280

Answer

The total revenue generated by Lake Beta from local and export market sales combined is ₹1,280 Lakhs.
Lake Beta produces 500 tonnes=500,000 kg500\text{ tonnes} = 500,000\text{ kg} of fish. 40%40\% of this (200,000 kg200,000\text{ kg}) is exported at ₹400/kg400/\text{kg}, yielding ₹800 Lakhs800\text{ Lakhs}. The remaining 60%60\% (300,000 kg300,000\text{ kg}) is sold locally at ₹160/kg160/\text{kg}, yielding ₹480 Lakhs480\text{ Lakhs}. Combining both gives ₹1,280 Lakhs1,280\text{ Lakhs}.

Step-by-Step Solution

1
Convert the total catch of Lake Beta to kilograms.
500 tonnes=500,000 kg500\text{ tonnes} = 500,000\text{ kg}.
Prices are given per kilogram, so total mass must be in kilograms.
2
Partition the total catch into export grade and local market quantities.
Export quantity = 40%×500,000=200,000 kg40\% \times 500,000 = 200,000\text{ kg}; Local quantity = 60%×500,000=300,000 kg60\% \times 500,000 = 300,000\text{ kg}.
Different market prices apply to export grade vs local grade catch.
3
Calculate monetary revenue for each grade and find their sum in ₹ Lakhs.
Export revenue = 200,000×400=80,000,000=800 Lakhs200,000 \times 400 = ₹80,000,000 = ₹800\text{ Lakhs}; Local revenue = 300,000×160=48,000,000=480 Lakhs300,000 \times 160 = ₹48,000,000 = ₹480\text{ Lakhs}; Total = 800+480=1,280 Lakhs800 + 480 = ₹1,280\text{ Lakhs}.
Summing both revenue streams gives the total earnings for Lake Beta.

Key Concept

Weighted revenue calculation from multi-column tabular data
Estimated Time:1m 30s
Question 13Question

The following data grid presents the cargo volume handled (in thousands of Metric Tonnes, '000 MT) across five maritime ports from FY 2021–22 to FY 2024–25:

PortFY 2021–22FY 2022–23FY 2023–24FY 2024–25
Port Alpha450540648777.6
Port Beta800720648583.2
Port Gamma300375450562.5
Port Delta600660792871.2
Port Epsilon500550605726

Which of the following statements regarding the performance of these ports are correct? Select all that apply.

Select all that apply

Show answer & explanation

Answer: Port Alpha registered a constant year-on-year cargo growth rate of 20% across all three consecutive periods.; The combined total cargo volume handled by all five ports increased by more than 30% in FY 2024–25 compared to FY 2021–22.

Answer

The statements confirming that Port Alpha registered a constant year-on-year growth rate of 20% and that the combined total cargo volume grew by more than 30% are correct.
The statement regarding Port Alpha is correct because the year-on-year growth rate is uniformly 20%20\% for every year (90/450=20%90/450 = 20\%, 108/540=20%108/540 = 20\%, and 129.6/648=20%129.6/648 = 20\%). The statement regarding combined total growth is also correct because the total cargo grew from 26502650 thousand MT to 3520.53520.5 thousand MT, which equals a 32.85%32.85\% increase—clearly exceeding 30%30\%.

Step-by-Step Solution

1
Calculate year-on-year percentage growth for Port Alpha.
FY 21–22 to 22–23: (540450)/450=0.20(540 - 450) / 450 = 0.20 (20%20\%). FY 22–23 to 23–24: (648540)/540=0.20(648 - 540) / 540 = 0.20 (20%20\%). FY 23–24 to 24–25: (777.6648)/648=0.20(777.6 - 648) / 648 = 0.20 (20%20\%).
Verify if the annual growth rate remains constant across all three consecutive periods.
2
Calculate total cargo volume for FY 2021–22 and FY 2024–25 across all ports.
Total FY 2021–22 =450+800+300+600+500=2650= 450 + 800 + 300 + 600 + 500 = 2650 thousand MT. Total FY 2024–25 =777.6+583.2+562.5+871.2+726=3520.5= 777.6 + 583.2 + 562.5 + 871.2 + 726 = 3520.5 thousand MT.
Determine the combined aggregate performance for percentage growth evaluation.
3
Compute total overall growth percentage from FY 2021–22 to FY 2024–25.
Percentage Growth =3520.526502650×100%=870.52650×100%32.85%= \frac{3520.5 - 2650}{2650} \times 100\% = \frac{870.5}{2650} \times 100\% \approx 32.85\%.
Compare calculated growth (32.85%32.85\%) against the target threshold of 30%30\%.
4
Calculate Port Beta's share of total cargo in FY 2024–25.
Share =583.23520.5×100%16.57%= \frac{583.2}{3520.5} \times 100\% \approx 16.57\%.
Test whether Port Beta's share exceeded 20%20\% in FY 2024–25.
5
Compare absolute growth values across all ports between FY 2021–22 and FY 2024–25.
Alpha: 327.6327.6, Beta: 216.8-216.8, Gamma: 262.5262.5, Delta: 271.2271.2, Epsilon: 226.0226.0.
Identify the port with the maximum absolute increase.

Key Concept

Tabular Data Interpretation: Multi-Period Rate Analysis and Baseline Distinctions
Question 14Question

The table below provides operational details regarding procurement, storage loss, public distribution system (PDS) allocation, and unit storage costs for rice across four agricultural zones of a state during FY 2025–26:

ZoneRice Procured (in '000 MT)Storage & Transit Loss (% of Procured Rice)Distribution to PDS (% of Net Retained Rice)Unit Storage Cost per MT of Net Retained Rice (₹)
Zone Alpha2504.0%80%₹ 450
Zone Beta1805.0%75%₹ 500
Zone Gamma2002.5%85%₹ 400
Zone Delta3006.0%70%₹ 350

*Note: Net Retained Rice = Total Rice Procured - Storage & Transit Loss.*

What is the total quantity of rice (in MT) retained as undistributed buffer stock across all four zones combined after completing the PDS distribution?

Show answer & explanation

Answer: 204,600 MT204,600\text{ MT}

Answer

204,600 MT204,600\text{ MT}
The correct answer is derived by first subtracting the percentage storage loss from the gross procurement of each zone to establish the net retained rice base (240,000 MT240,000\text{ MT} for Alpha, 171,000 MT171,000\text{ MT} for Beta, 195,000 MT195,000\text{ MT} for Gamma, and 282,000 MT282,000\text{ MT} for Delta). Multiplying these net figures by their respective remaining undistributed percentages (20%20\%, 25%25\%, 15%15\%, and 30%30\%) gives buffer quantities of 48,000 MT48,000\text{ MT}, 42,750 MT42,750\text{ MT}, 29,250 MT29,250\text{ MT}, and 84,600 MT84,600\text{ MT}. The sum of these four quantities equals 204,600 MT204,600\text{ MT}.

Step-by-Step Solution

1
Convert procured quantities into metric tonnes (MT) and compute net retained rice for each zone.
Zone Alpha: 250,000×(10.04)=240,000 MT250,000 \times (1 - 0.04) = 240,000\text{ MT}.
Zone Beta: 180,000×(10.05)=171,000 MT180,000 \times (1 - 0.05) = 171,000\text{ MT}.
Zone Gamma: 200,000×(10.025)=195,000 MT200,000 \times (1 - 0.025) = 195,000\text{ MT}.
Zone Delta: 300,000×(10.06)=282,000 MT300,000 \times (1 - 0.06) = 282,000\text{ MT}.
Storage loss must be deducted from gross procurement to get net retained rice.
2
Calculate the undistributed buffer stock percentage for each zone.
Zone Alpha: 100%80%=20%100\% - 80\% = 20\%.
Zone Beta: 100%75%=25%100\% - 75\% = 25\%.
Zone Gamma: 100%85%=15%100\% - 85\% = 15\%.
Zone Delta: 100%70%=30%100\% - 70\% = 30\%.
Buffer stock represents the remaining fraction of net retained rice after PDS distribution.
3
Calculate the volume of undistributed buffer stock for each zone.
Zone Alpha: 240,000×0.20=48,000 MT240,000 \times 0.20 = 48,000\text{ MT}.
Zone Beta: 171,000×0.25=42,750 MT171,000 \times 0.25 = 42,750\text{ MT}.
Zone Gamma: 195,000×0.15=29,250 MT195,000 \times 0.15 = 29,250\text{ MT}.
Zone Delta: 282,000×0.30=84,600 MT282,000 \times 0.30 = 84,600\text{ MT}.
Multiply net retained rice by the respective buffer stock percentage.
4
Sum the buffer stock volumes across all four zones.
48,000+42,750+29,250+84,600=204,600 MT48,000 + 42,750 + 29,250 + 84,600 = 204,600\text{ MT}.
To find the combined total buffer stock for the state.

Key Concept

Multi-stage sequential percentage calculations on tabular net base values.
Question 15Question

The table below presents the annual handicraft exports (in ₹ Crore) across four regional development boards from 2021–22 to 2024–25:

Regional Board2021–222022–232023–242024–25
Northern Region150180200240
Southern Region240260300360
Eastern Region120150180210
Western Region160200250300

Based on the table, what is the ratio of the total handicraft exports from the Northern and Eastern Regions combined in 2024–25 to the total handicraft exports from the Southern and Western Regions combined in 2021–22?

Show answer & explanation

Answer: 9 : 8

Answer

The correct ratio of exports is 9 : 8.
The total exports from the Northern and Eastern Regions combined in 2024–25 amount to ₹240 Crore + ₹210 Crore = ₹450 Crore. The total exports from the Southern and Western Regions combined in 2021–22 amount to ₹240 Crore + ₹160 Crore = ₹400 Crore. Taking the ratio of 450 to 400 gives 450 : 400, which simplifies directly to 9 : 8.

Step-by-Step Solution

1
Identify and sum the export values for Northern and Eastern Regions for the year 2024–25 from the table grid.
Northern Region (2024–25) = ₹240 Crore; Eastern Region (2024–25) = ₹210 Crore. Total = 240 + 210 = ₹450 Crore.
This establishes the numerator component requested in the question stem.
2
Identify and sum the export values for Southern and Western Regions for the base year 2021–22.
Southern Region (2021–22) = ₹240 Crore; Western Region (2021–22) = ₹160 Crore. Total = 240 + 160 = ₹400 Crore.
This establishes the denominator component requested in the question stem.
3
Form the ratio and simplify to its lowest integer terms.
Ratio = 450 / 400 = 9 / 8, or 9 : 8.
Simplifying by dividing both numbers by their highest common factor (50) yields the final required ratio.

Key Concept

Tabular Data Interpretation and Multi-Cell Ratio Calculation
Estimated Time:1m 30s
Question 16Question

The table below shows the annual solar power generation (in Megawatts, MW) across four districts (P, Q, R, and S) in a state from 2021 to 2024:

District2021 (MW)2022 (MW)2023 (MW)2024 (MW)
District P100120150200
District Q200240300360
District R150180200240
District S5060150200

Based on the table above, which of the following statements are correct?

Select all that apply

Show answer & explanation

Answer: District P experienced a 100% increase in solar power generation in 2024 compared to its generation in 2021.; The ratio of total solar power generation in 2021 to total solar power generation in 2024 across all four districts is 1:21 : 2.

Answer

The correct statements are that District P experienced a 100% increase in solar power generation in 2024 compared to 2021, and the ratio of total solar power generation in 2021 to 2024 across all four districts is 1 : 2.
The statement regarding District P's growth is valid because generation doubled from 100 MW in 2021 to 200 MW in 2024, representing a 100% increase. The statement comparing overall totals is also valid because total generation in 2021 (500 MW) and 2024 (1000 MW) forms a simplified ratio of 1 : 2.

Step-by-Step Solution

1
Evaluate the statement regarding District P's percentage growth from 2021 to 2024.
Percentage Increase = 200100100×100=100%\frac{200 - 100}{100} \times 100 = 100\%. This statement is correct.
Calculate relative growth using 2021 as the base year.
2
Evaluate the statement regarding District S's share in 2023.
Total 2023 generation = 150+300+200+150=800 MW150 + 300 + 200 + 150 = 800\text{ MW}. District Q generated 300 MW300\text{ MW} (37.5%37.5\%), which is the highest. District S generated 150 MW150\text{ MW} (18.75%18.75\%). This statement is incorrect.
Determine total generation for 2023 and compare individual district contributions.
3
Evaluate the statement regarding the ratio of total generation in 2021 vs 2024.
Total 2021 generation = 100+200+150+50=500 MW100 + 200 + 150 + 50 = 500\text{ MW}. Total 2024 generation = 200+360+240+200=1000 MW200 + 360 + 240 + 200 = 1000\text{ MW}. Ratio = 500:1000=1:2500 : 1000 = 1 : 2. This statement is correct.
Sum values across all districts for 2021 and 2024, then simplify the resulting ratio.
4
Evaluate the statement regarding District R's annual average generation.
Sum for District R = 150+180+200+240=770 MW150 + 180 + 200 + 240 = 770\text{ MW}. Average = 7704=192.5 MW\frac{770}{4} = 192.5\text{ MW}. This statement is incorrect.
Divide total four-year generation for District R by the number of years (4).

Key Concept

Tabular Data Interpretation: Multi-Step Percentage Growth, Aggregation, Ratio Analysis, and Averages
Estimated Time:1m 30s