In: Accounting
Problem #1
Walters, LLC produces knock-off watches. Each watch sells for $40.00. Walters produced and sold 100 watches last year. Use the following cost data to compute the variable cost per unit and the fixed cost for the period.
Volume |
Cost |
10 |
$800.00 |
20 |
$1,100.00 |
15 |
$900.00 |
18 |
$1,050.00 |
25 |
$1,250.00 |
a. Using the high-low method, determine the amount of variable cost per unit.
Answer: ________________________
b. Using the high-low method, determine the total amount of fixed costs.
Answer: ________________________
c. What is the variable cost ratio?
Answer: ________________________
d. What is the contribution margin per unit?
Answer: ________________________
e. What is the contribution margin ratio?
Answer: ________________________
f. How many watches must Walters sell to break even?
Answer: ________________________
g. What is the break-even sales revenue?
Answer: ________________________
h. What was Walters’ operating income last year?
Answer: ________________________
i. What was Walters’ margin of safety?
Answer: ________________________
j. Assume the company has a desired net income of $1,500.
(1) How many sales dollars must the company earn?
Answer: ________________________
(2) How many watches must the company sell?
Answer: ________________________
Volume |
Cost |
|
Highest Level |
25 |
$1250 |
Lowest Level |
10 |
$800 |
Difference |
15 (B) |
$450 (A) |
Variable cost per unit [A/B] |
[450/15] $30 |
Answer b) Total fixed cost = $500
Working |
High Level |
Low Level |
|
A |
Total cost |
$1250 |
$800 |
B |
Volume |
25 |
10 |
C |
Variable cost per unit |
$30 |
$30 |
D=BxC |
Total Variable cost |
$750 |
$300 |
E=A-D |
Total fixed cost |
$500 |
$500 |
Answer (c) to (j) in sequence
(C) |
|
Variable cost per unit |
30 |
Sale Price per unit |
40 |
Variable cost ratio |
75% |
(d) |
|
Sale Price per unit |
40 |
Variable cost per unit |
30 |
Contribution margin per unit |
$10 |
(e) |
|
Contribution margin per unit |
10 |
Sale Price per unit |
40 |
Contribution margin ratio |
25% |
(f) |
|
Fixed Cost |
500 |
Contribution margin per unit |
10 |
Watches to be sold for break Even |
50 watches |
(g) |
|
Break Even in no of watches |
50 |
Sale Price per unit |
40 |
Break Even Sales revenue |
$2000 |
(h) |
|
Contribution per unit |
10 |
Units Sold last year |
100 |
Total contribution margin |
1000 |
(-)Fixed Cost |
500 |
Operating Income |
$500 |
(i) |
|
Total Revenues |
4000 |
Break Even Revenues |
2000 |
Margin of Safety |
$2000 |
(j) |
|
Desired Net Income |
1500 |
Fixed Cost |
500 |
Total contribution margin required |
2000 |
Contribution per unit |
10 |
(j2) No. of Units to sell |
200 |
(j1) Sales Dollars to earn $1500 profit |
[200 x 40] $8000 |