Question
Gallatin Carpet Cleaning has always charged a flat fee per hundred square feet of carpet cleaned. The current fee is $13.05 per hundred square feet.
Gallatin Carpet Cleaning has always charged a flat fee per hundred square feet of carpet cleaned. The current fee is $13.05 per hundred square feet. However, there is some question about whether the company is making a profit on jobs requiring considerable travel time. The owners daughter suggested answering this question by designing an activity-based costing system using the information shown below:
Activity Cost Pool | Activity Measure | Activity for the Year | |
---|---|---|---|
Cleaning carpets | Square feet cleaned (00s) | 11,000 | hundred square feet |
Travel to jobs | Miles driven | 200,500 | miles |
Job support | Number of jobs | 2,400 | jobs |
Other (organization-sustaining costs and idle capacity costs) | None | Not applicable |
The total cost of operating the company for the year is $365,000 which includes the following costs:
Wages | $ 146,000 |
---|---|
Cleaning supplies | 22,000 |
Cleaning equipment depreciation | 14,000 |
Vehicle expenses | 37,000 |
Office expenses | 69,000 |
Presidents compensation | 77,000 |
Total cost | $ 365,000 |
She distributed these operating costs across her four activities as follows:
Distribution of Resource Consumption Across Activities | |||||
---|---|---|---|---|---|
Cleaning Carpets | Travel to Jobs | Job Support | Other | Total | |
Wages | 79% | 11% | 0% | 10% | 100% |
Cleaning supplies | 100% | 0% | 0% | 0% | 100% |
Cleaning equipment depreciation | 65% | 0% | 0% | 35% | 100% |
Vehicle expenses | 0% | 83% | 0% | 17% | 100% |
Office expenses | 0% | 0% | 58% | 42% | 100% |
Presidents compensation | 0% | 0% | 30% | 70% | 100% |
Job support consists of receiving calls from potential customers at the home office, scheduling jobs, billing, resolving issues, and so on.
Required:
- Prepare the first-stage allocation of costs to the activity cost pools.
- Compute the activity rates for the activity cost pools.
- The company recently completed a 200-square-foot carpet-cleaning job at the Flying N Rancha 57-mile round-trip from the companys home office. Compute the cost of this job using the activity-based costing system.
- The revenue from the Flying N Ranch was $26.10 (200 square feet @ $13.05 per hundred square feet). Calculate the customer margin earned on this job.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started