Question: Change the data in your worksheet so that it matches the following: B C D E Chapter 4: Applying Excel 1 2 3 4 Enter


Change the data in your worksheet so that it matches the following: B C D E Chapter 4: Applying Excel 1 2 3 4 Enter a formula into each of the polls marked with a 7 below Review Problem: Activity-Based Costing MON Data Deluxe 1,000 35 S 1 Tourist 9,000 35 $ ces 1 8 Annual sales in units Direct materials per unit 10 Direct labor-hours per unit 11 12 Direct labor rate 13 14 $ 15 per DLH + 15 Estimated Overhead Cost $ 35,000 120,000 70,000 150,000 $ 375,000 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 Total 10,000 100 50 20,000 S Chec 2 (a). What is the traditional unit product cost for the Deluxe model now? (Round your Intermediate calculations and final answer to 2 decimal places.) Part 2 of 2 Traditional unit product cost for the Deluxe model oints eBook Print (b). What is the traditional unit product cost for the Tourist model? (Round your intermediate calculations and final answer to 2 decimal places.) Referens 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 decimat places.) ABC unit product cost for the Deluxe model wonal 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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
