The Perkins Cove Yacht Company Case

The Perkin" rel="nofollow">ins Cove Yacht Company Case Order Description Answers should show all calculations usin" rel="nofollow">ing Excel . Answer & respond to question (A & B) with calculations in" rel="nofollow">in excel , with detailed explanation of each answer and calculations for each answer. A. The cost-allocation system Perkin" rel="nofollow">ins Cove has been usin" rel="nofollow">ing 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" rel="nofollow">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. Perkin" rel="nofollow">ins Cove’s production manager proposes allocatin" rel="nofollow">ing overhead by direct labor hours in" rel="nofollow">instead sin" rel="nofollow">ince the different models require different amounts of labor. How much overhead would be allocated to each yacht (per unit and in" rel="nofollow">in total) under this method? Show all supportin" rel="nofollow">ing calculations.