Kristoff Ltd.has accumulated the following data for the year regarding its factory overhead costs:
a.Using the least squares regression method and Microsoft Excel,determine the variable and fixed cost elements (SLOPE and INTERCEPT)and the RSQ.
b.What does the RSQ mean in this case.
c.Use the results to prepare a flexible budget at volumes of 2,800;3,000 and 3,200 units.Round to the nearest dollar.

Question

Kristoff Ltd.has accumulated the following data for the year regarding its factory overhead costs:  
a.Using the least squares regression method and Microsoft Excel,determine the variable and fixed cost elements (SLOPE and INTERCEPT)and the RSQ.
b.What does the RSQ mean in this case.
c.Use the results to prepare a flexible budget at volumes of 2,800;3,000 and 3,200 units.Round to the nearest dollar.

Quizplus · Accepted Answer

The Answer of Kristoff Ltd.has accumulated the following data for the year regarding its factory overhead costs:  
a.Using the least squares regression method and Microsoft Excel,determine the variable and fixed cost elements (SLOPE and INTERCEPT)and the RSQ.
b.What does the RSQ mean in this case.
c.Use the results to prepare a flexible budget at volumes of 2,800;3,000 and 3,200 units.Round to the nearest dollar.