Question

In: Accounting

A B C D E F 1 Chapter 3: Applying Excel 2 3 Enter a formula...

A

B

C

D

E

F

1 Chapter 3: Applying Excel
2
3 Enter a formula into each of the cells marked with a ? below
4 Review Problem: Activity-Based Costing
5        
6 Data
7     Deluxe Tourist
8 Annual sales in units 2,000 10,000
9 Direct materials per unit $25 $17
10 Direct labor-hours per unit 5 4
11
12 Direct labor rate $12 per DLH
13
14 Estimated
15 Overhead

Expected Activity

16 Activities and Activity Measures Cost Deluxe Tourist Total
17 Labor related (direct labor-hours) $ 80,000 10,000 40,000 50,000
18 Machine setups (setups) 150,000 3,000 2,000 5,000
19 Production orders (orders) 70,000 270 230 500
20 General factory (machine-hours) 250,000 12,000 28,000 40,000
21

$550,000

(a)

(a)What is the traditional unit product cost for the Deluxe model after this change?

(c)

What is the ABC unit product cost for the Deluxe model after this change? (Round your intermediate calculations and final answer to 2 decimal places.)

Solutions

Expert Solution


Related Solutions

A B C D E F 1 Chapter 3: Applying Excel 2 3 Enter a formula...
A B C D E F 1 Chapter 3: Applying Excel 2 3 Enter a formula into each of the cells marked with a ? below 4 Review Problem: Activity-Based Costing 5         6 Data 7     Deluxe Tourist 8 Annual sales in units 2,000 10,000 9 Direct materials per unit $25 $17 10 Direct labor-hours per unit 5 4 11 12 Direct labor rate $12 per DLH 13 14 Estimated 15 Overhead Expected Activity 16 Activities and Activity...
A B C D E F 1 Chapter 8: Applying Excel 2 3 Data 4 Exhibit...
A B C D E F 1 Chapter 8: Applying Excel 2 3 Data 4 Exhibit 8-8: Standard Cost Card 5 Inputs Standard Quantity Standard Price 6 Direct materials 3.0 pounds $4.00 7 Direct labor 0.50 hours $22.00 per hour 8 Variable manufacturing overhead 0.50 hours $6.00 per hour 9 10 Actual results: 11     Actual output 2,090 units 12     Actual variable manufacturing overhead cost $6,174 13    Actual Quantity Actual price 14     Actual direct materials cost 6,115 pounds $3.9 pounds...
Chapter 3: Applying Excel 2 3 Enter a formula into each of the cells marked with...
Chapter 3: Applying Excel 2 3 Enter a formula into each of the cells marked with a ? below 4 Review Problem: Activity-Based Costing 5         6 Data 7     Deluxe Tourist 8 Annual sales in units 1,000 9,000 9 Direct materials per unit $33 $33 10 Direct labor-hours per unit 1 1 11 12 Direct labor rate $17 per DLH 13 14 Estimated 15 Overhead Expected Activity 16 Activities and Activity Measures Cost Deluxe Tourist Total 17 Labor...
A B C D 1 Chapter 5: Applying Excel 2 3 Data 4 Selling price per...
A B C D 1 Chapter 5: Applying Excel 2 3 Data 4 Selling price per unit $321 5 Manufacturing costs: 6   Variable per unit produced: 7     Direct materials $141 8     Direct labor $69 9     Variable manufacturing overhead $40 10   Fixed manufacturing overhead per year $127,600 11 Selling and administrative expenses: 12   Variable per unit sold $5 13   Fixed per year $65,000 14 15 Year 1 Year 2 16 Units in beginning inventory 0 17 Units produced during the year...
A B C D 1 Chapter 5: Applying Excel 2 3 Data 4 Unit sales 30,000...
A B C D 1 Chapter 5: Applying Excel 2 3 Data 4 Unit sales 30,000 units 5 Selling price per unit $70 per unit 6 Variable expenses per unit $42 per unit 7 Fixed expenses $420,000 8 If your formulas are correct, you should get the correct answers to the following questions. (a) What is the break-even in dollar sales?        (b) What is the margin of safety percentage?        (c) What is the degree of operating leverage? (Round...
A B C 1 Chapter 4: Applying Excel 2 3 Data 4 Beginning work in process...
A B C 1 Chapter 4: Applying Excel 2 3 Data 4 Beginning work in process inventory: 5    Units in process 200 6    Completion with respect to materials 10 % 7    Completion with respect to conversion 45 % 8    Costs in the beginning work in process inventory: 9       Materials cost $404 10       Conversion cost $6,210 11 Units started into production during the period 15,000 12 Costs added to production during the period: 13    Materials cost $245,921 14    Conversion cost $996,935...
Six people (A, B, C, D, E, F) are lining up to enter a museum. (1)...
Six people (A, B, C, D, E, F) are lining up to enter a museum. (1) How many ways are there to line up the six people if A is somewhere before B, although not necessarily immediately before? (2) How many ways are there to line up the six people if A is next to C? (3) How many ways are there to line up the six people if A must be next to B but C and D can...
1. Processes A, B, C, D, E, and F require service times of 3, 5, 2,...
1. Processes A, B, C, D, E, and F require service times of 3, 5, 2, 5, 3, and 5. Their arrival times are 0, 1, 3, 9, 10, and 12. What is the average turnaround time, waiting time, response time, and throughput when using SRJF, RR (q=2), and MLF (q=22i+1). Show your work.
1. Processes A, B, C, D, E, and F require service times of 3, 5, 2,...
1. Processes A, B, C, D, E, and F require service times of 3, 5, 2, 5, 3, and 5. Their arrival times are 0, 1, 3, 9, 10, and 12. What is the average turnaround time, waiting time, response time, and throughput when using SRJF, RR (q=2), and MLF (q=22i+1). Show your work.
(a) (f ∘ g)(3) (b) g(f(2)) (c) g(f(5)) (d) (f ∘ g)(−3) (e) (g ∘ f)(−1) (f) f(g(−1))
(a)    (f ∘ g)(3) (b)    g(f(2)) (c)    g(f(5)) (d)    (f ∘ g)(−3) (e)    (g ∘ f)(−1) (f)    f(g(−1))  
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT