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 |
Elmwood 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 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 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 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: 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 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 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 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 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 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...