Cornerstones of Managerial Accounting 4th Edition by Maryanne Mowen, Don Hansen, Dan Heitger

Exercise 51

(Appendix 3A) Method of Least Squares Using Computer Spreadsheet Program
The controller for Beckham Company believes that the number of direct labor hours is associated with overhead cost. He collected the following data on the number of direct labor hours and associated factory overhead cost for the months of January through August.
Required:
1. Using a computer spreadsheet program such as Excel, run a regression on these data. Print out your results.
2. Using your results from Requirement 1, write the cost formula for overhead cost. ( Note : Round the fixed cost to the nearest dollar and the variable rate to the nearest cent.)
3. CONCEPTUAL CONNECTION What is R 2 based on your results Do you think that the number of direct labor hours is a good predictor of factory overhead cost
4. Assuming that expected September direct labor hours are 700, what is expected factory overhead cost using the cost formula in Requirement 2