please try if possible to include some of the calculations on an excel!

Exercise 7-14 Sheffield makes two products, Simple and Complex. As their names suggest, Simple is the more basic product, and Complex comes with all the bells and whistles. The company has always allocated overhead costs to products based on machine hours. Last year, the company implemented an activity-based costing system, and managers determined the following activity pools and rates based on total overhead of $1,591,000: Rate Assembly Fabrication Setups Bonding $1.25 per direct labor hour $9.75 per machine hour $18 per batch $193,750 direct to Complex Only the Complex product requires bonding, so all the costs of bonding should be allocated to Complex. The following data relate to both products Units produced Direct labor hours Machine hours Batches Simple 127,000 230,000 53,000 2,600 Complex 41,000 109,000 33,000 4,900 Using the traditional method of allocating overhead costs, | allocate overhead cost to the products. show that the overhead assigned to each product sums to the total company overhead. determine the overhead cost per unit for each product. Round overhead rate and overhead per unit answers to 2 decimal places, e.g. 15.25.) Simple Complex Total Machine hours Overhead rate Total overhead to product Simple Complex Total overhead to product Number of units produced Overhead per unit Using the activity-based costing rates, allocate overhead cost to the products. show that the overhead assigned to each product sums to the total determine the overhead cost per unit for each product. (Round per unit answers to 2 decimal places, e.g. 15.25) Simple Complex Total Assembly Fabrication Setups Bonding Total overhead Simple Complex Total overhead to product Number of units produced Overhead per unit