Sales Activity Variance, Service Organization
Refer to the data in Exercise 17 24. Prepare a sales activity variance analysis like the one in Exhibit 16.4 of the previous chapter.
Exercise 17 24: Flexible Budgeting, Service Organization
Lowe & Rent is a law firm that specializes in probate work. Last year, the firm billed more hours than expected, but, as the following data show, profits were lower than anticipated.
|
Reported Income |
Master |
|
Statement |
Budget |
Billable hoursa |
6,900 |
6,000 |
Revenue |
$825,000 |
$750,000 |
Professional salaries (all variable) |
465,000 |
375,000 |
Other variable costs (e.g., supplies, computer services) |
108,000 |
102,000 |
Fixed costs |
174,000 |
180,000 |
Profit |
$ 78,000 |
$ 93,000 |
Required
Prepare a flexible budget for Lowe & Rent. Use billable hours as the measure of output (that is, units produced).
Exhibit 16.4 Flexible and Master Budget, August—Bayou Division
|
A |
|
B |
C |
D |
E |
|
|||
|
|
|
Flexible Budget |
Sales Activity |
|
Master Budget |
|
|||
|
|
|
(based on |
Variance |
|
(based on |
|
|||
|
|
|
actual activity |
(based on |
|
planned |
|
|||
|
|
|
of 80,000 |
variance in |
|
activity of |
|
|||
1 |
|
|
units) |
sales volume) |
|
100,000 units) |
|
|||
2 |
Sales units |
|
80,000 |
20,000 |
|
100,000 |
|
|||
3 |
|
|
|
|
|
|
|
|||
4 |
Sales revenue |
|
$ 800,000 |
$ 200,000 |
U |
$ 1,000,000 |
|
|||
5 |
Less |
|
|
|
|
|
|
|||
6 |
Variable costs |
|
|
|
|
|
|
|||
7 |
Variable manufacturing costs |
|
304,000 |
76,000 |
F |
380,000 |
|
|||
8 |
Variable selling and administrative |
|
72,000 |
18,000 |
F |
90,000 |
|
|||
9 |
Total variable costs |
|
$ 376,000 |
$ |
94,000 |
F |
$ |
470,000 |
|
|
10 |
Contribution margin |
|
$ 424,000 |
$ 106,000 |
U |
$ |
530,000 |
|
||
11 |
Fixed costs |
|
|
|
|
|
|
|
||
12 |
Fixed manufacturing overhead |
|
200,000 |
–0– |
|
|
200,000 |
|
||
13 |
Fixed selling and administrative costs |
|
140,000 |
–0– |
|
|
140,000 |
|
||
14 |
Total fixed costs |
|
$ 340,000 |
–0– |
|
$ |
340,000 |
|
||
15 |
Profit |
|
$ |
84,000 |
$ 106,000 |
U |
$ |
190,000 |
|
|
16 |
|
|
|
|
|
|
|
|
|
|