The IIT Madras BS Business Data Management (BDM) Quiz 2 paper sat on 16 Mar 2025, in the January 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.
What best describes the Economic Census conducted by the government?
It is infrequent, covering every household in the country.
Conducted every five years to capture data from all households.
A sampling-based survey done every year to gather household information.
Conducted once every ten years, capturing data from every single household.
Correct answer
Conducted once every ten years, capturing data from every single household.
When would you most likely use a bar graph in Excel?
To display the frequency distribution of categorical data
To represent changes over time
To illustrate the parts of a whole
To show relationships between variables
Correct answer
To display the frequency distribution of categorical data
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
What kind of goods’ demand decreases as income increases?
Superior Good
Inferior Good
Luxury Good
Supply Good
Correct answer
Inferior Good
For the Data Given below, which function would you use to count the number of salespeople who exceeded both their Q1 and Q2 quotas.
COUNT(A2:A5,"=Yes",C3:C5,"=Yes")
COUNTIFS(B2:B5,"=Yes",C2:C5,"=Yes")
COUNTIF(B2:B5,"=Yes",C2:C5,"=Yes")
COUNTA(C2:C5,"=Yes",D2:D5,"=Yes")
Correct answer
COUNTIFS(B2:B5,"=Yes",C2:C5,"=Yes")
In the formula =VLOOKUP(A1, B1:C10, 2, FALSE), what does the "2" represent?
The column to search in
The column to return a value from
The number of matches to find
The row to start searching from
Correct answer
The column to return a value from
Which chart is used to display the distribution of a dataset by dividing it into bins?
Scatter Plot
Bubble Chart
Histogram
Box Plot
Correct answer
Histogram
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.
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)
You oversee the inventory management of gear assemblies in a manufacturing facility. The particulars of the inventory are as follows:
Starting Inventory: 100 units
Daily Usage: 5 units
Lead Time: 10 days
Safety Stock: 20 units
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
You oversee the inventory management of gear assemblies in a manufacturing facility. The particulars of the inventory are as follows:
Starting Inventory: 100 units
Daily Usage: 5 units
Lead Time: 10 days
Safety Stock: 20 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%
