Question

Med Max buys surgical supplies from a variety of manufacturers and then resells and delivers these...

Med Max buys surgical supplies from a variety of manufacturers and then resells and delivers these supplies to dozens of hospitals. In the face of declining profits, Med Max decided to implement an activity-based costing system to improve its understanding of the costs incurred to serve each hospital. The company broke its selling and administrative expenses into four activities as shown below:

Activity Cost Pool Activity Measure Total Cost Total Activity
Customer deliveries Number of deliveries $ 280,000 4,000 deliveries
Manual order processing Number of manual orders 195,000 3,000 orders
Electronic order processing Number of electronic orders 172,500 11,500 orders
Line item picking Number of line items picked 300,000 300,000 line items
Total selling and administrative expenses $ 947,500

Med Max gathered the data below for two of the many hospitals that it serves—City General and County General:

Activity
Activity Measure City General County General
Number of deliveries 20 40
Number of manual orders 0 80
Number of electronic orders 15 0
Number of line items picked 150 310

Compute the activity rate for each activity cost pool. (Round your answers to 2 decimal places.)

Activity Cost Pool Activity Rate
Customer deliveries per delivery
Manual order processing per manual order
Electronic order processing per electronic order
Line item picking    per line item picked

Compute the total activity costs that would be assigned to City General and County General. (Do not round intermediate calculations.)

ABC Cost
Activity Cost Pool City General County General
Customer deliveries
Manual order processing
Electronic order processing
Line item picking
Total activity costs $0 $0

Homework Answers

Answer #1

Solution:

Computation of Activity rates
Activity cost pool Total Cost Total Activity Activity rate
Customer Deliveries $2,80,000 5000 $56.00 per delivery
manual Order processing $1,95,000 4000 $48.75 per order
Electronic order processing $1,72,500 12500 $13.80 per order
Line Item picking $3,00,000 400000 $0.75 per line item
Computation of Overhead assigned to products
City General Country General
Activity cost pool Activity level used Activity rate Cost assigned Activity level used Activity rate Cost assigned
Machining 20 56.00 $1,120 40 56.00 $2,240
Setups 0 48.75 $0 80 48.75 $3,900
Product level 15 13.80 $207 0 13.80 $0
General Factory 150 0.75 $113 310 0.75 $233
Total Ativity cost assigned $1,440 $6,373
Know the answer?
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
Similar Questions
Med Max buys surgical supplies from a variety of manufacturers and then resells and delivers these...
Med Max buys surgical supplies from a variety of manufacturers and then resells and delivers these supplies to dozens of hospitals. In the face of declining profits, Med Max decided to implement an activity-based costing system to improve its understanding of the costs incurred to serve each hospital. The company broke its selling and administrative expenses into four activities as shown below:   Activity Cost Pool Activity Measure Total Cost Total Activity   Customer deliveries Number of deliveries $ 439,900 5,300 deliveries...
Med Max buys surgical supplies from a variety of manufacturers and then resells and delivers these...
Med Max buys surgical supplies from a variety of manufacturers and then resells and delivers these supplies to dozens of hospitals. In the face of declining profits, Med Max decided to implement an activity-based costing system to improve its understanding of the costs incurred to serve each hospital. The company broke its selling and administrative expenses into four activities as shown below: Activity Cost Pool Activity Measure Total Cost Total Activity Customer deliveries Number of deliveries $ 495,900 5,700 deliveries...
Worley Company buys surgical supplies from a variety of manufacturers and then resells and delivers these...
Worley Company buys surgical supplies from a variety of manufacturers and then resells and delivers these supplies to hundreds of hospitals. Worley sets its prices for all hospitals by marking up its cost of goods sold to those hospitals by 8%. For example, if a hospital buys supplies from Worley that cost Worley $100 to buy from manufacturers, Worley would charge the hospital $108 to purchase these supplies. For years, Worley believed that the 8% markup covered its selling and...
Worley Company buys surgical supplies from a variety of manufacturers and then resells and delivers these...
Worley Company buys surgical supplies from a variety of manufacturers and then resells and delivers these supplies to hundreds of hospitals. Worley sets its prices for all hospitals by marking up its cost of goods sold to those hospitals by 6%. For example, if a hospital buys supplies from Worley that cost Worley $100 to buy from manufacturers, Worley would charge the hospital $106 to purchase these supplies. For years, Worley believed that the 6% markup covered its selling and...
Worley Company buys surgical supplies from a variety of manufacturers and then resells and delivers these...
Worley Company buys surgical supplies from a variety of manufacturers and then resells and delivers these supplies to hundreds of hospitals. Worley sets its prices for all hospitals by marking up its cost of goods sold to those hospitals by 5%. For example, if a hospital buys supplies from Worley that cost Worley $100 to buy from manufacturers, Worley would charge the hospital $105 to purchase these supplies. For years, Worley believed that the 5% markup covered its selling and...
For years, Worley believed that the 8% markup covered its selling and administrative expenses and provided...
For years, Worley believed that the 8% markup covered its selling and administrative expenses and provided a reasonable profit. However, in the face of declining profits, Worley decided to implement an activity-based costing system to help improve its understanding of customer profitability. The company broke its selling and administrative expenses into five activities as shown: Activity Cost Pool (Activity Measure) Total Cost Total Activity Customer deliveries (Number of deliveries) $ 510,000 6,000 deliveries Manual order processing (Number of manual orders)...
Assume a service company has implemented an activity-based costing system with five activities as shown below:...
Assume a service company has implemented an activity-based costing system with five activities as shown below: Activity Cost Pool (Activity Measure) Total Cost Total Activity Customer deliveries (Number of deliveries) $ 400,000 8,000 deliveries Manual order processing (Number of manual orders) $ 280,000 5,000 manual orders Electronic order processing (Number of electronic orders) $ 150,000 15,000 electronic orders Line item picking (Number of line items picked) $ 450,000 375,000 line items Other organization-sustaining costs (None) $ 300,000 The company serves...
Marvin’s Kitchen Supply delivers restaurant supplies throughout the city. The firm adds 10 percent to the...
Marvin’s Kitchen Supply delivers restaurant supplies throughout the city. The firm adds 10 percent to the cost of the supplies to cover the delivery cost. The delivery fee is meant to cover the cost of delivery. A consultant has analyzed the delivery service using activity-based costing methods and identified four activities. Data on these activities follow: Cost Driver Volume Activity Cost Driver Cost Driver Volume Processing order Number of orders $ 36,000 3,000 orders Loading truck Number of items 126,000...
Applying ABC Methods to Customer Profitability Analysis Bountiful Harvest Distribution delivers supplies to small grocers throughout...
Applying ABC Methods to Customer Profitability Analysis Bountiful Harvest Distribution delivers supplies to small grocers throughout the region. Bountiful currently allocates order and delivery service costs based on a percentage of total revenue. Estimated revenue for the year is $5.16 Million. A consultant has analyzed the order and delivery service costs and identified four activities. Data on these activities are: Activity Cost Driver Cost Driver Volume Process order number of orders $50,000 4,000 orders Load truck number of items $100,000...
1. Choi Corporation is conducting a time-driven activity-based costing study in its Order Fulfillment Department. The...
1. Choi Corporation is conducting a time-driven activity-based costing study in its Order Fulfillment Department. The company has provided the following data to aid in that study: Activity Data: Processing Orders Preparing Deliveries Handling Returns Minutes per unit of the activity 14 30 32 Cost Object Data: Customer P Customer Q Customer R Number of orders processed 32 24 3 Number of deliveries prepared 14 9 9 Number of returns handled 0 0 1 The cost per minute of the...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT