I need help with this question please. thank you!

Estimated overhead costs by department:

Finishing: $3,000,000

assembly: $5,000,00

Estimated Direct labor hours and machine hours by department:

direct labour hours:

assembly: 100,000 hours

finishing: 25,000 hours

machine hours:

assembly: 70,000 hours

finishing: 30,000 hours.

estimated overhead costs by activity:

supervision: $2,000,000

maintenance: $6,000,000

cost driver and expected usage by activity:

supervision: $125,000 direct lavor hours

maintenance: $100,000 machine hours

Tableau DA 17-1: Quick Study, Computing plantwide overhead rates LO P1 Chrom Co. manufactures two models, the XL and RO. It also has two departments, assembly and finishing. The company wants to assign overhead costs to its two different models to better understand the profitability of each model. The Tableau Dashboard. provides data for our analysis. Estimated Overhead Costs by Activity Cost Driver \& Expected Usage by Activity Note: Total overhead costs by department and total overhead costs by activity are equal. The costs are presented in two different ways here. Note: Total overhead costs by department and total overhead costs by activity are equal. The costs are presented in two different ways here. 8+ableau 1. Using data from the upper half of the dashboard, compute the company's single plantwide overhead rate based on direct labor hours. 2. Using data from the upper half of the dashboard, compute the company's single plantwide overhead rate based on machine hours. Note: Total overhead costs by department and total overhead costs by activity are equal. The costs are presented in two different ways here. +ableau 1. Using data from the upper half of the dashboard, compute the company's assembly department overhead rate using direct labor hours. 2. Using data from the upper half of the dashboard, compute the company's finishing department overhead rate using machine hours