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 | ||