These UGC NET Paper 1 Unit 7 (Data Interpretation) Table DI practice sets are designed for Hard level learners who want to master tricky calculations and improve speed. In this set, you will solve questions based on tables only, where you must carefully read data, compare values, and apply smart maths like percentage change, ratio, averages, net values, and multi-step logic. Hard DI is not about big formulas, it is about staying calm, selecting the right numbers, and calculating accurately.
If you practice daily, even 1–2 DI sets per day, your calculation speed, accuracy, and confidence will increase quickly, and you will feel much more comfortable in the real UGC NET exam.
Table of Contents
DI Set 1: Table DI (Quarterly Revenue of Regional Branches)
Data:
| Branch | Q1 (₹ lakhs) | Q2 (₹ lakhs) | Q3 (₹ lakhs) | Q4 (₹ lakhs) |
|---|---|---|---|---|
| North | 125 | 132 | 128 | 145 |
| South | 118 | 126 | 135 | 140 |
| East | 110 | 115 | 120 | 125 |
| West | 130 | 125 | 133 | 138 |
Questions (MCQ):
Q1: What is the overall percentage increase in total revenue from Q1 to Q4 (all branches together)?
A) 13.26%;
B) 13.46%;
C) 13.66%;
D) 13.86%;
Q2: If 8% of Q4 revenue is spent as promotional cost by every branch, what is the net total Q4 revenue (all branches together)?
A) 503.88 lakhs;
B) 504.16 lakhs;
C) 504.52 lakhs;
D) 505.08 lakhs;
Q3: What is the percentage share of North in the total annual revenue (Q1+Q2+Q3+Q4 of all branches)?
A) 25.72%;
B) 25.92%;
C) 26.12%;
D) 26.32%;
Q4: A hypothetical Q5 is made by adding the same branch-wise increase as (Q4 − Q3) again to Q4. What will be the total revenue in Q5?
A) 578 lakhs;
B) 580 lakhs;
C) 582 lakhs;
D) 584 lakhs;
Q5: By what percentage does the average of (Q3 and Q4 total revenues) exceed Q2 total revenue?
A) 6.63%;
B) 6.83%;
C) 7.03%;
D) 7.23%;
Answers and Explanations:
Answer (Q1): B) 13.46%
Explanation: Total Q1 = 125+118+110+130 = 483. Total Q4 = 145+140+125+138 = 548.
% change = (548−483)/483 × 100 = 13.46% (approx).
Answer (Q2): B) 504.16 lakhs
Explanation: Total Q4 = 548 lakhs. Net after 8% cost = 548 × (1−0.08) = 548 × 0.92.
Net = 504.16 lakhs.
Answer (Q3): B) 25.92%
Explanation: North annual = 125+132+128+145 = 530. Total annual (all) = 2045.
Share % = 530/2045 × 100 = 25.92% (approx).
Answer (Q4): B) 580 lakhs
Explanation: Increases from Q3→Q4: North +17, South +5, East +5, West +5.
Q5 totals: (145+17)+(140+5)+(125+5)+(138+5) = 580 lakhs.
Answer (Q5): B) 6.83%
Explanation: Total Q2 = 498. Total Q3 = 516, Total Q4 = 548.
Average(Q3,Q4) = (516+548)/2 = 532. % = (532−498)/498 × 100 = 6.83% (approx).
DI Set 2: Table DI (City-wise Appeared vs Qualified: June vs Dec)
Data:
| City | June Appeared | June Qualified | Dec Appeared | Dec Qualified |
|---|---|---|---|---|
| Hyderabad | 4200 | 616 | 4500 | 675 |
| Delhi | 5000 | 760 | 5200 | 806 |
| Kolkata | 3800 | 532 | 4000 | 588 |
| Chennai | 4100 | 615 | 3900 | 561 |
Questions (MCQ):
Q1: What is the overall percentage increase in total qualified candidates from June to Dec (all cities together)?
A) 4.04%;
B) 4.24%;
C) 4.44%;
D) 4.64%;
Q2: What is the overall selection rate in Dec (total qualified as a % of total appeared)?
A) 14.74%;
B) 14.94%;
C) 15.14%;
D) 15.34%;
Q3: If Kolkata Dec appeared increases by 8% (Dec qualified stays same), what will be the new overall Dec selection rate?
A) 14.48%;
B) 14.68%;
C) 14.88%;
D) 15.08%;
Q4: Which city shows the highest positive change in selection rate from June to Dec?
A) Hyderabad;
B) Delhi;
C) Kolkata;
D) Chennai;
Q5: Find the difference (in percentage points) between:
- % change in total qualified (June→Dec), and
- % change in total appeared (June→Dec).
A) 1.12 pp;
B) 1.32 pp;
C) 1.52 pp;
D) 1.72 pp;
Answers and Explanations:
Answer (Q1): B) 4.24%
Explanation: Total qualified (June) = 616+760+532+615 = 2523. Total qualified (Dec) = 2630.
% change = (2630−2523)/2523 × 100 = 4.24% (approx).
Answer (Q2): B) 14.94%
Explanation: Total Dec appeared = 4500+5200+4000+3900 = 17600. Total Dec qualified = 2630.
Selection rate = 2630/17600 × 100 = 14.94% (approx).
Answer (Q3): B) 14.68%
Explanation: Kolkata Dec appeared increases by 8% ⇒ new Kolkata appeared = 4000 + 320 = 4320.
New total appeared = 17600 + 320 = 17920; rate = 2630/17920 × 100 = 14.68% (approx).
Answer (Q4): C) Kolkata
Explanation: June rate (Kolkata) = 532/3800 × 100 = 14.00%. Dec rate = 588/4000 × 100 = 14.70%.
Increase = 0.70 percentage points, highest among cities.
Answer (Q5): B) 1.32 pp
Explanation: % change qualified = 4.24% (from Q1). % change appeared = (17600−17100)/17100 × 100 = 2.92%.
Difference = 4.24 − 2.92 = 1.32 percentage points (approx).
DI Set 3: Table DI (Monthly Expense Break-up of Coaching Center)
Data:
| Expense Head | Apr (₹ lakhs) | May (₹ lakhs) | Jun (₹ lakhs) | Jul (₹ lakhs) |
|---|---|---|---|---|
| Rent | 5.5 | 5.5 | 5.7 | 5.7 |
| Salaries | 18.0 | 18.5 | 19.0 | 19.5 |
| Marketing | 6.0 | 7.2 | 6.8 | 7.6 |
| Utilities | 2.4 | 2.6 | 2.5 | 2.8 |
| Content | 3.2 | 3.0 | 3.6 | 3.4 |
| Misc | 1.8 | 2.0 | 1.9 | 2.1 |
Questions (MCQ):
Q1: What is the overall percentage increase in total expenses from Apr to Jul?
A) 11.08%;
B) 11.38%;
C) 11.68%;
D) 11.98%;
Q2: In May, 15% of Marketing is shifted to Content (Marketing reduces, Content increases). What is the new Content expense in May?
A) 3.96 lakhs;
B) 4.08 lakhs;
C) 4.20 lakhs;
D) 4.32 lakhs;
Q3: In July, what is the combined percentage share of Rent + Salaries in total July expenses?
A) 61.01%;
B) 61.31%;
C) 61.61%;
D) 61.91%;
Q4: Find how much (₹ lakhs) the average monthly (Marketing+Utilities) exceeds the average monthly (Rent+Misc) over Apr–Jul.
A) 1.83 lakhs;
B) 1.93 lakhs;
C) 2.03 lakhs;
D) 2.13 lakhs;
Q5: The largest absolute increase among all heads from Apr to Jul is:
A) 1.4 lakhs;
B) 1.5 lakhs;
C) 1.6 lakhs;
D) 1.7 lakhs;
Answers and Explanations:
Answer (Q1): B) 11.38%
Explanation: Total Apr = 36.9; Total Jul = 41.1.
% change = (41.1−36.9)/36.9 × 100 = 11.38% (approx).
Answer (Q2): B) 4.08 lakhs
Explanation: 15% of May Marketing = 15% of 7.2 = 1.08.
New Content (May) = 3.0 + 1.08 = 4.08 lakhs.
Answer (Q3): B) 61.31%
Explanation: July (Rent+Salaries) = 5.7 + 19.5 = 25.2. Total July = 41.1.
Share % = 25.2/41.1 × 100 = 61.31% (approx).
Answer (Q4): B) 1.93 lakhs
Explanation: Avg(Marketing+Utilities) = mean of (8.4, 9.8, 9.3, 10.4) = 9.475.
Avg(Rent+Misc) = mean of (7.3, 7.5, 7.6, 7.8) = 7.55. Difference = 9.475−7.55 = 1.93 lakhs (approx).
Answer (Q5): C) 1.6 lakhs
Explanation: Increase from Apr→Jul: Rent +0.2, Salaries +1.5, Marketing +1.6, Utilities +0.4, Content +0.2, Misc +0.3.
Largest increase = 1.6 lakhs.
DI Set 4: Table DI (Revenue and Operating Cost of Startups)
Data:
| Startup | Rev 2023 (₹ cr) | Cost 2023 (₹ cr) | Rev 2024 (₹ cr) | Cost 2024 (₹ cr) | Rev 2025 (₹ cr) | Cost 2025 (₹ cr) |
|---|---|---|---|---|---|---|
| Alpha | 48 | 36 | 54 | 39 | 61 | 44 |
| Beta | 52 | 41 | 58 | 45 | 64 | 49 |
| Gamma | 44 | 34 | 50 | 38 | 57 | 43 |
| Delta | 60 | 47 | 63 | 49 | 69 | 54 |
Questions (MCQ):
Q1: What is the total profit in 2025 for all startups together?
A) 59 cr;
B) 60 cr;
C) 61 cr;
D) 62 cr;
Q2: What is the overall percentage increase in combined revenue from 2023 to 2025?
A) 22.74%;
B) 23.04%;
C) 23.34%;
D) 23.64%;
Q3: In 2024, which startup has the highest profit margin (Profit ÷ Revenue)?
A) Alpha;
B) Beta;
C) Gamma;
D) Delta;
Q4: In 2025, Beta reduces cost by 5% and Alpha increases revenue by 4% (others unchanged). What is the new total profit in 2025?
A) 65.49 cr;
B) 65.89 cr;
C) 66.29 cr;
D) 66.69 cr;
Q5: What is the overall percentage increase in total profit from 2023 to 2025 (all startups together)?
A) 32.21%;
B) 32.61%;
C) 33.01%;
D) 33.41%;
Answers and Explanations:
Answer (Q1): C) 61 cr
Explanation: Profit 2025: Alpha 61−44=17, Beta 64−49=15, Gamma 57−43=14, Delta 69−54=15.
Total = 17+15+14+15 = 61 cr.
Answer (Q2): B) 23.04%
Explanation: Total revenue 2023 = 48+52+44+60 = 204. Total revenue 2025 = 61+64+57+69 = 251.
% change = (251−204)/204 × 100 = 23.04% (approx).
Answer (Q3): A) Alpha
Explanation: 2024 profit: Alpha 15, Beta 13, Gamma 12, Delta 14.
Profit margin = profit/revenue. Alpha = 15/54 × 100 = 27.78% (highest).
Answer (Q4): B) 65.89 cr
Explanation: Alpha new revenue = 61×1.04 = 63.44 ⇒ profit = 63.44−44 = 19.44.
Beta new cost = 49×0.95 = 46.55 ⇒ profit = 64−46.55 = 17.45. Total = 19.44+17.45+14+15 = 65.89 cr.
Answer (Q5): B) 32.61%
Explanation: Total profit 2023 = (48−36)+(52−41)+(44−34)+(60−47) = 46. Total profit 2025 = 61.
% change = (61−46)/46 × 100 = 32.61% (approx).
DI Set 5: Table DI (Weekly Category Sales with Discount Rate)
Data:
| Week | Electronics (₹ lakhs) | Fashion (₹ lakhs) | Home (₹ lakhs) | Beauty (₹ lakhs) | Discount on Total (%) |
|---|---|---|---|---|---|
| W1 | 240 | 180 | 150 | 90 | 12 |
| W2 | 260 | 175 | 160 | 95 | 10 |
| W3 | 255 | 190 | 155 | 100 | 11 |
| W4 | 275 | 205 | 165 | 110 | 13 |
Questions (MCQ):
Q1: What is the net total sales in W4 after applying the given discount on total?
A) 655.85 lakhs;
B) 656.85 lakhs;
C) 657.85 lakhs;
D) 658.85 lakhs;
Q2: What is the overall percentage increase in gross total sales from W1 to W4?
A) 14.09%;
B) 14.39%;
C) 14.69%;
D) 14.99%;
Q3: Which week has the highest net sales (after discount)?
A) W1;
B) W2;
C) W3;
D) W4;
Q4: In W2, Electronics should be reduced by 4% and Fashion should be increased by 3% (others unchanged). What is the revised W2 gross total?
A) 683.85 lakhs;
B) 684.85 lakhs;
C) 685.85 lakhs;
D) 686.85 lakhs;
Q5: Net sales increase (%) from average of (W1, W2) to average of (W3, W4) is:
A) 6.29%;
B) 6.49%;
C) 6.69%;
D) 6.89%;
Answers and Explanations:
Answer (Q1): B) 656.85 lakhs
Explanation: W4 total = 275+205+165+110 = 755. Discount = 13% ⇒ net = 755×0.87.
Net = 656.85 lakhs.
Answer (Q2): B) 14.39%
Explanation: W1 total = 660. W4 total = 755.
% change = (755−660)/660 × 100 = 14.39% (approx).
Answer (Q3): D) W4
Explanation: Net totals: W1 = 660×0.88 = 580.8; W2 = 690×0.90 = 621.0; W3 = 700×0.89 = 623.0; W4 = 656.85.
Highest net is W4.
Answer (Q4): B) 684.85 lakhs
Explanation: Corrected Electronics = 260×0.96 = 249.6. Corrected Fashion = 175×1.03 = 180.25.
Revised total = 249.6+180.25+160+95 = 684.85 lakhs.
Answer (Q5): B) 6.49%
Explanation: Avg net (W1,W2) = (580.8+621.0)/2 = 600.9. Avg net (W3,W4) = (623.0+656.85)/2 = 639.925.
% increase = (639.925−600.9)/600.9 × 100 = 6.49% (approx).
DI Set 6: Table DI (Quarterly Profit of 4 Retail Stores)
Data:
| Store | Q1 (₹ lakhs) | Q2 (₹ lakhs) | Q3 (₹ lakhs) | Q4 (₹ lakhs) |
|---|---|---|---|---|
| A | 86 | 90 | 88 | 99 |
| B | 92 | 95 | 101 | 106 |
| C | 78 | 84 | 89 | 94 |
| D | 96 | 93 | 97 | 103 |
Questions (MCQ):
Q1: What is the overall percentage increase in total profit from Q1 to Q4 (all stores together)?
A) 14.06%;
B) 14.20%;
C) 14.35%;
D) 14.49%;
Q2: If a flat 9% tax is applied on the total Q4 profit, what is the net Q4 profit?
A) 365.46 lakhs;
B) 365.82 lakhs;
C) 366.18 lakhs;
D) 366.54 lakhs;
Q3: What is Store B’s percentage share in the annual total profit (Q1+Q2+Q3+Q4 of all stores)?
A) 26.23%;
B) 26.43%;
C) 26.63%;
D) 26.83%;
Q4: In Q5, each store’s profit becomes: Q5 = Q4 + 60% of (Q4 − Q1). What is the total profit in Q5?
A) 431.20 lakhs;
B) 432.00 lakhs;
C) 432.80 lakhs;
D) 433.60 lakhs;
Q5: By what percentage does the average of total profits of (Q2, Q3, Q4) exceed the total profit of Q1?
A) 7.66%;
B) 7.86%;
C) 8.06%;
D) 8.26%;
Answers and Explanations:
Answer (Q1): B) 14.20%
Explanation: Total Q1 = 86+92+78+96 = 352. Total Q4 = 99+106+94+103 = 402.
% change = (402−352)/352 × 100 = 14.20% (approx).
Answer (Q2): B) 365.82 lakhs
Explanation: Total Q4 = 402 lakhs. Net after 9% tax = 402 × (1−0.09) = 402 × 0.91.
Net = 365.82 lakhs.
Answer (Q3): B) 26.43%
Explanation: Store B annual = 92+95+101+106 = 394. Total annual (all) = 1491.
Share % = 394/1491 × 100 = 26.43% (approx).
Answer (Q4): B) 432.00 lakhs
Explanation: For each store, add 60% of (Q4−Q1): A +7.8, B +8.4, C +9.6, D +4.2.
Q5 total = (99+7.8)+(106+8.4)+(94+9.6)+(103+4.2) = 432.0 lakhs.
Answer (Q5): B) 7.86%
Explanation: Total Q2=362, Q3=375, Q4=402 ⇒ average = (362+375+402)/3 = 379.67.
% = (379.67−352)/352 × 100 = 7.86% (approx).
DI Set 7: Table DI (Production and Defects in 4 Plants)
Data:
| Plant | Jan Prod | Jan Def | Feb Prod | Feb Def | Mar Prod | Mar Def | Apr Prod | Apr Def |
|---|---|---|---|---|---|---|---|---|
| P1 | 1200 | 36 | 1250 | 40 | 1300 | 39 | 1380 | 41 |
| P2 | 1100 | 33 | 1180 | 35 | 1240 | 38 | 1290 | 36 |
| P3 | 980 | 29 | 1020 | 31 | 1090 | 30 | 1150 | 34 |
| P4 | 1050 | 32 | 1070 | 30 | 1120 | 33 | 1200 | 35 |
Questions (MCQ):
Q1: What is the overall defect rate in April (total defects as a % of total production)?
A) 2.88%;
B) 2.91%;
C) 2.94%;
D) 2.97%;
Q2: What is the overall percentage increase in total production from Jan to Apr?
A) 15.74%;
B) 15.94%;
C) 16.14%;
D) 16.34%;
Q3: Which plant shows the maximum improvement (reduction) in defect rate from Jan to Apr?
A) P1;
B) P2;
C) P3;
D) P4;
Q4: In March, 25% of defective units are successfully reworked and counted as good units. What is the total good units in March after rework (all plants together)?
A) 4639 units;
B) 4645 units;
C) 4651 units;
D) 4657 units;
Q5: What is the overall percentage increase in total defective units from Jan to Apr?
A) 12.11%;
B) 12.31%;
C) 12.51%;
D) 12.71%;
Answers and Explanations:
Answer (Q1): B) 2.91%
Explanation: Total Apr production = 1380+1290+1150+1200 = 5020. Total Apr defects = 41+36+34+35 = 146.
Defect rate = 146/5020 × 100 = 2.91% (approx).
Answer (Q2): B) 15.94%
Explanation: Total Jan production = 4330. Total Apr production = 5020.
% change = (5020−4330)/4330 × 100 = 15.94% (approx).
Answer (Q3): B) P2
Explanation: Defect rate P2: Jan = 33/1100 ×100 = 3.00%, Apr = 36/1290 ×100 ≈ 2.79%.
Reduction ≈ 0.21 percentage points, highest among plants.
Answer (Q4): B) 4645 units
Explanation: Total Mar production = 4750, total Mar defects = 140.
Good after rework = production − 75% of defects = 4750 − (0.75×140) = 4750 − 105 = 4645.
Answer (Q5): B) 12.31%
Explanation: Total defects Jan = 130, Apr = 146.
% change = (146−130)/130 × 100 = 12.31% (approx).
DI Set 8: Table DI (State Budget Allocation Across Sectors)
Data:
| Sector | 2022 (₹ cr) | 2023 (₹ cr) | 2024 (₹ cr) | 2025 (₹ cr) |
|---|---|---|---|---|
| Education | 320 | 340 | 360 | 390 |
| Health | 250 | 265 | 285 | 305 |
| Transport | 180 | 195 | 205 | 220 |
| Agriculture | 210 | 225 | 240 | 255 |
| IT | 140 | 155 | 170 | 185 |
Questions (MCQ):
Q1: What is the overall percentage increase in total budget from 2022 to 2025?
A) 22.98%;
B) 23.18%;
C) 23.38%;
D) 23.58%;
Q2: In 2025, a 6% cut is applied to every sector. Then 10% of the reduced Health budget is transferred to Education. What is the new Education budget?
A) 394.71 cr;
B) 395.27 cr;
C) 395.83 cr;
D) 396.39 cr;
Q3: What is the percentage share of (Education + Health) in the total 2024 budget?
A) 50.99%;
B) 51.19%;
C) 51.39%;
D) 51.59%;
Q4: In 2024, Transport is increased by 10% and Agriculture is decreased by 8% (others unchanged). What is the revised total 2024 budget?
A) 1260.50 cr;
B) 1261.30 cr;
C) 1262.10 cr;
D) 1262.90 cr;
Q5: What is the overall percentage increase in combined (IT + Transport) budget from 2022 to 2025?
A) 26.36%;
B) 26.56%;
C) 26.76%;
D) 26.96%;
Answers and Explanations:
Answer (Q1): B) 23.18%
Explanation: Total 2022 = 1100. Total 2025 = 1355.
% change = (1355−1100)/1100 × 100 = 23.18% (approx).
Answer (Q2): B) 395.27 cr
Explanation: Reduced Education = 390×0.94 = 366.60. Reduced Health = 305×0.94 = 286.70.
Transfer = 10% of 286.70 = 28.67. New Education = 366.60 + 28.67 = 395.27 cr.
Answer (Q3): B) 51.19%
Explanation: (Education+Health) in 2024 = 360+285 = 645. Total 2024 = 1260.
Share % = 645/1260 × 100 = 51.19% (approx).
Answer (Q4): B) 1261.30 cr
Explanation: Transport change: 205→225.50 (+20.50). Agriculture change: 240→220.80 (−19.20).
Net change = +1.30, so revised total = 1260 + 1.30 = 1261.30 cr.
Answer (Q5): B) 26.56%
Explanation: (IT+Transport) 2022 = 140+180 = 320. (IT+Transport) 2025 = 185+220 = 405.
% change = (405−320)/320 × 100 = 26.56%.
DI Set 9: Table DI (Leads and Conversions by Marketing Channel)
Data:
| Channel | Jan Leads | Jan Conv | Feb Leads | Feb Conv | Mar Leads | Mar Conv | Apr Leads | Apr Conv |
|---|---|---|---|---|---|---|---|---|
| Organic | 850 | 170 | 900 | 189 | 950 | 209 | 1000 | 230 |
| Paid | 650 | 130 | 700 | 140 | 750 | 150 | 800 | 160 |
| Social | 520 | 104 | 560 | 112 | 600 | 120 | 640 | 128 |
| 400 | 120 | 420 | 126 | 440 | 132 | 460 | 138 |
Questions (MCQ):
Q1: What is the overall conversion rate in April (total conversions as a % of total leads)?
A) 22.42%;
B) 22.62%;
C) 22.82%;
D) 23.02%;
Q2: What is the overall percentage increase in total conversions from Jan to Apr?
A) 24.99%;
B) 25.19%;
C) 25.39%;
D) 25.59%;
Q3: Which channel shows the highest improvement in conversion rate from Jan to Apr?
A) Organic;
B) Paid;
C) Social;
D) Email;
Q4: In April, 12.5% of Paid leads are shifted to Organic (Paid leads decrease, Organic leads increase). Both channels keep their April conversion rates. What is the new total conversions in April?
A) 657;
B) 659;
C) 661;
D) 663;
Q5: Find the difference (in percentage points) between:
- % change in total conversions (Jan→Apr), and
- % change in total leads (Jan→Apr).
A) 5.16 pp;
B) 5.36 pp;
C) 5.56 pp;
D) 5.76 pp;
Answers and Explanations:
Answer (Q1): B) 22.62%
Explanation: Total Apr leads = 2900. Total Apr conversions = 656.
Conversion rate = 656/2900 × 100 = 22.62% (approx).
Answer (Q2): B) 25.19%
Explanation: Total Jan conversions = 524. Total Apr conversions = 656.
% change = (656−524)/524 × 100 = 25.19% (approx).
Answer (Q3): A) Organic
Explanation: Organic rate: Jan = 170/850 = 20%, Apr = 230/1000 = 23%.
Increase = 3 percentage points, highest among channels.
Answer (Q4): B) 659
Explanation: 12.5% of Paid leads in Apr = 12.5% of 800 = 100 leads moved to Organic.
New Paid leads = 700 ⇒ conv = 20% of 700 = 140; New Organic leads = 1100 ⇒ conv = 23% of 1100 = 253.
Total conv = 253+140+128+138 = 659.
Answer (Q5): B) 5.36 pp
Explanation: % change conversions = 25.19% (from Q2). % change leads = (2900−2420)/2420 ×100 = 19.83% (approx).
Difference = 25.19 − 19.83 = 5.36 percentage points (approx).
DI Set 10: Table DI (Orders and Returns by Product Category)
Data:
| Category | Aug Orders | Aug Returns | Sep Orders | Sep Returns | Oct Orders | Oct Returns | Nov Orders | Nov Returns |
|---|---|---|---|---|---|---|---|---|
| Electronics | 4200 | 210 | 4500 | 225 | 4800 | 240 | 5200 | 260 |
| Fashion | 5000 | 350 | 5200 | 364 | 5400 | 378 | 5600 | 392 |
| Home | 3100 | 155 | 3300 | 165 | 3500 | 175 | 3600 | 180 |
| Beauty | 2600 | 130 | 2700 | 135 | 2900 | 145 | 3000 | 152 |
Questions (MCQ):
Q1: What is the overall percentage increase in net delivered orders from Aug to Nov (net = orders − returns)?
A) 16.60%;
B) 16.80%;
C) 17.00%;
D) 17.20%;
Q2: What is the overall return rate in October (total returns as a % of total orders)?
A) 5.55%;
B) 5.65%;
C) 5.75%;
D) 5.85%;
Q3: In Nov, Fashion returns reduce by 12% (other categories unchanged). What is the revised net delivered total in Nov?
A) 16442.08;
B) 16463.04;
C) 16484.00;
D) 16504.96;
Q4: Which category has the highest overall percentage increase in net delivered orders from Aug to Nov?
A) Electronics;
B) Fashion;
C) Home;
D) Beauty;
Q5: In Nov, assume 25% of returns are successfully exchanged and counted as delivered. What is the effective delivered orders in Nov?
A) 16638;
B) 16662;
C) 16686;
D) 16710;
Answers and Explanations:
Answer (Q1): B) 16.80%
Explanation: Total net Aug = (14900−845) = 14055. Total net Nov = (17400−984) = 16416.
% change = (16416−14055)/14055 × 100 = 16.80% (approx).
Answer (Q2): B) 5.65%
Explanation: Total Oct orders = 16600. Total Oct returns = 938.
Return rate = 938/16600 × 100 = 5.65% (approx).
Answer (Q3): B) 16463.04
Explanation: Fashion Nov returns reduce by 12%: 392×0.88 = 344.96, reduction = 392−344.96 = 47.04.
Net increases by 47.04, so revised Nov net = 16416 + 47.04 = 16463.04.
Answer (Q4): A) Electronics
Explanation: Net Electronics: Aug = 4200−210 = 3990; Nov = 5200−260 = 4940.
% change = (4940−3990)/3990 × 100 = 23.81% (highest).
Answer (Q5): B) 16662
Explanation: Effective delivered = orders − 75% of returns (because 25% returns become delivered).
Nov effective = 17400 − 0.75×984 = 17400 − 738 = 16662.
DI Set 11: Table DI (Deposits and Withdrawals of 4 Bank Branches)
Data:
| Branch | Jan Deposits (₹ lakhs) | Jan Withdrawals (₹ lakhs) | Feb Deposits (₹ lakhs) | Feb Withdrawals (₹ lakhs) | Mar Deposits (₹ lakhs) | Mar Withdrawals (₹ lakhs) | Apr Deposits (₹ lakhs) | Apr Withdrawals (₹ lakhs) |
|---|---|---|---|---|---|---|---|---|
| A | 260 | 210 | 275 | 220 | 290 | 235 | 310 | 250 |
| B | 240 | 195 | 255 | 205 | 270 | 215 | 295 | 230 |
| C | 220 | 180 | 235 | 190 | 250 | 200 | 265 | 210 |
| D | 280 | 225 | 295 | 235 | 305 | 245 | 325 | 260 |
Questions (MCQ):
Q1: What is the overall percentage increase in total net inflow from Jan to Apr, where net inflow = Deposits − Withdrawals (all branches together)?
A) 28.75%;
B) 28.95%;
C) 29.15%;
D) 29.35%;
Q2: In March, the bank earns a service charge = 5% of withdrawals (added to income). What is the total effective net inflow in March for all branches, where effective net inflow = Deposits − Withdrawals + 5% of Withdrawals?
A) 264.45 lakhs;
B) 264.75 lakhs;
C) 265.05 lakhs;
D) 265.35 lakhs;
Q3: Which branch has the highest cumulative net inflow from Jan to Apr (net inflow each month = Deposits − Withdrawals)?
A) Branch A;
B) Branch B;
C) Branch C;
D) Branch D;
Q4: In April, deposits of each branch increase by 4% and withdrawals of each branch decrease by 3%. What is the revised total net inflow in April (all branches together)?
A) 320.90 lakhs;
B) 321.30 lakhs;
C) 321.70 lakhs;
D) 322.10 lakhs;
Q5: By what percentage does the average monthly deposits of (A and D together) exceed the average monthly deposits of (B and C together) for Jan–Apr?
A) 15.07%;
B) 15.27%;
C) 15.47%;
D) 15.67%;
Answers and Explanations:
Answer (Q1): B) 28.95%
Explanation: Total net Jan = (260−210)+(240−195)+(220−180)+(280−225) = 190.
Total net Apr = (310−250)+(295−230)+(265−210)+(325−260) = 245.
% increase = (245−190)/190 × 100 = 28.95% (approx).
Answer (Q2): B) 264.75 lakhs
Explanation: Effective net = Deposits − Withdrawals + 0.05×Withdrawals = Deposits − 0.95×Withdrawals.
March total = Σ(Deposits − 0.95×Withdrawals) = 264.75 lakhs.
Answer (Q3): D) Branch D
Explanation: Cumulative net: A=220, B=215, C=190, D=240 (sum of monthly nets Jan–Apr).
Highest is Branch D.
Answer (Q4): B) 321.30 lakhs
Explanation: Revised April net = Σ(1.04×Deposits − 0.97×Withdrawals).
Total = 321.30 lakhs.
Answer (Q5): B) 15.27%
Explanation: Avg deposits (A+D) = (A deposits total + D deposits total)/4 = 585.0 lakhs.
Avg deposits (B+C) = (B deposits total + C deposits total)/4 = 507.5 lakhs.
% = (585−507.5)/507.5 × 100 = 15.27% (approx).
DI Set 12: Table DI (Course Enrolment and Completion Across Two Terms)
Data:
| Course | Fee per Student (₹) | Term-1 Enrolled | Term-1 Completed | Term-2 Enrolled | Term-2 Completed |
|---|---|---|---|---|---|
| TA | 8000 | 520 | 392 | 560 | 424 |
| RA | 7500 | 500 | 360 | 520 | 384 |
| DI | 9000 | 470 | 324 | 500 | 340 |
| ICT | 8500 | 510 | 384 | 540 | 408 |
Questions (MCQ):
Q1: What is the overall percentage increase in total completions from Term-1 to Term-2 (all courses together)?
A) 6.38%;
B) 6.58%;
C) 6.78%;
D) 6.98%;
Q2: In Term-2, completers pay 100% fee, and non-completers pay 40% fee. What is the total fee collected in Term-2 (₹ lakhs)?
A) 146.28 lakhs;
B) 146.68 lakhs;
C) 147.08 lakhs;
D) 147.48 lakhs;
Q3: What is the increase in overall completion rate from Term-1 to Term-2 (in percentage points)?
A) 0.28 pp;
B) 0.40 pp;
C) 0.52 pp;
D) 0.64 pp;
Q4: In Term-2, a scholarship of 5% of fee is given to top 25% of completers in each course. What is the total scholarship amount (₹ lakhs)?
A) 1.40 lakhs;
B) 1.60 lakhs;
C) 1.80 lakhs;
D) 2.00 lakhs;
Q5: In each term, the fee is collected at enrolment, but 12% of fee is refunded for non-completers. What is the overall percentage increase in net fee revenue from Term-1 to Term-2 (₹)?
A) 5.88%;
B) 6.08%;
C) 6.28%;
D) 6.48%;
Answers and Explanations:
Answer (Q1): B) 6.58%
Explanation: Total completed Term-1 = 392+360+324+384 = 1460.
Total completed Term-2 = 424+384+340+408 = 1556.
% increase = (1556−1460)/1460 × 100 = 6.58% (approx).
Answer (Q2): B) 146.68 lakhs
Explanation: Term-2 revenue = Σ[Completed×Fee + (Enrolled−Completed)×0.40×Fee].
Total = ₹14,668,000 = 146.68 lakhs.
Answer (Q3): B) 0.40 pp
Explanation: Term-1 completion rate = 1460/2000 ×100 = 73.00%.
Term-2 completion rate = 1556/2120 ×100 = 73.40% (approx).
Increase = 73.40 − 73.00 = 0.40 percentage points.
Answer (Q4): B) 1.60 lakhs
Explanation: Top 25% of Term-2 completers: TA 106, RA 96, DI 85, ICT 102.
Scholarship = Σ(Count×Fee×5%) = ₹160,000 = 1.60 lakhs.
Answer (Q5): B) 6.08%
Explanation: Net revenue = Σ[Enrolled×Fee − (Enrolled−Completed)×0.12×Fee].
Term-1 = 159.40 lakhs (approx), Term-2 = 169.10 lakhs (approx).
% increase = (169.10−159.40)/159.40 ×100 = 6.08% (approx).
DI Set 13: Table DI (Electricity Consumption of 4 Factories)
Data:
| Factory | Jan (000 units) | Feb (000 units) | Mar (000 units) | Apr (000 units) |
|---|---|---|---|---|
| F1 | 480 | 500 | 530 | 560 |
| F2 | 450 | 470 | 510 | 540 |
| F3 | 520 | 515 | 525 | 550 |
| F4 | 490 | 505 | 535 | 570 |
Questions (MCQ):
Q1: Tariff per unit is: Jan ₹6.2, Feb ₹6.3, Mar ₹6.5, Apr ₹6.8. What is the overall percentage increase in total electricity bill from Jan to Apr (₹ lakhs)?
(Use: Bill in ₹ lakhs = Total (000 units) × Tariff / 100)
A) 25.31%;
B) 25.51%;
C) 25.71%;
D) 25.91%;
Q2: In March, a 3% penalty is added to a factory’s March bill if its March consumption is more than 520 (000 units). What is the total March bill after penalty (₹ lakhs)?
A) 139.20 lakhs;
B) 139.60 lakhs;
C) 140.00 lakhs;
D) 140.40 lakhs;
Q3: In April, base tariff is ₹6.8/unit, but for consumption above 550 (000 units), an extra surcharge applies, so those extra units are charged at ₹7.2/unit. What is the total April bill (₹ lakhs)?
A) 150.88 lakhs;
B) 151.08 lakhs;
C) 151.28 lakhs;
D) 151.48 lakhs;
Q4: Which factory has the highest percentage increase in consumption from Jan to Apr?
A) F1;
B) F2;
C) F3;
D) F4;
Q5: Let the total May consumption be 5% less than the average of total consumption of Jan–Apr. If May consumption is distributed among factories in the same ratio as their April consumption, what will be May consumption of F2 (000 units)?
A) 476.20;
B) 476.60;
C) 477.00;
D) 477.40;
Answers and Explanations:
Answer (Q1): B) 25.51%
Explanation: Total Jan units = 1940 ⇒ bill = 1940×6.2/100 = 120.28 lakhs.
Total Apr units = 2220 ⇒ bill = 2220×6.8/100 = 150.96 lakhs.
% increase = (150.96−120.28)/120.28 ×100 = 25.51% (approx).
Answer (Q2): B) 139.60 lakhs
Explanation: March bills (₹ lakhs) = units×6.5/100; apply 3% only if units > 520.
Penalty factories: F1, F3, F4.
Total after penalty = 139.60 lakhs (approx).
Answer (Q3): B) 151.08 lakhs
Explanation: For each factory: bill = (min(units,550)×6.8 + max(units−550,0)×7.2)/100.
Sum of all factories’ April bills = 151.08 lakhs.
Answer (Q4): B) F2
Explanation: % increase: F1 = 16.67%, F2 = 20.00%, F3 = 5.77%, F4 = 16.33%.
Highest is F2.
Answer (Q5): B) 476.60
Explanation: Monthly totals: Jan 1940, Feb 1990, Mar 2100, Apr 2220 ⇒ average = 2062.5.
May total = 0.95×2062.5 = 1959.375.
F2 share = 540/2220, so F2 May = 1959.375×(540/2220) = 476.60 (approx).
DI Set 14: Table DI (Production, Sales, Returns, and Pricing of 4 Products)
Data:
| Product | SP (₹/unit) | CP (₹/unit) | H1 Produced | H1 Sold | H1 Returns | H2 Produced | H2 Sold | H2 Returns |
|---|---|---|---|---|---|---|---|---|
| A | 1200 | 750 | 5000 | 4700 | 180 | 5400 | 5100 | 200 |
| B | 950 | 600 | 6200 | 5800 | 220 | 6500 | 6100 | 240 |
| C | 1500 | 980 | 4100 | 3900 | 140 | 4500 | 4200 | 160 |
| D | 1100 | 700 | 5600 | 5200 | 200 | 5900 | 5500 | 210 |
Questions (MCQ):
Q1: Net sold units = Sold − Returns. What is the overall percentage increase in total net sold units from H1 to H2?
A) 6.32%;
B) 6.52%;
C) 6.72%;
D) 6.92%;
Q2: In H2, every returned unit is refurbished and resold at 60% of SP. So, H2 revenue per product = (Sold−Returns)×SP + Returns×0.60×SP. What is the total H2 revenue (₹ lakhs)?
A) 238.49 lakhs;
B) 238.89 lakhs;
C) 239.29 lakhs;
D) 239.69 lakhs;
Q3: In H1, assume returns are fully refunded (no resale). So, H1 profit = (Sold−Returns)×SP − Produced×CP. What is the total H1 profit (₹ lakhs)?
A) 64.17 lakhs;
B) 64.57 lakhs;
C) 64.97 lakhs;
D) 65.37 lakhs;
Q4: In H2, CP of every product reduces by 4%, and SP increases by 3% only for products B and D (A and C unchanged). Returns are refunded (no resale). What is the new total H2 profit (₹ lakhs)?
A) 77.97 lakhs;
B) 78.37 lakhs;
C) 78.77 lakhs;
D) 79.17 lakhs;
Q5: Using the base rule (no resale, returns refunded), what is the overall percentage increase in total profit from H1 to H2?
A) 5.67%;
B) 5.87%;
C) 6.07%;
D) 6.27%;
Answers and Explanations:
Answer (Q1): B) 6.52%
Explanation: Total net sold H1 = Σ(Sold−Returns) = 18860.
Total net sold H2 = 20090.
% increase = (20090−18860)/18860 ×100 = 6.52% (approx).
Answer (Q2): B) 238.89 lakhs
Explanation: Revenue = Σ[(Sold−Returns)×SP + Returns×0.60×SP] = Σ[SP×(Sold−0.40×Returns)].
Total = ₹23,889,400 = 238.89 lakhs.
Answer (Q3): B) 64.57 lakhs
Explanation: Profit H1 = Σ[(Sold−Returns)×SP − Produced×CP].
Total = ₹6,457,000 = 64.57 lakhs.
Answer (Q4): B) 78.37 lakhs
Explanation: New CP = 0.96×CP for all products. New SP = 1.03×SP for B and D only.
Profit H2 new = Σ[(H2 net sold)×(new SP) − (H2 produced)×(new CP)].
Total = 78.37 lakhs (approx).
Answer (Q5): B) 5.87%
Explanation: Base profit H1 = 64.57 lakhs; base profit H2 = 68.36 lakhs.
% increase = (68.36−64.57)/64.57 ×100 = 5.87% (approx).
DI Set 15: Table DI (Quarter-wise Tourists and Spend in 4 Destinations)
Data:
| Destination | Avg Spend per Visitor (₹) | Q1 Tourists (000) | Q2 Tourists (000) | Q3 Tourists (000) | Q4 Tourists (000) |
|---|---|---|---|---|---|
| Goa | 3200 | 240 | 260 | 300 | 340 |
| Kerala | 2800 | 220 | 240 | 270 | 310 |
| Rajasthan | 2500 | 200 | 215 | 240 | 280 |
| Himachal | 2700 | 210 | 230 | 260 | 295 |
Questions (MCQ):
Q1: Total tourism revenue in Q4 is calculated as: Revenue (₹ cr) = Tourists(000) × Avg Spend / 10000. What is the total Q4 revenue (₹ cr)?
A) 344.85 cr;
B) 345.25 cr;
C) 345.65 cr;
D) 346.05 cr;
Q2: What is the overall percentage increase in total tourists from Q1 to Q4 (all destinations together)?
A) 40.60%;
B) 40.80%;
C) 41.00%;
D) 41.20%;
Q3: In Q3, Kerala and Himachal give 5% cashback on spend (so their effective revenue reduces by 5%). What is the revised total Q3 revenue (₹ cr)?
A) 294.11 cr;
B) 294.51 cr;
C) 294.91 cr;
D) 295.31 cr;
Q4: Which destination has the highest percentage growth in tourists from Q1 to Q4?
A) Goa;
B) Kerala;
C) Rajasthan;
D) Himachal;
Q5: For each destination, compute average quarterly revenue (Q1–Q4). Marketing budget is 10% of this average. By what percentage is the combined marketing budget of (Goa + Kerala) higher than (Rajasthan + Himachal)?
A) 30.37%;
B) 30.57%;
C) 30.77%;
D) 30.97%;
Answers and Explanations:
Answer (Q1): B) 345.25 cr
Explanation: Q4 revenue = Σ[Tourists×Spend/10000].
Goa 108.80, Kerala 86.80, Rajasthan 70.00, Himachal 79.65.
Total = 345.25 cr.
Answer (Q2): B) 40.80%
Explanation: Total tourists Q1 = 240+220+200+210 = 870.
Total tourists Q4 = 340+310+280+295 = 1225.
% increase = (1225−870)/870 ×100 = 40.80% (approx).
Answer (Q3): B) 294.51 cr
Explanation: Base Q3 revenue total = 301.80 cr.
Reduce Kerala and Himachal Q3 revenues by 5% only.
Revised total = 294.51 cr.
Answer (Q4): A) Goa
Explanation: % growth Q1→Q4: Goa 41.67%, Kerala 40.91%, Rajasthan 40.00%, Himachal 40.48%.
Highest is Goa.
Answer (Q5): B) 30.57%
Explanation: Compute each destination’s average quarterly revenue, then take 10% as marketing.
Marketing(Goa+Kerala) = 16.40 cr; Marketing(Rajasthan+Himachal) = 12.56 cr.
% higher = (16.40−12.56)/12.56 ×100 = 30.57% (approx).