Data for Sandhill Corporation's maintenance costs is shown below. Units Total Cost Produced July 19,635 $38,070...

 

Transcribed Image Text:

Data for Sandhill Corporation's maintenance costs is shown below. Units Total Cost Produced July 19,635 $38,070 August 34,912 52,368 September 39,276 60,005 October 24,002 41,458 November 43,640 81,279 December 41,458 67,642 Compute the variable- and fixed-cost elements using the regression analysis. Present your solution in the form of a cost equation. (We recommend that you use the Intercept and Slope functions in Excel.) (Round intercept to 2 decimal places eg. 1.25 and slope to 5 decimal places e.g. 1.25125.) Intercept Slope The cost equation is: $ + $ per unit produced = Total cost %24 %24 %24 Data for Sandhill Corporation's maintenance costs is shown below. Units Total Cost Produced July 19,635 $38,070 August 34,912 52,368 September 39,276 60,005 October 24,002 41,458 November 43,640 81,279 December 41,458 67,642 Compute the variable- and fixed-cost elements using the regression analysis. Present your solution in the form of a cost equation. (We recommend that you use the Intercept and Slope functions in Excel.) (Round intercept to 2 decimal places eg. 1.25 and slope to 5 decimal places e.g. 1.25125.) Intercept Slope The cost equation is: $ + $ per unit produced = Total cost %24 %24 %24

Answer rating: 100% (QA)

Solution Intercept 417346 Slope 155616 ie X Variable 1 Cost Equation is 417346 155... View the full answer