What is the traditional unit product cost for the Deluxe model now? (Round your intermediate calculations and final answer to 2 decimal places.)

(b). What is the traditional unit product cost for the Tourist model? (Round your intermediate calculations and final answer to 2 decimal places.)

(c). What is the ABC unit product cost for the Deluxe model? (Round your intermediate calculations and final answer to 2 decimal places.)

(d). What is the ABC unit product cost for the Tourist model? (Round your intermediate calculations and final answer to 2 decimal places.)

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