Alonzo Inc. manufactures two products: car wheels and truck wheels. To determine the amount of overhead to assign to each product line, the controller, YuYu Ortega, has developed the following information:
Car | Truck | |||
---|---|---|---|---|
Estimated wheels produced | 43,000 | 20,000 | ||
Direct labour hours per wheel | 2 | 4 |
Total estimated overhead costs for the two product lines are $ 830,000.
A) Calculate the overhead cost assigned to the car wheels and truck wheels, assuming that direct labour hours are used to allocate overhead costs.
Car wheels | $ | ||
---|---|---|---|
Truck wheels | $ | ||
Total overhead | $ |
B) YuYu is not satisfied with the traditional method of allocating overhead because he believes that most of the overhead costs relate to the truck wheel product line because of its complexity. He therefore develops the following three activity cost pools and related cost drivers to better understand these costs:
Activity Cost Pools | Estimated Use of Cost Drivers | Estimated Overhead Costs | ||||
---|---|---|---|---|---|---|
Setting up machines | 800 | set-ups | $ 408,000 | |||
Assembling | 37,000 | labour hours | 370,000 | |||
Inspection | 104 | inspections | 52,000 |
Calculate the activity-based overhead rates for these three cost pools.
Cost Pool | Rate | ||
---|---|---|---|
Setting up machines | $ | per set-up | |
Assembling | $ | per labour hr | |
Inspection | $ | per inspection |
WORKING | ANS | |
TOTAL LABOUR HRS | (43,000*2)+(20,000*4) | =166,000 |
CAR WHEELS | (830,000/166,000)*(43,000*2) | =430,000 |
TRUCK WHEELS | (830,000/166,000)*(20,000*4) | =400,000 |
TOTAL OVERHEAD | (430,000+400,000) | =830,000 |
B
ANS | WORKING | ||
COST POOL | RATE | ||
SETTING UP MACHINES | 510 | PER SET-UP | 40,800/800 |
ASSEMBLING | 10 | PER LABOUR HR | 370,000/37,000 |
INSPECTION | 500 | PER INSPECTION | 52,000/104 |
Compute the cost that is assigned to the car wheels and truck wheels product lines using an activity-based costing system, given the following information. Estimated Use of Cost Drivers per Product Car Truck Number of setups Direct labor hours 200 40,000 100 800 27,000 1.100 Number of inspections Car Wheels Truck Wheels Setting up machines $ Assembling Inspection Total cost assigned Altex Inc. manufactures two products: car wheels and truck wheels. To determine the amount of overhead to assign to...
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 Truck Estimated wheels produced Direct labor hours per wheel 39,000 11,000 1 3 Total estimated overhead costs for the two product lines are $835,200. ✓ Your answer is correct. Calculate overhead rate. (Round answer to 2 decimal places, e.g. 12.25.) Overhead rate $ 11.60 per direct labor hour...
Question 5 --/1 View Policies Current Attempt in Progress 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 Truck Estimated wheels produced Direct labor hours per wheel 40,000 10,000 1 3 Total estimated overhead costs for the two product lines are $742,000. Calculate overhead rate. (Round answer to 2 decimal places, e.g. 12.25.) Overhead rate $ per...
20,000 assign to each product line, the two products: car wheals and truck wheels. To determine theamr controller, Robert Hermann, has developed the follown Estimated wheels produced Direct labor hours per wheel Car 40,000 Truck 10,000 3 Total estimate d overhead costs for the two product lines are $770,000. Instructions (a) Compute the overhead cost assigned to the car wheels and truck wheels, a assuming that direct labor hours he believes that most is used to allocate overhead costs. (b)...
Exercise 17-4 Altex Inc. manufactures two products: car wheels and truck wheels. To determine the amount of overhead to assign to each product line, the information controller, Robert Hermann, has developed the following Car Truck Estimated wheels produced Direct labor hours per wheel 35,500 15,000 Total estimated overhead costs for the two product lines are $825,000 Calculate overhead rate. (Round answer to 2 decimal places, e-g. 12.25.) Overhead rate per direct labor hour Compute the overhead cost assigned to the...
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...
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,...
Question 11 EcoFabrics has budgeted overhead costs of $1,096,200. It has allocated overhead on a plantwide basis to its two products (wool and cotton) using direct labor hours which are estimated to be 522,000 for the current year. The company has decided to experiment with activity-based costing and has created two activity cost pools and related activity cost drivers. These two cost pools are cutting (cost driver is machine hours) and design (cost driver is number of setups). Overhead allocated...
AutoSave OB R File Home Insert U Page Layout E xcelTemplateAssignment_Ch04 (5) - Excel Search Formulas Data Review View HelpDYMO Label QuickBooks G X V 04-4 - Assign overhead using traditional costing and ABC A B C D E F 1 E4-4 - Assign overhead using traditional costing and ABC 2 Altex Inc. manufactures two products: car wheels and truck wheels. To determine the amount of overhead to 3 assign to each product line, the controller, Robert Hermann, has developed...
Question 11 EcoFabrics has budgeted overhead costs of $1,096,200. It has allocated overhead on a plantwide basis to its two products (wool and cotton) using direct labor hours which are estimated to be 522,000 for the current year. The company has decided to experiment with activity-based costing and has created two activity cost pools and related activity cost drivers. These two cost pools are cutting (cost driver is machine hours) and design (cost driver is number of setups). Overhead allocated...