Question
David Catrow is the manufacturing production supervisor for Walton Motor Works, a company that manufactures electrical motors for industrial applications. Trying to explain why he
David Catrow is the manufacturing production supervisor for Walton Motor Works, a company 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 140,000 units. Well, it sold only 130,000. The company lost money and gave me a bonus for not using as much materials and labor as was called for in the budget. This year, the company has the same 140,000 units goal and it sells 152,000. The companys making all kinds of money. Youd think Id 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 Id 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.
Waltons master budget and the actual results for the most recent year of operating activity follow:
Master Budget | Actual Results | Variances | F or U | |||||||||
Number of units | 140,000 | 152,000 | 12,000 | |||||||||
Sales revenue | $ | 30,380,000 | $ | 33,440,000 | $ | 3,060,000 | F | |||||
Variable manufacturing costs | ||||||||||||
Materials | (4,480,000 | ) | (4,903,520 | ) | 423,520 | U | ||||||
Labor | (4,340,000 | ) | (4,678,560 | ) | 338,560 | U | ||||||
Overhead | (2,100,000 | ) | (2,308,880 | ) | 208,880 | U | ||||||
Variable selling, general and administrative costs | (4,620,000 | ) | (4,984,080 | ) | 364,080 | U | ||||||
Contribution margin | 14,840,000 | 16,564,960 | 1,724,960 | F | ||||||||
Fixed costs | ||||||||||||
Manufacturing overhead | (7,230,000 | ) | (7,110,000 | ) | 120,000 | F | ||||||
Selling, general and administrative costs | (7,129,000 | ) | (7,229,000 | ) | 100,000 | U | ||||||
Net income | $ | 481,000 | $ | 2,225,960 | $ | 1,744,960 | F | |||||
Required
c. Prepare a flexible budget and recompute the budget variances. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance).)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started