The IIT Madras BS Business Data Management (BDM) Quiz 2 paper sat on 3 Aug 2025, in the May 2025 term: 15 questions for 20 marks in 120 minutes. Every question is below with its answer. Take it as a timed mock test to be marked, or read it through first.
The reference to cell B1 will adjust when the formula is copied to other cells.
The reference to cell B1 is absolute and will not change when the formula is copied to other cells.
The reference to cell A1 is absolute and will not change when the formula is copied to other cells.
The reference to cell A1 is absolute, but reference to B1 is relative.
Correct answer
The reference to cell B1 is absolute and will not change when the formula is copied to other cells.
What are the roles that the Government plays in the economic circular flow model?
Producer and Consumer
Moderator and Participant
Both Producer and Consumer & Moderator and Participant
None of these
Correct answer
Both Producer and Consumer & Moderator and Participant
Which of the following factors is most critical in determining the market potential for a new product ?
The size of the target market and percentage of potential customers interested in the product.
Historical sale data of unrelated products.
Cost of production and distribution.
Current market share of existing products.
Correct answer
The size of the target market and percentage of potential customers interested in the product.
In Excel, the SUBTOTAL function is used to perform calculations on a filtered range of data. Which of the following statements about the SUBTOTAL function is correct?
SUBTOTAL can only calculate the sum of a range and ignores hidden rows in the filtered data.
SUBTOTAL can perform various calculations, including sum, average, count, and more, and it ignores rows hidden by filters.
SUBTOTAL performs calculations only on rows that are manually hidden, not those hidden by filters.
SUBTOTAL can calculate results based on data in any worksheet, regardless of whether the data is visible or hidden.
Correct answer
SUBTOTAL can perform various calculations, including sum, average, count, and more, and it ignores rows hidden by filters.
Which of the following is typically NOT performed when using a pivot table in data analysis ?
Filtering data to display only specific records.
Creating new records in the original dataset.
Grouping data by categories or fields to analyze trends and patterns.
Summarizing data by aggregating values, such as sum, count, or average.
Correct answer
Creating new records in the original dataset.
Which chart can be used to represent the intensity or size of a data ?
Scatter Plot
Bubble Chart
Histogram
Box Plot
Correct answer
Bubble Chart
What does SOR refer to in e-commerce?
Sales of Resource
Sale or Return
Sales of Return
Sales on Regular
Correct answer
Sale or Return
Which of the following statements best describes the difference between a niche market and a mass market?
A niche market targets a small, specific group of customers with specialized needs, while a mass market targets a large, broad group of customers with general needs.
A niche market involves offering lower-priced products to a wide audience, whereas a mass market involves offering high-end products to a small, exclusive group.
A niche market typically requires large-scale advertising campaigns to reach a broad audience, while a mass market relies on word-of-mouth and targeted marketing.
A niche market focuses on standard products that appeal to everyone, while a mass market customizes products to fit individual customer preferences.
Correct answer
A niche market targets a small, specific group of customers with specialized needs, while a mass market targets a large, broad group of customers with general needs.
Determine the percentage change in total revenue when income increases from Rs 15000 to Rs 25000. (upto 3 decimals, hint : if your ans is 98% then enter 0.98 as your answer).
Income level 1
1) Income = Rs 15,000
2) Qty demanded = 60 units
3) Price per qty = Rs 40
Income level 2
1) Income = Rs 25,000
2) Qty demanded = 90 units
3) Price per qty = Rs 38
Correct answer: 0.425
Calculate the Overall Equipment Effectiveness (OEE) of the Assembly Line Equipment for the month of July. (Round the OEE to two decimal places)
Parameters:
| Planned Production Hours (PPH): | 400 |
|---|---|
| Lost Time (LOT): | 30 |
| Designed Assembly Speed from Equipment (DA) per Hour: | 180 |
| Actual Assembly Speed from Equipment (AA) per Hour: | 160 |
| Total Units Assembled (TU): | 8000 |
| Defective Units (DU): | 320 |
Correct answer: 0.79 (accepted within ±0.02)
Based on the above data, answer the given subquestions.
Based on this information, at what inventory level should you trigger a re-order for gear assemblies?
Initiate a re-order when the inventory level drops to 70 units
Initiate a re-order when the inventory level drops to 50 units
Initiate a re-order when the inventory level drops to 30 units
Initiate a re-order when the inventory level drops to 15 units
Correct answer
Initiate a re-order when the inventory level drops to 70 units
Based on the above data, answer the given subquestions.
After how many days should you trigger a re-order
Correct answer: 6
Based on the data provided, answer the given subquestions
| SKU | Product Name | Unit Price | Monthly Sales 1 | Monthly Sales 2 | Monthly Sales 3 | Monthly Sales 4 | Monthly Sales 5 | Monthly Sales 6 | Avg. Monthly Sales | Opening Stock |
|---|---|---|---|---|---|---|---|---|---|---|
| LAP001 | NovaBook Pro | $1,299 | 100 | 120 | 150 | 180 | 200 | 220 | 161.7 | 290 |
| LAP002 | Stellar 15 | $1,799 | 80 | 90 | 100 | 110 | 120 | 130 | 105.0 | 250 |
| LAP003 | QuantumBook 16 | $2,499 | 50 | 60 | 70 | 80 | 90 | 100 | 75.0 | 190 |
| LAP004 | TitanBook X1 Carbon | $1,999 | 30 | 40 | 50 | 60 | 70 | 80 | 55.0 | 115 |
| LAP005 | EclipseBook x360 | $1,499 | 20 | 30 | 40 | 50 | 60 | 70 | 45.0 | 95 |
| LAP006 | AuroraBook Studio | $1,199 | 10 | 15 | 20 | 25 | 30 | 35 | 22.5 | 50 |
| LAP007 | ZephyrBook 17 | $999 | 5 | 10 | 15 | 20 | 25 | 30 | 17.5 | 40 |
Which SKU has the highest Days of Inventory?
LAP002
LAP003
LAP006
LAP007
Correct answer
LAP003
Based on the data provided, answer the given subquestions
| SKU | Product Name | Unit Price | Monthly Sales 1 | Monthly Sales 2 | Monthly Sales 3 | Monthly Sales 4 | Monthly Sales 5 | Monthly Sales 6 | Avg. Monthly Sales | Opening Stock |
|---|---|---|---|---|---|---|---|---|---|---|
| LAP001 | NovaBook Pro | $1,299 | 100 | 120 | 150 | 180 | 200 | 220 | 161.7 | 290 |
| LAP002 | Stellar 15 | $1,799 | 80 | 90 | 100 | 110 | 120 | 130 | 105.0 | 250 |
| LAP003 | QuantumBook 16 | $2,499 | 50 | 60 | 70 | 80 | 90 | 100 | 75.0 | 190 |
| LAP004 | TitanBook X1 Carbon | $1,999 | 30 | 40 | 50 | 60 | 70 | 80 | 55.0 | 115 |
| LAP005 | EclipseBook x360 | $1,499 | 20 | 30 | 40 | 50 | 60 | 70 | 45.0 | 95 |
| LAP006 | AuroraBook Studio | $1,199 | 10 | 15 | 20 | 25 | 30 | 35 | 22.5 | 50 |
| LAP007 | ZephyrBook 17 | $999 | 5 | 10 | 15 | 20 | 25 | 30 | 17.5 | 40 |
If the profit margin for the sale of a laptop is 10%, what is the total profit earned from the sale of LAP005?
42505
40890
41782
40473
Correct answer
40473
Based on the data provided, answer the given subquestions
| SKU | Product Name | Unit Price | Monthly Sales 1 | Monthly Sales 2 | Monthly Sales 3 | Monthly Sales 4 | Monthly Sales 5 | Monthly Sales 6 | Avg. Monthly Sales | Opening Stock |
|---|---|---|---|---|---|---|---|---|---|---|
| LAP001 | NovaBook Pro | $1,299 | 100 | 120 | 150 | 180 | 200 | 220 | 161.7 | 290 |
| LAP002 | Stellar 15 | $1,799 | 80 | 90 | 100 | 110 | 120 | 130 | 105.0 | 250 |
| LAP003 | QuantumBook 16 | $2,499 | 50 | 60 | 70 | 80 | 90 | 100 | 75.0 | 190 |
| LAP004 | TitanBook X1 Carbon | $1,999 | 30 | 40 | 50 | 60 | 70 | 80 | 55.0 | 115 |
| LAP005 | EclipseBook x360 | $1,499 | 20 | 30 | 40 | 50 | 60 | 70 | 45.0 | 95 |
| LAP006 | AuroraBook Studio | $1,199 | 10 | 15 | 20 | 25 | 30 | 35 | 22.5 | 50 |
| LAP007 | ZephyrBook 17 | $999 | 5 | 10 | 15 | 20 | 25 | 30 | 17.5 | 40 |
What percentage of total revenue do the SKUs LAP004 and LAP005 contribute together?
10%
20%
15%
25%
Correct answer
20%
