In: Accounting
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.) | ||||||||||||||||||
|
|||||||||||||||||||
2. |
Compute the total activity costs that would be assigned to City General and County General. (Do not round intermediate calculations.) |
City General: | ||||||||||||
|
County General: |
|
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 |