please solve in excell

EXERCISE 7-13 Computing ABC Product Costs LO7-3, L07-4 Fogerty Company makes two products-titanium Hubs and Sprockets. Data regarding the two products follow: Hubs..... Sprockets. Direct Labor-Hours per Unit Activity Cost Pool (Activity Measure) Machine setups (number of setups) Special processing (machine-hours). General factory (organization-sustaining). 0.80 0.40 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. The ABC system has the following activity cost pools: d. Estimated Overhead Cost Hubs Annual Production 10,000 units 40,000 units $72,000 100 $200,000 5,000 $816,000 Activity Sprockets 300 0 Total 400 5,000 Required: 1. Compute the activity rate for each activity cost pool. Did you compute an activity rate for all of the activity cost pools? Why? 2. Determine the unit product cost of each product according to the ABC system