Download the Applying Excel form and enter formulas in all cells that contain question marks. Enter formulas in the cells that contain question marks. For example, in cell C17 enter the formula = B8 810" 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 Deluwe model in cell BIO 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. Save your completed Applying Excel form to your computer and then upload it here by clicking "Browse." Next, click "Save. You will use this worksheet to answer the questions in Part 2 L 1 Chapter 4: Applying Excel 2 3 Enter a formula into each of the cele 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 517 10 Direct labor hours per unit 5 4 11 12 Direct laborate $12 por DLH 13 14 Estimated 15 Overhead Expected Activity 16 Actiwdes and Activity Measures Cost Dolume Tourist Total 17 Labor related direct labor-hours) 5 80,000 10,000 40.000 ? 18 Machine setups (soups) 150.000 3.000 2.000 2 19 Production orders (orders) 70.000 100 300 2 20 General factory (machine-hours) 250,000 12.000 28.000 ? 21 2 22 23 Compute the predetermined overhead rate 24 Estimated total manufacturing overhead() ? 25 Estimated total amount of the allocation base (b) 2 DLHS 26 Predetermined overhead rate (a) (b) 7 por DLH 27 28 Compute the manufacturing overhead applied Deluxe Tourist 29 Direct labor hours per unit() 2 DLHS 2 DLHS 30 Predetermined overhead rate (b) 2 per DLH 2 per DLH 31 Manufacturing overhead applied per unit(a) (b) 2 2 32 33 Compute traditional unit product costs Deluxe Tour 34 Direct materials 2 2 35 Direct labor ? ? 36 Manufacturing overhead applied 2 ? 37 Traditional unit product cost 2 ? 38 39 Compute activity rates Estimated 40 Overhead 41 Active Cost Total Expected Activity Activity Rate 42 Labor related 2 2 per DLH 43 Machine setups 7 setups ? per setup 44 Production orders 2 7 orders 7 per order 45 General factory 7 2 MS 2 per MH 46 47 Compute the ABC overhead cost per unit Deluxe Tour 48 Activity Expected Expected 49 Activities Rate Activity Amount Activity Amount 50 Labor related 2 ? 3 2 2 51 Machine setups 2 2 2 2 2 52 Production orders ? ? 2 2 ? 53 General factory 2 2 2 2 54 Total overhead cos assigned ) 2 55 Number of units produced (b) 2 2 2 56 ABG overhead cost per unit () () 2 2 57 58 Compute the ABC unit product costs Deluxe Tourist 59 Direct materials ? ? 60 Direct labor 2 2 61 ADC overhead cont per unit (above) ? 62 ABC unit productos ? 2 63 64 65 7 DLHS ANNI