Calculate the customer margin earned on the job

Assignment Help Managerial Accounting
Reference no: EM132478711

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.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) 12,500 hundred square feet

Travel to jobs Miles driven 270,500 miles

Job support Number of jobs 1,700jobs

Other (organization-sustaining costs and idle capacity costs) None Not applicable

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

Wages                                               $150,000

Cleaning supplies                                    32,000

Cleaning equipment depreciation              14,000

Vehicle expenses                                  29,000

Office expenses                                   56,000

President's compensation                       78,000

Total cost                                           $359,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%                                    11% 0%                            10%                                          100%

Cleaning supplies 100% 0% 0% 0% 100%

Cleaning equipment depreciation 65% 0% 0% 35% 100%

Vehicle expenses 0% 78% 0% 22% 100%

Office expenses 0% 0% 64% 36% 100%

President's compensation 0% 0% 32% 68% 100%

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

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

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

Question 3. The company recently completed a 400 square foot carpet-cleaning job at the Flying N Ranch-a 51-mile round-trip journey from the company's offices in Bozeman. Compute the cost of this job using the activity-based costing system.

Question 4. The revenue from the Flying N Ranch was $93.40 (400 square feet @ $23.35 per hundred square feet). Calculate the customer margin earned on this job.

Reference no: EM132478711

Questions Cloud

What is a non-GAAP financial measure : What is a non-GAAP financial measure? Give an example of at least one non-GAAP financial measure and how it is calculated and how it is used
What was the rate of return on the investment : What was the rate of return on this investment? (Do not round intermediate calculations and enter your answer as a percentage rounded to 2 decimals places)
What the equity investment and the gain on revaluation : Assume that a parent company gains control over its subsidiary with the purchase of a 45% interest for $180,000. What the equity investment and the gain
How should cache handling be accomplished : How should cache handling be accomplished in order to minimize the ability of the attacker to deliver a payload through the cache?
Calculate the customer margin earned on the job : The revenue from the Flying N Ranch was $93.40 (400 square feet @ $23.35 per hundred square feet). Calculate the customer margin earned on this job
Difference in tools and personnel into a network environment : Discuss some of the differences in tools, techniques, skills and personnel that are needed between an intrusion into a network environment and a response to a.
What is the interest expense to be recognized for year two : The bond is issued for 90 percent of face value ($72,000) to yield an annual rate of 8 percent. What is the interest expense to be recognized for Year Two
How is monopolistic competition similar : How is monopolistic competition similar to each of the following market structures?
How cost of security controls implementation was justified : In 80 words or more give an example of a cost analysis conducted within your organization, and how the cost of security controls implementation was justified?

Reviews

Write a Review

Managerial Accounting Questions & Answers

  Manage budgets and financial plans

Explain the budgeting process and its importance to a business, identifying the components of different budgets, forecast estimates for inclusion in the budgets.

  Prepare a retained earnings statement

Prepare a retained earnings statement for the year and Prepare a stockholders' equity section of given case.

  Prepare a master budget for the three-month period

Prepare a master budget for the three-month period.

  Construct the companys direct labor budget

Construct the company's direct labor budget for the upcoming fiscal year, assuming that the direct labor workforce is adjusted each quarter to match the number of hours required to produce the forecasted number of units produced.

  Evaluate the predetermined overhead rate

Evaluate the Predetermined Overhead Rate

  Determine the company''s bid

Determine the company's bid if activity-based costing is used and the bid is based upon full manufacturing cost plus 30 percent.

  Compute the pool rates for the different activities

Complete the schedule to compute the pool rates for the different activities.

  Prepare Company financial statements

Prepare Company financial statements

  Prepare an analysis of terracycles

This individual assignment is based on the TerraCycle Inc.

  Discuss the ethical issues

Discuss the ethical issues

  Political resources in emerging markets

Calculate the GDP in Income Approach  and Expenditure Approach

  Management accounting - ehsan electronics company

A new plant accountant suggested that the company may be able to assign support costs to products more accurately by using an activity based costing system that relies on a separate rate for each manufacturing activity that causes support costs.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd