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 200 orders in cell C19 and the Tourist model will have 300 orders in cell D19. The Data area should now look like this: A B D E 1 Chapter 4: Applying Excel 2 3 Enter a formula into each of the cells marked with a ? below Review Problem: Activity-Based Costing 4 5 6 Data 7 Deluxe 8 Annual sales in units Direct materials per unit Direct labor-hours per unit 2,000 25 Tourist 10,000 17 9 $ $ 5 4 10 11 Direct labor rate $ 12 per DLH 12 13 Estimated 14 Overhead 15 Total 16 $ 17 Activities and Activity Measures Labor related (direct labor-hours) Machine setups (setups) Production orders (orders) General factory (machine-hours) Cost 80,000 150,000 70,000 250,000 550,000 Expected Activity Deluxe Tourist 10,000 40,000 3,000 2,000 200 300 12,000 28,000 50,000 5,000 500 18 19 40,000 20 $ 21 (a). What is the traditional unit product cost for the Deluxe model after this change? Traditional unit product cost for the Deluxe model (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 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. 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. (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