Hello,

I need help on this attached assignment. Please take a look at the attached and advise on step by step approach to solve the questions.

Thank you

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 Volume Price Unit costs Direct Materials Direct Labor Manufacturing Overhead* Total Unit Cost Unit Gross Profit Direct Labor Hours Rate per Hour Goose Rocks 50 $120,000 Kennebunkport 100 $200,000 Ogunquit $30,000 $36,000 $27,000 $82,000 $51,000 $27,000 $250,000 $440,000 $27,000 $93,000 $27,000 $160.000 $40,000 $717,000 $83,000 1,000 $36.00 1000 $51.00 4750 $92.63 20 $800,000 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 direct labor hours. The predetermined overhead rate, based on 6,750 direct labor hours, is $680 per direct labor hour ($4,590,000 6,750 direct labor hours). 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 direct labor hours were spent on these three models. How much overhead was allocated to each of the three models last year? Discuss why this might not be an accurate way to assign overhead costs to products. B. How would the use of more than one cost pool improve Perkins Cove Yacht's cost allocation? C. Perkins Cove Yacht's controller developed the following data for use in activity-based costing: Manufacturin g Overhead Depreciation Amount Cost Driver $2,000,000 Square Feet Direct Labor Hours # of Purchase Orders # of Inspections Units Manufacture d # of Inspections Units Manufacture d Maintenance $700,000 Purchasing $180,000 Inspection $350,000 Indirect Materials $290,000 Supervision $800,000 Supplies Total $70,000 Goose Rocks Kennebunkpor t Ogunquit 20,000 30,000 30,000 50,000 100,000 95,000 1,500 1,500 6,000 400 800 2,000 50 100 20 400 800 2.000 50 100 20 $4,590,000 D. 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