Refer to the data in the preceding problem for Nantucket Marine Supply.
In the preceding problem, Nantucket Marine Supply is a wholesaler for a large variety of boating and fishing equipment. The company’s controller, Alan Denney, has recently completed a cost study of the firm’s material-handling department. The activity measure (independent variable) used in the study was hundreds of pounds of equipment loaded or unloaded at the company’s loading dock. Denney compiled the following data.

1. Construct an Excel spreadsheet and use the Excel commands to perform a least-squares regression. Estimate of the variable- and fixed-cost components in the company’s material-handling department costs.
2. Write the least-squares regression equation for the department’s costs.
3. Predict the firm’s material-handling department’s costs for a month when 2,250 units of activity are recorded.
4. Why do the three cost predictions computed in this and the preceding problem differ? Which method do you recommend? Why?
5. Use your Excel spreadsheet from requirement (1) to compute the R2 value for the regression. Interpret the R2value.

  • CreatedApril 22, 2014
  • Files Included
Post your question