What is the product cost for
the Deluxe model?
What is the Activity Based Costing unit product cost for the Deluxe model? (Round your final answer to 2 decimal places.)
Activity rate=Estimated overhead cost/Total expected activity | |||||||
Activity cost pool |
Estimated Overhead Cost |
Total Expected Activity |
Activity Rate |
||||
Labor related | 80000 | 50000 | 1.6 | Per direct labor hour | |||
Machine setups | 150000 | 5000 | 30 | Per setup | |||
Production orders | 70000 | 500 | 140 | Per order | |||
General factory | 250000 | 40000 | 6.25 | Per machine hour | |||
Overhead cost=Actual activity*Activity rate | |||||||
Activity cost pool |
Activity Rate |
Actual activity | Overhead cost | ||||
a | b | a*b | |||||
Labor related | 1.6 | Per direct labor hour | 10000 | 16000 | |||
Machine setups | 30 | Per setup | 3000 | 90000 | |||
Production orders | 140 | Per order | 230 | 32200 | |||
General factory | 6.25 | Per machine hour | 12000 | 75000 | |||
Total overhead cost | a | 213200 | |||||
Annual sales in units | b | 2000 | |||||
Overhead cost per unit | a/b | 106.6 | |||||
Product cost: | |||||||
$ | |||||||
Direct materials per unit | 25 | ||||||
Direct labor cost per unit | (5*12) | 60 | |||||
Overhead cost per unit | 106.6 | ||||||
Total | 191.6 | ||||||
What is the product cost for the Deluxe model? What is the Activity Based Costing unit...
Given the following data, answer the questions below the table: -------------------------------------------------------------------------------------------------------------------------------- Data Deluxe Tourist Annual sales in units 2,000 10,000 Direct materials per unit $25 $17 Direct labor-hours per unit 5 4 Direct labor rate $12 per DLH Estimated Overhead Expected Activity Activities and Activity Measures Cost Deluxe Tourist Total Labor related (direct labor-hours) $ 80,000 10,000 40,000 50,000 Machine setups (setups) 150,000 3,000 2,000 5,000 Production orders (orders) 70,000 230 270 500 General factory (machine-hours) 250,000 12,000 28,000 40,000...
Given the following data, answer the questions below the table: -------------------------------------------------------------------------------------------------------------------------------- Data Deluxe Tourist Annual sales in units 2,000 10,000 Direct materials per unit $25 $17 Direct labor-hours per unit 5 4 Direct labor rate $12 per DLH Estimated Overhead Expected Activity Activities and Activity Measures Cost Deluxe Tourist Total Labor related (direct labor-hours) $ 80,000 10,000 40,000 50,000 Machine setups (setups) 150,000 3,000 2,000 5,000 Production orders (orders) 70,000 230 270 500 General factory (machine-hours) 250,000 12,000 28,000 40,000...
Activity Based Costing 1 Chapter 3: Applying Excel Fra formulato each of the cols marked when Review Problem. Activity Based Couting 6 Data Annual sales in units 9 Direct materials per unit 10 Direct labor hours per unit 2000 Tourist 10 000 $25 517 12 Direct labor rate 512 per DUH Overhead Expected Activity 16 Activities and Activity Measures 17 Labor-related (direct labor hours) 19 Machine setups (setups) 19 Production orders (orders) 20 General factory (machine hours) $ 80.000 150.000...
Siegel Corporation produces a product that is available in both a Deluxe and a Regular model. It is estimated that $2,410,000 in manufacturing overhead costs will be incurred and that the company will produce 9,500 units of the Deluxe model and 20,000 units of the Regular model. The Direct Materials and Direct Labor costs per unit are as follows: Deluxe Regular Direct Materials cost per unit………………………. $155 $124 Direct Labor cost per unit………………………….. $20 $11 The company...
Siegel Corporation produces a product that is available in both a Deluxe and a Regular model. It is estimated that $2,410,000 in manufacturing overhead costs will be incurred and that the company will produce 9,500 units of the Deluxe model and 20,000 units of the Regular model. The Direct Materials and Direct Labor costs per unit are as follows: Deluxe Regular Direct Materials cost per unit............... $155 $124 Direct Labor cost per unit................................ $20 $11 The company uses Activity-Based Costing...
Enter formulas in the cells that contain question marks. For
example, in cell C17 enter the formula "= B8*B10".
After entering formulas in all of the cells that contained question
marks, verify that the calculated numbers match the numbers in the
Review Problem.
Check your worksheet by reducing the direct labor-hours for the
Deluxe model in cell B10 from 5 to 2. The Deluxe model's unit
product cost under traditional costing should now be $74.00 and the
ABC unit product...
Siegel Corporation produces a product that is available in both a Deluxe and a Regular model. It is estimated that $2,410,000 in manufacturing overhead costs will be incurred and that the company will produce 9,500 units of the Deluxe model and 20,000 units of the Regular model. The Direct Materials and Direct Labor costs per unit are as follows: Deluxe Regular Direct Materials cost per unit.... $155 $124 Direct Labor cost per unit.. $20 $11 The company uses Activity-Based Costing...
Siegel Company manufactures product that is available in both a deluxe model and a regular model. The company has manufactured the regular model for years. The deluxe model was introduced several years ago to tap a new segment of the market. Since introduction of the deluxe model, the company's profits have steadily declined and management has become increasingly concerned about the accuracy of its costing system. Sales of the deluxe model have been increasing rapidly. Manufacturing overhead is assigned to...
Siegel Company manufactures a product that is available in both a deluxe model and a regular model. The company has manufactured the regular model for years. The deluxe model was introduced several years ago to tap a new segment of the market. Since introduction of the deluxe model, the company’s profits have steadily declined and management has become increasingly concerned about the accuracy of its costing system. Sales of the deluxe model have been increasing rapidly. Manufacturing overhead is assigned...
Required information Chapter 4: Applying Excel The Chapter 4 Form worksheet is to be used to create your own worksheet version of the Review Problem in the text on pages. Part 1 of 2 Chapter 4: Applying Excel: Excel Worksheet (Part 1 of 2) eBook Download the Applying Excel form and enter formulas in all cells that contain question marks. Enter formulas in the cells that contain question marks. For example, in cell C17 enter the formula "=B8*B10". Print After...