Fairbanks Corporation produces two types of cell phone electronic chargers: wall chargers and car chargers.
The current traditional costing system allocates overhead costs using a plant-wide overhead rate based on direct labor hours. Since the two products are similar but require different parts and processes, the company controller believes that it might make sense to employ activity-based costing in order to get a better application of overhead expenses to the products produced.
Production expectations for 2017 are 17,000 wall chargers and 15,200 car chargers. The wall chargers take .5 hours to produce. The car chargers take .75 hours to produce.
The direct material and direct labor costs included in the two products are as follows:
Wall chargers use $3.75 of direct material per unit and $9.50 per hour of direct labor. Car chargers use $4.15 of direct material per unit and $9.50 per hour of direct labor. Each charger sells for $23.00.
Budgeted Total Factory Overhead for 2017:
Activity |
Est. OH Cost |
Est. Volume Levels |
Production setup |
$8,500 |
20 setups |
Materials handling |
$62,000 |
4,500 lbs. |
Packaging and shipping |
$120,000 |
6,400 boxes |
Total factory overhead |
$190,500 |
Fairbanks’ controller worked with the operations group to analyze the three overhead activities in order to effectuate activity-based costing. The estimates related to the two products’ requirements were:
Activity |
Wall Charger |
Car Charger |
Production setup |
35% |
65% |
Materials handling |
60% |
40% |
Packaging and shipping |
55% |
45% |
From the cost information provided, provide responses in Microsoft Excel to the following questions. For assistance with Microsoft Excel, please refer to Lynda.com in the CSU-Global Library (Links to an external site.)Links to an external site. for tutorials.
Computation of direct labor hours used:
Different drivers are used for activity based costing, hence difference in answer.
Other answer is correct. If your teacher requires equations and linked cells, this page ( https://www.cliffsnotes.com/study-guides/accounting/accounting-principles-ii/activity-based-costing/activity-based-vs-traditional-costing ) gives a quick rundown on how to calculate traditional and ABC overhead with a similar problem. There's also a paragraph at the bottom of the page that you can reword for question 7.
Fairbanks Corporation produces two types of cell phone electronic chargers: wall chargers and car chargers. The...
Fairbanks Corporation produces two types of cell phone electronic chargers: wall chargers and car chargers. The current traditional costing system allocates overhead costs using a plant-wide overhead rate based on direct labor hours. Since the two products are similar but require different parts and processes, the company controller believes that it might make sense to employ activity-based costing in order to get a better application of overhead expenses to the products produced. Production expectations for 2017 are 17,000 wall chargers...
E17.4 (LU 1, 2) Altex Inc. manufactures two products: car wheels and truck wheels. lo determine the amount of overhead to assign to each product line, the controller, Robert Hermann, has developed the following information. Assign overhead using traditional costing and ABC. Excel Car Truck Estimated wheels produced 40,000 10,000 Direct labor hours per wheel Total estimated overhead costs for the two product lines are $770,000. Instructions a. Compute the overhead cost assigned to the car wheels and truck wheels,...
please solve in excel/table format. thank you. E17.4 Altex Inc, manufactures two products: car wheels and truck wheels. To determine the amount of overhead to assign to each product line, the controller, Robert Hermann. has developed the following information. Car 40,000 Truck 10,000 Estimated wheels produced Direct labor hours per wheel Total estimated overhead costs for the two product lines are $770,000. Instructions (a) Compute the overhead cost assigned to the car wheels and truck wheels, assuming that direct labor...
Smoky Mountain Corporation makes two types of hiking boots--the Xtreme and the Pathfinder. Data concerning these two product lines appear below: Selling price per unit Direct materials per unit Direct labor per unit Direct labor-hours per unit Estimated annual production and sales Xtreme $ 115.00 $ 63.90 $12.00 1.2 DLHS 28,000 units Pathfinder $ 85.00 $ 51.00 $10.00 1.0 DHS 75,000 units Print The company has a traditional costing system in which manufacturing overhead is applied to units based on...
Smoky Mountain Corporation makes two types of hiking boots--the Xtreme and the Pathfinder. Data concerning these two product lines appear below: Selling price per unit Direct materials per unit Direct labor per unit Direct labor-hours per unit Estimated annual production and sales $ 88.00 $ 53.00 8.00 1.0 DLRS 70,000 unit 1.8 DLHS 23,000 units The company has a traditional costing system in which manufacturing overhead is applied to units based on direct labor-hours. Data concerning manufacturing overhead and direct...
Smoky Mountain Corporation makes two types of hiking boots-the Xtreme and the Pathfinder. Data concerning these two product lines appear below: Selling price per unit Direct materials per unit Direct labor per unit Direct labor-hours per unit Estimated annual production and sales Xtreme $ 120.00 $ 63.30 $ 17.00 1.7 DLHS 22,000 units Pathfinder $ 87.00 $ 52.00 $ 10.00 1.0 DLHS 76,000 units The company has a traditional costing system in which manufacturing overhead is applied to units based...
Smoky Mountain Corporation makes two types of hiking boots—the Xtreme and the Pathfinder. Data concerning these two product lines appear below: Selling price per unit Direct materials per unit Direct labor per unit Direct labor-hours per unit Estimated annual production and sales Xtreme $141.00 $ 64.50 $ 17.00 1.7 DLHS 23,000 units Pathfinder $ 91.00 $ 52.00 $ 10.00 1.0 DLHS 74,000 units The company has a traditional costing system in which manufacturing overhead is applied to units based on...
Smoky Mountain Corporation makes two types of hiking boots-the Xtreme and the Pathfinder. Data concerning these two product lines appear below: Selling price per unit Direct materials per unit Direct labor per unit Direct labor-hours per unit Estimated annual production and sales Xtreme $ 116.00 $ 64.00 $ 12.00 1.5 DLHS 29,000 units Pathfinder $ 80.00 $ 52.00 $ 8.00 1.0 DLHS 76,000 units The company has a traditional costing system in which manufacturing overhead is applied to units based...
Smoky Mountain Corporation makes two types of hiking boots-the Xtreme and the Pathfinder. Data concerning these two product lines appear below Xtreme $120.00 $ 63.50 $ 13.50 1.5 DLHS 24,000 units Pathfinder $ 92.00 $ 54.00 $ 9.00 1.0 DLHS 71,000 units Selling price per unit Direct materials per unit Direct labor per unit Direct labor-hours per unit Estimated annual production and sales The company has a traditional costing system in which manufacturing overhead is applied to units based on...
Smoky Mountain Corporation makes two types of hiking boots—the Xtreme and the Pathfinder. Data concerning these two product lines appear below: Xtreme Pathfinder Selling price per unit $ 121.00 $ 88.00 Direct materials per unit $ 64.70 $ 54.00 Direct labor per unit $ 10.80 $ 9.00 Direct labor-hours per unit 1.2 DLHs 1.0 DLHs Estimated annual production and sales 25,000 units 71,000 units The company has a traditional costing system in which manufacturing overhead is applied to units based...