Walsh Company manufactures and sells one product. The following information pertains to each of the company’s first two years of operations:
Variable costs per unit: | ||
Manufacturing: | ||
Direct materials | $ | 26 |
Direct labor | $ | 13 |
Variable manufacturing overhead | $ | 7 |
Variable selling and administrative | $ | 6 |
Fixed costs per year: | ||
Fixed manufacturing overhead | $ | 320,000 |
Fixed selling and administrative expenses | $ | 80,000 |
During its first year of operations, Walsh produced 50,000 units and sold 40,000 units. During its second year of operations, it produced 40,000 units and sold 50,000 units. The selling price of the company’s product is $52 per unit.
Required:
1. Assume the company uses variable costing:
a. Compute the unit product cost for year 1 and year 2.
|
I cannot calculate selling and administrative costs as well as reconcile..... please show calculations
Part 1
Unit Product cost under Variable costing | ||
Year 1 | Year 2 | |
Direct material per unit | $ 26 | $ 26 |
Direct labor per unit | $ 13 | $ 13 |
Variable manufacture overhead per unit | $ 7 | $ 7 |
Unit Product cost under Variable costing | $ 46 | $ 46 |
Walsh Company | ||
Income statement (Variable Costing) | ||
Units sold | 40,000 | 50,000 |
Sales revenue (Units sold * 52) | $ 2,080,000 | $ 2,600,000 |
Less: Variable cost | ||
Variable cost of goods sold (Units sold * 46) | $ 1,840,000 | $ 2,300,000 |
Variable selling and administrative (Units sold * 6) | $ 240,000 | $ 300,000 |
Total variable cost | $ 2,080,000 | $ 2,600,000 |
Contribution margin | $ - | $ - |
Less: fixed cost | ||
Fixed manufacture overhead | $ 320,000 | $ 320,000 |
Fixed selling and administrative | $ 80,000 | $ 80,000 |
Total fixed cost | $ 400,000 | $ 400,000 |
Operating income (loss) | $ (400,000) | $ (400,000) |
Part 2
Units cost under absorption costing | ||
Year 1 | Year 2 | |
Fixed manufacture overhead | $ 320,000 | $ 320,000 |
Divided by: Units produced | 50,000 | 40,000 |
Fixed manufacture overhead per unit | $ 6.40 | $ 8.00 |
Direct material per unit | $ 26.00 | $ 26.00 |
Direct labor per unit | $ 13.00 | $ 13.00 |
Variable manufacture overhead per unit | $ 7.00 | $ 7.00 |
Fixed manufacture overhead per unit | $ 6.40 | $ 8.00 |
Units cost under absorption costing | $ 52.40 | $ 54.00 |
Units produced | 50,000 | 40,000 |
Multiply: Variable cost per unit | $ 46.00 | $ 46.00 |
Variable manufacture overhead | $ 2,300,000 | $ 1,840,000 |
Variable manufacture overhead | $ 2,300,000 | $ 1,840,000 |
Fixed manufacture overhead | $ 320,000 | $ 320,000 |
Total Manufacturing cost | $ 2,620,000 | $ 2,160,000 |
Year 1 | Year 2 | |
Beginning inventory | $ 0 | $ 524,000 |
Add: Total Manufacturing cost | $ 2,620,000 | $ 2,160,000 |
Less: ending inventory (52.4*10000) | $ (524,000) | $ (0) |
Cost of goods sold | $ 2,096,000 | $ 2,684,000 |
Variable selling and administrative | $ 240,000 | $ 300,000 |
Fixed selling and administrative | $ 80,000 | $ 80,000 |
Selling and administrative expenses | $ 320,000 | $ 380,000 |
Walsh Company | ||
Income statement (Absorption Costing) | ||
Sales | $ 2,080,000 | $ 2,600,000 |
Less: Cost of goods sold | $ 2,096,000 | $ 2,684,000 |
Contribution margin | $ (16,000) | $ (84,000) |
Less: Selling and administrative expenses | $ 320,000 | $ 380,000 |
Net operating income (loss) | $ (336,000) | $ (464,000) |
Part 3
Ending Inventory value in year 1 under both method | ||
Absorption costing (10000*52.4) | $ 524,000 | |
Variable costing (10000*46) | $ 460,000 | |
Difference | $ 64,000 | |
Reconciliation | ||
Year 1 | Year 2 | |
Operating income (loss) under variable costing | $ (400,000) | $ (400,000) |
Add: Difference in ending inventory value (Fixed Manufacture overhead cost deferred in inventory value under Absorption costing) | $ 64,000 | |
less : Difference in Beginning inventory value (Fixed Manufacture overhead cost realized from inventory value under Absorption costing) | $ (64,000) | |
Operating income (loss) under Absorption costing | $ (336,000) | $ (464,000) |
Walsh Company manufactures and sells one product. The following information pertains to each of the company’s...
Walsh Company manufactures and sells one product. The following information pertains to each of the company's first two years of operations: Variable costs per unit: Manufacturing: Direct materials Direct labor Variable manufacturing overhead Variable selling and administrative Fixed costs per year: Fixed manufacturing overhead Fixed selling and administrative expenses 0000 0 $ $ 320,000 50,000 During its first year of operations, Walsh produced 50,000 units and sold 40,000 units. During its second year of operations, it produced 40,000 units and...
Walsh Company manufactures and sells one product. The following information pertains to each of the company’s first two years of operations: Variable costs per unit: Manufacturing: Direct materials $ 28 Direct labor $ 10 Variable manufacturing overhead $ 3 Variable selling and administrative $ 2 Fixed costs per year: Fixed manufacturing overhead $ 320,000 Fixed selling and administrative expenses $ 50,000 During its first year of operations, Walsh produced 50,000 units and sold 40,000 units. During its second year of...
Walsh Company manufactures and sells one product. The following information pertains to each of the company's first two years of operations: Variable costs per unit: Manufacturing: Direct materials Direct labor Variable manufacturing overhead Variable selling and administrative Fixed costs per year Fixed manufacturing overhead Fixed selling and administrative expenses $ 23 $ 11 $5 $4 $ 320,000 $ 80,000 During its first year of operations, Walsh produced 50,000 units and sold 40,000 units. During its second year of operations, it...
Walsh Company manufactures and sells one product. The following information pertains to each of the company’s first two years of operations: Variable costs per unit: Manufacturing: Direct materials $ 23 Direct labor $ 13 Variable manufacturing overhead $ 3 Variable selling and administrative $ 2 Fixed costs per year: Fixed manufacturing overhead $ 320,000 Fixed selling and administrative expenses $ 80,000 During its first year of operations, Walsh produced 50,000 units and sold 40,000 units. During its second year of...
Walsh Company manufactures and sells one product. The following information pertains to each of the company’s first two years of operations: Variable costs per unit: Manufacturing: Direct materials $ 23 Direct labor $ 10 Variable manufacturing overhead $ 6 Variable selling and administrative $ 5 Fixed costs per year: Fixed manufacturing overhead $ 320,000 Fixed selling and administrative expenses $ 80,000 During its first year of operations, Walsh produced 50,000 units and sold 40,000 units. During its second year of...
Walsh Company manufactures and sells one product. The following information pertains to each of the company’s first two years of operations: Variable costs per unit: Manufacturing: Direct materials $ 27 Direct labor $ 12 Variable manufacturing overhead $ 5 Variable selling and administrative $ 4 Fixed costs per year: Fixed manufacturing overhead $ 320,000 Fixed selling and administrative expenses $ 80,000 During its first year of operations, Walsh produced 50,000 units and sold 40,000 units. During its second year of...
Walsh Company manufactures and sells one product. The following information pertains to each of the company's first two years of operations: Variable costs per unit: Manufacturing: Direct materials Direct labor Variable manufacturing overhead Variable selling and administrative Fixed costs per year: Fixed manufacturing overhead Fixed selling and administrative expenses $ $ 27 16 6 5 $ 400.000 $ 90,000 During its first year of operations, Walsh produced 50,000 units and sold 40,000 units. During its second year of operations, it...
Walsh Company manufactures and sells one product. The following information pertains to each of the company’s first two years of operations: Variable costs per unit: Manufacturing: Direct materials $ 29 Direct labor $ 17 Variable manufacturing overhead $ 3 Variable selling and administrative $ 2 Fixed costs per year: Fixed manufacturing overhead $ 400,000 Fixed selling and administrative expenses $ 50,000 During its first year of operations, Walsh produced 50,000 units and sold 40,000 units. During its second year of...
Walsh Company manufactures and sells one product. The following information pertains to each of the company's first two years of operations: Variable costs per unit: Manufacturing: Direct materials Direct labor Variable manufacturing overhead Variable selling and administrative Fixed costs per year: Fixed manufacturing overhead Fixed selling and administrative expenses $ $ $ $ 24 13 6 5 $ 320,000 $ 50,000 During its first year of operations, Walsh produced 50,000 units and sold 40,000 units. During its second year of...
Walsh Company manufactures and sells one product. The following information pertains to each of the company's first two years of operations: Variable costs per unit: Manufacturing: Direct materials Direct labor Variable manufacturing overhead Variable selling and administrative Fixed costs per year: Fixed manufacturing overhead Fixed selling and administrative expenses $ 21 $ 12 $3 $ 2 $ 320,000 $ 90,000 During its first year of operations, Walsh produced 50,000 units and sold 40,000 units. During its second year of operations,...