Prepare first-stage allocation of cost to activity cost pool

Assignment Help Managerial Accounting
Reference no: EM132515170

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.10 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 351,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 $350,000 which includes the following costs:

Wages $ 140,000

Cleaning supplies 29,000

Cleaning equipment depreciation 7,000

Vehicle expenses 38,000

Office expenses 66,000

President's compensation 70,000

Total cost $ 350,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 68 % 0 % 0 % 32 % 100 %

Vehicle expenses 0 % 79 % 0 % 21 % 100 %

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

President's compensation 0 % 0 % 33 % 67 % 100 %

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

Required:

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 $88.40 (400 square feet @ $22.10 per hundred square feet). Calculate the customer margin earned on this job.

Reference no: EM132515170

Questions Cloud

How much were the company total expenses : Lewitas Ltd earned revenues of $35 million during 2018 and ended the year with income of $8 million. How much were the company total expenses
Compares a random sample of 16 birds near the construction : The biologist compares a random sample of 16 birds near the construction site to a random sample of 16 birds in an undisturbed location.
Analyze manner in which her action rose to level of homicide : From the e-Activity, give your opinion of Michelle Carter's conviction for urging her boyfriend to commit suicide, and analyze the manner in which her actions.
Study of the impact of smoking on birth weight : In a study of the impact of smoking on birth weight, researchers analyze birth weights (in grams) for babies born to 189 women who gave birth in 1989
Prepare first-stage allocation of cost to activity cost pool : The revenue from the Flying N Ranch was $88.40 (400 square feet @ $22.10 per hundred square feet). Calculate the customer margin earned on this job.
What is the carrying value of the bond at December : On January 1, 2018 ABC Corporation issued a five-year $1,000,000, 7%, at $1,050,000. What is the carrying value of the bond at December
What is the probability that the books will be numbered : What is the probability that the books will be numbered in the correct order from left to? right?
Define conceptualization and operationalization : Define conceptualization and operationalization. Identify the primary concept of your proposed study (i.e., the primary dependent variable), and provide both.
On the present value basis which alternative is preferable : Assuming that cost of money is the only factor in Carol's decision and that cost of money to her is 8%, On present value basis which alternative is preferable

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