Simplifying the ABC System: Approximately Relevant ABC Systems 1. 2. 3. 4. 0.55 Patterson Company produces wafers for integrated circuits. Data for the most recent year are provided: Expected Consumption Ratios Activity Driver Wafer A Wafer B Inserting and sorting process activities: Developing test programs $ 45,000 Engineering hours 0.25 0.75 Making probe cards 61,000 Development hours 0.15 0.85 Testing products 700,000 Test hours 0.60 0.40 Setting up batches 135,000 Number of batches 0.45 5. Engineering design 90,000 Number of change orders 0.20 0.80 6. Handling wafer lots 300,000 Number of moves 0.40 0.60 7. Inserting dies 1,000,000 Number of dies 0.75 0.25 Procurement process activities: Purchasing materials 300,000 Number of purchase orders 0.20 0.80 9. Unloading materials 62,000 Number of receiving orders 0.30 0.70 10. Inspecting materials 80,000 Inspection hours 0.60 0.40 11 Moving materials 200,000 Distance moved 0.45 12. Paying suppliers 32,000 Number of invoices 0.30 0.70 Total activity cost $ 3,005,000 8. 0.55 $2,253,750 $751,250 Unit-level (plantwide) cost assignmenta Activity cost assignment $1,648,850 $1,356,150 Required: 1. Using the five most expensive activities, calculate the overhead cost assigned to each product. Assume that the costs of the other activities are assigned in proportion to the cost of the five activities. If required, round your answers to the nearest dollar. Activity Budgeted Activity Cost Testing products Handling Wafer lots Inserting dies Purchasing materials Moving materials Total activity cost 1,150,000 Approx. ABC Cost Wafer A Wafer B 2. Calculate the error relative to the fully specified ABC product cost. Round your calculation to three decimal places and the percentage answer to one decimal place. Relative error Wafer A % Wafer B 3. What if activities 1, 2, 5, and 8 each had a cost of $496,000 and the remaining activities had a cost of $127,625 each? Calculate the cost assigned to Wafer A by a fully specified ABC system and then by an approximately relevant ABC approach. Cost by a fully specified ABC system Cost by an approximately relevant ABC approach 2. 4. Patterson Company produces wafers for integrated circuits. Data for the most recent year are provided: Expected Consumption Ratios Activity Driver Wafer A Wafer B Inserting and sorting process activities: 1. Developing test programs $ 45,000 Engineering hours 0.25 0.75 Making probe cards 61,000 Development hours 0.15 0.85 3. Testing products 700,000 Test hours 0.60 0.40 Setting up batches 135,000 Number of batches 0.55 0.45 Engineering design 90,000 Number of change orders 0.20 0.80 6. Handling wafer lots 300,000 Number of moves 0.40 0.60 Inserting dies 1,000,000 Number of dies 0.25 Procurement process activities: Purchasing materials 300,000 Number of purchase orders 0.20 0.80 9. Unloading materials 62,000 Number of receiving orders 0.30 0.70 10. Inspecting materials 80,000 Inspection hours 0.60 0.40 11. Moving materials 200,000 Distance moved 0.55 0.45 12 Paying suppliers 32,000 Number of invoices 0.30 0.70 Total activity cost $ 3,005,000 5. 7. 0.75 8. $2,253,750 $751,250 Unit-level (plantwide) cost assignmenta Activity cost assignment $1,648,850 $1,356,150 a b Calculated using number of dies as the single unit-level driver. Calculated by multiplying the consumption ratio of each product by the cost of each activity. Required: 1. Using the five most expensive activities, calculate the overhead cost assigned to each product. Assume that the costs of the other activities are assigned in proportion to the cost of the five activities. If required, round your answers to the nearest dollar. Activity Budgeted Activity Cost Testing products Handling Wafer lots Inserting dies Purchasing materials Moving materials Total activity cost 1,150,000 Approx. ABC Cost Wafer A Wafer B 2. Calculate the error relative to the fully specified ABC product cost. Round your calculation to three decimal places and the percentage answer to one decimal place. Relative error Wafer A Wafer B 3. What if activities 1, 2, 5, and 8 each had a cost of $496,000 and the remaining activities had a cost of $127,625 each? Calculate the cost assigned to Wafer A by a fully specified ABC system and then by an approximately relevant ABC approach. Cost by a fully specified ABC system Cost by an approximately relevant ABC approach
