A manufacturer finds that over the past year, there has been a shift in consumer preference within
the two-wheeler market: the demand for scooters has decreased by 10%, whereas the demand for
motorcycles, especially higher-capacity models, has increased by 15%. Given this trend, how
should the manufacturer adjust its product portfolio?
A.
Increase production of scooters to clear out existing inventories.
B.
Shift manufacturing focus towards higher-capacity motorcycles to meet rising
demand.
C.
Keep the production rates the same, expecting the market to stabilize.
D.
Focus exclusively on high-capacity motorcycles and cease scooter production.
A published solution is not available for this question yet.
If a pivot table analysis reveals that a lender’s portfolio has shifted from predominantly
commercial loans to a more diversified portfolio including significant amounts of retail and
microfinance loans over the years, what might this indicate about the lender’s strategic shift?
A.
Diversification to mitigate risk
B.
Shifting market demand
C.
Regulatory Changes Influencing Lending Practices
D.
Not enough data is given in the situation to determine
A published solution is not available for this question yet.
Consider the following table and scatter plot and answer the questions
Product ID Product Category Sales Quantity Revenue ($)
P001 Electronics 150 4500
P002 Clothing 200 3000
P003 Home Appliances 100 5000
P004 Electronics 250 7500
P005 Clothing 150 2250
P006 Home Appliances 80 3200
Sales V/S Product Plot
250
200
150
r
100 8
I
50
a
LL = a a
001
g
P003 Pood
P006
POOS
Based on the above data, answer the given subquestions.
If you color-code the data points on the scatter plot by "Product Category," which of the following
statements would likely be true?
A.
All categories will cluster together, showing no distinct grouping.
B.
Electronics might form a cluster with higher revenue compared to other
categories.
C.
Clothing will show the highest sales quantity and revenue.
D.
Home Appliances will demonstrate the least variability in sales quantity and
revenue.
A published solution is not available for this question yet.
Consider the following table and scatter plot and answer the questions
Product ID Product Category Sales Quantity Revenue ($)
P001 Electronics 150 4500
P002 Clothing 200 3000
P003 Home Appliances 100 5000
P004 Electronics 250 7500
P005 Clothing 150 2250
P006 Home Appliances 80 3200
Sales V/S Product Plot
250
200
150
r
100 8
I
50
a
LL = a a
001
g
P003 Pood
P006
POOS
Based on the above data, answer the given subquestions.
Considering the given data, which category has the highest average revenue per unit?
A.
Home Appliances
B.
Clothing
C.
Electronics
A published solution is not available for this question yet.
The teacher wants to assign students grades based on their Maths marks using the IF function.
Which Excel formula represents the correct structure for this conditional grading?
A.B.C.D.
A published solution is not available for this question yet.
Four candidates are being considered for a Software Engineer position. The hiring committee has
rated them based on the number of relevant skills they possess, the number of days they can join
in, the number of relevant certificates they hold, and their years of relevant experience. Give all
the criteria the same weightage. Evaluate the data below and determine which candidate should
be ranked the highest based on the given criteria (more skills, more certificates, more experience
are better; fewer days to join is better).
Candidate A:
● Number of relevant skills: 12
● Days to join: 30
● Number of relevant certificates: 5
● Years of relevant experience: 3
Candidate B:
● Number of relevant skills: 15
● Days to join: 45
● Number of relevant certificates: 3
● Years of relevant experience: 4
Candidate C:
● Number of relevant skills: 10
● Days to join: 20
● Number of relevant certificates: 7
● Years of relevant experience: 5
Candidate D:
● Number of relevant skills: 14
● Days to join: 15
● Number of relevant certificates: 4
● Years of relevant experience: 6
Choose the correct ranking of the candidates from most suitable to least suitable:
A.
Candidate D > Candidate C > Candidate A or Candidate B
B.
Candidate B > Candidate A > Candidate C, Candidate D
C.
Candidate D > Candidate A > Candidate C > Candidate B
D.
Candidate C > Candidate D > Candidate A or Candidate B
A published solution is not available for this question yet.
A company has noticed that its average days of inventory are significantly lower than the industry
standard. Which of the following statements describes the potential consequences of this
situation?
A.
Increased carrying costs due to holding excess inventory.
B.
Higher likelihood of stockouts, leading to possible lost sales.
C.
Less need for warehouse space, reducing storage cost inefficiencies.
D.
Lower inventory obsolescence risks and reduced waste.
A published solution is not available for this question yet.
Considering the sales data and inventory levels for SKU cities (distribution centres) like Hyderabad,
Cochin, and Madras, what could be a significant risk if the average sales drastically change over a
short period?{Select All that apply}
A.
Overestimation of inventory needs leading to excess stock.
B.
Underestimation of lead times for inventory replenishment.
C.
Inaccurate calculation of the total opening stock.
D.
Misalignment between sales forecasts and actual sales data.
A published solution is not available for this question yet.
Imagine, you are an efficiency consultant hired by ABC Corp, a company that manufactures
automotive parts. Your first assignment is to evaluate the performance of their primary
production line. The provided data includes:
● The planned production time for last quarter was 700 hours.
● Unexpectedly, the line experienced 60 hours of lost time.
● The expected assembly rate of the line was 200 units per hour.
● However, the actual rate achieved was 180 units per hour.
● Over the quarter, 14,000 units were assembled.
● Out of these, 700 units were found to be defective.
Calculate the OEE for ABC Corp's production line and provide the result.
A published solution is not available for this question yet.
Based on the above data, answer the given subquestions.
What does the distribution of In_Game_Purchases in Group B suggest about the new tutorial’s
effectiveness?
A.
It's highly effective, as most players increased their purchases.
B.
Effectiveness is moderate; only some players increased their purchases.
C.
The new tutorial has no clear impact on purchase behavior.
D.
It is less effective; fewer players made purchases after the introduction of the
new tutorial.
**Business Analytics**
**Section Id :** 64065356698
**Section Number :** 13
**Section type :** Online
**Mandatory or Optional :** Mandatory
**Number of Questions :** 16
**Number of Questions to be attempted :** 16
**Section Marks :** 45
**Display Number Panel :** Yes
**Section Negative Marks :** 0
**Group All Questions :** No
**Enable Mark as Answered Mark for Review and**
Yes
**Clear Response :**
**Maximum Instruction Time :** 0
A published solution is not available for this question yet.