# Question: Jill Goldstein has been collecting data over the last year

Jill Goldstein has been collecting data over the last year in an effort to understand the cost drivers of distribution costs at Waterloo Corporation, a manufacturer of brass door handles. Distribution costs include the costs of organizing different shipments as well as physically handling and moving packaged units. Goldstein believes that, because the product is heavy, number of units moved will affect distribution costs significantly but she is not certain that this is the case.

Goldstein collects the following monthly data for the past 12 months:

Goldstein estimates the following regression equations:

y = $5,187.72 + ($0,533 x Number of packaged units moved)

y = $9,073.11 + ($88.71 x Number of shipments made)

1. Using Excel, produce plots of the monthly data and the regression lines underlying each of the following cost functions:

a. Predicted distribution costs y = a + bX (where X = Number of packaged units moved)

b. Predicted distribution costs y = a + bX (where X = Number of shipments made)

Which cost driver for support overhead costs would you choose? Explain your answer briefly based on the graphs and statistics provided by the analysis.

2. Goldstein anticipates moving 40,000 units in 220 shipments next month. Using the cost function you chose in requirement 1, what distribution costs should Goldstein budget?

3. If Ms. Goldstein chose the wrong cost function—the cost function other than the one you chose in requirement 1—and 40,000 units were moved in 220 shipments, would you expect actual costs to be lower than, to be greater than, or to closely approximate the predictions made using the “wrong” cost driver and cost function? Explain your answer briefly and discuss any other implications of choosing the “wrong” cost driver and cost function.

4. What problem is common to both estimations of predicted cost pool values based on changes in either cost driver and what can Goldstein do now?

Goldstein collects the following monthly data for the past 12 months:

Goldstein estimates the following regression equations:

y = $5,187.72 + ($0,533 x Number of packaged units moved)

y = $9,073.11 + ($88.71 x Number of shipments made)

1. Using Excel, produce plots of the monthly data and the regression lines underlying each of the following cost functions:

a. Predicted distribution costs y = a + bX (where X = Number of packaged units moved)

b. Predicted distribution costs y = a + bX (where X = Number of shipments made)

Which cost driver for support overhead costs would you choose? Explain your answer briefly based on the graphs and statistics provided by the analysis.

2. Goldstein anticipates moving 40,000 units in 220 shipments next month. Using the cost function you chose in requirement 1, what distribution costs should Goldstein budget?

3. If Ms. Goldstein chose the wrong cost function—the cost function other than the one you chose in requirement 1—and 40,000 units were moved in 220 shipments, would you expect actual costs to be lower than, to be greater than, or to closely approximate the predictions made using the “wrong” cost driver and cost function? Explain your answer briefly and discuss any other implications of choosing the “wrong” cost driver and cost function.

4. What problem is common to both estimations of predicted cost pool values based on changes in either cost driver and what can Goldstein do now?

## Answer to relevant Questions

Ken Howard, financial analyst at JVR Corporation, a manufacturer of precision parts, is examining the behaviour of quarterly maintenance costs for budgeting purposes. Ken collects data on machine-hours worked and maintenance ...Evaluating alternative simple regression models, not-for-profit. (Chapter Appendix) ^ Kathy Hanks, executive assistant to the president of Eastern University, is concerned about the overhead costs at her university. Cost ...Sanchez Corporation runs two convenience stores, one in Vancouver and one in Surrey. Operating income for each store in 2013 is as follows: The equipment has a zero disposal value. In a senior management meeting, Maria ...The following are the Class Company’s unit costs of manufacturing and marketing a high-style pen at an output level of 20,000 units per month: Manufacturing cost Direct materials ...... $1.00 Direct manufacturing labour ...The Pastel Company must reach a make/buy decision with respect to a high volume, easily made metal tool, RG1. Sean Gray, the cost analyst, estimates the following costs and production information for the 50,000 units of RG1 ...Post your question