Enter a formula into each of the cells marked with a below Review Problem: Activity-Based Costing Data Deluxe Tourist Annual sales in units 2,000 10,000 Direct materials per unit $25 $17 Direct labor-hours per unit 5 4 Direct labor rate $12 per DLH Estimated Overhead Expected Activity Activities and Activity Measures Cost Deluxe Tourist Total Labor related (direct labor-hours) $80,000? Machine setups (setups) 150,000 3,000 2,000 ? Production orders (orders) 70,000 100 300 ? General factory (machine-hours) 250,000 12,000 28,000? Compute the predetermined overhead rate Estimated total manufacturing overhead (a) Estimated total amount of the allocation base (b) DLHs Predetermined overhead rate (a) ÷ (b) per DLH Compute the manufacturing overhead applied Deluxe Tourist Direct labor-hours per unit (a) DLHs ? DLHs Predetermined overhead rate (b) ? per DLH ? per DLH 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 Overhead Activities Cost Total Expected Activity Activity Rate Labor related ? DLHs ? per DLH Machine setups ? ? setups ? per setup Production orders ? orders ? per order General factory ? MHs ? per MH Compute the ABC overhead cost per unit Deluxe Tourist Activity Expected Expected Activities Rate Activity Amount Activity Amount Labor related ? Machine setups ? Production orders ? General factory ? Total overhead cost assigned (a) Number of units produced (b) ABC overhead cost per unit (a) ÷ (b) Compute the ABC unit product costs Deluxe Tourist Direct materials ? Direct labor ? ABC overhead cost per unit (see above) ABC unit product cost ?