Darja Navitski, production manager, was upset with the latest performance report, which indicated that she was $100,000 over budget. Given the efforts that she and her workers had made, she was confident that they had met or beaten the budget. Now she was not only upset but also genuinely puzzled over the results. Three items-direct labour, power, and setups-were over budget. The actual costs for these three items follow:
Direct labour ......................... $210,000
Power .................................. 135,000
Setups .................................. 140,000
Total.................................... $485,000
Darja knew that her operation had produced more units than originally had been budgeted, so more power and labour had naturally been used. She also knew that the uncertainty in schedulng had led to more setups than planned. When she pointed this out to Jon Helguson, the controller, he assured her that the budgeted costs had been adjusted for the increase in productive activity. Curious, Darja questioned Jon about the methods used to make the adjustment.
Jon: If the actual level of activity differs from the original planned level, we adjust the budget by using budget formulas-formulas that allow us to predict the costs for dif- ferent levels of activity.
Darja: The approach sounds reasonable. However, I'm sure something is wrong here. Tell me exactly how you adjusted the costs of direct labour, power, and setups.
Jon: First, we obtained formulas for the individual items in the budget by using the method of least squares. We assumed that cost variations could be explained by variations in productive activity where activity is measured by direct labour hours. Here is a list of the cost formulas for the three items you mentioned. The variable X is the number of direct labour hours.
Direct labour cost 1⁄4 $10X
Power cost 1⁄4 $5,000 þ $4X
Setup cost 1⁄4 $100,000
Darja: I think I see the problem. Power costs don't have a lot to do with direct labour hours. They have more to do with machine hours. As production increases, machine hours increase more rapidly than direct labour hours.
Jon: You know, you have a point. The coefficient of determination for power cost is only about 50 percent. That leaves a lot of unexplained cost variation. The coefficient for labour, however, is much better-it explains about 96 percent of the cost variation. Setup costs, of course, are fixed.
Darja: Well, as I was about to say, setup costs also have little to do with direct labour hours. And I might add that they certainly are not fixed-at least not all of them. We had to do more setups than our original plan called for because of the scheduling changes.
And we have to pay our people when they work extra hours. It seems like we are always paying overtime. I wonder if we simply do not have enough people for the setup activity. Also, there are supplies that are used for each setup, and these are not cheap. Did you build these extra costs of increased setup activity into your budget?
Jon: No, we assumed that setup costs were fixed. I see now that some of them could vary as the number of setups increased. Darja, let me see if I can develop some cost formulas based on better explanatory variables. I'll get back to you in a few days.
After a few days' work, Jon developed the following cost formulas, all with a coefficient of determination greater than 90 percent:
Direct labour cost = $10X; where X = Direct labour hours
Power cost = $68,000 + 0:9Y; where Y = Machine hours
Setup cost = $98,000 + $400Z; where Z = Number of setups
The actual measure of each activity driver is as follows:
Direct labour hours .......................... 20,000
Machine hours ............................... 90,000
Number of setups ............................ 110
Required:
1. Prepare a performance report for direct labour, power, and setups using the direct labour- based formulas.
2. Prepare a performance report for direct labour, power, and setups using the multiple cost driver formulas that Jon developed.
3. Of the two approaches, which provides the more accurate picture of Darja's performance? Why?