Sales Activity Variance
Refer to the data in Problem 16 46. Prepare a sales activity variance analysis for Hayden Corporation like the one in Exhibit 16.4.
Problem 16 46: Prepare Flexible Budget
Hayden Corporation provides you with the following information for the month of June:
|
Actual (based on |
Master Budget (based |
|
actual sales of |
on budgeted sales of |
|
21,000 units) |
20,000 units) |
Sales revenues |
$1,155,000 |
$1,200,000 |
Less |
|
|
Variable costs |
|
|
Direct material |
147,000 |
120,000 |
Direct labor |
136,500 |
160,000 |
Variable overhead |
158,500 |
160,000 |
Marketing |
51,000 |
50,000 |
Administration |
47,000 |
50,000 |
Total variable costs |
$ 540,000 |
$ 540,000 |
|
|
|
Contribution margin |
$ 615,000 |
$ 660,000 |
Fixed costs |
|
|
Manufacturing |
256,000 |
250,000 |
Marketing |
57,000 |
50,000 |
Administration |
203,000 |
$ 200,000 |
|
|
|
Total fixed costs |
$ 516,000 |
$ 500,000 |
Operating profits |
$ 99,000 |
$ 160,000 |
Required
Prepare a flexible budget for Hayden Corporation for June.
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 |
|
|
|
|
|
|
|
|
|
|