Analyze Data Sets To Support Decisions

Help Questions

CPA Business Analysis and Reporting (BAR) › Analyze Data Sets To Support Decisions

Questions 1 - 10
1

Which of the following best describes structured data?

Data that is partially organized and requires transformation before it can be analyzed

Data organized in a predefined format, typically stored in rows and columns such as a relational database

Data that has no predefined format, including items such as emails, social media posts, and images

Data collected from external sources that has been validated for accuracy and completeness

Explanation

Structured data is organized according to a predefined schema - typically rows and columns in a relational database or spreadsheet - making it immediately accessible to standard query tools and analysis. Option B describes unstructured data, which lacks a predefined format. Option C describes semi-structured data, which has some organizational properties but requires further transformation. Option D describes data validation status, not a data type classification.

2

A cost analyst's regression output for utility costs shows an intercept of $5,200, a slope of $3.80, and an R-squared of 0.87. What is the estimated utility cost at 2,000 machine hours?

$7,600

$15,200

$10,600

$12,800

Explanation

Estimated cost = Intercept + (Slope x Activity) = $5,200 + ($3.80 x 2,000) = $5,200 + $7,600 = $12,800. Option A multiplies the slope by an incorrect base and omits the intercept properly. Option B adds the intercept and the product of slope times 1,000 rather than 2,000. Option C represents only the variable component ($3.80 x 2,000) without adding the fixed intercept.

3

A manufacturer with sufficient idle capacity receives a special order for 500 units at $45 per unit. The normal selling price is $60. Variable costs are $32 per unit and allocated fixed costs are $18 per unit based on normal volume. What is the incremental contribution from accepting the special order?

$13,500

$22,500

$6,500

$4,500

Explanation

For a special order with idle capacity, only variable costs are relevant. Contribution = (Special order price - Variable cost) x Units = ($45 - $32) x 500 = $13 x 500 = $6,500. Fixed costs are irrelevant because they will be incurred regardless of whether the order is accepted. Option B uses the normal price to compute contribution rather than the special order price. Option C multiplies the full price by units, omitting variable costs. Option D multiplies the normal selling price by units without deducting any costs.

4

A retailer's dashboard shows average transaction value increased 15% year-over-year while total transaction volume declined 8%. Which of the following actions is most directly supported by this data?

Increase marketing spend to address declining volume, which indicates insufficient brand awareness

Launch a loyalty program to reward existing customers for their higher per-transaction spend

Reduce prices to restore transaction volume, since total revenue has likely declined

Investigate whether a pricing change, product mix shift, or customer segment change is driving the value increase before modifying strategy

Explanation

The data presents two diverging signals without explaining their cause. A higher average transaction value could result from deliberate price increases, a shift toward premium products, or a loss of lower-value customers. Each explanation implies a different strategic response. Investigating the root cause first prevents committing to a strategy based on an incorrect interpretation. Option A assumes revenue declined, which is not certain (15% x 0.92 = approximately 6% net increase). Option B assumes brand awareness is the cause of volume decline without evidence. Option C assumes the existing customers are the source of value growth, which requires verification.

5

A make-or-buy analysis for 10,000 units shows internal costs of: direct materials $80,000, direct labor $60,000, variable overhead $40,000, and allocated fixed overhead $50,000 (none avoidable if outsourced). An outside supplier offers $19 per unit. What is the relevant cost comparison on a per-unit basis?

The fixed overhead must be included, making the total make cost $23 per unit versus $19 per unit to buy

Making costs $19 per unit; buying costs $19 per unit - the options are equivalent

Making costs $18 per unit; buying costs $19 per unit - making is less expensive by $1 per unit

Making costs $23 per unit; buying costs $19 per unit - buying is less expensive by $4 per unit

Explanation

Only avoidable (relevant) costs are included in the make-or-buy decision. The allocated fixed overhead of $50,000 is not avoidable and is excluded. Relevant make cost = ($80,000 + $60,000 + $40,000) / 10,000 = $180,000 / 10,000 = $18 per unit. The buy price is $19 per unit. Making is $1 per unit less expensive. Option B incorrectly equates the two. Option C includes the unavoidable fixed overhead in the make cost. Option D also incorrectly includes unavoidable fixed overhead and reaches the wrong conclusion.

6

A company tracks on-time delivery rates across four distribution centers: Center 1 at 94%, Center 2 at 88%, Center 3 at 97%, and Center 4 at 82%. The company target is 90%. Which centers require corrective action based on this data?

Centers 2 and 4, because both fall below the 90% target

Center 4 only, because it is the furthest below target

Centers 1, 2, and 4, because Center 3 is the only high performer

All four centers, because none has achieved 100% on-time delivery

Explanation

The stated performance threshold is 90%. Centers 2 (88%) and 4 (82%) are both below this target and require corrective action. Centers 1 (94%) and 3 (97%) exceed the target and do not require corrective action based on this metric. Option A identifies only the worst performer, ignoring Center 2 which also misses the target. Option B incorrectly includes Center 1, which exceeds the 90% target. Option C applies a standard of 100% that was not established as the target.

7

An accounts receivable aging report shows: 0-30 days $240,000, 31-60 days $85,000, 61-90 days $42,000, over 90 days $28,000. Which of the following is the most actionable insight from this data?

The 0-30 day balance is excessive and indicates the company is extending credit too liberally

The over-90-days balance of $28,000 requires immediate collection follow-up as it represents the highest credit risk in the aging schedule

The aging distribution is healthy because the majority of AR is in the current 0-30 day bucket

The company should write off all balances over 60 days to reduce its bad debt exposure

Explanation

The over-90-days bucket represents the highest-risk receivables - balances that have remained uncollected well beyond normal payment terms. These accounts are at the greatest risk of becoming uncollectible and merit immediate collection action or escalation. Option B incorrectly interprets a large current balance as a problem; having most receivables in the 0-30 day bucket is typical and healthy. Option C is partially correct but is passive - a healthy current balance does not eliminate the need to act on the high-risk aging buckets. Option D is inappropriate without first attempting collection; writing off collectible balances reduces assets unnecessarily.

8

A company's quality data shows a spike in product defect rates during weeks 14 through 17 of the production calendar, followed by a return to normal levels in week 18. Which investigation step is most appropriate?

Permanently increase quality inspection staffing because defect rates are unpredictable

Remove weeks 14-17 from the annual defect rate calculation to present a more accurate picture

Identify what changed in production inputs, processes, or personnel during weeks 14-17 to isolate the root cause

Conclude the spike was random variation and take no further action since rates normalized in week 18

Explanation

A localized, time-bounded spike in defect rates strongly suggests a specific, identifiable cause - a change in raw material supplier, equipment malfunction, new operator, or process deviation - rather than random variation. Root cause analysis during the affected weeks is the most productive response. Option A is an overreaction that does not address the cause and adds unnecessary cost. Option B removes data from the record, reducing accountability and eliminating information that could improve future quality. Option D treats the spike as random, but the pattern (four weeks of elevated rates followed by return to normal) is more consistent with a discrete cause than with random variation.

9

An analyst observes that departments with more employees tend to generate higher revenue and recommends increasing headcount to boost revenue. Which consideration is most important before acting on this recommendation?

Whether the correlation coefficient between headcount and revenue exceeds 0.80

Whether higher revenue is driving the need for more employees or more employees are driving revenue growth

Whether all departments use the same method for recognizing revenue

Whether the revenue data is reported on a cash basis or an accrual basis

Explanation

Before recommending an action based on a correlation, the direction of causality must be established. It is plausible that more revenue creates more demand for staff, rather than more staff creating revenue. Acting on the wrong causal direction could lead to hiring more employees for revenue-support roles without generating additional sales. Options A and B address revenue measurement consistency, which affects comparability but not the core causal question. Option C focuses on the strength of correlation, but even a strong correlation does not establish which variable is the cause.

10

A company's inventory turnover ratios over four consecutive years are: Year 1: 6.2x, Year 2: 5.8x, Year 3: 5.3x, Year 4: 4.9x. What does this declining trend most directly indicate?

Cost of goods sold has increased each year relative to average inventory

Inventory purchasing costs have decreased each year

The company is improving its supply chain efficiency over time

Inventory is turning over more slowly, suggesting a buildup of stock relative to cost of goods sold

Explanation

Inventory turnover = COGS / Average inventory. A declining ratio means inventory is selling more slowly relative to COGS - inventory levels are rising faster than sales, or sales are declining relative to inventory held. This signals a potential buildup of slow-moving or excess stock. Option A is incorrect; purchasing costs affect COGS and margins, not directly the turnover ratio. Option C is incorrect; improving supply chain efficiency would increase the turnover ratio, not decrease it. Option D describes the opposite of what a declining ratio indicates - a higher ratio would result if COGS increased relative to inventory.

Page 1 of 3