Activity Rates

    Patten Company uses activity-based costing (ABC). Patten manufactures toy cars using two activities: plastic injection molding and decal application. Patten's 20X1 total budgeted overhead costs for these two activities are $492,000 (90% for injection molding and 10% for decal application). Molding overhead costs are driven by the number of pounds of plastic that are molded together. Decal application overhead costs are driven by the number of decals applied to toys. The budgeted activity data for 20X1 are as follows: Line Item DescriptionNumerical DataPounds of plastic molded1,940,000Number of decals applied197,000 Required: 1. Calculate the activity rate for the plastic injection molding activity. Round your answer to the nearest cent. fill in the blank 1 of 1$ per pound molded 2. Calculate the activity rate for the decal application activity. Round your answer to the nearest cent. fill in the blank 1 of 1$ per decal applied     Comparing ABC and Plantwide Overhead Cost Assignments Castle Dale Company uses activity-based costing (ABC). The controller identified two activities and their budgeted costs: Line Item DescriptionAmountSetting up equipment$660,000Other overheard$2,376,000 Setting up equipment is based on setup hours, and other overhead is based on oven hours. Castle Dale produces two products, Fudge and Cookies. Information on each product is as follows: Line Item DescriptionFudgeCookiesBatches produced16,000890,000Setup hours12,0003,000Oven hours2,20015,400 Required: 1. Calculate the activity rate for (a) setting up equipment and (b) other overhead. Line Item DescriptionActivity ratea. Setting up equipment$fill in the blank 1 per setup hourb. Other overhead$fill in the blank 2 per oven hour 2. How much total overhead is assigned to Fudge using ABC? fill in the blank 1 of 1$ 3. What is the unit overhead assigned to Fudge using ABC? Round to the nearest cent. fill in the blank 1 of 1$per unit 4. Now, ignoring the ABC results, calculate the plantwide overhead rate, based on oven hours. Round to the nearest cent. fill in the blank 1 of 1$ per oven hour 5. How much total overhead is assigned to Fudge using the plantwide overhead rate? fill in the blank 1 of 1$ 6a. The difference in the total overhead assigned to Fudge is different under the ABC system and non–ABC system because different treatment of setup costs.difference in the Batches produced.difference in the sale prices of the products.different oven temperatures required for baking fudge and cookies.. 6b. What is the difference in total overhead assigned to fudge under the two methods? fill in the blank 1 of 1$

Sample Solution

   

1. Calculating Activity Rates:

a) Plastic injection molding:

  • Total budgeted overhead cost: $492,000 * 90% = $442,800
  • Budgeted pounds of plastic molded: 1,940,000 pounds
  • Activity rate: $442,800 / 1,940,000 pounds = $0.23 per pound molded (rounded to nearest cent)

Full Answer Section

     

Decal application:

  • Total budgeted overhead cost: $492,000 * 10% = $49,200
  • Budgeted number of decals applied: 197,000
  • Activity rate: $49,200 / 197,000 = $0.25 per decal applied (rounded to nearest cent)

Castle Dale Company: Comparison of ABC and Plantwide Overhead

1. Activity Rates:

a) Setting up equipment:

  • Total budgeted cost: $660,000
  • Budgeted setup hours: 12,000 + 3,000 = 15,000 hours
  • Activity rate: $660,000 / 15,000 hours = $44 per setup hour

b) Other overhead:

  • Total budgeted cost: $2,376,000
  • Budgeted oven hours: 2,200 + 15,400 = 17,600 hours
  • Activity rate: $2,376,000 / 17,600 hours = $135 per oven hour

2. Total Overhead for Fudge:

  • Setting up equipment: 16,000 batches * $44/batch = $704,000
  • Other overhead: 2,200 hours * $135/hour = $297,000
  • Total overhead: $704,000 + $297,000 = $1,001,000

3. Unit Overhead for Fudge:

  • Total overhead: $1,001,000
  • Batches produced: 16,000
  • Unit overhead: $1,001,000 / 16,000 = $62.56 per unit (rounded to nearest cent)

4. Plantwide Overhead Rate:

  • Total budgeted overhead: $660,000 + $2,376,000 = $3,036,000
  • Budgeted oven hours: 17,600 hours
  • Plantwide overhead rate: $3,036,000 / 17,600 hours = $172.44 per oven hour (rounded to nearest cent)

5. Total Overhead for Fudge using Plantwide Rate:

  • Oven hours: 2,200 hours
  • Plantwide overhead rate: $172.44/hour
  • Total overhead: 2,200 hours * $172.44/hour = $377,568

6. Comparison of Overhead Assignments:

a) Reason for difference:

The difference in total overhead assigned to Fudge between the ABC system and the plantwide method is primarily due to the different treatment of setup costs. The ABC system assigns a significant portion of overhead to Fudge based on its setup hours, while the plantwide method simply spreads the total overhead cost evenly across all units based on oven hours. This results in Fudge being assigned more overhead under the ABC system because it requires more setup time per unit.

b) Difference in total overhead:

  • ABC system: $1,001,000
  • Plantwide system: $377,568
  • Difference: $623,432

In conclusion, the ABC system provides a more accurate allocation of overhead costs to products based on their actual consumption of resources, particularly relevant for products with significant differences in setup times.

IS IT YOUR FIRST TIME HERE? WELCOME

USE COUPON "11OFF" AND GET 11% OFF YOUR ORDERS