Question

Elmwood Company has identified seven activities as part of its manufacturing process and chosen corresponding activity driver
0 0
Add a comment Improve this question Transcribed image text
Answer #1
Driver Usage
Activity Cost Activity driver Prod 1 Prod 2 Activity rate Activity cost: Pro 1 Activity cost: Pro 2
Design $          52,000 Design time 1600 2400 Hours $          13 Per Hour $    20,800 $      31,200
Preparation $          15,200 Labor hours 5400 2200 Hours $             2 Per Hour $    10,800 $        4,400
Machining $        189,000 Machine hours 11000          10,000 $             9 Per Hour $    99,000 $      90,000
Finishing $          29,000 Batches 100 150 $        116 Per Batch $    11,600 $      17,400
Inspection $          18,000 Units 2400 2100 $             4 Per Unit $      9,600 $        8,400
Packaging $          22,896 Orders 166 50 $        106 Per order $    17,596 $        5,300
Shipping $          13,000 Packages 70 30 $        130 Per package $      9,100 $        3,900

Formula view:

Driver Usage
Activity Cost Activity driver Prod 1 Prod 2 Activity rate Activity cost: Pro 1 Activity cost: Pro 2
Design 52000 Design time 1600 2400 Hours =+I3/D3 Per Hour =B3*D3/(D3+E3) =B3*E3/(D3+E3)
Preparation 15200 Labor hours 5400 =+D4*J4/I4 Hours =+I4/D4 Per Hour 10800 =+B4-I4
Machining 189000 Machine hours =+I5/G5 =+J5/G5 9 Per Hour 99000 =B5-I5
Finishing =+I6+J6 Batches 100 150 116 Per Batch =+D6*G6 =+E6*G6
Inspection =I7+J7 Units =+I7/G7 =+J7/G7 4 Per Unit 9600 8400
Packaging =I8+J8 Orders =+I8/G8 50 106 Per order 17596 =+E8*G8
Shipping 13000 Packages 70 =D9*J9/I9 =+I9/D9 Per package =B9-J9 3900
Add a comment
Know the answer?
Add Answer to:
Elmwood Company has identified seven activities as part of its manufacturing process and chosen corresponding activity...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Magnolia Company has identified seven activities as part of its manufacturing process and chosen corresponding activity...

    Magnolia Company has identified seven activities as part of its manufacturing process and chosen corresponding activity drivers for each activity. The chart below lists the total cost of each activity, the amount of activity driver used for each of Magnolia's two products, the activity rate, and the activity cost assigned to each product. Fill in the blanks below: Driver Usage Cost Activity Driver Prod. 1 Prod. 2 Activity Rate Activity Cost:Prod. 1 Activity Cost:Prod. 2 $ 880 hour 1,370 hours...

  • Magnolia Company has identified seven activities as part of its manufacturing process and chosen corresponding activity...

    Magnolia Company has identified seven activities as part of its manufacturing process and chosen corresponding activity drivers for each activity. The chart below lists the total cost of each activity, the amount of activity driver used for each of Magnolia's two products, the activity rate, and the activity cost assigned to each product. Fill in the blanks below: Cost Activity Driver Activity Rate Driver Usage Prod. 1 Prod. 2 850 1,200 hours 3,090 hours Activity Cost:Prod. 1 Activity Cost:Prod. 2...

  • Gable Company uses three activity cost pools. Each pool has a cost driver. Information for Gable...

    Gable Company uses three activity cost pools. Each pool has a cost driver. Information for Gable Company follows: Activity Cost Pools Machining Designing costs Setup costs Total Cost of Pool Cost Driver $312,000 Number of machine hours 73,600 Number of design hours 71,600 Number of batches Estimated Cost Driver 80,000 8,000 500 Required: 1. Compute the activity rate for each activity. (Round your answers to 2 decimal places.) Activity Rate per Machine Hour Activity Machining Design Costs Setup per Design...

  • Gable Company uses three activity cost pools. Each pool has a cost driver. Information for Gable...

    Gable Company uses three activity cost pools. Each pool has a cost driver. Information for Gable Company follows: Activity Cost Pools Machining Designing costs Setup costs Total Cost of Pool Cost Driver $312,000 Number of machine hours 73,600 Number of design hours 71,600 Number of batches Estimated Cost Driver 80,000 8,000 500 Required: 1. Compute the activity rate for each activity. (Round your answers to 2 decimal places.) Activity Rate per Machine Hour Activity Machining Design Costs Setup per Design...

  • helpp!! Lynwood, Inc. produces two different products (Product A and Product X) using two different activities:...

    helpp!! Lynwood, Inc. produces two different products (Product A and Product X) using two different activities: Machining, which uses machine hours as a activity driver, and Inspection, which uses number of batches as an activity driver. The activity rate for Machining is $180 per machine hour, and th- activity rate for inspection is $580 per batch. The activity drivers are used as follows: Machine hours Number of batches Product A Product X 1,200 3,200 55 18 Total 4,400 73 What...

  • 6. s (Product C and Product 2) using two different activities Machining, which uses machine hours...

    6. s (Product C and Product 2) using two different activities Machining, which uses machine hours as an . The cost of Machining is $945,000, while the cost of Inspection is Washington, Inc. produces two different products (Product C and Product 2) using two different actvities Machining activity driver, and Inspection, which uses number of batches as an activity driver $37.370 The activity drivers are used as follows Machine hours Number of batches Product C 1,900 53 Product 2 3,500...

  • Required information Gable Company uses three activity cost pools. Each pool has a cost driver. Information...

    Required information Gable Company uses three activity cost pools. Each pool has a cost driver. Information for Gable Company follows: Activity Cost Pools Machining Designing costs Setup costs Total Cost of Pool Cost Driver $ 250,680 Number of machine hours 61,600 Number of design hours 66,482 Number of batches Estimated Cost Driver 71,600 7.ee 465 Required: 1. Compute the activity rate for each activity 2. Classify each activity as facility, product, batch, or unit level. Complete this question by entering...

  • Required information Gable Company uses three activity cost pools. Each pool has a cost driver. Information...

    Required information Gable Company uses three activity cost pools. Each pool has a cost driver. Information for Gable Company follows: Activity Cost Pools Machining Designing costs Setup costs Total Cost of Pool Cost Driver $171,100 Number of machine hours 45,100 Number of design hours 66,123 Number of batches Estimated Cost Driver 59,000 5,500 465 Required: 1. Compute the activity rate for each activity. 2. Classify each activity as facility, product, batch, or unit level. Complete this question by entering your...

  • Gable Company uses three activity cost pools. Each pool has a cost driver. Information for Gable...

    Gable Company uses three activity cost pools. Each pool has a cost driver. Information for Gable Company follows: Activity Cost Pools Machining Designing costs Setup costs Total Cost of Pool Cost Driver $280,460 Number of machine hours 67,500 Number of design hours 70,070 Number of batches Estimated Cost Driver 75,800 7,500 490 Required: 1. Compute the activity rate for each activity. 2. Classify each activity as facility, product, batch, or unit level. Complete this question by entering your answers in...

  • Required information Gable Company uses three activity cost pools. Each pool has a cost driver. Information...

    Required information Gable Company uses three activity cost pools. Each pool has a cost driver. Information for Gable Company follows: Activity Cost Pools Machining Designing costs Setup costs Total Cost of Pool Cost Driver $183,300 Number of machine hours 47,725 Number of design hours 71,150 Number of batches Estimated Cost Driver 61,100 5,750 500 Required: 1. Compute the activity rate for each activity. 2. Classify each activity as facility, product, batch, or unit level. Complete this question by entering your...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT