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.$

Using the sequential method, allocate the costs of the warehouse department and data center department to the music

and books deparments in the table provided below.