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.) The predetermined overhead rate increased because the total direct labor-hours dropped. The predetermined overhead rate decreases because the total estimated overhead cost increased. The predetermined overhead rate decreased because the total direct labor-hours dropped. 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.) The traditional unit product cost of the Tourist model increases when the Deluxe model's direct labor-hour requirement decreases. 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. 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. 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 300 orders in cell C19 and the Tourist model will have 200 orders in cell D19. The Data area should now look like this: B D E Deluxe Tourist 2,000 10,000 $ 25 $ 17 5 4 A 1 Chapter 4: Applying Excel 2 3 Enter a formula into each of the cells marked with a ? below 4 Review Problem: Activity-Based Costing 5 Data 6 7 Annual sales in units 8 Direct materials per unit 9 Direct labor-hours per unit 10 11 Direct labor rate 12 13 14 Activities and Activity Measures 15 Labor related (direct labor-hours) 16 Machine setups (setups) 17 Production orders (orders) 18 General factory (machine-hours) 19 20 21 $ 12 per DLH Estimated Overhead Cost $ 80,000 150,000 70,000 250,000 $ 550,000 Expected Activity Deluxe Tourist 10,000 40,000 3,000 2,000 300 200 12,000 28,000 Total 50,000 5,000 500 40,000 (a). What is the traditional unit product cost for the Deluxe model after this change? Traditional unit product cost for the Dala malal $ 74 (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.) 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. 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. 2 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. (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.) ABC unit product cost for the Deluxe model $143.89 (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.) 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. 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. 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. 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. Requirement 3: Change the data in your worksheet so that it matches the following: 1 Chapter 4: Applying Excel 2 3 Enter a formula into each of the cells marked with a ? below 4 Review Problem: Activity-Based Costing 5 Data 6 Deluxe Tourist 1,000 9,000 $ 46 $ 46 1 1 7 Annual sales in units 8 Direct materials per unit 9 Direct labor-hours per unit 10 11 Direct labor rate 12 13 $ 18 per DLH 14. Activities and Activity Measures 15 Labor related (direct labor-hours) 16 Machine cetins (setuns) Estimated Overhead Cost $ 35,000 120 00 Expected Activity Deluxe Tourist 1,000 9,000 4n 601 Total 10,000 100 1 Chapter 4: Applying Excel 2 3 Enter a formula into each of the cells marked with a ? below 4 Review Problem: Activity-Based Costing 5 Data 6 7 Annual sales in units 8 Direct materials per unit 9 Direct labor-hours per unit 10 11 Direct labor rate Deluxe Tourist 1,000 9,000 $ 46 $ 46 1 $ 18 per DLH 12 13 14. Activities and Activity Measures 15 Labor related (direct labor-hours) 16 Machine setups (setups) 17 Production orders (orders) 18 General factory (machine-hours) Estimated Overhead Cost $ 35,000 120,000 70,000 150,000 $ 375,000 Expected Activity Deluxe Tourist 1,000 9,000 40 60 35 15 10,000 10,000 Total 10,000 100 50 20,000 19 20 21 (a). What is the traditional unit product cost for the Deluxe model now? (Round your intermediate calculations and final answer to 2 decimal places.) Traditional unit product cost for the Deluxe model (b). What is the traditional unit product cost for the Tourist model? (Round your intermediate calculations and final answer to 2 decimal places.) Traditional unit product cost for the Tourist model (c). What is the ABC unit product cost for the Deluxe model? (Round your intermediate calculations and final answer to 2 decimal places.) ABC unit product cost for the Deluxe model (d). What is the ABC unit product cost for the Tourist model? (Round your intermediate calculations and final answer to 2 decimal places.) ABC unit product cost for the Tourist model Requirement 2: Change the direct labor hour requirement for the Deluxe model back to 5 hours in cell 10. Assume that the production orders change so that the Deluxe model will have 300 orders in cell C19 and the Tourist model will have 200 orders in cell D19. The Data area should now look like this: B D A 1 Chapter 4: Applying Excel 2 t nce Deluxe Tourist 2,000 10,000 $ 25 $ 17 5 4 $ 12 per DLH 3 Enter a formula into each of the cells marked with a ? below 4 Review Problem: Activity-Based Costing 5 Data 6 7 Annual sales in units 8 Direct materials per unit 9 Direct labor-hours per unit 10 11 Direct labor rate 12 13 14 Activities and Activity Measures 15 Labor related direct labor-hours) 16 Machine setups (setups) 17 Production orders (orders) 18 General factory (machine-hours) 19 20 21 Estimated Overhead Cost $ 80,000 150,000 70,000 250,000 $ 550,000 Expected Activity Deluxe Tourist 10,000 40,000 3,000 2.000 300 200 12,000 28.000 Total 50,000 5,000 500 40.000 (a). What is the traditional unit product cost for the Deluxe model after this change? Traditional unit product cost for the Deluxe model $ 74 ). 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.) 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. 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. O 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. (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.) ABC unit product cost for the $184.25 Required information 5 Id. 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 bones left with a question mark will be automatically graded as incorrect.) Book Files Print 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. 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 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 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 Herence Requirement : Change the data in your worksheet so that it matches the following: A B D E 1 Chapter 4: Applying Excel 2 3 Enter a formula into each of the celis marked with a ? below Review Problem: Activity-Based Costing 4 5 Data 6 Deluxe Tourist 7 Annual sales in units 1,000 9,000 8 Oirect materials per unit 46 $ 46 9 Direct labor-hours per un 1 1 10 11 Direct labor rate $ 18 per DLH 12 Estimated 13 Overhead Expected Activity 14 Activities and Activity Measures Cost Deluxe Tourist Total 15 Labor related direct labor-hours) $ 35,000 1.000 9.000 10,000 16 Machine setups setups) 120,000 40 60 100 17 Production orders (orders) 70,000 35 15 50 18 General factory machine hours 150,000 10000 10,000 20,000 $ 375,000 20 21 al. What is the traditional unit product cost for the Deluxe model now? (Mound your intermediate calculations and final answer to 2 decimal places.) Traditional unit product cost for the Deluxe model $143.89 What is the traditional unit product cost for the Tourist model? (Round your intermediate calculations and final answer to 2 decimal places.)