Required information Requirement 3: 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 cells marked with a ? below Review Problem: Activity-Based Costing 4 5 25 6 Data 7 8 Annual sales in units 9 Direct materials per unit 10 Direct labor hours per unit 11 Deluxe 1,000 45 s Tourist 9,000 45 $ 1 1 12 Direct labor rate 13 $ 24 per DLH 14 15 16 Activities and Activity Measures 17 Labor related (direct labor hours) 18 Machine setups (setups) 19 Production orders (orders) Estimated Overhead Cost $ 35,000 120,000 70,000 Deluxe 1.000 40 35 Expected Activity Tourist 9,000 '60 15 Total 10.000 100 50