Change the data in your worksheet so that it matches the following: 1 Chapter 4: Applying...

Transcribed Image Text:

Change the data in your worksheet so that it matches the following: 1 Chapter 4: Applying Excel 2 3 Enter a formula into each of the cells marked with a ? below 4 Review Problem: Activity-Based Costing 5 167 A Data 8 Annual sales in units 9 Direct materials per unit 10 Direct labor-hours per unit 11 12 Direct labor rate 13 14 15 16 Activities and Activity Measures 17 18 Machine setups (setups) Labor related (direct labor-hours) 19 Production orders (orders) 20 General factory (machine-hours) 21 $ $ $ B $ Deluxe Estimated Overhead Cost 3,000 25 1 $ 35,000 120,000 70,000 150,000 375,000 с Tourist 20 per DLH 7,000 25 1 Deluxe 3,000 40 35 10,000 D Expected Activity Tourist 7,000 60 15 10,000 E Total 10,000 100 50 20,000 (b). What is the traditional unit product cost for the Tourist model? (Round your intermediate calculations and final answer to 2 decimal places.) Traditional unit product cost for the Tourist model (c). What is the ABC unit product cost for the Deluxe model? (Round your intermediate calculations and final answer to 2 decimal places.) ABC unit product cost for the Deluxe model (d). What is the ABC unit product cost for the Tourist model? (Round your intermediate calculations and final answer to 2 decimal places.) ABC unit product cost for the Tourist model Change the data in your worksheet so that it matches the following: 1 Chapter 4: Applying Excel 2 3 Enter a formula into each of the cells marked with a ? below 4 Review Problem: Activity-Based Costing 5 167 A Data 8 Annual sales in units 9 Direct materials per unit 10 Direct labor-hours per unit 11 12 Direct labor rate 13 14 15 16 Activities and Activity Measures 17 18 Machine setups (setups) Labor related (direct labor-hours) 19 Production orders (orders) 20 General factory (machine-hours) 21 $ $ $ B $ Deluxe Estimated Overhead Cost 3,000 25 1 $ 35,000 120,000 70,000 150,000 375,000 с Tourist 20 per DLH 7,000 25 1 Deluxe 3,000 40 35 10,000 D Expected Activity Tourist 7,000 60 15 10,000 E Total 10,000 100 50 20,000 (b). What is the traditional unit product cost for the Tourist model? (Round your intermediate calculations and final answer to 2 decimal places.) Traditional unit product cost for the Tourist model (c). What is the ABC unit product cost for the Deluxe model? (Round your intermediate calculations and final answer to 2 decimal places.) ABC unit product cost for the Deluxe model (d). What is the ABC unit product cost for the Tourist model? (Round your intermediate calculations and final answer to 2 decimal places.) ABC unit product cost for the Tourist model

Answer rating: 100% (QA)

SOLUTION Points from the Given Information Particulars Annual Sales in Units Dire... View the full answer