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.35 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 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 133,500 miles Job support Number of jobs 1,800 jobs Other (organization-sustaining costs and idle capacity costs) None Not applicable The total cost of operating the company for the year is $341,000 which includes the following costs: Wages $ 136,000 Cleaning supplies 25,000 Cleaning equipment depreciation 6,000 Vehicle expenses 34,000 Office expenses 65,000 President’s compensation 75,000 Total cost $ 341,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 78 % 14 % 0 % 8 % 100 % Cleaning supplies 100 % 0 % 0 % 0 % 100 % Cleaning equipment depreciation 75 % 0 % 0 % 25 % 100 % Vehicle expenses 0 % 77 % 0 % 23 % 100 % Office expenses 0 % 0 % 56 % 44 % 100 % President’s compensation 0 % 0 % 26 % 74 % 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. 2. Compute the activity rates for the activity cost pools. 3. The company recently completed a 800 square foot carpet-cleaning job at the Flying N Ranch—a 56-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 $178.80 (800 square feet @ $22.35 per hundred square feet). Calculate the customer margin earned on this job.
In: Accounting
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 $23.15 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 below:
| Activity Cost Pool | Activity Measure | Activity for the Year | |
| Cleaning carpets | Square feet cleaned (00s) | 10,000 | hundred square feet |
| Travel to jobs | Miles driven | 228,000 | miles |
| Job support | Number of jobs | 1,700 | jobs |
| Other (organization-sustaining costs and idle capacity costs) | None | Not applicable | |
The total cost of operating the company for the year is $355,000 which includes the following costs:
| Wages | $ | 138,000 |
| Cleaning supplies | 27,000 | |
| Cleaning equipment depreciation | 12,000 | |
| Vehicle expenses | 36,000 | |
| Office expenses | 64,000 | |
| President’s compensation | 78,000 | |
| Total cost | $ | 355,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 | 74 | % | 15 | % | 0 | % | 11 | % | 100 | % |
| Cleaning supplies | 100 | % | 0 | % | 0 | % | 0 | % | 100 | % |
| Cleaning equipment depreciation | 67 | % | 0 | % | 0 | % | 33 | % | 100 | % |
| Vehicle expenses | 0 | % | 75 | % | 0 | % | 25 | % | 100 | % |
| Office expenses | 0 | % | 0 | % | 56 | % | 44 | % | 100 | % |
| President’s compensation | 0 | % | 0 | % | 32 | % | 68 | % | 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.
2. Compute the activity rates for the activity cost pools.
3. The company recently completed a 600 square foot carpet-cleaning job at the Flying N Ranch—a 52-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 $138.90 (600 square feet @ $23.15 per hundred square feet). Calculate the customer margin earned on this job.
In: Accounting
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.75 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 below:
| Activity Cost Pool | Activity Measure | Activity for the Year | |
| Cleaning carpets | Square feet cleaned (00s) | 13,500 | hundred square feet |
| Travel to jobs | Miles driven | 142,000 | miles |
| Job support | Number of jobs | 1,600 | jobs |
| Other (organization-sustaining costs and idle capacity costs) | None | Not applicable | |
The total cost of operating the company for the year is $361,000 which includes the following costs:
| Wages | $ | 137,000 |
| Cleaning supplies | 26,000 | |
| Cleaning equipment depreciation | 12,000 | |
| Vehicle expenses | 40,000 | |
| Office expenses | 68,000 | |
| President’s compensation | 78,000 | |
| Total cost | $ | 361,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 | 76 | % | 14 | % | 0 | % | 10 | % | 100 | % |
| Cleaning supplies | 100 | % | 0 | % | 0 | % | 0 | % | 100 | % |
| Cleaning equipment depreciation | 68 | % | 0 | % | 0 | % | 32 | % | 100 | % |
| Vehicle expenses | 0 | % | 79 | % | 0 | % | 21 | % | 100 | % |
| Office expenses | 0 | % | 0 | % | 56 | % | 44 | % | 100 | % |
| President’s compensation | 0 | % | 0 | % | 26 | % | 74 | % | 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.
2. Compute the activity rates for the activity cost pools.
3. The company recently completed a 600 square foot carpet-cleaning job at the Flying N Ranch—a 60-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 $136.50 (600 square feet @ $22.75 per hundred square feet). Calculate the customer margin earned on this job.
In: Accounting
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.30 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 below:
| Activity Cost Pool | Activity Measure | Activity for the Year | |
| Cleaning carpets | Square feet cleaned (00s) | 12,000 | hundred square feet |
| Travel to jobs | Miles driven | 256,000 | miles |
| Job support | Number of jobs | 1,800 | jobs |
| Other (organization-sustaining costs and idle capacity costs) | None | Not applicable | |
The total cost of operating the company for the year is $357,000 which includes the following costs:
| Wages | $ | 146,000 |
| Cleaning supplies | 22,000 | |
| Cleaning equipment depreciation | 19,000 | |
| Vehicle expenses | 33,000 | |
| Office expenses | 57,000 | |
| President’s compensation | 80,000 | |
| Total cost | $ | 357,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 | 74 | % | 16 | % | 0 | % | 10 | % | 100 | % |
| Cleaning supplies | 100 | % | 0 | % | 0 | % | 0 | % | 100 | % |
| Cleaning equipment depreciation | 68 | % | 0 | % | 0 | % | 32 | % | 100 | % |
| Vehicle expenses | 0 | % | 81 | % | 0 | % | 19 | % | 100 | % |
| Office expenses | 0 | % | 0 | % | 64 | % | 36 | % | 100 | % |
| President’s 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:
1. Prepare the first-stage allocation of costs to the activity cost pools.
2. Compute the activity rates for the activity cost pools.
3. The company recently completed a 800 square foot carpet-cleaning job at the Flying N Ranch—a 55-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 $178.40 (800 square feet @ $22.30 per hundred square feet). Calculate the customer margin earned on this job.
In: Accounting
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.45 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 below: Activity Cost Pool Activity Measure Activity for the Year Cleaning carpets Square feet cleaned (00s) 13,000 hundred square feet Travel to jobs Miles driven 143,500 miles Job support Number of jobs 1,700 jobs Other (organization-sustaining costs and idle capacity costs) None Not applicable The total cost of operating the company for the year is $346,000 which includes the following costs: Wages $ 143,000 Cleaning supplies 22,000 Cleaning equipment depreciation 14,000 Vehicle expenses 31,000 Office expenses 60,000 President’s compensation 76,000 Total cost $ 346,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 75 % 14 % 0 % 11 % 100 % Cleaning supplies 100 % 0 % 0 % 0 % 100 % Cleaning equipment depreciation 66 % 0 % 0 % 34 % 100 % Vehicle expenses 0 % 75 % 0 % 25 % 100 % Office expenses 0 % 0 % 65 % 35 % 100 % President’s compensation 0 % 0 % 26 % 74 % 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. 2. Compute the activity rates for the activity cost pools. 3. The company recently completed a 400 square foot carpet-cleaning job at the Flying N Ranch—a 58-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 $89.80 (400 square feet @ $22.45 per hundred square feet). Calculate the customer margin earned on this job.
In: Accounting
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 $23.75 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 below:
| Activity Cost Pool | Activity Measure | Activity for the Year | |
| Cleaning carpets | Square feet cleaned (00s) | 12,000 | hundred square feet |
| Travel to jobs | Miles driven | 193,000 | miles |
| Job support | Number of jobs | 2,100 | jobs |
| Other (organization-sustaining costs and idle capacity costs) | None | Not applicable | |
The total cost of operating the company for the year is $349,000 which includes the following costs:
| Wages | $ | 140,000 |
| Cleaning supplies | 32,000 | |
| Cleaning equipment depreciation | 9,000 | |
| Vehicle expenses | 32,000 | |
| Office expenses | 65,000 | |
| President’s compensation | 71,000 | |
| Total cost | $ | 349,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 | 80 | % | 13 | % | 0 | % | 7 | % | 100 | % |
| Cleaning supplies | 100 | % | 0 | % | 0 | % | 0 | % | 100 | % |
| Cleaning equipment depreciation | 66 | % | 0 | % | 0 | % | 34 | % | 100 | % |
| Vehicle expenses | 0 | % | 83 | % | 0 | % | 17 | % | 100 | % |
| Office expenses | 0 | % | 0 | % | 59 | % | 41 | % | 100 | % |
| President’s compensation | 0 | % | 0 | % | 26 | % | 74 | % | 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.
2. Compute the activity rates for the activity cost pools.
3. The company recently completed a 600 square foot carpet-cleaning job at the Flying N Ranch—a 54-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 $142.50 (600 square feet @ $23.75 per hundred square feet). Calculate the customer margin earned on this job.
In: Accounting
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.50 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 below:
| Activity Cost Pool | Activity Measure | Activity for the Year | |
| Cleaning carpets | Square feet cleaned (00s) | 11,500 | hundred square feet |
| Travel to jobs | Miles driven | 67,000 | miles |
| Job support | Number of jobs | 1,900 | jobs |
| Other (organization-sustaining costs and idle capacity costs) | None | Not applicable | |
The total cost of operating the company for the year is $366,000 which includes the following costs:
| Wages | $ | 142,000 |
| Cleaning supplies | 28,000 | |
| Cleaning equipment depreciation | 16,000 | |
| Vehicle expenses | 39,000 | |
| Office expenses | 63,000 | |
| President’s compensation | 78,000 | |
| Total cost | $ | 366,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 | 79 | % | 12 | % | 0 | % | 9 | % | 100 | % |
| Cleaning supplies | 100 | % | 0 | % | 0 | % | 0 | % | 100 | % |
| Cleaning equipment depreciation | 75 | % | 0 | % | 0 | % | 25 | % | 100 | % |
| Vehicle expenses | 0 | % | 84 | % | 0 | % | 16 | % | 100 | % |
| Office expenses | 0 | % | 0 | % | 60 | % | 40 | % | 100 | % |
| President’s compensation | 0 | % | 0 | % | 26 | % | 74 | % | 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.
2. Compute the activity rates for the activity cost pools.
3. The company recently completed a 600 square foot carpet-cleaning job at the Flying N Ranch—a 52-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 $135.00 (600 square feet @ $22.50 per hundred square feet). Calculate the customer margin earned on this job.
In: Accounting
3. What would be the result on your balance sheet of recording unearned revenue as revenue? a. Overstated income and overstated liabilities b. Understated revenue and understated assets c. Overstated income and understated liabilities d. Understated income and understated liabilities
In: Accounting
As part of an annual review of its accounts, a discount brokerage selects a random sample of 27 customers. Their accounts are reviewed for total account valuation, which showed a mean of $39,900, with a sample standard deviation of $8,300. (Use t Distribution Table.) What is a 99% confidence interval for the mean account valuation of the population of customers? (Round your answers to the nearest dollar amount.)
In: Statistics and Probability
Tesla, Inc. is an American automotive company that specializes in electric car manufacturing. The company and Elon Musk, it’s current CEO, has been an innovator in the United States automobile industry. Tesla has used technology as one of it’s driving factors. They provide online software updates and have open source technology, to an extent. Tesla’s production efficiency and sales have increased the last few years. During 2018 & 2019, they were able to achieve some quarters profitability.
Despite of these improvements, the company has had to deal with a number of challenges. Among them:
- Elon Musk is a dynamic leader; however, he is also
unpredictable. For example, in 2018 Musk reported that the company
may be going private. The statements were deemed to be misleading
for a publicly traded company. Musk and the company were fined a
total of $40 million dollars and Musk was not allowed to serve as
Director of the Tesla Board for at least three years.
- Although production has improved, it is still has not
met expectations. The company has had many issues which include,
assembly line issues, battery integration, and delivery logistics.
During this time, Musk has made statements regarding production
which has over promised to the market.
- Tesla had achieved quarterly profitability for some
quarters during 2018 and 2019. They had losses for years.
Obviously, this is a problem but not unusual for a manufacturing
company that takes a number of years to develop a market. The issue
is that with accumulating debt, the unpredictability of production
and costs have caused major concerns in the investor market
place.
Operating a company the size of Tesla is a major task. It takes many teams, with numbers of functions. Address the following questions as advice for the Tesla Board of Directors
1. The leader of the company, Elon Musk, has created
issues on his own for the company. What structure could be put in
place to minimize negative impacts?
2. Chapter 4 of the Group Dynamics for Teams text
addresses group cohesion and team roles. What concepts could be
utilized to improve the Board’s results?
3. Tesla was founded in 2003. What factors would you
consider to be critical when forming the initial board?
In: Operations Management