Requirement 3:

Change the data in your worksheet so that it matches the following:

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

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	3,000	7,000
Direct materials per unit	$20	$20
Direct labor-hours per unit	1	1
Direct labor rate	$21	per DLH
	Estimated
	Overhead	Expected Activity
Activities and Activity Measures	Cost	Deluxe	Tourist	Total
Labor related (direct labor-hours)	$35,000	3,000	7,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.)