In: Accounting
Complete the chart, showing manufacturing cost at various levels of production for Company X
Volume (unit) 10,000 20,000 30,000 40,000
Cost A $25,000 $25,000 $25000
Cost B $25,000 $50,000 $100,000
Cost C $33,000 $48,000 $78,000
I know Cost A under Volume(unit) is $25,000, needs help on how to calculate Cost B and A.
--Cost A, is apparently a FIXED
COST
--Cost B, is a variable cost
because:
$ 25000 / 10000 = $ 2.5
$ 50000 / 20000 = $ 2.5
--Cost C is Mixed Cost:
| 
 Units  | 
 Cost  | 
||
| 
 High Level  | 
 30,000  | 
 $ 78,000.00  | 
|
| 
 Low Level  | 
 10,000  | 
 $ 33,000.00  | 
|
| 
 Difference  | 
 20,000  | 
 $ 45,000.00  | 
|
| 
 A  | 
 Difference in Cost  | 
 $ 45,000.00  | 
|
| 
 B  | 
 Difference in units  | 
 20,000  | 
|
| 
 C = A/B  | 
 Variable cost per unit  | 
 $ 2.25  | 
|
| 
 Working  | 
 High Level  | 
 Low Level  | 
|
| 
 A  | 
 Total Cost  | 
 $ 78,000.00  | 
 $ 33,000.00  | 
| 
 B  | 
 Total Units  | 
 30000  | 
 10000  | 
| 
 C  | 
 Variable cost per unit  | 
 $ 2.25  | 
 $ 2.25  | 
| 
 D = B x C  | 
 Total Variable cost  | 
 $ 67,500.00  | 
 $ 22,500.00  | 
| 
 E = A - D  | 
 Total Fixed Cost  | 
 $ 10,500.00  | 
 $ 10,500.00  | 
| 
 Volume  | 
 10,000  | 
 20,000  | 
 30,000  | 
 40,000  | 
| 
 Cost A [Fixed Cost]  | 
 $25,000  | 
 $25,000  | 
 $25,000  | 
 $25,000  | 
| 
 Cost B [Variable Cost]  | 
 $25,000  | 
 $50,000  | 
 $100,000  | 
 $100,000 [40000 units x $2.50]  | 
| 
 Cost C [Mixed Cost  | 
 $33,000  | 
 $48,000  | 
 $78,000  | 
 $100,500 [$10500 + ($2.25 x 40000 units)]  |