Cost Accounting Project

Cost Accounting Project: Implementing Activity-Based Costing at Precision Parts Inc.

Introduction

Precision Parts Inc. (PPI) currently employs a traditional, volume-based costing system to allocate manufacturing overhead to its three product lines: Widgets, Gadgets, and Doodads. This system allocates overhead based primarily on direct labor hours. However, with increasing product diversity and complexity, there is growing concern that this method may be distorting product costs, leading to inaccurate pricing strategies and potentially misinformed decisions regarding product profitability and resource allocation. This report investigates the limitations of PPI's current costing system and proposes the implementation of Activity-Based Costing (ABC) as a more accurate and insightful alternative.

Current Costing System: Analysis and Limitations

PPI's existing system allocates manufacturing overhead using a single, plant-wide overhead rate calculated as follows:

• Total Estimated Manufacturing Overhead: $1,500,000
• Total Estimated Direct Labor Hours: 150,000 hours
• Predetermined Overhead Rate: $1,500,000 / 150,000 hours = $10 per direct labor hour

This rate is then applied to each product line based on its consumption of direct labor hours. For example:

• Widgets: 50,000 direct labor hours * $10/hour = $500,000 overhead allocated.
• Gadgets: 70,000 direct labor hours * $10/hour = $700,000 overhead allocated.
• Doodads: 30,000 direct labor hours * $10/hour = $300,000 overhead allocated.

The primary limitation of this approach is its reliance on a single cost driver (direct labor hours) that may not accurately reflect the consumption of overhead resources by different products. Products that are complex, require significant setup, or involve extensive machine processing but relatively little direct labor may be undercosted, while simpler, labor-intensive products might be overcosted. This can lead to strategic errors, such as setting prices too low for complex products, thereby eroding profitability, or too high for simpler products, making them uncompetitive.

Activity-Based Costing (ABC): Methodology and Implementation

ABC seeks to overcome the limitations of traditional costing by identifying specific activities that consume overhead resources and assigning costs to products based on their consumption of these activities. The implementation process involves several key steps:

1. Identify Major Activities: Through interviews with production supervisors and analysis of operational processes, the following key activities consuming manufacturing overhead at PPI were identified:

• Machine Setup
• Machine Processing
• Quality Inspection
• Material Handling
• Production Engineering Support

1. Assign Costs to Activities: Overhead costs are traced to the activities that cause them. For instance, the costs associated with machine operators performing setups are assigned to the 'Machine Setup' activity pool. This requires a more detailed breakdown of the $1,500,000 overhead budget.

• Machine Setup Costs: $250,000
• Machine Processing Costs: $700,000
• Quality Inspection Costs: $200,000
• Material Handling Costs: $150,000
• Production Engineering Support: $200,000
• Total: $1,500,000

1. Identify Cost Drivers: A cost driver is a factor that causes a change in the cost of an activity. Appropriate cost drivers for the identified activities are:

• Machine Setup: Number of setups
• Machine Processing: Machine hours
• Quality Inspection: Number of inspections
• Material Handling: Number of material moves
• Production Engineering Support: Number of engineering change orders

1. Calculate Activity Rates: The cost per unit of each cost driver is calculated by dividing the total cost of the activity by the total volume of its cost driver.

• Machine Setup Rate: $250,000 / 1,000 setups = $250 per setup
• Machine Processing Rate: $700,000 / 70,000 machine hours = $10 per machine hour
• Quality Inspection Rate: $200,000 / 2,000 inspections = $100 per inspection
• Material Handling Rate: $150,000 / 1,500 moves = $100 per move
• Production Engineering Support Rate: $200,000 / 100 change orders = $2,000 per change order

1. Assign Costs to Products: The calculated activity rates are then used to assign overhead costs to products based on their consumption of each activity.

Data for Product Lines (Hypothetical)

| Metric | Widgets | Gadgets | Doodads | Total | | :-------------------------- | :------ | :------ | :------ | :------ | | Direct Labor Hours | 50,000 | 70,000 | 30,000 | 150,000 | | Machine Hours | 15,000 | 35,000 | 20,000 | 70,000 | | Number of Setups | 200 | 400 | 400 | 1,000 | | Number of Inspections | 500 | 1,000 | 500 | 2,000 | | Number of Material Moves | 300 | 600 | 600 | 1,500 | | Number of Engineering Orders| 20 | 50 | 30 | 100 |

Overhead Allocation Comparison: Traditional vs. ABC

Using the data above, we can compare the overhead allocated to each product line under both methods:

Traditional Costing Allocation:

• Widgets: $500,000 (as calculated previously)
• Gadgets: $700,000
• Doodads: $300,000

Activity-Based Costing Allocation:

• Widgets:
• Setup: 200 setups * $250/setup = $50,000
• Processing: 15,000 hrs * $10/hr = $150,000
• Inspection: 500 insp * $100/insp = $50,000
• Handling: 300 moves * $100/move = $30,000
• Engineering: 20 orders * $2,000/order = $40,000
• Total Widgets ABC Overhead: $320,000

• Gadgets:
• Setup: 400 setups * $250/setup = $100,000
• Processing: 35,000 hrs * $10/hr = $350,000
• Inspection: 1,000 insp * $100/insp = $100,000
• Handling: 600 moves * $100/move = $60,000
• Engineering: 50 orders * $2,000/order = $100,000
• Total Gadgets ABC Overhead: $710,000

• Doodads:
• Setup: 400 setups * $250/setup = $100,000
• Processing: 20,000 hrs * $10/hr = $200,000
• Inspection: 500 insp * $100/insp = $50,000
• Handling: 600 moves * $100/move = $60,000
• Engineering: 30 orders * $2,000/order = $60,000
• Total Doodads ABC Overhead: $470,000

Summary of Overhead Allocation:

| Product | Traditional Costing | Activity-Based Costing | Difference | | :-------- | :------------------- | :----------------------- | :--------- | | Widgets | $500,000 | $320,000 | -$180,000 | | Gadgets | $700,000 | $710,000 | +$10,000 | | Doodads | $300,000 | $470,000 | +$170,000 | | Total | $1,500,000 | $1,500,000 | $0 |

Analysis of Results and Implications

The comparison reveals significant cost distortions under the traditional system. Widgets, which are labor-intensive but require fewer setups and less engineering support relative to their direct labor hours, appear to be significantly overcosted by $180,000. Conversely, Doodads, which require a disproportionately high number of setups and engineering support despite lower direct labor hours, are substantially undercosted by $170,000. Gadgets show a minor increase in allocated overhead.

These findings have critical implications:

• Pricing Decisions: The traditional system might lead PPI to price Widgets too high, making them less competitive, and Doodads too low, eroding profit margins on a product that consumes more resources than recognized. ABC provides a more accurate basis for setting prices that reflect true costs.
• Product Profitability: The profitability analysis of each product line will be dramatically different under ABC. Widgets may be more profitable than previously thought, while Doodads may be less profitable or even loss-making, prompting a review of their strategic importance.
• Operational Efficiency: ABC highlights the cost drivers associated with specific activities. PPI can now focus improvement efforts on reducing the costs of high-consumption activities, such as minimizing setups for Doodads or optimizing inspection processes.
• Resource Allocation: Management can make better decisions about where to invest resources. For example, investing in process improvements for Doodad production might yield greater cost savings than anticipated.

Recommendations

Based on this analysis, it is strongly recommended that Precision Parts Inc. transition to an Activity-Based Costing system. This transition should be managed carefully, involving:

1. Phased Implementation: Consider a phased rollout, perhaps starting with one product line or department, to refine the process and train personnel.
2. System Integration: Ensure that the new ABC system can be integrated with existing accounting and enterprise resource planning (ERP) systems for efficient data collection and reporting.
3. Continuous Monitoring: ABC is not a one-time project. Activities, cost drivers, and rates should be reviewed and updated regularly (e.g., annually) to reflect changes in operations and cost structures.
4. Managerial Training: Provide comprehensive training to managers and relevant staff on how to interpret and utilize ABC data for decision-making.

Conclusion

The implementation of Activity-Based Costing offers Precision Parts Inc. a significantly more accurate view of its product costs. By identifying and assigning overhead costs based on the activities that drive them, ABC provides the granular data necessary for informed pricing, profitability analysis, and strategic decision-making. While the initial implementation requires effort, the long-term benefits of improved efficiency and profitability justify the transition from the current, potentially misleading, traditional costing system.