In: Accounting
Grange Manufacturing Company had net income of $300,000 in 2017 when the selling price per unit was $200 and data for variable and fixed costs were as follows:
Cost Schedule:
Variable Costs:
Direct Material
$28
Direct Labour
$35
Variable Manufacturing Overhead
$17
$80
Fixed Costs:
Manufacturing Overhead
$225,000
Advertising
45,000
Administrative
150,000
$420,000
Required:
i) Compute the number of units sold in 2017, using the equation method.
ii) Using the sales units calculated in (i), prepare a contribution margin income statement for the year ended December 31, 2017, detailing the components of total fixed costs, and clearly showing contribution and net income.
| Ans.1 | Number of units sold = 3680 | |||||
| *Calculation: | ||||||
| Sales = Variable cost + Fixed cost + Profit | ||||||
| (Sales units * Selling price) = Variable cost + fixed cost + Profit | ||||||
| (Sales units * 200) = 16000 + 420000 + 300000 | ||||||
| sales units * 200 = 736000 | ||||||
| Sales units = 736000 / 200 | ||||||
| Sales units = 3680 | ||||||
| *Calculation of total variable cost: | ||||||
| Direct material (28*200) | 5600 | |||||
| Direct labor (35*200) | 7000 | |||||
| Variable manufacturing overhead (17*200) | 3400 | |||||
| Total variable cost | 16000 | |||||
| *Calculation of total fixed cost: | ||||||
| Manufacturing overhead | 225000 | |||||
| Advertising | 45000 | |||||
| Administration | 150000 | |||||
| Total Fixed Costs | 420000 | |||||
| Ans.2 | GRANGE MANUFACTURING COMPANY | |||||
| Contribution margin income statement | ||||||
| For the year ended Dec. 31, 2017 | ||||||
| PARTICULARS | AMOUNT | |||||
| Sales Revenue (3680*200) | 736000 | |||||
| Less: Variable cost | ||||||
| Direct material | 5600 | |||||
| Direct labor | 7000 | |||||
| Variable manufacturing overhead | 3400 | |||||
| Total variable cost | 16000 | |||||
| Contribution margin | 720000 | |||||
| Less: Fixed costs: | ||||||
| Manufacturing overhead | 225000 | |||||
| Advertising | 45000 | |||||
| Administration | 150000 | |||||
| Total Fixed cost | 420000 | |||||
| Net income | 300000 | |||||
| *Each component of Variable cost & fixed cost is already calculated in Ans.1. | ||||||
| *Contribution margin = Sales revenue - Total variable costs | ||||||
| *Net Income = Contribution margin - Total fixed costs. | ||||||