Free CAT library

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:

    Aggregate Metric=Intensive Rate×Extensive Capacity\text{Aggregate Metric} = \text{Intensive Rate} \times \text{Extensive Capacity}

    e.g., Total Energy Stored (MWh)=Capacity per Module (MWh)×Number of Modules\text{e.g., Total Energy Stored (MWh)} = \text{Capacity per Module (MWh)} \times \text{Number of Modules}

    Total Profit=Revenue×Margin %100\text{Total Profit} = \text{Revenue} \times \frac{\text{Margin \%}}{100}

  • 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 100%100\%:

    ∑j=1kPi,j=100%∀ entity i\sum_{j=1}^{k} P_{i, j} = 100\% \quad \forall \text{ entity } i

  • Linear Algebraic Reconstruction:

    If an entity contains mm missing cells, the 100%100\% constraint reduces the degrees of freedom to m−1m - 1. Additional blending ratios, weighted average conditions, or marginal equalities provide the remaining simultaneous linear equations:

    w1C1+w2C2+⋯+wnCn=Cmixw_1 C_1 + w_2 C_2 + \dots + w_n C_n = C_{\text{mix}}

    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:

    Row Totali=∑j=1CXi,j,Column Totalj=∑i=1RXi,j,Grand Total=∑i=1RRow Totali=∑j=1CColumn Totalj\text{Row Total}_i = \sum_{j=1}^{C} X_{i, j}, \quad \text{Column Total}_j = \sum_{i=1}^{R} X_{i, j}, \quad \text{Grand Total} = \sum_{i=1}^{R} \text{Row Total}_i = \sum_{j=1}^{C} \text{Column Total}_j

  • Diagonal Slant Headers:

    When a cell represents dual orthogonal dimensions, the header is partitioned diagonally:

    • Top-Right Label: Column Header (Col→\text{Col} \rightarrow)

    • Bottom-Left Label: Row Header (↓Row\downarrow \text{Row})

    Semantic HTML representation: <th class="diagonal-header"><span class="diagonal-col">ColHeader &rarr;</span><span class="diagonal-row">&darr; RowHeader</span></th>

  • Deductive Case Analysis: When column labels (P,Q,R,SP, Q, R, S) are blinded, match known contextual properties (e.g., "In segment MM, 25%25\% rejected all options" or "Totals of AA and BB 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:

    Closing Balancet=Balancet−1+Creditt−Debitt\text{Closing Balance}_t = \text{Balance}_{t-1} + \text{Credit}_t - \text{Debit}_t

  • 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:

    AMB=∑k=1m(Balancek×Δtk)Total Days in Month\text{AMB} = \frac{\sum_{k=1}^{m} \left(\text{Balance}_k \times \Delta t_k\right)}{\text{Total Days in Month}}

    where Δtk\Delta t_k represents the exact number of calendar days for which the account balance remained unchanged at Balancek\text{Balance}_k, and ∑Δtk=Nmonth\sum \Delta t_k = N_{\text{month}} (28,29,3028, 29, 30, or 3131 days).


2. Quantitative Arithmetic & Rapid Mental Approximations

A. Percentage Change & Growth Formulations

  1. Simple Percentage Change:

    Δ%=Valuefinal−ValueinitialValueinitial×100\Delta\% = \frac{\text{Value}_{\text{final}} - \text{Value}_{\text{initial}}}{\text{Value}_{\text{initial}}} \times 100

  2. Compound Annual Growth Rate (CAGR):

    CAGR=(VnV0)1n−1\text{CAGR} = \left(\frac{V_n}{V_0}\right)^{\frac{1}{n}} - 1

    CAT Rapid Approximation Rule: For small to moderate growth rates over nn periods, approximate CAGR by dividing simple overall growth by nn and deducting a modest compounding correction:

    CAGR≈Vn−V0n⋅V0−(n−1)2(Vn−V0n⋅V0)2\text{CAGR} \approx \frac{V_n - V_0}{n \cdot V_0} - \frac{(n-1)}{2} \left(\frac{V_n - V_0}{n \cdot V_0}\right)^2

  3. The Rule of 72:

    Doubling Time Tdouble≈72r%\text{Doubling Time } T_{\text{double}} \approx \frac{72}{r\%}

    If an economic metric grows at 8%8\% per annum, it doubles in approximately 728=9\frac{72}{8} = 9 years.

B. Index-Based Normalization & Real Deflation

  • Base Year Indexing: Normalizes disparate time series by anchoring a designated base period to 100:

    Indext=ValuetValuebase×100\text{Index}_t = \frac{\text{Value}_t}{\text{Value}_{\text{base}}} \times 100

  • Deflating Nominal Values to Real Output:

    When a table presents nominal revenue alongside a Wholesale Price Index (WPI) or Consumer Price Index (CPI):

    Real Valuet=Nominal ValuetPrice Indext×100\text{Real Value}_t = \frac{\text{Nominal Value}_t}{\text{Price Index}_t} \times 100

  • Index Splicing: When a table shifts its base year from Year AA to Year BB, convert series across the transition using the ratio of index values in the overlapping year:

    Spliced Index=Old Index×New Base Overlap ValueOld Base Overlap Value\text{Spliced Index} = \text{Old Index} \times \frac{\text{New Base Overlap Value}}{\text{Old Base Overlap Value}}

C. Rapid Ratio Comparisons without Division

When comparing two tabular ratios N1D1\frac{N_1}{D_1} and N2D2\frac{N_2}{D_2}:

  1. Cross-Multiplication Test:

    N1D1>N2D2  ⟺  N1⋅D2>N2⋅D1\frac{N_1}{D_1} > \frac{N_2}{D_2} \iff N_1 \cdot D_2 > N_2 \cdot D_1

  2. Proportional Shift / Growth Comparison Method:

    Express N2=N1(1+gN)N_2 = N_1 (1 + g_N) and D2=D1(1+gD)D_2 = D_1 (1 + g_D):

    • If Numerator percentage growth gN>g_N > Denominator percentage growth gDg_D, then N2D2>N1D1\frac{N_2}{D_2} > \frac{N_1}{D_1}.

    • If gN<gDg_N < g_D, then N2D2<N1D1\frac{N_2}{D_2} < \frac{N_1}{D_1}.

    Example: Compare 438891\frac{438}{891} with 465942\frac{465}{942}.

    • ΔN=27  ⟹  gN=27438≈6.16%\Delta N = 27 \implies g_N = \frac{27}{438} \approx 6.16\%

    • ΔD=51  ⟹  gD=51891≈5.72%\Delta D = 51 \implies g_D = \frac{51}{891} \approx 5.72\%

    • Since gN(6.16%)>gD(5.72%)g_N (6.16\%) > g_D (5.72\%), the ratio has increased: 465942>438891\frac{465}{942} > \frac{438}{891}.

  3. Residual / Complement Comparison:

    When fractions are close to 1:

    ND=1−D−ND\frac{N}{D} = 1 - \frac{D - N}{D}

    The fraction with the smaller residual D−ND\frac{D - N}{D} is the larger fraction.

D. Weighted Averages & Alligation in Tabular Mixtures

When combining entities E1,E2,…,EkE_1, E_2, \dots, E_k with proportions w1:w2:⋯:wkw_1 : w_2 : \dots : w_k:

Xˉmix=w1X1+w2X2+⋯+wkXkw1+w2+⋯+wk\bar{X}_{\text{mix}} = \frac{w_1 X_1 + w_2 X_2 + \dots + w_k X_k}{w_1 + w_2 + \dots + w_k}

To achieve a target concentration CtargetC_{\text{target}} by mixing two components AA (CAC_A) and BB (CBC_B):

wAwB=∣CB−Ctarget∣∣CA−Ctarget∣\frac{w_A}{w_B} = \frac{|C_B - C_{\text{target}}|}{|C_A - C_{\text{target}}|}


3. Critical Traps & Cognitive Pitfalls in CAT/IPMAT Tables

  1. "Percentage of" vs. "Percentage more/less than":

    • "Entity A is what percent of Entity B?"   ⟹  AB×100\implies \frac{A}{B} \times 100

    • "Entity A is what percent MORE than Entity B?"   ⟹  A−BB×100=(AB−1)×100\implies \frac{A - B}{B} \times 100 = \left(\frac{A}{B} - 1\right) \times 100

    Confusing these two formulas introduces an automatic 100%100\% error.

  2. The Missing Data ≠\neq 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.

  3. Per-Capita vs. Gross Volume Blindness:

    A country or division may boast a 10×10\times higher per-capita rate, but if its population/headcount is 100×100\times smaller, its gross absolute contribution is significantly lower. Always compute gross volume before answering questions on aggregate shares.

  4. 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.

  5. Base-Shift in Step-by-Step Growth:

    If revenue increases by 20%20\% in Year 1 and decreases by 20%20\% in Year 2, the final revenue is NOT equal to the original:

    V2=V0×1.20×0.80=0.96⋅V0  ⟹  Net decrease of 4%V_2 = V_0 \times 1.20 \times 0.80 = 0.96 \cdot V_0 \implies \text{Net decrease of } 4\%


4. Step-by-Step Strategic Protocol for Solving Tabular Sets

  1. 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.

  2. 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).

  3. Phase 3 — Minimal Calculation & Option Scanning:

    • Scan option spreads. If options differ by >5%>5\%, 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

Δ%=Valuefinal−ValueinitialValueinitial×100\Delta\% = \frac{\text{Value}_{\text{final}} - \text{Value}_{\text{initial}}}{\text{Value}_{\text{initial}}} \times 100

Always check whether growth is asked relative to the immediately preceding period or a fixed historical base year.
Compound Annual Growth Rate (CAGR)

CAGR=(VnV0)1n−1≈Vn−V0n⋅V0−n−12(Vn−V0n⋅V0)2\text{CAGR} = \left(\frac{V_n}{V_0}\right)^{\frac{1}{n}} - 1 \approx \frac{V_n - V_0}{n \cdot V_0} - \frac{n-1}{2}\left(\frac{V_n - V_0}{n \cdot V_0}\right)^2

Quantifies the constant annual smoothed growth rate over n compounding periods.
Rapid Ratio Comparison Test

N1D1>N2D2  ⟺  N1⋅D2>N2⋅D1orgN>gD\frac{N_1}{D_1} > \frac{N_2}{D_2} \iff N_1 \cdot D_2 > N_2 \cdot D_1 \quad \text{or} \quad g_N > g_D

Compares two fractions without division by evaluating cross-products or relative growth rates of numerator versus denominator.
Index-Based Deflation

Real Valuet=Nominal ValuetPrice Indext×100\text{Real Value}_t = \frac{\text{Nominal Value}_t}{\text{Price Index}_t} \times 100

Converts nominal monetary figures into inflation-adjusted real values anchored to the index base year.
Weighted Average of Tabular Components

Xˉmix=∑i=1kwi⋅Xi∑i=1kwi\bar{X}_{\text{mix}} = \frac{\sum_{i=1}^{k} w_i \cdot X_i}{\sum_{i=1}^{k} w_i}

Determines the composite concentration or average across multiple mixed rows or columns.
Average Monthly Balance (AMB)

AMB=∑k=1m(Balancek×Durationk)Total Calendar Days in Month\text{AMB} = \frac{\sum_{k=1}^{m} (\text{Balance}_k \times \text{Duration}_k)}{\text{Total Calendar Days in Month}}

Computes day-weighted daily average balance in transaction ledger and liquidity accounts.

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 ConsortiumAverage Storage Capacity per Module (in MWh)Deployed Storage Modules (in thousands)
20212022202320242021202220232024
Titan Grid5.05.05.56.01600165017001750
Helios Power10.010.0—10.0110112115118
Orion Energy0.40.40.50.51200125013001350
Zephyr Storage1.21.21.11.4160165170175
Boreas Utilities1.01.01.01.1180185190195
Stellar Dynamics0.250.250.250.25350360370380

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:

    Global Total=42000+44000+46000+48000=180000 thousand MWh\text{Global Total} = 42000 + 44000 + 46000 + 48000 = 180000\text{ thousand MWh}

    Total energy stored by Titan Grid during 2021–2024 (Capacity×Modules\text{Capacity} \times \text{Modules}):

    Titan Grid Total=5.0×1600+5.0×1650+5.5×1700+6.0×1750\text{Titan Grid Total} = 5.0 \times 1600 + 5.0 \times 1650 + 5.5 \times 1700 + 6.0 \times 1750

    =8000+8250+9350+10500=36100 thousand MWh= 8000 + 8250 + 9350 + 10500 = 36100\text{ thousand MWh}

    Required percentage:

    36100180000×100≈20.06%≈20%\frac{36100}{180000} \times 100 \approx 20.06\% \approx 20\%

Question 2:

  • Answer: Option (1) [60%]

  • Calculation:

    Total energy stored by Boreas Utilities and Zephyr Storage:

    • Boreas Utilities: 1.0×(180+185+190)+1.1×195=555+214.5=769.5 thousand MWh1.0 \times (180 + 185 + 190) + 1.1 \times 195 = 555 + 214.5 = 769.5\text{ thousand MWh}

    • Zephyr Storage: 1.2×160+1.2×165+1.1×170+1.4×175=192+198+187+245=822 thousand MWh1.2 \times 160 + 1.2 \times 165 + 1.1 \times 170 + 1.4 \times 175 = 192 + 198 + 187 + 245 = 822\text{ thousand MWh}

    • Combined (Boreas + Zephyr): 769.5+822=1591.5 thousand MWh769.5 + 822 = 1591.5\text{ thousand MWh}

    Total energy stored by Orion Energy and Stellar Dynamics:

    • Orion Energy: 0.4×1200+0.4×1250+0.5×1300+0.5×1350=480+500+650+675=2305 thousand MWh0.4 \times 1200 + 0.4 \times 1250 + 0.5 \times 1300 + 0.5 \times 1350 = 480 + 500 + 650 + 675 = 2305\text{ thousand MWh}

    • Stellar Dynamics: 0.25×(350+360+370+380)=0.25×1460=365 thousand MWh0.25 \times (350 + 360 + 370 + 380) = 0.25 \times 1460 = 365\text{ thousand MWh}

    • Combined (Orion + Stellar): 2305+365=2670 thousand MWh2305 + 365 = 2670\text{ thousand MWh}

    Required percentage:

    1591.52670×100≈59.61%≈60%\frac{1591.5}{2670} \times 100 \approx 59.61\% \approx 60\%

Question 3:

  • Answer: Option (4) [8]

  • Calculation:

    Let the average battery capacity per storage module of Helios Power in 2023 be xx MWh.

    Helios Power's total energy stored over 2021–2024 is 2.4%2.4\% of 180000 thousand MWh180000\text{ thousand MWh}:

    Helios Total=0.024×180000=4320 thousand MWh\text{Helios Total} = 0.024 \times 180000 = 4320\text{ thousand MWh}

    Using the formula ∑(Capacity per Module×Modules)\sum (\text{Capacity per Module} \times \text{Modules}):

    10.0×110+10.0×112+x×115+10.0×118=432010.0 \times 110 + 10.0 \times 112 + x \times 115 + 10.0 \times 118 = 4320

    1100+1120+115x+1180=43201100 + 1120 + 115x + 1180 = 4320

    3400+115x=4320  ⟹  115x=920  ⟹  x=920115=8.03400 + 115x = 4320 \implies 115x = 920 \implies x = \frac{920}{115} = 8.0

Question 4:

  • Answer: Option (2) [Boreas Utilities]

  • Calculation:

    Energy stored in 2022 for each consortium (Capacity per Module×Modules\text{Capacity per Module} \times \text{Modules}):

    • Stellar Dynamics: 0.25×360=90.0 thousand MWh0.25 \times 360 = 90.0\text{ thousand MWh} (Lowest)

    • Boreas Utilities: 1.0×185=185.0 thousand MWh1.0 \times 185 = 185.0\text{ thousand MWh} (Second Lowest)

    • Zephyr Storage: 1.2×165=198.0 thousand MWh1.2 \times 165 = 198.0\text{ thousand MWh}

    • Orion Energy: 0.4×1250=500.0 thousand MWh0.4 \times 1250 = 500.0\text{ thousand MWh}

    • Helios Power: 10.0×112=1120.0 thousand MWh10.0 \times 112 = 1120.0\text{ thousand MWh}

    • Titan Grid: 5.0×1650=8250.0 thousand MWh5.0 \times 1650 = 8250.0\text{ thousand MWh}

    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.

SubstrateSiliconTitaniumGermaniumGalliumArsenic
A15%35%——10%
B20%20%45%5%10%
C10%—25%—30%
D25%20%15%30%10%
E10%45%25%5%15%
F35%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, Germanium+Gallium=100%−60%=40%\text{Germanium} + \text{Gallium} = 100\% - 60\% = 40\%.

    Let Germanium in A be x%x\%, then Gallium in A is (40−x)%(40 - x)\%.

  • In Substrate C: Silicon (10%) + Germanium (25%) + Arsenic (30%) = 65%.

    Hence, Titanium+Gallium=100%−65%=35%\text{Titanium} + \text{Gallium} = 100\% - 65\% = 35\%.

    Let Titanium in C be y%y\%, then Gallium in C is (35−y)%(35 - y)\%.

The reconstructed table structure is:

SubstrateSiliconTitaniumGermaniumGalliumArsenic
A15%35%x%(40 – x)%10%
B20%20%45%5%10%
C10%y%25%(35 – y)%30%
D25%20%15%30%10%
E10%45%25%5%15%
F35%15%5%30%15%

Composite G contains A, B, and C in the ratio 2:1:32 : 1 : 3 (total parts = 6).

Quantities of Titanium, Germanium, and Gallium in Composite G:

  • Titanium: 2×35+1×20+3×y6=90+3y6\frac{2 \times 35 + 1 \times 20 + 3 \times y}{6} = \frac{90 + 3y}{6}

  • Germanium: 2×x+1×45+3×256=2x+1206\frac{2 \times x + 1 \times 45 + 3 \times 25}{6} = \frac{2x + 120}{6}

  • Gallium: 2×(40−x)+1×5+3×(35−y)6=80−2x+5+105−3y6=190−2x−3y6\frac{2 \times (40 - x) + 1 \times 5 + 3 \times (35 - y)}{6} = \frac{80 - 2x + 5 + 105 - 3y}{6} = \frac{190 - 2x - 3y}{6}

Since Titanium, Germanium, and Gallium are present in equal quantity in G:

90+3y=2x+120=190−2x−3y90 + 3y = 2x + 120 = 190 - 2x - 3y

From 90+3y=2x+120  ⟹  2x−3y=−30— (Equation 1)90 + 3y = 2x + 120 \implies 2x - 3y = -30 \quad \text{--- (Equation 1)}

From 2x+120=190−2x−3y  ⟹  4x+3y=70— (Equation 2)2x + 120 = 190 - 2x - 3y \implies 4x + 3y = 70 \quad \text{--- (Equation 2)}

Adding (1) and (2):

6x=40  ⟹  x=203%6x = 40 \implies x = \frac{20}{3}\%

Substituting xx into (1):

3y=2(203)+30=403+30=1303  ⟹  y=1309%3y = 2\left(\frac{20}{3}\right) + 30 = \frac{40}{3} + 30 = \frac{130}{3} \implies y = \frac{130}{9}\%

Question 5:

  • Answer: Option (2) [100/3%]

  • Calculation:

    Percentage of Gallium in Substrate A =(40−x)%=40−203=120−203=1003%= (40 - x)\% = 40 - \frac{20}{3} = \frac{120 - 20}{3} = \frac{100}{3}\%.

Question 6:

  • Answer: Option (4) [Two]

  • Calculation:

    Composite X must satisfy:

    1. Arsenic = 15%

    2. Silicon ≥\ge 15%

    3. Gallium ≤\le 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 e:fe : f.

      Silicon =10e+35fe+f≥15  ⟹  20f≥5e  ⟹  ef≤4= \frac{10e + 35f}{e + f} \ge 15 \implies 20f \ge 5e \implies \frac{e}{f} \le 4.

      Gallium =5e+30fe+f≤20  ⟹  10f≤15e  ⟹  ef≥23= \frac{5e + 30f}{e + f} \le 20 \implies 10f \le 15e \implies \frac{e}{f} \ge \frac{2}{3}.

      Since 23≤ef≤4\frac{2}{3} \le \frac{e}{f} \le 4, valid mixing ratios exist. Thus, (E, F) is valid.

    • Case 2: Combining one substrate with <15%<15\% Arsenic and one with >15%>15\% Arsenic.

      Only Substrate C has >15%>15\% Arsenic (30%).

      To achieve 15% Arsenic, the ratio with any 10% Arsenic substrate must be:

      30−1515−10=155=3:1(75% of the 10% substrate, 25% of Substrate C)\frac{30 - 15}{15 - 10} = \frac{15}{5} = 3 : 1 \quad (75\% \text{ of the 10\% substrate, } 25\% \text{ of Substrate C})

      • Pair (A, C): Silicon in 3:1 mix =0.75(15)+0.25(10)=11.25+2.5=13.75%<15%= 0.75(15) + 0.25(10) = 11.25 + 2.5 = 13.75\% < 15\% (Invalid).

      • Pair (B, C):

        Silicon in 3:1 mix =0.75(20)+0.25(10)=15+2.5=17.5%≥15%= 0.75(20) + 0.25(10) = 15 + 2.5 = 17.5\% \ge 15\% (Valid).

        Gallium in 3:1 mix =0.75(5)+0.25(35−1309)=3.75+0.25(20.56)=3.75+5.14=8.89%≤20%= 0.75(5) + 0.25\left(35 - \frac{130}{9}\right) = 3.75 + 0.25(20.56) = 3.75 + 5.14 = 8.89\% \le 20\% (Valid).

        Thus, (B, C) is valid.

      • Pair (D, C):

        Silicon in 3:1 mix =0.75(25)+0.25(10)=18.75+2.5=21.25%≥15%= 0.75(25) + 0.25(10) = 18.75 + 2.5 = 21.25\% \ge 15\%.

        Gallium in 3:1 mix =0.75(30)+0.25(20.56)=22.5+5.14=27.64%>20%= 0.75(30) + 0.25(20.56) = 22.5 + 5.14 = 27.64\% > 20\% (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 =203%≈6.67%= \frac{20}{3}\% \approx 6.67\%, E =25%= 25\%, F =5%= 5\%.

    Testing options:

    • Option (1) 4:1:14 : 1 : 1: Germanium=4(20/3)+1(25)+1(5)6=80/3+306=17018≈9.44%<12%\text{Germanium} = \frac{4(20/3) + 1(25) + 1(5)}{6} = \frac{80/3 + 30}{6} = \frac{170}{18} \approx 9.44\% < 12\%

    • Option (2) 2:1:32 : 1 : 3: Germanium=2(20/3)+1(25)+3(5)6=40/3+406=16018≈8.89%<12%\text{Germanium} = \frac{2(20/3) + 1(25) + 3(5)}{6} = \frac{40/3 + 40}{6} = \frac{160}{18} \approx 8.89\% < 12\%

    • Option (3) 1:3:21 : 3 : 2: Germanium=1(20/3)+3(25)+2(5)6=20/3+856=27518≈15.28%≥12%\text{Germanium} = \frac{1(20/3) + 3(25) + 2(5)}{6} = \frac{20/3 + 85}{6} = \frac{275}{18} \approx 15.28\% \ge 12\% (Satisfies condition)

    • Option (4) 1:1:41 : 1 : 4: Germanium=1(20/3)+1(25)+4(5)6=20/3+456=15518≈8.61%<12%\text{Germanium} = \frac{1(20/3) + 1(25) + 4(5)}{6} = \frac{20/3 + 45}{6} = \frac{155}{18} \approx 8.61\% < 12\%

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 ww. Then the fraction of C is 1−w1 - w.

    10w+30(1−w)≥13.510w + 30(1 - w) \ge 13.5

    30−20w≥13.5  ⟹  20w≤16.5  ⟹  w≤16.520=82.50%30 - 20w \ge 13.5 \implies 20w \le 16.5 \implies w \le \frac{16.5}{20} = 82.50\%

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 SegmentPQRSTotal
Family Offices1204601604601200
Sovereign Wealth Funds2304402602701200
Pension Endowments2503003003501200
Total600120072010803600

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

  1. Director's Observation I: In Pension Endowments, 25% of participants opted to Retain Legacy On-Premise.

    25% of 1200=30025\% \text{ of } 1200 = 300

    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.

  2. Director's Observation II: The overall totals of Microservices Mesh and Event-Driven Streaming differ by 120.

    • If Q is "Retain Legacy On-Premise":

      Q=1200Q = 1200 (Retain Legacy On-Premise).

      The remaining options have totals: P=600P = 600, R=720R = 720, S=1080S = 1080.

      Pairwise differences:

      ∣R−P∣=720−600=120|R - P| = 720 - 600 = 120.

      ∣S−R∣=1080−720=360≠120|S - R| = 1080 - 720 = 360 \ne 120.

      ∣S−P∣=1080−600=480≠120|S - P| = 1080 - 600 = 480 \ne 120.

      Hence, the two options for Microservices Mesh and Event-Driven Streaming must be P and R. This leaves S = Serverless Architecture.

      • Case I: P=Event-Driven StreamingP = \text{Event-Driven Streaming}, Q=Retain LegacyQ = \text{Retain Legacy}, R=Microservices MeshR = \text{Microservices Mesh}, S=ServerlessS = \text{Serverless}

      • Case II: P=Microservices MeshP = \text{Microservices Mesh}, Q=Retain LegacyQ = \text{Retain Legacy}, R=Event-Driven StreamingR = \text{Event-Driven Streaming}, S=ServerlessS = \text{Serverless}

    • If R is "Retain Legacy On-Premise":

      R=720R = 720 (Retain Legacy On-Premise).

      The remaining options have totals: P=600P = 600, Q=1200Q = 1200, S=1080S = 1080.

      Pairwise differences:

      ∣Q−S∣=1200−1080=120|Q - S| = 1200 - 1080 = 120.

      ∣S−P∣=1080−600=480≠120|S - P| = 1080 - 600 = 480 \ne 120.

      ∣Q−P∣=1200−600=600≠120|Q - P| = 1200 - 600 = 600 \ne 120.

      Hence, the two options for Microservices Mesh and Event-Driven Streaming must be Q and S. This leaves P = Serverless Architecture.

      • Case III: P=ServerlessP = \text{Serverless}, Q=Microservices MeshQ = \text{Microservices Mesh}, R=Retain LegacyR = \text{Retain Legacy}, S=Event-Driven StreamingS = \text{Event-Driven Streaming}

      • Case IV: P=ServerlessP = \text{Serverless}, Q=Event-Driven StreamingQ = \text{Event-Driven Streaming}, R=Retain LegacyR = \text{Retain Legacy}, S=Microservices MeshS = \text{Microservices Mesh}

Possible CasesPQRS
Case IEvent-Driven StreamingRetain LegacyMicroservices MeshServerless
Case IIMicroservices MeshRetain LegacyEvent-Driven StreamingServerless
Case IIIServerlessMicroservices MeshRetain LegacyEvent-Driven Streaming
Case IVServerlessEvent-Driven StreamingRetain LegacyMicroservices Mesh

Question 9:

  • Answer: Option (4)

  • Calculation:

    In Family Offices, counts are: P=120P = 120, Q=460Q = 460, R=160R = 160, S=460S = 460.

    The minimum count is P=120P = 120. 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: P=600P = 600, Q=1200Q = 1200, R=720R = 720, S=1080S = 1080.

    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 P=Event-Driven StreamingP = \text{Event-Driven Streaming}.

    In Case I:

    • Event-Driven Streaming =P= P, Retain Legacy =Q= Q, Microservices Mesh =R= R, Serverless =S= S.

    • "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: P=250P = 250, Q=300Q = 300, R=300R = 300, S=350S = 350.

    The minimum count is P=250P = 250. Since Serverless Architecture is minimum in Pension Endowments, Option P must be Serverless Architecture.

    This validates Cases III and IV (P=ServerlessP = \text{Serverless}, R=Retain LegacyR = \text{Retain Legacy}, and {Q,S}={Microservices Mesh,Event-Driven Streaming}\{Q, S\} = \{\text{Microservices Mesh}, \text{Event-Driven Streaming}\}).

    In Pension Endowments, participants who preferred neither Microservices Mesh nor Event-Driven Streaming:

    Count=(Preferred Serverless)+(Retained Legacy)=P+R=250+300=550\text{Count} = (\text{Preferred Serverless}) + (\text{Retained Legacy}) = P + R = 250 + 300 = 550

    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   ⟹  R=Retain Legacy\implies R = \text{Retain Legacy} (Holds in Cases III & IV).

    • Statement II: In Pension Endowments, 250 preferred Event-Driven Streaming   ⟹  P=Event-Driven Streaming\implies P = \text{Event-Driven Streaming} (Holds in Case I).

    • Statement III: In Sovereign Wealth Funds, 270 preferred Microservices Mesh   ⟹  S=Microservices Mesh\implies S = \text{Microservices Mesh} (Holds in Cases II & IV).

    • Statement IV: In Pension Endowments, 300 preferred Event-Driven Streaming   ⟹  Q or R=Event-Driven Streaming\implies Q \text{ or } R = \text{Event-Driven Streaming} (Holds in Cases II, III, & IV).

    • Statement V: In Sovereign Wealth Funds, 230 preferred Serverless Architecture   ⟹  P=Serverless\implies P = \text{Serverless} (Holds in Cases III & IV).

    Testing Case IV (P=ServerlessP = \text{Serverless}, Q=Event-Driven StreamingQ = \text{Event-Driven Streaming}, R=Retain LegacyR = \text{Retain Legacy}, S=Microservices MeshS = \text{Microservices Mesh}):

    • Statement I: R=Retain Legacy  ⟹  TrueR = \text{Retain Legacy} \implies \text{True}.

    • Statement II: P=Event-Driven Streaming  ⟹  FalseP = \text{Event-Driven Streaming} \implies \text{False} (P is Serverless).

    • Statement III: S=Microservices Mesh  ⟹  TrueS = \text{Microservices Mesh} \implies \text{True}.

    • Statement IV: Q=Event-Driven StreamingQ = \text{Event-Driven Streaming} (Pension Endowments: Q=300Q = 300)   ⟹  True\implies \text{True}.

    • Statement V: P=ServerlessP = \text{Serverless} (Sovereign Wealth Funds: P=230P = 230)   ⟹  True\implies \text{True}.

    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.

DivisionMarket ChannelAnnual Revenue (in ₹)Operating Margin (%)Number of EngineersAnnual Salary per Engineer (in ₹)
AI SoftwareDomestic Enterprise0.40 crore25%2030000
International Cloud2.50 crore40%25150000
Edge HardwareDomestic Enterprise0.60 crore30%3020000
International Cloud3.00 crore50%50100000

Note: Operating Margin=Operating ProfitRevenue×100\text{Operating Margin} = \frac{\text{Operating Profit}}{\text{Revenue}} \times 100.

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 =0.40+2.50+0.60+3.00=₹6.50 crore= 0.40 + 2.50 + 0.60 + 3.00 = ₹6.50\text{ crore}.

  • Baseline Operating Profits by division (Profit=Revenue×Margin100\text{Profit} = \text{Revenue} \times \frac{\text{Margin}}{100}):

    • AI Software Domestic: 25%×0.40 crore=₹0.10 crore=₹10.0 lakh25\% \times 0.40\text{ crore} = ₹0.10\text{ crore} = ₹10.0\text{ lakh}

    • AI Software International: 40%×2.50 crore=₹1.00 crore=₹100.0 lakh40\% \times 2.50\text{ crore} = ₹1.00\text{ crore} = ₹100.0\text{ lakh}

    • Edge Hardware Domestic: 30%×0.60 crore=₹0.18 crore=₹18.0 lakh30\% \times 0.60\text{ crore} = ₹0.18\text{ crore} = ₹18.0\text{ lakh}

    • Edge Hardware International: 50%×3.00 crore=₹1.50 crore=₹150.0 lakh50\% \times 3.00\text{ crore} = ₹1.50\text{ crore} = ₹150.0\text{ lakh}

    • Total Initial Operating Profit =0.10+1.00+0.18+1.50=₹2.78 crore=₹278.0 lakh= 0.10 + 1.00 + 0.18 + 1.50 = ₹2.78\text{ crore} = ₹278.0\text{ lakh}.

Question 13:

  • Answer: Option (2) [42.31%]

  • Calculation:

    Salary increase per Edge Hardware Domestic engineer =50%×₹20,000=₹10,000= 50\% \times ₹20,000 = ₹10,000.

    Total additional cost for 30 engineers =10000×30=₹3,00,000=₹0.03 crore= 10000 \times 30 = ₹3,00,000 = ₹0.03\text{ crore}.

    New total operating profit =2.78−0.03=₹2.75 crore= 2.78 - 0.03 = ₹2.75\text{ crore}.

    New company operating margin percentage:

    2.756.50×100≈42.307%≈42.31%\frac{2.75}{6.50} \times 100 \approx 42.307\% \approx 42.31\%

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 =30000−20000=₹10,000= 30000 - 20000 = ₹10,000.

    Net decrease in cost for 20 engineers =10000×20=₹2,00,000=₹2.0 lakh= 10000 \times 20 = ₹2,00,000 = ₹2.0\text{ lakh}.

    Earlier AI Software Domestic profit = ₹10.0 lakh.

    New AI Software Domestic profit =10.0+2.0=₹12.0 lakh= 10.0 + 2.0 = ₹12.0\text{ lakh}.

    Percentage increase in profit (and thus margin):

    2.010.0×100=20.0%\frac{2.0}{10.0} \times 100 = 20.0\%

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%:

    New Total Profit=2.78×1.15=3.197 crore≈₹3.20 crore\text{New Total Profit} = 2.78 \times 1.15 = 3.197\text{ crore} \approx ₹3.20\text{ crore}

Question 16:

  • Answer: Option (2) [₹22 lakh]

  • Calculation:

    1. Increase in profit from International Cloud expansion (20% increase):

      • AI Software International: 20%×₹100.0 lakh=₹20.0 lakh20\% \times ₹100.0\text{ lakh} = ₹20.0\text{ lakh}

      • Edge Hardware International: 20%×₹150.0 lakh=₹30.0 lakh20\% \times ₹150.0\text{ lakh} = ₹30.0\text{ lakh}

      • Total increase in international profit =20.0+30.0=₹50.0 lakh= 20.0 + 30.0 = ₹50.0\text{ lakh}

    2. Loss in profit from closing Domestic Enterprise operations:

      • AI Software Domestic: 25%×0.40 crore=₹10.0 lakh25\% \times 0.40\text{ crore} = ₹10.0\text{ lakh}

      • Edge Hardware Domestic: 30%×0.60 crore=₹18.0 lakh30\% \times 0.60\text{ crore} = ₹18.0\text{ lakh}

      • Total domestic profit lost =10.0+18.0=₹28.0 lakh= 10.0 + 18.0 = ₹28.0\text{ lakh}

    3. Net overall change in profit =50.0−28.0=+₹22.0 lakh= 50.0 - 28.0 = +₹22.0\text{ lakh} (Net increase of ₹22 lakh).

Question 17:

  • Answer: Option (2) [17.5%]

  • Calculation:

    Initial AI Software Domestic profit = ₹10.0 lakh.

    Total training expenditure =15000×20=₹3,00,000=₹3.0 lakh= 15000 \times 20 = ₹3,00,000 = ₹3.0\text{ lakh}.

    New profit =10.0−3.0=₹7.0 lakh= 10.0 - 3.0 = ₹7.0\text{ lakh}.

    Annual revenue of AI Software Domestic =0.40 crore=₹40.0 lakh= 0.40\text{ crore} = ₹40.0\text{ lakh}.

    New margin percentage:

    7.0 lakh40.0 lakh×100=17.5%\frac{7.0\text{ lakh}}{40.0\text{ lakh}} \times 100 = 17.5\%

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.

DateTransaction DetailsDebit (₹)Credit (₹)Closing Balance (₹)
10-JanBy Wire Inflow (Client Milestone)NA1400034000
30-JanBy Clearing CHQ 567890NA1600050000
31-JanTo Vendor Payout (Debit)30000NA20000
17-FebTo Equipment Lease CHQ 234567—NA8600
23-FebTo API Infrastructure Settlement2200NA6400
28-FebBy Wire Inflow (Retainer Fee)NA760014000
11-MarTo Cloud Host Direct Debit (ECS)2575NA—
24-MarTo Operating Expenses Sweep7250NA—
31-MarBy Equity Tranche CHQ 238129NA4775052000
23-AprBy Enterprise Contract AdvanceNA3294085000
30-AprTo Inter-Bank Sweep (IB TFR)25320NA59680

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.

Average Monthly Balance (AMB)=Sum of the balances at the end of each day of a monthNumber of days in the month\text{Average Monthly Balance (AMB)} = \frac{\text{Sum of the balances at the end of each day of a month}}{\text{Number of days in the month}}

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   ⟹  \implies Balance = ₹34,000

  • Jan 30 (1 day): Cheque credit of ₹16,000   ⟹  \implies Balance = ₹50,000

  • Jan 31 (1 day): Vendor payout debit of ₹30,000   ⟹  \implies Balance before interest = ₹20,000

AMBJan=20000×9+34000×20+50000×1+20000×131=180000+680000+7000031=93000031=₹30,000\text{AMB}_{\text{Jan}} = \frac{20000 \times 9 + 34000 \times 20 + 50000 \times 1 + 20000 \times 1}{31} = \frac{180000 + 680000 + 70000}{31} = \frac{930000}{31} = ₹30,000

Interest credited on Jan 31=0.5%×30000=₹150\text{Interest credited on Jan 31} = 0.5\% \times 30000 = ₹150

Closing Balance on Jan 31=20000+150=₹20,150\text{Closing Balance on Jan 31} = 20000 + 150 = ₹20,150

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   ⟹  \implies Balance = ₹6,400

  • Feb 28 (1 day): Retainer credit of ₹7,600   ⟹  \implies Balance before interest = ₹14,000

AMBFeb=20150×16+8600×6+6400×5+14000×128=322400+51600+32000+1400028=42000028=₹15,000\text{AMB}_{\text{Feb}} = \frac{20150 \times 16 + 8600 \times 6 + 6400 \times 5 + 14000 \times 1}{28} = \frac{322400 + 51600 + 32000 + 14000}{28} = \frac{420000}{28} = ₹15,000

Interest credited on Feb 28=0.5%×15000=₹75\text{Interest credited on Feb 28} = 0.5\% \times 15000 = ₹75

Closing Balance on Feb 28=14000+75=₹14,075\text{Closing Balance on Feb 28} = 14000 + 75 = ₹14,075

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   ⟹  \implies Balance = 14075−2575=₹11,50014075 - 2575 = ₹11,500

  • Mar 24 to Mar 30 (7 days): Operating expenses debit of ₹7,250   ⟹  \implies Balance = 11500−7250=₹4,25011500 - 7250 = ₹4,250

  • Mar 31 (1 day): Equity tranche credit of ₹47,750   ⟹  \implies Balance before interest = 4250+47750=₹52,0004250 + 47750 = ₹52,000

AMBMar=14075×10+11500×13+4250×7+52000×131=140750+149500+29750+5200031=37200031=₹12,000\text{AMB}_{\text{Mar}} = \frac{14075 \times 10 + 11500 \times 13 + 4250 \times 7 + 52000 \times 1}{31} = \frac{140750 + 149500 + 29750 + 52000}{31} = \frac{372000}{31} = ₹12,000

Interest credited on Mar 31=0.5%×12000=₹60\text{Interest credited on Mar 31} = 0.5\% \times 12000 = ₹60

Closing Balance on Mar 31=52000+60=₹52,060\text{Closing Balance on Mar 31} = 52000 + 60 = ₹52,060

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   ⟹  \implies Balance = 52060+32940=₹85,00052060 + 32940 = ₹85,000

  • Apr 30 (1 day): Inter-bank sweep debit of ₹25,320   ⟹  \implies Balance before interest = 85000−25320=₹59,68085000 - 25320 = ₹59,680

AMBApr=52060×22+85000×7+59680×130=1145320+595000+5968030=180000030=₹60,000\text{AMB}_{\text{Apr}} = \frac{52060 \times 22 + 85000 \times 7 + 59680 \times 1}{30} = \frac{1145320 + 595000 + 59680}{30} = \frac{1800000}{30} = ₹60,000

Interest credited on Apr 30=0.5%×60000=₹300\text{Interest credited on Apr 30} = 0.5\% \times 60000 = ₹300

Closing Balance on Apr 30=59680+300=₹59,980\text{Closing Balance on Apr 30} = 59680 + 300 = ₹59,980

Answers:

  • Question 18: Total balance at the end of April 30 is ₹59,980   ⟹  \implies Option (2).

  • Question 19: Total interest =150+75+60+300=₹585= 150 + 75 + 60 + 300 = ₹585.

    Average monthly interest =5854=₹146.25  ⟹  = \frac{585}{4} = ₹146.25 \implies Option (1).

  • Question 20: Balance on Feb 16 was ₹20,150, and balance after cheque debit on Feb 17 was ₹8,600.

    Cheque amount =20150−8600=₹11,550  ⟹  = 20150 - 8600 = ₹11,550 \implies 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.

StatePopulation (millions)Per Capita Consumption (kWh)
State A401500
State B601200
State C252400
State D501800
State E80750

What percentage of the total electricity consumed by all five states combined is accounted for by State D?

  1. A

    24.15%

  2. B

    26.32%

  3. C

    28.50%

  4. D

    30.00%

Show answer and explanation

Answer: (B) 26.32%

Step-by-step calculation:

  1. Compute total electricity consumption for each state (Population×Per Capita Consumption\text{Population} \times \text{Per Capita Consumption}):

    • State A: 40×1500=60,000 million kWh40 \times 1500 = 60,000\text{ million kWh}

    • State B: 60×1200=72,000 million kWh60 \times 1200 = 72,000\text{ million kWh}

    • State C: 25×2400=60,000 million kWh25 \times 2400 = 60,000\text{ million kWh}

    • State D: 50×1800=90,000 million kWh50 \times 1800 = 90,000\text{ million kWh}

    • State E: 80×750=60,000 million kWh80 \times 750 = 60,000\text{ million kWh}

  2. Sum the total consumption across all five states:

    Total=60,000+72,000+60,000+90,000+60,000=342,000 million kWh\text{Total} = 60,000 + 72,000 + 60,000 + 90,000 + 60,000 = 342,000\text{ million kWh}

  3. Calculate State D's percentage share:

    Percentage Share=90,000342,000×100=90342×100=519×100≈26.32%\text{Percentage Share} = \frac{90,000}{342,000} \times 100 = \frac{90}{342} \times 100 = \frac{5}{19} \times 100 \approx 26.32\%

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.

AlloyCopper (%)Zinc (%)Nickel (%)
Alloy P45%35%—
Alloy Q30%—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?

  1. A

    32.5%

  2. B

    34.0%

  3. C

    36.5%

  4. D

    38.5%

Show answer and explanation

Answer: (C) 36.5%

Step-by-step calculation:

  1. Fill in missing percentages using the constraint that each alloy sums to 100%:

    • Alloy P Nickel: 100%−(45%+35%)=20%100\% - (45\% + 35\%) = 20\%

    • Alloy Q Nickel: 25%25\% (given)

    • Alloy R Nickel: 50%50\% (given)

  2. Apply weighted average using the mixing ratio 2:3:52 : 3 : 5:

    Combined Nickel %=2(20%)+3(25%)+5(50%)2+3+5=40+75+25010=36510=36.5%\text{Combined Nickel \%} = \frac{2(20\%) + 3(25\%) + 5(50\%)}{2 + 3 + 5} = \frac{40 + 75 + 250}{10} = \frac{365}{10} = 36.5\%

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 →↓ DemographicOption WOption XOption YOption ZTotal
Students40805030200
Professionals60507020200
Retirees303010040200
Total13016022090600

It is known that:

  1. Exactly 15% of all respondents chose 'None'.

  2. 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?

  1. A

    None is Z; Apex is X

  2. B

    None is Z; Apex is W

  3. C

    None is W; Apex is X

  4. D

    None is Z; Apex is Y

Show answer and explanation

Answer: (A) None is Z; Apex is X

Step-by-step deduction:

  1. Identify the 'None' option:

    Total ’None’=15%×600=90\text{Total 'None'} = 15\% \times 600 = 90

    Examining the column totals:

    W=130W = 130, X=160X = 160, Y=220Y = 220, Z=90Z = 90.

    Only Option Z has a total of 90. Therefore, Option Z represents 'None'.

  2. Identify the brand options among W (130), X (160), and Y (220):

    We are given: Crest−Apex=60\text{Crest} - \text{Apex} = 60.

    Checking differences between the remaining totals:

    • Y−X=220−160=60Y - X = 220 - 160 = 60

    • Y−W=220−130=90Y - W = 220 - 130 = 90

    • X−W=160−130=30X - W = 160 - 130 = 30

    The only pair with a difference of 60 is (Y,X)(Y, X), 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.

DivisionAnnual Revenue (₹ crore)Operating Profit Margin (%)HeadcountAverage Annual Salary (₹)
Cloud Services4.025%504,00,000
Cybersecurity6.020%605,00,000
AI Solutions10.030%806,00,000

Note: Operating Profit Margin=Operating ProfitRevenue×100\text{Operating Profit Margin} = \frac{\text{Operating Profit}}{\text{Revenue}} \times 100.

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?

  1. A

    15.0%

  2. B

    17.5%

  3. C

    18.2%

  4. D

    16.5%

Show answer and explanation

Answer: (D) 16.5%

Step-by-step calculation:

  1. Compute total revenue and baseline operating profit:

    • Total Revenue =4.0+6.0+10.0=₹20.0 crore= 4.0 + 6.0 + 10.0 = ₹20.0\text{ crore}

    • Baseline Profit:

      • Cloud Services: 25%×4.0=₹1.00 crore25\% \times 4.0 = ₹1.00\text{ crore}

      • Cybersecurity: 20%×6.0=₹1.20 crore20\% \times 6.0 = ₹1.20\text{ crore}

      • AI Solutions: 30%×10.0=₹3.00 crore30\% \times 10.0 = ₹3.00\text{ crore}

      • Total Baseline Profit =1.00+1.20+3.00=₹5.20 crore= 1.00 + 1.20 + 3.00 = ₹5.20\text{ crore}

  2. Calculate total additional salary expenditure:

    • Total Headcount =50+60+80=190 employees= 50 + 60 + 80 = 190\text{ employees}

    • Additional Cost =190×₹1,00,000=₹1.90 crore= 190 \times ₹1,00,000 = ₹1.90\text{ crore}

  3. Calculate new profit and overall margin:

    • New Operating Profit =₹5.20 crore−₹1.90 crore=₹3.30 crore= ₹5.20\text{ crore} - ₹1.90\text{ crore} = ₹3.30\text{ crore}

    • 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 RangeDurationDay-End Balance (₹)
April 1 to April 1010 days₹30,000
April 11 to April 2515 days₹50,000
April 26 to April 305 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?

  1. A

    ₹29,800

  2. B

    ₹30,200

  3. C

    ₹40,200

  4. D

    ₹30,150

Show answer and explanation

Answer: (B) ₹30,200

Step-by-step calculation:

  1. Compute the day-weighted balance for each period in April (30 days total):

    • Days 1 to 10 (10 days): 10×₹30,000=₹3,00,00010 \times ₹30,000 = ₹3,00,000

    • Days 11 to 25 (15 days): 15×₹50,000=₹7,50,00015 \times ₹50,000 = ₹7,50,000

    • Days 26 to 30 (5 days): 5×₹30,000=₹1,50,0005 \times ₹30,000 = ₹1,50,000

  2. Calculate the Average Monthly Balance (AMB):

    Sum of Daily Balances=3,00,000+7,50,000+1,50,000=₹12,00,000\text{Sum of Daily Balances} = 3,00,000 + 7,50,000 + 1,50,000 = ₹12,00,000

    AMB=₹12,00,00030=₹40,000\text{AMB} = \frac{₹12,00,000}{30} = ₹40,000

  3. Calculate the interest credited on April 30:

    Interest=0.5%×₹40,000=₹200\text{Interest} = 0.5\% \times ₹40,000 = ₹200

  4. Determine final closing balance:

    Closing Balance=Balance on April 30 before interest+Interest=₹30,000+₹200=₹30,200\text{Closing Balance} = \text{Balance on April 30 before interest} + \text{Interest} = ₹30,000 + ₹200 = ₹30,200

Try real CAT questions

Study this concept with interactive practice in PrepSoc.

Open the concept library