Please see excel spreadsheet

Activity-based Costing ProblemView more


Complete the attached excel spreadsheet.

Click the Assignment Files tab to submit your assignment.

Document Preview:

1050000 2350000 3600000 1400000 R&D activities fall into four pools with the following annual costs: Market Analysis Product Design Product Development Prototype Testing Activity analysis determines that the appropriate cost drivers and their usage for the four activities are: Cost Drivers Activities Total Estimated Drivers Hours of analysis Number of designs Number of products Number of tests 1500 hours 2500 designs 90 products 500 tests a) Compute the activity-based overhead rate for each pool. Use appropriate excel formulas to show your work b) How much cost would be charged to an in-house manufacturing department that consumed 1,800 hours of Show your work. market analysis time, was provided 280 designs relating to 10 products and requested 92 engineering tests? Total c) How much cost would serve as the basis for for pricing an R&D bid with an outside company on a contract that would consume 800 hours of analysis time, require 178 designs relating to 3 products, and result in 70 engineering tests? d) What is the benefit to Acme Manufacturing of applying activity-based costing to its R&D activity for both in-house and outside charging purposes? Acme Manufacturing Company of Portland, Oregon has a Research & Development department that currently provides services to in-house manufacturing departments. Other manufacuturers have expressed interested in using Acme’s R&D department for special projects. Management has decided to conduct an activity-based costing system in order to determine charges for both outside and in-house users of the department’s services. ???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????