Using Excel to Compute Overhead Applied for Activity-Based Costing Student Work Area PROBLEM Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with Spud, Inc. a manufacturer of gourmet snacks, employs activity-based costing. The budgeted data cell references to the Problem area or work area as indicated. Use the SUM anction with cell references for each of the activity cost pools is provided below for the year 2022. to calculate the total. Estimated Estimated Use of Cost Drivers What is the total overhead applied? Activity Cost Pools Overhead Per Activity Ordering and receiving 35 34,000 12,000 orders Overhead Food processing 480,000 60,000 machine hours Activity Cost Pools Overhead Rates Applied Packaging 1,760,000 40,000 labor hours Ordering and receiving ' per ' ' The following activities occurred during 2022. Food processing ' per ' ' Number of orders 7,000 Packaging ' per ' ' Number of machine hours 40,000 Number of labor hours 25,000 Total applied