(Static versus flexible budget variances)

ANALYZE, THINK, COMMUNICATE ATC 8-1 Business Applications Case Static versus flexible budget variances David Catrow is the manufacturing production supervisor for Faraday Motor Works (FMW), a com- pany that manufactures electrical motors for industrial applications. Trying to explain why he did not get the year-end bonus that he had expected, he told his wife, "This is the dumbest place I've ever worked. Last year the company set up this budget assuming it would sell 150,000 units. Well, it sold only 140,000. The company lost money and gave me a bonus for not using as much materials and la- bor as was called for in the budget. This year, the company has the same 150,000 units goal and it sells 160,000. The company's making all kinds of money. You'd think I'd get this big fat bonus. Instead, management tells me I used more materials and labor than was budgeted. They said the company would have made a lot more money if I'd stayed within my budget. I guess I gotta wait for another bad year before I get a bonus. Like I said, this is the dumbest place I've ever worked. FMW's master budget and the actual results for the most recent year of operating activity follow: Master Budget Actual Results Variances For U Number of units 150,000 160,000 10,000 Sales revenue $33,000,0 $35,520,000 $2,520,000 F Variable manufacturing costs Materials Labor Overhead (4,800 (4,200,0 (2,100,000) (5,300,000) 500,000 U 200,000 U 190,000 U (4,400,000) (2,290,000) Variable selling, general, and admin. costs (5,250,000) (5.450,000) 200,000U 000 F Contribution margin 8,080,000 1,430 16,650,000 (7,830,000) $ 1,840,000 Fixed costs 79,000 F Selling, general, and admin.costs(6,980,000 _(7.015,000) 35,000 U $3,314,000 $1,474,000 F Manufacturing overhead (7,751,000) Net income Did FMW increase unit sales by cutting prices or by using some other strategy? Is Mr. Catrow correct in his conclusion that something is wrong with the company's performance evaluation process? If so, what do you suggest be done to improve the system? a. b. c. Prepare a flexible budget and recompute the budget variances. d. Explain what might have caused the fixed costs to be different from the amount budgeted. e. Assume that the company's materials price variance was favorable and its materials usage vari- ance was unfavorable. Explain why Mr. Catrow may not be responsible for these variances. Now, explain why he may have been responsible for the materials usage variance. f. Assume the labor price variance is unfavorable. Was the labor usage variance favorable or unfavorable? Is the fixed cost volume variance favorable or unfavorable? Explain the effect of this variance on the cost of each unit produced. g