I need the answer for questions 2

1. (5 points) Linetti Products has presented the following information for the past eight months operations: Month Units Total Cost April 8,000 $27,400 May 6,400 $25,800 June 3,800 $18,300 July 5,600 $23,200 August 7,000 $26,000 September 8,400 $29,800 October 7,800 $26,500 November 6.800 $25,700 a. Using the high-low method, calculate the fixed cost per month and variable cost per unit. = ($29800-$18300)/(8400-3800) = 2.5 Variable cost per unit =2.5 =($29800-(2.5x8400) Fixed cost=8800 b. What would total costs be for a month with 6,000 units produced? (6000x2.5)+8800 23800 2. Using the Linetti Products data from Problem 1 above, perform a least-squares regression analysis on the data (use Excel to perform the analysis and attach your results). a. What is Silver's total fixed cost? b. What is Silver's variable cost per unit? c. What would total costs be for a month with 8,250 units produced? d. What proportion of variation in Silver's cost is explained by a variance in production