Business Data Management Quiz 2: 23 November 2025 (September 2025 term)

Which of the following statements is not true about the benefits of implementing an ERP system?

The number of heavy vehicle driving licenses issued can be used as a _________ of the potential market size for trucks.
(Fill in the Blank with the appropriate response)

If a company identifies a seasonal pattern in their sales data, how should this influence their inventory management strategy?

Which of the following statements best describes the difference between platform companies and niche companies?

In recent months, Trio Engineering Pvt. Ltd., a mid-sized automotive components manufacturer, has reported an unusually low level of inventory on hand. The Days of Inventory (DOI) has fallen sharply below the company’s usual level.
At first, management viewed this as a sign of lean and efficient operations. However, within a few weeks, the production department began facing frequent raw material shortages, leading to idle machine hours, delayed deliveries, and unmet customer orders.
The procurement team revealed that the company had been implementing an aggressive cost- control drive to reduce inventory-carrying costs. Suppliers were also asked to deliver materials just-in-time. But due to transportation delays and sudden demand surges, low DOI became common.
Based on the above data, answer the given subquestions.

Which of the following best explains the risk of maintaining excessively low Days of Inventory?

In recent months, Trio Engineering Pvt. Ltd., a mid-sized automotive components manufacturer, has reported an unusually low level of inventory on hand. The Days of Inventory (DOI) has fallen sharply below the company’s usual level.
At first, management viewed this as a sign of lean and efficient operations. However, within a few weeks, the production department began facing frequent raw material shortages, leading to idle machine hours, delayed deliveries, and unmet customer orders.
The procurement team revealed that the company had been implementing an aggressive cost- control drive to reduce inventory-carrying costs. Suppliers were also asked to deliver materials just-in-time. But due to transportation delays and sudden demand surges, low DOI became common.
Based on the above data, answer the given subquestions.

Which of the following corrective actions should Trio Engineering consider restoring balance between efficiency and reliability?

During the month of July, the operations team at ProMech Components Ltd., a manufacturer of automotive assemblies, observed that the total output from their main assembly line had declined compared to previous months.
Although the production schedule remained unchanged, managers suspected that frequent stoppages and slower production rates might be affecting efficiency.
A review of the production records revealed that the line had been scheduled to operate for 400 hours in July.
However, around 80 hours were lost due to setup adjustments, maintenance delays, and minor breakdowns, leaving less time for productive operation.
Under ideal conditions, the line is capable of producing 200 components per hour, but during the month, the average operating rate dropped to about 150 components per hour.
By the end of July, the plant had assembled 45,000 units, out of which roughly 2,250 failed to pass the final quality inspection.
The management then evaluates how efficiently the assembly line was utilized by estimating its Overall Equipment Effectiveness (OEE) — an integrated measure of availability, performance, and quality.
The international benchmarks are then Interpreted based on the OEE value using the following categorization
● World Class → ≥ 85%
● Industry Average → 60–85%
● Below Average → 40–60%
● Underperforming → < 40%
Based on the above data, answer the given subquestions.

Which category does ProMech Components Ltd. fall into?

During the month of July, the operations team at ProMech Components Ltd., a manufacturer of automotive assemblies, observed that the total output from their main assembly line had declined compared to previous months.
Although the production schedule remained unchanged, managers suspected that frequent stoppages and slower production rates might be affecting efficiency.
A review of the production records revealed that the line had been scheduled to operate for 400 hours in July.
However, around 80 hours were lost due to setup adjustments, maintenance delays, and minor breakdowns, leaving less time for productive operation.
Under ideal conditions, the line is capable of producing 200 components per hour, but during the month, the average operating rate dropped to about 150 components per hour.
By the end of July, the plant had assembled 45,000 units, out of which roughly 2,250 failed to pass the final quality inspection.
The management then evaluates how efficiently the assembly line was utilized by estimating its Overall Equipment Effectiveness (OEE) — an integrated measure of availability, performance, and quality.
The international benchmarks are then Interpreted based on the OEE value using the following categorization
● World Class → ≥ 85%
● Industry Average → 60–85%
● Below Average → 40–60%
● Underperforming → < 40%
Based on the above data, answer the given subquestions.

If the time lost was reduced by 50%, which category does ProMech Components Ltd. fall into?

During the month of July, the operations team at ProMech Components Ltd., a manufacturer of automotive assemblies, observed that the total output from their main assembly line had declined compared to previous months.
Although the production schedule remained unchanged, managers suspected that frequent stoppages and slower production rates might be affecting efficiency.
A review of the production records revealed that the line had been scheduled to operate for 400 hours in July.
However, around 80 hours were lost due to setup adjustments, maintenance delays, and minor breakdowns, leaving less time for productive operation.
Under ideal conditions, the line is capable of producing 200 components per hour, but during the month, the average operating rate dropped to about 150 components per hour.
By the end of July, the plant had assembled 45,000 units, out of which roughly 2,250 failed to pass the final quality inspection.
The management then evaluates how efficiently the assembly line was utilized by estimating its Overall Equipment Effectiveness (OEE) — an integrated measure of availability, performance, and quality.
The international benchmarks are then Interpreted based on the OEE value using the following categorization
● World Class → ≥ 85%
● Industry Average → 60–85%
● Below Average → 40–60%
● Underperforming → < 40%
Based on the above data, answer the given subquestions.

If they could make 20 more components per hour, what would have been the OEE?
(ignore the case of other sub-question)

Which chart type best shows the relationship between advertising spend and sales across 10 branches?

An analyst builds a Pivot Table to summarize quarterly sales by region.
After adding new March data to the source sheet, totals in the Pivot remain unchanged. Why?

Conside the following and select the correct option.
Assertion (A): Line charts are used to visualize trends over time.
Reason (R): They effectively display relationships between categorical variables.

In the circular flow model, when households increase savings with financial institutions, which immediate effect is most likely?

A data analyst uses CMIE’s Consumer Pyramids Household Survey to track shifts in average household electricity spending every quarter.
What kind of data is being used here?

What can be inferred about the relationship between income and the demand for goods with fixed prices? [Select all that apply]