Lacourse Inc.'s inspection costs are listed below: Management believes that inspection cost is a mixed cost that depends on units produced.
Using the least-squares regression method, the estimate of the variable component of inspection cost per unit produced is closest to:

Question

Lacourse Inc.'s inspection costs are listed below:  Management believes that inspection cost is a mixed cost that depends on units produced.
Using the least-squares regression method, the estimate of the variable component of inspection cost per unit produced is closest to:

Quizplus · Accepted Answer

Using Microsoft Excel functions, the solution is:
Variable cost per unit produced = Slope = $8.82