Least-squares regression method Using the data in E4-2 and spreadsheet software, determ...

Least-squares regression method

Using the data in E4-2 and spreadsheet software, determine:

1. The variable cost per unit, the total fixed cost, and R2.

2. The plotted data points using the graphing function.

3. Compare the results to your solutions in E4-2 and E4-3.

Reference: E4-3

Scattergraph method

Using the data in E4-2 and a piece of graph paper:

1. Plot the data points on the graph and draw a line by visual inspection, indicating the trend shown by the data points.

2. Determine the variable cost per unit and the total fixed cost from the information on the graph.

Reference: E4-2

High-low method

Tucson Tractor Inc. has accumulated the following data over a six-month period:

Separate the indirect labor into its fixed and variable components, using the high-low method.