Goldfarb's Book and Music Store has two service departments, Warehouse and Data Center. Warehouse Department costs of $$350,000$ are allocated on the basis of budgeted warehouse$-$hours.

Data Center Department costs of $$150,000$ are allocated based on the number of computer log$-$on hours. The costs of operating departments Music and Books are $$125,000$ and $$150,000,$ respecti

Data on budgeted warehouse$-$hours and number of computer log$-$on hours are as follows:

Please make sure you review Cornerstone $7\mathrm{.}3,7\mathrm{.}4,$ and $7\mathrm{.}5$ before attempting this part of the project.

For all requirements, round allocation ratios to four significant digits and round allocated costs to the nearest dollar.

Required: Complete $1-8$ below and all computations below must use cell references except for #$7.$

Calculate the allocation ratios for the four departments using in preparation for the reciprocal method in the table provided below.

Develop a simultaneous equations system of total costs for the support departments. Solver for the total reciprocated costs of the Warehouse and Data Center Departments

to the Music and Books Departments.