Question

In: Accounting

A manufacturing company that produces a single product has provided the following data related to its operations during May:

A manufacturing company that produces a single product has provided the following data related to its operations during May:

Manufacturing costs:

Variable costs per unit: Direct materials $22.50

Direct labor $20.00

Variable manufacturing overhead $7.50

Fixed manufacturing overhead costs (total) $875,000

Selling and administrative costs:

Variable per unit $5.00

Fixed (total) $900,000

The product sells for $125 per unit. The company produced 35,000 units and sold 30,000 units in May. There is no beginning inventory.

Required:

a) Compute the breakeven sales dollars and margin of safety in sales dollars.

b) Determine the unit product cost under: i. Absorption costing. ii. Variable costing.

c) Prepare an income statement for the month using absorption costing.

d) Prepare a contribution format income statement for the month using variable costing.

e) Reconcile the variable costing and absorption costing net operating incomes in (c) and (d) above.

f) Suppose the company had same production volume in the following month, June but sold all units, making no ending inventory left. Fixed and variable manufacturing costs kept unchanged. Suppose the net income under Variable costing is $2,025,000. Compute the net income absorption costing. (Income statement is NOT required.)

Solutions

Expert Solution

a) Breakeven sales dollars=Fixed cost/Contribution margin ratio
Fixed cost
$
Manufacturing overhead costs 875000
Selling and administrative cost 900000
Total 1775000
Contribution margin ratio=Contribution margin per unit/Selling price
Contribution margin per unit=Selling price-Variable cost=125-(22.50+20+7.50+5)=$ 70
Contribution margin ratio=70/125=0.56
Breakeven sales dollars=1775000/0.56=$ 3169643
Margin of safety in sales dollars=Actual sales in $-Breakeven sales dollars=(30000*125)-3169643=3750000-3169643=$ 580357
b) Unit product cost:
i) Variable costing:
$
Direct material 22.5
Direct labor 20
Variable manufacturing overhead 7.5
Total 50
ii) Absorption costing:
$
Direct material 22.5
Direct labor 20
Variable manufacturing overhead 7.5
Fixed manufacturing overhead (875000/35000) 25
(Based on units produced)
Total 75.00
c) Variable costing income statement
$ $
Sales (30000*125) 3750000
Less: Variable cost of goods sold (30000*50) 1500000
Gross contribution margin 2250000
Less: Variable selling and administrative (30000*5) 150000
Contribution margin 2100000
Less:Fixed costs
Fixed manufacturing overhead 875000
Fixed selling and administrative 900000 1775000
Net operating income 325000
d) Absorption costing income statement
$ $
Sales (30000*125) 3750000
Less: Cost of goods sold (30000*75) 2250000
Gross profit 1500000
Less:Selling and administrative expenses
Variable (30000*5) 150000
Fixed selling 900000 1050000
Net operating income 450000


Related Solutions

A manufacturing company that produces a single product has provided the following data concerning its most...
A manufacturing company that produces a single product has provided the following data concerning its most recent month of operations: Selling price $ 126 Units in beginning inventory 0 Units produced 2,630 Units sold 2,500 Units in ending inventory 130 Variable costs per unit: Direct materials $ 49 Direct labor $ 17 Variable manufacturing overhead $ 8 Variable selling and administrative expense $ 9 Fixed costs: Fixed manufacturing overhead $ 84,160 Fixed selling and administrative expense $ 17,500 The total...
A manufacturing company that produces a single product has provided the following data concerning its most...
A manufacturing company that produces a single product has provided the following data concerning its most recent month of operations:   Selling price $138   Units in beginning inventory 0   Units produced 3,390   Units sold 2,840   Units in ending inventory 550   Variable costs per unit:   Direct materials $51   Direct labor $16   Variable manufacturing overhead $14   Variable selling and administrative $10   Fixed costs:   Fixed manufacturing overhead $115,260   Fixed selling and administrative expenses $17,040 The total gross margin for the month under absorption costing...
A manufacturing company that produces a single product has provided the following data concerning its most...
A manufacturing company that produces a single product has provided the following data concerning its most recent month of operations: Selling price -------------------------------------- $126 Units in beginning inventory ------------------- 0 Units produced ----------------------------------  8,500 Units sold ----------------------------------------- 8,300 Units in ending inventory ---------------------    200 Variable costs per unit:    Direct materials -------------------------------  $36    Direct labor ------------------------------------  $52    Variable manufacturing overhead ---------   $2    Variable selling and administrative -------   $9 Fixed costs:    Fixed manufacturing overhead ----------- $127,500    Fixed selling and administrative ----------   ...
A manufacturing company that produces a single product has provided the following data concerning its most...
A manufacturing company that produces a single product has provided the following data concerning its most recent month of operations: Selling price -------------------------------------- $140 Units in beginning inventory ----------------- 0 Units produced ---------------------------------- 1,200 Units sold -----------------------------------------    800 Units in ending inventory ---------------------    400 Variable costs per unit:    Direct materials ------------------------------- $25    Direct labor ------------------------------------  $41    Variable manufacturing overhead -------   $6    Variable selling and administrative ------   $6 Fixed costs:    Fixed manufacturing overhead ----------- $24,000    Fixed selling and administrative...
13 A manufacturing company that produces a single product has provided the following data concerning its...
13 A manufacturing company that produces a single product has provided the following data concerning its most recent month of operations:   Selling price $149   Units in beginning inventory 0   Units produced 2,770   Units sold 2,520   Units in ending inventory 250   Variable costs per unit:   Direct materials $51   Direct labor $20   Variable manufacturing overhead $10   Variable selling and administrative $12   Fixed costs:   Fixed manufacturing overhead $96,950   Fixed selling and administrative expenses $35,280 The total gross margin for the month under absorption...
A manufacturing company that produces a single product has provided the following data concerning its most...
A manufacturing company that produces a single product has provided the following data concerning its most recent month of operations: Selling price ........................................................... $100 Units in beginning inventory .......................... 0 Unit produced ...................................................... 5,500 Unit sold ................................................................. 5,400 Unit in ending inventory ................................... 100 Variable costs per unit: Direct materials .............................................. $23 Direct labor ...................................................... $25 Variable manufacturing overhead ........... $ 2 Variable selling and administrative ......... $ 9 Fixed costs: Fixed manufacturing overhead .................. $137,500 Fixed selling and administrative...
A manufacturing company that produces a single product has provided the following data concerning its most...
A manufacturing company that produces a single product has provided the following data concerning its most recent month of operations: Selling price $ 140 Units in beginning inventory 0 Units produced 3,150 Units sold 2,760 Units in ending inventory 390 Variable costs per unit: Direct materials $ 47 Direct labor $ 18 Variable manufacturing overhead $ 10 Variable selling and administrative expense $ 19 Fixed costs: Fixed manufacturing overhead $ 107,100 Fixed selling and administrative expense $ 24,840 The total...
10. A manufacturing company that produces a single product has provided the following data concerning its...
10. A manufacturing company that produces a single product has provided the following data concerning its most recent month of operations: Selling price ........................................................... $100 Units in beginning inventory .......................... 0 Unit produced ...................................................... 5,500 Unit sold ................................................................. 5,400 Unit in ending inventory ................................... 100 Variable costs per unit: Direct materials .............................................. $23 Direct labor ...................................................... $25 Variable manufacturing overhead ........... $ 2 Variable selling and administrative ......... $ 9 Fixed costs: Fixed manufacturing overhead .................. $137,500 Fixed selling and...
A manufacturing comany that produces a single product has provided the following data concerning its most...
A manufacturing comany that produces a single product has provided the following data concerning its most recent month of operations Production Volume 6000 Units 7000 Units Direct Material 194,400 226,800 Direct Labor 74,400 86,800 Manufacturing Overhead 758,400 779,800 Selling Price 120 Units in beginning inventory 0 units produced 7100 units sold 6800 units in ending inventory 300 variable labor cost per unit direct materials 42 direct labor 33 variable manufacturing overhead 5 variable selling and administrative 11 fixed cost fixed...
last oneee i think A manufacturing company that produces a single product has provided the following...
last oneee i think A manufacturing company that produces a single product has provided the following data concerning its most recent month of operations: Selling price $ 163 Units in beginning inventory 0 Units produced 10,600 Units sold 9,800 Units in ending inventory 800 Variable costs per unit: Direct materials $ 52 Direct labor $ 47 Variable manufacturing overhead $ 11 Variable selling and administrative expense $ 9 Fixed costs: Fixed manufacturing overhead $ 318,000 Fixed selling and administrative expense...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT