Purchase Solution

Sample Question: Activity Based Costing

Not what you're looking for?

Ask Custom Question

1. Mahogany Manufacturing produces two types of entry doors: deluxe and standard. The assignment basis for support costs has direct labor dollars. For 2001, Mahogany compiled the following data for the two products.

Deluxe Standard
Sales units 50,000 400,000
Sales price per unit $650.00 $475.00
Direct material and labor costs per unit $180.00 $130.00
Manufacturing support costs per unit $80.00 $120.00

Last year, Mahogany Company purchased an expensive robotics system to allow for more decorative door products in the deluxe product line. The CFO suggested that an ABC analysis could be valuable to help evaluate a product mix and promotion strategy for the next sales campaign. She obtained the following ABC information for 2001:

ACTIVITY COST DRIVER COST TOTAL DELUXE STANDARD
Setups # setups $500,000 500 400 100
Machine related # of machine hours $44,000,000 600,000 300,000 300,000
Packing # shipments $5,000,000 250,000 50,000 200,000

a. Using the current system, what is the estimated:
i. Total cost of manufacturing one unit for each type of labor
ii. Profit per unit for each type of labor

b. Using the current system, estimated manufacturing support costs per unit are less for the deluxe door ($80 per unit) than the standard door ($120 per unit). What is the likely explanation for this?
c. Review machine related costs above. What is a likely explanation for this?
d. Using activity based costing data presented above:
i. Compute the cost driver rate for each support activity
ii. Compute the revised manufacturing support cost per unit for each type of entry door
iii. Compute the revised total cost to manufacture one unit of each type of entry door.

e. Is the deluxe door as profitable as the original data estimated? Why or why not?
f. What considerations need to be examined when determining a sales mix strategy?

Attachments
Purchase this Solution

Solution Summary

The total cost and profit of the current system is determined.

Solution Preview

Please see the atached excel file.
<br>
<br>Have used cell ...

Solution provided by:
Education
  • BE, Bangalore University, India
  • MS, University of Wisconsin-Madison
Recent Feedback
  • "Your explanation to the answers were very helpful."
  • "What does 1 and 0 means in the repair column?"
  • "Went through all of the formulas, excellent work! This really helped me!"
  • "try others as well please"
  • "Thank you, this helped a lot. I was not sure how to plug in those numbers to a formula. This was a great help. Now I have to figure out how to explain cost of capital is used in net present value analysis, and how cost of capital is used in net present value analysis. This stuff gets confusing."
Purchase this Solution


Free BrainMass Quizzes
MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.

Motivation

This tests some key elements of major motivation theories.

Learning Lean

This quiz will help you understand the basic concepts of Lean.

Understanding Management

This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.

Team Development Strategies

This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.