email

[SOLVED] The Perkins Cove Yacht Company CasePerkins

[SOLVED] The Perkins Cove Yacht Company Case

Perkins Cove 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 Goose Rocks. It comes with a standard depth finder, compass and 20 horsepower diesel
auxiliary motor. It sells for $120,000.
The Kennebunkport 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 Kennebunkport
sells for $200,000.
The Ogunquit 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 Maine shipyard with 2016 comforts and safety. The Ogunquit sells for $800,000.
Workers who build the Ogunquit 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 Perkins Cove Yacht’s sales come from the Goose Rocks and the Kennebunkport, but
sales of the Ogunquit model have been growing. Below is the company's sales, production, and
cost information for last year:
Yacht Goose Rocks Kennebunkport Ogunquit
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,200,000
Maintenance $700,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). Richard Perkins, president of Perkins Cove 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 Ogunquit may not be covering its true cost.

Questions:

A. The cost-allocation system Perkins Cove has been using allocates over 88% of
overhead costs to the Goose Rocks 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. Perkins Cove’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 Perkins Cove Yacht's cost
allocation?
D. Perkins Cove Yacht's controller developed the following data for use in activity-based
costing:
Manufacturing
Overhead

Amount Cost
Driver

Goose
Rocks

Kennebunkport Ogunquit

Depreciation $2,200,000 Square
Feet

20,000 30,000 30,000

Maintenance $700,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 Ogunquit 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
Ogunquit? Briefly discuss.
H. What should be the price that Perkins Cove Yacht Company charges for the Ogunquit?
Assume that the Ogunquit should have the same profit margin as the Kennebunkport.
Show all calculations.
I. What should Perkins Cove Yacht Co. do if the quantity of the Ogunquit yachts sold at the
new price falls to 10 per year?
J. What should Perkins Cove Yacht Co. do about the situation if the price of the Ogunquit
cannot exceed $800,000?
K. At a selling price of $800,000 each, what is the breakeven unit volume for the Ogunquit?
L. What are the lessons learned from this case?



Need customized help? Order now
user img

honeyd


21-09-20 | 09:45:02

A and B
Overheads allocation under ABC approach
Sl.No Particulars Product Lines-Amount($) Total Note
Goose Rocks Kennebunkport Ogunquit
1 Depreciation      550,000.00         825,000.00      825,000.00        2,200,000.00 1
2 Maintenance      142,857.14         285,714.29      271,428.57           700,000.00 2
3 Purchasing          30,000.00             30,000.00      120,000.00           180,000.00 3
4 Inspection          43,750.00             87,500.00      218,750.00           350,000.00 4
5 Indirect Material          85,294.12         170,588.24          34,117.65           290,000.00 5
6 Supervision      100,000.00         200,000.00      500,000.00           800,000.00 4
7 Supplies          20,588.24             41,176.47            8,235.29              70,000.00 5
8 Total overheads      972,489.50       1,639,978.99    1,977,531.51
9 Volume                  50.00                   100.00                  20.00
10 Overhead per unit          19,449.79             16,399.79          98,876.58
11 Total overheads (Traditional approach):Allocating Fixed amount for all lines with no regard fo activity and profitability          27,000.00             27,000.00          27,000.00
12 Under/(Over absorbed)          -7,550.21           -10,600.21          71,876.58
13 Direct labour+Material          66,000.00         133,000.00      690,000.00
14 Total cost of production          85,449.79         149,399.79      788,876.58
15 Sale      120,000.00         2,00,000.00      800,000.00
16 Profit          34,550.21             50,600.21          11,123.42
Notes
1 No.of parts ( In the order of product lines mentioned above)
Total square feet =20000+30000+30000=80000 Sq.Ft 80000 Hours
2 No.of labour hours (In the order of product lines mentioned above)
Total labour hours=50000+100000+95000=245000 Hours 245000 Hours
3 No.of purchase orders ( In the order of product lines mentioned above)
Total orders=1500+1500+6000=9000 orders 9000 Orders
4 No.of inspections ( In the order of product lines mentioned above)
Total inspections=400+800+2000=3200 Inspections 3200 Inspections
5 No.of units manufatured (In the order of product lines mentioned above)
Total units manufatured=50+100+20=170 170 Units

Explanation
A)







C)





D) This is shown above under the various listed calculations

E True Cost of production of Ogunquit

Direct Material $250,000.00
Direct Labour $440,000.00
Manufacturing Overheads $98,876.76
Total Cost $788,876.76
Sale $800,000.00
Profit $11,123.24
F)




G Yes the Ogunquit covers costs and make a profit of = $11,123.24
H Profit Margin of Kennebunkport
Profit ------------40000
Cost--------------160000 ( Based on old method of costing) Percentage representation 25%
Percentage on cost is 25%

E) Price of Ogunuquit
True cost of production------788,876.58 $788,876.76
Add@25% on cost------------- 197,219.15 $197,219.15 986095.725
Price------------------------------$ 986,095.73 $986,095.91
I) If the quantity falls to 10
Decrease in production-------10
No.of labour hours released--4750*10=47500 hrs 47500 Hours



J Now we can use these hours in manufacturing Kennebunkport which has a higher profit margin, if the demand exist
or for Gooserocks based on the availability of demand

K



Break Even Analysis
Contribution =800000-250000-440000 110000
Fixed Assets 1977531.51
Break Even Volume 17.97755918 Approximately 18 Yachts


L)

user img

honeyd


21-09-20 | 09:46:55

a) Using single over-head to allocate costs does not hold for goods produced in an activity
When costs are driven by a range of production activities, different products costs are assigned according to these uses
So we have to allocate overheads in the usage ratio i.e. as per activity
ABC Approach provides realistic cost allocation i.e. correct costing and correct profitability
The profitability per unit on different classes is vitally different and each class needs to be assessed on cost-price relationship
c. Using more cost pools means that there is better allocation of resources.We have group overheads to assess individual plant costing structure . Group overhead will help in asssesment of profitability of each line. Furthermore it will help in creating efficient allocations depending on what drives the costs
The difference in overhead costs under both methods is due usage of single and different methods to allocate cost in traditional and ABC
d.The cost are allocated on a tailored basis rather than on a one-fits-all basis to ensures that the changes are incorporated in the activity based method
k.If the price of Ogunuquit can't exceed $ 800000 and assuming all other costs unavoidable then we have to reduce our profit margin in such way that final price is $ 8,00,0000
l.Appropriate costing system for cost allocation is required in production with differentiated line of activity to optimize resources through cost reduction and maximization of profits. Otherwise, usage of inappropriate costing structurre that does not utilize the full scope of resources will lower profitability.


Related Question