Fogerty Company makes two products from titanium,$\_$Huhs and Sprockets.

Data regarding the two products follow:

Direct Labor$-$Hours per Unit

Annual Production

Hubs

$0\mathrm{.}80$

$10,000$ units

Sprockets $.........................=0\mathrm{.}40$

$40,000$ units

Additional information about the company follows:

a$.$ Hubs require $$32$ in direct materials per unit, and Sprockets require $$18.$

b$.$ The direct labor wage rate is $$15$ per hour.

c$.$ Hubs require special equipment and are more complex to manufacture than Sprockets.

d$.$ The ABC system has the following activity cost pools:

Activity Cost Pool $($Activity Measure$)$

Required:

Compute the activity rate for each activity cost pool. Did you compute an activity rate for all of the

activity cost pools? Why?

Determine the unit product cost of each product according to the ABC system.

please answer work using excel