! Required information Problem 6-42 Continuation of Preceding Problem; Computing Least-Squares Regression Estimates; Comparing Multiple Methods (Appendix) (LO 6-1, 6-2, 6-5, 6-6, 6-9) [The following information applies to the questions displayed below.] Martha's Vineyard Marine Supply is a wholesaler for a large variety of boating and fishing equipment. The company's controller, Mathew Knight, has recently completed a cost study of the firm's material-handling department in which he used work measurement to quantify the department's activity. The control factor unit used in the work-measurement study was hundreds of pounds of equipment unloaded or loaded at the company's loading dock. Knight compiled the following data. Month Units of Activity (hundreds of pounds of equipment loaded or unloaded) Material Handling Department Costs $ 13,300 January 3,400 February 3,200 12,900 March 2,900 12,050 April 2,600 11,800 May 3,800 12,700 June 4,000 14,950 July 3,600 13,600 August 3,400 13,000 September 4,200 14,040 October 2,700 11,850 November 2,800 December 3,000 12,950 12,950 Problem 6-42 Part 1 Required: 1. Construct an Excel spreadsheet and use the Excel commands to perform a least-squares regression. Estimate the variable- and fixed-cost components in the company's material-handling department costs. (Do not round intermediate calculations. Round the Variable-cost component to 2 decimal places and the Fixed-cost component to the nearest whole dollar amount.)