Question

In: Accounting

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 $ 400,000 5,000 deliveries
  Manual order processing Number of manual orders 300,000 4,000 orders
  Electronic order processing Number of electronic orders 200,000 12,500 orders
  Line item picking Number of line items picked 500,000 400,000 line items
  Total selling and administrative expenses $ 1,400,000
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 10           20          
  Number of manual orders 0           40          
  Number of electronic orders 10           0          
  Number of line items picked 100           260          
Required:
1. 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
2.

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

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

Solutions

Expert Solution

1)Activity rate for each activity cost pool
Activity cost pool Activity rate
Customer deliveries 400,000/5000= $80.00 per delivery
Manual order processing 300,000/4000= $75.00 per order
Electronic order processing 200,000/12,500= $16.00 per order
Line item picking 500,000/400,000= $1.25 per line item
2)Activity Cost assigned to City General
Rate Activity total
Customer deliveries $80.00 10 $800.00
Manual order processing $75.00 0 $0.00
Electronic order processing $16.00 10 $160.00
Line item picking $1.25 100 $125.00
$1,085.00
Activity cost assinged to City General $1,085 answer
Activity cost assinged to County General
Rate Activity total
Customer deliveries $80.00 20 $1,600.00
Manual order processing $75.00 40 $3,000.00
Electronic order processing $16.00 0 $0.00
Line item picking $1.25 260 $325.00
Activity cost assinged to COuntryGeneral $4,925.00

Related Solutions

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 $ 426,400 5,200 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 5%. For example, if a hospital buys supplies from Worley that had 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...
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 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...
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 9%. For example, if a hospital buys supplies from Worley that had cost Worley $100 to buy from manufacturers, Worley would charge the hospital $109 to purchase these supplies.      For years, Worley believed that the 9% markup covered its selling...
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 10%. For example, if a hospital buys supplies from Worley that cost Worley $100 to buy from manufacturers, Worley would charge the hospital $110 to purchase these supplies. For years, Worley believed that the 10% 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 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 9%. For example, if a hospital buys supplies from Worley that cost Worley $100 to buy from manufacturers, Worley would charge the hospital $109 to purchase these supplies. For years, Worley believed that the 9% 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 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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT