Reference no: EM132162848

Questions:

A Part one: Create an excel file to show how much overhead was allocated to each of the three yacht models last year. Briefly explain the advantages and disadvantages of the current overhead allocation system.

B What would be the advantages and disadvantages of using more than one cost pool? What cost pools would you recommend if more than one pool is used and explain why you would recommend those pools (answer in Excel file, but no calculation required)

C Perkins Cove production manager proposes allocating overhead by direct labor hours since the different models of yachts require different amounts of labor Show in your created excel file (response to question A above) how much overhead would be allocated to each yacht (per unit and in total) under this direct labor allocation Show all supporting calculations, in a comparison table (comparing method A with method C)

D. Perkins Cove Yacht's controller developed the following data for use in activity-based costing (method D):

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.

Manufacturing overhead* is made up as follows: