Chapter 4: Applying Excel: Exercise (Part 2 of 2)

Requirement 1:

(a). Which of the following statements are true concerning the predetermined overhead rate when the direct labor-hour requirement for the Deluxe model dropped from 5 hours to 2 hours? (You may select more than one answer. Single click the box with the question mark to produce a check mark for a correct answer and double click the box with the question mark to empty the box for a wrong answer. Any boxes left with a question mark will be automatically graded as incorrect.)

check all that apply 1

• The predetermined overhead rate decreased because the total direct labor-hours dropped.unanswered
• The predetermined overhead rate decreases because the total estimated overhead cost increased.unanswered
• The predetermined overhead rate increased because the total direct labor-hours dropped.unanswered
• The predetermined overhead rate increased because the total estimated overhead cost increased.

b). Which of the following statements are true concerning the unit product costs for the Tourist model when the direct labor-hour requirement for the Deluxe model drops from 5 hours to 2 hours? (You may select more than one answer. Single click the box with the question mark to produce a check mark for a correct answer and double click the box with the question mark to empty the box for a wrong answer. Any boxes left with a question mark will be automatically graded as incorrect.)

check all that apply 2

• Economically, the fact that the Deluxe model's direct labor-hour requirement changed should have little or no impact on the cost of the Tourist model.unanswered
• The ABC unit product cost of the Tourist model increases when the Deluxe model's direct labor-hour requirement decreases, but by not by as much as the traditional unit product cost.unanswered
• The traditional unit product cost of the Tourist model increases when the Deluxe model's direct labor-hour requirement decreases.

Requirement 2:

Change the direct labor-hour requirement for the Deluxe model back to 5 hours in cell B10. Assume that the production orders change so that the Deluxe model Will have 270 orders in cell C19 and the Tourist model will have 230 orders in cell D19. The Data area should now look like this:

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	10,000
Direct materials per unit	$25	$17
Direct labor-hours per unit	5	4
Direct labor rate	$12	per DLH
	Estimated
	Overhead	Expected Activity
Activities and Activity Measures	Cost	Deluxe	Tourist	Total
Labor related (direct labor-hours)	$80,000	10,000	40,000	50,000
Machine setups (setups)	150,000	3,000	2,000	5,000
Production orders (orders)	70,000	270	230	500
General factory (machine-hours)	250,000	12,000	28,000	40,000
	$550,000

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

(b). Which of the following statements are true? (You may select more than one answer. Single click the box with the question mark to produce a check mark for a correct answer and double click the box with the question mark to empty the box for a wrong answer. Any boxes left with a question mark will be automatically graded as incorrect.)

check all that apply 3

• The traditional unit product costs for the two models have been changed by the change in production orders because traditional overhead allocations based on direct labor-hours ignore other cost drivers such as production orders.unanswered
• The traditional unit product costs for the two models are unchanged by the change in production orders because traditional overhead allocations based on direct labor-hours ignore other cost drivers such as production orders.unanswered
• The traditional unit product costs for the two models are unchanged by the change in production orders because neither the total estimated overhead cost nor the total direct labor-hours were affected.

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.)

(d). Which of the following statements are true concerning the effects of the change in production orders on the ABC unit product costs? (You may select more than one answer. Single click the box with the question mark to produce a check mark for a correct answer and double click the box with the question mark to empty the box for a wrong answer. Any boxes left with a question mark will be automatically graded as incorrect.)

check all that apply 4

• The ABC unit product cost of the Deluxe model has increased and the ABC unit product cost of the Tourist model has decreased because a lower proportion of the production orders are now attributable to the Deluxe model.unanswered
• The ABC unit product cost of the Deluxe model has increased and the ABC unit product cost of the Tourist model has decreased because a higher proportion of the production orders are now attributable to the Deluxe model.unanswered
• The ABC unit product cost of the Deluxe model has decreased and the ABC unit product cost of the Tourist model has increased because a lower proportion of the production orders are now attributable to the Deluxe model.unanswered
• The ABC unit product cost of the Deluxe model has decreased and the ABC unit product cost of the Tourist model has increased because a higher proportion of the production orders are now attributable to the Deluxe model.unanswered

Requirement 3:

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

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	$32	$32
Direct labor-hours per unit	1	1
Direct labor rate	$18	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.)