Business Data Management · End Term · Jan 2026 · FN

**1. Understand the Government's dual role in the Circular Flow Model:** In the scenario: - The government levies a **10% tax** on inter-state transactions and uses that revenue to **subsidize transportation costs**. - In the circular flow of economic activity, the government does not merely watch from the outside: by collecting taxes (leakages/withdrawals) and providing subsidies/spending (injections) while setting rules for trade, **it functions as both an active participant and a regulator of economic activity**. **Answer: B — It functions as both a participant (through taxation and subsidies) and a regulator of economic activity.** A: **Incorrect:** Levying taxes and paying out subsidies makes the government an active financial participant in the circular flow, not solely a rule-maker. B: **Correct:** Through taxation and subsidies, the government participates directly in the monetary flows while also regulating inter-state trade. C: **Incorrect:** Intermediaries continue to facilitate trade; the government taxes and subsidizes rather than replacing them. D: **Incorrect:** The government is taxing transactions and subsidizing transport, not just buying wheat and sugar for its own consumption. E: **Incorrect:** Government taxation and spending are integral components of the expanded circular flow model.

**1. Estimate the market equilibrium price from the demand and supply schedules:** Compare Quantity Demanded (\(Q_d\)) and Quantity Supplied (\(Q_s\)) at each price: - At **₹10**: \(Q_d = 500 > Q_s = 100\) (excess demand / shortage of 400 units) - At **₹20**: \(Q_d = 300\) and \(Q_s = 250\) (nearly equal; equilibrium is just above **₹20**, around ₹21.67) - At **₹30**: \(Q_d = 150 < Q_s = 400\) (excess supply / surplus of 250 units) **2. Analyze the effect of a binding price ceiling at ₹15:** Since ₹15 is **below** the equilibrium price (near ₹20), at ₹15 the quantity demanded (between 300 and 500 units, around 400 units) is strictly greater than the quantity supplied (between 100 and 250 units, around 175 units). Because **demand exceeds supply** at ₹15, the binding price ceiling creates a **shortage**. **Answer: B — Equilibrium near ₹20; a ceiling at ₹15 creates a shortage since demand exceeds supply at that price.** A: **Incorrect:** At ₹15 (below the equilibrium price), buyers want more than sellers are willing to supply, creating a shortage, not a surplus. B: **Correct:** Demand (300) and supply (250) are closest near ₹20, and capping the price below equilibrium at ₹15 causes demand to exceed supply, resulting in a shortage. C: **Incorrect:** At ₹30, supply (400) far exceeds demand (150), and a ceiling at ₹15 is below equilibrium and therefore binding. D: **Incorrect:** At ₹10, demand (500) is five times supply (100), far from equilibrium. E: **Incorrect:** The schedules clearly bracket the intersection near ₹20.

**1. Understand relative vs. absolute cell references in Excel:** The formula in cell `E2` is: `=B2*$D$1` - **`B2` (Relative reference):** Neither the column `B` nor the row `2` has a `$` sign. When copied vertically down from row `2` (`E2`) to row `7` (`E7` — 5 rows down), the row number increments by 5 from `2` to **`B7`**. - **`$D$1` (Absolute reference):** Both the column `$D` and the row `$1` are locked with `$` signs. When copied to any cell, `$D$1` remains unchanged as **`$D$1`**. **2. Combine to get the formula in cell `E7`:** `=B7*$D$1` **Answer: A — =B7*$D$1.** A: **Correct:** Copying `=B2*$D$1` down 5 rows from `E2` to `E7` updates the relative reference `B2` to `B7` while keeping the absolute reference `$D$1` fixed. B: **Incorrect:** `$D$1` is locked with dollar signs and does not change to `$D$6` or `$D$7`. C: **Incorrect:** `B2` is a relative reference, so its row number changes from `2` to `7` when copied to `E7`. D: **Incorrect:** Moving vertically within column `E` does not change column `B`, and `$D$1` is locked. E: **Incorrect:** Only the relative row `2` changes to `7`, yielding `=B7*$D$1`.

**1. Recall how Excel's `VLOOKUP` handles duplicate keys in the lookup column:** When `VLOOKUP(lookup_value, table_array, col_index_num, FALSE)` searches vertically down the first column of `table_array` and multiple rows have the exact same `Product ID`: - `VLOOKUP` **always stops at and returns the FIRST matching row** it encounters from the top of the table, completely ignoring any subsequent duplicate rows! - Because different regions have different prices for the same `Product ID`, returning the first match arbitrarily may give the wrong regional price. - **Best mitigation:** Create a **unique composite key** (e.g., combining `Product_ID` and `Region` into `Product_ID_Region`) or filter/index by both criteria so each lookup key is unique. **Answer: C — VLOOKUP returns the first match it finds, which may not be the intended one; the analyst should ensure unique keys or use additional filtering.** A: **Incorrect:** `VLOOKUP` does not return an error on duplicate keys, and `HLOOKUP` is for horizontal tables rather than solving duplicate keys. B: **Incorrect:** With exact match (`FALSE`), `VLOOKUP` always returns the *first* match from the top, not the last match. C: **Correct:** `VLOOKUP` always returns the first matching row it finds, so duplicate `Product ID`s require creating unique composite keys or filtering by region. D: **Incorrect:** `VLOOKUP` retrieves a single cell value; it never averages multiple rows (which `AVERAGEIF` would do). E: **Incorrect:** `VLOOKUP` returns a single scalar value from the first match, not an array of all matches.

**1. Compare the strengths and limitations of the Census vs. CMIE Consumer Pyramids:** - **Decennial Census:** Covers 100% of the population (complete enumeration), providing reliable **structural and demographic baselines**, but is conducted only once every 10 years (outdated for current monthly trends). - **CMIE Consumer Pyramids Household Survey (CPHS):** A high-frequency sample survey conducted every quarter/wave, providing **timely, up-to-date consumption trends**, but based on a sample rather than a full census. **2. Identify the optimal data sourcing strategy:** The best practice is to **combine both sources**: use the **Census data for structural demographic baselines** (and population weights) and **CMIE data for recent household fuel consumption trends**, cross-referencing the two. **Answer: C — Use Census data for structural demographic baselines and CMIE for recent consumption trends, cross-referencing both.** A: **Incorrect:** Relying solely on a 10-year-old Census misses recent shifts in fuel prices, LPG adoption, and consumption patterns. B: **Incorrect:** Ignoring Census baselines misses the complete demographic distribution needed to weight and validate sample surveys. C: **Correct:** Combining Census demographic baselines with recent quarterly CMIE consumption data balances comprehensive coverage with timeliness. D: **Incorrect:** Conducting a new nationwide full census for a single study is prohibitively expensive and slow. E: **Incorrect:** The Annual Survey of Industries (ASI) covers *industrial/factory* fuel consumption, not *household* consumption.

**1. Synthesize the three observations from the CMIE household dataset:** In Southern India (compared to Northern India), households simultaneously exhibit: 1. Higher **EMI-to-income ratios** (greater use of formal credit/loans) 2. Higher **education expenditure** 3. Higher **savings rates** **2. Evaluate the competing interpretations:** - Because Southern households *also* maintain higher savings rates and higher education spending, their higher EMI-to-income ratio is **not** a sign of financial irresponsibility or distress (ruling out A and D). - Instead, higher education levels and financial literacy correlate with **greater formal financial product adoption** (access to banking, credit, and savings instruments) and a willingness to use structured credit (EMIs) for **productive asset creation** (housing, vehicles, education) alongside disciplined saving. **Answer: B — Higher education levels in Southern states may correlate with greater financial product adoption and willingness to borrow for asset creation.** A: **Incorrect:** High savings rates and education investment contradict the claim of financial irresponsibility. B: **Correct:** Higher education and financial inclusion explain why households simultaneously save more, invest in education, and use formal credit (EMIs) to build assets. C: **Incorrect:** The data says Northern states have *lower* savings rates than Southern states, not higher. D: **Incorrect:** A household can simultaneously allocate a higher share of income to EMIs and to savings if discretionary consumption shares differ or formal financial engagement is higher. E: **Incorrect:** Ratios (EMI-to-income and savings rate) are already normalized by income, so higher income alone does not automatically explain all three patterns without financial literacy/adoption.

**1. Apply the top-down Market Sizing funnel step by step:** 1. **Total city population:** \(5,00,000\) (5 lakh) 2. **Adult population (aged 18+, 60% of population):** \[5,00,000 \times 0.60 = 3,00,000\text{ adults}\] 3. **Adults with two-wheeler licenses (40% of adults):** \[3,00,000 \times 0.40 = 1,20,000\text{ license holders}\] 4. **License holders intending to buy within 2 years (30% of license holders):** \[1,20,000 \times 0.30 = 36,000\text{ intending buyers}\] 5. **Intending buyers who opt for loans (70% of intending buyers):** \[36,000 \times 0.70 = 25,200\text{ loan customers}\] **2. Multiply by the average two-wheeler cost (₹80,000):** \[\text{Total Addressable Loan Market} = 25,200 \times ₹80,000 = ₹2,01,60,00,000 = ₹201.6\text{ crore}\] (Since \(1\text{ crore} = 10^7\), \(2,01,60,00,000 / 10^7 = 201.6\text{ crore}\).) **Answer: C — ₹201.6 crore.** A: **Incorrect:** `₹100.8 crore` is the annual (1-year) half of the 2-year total addressable market of ₹201.6 crore. B: **Incorrect:** `₹50.4 crore` is one-fourth of the total ₹201.6 crore market. C: **Correct:** \(5,00,000 \times 0.60 \times 0.40 \times 0.30 \times 0.70 \times ₹80,000 = 25,200 \times ₹80,000 = ₹201.6\text{ crore}\). D: **Incorrect:** `₹33.6 crore` omits the 60% adult share or miscalculates the multiplier. E: **Incorrect:** `₹144 crore` forgets the 70% loan-adoption factor (and uses a different multiplier).

**1. Distinguish between Correlation and Causation in a 2x2 contingency table:** The 2x2 cross-tabulation shows that: - Among Fixed Deposit (FD) holders, **45%** own a two-wheeler. - Among non-FD holders, **30%** own a two-wheeler. **2. Interpret the finding accurately:** - There is a clear **positive association (correlation)** between owning an FD and owning a two-wheeler (a 15 percentage-point higher ownership rate among FD holders), which suggests that underlying financial stability or savings capacity is linked to a higher propensity to acquire assets. - However, because this is observational cross-sectional survey data (with confounding variables like income and age), **causation cannot be established** (opening an FD does not *cause* someone to buy a two-wheeler). **Answer: B — FD ownership shows positive correlation with two-wheeler ownership, suggesting financial stability may increase asset acquisition propensity, but causation cannot be established.** A: **Incorrect:** Observational cross-tabulation shows correlation, not causation; third variables like household income drive both FD and vehicle ownership. B: **Correct:** The 45% vs. 30% comparison demonstrates a positive correlation suggesting a link with financial stability, without proving causation. C: **Incorrect:** 30% of non-FD holders still own two-wheelers (and non-FD holders may be a large group), so excluding them entirely would be a mistake. D: **Incorrect:** While FD ownership may correlate with income, a 2x2 table of FD vs. two-wheeler ownership does not directly measure or prove income levels. E: **Incorrect:** A 2x2 contingency table is a standard and appropriate tool for comparing two binary categorical variables.

**1. Understand how Pivot Table Report Filters interact with Rows and Columns:** Initially, the pivot table has: - **Rows:** `Department` - **Columns:** `Hostel` (5 hostels) - **Values:** `Count of Grade` - **Filter:** `Department = 'Computer Science' (CS)` **2. Trace what happens when `Hostel` and `Department` are swapped while the `CS` filter remains active:** - **Rows** become `Hostel` \(\implies\) displays the **5 rows (one for each of the 5 hostels)**. - **Columns** become `Department`. Because the filter for `'Computer Science'` is **still active**, only the `'Computer Science' (CS)` department is included! - Therefore, the pivoted table displays **5 rows (hostels) with a single data column (`CS`)** showing the grade counts per hostel. **Answer: B — She sees 5 rows (hostels) with a single column (CS) showing grade counts per hostel.** A: **Incorrect:** Filtering a field that is placed in the Columns area is completely valid in Excel Pivot Tables. B: **Correct:** Putting `Hostel` in Rows and `Department` (filtered to `CS` only) in Columns displays the 5 hostel rows against the single `CS` column. C: **Incorrect:** Swapping row and column fields preserves any active filters on those fields. D: **Incorrect:** Active filters on `Department` continue to restrict the displayed departments to `CS` only. E: **Incorrect:** While the table transposes, Option B gives the exact specific description of the resulting 5-row by 1-column (`CS`) layout.

**1. Identify the two dimensions the chart must communicate simultaneously over 2015–2022:** 1. **Shifts in relative composition** (how public banks, private banks, and NBFCs contributed over time). 2. **Tripling of the total market size** from 2015 to 2022 (overall volume expansion). **2. Compare the chart types:** - A 100% stacked chart or pie charts only show relative percentages, hiding the fact that the total market tripled. - A **stacked area chart using absolute values** (e.g., loan volume in ₹ crore on the vertical axis and years 2015–2022 on the horizontal axis) shows each lender category's individual volume band **and** stacks them so the top boundary clearly displays the **tripling of the total market** over time! **Answer: B — A stacked area chart using absolute values (not percentages) to show both individual lender growth and total market expansion.** A: **Incorrect:** A single pie chart for 2022 shows neither the 2015–2022 time trend nor the tripling of the total market. B: **Correct:** A stacked area chart in absolute rupee terms displays both each lender segment's trajectory and the overall market expansion (the top line tripling). C: **Incorrect:** Comparing only 2015 and 2022 omits the intermediate annual trends from 2016 to 2021. D: **Incorrect:** A scatter plot of share vs. market size obscures the chronological 2015–2022 time series across the three categories. E: **Incorrect:** Pie charts show proportions summing to 100% and cannot effectively convey that the total market size tripled.

**1. Compare the total loan value of Lender X and Lender Y:** We are given that the total two-wheeler loan market is ₹10,000 crore: - **Lender X's market share (by value):** **15%** of the market (₹1,500 crore). - **Lender Y's market share (by value):** **25%** of the market (₹2,500 crore). (Even if market share were by volume of loans, \(25\% \times ₹38,000 = 9,500\) vs \(15\% \times ₹45,000 = 6,750\), so Lender Y's total loan value is **already much larger** than Lender X's total loan value!) **2. Conclude:** Because Lender Y has a 25% market share compared to Lender X's 15% market share, **Lender Y already exceeds Lender X's total loan value** and does not need to increase its loans to match Lender X. **Answer: E — It already exceeds Lender X’s total loan value due to its larger market share.** A: **Incorrect:** `18%` is the ticket-size ratio \((45,000 - 38,000) / 38,000 \approx 18.4\%\), ignoring that Lender Y already has a 25% vs. 15% market share. B: **Incorrect:** Lender Y's total loan value is already higher than Lender X's. C: **Incorrect:** Lender Y does not need to increase its loan count to match Lender X. D: **Incorrect:** Lender Y already has a larger share of the market than Lender X. E: **Correct:** With 25% market share versus Lender X's 15% (even with a ₹38,000 vs ₹45,000 ticket size), Lender Y's total loan value already exceeds Lender X's.

**1. Analyze the three data points for the Beauty & Personal Care segment:** 1. **143.3% online order volume growth (FY22 vs. FY21):** Shows rapid consumer adoption online (**strong growth opportunity**). 2. **Only 2% share of overall retail:** Shows the current base is still relatively **small**. 3. **Traditional offline channels still hold 72.3% of the segment:** Shows that nearly three-fourths of purchases still happen in brick-and-mortar stores (**significant offline competition remains**). **2. Formulate the strategic conclusion:** High percentage growth on a small base indicates a promising growth opportunity, but because traditional offline retail still controls 72.3% of the category, the company must account for strong offline competition rather than assuming offline retail is dead or that Beauty will immediately overtake Food & Grocery. **Answer: C — High growth rate on a small base represents an opportunity, but the large traditional channel share means significant offline competition remains.** A: **Incorrect:** Exiting the fastest-growing segment (143.3% growth) ignores its clear expansion potential. B: **Incorrect:** Traditional channels still command 72.3% of the segment, so they are far from dying. C: **Correct:** Balances the 143.3% growth opportunity on a small (2%) base with the reality that 72.3% of the market remains in traditional offline channels. D: **Incorrect:** A high percentage growth rate on a tiny 2% base does not mean it will soon surpass massive staple categories like Food & Grocery. E: **Incorrect:** Ignoring high-growth emerging online categories would forfeit future market share.

**1. Compare Warehouse C's opening stock with the 7-day sales demand for SKU F01:** - **Opening stock at Warehouse C:** \(77\text{ units}\) - **Daily sales demand at Warehouse C (Days 1 to 7):** \(10, 21, 15, 17, 13, 19, 15\) **2. Calculate total 7-day demand and cumulative stock depletion:** - **Total 7-day demand:** \[10 + 21 + 15 + 17 + 13 + 19 + 15 = 110\text{ units}\] - **Average daily demand rate:** \[\frac{110\text{ units}}{7\text{ days}} \approx 15.71 \approx 15.7\text{ units/day}\] - **Cumulative demand day by day vs. opening stock of 77:** - End of Day 1: \(10\) (67 left) - End of Day 2: \(10 + 21 = 31\) (46 left) - End of Day 3: \(31 + 15 = 46\) (31 left) - End of Day 4: \(46 + 17 = 63\) (14 left) - End of Day 5: \(63 + 13 = 76\) (1 unit left!) - **On Day 6:** Demand is \(19\) units, but only \(1\) unit is left! Thus, **stock runs out on Day 6 (stockout before Day 7)**. **Answer: B — Stock runs out during the week (stockout before Day 7); average demand is 15.7 units/day.** A: **Incorrect:** Total demand is 110 units (not 44 units), which exceeds the 77 units of opening stock. B: **Correct:** Cumulative demand reaches 76 units on Day 5 and 95 units on Day 6, exhausting the 77-unit stock on Day 6, with an average daily demand of \(110 / 7 \approx 15.7\text{ units/day}\). C: **Incorrect:** Average demand is \(110 / 7 \approx 15.7\) units/day, and the stockout occurs on Day 6 before Day 7. D: **Incorrect:** Sales occurred every day from Day 1 to Day 7. E: **Incorrect:** The question explicitly states 'assuming no restocking'.

**1. Calculate the total raw material cost for 4,000 units of Gear Assembly 3:** Each unit of Gear Assembly 3 requires: - 1 unit of **Gear 3-A** (made from Blank 011, costing **₹105**) - 1 unit of **Gear 3-B** (made from Blank 021, costing **₹35**) - **Raw material cost per assembly:** \[₹105 + ₹35 = ₹140\text{ per unit}\] - **Total raw material cost for 4,000 units:** \[4,000 \times ₹140 = ₹5,60,000\] **2. Identify the production bottleneck workstation:** Compare the daily production capacities of the two required workstations: - **Hobbing workstation (for Gear 3-A):** \(800\text{ units/day}\) - **Broaching workstation (for Gear 3-B):** \(780\text{ units/day}\) Because **Broaching has the lower capacity** (\(780 < 800\text{ units/day}\)), it limits the overall throughput of Gear Assembly 3 to 780 assemblies/day, making **Broaching the bottleneck**. **Answer: B — ₹5,60,000; Broaching is the bottleneck.** A: **Incorrect:** Hobbing produces 800 units/day whereas Broaching produces only 780 units/day, so Broaching is the slower bottleneck step. B: **Correct:** Raw material cost is \(4,000 \times (₹105 + ₹35) = ₹5,60,000\), and Broaching (780 units/day < 800 units/day) is the bottleneck. C: **Incorrect:** `₹4,20,000` only counts Blank 011 (\(4,000 \times ₹105 = ₹4,20,000\)) and forgets Blank 021. D: **Incorrect:** `₹4,20,000` omits the ₹1,40,000 cost of Blank 021. E: **Incorrect:** Whenever two sequential/paired processes have unequal capacities (800 vs. 780), the lower-capacity station (Broaching) is the bottleneck.

**1. Recall the Overall Equipment Effectiveness (OEE) formula:** \[\text{OEE} = \text{Availability} \times \text{Performance} \times \text{Quality}\] **2. Calculate each component from the plant data:** 1. **Planned Production Time & Operating (Run) Time:** - Planned Production Time \(= \text{Shift length} - \text{Breaks} = 480\text{ min} - 60\text{ min} = 420\text{ min}\) - Operating Time (Run Time) \(= \text{Planned Production Time} - \text{Downtime} = 420\text{ min} - 47\text{ min} = 373\text{ min} = 22,380\text{ seconds}\) - **Availability:** \[\text{Availability} = \frac{373}{420} \approx 0.8881 \quad (88.81\%)\] 2. **Performance:** - Ideal Cycle Time \(= 1.0\text{ sec/unit}\), Total Count \(= 19,271\text{ units}\) - \[\text{Performance} = \frac{\text{Total Count} \times \text{Ideal Cycle Time}}{\text{Operating Time}} = \frac{19,271 \times 1.0\text{ sec}}{22,380\text{ sec}} \approx 0.86108 \quad (86.11\%)\] 3. **Quality:** - Good Count \(= \text{Total Count} - \text{Reject Count} = 19,271 - 423 = 18,848\text{ units}\) - \[\text{Quality} = \frac{18,848}{19,271} \approx 0.97805 \quad (97.81\%)\] **3. Multiply the three ratios to find OEE:** Notice that the intermediate terms cancel cleanly: \[\text{OEE} = \frac{\text{Good Count} \times \text{Ideal Cycle Time}}{\text{Planned Production Time}} = \frac{18,848 \times 1.0\text{ sec}}{420 \times 60\text{ sec}} = \frac{18,848}{25,200} \approx 0.747936 \approx 74.8\%\] **Answer: B — 74.8%.** A: **Incorrect:** `85.2%` forgets to multiply by one of the OEE factors (Availability or Performance). B: **Correct:** Good units (`19,271 - 423 = 18,848`) times ideal cycle time (`1.0 sec`) divided by planned production time (`420 min = 25,200 sec`) gives \(18,848 / 25,200 \approx 74.8\%\). C: **Incorrect:** `72.4%` does not subtract the 60-minute break from shift length properly. D: **Incorrect:** `80.0%` is a rough guess, whereas the exact OEE is `74.8%`. E: **Incorrect:** `78.3%` omits the reject count or downtime adjustment.

**1. Understand the relationship between Sales Quantity, Unit Price, and Revenue:** Since \(\text{Revenue} = \text{Sales Quantity} \times \text{Unit Price}\), on a scatter plot of Sales Quantity vs. Revenue, the ratio \(\frac{\text{Revenue}}{\text{Sales Quantity}}\) represents the **unit selling price** of the product: - **GA6 (BS4/6):** Has **very high sales volume** but only **moderate total revenue**, meaning its **unit price is low** (a high-volume, low-priced mass product). - **GA7 (BS4/6):** Has **moderate sales volume** but **high total revenue**, meaning its **unit price is high** (a premium, higher-priced/high-margin product). **Answer: B — GA6 is a low-priced, high-volume product while GA7 is a premium high-margin product, reflecting different pricing strategies.** A: **Incorrect:** Differing volume-to-revenue ratios across product lines reflect unit price differences, not necessarily a data entry error. B: **Correct:** Since \(\text{Revenue} = \text{Price} \times \text{Quantity}\), high volume with moderate revenue (GA6) indicates a lower unit price, whereas moderate volume with high revenue (GA7) indicates a higher unit price. C: **Incorrect:** Lower sales volume for a higher-priced gear assembly does not make its sales data unreliable. D: **Incorrect:** Distinct product positioning should be analyzed rather than discarded. E: **Incorrect:** Different gear assemblies (GA6 vs. GA7) have different specifications, costs, and unit prices.

**1. Recall the inventory management policies for ABC Classification:** In ABC inventory analysis: - **Category A (Item X — ₹50 lakh, high consumption value):** Requires tightest control, frequent review, **accurate records**, and **Just-In-Time (JIT) / planned order** delivery to avoid tying up large amounts of working capital. - **Category B (Item Y — ₹5 lakh, moderate consumption value):** Managed with moderate control, **safety stock with planned orders**. - **Category C (Item Z — ₹50,000, low consumption value):** Managed with minimal administrative overhead, **Economic Order Quantity (EOQ) bulk ordering and simple record-keeping**. **Answer: B — X: JIT with planned orders and accurate records; Y: Safety stock with planned orders; Z: EOQ with simple record-keeping.** A: **Incorrect:** Ordering high-value Category A items (`X`) in large batches ties up excessive capital and increases holding costs. B: **Correct:** Category A (`X`) warrants tight JIT/planned control and accurate records, Category B (`Y`) uses safety stock with planned orders, and low-value Category C (`Z`) uses EOQ with simple records. C: **Incorrect:** Applying strict JIT to low-value Category C items (`Z`) wastes administrative effort while holding large buffers of expensive Category A items (`X`) wastes capital. D: **Incorrect:** JIT requires intensive supplier coordination that is not cost-effective for cheap Category C items. E: **Incorrect:** The whole purpose of ABC classification is to differentiate inventory control intensity across A, B, and C items.

**1. Calculate the net number of operators needed from external hiring:** - **Total new operators needed:** \(50\) - **Supplied via internal retraining:** \(12\) - **Net operators needed from external hires (after attrition):** \[50 - 12 = 38\text{ operators}\] **2. Gross up for the 15% annual attrition rate among external hires:** If the company hires \(E\) external operators and 15% leave during the first year, \(85\%\) (\(0.85 E\)) remain: \[0.85 \times E = 38 \implies E = \frac{38}{0.85} \approx 44.71 \implies 45\text{ external hires}\] (Check: \(45 \times 0.85 = 38.25 \approx 38\) retained external operators, plus \(12\) internal \(= 50\) operators.) **Answer: C — 45 external hires (since 45 x 0.85 ≈ 38, plus 12 internal = 50).** A: **Incorrect:** `38` is the required net external headcount *before* accounting for the 15% attrition loss. B: **Incorrect:** \(44 \times 0.85 = 37.4 < 38\), leaving the firm short of the 50-operator target. C: **Correct:** Subtracting 12 internal hires leaves 38 net external operators needed; dividing by the 85% retention rate gives \(38 / 0.85 = 44.71\), which rounds up to 45 external hires. D: **Incorrect:** `50` ignores the 12 internal hires. E: **Incorrect:** All necessary figures are provided in the question.

**1. Identify the two business/behavioral concepts illustrated in the scenario:** 1. **A/B Testing methodology:** Randomly splitting checkout traffic between Version A (control) and Version B (treatment) for 2 weeks to measure the impact on conversion rate (4.5% vs. 3.1%). 2. **Nudge Theory (Social Proof):** Displaying the badge *'Bought by 3 people in the last hour'* uses **social proof** as a subtle behavioral nudge to reduce purchase hesitation without changing prices or restricting choices. **Answer: B — A/B testing methodology and nudge theory (social proof as a behavioral nudge).** A: **Incorrect:** No market sizing or supply-demand pricing equilibrium is involved in a checkout badge experiment. B: **Correct:** Comparing Version A and Version B is A/B testing, and the 'Bought by 3 people in the last hour' badge is a social-proof behavioral nudge. C: **Incorrect:** Checkout conversion optimization is unrelated to credit risk assessment. D: **Incorrect:** This is a randomized controlled web experiment with a behavioral nudge, not a pivot table task. E: **Incorrect:** Spreadsheet lookup functions are unrelated to this checkout experiment.

**1. Evaluate the loan applicant's profile across credit risk categories:** - **Eligibility / Financial capacity:** Age 28, ₹6 LPA income, ₹8,000/month existing EMI, and zero prior defaults all meet standard creditworthiness criteria. - **KYC Document Name Mismatch:** A slight spelling discrepancy between the applicant's PAN card and bank records violates **Know Your Customer (KYC) regulatory verification standards** mandated by the RBI/regulators, which primarily constitutes a **Compliance risk** (requiring KYC rectification/affidavit before disbursement). **Answer: C — Compliance risk - the KYC documents don’t match, creating regulatory issues.** A: **Incorrect:** The applicant's age, income (₹6 LPA), and low existing EMI meet eligibility criteria. B: **Incorrect:** A minor spelling variation in a legitimate applicant's PAN vs. bank account is primarily a KYC compliance/documentation issue rather than outright identity theft. C: **Correct:** Mismatched names across official KYC documents (PAN vs. bank records) create regulatory non-compliance risk under KYC norms. D: **Incorrect:** The issue is regulatory KYC verification compliance, not a software bug. E: **Incorrect:** Regulated lenders cannot ignore KYC document mismatches due to strict regulatory compliance rules.