The IIT Madras BS Business Data Management (BDM) End Term paper sat on 30 Apr 2023, in the January 2023 term, set QPD1-S1: 18 questions for 40 marks in 180 minutes. Every question is below with its answer. Take it as a timed mock test to be marked, or read it through first.
When does marginal utility become negative?
When a consumer consumes the first unit of a good
When the total utility of a good is zero.
When the total utility of a good is at its maximum.
When the consumer reaches the point of overconsumption.
Correct answer
When the consumer reaches the point of overconsumption.
The current ratio is a measure of:
A company's ability to pay its long-term debt obligations.
A company's liquidity and short-term solvency.
A company's ability to generate profits.
A company's efficiency in managing its inventory.
Correct answer
A company's liquidity and short-term solvency.
A Company has current assets of $500,000 and current liabilities of $250,000. What is the current ratio of the company?
2
0.5
1
1.5
Correct answer
2
Match the following
| 1 | Pricing Decisions | A | Process that integrates various business processes, functions, and departments within an organisation into a single system |
|---|---|---|---|
| 2 | Production Function | B | Measure if manufacturing efficiency that calculates the percentage of actual productive manufacturing time, as compared to the planned production time |
| 3 | Enterprise Resource Planning System | C | Choices Businesses makes when setting prices for their products or services |
| 4 | Overall Equipment Effectiveness | D | Relationship between inputs (such as labour and capital) and output (such as the quantity of goods or services produced) |
1-A, 2-B, 3-C, 4-D
1-C, 2-D, 3-A, 4-B
1-B, 2-C, 3-D, 4-A
1-D, 2-A, 3-B, 4-C
Correct answer
1-C, 2-D, 3-A, 4-B
What do regional tables signify?
It tells which region brought the most revenue and volume sales.
It tells which production unit gave the highest revenue and volume sales.
It organizes data based on geographic regions and areas.
Both It tells which region brought the most revenue and volume sales & It organizes data based on geographic regions and areas.
Correct answer
Both It tells which region brought the most revenue and volume sales & It organizes data based on geographic regions and areas.
Which of the SKU should be placed closer to the processing center?
A
B
C
D
Correct answer
B
Match the following
| 1 | Ashmit who has not got his KYC done, applied for a credit of 120 rupees but got rejected. | A | Eligibility |
|---|---|---|---|
| 2 | Beena has defaulted in paying her EMIs for 5 straight months now, but is sad now that her Pay Later Option isn't enabled | B | Fraud Risk |
| 3 | Chetan gets notified because his transaction amount was too high and the location of this request was from some obsolete island near Caribbean | C | Credit Risk |
| 4 | Divya who is just graduated from Std. 4B to Std. 5A in School tried applying for credit but got rejected. | D | Compliance Issue |
1-A, 2-B, 3-C, 4-D
1-D, 2-C, 3-B, 4-A
1-B, 2-C, 3-D, 4-A
1-D, 2-A, 3-B, 4-C
Correct answer
1-D, 2-C, 3-B, 4-A
Suppose you have an Excel cell containing the following text string: "03/12/2022 14:36:00". Which of the following formulas will return the date "03/12/2022" from this cell using the LEFT function?
=LEFT(A1, 10)
=LEFT(A1, 8)
=LEFT(A1, 5)
=LEFT(A1, 7)
Correct answer
=LEFT(A1, 8)
If the price of a product increases by 10% and the quantity demanded decreases by 20%, what is the price elasticity of demand?
2
0.5
1
1.5
Correct answer
2
Consider the dataset. Rank the candidates, and choose the option correctly. Here appraisal score, duration in the current post, and count of skills are higher the better, whereas the joining possibility is lower the better.
| Candidates | Appraisal Score | Duration in the current Post (in yrs) | Count of Skills | Joining Possible (in Months) |
|---|---|---|---|---|
| A | 2 | 3 | 3 | 1 |
| B | 3 | 3 | 3 | 1 |
| C | 2 | 4 | 2 | 2 |
| D | 1 | 2 | 2 | 2 |
D > C > B > A
C > D > B > A
B > A > C > D
A > B > C > D
Correct answer
B > A > C > D
Give the preference order in which the following people are most likely to get their credit request approved
| Customer Name | Cust Engagement | Application Credit Score | Application Amount |
|---|---|---|---|
| Alya | Mid | 444 | 100 |
| Bobby | Low | 630 | 120 |
| Catty | Mid | 500 | 210 |
| Deepak | High | 613 | 100 |
Deepak > Bobby > Catty > Alya
Alya > Deepak > Catty > Bobby
Bobby > Catty > Alya > Deepak
Deepak > Alya > Catty > Bobby
Correct answer
Deepak > Bobby > Catty > Alya
The following table provides the number of credit applications approved or declined in 4 months in 2021
Which Month has the highest approval rate?
July
August
September
October
Correct answer
August
Calculate the given subquestions for Gear Hobbing Process for Week 1
| Parameters | Week 1 |
|---|---|
| No. of Shifts/ Day (No Holiday on any day of the week) | 3 |
| No. of Hours/Shift | 8 |
| Number of Shifts lost due to maintenance | 6 |
| Designed Speed of Hobbing Process (per hour) | 60 |
| Total Product Output | 6200 |
| Scrap (S) | 422 |
Availability - _______%
Correct answer: 71.5 (accepted within ±1.5)
Calculate the given subquestions for Gear Hobbing Process for Week 1
| Parameters | Week 1 |
|---|---|
| No. of Shifts/ Day (No Holiday on any day of the week) | 3 |
| No. of Hours/Shift | 8 |
| Number of Shifts lost due to maintenance | 6 |
| Designed Speed of Hobbing Process (per hour) | 60 |
| Total Product Output | 6200 |
| Scrap (S) | 422 |
Performance ________%
Correct answer: 86 (accepted within ±1)
Calculate the given subquestions for Gear Hobbing Process for Week 1
| Parameters | Week 1 |
|---|---|
| No. of Shifts/ Day (No Holiday on any day of the week) | 3 |
| No. of Hours/Shift | 8 |
| Number of Shifts lost due to maintenance | 6 |
| Designed Speed of Hobbing Process (per hour) | 60 |
| Total Product Output | 6200 |
| Scrap (S) | 422 |
Quality ________%
Correct answer: 93.25 (accepted within ±0.75)
Calculate the given subquestions for Gear Hobbing Process for Week 1
| Parameters | Week 1 |
|---|---|
| No. of Shifts/ Day (No Holiday on any day of the week) | 3 |
| No. of Hours/Shift | 8 |
| Number of Shifts lost due to maintenance | 6 |
| Designed Speed of Hobbing Process (per hour) | 60 |
| Total Product Output | 6200 |
| Scrap (S) | 422 |
OEE _______ (Enter a number between 0 and 1 up to 3 decimal places)
Correct answer: 0.5715 (accepted within ±0.0115)
Answer the given subquestions concerning the Hobbing process of gear manufacturing?
Total Output of Gear Casts after Broaching: 2300
Cost of Broaching: INR 27 per Gear cast, Raw Material Cost: INR 43 per Gear Cast
Scrap Percentage after broaching process__________________%
Correct answer: 3.2 (accepted within ±0.05)
Answer the given subquestions concerning the Hobbing process of gear manufacturing?
Total Output of Gear Casts after Broaching: 2300
Cost of Broaching: INR 27 per Gear cast, Raw Material Cost: INR 43 per Gear Cast
Loss due to scrap after broaching_________________________
Correct answer: 5175 (accepted within ±125)
