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