The Perkins Cove Yacht Company Case

Order Description

Answers should show all calculations using Excel . Answer & respond to question (A & B) with calculations in excel , with detailed explanation of each answer and

calculations for each answer.

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.