Shafer Company has gathered data on its overhead activities and associated costs for the past 10 months. Theodore, a member of the controller’s department, has convinced management that overhead costs can be better estimated and controlled if the fixed and variable components of each overhead activity are known. One such activity is receiving raw materials (unloading incoming goods, counting goods, and inspecting goods), which she believes is driven by the number of receiving orders. Ten months of data have been gathered for the receiving activity and are as follows:

Now suppose that Theodore has gathered 2 more months of data:

Required:

1. Run two regressions using a computer spreadsheet program such as Excel. First, use the method of least squares on the first 10 months of data. Then, use the method of least squares on all 2 months of data. Write down the results for the intercept, slope, and R2 for each regression. Compare the results.

2. Prepare a scattergraph using all 12 months of data. Do any points appear to be outliers? Suppose Theodore has learned that the factory suffered severe storm damage during Month 11 that required extensive repairs to the receiving area—including major repairs on a forklift. These expenses, included in Month 11 receiving costs, are not expected to recur. What step might Theodore, using his judgment, take to amend the results from the method of least squares?

3. Rerun the method of least squares, using all the data except for Month 11. (You should now have 11 months of data.) Prepare a cost formula for receiving based on these results, and calculate the predicted receiving cost for a month with 1,450 receiving orders. Discuss the results from this regression versus those from the regression for 12 months of data.

Transcribed Image Text:

Month 12 2 3 4 5 6 7 8 9 10 Receiving Orders 1,000 700 1,500 1,200 1,300 1,100 1,600 1,400 1,700 900 Receiving Cost $18,000 15,000 28,000 17,000 25,000 21,000 29,000 24,000 27,000 16,000