fill in the question marks! thank you

G H 1 J L M N o P o Q R s T U v w A B D E F TS Uverridad Expected Activity 16 Activities and Activity Measures Cos! 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 appl Deluxe Tourist 29 Direct labor-hours per unit(a) ? DLHS ? DLHs 30 Prodetermined overhead rate (b) ? per DLH ? per DLH 31 Manufacturing overhead applied per unit (a) ? ? 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 42 Labor related ? ? DLHS ? per DLH 43 Machine setups ? ? setups ? per setup 44 Production orders ? ? orders ? per order 45 General factory ? ? MHS ? per MH 46 47 Compute the ABC overhead cost per unit Deluxe Tourist 48 Activity Expected Expected 49 Activities Rate Activity Amount Activity Amount 50 Labor related ? ? ? ? ? 51 Machine setups ? ? ? ? ? ? 52 Production orders ? ? ? ? ? ? 53 General factory ? ? ? ? ? 54 Total overhead cost assigned (a) ? ? 55 Number of units produced (b) ? 2 ? 56 ABC overhead cost per unit (a) (b) ? ? 57 58 Compute the ABC unit product costs Deluxe Tourist 59 Direct materials ? ? 60 Direct labor ? ? 61 ABC overhead cost per unit (see above) ? ? 62 ABC unit product cost ? ? 63 64 65 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, fmd 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. G H 1 J L M N o P o Q R s T U v w A B D E F TS Uverridad Expected Activity 16 Activities and Activity Measures Cos! 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 appl Deluxe Tourist 29 Direct labor-hours per unit(a) ? DLHS ? DLHs 30 Prodetermined overhead rate (b) ? per DLH ? per DLH 31 Manufacturing overhead applied per unit (a) ? ? 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 42 Labor related ? ? DLHS ? per DLH 43 Machine setups ? ? setups ? per setup 44 Production orders ? ? orders ? per order 45 General factory ? ? MHS ? per MH 46 47 Compute the ABC overhead cost per unit Deluxe Tourist 48 Activity Expected Expected 49 Activities Rate Activity Amount Activity Amount 50 Labor related ? ? ? ? ? 51 Machine setups ? ? ? ? ? ? 52 Production orders ? ? ? ? ? ? 53 General factory ? ? ? ? ? 54 Total overhead cost assigned (a) ? ? 55 Number of units produced (b) ? 2 ? 56 ABC overhead cost per unit (a) (b) ? ? 57 58 Compute the ABC unit product costs Deluxe Tourist 59 Direct materials ? ? 60 Direct labor ? ? 61 ABC overhead cost per unit (see above) ? ? 62 ABC unit product cost ? ? 63 64 65 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, fmd 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