can we solve this problem in the excel sheet provided please i have 15 mins to complete

Intioduction: In this problem we want to allooate the cost of thared costs between 2 sroducts: Cat Earingr and Dog Earrings. Like any deteriming the amount of applied ovethead. Alloe ate oxerhead between 2 products. CAT and Doc: gou ve done this betore. The appled ouethead ealoulyion is bused on if as appies 1 overhesad rare, and (2) the actual oest divet. 2 Cralculate the applied overhead rate FDB EACH OF THE ACTREITY CENIERS described belox. Activits Based Costing - Duerhead Applied Faetory Duerhead Rates Step 1: Caleulate the ABC overhead anslie atinn rab. Step 2. Allocate estimated overhead ARC nueshoad analionsinen w