Required Information 1 Chapter 4: Applying Excel 2 3 Enter a formula into each of the colls marked with a ? below Review Problem: Activity-Based Costing 4 5 Data G Deluxe 2.000 25 s 5 Tourist 10,000 17 $ 7 Annual sales in units 8 Directorials per unit 9 Direct labor hours perunt 10 11 Direct laborata 12 4 12 per DH Estimated Orehead Cost $ 13 14 Activities and Atty Measures 15 Laborito (direct labor hours 16 Machine stos) 17 Production orders oder) 18 General factory machine-hours) 19 20 21 80,000 150,000 70.000 250.000 330.000 Expected Activity Dewe Tourist 10.000 40,000 3,000 2.000 200 300 12.000 28.000 Total 50.000 5,000 500 10 000 5 (). What is the traditional unit product cost for the Deluxe mode after this change? Tractional productore Damer $ 20 fol. Which of the foowing stements 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 o wrong answer Any boxes left with a question mark will be automatically graded ss Incorrect) The trattata SO SE OPSOE TherEgger SOOS The tot -- E () 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) ABG unit product of the model idi. Which of the following statements are true concerning the effects of the change in production orders on the ABC unit product couts! (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 ut dutto in modul hand the ABC unit own the Toni medlem the reduction to the most The ABC product of the mind the Beat the Team had be in the Demo The ABC on the executarehe models and be Drone The ABC ABC Tubes Pornstar 2 Required information The ABC unit product of the Delus model has decreased and the ABC un product of the Tour model has increased becue higher proportion of the production sera are now able to the Deine model 22 Requirement 3 Change the data in your worksheet so that it matches the following: B 1 Chapter 4: Applying El 2 3 Entor a formulach of the calls marked with a blow Review Problem: Activity-Band Costing 5 Data 6 EN Delare 2.000 Z Amis in units 8 Dramos por un 9 Director hos por un 10 11 Direct laborat 12 Tours 7.000 45 1 3 1 $ 27 DUH Estimated Oreo Cost $ 35.000 120.000 70.000 150.000 5 325.000 Eco Adi Decae Tours 3.000 2000 40 59 14 Aces and Activity reasures 15 Laboratoirectors 16 Machines 27 Production orders foros 14 Generaatory machines 19 20 21 10.000 10.000 15 10.000 30 20.000 What is metional unit product cost for the Deuce model now! Round your intermediate calculations and final answer to 2 decimal places) Tato poco et net is the con un product cost for the tous mode (Round your intermediate calculations and final answer to 2 decimal places) Toro c) What is the ABC unit product cost for the Deluxe mode? (Round your intermediate calculations and final answer to 2 decimal places. ABC un product that ( What is the ABC unt product cost for the Tourist model (Round your intermediate calculations and final answer to 2 decimal places.)