Question

Bill Johnson, sales manager, and Diane Buswell, controller, at Current Designs are beginning to analyze the cost considerations for one of the composite models of the kayak division. They have provided the following production and operational costs necessary to produce one composite kayak.

Kevlar $250 per kayak
Resin and supplies $100 per kayak
Finishing kit (seat, rudder, ropes, etc.) $170 per kayak
Labor $420 per kayak
Selling and administrative expenses—variable $400 per kayak
Selling and administrative expenses—fixed $119,700 per year
Manufacturing overhead—fixed $240,000 per year
Bill and Diane have asked you to provide a cost-volume-profit analysis, to help them finalize the budget projections for the upcoming year. Bill has informed you that the selling price of the composite kayak will be $2,000.
(a) Calculate variable costs per unit.
Variable cost per unit $
Bill Johnson, sales manager, and Diane Buswell, co
(b) Determine the contribution margin per unit.
Contribution margin per unit $
Bill Johnson, sales manager, and Diane Buswell, co
(c) Using the contribution margin per unit, determine the break-even point in units for this product line.
Break-even point
Bill Johnson, sales manager, and Diane Buswell, co
units
(d) Assume that Current Designs plans to earn $270,600 on this product line. Using the contribution margin per unit, calculate the number of units that need to be sold to achieve this goal.
Number of units
Bill Johnson, sales manager, and Diane Buswell, co
units
(e) Based on the most recent sales forecast, Current Designs plans to sell 1,000 units of this model. Using your results from part (c), calculate the margin of safety and the margin of safety ratio. (Round margin of safety ratio to 1 decimal place, e.g. 25.5%.)
Margin of safety $
Bill Johnson, sales manager, and Diane Buswell, co
Margin of safety ratio
Bill Johnson, sales manager, and Diane Buswell, co
%
By accessing this Question Assistance, you will learn while you earn points based on the Point Potential Policy set by your instructor.
(a) Calculate variable costs per unit.
Variable cost per unit $
Bill Johnson, sales manager, and Diane Buswell, co
(b) Determine the contribution margin per unit.
Contribution margin per unit $
Bill Johnson, sales manager, and Diane Buswell, co
(c) Using the contribution margin per unit, determine the break-even point in units for this product line.
Break-even point
Bill Johnson, sales manager, and Diane Buswell, co
units
(d) Assume that Current Designs plans to earn $270,600 on this product line. Using the contribution margin per unit, calculate the number of units that need to be sold to achieve this goal.
Number of units
Bill Johnson, sales manager, and Diane Buswell, co
units
(e) Based on the most recent sales forecast, Current Designs plans to sell 1,000 units of this model. Using your results from part (c), calculate the margin of safety and the margin of safety ratio. (Round margin of safety ratio to 1 decimal place, e.g. 25.5%.)
Margin of safety $
Bill Johnson, sales manager, and Diane Buswell, co
Margin of safety ratio
Bill Johnson, sales manager, and Diane Buswell, co
%

Answer 1

a. Particulars Amount$

Kevlar per kayak 250

Resin and Supplies per kayak 100

Finishing Kit per kayak 170

Labor per Kayak 420

Variable selling & admin. exp. per kayak 400

Total variable cost per kayak 1,340

b. Contribution margin per unit = Selling price per unit – Variable cost per unit

Contribution margin per unit = $2,000 per unit - $1,340 per unit

Contribution margin per unit = $660 per unit

c. Break-even point in units = Total fixed costs/ Contribution margin per unit

Break-even point in units = ($ 119,700 + $240,000) / $660 per unit

Break-even point in units = 545 units

d. Number of units to be sold = (Total Fixed cost + Target Profit)/ Contribution margin per unit

Number of units to be sold= ($119,700 + $240,000 + $270,600) / $660 per unit

Number of units to be sold = 955 units

So therefore, the company needs to sell 955 units in order to achieve target profit of $270,600.