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 fixed component of inspection cost per month 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 fixed component of inspection cost per month is closest to:

Quizplus · Accepted Answer

Using Microsoft Excel functions, the solution is:
Fixed cost per month = Intercept = $9,587