PROBLEM 7-20 Evaluating the Profitability of Services LO7-2, LO7-3, L07-4, L07-5 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 $28 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, she designed a simple system consisting of four activity cost pools. The activity cost pools and their activity measures appear in the pictures below: Job support consists of receiving calls from potential customers at the home office, scheduling jobs, billing, resolving issues, and so on. Required: 1.Using Exhibit 7-6 as a guide, prepare the first-stage allocation of costs to the activity cost pools. 2. Using Exhibit 7-7 as a guide, compute the activity rates for the activity cost pools. 3.  The company recently completed a 500 square foot carpet-cleaning job at the Flying N Ranch- a 75-mile round-trip journey from the company's offices in Bozeman. Compute the cost of this job using the activity-based costing system.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question
100%

PROBLEM 7-20 Evaluating the Profitability of Services LO7-2, LO7-3, L07-4, L07-5

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 $28 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, she designed a simple system consisting of four activity cost pools. The activity cost pools and their activity measures appear in the pictures below:

Job support consists of receiving calls from potential customers at the home office, scheduling
jobs, billing, resolving issues, and so on.
Required:
1.Using Exhibit 7-6 as a guide, prepare the first-stage allocation of costs to the activity cost
pools.
2. Using Exhibit 7-7 as a guide, compute the activity rates for the activity cost pools.
3.  The company recently completed a 500 square foot carpet-cleaning job at the Flying N
Ranch- a 75-mile round-trip journey from the company's offices in Bozeman. Compute the
cost of this job using the activity-based costing system.
4. The revenue from the Flying N Ranch was $140 (500 square feet @ $28 per hundred square
feet).Using Exhibit 7-12 as a guide, calculate the customer margin earned on this job.
5. What do you conclude concerning the profitability of the Flying N Ranch job? Explain.
6.What advice would you give the president concerning pricing jobs in the future?

Activity Measure
Activity for the Year
Activity Cost Pool
20,000 hundred square feet
60,000 miles
Square feet cleaned (00s)
Cleaning carpets
Travel to jobs....
Job support .. ..
Other (organization-sustaining
costs and idle capacity costs) ...
Miles driven
Number of jobs
2,000 jobs
None
Not applicable
The total cost of operating the company for the year is $430,000, which includes the following
costs:
Wages
$150,000
Cleaning supplies ....
Cleaning equipment depreciation
Vehicle expenses
40,000
20,000
80,000
Office expenses ...
Presidents compensation
60,000
80,000
Total cost ....
$430,000
Transcribed Image Text:Activity Measure Activity for the Year Activity Cost Pool 20,000 hundred square feet 60,000 miles Square feet cleaned (00s) Cleaning carpets Travel to jobs.... Job support .. .. Other (organization-sustaining costs and idle capacity costs) ... Miles driven Number of jobs 2,000 jobs None Not applicable The total cost of operating the company for the year is $430,000, which includes the following costs: Wages $150,000 Cleaning supplies .... Cleaning equipment depreciation Vehicle expenses 40,000 20,000 80,000 Office expenses ... Presidents compensation 60,000 80,000 Total cost .... $430,000
Resource consumption is distributed across the activities as follows:
Cleaning
Carpets
Travel to
Job
Jobs
Support
Other
Total
70%
20%
Wages
Cleaning supplies ...
Cleaning equipment depreciation ..
Vehicle expenses
0%
10%
100%
...
...
100%
0%
0%
0%
100%
80%
0%
0%
20%
100%
0%
60%
0%
40%
100%
Office expenses
0%
0%
45%
55%
100%
President's compensation
0%
0%
40%
60%
100%
Transcribed Image Text:Resource consumption is distributed across the activities as follows: Cleaning Carpets Travel to Job Jobs Support Other Total 70% 20% Wages Cleaning supplies ... Cleaning equipment depreciation .. Vehicle expenses 0% 10% 100% ... ... 100% 0% 0% 0% 100% 80% 0% 0% 20% 100% 0% 60% 0% 40% 100% Office expenses 0% 0% 45% 55% 100% President's compensation 0% 0% 40% 60% 100%
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 6 images

Blurred answer
Knowledge Booster
Cost management
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education