Calculate the cost of one custom odawa yacht

Assignment Help Financial Management
Reference no: EM131883831

The Sturgeon Bay Yacht Company Case

Sturgeon Bay Yacht Company produces three models of yachts. All are 44 feet long.  One is a standard Fiberglass model with nylon sails and a fixed keel made of lead and fiberglass named the Ste. Marie.  It comes with a standard depth finder, compass and 20 horsepower diesel auxiliary motor.  It sells for $120,000.

The Mackinac model has upgrades with radar, GPS nautical charts, enhanced batteries, and Teflon coated carbon fiber sails. The engine produces 100 horsepower and can run a cabin heater.  It can completely recharge the battery in less than an hour.  The Mackinac sells for $200,000.

The Odawa model is a custom-made with a deck made from teak and a cabin constructed from special woods. The sails are made from the traditional flax based canvass.   The hull is from specially cut oak from local forests.  It has the look of a vessel constructed in 1850 by a quality shipyard with 2018 comforts and safety.  The Odawa sells for $800,000.  Workers who build the Odawa are specialty craftsmen.  They earn twice the hourly rate of those working on the two standard models.  Note: Labor rate is fully loaded for benefits.

Most of Sturgeon Bay Yacht's sales come from the Ste. Marie and the Mackinac, but sales of the Odawa model have been growing.  Below is the company's sales, production, and cost information for last year:

Yacht

Ste. Marie

Mackinac

Odawa

Volume

50

100

20

Price

$120,000

$200,000

$800,000

Unit costs

     

Direct Materials

$30,000

$82,000

$250,000

Direct Labor

$36,000

$51,000

$440,000

Manufacturing Overhead*

$27,000

$27,000

$27,000

Total Unit Cost

$93,000

$160.000

$717,000

Unit Gross Profit

$27,000

$40,000

$83,000

       

Direct Labor Hours

1,000

1000

4750

Rate per Hour

$36.00

$51.00

$92.63

Manufacturing overhead* is made up as follows:

Depreciation

$2,100,000

Maintenance

$800,000

Purchasing

$180,000

Inspection

$350,000

Indirect Materials

$290,000

Supervision

$800,000

Supplies

$70,000

Total Manufacturing Overhead Cost

$4,590,000

*These manufacturing overhead costs are fixed in nature: they do not vary with the volume of manufacturing activity.

The company allocates overhead costs using the traditional method. Its activity base is unit volume. The predetermined overhead rate, based on 170 total yachts, is $27,000 per yacht ($4,590,000 ÷ 170 yachts). Marlin Perkins, president of Sturgeon Bay Yacht, is concerned that the traditional cost-allocation system the company is using may not be generating accurate information and that the selling price of the custom Odawa may not be covering its true cost.

Questions:

A. The cost-allocation system Sturgeon Bay has been using allocates over 88% of overhead costs to the Ste. Marie and the Kennebunk because 88% of yachts produced were these two models. How much overhead was allocated, in total, to each of the three models last year? Discuss why this might not be an accurate way to assign overhead costs to products.

B. Sturgeon Bay's production manager proposes allocating overhead by direct labor hours instead since the different models require different amounts of labor. How much overhead would be allocated to each yacht (per unit and in total) under this method? Show all supporting calculations.

C. How would the use of more than one cost pool improve Sturgeon Bay Yacht's cost allocation?

D. Sturgeon Bay Yacht's controller developed the following data for use in activity-based costing:

Manufacturing Overhead

Amount

Cost Driver

Goose Rocks

Mackinac

Odawa

Depreciation

$2,100,000

Square Feet

20,000

30,000

30,000

Maintenance

$800,000

Direct Labor Hours

50,000

100,000

95,000

Purchasing

$180,000

# of Purchase Orders

1,500

1,500

6,000

Inspection

$350,000

# of Inspections

400

800

2,000

Indirect

Materials

$290,000

Units Manufactured

50

100

20

Supervision

$800,000

# of Inspections

400

800

2.000

Supplies

$70,000

Units Manufactured

50

100

20

Total

$4,590,000

       

Use activity-based costing to allocate the costs of overhead per unit and in total to each yacht. Show all supporting calculations. It is appropriate to use an excel document to do your computations in Excel.

E. Calculate the cost of one custom Odawa yacht using activity-based costing.

F. Why are the costs different between the traditional method and the activity-based method? 

G. At the current selling price, is the company covering its true cost of production of the Odawa? Briefly discuss.

H. What should be the price that Sturgeon Bay Yacht Company charges for the Odawa? Assume that the Odawa should have the same profit margin as the Mackinac. Show all calculations.

I. What should Sturgeon Bay Yacht Co. do if the quantity of the Odawa yachts sold at the new price falls to 10 per year?

J. What should Sturgeon Bay Yacht Co. do about the situation if the price of the Odawa cannot exceed $800,000?

K. At a selling price of $800,000 each, what is the breakeven unit volume for the Odawa? 

L. What are the lessons learned from this case?

Verified Expert

Case study on activity based costing for a company making yachts is solved. Complicated costing model on excel has been prepared. Break-even point analysis has also been done.

Reference no: EM131883831

Questions Cloud

What is receivables float : Name at least two different types of inventory valuation methods. Discuss the advantages and disadvantages of each method.
Required return exceed foley required return : By how much does Beale's required return exceed Foley's required return?
What is the depreciation expense reported for the equipment : Fusion Co. uses the double declining balance depreciation method On April 1, 2011, Fusion Co. bought a equipment for $24,000. They estimate the equipment.
What is the cash flow break-even quantity : What is the cash flow break-even quantity? What is the DOL at the financial break-even quantity?
Calculate the cost of one custom odawa yacht : The Sturgeon Bay Yacht Company Case - Calculate the cost of one custom Odawa yacht using activity-based costing
Identify the primary methods used to allocate joint costs : Regarding joint cost allocation, discuss the following: Identify the two primary methods used to allocate joint costs.
What transfer would take place at the settlement date : If in 3 months, Libor decreased to 4%, what transfer would take place at the settlement date?
Eliminate the itemized deduction for charitable giving : Personal Income Tax Reforms Examine the following proposed tax reforms. Evaluate them according to the following three principles for optimal taxation.
The hsbc futures contract is mispriced : Demonstrate why you believe the HSBC futures contract is mispriced.

Reviews

len1883831

2/28/2018 11:21:50 PM

Choose MY CLASSES, then choose: DMBA 620 9042 Effective Financial and Operations. Then choose CONTENT: then WEEK 5. Yacht company case. all instruction are attached and all readings are in the login page I gave access to. Use activity-based costing to allocate the costs of overhead per unit and in total to each yacht. Show all supporting calculations. It is appropriate to use an excel document to do your computations in Excel.

Write a Review

Financial Management Questions & Answers

  Foreign company acquisition

Acquisition by a foreign company and the effects of that decision and the results of foreign exchange in Euro and the exchange rate differences.

  Financial management for profit and non profit organizations

In this essay, we are going to discuss the issues of financial management in a non-profit organisation.

  Method for estimating a venture''s value

Evaluate venture's present value, cash and surplus cash and basic venture capital.

  Replacement analysis

This document show the Replacement Analysis of modling machine. Is replacement give profit to company or not?

  Business finance task - capital budgeting

Your company is considering using the payback period for capital-budgeting. Discuss the advantages and disadvantages of this technique.

  Analysis of the investment

In this project, you will focus on one of these: the additional cost resulting from the purchase of an apple press (a piece of equipment required to manufacture apple juice).

  Conduct a what-if analysis

Review the readings and media for this unit, including the Anthony's Orchard case study media. Familiarise yourself with the Anthony's Orchard company and its current situation.

  Determine operational expenditures

Organisations' behaviour is guided by financial data. In the short term, such data will help determine operational expenditures; in the long term, historical data may help generate forecasts aimed at determining strategic plans. In both instances.

  Personal financial management

How much will you have left over each half year if you adopt the latter course of action?

  Sources of finance for expansion into new foreign markets

A quoted company is considering several long-term sources of finance for expansion into new foreign markets.

  Long term financial planning

This assignment is designed for analyze Long term financial planning begins with the sales forecast and the key input in the long term fincial planning.

  Explain the role of fincial manager

This assignment explain the role of fincial manager, function of manger. And what are the motives of financial manager.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd