- TechFlow Industries collected quarterly data for equipment maintenance costs over two years: Q1-Y1 (850 hours, $18,500), Q2-Y1 (920 hours, $19,800), Q3-Y1 (780 hours, $17,200), Q4-Y1 (1,050 hours, $22,100), Q1-Y2 (890 hours, $19,200), Q2-Y2 (950 hours, $20,300), Q3-Y2 (810 hours, $17,800), Q4-Y2 (1,080 hours, $22,600). The company wants to use the high-low method but is concerned about seasonal variations. Which quarters should be used as high and low points to minimize seasonal bias?
Answer: Q4-Y1 (high) and Q3-Y2 (low) because they are from different years, reducing seasonal impact
The high-low method requires using the highest and lowest activity levels, which are Q4-Y2 (1,080 hours) and Q3-Y1 (780 hours). However, choice B correctly identifies that using points from different years (Q4-Y1 at 1,050 hours and Q3-Y2 at 810 hours) would reduce seasonal bias while still representing high and low activity levels within a reasonable range. Choice A uses the absolute extremes but ignores seasonal considerations. Choice C abandons the high-low method principle of using extreme points. Choice D incorrectly suggests averaging, which violates the high-low methodology.
- A company's maintenance costs are a mixed cost. The company has compiled the following data for the first four months of the year:
| Month | Machine Hours | Maintenance Cost |
|---|
| January | 7,000 | $23,500 |
| February | 9,500 | $28,000 |
| March | 8,000 | $29,000 |
| April | 6,000 | $21,000 |
Answer: $26,500
The high-low method uses the periods with the highest and lowest activity levels to determine the cost formula.
1. Identify High and Low Activity Points:
* High Activity: February (9,500 hours, $28,000 cost)
* Low Activity: April (6,000 hours, $21,000 cost)
2. Calculate Variable Cost per Hour:
* Change in Cost: $28,000 - $21,000 = $7,000
* Change in Hours: 9,500 - 6,000 = 3,500 hours
* Variable Rate = $7,000/3,500 hours = $2.00 per machine hour
3. Calculate Total Fixed Cost:
Using the high point: $28,000 - (9,500 hours $2.00/hour) = $28,000 - $19,000 = $9,000
Using the low point: $21,000 - (6,000 hours $2.00/hour) = $21,000 - $12,000 = $9,000
4. Estimate Cost for 8,500 Hours:
Total Cost = Fixed Cost + (Variable Rate Activity)
Total Cost = $9,000 + ($2.00 8,500) = $9,000 + $17,000 = $26,500 - A regression analysis reveals a strong correlation (R-squared = 0.95) between a company's sales commissions and the number of lawnmowers sold by a competitor in the same city. Assuming no business relationship exists between the two companies, what is the most logical conclusion?
Answer: The statistical relationship is likely spurious and driven by a common underlying factor, such as seasonality.
This question tests the critical concept of correlation versus causation. A high R-squared indicates a strong statistical correlation, meaning the two variables move together. However, it does not prove that one causes the other. In this case, it is implausible that a competitor's sales would directly cause the company's commission costs. A more logical explanation is a lurking or confounding variable, such as season (e.g., more lawnmowers are sold by everyone in the spring and summer), which is driving both variables in the same direction. This creates a spurious correlation.
- Alpine Manufacturing uses the scattergraph method to analyze utility costs. After plotting 12 months of data (machine hours vs. utility costs), the visual inspection suggests a linear relationship with the line of best fit appearing to intersect the y-axis at approximately $3,200. The line passes through the point (2,000 hours, $8,200). However, when management reviewed the data, they noticed that the March data point (1,800 hours, $12,500) appears to be an outlier due to emergency repairs. What should be the estimated variable cost per machine hour after removing this outlier?
Answer: $2.50 per hour
Using the scattergraph method with visual inspection, the line intersects the y-axis at $3,200 (fixed cost) and passes through (2,000 hours, $8,200). Variable cost per hour = ($8,200 - $3,200) ÷ 2,000 = $5,000 ÷ 2,000 = $2.50. The outlier removal doesn't affect this calculation since we're using the visually fitted line that already excludes outliers. Choice B incorrectly includes the outlier in the calculation. Choice C uses an incorrect fixed cost estimate. Choice D uses the wrong reference point.
- A manufacturing company collected the following data over six months: Month 1 (2,000 units, $15,000 total cost), Month 2 (2,500 units, $17,500 total cost), Month 3 (1,800 units, $14,200 total cost), Month 4 (3,000 units, $20,000 total cost), Month 5 (2,200 units, $16,100 total cost), Month 6 (2,800 units, $19,100 total cost). Using the high-low method, if the company produces 2,400 units next month, what total cost should be expected?
Answer: $17,200
When you encounter cost data at different activity levels, the high-low method helps you separate fixed and variable costs by using the highest and lowest activity points. This technique assumes costs behave linearly within the relevant range.
First, identify the high and low activity levels: Month 4 has the highest production (3,000 units, $20,000) and Month 3 has the lowest (1,800 units, $14,200). Next, calculate the variable cost per unit using the formula: Variable cost per unit=Change in unitsChange in total cost
Variable cost per unit=3,000−1,800$20,000−$14,200=1,200$5,800=$4.83
Now find fixed costs by substituting back into either data point. Using the high point: Fixed costs=$20,000−(3,000×$4.83)=$20,000−$14,500=$5,500
For 2,400 units: Total cost=$5,500+(2,400×$4.83)=$5,500+$11,600=$17,100
The closest answer is D) $17,200, accounting for rounding differences in the variable rate calculation.
Answer A) $16,850 likely uses an incorrect variable rate calculation. Answer B) $17,050 might result from computational errors in the fixed cost determination. Answer C) $16,600 probably stems from using the wrong data points or miscalculating the variable cost per unit.
Remember: Always use the true highest and lowest activity levels, not the highest and lowest costs, as your calculation points in the high-low method. - Precision Tools Inc. wants to separate its maintenance costs into fixed and variable components. The company has narrowed its analysis to two potential cost drivers: machine hours and number of setups. Using least squares regression, machine hours yielded: Fixed cost = $8,500, Variable cost = $12.50 per hour, R² = 0.78. Number of setups yielded: Fixed cost = $6,200, Variable cost = $425 per setup, R² = 0.91. Which approach should the company choose and why?
Answer: Number of setups because it has a higher R² value, indicating better correlation and more reliable predictions
When analyzing cost behavior using regression analysis, the key metric for choosing between cost drivers is the R² value (coefficient of determination). This statistic measures how well your chosen cost driver explains the variation in costs, with values closer to 1.0 indicating stronger predictive power.
In this case, number of setups produces an R² of 0.91, meaning 91% of the variation in maintenance costs can be explained by the number of setups. Machine hours only explains 78% of the cost variation. The higher R² for setups indicates a much stronger correlation and more reliable cost predictions, making option C correct.
Option A incorrectly focuses on the variable cost per unit ($12.50 vs. $425). You cannot directly compare these amounts because they measure different activities - the cost per setup versus cost per machine hour serve different purposes and volumes.
Option B misunderstands the role of fixed costs in regression analysis. Higher fixed costs don't inherently provide "conservative" estimates - accuracy matters more than the absolute level of fixed costs. The $8,500 versus $6,200 difference is irrelevant for choosing the better model.
Option D incorrectly suggests that higher variable costs provide "better cost coverage margins." This confuses cost prediction accuracy with pricing strategy. The goal of cost driver analysis is predictive reliability, not maximizing variable cost rates.
Remember: When comparing regression models for cost accounting, always prioritize the R² value. It's your best indicator of which cost driver will give you the most accurate cost predictions for budgeting and planning purposes.
- A visual-fit line on a scattergraph of total cost versus activity indicates a y-intercept of approximately $10,000 and passes through a data point representing 5,000 units and a total cost of $45,000. Based on this line, what is the estimated variable cost per unit?
Answer: $7.00
The y-intercept of the cost line represents the total fixed cost. The variable cost per unit is the slope of the line.
1. Identify Fixed Cost: The y-intercept is given as $10,000.
2. Use the data point to find the variable cost component:
* Total Cost at 5,000 units = $45,000
* Total Cost = Total Fixed Cost + Total Variable Cost
* $45,000 = $10,000 + Total Variable Cost
* Total Variable Cost = $35,000
3. Calculate Variable Cost per Unit:
* Variable Cost per Unit = Total Variable Cost / Activity Level
* Variable Cost per Unit = $35,000/5,000 units = $7.00 per unit. - A company is analyzing its maintenance costs. An accountant states that within the relevant range of 10,000 to 20,000 machine hours, fixed costs are $40,000 per month. However, if activity exceeds 20,000 hours, fixed costs increase by $15,000. Last month, activity was 18,000 hours and total cost was $94,000. This month, activity is budgeted at 22,000 hours. What is the budgeted maintenance cost for this month?
Answer: $121,000
This problem involves a step-fixed cost, which changes at a certain activity level. The solution requires multiple steps.
1. Determine the Variable Cost Rate: Use the data from last month, as it falls within the initial relevant range.
* Total Cost = $94,000 at 18,000 hours.
* Fixed Cost for this activity level = $40,000.
* Total Variable Cost = Total Cost - Fixed Cost = $94,000 - $40,000 = $54,000.
* Variable Rate = Total Variable Cost / Activity = $54,000/18,000 hours = $3.00 per hour.
2. Determine the Fixed Cost for the Budgeted Month: The budgeted activity is 22,000 hours, which is above the 20,000-hour threshold.
* New Fixed Cost = Base Fixed Cost + Step Increase = $40,000 + $15,000 = $55,000.
3. Calculate the Total Budgeted Cost:
* Total Budgeted Cost = New Fixed Cost + (Variable Rate × Budgeted Activity)
* Total Budgeted Cost = $55,000 + ($3.00 × 22,000 hours) = $55,000 + $66,000 = $121,000. - A regression analysis of manufacturing overhead costs resulted in the following equation: Total Cost = $75,000 + $12.50 * Direct_Labor_Hours. The analysis was based on monthly data ranging from 4,000 to 7,000 direct labor hours. The company is evaluating a special project that would require 9,000 direct labor hours. Which statement best assesses the use of the regression equation to estimate the overhead cost for this project?
Answer: The estimate may be unreliable because the activity level is outside the relevant range of the data.
Cost behavior patterns identified via regression or the high-low method are reliable only within the relevant range—the range of activity over which the cost relationships are expected to hold true. The analysis was based on data between 4,000 and 7,000 hours. The project's 9,000 hours falls outside this range. Extrapolating beyond the relevant range is risky because the underlying cost behavior might change (e.g., fixed costs might increase in a step, or variable costs might change due to capacity constraints or bulk discounts). Therefore, the estimate may be unreliable.
- A service firm wants to determine the cost behavior of its client support costs. The firm has the following information for the last two quarters:
| Quarter | Support Tickets | Total Cost |
|---|
| Q1 | 3,000 | $140,000 |
| Q2 | 5,000 | $190,000 |
Answer: Y = $65,000 + $25.00X
The high-low method is used to separate the fixed and variable components of the mixed cost.
1. Calculate Variable Cost per Ticket (the 'b' coefficient):
* Change in Cost = $190,000 - $140,000 = $50,000
* Change in Tickets = 5,000 - 3,000 = 2,000 tickets
* Variable Rate (b) = $50,000/2,000 tickets = $25.00 per ticket
2. Calculate Total Fixed Cost (the 'a' coefficient):
Using the high point (Q2): Fixed Cost = Total Cost - (Variable Rate Activity)
Fixed Cost = $190,000 - ($25.00 5,000) = $190,000 - $125,000 = $65,000
Using the low point (Q1): Fixed Cost = $140,000 - ($25.00 3,000) = $140,000 - $75,000 = $65,000
3. State the Cost Formula: Y = $65,000 + $25.00X, where X is the number of support tickets. - A manufacturing company provides the following quarterly data on overhead costs and machine hours:
| Quarter | Machine Hours | Overhead Cost |
|---|
| 1 | 25,000 | $150,000 |
| 2 | 35,000 | $180,000 |
| 3 | 40,000 | $215,000 |
| 4 | 20,000 | $130,000 |
Answer: $4.25
To use the high-low method, you must select the periods with the highest and lowest activity levels, not the highest and lowest costs (though they are sometimes the same).
1. Identify High and Low Activity Points:
* High Activity: Quarter 3 (40,000 machine hours, $215,000 cost)
* Low Activity: Quarter 4 (20,000 machine hours, $130,000 cost)
2. Calculate the Variable Cost per Machine Hour:
* Change in Cost = $215,000 - $130,000 = $85,000
* Change in Hours = 40,000 - 20,000 = 20,000 hours
* Variable Rate = Change in Cost / Change in Activity
* Variable Rate = $85,000/20,000 hours = $4.25 per machine hour. - When comparing cost estimation methods, regression analysis is generally considered superior to the high-low method because regression analysis:
Answer: mathematically fits a line to all available data points, not just the extremes.
The primary advantage of regression analysis over the high-low method is its use of all data points in the dataset. By doing so, it provides a line of best fit that is more statistically representative of the overall relationship between cost and activity. The high-low method's major weakness is that it only uses two data points (the highest and lowest activity levels), which may be outliers and not representative of the true cost behavior, potentially skewing the resulting cost formula.
- A company is analyzing its electricity cost. A scattergraph of monthly costs versus machine hours reveals a pattern of points that are widely dispersed and show no discernible upward or downward trend. What is the most likely conclusion about the company's electricity cost?
Answer: Electricity cost is a mixed cost, but machine hours are not the primary cost driver.
A scattergraph is used to visualize the relationship between a cost and a potential activity driver. If the points are widely scattered with no clear trend, it indicates a very weak or nonexistent correlation between the two variables. Since electricity cost is known to have both fixed (e.g., basic connection fee) and variable (e.g., usage charge) components, it is a mixed cost. The lack of a pattern suggests that machine hours are not the primary factor driving the changes in electricity cost; some other activity driver is likely more influential, or the cost is influenced by multiple factors.
- A company's production data for two semi-annual periods are as follows:
* First 6 months: 60,000 units produced, $420,000 total overhead.
* Second 6 months: 75,000 units produced, $495,000 total overhead.
Using the high-low method, what is the estimated total overhead for a future month in which 11,000 units are expected to be produced?
Answer: $75,000
This is a multi-step problem that requires adjusting the time frame for the fixed cost component.
1. Calculate Variable Cost per Unit using the semi-annual data:
* Change in Cost = $495,000 - $420,000 = $75,000
* Change in Units = 75,000 - 60,000 = 15,000 units
* Variable Rate = $75,000/15,000 units = $5.00 per unit
2. Calculate the Semi-Annual Fixed Cost:
Using the high point: $495,000 - (75,000 units $5.00/unit) = $495,000 - $375,000 = $120,000 (for a 6-month period)
3. Convert to Monthly Fixed Cost:
* Monthly Fixed Cost = $120,000/6 months = $20,000 per month
4. Estimate Total Overhead for the Future Month:
Total Cost = Monthly Fixed Cost + (Variable Rate Units for the month)
Total Cost = $20,000 + ($5.00 11,000) = $20,000 + $55,000 = $75,000 - A regression analysis of overhead costs (Y) against machine hours (X) produced the equation Y = $32,000 + $18.00X, with an R-squared value of 0.25. Which of the following is the most appropriate conclusion from this analysis?
Answer: Machine hours are a weak predictor of overhead cost because the R-squared value is low.
The R-squared value, or coefficient of determination, measures the proportion of the variance in the dependent variable (cost) that is predictable from the independent variable (activity). An R-squared of 0.25 means that only 25% of the variation in overhead costs is explained by the variation in machine hours. This is a low value, indicating a weak relationship and that machine hours are a poor predictor of overhead costs. Other factors, not included in the model, are responsible for most of the cost variation.
- Alpha Corp. used the high-low method to analyze its utility costs. The analysis was based on the highest activity of 20,000 machine hours at a total cost of $58,000, and the lowest activity of 12,000 machine hours at a total cost of $46,000. What is the estimated variable portion of the total utility cost in a month with 15,000 machine hours?
Answer: $22,500
The question asks for only the variable portion of the total cost at the new activity level, not the total estimated cost.
1. Calculate Variable Cost per Hour:
* Change in Cost: $58,000 - $46,000 = $12,000
* Change in Hours: 20,000 - 12,000 = 8,000 hours
* Variable Rate = $12,000/8,000 hours = $1.50 per machine hour
2. Calculate the Variable Portion for 15,000 Hours:
Variable Portion = Variable Rate Activity Level
Variable Portion = $1.50 15,000 hours = $22,500
The fixed cost portion is $28,000, and the total estimated cost is $50,500, but the question specifically asks for the variable portion. - When visually fitting a line to a scattergraph of cost data, the estimated fixed cost component is best represented by:
Answer: the point where the fitted line intersects the vertical (cost) axis.
On a scattergraph plotting total cost (on the y-axis) versus activity level (on the x-axis), the cost line follows the formula Y = a + bX. The term 'a', representing total fixed cost, is the y-intercept. The y-intercept is the value of Y when X is zero, which is graphically represented by the point where the line crosses the vertical (Y) axis. The slope of the line represents the variable cost per unit.
- A company's cost accountant developed a regression equation for monthly utility costs: Y = $1,500 + $0.75X, where X is the number of machine hours. The average monthly activity is 10,000 machine hours. Next month, activity is expected to increase by 20%. What is the predicted total utility cost for next month?
Answer: $10,500
This is a two-step problem: first determine the new activity level, then use the cost formula to predict the cost.
1. Calculate the New Activity Level:
* Current average activity = 10,000 hours
Increase = 20% of 10,000 = 0.20 10,000 = 2,000 hours
* New activity level = 10,000 + 2,000 = 12,000 machine hours
2. Predict the Total Utility Cost using the Regression Equation:
Y = $1,500 + $0.75 X
Y = $1,500 + $0.75 (12,000)
* Y = $1,500 + $9,000
* Y = $10,500
- In the cost formula Y = a + bX for a mixed cost, the term 'a' represents:
Answer: the estimated total fixed cost within the relevant range of activity.
In the linear cost equation Y = a + bX, 'Y' is the total mixed cost, 'b' is the variable cost per unit of activity, 'X' is the number of activity units, and 'a' is the total fixed cost. The term 'a' represents the portion of the total cost that does not change with activity. It is the y-intercept of the cost line. This interpretation is valid only within the relevant range, as fixed costs may change outside of this range.
- Which of the following describes a significant weakness of the high-low method for separating mixed costs?
Answer: The cost formula is distorted if the high and low activity points are not representative of the overall data.
The primary weakness of the high-low method is that it relies on only two data points, the highest and lowest activity levels. If either of these points is an outlier (i.e., not typical of the general relationship between cost and activity), the resulting cost formula can be skewed and may not accurately represent the true cost behavior. Regression analysis, by contrast, uses all data points and is less susceptible to distortion by one or two outliers.
