# Question

Louise McDermott, controller for the Galvin plant of Veromar Inc., wanted to determine the cost behavior of moving materials throughout the plant. She accumulated the following data on the number of moves (from 100 to 800 in increments of 100) and the total cost of moving materials at those levels of moves:

Number of Moves Total Cost

100 ............ $ 3,000

200 ............ 4,650

300 ............ 3,400

400 ............ 8,500

500 ............ 10,000

600 ............ 12,600

700 ............ 13,600

800 ............ 14,560

Note: For the following requirements, round the fixed costs to the nearest dollar and round the variable cost to the nearest cent.

Required:

1. Prepare a scattergraph based on these data. Use cost for the vertical axis and number of moves for the horizontal. Based on an examination of the scattergraph, does there appear to be a linear relationship between the total cost of moving materials and the number of moves?

2. Compute the cost formula for moving materials by using the high-low method. Calculate the predicted cost for a month with 550 moves by using the high-low formula.

3. Compute the cost formula for moving materials using the method of least squares. Using the regression cost formula, what is the predicted cost for a month with 550 moves? What does the coefficient of determination tell you about the cost formula computed by regression?

4. Evaluate the cost formula using the least squares coefficients. Could it be improved? Try dropping the third data point (300, $3,400), and rerun the regression.

Number of Moves Total Cost

100 ............ $ 3,000

200 ............ 4,650

300 ............ 3,400

400 ............ 8,500

500 ............ 10,000

600 ............ 12,600

700 ............ 13,600

800 ............ 14,560

Note: For the following requirements, round the fixed costs to the nearest dollar and round the variable cost to the nearest cent.

Required:

1. Prepare a scattergraph based on these data. Use cost for the vertical axis and number of moves for the horizontal. Based on an examination of the scattergraph, does there appear to be a linear relationship between the total cost of moving materials and the number of moves?

2. Compute the cost formula for moving materials by using the high-low method. Calculate the predicted cost for a month with 550 moves by using the high-low formula.

3. Compute the cost formula for moving materials using the method of least squares. Using the regression cost formula, what is the predicted cost for a month with 550 moves? What does the coefficient of determination tell you about the cost formula computed by regression?

4. Evaluate the cost formula using the least squares coefficients. Could it be improved? Try dropping the third data point (300, $3,400), and rerun the regression.

## Answer to relevant Questions

For the past five years, Garner Company has had a policy of producing to meet customer demand. As a result, finished goods inventory is minimal, and for the most part, units produced equal units sold. Recently, Garner’s ...Describe the difference between the units sold approach to CVP analysis and the sales revenue approach. Head-First Company plans to sell 5,000 bicycle helmets at $75 each in the coming year. Variable cost is 60 percent of the sales price; contribution margin is 40 percent of the sales price. Total fixed cost equals $49,500 ...Suppose that Adams Company sells a product for $20. Unit costs are as follows: Direct materials ................. $3.90 Direct labor .................. 1.40 Variable factory overhead ............ 2.10 Variable selling and ...Refer to the information for Peace River Products above. Suppose that in the coming year, the company plans to produce an extra-thick yoga mat for sale to health clubs. The company estimates that 9,000 mats can be sold at a ...Post your question

0