In: Accounting
Homework: Cost Behavior and Cost Prediction | |||
Oct | Nov | ||
Unit Sales | 4,000 | 6,000 | |
Cost of Food Sold | $ 2,000 | $ 3,000 | |
Depreciation | 500 | 500 | |
Supplies | 500 | 750 | |
Wages and Salaries | 5,000 | 5,500 | |
Utilities | 1,400 | 1,500 | |
Rent | 4,000 | 4,000 | |
Total | $ 13,400 | $ 15,250 | |
What is the Unit Variable Cost and Fixed Costs? | |||
Predict the Average and Total Costs for | 7000 | units |
Calculation of unit variable cost & fixed cost |
|||||||||
Increase in cost for increase in units |
Increase % |
Cost |
Fixed costs for 7000 units |
Calculation |
Variable costs for 7000 units |
Calculation |
|||
Unit Sales |
4000 |
6000 |
2000 |
50% |
Variable cost |
7000 |
7000 |
||
Cost of Food Sold |
2000 |
3000 |
1000 |
50% |
Variable cost since increase in units % = Increase in % variable cost |
- |
NA |
3,500 |
100% Variable cost |
Depreciation |
500 |
500 |
0 |
0% |
Fixed cost |
500 |
100% Fixed cost |
- |
NA |
Supplies |
500 |
750 |
250 |
50% |
Variable cost |
- |
NA |
875 |
100% Variable cost |
Wages and Salaries |
5000 |
5500 |
500 |
10% |
Semi variable cost |
4,000 |
(5500-(500/2000*6000)) |
1,750 |
(500/2000*7000) |
Utilities |
1400 |
1500 |
100 |
7% |
Semi variable cost |
1,200 |
(1500-(100/2000*6000)) |
350 |
(100/2000*7000) |
Rent |
4000 |
4000 |
0 |
0% |
Fixed cost |
4,000 |
100% Fixed cost |
- |
NA |
Total |
$ 13,400 |
$ 15,250 |
9,700 |
6,475 |
|||||
Cost per unit |
1.39 |
0.93 |
|||||||
Unit variable cost |
$0.93 |
||||||||
Unit Fixed cost |
$1.39 |