01 Liberation Sans 12 A A Wrap Text Text th- sta BIU A E Merge & Center $ % 9 Conditional Format Formatting as Table Styles Cell art Delete Forma xvfx D Formula: Divide: Cell Refedancing Using Excel To Compute Activity-Based Overhead Rates PROBLEM Weisman, Inc. uses activity-based costing as the basis for information to set prices for its six lines of seasonal coats. The company's cost pools, estimated everhead costs, and estimated use of cost drivers are presented here. Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem or work area as indicated Estimated 1 Activity Cost Pools Overhead Estimated Use of Cost Drivers Per Activity Activity Cost Pools Sizing and cutting 2 Sizing and cutting 4,000,000 160,000 machine hours Suching and trimming Wrapping and packing 80,000 labor hours 32,000 finished unita Compute the activity-based overheed rates for each of the activity cost pools 1,440,000 Staching and trimming Wrapping and packing Activity-Based Overhead Rates 336,000 P Q