Required information as a eu un TUULILUL 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 250 orders in cell C19 and the Tourist model will have 250 orders in cell 019. The Data area should now look like this: A B D 1 E Chapter 4: Applying Excel 2 3 4 Enter a formula into each of the cells marked with a ? below Review Problem: Activity Based Costing 5 6 Data 7 Deluxe 2,000 8 Annual sales in units 9 Direct materials per unit 10 Direct labor-hours per unit 11 Tourist 10,000 17 $ 25 $ 5 4 12 Direct labor rate 5 12 per DLH 13 14 15 16 Total 17 18 Activities and Activity Measures Labor related (direct labor-hours) Machine setups (setups) Production orders (orders) General factory (machine-hours) 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 250 250 12,000 28,000 50,000 5,000 500 40,000 19 20 21 Check my work mode: This shows what is correct or incorrect for the work you have completed sefer does not indicate 6 Required information 0.85 points taj What is the traditional unit product cost for the Deluxe model atter this change? Answer is complete and correct. Traditional unit product cost for the Delu 140 (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 overhed locations based on drectibor hours ignore covers such as production orders The traditional introduct costs for the two models are unchanged by the change in production orders because traditional overhead allocations based on direct labor hours or other covers the production orders The tradisional unt product costs for the two models are unchanged by me change in production orders because there estmed overhead cost nor the total director mours were affected (c). What is the ABC unit product cost for the Deluxe model after the change? (Round your intermediate calculations and final answer to 2 decimal places.) Answer is complete but not entirely correct. ABC und produd cost for Denne model S 184250 Uw what is correct or incorrect for the work you have completed so far, it does not indicate 6 Required information Requirement 3: 0.85 point Change the data in your worksheet so that it matches the following: Chapter Applying Excel B D 1 2 3 E 4 Enter a forma into each of the ce mardwa below Review Problem: Activity Based Costing 5 6 Data 2 Tour 9.000 8 Annual sales in units 9 Direct materials per unit 10 Direct labor-hours per unit 11 12 Direct laborate 13 Dolu 1,000 21 1 5 21 1 $ 15 per DEH 14 15 Expected Activity Do 1.000 16 Activities and Activity Matures 17 Labor related direct labor hours) 18 Machine setups (setups) 19 Production orders (orders) 20 21 General factory machine hours) Estimated Overhead Cost 35.000 120,000 70,000 150 000 $375,000 40 9,000 60 15 10.000 10,000 100 50 20.000 35 10.000 Required information 0.85 points (a) What is the traditional unit product cost for the Deluxe model now? (Round your intermediate calculations and final answer to 2 decimal places.) Answer is complete but not entirely correct. Traditional unt product cost for the Deluxe mode $ 7400 (b). What is the traditional unit product cost for the Tourist model? (Round your Intermediate calculations and final answer to 2 decimal places.) Answer is complete but not entirely correct. Traditional unit product cost for the Tour model $ 115,00 1). What is the ABC unit product cost for the Deluxe model? (Round your intermediate calculations and final answer to 2 decimal places) Answer is complete but not entirely correct. ABC une product cost for the Deluxe model 10389 0.85 points (b) What is the traditional unit product cost for the Tourist model? (Round your intermediate calculations and final answer to 2 decimal places.) Answer is complete but not entirely correct. Traditional unit product cost for the Tourist model $ 115,00 1). What is the ABC unit product cost for the Deluxe model? (Round your intermediate calculations and final answer to 2 decimal places.) Answer is complete but not entirely correct. ABC unit product cost for the Deluxe model $ 143.89 (a) What is the ABC unit product cost for the Tourist model? (Round your intermediate calculations and final answer to 2 decimal places.) Answer is complete but not entirely correct. ABC unit product cost for the Tourist model s 101 02
