Activity-Based Costing in a Service Environment
Elite Lawn & Plowing (EL&P) is a lawn and snow plowing service with both residential and commercial clients. The owner believes that the commercial sector has more growth opportunities and is considering dropping the residential service.
Twenty employees worked a total of 20,000 hours last year, 13,000 on residential jobs and 7,000 on commercial jobs. Wages were $25 per hour for all work done. Any materials used are included in overhead as supplies. All overhead is allocated on the basis of labor-hours worked, which is also the basis for customer charges. Because of increased competition for commercial accounts, EL&P can charge $60 per hour for residential work, but only $45 per hour for commercial work.
Required
- a. If overhead for the year was $205,000, what were the profits of the residential and commercial services using labor-hours as the allocation base?
- b. Overhead consists of costs of traveling to the site, using equipment (including vehicle rental), and using supplies, which can be traced as follows:
Recalculate profits for commercial and residential services based on these activity bases.
- c. What recommendations do you have for management regarding the profitability of these two types of services?
Want to see the full answer?
Check out a sample textbook solutionChapter 9 Solutions
Fundamentals Of Cost Accounting (6th Edition)
- Functional-Based versus Activity-Based Costing For years, Tamarindo Company produced only one product: backpacks. Recently, Tamarindo added a line of duffel bags. With this addition, the company began assigning overhead costs by using departmental rates. (Prior to this, the company used a predetermined plantwide rate based on units produced.) Surprisingly, after the addition of the duffel-bag line and the switch to departmental rates, the costs to produce the backpacks increased, and their profitability dropped. Josie, the marketing manager, and Steve, the production manager, both complained about the increase in the production cost of backpacks. Josie was concerned because the increase in unit costs led to pressure to increase the unit price of backpacks. She was resisting this pressure because she was certain that the increase would harm the companys market share. Steve was receiving pressure to cut costs also, yet he was convinced that nothing different was being done in the way the backpacks were produced. After some discussion, the two managers decided that the problem had to be connected to the addition of the duffel-bag line. Upon investigation, they were informed that the only real change in product-costing procedures was in the way overhead costs are assigned. A two-stage procedure was now in use. First, overhead costs are assigned to the two producing departments, Patterns and Finishing. Second, the costs accumulated in the producing departments are assigned to the two products by using direct labor hours as a driver (the rate in each department is based on direct labor hours). The managers were assured that great care was taken to associate overhead costs with individual products. So that they could construct their own example of overhead cost assignment, the controller provided them with the information necessary to show how accounting costs are assigned to products: The controller remarked that the cost of operating the accounting department had doubled with the addition of the new product line. The increase came because of the need to process additional transactions, which had also doubled in number. During the first year of producing duffel bags, the company produced and sold 100,000 backpacks and 25,000 duffel bags. The 100,000 backpacks matched the prior years output for that product. Required: (Note: Round rates and unit cost to the nearest cent.) 1. CONCEPTUAL CONNECTION Compute the amount of accounting cost assigned to a backpack before the duffel-bag line was added by using a plantwide rate approach based on units produced. Is this assignment accurate? Explain. 2. Suppose that the company decided to assign the accounting costs directly to the product lines by using the number of transactions as the activity driver. What is the accounting cost per unit of backpacks? Per unit of duffel bags? 3. Compute the amount of accounting cost assigned to each backpack and duffel bag by using departmental rates based on direct labor hours. 4. CONCEPTUAL CONNECTION Which way of assigning overhead does the best jobthe functional-based approach by using departmental rates or the activity-based approach by using transactions processed for each product? Explain. Discuss the value of ABC before the duffel-bag line was added.arrow_forwardHandbrain Inc. is considering a change to activity-based product costing. The company produces two products, cell phones and tablet PCs, in a single production department. The production department is estimated to require 2,000 direct labor hours. The total indirect labor is budgeted to be 200,000. Time records from indirect labor employees revealed that they spent 30% of their time setting up production runs and 70% of their time supporting actual production. The following information about cell phones and tablet PCs was determined from the corporate records: a. Determine the indirect labor cost per unit allocated to cell phones and tablet PCs under a single plantwide factory overhead rate system using the direct labor hours as the allocation base. b. Determine the budgeted activity costs and activity rates for the indirect labor under activity-based costing. Assume two activitiesone for setup and the other for production support. c. Determine the activity cost per unit for indirect labor allocated to each product under activity-based costing. d. Why are the per-unit allocated costs in (a) different from the per-unit activity cost assigned to the products in (c)?arrow_forwardActivity-based costing and product cost distortion The management of Four Finger Appliance Company in Exercise 14 has asked you to use activity-based costing instead of direct labor hours to allocate factory overhead costs to the two products. You have determined that 81,000 of factory overhead from each of the production departments can be associated with setup activity (162,000 in total). Company records indicate that blenders required 135 setups, while the toaster ovens required only 45 setups. Each product has a production volume of 7,500 units. Determine the three activity rates (assembly, test and pack, and setup). Determine the total factory overhead and factory overhead per unit allocated to each product using the activity rates in (A).arrow_forward
- Hicks Contracting collects and analyzes cost data in order to track the cost of installing decks on new home construction jobs. The following are some of the costs that they incur. Classify these costs as fixed or variable costs and as product or period costs. Lumber used to construct decks ($12.00 per square foot) Carpenter labor used to construct decks ($10 per hour) Construction supervisor salary ($45,000 per year) Depreciation on tools and equipment ($6,000 per year) Selling and administrative expenses ($35,000 per year) Rent on corporate office space ($34,000 per year) Nails, glue, and other materials required to construct deck (varies per job)arrow_forwardMott Company recently implemented a JIT manufacturing system. After one year of operation, Heidi Burrows, president of the company, wanted to compare product cost under the JIT system with product cost under the old system. Motts two products are weed eaters and lawn edgers. The unit prime costs under the old system are as follows: Under the old manufacturing system, the company operated three service centers and two production departments. Overhead was applied using departmental overhead rates. The direct overhead costs associated with each department for the year preceding the installation of JIT are as follows: Under the old system, the overhead costs of the service departments were allocated directly to the producing departments and then to the products passing through them. (Both products passed through each producing department.) The overhead rate for the Machining Department was based on machine hours, and the overhead rate for assembly was based on direct labor hours. During the last year of operations for the old system, the Machining Department used 80,000 machine hours, and the Assembly Department used 20,000 direct labor hours. Each weed eater required 1.0 machine hour in Machining and 0.25 direct labor hour in Assembly. Each lawn edger required 2.0 machine hours in Machining and 0.5 hour in Assembly. Bases for allocation of the service costs are as follows: Upon implementing JIT, a manufacturing cell for each product was created to replace the departmental structure. Each cell occupied 40,000 square feet. Maintenance and materials handling were both decentralized to the cell level. Essentially, cell workers were trained to operate the machines in each cell, assemble the components, maintain the machines, and move the partially completed units from one point to the next within the cell. During the first year of the JIT system, the company produced and sold 20,000 weed eaters and 30,000 lawn edgers. This output was identical to that for the last year of operations under the old system. The following costs have been assigned to the manufacturing cells: Required: 1. Compute the unit cost for each product under the old manufacturing system. 2. Compute the unit cost for each product under the JIT system. 3. Which of the unit costs is more accurate? Explain. Include in your explanation a discussion of how the computational approaches differ. 4. Calculate the decrease in overhead costs under JIT, and provide some possible reasons that explain the decrease.arrow_forwardRoper Furniture manufactures office furniture and tracks cost data across their process. The following are some of the costs that they incur. Classify these costs as fixed or variable costs, and as product costs or period costs. Wood used to produce desks ($125,00 per desk) Production labor used to produce desks ($15 per hour) Production supervisor salary ($45,000 per year) Depreciation on factory equipment ($60,000 per year) Selling and administrative expenses ($45,000 per year) Rent on corporate office ($44,000 per year) Nails, glue, and other materials required to produce desks (varies per desk) Utilities expenses for production facility Sales staff commission (5% of gross sales)arrow_forward
- Ventana Window and Wall Treatments Company provides draperies, shades, and various window treatments. Ventana works with the customer to design the appropriate window treatment, places the order, and installs the finished product. Direct materials and direct labor costs are easy to trace to the jobs. Ventanas income statement for last year is as follows: Ventana wants to find a markup on cost of goods sold that will allow them to earn about the same amount of profit on each job as was earned last year. Required: 1. What is the markup on cost of goods sold (COGS) that will maintain the same profit as last year? (Round the percentage to two significant digits.) 2. A customer orders draperies and shades for a remodeling job. The job will have the following costs: What is the price that Ventana will quote given the markup percentage calculated in Requirement 1? (Round the price to the nearest dollar.) 3. What if Ventana wants to calculate a markup on direct materials cost, since it is the largest cost of doing business? What is the markup on direct materials cost that will maintain the same profit as last year? (Round the percentage to two significant digits.) What is the bid price Ventana will use for the job given in Requirement 2 if the markup percentage is calculated on the basis of direct materials cost? (Round to the nearest dollar.)arrow_forwardProduct costing and decision analysis for a service company Blue Star Airline provides passenger airline service, using small jets. The airline connects four major cities: Charlotte, Pittsburgh, Detroit, and San Francisco. The company expects to fly 170,000 miles during a month. The following costs are budgeted for a month: Blue Star management wishes to assign these costs to individual flights in order to gauge the profitability of its service offerings. The following activity bases were identified with the budgeted costs: The size of the companys ground operation in each city is determined by the size of the workforce. The following monthly data are available from corporate records for each terminal operation: Three recent representative flights have been selected for the profitability study. Their characteristics are as follows: Instructions Determine the fuel, crew, and depreciation cost per mile flown. Determine the cost per arrival or departure by terminal city. Use the information in (1) and (2) to construct a profitability report for the three flights. Each flight has a single arrival and departure to its origin and destination city pairs.arrow_forwardAdvent Software uses standards to manage the cost of the programming staff. There are two programmer levels, Level 1 and Level 2. Level 1 programmers normally work on the easier projects. Level 1 and Level 2 programmers are paid 25 and 35 per hour, respectively. It has been determined from experience that Level 2 programmers can complete 50 lines of code per hour. If a Level 1 programmer is assigned to a Level 2 task, the programming work will be slower than the Level 2 time standard, but will be accomplished at a lower labor rate. During a recent week, a Level 2 project was assigned to a Level 1 programmer. The programmer worked 40 hours and completed 1,400 lines of code. a. Determine the direct labor time variance for this worker. b. Determine the direct labor rate variance for this worker. c. Using the information in (a) and (b), is it more cost effective to use a Level 1 worker or a Level 2 worker on a Level 2 project?arrow_forward
- Cost Separation About 8 years ago, Kicker faced the problem of rapidly increasing costs associated with workplace accidents. The costs included the following: A safety program was implemented with the following features: hiring a safety director, new employee orientation, stretching required four times a day, and systematic monitoring of adherence to the program by directors and supervisors. A year later, the indicators were as follows: Required: 1. CONCEPTUAL CONNECTION Discuss the safety-related costs listed. Are they variable or fixed with respect to speakers sold? With respect to other independent variables (describe)? 2. CONCEPTUAL CONNECTION Did the safety program pay for itself? Discuss your reasoning.arrow_forwardStep Costs, Relevant Range Bellati Inc. produces large industrial machinery. Bellati has a machining department and a group of direct laborers called machinists. Each machinist can machine up to 500 units per year. Bellati also hires supervisors to develop machine specification plans and oversee production within the machining department. Given the planning and supervisory work, a supervisor can oversee, at most, three machinists. Bellatis accounting and production history shows the following relationships between number of units produced and the annual costs of supervision and materials handling (by machinists): Required: 1. Prepare a graph that illustrates the relationship between direct labor cost and number of units produced in the machining department. (Let cost of direct labor be the vertical axis and number of units be the horizontal axis.) Would you classify this cost as a strictly variable cost, a fixed cost, or a step cost? 2. Prepare a graph that illustrates the relationship between the cost of supervision and the number of units produced. (Let cost of supervision be the vertical axis and number of units be the horizontal axis.) Would you classify this cost as a strictly variable cost, a fixed cost, or a step cost? 3. Suppose that the normal range of production is between 1,400 and 1,500 units and that the exact number of machinists is currently hired to support this level of activity. Further suppose that production for the next year is expected to increase by an additional 500 units. What is the increase in the cost of direct labor? Cost of supervision?arrow_forwardProduction run size and activity improvement Littlejohn, Inc., manufactures machined parts for the automotive industry. The activity cost associated with Part XX-10 is as follows: Each unit requires 30 minutes of fabrication direct labor. Moreover, Part XX-10 is manufactured in production run sizes of 50 units. Each production run is set up, scheduled (production control), and moved as a batch of 50 units. Management is considering improvements in the setup, production control, and moving activities in order to cut the production run sizes by half. As a result, the number of setups, production runs, and moves will double from 10 to 20. Such improvements are expected to speed the companys ability to respond to customer orders. Setup is reengineered so that it takes 60% of the original cost per setup. Production control software will allow production control effort and cost per production run to decline by 60%. Moving distance was reduced by 40%, thus reducing the cost per move by the same amount. A. Determine the revised activity cost per unit under the proposed changes. B. Did these improvements reduce the activity cost per unit? C. What cost per unit for setup would be required for the solution in (a) to equal the base solution?arrow_forward
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning