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 overhead costs, and estimated use of cost drivers are presented here.

X Chapter4Problems Question2 [Protected View] - Excel ACROBAT Power Pivot Tell me what you want to do... File Home Insert Page Layout Formulas Data Review View Sign in 2. Share PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X A5 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 overhead costs, and B D E F G H | J K L M N o P R 1 Formula: Divide; Cell Referencing 2 4 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. 3. Using Excel To Compute Activity-Based Overhead Rates PROBLEM 5 Weisman, Inc. uses activity-based costing as the basis for information to 6 set prices for its six lines of seasonal coats. The company's cost pools, 7 estimated overhead costs, and estimated use of cost drivers are 8 presented here. 9 10 Estimated Estimated Use of Cost 11 Activity Cost Pools Overhead Drivers Per Activity 12 Sizing and cutting $ 4,000,000 160,000 machine hours 13 Stitching and trimming 1,440,000 80,000 labor hours 14 Wrapping and packing 336,000 32,000 finished units 15 16 Compute the activity-based overhead rates for each of the activity cost 17 pools. 18 Activity-Based Overhead Rates Activity Cost Pools Sizing and cutting Stitching and trimming Wrapping and packing 19 20 21 22 23 24 25 Enter Answer + Ready 100% a i x] AO