Tables: Concepts & Solved Examples
Master multi-column tabular data, missing data matrices, cross-tabulations, growth rates, index-based tables, and rapid ratio calculations.
Comprehensive Conceptual Framework: Tables & Multi-Dimensional Matrices
Tables represent the most foundational, ubiquitous, and versatile data representation instrument in Quantitative Aptitude and Data Interpretation (DILR) for CAT and IPMAT. Unlike graphs, which encode numeric magnitudes visually via geometric coordinates, bars, or angles, a Table presents raw, tabular data organized into discrete rows and columns.
In high-stakes competitive examinations, tables test not merely passive reading, but active multi-step synthesis: identifying hierarchical structures, deducing missing entries via algebraic invariants, executing rapid mental ratio approximations, evaluating base-shift indices, and tracking chronological flow across transaction matrices.
1. Architectural Taxonomy of Tabular Datasets
A. Multi-Column Performance & Demographic Tables
-
Structural Design: Features individual entities (e.g., nations, enterprise divisions, product lines) as rows, with heterogeneous metrics (absolute population, per-capita rates, annual revenue, operating margin %, employee count, and average salary) distributed across columns.
-
Intensive vs. Extensive Variables:
-
Extensive Variables: Depend on system size and aggregate additively across entities (e.g., Total Revenue, Total Energy Stored, Total Population, Number of Engineers).
-
Intensive Variables: Independent of system size; express per-unit rates, averages, or percentages (e.g., Per-Capita Energy Consumption, Operating Margin %, Average Salary). Intensive variables cannot be added across rows without weighting by their underlying base.
-
-
The Dimensional Product Principle: Tabular problems frequently define a secondary metric as the product or quotient of two primary table columns:
-
Analytical Caution: Never rank or compare entities based solely on intensive rates (e.g., per-capita consumption or profit margin %) without weighting by the underlying base volume (population or total sales).
B. Missing Data Matrices & Constraint Satisfaction
-
Structural Design: A table where several cells are omitted or replaced by dashes (
—). The candidate must reconstruct the table before answering specific questions. -
The Conservation Invariant (Row/Column Sum Rule):
In chemical mixtures, demographic distributions, or market share breakdowns, the sum of percentages across all constituent categories for any single entity must strictly sum to :
-
Linear Algebraic Reconstruction:
If an entity contains missing cells, the constraint reduces the degrees of freedom to . Additional blending ratios, weighted average conditions, or marginal equalities provide the remaining simultaneous linear equations:
Solving this system of linear equations yields unique, unambiguous values for the missing entries.
C. 2D Cross-Tabulations & Contingency Tables
-
Structural Design: Bivariate distribution matrices where rows represent demographic tiers or geographical segments, and columns represent categorical choices or preferences.
-
Marginal Row and Column Totals:
-
Diagonal Slant Headers:
When a cell represents dual orthogonal dimensions, the header is partitioned diagonally:
-
Top-Right Label: Column Header ()
-
Bottom-Left Label: Row Header ()
Semantic HTML representation:
<th class="diagonal-header"><span class="diagonal-col">ColHeader →</span><span class="diagonal-row">↓ RowHeader</span></th> -
-
Deductive Case Analysis: When column labels () are blinded, match known contextual properties (e.g., "In segment , rejected all options" or "Totals of and differ by 120") against the matrix margins to eliminate impossible permutations and isolate valid structural cases.
D. Rolling Balance & Transaction Ledger Tables
-
Structural Design: Chronological accounting registers tracking credits, debits, and progressive account balances across arbitrary calendar intervals.
-
The Accounting Equation:
-
Average Monthly Balance (AMB) with Day Weighting:
Interest in corporate or escrow bank accounts is calculated not on the closing balance, but on the calendar day-weighted daily balance:
where represents the exact number of calendar days for which the account balance remained unchanged at , and (, or days).
2. Quantitative Arithmetic & Rapid Mental Approximations
A. Percentage Change & Growth Formulations
-
Simple Percentage Change:
-
Compound Annual Growth Rate (CAGR):
CAT Rapid Approximation Rule: For small to moderate growth rates over periods, approximate CAGR by dividing simple overall growth by and deducting a modest compounding correction:
-
The Rule of 72:
If an economic metric grows at per annum, it doubles in approximately years.
B. Index-Based Normalization & Real Deflation
-
Base Year Indexing: Normalizes disparate time series by anchoring a designated base period to 100:
-
Deflating Nominal Values to Real Output:
When a table presents nominal revenue alongside a Wholesale Price Index (WPI) or Consumer Price Index (CPI):
-
Index Splicing: When a table shifts its base year from Year to Year , convert series across the transition using the ratio of index values in the overlapping year:
C. Rapid Ratio Comparisons without Division
When comparing two tabular ratios and :
-
Cross-Multiplication Test:
-
Proportional Shift / Growth Comparison Method:
Express and :
-
If Numerator percentage growth Denominator percentage growth , then .
-
If , then .
Example: Compare with .
-
-
-
Since , the ratio has increased: .
-
-
Residual / Complement Comparison:
When fractions are close to 1:
The fraction with the smaller residual is the larger fraction.
D. Weighted Averages & Alligation in Tabular Mixtures
When combining entities with proportions :
To achieve a target concentration by mixing two components () and ():
3. Critical Traps & Cognitive Pitfalls in CAT/IPMAT Tables
-
"Percentage of" vs. "Percentage more/less than":
-
"Entity A is what percent of Entity B?"
-
"Entity A is what percent MORE than Entity B?"
Confusing these two formulas introduces an automatic error.
-
-
The Missing Data Zero Fallacy:
A dash (
—) or blank cell indicates unreported or suppressed data, NOT a numeric zero, unless the preamble explicitly clarifies that blank cells represent zero. -
Per-Capita vs. Gross Volume Blindness:
A country or division may boast a higher per-capita rate, but if its population/headcount is smaller, its gross absolute contribution is significantly lower. Always compute gross volume before answering questions on aggregate shares.
-
Calendar Day Counting Anomalies:
When calculating day-weighted average balances across months:
-
January: 31 days
-
February: 28 days (or 29 in leap years)
-
March: 31 days
-
April: 30 days
Miscounting the number of days in an intermediate bracket by 1 alters the denominator and generates incorrect choices that test-makers deliberately plant.
-
-
Base-Shift in Step-by-Step Growth:
If revenue increases by in Year 1 and decreases by in Year 2, the final revenue is NOT equal to the original:
4. Step-by-Step Strategic Protocol for Solving Tabular Sets
-
Phase 1 — Structural Reconnaissance (30 seconds):
-
Read row headers, column headers, units (crores, lakhs, millions, tonnes, percentages).
-
Check footnotes for operational definitions (e.g., Margin = Profit / Sales).
-
Note whether totals are row-wise, column-wise, or unprovided.
-
-
Phase 2 — Question Categorization & Triage (45 seconds):
-
Direct Lookup / Single-Step: Questions answerable in under 45 seconds via single division or observation.
-
Multi-Step Deductive: Questions requiring missing value algebra or multi-row summation.
-
Conditional Scenarios: Questions introducing "What if" modifications (e.g., a 50% salary hike or business closure).
-
-
Phase 3 — Minimal Calculation & Option Scanning:
-
Scan option spreads. If options differ by , round numbers to 2 or 3 significant figures.
-
Look at the last digit or magnitude of products to eliminate 2 out of 4 options immediately.
-
In mixture problems, verify boundary conditions using alligation before setting up full equations.
-
Formulas
| Percentage Change | |
|---|---|
| Compound Annual Growth Rate (CAGR) | |
| Rapid Ratio Comparison Test | |
| Index-Based Deflation | |
| Weighted Average of Tabular Components | |
| Average Monthly Balance (AMB) |
Traps and tips
- Trap: 'Percentage of' vs. 'Percentage more than' — 'A is what % of B' equals (A/B)*100, whereas 'A is what % more than B' equals ((A-B)/B)*100. Confusing them causes an immediate 100% error.
- Trap: Missing Data Assumptions — Never assume missing or dashed cells represent zero unless explicitly stated. Look for conservation constraints (e.g. sum of parts = 100%) or marginal balance equations.
- Trap: Per-Capita vs. Gross Volume — High per-capita or intensive rates do not imply high aggregate output. Gross volume equals per-unit rate multiplied by underlying volume/headcount.
- Tip: Proportional Shift for Fractions — To compare two large fractions, determine which grew faster: if the numerator grew by a higher percentage than the denominator, the fraction increased.
- Tip: Calendar Duration Precision — In Average Monthly Balance (AMB) questions, verify the exact day count for each balance bracket (e.g., non-leap Feb = 28 days, Apr = 30 days) to avoid off-by-one errors.
Solved examples
Solved Example Set 1: Questions 1 to 4
Directions for Examples 1 to 4
Answer the questions on the basis of the information given below.
The table given below shows the average battery storage capacity per installation module (in MWh) and the total number of deployed grid storage modules (in thousands) across six clean-tech renewable energy consortia during the period 2021–2024. The total energy stored by all global battery installations (in thousand MWh / GWh) in 2021, 2022, 2023, and 2024 was 42,000, 44,000, 46,000, and 48,000 respectively.
| Clean-Tech Consortium | Average Storage Capacity per Module (in MWh) | Deployed Storage Modules (in thousands) | ||||||
|---|---|---|---|---|---|---|---|---|
| 2021 | 2022 | 2023 | 2024 | 2021 | 2022 | 2023 | 2024 | |
| Titan Grid | 5.0 | 5.0 | 5.5 | 6.0 | 1600 | 1650 | 1700 | 1750 |
| Helios Power | 10.0 | 10.0 | — | 10.0 | 110 | 112 | 115 | 118 |
| Orion Energy | 0.4 | 0.4 | 0.5 | 0.5 | 1200 | 1250 | 1300 | 1350 |
| Zephyr Storage | 1.2 | 1.2 | 1.1 | 1.4 | 160 | 165 | 170 | 175 |
| Boreas Utilities | 1.0 | 1.0 | 1.0 | 1.1 | 180 | 185 | 190 | 195 |
| Stellar Dynamics | 0.25 | 0.25 | 0.25 | 0.25 | 350 | 360 | 370 | 380 |
1. The total energy stored by Titan Grid was approximately what percent of the total energy stored globally during the given period?
(1) 12%
(2) 20%
(3) 25%
(4) 28%
2. The total energy stored by Boreas Utilities and Zephyr Storage put together was approximately what percent of that of Orion Energy and Stellar Dynamics put together during the given period?
(1) 60%
(2) 45%
(3) 75%
(4) 70%
3. If the total energy stored by Helios Power was 2.4% of the total energy stored globally during the given period, then what was the average battery capacity per storage module (in MWh) of Helios Power in 2023?
(1) 7
(2) 10
(3) 9
(4) 8
4. The total energy stored by which consortium was second lowest in 2022?
(1) Helios Power
(2) Boreas Utilities
(3) Orion Energy
(4) Zephyr Storage
Show solution
Step-by-Step Solution & Deductions
Question 1:
-
Answer: Option (2) [20%]
-
Calculation:
Total energy stored globally during 2021–2024:
Total energy stored by Titan Grid during 2021–2024 ():
Required percentage:
Question 2:
-
Answer: Option (1) [60%]
-
Calculation:
Total energy stored by Boreas Utilities and Zephyr Storage:
-
Boreas Utilities:
-
Zephyr Storage:
-
Combined (Boreas + Zephyr):
Total energy stored by Orion Energy and Stellar Dynamics:
-
Orion Energy:
-
Stellar Dynamics:
-
Combined (Orion + Stellar):
Required percentage:
-
Question 3:
-
Answer: Option (4) [8]
-
Calculation:
Let the average battery capacity per storage module of Helios Power in 2023 be MWh.
Helios Power's total energy stored over 2021–2024 is of :
Using the formula :
Question 4:
-
Answer: Option (2) [Boreas Utilities]
-
Calculation:
Energy stored in 2022 for each consortium ():
-
Stellar Dynamics: (Lowest)
-
Boreas Utilities: (Second Lowest)
-
Zephyr Storage:
-
Orion Energy:
-
Helios Power:
-
Titan Grid:
Therefore, the second lowest stored energy in 2022 was achieved by Boreas Utilities.
-
Takeaway: Always verify whether the dataset specifies total aggregate values or per-unit intensive rates before multiplying by the volume base.
Solved Example Set 2: Questions 5 to 8
Directions for Examples 5 to 8
Answer the questions on the basis of the information given below.
The following table provides partial information about the chemical dopant composition of six different aerospace semiconductor thin-film substrates, namely Substrate A, Substrate B, Substrate C, Substrate D, Substrate E, and Substrate F. Each of these six substrates is synthesized from five core chemical dopants: Silicon, Titanium, Germanium, Gallium, and Arsenic. A master composite substrate G, the composition of which is not given in the table, is synthesized by mixing substrates A, B, and C in the ratio 2 : 1 : 3. It is also known that in composite G, Titanium, Germanium, and Gallium are present in equal quantities.
| Substrate | Silicon | Titanium | Germanium | Gallium | Arsenic |
|---|---|---|---|---|---|
| A | 15% | 35% | — | — | 10% |
| B | 20% | 20% | 45% | 5% | 10% |
| C | 10% | — | 25% | — | 30% |
| D | 25% | 20% | 15% | 30% | 10% |
| E | 10% | 45% | 25% | 5% | 15% |
| F | 35% | 15% | 5% | 30% | 15% |
5. Find the percentage of Gallium in Substrate A.
(1) 100/9%
(2) 100/3%
(3) 20/9%
(4) 20/3%
6. If a composite formulation X, which contains 15% Arsenic, at least 15% Silicon, and at most 20% Gallium, is to be synthesized, how many combinations of exactly two of the six mentioned substrates can be used to produce it?
(1) Three
(2) Four
(3) Five
(4) Two
7. Which of the following can be a value of the ratio in which substrates A, E, and F need to be mixed to get at least 12% Germanium in the resulting composite?
(1) 4 : 1 : 1
(2) 2 : 1 : 3
(3) 1 : 3 : 2
(4) 1 : 1 : 4
8. If a composite blend Z, which contains at least 13.5% Arsenic, is to be formulated using the substrates mentioned in the table, the percentage of Substrate B in composite blend Z cannot exceed:
(1) 92.50%
(2) 82.50%
(3) 78.20%
(4) 86.40%
Show solution
Step-by-Step Solution & Deductions
Algebraic Formulation of Missing Values
Since the sum of percentages of the 5 dopants in any substrate formulation must equal 100%:
-
In Substrate A: Silicon (15%) + Titanium (35%) + Arsenic (10%) = 60%.
Hence, .
Let Germanium in A be , then Gallium in A is .
-
In Substrate C: Silicon (10%) + Germanium (25%) + Arsenic (30%) = 65%.
Hence, .
Let Titanium in C be , then Gallium in C is .
The reconstructed table structure is:
| Substrate | Silicon | Titanium | Germanium | Gallium | Arsenic |
|---|---|---|---|---|---|
| A | 15% | 35% | x% | (40 – x)% | 10% |
| B | 20% | 20% | 45% | 5% | 10% |
| C | 10% | y% | 25% | (35 – y)% | 30% |
| D | 25% | 20% | 15% | 30% | 10% |
| E | 10% | 45% | 25% | 5% | 15% |
| F | 35% | 15% | 5% | 30% | 15% |
Composite G contains A, B, and C in the ratio (total parts = 6).
Quantities of Titanium, Germanium, and Gallium in Composite G:
-
Titanium:
-
Germanium:
-
Gallium:
Since Titanium, Germanium, and Gallium are present in equal quantity in G:
From
From
Adding (1) and (2):
Substituting into (1):
Question 5:
-
Answer: Option (2) [100/3%]
-
Calculation:
Percentage of Gallium in Substrate A .
Question 6:
-
Answer: Option (4) [Two]
-
Calculation:
Composite X must satisfy:
-
Arsenic = 15%
-
Silicon 15%
-
Gallium 20%
Arsenic contents across substrates: A (10%), B (10%), C (30%), D (10%), E (15%), F (15%).
-
Case 1: Combining two substrates both having 15% Arsenic.
E (15% Arsenic) and F (15% Arsenic): Any mixture has 15% Arsenic.
Let ratio be .
Silicon .
Gallium .
Since , valid mixing ratios exist. Thus, (E, F) is valid.
-
Case 2: Combining one substrate with Arsenic and one with Arsenic.
Only Substrate C has Arsenic (30%).
To achieve 15% Arsenic, the ratio with any 10% Arsenic substrate must be:
-
Pair (A, C): Silicon in 3:1 mix (Invalid).
-
Pair (B, C):
Silicon in 3:1 mix (Valid).
Gallium in 3:1 mix (Valid).
Thus, (B, C) is valid.
-
Pair (D, C):
Silicon in 3:1 mix .
Gallium in 3:1 mix (Invalid).
-
Thus, there are exactly 2 valid pairs: (E and F) and (B and C).
-
Question 7:
-
Answer: Option (3) [1 : 3 : 2]
-
Calculation:
Germanium percentages: A , E , F .
Testing options:
-
Option (1) :
-
Option (2) :
-
Option (3) : (Satisfies condition)
-
Option (4) :
-
Question 8:
-
Answer: Option (2) [82.50%]
-
Calculation:
Arsenic in Substrate B = 10%, which is less than the required 13.5%.
To maximize the proportion of B, combine B with the substrate having the maximum possible percentage of Arsenic.
The substrate with the highest Arsenic content is Substrate C (30%).
Let the fraction of Substrate B be . Then the fraction of C is .
Takeaway: In missing-value mixture matrices, use the 100% row constraint to express missing values in terms of minimal variables, then set up linear equations from balanced conditions.
Solved Example Set 3: Questions 9 to 12
Directions for Examples 9 to 12
Answer the questions on the basis of the information given below.
A global cloud infrastructure consultancy conducted an adoption survey among 1200 enterprise IT decision-makers in each of three customer segments: Family Offices, Sovereign Wealth Funds, and Pension Endowments. In the survey, all participants were requested to select exactly one of four options (P, Q, R, or S) indicating their preferred backend architecture for the next decade. One of the four options corresponded to "Retain Legacy On-Premise" (not adopting any modern cloud architecture), and each of the other three corresponded to a distinct modern architecture: Serverless Architecture, Microservices Mesh, and Event-Driven Streaming. The table below records the responses received:
| Option →↓ Enterprise Segment | P | Q | R | S | Total |
|---|---|---|---|---|---|
| Family Offices | 120 | 460 | 160 | 460 | 1200 |
| Sovereign Wealth Funds | 230 | 440 | 260 | 270 | 1200 |
| Pension Endowments | 250 | 300 | 300 | 350 | 1200 |
| Total | 600 | 1200 | 720 | 1080 | 3600 |
The research director who compiled the survey knew which option coded for which architecture and derived the following conclusions:
I. In Pension Endowments, as many as 25% of all participants opted to Retain Legacy On-Premise.
II. The total number of participants across all segments who selected Microservices Mesh differed from the total number who selected Event-Driven Streaming by exactly 120.
9. If it was in Family Offices where the minimum number of participants preferred Serverless Architecture, then which of the following can be definitely concluded?
(1) It was in Sovereign Wealth Funds where the maximum number of participants preferred Microservices Mesh.
(2) It was in Sovereign Wealth Funds where the minimum number of participants preferred Event-Driven Streaming.
(3) It was in Family Offices where the maximum number of participants preferred Microservices Mesh.
(4) It was in Family Offices where the minimum number of participants opted to Retain Legacy On-Premise.
10. If Event-Driven Streaming was preferred by the minimum number of participants in all three enterprise segments put together, then which of the following statements is definitely false?
(1) Out of the participants who preferred Microservices Mesh in the three enterprise segments, the minimum number belonged to Family Offices.
(2) Out of the participants who preferred Serverless Architecture in the three enterprise segments, the minimum number belonged to Sovereign Wealth Funds.
(3) Out of the participants who opted to Retain Legacy On-Premise in the three enterprise segments, the minimum number belonged to Family Offices.
(4) Out of the participants who opted to Retain Legacy On-Premise in the three enterprise segments, the maximum number belonged to Family Offices.
11. In Pension Endowments, if the number of participants who preferred Serverless Architecture was the minimum, then which of the following is definitely true?
(1) In Family Offices, the number of participants who preferred neither Microservices Mesh nor Event-Driven Streaming was 350.
(2) In Pension Endowments, the number of participants who preferred neither Serverless Architecture nor Event-Driven Streaming was 650.
(3) In Sovereign Wealth Funds, the number of participants who preferred neither Microservices Mesh nor Serverless Architecture was 700.
(4) In Pension Endowments, the number of participants who preferred neither Microservices Mesh nor Event-Driven Streaming was 550.
12. A maximum of how many of the following five statements can simultaneously be true?
I. In Family Offices, 160 participants opted to Retain Legacy On-Premise.
II. In Pension Endowments, 250 participants preferred Event-Driven Streaming.
III. In Sovereign Wealth Funds, 270 participants preferred Microservices Mesh.
IV. In Pension Endowments, 300 participants preferred Event-Driven Streaming.
V. In Sovereign Wealth Funds, 230 participants preferred Serverless Architecture.
(1) 4
(2) 3
(3) 2
(4) 5
Show solution
Step-by-Step Solution & Deductions
Deducing the Four Possible Cases
-
Director's Observation I: In Pension Endowments, 25% of participants opted to Retain Legacy On-Premise.
In Pension Endowments, both Option Q and Option R have exactly 300 participants. Therefore, the "Retain Legacy On-Premise" option must be either Q or R.
-
Director's Observation II: The overall totals of Microservices Mesh and Event-Driven Streaming differ by 120.
-
If Q is "Retain Legacy On-Premise":
(Retain Legacy On-Premise).
The remaining options have totals: , , .
Pairwise differences:
.
.
.
Hence, the two options for Microservices Mesh and Event-Driven Streaming must be P and R. This leaves S = Serverless Architecture.
-
Case I: , , ,
-
Case II: , , ,
-
-
If R is "Retain Legacy On-Premise":
(Retain Legacy On-Premise).
The remaining options have totals: , , .
Pairwise differences:
.
.
.
Hence, the two options for Microservices Mesh and Event-Driven Streaming must be Q and S. This leaves P = Serverless Architecture.
-
Case III: , , ,
-
Case IV: , , ,
-
-
| Possible Cases | P | Q | R | S |
|---|---|---|---|---|
| Case I | Event-Driven Streaming | Retain Legacy | Microservices Mesh | Serverless |
| Case II | Microservices Mesh | Retain Legacy | Event-Driven Streaming | Serverless |
| Case III | Serverless | Microservices Mesh | Retain Legacy | Event-Driven Streaming |
| Case IV | Serverless | Event-Driven Streaming | Retain Legacy | Microservices Mesh |
Question 9:
-
Answer: Option (4)
-
Calculation:
In Family Offices, counts are: , , , .
The minimum count is . If Serverless Architecture is minimum in Family Offices, Option P must represent Serverless Architecture.
This indicates Case III or Case IV is valid.
In both Case III and Case IV, Option R represents "Retain Legacy On-Premise".
Counts for Option R across segments: Family Offices = 160, Sovereign Wealth Funds = 260, Pension Endowments = 300.
The minimum number of participants who retained legacy on-premise is in Family Offices (160).
Hence, statement (4) can definitely be concluded.
Question 10:
-
Answer: Option (3)
-
Calculation:
Event-Driven Streaming has the minimum total participants among all architectures.
Total counts across the 4 options: , , , .
The minimum overall count is 600 (Option P). Thus, Option P must be Event-Driven Streaming.
From our table of cases, only Case I has .
In Case I:
-
Event-Driven Streaming , Retain Legacy , Microservices Mesh , Serverless .
-
"Retain Legacy On-Premise" counts (Option Q): Family Offices = 460, Sovereign Wealth Funds = 440, Pension Endowments = 300.
-
The minimum number who retained legacy belongs to Pension Endowments (300), not Family Offices.
-
Therefore, statement (3) ("Out of the participants who opted to Retain Legacy On-Premise in the three enterprise segments, the minimum number belonged to Family Offices") is definitely false.
-
Question 11:
-
Answer: Option (4)
-
Calculation:
In Pension Endowments, counts are: , , , .
The minimum count is . Since Serverless Architecture is minimum in Pension Endowments, Option P must be Serverless Architecture.
This validates Cases III and IV (, , and ).
In Pension Endowments, participants who preferred neither Microservices Mesh nor Event-Driven Streaming:
This directly matches option (4).
Question 12:
-
Answer: Option (1) [4]
-
Calculation:
Evaluating each statement against the 4 possible cases:
-
Statement I: In Family Offices, 160 retained legacy (Holds in Cases III & IV).
-
Statement II: In Pension Endowments, 250 preferred Event-Driven Streaming (Holds in Case I).
-
Statement III: In Sovereign Wealth Funds, 270 preferred Microservices Mesh (Holds in Cases II & IV).
-
Statement IV: In Pension Endowments, 300 preferred Event-Driven Streaming (Holds in Cases II, III, & IV).
-
Statement V: In Sovereign Wealth Funds, 230 preferred Serverless Architecture (Holds in Cases III & IV).
Testing Case IV (, , , ):
-
Statement I: .
-
Statement II: (P is Serverless).
-
Statement III: .
-
Statement IV: (Pension Endowments: ) .
-
Statement V: (Sovereign Wealth Funds: ) .
Statements I, III, IV, and V are simultaneously true (4 statements).
-
Takeaway: In categorical preference surveys, anchor your deduction on unambiguous constraints (such as an exact percentage in one segment) to identify extreme counts and establish the distinct possible cases.
Solved Example Set 4: Questions 13 to 17
Directions for Examples 13 to 17
Answer the questions based on the table given below.
The following table shows the annual business details of an enterprise technology firm, Vanguard Cloud Dynamics, across two divisions and two market channels.
| Division | Market Channel | Annual Revenue (in ₹) | Operating Margin (%) | Number of Engineers | Annual Salary per Engineer (in ₹) |
|---|---|---|---|---|---|
| AI Software | Domestic Enterprise | 0.40 crore | 25% | 20 | 30000 |
| International Cloud | 2.50 crore | 40% | 25 | 150000 | |
| Edge Hardware | Domestic Enterprise | 0.60 crore | 30% | 30 | 20000 |
| International Cloud | 3.00 crore | 50% | 50 | 100000 |
Note: .
13. If the salary of each Edge Hardware Domestic engineer is increased by 50%, what is the new overall operating margin percentage of the company? (All other factors remain unchanged)
(1) 38.50%
(2) 42.31%
(3) 45.00%
(4) 40.25%
14. If the annual salary per engineer of AI Software Domestic division is made equal to the annual salary per engineer of Edge Hardware Domestic division, what is the percentage increase in the AI Software Domestic operating margin?
(1) 15.0%
(2) 20.0%
(3) 25.0%
(4) 30.0%
15. If in each division and market category the annual revenue increases by 15%, what is the total operating profit of the company? (The margins remain the same)
(1) ₹2.85 crore
(2) ₹3.20 crore
(3) ₹3.45 crore
(4) Data insufficient
16. If the International Cloud revenues for both AI Software and Edge Hardware increase by 20% and the Domestic Enterprise business across both divisions is completely shut down, what is the overall net change in the operating profit of the company? (Operating margins remain constant)
(1) ₹15 lakh
(2) ₹22 lakh
(3) ₹28 lakh
(4) ₹50 lakh
17. The company plans an advanced AI upskilling program for the AI Software Domestic engineers, with training expenditure amounting to ₹15,000 per engineer. What will be the new operating margin percentage in the AI Software Domestic division if the company executes this training plan?
(1) 15.0%
(2) 17.5%
(3) 20.0%
(4) Cannot be determined
Show solution
Step-by-Step Solution & Deductions
Baseline Financial Calculations
-
Total Revenue of the company .
-
Baseline Operating Profits by division ():
-
AI Software Domestic:
-
AI Software International:
-
Edge Hardware Domestic:
-
Edge Hardware International:
-
Total Initial Operating Profit .
-
Question 13:
-
Answer: Option (2) [42.31%]
-
Calculation:
Salary increase per Edge Hardware Domestic engineer .
Total additional cost for 30 engineers .
New total operating profit .
New company operating margin percentage:
Question 14:
-
Answer: Option (2) [20.0%]
-
Calculation:
Current salary of AI Software Domestic engineer = ₹30,000.
New salary = ₹20,000 (same as Edge Hardware Domestic).
Savings per engineer .
Net decrease in cost for 20 engineers .
Earlier AI Software Domestic profit = ₹10.0 lakh.
New AI Software Domestic profit .
Percentage increase in profit (and thus margin):
Question 15:
-
Answer: Option (2) [₹3.20 crore]
-
Calculation:
Since revenue in each category increases by 15% while operating margins remain unchanged, the profit from each category (and consequently total company profit) increases by exactly 15%:
Question 16:
-
Answer: Option (2) [₹22 lakh]
-
Calculation:
-
Increase in profit from International Cloud expansion (20% increase):
-
AI Software International:
-
Edge Hardware International:
-
Total increase in international profit
-
-
Loss in profit from closing Domestic Enterprise operations:
-
AI Software Domestic:
-
Edge Hardware Domestic:
-
Total domestic profit lost
-
-
Net overall change in profit (Net increase of ₹22 lakh).
-
Question 17:
-
Answer: Option (2) [17.5%]
-
Calculation:
Initial AI Software Domestic profit = ₹10.0 lakh.
Total training expenditure .
New profit .
Annual revenue of AI Software Domestic .
New margin percentage:
Takeaway: When sales or salary modifications are applied, isolate the incremental changes in revenue and costs rather than recalculating the entire income statement from scratch.
Solved Example Set 5: Questions 18 to 20
Directions for Examples 18 to 20
Answer the questions on the basis of the information given below.
The following table provides the transaction register of a corporate liquidity escrow account maintained by NexaCore Ventures at Zenith Custody Bank during the period January 2023 to April 2023. The balance in the escrow account as on December 31, 2022 was ₹20,000.
| Date | Transaction Details | Debit (₹) | Credit (₹) | Closing Balance (₹) |
|---|---|---|---|---|
| 10-Jan | By Wire Inflow (Client Milestone) | NA | 14000 | 34000 |
| 30-Jan | By Clearing CHQ 567890 | NA | 16000 | 50000 |
| 31-Jan | To Vendor Payout (Debit) | 30000 | NA | 20000 |
| 17-Feb | To Equipment Lease CHQ 234567 | — | NA | 8600 |
| 23-Feb | To API Infrastructure Settlement | 2200 | NA | 6400 |
| 28-Feb | By Wire Inflow (Retainer Fee) | NA | 7600 | 14000 |
| 11-Mar | To Cloud Host Direct Debit (ECS) | 2575 | NA | — |
| 24-Mar | To Operating Expenses Sweep | 7250 | NA | — |
| 31-Mar | By Equity Tranche CHQ 238129 | NA | 47750 | 52000 |
| 23-Apr | By Enterprise Contract Advance | NA | 32940 | 85000 |
| 30-Apr | To Inter-Bank Sweep (IB TFR) | 25320 | NA | 59680 |
Zenith Custody Bank credits monthly liquidity yield at the rate of 0.5% per month on the Average Monthly Balance (AMB). The interest, the details of which are not shown in the raw transaction log, is credited to the account on the last day of each month after all scheduled transactions for that day are concluded.
18. What was the total balance in the escrow account at the end of April 30?
(1) ₹59680
(2) ₹59980
(3) ₹60280
(4) ₹59850
19. During the given four-month period, what was the average monthly interest credited to NexaCore's account?
(1) ₹146.25
(2) ₹150.00
(3) ₹142.50
(4) ₹155.00
20. What was the amount of the equipment lease cheque debited from NexaCore's account on 17th February?
(1) ₹10550
(2) ₹11550
(3) ₹12000
(4) ₹11250
Show solution
Step-by-Step Solution & Deductions
Month-by-Month Balance & Interest Reconstruction
1. Month of January (31 days):
-
Jan 1 to Jan 9 (9 days): Balance = ₹20,000
-
Jan 10 to Jan 29 (20 days): Credit of ₹14,000 Balance = ₹34,000
-
Jan 30 (1 day): Cheque credit of ₹16,000 Balance = ₹50,000
-
Jan 31 (1 day): Vendor payout debit of ₹30,000 Balance before interest = ₹20,000
2. Month of February (28 days in non-leap year 2023):
-
Feb 1 to Feb 16 (16 days): Balance = ₹20,150
-
Feb 17 to Feb 22 (6 days): Balance after equipment lease cheque debit = ₹8,600
-
Feb 23 to Feb 27 (5 days): API settlement debit of ₹2,200 Balance = ₹6,400
-
Feb 28 (1 day): Retainer credit of ₹7,600 Balance before interest = ₹14,000
3. Month of March (31 days):
-
Mar 1 to Mar 10 (10 days): Balance = ₹14,075
-
Mar 11 to Mar 23 (13 days): ECS debit of ₹2,575 Balance =
-
Mar 24 to Mar 30 (7 days): Operating expenses debit of ₹7,250 Balance =
-
Mar 31 (1 day): Equity tranche credit of ₹47,750 Balance before interest =
4. Month of April (30 days):
-
Apr 1 to Apr 22 (22 days): Balance = ₹52,060
-
Apr 23 to Apr 29 (7 days): Contract advance credit of ₹32,940 Balance =
-
Apr 30 (1 day): Inter-bank sweep debit of ₹25,320 Balance before interest =
Answers:
-
Question 18: Total balance at the end of April 30 is ₹59,980 Option (2).
-
Question 19: Total interest .
Average monthly interest Option (1).
-
Question 20: Balance on Feb 16 was ₹20,150, and balance after cheque debit on Feb 17 was ₹8,600.
Cheque amount Option (2).
Takeaway: For interest calculations based on Average Monthly Balance (AMB), calculate day-weighted balances strictly according to the calendar duration of each balance bracket.
Practice questions
Question 1 · Foundation
Directions for Question 1
The following table presents the population (in millions) and per capita electricity consumption (in kWh/year) of five states in 2023.
| State | Population (millions) | Per Capita Consumption (kWh) |
|---|---|---|
| State A | 40 | 1500 |
| State B | 60 | 1200 |
| State C | 25 | 2400 |
| State D | 50 | 1800 |
| State E | 80 | 750 |
What percentage of the total electricity consumed by all five states combined is accounted for by State D?
Show answer and explanation
Answer: (B) 26.32%
Step-by-step calculation:
-
Compute total electricity consumption for each state ():
-
State A:
-
State B:
-
State C:
-
State D:
-
State E:
-
-
Sum the total consumption across all five states:
-
Calculate State D's percentage share:
Question 2 · Foundation
Directions for Question 2
A metallurgical laboratory analyzes three ternary alloys composed exclusively of Copper, Zinc, and Nickel. The table below displays partial composition percentages.
| Alloy | Copper (%) | Zinc (%) | Nickel (%) |
|---|---|---|---|
| Alloy P | 45% | 35% | — |
| Alloy Q | 30% | — | 25% |
| Alloy R | — | 20% | 50% |
If Alloy P, Alloy Q, and Alloy R are melted together in the ratio 2 : 3 : 5 by weight, what is the percentage of Nickel in the resulting combined alloy?
Show answer and explanation
Answer: (C) 36.5%
Step-by-step calculation:
-
Fill in missing percentages using the constraint that each alloy sums to 100%:
-
Alloy P Nickel:
-
Alloy Q Nickel: (given)
-
Alloy R Nickel: (given)
-
-
Apply weighted average using the mixing ratio :
Question 3 · Foundation
Directions for Question 3
A survey of 600 consumers evaluated preference among three smartphone brands: Apex, Bolt, and Crest. Respondents chose either one favorite brand or 'None'. The table records counts across three demographics:
| Option →↓ Demographic | Option W | Option X | Option Y | Option Z | Total |
|---|---|---|---|---|---|
| Students | 40 | 80 | 50 | 30 | 200 |
| Professionals | 60 | 50 | 70 | 20 | 200 |
| Retirees | 30 | 30 | 100 | 40 | 200 |
| Total | 130 | 160 | 220 | 90 | 600 |
It is known that:
-
Exactly 15% of all respondents chose 'None'.
-
The total number of people who preferred Apex was 60 fewer than those who preferred Crest.
Which option in the survey form corresponds to the 'None' response, and which option corresponds to brand Apex?
Show answer and explanation
Answer: (A) None is Z; Apex is X
Step-by-step deduction:
-
Identify the 'None' option:
Examining the column totals:
, , , .
Only Option Z has a total of 90. Therefore, Option Z represents 'None'.
-
Identify the brand options among W (130), X (160), and Y (220):
We are given: .
Checking differences between the remaining totals:
The only pair with a difference of 60 is , which means:
-
Option Y = Crest (220)
-
Option X = Apex (160)
-
Option W = Bolt (130)
-
Therefore, 'None' is Option Z and 'Apex' is Option X.
Question 4 · Foundation
Directions for Question 4
The table below shows the financial metrics of the three divisions of NovaTech Solutions for FY 2024.
| Division | Annual Revenue (₹ crore) | Operating Profit Margin (%) | Headcount | Average Annual Salary (₹) |
|---|---|---|---|---|
| Cloud Services | 4.0 | 25% | 50 | 4,00,000 |
| Cybersecurity | 6.0 | 20% | 60 | 5,00,000 |
| AI Solutions | 10.0 | 30% | 80 | 6,00,000 |
Note: .
If NovaTech implements an across-the-board salary hike of ₹1,00,000 per employee for all divisions while annual revenues remain unchanged, what is the new overall operating profit margin of the company?
Show answer and explanation
Answer: (D) 16.5%
Step-by-step calculation:
-
Compute total revenue and baseline operating profit:
-
Total Revenue
-
Baseline Profit:
-
Cloud Services:
-
Cybersecurity:
-
AI Solutions:
-
Total Baseline Profit
-
-
-
Calculate total additional salary expenditure:
-
Total Headcount
-
Additional Cost
-
-
Calculate new profit and overall margin:
-
New Operating Profit
-
New Margin $= \frac{₹3.30\text{ crore}}{₹20.00\text{ crore}} \times 100 = 16.5%$$
-
Question 5 · Foundation
Directions for Question 5
A savings bank account calculates monthly interest on the Average Monthly Balance (AMB). During a 30-day month (April), the account balance history before monthly interest credit was as follows:
| Date Range | Duration | Day-End Balance (₹) |
|---|---|---|
| April 1 to April 10 | 10 days | ₹30,000 |
| April 11 to April 25 | 15 days | ₹50,000 |
| April 26 to April 30 | 5 days | ₹30,000 |
The bank credits monthly interest at the rate of 0.5% on the Average Monthly Balance on the final day of the month.
What is the total closing balance in the account at the end of April after interest is credited?
Show answer and explanation
Answer: (B) ₹30,200
Step-by-step calculation:
-
Compute the day-weighted balance for each period in April (30 days total):
-
Days 1 to 10 (10 days):
-
Days 11 to 25 (15 days):
-
Days 26 to 30 (5 days):
-
-
Calculate the Average Monthly Balance (AMB):
-
Calculate the interest credited on April 30:
-
Determine final closing balance:
Try real CAT questions
Study this concept with interactive practice in PrepSoc.
Open the concept library