Sales Activity Variance
Refer to the data in Exercise 16 22. Prepare a sales activity variance analysis for Data 2 Go like the one in Exhibit 16.4.
Exercise 16 22: Prepare Flexible Budget
Data 2 Go manufactures and sells flash drives. The company produces only when it receives orders and, therefore, has no inventories. The following information is available for the current month:
|
Actual (based on actual of 750,000 units) |
Master Budget (based on budgeted 800,000 units) |
|
||
|
||
Sales revenue |
$6,210,000 |
$6,000,000 |
Less |
|
|
Variable costs |
|
|
Blank flash drives |
1,800,000 |
1,800,000 |
Direct labor |
345,000 |
420,000 |
Variable overhead |
843,000 |
780,000 |
Variable marketing and administrative |
585,000 |
600,000 |
Total variable costs |
$3,573,000 |
$3,600,000 |
Contribution margin |
$2,637,000 |
$2,400,000 |
Less |
|
|
Fixed costs |
|
|
Manufacturing overhead |
1,236,000 |
1,200,000 |
Marketing |
360,000 |
360,000 |
Administrative |
255,000 |
225,000 |
Total fixed costs |
$1,851,000 |
$1,785,000 |
Operating profits |
$ 786,000 |
$ 615,000 |
Required
Prepare a flexible budget for Data 2 Go.
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 |
|
|
|
|
|
|
|
|
|
|