ule: Divide; Cell Referencing BE.12 . Using Excel to Calculate Activity-Based Costing Rates and Student WorkArea Activity Levels Required: Provide input into cells shaded in yellow in this PROBLEM template. Use mathematical formulas with cell references to the Spin Cycle Company uses three activity pools to apply overhead to its Problem area as indicated. products. Each activity has a cost driver used to allocate the overhead costs to the product. The activities and related overhead costs are as Estimated a. Calculate the predetermined overhead rate for each activity. Activities Overhead Product design iii 40,000 Cost Pool Predetermined Overhead Rates Machining 300,000 Product design ' per ' Material handling 100,000 Machining ' per ' The cost drivers and estimated use are as follows. Material handling ' per ' Estimated Use of Cost Activity Cost Pools Activities Drivers Per Activity b. Classify each of these activities as unitlevel, batchlevel, Product design Number of product '10 prod uctlevel, or facility-level. changes Machining Machine hours 150,000 Activity Activity Level Mate rial handling Number of set-ups 100 Product design Machining ' Material handling