If you could also show formulas if using excel to solve that would be great. Thanks!

Eilers Company has two producing departments and two support departments. The following budgeted data pertain to these four departments: 1. Allocate the overhead costs of the support departments to the producing departments using the reciprocal method. (Round allocation ratios to four significant digits. Round allocated costs to the nearest dollar.) 2. Using direct labor hours, compute departmental overhead rates. (Round to the nearest cent.)