Gallatin Carpet Cleaning is a small, family-owned business operating out of Bozeman, Montana. For its services, the company has always charged a flat fee per hundred square feet of carpet cleaned. The current fee is $22.40 per hundred square feet. However, there is some question about whether the company is actually making any money on jobs for some customers—particularly those located on remote ranches that require considerable travel time. The owner’s daughter, home for the summer from college, has suggested investigating this question using activity-based costing. After some discussion, a simple system consisting of four activity cost pools seemed to be adequate. The activity cost pools and their activity measures appear below:   Activity Cost Pool Activity Measure Activity for the Year Cleaning carpets Square feet cleaned (00s)   10,500   hundred square feet Travel to jobs Miles driven   96,500   miles Job support Number of jobs   1,700   jobs Other (costs of idle capacityand organization-sustaining costs) None   Not applicable     The total cost of operating the company for the year is $370,000, which includes the following costs:          Wages $ 144,000   Cleaning supplies   35,000   Cleaning equipment depreciation   14,000   Vehicle expenses   36,000   Office expenses   69,000   President’s compensation   72,000   Total cost $ 370,000     Resource consumption is distributed across the activities as follows: Distribution of Resource Consumption Across Activities       Cleaning Carpets Travel to Jobs Job Support Other Total Wages   73 %     14 %     0 %     13 %       100 % Cleaning supplies   100 %     0 %     0 %     0 %       100 % Cleaning equipment depreciation   67 %     0 %     0 %     33 %       100 % Vehicle expenses   0 %     82 %     0 %     18 %       100 % Office expenses   0 %     0 %     64 %     36 %       100 % President’s compensation   0 %     0 %     31 %     69 %       100 %     Job support consists of receiving calls from potential customers at the home office, schedulingjobs, billing, resolving issues, and so on. Required: 1. Prepare the first-stage allocation of costs to the activity cost pools.       Cleaning   Job       Carpets Travel to Jobs Support Other Total Wages           Cleaning supplies           Cleaning equipment depreciation           Vehicle expenses           Office expenses           President’s compensation           Total cost             2. Compute the activity rates for the activity cost pools. (Round your answers to 2 decimal places.)     Activity Cost Pool Activity Rate   Cleaning carpets   per hundred square feet Travel to jobs   per mile Job support   per job    3. The company recently completed a 4 hundred square foot carpet-cleaning job at the Flying N ranch—a 56.00-mile round-trip journey from the company’s offices in Bozeman. Compute the cost of this job using the activity-based costing system. (Round your intermediate and final answers to 2 decimal places.)       Cost of the job     4. The revenue from the Flying N ranch was $89.60 (4 hundred square feet at $22.40 per hundred square feet). Prepare a report showing the margin from this job. (Round your intermediate calculations and final answers to 2 decimal places.)     Gallatin Carpet Cleaning Customer Margin—Activity-Based Costing Amounts per Job       Costs:

Question

Gallatin Carpet Cleaning is a small, family-owned business operating out of Bozeman, Montana. For its services, the company has always charged a flat fee per hundred square feet of carpet cleaned. The current fee is $22.40 per hundred square feet. However, there is some question about whether the company is actually making any money on jobs for some customers—particularly those located on remote ranches that require considerable travel time. The owner’s daughter, home for the summer from college, has suggested investigating this question using activity-based costing. After some discussion, a simple system consisting of four activity cost pools seemed to be adequate. The activity cost pools and their activity measures appear below:

 

Activity Cost Pool Activity Measure Activity for the Year
Cleaning carpets Square feet cleaned (00s)   10,500   hundred square feet
Travel to jobs Miles driven   96,500   miles
Job support Number of jobs   1,700   jobs
Other (costs of idle capacity
and organization-sustaining costs)
None   Not applicable

 

 

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

       
Wages $ 144,000  
Cleaning supplies   35,000  
Cleaning equipment depreciation   14,000  
Vehicle expenses   36,000  
Office expenses   69,000  
President’s compensation   72,000  
Total cost $ 370,000  

 


Resource consumption is distributed across the activities as follows:


Distribution of Resource Consumption Across Activities  

 

  Cleaning Carpets Travel to Jobs Job Support Other Total
Wages   73 %     14 %     0 %     13 %       100 %
Cleaning supplies   100 %     0 %     0 %     0 %       100 %
Cleaning equipment depreciation   67 %     0 %     0 %     33 %       100 %
Vehicle expenses   0 %     82 %     0 %     18 %       100 %
Office expenses   0 %     0 %     64 %     36 %       100 %
President’s compensation   0 %     0 %     31 %     69 %       100 %

 

 


Job support consists of receiving calls from potential customers at the home office, scheduling
jobs, billing, resolving issues, and so on.


Required:

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

 
 
  Cleaning   Job    
  Carpets Travel to Jobs Support Other Total
Wages          
Cleaning supplies          
Cleaning equipment depreciation          
Vehicle expenses          
Office expenses          
President’s compensation          
Total cost          


 

2. Compute the activity rates for the activity cost pools. (Round your answers to 2 decimal places.)

 
 
Activity Cost Pool Activity Rate  
Cleaning carpets   per hundred square feet
Travel to jobs   per mile
Job support   per job

 
 

3. The company recently completed a 4 hundred square foot carpet-cleaning job at the Flying N ranch—a 56.00-mile round-trip journey from the company’s offices in Bozeman. Compute the cost of this job using the activity-based costing system. (Round your intermediate and final answers to 2 decimal places.)

 

 
 
Cost of the job  


 

4. The revenue from the Flying N ranch was $89.60 (4 hundred square feet at $22.40 per hundred square feet). Prepare a report showing the margin from this job. (Round your intermediate calculations and final answers to 2 decimal places.)

 
 
Gallatin Carpet Cleaning
Customer Margin—Activity-Based Costing
Amounts per Job
     
Costs:    
     
     
     
     
     
     

 

Expert Answer

1 Rating

Want to see the step-by-step answer?

See Answer

Check out a sample Q&A here.

Want to see this answer and more?

Experts are waiting 24/7 to provide step-by-step solutions in as fast as 30 minutes!*

See Answer
*Response times vary by subject and question complexity. Median response time is 34 minutes and may be longer for new subjects.
Tagged in
BusinessAccounting

Activity Based Costing

Related Accounting Q&A

Find answers to questions asked by student like you

Q: I am lost on this problem, I tried using the 'Show me how' video but I don't understand it at all. H...

A: Since we only answer upto 3 sub-parts, we'll answer the first 3. Please resubmit the question and sp...

Q: are the answers correct?

A: Standard input/output means the budgeted or planned input or output.Variances are computed as differ...

Q: The management of Oriole Company asks your help in determining the comparative effects of the FIFO a...

A: Inventory: Inventory refers to the entire stock of goods purchased, goods utilized and goods maintai...

Q: Which of the following constitute a tax and why? l  Payment for driver’s license?    l  Payment for ...

A:  Tax: It is an amount which is a compulsory contribution to government’s revenue and levied by the g...

Q: Required information   [The following information applies to the questions displayed below.]  Doyle ...

A: Accounting equation: Accounting equation is an accounting tool expressed in the form of equation, by...

Q: Hello, can you please help me with this question? Only part of the question fits in the screen snip ...

A: Process costing is a system in which production cost are allocated to individual production stages u...

Q: I am resubmitting this question as the answer to number two is incorrect from the guidance I was giv...

A: Calculate the sales value for each component.

Q: Comdex Inc. manufactures parts for the telecom industry. One of its products that currently sells fo...

A: Calculate the desire profit of Comdex Incorporation.

Q: Brief Exercise 21A-6 Metlock Company leased equipment from Costner Company, beginning on December 31...

A: Prepare jounal entry to record lease liability: