CPA Quiz: Analyze Data Sets To Support Decisions
20 questions · exam conditions
0:00
Analyze Data Sets To Support DecisionsQuestion 1 of 20

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?

$6,500
$4,500
$13,500
$22,500
← Back to quizzes

CPA Quiz

CPA Quiz: Analyze Data Sets To Support Decisions

Practice Analyze Data Sets To Support Decisions in CPA with focused quiz questions that help you check what you know, review explanations, and build confidence with test-style prompts.

What this quiz covers

This quiz focuses on Analyze Data Sets To Support Decisions, giving you a quick way to practice the rules, question types, and explanations that matter most for CPA.

How to use this quiz

Try each quiz question before looking at the correct answer. Use the explanations to review missed ideas, then come back to similar questions until the pattern feels familiar.

All questions

Question 1

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?

  1. $6,500 (correct answer)
  2. $4,500
  3. $13,500
  4. $22,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.

Question 2

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?

  1. Making costs $18 per unit; buying costs $19 per unit - making is less expensive by $1 per unit (correct answer)
  2. Making costs $19 per unit; buying costs $19 per unit - the options are equivalent
  3. Making costs $23 per unit; buying costs $19 per unit - buying is less expensive by $4 per unit
  4. The fixed overhead must be included, making the total make cost $23 per unit versus $19 per unit to buy
Explanation: Only avoidable (relevant) costs are included in the make-or-buy decision. The allocated fixed overhead of 50,000isnotavoidableandisexcluded.Relevantmakecost=(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.

Question 3

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?

  1. Center 4 only, because it is the furthest below target
  2. Centers 1, 2, and 4, because Center 3 is the only high performer
  3. All four centers, because none has achieved 100% on-time delivery
  4. Centers 2 and 4, because both fall below the 90% target (correct answer)
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.

Question 4

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?

  1. Permanently increase quality inspection staffing because defect rates are unpredictable
  2. Remove weeks 14-17 from the annual defect rate calculation to present a more accurate picture
  3. Identify what changed in production inputs, processes, or personnel during weeks 14-17 to isolate the root cause (correct answer)
  4. 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.

Question 5

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?

  1. Whether the revenue data is reported on a cash basis or an accrual basis
  2. Whether all departments use the same method for recognizing revenue
  3. Whether the correlation coefficient between headcount and revenue exceeds 0.80
  4. Whether higher revenue is driving the need for more employees or more employees are driving revenue growth (correct answer)
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.

Question 6

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?

  1. Inventory purchasing costs have decreased each year
  2. Inventory is turning over more slowly, suggesting a buildup of stock relative to cost of goods sold (correct answer)
  3. The company is improving its supply chain efficiency over time
  4. Cost of goods sold has increased each year relative to average inventory
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.

Question 7

A company's dashboard shows: revenue growth 12% (above target), customer satisfaction 74/100 (below target of 85), employee turnover 22% (above target of 15%), and inventory days on hand 45 (above target of 35). Which of the following represents the most balanced assessment?

  1. Performance is strong because the most important metric, revenue growth, exceeds its target
  2. Performance is poor because three of four metrics are below target
  3. Revenue growth may be masking operational problems in customer experience, workforce stability, and inventory management (correct answer)
  4. The dashboard should be reconfigured to remove metrics that consistently underperform
Explanation: The dashboard tells a nuanced story: strong top-line growth accompanies weak customer satisfaction, high employee turnover, and elevated inventory days. These operational metrics often serve as leading indicators - deteriorating customer satisfaction and high turnover can erode future revenue even when current growth looks strong. A balanced assessment recognizes that the favorable revenue metric may be obscuring systemic operational concerns. Option A assigns priority to revenue without acknowledging the lagging nature of that metric. Option B is overly negative given that three of four metrics have meaningful targets, but the revenue outperformance is material. Option D is counterproductive; removing underperforming metrics from dashboards hides rather than resolves problems.

Question 8

Two capital projects each have an NPV calculated at a 10% discount rate: Project A NPV $85,000 and Project B NPV $62,000. Before recommending Project A, which additional data point is most important to review?

  1. The accounting rate of return for each project, which provides a simpler comparison metric
  2. Whether the NPV calculations used the same tax rate assumptions
  3. The payback period, because NPV does not account for the time required to recover the initial investment
  4. The initial investment required for each project, since a higher NPV may require a disproportionately larger investment (correct answer)
Explanation: NPV measures absolute dollar value created, not return on investment. Project A's higher NPV might require, for example, $1,000,000 of initial investment (NPV/Investment = 8.5%) while Project B requires $200,000 (NPV/Investment = 31%). In that case, Project B creates far more value per dollar invested. The profitability index (NPV / Initial investment) reconciles this comparison. Option A substitutes a less theoretically sound metric without addressing the scale issue. Option B addresses consistency of assumptions, which is important but secondary to the scale question when comparing projects. Option C mischaracterizes NPV; while NPV does not display payback explicitly, the time value of cash flows is already embedded in the discounting process.

Question 9

In data analytics, a heat map visualization is most useful for which of the following purposes?

  1. Displaying the intensity or concentration of values across two dimensions simultaneously (correct answer)
  2. Showing changes in a single variable over a continuous time period
  3. Comparing the proportional composition of a whole across multiple categories
  4. Illustrating the statistical distribution of a continuous variable around its mean
Explanation: A heat map uses color gradients to represent the magnitude or density of values at intersections of two dimensions - for example, sales performance by region and product category, or risk levels by likelihood and impact. Option B describes a line chart or time series plot. Option C describes a pie chart or stacked bar chart. Option D describes a histogram or bell curve visualization.

Question 10

A company's monthly expense report shows (in thousands): Salaries $320, Rent $45, Utilities $18, Marketing $52, Travel $29, Other $14. Total expenses are $478 thousand. What percentage of total expenses do Salaries represent?

  1. 57.2%
  2. 66.9% (correct answer)
  3. 72.4%
  4. 63.5%
Explanation: Salary percentage = $320 / $478 = 66.9%. Option A results from dividing $320 by an incorrect total. Option C overstates the percentage using an understated denominator. Option D applies an incorrect denominator derived from summing only selected line items.

Question 11

A pricing model shows that a 5% price increase would reduce unit volume by 8% based on historical elasticity data. Which of the following conclusions is best supported by this analysis?

  1. The price increase should be implemented because higher unit prices always improve profitability
  2. The price increase should not be implemented because any decline in volume is unacceptable
  3. The price increase would likely reduce total revenue, and its net effect on profitability depends on whether the per-unit margin gain offsets the contribution lost from lower volume (correct answer)
  4. The model is inconclusive because historical elasticity data may not predict future consumer behavior
Explanation: Net revenue effect = 1.05 x 0.92 - 1 = approximately -3.4%, meaning total revenue would likely decline. However, profitability is not determined by revenue alone - if variable costs are a large portion of unit cost, each unit sold at a higher price may generate enough additional contribution margin to offset the lost volume. The correct conclusion is that the data supports a probable revenue decline, and further analysis of the margin structure is needed. Option A ignores the volume loss entirely. Option B is overly rigid and does not consider whether the margin improvement on remaining units compensates. Option D is a valid caveat but does not constitute a conclusion supported by the data.

Question 12

A company's sales channel mix has shifted over three years: direct sales from 55% to 45%, distributor from 37% to 35%, and online from 8% to 20% of total sales. Which of the following is the most analytically appropriate observation?

  1. The company should eliminate the direct sales channel because it is declining in share
  2. The distributor channel is most stable and should receive the most incremental investment
  3. The online growth is unsustainable and will likely reverse in the near term
  4. The structural shift toward online warrants a review of cost structure and margin by channel to understand the profitability implications (correct answer)
Explanation: A consistent three-year shift in channel mix from direct to online is a structural change, not a short-term fluctuation. Different channels carry different cost structures - direct sales involve headcount and travel costs, while online may involve lower variable costs but higher technology and fulfillment investments. Understanding margin by channel is essential before determining whether the shift is favorable or unfavorable for profitability. Option A is premature; declining share does not mean a channel is unprofitable or should be eliminated. Option B prioritizes stability without evidence that the distributor channel is the highest-margin or most strategically valuable. Option C makes a predictive claim without supporting data.

Question 13

An analyst reviewing 24 months of sales data finds that values consistently range from $180,000 to $220,000, except for one month that shows $480,000. What is the most appropriate first step?

  1. Include the $480,000 figure in all trend analyses because all reported data points are valid
  2. Investigate the $480,000 month to determine whether it represents a data error or a genuine business event (correct answer)
  3. Remove the $480,000 month from all analyses because it distorts the trend line
  4. Replace the mean with the median to reduce the statistical influence of the outlier
Explanation: An outlier that falls far outside the range of all other observations requires investigation before any analytical decision is made about it. It could represent a data entry error, a system glitch, or a genuine business event such as a large one-time contract. The appropriate action is to verify the source before including or excluding it. Option A accepts the figure without verification. Option C removes it without understanding its cause, which could discard valid information. Option D is a defensive measure that does not address the underlying question of whether the data point is accurate.

Question 14

A pivot table summarizes sales by region: North - Electronics $420,000, Apparel $185,000, Home Goods $310,000; South - Electronics $380,000, Apparel $240,000, Home Goods $195,000. Which product category has the largest absolute variance between the two regions?

  1. Electronics, with a $40,000 regional difference
  2. Home Goods, with a $115,000 regional difference (correct answer)
  3. Apparel, with a $55,000 regional difference
  4. Electronics and Apparel are tied for the largest regional variance
Explanation: Regional differences: Electronics = $420,000 - $380,000 = $40,000; Apparel = $240,000 - $185,000 = $55,000; Home Goods = $310,000 - $195,000 = $115,000. Home Goods has the largest absolute variance between regions at 115,000.OptionAunderstatestheElectronicsdifferenceandignoresthelargervariances.OptionCidentifiesApparelcorrectlyassecondbutmissesthelargerHomeGoodsvariance.OptionDisincorrectbecauseElectronics(115,000. Option A understates the Electronics difference and ignores the larger variances. Option C identifies Apparel correctly as second but misses the larger Home Goods variance. Option D is incorrect because Electronics (40,000) is not tied with Apparel ($55,000).

Question 15

A company's quarterly sales for five consecutive quarters are $400,000, $420,000, $440,000, $460,000, and $480,000. Using the linear trend in this data, what is the estimated sales figure for Quarter 6?

  1. $488,000
  2. $492,000
  3. $500,000 (correct answer)
  4. $510,000
Explanation: The data shows a constant increase of $20,000 per quarter. Extending the trend: Quarter 6 = $480,000 + $20,000 = $500,000. Option A applies an incorrect incremental amount. Option B applies a declining increment rather than the consistent $20,000 pattern. Option D overstates the trend by applying a larger increment than the data supports.

Question 16

A company analyzes customer profitability. Customer A: revenue $120,000, direct costs $85,000, customer-specific overhead $20,000. Customer B: revenue $90,000, direct costs $55,000, customer-specific overhead $12,000. Which customer is more profitable on a direct contribution basis?

  1. Customer A, with a direct contribution of $35,000
  2. Customer B, with a direct contribution of $23,000 (correct answer)
  3. Customer A, with a direct contribution of $15,000
  4. Customer B, with a direct contribution of $35,000
Explanation: Direct contribution = Revenue - Direct costs - Customer-specific overhead. Customer A: $120,000 - $85,000 - $20,000 = $15,000. Customer B: $90,000 - $55,000 - $12,000 = $23,000. Customer B is more profitable despite lower revenue. Option A uses only revenue minus direct costs for Customer A, omitting the customer-specific overhead. Option C correctly calculates Customer A's contribution but does not identify which is more profitable. Option D applies the incorrect contribution amount to Customer B.

Question 17

A CFO asks an analyst to recommend which of three product lines should receive additional investment. Product Line X has a 22% operating margin, Y has a 15% operating margin, and Z has a 30% operating margin. The analyst immediately recommends Product Line Z. What is the most significant flaw in this recommendation?

  1. Operating margin alone does not capture growth potential, capital requirements, or strategic fit, all of which are relevant to an investment decision (correct answer)
  2. Product Line Y should have been eliminated from consideration before comparing X and Z
  3. The recommendation is valid because a higher operating margin always signals a better investment opportunity
  4. The analyst should have used gross margin rather than operating margin as the comparison metric
Explanation: A single financial ratio like operating margin is an incomplete basis for an investment recommendation. A product line with a 30% margin may be in a mature market with limited growth, require substantial capital investment to scale, or conflict with the company's strategic direction. Option B is incorrect; all three candidates should be evaluated rather than discarded. Option C is incorrect; higher margins do not always translate to better investments - context and capital requirements matter. Option D is a matter of analytical approach preference and does not address the fundamental inadequacy of relying on one metric.

Question 18

An analyst observes that ice cream sales and drowning incidents both increase during summer months and concludes that ice cream sales cause drowning incidents. Which of the following best identifies the flaw in this reasoning?

  1. The dataset covers too short a time period to support a conclusion about seasonal patterns
  2. Drowning incidents should be analyzed using a different statistical method than sales data
  3. Both variables are driven by a common third factor - hot weather - so correlation between them does not establish causation (correct answer)
  4. The analyst should extend the study period before drawing any conclusions about the relationship
Explanation: This is a textbook example of a spurious correlation caused by a confounding variable. Both ice cream sales and drowning incidents rise in summer because of hot weather and increased outdoor activity - not because one causes the other. Correlation identifies a statistical relationship but does not identify direction or cause. Option A and D suggest the issue is data quantity rather than logical reasoning. Option B is a procedural suggestion that does not identify the causal reasoning flaw.

Question 19

A product line reports a net loss of $25,000 after absorbing $60,000 of allocated corporate overhead and $15,000 of traceable fixed costs. The traceable fixed costs would be eliminated if the line is dropped; the corporate overhead would be reallocated. What does this data indicate about the discontinuation decision?

  1. The product line should be discontinued because it reports a net loss of $25,000
  2. The product line should be discontinued because its traceable fixed costs exceed its avoidable savings
  3. The product line should be retained because its contribution margin exceeds the avoidable fixed costs (correct answer)
  4. The product line should be retained only if the corporate overhead allocation can be renegotiated
Explanation: Using the reported net loss: Net loss = Contribution margin - Traceable fixed - Allocated corporate overhead. So Contribution margin = -$25,000 + $15,000 + $60,000 = $50,000. If the line is dropped, the company loses $50,000 of contribution margin but saves only $15,000 of traceable fixed costs - a net loss of $35,000 from dropping the line. The $60,000 of corporate overhead would simply be reallocated and is not saved. Option A relies on net loss, which includes unavoidable allocated overhead - an irrelevant cost for this decision. Option B misstates the relationship between traceable costs and contribution. Option D conditions the decision on an overhead renegotiation that is not relevant to the avoidable cost analysis.

Question 20

A company reports revenue growth of 18% but cash flow from operations declined 12% over the same period. Which of the following best explains how these two metrics can diverge and what decision-relevant information they provide together?

  1. Cash flow from operations is less reliable than revenue as an indicator of financial health and should be weighted accordingly
  2. The 18% revenue growth confirms the business is fundamentally healthy and the cash flow decline is a temporary anomaly
  3. Revenue growth without corresponding operating cash flow growth may indicate rising receivables, inventory buildup, or accelerated revenue recognition - each of which signals a different operational or financial risk (correct answer)
  4. The company should revise its revenue recognition policies downward to bring recognized revenue in line with cash collected
Explanation: Revenue and operating cash flow can diverge for several reasons, each with distinct implications: growing receivables (customers are not paying promptly), inventory buildup (cash is tied up in unsold goods), or aggressive revenue recognition (revenue is recorded before cash is earned or collectible). Analyzing this divergence is essential because it shapes different corrective actions - collections management, inventory controls, or revenue recognition review. Option A incorrectly subordinates cash flow; operating cash flow is widely considered a key indicator of business quality because it is harder to manipulate than revenue. Option B dismisses the cash flow decline without investigation. Option D prescribes a policy change without first understanding why the divergence exists.