Chapter 3: Applying Excel 2 3 Enter a formula into each of the cells marked with a ? below 4 Review...

60.1K

Verified Solution

Question

Accounting

Chapter 3: Applying Excel
2
3 Enter a formula into eachof the cells marked with a ? below
4 Review Problem: Activity-Based Costing
5
6 Data
7     Deluxe Tourist
8 Annualsales in units 1,000 9,000
9 Directmaterials per unit $33 $33
10 Directlabor-hours per unit 1 1
11
12 Directlabor rate $17 perDLH
13
14 Estimated
15 Overhead
Expected Activity
16 Activities and Activity Measures Cost Deluxe Tourist Total
17 Laborrelated (direct labor-hours) $ 35,000 1,000 9,000 10,000
18 Machinesetups (setups) 120,000 40 60 100
19 Production orders (orders) 70,000 35 15 50
20 Generalfactory (machine-hours) 150,000 10,000 10,000 20,000
21
$375,000
(a)
What is the traditional unit product cost for the Deluxe model now?(Round your intermediatecalculations and final answer to 2 decimalplaces.)

(b)
What is the traditional unit product cost for the Tourist model?(Round your intermediatecalculations and final answer to 2 decimalplaces.)

(c)
What is the ABC unit product cost for the Deluxe model?(Round your intermediatecalculations and final answer to 2 decimalplaces.)


(d)
What is the ABC unit product cost for the Tourist model?(Round your intermediatecalculations and final answer to 2 decimalplaces.)

Answer & Explanation Solved by verified expert

3.6 Ratings (273 Votes)

Answer a b Predetermined Overhead Rate 375000 Total Overhead 10000 DLH Predetermined Overhead Rate 3750 per DLH Calculation of Unit Product Cost Under Traditional Costing Deluxe Moderate Direct Material 3300 3300 Direct Labor 1700 1700 Applied Overhead 3750 3750 See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member

Chapter 3: Applying Excel
2
3	Enter a formula into eachof the cells marked with a ? below
4	Review Problem: Activity-Based Costing
5
6	Data
7		Deluxe	Tourist
8	Annualsales in units	1,000	9,000
9	Directmaterials per unit	$33	$33
10	Directlabor-hours per unit	1	1
11
12	Directlabor rate	$17	perDLH
13
14		Estimated
15		Overhead	Expected Activity
16	Activities and Activity Measures	Cost	Deluxe	Tourist	Total
17	Laborrelated (direct labor-hours)	$ 35,000	1,000	9,000	10,000
18	Machinesetups (setups)	120,000	40	60	100
19	Production orders (orders)	70,000	35	15	50
20	Generalfactory (machine-hours)	150,000	10,000	10,000	20,000
21		$375,000