Fundamentals of Cost Accounting 3rd Edition by William N. Lanen, Shannon W. Anderson, Michael Maher

Exercise 29

Methods of Estimating Costs: Simple Regression

Simple regression results from the data of Adriana Corporation (Exercise 5-26) are as follows:

Equation: Overhead = $206,469 + ($45.83 × Machine-hours) Statistical data
Correlation coefficient	.962
R2	.925

Required

Estimate overhead if the company expects the plant to operate at a monthly average of 9,000 machine-hours next year.

Step 1 of 2

Cost estimation

Cost estimation is an important exercise because it helps managers in decision making. Correct cost estimates result in cost saving and making business successful. Cost estimates helps managers to evaluate and choose the best alternative. It is important for managers to capture the correct cost for each alternative.

There different methods used for cost estimation like engineering, accounting and statistical analysis.

Statistical method

Statistical is more accurate method of cost estimation as compared to engineering and accounting analysis method as they have certain limitations. Under this method, random events are separated from while analyzing relationship between cost and activity. While using statistical method for cost estimation it is important to confirm that past activity levels are related to current estimation.

Simple regression analysis – In simple regression analysis there is only one predictor for the activity and cost is estimated on the basis on one predictor only. For example, overhead cost is estimated on the basis of relationship between total cost and parts used.

Multiple regression analysis – In multiple regression analysis more than one type of predictor is used for the activity and cost is estimated on the basis on multiple predictors. Multiple predictors are used for better and more accurate cost estimation. For example, overhead cost is estimated on the basis of parts used and labor hours used for production purpose. Only parts cost may not provide correct overhead cost estimation, hence labor hours used, must also be included as predictor to calculate overhead cost.