Gallatin Carpet Cleaning is a small, family-owned business operating out of Bozeman, Montana. For its services,...

Free

60.1K

Verified Solution

Question

Accounting

Gallatin Carpet Cleaning is a small, family-owned businessoperating out of Bozeman, Montana. For its services, the companyhas always charged a flat fee per hundred square feet of carpetcleaned. The current fee is $22.95 per hundred square feet.However, there is some question about whether the company isactually making any money on jobs for some customers—particularlythose located on remote ranches that require considerable traveltime. The owner’s daughter, home for the summer from college, hassuggested investigating this question using activity-based costing.After some discussion, she designed a simple system consisting offour activity cost pools. The activity cost pools and theiractivity measures appear below:

Activity Cost PoolActivity MeasureActivity for the Year
Cleaning carpetsSquare feet cleaned (00s)7,000hundred square feet
Travel to jobsMiles driven202,500miles
Job supportNumber of jobs1,800jobs
Other (organization-sustaining costs and idle capacitycosts)NoneNot applicable

The total cost of operating the company for the year is $347,000which includes the following costs:

Wages$143,000
Cleaning supplies21,000
Cleaning equipment depreciation12,000
Vehicle expenses29,000
Office expenses57,000
President’s compensation85,000
Total cost$347,000

Resource consumption is distributed across the activities asfollows:

Distribution of Resource Consumption AcrossActivities
Cleaning CarpetsTravel to JobsJob SupportOtherTotal
Wages77%13%0%10%100%
Cleaning supplies100%0%0%0%100%
Cleaning equipment depreciation72%0%0%28%100%
Vehicle expenses0%77%0%23%100%
Office expenses0%0%56%44%100%
President’s compensation0%0%32%68%100%

Job support consists of receiving calls from potential customersat the home office, scheduling jobs, billing, resolving issues, andso on.

Required:

1. Prepare the first-stage allocation of costs to the activitycost pools.

2. Compute the activity rates for the activity cost pools.

3. The company recently completed a 200 square footcarpet-cleaning job at the Flying N Ranch—a 51-mile round-tripjourney from the company’s offices in Bozeman. Compute the cost ofthis job using the activity-based costing system.

4. The revenue from the Flying N Ranch was $45.90 (200 squarefeet @ $22.95 per hundred square feet). Calculate the customermargin earned on this job.

Answer & Explanation Solved by verified expert
3.5 Ratings (571 Votes)

1
Cleaning Carpets Travel to Jobs Job support Other Total
Wages 110110 18590 0 14300 143000
Cleaning supplies 21000 0 0 0 21000
Cleaning equipment depreciation 8640 0 0 3360 12000
Vehicle expenses 0 22330 0 6670 29000
Office expense 0 0 31920 25080 57000
President’s compensation 0 0 27200 57800 85000
Total cost 139750 40920 59120 107210 347000
2
Activity Cost Pool Activity Rate   
Cleaning carpets 19.96 per hundred square feet =139750/7000
Travel to jobs 0.20 per mile =40920/202500
Job support 32.84 per job =59120/1800
3
Activity Cost Pool Activity Rate    Activity Total
Cleaning carpets 19.96 2 39.92
Travel to jobs 0.20 51 10.20
Job support 32.84 1 32.84
82.96
Cost of the job $82.96
4
Customer Margin—Activity-Based Costing
Sales 45.90
Costs:
Cleaning carpets 39.92
Travel to jobs 10.20
Job support 32.84 82.96
Customer margin -37.06

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students