Question
Chapter 4: Applying Excel Enter a formula into each of the cells marked with a ? below Review Problem: Activity-Based Costing Data Deluxe Tourist Annual
Chapter 4: Applying Excel Enter a formula into each of the cells marked with a ? below Review Problem: Activity-Based Costing Data Deluxe Tourist Annual sales in units 2,000 8,000 Direct materials per unit $38 $38 Direct labor-hours per unit 1 1 Direct labor rate $16 per DLH Estimated Overhead Expected Activity Activities and Activity Measures Cost Deluxe Tourist Total Labor related (direct labor-hours) $35,000 2,000 8,000 10,000 Machine setups (setups) 120,000 40 60 100 Production orders (orders) 70,000 35 15 50 General factory (machine-hours) 150,000 10,000 10,000 20,000 $375,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.) (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.)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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