Question: please just give me the excel formulas for each cell that has a question mark Enter formulas in the cells that contain question marks. For

please just give me the excel formulas for each cell that has a question mark  please just give me the excel formulas for each cell that
has a question mark Enter formulas in the cells that contain question
marks. For example, in cell C17 enter the formula =B8 'B10". After

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. Sove 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. Review Problem: Activity-Based Costing Data Annual sales in units Direct materials per unit Direct labor-hours per unit 1211 Direct labor rate 1410 514 16 Activities and Activity Measures 7 Labor related (direct labor-hours) 18 Machine setups (setups) Production orders (orders) General factory (machine-hours) Deluxe 2,000 Tounist $25 5 10,000 $17 $12 per DLH Estimated Overhead Cost \$ 80,000 150,000 70,000 \begin{tabular}{rr} 250,000 & 12,000 \\ \hline \end{tabular} Expected Activity Deluxe 3.000 100 12,000 Tounist Total 2.000 ? 28,000 ? \begin{tabular}{l} \hline? \\ \\ ? DLHs \\ ? per DLH \end{tabular} Compute the predetermined overhead rate Estimated total manufacturing overhead (a) Estimated total amount of the allocation base (b) Predetermined overhead rate (a)(b) Deluxe?DLHs?perDLH?Tourist?DLHs?perDLH? Compute the manufacturing overhead applied Direct labor-hours per unit (a) Predetermined overhead rate (b) Manufacturing overhead applied per unit (a) ( b) ? ? Compute traditional unit product costs Deluxe Tourist Direct materials Direct labor Manufacturing overhead applied Traditonal unit product cost Compute activity rates Estimated Activities Overhead Labor related Cost Total Expected Activity Activity Rate Machine setups DUHs ? per DLH Production orders setups ? per setup General factory orders ? per order ? per MH

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!