Can you please solve this using EXCEL and breaking out each part if possible so I can learn it correctly.

Supplemental Problem #1-Activity-based costing versus traditional costing You have been hired by Casson Manufcturing to assess and make recommendations for the proftability of ts Bobblehead line of products. Casson Manufacturing makes two types of Pistol Pete Bobbleheads. The Huge Bobblehead is 15 feet tall and is sold as a lawn omament. The Tiny Bobblehead is 15 centimeters tall and is sold as a jewelry apparel item Although Pistol Pete has been manufacturing the Huge Bobbkehead for years, i only recently added the Tiry Bobblehead product line. The Tiny Bobblehead is more difficult to manufacture and requires special tooling and machine setups because it is made out of pure platinum Casson Manufacturing has faced intense competition for both products from competing manufacturers and is sales of the Tiny Bobbleheads have recently dropped dramatically. Much of the competition is from Norman, Oklahoma-based Sooner-Goober Manufacturing and the Casson plant manager is convinced that this producer is intentionally seling the Tiny Bobblehead below its manufacturing cost. Production Seling price Overhead per unit* Direct materials cost per unit Direct hbor cost per un Direct labor hours Number of production runs Machine hours Receiving orders Engineering hours Materials moves 100,000 units $500 900,000 units $100 $150 150,000 DLHs 10 runs 15,000 machine hours 85,000 machine hours 40 orders 10,000 hours 40 moves S3 S5 350,000 DLHs 190 runs 450 ordens 90,000 hours 60 moves Cakculated using a plantwide rate based on direct labor hours. This is the current way of assigning the plant's overhead to its products. Overhead Costs Setup costs Machine costs Receiving costs Engineering costs Materials handling costs 500,000 Total overhead costs S 250,000 S 1,250,000 S 2,000,000 $ 1,000,000 S 5,000,000 Your recommendation is to consider assigning overhead costs to each product line using Activity-based Costing (ABC). Setup costs would be assigned using Number of production runs. Machine costs would be assigned using Machine hours. Receiving costs would be assigned using Receiving orders. Engineering costs woukd be assigned using Engineering hours. Materials handling costs would be assigned using Materials moves. ***Problem 1 is continued on the next page**