Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Requirement 3: : Change the data in your worksheet so that it matches the following: A B D E 1 Chapter 4: Applying Excel 2
Requirement 3: : 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 ? below Review Problem: Activity-Based Costing 4 5 6 Data Deluxe 1,000 41 s Tourist 9.000 S 7 8 Annual sales in units 9 Direct materials per unit 10 Direct labor hours per unit 11 12 Direct labor rate 13 41 1 1 1 S 28 per DLH 14 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 Estimated Overhead Cost 5 5 35,000 120.000 70.000 150.000 S 375 000 Expected Activity Deluxe Tourist 1.000 9,000 40 60 35 15 10.000 Total 10,000 100 50 20.000 10.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 (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
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started