Enter formulas in the cells that contain question marks. For example, in cell C17 enter the formula "= B8*B10". After entering formulas in all of the cells that contained question marks, verify that the calculated numbers match the numbers in the Review Problem. Check your worksheet by reducing the direct labor-hours for the Deluxe model in cell B10 from 5 to 2. The Deluxe model's unit product cost under traditional costing should now be $74.00 and the ABC unit product cost should be $143.89. If you do not get these results, find the errors in your worksheet and correct them.

F A B D E F 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 6 Data 7 Deluxe Tourist 8 Annual sales in units 2,000 10,000 9 Direct materials per unit $25 $17 10 Direct labor-hours per unit 5 4 11 12 Direct labor rate $12 per DLH 13 14 Estimated 15 Overhead Expected Activity 16 Activities and Activity Measures Cost Deluxe Tourist Total 17 Labor related direct labor-hours) $ 80,000 ? ? 18 Machine setups (setups) 150,000 3,000 2,000 ? 19 Production orders (orders) 70,000 100 300 ? 20 General factory (machine-hours) 250,000 12,000 28,000 ? 21 ? 22 23 Compute the predetermined overhead rate 24 Estimated total manufacturing overhead (a) ? 25 Estimated total amount of the allocation base (b) ? DLHs 26 Predetermined overhead rate (a) (b) ? per DLH 27 28 Compute the manufacturing overhead applied Deluxe Tourist 29 Direct labor-hours per unit (a) ? DLHs ? DLHs 30 Predetermined overhead rate (b) ? per DLH 31 Manufacturing overhead applied per unit (a) (b) ? ? 32 33 Compute traditional unit product costs Deluxe Tourist 34 Direct materials ? ? 35 Direct labor ? ? 36 Manufacturing overhead applied ? ? 37 Traditonal unit product cost ? ? 38 39 Compute activity rates Estimated 40 Overhead 41 Activities Cost Total Expected Activity Activity Rate ? per DLH