please show steps and calculation . excell prefered

Multiple Versus Single Overhead Rates, Activity Drivers Deoro Company has identified the following overhead activities, costs, and activity drivers for the coming year: Deoro produces two models of dishwashers with the following expected prime costs and activity demands: The company's normal activity is 7,700 direct labor hours. Required: 1. Determine the unit cost for each model using direct labor hours to apply overhead. Round intermediate calcula The company's normal activity is 7,700 direct labor hours: Required: 1. Determine the unit cost for each model using direct labor hours to apply overhead. Round intermediate calculations and final answers to nearest cent. 2. Determine the unit cost for each model using the four activity drivers. Round your answers to nearest cent. 3. Which method produces the more accurate cost assignment? Feedback r Chock My Work 1. Plantwide OH rate is determined by taking the whole expected annual OH t driver (in this case, the total direct labor hours). Apply Overhead to each Mode colculate Unit cost. 2. For each activity, conslder what items would be used in the formula for OH. Apply OH rate to individual activity for each Model 3. Compare both methods and discuss which is more accurate and why. Review diversity and significant non-unit overhed costs