Refer to the Farnsworth Company information in Problem 3-27 for the first I0 months of data on receiving orders and receiving cost. Now suppose that Tracy has gathered two more months of data:

For the following requirements, round the intercept terms to the nearest dollar and round the variable rates to the nearest cent.

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 12 months of data. Record 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 Tracy has learned that the factory suffered severe storm damage during month II that required extensive repairs to the receiving area- including major repairs on a forklift. These expenses, included in month II receiving costs, are not expected to recur. What step might Tracy, using her 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 II. (You should now have II 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.

Problem 3-27

Transcribed Image Text:

Month Receiving Orders Receiving Cost 11 12 1,200 950 $28,000 17,500