Liberation Sans 12 AA Paste BIU A Conditional Formatting Insert Text Format as Table Delete $ -% Editing Cell Styles Format w Analyze Deta A1 xfx Function: SUM; Formula: Multiply, Divide; Cell Referencing " C D Function: SUM; Formula: Mutiply, Divide: Cell Referencing Using Excel to Compute Overhead Applied for Activity-Based Costing PROBLEM Spud, Inc. manufacturer of gourmet macks, mploys activity-based costing. The budgeted data for each of the activity cost pools is provided below for the year 2022, Estimated Use of Cost Drivers Per Activity Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem area or work area as indicated. Use the SUM function with cell references 30 calculate the total 14 Adivity Cant Poolsi Overhead 11 Ordering and receiving $4,000 12,000 onders Food processing 480,000 13 Packaging 1,760,000 60,000 machine hours 40,000 labor bours Activity Cost Pools Ordering and receiving Overhead Rates Overhead Applied 15 The following activities occurred during 2022. per 16 17 Number of order Number of machine hours 19 Number of labor hours 29 21 21 25 24 Enter Answer + Ready 7,000 40,000 25,000 Food processing Packaging Total applied E 100%