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 January February Units of Activity (hundreds of pounds of equipment loaded or unloaded) 1,400 Material Handling 1, 200 March 1, 100 April 2,600 May 1,800 June 2,000 July 2,400 Department Costs $11, 350 11, 350 11,050 12, 120 11,400 12,000 12, 550 August 2,200 11, 100 September 1,000 October 1,300 10, 200 11,250 November 1,600 December 1,800 11, 300 11, 700 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.) Fixed-cost component Variable-cost component