Question

In: Accounting

Current Designs Problem 5 Bill Johnson, sales manager, and Diane Buswell, controller, at Current Designs are...

Current Designs Problem 5

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® $230 per kayak
Resin and supplies $190 per kayak
Finishing kit (seat, rudder, ropes, etc.) $160 per kayak
Labor $450 per kayak
Selling and administrative expenses—variable $400 per kayak
Selling and administrative expenses—fixed $172,400 per year
Manufacturing overhead—fixed $280,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,300.
Calculate variable costs per unit.
Variable costs $ per unit
Determine the unit contribution margin.
Contribution margin $ per unit
Using the unit contribution margin, determine the break-even point in units for this product line.
Break-even point units
Assume that Current Designs plans to earn net income of $378,450 on this product line. Using the unit contribution margin, calculate the number of units that need to be sold to achieve this goal.
Number of units to be sold units
Based on the most recent sales forecast, Current Designs plans to sell 1,000 units of this model. Calculate the margin of safety and the margin of safety ratio. (Round percentage to 1 decimal place, 25.5%.)
Margin of safety $
Margin of safety ratio %
Click if you would like to Show Work for this question:

Open Show Work

Solutions

Expert Solution

Answer :-

· All working forms part of the requirements

· Requirement 1,2 and 3

A

Selling Price per kayak

$2,300

Variable cost per kayak:

Kevlar

$230

Resin & Supplies

$190

Finishing kit

$160

Labore

$450

Selling & Admin expense

$400

B

Total Variable cost per kayak

$1,430

[Requirement 1]

C = A - B

Contribution margin per kayak

$870

[Requirement 2]

Fixed Cost:

Selling & Admin expense

$172,400

Manufacturing overhead

$280,000

D

Total Fixed Cost

$452,400

E = D/C

Break even point

520

[Requirement 3]

· Requirement 4

A

Total Fixed Cost

$452,400

B

Target net income

$378,450

C = A+B

Total contribution margin required

$830,850

D

Contribution margin per kayak

$870

E = C/D

Number of units to be sold

955

[Requirement 4]

· Requirement 5 and 6

A

Units to be sold

1000

B

Break even point

520

C = A - B

Margin of safety units

480

D = C x $ 2,300

Margin of Safety in dollar

$1,104,000

[Requirement 5]

E = (C/A) x 100

Margin of Safety Ratio

48%

[Requirement 6]


Related Solutions

CURRENT DESIGNS Diane Buswell is preparing the 2019 budget for one of Current Designs' kayaks. Extensive...
CURRENT DESIGNS Diane Buswell is preparing the 2019 budget for one of Current Designs' kayaks. Extensive meetings with members of the sales department and executive team have resulted in the following unit sales projections for 2019. Quarter 1 1,000 kayaks Quarter 2 1,500 kayaks Quarter 3 750 kayaks Quarter 4 750 kayaks Current Designs' policy is to have finished goods ending inventory in a quarter equal to 20% of the next quarter's anticipated sales. Preliminary sales projections for 2020 are...
Diane Buswell is preparing the 2019 budget for one of Current Designs' kayaks. Extensive meetings with...
Diane Buswell is preparing the 2019 budget for one of Current Designs' kayaks. Extensive meetings with members of the sales department and executive team have resulted in the following unit sales projections for 2019. Quarter 1 1,000 kayaks Quarter 2 1,500 kayaks Quarter 3 750 kayaks Quarter 4 750 kayaks Current Designs' policy is to have finished goods ending inventory in a quarter equal to 20% of the next quarter's anticipated sales. Preliminary sales projections for 2020 are 1,100 units...
Diane Buswell is preparing the 2019 budget for one of Current Designs' kayaks. Extensive meetings with...
Diane Buswell is preparing the 2019 budget for one of Current Designs' kayaks. Extensive meetings with members of the sales department and executive team have resulted in the following unit sales projections for 2019. Quarter 1 1,000 kayaks Quarter 2 1,500 kayaks Quarter 3 750 kayaks Quarter 4 750 kayaks Current Designs' policy is to have finished goods ending inventory in a quarter equal to 20% of the next quarter's anticipated sales. Preliminary sales projections for 2020 are 1,100 units...
Diane Buswel! is preparing the 201/ budget for one of Current Designs rotomolded kayaks Extensive meetings...
Diane Buswel! is preparing the 201/ budget for one of Current Designs rotomolded kayaks Extensive meetings with members of the sales department and executive team have resulted in the following unit sales projections for 2017. Quarte 1,000 kayaks Quarter 2 1,500 kayaks Quarter 3 750 kayaks Quarter 4 750 kayaks Current Designs policy is to have finished goods ending inventory in a quarter equal to 20% of the next quarters anticipated sales. Preliminary sales projections for 2018 are 1,100 units...
Your analysis for the Controller and Sales Manager is needed to suggest a different way of...
Your analysis for the Controller and Sales Manager is needed to suggest a different way of calculating the pricing of the pickles that may be lower. As part of your analysis, address the following items: Explain why some production costs are variable and some are fixed. Analyze the benefit of recalculating the cost of pickle production. How would you recalculate it? What would the result be? What is the benefit to the company of recalculating the cost? Analyze how financial...
The controller and sales manager are at odds over the pricing of a new product. What...
The controller and sales manager are at odds over the pricing of a new product. What major influences should be considered in pricing the new product?   Discuss each briefly
Problem 10-39A (Part Level Submission) The controller of Harrington Company estimates sales and production for the...
Problem 10-39A (Part Level Submission) The controller of Harrington Company estimates sales and production for the first four months of 2016 as follows: January February March April Sales $33,000 $43,300 $53,200 $24,000 Production in units 1,050 1,560 2,180 2,620 Sales are 40% cash and 60% on account, and 60% of credit sales are collected in the month of the sale. In the month after the sale, 40% of credit sales are collected. It takes 4 kg of direct material to...
Problem 10-39A (Part Level Submission) The controller of Harrington Company estimates sales and production for the...
Problem 10-39A (Part Level Submission) The controller of Harrington Company estimates sales and production for the first four months of 2016 as follows: January February March April Sales $34,500 $42,800 $53,100 $24,800 Production in units 1,090 1,530 2,020 2,520 Sales are 40% cash and 60% on account, and 60% of credit sales are collected in the month of the sale. In the month after the sale, 40% of credit sales are collected. It takes 4 kg of direct material to...
Problem 16-5 Amy Dyken, controller at Kingbird Pharmaceutical Industries, a public company, is currently preparing the...
Problem 16-5 Amy Dyken, controller at Kingbird Pharmaceutical Industries, a public company, is currently preparing the calculation for basic and diluted earnings per share and the related disclosure for Kingbird’s financial statements. Below is selected financial information for the fiscal year ended June 30, 2017. KINGBIRD PHARMACEUTICAL INDUSTRIES SELECTED BALANCE SHEET INFORMATION JUNE 30, 2017 Long-term debt Notes payable, 9% $1,000,000 8% convertible bonds payable 4,910,000 9% bonds payable 6,080,000 Total long-term debt $11,990,000 Shareholders’ equity Preferred stock, 7% cumulative,...
Problem 16-5 Amy Dyken, controller at Ivanhoe Pharmaceutical Industries, a public company, is currently preparing the...
Problem 16-5 Amy Dyken, controller at Ivanhoe Pharmaceutical Industries, a public company, is currently preparing the calculation for basic and diluted earnings per share and the related disclosure for Ivanhoe’s financial statements. Below is selected financial information for the fiscal year ended June 30, 2017. IVANHOE PHARMACEUTICAL INDUSTRIES SELECTED BALANCE SHEET INFORMATION JUNE 30, 2017 Long-term debt    Notes payable, 11% $1,010,000    8% convertible bonds payable 5,050,000    11% bonds payable 5,950,000      Total long-term debt $12,010,000 Shareholders’ equity    Preferred stock, 6% cumulative,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT