Response to the following problem:
Stevie McQueen has run Lightning Car Detailing for the past 10 years. His static budget and actual results for June 2011 are provided next. Stevie has one employee who has been with him for all 10 years that he has been in business. In addition, at any given time he also employs two other less experienced workers. It usually takes each employee 2 hours to detail a vehicle, regardless of his or her experience. Stevie pays his experienced employee $40 per vehicle and the other two employees $20 per vehicle. There were no wage increases in June.
|
Lightning Car Detailing
Actual and Budgeted Income Statements
For the Month Ended June 30, 2011
Budget
|
Actual
|
|
Cars detailed
|
200
|
225
|
|
Revenue
|
$30,000
|
$39,375
|
|
Variable costs
|
|
|
|
Costs of supplies
|
1,500
|
2,250
|
|
Labor
|
5,600
|
6,000
|
|
Total variable costs
|
7,100
|
8,250
|
|
Contribution margin
|
22,900
|
31,125
|
|
Fixed costs
|
9,500
|
_9,500
|
|
Operating income
|
$13,400
|
$21,625
|
Required:
1. How many cars, on average, did Stevie budget for each employee? How many cars did each employee actually detail?
2. Prepare a flexible budget for June 2011.
3. Compute the sales price variance and the labor efficiency variance for each labor type.
4. What information, in addition to that provided in the income statements, would you want Stevie to gather, if you wanted to improve operational efficiency?