Requirements:
1. Based on all of the date provided, compute the cost driver rates for each of the four activities.
2. Compute the per unit product costs for each of the four products.Compute this cost using ABC allocation for overhead. Show the computation for each per unit product cost in detail.
3. Prepare a "Monthly Profit Report", like the one provided on page 4 of this packet. Create this report using the results of your ABC overhead allocation.
4. Prepare a written "Management Report" that explains to the management team what Activity Based Costing is, how it was used to generate the Monthly Profit Report (from requirement #3). Explain why the profit for each product is different when comparing the Traditional report with the ABC report. Explain what the company might consider doing, based on all of this information, to stop the erosion of company profits. Defend your recommendations with data.
Additional Consideration:
Mr. Port wonders what would happen to costs if plant capacity was shifted from 20,000 machine-hours a month to 40,000 machine-hours per month.
Requirements:
5. Compute the new cost per unit for each of the products considering the increase in capacity. Show the computation for each per unit product cost in detail.
6. What is the cost of the unused capacity if it is assumed that the company has 40,000 machine-hours of capacity but it using 20,000 machine-hours? Amend your "Management Report" to include a discussion on how to best use the additional capacity.